Future value

Returns the future value of an investment based on periodic, constant payments and a constant interest rate. The future value is equal to the present value plus the amount of accumulated interest that would be earned. This can be applied to future payments, with interest calculated for each payment.

Syntax

Fv <Type> (Rate, Nper, Pmt, Pv)

Where:

Rate is the interest rate per period.

Nper is the total number of payment periods.

Pmt is the (fixed) amount paid each period. This typically includes principal and interest, but no other fees or taxes.

Pv is the present value (lump-sum amount) of future payments. If no value is provided, it is assumed to be 0 (zero).

Type is a parameter that indicates when payments are due.

Usage Notes

In all cases, disbursements, such as deposits, are represented by negative numbers; funds received, such as dividends, are represented by positive numbers.

Use the Fvschedule function for payments made with a variable or adjustable interest rate.