FP & A Montly Cash Flow Forecast (CF)

OBJECTIVE:
Master the art of building a rolling 12-month cash flow forecast model in the Financial Planning & Analysis (FP&A) course. In the course, participants will learn to build a cash flow model from scratch complete with assumptions, financials, supporting schedules and charts.

The course looks at how to forecast revenues, operating expenses and changes in balance sheet items to arrive at monthly cash flow. From there, participants assess the financial impact on the business, decide if capital needs to be raised, evaluate credit metrics, and create elegant charts to inform management.

WHO WILL BENEFIT:
Finance professionals and industry practitioners who want to master the art of corporate finance. Participants typically include professionals in entry to mid-level positions in financial planning & analysis (FP&A), corporate development, treasury, investor relations, and capital markets.

LEARNING OUTCOMES:
Participants will learn to:

  1. Apply a structured approach to monthly cash flow modeling in Excel
  2. Build up the assumptions and formulas required to forecast the business
  3. Understand how to forecast the financial statements based on the business plan
  4. Calculate the monthly cash flow
  5. Analyze the impact of the forecast on the company’s balance sheet and capitalization
  6. Output relevant graphs to illustrate the cash flow profile to management

Course Code:  CF2021
CPD:  Estimated CPD Hours: Total - 4
Competency:  Finance
Course Level:  Intermediate
When
4/20/2020 - 3/31/2021
Where
On Demand
Canada

Program


Monday, 20 April 2020

 
Time
4/20/2020 - 3/31/2021
4/20/2020

Sign In