Skip to content
Excel

FV function in Excel

Returns the future value of an investment

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

FV syntax and parameters

Five arguments, three required.

  • ratenumberRequired

    The interest rate per period.

  • npernumberRequired

    The total number of payment periods in an annuity.

  • pmtnumberRequired

    The payment made each period; it cannot change over the life of the annuity. Typically, pmt contains principal and interest but no other fees or taxes. If pmt is omitted, you must include the pv argument.

  • pvnumberOptional

    The present value, or the lump-sum amount that a series of future payments is worth right now. If pv is omitted, it is assumed to be 0 (zero), and you must include the pmt argument.

  • typenumberOptional

    The number 0 or 1 and indicates when payments are due. If type is omitted, it is assumed to be 0.

FV examples

Formulas you'll actually reuse.

  1. What $200 a month grows to over 10 years at 5%:

    =FV(5%/12, 120, -200)

    Result31056.46

  2. A single $10,000 deposit after 10 years at 4%, no further payments:

    =FV(4%, 10, 0, -10000)

    Result14802.44

FV in Google Sheets

Same name — your formula ports as-is.

Try FV in the playground

Edit the example — nothing to install.

Preloaded with the FV formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.