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

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.

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

  1. sivaprasad

    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.

    Reply
    1. pattu

      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.

      Reply
      1. sivaprasadr

         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

        ________________________________

        Reply
  2. cbisekhar

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

    Reply
  3. ANURADHA

    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.
    Thanks.
    Anuradha

    Reply
  4. pattu

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

    Reply
  5. ANURADHA

    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,
    Anuradha

    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
    UCO BANK

    Reply
  6. Balaji J. Hari

    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

    Reply
  7. ajay

    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))

    ACTUAL AMOUNT (MATURITY AMOUNT) = 65229/-

    ========================

    Now I want to know the FORMULA OF HOW TO CALCULATE RATE OF INTEREST.

    Suppose I’m investing 2500 per month in recurring deposit account interest compounded quarterly. My MATURITY AMOUNT IS 65229/-.
    But i don’t know what INTEREST RATE I HAVE GOT. I want to find out INTEREST RATE . WHAT FORMULA SHOULD I USE TO FIND OUT RATE OF INTEREST

    PLEASE REPLY.

    Reply
  8. Pingback: Recurring Deposit Taxes & FD Taxes - Details & Implications

Do let us know what you think about the article