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.

=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.

=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.

=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.

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

Conclusion Recap

• 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.