Question

2019 2018 2017 2016 2015 Sales $ 672,736 $ 439,697 $ 356,030 $ 248,972 $ 185,800 Cost of goods sold 352,273 230,192 188,636 130,765 96,616 Accounts receivable 32,426 25,722 24,388 14,540 12,746 Compute trend percents for the above accounts, using 2015 as the base year.

Answer 1

Answer:

                                      2019        2018     2017      2016     2015

Sales                              362           237      192         134        100

Cost of goods sold       365           238      195         135        100

Accounts receivable    254           202       191          114        100

Explanation:

Note: See the attached excel file for the table showing how the trend percents are calculated.

Trend percents, often known as index numbers, can be described as percents that are used for comparing financial data across time to a based year or period. This can be calculated using the following formula:

Trend percents = (Analysis year amount / Base year amount) * 100 ........ (1)

Using equation (1), the following table shows the trend percents computed as follows:

                                     2019         2018     2017      2016     2015

Sales                              362           237       192         134        100

Cost of goods sold       365           238       195         135        100

Accounts receivable     254           202       191          114        100

Download xlsx