Short-Term Rental Profit Calculator

Twelve months of days, nightly rate and occupancy give nights booked, stays, nightly revenue, cleaning fees collected and booking revenue. Against that, every cost a host carries: the platform fee, cleaning per stay, consumables, management, mortgage or rent, utilities, insurance, a repairs reserve, licence and other fixed costs. Net profit by month and for the year, beside the long-term let of the same property (rent less vacancy, management and repairs, less the same mortgage and insurance), so the question that matters, short-term or long-term, is answered on your own numbers.

Summary: nights, occupancy, average rate achieved, revenue per available night, total costs, net profit under both uses, the short-term advantage, break-even occupancy at the average rate, and net margin on booking revenue.

• Every month and every summary line recalculated with a formula engine and matched to an independent Python replica before listing.
• Live formulas, no macros, no locked cells; opens in Excel and Google Sheets.
• Income tax, licensing limits on nights, furnishing capital and guest-side platform fees are outside the workbook and the Guide says so. Arithmetic on your assumptions, not investment or tax advice.