Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE HELP WITH 2 THROUGH 6 QUESTIONS, THANK YOU Net sales, net income, and total assets for Alex Shipping, Inc., for a five-year period follow:

image text in transcribedimage text in transcribedPLEASE HELP WITH 2 THROUGH 6 QUESTIONS, THANK YOU

Net sales, net income, and total assets for Alex 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. Alex Shipping, Inc. - Trend Percentages 2018 2017 2016 2015 2014 Net sales. 304 % 168 % 165 % 103 % 100 % Net income 248 % 148 % 183 % 139 % 100 % 1 Total assets. 147 % 132 % 126 % 107 % 100 % Requirement 2. Calculate the rate of return on net sales for 2016 through 2018, rounding to the nearest one-tenth percent. Explain what this means. 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 ( 17 % 2017 III II % 2018 % Data Table (In thousands) 2018 2017 2016 2015 2014 Net sales.. $ 906 $ 500 $ 493 $ 308 $ 298 Net income 57 34 42 32 23 Total assets 302 270 258 220 205 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 Alex 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Political Standards

Authors: Karthik Ramanna

1st Edition

022652809X, 9780226528090

More Books

Students also viewed these Accounting questions

Question

What has been your desire for leadership in CVS Health?

Answered: 1 week ago

Question

Question 5) Let n = N and Y Answered: 1 week ago

Answered: 1 week ago