Companion files · The Private Markets Career Guides
Operating expenses, CAM reconciliations, budgets, turnover, capital projects and the daily work of running commercial property.
These are the companion files of the book. One workbook rebuilds the fictional files of Halden Property Services: Calder Point, a 180,000 square foot office building, with its 2025 expense pools, gross-up, management fee and the reconciliation of its four tenants; Juniper Flats, a 240-unit apartment community, with its 2026 operating budget and the full cost of a move-out; and the rooftop HVAC replacement at Calder Point, from bid leveling to what the owner and the tenants each gain. A toolkit holds the checklists of Appendix B in an editable form.
The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.
Chapters 8, 9, 10, 12 and 13
One Inputs sheet holds every assumption: expense pools, occupancy, leases, estimates, rents, budget lines, turnover, bids and savings. One sheet per analysis, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook31 KBAppendix B
Daily and weekly building walk, work order standards, vendor onboarding and certificate of insurance check, budget preparation, CAM reconciliation, move-out and make-ready, capital project from scope to closeout, and the monthly report.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me2 KB| Reconciliation | Calder Point bills its four tenants $1,113,977 for 2025 against $1,078,000 of estimates; the owner recovers 50.7 percent of what it paid and absorbs $1,083,247 |
| Move-out | One move-out at Juniper Flats costs $4,102 in all, and every part ties to a budget line; 5 more points of retention save $49,224 a year, 1.8 percent of NOI |
| HVAC | Leveling turns a $140,000 lead into $30,000; the owner gains $138,592 a year, a 10.0-year payback against 9.3 years on the simple view |
The files are provided as they are, without warranty of any kind. Halden Property Services, Corvane Real Estate Partners, Calder Point and Juniper Flats are fictional, the models are simplified teaching models, and the figures are the book’s assumptions. Nothing here is legal, tax or investment advice.
More in real estate, with free companion files. The full list of titles is on the author page.
Optional: join the reader list to get an email when a workbook is corrected or a new title goes up.