FVSCHEDULE

FVSCHEDULE(principal, schedule)

Returns the future value of an initial principal after applying different compound interest rates.

principal	The present value.
schedule	The array of interest rates.

REMARKS

* This function can be used to calculate future value of an investment with a variable or adjustable rate.
* This function assumes the rates are annual and the compounding is annual.
* The "principal" is the current present value of the investment.
* The "schedule" can be numbers or blank cells.
* If "schedule" contains empty cells then these are taken as zeros (no interest).
* If "schedule" is not a range reference then the rates must be entered as an Array Constant.
* If "schedule" is not numeric, then #VALUE! is returned.
* The number of values in "schedule" is the number of periods for compounding interest.
* A zero or an empty cell indicates no interest earned in that period.
* The FV function assumes a fixed interest rate, it cannot handle different rates in different periods.
* If you want to use semi-annual compounding divide the interest rate by 2 and double the number of interest rates.
* You can use the FV function to return the future value of a series of equal cash flows at regular intervals.
* You can use the EFFECT function to return the effective interest rate given a nominal interest rate and compounding frequency.
* You can use the PV function to return the present value of a series of equal cash flows at regular intervals.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=FVSCHEDULE(1000, {0.02}) = $1,020.00
2	=FVSCHEDULE(1000, {0.05, 0.06, 0.07}) = $1,190.91
3	=FVSCHEDULE(1000, {0.09, 0.1, 0.11}) = $1,330.89
4	=FVSCHEDULE(1000, {0.02, 0.021, 0.022}) = $1,064.33
5	=FVSCHEDULE(500, {0.01, 0.02, 0.03, 0.04}) = $551.78
6	=FVSCHEDULE("text", {0.1}) = #VALUE!

1 - What is the future value of a $1000 investment that pays 2% interest for one year.
2 - What is the future value of a $1000 investment that pays 5% interest (first year), 6% interest (second year) and 7% interest (third year).
3 - What is the future value of a $1000 investment that pays 9% interest (first year), 10% interest (second year) and 11% interest (third year).
4 - What is the future value of a $1000 investment that pays 2% interest (first year), 2.1% interest (second year) and 2.2% interest (third year).
5 - What is the future value of a $500 investment compounded semi-annually that pays 1% (first 6 months), 2% (second 6 months), 3% (third 6 months) and 4% (fourth 6 months)
6 - If principal is not numeric.