Corporate Financial Modelling: Building Forecasts and Cash Flows


Using a real life Excel example, this course takes you through a process where you can learn how to develop forecasts and perform financial analysis

This course is provided by a third party provider and the fee charged is exclusive of VAT

Venue details:  
Online EU, ,
Start date & time:  
01 January 2021 00:00
End date & time:  
01 January 2022 00:00
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
3.50 Training Tickets accepted
CPD hours:  
Speaker details
No speakers have been associated with this event.


Product type:  
CPD online course
Category:, Technology and data


  • What are the forecasting basics?
  • What causes forecasting errors?
  • What types of charts should we use?
  • How do we review forecasts?
  • How can we appraise accuracy?
  • How do we analyse data in Excel?

Forecasting methods

  • How can we identify patterns?
  • What is the simple percentage plus method?
  • How do we use compound annual growth rate?
  • How are trends useful?
  • What is smoothing?
  • How do we look at seasons?
  • How do we use regression?
  • What is the inflation problem?


  • What factors can affect cash flow?
  • What are the core ratios?
  • What are the profitability ratios?
  • What ratios measure operating efficiency?
  • What ratios can help with financial structure?
  • Is growth sustainable?
  • What are the market ratios?
  • What error functions and units should be considered?
  • What checks are required?

Forecast drivers

  • What assumptions can we make?
  • How do we generate the income statement?
  • How are balance sheet assets generated?
  • What about balance sheet liabilities?
  • Why are the workings sheets important?
  • How do we deal with divisions?

Accounting statements

  • What is the structure of the balance sheet?
  • How do we model the income statement?
  • How do we model the balance sheet?
  • What are the mechanics of cash flow?
  • What are the cash flow ratios?
  • Can we avoid common mistakes?
  • How should we deal with iteration?
  • What further checks are needed?