NPV Calculator - Net Present Value

NPV Calculator - Net Present Value

Discount a stream of future cash flows, compare it with the initial investment, and review NPV, IRR, MIRR, payback period and profitability index in one clear worksheet.

Last Updated: July 23, 2026

Use this net present value calculator when you want to test whether a business project, rental property, equipment purchase, startup investment, product launch or capital-budgeting option creates value after allowing for the time value of money. The calculator does not use a hard-coded market rate, tax slab or loan assumption. You enter the discount rate, finance rate, reinvestment rate and cash flows that match your current project, currency and risk profile.

Calculate NPV From Cash Flows

Enter the upfront cost as a positive number. Future cash flows may be positive or negative, so the tool can handle maintenance costs, shutdown costs, tax outflows, salvage value and uneven project income.

Display and timing
Used only when Custom is selected.
Most NPV work uses end-of-period cash flows.
Investment and rates
$
%
Required return, WACC or opportunity cost per period.
%
%
Projected cash flows
Net present value$0

Enter cash flows to calculate NPV.

PV of future cash flows$0
Profitability indexN/A
IRRN/A
MIRRN/A
Simple paybackN/A
Discounted paybackN/A
Equivalent annual value$0
PV outflows used in PI$0

The result updates after calculation.

Discounted cash flow detail

Line itemCash flowTiming periodPresent valueCumulative discounted value

Discount-rate sensitivity

Discount rateNPVProfitability indexDecision signal

NPV is an estimate from the assumptions entered. Use current project quotes, taxes, financing costs, working-capital assumptions and risk-adjusted return requirements before relying on a result.

How to Use This NPV Calculator

  1. Choose a currency symbol and number format. This only changes display formatting; it does not convert currencies.
  2. Enter the initial investment as a positive amount. The calculator treats it as a period-zero cash outflow.
  3. Enter the discount rate per period. If your cash flows are yearly, use an annual required return. If your cash flows are monthly, use a monthly discount rate.
  4. Select whether the projected cash flows happen at the end or beginning of each period.
  5. Add yearly cash flows. Use positive numbers for inflows and negative numbers for costs, reinvestment, clean-up costs, tax payments or other outflows.
  6. Review NPV first, then use IRR, MIRR, profitability index and payback as supporting metrics.

A good NPV model is less about typing one perfect forecast and more about testing a range of honest assumptions. Try a conservative case, a base case and an upside case. If a project only looks attractive under optimistic cash flows and a low discount rate, the decision needs more scrutiny.

What Net Present Value Means

Net present value, usually shortened to NPV, is the value today of all expected project cash flows after subtracting the money invested today. It is one of the core tools of discounted cash flow analysis because it recognizes that money received later is not worth the same as money available now. A dollar, rupee, euro or pound today can be invested, used to reduce debt, or kept as liquidity. Future cash needs to be discounted to make a fair comparison.

If NPV is positive, the project is estimated to create value above the discount rate you entered. If NPV is negative, the project is estimated to fall short of that required return. If NPV is close to zero, the project roughly breaks even at the selected discount rate, which means small changes in assumptions could flip the decision.

NPV = ∑ [ CFt / (1 + r)t ] - Initial Investment

In the formula, CFt is the cash flow in period t, r is the discount rate per period, and t is the period number. The calculator also supports beginning-of-period timing by moving the first projected cash flow to period zero.

Worked NPV Example

Suppose a business is considering equipment that costs $100,000 today. Management expects end-of-year cash flows of $25,000, $30,000, $35,000, $40,000 and $20,000. If the required return is 10% per year, each cash flow is discounted back to today:

YearCash flowDiscount factor at 10%Present value
1$25,0001 / 1.10$22,727
2$30,0001 / 1.102$24,793
3$35,0001 / 1.103$26,296
4$40,0001 / 1.104$27,321
5$20,0001 / 1.105$12,418

The present value of the future cash flows is about $113,556. After subtracting the $100,000 initial investment, NPV is about $13,556. Because the NPV is positive, the project is estimated to add value at a 10% required return. That does not guarantee the project will succeed, but it means the forecast clears the hurdle rate entered.

How to Choose a Discount Rate

The discount rate should match the risk, timing and basis of the cash flows. For a company, it might come from weighted average cost of capital, a project hurdle rate, or the return required by investors. For a personal investment, it might be the return you could reasonably earn on another opportunity with similar risk. For real estate, infrastructure or business acquisitions, analysts often test several rates because debt costs, equity expectations, vacancy, inflation and execution risk can change the answer.

  • Use a nominal discount rate for nominal cash flows that include expected inflation.
  • Use a real discount rate for real cash flows stated in today's purchasing power.
  • Use the same period for both the rate and the cash flows. Annual cash flows need an annual rate; monthly cash flows need a monthly rate.
  • Do not use a risk-free rate for a risky project unless the cash flows have already been certainty-adjusted.
  • Update the rate when financing terms, benchmark yields, project risk or inflation expectations materially change.

This page intentionally asks you to enter the rate instead of assuming a current market number. There is no universal 2026 NPV discount rate. A safe treasury-like cash flow, a leveraged property development and a startup product launch should not be discounted at the same rate.

NPV, IRR, MIRR, ROI and Payback Compared

NPV is usually the most decision-focused measure for capital budgeting because it estimates value in currency terms. Other measures are useful, but they answer different questions. The calculator includes several supporting metrics so you can see where they agree or conflict.

MetricWhat it answersBest useMain caution
NPVHow much value is created today?Choosing projects with a selected discount rate.Depends heavily on forecast quality and the discount rate.
IRRWhat discount rate makes NPV equal zero?Understanding an implied return from the cash flow pattern.Can be missing or multiple when cash flows change sign more than once.
MIRRWhat return results after separate finance and reinvestment assumptions?Cleaner return estimate for uneven or non-standard projects.Still depends on the reinvestment and finance rates entered.
Profitability indexHow much PV benefit is generated per PV dollar of outflow?Ranking projects when capital is limited.Can favor smaller projects even when a larger project has higher NPV.
PaybackHow quickly is the investment recovered?Liquidity and risk screening.Ignores value after payback and, for simple payback, ignores discounting.
ROIWhat is total gain relative to cost?Simple one-period comparisons.Does not handle timing as carefully as NPV.

Reading the Calculator Results

Positive NPV

A positive result means the discounted value of expected cash inflows exceeds the discounted value of expected outflows. If the assumptions are reasonable and the project fits your risk limits, a positive NPV is usually a favorable signal.

Zero or near-zero NPV

A result close to zero means the project roughly earns the discount rate. It may still be worth doing for strategic reasons, but the financial margin of safety is thin.

Negative NPV

A negative result means the project is estimated to destroy value at the required return entered. The project might need a lower purchase price, higher expected cash flows, lower risk, lower costs or a better strategic reason before it makes sense.

Multiple or unavailable IRR

IRR can fail when cash flows are unusual. A project with an outflow, inflows and then a large future outflow can have more than one IRR. In those cases, NPV and MIRR are usually more reliable for decision-making.

Common NPV Mistakes to Avoid

  • Mixing monthly cash flows with an annual discount rate.
  • Ignoring taxes, fees, maintenance, working capital, terminal value or disposal costs.
  • Using optimistic revenue projections without testing lower-demand scenarios.
  • Comparing projects with different lives without checking equivalent annual value.
  • Using IRR as the only decision rule when projects are mutually exclusive.
  • Treating a calculator estimate as a quote, valuation report, investment recommendation or guarantee.

For high-stakes decisions, build a detailed model from source documents: contracts, invoices, financing offers, tax rules, lease terms, operating budgets and current market research. The NPV result is only as reliable as those inputs.

Related Investment Calculators

Continue with nearby 1Dollars calculators when you need a different return, growth or valuation measure.

Frequently Asked Questions

What is NPV?

NPV is the present value of expected future cash flows minus the initial investment. It helps estimate whether a project creates or destroys value at a chosen discount rate.

What discount rate should I use?

Use a rate that reflects the timing, risk and opportunity cost of the project. Companies may use WACC or a hurdle rate; individuals may use the return required to justify taking similar risk.

Is a higher NPV always better?

For mutually exclusive projects with similar risk and capital constraints, the higher NPV usually creates more value. Still compare scale, timing, liquidity, strategic fit and execution risk.

Why do NPV and IRR sometimes disagree?

NPV measures currency value at a selected discount rate, while IRR reports a break-even rate. Projects with different size, timing or non-normal cash flows can rank differently under the two metrics.

Can I use this for monthly cash flows?

Yes. Treat each row as one month and enter a monthly discount rate. For example, an annual nominal rate of 12% is roughly 1% per month before compounding adjustments.

Does this calculator use live interest rates?

No. NPV depends on the specific project and risk profile, so the calculator uses the rates you enter instead of applying a universal market rate.

How are negative future cash flows handled?

Negative future cash flows are discounted like any other cash flow and reduce NPV. They also increase the present value of outflows used for the profitability index.

Is payback better than NPV?

Payback is useful for liquidity screening, but it is not better than NPV for value measurement. Simple payback ignores discounting and cash flows after the recovery date.

Financial disclaimer: This NPV calculator is for educational planning only. It is not investment, tax, accounting, legal, valuation, lending or financial advice. Verify cash flows, tax treatment, financing terms, market assumptions and risk inputs with qualified professionals before making consequential decisions.

Post a Comment

0Comments

Post a Comment (0)