Rate of Return Analysis

Rate of Return Analysis

$Learning Objectives$

Define IRR as a root of the net-present-worth function and interpret it for conventional investments.
Use an NPV-versus-rate profile to identify economically relevant roots and multiple-root risk.
Distinguish IRR from the MARR and from value-based measures such as NPV.
Perform incremental rate-of-return analysis for mutually exclusive alternatives.
Explain modified/external rate-of-return constructions without relying on an incorrect universal reinvestment interpretation of IRR.

$Internal Rate of Return (IRR)$

An internal rate of return $i^*$ is a discount rate at which the net present worth of the modeled cash flows equals zero.

IRR Root Equation

Defines each IRR as a root of the present-worth function.

0=PW(i^*)=\sum_{t=0}^{n}\frac{CF_t}{(1+i^*)^t}

Variables

Symbol	Description	Unit
$i^*$	Internal rate-of-return root	-
$CF_t$	Net cash flow at period t	-
$n$	Project horizon	-

$Conventional Investment Cash Flow$

A conventional investment cash-flow pattern has one initial net investment sign followed by cash flows of the opposite sign, producing one sign change in the ordered cash-flow sequence.

$IRR Decision Interpretation$

For a conventional independent investment with one economically relevant IRR, $IRR\ge MARR$ is consistent with $NPV(MARR)\ge0$ . When cash flows are nonconventional, have multiple roots, or have no useful IRR, evaluate the NPV profile directly rather than forcing a single percentage answer.

$NPV Profile$

An NPV profile is a graph of net present worth as a function of discount rate. IRRs occur where the profile equals zero. A simple root usually crosses the zero line; a repeated even-multiplicity root can touch zero and turn without changing sign. The value at the MARR is the project's NPV decision value.

$Interactive NPV-Rate Profile$

Change the defender and challenger cash flows to inspect stand-alone roots, challenger-minus-defender incremental roots, cash-flow sign changes, and incremental NPV at the MARR.

Common study life5 years

MARR12.00%

Defender — lower first investment

Initial investmentPHPAnnual net cash flowPHP/yearAdditional terminal cash flowPHP

Challenger — higher first investment

Initial investmentPHPAnnual net cash flowPHP/yearAdditional terminal cash flowPHP

Defender IRR root(s)

17.227%

1 cash-flow sign change; NPV at MARR = ₱138,176.

Challenger IRR root(s)

13.246%

1 cash-flow sign change; NPV at MARR = ₱52,191.

Incremental IRR root(s) — challenger minus defender

6.421%

1 incremental sign change. For a conventional incremental cash flow, compare the economically relevant incremental IRR with the MARR.

Incremental value at MARR

-₱85,985

The extra investment does not earn the stated MARR on the NPV basis; retain the defender.

Loading chart...

Vertical dotted markers show numerical IRR roots within the search interval, including a repeated root that can touch zero without producing an NPV sign crossing. The chart uses linear interpolation between computed samples so it does not invent additional curvature around nonconventional roots.

A high stand-alone IRR can belong to a small project that creates less total value. For mutually exclusive alternatives, evaluate the extra investment directly; if the incremental cash flow is non-conventional, NPV at the MARR is the more reliable decision anchor.

MARR10.00%

Common study life8 years

Alternative A

First costPHPAnnual net cash flowPHP/yearSalvagePHP

Alternative B

First costPHPAnnual net cash flowPHP/yearSalvagePHP

PW — Alternative A

₱1,741,625

Meets the MARR screen.

PW — Alternative B

₱1,968,658

Meets the MARR screen.

Preferred on this common basis

Alternative B

PW(B) − PW(A) = ₱227,033.

For unequal lives, do not force a common-life comparison without stating the repeatability assumption. Annual worth or a fixed study period is often clearer.

$Sign Changes Are a Warning, Not an Exact Root Count$

More than one sign change in the cash-flow sequence means multiple positive IRR roots may occur. It does not guarantee that every possible sign change produces a distinct economically meaningful root. Inspect the NPV profile or solve the polynomial numerically.

$A Sign-Crossing Scan Can Miss a Repeated IRR$

A numerical routine that only looks for intervals where NPV changes sign can miss an even-multiplicity root because the NPV curve may merely touch zero and remain on the same side. Robust root finding should also test stationary/tangent roots or solve the transformed polynomial over a stated rate interval. This is a numerical-method issue, not a new economic decision rule.

$Incremental Rate of Return$

Incremental ROR is the rate of return on the additional investment required to move from a lower-first-cost alternative (defender) to a higher-first-cost alternative (challenger), using the challenger-minus-defender cash-flow difference.

$Incremental ROR for Mutually Exclusive Alternatives$

STEP-BY-STEP

Ensure the alternatives satisfy the same service requirement and are compared on a consistent study basis.
Order alternatives by increasing first investment magnitude.
Form the incremental cash flow $\Delta CF=CF_{\text{challenger}}-CF_{\text{defender}}$ .
Determine whether the incremental cash flow has a conventional, interpretable ROR pattern.
If the economically relevant incremental IRR is at least the MARR, justify the additional investment and retain the challenger; otherwise retain the defender.
Continue sequentially through higher-cost alternatives.
Cross-check the final choice with PW/AW at the MARR, especially when incremental cash flows are nonconventional.

$Highest Stand-Alone IRR Is Not the Mutually Exclusive Rule$

A smaller project can have a very high percentage return while creating less total economic value than a larger project. Never select mutually exclusive alternatives merely by ranking their individual IRRs.

$Modified or External Rate of Return$

A modified/external rate-of-return measure separates the assumed finance rate for negative cash flows from the assumed reinvestment rate for positive cash flows, then reports the compound rate connecting their equivalent present and future values.

Modified Rate-of-Return Construction

One common MIRR/ERR form using a finance rate for negative flows and a reinvestment rate for positive flows.

1+i_m=\left(\frac{FW_{+}(i_r)}{PW_{-}(i_f)}\right)^{1/n}

Variables

Symbol	Description	Unit
$i_m$	Modified/external rate of return	-
$FW_{+}$	Future worth of positive cash flows at reinvestment rate i_r	-
$PW_{-}$	Magnitude of present worth of negative cash flows at finance rate i_f	-
$i_r$	Assumed reinvestment rate	-
$i_f$	Assumed finance rate	-
$n$	Study horizon	-

$IRR and Reinvestment Interpretation$

The IRR root equation is fundamentally an equivalence equation. It is unnecessary and potentially misleading to teach that every IRR calculation literally assumes each interim cash flow is reinvested at the IRR. Modified-rate measures are useful when the analyst explicitly wants to impose external finance and reinvestment rates.

$Minimum Attractive Rate of Return (MARR)$

The MARR is the externally selected hurdle rate used for the economic decision. It is an input to the study, not a project-generated IRR.

$MARR and Cost of Capital$

Financing cost, opportunity cost, organizational risk policy, project risk, and strategic constraints may all influence a chosen MARR. Do not state a universal rule that MARR must always exceed WACC by a fixed or positive margin.

$ROR Quality Checks$

Plot or sample NPV over rate when the cash-flow pattern is nonconventional.
Count sign changes as a warning indicator, not proof of root count.
Do not rely only on NPV sign crossings when numerical root multiplicity is possible.
Use incremental ROR for mutually exclusive alternatives.
Confirm the final recommendation with NPV or AW at the MARR when interpretation is ambiguous.
Report the search interval and assumptions when numerical root solving is used.

Key Takeaways

IRR is a root of the NPV equation, not the MARR itself.
Conventional independent investments often permit the familiar $IRR\ge MARR$ rule.
Nonconventional cash flows may produce multiple IRRs, repeated/tangent roots, no useful IRR, or ambiguous percentage measures.
The NPV profile shows both roots and the value at the decision rate; a repeated root can touch zero without crossing it.
Mutually exclusive alternatives require incremental analysis; highest stand-alone IRR is not a valid selection rule.
Modified/external rates explicitly impose finance and reinvestment assumptions and should be labeled as such.
Value-based cross-checks at the MARR are especially important when ROR interpretation is difficult.