Excel
FVSCHEDULE function in Excel
Returns the future value of an initial principal after applying a series of compound interest rates
=FVSCHEDULE(principal, schedule)FVSCHEDULE syntax and parameters
Two arguments, two required.
- principalnumberRequired
The present value.
- schedulearrayRequired
An array of interest rates to apply.
FVSCHEDULE examples
Formulas you'll actually reuse.
$10,000 after three years at 5%, then 4%, then 6%:
=FVSCHEDULE(10000, {0.05, 0.04, 0.06})Result
11575.2A principal grown through a column of ten yearly rates:
=FVSCHEDULE(B2, C2:C11)
FVSCHEDULE in Google Sheets
Same name — your formula ports as-is.
Try FVSCHEDULE in the playground
Edit the example — nothing to install.
Preloaded with the FVSCHEDULE formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Excel gets this done.
- ACCRINTReturns the accrued interest for a security that pays periodic interestFinancialGoogle Sheets
- ACCRINTMReturns the accrued interest for a security that pays interest at maturityFinancialGoogle Sheets
- AMORDEGRCReturns the depreciation for each accounting period by using a depreciation coefficientFinancialNo Google Sheets equivalent
- AMORLINCReturns the depreciation for each accounting periodFinancialGoogle Sheets
- COUPDAYBSReturns the number of days from the beginning of the coupon period to the settlement dateFinancialGoogle Sheets
- COUPDAYSReturns the number of days in the coupon period that contains the settlement dateFinancialGoogle Sheets