The present value of an ordinary annuity is the total worth today of a series of equal future payments, where each payment arrives at the end of a regular interval. It answers a practical question: if someone promises to pay you a fixed amount every month or every year for a set number of periods, how much is that entire stream of payments worth right now in a single lump sum? The answer is always less than the simple total of those payments, because money received in the future is worth less than money in your hand today.
Why Future Payments Are Worth Less Today
The core idea behind present value is the time value of money. A dollar you have today can be invested and earn a return, so it is worth more than a dollar you will receive a year from now. If you could earn 5% annually, $1,000 today would grow to $1,050 in a year. Flip that around: $1,050 arriving a year from now is only worth $1,000 to you today. Present value math applies that same logic to every single payment in an annuity, discounting each one back to its current worth and adding them up.
What Makes It “Ordinary”
The word “ordinary” refers to payment timing. In an ordinary annuity, each payment is made at the end of the period. Your mortgage payment, for example, covers the month that just passed, not the month ahead. Bond interest payments work the same way: the issuer pays you after the interest has accrued. Quarterly stock dividends from a company with a stable payout follow this pattern too.
An annuity due is the opposite arrangement, where payments arrive at the beginning of each period. Rent is a common example: you pay on the first of the month for the month ahead. Because each payment in an annuity due arrives one period sooner, its present value is slightly higher than an ordinary annuity with the same payment amount, rate, and number of periods. When someone refers to an “annuity” without further detail, they usually mean the ordinary type.
The Formula
The present value of an ordinary annuity is calculated with this formula:
PV = PMT × [(1 − (1 + r)^(−n)) / r]
Each variable represents something concrete:
- PV is the present value, the lump sum equivalent of all future payments.
- PMT is the fixed payment amount each period.
- r is the discount rate per period (expressed as a decimal, so 6% becomes 0.06).
- n is the total number of payment periods.
The bracketed portion is sometimes called the “present value interest factor of an annuity.” It represents how much one dollar of payment per period is worth today, given the rate and number of periods. Multiply that factor by the actual payment amount and you have your answer.
A Worked Example
Suppose you are offered an investment that pays $1,000 at the end of each year for five years, and you want a 6% annual return on your money. Plugging into the formula:
PV = $1,000 × [(1 − (1.06)^(−5)) / 0.06]
First, calculate (1.06)^(−5), which equals roughly 0.7473. Subtract that from 1 to get 0.2527. Divide by 0.06 to get approximately 4.2124. Multiply by $1,000, and the present value is about $4,212.36.
That means the five payments totaling $5,000 are worth $4,212.36 in today’s dollars if your required return is 6%. If someone offered to sell you that payment stream, any price below $4,212 would be a good deal at your target rate, and any price above it would not meet your return requirement.
How the Discount Rate Changes the Result
The discount rate has a powerful effect on present value, and the relationship runs in one direction: a higher rate means a lower present value. Using the same five-year, $1,000-per-year annuity from above, here is how the present value shifts at different rates:
- 3% discount rate: PV ≈ $4,580
- 6% discount rate: PV ≈ $4,212
- 10% discount rate: PV ≈ $3,791
At 10%, each future dollar is discounted much more heavily because you are assuming you could earn a higher return elsewhere. The gap widens further as the number of periods grows. For a 20-year annuity, the difference between using a 3% and 10% discount rate can cut the present value nearly in half.
Choosing the right discount rate depends on context. For valuing a bond, you would typically use the market yield for comparable bonds. For evaluating a business investment, you might use the company’s cost of capital. For personal financial planning, a reasonable expected rate of return on alternative investments often serves as the rate.
Where This Calculation Shows Up
Present value of an ordinary annuity is not just a textbook exercise. It is embedded in several everyday financial decisions:
- Loan pricing: When a bank sets a monthly mortgage or car payment, it is solving the present value formula in reverse. The loan amount is the present value, and the bank calculates the payment that, when discounted at the loan’s interest rate, equals that amount.
- Bond valuation: A bond’s coupon payments form an ordinary annuity. Investors discount those payments, plus the face value returned at maturity, to decide what the bond is worth today.
- Retirement planning: If you want a pension or withdrawal plan that pays you $2,000 a month for 25 years, present value tells you how large your account needs to be on the day withdrawals start.
- Legal settlements: Courts use present value to convert a stream of future damages or structured settlement payments into a single lump sum.
Calculating in Excel
You do not need to work through the formula by hand. Excel’s built-in PV function handles it directly. The syntax is:
PV(rate, nper, pmt, [fv], [type])
- rate: the discount rate per period
- nper: the number of periods
- pmt: the payment amount per period
- fv: optional, any lump sum received at the end (enter 0 or leave blank for a pure annuity)
- type: enter 0 or leave it blank for an ordinary annuity (payments at end of period); enter 1 for an annuity due
For the earlier example, you would type =PV(0.06, 5, -1000, 0, 0) and get approximately $4,212.36. The payment is entered as a negative number because Excel treats cash outflows and inflows with opposite signs. If you enter the payment as positive, the result will display as negative, which just indicates direction of cash flow.
Number of Periods and Payment Frequency
One common stumbling block is making sure the discount rate and the number of periods use the same time unit. If payments are monthly, the rate must be a monthly rate and the number of periods must be in months. A 6% annual rate on a 5-year annuity with monthly payments means you would use 0.5% (0.06 / 12) as the rate and 60 as the number of periods, not 6% and 5.
Longer annuities and more frequent payments both increase the present value because you are receiving more total payments. But each additional payment in the far future adds a smaller increment to the present value, since it gets discounted more heavily. This is why doubling the number of years does not double the present value.