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: