Financial modelling is a
critical skill in financial analysis and valuation for professionals working in
corporate finance and investment. It is more than just number crunching. It
requires the ability to incorporate business and management strategies into the
models and translate the numbers into meaningful information for strategic
decisions and actions.
Learning Objectives
Delegates will learn:
How to construct financial
statements
How to perform scenario analysis
How to develop financial
models for evaluating investments and acquisitions, including private equity
deals
How to structure cash flows
waterfalls used in LBOs and MBOs
The common financial models
used by industry practitioners
How implementation of
business strategies impacts financial projections and valuation
How to build your own
templates and models using Excel
Program Outline
How to build a financial
model?
Ratio Analysis
Projecting the Income
Statement
Working Capital Schedule
Depreciation Schedule
Amortization Schedule
Completing the Income
Statement
Shareholder’s Equity
Schedule
Shares Outstanding Schedule
Completing the Cash Flow
Statements
Debt and Interest Schedule
Recommended
Target Audience:
Financial and investment
analysts, Project Managers, Investment bankers, Equity researchers, Commercial
bankers, Credit Analysts, CFA and other finance professionals. Fresh graduates
and new entrants to the investment and corporate finance industry.