How to Find Present Value on a Financial Calculator

Present value answers one of the most useful questions in finance: what is future money worth today? It is how you compare a lump sum with installments, price a bond, value a pension, or decide whether an investment is worth its cost. This guide shows how to find present value three ways (by formula, on a financial calculator and in Excel) for a single amount, a stream of payments and a bond.

The present value formulas

A single future amount:

PV = FV ÷ (1 + i)^n

A level payment every period (ordinary annuity):

PV = PMT × (1 − (1 + i)^−n) ÷ i

i is the rate per period and n is the number of periods. For payments at the start of each period (an annuity due), multiply the annuity result by (1 + i). Our present value calculator handles both, plus the compounding frequency.

Worked example 1: a single future amount

What is $10,000 received in 10 years worth today at 5%?

• By formula: 10,000 ÷ 1.05¹⁰ = 10,000 × 0.613913 = $6,139.13.
• BA II Plus: set P/Y = 1 (2nd → I/Y, 1, ENTER, 2nd → CPT), clear TVM (2nd → FV), then 10 N, 5 I/Y, 0 PMT, 10000 FV, CPT → PV = −6,139.13.
• HP 12C: f → CLEAR FIN, 10 n, 5 i, 0 PMT, 10000 FV, PV = −6,139.13.
• TI-84: TVM Solver with N = 10, I% = 5, PMT = 0, FV = 10000, P/Y = C/Y = 1, then solve PV = −6139.13.
• Excel: =PV(5%,10,0,10000) = −6,139.13.

The minus sign means “you would pay this today to receive $10,000 later”. With monthly compounding (N = 120, P/Y = 12), the present value is $6,071.61.

Worked example 2: a stream of payments

What is $1,000 a year for 10 years worth today at 5%?

• Formula: 1,000 × (1 − 1.05⁻¹⁰) ÷ 0.05 = $7,721.73.
• Calculator: 10 N, 5 I/Y, 1000 PMT, 0 FV, CPT → PV = −7,721.73.
• Excel: =PV(5%,10,1000) = −7,721.73.

If each payment arrives at the start of the year (BGN mode, or type = 1 in Excel), the value rises to $8,107.82, because every payment comes a year sooner.

A pension of $2,000 a month for 25 years, discounted at 4%, is worth about $378,904.97 today. That is the number to compare with a lump-sum offer.

Worked example 3: the present value of a bond

A bond pays a $50 coupon each year for 10 years and returns its $1,000 face value at the end. If similar bonds yield 6%, what is it worth?

• Calculator: 10 N, 6 I/Y, 50 PMT, 1000 FV, CPT → PV = −926.40.
• Excel: =PV(6%,10,50,1000) = −926.40.

The bond’s 5% coupon is below the 6% market yield, so it trades at a discount, about $926.40. Solving a problem like this is exactly what the finance calculator is built for.

Present value of uneven cash flows

When the amounts differ from year to year, discount each one separately and add them up:

PV = CF1 ÷ (1 + i) + CF2 ÷ (1 + i)² + CF3 ÷ (1 + i)³ + …

Example: a small project returns $3,000, $4,000 and $5,000 over the next three years. At 8%:

Year	Cash flow	Discount factor	Present value
1	$3,000	1 ÷ 1.08	$2,777.78
2	$4,000	1 ÷ 1.08²	$3,429.36
3	$5,000	1 ÷ 1.08³	$3,969.16
Total			$10,176.29

If the project costs less than $10,176.29 today, it earns more than 8%. That difference is its net present value. On a BA II Plus, use the CF worksheet: CF0 = 0, C01 = 3,000, C02 = 4,000, C03 = 5,000, then NPV with I = 8. In Excel, use =NPV(8%, 3000, 4000, 5000).

Lump sum or payments? Using present value to decide

Present value is the fair way to compare a lump sum with a series of payments. Suppose you’re offered $500,000 now or $40,000 a year for 20 years:

• At a 5% discount rate, the payments are worth $498,488.41 today, slightly less than the lump sum.
• At 3%, they are worth $595,098.99, so the payments come out ahead.

The right answer depends on the return you could earn on the lump sum, plus taxes, your health and your need for flexibility. The present value calculation turns the decision into a direct comparison.

Everyday example: pay yearly or monthly?

Insurers, gyms and software companies often offer a choice: pay $1,200 once a year, or $105 a month (twelve payments starting today, $1,260 in total). Monthly looks only slightly more expensive, but present value shows the hidden cost.

Paying monthly is like borrowing the $1,200 and repaying it at $105 a month. The rate that makes twelve $105 payments, the first due today, worth exactly $1,200 is about 0.9% a month, or 10.8% a year. That is roughly 11.35% effective. Unless you’d otherwise borrow at a higher rate, or the cash is better used paying down expensive debt, the annual payment is the better deal.

On a financial calculator, set BGN, then N = 12, PV = 1,200, PMT = −105, FV = 0, and solve for I/Y.

Choosing the discount rate

The present value is only as good as the rate you use:

• Safe, guaranteed payments: use a savings or government bond rate.
• Business projects: use the company’s cost of capital or required return.
• Personal decisions: use the return you could realistically earn on the money elsewhere.

A higher rate always gives a lower present value. To see the same relationship running forward, from today’s money to the future, try the compound interest calculator. To find the rate implied by a price you’ve been offered, use the interest rate calculator.

Common mistakes

• Forgetting to set P/Y = 1 for yearly problems. The default on many calculators is 12.
• Mismatched periods. Monthly payments need a monthly rate and a number of months.
• Ignoring payment timing. Rent, leases and many annuities pay in advance, so use BGN.
• Reading the minus sign as an error. It is the sign convention working as intended.
• Ignoring taxes. If the future money will be taxed and the alternative won’t be, or the other way round, discount the after-tax amounts so you compare like with like.
• Treating present value as a forecast. It is a comparison at the rate you chose, not a prediction of what will happen.
• Using Excel’s NPV for present value of a lump sum. Use PV, or remember that NPV discounts the first cash flow by one period.

Frequently asked questions

Why is present value negative on my financial calculator?

Because of the sign convention. If the future amount is money you will receive (positive), the present value is what you would have to pay today to get it, so it shows as negative. The size of the number is the present value.

How do I calculate present value with monthly compounding?

Use the monthly rate (annual rate ÷ 12) and the number of months. $10,000 in 10 years at 5% compounded monthly is 10,000 ÷ (1 + 0.05/12)^120 = $6,071.61.

What is the Excel formula for present value?

=PV(rate, nper, pmt, [fv], [type]). For $10,000 in 10 years at 5%, =PV(5%,10,0,10000) returns −6,139.13. For $1,000 a year for 10 years, =PV(5%,10,1000) returns −7,721.73.

What is the difference between PV and NPV?

PV values a set of future cash flows. NPV subtracts the upfront cost, so it shows whether an investment creates value at your discount rate. In Excel, the NPV function assumes the first cash flow comes one period from now.