The global body for professional accountants

16
UNITS

Online course | SumProduct

Valuation modelling

Understand why valuation analysis is so important for your business

Overview

London cityscape

In a post-COVID business world full of tax consolidations, increasing interest rates, Public Private Partnerships and trade sales, few analysts can construct robust valuations.  This pack aims to plug the holes and provide real-life examples for various enterprise, equity and project valuations.

This pack highlights how to convert cash flows to free cash flows, notes the different types of valuation and shows you how to model them – without making many of the errors many businesses inadvertently produce.

You will learn:

  • about the concept of discounted and free cash flows, alongside several other key valuation techniques
  • how to calculate free cash flows from existing information
  • the differences between enterprise value, equity value, project investment appraisal and lease vs buy decisions
  • how to recognise the issues associated with developing equity valuations
  • how to check your valuations using different analytical techniques
  • other metrics: differing internal rates of return (IRR, XIRR and MIRR), Economic Value Added (EVA) (© Stern Stewart), Strategic Value Add (SVA), Market Value Added (MVA) and the link to Net Present Value (NPV).
  • This pack contains a collection of interactive slides and videos for you to follow, and exercises for you to complete within Excel.
  • This pack requires you to use (for Windows) Excel 2016 (or newer), Excel for the web or Excel 365; (for Mac) Excel 2021.
  • The recommended operating systems for Windows are Windows 10 or 11; for MacOS is Big Sur 11 or later.
  • This pack requires you to have a basic understanding of Microsoft Excel.
  • CPD certificate is available upon successful completion of the pack.
  • 12-month access.

Price

Price 250 GBP

Location

Global

Date & time

On demand

Course providers

Logos of ACCA and SumProduct