# The Commercial Property Manager: companion files

Julian R. Sterling

## What is here

- **Property_Manager_Model.xlsx**: the workbook that rebuilds the book's case files with live formulas. Sheets: Inputs, Calder_Expenses, Calder_Recon, Juniper_Budget, Juniper_Turnover, HVAC_Bids, HVAC_Recovery, Checks.
- **Property_Manager_Toolkit.docx**: the checklists of Appendix 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, monthly report), in editable form.

## Which sheet answers which chapter

- Chapters 8 and 10: Calder_Expenses and Calder_Recon (Calder Point: 2025 expense pools, gross-up, management fee, and the reconciliation of the four tenants)
- Chapter 9: Juniper_Budget (Juniper Flats: gross potential rent to NOI, expense lines, management fee, expense ratio, per unit)
- Chapter 12: Juniper_Turnover (the full cost of a move-out and the value of 5 more points of retention)
- Chapter 13: HVAC_Bids and HVAC_Recovery (bid leveling, payback, amortization capped at the savings, and the effect on the owner and the tenants)

## Two inputs to change first

1. On Inputs, change the gross-up occupancy for Calder Point from 95 percent to 100 percent: watch what each tenant owes on Calder_Recon and what the owner absorbs.
2. On Inputs, lower the Juniper Flats turnover or raise the share of full turns: see the full cost of a move-out and the retention saving on Juniper_Turnover, and the concession and turnover lines move in Juniper_Budget. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light yellow background is an input, black type a formula. No macro, no circular reference, no external link. The management fee is charged on cash collected, so it does not depend on the reconciliation it feeds. The Checks sheet should read ALL CHECKS OK on the default inputs.

Halden Property Services, Corvane Real Estate Partners, Calder Point and Juniper Flats are fictional; the models are simplified teaching models; all case figures are illustrative assumptions. Provided as is, without warranty. Not legal, tax or investment advice.
