Documentation/Calc Functions/FVSCHEDULE

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

FVSCHEDULE

Category:

Financial Analysis

Summary:

Calculates the accumulated value of the starting capital for a series of periodically varying interest rates.

Syntax:

FVSCHEDULE(Principal; Schedule)

Returns:

Arguments:

Principal is the starting capital.

Schedule is a series of interest rates, for example, as a range H3:H5 or as a (List) (see example).

Additional details:

Examples:

1000 currency units have been invested in for three years. The interest rates were 3%, 4% and 5% per annum. What is the value after three years?

=FVSCHEDULE(1000;{0.03;0.04;0.05}) returns 1124.76.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: