xercise 133 Computation and analysis of trend percents LO P1

xercise 13-3 Computation and analysis of trend percents LO P1 2012 2011 2013 663,349 $439,304 $ 348,654 $250,830 $ 185,800 2015 2014 Sales Cost of goods sold Accounts receivable 340,858 225,645 180,914 129,623 94,758 32,239 25,743 23,848 14,648 12,746 Compute trend percents for the above accounts, using 2011 as the base year. Trend Percent for Net Sales: Choose Denominator: Choose Numerator Sales 2015 2014 2013 2012 Trend Percent for Cost of Goods Sold: Choose Numerator: Choose Denominator: Cost of goods sold 2015: 2014: 2013: 2012: Trend Percent for Accounts Receivables: Choose Numerator: Choose Denominator: Accounts receivable 2015 2014: 2013: 2012:

Solution

Trend Percent for Net Sales Choose Numerator / Choose Denominator Analysis period net sales / Base year net sales = Sales 2015 663,349 / 185,800 = 357% 2014 439,304 / 185,800 = 236% 2013 348,654 / 185,800 = 188% 2012 250,830 / 185,800 = 135% Trend percent for cost of goods sold Choose Numerator / Choose Denominator Analysis period cost of goods sold / Base year COGS = COGS 2015 340,858 / 94,758 = 360% 2014 225,645 / 94,758 = 238% 2013 180,914 / 94,758 = 191% 2012 129,623 / 94,758 = 137% Trend percent for Accounts receivable Choose Numerator / Choose Denominator Analysis period accounts receivable / Base year Accounts receivable = Accounts receivable 2015 32,239 / 12,746 = 253% 2014 25,743 / 12,746 = 202% 2013 23,848 / 12,746 = 187% 2012 14,648 / 12,746 = 115%