Short-Term Rental Profit Calculator
Nightly rate and occupancy by month, every host cost, STR vs long-term let, verified
Nightly rate and occupancy by month, platform and cleaning fees, every host cost, and the long-term let of the same property beside it; every line verified.
One price, no licence to choose. Payment and VAT are handled by Gumroad, the merchant of record.
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.
Checked, not asserted. This workbook was recalculated cell by cell through a formula engine and matched against an independent replica written separately: 31 checks, all passing, last run 2026-10-17. Each check compares the figure the workbook produces against one worked out separately by hand before the run, so a figure lost in packaging fails the check rather than reaching you. Read the verification report for the UAE Corporate Tax workbook, or how Bindler verifies.
What was checked: all 14, by name
Each line is one figure recalculated and matched against a value worked out by hand before the run. The figures themselves are in the workbook.
- B4 Nights booked in the year vs
- B5 Occupancy for the year vs
- B6 Average nightly rate achieved vs
- B7 Booking revenue for the year vs
- B8 Revenue per available night (RevPAN) vs
- B9 Total costs for the year vs
- B10 Net profit, short-term rental vs
- B11 Net profit, long-term let of the same property vs
- B12 Short-term advantage for the year vs
- B13 Break-even occupancy at the average rate (costs th vs
- B14 Net margin on booking revenue vs
- month 1: net vs , long-term vs
- month 7: net vs , long-term vs
- month 12: net vs , long-term vs
What is inside
1 Excel workbook (.xlsx), sheets: Inputs, Summary, Months, Guide.
Use it if
You host or are considering hosting a property short-term and want the profit computed with every cost shown.
Not for
You need a multi-property portfolio model or a purchase analysis; use the Rental Property Analyzer for the purchase decision.
Who you are buying from
Bindler is the trading name of Neil Sangwaiya, one person in Dubai. There is no company behind that name, no sales team and no reviews, and this page is not going to pretend otherwise. What there is instead is a record. Gumroad takes the payment and is the merchant of record, so your card details never reach Bindler. Where a figure could not be verified the cell is left blank rather than filled. When something was found wrong it was written down and dated in the change log with the old figure named. And there is a 30-day money back guarantee, no reason needed, handled by Gumroad.
What you actually download
One spreadsheet file. No macros and no VBA, because the .xlsx format cannot carry them. No locked cells and no hidden sheets. If your IT will not let you open a spreadsheet from outside, upload it to Google Sheets and it opens there. And yes, an AI built it: that is exactly why every figure is recalculated against a replica worked out by hand first, rather than trusted.
Sheet previews
How buying works
- Choose a licenceSingle user for one person, team for up to 10, consultancy to use with clients. The buttons above go to the Gumroad page.
- Pay on GumroadCard or PayPal; Gumroad is the merchant of record and handles VAT and the receipt.
- Download the fileThe .xlsx arrives on the receipt page and by email. It opens in Excel and Google Sheets; nothing to install.
- Use itYellow cells are inputs, blue cells are formulas, every figure names its source. Questions: reply to the receipt; every reply is read and answered, usually the same day.
Advisers and accountants who recommend these workbooks to clients can earn 30% of each sale as a Gumroad affiliate: sign up on the store, no approval wait.
Search terms this page answers: airbnb profit calculator excel, short term rental calculator spreadsheet, str vs long term rental calculator, vacation rental income spreadsheet occupancy.