Cost-Benefit Analysis
Learn how to do a cost-benefit analysis step by step: define the baseline, model incremental costs and benefits, apply the cost-benefit analysis formula, test uncertainty, and turn the evidence into a reviewable project decision.
Cost-benefit analysis definition: a CBA is a structured way to compare an action with a baseline by estimating its incremental costs and benefits, converting them to a common unit, discounting future values to the present, and testing whether the conclusion survives uncertainty. Positive net present value and a benefit-cost ratio above 1 support an option under the stated assumptions, but legal, ethical, safety, distributional, and strategic constraints can still affect the decision. Gixo Business uses the figures and evidence you supply to structure a decision brief; it does not invent market data, prices, or outcomes.
What a cost-benefit analysis is—and is not
A cost-benefit analysis compares the world with a proposed action to the world without it. That “without” case is the baseline or counterfactual. The model should count only incremental effects caused by the decision, not costs and benefits that would occur anyway. If there are several feasible alternatives, compare each against the same baseline.
Perspective determines what counts. A company analysis may focus on cash flows, employee time, customer outcomes, and risk borne by the business. A public-sector benefit cost analysis may include effects on citizens, other agencies, the environment, or society. State the perspective before collecting data so a transfer between groups is not accidentally treated as a net gain.
CBA is broader than a budget forecast and different from return on investment. A budget asks whether the organization can fund an option. ROI expresses return relative to cost. Cost- effectiveness analysis compares ways to reach a fixed outcome when benefits should not or cannot be monetized. A weighted decision matrix handles qualitative criteria. These methods can support the same decision without being interchangeable.
What Goes Into a Cost-Benefit Analysis?
A complete CBA weighs one-time and recurring costs against tangible and intangible benefits, then accounts for time and uncertainty before you decide.
List one-time costs (purchase, setup, migration), recurring costs (licences, maintenance, staff time), and indirect costs (disruption, opportunity cost). You supply the figures; a full inventory keeps the analysis honest.
Capture tangible benefits (added revenue, cost savings, hours reclaimed) and hard-to-value effects (risk, morale, service quality, brand). Monetize only where a defensible method exists; otherwise report the effect separately.
Money next year is worth less than money today. Apply a discount rate to future costs and benefits to get present values, so a five-year payoff is compared fairly against an upfront spend.
Net benefit is total benefits minus total costs; the benefit-cost ratio is benefits divided by costs. Gixo computes both totals from the numbers you enter — arithmetic on your inputs, not invented figures.
Estimates are uncertain. Flex the key assumptions — best case, worst case, likely case — to see whether the decision flips. A CBA that only survives its rosiest inputs is a warning, not a green light.
Gixo Business assembles your inputs into a block-based brief — KPI blocks for net benefit and ratio, a Comparison Table for the options, and a recommendation section you review before you present or export to PDF.
How to do a cost-benefit analysis in eight steps
A defensible project cost-benefit analysis makes the baseline, scope, timing, valuation methods, sources, assumptions, and uncertainty visible—not just the final ratio.
Write one decision question, specify what happens without the project, list feasible options, identify whose costs and benefits count, and record constraints that cannot be traded away.
Cover the useful life, major transition period, and material residual effects. Use either real amounts with a real discount rate or nominal amounts with inflation and a nominal rate; do not mix the two.
List capital, implementation, operating, maintenance, training, disruption, decommissioning, and opportunity costs alongside revenue, savings, productivity, risk reduction, service, residual, and option-value benefits. Mark possible overlaps.
Estimate units such as hours, incidents, customers, errors, tonnes, transactions, or downtime. Separate quantity assumptions from monetary values so reviewers can challenge either input without rebuilding the model.
Use observed prices, loaded labor rates, avoided replacement cost, expected loss, or another defensible method. Record source, date, units, rationale, confidence, and limitations; do not force every social or ethical effect into a weak dollar proxy.
Assign every cash flow or valued impact to the period when it occurs, then convert future amounts to present value. Include terminal, residual, and decommissioning values where material.
Calculate present values, NPV, BCR, and any useful ROI, payback, or break-even metrics. Vary pivotal inputs individually, compare coherent scenarios, and use probabilistic analysis when the decision warrants it.
Explain which option creates the greatest defensible value, what could change the answer, which effects remain unmonetized, who owns each benefit, and when actual results will be compared with the business case.
Cost-benefit analysis formula and key metrics
A formula is only as reliable as the baseline, inputs, timing, and valuation behind it. Keep the calculation transparent enough for another reviewer to reproduce.
| Metric | Formula | Interpretation and caution |
|---|---|---|
| Present value (PV) | PV = FV ÷ (1 + r)t | Converts a future value (FV) in period t to today using discount rate r. |
| Net present value (NPV) | NPV = Σ[(Bt − Ct) ÷ (1 + r)t] | Positive NPV supports the option under the assumptions. For mutually exclusive options, incremental NPV is usually more informative than ratio alone. |
| Benefit-cost ratio (BCR) | BCR = PV of benefits ÷ PV of costs | A ratio above 1 means discounted benefits exceed discounted costs. Ratios can favor a smaller project even when another option creates more total value. |
| Return on investment (ROI) | ROI = net benefit ÷ total cost × 100% | A useful relative-return measure, but the simple version does not express when benefits occur. |
| Payback period | Time until cumulative benefits recover cumulative costs | Shows liquidity and exposure duration but ignores later value unless paired with NPV. |
| Break-even point | Input value at which NPV = 0 or BCR = 1 | Reveals the threshold for adoption, utilization, price, savings, or another pivotal assumption. |
A Worked Cost-Benefit Analysis Example
Say you are weighing a $20,000 automation tool. These are illustrative numbers you would replace with your own — Gixo does the arithmetic on whatever you enter.
| Line item | Type | Year 1 value (your estimate) |
|---|---|---|
| Software licence + setup | Cost | $20,000 |
| Staff time to implement | Cost | $6,000 |
| Hours reclaimed (500 hrs × $60) | Benefit | $30,000 |
| Error / rework reduction | Benefit | $8,000 |
| Net benefit (benefits − costs) | Result | $12,000 |
| Benefit-cost ratio (38,000 ÷ 26,000) | Result | 1.46 |
On these one-year assumptions, the ratio of 1.46 and positive net benefit support the purchase. The conclusion is not yet a final recommendation: implementation timing, recurring costs, adoption, displacement of other work, and sensitivity to the “hours reclaimed” estimate still need review.
Cost-benefit analysis template and worksheet structure
A good cost-benefit analysis worksheet is an audit trail, not just a cost-benefit analysis chart. It connects each result to a quantity, unit value, source, timing assumption, and owner.
| Worksheet area | Fields to include | Quality check |
|---|---|---|
| Decision frame | Decision question, baseline, alternatives, perspective, constraints, analyst, review date | Would two reviewers model the same decision? |
| Model settings | Start date, horizon, period, currency, real or nominal basis, discount rate, inflation, tax treatment | Are units and conventions consistent? |
| Impact register | Impact, cost or benefit, affected group, incremental quantity, unit, timing, overlap flag | Is every material effect represented once? |
| Valuation | Unit value, valuation method, source link, source date, rationale, confidence, limitation | Could a reviewer reproduce the estimate? |
| Results | PV costs, PV benefits, NPV, BCR, ROI, payback, break-even, non-monetized impacts | Are results shown by option and scenario? |
| Decision record | Recommendation, pivotal assumptions, distributional effects, owner, milestones, reappraisal date | Does the model lead to an accountable action? |
A cost-benefit analysis Excel template should normally separate input, calculation, result, scenario, and documentation tabs. Use formula cells rather than typed totals, label every unit, keep source links beside inputs, protect or visually distinguish calculated cells, and include control checks for missing values, signs, duplicate effects, and totals. This guidance describes the structure of a spreadsheet; it is not a downloadable Excel file.
Cost-benefit analysis in project management
In project management, CBA is not a one-time approval document. During project selection it compares the status quo with viable alternatives. In the business case it establishes expected economics and key assumptions. At stage gates it tests whether new cost, schedule, adoption, and risk information has changed the case. After implementation it supports benefits realization by comparing actual outcomes with the approved baseline.
Assign ownership to benefits, not only tasks
For each material benefit, name the operational owner, measurement method, baseline value, target, realization date, dependency, and reporting cadence. A project can finish on time and still fail its economic case if users do not adopt the process, savings are not captured, or another team bears the implementation cost.
Reappraise when the decision changes
Revisit the analysis when scope, delivery date, cost, regulation, demand, useful life, or a pivotal assumption changes materially. Compare remaining future costs and benefits at that point; sunk costs may explain history but should not automatically justify continuation.
How to value difficult benefits and risks
| Impact | Possible method | Important caution |
|---|---|---|
| Time saving | Hours saved × loaded hourly rate × realistic utilization | Time has financial value only if capacity is redeployed, avoided, or produces additional outcomes. |
| Risk reduction | Change in probability × consequence, modeled as expected loss | Do not hide catastrophic or safety risks behind an average value; show severity and tail exposure separately. |
| Error or downtime avoided | Expected incidents × duration or units × verified cost per incident | Use a credible baseline and avoid counting the same saving in productivity and revenue. |
| Residual value | Expected sale, reuse, or remaining service value at the horizon | Discount it and subtract disposal, decommissioning, or restoration obligations. |
| Option value | Value of preserving a future choice, often supported by scenario or decision-tree analysis | Do not add a speculative premium without a transparent method. |
| Service, equity, safety, or environmental effects | Defensible shadow price, avoided-cost method, or separate quantitative/qualitative score | Some effects should remain visible outside the monetary total rather than receive false precision. |
Sensitivity, scenarios, and risk cost-benefit analysis
Sensitivity analysis changes one assumption at a time to find what drives the answer. Test adoption, volume, price, delay, useful life, labor rate, savings, residual value, and discount rate over credible ranges. Report the break-even value for the most important variable.
Scenario analysis changes a coherent set of assumptions together. A base case, downside case, upside case, and delay case are often more meaningful than mechanically moving every input by the same percentage. Each scenario should tell a plausible operational story.
Probabilistic analysis, including Monte Carlo simulation, assigns distributions to uncertain inputs and estimates the range of NPV or the probability that NPV is positive. It is useful for consequential decisions with multiple interacting uncertainties, but its output is only as credible as the chosen distributions and dependencies.
Pros and cons of cost-benefit analysis
| Advantages | Limitations |
|---|---|
| Creates a common framework for comparing unlike effects | Monetization can imply precision that the evidence does not support |
| Makes timing, assumptions, and trade-offs explicit | The answer changes with the baseline, perspective, horizon, and discount rate |
| Supports comparison, prioritization, and later benefits tracking | Distributional, ethical, safety, and strategic effects can be obscured by one total |
| Exposes break-even points and pivotal risks | Large uncertain models can become opaque or easy to manipulate |
Common cost-benefit analysis mistakes
- No explicit baseline: counting total future benefits rather than the change caused by the project.
- Ignoring opportunity cost: treating committed people, space, capital, or management attention as free.
- Double counting: recording time saved, cost saved, and additional output when they describe the same effect.
- Mixing units or price bases: combining real cash flows with a nominal rate, annual values with monthly values, or gross with net amounts.
- Using ROI as a substitute for NPV: ignoring scale, timing, or mutually exclusive alternatives.
- Forcing every effect into money: hiding important non-monetized impacts behind an arbitrary proxy.
- Presenting one deterministic case: omitting sensitivity, scenarios, break-even points, and confidence in the evidence.
- Stopping at approval: failing to assign benefit owners, measure actual results, or update the case at stage gates.
Cost-Benefit Analysis vs ROI vs a Decision Matrix
CBA, ROI, and decision matrices answer related but different questions. Use the one that fits how your options and criteria are shaped.
| Aspect | Cost-Benefit Analysis | ROI | Decision Matrix |
|---|---|---|---|
| Core question | Which option creates the greatest defensible net benefit versus a common baseline? | What return is produced relative to investment? | Which option scores best across weighted criteria? |
| Output | NPV, benefit-cost ratio, and supporting metrics | A percentage | A weighted score per option |
| Handles time value | Yes, through discounting | Not in the simple ROI formula | Not inherently |
| Handles hard-to-monetize effects | Report separately or value with a defensible method | Poorly | Yes, as scored criteria |
| Compares alternatives | Yes, against one consistent baseline | Yes, if calculated consistently | Yes, in one scoring model |
| Best when | Material costs and benefits can be quantified over time | A quick relative financial return is sufficient | Criteria are mixed or hard to monetize |
When your options are hard to reduce to dollars, a decision matrix pairs well with a CBA — score the qualitative criteria there, run the numbers here.