FVSCHEDULE

<Syntax>:

FVSCHEDULE ( principal , schedule )

Description: Computes the future value of an initial principal after applying a series of compound interest rates.

Note: : This function can be used to calculate the future value of an investment with a variable or adjustable rate.

Arguments:

Name	Type	Description
principal	number	The present value.
schedule	array	Set of interest rates to apply. The values in this array can be numbers or blank cells. Blank cells are taken as zeros (i.e., no interest).

Return Type and Value: number – The future value of an initial principal after applying a series of compound interest rates.

However, if any element of the array schedule is not a number and not blank, #VALUE! is returned.

example: