Companion files
A Practitioner’s Guide to Pricing an Appraisal, LP Portfolios and Real Estate Continuation Vehicles
These are the companion files of The Real Estate Secondaries Investor by Julian R. Sterling.The book on Amazon →
The five Excel workbooks that go with the book, corrected where they were wrong: four models that reproduce every figure it prints, each closing on a checks sheet, and the seventy-two questions of Appendix A as a working document. Around them: the four models with the inputs emptied, thirteen working documents to print, including the transfer and consent tracker the book promises, forty questions that mark themselves, and three cases the book names and never takes to a number. Every number is a live formula. Nothing is locked, protected or watermarked, and no email address is asked for.
Thirteen workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 23 September 2026.
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? Two or more PDF editions bought together are 15% off. Browse the PDF editions →
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. The four models now close on a checks sheet: 156 checks, all passing. Download these five94 KB
Chapters 5 to 9 · start here
The whole argument of the book in one file. An interest reported at €38.5 million, offered at 82 per cent of that number, and the four discounts that follow.
The headline is 18.00 per cent. Remove the smoothing from the appraisal series and it is 14.42. Add the unfunded commitment, which is funded at par and bought at no discount, and it is 13.01. Deduct the management fees the interest still owes to the end of the fund’s life and it is 9.18. The headline is roughly twice the truth, and none of the three deductions is a market view.
Sheet 4 carries the threshold that matters most, now solved by the sheet: below α = 0.1317 — below an appraiser absorbing about 13 per cent of new information each quarter — an 18 per cent discount to the appraisal buys no discount to value at all (the book prints 0.1315, found by a search in steps).
New: sheet 5 prices the offer across α and the lag, sheet 6 is the bridge from value to price. The offer is a 14.21 per cent margin on the adjusted value of €36.80 million; the book’s margin table was computed at 12.5 and 17.5 per cent on its 12 and 18 per cent lines, which are €32.38 and €30.18 million, not 32.20 and 30.36. 62 checks.
Download the workbook27 KBChapters 10 to 12 · the second road
The same value reached from the other direction, without using the reported net asset value at all. Six assets, an estimated rental value, a non-recoverable ratio, an exit yield and a capital expenditure line each.
Gross asset value rebuilds to €291.83 million and the interest to €36.57 million — against €36.89 million from unsmoothing the reported series. The two methods share no inputs and land 0.87 per cent apart.
Sheet 3 marks the in-place debt, worth €1.478 million to this interest and invisible in the accounts. Sheet 4 is the one to read before bidding: twenty-five basis points on the exit yields moves the value of the interest by 7.79 per cent — more than the entire unsmoothing argument is worth.
New: sheet 5 carries the six scenarios of Chapter 19, the refinancing headroom (26.9 per cent) and the two thresholds, solved in the sheet: exit yields can rise 45 basis points, or rental values fall 7.3 per cent, before the offered price equals the rebuilt value (the book prints 46 and 7.4). 35 checks.
Download the workbook24 KBChapters 15 and 16
A continuation vehicle offers 90 per cent of net asset value, or a rolled interest for 4.0 years on new terms. Rolling only wins if the assets return 1.667× — a 13.62 per cent annual return.
Sheet 2 converts the vehicle’s fee and carried interest into the language the decision is made in: they cost a rolling investor 1.62 points of annual return — and more, not less, if your opportunity cost is higher.
Sheet 3 is the open-ended fund version. If the appraisal stands above spot value, the redemption queue pays you at a number that still has to fall. A one-year queue justifies selling today at up to a 14.45 per cent discount; a three-year queue, 31.80.
Revised: the break-even multiples were typed in and are now computed by the sheet, in closed form, so they move with the terms. Every figure the book prints was right. 38 checks.
Download the workbook17 KBChapter 17
Five interests, one price. Price each line at a margin on its own adjusted value and the portfolio discount is 22.22 per cent. The simple average of the five line discounts is 23.92. Only the first is true, and the second is the one that ends up in memos.
Sheet 2 prices the seller’s all-or-nothing requirement. Excluding the weakest line takes the discount on the remaining four from 22.22 to 19.63 per cent — so insisting on a single lot costs the seller 2.60 points. That is the number to negotiate with. Sheet 2 now finds the weakest line itself. 21 checks.
Download the workbook13 KBAppendix A · the working document
The seventy-two questions of the appendix, in the same order and the same words, read from the same source file as the chapter so the book and the workbook cannot drift apart.
Columns for the answer, the source document, the owner and the date. The status column marks any question answered without a source as unsourced, and the progress sheet counts only the sourced ones. An answer whose only authority is the seller is not an answer.
Download the workbook16 KBThe four models with every input emptied. The checks sheets count what is still missing and test what holds for any inputs.
Chapters 5 to 17 · Appendix B
The four discounts and the unsmoothing, the rebuild from the tape with the debt and the stress case, sell or roll with the redemption queue, and the portfolio bid, with the same formulas and every blue cell emptied. The alphas, lags, margins, shocks, rates and queue lengths are steps and stay. The seventy-two questions already arrive empty, so they have no blank twin.
The book’s inputs are listed in a text file inside the archive. Type them back in and the book’s figures come back with them: 18.00, 14.42, 13.01 and 9.18 per cent, €36.57 million from the tape, a break-even of 1.667×.
Download the blank set68 KBThirteen pages to print and use. A4, with margins wide enough for US Letter.
Chapters 1 to 21
Why the interest is for sale, with the five reasons and their tells. The net asset value layer by layer, and the four documents to ask for in order. Reading a valuation report, with the realisation history. The four discounts and their thresholds. Unsmoothing and the lag. The tape and the second road, with the diagnostic when the two disagree. The debt: the mark, the refinancing headroom and three clauses.
The one-page bid and the four mechanics between reference date and completion. The transfer and consent tracker, the fifth workbook the book announces and never shipped, in the order consents actually run. Sell or roll with the five questions, and the redemption queue. The portfolio bid and the tail rule. The stress case and the decision record. The first mark, and what would actually falsify the trade.
Download the PDF35 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Seven on sellers, shapes and the net asset value, seven on the four discounts, seven on the tape and the debt, six on the bid, the transfer and after, seven on vehicles, queues and portfolios, and six on the three cases below. Numbers are marked to a tolerance, multiple choice to the letter, and the score sheet counts your errors part by part: that is your revision list.
Nothing is hidden. The marking sheet holds every answer, every tolerance, and the reason for each answer.
Download the questions17 KBNew material, not a restatement. Three situations the chapters name 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.
Chapters 8 and 20 · Case one
The three refinements of Chapter 8, switched on. On the book’s interest they give back 0.66 points; on an interest early in its life (ADDED: 15 unfunded on 12 of NAV) the same 18 per cent headline is worth only 6.26 per cent. New money stops diluting only if it is bought 16.85 per cent below value, and a seller’s drawdown forecast is worth €0.26 million on Kestrel.
Chapter 14 · Case two
The chapter says the gap between a seller’s higher rate and the buyer’s is the value deferral creates. It is the other way round: keeping a 15 per cent seller whole on half the price deferred a year costs a 12 per cent buyer €0.423 million (ADDED rates); deferral pays only when the buyer’s rate is the higher. A €10 million staple into a fund returning 9 per cent (ADDED) costs €0.96 million, 18.4 per cent of the margin.
Chapters 13 and 20 · Case three
The four mechanics, priced. On the book’s figures value movement over the two quarters is €0.27 million at the recovered return, against €1.80 million of distributions: it becomes the largest of the four only beyond a fall of 2.47 per cent a quarter. With interest on the price and a capital call (ADDED), the discount actually bought at completion is 12.08 per cent; a reference date one quarter earlier is worth €0.41 million to the seller.
Blue text on a pale blue fill is an input — edit these. A yellow fill is the carrying assumption of the sheet, the one to argue about first. Black text is a formula. The last sheet of each model is its checks sheet: every control states its own verdict, and the file ends ALL OK. ADDED marks a figure the book does not give, used in the cases and flagged wherever it appears. Nothing is locked, protected or watermarked, there are no macros and no external links, and every file opens in Excel, LibreOffice or Numbers.
The checks sheet in each of the four models lists every printed figure beside a live formula that recomputes it. Where the book was wrong, the check carries the right figure and says what the book prints; the changes are listed below and at the end of 00_START_HERE.md. If you find another, please say so, and it will be corrected.
| 23 Sep 2026 | The four models corrected and given checks sheets (156 checks). The α threshold is 0.1317, solved in the sheet, not 0.1315. The margin table of Chapter 13: 32.38 and 30.18 on the 12 and 18 per cent lines, not 32.20 and 30.36. The Chapter 19 thresholds are +45 basis points and -7.3 per cent, not +46 and −7.4. Added: a blank set, thirteen working documents including the transfer and consent tracker, forty questions that mark themselves, and three cases. |
More in real estate, with free companion files. The full list of titles is on the author page.
The Real Estate 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.
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.
Also available as a standalone free template: secondaries discount to NAV calculator.