Related Function:

The FVSCHEDULE function calculates the Future Value of an investment with a variable interest rate.

Syntax

=FVSCHEDULE(principal,schedule)

Arguments

Argument Description
principal The present value of the investment
schedule An array of values, that provides the schedule of interest rates to be applied to the principal

  If provided as a range of cells, these may contain numeric values or be empty (empty cells denote a zero interest rate)

Examples

The following spreadsheet shows the FVSCHEDULE function used to calculate the future value of an investment of $10,000, over 3 years. The investment earns interest of 9% during the first year, 10% the 2nd year, and 11% the 3rd year.

  A B C
1 Formula Result Notes
2 =FVSCHEDULE(10000,{0.09,0.10,0.11}) $13,308.90 Future value of $10,000 with compound annual interest rates of 9%, 11%, and 10%

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if any of the supplied arguments are non-numeric

(blank cells as a part of the schedule array are acceptable and are treated as the numeric value 0)
#NAME? Occurs when Analysis ToolPak add-in is not enabled