Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
FV
FV computes how much a series of equal periodic payments, or a lump-sum investment, will be worth at the end of a specified number of periods at a given interest rate. It is essential for retirement planning, savings projections, and evaluating the growth of recurring deposits.
Excel
=FV(0.06/12,120,-200,0,0)Google Sheets
=FV(0.06/12,120,-200,0,0)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Rate | Nper | Pmt | PV | FutureValue |
| 0.005 | 120 | -200 | 0 | |
| 0.005 | 60 | -500 | 0 | |
| 0.00417 | 240 | -100 | 0 | |
| 0.005 | 12 | -1000 | -5000 |
=FV(0.06/12,120,-200,0,0)→32775.8693612916
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Determine your periodic interest rate (annual rate ÷ periods per year), number of periods, and periodic payment.
- 2Type =FV(rate, nper, pmt, [pv], [type]) — use a negative pmt value for money paid out.
- 3The result is the future value; format it as currency for readability.
Need a version for your data?
Try: “If I invest $200 per month for 10 years at 6% annual interest, what will I have?”