The short answer
An ROI calculator template is a simple model that estimates the return on a purchase. It has inputs (the buyer's volumes, time and costs), stated assumptions (the improvement you expect) and outputs (annual benefit, ROI percentage and payback period). ROI equals net benefit divided by cost. Credible versions use the buyer's own numbers and conservative assumptions.
On this page
- The ROI Calculator Template (Inputs, Formula, Outputs)
- A Worked ROI Example
- The Four Value Levers to Model
- Building the Calculator Buyers Will Actually Use
- How to Present ROI Credibly
- ROI Calculator Mistakes That Kill Trust
- Carrying the Value Case to Every Account
- Put your value case on a one-pager for every prospect
- FAQ
Key takeaways
Use their numbers: Inputs come from the buyer: volumes, hours, rates. Your assumptions are the only part they need to accept.
Three outputs only: Annual benefit, ROI percentage and payback period. A dozen outputs reads like a sales trick.
Lead with the cautious case: A modest number the CFO believes beats a big one they cross out. Show conservative first.
Show the math: Every output should trace back to an input and a formula the buyer can check in 30 seconds.
The ROI Calculator Template (Inputs, Formula, Outputs)
An ROI model has three blocks, and only one of them is yours. Inputs come from the buyer. Assumptions are your claims, stated openly. Outputs are pure arithmetic, so nobody can argue with them once they accept the first two.
INPUTS (the buyer provides these)
A. Volume per month: [e.g. 400 spot quotes]
B. Minutes per unit today: [e.g. 45]
C. Loaded hourly cost: [e.g. $55]
D. Costs you replace per year: [e.g. $0, or a tool you retire]
ASSUMPTIONS (you state these)
E. Share of time saved: [e.g. 25% conservative, 50% expected]
F. Annual price: [e.g. $24,000]
G. One-time setup cost: [e.g. $3,000]
OUTPUTS (arithmetic only)
Hours saved per year = A x (B / 60) x E x 12
Annual benefit = (Hours saved x C) + D
Year-one cost = F + G
ROI, year one = (Annual benefit - Year-one cost) / Year-one cost
Payback in months = Year-one cost / (Annual benefit / 12)
Keep the inputs in the buyer's units. If they count "loads" or "tickets" or "invoices," so does your model. A calculator that speaks their language gets filled in; one that speaks yours gets ignored.
A Worked ROI Example
Here is the template filled in for a fictional deal. Northwind sells quoting software to Halden Freight, whose pricing team builds about 400 spot quotes a month at roughly 45 minutes each. The numbers are illustrative, not a benchmark.
| Line | Conservative case | Expected case |
|---|---|---|
| Share of time saved (E) | 25% | 50% |
| Hours saved per year | 900 | 1,800 |
| Annual benefit at $55 per hour | $49,500 | $99,000 |
| Year-one cost (price plus setup) | $27,000 | $27,000 |
| ROI, year one | about 83% | about 267% |
| Payback | about 6.5 months | about 3.3 months |
Lead with the left column. If the conservative case still pays back inside a year, you have a strong case and a CFO who trusts you. If it only works in the expected case, you've learned something important about the deal.
The Four Value Levers to Model
Not all benefits are equal in a finance review. Sort every benefit into one of four levers and be honest about which ones are hard money.
| Lever | What to measure | How finance sees it |
|---|---|---|
| Cost avoided | Tools retired, hires not made, overtime cut | Hard savings, most credible |
| Time saved | Hours freed per week or month | Soft, unless it avoids a hire or frees revenue work |
| Revenue gained | Faster quotes won, higher win rate, bigger deals | Persuasive but hardest to prove |
| Risk reduced | Errors, penalties, compliance exposure | Real, but easy to overstate |
Turn soft savings into capacity. "1,800 hours a year" sounds abstract. "Your two pricing analysts can absorb the new Midwest lanes without a third hire" is a decision a VP can make.
Building the Calculator Buyers Will Actually Use
A simple spreadsheet beats a slick web calculator in a real deal. The buyer can open it, change a cell and forward it to finance. Build it in this order:
- One tab for inputs. Color input cells so the buyer knows exactly what to change. Pre-fill with their numbers from discovery, marked as estimates.
- One tab for assumptions. Each one gets a single-line justification, such as "based on rollout data from two similar customers" (only if true).
- One tab for outputs. Three numbers and two scenarios, nothing else.
- A notes column. Record where every input came from: "Maya Chen, call on 3 Oct."
- A sensitivity line. Show the break-even point: "This pays back in year one if time saved is above 14%."
Gather inputs in discovery, not after. The questions that fill this model are the same ones behind the Metrics element in a MEDDIC template. Ask them on the call and the calculator almost builds itself.
How to Present ROI Credibly
Where you show the number matters as much as the number. Use a different depth at each stage of the deal.
- In cold outreach: never attach a calculator. Use one line that shows you understand the cost of the problem, then ask a question.
- In the first meeting: one slide with the formula visible and the inputs blank. Fill it in together. Our B2B sales pitch guide covers framing the business case for a committee.
- In the proposal: the agreed numbers, both scenarios and the sources. The sales proposal template shows where the value section sits.
- With the CFO: hand over the spreadsheet and let their analyst change the inputs. Ownership is what makes the number stick.
Subject: Quick math on spot quotes
Hi [Name],
If [Company] builds roughly [volume] quotes a month and each one
takes [time], that's around [hours] hours a month of [role] time.
Teams like yours usually want that time back for [priority].
Is quote turnaround something you're looking at this quarter?
[You]
Use their public facts for the estimate, then ask. A rough, clearly labeled estimate invites a correction, and a correction is a conversation.
ROI Calculator Mistakes That Kill Trust
- Inventing the inputs. A model built on your guesses about their business gets dismissed the moment one figure is wrong.
- Counting the same benefit twice. Time saved and "productivity gained" are usually the same hours.
- Hiding the cost side. Leave out setup, training or internal time and the CFO will add it back, with interest.
- Showing ten outputs. Net present value, IRR and five charts make it look like you are hiding something. Three outputs are enough for most sales conversations.
- Using unsourced benchmarks. "Customers see 300% ROI" with no named source is a claim, not evidence.
Carrying the Value Case to Every Account
The calculator proves the number; a one-pager tells the story. Most stakeholders will never open your spreadsheet. They'll read a page that says what changes for their team, why it's credible and what it costs, with the headline numbers you agreed. The sales one-pager guide covers the six blocks that page needs, and an ROI-style sales infographic works when the before-and-after is the whole story.
Building that page for every account takes time you don't have. Edithly builds a one-pager for each prospect from their website and your product playbook, and you can point it at the value case you agreed in Notes. The math stays in your spreadsheet; the story goes to everyone else on the buying side.
How Edithly does it
Put your value case on a one-pager for every prospect
Edithly doesn't build ROI calculators. It builds a one-pager for each prospect from their website and your playbook, and you can use Notes to tell it which value case to lead with, so the math in your spreadsheet arrives with a story around it.
- 1
Click the One Pager tile
On Home, pick One Pager. Your value propositions and proof points are already in your playbook, read from your website when you added the product.
- 2
Add the prospect and value angle
Enter the company name and website. In Notes, add the value case you agreed, for example 'cut spot quote time; we estimated about 900 analyst hours a year'.
- 3
Generate and copy the link
Click Generate one pager, pick a style, then copy the share link to send alongside your ROI sheet. The view count shows whether it's been opened.
Website
Ready
- Their challenge
- Your answer
- Proof points
- Next step
- Styles
- Copy link
- By hand
- 1 to 2 hours per account to research and lay out a value one-pager
- With Edithly
- A couple of minutes for the one-pager; the ROI math stays in your spreadsheet
Frequently asked questions
What is the formula for ROI?
ROI equals net benefit divided by cost, shown as a percentage: (total benefit minus total cost) divided by total cost, times 100. If a tool costs $27,000 in year one and produces $49,500 of benefit, ROI is (49,500 minus 27,000) divided by 27,000, or about 83%. State the time period, because year-one ROI includes setup costs.
What should an ROI calculator include?
Three blocks. Inputs the buyer provides, such as volumes, time per task and loaded hourly cost. Assumptions you state openly, such as the percentage of time saved and your price. Outputs kept to three: annual benefit, ROI percentage and payback period. Add a conservative and an expected scenario so the buyer can see the range.
How do you calculate the payback period?
Divide the total cost by the monthly benefit. If the first-year cost is $27,000 and the benefit is $4,125 a month, payback is about 6.5 months. Payback is often more persuasive than ROI percentage for finance teams, because it answers a simple question: how long until this has paid for itself?
How do you make an ROI case credible to a CFO?
Use the buyer's own inputs, state every assumption, show a conservative case first and separate hard savings (costs that disappear) from soft savings (time that frees up). Let the buyer change the inputs themselves. A CFO trusts a number their own team built far more than one that arrived finished in a vendor deck.
Can Edithly build an ROI calculator?
No. Edithly doesn't build ROI calculators or financial models. Keep your calculator in a spreadsheet. Edithly builds a one-pager for each prospect from their website and your playbook, and you can use Notes to tell it which value case to lead with, so the summary you send matches the numbers you agreed.