What it does
FV works with compound growth: each period's return is added to the balance for the next period. The rate and the periods must use the same unit; for monthly deposits, divide the annual rate by 12 and count the periods in months.
The sign rule: money you put into the account leaves you, so it is negative, and the amount you get back at the end comes out positive. =FV(0.045/12,36,-300) returns, as a positive number, the balance after 36 monthly deposits of 300. If you also put in a lump sum at the start, enter it as the fourth argument, also negative.
To find the monthly amount needed to reach a target, use PMT; for the present value use PV, and for the time needed use NPER. The returns in the examples are assumptions; taxes and fees are not included.
Syntax
=FV(rate, nper, pmt, [pv], [type])=GD(oran; dönem_sayısı; devresel_ödeme; [bd]; [tür])Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|---|---|
rate | Required | The return per period; for monthly deposits, the annual rate divided by 12. |
nper | Required | The total number of periods (deposits), e.g. 36 months for 3 years. |
pmt | Required | The amount deposited each period; negative because it leaves you. Use 0 if you only have a lump sum. |
pv | Optional | A lump sum deposited at the start, also negative. 0 if omitted. |
type | Optional | 0 or omitted: deposits at the end of each period. 1: at the start, so each deposit earns one more period of return. |
Examples
1The end balance of monthly savings
The monthly deposit is money going into the account, so it is negative in column B. Column E gives the end balance, column F the total paid in and column G the return earned. The returns are assumptions.
=FV(C2/12,D2,B2)| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Plan | Monthly Deposit | Annual Return | Months | End Balance | Total Paid In | Return |
| 2 | Plan A | -300.00 | 4.50% | 36 | 11,539.83 | 10,800.00 | 739.83 |
| 3 | Plan B | -300.00 | 4.50% | 60 | 20,143.67 | 18,000.00 | 2,143.67 |
| 4 | Plan C | -800.00 | 4.00% | 24 | 19,954.31 | 19,200.00 | 754.31 |
- E2 (filled down to E4)
=FV(C2/12,D2,B2) - F2 (filled down to F4)
=-B2*D2 - G2 (filled down to G4)
=E2-F2
Because the deposit is negative, the balance comes out positive: 11,539.83 for Plan A. Keeping it up for 60 months gives 20,143.67, and the return's share grows noticeably: 2,143.67.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
2Savings with a starting lump sum and monthly deposits
Both the starting lump sum and the monthly deposit leave you, so both are negative. E2 treats deposits as made at the end of each month, E3 at the start (type 1).
=FV(B4/12,B5,B3,B2)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item | Value | Case | End Balance | |
| 2 | Starting Sum | -5,000.00 | Deposits at month end | 11,735.96 | |
| 3 | Monthly Deposit | -250.00 | Deposits at month start | 11,759.46 | |
| 4 | Annual Return | 4.50% | |||
| 5 | Months | 24 |
- E2
=FV(B4/12,B5,B3,B2) - E3
=FV(B4/12,B5,B3,B2,1)
With a starting sum of 5,000 and 250 a month, the balance after 24 months is 11,735.96. Depositing at the start of each month gives every deposit one more month of return: 11,759.46.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
Common errors and fixes
- Negative result
Cause: The deposit was entered as a positive number, so Excel treated it as money coming to you and returned the future value as negative.
Fix: Enter deposits as negative numbers:
=FV(0.045/12,36,-300).- Result far too large
Cause: The annual rate was used with monthly periods without dividing by 12.
Fix: Put the rate in the same unit as the periods.
- #VALUE!
Cause: One of the arguments is text that cannot be read as a number.
Fix: Make sure the cells really hold numbers.
Good to know
- The return earned is the future value minus the total paid in; the total paid in is the monthly amount times the number of periods.
- To see the compound effect of an annual rate paid monthly, use EFFECT:
=EFFECT(0.045,12).
In Nexell
Get Nexell to do it from a sentence
Add end balance and total return columns to my savings plan table based on the monthly deposit, annual return and term
Convert to tableBring your savings table into the tool and type this. Nexell adds both columns with real Excel formulas and shows them in the preview; in the downloaded file, the balances change when you change the rate.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
How do I calculate the future value of monthly savings in Excel?
Use =FV(annual_rate/12,months,-monthly_amount). For example, for 300 a month for 3 years at 4.5% a year, =FV(0.045/12,36,-300). The deposit is negative, so the result is positive.