FV

Returns the value of an annuity at the time of the final payment. Here, annuity is a series of equal payments made at equal points in time.

Syntax

FV(Payment, InterestRate, Periods)

Payment is the amount paid. InterestRate is the interest rate paid per period. Periods is the number of periods in the annuity. Payments are assumed to be made at the close of each period. All arguments must be numbers or formulas which return numbers.

Examples

The value of an annuity at the end of 10 years, with payments of $10,000 per year at 10% interest. This example returns -159374.25:

FV(10000, 0.10, 10)

The value of an annuity at the end of 10 years, with payments of $100 per month at 10% per year, is represented by:

FV(100, .10/12, 120)

-20484.50 is returned.