Investment Studio > Expressions > Functions > Financial > FVSCHEDULE

float fvschedule(float principal, float array rate_schedule)

Returns the future value of a principal amount given a series of compounded interest payments, as specified by rate_schedule.

All elements in rate_schedule are converted to floats (with exclusion if conversion fails).

Example

Five years of compounded interest at the annual rates of 2%, 3.5%, 4%, 3%, 3.5% will grow USD 1000 to

=fvschedule(1000, {2%, 3.5%, 4%, 3%, 3.5%})

» USD 1170.45.

See also fv, ipmt, nper, pmt, ppmt, pv, rate.