Companion files
A Practitioner's Guide to Building Property, Development and Fund Models — and Passing the Modeling Test
These are the companion files of Real Estate Financial Modeling by Julian R. Sterling.The book on Amazon →
Also as an ebook on Apple Books · Google Play, and as a DRM-free PDF edition ($19.99).
The five Excel workbooks that go with the book, every number a live formula and every figure the book publishes reproduced exactly. Around them, eight working documents to print, forty questions that mark themselves, and three cases the book does not work. Nothing is locked, protected or watermarked.
Free to download. No sign-up, no email address, nothing to fill in.
Eight workbooks, the printable documents and the read-me. Each file below can also be downloaded on its own. Last revised 22 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.
Chapter 19
The full worked model, built to the seven-sheet architecture of Chapter 2: Read Me, Summary, Assumptions, Rent Roll, Cash Flow, Debt, Returns, Sensitivity. It reproduces the chapter exactly — net initial yield 5.22%, loan sized at 12,925,000 on the binding loan-to-value test, unlevered IRR 8.21% at a 1.44× multiple, levered 11.07% at 1.64×, exit at 30,287,357 gross. Six checks sit at the top of the Summary sheet and all six pass. Change the exit yield on the Assumptions sheet and watch what moves — the fastest way to understand why Chapter 15 says the exit yield is the assumption that carries the answer.
Download the workbook28 KBChapters 2 and 3
The same architecture, empty, for your own deal. The header block, the flag rows, the three debt tests, the covenant grid and the check block are already built. Fill in the Assumptions and the Rent Roll; the rest calculates. One example row shows the expected format — overwrite it.
Download the workbook22 KBAppendix C
The three timed cases, each with the brief, a blank working area and a live solution: single-let logistics in 45 minutes; a development residual in 60 minutes, where the land cell is the one you iterate; an equity waterfall in 30 minutes. Work them against a clock before you look at the solution block.
Download the workbook16 KBAppendix B · Chapters 16 and 18
All 53 items of Appendix B with a status dropdown, a notes column and a counter at the top; the Chapter 16 two-hour protocol for auditing a model you did not build, with the twelve things that are usually wrong ranked by frequency; and the Chapter 18 allocation for a modeling test under time pressure.
Download the workbook15 KBAppendix F, and Chapters 15 and 19
Chapter 15 specifies exactly what a sensitivity section owes a committee: a tornado chart, a two-way table on the top two drivers, a scenario table of four columns and six rows, and four break-even numbers. Chapter 19 builds Meridian House, calls it a finished model, and delivers a one-way table, three scenarios in prose and one break-even of the four. This workbook rebuilds Chapter 19 from its published inputs — twelve controls check the rebuild against the chapter, including all ten cells of its own sensitivity table — and then produces the page. It finds that the covenant that binds is the debt yield at a 7.9 percent fall in income, not the coverage ratio at 35.5; that the real risk threshold is three and a third times nearer than the exit-yield headroom suggests; and that “the combination is worse than the sum” is a fact about leverage rather than correlation, true above about 19.6 percent loan-to-value and false below it. Eighty-three controls, all live.
Download the workbook35 KBEight pages to print and use. A4, with margins wide enough for US Letter.
Appendix B · Chapters 10, 12, 13, 15 to 18
The Appendix B review checklist on two pages. The two-hour audit of Chapter 16 with the twelve things usually wrong. Debt sizing on three tests, with the distance to every covenant. The page that gets read: tornado, two-way table, scenario table, break-evens. The development front page with its four break-evens. The four waterfall tests and the list of what the term sheet did not say. And the one-page summary with the ninety-minute test.
Download the PDF22 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Six on purpose, structure and time, seven on income, cost and capital, seven on valuation and returns, seven on debt, the capital stack and the waterfall, seven on development through to the modelling test, 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 question book18 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 9 and 12, Appendix C · Case one
Chapter 9 says a quarterly IRR multiplied by four overstates by about a hundred basis points. It understates, at every positive rate: by 43 basis points at Meridian House’s 11.07 per cent, and by a hundred only near 17. Appendix D has it right. Then the word the chapter lists and never prices: in Appendix C’s joint venture, compounding the 8 per cent preferred return quarterly instead of simply takes the promote from 1,640,000 to 1,439,429.
Chapter 13, Appendix C · Case two
Appendix C’s development, taken to the four break-evens Chapter 13 asks for: profit reaches zero at a 15.1 per cent fall in value, a 22.0 per cent cost overrun, 21 months of delay or a 6.48 per cent exit yield. The chapter’s illustrative “14 and 21 per cent” describes this very scheme. Six months of delay costs about 3.6 points on finance alone and 5.7 with site costs; the exact residual is 5,353,314.
Chapter 11 · Case three
Chapter 11 warns that selling the best asset out of a cross-collateralised pool can over-lever what is left. At a 115 per cent release price, selling the prime office improves every test. Selling the two highest-yielding assets breaches the debt yield, 9.48 per cent against 9.5, while the loan to value sits at 55. Keeping the debt yield on the industrial estate would need a 140 per cent release price.
Download the three cases40 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 publishes annual figures; the model behind them is quarterly. Rebuilding a quarterly lease-event engine from a printed annual table requires convention choices the text does not spell out. So the Cash Flow sheet of the Meridian model carries a live income engine and the published figures beside it, with the variance shown — it lands within about 0.3% across the hold. The Debt, Returns and Sensitivity sheets run off the published cash flow, so every headline number in Chapter 19 reproduces exactly.
That visible variance is deliberate. Chapter 3, Rule 4: a model must contain checks, and they must be impossible to ignore. A companion file that quietly buried 0.3% would teach the opposite of the book.
Real Estate Financial Modeling 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 analysisThe 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 | Eight working documents, forty questions that mark themselves and three new cases. Each workbook can now be downloaded on its own. The archive again carries the main read-me, 00_START_HERE.md, which the previous archive had left out; the five workbooks have not changed. |
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 property model.
These files accompany Real Estate Financial Modeling. 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