How to Use the FVSCHEDULE Function in Excel

This guide explains how to use FVSCHEDULE Function in Excel, including its syntax, required arguments, practical examples, and common errors.

Description: The function that calculates the future value of an investment with interest.

Syntax : = FVSCHEDULE (principal, schedule) .

Inside:

- principal : The initial value of the investment.

- schedule : an array containing the interest rates to apply.

Attention:

- The values in the array can be either numbers or blank cells, in which case the blank cell is counted as zero (interest = 0).

For example:

Calculate the amount of investment received after 3 years with an initial value of 200,000,000, knowing the interest rates for years, respectively, 0.12, 0.15, and 0.08.

How to Use the FVSCHEDULE Function in Excel screenshot

In the cell to calculate the investment value after 3 years enter the formula: = FVSCHEDULE (B6, C6: E6) .

How to Use the FVSCHEDULE Function in Excel screenshot 2

Press Enter and the result of the investment after 3 years is:

How to Use the FVSCHEDULE Function in Excel screenshot 3

In case the interest rate value is left blank, the function of self-understanding interest rate is 0:

How to Use the FVSCHEDULE Function in Excel screenshot 4

The above is a detailed guide on how to use the FVSCHEDULE function in Excel hoping to help you.

Good luck!

FAQ

What does the FVSCHEDULE function do in Excel?

The FVSCHEDULE function performs the calculation described in this guide. Use the correct arguments and compatible data types for reliable results.

How do I enter the FVSCHEDULE function correctly?

Start with an equals sign, enter FVSCHEDULE, add the required arguments inside parentheses, and confirm that cell references and separators are correct.