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: