FV(P, R, N)

 

Description

This function returns the future value of an annuity given periodic payment P, interest rate R, and N number of periods.  The function is given by:

 

 

Parameters

 

P

Periodic payment.

 

R

Interest rate.

 

N

Number of periods.

 

Examples

 

FV(100, 0.085, 5) = 592.54

 

FV(G7, C2, 2) = 6240

Where C2 = 8% and G7 = 3000.00.

 

FV(1000, 0.075, 1.5) = #Error

"Period" must be an integer greater than 0.