Hotel Cost Calculator Formula
Understand the math behind the hotel cost calculator. Each variable explained with a worked example.
Formulas Used
Total Hotel Cost
total_cost = room_subtotal + tax_total + fees_totalTrue Cost Per Night
avg_per_night = (room_subtotal + tax_total + fees_total) / nightsTotal Taxes & Fees
taxes_fees = tax_total + fees_totalVariables
| Variable | Description | Default |
|---|---|---|
nightly_rate | Nightly Rate(USD) | 159 |
nights | Number of Nights | 3 |
tax_pct | Hotel Tax Rate(%) | 14 |
resort_fee | Daily Resort/Amenity Fee(USD) | 25 |
parking_daily | Daily Parking Fee(USD) | 0 |
room_subtotal | Derived value= nightly_rate * nights | calculated |
tax_total | Derived value= room_subtotal * tax_pct / 100 | calculated |
fees_total | Derived value= (resort_fee + parking_daily) * nights | calculated |
How It Works
How Hotel Costs Add Up
The advertised nightly rate is just the start. Taxes and fees can add 20-40% to the total.
Formula
Total = (Nightly Rate x Nights) x (1 + Tax%) + (Resort Fee + Parking) x Nights
Worked Example
3 nights at $159/night, 14% tax, $25 resort fee, no parking.
nightly_rate = 159nights = 3tax_pct = 14resort_fee = 25parking_daily = 0
- 01Room subtotal = $159 x 3 = $477.00
- 02Taxes = $477 x 14% = $66.78
- 03Resort fees = $25 x 3 = $75.00
- 04Total = $477 + $66.78 + $75 = $618.78
- 05True per-night cost = $618.78 / 3 = $206.26
Ready to run the numbers?
Open Hotel Cost Calculator