Private equity secondaries model: pricing an LP stake
Bid on NAV, unfunded commitment, roll-forward, buyer IRR. 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.
By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.
On this subject: private equity secondaries model: pricing an lp stake.Updated 14 November 2026
Who builds it, and for whatThe model a secondaries team keeps for every stake it is shown, and the one a fund of funds, a pension plan or an insurer builds to see what its own interest would fetch. The buyer uses it to decide what percentage of reference-date NAV to bid, and to say how much of that answer rests on the exit multiples, on the timing of the sales and on a deferred payment. The seller’s adviser reads the same cash flows from the other side to show what the liquidity costs. Because the buyer also takes on the commitment the seller never paid, the unfunded balance and the calls that will be made against it are in the price from the first line.
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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Assumptions | ||||||||||||
| 2 | $m unless stated. Annual periods from closing; every cash flow falls at a year end. All figures are illustrative. | ||||||||||||
| 4 | Year | Unit | Close | Y1 | Y2 | Y3 | Y4 | Y5 | Y6 | Y7 | Y8 | Notes | |
| 5 | Years from closing | # | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | Close = 0, the date the stake transfers. Drives exit years, fees and discounting. | |
| 7 | Scenario | ||||||||||||
| 8 | Scenario | # | 1 | 1 = base, 2 = exits delayed and lower multiples, 3 = strong exit market. Selects a case on the Scenarios sheet. | |||||||||
| 10 | The stake and the fund | ||||||||||||
| 11 | LP commitment to the fund | $m | 100.0 | What the seller agreed to pay in over the fund’s life. | |||||||||
| 12 | Paid-in capital at the reference date | $m | 85.0 | Capital the seller has contributed to date. The rest is the unfunded commitment, and it passes to the buyer. | |||||||||
| 13 | Fund age at the reference date | years | 6.0 | Years since the first close. | |||||||||
| 14 | Fund term | years | 10.0 | Contractual life from the first close. | |||||||||
| 15 | Extensions available | years | 2.0 | Years the manager may add, usually with the advisory committee’s consent. | |||||||||
| 16 | Reference date to closing | years | 0.5 | Reported NAV is struck months before the deal closes. Used for the fund’s remaining life. | |||||||||
| 18 | The price | ||||||||||||
| 19 | Bid, % of reference-date NAV | % | 88.0% | The headline price before the interim cash flows. | |||||||||
| 20 | Deferred payment, share of the price | % | 25.0% | Paid to the seller later, with no interest. Nil is the whole price at closing. | |||||||||
| 21 | Deferred payment, years after closing | years | 2 | A whole year from 1 to 8. | |||||||||
| 22 | Buyer’s transaction costs, % of the price | % | 0.5% | Legal, diligence and transfer costs, paid at closing. | |||||||||
| 23 | Target IRR | % | 15.0% | The return the buyer’s investment committee requires. | |||||||||
| 24 | Seller’s cost of capital | % | 16.0% | The return the seller could earn redeploying the cash, or the cost of the capital the stake ties up. Used only in the seller view. | |||||||||
| 26 | The fund’s terms | ||||||||||||
| 27 | Management fee, on the cost of investments held | % | 1.5% | A year, on the cost of the companies still held at the start of the year, charged to the stake as a capital call. | |||||||||
| 28 | Effective carry rate | % | 15.0% | Applied to the fund’s proceeds above the total cost of what remains. Below the headline 20% because part of the carry has already been paid or accrued. | |||||||||
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
Private equity secondaries model: pricing an LP stake: 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
- 13 sheets and 1,172 live formulas, all 5 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 secondary buyer returns: IRR, capital at risk and the day-one uplift left blank for you to build, each blank cell marked. The worked model is its answer.
What the base case says
- Buyer IRR
- 15.4%
- Maximum bid for the target IRR, % of reference NAV
- 88.5%
- Purchase price
- $65.5m
- Multiple on invested capital (x)
- 1.29
- Buyer IRR, no deferral
- 12.3%
- What the deferral adds to the IRR
- 3.0%
- Peak capital at risk, including the unfunded commitment
- $78.8m
- Day-one uplift: NAV bought less the price paid
- $9.0m
- Years to get the cost back
- $2.7m
- Share of the unfunded commitment never called
- 24.4%
- Seller’s implied annual cost of liquidity
- 15.7%
- Lowest bid the seller would take, % of reference NAV
- 87.5%
- IRR at the maximum bid
- 15.0%
Read from the workbook as served, every input at its default. Periods: Close, Y1, Y2, Y3, Y4, Y5, Y6, Y7, Y8. The figures are invented and move with whatever you type in.
What this model is
A nine-column model (Close, then Y1 to Y8) of an invented LP stake in a mature buyout fund: $100 million committed, $85 million paid in, $75 million of reported NAV across six remaining companies and $13 million still to be called once the seller’s interim call is settled.
The question is what percentage of reference-date NAV to bid. The price is the bid on NAV adjusted dollar for dollar for the call the seller paid and the distribution it received since the reference date, with a quarter of it deferred two years and the buyer’s costs on top.
Distributions come from six named sales, each an expected hold and a multiple of NAV, net of an effective carry rate applied above the fund’s total cost; the last company is a tail asset that sells below its NAV. The buyer is called for follow-ons and the management fee out of the unfunded commitment, and part of it is never called.
The Buyer Returns sheet gives the IRR with and without the deferral, the multiple on invested capital, the peak capital at risk with the unfunded commitment, the day-one NAV uplift (accounting, not cash) and the years to get the cost back. The Pricing sheet solves the maximum bid for a target IRR in closed form and proves it by bidding that price. The Seller View sheet shows what the seller pays for the liquidity.
Three scenarios (base, exits delayed two years at lower multiples, and a strong exit market) and two board-style tables: buyer IRR by bid and exit multiple adjustment, and the maximum bid by target IRR and exit multiple adjustment.
Seats: Private equity, Investment banking, Equity research and hedge funds.
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.
Secondary pricing: the bid, the interim cash flows and the deferral
Bid on NAV, interim adjustment, deferral, maximum bid
Assumptions, rows 11–16 · Assumptions, rows 19–24 · Portfolio, rows 6–7 · Portfolio, rows 10–11 · Portfolio, rows 14–17 · Pricing, rows 6–15 · Pricing, rows 18–20 · Pricing, rows 23–33 · Pricing, rows 36–41 · Realisations, rows 33–37 · Seller View, rows 6–8 · Seller View, rows 11–15 · Seller View, rows 18–24
Unfunded commitment: follow-on calls, fees and what is never called
Calls against the unfunded commitment and the share never drawn
Assumptions, rows 27–28 · Unfunded Commitment, rows 6–10 · Unfunded Commitment, rows 13–23
NAV roll-forward: calls, value growth and distributions
Opening NAV, calls, growth, distributions, closing NAV
Portfolio, rows 20–23 · Portfolio, rows 26–41 · Realisations, rows 15–21 · Realisations, rows 24–30 · NAV Roll-Forward, rows 6–13 · NAV Roll-Forward, rows 16–17
Secondary buyer returns: IRR, capital at risk and the day-one uplift
Buyer IRR, multiple, peak risk, uplift, time to return cost
Buyer Returns, rows 6–12 · Buyer Returns, rows 15–21 · Buyer Returns, rows 24–28 · Buyer Returns, rows 31–38 · Buyer Returns, rows 41–42
Sensitivity tables
Two assumptions at once, without a data table
Sensitivity, rows 5–7 · Sensitivity, rows 10–15 · Sensitivity, rows 19–24 · Sensitivity, row 27
What you should be able to explain
- Why a secondary is priced as a percentage of reference-date NAV, and why a bid of 88% is a view on exit multiples and timing, not a rule of thumb.
- How the price is adjusted for what happened between the reference date and closing: calls the seller paid are added back, distributions it received come off.
- What the unfunded commitment is to a buyer: a liability that is called for follow-ons and fees, partly never called, and counted in the capital at risk.
- Why distributions should come from named realisations, each with a hold and a multiple of NAV, and what a tail asset that sells below NAV does to the portfolio.
- How the fund’s carry is carried as a haircut on proceeds above the fund’s total cost, and what that simplification leaves out.
- Why the maximum bid is solved in closed form, why deferring part of the price raises the buyer’s IRR, and why the day-one NAV uplift is accounting and not cash.
What a reviewer looks for
- A bid struck on NAV at closing and not on the reference-date NAV the market quotes, so the interim calls and distributions are counted twice or not at all.
- The unfunded commitment ignored, so the price looks like the whole cost when the buyer will be called for follow-ons and fees for years.
- Distributions from one smooth return on NAV, which hides that the sales are lumpy, that the tail asset sells low and that a delay costs a year of fees.
- Carry taken on every winner and never set against the losers, when the fund as a whole must recover its cost first.
- A NAV roll-forward that does not tie to the carrying value of each company, or that counts the fee as an investment.
- The day-one uplift quoted as return, when it is the discount to NAV recognised and no cash has moved.
- A maximum bid that discounts the post-closing flows but forgets the buyer’s costs and the discounting of the deferred piece.
Conventions this workbook uses
Stated on the cover sheet too. A model is only as trustworthy as the decisions it tells you it made.
- Annual periods from closing. Close is year 0, the date the stake transfers; every other cash flow falls at a year end. Reported NAV is struck half a year before closing, and the interim cash flows are settled in the price.
- The price is the bid on reference-date NAV, plus the calls the seller paid and less the distributions it received since that date. The buyer’s NAV at closing is reference NAV plus those calls less those distributions: no value change is assumed in the interim.
- Each company is sold in one year at a stated multiple of its NAV at closing plus any follow-on, and its carrying value moves in a straight line from NAV to exit value. Distributions come from those sales only; there are no dividends or part-sales after closing.
- The fund’s carry is a haircut and not a waterfall: an effective rate on the fund’s cumulative proceeds above the total cost of the companies and follow-ons, so the tail asset’s loss is set against the winners before any carry is charged. Fees are not netted against profit for this purpose. The private equity fund model builds the whole waterfall.
- The management fee is a rate on the cost of the companies held at the start of each year, and every dollar of it is a capital call. Follow-ons are called in the years set on the Portfolio sheet. Calls may not exceed the unfunded commitment; what is left is never called.
- A deferred payment is a share of the price paid in a later year with no interest. The seller, not the buyer, bears the time value, so deferral raises the buyer’s IRR for the same price.
- The maximum bid is the price at which the post-closing flows discounted at the target IRR equal the cost of the stake: the flows divided by (one less the deferred share, plus the deferred share discounted, plus the costs), less the interim adjustment, over reference NAV.
- The day-one uplift is NAV at closing less the price. It is the discount to reference NAV, recognised in the reported multiple on day one. It is accounting, not cash, and it is a gain only if the NAV is right.
- The seller’s implied cost of liquidity is the rate at which the price it receives equals the cash flows it gives up, which is the buyer’s IRR before the buyer’s costs. A scenario changes when the companies are sold and at what multiple, never the price.
What this model does not cover
Where its answer stops, so you know what to add before relying on it.
- Continuation vehicles and other GP-led deals, where the manager sits on both sides of the price, a fairness opinion is needed and existing investors choose between selling and rolling.
- The fund’s waterfall. Carry is an effective rate applied above the fund’s total cost; the private equity fund model builds the whole waterfall, the clawback and the deal-by-deal comparison.
- The portfolio companies. Each is a NAV, a cost, a hold and a multiple of NAV at exit; the LBO model builds one from its operations and debt.
- Portfolios of stakes in several funds, and tail-end deals with a single dominant asset. The model prices one interest in one fund.
- Fund-level expenses, the subscription credit line, recycling, and the tax and withholding on distributions. The fee is one rate on the cost of the companies held.
- A change in value between the reference date and closing. Reference NAV rolls to closing for the interim calls and distributions and nothing else.
- A real fund. Secondary market pricing reports are the natural source for a case; this model uses invented figures.
Build it yourself
The starter workbook
The Buyer Returns sheet has been cleared: the price and costs paid at closing, the deferred payment, the net cash flow, the cumulative cash, the IRR with and without the deferral, the multiple on invested capital, the capital at risk with the unfunded commitment, the day-one uplift and the reported multiple, and the years to get the cost back. Rebuild them from the price on the Pricing sheet and the net cash flow after closing on the Realisations sheet, then switch to the delayed-exit case and find the bid at which the IRR meets the target.
Blanks: Secondary buyer returns: IRR, capital at risk and the day-one uplift. 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.
Understand · Primer
LBO Mechanics & Returns
Intermediate · a curated reel with a quiz
Build · Lab · ~3 min
IRR by Eye
Say the IRR for any multiple and hold before the interviewer finishes the sentence, and the multiple for any IRR.
Build · Lab · ~8 min
Paper LBO Trainer
Solve MOIC and IRR in your head from a deal you have never seen, in under ten minutes.
Read · Guide · 10 min
Private Equity vs Venture Capital: What Each One Is Actually Buying
Read · Guide · 15 min
How to Build an LBO Model: The Build Order That Survives a Modelling Test
Read · Guide · 10 min
Scenario and Sensitivity Architecture: Building a Model That Can Be Stress-Tested
Apply · Skill
IC Memo Builder
Draft a first-pass investment committee memo that anticipates the committee’s questions.
Apply · Skill
Model Audit
Find the errors in a financial model before someone senior does.
Vocabulary: Unfunded Commitment, Secondaries, Continuation Vehicle, J-Curve, TVPI, DPI and RVPI, Carried Interest (Carry), Dry Powder, LP / GP, IRR, MoIC.
Questions about this model
What does a buyer earn at an 88% bid?
The reference-date NAV is $75.0 million, so the headline price is $66.0 million. The seller has since paid a $2.0 million call and received a $2.5 million distribution, so the purchase price is $65.5 million, 87.9% of the $74.5 million NAV at closing. A quarter of it, $16.4 million, is paid two years later, and the buyer’s costs are $0.3 million. On those terms the buyer earns an IRR of 15.4% and a multiple of 1.29x on invested capital, gets its cost back in 2.7 years, and at the start has $78.8 million at risk: the price, the costs and the $13.0 million still unfunded.
How is the maximum bid found?
In closed form, with no goal seek. The distributions after closing, net of carry and less the calls, are worth $62.2 million discounted at the 15% target. A dollar of price costs 0.944 at that rate: the three-quarters paid now, the deferred quarter discounted two years, and the costs. The maximum price is $62.2 million over 0.944, $65.9 million, which is 88.5% of reference NAV once the interim adjustment is taken out, and bidding it returns exactly 15.0%. Two points more required return takes the bid down by about three points of NAV: 91.7% at a 13% target and 85.6% at 17%.
What does deferring part of the price add?
The same headline price paid a quarter at a time later is a better price for the buyer. With the whole price paid at closing the IRR is 12.3%; with a quarter paid in year two it is 15.4%, a gain of 3.0 points. The seller bears the time value, which is why deferral is offered as a way to bridge a gap on price and why a bid that depends on it should be quoted both ways.
What is the day-one uplift, and is it a return?
It is the NAV the buyer owns at closing, $74.5 million, less the $65.5 million it paid: $9.0 million, or 13.7% of the price. No cash has moved. It lifts the reported multiple to 1.13x on day one and keeps a secondary out of the J-curve a primary fund suffers, but it is the discount to NAV recognised, and it is a gain only if the NAV is right. The cash return has to come from the sales, and the tail asset, which realises at 0.60x of its NAV, takes $2.4 million, 2.9% of NAV and follow-ons, off the portfolio.
How much of the unfunded commitment is called, and what if exits are late?
Of the $13.0 million unfunded at closing the buyer is called $9.8 million in the base case, $7.0 million of follow-ons and $2.8 million of management fees, and 24.4% is never called. If the sales are delayed two years and the multiples fall by 0.10x, fees run longer and $11.8 million is called. The IRR falls to 4.3%, cost comes back in 4.9 years, the last sale falls 1.5 years beyond the fund’s life and the maximum bid for 15% is 57.6% of NAV. In a strong exit market, with every multiple 0.10x higher, the IRR is 19.9% and the maximum bid is 95.5%.
What does the seller accept?
At 88% the seller takes 25.3% less than the $87.7 million the stake would return if kept to the end, undiscounted. As an annual cost, the price it accepts for the cash it gives up is 15.7% a year, the buyer’s IRR before its own costs. A seller whose cost of capital is 16% sells at any bid above 87.5% of NAV, so there is 1.0 point of room beneath the buyer’s maximum of 88.5%.
Related models
M&A and private equity · Advanced
Private equity fund model: cash flows, J-curve and waterfall
Capital calls, fees, NAV, the J-curve, carry and clawback
M&A and private equity · Core
Leveraged buyout model
Sources and uses, a cash sweep, sponsor returns
Financial institutions · Core
Asset manager AUM and fee economics model
AUM roll-forward, flows, fee rates, margin, P/E and DCF
Questions about this model
Discussions open here soon.