The Net Present Value calculator, provided by Hesapstan, estimates the NPV of an initial investment and up to 30 signed period cash flows using the discount rate you enter. It is a financial math tool for user-entered assumptions, not an investment recommendation or a promise that a project will perform as modeled.
What does NPV measure?
Net present value converts future cash flows into today's value using a discount rate, then subtracts the initial investment. A positive NPV means that, at the entered discount rate, the discounted inflows exceed the period-0 outflow. A negative NPV means the opposite under the same assumptions.
This calculator treats the optional initial investment (entered under “Advanced”) as a period-0 cash outflow. Later rows can be positive or negative, so you can model income, expenses, reinvestment, repairs, exit payments, or other period cash flows.
A positive NPV does not guarantee that a project is good. The result depends on the cash flows, the discount rate, and the assumption that periods are equal. Taxes, inflation, financing costs, and risk are not automatically included.
How the calculation works
Each period cash flow is discounted by its period number. A cash flow received in period 1 is discounted once, a cash flow in period 2 is discounted twice, and so on. The farther away the cash flow is, the more the discount rate reduces its present value.
- Enter the initial investment as a magnitude; the model treats it as a period-0 outflow.
- Enter each future cash flow with its correct + or − sign.
- The calculator divides each CFt by (1+r)^t to get its present value.
- It adds the present values and subtracts the initial investment to produce NPV.
- The result also shows the number of periods, the undiscounted total of the future cash flows, the initial investment, and the net undiscounted total including the investment; the two totals are different.
The tool assumes equal-length periods and applies the discount rate once per period: enter an annual rate for yearly cash flows and a monthly rate for monthly ones. This version does not convert an annual rate to a monthly one (or the reverse) automatically, and a rate in the wrong unit changes the result materially.
Worked example: one project, two discount rates
Suppose the initial investment is 100,000 and the project returns 40,000 in each of four periods. With a 30% discount rate, the NPV is about −13,350.37. With a 10% discount rate, the same cash flows give an NPV of about +26,794.62.
The example shows why the discount rate is not a small detail. A higher discount rate lowers the present value of future inflows and can move the same project from positive to negative NPV.
- Positive NPV: the project may create value at the entered discount rate.
- Negative NPV: the discounted cash flows may not cover the initial outflow at that rate.
- Near-zero NPV: the project is close to break-even under the entered assumptions.
Cash-flow signs and the period table
The sign of each row matters. A positive row is a cash inflow; a negative row is a cash outflow. If a period includes an additional investment, maintenance cost, or closing payment, it should be entered as a negative flow. You choose the number of periods from the drop-down; once at least one of the selected periods has an amount, the periods you leave empty (trailing ones included) count as zero cash flow and keep their period numbers. An explicitly typed 0 is valid too, and only a form with no period amount at all is refused. For an outgoing flow, type a minus sign before the amount or use the +/− button on the row.
If a cost is entered as positive by mistake, NPV can look materially better than it really is. Review the +/− state of each cash-flow row before relying on the result.
NPV vs IRR, ROI, and payback period
NPV answers a money-value question at a chosen discount rate. IRR answers a rate question by finding the rate that makes NPV equal to zero. ROI is a simpler return ratio, and payback period focuses on when the initial investment is recovered.
- Use NPV when the discount rate is known or chosen and you want today's money value.
- Use IRR when you want the rate implied by the cash-flow sequence, while remembering that multiple IRR can occur.
- Use ROI for a simpler gain-versus-cost ratio.
- Use payback period when timing of recovery is more important than discounted value.
Limitations of this calculator
This is a deterministic calculator based on values you enter. It does not fetch market data, estimate risk, or decide the correct discount rate for you.
- No XNPV or date-based unequal-period calculation.
- The number of periods is chosen from 1 to 30. The discount rate can be any value strictly above −100%, including 0 and negative rates. At exactly −100% the discount denominator is zero (undefined); rates below −100% are outside this calculator's supported financial domain. Both are rejected.
- No taxes, inflation, terminal value, commissions, or financing costs unless you include them as cash-flow rows.
- No automatic monthly or quarterly rate conversion.
- No investment advice or project recommendation.
If you need the rate that makes NPV zero, use the IRR calculator. If you need a simple return percentage, use ROI. If you need the recovery timing, use the payback period calculator.
Frequently Asked Questions
Is positive NPV always good?
No. Positive NPV means the project is positive under the entered discount rate and cash-flow assumptions. It does not remove business, market, tax, financing, or execution risk.
What discount rate should I use?
The calculator does not choose the rate. Users often use a required return, cost of capital, opportunity cost, or scenario rate, but the correct assumption depends on the case.
Do empty cash-flow rows count?
Within the number of periods you select, empty rows count as zero once at least one amount is entered (trailing rows included), and the period numbering is kept. An explicit 0 is valid as well, but no result is produced if no period amount is entered at all.
Should the discount rate be an annual rate?
Use the rate for the same length of time as one cash-flow period: annual for yearly periods, monthly for monthly periods. The calculator does not convert the rate and applies the same rate to every period.
Can the discount rate be zero or negative?
Yes. At 0% the NPV equals the undiscounted total of all cash flows including the investment, and negative rates work as long as they are strictly above −100%. At exactly −100% the discount factor divides by zero, and rates below −100% are outside this calculator's supported domain. Both are rejected.
Is NPV the same as IRR?
No. NPV gives a money amount at a selected discount rate. IRR finds the rate that makes NPV approximately zero.
Does this calculator handle dated cash flows?
No. It assumes equal periods. Dated cash flows with irregular timing require XNPV or a date-based model.