Simple how-to articles and free tools for financing your goals, managing your money, mutual fund and stock investments

Nifty Valuation Analysis with PE, PB, Div Yield, ROE, EPS of 21 NSE Indices

Use this Excel sheet to automatically determine the valuation of 21 NSE indices with long-term averages of PE, PB and Div Yield ratios along with ROE and rolling one-year EPS growth rate and dual moving averages. This is a major update to the Nifty PE Valuation Analysis spreadsheet where I have integrated Pranav Date’s NSE historical price and ratios downloader.

Before we look at the features of the sheet, two quick announcements:

  1. V Ramesh, CEO of MF Utility will be joining Ashal and me at the Pune Investor Meet on Feb 26th. You can register via here. Only a few seats left.
  2. My book with PV Subramanyam, You Can Be Rich Too With Goal Based Investing is now available at a massive 30% discount of Rs. 278/- from amazon.

Some Caveats

1: These charts are provided for information only. No investment suggestions are provided. I only use them sparingly for education and not for investments. Goal-based systematic investment continues regardless of current developments.

2: Research ( some mine, plenty from others) have shown that market timing has a high probability of reducing volatility, but may or may not enhance returns.

Buying “low” vs Buying “systematically”: Surprise, Surprise!

3: Markets crash for no rhyme or reason. They can ‘crash’ at any Nifty value or PE.

4: Long-term investors must understand the relevance of the Nifty PE for the long-term investor and misconceptions about the Nifty PEbefore worrying about the current value or PE.

5: History tells us that there is no particular advantage in exiting ‘hot’ markets and re-entering ‘cold’ ones (links below).

3) If you think the market is over-valued, take some money off the table, if you will but do so because you would like to reduce stress and rest easy and not because you would like to maximise returns.

4) Exit and enter as per the requirements of your goal and not because someone says so.

5) Nifty at 9000 or PE at 25 means little. One should use multiple metrics to evaluate the state of the market. This sheet offers only a few of them.

Features of the Nifty Analyser

The user can choose from one of these 21 indices and download historical price and valuation ratios: PE, PB and Dividend Yield.

Thanks to Pranav, a single click would fetch both the price index and PE,PB and Div Yield ratios. Users can change the moving average interval too.

Available indices

NIFTY NEXT 50: Evaluating the Nifty Next 50 as an Index Fund

Nifty Strategy Indices as Mutual Fund Benchmarks
NIFTY HIGH BETA 50: Nifty High Beta 50: an unsmart beta strategy
NIFTY LOW VOLATILITY 50: Nifty Low Volatility 50: A Benchmark Index to watch out for
NIFTY50 VALUE 20: Nifty50 Value 20 Index (NV20) as a mutual fund benchmark

After that, the user can study the price chart with dual moving average indicators.

Simple Moving Averages: 150 and 363 days

How to use (1): Moving Average Market Level Indicator

How to use (2): Nifty 200 DMA: Buying High vs Buying Low

Nifty PE Valuation Analysis:10Y average and standard deviation bands

How to use (1): Relevance of the Nifty PE for the long-term investor

How to use (2): Misconceptions about the Nifty PE

Nifty PE Valuation Analysis

Nifty PB Valuation with 10Y average and standard deviation bands

How to use: Is PB-based investing better than PE-based investing?

Div Yield with 10Y average and standard deviation bands

EPS one-year rolling growth rate

No sign of earnings yet!

Return on Equity or Book Yield

Heading south for the last 10Y!

Download the Nifty Valuation Analyser V3.0

Please join me in congratulating Pranav. Freefincal cannot grow without such support from friends, readers and DIY investing community.

Pune Investor Workshop (personal finance) Feb 26th, 2017

The second Pune workshop will be held on Feb 26th, 2017. You can register for this via this link

You Can Be Rich Too With Goal-Based Investing

Gift it to your Friends and Relatives whom you care more. Already follower of Pattu and Subra’s forum. Ordered 4 more copies to give gift to my friends and eagerly waiting to read

The best book ever on Financial Freedom Planning. Go get it now!

Your first investment should be buying this book

The (nine online) calculators are really awesome and will give you all possible insights

Thank you, readers, for your generous support and patronage.

Amazon Hardcover Rs. 278 30% OFF

Kindle at (Rs. 244.30)

Google Play Store (Rs. 244.30)

Infibeam Now just Rs. 307 use love10 to get additional 10% OFF.  

If you use a mobikwik wallet, and purchase via infibeam, you can get up to 100% cashback!!

  • Ask the right questions about money
  • get simple solutions
  • Define your goals clearly with worksheets
  • Calculate the correct asset allocation for each goal.
  • Find out how much insurance cover you need, and how much you need to invest with nine online calculator modules
  • Learn to choose mutual funds qualitatively and quantitatively.

More information is available here: A Beginner’s Guide To Make Your Money Dreams Come True!

What Readers Say

Also Available At

Bookadda Rs. 371. Flipkart Rs. 359 ($ 3.70 or Rs. 267)

Google Play Store (Rs. 244.30)

Subscribe and join the freefincal Youtube community!

 Don't like ads but want to support the site? Subscribe to the ad-free newsletter! 
You will get the full post-ad-free delivered to your inbox for Rs. 3000 a year. Follow this link to read the terms and sign up! 
Want to conduct a sales-free "basics of money management" session in your office?
I conduct free seminars to employees or societies. Only the very basics and getting-started steps are discussed (no scary math):For example: How to define financial goals, how to save tax with a clear goal in mind; How to use a credit card for maximum benefit; When to buy a house; How to start investing; where to invest; how to invest for and after retirement etc. depending on the audience. If you are interested, you can contact me: freefincal [at] Gmail [dot] com. I can do the talk via conferencing software, so there is no cost for your company. If you want me to travel, you need to cover my airfare (I live in Chennai)

Connect with us on social media

Do check out my books

You Can Be Rich Too with Goal-Based InvestingYou can be rich too with goal based investing

My first book is meant to help you ask the right questions, seek the right answers and since it comes with nine online calculators, you can also create customg solutions for your lifestye!Get it now.  It is also available in Kindle format.

Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You Want

Gamechanger: Forget Start-ups, Join Corporate and Still Live the Rich Life you want My second book is meant for young earners to get their basics right from day one! It will also help you travel to exotic places at low cost! Get it or gift it to a youngearner

The ultimate guide to travel by Pranav Surya

Travel-Training-Kit-Cover This is a deep dive analysis into vacation planning, finding cheap flights, budget accommodation, what to do when travelling, how travelling slowly is better financially and psychologically with links to the web pages and hand-holding at every step.  Get the pdf for ₹199 (instant download)

Create a "from start to finish" financial plan with this free robo advisory software template

Free Apps for your Android Phone

All calculators from our book, “You can be Rich Too” are now available on Google Play!
Install Financial Freedom App! (Google Play Store)
Install Freefincal Retirement Planner App! (Google Play Store)
Find out if you have enough to say "FU" to your employer (Google Play Store)

About Freefincal

Freefincal has open-source, comprehensive Excel spreadsheets, tools, analysis and unbiased, conflict of interest-free commentary on different aspects of personal finance and investing. If you find the content useful, please consider supporting us by (1) sharing our articles and (2) disabling ad-blockers for our site if you are using one. We do not accept sponsored posts, links or guest posts request from content writers and agencies.

Blog Comment Policy

Your thoughts are vital to the health of this blog and are the driving force behind the analysis and calculators that you see here. We welcome criticism and differing opinions. I will do my very best to respond to all comments asap. Please do not include hyperlinks or email ids in the comment body. Such comments will be moderated and I reserve the right to delete the entire comment or remove the links before approving them.
Updated: September 4, 2018 — 9:59 am
freefincal © 2019 Frontier Theme