O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required