Documentation/Calc Functions/FVSCHEDULE

From The Document Foundation Wiki
Jump to navigation Jump to search


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:
Fvschedule.png

Examples:

Formula Description Returns
=FVSCHEDULE(1000;{0.03;0.04;0.05}) 1000 currency units have been invested in for three years. The interest rates were 3%, 4% and 5% per annum. The function calculates the value after three years. 1124.76
=FVSCHEDULE(1000;A1:A3) where A1:A3 contains 0.03,0.04,0.05 1000 currency units have been invested in for three years. The interest rates were 3%, 4% and 5% per annum. The function calculates the value after three years. 1124.76

Related LibreOffice functions:

PV

NPER

PMT

RATE

ODF standard:

Section 6.12.21, part 2

Equivalent Excel functions:

FVSCHEDULE