Payback Period Calculator
Payback Period Calculator
Simple & Discounted Payback Analysis
| Year | Cash Flow | Cumulative CF | Discounted CF | Cum. Discounted CF |
|---|
A Payback Period Calculator estimates how long an investment takes to recover its original cost from the net cash inflows it generates. It is commonly used to evaluate business projects, machinery purchases, solar panel installations, and other investments that require an upfront expense.
The payback period is especially useful when cash recovery and liquidity are important. However, it should not be the only measure used to approve an investment because it does not necessarily show how profitable the project will be over its entire lifetime.
What Is the Payback Period?
The payback period is the amount of time required for the cumulative net cash inflows from an investment to equal its initial cost.
For example, suppose a company spends $20,000 on equipment that generates $5,000 in net cash inflows each year. If those annual inflows remain constant, the company will recover its initial investment in four years.
A shorter payback period generally means that the initial investment is recovered sooner. This can be useful for businesses concerned about liquidity, uncertain demand, or equipment becoming obsolete.
A payback calculator can help you:
- Estimate when an investment will recover its initial cost.
- Compare projects based on the speed of cost recovery.
- Evaluate equipment purchases and operational upgrades.
- Assess projects with regular or changing annual cash flows.
- Determine whether an investment meets a company's payback deadline.
The calculation should use net cash inflows attributable to the investment rather than accounting profit alone.
Payback Period Formula
The formula depends on whether the investment produces equal cash inflows each period or different amounts over time.
1. Equal annual cash flows
When an investment generates the same net cash inflow every year, use:
[
\text{Payback Period}=
\frac{\text{Initial Investment}}
{\text{Annual Net Cash Inflow}}
]
For example, an investment of $30,000 that generates $10,000 per year has a payback period of:
[
\frac{$30,000}{$10,000}=3\text{ years}
]
This shortcut is appropriate only when the annual net cash inflows are constant and the investment is recovered through those inflows.
2. Unequal annual cash flows
When annual cash flows vary, calculate the cumulative cash flow for each period until the initial investment is recovered.
If recovery occurs partway through a year, the estimated payback period is:
[
\begin{aligned}
\text{Payback Period}={}&
\text{Full Years Before Recovery}\
&+\frac{\text{Unrecovered Investment}}{\text{Cash Inflow During Recovery Year}}
\end{aligned}
]
This fractional-year method assumes that cash flows arrive evenly throughout the recovery year. If cash flows occur on specific dates or in irregular instalments, a date-based calculation may be more accurate.
How to Calculate the Payback Period: Worked Example
Suppose a business invests $25,000 in a new machine. The machine is expected to produce the following net cash inflows:
| Year | Annual cash inflow | Cumulative cash inflow |
|---|---|---|
| 0 | −$25,000 | −$25,000 |
| 1 | $7,000 | −$18,000 |
| 2 | $8,000 | −$10,000 |
| 3 | $9,000 | −$1,000 |
| 4 | $6,000 | $5,000 |
At the end of Year 3, the business has recovered $24,000 of its $25,000 investment. It still needs to recover $1,000.
During Year 4, the machine is expected to generate $6,000 in net cash inflows. The fraction of Year 4 required to recover the remaining amount is:
[
\frac{$1,000}{$6,000}=0.1667\text{ years}
]
Therefore:
[
\text{Payback Period}=3+0.1667
]
The estimated payback period is 3.17 years, or approximately 3 years and 2 months.
This result assumes that the Year 4 cash inflow arrives evenly over the year. If the full $6,000 is received only at year-end, the investment is not actually recovered until the end of Year 4.
Simple Payback vs. Discounted Payback Period
The simple payback period measures how quickly the initial investment is recovered without adjusting future cash flows for the time value of money.
The discounted payback period takes an additional step: it discounts each future cash flow to its present value before calculating when the investment is recovered.
The present value of a future cash flow is:
[
PV_t=\frac{CF_t}{(1+r)^t}
]
Where:
- (PV_t) = present value of the cash flow.
- (CF_t) = cash flow in period (t).
- (r) = discount rate per period.
- (t) = number of periods into the future.
For example, $10,000 received one year from now has a present value of approximately $9,091 at a 10% annual discount rate.
Because discounted cash flows are worth less than their undiscounted amounts when the discount rate is positive, discounted payback will generally be longer than simple payback for the same project with positive future cash flows.
Use simple payback when you need a quick estimate of the recovery timeline. Discounted payback is more informative when the timing and required return on future cash flows matter.
Payback Period vs. ROI, NPV, and IRR
| Metric | Main question answered | Key limitation |
|---|---|---|
| Payback period | How long until the initial investment is recovered? | Does not measure value created over the full project life |
| Return on investment (ROI) | How large is the gain relative to the investment under a chosen definition? | A basic ROI calculation may ignore timing |
| Net present value (NPV) | How much value does the investment create in today's money? | Depends on cash flow estimates and the discount rate |
| Internal rate of return (IRR) | What discount rate makes the project's NPV equal to zero? | Can be difficult to interpret for unusual cash flow patterns |
Payback is most useful for understanding recovery speed. NPV is generally more informative when the objective is to assess the financial value created by a project over its full life.
There is no universal ideal. A suitable period depends on the project type, expected useful life, business risk, financing needs, and the organisation's investment policy. A company may require a short payback for uncertain projects and allow a longer period for durable assets.
Yes. If the initial investment is $6,000 and the project generates $12,000 in annual net cash inflows evenly throughout the year, the simple payback period is 0.5 years, or approximately six months.
If cumulative net cash inflows never equal the initial investment within the forecast period, the project has no payback within that period. The investment may eventually recover its cost if cash inflows continue, but the available forecast does not establish that outcome.
Use net cash inflows attributable to the investment. Revenue alone usually overstates the cash available for recovery because operating expenses and other cash outflows must also be considered. Accounting profit may also differ from cash flow because of non-cash expenses and the timing of payments.
Not necessarily. A short payback period can be attractive when liquidity is important, but it does not account for all cash flows after recovery. A project with a longer payback may create more value over its full life. Consider NPV, risk, and strategic objectives as well.
For equal annual cash flows, divide the initial investment by the annual net cash inflow. For uneven cash flows, create a table with each period's net cash flow and cumulative cash flow. Identify the last period with an unrecovered balance, then divide the remaining balance by the cash inflow in the recovery period if a fractional-year estimate is appropriate.