September 17, 2021

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

Syntax: =FVSCHEDULE(B1,B4:B7)
Result: \$2,744,537.16

Syntax: =FVSCHEDULE(B1,{0.06;0.07;0.09;0.11})
Result: \$2,744,537.16

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.
READ:  How to use NPV Function in Excel #### Excel

View all posts by Excel →