2015 2014 2012 2011 Sales Cost of goods sold Accounts receiv
2015 2014 2012 2011 Sales Cost of goods sold Accounts receivable 2013 S 643,340 S 417,753 S 328,939 S 224,532 S 170,100 330,603 214,854 171.159 116,511 86,751 4 31,138 24,439 22,532 13,113 11,889 Compute trend percents for the above accounts, using 2011 as the base year Trend Percent for Net Sales Choose Numerator: Sales 2014: Percent for Cost of Goods Sold: Choose Numerator: - Cost of goods sold 2014: Choose Numerator: 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 $643,340 / $170,100 = 378% 2014 $417,753 / $170,100 = 246% 2013 $328,939 / $170,100 = 193% 2012 $224,532 / $170,100 = 132% 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 $330,603 / $86,751 = 381% 2014 $214,854 / $86,751 = 248% 2013 $171,159 / $86,751 = 197% 2012 $116,511 / $86,751 = 134% Trend Percent for Accounts Receivables: Choose Numerator: / Choose Denominator: Analysis period accounts receivable / Base year accounts receivable = Accounts receivable 2015 $31,138 / $11,669 = 267% 2014 $24,439 / $11,669 = 209% 2013 $22,532 / $11,669 = 193% 2012 $13,113 / $11,669 = 112%