Store / Short-Term Rental Analyzer & Tracker
Short-Term Rental Analyzer & Tracker
Will this home earn more as a short-term rental, and by how much?
A short-term rental spreadsheet for two jobs. Buying: it prices the stay month by month and compares the result with renting the same home on a 12-month lease. Running: once guests are booking, it tracks each month against your plan. For Excel and Google Sheets.
Excel + Google Sheets · No macros · .xlsx download
$19 one payment · no subscription
Five reasons to use it
- Short-term vs long-term, side by side Revenue, costs, NOI, cash flow and cash-on-cash for both. You see what the furniture and the extra work actually buy you.
- Month by month, not one average Enter the nightly rate and occupancy for each month. The sheet works out nights booked, cleaning fees, platform fees, turnover costs, fixed costs and cash flow for every month and for the year.
- Real per-stay costs Average stay length drives how many turnovers you pay for: cleaning, supplies and laundry against the cleaning fee you charge.
- Know your floor It shows your break-even occupancy, plus a grid of yearly cash flow if the nightly rate drops up to 20% or bookings fall up to 30%.
- Track it once it's live Type each month's real nights, revenue and costs. It shows whether you're ahead of or behind plan, and where the year will end if the rest goes to plan.
What you get
- One .xlsx workbook with four tabs:
- How to use: one page.
- Inputs: the purchase, furniture and loan; 12 months of rate and occupancy; per-stay fees and costs; 13 running costs, from utilities to permits and reserves; the long-term rent comparison; your targets.
- Results: the verdict, and short-term vs long-term; occupancy, average rate, cap rate and break-even; the month-by-month table; the what-if grid.
- Actuals: a 12-month tracker against your plan.
- No macros. The formulas are locked, and the sheet uses only functions Google Sheets supports.
- A filled-in sample cabin, with invented numbers, so you can see it work before you type in yours.
Honest limits
- Local rules come first. Some cities, counties and HOAs ban, cap or license short-term rentals. The sheet can't check that for you.
- It gives estimates, not financial, tax or legal advice. A result is only as good as the rates and occupancy you enter. Use booked prices for similar homes nearby, not listed prices.
- Taxes are partly left out. Income taxes aren't included, and lodging taxes are only counted if you enter a % you pay yourself.
- One property per file, and year 1 only. There's no multi-year projection or sale.
- The tracker compares monthly totals only. It doesn't import bookings or keep a line-by-line expense ledger.
Questions
- Does it work in Google Sheets?
- Yes. We opened it in Google Sheets, and every formula gave the same result as our own checks. Upload the .xlsx to Google Drive and open it. Google Sheets doesn't keep the cell locks, so avoid typing over grey cells.
- Does it work for Airbnb and VRBO?
- Yes. Enter your platform's host fee as a %.
- I already own the home. Can I still use it?
- Yes. Enter what you paid and your loan, or use 100% down if you own it outright. Then use the Actuals tab each month.
- I use a co-host or manager. Where does that go?
- Enter their share as "Management or co-host (% of revenue)".
- Can I unlock the formulas?
- Yes. In Excel, go to Review > Unprotect sheet. There's no password.
More from the store
Spreadsheets for estimating, not advice. The sample data is invented.