FV Examples in Excel: Formula and Worked Examples

Excel’s FV function calculates the future value of money invested or saved at a steady interest rate. For example, with an annual rate in B2, years in B3, and an initial $1,000 entered as -1000 in B4, =FV(B2,B3,0,B4) returns $1,157.63 when B2 is 5% and B3 is 3.

What the FV function calculates

FV is short for future value. It estimates what a current amount, a series of regular payments, or both will be worth after a specified number of equal periods, assuming a constant interest rate. It is commonly used to model savings growth, recurring contributions, and other time-value-of-money examples.

The function calculates each period in sequence. An amount already saved earns interest over the full term; a payment made regularly earns interest only from the time it is added. That distinction explains why FV needs separate inputs for the starting amount and the periodic payment.

FV is a mathematical projection, not a promise about an account balance. Real accounts may have changing rates, fees, taxes, contribution limits, or rules about when interest is credited. The examples below assume a fixed rate and regular, equal periods so that the function’s result can be checked and understood.

A first FV example: one initial deposit

Suppose you place $1,000 in an account earning 5% per year and leave it there for three years, with no later deposits. Set up the worksheet like this:

B2: annual interest rate, entered as 5%
B3: number of years, entered as 3
B4: initial deposit, entered as -1000

With those values in B2:B4, the formula can refer to the rate, term, and starting balance directly. The zero is the regular payment per year because there are no additional deposits. Enter this in B5:

=FV(B2,B3,0,B4)

The result is $1,157.625, or $1,157.63 when displayed to two decimal places. That is the initial $1,000 plus $157.625 of modeled growth over three annual periods. Excel may show more or fewer decimal places depending on the cell format; changing the display format does not change the underlying calculation.

The starting deposit is negative because Excel uses cash-flow signs: money paid into the account is an outflow from the saver’s point of view. The positive result represents money received from the account in the future. The sign convention is important even when the arithmetic seems obvious.

FV example with monthly savings contributions

FV can also include recurring payments. Consider saving $200 at the end of every month for five years, using a nominal annual rate of 6% divided into monthly periods. Put these inputs in the worksheet:

B2: annual nominal rate, 6%
B3: years, 5
B4: monthly contribution, 200

With the annual rate in B2, the term in years in B3, and the positive contribution amount in B4, enter this formula in B5. Dividing the annual rate by 12 gives a monthly rate, and multiplying the years by 12 gives the number of monthly periods:

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

The result is approximately $13,954.01. The saver contributes $12,000 in total (60 payments of $200); the remaining approximately $1,954.01 is modeled interest. The formula uses a negative payment because the monthly contributions are money going into savings from the saver’s perspective. The final zero sets the initial balance to zero, and the last zero specifies payments at the end of each month.

This is an illustration of the function, not a forecast for a particular bank or investment. It assumes the rate stays constant, contributions are made on schedule, and the 6% nominal annual rate is applied as 6% divided by 12 each month. Account terms may use a different compounding method or include costs that this simple calculation does not represent.

Payment timing: end of period or beginning

The optional type argument tells FV when regular payments occur. Use 0 for payments at the end of each period, which is the default, or 1 for payments at the beginning. A beginning-of-month contribution has one extra month to earn interest compared with an end-of-month contribution.

Using the same monthly-savings layout—annual nominal rate in B2, years in B3, and contribution amount in B4—change only the final argument to 1:

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

With the example values of 6%, five years, and $200 per month, this returns approximately $14,023.78. It is about $69.77 more than the end-of-month result because each of the 60 contributions earns one additional month of interest. If you omit the final argument or use 0, Excel treats the payments as occurring at period-end.

Choose the timing that matches the real cash-flow pattern you want to model. A regular transfer made on the first day of each month may fit type 1 more closely; a deposit made after each month ends may fit type 0. If deposits happen on irregular dates, the standard FV function’s equal-period assumption may not be suitable.

Match the interest rate to the number of periods

A frequent source of incorrect results is mixing an annual rate with monthly periods or a monthly rate with annual periods. The rate and nper must describe the same period. If contributions are monthly, use a monthly rate and count the months. If contributions are annual, use an annual rate and count the years.

For monthly periods with a nominal annual rate, divide the annual rate by 12 and multiply years by 12.
For quarterly periods, divide a nominal annual rate by 4 and count quarters.
For annual periods, use the annual rate and the number of years.

These conversions assume the quoted rate is a nominal annual rate that is divided evenly across the periods. A stated effective annual rate is not necessarily converted to a monthly rate by simply dividing by 12; the appropriate periodic rate depends on how that rate is defined. Check the account or contract terms before using a rate in a real-world model.

Also make sure every recurring payment occurs at the period frequency used in the formula. Entering a monthly contribution while counting only five periods for a five-year plan does not model 60 deposits; it models five payments. A useful check is to say the inputs out loud: “monthly rate, 60 monthly periods, monthly payment.”

Understanding positive and negative values

Excel’s financial functions use a cash-flow sign convention. Cash paid out is generally entered as a negative amount, and cash received is generally entered as positive. For a savings example, the deposit or contribution is typically negative and the future balance is positive. For a borrower’s perspective, a loan received today may be positive while later payments are negative.

If a result has the opposite sign from the one you expect, first check the signs of the payment and present-value inputs. Do not change signs randomly just to make the output look positive: the signs should represent the direction of the cash flows from one consistent point of view. Flipping the sign of every cash flow changes the sign of the answer without changing its magnitude.

A zero result can also be valid. For example, with no starting balance, no payments, and any rate or term, there is no money to grow. Likewise, a negative result may reflect the inputs’ cash-flow directions rather than a calculation error. Interpret the result alongside the assumptions and signs in the model.

Entering and formatting an FV formula in Excel

In Excel for Microsoft 365 on Windows, select the result cell, type an equals sign followed by the function and its arguments, and press Enter. The formula bar can also be used to edit the formula. You can enter the percentages and amounts in separate cells, as in the examples, which makes it easier to change assumptions without rewriting the calculation.

To show a result as currency, select the result cell and choose Currency from the Number Format list in the Home tab’s Number group. The displayed value may round to cents, but Excel keeps its stored precision for later calculations. To inspect more detail, increase the displayed decimal places from the same Number group.

The FV function and formulas shown here also work in Excel for Mac and Excel for the web. Ribbon layout and some controls can look different across platforms, but the function syntax and calculation are the same. If Excel displays a function-argument dialog while you type, the argument names can help identify the interest rate, number of periods, payment, starting value, and payment timing.

Common FV errors and how to fix them

Wrong rate frequency: If the periods are months, use a monthly rate rather than entering an annual rate unchanged. Make the rate and period count agree.
Wrong number of periods: Five years of monthly contributions usually means 60 periods, not five. Multiply the years by 12 for a monthly model.
Unexpected negative result: Review the signs of the payment and starting balance. Excel’s cash-flow convention can make a mathematically correct answer appear negative.
Payment timing is off: Check the final argument. Type 0 means end of period; type 1 means beginning of period.
Missing starting balance: If there is no initial deposit, include zero for the present value when also specifying the type argument. This makes the argument positions clear.
Result seems too large or small: Check whether a percentage was entered as 5% or as 5. Entering 5 means 500% in Excel, not 5%.

When troubleshooting, test a simplified version of the calculation with a small number of periods, then compare the result with the expected direction and scale. Also check that the input cells contain numbers rather than text that only looks numeric. Excel’s formula bar and cell formatting can help distinguish the displayed value from the underlying entry.

FV compared with other financial functions

FV answers “what could this amount or payment stream grow to?” The related PV function works in the opposite direction: it estimates the value today of future payments at a specified rate. PMT calculates a regular payment for a loan or other constant-payment arrangement, while NPER calculates how many periods a payment plan takes under the supplied assumptions.

These functions share the need for consistent periods, rates, and cash-flow signs. They are useful for different unknowns in a model, but they do not automatically account for changing rates, irregular dates, taxes, fees, or inflation. If the question is about the future value of cash flows on uneven dates, a function designed for dated cash flows may be a better fit than ordinary FV.

For a loan balance, FV can sometimes model a remaining value under a fixed-rate, regular-payment setup, but the signs and timing need to match the borrower’s perspective and the loan’s terms. For consequential borrowing or savings decisions, use the actual contractual figures and check assumptions with the lender or a qualified professional. These examples explain spreadsheet mechanics and are not financial, tax, investment, or legal advice.

Frequently Asked Questions

What does FV mean in Excel?

FV means future value. The function estimates the value at the end of a series of periods for a starting amount, regular payments, or both, using a constant rate per period.

What is the basic FV formula in Excel?

The function takes a rate per period, the number of periods, a payment each period, an optional present value, and an optional payment-timing setting. In a worksheet, the arguments can refer to cells, as in the worked examples above. The present value and payment inputs should follow Excel’s cash-flow sign convention.

Why is my FV result negative?

Usually, the inputs’ signs indicate cash flows in a direction that produces a negative future value. Check whether deposits and starting balances are entered as outflows and whether you are interpreting the result from the same person’s perspective. A negative result is not automatically a formula error.

Should I use type 0 or type 1 in FV?

Use type 0, or leave the argument out, for payments at the end of each period. Use type 1 for payments at the beginning. The choice should reflect when payments actually occur in the scenario being modeled.

Can FV calculate monthly savings?

Yes. Use a monthly interest rate, the total number of months, and the monthly contribution. For a nominal annual rate and a five-year monthly plan, that generally means dividing the rate by 12 and multiplying five by 12, provided those assumptions match the rate definition and account terms.

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.