NPV Calculator: Net Present Value

Determine whether a project or investment creates value by discounting future cash flows to today's dollars.

Discount Rate (required return)10%

0%30%

Initial Investment (outflow at t=0)

Annual Cash Flows (one per line or comma-separated)

Terminal Value (optional: cash flows beyond forecast period)

Initial Investment$100,000

$0$500K

Annual Cash Flow (uniform)$30,000

$0$200K

Discount Rate10%

0%30%

Number of Years5 yrs

yrs

130

Net Present Value (NPV)

—

PV of Cash Flows

—

Total Undiscounted CFs

—

Profitability Index

—

Forecast Period

—

Decision

—

💹 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=1ⁿ CF_t ÷ (1+r)^t − C₀

CF_t = 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

C₀ = initial investment (cash outflow at time zero)

Annuity shortcut: when all CF_t are equal (CF), PV = CF × (1 − (1+r)⁻ⁿ) ÷ r

Example: Initial investment $100,000, cash flows $30,000/yr for 5 years, discount rate 10%. PV = 30,000 × (1 − 1.1⁻⁵) / 0.10 = $113,724. NPV = 113,724 − 100,000 = +$13,724. Accept.

📖 How to Use This Calculator

Steps

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).

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.

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%.

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.

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

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.

PV Year 1: 50,000 / 1.12 = $44,643. PV Year 2: 65,000 / 1.2544 = $51,818. PV Year 3: 80,000 / 1.4049 = $56,942. PV Year 4: 90,000 / 1.5735 = $57,197. PV Year 5: 95,000 / 1.7623 = $53,906.

Total PV of inflows = 44,643 + 51,818 + 56,942 + 57,197 + 53,906 = $264,505.

NPV = $264,505 − $250,000 = +$14,505: 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

Initial investment: $500,000. Annual cash flow: $60,000 (uniform). Discount rate: 10%. Years: 15.

PV of annuity = 60,000 × (1 − 1.10⁻¹⁵) / 0.10 = 60,000 × 7.6061 = $456,365.

NPV = $456,365 − $500,000 = −$43,635. Profitability Index = 0.913.

NPV = −$43,635: 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

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).

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,205.

Total PV = 103,826 + 88,205 = $192,031. NPV = $192,031 − $80,000 = +$112,031.

NPV = +$112,031: 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.

🔗 Related Calculators

What is Net Present Value (NPV) and why does it matter?

NPV is the sum of all future cash flows discounted to today's value, minus the initial investment. A positive NPV means the project earns more than your required return and adds wealth. A negative NPV destroys value. NPV is considered the gold standard capital budgeting metric because it accounts for the time value of money and gives a dollar amount of value created.

What is the NPV formula?

NPV = sum of [CF_t / (1+r)^t] for t from 1 to n, minus the initial investment C0. CF_t is the cash flow in year t, r is the discount rate per period, and n is the number of periods. Each future cash flow is divided by (1+r)^t to convert it to a present-day equivalent.

What discount rate should I use for NPV?

Use your hurdle rate or Weighted Average Cost of Capital (WACC). For a corporate project, WACC blends the after-tax cost of debt and the cost of equity. For personal investments, use your opportunity cost, the return you would earn on your next-best alternative. Common ranges are 8% to 12% for stable projects and 15% to 25% for riskier ventures.

What is the difference between NPV and IRR?

NPV tells you the dollar amount of value a project adds at a given discount rate. IRR is the discount rate that makes NPV equal to zero. Both methods should give the same Accept/Reject signal for independent projects, but they can rank mutually exclusive projects differently. NPV is generally preferred because it measures value in dollars, not percentages, and avoids the multiple-IRR problem that arises with non-conventional cash flows.

What is a good NPV?

Any positive NPV is acceptable in isolation. When comparing projects, a higher NPV is better if you have capital. When comparing projects of different sizes, use the Profitability Index (PV of inflows divided by initial investment) so a small high-return project is not automatically overshadowed by a large project with modest returns.

What is the profitability index and how is it used?

The Profitability Index (PI) equals the present value of future cash flows divided by the initial investment. A PI above 1.0 means the project creates value. PI is most useful when you have a capital constraint and must choose between projects. Rank projects by PI and fund them in order until the budget is exhausted. This maximises total NPV per dollar invested.

Can NPV be negative even if total cash flows exceed the initial investment?

Yes. NPV discounts future cash flows, so a project that pays back $200,000 over 20 years on a $100,000 investment may still show negative NPV if the discount rate is high enough. The time value of money means $200,000 received over 20 years is worth far less than $200,000 received today.

How does the Annuity mode differ from the Variable Cash Flows mode?

Annuity mode assumes you receive the same cash flow every year and applies the annuity present value formula: PV = CF times (1 minus (1+r)^(-n)) divided by r. Variable Cash Flows mode lets you enter a different amount for each year and a terminal value for cash flows beyond the forecast horizon. Use Annuity mode for stable income streams like bonds, leases, or fixed-fee contracts.

What is a terminal value in NPV analysis?

Terminal value captures the present value of all cash flows beyond the explicit forecast period. It is added as a lump sum in the final period of your model. The Gordon Growth Model formula is commonly used: TV = CF_n times (1+g) divided by (r minus g), where g is the perpetual growth rate. Terminal value often represents more than half of total NPV for long-lived projects or businesses.

How does currency affect NPV calculations?

NPV is denominated in whatever currency your cash flows are denominated in. This calculator supports switching between major currencies (USD, GBP, EUR, INR, and more) for display purposes. The math is identical regardless of currency. When comparing projects in different currencies, convert all cash flows to a single currency first using expected exchange rates.

What is NPV used for in capital budgeting?

In capital budgeting, NPV helps managers decide which projects to approve. The rule is simple: accept projects with NPV greater than or equal to zero when evaluated at the firm's hurdle rate (WACC). When choosing between mutually exclusive projects, choose the one with the highest positive NPV. NPV is the preferred method over payback period and accounting rate of return because it explicitly accounts for the time value of money and all cash flows over the project's life.

Does NPV assume cash flows arrive at year end?

By convention, yes. Standard NPV calculations discount cash flows as if they arrive at the end of each period (ordinary annuity convention). If your cash flows arrive at the beginning of each period (annuity due), multiply the NPV result by (1+r) to adjust. The difference is significant at high discount rates or over long periods.

📌 Quick Tips

💡Your discount rate is your required rate of return, the minimum return that justifies the project's risk. Most corporate finance teams use 8% to 15%. A higher rate makes it harder for a project to show a positive NPV.

💡NPV greater than zero means the project returns more than your discount rate and adds value. NPV less than zero means it destroys value at your required return. NPV of exactly zero means the project earns exactly your required rate (its IRR equals the discount rate).

💡The profitability index (PI = PV of cash flows divided by initial investment) ranks projects when you have limited capital. A PI above 1.0 means every dollar invested returns more than a dollar in present value. When choosing between projects with different sizes, a higher PI is better.

💡Use the Annuity mode when your project generates roughly equal annual cash flows, such as a rental property, bond coupon, or fixed-fee service contract. Use Variable Cash Flows when inflows differ year by year, as is common in product launches or capital projects.

💡Always include a terminal value if the project or business continues beyond your explicit forecast period. Even a conservative terminal value can represent 40% to 70% of total NPV for long-lived assets.