Skip to content

Payback Period Calculator: Discounted, NPV & IRR

Payback period calculator for uneven cash flows: simple and discounted payback, NPV, IRR and profitability index, with a year-by-year cash flow table.

By Updated Runs in your browser

Payback Period Calculator guide

Enter the upfront investment, your discount rate, and the cash each year brings in. Get simple payback, discounted payback, NPV, IRR, and a cumulative cash flow table that shows exactly when you break even.

What the payback period tells you, and what it hides

The payback period is how long an investment takes to return the cash you put in. Buy a $50,000 machine that saves $15,000 a year and it pays for itself in about three and a third years. Owners love it because it answers the question that keeps them up at night: when do I get my money back?

Its weakness is everything after that date. Simple payback ignores the time value of money and ignores all cash that arrives after breakeven. A project that pays back in two years and then dies can look better than one that pays back in three years and earns for fifteen. That is why this calculator shows simple payback, discounted payback, NPV, and IRR side by side.

Simple payback: the formula

With equal annual cash flows, simple payback = initial investment ÷ annual cash flow. With uneven flows, add them up year by year until the running total covers the investment, then interpolate inside the crossing year: payback = years before the crossing year + (amount still unrecovered ÷ cash flow in the crossing year).

Worked example: a $50,000 project

Cash flows are $12,000, $14,000, then $15,000 a year for four years. After year 1 you are $38,000 short, after year 2 $24,000 short, and after year 3 $9,000 short. Year 4 brings $15,000, so you need 9,000 ÷ 15,000 = 0.6 of that year. Simple payback: 3.6 years.

Now discount at 8 percent, the return you could earn elsewhere. Year 1's $12,000 is worth $12,000 ÷ 1.08 = $11,111.11 today. Year 4's $15,000 is worth $15,000 ÷ 1.08^4 = $11,025.45. The discounted running total is still $3,953.21 short after year 4. Year 5 adds $10,208.75 in present value, so discounted payback = 4 + 3,953.21 ÷ 10,208.75 = 4.39 years. Waiting costs money, and discounting shows how much.

Across all six years the discounted flows total $65,708.08. Subtract the $50,000 outlay and NPV is $15,708.08. The IRR, the discount rate that would make NPV exactly zero, is 17.40 percent, comfortably above the 8 percent hurdle. The profitability index is 1.31: every dollar invested returns $1.31 in present value.

NPV and IRR in plain English

Net present value (NPV) is the sum of every cash flow converted to today's dollars at your discount rate, minus the upfront cost. Positive NPV means the project earns more than your required return; negative means you would do better putting the money somewhere earning that rate. When two projects compete for the same money, the higher NPV usually wins.

Internal rate of return (IRR) is the annualized return the project delivers. Compare it with your cost of capital. IRR is intuitive but has traps: it assumes cash flows are reinvested at the IRR itself, and projects whose cash flows flip between positive and negative more than once can have more than one IRR. When NPV and IRR disagree on which project to pick, trust NPV.

Choosing a discount rate

Use the return you give up by choosing this project. For a small business that might be the interest rate on its line of credit, often 8 to 12 percent. For a company with investors it is the weighted average cost of capital. Riskier projects deserve a higher rate. A rule used by many owners: add 3 to 5 points to your borrowing rate for ordinary projects and more for anything unproven.

What is a good payback period? It depends on the asset's life. Equipment that lasts 10 years with a 3-year payback is excellent. Marketing campaigns and software tools should usually pay back within 12 months. Energy-efficiency upgrades like LED lighting often pay back in 1 to 3 years, rooftop solar in 6 to 10.

Mistakes to avoid

Using revenue instead of net cash flow. Count the cash the project adds after its own operating costs, maintenance, and taxes. Depreciation is not a cash cost, but the tax it saves is a cash benefit; IRS Publication 946 covers how business assets are depreciated.

Forgetting the end. Include salvage or resale value in the final year, and any shutdown or disposal cost.

Ranking by payback alone. Use payback as a risk screen (how long your cash is exposed), then pick among the survivors with NPV. For a single-period gain without timing, the ROI calculator is quicker; for a product's unit volume needed to cover fixed costs, use the break-even calculator.

How we calculate: sources

Frequently asked questions

How do you calculate the payback period?

With equal cash flows, divide the investment by annual cash flow. With uneven flows, add years until the cumulative total turns positive, then add the unrecovered amount ÷ that year's cash flow.

What is the discounted payback period?

The same calculation using cash flows discounted to present value: each year's flow ÷ (1 + rate)^year. It is always longer than simple payback when the rate is positive.

What is a good payback period?

It depends on how long the asset lasts. Software and marketing usually should pay back within 12 months; equipment in 2 to 5 years; solar panels often 6 to 10 years.

What is the difference between payback period and NPV?

Payback shows how fast money comes back but ignores anything after breakeven. NPV counts every cash flow in today's dollars, so it is the better guide for choosing between projects.

What does IRR mean?

The internal rate of return is the discount rate at which NPV equals zero, the project's effective annual return. Accept projects whose IRR beats your cost of capital.

What discount rate should I use?

Your cost of capital or the return you could earn elsewhere. Small businesses often use their borrowing rate plus a few points for risk, commonly 8 to 15%.

Is my project data saved online?

Everything runs in your browser. Nothing you enter is uploaded to a server or stored by us.