Free tool · hotels and resorts
A hotel cost calculator and profitability model for small hotels, resorts and homestays. Put in your keys, rates, season, running costs and setup budget, and see occupancy, ADR, RevPAR, GOP and month-by-month cash. Every number on the page starts as an example; replace it with your own. Your work saves in this browser. It is a planning aid, not financial advice.
| Year 1 incl. setup | Year 2 first full year |
|---|
| Key type | No. | Rate / night |
|---|---|---|
| Room type A | ||
| Room type B | ||
| Room type C | ||
| Room type D new keys | ||
| Room type E new keys |
The season below sets the shape; the slider above sets the yearly average. The example shape is a coastal leisure market: busy in winter and the summer holidays, quiet in the monsoon. Replace it with your own booking history.
| Month | Season shape, occupancy % | Rate, % of rate card | Beach activities | Used occupancy |
|---|---|---|---|---|
| Jan | ||||
| Feb | ||||
| Mar | ||||
| Apr | ||||
| May | ||||
| Jun | ||||
| Jul | ||||
| Aug | ||||
| Sep | ||||
| Oct | ||||
| Nov | ||||
| Dec |
Example roles and monthly pay. Add or remove roles to fit the property.
| Staff | No. | Pay / month |
|---|---|---|
| Site manager | ||
| Booking manager | ||
| Housekeeping lead | ||
| Housekeeping staff | ||
| Helper / gardener | ||
| Night security |
| Power | Units | kW each | Hours / day |
|---|---|---|---|
| ACs (run on occupied nights) | |||
| Geysers (occupied nights) |
One-time spend. Every cost is an example until you have quotes.
| Item | Phase | Qty | Cost each, Rs | Owner funds |
|---|---|---|---|---|
| New guest units, type D | ||||
| New guest units, type E | ||||
| Septic tank with bio-digester | ||||
| Civil repair and waterproofing (lump sum) | ||||
| Paint, whole property (lump sum) | ||||
| Rewiring, boards, earthing (lump sum) | ||||
| Outdoor lighting: festoons, lanterns, uplights | ||||
| Solar rooftop, per kW | ||||
| Inverter and battery, per kWh (lights, fans, Wi-Fi, CCTV, pumps: no flicker) | ||||
| Silent diesel generator, 25 kVA, with automatic changeover (runs the ACs in power cuts) | ||||
| Room refresh: linen, mattresses, curtains, per key | ||||
| Landscaping and screening | ||||
| Workshop and event pavilion (thatch, timber) | ||||
| Furniture, loungers, hammocks | ||||
| Solar water heater, 500 L |
Phase 1 = amenities that make the rooms sellable (rooms, hot water, power backup, wiring, civil). Phase 2 = the look. Phase 3 = new keys and solar.
Starts at minus the setup budget. Cash after rent = GOP minus rent minus the yearly property works spread by month. The owner's profit share is settled yearly and is not in this table.
| Month | Occupancy | ADR | Revenue | GOP | Rent | Cash after rent and works | Cumulative |
|---|
| Average occupancy | Total revenue | GOP | Profit before split | Operator keeps | Owner gets (cash) |
|---|
Your current inputs save automatically in this browser and come back when you return.
Scenarios stay in this browser only. Clearing your browser data removes them. To use one on another device, export it here and import it there. Your inputs are not sent to Alphamotion.
It turns a few inputs into the numbers a hotel general manager reads every month: occupancy, ADR, RevPAR, room nights sold, total revenue across rooms, F&B, events and other services, and GOP. If you lease the property, it then takes out rent, property works, setup recovery and any profit share, and shows what the operator keeps.
Running costs are set by line: staff by role, power by kWh (ACs and geysers on occupied nights, plus a base load), water, generator diesel during power cuts, maintenance, housekeeping, laundry, internet, marketing, guest amenities and card fees. The setup budget lists one-time costs with quantity, phase and GST, and marks which items the owner funds.
From your keys, room rates and occupancy it works out ADR, RevPAR, room nights, total revenue, GOP and what the operator keeps after rent, property works, setup recovery and any profit share. It also shows month-by-month cash for the first two years.
Yes. The running costs tab takes staff by role, power by kWh, water, maintenance, housekeeping, laundry, internet, marketing and guest amenities. The setup budget tab lists one-time costs with quantities, phases and GST.
Yes. Set an occupancy shape and a rate index for each month. The yearly average slider scales the whole season, and beach activities can be switched off for the monsoon months.
Your inputs save automatically in this browser. You can also save named scenarios, and export a scenario file to open on another device. Your inputs are not sent to Alphamotion.
ADR is the average rate earned per room night sold. RevPAR is room revenue divided by every room night available, sold or not, so it reflects both rate and occupancy.
Events, sundowners and water sports start at zero; type in how many you expect a month to see their effect. Their fees, spends and commission rates are examples. All figures are gross of GST. Occupancy and rates follow the season table. Year 1 has the setup months with no rooms sold and no rent. "Owner gets" counts rent plus the owner's profit share in cash. The works also add value to the owner's property, which is shown on its own line.