Using the attached Excel spreadsheet for Wicked Good Cupcakes (WGC) calculate the listed ratios. 1. Copy and paste your ratio calculation as a Table 1, inserted into the Word document. 2. What do these ratios suggest about the companys performance during the period presented? 3. In Table 2 list the 5 ratios from Walmart and corresponding ratios for WGC. 4. Which ratios would a senior operational manager for WGC be most interested in following?

($ Thousands) 31-Dec-15 31 Dec-16 heliaity Ratios ( %) Cash &Short-Tem Irwestments Tmayer ComtrlRatis Asset tver Gross Plant, Property&Equipment Colectionperiod (drys) Net Plant, Property&Equipment Leveragety Raias Long Term Debt Due In One Year Taxes Payable Annual Income Stale nent ($ Thousands, except pershare) Cost of Goods Sold Selling, General, & Administrative Exp. Operating Income Before Deprec Depreciation,Depletion,&Amortization Profrt Total Income Taxes Income Before Extraordinary tems & Discontinued Operations Savings Due to Comon Stock Equiv. Dividends Per Share Com Shares for Basic EPS Com Shares forDilutedEPS ($ Thousands) 31-Dec-15 31 Dec-16 heliaity Ratios ( %) Cash &Short-Tem Irwestments Tmayer ComtrlRatis Asset tver Gross Plant, Property&Equipment Colectionperiod (drys) Net Plant, Property&Equipment Leveragety Raias Long Term Debt Due In One Year Taxes Payable Annual Income Stale nent ($ Thousands, except pershare) Cost of Goods Sold Selling, General, & Administrative Exp. Operating Income Before Deprec Depreciation,Depletion,&Amortization Profrt Total Income Taxes Income Before Extraordinary tems & Discontinued Operations Savings Due to Comon Stock Equiv. Dividends Per Share Com Shares for Basic EPS Com Shares forDilutedEPS