Corporate Financial Modelling: Valuation Sensitivity and Reporting

by Alastair Day

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.

This course is not currently available

This course will enable you 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

About the course

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 CPD course in a three-part series.

Corporate Financial Modelling: Setting up Financial Models set 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.

Look inside

imac
slide-1
slide-2
slide-3
slide-4
slide-5
slide-1-thumbnail
slide-2-thumbnail
slide-3-thumbnail
slide-4-thumbnail
slide-5-thumbnail

Contents

  • Free cash flow
    • What is the methodology for a basic valuation?
    • How do we use the cash flow statement?
    • What is free cash flow?
    • What is the time value of money?
    • How do we deal with a varying interest rate?
  • Cost of capital
    • What are the components of WACC?
    • What data sources can we use?
    • What are the limitations of WACC?
    • What is the capital asset pricing model ?
    • What is asset beta and leveraging?
    • Example: Sector beta
  • Initial valuation
    • What are terminal values?
    • Discounted cash flows refresher
    • What are the common mistakes?
    • What are the required functions?
    • Comparison to market value
    • What are the components of value periods?
  • Sensitivity
    • How can we use scenarios?
    • Can we use multiple values?
    • How do we use scenario manager?
    • How do we use multiple calculations?
    • How do we use data tables?
    • How do we use complex tables?
  • Reports and completion
    • What are the common charting failures?
    • How can we use composite charts?
    • How can we use dynamic charts?
    • How do we create a report template?
    • How do we prepare for model completion?
    • Documentation

How it works

Author

Alastair Day

Alastair has worked in the finance industry for more than thirty years and has extensive experience of financial modelling, finance and leasing.

Reviews

You might also like

Take a look at some of our bestselling courses

This course is not currently available. To find out more, please get in touch.