FVSCHEDULE

Formulas / FVSCHEDULE
Calculate the future value of a single sum using a schedule of interest rates.

=FVSCHEDULE(Principal, schedule)

Principal - required, the present value of the investment
Schedule - required, an array of values that specifies the schedule of interest rates to be applied to the principal

Examples

=FVSCHEDULE(100,{0.05})
To calculate the future value of a one-year investment of $100 in an account with an annual interest rate of 5%, use the FVSCHEDULE function. The result is $105, the future value of the initial investment after one year.
=FVSCHEDULE(200,{0.03,0.04,0.05})
Using the FVSCHEDULE function, you can also calculate the future value of a three-year investment of $200 in an account with increasing interest rates each year. The annual interest rates in the first, second, and third year are 3%, 4%, and 5%, respectively. The result is $214.32, the future value of the initial investment after three years.
=FVSCHEDULE(500,{0.08,0.07,0.06,0.05,0.04})
With the FVSCHEDULE function, you can also calculate the future value of a five-year investment of $500 in an account with decreasing interest rates each year. The annual interest rates in the first, second, third, fourth, and fifth year are 8%, 7%, 6%, 5%, and 4%, respectively. The result is $576.37, the future value of the initial investment after five years.

The FVSCHEDULE function is used to calculate the future value of an investment with a variable or adjustable rate and compound interest.

The FVSCHEDULE function can be used to calculate the future value of a single sum based on a schedule of interest rates, with variable or adjustable rates.
The FV and PV functions can be used to calculate the future value of a sum based on a given interest rate.

What is the FVSCHEDULE function?

The FVSCHEDULE function computes the future value of an investment using compound interest. It takes two arguments, principal and schedule.

Is the principal argument required?

Yes, the principal argument is required.

Is the schedule argument required?

Yes, the schedule argument is required.

What is the schedule argument?

The schedule argument is an array of interest rates to apply.

What types of interest rates can be used?

The interest rates in schedule can be numbers or blank cells, and they are not required to be numbers.