Present value formulas
Present value is the amount that, invested today at the discount rate, would grow into the future money exactly. Discounting is compound interest run backwards. For one future amount:
PV = FV ÷ (1 + r ÷ m)m × t
PV is the present value, FV the future amount, r the yearly discount rate as a decimal, m the number of times it compounds in a year and t the time in years. With continuous compounding the divisor becomes er × t.
A stream of n equal payments is valued with the present value of an annuity formula, which is the sum of the lump-sum formula applied to every payment:
PV = PMT × (1 − (1 + i)−n) ÷ i
PMT is the payment and i is the discount rate for one payment period. That form is the ordinary annuity, with each payment at the end of its period. For an annuity due, with payments at the beginning, every payment arrives one period sooner, so the result is multiplied by (1 + i). When i is zero, PV is simply PMT × n.
If the payments rise by a fixed percentage g each year, with one payment at the end of each year, the growing annuity formula applies:
PV = PMT × (1 − ((1 + g) ÷ (1 + r))n) ÷ (r − g)
PMT is the first payment. When g equals r the formula divides by zero and is replaced by PV = PMT × n ÷ (1 + r). For payments made more often than yearly, this calculator raises the payment once every twelve months and adds up the discounted payments one by one.
When compounding and payments do not match
The quoted rate is first turned into an effective annual rate, (1 + r ÷ m)m − 1, and then into the rate for one payment period, i = (1 + effective rate)1 ÷ p − 1, where p is the number of payments a year. If compounding and payments have the same frequency, this is just r ÷ m.
Worked examples
A lump sum: $10,000 in 5 years at 8%
- Growth factor. Compounded yearly, 1.085 = 1.469328.
- Divide. $10,000 ÷ 1.469328 = $6,805.83.
- Check. $6,805.83 invested at 8% a year for 5 years grows back to $10,000.
Compounded monthly, the divisor is (1 + 0.08 ÷ 12)60 = 1.489846 and the present value falls to $6,712.10, because 8% compounded monthly is an effective 8.30% a year. Compounded continuously it is $6,703.20.
Equal payments: $1,000 a year for 5 years at 8%
- Discount factor. 1.08−5 = 0.680583.
- Annuity factor. (1 − 0.680583) ÷ 0.08 = 3.992710.
- Ordinary annuity. $1,000 × 3.992710 = $3,992.71.
- Annuity due. $3,992.71 × 1.08 = $4,312.13.
The five payments total $5,000, so discounting removes $1,007.29 from the ordinary annuity.
Growing payments: $1,000 rising 3% a year for 5 years at 8%
- Ratio. 1.03 ÷ 1.08 = 0.953704, and 0.9537045 = 0.788982.
- Apply the formula. $1,000 × (1 − 0.788982) ÷ (0.08 − 0.03) = $1,000 × 4.220351 = $4,220.35.
The payments themselves add up to $5,309.14.
Reading the sensitivity table
A present value is only as good as its discount rate, and the rate is an assumption. The table makes the dependence visible. For the $10,000 lump sum, a rate of 6% gives $7,472.58 and 10% gives $6,209.21, a spread of more than $1,260 around the 8% answer.
The effect grows with time. Push the same $10,000 out to 30 years and it is worth $993.77 at 8% but $1,741.10 at 6%: two percentage points now change the answer by three-quarters. Long-dated amounts are therefore the ones where the choice of rate deserves the most scrutiny.
Common mistakes and limits
Mixing real and nominal figures. If the future amounts are in future dollars, use a rate that includes inflation. If they are stated in today’s buying power, use a rate with inflation taken out. Choosing the wrong timing. Rent and insurance premiums are usually paid in advance and wages and loan repayments in arrears; the difference is a factor of (1 + i). Forgetting the compounding basis. The same quoted 8% gives three different answers above. Growth at or above the discount rate. For a fixed number of payments the calculation still works, but a stream that grows for ever at g only has a finite value, PMT ÷ (r − g), when g is below r.
The method assumes one constant rate, certain payments and no tax or fees. It makes no allowance for the chance that a payment is late or never arrives; any such risk has to be reflected in the rate you choose.