FVSCHEDULE (PQL - xl)

This function returns the future value of an initial principal after applying a series of compound interest rates. Calculate future value of an investment with a variable or adjustable rate

  • Library: PQL \ Spreadsheet \ Financial
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

FVSCHEDULE(principal, schedule)

Function Arguments

Name

Description

Type

Optional

principal

Present value of the principal

Number

schedule

Schedule, array of interest rates to apply

StringOrNumber

Comments

This function is the same as the Microsoft Excel 'FVSCHEDULE' function - using the same inputs, logic and outputs.