prefer excel file and use formula please!!

email file: s.alquzah@gmail.com

hris Guthrie was recently hired by S\&S Air, Inc., to partial payment before the order is complete. In conCassist the company with its financial planning and to trast, a commercial airplane may take one and one-half evaluate the company's performance. Chris graduated to two years to manufacture once the order is placed. from college five years ago with a finance degree. He Mark and Todd have provided the following finanhas been employed in the finance department of a cial statements. Chris has gathered the industry ratios Fortune 500 company since then, for the light airplane manufacturing industry. 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 commerclal 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 recelves a deposit on each order, as well as another hris Guthrie was recently hired by S\&S Air, Inc., to partial payment before the order is complete. In conCassist the company with its financial planning and to trast, a commercial airplane may take one and one-half evaluate the company's performance. Chris graduated to two years to manufacture once the order is placed. from college five years ago with a finance degree. He Mark and Todd have provided the following finanhas been employed in the finance department of a cial statements. Chris has gathered the industry ratios Fortune 500 company since then, for the light airplane manufacturing industry. 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 commerclal 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 recelves a deposit on each order, as well as another \begin{tabular}{lccr} & \multicolumn{3}{c}{ Light Airplane Industry Rotios } \\ & Lower Quartile & Median & Upper Quartile \\ & & & \\ & .50 & 1.43 & 1.89 \\ Current ratio & .64 & .84 & 1.05 \\ Quick ratio & .08 & .21 & .39 \\ Cash ratio & .68 & .85 & 1.28 \\ Total asset turnover & 4.89 & 6.15 & 10.89 \\ Inventory turnover & 6.27 & 9.82 & 11.51 \\ Receivables turnover & .31 & .52 & .61 \\ Total debt ratio & .58 & 1.08 & 1.56 \\ Debt-equity ratio & 1.58 & 2.08 & 2.56 \\ Equity multiplier & 5.18 & 8.06 & 9.83 \\ Times interest earned & 5.84 & 8.43 & 10.27 \\ Cash coverage ratio & 4.05% & 5.15% & 6.47% \\ Profit margin & 6.05% & 10.53% & 13.21% \\ Return on assets & 9.93% & 16.54% & 26.15% \\ Return on equity & & & \end{tabular} QUESTIONS 1. Calculate the ratios for S\&S Air that are shown for viewed as positive or negative relative to the inthe industry. dustry. Suppose you create an inventory ratio cal- 2. Mark and Todd agree that a ratio analysis can pro-_ culated by inventory divided by current liabilities. vide a measure of the company's performance. _How do you think S\&S Air's ratio would compare They have chosen Boeing as an aspirant comto the industry average? pany. Would you choose Boeing as an aspirant 4. Calculate the internal growth rate and sustainable company? Why or why not? 3. Compare the performance of 5&S Alr to the indusgrowth r mean? try. For each ratio, comment on why it might be