WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Percent Change in Excel

Percent Change in Excel

How to Calculate Percent Change in Excel?

To calculate the percent change in excel, we need at least two numbers from different time periods. Below is the formula to calculate the percent change in general.

Percent Change = (New Value – Old Value) / Old Value

OR

Percent Change = New Value / Old Value – 1

Percent Change in Excel

For example Company, ABC has achieved a revenue of USD 15 K in the previous week, and the current week revenue is USD 20 K; what is the percentage change in revenue when we compare to the previous week.

In this example, we have two numbers, i.e., Previous Week & Current Week. As per the formula, Old Value is Previous Week Number, and New Value is Current Week Number.

Percent Change = (New Value – Old Value) / Old Value

  • Percent Change = (20000 – 15000) / 15000
  • Percent Change = 5000 / 15000
  • Percent Change = 33.33%

The same calculation can be done by using excel simple formulas. Now we will see how to solve these problems in an excel worksheet.

Examples

You can download this Percent Change Excel Template here – Percent Change Excel Template

Example #1

Below is the revenue on year basis for the past 10 years.

Example 1

So, from this data, we need to find what the year on the year percentage change in revenue is. Copy the above data to a worksheet.

Here the first-year percentage change is nil because to compare that year number, we need the previous year number, so it is not available. From the second year onwards, we can calculate the percentage difference in excel.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Apply the basic excel formula as (New Value – Old Value) / Old Value.

Percent Change in Excel Example 1.1

This will calculate the % change in revenue between 2008 & 2009.

Example 1.2

So revenue has been decreased by -15.75% from 2008 to 2009.

Copy and paste the formula to the remaining cells to see the year on percent change.

Percent Change in Excel Example 1.3

Apply the below formatting to see the negative percentage in red color.

Example 1.4

We get the following result.

Percent Change in Excel Example 1.5

This is one way of finding percentage change year on year. Another way of finding the percentage change is between the base year (first year) and the remaining year.

For this, our formula Old Value remains the same for all the years. In this data Old Value is the year 2008.

 Example 1.6

Apply the above formula to all the remaining cells to see the percentage change between the first year and last year.

Percent Change in Excel Example 1.7.0

So from the first year to last year, revenue has been decreased by 20.98%. The only year revenue was increased is in the year 2016 by 10.08%, which is the highest.

Example 1.8

Example #2

We have seen how to calculate the percentage change between two values. Now we will see how to increase the number by a certain percentage.

Assume you are working as HR, and you have received a salary increment percentage after appraisal. You have a current salary, and also you are provided with what the percentage hike is given. Using this, you need to calculate a new salary.

Percent Change in Excel Example 2

This is a slightly different scenario from what we have seen in the above example. Here we need to increase the number by a certain percentage as given.

Below is the formula to increase the value by a certain percentage.

New Salary = Current Salary * (1 + Percentage Increase)

Apply the same logic for the below data as well.

 Example 2.1

We get the following result.

Percent Change in Excel Example 2.2

Apply the above same formula to all the cells to get the new salary value.

 Example 2.3.0

Let me explain to you how this formula works.

The first formula reads like this B2*(1+C2)

= 27323*(1+4.5%)

= 27323*(1.045)

= 28553

Things to Remember

  • Percentage change requires at least two numbers.
  • Percentage change could be positive as well as negative.
  • Always apply red color format for negative percentage change.

Recommended Articles

This has been a guide to Percent Change in Excel. Here we discuss how to calculate percent change using a formula in excel along with some examples and a downloadable excel template. You may learn more about excel from the following articles –

  • Calculate the Percentage Increase in Excel
  • Percentage Excel Formula
  • Percentile Excel Formula
  • Percent Error Excel Formula
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Percent Change Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More