Spread Formula Reference
FVSCHEDULE
Formula Functions > Functions D to G > FVSCHEDULE

This function returns the future value of an initial principal after applying a series of compound interest rates. Calculate future value of an investment with a variable or adjustable rate.

Syntax

FVSCHEDULE(principal,schedule)

Arguments

This function has these arguments:

Argument Description
principal Present value of the principal
schedule Schedule, array of interest rates to apply

Data Types

Accepts numeric data for both arguments. Returns numeric data.

Examples

FVSCHEDULE(4,A1:C1)

FVSCHEDULE(45,R1C1:R7C1)

FVSCHEDULE(1000,{0.8,0.6,0.7}) gives the result 4896

Version Available

This function is available in product version 1.0 or later.

See Also

FV | Financial Functions