Companion files
A Practitioner's Guide to Street Rate, In-Place Rate, Length of Stay and the Rent Roll That Has No Leases
These are the companion files of Self-Storage Real Estate by Julian R. Sterling.The book on Amazon →
Every other asset class hands you a lease. A self-storage store hands you 470 customers who can cancel this month. The price on the website is £32.65/sq ft. The rent roll collects £35.93/sq ft. That gap — 10.0 per cent — is not a market fact: it is an operating record, and resetting every customer to the website price removes 17.7 per cent of the asking price.
These are the workbooks the book was written from, corrected and completed: the first version announced a lease-up curve, a ten-year cash flow and an optimum increase it did not compute, and three of the four files held typed values. Every figure is now a live formula, and every workbook ends with a sheet that compares it with the book line by line. Around them: the same four with the inputs emptied, thirteen working documents, forty questions that mark themselves, and three cases the book names and never takes to a number.
The whole book
The cohort engine every figure in the book is computed from. Self-storage has no leases, so the rent roll cannot be read from a schedule — it is built from cohorts of arrivals decaying against a hazard of departure, each carrying the increases it has received. 590 units across six sizes, the three prices, length of stay, the cost base and the break-even (36.3 per cent). Revised: the lease-up curve is now built from the cohorts (the store first earns money in month 25, after £535,460 of losses), the ten years, the sale, the debt and the bid are computed (£7,279,057, 13.7 per cent below the asking price once acquisition costs are paid), and the optimum increase is found in closed form. What a move-out loses is valued properly: the average customer in the store is worth £2,691 from here on, not the £1,094 of Chapter 8's shorthand. Fifty-six checks.
Download the workbook147 KBChapters 4 and 5
The decision the asset class turns on, laid out so you can put your own response curve into it. Fill in your move-outs in the month after each increase cycle and the file fits the response exponent, solves for the increase that maximises net operating income — 12.82 per cent on this store, worth £0.4 million of value — shows how flat the answer is, and repeats the search under four other beliefs. Revised: the decision sheet held values and did not recalculate; it now does. At the book's exponent the optimum is exactly where four increases land on the 62 per cent cap.
Download the workbook217 KBChapters 3 and 14
Month by month against the plan: move-ins, move-outs, net gain and the enquiries behind them. Its diagnostic columns answer the question most lease-up plans have never been asked — occupancy equals move-ins times length of stay, so what occupancy can your actual flow hold? Here that flow is 34.0 new customers a month, indefinitely. Revised: a second diagnostic uses a measured length of stay, because one read off a filling store's own move-outs overstates it (16.4 months in the first year against a true 13.8).
Download the workbook20 KBChapters 26, 29 and 30
The bridge from asking price to bid, the six inversions — each of which closes the gap on its own — and the omissions table for the facing page, with a column saying where each unpriced item can actually be found. Revised: it was typed values and is now live from its asset sheet; it ends where Chapter 29 does, at the bid of £7,279,057, and the length-of-stay inversion is corrected to 16.0 months (the book prints 16.7, having charged marketing as a share of rent).
Download the workbook32 KBTwelve workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own; the four book workbooks alone are in The_Four_Workbooks.zip392 KB. 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 →
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.
The four workbooks with every input emptied. The checks sheets count what is still missing and test what holds for any inputs.
Every chapter
The cohort engine, the planner, the tracker and the bid sheet, with the same formulas and every blue cell emptied. The increases tested and the search grid are kept. Nothing runs until the last input is in; then the whole engine does.
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: 13.8 months, £510,124, an optimum of 12.82 per cent, a bid of £7,279,057.
Download the blank set197 KBThirteen pages to print and use. A4, with margins wide enough for US Letter.
Chapters 1 to 30 · Appendices A and D
The five-minute test and the six things to check first. The eighty-five questions of Appendix A across five pages, with a measurement table for the response to an increase. Length of stay from the two raw series, with the three definitions side by side. The lease-up plan tested against the flow it requires. The catchment: the planning register and the competitor walk. Arrears, the lien and the licence. The wrapper: VAT and the going concern, capital allowances, the protection product. The operator agreement and the unstaffed store. The committee paper with the omissions table.
Download the PDF38 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 unit-month and the four prices, seven on increases, stay and the customer, seven on denominators, occupancy and costs, six on income lines, tax and the market, seven on cash flow, value, debt and the bid, and six on the three cases. Every numeric answer comes from the models; the reasons are on the last sheet.
Download the workbook17 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.
Chapters 5 and 24 · Case one
Chapter 24 says a buyer moving the increase toward the optimum would want to see the rent roll re-age, and sends the reader to the workbook. Every cohort in every month: move-ins jump at once, income dips below the old policy in months 1 and 2, and year 1 delivers £9,584 of the £23,962 steady-state gain (40 per cent). It all arrives only after two years, when every customer has climbed four increases to the cap.
Chapter 7 · Case two
Chapter 7 recommends testing a deeper promotion in two stores and never says what result would decide it. Eight weeks free, converting 15 per cent more of the same enquiries (ADDED), adds £82,157 a year if its customers stay as long; it loses money if they stay 0.81 of a month less. The test decides it at month twelve: 37.7 per cent of the intake still there, against 39.9 for today’s offer.
Chapter 20 · Case three
The chapter’s opening followed month by month: half the fall in occupancy by month 9, ninety per cent by month 30. A buyer valuing on the trailing twelve months nine months later (ADDED) overpays £875,095. Holding the flow is worth up to £2,424 for each extra move-in, 19 times what marketing pays for one today.
Download the three cases163 KB
Blue on pale blue is an input you may edit. A yellow fill is the carrying assumption of the sheet — the one to argue about first. Black is a formula. Nothing is locked, protected or watermarked. There are no macros and no external links.
Every workbook ends with a sheet called Checks: the figure as the book prints it, the figure the workbook computes, the variance and a status, closing on ALL OK. If a line ever reads “to check”, the workbook and the book have drifted apart — and the workbook is right.
The increase applied to existing customers is what manufactures the rent roll, and how far to push it turns on a number nobody publishes: how sharply customers respond. The second workbook exists to measure it rather than assume it. What the book can say is which part of the conclusion survives not knowing: the optimum ranges from 10.1 per cent to 17.4 per cent across plausible beliefs — too wide to act on as a figure — but under every one of them it lies above the 8.2 per cent this store applies. The magnitude does not survive. The direction does.
| 23 Sep 2026 | The four workbooks corrected and completed. The model now computes what it announced: the lease-up from the cohorts, the ten years, the debt, the bid (£7,279,057) and the optimum increase (12.82 per cent); the planner and the bid sheet recalculate. Corrected: a move-out loses £2,691 of value on average, not £1,094; with marketing charged per customer, the length-of-stay inversion is 5.60 per cent and 16.0 months, not 5.35 and 16.7, the gap to the national churn is worth £29,958 a year, not £22,968, and a month of stay £19,696, not £15,369. 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.
Self-Storage Real Estate 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.
These files accompany Self-Storage Real Estate. 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.
Also available as a standalone free template: Self-storage financial model.