Corporate Financial Modelling Building Forecasts and Cash Flows

Course Info

Date: Jan-24-2023

Length: 1 Week

City: Madrid

Fees: 4,300

Type: In Classroom

Available Dates

  • June-27-2022

    Madrid

  • July-11-2022

    Madrid

  • Aug-22-2022

    Madrid

  • Sep-19-2022

    Madrid

  • Oct-17-2022

    Madrid

  • Oct-31-2022

    Madrid

  • Nov-14-2022

    Madrid

  • Nov-28-2022

    Madrid

  • Dec-05-2022

    Madrid

  • Dec-19-2022

    Madrid

  • Dec-27-2022

    Madrid

  • Jan-24-2023

    Madrid

  • Feb-28-2023

    Madrid

  • Mar-28-2023

    Madrid

  • Apr-25-2023

    Madrid

  • May-02-2023

    Madrid

Dates in Other Venues

  • May-23-2022

    Dubai

  • May-30-2022

    Dubai

  • May-30-2022

    Zurich

  • May-30-2022

    Bangkok

  • June-06-2022

    Dubai

  • June-13-2022

    London

  • June-13-2022

    Zurich

  • June-13-2022

    Bangkok

  • June-20-2022

    Paris

  • June-20-2022

    Barcelona

  • June-27-2022

    Kuala Lumpur

  • June-27-2022

    Istanbul

  • June-27-2022

    Dubai

  • June-27-2022

    Amsterdam

  • July-04-2022

    Paris

  • July-04-2022

    Dubai

  • July-04-2022

    Barcelona

  • July-11-2022

    London

  • July-11-2022

    Kuala Lumpur

  • July-18-2022

    Istanbul

  • July-18-2022

    Amsterdam

  • July-25-2022

    Dubai

  • July-25-2022

    Zurich

  • July-25-2022

    Bangkok

  • Aug-08-2022

    Dubai

  • Aug-08-2022

    Zurich

  • Aug-15-2022

    London

  • Aug-15-2022

    Amsterdam

  • Aug-22-2022

    Kuala Lumpur

  • Aug-22-2022

    Bangkok

  • Aug-29-2022

    Istanbul

  • Aug-29-2022

    Paris

  • Aug-29-2022

    Dubai

  • Aug-29-2022

    Barcelona

  • Sep-05-2022

    Kuala Lumpur

  • Sep-05-2022

    Dubai

  • Sep-05-2022

    Bangkok

  • Sep-12-2022

    London

  • Sep-12-2022

    Istanbul

  • Sep-12-2022

    Paris

  • Sep-12-2022

    Zurich

  • Sep-12-2022

    Barcelona

  • Sep-26-2022

    Dubai

  • Sep-26-2022

    Amsterdam

  • Oct-03-2022

    Istanbul

  • Oct-03-2022

    London

  • Oct-03-2022

    Dubai

  • Oct-03-2022

    Zurich

  • Oct-10-2022

    Kuala Lumpur

  • Oct-10-2022

    Paris

  • Oct-10-2022

    Barcelona

  • Oct-17-2022

    Zurich

  • Oct-17-2022

    Amsterdam

  • Oct-17-2022

    Bangkok

  • Oct-24-2022

    Istanbul

  • Oct-24-2022

    London

  • Oct-31-2022

    Kuala Lumpur

  • Oct-31-2022

    Paris

  • Oct-31-2022

    Dubai

  • Oct-31-2022

    Amsterdam

  • Oct-31-2022

    Bangkok

  • Oct-31-2022

    Barcelona

  • Nov-07-2022

    Kuala Lumpur

  • Nov-07-2022

    Paris

  • Nov-07-2022

    Dubai

  • Nov-07-2022

    Amsterdam

  • Nov-07-2022

    Barcelona

  • Nov-14-2022

    Istanbul

  • Nov-14-2022

    London

  • Nov-14-2022

    Zurich

  • Nov-14-2022

    Bangkok

  • Nov-21-2022

    Kuala Lumpur

  • Nov-21-2022

    Paris

  • Nov-21-2022

    Amsterdam

  • Nov-21-2022

    Barcelona

  • Nov-28-2022

    Istanbul

  • Nov-28-2022

    London

  • Nov-28-2022

    Dubai

  • Nov-28-2022

    Zurich

  • Nov-28-2022

    Bangkok

  • Dec-05-2022

    Istanbul

  • Dec-05-2022

    London

  • Dec-05-2022

    Dubai

  • Dec-05-2022

    Zurich

  • Dec-05-2022

    Bangkok

  • Dec-12-2022

    Kuala Lumpur

  • Dec-12-2022

    Paris

  • Dec-12-2022

    Amsterdam

  • Dec-12-2022

    Barcelona

  • Dec-19-2022

    Istanbul

  • Dec-19-2022

    London

  • Dec-20-2022

    Paris

  • Dec-20-2022

    London

  • Dec-20-2022

    Kuala Lumpur

  • Dec-20-2022

    Zurich

  • Dec-20-2022

    Amsterdam

  • Dec-20-2022

    Bangkok

  • Dec-20-2022

    Barcelona

  • Dec-26-2022

    Kuala Lumpur

  • Dec-26-2022

    Paris

  • Dec-26-2022

    Dubai

  • Dec-26-2022

    Zurich

  • Dec-26-2022

    Amsterdam

  • Dec-26-2022

    Bangkok

  • Dec-26-2022

    Barcelona

  • Dec-27-2022

    Istanbul

  • Dec-27-2022

    Dubai

  • Dec-27-2022

    Amsterdam

  • Jan-03-2023

    Kuala Lumpur

  • Jan-03-2023

    London

  • Jan-03-2023

    Dubai

  • Jan-10-2023

    Istanbul

  • Jan-17-2023

    Paris

  • Jan-17-2023

    Zurich

  • Jan-17-2023

    Amsterdam

  • Jan-17-2023

    Bangkok

  • Jan-17-2023

    Barcelona

  • Jan-31-2023

    Dubai

  • Feb-07-2023

    Kuala Lumpur

  • Feb-07-2023

    London

  • Feb-07-2023

    Dubai

  • Feb-14-2023

    Istanbul

  • Feb-21-2023

    Paris

  • Feb-21-2023

    Zurich

  • Feb-21-2023

    Amsterdam

  • Feb-21-2023

    Bangkok

  • Feb-21-2023

    Barcelona

  • Feb-28-2023

    Dubai

  • Mar-07-2023

    Kuala Lumpur

  • Mar-07-2023

    London

  • Mar-07-2023

    Dubai

  • Mar-14-2023

    Istanbul

  • Mar-21-2023

    Paris

  • Mar-21-2023

    Zurich

  • Mar-21-2023

    Amsterdam

  • Mar-21-2023

    Bangkok

  • Mar-21-2023

    Barcelona

  • Mar-28-2023

    Dubai

  • Apr-04-2023

    Kuala Lumpur

  • Apr-04-2023

    London

  • Apr-04-2023

    Dubai

  • Apr-11-2023

    Istanbul

  • Apr-18-2023

    Paris

  • Apr-18-2023

    Zurich

  • Apr-18-2023

    Bangkok

  • Apr-18-2023

    Amsterdam

  • Apr-18-2023

    Barcelona

  • Apr-25-2023

    Dubai

  • May-02-2023

    Kuala Lumpur

  • May-02-2023

    Istanbul

  • May-02-2023

    Dubai

  • May-02-2023

    Amsterdam

  • May-09-2023

    Paris

  • May-09-2023

    London

  • May-09-2023

    Barcelona

Course Details

Course Outline

5 days course

 

Forecasting
 
  • 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?

 

Ratios

 

  • 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?

Course Video