FV

Intermediate

Financial

Calculates future value of an investment based on periodic payments and interest rate. Perfect for savings and investment planning.

Syntax
=FV(rate, nper, pmt, [pv], [type])
Parameters
rate
Required
(number)

Interest rate per period

nper
Required
(number)

Total number of payment periods

pmt
Required
(number)

Payment per period

pv(number)

Present value (optional, default 0)

Examples
Real-world examples to help you understand how to use FV

Savings growth

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

Future value of $500 monthly savings over 10 years at 6% annual rate

Result: $81,939.67

Investment with initial deposit

=FV(5%, 10, -1000, -5000)

Future value with $5,000 initial deposit plus $1,000 yearly

Result: $20,710.19

Common Use Cases
  • ✓Plan retirement savings
  • ✓Calculate investment growth
  • ✓Project education fund value
  • ✓Estimate savings account balance
  • ✓Analyze compound growth
Pro Tips
  • 💡Use negative values for payments you make
  • 💡Higher rate = higher future value
  • 💡Consistent time periods are critical
  • 💡Great for "what will I have" planning
Common Errors
  • ⚠️Forgetting negative sign for payments
  • ⚠️Mixing annual and monthly rates
  • ⚠️Unrealistic rate assumptions
Related Formulas
PVPMTRATENPER

Need a Custom FV Formula?

Our AI can generate tailored formulas based on your specific needs

Generate Custom Formula