Question

2019 2018 2017 2016 2015 Sales $ 282,880 $ 270,800 $ 252,600 $ 234,560 $ 150,000 Cost of goods sold 128,200 122,080 115,280 106,440 67,000 Accounts receivable 18,100 17,300 16,400 15,200 9,000 Compute trend percents for the above accounts, using 2015 as the base year.

Answer 1

Sales

2019 Net Sales = 188.59%

2018 Net Sales = 180.53%

2017 Net Sales = 168.4%

2016 Net Sales = 156.37%

Cost of Goods Sold

2019Cost of Goods Sold = 191.34%

2018 Cost of Goods Sold = 182.21%

2017 Cost of Goods Sold = 172.06%

2016 Cost of Goods Sold = 158.87%

Accounts Receivable:

2019 Accounts Receivable = 201.11%

2018Accounts Receivable = 192.22%

2017Accounts Receivable = 182.22%

2016Accounts Receivable = 168.89%

Step-by-step explanation:

Computation forn trend percents for the above accounts, using 2015 as the base year:

FOR SALES:

2019:

Net Sales = Sales 2019 / Sales 2015*100

Net Sales = $282,880 / $150,000 * 100

Net Sales = 188.59%

2018:

Net Sales = Sales 2018 / Sales 2015*100

Net Sales = $270,800 / $150,000 * 100

Net Sales = 180.53%

2017:

Net Sales = Sales 2017 / Sales 2015*100

Net Sales = $252,600 / $150,000 * 100

Net Sales = 168.4%

2016:

Net Sales = Sales 2016 / Sales 2015*100

Net Sales = $234,560 / $150,000 * 100

Net Sales = 156.37%

COST OF GOODS SOLD:

2019:

Cost of Goods Sold = Cost of Goods Sold 2019 / Cost of Goods Sold 2015 *100

Cost of Goods Sold = $128,200 / $67,000 * 100

Cost of Goods Sold = 191.34%

2018:

Cost of Goods Sold = Cost of Goods Sold 2018 / Cost of Goods Sold 2015 *100

Cost of Goods Sold = $122,080 / $67,000 * 100

Cost of Goods Sold = 182.21%

2017:

Cost of Goods Sold = Cost of Goods Sold 2017 / Cost of Goods Sold 2015 *100

Cost of Goods Sold = $115,280 / $67,000 * 100

Cost of Goods Sold = 172.06%

2016:

Cost of Goods Sold = Cost of Goods Sold 2016 / Cost of Goods Sold 2015 *100

Cost of Goods Sold = $106,440 / $67,000 * 100

Cost of Goods Sold = 158.87%

ACCOUNTS RECEIVABLE:

2019:

Accounts Receivable = Accounts Receivable 2019 / Accounts Receivable 2015 * 100

Accounts Receivable = $18,100 / $9,000 * 100

Accounts Receivable = 201.11%

2018:

Accounts Receivable = Accounts Receivable 2018 / Accounts Receivable 2015 * 100

Accounts Receivable = $17,300 / $9,000 * 100

Accounts Receivable = 192.22%

2017:

Accounts Receivable = Accounts Receivable 2017 / Accounts Receivable 2015 * 100

Accounts Receivable = $16,400 / $9,000 * 100

Accounts Receivable = 182.22%

2016:

Accounts Receivable = Accounts Receivable 2016 / Accounts Receivable 2015 * 100

Accounts Receivable = $15,200 / $9,000 * 100

Accounts Receivable = 168.89%