FUTURE_VALUE_SCHEDULE

Future value by schedule

Description

Calculates a given principal's future value using a specified collection of potentially varying interest rates.

Function signature

FUTURE_VALUE_SCHEDULE(principal: Number, rateschedule: Array) => Number

Parameter

Description

Principal

The amount of initial capital or value to compound against

Rate schedule

A series of interest rates to compound against the principal

Examples

Formula

Return value

FUTURE_VALUE_SCHEDULE(1, [1, 2, 3, 4, 5])

720

FUTURE_VALUE_SCHEDULE(2, [1, 2, 3, 4, 5])

1440

FUTURE_VALUE_SCHEDULE(-1, [1, 2, 3, 4, 5])

-720

FUTURE_VALUE_SCHEDULE(1, [1, -2, 3, 4, 5])

-240