Please, I want to help you with the solution. I found the same question, but the numbers in the table differ, only one table, which is the same numbers, and the rest of the tables are different. Please help me and solve it with the numbers shown in the pictures. Thank you

please i need answers q1 and q 3

Please, I want to help you with the solution. I found the same question, but the numbers in the table differ, only one table, which is the same numbers, and the rest of the tables are different. Please help me and solve it with the numbers shown in the pictures. Thank you

this question 1 + 3

This is all the information filmed from the book for more clarity and the solution is not the problem of excel or writing, all of them are allowed

1. [Textbook Ch.3 p.94 95] Answer the Question 1 in page 95. Q. Using the financial statements provided for S\&S Air, calculate each of the ratios listed in the table for the light aircraft industry. 2. [Textbook Ch.3 p.94 95] Answer the Question 3 in page 95. Q. 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 industry. Suppose you create an inventory ratio calculated as inventory divided by current liabilities. How do you think S\&S Air's ratio would compare to the industry average? Hint: Textbook states that "inventory ratio = inventory / current liabilities". Using two ratios among the given table for the light aircraft industry, we can estimate the industry-level "inventory ratio". Ratio Analysis at S\&S Air, Inc. 597t ifrin inder in flackl. arflark wimfiacting inslunar. Qutstioks 1s the 1ret aikiat indesing. 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 company's performance. They have chosen Boeing as 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, and Cirrus Aircraft Corporation. 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 Air's ratio would compare to the industry average? Ratio Analysis at S\&S Air, Inc. Chris Guthrie was recently hired by S\&S Air, Inc., to assist S\&S Air was founded 10 years ago by friends Mark Setton the company with its financial planning and to evaluate and Todd Story. The company has manufactured and sold light the company's performance. Chris graduated from college airplanes over this period, and the company's products have five years ago with a finance degree. Since then, he has received high reviews for safety and reliability. The company has been employed in the finance department of a Fortune 500 a niche market in that it sells primarily to individuals who own company. 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 aireraft companies. S\&S Air builds aircraft to order. By using prefabricated paris. 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 hefore 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. Workins, with Financial Statcments S8S AIR, INC. 2021 BALANCE SHEET \begin{tabular}{|lccc|} \hline \multicolumn{4}{c|}{ Light Airplane Industry Ratios } \\ \hline & Lower Ouartile & Median & Upper Quartile \\ \hline Current ratio & .50 & 1.43 & 1.89 \\ Quick ratio & .21 & .35 & .62 \\ Cash ratio & .08 & .21 & .39 \\ Total asset turnover & .68 & .85 & 1.38 \\ Inventory turnover & 4.89 & 6.15 & 10.89 \\ Receivables turnover & 6.27 & 9.82 & 14.11 \\ Total debt ratio & .41 & .52 & .61 \\ Debt-equity ratio & .68 & 1.08 & 1.56 \\ Equity multiplier & 1.68 & 2.08 & 2.56 \\ Times interest earned & 5.18 & 8.06 & 9.83 \\ Cash coverage ratio & 5.84 & 9.41 & 10.27 \\ Profit margin & 4.05% & 5.10% & 7.15% \\ Return on assets & 6.05% & 9.53% & 13.21% \\ Return on equity & 9.93% & 15.14% & 19.15% \\ \hline \end{tabular} 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 company's 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, and Cirrus Aircraft Corporation. 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 Air's ratio would compare to the industry average? 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. Ratio Analysis at S\&S Air, Inc. Chris Guthric was recently hired by S\&S Air, Inc., to assist S S\&S Air was founded 10 years ago by friends Mark Sexton the company with its financial planning and to evaluate and Todd Story. The company has manufactured and sold light the company's performance. Chris graduated from college airplanes over this period, and the company's products have five years ago with a finance degree. Since then, he has received high reviews for safety and reliability. The company has been employed in the finance department of a Fortune 500 a niche market in that it sells primarily to individuals who own company. and fly their own airplanes. The company has two models: the Working with Financial Statements \begin{tabular}{|lccc|} \hline \multicolumn{3}{c|}{ Light Airplane Industry Ratios } & \\ \hline & Lower Quartile & Median & Upper Quartile \\ \hline Current ratio & .50 & 1.43 & 1.89 \\ Quick ratio & .21 & .35 & .62 \\ Cash ratio & .08 & .21 & .39 \\ Total asset turnover & .68 & .85 & 1.38 \\ Inventory turnover & 4.89 & 6.15 & 10.89 \\ Receivables turnover & 6.27 & 9.82 & 14.11 \\ Total debt ratio & .41 & .52 & .61 \\ Debt-equity ratio & .68 & 1.08 & 1.56 \\ Equity multiplier & 1.68 & 2.08 & 2.56 \\ Times interest earned & 5.18 & 8.06 & 9.83 \\ Cash coverage ratio & 5.84 & 9.41 & 10.27 \\ Profit margin & 4.05% & 5.10% & 7.15% \\ Return on assets & 6.05% & 9.53% & 13.21% \\ Return on equity & 9.93% & 15.14% & 19.15% \\ \hline \end{tabular} 1. [Textbook Ch.3 p.94 95] Answer the Question 1 in page 95. Q. Using the financial statements provided for S\&S Air, calculate each of the ratios listed in the table for the light aircraft industry. 2. [Textbook Ch.3 p.94 95] Answer the Question 3 in page 95. Q. 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 industry. Suppose you create an inventory ratio calculated as inventory divided by current liabilities. How do you think S\&S Air's ratio would compare to the industry average? Hint: Textbook states that "inventory ratio = inventory / current liabilities". Using two ratios among the given table for the light aircraft industry, we can estimate the industry-level "inventory ratio". Ratio Analysis at S\&S Air, Inc. 597t ifrin inder in flackl. arflark wimfiacting inslunar. Qutstioks 1s the 1ret aikiat indesing. 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 company's performance. They have chosen Boeing as 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, and Cirrus Aircraft Corporation. 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 Air's ratio would compare to the industry average? Ratio Analysis at S\&S Air, Inc. Chris Guthrie was recently hired by S\&S Air, Inc., to assist S\&S Air was founded 10 years ago by friends Mark Setton the company with its financial planning and to evaluate and Todd Story. The company has manufactured and sold light the company's performance. Chris graduated from college airplanes over this period, and the company's products have five years ago with a finance degree. Since then, he has received high reviews for safety and reliability. The company has been employed in the finance department of a Fortune 500 a niche market in that it sells primarily to individuals who own company. 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 aireraft companies. S\&S Air builds aircraft to order. By using prefabricated paris. 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 hefore 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. Workins, with Financial Statcments S8S AIR, INC. 2021 BALANCE SHEET \begin{tabular}{|lccc|} \hline \multicolumn{4}{c|}{ Light Airplane Industry Ratios } \\ \hline & Lower Ouartile & Median & Upper Quartile \\ \hline Current ratio & .50 & 1.43 & 1.89 \\ Quick ratio & .21 & .35 & .62 \\ Cash ratio & .08 & .21 & .39 \\ Total asset turnover & .68 & .85 & 1.38 \\ Inventory turnover & 4.89 & 6.15 & 10.89 \\ Receivables turnover & 6.27 & 9.82 & 14.11 \\ Total debt ratio & .41 & .52 & .61 \\ Debt-equity ratio & .68 & 1.08 & 1.56 \\ Equity multiplier & 1.68 & 2.08 & 2.56 \\ Times interest earned & 5.18 & 8.06 & 9.83 \\ Cash coverage ratio & 5.84 & 9.41 & 10.27 \\ Profit margin & 4.05% & 5.10% & 7.15% \\ Return on assets & 6.05% & 9.53% & 13.21% \\ Return on equity & 9.93% & 15.14% & 19.15% \\ \hline \end{tabular} 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 company's 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, and Cirrus Aircraft Corporation. 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 Air's ratio would compare to the industry average? 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. Ratio Analysis at S\&S Air, Inc. Chris Guthric was recently hired by S\&S Air, Inc., to assist S S\&S Air was founded 10 years ago by friends Mark Sexton the company with its financial planning and to evaluate and Todd Story. The company has manufactured and sold light the company's performance. Chris graduated from college airplanes over this period, and the company's products have five years ago with a finance degree. Since then, he has received high reviews for safety and reliability. The company has been employed in the finance department of a Fortune 500 a niche market in that it sells primarily to individuals who own company. and fly their own airplanes. The company has two models: the Working with Financial Statements \begin{tabular}{|lccc|} \hline \multicolumn{3}{c|}{ Light Airplane Industry Ratios } & \\ \hline & Lower Quartile & Median & Upper Quartile \\ \hline Current ratio & .50 & 1.43 & 1.89 \\ Quick ratio & .21 & .35 & .62 \\ Cash ratio & .08 & .21 & .39 \\ Total asset turnover & .68 & .85 & 1.38 \\ Inventory turnover & 4.89 & 6.15 & 10.89 \\ Receivables turnover & 6.27 & 9.82 & 14.11 \\ Total debt ratio & .41 & .52 & .61 \\ Debt-equity ratio & .68 & 1.08 & 1.56 \\ Equity multiplier & 1.68 & 2.08 & 2.56 \\ Times interest earned & 5.18 & 8.06 & 9.83 \\ Cash coverage ratio & 5.84 & 9.41 & 10.27 \\ Profit margin & 4.05% & 5.10% & 7.15% \\ Return on assets & 6.05% & 9.53% & 13.21% \\ Return on equity & 9.93% & 15.14% & 19.15% \\ \hline \end{tabular}