deepcalc
DocsFVSCHEDULE

FVSCHEDULE

View as markdown/docs/functions/fvschedule.md Ask Claude about this pageOpens Claude with this page's address

Future value under a schedule of compound rates.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number

Examples

=FVSCHEDULE(2, B1:B10)
B
1 2
2 4
3 6
4 8
5 10
Result 20790

Syntax

FVSCHEDULE(principal, schedule)
principal
number required
schedule
range required
ACCRINTAccrued interest for a security paying periodic interest. ACCRINTMAccrued interest for a security paying at maturity. AMORDEGRCDepreciation per period, French accounting, degressive. AMORLINCDepreciation per period, French accounting, linear. COUPDAYBSDays from coupon period start to settlement. COUPDAYSDays in the coupon period containing settlement.