How to use FVSCHEDULE Function in Excel

The Excel FVSCHEDULE function returns the future value of a single sum based on a schedule of given interest rates. FVSCHEDULE can be used to find the future value of an investment with a variable or adjustable rate

Syntax:= FVSCHEDULE (principal, schedule)

The FVSCHEDULE function syntax has the following arguments:

1. Principal (required argument) – This is the present value of the investment.
2. Schedule (required argument) – This is an array of values that provides the schedule of interest rates to be applied to the principal.

Example: Let’s look at some Excel FVSCHEDULE function examples and explore how to use the FVSCHEDULE function as a worksheet function in Microsoft Excel:

Syntax: =FVSCHEDULE(B1,B4:B7)

Result:

Based on the Excel spreadsheet above, the following FVSCHEDULE examples would return:

Note:

1. Principal (required argument) – This is the present value of the investment.
2. Schedule (required argument) – This is an array of values that provides the schedule of interest rates to be applied to the principal.