This is the April 2020 update for the State of Indian Stock Markets. This update includes the historical analysis (since 1999, i.e. about 20+ years) and Heat Maps for the key ratios like P/E, P/BV ratios and Dividend Yield for Nifty50 and Nifty500.
But first, here is how markets behaved this month. Nifty50 ended the month of April 2020 with a cut of +14.7%. This is one of the best monthly returns in the last 11 years. But it comes at the back of a horrible month of March which saw a cut of -23%. Read more here in March 2020: Unforgettable Month. To give a picture of monthly returns in past, here is the Nifty Monthly Returns Heatmap:
Since many people take the heatmaps on their face values alone, I want to highlight a few important things before we move forward:
- National Stock Exchange (NSE) publishes index level PE ratios based on standalone numbers and not the consolidated numbers. Does it matter? To an extent yes. It would be ideal to use consolidated numbers as many Nifty companies now have subsidiaries that have a significant impact on the overall earning numbers of these companies. And this has a much larger impact now than it had in previous years as many subsidiaries are now much larger than ever. And more importantly, this will matter more and more going forward. But NSE (as of now) continues to publish Nifty PE using its own set of criteria and decisions and for now, sticks with the standalone figures.
- So for now, we continue to use the officially published figures: which is index PE based on Standalone numbers. How different will the PE based on Consolidated figures be? It has to be arrived at using calculations as NSE doesn’t publish it. But by some estimates, it should be around 10-20% lower than the standalone PE. So if (let’s say) the standalone PE is 25, then the consolidated PE would be between 20-22.5. Or it’s more likely to be somewhere in between that range for now.
- So if consolidated PE is a better representative, then is the ratio analysis based on the standalone data still relevant? Yes, it still is. The trends still rhyme if not exactly. But as long as you know at the back of your mind that these are standalone figures and that the consolidated figures (PE ratio, etc.) are lower, you will know how to comprehend the data.
- At times, some sectors in index get far more weight than is prudent to give from diversification and concentration risk perspective. And its also possible that at the very same time, their earnings may be unexpectedly high or low. If and when this happens, the index level earnings will be impacted accordingly due to higher-than-necessary sector weight – which in turn may skew the PE data at that point of time.
- Similar to the point discussed above, it is also possible that at times, some (or few) individual index constituents might have high earning or market cap at an individual level(s) which might, to some extent, skew the PE data at the index level as well. The possibility of this happening is rare to low but still non-zero as the period under consideration in our analysis is long term here.
- The numbers shown in the analysis/tables in later sections are the averages of P/E, P/BV and Dividend Yield in each month (unless otherwise stated). Neither Nifty50 heat maps nor Nifty500 heat maps show the maximum or the minimum values for each month. So depending on how much the indices fluctuate within a month, the PE and other ratios will fluctuate accordingly too.
- Never make any investment decision based on just one or two ‘average’ indicators (here’s Why?) At most, treat these heat maps as broad indicators of market sentiments and a reference of market’s historical mood swings.
- I would want to additionally clarify something here (as I get a lot of queries for this). That the PE ratio is just one of the many factors in the overall, much broader model that I use to track markets, sentiments and comprehend equity things in general. I do not publish the full model publically as its kind of proprietary (I hope you understand). So don’t think that just because one indicator says markets are good to buy (or crash) then you should blindly go ahead and buy (or sell).
Sorry for so many points before coming to the actual data. But it was necessary so that people understand the assumptions, the actual basis of this analysis and how to use it in their investment decisions.
So without further ado, here are the Nifty 50 Heat Maps…
Historical P/E Ratios – Nifty 50 (Monthly Average)
As I said earlier, the above PE data is based on standalone figures. So if we were to estimate the PE based on consolidated data, then use 10-20% adjustment as an approximate. And if you are familiar with my PE Vs Return Analysis of 20+ years, you will agree that it is still not cheap from the historical standards. But it is also not as expensive as it would seem if you were to look just at the standalone PE figures.
But what about the recent past?
What if we looked at the movement of Nifty’s PE in the last 12 months? Here is a graph depicting the same:
Now, let’s have a more detailed look at how the last 12 months have panned out when it comes to Nifty movements and its implications on the PE ratio of Nifty.
I suggest you spend some time on the table below (which shows month-wise data cuts) to gauge its importance in highlighting the trends in the last 1 year:
Now with PE of Nifty50 analysed in various cuts, let’s move ahead to the analysis of P/BV and Dividend Yields of the Nifty50
Historical P/BV Ratios – Nifty 50
Historical Dividend Yield – Nifty 50
That was all about Nifty50 – the more popular bellwether index of India. But as you know, there are several other Indexes in India.
The State of Indian Markets section has also been updated with new Nifty heat maps (link).
And why should we be tracking these ratios? Because there are clear indications that market valuations have some relation to how much your expected returns are. Does it mean that these models have predictive power and can help you time the markets? I don’t know. I just present the data and what I see in it. But if it interests you (and I am sure you would want to know it), then do check the Detailed analysis of how much return you can expect depending on when the actual investments have been made (at various P/E, P/BV and Dividend Yield levels). You can read this super detailed analysis at Nifty P/E Ratio Vs Returns Analysis (Updated). I am sure you would like the insights.
Dear Sir you have done extremely good analysis which shows your passion for finance. I am new to investing can you pls advise if this is a good time to invest in mutual funds? i am 40 years old and have large lump sum cash to invest. Which are good funds to invest. Thank you
How about adding at table showing furture returns over the next 1, 3, 5, 7, 10 years when in the past PE was is the range as is current in your state indian markets post?
Hello , I wondering the value for April returns at 14.7%.. How did you arrive at this percentage ?
31-Mar-2020 Closing price –> 8597.75 & 30-Apr-20 Closing price is 9859.9 .. Returns is 12.80%.. Correct me If I am missing any values here..
I got the calculation right.. Don’t need to answer my Previous query ! Thanks anyway !!