I need help in this. Please do it on excel as you can see in the pictures, Please I only need question 3 (overall interpretation and analysis and Q4 ). Please do only those

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 alrcraft, Its operations are different from commercial aircraft companies. S&S Air builds alrcraft 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 depost 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 S&S AIR, INC 2019 Income Statement $26,501,600 19.780,200 3,166,700 864.500 $ 2,690,200 Sales Cost of goods sold Other expenses Depreciation EBIT Interest Taxable income Taxes (21%) Net income Dividends Additions to retained earnings 479.200 $ 2,211,000 464.310 $ 1.746,690 $270,600 1,476,090 S&S AIR, INC. 2019 Balance Sheet Liabilities and Equity Current liabilities Current assets Cash $ 481.852 2,025.778 Accounts payable Notes payable Total current liabilities $ 944,698 1,909,248 $ 2,853.946 1.634,820 Accounts receivable Inventory Total current assets Fixed assets Net plant and equipment $ 4.142.450 $ 5,060,000 $16.256,698 Long-term debt Shareholder equity Common stock Retained earnings $ 190,000 12,295,202 $ 481.852 Current assets Cash Accounts receivable Inventory Total current assets Fixed assets Net plant and equipment Liabilities and Equity Current liabilities Accounts payable Notes payable Total current liabilities $ 944698 2,025.778 1.634.820 1,909,248 $ 2,853.946 $ 4.142,450 $ 5,060,000 816.256,608 $ 190,000 Long-term debt Shareholder equity Common stock Retained earnings Total equity Total liabilities and equity 12,295,202 $12.485.202 Total assets $20,399.148 $20,399.148 Light Airplane Industry Ratios Lower Quartile Median Upper Quartile 1.43 1.89 -50 .64 .84 1.05 .08 .21 -39 .68 1.13 .85 6.15 4.89 6.27 9.82 10.89 11.51 .61 -52 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 1.08 2.08 1.56 2.56 9.83 31 -58 1.58 5.18 5.84 4.05% 6.05% 9.93% 10.27 8.06 8.43 6.75% 10.53% 16.54% 8.47% 13.21% 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 rate and sustainable growth rate for S&S Air. What do these numbers mean? B D E F G H 1 | J K L L M N o 1 FIN220 Marking rubrics Name: Studen ID: Section No.: Formula Point Unit Point Result Point 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 3 Q1 4 Ratio 5 Current Ratio 6 Quick Ratio 7 Cash Ratio 8 Total Asset Turnover 9 Inventory Turnover 10 Receivables Turnove 11 Total Debt Ratio 12 Debt-Equity Ratio 13 Equity Multiplier 14 Times Interest Earne 15 Cash Coverage Ratio 16 Profit Margin 17 Return on Assets 18 Return on Equity 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 19 Total 14 14 14 42 point 20 Q2 10 3 Q3 Reference for comparing the ratio to industry Ratio Result Favorable/ Point Point Short analysis Unfavorable Light Airplane Industry Ratios Current Ratio 1 1 1 Lower Quartile 0.50 Upper Median Quartile 1.43 1.89 1 1 1 2 Quick Ratio 3 Cash Ratio 4 Total Asset Turnove 5 Inventory Turnover 5 Receivables Turnove 1 1 1 1 Current Ratio Quick Ratio Cash Ratio Total Asset Turnov Inventory Turnover 0.64 0.08 0.68 4.89 0.84 0.21 0.85 6.15 1.05 0.39 1.28 10.89 2 1 6.27 9.82 11.51 1 2 0.52 0.61 1 Total Debt Ratio 7 Debt-Equity Ratio Equity Multiplier Times Interest Earn 1 Cash Coverage Ratid 2. Profit Margin Return on Assets 3 Receivables Turno Total Debt Ratio Debt-Equity Ratio Equity Multiplier Times Interest Earl Cash Coverage Rati 1 1 1 0.31 0.58 1.58 5.18 5.84 1.08 2.08 8.06 8.43 1.56 2.56 9.83 10.27 1 4.05% 5.15% 6.47% 2 Profit Margin 1 6.05% 10.53% 13.21% Return on Equity 4 5 Total Return on Assets Return on Equity 14 9 23 point 9.93% 16.54% 26.15% 5 Deeper analysis on current and quick ratio: 3 3 1 6 points 2 3 mm 3 Overall interpretation 4 point 10 points 63 64 Q4 65 Formula Calculation Point 4 4 4 Retention Ratio 66 67 Internal Growth 68 Sustainable 69 70 71 72 73 Overall Interpretation 3 74 Total 15 points Solution Sheet +)