The Excel FVSCHEDULE function returns the future value of a single sum based on a schedule of given interest rates. FVSCHEDULE can be used to find the future value of an investment with a variable or adjustable rate.
Get future value of principal compound interest
=FVSCHEDULE (principal, schedule)
principal - The initial investment sum.
schedule - Schedule of interest rates, provided as range or array.
The FVSCHEDULE function calculates the future value of a single sum based on a schedule of interest rates. The interest rates can vary in each period. As such, FVSCHEDULE can be used to find the future value of an investment with a variable or adjustable rate.
By contrast, the FV function can also be used to find the future value of a sum based on a given interest rate, it can't handle different rates in different periods.
In the example shown, an initial sum of $1000 is invested for 4 years. In each year, the rate is different as shown below:
In the example, the rates are entered in the range C8:C11. The formula in F5 is:
The values in schedule can provided as a range of cells (per the example) or an array constant. For example, the formula below provides the principal as C5, but rates are hardcoded into an array constant:
The Excel FV function is a financial function that returns the future value of an investment. You can use the FV function to get the future value of an investment assuming periodic, constant payments with a constant interest rate.
The Excel PV function is a financial function that returns the present value of an investment. You can use the PV function to get the value in today's dollars of a series of future payments, assuming periodic, constant payments and a constant...