FV Function

FV Function is used for calculating the future value of a current amount of money. As discussed in Time Value of Money, value of an amount of Money changes over time. FV Function helps us for calculating how much a current amount money will value in future.

Snytax for FV() Function:

FV(rate;Nper;Pmt;PV;Type)

PV – Present Value

rate – Interest Rate

Nper – Payment Periods

Pmt – Payment

FV – Future Value

Type1 if payment is at the beginning of the period, 0 if payment is at the end of the period

You need to provide first 3 variables in order FV() Function to work. Last 2 variables are optional.

Example1:

For compound interest rate calculations, see Compound Interest in Excel.

George asks John for a loan of 20,000$ and promises to pay him 1,100$ for 20 months. Should John give George the money or should he invest money on different things to earn more? (assuming annual interest rate is 15%)

Our formulation with PV() Function for this deal is:

PV=(15%/12 ; 20 ; -1100$ ; 0 ; 0) = 24,819$

So 1000$ monthly payments for 20 months will be equal to 24,819$ 20 months later. If John would put his money in a compound interest, he would get 25,640$ at the end of 20 months. John should pass on this offer because current offer is not in his favor.

Example2:

Jane gives her 50,000$ to an investor for 2,000$ monthly payments for 24 months and 10,000$ one time payment at the end of 24 months. Is this investment profitable for Jane? (assuming annual interest rate is 15%)

Our formulation with FV() Function for this deal is:

FV=(15%/12 ; 24 ; -2,000$ ; 10,000$ ; 0) = 14,525$

If Jane would have put her money on compound interest, she would get 67,367$ in return. Since her current deal will get her 69,050$, this deal is profitable for Jane.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *