Leveraged buyout model
Size a deal, run its debt schedule with a sweep, and decompose the return into EBITDA growth, multiple change and net debt reduction.
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
Size a deal, run its debt schedule with a sweep, and decompose the return into EBITDA growth, multiple change and net debt reduction.
Price an offer, fund it, and say whether it is accretive, by how much, and how much synergy it would take to break even.
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.
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.
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.
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.
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.
Price a seed round with a converting SAFE and a pool top-up, say who paid for the pool, and run the exit waterfall for a non-participating preferred.
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
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.
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
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.
Advise on M&A and capital raising. The training ground the rest of the map feeds off.
How to get in and prepareBuy control of established companies using debt, improve them, sell them.
How to get in and prepareMinority stakes in companies that already work and need capital to scale. Between PE and VC.
Buy companies for an operator. The modelling is banking; the judgement is not.
How to get in and prepareEarly-stage minority investing. Judgement about people and markets, far less modelling.
How to get in and prepareThey 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.
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.
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.