FVSCHEDULE()

Description

Calculates the future value of some principal based on a specified series of potentially varying interest rates.

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!