Building your first company valuation


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

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