Introduction to valuation


This advanced course will teach you the essentials of asset valuation theory and how to create simple valuation models in Excel. All the primary valuation techniques are included in the course, from Internal Rate of Return to EV/EBITDA multiples. The course also teaches you when to use certain models and how to incorporate loans into your investment return calculations.  Created & customized for Chartered Accountants Ireland by

Venue details:  
Online EU, ,
Start date & time:  
01 January 2021 00:00
End date & time:  
01 January 2022 00:00
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
3.00 Training Tickets accepted
CPD hours:  
Speaker details
No speakers have been associated with this event.


Product type:  
CPD online course
Kubicle, Technology and data

Who Should Attend?

This course is suitable for advanced learners who are very familiar with writing formulas and performing analysis in Microsoft Excel. It is best suited to accountants, management consultants, analysts and other business professionals.

Course Overview

This Kubicle course contains 18 lessons, 2 exercises and 1 Exam. It covers the following topics:

  • Why learn about valuation
  • Different methods of valuation
  • Time value of money & present values
  • Calculating present values in Excel
  • Choosing the right discount rate
  • Calculating net present value
  • Calculating Internal Rate of Return
  • Limitations of IRR
  • Payback period
  • IRR vs NPV
  • Investing with loans
  • How loan terms affect returns
  • Downside of investing with loans
  • Growth rates & terminal value
  • Market-based valuation & multiples
  • Limitations of market-based valuation
  • More tips on using multiples
  • Cost-based valuation

Key Outcomes

Once you have completed this course you will know how to frame a business problem, diagram the problem, build a model in Excel and analyse the results of the model so as to make an informed decision. This ability is hugely valuable to organisations who methods for making better decisions that lead ultimately, to better financial results.