Excel functions / Financial

FVSCHEDULE function

What an amount grows to when the interest rate changes from period to period.

Syntax

=FVSCHEDULE(principal, schedule)

Arguments

When to use it

FVSCHEDULE gives what an amount grows to when the interest rate changes from period to period: each rate in the list is applied in turn.

Examples

  1. 1,000 over three years at 9%, 11% and 10%

    ABC
    1Rate
    29%1330.89
    311%
    410%

    In C2: =FVSCHEDULE(1000, A2:A4) → 1330.89

    Try this example

Common mistakes

FVSCHEDULE in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try FVSCHEDULE in the playground

Related functions