FV Excel Formula: Syntax, Examples, and Tips

Formulas & functions · Updated November 20, 2026

Excel’s FV function calculates the future value of savings or a loan-related cash flow using a constant interest rate and regular payment periods. Supply the rate per period, number of periods, payment, and—if needed—a starting balance and payment timing; the result is the value at the end of the final period.

What the FV function calculates

FV stands for future value. It answers questions such as how much regular deposits might add up to after several years, or what a current sum could grow to at a stated rate. The function can account for both a present value, such as an opening balance, and a repeated payment, such as a monthly contribution.

Excel assumes the rate and payment schedule are consistent from period to period. A monthly savings plan therefore needs a monthly rate and a count of monthly periods. FV does not automatically interpret a rate as annual or turn years into months; those conversions are up to the person building the worksheet.

The result is a mathematical projection based on the supplied inputs, not a promise of a real-world return. It does not account for changing rates, fees, taxes, inflation, or irregular deposits unless those factors are separately modeled.

Arguments and required inputs

FV accepts five arguments. The first three are essential, while the last two are optional:

  • rate: the interest rate for one payment period.
  • nper: the total number of payment periods.
  • pmt: the payment made each period. If there is no recurring payment, use zero.
  • pv: the present value, or starting balance. If omitted, Excel treats it as zero.
  • type: when payments occur: 0 or omitted means the end of each period; 1 means the beginning.

For example, a plan with monthly deposits over five years has 60 periods, not five. If the quoted rate is an annual nominal rate and interest is compounded monthly, divide that rate by 12 to get the rate for one month. The rate, payment frequency, and period count must all describe the same interval.

How to set up an FV calculation

Put each assumption in a clearly labeled cell before writing the function. This makes it easier to update the rate or schedule and reduces the risk of mixing annual and monthly values. A useful setup is to keep the annual rate, periodic payment, term, and opening balance in separate cells.

  1. Choose the time unit for one period, such as a month or a year.
  2. Convert the interest rate to that period and express the total term as a number of those periods.
  3. Enter each payment and starting balance using consistent cash-flow signs.
  4. Choose whether payments occur at the end or beginning of each period.
  5. Check that the answer is plausible and that the assumptions match the actual account terms.

In Microsoft 365 for Windows, type the function directly into a cell and press Enter. Excel’s formula suggestions can help identify the arguments, but they do not decide whether your rate and period units are appropriate. The same FV function is available in Excel for Mac and Excel for the web; interface details may differ, but the calculation logic is the same.

Worked example: monthly savings

Suppose a person deposits $200 at the end of every month for five years, and the account earns a steady 6% nominal annual rate compounded monthly. Put 6% in B1, -200 in B2, and 5 in B3. The negative payment represents money paid into the account from the saver’s point of view. With those values in place, enter:

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

The result is approximately $13,954.01. There are 60 deposits, and each earlier deposit earns interest for more months than a later one. The total amount contributed is $12,000; the remaining roughly $1,954.01 is the modeled growth under the stated assumptions. This example assumes deposits are made at each month’s end and that the rate stays constant.

If the same deposits are made at the beginning of each month, the layout stays the same—B1 is 6%, B2 is -$200, and B3 is five years—but the timing argument changes:

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

This returns approximately $14,023.78. Each payment has one additional month to earn interest compared with an end-of-month payment, so the future value is slightly higher. The difference is small in this example, but payment timing can matter more with larger deposits, longer periods, or higher rates.

Calculating the growth of a starting balance

FV can also project a single amount without recurring deposits. For a simple annual example, put 4% in D1, 5 in D2, and -10000 in D3. The negative starting balance follows Excel’s cash-flow sign convention, and the zero payment means no additional money is added each year:

=FV(D1,D2,0,D3)

The result is approximately $12,166.53. That is the future value of $10,000 after five annual periods at 4%, with annual compounding and no withdrawals or additional deposits. The omitted type argument defaults to 0, which is appropriate here because there are no recurring payments to time.

You can combine an opening balance and regular contributions as well. If B4 contains -1000 as an opening amount, while B1, B2, and B3 retain the monthly example’s values, use:

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

It returns approximately $15,302.86: the projected value of the $1,000 opening balance plus the monthly deposits. This treats both amounts as contributions made from the same perspective, so both are entered as negative cash flows.

Rate, compounding, and payment timing

A common source of confusion is the difference between an annual rate and a periodic rate. If a plan pays monthly, FV needs a monthly rate and a monthly period count. Entering 6% as the rate while also using 60 monthly periods would apply 6% every month, which is very different from a 6% annual rate divided across monthly periods.

Dividing by 12 is suitable when the stated rate is a nominal annual rate with monthly compounding. If a financial product instead gives an effective annual rate, converting it to an equivalent monthly rate requires a different calculation. Read the rate definition and compounding terms rather than assuming every annual percentage should be divided by 12.

The type argument is about when each repeated payment happens, not how often interest is quoted. Type 0 means a payment at the end of a period, which is common for monthly deposits made after a month has passed. Type 1 means payment at the beginning, so the payment earns interest during that period. If type is omitted, Excel uses end-of-period timing.

Why FV uses positive and negative amounts

Excel’s financial functions use a cash-flow sign convention: money going out from one perspective is negative, and money coming back is positive. For a saver, deposits into an account are outflows, so entering a negative payment usually produces a positive FV representing the accumulated account value. A positive payment may instead produce a negative result.

A negative result does not necessarily mean the arithmetic failed. It often means the inputs use signs that do not match the intended perspective. Check the signs of pmt and pv before changing the rate or payment count. For a savings projection, a typical setup uses negative contributions and a positive future value; for a borrowing calculation, the appropriate signs depend on whether the loan proceeds or repayments are being viewed as the cash inflow.

Common mistakes and ways to check the answer

  • Using years as the period count for monthly payments: multiply years by 12 when payments and compounding periods are monthly.
  • Using the annual rate in a monthly calculation: convert the rate to a monthly rate when the quoted rate is nominal and monthly compounding applies.
  • Entering every cash flow with the same sign: use opposite signs for money paid in and money received if you expect a positive result.
  • Choosing the wrong type: confirm whether deposits happen at the start or end of each period. Omitting type means end of period.
  • Expecting a guaranteed forecast: FV assumes the rate and schedule stay constant; actual account results may differ.

Sanity-check the result against the total deposits. In the monthly example, deposits alone add up to $12,000, so a result of about $13,954 is plausible at a positive rate over five years. A result far larger than expected may indicate that an annual rate was applied monthly, or that the period count is too high. A very small result may indicate that five was entered instead of 60, or that the monthly rate was entered as a whole number rather than a percentage.

FV compared with related Excel functions

FV works forward from a rate and payment plan to a future amount. PV works in the opposite direction: it calculates a current value for future cash flows. PMT calculates the regular payment required for a loan or savings target when the other key values are known. NPER finds the number of periods, and RATE estimates a periodic rate based on the other inputs.

These functions share the same general financial logic and sign conventions, but they answer different questions. Choose the one that matches the unknown in your problem rather than trying to make FV solve for a payment or rate. Also check that inputs use consistent periods across whichever function you choose.

Frequently Asked Questions

What does FV mean in Excel?
FV means future value. It estimates what a present balance and/or a series of regular payments will be worth after a specified number of periods at a stated periodic rate.

What does type 0 or 1 mean in FV?
Type 0, or leaving the argument out, means payments occur at the end of each period. Type 1 means they occur at the beginning. Use the timing that matches the actual payment schedule.

Why is my FV result negative?
Excel’s financial functions use positive and negative signs to distinguish cash inflows from outflows. If the result’s sign is unexpected, review the signs used for the payment and starting balance; the calculation may be valid even if the perspective is reversed.

Can FV calculate monthly compound interest?
Yes. Use a monthly rate and the total number of months. For a nominal annual rate compounded monthly, that generally means dividing the annual rate by 12 and multiplying the number of years by 12.

Does FV include taxes, fees, or inflation?
No. FV calculates from the rate and cash flows you provide. To model fees, taxes, inflation, or changing returns, you need additional assumptions and calculations; confirm real account terms with the provider or a qualified professional.

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.