img

Three Statement Financial Modeling

Course Start Date: 23rd July

Training Duration: 5 Days

Practical application through exercises:

  • Excel Exercises 

Learning Outcomes

icon

Understand how to plan the model design and structure

icon

Forecast financial statements and key schedules

icon

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

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