FV Function | How to Use FV Function in Excel

FV Function

FV stand for Future Value. FV function is the last of the financial keys. Future Value helps us to calculate the future value of the investment for the investment made today. FV function is used when you what to know what return will you obtain if you invest something today at the same interest rate and for a constant period of time.

It will be easy to calculate if you know the monthly or yearly investment you need to make, the constant interest rate at which you’ll invest and the time period for which investment is made.

Note: Future Value will always be greater than the Present Value.

The Formula to Calculate Future Value

FV(rate, nper, pmt, [pv], [type])


FV stands for the future value which we will yield.

Rate stands for the interest rate at which investment is to be made.

Nper stand for the time period investment has to be done.

PV stands for the Present value of the investment

Type stand for the time at which investment is to be made at the beginning or at the end of the year

The arguments in the formula with Box brackets are optional.

Example of FV Function

We make Deposit of Rs.2000 every year for 5 years. The rate at which deposit is made is 9%. What will be the future value of the deposits made today?

FV Function - Data Example


Here Rate: 9%

Nper: 5 years

PMT: Rs.2000 (deposit)

PV: 0

Type: 1 (Here we are assuming that the deposit is made at the beginning of the period.)

FV Function in Excel

You can check whether your future value is correct by going through the lengthy process which is explained in the video.

Note: We took the same example of Present value to prove that Future Value will be greater than the present value.

Hope you like our tutorial on FV Function for more cool and amazing trick of excel Like our Excel Superstar Facebook Page and subscribe to our Excel Superstar YouTube channel. Excel Superstar is the leading online training company, which provides Online Excel Course in Hindi. Connect with us and become an Excel Superstar.