te) HW Score: 7 P12-56A (similar to) Qu 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 Requirement 1. Calculate trend percentages for each item for 2015 through 2018. Use 2014 as the base year and round to the nearest percent Alexander Shipping, Inc. - Trend Percentages 2018 2017 2016 2015 2014 % % Net sales Net incomo Total assets % % % % % % % % % 100% 100 % 100% % Enter any number in the odit fields and then click Check Answer. 7 parts remaining Clear All Check Answe 5 of 6 (5 complete) HW Scor assets for Alexander Shipping, Inc., for a five-year period follow: ata.) percentages for each item for 2015 through 2018. Use 2014 as the base year and round to the nearest percent. Alexander S 2018 i Data Table - X 94 9 2018 2017 2016 (In thousands) Net sales 2015 2014 418 $ 356 $ 307 $ 300 906 $ 62 Net Income 31 29 40 29 Total assets +++ 310 272 252 230 203 Print Done t fields and then click Check Answer. Clear All Check Ar -k: End of Semester Project 5 of 6 (5 complete) HWS lar to) and total assets for Alexander Shipping, Inc., for a five-year period follow: view the data.) ulate trend percentages 0 Requirements Alexander Sh cent. 2018 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 tumover 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 the edit fields and then click Check Answer Clear All