Mini Case: Ed Cowan was recently hired by Tuxedo Air Inc. to assist the organization with its financial planning and to evaluate the organization's performance. Ed graduated from university six years ago with a finance degree. He has been employed in the finance department of a TSX100 company since then. Tuxedo Air was founded 12 years ago by friends Mark Taylor and Jack Rodwell. The organization manufactured and sold light airplanes over this period, and its products have received high reviews for safety and reliability. The organization has a niche market in that it sells primarily to individuals who own and fly their own airplanes. The company has two models; the Sparrow, which sells for $53,000, and the Vulture, which sells for $78,000. Although the company manufactures aircraft, its operations are different from commercial aircraft companies. Tuxedo Air builds aircraft to order. By using prefabricated parts, the organization can complete the manufacture of an airplane in only five weeks. The organization 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 Jack have provided the following financial statements. Ed has gathered the industry ratios for the light airplane manufacturing industry. Tuxedo Alr Inc. 2015 Statement of Comprehensive Income Sales $36,599,300 Cost of goods sold 26,669,496 Other expenses 4,641,000 Depreciation 1,640,200 EBIT $ 3,648,604 Interest 573,200 Taxable income $ 3,075,404 Taxes (40%) 1,230,162 Net income $ 1,845,242 Dividends $ 560,000 Add to retained earnings 1,285,242 Assets Current assets Cash Accounts receivable $ 844,550 1,928,500 2,773,050 Tuxedo Alr Inc. 2015 Statement of Financial Position Llabilities and Equity Current liabilities $ 396,900 Accounts payable 637,560 Notes payable Total current liabilities 933.400 $ 1,967,860 Long-term debt Owners' equity $15,411,620 Common stock Retained earnings Total equity $17,379,480 Total liabilities and owners' equity $ 5,050,000 Inventory Total current assets Fixed assets Net plant and equipment $ 322,500 4233,930 $ 9,556,430 $17,379,480 Total assets 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 Ught Alrplane Industry Ratlos Lower Quartile Median 0.50 1.43 0.21 0.38 0.08 0.21 0.68 0.85 4.89 6.15 6.27 982 0.44 0.52 1.08 1.79 2.08 5.18 8.06 5.84 8.43 4.05% 6.98% 6.05% 10.53% 9.93% 16.54% Upper Quartille 1.89 0.62 0.39 1.38 10.89 14.11 0.61 1.56 2.56 9.83 10.27 4.87% 13.21% 26.15% 0.79 Questions 1. Using the financial statements provided for Tuxedo Air, calculate each of the ratios listed in the table for the light aircraft industry. 2. Mark and Jack agree that a ratio analysis can provide a measure of the company's performance. They have chosen Bombardier as an aspirant company. Would you choose Bombardier as an aspirant company? Why or why not? There are other aircraft manufacturers Tuxedo Air could use as aspirant companies. Discuss whether it is appropriate to use any of the following companies: Boeing, XOJET, Piper Aircraft, and AeroCentury. 3. Compare the performance of Tuxedo 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 Tuxedo Air would compare to the industry average