- Enter total rooms and average occupied rooms per day.
- Choose the days in your reporting period.
- Input ADR, then add discount and tax percentages.
- Add any other revenue streams for the same period.
- Include fixed and variable costs to estimate NOI.
- Press Submit to see results above this form.
- Use Download CSV or PDF for sharing and archives.
| Scenario | Total Rooms | Occupied | Days | ADR | Other Revenue | Discount% | Tax% | Net Room Revenue | Total Revenue |
|---|---|---|---|---|---|---|---|---|---|
| Example | 120 | 78 | 30 | 105 | 22000 | 5 | 10 | 233,415.00 | 280,956.50 |
Demand and room inventory drivers
Occupancy rate links demand to available inventory. For a given period, room-nights available equal total rooms multiplied by days. Room-nights sold equal average occupied rooms multiplied by days. Small changes in occupied rooms can materially shift revenue when the period is long or the property is large. If occupied rooms approach total rooms, revenue growth must come from higher ADR or stronger ancillary income rather than volume.
Building room revenue from ADR
Room revenue begins with ADR applied to sold room-nights. The calculator separates gross room revenue from net room revenue by applying a discount percentage. This mirrors common practices for corporate deals, promotional codes, and channel-based pricing where the realized rate differs from the published rate. Because the discount is applied before other revenue, you can isolate how rate concessions influence room-only performance.
Taxes, fees, and revenue layering
Many properties add taxes or service charges on top of the subtotal. The calculator applies a tax percentage to subtotal revenue, producing total revenue inclusive of tax. Use this view for cash-flow forecasting and front-desk collection estimates, but use subtotal revenue for operational comparisons across jurisdictions. If other revenue is volatile, test conservative and upside cases to understand sensitivity.
RevPAR and total RevPAR interpretation
RevPAR divides net room revenue by available room-nights, combining occupancy and pricing into one benchmark. Total RevPAR extends the view by adding other revenue such as food, parking, or meeting space. When ancillary income is significant, total RevPAR can better represent overall monetization of the asset. Compare both metrics to see whether performance is driven by the rooms engine or by non-room spend per guest-night.
Costs, NOI, and margin discipline
Profitability depends on cost behavior. Fixed costs stay relatively stable across occupancy swings, while variable costs scale with sold room-nights. The calculator estimates NOI as subtotal revenue minus fixed and variable costs, then reports NOI margin. Tracking margin helps identify when discounting increases volume but erodes profitability. You can also back into break-even occupancy by iterating inputs until NOI approaches zero for the chosen period. Document assumptions for auditability always.
What period should I use for inputs?
Match your reporting cycle. Monthly and weekly are common, but any period works if occupied rooms, ADR, other revenue, and costs reflect the same days.
Why does RevPAR use net room revenue?
RevPAR is most comparable when it reflects actual realized room revenue after discounts. This helps benchmark pricing and demand without ancillary revenue masking room performance.
Should taxes be included in performance comparisons?
Use subtotal revenue for cross-market comparisons because tax rules vary. Use total revenue with tax when forecasting cash collections and reconciliation.
How do I estimate occupied rooms if occupancy changes daily?
Use the average occupied rooms per day for the period. If volatility is high, run multiple scenarios and compare outcomes to build a range.
What counts as other revenue?
Include non-room income earned during the same period, such as food and beverage, parking, resort fees, meeting rentals, or spa and retail sales.
How can I find a break-even occupancy?
Iterate occupied rooms, ADR, and costs until NOI is near zero. The resulting occupancy rate is a practical break-even point for that period.