show work for answers that arent gray blanks. Round percentages to nearest tenth. Round decimals to nearest hundredth

6. Jaden Iman is completing the year-end comparative balance sheet for the Coolidge Hotel. The format of the balance sheet is designed to compare the current year to the prior year and indudes the amount of dollar and percentage change experienced by the operation. Much of the information for the balance sheet has been entered by Jaden but some is missing Coolidge Hotel Balance Sheet Current Year ($) Prior Year (S) $ Change XChange ASSETS Current Assets Cash Cash in House Banks Cash In Demand Deposits Total Cash 34,500 (0) 4,500 15.0% 430,000 484,750 (b) 250,000 150,000 100,000 66.7% Short-Term Investments Receivables 1d Accounts Receivable Notes Receivable Total Receivables Less: Allowance for Doubtful Accounts Net Recelvables 150,000 465,000 31,500 285,550 250,000 535,550 28,555 506,995 29,450 (100,000) (70,550) 2,945 (73,495) 10.3% -40.0% -13.2% 10.3% -14.5% (d) Due from Management Company 15,000 20,000 (5,000) -25.0% 2.750 3.9% (4,030) -9.5% 00 Food Inventories Beverage Inventories Gift Shop Inventories Supplies Inventories Prepaid Expenses Deferred Income Taxes - Current 72,500 38,520 6,255 12,150 156,000 48,000 69,750 42,550 6,950 tel 11,825 120,100 35,000 325 2.7% 35,900 13,000 29.9% 37.1% Total Current Assets 93,505 Investments 272,500 274,150 (1,650) -0.6% 0.0% Property and Equipment Land Building Leaseholds and Leasehold improvements Furnishings and Equipment 0.0% 3,000,000 18,500,000 4,037,000 3,288,000 3,000,000 18,500,000 3,850,000 3,105,000 4.9% 187,000 183,000 5.9N 8 58% + 28,825,000 370,000 Total Property and Equipment Less: Accumulated Depreciation and Amortization Net Property and Equipment 28,455,000 2,975.000 25.480,000 1 3N 20.2% -0.9% 25,250,000 (230,000) 0.0% 13.8% Other Assets Intangible Assets Defered Income Taxes - Non-current Operating Equipment Restricted Cash Total Other Assets 100,000 66,000 110,000 95,000 371,000 100,000 58,000 65,000 95,000 318,000 8,000 45,000 69.2K 0.0% 16.7% 53,000 TOTAL ASSETS LIABILITIES and OWNERS' EQUITY Current Liabilities Notes Payable Banks 17,500 8,000 Others Total Notes Payable 16,250 7,500 23,750 1,250 500 1,750 7.7% 6.7% 7.4% 25,500 0 01 Accounts Payable Accrued Expenses Advance Deposits Income Taxes Payable Deferred Income Taxes. Current Current Maturities of Long-Term Debt Other Total Current Liabilities 45,000 45,500 85,000 40,000 420,000 50,000 881,175 42,500 42,250 78,000 35,000 695,000 58,000 1,095,250 2,500 3,250 7,000 5,000 (275,000) (8,000) (214,075) 5.9% 7.7% 9.0% 14.3% -39.6% -13.8% - 19.5% Long-term Debt, Net of Current Maturities Mortgage Note Obligations Under Capital Leases Total Long-term Liabilities 16,850,000 490,000 17,340,000 385,000 18,385,000 105,000 (1,045,000) -6.4% 27.3% -5.7% Owners' Equity Common Stock Pald in Capital Retained Earnings Total Owners' Equity 1,000,000 5,250,000 0.0% 0.0% 1,000,000 5,250,000 1,765,070 8,015,070 9,189,000 1,173,930 14.6% 9 58% + Name: TOTAL LIABILITIES AND OWNERS' EQUITY Insert the missing information in the balance sheet above (Fill in the gray blanks, 10 points and answer the following questions (2 points each (A) What was the amount of money in the operation's cash in house banks account in the prior year? (b) What was the amount of increase in the operation's total cash account in the current year compared to the prior year? c) What is the amount of the operation's current year accounts receivables? (d) What is the amount of the operation's current year net receivables? te) What was the dollar amount of change in gift shop inventories from the prior year to the current year? thWhat was the percentage amount of change in gift shop inventories from the prior year to the current year? le) What was the amount the operation recorded for depreciation and amortization in the current year? (h) What was the dollar amount of the of the operation's mortgage note that was paid off in the current year? is the operation's accounts payable account balance higher or lower at the end of the current year than it was at the end of the prior year? By how much in dollar and percentage? 10