Net Present Value Profitability Index Calculator
Net present value (NPV) tells you whether a project creates value after its future cash is restated in today’s dollars, and the profitability index (PI) restates that same verdict per dollar invested. This calculator takes an initial investment, a discount rate and one cash inflow per period, then returns NPV, PI, a plain accept or reject verdict, three return percentages and both payback periods, with the period-by-period arithmetic shown in a table. It handles uneven and negative cash flows, so mid-project spending years do not need to be hidden or averaged away.
| Period | Cash flow | Discount factor | Present value | Cumulative PV |
|---|
NPV = sum of discounted inflows − initial investment. PI = PV of inflows / initial investment = 1 + NPV / investment. Discounted payback uses discounted (not raw) cash flows. Payback periods show the whole period plus the interpolated fraction (e.g. 2.60 periods). Discounted ROI = NPV / investment; simple ROI uses undiscounted inflows; ARR = average annual inflow / investment. The Cumulative PV column starts from the initial investment as a negative balance, so the row where it turns positive is the discounted payback period.
Quick Answer
A $100,000 project returning $30,000, $40,000 and $50,000 over three years at an 8% discount rate has a present value of inflows of $101,762.94, an NPV of $1,762.94 and a PI of 1.0176: accept, but only just. Simple payback lands at 2.60 periods interpolated, discounted payback at 2.96. Those are the pre-filled numbers in the calculator above, so one click on Calculate reproduces every figure.
Key takeaways
- NPV and PI never disagree on a single project: NPV above zero and PI above 1.0 are the same condition, because PI = 1 + NPV / investment.
- PI earns its keep when the budget is capped. It ranks projects by value created per dollar, where NPV ranks by total dollars created.
- Discounted payback is the honest exposure measure. It asks when the project repays its cost in today’s dollars, not in inflated future ones.
- The accounting rate of return on this page is a cash shortcut (average inflow over investment), not the textbook profit-based ARR. The FAQ at the bottom states the difference plainly.
- Quick Answer
- How to use this NPV and profitability index calculator
- The formulas: NPV, PI, ROI and payback
- Worked example: $100,000 in, three uneven years out
- NPV vs profitability index: when the ranking flips
- Simple vs discounted payback, and the words Beyond horizon
- What competing calculators miss
- Frequently asked questions
- Add This Calculator to Your Website
- References
How to use this NPV and profitability index calculator
Enter the upfront cost, the rate and the cash flow for each period, then click Calculate. The verdict, eight result lines and the period table all come from that one run.
- Initial investment: the full day-one cost as a positive number. The tool stops with a prompt if this is blank, zero or negative, because PI and both ROI figures divide by it.
- Discount rate: your required return per period, in percent. Companies usually start from the weighted average cost of capital; the treatment in OpenStax’s Principles of Finance chapter on the NPV method uses the firm’s cost of attracting capital the same way. A blank rate is treated as 0%, which turns NPV into a simple sum of inflows minus cost.
- Cash inflow per period: one net figure per period, in time order, on separate lines or separated by commas or semicolons. Flows are treated as arriving at the end of each period. A year where the project spends more than it earns goes in as a negative number, and it is discounted like any other line.
- Read the verdict first, then the table: ACCEPT, REJECT or INDIFFERENT follows the sign of NPV. The table shows each period’s discount factor, present value and the cumulative position, so you can see exactly which period carries the project over the line.
Two entry quirks worth knowing. The parser reads the leading number of each entry, so tidy figures matter: an entry typed as 100abc is read as 100, while a word with no leading number stops the run with a prompt. And the payback display pairs a whole-period count with an interpolated fraction, so a fast project can read “1 periods (0.50 interpolated)”: the fraction is the precise figure, the whole count is the period in which payback lands.
The formulas: NPV, PI, ROI and payback
Every figure on the results panel comes from five formulas, all built on one discounting step: a cash flow CF in period t is worth CF / (1 + r)^t today. That discount factor is the mirror image of compounding, the same machinery the annual time value of money calculator runs in the forward direction.
NPV = PV of inflows − initial investment
PI = PV of inflows / initial investment = 1 + NPV / investment
Discounted ROI = NPV / investment × 100 | Simple ROI = (total inflows − investment) / investment × 100
ARR (as computed here) = (total inflows / number of periods) / investment × 100
Interpolated payback = last whole period before recovery + (unrecovered balance at its start / that period’s cash flow)
The discount factor itself is a reciprocal growth factor: where the future value factor calculator multiplies a present sum by (1 + r)t to push it forward in time, this tool divides by the same factor to pull a future sum back. The period table prints the factor for every line (1.0800, 1.1664, 1.2597 in the worked example), so the division behind each present value can be checked with a pocket calculator. One related figure this page does not compute is the internal rate of return, the single discount rate that would drive NPV to exactly zero; the MOIC to IRR calculator approaches that rate from the money-multiple side.
One definition needs care. Textbook accounting rate of return divides average annual accounting profit, after depreciation, by the investment. This tool has no depreciation or profit inputs, so its ARR line divides the average annual cash inflow by the investment instead. The number is useful as a quick sizing check, and it can run well above 100% on short projects (a single $2,000 inflow on a $1,000 investment reads 200.00%), but it is not the textbook ratio and should never be quoted as one.
Worked example: $100,000 in, three uneven years out
The pre-filled project costs $100,000 today and returns $30,000, $40,000 and $50,000 at the ends of years 1 to 3, discounted at 8%. Each year is divided by its discount factor:
Payback needs the cumulative lines. In raw cash, the project is still $30,000 short after year 2 and year 3 brings $50,000, so simple payback is 2 + 30,000 / 50,000 = 2.60 periods. In discounted cash, $37,928.67 is still short after year 2 and year 3’s present value is $39,691.61, so discounted payback is 2 + 37,928.67 / 39,691.61 = 2.96 periods. The tool reports both as “3 periods” for the whole count, with those fractions beside them. The full results panel for this run reads: PV of inflows $101,762.94, NPV $1,762.94, PI 1.0176, discounted ROI 1.76%, simple ROI 20.00%, ARR 40.00%.
Four more runs of the same tool, each one a check you can repeat:
| Scenario (investment / rate / inflows) | NPV | PI | Verdict |
|---|---|---|---|
| $50,000 / 10% / $10,000 × 3 years | -$25,131.48 | 0.4974 | Reject |
| $10,000 / 0% / $4,000 × 3 years | $2,000.00 | 1.2000 | Accept |
| $20,000 / 5% / -$5,000, $15,000, $20,000 | $6,120.29 | 1.3060 | Accept |
| $1,000 / 25% / $2,000 in year 1 only | $600.00 | 1.6000 | Accept |
The zero-rate row is the cleanest sanity check on the whole panel: with no discounting, NPV is just $12,000 of inflows minus the $10,000 cost, PI is 1.2000, and simple and discounted payback agree at 2.50 periods interpolated, because there is no time value left to separate them.
NPV vs profitability index: when the ranking flips
On one project the two measures always agree, since PI = 1 + NPV / investment. They part company when a fixed budget forces a ranking: NPV rewards total dollars created, PI rewards dollars created per dollar spent. OpenStax’s chapter on choosing between projects works through the same tension with replacement and mutually exclusive projects.
| Question | NPV | Profitability index |
|---|---|---|
| Units | Dollars of value created | Ratio of value to cost |
| Accept line | Above 0 | Above 1.0 |
| Best at | Judging one project, or projects of similar size | Ranking under capital rationing |
| Blind spot | Favours big projects in a ranking, even when they use the budget inefficiently | Favours small projects: a $10,000 project with PI 2.1 creates $11,000, while a $100,000 project with PI 1.2 creates $20,000 |
The practical rule: with unlimited capital, take every positive-NPV project and let NPV lead. With a hard cap, rank by PI so the budget buys the most value per dollar, then check the leftovers by hand, because PI ranking can leave awkward unspent gaps that a slightly lower-PI project would have filled.
Simple vs discounted payback, and the words Beyond horizon
Simple payback counts raw cash until the cost is recovered; discounted payback counts present values, so it answers when the project repays its cost in today’s dollars. With a positive discount rate and ordinary inflows, discounted payback lands later than simple payback or at the same point, never earlier, because every discounted inflow is worth less than its face value. At a 0% rate the two are identical, as the checks table above shows.
When the cumulative line never reaches zero inside the entered periods, the tool prints “Beyond horizon” rather than a misleading number. That is a real answer, not an error: on the entered forecast the project does not repay, in raw or discounted terms, and both the $50,000 check row above and any slow project will show it. Neither payback flavour says anything about cash after the payback date, which is why NPV stays the decision metric and payback stays the exposure metric. The screening role of payback and ARR alongside NPV is the same division of labour the capital budgeting chapters in the references describe.
What competing calculators miss
NPV tools split into PI-only widgets, capped-period calculators and all-in-one appraisal suites. Each camp drops something this page keeps:
- PI-only tools (the wpcalc profitability index page): you must already know the present value of the future cash flows before the tool does anything. There is no cash flow schedule, no discounting step, no NPV and no payback, so the hardest part of the job is left to a spreadsheet.
- Capped-period tools (Omni’s NPV calculator): five cash flow periods by default and nine in advanced mode. Real equipment and property projects routinely run ten to twenty periods; here the schedule is one free-form list with no period cap.
- Formula errors in popular explainers: at least one widely read PI guide states the index as NPV divided by the initial investment, which would put the accept line at 0 instead of 1.0 and understate every index by exactly 1. PI is the present value of inflows divided by the investment, equivalently 1 + NPV / investment, and the results panel here shows both forms reconciling.
- Payback quoted as a bare whole number: several suites report “3 years” and stop. This tool interpolates inside the payback period (2.60 and 2.96 on the worked example), which is how the textbooks quote it and the only version precise enough to compare two close projects.
- The gap this page fills: NPV, PI, a verdict, discounted and simple ROI, an honestly labelled ARR, both paybacks interpolated, and the full discount-factor table in one run, with no period cap and negative years supported.
Frequently asked questions
Use your cost of capital if you are appraising a company project, or your required rate of return if the money is yours. For companies, the weighted average cost of capital (WACC) is the standard starting point. For personal investments, use the return of your next-best alternative. A higher rate makes fewer projects pass, because future cash gets discounted harder.
Because it divides the present value of the benefits (the inflows) by the present value of the cost (the initial investment). A ratio above 1.0 means benefits exceed costs in present-value terms, which is exactly the same test as a positive NPV, stated as a ratio instead of a dollar amount.
Yes, but only when the discounted inflows add up to a negative total, which takes large negative cash flows in the schedule. Enter inflows of -1,000 and -2,000 against a $10,000 investment at 10% and this calculator returns a PI of -0.2562. In a normal project with positive inflows, PI stays above zero and the decision line is 1.0.
Enter each period’s net cash flow exactly as it falls, negative in a year where the project consumes cash. The calculator discounts every line the same way: a negative year reduces NPV, lengthens both payback measures, and appears as a negative present value in the period table.
Only through the discount rate. NPV has no separate risk input, so a riskier project should be tested at a higher rate, which discounts distant cash flows more heavily. Running the same project at two or three rates is the practical way to see how much of the verdict is risk assumption rather than arithmetic.
Payback answers a different question: how long is the money at risk? A project can clear NPV and still take most of its life to hand the cash back, which matters for liquidity and for how long the forecasts have to hold up. Discounted payback states that exposure in today’s dollars; NPV states the value created.
The tool finds the first period where cumulative cash flow turns positive, then divides the balance still unrecovered at the start of that period by that period’s cash flow. In the worked example, $30,000 is still unrecovered after year 2 and year 3 brings in $50,000, so simple payback is 2 + 30,000 / 50,000 = 2.60 periods. The display pairs the whole period count with that fraction, for example 3 periods (2.60 interpolated).
Here it is the average annual cash inflow divided by the initial investment, shown as a percentage. That is a cash-based shortcut, not the textbook accounting rate of return, which uses average accounting profit after depreciation instead of cash inflows. On the worked example it reads 40.00%, because the average inflow is $40,000 on a $100,000 investment. Treat it as a rough sizing figure and let NPV make the decision.
Add This Calculator to Your Website
Embed this calculator on your own site with the code below. Pick a size to preview it live, then copy the code.
Powered by Calculator Zilo
References
- OpenStax, Rice University. Net Present Value (NPV) Method, Principles of Finance. Accessed October 22, 2026.
- OpenStax, Rice University. Choosing between Projects, Principles of Finance. Accessed October 22, 2026.
- OpenStax, Rice University. Applications of TVM in Finance, Principles of Finance. Accessed October 22, 2026.
- OpenStax, Rice University. Compare and Contrast Non-Time Value-Based Methods and Time Value-Based Methods in Capital Investment Decisions, Principles of Managerial Accounting. Accessed October 22, 2026.
- OpenStax, Rice University. Describe Capital Investment Decisions and How They Are Applied, Principles of Managerial Accounting. Accessed October 22, 2026.
- Harvard Business School Online. How to Determine Profitability. Accessed October 22, 2026.
- U.S. Securities and Exchange Commission, Investor.gov. Compound Interest Calculator. Accessed October 22, 2026.
- Board of Governors of the Federal Reserve System. The Discount Window and Discount Rate. Accessed October 22, 2026.
- U.S. Department of the Treasury. Daily Treasury Par Yield Curve Rates. Accessed October 22, 2026.
- Federal Reserve Bank of St. Louis, FRED. Market Yield on U.S. Treasury Securities at 10-Year Constant Maturity (DGS10). Accessed October 22, 2026.