Description Returns the future value of an annuity based on regular payments and a fixed interest rate.
Syntax FV ( interest, nper, payment [, pv] [, type] )
| Argument | Description |
|---|---|
| interest | The fixed interest rate. |
| nper | The number of payments in an annuity. |
| payment | The fixed payment made each period. |
| [pv] | Optional. The present value, or the lump sum amount, the annuity is currently worth. If this argument is omitted, 0 is used. |
| [type] | Optional. 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. If you omit this argument, 0 is used. |
Remarks The units used for interest must match those used for nper. For example, if the annuity has an 8 percent annual interest rate over a period of 5 years, specify 8 percent/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.
Examples This function returns 4,774.55:
This function returns 531,550.86:
See Also CUMIPMT, CUMPRINC, FVSCHEDULE, IPMT, NPER, PMT, PPMT, PV, RATE
