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:

FVSCHEDULE Function - How to use FVSCHEDULE Function in Excel

Syntax: =FVSCHEDULE(B1,B4:B7)

Result:

FVSCHEDULE Function in Excel - How to use FVSCHEDULE Function in Excel

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 YIELD Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *