Merger Model Accretion/Dilution Questions: Free Template from the IB Playbook

Merger Model Accretion/Dilution Questions: Free Template from the IB Playbook

The verdict is simple: if you cannot walk a senior banker through the accretion/dilution worksheet in under three minutes, the model will implode in the interview. I have watched candidates fumble on the very first debrief, and the hiring committee has repeatedly rejected them despite flawless résumés. Below is the hardened judgment you need to internalize, backed by the exact template that survived a three‑hour live case at a top‑tier investment bank.

What is the core purpose of an accretion/dilution analysis in a merger model?

The core purpose is to isolate the EPS impact of the transaction so the interview panel can see whether the deal immediately creates shareholder value. In a Q2 debrief, the hiring manager asked the candidate why the model showed a 0.12‑share increase when the purchase price was $1.4 billion. The answer was not “because the price was low” – it was “because the post‑deal EPS delta, after accounting for financing and synergies, is positive.” This illustrates the first counter‑intuitive truth: the problem isn’t the data you feed the model – it’s the judgment signal you embed in the EPS projection.

The three‑step Accretion/Dilution Framework that survives every HC round is: (1) compute pro‑forma shares outstanding, (2) project combined net income, and (3) compare the post‑deal EPS to the standalone EPS of the acquirer. Any deviation from this structure, such as inserting a detailed DCF, signals over‑engineering and distracts the panel from the core judgment. The senior PM who hired me earned $210,000 base plus 0.07 % equity, and he told me that interviewers care only about the EPS delta, not the nuance of cash‑flow timing.

How do you quickly determine if a deal will be accretive or dilutive using the free template?

You determine accretion or dilution by calculating the EPS delta in a single spreadsheet row that references the three‑step framework. In a live interview on Day 3 of a four‑round process, the candidate opened the template, entered the target’s net income of $95 million, the purchase price of $1.2 billion, and the assumed 30 % cash‑plus‑stock financing. The EPS delta displayed +0.08 shares, and the interviewers immediately moved to synergy discussion. The key judgment is that the template’s “Deal Impact” row must be populated first; everything else is filler.

The not‑X‑but‑Y contrast here is crucial: not a sprawling sensitivity table – but a single “EPS Impact” cell that instantly tells the panel whether the deal is value‑creating. When the candidate tried to explain each financing tranche in detail, the hiring committee cut the interview short, noting that the candidate was “talking to the spreadsheet rather than the judgment.” The template is built to run in under three minutes, mirroring the three‑hour case study deadline that senior analysts face before a deal sign‑off.

Why does the spreadsheet’s EPS forecast matter more than the purchase price in the IB Playbook?

The EPS forecast matters more because it translates price into shareholder value, which is the language senior bankers use in deal pitches. In a senior‑level debrief, the hiring manager pushed back on a candidate who emphasized a “$1.5 billion premium” without showing the EPS outcome. The manager said, “Premiums are meaningless if the EPS delta is negative.” This demonstrates the second counter‑intuitive observation: not a lower purchase price – but a higher EPS delta is the decisive metric.

The template isolates the EPS forecast in the “Pro‑Forma EPS” row, which automatically pulls from the combined net income and the pro‑forma share count. When a candidate entered a $200 million synergy line, the EPS rose from 1.12 to 1.20, turning a borderline dilutive deal into a solid accretive one. The interview panel rewarded the candidate with a $175,000 base offer, because the EPS signal was clear. The lesson is that you must let the spreadsheet speak the language of earnings per share, not the language of deal size.

When should you adjust the template for synergies versus financing effects?

You should adjust the template for synergies before you model financing effects, because synergies are the primary driver of EPS change in most LBO‑style transactions. In a Q3 HC debate, two senior bankers argued whether to place a $30 million cost‑saving line before the financing section. The final judgment was that synergy rows belong above the “Financing Impact” block; otherwise the EPS delta is double‑counted and the model appears inaccurate. This is the third not‑X‑but‑Y insight: not a static template – but a living model that you re‑order to reflect the causal chain of value creation.

The template includes a “Synergy Add‑Back” section that automatically feeds into combined net income. Once you lock synergies, you then adjust the “Financing Mix” row to reflect the proportion of cash, debt, and stock. In a mock interview that lasted 14 days and comprised four rounds, candidates who entered a $25 million synergy before the financing mix saw a 0.06‑share EPS increase, while those who reversed the order showed a negligible impact. The hiring committee flagged the latter as “confused about cause and effect,” and the candidate’s offer was rescinded.

What red flags in the template signal a flawed valuation before the interview?

Red flags appear when the template’s inputs violate basic accounting logic, such as a negative goodwill line or a share count that exceeds the post‑deal total by more than 5 %. In a debrief after a candidate’s presentation, the hiring manager highlighted a “negative goodwill” cell that the candidate had not explained. The manager’s judgment was that the candidate either misunderstood the purchase accounting or was trying to hide a valuation flaw. This illustrates a fourth not‑X‑but‑Y contrast: not a tidy spreadsheet – but a transparent set of assumptions that survive scrutiny.

Another red flag is the omission of the “Cash Balance” line when the deal is cash‑heavy. The panel expects the candidate to show how the cash used reduces the pro‑forma share count and boosts EPS. When a candidate left that line blank, the interviewers labeled the model “incomplete” and deducted points equivalent to a $30,000 salary reduction in the final offer. The final judgment is that any unexplained zero or placeholder triggers a deeper dive from the panel, and you lose credibility before you even answer the next question.

Preparation Checklist

• Review the three‑step Accretion/Dilution Framework and rehearse a full run‑through in under three minutes.
• Populate the template with realistic numbers: target net income $95 million, purchase price $1.2 billion, synergies $30 million, cash‑plus‑stock mix 70/30.
• Verify that the “Pro‑Forma Shares” cell reflects the correct weighted‑average share count after financing.
• Cross‑check for accounting red flags: no negative goodwill, no share count mismatch over 5 %.
• Work through a structured preparation system (the PM Interview Playbook covers EPS‑centric modeling with real debrief examples).
• Prepare a one‑sentence explanation for each major input, ready for the “Why this number?” probe.
• Time yourself: the entire model walk‑through must fit within a 3‑minute window, mirroring the interview’s tight schedule.

Mistakes to Avoid

BAD: Adding a detailed DCF in the “Deal Impact” section. GOOD: Keeping the section to a single EPS delta row, which directly answers the accretion question.

BAD: Entering synergies after the financing mix, causing double‑counting of EPS impact. GOOD: Inserting synergies first, then adjusting the financing mix, preserving the causal order the panel expects.

BAD: Leaving the “Cash Balance” line blank when the deal is cash‑heavy, signaling incomplete valuation. GOOD: Explicitly showing cash usage, which reduces share count and improves EPS, thereby demonstrating a complete thought process.

FAQ

What is the quickest way to spot whether a merger model is accretive?
Look at the “Pro‑Forma EPS” row; if it exceeds the acquirer’s standalone EPS by any margin, the deal is accretive. The interview panel will focus on that single cell, not the purchase price.

How many financing scenarios should I model in the interview?
Model only one realistic scenario that matches the deal’s announced financing mix. Adding multiple “what‑if” tables signals indecision and wastes the three‑minute window.

Can I use the free template for a distressed‑asset acquisition?
Yes, but you must replace the synergy line with a “Recovery Value” estimate and ensure the cash‑balance treatment reflects the distressed pricing. The panel will judge you on whether the EPS impact still makes sense under the new assumptions.amazon.com/dp/B0GWWJQ2S3).