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 C arriving at time t , discounted at rate r per period, has present value C ( 1 + r ) − t . For a dated stream C 0 , C 1 , … , C n the net present value is

NPV ( r ) = ∑ t = 0 n C t ( 1 + r ) t .

An annuity pays a constant C at the end of each of n periods. Summing the geometric series gives

PV = C 1 − ( 1 + r ) − n r .

A perpetuity pays C forever. Letting n → ∞ with r > 0 sends ( 1 + r ) − n → 0 , leaving

PV = C r .

The internal rate of return is a rate r ∗ at which NPV ( r ∗ ) = 0 . Written in terms of x = ( 1 + r ) − 1 this is a polynomial equation in x , so the internal rate of return is a root, and the usual facts about roots apply: there may be none in the admissible range, exactly one, or several. By Descartes' rule, the number of positive roots is bounded by the number of sign changes in the stream.

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 r must match the period of the cash flows. An annual rate applied to monthly payments overstates the discounting unless converted, and the conversion is ( 1 + r annual ) 1 / 12 − 1 rather than division by twelve.

  • The perpetuity formula requires r > 0 . As r → 0 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 n payments equals the sum advanced, which is the annuity formula solved for C rather than for the value. The quoted rate and the payment are two views of one equation.

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 C / r , and the formula makes the dependence on the rate stark: at 5 % a payment of 1000 needs 20,000 , at 2.5 % it needs 40,000 . Halving the assumed rate doubles the capital required, which is why endowment arithmetic is so sensitive to the long-run return assumed.

---

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: 1200 at year 1B: 2100 at year 5
internal rate 20.00 % 15.9962 %
NPV at 10 % 90.9091 303.9348
NPV at 18 % 16.9492 − 82.0706

The internal rate ranks A above B at every discount rate, because it consumes none. Net present value ranks B above A below 15.0163 % and A above B beyond it. A firm borrowing at 10 % that followed the internal rate would give up 213.03 per 1000 committed.

Twenty payments against infinitely many.

20 years at 5 % forever at 5 %
present value 12,462.210343 20,000
share of the perpetuity 62.31 % 100 %

Everything from year 21 to the end of time is worth 7,537.79 , less than the first two decades. The difference between a long stream and an endless one is smaller than the difference between their descriptions.

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: − 1000 , + 2600 , − 1650 is zero at 10 % and at 50 % . The difference is not the size of the flows but the number of direction changes, which is why counting signs is the first step rather than an afterthought.

Annual rate divided by twelve against the twelfth root.

At a quoted 12 % , the monthly equivalents are 1 % by division and 0.9489 % by ( 1.12 ) 1 / 12 − 1 . The first overstates the monthly rate, and over a long stream the error accumulates in the same direction throughout. Both appear in practice; they price different contracts, and which is correct depends on how the quoted rate was defined rather than on preference.

A ratio against an amount.

A project turning 10 into 12 has an internal rate of 20 % ; one turning 10,000 into 11,500 has 15 % . The rate prefers the first and the second leaves the firm 1,500 better off. A ratio cannot express magnitude, which is a limitation of the quantity rather than a mistake in computing it.

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 − 1000 , + 2600 , − 1650 have net present value exactly zero at both 10 % and 50 % , positive strictly between them and negative outside, so there are two internal rates and neither is "the" one. Software returning a single figure has found one root, usually the first encountered from its starting guess, and reports it without indicating that others exist.

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 1200 at the end of one period on an outlay of 1000 has an internal rate of 20.00 % ; a project paying 2100 after five periods on the same outlay has 15.9962 % . The internal rate prefers the first at every discount rate. Net present value prefers the second below 15.0163 % and the first above it: at 10 % the values are 90.91 against 303.93 , and at 18 % they are 16.95 against − 82.07 . The internal rate is also insensitive to scale, so a small project with a high rate outranks a large one that creates far more value.

Related units

Requires

Connected

Learn this topic

Used in

Sources

Results update as you type. Use the up and down arrow keys to move between results, Enter to open one, and Escape to close.

Type to search.

Settings

Appearance

Interface density

Your record

Your progress is stored in this browser and nowhere else: an identifier, the answers you have given, the mastery states and review schedule derived from them, and the lesson you last opened. Clearing it makes you a new learner on this device. It cannot be undone, and it will not affect your appearance or density settings.

Focus timer

Focus--minutes remaining

Phase

Kept in this browser only, and used to label the session in your own history.

Today

Nothing recorded yet. Finish a focus session and it will appear here.

Settings

Focus sessions between long breaks.

Sessions you are aiming for in a day.

Notifications

Your history

Sessions are stored in this browser and nowhere else. They are not evidence and never reach your mastery record.