show work for the part of question that is not fill in the gray blank. round percentages to nearest tenth. round decimals to nearest hundredth

5. Having completed the vertical analysis of her balance sheet (from Question 4), Rachel now wants to complete a horizontal analysis of her balance sheet comparing last year to this year Rachel's Restaurant Balance Sheet December 31 Last Year Versus This Year Last Year This Year $ Change % Change ASSETS Current Assets Cash 57,317 Marketable Securities 63,049 104,615 64,000 130,769 Net Receivables 80,000 Inventories 48,363 34,545 Total Current Assets Investments 323,488 248,837 Property and Equipment Land 206,053 206,053 Building 418,665 418,665 Furnishings and Equipment 267,223 205,556 142,710 135,429 Less Accumulated Depreciation Net Property and Equipment Other Assets 12.651 15,814 TOTAL ASSETS LIABILITIES AND OWNERS' EQUITY Current Liabilities Accounts Payable 253,354 142,439 Notes Payable 38,286 31,905 Other Current Liabilities 192,279 147 907 Total Current Liabilities 58% + Long-Term Liabilities 102.560 218,272 Long-Term Debt Total Liabilities Owners' Equity 102,631 78,947 Common Stock 421,621 324,324 Paid in Capital 254,666 318, 333 Retained Earnings Total Owners' Equity TOTAL LIABILITIES AND OWNERS' EQUITY (1) Help Rachel complete her horizontal analysis by filling in the gray blanks in the balance sheet above. (10 points) (2) Rachel wanted to try to decrease her accounts receivable this year. Did she do this? (2 points) (3) Rachel wanted to try to reduce her inventories this year to be more in line with the chain's average inventories. Did she do this? (2 points) (4) Rachel wanted to reduce her accounts payable this year. Did she do this? (2 points) (5) Rachel wanted to pay off more of her total current liabilities this year. Did she do this? (2 points) (6) Based on the changes reported in her balance sheet, do you think Rachel's restaurant likely made a profit last year? Why or why not? (2 points) 7