# Documentation/Calc Functions/FVSCHEDULE

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

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

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

## ODF standard:

## Equivalent Excel functions:

FVSCHEDULE