What this calculator does
The Present Value of Uneven Cash Flows Calculator finds today's worth of a series of future cash flows. Each "line" describes a cash flow amount that repeats for a chosen number of consecutive periods, so you can describe both even annuities and irregular streams compactly. It is conceptually equivalent to Excel's NPV() for end-of-period flows, with an annuity-due adjustment for beginning-of-period timing, and it also supports compounding more than once per period.
How to use it
Enter the discount rate per period, how many times interest compounds within one period, whether cash flows occur at the beginning or end of each period, and how many lines you need. For each line, give the number of consecutive periods and the cash flow amount (commas allowed). The tool expands the lines into a chronological stream and discounts every period.
The formula
First convert the nominal per-period rate into an effective per-period rate accounting for compounding m times per period: $$r = \left(1 + \frac{i}{m}\right)^m - 1,$$ where \(i = \text{ratePercent} / 100\). For end-of-period flows, \(\text{PV}[t] = CF[t] / (1 + r)^t\). For beginning-of-period flows (annuity-due), \(\text{PV}[t] = CF[t] / (1 + r)^{t-1}\). The total present value is the sum of all \(\text{PV}[t]\).
Worked example
With rate 4%, \(m = 12\), end-of-period, and three lines (5 periods of 925.00, 5 periods of 725.25, 1 period of 2,500.00), the effective rate is $$r = \left(1 + \frac{0.04}{12}\right)^{12} - 1 \approx 0.0407415$$ (about 4.07415%). Discounting all 11 periods gives a total present value of about $8,359.44.
How Rate and Timing Change the Present Value
The table below uses one fixed uneven stream: 5 periods of 925.00 (periods 1–5), then 5 periods of 725.25 (periods 6–10), then 1 period of 2,500.00 (period 11). The undiscounted total is 4,625.00 + 3,626.25 + 2,500.00 = 10,751.25. Compounding is set to 1 per period, so the effective rate per period equals the stated rate. All amounts are in the same currency unit.
| Discount rate | PV, end of period (ordinary) | PV, beginning of period (annuity-due) | Beginning − End |
|---|---|---|---|
| 0% | 10,751.25 | 10,751.25 | 0.00 |
| 2% | 9,466.79 | 9,656.13 | 189.34 |
| 4% | 8,395.63 | 8,731.46 | 335.83 |
| 8% | 6,736.24 | 7,275.14 | 538.90 |
Two patterns stand out:
- Higher rate, lower PV. Every cash flow is divided by a larger factor \((1+r)^t\), and later flows are reduced the most. At 8% the PV is about 63% of the undiscounted total.
- Timing multiplier. Moving every payment from the end to the beginning of its period brings each one forward by one period, so \(PV_{\text{begin}} = PV_{\text{end}} \times (1+r)\). For example, at 4%: \(8{,}395.63 \times 1.04 \approx 8{,}731.46\). At 0% the two are identical because no discounting occurs.
Figures are rounded to two decimals; small differences of 0.01 can arise from rounding.
Key Terms and Variables
- Present value (PV): the amount today that is equivalent to a future cash flow, or a stream of them, at a chosen discount rate.
- Discount rate (Rate %): the annual percentage rate used to translate future money into today's terms. It reflects the return you could earn elsewhere or the risk you assign to the flows.
- Effective rate per period (r): the rate actually applied per period after compounding: \(r = \left(1 + \frac{R}{100\,m}\right)^{m} - 1\), where \(R\) is the rate in percent and \(m\) is the compounding count.
- Compounding times per period (m): how many times interest is compounded within one period. With \(m = 1\), \(r = R/100\). Larger \(m\) gives a slightly higher effective rate and a lower PV.
- Cash flow line: one row of input made up of a number of consecutive periods and the cash flow amount received in each of them (for example, 5 periods of 925.00).
- End-of-period (ordinary) timing: each cash flow occurs at the end of its period, so the first flow is discounted by one full period.
- Beginning-of-period (annuity-due) timing: each cash flow occurs at the start of its period, so every flow is discounted one period less. The PV is the end-of-period PV × (1 + r).
- Discount factor: \(1/(1+r)^t\), the number you multiply a period-\(t\) cash flow by to get its present value.
- Even vs uneven cash flows: even (an annuity) means identical amounts each period; uneven means amounts vary from period to period, so each must be discounted individually and then summed.
Interpreting the Present Value Result
The present value is the single lump sum today that is financially equivalent to the whole stream of future cash flows, given the discount rate and timing you assumed. If you could invest that lump sum at the discount rate, it would be able to reproduce the stream.
- Rate effect: a higher discount rate lowers the PV, and a lower rate raises it. At 0% the PV equals the simple sum of the flows.
- Timing effect: flows received later are discounted more heavily, so a stream weighted toward distant periods has a lower PV than the same total received sooner. Beginning-of-period timing raises the PV by a factor of \(1+r\) compared with end-of-period timing.
- Link to NPV: comparing the PV of future inflows with an upfront cost is the basis of net present value: \(NPV = PV - \text{initial cost}\). A positive NPV means the discounted inflows exceed the cost at that rate; a negative NPV means they do not.
- Assumption sensitivity: the result depends entirely on the assumed rate, compounding, and timing, and it treats the cash flows as certain. Test several plausible rates, as in the comparison table above, rather than relying on one number.
This is general educational information, not financial advice. For decisions about investments, loans, or contracts, consult a qualified professional.
FAQ
What if the rate is zero? Each discount factor becomes 1, so the present value equals the simple sum of all cash flows.
What does compounding times per period mean? It splits one period into m sub-intervals (e.g. monthly compounding within an annual period), raising the effective per-period rate above the nominal rate.
How do beginning and end timing differ? Beginning-of-period treats each flow as occurring one period earlier, so \(\text{PV}_{\text{beginning}} = \text{PV}_{\text{end}} \times (1 + r)\).