Short-term rental calculator

Enter twelve months of nightly rate and occupancy, the fees and every cost a host carries, and the rent the same property would fetch on a long-term let. You get nights, stays, booking revenue, every cost line and net profit by month, and the year's answer to the question that matters: short-term or long-term. Same logic as the Bindler workbook, verified against it.

Bookings and fees

Average length of stay, nightsCleaning fee charged to guests per stayCleaning cost paid per stay Platform host fee, % of booking revenueConsumables and welcome supplies per stayProperty management, % of booking revenue

Fixed monthly costs

Mortgage or rent for the propertyUtilities and internetInsurance Repairs and replacements reserveLicence, HOA and other fixed costs

Long-term let of the same property

Monthly rentVacancy and credit loss, % of rentManagement, % of rentRepairs reserve, monthly

The long-term let carries the same mortgage and insurance; utilities, licence and short-term reserves are the host's alone.

Twelve months

Month	Days	Nightly rate	Occupancy, %
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec

The workbook: Inputs, Summary, Months and the GuideShort-Term Rental Profit Calculator, $19: twelve months with every revenue and cost line in its own column, the summary with RevPAN, break-even occupancy and net margin, the long-term let beside it, and a Guide. Verified through a formula engine before listing.

See the workbook

Method: nights booked are days times occupancy; stays are nights over the average length of stay; booking revenue is nights times rate plus cleaning fees collected. Costs each month: the platform fee and management on booking revenue, cleaning and consumables per stay, and the fixed lines. The long-term let is rent less vacancy and management, less its repairs reserve, mortgage and insurance. Break-even occupancy is the year's fixed costs over nightly revenue at full occupancy at the average rate achieved. Income tax, night caps in licensing, furnishing capital and guest-side platform fees are outside this page. Same logic as the Bindler workbook. Arithmetic on your assumptions, not investment or tax advice.