What is FV?

The FV (Future Value) function calculates the future value of an investment based on a constant interest rate and regular payments.

Syntax

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

Example Data

Item

Value

Monthly Investment

5,000

Annual Interest Rate

8%

Investment Period

5 Years

Initial Investment

0

Formula

=FV(8%/12,5*12,-5000,0)

Result is approximately:

367,329

Why Use FV?

FV can be used for:

  • Investment planning
  • Savings planning
  • Retirement projections
  • Regular monthly investments

Practice

Create a Future Value Calculator with:

  • Monthly Investment
  • Annual Interest Rate
  • Investment Period
  • Future Value
PreviousNext