Net Present Value Calculator
Calculate NPV from an initial investment, discount rate, and periodic or dated cash flows, with IRR/XIRR, profitability index, and payback checks.
Calculator is for informational purposes only. Terms and Conditions
Periodic mode discounts equally spaced cash flows; dated mode uses actual day counts on a 365-day basis, matching the published XNPV convention.
Choose the cash-flow setup
Use equal periods for standard NPV or actual dates for irregularly timed cash flows.
Enter the investment and cash flows
The calculator treats the initial investment as a time-zero outflow and discounts each later cash flow to today.
Fields marked required must be completed. You may enter commas, negative values, decimals, or scientific notation.
Result
Net present value first, followed by complementary project-evaluation checks.
Result details
- Check—
Show calculation steps Review discount factors, present values, assumptions, and checks
- Enter valid values to see the complete calculation.
Discounted Cash Flow by Period
Compare the magnitude of each future cash flow after discounting it to present value.
- Enter valid values to populate the chart.
Method, Sources, and Assumptions
Calculation basis, timing conventions, limitations, and authoritative references.
Periodic NPV discounts equally spaced cash flows. Dated mode discounts each cash flow using its actual number of days from the valuation date on a 365-day basis.
- The initial investment is entered as a positive cost and treated as a negative time-zero cash flow.
- Periodic mode assumes equal spacing and uses an annual effective discount rate with time converted to years. Excel NPV instead expects a discount rate per cash-flow period.
- Dated mode uses actual calendar-day differences divided by 365, consistent with the published XNPV day-count convention.
- IRR/XIRR is supplementary; nonconventional cash flows can produce multiple roots or no useful root.
- NPV depends on forecast cash flows and the selected discount rate; verify those assumptions independently before making a financial decision.
Calculator guide
What Your NPV Result Means
NPV is the primary result because it measures value in today’s currency after accounting for timing. The calculator also reports IRR or XIRR, profitability index, simple payback, and discounted payback as supporting checks. Those metrics answer different questions and should not replace the NPV decision when cash flows or timing are complex.
NPV answers a specific question: after discounting every future inflow and outflow for timing and your required return, how much net value remains in today’s money? A positive NPV means the modeled cash flows exceed the return represented by the discount rate; a negative NPV means they fall short. That conclusion is only as reliable as the cash-flow forecast and discount-rate assumption behind it.
- Best for
- Capital projects, equipment decisions, investments, energy upgrades, and other multi-period cash-flow comparisons.
- Main output
- Net present value in the selected currency, measured at time zero.
- Key assumption
- The discount rate and cash flows must use a consistent economic basis and realistic timing.
How to Use the NPV Calculator
Use equal-period mode when cash flows occur at regular annual, semiannual, quarterly, or monthly intervals. Use specific-date mode when the actual payment dates are irregular and you need XNPV/XIRR timing.
-
Enter the annual discount rate
Enter the effective annual required return as a percent. For example, enter 8 for 8%. In periodic mode, the calculator applies that annual rate using time measured in years, so monthly, quarterly, and semiannual periods use fractional-year exponents.
-
Enter the initial investment as a positive cost
The calculator treats the Initial Investment field as a time-zero outflow automatically. If the project costs $100,000 today, enter 100000, not −100000.
-
Add the future cash-flow schedule
Use positive values for future net inflows such as savings, revenue, or salvage proceeds, and negative values for later costs such as maintenance, reinvestment, or decommissioning. Keep all monetary entries in the same currency.
-
Choose periodic timing or specific dates
For equal periods, select the matching cash-flow frequency. For irregular timing, select Specific Dates and enter the initial investment date plus a later date for each future cash flow. The dated calculation uses actual calendar-day differences divided by 365.
-
Read NPV first, then use the supporting metrics
Use NPV as the main value-at-time-zero result. IRR/XIRR, profitability index, and payback can add context, but they answer different questions and may become ambiguous when the cash-flow sequence changes sign more than once.
Net Present Value Formula: NPV and XNPV
NPV is a discounted-cash-flow method. Each cash flow is converted to its value at time zero, then the discounted values are added. The calculator uses one equation for equal-period schedules and an actual-date version for irregular schedules.
Periodic net present value
Plain language: start with the negative initial investment, discount each future cash flow using the annual rate and its time in years, then add the results.
For annual cash flows, \(t_y=t\). For semiannual, quarterly, and monthly cash flows, the calculator uses \(t/2\), \(t/4\), and \(t/12\), respectively. This means the entered rate remains an annual effective rate.
Equivalent notation: if the time-zero cash flow is already written as a negative value, NPV can also be written as \(\mathrm{NPV}=\sum_{t=0}^{n}CF_t/(1+r)^t\). The calculator keeps the initial investment separate so that cost can be entered as a positive amount.
Dated net present value (XNPV)
Plain language: discount each future cash flow according to the actual number of days between its payment date and the initial investment date.
Microsoft documents XNPV for schedules that are not necessarily periodic and discounts succeeding payments on a 365-day year. The calculator follows that date-spacing convention.
- \(C_0\)
- Initial investment at time zero. The calculator input is entered as a positive cost and then treated as a negative cash flow.
- \(CF_t\)
- Net cash flow in period \(t\). Positive values are inflows; negative values are future outflows.
- \(r\)
- Annual effective discount rate in decimal form. An 8% input corresponds to \(r=0.08\).
- \(t_y\)
- Elapsed time in years for a periodic cash flow.
- \(d_0\)
- Initial investment date in specific-date mode.
- \(d_i\)
- Date of the \(i\)-th future cash flow in specific-date mode.
Worked NPV Example
Consider an equipment or efficiency project that requires $100,000 today and is expected to produce increasing annual net cash flows for five years. This example matches the calculator’s default periodic example state.
Substitute the cash flows
Each future amount is discounted separately because money received later has less present value at a positive discount rate.
Result
$36,679.88 NPV
At an 8% required return, the modeled future cash flows have a present value of $136,679.88. After subtracting the $100,000 time-zero investment, $36,679.88 of positive net present value remains.
| Time | Cash Flow | Discount Factor | Present Value | Cumulative PV |
|---|---|---|---|---|
| Year 0 | −$100,000.00 | 1.000000 | −$100,000.00 | −$100,000.00 |
| Year 1 | $25,000.00 | 0.9259 | $23,148.15 | −$76,851.85 |
| Year 2 | $30,000.00 | 0.8573 | $25,720.16 | −$51,131.69 |
| Year 3 | $35,000.00 | 0.7938 | $27,784.13 | −$23,347.56 |
| Year 4 | $40,000.00 | 0.7350 | $29,401.19 | $6,053.64 |
| Year 5 | $45,000.00 | 0.6806 | $30,626.24 | $36,679.88 |
How to Interpret NPV, IRR, and Payback
Read the NPV first because it expresses the modeled value created or lost at your chosen required return. Then use the calculator’s other metrics to answer separate questions about return, investment efficiency, and recovery time.
| NPV Result | What It Means at the Entered Discount Rate |
|---|---|
| NPV > 0 | The discounted net cash flows exceed the initial investment; the modeled project earns more than the selected required return. |
| NPV ≈ 0 | The modeled return is approximately equal to the selected discount rate. |
| NPV < 0 | The discounted net cash flows do not recover the initial investment at the selected required return. |
What Is a Good NPV?
There is no universal dollar amount that counts as a “good” NPV. For a stand-alone project, an NPV greater than zero means the modeled project exceeds the required return represented by the discount rate. When comparing alternatives, project size, timing, life, risk, capital constraints, and whether the projects are mutually exclusive also matter.
For example, a $30,000 NPV on a $100,000 project and a $35,000 NPV on a $10 million project do not represent the same investment efficiency. That is one reason the calculator also reports profitability index, but NPV remains the clearest measure of modeled value creation at the chosen rate.
NPV measures present-value surplus
A $36,679.88 NPV does not mean the project earns $36,679.88 of nominal accounting profit. It means the entire modeled cash-flow stream is worth $36,679.88 more than the time-zero investment after applying the 8% discount rate.
The discount rate can change the decision
Holding the example cash flows fixed, increasing the annual discount rate reduces NPV: about $44,981.84 at 6%, $36,679.88 at 8%, $29,078.68 at 10%, and $22,104.49 at 12%.
Check timing and signs first
If NPV looks unexpectedly large or negative, verify that the initial investment was entered as a positive cost, later outflows have negative signs, the frequency matches the schedule, and irregular payments were entered in Specific Dates mode.
Two Fast NPV Sanity Checks
At a 0% discount rate, NPV must equal the arithmetic sum of all cash flows. For the worked example, −$100,000 + $25,000 + $30,000 + $35,000 + $40,000 + $45,000 = $75,000. If a zero-rate result does not match the cash-flow sum, check the signs, timing, and entered values.
Timing also matters even when the nominal cash flow is identical. At an 8% annual rate, $50,000 received in Year 1 has a present value of about $46,296.30, while the same $50,000 received in Year 5 is worth about $34,029.16 at time zero. That difference is why Specific Dates mode is useful when real payment dates are irregular.
What the supporting results add
IRR in this calculator is reported as the annual effective rate that makes the calculator’s periodic NPV equal zero. XIRR is the corresponding annual rate for actual dated cash flows. Profitability index compares the present value of future net cash flows with the initial investment. Simple payback ignores discounting, while discounted payback uses discounted cash flows. Excel IRR returns a rate per cash-flow period, so monthly or quarterly Excel IRR values must be annualized before comparing them directly with this calculator.
NPV vs. XNPV, IRR vs. XIRR, and Excel
The correct method depends on cash-flow timing. Regular intervals use periodic NPV and IRR. Irregular payment dates use XNPV and XIRR so the elapsed time between cash flows is represented directly.
| Cash-Flow Timing | Present-Value Metric | Return Metric | Use When |
|---|---|---|---|
| Equal intervals | NPV | IRR | Cash flows occur at regular monthly, quarterly, semiannual, or annual spacing. |
| Actual dates | XNPV | XIRR | Payments occur on irregular calendar dates and the exact timing matters. |
NPV vs. IRR
NPV answers “how much present value remains at my required return?” IRR answers “what annual effective rate makes NPV equal zero?” Microsoft notes that IRR is closely related to NPV, but nonconventional cash flows can produce more than one acceptable IRR or no useful IRR at all.
XNPV vs. XIRR
XNPV applies a chosen annual discount rate to actual dated cash flows. XIRR instead solves for the annual rate that makes XNPV equal zero. Both require date information, and Excel’s XNPV/XIRR conventions use the first date as the start of the schedule.
NPV vs. Present Value
Present value discounts one or more future amounts to time zero. Net present value includes the complete investment cash-flow stream, including the initial outlay, so the result is the net surplus or shortfall after discounting.
NPV vs. ROI
NPV is a currency value that explicitly reflects cash-flow timing and a required return. ROI is usually a percentage return measure and may ignore exact cash-flow timing. Use NPV for time-value-of-money decisions and ROI when a simpler return ratio is the main comparison.
How this differs from Excel’s NPV function
The calculator’s periodic mode accepts an annual effective discount rate and converts monthly, quarterly, or semiannual timing into fractions of a year. Excel’s NPV(rate, values) function instead expects a discount rate for each cash-flow period. For example, if you reproduce a monthly case in Excel, first convert the annual effective rate to the equivalent monthly rate rather than entering the annual rate directly.
Here \(m\) is the number of periods per year: 12 for monthly, 4 for quarterly, and 2 for semiannual cash flows.
Excel formulas for a manual cross-check
For regular end-of-period cash flows, Excel’s NPV function discounts the values passed to it as period-end cash flows. A separate time-zero investment is normally added outside that function:
=NPV(period_rate, future_cash_flows) + initial_cash_flowFor the annual worked example, if cells B2:B6 contain 25000, 30000, 35000, 40000, and 45000, a direct Excel check is =NPV(8%,B2:B6)-100000, which returns approximately $36,679.88.
For actual dates, use the dated functions:
=XNPV(annual_rate, values, dates)
=XIRR(values, dates)For XNPV/XIRR, include the time-zero cash flow as a negative value associated with the starting date. Microsoft states that later dates must be after the first date; they may otherwise appear in any order.
Common NPV Mistakes
Most bad NPV answers come from timing, sign, rate, or cash-flow assumptions rather than from the discounting arithmetic itself.
Using the wrong sign
Enter the calculator’s Initial Investment as a positive cost because the tool converts it to a time-zero outflow. In the future cash-flow rows, use positive values for net inflows and negative values for later costs.
Mixing annual rates with period rates
The calculator accepts an annual effective rate. Excel NPV accepts a rate per cash-flow period. Do not copy the same percentage between the two without checking the rate basis.
Using periodic NPV for irregular dates
A March payment, an October payment, and a February payment are not equally spaced annual periods. Use Specific Dates mode so actual timing is reflected through XNPV/XIRR.
Using revenue instead of net incremental cash flow
NPV should reflect cash attributable to the decision. Include relevant incremental operating costs, maintenance, future capital spending, taxes when modeled, working-capital changes, and end-of-project cash flows rather than gross revenue alone.
Forgetting salvage or decommissioning cash flow
If an asset can be sold at the end of the study period, include the net proceeds in the final cash flow. If closure, removal, or restoration creates a future cost, include that as a negative cash flow.
Mixing real and nominal assumptions
If cash flows include expected inflation, use a nominal discount rate on the same basis. If cash flows are expressed in constant purchasing-power terms, use a consistent real rate. Mixing the two changes present value.
Treating IRR as always unique
A cash-flow sequence that changes sign more than once can have multiple IRR roots. The calculator warns when it detects this pattern. In that case, rely on NPV at the required return rather than forcing one IRR interpretation.
Assuming positive NPV proves the forecast
Positive NPV only says the entered cash flows beat the entered discount rate. It does not verify demand, equipment performance, operating savings, financing terms, tax treatment, or project execution.
How to Choose a Discount Rate for NPV
The discount rate should represent the annual return required for the risk and economic basis of the cash flows. There is no universal default rate: corporate projects may use an approved hurdle rate or cost-of-capital basis, engineering-economy studies may use a minimum attractive rate of return, and investment comparisons may use an opportunity-cost or required-return benchmark.
Discount rate selection
Depending on the use case, the rate may be a project hurdle rate, minimum attractive rate of return, opportunity cost, or a cost-of-capital measure. There is no universal percentage that is correct for every project.
Cash-flow forecast quality
NPV is highly sensitive to amounts that occur repeatedly or far into the future. Use net incremental cash flows and document the assumptions behind volume, price, energy savings, maintenance, taxes, residual value, and project life when they are material.
Timing convention
Periodic mode treats cash flows as equally spaced. Specific Dates mode uses the entered calendar dates. If the real timing differs from the selected model, the present value will differ too.
Payback is not NPV
Payback reports recovery time, not total present-value creation. A project can pay back quickly but have a lower NPV than a longer-lived alternative, or have a positive NPV without reaching discounted payback inside the entered horizon.
Profitability index has a narrower role
This calculator reports profitability index as the present value of future net cash flows divided by the initial investment. That convention can help normalize projects of different initial sizes. When later negative cash flows are significant, compare the underlying NPV and cash-flow schedule rather than relying on profitability index alone.
IRR/XIRR is a numerical root
The calculator searches for rates where NPV or XNPV equals zero. Nonconventional cash flows can have multiple roots, and some schedules have no useful root even though NPV at a chosen discount rate is still well defined.
A practical discount-rate sensitivity check
For the worked example, holding every cash flow fixed while changing only the annual discount rate gives the following results. The table shows why a project close to the decision boundary should not be judged at one rate without understanding the uncertainty around that rate.
| Annual Discount Rate | NPV |
|---|---|
| 6% | $44,981.84 |
| 8% | $36,679.88 |
| 10% | $29,078.68 |
| 12% | $22,104.49 |
Sources and Calculation Checks
The calculator guide uses standard discounted-cash-flow relationships and Microsoft’s published NPV/XNPV and IRR/XIRR timing conventions as reference points. The worked example was recomputed by discounting each cash flow separately and summing the present values.
- Microsoft Support — Calculate NPV and IRR in Excel — supports the relationship between NPV and IRR and explains when to use NPV, XNPV, IRR, XIRR, and MIRR.
- Microsoft Support — XNPV function — supports irregular-date NPV, the 365-day discounting basis, and the dated cash-flow requirements.
- Microsoft Support — IRR function — supports regular-interval IRR, its relationship to zero NPV, and the fact that Excel IRR returns a rate per cash-flow period.
- Microsoft Support — XIRR function — supports irregular-date XIRR and its relationship to XNPV = 0.
Calculator-specific controls and outputs in this guide are based on the current V3 calculator files: annual effective discount rate, annual/semiannual/quarterly/monthly periodic timing, specific-date mode, NPV/XNPV, IRR/XIRR, profitability index, and simple and discounted payback.
Net Present Value FAQ
These questions address the result, rate basis, timing, and comparison issues that most often cause NPV calculations to disagree.
What does a positive NPV mean?
A positive NPV means the present value of the modeled future net cash flows exceeds the initial investment at the discount rate you entered. It indicates value above that required return, not guaranteed accounting profit or a guarantee that the cash-flow forecast will occur.
What is a good NPV?
There is no universal dollar amount that is “good.” For an independent project, a positive NPV indicates that the modeled return exceeds the selected hurdle rate. When comparing projects, also consider investment size, project life, risk, capital constraints, and whether the alternatives are mutually exclusive.
What discount rate should I use for NPV?
Use a rate that represents the required return and economic basis appropriate to the cash flows. Depending on the analysis, that may be a hurdle rate, minimum attractive rate of return, opportunity cost, or cost-of-capital measure. There is no single discount rate that is correct for every project.
Why can the calculator show more than one IRR?
When the cash-flow sequence changes sign more than once, the NPV equation can cross zero at multiple discount rates. That produces multiple numerical IRR roots. In that case, NPV evaluated at the required return is generally easier to interpret than selecting one IRR arbitrarily.
Why is my Excel NPV different from this calculator?
First check the rate basis and time-zero cash flow. This calculator’s periodic mode uses an annual effective rate and fractional-year timing. Excel NPV expects a discount rate per cash-flow period and treats values supplied to NPV as period-end flows; a separate time-zero investment is normally added outside the NPV function.
Can NPV use negative future cash flows?
Yes. Future costs such as maintenance, reinvestment, overhaul, working-capital increases, or decommissioning can be entered as negative cash flows. Their timing matters because the calculator discounts them just like positive future cash flows.
Can the NPV discount rate be negative?
Yes. The calculator permits discount rates greater than −100% because the NPV equation remains mathematically defined in that range. Negative rates are unusual in many capital-budgeting applications, so confirm that the economic assumptions justify using one before interpreting the result.
Is NPV the same as present worth?
They use the same discounting principle, but the terms are often used differently. Present worth can refer to the time-zero equivalent of one or more future amounts, while NPV emphasizes the net sum of all discounted inflows and outflows, including the initial investment.