• Home
  • Corporate Financial Modelling: Valuation Sensitivity and Reporting – eLearning

Corporate Financial Modelling: Valuation Sensitivity and Reporting – 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 historic spreadsheet model, which includes a financial forecast, this course looks at how to further develop the model to add valuation and reporting.
Content Description:
Building a functional financial model is one thing but building a sophisticated financial model can elevated your business and provide you with vital information on financial analysis, loan sizing, debt restructuring and valuation.

Using a historic spreadsheet model, which includes a financial forecast, this course looks at how to further develop the model to add valuation and reporting. It will lead you through a series of spreadsheet examples and the steps required to further develop your own model.

Corporate Financial Modelling: Valuation Sensitivity and Reporting is the third course in a three-part series:
Corporate Financial Modelling: Setting up Financial Models sets out a methodology for building models in Excel.
Corporate Financial Modelling: Building Forecasts and Cash Flows leads you through a series of steps required to create your own model.

Upon satisfactory completion of this activity you will be able to:
Generate cash flows attributable to debt providers and shareholders.
Use historic data to calculate discount rates for net present value calculations.
Build a flexible financial model that can calculate different futures, circumstances and outcomes efficiently.
Consider the needs of different audiences and produce financial reports accordingly.

Benefits:
This course arms you with the knowledge and skills you need to be able to build a ‘what-if’ or simulation analysis to predict the outcome of a decision given a certain range of variables and determine how changes in one variable affects the outcome.
Others: 

No prerequisites.


No materials distributed.


No assessments required.

EVENT DETAILS


Topic: Corporate Finance, Reporting

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

Format: Self-paced

Proficiency Level: Intermediate, Advanced

CPD: 4 hours