SENIOR LIVING AND HEALTHCARE REAL ESTATE - COMPANION FILES
julianrsterling.com/senior

Free. No sign-up, no email address. Nothing is locked, protected or watermarked.
Revised 24 September 2026.

Optional: to get an email if these files are ever corrected, join the reader list at
https://julianrsterling-readers.subscribepage.io/
(run by MailerLite, off the site; nothing in this archive needs it).

WHAT IS IN THE ARCHIVE

1. The book's four workbooks, corrected
   Care_Home_Model.xlsx               the resident engine, the whole book
   Payor_Mix_Tracker.xlsx             Chapters 5 and 6
   Rota_And_Employer_Cost.xlsx        Chapters 7 and 8
   Bid_Sheet.xlsx                     Chapters 14, 19 and 22
   00_START_HERE.md                   what changed is at the end
   Each workbook closes on a checks sheet that ends ALL OK.

2. Blank_Model_Set/  (new)
   The four workbooks with every input emptied, for your own home. Each
   checks sheet counts what is still missing and tests what holds for any
   inputs. The book's figures are in book_inputs.txt: type them back in and
   the book's results come back.

3. Working_Documents.pdf  (new)
   Thirteen printable pages: the first meeting, occupancy as a flow, who pays
   and when the capital runs out, the calendar and the average fee, hours to
   a loaded staff cost, agency and the cost base, reading a trading pack, the
   bridge per resident, the lease and the identity, sale and leaseback and
   the debt, the twenty-five-year gap test, the regulator, and building and
   bidding. A4, fits Letter.

4. Forty_Questions.xlsx  (new)
   Forty questions across the book, marked by the file as you type.

5. Cases/  (new)
   Case_1_What_A_Good_Manager_Is_Worth.xlsx        Conclusion, Chapters 9 and 19
   Case_2_The_Capital_Programme.xlsx               Chapters 10, 13 and 15
   Case_3_A_Rent_That_Moves_With_Fees.xlsx         Chapter 17
   Each case: the note on the first sheet, the model after it, checks at the end.

The files open in Excel, LibreOffice Calc, Google Sheets and Numbers. No macros.
