Calculate Net Present Value and profitability index to evaluate corporate projects and investments.
| Year | Expected Cash Flow | Discount Factor | Present Value of Cash Flow |
|---|
Net Present Value (NPV) is the cornerstone metric in capital budgeting, corporate finance, and business valuation. It represents the difference between the present value of all cash inflows generated by a project and the present value of the initial capital outlay required to fund it. By discounting future earnings back to the present day using a specific hurdle rate (discount rate), NPV allows decision makers to verify if a project will add value to the enterprise or destroy capital.
Our NPV Calculator is a free, web-based tool. Written in pure vanilla JavaScript, the script executes entirely client-side, running locally within your browser. It requires no signup, no company profile, and sends none of your inputs to a remote server. This ensures that your confidential business projections remain 100% private.
In my experience auditing commercial business plans, I have found that managers frequently make the mistake of using arbitrary discount rates or ignoring the cost of capital. A cash inflow of ₹2,00,000 received 5 years from now is not worth ₹2,00,000 today. Because of the time value of money, that future inflow must be discounted by your hurdle rate (Weighted Average Cost of Capital, or WACC). Our tool computes this discounting factor for each period, giving you the mathematically accurate net present value.
When cash flows or discount rates are updated, the script runs the discounted cash flow analysis. The calculator follows this step-by-step logic:
The calculation of Net Present Value is governed by this standard DCF formula:
NPV = -C_0 + Sum [ C_t / (1 + r)^t ]Where:
To find the Profitability Index (PI, also known as the Value Investment Ratio), we divide the present value of inflows by the initial cost:
Profitability Index = [ Sum ( C_t / (1 + r)^t ) ] / C_0If $ ext{NPV} > 0$, then the Profitability Index will be greater than $1$, meaning the investment returns exceed the cost of capital, making the project viable.
When analyzing project viability, the decision rules are mathematically clear. If $ ext{NPV} > 0$ (and $ ext{PI} > 1.0$), the project adds economic value to the firm, and you should accept it. If $ ext{NPV} < 0$, the project fails to meet the required rate of return and will destroy value, so you should reject it.
When I first built this tool, I wanted to model how a project's viability shifts when its hurdle rate increases. Let's compare an outlay of ₹5,00,000 with cash inflows of ₹1,50,000, ₹1,80,000, ₹2,00,000, ₹1,50,000, and ₹1,00,000 at a 10% vs. 15% discount rate:
| Discount Rate (Hurdle) | Total Undiscounted Inflows | PV of Inflows | Net Present Value (NPV) | Profitability Index (PI) | Decision Status |
|---|---|---|---|---|---|
| 10% | ₹7,80,000.00 | ₹5,90,788.19 | +₹90,788.19 | 1.18 | ACCEPT (Adds Value) |
| 15% | ₹7,80,000.00 | ₹5,18,720.08 | +₹18,720.08 | 1.04 | ACCEPT (Marginal) |
At a 10% WACC, the project is highly attractive, generating ₹90,788 in excess present-day value with a Profitability Index of 1.18. However, if the cost of capital rises to 15%, the NPV drops significantly to ₹18,720, and the PI drops to 1.04. This shows how changes in interest rates or corporate risk profiles can instantly make once-profitable projects financially unviable.
WACC stands for Weighted Average Cost of Capital, representing the average rate a company pays to finance its assets (combining debt and equity). WACC is typically used as the baseline discount rate in NPV calculations because a project must yield returns higher than this rate to generate true profit.
An NPV of exactly zero means the project's present-day inflows exactly equal the initial capital cost. In this scenario, the project yields a return exactly equal to the discount rate, meaning it meets WACC but adds no excess value to shareholders.
NPV (Net Present Value) calculates the absolute monetary gain of a project at a fixed discount rate. IRR (Internal Rate of Return) calculates the discount rate at which the NPV of the cash flows equals exactly zero. While NPV is preferred for comparing scale, IRR is popular for percentage-based yields.
In advanced corporate finance, analysts sometimes use variable discount rates if the project's risk profile changes or inflation is expected to spike. For simplicity, this calculator uses a constant annual discount rate across the entire term.
The Profitability Index (PI) is the ratio of the present value of future cash flows to the initial investment. It measures the value created per unit of investment, making it highly useful for prioritizing projects under a strict capital rationing budget.
ROI Calculator – Evaluate absolute return on investment and compound CAGR.
Present Value Calculator – Find the present value of a future target sum.
Future Value Calculator – Project asset values with custom compounding frequencies.
Compound Interest Calculator – Track exponential investment growth over long terms.