Call us at:- +91-9958934646
Go

Create a free profile as



international-students
Financial-Modeling-Using-Ex.jpg

Financial Modelling Using Excel

Indian : Rs.14500
International : $169
INTRODUCTION
Gain an indepth understanding of Financial Modelling techniques like Forecasting Financial Statements,Company Valuation and Analyzing M&A transactions
PROGRAM HIGHLIGHTS
  • Master Basic and Advanced concepts in MS Excel
  • Forecasting Financial Statements
  • Valuation techniques and M&A Analysis
COURSE OUTCOME
  • Analyze historical financial statement and evaluate the current value of an entity
  • Efficiently forecast Profit & Loss, Balance Sheet and Cash Flow statements
  • Learn to build a Project Finance Model
  • Analyse Mergers and Acquisitions (M&A)
  • Perform a Discounted Cash Flow (DCF) and Relative Valuation
CONTENT
Excel- Basics & Advanced
  • Basic Shortcuts & formulas in Excel (sumif, sumifs, nested if, vlookup, hlookup and many more)
  • Advanced formulas -Named Ranges, Index Match, Array Functions, Building Scenarios using Offset Functions, Index functions, Usage of Indirect Functions, Usage of Goal Seek and Solver Function
  • Array Functions
  • Pivot tables

Charts
  • Creating and formatting Basic Charts in Excel
  • Charting with two axis and chart type
  • Bubble Charts
  • Creating a Dynamic Range Chart
  • Creating Radar/Spider Charts
  • Creating Waterfall Charts
  • Creating a Football Field Chart
  • Creating Gantt Chart

Financial Statement Analysis
  • Building a financial model template
  • Gathering and organising the historical data
  • Understanding the Income Statement, Balance Sheet and Cash Flow statement of a company
  • Calculating Financial ratios

Forecasting Financial Statements
  • Understanding the Business Model Identifying key Revenue & Cost Drivers
  • Forecasting the drivers
  • Preparing Balance Sheet schedules
  • Forecasting Profit & Loss Statement
  • Forecasting Balance Sheet
  • Linking the Cash Flow Statement
  • Ratio Analysis

DCF Modelling
  • Calculating Cost of Capital [Weighted Average Cost of Capital (WACC), Capital Asset Pricing Model (CAPM)]
  • Discounted Cash Flow (DCF) Model Free Cash Flow to Firm (FCFF) v/s Free Cash Flow To Equity (FCFE) model
  • Relative Valuation
  • Performing Sensitivity / Scenario Analysis

Project Finance
  • Understanding Project Finance
  • Building the Project Finance Model

M&A Analysis
  • What is Mergers & Acquisitions (M&A) and why do companies need M&A
  • Payment Methods in M&A
  • Types of offer
  • Key Inputs into an M&A Analysis
  • Understanding & analysing accretion & dilution
  • Analysing the impact of different financing plans
  • Analysing the impact of different ownership structures
  • Analysing the impact of Transaction Price and Financing Structure through Sensitivity Analysis
  • Performing Contribution Analysis
  • Valuing a transaction
  • Valuation Analysis with different methods of valuation

Case Study (Application of everything done so far)
  • Analysing a Company
  • Gathering Historical Data
  • Building Business Model and revenue drivers
  • Calculating WACC (Weighted Average Cost of Capital) Cost of Equity, Terminal Value
  • Arriving at the value of a Company using DCF and Relative valuation
  • Doing a sensitivity analysis of your assumptions
BENEFITS
  • Learn Financial Modelling for valuation of a company and determining whether it is undervalued or overvalued.
  • Course covers financial modelling for specific sectors such as Real Estate and Banking.
  • Learn different methods such as Discounted Cash Flow/ Dividend Discount Model/Relative Valuation etc.
  • Building Financial Projections to help companies to plan their output and predict their performance.
WHO SHOULD ATTEND
  • MBAs, CFAs, CAs, FRMs, B-Tech and Commerce Graduates and students
  • Candidates looking to make career in equity research, valuation, private equity funds, investment banking or commercial banking, project management etc
Frequently Asked Questions


logoprolearnmani.png

Manipal ProLearn

Manipal ProLearn, a part of Manipal Global Education Services, offers a variety of professional certification programs across IT, Management and Finance domains. Carrying forward the Manipal legacy of over six decades in education, we help working professionals and students enhance their skills and fast-track their careers.
  • 25,000+ Professionals Trained
  • 15+ Global Knowledge Partners
  • 100 Professionally Certified Courses
  • 500 Classroom Batches
Manipal ProLearn has redefined learning in the professional certification program space with a wide range of course options, expert faculty and an award winning learning platform. Benchmarked against global certification standards of PMI, CIMA, PMBOK etc., our course content is designed and developed by industry experts.

Not only are these certification courses good for skill enhancement, but with industry recognized certification, they are also a great value add to one's resume. Over the last two years, more than 23,000 learners have advanced their careers with the aid of our courses.

Hot Courses

Our Partners