In Excel for Microsoft 365, use the FV function to calculate the future value of regular payments or a starting balance. For example, with a $200 monthly deposit, a 6% annual rate, and a 10-year term, enter the formula below to calculate an ending balance of about $32,775.87. The example assumes B2 contains 200, B3 contains 6%, and B4 contains 10; the deposit is treated as a payment at the end of each month.
=FV(B3/12,B4*12,-B2,0,0)
What Excel’s FV function calculates
FV stands for future value: the value a series of payments or a current balance may reach after earning interest over a specified number of periods. The function is useful for estimating how regular saving, a deposit, or both could accumulate when the interest rate and payment schedule are known.
Excel’s FV function takes five arguments, in this order:
- Rate: The interest rate for one period, such as one month if payments and compounding are monthly.
- Nper: The total number of periods. For 10 years of monthly deposits, that is 120 periods.
- Pmt: The fixed payment made each period. Enter zero if there are no regular payments.
- Pv: The present value, or starting balance. This argument is optional; if omitted, Excel treats it as zero.
- Type: The payment timing. Use 0 for payments at the end of each period, or 1 for payments at the beginning. If omitted, Excel uses 0.
The payment and present-value arguments are optional in the function syntax, but including them explicitly can make a calculation easier to read and check. FV assumes a constant rate and equal payments made at regular intervals. It does not automatically account for changing rates, irregular deposits, taxes, or fees.
Why the signs in the formula matter
Excel’s financial functions use cash-flow direction. Money you pay out is normally entered as a negative amount, while money you receive is positive. In the opening example, the saver pays out $200 each month, so the payment argument is negative. The resulting future value is positive because it represents money accumulated in the account.
If you enter the $200 payment as a positive number while leaving the other arguments unchanged, Excel may return a negative future value. That does not mean the account will literally have a negative balance; it reflects the cash-flow signs supplied to the function. Make the payment and starting-balance signs consistent with the perspective you are using. For a saver, deposits are usually negative outflows and the accumulated balance is a positive inflow.
This sign convention is also why an initial balance is often entered as negative when you want FV to return a positive ending balance. It is a bookkeeping convention in the function, not a judgment about whether the account balance is good or bad.
Set up a reusable FV calculation
Using input cells rather than typing every number into a formula makes it simpler to change the assumptions and compare scenarios. In a blank worksheet, enter these labels and values:
- Put Monthly deposit in A2 and 200 in B2.
- Put Annual interest rate in A3 and 6% in B3.
- Put Years in A4 and 10 in B4.
- Put Future value in A5, then enter the FV formula in B5. The opening example uses the same cell layout.
Format B2 and B5 as Currency, and B3 as Percentage, using the Number group on the Home tab if you want the assumptions and result to be easier to scan. Formatting changes how values appear, not the underlying calculation. Keep the rate stored as a percentage value such as 6%, rather than entering 6 and expecting Excel to interpret it as six percent.
To compare a different contribution, rate, or time horizon, edit B2, B3, or B4. The formula updates automatically. The rate is divided by 12 and the number of years multiplied by 12 because this example uses monthly periods. Those conversions are appropriate only when the annual rate and monthly payment schedule are being treated as a nominal annual rate with monthly periods.
Worked example: monthly deposits over 10 years
Suppose a person deposits $200 at the end of every month for 10 years and assumes a 6% annual interest rate with monthly compounding. There are 120 deposits, and the rate per monthly period is 0.5%. FV calculates the value of those payments, including the interest accumulated on earlier deposits. With B2 set to 200, B3 set to 6%, and B4 set to 10, the formula is =FV(B3/12,B4*12,-B2,0,0), which returns approximately $32,775.87.
The total amount contributed is $24,000: $200 multiplied by 120 months. The remaining approximately $8,775.87 is the modeled growth under the stated assumptions. This comparison helps explain why the result is larger than the sum of the deposits, but it is not a forecast or guarantee. A real account may have variable returns, fees, taxes, contribution changes, or other terms that change the outcome.
Small differences can appear if you compare the result with another calculator. Check whether it assumes payments at the start or end of the month, uses a different compounding convention, or rounds intermediate values. Excel displays a rounded amount when the cell is formatted as currency, while it can retain more precision internally.
Payment timing: end of period or beginning
The type argument changes when each regular payment is made. Type 0 means a payment occurs at the end of its period; this is the usual assumption for an ordinary annuity and is the default when the argument is omitted. Type 1 means payments occur at the beginning of each period. A beginning-of-month deposit earns interest for that month, so it produces a slightly larger ending balance than the same deposit made at month-end.
For the opening example’s inputs—B2 is 200, B3 is 6%, and B4 is 10—the following formula changes only the timing argument from 0 to 1:
=FV(B3/12,B4*12,-B2,0,1)
It returns approximately $32,939.75, about $163.90 more than the end-of-month result. This is an illustrative difference, not a promise about a particular savings product. Check whether the real account credits interest daily, monthly, or under another method, and when deposits actually post.
Using FV for a single starting balance
FV can also project a lump sum without recurring payments. For instance, suppose B7 contains a starting balance of 10,000, B8 contains an annual rate of 5%, and B9 contains 8 years. With no periodic payment, enter:
=FV(B8,B9,0,-B7)
The formula returns approximately $14,774.55, assuming annual periods, a constant 5% rate, and no deposits or withdrawals during the eight years. The zero is the periodic payment argument; the starting balance is negative so the future value appears as a positive amount. This is an example of compound growth: interest earned in earlier years is included in the balance that earns interest in later years.
When the compounding period is not annual, make the rate and number of periods match that schedule. For example, a monthly calculation needs a monthly rate and the number of months, not a monthly payment paired with an annual period count. If the quoted rate is an effective annual rate rather than a nominal annual rate, dividing it by 12 does not produce the equivalent monthly rate; use the rate definition given by the account or contract.
Common FV errors and how to check them
- Rate and period do not match: A monthly payment schedule generally needs a monthly rate and a total number of months. Using an annual rate with 120 monthly periods exaggerates growth.
- Wrong number of periods: Convert years to months for monthly payments, or keep both rate and period count annual for annual payments.
- Payment sign is reversed: If the result has an unexpected sign, review whether the payments and starting balance represent money going out or coming in.
- Wrong timing assumption: Confirm whether deposits are made at the beginning or end of a period. The type argument controls this for regular payments.
- Unrealistic constant-rate assumption: FV applies the rate supplied to every period. It does not simulate market ups and downs or a rate that changes over time.
- Rounding too early: Avoid rounding the rate or intermediate calculations unnecessarily. Format the output for display instead of changing the stored values.
A useful check is to compare the result with total contributions. For a saver who contributes regularly and earns a positive rate, the modeled ending value will generally exceed the amount contributed when interest is credited and the assumptions hold. If it does not, inspect the signs, rate, period count, payment timing, and any starting balance before assuming Excel has malfunctioned.
When to use another approach
FV is a good fit when payments are equal, arrive at regular intervals, and use a constant rate. It is less suitable when deposits vary month to month, withdrawals occur at irregular times, or the rate changes. For uneven cash flows, a period-by-period worksheet can make each date and amount visible; the calculation then needs to apply the relevant rate and timing to each cash flow rather than treating all payments as identical.
FV is also different from present value. Future value asks what cash flows may amount to later, while present value asks what a future amount or payment stream is worth today under a chosen rate. A loan amortization schedule is another distinct task: it tracks each payment’s interest and principal rather than just returning one ending value. Choose the calculation that matches the question you are actually trying to answer.
For budgeting or planning, treat an FV result as a scenario based on assumptions, not a guaranteed balance. Compare more than one plausible rate or contribution amount, and account for costs that the formula does not include. For decisions involving a real account, loan, investment, tax, or contract, check the actual terms with the lender or a qualified professional; this example is educational, not financial, tax, investment, or legal advice.
Frequently Asked Questions
What does FV mean in Excel?
FV means future value. It calculates the value of an investment or series of regular payments at a later point, based on a rate, number of periods, payment amount, starting value, and payment timing.
How do I calculate future value with monthly deposits?
Use a monthly rate and the total number of months, enter the recurring deposit as a negative payment from the saver’s perspective, and choose the correct timing. In the worked example, a $200 end-of-month deposit and a 6% annual rate over 10 years produce about $32,775.87 under the stated assumptions.
Why does Excel FV return a negative number?
Excel is applying its cash-flow sign convention. Check whether the payment and present-value inputs use the intended signs. If the saver’s deposits are positive, Excel may return a negative future value; entering deposits as negative outflows typically produces a positive accumulated balance.
What does the type argument do in FV?
Type specifies payment timing: 0 means payments at the end of each period, and 1 means payments at the beginning. If omitted, Excel assumes end-of-period payments. Use the timing that matches the real payment schedule.
Can FV calculate compound interest on a deposit with no monthly contributions?
Yes. Set the payment argument to zero, enter the starting balance as the present value with the appropriate cash-flow sign, and use periods and a rate that match the compounding schedule. The lump-sum example above shows an eight-year annual calculation.
Final check before relying on the result
Before using an FV result, verify that the rate is for one period, the period count covers the full term, the payment sign is intentional, and the timing argument reflects when money moves. Then confirm whether the formula’s constant-rate and regular-payment assumptions fit the question. Those checks make the result easier to interpret and help prevent a mathematically valid formula from answering the wrong financial question.
Related
- Excel Data Validation Restrictions and Their Limits
- Data Validation Process: Steps, Checks, and Best Practices
- Data Validation Named Range in Excel: Setup and Fixes
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Upper Quartile Formula in Excel: How to Find Q3 CorrectlyIn Excel, use =QUARTILE.INC(A2:A20,3) to find the upper quartile, or third quartile (Q3), of the numbers in A2:A20.…
- Excel Days Until End of Month: Formula and ExamplesWith no input cells needed, enter =EOMONTH(TODAY(),0)-TODAY() to calculate the number of days from today to the last…
- Count Unique Values in Excel with a Simple FormulaTo count distinct, nonblank entries in a column in Microsoft 365, enter =IFERROR(ROWS(UNIQUE(FILTER(A2:A100,A2:A100<>""))),0) in an empty cell, replacing…
- INDEX MATCH With Two MATCH Functions: Practical ExamplesYes: the standard two-way lookup uses INDEX with one MATCH to find a row and a second MATCH…
- Power Query Custom Column IF Statement: ExamplesTo write an IF statement in a Power Query custom column, use M’s if … then … else…
- VLOOKUP Showing Formula? Causes and Fixes in ExcelIf VLOOKUP is showing as text instead of returning a result, first turn off Formulas > Show Formulas;…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.