FVSCHEDULE

Description Computes the future value of an investment after applying a series of compounded interest rates.

Syntax FVSCHEDULE (value, schedule)

Argument Description

value The starting value of the investment (the principal).

schedule A list of interest rates for the compounding periods. This may be a range reference or an array constant. The number of values in schedule is the number of periods for compounding interest. An empty cell or 0 value will indicate no interest earned in that period.

Argument	Description
value	The starting value of the investment (the principal).
schedule	A list of interest rates for the compounding periods. This may be a range reference or an array constant. The number of values in schedule is the number of periods for compounding interest. An empty cell or 0 value will indicate no interest earned in that period.

Examples This function returns 1367.52:

FVSCHEDULE(1000,{0.2,0.21,0.22})

See Also FV