Learn to build a rolling 12-month cash flow forecast model for financial planning and analysis (FP&A).
Description
CPA Members only
CPA Australia has partnered with the Corporate Finance Institute (CFI) to curate a collection of data and digital courses exclusively for CPA members. CFI courses have an emphasis on hands-on, practical learning and skills acquisition. They teach in-demand industry practices, tools and techniques that help accounting and finance professionals build confidence, stand out from the competition, and make a positive impact on their careers.
Master the art of building a rolling 12-month cash flow forecast model in our Financial Planning & Analysis FP&A course. In this monthly cash flow modelling course, you will learn to build an Excel model from scratch complete with assumptions, financials, supporting schedules and charts.
This FP&A 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.
CPA Australia handles your personal information in accordance with the CPA Australia Privacy Policy. By proceeding you may be redirected to an external website to access the course.
Our Privacy Policy includes the following statement under the subsection 'Links to external websites':
• We may provide links to websites operated by third parties.
• We are not responsible for the privacy practices or the content of such websites which will be governed by their own privacy policies to which you are advised to refer.
• Your satisfactory completion of the course may be recorded in your CPD Diary.
CFI programs will be supplied to CPA Australia members as standalone courses for 12 months from the date of purchase and as such, any associated CFI certifications are not able to be supplied. Refunds or extensions for purchases of CFI courses will only be available in exceptional circumstances and will be based on CPA Australia and CFI’s cancellation terms.
Learning objectives
- 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
- Explain how to forecast the financial statements based on the business plan
- Calculate the monthly cash flow
- Analyse the impact of the forecast on the company’s balance sheet and capitalisation
- Output relevant graphs to illustrate the cash flow profile to management
Audience
This monthly cash flow modelling course is critical 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.
