Excel functions / Financial
FVSCHEDULE function
What an amount grows to when the interest rate changes from period to period.
Syntax
=FVSCHEDULE(principal, schedule)
Arguments
principal: The starting amount.schedule: The interest rate for each period.
When to use it
FVSCHEDULE gives what an amount grows to when the interest rate changes from period to period: each rate in the list is applied in turn.
Examples
1,000 over three years at 9%, 11% and 10%
A B C 1 Rate 2 9% 1330.89 3 11% 4 10% In C2:
=FVSCHEDULE(1000, A2:A4)→ 1330.89
Common mistakes
- Rates as whole numbers. 9% is 0.09. Typing 9 multiplies the amount by 10.
FVSCHEDULE in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: FVSCHEDULE
- Danish: FVTABEL
- Dutch: TOEK.WAARDE2
- Finnish: TULEVA.ARVO.ERIKORKO
- French: VC.PAIEMENTS
- German: ZW2
- Hungarian: KJÉ
- Italian: VAL.FUT.CAPITALE
- Norwegian: SVPLAN
- Polish: WART.PRZYSZŁ.KAP
- Portuguese (Brazil): VFPLANO
- Portuguese (Portugal): VFPLANO
- Russian: БЗРАСПИС
- Spanish: VF.PLAN
- Swedish: FÖRRÄNTNING
- Turkish: GDPROGRAM
Try FVSCHEDULE in the playground