Valuation Excel Model
  • Valuation Excel Model
  • Valuation Excel Model
  • Valuation Excel Model
  • Valuation Excel Model
  • Valuation Excel Model
  • Valuation Excel Model
  • Valuation Excel Model
Originally published: 10/06/2020 07:29
Last version published: 29/06/2020 16:57
Publication number: ELQ-89297-3
View all versions & Certificate
certified

Valuation Excel Model

This dynamic excel file will help you build a detailed valuation of any business

Description
There are 3 sections in this Excel:

Precedent: Where you can compare previous transactions happening in the same industry as the company you are valuing and mentioning the transaction price to get a picture of what the value of a business in this industry is

DCF Model: Everything is dynamic. Assumptions, Income statement, balance sheet, Cash flow are all linked to DCF

Football field: To picture a summary of your analysis in graphs


This excel will help you calculate and compare the EV of the company from DCF with those that have been previously acquired through precedent analysis.

Furthermore, It is fully dynamic. You just need to input the values, make strong assumptions for your forecast and then let the excel do everything.


For the DCF model,
you might want to calculate the WACC as close as to the industry standards.
For highly capital intensive company, use the CAPM model to calculate the cost of equity

Perpetuity growth rate should be appropriately assumed. You assume that the company's growth to surpass the economy's growth

EV/EBITDA multiple can be chosen by doing a comp analysis. It is not present in the excel but you can make assumption or actually calculate it.

This Best Practice includes
1 Excel file

Acquire business license for $69.00

Add to cart

Add to bookmarks

Discuss

Reviews

  • Be the first to review this Downloadable Tool

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

Any questions on Valuation Excel Model?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...