FVSCHEDULE

Scripting Formulas Finance

FINANCE.FVSCHEDULE

FINANCE.FVSCHEDULE(amount, rate_schedule...)

Calculates the future value of an initial principal, after applying a series of compound interest rates.

  • amount: The present value.

  • rate_schedule: A comma-separated list of interest rates as decimals to compound against the principal amount.

    FINANCE.FVSCHEDULE(100, 0.1, 0.2, 0.3, 0.1)