Skip to main content

FVSCHEDULE function

The FVSCHEDULE function is one of the financial functions. It is used to calculate the future value of an investment based on a series of changeable interest rates.

Syntax​

FVSCHEDULE(principal, schedule)

The FVSCHEDULE function has the following arguments:

ArgumentDescription
principalThe current value of an investment.
scheduleAn array or a range of interest rates.

Notes​

Schedule values can be numbers or empty cells (they are interpreted as 0).

How to apply the FVSCHEDULE function.

Examples​

The figure below displays the result returned by the FVSCHEDULE function.

FVSCHEDULE Function