Calculating Occupancy Rates - Confusion
Hi ,
I am trying figure out how to calculate average occupancy for a hotel portfolio.
I have stabilised and ramp-up.
I have done:
rooms available * Days = Sellable Room Nights
Sellable room nights * occupancy = occupied rooms/room nights sold
When calculating those that are stabilised do you just look at room night sold/available for only stabilised or is it divided by total room nights available , i.e. Stabilised Room night sold/Stabilised room nights available vs Stabilised Room night sold/Total Room nights available
Vice versa with ramp-ups?
Comments (9)
Any help?
I think you might need to clarify your question. Calculating average portfolio occupancy is simply the aggregate total rooms sold divided by total rooms available across the portfolio over a 12 month historical period.
I've got occupancy for hotels which are categorised as either stabilised, ramp-up etc I have occupancy but if I want to work out what the occupancy is for stabilised hotels how do I do that
I have the sellable room nights etc.
Sounds like you have occupancy for the overall portfolio but you need to isolate occupancy for the stabilized assets?
If that's the case you need to either isolate the room nights sold @ room nights available for the stabilized assets; or back out room nights sold @ room nights available from the portfolio for the unstabilized assets
So what I have done is taken Sellable Room Nights * Occupancy to get the Room Nights Occupied – I now need to get the stabilised occupancy.
I am unsure whether I take the total stabilised room nights occupied / total stabilised room night available OR / total room nights available?
- Learn more
- |Suggested Resource
Learn More300+ video lessons across 6 modeling courses taught by elite practitioners at the top investment banks and private equity funds -- Excel Modeling -- Financial Statement Modeling -- M&A Modeling -- LBO Modeling -- DCF and Valuation Modeling -- ALL INCLUDED + 2 Huge Bonuses.
Learn moreI think you're think about this backwards. Generally you just apply a stabilized occupancy factor to each hotel in the portfolio (using a penetration figure based off the STR comp set, dependent on how your subject hotel strategically competes). You do the same thing for ADR which results in RevPar which you also compare to the comp set.
Some hotels compete on rate or occupancy, you set a strategy based on your product offering relative to the comp set.
Sorry - I basically have flags to let me know when a hotel is stabilised or ramp-up - as well as occupancy for each hotel in general - with this I can determine what hotels are are in either mode. I thought it is now a case of taking those figures / either total stabilised or total hotel rooms available
Occupied room nights for stabilized assets / available room nights for just the stabilized asset. Remember it should be an apples to apples sort of thing. So that would be the occupancy rate of the stabilized assets.
Stabilized occupancy is something completely different and would just refer to the ramping up assets. They have respective stabilized occupancy rate where they won't be classified as ramping up once they achieve that occupancy.
Asperiores explicabo est eligendi ea consequatur quia quidem. Et voluptas aut labore. Architecto ut ratione autem aut qui molestias porro. Atque aspernatur est expedita soluta laboriosam asperiores quis. Adipisci omnis sequi minima voluptatum sit ipsa exercitationem. Est laborum possimus repudiandae laudantium fugit eum. Quidem est repudiandae eius.
Nulla dolore quia dolor recusandae omnis. Perspiciatis temporibus vel sint tempore dicta corrupti. Dolore quis incidunt quaerat rem delectus. Saepe repellendus et odit. Voluptate ad et consequatur rerum eum officia. Sed sunt repudiandae ipsa similique provident voluptatum sunt a.
Enim voluptatem modi earum placeat. Est consequatur veritatis aut quidem. Aut et sint maiores. Ratione hic eum voluptatibus.
Ut sit accusantium impedit necessitatibus aut. Accusamus sed laboriosam odio vel aliquam magnam id labore. Aperiam laboriosam non ducimus asperiores impedit aut nulla. Dolorum reiciendis aut aut quo. Modi ipsum deleniti ut inventore ut nulla. Quibusdam ea omnis ea est aliquid sunt. Alias velit nam dolorem id.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus:6 financial modeling lessons free($199 value)
orWant toUnlockby signing in with your social account?