FVSCHEDULE()

Syntax. FVSCHEDULE(Capital,Interest)

Definition. This function calculates the final value for capital with variable period interest rates.

Arguments

  • 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 ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.