Question

In: Accounting

Compute trend percentages for each item for 2013 through 2016. Use 2012 as the base year...

Compute trend percentages for each item for 2013 through 2016. Use 2012 as the base year and round to the nearest percent.

2. Compute the rate of return on net sales for 2014 through 2016. Explain what this means.

3. Compute asset turnover for 2014 through 2016. Explain what this means.

4. Use DuPont Analysis to compute rate of return on average total assets​ (ROA) for 2014 through 2016.

5. How does AccurateShipping's return on net sales for 2016 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 Accurate ​Shipping, Inc.'s ROA for 2016​, compared with previous years and against an​ 18% benchmark for the industry.

Information to fill in

(In thousands) 2016 2015 2014 2013 2012

Net Sales.......................................$ 1,000 $ 920 $492 $308 $306

Net income................................. 41 34 11 39 24

Total assets................................. 300 266 262 230 208

Requirement 1. Compute trend percentages for each item for 2013 through 2016. Use 2012

as the base year and round to the nearest percent.

Accurate Shipping, Inc. - Trend Percentages

2016

2015

2014

2013

2012

Net sales. . . . . . . . . . . . . . .

%

%

%

%

100

%

Net income. . . . . . . . . . . .

%

%

%

%

100

%

Total assets. . . . . . . . . . . . .

%

%

%

%

100

%

Requirement 2. Compute the rate of return on net sales for

20142014

through

20162016.

Explain what this means.

Begin by selecting the rate of return on net sales​ (return on​ sales) formula and then enter the amounts to calculate the percentages. ​(Enter amounts in thousands as provided to you in the problem statement. Enter​ "0" for zero amounts and enter the return on sales amounts as percentages rounded to​ one-tenth percent,​ X.X%.)

(

-

) /

=

Return on sales

2014

(

-

) /

=

%

2015

(

-

) /

=

%

2016

(

-

) /

=

%

Explain what this means.

Return on sales measures

the ability to collect cash from credit customers.

the amount of net income for each dollar of net sales.

the amount of net sales per dollar invested in assets.

the percentage of a stock's market value returned as dividends to stockholders.

Requirement 3. Compute asset turnover for

20142014

through

20162016.

Explain what this means.

Begin by selecting the asset turnover formula and then enter the amounts to calculate the ratios. ​(Enter amounts in thousands as provided to you in the problem statement. Do not round until your final​ answer, then enter the asset turnover amounts rounded to three decimal​ places, .XXX.)

/

=

Asset turnover

2014

/

=

2015

/

=

2016

/

=

Explain what this means.

Asset turnover means

the ability to collect cash from credit customers.

the amount of net income for each dollar of net sales.

the amount of net sales per dollar invested in assets.

the percentage of a stock's market value returned as dividends to stockholders.

Requirement 4. Use DuPont Analysis to compute rate of return on average total assets​ (ROA) for

20142014

through

20162016.

Begin by selecting the ROA formula using the DuPont analysis and then enter the amounts to calculate the ratio. ​(Enter percentages rounded to​ one-tenth percent,​ X.X%. Enter other component ratios as decimals to three​ places, .XXX.)

x

=

ROA

2014

%

x

=

%

2015

%

x

=

%

2016

%

x

=

%

Requirement 5. How does Accurate Shipping's return on net sales for 2016 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.

Accurate ​Shipping's rate of return on net sales for 2016 compares ▼( unfavorably, favorably) with the industry rate of​ 9%. It's 2016 rate of return on net sales has ▼ (improved,deteriorated) from 2015 and (improved,deteriorated) from 2014.

Requirement 6. Evaluate Accurate ​Shipping, Inc.'s ROA for 2016​, compared with previous years and against an​ 18% benchmark for the industry. Accurate Shipping's return on assets​ (ROA) for 2016 compares ▼ (unfavorably, favorably) with the​ 18% benchmark for the industry.​ It's 2016 ROA has ▼ (deteriorated, improved) from 2015 and ▼ (improved,deteriorated) from 2014.

Solutions

Expert Solution

Requirement 1

Particulars Trend Percentage
2016 2015 2014 2013 2012
Net Sales $ 1,000.00 327% $ 920.00 301% $ 492.00 161% $ 308.00 101% $ 306.00 100%
Net Income $        41.00 171% $    34.00 142% $    11.00 46% $    39.00 163% $    24.00 100%
Total Asset $     300.00 144% $ 266.00 128% $ 262.00 126% $ 230.00 111% $ 208.00 100%
Trend Percentage = Amount for the particular year / Amount for the year (2012)

Requirement 2

Rate of return on net sales

Particulars 2016 2015 2014
Net Sales $ 1,000.00 $ 920.00 $ 492.00
Net Income $        41.00 $    34.00 $    11.00
Rate of Return 4.10% 3.70% 2.24%
Rate of Return = Net Income / Net Sales

Return on sales measures the amount of net income for each dollar of net sales.

Requirement 3

Asset turnover

Particulars 2016 2015 2014
Net Sales $ 1,000.00 $ 920.00 $ 492.00
Opeing Assets balance $     266.00 $ 262.00 $ 230.00
Closing Assets Balance $     300.00 $ 266.00 $ 262.00
Average Assets $     283.00 $ 264.00 $ 246.00
Assets Turnover 3.53 3.48 2.00
Assets Turnover = Net Sales / Average Assets

Asset turnover means the amount of net sales per dollar invested in assets.

Requirement 4

DuPont Analysis to compute rate of return on asset

Particulars 2016 2015 2014
Return on Sales (A) in % 4.10 3.70 2.24
Asset Turn Over (B) in times 3.53 3.48 2.00
Return on Asset (A x B) in % 14.47 12.88 4.48 approx

Requirement 5

return on net sales for 2016 = 4.10%

return on net sales for 2015 = 3.70%

return on net sales for 2014 = 2.24%

It's 2016 rate of return on net sales has ▼ (improved) from 2015 and (improved) from 2014.

Accurate ​Shipping's rate of return on net sales for 2016 compares ▼( unfavorably) with the industry rate of​ 9%.

Requirement 6

Accurate Shipping's return on assets​ (ROA) for 2016 = 14.47%

Accurate Shipping's return on assets​ (ROA) for 2015 = 12.88%

Accurate Shipping's return on assets​ (ROA) for 2014 = 4.48%

It's 2016 ROA has ▼ ( improved) from 2015 and ▼ (improved) from 2014.

Accurate Shipping's return on assets​ (ROA) for 2016 compares ▼ (unfavorably) with the​ 18% benchmark for the industry.


Related Solutions

Meyer reported the following pretax financial income (loss) for the years 2012-2016 2012 $240,000 2013 200,000...
Meyer reported the following pretax financial income (loss) for the years 2012-2016 2012 $240,000 2013 200,000 2014 150,000 2015 (500,000) 2016 180,000 pretax financial income (loss) and taxable income (loss) were the same for all the years involved. The enacted tax rate was 34% for 2012 and 2013 and 38% for 2014-2016. Assume the carryback provision is used first for net operating losses. In 2015, based on the weight of available evidence, it is more likely than not that one-fifth...
Time series is given: Year 2012 2013 2014 2015 2016 2017 2018 2019 Amount 65 61...
Time series is given: Year 2012 2013 2014 2015 2016 2017 2018 2019 Amount 65 61 73 68 67 72 75 70 Calculate and interpret the characteristics of it; Make the time series next value forecast by using any method.
The base year is 2012. Real GDP in 2012 was? $15 trillion. The GDP price index...
The base year is 2012. Real GDP in 2012 was? $15 trillion. The GDP price index in 2015 was? 105, and real GDP in 2015 was? $16 trillion. ?? ?? Calculate nominal GDP in 2012 and in 2015 and the percentage increase in nominal GDP from 2012 to 2015. Nominal GDP in 2012 is ?$ _ trillion. And percentage increase in production 2012-2015 is _
Prepare the common-size balance sheet and common-base-year balance sheet for the company. Use 2013 as the...
Prepare the common-size balance sheet and common-base-year balance sheet for the company. Use 2013 as the base year. (Do not round intermediate calculations. Enter all common-size answers as a percent. Round your common-size answers to 2 decimal places (e.g., 32.16) and common-base-year answers to 4 decimal places (e.g., 32.1616).) JARROW CORPORATION 2013 Common-size 2014 Common-size Common-base year Assets   Current assets     Cash $8,964 % $10,904 %     Accounts receivable 22,353 % 24,837 %     Inventory 38,722 % 43,697 %         Total $70,039 % $79,438...
Econ 1 Price Index (E1PI) Item Quantity in Basket 2011 Price 2012 Price 2013 Price Cartoon...
Econ 1 Price Index (E1PI) Item Quantity in Basket 2011 Price 2012 Price 2013 Price Cartoon Book 1 $10 $12 $12 Blue Book 5 $0.25 $0.50 $1.00 Scantron 5 $0.10 $0.15 $0.25 Calculator 1 $4 $5 $6 The table above shows the market basket for an Econ 1 student. Use this data to calculate the E1PI Suppose the base year is 2011. What is the value of the price index in 2011? Suppose the base year is 2011. What is...
Table 9-10 Product Quantity (2013) Price (2013) Expenditure (2013) Price (2018) Expenditure (on base year quantities)...
Table 9-10 Product Quantity (2013) Price (2013) Expenditure (2013) Price (2018) Expenditure (on base year quantities) (2018) Computers 1 $1,200 $1,200 $900 $900 Books 10 25 250 30 300 Burgers 50    3 150      4 200     Total $1,600 $1,400 38) Refer to Table 9-10. Suppose an economy has only three goods and the typical family purchases the amounts given in the table above. If 2013 is the base year, then what is the CPI for 2018? A) 14.3...
Item 6 of the 10-K report provides comparative financial highlights of RMCF for the years 2012–2016....
Item 6 of the 10-K report provides comparative financial highlights of RMCF for the years 2012–2016. How would you describe the revenue trend for RMCF over this five-year period? Has RMCF been profitable (see net income) over this five-year period? Support your answer.
1. In 2012 the price index was calculated at 157.6 with 2009 as the base year....
1. In 2012 the price index was calculated at 157.6 with 2009 as the base year. In 2013 the price index increased to 168.3. What was the inflation from 2008-2009? A. 6.8% B. 6.4% C. 10.7% 2. In the fictional country of Alpha-land the economics statistics department has been busy calculating the price index for a basket of goods from 2013 to 2017. January 2013 is the standardized price index, at 100, for a basket of consumer goods in the...
Use the following table to answer the questions below. Country GDP in 2012 GDP in 2013...
Use the following table to answer the questions below. Country GDP in 2012 GDP in 2013 Population in 2013 United States 16,244,575 16,724,272 316,438,601 Mexico 1,177,398 1,327,021 118,818,228 United Kingdom 2,476,665 2,489,674 63,395,574 Kenya 40,697 45,311 44,037,656 Note that GDP numbers are presented in millions (add six zeros on to each of the reported numbers). 1. Calculate the GDP growth rate for each country between 2012 and 2013. Round to one decimal place. US: Mexico: UK: Kenya: 2. Calculate GDP...
Exercise 17-3 Computation and analysis of trend percents LO P1 2017 2016 2015 2014 2013 Sales...
Exercise 17-3 Computation and analysis of trend percents LO P1 2017 2016 2015 2014 2013 Sales $ 441,811 $ 292,590 $ 239,828 $ 168,300 $ 127,500 Cost of goods sold 232,292 153,697 128,061 89,366 66,300 Accounts receivable 21,339 17,146 16,428 9,829 8,708
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT