Key Takeaways
- NPV = sum of present values of all cash flows minus the initial investment; a positive NPV means the investment exceeds the required return.
- IRR is the discount rate that makes NPV equal to zero, representing the investment's annualized return.
- IRR assumes reinvestment at the IRR rate, which may be unrealistic; MIRR corrects this by using a separate reinvestment rate.
- When NPV and IRR conflict in ranking mutually exclusive investments, NPV is generally the more reliable guide.
- Use NPV for accept/reject decisions and IRR for capital allocation and ranking among competing opportunities.
Net present value (NPV) and internal rate of return (IRR) are the two most widely used metrics in real estate investment analysis. NPV tells you how much value an investment creates in today's dollars, while IRR tells you the annualized rate of return. This lesson covers both calculations in detail and explains when to use each.
Net Present Value: Measuring Value Creation
Net present value sums the present values of all future cash flows (inflows and outflows) using the investor's required rate of return as the discount rate. The formula is NPV = -C₀ + CF₁/(1+r)¹ + CF₂/(1+r)² + ... + CFₙ/(1+r)ⁿ, where C₀ is the initial investment, CFₜ represents cash flow in period t, and r is the discount rate. A positive NPV means the investment creates value above the required return; a negative NPV means it falls short.
Example: An investor evaluates a $1 million apartment purchase. Projected net cash flows are $80,000 per year for five years, with a $1.1 million sale at end of year five. Using a 9% discount rate: NPV = -$1,000,000 + $80,000/1.09 + $80,000/1.09² + $80,000/1.09³ + $80,000/1.09⁴ + ($80,000+$1,100,000)/1.09⁵ = $76,929. The positive NPV of $76,929 indicates the investment exceeds the 9% required return.
Internal Rate of Return: The Breakeven Discount Rate
The IRR is the discount rate that makes NPV equal to zero. It answers: "What annualized return does this investment actually deliver?" Using the same example, the IRR is approximately 11.2% — the rate at which the present value of all inflows exactly equals the $1 million outflow. IRR is found by trial-and-error or using financial calculators/spreadsheets.
IRR is particularly useful for comparing investments of different sizes and time horizons. However, it has important limitations. First, IRR assumes reinvestment of interim cash flows at the IRR itself, which may be unrealistic (the modified IRR, or MIRR, addresses this by using a separate reinvestment rate). Second, projects with non-conventional cash flow patterns (e.g., large capital expenditures mid-project) can produce multiple IRRs. Third, IRR ignores the absolute dollar amount of value created — a $10,000 investment earning 50% IRR creates less wealth than a $1 million investment earning 12% IRR.
NPV vs. IRR: When They Disagree
NPV and IRR usually agree on accept-or-reject decisions, but they can conflict when ranking mutually exclusive investments. Consider two properties: Property A requires $500,000 and has an NPV of $60,000 at 10% discount rate with an IRR of 14%. Property B requires $2 million and has an NPV of $150,000 at the same discount rate with an IRR of 12%. By IRR, A is better (14% vs. 12%). By NPV, B is better ($150,000 vs. $60,000).
Financial theory favors NPV because it measures absolute value creation in dollars. If an investor has $2 million available, choosing Property A and investing the remaining $1.5 million at the required return of 10% produces less total value than choosing Property B. However, if the investor has limited capital and many opportunities above the hurdle rate, IRR helps prioritize capital efficiency. In practice, sophisticated investors use both metrics: NPV for the go/no-go decision and IRR for ranking and capital allocation.
Key Takeaways
- ✓NPV = sum of present values of all cash flows minus the initial investment; a positive NPV means the investment exceeds the required return.
- ✓IRR is the discount rate that makes NPV equal to zero, representing the investment's annualized return.
- ✓IRR assumes reinvestment at the IRR rate, which may be unrealistic; MIRR corrects this by using a separate reinvestment rate.
- ✓When NPV and IRR conflict in ranking mutually exclusive investments, NPV is generally the more reliable guide.
- ✓Use NPV for accept/reject decisions and IRR for capital allocation and ranking among competing opportunities.
Sources
Common Mistakes to Avoid
Relying solely on IRR without considering NPV
Consequence: May choose a smaller project with a high IRR over a larger project that creates more total value.
Correction: Always calculate both NPV and IRR. Use NPV for accept/reject and total value creation; use IRR for ranking and capital efficiency.
Ignoring the reinvestment rate assumption embedded in IRR
Consequence: Overstating actual returns when the IRR is high but reinvestment opportunities are limited.
Correction: Use MIRR with a realistic reinvestment rate (e.g., cost of capital) for a more accurate picture, especially for projects with large interim cash flows.
Forgetting to include all cash flows — including transaction costs, capital expenditures, and disposition costs
Consequence: Overstating NPV and IRR by omitting outflows like closing costs (2–5% of price), renovation expenses, and broker commissions at sale.
Correction: Build a comprehensive cash flow model that includes acquisition costs, operating expenses, capital reserves, debt service, and all disposition costs.
Test Your Knowledge
1.An investment costs $200,000 and generates $50,000 per year for 5 years with no residual value. At a 10% discount rate, the NPV is approximately $-10,461. Should the investor proceed?
2.What is the primary limitation of using IRR to rank investments?
3.What does a modified IRR (MIRR) correct for?