• 

Send to a friend

• linkedin
• twitter
• facebook
• code

Originally published: 17/06/2016 13:39
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 Damodaran
Professor at NYU Stern School of BusinessFollow 861

with NYU Stern School of Business
An Education in PossibleFollow 32

48 reviews2,966 views|Start the discussion!|Bookmark download for free

synergyvaluationmergersindependent firmscombined firm

Description
This simple excel model enables you with the 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 to compute the Value of the global synergy in a merger.

- Prof. Aswath Damodaran

Side note: If you have appreciated this model, feel free to give it a rating/review!

This Best Practice includes
1 Excel Model File

Prof. Aswath Damodaran offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Reviews

• • 
    4.8 / 5 (48 votes)

    • 77%
    • 23%
    • -
    • -
    • -
  • Rate this Downloadable Best Practice
    

    Write a review

• Wael Attallah, MBA(last updated: 29/10/2020 17:29)
  
• 杨 胡276(last updated: 04/08/2020 09:24)
  
• Vishal More(last updated: 29/07/2020 18:53)
  
• Vasile Popovici the Excel guru(last updated: 28/07/2020 14:52)
  

  This tool is helpful

  This is a really helpful tool.
• Mohd. Faizal Mohd. Zaki(last updated: 24/07/2020 07:34)
  
• JEFF LALO(last updated: 17/06/2020 12:43)
  
• VAIBHAV SINHA(last updated: 16/05/2020 12:34)
  
• Daria Mash(last updated: 14/05/2020 13:26)
  
• SAMUEL MWAURA(last updated: 07/05/2020 19:52)
  
• Natalia Kogan(last updated: 03/05/2020 15:24)
  
• SharafEddein Ahmed(last updated: 15/04/2020 09:26)
  
• Farhan Soeprapto(last updated: 29/03/2020 06:00)
  
• Peggy Schwander(last updated: 29/01/2020 15:34)
  
• George Kyriazopoulos(last updated: 31/12/2019 18:15)
  
• Evan J. MacHenry(last updated: 19/11/2019 20:32)
  
• Valeri Mirchev(last updated: 07/11/2019 11:39)
  
• Yash Garg(last updated: 14/10/2019 09:40)
  
• Dr. Soebowo Musa90(last updated: 02/10/2019 09:07)
  
• Hany Ismail(last updated: 24/09/2019 01:48)
  
• Mitchell Posner558(last updated: 18/07/2019 06:54)
  
• appy shah(last updated: 10/06/2019 08:47)
  
• Choi Tony(last updated: 13/05/2019 02:41)
  
• Amrita Ganguly(last updated: 09/05/2019 00:35)
  
• Saeed Hosseini(last updated: 24/04/2019 07:43)
  
• Trâm Phan843(last updated: 18/04/2019 01:56)
  
• Rohit Chopra998(last updated: 03/04/2019 13:31)
  
• 상철 한(last updated: 28/03/2019 08:13)
  
• kofi(last updated: 22/03/2019 14:51)
  
• Model ME Financial Modelling Solutions(last updated: 22/03/2019 03:52)
  
• ANIKET k(last updated: 15/03/2019 06:21)
  

keyboard_arrow_downShow all

People using this Best Practice also downloaded