fx =FV(0.07/12,120,-500)ABCLaptop$1,299$1,103.15Monitor$549$466.65Keyboard$179$152.15
💰 Financial

FV Formula for Financial

Calculate future value of an investment. Copy-paste ready for Excel, Google Sheets, and Airtable.

=FV(0.07/12,120,-500)
When you need this: When you plan retirement savings: $500/month, 7% annual return, 10 years (120 months) — what will you have?

How it works

  1. 1Specify the interest rate per period (0.07/12 = monthly 7% annual).
  2. 2Total periods (120 months = 10 years).
  3. 3Monthly payment (-500, negative = outflow).
  4. 4FV returns how much your savings will grow to.

Variations

College fund projection
=FV(0.05/12,216,-300)
FV with lump sum
=FV(0.07/12,120,-500,-10000)

Related Formulas

PMT — Calculate loan payment amountFinancialSUM — Add up a range of numbersMathAVERAGE — Calculate the average of a rangeStatisticalIF — Return different values based on a conditionLogic

Need a formula that's not here?

Generate custom formula →