• Home
  • eLearning
  • Corporate Financial Modelling: Building Forecasts and Cash Flows - eLearning

Corporate Financial Modelling: Building Forecasts and Cash Flows - eLearning

This activity is published by accountingcpd.

All year round, and on every accountingcpd purchase you make, get 10% off  as a CA ANZ member. Just use code CAANZ101.

Please note you will be directed to accountingcpd to purchase this product.

Financial modelling is key to every business. Financial models can inform budgeting, forecasting, investment analysis, cash flows, loan sizing, valuation – the list is endless. If your financial models aren't right, your business is going to make bad decisions.

Using a real life Excel example, this course takes you through a process where you can learn how to develop forecasts and perform financial analysis. It leads you through a series of steps required to create your own model.

Corporate Financial Modelling: Building Forecasts and Cash Flows is the second course in a three-part series. Starting with, Corporate Financial Modelling: Setting up Financial Models, which set out a methodology for building models in Excel. This course helps you take a simple historic spreadsheet model and develop it by adding a financial forecast and using other forecasting techniques.

Upon satisfactory completion of this activity you will be able to:
• Understand the different forecasting methods available to you in Excel and apply them to your own data.
• Use ratio analysis to produce a forecast.
• Generate expectations of future performance and provide forecasted statements and cash flows.
• Create a flexible model which can be used to review different scenarios, and where inputs can be quickly changed, and results quickly accessed.


This course arms you with the knowledge and skills you need to be able to use a model building approach applicable for all of your financial modelling requirements.

No prerequisites.

No materials distributed.

No assessments required.


Topic: Corporate Finance, Reporting

Sub-Topic: Business Planning & Analysis, Financial Modelling, Financial Reporting

Format: eLearning

Proficiency Level: Foundation, Intermediate, Advanced

CPD: Upto 4 hours