2019 | 2018 | 2017 | 2016 | 2015 | ||||||
Sales | $ | 556,950 | $ | 368,841 | $ | 290,426 | $ | 200,294 | $ | 146,200 |
Cost of goods sold | 286,545 | 189,809 | 151,417 | 104,100 | 74,562 | |||||
Accounts receivable | 27,012 | 21,503 | 19,836 | 11,737 | 10,029 | |||||
Compute trend percents for the above accounts, using 2015 as the base year.
|
_________________________________________________________________
Express the following comparative income statements in
common-size percents.
Using the common-size percentages, which item is most responsible
for the decline in net income?
Express the following comparative income statements in common-size percents. (Round your percentage answers to 1 decimal place.)
|
Using the common-size percentages, which item is most responsible for the decline in net income?
Question 1
Solution
Trend Percent for Net Sales: | |||||
Analysis period Net Sales | / | Base year net sales | = | Trend Percent | |
2019 | $ 556,950.00 | $ 146,200.00 | 381% | ||
2018 | $ 368,841.00 | $ 146,200.00 | 252% | ||
2017 | $ 290,426.00 | $ 146,200.00 | 199% | ||
2016 | $ 200,294.00 | $ 146,200.00 | 137% | ||
Trend Percent for Cost of goods sold | |||||
Analysis period Net Sales | / | Base year net sales | = | Trend Percent | |
2019 | $ 286,545.00 | $ 74,562.00 | 384% | ||
2018 | $ 189,809.00 | $ 74,562.00 | 255% | ||
2017 | $ 151,417.00 | $ 74,562.00 | 203% | ||
2016 | $ 104,100.00 | $ 74,562.00 | 140% | ||
Trend Percent for Accounts receivable | |||||
Analysis period Net Sales | / | Base year net sales | = | Trend Percent | |
2019 | $ 27,012.00 | $ 10,029.00 | 269% | ||
2018 | $ 21,503.00 | $ 10,029.00 | 214% | ||
2017 | $ 19,836.00 | $ 10,029.00 | 198% | ||
2016 | $ 11,737.00 | $ 10,029.00 | 117% |
.
Question 2
Solution
GOMEZ CORPORATION | ||||
Comparative income statement | ||||
For the year ended December 31, 2017 and 2016 | ||||
Current year | Previous year | |||
$ | % | $ | % | |
Sales | $ 760,000 | 100.0% | $ 695,000 | 100.0% |
Cost of goods sold | $ 570,800 | 75.1% | $ 293,200 | 42.2% |
Gross profit | $ 189,200 | 24.9% | $ 401,800 | 57.8% |
Operating expense | $ 130,400 | 17.2% | $ 250,400 | 36.0% |
Net income | $ 58,800 | 7.7% | $ 151,400 | 21.8% |
Cost of goods sold is most responsible for decrease in net income.
2019 2018 2017 2016 2015 Sales $ 556,950 $ 368,841 $ 290,426 $ 200,294 $ 146,200...
Sales Cost of goods sold Accounts receivable 2019 2018 2017 2016 $ 620,481 $ 408, 211 $ 331,879 $ 225,768 $ 318,945 209,888 172,408 1 17,092 30,031 23,799 22,734 13,230 2015 163,600 83,436 11,190 Compute trend percents for the above accounts, using 2015 as the base year. Trend Percent for Net Sales: | Choose Denominator: Choose Numerator: Trend percent 2019: 2018: 2017: 2016: Trend Percent for Cost of Goods Sold: 1 Choose Denominator: Choose Numerator: 1 = Trend percent 2019:...
Sales Cost of goods sold Accounts receivable 2019 2018 2017 2016 2015 $ 382,751 $ 255,167 $ 210,014 $ 152,184 $ 111,900 197,703 131,885110,257 79,514 57,069 18,449 14,902 14,344 8,888 7,665 Compute trend percents for the above accounts, using 2015 as the base year. Choose Numerator: Trend Percent for Net Sales: 1 Choose Denominator: 1 Base year net sales Trend percent 2019: 2018: 2017: 2016: Choose Numerator: Trend Percent for Cost of Goods Sold: 1 Choose Denominator: / Base year...
Sales Cost of goods sold Accounts receivable 2019 2018 2017 2016 2015 $ 420,988 $ 278,800 $ 216,965 $ 150,670 $ 115,900 208, 784 138,312 109,663 74,928 56,791 20,292 16,282 14,884 7,951 8,844 Compute trend percents for the above accounts, using 2015 as the base year. Trend Percent for Net Sales: 1 Choose Denominator: Choose Numerator: Trend percent 2019: 2018: 2017: 2016: Trend Percent for Cost of Goods Sold: 1 Choose Denominator: Choose Numerator: Trend percent 2019: 2018: 2017: 2016:...
2019 Sales Cost of goods sold Accounts receivable 2018 2017 2016 2015 $ 615,911 $ 410,607 $ 327,177 $ 238,815 $ 176,900 310,506 206,854 166,689 129,558 88,450 29,933 23,979 22,346 13,923 12,065 Compute trend percents for the above accounts, using 2015 as the base year. Choose Numerator: Trend Percent for Net Sales: Choose Denominator: 2019: Trend percent % 2018: 1 % 2017: % 2016: = % Trend Percent for Cost of Goods Sold: Choose Denominator: Choose Numerator: Trend percent 2019:...
2019 2018 2017 2016 2015 Sales $517,562 342,756 274,205 202,365 149,900 142,895 18,756 Cost of goods sold Accounts receivable 76,449 10,298 266,407 25,050 176,506 20,051 104,806 11,818 Compute trend percents for the above accounts, using 2015 as the base year. Trend Percent for Net Sales: Choose Denominator: Choose Numerator: Trend percent 2019: % 2018: % 2017: % 2016: % Trend Percent for Cost of Goods Sold: /Choose Denominator: Choose Numerator: Trend percent 2019: 2018: % 2017 % 2016: % Trend...
2019 2018 2017 2016 2015 Sales $ 554,335 $ 359,958 $ 297,486 $ 208,032 $ 157,600 Cost of goods sold 285,211 185,379 155,118 107,246 80,376 Accounts receivable 26,830 21,094 20,348 12,191 10,796 Compute trend percents for the above accounts, using 2015 as the base year. Trend Percent for Net Sales: 1 Choose Denominator: Choose Numerator: Trend percent 2019: 2018: 2017: 2016: Trend Percent for Cost of Goods Sold: 1 Choose Denominator: Choose Numerator: Trend percent 2019: 2018: 2017: 2016: Trend...
Exercise 13-3 Computing and interpreting common-size percents LO P1 2017 2019 2018 2016 2015 608, 823 $ 392, 789 $ 316, 765 $ 231, 215 $ Sales 176, 500 90, 015 12, 090 201, 922 22, 978 Cost of goods sold 312, 950 29, 589 165, 000 21, 730 119, 370 13, 549 Accounts receivable Compute trend percents for the above accounts, using 2015 as the base year. Trend Percent for Net Sales: I Choose Denominator: Choose Numerator: Analysis period...
5 ezto.mheducation.com ework Saved Sales Cost of goods sold Accounts receivable 2019 2018 2017 2016 $ 282,880 $ 270,800 $ 252,600 $ 234,560 128,200 122,080 115,280 106,440 18,100 17,300 16,400 15,200 2015 150,000 67,000 9,000 Compute trend percents for the above accounts, using 2015 as the base year. Trend Percent for Net Sales: 1 Choose Denominator: Choose Numerator: 11 Trend percent 1 = 2019: 2018: % % 1 2017: 1 2016: = % Trend Percent for Cost of Goods Sold:...
Sarved Help Sav 2 Sales Cost of goods sold Accounts receivable 2019 2013 2017 2016 2015 $ 282,880 $ 270,800 $ 252,6ee $ 234,560 $ 150.800 128,269 122,080 115,280 106,440 67.000 18,100 17,300 16,400 15,200 9,000 Compute trend percents for the above accounts, using 2015 as the base year. Choose Numerator: Trend Percent for Net Sales Choose Denominator: 1 1 Trend percent % 2019: 2018: 2017: 2016: % % % Trend Percent for Cost of Goods Sold: 1 Choose Denominator:...
Sales Cost of goods sold Accounts receivable 2018 2017 2016 2015 2014 $ 458,634 $ 299,761 $ 233, 277 $ 170, 275 $ 122,500 231,917 151,481 119,889 87,088 61,250 22,244 17,476 15,933 9 ,944 8,379 Compute trend percents for the above accounts, using 2014 as the base year. (Round the percents to whole numbers.) Trend Percent for Net Sales: 1 Choose Denominator: Choose Numerator: Sales 2018: 2017: 2016: 2015: Trend Percent for Cost of Goods Sold: 1 Choose Denominator: Choose...