FVSCHEDULE
Formulas / FVSCHEDULECalculate 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.
Summary
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.
Frequently Asked Questions
What is the FVSCHEDULE function?
Is the principal argument required?
Is the schedule argument required?
What is the schedule argument?
What types of interest rates can be used?
