FV Function
Calculate the future value of an investment using the FV function.
Task:
You are planning for retirement and want to know the future value of your savings. Calculate the future value of your investment in cell B7 using the FV function, given the rate, number of periods, payment, and present value.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of FV
0/3The same formula in the other shapes it takes at work.
- FV Function
Calculate the future value of an investment using the FV function.
CoreAdvanced - FV of a one-off deposit
Put money in once and leave it: pmt is 0, pv is the deposit.
Advanced - FV with payments at the start of each month
The type argument: paying in a month earlier earns a month more interest.
Advanced
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | |
|---|---|---|
| 1 | Parameter | Value |
| 2 | Rate | 0.05 |
| 3 | Nper | 10 |
| 4 | Pmt | -1000 |
| 5 | Pv | -10000 |
| 6 | Type | 0 |
| 7 | FV |
Functions used here
What this exercise teachesMay contain the answer
The FV function is essential for financial planning, allowing you to determine the future value of your investments, which is crucial for retirement planning or savings goals.