Calculator Inputs
Example Data Table
| Input / Output | Sample Value |
|---|---|
| Number of rooms | 120 |
| Analysis days | 30 |
| Occupancy rate | 72% |
| ADR | $95.00 |
| Total revenue | $371,740.00 |
| Total variable cost | $102,556.80 |
| GOP | $119,783.20 |
| Net operating profit | $104,283.20 |
| RevPAR | $68.40 |
| Break-even occupancy | 44.11% |
Formula Used
Available Room Nights = Number of Rooms × Analysis Days
Sold Room Nights = Available Room Nights × Occupancy Rate
Room Revenue = Sold Room Nights × ADR
Total Revenue = Room + Food + Beverage + Events + Spa + Other Revenue
Total Variable Cost = Room Servicing Cost + OTA Commission + Departmental Cost Percentages
Departmental Profit = Total Revenue − Total Variable Cost
GOP = Departmental Profit − Operating Expenses
Net Operating Profit = GOP − Finance Cost − Depreciation
RevPAR = Room Revenue ÷ Available Room Nights
TRevPAR = Total Revenue ÷ Available Room Nights
Contribution per Sold Room = (Total Revenue − Total Variable Cost) ÷ Sold Room Nights
Break-even Occupancy = Break-even Sold Room Nights ÷ Available Room Nights × 100
How to Use This Calculator
1. Enter the currency symbol, number of rooms, and analysis period.
2. Add expected occupancy, ADR, room servicing cost, and OTA commission.
3. Fill in each non-room revenue stream and its matching cost percentage.
4. Add payroll, utilities, maintenance, marketing, administration, insurance, tax, and other fixed expenses.
5. Include finance cost and depreciation for a fuller profit view.
6. Press Calculate Profitability to show results below the header and above the form.
7. Use the export buttons to save the calculated summary as CSV or PDF.
FAQs
1. What does this hotel profitability calculator measure?
It estimates room revenue, total revenue, variable costs, operating expenses, GOP, net operating profit, RevPAR, TRevPAR, and break-even occupancy for the selected period.
2. Why is ADR important here?
ADR drives room revenue directly. Even small ADR changes can strongly affect RevPAR, GOP, and net operating profit when occupancy and fixed costs stay similar.
3. What is included in total variable cost?
Variable costs include room servicing cost, OTA commissions, and the cost percentages applied to food, beverage, events, spa, and other revenue streams.
4. What does GOP mean?
GOP means gross operating profit. It shows how much profit remains after variable costs and core operating expenses, before finance cost and depreciation.
5. How is break-even occupancy estimated?
The calculator divides total fixed-style expenses by contribution per sold room, then compares required sold room nights against available room nights.
6. Can I use this for resorts or boutique hotels?
Yes. The model works for hotels, resorts, serviced apartments, and boutique properties, as long as you enter realistic revenue streams and cost assumptions.
7. Why might net profit be negative?
Negative net profit usually means pricing is weak, occupancy is low, variable costs are high, or fixed expenses exceed the property’s contribution margin.
8. What should I improve first for better profitability?
Start by reviewing ADR, occupancy mix, channel commissions, room servicing cost, payroll efficiency, and the margins of food, beverage, and event departments.