#Shorts How to Calculate the Future Value in Excel The Excel FV function is a financial function that returns the future value of an investment. You can use the FV function to get the future value of an investment assuming periodic, constant payments with a constant interest rate. The future value formula is FV=PV(1+i)n, where the present value PV increases for each period into the future by a factor of 1 + i. The future value calculator uses multiple variables in the FV calculation. In this video, we will uncover some very cool and lesser-known ways of calculating the future value in Excel. We'll start with some basics and then work our way up to some pretty advanced techniques. For this tutorial, we'll be using a spreadsheet that shows the amount of money someone has invested for 12 years at a 12% interest rate.