How to calculate future value of investment using excel or calculator if any: initial investment say as on today + yearly lumpsum contribution may be in any month say when sensex is down by 1000 points on any day in year…. for eg. initial investment – 100000 every year contribution of indifferent amount say 50000 in year 1 55000 in year 2 33000 in year 3 and so on for say 20 years… how to calculate future value in this case assuming return @15% at the end of 20 years?

It is easy to calculate the future value of investment using Excel spreadsheet. You need to use FV function you enter a rate of return, amount and detail of periodic or one-time investments and number of periodic investments.

Given these parameters, the FV function computes the future value of the specified investment.

In a cell of Excel enter =FV(rate,nper,pmt,pv,type)

Enter respective value and you will get answer.