# Documentation/Calc Functions/FVSCHEDULE

Jump to navigation Jump to search

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:

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

FVSCHEDULE