Mergers and Acquisitions (M&A) Financial Excel Model
  • Mergers and Acquisitions (M&A) Financial Excel Model
  • Mergers and Acquisitions (M&A) Financial Excel Model
  • Mergers and Acquisitions (M&A) Financial Excel Model
  • Mergers and Acquisitions (M&A) Financial Excel Model
  • Mergers and Acquisitions (M&A) Financial Excel Model
  • Mergers and Acquisitions (M&A) Financial Excel Model
Originally published: 26/06/2018 08:52
Last version published: 03/07/2018 17:33
Publication number: ELQ-13880-3
View all versions & Certificate
certified

Mergers and Acquisitions (M&A) Financial Excel Model

A complete financial model for mergers and acquisitions (M&A). Includes DCF, accretion/dilution, sensitivity, much more.

accretiondcf modelfinancial modelinvestment bankingm&am&a modelmerger modelmergers and acquisitionsmergers and acquisitions modelsynergies

Description
A complete mergers and acquisitions M&A model that includes: (1) stand-alone target DCF model, (2) stand-alone acquirer DCF model, (3) pro forma model, (4) synergies, (5) accretion/dilution, (6) sensitivity analysis, (6) transaction structure, (7) form of consideration, (8) sources and uses of cash, (9) operating scenarios, and much more! This model was designed by professionals with first hand experience in investment banking, private equity, and corporate development, while working on large-scale M&A transactions.

What this model includes:
- Clean and efficient structure for an M&A model
- All drivers and assumptions required to for the M&A model
- All adjusting accounting entries for a post-transaction balance sheet
- Integration of acquirer and target models into one pro forma
- Accretion and dilution analysis of per share numbers
- Sensitivity analysis of main assumptions and share price

This model can be useful for beginners who are looking to teach themselves based on an example, and also for advanced users who are looking at add more dynamic calculations and enhanced functionality into their models.

To learn how to build this model from scratch, check out CFI's mergers and acquisitions modeling course: https://courses.corporatefinanceinstitute.com/courses/advanced-financial-modeling-mergers-acquisitions

This business tool includes
1 Excel Model

Acquire business license for $107.00

Add to cart

Add to bookmarks

Discuss

Further information

This M&A model gives you a completed version of what an investment banking or corporate development analyst would build for evaluation mergers and acquisitions.

Advanced financial modeling experience

Reviews

  • Desi M.(last updated: 30/06/2018 20:02)
  • 李刚(last updated: 28/06/2018 11:41)
  • Tom Samuel MBA, SA Fin.(last updated: 27/06/2018 04:25)
    Samuel & Sonz
    Excellent tool and simple enough to navigate and understand

keyboard_arrow_leftkeyboard_arrow_right

More tools from Corporate Finance Institute

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Mergers And Acquisitions (M&A) Financial Excel Model?

The user community and author are here to help. Go ahead!

please wait...