Turn Recurring ROI Calculations Into a Tool Sales Can Actually Use
Revetorque builds custom ROI & TCO Tools that combine customer-specific operating data, validated assumptions and transparent financial logic into a reusable workflow for complex Industrial B2B sales.
The goal is not to produce a more impressive number.
It is to make the economics of the investment easier to input, compare, understand and explain.
- Customer operating data
- Product data
- Validated assumptions
- Scenario variables
ROI / TCO model
- ROI
- Payback
- TCO
- Lifecycle economics
A calculator is easy. A credible decision model is harder.
The formula is only one part of the tool.
A useful ROI/TCO workflow also needs to answer:
Which inputs actually matter?
Where does the data come from?
Which values are known and which are assumed?
Which assumptions should Sales or the customer be able to change?
What alternatives are being compared?
Which variables materially affect the result?
What output does the user need next?
A calculator can return a number.
A decision tool needs to explain what that number means.
The value of the tool comes from the model around the formula — not the formula alone.
Different investment questions require different financial outputs
Not every decision needs the same metric.
A custom tool should calculate what is relevant to the investment.
ROI
Useful when the customer wants to understand the return relative to the amount invested.
Payback
Useful when the key question is:
“How quickly do we recover the additional CAPEX?”
Total Cost of Ownership
Useful when alternatives have different operating, maintenance or lifecycle economics.
OPEX
Useful where recurring operating cost is the primary value driver.
Lifecycle Cost
Useful where equipment life, maintenance and replacement timing materially change the decision.
Break-even
Useful when the economics depend on utilisation, throughput or another operating variable.
One tool may contain several of these.
But adding more metrics does not automatically make the model better.
The decision determines what belongs.
The economics should respond to the customer's actual operating conditions
The same product can create very different financial outcomes for two different customers.
A useful ROI/TCO Tool therefore needs to use customer-specific inputs where those inputs materially affect the result.
Depending on the application, that may include:
- operating hours,
- electricity price,
- production volume,
- consumption,
- utilisation,
- maintenance cost,
- labour,
- consumables,
- downtime,
- existing equipment,
- purchase price,
- expected equipment lifetime,
- financing assumptions,
- other application-specific variables.
Some values may begin with sensible defaults.
But when the customer's real operating conditions matter, the model should be able to respond to them.
A precise number is not credible if the assumptions are invisible
ROI can look reassuringly exact.
That does not make it reliable.
A transparent tool should make it clear which values come from:
Customer data
Inputs supplied directly by the customer.
Product data
Validated information about the proposed solution.
Engineering assumptions
Values introduced where direct measurement is unavailable.
Benchmarks
Reference values used where appropriate.
Commercial assumptions
Inputs related to cost, pricing or investment conditions.
Scenario variables
Values deliberately changed to test different outcomes.
The user should know:
What is known, what is assumed and what can be changed.
That is one of the main differences between a useful decision model and a black-box calculator.
The tool should help answer: “Compared with what?”
ROI does not exist in isolation.
The customer is usually comparing one option with another.
That might mean:
Status quo
vs
replacement
or:
external supply
vs
on-site production
or:
existing technology
vs
higher-efficiency alternative
or:
Option A
vs
Option B
A dedicated tool can keep those scenarios inside one consistent model.
That makes it easier to see not only the final result, but what changes between the alternatives.
Do not stop at the final number
A useful ROI/TCO Tool should make the drivers behind the result visible.
Depending on the use case, the output might include:
- annual operating-cost difference,
- cumulative cost,
- payback period,
- ROI,
- TCO difference,
- lifecycle cost,
- cost breakdown,
- key value drivers,
- scenario comparison,
- sensitivity.
The user should be able to answer:
Why did the result change?
not only:
What number did the calculator produce?
Which assumptions could change the decision?
Some variables barely move the result.
Others can completely change the business case.
That is where sensitivity becomes useful.
For example:
- energy price,
- utilisation,
- production volume,
- downtime,
- maintenance interval,
- project lifetime.
- energy price,
- utilisation,
- production volume,
- downtime,
- maintenance interval,
- project lifetime.
A good tool can make those dependencies visible.
The objective is not financial sophistication for its own sake.
It is to understand:
What has to be true for this investment to make sense?
A good ROI tool does not always show a good ROI
If:
- utilisation is too low,
- savings are too small,
- CAPEX is too high,
- operating conditions are unfavourable,
- or the assumptions required to justify the investment become unrealistic,
the tool should show that.
A model designed to always generate a positive case is not really evaluating the investment.
It is reverse-engineering a sales argument.
If the calculation is designed to always support the sale, it is not a credible calculation.
The tool should be capable of saying:
“Under these conditions, this investment does not make economic sense.”
That makes the positive cases more credible too.
Excel is often where good logic starts
Many strong ROI and TCO models begin in spreadsheets.
That makes sense.
The spreadsheet may contain years of useful knowledge.
Revetorque does not start by throwing that away.
We start by understanding it.
Excel is excellent for:
- developing formulas,
- testing assumptions,
- iterating quickly,
- validating methodology,
- exploring scenarios with experts.
The question is what happens when the model needs to leave the spreadsheet
The limitations often appear when the same model needs to be used:
- by more salespeople,
- across more opportunities,
- with customers directly,
- with controlled assumptions,
- with consistent formulas,
- with a cleaner user experience,
- with saved scenarios,
- with structured outputs,
- or without someone explaining which cells are safe to touch.
At that point, the issue is no longer:
“Can Excel calculate this?”
It usually can.
The better question is:
“Is the spreadsheet still the right operating model for how this logic now needs to be used?”
A dedicated Revetorque tool becomes relevant when the calculation needs to move from an expert model into a repeatable sales workflow.
Keep the logic that works. Improve how it is used.
From spreadsheet model to dedicated sales tool
Revetorque can start from an existing:
- ROI calculator,
- OPEX model,
- TCO spreadsheet,
- engineering calculation,
- manual business-case worksheet.
We then examine:
- Inputs
- Which values are required?
- Formulas
- What calculations are already validated?
- Dependencies
- Which values affect one another?
- Assumptions
- Which defaults exist and who owns them?
- Units
- How are different customer conventions handled?
- Exceptions
- When does the normal logic stop being valid?
- Outputs
- What does Sales or the customer actually need to see?
The objective is not to reproduce Excel in a browser.
It is to turn validated logic into a workflow designed for how the model will actually be used.
Example: external supply vs on-site generation
Consider an industrial customer deciding whether to continue purchasing gas externally or invest in on-site generation.
A custom ROI/TCO Tool can use inputs such as:
- gas consumption,
- current supply price,
- delivery cost,
- required purity,
- operating hours,
- compressor power,
- electricity price,
- equipment CAPEX.
From those inputs, the model can calculate and compare:
Current external-supply economics
What does the existing supply model cost?
On-site operating cost
What would it cost to produce the gas locally?
Annual economic difference
How do the two models compare under the customer's actual conditions?
Cumulative cost
How do the economics change over time?
Payback
When, if ever, does the investment recover its upfront cost?
Alternative scenarios
What happens when electricity price, consumption or another material assumption changes?
For one customer, the business case may be strong.
For another, it may not.
That is the point of the model.
One model. A workflow built around real use.
A finished ROI & TCO Tool can do more than display a calculation.
Depending on the use case, it may include:
Input
- guided customer inputs,
- units and conversions,
- validation,
- default assumptions.
Calculate
- validated formulas,
- customer-specific economics,
- technical dependencies.
Compare
- alternative scenarios,
- status quo,
- sensitivity,
- configuration options.
Explain
- cost breakdowns,
- charts,
- key value drivers,
- visible assumptions.
Share
- customer summaries,
- PDF outputs,
- saved calculations,
- management-ready views.
The workflow should contain only what the decision actually requires.
ROI & TCO Tool or Business Case Tool?
The two often overlap.
The difference is the primary job.
Choose an ROI & TCO Tool when:
The main requirement is to answer:
“What do the economics of this investment look like?”
and the tool primarily needs to quantify:
- ROI,
- payback,
- TCO,
- OPEX,
- lifecycle economics,
- scenario differences.
Choose a Business Case Tool when:
The financial model is one part of a broader decision involving:
- technical context,
- several value mechanisms,
- status quo,
- alternatives,
- customer narrative,
- internal decision outputs.
A real application may combine both.
Explore Business Case Tools →A dedicated ROI/TCO Tool makes sense when the calculation keeps coming back
This solution is particularly relevant when:
- Sales repeatedly receives ROI or TCO questions,
- customer-specific inputs materially change the result,
- the methodology already exists or can be validated,
- multiple sellers need to use the same model,
- the current process requires manual spreadsheet work,
- customers need to see or interact with the logic,
- the same scenarios recur across opportunities.
The stronger the repetition, the stronger the case for turning the methodology into a dedicated tool.
Rebuilding the same ROI model for every opportunity?
Bring us:
- the spreadsheet or calculation you already use,
- the technical inputs,
- the formulas,
- the assumptions,
- the financial outputs customers ask for,
- and how Sales currently applies the model.
We will first identify what logic already works.
Then we determine what needs to change for that methodology to become a reusable customer-facing sales tool.
Discuss a Use Case
Tell us what you currently calculate, who uses the model and where the spreadsheet starts becoming difficult to work with.
Discuss a Use Case