Companion files
The Complete A to Z Guide — Strategies, Structures, and Insights
These are the companion files of Private Equity Real Estate by Julian R. Sterling.The book on Amazon →
These are the workbooks and documents that go with the book. The four original workbooks reproduce both worked waterfalls of Chapter 12 to the dollar, build the two capital stacks of Chapter 21, turn the performance measures of Chapter 24 and the diligence framework of Chapter 15 into working files, and take the risk-return spectrum net of fees. Around them: three 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.
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? 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 →
Learn to model a commercial property, from rent roll to waterfall: the Real Estate Modeling course →
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 four98 KB
Chapters 11–12
Both worked examples of Chapter 12, tier by tier. The $500M fund returning $1 billion, arriving at $900M to the LPs and $100M to the GP at exactly 20% of profit. And the ten-investment value-add fund — seven winners at 1.8x, three losers at 0.7x, $735M of proceeds, $235M of profit — where the catch-up clears by exactly $2 million. That $2M is the sheet worth playing with: move the winners to 1.7x and it stops clearing entirely, which is what the chapter means by calling the hurdle "a binary threshold". Further sheets price the European against the American calculation on the same ten deals and size the resulting clawback at $9M — 16% of everything the GP had already banked — build the multi-tier structure the chapter describes, and compute the time-weighted preferred return on the three-tranche example under both annual and quarterly compounding.
Chapter 21
The $56M value-add stack and the four-layer $100M development stack, both exactly as the chapter sets them out, with the blended cost of the priority capital and what each layer recovers across a range of exit values. A separate sheet works the leverage arithmetic in full, from no debt to 85% loan-to-value in both directions. The chapter's 33% figure at 70% LTV is right; the derivation printed beside it is not, and the sheet shows the working that reaches it.
Chapters 15 and 24
IRR, TVPI, DPI and RVPI computed from one cash-flow schedule, so what each one hides becomes visible on the same page. A gross-to-net bridge separating management fees, fund expenses and carried interest — 2.15x gross to 1.78x net on the worked fund, and 200bps of compound return. The J-curve, and the vintage pacing that manages it: on the same total commitment, pacing does not shorten the J-curve, but it cuts the peak funding requirement by a third, which is the number a treasury actually plans around. And the six-step diligence framework of Chapter 15 as a weighted scorecard that refuses to return a recommendation while any line is scored without evidence recorded against it.
Appendix A, and Chapters 5 and 11
Chapter 5 calls the four-tier spectrum the foundation of portfolio construction and quotes every one of its return targets gross. Chapter 11 gives the fee load for the same four tiers and notes that sophisticated LPs build comprehensive fee models. This is that model, on the book’s own $1bn fund. The ranking survives — but the core-to-opportunistic spread falls from 12.50 percentage points gross to 8.59 net, and the promote, not the management fee, does more than half of that. It also finds the arithmetic reason core funds never use the 8 per cent hurdle: a ten-year fund needs 8.97 per cent gross to clear it, and chapter 5’s core band stops at 9. And the anchor discount that is worth nothing: on the levered tiers the transaction fees already consume the whole management fee, so cutting it by 25 basis points buys 30 bp of net return on core and exactly zero on value-add. Sixty controls, all live.
The waterfalls, the capital stacks and the fund metrics, with the same formulas and every input emptied. Type your own fund or deal into the blue cells and the model runs.
Blank set · three workbooks
The European and American waterfalls, the multi-tier promote and the time-weighted pref; the value-add and development stacks, the leverage ladder and the mezzanine against preferred equity; the four performance measures from one cash-flow schedule, the gross-to-net bridge and the thirty-two-line manager scorecard with its weights. Each workbook closes on a checks sheet that counts the inputs still empty and runs the tests that hold on any fund: every dollar distributed once, sources equal to uses, layers that add to the cost, TVPI equal to DPI plus RVPI, scores between 1 and 5.
Put the book’s inputs back, listed in the archive, and the book’s figures come back with them: 900 and 100 on the Chapter 12 fund, 56 of uses on the value-add stack, a TVPI of 1.97x.
Download the blank set67 KBFive pages to print and take into a meeting. A4, with margins wide enough for US Letter.
Chapters 10, 11, 15, 18, 21 and 24
The manager selection scorecard of Chapter 15, thirty-two lines in six steps, each with a score, a weight, an owner and the evidence. An LPA and fee terms review: every economic, protective and liquidity term against market and against the fund’s own position. A deal underwriting one-pager: sources and uses, the yields that pay for the stack, and a blank exit-cap sensitivity grid. And a sheet for reading a quarterly fund report: the four measures, the share of value still unrealised, and the gross-to-net bridge since inception.
Download the PDF14 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: both Chapter 12 waterfalls and the clawback between them, the time-weighted pref, the Chapter 21 stacks and the leverage ladder, the Chapter 24 measures and the gross-to-net bridge, and the spectrum net of fees. They are marked against a tolerance, so a reasonable rounding passes. The score sheet counts the wrong answers by part of the book, which gives the only revision list worth having.
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 the Chapter 12 waterfall
The ten-investment fund clears its full catch-up by 2.5 of proceeds: at a loser multiple of 0.683 instead of 0.7 it would not. At 0.6 the fund loses 15; the GP loses 13 of it and the LPs 2. Inside the catch-up zone the LPs receive their capital and pref whatever happens and the GP is the first-loss holder of the last 46.5 of profit. With a 50 per cent catch-up the GP’s 47 would be 24.5, with none 9.8.
Case two · extends open-end funds in Chapter 9
A tenth of an open-end fund asks to leave while others queue too. A third is paid in the first quarter, 87 per cent within a year, the last units in the sixth quarter. Waiting in the queue costs 2.6 points on top of the fall in NAV; paying everyone at once would have cost the investors who stay 1.8 per cent. A gate does not remove the cost of liquidity; it decides who pays it.
Case three · extends pacing in Chapters 8 and 24
A flat 350 a year, one fund a vintage, reaches an 8 per cent allocation in year 5, then overshoots to 12.8 per cent in year 8 as the early funds keep drawing. The steady commitment that holds the target once the programme is mature is about 220. Net cash flow stays negative for seven years. Steady pacing smooths vintage risk; it does not produce a steady allocation.
Download the three cases41 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 first worked example in Chapter 12 prints, at Step 4, "remaining $750M – $200M – $50M = $250M". The residual is right — $1,000M less $500M of capital, $200M of pref and $50M of catch-up does leave $250M — but the line as set does not compute: the first figure should be $500M, and $750M – $200M – $50M is $500M, not $250M.
The final tally in the book is correct and unaffected. The workbook derives each tier from the one above it, so the residual falls out of the arithmetic rather than being asserted.
Private Equity Real Estate develops the complete framework behind these models, with the assumptions, trade-offs and worked examples tied together.
View the book on AmazonAlso as an ebook on Apple Books · Google Play.
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. Verdict cells that read “ECART” or “TOUT CONCORDE” now read GAP and ALL AGREE; no figure changed. Read-me rewritten. |
9 of the calculations in these workbooks, worked out in full. All articles.
More in real estate, with free companion files. The full list of titles is on the author page.
Also available as a standalone free template: real estate capital stack calculator.
These files accompany Private Equity Real Estate. 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.
The REPE Interview Prep Pack: 18 full-length case studies solved step by step (acquisition, development, debt sizing, the promote, the paper LBO) and 3 Excel models with live formulas. Instant download, €99.
See the REPE Interview Prep Pack