๐ Core Insight: NPV and IRR are the two most important tools in corporate finance for evaluating investment projects. NPV tells you the dollar value a project adds, while IRR tells you the project's annualized rate of return. Choosing the right one depends on the situation.
What is Net Present Value (NPV)?
Net Present Value (NPV) is the difference between the present value of all cash inflows and the present value of all cash outflows over a project's lifetime. A positive NPV means the project is expected to add value to the firm and should be accepted. A negative NPV means it destroys value and should be rejected.
The formula is: NPV = ฮฃ (Cash Flow / (1 + Discount Rate)^Time Period). The discount rate is usually the firm's cost of capital, representing the minimum required return.
NPV Calculation:
Year 0 Cash Flow: -$100,000
Year 1 PV: $60,000 / (1 + 0.10)^1 = $54,545
Year 2 PV: $70,000 / (1 + 0.10)^2 = $57,851
NPV = -$100,000 + $54,545 + $57,851 = $12,396
If Discount Rate = 5%:
NPV = -$100,000 + ($60,000/1.05) + ($70,000/1.05^2) = $21,995
If Discount Rate = 15%:
NPV = -$100,000 + ($60,000/1.15) + ($70,000/1.15^2) = $3,780
If Discount Rate = 20%:
NPV = -$100,000 + ($60,000/1.20) + ($70,000/1.20^2) = -$4,861
What is Internal Rate of Return (IRR)?
The Internal Rate of Return (IRR) is the discount rate that makes the Net Present Value (NPV) of a project equal to zero. In simple terms, it's the project's own estimated annual rate of return. You compare the IRR to your required rate of return (hurdle rate). If IRR > Hurdle Rate, accept the project.
There is no simple formula for IRR; it is found through trial-and-error or using financial calculators/software (like Excel's IRR function).
We need to find the rate (r) where:
0 = -$100,000 + [$60,000 / (1+r)] + [$70,000 / (1+r)^2]
By calculation (or Excel's
=IRR()), we find that r โ 16.05%.Project A: IRR = 18%
Project B: IRR = 9%
Decision:
- Accept Project A because its IRR (18%) is greater than the 12% hurdle rate.
- Reject Project B because its IRR (9%) is less than the 12% hurdle rate.
Key Differences: NPV vs. IRR
| Aspect | Net Present Value (NPV) | Internal Rate of Return (IRR) |
|---|---|---|
| What it measures | Absolute dollar value added to the firm. | Percentage rate of return on the investment. |
| Decision Rule | Accept if NPV > 0. Reject if NPV < 0. | Accept if IRR > Hurdle Rate. Reject if IRR < Hurdle Rate. |
| Assumption about Reinvestment | Assumes cash flows are reinvested at the discount rate (cost of capital). | Assumes cash flows are reinvested at the IRR itself. |
| Result for Mutually Exclusive Projects | Gives a clear ranking based on dollar value. Choose the project with the highest NPV. | May give conflicting rankings with NPV. IRR can be misleading here. |
| Handling Non-Conventional Cash Flows | Always gives a single, clear answer. | May produce multiple IRRs or no IRR, causing confusion. |
โ ๏ธ Common Pitfalls and When They Conflict
- Mutually Exclusive Projects: NPV and IRR can recommend different projects. Always trust NPV for mutually exclusive choices because it maximizes shareholder wealth in dollars.
- Scale of Investment: A small project with a high IRR might be chosen over a large project with a lower IRR but a much higher NPV. NPV correctly accounts for the scale of value creation.
- Non-Conventional Cash Flows: If a project has cash flow sign changes (e.g., -, +, -), IRR may have multiple solutions. NPV does not have this problem.
- Reinvestment Rate Assumption: IRR's assumption that interim cash flows can be reinvested at the high IRR rate is often unrealistic. NPV's assumption (reinvestment at cost of capital) is more conservative and practical.
Which One Should You Use?
The choice depends on the context:
- Use NPV as your primary decision tool. It directly measures the increase in firm value in dollar terms, which is the ultimate goal of corporate finance. It works in all situations and avoids the pitfalls of IRR.
- Use IRR as a supplementary, communication tool. Executives and investors often find a percentage return (IRR) more intuitive than a dollar figure (NPV). Use IRR to explain the project's attractiveness, but base the final decision on NPV.
- Rule of Thumb: For independent projects (accept/reject decisions), both NPV and IRR will give the same yes/no answer. For mutually exclusive projects (choosing one among several), always rely on NPV to avoid incorrect rankings.