To calculate the present value and future value of annuities, you discount each future payment back to today using PV = PMT × [(1 − (1 + r)−n) / r], and you compound each payment forward using FV = PMT × [((1 + r)n − 1) / r]. PMT is the fixed payment, r is the interest rate per period, and n is the total number of periods. Present value tells you the lump sum that would replicate the stream today; future value tells you the balance after the last payment is made and compounded.
The Four Inputs Both Formulas Need
Every annuity valuation runs on the same four numbers. Miss one and the output is meaningless.
- Payment amount (PMT): the fixed dollar amount paid each period, taken from a policy schedule, loan disclosure, or plan statement.
- Interest rate per period (r): the rate applied during each interval. If you’re quoted an annual rate but payments are monthly, divide by 12. A 6% annual rate on a monthly annuity means r = 0.5% per month.
- Number of periods (n): the total count of payments. Twenty years of monthly payments is 240 periods, not 20.
- Timing: an ordinary annuity pays at the end of each period. An annuity due pays at the beginning. This shifts the result by one period’s worth of interest.
Two complications are worth checking before you plug numbers in. If the contract has a cost-of-living rider, the payment amount changes over time, so the standard formulas don’t fit. You’d need to value each year’s payment individually and add them. And if the contract rate is variable rather than fixed, your output is a projection, not a guarantee, because the rate will drift with market conditions.
Present Value of an Annuity
Present value answers one question: how much cash would you need right now to replicate this entire stream of future payments? A dollar today is worth more than a dollar next year because today’s dollar can earn interest, so each future payment is discounted back to today at the agreed rate.
The formula for an ordinary annuity is:
PV = PMT × [(1 − (1 + r)−n) / r]
The bracketed portion is the present value interest factor. Solve inside the brackets first, then multiply by the payment.
Worked Example
Suppose you’re offered $50,000 per year for 20 years, and the appropriate discount rate is 5%:
PV = 50,000 × [(1 − (1.05)−20) / 0.05]
Work it in order. (1.05)20 = 2.6533, so (1.05)−20 = 1 / 2.6533 = 0.3769. Then 1 − 0.3769 = 0.6231. Divide by 0.05 to get 12.4622. Multiply by $50,000. The present value is roughly $623,110.
That means $623,110 invested today at 5% would generate exactly $50,000 per year for 20 years before running dry. If a buyer offers you a lump sum below that figure to take over the payment stream, you’re giving up value at that discount rate. If the offer is higher, the cash is mathematically the better deal.
The discount rate drives everything. A higher rate produces a lower present value because future dollars are being penalized more heavily for not being here yet. This is why the same stream of payments can be worth very different amounts to different parties: an insurance carrier pricing a settlement uses one rate, a factoring company buying payments uses a much steeper one, and the IRS uses its own rate for estate valuations.
Future Value of an Annuity
Future value works in the opposite direction. Instead of discounting payments backward, it compounds them forward. Each payment earns interest from the moment it’s deposited until the end of the term, so earlier payments grow more than later ones. The result is the balance after the final payment lands.
The formula for an ordinary annuity is:
FV = PMT × [((1 + r)n − 1) / r]
Worked Example
Say you contribute $6,000 per year to a retirement account earning 7% annually for 30 years:
FV = 6,000 × [((1.07)30 − 1) / 0.07]
(1.07)30 = 7.6123. Subtract 1 to get 6.6123. Divide by 0.07 to get 94.461. Multiply by $6,000. The future value is approximately $566,765.
Your out-of-pocket contributions over 30 years total $180,000. The remaining $386,765 is compound interest. Someone who waits 10 years and contributes for only 20 at the same rate and amount ends up with roughly $246,000, less than half, despite contributing two-thirds as much cash.
The formula assumes you reinvest every payment at the stated rate for the full remaining term. Real rates fluctuate, and not every dollar earns the same return, so treat the output as a target rather than a promise. If you’re projecting a 401(k) or similar plan, your quarterly or annual benefit statement will show actual balances and estimated lifetime income you can check against your own numbers.1Office of the Law Revision Counsel. 29 USC 1025 – Reporting of Participant’s Benefit Rights
Adjusting for an Annuity Due
Both formulas above assume payments arrive at the end of each period. An annuity due shifts each payment to the beginning. Rent is the familiar example: you pay on the first of the month, not the last.
Because each payment arrives one period earlier, it has one extra period to earn (or be discounted by) interest. The fix is simple: run the ordinary annuity calculation, then multiply by (1 + r).
- Present value of an annuity due: PVdue = PVordinary × (1 + r)
- Future value of an annuity due: FVdue = FVordinary × (1 + r)
Applied to the earlier present value example, $623,110 × 1.05 = roughly $654,266. That 5% bump reflects every payment landing in your hands one year sooner.
Using Spreadsheets and Financial Calculators
You don’t need to grind through exponents by hand. Excel and Google Sheets handle both calculations with built-in functions:
- =PV(rate, nper, pmt) returns the present value of an ordinary annuity. Enter the rate per period, total number of periods, and the payment. The result displays as a negative number representing cash you’d pay out today; wrap it in ABS() or ignore the sign.
- =FV(rate, nper, pmt) returns the future value. Same inputs, same sign convention.
Both functions accept an optional type argument at the end. Enter 0 or leave it blank for an ordinary annuity, or enter 1 for an annuity due. That toggle replaces the manual (1 + r) adjustment.
Financial calculators from HP or Texas Instruments have dedicated keys for N, I/Y, PMT, PV, and FV. Enter any four and solve for the fifth.
The single most common mistake, in both spreadsheets and calculators, is mismatching the rate and the period. If payments are monthly, the rate must be monthly and n must be in months. Mixing an annual rate with monthly periods produces a wildly wrong answer. Check this before you check anything else.
What the Formulas Don’t Capture
Both formulas assume every dollar works at the stated rate and that you receive each payment as scheduled. Real contracts carry fees, penalties, and taxes that shrink the real-world result.
Fees
Variable annuities carry the heaviest fee load. The mortality and expense risk charge alone typically runs around 1.25% of account value per year, and administrative fees add roughly another 0.15%.2U.S. Securities and Exchange Commission. Variable Annuities: What You Should Know Add the expense ratios of the underlying funds and combined annual costs can reach 2% or more. On a 7% gross return, 2% in fees drops the compounding rate to 5%, which over 30 years can cut the future value by more than a third.
Fixed annuities don’t itemize fees the same way. The insurer bakes its costs into the rate it offers you. The rate you see is the rate you get, but it’s lower than what the insurer earns on the underlying investments. Either way, when projecting future value, use the net rate after charges rather than the headline rate.
Surrender Charges
Most contracts impose a surrender charge if you withdraw more than a specified amount during the early years. The surrender period commonly lasts six to eight years, with the charge starting around 7% in year one and declining by roughly a percentage point annually until it disappears. Many contracts let you pull up to 10% of account value each year without triggering the charge, but anything above that gets hit. A future value projection of $500,000 means less if cashing out in year three costs you 5% off the top.
Taxes
Gross value is not take-home value. For a non-qualified annuity, bought with after-tax money, the IRS taxes only the earnings portion of each payment. You divide your investment in the contract by the expected total return to get an exclusion ratio, which is the tax-free percentage of each payment. Once you’ve recovered your full investment, every subsequent payment is fully taxable.3Office of the Law Revision Counsel. 26 USC 72 – Annuities; Certain Proceeds of Endowment and Life Insurance Contracts Annuities held inside a 401(k) or IRA were funded with pre-tax dollars, so every payment is fully taxable as ordinary income.
Taking money out before age 59½ generally triggers an additional 10% tax on the taxable portion. For non-qualified contracts the penalty is imposed under Section 72(q);4Office of the Law Revision Counsel. 26 USC 72 – Annuities; Certain Proceeds of Endowment and Life Insurance Contracts for qualified plans a parallel rule under Section 72(t) applies.5Internal Revenue Service. Topic No. 558, Additional Tax on Early Distributions From Retirement Plans Other Than IRAs Exceptions exist for death, disability, and a series of substantially equal periodic payments, among others. If you’re running present value on an annuity you might liquidate early, build in the 10% hit plus ordinary income tax on the gains before comparing offers.