The future value of an annuity tells you how much a series of equal payments will be worth at a specific point in the future, assuming those payments earn interest over time. The core formula multiplies your periodic payment by a factor that accounts for compound growth across all payment periods. Once you understand the variables, you can calculate it by hand, in a spreadsheet, or with a financial calculator in under a minute.
The Core Formula
The standard future value of an annuity formula is:
FV = PMT × [((1 + r)^n – 1) / r]
Each variable represents something straightforward:
- FV is the future value, the total your payments will grow to.
- PMT is the payment amount each period (the same every time).
- r is the interest rate per period (not necessarily per year).
- n is the total number of payment periods.
The bracketed portion is sometimes called the “future value interest factor of an annuity.” It captures the compounding effect: each payment earns interest for a different length of time. Your first payment compounds for the longest stretch, your last payment barely compounds at all, and the formula sums up all that growth in one step.
Ordinary Annuity vs. Annuity Due
The formula above assumes an ordinary annuity, where each payment happens at the end of the period. Most loans, bond coupon payments, and retirement account contributions work this way.
An annuity due shifts every payment to the beginning of the period. Rent payments and insurance premiums often follow this pattern. Because each payment arrives one period earlier, every payment gets one extra period of compounding. The adjusted formula is:
FV (annuity due) = PMT × [((1 + r)^n – 1) / r] × (1 + r)
You simply multiply the ordinary annuity result by (1 + r). That one extra compounding period on every payment adds up, especially over long time horizons.
A Step-by-Step Example
Suppose you invest $500 per month into an account earning 6% annual interest, compounded monthly, for 20 years. Here’s how to work through it:
Step 1: Convert the annual rate to a periodic rate. Divide 6% by 12 months: r = 0.06 / 12 = 0.005.
Step 2: Calculate the total number of periods. Multiply 20 years by 12 months: n = 240.
Step 3: Plug into the formula.
FV = 500 × [((1.005)^240 – 1) / 0.005]
First, calculate (1.005)^240. That equals approximately 3.3102. Subtract 1 to get 2.3102. Divide by 0.005 to get 462.04. Multiply by $500, and your future value is approximately $231,020.
Over those 20 years, you contributed $120,000 out of pocket (500 × 240). The remaining $111,020 came from compound interest. That’s the power the formula is measuring: not just your deposits, but the growth on top of growth that accumulates over time.
Adjusting for Compounding Frequency
The most common mistake is mismatching the interest rate and the number of periods. The rate and the period length must always align. If you make monthly payments, you need a monthly interest rate and the total count of monthly periods. If you make quarterly payments, divide the annual rate by 4 and multiply the years by 4.
For example, with a 5% annual rate and quarterly payments over 10 years: r = 0.05 / 4 = 0.0125, and n = 10 × 4 = 40. Using an annual rate of 5% with 40 periods would produce a wildly inflated result, because the formula would treat 5% as the rate per quarter instead of per year.
Using the Excel FV Function
Excel has a built-in FV function that handles annuity calculations without requiring you to build the formula manually. The syntax is:
=FV(rate, nper, pmt, [pv], [type])
- rate: The interest rate per period (monthly rate if payments are monthly).
- nper: The total number of payment periods.
- pmt: The payment amount each period. Enter this as a negative number, since it represents money leaving your hands.
- pv: Optional. The present value or lump sum already in the account. If you’re starting from zero, omit it or enter 0.
- type: Optional. Enter 0 (or leave blank) for an ordinary annuity, where payments occur at the end of each period. Enter 1 for an annuity due, where payments occur at the beginning.
Using the earlier example of $500 per month at 6% annual interest for 20 years, your Excel formula would be:
=FV(0.005, 240, -500, 0, 0)
This returns approximately $231,020. Google Sheets uses the same syntax, and most financial calculators follow similar input logic with dedicated keys for rate, nper, and pmt.
How Fees Reduce the Effective Rate
If you’re calculating the future value of an insurance annuity product rather than a generic investment, fees eat into your effective interest rate and lower the actual future value. Variable annuities are especially fee-heavy. Common charges include:
- Mortality and expense risk charges, typically around 1.25% of the account value per year.
- Administrative fees, often about 0.3% annually or a flat dollar amount.
- Investment expense ratios, ranging from 0.6% to 3% per year depending on the underlying funds.
These fees compound against you just like interest compounds in your favor. To get a more realistic future value, subtract the total annual fee percentage from the gross interest rate before plugging it into the formula. If your annuity credits 6% but charges 1.55% in combined fees, use 4.45% as your effective annual rate. Over 20 years of $500 monthly payments, that difference drops the future value from roughly $231,000 to around $189,000, a gap of more than $40,000.
Surrender charges are a separate issue. They don’t reduce your growth rate, but they penalize early withdrawals. These often start around 7% of the account value and decline by about one percentage point per year until they disappear, usually after seven to ten years.
When the Formula Breaks Down
The standard annuity formula assumes three things: every payment is the same amount, they arrive at perfectly regular intervals, and the interest rate stays constant. Real life often deviates. If you increase your contributions each year, you’re dealing with a growing annuity, which requires a different formula that adds a growth rate variable. If your interest rate fluctuates (as with variable annuities or market-linked accounts), no single formula captures the result. You’d need to model each period individually in a spreadsheet, applying that period’s actual rate to the running balance.
For fixed-payment scenarios with a steady rate, though, the standard formula is exact. It works for retirement savings projections, loan payoff calculations, and any situation where you’re making or receiving identical payments on a set schedule and want to know the total value at the end.