Wikia

Wikianswers

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

How do you calculate growth percentage year over year?

Talk0
882,977questions on
Wikianswers

Redirected from How to calculate growth percentage year over year

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.

Around Wikia's network

Random Wiki