Dates and location
Hours
Dates and location
Hours
Description
This course is essential for finance professionals seeking to master cash flow forecasting, a critical skill for effective financial analysis. By accurately predicting cash flow, businesses can ensure liquidity, optimize financial performance, and make informed strategic decisions. In this course, you will learn to build a rolling 12-month cash flow forecast model in Excel from scratch, incorporating key assumptions, financial statements, and supporting schedules.
You will also gain expertise in forecasting revenues, operating expenses, and balance sheet changes, calculating monthly cash flow, and evaluating its impact on the company’s financial health. Additionally, the course covers how to create informative charts to visualize the cash flow profile, aiding management in decision-making. This comprehensive approach equips you with the skills to manage cash flow effectively and contribute to the financial stability and growth of your organization.
Topics Include:
- Financial Modelling Best Practices
- Review of Modelling Cash Flows
- Building Your Financial Model in Excel
- Enhancing Your Model
Key Takeaways
Upon completing this 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.
Who Will Benefit
This course is designed for finance professionals, analysts, and aspiring FP&A specialists seeking to enhance their skills in financial modelling and cash flow forecasting to advance their careers in corporate finance, financial planning, and strategic management.
Prerequisite(s)
Before taking this course, participants should have a foundational understanding of:
- Accounting Fundamentals
- 3-Statement Modelling
- Excel
- Financial Modelling
How to Access the Course
To access the course on your computer please visit our BlackBoard site, and log-in using the same login and password used for the Registration Portal.
Please allow up to 15 minutes after registration for the course to appear on your BlackBoard page.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
Tim Vipond is the Chair of the Board of CFI Education. He has extensive experience as an internet entrepreneur in financial analysis and investment banking. Beginning in 2005, Tim was an active participant in the capital markets with a wide range of experience spanning investment banking, investment management, and corporate development.