Question

In: Accounting

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

Solutions

Expert Solution

formula :- Analysis year amount*100/base year amount

take 2013 as base year assume 100%

Particular 2013 2014 trend % 2015 trend % 2016 trend % 2017 trend %
sales 127500 168300

=168300*100/127500

=132%

239828

=239828*100/127500

=188.10%

292590

=292590*100/127500

=229.48%

441811

=441811*100/127500

=346.52%

Cost of Goods Sold 66300 89366

=89366*100/66300

=134.79%

128061

=12061*100/66300

=193.15%

153697

=153697*100/66300

=231.82%

232292

=232292*100/66300

=350.37%

account receivable 8708 9829

=9829*100/8708

=112.87%

16428

=16428*100/8708

=188.66%

17146

=17146*100/8708

=196.90%

21339

=21339*100/8708

=245.05%

trend percentage indicate changes take place in organiisation and highlight direction of changes.cost of good sold increase in higher rate than sales in all years. account receivable rate increase in lower rate in 2014, 2016 and 2017


Related Solutions

Problem 17-1A Calculation and analysis of trend percents LO A1, P1 Selected comparative financial statements of...
Problem 17-1A Calculation and analysis of trend percents LO A1, P1 Selected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended December 31, 2017–2011 ($ thousands) 2017 2016 2015 2014 2013 2012 2011 Sales $ 2,870 $ 2,514 $ 2,287 $ 2,096 $ 1,956 $ 1,819 $ 1,491 Cost of goods sold 2,063 1,678 1,444 1,264 1,174 1,098 875 Gross profit 807 836 843 832 782 721 616 Operating expenses 614 480 440 325...
Problem 17-1A Calculation and analysis of trend percents LO A1, P1 Selected comparative financial statements of...
Problem 17-1A Calculation and analysis of trend percents LO A1, P1 Selected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended December 31, 2017–2011 ($ thousands) 2017 2016 2015 2014 2013 2012 2011 Sales $ 1,679 $ 1,470 $ 1,338 $ 1,226 $ 1,144 $ 1,064 $ 872 Cost of goods sold 1,207 982 845 739 687 643 512 Gross profit 472 488 493 487 457 421 360 Operating expenses 359 281 257 190...
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.
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...
Required information Problem 17-2A Ratios, common-size statements, and trend percents LO P1, P2, P3 [The following...
Required information Problem 17-2A Ratios, common-size statements, and trend percents LO P1, P2, P3 [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow: KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2017, 2016, and 2015 2017 2016 2015 Sales $ 480,784 $ 368,320 $ 255,600 Cost of goods sold 289,432 230,568 163,584 Gross profit 191,352 137,752 92,016 Selling expenses 68,271 50,828 33,739 Administrative expenses 43,271 32,412 21,215 Total expenses 111,542...
Required information Problem 17-2A Ratios, common-size statements, and trend percents LO P1, P2, P3 [The following...
Required information Problem 17-2A Ratios, common-size statements, and trend percents LO P1, P2, P3 [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow: KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2017, 2016, and 2015 2017 2016 2015 Sales $ 449,371 $ 344,255 $ 238,900 Cost of goods sold 270,521 217,225 152,896 Gross profit 178,850 127,030 86,004 Selling expenses 63,811 47,507 31,535 Administrative expenses 40,443 30,294 19,829 Total expenses 104,254...
Required information Problem 17-2A Ratios, common-size statements, and trend percents LO P1, P2, P3 [The following...
Required information Problem 17-2A Ratios, common-size statements, and trend percents LO P1, P2, P3 [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow: KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2017, 2016, and 2015 2017 2016 2015 Sales $ 528,561 $ 404,921 $ 281,000 Cost of goods sold 318,194 253,481 179,840 Gross profit 210,367 151,440 101,160 Selling expenses 75,056 55,879 37,092 Administrative expenses 47,570 35,633 23,323 Total expenses 122,626...
Exercise 17-6 Common-size percents LO P2 Simon Company's year-end balance sheets At December 31 2017 2016...
Exercise 17-6 Common-size percents LO P2 Simon Company's year-end balance sheets At December 31 2017 2016 2015 Assets Cash $36,867 $42,664 $44,006 Accounts receivable, net 110,059 75,415 57,512 Merchandise inventory 131,660 102,646 63,119 Prepaid expenses 12,229 11,652 4,890 Plant assets, net 334,056 306,305 270,573 Total assets $624,871 $538,682 $440,100 Liabilities and Equity Accounts payable $157,149 $89,217 $59,255 Long-term notes payable secured by mortgages on plant assets 119,825 125,136 100,180 Common stock, $10 par value 163,500 163,500 163,500 Retained earnings 184,397...
Innovative Components, Inc. reported the following income statement data for 2013-2017.    2017 2016 2015 2014 2013...
Innovative Components, Inc. reported the following income statement data for 2013-2017.    2017 2016 2015 2014 2013 Net Sales $3,144.6 $2,993.1 $2,790.5 $2,654.0 $2,478.9 What would be an appropriate sales growth rate based on the historical data?
Years 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Retail Sales 5.2% 0.3%...
Years 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Retail Sales 5.2% 0.3% -3.3% 3.0% 4.9% 3.9% 3.1% 4.2% 3.8% 3.9% 3.6% e-commerce Sales 19% 4.1% 2.8% 17.1% 17.5% 14.9% 13.0% 14.6% 14.7% 14.0% 16.0% Does Retail Stores Growth Reduced by E-commerce Growth? Null Hypothesis: Ho: Retail stores growth doesn’t reduce by E-commerce growth. Alternative Hypothesis: Ha: Retail stores growth does reduce by E-commerce growth Do the chi-square test for goodness of fit. with the level of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT