FVSCHEDULE function - Returns the future value of an investment that has variable or adjustable interest in period in Excel

The following article details the meaning and usage of the FVSCHEDULE function - Returns the future value of an investment that has an interest rate that changes or can be adjusted periodically in excel.

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.

FVSCHEDULE function - Returns the future value of an investment that has variable or adjustable interest in period in Excel Picture 1

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

FVSCHEDULE function - Returns the future value of an investment that has variable or adjustable interest in period in Excel Picture 2

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

FVSCHEDULE function - Returns the future value of an investment that has variable or adjustable interest in period in Excel Picture 3

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

FVSCHEDULE function - Returns the future value of an investment that has variable or adjustable interest in period in Excel Picture 4

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

Good luck!