Last version published: 31/01/2017 16:00
Publication number: ELQ-52119-2
View all versions & Certificate
Terminal Value Calculation Excel Template
Compute the Terminal Value of a stock (Perpetuity and Exit Multiple Methods) with this excel spreadsheet
Download this Terminal Value Excel Template. This explains how the perpetuity growth method and exit multiple methods can be professionally applied through excel.
- 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 business tool includes
1 Excel Model
Dheeraj Vaidya CFA FRM offers you this business tool for free!
download for free
Add to bookmarks
- Paya Danesh(last updated: 23/05/2018 09:53)
- 丁 毛毛(last updated: 13/04/2018 02:48)
- Long Lê(last updated: 01/04/2018 10:28)
People using this tool also downloaded
FCFF (Free Cash Flow for the Firm) Excel Model with exposure to country riskAn Excel FCFF Model allowing the user to enter a measure of company exposure to country risk when making a valuationfinancevaluationfree cash flow for the firmfcffpresent valuecountry riskexposuremarket value502 remove_red_eye
High Growth Firms Valuation ModelValue tough-to-value firms, with negative earnings, high growth in revenues and few comparablesfinancevaluationfcffpresent valuehigh growthfirmsnegative earningsrevenues302 remove_red_eye
Activision Blizzard DCF (Discounted Cash Flow) ModelA simple DCF Model based on Operating and Working Capital Assumptions (example: Activision Blizzard)financevaluationdcfoperatingterminal valueshare pricediscounted cash flowworking capital442 remove_red_eye
Simple FCFF Model (Free Cash Flow for the Firm)A complete FCFF model that allows for changing margins and has default assumptions built infinancevaluationfcffpresent valuefree cash from for the firmsimple161 remove_red_eye
Free Cash Flow (FCFF) TemplateCompute the FCFF for a firm through three different methods (EBIT, EBITDA and Net Income)financefree cash flow for the firmfcffebitebitdanet income178 remove_red_eye
Estimating a beta (Corporate Finance)Compute and estimate a beta for a firm's stock/market indexperformanceriskfinancestocksensitivitybetaestimatingjensen's alphamarket index425 remove_red_eye
Implied Return on Capital (ROC) & Return on Equity (ROE) Terminal ValueCompute the ROC or ROE implied in your terminal value calculationfinanceroereturn on equityrocterminal valuereturn on capitalreinvestment564 remove_red_eye
Generalized Free Cash Flow for the Firm (FCFF) Excel ModelCompute the FCFF (Free Cash Flow for the Firm) Model for a Firm with this excel spreadsheet model.financevaluationfirmfree cash flow for the firmfcfftransition391 remove_red_eye
Warrants and Management Options - Excel Valuation ModelWarrants and Management Options Excel Model for valuing options that result in dilution of the underlying stock.financewarrantsoptions pricingmanagement optionsvaluation modelstock381 remove_red_eye
Free Cash Flow for the Firm (FCFF) Valuation Excel ModelAn Excel Model to value firms with operating income that is either positive or can be normalized to be positive.financevaluationfree cash flow for the firmfcff1,454 remove_red_eye
Any questions on Terminal Value Calculation Excel Template?
The user community and author are here to help. Go ahead!