Do It Yourself Mutual Fund Analysis: HDFC Top 100 ( earlier Top 200) Fund

Published: September 8, 2013 at 2:23 pm

Last Updated on October 5, 2019

Analyzing the performance of a mutual fund is not rocket science.  Anybody can do it, just as anybody can select a mutual fund following a few simple rules.

I would like to prove my point with a do it yourself mutual fund analysis using HDFC Top 200 fund – one of the most popular mutual funds in India. Recently many investors have become disillusioned with the fund: “I thought Top 200 was the best fundand Prashant Jain was the best fund manager.  I am disappointed with its recent performance. My portfolio is in the red for months together”

One way or another, whether you are an individual investor or a financial advisor/planner, such a comment should be familiar enough to you.

My goal in this post is to analyse the performance of HDFC Top 200 fund over the last 5 years and find out how justified such sentiments are. The analysis will be done in two ways:

  • Using available resources online.  The goal is anybody, even a layman with a little inclination and minimal effort should be able to analyse the performance of the fund.
  • Using my Excel Rolling returns calculator.

Note:

  • A significant part of my portfolio is held in HDFC Top 200.  I have an ongoing SIP in it. So when I made the analysis, only one question was running through my mind: Should I stay invested in HDFC Top 200? Should I exit and invest elsewhere?

Method 1: Using available resources online.

Step 1:

(a) What kind of mutual fund is HDFC Top 200?

It is a diversified equity mutual fund investing in stocks that are part of the BSE 200.

The BSE 200 is a diversified  list of 200 stocks chosen from the BSE: predominantly large-cap stocks and mid-cap stocks. The health of the stocks and their growth potential is taken into account before they are included/excluded from the list.

Therefore, Top 200 can be part of ones core-equity portfolio.  Its performance may also be compared with the Sensex and Nifty indices.

(b) Why did I invest in HDFC Top 200?  Only you can answer this (my reasons are clear).  The nature of the goal and its time frame should be considered: Check out my step-by-step guide to goal-based investing

Step 2: Check out the Funds webpage

Let us face it, all AMCs present data in a confusing way.  Their goal is to ensure that the data published does not present the fund in a bad light.  HDFC is no different.

If you go to Top 200’s page, you will need to locate an obscure link titled ‘returns and benchmarks’ which will take you to the bottom of the same page! You will now need to click Please click here to view Scheme Performance Summary (Fund Manager-Wise)

 In the page that loads, you will have to click on Mr. Prashant Jain and see:

hdfc-top-200-mutual-fund-performance
Snapshot HDFC Top 200’s performance. Source: HDFC

From 28-06-2011 to 28-06-2013, the fund has severely underperformed when compared to its benchmark as well as Sensex.  However, from 28-06-2010 to 28-06-2013, the fund has beaten its benchmark comfortably but has performed just a little lower than Sensex.

Although this information is not very illuminating, considering the funds history (last entry in the table), the longer we stay invested in the fund, the higher is the expected outperformance (with respect to both BSE 200 and Sensex).

This vague inference can be confirmed by looking at Money Control’s Top 200 page

Step 3: Observe the plot comparing the scheme with its benchmark.  Screenshot of the 5-year period is shown below:

hdfc-top-200-money-control-5-year-performance
Plot of HDFC Top 200 NAV vs Benchmark (BSE 200) over a 5 year period (dated 8th Sep. 2013). Source: MoneyControl

The outperformance is clear. Even for a 3-year period the fund has managed to stay above the benchmark. If we have bothered to choose funds with a good record of accomplishment, we must give it space to perform – a period of at least 5 years.

Ignore the star rating (2-star FYI!) and most important, ignore this nonsense:

Moneycontrol mutual fund meter for HDFC Top 200 (dated 8th Sep. 2013)
Moneycontrol mutual fund meter for HDFC Top 200 (dated 8th Sep. 2013)

Step 4: Value Research Online’s Top 200 page

Let us look at two specific tables and ignore the rest:

Screen shot from Value Research Onlines HDFC Top 200 Page (dated 8th Sep. 2013)
Screen shot from Value Research Onlines HDFC Top 200 Page (dated 8th Sep. 2013)

The table on the left is part of VR Online’s front page (snapshot) while that on the right in part of the performance tab.

The trailing returns table for a most part paints a poor picture.  Investors should learn to ignore trailing returns.  They depend entirely on the date on which you choose to observe the returns.

An annual return, on the other hand, is between two fixed points and is far more reliable.  Notice that whenever the market rallies, Top 200 has given good returns.  Therefore, to benefit from this fund (or any other equity fund for that matter), we should periodically rebalance our portfolio after each market rally.  To learn more about the benefits of rebalancing, and how it reduces volatility in portfolio returns, you could use this tool.

Step 6: Morning Star India’s Top 200 Page

 Screenshot from Morning Star India's HDFC Top 200 page (dated 8th Sep. 2013)
Screenshot from Morning Star India’s HDFC Top 200 page (dated 8th Sep. 2013)

Do not worry too much about the graph (although it is quite reassuring!).  Observe the performance of the fund compared with large-cap category averages and judge for yourself.

Also look at the turnover ratio.  This is a measure of how much the fund managers has modified his/her portfolio.  During the 2008-2009 recession, the fund manager has churned the portfolio quite a bit.  As a result, the fund lost much less than other funds and recovered much more.

The turnover ratio in 2012 was quite low. This suggests that the manager believes in his stock picks and is waiting for the economy to turn around. Considering his past performance, I would like to trust him (of course he could be wrong).

 I think it is safe to say that HDFC Top 200 fund remains a compelling pick.  I am going to stay invested in it. We will need to watch what happens in the months after the election next year.

That is it.  This analysis would take no more than 10-15 minutes.  If I have money invested in this fund, should I not take the effort of spending this much time in analysing the funds performance? All it takes is a little bit of commonsense.

Do not ask a mutual fund agent or financial advisor if you should change your mutual fund without making such an analysis.  Many times fund changes are suggested just to pacify clients. Many financial advisors and agents are worried about losing clients if they advise them to stay invested in a fund that appears to be going through a bad phase. Analyse the funds performance yourself and make an informed choice.

Method 2: Using my rolling returns calculator

If you want additional evidence of the fund performance then you could use my rolling returns calculator

To use this, we need the NAV history and the benchmark index (BSE 200) data. I have chosen a period between 8th June 2009 to 5th Sep. 2013. In this period the market had recovered from the 2008 crash.

The benchmark history is available here.

The NAV history can be obtained from here

Update: Here is the automated version of the rolling returns calculator

 Download the Rolling Returns Calculator for HDFC  Top 200 Fund.

Here are the results. Please go ahead make your own conclusions. As far as I am concerned, these results do not change the above conclusions. I am going to stay invested.

Rolling Returns analysis for HDFC Top 200 Fund
Rolling Returns analysis for HDFC Top 200 Fund

Your Say: What do you think? Do you agree with the above analysis?

 

Do share if you found this useful

Did you know? We have more than 900+ videos on YouTube to explore! Join our YouTube Community!

Use our Robo-advisory Excel Template for a start-to-finish financial plan!

Join our courses in exclusive Facebook Groups!

  • 500+ members are now part of our new course, How to get people to pay for your skills! (watch 1st lecture for free). Learn how to get people to pay for your skills! Whether you are a professional or small business owner wanting more clients via online visibility or a salaried person wanting a side income or passive income, we will show how to achieve by showcasing your skills, building a community that trusts you and pays you!
  • 1822 members have signed for Goal-based portfolio management (watch 1st lecture for free). This is an online course to reduce fear, uncertainty and doubt while investing for a financial goal. Learn how to plan for your goals before and after retirement with confidence.

Want to check if the market is overvalued or undervalued? Use our market valuation tool (will work with any index!) or you buy the new Tactical Buy/Sell timing tool!
We publish mutual fund screeners and momentum, low volatility stock screeners on a monthly basis
About the Author Pattabiraman editor freefincalM. Pattabiraman(PhD) is the founder, managing editor and primary author of freefincal. He is an associate professor at the Indian Institute of Technology, Madras. since Aug 2006. Connect with him via Twitter or Linkedin Pattabiraman has co-authored two print-books, You can be rich too with goal-based investing (CNBC TV18) and Gamechanger and seven other free e-books on various topics of money management. He is a patron and co-founder of “Fee-only India” an organisation to promote unbiased, commission-free investment advice. He conducts free money management sessions for corporates and associations on the basis of money management. Previous engagements include World Bank, RBI, BHEL, Asian Paints, Cognizant, Madras Atomic Power Station, Honeywell, Tamil Nadu Investors Association, IIST Alumni Association. For speaking engagements write to pattu [at] freefincal [dot] com
About freefincal & its content policy Freefincal is a News Media Organization dedicated to providing original analysis, reports, reviews and insights on developments in mutual funds, stocks, investing, retirement and personal finance. We do so without conflict of interest and bias. Follow us on Google News Freefincal serves more than one million readers a year (2.5 million page views) with articles based only on factual information and detailed analysis by its authors. All statements made will be verified from credible and knowledgeable sources before publication. Freefincal does not publish any kind of paid articles, promotions or PR, satire or opinions without data. All opinions presented will only be inferences backed by verifiable, reproducible evidence/data. Contact information: letters {at} freefincal {dot} com (sponsored posts or paid collaborations will not be entertained)
Connect with us on social media
Our publications

You Can Be Rich Too with Goal-Based Investing

You can be rich too with goal based investingPublished by CNBC TV18, this 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 custom solutions for your lifestyle! 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 wantThis 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 young earner

Your Ultimate Guide to Travel

Travel-Training-Kit-Cover-new 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 Rs 199 (instant download)
Free android apps