Present Value of Multiple Cash Flows: How to Value a Series of Payments
In this chapter
Intermediate
You’re due $420.00 a year from now and $780.00 three years from now. What are those payments worth together today? At a 7.00% annual discount rate, their present value is $1,029.24.
The present value of a series is its equivalent value on the date you choose for the calculation. To find it, bring each payment back to that date and add the results. In this case the $780.00 has three years to travel back, and the $420.00 has one.
The examples use U.S. dollars and value the cash flows today. The first year-end is one year from today, and the later year-ends are one year apart. The monthly question uses full months. Unless an example or question specifies changing rates, the discount rate is fixed per period. Keep full precision until you round the final dollar result to cents.
Put the cash flows on a timeline
A cash flow is a receipt or payment at a particular time. A cash flow timeline places each receipt or payment on its date. Its starting date is time zero, the date as of which you want the value.
Write a cash inflow, money you receive, as positive. Write a cash outflow, money you pay, as negative. Use the same point of view throughout. If a date has several payments, you can add their signed amounts before discounting because they share the same date and factor.
Discount each amount, then add
Discounting moves an amount back to an earlier date. The discount rate is the rate used per period in that calculation. With a fixed rate \(r\), divide by \(1+r\) once for each period between the payment and today.
\[ PV=\sum_{t=0}^{N}\frac{CF_t}{(1+r)^t} \]
| Symbol | Meaning | Unit |
|---|---|---|
| \(PV\) | Present value of all the signed cash flows at time zero | USD |
| \(CF_t\) | Signed cash flow at date \(t\), after combining any amounts on that date | USD |
| \(r\) | Constant discount rate for one period | Decimal rate per period |
| \(t\) | Number of periods from today to that cash flow | Periods |
| \(N\) | Number of periods from today to the final cash flow | Periods |
The symbol \(\sum\) means add the discounted amounts from time zero through the last date. Match the rate to the period. With months as periods, use a rate per month and count months in the exponent. With a zero discount rate, every denominator is 1 and the result is the sum of the signed amounts. For equal, regularly spaced payments, the present value of an annuity gives you a shortcut. The same approach works when valuing a bond’s scheduled payments.
Worked example 1. Keep the gap between payments
Use 7.00% per year to value the opening example. The payment at the end of year three is three periods away. Year two has no cash flow, and that year still counts when you work out the time to the final payment.
| Date | Signed cash flow (USD) | Discount calculation | Present value (USD) |
|---|---|---|---|
| End of year 1 | +$420.00 | \(\$420.00/1.07\) | $392.52 |
| End of year 2 | $0.00 | \(\$0.00/1.07^2\) | $0.00 |
| End of year 3 | +$780.00 | \(\$780.00/1.07^3\) | $636.71 |
Add the unrounded amounts to get $1,029.24 today. The displayed entries are rounded separately, so adding them as shown gives a total one cent lower.
Worked example 2. Include an upfront payment
A project requires $1,050.00 today and is expected to bring in $640.00 at the end of year one and $610.00 at the end of year two. Use an 8.00% annual discount rate.
The upfront payment belongs at time zero with a negative sign. Its denominator is \((1+0.08)^0=1\), since the money leaves today.
\[ PV=-\$1{,}050.00+\frac{\$640.00}{1.08}+\frac{\$610.00}{1.08^2} \approx \$65.57 \]
At the stated rate, the two future receipts together are worth about $1,115.57 today. Subtract the $1,050.00 paid today to get the signed present value of $65.57. That difference is the project’s net present value at the stated rate.
Use discount factors when rates change between periods
A discount factor is the multiplier that takes a payment from its date back to the valuation date. If you know the factor \(DF_t\) for each date \(t\), multiply each cash flow by its own factor and add.
\[ PV=\sum_{t=0}^{N}CF_t DF_t \]
At time zero, \(DF_0=1\). When the rate changes from period to period, find the factor \(DF\) for a payment \(n\) periods away by multiplying the growth factors along the way and taking the reciprocal.
\[ DF=\frac{1}{(1+r_1)(1+r_2)\cdots(1+r_n)} \]
Here \(r_1,r_2,\ldots,r_n\) are the decimal rates for successive periods, with \(r_n\) applying to the last period before the payment. The factor \(DF\) has no unit. Multiplying it by a cash flow in U.S. dollars gives its value today in U.S. dollars.
Worked example 3. Use a different rate for each year
You expect to receive $350.00 at the end of year one and $900.00 at the end of year two. The one-year discount rate is 4.00% from today to the end of year one and 7.00% from the end of year one to the end of year two.
| Date | Cash inflow (USD) | Discount factor calculation | Present value (USD) |
|---|---|---|---|
| End of year 1 | $350.00 | \(1/1.04\) | $336.54 |
| End of year 2 | $900.00 | \(1/(1.04\times 1.07)\) | $808.77 |
The year-two payment travels back through both years, so its factor uses both rates. The total present value is $1,145.31 after rounding. You can also compare payment schedules at a later date by moving each cash flow to that date before adding.
Practice questions
1. Discount payments with a year between them
You receive $300.00 at the end of year one and $700.00 at the end of year three. Use a 6.00% annual discount rate. What is the present value?
2. Include today’s payment
You pay $800.00 today and receive $460.00 at the end of year one and $440.00 at the end of year two. At 5.00% per year, what’s the total signed present value?
3. Combine an inflow and an outflow on the same date
You receive $540.00 at the end of year one. At the end of year two, you receive $360.00 and pay $180.00. Use a 7.50% annual discount rate. What’s the total signed present value?
4. Match a monthly rate with monthly dates
You receive $260.00 two months from today and $390.00 five months from today. The discount rate is 1.20% per month. What is the present value?
5. Discount through two different rates
You receive $500.00 at the end of each of the next two years. The one-year discount rate is 5.00% over the first year and 9.00% over the second. What is the present value?
6. Compare equal totals paid on different dates
Schedule A pays you $600.00 at the end of year one and $600.00 at the end of year three. Schedule B pays you $600.00 at the end of year two and $600.00 at the end of year three. Use the same positive annual discount rate for both. Which has the higher present value?