Business ROI Calculator

How to Use the Business ROI Calculator

Almost every business decision that costs money up front and pays back over time reduces to the same four questions: what does it return in total, what does that work out to per year, how long until the money is back, and is it worth more than the same cash left alone. This calculator answers all four.

1. Enter the upfront investment. Everything spent before the benefit begins: the equipment, the software licence, the implementation, the training, and the time your own people spend on it. That last one is the item most often left out and it is rarely small.
2. Enter the annual benefit. Extra revenue, or cost genuinely removed. Be strict here — a saving that lets someone spend four hours a week on something else is only a saving if that time turns into revenue or a smaller wage bill.
3. Enter the annual ongoing cost. Licences, maintenance, support contracts and hosting. A project with a large recurring cost can have an excellent first-year return and a poor five-year one.
4. Set the horizon. How long the benefit realistically lasts before the equipment is obsolete or the process changes. Stretching the horizon is the easiest way to make a bad project look good, so be honest about it.
5. Set a discount rate. Roughly what capital costs you — a lending rate, or the return you would get from the next best use of the money. The net present value figure uses it to weigh money later against money now.

Read the payback period and the annualised return together. A 43% return sounds excellent until you notice it took three years to get there, which is 12.75% a year.

Business ROI Formulas

Four measures of the same cash flows, each answering a different question.

Net present value is the strictest of the four. It asks whether the project beats simply keeping the money, and it accounts for the fact that a benefit arriving in year three is worth less than the same amount arriving now. A positive NPV means the project clears your cost of capital; a negative one means it does not, however attractive the headline ROI looks.

Example

A $45,000 system returning $26,000 a year

1. Annual net benefit: 26,000 − 4,500 of licences and support = $21,500.
2. Over three years: 21,500 × 3 = $64,500 returned against $45,000 invested.
3. Gain: 64,500 − 45,000 = $19,500.
4. ROI: 19,500 ÷ 45,000 × 100 = 43.33%.
5. Annualised: (64,500 ÷ 45,000)^1/3 − 1 = 12.75% a year.
6. Payback: 45,000 ÷ 21,500 = 2.09 years, or 25.1 months.

Does it beat leaving the money alone?

Discounting the three annual benefits at 10% gives $19,545, $17,769 and $16,153, a total of $53,467 against the $45,000 spent. Net present value is $8,467. The project clears a 10% cost of capital with room to spare, which is the version of the answer worth taking to whoever signs it off.

Stress-testing the benefit

Business cases are almost always optimistic about the benefit and accurate about the cost. Cut the benefit by 20% to $20,800 and the annual net falls to $16,300. The three-year ROI drops from 43.33% to 8.67% and payback stretches to 33.1 months — beyond the horizon at which many organisations stop caring. A project that only works if the estimate is exactly right is not a project, it is a hope.

Reading Payback Against Annualised Return

The cumulative position, year by year.

Two years in, this project has returned almost everything and shows a return of −4.44%. That is not failure, it is arithmetic: ROI stays negative until the cumulative benefit passes the investment. Judging a multi-year project on its first-year ROI condemns every project with a payback longer than twelve months, which is most of the ones worth doing.

Notice also how fast the number climbs once payback is passed. Year four adds 47.78 percentage points of ROI for the same $21,500, because the denominator no longer grows. This is why the horizon assumption carries so much weight, and why a plausible horizon should be argued for rather than assumed.

What counts as a good business ROI depends on what else you could do with the money. If the alternative is paying down borrowing at 9%, a project returning 12.75% a year is worth doing and one returning 6% is not. Compare like with like using the general ROI calculator for investments, and check the CAGR calculator if you want the same compounding logic applied to a growth figure.

Five Ways Business Cases Go Wrong

Five ways business cases go wrong, in rough order of how often.

Internal time is not counted. A software rollout that takes three people four weeks has consumed real money even though no invoice appeared. Cost it at loaded salary and add it to the investment, or the ROI is measuring something other than reality.

Soft savings are counted as hard ones. Saving each of forty people twenty minutes a day is thirteen hours a day of capacity, and it is only money if headcount falls or output rises. If neither happens, the saving is real for the staff and invisible in the accounts.

The horizon is stretched to fit. If a five-year case is positive and a three-year case is not, the honest question is which horizon is true, not which one is convenient. Equipment obsolescence and process change both arrive faster than business cases assume.

The comparison is against nothing. Most projects are not compared against doing nothing but against the next best use of the same money and the same attention. A 12.75% return is only good if nothing else on the list returns more.

Nobody measures it afterwards. The single most useful discipline is to record the assumptions, diarise a review twelve months out, and compare. Organisations that do this get noticeably better at estimating within two or three cycles; ones that do not repeat the same optimism indefinitely.

Two related views: the net profit calculator shows what the benefit looks like once it reaches the bottom line after tax, and the customer lifetime value calculator is the right tool when the investment is in acquiring customers rather than in equipment.