Real Estate
Convert occupancy, nightly rate, stay length, turnover costs, fixed expenses, reserves, and debt service into seasonal vacation-rental cash flow.
MONTH-BY-MONTH DEMAND MAP
DETAILED CALCULATION PROCESS
Bookings create both nightly rent and cleaning-fee income. Turnover count creates cleaning expense, while platform fees follow guest revenue rather than only rent.
Booked nights = Available nights x Occupancy rate Stays = Booked nights / Average stay Guest revenue = Booked nights x Nightly rate + Stays x Cleaning fee charged Platform fees = Guest revenue x Platform-fee rate NOI = Guest revenue - Platform fees - Stays x Cleaning cost - 12 x Fixed expenses - Reserve Owner cash flow = NOI - 12 x Monthly debt service DSCR = NOI / Annual debt service Break-even occupancy = (Fixed expenses + Reserve + Debt service) / contribution generated at 100% occupancy 1. Booked nights = 340 x 0.64 = 217.6 nights; stays = 217.6 / 3.8 = 57.3.
2. Guest revenue combines nightly rent and cleaning fees.
3. Platform and turnover costs are deducted before fixed expenses.
4. NOI is reconciled to cash flow after debt service.
5. Break-even occupancy is solved from the same contribution model.
OPERATING LEDGER
The seasonal curve redistributes the entered annual occupancy across the year while preserving the annual booked-night total. It is a planning pattern, not a destination forecast.
| Month | Modeled occupancy | Booked nights | Guest revenue | NOI before reserve | Owner cash flow |
|---|
METHOD
LIMITATIONS
The calculator excludes taxes on profit, acquisition costs, appreciation, dynamic pricing, minimum-stay constraints, cancellations, separate management commissions, and financing principal balances. Seasonality is a smooth illustrative curve and may not match local demand.
FAQ
No. The model records the fee as guest revenue and separately subtracts the entered cleaning cost for every estimated turnover.
DSCR compares NOI with debt service. Replacement reserve is already deducted in this model, but owner taxes and capital events may still reduce spendable cash.
Shorter stays create more turnovers for the same booked nights, increasing both cleaning-fee revenue and the separately entered turnover expense.
The denominator is the entered available-night inventory after owner blocks and closures. Changing that inventory changes both feasible booked nights and the occupancy needed to cover modeled costs.