Last version published: 02/02/2018 14:50
Publication number: ELQ-93124-2
View all versions & Certificate
Value of Control in a Firm - Excel Model
This Excel model analyzes the value of control in a firm.
Prof. Aswath Damodaran offers you this Best Practice for free!
download for free
Add to bookmarks
The objective of this model is to get the following output values for a firm:
- Cost of Equity
- After-tax cost of debt
- Cost of capital
- After-tax return on capital
- Reinvestment rate
- Expected growth rate
- Value of Firm
- Present Value (PV) of Free Cash Flow for Firm (FCFF) in high growth
- Terminal Value
- Value of Firm Today
Value of Control:
- Value of Status Quo
- Value of Optimal
- Value of Control
4.7 / 5 (21 votes)
Write a review
- Nice Tool!
People using this Best Practice also downloaded
Merger Synergy Valuation Excel ModelThis Excel Model estimates the value of synergy in a merger.2,966add_shopping_cart
Merger & LBO Model Valuation ExcelThis LBO model in excel analyzes the value of equity and the firm in a leveraged buyout operation.10,114add_shopping_cart
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.1,915add_shopping_cart
Discounted Cash Flow (DCF) Excel ModelThis DCF Excel Model provides a rough guide to which discounted cash flow model may be best suited to your firm.1,830add_shopping_cart
Dividend Discount ModelA complete dividend discount model that can do stable growth, 2-stage or 3-stage valuation.3,454add_shopping_cart
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 valuation681add_shopping_cart
FCFE (Free Cash Flow to Equity) Valuation ModelA complete FCFE valuation model that allows you to capital R&D and deal with options in the context of a valuation model2,038add_shopping_cart
High Growth Firms Valuation ModelValue tough-to-value firms, with negative earnings, high growth in revenues and few comparables572add_shopping_cart
Simple FCFF Model (Free Cash Flow for the Firm)A complete FCFF model that allows for changing margins and has default assumptions built in471add_shopping_cart
Valuation of PremiumsA model to value the premium you should pay for growth in either an intrinsic valuation or a relative valuation.250add_shopping_cart
Black-Scholes converted for Binomial TreeConverts the standard deviation input in the Black-Scholes model to up and down movements in the binomial tree.3,217add_shopping_cart
Dividend Adjusted Model to value Long Term OptionsA dividend-adjusted model for valuing long term options.355add_shopping_cart
Any questions on Value Of Control In A Firm - Excel Model?
The user community and author are here to help. Go ahead!