# The Vacation Rental Management Business Owner: companion files

Julian R. Sterling

## What is here

- **VRMBO_1_Nights_and_Rates.xlsx** (Chapter 5; Nights and Rates workbook of Appendix A): sheets Inputs, Occupancy, Nightly rate, then Checks. Occupancy (60.5 percent then 58.3 percent), the average nightly rate ($264.25 then $273.51), rent per available night and guest spending before lodging taxes.
- **VRMBO_2_Channels_and_Owner_Statement.xlsx** (Chapters 7 and 12; Channels and Owner Statement workbook): sheets Inputs, Channels, Owner statement, then Checks. The cost of each channel and who bears it ($392,609 in FY2026), and one cottage's year from rent to the owner's payout ($37,925).
- **VRMBO_3_Fee_Plans.xlsx** (Chapter 4; Fee Plans workbook): sheets Inputs, Meeting point, Home types, then Checks. The net rent where the two fee plans meet ($22,800 a year) and what each plan brings on one home of each type.
- **VRMBO_4_Turnovers.xlsx** (Chapter 9; Turnovers workbook): sheets Inputs, Team, By month, then Checks. The in-house cost per turnover ($98.57) and FY2026 cleaning month by month, with the team and with contracted crews only.
- **VRMBO_5_Unit_Economics.xlsx** (Chapter 14; Unit Economics workbook): sheets Inputs, Contribution, Break-even, Home types, then Checks. Contribution per home ($12,500.20 then $15,657.67), the break-even (41 then 48 homes on average), net income, and what one home of each type leaves the company.
- **VRMBO_6_Cash_and_Valuation.xlsx** (Chapter 16; Cash and Valuation workbook): sheets Inputs, SDE, Indication, then Checks. Seller's discretionary earnings ($161,594 then $257,283) and the fictional buyer's indication.
- **VRMBO_Vacation_Rental_Checklists.docx**: the 8 checklists of Appendix B, editable (Before signing a home; Management agreement checklist; Onboarding and listing checklist; Turnover checklist; Empty-home visit checklist; Guest incident checklist; Monthly reconciliation and payouts checklist; Lodging tax month and the monthly review page).

## How to use the workbooks

The first tab of each workbook, Inputs, holds every input in two input columns, followed by a Used column: the case's figures in blue on a light blue background, and an empty yellow column for yours. The Used column takes your figure when you type one and the case figure otherwise, and every other sheet reads the Used column. Black type is a formula, green type a link to another sheet. Rebuild the case first: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK while the yellow column is empty. Each of the 16 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: add, subtract, multiply, divide and round. When a figure is rounded, the note at the top of the sheet says how.

Two inputs to try first:

1. In VRMBO_4_Turnovers.xlsx, on Inputs, type a lower number of condo and cottage turnovers for January and February: the team's cost stays, the cost per turnover rises, and the difference in favor of the team shrinks.
2. In VRMBO_3_Fee_Plans.xlsx, on Inputs, type the net rent of your own average home: if it sits above the meeting point, a lower commission with a monthly fee is a price cut on that home.

To use a workbook on your own company, fill the yellow column from the property management system, each platform's payout reports, the bank statements of the account you hold for owners and guests, and the income statement, in the order Appendix A gives, and keep a copy with the case column for comparison. The workbooks are separate files with no link between them.

## A word of caution

Ostrevale Shore Stays, LLC, the town of Ostrevale, its owners, guests, cleaning crews, platforms and the regional company that gave an indication are fictional. Rates, fees, commissions, prices, costs, occupancy, counts and multiples are teaching assumptions, not market norms or recommendations. Permits, lodging taxes, trust accounting, employment and insurance rules change and differ by city and state: read them in their current text, with your outside CPA, your insurance broker and your counsel. No platform, software, device or insurer is described or recommended. Nothing here is legal, tax, insurance or accounting advice.
