Please note that the excel sheet is a monthly statement. So, the number of rooms available is 900 (30 rooms * 30 days=900)

Hotel X has 30 rooms. Please review its Income Statements for 2021 and 2020 i, and calculate the following indices. 1. What is the GOPPAR of Hotel X for the year of 2021? 2. What is the owthrough for Hotel X forthe period of 20202021? 4 Previous Next b O ZOOM + KZ 30 Room Hotel 2021 2020 Revenue December December Rooms Occupied 6,560.00 8,560.00 $1,268,607.21 Rooms Revenue $1,068,607.21 Food & Berverage $518,303.24 $618,303.24 Other Operated Departments $48,654.76 $53,654.76 Rentals and Other Income $7,546.76 $7,546.76 Total Revenue $1,649,672.00 $1,956,671.97 Expenses Rooms $287,646.54 $327,646.54 Food & Beverage $129,564.90 $129,564.90 Other Operated Departments $56,730.54 $56,730.54 Administrative and General $256,321.21 $256,321.21 Sales and Marketing $156,310.12 $156,310.12 Property Operation and Maintenance $80,654.55 $80,654.55 Utilities $135,654.56 $135,654.56 Management Fees $87,076.86 $87,076.86 Rent, Property Taxes, and Insurance $5,761.21 $5,761.21 Interest Expense $1,982.34 $1,982.34 Depreciation and Amortization $80,462.87 $80,462.87 Loss or (Gain) on the Disposition of Assets $0.00 $0.00 Total Expenses $1,278,166.00 $1,318,166.00 Income Before Income Taxes $371,506.00 $638,505.97 Income Taxes Current $39,000.00 $45,000.00 Deferred $0.00 $0.00 Total Income Taxes $39,000.00 $45,000.00 Net Income $332,506.00 $593,505.97