WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » Relative Change

Relative Change

What is Relative Change?

Relative change shows the change of a value of an indicator in the first period and in percentage terms, i.e. Relative change is calculated by subtracting the value of the indicator in the first period from the value of the indicator in the second period which is then divided by the value of the indicator in the first period and the result is taken out in percentage terms.

The formula for relative change is very simple, and it is derived by initially deducting the initial value of the variable from the final value, then dividing the result by the initial value, and then finally multiplying by 100% to express in terms of percentage. Mathematically, it is represented as,

Relative Change = (Final value – Initial value) / Initial value * 100%

Relative-Change-Formula

Calculation of the Relative Change (Step by Step)

The formula for relative change can be derived by using the following steps:

  • Step 1: Firstly, determine the initial value of the variable. For instance, the revenue earned by a company in the previous year can be an example of an initial value of the revenue.
  • Step 2: Next, determine the final value of the variable. In the above example, the revenue earned in the following year can be regarded as the final value of the revenue.
  • Step 3: Next, deduct the initial value from the final value to derive the absolute change in the variable. In the example, the increase in revenue in the following year.
    • Absolute change = Final value – Initial value
  • Step 4: Finally, the formula for relative change is derived by dividing the absolute change in the variable by the initial value and then multiply by 100% to express the result in terms of the percentage change.
    • Relative change Formula = (Final value – Initial value) / Initial value * 100%

Examples

You can download this Relative Change Formula Excel Template here – Relative Change Formula Excel Template

Example #1

Let us take the example of a small business owner who wants to compare the current year’s revenue with the revenue generated in the previous year. In the current year, the business managed revenue of $53,250, while the revenue clocked last year was $51,000. Calculate the relative change in the revenue in the current year.

relative change formula example 1.1

Therefore, the % change in the revenue of the current year can be calculated using the above formula as,

relative change formula example 1.2

  • % Change = ($53,250 – $51,000) / $51,000 * 100%

relative change formula example 1.3

  • % Change= 4.41%

Therefore, the current year revenue grew by 4.41% as compared to the revenue generated last year.

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Example #2

Let us take the example of an apartment that was valued at $1,200,000 last month. Calculate the relative change in the valuation of the house if the valuation today has moved to $1,150,000.

relative change formula example 2.1

Therefore, the % change in the valuation today can be calculated using the above formula as,

relative change formula example 2.2

  • % change = ($1,150,000 – $1,200,000) / $1,200,000 * 100%

relative change formula example 2.3

  • % Change = -4.17%

Therefore, the valuation of the apartment today is 4.17% lower as compared to the last month’s valuation. [Negative value indicates de-growth]

Example #3

Let us take the example where a business owner has started a new product line. Now, because of the new product, the revenue has increased from $78,000 to $89,000, and the cost of sales has increased from $56,000 to $66,000. Determine whether the value addition for the business owner in terms of absolute change and relative change.

example 3.1

Absolute Change in Revenue

example 3.2

  • Absolute Change in Revenue = $89,000 – $78,000
  • = $11,000

Absolute Change in the Cost of Sales

example 3.3

  • Absolute change in the cost of sales = $66,000 – $56,000
  • = $10,000

Incremental Benefit in Absolute Terms

example 3.4

  • Incremental benefit in absolute terms = Absolute change in revenue – Absolute change in cost of sales
  • = $11,000 – $10,000
  • = $1,000

% Change in Revenue

example 3.5

  • % change in revenue = ($89,000 – $78,000) / $78,000 * 100%
  • = 14.10%

% Change in Cost of Sales

example 3.6

  • % change in cost of sales = ($66,000 – $56,000) / $56,000 * 100%
  • = 17.86%

Incremental Benefit in Relative Terms

example 3.7

  • Incremental benefit in relative terms = % change in revenue – % change in the cost of sales
  • = 14.10% – 17.86%
  • = -3.76%

Therefore, the business is making benefit in absolute terms ($1,000) but is losing in relative terms (-3.76%) because the relative change in the cost of sales is higher than that of revenue due to its lower base.

Relative Change Calculator

You can use this Relative Change Calculator.

Final Value
Initial Value
Relative Change Formula =
 

Relative Change Formula =
Final Value-Initial Value
X100
Initial Value
0-0
X100= 0
0

Relevance and Uses

The concept of relative change is important because, at times, it is impossible to compare the absolute changes in the value of two entities because of the scale or size, i.e., a small change in a large value can be greater than a significantly large change in a small value. For instance, 10% in 5000 is equal to 500 is higher than 75% of 200, which is equal to 150, although, in terms of % change, it is the other way round.

In such a scenario, the percentage change is very handy as it takes the problem of scale-out of the equation as it is a unitless value expressed either as a fraction or percentage. The relative change formula has applications in every field, such as financial metrics, scientific values, historical values, etc.

Recommended Articles

This has been a guide to Relative Change. Here we discuss how to calculate relative change using its formula along with examples, a calculator, and a downloadable excel template. You can learn more about statistical modeling from the following articles –

  • Incremental Revenue
  • Formula of Markup Percentage
  • Formula of Marginal Revenue
  • Exchange Rate Risk
  • Interest on Loan
0 Shares
Share
Tweet
Share
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
  • 250+ Courses
  • 40+ Projects
  • 1000+ 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 Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* 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
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

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

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

Login

Forgot Password?

WallStreetMojo

Download Relative Change Formula Excel Template

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