225k views
3 votes
20192018201720162015 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 Compute trend percents for the above accounts, using 2015 as the base year.\

User Mode
by
5.1k points

1 Answer

3 votes

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 %

Step-by-step 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 %

User Delphifirst
by
5.2k points