FVSCHEDULE function

FVSCHEDULE(principal, schedule) FVSCHEDULE(principal; schedule)

principal — Number or { Number }

The initial value of the lump sum.

schedule — { Number }

An array containing a schedule of interest rates which apply each period.

Returns — Number or { Number }

The future value of a lump sum, with changing future interest rates.

Returns the future value of a lump sum, with changing future interest rates.

Example

FVSCHEDULE(1000, { 5%, 6%, 7% })FVSCHEDULE(1000; { 5%; 6%; 7% })

Returns roughly $1,190.91, the future value of $1,000 in three years' time, where you believe the interest rates will be 5% in the first year, 6% in the second year and 7% in the third year.

Partly derived from the OpenOffice.org documentation, licensed under the Apache License 2.0.