Value of Control in a Firm - Excel Model
  • Value of Control in a Firm - Excel Model
  • 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.

control valuefinancefirmmodeloptimal valuestatus quo valuevaluation

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 business tool includes
1 Excel Model File

Prof. Aswath Damodaran offers you this business tool 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



Any questions on Value Of Control In A Firm - Excel Model?

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

please wait...