Last version published: 02/02/2018 14:50
Publication number: ELQ-90266-2
View all versions & Certificate
Merger Synergy Valuation Excel Model
This Excel Model estimates the value of synergy in a merger.
Prof. Aswath Damodaran offers you this business tool for free!
download for free
Add to bookmarks
The objective of this model is to get the following output values for the acquiring firm, target firm and merged firm:
- Cost of Equity
- After-tax cost of debt
- Cost of capital
- After-tax return on capital
- Reinvestment rate
- Expected growth rate
- Present Value (PV) of Free Cash Flow for the Firm (FCFF) in high growth
- Terminal value
- Value of firm today
Value of synergy:
- value of independent firms
- value of combined firm
- value of synergy
People using this tool also downloaded
Any questions on Merger Synergy Valuation Excel Model?
The user community and author are here to help. Go ahead!