Question

In: Accounting

Given 2016 2015 2014 Days Inventory (365 x Average inventory / Cost of sales) 83 82...

Given 2016 2015 2014 Days Inventory (365 x Average inventory / Cost of sales) 83 82 75 Sales/Store ($ million) 14.0 13.9 13.5 = Transactions/Store (Thousands) 466.5 459.9 446.3 x Sales/Transactions ($) 30.01 30.22 30.25 Sales/Store ($ million) 14.0 13.9 13.5 = Square feet/Store (Thousands) 80.0 77.4 73.7 x Sales/Square foot ($) 175.0 179.59 183.18 Given (Thousands) 2016 2015 2014 2013 Sales 700,000 432,800 256,200 117,600 Gross profit 181,400 114,300 70,000 33,400 Net income 8,200 14,100 10,300 5,300 Working capital 106,500 100,100 49,300 12,900 Total assets 380,200 249,400 105,200 33,000 Long-term debt 200,000 118,000 4,400 200 Stockholders’ equity 89,100 80,200 65,300 18,400 I. From the above information, compute the following for the calendar years 2016, 2015 and 2014. A. Return on average equity (%) B. Asset turnover (Net Sales/Average Assets) C. Return on net sales (%) II. Based on the above information, explain the following: A. Why are net sales increasing? B. Is the Company operating more or less efficiently (profitably)? Explain your answer. C. Is the Company operating more or less effectively (productively)? Explain your answer.

Solutions

Expert Solution

Answer:-

RETURN ON AVERAGE EQUITY

2016

Average Equity = ($89,100+$80,200)/2 Average Equity = $84,650

Return on Average Equity = Net Income / Average Equity Return on Average Equity = $8,200 / $84,650 Return on Average Equity = 9.69%

2015:

Average Equity = ($80,200+$65,300)/2 Average Equity = $72,750

Return on Average Equity = Net Income / Average Equity Return on Average Equity = $14,100 / $72,750 Return on Average Equity = 19.38%

2014:

Average Equity = ($65,300=$18,400)/2 Average Equity = $41,850

Return on Average Equity = Net Income / Average Equity Return on Average Equty = $10,300 / $41,850 Return on Average Equity = 24.61%

ASSETS TURNOVER:

2016:

Average Assets = ($380,200+$249,400)/2 Average Assets = $314,800

Assets Turnover = Net Sales / Average Assets Assets Turnover = $700,000 / $314,800 Assets Turnover = 2.22

2015:

Average Assets = ($249,400+$15,200)/2 Average Assets = $177,300

Assets Turnover = Net Sales / Average Assets Assets Turnover = $432,800 / $177,300 Assets Turnover = 2.44

2014:

Average Assets = ($105,200+33,000)/2 Average Assets = $69,100

Assets Turnover = Net Sales / Average Assets Assets Turnover = $256,200 / $69,100 Assets Turnover = 3.71

RETURN ON NET SALES:

2016:

Return on Net Sales = Net Income / Net Sales Return on Net Sales = $8,200 / $700,000 Return on Net Sales = 1.17%

2015:

Return on Net Sales = $14,100 / $432,800 Return on Net Sales = 3.26%

2014:

Return on Net Sales = $10,300 / $256,200 Return on Net Sales = 4.02%

  


Related Solutions

How can I respond to this discussion? Days sales = 365/ Inventory Turnover Industry: 365/2.69= 135.69,...
How can I respond to this discussion? Days sales = 365/ Inventory Turnover Industry: 365/2.69= 135.69, so days sales for industry is 135.69. Company: 365/15.82= 23.07, so days sales for company is 23.07. Taking into consideration that a company with a quick ratio greater 1, has a liquidity that allows for meeting short-term obligations. This company has a quick ratio of .91. The reasons for this could be a number of things, from delayed collections of accounts receivable to decreasing...
1. Calculate days’ sales in inventory given the following information: inventory = $2500; cost of goods...
1. Calculate days’ sales in inventory given the following information: inventory = $2500; cost of goods sold = $95,000. a. 8.62 days b. 9.61 days c. 12.93 days d.10.39 days e. 11.28 days
A firm has days' sales in an inventory of 105 days, an average collection period of...
A firm has days' sales in an inventory of 105 days, an average collection period of 35 days, and takes 42 days, on average, to pay its accounts payable. Taken together, what do these three figures imply about the firm's operations and its cash flows?
Financial Ratio Worksheet 2014 2015 2016 2017 2018 Days Receivable 75.47 80.31 63.69 78.74 76.59 Days...
Financial Ratio Worksheet 2014 2015 2016 2017 2018 Days Receivable 75.47 80.31 63.69 78.74 76.59 Days Inventory 17.42 21.58 184.32 41.88 41.43 Days Payable 45.19 57.23 618.53 109.84 103.13 Sales Growth -5.47% -5.47% -3.81% -42.40% 6.86% Costs of Goods Sold 71.63% 71.33% 7.00% 69.89% 69.88% Sales & General Administrative to sales 15.81% 15.40% 15.60% 17.53% 16.03% Operating Profit to Sales 6.92% 7.15% 2.11% 6.31% 3.35% Current Ratio 1.11 1.41 1.28 1.13 1.00 Debt Ratio 0.77 1.42 1.53 1.62 1.61 Sales...
Pepsi 2013 2014 2015 2016 2017 Sales/Revenue 66.42B 66.68B 63.05B 62.8B 63.53B Coca-Cola 2013 2014 2015...
Pepsi 2013 2014 2015 2016 2017 Sales/Revenue 66.42B 66.68B 63.05B 62.8B 63.53B Coca-Cola 2013 2014 2015 2016 2017 Sales/Revenue 46.76B 46B 43.7B 41.38B 35.02B Using the year 2013-2017 financial data of Coca-Cola and PepsiCo companies, determine their 5-year average growth rates related to net sales and income from continuing operations. Coca Cola: Net Sales: 7.86% Increase. PepsiCo: Net Sales: 3.11% Increase. And what data to use to calculate.
2018 2017 2016 2015 2014 Sales $ 80,000 $ 73,000 $ 61,000 $ 57,000 $ 50,000...
2018 2017 2016 2015 2014 Sales $ 80,000 $ 73,000 $ 61,000 $ 57,000 $ 50,000 Cost of goods sold 72,600 53,400 45,600 33,300 30,000 Dollar amounts stated above are in thousands. a. Compute trend percentages for the above items taken from the financial statements of Lopez Plumbing over a five-year period. Treat 2014 as the base year. b. State whether the trends are favorable or unfavorable. Required A Required B Compute trend percentages for the above items taken from...
2018 2017 2016 2015 2014 Sales $ 672,729 $ 434,019 $ 347,215 $ 242,808 $ 181,200...
2018 2017 2016 2015 2014 Sales $ 672,729 $ 434,019 $ 347,215 $ 242,808 $ 181,200 Cost of goods sold 332,087 214,419 173,535 120,176 88,788 Accounts receivable 32,560 25,434 23,715 14,180 12,376 Compute trend percents for the above accounts, using 2014 as the base year. (Round the percents to whole numbers.)
2017 2016 2015 2014 2013 Sales $ 699,332 $ 466,221 $ 368,554 $ 252,434 $ 189,800...
2017 2016 2015 2014 2013 Sales $ 699,332 $ 466,221 $ 368,554 $ 252,434 $ 189,800 Cost of goods sold 352,166 234,761 187,327 128,167 94,900 Accounts receivable 33,918 27,227 25,283 14,767 13,001 Compute trend percents for the above accounts, using 2013 as the base year. Trend Percent for Net Sales: Choose Numerator: / Choose Denominator: / = Sales 2017: / = % 2016: / = % 2015: / = % 2014: / = % Trend Percent for Cost of Goods...
1)Calculate GMROI and inventory turnover given annual sales of $20,000, average inventory (at cost) of $4,000...
1)Calculate GMROI and inventory turnover given annual sales of $20,000, average inventory (at cost) of $4,000 and a gross margin of 45%. (1point) 2)Using the following information, calculate additions to stock: (1 point) Sales $26,000 EOM stock $100,000 BOM stock $88,000 3)Using the following information, calculate the average BOM stock-to-sales ratio for a six-month merchandise budget plan: ( 2 points).                 GMROI                 130%                 Gross Margin     46% 4)Today is July 19. Buyers at two different stores are attempting to assess...
2014 2015 Sales $200,000 $150,000 Beginning inventory (a)______ (e)_______ Purchases, net 40,000 40,000 Ending inventory 25,000...
2014 2015 Sales $200,000 $150,000 Beginning inventory (a)______ (e)_______ Purchases, net 40,000 40,000 Ending inventory 25,000 5,000 Cost of goods sold (b)______ 60,000 Gross profit 65,000 (f)______ Operating expenses (c)______ (g)_______ Income before taxes (d)______ 40,000 Income tax expense (30%) 14,100 (h)_______ Net income (loss) 32,900 (i)________ Can you add your work for each missing blank please! Required: Fill in the blanks for the missing data.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT