Q Search Sheet Home Insert Draw Page Layout Formulas Data 12 Calibri (Body) Insert Exercise Basic Formulas blank(1) Review View Custom Conditional Formatting Format as Table $ % ) 000 Cell Styles A- A 2+ Share AQ Sort & Find & Filter Select = X Delete Paste BIU $ 4.0 .00 . O Format D24 XV fx B F G H 4 D E Tremore TOTU Key RM Calculations AQUARIUS HOTEL FORMULAS 1600 260 120 at the F. O. 500 $185 $ 13 70% of revenue 11 $60 65 90% of revenue 100,000,000 Revenue: Profit: ROI: ADR: Occ%: Revpar: 5 6 7 FACTS 8 Number of rooms 9 Number of employees 10 Number of rooms sold daily 11 ADR 12 Rooms 000-Out of order 13 Overall room expenses 14 Number of restaurants 15 Restauant awerage check 16 Number of daily covers sold 17 Overall restaurant expenses 18 Initial owner Investment 19 20 Please indicate for Q2 (91 days) 21 Occ% 22 Room revenue 23 Revpar 24 Room Profit 25 Number of covers sold 26 Restaurant revenue 27 Restaurant Profit 28 Overall Hotel Profit 29 30 31 Number of units sold x unit price Revenue - expenses Return /original investment Total room revenue/total rooms sold Total number rooms sold total rooms available for sale x 100 Total room revenue/total available rooms for sale Sheet1 + Ready 13 . + 90%