background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for February 2025 for September 2024
:
Private EquityReal Estate InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for February 2025 is Open
Wall Street Prep

Join 750k+ learners today. Learn online from Wall Street Prep — the training firm that prepares new hires at the world's top financial institutions.

Enroll Today
  Table of Contents

M&A Model: Accretion/Dilution Analysis

An important part of investment banking is understanding mergers and acquisitions (M&A). Within M&A, One of the core models investment banking analysts and associates have to build when analyzing an acquisition is the accretion/dilution model. The underlying purpose of such an analysis is to assess the impact of an acquisition on the acquirer’s expected future earnings per share (EPS).

Learn More → Investment Banking Primer

M&A Model – Excel Template

Use the form below to get the Accretion dilution Excel model template that goes with this lesson:

dl

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Submitting...

Part 1: Accretion/Dilution Analysis

Part 2: Accretion/Dilution Analysis

M&A Model Conclusion

This is a brief introduction to the concepts and adjustments underlying accretion/dilution analysis and modeling. These are, of course, just a few of the many issues that come into play when building an accretion/dilution analysis. Other adjustments that we did not include:

  1. Advanced Purchase Price Allocation concepts including deferred taxes and the treatment of in-process research & development
  2. Modeling asset sales, 338(h)(10) elections, and stock sales
  3. Modeling an Advanced Sources & Uses of Funds schedule
  4. Target debt considerations
  5. Calendarization and stub year challenges in Excel

Those concepts, along with many others required to build a full-scale M&A accretion/dilution model, are covered in Wall Street Prep’s Premium Package.

Step-by-Step Online Course

Everything You Need To Master Financial Modeling

Enroll in The Premium Package: Learn Financial Statement Modeling, DCF, M&A, LBO and Comps. The same training program used at top investment banks.

Enroll Today

Learn Financial Modeling Online

Everything you need to master financial and valuation modeling: 3-Statement Modeling, DCF, Comps, M&A and LBO.

Learn More

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.