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. Instead of receiving $500 a month for 10 years, you could ask: what lump sum right now would be worth the same thing? That lump sum is the present value.

The formula is: PV = PMT × [(1 − (1 + r)^−n) / r]. In this formula, PMT is the payment amount, r is the interest rate per period, and n is the total number of periods. You can use this with a calculator, a spreadsheet, or an online present value tool.

The reason you need this calculation is that money today is worth more than money later. If you had $10,000 now, you could invest it and earn interest. So $10,000 in five years is worth less than $10,000 today. Present value accounts for that difference.

Key Takeaways

• Present value converts future annuity payments into a single dollar amount in today's money, accounting for the fact that money now is worth more than money later.
• You need three pieces of information: the payment amount, the interest rate (or discount rate), and the number of periods the payments will continue.
• The interest rate you use should match the time period of the payments — if payments are monthly, use a monthly rate, not an annual rate.
• An ordinary annuity (payments at the end of each period) and an annuity due (payments at the beginning) use slightly different calculations.
• Spreadsheet functions like PV() in Excel or Google Sheets can do this calculation for you without manually working through the formula.

Gathering the three numbers you need

Before you can calculate present value, you need to identify three specific pieces of information from your annuity contract or situation.

Payment amount (PMT): This is how much you receive each period. If your annuity pays $1,200 per month, that is your PMT. The payment should be the same each period — if it varies, the calculation becomes more complex and you may need a financial calculator or spreadsheet.

Interest rate or discount rate (r): This is the rate of return you could earn if you invested the money elsewhere, or the rate built into the annuity contract. If you are comparing an annuity to a savings account earning 2% annually, use 2%. If the annuity contract specifies a rate, use that. The rate must match your time period — if payments are monthly, divide the annual rate by 12.

Number of periods (n): Count how many payments you will receive. If you get $500 a month for 10 years, that is 120 periods. If you receive quarterly payments for 5 years, that is 20 periods. If the annuity is for your lifetime, you will need to estimate based on life expectancy tables or use a financial professional.

Working through a real example step by step

Suppose you have an annuity that pays $500 per month for 10 years, and you want to know what it is worth today. You decide to use a 3% annual discount rate (the rate you could earn elsewhere). Here is how to work through it.

First, convert the annual rate to a monthly rate: 3% ÷ 12 = 0.25% per month, or 0.0025 in decimal form. Next, count the periods: 10 years × 12 months = 120 periods. Now plug into the formula: PV = $500 × [(1 − (1 + 0.0025)^−120) / 0.0025].

Calculate (1 + 0.0025)^−120, which equals approximately 0.7414. Then (1 − 0.7414) = 0.2586. Divide by the rate: 0.2586 ÷ 0.0025 = 103.44. Finally, multiply by the payment: $500 × 103.44 = $51,720. This means the 10-year stream of $500 monthly payments is worth approximately $51,720 in today's dollars at a 3% discount rate.

Using a spreadsheet to avoid manual calculation

Most people use a spreadsheet rather than working through the formula by hand. In Excel or Google Sheets, the function is =PV(rate, nper, pmt). The order of the arguments matters, and the result will appear as a negative number (a spreadsheet convention for cash outflows), so you may need to add a negative sign to make it positive.

Using the same example: =PV(0.0025, 120, -500) returns approximately 51,720. The -500 tells the spreadsheet that money is going out (you are receiving it). If you enter it as positive, the result will be negative, so flip the sign.

A spreadsheet is especially useful if you want to test different scenarios. Change the rate to 4% or 2%, or change the number of periods, and the spreadsheet recalculates when ready. This helps you see how sensitive the present value is to changes in your assumptions.

The difference between ordinary annuities and annuities due

An ordinary annuity pays you at the end of each period. An annuity due pays you at the beginning of each period. This timing difference affects the present value because money received sooner is worth more.

The formula above assumes an ordinary annuity. If you have an annuity due, multiply the result by (1 + r). Using the earlier example, if the $500 payments came at the start of each month instead of the end, you would multiply $51,720 by 1.0025, giving approximately $51,850. The difference grows larger as the interest rate increases.

Check your annuity contract to see when payments are made. Most commercial annuities are ordinary annuities (payments at the end of the period), but some insurance products and pension plans pay at the beginning. Your contract should state this clearly.

How the discount rate affects your result

The discount rate you choose has a large impact on the present value. A higher rate means future money is worth less today, so the present value drops. A lower rate means future money is worth more today, so the present value rises.

Using the same $500-per-month, 10-year annuity: at 1% the present value is about $58,500; at 3% it is about $51,720; at 5% it is about $45,700. The choice of rate matters enormously. If you are comparing an annuity to another investment, use the rate of return you could earn on that other investment. If you are valuing an annuity for estate or legal purposes, you may need to use a rate set by law or regulation.

When you might need a professional to calculate this

For a straightforward annuity with fixed payments, a spreadsheet or online calculator works fine. But some situations require more help. If your annuity has payments that increase each year, if it includes a survivor benefit, if it is a variable annuity with returns tied to market performance, or if it is a lifetime annuity where you need to estimate how long you will live, a financial advisor or actuary may give you a more accurate picture.

Similarly, if you are using present value for a legal settlement, divorce, or tax matter, the discount rate may be set by statute or court rule rather than your choice. An attorney or tax professional can tell you which rate to use in your jurisdiction.

Frequently Asked Questions

What discount rate should I use if I don't know what to pick?

Use the rate you could earn on a safe alternative investment, such as a high-yield savings account or short-term Treasury bill. If you are comparing the annuity to keeping money in a regular savings account earning 0.5%, use 0.5%. If you are comparing it to a bond fund earning 3%, use 3%. The rate should reflect what you would actually do with the money if you did not buy the annuity.

Does present value tell me whether to buy an annuity?

Present value is one tool, not a complete answer. It tells you what the payment stream is worth in today's dollars, but it does not account for your personal situation, tax consequences, or whether you need may provide income. A financial advisor can help you weigh present value against your actual needs and goals.

Can I use present value to compare two different annuities?

Yes. Calculate the present value of each annuity using the same discount rate, then compare the results. The annuity with the higher present value delivers more value in today's dollars. This works only if both annuities have the same payment schedule (monthly, quarterly, etc.) and you use the same rate for both.

What if the annuity payments are not the same every period?

The basic formula assumes equal payments. If payments grow by a fixed percentage each year (a growing annuity), or if they vary unpredictably, you need a different approach. You can calculate the present value of each individual payment separately and add them up, or use a spreadsheet to discount each payment one at a time. A financial calculator or professional may be faster for complex payment schedules.

Is present value the same as the annuity's cash surrender value?

No. Cash surrender value is what the insurance company will pay you if you cancel the annuity today — it is set by the contract and may include surrender charges. Present value is a mathematical calculation of what the future payments are worth. They can be very different numbers, and you should not confuse them.