Hotel Income Calculator

Measure revenue, costs, and operating profit quickly. Improve pricing using occupancy and rate insights daily. See clearer lodging earnings for smarter planning and control.

Enter Hotel Operating Assumptions

The calculator uses a responsive grid: three columns on large screens, two on medium screens, and one on mobile.

Examples: $, €, £, Rs.
Total sellable rooms in inventory.
Commonly 30, 31, 90, or 365.
Expected occupied percentage of available rooms.
Average room selling price per occupied night.
Parking, breakfast, spa, or service revenue.
Housekeeping, linen, toiletries, and room servicing.
Front desk, housekeeping, management, and support staff.
Power, water, internet, gas, and waste services.
Repairs, upkeep, and preventive maintenance.
Ads, promotions, and direct booking campaigns.
Commission applied to room revenue.
Fee applied to total revenue.
Reset

Example Data Table

Example Metric Sample Value
Total rooms80
Days in period30
Occupancy rate72%
Average daily rate$145.00
Ancillary revenue per occupied room$28.00
Variable cost per occupied room$24.00
Payroll cost$38,000.00
Utilities cost$7,800.00
Maintenance cost$4,500.00
Marketing cost$5,500.00
OTA commission rate14%
Management fee rate3%
Use this sample set to test the calculator quickly.

Formula Used

1) Available Room Nights

Available Room Nights = Total Rooms × Days in Period

2) Occupied Room Nights

Occupied Room Nights = Available Room Nights × Occupancy Rate

3) Room Revenue

Room Revenue = Occupied Room Nights × ADR

4) Ancillary Revenue

Ancillary Revenue = Occupied Room Nights × Ancillary Revenue per Occupied Room

5) Gross Revenue

Gross Revenue = Room Revenue + Ancillary Revenue

6) Variable Operating Cost

Variable Operating Cost = Occupied Room Nights × Variable Cost per Occupied Room

7) OTA Distribution Cost

OTA Distribution Cost = Room Revenue × OTA Commission Rate

8) Management Fee

Management Fee = Gross Revenue × Management Fee Rate

9) Gross Operating Profit

Gross Operating Profit = Gross Revenue − Variable Operating Cost − OTA Distribution Cost − Fixed Operating Costs

10) Net Operating Income

Net Operating Income = Gross Revenue − Variable Operating Cost − OTA Distribution Cost − Management Fee − Fixed Operating Costs

11) RevPAR, TRevPAR, and GOPPAR

RevPAR = Room Revenue ÷ Available Room Nights

TRevPAR = Gross Revenue ÷ Available Room Nights

GOPPAR = Gross Operating Profit ÷ Available Room Nights

12) Break-even Occupancy

Contribution per Occupied Room Night = (ADR + Ancillary Revenue per Occupied Room) − Variable Cost per Occupied Room − OTA Cost per Occupied Room − Management Fee per Occupied Room

Break-even Occupancy = Fixed Operating Costs ÷ Contribution per Occupied Room Night ÷ Available Room Nights

How to Use This Calculator

Step 1: Enter the currency symbol you use in your reports.

Step 2: Add room inventory and the number of days for the period you want to evaluate.

Step 3: Input expected occupancy and ADR based on your forecast or recent performance.

Step 4: Add ancillary revenue per occupied room to reflect food, parking, spa, laundry, or service sales.

Step 5: Enter variable cost per occupied room and your fixed operating costs for payroll, utilities, maintenance, and marketing.

Step 6: Include OTA commission and management fee percentages for a more realistic operating view.

Step 7: Click Calculate Hotel Income to show results above the form.

Step 8: Review gross revenue, NOI, RevPAR, break-even occupancy, and margin trends. Export the results using the CSV or PDF buttons when needed.

FAQs

1) What does this hotel income calculator measure?

It estimates room revenue, ancillary income, operating costs, gross operating profit, net operating income, margin, and break-even occupancy for a chosen time period.

2) What is ADR in hotel analysis?

ADR means Average Daily Rate. It shows the average room price earned for occupied rooms during the selected period.

3) Why is ancillary revenue included?

Hotels often earn meaningful income from breakfast, parking, spa services, resort fees, meeting rooms, and other guest purchases. Including it gives a fuller income picture.

4) What is the difference between RevPAR and TRevPAR?

RevPAR uses room revenue only. TRevPAR uses total revenue, including ancillary sales, and gives a broader view of asset productivity.

5) Why does the calculator show break-even occupancy?

Break-even occupancy helps you see the minimum occupancy required to cover fixed costs after variable, commission, and management costs are considered.

6) Can I use this for monthly and yearly forecasting?

Yes. Change the days in period to match a month, quarter, or year, then enter assumptions that fit that horizon.

7) Should fixed costs include debt service or taxes?

This version focuses on operating income. You can add those items into fixed costs if you want a more conservative cash-oriented view.

8) When should I export the results?

Export after testing a scenario you want to share, compare, archive, or present during budgeting, pricing reviews, or investor discussions.

Related Calculators

hotel roi calculatorhotel profitability calculatorroom pricing calculatorrevenue management calculator

Important Note: All the Calculators listed in this site are for educational purpose only and we do not guarentee the accuracy of results. Please do consult with other sources as well.