FV Function

Summary

The Excel FV function returns the future value of an investment or annuity-style payment plan under a constant interest rate. Microsoft documents FV as the counterpart to other time-value functions such as PV and PMT, and it is widely used when the worksheet needs the ending balance implied by today's assumptions.

FV can model both a recurring contribution stream and a one-time starting balance. That makes it suitable for savings projections, fund-accumulation schedules, and target-based planning models.

The function is sensitive to setup. Rate must match the period unit, timing should be chosen intentionally, and sign convention should make the direction of cash flows clear.

Syntax

=FV(rate, nper, pmt, [pv], [type])

rate is the interest rate per period, nper is the total number of periods, and pmt is the periodic payment. Optional pv adds an initial balance, while type controls whether payments are made at the end of the period (0) or the beginning (1).

For monthly plans, convert annual assumptions to monthly units before calling FV. An annual rate of 8% over 5 years with monthly contributions should therefore use 0.08/12 and 5*12.

Arguments

• rate - Interest rate per period.
• nper - Total number of periods.
• pmt - Payment made each period.
• pv - [Optional] Present value, or the amount invested at time 0.
• type - [Optional] Payment timing. Use 0 for end-of-period payments and 1 for beginning-of-period payments.

Two common modeling checks matter here: whether the payments and balance signs are consistent, and whether the payment timing assumption matches the real situation. Beginning-of-period contributions produce a larger future value than end-of-period contributions because each payment compounds for one additional period.

FV vs Related Functions

FV solves for the ending balance. Other time-value functions in the same family solve different unknowns from the same underlying structure.

Use FV when the return structure is constant. If the worksheet needs year-by-year changing rates, FVSCHEDULE is usually more appropriate.

Using the FV Function

FV is often used to translate a savings plan into an ending balance. Instead of asking how much to save, the worksheet asks what the current contribution plan will become after compounding over a stated horizon. That makes it useful for target tracking and scenario comparison.

The function is also helpful when the worksheet needs to separate contributed capital from growth. Once the future value is known, comparing it to total contributions or the initial balance gives a clearer view of how much of the ending result comes from compounding rather than from funding alone.

• Use FV for fixed-rate growth models.
• Store rate, term, and payment assumptions in visible cells so the model remains auditable.
• Pair FV with target checks or contribution breakdowns so the projection is easier to interpret.

Example 1 - Monthly Savings Goal

This example models a regular contribution plan. The annual rate is converted to a monthly rate, the term is expressed in months, and FV returns the accumulated value after 60 deposits. The negative payment reflects money being contributed into the plan from the user's side.

So the question here is simple: if you save $500 every month for 5 years at 8%, how large could the account become? The result gives the projected ending balance, which is much easier to understand than thinking about compound growth manually.

=FV(0.08/12,60,-500)

Example 2 - Lump Sum Compound

Here there are no recurring payments, so the function compounds only the initial $10,000 over 10 years at 8%. This is a cleaner example of pure compound growth because the result is driven entirely by the starting balance and the rate.

It helps learners separate two ideas that often get mixed together: growth from new deposits and growth from time. In this case, every dollar in the result comes from the original amount plus compounding, not from monthly saving.

=FV(0.08,10,0,-10000)

Example 3 - Goal Threshold Check

A comparison against a target turns the projected balance into a decision rule. Rather than reading only the raw FV output, the worksheet can state directly whether the current savings plan clears the required milestone.

This makes the example more practical because many spreadsheets are built around targets, not just calculations. Instead of asking “what is the balance,” the sheet can ask “does this plan get past $40,000?” and show TRUE or FALSE right away.

=FV(0.08/12,60,-500)>40000

Example 4 - Net Interest Earned

Subtracting the total contributions from FV isolates the growth component. This is often more informative than the ending balance alone because it shows how much of the result comes from returns rather than from cash funded into the plan.

That makes the example easier to interpret in real life. A big final balance can look impressive, but this formula shows how much of it is actual investment gain after removing the money you personally put in.

=FV(0.08/12,60,-500)-30000

Conclusion Recap

FV is useful when you want to know what a savings plan or investment could grow into by the end of a period. In this lesson, that included regular monthly saving, lump-sum compounding, goal checks, and separating total contributions from the growth earned on top of them.

The most important setup detail is making the time units match. If the payments are monthly, the rate and number of periods should be monthly too. Once that is set up correctly, FV becomes a very clear way to turn today’s assumptions into an ending balance.

• Summary: FV returns the ending balance implied by a fixed-rate payment structure.
• Syntax: =FV(rate,nper,pmt,[pv],[type]).
• Core setup: Keep rate and period units aligned, and use a clear sign convention.
• Best use: Savings projections, goal planning, lump-sum growth, and contribution-versus-growth analysis.