Net sales, net income, and total assets for Alexander Shipping, Inc., for a five-year period follow: (Click the icon to view the data.) Read the requirements. (In thousands) Net sales 316 S 33 2014 303 34 Requirement 1. Calculate trend percentages for each item for 2015 through 2018. Use 2014 as the base year and round to the Net income Total assets 234 207 Alexander Shipping, Inc. - Trend Percentages 2016 2015 2018 330 % 2017 304 % 91 % 2014 100 % Net sales 104 % 163 % 129 % Net Income 168 % 97 % 100 % Print Done Total assets 145 % 130 % 121 % 113 % 100 % Requirement 2. Calculate the rate of return on net sales for 2016 through 2018, rounding to the nearest one-tenth percent. Expl Begin by selecting the rate of return on net sales (return on sales) formula and enter the amounts to calculate the percentages. (Enter amounts in thousands as provided to you in the problem statement. Complete all answer boxes. Enter "0" for any zero amounts and enter the return on sales amounts as percentages rounded to one-tenth percent, X.X%.) Return on sales 2016 ( }{\ % 2017 ( % 2018 ( }{ % Data table S 2018 2017 1,000 $ 920 $ 57 31 300 270 2016 494 $ 250 2015 - X Requirements 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 Alexander 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. Print Done X