Excel FV Function Examples: How to Calculate Future Value

Excel’s FV function calculates the future value of an investment or savings plan from a fixed interest rate and regular payments. For example, to grow $10,000 at 5% annually for 10 years, use =FV(5%,10,0,-10000); the result is $16,288.95.

What the FV function calculates

FV stands for future value: the value that money, or a series of payments, may reach after interest accumulates over a specified number of periods. It is useful for estimating a savings balance, comparing payment schedules, or projecting how a starting amount grows. The function assumes the rate and payment pattern supplied to it stay consistent throughout the calculation.

Excel’s syntax is FV(rate, nper, pmt, [pv], [type]). The first three arguments are required; the last two are optional. The brackets in the syntax indicate optional arguments and are not typed into the formula.

rate: The interest rate for each period, such as a monthly rate when periods are months.
nper: The total number of periods. For monthly deposits over five years, this is 60.
pmt: The payment made in each period. Use 0 if there is no recurring payment.
pv: The present value, or starting balance. If omitted, Excel treats it as 0.
type: When payments occur: 0 or omitted means at the end of each period; 1 means at the beginning.

Example: Calculate the future value of a lump sum

Suppose $10,000 is deposited once in an account earning 5% per year, compounded annually, and left untouched for 10 years. Enter the annual rate in B2, the number of years in B3, the starting amount in B4, and 0 in B5 for the recurring payment. With those values in B2:B5, use:

=FV(B2,B3,B5,-B4)

The result is $16,288.95. The formula compounds the starting balance for 10 periods; there are no additional payments. The minus sign before B4 reflects Excel’s cash-flow convention, not a loss. This sign convention is explained below.

If the account compounds monthly rather than annually, the rate and period count must both change. A 5% nominal annual rate with monthly compounding uses 5% divided by 12 and 10 multiplied by 12. That gives 120 monthly periods. The result will differ slightly from annual compounding because interest is added more frequently.

Example: Add a fixed amount every month

Now consider deposits of $200 at the end of each month for five years, with a 6% nominal annual rate compounded monthly. Enter 6% in B2, 5 in B3, and 200 in B4. B2 holds the annual rate, B3 the number of years, and B4 the monthly deposit. Use:

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

The result is approximately $13,954.01. The deposits total $12,000 before interest, so the higher future value includes the interest earned over time. The formula uses a monthly rate of 0.5%, 60 periods, no opening balance, and end-of-month payments. The last argument, 0, makes the payment timing explicit; it could be omitted because 0 is the default.

In a real workbook, put the annual rate and years in separate cells rather than hard-coding them into the formula. That makes it easy to compare scenarios by changing an input without editing the calculation. Format the result cell as Currency or Number with two decimal places if you want a readable display.

Example: Payments at the beginning of each period

Some savings contributions are made at the start of a month, not at its end. If the same $200 deposits are made at the beginning of each month, interest has an extra month to accrue on each payment. Keep the same inputs as the monthly example—annual rate in B2, years in B3, and payment in B4—and change the type argument to 1:

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

The result is approximately $14,023.78, about $69.77 more than the end-of-month schedule. That difference is the effect of timing, not a change in the payment amount or interest rate. Type 1 applies to all regular payments in the calculation; it does not mean that the initial balance is deposited at the beginning. The starting balance is handled separately by pv.

Example: Use quarterly periods

FV is not limited to years or months. Suppose $1,000 earns a nominal annual rate of 4%, compounded quarterly, for three years, with no further deposits. Put 4% in B2, 3 in B3, and 1,000 in B4; B4 is the starting balance. Use zero for the recurring payment:

=FV(B2/4,B3*4,0,-B4)

The result is approximately $1,126.83. Dividing the annual rate by four gives a quarterly rate of 1%, and multiplying three years by four gives 12 quarters. This illustrates the key rule: rate and nper must describe the same period. If payments are quarterly but the rate is monthly, convert one or both so each period in the formula corresponds to the intended interval.

How Excel handles positive and negative cash flows

Excel’s financial functions use a cash-flow sign convention. Money paid into an account is normally entered as a negative cash flow, while money received from it is positive. In a savings projection, the deposits are outflows from the saver’s perspective, so pmt is negative; the future balance is money received, so FV returns a positive value.

For a starting deposit, the same logic applies to pv. In the lump-sum example, the starting $10,000 is entered as negative so the future balance can appear positive. If both the payment and starting balance are entered as positive amounts, Excel may return a negative future value. That does not mean the calculation has failed; it reflects the chosen cash-flow signs. For a simple display, enter the cash invested as negative and the future amount as positive.

Negative values may be appropriate in other contexts. The signs should represent the direction of cash moving from a particular point of view, and the result should be interpreted consistently. Do not change signs solely to make a result look attractive without checking what the inputs mean.

Choosing the right rate, period count, and payment timing

Most mistakes in FV calculations come from mixing time units or using a rate that does not match the scenario. Before writing the formula, decide what one period means. If one period is a month, enter a monthly rate and count months; if it is a quarter, use a quarterly rate and count quarters.

Check the rate basis: A stated annual rate is not automatically a monthly rate. For a nominal annual rate divided into monthly periods, use annual rate divided by 12.
Count periods, not calendar labels: Five years of monthly contributions means 60 payments, not 5.
Match payment frequency: A monthly payment belongs with monthly periods. If deposits happen at a different frequency from the compounding periods, a simple FV setup may not represent the arrangement as stated.
Choose the correct type: Use 0 for payments at period-end and 1 for payments at period-start. Check the actual schedule rather than guessing.
Distinguish nominal from effective rates: Dividing a nominal annual rate by 12 assumes that rate is quoted for conversion to monthly periods. A published effective annual rate may need a different conversion to obtain the equivalent monthly rate.

For example, an effective annual rate r corresponds to a monthly rate of (1+r)^(1/12)-1, rather than simply r/12. The correct conversion depends on how the rate is quoted in the account terms. For an actual account, verify compounding, fees, rate changes, and deposit timing against the provider’s terms; FV is a mathematical estimate, not a promise of a particular return.

Common errors and how to fix them

A result has the wrong sign: Review whether the starting balance and recurring deposits are entered as cash paid out. A positive future value normally pairs with negative savings contributions.

The result seems far too large or small: Check that the rate and period count use matching units. A 6% annual rate entered as the rate for every month would mean 6% per month, which is a very different assumption. Similarly, entering five periods instead of 60 understates five years of monthly activity.

The payment timing is off: Confirm whether deposits occur at the start or end of each period. In FV, type applies to the recurring pmt, not to pv.

The formula returns an unexpected zero or error: Check that required arguments are present, that rate and nper are numeric, and that references point to the intended cells. A zero payment is valid for a lump-sum calculation, but an omitted starting value is treated as zero. If a spreadsheet uses regional settings with semicolon list separators, Excel may display or require semicolons instead of commas; the formulas here use the standard comma-separated syntax.

The projection assumes a rate that changes: FV takes one fixed rate argument for the periods in the calculation. It is not designed to model a rate that changes each month or irregular deposits. A period-by-period schedule with separate rate and cash-flow assumptions is more suitable for those cases.

FV compared with PV and other approaches

FV answers, “What could this amount or payment stream be worth later?” PV, Excel’s present-value function, works in the other direction: it estimates the value today of future payments under a specified rate. They are related time-value-of-money calculations, but they answer different questions, so choose based on whether the unknown is the future amount or the current equivalent.

FV is designed for a constant rate and regular, equal payments. It is not the same as a detailed investment return calculation, and it does not automatically account for taxes, fees, inflation, missed payments, or changing rates. For irregular cash flows, a cash-flow table or a suitable cash-flow analysis function may be more appropriate. For a basic plan with fixed periodic contributions, FV is often the clearest option.

Frequently Asked Questions

What does the type argument do in Excel FV?
It sets when each regular payment is made. Use 0, or leave it out, for payments at the end of a period; use 1 for payments at the beginning. It affects pmt, not the initial balance.

Can I use FV for monthly savings?
Yes. Use a monthly rate, the number of monthly periods, and the monthly payment. For a nominal annual rate and five years of monthly deposits, the rate is commonly annual rate divided by 12 and nper is 5 multiplied by 12, subject to the rate terms.

Why does Excel FV return a negative number?
Excel’s financial functions distinguish cash paid out from cash received. If the signs of your starting balance and deposits do not reflect the direction of money flow, the result may be negative. Review the signs and the point of view used.

Does FV include taxes, fees, or inflation?
No. FV calculates from the rate, periods, payments, starting value, and payment timing you provide. Add those other effects separately if they apply, and verify real account terms with the provider or a qualified professional.

Can FV calculate a balance when the interest rate changes?
Not directly with one FV formula, because its rate argument is constant across the modeled periods. Use a period-by-period worksheet when rates or payment amounts vary, so each period can use its own assumptions.

FV is most dependable when its assumptions are explicit: consistent periods, a rate stated on the matching basis, equal regular payments, and correct cash-flow signs. Start with a small set of clearly labeled inputs, then check the projected result against the schedule and terms you intend to model.

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.