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

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)


Find out if you have enough to say "FU" to your employer (Google Play Store)


You Can Be Rich Too With Goal-based Investing A book that can help you ask the right questions about money and find simple solutions. Comes with nine online calculator modules. Read more about the book and order now! 

GameChanger - Forget Startups, Join Corporate & Still Live The Rich Live You want Take that international trip at 50% lower costs! Optimise credit card usage! Set money management on auto-pilot! Read more about the book and order now!

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