IRR vs NPV in Capital Budgeting: Exact Formulas, Reinvestment Pitfalls & Real Estate DCF Modeling
When evaluating real estate acquisitions, venture investments, or corporate projects, Net Present Value (NPV) and Internal Rate of Return (IRR) are the two foundational metrics of Discounted Cash Flow (DCF) analysis. While business pitch decks frequently lead with high IRR figures, corporate finance theory proves that NPV is the superior decision metric for maximizing shareholder wealth.
format_list_bulleted Table of Contents
- 1. Net Present Value (NPV): Mathematical Formula & Hurdle Rates
- 2. Internal Rate of Return (IRR): The Breakeven Yield
- 3. The Reinvestment Rate Flaw: Why High IRRs are Often Misleading
- 4. The Project Scale Dilemma: $100k at 50% vs $10M at 20%
- 5. Real Estate Deal Case Study: A 5-Year Rental Acquisition
1. Net Present Value (NPV): Mathematical Formula
NPV discounts all future projected cash flows back to today's dollars using the company's Weighted Average Cost of Capital (WACC) or the investor's required hurdle rate ($r$):
The Decision Rule: If NPV > 0, the project generates more value than the cost of capital and should be accepted.
2. Internal Rate of Return (IRR): The Breakeven Yield
IRR is the exact discount rate that sets the project's NPV to zero:
The Decision Rule: If IRR > Hurdle Rate, the project generates an excess rate of return above the cost of capital.
3. The Reinvestment Rate Flaw: The Hidden IRR Trap
The fundamental theoretical weakness of standard IRR is its assumption that all intermediate cash inflows can be reinvested at the project's own IRR:
- If a deal claims a 42% IRR, standard formula math assumes you can reinvest Year 1 cash flow into another 42% asset—which is almost impossible in practice.
- NPV assumes reinvestment at your realistic Cost of Capital (e.g. 8%-10%), making its output grounded in real-world economics.
- To fix this flaw in rate analysis, financial analysts use Modified IRR (MIRR).
4. The Project Scale Dilemma
Consider two mutually exclusive business proposals (10% discount rate):
- Project A: Invest $10,000 today → Receive $20,000 next year (IRR = 100%, NPV = +$8,181).
- Project B: Invest $1,000,000 today → Receive $1,350,000 next year (IRR = 35%, NPV = +$227,272).
While Project A has an eye-catching 100% IRR, Project B creates $227,272 in real wealth vs only $8,181 from Project A. When capital scale matters, always pick the highest NPV.
5. Summary: When to Use Each Metric
Use NPV as your primary decision criterion when deciding whether to commit corporate capital or purchase an asset. Use IRR as a secondary communication metric to quickly convey operational return efficiency to non-technical stakeholders and limited partners.