Hotel Cancellation Revenue Calculator
Estimates the monthly revenue impact of guest cancellations, factoring in cancellation policy retention and the hotel's ability to resell cancelled rooms. Use it to optimize cancellation policy strictness and overbooking strategy.
About this calculator
When a guest cancels, the hotel faces two possible outcomes: it retains a cancellation fee defined by its policy, or it successfully resells the room to another guest. The revenue impact depends on the interplay between these two recovery mechanisms. A stricter policy (higher policyType %) retains more fee revenue from cancellations. A higher resale rate recovers more revenue from the rooms not covered by policy. The formula is: Revenue Recovered = totalBookings × (cancellationRate / 100) × averageBookingValue × [policyType/100 + (1 − resaleRate/100) × (1 − policyType/100)]. The bracketed term combines fee retention and resale recovery across the cancelled inventory. Revenue at risk is the portion not recovered by either mechanism. Understanding this helps hotels calibrate policy strictness against the risk of booking demand suppression.
How to use
A hotel has 500 monthly bookings, a 15% cancellation rate, and an average booking value of $300. The cancellation policy retains 50% of the booking value (policyType = 50), and the room resale success rate is 60%. Cancelled bookings = 500 × 0.15 = 75. Recovery factor = 0.50 + (1 − 0.60) × (1 − 0.50) = 0.50 + 0.40 × 0.50 = 0.50 + 0.20 = 0.70. Revenue recovered = 75 × $300 × 0.70 = $15,750. Revenue lost = 75 × $300 × 0.30 = $6,750. Tightening policy or improving resale (overbooking, OTA re-listing) directly reduces the $6,750 gap.
Frequently asked questions
How does a stricter cancellation policy affect hotel revenue?
A stricter cancellation policy — such as non-refundable or short cancellation windows — increases the fee retained from each cancellation, reducing revenue leakage. However, overly restrictive policies can suppress booking conversion, particularly for leisure guests who value flexibility. The optimal policy balances fee recovery against booking volume impact. Many hotels now offer tiered options: a lower rate for non-refundable bookings and a slightly higher rate for flexible ones, letting guests self-select based on their risk tolerance.
What is a typical hotel cancellation rate and how does it vary by segment?
Industry-wide hotel cancellation rates typically range from 15% to 40%, depending on booking channel, segment, and policy type. OTA bookings tend to have higher cancellation rates (25–40%) compared to direct bookings (10–20%) due to the ease of cancellation and guest behavior on those platforms. Corporate transient travel sees lower cancellation rates due to contracted rates, while leisure bookings spike around high-demand dates. Seasonality and macroeconomic uncertainty also significantly influence cancellation patterns.
How can hotels improve room resale rates after a cancellation?
Hotels improve resale rates through several tactics: maintaining real-time availability on OTAs and the hotel website so cancelled rooms appear instantly, using dynamic pricing to make re-listed rooms attractive at short notice, and employing strategic overbooking based on historical cancellation forecasts. Last-minute booking platforms and walk-in traffic can also absorb cancelled inventory. Revenue management systems that integrate cancellation forecasting with yield management allow hotels to preemptively fill cancelled rooms before the arrival date.