Work out the payback, including the awkward answer.
Five inputs, one arithmetic chain. When monthly net savings are zero or negative, the worksheet returns no payback and explains why — it does not divide by zero and it does not round the answer into optimism.
Everything here runs in your browser. No value is submitted, stored or transmitted. The pre-filled figures are an illustration, not a benchmark.
Nothing is sent or stored. The arithmetic runs in this page.
$506
- Gross value of saved hours
- $1,260
- Cash actually converted (60%)
- $756
- Less recurring cost
- −$250
23.7 months
$12,000 ÷ $506 per month
$6,072
−$5,928
Simple payback is arithmetic, not a forecast. It ignores financing, tax, depreciation, ramp-up and everything that happens after the payback month.
How the numbers are produced
① gross = 30 h × $42.00 = $1,260
② net = $1,260 × 60% − $250 = $506
③ payback = $12,000 ÷ $506 = 23.7 months
Rounding is applied for display only; the result panel uses unrounded values.
Sensitivity: the conversion share
Holding every other input still, this is what happens when the share of saved hours that becomes cash changes. It is usually the least certain number in the calculation.
| Conversion | Net cash / month | Payback |
|---|---|---|
| 0% | −$250 | No payback |
| 25% | $65 | 184.6 months |
| 50% | $380 | 31.6 months |
| 75% | $695 | 17.3 months |
| 100% | $1,010 | 11.9 months |
How to read the result
Gross value of the hours
Hours saved per month multiplied by the fully loaded hourly cost. This is the value of the time before anything is assumed about what happens to it.
Cash after conversion
The gross value multiplied by the cash-conversion share. This is the part of the saving that is expected to reach the bank account rather than the schedule.
Net monthly cash
The converted amount minus the recurring cost. If this is zero or negative, the setup cost is never recovered and the result says so.
Assumptions and limits
Printed here so the result can be argued with, which is the point of a worksheet.
Saved hours are treated as constant in every month. There is no ramp-up, learning curve or seasonal variation.
The cash-conversion share is a judgement about operations, not a measured quantity. It is the most consequential input in the calculation.
Recurring cost includes licences, service, consumables, hosting, support and the internal time to run them.
Setup cost includes hardware, software, integration, installation, training and the cost of disruption.
No financing cost, tax, depreciation or residual value is modelled.
Cash savings do not compound, and volume does not grow. The arithmetic is linear on purpose.
Simple payback is not a return on investment. It says when the setup cost is recovered, and nothing about what follows.
A worked illustration
These are the worksheet's default figures, used only so the chain can be followed by hand. They do not describe any real plant, project or vendor.
| Hours saved per month | 30.00 h |
|---|---|
| Hourly cost | $42.00 |
| Gross value of saved hours | $1,260.00 |
| Cash-conversion share | 60% |
| Cash after conversion | $756.00 |
| Recurring cost | −$250.00 |
| Monthly net savings | $506.00 |
| Setup cost | $12,000.00 |
| Simple payback | 23.7 months |
At a 25 per cent conversion share, the same inputs produce $65 a month and a payback beyond fifteen years. At zero, there is no payback. The arithmetic is on the technology investment explainer.