NPV Calculator · Net Present Value & IRR

NPV Calculator

Net Present Value · IRR · Payback Period · Profitability Index.

Currency
Investment Setup
%
years
Enter your initial investment as a negative number in Year 0. Use positive numbers for inflows (revenue, savings) and negative for outflows (costs).
Cash Flows
Year Description Cash Flow Present Value
Year 0 is typically your initial investment. Subsequent years are the returns. Cash flows can be positive or negative.
Investment Analysis
✅ Accept
Net Present Value: $ 0
IRR: — · Payback: —
📊 NPV
—
📈 IRR
—
📉 Payback
—
📊 Profitability Index
—
Initial Investment
—
Total Inflows
—
PV of Inflows
—
Discounted Payback
—
💡 Interpretation
Enter your cash flows to see the investment analysis.
📋 NPV Decision Rule
Accept: NPV > 0
Marginal: NPV ≈ 0
Reject: NPV < 0
PI target: ≥ 1.0
Discounted Cash Flow Analysis
YearCash FlowDiscount FactorPresent ValueCumulative PV

Powered by Toolraxy

`; embedCodeTextarea.value = ``; }window.toggleEmbedPanel = function() { if (embedPanel.style.display === 'none' || embedPanel.style.display === '') { generateEmbedCode(); embedPanel.style.display = 'block'; } else { embedPanel.style.display = 'none'; } };window.copyEmbedCode = function() { embedCodeTextarea.select(); navigator.clipboard?.writeText(embedCodeTextarea.value).then(() => alert('Embed code copied!')).catch(() => alert('Press Ctrl+C')); };document.addEventListener('DOMContentLoaded', function() { populateCurrency(); renderCashFlows(); currencySelect.addEventListener('change', function(e) { const found = currencies.find(c => c.code === e.target.value); if (found) currentCurrency = found; updateCurrencySymbols(); renderCashFlows(); calculate(); }); discountRate.addEventListener('input', calculate); discountRate.addEventListener('change', calculate); projectYears.addEventListener('input', calculate); projectYears.addEventListener('change', calculate); calculate(); }); })();

ADVERTISEMENT

Relevant Tools

Creator & Maintainer

Image of Faiq Ur Rahman, CEO & Founder Toolraxy

Faiq Ur Rahman

Founder & CEO, Toolraxy

Faiq Ur Rahman is a web designer, digital product developer, and founder of Toolraxy, a growing platform of web-based calculators and utility tools. He specializes in building structured, user-friendly tools focused on health, finance, productivity, and everyday problem-solving.

View Profile

Share:

Rate this Tool

User Ratings:

0
0 out of 5 stars (based on 0 reviews)
Excellent
Very good
Average
Poor
Terrible

ADVERTISEMENT

ADVERTISEMENT

NPV Calculator

Estimate whether a project, purchase, or investment adds value after accounting for the time value of money. Enter a discount rate, build a cash-flow timeline, and the NPV Calculator returns net present value, IRR, payback period, discounted payback, and profitability index. It also produces a year-by-year discounted cash flow table and a plain-language interpretation. Get a complete investment snapshot without manual spreadsheets.

Before capital goes into a project, the numbers need to survive more than a simple total. The NPV Calculator discounts every future cash flow back to today’s value, then compares that present value against the initial outlay. It suits business owners, analysts, students, real estate investors, and anyone comparing equipment, rentals, startups, solar installations, or other multi-year commitments. You can choose a currency, set a required return, add or remove yearly cash flows, and test preset scenarios. Because the tool runs in the browser, your figures stay on your device. Toolraxy presents this as an educational calculator, not a substitute for professional financial advice. Use it to see whether a project clears your hurdle rate or destroys value.

 

How to Use the NPV Calculator

  1. Pick your currency from the dropdown so all monetary results use the correct symbol.

  2. Set the discount rate as your required return. The default is 10%, with a valid range of 0% to 100%.

  3. Confirm the project period field matches your timeline. It updates automatically as you add or remove cash-flow rows.

  4. Enter the Year 0 cash flow, usually the initial investment as a negative number.

  5. Fill in each later year with positive inflows or negative outflows. Use the description field to label each line.

  6. Add or remove rows as needed, or click a quick example to load a preset cash-flow pattern.

  7. Press Calculate to refresh NPV, IRR, payback, discounted payback, and profitability index.

  8. Review the DCF table, decision badge, and interpretation text before copying or sharing the result.

 

How the NPV Calculator Formula Works

Net present value is the sum of every cash flow discounted back to the present at your required return. If the total is positive, the project creates value above that return; if negative, it destroys value.

Formula: NPV = Σ [ Cash Flow_t ÷ (1 + r)^t ]

Formula: Discount Factor = 1 ÷ (1 + r)^t

Formula: Present Value = Cash Flow × Discount Factor

Formula: r = Discount Rate ÷ 100

Formula: IRR = the rate where NPV = 0

Formula: Profitability Index = PV of positive cash flows ÷ absolute sum of negative cash flows

Formula: Total Inflows = sum of all positive cash flows

Formula: PV of Inflows = sum of present values for positive cash flows only

Formula: Initial Investment = first cash-flow row, Year 0

The calculator uses the discount rate to compute each year’s discount factor and present value. It then sums those present values to produce NPV. IRR is found by searching for the rate that makes NPV zero; it requires at least one positive and one negative cash flow, otherwise it returns N/A. Payback is the first point where cumulative undiscounted cash flow turns non-negative. Discounted payback does the same using cumulative present value. Profitability index divides the present value of positive cash flows by the absolute total of negative cash flows.

Validation and edge cases follow the visible code. The discount rate accepts 0 to 100. The project period field accepts 1 to 50, but the calculation iterates over the actual cash-flow rows. Cash-flow amounts can be positive or negative. Clearing or reducing below two rows resets the list to an initial investment and one later year. If every cash flow is zero, the tool shows an awaiting-data state. If total outflows are zero, profitability index becomes 0. If payback never occurs, the result reads Never.

 

Worked Example

Suppose a company buys equipment for $120,000. The discount rate is 8%. The expected savings are $32,000 in Year 1, $34,000 in Year 2, $36,000 in Year 3, $38,000 in Year 4, and $45,000 in Year 5, including salvage value.

Step 1: Discount each inflow.

  • Year 1: $32,000 ÷ 1.08 = $29,629.63

  • Year 2: $34,000 ÷ 1.08² = $29,149.52

  • Year 3: $36,000 ÷ 1.08³ = $28,579.95

  • Year 4: $38,000 ÷ 1.08⁴ = $27,931.13

  • Year 5: $45,000 ÷ 1.08⁵ = $30,626.24

Step 2: Add the present values. PV of inflows = $145,916.47.

Step 3: Subtract the initial investment. NPV = $145,916.47 − $120,000 = $25,916.47.

Step 4: Read the supporting metrics. IRR is about 15.44%. Undiscounted payback is roughly 3.47 years. Discounted payback is about 4.15 years. Profitability index is 1.22. Because NPV is positive and PI is above 1.0, the calculator labels this an Accept — Positive NPV project.

The takeaway: the equipment purchase is expected to return more than the 8% required return. It adds about $25,916 in present-value terms, though the discounted payback stretches beyond four years.

Frequently Asked Questions

What does the NPV Calculator compute?

It computes net present value from a discount rate and a series of cash flows. It also returns IRR, payback period, discounted payback, profitability index, initial investment, total inflows, present value of inflows, and a discounted cash flow table.

 

How do I enter the initial investment?

Enter it in the Year 0 row as a negative number. The calculator treats that first amount as the initial investment and subtracts it from the present value of later inflows.

 

What discount rate should I use?

Use your required return or hurdle rate. The calculator allows any rate from 0% to 100%. Common ranges include 5% to 8% for low-risk projects, 8% to 12% for average business projects, and 15% to 30% for high-risk ventures.

 

Can the NPV Calculator find IRR automatically?

Yes. It searches for the discount rate that makes NPV equal zero. IRR appears as a percentage when the cash flows include at least one positive and one negative amount.

 

Why is IRR showing N/A?

IRR needs both positive and negative cash flows to solve. If every cash flow is positive, every cash flow is negative, or all amounts are zero, the calculator cannot find a meaningful internal rate of return.

 

What is the difference between payback and discounted payback?

Payback uses undiscounted cumulative cash flow. Discounted payback uses cumulative present value, so it accounts for the time value of money and is usually longer than ordinary payback.

 

How is profitability index calculated?

Profitability index equals the present value of positive cash flows divided by the absolute sum of negative cash flows. A result of 1.0 or higher generally supports acceptance, while below 1.0 suggests rejection.

 

Does a positive NPV always mean I should invest?

No. Positive NPV means the project clears the discount rate you entered. You should also consider risk, liquidity, strategic fit, tax effects, and whether the cash-flow estimates are realistic.

 

Can I use this NPV Calculator for real estate or equipment?

Yes. The tool includes presets for real estate, equipment, startups, solar panels, and a negative NPV example. You can also clear the rows and enter your own timeline.

 

What happens if my cash flows include more outflows later?

Later outflows should be entered as negative numbers. The calculator includes them in NPV, total outflows, profitability index, and the DCF table, so they reduce the project’s present value.

 

Is the NPV Calculator free and private?

Yes. It is free to use, and the calculations run in your browser. The amounts you enter are not sent to a server by the calculator itself.

 

How do I copy or share my NPV results?

Use the Copy button to place a text summary on your clipboard, or use Share to send the result through your device’s sharing options. Both actions use the current cash flows and computed metrics.

Financial Disclaimer

This NPV Calculator provides educational estimates only. It is not financial, investment, tax, legal, or accounting advice. Results depend entirely on the cash flows, discount rate, and currency you enter. Real projects involve risk, uncertainty, taxes, inflation, financing costs, and assumptions that this tool does not model. For capital budgeting, investment decisions, or professional valuations, consult a qualified financial advisor or analyst.

ADVERTISEMENT

ADVERTISEMENT