# FVSCHEDULE

### Definition of FVSCHEDULE

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

### Sample Usage

`FVSCHEDULE(10000,A2:A100)`

`FVSCHEDULE(10000,{0.1,0.95,0.9,0.85})`

`FVSCHEDULE(A2,B2:B20)`

### Syntax

`FVSCHEDULE(principal, rate_schedule)`

`principal`

- The amount of initial capital or value to compound against.`rate_schedule`

- 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`

.

### See Also

`PV`

: Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate.

`PPMT`

: Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate.

`PMT`

: Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.

`NPER`

: Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.

`IPMT`

: Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate.

`FV`

: Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate.

### To use the FVSCHEDULE Formula, simply begin with your edited Excellentable:

### Then begin typing the FVSCHEDULE formula in the area you would like to display the outcome:

### By adding the values you would like to calculate, Excellentable generates the outcome: