Companion files
Structuring, Negotiating and Managing Partnerships in Property
These are the companion files of Real Estate Joint Ventures by Julian R. Sterling.The book on Amazon →
The four Excel workbooks that go with the book, corrected where it was wrong: the waterfall of Chapter 9 as a live engine, now with every other chapter’s arithmetic beside it; the complete venture of Chapter 23 end to end; the remedies of Chapters 7, 8, 11 and 19; and the term sheet checklist, the major decisions table and the diligence questions. Around them: the same models with the inputs emptied, thirteen working documents to print, forty questions that mark themselves, and three cases the book names and never takes to a number. Every numeric workbook ends with a checks sheet that closes ALL OK.
Free to download. No sign-up, no email address, nothing to fill in.
Twelve 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? The Real Estate Investing Pack: five PDF editions, from asset management to joint ventures, this book included, $59.99. See the pack →
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; where the book is wrong, the corrected figure stands beside it, marked “revised”. Download these four141 KB
Chapters 9, 10, 6, 12, 13, 17 and 20 to 22 · Appendix C
Nine cells define the deal and five tiers resolve below them. Set the exit proceeds to 150 and the promote is 1.53 (the book, rounding first, prints 1.54); set them to 320 and it is 54.43. Between those two the venture’s proceeds slightly more than double and the promote rises thirty-five-fold — the convexity of Chapter 10, easier to believe once you have made it happen yourself. The catch-up is solved in the cell rather than asserted, so changing the split from 50/50 to a full catch-up simply produces the right answer. Separate sheets carry the other two appendix structures, the promote-by-exit-year comparison that shows a multiple-based waterfall paying 27.64 whether the exit is in year three or year ten, the leverage table — sixty per cent more promote on thirty-seven per cent less equity — and the investor’s return computed with the promote and without it, which Chapter 10 says an investment committee wants and rarely receives. A final sheet is the same engine with the book’s numbers stripped out, for a deal of your own. New: a sheet that recomputes the other chapters’ arithmetic, which nothing reproduced before — the leverage table of Chapter 6, the fee bases and the sponsor’s total economics of Chapter 12, the promote grid of Chapter 13, the buy-sell, the rescue, the retention and the lookback. In Chapter 12’s bad case the sponsor takes out 3.16 times its capital, not the “1.5x” the book prints, which is its fees alone; across Chapter 13’s grid the investor’s net return falls 28 per cent while the promote falls 42, the reverse of what the chapter says.
Download the workbook54 KBChapter 23
Chapter 23 opens by saying that a reader with a spreadsheet should be able to rebuild the deal from the chapter alone. This is that spreadsheet: sources and uses at closing, five years of operations, the capital account rolled forward at 8% on capital plus accrued, the refinancing and the deemed liquidation at a valuation of 126 — revised: the chapter runs it after the 2.00 advance has left, and finds nothing; run first, it finds 1.50 above capital and the preferred return and a promote of 0.75, still well short of the advance — the exit waterfall with the 14% hurdle solved in the cell — it needs the year-five receipt of 71.54, and sizing that tier as “80% of what is left” is where hand-built models go wrong — the lookback, and the returns by partner. The chapter prints interest and the asset management fee as a single line; the workbook splits them, and the split reproduces all five printed figures and the 3.60 of total fees. A downside sheet runs the venture at any exit price and finds the one at which the promote first becomes payable at all. It is 122.68, and it appears nowhere in the term sheet. And the sponsor’s regret about the catch-up is priced: at this exit a full catch-up would have added nothing, while the 70/30 tier it traded for paid 0.58.
Download the workbook40 KBChapters 7, 8, 11 and 19
Chapter 8 ends by telling you to model the remedy before you sign it. This does that for all four dilution families at once: a sponsor at 10% that misses a 2.00 call ends at 7.14%, 7.04%, 2.99% or 1.52% depending on which formula the agreement contains — and two of those four are both described in term sheets as “dilution at 1.5 times”. Beside each, the promote, unchanged by any of them, which is why an investor that dilutes without touching the promote has barely moved the sponsor’s economics. Then the default loan and its accretion, the deferred buyout that turns a 75% price into 56% of fair value, the worked clawback of Chapter 11 with the tax rate as an editable cell — at 40% the sponsor finishes at 1.52x against the investor’s 1.22x on a deal that produced almost no profit — and the five removal variants of Chapter 19, with what the sponsor’s capital interest becomes if the promote it gives up is shared pro rata (22.99 rather than 21.66), which the chapter’s table silently rules out. New: the sources and uses of Chapter 7, the cost of calling early and the equalization of a late partner.
Download the workbook30 KBAppendices B, D and E
Appendix B’s sixty-four questions as a working checklist, with a status against each and a column for who benefits if a question stays open — the column that earns its keep, because a term sheet leaving more than a handful open will be renegotiated, and renegotiation after signing is where relationships are spent. Appendix D’s major decisions table with both opening positions and a column for where you landed. And Appendix E’s twenty-five diligence questions with a column for how each was received, which is often more informative than the answer.
Download the workbook20 KBThe four workbooks with every input emptied. The checks sheets count what is still missing and test what holds for any inputs.
Chapters 7 to 11, 19 and 23 · Appendices B to E
The waterfall and its three appendix structures, the complete venture, the remedies and the checklist, with the same formulas and every blue cell emptied. The exit values, exit years and price ladders down the side of the tables are steps, not data, and stay.
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: 33.43 of promote at 250, 15.0 per cent to the investor in Chapter 23, a sponsor at 2.99 per cent after a 1.5x reduction.
Download the blank set105 KBThirteen pages to print and use. A4, with margins wide enough for US Letter.
Chapters 3 to 20 · Appendices B, D and E
The term sheet read for what it decides, with each side’s opening position and the absences to look for. Appendix B’s checklist on two pages, with a column for who benefits if a question stays open. The three-way race: the timetable and the conditions precedent. Sources and uses, the capital call notice and the overrun. The remedy, modelled before you sign it. The waterfall written as definitions, and the eight tests that prove a model. Interim promote, the clawback and the lookback. Every payment to the sponsor and its affiliates. Major decisions and where you landed. Removal and the morning after. The quarterly report and the distribution notice. Diligence on your partner.
Download the documents42 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Five on setting up the deal, seven on capital and funding, eight on the waterfall and the promote, seven on the clawback, fees and the model, seven from governance to the complete venture, 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.
Chapter 11 · Case one
Chapter 11 defines the lookback as the whole life run “as a single set of cash flows”, then adds up amounts owed in year seven and paid in year three, and finds no promote earned. On dated flows the partners earned 9.92 per cent before promote. A lookback measured that way allows 5.36 of the 12.00 and repays 6.64. Same venture, same words; the measure is worth 45 per cent of the clawback.
Chapter 6 · Case two
The chapter’s asset with a 50 per cent senior loan and 15 of preferred equity at 6 per cent cash and 5 per cent accruing (ADDED). The common returns 13.48 per cent, the promote is 2.22. Income can fall 43 per cent before the hard pay is missed and the holder can take control; below a sale at 69.14 it is not repaid. The layer helps the common only while its all-in cost stays under about 13.3 per cent.
Chapter 12 · Case three
Transaction fees offset against the promote recover 1.53 of 4.75 in Chapter 12’s bad case, and all of them in the good one. Offset against the asset management fee instead, they give the investor 2.14 at 150 against 1.38. The two cross at net proceeds of 151.68: below it the fee offset protects, above it the promote offset pays.
Download the three cases35 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 |
| Checks sheet | the last sheet of every numeric workbook: each line states its own verdict, and the file ends ALL OK |
| ADDED | a figure the book does not give, used in the cases and marked wherever it appears |
Of the 140 figures the first workbook now tests, 121 reproduce exactly and 3 are marked “revised”, with the corrected figure beside the book’s. Sixteen differ in the second decimal: ten are cells of the Chapter 13 grid, whose base yield, income and growth the book does not print, and the rest come from the book rounding as it goes. They are marked “rounding” rather than quietly folded into “reproduced”, and the sheet says why: the book rounds an intermediate figure and carries the rounded number forward, while the workbooks carry full precision and round only for display.
Chapter 9 and Appendix C disagree with each other in the same way. The chapter prints the catch-up as 31.28 and the appendix as 31.29; the exact value is 31.2885. Tiers four and five inherit a hundredth each and both tables still total 250.00, because the last tier absorbs it. Nothing turns on any of it — it is shown because a check that widens its own tolerance until everything passes is not a check.
Real Estate Joint Ventures 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; the PDF prints on A4 or US Letter. 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.
Real Estate Joint Ventures by Julian R. Sterling. The workbooks reproduce the worked examples in the chapters; the book is where the reasoning behind them is set out.
| 23 Sep 2026 | The four workbooks corrected; each numeric one now ends ALL OK. Chapter 23’s deemed liquidation at 126, run before the 2.00 advance, finds a promote of 0.75, not nil; at its exit a full catch-up would have added nothing (the book says more than twice 1.74). New sheet for Chapters 6, 10, 12, 13, 17 and 20 to 22: the sponsor’s bad case is 3.16 times its capital, not 1.5x; the investor falls 28 per cent across the Chapter 13 grid, not more than the promote’s 42. Appendix B has 64 questions. Added: a blank set, thirteen working documents, 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.
These files accompany Real Estate Joint Ventures. 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.
Also available as a standalone free template: JV waterfall and promote model.