NPV Calculator: Net Present Value
Determine whether a project or investment creates value by discounting future cash flows to today's dollars.
💹 What is Net Present Value (NPV)?
Net Present Value (NPV) is the most widely used metric in capital budgeting and investment appraisal. It measures the total value a project creates by subtracting the initial investment from the sum of all future cash flows discounted to today's dollars. A positive NPV means the project earns more than your required return, so it adds value. A negative NPV means the project earns less than your required return and should be rejected unless strategic considerations override the numbers.
NPV is used across every sector that involves long-term decisions: manufacturing companies evaluating new plants, private equity firms underwriting acquisitions, real estate developers projecting rental income, and individual investors comparing bond yields or rental property returns. Any scenario where you spend money now to receive money later can be evaluated with NPV. Common applications include factory expansion projects, commercial real estate investments, software development initiatives, renewable energy plants, toll road concessions, and pharmaceutical drug pipelines.
The core insight behind NPV is the time value of money: a dollar received one year from now is worth less than a dollar today because today's dollar can be invested to earn a return. By discounting each future cash flow at your required rate of return, NPV converts all future receipts to their present-day equivalent and makes them directly comparable to the upfront cost. This is fundamentally different from simpler metrics like payback period (which ignores the time value of money and cash flows after payback) or accounting rate of return (which uses accounting profit instead of cash flow).
The discount rate you choose is critical. It represents the opportunity cost of capital, the return you could earn on the next-best alternative investment of equivalent risk. For a company, this is typically the Weighted Average Cost of Capital (WACC). For a personal investor, it might be the expected return of an index fund. If the discount rate is too low, borderline projects look better than they are. If it is too high, good projects get incorrectly rejected. Sensitivity analysis, recalculating NPV at multiple discount rates, is standard practice for any material investment decision.
📐 Formula
NPV = ∑t=1n CFt ÷ (1+r)t − C0
CFt = cash flow in year t (positive for inflows, negative for outflows)
r = discount rate per period (required rate of return / WACC, as a decimal)
t = time period (year 1, year 2, ... year n)
n = total number of periods in the project
C0 = initial investment (cash outflow at time zero)
Annuity shortcut: when all CFt are equal (CF), PV = CF × (1 − (1+r)−n) ÷ r
Example: Initial investment $100,000, cash flows $30,000/yr for 5 years, discount rate 10%. PV = 30,000 × (1 − 1.1−5) / 0.10 = $113,724. NPV = 113,724 − 100,000 = +$13,724. Accept.
📖 How to Use This Calculator
Steps
1
Choose a mode: Select Variable Cash Flows if your project generates different amounts each year. Select Uniform Annuity if you receive the same amount every year (bond coupons, fixed lease payments, uniform service fees).
2
Enter the initial investment: Type the total upfront cost you pay today (time zero). This is typically the purchase price, project cost, or capital expenditure. Do not discount it since it is already in today's dollars.
3
Set the discount rate: Enter your required rate of return as a percentage. Use your company's WACC for corporate projects, or your personal opportunity cost rate for personal investments. Typical values range from 8% to 15%.
4
Enter cash flows: In Variable mode, type each year's net cash inflow on a new line or separated by commas. Optionally add a terminal value for any remaining asset value. In Annuity mode, enter the fixed annual amount and number of years.
5
Read the result: A positive NPV (shown in green) means Accept. A negative NPV (shown in red) means Reject. The Profitability Index shows value earned per dollar invested: anything above 1.0 is value-creating.
💡 Example Calculations
Example 1: Manufacturing Plant Expansion
A factory expansion costs $250,000 and generates variable annual savings over 5 years at a 12% hurdle rate
1
Initial investment: $250,000. Discount rate: 12%. Annual cash flows (net savings): Year 1: $50,000, Year 2: $65,000, Year 3: $80,000, Year 4: $90,000, Year 5: $95,000.
2
PV Year 1: 50,000 / 1.12 = $44,643. PV Year 2: 65,000 / 1.2544 = $51,822. PV Year 3: 80,000 / 1.4049 = $56,943. PV Year 4: 90,000 / 1.5735 = $57,190. PV Year 5: 95,000 / 1.7623 = $53,911.
3
Total PV of inflows = 44,643 + 51,822 + 56,943 + 57,190 + 53,911 = $264,509.
NPV = $264,509 − $250,000 = +$14,509: Accept (PI = 1.058)
Try this example →Example 2: Commercial Lease Investment (Annuity)
A commercial property costs $500,000 and generates $60,000/year net rent for 15 years at a 10% required return
1
Initial investment: $500,000. Annual cash flow: $60,000 (uniform). Discount rate: 10%. Years: 15.
2
PV of annuity = 60,000 × (1 − 1.10−15) / 0.10 = 60,000 × 7.6061 = $456,364.
3
NPV = $456,364 − $500,000 = −$43,636. Profitability Index = 0.913.
NPV = −$43,636: Reject at 10%. The property yields an IRR below 10%.
Try this example →Example 3: Software Project with Terminal Value
A SaaS product costs $80,000 to build, generates growing cash flows for 4 years, and has a terminal value of $120,000 at an 8% discount rate
1
Initial investment: $80,000. Discount rate: 8%. Cash flows: Year 1: $15,000, Year 2: $25,000, Year 3: $40,000, Year 4: $50,000. Terminal value: $120,000 (discounted at end of year 4).
2
PV of CFs: 15,000/1.08 + 25,000/1.1664 + 40,000/1.2597 + 50,000/1.3605 = 13,889 + 21,433 + 31,753 + 36,751 = $103,826. PV of TV: 120,000/1.3605 = $88,203.
3
Total PV = 103,826 + 88,203 = $192,029. NPV = $192,029 − $80,000 = +$112,029.
NPV = +$112,029: Strong Accept (PI = 2.40)
Try this example →❓ Frequently Asked Questions
What is Net Present Value (NPV) in simple terms?
NPV is a way to compare money received in the future to money spent today. Because a dollar today is worth more than a dollar in the future (it can be invested and earn a return), you discount future cash flows. NPV sums those discounted future inflows and subtracts what you paid upfront. Positive NPV means you earned more than your required return and made a good investment.
What discount rate should I use for my NPV calculation?
Use your opportunity cost of capital, the return you could earn on an alternative investment of equivalent risk. For a company, this is typically the WACC (Weighted Average Cost of Capital), often 8% to 12%. For a personal investment, compare to an index fund return of 7% to 10%. For riskier startup projects or venture investments, 20% to 30% is common. A higher discount rate is a tougher hurdle and produces a lower NPV.
What is the difference between NPV and IRR?
NPV tells you the dollar amount of value created at a specific discount rate. IRR is the discount rate at which NPV equals exactly zero. Use IRR to quickly compare a project's return to your hurdle rate. Use NPV when deciding which project to choose between two options of different sizes, since NPV measures total value in dollars and IRR is a percentage. For most decisions, both metrics should agree, but when they conflict, NPV is the more reliable guide.
What does a negative NPV mean: should I always reject the project?
A negative NPV means the project earns less than your required return at the chosen discount rate. In purely financial terms, yes, you should reject it. However, some projects with negative financial NPV are approved for strategic reasons: entering a new market, complying with regulations, building brand reputation, or retaining a key customer. These benefits can be real but are hard to quantify in a cash flow model.
How is profitability index different from NPV?
Profitability Index (PI) equals the present value of cash flows divided by the initial investment. PI is a relative measure (value per dollar invested), while NPV is an absolute measure (total dollars of value created). PI is most useful when you have a limited capital budget and need to rank which projects to fund first. A project with PI of 1.5 earns 50 cents of present value for every dollar invested. When choosing between a large project with NPV of $500,000 and a small project with NPV of $300,000, the small project might have the higher PI and be a better use of scarce capital.
Can NPV be used for stocks and bonds?
Yes. Bond valuation is essentially NPV: discount the future coupon payments and face value at your required yield to find fair price. Stock valuation using the Dividend Discount Model (DDM) or Discounted Cash Flow (DCF) analysis is also NPV applied to future dividends or free cash flows. If the calculated intrinsic value is above the market price, the stock may be undervalued (positive NPV of buying it at market price).
What happens to NPV if the discount rate increases?
NPV falls as the discount rate rises. Higher discount rates reduce the present value of each future cash flow more aggressively. Projects with cash flows that arrive far in the future are more sensitive to rate changes than projects with near-term payoffs. A project with NPV of +$50,000 at 8% might turn negative at 12%. This is why rising interest rates increase the hurdle for capital projects and reduce corporate investment.
What is the terminal value in an NPV model and how do I calculate it?
Terminal value represents the present value of all cash flows beyond your explicit forecast period. The two most common methods are the Gordon Growth Model (TV = CF_n times (1+g) / (r minus g), where g is the perpetual growth rate) and the exit multiple method (TV = EBITDA in final year times an industry multiple). Enter the resulting terminal value in the Terminal Value field and it will be discounted at the end of your last forecast year. Terminal value often accounts for 50% to 80% of total NPV in a long-lived project or business valuation.
How many decimal places should I use in NPV calculations?
NPV results for capital projects are typically rounded to the nearest dollar or thousand dollars. The precision of the inputs (especially the discount rate and long-term growth assumptions) rarely justifies more than four significant figures. More important than decimal precision is sensitivity analysis: running the NPV calculation at several discount rates (base, optimistic, pessimistic) to understand how robust the decision is.
What are the limitations of NPV analysis?
NPV has four main limitations. First, it assumes cash flows are known with certainty, but forecasts are often highly uncertain, especially for years 3 and beyond. Second, choosing the correct discount rate is subjective and can change the decision. Third, NPV does not capture optionality (the value of being able to expand, delay, or abandon a project). Fourth, it ignores qualitative factors like competitive positioning, brand value, and employee morale. Supplement NPV with scenario analysis, real options analysis, and qualitative judgment for important decisions.
Does NPV account for inflation?
NPV is consistent when you are consistent: if your cash flows are in nominal terms (including inflation), use a nominal discount rate (which includes an inflation component). If your cash flows are in real terms (constant purchasing power), use a real discount rate (nominal rate minus inflation). Mixing nominal cash flows with a real discount rate, or vice versa, produces incorrect results. For most corporate finance work, nominal cash flows and nominal WACC are used.
How do I use this NPV calculator for a rental property?
For a rental property, set the initial investment to the purchase price plus closing costs. Use Variable Cash Flows mode and enter each year's expected net operating income (rent minus operating expenses, property tax, insurance, and maintenance, but before mortgage payments). Add a terminal value equal to the expected sale price minus selling costs, discounted at your hold period (usually 5 to 10 years). Set the discount rate to your target return (typically 8% to 12% for real estate). A positive NPV means the property meets your return target at the assumed purchase price.