FV

See also A-Z Spreadsheet Function List

Description Returns the future value of an annuity based on regular payments and a fixed interest rate.

Syntax FV(interest, nper, payment [, pv] [, type])

interest is the fixed interest rate.

nper is the number of payments in an annuity.

payment is the fixed payment made each period.

pv is the present value, or the lump sum amount, the annuity is currently worth. When you omit this argument, a present value of 0 is assumed.

type indicates when payments are due. Use 0 if payments are due at the end of the period or 1 if payments are due at the beginning of the period. When you omit this argument, 0 is assumed.

Remarks The units used for interest must match those used for nper. For example, if the annuity has an 8% annual interest rate over a period of 5 years, specify 8%/12 for interest and 5*12 for nper.

         Cash paid out, such as a payment, is shown as a negative number. Cash received, such as a dividend check, is shown as a positive number.

See Also IPMT , NPER , PMT , PPMT , PV , and RATE functions

Examples FV(5%, 8, -500) returns 4,774.55

         FV(10%/12, 240, -700, 1) returns 531,550.86