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

Exercise 17-3 Computation and analysis of trend percents LO P1 2015 2014 2012 2011 Sales Cost of goods sold Accounts receivable 2013 S 732,157 $ 481,682 $ 388,453 $266,064 192,800 376,000 247,258 201,111 137,043 98,328 35,58328,178 26,531 15,591 13,168 Compute trend percents for the above accounts, using 2011 as the base year Trend Percent for Net Sales: Choose Numerator: Choose Denominator: Sales 2015 2014 2013 2012 Trend Percent for Cost of Goods Sold: Choose Numerator: Choose Denominator: Cost of goods sold 2015 2014 2013 2012 en unt ceivables Choose Numerator: Choose Denominator: Accounts receivable 2015 2014 2013 2012

Answer

Trend Percent for Net Sales:
Choose Numerator: / Choose Denominator:
Analysis period net sales / Base year net sales = Sales
2015: $                                    732,157 / $                              192,800 = 380%
2014: $                                    481,682 / $                              192,800 = 250%
2013: $                                    388,453 / $                              192,800 = 201%
2012: $                                    266,064 / $                              192,800 = 138%
Trend Percent for Cost of Goods Sold:
Choose Numerator: / Choose Denominator:
Analysis period cost of goods sold / Base year cost of goods sold = Cost of goods sold
2015: $                                    376,000 / $                                98,328 = 382%
2014: $                                    247,258 / $                                98,328 = 251%
2013: $                                    201,111 / $                                98,328 = 205%
2012: $                                    137,043 / $                                98,328 = 139%
Trend Percent for Accounts Receivables:
Choose Numerator: / Choose Denominator:
Analysis period accounts receivable / Base year accounts receivable = Accounts receivable
2015: $                                      35,583 / $                                13,168 = 270%
2014: $                                      28,178 / $                                13,168 = 214%
2013: $                                      26,531 / $                                13,168 = 201%
2012: $                                      15,591 / $                                13,168 = 118%

Leave a Comment