Value of Control in a Firm - Excel Model
Originally published: 17/06/2016 13:38
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.

This excel model helps you analyze the value of control in a firm by inputing your status quo and optimal beta, pre-tax cost of debt, tax rate, debt to capital ratio, revenues, operating income (EBIT), Pre-tax return on capital, reinvestment rate and length of growth period.

- Prof. Aswath Damodaran

Side note: If you have appreciated this model, feel free to give it a rating/review!

This Best Practice includes
1 Excel Model File

Prof. Aswath Damodaran offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

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 (23 votes)

please wait...