How to Calculate FVIFA in Excel

April 9, 2026

If you are projecting how much a stream of equal payments — retirement contributions, loan installments, insurance premiums — will be worth at the end of some horizon, the Future Value Interest Factor of an Annuity (FVIFA) is the single multiplier that does the work. Multiply it by the payment amount and you get the future value of the whole stream. It is one of the most reusable numbers in personal and corporate finance, and Excel can compute it in a single cell.

This guide walks through what FVIFA actually represents, the closed-form formula, how to type it into Excel, how to cross-check the result against Excel's built-in FV function, and the one subtlety — ordinary annuity vs. annuity due — that trips most people up.

What FVIFA Actually Measures

FVIFA is the future value, at the end of $n$ periods, of a stream of $1 payments made at the end of each period, assuming each payment earns a constant interest rate $r$ per period until the end of the horizon.

Because it is defined on a $1 payment, it is a pure multiplier. If you know the FVIFA for a given rate and horizon, the future value of any equal-payment stream at that rate and horizon is simply:

\text{Future Value} = \text{FVIFA}(r, n) \times \text{Payment}

This is what makes the factor useful: compute it once for a given $(r, n)$ pair, then plug in whatever payment size you want.

Two things to pin down before using it:

The rate and the period must match. If payments are monthly, $r$ is the monthly rate and $n$ is the number of months. If they are annual, both are annual. Mixing them is the single most common mistake.
FVIFA assumes payments are made at the end of each period. This is the "ordinary annuity" convention. If payments are made at the beginning of each period (an "annuity due"), the factor is slightly larger, by a factor of $(1 + r)$ . We cover this below.

The FVIFA Formula

The closed-form expression is:

\text{FVIFA}(r, n) = \frac{(1 + r)^{n} - 1}{r}

Where:

$r$ is the interest rate per period (e.g., 5% per year as 0.05, or 0.4167% per month as 0.05/12).
$n$ is the number of periods.

The intuition: the first payment sits in the account for $n - 1$ periods and compounds to $(1 + r)^{n-1}$ . The second earns for $n - 2$ periods, and so on, with the last payment earning nothing because it is deposited at the very end. Summing that geometric series gives the closed form above.

Calculating FVIFA in Excel

The Data You Need

All you need is two numbers: the per-period rate and the number of periods. Lay them out like this:

Cell	Contents
`A1`	`Rate`
`A2`	`0.05`
`B1`	`Periods`
`B2`	`10`
`C1`	`FVIFA`
`C2`	(formula here)

Step-by-Step

Type the rate in A2. If you want an annual rate of 5%, enter 0.05. If payments are monthly at an annual rate of 5%, enter =0.05/12 instead — the rate must match the payment frequency.
Type the number of periods in B2. For a 10-year annual-payment plan, enter 10. For a 10-year monthly plan, enter =10*12.
In C2, type the FVIFA formula:
```
=((1+A2)^B2-1)/A2
```
Press Enter. For r = 0.05 and n = 10, Excel returns 12.5779 (to four decimal places). That is the FVIFA.
Optional: compute the future value of an actual payment stream. In D1 type Payment, in D2 enter the payment amount (say 1000). In E1 type Future Value, and in E2 enter:
```
=C2*D2
```
Excel returns 12577.89, meaning $1,000 deposited at the end of each year for 10 years at 5% grows to about $12,577.89.

Excel worksheet with the FVIFA formula in C2, a cross-check against the FV function, and the resulting future value for a $1,000 annual payment — Excel worksheet computing FVIFA from a per-period rate and number of periods, cross-checked against the built-in FV function

Cross-Checking With Excel's `FV` Function

Excel has a built-in function, FV, that computes the future value of an annuity directly, without going through FVIFA. You can use it to verify your FVIFA calculation.

In C4 type a label like FV check, and in C5 type:

=FV(A2, B2, -1, 0, 0)

The arguments are:

rate — the per-period rate, same as A2.
nper — the number of periods, same as B2.
pmt — the payment per period. Enter -1 (Excel uses a cash-flow sign convention where outflows are negative; using -1 returns a positive factor).
pv — present value, 0 because we are only valuing the annuity, not an existing lump sum.
type — 0 for an ordinary annuity (payments at the end of each period). Use 1 for an annuity due.

This should return 12.5779 — the same FVIFA you computed from the closed-form formula. If the two differ, you almost certainly have a rate/period mismatch or an annuity-due setting to track down.

Ordinary Annuity vs. Annuity Due

The standard FVIFA formula assumes payments occur at the end of each period (an "ordinary annuity" — most loans and bond coupons work this way). If payments instead occur at the beginning of each period (an "annuity due" — rent, many insurance premiums, some retirement contributions), every payment gets one extra period of compounding, and the factor becomes:

\text{FVIFA}_{\text{due}}(r, n) = \frac{(1 + r)^{n} - 1}{r} \times (1 + r)

In Excel, you can either multiply your C2 formula by (1+A2):

=((1+A2)^B2-1)/A2*(1+A2)

or let the FV function do it by setting the type argument to 1:

=FV(A2, B2, -1, 0, 1)

For r = 0.05 and n = 10, the annuity-due FVIFA is 13.2068 — about 5% larger than the ordinary version, exactly the extra period of compounding.

A Worked Example: Retirement Contributions

Suppose you contribute $6,000 at the end of each year to a retirement account for 30 years and expect a 7% average annual return.

Rate per period: 0.07
Periods: 30
FVIFA: $\dfrac{(1.07)^{30} - 1}{0.07} \approx 94.4608$
Future value: $94.4608 \times 6{,}000 \approx \$566{,}765$

If instead you contribute at the beginning of each year:

Annuity-due FVIFA: $94.4608 \times 1.07 \approx 101.0730$
Future value: $101.0730 \times 6{,}000 \approx \$606{,}438$

The roughly $40,000 difference is what one extra year of compounding on every contribution is worth over a 30-year horizon. This is a real, recurring reason to fund retirement accounts early in the year rather than at the end.

Common Mistakes

Rate/period mismatch. Using an annual rate with a number-of-months period count is the single most frequent error. If payments are monthly, divide the annual rate by 12 and multiply the horizon in years by 12.
Entering the rate as a whole number. 5 instead of 0.05 will give a nonsensical answer. Excel's percentage formatting on the cell does not change what you type — 5% and 0.05 are the same, but 5 alone is not.
Forgetting the annuity-due adjustment. If your real-world payments are at the beginning of the period, the ordinary-annuity FVIFA understates the future value by a full period of compounding.
Confusing FVIFA with PVIFA. The Present Value Interest Factor of an Annuity answers the opposite question — what a stream of future payments is worth today — and has a different formula. FVIFA projects forward; PVIFA discounts backward.

Frequently Asked Questions

What is the difference between FVIFA and Excel's `FV` function?

They compute the same thing, but FV is an all-in-one function that takes a payment amount directly and returns the future value, while FVIFA is just the multiplier for a $1 payment. If you only need one answer, FV is faster. If you want to apply the same factor to several different payment sizes, computing FVIFA once and multiplying is cleaner.

Do I need to use FVIFA tables anymore?

No. Printed FVIFA tables were useful before spreadsheets because the formula involves an exponentiation that is tedious by hand. With Excel, the closed-form expression takes one cell. Tables are still occasionally useful as a sanity check or for textbook problems.

What happens when the rate is zero?

The closed-form formula has r in the denominator and is undefined at exactly r = 0. In that edge case, FVIFA is simply the number of periods n — because with no interest, $1 deposited each period for $n$ periods is worth exactly $n$ at the end. Excel's FV function handles this correctly; the algebraic formula requires a special case.

Can I use FVIFA for irregular payments?

No — FVIFA assumes equal payments each period. If your payments vary, you need to compound each one individually, or use Excel's NPV and FV functions on an explicit cash-flow column.

How do I handle inflation?

FVIFA gives you a nominal future value. To express the result in today's dollars, either use a real (inflation-adjusted) interest rate in place of $r$ , or compute the nominal future value first and then divide by $(1 + \pi)^{n}$ , where $\pi$ is the expected inflation rate per period. Do not mix nominal and real inputs in the same formula.

Why does the FVIFA formula look like a geometric series?

Because it is one. Each payment compounds for a different number of periods — the first for $n - 1$ periods, the last for zero — and summing $(1 + r)^{n-1} + (1 + r)^{n-2} + \dots + 1$ gives the closed form $\frac{(1 + r)^{n} - 1}{r}$ . Recognizing it as a geometric series is the cleanest way to remember the formula.