Answer:
Trend Percent for Net Sales :
2016 = 135.00 %
2017 =199.00%
2018 = 239.9 %
2019 = 364.7 %
Trend Percent for Cost of goods sold :
2016 = 136.7 %
2017 = 202.8 %
2018 = 241.9 %
2019 = 367.33 %
Trend Percent for Accounts receivable :
2016 = 114.9 %
2017 = 199.00 %
2018 = 203.9 %
2019 = 256.7 %
Explanation:
2019 2018 2017 2016 2015
Sales $656,856 $432,142 $358,624 $243,135 $180,100
Cost of goods sold 337,397 222,192 186,298 125,649 91,851 Accounts receivable 31,726 25,194 24,602 14,199 12,355
Trend Percent for Net Sales :
2016 Current Year Sales/ Base year Sales = $243,135 /$180,100
= 135.00 %
2017 Current Year Sales/ Base year Sales = $358,624 /$180,100 = 199.00%
2018 Current Year Sales/ Base year Sales =$432,142 / $180,100
= 239.9 %
2019 Current Year Sales/ Base year Sales = $656,856 /$180,100
= 364.7 %
Trend Percent for Cost of goods sold :
2016 Current Year CGS/ Base year CGS = $125,649 /91,851 = 136.7 %
2017 Current Year CGS/ Base year CGS = $ 186,298 /91,851 = 202.8 %
2018 Current Year CGS/ Base year CGS =$ 222,192/ 91,851 = 241.9 %
2019 Current Year CGS/ Base year CGS= $337,397 /91,851 = 367.33 %
Trend Percent for Accounts receivable :
2016 Current Year A/R/ Base year A/R = $14,199 /12,355 = 114.9 %
2017 Current Year A/R/ Base year A/R= $ 24,602 /12,355= 199.00 %
2018 Current Year A/R/ Base year A/R=$ 25,194 / 12,355 = 203.9 %
2019 Current Year A/R/ Base year A/R = $31,726 /12,355 = 256.7 %
