answers all of the questions

QRB501 r11 Week 6 Balance Sheets, and Income Statement (1) Excel insert Page Layout Formulas Review View Add-ins Help Data Tell me what you want to do Part A- Chapter 21 in your texthook contains examples that will be helpful for completing the exercises below Using Excel formulas, prepare a vertical analysis for 2017 for the balance sheet below (only use 2017) Using Excel formulas, prepare a horizontal analysis for the balance sheet below (use 2016 &2017- also note the order of the columns below) . Compute the following ratios and show the answer to two digits past the decimal: 0) the current ratio, (iij the acid-test ratio. Use Excel form he cells indicated below in yellow for calculating your ratios. Formulas for this exercise are located on page 779 in your textbook or on the Tab ab in this Excel file. Current ratio: 9.31 9.05 Acid-test ratio: 2.02 1.49 Using Table 21-1, how would you interpret the current ratio result you computed above? Using Table 21-1, how would you interpret the acid-test ratio result you computed above? Balance Sheet December 31, 2016 and 2017 2017 2016 Assets Current Assets Cash Accounts receivable $5,275 7,305 45,522 58,102 $4,507 5,118 48,722 58,347 + Merchandise inventory Total current assets Plant and equipment Equipment Total assets 20,173 78,275 25,942 84,289 Liabilities Current liabilities Accounts payable Wages payable Total current liabilities Long-term liabilities Mortgage note payable Total liabilities 3,809 2,432 6,241 4,476 1,973 6,449 36,454 42,695 45,899 52,348 Owner's Equity A. Green, capital Total liabilities and owner's equity 35,580 78,275 31,941 84,289