Net Present Value (NPV) Calculator
Find the NPV of an investment.
Result
How it is calculated
The tool assumes equal cash flows at the end of each period. The present value of those inflows is PV = CF × (1 − (1 + r)^−n) / r and NPV = PV − initial investment. CF is the cash flow per period, r the discount rate per period as a decimal (8% becomes 0.08) and n the number of periods. When the rate is 0 it simply uses CF × n. The initial outlay is entered as a positive number and is assumed to happen now. A positive NPV means the project earns more than the discount rate, a negative one that it earns less.
Worked example
Invest 10,000 and receive 3,000 at the end of each of 5 years, with an 8% discount rate. Discount factor: (1 − 1.08^−5) / 0.08 ≈ 3.9927. Present value of inflows: 3000 × 3.9927 = $11,978.13. NPV: 11,978.13 − 10,000 = $1,978.13. This project is worth taking at that rate.
Common mistakes
- Entering the initial investment as a negative number. The tool subtracts it itself, so a minus sign gives the wrong answer.
- Mixing periods, such as a yearly discount rate with monthly cash flows. Rate and periods must use the same unit.
- Using this for uneven cash flows. The tool needs the same amount every period.
- Choosing the discount rate casually. NPV is very sensitive to it, so test a few rates.
About this calculator
Net present value (NPV) discounts a series of future cash flows back to today's value and subtracts the initial investment, so that money received later counts for less than money received now: NPV = Σ [CF / (1+r)ᵗ] − Initial Investment, where r is the discount rate (reflecting the cost of capital or required rate of return) and t is the period of each cash flow. For a project with equal periodic cash flows, this simplifies to an annuity present-value calculation.
Corporate finance analysts, investors, and business owners use NPV as the standard test for whether a project or investment is worth pursuing: a positive NPV means the investment is expected to create value above the required rate of return, while a negative NPV means it's expected to destroy value even before accounting for risk. Enter the periodic cash flow, discount rate, number of periods, and initial investment to find the NPV.
Was this helpful?
You can pick up to 3 reactions.
Popular calculators
Loan Calculator
Monthly payment, total interest and full amortization schedule.
Percentage Calculator
Percent change, percent of, and ratio calculations.
Discount Calculator
Calculate final price, savings, and discount amount.
BMI Calculator
Body mass index from height and weight (metric or imperial).
Age Calculator
Compute your exact age in years, months and days from a birth date.
Compound Interest Calculator
Calculate the final amount and interest earned with compounding.
All Calculators
No calculators found
Comments (0)