Companion files
A Practitioner’s Guide to What Actually Produced the Return, and Who Was Paid for It
These are the companion files of Commercial Real Estate Investing by Julian R. Sterling.The book on Amazon →
The four Excel workbooks that go with the book, corrected where they were wrong and completed where the book prints a figure no workbook reproduced: the twenty-four attribution orders are now computed live, and the hold-period table, the gearing ladder and the lease calendar in cash have their own sheets. 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 workbook ends on a Checks sheet: 237 controls, every one green. Nothing is locked, protected or watermarked.
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? 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. Each closes on a checks sheet that ends ALL OK. Download these four218 KB
Chapters 1 to 4
Ten units with their areas, passing rents, rental values and expiry years, and eleven years of income built on top of them by formula. The re-letting rule is applied automatically: a lease expiring at the end of year e pays its old rent through year e, three twelfths of the new rent in year e+1, and the whole of it thereafter.
That single convention is what most models leave out, and it is visible here as soon as the sheet opens: the rent line falls in five of the ten years, because each of those is the year after an expiry. Passing rent starts at 1,575,900 against a rental value of 2,284,000, two units of the ten are empty on day one, and year one produces a negative net income of 265,863.
A sheet added in the revision reads the rent roll one division at a time and costs every re-letting inside the hold in cash: 1,788,485 of rent never billed and 357,697 of fees, 2,146,182 in all, 10.3393 per cent of everything the estate collects.
Download the workbook31 KBChapters 5 to 7
An exit yield is a stabilised income over a gross value, so only one of the numbers people quote as the entry yield can be set beside it. The sheet computes all six — 5.9693, 5.5892, 5.4551, 4.8681, 8.6515 and the like-for-like 7.0555 per cent — and says why five of them compare two different things.
Against an exit at 6.65, the yield moved 0.4055 points. Not the 0.6807 you get by subtracting the headline yield, and not the 2.0015 you get from the reversionary one. The sale is priced on year eleven's 2,453,319 at 6.65 per cent, and the sheet also prices it on year ten instead, which is worth 3,484,658 less — because year eleven is the only year in four that carries no re-letting. (Corrected: the book capitalised year ten after its one-off letting fee and printed 4,198,723.) A new sheet takes any exit yield and either base year through the waterfall, and finds where the catch-up finishes: at 6.3285 per cent.
Download the workbook49 KBChapters 8 to 12
Switch the four drivers on one at a time and record the step in the equity return at each switch. Do it in a different order and you get a different answer: leverage is worth plus 1.8441 points when it goes on last and minus 1.1977 when it goes on first, a swing of 3.0419 points on the same deal.
All twenty-four orders are here as live rows, computed from sixteen complete runs of the model on the sheet itself (the first version typed them in), with each driver's minimum, maximum and average. Only the average is order-independent: business plan 2.5923, rental growth 1.4816, exit yield 0.6711, leverage 0.4535 — and the four of them sum to exactly the 5.1986 points there are to explain, which the sheet checks. That is the only attribution worth putting in a report.
Chapter 12’s thirteen hold dates have their own sheet: 4.0160 per cent at seven years against 7.5473 at six, because Ardgour expires at the end of year seven and the sale is priced on year eight.
Download the workbook66 KBChapters 13 to 15
The preferred return accruing year by year on unreturned capital and on unpaid accrued preferred, capital returned, the full catch-up, then the eighty-twenty. The investor put in 14,943,867 and took out 29,341,958, of which 14,398,091 is the preferred return itself: nothing above the hurdle, and a return of exactly 8.0000 per cent against a gross equity return of 8.6647. The manager took 2,114,640 of fees and 1,748,716 of promote.
The sheet also carries a switch that turns off the crediting of capital called after completion. Turn it off and the promote goes from 1,748,716 to 3,451,151 on exactly the same building and the same distributions — the whole difference being nine years of preferred return on 1,108,947 the investor put in and did not get back.
Added: chapter 11’s seven gearings, each with its own capital account under both conventions, and the hard hurdle. The promote peaks at 2,993,873 at 65 per cent and falls at 70 while the equity return keeps rising; with no catch-up it would be 349,743.
Download the workbook80 KBThe four workbooks with every input emptied. The checks sheets count what is still missing and test what holds for any inputs.
Chapters 1 to 15
The same four workbooks with the Inputs and Rent roll sheets emptied: sixty cells, from the price and the void to each unit’s area, rents and expiry. Nothing computes until all are filled; the sensitivity axes, the order selectors and the waterfall switch keep their values.
The book’s inputs are listed in a text file inside the archive. Type them back in and Bracken Wharf comes back with them: 8.6647 per cent, exactly 8.0000 to the investor, 1,748,716 of promote, and the four attribution averages.
Download the blank set160 KBThirteen pages to print and use. A4, with margins wide enough for US Letter.
Chapters 1 to 18
The six entry yields and the one that compares. The rent roll, read one division at a time. The cheque at completion and year one in full. The re-letting calendar in cash, with a column for the holding costs the model leaves out. The exit assumption, interrogated. The four returns and what stands between each and your account.
The attribution grid for all twenty-four orders. The capital structure priced for its promote. The hold against the lease calendar and the fund’s wind-up window. The capital account year by year. The fee schedule’s four terms. The report a manager should publish. The seven questions for a paper that lands on Tuesday.
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 yields and the rent roll, seven on year one, the income account and the sale, six on the four returns and the yield, seven on attribution, gearing and the hold, seven on the waterfall, the promote and the fees, 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 5 · Case one
Chapter 5 says a surveyor would capitalise year eleven and deduct Corrour’s void and fee, and stops. The deduction is 109,383, and every pound of it comes out of the promote while the investor stays at exactly 8.0000 per cent. The promote survives a deduction of up to 1,770,852, 16.2 times Corrour’s; priced on an ordinary year instead of the clean one, it is nil and the equity earns 7.2626 per cent. Nothing is added to the book’s figures.
Chapter 4 · Case two
The chapter names empty rates, service charge, insurance and security, and prices none of them. At 30 per cent of the new rent a year of void (ADDED), 536,546 of holding costs remove 774,283 of promote, 1.44 times the cash, because the preferred return compounds on every pound withheld. 69.0 per cent of the cost lands in the years the rent already falls. Above 67.8 per cent the manager earns no promote at all.
Chapter 12 · Case three
A fund that must sell at seven years (ADDED) takes the 4.0160 per cent notch. Renewing Ardgour a year early at the full indexed rent, with no void (ADDED), lifts the seven-year sale to 8.6397 per cent and pays the manager a promote of 991,913. The fund can concede up to 19.6 per cent of the rent and still match selling at six.
| Blue text | a hardcoded input — you may edit these |
| Yellow fill | an input cell; everything else on the sheet is a formula |
| Black text | a formula — do not overtype these |
| Checks sheet | the printed figure beside the computed one, with a PASS or a FAIL; the sheet ends ALL OK |
| ADDED | a figure the book does not give, used in the cases and marked wherever it appears |
A workbook that agrees with a book proves nothing on its own — the author wrote both. What the Checks sheets do is different: they force the model to reproduce, from a formula, a number that was printed before the model existed.
On this book the discipline worked in the other direction twice, and the chapters carry the result rather than the original claim. The first draft declared a nine-month void between leases and never applied it; applying it turned the rent line from a rising staircase into something that falls in five years out of ten, and made the hold-period table jagged rather than smooth. The second draft computed the preferred return on the money subscribed at closing and ignored the 1,108,947 called a year later; correcting that cut the promote from 3,451,151 to 1,748,716 and moved the investor's return from 8.2150 per cent to exactly 8.0000. Both errors flattered the story the book was telling. Both were caught by refusing to print a number that would not reproduce.
A third pass, on the finished book, found a quieter one. Two chapters priced a sale on a year’s income after its one-off letting fee, while the model, and the book’s own formula reference, capitalise the income before it. Corrected, pricing the sale on year ten costs 3,484,658 rather than 4,198,723, and holding six years rather than seven costs 4,714,128 of proceeds rather than 6,025,963. The conclusions stand; the figures under them are now the model’s.
Where two correct computations disagree, both are shown. The four attribution averages printed to four decimals sum to 5.1985 against the model's 5.1986. The exit value is 36,892,015 computed from the printed income and 36,892,021 from the unrounded. Neither gap is smoothed away.
Commercial Real Estate Investing 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.
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 four workbooks corrected and completed. The sale priced on year ten costs 3,484,658 of net proceeds, not 4,198,723: the book capitalised year ten after its one-off letting fee (chapters 5, 16, 17 and 18). Holding six years rather than seven costs 4,714,128, not 6,025,963 (chapter 12). Chapter 2’s years five and nine rise because Dunardry and Eilanreach are the smallest leases, not the smallest reversions. The attribution orders, typed in the first version, are now computed from sixteen live runs; new sheets for the lease calendar, other exits, the hold and the gearing ladder. 237 checks in all. 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.
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: cap rate and exit yield calculator.