Spread.NET 17 Formula Reference
Formula Functions / Functions D to G / FVSCHEDULE
In This Topic
    FVSCHEDULE
    In This Topic

    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