Nifty PE after all earnings have been declared

Dear Yogesh,

PFA EPS since Dec 2012.xlsx (165.1 KB), Nifty EPS and PE since Dec 2012 (which will have trailing 12 months since Mar 12 quarter). The big summary is that earnings have grown by 20% in close to 5 years, whereas valuations have grown faster at 70%.

The summary is as below

image

Notes:

  1. Sept 2014 Nifty weights weren’t available in the spreadsheet given by you, so I assumed it to be the same as June 2014.

  2. Consolidated statements have been used where-ever available in quarterly data, standalone used otherwise. This even if the firm has material business outside the standalone entity and provides consolidated results only annually (like RIL, M&M for example). I take care of it in the quarterly PE computation I share by looking at the non-statutory info they provide quarterly.

  3. The detailed working are in the sheets so feel free to come back for any clarifications.

Cheers,

14 Likes