Companion files
Originating, Underwriting, Structuring and Managing Property Loans
These are the companion files of The Real Estate Debt Investor by Julian R. Sterling.The book on Amazon →
One Excel workbook that answers the question Chapter 7 ends on, now corrected. Around it, a blank version and a sizing and exit-test model for your own loans, thirteen working documents to print, forty questions that mark themselves, and three cases the book does not work. All free. Nothing is gated behind a sign-up, and no email address is asked for.
Seven workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 23 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 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 →
Learn to underwrite a direct loan, step by step: the Private Credit 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.
Appendix G · Chapter 7
The chapter’s own two loans, with figures on them. A tight senior loan at 200 basis points against a wide whole loan at 550. Apply the four deductions the chapter names — cost of funds, expected loss, operating cost, capital held — and the ranking barely survives.
Gross margin says the whole loan wins by 350 basis points, nearly three times. Return on capital says it wins by 3.4 points, a tenth. The margin overstates the advantage by roughly seventeen times. That is what the chapter means by a business that manages to gross margin selecting the wrong deals — and at that size the distortion does not merely blur the ranking, on a slightly different pair it reverses it.
And the wide margin is a position on an estimate. Raise the default probability from 3.00 to 4.36 per cent and the whole loan ties with the senior one. A margin for error of 1.45× — inside the range any honest analyst would put around a PD. Meanwhile the objection people actually raise, that it is three times the work, turns out not to bite until it costs nearly six times as much to run.
The floor, priced. The clause the chapter says gets conceded when everyone is tired costs the borrower nothing on the day. If the reference rate falls 150 basis points, it earns 750,000 a year — three quarters of the senior loan’s entire credit margin. The negotiator who gives it away at eleven o’clock has given away more than the credit team gained by pricing the risk correctly.
And early repayment, where the surprise is instructive. On the loan alone, an early exit makes the lender more money — 38.4 per cent against 33.1 — because the arrangement fee annualises over a shorter life. So the chapter’s warning is not about the loan; it is about the five words at the end of it, at a compressed margin. Run the round trip and the lender can absorb just 13 basis points of compression on the replacement loan before the early exit costs real money.
Which reframes prepayment protection entirely: not a penalty, not a windfall, but the amount of margin compression the lender can survive — 13 basis points with none, 41 with a hundred of protection, 70 with two hundred: about 29 more for every hundred, not the forty the first edition said. Twenty-three checks.
Download the workbook24 KBSet both risk weights to 100 per cent — the unregulated fund case — and look again. Then put your own funding spread in. Most lenders discover that the ranking of their last three loans depends more on the capital line than on anything discussed at credit committee, which is precisely the chapter’s argument and much more persuasive as your own numbers.
It cannot tell you the probability of default, which is the input the whole comparison turns on and the one nobody can observe. It cannot price the risk a team is not equipped to manage — the chapter’s sharpest point, and the one no model captures. And capital treatment differs by lender type and jurisdiction, which is why the book avoids naming regimes. The arithmetic holds in any regime; only the inputs change.
Two workbooks with every input emptied. The checks sheets count what is still missing and test what holds for any inputs.
Chapters 5, 7, 8 and 18 · Appendix G
The book’s workbook with its inputs emptied: your two loans, your funding spread and your capital ratio. And a new file for the arithmetic Chapters 5 and 18 ask for: the five metrics at the loan requested, the loan each of your limits allows and which one binds; the exit test on a good and a bad case, on debt yield alone and on every test you set; the downside shortfall, the recovery, and the value decline at which the loan is not repaid.
The book’s two deals are listed in a text file inside the archive. Type Chapter 18’s back in and the file returns a gap of 11 at maturity and a shortfall of 7 on the swept balance. Type Chapter 5’s in and it shows what the chapter leaves out: on its own 2.0× cover at 5 per cent, the bad case refinances 54, not 60.
Download the blank set39 KBThirteen pages to print and use. A4, with margins wide enough for US Letter.
Chapters 2 to 17 · Appendices A to D
The thirty-minute screen. The income that exists and the three values. The sponsor, with the verified record and the lender references. Sizing on five metrics with the exit test. Structure, each feature against the risk it addresses, and the intercreditor for a subordinated position. The credit paper and the five questions a committee asks. The term sheet skeleton. The facility agreement and the mark-up. The development drawdown test. Quarterly monitoring with the rent roll compared line by line. Hedging and the maturity eighteen months out. The workout’s first fortnight with the recovery. And the loan book: concentration, expected loss, leverage and what investors should be told.
Download the documents36 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Seven on the lender’s position, seven on sizing, structure and pricing, seven on the credit paper, the documents, covenants and development, seven on the book, monitoring, hedging, valuation, maturities and workouts, six on Chapter 18 and Appendix G, 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 book17 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’s scheme, cost 100, equity 30, facility 70, value 130, with the overrun certified when 85 has been spent. The drawdown test fails that day by the whole overrun, 10, because the equity went in first. A rational sponsor keeps funding far past the zero-profit point: it walks only when the completed value falls below 80, a 38.5 per cent decline. What stops it is capital, 6 of the 10. Completing leaves the lender whole; selling the site loses 4.
Chapter 14 · Case two
The chapter’s cap, taken to the number: cover falls to 1.2× only if rates climb 2.62 points past the strike; at the strike it is 1.5×, cap or no cap. Then the pari passu swap the chapter calls a competing creditor: on Chapter 18’s loan of 57, after a two-point fall with three years left, the counterparty claims 3.29 and takes 5.5 per cent of a recovery of 50, costing the lender 2.73.
Chapter 15 · Case three
The watchlist loan of 72 the chapter calls impaired at 82 per cent loan to value. Its accrued interest already discounts for time, at the loan’s own 5.56 per cent: doing both counts fifteen months twice. At a 60 per cent chance the letting works, the provision is 5.6, 7.8 per cent of the loan and 0.52 per cent of a fund levered at 40 per cent. And the same haircuts impair any loan above 68.2 per cent loan to value.
Download the three cases35 KB| Amber fill | an input — you may edit these |
| Grey fill | a formula — do not overtype these |
| Checks sheet | twenty-three controls in the book’s workbook, each stating its own verdict; every other workbook ends with its own |
| ADDED | a figure the book does not give, used in the cases and marked wherever it appears |
Every figure is illustrative, as everything in the book is. The loans, the sponsor, the funding cost and the risk weights are invented. The arithmetic is not.
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.
| 23 Sep 2026 | The book’s workbook corrected: the early-repayment sheet hard-coded the running cost at 5 basis points instead of the 9 sheet 1 implies, so Loan A returned 34.1 per cent to term there and 33.1 on sheet 2; it is now 33.1 to term and 38.4 repaid at eighteen months, not 34.1 and 39.4. Each 100 basis points of prepayment protection buys about 29 of tolerance, not forty; 13, 41 and 70 were right. Twenty-three checks. Added: a blank version, a sizing and exit-test model, thirteen working documents, forty questions that mark themselves and three new cases. The workbook can now also be downloaded on its own. |
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: loan pricing and return on capital calculator.
The Real Estate Debt 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).
These files accompany The Real Estate Debt 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.