Build the income statement on the spreadsheet. Implement MS Excel functions in the relevant cells. Perform vertical analysis on the second column. HFT4464 Fall2022 Building Income Statement in MS Excel.xlsx ACT MTD 5,859 ROOMS AVAILABLE 5,435 ROOMS OCCUPIED 92.8% ROOMS OCCUPIED % $107.35 $99.58 AVERAGE RATE REVPAR 165,529 24.4% TOTAL PAYROLL AND BURDEN 18,033 31.6% FOOD COST 2,196 20.4% BEVERAGE COST REVENUES 583,421 86.0% n ROOMS 57,090 8.4% FOOD 10,761 1.6% BEVERAGE 1,032 0.2% TELEPHONE 25,821 3.8% MISCELLANEOUS 678,125 100.0% TOTAL REVENUES 438,654 75.2% DEPARTMENTAL PROFIT ROOMS 10,420 18.3% FOOD 6,861 63.8% BEVERAGE -124 -12.0% TELEPHONE 13,893 53.8% MISCELLANEOUS 469,702 69.3% GROSS OPERATING INCOME 52,014 7.7% DEDUCTIONS FROM INCOME A & G 20,310 3.0% 31,941 4.7% 54,782 8.1% 31,915 4.7% HEAT, LIGHT & POWER 22,736 3.4% MANAGEMENT FEES SALES & MARKETING FRANCHISE FEES PROPERTY OPERATIONS 213,699 31.5% TOTAL DEDUCTIONS 256,003 37.8% GROSS OPERATING PROFIT 36,020 5.3% TAXES & INSURANCE 219,983 32.4% OPERATING PROFIT CAPITAL EXPENSES 947 0.1% LEASE EXPENSE 102,868 15.2% INTEREST 21,081 3.1% PRINCIPAL 25,022 3.7% FF&E RESERVES 0 0.0% CAPITAL DISTRIBUTIONS 2,379 0.4% OTHER CAPITAL 152,297 22.5% TOTAL CAPITAL 67,687 10.0% HOTEL EARNINGS 1 ACT MTD 23 5,859 ROOMS AVAILABLE 3 5,435 ROOMS OCCUPIED 4 92.76% OCCUPANCY% 5 $107.35 ADR 6 REVPAR 7 $99.58 $165,529 00 8 TOTAL PAYROLL AND BURDEN 9 10 $18,033 31.6% FOOD COST 11 $2,196 BEVERAGE COST 12 13 REVENUES 14 $583,421 ROOMS 15 $57,090 FOOD 16 $10,761 17 $1,032 18 $25,821 BEVERAGE TELEPHONE MISCELLANEOUS 19 20 $678,125 TOTAL REVENUES 21 22 23 $438,654 DEPARTMENTAL PROFIT ROOMS 22 24 $10,420 FOOD 25 $6,861 22 26 27 22 28 29 30 31 -$124 $13,893 $469,704 BEVERAGE TELEPHONE MISCELLANEOUS GROSS OPERATING INCOME DEDUCTIONS FROM INCOME 23 32 33 33 A & G 57090 10761