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 initial investment 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 tool assumes equal-length periods. If your cash flows are annual, the discount rate should be interpreted annually. This version does not convert monthly or quarterly flows automatically.
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. Empty middle rows are treated as zero, meaning no cash flow in that period.
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.
- 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?
Yes. Empty middle rows are treated as zero cash-flow periods, which can be useful when a project has no inflow or outflow in a period.
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.