# Read This to Know How to Calculate Percentage Increase Perfectly

Whether it is your saved finances or the population of your city or town; whether it is your mutual fund investment or just your son's math sum; whatever the case, you need to know about calculating percentage increases. While you may know that your money has grown in a specific period, you will only know by exactly how much, after calculating the increase in percentage.

Sayali Bedekar Patil

Last Updated: Feb 28, 2018

The dictionary meaning of the term 'percentage' is '

**a proportion in relation to a whole**'. While it is hardly a good comparison to compare a chit fund that gives USD 100 for every $10 of monthly investment at the end of a 3 month period, with a savings account that yields USD 106 for a USD 100 saving, it is much easier to compare incomparable investments with respect to percentages. For example, if one investment yields 10% annually and one gives out 8 percent annually, you will always go for the former. Percentages make it easier to make comparisons between two numbers or figures that are different to each other in terms of initial investment laid down, the duration of the investment, so on and so forth. In simple terms, a simple percentage of a simple, uncomplicated investment gives nothing but its simple 'return on investment' number. By comparing two of these single numbers, it is easy to reach a decision on which one grows more and is hence more profitable. While percentage calculations are necessary in almost every field, we will take it from a simple investment perspective henceforth in the following article.

How to Calculate Percentage Increase

Calculating percentage increase is actually nothing but to calculate percentage increase between two numbers - one is the input figure or investment at the beginning, and the other is the output figure or the amount at the end of the investment duration. The formula given below is a simple one that can be used to calculate percentage increase or decrease, or even difference. To calculate the percentage increase in an 'x' amount of investment that yields 'y' amount after 1 year, the formula is as follows.

In figures if your initial investment was $100 and you earned $110 at the end of the year, your annual percentage was [(110-100) / 100] * 100 i.e 10%. In other words, the formula can also be written down as:

This was just a very basic example, for actual investments, there are many different formulas, to factor in variables like period of investment, frequency of compounding, etc. Now let us turn to calculate percentage increase year after year.

**[(y - x) / x] * 100**In figures if your initial investment was $100 and you earned $110 at the end of the year, your annual percentage was [(110-100) / 100] * 100 i.e 10%. In other words, the formula can also be written down as:

**[(Increased Amount - Original Amount) / Original Amount] * 100**This was just a very basic example, for actual investments, there are many different formulas, to factor in variables like period of investment, frequency of compounding, etc. Now let us turn to calculate percentage increase year after year.

Calculating Percentage Increase/Decrease from Year to Year

Calculating year to year percentage change between two figures, let's say prices, helps you figure out the ongoing inflation or deflation in the economy. If you compare these year on year percentage figures with the percentage figures of your investment yield, you should be able to gauge if the investment has actually grown over and above the inflation or has lagged back and eroded due to it. As long as you use the right figures and you plug them into the basic formula, which is given below, you should have the economic year on year values that you require.

Let's try to understand this formula with the help of an example:

In 2010, you spent $500 on your car maintenance and in 2011, you spent $550 for the same purpose, so how much more you spent in 2011 in percentage?

Step a: 550 - 500 = 50

Step b: 50 / 500 = 0.1

Step c: 0.1 * 100 = 10

So, you spent 10% more on your car maintenance in 2011.

**[(Newer Year's Value - Older Year's Value) / Older Year's Value] * 100**Let's try to understand this formula with the help of an example:

In 2010, you spent $500 on your car maintenance and in 2011, you spent $550 for the same purpose, so how much more you spent in 2011 in percentage?

Step a: 550 - 500 = 50

Step b: 50 / 500 = 0.1

Step c: 0.1 * 100 = 10

So, you spent 10% more on your car maintenance in 2011.

How to Calculate Percentage Increase in Excel

If your figures of values are listed in the B2 and B3 cells of an excel worksheet, you can calculate the percentage increase by plugging in the following formula into the cell that you want the percentage value in. For example, if you want the value in cell C3, just take your mouse there and click on it. Then, in the input line, plug in the formula given below.

**=((B3-B2)/B2)*100**Here is another formula to calculate percentage decrease in Excel:

**=((B2-B3)/B2)*100**

**=((B2-C2)/B2)*100**

**=(B2-$A2)/$A2,**no matter that the formula was copied over the entire row, the excel calculator will always use the numbers on column A as the comparison base.

Here is one more example to calculate percentage change. Use the following formula to calculate percentage change of following years to a specific one year.

**=((B3-$B$2)/$B$2)*100**