Valuing a Stream of Dated Payments
Why a payment's value depends on when it arrives, the closed forms for level and perpetual streams, how competing projects are ranked by net present value at a stated rate, and why the internal rate of return can be non-unique or disagree with that ranking.
Definition
A cash flow
An annuity pays a constant
A perpetuity pays
The internal rate of return is a rate
Net present value is additive across projects and depends on the rate; an internal rate of return is neither. Two projects can therefore be ranked one way by their internal rates and the other way by net present value, with the ranking reversing at a particular discount rate.
Assumptions and scope
The rate
must match the period of the cash flows. An annual rate applied to monthly payments overstates the discounting unless converted, and the conversion is rather than division by twelve.The perpetuity formula requires
. As the value diverges, which correctly reports that an infinite undiscounted stream has no finite value.Net present value assumes the discount rate is the rate at which the decision-maker can genuinely lend and borrow. Where that rate is uncertain or differs by direction, the criterion still applies but its input is a range rather than a number.
An internal rate of return exists in the admissible range only when the stream changes sign at least once. A stream of uniformly positive flows has no root and no internal rate.
Where a stream changes sign more than once, multiple roots are possible but not guaranteed; the sign-change count bounds the number of positive roots rather than determining it.
Net present value is additive across independent projects, so a portfolio's value is the sum of its parts. Internal rates are not additive, and averaging them is meaningless.
Worked material
Example
Five streams and the criterion each one calls for
A bond paying a fixed coupon to maturity. A level stream with a lump sum at the end: the annuity formula prices the coupons and one discount factor prices the redemption. The stream changes sign once, from the purchase outflow to the receipts, so its internal rate exists and is unique. This is the redemption yield, and quoting it is standard precisely because uniqueness is guaranteed here.
A mortgage. The same arithmetic run backwards. The payment is chosen so the present value of
Two mutually exclusive capital projects. The case where the criterion matters. If one is short and one is long, their internal rates can rank them opposite to net present value, and the ranking depends on the firm's cost of capital. Reporting net present value across a range of rates answers the question; reporting two internal rates does not.
A mine with restoration costs. Money out to open it, money in while it produces, money out to close the site. Two sign changes, so the present-value polynomial can have two roots, and the worked example shows a stream where it does. Here the internal rate is not merely misleading for ranking. It is not a well-defined number.
A perpetual endowment. A fund intended to pay a fixed sum forever is priced at
---
What decides the criterion in each case. The first two ask for a rate and the stream's single sign change makes that rate well defined. The third asks which project to fund, which depends on a rate the criterion must accept as input. The fourth has no single rate to report. The fifth is a pricing question with no ranking at all. The pattern is that the internal rate answers at what rate does this break even and nothing else; where the question is different, so is the tool.
Contrast
Pairs that differ in one respect
Net present value against internal rate, on the same two projects.
| A: | B: | |
|---|---|---|
| internal rate | ||
| NPV at | ||
| NPV at |
The internal rate ranks A above B at every discount rate, because it consumes none. Net present value ranks B above A below
Twenty payments against infinitely many.
| 20 years at | forever at | |
|---|---|---|
| present value | ||
| share of the perpetuity |
Everything from year 21 to the end of time is worth
One sign change against two.
A stream that goes out once and comes in thereafter has at most one positive root, so its internal rate is unique and quoting it is safe. A stream that goes out, comes in and goes out again may have two:
Annual rate divided by twelve against the twelfth root.
At a quoted
A ratio against an amount.
A project turning
Common errors
Common misconception
That every project has an internal rate of return, and exactly one. The internal rate is a root of the present-value polynomial in the discount factor, so the usual facts about roots apply. A stream whose cash flows are all the same sign has no root at all and no internal rate. A stream that changes sign more than once may have several: the flows
Common misconception
That between two projects the one with the higher internal rate of return is the better investment. The internal rate takes no discount rate as input, so it cannot express a preference that depends on the rate the decision-maker actually faces, and rankings frequently do depend on it. A project paying
Related units
Requires
Connected
- Optimal Solutions and Optimal Values (analogous to)
Learn this topic
Used in
Sources
- Investment Science (2013)
- Principles of Corporate Finance (2020)