M&A and private equityAdvanced · ~45 minWorking draft · 11 sheets · 575 formulas

Merger arbitrage model: deal spread, break risk and position size

Deal spread, the hedge, break risk and position size. Price the target’s shares in an announced cash-and-stock deal: the offer value and the spread net of dividends, borrow and financing, the short that hedges the stock leg, the price the target falls to if the deal breaks, the probability of completion the price implies against your own, how the return erodes if completion slips toward the long-stop date, and the largest position a loss budget allows.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: merger arbitrage model: deal spread, break risk and position size.Updated 14 November 2026

Who builds it, and for whatThe model an event-driven fund keeps for each announced deal it considers, and that an equity research analyst or a banker covering the target rebuilds to say what the market thinks of a bid. The portfolio manager uses it to decide whether the spread pays enough for the chance that the deal breaks, and the risk team reads the same sheet for how much the fund loses if it does. It is the other side of the merger model: that one asks whether the acquirer’s shareholders gain, this one prices the target’s shares between the announcement and the day the deal closes.

Every sheet below, in your browser, with its outputs and checks

Starter workbook free with an account. Worked model: one a month with Plus, every one with Pro. Downloads

Inspect the workbook
All checks read zero100%
Every value, every sheet, as the workbook holds it.
ABCDEFGHIJKLMNOPQRSTU
1Assumptions
2$ per target share unless stated. Months run from today; the last column is the long-stop date. The target, the acquirer and the offer are invented.
4MonthUnitM0M1M2M3M4M5M6M7M8M9M10M11M12M13M14M15M16Notes
5Month#012345678910111213141516Months from today. Drives the carry, the discounting and the timeline.
7Scenario
8Scenario#11 = base (completes on time), 2 = regulatory delay (a second request), 3 = competing bid. Selects a column of each driver on the Scenarios sheet.
10Offer terms
11Cash per target share$ per share24.00The cash leg of the offer.
12Exchange ratio, acquirer shares per target shareshares0.40The stock leg: 0.40 acquirer shares for each target share.
13Acquirer share price, today$ per share60.00Values the stock leg today and is the price the short is opened at.
14Target share price, today$ per share44.00What the long costs. The market’s price, the same in every scenario.
15Target unaffected share price$ per share34.00Before the offer was announced.
16Contingent value right, value per target share if paid$ per share-Optional extra paid at completion if a milestone is met. Nil in the base; enter a value to switch it on.
17Probability the contingent value right pays%40.0%Expected value = probability x value. Has no effect while the value is nil.
19Carry and the hedge
20Financing cost of the long, annual%5.0%What the prime broker charges to carry the target shares. Also the discount rate for the implied probability.
21Stock borrow cost on the short, annual%1.0%On the value of the acquirer shares borrowed, at today’s price.
22Hedge ratio, % of the stock leg sold short%100.0%100% is a full hedge. Below it the position keeps some of the acquirer’s risk.
23Dividend per target share, by month paid$ per share--0.20--0.20--0.20--0.20--0.20--Received by the long if paid on or before the completion month. Quarterly.
24Dividend per acquirer share, by month paid$ per share-0.45--0.45--0.45--0.45--0.45--0.45Paid by the short on the shares borrowed, which are the exchange ratio x the hedge ratio per target share.
25Long-stop monthmonth16The date after which either side can walk away. The last column of the workbook.
27If the deal breaks
28Sector move since announcement%-4.0%How the target’s peers have moved since the day before the offer. Negative is a fall.
29"Damaged goods" discount to the unaffected price%6.0%A failed deal leaves a company that has been in play, with unsettled staff and customers, trading below its peers.
30Acquirer share price move if the deal breaks%5.0%Positive: the acquirer rises when the deal fails, which costs the short.
32The fund and its limits
33Fund net asset value$m2,500.0Capital the position is sized against.
34Maximum loss on a break, % of NAV%1.0%The risk budget for one deal: what the fund will lose if it breaks.
35Concentration limit, long position % of NAV%12.0%A cap on the position whatever the risk budget allows.

Select a cell to see its row, its schedule and the type of cell. Font colours: blue for inputs, black for formulas, green for links to other sheets. Scroll sideways to see every period.

Download

Merger arbitrage model: deal spread, break risk and position size: the workbook

An Excel workbook with working formulas, no macros and no external links: the same model you can work with on this page.

  1. Browse without an accountPreview every model online, sheet by sheet, with its outputs and checks.
  2. Free accountWork with every model online: change the inputs, switch the case, see every formula. And every starter workbook, with its key schedules left blank to build.
  3. L3VLUP Plus$4.99/monthEverything in Free, and one worked model each billing month as an Excel file: every schedule built, formulas live, checks at zero, yours to keep.
  4. L3VLUP Pro$25/monthEverything in Plus, every worked model in the library, and the Pro applications.
The worked model
11 sheets and 575 live formulas, all 6 schedules built and linked, every check reading zero. Change an input in Excel and the whole model moves.
The starter
The same inputs and layout with the break price analysis: what the target falls to and the implied deal probability: what the spread says left blank for you to build, each blank cell marked. The worked model is its answer.

What the base case says

Gross spread, % of price
9.1%
Net spread after carry, % of price
5.1%
Net spread, annualised (compounded)
6.8%
Break price per share
30.68
Loss per share on a break
16.29
Market-implied probability of completion
82.9%
Own probability of completion, any terms
92.0%
Edge, own less implied
9.1%
Expected profit per share
0.81
Expected annualised return
2.5%
Break-even probability of completion
88.0%
Expected annualised return if completion slips to the long-stop
-1.3%
Maximum long position
$67.5m
Gross exposure, % of NAV
4.2%
Expected contribution to the fund (bp of NAV)
4.96

Read from the workbook as served, every input at its default. Periods: M0, M1, M2, M3, M4, M5, M6, M7, M8, M9, M10, M11, M12, M13, M14, M15, M16. The figures are invented and move with whatever you type in.

What this model is

A monthly model of an event-driven position in an invented listed target, bought at a discount to an invented cash-and-stock offer and held until the deal completes or breaks. Months run from today to the long-stop date.

The offer value is the cash, the exchange ratio at the acquirer’s price and an optional contingent value right. The gross spread is that value less the price today; the net spread is after dividends received on the long, dividends paid on the short, stock borrow and the cost of financing the long to the expected completion month, with simple and compounded annualised returns.

The stock leg is hedged by selling the acquirer’s shares short. A small table moves the acquirer up and down and shows the unhedged spread following it while the hedged spread does not move. The break analysis prices the target if the deal fails from its unaffected price, a sector move and a damaged-goods discount, charges the short for the acquirer’s rebound and gives the loss per share and the higher-bid case.

The price implies a probability of completion, on present values at the financing rate; the investor’s own probability sits beside it, with the expected profit, the expected annualised return and the break-even probability. A monthly timeline shows the carry and what the return becomes if completion slips toward the long-stop date. The position is sized so that a break costs no more than a stated share of the fund.

Three scenarios (the deal completes on time, a regulatory delay, a competing bid) and one board-style grid: expected annualised return by probability of completion and months to completion. Collars, tender offers with proration and election mechanics are not modelled.

Seats: Equity research and hedge funds, Investment banking.

Careers that do this work: investment banking, private equity, growth equity, corp dev / m&a, venture capital.

How the schedules connect

Every row in the workbook is tagged with the schedule it belongs to; the inspector above shows the tag when you click a row. These are the schedules this model is made of and where each one lives.

What you should be able to explain

  • Why the gross spread overstates what the position earns: dividends on both shares, the cost of borrowing the acquirer’s stock and the cost of financing the long all come out of it, and time does most of the damage.
  • Why the stock leg is hedged by selling the acquirer short, and what the hedge does and does not remove: the acquirer’s moves, but not the risk that the deal fails.
  • How the break price is built from the unaffected price, what the sector has done since, and a discount for a company that has been in play and was not sold.
  • What the spread implies about the odds of completion, and why that implied probability and the investor’s own are the whole argument.
  • Why a delay is a loss even when the deal is still certain: the spread does not widen to pay for the extra months.
  • Why position size follows from the loss on a break and not from the size of the spread.

What a reviewer looks for

  • Quoting the gross spread, or its simple annualisation, as the return, with no dividends, borrow or financing taken off.
  • Treating a stock-for-stock spread as fixed while leaving the acquirer unhedged, so the position is also a bet on the acquirer’s share price.
  • A break price equal to the unaffected price, with no allowance for the sector’s move or for what a failed deal does to the company.
  • Leaving the loss on the short out of the break case: the acquirer usually rises when the deal is called off.
  • Sizing the position from the spread or the expected return instead of from the most the fund can lose on a break.
  • Assuming completion on the expected date and never asking what a second request does to the annualised return.

Conventions this workbook uses

Stated on the cover sheet too. A model is only as trustworthy as the decisions it tells you it made.

  • Months from today (M0 to M16); the last column is the long-stop date. Values are in dollars per target share unless a row says otherwise. The position is a long of one target share against a short of the exchange ratio x the hedge ratio in acquirer shares.
  • Every return is an excess return. The long is financed at the financing rate and that cost is inside the carry, so the net spread and the annualised returns are what the position earns above its own funding. Annualised simple is the return x 12 / months; compounded is (1 + return) ^ (12 / months) - 1.
  • Carry to the expected completion month: dividends on the long paid in months up to and including it; dividends on the acquirer shares borrowed, paid by the short in the same months; financing on the price today and stock borrow on the short at today’s price, both accruing evenly by month.
  • Offer value = cash + exchange ratio x acquirer price today + probability x value of the contingent value right, which is nil in the base case. The stock leg is valued at today’s price; the hedge is what makes that safe.
  • The break price is the unaffected price x (1 + the sector’s move since announcement) x (1 - the damaged-goods discount). A break is called on the date the deal was to close, so the carry to the break is the carry to the expected completion month. The acquirer’s rebound is a loss on the short.
  • Loss per share on a break = price today - break price + loss on the short - net carry. Net spread and loss give the break-even probability of completion at current terms: loss / (net spread + loss).
  • Market-implied probability = (price - break value) / (deal value - break value), each on present values at the financing rate, with the target’s dividends to completion in both. It is read from the target alone, before the hedge, as the market quotes it. It ignores a higher bid, so the edge against the investor’s completion probability is the cautious comparison.
  • Expected profit per share = probability of completion at current terms x the net spread + probability of a higher bid x the net spread on it + probability of a break x the loss, each with the carry to the month in question. Higher-bid and completion outcomes close in the same month.
  • The position is the smaller of the risk-budget size (budget / loss per share) and the concentration limit. Gross exposure is the long plus the short; net exposure is the long less the short. The expected contribution is the expected profit on the position over NAV, in basis points.
  • Nothing is circular: the carry is built from the price today and the Timeline is read by position in its columns. The scenarios change the investor’s view; the price today and the offer are the same in all three.

What this model does not cover

Where its answer stops, so you know what to add before relying on it.

  • Collars, where the exchange ratio floats inside a band around the acquirer’s price. Here the ratio is fixed, so the stock leg moves one for one with the acquirer.
  • Tender offers with proration and election mechanics, where holders choose between cash and stock and the choice is scaled back. Every share receives the same package.
  • Break fees, reverse break fees and the legal timetable of a particular deal. A break is a price and a probability, not a clause.
  • A break that arrives on a date other than the expected completion. Every outcome is taken to resolve in the same month.
  • Mark-to-market of the hedge through the period, margin calls and the borrow becoming scarce. The short is opened at today’s price and its cost is a flat rate.
  • A real deal. The target, the acquirer and every figure are invented; the Finance OS Transaction Analysis workflow reads real deals from their filings.

Build it yourself

The starter workbook

The Break Analysis and Implied Probability sheets have been cleared: the break price from the unaffected price, the sector move and the damaged-goods discount, the loss on the short, the loss per share on a break and the higher-bid case; then the present values, the probability the price implies, the investor’s own view, the edge, the expected profit and return and the break-even probability. Rebuild them from the Assumptions, Deal Spread, Hedge and Timeline sheets, then switch to the regulatory delay and watch the carry of five more months turn a positive expected return negative.

Blanks: Break price analysis: what the target falls to, Implied deal probability: what the spread says. Download it beside the worked model.

The path around this model

Understand it, drill it, read the build, then apply it to a real company.

Vocabulary: Merger Arbitrage, Deal Spread, Merger Model, Break Fee, Catalyst, Position Sizing, Long / Short (Equity), Gross Exposure, Net Exposure.

Questions about this model

What is the spread, and why is the net spread so much smaller?

The invented offer is worth $48.00 a target share: $24.00 in cash and 0.40 acquirer shares at $60.00. With the target at $44.00 the gross spread is $4.00, 9.1% of the price. Over nine months to the expected completion the carry takes $1.77 of it: $0.60 of dividends are received on the long and $0.54 paid on the short, financing the long costs $1.65 and borrowing the acquirer’s shares $0.18. That leaves a net spread of $2.23, 5.1% of the price and 6.8% annualised on a compounded basis. It is a return above the position’s own funding, because the financing cost is already inside it.

What does the hedge do?

The stock leg is $24.00 of the offer, so the position sells 0.40 acquirer shares short for each target share held. If the acquirer falls 10% before completion the offer is worth $2.40 less and an unhedged spread of $4.00 shrinks to $1.60; if it rises 10% the spread grows to $6.40. With the short in place the spread is $4.00 in every column of the table. The hedge removes the acquirer from the position. It does nothing about a break, and on a break the short is a cost: the acquirer rebounds and the short loses.

How much is lost if the deal breaks, and how big can the position be?

The break price is the $34.00 unaffected price moved with a sector that has fallen 4% and cut by a 6% damaged-goods discount: $30.68. The long loses $13.32, a 5% rebound in the acquirer costs the short $1.20 and the net carry another $1.77, so a break costs $16.29 a share. Against it the net spread earns $2.23, about 14 cents for each dollar at risk, so the deal pays only if it completes with a probability above 88.0%. The price implies 82.9% and the investor’s own view of completion on any terms is 92.0%, an edge of 9.1 points. A loss budget of 1.0% of a $2,500 million fund is $25.0 million, which allows 1.53 million target shares, a $67.5 million long (2.7% of NAV) and gross exposure of 4.2% of NAV. The expected profit is $0.81 a share, 2.5% annualised, 5.0 basis points of NAV.

What happens in a regulatory delay and in a competing bid?

A second request pushes completion from month 9 to month 14 and cuts the investor’s probability of completion from 92.0% to 83.0%. The carry of five more months leaves a net spread of 2.8% against a price that has not moved, the break-even probability rises to 93.2% and the expected annualised return falls to -3.6%: the deal still looks likely to close and no longer pays. Even in the base case the return erodes with each month of slippage, to -1.3% if completion drifts to the long-stop in month 16, and it stays above nil only until month 12. In the competing-bid case the probability of a higher bid rises from 3% to 30%, the size of the bid from $2.00 to $5.00 and the expected annualised return to 7.2%.

Related models

Questions about this model

Discussions open here soon.

All discussions

Share your result 📊

𝕏in💬🤖

Instagram and TikTok have no desktop share link, so copy the caption and paste it into the app.