# The Property Management Business Owner: companion files

Julian R. Sterling

## What is here

- **PMBO_1_Fee_Schedule.xlsx** (Chapters 3 and 12; Fee Schedule workbook of Appendix A): sheets Inputs, Statement, Flat fee, then Checks. The September 2026 owner statement of owner account 1187 rebuilt line by line ($2,960.70 paid to the owner) and the percentage fee against a flat monthly fee (break-even $129.76 per door per month).
- **PMBO_2_Unit_Economics.xlsx** (Chapters 4 and 13; Unit Economics workbook): sheets Inputs, Per door, then Checks. Revenue, recurring cost and contribution per door per month for FY2025 and FY2026 ($175.92 then $174.77 of revenue) and doors per portfolio manager (148.7 then 131.2).
- **PMBO_3_Leasing_and_Maintenance.xlsx** (Chapters 7 and 9; Leasing and Maintenance workbook): sheets Inputs, Vacancy, Deposit, then Checks. The rent lost to vacant days ($278.63 for five extra days on one turnover) and the August 2026 move-out from the deposit held to a refund of $955.00.
- **PMBO_4_Trust_Reconciliation.xlsx** (Chapters 10 and 11; Trust Reconciliation workbook): sheets Inputs, Three-way, then Checks. The three-way reconciliation of 30 September 2026: bank, book and ledgers, and the shortage of $1,842.00 that one negative owner ledger hid.
- **PMBO_5_Growth_and_Acquisition.xlsx** (Chapters 14 and 15; Growth and Acquisition workbook): sheets Inputs, Churn, Price, Earn-out, then Checks. Churn (12.1 then 10.6 percent), the life of a door and the cost of winning one, the Fennimarsh price ($241,009) and the earn-out forecast ($90,379).
- **PMBO_6_Cash_and_Valuation.xlsx** (Chapter 16; Cash and Valuation workbook): sheets Inputs, SDE, Loan, then Checks. Seller's discretionary earnings ($185,468 then $238,218), the buyer's indication before debt and earn-out, and the term loan payment ($6,313.51 a month) with its balance at 30 September 2026.
- **PMBO_Owner_Checklists.docx**: the 8 checklists of Appendix B, editable (Taking on a new owner; Listing and screening a vacancy; Move-in; Move-out and the deposit statement; Monthly trust reconciliation; Owner statement review before distribution; Buying a portfolio: due diligence; The owner's monthly review).

## How to use the workbooks

The first tab of each workbook, Inputs, holds every input: blue type on a light blue background. Black type is a formula, green type a link to another sheet. Change one input at a time, note the result, and set the input back before the next test: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK at the base case. Each of the 13 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: add, multiply, divide and round, plus the spreadsheet's payment function for the loan. When a figure is rounded, the note at the top of the sheet says how.

Two inputs to try first:

1. In PMBO_1_Fee_Schedule.xlsx, on Inputs, change the management fee from 8 to 7 percent: the fee, the net paid to the owner and nothing else on the statement moves, because the markup applies to the invoices only.
2. In PMBO_4_Trust_Reconciliation.xlsx, on Inputs, set the owner account 2041 ledger to zero: the shortage disappears and the negative ledger flag clears.

To use a workbook on your own company, work in a copy and overwrite the blue cells only, from the bank statement, the ledger reports and the signed agreements. The workbooks are separate files with no link between them.

## A word of caution

Thistlewick Property Management, LLC, the city of Corvelle, Fennimarsh Rentals and every party in the case are fictional. Rents, fees, percentages, vacancy periods, costs, interest rates, prices and multiples are teaching assumptions, not market norms or recommendations. Fair housing, screening, trust account and security deposit rules change and differ by state and city: read them in their current text, with your outside CPA and your counsel. No software is described or recommended. Nothing here is legal, tax or accounting advice.
