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 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,980,051 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,500 Dividends per common share 0.95 0.81 0.55 Market Price High 101.25 88.25 69.25 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. per share: The following are the industry averages: Industry Averages Return on Assets Gross Profit Margin Asset Turnover Times Interest Earned Debt-to-Equity 2021 25.25% 39.75% 2.10x 29.84x 0.44 2020 28.75% 41.25% 2.45x 27.55x 0.51 You have been recently hired by SPI-Windsor Inc. (SPIW) as the assistant to the controller and the Controller has provided you with the following tasks for you to complete as indicated below. Tasks: a) A full analysis using the following ratio's: (20 marks) i. Current Ratio ii. Operating Cash Flow iii. Times Interest Earned iv. Debt-to-Equity Ratio v. Inventory Turnover Ratio vi. Asset Turnover Ratio vii. Gross Profit Percentage viii. Return on Assets ix. Earnings per share x. Price/Earnings Ratio 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) a 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)