Formula Library

FV

financial

Calculates the future value of an investment based on periodic, constant payments and a constant interest rate.

Syntax

=FV(rate, nper, pmt, [pv], [type])

Example

Excel
=FV(6%/12, 120, -500)

Calculates the future value of saving $500/month for 10 years (120 months) at 6% annual interest — the result is what the account will be worth.

Tips & Notes

  • →Rate must match period (divide annual rate by 12 for monthly)
  • →Payment is negative when money leaves your pocket
  • →Add PV if you have an existing balance

See Also

PMTNPVIRR

Need a custom FV formula?

Describe exactly what you need and get the formula generated instantly.

Generate →

We use cookies and display ads via Google AdSense to keep ExcelBossPro free. Privacy Policy. By continuing, you accept our use of cookies.