City Apart-hotel Financial Model
Description
The model is built for a city-centre apart-hotel blending serviced-apartment living with hotel-style amenities. It covers multiple unit categories — from compact studios to two-bedroom suites — each with its own floor area, furnishing package, and utility consumption profile. The capital investment is typically in the low-to-mid eight-figure range (USD), though this order-of-magnitude indication will adjust once specific location and unit counts are entered.
Operationally, the model differentiates between nightly, weekly, and monthly bookings, each triggering distinct housekeeping schedules, linen change frequencies, and consumable usage rates. Extended-stay demand dynamics are modelled through length-of-stay distribution curves and corresponding rate fences, ensuring that the revenue built-up reflects real-world booking patterns rather than a flat ADR assumption. Departmental staffing is linked to occupancy bands and unit mix, with separate drivers for front desk, housekeeping, and maintenance.
Revenue is split by OTA, direct website, and corporate negotiated channels, each with its own commission rate and growth trajectory. The model also accounts for seasonality, weekday/weekend differentials, and renovation downtime on a rolling basis. Capital structure allows for a construction/refurbishment loan, equity tranches, and FF&E reserve buildup, making it suitable for both greenfield projects and conversions of existing buildings.
Modeling specifics
- Length-of-stay distribution modelling with differentiated rate fences — prevents flat-ADR assumption that misses the revenue discount for monthly stays.
- Unit-type capacity and inter-type cannibalization logic — avoids selling a studio booking in a one-bedroom suite, which would overstate revenue by up to 12%.
- Housekeeping cost by stay type (full clean for short stays, light refresh for extended stays) — capturing the 60–70% lower labour usage per occupied key for monthly guests.
- OTA commission tiering with a ramp-up of direct bookings year-over-year — closing the 8–15% net revenue leakage from ignoring direct channel growth.
- Seasonal and weekday/weekend occupancy curves applied independently to each unit category — because a Tuesday studio and a Saturday two-bedroom suite behave differently.
- FF&E reserve as a percentage of departmental revenue with a mid-cycle refurbishment trigger — reflecting the capital intensity that typical hotel templates ignore.
What's included in the base version
- Revenue model with channel and length-of-stay splits
- Unit-level operational cost model (utilities, consumables, linen, amenities)
- Staffing model linked to occupancy bands and unit mix
- CAPEX and pre-opening expense schedule
- Debt and equity financing with a cash sweep mechanism
- Monthly 15-year integrated financial statements (P&L, cash flow, balance sheet)
- Sensitivity tables for occupancy and average daily rate
- One-page executive dashboard with key KPIs
Common modeling mistakes
- Assuming a single nightly ADR for all bookings — overstates ancillary revenue from short stays and can inflate ADR by 5–12%.
- Ignoring length-of-stay mix — leads to overestimated occupancy by 5–10 percentage points and overstated RevPAR by 12–18%.
- Treating housekeeping as a pure variable cost per occupied room irrespective of stay length — overstates total operational expenses by 10–15% because monthly stays require far less cleaning frequency.
- Omitting OTA commission tiering and direct channel growth — understates net revenue pressure by 8–15% in the first years of operation.
- Building a single occupancy driver without unit-type constraints — creates physically impossible unit allocation, overbooking certain categories by 50%+ during peak demand periods.
