Definition. This function calculates the final value for capital with variable period interest rates.
Principal (required) The capital that will receive interest payments.
Schedule (required) A list of the
interest rates for the periods without gaps, which follows the required order. This argument can be
a cell reference or a matrix (values inside of braces, separated by commas). Values that cannot be
evaluated as numbers cause the error
#VALUE!. Empty cells are handled as if they
had the number zero.
Background. This calculation takes into consideration the fact that the interest is added to the capital at the end of the period:
Period end value = (Period start value) · (1 + Period interest ...