Originally published: 17/06/2016 13:39
Last version published: 02/02/2018 14:50
Publication number: ELQ-90266-2
View all versions & Certificate
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.
by Prof. Aswath DamodaranProfessor at NYU Stern School of Business
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 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
Reviews
People using this tool also downloaded
Mergers & Acquisitions Valuation
This module explores all details of M&A that investment bankers need to know, from a valuation perspective.322 remove_red_eyeDiscussEstimating the Value of Financial Flexibility
Calculate the value of financial flexibility105 remove_red_eyeDiscussChapters Model with Leveraged Buyout LBO Analysis
A full financial model to understand the mechanics of an organisation using Valuation, LBO, & Financial Reports573 remove_red_eyeDiscussfreeby Joshua Wong5-Year SaaS Startup Excel Financial Model: 4 Pricing Tiers + Advanced Metrics
A straight forward approach to build financial projections for a SaaS startup business.183 remove_red_eyeDiscuss$45.00by Jason VarnerGeneralized Free Cash Flow for the Firm (FCFF) Excel Model
Compute the FCFF (Free Cash Flow for the Firm) Model for a Firm with this excel spreadsheet model.412 remove_red_eyeDiscussSaudi Cement Financial Model
This model shows that you can make a reasonable simple model from the data in TAWDAL452 remove_red_eyeDiscussValuation Partial Commitment of the Entrepreneur
Learn how to value an entrepreneur's partial commitment to a venture182 remove_red_eyeDiscussDCF Model with Bear and Bull Scenarios in Excel
A DCF model built for public equity valuations, with a bull and bear scenario analysis to evaluate upside/downside risk348 remove_red_eyeDiscussfreeby Colin FerrianBusiness Model Manufacturer
A model for performing a valuation of a manufacturing company304 remove_red_eyeDiscussfreeby Scott BeberEntrepreneur's Cost of Capital Template
Estimate the statistical parameters for determining an entrepreneur's cost of capital262 remove_red_eyeDiscuss
Any questions on Merger Synergy Valuation Excel Model?
The user community and author are here to help. Go ahead!
