Introduction to valuation

Summary

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 kubicle.com

Venue details:  
Online, ,
Start date & time:  
03 December 2018 00:00
End date & time:  
01 January 2020 00:00
Price: €75.00  (€75.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
3.00
CPD hours:  
3.00
Speaker details
No speakers have been associated with this event.

Description

Product type:  
CPD online course
Category:  
Information technology

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.