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 (47 votes)- 77%
- 23%
- -
- -
- -
Write a review
- This tool is helpfulThis is a really helpful tool.
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 Tips273Discussadd_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 tips1581add_shopping_cart$9.00Mergers & Acquisitions Valuation
This module explores all details of M&A that investment bankers need to know, from a valuation perspective.974Discussadd_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 examples361add_shopping_cart$29.00Fully Automated Stock Portfolio and Valuation Template
Fully Automated G. Sheet template for Portfolio and Stock Valuation with live data from internet (for US listed stocks)1,0601add_shopping_cart$20.00by Bassir Ahmadzai
Discounted Cash Flow DCF Valuation Model Template (Mining Company)
Financial model that performs a DCF & Relative valuation on Mining Company.1,085Discussadd_shopping_cart$49.00by Fin-Wiser Advisory
All in One Private Equity Model
Used by Investment Professionals at Private Equity and IB Firms10,1872add_shopping_cart$180.00by John Swan
10 Years Financial Forecast and Valuation Excel Model
Three statement financial model to forecast the Company's P&L account, BS, Cash Flow and Company's Valuation2,0802add_shopping_cart$50.00by Jair Almeida
3-Year Financial Forecast (DEMO)
3-year financial forecast model for CEO of a startup or small business156Discussadd_shopping_cartfreeby ExcelModels
LBO Financial Model Template (Detailed) - EXCEL
LBO (Leveraged Buyout) financial model for private companies (clean, simple, functional, and reusable template).1,4793add_shopping_cart$500.00by Karl Schopf
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,457Discussadd_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,861Discussadd_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,734Discussadd_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,7641add_shopping_cartfreeDividend Discount Model
A complete dividend discount model that can do stable growth, 2-stage or 3-stage valuation.3,346Discussadd_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 valuation664Discussadd_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,944Discussadd_shopping_cartfreeHigh Growth Firms Valuation Model
Value tough-to-value firms, with negative earnings, high growth in revenues and few comparables548Discussadd_shopping_cartfreeSimple FCFF Model (Free Cash Flow for the Firm)
A complete FCFF model that allows for changing margins and has default assumptions built in450Discussadd_shopping_cartfreeValuation of Premiums
A model to value the premium you should pay for growth in either an intrinsic valuation or a relative valuation.207Discussadd_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,941Discussadd_shopping_cartfreeDividend Adjusted Model to value Long Term Options
A dividend-adjusted model for valuing long term options.330Discussadd_shopping_cartfree
Any questions on Merger Synergy Valuation Excel Model?
The user community and author are here to help. Go ahead!
