ExcelFlux

FVSCHEDULE function

the future value of an initial principal after applying a series of compound interest rates.

Financial

Where can you use it?

Budgeting, treasury and finance teams. When reviewing a scenario with cash flows, payment periods and rate assumptions, compare the input and output units in the example.

Scenario in the workbook

Apply a schedule of varying rates to the opening balance. A negative rate represents a losing period.

A worked example from the workbook

RowABC
6ValueSecond inputAmount
71000.10.2
810000
91000.1-0.1
Record 1
=FVSCHEDULE(A7,B7:C7)

Expected result132

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=FVSCHEDULE(A7,B7:C7)
Turkish Excel · tr-TR
=GDPROGRAM(A7;B7:C7)

Worked examples

Apply a schedule of varying rates to the opening balance. A negative rate represents a losing period.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B C
6 Value Second input Amount
7 100 0.1 0.2
8 100 0 0
9 100 0.1 -0.1
Case Formula Expected result
Record 1 =FVSCHEDULE(A7,B7:C7) 132
Record 2 =FVSCHEDULE(A8,B8:C8) 100
Record 3 =FVSCHEDULE(A9,B9:C9) 99
Microsoft Excel reference