next up previous contents index
Next: GAMMA Up: A. Function Reference Previous: FV   Contents   Index


FVSCHEDULE

Syntax: FVSCHEDULE(P, R)

P = Principal, or present value
R = An array of interest rates by which to compound

FVSCHEDULE returns the future value of an initial principal after compounding by a series of interest rates.

Example:

FVSCHEDULE(100, A1..A4) = 133.4260, where A1..A4 = 7.5%, 6.6%, 8%, 7%

Excel function: N/A


next up previous contents index
Next: GAMMA Up: A. Function Reference Previous: FV   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003