ROI Calculator: Size the Gain Before You Commit to a Pilot

The ROI Calculator sits in the Improve phase of RDMAICS. In the product's own words, it calculates return on investment, payback period, and net present value for the proposed improvement solution.

You reach for it after Analyse, not before. By the Improve phase you have a cause you believe in and a solution you think will address it. What you do not yet have is permission to spend. The ROI Calculator produces the number that decides whether the change gets piloted or shelved.

The sequence matters. Recognise found the problem. Define scoped it. Measure gave you a baseline. Analyse told you why. Improve is where you choose between candidate solutions, and choosing requires a comparable figure for each. This tool gives you that figure in three forms: a percentage return, a time to payback, and a discounted value over three years.

Every number in this guide comes from the sample data built into the tool. The case is fictional. It exists so you can see the mechanics without needing your own data loaded.

The scenario is a single improvement solution with a total investment of 150000 dollars. That investment covers software, implementation and training. The expected annual benefits are 269000 dollars a year, made up of labour savings, rework savings and penalty savings.

Those benefits are not free to run. Once annual running costs are subtracted, the net annual benefit is 219000 dollars a year. That net figure is the one that drives the arithmetic. It is the number you defend in a steering meeting, and it is the number most teams get wrong by forgetting the running costs.

The worksheet is a short table. Each row is a metric with a value, a unit and a notes field. The notes field is where the reasoning lives, and it is the part people skip.

Look at how the sample case uses it. Against total investment the note reads software plus implementation plus training. Against annual benefits the note reads labour plus rework plus penalty savings. Against net annual benefit the note reads benefits minus annual costs. Anyone reading the worksheet six months later can reconstruct how you arrived at each figure.

The rows in the sample case are these:

The result panel restates the inputs and then shows the calculated outputs. Investment of 150000 dollars. Net annual benefit of 219000 dollars a year. Calculated ROI of 146 per cent. Payback of 8.2 months. NPV over three years at 8 per cent of 414384.24 dollars.

The panel is labelled as built from worksheet and formula driven. That label is doing useful work. It tells you the numbers were derived from the rows you entered, not estimated or asserted. The tool also explains its own method: ROI and payback use the annual net benefit, and NPV uses a three year, 8 per cent discounted cash flow model.

You will notice the worksheet row for NPV reads 429000 dollars while the calculated result reads 414384.24 dollars. That gap is informative rather than alarming. The worksheet row held a rounded planning estimate. The result panel ran the discounted cash flow and returned the precise figure. When a hand estimate and a formula disagree, you want to know, and you want to carry the formula figure into your proposal.

The tool also offers an AI review that explains the result in plain language. Use it to sanity check your own reading, not to replace it.

Three outputs support three different conversations, and you should know which one to lead with.

ROI at 146 per cent answers the question of whether the change is worth doing at all. It is a ratio, so it compares cleanly across candidate solutions of different sizes. If you have three proposals competing for the same budget, ROI ranks them.

Payback at 8.2 months answers a cash question. It tells a finance sponsor how long the organisation carries the 150000 dollars before the net benefit covers it. Under twelve months tends to be an easier conversation than over twenty four, because it lands inside a single budget cycle.

NPV at 414384.24 dollars answers the question of scale. ROI tells you the change is efficient. NPV tells you it is material. A small change can carry a high ROI and still be too minor to justify management attention. A figure over 400000 dollars across three years is not minor.

Together they also support a fourth decision: pilot design. If the number is large enough to matter and the payback is short enough to observe, you can run a time boxed pilot and compare actual benefit against the 219000 dollars a year you forecast.

The most common error is using gross benefits instead of net. In the sample case that would mean building the ROI on 269000 dollars rather than 219000 dollars. The result would look better and would not survive first contact with a finance review.

The second error is an incomplete investment figure. The sample note is explicit that 150000 dollars includes software, implementation and training. Teams routinely count licence cost and forget the people time needed to implement and train. That omission shortens payback artificially.

Other mistakes to watch for:

The ROI Calculator is a gate, not an analysis. It does not tell you what to improve. Analyse did that. It tells you whether the improvement you have chosen is worth piloting.

That makes it the natural handover point into Control and Sustain. The forecast you record here becomes the target you verify later. Control measures whether the net annual benefit of 219000 dollars a year actually appears. Sustain checks whether it holds once the project team moves on.

Record the worksheet as it stands when you make the decision. Do not edit it after the fact to match what happened. The value of the forecast lies in the comparison.

The ROI Calculator is arithmetic applied to your assumptions. If the assumptions are wrong, the outputs are wrong with precision. A calculated NPV of 414384.24 dollars carries two decimal places and no more certainty than the 269000 dollar benefit estimate underneath it.

It will not test whether your benefits are real. Nothing in the tool verifies that labour, rework and penalty savings will materialise, or that they are independent of each other. That verification is your job, and it usually means going back to the Measure data.

It will not model risk, and it will not model timing. The three year, 8 per cent model treats the net annual benefit as arriving evenly. Most improvements ramp. If benefits start slowly, real payback will run longer than 8.2 months even when the annual figure is correct.

It will not account for anything outside the rows you enter. Disruption during implementation, capability you gain for future projects, option value, staff reaction to the change, none of it appears. Those factors may change your decision and they will not change your ROI.

Finally, it will not make the decision. A 146 per cent return is a strong case on its own terms. Whether your organisation has the 150000 dollars, the implementation capacity, and the appetite to change behaviour is a judgement the tool cannot make for you.