Project ROI Calculator – Compare Multiple Projects

Calculate each project’s ROI, net benefit, annualized ROI, duration, and payback; then rank alternatives and see cost-weighted portfolio ROI.

Project inputs

Private by design: calculations, scenarios, and exports stay in this browser; the page does not upload your project values.

Calculation mode
Duration input
Inputs: Simple totals Duration: Dates Currency: £
Load example:

Enter the full project cost, including fees. Total benefit or ending value may include attributable revenue, cost savings, or recovered value. Do not enter net profit as the benefit.

Scenario analysis — conservative, expected, and optimistic

Apply percentage changes to each active project’s calculated costs and benefits. Expected leaves both unchanged.

ScenarioCost changeBenefit changePortfolio net benefitPortfolio ROIPayback
Conservative%%
Expected0%0%
Optimistic%%

Advertisement

Results

Total Project Cost
£0.00
Total Benefit
£0.00
Portfolio Net Benefit
£0.00
Portfolio ROI (cost-weighted)
0.00%
Calculate valid active projects to see the strongest result.
Per-project comparison results. Use a column heading to change the ranking.
RankProject / statusTotal benefitDuration
No calculated projects yet.
Project ROI comparison chart No valid active projects have been calculated.
+ Positive − Negative 0 Break-even
The center line is 0%. Bars extend right for gains and left for losses; every value is also listed in the accessible results table.
Inputs and assumptions

Calculate a project to prepare its input summary.

Calculation audit

Calculate a project to see formulas with its current values substituted.

How to compare project ROI

  1. Choose Simple totals for known total cost and benefit, or Project forecast for upfront and recurring amounts.
  2. Add projects, define their evaluation periods, and include all material costs and attributable benefits.
  3. Set an optional target ROI and ranking metric, then calculate. Correct any row-specific validation messages.
  4. Compare ROI with net benefit, annualized ROI, payback, scenarios, and the cost-weighted portfolio result before exporting.

Worked project ROI examples

The buttons above load these exact assumptions so you can audit each answer in the calculation panel.

Software implementation

£40,000 upfront + £1,000 monthly cost; £6,000 monthly savings for 2 years; £5,000 residual value. Cost £64,000, benefit £149,000, net benefit £85,000, ROI 132.81%, estimated payback 8 months.

Equipment purchase

£80,000 upfront + £500 monthly maintenance; £5,000 monthly savings for 3 years; £20,000 residual value. Cost £98,000, benefit £200,000, net benefit £102,000, ROI 104.08%, estimated payback 18 months.

Marketing campaign

£25,000 total cost and £36,000 attributable benefit over 6 months. Net benefit £11,000 and simple ROI 44%; annualized ROI is 107.36% when benefit is treated as an ending value.

Cost-saving initiative

£15,000 upfront + £250 monthly cost; £2,000 monthly savings for 18 months. Cost £19,500, benefit £36,000, net benefit £16,500, ROI 84.62%, estimated payback 9 months.

Project ROI formulas and variables

Variables: U = upfront cost, C = recurring cost per month, B = one-time benefit, R = recurring revenue or savings per month, m = evaluation months, V = residual value, TC = total cost, and TB = total benefit.

  • Total cost: TC = U + (C × m). In simple mode, TC = stated project cost + fees.
  • Total benefit: TB = B + (R × m) + V. In simple mode, it is the stated total benefit or ending value.
  • Net benefit: TB − TC.
  • Simple ROI: (TB − TC) ÷ TC × 100.
  • Annualized ROI: ((TB ÷ TC)^(1 ÷ years) − 1) × 100, only when benefit can reasonably be treated as an ending value.
  • Estimated payback: forecast mode uses U ÷ (R − C) months when monthly net benefit is positive; if a one-time benefit occurs at the start, it first reduces unrecovered upfront cost. Simple mode has no cash-flow schedule, so payback is not calculated.
  • Portfolio ROI: Σ net benefits ÷ Σ total costs × 100.

Portfolio ROI uses aggregate gains and costs, not the simple average of project percentages. That gives a £100,000 project proportionally more influence than a £1,000 project.

Amounts display to two decimals and percentages to two decimal places, while calculations retain full precision. Date duration uses 365.2425 days per year. Fees are added to simple-mode project cost. Inactive projects remain visible but are excluded from rankings, chart, scenarios, and portfolio totals.

What to include—and when ROI is not enough

Costs to include

Include implementation, labor, training, licenses, vendors, maintenance, financing fees, shutdown time, and opportunity cost where it can be estimated. Allocate shared costs using a documented driver such as labor hours, users, or revenue share.

Benefits that qualify

Use attributable revenue, contribution or gross profit where appropriate, avoided costs, productivity savings that can actually be redeployed, and recovered value. Use conservative attribution and do not count the same benefit twice.

Projected versus actual

Label forecasts as projected, record assumptions, then replace them with actual costs and realized benefits after launch. Compare the two to improve later estimates.

Negative and break-even

Negative ROI means measured benefits are below cost; break-even means they equal cost. Either may still support compliance, learning, safety, or strategy, but that rationale should be assessed separately.

Do not choose on ROI alone. A smaller project can have the highest percentage while creating less total value. Also consider scale, risk, capacity, strategic value, cash-flow timing, and mutually exclusive constraints. Use NPV for time value and IRR/XIRR for dated or staged cash flows.

Methodology and calculation checks

Maintained by: Starlight Robotics. Calculation version: 2.0. Last reviewed: 16 July 2026.

The calculator includes the inputs shown, adds simple-mode fees to total project cost, treats forecast recurring amounts as uniform monthly values, and uses undiscounted totals. It excludes taxes, inflation, financing schedules, probability, depreciation, and the time value of money. Annualized ROI is an ending-value rate, not IRR. Payback is a simplified estimate, not a dated cash-flow model.

Reference basis: the ROI ratio follows the net gain divided by investment cost convention described by the Corporate Finance Institute. For material or long-lived decisions, HM Treasury’s Green Book illustrates why appraisal should also address costs, benefits, risks, uncertainty, and discounting across time.

Published test cases

CaseInputsExpected result
Positive simple ROICost 100; benefit 120; 1 yearNet benefit 20; ROI 20%; annualized ROI 20%
Break-evenCost 100; benefit 100Net benefit 0; ROI 0%; explicit break-even status
Negative ROICost 100; benefit 75Net loss 25; ROI −25%
ForecastUpfront 1,000; monthly cost 100; monthly benefit 300; 12 monthsCost 2,200; benefit 3,600; net benefit 1,400; ROI 63.64%; payback 5 months

Educational information only; not financial, accounting, tax, or investment advice.

Project ROI calculator FAQs

What does project ROI mean?

Project ROI is net measured benefit divided by total project cost, expressed as a percentage. It shows efficiency, while net benefit shows the absolute value created or lost.

What counts as project cost?

Include all incremental and allocated costs needed to deliver and operate the project: labor, implementation, training, software, equipment, vendor fees, maintenance, and relevant overhead.

Does total benefit mean revenue or profit?

It can be attributable revenue, savings, or recovered value, but the definition must be consistent. Do not enter net profit as total benefit because this calculator subtracts project cost to derive net benefit.

How do I compare projects of different lengths?

Use annualized ROI only when total benefit is reasonably an ending value. For recurring or staged cash flows, compare NPV and IRR/XIRR instead.

Why is portfolio ROI different from average ROI?

Portfolio ROI divides combined net benefits by combined costs. A simple average gives a small project the same weight as a large one and can misstate the portfolio result.

How should I compare projected and actual ROI?

Save the same cost and benefit definitions for both, record forecast assumptions, and later replace projections with realized values. Explain material variances.

How should shared costs be handled?

Allocate them consistently using a defensible driver such as usage, headcount, labor hours, or revenue share, and document the method outside the calculator.

What does negative ROI mean?

Measured benefits are below measured costs. The project may still have strategic or mandatory value, but its financial result is a loss under the entered assumptions.

How is payback calculated?

Forecast mode estimates the months needed for recurring net benefit to recover upfront cost, after any assumed immediate one-time benefit. It does not discount cash flows.

When should I use NPV or IRR?

Use NPV when timing and the discount rate matter. Use IRR or XIRR for a sequence of periodic or dated cash flows. Simple ROI and annualization cannot replace those methods.

Explore more tools