QUESTION 5 You have been provided the following financial statements for SPI-Windsor Inc. (SPIW): SPI-Windsor Inc. Statement of Earnings (in thousands) Year Ended September 30 2021 2020 2019 Revenues $ 5,198,256 $ 3,956,781 $3,281,791 Costs and Expenses: Cost of Goods Sold $ 2.859,041 $ 2,311,560 $ 1,904,561 Selling and Administrative $ 1,027,412 $ 753,966 $ 698,236 Interest $ 33,794 $ 42,596 $ 29,891 Other expenses (income) $ 3.500 $ 4.890 $ (1,020) Total Costs and Expenses $ 3,923,747 $ 3,113,012 $ 2,631,668 Income before taxes $ 1,274,509 $ 843,769 $ 650,123 Income Taxes $ 382.353 $ 210.942 $ 162,531 Net Income $ 892,156 $ 632.827 $ 487,592 SPI- Windsor Inc. Statement of Financial Position (in thousands) Year Ended September 30 ASSETS 2021 2020 Current Assets Cash and cash equivalents $ 501,695 $ 421,950 Accounts Receivable (note 1) $ 795,500 $ 701,560 Inventories $ 648,000 $ 550,200 Deffered Income Taxes $ 25,125 $ 21,600 Prepaid Expenses $ 63,250 $ 47.980 Total Current Assets $ 2,033,570 $ 1,743,290 Property, Plant, Equipment $ 785,000 $ 715,000 Less Accumulated Depreciation $ 290,450 $393.250 Net PPE $ 494,550 $ 321,750 Goodwill $ 203,500 $ 203,500 Other Assets $ 39,150 $ 33,150 Total Assets $ 2.770.770 $ 2.301.690 LIABILITIES AND SHAREHOLDERS' EQUITY Current Liabilities Current Portion of LT Debt $ 83,169 $ 15,500 Notes Payable $ 185,500 $ 135,600 Accounts Payable $ 189,400 $ 195,005 Accrued Liabilities $ 172,500 $ 164,900 Income Taxes Payable $ 38,500 $ 51.000 Total Current Liabilities $ 669,069 $ 562,005 Long-term Debt $ 24.950 $ 85,125 Noncurrent deffered income tax $ 35,000 $ 31,000 Other non current liabilities $ 61,500 $ 39,400 Redeemable Preferred Shares $ 200 $ 200 Total Liabilities $ 790,719 $ 717,730 Shareholders' Equity Common Shares 1$ 1 Contributed Surplus 25,700 $ 8,954 Retained Earnings $ 1.954.350 $ 1,575,005 Total Shareholders' Equity $ 1.980.051 $ 1,583,960 Goodwill $ 203,500 $ 203,500 Other Assets $ 39.150 $ 33.150 Total Assets $ 2.770.770 $ 2.301.690 LIABILITIES AND SHAREHOLDERS' EQUITY Current Liabilities Current Portion of LT Debt $ 83,169 $ 15,500 Notes Payable $ 185,500 $ 135,600 Accounts Payable $ 189,400 $ 195,005 Accrued Liabilities $ 172,500 $ 164,900 Income Taxes Payable $ 38.500 $ 51.000 Total Current Liabilities $ 669,069 $ 562,005 Long-term Debt $ 24,950 $ 85,125 Noncurrent deffered income tax $ 35,000 $ 31,000 Other non current liabilities $ 61,500 $ 39,400 Redeemable Preferred Shares $ 200 $ 200 Total Liabilities $ 790,719 $ 717,730 Shareholders' Equity Common Shares $ 1$ 1 Contributed Surplus $ 25,700 $ 8,954 Retained Earnings $ 1.954.350 $ 1,575,005 Total Shareholders' Equity $ 1.980.051 $1,583,960 Total Liabilities and Shareholders' Equit $ 2,770,770 $ 2.301,690 SPI-Windsor Inc. Notes to Financial Statements September 30, 2021 1. The account receivables are net an allowance for doubtful accounts where $39,4632 and $28,724. The following two table provides additional information for you to review regarding SPI-Windsor Inc.: 2021 2020 2019 Average number of common shares outstanding 56,001 54.125 54.001 Accounts Receivable 795,500 701,650 605,125 Inventories 648.000 550.200 500,175 Total Assets 2.770.770 2.301.690 2,100.500 Shareholders' Equity 1.980051 1.583.960 1.150,000 Share Repurchases 780.520 485,100 395.100 Cash Flow from operating activities 695.000 580,000 305.000 Common Dividends Paid 71 850 51,500 41 300 Dividends per common share 0.95 0.55 Market Price per ure: High 10125 88.25 6925 Low 65.25 44.25 31.25 Close 99.60 71.25 48.75 *Please note all are amounts above are in thousands except for costs per share information provided OS The following are the industry averages: 2020 Industry Averages 2021 Return on Assets 25.25% 28.75 Gross Profit Margin 39.75% 41.25 Asset Tamover 2.10% 2.45 'Times Interest and 29.84 27.55x Debt-to-Equity 0.44 O.SI You have been recently hired by SPI-Windsor Inc. (SPI) as the assistant to the controller and the Controller has provided you with the following tasks for you to complete as indicated below. You have been recently hired by SPI-Windsor Inc. (SPI) as the assistant to the controller and the Controller has provided you with the following tasks for you to complete as indicated below. Tasks: Iv a) A full analysis using the following ratio's: (20 marks) Current Ratio Operating Cash Flow lil Times Interest Earned Debt-to-Equity Ratio Inventory Tumover Ratio Asset Turnover Ratio Gross Profit Percentage Return on Assets Eamings per share Price/Earnings Ratio VE VII Vild b) Based on the information provided and your analysis do you feel that SPIW is profitable, provide a brief explanation. (4 marks) c) In reviewing the asset efficiency ratios for SPIw, what could be said in general and compared to the industry average, provide a brief explanation (4 marks) d) Do you feel that the bank and or other creditors perceive SPIW as a high-risk firm? Provide a brief explanation for your reasons. (4 marks) e) In reviewing the company do you feel that SPI-Windsor Inc., has adequate liquidity in the short-term. Provide a brief explanation (4 marks) 1) When reviewing the statement of earnings, what two (2) items would to show the sults for the past two years. (2 marks) ix. Earnings per share Price/Earnings Ratio X. b) Based on the information provided and your analysis do you feel that SPIW is profitable, provide a brief explanation. (4 marks) c) In reviewing the asset efficiency ratios for SPIW, what could be said in general and compared to the industry average, provide a brief explanation. (4 marks) d) Do you feel that the bank and or other creditors perceive SPIW as a high-risk firm? Provide a brief explanation for your reasons. (4 marks) e) In reviewing the company do you feel that SPI-Windsor Inc., has adequate liquidity in the short-term. Provide a brief explanation (4 marks) f) When reviewing the statement of earnings, what two (2) items would you note about the results for the past two years. (2 marks) g) When reviewing the statement of financial position what two (2) items would you note about the results for the past two years? (2 marks)