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.
Best Excel Course in Hindi
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[/vc_column_text][vc_column_text el_class=”formula”]FV(rate, nper, pmt, [pv], [type])[/vc_column_text][vc_column_text]Where,
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.[/vc_column_text][vc_column_text]
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?
Here Rate: 9%
Nper: 5 years
PMT: Rs.2000 (deposit)
Type: 1 (Here we are assuming that the deposit is made at the beginning of the period.)
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.[/vc_column_text][vc_column_text]