please answer step by step using excel formula ( or type out how it comes out, like revenues)

E M D G N 0 P B F H Q Prepare a comparative income statement using the 20x1 and 20x2 information available Rearrange the income statement to show departmental incomes MCU Hotel ANSWER MCU Hotel Income Statements Comparative Income Statements For the years ending December 31, 20x1 and 20x2 For the years ending December 31, 20x1 and 20x2 Change from x1 to x2 Percentage 20x2 Amount 20x1 20x1 20x2 Revenues Rooms 10 Rooms 976,000 1,041,000 Revenues 11 Food and Beverage 604,000 626,000 Direct Expenses Deparmental Income 12 Telephone 50,000 52,000 13 Total 14 Food and Beverage 15 Direct Expenses Revenues 16 Rooms 250,000 264,000 Direct Expenses 17 Food and Beverage 476,000 507,000 Deparmental Income 18 Telephone 68,000 68,000 19 Total Telephone Revenues 20 21 Total Operational Departmental Income Direct Expenses Deparmental Income 22 23 Undistributed Operating Expenses 24 Administrative and General 195,000 206,000 Total Operational Departmental Income 25 Marketing 65,000 68,000 26 Property Operation and Maintenance 69,000 68,000 Undistributed Operating Expenses 27 Energy Costs 101,000 102,000 Administrative and General 28 Total Marketing Property Operation and Maintenance 29 30 Income after Undistributed Operating Expense Energy Costs Total 31 32 Rent, Property Taxes and Insurance 200,000 201,000 33 Interest 55,000 52,000 Income after Undistributed Operating Expenses 34 Depreciation and Amortization 116,000 116,000 35 Income before Income Taxes Rent, Property Taxes and Insurance 36 Income Taxes 7,000 17,000 Interest Depreciation and Amortization 37 38 Net Income Income before Income Taxes 39 Income Taxes 40 41 Net Income