CalcTrace

Payback Period Calculator

Work out how long an investment takes to earn back what it cost. Enter the upfront cost and the cash it brings in each year, as one even figure or year by year, and set a discount rate to see the discounted payback beside the simple one.

Last updated .

The investment

Everything paid out at the start, entered as a positive amount.

Yearly cash flows are

Line 1 is year 1, line 2 is year 2 and so on, up to 100 years. Use a minus sign for a year in which more cash goes out than comes in.

Used only for the discounted payback and net present value. It is your own assumption about what the money could earn elsewhere. Enter 0 to leave future cash undiscounted.

Result

Simple payback period

–

–Simple payback
–Discounted payback
–Net cash over all years
–Net present value

Cumulative cash flow

YearCash flowRunning totalDiscountedDiscounted total

Shaded rows are the years in which each running total first reaches zero. Year 0 is the upfront cost. Figures are rounded to the nearest dollar.

Show the working

    How the payback period is worked out

    The payback period is the time an investment needs to return the cash that was put into it. When the same amount comes in every year, it is a single division:

    Payback period = upfront cost ÷ net cash flow per year

    When the yearly amounts differ, keep a running total. Start at minus the upfront cost and add each year’s net cash flow in turn. The payback falls in the first year the running total reaches zero or better, and the part of that year needed is found by assuming the cash arrives evenly through it:

    Payback period = A + B ÷ C

    Net cash flow means cash in less cash out for the year: extra revenue or savings, less running costs. It is not accounting profit, which includes non-cash items such as depreciation.

    Discounted payback

    Simple payback counts a dollar received in year 5 as equal to a dollar spent today. Discounted payback first converts every future cash flow to its value today, then runs the same test on the discounted figures:

    Discounted cash flow of year t = cash flow of year t ÷ (1 + r)t

    r is the discount rate per year as a decimal and t is the year number. Each flow is treated as arriving at the end of its year. Because every discounted flow is smaller than the original whenever r is above zero, discounted payback is always longer than simple payback, and it may never arrive at all. At a rate of 0% the two are identical.

    Worked example

    A machine costs $50,000 and is expected to bring in net cash of $12,000, $15,000, $18,000, $20,000 and $20,000 over five years. The discount rate is 8%.

    1. Running total. −50,000 + 12,000 = −38,000 after year 1; −23,000 after year 2; −5,000 after year 3; +15,000 after year 4.
    2. Find the year. The total turns positive in year 4, so A = 3, B = $5,000 and C = $20,000.
    3. Fraction of the final year. 5,000 ÷ 20,000 = 0.25.
    4. Simple payback. 3 + 0.25 = 3.25 years, or 3 years and 3 months.
    5. Discount each flow. 12,000 ÷ 1.08 = 11,111.11; 15,000 ÷ 1.082 = 12,860.08; 18,000 ÷ 1.083 = 14,288.98; 20,000 ÷ 1.084 = 14,700.60; 20,000 ÷ 1.085 = 13,611.66.
    6. Discounted running total. −38,888.89, −26,028.81, −11,739.83, then +2,960.77 after year 4.
    7. Discounted payback. 3 + 11,739.83 ÷ 14,700.60 = 3 + 0.80 = 3.80 years.

    The discounted running total after the last year, $16,572.43, is the net present value of the whole project at 8%. With an even $16,000 a year instead, the simple payback would be 50,000 ÷ 16,000 = 3.125 years and the discounted payback 3.75 years.

    What payback ignores

    Everything after the payback point

    Payback stops counting the moment the cost is recovered. Compare two $50,000 projects. Project A returns $20,000, $20,000 and $10,000, then nothing. Project B returns $10,000 and then $20,000 a year for four years. Both pay back in exactly 3 years. Yet A ends with a net cash gain of $0 and B with $40,000, and at 8% their net present values are −$6,396.38 and +$20,594.94. The payback period alone cannot tell them apart.

    The timing of cash inside the payback period

    Simple payback treats $20,000 in year 1 the same as $20,000 in year 3. Discounted payback corrects this, but only up to the payback point.

    Size and profitability

    A payback period says nothing about how much is made, only how soon the outlay comes back. It is a measure of how long money is exposed, which is why it is normally read beside net present value or the internal rate of return and not in place of them.

    Edge cases and common mistakes

    The cost is never recovered. If the cash flows add up to less than the upfront cost, there is no payback period, and the calculator shows how much is still outstanding. The total dips again later. A project with a large late cost, such as a refit or clean-up, can pass zero and then fall back below it. The calculator reports the first crossing and warns when this happens. The even-flow assumption. The fraction of the final year assumes cash arrives steadily across that year. For a seasonal business the true date can be earlier or later. Mixing before-tax and after-tax figures. Use the same basis for the cost and for every year’s cash flow. This page applies no tax or depreciation rules of any country.