FP & A Monthly Cash Flow Forecast

FP & A Monthly Cash Flow Forecast
Corporate Finance Institute (CFI) on-demand courses are designed for finance professionals and industry practitioners who want to master the art of corporate finance. The courses move through three levels of mastery for anyone looking to be an expert in financial modeling, valuation, and financial analysis. Participants typically include professionals in entry to mid-level positions in financial planning and analysis (FP&A), corporate development, treasury, investor relations, and capital markets. All participants are automatically issued certificates of completion after successfully finishing each course.

NOTE: Course login details are normally sent to registrants within one week from date of registration.

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

We 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 on the business, decide if capital needs to be raised, evaluate credit metrics, and create elegant charts to inform management.

 • Apply a structured approach to monthly cash flow modeling in Excel
 • Build up the assumptions and formulas required to forecast the business
 • 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 

CPD- 4 Hours
4/1/2022 - 3/31/2023 11:59 PM