Skip to content
Google Sheets

FVSCHEDULE function in Google Sheets

Calculates the future value of some principal based on a specified series of potentially varying interest rates.

=FVSCHEDULE(principal, rate_schedule)

FVSCHEDULE syntax and parameters

Two arguments, two required.

  • principalnumberRequired

    The amount of initial capital or value to compound against.

  • rate_schedulerangeRequired

    A series of interest rates to compound against the principal. rate_schedule must be either a range or array containing the interest rates to compound, in sequence. These should be expressed either as decimals or as percentages using UNARY_PERCENT, i.e. 0.09 or UNARY_PERCENT(9) rather than 9.

FVSCHEDULE examples

Formulas you'll actually reuse.

  1. $10,000 after three years at 5%, then 4%, then 6%:

    =FVSCHEDULE(10000, {0.05, 0.04, 0.06})

    Result11575.2

  2. A principal grown through a column of ten yearly rates:

    =FVSCHEDULE(B2, C2:C11)

FVSCHEDULE in Excel

Same name — your formula ports as-is.

Try FVSCHEDULE in the playground

Edit the example — nothing to install.

Preloaded with the FVSCHEDULE formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.