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

Corporate Financial Modelling: Valuation Sensitivity and Reporting – 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.

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.

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.

No prerequisites.

No materials distributed.

No assessments required.


Topic: Corporate Finance, Reporting

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

Format: eLearning

Proficiency Level: Intermediate, Advanced

CPD: Upto 4 hours