## Calculate future value excel formula

As to what that error could be, I have no way to tell since I cannot examine the formulas in the cells. The number of periods used for the calculation. If each year is broken into two periods and you calculate the FV for 5 years, this number would be 10. Pmt. 10 Feb 2015 Future value calculation is very handy in getting the maturity amount of your FD, RD and Annuity. The calculation is very easy in Excel. Learn Every step. I have used simple interest formula to get interest of one year.