In: Accounting
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
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