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
certified

Value of Control in a Firm - Excel Model

This Excel model analyzes the value of control in a firm.

control valuefinancefirmmodeloptimal valuestatus quo valuevaluation

Description
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

Discuss

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

Reviews


keyboard_arrow_leftkeyboard_arrow_right

More tools from Prof. Aswath Damodaran

See all
keyboard_arrow_leftkeyboard_arrow_right

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

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

please wait...