Present Value Calculator: Find Today's Worth of Future Cash Flows
Calculate the present value of a lump sum, annuity payments, or uneven cash flows. Our free PV calculator supports multiple compounding frequencies, payment timing options, and generates instant charts with a full discount schedule.
What Is Present Value?
Present value (PV) is the current worth of a future sum of money or a series of future cash flows, discounted at a specific rate of return. It is one of the most important concepts in finance, rooted in the time value of money — the principle that a dollar received today is worth more than a dollar received in the future.
Why? Because money available now can be invested and earn a return. If you can earn 6% per year, receiving $10,000 today is better than receiving $10,000 five years from now, since today's $10,000 could grow to $13,382 over that period. Conversely, $10,000 received in five years is only worth $7,473 in today's terms at a 6% discount rate.
Present value analysis is used extensively in:
- Bond valuation — pricing coupon payments and face value
- Capital budgeting — evaluating project profitability via NPV
- Retirement planning — determining how much to save today
- Loan analysis — calculating the true cost of borrowing
- Legal settlements — valuing structured payouts in today's dollars
Present Value Formula
The fundamental present value formula discounts a single future amount back to today:
Where:
- PV = Present Value (what the future amount is worth today)
- FV = Future Value (the amount to be received in the future)
- r = Annual discount rate (as a decimal, e.g. 0.06 for 6%)
- m = Number of compounding periods per year
- n = Number of years
For annual compounding (m = 1), this simplifies to:
PV = $100,000 ÷ (1.07)15 = $100,000 ÷ 2.7590 = $36,245
The discount factor — 1 / (1+r)n — is the key multiplier. A higher rate or longer time period produces a smaller discount factor, resulting in a lower present value.
Present Value of an Annuity
When you receive (or pay) a series of equal payments over time, you need the present value of an annuity formula:
Where:
- PMT = Payment amount per period
- r = Discount rate per period
- n = Total number of payment periods
For an annuity due (payments at the beginning of each period), multiply by (1 + r):
Practical Examples
Lottery Winnings: You win a lottery that pays $50,000 per year for 20 years. At an 8% discount rate, the present value is:
This means the "million-dollar" lottery (20 × $50,000 = $1,000,000) is actually worth about $491,000 in today's money — less than half the headline number.
Mortgage Valuation: A 30-year mortgage at 6.5% with $2,000 monthly payments has a present value (loan amount) of:
Present Value of Uneven Cash Flows
Not all investment returns come as equal payments. Many real-world scenarios involve uneven (irregular) cash flows — varying amounts received at different times. Examples include:
- Business investment projects with varying annual revenues
- Real estate rental income that changes over time
- Stock dividends that grow or fluctuate each year
- Legal settlements with structured payouts
To find the present value of uneven cash flows, discount each individual cash flow separately and sum them:
PV = $5,000/1.10 + $7,000/1.21 + $10,000/1.331
PV = $4,545 + $5,785 + $7,513 = $17,843
The total future cash flows are $22,000, but their present value is only $17,843 — a discount of $4,157 (18.9%).
Our calculator's "PV of Cash Flows" tab lets you enter any number of uneven future payments and instantly calculates the total present value with a year-by-year discount schedule.
Present Value vs Future Value
Present Value and Future Value are two sides of the same coin in the time value of money framework. They are mathematical inverses:
| Aspect | Present Value (PV) | Future Value (FV) |
|---|---|---|
| Direction | Backward in time (discounting) | Forward in time (compounding) |
| Question | "What is future money worth today?" | "What will today's money be worth later?" |
| Formula | PV = FV ÷ (1+r)n | FV = PV × (1+r)n |
| Common Uses | Bond pricing, loan valuation, NPV analysis | Savings goals, retirement projections |
| As rate increases | PV decreases | FV increases |
| As time increases | PV decreases | FV increases |
In essence, discounting is the reverse of compounding. If you invest $7,473 today at 6% for 5 years, it grows to $10,000 (FV). Conversely, $10,000 received in 5 years has a present value of $7,473 at a 6% discount rate.
How to Calculate PV in Excel
Microsoft Excel and Google Sheets include a built-in =PV() function:
- rate — Discount rate per period (e.g., 6%/12 = 0.5% for monthly)
- nper — Total number of periods (e.g., 10 years × 12 = 120 months)
- pmt — Payment per period (enter as negative for money received)
- fv — Future lump sum (enter as negative; optional)
- type — 0 = end of period (default), 1 = beginning of period
Excel Examples
=PV(0.06, 10, 0, -50000) → $27,919.74
=PV(0.05/12, 60, -1000) → $52,990.71
=NPV() function:=NPV(0.08, 5000, 7000, 8000, 10000, 12000) → $33,638.83This discounts each value at 8% for its respective year.
For Google Sheets, the syntax is identical. Note that Excel's =PV() returns a negative value (representing a cash outflow), so you can wrap it in =ABS() if needed.
PV Calculation Examples
Example 1: Lump Sum — College Savings Goal
You want to have $200,000 for your child's college education in 18 years. How much do you need to invest today at 7% annual return (compounded annually)?
You need to invest $59,172 today to reach your $200,000 goal. The discount of $140,828 represents the interest that will be earned over 18 years.
Example 2: Annuity — Pension Valuation
A pension plan offers $3,000 per month for 25 years after retirement. Assuming a 5% discount rate with monthly compounding, what is the lump-sum equivalent?
The $900,000 in total payments ($3,000 × 300 months) is worth $511,567 today — a helpful benchmark when comparing lump-sum vs. annuity pension options.
Example 3: Uneven Cash Flows — Business Investment
A business project requires a $100,000 investment and is expected to generate the following returns:
| Year | Cash Flow | PV at 12% |
|---|---|---|
| 1 | $20,000 | $17,857 |
| 2 | $30,000 | $23,916 |
| 3 | $40,000 | $28,471 |
| 4 | $35,000 | $22,237 |
| 5 | $25,000 | $14,186 |
| Total | $150,000 | $106,667 |
The NPV = $106,667 − $100,000 = +$6,667. Since NPV is positive, this investment creates value and should be accepted.
Frequently Asked Questions About Present Value
-
Present value (PV) is the current worth of a future sum of money or stream of cash flows, given a specified rate of return (the discount rate). It is based on the time value of money principle — a dollar today is worth more than a dollar in the future because it can be invested and earn returns. PV is calculated using the formula: PV = FV / (1 + r)n.
-
Present Value (PV) discounts a single future cash flow or a series of equal cash flows to today's value. Net Present Value (NPV) is the sum of all discounted future cash flows minus the initial investment cost. NPV = −Initial Cost + ∑ PV of future cash flows. A positive NPV means the investment earns more than the discount rate and is considered profitable.
-
A higher discount rate reflects a greater opportunity cost or risk premium. If you can earn 10% elsewhere versus 5%, a future payment is "less attractive" compared to what you could earn independently. Mathematically, the denominator (1 + r)n grows larger with a higher rate, resulting in a smaller PV. For example, $10,000 in 10 years: at 5% PV = $6,139; at 10% PV = $3,855.
-
The appropriate discount rate depends on context: Risk-free rate (3–5%, Treasury yields) for guaranteed payments; Expected market return (8–10%) for equity investments; WACC (weighted average cost of capital) for corporate projects; Personal required return for individual investment decisions. Higher risk always warrants a higher discount rate to compensate for uncertainty.
-
A perpetuity is an annuity that lasts forever. Its present value formula is surprisingly simple: PV = PMT / r, where PMT is the periodic payment and r is the discount rate per period. For a growing perpetuity: PV = PMT / (r − g), where g is the growth rate. For example, $1,000 per year forever at 5%: PV = $1,000 / 0.05 = $20,000.
-
The present value of a positive future cash flow is always positive. However, in practice, when you subtract the initial investment cost (as in NPV analysis), the result can be negative — indicating the investment would lose value. A negative NPV means you'd be better off investing your money at the discount rate elsewhere.
-
More frequent compounding produces a lower present value (the opposite effect vs. future value). With monthly compounding versus annual, the effective discount rate is slightly higher, so the future amount is discounted more aggressively. For example, $10,000 in 10 years at 6%: annually PV = $5,584; monthly PV = $5,496; daily PV = $5,488.