FVSCHEDULE Function in Google Sheets

Calculate the future value of an initial principal after applying a series of compound interest rates using the FVSCHEDULE function.

FVSCHEDULE Function

The FVSCHEDULE function in Google Sheets calculates the future value of an initial principal after applying a series of compound interest rates.

Syntax

FVSCHEDULE(principal, rate_schedule)
  • principal: The initial amount of money. This is a required parameter.
  • rate_schedule: An array or range containing the interest rates to apply. This is a required parameter.

Examples

  1. Calculate Future Value with Rate Schedule

Calculate the future value of a $1,000 principal with annual interest rates of 5%, 4%, and 3% over three years:

=FVSCHEDULE(1000, {0.05, 0.04, 0.03})

This will output 1,123.64.

Notes

  • The FVSCHEDULE function is useful for evaluating investments with varying interest rates over time.
  • Ensure that the rate_schedule array accurately reflects the compounding periods.
  • FV: Calculate the future value of an investment with a fixed interest rate.
  • NPV: Calculate the net present value of an investment.