Price Index Formula

Price Index Formula (Table of Contents)

• Price Index Formula
• Examples of Price Index Formula (With Excel Template)
• Price Index Formula Calculator

Price Index Formula

A Price index, also known as price weighted indexed is an index in which the firms, which forms the part of the index, are weighted as per price according to a price per share associated with them.  Each stock will influence the price of the index as per its price.

Mathematically, Price Index Formula can be expressed as:

In other words, we can simply say that Price weighted index is arithmetic average of all the stock associated with the index. Due to arithmetic average formula, you can see that stocks which have higher prices will dominate and will have more influence on the index than stocks with lower prices. The much well-known stock market index is based on price index formula. Dow Jones and Nikkie 225, which are the two most famous stock indexes are few examples of price weighted indexes.

Examples of Price Index Formula (With Excel Template)

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

Price Index Formula – Example #1

Suppose that we have 5 stocks which form the part of the index:

Now to calculate Price weighted index, following steps needs to be followed:

First, calculate the sum of all the stocks

• Sum of all the stocks = $5 + $50 + $20 + $12 + $8
• Sum of all the stocks= $95

Then, find out the number of stocks

Number of stocks = 5

then, calculate the Price Index using the formula given below

Price Index = Sum of all the prices of Stocks which are part of Index / Number of Stocks in the Index

Finance for Non Finance Managers Training Course 7 Online Courses | 25+ Hours | Verifiable Certificates | Lifetime Validity Watch The Course Preview

• Price Index = $95 / 5
• Price Index= $19

Price Index Formula – Example #2

Let’s see some practical example and take some well know stocks from the market. Let’s take three popular stocks: Microsoft, Intel, and Apple:

Now to calculate Price weighted index, following steps needs to be followed:

First, calculate the sum of all the stocks

• Sum of all the stocks = $105.08 + $46.71 + $156.30
• Sum of all the stocks = $308.09

Then, find out the number of stocks

Number of stocks = 3

then, calculate the Price Index using the formula given below

Price Index = Sum of all the prices of Stocks which are part of Index / Number of Stocks in the Index

Price Index = $308.09 / 3

Price index = $102.70

Now, suppose that Apple unveil some big news today and due to which, a share price of Apple jumps by 15% to $179.75. Because of this, the price index will move to $110.51 (7.6% increase in an index)

Now if instead of Apple, Intel stock increase by 15% due to positive results, the stock price will move to $53.72 and the index will move to $105.03 (an increase of 2.28%)

So, if you see, 15% increase in higher price stock will move the index by 7.6% whereas the same % increase in lower price stock has less impact on the index price.

Explanation of Price Index Formula

Price index formula, as we have observed above, is really simple and easy to understand. Anyone, even with limited knowledge of finance can easily calculate the price weighted index. This simplicity is its major advantage. On the other hand, a disadvantage is that price weighted index will not be very effective in case of stock-split, spinoffs etc. In that case, we cannot simply take the divisor and divide the sum. We need to adjust the divisor accordingly. Let’s continue our above example and see:

Price Index Formula – Example #3

Assume that Microsoft split its stock in the ratio of 2 for 1. So accordingly the new price for Microsoft share will be $105.08 / 2 = $52.54.

When we initially calculated the price weighted index, the divisor was simply the number of shares i.e. 3. But in the event of a stock split, we cannot take that. To keep the price weighted index at the same level, we need to adjust the divisor and find the new one. New divisor will be:

A divisor is calculated using the formula given below

Divisor = Sum of stock price after the split / Old price weighted index

Divisor = ($52.54 + $46.71 + $156.30) / $102.69

Divisor = 2.488

So after the split, divisor will not 3 but 2.488

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

Relevance and Uses of Price Index Formula

Price weighted index straightforward way to calculate an index price. You just simply add all the stock prices and divide it by a number of shares and you are done. But in Price-weighted index method, stocks which have a higher price will have more influence on the price of the index. The index price will be biased towards heavy stock and its price will be close to those stocks. So big change in small prices will not move the index much which will give us misleading information.

Similarly, when a company goes for a stock split or spin-off, this method will not be as simple as it seems and it needs adjustments. This can become very messy if we have a large number of stocks in the index and we need lot of adjustments.

The fact that the experts in the finance industry and financial institutions choose S&P 500 as a benchmark instead of Dow Jones which is price weighted index shows that they do not have much confidence in price weighted method. This method although is simple and easy to understand, it does not have much practical relevance due to its limitations.

Price Index Formula Calculator

You can use the following Price Index Calculator.

Recommended Articles

This has been a guide to Price Index formula. Here we discuss How to Calculate Price Index along with practical examples. We also provide Price Index Calculator with downloadable excel template. You may also look at the following articles to learn more –

1. Formula for Revenue
2. Formula for Cost of Equity
3. Asset to Sales Ratio Formula
4. Examples of Net Income Formula