Address
3, Allen Lane, Capable People Africa Building, Allen Lane, Ikeja, Lagos State. View mapCategories
Financial ModellingFinancial 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.