FIN 355 · Real Estate Investment Analysis

Internal rate of return as a zero-NPV solution

IRR is not entered into the equation as a known input. It is the discount rate that must be solved implicitly so that the present value of all cash flows equals zero.

Created by Desen Lin · California State University, Fullerton

1. The implicit equation

An IRR exists only when at least one admissible discount rate makes NPV exactly zero.

Definition
0 = NPV(IRR) = CF0 + Σt=1T CFt ÷ (1 + IRR)t

Because IRR appears inside every discount factor, the equation is generally solved iteratively rather than by rearranging it with ordinary algebra.

Economic meaning

At an IRR, the negative present value of investment outflows is exactly offset by the positive present value of inflows. IRR is a break-even discount rate, not necessarily the correct required return and not a complete measure of investment quality.

2. Build a cash-flow stream

Use a course example or enter your own annual cash flows.

Annual cash flows
TimeNet cash flow
Cash-flow timeline Inflows above zero; outflows below zero
Cash-flow timeline Positive cash flows appear above the zero line and negative cash flows appear below it.
IRR solutions Rates greater than −100%
Solved rate(s) Each makes NPV approximately zero
Cash-flow sign changes An upper bound, not a guarantee
NPV at selected rate At a 10.0% discount rate

3. Find IRR on the NPV profile

An IRR is an x-intercept: a discount rate where the NPV curve meets the zero line.

−20%Drag or click the chart80%
NPV profile IRR / zero-NPV solution Selected discount rate
Net present value profile The curve plots net present value against the discount rate. Internal rates of return are marked where the curve crosses zero.

Click anywhere inside the plot to evaluate NPV at that discount rate.

4. When one equation has multiple IRRs

Later negative cash flows can make the NPV profile non-monotonic and create more than one zero point.

A cash-flow stream with two solutions

Consider an initial outflow of $100, an inflow of $230 in Year 1, and another outflow of $132 in Year 2. The signs change twice: negative → positive → negative.

The NPV equation reaches zero at both 10% and 20%. The same project therefore has two mathematically valid IRRs, making the IRR decision rule ambiguous.

More precisely, these are multiple mathematical solutions to the zero-NPV equation, not separate market equilibria.

0 = −100 + 230 ÷ (1 + IRR)
− 132 ÷ (1 + IRR)2
IRR = 10% or 20%

Why future outflows matter

Major renovations, capital calls, debt payoffs, remediation, or other later costs can reverse the sign of the cash-flow stream. Those reversals can bend the NPV profile enough to cross zero more than once.

Possible does not mean guaranteed

The number of sign changes is an upper bound on the number of admissible IRRs. Two sign changes may produce two IRRs, one repeated IRR, or no real IRR. Always inspect the NPV profile or solve for all roots.

What to use instead

When multiple IRRs exist, do not rank or accept the investment using IRR. Evaluate NPV at the appropriate risk-adjusted required return and examine the underlying cash-flow pattern.

Decision rule: “IRR > required return” implies a positive NPV only under a conventional, uniquely solved NPV profile. With multiple IRRs, the rule can reverse across different discount-rate ranges and should not be used.

5. What IRR does not tell you

A solved rate is useful, but it is not an all-telling performance measure.

ScaleTwo investments can have the same IRR but very different dollar investments and NPVs.
Investment horizonIRR alone does not reveal whether the holding period is short or long.
Timing and sourceIt does not distinguish early from late cash flows or operations from refinancing and sale proceeds.
Risk and leverageIRR does not identify the correct discount rate, changing risk over time, or how much leverage produced the return.