How to Calculate What an Annuity Is Worth Today

The basic formula for present value of an annuity

The present value of an annuity tells you what a stream of future payments is worth in today's dollars. You calculate it by taking each payment you expect to receive, reducing it by how much time and interest will pass before you get it, and adding all those reduced amounts together.

The standard formula is: PV = PMT × [(1 − (1 + r)^−n) / r], where PMT is the payment amount, r is the interest rate per period, and n is the number of periods. If you receive $500 per month for 10 years at a 5% annual rate, you would plug those numbers in to find that those payments are worth roughly $47,700 today — not $60,000, because you have to wait for the money.

The reason present value matters: if someone offered to buy your annuity from you, they would use this calculation to decide how much cash to offer you right now. Insurance companies and financial institutions use it to price annuities when you first buy them. Understanding the math helps you see why waiting for payments costs you money compared to having a lump sum today.

Key Takeaways

• Present value reduces future payments to today's dollars by accounting for the time you wait and the interest rate that could have been earned.
• The calculation requires three pieces of information: the payment amount, the interest rate per period, and the total number of periods.
• A financial calculator or spreadsheet formula (like Excel's PV function) will do the math faster and more accurately than doing it by hand.
• The higher the interest rate, the lower the present value, because money today could earn more if invested elsewhere.
• Present value is how annuity buyers and insurance companies decide what your future payments are worth in cash right now.

Breaking down each part of the formula

PMT is the payment amount you receive each period. If your annuity pays $1,000 per month, PMT = 1,000. This stays the same for a fixed annuity. For a variable annuity, the payment changes, so you would need to calculate present value for each different payment separately and add them.

r is the discount rate — the interest rate per period. This is where confusion often starts. If you have an annual rate of 6%, but payments come monthly, you divide by 12 to get 0.06 ÷ 12 = 0.005 per month. The rate must match the period. Annual rate for annual payments, monthly rate for monthly payments.

n is the number of periods. If you receive payments for 20 years and they come monthly, n = 240 (20 × 12). If they come annually, n = 20. Again, the period must match the payment frequency.

The expression (1 + r)^−n is the discount factor — it shrinks future dollars to present dollars. The longer you wait (higher n) or the higher the interest rate (higher r), the smaller this factor becomes, and the less your future payments are worth today.

Using a spreadsheet to calculate present value

Most people do not calculate present value by hand. Excel, Google Sheets, and other spreadsheet programs have a built-in PV function that does it when ready. In Excel, the syntax is =PV(rate, nper, pmt). The rate is the interest rate per period, nper is the number of periods, and pmt is the payment amount (entered as a negative number).

Example: You want to know the present value of $500 monthly payments for 10 years at 5% annual interest. In Excel, you would type =PV(0.05/12, 120, -500). The result is approximately −$47,700, and you drop the negative sign to get $47,700. The negative sign is just how Excel displays it; the actual value is positive.

A financial calculator works the same way. Enter the rate, the number of periods, and the payment, then press PV. The calculator does the exponent and division for you. This method is faster and eliminates arithmetic errors that happen when doing the formula by hand.

How interest rates change the present value

The discount rate is the most sensitive part of the calculation. A small change in the rate produces a large change in present value. This is why annuity prices shift when interest rates move in the broader economy.

Imagine two scenarios for the same annuity: $1,000 per month for 20 years. At 3% annual interest, the present value is about $219,000. At 6% annual interest, it drops to about $186,000 — a difference of $33,000 from just a 3% rate change. At 1% interest, it rises to about $237,000. The lower the rate, the more future payments are worth today, because the opportunity cost of waiting is smaller.

This is why people buying annuities pay attention to current interest rates. When rates are low, annuities are expensive (you pay more for the same stream of payments). When rates are high, annuities are cheaper. The discount rate reflects what you could earn if you invested the money elsewhere instead of buying the annuity.

Present value for annuities that start later

Some annuities do not start paying when ready. A deferred annuity might start payments five years from now. To calculate the present value of a deferred annuity, you first calculate the present value of the payments as if they started today, then discount that result back by the number of years until payments actually begin.

The formula becomes: PV = [PMT × ((1 − (1 + r)^−n) / r)] × (1 + r)^−d, where d is the number of periods until payments start. If an annuity pays $500 monthly for 10 years but does not start for 3 years, you calculate the present value of those 10 years of payments, then multiply by (1.05)^−36 (assuming 5% annual rate and monthly periods) to push that value back 3 years.

This matters because a deferred annuity is worth less today than an when ready annuity with the same payment, even though you receive the same total amount. You are giving up the chance to use or invest that money for several years.

The difference between ordinary annuities and annuities due

An ordinary annuity pays at the end of each period. A payment arrives at the end of month one, the end of month two, and so on. An annuity due pays at the beginning of each period — you get the first payment when ready, the second at the end of month one, and so on.

The basic formula above calculates ordinary annuities. For an annuity due, you multiply the result by (1 + r) to shift all payments forward by one period. If an ordinary annuity is worth $47,700, the same annuity due is worth $47,700 × 1.05 = $50,085 (at 5% annual rate). The annuity due is worth more because you receive each payment sooner.

Most commercial annuities are ordinary annuities — payments arrive after the period ends. But some pension plans and insurance products pay at the beginning of the period. Check your annuity contract to see which type you have, because it affects the present value calculation.

When you might need to calculate present value yourself

You may need to calculate present value if you are considering selling your annuity to a factoring company. These companies buy annuities for a lump sum, and they use present value to decide their offer. If you know how to calculate it, you can check whether their offer is fair or whether you are giving up too much value.

You might also calculate it to compare an annuity to other investments. If you are deciding between buying an annuity that pays $500 monthly for 20 years or investing a lump sum in bonds or stocks, present value tells you what that annuity stream is worth in today's dollars so you can compare apples to apples.

Some people calculate present value to understand how much of their annuity payment is return of principal versus earnings. This matters for tax purposes, because the IRS taxes only the earnings part. Your annuity contract should tell you this, but the calculation shows you how it works.

Frequently Asked Questions

Why does present value go down when interest rates go up?

Higher interest rates mean money today could earn more if invested elsewhere. So future payments become less attractive relative to having cash now. The discount rate reflects this opportunity cost — the higher the rate, the more you are giving up by waiting for payments instead of having the money today.

Can I use present value to figure out if I should take a lump sum instead of annuity payments?

Yes. Calculate the present value of the annuity payments, then compare it to the lump sum offer. If the lump sum is higher than the present value, the lump sum is the better deal in today's dollars. If it is lower, the annuity payments are worth more. This assumes you could invest the lump sum at the same rate used in the calculation.

What discount rate should I use if I do not know the interest rate?

Use the rate your annuity contract specifies, or ask your insurance company or financial advisor. If you are comparing to other investments, use the rate you could earn on those alternatives — bonds, CDs, or stock market returns. The rate you choose affects the result significantly, so make sure it reflects your actual situation.

Does present value work the same way for variable annuities?

The formula is the same, but variable annuities have unpredictable payments, so you cannot use a single number for PMT. You would need to estimate future payments based on market performance, then calculate present value for each estimated payment separately. This is why financial advisors often use projections rather than exact calculations for variable annuities.

If I calculate present value and get a negative number, what does that mean?

You likely entered the payment as a positive number when the formula expects it as negative, or you made an error in the spreadsheet. Recalculate and make sure the payment is entered as negative (like −500 instead of 500). The actual present value should always be positive — it represents the worth of your payments in today's dollars.