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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
