All articles
Revenue Analysis

Cancellation Exposure: An Illustrative Expected-revenue Calculation

Stayax4 min read
Small hotel model with an empty doorway and translucent panels

Separate booked value from a forecast

The total value of future reservations is not certain room revenue. A simple expected-value exercise can expose assumptions in a calendar with cancellation exposure. It cannot guarantee the arrivals on a particular date or decide room availability or whether to open sales. This article compares room nights and revenue for two entirely fictional groups. Rates and realization percentages are neither industry statistics nor property data or a product method. The purpose is to distinguish recorded bookings from planning expectations and create a discussion of explicit assumptions. Do not transplant the example’s percentages without observations, scope and actual conditions.

Check the applicable conditions first

Airbnb’s home-stay help page distinguishes short and long stays; cancellation timing and exceptions can affect the outcome. A separate guest guide explains where conditions appear before booking and in confirmed reservation details. These sources establish no universal hotel refund policy or standard cancellation percentage. The practical check is to verify the reservation’s own conditions instead of inferring them from a generic label. Retained cancellation revenue, resale and different contracts are separate inputs. No customer reservations were accessed. The example assumes zero revenue after cancellation for simplicity, without describing this as a platform’s policy in every case.

State the fictional inputs

Group A contains 30 room nights at TRY 2,000 per night, with an assumed 80% realization. Group B contains 20 room nights at TRY 2,500, with an assumed 60% realization. Both use the same review period and fixed nightly rates. Room nights are not rooms or booking counts: one room used for three nights contributes three room nights. Taxes, channel costs, retained cancellation amounts and resale are excluded. The result therefore represents neither cash, profit nor recognized revenue. Specify the included components before changing an assumption so that different measures are not mistaken for comparable totals.

Calculate each group separately

A has booked value of 30 × 2,000 = TRY 60,000. Expected room nights are 30 × 0.80 = 24, producing 24 × 2,000 = TRY 48,000. B has booked value of 20 × 2,500 = TRY 50,000; expected nights are 20 × 0.60 = 12 and expected revenue is 12 × 2,500 = TRY 30,000. Combined booked value is TRY 110,000, while the assumed expectation is TRY 78,000 and 36 room nights. The TRY 32,000 difference is not a realized loss. A fractional expected night would describe an average expectation, not an actual fractional room sale.

Test one assumption at a time

If A’s realization changes from 80% to 70%, expected revenue becomes 30 × 0.70 × 2,000 = TRY 42,000. Keeping B unchanged gives TRY 72,000, or TRY 6,000 below the initial expectation. In a separate test, retain A’s original assumption and reduce B from 60% to 50%: B becomes TRY 25,000 and the total TRY 73,000. Do not combine these separate tests as one scenario. Ten percentage points do not create equal monetary changes when group values differ. No evidence establishes these percentages as accurate forecasts; the exercise shows how assumptions affect the calculation.

Avoid double-counting cancellation revenue and resale

A real assessment might include retained cancellation amounts or resale, but the same revenue must not be counted twice. Resale feasibility and price introduce separate uncertainty; no probabilities are assigned here. Demand events may affect several reservations together, so an average expectation does not describe the distribution or worst outcome. If developing assumptions from history, compare similar dates, conditions and data scope, and preserve uncertainty for small samples. Do not claim forecast accuracy without actual comparison. This general teaching calculation explains no product’s internal decisions and cannot justify selling beyond available inventory.

Bring four questions to the review

Which period, how many room nights, which realization assumption and which revenue scope? Answer these before treating a large booking total as a successful result. Once outcomes arrive, compare assumptions and realized nights consistently, distinguishing cancellation, price changes and scope errors. This is a forecast review proposal, not automatic revenue uplift. Do not replace cash tracking or room-readiness checks with the indicator. In a reporting or software demonstration, ask how booked value and planning expectations are separated and request a reproducible group example. Evaluate the assumptions before accepting an impressive total as certainty.

Let's put this to work for you

Let's start with a free, personalized demo.

Book a FREE demo
Book a FREE demoApply for free