Companion files
A Practitioner's Guide to Business Plans, Leases, Capital and the Decisions That Move Value
These are the four Excel workbooks that go with the book: the three appendices turned into working documents, plus the two calculations the book returns to most often and never prints in full. 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.
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.
DownloadXLSX · 29 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%.
DownloadXLSX · 22 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.
DownloadXLSX · 18 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.
DownloadXLSX · 23 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 |
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 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.
The other books with companion files. The full list of titles is on the author page.