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

Corporate Financial Modelling: Building Forecasts and Cash Flows - eLearning



This activity is published by accountingcpd.


CA ANZ members are entitled to receive 10% off every purchase. Use code CAANZ101 at checkout to take advantage of this discount.


Save $180 and get 20 hours of CPD at your fingertips when you pick ANY 5 4-hr CPD courses for just $495 – use code CAANZ20 at checkout.

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.


Content Description:

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.


Benefits:

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.

EVENT DETAILS


Topic: Corporate Finance, Reporting

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

Format: Self-paced

Proficiency Level: Foundation, Intermediate, Advanced

CPD: 4 hours