Your Training Partner
Techniques Toolbox
Two proportional bars with no time axis. The cost bar shows CHF 45'000 and is the reference. The total gross benefit bar shows CHF 75'000. Its part beyond the cost is the net benefit of CHF 30'000. The ROI divides this net benefit by the cost and equals 66.7%.

Return on Investment (ROI)

Return on investment (ROI) divides the net benefit of an investment by its cost and expresses it as a percentage: ROI = (gain − cost) / cost. The calculation needs only two numbers. A decision-maker reads "a return of 66%" without financial training. ROI ignores when the money arrives: two investments with the same ROI can pay back one in eight months and the other in five years. The analyst delivers the percentage with the horizon and the assumptions needed to redo it.

Goal

Return on investment divides the net benefit of an initiative by its cost. The result is a percentage that can be compared across investments. An ROI of 66.7% means that each franc invested returned 0.667 francs of net benefit. The analyst uses it to rank options and to report on a completed initiative.

Cost-benefit analysis supplies the gain and the cost. The analyst establishes that cost as a total cost of ownership, which includes support, recurring licences and upgrades. A cost that counts only the purchase price inflates the ratio.

ROI belongs to financial analysis alongside net present value, the internal rate of return and the payback period. It measures a relative return. Net present value measures the value created in francs and accounts for the timing of the cash flows.

Usage

When to use it

  • Screening many options: rank the candidates by relative return, then reserve net present value for the short list.
  • Reporting on a completed initiative: give management a single figure instead of a full cash-flow table.
  • Options compared over the same short horizon: over one or two years, discounting barely changes the ranking.
  • Gain and cost already credibly estimated: the ratio is only as good as its two inputs.

When not to use it

  • Long horizon or costs and benefits spread over time: a distant franc counted as a near one distorts the comparison. Prefer net present value, which discounts the cash flows.
  • Mutually exclusive options of very different sizes: the ratio favours the small project. Prefer net present value.
  • Mainly non-financial benefits (compliance, security, reputation): ROI leaves them out or prices them by guesswork. Prefer multi-criteria decision analysis.

Description

The ratio

ROI is expressed as a percentage: ROI = (gain − cost) / cost. The numerator subtracts the cost from the gross gain, that is all the revenue or savings the investment generates. This subtraction gives the net benefit. Yet many business cases present a net benefit: someone has already subtracted the cost. The numerator is then this net benefit. If the analyst subtracts the cost again from a benefit that is already net, the ROI loses exactly 100 points: the example's 66.7% becomes −33.3%. This silent double subtraction is the first trap. The analyst avoids it by noting whether each figure is gross or net before placing it in the formula.

ROI and the timing of cash flows

ROI discounts nothing: it treats every franc as equal no matter when it arrives. By construction, ROI cannot tell apart two investments of identical return when one pays back in eight months and the other in five years. When that difference matters, the analyst discounts the cash flows with net present value.

Over a multi-year horizon, the same trait sets a second trap: ROI is cumulative by default. The decision-maker may read the three-year cumulative 66.7% as an annual rate. Annualised ROI converts the cumulative figure into a compound rate: (1 + ROI)1/n − 1, that is 1.6671/3 − 1 = 18.6% per year. It assumes that the whole gain arrives at the end of the period. Plain division of 66.7% by three gives 22.2%: it does not compound and overstates the rate. The example's cash flows start in year 1. Their internal rate of return is 33.3%.

ROI and the cash-flow schedule

IndicatorProfile A (example)Profile B (reverse order)
Gross benefits in years 1, 2 and 3 (CHF)30'000 · 25'000 · 20'00020'000 · 25'000 · 30'000
Cumulative ROI over three years66.7%66.7%
Annualised ROI18.6%18.6%
Payback period1.6 years2.0 years
Internal rate of return33.3%28.3%
Both profiles have the same cumulative ROI and the same annualised ROI. Profile A recovers the outlay sooner and has a higher internal rate of return. The payback period assumes benefits spread over the year. The internal rate of return assumes cash flows at year end.

ROI and the size of the investment

ROI ignores the size of the stake. A CHF 10'000 project that returns CHF 15'000 of net benefit shows 150%. A CHF 1'000'000 project that returns CHF 400'000 shows 40%. ROI ranks the small project first. Yet the large one creates nearly 27 times more value. Between mutually exclusive options, net present value decides.

The calculation steps

  1. Gather the gain and the cost over the same scope and the same horizon: an annual gain set against a three-year cost gives a false ratio.
  2. Settle gross versus net: set the numerator either as (gross gain − cost) or as the net benefit already calculated, never both in succession.
  3. Divide by the cost and express the result as a percentage: the result is the ROI over the chosen horizon.
  4. Declare the horizon and the nature of the figure: cumulative ROI over N years. BABOK recommends comparing options over the same period. If the horizons differ, annualise the ROI and say so.
  5. Record the assumptions behind each number: the origin of the gain and the make-up of the cost. A reviewer can then redo the calculation and challenge each input.

ROI and the role of assumptions

ROI flags no false input: it divides what it is given. An optimistically projected gain produces a flattering percentage. The displayed precision of the percentage masks the uncertainty of the estimates. The analyst therefore tests the ROI under a cautious scenario: if the gain falls by 20%, the example's ROI drops from 66.7% to 33.3%. BABOK notes that positive financial figures can give a false sense of security. It recommends stating the assumptions behind costs and benefits so that they can be reviewed, challenged and approved.

AI considerations

A language model helps the analyst build cautious, median and optimistic benefit scenarios from the analyst's own assumptions. The analyst can then test the ROI under several sets of inputs rather than on a single guessed figure. The model also structures the table of gains and costs. It spots cost items that analysts often forget: training, licence renewal or support. The analyst then checks that the denominator is complete. A language model that calculates in its head can get the fractional power of annualisation wrong. The analyst therefore calculates the ROI in the spreadsheet or with a tool that executes code.

An amount that AI invents with no basis in the organisation's data is worse than a declared "unknown": the percentage lends it an authority it does not have. When the case does not say whether a benefit is gross or net, cumulative or annualised, the AI flags the ambiguity and the analyst decides. When a model produces the scenarios, the analysis handed to the decision-maker shows the assumptions behind each one. The amounts in an investment case are often confidential: the company's internal rules decide whether they may pass through an external AI service.

Examples

A logistics SME in the canton of Bern buys route-optimisation software. It invests CHF 45'000 excluding VAT in year 0 for the licence, implementation and training. The software saves fuel costs and overtime. These gross benefits amount to CHF 30'000 in the first year, CHF 25'000 in the second and CHF 20'000 in the third.

Cost Net benefit (return)

Cost
CHF 45'000
Total benefit
Net benefit
CHF 30'000
CHF 75'000
Reference: the cost
ROI = 30'000 ÷ 45'000 66.7%

Return on investment

Cumulative ROI of route optimisation over three years

ItemAmount (CHF)
Initial investment (year 0): licence, implementation, training45'000
Gross benefit in year 1 (fuel and overtime avoided)30'000
Gross benefit in year 225'000
Gross benefit in year 320'000
Total gross benefit over 3 years (30'000 + 25'000 + 20'000)75'000
Net benefit (75'000 − 45'000)30'000
ROI = net benefit ÷ cost = 30'000 ÷ 45'00066.7%
The net benefit of CHF 30'000 set against the cost of CHF 45'000 gives a cumulative ROI of 66.7% over three years. This is a total for the period: the annualised ROI is about 18.6% per year.

If the benefits arrived in reverse order (CHF 20'000 then 25'000 then 30'000), the ROI would stay at 66.7%. The payback period, the internal rate of return and the net present value would change.

Visualisations

The ROI deliverable is a table: the cost, the benefits of each year, their total, the net benefit and the ratio. The analyst keeps it in a spreadsheet. The two bars of the example show the ratio by their length: the net benefit is the part of the second bar that exceeds the cost. The table of the two profiles shows one limit of ROI: two different cash-flow schedules give the same ratio.

Cost

PhaseLevelRationale
PreparationLow to mediumWhen a cost-benefit analysis exists, ROI adds only a division. Without that table, the analyst must establish a defensible gain and a total cost of ownership.
ExecutionLowA subtraction and a division in a spreadsheet: the fastest calculation in financial analysis.
DocumentationLowThe percentage, its two inputs, the horizon and whether the gain is gross or net.

Tools

A spreadsheet is enough in most cases. One cell calculates the ROI. The result recalculates as soon as a figure changes. In Excel, the RRI function returns the annualised ROI. The IRR and NPV functions return the internal rate of return and the net present value from the same cash flows. The analyst varies a gain or cost cell, then Scenario Manager compares the cautious, median and optimistic sets. The decision-maker thus sees how far the percentage depends on the assumptions.

The investment case or business case template usually carries the ROI line next to the payback period and the net present value. All three read off the same cash-flow table and can disagree: ROI gives the relative return, the payback period gives the speed, net present value gives a verdict that accounts for time. Project portfolio management tools calculate the ROI of dozens of candidates for a first screening. Below that volume, the spreadsheet does the same work without a licence. An ROI copied into a presentation no longer recalculates when an estimate changes: the team keeps the figure in the workbook that holds the assumptions.

Sources

Retrospectives
All techniques
Reviews