Rolling Returns Calculator: Fund A vs. Fund B

Use this rolling returns calculator to compare the consistency in performance of one mutual fund with another. When you have shortlisted two funds and are not sure which one to choose, this tool along with the Fund A vs. Fund B Risk and Return Analyzer can be used to choose one fund.

For those who hold multiple funds in then same category, both these tools can be used to consolidate their portfolio.

This tool was suggested by certified financial planner Basavaraj Tonagatti, who runs Basunivesh.com

Here a few screenshots obtained for a comparison between ICICI Focussed Blue Chip and Franklin India Blue Chip

Input Sheet

Rolling returns fund a vs fund b inputs

 

Analysis Sheet

Rolling returns fund a vs fund b analysis

 

 

Normalized NAV movement

 

Rolling returns fund a vs fund b NAV movement

 

Rolling Returns

Rolling returns fund a vs fund b

 

This is the 5 year rolling returns. In this case, the better performer is obvious. In general, a fund which has higher long-term rolling returns (more frequent) is better.

Download the fund A vs fund B rolling returns calculator

Install Financial Freedom App! (Google Play Store)

Install Freefincal Retirement Planner App! (Google Play Store)

book-footer

Buy our New Book!

You Can Be Rich With Goal-based Investing A book by  P V Subramanyam (subramoney.com) & M Pattabiraman. Hard bound. Price: Rs. 399/- and Kindle Rs. 349/-. Read more about the book and pre-order now!
Practical advice + calculators for you to develop personalised investment solutions

Thank you for reading. You may also like

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.

12 thoughts on “Rolling Returns Calculator: Fund A vs. Fund B

  1. S.Vaithyanathan

    I am getting an error when I compare UTI Opportunities Growth Vs Quantum Long term equity Growth. I am not getting Total number of rolling return entries in the analysis page.
    Could you pls. guide

    Reply
  2. S.Vaithyanathan

    I am getting an error when I compare UTI Opportunities Growth Vs Quantum Long term equity Growth. I am not getting Total number of rolling return entries in the analysis page.
    Could you pls. guide

    Reply

Do let us know what you think about the article