Merger Models and Accretion Dilution

A merger model you can build, defend and turn overnight: share counts, offer bridge, financing mix, purchase accounting, synergies, pro forma EPS, contribution and ownership, plus the checks and specialist cases.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Merger Models and Accretion Dilution, and click Install. It goes into your own files, and works offline from then on.

What it installs.

1

Pillar

1

Area

50

Projects

199

Starter tasks

🏦 Investment Banking & Advisory

Merger Models and Accretion Dilution

Building merger models: purchase price and financing mix, synergies, pro forma EPS accretion or dilution, contribution analysis and ownership.

  1. One-page map of how a merger model flows
  2. Personal merger model template built from a blank sheet
  3. Aligned standalone forecasts for acquirer and target
  4. Fully diluted share counts for both companies
  5. Offer price, premium and enterprise value bridge
  6. Sources and uses table with fees and refinancing
  7. Financing cost assumptions for cash, debt and stock
  8. Purchase price allocation and goodwill estimate
  9. Year one and year two pro forma EPS build
  10. Assumptions log with a source for every input
  11. Weekly market data refresh for live merger models
  12. Quarterly earnings rerun of the merger model
  13. Model version control and change log
  14. Debt pricing assumptions refresh
  15. Benchmark library of announced deal synergies
  16. Personal error log for merger models
  17. Merger-specific sanity checks before every send
  18. Back-of-envelope accretion dilution drill
  19. Yearly check of business combination accounting rules
  20. Purchase accounting under IFRS 3 and ASC 805
  21. Deferred taxes and deal structure in the model
  22. Exchange ratios, fixed versus floating, and collars
  23. Breakeven and required synergies analysis
  24. Contribution analysis for the combined company
  25. Pro forma ownership and voting control analysis
  26. Cash EPS and the amortisation of acquired intangibles
  27. Sensitivity tables for premium, mix and synergies
  28. Pro forma credit metrics alongside accretion
  29. Cash, stock or mixed consideration comparison
  30. Phasing synergies and the cost to achieve them
  31. Revenue synergies, included or excluded
  32. Accretion against value creation, the ROIC test
  33. Acquisition compared with a share buyback
  34. Transaction fees and financing fees in the pro forma
  35. Refinancing the target's debt in the model
  36. Merger model pages for a client board meeting
  37. Announcement day accretion statement check
  38. Overnight accretion dilution pages for a pitch
  39. Revised bid rerun of the merger model
  40. Post-closing look-back on projected accretion
  41. First merger model on a live deal as a new analyst
  42. Associate ownership of the merger model and its builders
  43. Reconciling with the client's corporate development model
  44. Timed merger model test practice
  45. Vice president review of a merger model in thirty minutes
  46. Bank acquirer model with tangible book value earn-back
  47. REIT merger model on FFO and AFFO per share
  48. Merger of equals exchange ratio and governance
  49. Cross-border merger model with currency and tax rates
  50. Earnouts and contingent consideration in the model

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

One-page map of how a merger model flows

Most first merger models break because the builder copies a template without knowing why each block feeds the next. Drawing the flow once on a single page, from offer price and share counts through financing, purchase accounting and synergies to pro forma net income and EPS, means you can rebuild any model from memory and spot a broken link in seconds.

First tasks

  • Sketch the blocks of a merger model on one sheet of paper from memory
  • Compare your sketch with a firm merger model and mark what you missed
  • Label each arrow with the line items it carries between blocks
  • Walk a fellow analyst through the finished map and note their questions

Personal merger model template built from a blank sheet

Firm templates are dense and often carry fixes from old deals that nobody remembers. Building your own compact merger model from a blank workbook, using two real listed companies, teaches the mechanics properly and gives you a clean tool for quick pitch analysis where the full firm model would be slower.

First tasks

  • Pick two listed companies in one sector as your practice acquirer and target
  • Lay out the input, forecast, transaction and output tabs in a blank workbook
  • Build the pro forma net income and share count rows for two years
  • Run the same inputs through the firm model and reconcile any gap

Aligned standalone forecasts for acquirer and target

Pro forma EPS is only as good as the two standalone forecasts underneath it, and those usually come from different sources, fiscal years and accounting bases. Calendarising both companies to the acquirer's fiscal year, choosing consensus or management cases deliberately and cleaning out one-off items stops the model reporting accretion that is really a timing or definition mismatch.

First tasks

  • Note each company's fiscal year end and the months that need shifting
  • Pull consensus net income and EPS for both companies with today's date
  • Calendarise the target forecast to the acquirer's fiscal year
  • List every one-off item removed and apply the same rule to both companies

Make it yours.

Install Merger Models and Accretion Dilution, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.