Rate of Return Analysis

Rate of Return Analysis

The rate of return (ROR) is the interest rate paid on the unpaid balance of borrowed money, or the interest earned on the unrecovered balance of an investment. It is one of the most intuitive measures of an investment's profitability.

Key Takeaways

The Intrinsic Metric: Rate of return solves for the interest rate ( $i^*$ ) that equates present worth of benefits to present worth of costs.
Widespread Use: Often preferred by management over Present Worth because it provides a percentage yield that is easy to compare against other financial benchmarks.

Minimum Attractive Rate of Return (MARR)

Before evaluating any investment, an organization must establish a baseline or hurdle rate that any proposed project must exceed to be considered viable. This rate is known as the Minimum Attractive Rate of Return (MARR).

Minimum Attractive Rate of Return (MARR)

The lowest expected rate of return that an organization is willing to accept for a proposed project or investment. It serves as a cutoff rate; projects with an expected return below the MARR are typically rejected.

The MARR is influenced by several factors, including the cost of capital, the risk associated with the investment, the organization's current financial situation, and the returns available from other opportunities (opportunity cost).

Weighted Average Cost of Capital (WACC)

A critical component in determining the MARR is the Weighted Average Cost of Capital (WACC). This is the average rate that a company pays to finance its assets, calculated by weighting the cost of each capital component (equity and debt) according to its proportion in the company's capital structure.

WACC Formula

WACC = \left( \frac{E}{V} \times R_e \right) + \left( \frac{D}{V} \times R_d \times (1 - T_c) \right)

Where:

$E$ = Market value of the firm's equity
$D$ = Market value of the firm's debt
$V = E + D$ (Total market value of the firm's financing)
$R_e$ = Cost of equity
$R_d$ = Cost of debt
$T_c$ = Corporate tax rate

Because debt interest is often tax-deductible, the cost of debt is adjusted by

(1 - T_c)

. In practice, an organization's MARR will almost always be greater than its WACC to ensure a profit margin and account for project-specific risks.

Key Takeaways

The Hurdle Rate: The absolute minimum acceptable rate of return for any proposed investment.
WACC as a Foundation: A company's Weighted Average Cost of Capital (the blended cost of its debt and equity financing) forms the absolute floor for the MARR.
Risk Premium: MARR is typically set higher than WACC to account for specific project risks and to ensure a profit margin.

Internal Rate of Return (IRR)

Internal Rate of Return (IRR)

The interest rate (

i^*

) at which the present worth (PW) of all cash flows is exactly equal to zero. It represents the internal yield of an investment.

IRR Equation

PW(i^*) = 0

Or equivalently, setting Present Worth of benefits equal to Present Worth of costs:

PW_{benefits}(i^*) = PW_{costs}(i^*)

Decision Criterion

Checklist

Accept: If $IRR \ge MARR$
Reject: If $IRR < MARR$

Visualizing IRR

Since the IRR equation is often a high-degree polynomial, it is typically solved using trial and error or numerical methods (like Newton-Raphson). The tool below plots the Present Worth Profile—the relationship between PW and the interest rate. The point where the curve crosses the horizontal axis (

PW=0

) is the IRR.

IRR Visualizer

Cash Flows

Yr 0

Yr 1

Yr 2

Yr 3

Yr 4

Approx. IRR:7.71%

Loading chart...

Key Takeaways

The Core Definition: IRR is the specific interest rate ( $i^*$ ) that forces the Present Worth of all cash flows to equal exactly zero ( $PW = 0$ ).
The Decision Rule: For an independent project, Accept if $IRR \ge MARR$ ; otherwise, Reject.
Multiple IRRs: If the cash flow series changes sign more than once (e.g., initial cost, positive returns, then a large final cleanup cost), Descartes' Rule of Signs dictates there may be multiple valid IRRs, making the IRR method unreliable without using the External Rate of Return.

External Rate of Return (ERR)

The standard IRR calculation mathematically assumes that all intermediate positive cash flows generated by the project are immediately reinvested at the IRR itself. If a project has an unusually high IRR (e.g., 40%), this assumption is highly unrealistic.

To address this flaw, the External Rate of Return (ERR), also known as the Modified Internal Rate of Return (MIRR), explicitly assumes that all intermediate cash flows are reinvested at a more realistic rate—typically the MARR.

ERR Calculation Steps

The ERR is the interest rate (

i'

) at which the future worth of the project's net positive cash flows (compounded at the MARR) equals the present worth of the initial investments (discounted at the MARR).

Steps:

Take all net positive cash flows forward to the end of the project life ( $n$ ) at the reinvestment rate (MARR) to find the Total Future Worth ( $F_{pos}$ ).
Take all net negative cash flows (investments) back to time zero at the finance rate (often also the MARR) to find the Total Present Worth ( $P_{neg}$ ).
Calculate the external interest rate ( $i'$ ) that equates these two absolute values over $n$ periods: $F_{pos} = P_{neg}(1 + i')^n$

Key Takeaways

The Reinvestment Flaw: Standard IRR implicitly assumes all intermediate cash flows are reinvested at the IRR itself. This is often an aggressive, unrealistic assumption for highly profitable projects.
The ERR Solution: External Rate of Return (ERR) provides a more conservative, realistic metric by explicitly assuming intermediate cash flows are reinvested at the MARR.

\Delta

When comparing mutually exclusive alternatives, simply picking the one with the highest overall IRR is fundamentally incorrect and can easily lead to selecting the wrong project. This happens because IRR ignores the scale (size) of the investment. You must perform an incremental analysis.

Procedure

STEP-BY-STEP

Order Alternatives: Order the mutually exclusive alternatives strictly by increasing initial investment cost (lowest first, highest last).
Establish the Defender: The lowest-cost alternative that meets the MARR hurdle is the initial "Defender." The next more expensive alternative is the "Challenger."
Calculate Incremental Cash Flow: Calculate the cash flow of the difference between the Challenger and the Defender for each time period. $\Delta CF = CF_{challenger} - CF_{defender}$
Calculate Incremental IRR: Find the internal rate of return of this incremental cash flow series ( $\Delta i^*$ ).
Compare with MARR:
- If $\Delta i^* \ge MARR$ , the extra incremental investment is justified. The Challenger becomes the new Defender.
- If $\Delta i^* < MARR$ , the extra incremental investment is not justified. The Challenger is eliminated, and the current Defender remains.
Repeat: Continue comparing the reigning Defender against the next Challenger until all alternatives have been evaluated.

Key Takeaways

The Greatest Pitfall: You cannot correctly choose between mutually exclusive alternatives simply by picking the one with the highest overall IRR. Doing so ignores the scale of the investment.
The Incremental Approach: You must analyze whether the extra money spent on the more expensive option yields a return equal to or greater than the MARR.
The Incremental Rule: If the IRR of the incremental cash flow ( $\Delta i^*$ ) is $\ge MARR$ , the extra investment is justified, and you select the higher-cost alternative.