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