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.