EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Finance Finance Resources Finance Formula Consumer Price Index Formula
 

Consumer Price Index Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated July 26, 2023

Consumer Price Index Formula

 

 

Consumer Price Index Formula (Table of Contents)
  • Formula
  • Examples
  • Calculator

What is the Consumer Price Index Formula?

The term “consumer price index” or CPI refers to the weighted average price of a basket that comprises of commonly used goods and services in any given year period vis-à-vis a base year.

Conversely, the consumer price index enables easy comparison of the price changes in the value of the market basket in any period relative to a base year. The formula for the consumer price index can be derived by dividing the value of the market basket in any given year by the value of the market basket in the base year and then multiply the result by 100. Mathematically, Consumer Price Index Formula is represented as,

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Consumer Price Index = (Value of Market Basket in the Given Year / Value of Market Basket in the Base Year) * 100

Examples of Consumer Price Index Formula (With Excel Template)

Let’s take an example to understand the calculation of the Consumer Price Index in a better manner.

You can download this Consumer Price Index Formula Excel Template here – Consumer Price Index Formula Excel Template

Consumer Price Index Formula– Example #1

Let us take the example in which the market basket is comprised of some of the most commonly used items – food, fuel, cloth, and education. As per the recent survey, average consumers spend 35% of their total annual consumption budget on food, 15% on fuel, 25% on clothes and 25% on education. Prepare the consumer price index for the year 2019 if the base year is 2015 and the consumer spending preference remains the same. The following information pertaining to prices are available.

Consumer Price Index Formula-1.1

Solution:

Value of Market Basket in the Base Year (2015) is Calculated as

Value of Market Basket for Base Year

  • Value of Market Basket in the Base Year (2015) = (35% * $45) + (15% * $40) + (25% * $50) + (25% * $35)
  • Value of Market Basket in the Base Year (2015) = $43

Value of Market Basket in the Given Year (2019) is Calculated as

Calculation of Value of Market Basket in the Given Year

  • Value of Market Basket in the Given Year (2019) = (35% * $50) + (15% * $41) + (25% * $60) + (25% * $40)
  • Value of Market Basket in the Given Year (2019) = $48.65

Consumer Price Index is calculated using the formula given below

Consumer Price Index = (Value of Market Basket in the Given Year / Value of Market Basket in the Base Year) * 100

Calculation of Consumer Price Index Formula

  • Consumer Price Index = ($48.65 / $43.00) * 100
  • Consumer Price Index = 113.14

Therefore, the Consumer Price Index for the year 2019 stood at 113.14, which means the average price increased by 13.14% during the last four years.

Consumer Price Index Formula– Example #2

Let us take another example where consumer spending is provided in terms of units consumed monthly. The market basket comprises the same four components – food, fuel, cloth, and education. Prepare the consumer price index for the year 2019 if the base year is 2018 and the following information pertaining to prices and consumption are available:

Consumer Price Index Formula-2.1

Solution:

Value of Market Basket in the Base Year (2018) is Calculated as

Calculation of Value of Market Basket in the Base Year

  • Value of Market Basket in the Base Year (2018) = (35 * $38) + (20 * $41) + (25 * $30) + (30 * $34)
  • Value of Market Basket in the Base Year (2018) = $3,920

Value of Market Basket in the Given Year (2019) is Calculated as

Consumer Price Index Formula-2.3

  • Value of Market Basket in the Given Year (2019) = (35 * $40) + (20 * $37) + (25 * $35) + (30 * $38)
  • Value of Market Basket in the Given Year (2019) = $4,155

Consumer Price Index is calculated using the formula given below

Consumer Price Index = (Value of Market Basket in the Given Year / Value of Market Basket in the Base Year) * 100

Consumer Price Index Formula-2.4

  • Consumer Price Index = ($4,155 / $3,920) * 100
  • Consumer Price Index = 105.99

Therefore, the Consumer Price Index for the year 2019 stood at 105.99, which means the average price increased by 5.99% during the last four years.

Explanation

The formula for the consumer price index can be calculated by using the following steps:

Step 1: Firstly, select the commonly used goods and services to be included in the market basket. The market basket is crated based on surveys, and it should be reflective of the day-to-day consumption expenses of the majority of consumers.

Step 2: Next, identify and fix the base year based on various social and economic factors.

Step 3: Next, determine the value of the market basket based on the weighted average price of the goods and services in the base year.

Step 4: Next, determine the value of the market basket based on the weighted average price of the goods and services in the given year.

Step 5: Finally, the formula for consumer price index can be calculated by dividing the value of the market basket in any given year (step 4) by the value of the market basket in the base year (step 3) and then multiply the result by 100 as shown below.

Consumer Price Index = (Value of Market Basket in the Given Year / Value of Market Basket in the Base Year) * 100

Relevance and Use of Consumer Price Index Formula

The concept of the consumer price index is very important because it is an economic indicator that is usually used as a measure of inflation in the economy or the purchasing power of the consumer. As such, the government and the policymakers use the changes in the consumer price index as a cue to make suitable economic decisions.

However, one of the biggest flaws in the consumer price index is its failure to include cheaper substitutes in the market basket. For instance, when the price of a certain good increase, there is a high possibility that the consumer will substitute the good with a cheaper option, but the consumer price index doesn’t include the cheaper good in its market basket and as such, the index fails to reflect the correct picture in this case.

Consumer Price Index Formula Calculator

You can use the following Consumer Price Index Formula Calculator

Value of Market Basket in the Given Year
Value of Market Basket in the Base Year
Consumer Price Index
 

Consumer Price Index =
Value of Market Basket in the Given Year
X100
Value of Market Basket in the Base Year
0
X100= 0
0

Recommended Articles

This is a guide to Consumer Price Index Formula. Here we discuss how to calculate the Consumer Price Index along with practical examples. We also provide a Consumer Price Index calculator with a downloadable excel template. You may also look at the following articles to learn more –

  1. Formula For Consumer Surplus
  2. How to Calculate the Delta Formula
  3. Examples of Interest Expense
  4. Calculation of Total Cost

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

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

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

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

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

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

EDUCBA

Download Consumer Price Index Formula Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

डाउनलोड Consumer Price Index Formula Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW