SuperDevTools

NPV and IRR Calculator

Project A

Cash flows (money in minus money out for each period)

    Paste a column or a row copied from a spreadsheet: the values spread across the periods. Pasted into “Initial investment”, a full row fills the investment, then the cash flows. Enter money going out as a negative number.

    Convention: the initial investment is paid at the start (period 0) and each cash flow arrives at the end of its period. In monthly mode, the yearly rate is converted to the equivalent monthly rate.

    Indicative calculation based on the cash flows you enter. This is not investment advice: future cash flows are estimates and the discount rate is a choice.

    NPV profile by discount rate

    Discounted and cumulative cash flows

    Does this investment pay for itself?

    A dollar received in three years is worth less than a dollar today. Net present value (NPV) converts every future cash flow into today's money and subtracts what you invest. The internal rate of return (IRR) is the rate at which that NPV equals zero. This calculator also gives the profitability index, the simple and discounted payback periods and the modified IRR (MIRR). Use it to weigh new equipment, a delivery van, a solar installation or a small business venture.

    How to use it

    1. Pick the “Cash flow frequency”: yearly or monthly.
    2. Enter the “Initial investment”, then one cash flow per period (money in minus money out). Later spending goes in as a negative number. You can paste a column copied from a spreadsheet in one go.
    3. Set the “Discount rate (% per year)” and the “Reinvestment rate for MIRR”.
    4. Tick “Compare with a second project” to see two projects side by side.

    The formulas

    • NPV: NPV = −I0 + Σ CFt ÷ (1 + r)^t, where I0 is the investment, CFt the cash flow in year t and r the discount rate.
    • IRR: the rate that makes NPV equal 0. There is no direct formula, so the tool scans a wide range of rates and refines each root with bisection and Newton's method.
    • Profitability index: PI = 1 + NPV ÷ I0, the present value returned per dollar invested.
    • MIRR: positive cash flows grow to the end at the reinvestment rate, negative ones are discounted to today at the discount rate.

    Worked example

    A contractor spends $10,000 on a machine expected to bring in $3,000, $4,000, $4,000 and $3,000 over four years. At 8%, those cash flows are worth $2,777.78, $3,429.36, $3,175.33 and $2,205.09 today. The NPV is $1,587.55 and the IRR 14.90%. The profitability index is 1.1588. After two years, $3,000 is still missing, covered by three quarters of year three: a payback period of 2.75 years, or 3.28 years discounted. With reinvestment at 8%, the MIRR drops to 12.05%.

    Decision rules

    A positive NPV means the project earns more than your chosen rate; a negative NPV means it earns less. Compare the IRR with your cost of capital or the interest rate on your loan. For two mutually exclusive projects, the two rules can disagree. Project B, preloaded in the tool ($5,000 then $2,500, $2,000, $1,500 and $1,000), has an IRR of 17.80% but an NPV of only $955.27. The two NPV curves cross at 12.74%: below that rate, project A creates more value. IRR ignores scale; NPV measures the gain in dollars.

    Limits

    When cash flows change sign more than once, a project can have several IRRs or none. With −100, +230 and −132, NPV is zero at both 10% and 20%: the tool lists both rates with a warning. Results depend on your estimates and the rate you pick, and taxes or inflation only count if you build them into the cash flows. This is a calculator, not investment advice.

    Frequently asked questions

    Why does a spreadsheet NPV function give a different number?

    It discounts from the very first value in the range, so an investment placed there gets divided by 1.08. Feed it the year 1 to 4 cash flows, then subtract the $10,000 separately: you get $1,587.55.

    Which discount rate should I use?

    Your borrowing rate, or the return you require from the money. At 5%, the example's NPV rises to $2,408.72; at 15%, it turns negative (−$21.41).

    Can I use monthly cash flows?

    Choose “Monthly”. The yearly rate is converted to the equivalent monthly rate: 12.6825% a year gives 1% a month. $1,000 that returns $100 a month for 12 months then has an NPV of $125.51.

    Are my figures saved?

    Everything is calculated in your browser. Nothing is kept unless you tick “Remember my entries on this device”.