Mutual Fund Analyzer: Fund A vs. Fund B

Ever wondered which to choose between Franklin Blue Chip and ICICI Blue Chip? Between HDFC Balanced and ICICI Balanced? Here is a mutual fund analyzer that goes beyond mere return comparison. It can be used each time you wish to make a choice or to compare how your fund did relative a 'hot fund' everyone is talking about!

Personally, I do not engage in such comparison and do not recommend them. However, many investors do want to do such a comparison. Therefore, I felt it is better to modify the Mutual Fund Risk and Return Analyzer and compare two funds, call them Fund A  and Fund B on a risk-adjusted basis.

Sometimes a holistic view of risk and reward could investors that their holdings and choices are not so bad after all (compared to that 'hot fund'!).

I had recently used this tool to compare Tata Balanced Fund vs. HDFC Balanced Fund. The tool was first published in Aug 2012. I have now modified the sheet to extend calculations up to 10 years.

Here is a comparison between Franklin Blue Chip and ICICI Blue Chip to illustrate the features.

The input sheet. Fund A = Franklin Blue Chip and Fund B = ICICI Focussed Blue Chip
The results page listing SIP and lump sum returns
Returns plot. Notice Franklin has done well recently
The risk-return score which uses a total of 20 metrics (2 of them SIP and lump sum returns) to gauge funds on risk-adjusted basis. A score of higher than 50% means fund A has done better.
Upside and downside capture analysis. If upside capture >100% fund A has beat fund B when fund B returns were positive. If downside capture <100% then fund A has beat fund B when fund B returns were negative.

Read more: Simplify Mutual Fund Analysis with Upside/Downside Capture Ratios

NAV movement in the last two years with Ulcer index. Higher ulcer index is more stress to investors!

Read more: Mutual Fund Analysis With the Ulcer Index

Latest version: Download the Fund A vs Fund B analyser (May 2016)

Fund A vs. fund B risk-return analyser (old version) (aug 2014)

Register for the New Delhi DIY Investor meet:  April 23rd 2017

Get free, yet comprehensive calculators, tools and analysis delivered to your mailbox! Subscribe to get posts via email

Your subscription is successful if you are directed to the "Welcome Page"

Install Financial Freedom App! (Google Play Store)

Install Freefincal Retirement Planner App! (Google Play Store)


Buy our New Book!

You Can Be Rich With Goal-based Investing A book by  P V Subramanyam ( & M Pattabiraman. Read more about the book and pre-order now!
Practical advice + calculators for you to develop personalised investment solutions

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.

25 thoughts on “Mutual Fund Analyzer: Fund A vs. Fund B

  1. Vinay Maithani Cmrp

    Pattabiraman Murari This articles and your entire blog celebrates the marriage of personal finance with technology backed by Human Intelligence. Wish you great health !

  2. Vinay Maithani Cmrp

    Pattabiraman Murari This articles and your entire blog celebrates the marriage of personal finance with technology backed by Human Intelligence. Wish you great health !

  3. Anjani

    Hi Pattu,

    It is great article and very good comparative between 2 mfs. Is it possible to extend this to basket of mutual funds (example 5 -10) so that in one go, 10 could be compared and results table can show top to bottom based on ranking. It will help folks to take decision.

    Thanks for the great article and excel file.

    Anjani Singh

    1. pattu

      Thanks. comparing more than two will be difficult in Excel. The file will become large and the processing, intense.

  4. Nithin

    Hi, Can you please include UTI equity fund ? Currently there is "UTI - Equity Fund-Income Option". I am not sure if it is the same fund. I tried adding UTI - Equity fund, in the "Add new AMFI Record" section but was unable to do so. Thanks in advance !!

  5. Austin

    Thank You Sir .

    Between HDFC Equity Growth and Birla Sunlife Frontline Equity Growth , The sense of data I get its very tough to make a selection between the two.

    Can any one share their own opinion between the two Fund , if I have to opt for one.

    Thank You.


Do let us know what you think about the article