Building your first company valuation

Summary

Valuing companies is one of the most important and challenging tasks that an analyst will be asked to perform. This course will show you how to build a valuation model in Excel, that estimates a fictional company’s value using several different valuation techniques.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 13 lessons, 3 exercises and 1 Exam. It covers the following topics:

  • Why build financial projections?
  • Why and when companies are valued?
  • The different methods of valuing a company
  • Enterprise & Equity value
  • The cost of capital
  • Unlevered free cash flow
  • Calculating discounted cash flows
  • The terminal value
  • Re-cap of equity valuation calculation
  • Scenarios & sensitivity analysis
  • Market-based valuation with multiples
  • Return on investment

Key Outcomes

Once you have completed this course you will know how value a company using both the discounted cashflow method and market-based multiples. You will also know how to calculate the discount rate, the difference between enterprise and equity value and how to create scenarios and sensitivity analysis for your completed model.