Skip to content
NextGen Code
// Data & Business Intelligence

How to Calculate AI ROI (Formula + Worked Example)

How to calculate AI ROI: the formula, payback period and 3-year view, a worked example with every assumption shown, and a free worksheet you can copy.

NextGen Code TeamPublished 11 min read

AI ROI is the net benefit an AI project produces divided by its total cost: ROI = (Benefits − Costs) ÷ Costs. To calculate it honestly, put a dollar value on the hours, errors and revenue the project actually changes, subtract every cost (including licenses, model usage, maintenance and your team's time), and judge the result on payback and a 3-year view, not on year one alone.

Where AI ROI estimates go wrong is predictable. They count saved hours that never turn into useful work, assume everyone adopts the tool on day one, and leave out usage and maintenance. This guide gives you the formula, a fully worked example with every assumption visible, a sensitivity analysis, and a worksheet you can copy into a spreadsheet.

The AI ROI formula

AI ROI uses the same formula as any other investment, applied over a period long enough to include both the build and the payoff:

ROI = (Benefits − Costs) ÷ Costs

If a project costs $40,000 over three years and produces $100,000 in benefits, ROI = ($100,000 − $40,000) ÷ $40,000 = 150%. Two companion numbers make the result useful:

  • Payback period is how long it takes cumulative benefits to cover cumulative costs. A quick version is one-time costs ÷ monthly net benefit, where monthly net benefit is monthly benefits minus monthly running costs. Then add the months it takes to build and ramp up.
  • 3-year ROI applies the formula to three years of benefits and costs. Year one carries the build and the learning curve; years two and three show the steady state. Three years is long enough to be fair to the investment and short enough that the assumptions still mean something.

For large projects, finance teams discount future years to net present value (NPV). For most small-business automation, a simple 3-year view is enough to make the decision.

What counts as an AI benefit

AI benefits fall into four categories, and each needs its own formula so you can check it after launch.

BenefitFormulaWhere the data comes from
Hours recoveredHours saved × loaded hourly cost × capture rateTimed samples, system timestamps
Revenue liftExtra sales × gross margin per saleCRM conversion and response-time data
Error and rework reductionErrors avoided × cost per errorCredit memos, returns, rework logs
Cost avoidanceHires, overtime, fees or software you no longer needPayroll, accounts payable, hiring plan

Hours recovered: use a loaded rate and a capture rate

An hour saved is worth the full cost of that hour, not just the wage. At private-industry establishments with fewer than 50 workers, employers paid $27.88 an hour in wages and $9.76 in benefits per hour worked in June 2026, according to the Bureau of Labor Statistics' Employer Costs for Employee Compensation. That's about 35 cents of benefits on top of every wage dollar. Across all of private industry, benefits were 30% of total compensation.

A quick loaded rate for a small business is wage × 1.35; use your own payroll numbers if you have them. Then apply a capture rate: the share of saved hours that turns into work that matters, like calling accounts, collecting receivables, or absorbing growth without a new hire. Ten minutes saved here and there rarely becomes anything. As a rule of thumb, use 70–90% if you can name where the hours will go, and 30–50% if you can't.

Revenue lift: count margin, not revenue

If an AI agent answers leads in minutes instead of hours and lifts your close rate, the benefit is the added gross profit, not the added revenue. Example: 400 leads a month × a 1-point increase in close rate × a $2,500 average sale × 35% gross margin = $3,500 a month. Revenue lift is the hardest benefit to prove, so give it your most conservative assumption and, if you can, compare against a control group.

Error reduction and cost avoidance

Price each error the way your finance team would: re-shipping, restocking, credits, staff time and, for some errors, the customer you lose. Cost avoidance counts money you would otherwise spend, such as a hire you no longer need as volume grows, overtime, late-payment fees or software you can retire. Count an avoided hire only if you really would have made it.

What counts as an AI cost

Count every cost that wouldn't exist without the project, one-time and recurring.

CostTypeNotes
Build and implementationOne-timeConsultant or developer fees
Data cleanupOne-timeOften internal hours
Training and change managementOne-time, plus new hiresSessions, guides and practice time
Internal project timeOne-timeInterviews, testing and sign-off at loaded rates
Licenses and platformsRecurringSeats, automation tools, document tools
Model usageRecurringBilled per task; grows with volume
Hosting and monitoringRecurringServers, logs and alerts
MaintenanceRecurringPlan on 15–25% of build cost per year

Human review time is also a cost. The cleanest way to handle it is to subtract it from the hours saved, as the example below does. For typical prices on each line, see how much AI consulting costs.

Worked example: AI ROI for order-entry and invoice automation

This example is illustrative, not a client result. Every assumption is shown so you can swap in your own numbers.

The business: a 15-person distributor. Customers email about 40 purchase orders a day as PDFs and spreadsheets, and two office staff key them into the ERP, along with 500 supplier invoices a month.

The project: AI reads each order and invoice, matches customers, SKUs and purchase orders, and drafts the ERP entry for a person to approve. Anything that doesn't match goes to an exception queue.

AssumptionValue
Customer orders40 a day × 21 working days = 840 a month
Time per order today9 minutes to key, look up SKUs and prices, and check
Supplier invoices500 a month at 6 minutes each to key and match
Manual time today(840 × 9 + 500 × 6) ÷ 60 = 176 hours a month
Orders after automation85% need a 2-minute review; 15% are exceptions at the full 9 minutes
Invoices after automation90% need a 1.5-minute review; 10% are exceptions at 6 minutes
Manual time after59 hours a month, so 117 hours a month (1,405 a year) are saved
Loaded labor cost$31 an hour ($23 wage × 1.35)
Capture rate60%; the manager plans to move the time to collections and account calls
Order errors2% of orders today, 0.5% after; each costs $85 in freight, restocking, credits and staff time
One-time costsBuild $30,000; data cleanup $3,000; training $1,500; internal time 60 hours × $31 = $1,860; total $36,360
Running costsPlatform, hosting and monitoring $200 a month; model usage about $54 a month (1,340 documents × $0.04); maintenance $375 a month (15% of the build per year)
TimelineTwo-month build; half of volume runs through it in months 3–4; full use from month 5

At full use, the annual benefit is about $38,980:

  • Labor value: 1,405 hours × $31 × 60% = about $26,130
  • Error savings: 840 orders × 1.5 percentage points × 12 months × $85 = about $12,850

Running costs are about $7,540 a year at full use. Here's the 3-year view, rounded to the nearest $10:

Year 1Year 2Year 33-year total
Labor value$19,600$26,130$26,130$71,860
Error savings$9,640$12,850$12,850$35,340
Total benefits$29,240$38,980$38,980$107,200
One-time costs$36,360$0$0$36,360
Running costs$6,230$7,540$7,540$21,310
Total costs$42,590$7,540$7,540$57,670
Net benefit−$13,350$31,440$31,440$49,530

The results:

  • 3-year ROI = ($107,200 − $57,670) ÷ $57,670 = 86%
  • Year-one ROI = −31%
  • Payback: month 18 from kickoff, about 16 months after go-live

That's a solid, unspectacular and realistic result. A naive version of the same calculation, with every saved hour at full value, no ramp-up and only the build cost counted, claims 88% ROI in year one and payback in about six months. It counts benefits the business won't receive and leaves out costs it will pay.

Sensitivity analysis: pessimistic, expected and optimistic

A single ROI number hides how fragile it is, so run three scenarios and see which assumptions carry the result. Figures are rounded.

Assumption or resultPessimisticExpectedOptimistic
Exception rate (orders / invoices)30% / 25%15% / 10%10% / 5%
Capture rate40%60%80%
Order error rate after1.25%0.5%0.3%
Build cost$37,500$30,000$30,000
Months at half use after launch422
Model usage per document$0.08$0.04$0.03
Annual benefit at full use$20,800$39,000$51,400
3-year net benefit−$14,500$49,500$84,200
3-year ROI−21%86%147%
PaybackNot within 3 yearsMonth 18Month 14

Change one assumption at a time, starting from the expected case's 86%, and the ranking becomes clear:

  • Capture rate of 40% instead of 60%: 3-year ROI falls to 44%.
  • Errors fall only to 1.25%: 55%.
  • Build runs 25% over budget: 57%.
  • Exception rates double: 64%.
  • Adoption takes twice as long: 80%.
  • Model usage costs double: 80%.

In this project, what the business does with the freed-up time matters more than anything the AI does. That's why the capture rate deserves an owner and a plan, not a guess. Usage barely moves this result because the volume is modest. For a customer-facing agent handling thousands of conversations a month, run the same test, because usage can become one of the largest lines.

How to set a baseline before you start

A baseline is the measured "before" number for each metric the project should move, captured with the same method you'll use afterward.

  1. Pick 3–5 metrics tied to the workflow: volume, minutes per transaction, error rate, cycle time (for example, email received to order entered) and cost per transaction.
  2. Measure for 2–4 normal weeks. Avoid holiday peaks and month-end spikes unless they're the point.
  3. Use the cheapest reliable method. Time 20–30 transactions with a stopwatch, pull timestamps from email and the ERP, and count credit memos or rework tickets by reason code.
  4. Agree on the dollar values, such as the loaded rate, cost per error and gross margin, with whoever owns the P&L.
  5. Write it down: the metric, the number, the method, the dates and who measured it.

If you can't measure a metric before the project, you won't be able to prove it moved afterward. The baseline is also the starting point of any forecast, which is why financial analysis and forecasting and ROI work go together. It's also why every recommendation in a NextGen Code AI Opportunity Assessment comes with a measured baseline, a target metric and a payback estimate.

How to measure AI ROI after launch

Measure the same metrics, with the same method, at 30, 60 and 90 days after launch, then quarterly. Track four groups:

  • Adoption: the share of transactions flowing through the new process, and how often people work around it.
  • Quality: error rate, exception rate and how often reviewers edit the AI's drafts. Rising edits are an early warning.
  • Cost: actual usage bills, platform fees and maintenance hours against the plan.
  • Realization: where the saved hours went. Ask the manager to name the work, the overtime cut or the hire not made.

Put these on one dashboard so nobody has to assemble a report by hand. It's standard business intelligence work, and it keeps the project honest; if you don't have dashboards yet, start with our guide to business intelligence for small business. At 90 days, recalculate ROI with actual numbers and make a call: scale it, fix it or stop it.

Common AI ROI mistakes

  1. Counting hours that never get redeployed. Saved time only has value if it goes somewhere. Apply a capture rate and name the destination.
  2. Ignoring adoption. Nobody uses a new tool fully on day one. Model a ramp-up and measure actual use.
  3. Ignoring usage costs. Pay-per-task fees grow with volume and with how much text each task sends. Estimate cost per task during testing.
  4. Forgetting review time. A person approving AI drafts is part of the new process. Subtract that time from the savings.
  5. Counting revenue instead of margin. A $10,000 sale isn't a $10,000 benefit.
  6. Leaving out maintenance and internal time. Both are real costs, and both are easy to forget.
  7. Judging on year one alone, or on five rosy years. Build costs make year one look bad, while a 5-year view with no maintenance costs flatters almost anything.

AI ROI worksheet

Copy this into Excel or Google Sheets, one worksheet per workflow. Each formula refers to the line letters, so it carries over directly. Enter rates as decimals (2% = 0.02).

Template · AI ROI worksheet

1. Baseline (measure for 2–4 normal weeks)

LineInputYour number
ATransactions per month
BMinutes per transaction today
CError rate today
DCost per error ($)
ELoaded labor cost per hour ($): wage × 1.35, or your payroll figure

2. After the project (from your pilot or test set)

LineInputYour number
FShare of transactions needing only a quick review
GReview minutes per transaction
HMinutes per exception (often the same as B)
IError rate after
JCapture rate: share of saved hours redeployed to useful work
KYear-one ramp factor (for example, 0.75)

3. Annual benefit at full use

LineFormulaYour number
LHours saved per year = A × 12 × (B − (F × G + (1 − F) × H)) ÷ 60
MLabor value = L × E × J
NError savings = A × 12 × (C − I) × D
OOther benefits: added gross margin, cost avoidance
PAnnual benefit = M + N + O

4. Costs

LineInputYour number
QOne-time costs: build, data cleanup, training, internal time
RAnnual running costs: licenses, usage, hosting, maintenance

5. Results

LineFormulaYour number
S3-year benefits = P × K + P × 2
T3-year costs = Q + R × 3
U3-year ROI = (S − T) ÷ T
VPayback after go-live, in months = Q ÷ ((P − R) ÷ 12)

6. Measurement plan

  • Metric owner named
  • Baseline method written down
  • Check-ins booked at 30, 60 and 90 days
  • Decision rule agreed: scale, fix or stop

Line T counts a full year of running costs in year one, which is slightly conservative. Run the worksheet three times, with pessimistic, expected and optimistic inputs, before you trust any single answer.

Frequently asked questions

What is a good ROI for an AI project?

There's no universal number, but a sound AI project should show a positive 3-year ROI even under pessimistic assumptions, and a payback period you'd accept for any other investment. For process automation in a small business, a practical ceiling is a 12–24 month payback. Compare the result with other uses of the same cash, such as hiring, marketing or paying down debt, rather than judging it in isolation.

How do I measure the ROI of ChatGPT or Copilot licenses?

Compare the seat price with the time it saves on specific, repeated tasks. Break-even is the monthly seat price divided by the person's loaded hourly cost: a $20 seat for someone whose time costs $31 an hour pays for itself at about 40 minutes saved a month. Measure with short before-and-after timings on real tasks, and check the admin usage reports to see who actually uses their seat.

Should I count time savings if I'm not cutting staff?

Yes, if the time goes to work that creates value. Freed-up hours can absorb growth without a new hire, cut overtime, or move people to sales calls and collections. Count them at the loaded labor rate multiplied by a capture rate, which is the share of saved time you can show was redeployed. If you can't say where the hours will go, use a low capture rate or leave them out.

How long does it take to see ROI from AI?

It depends on the up-front cost and how quickly people adopt the tool. AI assistants can cover their seat cost within the first month if people use them on repeated tasks. Integrated automations take longer: in this article's worked example, a $30,000 project loses money in year one and pays back in month 18. Model a ramp-up period instead of assuming full use from launch day.

Is there an AI ROI calculator I can use?

Yes. The worksheet in this article works as a simple AI ROI calculator. Copy it into Excel or Google Sheets, enter your baseline volumes, minutes per task, error rates and costs, and the formulas give you annual benefit, 3-year ROI and payback. Run it three times, with pessimistic, expected and optimistic inputs, before you trust any single result.