1. Catalog
  2. Finance
  3. Stock Valuation
  4. Terminal Value Calculation Excel Template
Terminal Value Calculation Excel Template
  • Terminal Value Calculation Excel Template
Originally published: 02/08/2016 12:00
Last version published: 31/01/2017 16:00
Publication number: ELQ-52119-2
View all versions & Certificate
certified

Terminal Value Calculation Excel Template

Compute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet

Dheeraj Vaidya CFA FRMby Dheeraj Vaidya CFA FRM
Co-founder & CEO @ eduCBA & founder of WallStreetMojoFollow 190
23 reviews4,449 views|Start the discussion!|Bookmark download for free
financefcffpresent valuestockterminal valueequity valueshare priceperpetuity growthmultiple methodtotal enterprise value
Description
Download this Terminal Value Excel Template. This explains how the perpetuity growth method and exit multiple methods can be professionally applied through excel.

Outputs:
- Present Value of Explicit FCFF (Free Cash Flow to the Firm) with both the Perpetuity Growth method and the exit multiple method.
- Total Enterprise Value
- Equity Value
- Share Price

This Best Practice includes
1 Excel Model

Dheeraj Vaidya CFA FRM offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


4.4 / 5 (23 votes)

please wait...