# How to calculate interest on recurring deposits?

by on April 3, 2012

Pradeep Sharma left a comment the other day about how he had set up a recurring deposit with ICICI Bank and how the final amount he was calculating was different from the amount that the ICICI Bank representative told him.

That difference was due to the fact that while he was compounding interest monthly, banks usually compound interest quarterly and that’s why he was getting a different answer.

Paresh responded to that comment telling him what caused the difference, and when I looked at the response, I thought I’d add to it by providing a link to how interest on recurring deposits (RDs) are calculated.

I was surprised to see that while there were quite a few recurring deposit calculators, there were hardly any explanations and the few that existed were really very short explanations on how interest on RD was calculated.

So, I decided to give it a try myself, and it took me an embarrassingly long time and several mistakes to do that even though the concept is very simple.

## Understand Compound Interest To Understand Recurring Deposit Interest

When you create a RD for Rs. 10,000 for 2 years, what you’re doing is depositing Rs. 10,000 with the bank every month for 24 months, and the bank pays you interest on Rs. 10,000 for 2 years compounding it quarterly, then for the next Rs. 10,000 it pays you interest for 23 months, and so on and so forth.

Banks usually compound interest quarterly, so the first thing is to look at the formula for compound interest.

That formula is as follows:

A formula for calculating annual compound interest is

Where,

• A = final amount
• P = principal amount (initial investment)
• r = annual nominal interest rate (as a decimal, not in percentage)
• n = number of times the interest is compounded per year
• t = number of years

In your recurring deposit, you use this formula to calculate the final amount with each installment, and at the end of the installments, you add them all up to get the final amount.

## Think of RD Installments and Series of Principal Payments

Let’s take a simple example to understand this – suppose you start a recurring deposit for Rs. 47,000 per month for 2 years at 8.25% compounded quarterly. If you were to see this number as a standalone fixed deposit that you set up every month for 24 months, you could come up with a table like I have here. Before you get to the table, here is a brief explanation on the columns.

• Month: First column is simply the Month.
• Principal (P): Second column is P or principal investment which is going to be the same for 24 months,
• Rate of Interest (r): r is going to 8.25% divided by 100.
• 1+r/n: In our case, n is 4 since the interest is compounded quarterly, and 1+r/n is rate divided by compounding periods.
• Months Remaining: This is simply how far away from 2 years you are because that’s how much time your money will grow for.
• Months expressed in year: I’ve created a column for Months expressed in a year since that makes it easy to do the calculation in Excel.
• nt: 4 multiplied by how many months are remaining as expressed in year.
• (1+r/n)^nt: Rate of interest raised by the compounding factor.
• Amount (A): Finally, this is the amount you if you plug in the numbers in a row in the compound interest formula.

So, Rs. 47000 compounded quarterly for 2 years at 8.25% will yield Rs. 55,338.51 after two years. The last row contains the grand total which is what the RD will yield at the end of the time period.

 Month P r 1+r/n Months remaining Months expressed in year nt (1+r/n)^nt A 1 47000 0.0825 1.020625 24 2 8.00 1.18 55338.51 2 47000 0.0825 1.020625 23 1.916666667 7.67 1.17 54963.21 3 47000 0.0825 1.020625 22 1.833333333 7.33 1.16 54590.45 4 47000 0.0825 1.020625 21 1.75 7.00 1.15 54220.22 5 47000 0.0825 1.020625 20 1.666666667 6.67 1.15 53852.50 6 47000 0.0825 1.020625 19 1.583333333 6.33 1.14 53487.27 7 47000 0.0825 1.020625 18 1.5 6.00 1.13 53124.53 8 47000 0.0825 1.020625 17 1.416666667 5.67 1.12 52764.24 9 47000 0.0825 1.020625 16 1.333333333 5.33 1.12 52406.39 10 47000 0.0825 1.020625 15 1.25 5.00 1.11 52050.97 11 47000 0.0825 1.020625 14 1.166666667 4.67 1.10 51697.97 12 47000 0.0825 1.020625 13 1.083333333 4.33 1.09 51347.35 13 47000 0.0825 1.020625 12 1 4.00 1.09 50999.12 14 47000 0.0825 1.020625 11 0.916666667 3.67 1.08 50653.24 15 47000 0.0825 1.020625 10 0.833333333 3.33 1.07 50309.72 16 47000 0.0825 1.020625 9 0.75 3.00 1.06 49968.52 17 47000 0.0825 1.020625 8 0.666666667 2.67 1.06 49629.63 18 47000 0.0825 1.020625 7 0.583333333 2.33 1.05 49293.05 19 47000 0.0825 1.020625 6 0.5 2.00 1.04 48958.74 20 47000 0.0825 1.020625 5 0.416666667 1.67 1.03 48626.71 21 47000 0.0825 1.020625 4 0.333333333 1.33 1.03 48296.92 22 47000 0.0825 1.020625 3 0.25 1.00 1.02 47969.38 23 47000 0.0825 1.020625 2 0.166666667 0.67 1.01 47644.05 24 47000 0.0825 1.020625 1 0.083333333 0.33 1.01 47320.93 Final Amount 12,29,514

I’ll be the first one to admit that this is not a very intuitive way to either explain or understand recurring deposits calculation, but this is the only way I could write which seemed to convey the calculation comprehensively.

bemoneyaware April 3, 2012 at 10:12 AM

Thanks a lot – you saved me lot of work!
There is not much data available on the formula for calculating recurring post.

Arun February 28, 2016 at 9:54 PM

Naresh deposited rp 2000 at the beginning of every month in a bank for 5 year.the rate of interest is 12? compounded monthly. The accumulated amount at the end of 5 years will be?

Actually answer is 164973 I have want to know the method of calculate, pls help me to resolve

Shailesh deshkar July 20, 2017 at 12:15 AM

How to calculate RD account

Abhishek Kumar February 25, 2018 at 11:57 AM

for calculating RD 1 formula is there

MV= Pn+Pn(n+1)RT/2×100

for T the value is fixed T=1/12

now the formula will be,

MV=Pn+Pn(n+1)R×1/2×100×12

You have to find only the missing term
e.g.
Anil opened aRD account in a bank and diposited Rs.400 per month for 3 years if he recevied Rs.15732 at the time of maturity find the rate of intrest per annum.

MV=Rs.15732(its written recivied or get)
P=Rs.400
n=3years
=3×12
=36(n will be always in months)
R= the missing term

now putting the formula
=MV=Pn+Pn(n+1)R×1/2×100×12

=15732=400×36+37×R×1/2×100×12

=by solving we get,
=15732=14400+222R
Moving the R to LHS we get,
=222R= 15732-14400
222R=1332
R=1332/222
R=6 .ans

The Rate of interest will be 6%

Ak March 18, 2018 at 12:04 PM

A recurring deposit of Rs. 5000 per month for 12 installments will grow to ______ at the
end of 12 months for the given nominal interest rate of 12 percent, but compounded
monthly (consider deposit being done on the last day of the month and also accrual of
interest being calculated on the last day of the month).

Mohanraj P May 20, 2018 at 10:05 AM

How do calculate Recurring deposit?
Please provide the formula and explain
Example: Each month Paying 4200 in 1year and interest rate 6.85 %

renu June 9, 2018 at 11:01 PM

I have monthly deposite 500 in recuring account 8% intrest
How many get intrest amount
How caculate

Arun February 28, 2016 at 9:58 PM

Naresh deposited rp 2000 at the beginning of every month in a bank for 5 year.the rate of interest is 12? compounded monthly. The accumulated amount at the end of 5 years will be?

I want to know the method of calculation, pls help me to resolve

manohar karlekar July 6, 2016 at 1:37 PM

i am much impressed by the answer and the method i.e formula

Anju August 21, 2016 at 11:20 AM

Mr.A invested Rs.400000 in post office MIS and the proceedings from this investment is directly transferred to post office RD. How much amount will he get after maturity?

sribash September 22, 2017 at 11:56 AM

Please mail the formula for calculating interest on Recurring deposit on quarterly compounding method as being practice in banks.

Turiyam September 11, 2016 at 9:27 AM
Indian Thoughts April 3, 2012 at 10:29 AM

You are a saviour. I was procarstinating about doing this calculation from so long. 🙂 Thanks 🙂

Manshu April 4, 2012 at 6:22 PM

Anonymous Coward April 6, 2012 at 6:57 PM

Manshu April 9, 2012 at 3:40 AM

The link to the calculator is far more useful than my excel since that calculator gives you the number ready, and in my sheet you have to make a lot of changes if your term is different, compounding is different etc.

Turiyam September 11, 2016 at 9:29 AM

Ankush April 3, 2012 at 3:23 PM

Worth reading, analyzing and making others aware:

http://ftalphaville.ft.com/blog/2012/03/30/944431/indias-economic-monsoon/

Manshu April 4, 2012 at 4:28 PM

Absolutely right Ankur – I have a post in my drafts about this as soon as the report came out but didn’t publish it yet because I’m simplifying it and adding more data, but I will definitely link to this article in my weekend post. Thanks for leaving this comment here and bringing it up.

Manshu April 4, 2012 at 4:29 PM

Oops!!! My apologies – Ankush!

Prashant April 3, 2012 at 4:49 PM

thanks a lot for this article, it would be great if you include the tax implication of the same.

Vimal Raj April 3, 2012 at 5:50 PM

Prashant,

The interest earned through RD will be included in your income and will be taxed. There is no tax exemption for RD.

Manshu, thanks for the good post.

Manshu April 4, 2012 at 4:26 PM

Thanks for the response Vimal – the one thing I’ve heard differing opinions on is when should the tax be paid. Should it be paid every year since the income is accruing every year (even though it’s not getting paid) or should it be paid at the end of the RD term when the person actually gets the money. What are your thoughts?

Thanks!

Rupesh S Mahadik April 21, 2012 at 3:48 PM

When it comes to paying taxes on the interest earned there always is this question whether to pay it on per year basis or directly on maturity. The point here to be noted is that when you pay on a per year basis you end up paying a small tax amount only on the interest earned during that particular year, whereas when you think of paying it on maturity you may end up paying some more tax because the whole interest amount accrued over the period would add to your annual income and may end up moving your taxable income in the next higher tax slab and that really makes a good difference when the interest amount is higher, just consider for eg. you earn a total of 25K as only interest may be the same is from KVP / NSC / FD / RD.

Manshu April 22, 2012 at 8:19 PM

Thanks for the point Rupesh – so the laws allow you to choose which one to do? pay tax now or pay tax later? That’s what I’m not so clear about whether both are okay or not, people have said that they have chosen either option but I’m not sure whether there is any official guidance on this.

Pramod August 26, 2015 at 4:23 PM

I guess there isn’t a choice that you could make to pay on a y-o-y basis or on cumulative int. earned for the period. The Bank that holds your RD would certainly book the interest earned by you during an FY (without paying you) and include it as part of their interest payouts and that eventually gets reflected in your 26AS. This also gets reflected in the Interest paid statement that the bank gives you for each FY.

So it is always…….interest earned during an FY is included in the total income for the FY from tax purposes irrespective of the length of the investment.

moronbuffett April 3, 2012 at 8:38 PM

It is a sum of a Geometric Progression (GP).
I use this formula for monthly deposits.
P=monthly installment, r = rate %, y=no.of years, n=12*y, R=1+(r/1200)

A= P*(R)*(R^n-1)/(R-1)

For derivation, look at your +1 Maths book

Manshu April 4, 2012 at 4:23 PM

Thanks – I need to look this up and I must admit it didn’t occur to me at all to use GP. Thanks for bringing this up.

Jitendar Solanki April 4, 2012 at 10:28 AM

Nice post Manshu.

Manshu April 4, 2012 at 4:16 PM

Thanks!

Ramya Dear April 4, 2012 at 4:48 PM

Thanks for the info which gave a different approach…..RD from the point of view of FD….it was helpful. And i like your eagerness to make people understand in a easy way.

Manshu April 4, 2012 at 6:15 PM

Thanks Ramya – this was certainly one way, but perhaps doing it through geometric progressions as said in comments is better. I will have to look at that and see if this can be further simplified.

Paresh April 5, 2012 at 11:01 PM

Manshu,

I also think that this logic [considering the individual installment as Fd / calculating the interest for a period for each deposit/ sum it up] is not a true representation of recurring deposit..

I have one RD at IDBI bank with interest rate of 8.6% ..just I check the deposit schedule which I found for first few installments as below:

Payment Type Date Amount Paid Balance

Installment 03/01/2011 2000/- 2000/-
Installment 03/02/2011 2000/- 4000/-
Installment 03/03/2011 2000/- 6000/-
Installment 03/04/2011 2000/- 8000/-
INTEREST 03/04/2011 86 /- 8086/-
Installment 03/05/2011 2000/- 10,086/-
Installment 03/06/2011 2000/- 12,086/-
Installment 03/07/2011 2000/- 14,086/-
INTEREST 03/07/2011 216/- 14302/-
Installment 03/08 2000/- 16302/-
AND SO ON………………

I tried few things for my blog but not able to fit any formula …..
just check,, I think you will be….

Paresh April 5, 2012 at 11:45 PM

Just for more elaboration:

In above deposit schedule,I just fail to understand how interest of Rs.86 credited on 03/04/2011 or Rs 216/- credited on 03/07/2011…..
My feeling is that there is something which is on the shorter sight only but not able to find…..

Manshu April 6, 2012 at 6:19 AM

You didn’t mention why you think that way Paresh – is it just a feeling or something more than that? I’m convinced that this is accurate and don’t feel compelled to relook at it unless you can give some numbers or something else more concrete to show it’s inaccurate.

Paresh April 6, 2012 at 8:21 AM

I have never mean that you are inaccurate….

I have tried to present the numbers from my IDBI RD account…where I do not understand the logic that how they calculate the interest flow….thats what I was looking for.

Manshu April 6, 2012 at 8:24 AM

No, no, no, I didn’t misunderstand or feel bad and you certainly don’t need to say sorry but I was asking more in terms of what I should look for if I have to see whether there is an error or not. I didn’t realize that the RD numbers were for that purpose alone. I’ll look at the RD numbers.

Sorry for the miscommunication.

Paresh April 7, 2012 at 3:19 PM

Thanks for that.

What I was looking for is actually available in your post and work ….
Just able to solve the calculation of deposit schedule.

Have tried a deposit schedule for above particular case also:

Payment Type– Rs.——– A/C.Balance
1)Principle——>47000 —— 47000
2)Principle——>47000——- 94000
3)Principle——>47000——- 141000
4)Principle——>47000——–188000
5)INTEREST——- 3231.28——191231.28
6)Principle——>47000——–238231.28.
7)Principle——>47000 ——-285231.28
8)Principle——->47000——-332231.28.
9)INTEREST——–5878.50—–338109.78
10)Principle—–>47000——-385109.78
11)Principle—–>47000——-432109.78
12)Principle—–>47000——-479109.78
13)INTEREST—— 8907.87—–4,88017.65
14)Principle—–>47000——-535017.65
15)Principle—–>47000——-582017.65
16)Principle—–>47000——-629017.65
17)INTEREST—— 11999.71—-641017.36
18)Principle—–>47000——-688017.36
19)Principle—–>47000——-735017.36
20)Principle—–>47000——-782017.36
21)INTEREST——-15155.33—-797172.69
22)Principle—–>47000——-844172.69
23)Principle—–>47000——-891172.69
24)Principle—–>47000——-938172.69
25)INTEREST——-18376.04—-956548.73
26)Principle—–>47000——-1003548.73
27)Principle—–>47000——-1050548.73
28)Principle—–>47000——-1097548.73
29)INTEREST——-21663.17—-1119211.90
30)Principle—–>47000——-1166211.90
31)Principle—–>47000——-1213211.90
32)INTEREST——-16301.72—-1229513.62

Paresh April 7, 2012 at 4:21 PM

Please do not get confused with serial Number.
Serial number 32 is a flow serial number…do not represent the number of month…
Date of interest addition and installment on that date will be same..Total period is 24 months.

Michael July 31, 2012 at 4:14 PM

Hi Paresh, how did you calculate Interest at every interval?

Dr.Suneet Jindal March 3, 2013 at 2:20 AM

Its quite a simple riddle:
Actually on 03/01/2011: Your final amount was 2000
And on 03/02/2011: Your final amount was 2000+2000=4000
And on 03/03/2011: Your final amount was 6086(With Interest)
And on 03/04/2011: Your final amount was 6086+2000=8086
And on 03/05/2011: Your final amount was 8086+2000=10086
And on 03/06/2011: Your final amount was 10086+2000=12302(With Interest)
And on 03/07/2011: Your final amount was 12302+2000=14302
And on 03/08/2011: Your final amount was 14302+2000=16302
And so on..
Hopefully,you got what i wanna convey.. everything is right but you or the authorities just misplaced the dates/entries in the final statement..
Any doubts,will be happy to clear it..!!

Vivek July 1, 2013 at 9:11 AM

Dear Paresh bhai,
Here is an attempt from myside to decode the RD interest piece. Here are basic premises:
1. The bank makes 2 entries in every 4th month i.e. interest for previous 3 months and monthly deposit of 4th month’s principal.
2. The interest concept can be simply understood in this way:
Interest as of any particular month will be simple interest accumulated on an amount till that month. Hence, in April’11, Jan’11 deposit will fetch interest for 3 months, FEb’13 deposit for 2 months and Mar’13 for 1 month. Together, this interest can be calculated as AP of 3+2+1 i.e.. (n*(n+1)/2)
3. Bank however credits this interest in 4thh month in line with concept explained by Manesh bhai. However, fresh interest credited in every 4th month is total interest accumulated on all principals of every month minus interest already credited to account holder.
4. I hv mentioned entry no. to bring clarity to all.

Entry No. Date of transaction Month count Deposited Money Balance Interest due till date Interest being credited account Balance
1 3-Jan-11 1 2000 2000 2000
2 3-Feb-11 2 2000 4000 4000
3 3-Mar-11 3 2000 6000 6000
4 3-Apr-11 3 86 86 6086
5 3-Apr-11 4 2000 8000 8086
6 3-May-11 5 2000 10000 10086
7 3-Jun-11 6 2000 12000 12086
8 3-Jul-11 6 301 215 12301
9 3-Jul-11 7 2000 14000 14301
10 3-Aug-11 8 2000 16000 16301
11 3-Sep-11 9 2000 18000 18301
12 3-Oct-11 9 645 344 18645
13 3-Oct-11 10 2000 20000 20645
14 3-Nov-11 11 2000 22000 22645
15 3-Dec-11 12 2000 24000 24645
16 3-Jan-12 13 1118 473 25118
17 3-Jan-12 13 2000 26000 27118
18 3-Feb-12 14 2000 24000 29118
19 3-Mar-12 15 2000 28000 31118
20 3-Apr-12 16 1720 602 31720
21 3-Apr-12 16 2000 30000 33720
22 3-May-12 17 2000 26000 35720
23 3-Jun-12 18 2000 32000 37720
24 3-Jul-12 19 2451 731 38451
25 3-Jul-12 19 2000 34000 40451
26 3-Aug-12 20 2000 28000 42451
27 3-Sep-12 21 2000 36000 44451
28 3-Oct-12 22 3311 860 45311
29 3-Oct-12 22 2000 38000 47311
30 3-Nov-12 23 2000 30000 49311
31 3-Dec-12 24 2000 40000 51311
32 3-Jan-13 25 4300 989 52300

Hope this helps.

sneha September 3, 2013 at 4:47 PM

what is the percentage that you have taken ? could u please tell if you dont mind and give the illustration for the first three month i mean the working thank you…

Aarti April 12, 2012 at 5:41 PM

Hi,
Really greatful for your detailed & precise explaination…I was brainstorming on the calculation along with my frens since yesterday & could find no way of reaching the correct answer.
Your hard work has made me happy & got to learn a lot of things in the course of trial & error.

Kudos to u & ur effort..keep up the good work.

Thanks 🙂

Ashwani July 14, 2012 at 2:42 PM

Is RD interest taxable? Do reply me soon 🙂

A.K.Kaul September 7, 2017 at 7:51 PM

Yes,RD interest is taxable like FDR interest.

Ashwani July 14, 2012 at 2:44 PM

I wish to ask the same question you can reply me on either of the 2 IDs !!!

Ashwani July 14, 2012 at 2:46 PM

Is RD interest taxable ? Do reply me soon

Rupesh S Mahadik July 14, 2012 at 9:16 PM

Yes, Fully Taxable. Interest accrued from RD / FD adds to the annual income & an individual is liable to pay tax on the same.

Shirish July 15, 2012 at 6:25 PM

There is a simple formula for calculating future value (accumulated amount) of a recurring deposit:
FV = A *{[ (1+i)^n] -1}/i
FV = future value
A = Recurring deposit amount
i= interest rate
n = period

sanket July 31, 2012 at 12:00 PM

sir, my question is how to calculate the interest if i am depositing money annually.
like i pay my premiums to the life insurance company annually 10000. so say after 10 years how can i calculate the interest. let rate of interest be according to the market rates.

please explain the process n the formula.

Manshu August 1, 2012 at 5:48 AM

Here is a good post that explains how to do this with a video tutorial, I think this post will answer all your questions.
http://www.jagoinvestor.com/2011/02/calculate-insurance-policies-returns-video.html

sanket August 1, 2012 at 8:51 PM

thanks sir.. clear concept

BV August 16, 2012 at 12:12 PM

One subtle point is that it is important to know which 2 years the deposit is taken on. That is, the date of deposit could alter the final amount a little bit. For example, a 2-year deposit taken on 1-Feb-2012 will end on 1-Feb-2014 and will have a total of 731 days (2012 being a leap year) for which interest will have to be accrued, whereas a 2-year deposit taken on 1-Feb-2013 ending on 1-Feb-2015 will accrue interest on 730 days only.

In essence, the payment frequency a.k.a number of days between each actual payment period (monthly in your example) will determine the interest amount for that period and the sum of all those amounts for the tenure will yield the final deposit amount.

Manshu August 20, 2012 at 9:58 PM

Thanks for bringing that up BV.

pradeep gogoi August 21, 2012 at 2:42 PM

i’ll get rs 1.44 lacs by investing rs 1500 p.m for 5yrs.i would like to know what is the interest i am getting?and i dnt knw how many times interest is compounding in a year u can assume once in a year.

pradeep gogoi August 21, 2012 at 2:47 PM

interest i mean rate of interest.

Paresh August 21, 2012 at 9:29 PM

Around 18%.

chandran.ravindran September 28, 2012 at 10:35 AM

Can u please explain hw u calc ? Any Formula ?

pradeep gogoi August 22, 2012 at 12:11 AM

thanks.

Satie J August 24, 2012 at 11:04 AM

Hi Manshu,

Nice post!

I did lots of r&d to achieve this but unfortunately i couldn’t make it. You save lots of my time. Really appreciate your hard work.

Even I was looking Fixed Deposits. I am not sure whether we already have it. Pls let me know your view if possible.

Thx,
Satya

Charanjeet September 24, 2012 at 4:18 PM

Guys can you help me out with a formula for PPF where i would be depositing Rs 50000 on anually basis for 15 years what would be amount at maturity…. Calculated manually but if you guys can help me out with formulla that would be a real help….

bemoneyaware September 25, 2012 at 4:13 AM

The calculator at PPF calculator might be of help!

Anil Kuppa October 2, 2012 at 10:13 AM

Hi Manshu,
I am a regular reader of your blog and subscribe through google reader. I have recently opened a RD in icicibank.com and I’d like to show you how the bank is cheating/earning interest while we fail to earn interest.
Step1: Click on Open a fixed deposit/recurring deposit
Step2: Open the RD form. You’ll notice a form very similar to this:
https://dl.dropbox.com/u/34070124/iciciRD.jpg
I have highlighted the most important note10. I had opened the RD on 28th September and chose the date as 1st of every month.
Now, this is what happens. The first installment was debited on 28th and the second one was debited on 1st of October. But, the money debited from my savings account for the second installment was not credited into my RD. I think it would be credited on 28th.
I checked my RD account and it shows the maturity date as 28th June 2013 and checked the amount. The amount and the date are correct. But, what is really happening here is that the amount which is debited on 1st does not fetch any interest until 28th of every month, which essentially means almost one entire month.
I could have chosen a better way, that is the date on which I am opening the RD as the date to debit the account from.
I felt completely cheated by this option. This date option is just like locking the amount until 28th and then putting in RD. This is how bank earns money in the garb of saving money for us.
I requested ICICI bank to change this option and emailed them. Let’s see. I felt this comment would be useful for a lot of readers.

In a completely unrelated note, a suggestion from my end, it will be great if you have this discussion or comments secion from http://disqus.com/ . I am not a salesperson of disqus.com, but this will help readers like me to check whatever comments I’ve made so far.

Manshu October 7, 2012 at 7:06 AM

Wow! I had no idea about this! So when you contacted ICICI, they agreed that this is what was happening? It’s unbelievable! I think I’ll make this as a mini post and let others know that this is happening instead of this just being buried in comments.

Thanks a lot for sharing this.

I have once passed over Disqus because I felt that it will make OneMint dependent on availability of Disqus and I wasn’t sure if it is wise to rely on that. I think now it seems like it is fine to rely on their availability. I wish I knew how they make money…that always makes the decision easier. Thanks for the suggestion.

Anil Kuppa October 7, 2012 at 10:33 AM

I am following up with ICICI bank. I’m not sure they have accepted it yet. But, I don’t think there’s any calculation mistake in my part. I have clearly put up in blogpost :
http://itooblog.wordpress.com/2012/10/04/investing-in-recurring-deposit/
I have emailed the customer care and am waiting for their reply.

Manshu October 7, 2012 at 7:35 PM

After reading your blog post I understand this a little better, and realize that this happened only once at the setup. Correct?

This wasn’t clear to me earlier, it seemed like it was happening every month.

Anil Kuppa October 8, 2012 at 8:53 AM

Since the amount is being debited from my savings account for every month, I should be getting interest for that. This is not one-time interest, every month I should be getting the interest. You could check out my 2nd table in the post.
But, the interest calculation is not correct. It could also be that recurring deposit calculates only based on months, the interest calculation does not consider any days.
I would like to confirm that from ICICI bank.

Anil Kuppa October 4, 2012 at 6:39 PM

Hi Manshu,
I have created a blogpost out of my experience. You can check it here:
http://itooblog.wordpress.com/2012/10/04/investing-in-recurring-deposit/

Thanks.

Gaurav Anand November 20, 2012 at 8:57 AM

Please tell me the formula used to calculate RD.

Somendu December 18, 2012 at 12:48 PM

Hi,
Can u put the formula for one year
RD calculated annually

Manshu December 18, 2012 at 5:41 PM

That is just the future value of an annuity, you can look up that formula to see how that works, but RDs are never annual. The payment is always monthly.

Somendu December 18, 2012 at 8:38 PM

Thanks Manshu,

Yeah.. I know

Actually was looking for the formula to put it in my recurring deposit calculator code. I worked on it and did 🙂

Manshu December 18, 2012 at 8:58 PM

Excellent – congrats!

smartgirl02 July 1, 2013 at 4:58 PM

Dear Paresh bhai,
Here is an attempt from myside to decode the RD interest piece. Here are basic premises:
1. The bank makes 2 entries in every 4th month i.e. interest for previous 3 months and monthly deposit of 4th month’s principal.
2. The interest concept can be simply understood in this way:
Interest as of any particular month will be simple interest accumulated on an amount till that month. Hence, in April’11, Jan’11 deposit will fetch interest for 3 months, FEb’13 deposit for 2 months and Mar’13 for 1 month. Together, this interest can be calculated as AP of 3+2+1 i.e.. (n*(n+1)/2)
3. Bank however credits this interest in 4thh month in line with concept explained by Manesh bhai. However, fresh interest credited in every 4th month is total interest accumulated on all principals of every month minus interest already credited to account holder.
4. I hv mentioned entry no. to bring clarity to all.

Entry No. Date of transaction Month count Deposited Money Balance Interest due till date Interest being credited account Balance
1 3-Jan-11 1 2000 2000 2000
2 3-Feb-11 2 2000 4000 4000
3 3-Mar-11 3 2000 6000 6000
4 3-Apr-11 3 86 86 6086
5 3-Apr-11 4 2000 8000 8086
6 3-May-11 5 2000 10000 10086
7 3-Jun-11 6 2000 12000 12086
8 3-Jul-11 6 301 215 12301
9 3-Jul-11 7 2000 14000 14301
10 3-Aug-11 8 2000 16000 16301
11 3-Sep-11 9 2000 18000 18301
12 3-Oct-11 9 645 344 18645
13 3-Oct-11 10 2000 20000 20645
14 3-Nov-11 11 2000 22000 22645
15 3-Dec-11 12 2000 24000 24645
16 3-Jan-12 13 1118 473 25118
17 3-Jan-12 13 2000 26000 27118
18 3-Feb-12 14 2000 24000 29118
19 3-Mar-12 15 2000 28000 31118
20 3-Apr-12 16 1720 602 31720
21 3-Apr-12 16 2000 30000 33720
22 3-May-12 17 2000 26000 35720
23 3-Jun-12 18 2000 32000 37720
24 3-Jul-12 19 2451 731 38451
25 3-Jul-12 19 2000 34000 40451
26 3-Aug-12 20 2000 28000 42451
27 3-Sep-12 21 2000 36000 44451
28 3-Oct-12 22 3311 860 45311
29 3-Oct-12 22 2000 38000 47311
30 3-Nov-12 23 2000 30000 49311
31 3-Dec-12 24 2000 40000 51311
32 3-Jan-13 25 4300 989 52300

Hope this helps.

krish July 2, 2013 at 12:41 PM

when the deposit for the 24th month is held for one more month for maturity, then the first deposit, the interest should be for 25 months and similar for other deposits??

divya July 10, 2013 at 10:59 AM

what is months expressed in an year? how is that calculated?
also, will this calculation help with different installments.
Basically i paid off a loan borrowed from my mom, amounts vary in a month.
I have paid off the principle. Need to calculate interest at 8% p a, compunded monthly.

vivek July 17, 2013 at 12:01 AM

Interest on loan repayment is calculated on reducing principal basis. You need to calculate due interest on due loan amount at end of every month. For compound benefit, you need to add up this interest in the due loan amount as opening balance of next month. Once payment is done, due loan amount gets reduced by paid amount and interest is calculate on balance due amount. Let me make it clear nby this example:
Let’s assume you borrowed Rs. 10,000 from your mom on 1st Jan to return within 1 year at 8% p.a. compounded monthly. I will explain reduced principal basis with 3 scenarios:
1. Simple interest: Had you paid SI, your interest payble at year end will be = 10,000 x 8% = 800 (no brainer !)
2. Compounded intrest: In logical terms, it can be calculated for 12 months as following:
Opening Balance Monthly interest Closing balance
10,000 67 10,067
10,067 67 10,134
10,134 68 10,201
10,201 68 10,269
10,269 68 10,338
10,338 69 10,407
10,407 69 10,476
10,476 70 10,546
10,546 70 10,616
10,616 71 10,687
10,687 71 10,758
10,758 72 10,830
Hence, Compound interest is 10830-10000 = 830
Also, In mathematical terms it will be 10,000 x (1+8%/12)^12 – 10000 = 830
3. Now comes Reducing principal…..Let’s assume you returned 2000 in feb, 3000 in May, 2000 in Oct and balance 3000 in Dec. I am making it not only varying amount but also irregularly paid in tranches. Let’ look at interest payble at year end:

Month Opening Balance Monthly interest Princi paid Closing balance
Jan 10,000 67 10,067
Feb 10,067 67 2000 8,134
Mar 8,134 54 8,188
Apr 8,188 55 8,243
May 8,243 55 3000 5,298
Jun 5,298 35 5,333
Jul 5,333 36 5,368
Aug 5,368 36 5,404
Sep 5,404 36 5,440
Oct 5,440 36 2000 3,476
Nov 3,476 23 3,500
Dec 3,500 23 3000 523

Hope this helps.

Mukesh July 12, 2013 at 6:11 PM

Sir I m depositing 25000 every month in RD I have to deposit for 10 years So pl.let me know the interest I will get every year for income tax purpose. Interest is calculated monthly.
Thanks Mukesh

vivek July 16, 2013 at 11:39 PM

Dear Mukesh,
Interest is calculated monthly but paid in the account after the quarter. Now for interest calculation, I will give you logic and then you can calculate ineterest for n years yourself.
In RD, interest on any months’ deposit is calculated on the basis of no. of months eligible for ineterest credit as on interest date. Now let’s take our Rs. 2,000 gets deposited on 1st Jan, 1st Feb and 1st Mar. Since interest will be calculated after this quarter, the calculations will be as following:
1. Interest on Jan deposit = 2,000 x 3 months (Jan till Mar) x 8.6%/12 (monthly interest)
= 43
2. Similarly, interest on Feb deposit = 2,000 x 2 months (Feb and Mar) x 8.6%/12 = 28.67
3. and interest on Mar deposit = 2,000 x 1 month (Mar) x 8.6%/12 = 14.33
Total accumulated interest = Rs. 86

Similarly, interest will be calculated after 2nd quarter i.e. Jan deposit will get interest for 6 months + Feb deposit for 5 months + ……..+ Jun deposit for 1 month = 301. This is total accumulated interest till end of 2nd quarter. But since interest (86) at end of quarter 1 was paid already, 301 – 86 = 215 will be paid as interest in the account at quarter 2.

Hope it helps.

vivek July 17, 2013 at 5:12 AM

Another interesting point, though it hasn’t discussed in this forum, is about taxability of interest from RD. Unlike other fin’l products, interest in RD a/c is taxable on annual basis, not on maturity. Bank / PO doesn’t deduct TDS or gives exemption. Hence, the net return should be calculated depending upon which tax bracket an investor is.

Ankith July 18, 2013 at 8:44 AM

Hi Manshu,

Thanks for such a simplified explanation.

I was wondering if we can use the future value of an Annuity formula to arrive at the maturity amount in the case of an RD. If yes, can u please eloborate the workings of the same.

Ankith

Manshu July 18, 2013 at 5:39 PM

Yes Ankith, you should be able to do that by simply multiplying time periods by 12 and dividing interest rate by 12 in the standard formula. Did you try that? I think that’s all you’d need to do.

Ankith July 19, 2013 at 8:22 AM

Yea I did try it out. I think multiplying and dividing by 12 would work only when the interest is compounded monthly. As you know many of the banks compound the interest on a quarterly basis. Lets say for example I invest INR 2000 per month for the next 24 months and if i calculate in excel as expalined by you, the maturity amount would be INR 53148(Interest rate being 9.75% compounded quarterly) and when I consider the future value formula, the maturity amount would be INR 50310(after dividing the interest rate by 24 and multiplying the time period by 24).

Is there a way to use the future value of annuity formula when the interest is compounded quarterly and also supposing I pay the RD amount at the beginning of every month, shouldn’t it be considered as annuity due and not as ordinary annuity? In either case I am not getting the value that matches with the working suggested by you. Please do clarify this ambiguity.

Rikin Kachalia September 13, 2013 at 2:51 PM

Thanx. Its really very helpful. The calculations are exact.

anoop September 29, 2013 at 12:27 PM

thank you

Ajay April 3, 2014 at 4:00 PM

I found this is really useful and I must thank you for your efforts. Can you also share a similar table for FDs. It will be really helpful.

Arunangshu Chatterjee August 7, 2014 at 3:57 PM

Hi,
I have used the mentioned formula for RD calculation (Future Value) and the result also in line with the method of calculating of RD by Banks (ref: http://www.allbankingsolutions.com/Recurring-Deposit-Calculator-India.shtml) with quarterly compounding effect. But the results are in line up to 3 years (time frame), while calculating more than 3 years terms it is not matching with the result of banks.

tyler September 4, 2014 at 4:01 AM

I have $135 bi weekly deposits compounded bi weekly at .8%, how much money will there be in 15 years? Can you please explain how you did it too. Thanks Reply Tyler September 4, 2014 at 5:48 AM If i make biweekly deposits of$135 and the interest compounds biweekly at the rate of .8% for 15 years, how much money will I have at the end of the 15 years

Thanks

MANCHALA SWAMY November 29, 2014 at 1:39 PM

How to exactly calculate Int on Recurring Deposit?

krishna January 19, 2015 at 6:17 PM

Hi,
I just found a formula for calculating the final amount using the logic provided here and thought this will be useful for you all.

A=P(1-(N^(m+1)))/(1-N) – P

May be the admin can post the formula in a more readable form. 🙂

Cheers!!!!

krishna January 19, 2015 at 6:20 PM

Sorry. I missed this in my previous comment.
There N=(1+(r/n))^(n/12)
Where n = no. of time interest is compounded per year (4 for quaterly)
And r= rate of interest as a decimal (0.08 for 8%)

Ashis mondal January 22, 2015 at 4:57 PM

please anyone give a eassy formula for calculating Recurring Deposit prematurity system.

MOOL SINGH February 27, 2015 at 6:16 PM

P R 1+r/n Months remaining Months expressed in year nt (1+r/n)^nt A
100 0.11 1.009166 36 3 36 1.388846 138.8845599
100 0.11 1.009166 35 2.916666667 35 1.376231 137.6231065
100 0.11 1.009166 34 2.833333333 34 1.363731 136.3731106
100 0.11 1.009166 33 2.75 33 1.351345 135.1344681
100 0.11 1.009166 32 2.666666667 32 1.339071 133.9070758
100 0.11 1.009166 31 2.583333333 31 1.326908 132.6908316
100 0.11 1.009166 30 2.5 30 1.314856 131.4856343
100 0.11 1.009166 29 2.416666667 29 1.302914 130.2913835
100 0.11 1.009166 28 2.333333333 28 1.291080 129.1079798
100 0.11 1.009166 27 2.25 27 1.279353 127.9353246
100 0.11 1.009166 26 2.166666667 26 1.267733 126.7733203
100 0.11 1.009166 25 2.083333333 25 1.256219 125.6218703

mahesh May 13, 2015 at 9:25 PM

can I deposit more than 10000 per month in Vrd

Hemendra Zaveri July 9, 2015 at 4:59 AM

Interest calculation by your way does not give exact amount for Indian Banking system where monthly deposit can start any date of month and quarter ends at 30th June, 30th September, 31st December and 31st March.

For example:

P=12000 on every 2nd of month starting from 2nd April,
t=1 year,
i=9.25%

on 30th June interest=544.36
on 30th Sept interest = 1399.43
on 31st Dec interest = 2261.75
on 31st March interest = 3053.14

Total interest upto 31st March = 7258.69

As per your formula interest =7309.86

The difference is probably interest for 1 day 1st April.

tsr August 18, 2015 at 2:32 PM

Try “Everyday Calculator” App for Android for all your calculation needs. Use the Future value of Annuity calculator to find interests earned on daily/ monthly/ yearly recurring deposits. This and many more..

Satish S. Gaikwad September 4, 2015 at 6:00 PM

Thank you Manshu.. I made my own Excel by formula.. 🙂

RDaccount November 23, 2015 at 12:40 PM

great article ! let me understand one thing investing in mutual fund is better or investment in RD account ? which one i can prefer

higro December 2, 2015 at 9:49 PM

Dear friend, RD and Mutual Funds both are avenues for investing. However, both differ in their purposes. Both have their merits and demerits. RD will give you assured returns but the same will be subject to taxation and inflation, which will both erode the final returns. Mutual Funds on the other hand may not give you assured returns,but can beat inflation and taxation. So the question is not which one is better, but what for you are investing. In the long run Mutual Funds will always give you better returns.

higro December 2, 2015 at 9:42 PM

The maturity value of RD quarterly compounding can be calculated using simple financial function (fv) on spreadsheet. However, the rate given has to be converted to effective monthly rate using financial functions nominal and effect on spreadsheet.

Deepak January 12, 2016 at 6:10 PM

Hi,

A loan of 10,00,000 is taken for 10 months. The loan amount is to be repaid in ten equal instalments of 1,00,000. The Rate of interest is 10% p.a compounded monthly. Interest will be debited in the account on the last day of the month and the same will be serviced on the same day itself, that means no overdue.

In the above situation, whether there will be any change in the total interest (and total outflow) if the interest charged is simple interest or compound interest

Thank you

bindu January 27, 2016 at 5:05 PM

Hi.. The post was really helpful in calculating the interest.
Just one query.. any idea how the ICICI iWish (Flexi-RD) interest is calculated. I am breaking my head trying to trace back how the interest deposited is calculated but cant seem to match up the figures..
Any help would be greatly appreciated.

RUSHI JAIN March 21, 2016 at 12:59 PM

Q. How to calculate months expressed in year (any formula or step)
Q. How to calculate rate of interest raised by compound factor?

plz explain

Anirudh April 10, 2016 at 6:31 PM

Quite a nice explanation ! Is it a good idea to open a recurring deposit ? I think some SIPs provide same sort of structure and better returns. However, i am not that sure to invest in Mutual Funds.

umesh daniel June 30, 2016 at 4:02 PM

I wish to know in recurring deposit how much total amount shall i get when i am depositing 5000/ month @8% interest pa

Snehashis Paul July 14, 2016 at 1:21 PM

Here is the formula,
M =R [ (1+i)^n – 1]
——————–
1- (1+i)^ -1/3
where,
M = Maturity value
R = Monthly installment
n = Number of quarters
i = Rate of interest/400

Ami July 28, 2016 at 10:47 PM

i want answer of this question.. how to calculate answer n what formula i used??

Manisha is a smart investor. She has
opened a Recurring Deposit (RD) account
with a bank. She has negotiated smartly
with the bank. Bank has agreed to vary the
interest rate on her RD account such that
she is always able to comfortably beat
inflation.
her RD account in face of varying interest
rates that she will enjoy.
Input Format:
First line contains principle amount P
Second line contains original rate of
interest per annum R
Third line contains tenure in months T
Next few lines contain a tuple with 3
values. Each tuple contains delimited by
whitespace, where updated _rate is applied
on From_month and To_month, both
inclusive.
-1 shows the end of input
Output Format:
Print the maturity amount after specified
tenure or month in the format
“Final_Amount ”
Constraints:
P > 0 ; it can be float value
R >=0 ; it can be float value
T >0 ; it can be integer only
Calculation should be done upto 11-digit
precision
Maturity amount should be printed to its
nearest integer value
Sample Input and Output
SNo. Input
1
5000
10
12
3 7 11
8 12 12
-1
F
2
2565.50
7.5
12
6 12 8
-1
F
3 200.75
6.9
5
-1

satish August 30, 2016 at 1:04 PM

Not understood.
I am investing Rs 1520 for 13 months
And final amt I will get is Rs 21000.
How do I calculate the Interest.
The bank says it is 10.46%.
Pl explain to me how they got this fig of 10.46.. In simple formula method.

Anil July 23, 2018 at 8:53 PM

Satish,

If it’s quarterly cumulative then the Rate of Interest is 10.47087 % per Annum and if it’s monthly cumulative then the Rate of Interest is 10.3892 % per Annum.

It’s not easy to explain the formula, but it’s basically Reversed Engineering. I have developed a SpreadSheet that gives me Future values of Recurring Deposits by giving Monthly Contribution, Rate of Interest and No. of Years. I considered 10.46% as the Baseline Interest and fine tuned it to arrive at 10.47087% as the final answer. This was done with Quarterly Cumulative Strategy.
Similarly I did it for Monthly Cumulative Strategy to arrive at 10.3892% as the final answer.

Hope this helps.

Thanks.

Anil

Kim November 1, 2016 at 4:45 PM

Someone help me find the formula for calculating future value for RD and deposit+interest for each period is added up to the deposit of the next period. Such that if I have RD of rs 19600 and it earns interest of rs30,my next principal amount will be 19600+30+19600

lasertest January 15, 2017 at 5:16 PM

With havin so much content do you ever run into any problems of plagorism or copyright infringement?
My website has a lot of exclusive content I’ve either created myself
or outsourced but it looks like a lot of it is popping it up
all over the web without my authorization. Do you know any techniques to help prevent content
from being ripped off? I’d really appreciate it.

Arjun February 21, 2017 at 11:14 AM

What will be the calculation if it is compounded monthly or half-yearly, need help

Shreya Sarkar May 29, 2017 at 12:22 PM

For RD account, is it better to open in a Private bank or Government bank?
I also heard Post office is giving a good rate of interest.

manoj September 27, 2017 at 10:18 PM

Why are you calculating interest monthly?
For RD, interest calculation done on after every 3 months.

RATTAN April 16, 2018 at 6:33 PM

Please advise as to what will be the interest rate yearly on depositing Rs.50000 pa for 5 years giving a gross return of Rs 350000. and how it is calculated.

Usha Vijayanarasimha September 9, 2018 at 5:18 PM

I have started a rd on 8-9-2018 for 50000 ,rate of interest is 6.6, and the tenure is 1 year.interest is compounded quarterly. How do i calculate how much interest is earned till march 2019 for tax calculation purpose?