deepcalc
DocsFV

FV

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

Returns future value of an investment.

  • Excel: Verified match
  • Google Sheets: Verified match
  • Returns: Number

Examples

=FV(0.06/12, 120, -200)
Result 32775.8693612916

Syntax

FV(rate, nper, pmt, [pv], [type])
rate
number required
nper
number required
pmt
number required
pv
number optional defaults to 0
type
number optional defaults to 0
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.