M&K Design Limited Balance Sheet October 31, 2019 Assets Cash Accounts receivable Inventory $22.000 122,000 96.000 240,000 Furniture and Equipment 700,000 Accumulated depreciation - furniture and equipment (300,000) Long term investment 125.500 525,500 $765,500 Liabilities & Shareholder's Equity Liabilities Accounts payable Salary payable Income tax payable I $158,000 12.000 30,000 200,000 75,000 275.000 Bank loan (long-term) Shareholder's Equity Common shares Retained earnings 50.000 440,500 490,500 $765.500 Selected data from October 31, 2018 financial statements: Total assets $683.500 Accounts receivable $107.500 Inventory $ 60.000 Accounts payable $175.000 Required: A. Calculate 10 ratios (see page 7) to help you analyze M&K Design Limited. Some limited industry averages & comparative ratios are provided on the next page. B. Using at least 4 ratios calculated above to answer the following: M&K Design has come to you looking for a loan of $40,000 to be repaid over 5 years. Would you be willing to loan them the money? Provide an explanation for your answer. The following information is available for: T Gross profit margirtratio Return on sales (net profit margin) Rate of return on assets Debt ratio Current ratio Asset turnover Industry averages - 2019 50.0% 9% .25 .40 1.5 2.1 .75 M&K Design 2018 47.2% 9.5% .24 48 1.0 2.0 .67 Quick Ratio 1. Gross profit margin ratio 2. Return on sales (Net profit margin ratio) 3. Rate of return on assets ratio 4. Asset turnover ratio 5 86. Receivables turnover ratio and days sales outstanding 7 & 8. Inventory turnover ratio and days inventory outstanding Gross profit Net sales Net income Net sales Net income Average total assets Net sales Average total assets Net sales Average accounts receivable and 365 Accounts receivable turnover Cost of goods sold Average inventory and 365 Tnventory turnover ratio Cost of goods sold Average accounts payable and 365 Accounts payable turnover Days inventory outstanding days sales outstanding - days payables outstanding Current assets Current liabilities Cash + short term investments current receivables Current liabilities Total liabilities Total assets Income from operations Interest expense 9 & 10. Payables turnover and days payables outstanding 11. Cash conversion cycle 12. Current ratio 13. Quick ratio 14. Debt ratio 15. Times interest earned