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.
In the cell to calculate the investment value after 3 years enter the formula: = FVSCHEDULE (B6, C6: E6) .
Press Enter and the result of the investment after 3 years is:
In case the interest rate value is left blank, the function of self-understanding interest rate is 0:
The above is a detailed guide on how to use the FVSCHEDULE function in Excel hoping to help you.
Good luck!