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.