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

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

TL;DR

The free IB Playbook template eliminates the most common source of dilution errors, but only if you enforce disciplined assumption checks. The model’s output is a judgment signal, not a spreadsheet miracle. Use the template, audit every driver, and you will consistently present accretion that survives senior‑banker scrutiny.

Who This Is For

You are an investment‑banking analyst or associate who has just been handed a live M&A pitch and a deadline of 48 hours to produce a credible accretion/dilution analysis. You have solid Excel skills, but you have seen peers get their models rejected because of hidden assumption gaps. You need a battle‑tested template and a decision‑making framework that lets you move from “I built a model” to “I built a model the senior banker trusts.”

How do I quickly validate the accretion/dilution outcome of a merger model?

The quickest validation is a three‑step sanity check that compares the model’s headline EPS change to a back‑of‑the‑envelope proxy. First, calculate the standalone EPS of the target and the acquirer using the most recent quarterly filing. Second, apply the deal‑level synergies and financing costs to the combined earnings. Third, divide the adjusted earnings by the post‑deal share count. If the resulting EPS differs from the model’s headline by more than 2 cents, the model is likely mis‑aligned. In a Q1 debrief, the hiring manager pushed back because the analyst’s EPS jump was 0.15 dollar while the sanity proxy showed only 0.07 dollar. The manager’s objection was not about the spreadsheet’s formulas—it was about the analyst’s failure to cross‑check the headline.

Counter‑intuitive Insight #1: The first red flag is never a broken VLOOKUP; it is an assumption that never survived a sanity check. Most trainees think the model’s complexity shields it from error, but the reality is the opposite: complexity hides assumption drift.

Script:

“Hey Alex, I just ran the three‑step sanity check and my EPS delta is off by 0.08 dollar. I’ll revisit the financing assumptions and run the model again before the deck goes out.”

Why does a flawless spreadsheet still produce a misleading dilution figure?

A flawless spreadsheet can still mislead because the dilution figure is a judgment signal, not a deterministic output. The signal is distorted when the model treats the target’s cash‑on‑hand as a free source of value without accounting for transaction‑level cash‑flow timing. In a recent HC meeting, a senior associate argued that the model “looks perfect” while the hiring committee flagged the dilution as “inflated” because the cash‑balance line was entered as a static number instead of a dynamic post‑closing cash‑flow.

Not a typo, but a conceptual mismatch: the model assumed cash stayed on the target’s balance sheet, yet the deal structure required a cash‑out to finance the purchase. The mismatch inverted the dilution direction, turning an accretive deal into a seemingly dilutive one.

Counter‑intuitive Insight #2: The second truth is that the most trustworthy output comes from a deliberately “imperfect” model that forces you to articulate every assumption.

What hidden assumptions typically skew the accretion analysis in IB cases?

The hidden assumptions that most analysts overlook are the tax‑rate treatment of synergies, the incremental cost of new debt, and the impact of a change‑in‑control clause on the target’s earn‑out. In a live pitch, the senior banker asked the analyst to justify why the model showed a 0.12 dollar EPS accretion while the market implied a 0.04 dollar accretion. The analyst answered that the tax shield on synergies was set at 40 percent, but the deal’s financing memorandum capped the effective tax rate at 30 percent due to covenant‑linked interest expense. The banker’s reaction was not “the math is wrong”—it was “the assumption is unrealistic.”

Not a lack of data, but a mis‑placed confidence in the default tax rate setting. The model’s default 35 percent tax rate was a convenience, not a calibrated figure. Once the analyst replaced the default with the covenant‑adjusted rate, the accretion dropped to the market‑consistent 0.05 dollar.

Counter‑intuitive Insight #3: The third lesson is that every “standard” input in a template should be treated as a hypothesis, not a constant.

How can I leverage the IB Playbook template to avoid common modeling pitfalls?

The IB Playbook template forces a disciplined walk‑through of every driver, turning hidden assumptions into explicit line items. When you open the template, you see a “Assumption Audit” tab that lists cash‑balance treatment, tax‑rate overrides, and financing cost flags. The judgment is to fill each flag before you touch the calculation sheets. In a recent interview, the hiring manager asked the candidate to walk through the template’s “Assumption Audit” during a 30‑minute case study. The candidate’s answer was not “I entered the numbers”—it was “I reviewed each flag, documented the source, and set a green/red indicator for senior review.”

Not a “copy‑paste” model, but a “audit‑first” model. The template’s design makes the model’s credibility a function of the audit completeness, not the number of formulas.

Script:

“Dear Sara, I’ve completed the Assumption Audit in the IB Playbook template and highlighted three items that need senior sign‑off: target cash treatment, post‑deal tax rate, and incremental debt cost. I’ll circulate the audit sheet before the final deck.”

When should I present a dilution model to senior bankers versus the deal team?

Present the dilution model to senior bankers only after you have validated the three‑step sanity check and documented every audit flag. The senior bankers care about the judgment signal, not the raw numbers. In a Q3 debrief, the hiring manager pushed back because the analyst presented the model before the audit was complete, causing the senior banker to question the credibility of the entire pitch. The manager’s objection was not “the numbers look off”—it was “the process was incomplete.”

Not a “final deck” version, but a “pre‑review” version. The pre‑review version includes a one‑page “Assumption Summary” that senior bankers can scan in under 30 seconds. Once senior bankers sign off, you can embed the full model in the deal‑team deck without exposing the underlying audit details.

Counter‑intuitive Insight #4: The fourth truth is that the optimal presentation moment is after you have a documented failure mode, because it shows you can anticipate and mitigate risk.

Preparation Checklist

• Review the IB Playbook template’s Assumption Audit tab and flag every driver that is not a default value.
• Run the three‑step EPS sanity check using the latest quarterly filings; ensure the model’s headline EPS is within 2 cents of the proxy.
• Verify the target’s cash‑on‑hand treatment against the transaction financing memorandum; document any timing mismatches.
• Adjust the tax‑rate inputs to reflect covenant‑linked effective rates; note the source of each tax assumption.
• Recalculate incremental debt cost using the deal’s actual spread over LIBOR; compare to the template’s default spread.
• Prepare a one‑page Assumption Summary that lists red flags in green/red format for senior‑banker review.
• Work through a structured preparation system (the PM Interview Playbook covers “Assumption Auditing” with real debrief examples, so you can see how senior bankers react to incomplete audits).

Mistakes to Avoid

BAD: Leaving the cash‑balance flag at the default “$0” value and assuming the target’s cash will be retained. GOOD: Explicitly modeling cash outflow, documenting the timing, and updating the post‑deal share count accordingly.

BAD: Using the template’s default 35 percent tax rate without checking the financing covenant. GOOD: Replacing the default with the covenant‑adjusted 30 percent rate and noting the source in the Assumption Audit.

BAD: Presenting the raw model to senior bankers before completing the Assumption Audit. GOOD: Delivering a pre‑review deck that includes the Assumption Summary, allowing senior bankers to focus on the judgment signal.

FAQ

What is the quickest way to spot a dilution error in a live model?

Run the three‑step EPS sanity check and compare the headline EPS to the proxy. If the difference exceeds 2 cents, the model contains a hidden assumption error that must be investigated.

Can I rely on the IB Playbook template’s default values?

Never. Every default is a hypothesis that must be validated against deal‑specific documents. Treat each default as a red flag until you replace it with a calibrated figure.

How much time should I allocate to the Assumption Audit before the final deck?

Allocate at least 6 hours for a 48‑hour pitch cycle. The audit consumes roughly 30 percent of total modeling time but prevents senior‑banker push‑back that can add days of rework.

The 0→1 PM Interview Playbook (2026 Edition) — view on Amazon →