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
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Assumptions | ||||||||||||||||||||
| 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. | ||||||||||||||||||||
| 4 | Month | Unit | M0 | M1 | M2 | M3 | M4 | M5 | M6 | M7 | M8 | M9 | M10 | M11 | M12 | M13 | M14 | M15 | M16 | Notes | |
| 5 | Month | # | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | Months from today. Drives the carry, the discounting and the timeline. | |
| 7 | Scenario | ||||||||||||||||||||
| 8 | Scenario | # | 1 | 1 = base (completes on time), 2 = regulatory delay (a second request), 3 = competing bid. Selects a column of each driver on the Scenarios sheet. | |||||||||||||||||
| 10 | Offer terms | ||||||||||||||||||||
| 11 | Cash per target share | $ per share | 24.00 | The cash leg of the offer. | |||||||||||||||||
| 12 | Exchange ratio, acquirer shares per target share | shares | 0.40 | The stock leg: 0.40 acquirer shares for each target share. | |||||||||||||||||
| 13 | Acquirer share price, today | $ per share | 60.00 | Values the stock leg today and is the price the short is opened at. | |||||||||||||||||
| 14 | Target share price, today | $ per share | 44.00 | What the long costs. The market’s price, the same in every scenario. | |||||||||||||||||
| 15 | Target unaffected share price | $ per share | 34.00 | Before the offer was announced. | |||||||||||||||||
| 16 | Contingent 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. | |||||||||||||||||
| 17 | Probability the contingent value right pays | % | 40.0% | Expected value = probability x value. Has no effect while the value is nil. | |||||||||||||||||
| 19 | Carry and the hedge | ||||||||||||||||||||
| 20 | Financing 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. | |||||||||||||||||
| 21 | Stock borrow cost on the short, annual | % | 1.0% | On the value of the acquirer shares borrowed, at today’s price. | |||||||||||||||||
| 22 | Hedge 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. | |||||||||||||||||
| 23 | Dividend 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. | |
| 24 | Dividend per acquirer share, by month paid | $ per share | - | 0.45 | - | - | 0.45 | - | - | 0.45 | - | - | 0.45 | - | - | 0.45 | - | - | 0.45 | Paid by the short on the shares borrowed, which are the exchange ratio x the hedge ratio per target share. | |
| 25 | Long-stop month | month | 16 | The date after which either side can walk away. The last column of the workbook. | |||||||||||||||||
| 27 | If the deal breaks | ||||||||||||||||||||
| 28 | Sector 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. | |||||||||||||||||
| 30 | Acquirer share price move if the deal breaks | % | 5.0% | Positive: the acquirer rises when the deal fails, which costs the short. | |||||||||||||||||
| 32 | The fund and its limits | ||||||||||||||||||||
| 33 | Fund net asset value | $m | 2,500.0 | Capital the position is sized against. | |||||||||||||||||
| 34 | Maximum loss on a break, % of NAV | % | 1.0% | The risk budget for one deal: what the fund will lose if it breaks. | |||||||||||||||||
| 35 | Concentration 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.
- Browse without an accountPreview every model online, sheet by sheet, with its outputs and checks.
- 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.
- 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.
- 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.
Deal spread: gross, net of carry and annualised
Offer value, spread, carry and annualised return
Assumptions, rows 11–17 · Deal Spread, rows 6–11 · Deal Spread, rows 14–19 · Deal Spread, rows 22–26 · Deal Spread, rows 29–33 · Timeline, rows 6–8 · Timeline, rows 11–15 · Timeline, rows 18–22 · Timeline, rows 25–30 · Timeline, rows 33–41
The merger arbitrage hedge: shorting the acquirer
The short that hedges the stock leg of a deal
Assumptions, rows 20–25 · Hedge, rows 6–9 · Hedge, rows 12–23
Break price analysis: what the target falls to
The break price, the loss per share and a higher bid
Assumptions, rows 28–30 · Break Analysis, rows 6–12 · Break Analysis, rows 15–20 · Break Analysis, rows 23–28
Implied deal probability: what the spread says
The odds of completion in the price, against yours
Implied Probability, rows 6–11 · Implied Probability, rows 14–18 · Implied Probability, rows 21–29
Arbitrage position sizing from the loss on a break
Position size, exposure and contribution to the fund
Assumptions, rows 33–35 · Sizing, rows 6–15 · Sizing, rows 18–23 · Sizing, rows 26–31
Sensitivity tables
Two assumptions at once, without a data table
Sensitivity, rows 5–6 · Sensitivity, rows 9–15 · Sensitivity, rows 18–23 · Sensitivity, row 26
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.
Build · Lab · ~8 min
Accretion / Dilution Animator
Call a deal accretive or dilutive from P/E, premium and financing mix before you open a model.
Build · Lab · ~8 min
Options Payoff Lab
Draw a call and a put payoff from memory, separate payoff from profit by the premium that was paid, and say which side of which contract has a loss with no ceiling on it.
Read · Guide · 14 min
How to Build a Merger Model: Purchase Accounting, Financing and Accretion
Read · Guide · 8 min
Hedge Fund Interview Questions Beyond the Stock Pitch
Read · Guide · 10 min
Scenario and Sensitivity Architecture: Building a Model That Can Be Stress-Tested
Read · Guide · 7 min
Enterprise Value vs. Equity Value, Once and For All
Apply · Skill
Model Audit
Find the errors in a financial model before someone senior does.
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
M&A and private equity · Core
Merger model: accretion and dilution
Is the deal accretive, and what would break even
Core modelling · Core
Comparable companies model
Calendarised, LTM, trading and transaction multiples
M&A and private equity · Advanced
Purchase price allocation model
Goodwill, write-ups, deferred tax, stock vs asset deal
Questions about this model
Discussions open here soon.