RATIO ANALYSIS 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 companys 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 companys 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 $103,000, and the Eagle, which sells for $178,000.

Although 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 can 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.

QUESTIONS

1.Using the financial statements provided for S&S Air, calculate each of the ratios listed in the table for the light aircraft industry.

2.Mark and Todd agree that a ratio analysis can provide a measure of the companys performance. They have chosen Boeing as an aspirant company. Would you choose Boeing as an aspirant company? Why or why not? There are other aircraft manufacturers S&S Air could use as aspirant companies. Discuss whether it is appropriate to use any of the following companies: Bombardier, Embraer, Cirrus Aircraft Corporation, and Cessna Aircraft Company.

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 as inventory divided by current liabilities. How do you think S&S Airs ratio would compare to the industry average?

JEGYULA LULAULU LUI Light Airplane Industry Ratios Lower Quartile Median Upper Quartile 50 1.43 21 1.89 .62 39 1.38 10.89 .85 4.89 .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 .68 1.68 5.18 5.84 4.05% 6.05% 9.93% 6.15 9.82 52 1.08 2.08 8.06 9.41 1.56 2.56 9.83 10.27 7.15% 5-10% 13.21% 9.53% 15.14% 19.15% QUESTIONS 1. Using the financial statements provided for S&S Air, calculate each of the ratios listed in the table for the light aircraft industry S&S AIR, INC. 2018 Balance Sheet Assets Liabilities and Equity Current assets Cash Current liabilities Accounts payable Notes payable Total current liabilities $ 524,963 843.094 1,235,161 $ 2.603.218 Accounts receivable Inventory Total current assets $ 1,068,356 2.439,553 $3.507.909 Long-term debt $ 6.300.000 Fixed assets Net plant and equipment $20.381.945 Shareholder equity Common stock Retained earnings Total equity Total liabilities and equity $ 460,000 12.717.254 $ 13.177.254 $ 22,985,163 Total assets $22,985,163 Mark and Todd have provided the following financial statements. Chris has gathered the industry ratios for the light airplane manufacturing industry. S&S AIR, INC. 2018 Income Statement Sales Cost of goods sold Other expenses Depreciation EBIT Interest Taxable income Taxes (25%) Net income Dividends Add to retained earnings $46,298,115 34.536,913 5,870,865 2,074.853 $ 3,815,484 725.098 $ 3,090,386 -772.592 $ 2.317.789 $ 705,000 1,612,789 S&S AIR, INC. 2018 Balance Sheet Assets Liabilities and Equity Current assets Current liabilities