Wheeler, LLC: Exciting Net Sales Trend Analysis for 2017 and 2016!

How can we determine the trend percentages for net sales in 2017 and 2016 using 2016 as the base year? Answer: See below.

To calculate the trend percentages for net sales in 2017 and 2016 using 2016 as the base year, we need to compare the sales figures for each year to the base year 2016.

2016 Trend Percentage:

Base year 2016 Sales = $233,200

Current year sales (2016) = $233,200

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

2017 Trend Percentage:

Base year 2016 Sales = $233,200

Current year sales (2017) = $285,200

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

By using the same formula for trends, we can calculate multiple percentages for further analysis and insights into the company's net sales performance.

Isn't it exciting to see how Wheeler, LLC has increased its net sales by 22% in 2017 compared to the base year 2016?

← Using power query to shape data in excel workbooks How to calculate the value of a forward contract →

More Posts: