1. Calculate the MKC financial ratios using EXCEL and the template provided in "A". Take all calculations to two decimal places. account trade accounts receivable, net inventories PPE, net total current assets total assets trade accounts pay I-t debt total shareholders equity 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) 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 pmt 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 "A" 1 of 2019 2018 2017 2019 2018 555.1 793.3 809.1 1617 10385.8 639.9 4443.9 2570.9 1947.3 7814.9 plus interest expense)/interest expense) gross profit % ((net sales-CGS)/Net sales) oper profit % (oper. Profit/net sales) net profit % (net income/net 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 paid/net income) "A" 2 2 of 2