Calculate lodging cost per night from an all-in lodging total or a nightly rate plus fees and an entered percentage. Optionally split the cost equally among guests, or estimate a required nightly rate from fixed costs, variable costs and a target profit margin.
Cost Per Night Formula
The following equation is used to calculate the Cost Per Night.
- Where CPN is the cost per night ($/night)
- TC is the total cost ($)
- N is the number of nights staying at the location
To calculate lodging cost per night, divide the complete lodging total, including applicable fees and taxes, by the number of nights. Do not add taxes again if they are already included. For a whole-trip average, use all trip costs consistently instead.
What is a Cost Per Night?
Definition:
Cost per night expresses the average cost of staying at a hotel or other lodging for one night. Compare complete totals for the same number of nights and guests; a longer stay does not guarantee a lower nightly price.
How to Calculate Cost Per Night?
Example Problem:
The following example outlines the steps and information needed to calculate the Cost Per Night.
First, determine the length of the stay. For this example, a couple is taking a vacation on a 7-night trip to the tropics.
Next, determine the total cost. In this example, the all-in lodging cost is $10,000.00.
Finally, calculate the cost per night using the formula above:
CPN = TC / #N
CPN = $10,000.00 / 7
CPN ≈ $1,428.57 / night
