Relative Change (Table of Contents)
What is Relative Change?
The term “relative change” refers to formula that calculates the absolute change in a variable expressed as a percentage of the initial value. 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,
Explanation of the Relative Change Formula
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 of Relative Change Formula
Let’s see some simple to advanced examples of Relative Change Formula to understand it better.
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.
Therefore, the % change in the revenue of the current year can be calculated using the above formula as,
- % Change = ($53,250 – $51,000) / $51,000 * 100%
- % Change= 4.41%
Therefore, the current year revenue grew by 4.41% as compared to the revenue generated last year.
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.
Therefore, the % change in the valuation today can be calculated using the above formula as,
- % change = ($1,150,000 – $1,200,000) / $1,200,000 * 100%
- % 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]
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.
Absolute Change in Revenue
- Absolute Change in Revenue = $89,000 – $78,000
- = $11,000
Absolute Change in the Cost of Sales
- Absolute change in the cost of sales = $66,000 – $56,000
- = $10,000
Incremental Benefit in Absolute Terms
- Incremental benefit in absolute terms = Absolute change in revenue – Absolute change in cost of sales
- = $11,000 – $10,000
- = $1,000
% Change in Revenue
- % change in revenue = ($89,000 – $78,000) / $78,000 * 100%
- = 14.10%
% Change in Cost of Sales
- % change in cost of sales = ($66,000 – $56,000) / $56,000 * 100%
- = 17.86%
Incremental Benefit in Relative Terms
- 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 its lower base.
Relative Change Calculator
You can use this Relative Change Calculator.
|Relative Change Formula =||
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 fraction or percentage. The relative change formula has application in every field, such financial metrics, scientific values, historical values, etc.
This has been a guide to Relative Change. Here we discuss how to calculate relative change using its formula along with examples, calculator and downloadable excel template. You can learn more about statistical modeling from the following articles –
- What is the Cost of Sales Formula?
- Definition of Markup
- What is Incremental Revenue?
- Formula of Markup Percentage
- Formula of Decrease Percentage
- Formula of Marginal Revenue
- 35+ Courses
- 120+ Hours of Videos
- Full Lifetime Access
- Certificate of Completion
- Basic Excel Training
- Advanced Excel Training
- Basic & Advanced VBA Course
- Excel Dashboard Course
- Data Analysis in Excel
- Create VBA Applications