Short-Term Rental Furnishing Budget Planner

Furnishing a short-term rental is the biggest cheque a new host writes — usually with no idea what it does to the nightly rate. This planner budgets the setup room by room, item by item, then divides the whole spend by the nights you actually expect to sell. That one number — furnishing cost per booked night — is the number that tells you whether your rate works.

The sample unit: $7,290.00 budgeted across 26 items in 6 rooms, $7,056.00 actually spent, $234.00 left over. The roll-up keeps it honest — Kitchen & Dining finished $24.00 OVER its room budget (the dining set and small appliances crept) while every other room came in under. At 165 expected booked nights, the furnishing cost works out to $42.76 per booked night against a $145 target rate — and at that rate the whole setup earns itself back in 48.7 booked nights. The replacement reserve then spreads each group’s renewal cost across its life ($107.21 a month), so year-three bedding is already paid for when it wears out.

What it does for you:
– Budgets 26 pre-loaded items across 6 rooms (add your own) with budget vs actual and per-room roll-ups
– Flags any room that goes OVER BUDGET while the unit total can still be under — creep stays visible
– Computes furnishing cost per booked night and the nights needed to earn the setup back at your target rate
– Builds a replacement reserve (beds, sofas, electronics, linens, kitchen gear, decor) by year and by month
– Adds a launch expense log, zero-based monthly budget, dashboard and 12-month summary

What’s inside (.xlsx, works in Excel AND Google Sheets):
– Start Here — setup steps, expected booked nights and target nightly rate settings
– Room-by-Room Budget — 26 items in 6 rooms + the per-room roll-up
– Cost Per Night & Reserve — cost per booked night, % of rate, payback nights, replacement reserve
– Expense Log, Monthly Budget, Dashboard, Monthly Summary

Instant download. Type only in the yellow cells — formula cells are locked (password: sheetdaily, disclosed on the Start Here tab so you can unlock if you ever need to). Sample unit is pre-filled so you can see exactly how it works; clear the yellow cells and type your own. Planning tool only — permit, licence and tax rules for short-term rentals vary by city; confirm yours locally.