NPV Calculator
Net Present Value, Internal Rate of Return, Payback Period, and Profitability Index. The complete capital budgeting toolkit for investment decisions.
Project Cash Flows
Cash Inflows
Formulas
NPV = -C0 + SUM(Ct/(1+r)^t)
IRR: rate where NPV = 0
PI = PV(inflows) / C0
Accept Project
NPV is positive (₹17.64 L). This project creates value above the 12% required return.
Net Present Value
₹17.64 L
At 12% discount rate
Internal Rate of Return
18.04%
Above hurdle rate of 12%
Payback Period
3.4 yrs
Undiscounted
Discounted Payback
4.3 yrs
At 12% rate
Profitability Index
1.176x
PI > 1: Value-creating
Discounted Cash Flows by Year
Cash Flow Analysis
r = 12%| Year | Cash Flow | Cumulative | PV of Cash Flow | PV Cumulative |
|---|---|---|---|---|
| Y0 | -₹1.00 Cr | -₹1.00 Cr | -₹1.00 Cr | -₹1.00 Cr |
| Y1 | ₹20.00 L | -₹80.00 L | ₹17.86 L | -₹82.14 L |
| Y2 | ₹30.00 L | -₹50.00 L | ₹23.92 L | -₹58.23 L |
| Y3 | ₹35.00 L | -₹15.00 L | ₹24.91 L | -₹33.31 L |
| Y4 | ₹40.00 L | ₹25.00 L | ₹25.42 L | -₹7.89 L |
| Y5 | ₹45.00 L | ₹70.00 L | ₹25.53 L | ₹17.64 L |
IRR vs Required Return
The project returns 6.04% above the cost of capital, creating shareholder value.
NPV, IRR, and Capital Budgeting: The Complete Decision Framework
Capital budgeting is the process by which companies evaluate and select long-term investment projects. Whether a business is considering a new factory, an acquisition, a technology upgrade, or market expansion, the fundamental question is the same: will this investment create more value than it costs? Net Present Value (NPV) and Internal Rate of Return (IRR) are the two most widely used tools for answering this question, and understanding their mechanics, strengths, and limitations is essential for any finance professional.
Net Present Value (NPV): The Gold Standard
NPV calculates the difference between the present value of all future cash inflows from a project and the initial investment cost. The formula is straightforward: NPV = -C0 + CF1/(1+r) + CF2/(1+r)^2 + ... + CFn/(1+r)^n, where C0 is the initial investment, CF1 through CFn are the projected cash flows in each period, and r is the discount rate (typically the company's WACC or the project-specific required return).
The NPV decision rule: if NPV is positive, the project earns more than the required return and adds value; if NPV is negative, it earns less and reduces value; if NPV is zero, it earns exactly the required rate of return. NPV measures the expected change in shareholder wealth in rupees.
Internal Rate of Return (IRR): The Return Perspective
IRR is the discount rate that makes the NPV of a project exactly zero. In other words, it is the rate of return at which the present value of cash inflows equals the initial investment. The IRR decision rule states: accept the project if IRR exceeds the required rate of return (hurdle rate or WACC); reject if IRR falls below it.
Our calculator computes IRR using the Newton-Raphson numerical method, which iteratively converges to the solution. This is the same approach used in spreadsheet software and professional financial tools. For conventional cash flow patterns (one initial outflow followed by a series of inflows), the Newton-Raphson method converges quickly and reliably. For unconventional patterns (multiple sign changes in cash flows), the tool uses a bisection fallback to ensure a result.
When NPV and IRR Conflict
For independent projects (where accepting one does not preclude accepting the other), NPV and IRR always give the same accept/reject decision. However, when ranking mutually exclusive projects (where only one can be chosen), NPV and IRR can disagree. This happens because of differences in project scale (a larger project may have a lower IRR but higher NPV) and differences in cash flow timing (a project with earlier cash flows may have a higher IRR but lower NPV at the firm's actual cost of capital).
In such cases, finance theory unambiguously recommends following the NPV rule. The reason is fundamental: NPV measures the absolute increase in firm value, which is what shareholders care about. A project that earns 25% IRR on a Rs 10 lakh investment (NPV = Rs 5 lakh) is less valuable than a project earning 18% IRR on a Rs 1 crore investment (NPV = Rs 30 lakh), even though the first project has a higher percentage return.
Payback Period: Simple but Limited
The payback period measures how long it takes for cumulative cash flows to recover the initial investment. It is intuitive and popular among managers, but it has significant limitations. The simple payback period ignores the time value of money entirely, treats a rupee received in year 5 the same as a rupee received in year 1. The discounted payback period addresses this by using discounted cash flows, but both versions ignore all cash flows that occur after the payback point. A project that pays back quickly but generates nothing thereafter would be preferred over one that takes longer to pay back but generates enormous value in later years.
Despite these limitations, payback period is useful as a risk metric: projects with shorter payback periods have less exposure to forecasting uncertainty. Many Indian corporations use payback period as a screening criterion (for example, requiring payback within 4 years) before conducting a full NPV analysis.
Profitability Index: Value per Rupee Invested
The Profitability Index (PI) is the ratio of the present value of future cash flows to the initial investment: PI = PV(cash inflows) / Initial Investment. A PI greater than 1.0 means the project creates value (equivalent to a positive NPV). PI is useful when a company faces capital rationing (a limited investment budget) and has to rank projects by value created per rupee invested. Under a single budget limit, taking projects in descending order of PI until the budget runs out gives the highest total NPV when projects can be taken in part. When only whole projects can be taken, PI ranking can miss the combination with the highest total NPV, which is found by checking the combinations that fit the budget.
Capital Budgeting in the Indian Corporate Context
In India, the cost of capital reflects Indian interest rates and equity risk, so the discount rate used for a project here differs from one used for the same project in another market. Policy and regulatory changes (GST rates, environmental rules, licensing) can be modelled as cash flow scenarios rather than added to the discount rate, which keeps the two kinds of risk apart. Revenue growth assumptions are the inputs that most often turn out too high, so testing them with lower figures shows how much the NPV depends on them.
NPV and IRR are standard tools in corporate capital budgeting. The result depends on three things: the cash flow projection, the discount rate, and how the answer is read against the other options open to the company.
How the Inputs Are Usually Built
- NPV and IRR are worked out on free cash flow, not accounting profit
- Incremental cash flows count: opportunity costs, cannibalisation of existing sales, and working capital changes
- Sunk costs (money already spent that cannot be recovered) are left out
- Sensitivity analysis on the two or three most uncertain inputs (revenue growth, margin, capex) shows how much the answer depends on each
- Scenario analysis (base, optimistic, pessimistic) with probability weights gives an expected NPV
- For mutually exclusive projects, NPV ranks them by value added; IRR can rank them differently
- IRR assumes reinvestment at the IRR itself, which may be unrealistic for very high-IRR projects
Disclaimer
This calculator is an educational and analytical tool. Real-world capital budgeting decisions involve strategic considerations, risk analysis, and qualitative factors beyond NPV and IRR. Cash flow projections are inherently uncertain. This is not financial or investment advice. Consult qualified professionals for corporate investment decisions.
NPV Calculator by City
Each city page has this calculator with a worked example for the city, and the facts that differ by state where they bear on it: the house rent allowance limit, stamp duty and professional tax, each from the law or the state's published rates.
Cities with the 50% HRA limit
Other cities (40% HRA limit)
HRA limit for tax year 2026-27: 50% of salary in Mumbai, Kolkata, Delhi, Chennai, Hyderabad, Pune, Ahmedabad and Bengaluru, 40% in any other place (rule 279(1)(c), Income-tax Rules, 2026). The exemption is not available under the new tax regime.
Related Calculators
Explore other tools on related topics — each one is free to use and built for Indian financial contexts.