Nifty PE after all earnings have been declared

40

Folks,

Attached is the Nifty trailing PE (weighted) for quarter ending June 2017 after results of all firms have been declared. Nifty PE Q1 FY18 for valupickr.xlsx (67.0 KB)

Notes:

  1. The Nifty trailing PE as of 14/08/2017 was 22.83 vs 22.69 as on 29/05/2017. Thus valuations have grown slightly more than earnings growth. About the same time last year the PE ratio was 20.09 which means valuations grew 13.6% faster than earnings.

  2. For the quarter ending June 2017 unweighted PAT grew by 60 basis points, but weighted PAT grew by 10%. This implies that high weighted stocks performed better (aka HDFC Bank, RIL) than low weighted stocks.

  3. For the trailing 12 months ending June 2017, weighted PAT grew 1.64% over trailing 12 months ending March 2017.

Feel free to ask any queries.

Warm regards,

P.S: I do not know how to get the digit separator comma to after 3 digits, instead of after 2 in Excel, which makes it a bit difficult to read numbers in millions. Would appreciate any help.

12 Likes