Â
Â
1. Finding the Project’s True Break-Even Return Rate
The Internal Rate of Return (IRR) is the exact discount rate where a project’s Net Present Value equals zero \((\text{NPV} = 0).\) It represents the true annual percentage return that the project generates on its invested capital.
2. Calculation Mechanics via Linear Interpolation
Because solving for IRR directly requires complex polynomial math, analysts estimate it manually using a technique called Linear Interpolation. You calculate the project’s NPV at two different discount rates—one low rate (L) that yields a positive NPV, and one high rate (H) that yields a negative NPV—and apply this formula:Â
“IRR” = L + ((“NPV”_L)/(“NPV”_L − “NPV”_H))(H − L)
Executive Hurdle Rate Rules
Management compares the calculated IRR against the company’s internal Hurdle Rate (the minimum required return):
- If IRR > Hurdle Rate, accept the project.
- If IRR < Hurdle Rate, reject it.
3. Systemic Pitfalls of IRR
- The Reinvestment Rate Fallacy: IRR assumes all intermediate cash inflows are immediately reinvested at the project’s high IRR percentage, which is often unrealistic. NPV uses the more realistic assumption that cash is reinvested at the company’s standard cost of capital.
- Multiple IRRs: If a project’s cash flows shift between positive and negative values over time (e.g., if a mining project requires large environmental cleanup costs at the end), the math can output multiple different IRR percentages for the same project, making the results uninterpretable.
Â