NPV (net present value) measures whether an investment creates value by discounting future cash flows to their present value using a discount rate. It helps businesses and investors assess profitability by factoring in the time value of money, which holds that money today is worth more than the same amount in the future.
NPV is widely used in capital budgeting, business expansion decisions, project evaluation and investment analysis.
What is the NPV Formula?
The NPV formula finds the present value of all future cash flows and subtracts the initial investment.
NPV = ∑ₜ₌₁ⁿ (CFₜ / (1 + r)ᵗ) − C₀
Where:
- ∑ = sum of all periods from 1 to n
- CFₜ = Cash flow at time t
- r = Discount rate
- t = Time period
- C₀ = Initial investment
Why the discount rate matters
The discount rate determines how future cash flows are valued in today’s terms. It reflects the return expected from an alternative investment of similar risk, while accounting for inflation and the cost of capital.
It captures both investment risk and opportunity cost. A higher perceived risk or required return leads to a higher discount rate.
As a result, even strong future cash flows appear less attractive when discounted at a higher rate, as their present value decreases. Selecting an appropriate discount rate is critical because it directly affects whether an investment appears profitable.
In practice, businesses often use the weighted average cost of capital (WACC) as a starting point and adjust it for project-specific risks, industry conditions or geography.
How to calculate NPV
Follow these steps to calculate NPV:
- Estimate future cash flows based on expected returns.
- Choose a discount rate based on risk, industry standards or required return.
- Calculate the present value of each cash flow using the discount rate (often the weighted average cost of capital (WACC) or hurdle rate):
Present value (PV) = CFₜ / (1 + r)ᵗ
- Add all the present values of the cash flows.
- Subtract the initial investment.
Example 1: NPV with a single cash flow
Suppose:
Initial investment = ₹10,000
Cash inflow after 1 year = ₹12,000
Discount rate = 10%
Calculation:
NPV= 12,000/(1.10)^1 - 10,000
NPV = 10,909 - 10,000 = ₹909
Interpretation: NPV is positive, so it’s a good investment and you earn more than your required rate of return.
Example 2: NPV with multiple cash flows
Let’s imagine:
Initial investment = ₹50,000
Cash inflows = ₹20,000 per year for 3 years
Discount rate = 10%
Stepwise calculation:
Year 1: 20,000 ÷ 1.10 = 18,182
Year 2: 20,000 ÷ (1.10)^2 = 16,529
Year 3: 20,000 ÷ (1.10)^3 = 15,026
Total present value: 18,182 + 16,529 + 15,026 = 49,737
NPV: 49,737 - 50,000 = -₹263
Interpretation: NPV is negative, so it’s best to reject the investment as it does not meet the required rate of return.
How discount rate change NPV
NPV and the discount rate have an inverse relationship. When the discount rate increases, the present value of future cash flows decreases, thereby lowering the NPV. When the discount rate decreases, NPV increases as future cash flows are discounted less.
For example, if the same investment is evaluated at a 5% discount rate, the NPV will be higher because future cash flows retain more value. At a 15% discount rate, those cash flows are discounted more heavily, reducing the NPV.
This reflects the idea that a higher discount rate signals greater risk or higher expected returns, making future cash flows less valuable in today’s terms. As a result, even profitable projects may appear less attractive when evaluated with a higher rate.
NPV decision rule
Use these simple rules to decide on the project:
- NPV > 0 - Generally accept the project (subject to capital constraints and strategic considerations)
- NPV = 0 - Break-even
- NPV < 0 - Reject the project
This makes NPV one of the most widely used and theoretically sound tools in financial decision-making.
Advantages of using NPV
NPV is widely used in finance because it:
- Accounts for the time value of money: It adjusts future cash flows to their present value, giving a more accurate view of profitability.
- Consider all cash flows: It includes every inflow and outflow over the project’s life.
- Helps compare investment options: It shows which project adds more value in absolute terms.
- Provides a clear profitability measure: It expresses returns in monetary terms, making decisions more straightforward.
Limitations of NPV
NPV has some practical limitations:
- It depends on accurate cash flow estimates.
- Choosing the right discount rate can be complex.
- It does not easily compare projects of different sizes.
- It assumes reinvestment at the discount rate, which may not be realistic.
- It is sensitive to small changes in inputs such as cash flows or the discount rate.
Tips for accurate NPV calculation
Use these practices to improve accuracy:
- Use realistic cash flow projections.
- Adjust the discount rate for risk.
- Consider inflation in the calculations.
- Use tools like Excel for consistency and accuracy.
Note: The NPV() function in Excel excludes the initial investment, which must be subtracted separately.
Conclusion
The NPV formula helps evaluate whether an investment creates value by measuring future cash flows in today’s terms using a discount rate. Since results are sensitive to assumptions such as cash flows and the discount rate, careful estimation and review are important for reliable decision-making.
With TallyPrime, you can maintain accurate financial data and use it to support investment analysis, helping you make informed, data-driven decisions with greater confidence.
