FV Function in Excel
Advanced
Calculates the future value of an investment based on a constant interest rate.
Syntax
=FV(rate, nper, pmt, [pv], [type])Example
Use Case
Calculate how much an investment will be worth in 10 years.
Common Errors to Avoid
- Rate must match payment period frequency
- Result sign convention: deposits negative, withdrawals positive
- Forgetting to enter pmt as negative for contributions
Pro Tips
For monthly contributions, divide annual rate by 12 and multiply years by 12. Enter regular payments as negative values. Use type=1 if payments occur at period start.
Need help with this formula?
Our AI Formula Generator can write this for you instantly.
Try AI Formula Generator →