KPME Three Statement Financial Modeling
Three Statement Financial Modeling
Course Start Date: 23rd July
Training Duration: 5 Days
Practical application through exercises:
- Excel ExercisesÂ
Learning Outcomes
Understand how to plan the model design and structure
Forecast financial statements and key schedules
Develop consistent and review friendly models using global best practices
Create Model KPI/Output sheet - Key Financial Ratios and perform Scenario and Sensitivity Analysis
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