The Ultimate Guide to NPV and IRR
When a business decides to buy a new factory, develop a new software product, or acquire a competitor, they are making a massive upfront investment in hopes of generating cash flow in the future. But how do they know if the investment is actually worth it?
They can't just add up the future cash because of a fundamental law of finance: The Time Value of Money (TVM). A dollar today is worth more than a dollar five years from now because today's dollar can be invested to earn interest. To evaluate projects fairly, financial analysts use NPV (Net Present Value) and IRR (Internal Rate of Return).
Net Present Value (NPV)
NPV calculates the current value of all future cash flows generated by a project, minus the initial investment. It heavily relies on your Discount Rate (usually your company's Cost of Capital). If the NPV is strictly greater than zero ($0), the project is mathematically expected to add value to the firm and should be accepted.
Internal Rate of Return (IRR)
IRR is the annualized effective compounded return rate of the project. Mathematically, it is the exact Discount Rate that makes your NPV equal perfectly to zero. If the IRR is higher than your company's required rate of return (hurdle rate), the project is considered a good investment.
What is the "Discount Rate"?
The Discount Rate is the most important input in an NPV calculation. It represents the opportunity cost of your money.
If you have $100,000, you could put it in the stock market and easily earn 8% per year without doing any hard work. Therefore, if you are going to use that $100,000 to start a risky business project instead, that project must yield more than 8%. In this scenario, your Discount Rate is 8%. Large corporations usually use their WACC (Weighted Average Cost of Capital) as their discount rate.
NPV vs IRR: Which is better?
While executives love IRR because it gives them a simple percentage (e.g., "This project yields 15%"), NPV is the mathematically superior metric.
- The Scale Problem: A $100 investment that yields $150 in a year has a massive 50% IRR. A $1 Million investment that yields $1.2 Million has a 20% IRR. The IRR rule says pick the first project, but the NPV rule recognizes the second project puts vastly more actual wealth into your pocket.
- Multiple IRRs: If a project requires a massive cash injection in Year 3 (a negative cash flow), the complex polynomial math can actually result in two different IRRs, making the metric useless. NPV does not suffer from this mathematical flaw.
Pro Tip: Be Conservative
The biggest flaw in Capital Budgeting is human optimism. Managers tend to underestimate initial costs and drastically overestimate future cash flows to get their projects approved. Always run your NPV calculations using conservative estimates.