Jagoinvestor

May 23, 2010

How to calculate Future Value of your monthly Investments

Lets say you want to invest Rs 2,000 per month for 10 yrs and then want to leave it for next 20 yrs to grow . How will you calculate it ? Do you know ?

Today we will see this basic calculation and learn how to find out the amount you can generate .

Calculate Future Value of monthly Investments

We have to understand that there are two phases to this calculation. First is  Payment  Phase, which is total time when you will pay money from your pocket , example 10 yrs .

Next phase is Investment Phase, This is total time frame you are invested in something product. Example 30 yrs, So in this case Phase 2 – Phase 1 = 20 yrs , which is the time when you let your money grow .

What it means is that your money will grow in two phases, First is the payment phase when you are investing money from your pocket, at the end of the payment phase , you will build a corpus which you can call as “Payment phase Corpus”, Now after this you stop payment any amount from your pocket and just let this “Payment phase coupus” grow year by year in some product till your target date.

So as per our earlier example, You may want to pay for 10 yrs (payment phase) and then let it grow for next 20 yrs and at the end of 30 yrs (Total Investment phase) you will build the “Investment Corpus” .

We will see an example calculation below . Assumptions are

Ajay wants to invest Rs 4,000 per month for 10 yrs and expects a return of 12% yearly (Payment Tenure) . After 10 yrs of investing from his pocket he then wants to leave that investment to grow in Equity (see suggestions for equity funds) and expects it to grow by same 12% return.

His total Investment tenure is 30 yrs. (Video tutorial for calculations)

Calculations

Payment Phase : Our first task here is to calculate the Corpus generated after Payment tenure first . So as per example, Ajay wants to invest Rs 4,000 per month for 10 yrs (120 payments) @12% return expectation .  The forumla you have to apply is called Future Value forumla or annuity due (payment in the start of the period) . The forumla is :

FV = A x (1+R) x (((1+R) ^ n) – 1)/R

where

A = Investment per month : This is the amount invested per month , In our example its 4,000 per month

R = Rate of Interest per month (yearly interest/12) . This is monthly return you expect , If you expect the return to be 12% per year , then per month return will be 1% (compounded monthly) , hence R = 1% or 0.01

n = This is total number of payments , so multiply 12 by the number of years , so if your duration is 10 yrs ,then n = 12X10 = 120

As per the formula

FV = 4000 x (1+.01) x (((1+.01) ^ 120) – 1)/.01

= 9,29,356

So we have found that the total corpus generated after 10 yrs of payment tenure is Rs 9,29,356 . First step is completed .

Investment Phase : Here , we are going to calculate the final value of the corpus at the end of Investment phase , so as per step 1 , we have Rs 9,29,356 at the end of 10 yrs , which we will call as Payment phase Corpus (PPC) . Now this amount will be lying in the investment for growth . We just have to apply compound interest formula now which is:

Final Corpus = PPC x (1+R) ^ n

where

PPC = Payment Phase Corpus , we have calculated it above and its value is 9,29,356

R = Rate of return expected for the rest of the period , we have expected it to be 12% or 0.12

n = this is the number of years we are letting the money grow after Payment phase . In our example it was 20 yrs, because total investment tenure was 30 yrs, out of which first 10 yrs was payment tenure .

Applying the formula we get

Final Corpus = 9,29,356 x (1+ 0.12) ^ 20

= 89,64,840

So the final amount you can generate by investing 4,000 per month for 10 yrs and then leaving it to grow for next 20 yrs @12% is 89.64 lacs.

Calculator

You can use the calculator Below to find out your Corpus (Look at more calculators)


Comments please , Did you find this whole calculations very tough to understand ? Suggestions ?

Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

59 Comments
Inline Feedbacks
View all comments
Abir
Abir
10 years ago

Hi,

Can someone help me understand what the annual rate of return would be in the below mentioned scenario and how to calculate it:

If you are paying INR 5,670/month for 10 years and after another 10 years i.e. total term is 20 years you get back INR 11,00,000 (11 Lakh).

Rahul Kumar
Rahul Kumar
10 years ago

I mean, what will the formula be if a person puts 4000 rs in a RFD account every month for 10 years and earns, not simple interest but compound interest of 12% pa, the conversion period of which is say, a quarter?

Rahul Kumar
Rahul Kumar
Reply to  Jagoinvestor
10 years ago

But he is putting 4000 every month. That makes it 48000 in a year. Why are we taking 12000?

Rahul Kumar
Rahul Kumar
Reply to  Jagoinvestor
10 years ago

Thank you so much. Understood the concept

Rahul Kumar
Rahul Kumar
10 years ago

Great post. Just one question. What will be the formula if* compounding is also done, say half yearly or quarterly? Rest of the situation remains the same ie. monthly payments of 4000, interest @ 12% pa., years= 10

Karthikeyan
Karthikeyan
11 years ago

Manish, during the payment phase, we are assuming that payments will be compounded monthly, but realistically speaking, no bank in India does monthly compounding, the minimum you can expect is quarterly.

Taking the same example, if monthly payment is Rs. 4000, then quarterly payment is Rs. 12,000. Using the same formula and assuming quarterly compounding, the FV of the corpus (at payment phase) is Rs. 5,88,032 (3% quarterly interest, 30 quarters). The final corpus works out to Rs. 62,57,186, assuming quarterly compounding again.

Let me know if my calculations are correct.

sandeep
sandeep
11 years ago

Hi Manish,

I am planning to start investing 2k PM in MF’s.Do we have the chance of investing more money when the market is down keeping 2k investment as usual.

Thanks,
Sandeep

raj
raj
11 years ago

Sir,

Have joined job recently. Have sister’s marriage down the line in around 2019(7years). Can save and allocate 12000 every month. How should i go about to get maximum returns. Cant take too much risk as objective is marriage.

please suggest options.

regards,

Raj

Ananth
Ananth
13 years ago

Hi Manish

I just came across this website and find it very informative. I have a question for you. Can I use the method articulated above to calculate returns on my VPF contribution. My employer allows me to put aside 88% of my basic for my VPF (Voluntary Provident Fund) which gets compounded at 8.5% PA. The deduction happens on a monthly basis from my payroll but my understanding is that the interest calculation happens once in a year.Can you tell me how I can calculate the return on my VPF where I set aside 9000 rupees per month? How is this same/different from calculating the return on my monthly SIP Mutual Fund investments.

Anand
Anand
14 years ago

Manish – I have a quickie – I have SIPs in large cap oriented HDFC Top 200 and also Reliance Banking fund. I infact have these SIPs on different dates – so if I want to invest 10k in a fund in a month I do it as 5 different SIPs for 2000 each so I can cost average even better ;-). On the days that markets fall 200+ points (roughly, more than 1 %) I pump in a little extra cash into these funds as well by 3 PM – well anticipating the markets would not recover greatly by EOD!

I have read with numbers that the DIP has not beat a monthly SIP over any duration but I am thoroughly convinced that 5 SIPs a month is cost effective even if it only a few rupees or decimals of units.

Now for a regular monthly investment (say 5th of every month) the annualized returns can be calculated. How can I do the same for investments made in a fund some 80 – 90 times as year (5 SIPs per month * 12 plus ~ 30 days that I invest when markets fall more). Any tracker to that effect would be helpful!

trackback
Twitter Weekly Updates for 2010-05-30 » Ranjan Varma's Blog
14 years ago
Pradeep
Pradeep
14 years ago

Hello Manish,

Once again a great article. It will be really appreciated, if along with it you provide some suggestions about where to invest with the fund names or scheme names so that the people who do not have much knowledge about these things get a idea about in which funds and where to invest their money. ( Also mention that the risk factor is involved and it is only a suggestion and people need to invest on their own risk )

But it will be more helpful
Thanks for the article, really helpful

Pradeep
Pradeep
Reply to  Jagoinvestor
14 years ago

Hi Manish,
Thanks but my suggestion was about not just the mutual funds, but a whole portfolio. As there are many people out there who have less knowledge of all these things.
Ofcourse the website is itself a lot whole new learning experience for many people, which itself is a great work by you.

prashanth eyyala
prashanth eyyala
14 years ago

Thanks a Lot Manish, I have found your site to be a enabler. Infact i need to credit you for a lot of planning that i have been able to accomplish on my own. I have juggled my insurance portfolio where i dumped a Bad Endowment Policy and taken the I-Term. Have used the proceeds and the monthly savings to invest in some good SIP. Additionally have made some adjustments in my outlook and investment plan.

I have been searching for this particular formulae for some time now (was lazy to research 🙂 _) . Extremly helpful. Would you be able to help me understand if there is a concept called as the SIP rate of return. If so can you help in the calcuation. Cheers Keep up the Great work.

Krishna
Krishna
14 years ago

Manish,

Taking the example mentioned about ajay’s 4k per month invested for 10 yrs and leaving it to grow for 20yrs . Your calculator gave the following results.

Total Corpus : 3759763

Payment Corpus : 929356

Total amount Paid : 480000

Which is correct the figures mentioned in the article or the calculator ?

Karan Khaitan
Karan Khaitan
14 years ago

Hi Manish,

Good Article. But in your calculation of the total amount, you havent factored in inflation! Even if I take inflation at 6%p.a., the final total of 89,64,840 will actually be worth Rs 15.5 lakhs approx today. Kindly shed some light on this. Thanks!

Prashant
Prashant
14 years ago

Hi Manish,
You really doing greate and really doing “JAGO” investors!!!!

Thanks for the post.

KSL
KSL
14 years ago

I think i wanna see more of such posts since they are something that you don’t see these kind of posts much anywhere.

Cannot express in words how important these calculators are. They can make your aimless life much more meaningful and help plan for the future.

It would be really disappointing not to see more of such posts from you, the owner of one of the best blogs in india or maybe in the whole world.

Keep on posting on topics that are based on everyday life.

KSL

Srikanth Achanta
Srikanth Achanta
14 years ago

write about smart loans please.

saurabh_kdsunita
saurabh_kdsunita
14 years ago

Hi , very nice article.Keep up the good work.Just one question , is it safe to assume that i would be able to earn 15 % for next 30 years ? And has it ever happened from nifty or sensex inception it has given return in negative from medium term to long term basis i.e. from 5-10 year basis ? Thanks in advance.

Atul
Atul
14 years ago

Very informative article.

TS GNANADEV
TS GNANADEV
14 years ago

Manish!!
Good one!will be very usefull for basic investors…also helps to find X amount at the end of specific years time then how much to start investing today…….

Manish
Manish
14 years ago

Actually I would like to it will be better if i stay invested in a single equity fund for 30 years… or If i swicth from 1 equity funds to next equity fund after 10 years and keep the amount invested in first one for next 20 years…