How to use FVSCHEDULE function in Excel?

The `FVSCHEDULE` function in Excel is used to calculate the future value of an initial principal after applying a series of compound interest rates. This can be particularly useful for evaluating investments or savings that have different interest rates over time.

Here’s how to use the `FVSCHEDULE` function:

Syntax

FVSCHEDULE(principal, schedule)
  • `principal`: This is the initial amount of money (the principal) you are investing or saving.
  • `schedule`: This refers to the series of interest rates to apply to the principal. You can input this as a range of cells that contain the interest rates or an array of values. The interest rates should be expressed as decimals (e.g., 5% should be input as 0.05).

Steps to Use `FVSCHEDULE`

  • Enter your Principal: Decide on the initial investment or savings amount.
  • List the Interest Rates: Create a range of cells that include your schedule of interest rates. These should be listed as decimal fractions (e.g., 10% as 0.10).
  • Use the FVSCHEDULE Function: In a new cell, type the `FVSCHEDULE` function. Reference the cell with the principal and the range of cells containing your interest rates.

Example

Suppose you have an initial investment of $1,000, and you want to calculate its future value over three periods with interest rates of 5%, 3%, and 4%.

  • Enter the Principal:

Let’s assume the principal is in cell A1, with a value of `1000`.

  • Enter the Interest Rates:

Assume the interest rates are in cells B1 to B3:

  • Apply the FVSCHEDULE Function:

In a new cell, enter the formula:

   =FVSCHEDULE(A1, B1:B3)
  • Result:

This formula will output the future value of the $1,000 investment after applying the series of interest rates.

Additional Tips

  =FVSCHEDULE(1000, {0.05, 0.03, 0.04})
  • Array Constant: You can also use an array constant directly in the formula like this:
  • Interest Rates as Percentages: Remember to convert percentage rates to decimal form when entering them. For example, 10% should be entered as 0.10.
  • Dynamic Ranges: You can use dynamic ranges if you expect the schedule of interest rates to change, ensuring your `FVSCHEDULE` calculation automatically updates.

With the `FVSCHEDULE` function, you can easily account for varying interest rates over time, providing a more accurate representation of how an investment or savings vehicle will grow.

Unlock Your Potential

Excel

Basic - Advanced

Access

Access Basic - Advanced

Power BI

Power BI Basic - Advanced

Help us grow the project