| : 17 ... 1 Assignment A * A.. U I B ) old S&S AIR, INC. 2019 Balance Sheet Assets Liabilities and Equity Current assets Current liabilities Cash $ 481,852 Accounts payable $ 944,698 Accounts receivable 2,025,778 Notes payable 1,909,248 Inventory 1,634,820 Total current liabilities $ 2,853,946 Total current assets $ 4,142,450 Fixed assets Long-term debt $ 5,060,000 Net plant and equipment $16,256,698 Shareholder equity Common stock $ 190,000 Retained earnings 12,295,202 Assets Liabilities and Equity Current assets Current liabilities Cash $ 481,852 Accounts payable $ 944,698 Accounts receivable 2,025.778 Notes payable 1,909,248 Inventory 1,634,820 Total current liabilities $ 2,853,946 Total current assets $ 4,142,450 Fixed assets Long-term debt $ 5,060,000 Net plant and equipment $16,256,698 Shareholder equity Common stock $ 190,000 Retained earnings 12,295,202 : ... 1 Assignment A A.. U I B ) old Total current assets $ 4,142,450 Fixed assets Long-term debt $ 5,060,000 Net plant and equipment $16,256,698 Shareholder equity Common stock $ 190,000 Retained earnings 12,295,202 Total equity $12,485,202 Total assets $20,399,148 Total liabilities and equity $20,399,148 | : ... 1 Assignment ! * A. A . U I B ) old Light Airplane Industry Ratios Lower Quartile Median Upper Quartile -50 1.43 1.89 .64 .84 1.05 .08 .21 .39 .68 .85 1.13 4.89 6.15 10.89 6.27 9.82 11.51 31 -52 .61 Current ratio Quick ratio Cash ratio Total asset turnover Inventory turnover Receivables turnover Total debt ratio Debt-equity ratio Equity multiplier Times interest earned Cash coverage ratio Profit margin Return on assets Return on equity -58 1.08 1.56 1.58 2.08 2.56 5.18 8.06 9.83 10.27 5.84 4.05% 6.05% 8.43 6.75% 8.47% 10.53% 13.21% 9.93% 16.54% 26.15% QUESTIONS 1 Calcula Air that are chans for the indet | : ... 1 Assignment usis A. U I B ) old NCLUITI UN ASSCUS V.0570 TU.5370 15-2170 Return on equity 9.93% 16.54% 26.15% QUESTIONS 1. Calculate the ratios for S&S Air that are shown for the industry. 2. Mark and Todd agree that a ratio analysis can provide a measure of the company's performance. They have chosen Boeing as an aspirant company. Would you choose Boeing as an aspirant company? Why or why not? 3. Compare the performance of S&S Air to the industry. For each ratio, comment on why it might be viewed as positive or negative relative to the industry. Suppose you create an inventory ratio calculated by inventory divided by current liabilities. How do you think S&S Air's ratio would compare to the industry average? 4. Calculate the internal growth sustainable growth for S&S Air. What do these numbers mean? Ratios and Financial Planning at S&S Air, Inc. Chris Guthrie was recently hired by S&S Air, Inc., to assist the company with its financial planning and to evaluate the company's performance. Chris graduated from college five years ago with a finance degree. He has been employed in the finance department of a Fortune 500 company since then. S&S Air was founded 10 years ago by friends Mark Sexton and Todd Story. The company has manufactured and sold light airplanes over this period, and the company's products have received high reviews for safety and reliability. The company has a niche market in that it sells primarily to individuals who own and fly their own airplanes. The company has two models: the Birdie, which sells for $53,000, and the Eagle, which sells for $78,000. While the company manufactures aircraft, its operations are different from commercial aircraft companies. S&S Air builds aircraft to order. By using prefabricated parts, the company is able to complete the manufacture of an airplane in only five weeks. The company also receives a deposit on each order, as well as another partial payment before the order is complete. In contrast, a commercial airplane may take one and one-half to two years to manufacture once the order is placed. Mark and Todd have provided the following financial statements. Chris has gathered the industry ratios for the light airplane manufacturing industry. II : 17 ... 1 Assignment A A. U T B ) old manufacturing industry. S&S AIR, INC. 2019 Income Statement Sales $26,501,600 Cost of goods sold 19,780,200 Other expenses 3,166,700 Depreciation 864,500 EBIT $ 2,690,200 Interest 479,200 $ 2,211,000 Taxable income Taxes (21%) 464,310 Net income $ 1,746,690 Dividends $270,600 Additions to retained earnings 1,476,090 | : 17 ... 1 Assignment A * A.. U I B ) old S&S AIR, INC. 2019 Balance Sheet Assets Liabilities and Equity Current assets Current liabilities Cash $ 481,852 Accounts payable $ 944,698 Accounts receivable 2,025,778 Notes payable 1,909,248 Inventory 1,634,820 Total current liabilities $ 2,853,946 Total current assets $ 4,142,450 Fixed assets Long-term debt $ 5,060,000 Net plant and equipment $16,256,698 Shareholder equity Common stock $ 190,000 Retained earnings 12,295,202 Assets Liabilities and Equity Current assets Current liabilities Cash $ 481,852 Accounts payable $ 944,698 Accounts receivable 2,025.778 Notes payable 1,909,248 Inventory 1,634,820 Total current liabilities $ 2,853,946 Total current assets $ 4,142,450 Fixed assets Long-term debt $ 5,060,000 Net plant and equipment $16,256,698 Shareholder equity Common stock $ 190,000 Retained earnings 12,295,202 : ... 1 Assignment A A.. U I B ) old Total current assets $ 4,142,450 Fixed assets Long-term debt $ 5,060,000 Net plant and equipment $16,256,698 Shareholder equity Common stock $ 190,000 Retained earnings 12,295,202 Total equity $12,485,202 Total assets $20,399,148 Total liabilities and equity $20,399,148 | : ... 1 Assignment ! * A. A . U I B ) old Light Airplane Industry Ratios Lower Quartile Median Upper Quartile -50 1.43 1.89 .64 .84 1.05 .08 .21 .39 .68 .85 1.13 4.89 6.15 10.89 6.27 9.82 11.51 31 -52 .61 Current ratio Quick ratio Cash ratio Total asset turnover Inventory turnover Receivables turnover Total debt ratio Debt-equity ratio Equity multiplier Times interest earned Cash coverage ratio Profit margin Return on assets Return on equity -58 1.08 1.56 1.58 2.08 2.56 5.18 8.06 9.83 10.27 5.84 4.05% 6.05% 8.43 6.75% 8.47% 10.53% 13.21% 9.93% 16.54% 26.15% QUESTIONS 1 Calcula Air that are chans for the indet | : ... 1 Assignment usis A. U I B ) old NCLUITI UN ASSCUS V.0570 TU.5370 15-2170 Return on equity 9.93% 16.54% 26.15% QUESTIONS 1. Calculate the ratios for S&S Air that are shown for the industry. 2. Mark and Todd agree that a ratio analysis can provide a measure of the company's performance. They have chosen Boeing as an aspirant company. Would you choose Boeing as an aspirant company? Why or why not? 3. Compare the performance of S&S Air to the industry. For each ratio, comment on why it might be viewed as positive or negative relative to the industry. Suppose you create an inventory ratio calculated by inventory divided by current liabilities. How do you think S&S Air's ratio would compare to the industry average? 4. Calculate the internal growth sustainable growth for S&S Air. What do these numbers mean? Ratios and Financial Planning at S&S Air, Inc. Chris Guthrie was recently hired by S&S Air, Inc., to assist the company with its financial planning and to evaluate the company's performance. Chris graduated from college five years ago with a finance degree. He has been employed in the finance department of a Fortune 500 company since then. S&S Air was founded 10 years ago by friends Mark Sexton and Todd Story. The company has manufactured and sold light airplanes over this period, and the company's products have received high reviews for safety and reliability. The company has a niche market in that it sells primarily to individuals who own and fly their own airplanes. The company has two models: the Birdie, which sells for $53,000, and the Eagle, which sells for $78,000. While the company manufactures aircraft, its operations are different from commercial aircraft companies. S&S Air builds aircraft to order. By using prefabricated parts, the company is able to complete the manufacture of an airplane in only five weeks. The company also receives a deposit on each order, as well as another partial payment before the order is complete. In contrast, a commercial airplane may take one and one-half to two years to manufacture once the order is placed. Mark and Todd have provided the following financial statements. Chris has gathered the industry ratios for the light airplane manufacturing industry. II : 17 ... 1 Assignment A A. U T B ) old manufacturing industry. S&S AIR, INC. 2019 Income Statement Sales $26,501,600 Cost of goods sold 19,780,200 Other expenses 3,166,700 Depreciation 864,500 EBIT $ 2,690,200 Interest 479,200 $ 2,211,000 Taxable income Taxes (21%) 464,310 Net income $ 1,746,690 Dividends $270,600 Additions to retained earnings 1,476,090
