Welcome! Enter your question below. Please use words like "Who, What, Where, When, Why, How, etc..." in your question. Nothing to ask? Click here for a random, un-answered question.

How do you calculate growth percentage year over year?

1,050,975questions on
Add New Page
Talk0 Share

We'll use 1969 and 1970 as years 1 and 2 respectively. Also, say we're looking at Revenue growth or loss.

Example 1 Year 1 Revenue 1000 Year 2 Revenue 250

Step 1. 250 - 1000 = -750 Step 2. -750/1000 = - .75 Step 3. Convert to % = - 75% (Negative = LOSS %)

Example 2 Year 1 Revenue 150 Year 2 Revenue 500

Step 1. 500 - 150 = 350 Step 2. 350/150 = 2.33 Step 3. Convert to % = 233% (Positive = GROWTH %)

In Excel, let's say you have last year's sales numbers in cell A1 and this year's numbers in cell A2. In cell A3, you want to calculate the year over year percentage change.

The formula in cell A3 would look like this (Current - Previous)/Previous or =SUM(A2-A1)/A1. Instead of multiplying by 100 to get the percent, use the "Format cell" option to choose percentage. The number will automatically change to a percentage.

The problem with said calculation is when the first year or both years ended in negative values, say the company ran at a loss.

Example 3 Year 1 Revenue -500 Year 2 Revenue -200

You will end up with a negative % growth.

To counter this use the following formula in A3 =IF(A2>A1;ABS(A2/A1-1);-(A2/A1-1)). This formula will determine whether or not your second year is a larger or smaller amount and the calculate the correct percentage based on that information. In our examples case although the company is still running at a loss it showed a positive growth of 60%.

Ad blocker interference detected!

Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.