Calculator to Compare Lump Sum Investment Returns

The following appeared as a guest post in BasuNivesh Learn…Invest…Succeed !!! on May 1st 2013. The blog is authored by Basavaraj Tonagatti a Certified Financial Planner from Bangalore. His posts are honest, sincere and balanced.

All of us would like to get better returns on our investments. However with returns or capital gain comes knocking its evil twin – taxes. American entertainer Will Rogers once said, “The only difference between death and taxes is that death doesn’t get worse …”!

Trouble is tax rules are different for different investments. If a holding period of 1 year is considered ‘long term’ for capital gain taxation of Gold ETFs, it is 3 years for E-gold. To add to that the taxation rules also differ. This makes it difficult to compare the two and decide which is better if I want to invest for just a few years or many years.

Consider fixed deposits and debt funds. Both are ‘debt’ products. However tax on FD (or RD) interest should be declared and paid onaccrual basis (that is each year) while tax on debt funds can be deferred until redemption. This can make a considerable difference in the corpus if the investment period is long.

The main problem is most investment calculators available online do not take into account taxation rules. Based on the suggestions of Basavaraj and a few encouraging readers like Kapil Tiwari, I have made a calculator with gives the post-tax corpus of several common instruments for a given lump sum investment. It also includes a table in which the tax rules for different instruments are listed to serve as a ready-reckoner. The minimum investment period considered is 1 year. So only long term capital gains will be computed.

A recurring deposit calculator with a table listing the monthly pre-tax and post-tax interest earned is also available (I will post an updated version of this separately).

Use the calculators and let us know your feedback. Suggestions to modify the calculator are welcome.

Download the Lump Sum Investment Returns Comparator (updated Jan. 2014 with NRE fixed deposits)

Download the Lump Sum Investment Returns Comparator

Download the Recurring Deposit Calculator

Create a "from start to finish" financial plan with this free robo advisory software template

Free Apps for your Android Phone

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.

10 thoughts on “Calculator to Compare Lump Sum Investment Returns

  1. Hi Pattu,

    RD Calculator is a very good calculator. I dont think it may make significant difference in interest but can it be aligned with a entry of start date of RD and formulas tweaked to that. Also if it can show by financial year tax to be paid. I was always under assumption that I could pay tax on reciept at maturity of RD based on actuals. I will pay tax for the same while filing.

    1. Dear Vijay,

      Thanks for your feedback. I will implement your suggestion in the second version of the RD calc. which I will post soon.

  2. One more suggestion if you can provide years and months as inputs. Some schemes have good interest rate for fixed months…

  3. Many thanks, dear Pattu !! This is excellent for people like me who are still trying to comprehend with the basics of Personal Finance!

  4. Hi pattu, is there a calculator that can calculate the capital gains for debt MFs for lumpsum investments in FIFO order taking into account indexation benefit? For example, I invest regularly in debt MF throughout the year (but not SIPs) in an irregular manner. The calculator would take date of investment and calculate the capital gain for each date..

  5. The calcular is really very useful. My sincere thanks to you. However, just couple of suggestions to improve the same:
    1. For RD calculator, it will be helpful if you can incorporate investment tenure in terms of months and not in terms of year. Reason bank provides RD account in multiple of 6 months to 120 months.

    2. For FD (Lump Sum) calculator, I’ll sugeest you to incorporate years, months as well as days. Reason, Bank of Baroda has come with FD scheme of 7 years 6 months & 5 days. Probably many banks have com with the same scheme.

    Thanks again.

    1. Dear Aditya,

      Thanks for your inputs. You feedback reg. RD calc. is already implemented and will be posted tomorrow. The calc will also have annual tax break up.

      For FD I wil work on your suggestions and post it soon. Subscribe for email updates to know when it is released.

Do let us know what you think about the article