How to Use the FV Function in Excel: Examples and Tips

Formulas & functions · Updated November 20, 2026

In Excel, use the FV function to calculate the future value of an investment or a series of regular payments: enter a rate per period, the number of periods, and any recurring payment. For example, =FV(5%,3,0,-1000) returns $1,157.63 for $1,000 growing at 5% per year for three years, assuming no additional deposits.

What the FV function calculates

FV stands for future value. The function projects what money may be worth at the end of a specified number of periods when an interest rate and, optionally, regular payments are applied. It is useful for questions such as how much a savings balance could grow, what a series of monthly contributions could accumulate to, or how a loan balance might change under regular payments.

The calculation assumes that the interest rate stays constant and that each payment is the same amount and occurs at regular intervals. Those are mathematical assumptions, not a guarantee about an actual account or investment. Real rates, fees, taxes, payment rules, and returns can differ. Use the terms supplied by the bank or other provider when modeling a real product.

FV works for savings and borrowing calculations, but the result is not automatically a prediction. In particular, an investment with variable returns will not necessarily grow at a steady rate from period to period. FV is best understood as a way to calculate a defined scenario.

Arguments and payment timing

The FV arguments are entered in this order: rate, nper, pmt, pv, and type. The first three are required; pv and type are optional. In plain language, they mean:

  • rate: The interest rate for one payment period, not necessarily the annual rate.
  • nper: The total number of periods in the calculation.
  • pmt: The payment made in each period. Use the same amount and interval throughout the calculation.
  • pv: The present value, or amount already in the account at the start. If omitted, Excel treats it as zero.
  • type: When each recurring payment occurs: 0 means at the end of the period, while 1 means at the beginning. If omitted, Excel uses 0.

Match the units of rate and nper. For monthly contributions over five years, use a monthly rate and 60 periods. For quarterly contributions over five years, use a quarterly rate and 20 periods. Putting an annual rate together with a monthly period count is a common mistake because it applies a full year of interest every month.

Calculate the future value of one deposit

Suppose you want to estimate a $1,000 deposit earning 5% annually for three years, with no further deposits. With the annual rate in B1 (5%), the number of years in B2 (3), and the starting deposit in B3 (1000), enter:

=FV(B1,B2,0,-B3)

The result is approximately $1,157.63. That agrees with the calculation $1,000 × 1.05 × 1.05 × 1.05 = $1,157.625, rounded to cents. The zero in the payment position says there are no recurring deposits. The starting balance is entered as a negative value in the formula because Excel uses opposite signs for money paid in and money received later.

You can also enter numbers directly, as in the opening example, but cell references make a worksheet easier to update. Change the rate or time period in the input cells and the result recalculates without editing the formula.

Model regular monthly contributions

FV can also include recurring deposits. Imagine contributing $100 at the end of every month for 10 years, with an assumed annual rate of 5% divided evenly across 12 months. With the annual rate in B1 (5%), years in B2 (10), and monthly contribution in B3 (100), enter:

=FV(B1/12,B2*12,-B3,0,0)

The result is approximately $15,528.24. The formula uses a monthly rate, 120 monthly periods, a negative $100 payment, no starting balance, and type 0 for payments at each month’s end. The total contributions are $12,000 (120 × $100); the difference between that amount and the future value comes from the modeled interest. This is an illustrative calculation, not a promise of an account’s return.

If deposits happen at the beginning of each month instead, use type 1. Each deposit then has one additional period to earn interest, so the future value is a little higher under the same rate and other assumptions. Choose the timing that matches the real payment schedule rather than selecting the option simply because it produces a larger number.

Choose a rate and period that match

Before using FV, decide what one period means in your model. If payments are monthly, use a monthly rate and a count of months; if payments are annual, use an annual rate and a count of years. For a nominal annual rate quoted as 5% with monthly compounding, dividing by 12 is a common modeling convention. Confirm how a real product defines its rate and compounding before relying on that conversion.

Rate conventions matter. A stated annual percentage rate, an effective annual rate, and a rate after fees are not necessarily interchangeable. If a quoted annual figure is already an effective annual yield, dividing it by 12 may not reproduce the equivalent monthly rate. When precision matters, use the provider’s stated compounding method or ask a qualified professional how to interpret the quoted rate.

Likewise, don’t set nper to 10 just because a plan lasts 10 years if it makes monthly payments. For monthly periods over 10 years, the period count is 120. The rate and period count must describe the same interval for the result to make sense.

Understand Excel’s positive and negative results

Excel’s financial functions use a cash-flow sign convention: money you pay out is negative, and money you receive is positive. In a savings example, a contribution from you is negative and the future account value is positive. That is why the examples put the deposit or payment in the formula as a negative number.

If you enter both a starting balance and recurring payments as positive values, Excel may return a negative future value. That result is usually a sign-convention issue, not evidence that the calculation failed. Reverse the sign of the cash amounts to represent money paid in versus money received. Do not change signs arbitrarily; make sure they reflect the direction of the cash flows in the scenario.

The sign also helps distinguish the perspective being modeled. A borrower receiving loan proceeds and later making payments has cash flows in the opposite direction from a saver depositing money and later withdrawing a balance. A mathematical result is easier to interpret when the signs match one consistent point of view.

Enter FV in Excel and check the result

In Excel for Microsoft 365 on Windows, select a cell for the result and type the formula beginning with an equals sign. Press Enter to calculate it. You can also select the Insert Function button (fx) beside the formula bar, search for FV, and fill in the function’s arguments. The Formulas tab’s Function Library includes financial functions, where FV can be selected. In Excel for Mac, the same FV function and formula syntax are available; ribbon placement can differ slightly by version. Excel for the web also supports the function.

For a readable model, keep assumptions in separate cells and label them clearly—for example, annual rate, payment per month, years, and payment timing. Format the result as currency if it represents money, and retain enough decimal places while checking calculations. A displayed value rounded to whole dollars may hide small differences that matter when comparing scenarios.

Check a result by asking whether it passes a basic reasonableness test. With a positive interest rate and positive deposits over time, a savings future value should generally exceed the sum of deposits when interest is earned. With zero interest, the ending value should reflect the starting balance and total payments, subject to the signs used. Unexpected results often point to a mismatched period, a wrong sign, or a rate entered in the wrong units.

Common problems and alternatives

  • Wrong period units: A monthly payment count paired with an annual rate overstates growth. Convert the rate and number of periods to the payment interval.
  • Wrong payment timing: The default is payment at the end of the period. Use type 1 only when payments are actually made at the beginning.
  • Unexpected negative answer: Review the signs for pmt and pv. Cash paid out and cash received should have opposite signs.
  • Changing payments: FV assumes equal, regular payments. If deposits vary, a single FV payment argument may not represent the cash flows accurately; model each dated cash flow separately or use a method suited to the schedule.
  • Unchanging rate assumption: One rate applies throughout the FV calculation. A scenario with different rates over time needs a period-by-period model rather than one constant-rate FV calculation.

FV is related to, but different from, Excel’s PV function. FV works forward from a starting balance and payments to an ending value; PV discounts future payments or a future amount back to a value today. NPER can solve for the number of periods under specified payment and rate assumptions, while RATE can solve for a periodic rate in supported cash-flow setups. These functions do not remove the need to define cash-flow signs and period timing consistently.

Frequently Asked Questions

What does FV mean in Excel?
FV means future value. It calculates the ending value of a current amount, regular payments, or both, assuming a specified rate and number of periods.

What is the type argument in FV?
Type tells Excel when recurring payments occur. Use 0, or leave it out, for payments at the end of each period; use 1 for payments at the beginning.

Why is my FV formula negative?
Excel uses opposite signs for money going out and money coming in. If your deposits and starting balance are both entered with the same sign, the resulting future value may be negative. Review the cash-flow direction represented by each input.

Can FV calculate monthly compound interest?
Yes. Use the monthly rate and the total number of months. For a nominal annual rate modeled as monthly, that often means dividing the annual rate by 12 and multiplying the number of years by 12, while checking that this matches the rate convention being used.

Does FV include taxes, fees, or changing returns?
No. FV calculates the scenario represented by its inputs; it does not automatically account for taxes, fees, inflation, or rates that change over time. Add relevant assumptions separately or build a more detailed model.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.