Practice free

FVSCHEDULE function

FVSCHEDULE compounds a starting amount through a list of different interest rates, one per period, and returns the result. It suits variable-rate investments where each year's rate differs.

Example

Read it as a sentence: grow 1000 by the rates in U1:U3 one after another (5%, 6% and 4%), which gives 1157.52.

Practice this in the app

Syntax

FVSCHEDULE(principal, schedule)

principal (required)
Starting amount.
schedule (required)
Range or array of interest rates, one per period.

Returns: Principal grown through the series of rates.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=FVSCHEDULE(1000,{0.05,0.06}) 1113 Array
=FVSCHEDULE(1000,{-1}) 0 Negative rate
=FVSCHEDULE("1000",{0.05}) 1050 Text number principal
=FVSCHEDULE(1000,Data!U1:U3) 1157.52 Range
=FVSCHEDULE(1000,Data!D1:D3) 1000 Blank rates (0)
=FVSCHEDULE(1000,{0.05,"a"}) #VALUE! Text in array
=FVSCHEDULE(1000,{0.05,"0.06"}) #VALUE! Text number in array
=FVSCHEDULE(1000,{TRUE}) #VALUE! TRUE in array

The Data sheet these formulas read

A cell that starts with = holds that formula.

Watch out for

  • Rates are applied in order, so each entry is one period.
  • Blank cells in the schedule count as zero.

Where it works

Excel
FVSCHEDULE is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Financial functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .