I need help

RHIM 4322 * Homework 2 * Vertical and Horizontal Analyses Please complete and show worlc in an excel spreadsheet following the Demo Exercise. Do transfer the financial data to the spreadsheet. However: no need to show the explanatory notes like what is being provided in the Demo Exercise. Submit the Homework spreadsheet using this lename "RHlM4322Last_Naine-Honieworh 2 \" 1. Conduct a vertical analysis (common-size analysis) for the income statements of Boatman Hotel for the months ended March 31 and April 30, 2016. March April Revenues: Rooms 325,236425,165 Food and Beverage 136.253 126,523 Telecommunications 4,213 5,3 26 Ether Income 46,829 49,654 Total Revenues Cost of Sales: Rooms 136,256 154,932 Food and Beverages 142,516 135,216 Telecommunications 3,453 4,123 Uther Income 35,643 41,213 Total Cost of Sales 311,673 335,539 Gross Prot: Rooms 244,936 226,113 Food and Beverages 43,232 41,3614I Telecommunications 2611 1,2113 other Income 11,231 6,441 Total Gross Prot Operating {Controllable} Expenses: Administration a General 11,665 16,256 Marketing 41,219 44,3 62 Franchise Fees 21 ,665 24,632 Property Operations and Maintenance 32,456 36,612 Utilities 32,156 36,459 Total Operating Expenses 143,441 161,221 Operating Income Other (Non-controllable} Expenses: Management Fee 6,145 6,425 li'ropertyr Taxes 25,613 25,613 Reserve for Capital Improvements 16,321 26,153 Insurance 6,961 6,852 Interest Expense 25,664 26,456 Total Non-controllable Expenses 131384131463 Income Before Income Taxes 2. Conduct a horizontal analysis (comparative analysis) for the balance sheets of Gian's Italian Cuisine as of November 30 and December 31, 2016. November December Current Assets: Cash 9,000 14,000 Accounts Receivable 10,000 11,500 Food Inventory 4,000 3,538 Beverage Inventory 6,000 3.950 Prepaid Rent 18,000 20,000 Total Current Assets Fixed Assets: Furniture, Fixture & Equipment (FF&E) 7,500 9,870 Accumulated Depreciation (FF&E) (3,030) (4,000) Building 20,000 20,000 Long term Investments 5,000 8,580 Long Term Assets 29,470 34,450 Total Assets Current Liabilities: Accounts Payable 7,000 6,790 Accrued Payroll 5,400 6,540 Accrued Taxes 5,500 3,500 Total Current Liabilities Long Term Debt 10,000 12,000 Total Liabilities Owner's Equity 39,000 40,620 Retained Earnings 9.570 17,988 Total Owner's Equity Total Liabilities and Owner's Equity