# FVSCHEDULE

The FVSCHEDULE function 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`: The PPMT function calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate.

`PMT`: The PMT function calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.

`NPER`: The NPER function calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.

`IPMT`: The IPMT function calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate.

`FV`: The FV function calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate.

### Examples

Was this article helpful?
How can we improve it?