Companion files
A Practitioner's Guide to LP Portfolios, GP-Led Deals, and NAV-Based Pricing
These are the companion files of The Private Equity Secondaries Investor by Julian R. Sterling.The book on Amazon →
These are the workbooks and documents that go with the book. The five original workbooks reproduce all sixteen figures Chapter 9 states, including the ones it states as ranges, and the fifth computes the seller’s walk-away level next to the buyer’s ceiling. Around them: two of the models with the inputs emptied, four printable working documents, a question book that marks itself, and three cases the book names and never takes to a number. Nothing is locked, protected or watermarked.
Free to download. No sign-up, no email address, nothing to fill in.
Eleven workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 22 September 2026.
Read the book already? An honest review on Amazon, good or bad, is what the next reader goes on: write a review. The files stay free either way.
Reading the paperback or the Kindle edition? The same book is also sold as a DRM-free PDF: searchable, printable, yours on any device. $19.99, instant download.Buy the PDF edition → Free sample
Finished the book? The Private Equity Career Pack: five PDF editions, from buyouts to venture capital, this book included, $59.99. See the pack →
The working models behind the books, built out for live deals: the Pro models →
Optional. When a workbook on this page is corrected or a new worked case goes up, readers on the list get one email, plus a short note when a new book comes out. The downloads do not need it.
Join the reader listRun by MailerLite, off this site. How your address is used.
These carry the book’s own figures, so that every number it prints can be traced to a live formula. Download these five89 KB
Chapters 8 and 9
The worked case, live: an interest offered at 88 against a reported NAV of 100, an underwriting NAV of 104, a portfolio expected to return around 130 over four years. It projects distributions and remaining calls over time, decomposes the return into the part from the entry discount and the part from company appreciation, and stresses delay and value together. On the chapter's case only 30 percent of the value created comes from the discount — which is what tells you the diligence budget belongs on company quality. Sheet 2 also carries the Chapter 8 duration table: 85 for 100 returns 1.18× whether the money comes back in one year or five, but 17.6 percent becomes 3.3 percent.
Chapter 7
Rebuild the reported NAV company by company so you price against a number you believe rather than one the manager asserts. Pre-filled with the chapter's build, where a reported 100 becomes an underwriting 97. The aggregate is the least interesting output: 62.9 percent of the value sits in the two names the buyer likes, while the two it worries about are smaller and marked down. There is a triage panel for how much of your NAV rests on positions you have actually underwritten, and a marking calibration sheet for a manager's historical marks against what its companies eventually fetched.
Appendix B
Thirty items across six sections — fund and manager, NAV and valuation, underlying companies, structure and terms, legal and consents, return and pricing — with a status dropdown, a notes column and a progress sheet that counts what is still open by section. Work it before the bid goes out, not after it is accepted.
Appendix C · Chapter 13
The ten questions with what a strong answer contains and a self-score, the three case prompts with the structure a strong response follows, and the 30/60/90-day plan as a tracker. Answer in the blue column before reading the guidance column.
Appendix E · Chapter 8
Chapter 8 says a deal clears only where the buyer’s ceiling and the seller’s floor overlap, and that the art of pricing is to infer the floor. It never computes either one. This file computes both, from the same cash flows, and the result is not the one the chapter implies.
The floor and the ceiling turn out to be the same formula — the present value of one set of cash flows — evaluated at two different rates. So when both sides project the same cash, the zone of agreement is exactly zero at equal required returns, and negative whenever the buyer wants more than the seller requires. On the Chapter 9 deal, a buyer at 15 per cent facing a seller discounting at 10 misses by 11.02 points of NAV. There is no price that satisfies them both.
Which reframes the whole trade: a discount to NAV is not a disagreement about value, it is the price of a difference in required return, plus whatever the seller’s motivation is worth. The grid shows where a zone exists at all, and the shape of it explains three things the chapter asserts without deriving — why stress favours buyers, why proprietary deals clear tighter, and why near-harvest funds trade closer to par.
The last two sheets price the deferred purchase price, which the book calls counterintuitive and leaves at that. Deferring a third of the price for one year is worth 3.94 points of headline price at an identical return — four points of NAV in a market decided by one or two. It works because the fund’s own year-one distribution covers 58.7 per cent of the deferred cheque, so it is not leverage on the asset at all. Which is exactly why it fails the way it does: let that distribution arrive two years late and the deferred buyer gives back more than the all-cash buyer, because the points stay paid while the cash does not arrive.
The deal model and the bottom-up NAV build, with the same formulas and every input emptied. Type your own fund interest into the blue cells and the model runs.
Blank set · two workbooks
The deal model takes the NAV, the price, the underwriting NAV, the value expected back and its profile year by year, the deferral and leverage, and the stress. The NAV build takes each company’s mark, your view, its exit horizon and your confidence. Each workbook closes on a checks sheet that counts the inputs still empty and runs the tests that hold on any deal: distribution shares that add to 100 per cent, a stressed multiple below the base, a price below the value expected back, every position with both marks and a horizon.
Put the book’s inputs back, listed in the archive, and the book’s figures come back with them: 1.45x and 14.8 per cent on the Chapter 9 deal, a reported 100 rebuilt to 97 in Chapter 7.
Download the blank set42 KBFive pages to print and take into a meeting. A4, with margins wide enough for US Letter.
Chapters 4, 6 to 9 · Appendix B
The thirty-item underwriting checklist of Appendix B, with a status, an owner and a line for the answer. A bid one-pager: NAV rolled forward, the unfunded commitment, the price and its discounts, the return base and stressed, and the split between discount and appreciation. The company-by-company NAV rebuild of Chapter 7, with the concentration and marking questions beneath. And a GP-led transaction review: price and process, the choice offered to existing investors, the general partner’s economics and the asset.
Download the PDF12 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
The numerical questions work the book’s own figures: the Chapter 7 rebuild and its concentration, the Chapter 8 duration table and the price a hurdle allows, the Chapter 9 deal and its stress, and the floor, ceiling and deferral of Appendix E. They are marked against a tolerance, so a reasonable rounding passes. The score sheet counts the wrong answers by part of the book.
Nothing is hidden. The marking sheet holds every answer, every tolerance, and the reason for each answer.
Download the question book16 KBNew material, not a restatement. Three situations the chapters name in passing and never take to a number. Each case is one workbook: the note is the first sheet, the model is the rest, and a checks sheet closes it. Type your own figures in and every finding recomputes.
Case one · extends Chapter 6
Two interests with the same NAV of 100, bought at 88. The one with 30 of unfunded commitment is bought at a 9.2 per cent discount on its total exposure, not 12, and returns 14.7 per cent against 15.6. To match, it should cost 85.58, or its new investments should return 1.67 times instead of 1.5. A discount to NAV prices what exists; the capital still to be called is bought at par.
Case two · extends Chapters 8 and 9
The Chapter 9 deal paid four ways. A free one-year deferral of 40 per cent lifts the return from 14.8 to 17.5 per cent and keeps most of that gain in the chapter’s stress. Leverage at 8 per cent lifts it to 17.1 per cent and keeps none: 8.1 per cent stressed, with or without it. Together they show 22 per cent on a 14.8 per cent asset.
Case three · extends continuation vehicles in Chapter 4
An existing investor offered 95 for an asset carried at 100, or a roll into the new vehicle at a 1 per cent fee and 12.5 per cent carry. At 1.8 times gross, rolling is worth 19 more than selling and earning 10 per cent elsewhere; the break-even is 1.57 times. The fee and carry cost a rolling investor about 2.2 points a year.
Download the three cases33 KB| Blue text | a hardcoded input — you may edit these |
| Black text | a formula — do not overtype these |
| Green text | a link to another sheet |
| Yellow fill | the assumptions that carry the answer |
The book states its answers in words — a MOIC "in the region of one and a half times", an IRR "in the mid-teens", a stressed multiple that "compresses toward one and a third". The workbook tests membership of the range the book states rather than equality to a point, which is the honest test and the one that survives you pricing a different deal.
Where the book leaves a convention open — what "the exits slip by two years" means — both readings are computed and shown side by side rather than one being fitted to agree.
The Private Equity Secondaries Investor develops the complete framework behind these models, with the assumptions, trade-offs and worked examples tied together.
View the book on Amazon Read the related analysisAlso as an ebook on Apple Books · Google Play ยท DRM-free PDF edition ($19.99).
The workbooks open in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers. They use no macros and no add-ins, so nothing needs to be enabled or trusted. If your spreadsheet asks to update links on opening, decline — there are none.
| 22 Sep 2026 | Blank model set, four printable working documents, the question book and three new cases added. Read-me rewritten. |
More in private equity and funds, with free companion files. The full list of titles is on the author page.
Also available as a standalone free template: lP secondary pricing model.
These files accompany The Private Equity Secondaries Investor. The book is on Amazon.
If this book helped — or didn’t — a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.