The following information has been gathered to assist you in deciding whether to invest in Socks & Gizmo Limited.
Additional information:
Dividends declared & paid in 2021 $50,000
Number of shares outstanding at October 31, 2021 10,000
Market price per share at October 31, 2021 $ 20.00
Selected Data from the October 31, 2020 financial statements:
Accounts receivable, net 31,500
Inventory 44,000
Total assets 328,500
Accounts payable 32,600
Total shareholders equity 167,200
Required: SHOW ALL THE WORK IN DETAIL
1. Calculate 12 ratios for the year ended October 31, 2021 for Socks & Gizmo Limited using the ratio sheet provided in Moodle. You may calculate any 12 you wish.
2. Discuss 4 ratios calculated in part 1.
3. Based on the ratios you discussed in Part 2 would you be willing to invest in Socks & Gizmo Limited? Why or why not?
Ratio Sheet:
The following information has been gathered to assist you in deciding whether to invest in Socks & Gizmo Limited. Socks & Gizmo Limited Income Statement Year Ended October 31, 2021 2021 $ Sales Cost of goods sold 750,000 300,000 450,000 Selling & Admin Depreciation expense Advertising Office expenses Utilities expense Salary expense Insurance expense 10,000 20,000 24,000 30,000 275,000 6,000 Interest expense Income before income taxes Income tax expense Net income 365,000 85,000 5,000 80,000 12,000 68,000 $ Socks & Gizmo Limited Balance Sheet October 31, 2021 $ ASSETS Current Assets Cash Accounts receivable Allowance for doubtful accounts Inventory Prepaid expenses 52,000 6,000 LIABILITIES AND SHAREHOLDERS' EQUITY Current Liabilities 18,000 Accounts payable $ 39,000 Salary payable 4,800 46,000 Income taxes payable 12,000 50,000 55,800 2,000 116,000 Note payable 100,000 Total Liabilities 155,800 225,000 Shareholders'Equity 341,000 Common shares 20,000 Retained earnings 165,200 Total shareholders' equity 185,200 Property, plant & equipment Accumulated depreciation - PPE 275,000 50,000 $ TOTAL LI ABILITIES & SHAREHOLDERS' EQUITY $ 341,000 Additional information: Dividends declared & paid in 2021 Number of shares outstanding at October 31, 2021 Market price per share at October 31, 2021 $50,000 10,000 $ 20.00 Selected Data from the October 31, 2020 financial statements: Accounts receivable, net 31,500 Inventory 44,000 Total assets 328,500 Accounts payable 32,600 Total shareholder's equity 167,200 Socks & Gizmo Limited Industry averages -2021 2020 62.00% 55.00% 9% 10.00% 24% 26% 0.45 0.4 Gross profit margin ratio Return on sales (net profit margin) Return on total assets Debt ratio Current ratio Asset turnover Quick Ratio Earnings per share Dividend Yield N 1.5 2.1 2 2 2 1 1.1 10 5 0.3 0.2 Required: 1. Calculate 12 ratios for the year ended October 31, 2021 for Socks & Gizmo Limited using the ratio sheet provided in Moodle. You may calculate any 12 you wish. 2. Discuss 4 ratios calculated in part 1. 3. Based on the ratios you discussed in Part 2 would you be willing to invest in Socks & Gizmo Limited? Why or why not? 11. Gross profit margin ratio 2. Operating profit ratio 3. Return on sales (Net profit margin ratio) 4. Sales to Total assets ratio (Asset turnover ratio) 5. Return on total assets ratio Gross profit Net sales Income from operations Net sales Net income Net sales Net sales Average total assets Income from operations Average total assets Net income Average shareholders' equity Average accounts receivable Net credit sales Average merchandise inventory Cost of goods sold * 365 6. Return on equity ratio 7. Accounts receivable collection period 8. Number of days sales in inventory 9. Days to complete revenue operating cycle * 365 Days sales in inventory + accounts receivable collection period 10. Current ratio 11. Quick ratio (Acid Test ratio) 12. Working capital Current assets Current liabilities Cash + short-term investments + current receivables Current liabilities Current assets - Current liabilities 13. Debt ratio 14. Equity ratio 15. Debt to equity ratio 16. Times interest earned Total liabilities Total assets Total Equity Total assets Total liabilities Total equity Income from operations Interest expense Net income - preferred share dividends Number of common shares outstanding Market price per share Earnings per share Dividend per share Market price per share 17. Earnings per share 18. Price-earnings ratio 19. Dividend Yield
