Skip to content

Tool / Worksheet

Arithmetic in the page

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.

Inputs — all figures in Canadian dollars
h

Paid hours the process no longer spends in a month — not the hours a machine runs.

$ / h

Fully loaded: wage, benefits and payroll overhead for the work being replaced or redeployed.

%

The share of saved hours that actually turns into cash: hours redeployed to revenue, overtime avoided, a hire not made. At 0%, nothing converts.

$ / month

Licences, service, consumables, hosting, support and the internal time to run them.

$ once

Hardware, software, integration, installation, training and the cost of the disruption.

Nothing is sent or stored. The arithmetic runs in this page.

Result / monthly net cash

$506

Gross value of saved hours
$1,260
Cash actually converted (60%)
$756
Less recurring cost
−$250

Simple payback

23.7 months

$12,000 ÷ $506 per month

Net cash, 12 months

$6,072

After setup cost

−$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.

Simple payback in months, by cash-conversion share. Setup cost $12,000, recurring cost $250 per month.
ConversionNet cash / monthPayback
0%−$250No payback
25%$65184.6 months
50%$38031.6 months
75%$69517.3 months
100%$1,01011.9 months

How to read the result

01

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.

02

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.

03

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.

  1. 01

    Saved hours are treated as constant in every month. There is no ramp-up, learning curve or seasonal variation.

  2. 02

    The cash-conversion share is a judgement about operations, not a measured quantity. It is the most consequential input in the calculation.

  3. 03

    Recurring cost includes licences, service, consumables, hosting, support and the internal time to run them.

  4. 04

    Setup cost includes hardware, software, integration, installation, training and the cost of disruption.

  5. 05

    No financing cost, tax, depreciation or residual value is modelled.

  6. 06

    Cash savings do not compound, and volume does not grow. The arithmetic is linear on purpose.

  7. 07

    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.

Illustrative inputs and the resulting arithmetic. Not a benchmark.
Hours saved per month30.00 h
Hourly cost$42.00
Gross value of saved hours$1,260.00
Cash-conversion share60%
Cash after conversion$756.00
Recurring cost−$250.00
Monthly net savings$506.00
Setup cost$12,000.00
Simple payback23.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.

From measurement to decision: the two explainers set out the reasoning behind this arithmetic.

Planning a technology investment