What you will learn
- 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).
About this pack
Valuation analysis has never been as important as it is right now. 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.
Key information
- 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 (Excel 2019 for MAC support will end in October 2023).
- 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.
