Future value of annuity payments and (optional) initial lump sum receipt.

Syntax: @fv(r, n, x[, v, bf])

r: number

n: integer

x: number

v: (optional) number

bf: (optional) number

Return: number

Compute future (negative) value of payment of an n-period annuity, with payments x and rate r, and optional receipt of (positive) initial lump sum v.

If n is not an integer, the integer floor will be used.

A non-zero value for the optional bf indicates that the payments are made at the beginning of periods (annuity due) instead of ends (ordinary annuity).

• The future value of an initial lump sum followed by n-periods of ordinary annuity payments:

• The future value of an initial lump sum followed by annuity due payments is:

Examples

= @fv(0.05, 10, 100, 1000)

returns the value 371.1054, meaning that the issuer of the annuity stands to profit $371.11 once payments are done.

Cross-references