Question

In: Accounting

2019 2018 2017 2016 2015 Sales $ 475,208 $ 306,586 $ 248,248 $ 171,798 $ 125,400...

2019 2018 2017 2016 2015
Sales $ 475,208 $ 306,586 $ 248,248 $ 171,798 $ 125,400
Cost of goods sold 244,756 158,059 130,106 89,117 63,954
Accounts receivable 23,095 17,966 16,955 9,999 8,577


Compute trend percents for the above accounts, using 2015 as the base year.

Solutions

Expert Solution

Solution

% are in one decimal place. Use below alternate answer for Trend percentage in 2 decimal place and zero decimal place.

Trend analysis
              2,015               2,016               2,017               2,018               2,019
Sales 100.0% 137.0% 198.0% 244.5% 379.0%
Cost of goods sold 100.0% 139.3% 203.4% 247.1% 382.7%
Accounts receivable 100.0% 116.6% 197.7% 209.5% 269.3%

.

Trend analysis
              2,015               2,016               2,017               2,018               2,019
Sales 100.00% 137.00% 197.96% 244.49% 378.95%
Cost of goods sold 100.00% 139.35% 203.44% 247.14% 382.71%
Accounts receivable 100.00% 116.58% 197.68% 209.47% 269.27%

.

Trend analysis
              2,015               2,016               2,017               2,018               2,019
Sales 100% 137% 198% 244% 379%
Cost of goods sold 100% 139% 203% 247% 383%
Accounts receivable 100% 117% 198% 209% 269%

Related Solutions

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.)
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.
2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Revenue 4,500 6,860 8,409 9,082...
2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Revenue 4,500 6,860 8,409 9,082 9,808 10,593 11,440 12,355 13,344 14,411 Revenue Growth 52.4% 22.6% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% 8.0% Production Costs Fixed Production Expense (excl depreciation) 575 575 587 598 610 622 635 648 660 674 Variable Production Costs 2,035 3,404 4,291 4,669 5,078 5,521 6,000 6,519 7,079 7,685 Depreciation 152 152 152 152 164 178 192 207 224 242 Total Production Costs 0 2,762 4,131...
2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026...
2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 BVPS, start of year 7 7.61 8.51 9.51 10.73 11.77 13.17 14.4 15.91 17.58 19.43 21.47 23.72 25.38 27.16 29.06 EPS 0.81 1.1 1.3 1.52 1.64 2 2.03 2.16 2.39 2.64 2.91 3.22 2.37 2.54 2.72 2.91 ROE 0.116 0.145 0.153 0.16 0.153 0.17 0.154 0.15 0.15 0.15 0.15 0.15 0.1 0.1 0.1 0.1 Payout Ratio 0.247 0.182 0.231 0.197 0.366 0.3 0.394 0.3...
2018 2017 2016 2015 2014 Average Sales A 4.22% 2.22% 2.40% 6.99% 3.96% B 6.53% 6.30%...
2018 2017 2016 2015 2014 Average Sales A 4.22% 2.22% 2.40% 6.99% 3.96% B 6.53% 6.30% 4.23% 11.91% 7.25% C -0.56% -0.34% 3.58% 9.17% 2.96% Gross Profit A 4.01% 3.26% 3.84% 5.77% 4.22% B 5.88% 8.71% 3.13% 11.18% 7.23% C 0.96% 0.97% 1.14% 8.75% 2.96% Net Income A -26.02% 45.85% 56.18% 1.17% 19.30% B -23.31% 78.39% 4.34% 9.36% 17.20% C -8.99% 0.76% -2.70% 5.69% -1.31% Total Assets A 2.67% 9.17% 1.48% 6.16% 4.87% B 2.89% 19.85% 11.54% 10.86% 11.29% C...
Suppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 2020...
Suppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 2020 Sales $1,450,000 $1,710,000 $1,600,000 $2,000,000 $1,850,000 What would be the forecast for next year’s sales using regression to estimate a trend?
Statement of Profit or Loss for years 2016 to 2019 Year 2019 Year 2018 Year 2017...
Statement of Profit or Loss for years 2016 to 2019 Year 2019 Year 2018 Year 2017 Year 2016 $ $ $ $ Sales revenue 1,095,910 1,060,900 1,030,000 1,000,000 Less: Cost of goods sold (895,358) (866,755) (842,540) (820,000) Gross profit 200,552 194,145 187,460 180,000 Other operating expenses (162,877) (161,827) (160,900) (160,000) Income before tax 37,675 32,318 26,560 20,000 Less: Income tax expense (3,768) (3,232) (2,656) (2,000) Net income 33,907 29,086 23,904 18,000 Required: Compute the index-number trend percentages for the accounts...
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...
This information is available for Pharoah Company for 2017, 2018, and 2019. 2017 2018 2019 Beginning...
This information is available for Pharoah Company for 2017, 2018, and 2019. 2017 2018 2019 Beginning inventory $ 103,000 $ 319,000 $ 414,500 Ending inventory 319,000 414,500 472,000 Cost of goods sold 892,000 1,120,500 1,306,000 Net sales 1,200,000 1,605,500 1,903,000 Calculate inventory turnover for Pharoah Company for 2017, 2018, and 2019. (Round answers to 2 decimal places, e.g. 1.52.) 2017 2018 2019 Inventory turnover Calculate days in inventory for Pharoah Company for 2017, 2018, and 2019. (Round answers to 1...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT