FVSCHEDULE

  • Updated

Calculates the accumulated future value of principal for a series of rates.

Sample Usage

FVSCHEDULE(1000,A2:A100)
FVSCHEDULE(B2,C2:C20)
 

Syntax

FVSCHEDULE(principal, schedule)

  • principal - The starting capital.
  • schedule - An series of interest rates to apply.

Examples

FVSCHEDULE(1000,A2:A100) returns the future value of a staring capital of 1000 with compound annual interest rates.