Transaction schedules · in 1 model

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

Bid on NAV, interim adjustment, deferral, maximum bid.

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

On this subject: secondary pricing: the bid, the interim cash flows and the deferral.Updated 14 November 2026

Part of m&a and private equity models, with the models, labs and guides around it.

What it does

The price a buyer pays for a limited partner’s interest in a fund. It is quoted as a percentage of the net asset value at a reference date, struck months before the deal closes, and then settled dollar for dollar for what moved since: calls the seller paid are added to the price, distributions it received are deducted. Part of the price may be deferred, paid later with no interest, and the buyer adds its own costs. What a buyer can pay is solved the other way: the cash flows after closing, discounted at the return it requires, divided by what one dollar of price costs once the deferral and the costs are counted.

Where it lives

The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.

Private equity secondaries model: pricing an LP stake
  • Assumptions, rows 11–16: LP commitment to the fund, Paid-in capital at the reference date, Fund age at the reference date, Fund term…
  • Assumptions, rows 19–24: Bid, % of reference-date NAV, Deferred payment, share of the price, Deferred payment, years after closing, Buyer’s transaction costs, % of the price…
  • Portfolio, rows 6–7: NAV at the reference date, Cost at the reference date
  • Portfolio, rows 10–11: Capital called and paid by the seller, Distribution received by the seller
  • Portfolio, rows 14–17: Follow-on the fund will make, Year of the follow-on, Expected hold, years from closing, Exit value, multiple of NAV at closing plus follow-on
  • Pricing, rows 6–15: LP commitment, Paid-in capital at the reference date, Unfunded commitment at the reference date, Paid-in, % of commitment…
  • Pricing, rows 18–20: Remaining life at closing, to the end of the extensions, Last sale in the selected scenario, Years beyond the fund’s life
  • Pricing, rows 23–33: Bid, % of reference-date NAV, Headline price, Adjustment for interim cash flows, Purchase price…
  • Pricing, rows 36–41: Target IRR, Post-closing net cash flows, discounted at the target, Cost of one dollar of price, at the target, Maximum purchase price…
  • Realisations, rows 33–37: Exit proceeds to date, Carry to date, Carry paid in the year, Distributions to the stake, net of carry…
  • Seller View, rows 6–8: Price received, Net cash flow given up, Seller’s net cash flow from selling
  • Seller View, rows 11–15: Discount to reference-date NAV, Hold-to-maturity value: net cash after closing, undiscounted, Price, discount to hold-to-maturity value, Average life of the cash flows…
  • Seller View, rows 18–24: Seller’s cost of capital, Value of holding, at the seller’s cost of capital, Lowest price the seller would take, Lowest bid the seller would take, % of reference-date NAV…

What a reviewer looks for

  • A bid applied to NAV at closing, so the interim adjustment is made twice.
  • A deferred payment left undiscounted in the maximum bid.
  • The buyer’s costs left out of the cost of a dollar of price.

Learn it, then build it

Vocabulary: Secondaries, Continuation Vehicle, IRR.

Other transaction schedules