Simple how-to articles and free tools for financing your goals, managing your money, mutual fund and stock investments

Mutual Fund Calculators

Subscribe and join the freefincal Youtube community!

 Don't like ads but want to support the site? Subscribe to the ad-free newsletter! 
You will get the full post-ad-free delivered to your inbox for Rs. 3000 a year. Follow this link to read the terms and sign up! 
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 InvestingYou can be rich too with goal based investing

My first 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 customg solutions for your lifestye!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 want My second 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 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.
Updated: September 4, 2018 — 9:59 am


  1. Sir,
    Do you have a calculator that takes the historical dividents onto account for calculating returns

    1. Yes of course. Please see

      Keep visiting and sharing your feedback and requirements

  2. Hello Sir,
    I have been reading some of your articles and they have been very informative .Thanks for all your effort.
    I would like to know if there is any calculator to check the volatility of a full portfolio against the indices.

  3. Hello Sir,
    I have been reading some of your articles and they have been very informative .Thanks for all your effort.
    I would like to know if there is any calculator to check the volatility of a full portfolio against the indices.

  4. Vinay, apologies for the late reply. Just this now. Am trying to build portfolio analysis tools. Stay tuned!

  5. Hi Sir
    One suggestion, it would be nice if you can include the option to use data from VRO transaction history by importing it in an excel file. If feasible, It can save a lot of time.

    1. You mean in the fund tracker? Sorry, that would make it cumbersome.

      1. Not exactly,i am asking about a separate sheet which would just take the whole transaction history from VRO and compare the value of the portfolio at a particular date against various indices. You can choose monthly or any other intervals for reference.I am not sure how difficult it would be ..just putting a basic idea .

        1. Sounds interesting. However, I don’t understand what you mean by transaction history. Can you please clarify? Thanks.

          1. Hi Sir,when you track your portfolio in VRO, it also keeps track of all mutual fund transactions in a separate tab (together) which have all the details like purchase date, nav,cost, balance amount etc. This can be downloaded to an excel file too.i believe that having all of them at single place(rather than maintaining separate tabs)
            can be helpful to determine portfolio value at any date.

          2. Okay I get. Let me explore this option. Thank you.

  6. Hello Pattu sir, this is prashanth. I have a query …. I am actually new to mutual funds, i wish to invest in such a scheme that would offer me good returns. I am looking to invest just for an year. So i have shortlisted the following

    1) Can Robeco Emerg-Equities (G)
    2) Franklin Build India Fund (G)
    3) Reliance Small Cap Fund (G)
    4) UTI Mid Cap (G)
    5) Reliance Tax Saver (ELSS) (G)

    All these funds are offering close to 100 percent returns when invested for a year. I am looking at investing close to 70000, so please tell me if i should go ahead or how should i plan this investment. Since i am new, i am not sure how to plan ahead…. KIndly suggest me on how i should take it forward. If u have any idea on other schemes, kindly let me know

    Thanks in advance

  7. No doubt your articles are informative ,thanks a lot

  8. Mr Pattu,
    Apart from redeeming your MF folio on reaching targets set before start of investment, what can be the apt time-period for churing your MF folio ?

  9. please see my latest post on this

  10. Mr. Pattabiraman,

    First up, I respect your passion. You are indeed doing a yeoman service, thanks.

    I tried your principles of selecting a MF scheme. After the due diligence, I observed a huge swing in Alpla and Sharpe ratios. Then realised, benchmarks are different for different schemes and risk profiles are different too, affecting Alplha & Sharpe ratio respectively. As such, a scheme with a 3.6 alpha and 0.86 sharpe has given lower long term return than a scheme with 1.34 alpha and 0.66 sharpe. So, my doubt is whether the 5 volatility measures alone are enough to pick the one with highest return.


    1. Thank you. Sorry for the late response. I agree with your observations. I prefer either to pick consistent performers in terms of returns and then look at these metrics or focus only on downside protection

      1. Thanks indeed. I am reassured in my understanding towards selecting funds. Incidentally, your portfolio overlap tool( excellent ! ) competes the bouquet of parameters I will use to pick funds. If feels to me, that a vector of future performance potential, may be nice to fold into the analysis. Perhaps it is worthwhile to consider Morningstar analyst rating for this.

  11. Hi, I have invested 35000 (NAV 70.44) in 2010 in HDFC Tax Saver fund for which each year I received approx 3000 as dividend. As of now the NAV is 65.27. From the return perspective it is 8.5%. But when I see the %return in MF statement it shows me approx 12.5%. I am not able to understand. Can anybody please explain….

Comments are closed.

freefincal © 2019 Frontier Theme