Question

Use the following selected information from Wheeler, LLC to determine the 2017 and 2016 trend percentages for net sales using 2016 as the base. 2017 2016 Net sales $ 285,200 $ 233,200 Cost of goods sold 150,100 131,390 Operating expenses 53,440 51,440 Net earnings 29,820 21,620

Answer 1

See below.

Step-by-step explanation:

Trend percentages for net sales can be calculated by comparing base year sales to the current year sales.

For 2016

Base year 2016 Sales = $233,200

Current year sales (2016) = $233,200

Trend percentage = 233,200 / 233,200 = 1.00 * 100% = 100%

For 2017

Base year 2016 Sales = $233,200

Current year sales (2017) = $285,200

Trend percentage = 285,200 / 233,200 = 1.22 * 100% = 122%

Using the same formula for trends we can calculate multiple percentages for analysis.

Hope that helps.