Mutual Fund Performance Analysis: Consistency of returns

A method to analyse mutual fund performance during a particular investment duration in terms of consistency of returns is discussed in this post.

Many mutual fund investors are unable to rationally analyse the performance of their equity mutual fund holdings and often ask, When should I exit an equity mutual fund?. I would like to suggest simply ways in which mutual fund performance can be analyzed objectively. As always, there are multiple solutions to most problems in life, and what is suggested is one such solution. I suggest this, because this is what I would do.

When it comes to mutual fund performance analysis, the key point to remember is that a fund should be analyzed over the period in which we have held units and ONLY over the period in which we have held units.

The reason for this is quite simple. Mutual funds invest in securities that are marketed to market. That is the current value of a mutual fund portfolio is equal to the current market value. This current market value fluctuates quite a bit for equity and the rise, fall and amount of fluctuations crucially depend on the period chosen for study.

This is the key reason why you should ignore mutual fund star ratings.

The ratings agency assigns a star rating over a different period than your investment period. Therefore, their analysis will be entirely different from yours.

So unless you can do a peer comparison over your investment period, Star ratings are of no use.

If the investment duration is reasonably long (at least 3 plus years), one can consider using the Mutual Fund SIP XIRR Fluctuations Tracker Version 2.0. Here you can set the start of the SIP as your own and compare the XIRR of the SIP investment month after month with the benchmark. This gives you an idea of how well the fund has performed wrt to its benchmark for the period in which you invested. If this is reasonable (fund has bet the benchmark for most months), stay invested and do nothing.

If your goal is 15+ years away, I suggest not even looking at the investment performance for at least 4/5 years. After that one can review a bit more frequently.

A more powerful tool is the Mutual Fund SIP Rolling Returns Calculator. Here one can use the total returns indices (values need to updated manually from links provided) from BSE: Sensex, BSE 200 and BSE500 to compare the SIP returns for a given duration say, 5 years with the duration rolled over each business day. This would tell you, how consistently the fund has performed over every possible 5 year duration between any two dates. To learn more about how rolling returns are computed you can check out the corresponding calculator for lump sum returns: Multi-index Mutual Fund Rolling Returns Calculator.


Notice that for a 5-year SIP, the fund has reasonably manged to beat the total returns index after accounting for expenses. I don’t know about you, but as far as I am concerned, I am more than happy with that performance. So I continue to hold HDFC Equity (a two-star fund btw).

The point of this post is to to urge you to analyse your fund holdings for the period you have held that. That is likely to give you an entirely different, and in my opininon the most relevant, perspective about what you should do with your fund holdings.

There are many other ways of analyzing mutual fund performance. I have focussed on consistentcy of returns or rather the consistent of outperformance. Once can also consider downside protection with this tool: Mutual Fund Downside Protection Calculator

Do let me know what you think.

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 Investing

My first book is now available at a 35% discount for Rs. 258. It comes with nine online calculators. Get it now . The Kindle edition is only Rs. 199.

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

My second book is now only Rs 199 (Kindle Rs. 99) 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.