Companion files
A Practitioner's Guide to Business Plans, Leases, Capital and the Decisions That Move Value
These are the companion files of The Real Estate Asset Manager by Julian R. Sterling.The book on Amazon →
The five Excel workbooks that go with the book, corrected where they were wrong: the three appendices turned into working documents, the two calculations the book returns to most often and never prints in full, and a fifth that costs the one chapter with no figures in it. Around them: four of 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 number is a live formula. 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? 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. Each now closes on a checks sheet. Download these five124 KB
Appendix A
The plan as a working file: the narrative sections, a rent roll that computes the occupational position — passing rent, ERV, reversion, occupancy by area and by rent, WAULT, WAULB, the expiry and break profile, the concentration tests — a ten-year projection to exit, and the base, downside and break-even page. Two rules are enforced rather than suggested: contracted and speculative income never share a column, and the purchase price appears nowhere. Every return is computed on today's net realisable value. Revised: the expiry profile no longer puts a whole-year expiry one year late, occupancy by rent is the ERV of let space over total ERV (80.6 per cent on the example, not 75.6), and the break-even exit yield is computed: 6.02 per cent against 5.50 assumed.
Download the workbook31 KBAppendix B · Chapter 6
The three options projected on identical assumptions from the same net realisable value, with the forward return on each, then the interrogation questions and the sale preparation checklist. The second sheet is the worked illustration of Chapter 6, live: the book calls the forward return "comfortably positive but modest" and says that half a point of exit yield "may drop it below the fund's cost of capital", without printing either rate. They are 7.13% and 4.33% (4.56% on the other reading of the book’s 108, with no exit costs). Both are below a 7% cost of capital.
Download the workbook24 KBChapter 8
The vacancy decision, quantified. Net effective rent for up to three packages; the accept-or-wait arithmetic with every line of the holding cost; the two-offers example of Chapter 8 as a live comparison; and the strategic vacancy record. It returns the two numbers that end most arguments — the months of extra vacancy at which waiting breaks even, and the rent you would have to achieve for waiting to have been worth it: on the pre-filled example, 3.1 months and 105.18 (the first version said 104.75, forgetting that the rent lost while waiting rises with the rent you are waiting for).
Download the workbook21 KBAppendix C
The one-page dashboard, then arrears by occupier, the leasing pipeline with rejected offers and their reasons, service charge against budget by line with the recovery shortfall decomposed, capital with contingency reported separately, and a compliance register that computes its own status against the reporting date. The recovery shortfall now carries all four causes of Chapter 11, including the apportionment shortfall the first version left out. It arrives empty: it is the month’s document.
Download the workbook26 KBAppendix F · Chapter 13
Chapter 13 is called The Cost of Doing Nothing. It says the value of the chapter is entirely in the comparison between doing the work in a void and doing it under a deadline — and then does not make the comparison. There is not a figure in it. This file makes it, on the chapter’s own building, with the deadline left in the abstract exactly as the book leaves it.
Doing nothing costs 4,770,000 in present value — one and a half times the price of the work that avoids it. And the damage falls mostly on the exit, not on the rent: 4,036,000 of value forgone at sale against 3,131,000 of rent never earned. Which is the chapter’s opening claim proved rather than asserted — building performance is a valuation problem, and the arithmetic says so before the valuer does.
Planning the work into the year-three void is worth 1,302,000. The chapter calls this the single largest cost saving available. It is the largest; it is not mostly a cost saving. Only 613,000 of it is the cheaper contract. The other 689,000 is income — which means an asset manager who defends early planning on the contractor’s price is understating their own case by more than half, on the one ground a cost consultant is qualified to dispute.
And the cheaper technical route turns out to be the expensive one. The plant package saves 1,400,000 and loses by 448,000, because a buyer inheriting plant with six years of life left deducts 1,479,000 to replace it (corrected: the first file started the plant’s life a year before it is paid for, and the book says two years). Durability is the book’s word for this; a deduction is the buyer’s, and only one of the two appears in a price.
Twenty-five checks, and a sensitivity sheet for the assumptions you will want to argue with: across 275 basis points of exit yield the cost of doing nothing runs from 3.3 to 6.0 million, not the 3.7 to 5.6 the book prints. Two conclusions survive all of them: do the work, and do it in the void.
Download the workbook27 KBFour of the workbooks with every input emptied. The checks sheets count what is still missing and test what holds for any inputs.
Appendices A, B and F · Chapters 6 and 8
The business plan, the hold-refurbish-sell comparison, the accept-or-hold-out arithmetic and the cost of doing nothing, with the same formulas and every blue cell emptied. The sensitivity steps stay. The monthly dashboard already arrives empty, so it has no blank twin.
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: 7.13 per cent on Chapter 6, 4,770,279 for doing nothing, 1,301,868 for the void.
Download the blank set98 KBThirteen pages to print and use. A4, with margins wide enough for US Letter.
Chapters 2 to 17 · Appendices A to C
The acquisition case interrogated, with the handover meeting and the minimum document set. The first ninety days and the list of what you do not know. The delegation schedule, per project with who decides, who is consulted and who is informed. The six-part committee paper. The business plan on one page. The rent roll as a document of record, with the expiry and break profile. The hold underwrite and its break-evens. Budget, reforecast and variance. Accept or hold out. The lease the valuer will reward and the occupier behind it. Recovery, the property manager and the compliance register. Capital, building performance and repositioning. And hold, refurbish or sell with the quarterly report.
Download the PDF34 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 role, the plan and the rent roll, seven on the hold and the budget, seven on leasing, the lease and the occupier, seven on costs, capital and Appendix F, six from repositioning to the career, 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 14 · Case one
The 1980s office worth 100, converted for 60 over two and a half years. As planned it returns 17.47 per cent; with the chapter’s six-month delay and five per cent overrun, 13.51, below the 15 per cent a developer needs (ADDED). A developer pays 106.59 today, above the office value as the chapter says; at the fund’s 7 per cent the same project looks worth 32 more, which is the headline return the chapter warns about. Selling hands the buyer 11.3 of stress.
Chapter 11 · Case two
The chapter’s 81 per cent recovery rate, decomposed into 9, 5, 2 and 3 points and valued. On 800,000 of service charge at a 6.25 per cent yield (ADDED), the ten structural points are worth 1,280,000. The two unindexed caps imply cost inflation of 3.09 per cent a year and widen to 8.4 points in five: 86,441 of drift before any lease event. A point of recovery is worth 0.32 of a point of rent: pound for pound the same, point for point not.
Chapter 17 · Case three
The offer at 8 per cent below the previous rent. The chapter’s arithmetic holds for any holding cost above 6.7 per cent of the rent a year. Like for like and discounted, accepting is worth 30.3 more, and declining would need a re-letting 5.4 per cent above the old rent. The larger money was the break: moved to year six with twelve months notice and a penalty, it is worth 20.9 at a 40 per cent chance of exercise (ADDED), more than the rent discount for two and a half years.
Download the three cases36 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 workbook: each control 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 |
It carries the average days late over the last four quarters, beside a flag for a changed payment pattern. That column is the point of the whole format. The February finding in Chapter 17 — an occupier at 8% of building income moving from paying on the due date to paying eighteen days late for a third consecutive quarter — is visible there, and invisible in any aggregate arrears figure.
Nothing else was wrong. The accounts on file were eight months old and sound. Early information is worth a great deal, and it only arrives if something is looking for it.
The Real Estate Asset Manager 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.
| 23 Sep 2026 | The five workbooks corrected and given checks sheets. Appendix F’s plant has six years of life left at exit, not two: the buyer deducts 1,479,000 and fabric wins by 448,000, not 1,590,000 and 501,000. The cost of doing nothing across the yield range runs from 3.3 to 6.0 million, not 3.7 to 5.6. The break-even rent for waiting is 105.18, not 104.75. The rent roll’s expiry profile and occupancy by rent corrected. 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.
Also available as a standalone free template: WAULT calculator.
These files accompany The Real Estate Asset Manager. 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