A beginner-friendly guide to understanding NPV and IRR with examples, formulas, and their applications.
When evaluating an investment, the real challenge is determining whether it will generate value in the future or not. This is where two fundamental financial metrics, Net Present Value (NPV) and Internal Rate of Return (IRR), can help you gain insight into your investment decision.
In this blog, we break down both concepts step by step, with examples, so that you can understand their applications practically.
What is Net Present Value (NPV)?
The net present value is a financial metric that helps in evaluating whether an investment or project is worth undertaking. It does so by measuring the difference between the present value of expected future cash inflows and the present value of cash outflows by discounting them to today’s value.
NPV helps you answer a key question: Will this investment generate more value than it costs today?
At its core, NPV is based on the time value of money, The idea here is that money received today is worth more than the same amount received in the future due to factors such as inflation, risk, and opportunity cost. It is widely applied in capital budgeting, financial analysis, and investment decision-making.
Furthermore, NPV converts all future cash flows of a project into today’s value using a discount rate (usually the cost of capital). These discounted cash inflows are then compared against the initial investment.
- If NPV is positive, the investment is expected to create value
- If NPV is negative, the investment may destroy value
Let’s look at how this actually works.
Calculation of NPV
NPV is calculated by discounting all future cash flows back to their present value using a required rate of return and then subtracting the initial investment.
The formula: NPV = Σ [Cₜ / (1 + r)ᵗ] − C0
Wherein:
- Cₜ: The net cash flow received at time t. This could be a coupon payment, rental income, or any return the investment generates in that specific period.
- r: The discount rate. This is your required rate of return; the minimum return you expect, usually benchmarked against your cost of capital or an alternative investment of similar risk.
- t: It refers to the time period: Year 1, Year 2, Year 3, and so on. It tells the formula how far into the future a cash flow occurs, which determines how heavily it gets discounted.
- (1 + r)ᵗ: The discount factor. The further a cash flow is in the future, the larger this number gets, and the smaller its present value becomes. This is the mathematical expression of the time value of money.
- C0: Initial investment at time zero. This is the upfront cash outflow made to acquire the investment.
Example of NPV
Let’s unpack that 3-year bond example step by step. Imagine you’re eyeing a bond with:
- Face value: ₹1,00,000
- Coupon rate: 8% per year
- Discount rate: 10%
- Purchase price: ₹1,00,000
The bond pays ₹8,000 in interest each year (8% of ₹1,00,000) plus the principal of ₹1,00,000 at year 3. But future cash flows are worth less today due to the time value of money, so we discount each cash flow.
Step 1: List the cash flows
- Year 1: ₹8,000 (coupon only)
- Year 2: ₹8,000 (coupon only)
- Year 3: ₹8,000 (coupon) + ₹1,00,000 (principal) = ₹1,08,000
Step 2: Discount each to present value
Use the formula: Present Value = Cash Flow ÷ (1 + discount rate)^year.
- Year 1: ₹8,000 ÷ (1.10)¹ = ₹7,273
- Year 2: ₹8,000 ÷ (1.10)² = ₹6,612
- Year 3: ₹1,08,000 ÷ (1.10)³ = ₹81,141
Total present value of cash flows: ₹7,273 + ₹6,612 + ₹81,141 = ₹95,026.
Step 3: Calculate NPV
NPV = Total present value – Purchase price
= ₹95,026 − ₹1,00,000
= −₹4,974
At a 10% discount rate, the bond’s future payments are only worth ₹95,026 today, which is less than the ₹1,00,000 price. Negative NPV says it’s overpriced. Meaning, you’d lose value compared to other 10% options. In such a case, you should only invest in the bond if the bond is worth ₹95,026 or less.
While NPV helps you understand how much value an investment creates in absolute terms, it does not directly tell you the rate at which that value is generated. This is where IRR comes in.
What is Internal Rate of Return (IRR)?
Internal rate of return is the discount rate at which the NPV of all cash flows from an investment becomes zero. In other words, it is the rate you need to find such that the present value of future cash inflows equals the initial investment.
IRR helps you in estimating the expected rate of return a project or investment is likely to generate over time. Similar to NPV, IRR is also widely used in capital budgeting and financial analysis to evaluate and compare different investment opportunities.
A higher IRR generally indicates a more attractive investment. However, IRR is only meaningful when compared against a hurdle rate or cost of capital. For example, a 20% IRR on a highly risky venture may be less attractive than a 12% IRR on a low-risk project.
Its calculation involves identifying the discount rate that brings the NPV of all projected cash flows to zero. Since this cannot usually be solved directly, it is typically computed using financial calculators, Excel, or iterative methods.
Calculation of IRR
For a series of cash flows:
- Initial investment =
(outflow at time 0).
- Future cash inflows/outflows =
at years 1, 2, …,
,
IRR is the value of that satisfies: 0=−
+∑t=1n (1+r)tCt
Unlike NPV, you cannot solve this formula directly with simple algebra; instead, you usually:
- Use trial and error (test different discount rates)
Or
- Use a financial calculator or Excel’s IRR function
Example of IRR
Let’s continue with the same 3‑year bond example and find the IRR instead of using a fixed 10% discount rate.
Bond details
- Face value: ₹1,00,000
- Coupon rate: 8% per year
- Purchase price today (
): ₹1,00,000
- Discount rate for NPV was 10%, but now we want to know: What discount rate makes NPV = 0?
The cash flows are:
- Year 1: ₹8,000 (coupon only)
- Year 2: ₹8,000 (coupon only)
- Year 3: ₹8,000 (coupon) + ₹1,00,000 (principal) = ₹1,08,000
Step 1: Set up the IRR equation
We look for the rate r such that:
1,00,000=(1+r)18,000 +(1+r)28,000 +(1+r)31,08,000
Step 2: Trial and error
Try r = 8%
- Year 1: ₹8,000 ÷ 1.08 = ₹7,407
- Year 2: ₹8,000 ÷ (1.08)² = ₹6,858
- Year 3: ₹1,08,000 ÷ (1.08)³ = ₹85,735
Total present value = ₹1,00,000
NPV = ₹1,00,000 − ₹1,00,000 = 0
So, IRR = 8%
Step 3: Interpretation
- At a purchase price of ₹1,00,000, the bond’s IRR is 8%.
- This means: if alternative investments of similar risk promise more than 8% (say 10%), this bond is less attractive; if alternatives pay less than 8%, the bond looks better.
- In simple terms, IRR is the bond’s own effective annual return when you buy it at this price.
NPV vs IRR: Key Differences
| Parameter | NPV | IRR |
| What it measures | Absolute value created by the investment in present terms | Expected annual rate of return from the investment |
| Output format | Expressed in currency (₹) | Expressed as a percentage (%) |
| Reinvestment assumption | Assumes reinvestment at the discount rate (more realistic) | Assumes reinvestment at IRR (less realistic) |
| Practical relevance | Better for measuring actual wealth creation | Better for comparing return rates across projects |
Final Thoughts: When To Use NPV or IRR
Choosing between NPV and IRR depends on the context of the decision you are trying to make. Both metrics serve different purposes.
Use NPV when your goal is to evaluate absolute value creation. It is best suited for capital budgeting decisions, especially when comparing projects of different sizes or when capital allocation is at stake. Since NPV measures the wealth an investment adds in actual monetary terms, it is generally preferred for final investment decisions.
Use IRR when you want to understand the rate of return or compare multiple investment options with similar characteristics. It is particularly useful for ranking projects or assessing whether an investment meets a required return threshold.
In practice, both metrics are often used together. However, when results conflict, NPV typically prevails, as it provides a more reliable measure of value creation.
