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.
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 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
4.8 / 5 (42 votes)- 76%
- 24%
- -
- -
- -
Write a review
People using this Best Practice also downloaded
Valuation - Comparables Approach: Using Peer Companies and Transaction Multiples
Business Valuation using Peer Multiples Approach : 40 Slides full of Details, Examples and Tips159Discussadd_shopping_cart$9.00by Rositsa Chopeva
Valuation- DCF Approach Complete Guide
JP Morgan comprehensive guideline on business valuation by Discounted Cash Flow Method, full of illustrations and tips981add_shopping_cart$9.00Mergers & Acquisitions Valuation
This module explores all details of M&A that investment bankers need to know, from a valuation perspective.911Discussadd_shopping_cartfreeby Street Of Walls
Valuation - 120 Slides Complete Guideline, 5 valuation methods, examples and tips
The most comprehensive guideline on business valuation, +120 Slides, 5 methods, step by step illustrations and examples301add_shopping_cart$29.00All in One Private Equity Model
Used by Investment Professionals at Private Equity and IB Firms9,0022add_shopping_cart$180.00by John Swan
Commercial Real Estate Valuation Model - BASIC
Advanced Real Estate Model, that allows a professional DCF Valuation for Office, Retail or Industrial Properties86Discussadd_shopping_cart$29.00by Julian Scheeff
LBO Financial Model Template (Detailed) - EXCEL
LBO (Leveraged Buyout) financial model for private companies (clean, simple, functional, and reusable template).1,066Discussadd_shopping_cart$500.00by Karl Schopf
Discounted Cash Flow DCF Valuation Model Template (Mining Company)
Financial model that performs a DCF & Relative valuation on Mining Company.701Discussadd_shopping_cart$49.00by Fin-Wiser Advisory
Financial Model (Toys & Seasonal) Excel Template
A full example Financial Model of a retail company (Toys & Seasonal) to download and analyse.2592add_shopping_cart$49.00by Big4WallStreet
Company Valuation Excel Model (Equity) - Market approach, with automatic data download
An excel model for Company (Equity) valuation using the market approach742Discussadd_shopping_cart$15.00by Finance Cell
More Best Practices from Prof. Aswath Damodaran
Value of Control in a Firm - Excel Model
This Excel model analyzes the value of control in a firm.1,413Discussadd_shopping_cartfreeby Aswath Damodaran
Merger & LBO Model Valuation Excel
This LBO model in excel analyzes the value of equity and the firm in a leveraged buyout operation.9,580Discussadd_shopping_cartfreeFree Cash Flow for the Firm (FCFF) Valuation Excel Model
An Excel Model to value firms with operating income that is either positive or can be normalized to be positive.1,592Discussadd_shopping_cartfreeDiscounted Cash Flow (DCF) Excel Model
This DCF Excel Model provides a rough guide to which discounted cash flow model may be best suited to your firm.1,6511add_shopping_cartfreeDividend Discount Model
A complete dividend discount model that can do stable growth, 2-stage or 3-stage valuation.3,101Discussadd_shopping_cartfreeFCFF (Free Cash Flow for the Firm) Excel Model with exposure to country risk
An Excel FCFF Model allowing the user to enter a measure of company exposure to country risk when making a valuation646Discussadd_shopping_cartfreeFCFE (Free Cash Flow to Equity) Valuation Model
A complete FCFE valuation model that allows you to capital R&D and deal with options in the context of a valuation model1,802Discussadd_shopping_cartfreeHigh Growth Firms Valuation Model
Value tough-to-value firms, with negative earnings, high growth in revenues and few comparables527Discussadd_shopping_cartfreeSimple FCFF Model (Free Cash Flow for the Firm)
A complete FCFF model that allows for changing margins and has default assumptions built in424Discussadd_shopping_cartfreeValuation of Premiums
A model to value the premium you should pay for growth in either an intrinsic valuation or a relative valuation.195Discussadd_shopping_cartfreeBlack-Scholes converted for Binomial Tree
Converts the standard deviation input in the Black-Scholes model to up and down movements in the binomial tree.2,067Discussadd_shopping_cartfreeDividend Adjusted Model to value Long Term Options
A dividend-adjusted model for valuing long term options.295Discussadd_shopping_cartfree
Any questions on Merger Synergy Valuation Excel Model?
The user community and author are here to help. Go ahead!
