How to Set Airbnb Nightly Rates by Season (Spreadsheet Method)

Most hosts price by feel. The place is quiet in January so they drop the rate, it is busy in July so they nudge it up, and at the end of the year they have no idea whether either move made money.

There is a single line of arithmetic that settles it. Before you change a rate, work out how much occupancy the new rate needs just to break even. If the number is above where you realistically expect to land, do not make the change.

Here is the formula, worked through on a real-shaped property, plus how to build the seasonal rate table it feeds.

The break-even occupancy formula

A rate change only pays if the revenue per available night — RevPAR — goes up. RevPAR is rate × occupancy, so for a change to leave you level:

Break-even occupancy = old occupancy × (old rate ÷ new rate)

That is it. Everything below is applying it.

Case 1: should you discount the off season?

Harbor Loft, January to March. 90 nights. Currently listed at $150, running 52% occupancy.

Current RevPAR: $150 × 52% = $78.00

You are considering dropping to $129 to fill the calendar.

Break-even occupancy = 52% × ($150 ÷ $129) = 60.5%

So the cut only makes sense if it lifts you above 60.5%. Below that, you have discounted for nothing. This is where a lot of off-season pricing goes wrong — a 14% price cut sounds modest, and it quietly demands an 8.5-point occupancy gain before it earns a cent.

Say the market response is good and you get to 71%:

Now subtract the cost the RevPAR calculation cannot see. Filling more nights at an average three-night stay means about 5.7 extra turnovers over the quarter. If the guest pays $110 for cleaning and the true turnover cost is $125 — cleaner $95, laundry $12, consumables $18 — each extra stay is $15 out of pocket:

Still clearly worth doing. But notice that if the cut had only reached 63% occupancy instead of 71%, the RevPAR gain would have been thin and the extra turnovers would have eaten a meaningful share of it. The break-even is a floor, not a target — you want daylight above it.

Case 2: should you raise the peak?

Same property, July and August. 62 nights, listed at $205, running 94% occupancy.

That 94% is the tell. A property that is nearly always full is not a well-run property — it is an underpriced one. There is no inventory left to sell, so price is the only lever remaining.

Current RevPAR: $205 × 94% = $192.70

Test $239, a 17% rise:

Break-even occupancy = 94% × ($205 ÷ $239) = 80.6%

You have 13 points of headroom. Occupancy would have to collapse from 94% to below 81% before the rise costs you anything. At a realistic 88%:

And unlike the discount, this one comes with fewer turnovers, not more. Higher rate, less work, more money.

Together the two changes are worth about $2,230 a year on a single unit — from two calculations and no new guests, no new photos and no new listing.

Setting the seasons from your own data

The formula is useless without knowing your real occupancy by month, which means the sequence is: log first, season second, price third.

Step 1 — pull twelve months of occupancy and RevPAR by month. From a booking log with check-in and check-out dates this is a single pivot. If you do not have a year of history yet, use what you have and revisit; do not import someone else’s seasonal calendar for your market.

Step 2 — sort the months by RevPAR and look for the breaks. They are usually obvious. A coastal condo might land like this:

Three seasons is usually enough. Four if there is a genuine second peak. More than that and you are administering a spreadsheet rather than running a property.

Step 3 — set a base rate per season, then apply modifiers. Keep the modifiers as a short, explicit list rather than baking them into the base:

• Weekend premium — Friday and Saturday, typically 10–25% over the weeknight rate
• Event dates — a named list of local dates that behave nothing like the season around them. Ten lines, updated once a year, and consistently the highest-return part of the whole exercise
• Last-minute — a small discount inside 7 days, because an unsold night is worth zero
• Length-of-stay discount — a weekly rate that looks generous and usually is not, since longer stays are worth nearly double per night at the same rate

Step 4 — check every proposed rate against your floor. Break-even occupancy tells you whether a change beats the status quo. It does not tell you whether the resulting rate is above your actual cost. For Harbor Loft the break-even nightly rate — the point where a booking covers its direct costs and its share of the fixed costs — is $168. So the off-season list price of $150 is already below cost, and $129 is well below it. Those bookings are still worth taking, because an empty night contributes nothing and a $129 night contributes something toward fixed costs that exist regardless. But you should know you are doing it, and you should never let an off-season rate become the anchor for your shoulder season.

The pricing log that makes next year easier

One tab, one row per season per property, six columns: date range, property, your rate, competitor average rate, occupancy achieved, notes on what was happening. Two minutes a month.

After one year you can price from evidence. After two you can see whether a change worked, because you have the same season under two different rates — the only genuinely reliable pricing experiment available to a host, and one you cannot run retroactively.

Keep the competitor column honest: three or four comparable listings, same bedroom count, same sub-area, checked on the same day each month. Not the whole market, and not the one aspirational listing with the hot tub.

The short version

Never change a rate without running old occupancy × old rate ÷ new rate. Discount only when you expect occupancy comfortably above that break-even, and subtract the turnover cost of the extra stays. Raise whenever occupancy sits above about 90%, because the headroom is enormous. Build three or four seasons from your own RevPAR history, add a weekend premium and a list of event dates, and log the result so next year is a calculation instead of a guess.

All of it runs off the same booking log as the rest of your numbers — here is how to set that up, and here is how to calculate the occupancy, ADR and RevPAR figures this article depends on.