Companion files · The Private Markets Career Guides
Running a Profitable Residential Property Management Company: Fees, Revenue per Door, Leasing, Maintenance, Trust Accounting, Fair Housing, Screening, Owner Churn and Buying a Portfolio.
DRM-free PDF edition, $19.99: searchable, printable, instant download.Buy the PDFFree sample
These are the companion files of the book. Six workbooks follow Thistlewick Property Management, the fictional residential management company of the case, across two fiscal years: the fee schedule, unit economics, leasing and maintenance, the trust reconciliation, growth and acquisition, and cash and valuation. A toolkit holds the checklists of Appendix B in editable form.
The archive holds the six workbooks, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbooks recalculate in Excel, LibreOffice or Google Sheets.
Chapters 3 and 12
An owner statement rebuilt line by line, and the percentage fee against a flat monthly fee. Sheets: Inputs, Statement, Flat fee. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 112 KBChapters 4 and 13
Revenue, cost and contribution per door per month for both years, and doors per portfolio manager. Sheets: Inputs, Per door. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 212 KBChapters 7 and 9
The rent lost to vacant days, and a move-out from the deposit held to the refund. Sheets: Inputs, Vacancy, Deposit. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 312 KBChapters 10 and 11
The monthly three-way reconciliation, with any owner ledger below zero flagged. Sheets: Inputs, Three-way. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 411 KBChapters 14 and 15
Churn, the life of a door and the cost of winning one, the price of a portfolio and its earn-out. Sheets: Inputs, Churn, Price, Earn-out. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 514 KBChapter 16
Seller’s discretionary earnings, a buyer’s indication, and the term loan payment and balance. Sheets: Inputs, SDE, Loan. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 612 KBAppendix B
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.
Download the toolkit42 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me4 KB| The owner statement | Owner account 1187, September 2026: $5,185.00 collected, $2,960.70 paid to the owner |
| The trust shortage | Adjusted bank balance $395,057.55 against $396,899.55 owed out: short $1,842.00 |
| The portfolio price | 176 doors, trailing fees $219,099 at 1.10 times: $241,009, of which $96,404 as an earn-out |
The files are provided as they are, without warranty of any kind. The model is illustrative: Thistlewick Property Management, Corvelle, Fennimarsh Rentals and every party are fictional, and the rents, fees, vacancy periods, costs, prices and multiples are the book’s assumptions, not market terms or the practice of any real company. Rules change and differ by state: check the current texts, your outside CPA and your counsel.