What a merger model actually tests

M&A guideValuation and modeling9 min read

A communication tool, not a spreadsheet exercise

Candidates preparing for M&A interviews often treat the merger model as a purely mechanical exercise: get the accretion and dilution formula right, and the technical bar is cleared. The formula itself, and the classic follow-up questions about it, are covered fully in M&A terms interviewers expect you to know, and this article will not re-derive them. What actually separates a strong candidate is understanding what the model is for once it is built: it exists to help a client's management team and board decide whether a deal makes sense, under what structure, and how sensitive that answer is to assumptions nobody can know with certainty at signing. An interviewer who asks you to "walk me through building a merger model" is really asking whether you understand that judgment layer, not whether you can recite formulas.

Structuring the consideration: the first real decision

Before any accretion or dilution math matters, someone has to decide how the target's shareholders will actually get paid, and this decision shapes everything downstream. The three basic structures each answer a different question about who bears what risk.

StructureHow it worksWho bears the risk between signing and closing
All cashTarget shareholders receive a fixed dollar amount per shareAcquirer bears all risk of its own stock price moving; target shareholders get certainty
Fixed exchange ratio (stock)Target shareholders receive a set number of acquirer shares per target shareTarget shareholders bear the risk of the acquirer's stock price falling before closing
Fixed value (stock, collared or uncollared)Target shareholders receive a dollar value of stock, with the share count floating (sometimes within a collar limiting how far it floats)Acquirer bears more of the risk, since it must issue more shares if its price falls

Cash deals are simpler to model and to explain, and appeal to sellers who want certainty, but require the acquirer to actually have or raise the cash, which introduces financing risk and, if debt-funded, adds interest expense that affects the deal's earnings impact directly. Stock deals let a cash-constrained acquirer transact without new financing and let target shareholders participate in the combined company's future upside, but introduce real disagreement risk over how many shares is fair, the subject of contribution analysis covered in how valuation works in a live deal. Most large deals actually use some mix, and the specific split is itself a negotiated outcome that a merger model needs to flex around, not a fixed input decided before modeling starts.

Sources and uses: where the money actually comes from

Every acquisition financed with anything other than 100% acquirer stock needs a sources and uses schedule, a simple but essential table showing where the money to fund the deal comes from (new debt, cash on the balance sheet, new equity, rollover equity from existing owners) and where it goes (paying target shareholders, refinancing the target's existing debt, transaction fees). This schedule is where financing assumptions meet reality: does the acquirer have enough revolver capacity or cash on hand, does new debt push leverage above a level rating agencies or existing lenders would tolerate, does the equity check make sense relative to the acquirer's own market capitalization.

Interviewers use sources and uses questions specifically to test whether a candidate understands that a deal's economics and its financing are not separate problems. A deal that looks attractive on a standalone valuation basis can become unattractive once you see it requires leverage the acquirer's balance sheet cannot realistically support, and a candidate who jumps straight to accretion and dilution without first confirming the deal is financeable at all is skipping a step interviewers notice.

A worked example of why structure matters more than the headline price

A hypothetical shows why the consideration decision often matters more than the price itself. Suppose a larger company agrees to acquire a smaller competitor for what both sides describe publicly as a fixed enterprise value, built from a blend of the valuation methodologies described in how valuation works in a live deal. If the acquirer proposes to fund the deal entirely with new debt, the model needs to show whether the combined company's leverage, existing debt plus the new acquisition debt, stays within a level the acquirer's existing lenders and rating agencies will tolerate, and whether the added interest expense still leaves the deal accretive once realistic (not best-case) synergies are assumed. If instead the acquirer proposes an all-stock, fixed-exchange-ratio deal, the same headline price now exposes the target's shareholders to the acquirer's stock price between signing and closing, a real risk if the acquirer's shares are volatile or if the market reacts negatively to the announcement itself. The "same" deal, in other words, is a materially different proposition to both sides depending purely on how it's financed and structured, which is exactly why a candidate who jumps straight to an accretion and dilution answer without first asking how the deal is being funded is skipping the step interviewers care about most.

Sensitivity analysis: the real test of the model

A merger model built around a single set of assumptions, one synergy number, one financing mix, one exit multiple, tells a client almost nothing useful, because every one of those assumptions is genuinely uncertain at the time a deal is signed. The actual value of the exercise comes from sensitivity analysis: rerunning the model across a reasonable range of inputs (synergy realization from a conservative estimate to management's full case, a range of financing costs, a range of the combined company's future trading multiple) to show how much the conclusion depends on assumptions that could easily go the other way.

A well-built sensitivity table often reveals that a deal's headline accretion is fragile, dependent on synergies materializing close to the high end of what management projects, while the deal would actually be dilutive under a more conservative, still plausible case. Presenting that range honestly, rather than presenting only the base case that makes the deal look best, is exactly the kind of judgment interviewers are trying to surface when they ask what you would tell a board about a deal's risks, not just its expected outcome.

Circularity and other technical wrinkles

A handful of technical issues come up specifically when interviewers want to see whether you have actually built a merger model rather than just studied its output. Circularity is the most common: in a cash-and-debt-funded deal, interest expense on new debt reduces net income, which can affect a revolver balance used to plug a cash shortfall, which changes the interest expense again, creating a circular reference that spreadsheet software needs to be told explicitly to handle (typically through an iterative calculation setting or a circularity breaker). Knowing that this wrinkle exists, and why, is a good signal of hands-on modeling experience even if you cannot recite the exact mechanical fix from memory.

A second wrinkle is transaction fees and financing fees, which reduce the cash available at closing and are typically expensed or capitalized and amortized depending on the fee type and applicable accounting treatment, a small detail that nonetheless shows up in sources and uses and in the first year or two of pro forma earnings. A third is the treatment of the target's existing debt: whether it stays in place, gets refinanced as part of the deal, or triggers change-of-control provisions requiring repayment, each of which changes the sources and uses schedule and the combined company's post-close capital structure meaningfully.

Turning model output into a recommendation

None of this technical work matters if it does not resolve into an actual recommendation a client can act on. A banker presenting merger model output to a board is not simply reporting a number, they are translating a spreadsheet into a judgment: does this structure make sense given the acquirer's balance sheet capacity, is the implied price justified relative to the valuation range built independently, and what would need to be true for the deal to actually create the value being claimed. This is the same translation exercise that shows up throughout M&A work, connecting a technical output to a client's actual decision, discussed from the valuation side in how valuation works in a live deal and from the process side in the buy-side process, where a buy-side banker uses exactly this kind of model to establish the maximum defensible price before a bid ever goes out.

Interviewers who ask you to build or walk through a merger model are, underneath the mechanics, asking whether you can do this translation: take a set of assumptions, some solid, some genuinely uncertain, and turn them into a clear, honest answer about whether a deal makes sense and under what conditions that answer would change.

This same translation exercise looks different depending on which side of the table you are on. A banker advising the target in a sell-side process, covered in the sell-side process, start to finish, cares less about the acquirer's own accretion and dilution math and more about whether the acquirer's financing plan is credible enough that the deal will actually close on the terms proposed, since a deal that falls apart in financing after signing is a real risk to a seller's shareholders. A banker advising the acquirer cares directly about the model's own output, since it is the basis for what that client can defend internally. Recognizing which seat you would be advising from, and adjusting what the model needs to answer accordingly, is a small but telling signal of real process fluency in an interview setting.

Practice question

What do you think a merger model is actually testing, beyond whether a deal is accretive or dilutive?

The accretion and dilution output is really just the headline number, and on its own it doesn't tell a board very much, since a deal can be accretive purely because the financing is cheap, even if it's a bad deal, or dilutive in year one and still be the right long-term decision. What the model is actually testing is a set of judgment calls layered underneath that number. First, whether the deal is financeable at all, which is what a sources and uses schedule is for, checking whether the acquirer actually has the cash or debt capacity to fund the purchase without stretching its balance sheet past what lenders or rating agencies would tolerate. Second, how sensitive the conclusion is to assumptions nobody can know for certain at signing, mainly the synergy case and the financing terms, which is why a single base-case output matters much less than a sensitivity table showing a range of plausible outcomes. Third, whether the consideration structure, cash, stock, or some mix, allocates risk between the buyer and seller in a way both sides can live with. A merger model that produces a clean accretion number but skips these questions hasn't actually told a board whether the deal makes sense, it's just answered one narrow arithmetic question and left the real judgment calls unexamined.

What the interviewer is listening for: Whether you understand the merger model as a decision-support tool with real judgment embedded in it, rather than treating accretion and dilution as the whole exercise.

Practice this topic inside IB Atlas: spoken mock interviews graded by AI, built around exactly what interviewers ask.

Start free

More in M&A

Back to Breaking into M&A investment banking or the M&A investment banking interview questions.

Free question bank: 125 real interview questions with answers