M&A and private equity models

M&A and private equity modelling answers three questions about one transaction: what the buyer can pay, how the price is funded, and who receives what it returns. A leveraged buyout funds the price mostly with debt and judges it on the sponsor’s equity return. A merger is judged by the buyer’s shareholders, on whether earnings per share rise or fall once the deal closes. Purchase price allocation is the accounting that follows either one, marking the target’s assets to fair value and leaving goodwill as the balance. A cap table and exit waterfall settles the last question for a venture-backed company, dividing the sale proceeds among founders and every class of investor in order of preference.

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

On this subject: m&a and private equity.Updated 3 October 2026

The models

Preview the Merger arbitrage model: deal spread, break risk and position size workbook
Advanced11 sheets~45 minER/HFIB

Merger arbitrage model: deal spread, 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.

Preview the ICG management buyout model workbook
Advanced11 sheets~60 minPEIBER/HF

ICG management buyout model

Read a real management buyout from its announcement: separate equity value from enterprise value, cash from rollover, facilities from debt drawn and preferred from ordinary, and say what each class earns under the base, downside and upside cases.

Preview the Private equity fund model: cash flows, J-curve and waterfall workbook
Advanced12 sheets~45 minPEVCIB

Private equity fund model: cash flows, J-curve and waterfall

Build a buyout fund over its life: commitments called for ten investments, a management fee that steps down from committed capital to invested cost, and fund expenses; NAV marked on a stated path; a whole-fund waterfall with a compounding preferred return, a GP catch-up and an 80/20 split; then the LPs’ net cash flows, the J-curve in TVPI, DPI, RVPI and IRR by year, the bridge from gross to net, and the clawback a deal-by-deal waterfall would leave.

Preview the Private equity secondaries model: pricing an LP stake workbook
Advanced13 sheets~45 minPEIBER/HF

Private equity secondaries model: pricing an LP stake

Underwrite one LP stake in a mature buyout fund: price it as a percentage of reference NAV and settle the cash that moved before closing, project the calls on the unfunded commitment and the distributions from six named sales net of the fund’s carry, roll NAV forward and prove it, read the buyer’s IRR, multiple and peak capital at risk, solve the maximum bid for a target IRR in closed form and prove it, and see the price as the seller does.

Preview the Purchase price allocation model workbook
Advanced7 sheets~40 minIBPEER/HF

Purchase price allocation model

Allocate a purchase price across book assets, fair value write-ups and new intangibles, compute the deferred tax liability and goodwill in a stock deal and an asset deal, build the closing balance sheet, and say what the write-ups cost earnings and what a step-up is worth in cash.

Preview the Carve-out and standalone cost model workbook
Advanced11 sheets~50 minIBPE

Carve-out and standalone cost model

Rebuild a division’s cost base from the bottom, bridge reported EBITDA to run-rate standalone EBITDA, schedule the transition services and the months of double running, split the separation costs between the parties, and then read the sale from both sides: the sponsor’s funding, debt and IRR, and the seller’s tax leakage, stranded costs and real multiple. At the asking price of 8.5x run-rate standalone EBITDA the base case returns 12.9% against a 15% target, so the model’s answer is that the price is too high; the grid shows the price that would clear it, 7.5x.

Other areas: Core modelling · Credit and restructuring · Real estate · Infrastructure and project finance · Healthcare · Technology · Financial institutions · All 57 models

How to work through it

Start with the paper LBO lab, which sizes a deal and its return by hand in a few minutes. Then open the LBO model to see the same deal with a three-tranche debt schedule, a cash sweep and the return decomposed into growth, multiple and paydown. The merger model takes the strategic buyer’s side: change the share of stock in the consideration and watch accretion turn to dilution. The merger arbitrage model takes the other side of the same announcement, the investor who buys the target’s shares at a discount to the offer: it prices the spread, the hedge and the loss if the deal breaks. Purchase price allocation shows what the buyer’s balance sheet looks like the day after. The carve-out model comes before it when the target is a division of a larger group: it strips out the parent’s allocations, rebuilds the cost of running alone and reads the sale from both sides, the sponsor’s return and what the seller really nets. The cap table model shows how a sale is shared when the company was funded by venture rounds. The private equity fund model steps back from one deal to the fund that owns ten: capital calls, the J-curve, and the waterfall that divides the profit between the investors and the general partner. The secondaries model then prices one investor’s stake in a mature fund: a bid on reported NAV, the unfunded commitment that comes with it, and the most a buyer can pay for a target return. Each model has a starter workbook that leaves one schedule for you to build.

The mechanics they share

Each schedule is one reusable calculation, explained on its own page with the rows it occupies in every model that uses it.

Transaction schedules

Sources and uses

What the deal costs and who funds it

The statements

Revenue build

Where the top line comes from

Operating schedules

Capex and depreciation (PP&E roll-forward)

Opening, plus capex, less depreciation, closing

Operating schedules

Working capital schedule

Receivables, inventory and payables in days

The statements

Tax

Tax on profit, and tax on operating profit

The statements

Cash flow statement

Indirect method, closing on balance-sheet cash

Financing schedules

Debt schedule

Tranches, interest, amortisation and the sweep

Valuation and returns

Returns analysis

Exit value, MOIC, IRR and the bridge

Valuation and returns

Sensitivity tables

Two assumptions at once, without a data table

Transaction schedules

Purchase price and consideration

Offer, premium, mix, new shares, exchange ratio

Transaction schedules

Synergies

Run-rate, phase-in, after tax

Transaction schedules

Purchase accounting

The write-up that amortises

Transaction schedules

Pro forma EPS: accretion and dilution

Standalone to pro forma, per share

Transaction schedules

Contribution analysis

What each side brings against what it owns

Transaction schedules

Deal spread: gross, net of carry and annualised

Offer value, spread, carry and annualised return

Transaction schedules

The merger arbitrage hedge: shorting the acquirer

The short that hedges the stock leg of a deal

Transaction schedules

Break price analysis: what the target falls to

The break price, the loss per share and a higher bid

Transaction schedules

Implied deal probability: what the spread says

The odds of completion in the price, against yours

Transaction schedules

Arbitrage position sizing from the loss on a break

Position size, exposure and contribution to the fund

Valuation and returns

Enterprise value to equity value

Debt off, cash on, per share

Venture schedules

Exit waterfall

Preference or conversion, then what reaches the common

Financing schedules

Fund cash flows: commitments, capital calls and NAV

Commitments, calls, paid-in capital, proceeds, NAV

Financing schedules

Fund management fee: committed capital, then invested cost

The fee basis and rate before and after the step-down

Valuation and returns

Fund distribution waterfall: European and American carry

Capital, preferred return, catch-up, split, clawback

Valuation and returns

Fund performance: TVPI, DPI, RVPI, IRR and the J-curve

Net and gross multiples and IRR by year, gross to net

Transaction schedules

Secondary pricing: the bid, the interim cash flows and the deferral

Bid on NAV, interim adjustment, deferral, maximum bid

Financing schedules

Unfunded commitment: follow-on calls, fees and what is never called

Calls against the unfunded commitment and the share never drawn

Valuation and returns

NAV roll-forward: calls, value growth and distributions

Opening NAV, calls, growth, distributions, closing NAV

Valuation and returns

Secondary buyer returns: IRR, capital at risk and the day-one uplift

Buyer IRR, multiple, peak risk, uplift, time to return cost

Transaction schedules

Goodwill calculation

From the price to goodwill, through every write-up

Transaction schedules

Deferred taxes in an acquisition

The DTL on write-ups, its unwind, and the step-up

Transaction schedules

Closing balance sheet

Acquirer plus target plus adjustments, balanced

Venture schedules

Priced round and option pool

Pre-money to price per share, with the pool shuffle

Venture schedules

SAFE conversion

What a post-money SAFE turns into at the round

Transaction schedules

Standalone cost build: what a division costs to run alone

Functions rebuilt from heads, systems and third parties

Transaction schedules

TSA schedule: transition services, fees and double running

Terms in months, cost-plus fees, exits and overlap

Transaction schedules

Carve-out EBITDA bridge: reported to run-rate standalone

Reported EBITDA to run-rate, and the transition years

Transaction schedules

Stranded costs: what the seller cannot take out

Allocations the parent keeps, running off over time

Practise first

LBO Modelling Test · 60 min

Sit the one-hour test under a clock, in the browser or in your own workbook, and get every line of the build marked.

Paper LBO Trainer · 8 min

Solve MOIC and IRR in your head from a deal you have never seen, in under ten minutes.

Napkin LBO · 12 min

Sketch a full buyout by hand, from sources and uses through the debt paydown to the return, and say which bucket the return depends on.

IRR by Eye · 3 min

Say the IRR for any multiple and hold before the interviewer finishes the sentence, and the multiple for any IRR.

Capital Stack Challenge · 15 min

Finance a real buyout from revolver to equity, hold it through a shock, and explain every layer against the deal the sponsor actually did.

Accretion / Dilution Animator · 8 min

Call a deal accretive or dilutive from P/E, premium and financing mix before you open a model.

Options Payoff Lab · 8 min

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.

Cap Table Builder · 15 min

Convert a post-money SAFE, price a seed round and size an option pool by hand, and say who paid for the pool.

Exit Waterfall Lab · 12 min

Run a liquidation waterfall at any exit value, say where a preferred holder chooses to convert, and explain what a 1x non-participating preference actually costs the founders.

Three-Statement Linker · 8 min

Walk any event through all three statements in the right order, with the right signs, and prove the balance sheet balances rather than asserting it.

Depreciation Waterfall · 10 min

Forecast depreciation from a capex plan rather than a ratio, read a capex-to-depreciation multiple, and say which part of the spend is buying growth and which is only standing still.

Optimal Capital Structure · 15 min

Explain why more debt stops helping: watch coverage, rating and spread move as leverage rises until WACC turns.

DCF Builder · 15 min

Build a DCF by hand from revenue to a share price, know how much of it sits in the terminal value, and name the one assumption the answer hinges on.

EV to Equity Bridge · 12 min

Walk from enterprise value to a price per share without dropping a claim: net debt, pensions, minorities, leases and options.

Where this work is done

Investment Banking

Advise on M&A and capital raising. The training ground the rest of the map feeds off.

How to get in and prepare
Private Equity

Buy control of established companies using debt, improve them, sell them.

How to get in and prepare
Growth Equity

Minority stakes in companies that already work and need capital to scale. Between PE and VC.

Corp Dev / M&A

Buy companies for an operator. The modelling is banking; the judgement is not.

How to get in and prepare
Venture Capital

Early-stage minority investing. Judgement about people and markets, far less modelling.

How to get in and prepare

Read

The vocabulary

Questions

What is the difference between an LBO model and a merger model?

They are judged by different owners. An LBO is judged by a financial sponsor on its equity return, so the model ends in an IRR and a multiple of money, and debt does most of the funding. A merger is judged by the buyer’s existing shareholders, so the model ends in earnings per share against the standalone case, and whether the deal is paid in cash or shares decides most of the answer.

Why does purchase price allocation sit with these models?

Because every acquisition ends in one. Once a buyer pays, the target’s assets and liabilities are restated at fair value, new intangible assets are recognised, deferred taxes follow, and goodwill takes up what is left of the price. The amortisation of those intangibles is what the merger model’s accretion test is often most sensitive to.

Which of these do interviews test?

Private equity interviews test the LBO: a paper LBO by hand and a modelling test at a desk. Banking interviews test accretion and dilution and the mechanics of a purchase price allocation. Venture interviews test liquidation preferences and the waterfall. The labs drill each one, and every model page lists the mistakes a reviewer looks for.