Course description
Master the art of building a rolling 12-month cash flow forecast model in our Financial Planning & Analysis FP&A class. In this monthly cash flow modeling course, you will learn to build an Excel model from scratch Complete with assumptions, financials, supporting schedules and charts.
Financial Planning and Analysis: Monthly Cash Flow Forecast Modelling training course will look at how to forecast revenues, operating expenses and changes in balance sheet items to arrive at monthly cash flow.
From there we will assess the financial impact of the forecast on the business, decide if capital needs to be raised, evaluate credit metrics, and create elegant charts to inform management and make executive decisions.
Upcoming start dates
Upcoming start dates
Suitability - Who should attend?
Financial Planning and Analysis: Monthly Cash Flow Forecast Modelling training course, is ideal for :
- Anyone working in Financial Planning & Analysis (FP&A), accounting, or finance departments and is required to build monthly financial models in their job. Career paths may include accounting, finance, treasury, and corporate development.
Outcome / Qualification etc.
At the end of the Financial Planning and Analysis: Monthly Cash Flow Forecast Modelling training course, you will be able to:
- Apply a structured approach to monthly cash flow modelling in Excel
- Build up the assumptions and formulas required to forecast the business month by month
- Understand how to forecast the financial statements based on the business plan
- Calculate the monthly cash flow
- Analyze the impact of the forecast on the company’s balance sheet and capitalization
- Output relevant graphs to illustrate the cash flow profile to management
Training Course Content
Day 1
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
Day 2
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
Day 3
Modeling Cash Flows (Review)
- Key learning objectives
- Operating cash flow
- Investing cash flow
- Financing cash flow & circular references
Day 4
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
Day 5
Enhancing Your Model
- Key learning objectives
- Conditional formatting
- Data validation
- Protecting the worksheet
- Auditing the model
- Charts and graphs
- Interactive exercise 2
Request info
London Premier Centre
London Premier Centre is a UK leading training provider based in London and specialises in international short courses. Our inspiring, comprehensive portfolio of more than 400 professional development courses and seminars covers a wide range of professions from Administration, Leadership,...