KPME Three Statement Financial Modeling
![img](https://kaplanprofessionalme.com/wp-content/uploads/2023/01/finance-2022-11-15-15-24-59-utc.jpg)
Three Statement Financial Modeling
Course Start Date: 23rd July
Training Duration: 5 Days
Practical application through exercises:
- Excel ExercisesÂ
Learning Outcomes
![icon](https://kaplanprofessionalme.com/wp-content/uploads/2021/10/icon-degree.png)
Understand how to plan the model design and structure
![icon](https://kaplanprofessionalme.com/wp-content/uploads/2021/10/icon-recognized.png)
Forecast financial statements and key schedules
![icon](https://kaplanprofessionalme.com/wp-content/uploads/2021/08/icon01.png)
Develop consistent and review friendly models using global best practices
Create Model KPI/Output sheet - Key Financial Ratios and perform Scenario and Sensitivity Analysis
![icon](https://kaplanprofessionalme.com/wp-content/uploads/2021/08/icon02.png)
Create a model dashboard for management presentation
Course Outlines
- Overview of Financial Modelling
- Key Excel tools used in financial modelling (Logical & Date functions, Data Tables, Index & Match, Choose, etc.)
- Best Practices in Financial Modelling (FAST Standards, SMART, etc.)
- Model design and structure for the case study company
- Know the key model outputs and their drivers
- Understand the requisite inputs
- Developing cell styles for model transparency and review
- Extracting, cleaning and normalizing historical financial statements from annual reports
- Building error checks in the model
- Revenue modelling or different types of industries
- Forecasting key operating expenses and margins
- Projecting key schedules: debt & interest, capex & depreciation and working capital , etc.
- Stepwise projection of income statement, balance sheet and cash flows
- Integrating the three financial statements
- Create Model KPI/Output sheet – Financial Ratios – Profitability, Liquidity, Solvency and Activity
- Performing sensitivity analysis using data tables
- Scenario analysis
- Presenting model KPIs in dashboard
- Developing the model from scratch for a large regional public company