Req 2-6 please.

Part 2 of 8 Points: 1.05 of 5 >> Nel sales, net income, and total assets for Aircraft Shipping, ind for a five-year poriod follow Click the icon to wow the data) Road the requirements Requirement 1. Calculato trend percentages for each item for 2015 through 2018 Use 2014 as the base your and round to the nearest percent Aircraft Shipping, Inc. - Trend Percentages 2018 2017 2016 2015 2014 1189 Not so Not income 137 64 150 164 106 33% 128 % 104 % 115% 108 % 100 100% 100% Total assets 130 Requirement 2. Calculate the rate of return on net sales for 2016 through 2018, rounding to the nearest one tonth percent Explain what this means Begin by selecting the rate of return on not sales return on salos) formula and enter the amounts to calculate the percentages (Entor amounts in thousands as provided to you in the problem statement complete all answer boxes Enter o for any zero amounts and enter the return on sales amounts as porcentages rounded Return on sales % 2016 2017 ( 2018 * % - Requirements 1 1. Calculate trend percentages for each item for 2015 through 2018. Use 2014 as the base year and round to the nearest percent 2. Calculate the rate of return on net sales for 2016 through 2018, rounding to the nearest one-tenth percent. Explain what this means 3. Calculate asset turnover for 2016 through 2018. Explain what this means 4. Use a DuPont Analysis to calculate the rate of return on average total assets (ROA) for 2016 through 2018 5. How does Aircraft Shipping's return on net sales for 2018 compare with previous years? How does it compare with that of the industry? In the shipping industry, rates above 9% are considered good, and rates above 11% are outstanding 6. Evaluate the company's ROA for 2018, compared with previous years and against an 18% benchmark for the industry Data table (In thousands) 2017 2016 2015 2014 2018 $ 418 5 Net sales 503 $ 360 $ 318 $ 306 Net income 21 35 11 38 33 Total assets 304 264 260 220 203 Print Done