Top

How to Calculate SENSEX Earnings / EPS ?

June 25, 2008

Many have always wondered how to calculate the Earnings / EPS of Bombay Stock Exchange’s 30 stocks benchmark Index – the SENSEX. It is a very easy and the process is highlighted below.

The EPS of Sensex is the sum of all the individual companies EPSs considered on a pro-rata basis on the available floating stock of the company.

Lets analyze what does this mean, First, have the list of 30 companies which constitute the SENSEX in a spreadsheet. Or download the spreadsheet from BSEIndia.com. Now, all you need to do is get individual EPS of each company independently. This EPS must be taken on a pro-rata basis depending on the availability of the free float for calculating the BSE Sensex EPS. (i.e non-promoter holding, it is readily given by BSEIndia) Make another column in your spreadsheet and multiply the EPS the company reported by the Adjustment Factor.

For example, lets consider ACC. ACC reported an EPS of Rs 72.70 for FY-2008. The Adjustment Factor for ACC is 0.60, means 60% of ACCs stock is free floating stock [or non-promoter non-locked in stock] Multiplying 72.70 * 0.60 = Rs 43.62 is ACCs contribution to SENSEX EPS.

We are attaching the Spreadhseet for your ready reference which you can download and use it in every way you want to. Kindly feel free to post any questions you have in mind.

Comments

6 Responses to “How to Calculate SENSEX Earnings / EPS ?”

  1. ris on June 27th, 2008 8:14 PM

    The current excel sheet contains wrong data for free float. The method is correct but the free float data is wrong to calculate the sensex eps.

  2. Webmaster on June 27th, 2008 11:51 PM

    I have used the data provided by http://www.bseindia.com/downloads/about/INDICES.zip
    and hence it is should be error-free.

  3. rk on June 28th, 2008 12:40 PM

    using your data the PE comes to 15 .what is historical pe say for last 10 years

  4. Anonymous on June 28th, 2008 12:59 PM

    Can you please provide a similar spreadsheet for calculation of Nifty’s EPS?

  5. Anonymous on June 30th, 2008 10:45 AM

    RK,

    Here is historical forward P/E for SENSEX since 1990,

    http://www.dalalstreet.biz/2008/05/bse-sensex-1990-to-2008.html

  6. Arul Saxena on June 7th, 2010 3:36 PM

    I want to create my own nifty PE chart in my metastock . Please tell me how to get data . Regards-

Got something to say?






Bottom