1. Calculate the MKC financial ratios using EXCEL and the template provided in A. Take all calculations to two decimal places. "A" 1 of 2 2019 2018 2017 account 555.1 trade accounts receivable, net 793.3 inventories 809.1 PPE, net total current assets total assets 1617 10385.8 trade accounts pay It debt total shareholders equity 639.9 4443.9 2570.9 1947.3 7814.9 total current liabities total liabilities net sales cost of goods sold operating income income from consolidated ops before income taxes net income interest exp. Cash Flow from Operating Activities (CFOA) dividends paid (from cash flow statement) 2019 2018 working cap (CA-CL) current ratio (CA/CL) quick ratio (QA/CL) inv. Turns (CGS/ave. Inventory) days in inv (365/inventory turnover) accts rec turns (net sales/ave accts. Rec) DSO (365/accts. Receivable turns) accts pay turns (CGS/ave. accts. Payable) ave prt period (365/accts. Payable turnover) fixed asset turns (net sales/ ave. net PPE) total asset turns (net sales/ave, total assets) debt ratio (Total liab/total assets) times interest income from cons ops b4 income taxes "All a 2 of 2 plus interest expense)/interest expense) gross profit % ((net sales-CGS)/Net sales) oper profit % (oper. Profitet sales) net profit % (net incomeet sales) ROA (Net income/ave. total assets) ROE (net income/ave. shareholder equity) fin. Multiplier (Ave. total assets/ave. shareholder equity Cash Flow Yield (CFOA/Net Income) Dividend Payout (dividends paidet income) 1. Calculate the MKC financial ratios using EXCEL and the template provided in A. Take all calculations to two decimal places. "A" 1 of 2 2019 2018 2017 account 555.1 trade accounts receivable, net 793.3 inventories 809.1 PPE, net total current assets total assets 1617 10385.8 trade accounts pay It debt total shareholders equity 639.9 4443.9 2570.9 1947.3 7814.9 total current liabities total liabilities net sales cost of goods sold operating income income from consolidated ops before income taxes net income interest exp. Cash Flow from Operating Activities (CFOA) dividends paid (from cash flow statement) 2019 2018 working cap (CA-CL) current ratio (CA/CL) quick ratio (QA/CL) inv. Turns (CGS/ave. Inventory) days in inv (365/inventory turnover) accts rec turns (net sales/ave accts. Rec) DSO (365/accts. Receivable turns) accts pay turns (CGS/ave. accts. Payable) ave prt period (365/accts. Payable turnover) fixed asset turns (net sales/ ave. net PPE) total asset turns (net sales/ave, total assets) debt ratio (Total liab/total assets) times interest income from cons ops b4 income taxes "All a 2 of 2 plus interest expense)/interest expense) gross profit % ((net sales-CGS)/Net sales) oper profit % (oper. Profitet sales) net profit % (net incomeet sales) ROA (Net income/ave. total assets) ROE (net income/ave. shareholder equity) fin. Multiplier (Ave. total assets/ave. shareholder equity Cash Flow Yield (CFOA/Net Income) Dividend Payout (dividends paidet income)