Companion files · The Private Markets Career Guides

The Commercial Property Manager

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 workbook, the toolkit and the read-me, in one archive69 KB

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.

The files

Three numbers to reproduce first

ReconciliationCalder 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-outOne 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
HVACLeveling 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.

Also by Julian R. Sterling

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.