Financial Planning and Analysis: Monthly Cash Flow Forecast Modelling

Course Info

Length: 1 Week

City: London

Type: In Classroom

Available Dates

  • Apr-08-2024

    London

  • May-13-2024

    London

  • June-10-2024

    London

  • July-08-2024

    London

  • Aug-12-2024

    London

  • Sep-09-2024

    London

  • Oct-14-2024

    London

  • Nov-11-2024

    London

  • Dec-09-2024

    London

Dates in Other Venues

  • Apr-01-2024

    Dubai

  • Apr-01-2024

    Barcelona

  • Apr-08-2024

    Amsterdam

  • Apr-15-2024

    Kuala Lumpur

  • Apr-15-2024

    Istanbul

  • Apr-22-2024

    Singapore

  • Apr-22-2024

    Barcelona

  • Apr-29-2024

    Paris

  • Apr-29-2024

    Dubai

  • May-06-2024

    Barcelona

  • May-06-2024

    Dubai

  • May-13-2024

    Amsterdam

  • May-20-2024

    Kuala Lumpur

  • May-20-2024

    Istanbul

  • May-27-2024

    Singapore

  • May-27-2024

    Paris

  • June-03-2024

    Dubai

  • June-03-2024

    Barcelona

  • June-10-2024

    Amsterdam

  • June-17-2024

    Kuala Lumpur

  • June-17-2024

    Istanbul

  • June-24-2024

    Paris

  • June-24-2024

    Singapore

  • July-01-2024

    Dubai

  • July-01-2024

    Barcelona

  • July-08-2024

    Amsterdam

  • July-15-2024

    Istanbul

  • July-15-2024

    Kuala Lumpur

  • July-22-2024

    Barcelona

  • July-22-2024

    Singapore

  • July-29-2024

    Dubai

  • July-29-2024

    Paris

  • Aug-05-2024

    Barcelona

  • Aug-05-2024

    Dubai

  • Aug-12-2024

    Amsterdam

  • Aug-19-2024

    Kuala Lumpur

  • Aug-19-2024

    Istanbul

  • Aug-26-2024

    Singapore

  • Aug-26-2024

    Paris

  • Sep-02-2024

    Barcelona

  • Sep-02-2024

    Dubai

  • Sep-09-2024

    Amsterdam

  • Sep-16-2024

    Istanbul

  • Sep-16-2024

    Kuala Lumpur

  • Sep-23-2024

    Barcelona

  • Sep-23-2024

    Singapore

  • Sep-30-2024

    Dubai

  • Sep-30-2024

    Paris

  • Oct-07-2024

    Dubai

  • Oct-07-2024

    Barcelona

  • Oct-14-2024

    Amsterdam

  • Oct-21-2024

    Kuala Lumpur

  • Oct-21-2024

    Istanbul

  • Oct-28-2024

    Paris

  • Oct-28-2024

    Singapore

  • Nov-04-2024

    Dubai

  • Nov-04-2024

    Barcelona

  • Nov-11-2024

    Amsterdam

  • Nov-18-2024

    Kuala Lumpur

  • Nov-18-2024

    Istanbul

  • Nov-25-2024

    Paris

  • Nov-25-2024

    Singapore

  • Dec-02-2024

    Dubai

  • Dec-02-2024

    Barcelona

  • Dec-09-2024

    Amsterdam

  • Dec-16-2024

    Istanbul

  • Dec-16-2024

    Kuala Lumpur

  • Dec-23-2024

    Singapore

  • Dec-23-2024

    Barcelona

  • Dec-30-2024

    Dubai

  • Dec-30-2024

    Paris

Course Details

Course Outline

5 days course

 

Introduction to Financial Analysis
 
  • Financial Economic Decision-Making: The challenge

  • Financial/economic analysis practice

  • Understanding the value-creating company

  • Shareholder and corporate value

  • Business: A dynamic perspective

  • Corporate governance and the agency problem

  • Description: What information and data to use?

  • Financial statements: Nature

  • Financial analysis and decision-making: Context

 

 

Financial Modeling Best Practices
 
  • Robust rolling forecast models

  • Inputs and assumptions

  • Processing and formulas

  • Outputs and graphs

  • Modeling best practices and tradeoffs

  • Interactive exercise 1

 

Modeling Cash Flows (Review)
 
  • Key learning objectives

  • Operating cash flow

  • Investing cash flow

  • Financing cash flow & circular references

 

Building Your Financial Model in Excel
 
  • Overview of the modeling process

  • Time periods

  • Historical assumptions and drivers

  • Forecast assumptions and drivers

  • Income statement: revenue to EBITDA

  • Balance sheet: AR, inventory & AP

  • Supporting schedules: PP&E

  • Supporting schedules: debt schedule

  • Completing the income statement and balance sheet

  • Cash flow statement and cash balance

 

Enhancing Your Model
 
  • Key learning objectives

  • Conditional formatting

  • Data validation

  • Protecting the worksheet

  • Auditing the model

  • Charts and graphs

  • Interactive exercise 2

Course Video