Documentation/Calc Functions/FVSCHEDULE

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:
Returns the accumulated value given starting capital as Principal and a series of interest rates as Schedule.

Arguments:
Principal is a real number or a reference to the cell containing that number which is the starting capital.

Schedule is an array/name/reference to a list of real numbers which is a series of interest rates.


 * If the Principal is not a real number or Schedule is not an array/name/reference to a list of real numbers then the function returns #VALUE! error.

Additional details:

 * The formula for FVSCHEDULE is:

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/PV PV]

[[Special:MyLanguage/Documentation/Calc_Functions/NPER NPER]

[[Special:MyLanguage/Documentation/Calc_Functions/PMT PMT]

[[Special:MyLanguage/Documentation/Calc_Functions/RATE RATE]

ODF standard:
Section 6.12.21, part 2

Equivalent Excel functions:
FVSCHEDULE