Skip to content

How to Calculate ROI for a Business Project

By Newtown Analytics · · 8 min read

For smb owners & operators

Knowing how to calculate ROI for a business project means going beyond the formula and building a defensible estimate of costs and benefits over the life of the project. The formula itself, net gain divided by cost, takes seconds. The work is in finding every cost, identifying benefits you can actually measure, choosing a sensible time period and testing how much the answer changes if you are wrong. This guide gives a seven-step method, works through a warehouse barcode scanning project with checked arithmetic, shows a conservative scenario and lists what to document so that the number survives a challenge from the finance team. It is part of business analytics for finance and operations, follows the ROI formula and leads to ROI vs. ROAS and marketing ROI. The result usually feeds the capital plan in budgeting and forecasting.

The seven steps

  1. Define the project and the baseline. State what will change and what you would do if you did nothing. The baseline is the yardstick for every benefit.
  2. List the costs. One-time costs (equipment, software, implementation, training, internal time) and recurring costs (licenses, maintenance, support, extra staff).
  3. List the benefits. Cost savings, extra contribution margin, avoided losses, risk reduction. Separate those you can measure from those you can only describe.
  4. Quantify each benefit with a stated method. Hours saved times loaded cost, errors avoided times cost per error, extra sales times contribution margin.
  5. Choose the period. Usually the useful life, or three to five years for technology projects. Show benefits and costs by year.
  6. Calculate ROI, payback and, where appropriate, NPV.
  7. Test the answer. Apply a haircut to benefits, delay the start of benefits and add a cost overrun.

A worked example: barcode scanning in a warehouse

A distributor plans to introduce barcode scanning at its warehouse to cut picking errors and manual data entry (hypothetical). The costs and benefits are as follows.

One-time costsAmount
Scanners and hardware$18,000
Software and integration$12,000
Implementation support$10,000
Training and lost productivity during rollout$5,000
Total one-time cost$45,000

Recurring costs: $6,000 a year for software support and device replacement.

Annual benefitsCalculationAmount
Fewer picking errors900 error orders a year × $35 average cost × 70% reduction$22,050
Less manual data entry1,100 hours × $26 loaded hourly cost$28,600
Total annual benefit$50,650

Check: 900 × 35 = 31,500, and 31,500 × 0.70 = 22,050; 1,100 × 26 = 28,600; 22,050 + 28,600 = 50,650.

Over a three-year period:

  • Total cost: $45,000 + 3 × $6,000 = $63,000
  • Total benefit: 3 × $50,650 = $151,950
  • Net gain: $151,950 - $63,000 = $88,950
  • ROI: $88,950 / $63,000 = 141.2 percent over three years
  • Net annual benefit after running costs: $50,650 - $6,000 = $44,650, so payback is $45,000 / $44,650 = 1.01 years

That looks excellent, which is a reason to be careful. The 70 percent error reduction is a supplier claim, and the labor hours are saved only if the work disappears or is redeployed. The next step tests the case.

The conservative case

Apply a 30 percent haircut to all benefits, so the annual benefit is 0.70 × $50,650 = $35,455.

  • Total benefit over three years: 3 × $35,455 = $106,365
  • Net gain: $106,365 - $63,000 = $43,365
  • ROI: $43,365 / $63,000 = 68.8 percent
  • Net annual benefit: $35,455 - $6,000 = $29,455, so payback is $45,000 / $29,455 = 1.53 years

Even with benefits 30 percent lower, the project returns well above its cost, which makes the decision robust. If the conservative case had shown a negative ROI, the right response would be to find out which assumptions drive the result and test them with a pilot before committing.

Costs people forget

  • Internal time spent on selection, configuration, testing and training.
  • Productivity dip during changeover.
  • Ongoing administration, including someone to own the system.
  • Integration and data cleanup.
  • Contingency. A common practice is to add 10 to 20 percent to one-time costs for projects with uncertain scope.
  • Financing costs if the project is funded with debt.
  • End-of-life costs such as disposal or migration.

Benefits people overcount

  • Time saved that is not redeployed. Saving ten minutes per task for twelve people does not reduce payroll.
  • Revenue increases counted at revenue and not at contribution margin.
  • Benefits that would have happened anyway because of market growth or other initiatives.
  • Benefits claimed by several projects.
  • Soft benefits, such as better morale, valued at a precise number with no evidence.

Keep soft benefits visible but outside the number, and call them upside.

Showing the result to decision makers

A one-page summary works best: the project in two sentences, total cost, total benefit, ROI, payback, the conservative case, the three assumptions with the greatest effect and the plan to measure results after launch. Add a table of costs and benefits by year, so readers can see when cash goes out and when it comes back. After the project is live, track actual benefits against the plan for at least a year and report the differences. Teams that review actual results become better at forecasting benefits.

Measuring after launch

Define in advance how each benefit will be measured. For picking errors, use the error log, comparing the average per month in the six months before and after. For labor hours, use time records or the planned reduction in overtime. Assign someone to report the results, and compare with the business case at 6 and 12 months. Where results fall short, find out why: was the benefit overstated, was adoption incomplete, or did something else change? That feedback improves the next business case. See how to track ROI across departments.

Choosing the period and phasing the benefits

Two projects with the same total benefit can have very different ROI depending on when the benefit arrives. In the barcode example, the benefits were assumed to start on day one. In practice, rollout takes months, and the first year delivers only part of the run-rate benefit. Suppose the first year delivers 50 percent of the annual benefit, or $25,325, and years 2 and 3 deliver the full $50,650. Total benefit becomes $25,325 + $101,300 = $126,625, the net gain is $126,625 - $63,000 = $63,625 and the ROI is 63,625 / 63,000 = 101.0 percent, down from 141.2 percent. Phasing matters most for projects with long implementation periods, and it is the most common reason that realized ROI falls short of the case. Build the phasing into the model as a row of percentages by year, and ask the project owner to justify each.

For the period itself, use the useful life of the asset where it is shorter than the planning horizon. Do not extend the horizon to make a weak project work. A five-year view for a technology that is likely to be replaced in three will overstate the return.

Capital projects and operating projects

Capital projects, such as equipment and facilities, have a large cost up front and benefits over many years, and they are usually assessed with payback and NPV as well as ROI. Operating projects, such as process redesign, training or a new reporting routine, have smaller costs, often in people's time, and benefits that depend on behavior. Operating projects therefore tend to show high ROI on paper, and a high proportion of the risk lies in whether anyone changes what they do. For these projects, spend more of the analysis on the owner of each benefit and the plan to embed the change than on the arithmetic.

A ten-minute reasonableness check

Before building a detailed model, run a plausibility test on the biggest benefit. In the example, 1,100 hours saved on data entry would be 1,100 / 8,000 = 13.75 percent of the warehouse's annual data entry and handling hours, if those total 8,000. Is it believable that scanners remove that share of the work? If the figure had been 60 percent, it would call for evidence. Similarly, compare the total benefit with the cost base it acts on: a project that claims to save 25 percent of a $200,000 cost line, which is $50,000, needs a very clear mechanism. Anchoring benefits to the cost base catches the most common error in business cases, which is a benefit that exceeds what the process costs today.

The assumptions page

Every business case should have a page, or at least a table, that lists each assumption, its source, the person who supplied it and a confidence level. Typical entries are the error rate and cost per error (from the error log), the labor rate (from payroll, loaded with benefits), the adoption timeline (from the vendor and a reference customer) and the useful life. When someone challenges the ROI, the assumptions page is where the conversation should go. It also allows the finance team to adjust a single number and see the effect, without reconstructing the model.

FAQs

How do I calculate ROI for a project?

List all costs and benefits over the project's life, subtract total costs from total benefits to get net gain, and divide by total costs. Show payback and a conservative case alongside.

What time period should I use?

The useful life of the asset or a standard horizon such as three to five years, applied consistently across projects you compare.

Should I include internal staff time as a cost?

Yes, at a loaded hourly rate, because it has an opportunity cost even if no cash leaves the business.

How do I deal with uncertain benefits?

Estimate a range, apply a haircut to the central estimate and show the ROI under the conservative case.

What if ROI is positive but payback is long?

Consider the risk and the cash position. A project with a good return but a long payback may strain liquidity or depend on assumptions that are hard to hold for years.

This article is for general information. It is not accounting, tax, legal or investment advice, and examples use illustrative numbers rather than client data. Confirm decisions that carry financial or legal consequences with a qualified professional.

Better forecasts. Healthier inventory. More working capital.

Newtown Analytics advises growing consumer-product companies on demand planning and inventory optimization.