Calculates the future value of some principal based on a specified series of potentially varying interest rates.
Description
How To Use in Sheets
FVSCHEDULE(principal, rate_schedule)
External Links
Google Sheets FVSCHEDULE Function | Future Value | Variable Interest Rates | Google Sheets Functions
Use the Google Sheets FVSCHEDULE function to calculate the future value of an amount with a variable interest rate in some or all of the years of the investment period. For example, in a three-year investment time frame, the interest rates could be 3%, 4%, and 5% in the first, second, and third year respectively. The two inputs the FVSCHEDULE function requires are the investment amount and the schedule of the interest rates.
0Better Sheets Tutorials
No videos yet. Stay tuned!