You are an investment banker planning to invest in Hotel Business. You are given the following details
Question:
You are an investment banker planning to invest in Hotel Business. You are given the following details regarding 5 hotels you are to calculate all the missing links and analyze the RevPAR penetration of the hotels. On the basis of RevPAR penetration which hotel would you choose to invest in and support your decision with facts?
HOTEL | ROOMS | IN JULY | CAPACITY MARKET SHARE | OCCUPANCY | ROOMS SOLD | ROOMS REVENUE | ADR | RevPAR | RevPAR Penetration |
DISNEY | 170 | 5270 | 3000 | 434,000 | 144.67$ | 118% | |||
PIXAR | 245 | 74% | 5590 | 644,000 | |||||
MARVEL | 435 | 20% | 61% | 8200 | 899,000 | 66.67$ | |||
STAR | 550 | 17050 | 13700 | 1,123,200 | 81.98$ | ||||
GEO | 790 | 36% | 82% | 20120 | 1,625,750 | ||||
TOTAL | 2190 | 67890 | 74.5% | 4,725,950$ | 93.38$ | 69.6$ | 100% |
1. Find the total rooms sold in July for all the Hotels?
2. Capacity Market Share of All the Hotels?
3. Calculate the missing Occupancy %?
4. ADR of missing Hotels and the total ADR?
5. RevPAR of missing Hotels and the RevPAR penetration of the hotels?
Submit the assignment as a word or Excel attachment.
International Financial Management
ISBN: 978-0078034657
6th Edition
Authors: Cheol S. Eun, Bruce G.Resnick