CodePackr Finance / Business Finance / NPV Calculator

NPV Calculator

Calculate Net Present Value (NPV), Profitability Index (PI), and discounted cash flow paybacks for capital investments.

Client-Side Execution & Privacy Guarantee

Calculations run locally in your web browser. The amounts, rates, and other figures you enter are not sent to our servers. This calculator is for educational estimates only and is not personalized financial advice.

The Net Present Value (NPV) Calculator is a capital budgeting tool that helps you determine the present value of an investment's future cash flows compared to its initial cost. By applying a discount rate that reflects the time value of money and the risk of the project, this tool discounts future cash inflows and outflows back to their value in today's terms.

Codepackr Finance provides this tool for educational purposes to help you evaluate whether a project is projected to generate value. Keep in mind that these results are estimates based on your projected cash flows and chosen discount rate; they do not constitute financial advice. Always consult a qualified financial adviser or perform detailed due diligence before committing to a capital investment. This content is for informational purposes only and is not financial advice.

Understanding Net Present Value

Net Present Value is the difference between the present value of cash inflows and the present value of cash outflows over a period of time. A positive NPV indicates that the projected earnings generated by a project or investment—in present dollars—exceed the anticipated costs. Generally, an investment with a positive NPV will be profitable, and one with a negative NPV will result in a net loss.

The core principle behind NPV is the time value of money, which states that a dollar today is worth more than a dollar tomorrow because of its potential earning capacity. The discount rate used in the calculation represents the rate of return that could be earned on an investment in the financial markets with similar risk.

The Role of the Discount Rate

The discount rate is a critical input in NPV calculations. It often represents a company's Weighted Average Cost of Capital (WACC), a required rate of return, or the interest rate associated with borrowing funds for the project. Choosing an appropriate discount rate is essential, as a higher rate will significantly reduce the present value of future cash flows.

If the discount rate is set too low, a project might appear artificially profitable. Conversely, an overly high discount rate might cause you to reject a potentially viable investment. It is common practice to calculate NPV using several different discount rates to understand the project's sensitivity to changes in the cost of capital.

Profitability Index and Payback Period

In addition to NPV, this calculator provides the Profitability Index (PI), which is the ratio of the present value of future cash flows to the initial investment. A PI greater than 1 indicates a good investment. This metric is particularly useful when comparing multiple projects with different initial costs.

The tool also estimates the discounted payback period—the time it takes for the project to break even on a discounted basis. Unlike a simple payback period, the discounted version accounts for the time value of money, providing a more conservative and realistic timeline for recovering the initial outlay.

When to use this calculator

  • Evaluating new business ventures or product lines.
  • Comparing mutually exclusive capital projects.
  • Assessing the viability of purchasing new equipment or machinery.
  • Analyzing long-term real estate investments.
  • Determining the profitability of a proposed marketing campaign.

How to use the NPV Calculator

  1. Enter the initial investment amount (this is typically a negative number representing cash outflow).
  2. Input the expected discount rate (often your required rate of return or WACC).
  3. Specify the number of periods (years or months) for the cash flows.
  4. Enter the projected cash flow for each period. Use positive numbers for inflows and negative numbers for outflows.
  5. Review the calculated Net Present Value (NPV).
  6. Check the Profitability Index (PI) and discounted payback period for additional context.
  7. Adjust the cash flows or discount rate to run different scenarios.

Worked examples

New Equipment Purchase

Input

Initial Investment: -₹1,00,000, Discount Rate: 10%, Year 1: ₹30,000, Year 2: ₹40,000, Year 3: ₹50,000

Output

NPV: ₹-2,103.68, PI: 0.98

With a 10% discount rate, the present value of the cash inflows (₹97,896.32) is less than the initial cost, resulting in a negative NPV. The project should likely be rejected at this required rate of return.

Software Development Project

Input

Initial Investment: -₹5,00,000, Discount Rate: 12%, Year 1: ₹2,00,000, Year 2: ₹2,50,000, Year 3: ₹3,00000

Output

NPV: ₹91,404 (year-end discounting). PI: 1.18.

Discounting ₹2,00,000, ₹2,50,000 and ₹3,00,000 at 12% at each year-end gives a present value of about ₹5,91,404, so NPV is ₹91,404 and the profitability index is about 1.18. Mid-year conventions produce a slightly different figure.

Common mistakes and tips

  • Be realistic when estimating future cash flows; overly optimistic projections lead to a misleadingly high NPV.
  • Remember that cash flow estimates further in the future are less certain and carry higher risk.
  • Ensure your discount rate accurately reflects the risk of the specific project, not just the company's overall borrowing rate.
  • Include the salvage value of equipment at the end of the project in your final year's cash flow.
  • Do not use these results as definitive financial advice; always verify inputs and assumptions with a financial professional.

Frequently asked questions

What does a negative NPV mean?

A negative NPV indicates that the present value of the expected cash inflows is less than the initial investment, meaning the project is expected to generate a return lower than your specified discount rate and result in a net loss in present-day terms.

How is NPV different from IRR?

NPV calculates the absolute dollar value a project is expected to add, using a specific discount rate. Internal Rate of Return (IRR) is the specific discount rate that makes the NPV of a project equal to zero. NPV provides a magnitude of value, while IRR provides a percentage return.

What discount rate should I use?

The discount rate often represents the company's Weighted Average Cost of Capital (WACC) or a minimum acceptable rate of return (hurdle rate). For riskier projects, a higher discount rate is usually applied.

Can I use NPV for personal investments?

Yes, NPV can evaluate personal investments like real estate or major purchases. The discount rate in personal finance might be your opportunity cost—the return you could earn by investing that money elsewhere, like in an index fund.

Why is the time value of money important in NPV?

Because of inflation and the potential to earn interest, money available now is worth more than the same amount in the future. NPV discounts future cash flows to account for this, allowing for an apples-to-apples comparison with the initial upfront cost.

Related Business Finance Calculators

  • IRR Calculator — Compute Internal Rate of Return (IRR), hurdle rate spreads, and NPV sensitivity curves for multi-year cash flows.
  • Break-Even Calculator — Determine unit and revenue break-even thresholds, contribution margin ratios, and margin of safety buffers.
  • Business Valuation Calculator — Estimate enterprise and equity fair market values across conservative, base, and optimistic multiples for Revenue, EBITDA, and SDE.
  • DCF Valuation Calculator — Model discounted cash flows (DCF), forecast free cash flows, terminal values via Gordon Growth and exit multiples, and equity value per share.
  • WACC Calculator (Cost of Capital) — Calculate Weighted Average Cost of Capital (WACC), CAPM cost of equity, after-tax cost of debt, and interest tax shield benefits.
  • Startup Valuation Calculator — Triangulate pre-revenue and seed-stage startup valuations using Dave Berkus, Payne Scorecard, and Venture Capital (VC) methods.
  • Burn Rate & Runway Calculator — Calculate gross burn, net burn, cash runway in months, zero cash dates, and Paul Graham Default Alive status for startups.

See all Business Finance calculators →