Calculator Update: Variable/flexible Recurring Deposit Calculator

Note: The variable RD calculator gives the total post-tax interest. I have assumed that only the variable payments are subject to a penalty. That is if a variable payment is not made before a certain date (reader Srinivas says it is 10th in his case) then interest on the variable payment for that month will not be paid.

There was an issue with interest calculation for each FY when the monthly payments become variable. So I had to remove the original download link. I am trying to resolve this.

For normal RD where the monthly payments are fixed you could use this Recurring deposit calculator published earlier. This gives the tax liability each FY for different types of compounding (annual, half-yearly, quarterly and monthly).

Download the Variable/Flexible RD calculator-I

(total tax liability for multiple installments per month: fixed + variable)

  • Note: the above calculator assumes you make a fixed payment on the same day each month and variable investment (zero to anything subject to a max. defined by bank) on any day of the month (ie. two investments each month)
  • If your bank will permit only one investment each month then use this:

Download the Variable/Flexible RD calculator-II

(total tax liability for single variable installment per month)

Related articles

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.

15 thoughts on “Calculator Update: Variable/flexible Recurring Deposit Calculator

  1. In RD/Flexible RD calculators amount will be returned at the end of the period. But in chits amount may received in the middle or beginning also. Then how to calculate return rate if amount received in the middle of the period and subscription is continued till the end. I hope I am clear.
    Please help.

    1. Dear Shiva, If you are not able to use the XIRR calculator mentioned above, please send me the cash flow details. I will make one for you.

      1.  Dear Sir,

        Please find attached excel sheet for cash flows for 3 scenarios. Please tell how to calculate Annualised return for these.

        Thanking You ,     Yours Faithfully, R Siva Prasad Aurangabad Mobile:8275043533


  2. Excellent Tool sir ji, will use this to cross check the interest paid by my bank on a recently closed flexi RD…. thank you

  3. You have given very vluable information regarding variable recurring deposit post tax liability.
    I request u to please let us know the variable recurring deposit formula or calculator who have opted for the savings who does not come under the tax bracket.i.e. non tax payable persons.
    looking forward for your updates.

  4. Thank you. Please download the above file and set the tax slab as zero. Since the investments are variable there is no fixed formula.

  5. Thank you for the quick response.
    1) I request to help me, verify the Interest calculation and I feel the interest given under sl no 9 & 13 is not properly calculated by the bank.

    2) In the previous mail you have provided the calculation sheet to calculate variable RD interests. Now can i know that is there any calculation sheet available with you to check quarterly interests being given by the bank.

    I am reproducing the UCO Bank Passbook details for better clarity. This amount is from selling all my properties and hence i am very careful in my returns.

    Request you to verify and help me to with calculation, if available with you.

    thank you,

    Sl.No Date Deposits Balance
    1 19-08-13 Deposit 100 100
    2 04-09-13 Deposit 600000 600100
    3 14-09-13 Deposit 200000 800100
    4 14-09-13 Deposit 65000 865100
    5 30-09-13 Interest 4965 870065
    6 03-10-13 Deposit 100 870165
    7 04-11-13 Deposit 100 870265
    8 05-12-13 Deposit 100 870365
    9 31-12-13 Interest 19193 889558
    10 06-01-14 Deposit 100 889658
    11 06-02-14 Deposit 100 889758
    12 20-03-14 Deposit 100 889858
    13 31-03-14 Interest 19196 909054
    14 23-04-14 Deposit 100 909154
    15 13-05-14 Deposit 100 909254
    16 05-06-14 Deposit 100 909354

    Rate of Interest 8.75
    Quarterly Cumulative
    Variable RD
    Term 3 years

  6. please ignore the above post sent by me. Corrected details sent through email.

    thank you


  7. Is there any idea on deposit period for ICICI iWish and how their interest calculations are done since they allow multiple deposit amounts per month instead of conventional V RD

  8. how to calculate RATE OF INTEREST of recurring deposit.

    Suppose I’m investing 2500 per month in recurring deposit account for 2 years with rate of interest 8% compounded quarterly. Now I have to find out MATURITY AMOUNT. For this i will use formula :

    ACTUAL AMOUNT (MATURITY AMOUNT) = PRINCIPLE AMOUNT *( (1+RATE/100/4)^(4*2)-1)/(1-(1+RATE/100/4)^(-1/3))

    ACTUAL AMOUNT (MATURITY AMOUNT) = PRINCIPLE AMOUNT *( (1+8/100/4)^(4*2)-1)/(1-(1+8/100/4)^(-1/3))




    Suppose I’m investing 2500 per month in recurring deposit account interest compounded quarterly. My MATURITY AMOUNT IS 65229/-.


Comments are closed.