You have been provided the following financial statements for SPI-Windsor Inc. (SPIW): Revenues Costs and Expenses:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You have been provided the following financial statements for SPI-Windsor Inc. (SPIW): Revenues Costs and Expenses: Cost of Goods Sold SPI-Windsor Inc. Statement of Earnings (in thousands) $ $ Selling and Administrative $ Interest $ Other expenses (income) $ Total Costs and Expenses Income before taxes Income Taxes Net Income $ $ $ $ Year Ended September 30 2020 2021 2019 5,198,256 $ 3,956,781 $3,281,791 2,859,041 $ 2,311,560 $1,904,561 1,027,412 $ 753,966 $ 698,236 33,794 $ 42,596 $ 29,891 3,500 $ 4,890 $ (1,020) 3,923,747 $ 3,113,012 $2,631,668 1,274,509 $ 843,769 $ 650,123 382,353 $ 210,942 $ 162,531 892,156 $ 632,827 $ 487,592 SPI-Windsor Inc. Statement of Financial Position (in thousands) ASSETS Current Assets Cash and cash equivalents Accounts Receivable (note 1) Inventories Deffered Income Taxes Prepaid Expenses Total Current Assets. Property, Plant, Equipment Less Accumulated Depreciation Net PPE Goodwill Other Assets Total Assets LIABILITIES AND SHAREHOLDERS' Current Liabilities. Current Portion of LT Debt Notes Payable Accounts Payable Accrued Liabilities Income Taxes Payable Total Current Liabilities Long-term Debt Noncurrent deffered income tax Other non current liabilities Redeemable Preferred Shares Total Liabilities Shareholders' Equity Common Shares Contributed Surplus Retained Earnings Year Ended September 30 2021 2020 $501,695 $ 421,950 $ 795,500 $ 701,560 648,000 $ 550,200 $ $ $ 25,125 $ 21,600 63,250 $ 47,980 $2,033,570 $1,743,290. $ 785,000 $ 715,000 $ 290,450 $393,250 $ 494,550 $ 321,750 203,500 $ 203,500 39,150 $ 33,150 $ $ $2,770,770 $2,301,690 EQUITY $ $ 83,169 $ 15,500 185,500 $ 135,600 $ 189,400 $ 195,005 172,500 $164,900 38,500 $ 51,000 669,069 $ 562,005 24,950 $ $ 35,000 $ 61,500 $ 200 $ 790,719 $ $ $ $ $ $ $ 1 $ $ 25,700 $ AS 85,125 31,000 39,400 200 717,730 1 8,954 $1,954,350 $1,575,005 Total Shareholders' Equity $1,980,051 $1,583,960 Total Liabilities and Shareholders' Equ $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 andd $28,724. The following two table provides additional information for you to review regarding SPI-Windsor Inc.: Average number of common shares outstanding Accounts Receivable Inventories Total Assets Shareholders' Equity 2021 25.25% 39.75% 2.10x 2021 2020 56,001 54,125 795,500 701,650 2019 54,001 605,125 648,000 550,200 500,175 2,770,770 2,301,690 2,100,500 1,980,051 1,583,960 1,150,000 780,520 485,100 395,100 695,000 305,000 71,850 41,500 0.95 0.55 Share Repurchases Cash Flow from operating activities Common Dividends Paid Dividends per common share Market Price per share: High 101.25 Low 65.25 Close 99.60 *Please note all are amounts above are in thousands except for costs per share information provided. The following are the industry averages: Industry Averages Return on Assets Gross Profit Margin Asset Turnover Times Interest Earned Debt-to-Equity 29.84x 0.44 580,000 51,500 0.81 88.25 44.25 71.25 2020 28.75% 41.25% 2.45x 27.55x 0.51 69.25 31.25 48.75 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. Debt-to-Equity Ratio iv) 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) 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] You have been provided the following financial statements for SPI-Windsor Inc. (SPIW): Revenues Costs and Expenses: Cost of Goods Sold SPI-Windsor Inc. Statement of Earnings (in thousands) $ $ Selling and Administrative $ Interest $ Other expenses (income) $ Total Costs and Expenses Income before taxes Income Taxes Net Income $ $ $ $ Year Ended September 30 2020 2021 2019 5,198,256 $ 3,956,781 $3,281,791 2,859,041 $ 2,311,560 $1,904,561 1,027,412 $ 753,966 $ 698,236 33,794 $ 42,596 $ 29,891 3,500 $ 4,890 $ (1,020) 3,923,747 $ 3,113,012 $2,631,668 1,274,509 $ 843,769 $ 650,123 382,353 $ 210,942 $ 162,531 892,156 $ 632,827 $ 487,592 SPI-Windsor Inc. Statement of Financial Position (in thousands) ASSETS Current Assets Cash and cash equivalents Accounts Receivable (note 1) Inventories Deffered Income Taxes Prepaid Expenses Total Current Assets. Property, Plant, Equipment Less Accumulated Depreciation Net PPE Goodwill Other Assets Total Assets LIABILITIES AND SHAREHOLDERS' Current Liabilities. Current Portion of LT Debt Notes Payable Accounts Payable Accrued Liabilities Income Taxes Payable Total Current Liabilities Long-term Debt Noncurrent deffered income tax Other non current liabilities Redeemable Preferred Shares Total Liabilities Shareholders' Equity Common Shares Contributed Surplus Retained Earnings Year Ended September 30 2021 2020 $501,695 $ 421,950 $ 795,500 $ 701,560 648,000 $ 550,200 $ $ $ 25,125 $ 21,600 63,250 $ 47,980 $2,033,570 $1,743,290. $ 785,000 $ 715,000 $ 290,450 $393,250 $ 494,550 $ 321,750 203,500 $ 203,500 39,150 $ 33,150 $ $ $2,770,770 $2,301,690 EQUITY $ $ 83,169 $ 15,500 185,500 $ 135,600 $ 189,400 $ 195,005 172,500 $164,900 38,500 $ 51,000 669,069 $ 562,005 24,950 $ $ 35,000 $ 61,500 $ 200 $ 790,719 $ $ $ $ $ $ $ 1 $ $ 25,700 $ AS 85,125 31,000 39,400 200 717,730 1 8,954 $1,954,350 $1,575,005 Total Shareholders' Equity $1,980,051 $1,583,960 Total Liabilities and Shareholders' Equ $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 andd $28,724. The following two table provides additional information for you to review regarding SPI-Windsor Inc.: Average number of common shares outstanding Accounts Receivable Inventories Total Assets Shareholders' Equity 2021 25.25% 39.75% 2.10x 2021 2020 56,001 54,125 795,500 701,650 2019 54,001 605,125 648,000 550,200 500,175 2,770,770 2,301,690 2,100,500 1,980,051 1,583,960 1,150,000 780,520 485,100 395,100 695,000 305,000 71,850 41,500 0.95 0.55 Share Repurchases Cash Flow from operating activities Common Dividends Paid Dividends per common share Market Price per share: High 101.25 Low 65.25 Close 99.60 *Please note all are amounts above are in thousands except for costs per share information provided. The following are the industry averages: Industry Averages Return on Assets Gross Profit Margin Asset Turnover Times Interest Earned Debt-to-Equity 29.84x 0.44 580,000 51,500 0.81 88.25 44.25 71.25 2020 28.75% 41.25% 2.45x 27.55x 0.51 69.25 31.25 48.75 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. Debt-to-Equity Ratio iv) 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) 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]
Expert Answer:
Answer rating: 100% (QA)
a 1 The current ratio for SPIW is 147 which is lower than the industry average of 210 This means that SPIW may have difficulty meeting its shortterm obligations with its current assets 2 The operating ... View the full answer
Related Book For
Introduction to Corporate Finance What Companies Do
ISBN: 978-1111222284
3rd edition
Authors: John Graham, Scott Smart
Posted Date:
Students also viewed these accounting questions
-
A commodity bond links interest and principal payments to the price of a commodity. Differentiate a commodity bond from a straight bond and then from equity. How would you factor these differences...
-
Barry Boswell is a financial analyst for Dossman Metal Works, Inc. and he is analyzing two alternative configurations for the firms new plasma cutter shop. The two alternatives that are denoted A and...
-
Gail Dribble is a financial analyst at Hill Propane Distributors. Gail must provide a financial analysis of the decision to replace a truck used to deliver propane gas to residential customers. Given...
-
What is meant by a throwaway prototype?
-
Consider two countries, East and West, that produce and trade two goods, Food and Clothing, using skilled and unskilled labor. Each unit of Food requires 1 unit of unskilled labor and 2 units of...
-
Consider again the car panel painting machine discussed in Problem 2.2.6. What is the expected paint thickness? What is the median paint thickness? Problem 2.2.6 A car panel is spray-painted by a...
-
Explain what the following accounting terms mean: a. Cost principle b. Conservatism
-
How would the court most likely rule on Scotts employee status? James Blatt hired Marilyn Scott to sell insurance for the Massachusetts Mutual Life Insurance Co. Their contract stated, Nothing in...
-
The adjusted trial balance for Blossom's Animations is presented below. BLOSSOM'S ANIMATIONS Adjusted Trial Balance December 31, 2024 Debit Credit Cash $3,300 Accounts receivable 4,700 Prepaid...
-
Cinder and PQ are associated [ITA 256(1)(a)] and connected [ITA 186(4)] for tax purposes. Cinder Inc. is a Canadian-controlled private corporation based in your province. The company operates a...
-
Helicopter Gear is planning to expand its product line, which requires investment of $475,200 in special-purpose machinery. The machinery has a useful life of six years and no salvage value. The...
-
What is return abuse? Should prices be reduced and returns limited to offset return abuse? Explain.
-
A puck of mass m = 1.30 kg slides in a circle of radius r = 23.0 cm on a frictionless table while attached to a hanging cylinder of mass M=4.20 kg by a cord through a hole in the table. What speed...
-
4. (4 points) A simple spring is used to measure force; force can be calculated using F = kx where x = 12.5 1.25 cm and k = 700 + 18 N/cm. Calculate the measured force and the uncertainty in the...
-
A firm with annual revenues of $8,760,000 has DSO of 30 days. Calculate the change in receivables that would occur if the firm's collections deteriorated so that DSO increased to 50 days.
-
A positive charge is moving to the right and experiences an upward magnetic force, as shown in this figure: F +Q V In which direction must the magnetic field have a component? A. to the right B. to...
-
Given that the following Zero rate with semiannual compounding: Maturity (years) Zero rate(semi-annual) 0.5 1.0 5 5.25 1.5 2.0 5.5 6 (a) What are the rates with continuous compounding? (8 points) (b)...
-
Draw and label the E and Z isomers for each of the following compounds: 1. CH3CH2CH==CHCH3 2. 3. 4. CH,CH2C CHCH2CH Cl CH3CH2CH2CH2 CH CH2CCCH2CI CHCH3 CH3 HOCH CH CCC CH O-CH C(CH
-
Tracey White, the owner of the Buzz Coffee Shop chain, has decided to expand her operations. Her 2012 financial statements follow. Tracey can buy two additional coffeehouses for $3 million, and she...
-
Fournier Industries, a publicly traded waste disposal company, is a highly leveraged firm with 70% debt, 0% preferred stock, and 30% common equity financing. Currently the risk-free rate is about...
-
A firm operates in perfect capital markets. The required return on its outstanding debt is 6 percent, the required return on its shares is 14 percent, and its WACC is 10 percent. What is the firms...
-
Wisconsin Tool Company Wisconsin Tool Company (WTC) is a business located in Madison, WI that manufacturers tool and die equipment. WTC executed three sales in Year 23. See Sale Agreements in the...
-
Saenz-Qualified Business Income Javier and Maria Saenz, married filing jointly, have several investments. Their adjusted gross income and taxable income for 2023 is \( \$ \) 300,000 and \( \$ \)...
-
Find the Laplace transform of the following signals and locate the poles and zeros of \(F(s)\). (a) \(f(t)=-10 \mathrm{~d} \delta(t) / d t\) (b) \(f(t)=120 \cos (377 t) u(t)\). (c)...
Study smarter with the SolutionInn App