Skip to content

Excel function · Financial

Excel FV function

FV works out what regular deposits, or a starting amount, will grow to at a fixed rate of return: the balance after 3 years of putting 300 a month into a savings account, for example.

In Turkish Excel: GD

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

English Excel=FV(rate, nper, pmt, [pv], [type])
Turkish Excel=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

ArgumentRequiredDescription
rateRequiredThe return per period; for monthly deposits, the annual rate divided by 12.
nperRequiredThe total number of periods (deposits), e.g. 36 months for 3 years.
pmtRequiredThe amount deposited each period; negative because it leaves you. Use 0 if you only have a lump sum.
pvOptionalA lump sum deposited at the start, also negative. 0 if omitted.
typeOptional0 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.

E2fx=FV(C2/12,D2,B2)
The end balance of monthly savings: example table
ABCDEFG
1PlanMonthly DepositAnnual ReturnMonthsEnd BalanceTotal Paid InReturn
2Plan A-300.004.50%3611,539.8310,800.00739.83
3Plan B-300.004.50%6020,143.6718,000.002,143.67
4Plan C-800.004.00%2419,954.3119,200.00754.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).

E2fx=FV(B4/12,B5,B3,B2)
Savings with a starting lump sum and monthly deposits: example table
ABCDE
1ItemValueCaseEnd Balance
2Starting Sum-5,000.00Deposits at month end11,735.96
3Monthly Deposit-250.00Deposits at month start11,759.46
4Annual Return4.50%
5Months24
  • 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

Type this in Nexell

Add end balance and total return columns to my savings plan table based on the monthly deposit, annual return and term

Convert to table

Bring 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.

Related functions

All financial functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free