Cost Benefit Analysis Calculator

What Is Cost Benefit Analysis and When Do Organizations Use It?

Cost benefit analysis (CBA) is a structured appraisal method that converts every expected impact of a project into money terms, discounts those amounts to present value, and compares total benefits against total costs. A project passes the test when discounted benefits exceed discounted costs. Governments apply the method to infrastructure, environmental, and health programs under OMB Circular A-94, while corporations use the same arithmetic to screen capital expenditures, product launches, and plant expansions.

The method earns its place in decision-making because raw totals mislead. A project that returns $1,000,000 over ten years is not equivalent to one that returns $1,000,000 next year. Discounting converts each future cash flow into its present equivalent, so proposals with different timing, different lives, and different cost structures can compete on a level field.

Organizations typically commission a CBA when:

• Capital outlays are large relative to available budgets and several mutually exclusive options exist.
• Regulatory rules require documented economic justification for public spending.
• Benefits arrive over many years while costs concentrate up front.
• Stakeholders need a transparent, auditable record of the assumptions behind an approval.

The output is a small set of metrics: net present value (NPV), the benefit-cost ratio (BCR), the payback period, and the internal rate of return (IRR) that serves as the break-even discount rate.

Core Formulas: NPV, BCR, and Discounted Payback

Three formulas carry most of the analytical weight in a cost benefit analysis.

Net Present Value (NPV) sums every discounted flow over the analysis horizon:

NPV = Sum over t of (Bt - Ct) / (1 + r)^t

where Bt is the benefit in year t, Ct is the cost in year t, and r is the discount rate. Costs include the initial outlay at t = 0. A positive NPV means the project creates value after recovering its cost of capital.

Benefit-Cost Ratio (BCR) divides the present value of all benefits by the present value of all costs:

BCR = PV(Benefits) / PV(Costs)

A BCR above 1.0 mirrors a positive NPV; a BCR of 1.25 signals $1.25 of discounted benefit per $1.00 of discounted cost. BCR is useful for ranking projects when the capital budget is fixed, because it measures value created per dollar committed.

Payback Period measures recovery speed. Simple payback divides the initial outlay by the average annual net benefit. Discounted payback runs the same accumulation on discounted flows, asking when cumulative present value first turns positive. Discounted payback is always longer, and it exposes projects that recover their cost only after most of their value has been eroded by the discount rate.

The three metrics interlock. NPV greater than zero is equivalent to BCR greater than 1.0, and both hold whenever the IRR exceeds the chosen discount rate. Reporting all of them gives decision makers the absolute value created, the efficiency per dollar, and the timing risk.

Worked Example: Municipal Water Treatment Upgrade

Consider a municipality evaluating a $2,000,000 water treatment upgrade. The engineering study projects $650,000 in yearly benefits (energy savings, chemical reduction, and avoided emergency repairs) against $90,000 in annual operating and maintenance costs, over a 5-year evaluation horizon. The finance office discounts at 7% per year. The calculator arrives at the following result:

Step 1. Net annual flow: 650,000 - 90,000 = 560,000 per year.
Step 2. Five-year annuity factor at 7%: (1 - 1.07^-5) / 0.07 = 4.1002.
Step 3. PV of benefits: 650,000 x 4.1002 = 2,665,128.
Step 4. PV of operating costs: 90,000 x 4.1002 = 369,018, so PV of all costs = 2,000,000 + 369,018 = 2,369,018.
Step 5. NPV: 2,665,128 - 2,369,018 = 296,111.
Step 6. BCR: 2,665,128 / 2,369,018 = 1.125.
Step 7. Simple payback: 2,000,000 / 560,000 = 3.57 years.
Step 8. Discounted payback: cumulative discounted flow crosses zero during year 5, at 4.26 years.

The year-by-year ledger below shows how the cumulative discounted position builds toward the $296,111 surplus.

The project clears every screen: positive NPV, BCR of 1.125, and full recovery of the outlay within the evaluation horizon on a discounted basis.

Choosing the Discount Rate: OMB Circular A-94 and Market Benchmarks

The discount rate is the single most influential assumption in any CBA, and federal practice does not leave it to analyst discretion. OMB Circular A-94 (Guidelines and Discount Rates for Benefit-Cost Analysis of Federal Programs) governs the rate for United States federal program analysis. The 1992 version of the circular used a default real discount rate of 7%, reflecting the opportunity cost of private capital, while cost-effectiveness and lease-purchase studies drew on Treasury yield based rates published in its appendices. The November 2023 revision moved the primary rate to a real social rate of time preference of 2%, grounded in long-term Treasury yields, and requires sensitivity testing across a range of rates in every analysis.

Three practical rules follow from the federal guidance and from standard corporate practice:

• Match the rate to the funding source. Tax-financed public projects use the social discount rate; debt-financed corporate projects use the after-tax weighted average cost of capital.
• Keep the rate and flows consistent in price terms. Real (inflation-adjusted) flows take a real rate; nominal flows take a nominal rate. Mixing the two is a common arithmetic error.
• Test a range, not a point. Because small rate changes can flip a marginally positive NPV, every submission should show results at low, base, and high rates.

For private-sector analyses, the discount rate usually starts from the firm's WACC and is adjusted upward for project-specific risk. GAO's Cost Estimating and Assessment Guide adds a related discipline for public projects: document the basis for every rate and every cost estimate so reviewers can reproduce the result.

Sensitivity Analysis: Testing NPV Across Discount Rates

Sensitivity analysis asks how the verdict changes when a key assumption moves. The discount rate is the natural first candidate because it compounds against every future year. Re-running the worked example across rates from 3% to 10% produces the following profile:

NPV falls as the rate rises, from $564,636 at 3% to $122,841 at 10%, yet the project stays positive across the entire tested range. The rate at which NPV reaches exactly zero is the project's IRR. Setting the required annuity factor equal to 2,000,000 / 560,000 = 3.5714 and solving across five years places the break-even rate at about 12.4%. Only if the municipality's opportunity cost of funds rose above that level would the upgrade fail the test.

Good sensitivity practice extends beyond the discount rate. Analysts normally vary benefit levels (a 10% to 20% haircut), construction cost (a 15% to 25% overrun), and the horizon (dropping the final year) and report a small table of combined pessimistic cases. If the project survives all of them, the recommendation carries real credibility; if it flips negative in one plausible case, that case should be named and managed.

Identifying, Quantifying, and Valuing Costs and Benefits

The arithmetic is only as good as the inputs, so itemizing costs and benefits deserves as much care as the discounting itself. A defensible ledger separates each item by type and assigns a valuation method to it.

Three valuation disciplines matter most. First, use opportunity cost, not accounting cost: the price of land a city already owns is what that land could earn in its next best use, not its historical book value. Second, count benefits once. A travel-time saving can feed household budgets or business productivity, never both. Third, monetize non-market goods with recognized methods (revealed preference for time and safety, stated preference for environmental qualities) rather than invented numbers. The Department of Transportation's benefit-cost analysis guidance publishes standard unit values for time savings and crash reductions that many agencies adopt by reference.

Sunk costs deserve explicit exclusion. Money already spent on feasibility studies or aborted designs is gone under every alternative, so it cannot differ between options and must not enter the comparison. Including it only distorts the ratio of future value to future commitment.

How Cost Benefit Analysis Compares With CEA, ROI, and Payback

CBA is one member of a family of appraisal tools, and each has a niche where it outperforms the others.

The distinctions are practical, not cosmetic. A hospital deciding between two diagnostic devices with identical clinical outcomes needs cost effectiveness analysis, because the benefit side is fixed and only cost varies. A retailer judging a seasonal promotion can rely on ROI because the cash flows compress into a short, well-defined window. A transportation agency comparing a highway bypass against a rail upgrade, where benefits span decades and include non-market effects, needs full CBA with sensitivity testing.

When uncertainty about monetization is high, a common compromise is to present CBA on the monetizable core and attach a cost effectiveness annex for the remainder. Decision makers then see both the dollar verdict and the physical outcome per dollar, and can weigh the unpriced effects against their own priorities rather than against an analyst's conversion rate.

Common Pitfalls and How to Avoid Them

Most failed cost benefit studies stumble on a short list of recurring errors, each of which is avoidable with a checklist:

• Counting the same benefit twice. A training program cannot simultaneously claim higher graduate wages and the employer productivity those wages pay for. Build the ledger bottom-up from distinct impacts.
• Optimism bias in benefits and costs. Forecasts drift upward because advocates prepare them. Correct with reference-class data: how did similar projects perform against their own forecasts?
• Mismatched horizons. Truncating a project's life just before its largest benefits arrive biases the comparison. Set the horizon by asset life and disclose the residual value treatment.
• Ignoring distribution of effects. A positive aggregate NPV can hide concentrated losses on one group. Report who gains and who pays, especially for public projects.
• Treating risk by padding the discount rate. Adjusting the rate for risk double-counts what cash-flow scenarios already capture. Model risk in the flows and keep the rate tied to the funding source.
• Forgetting the do-nothing baseline. Every figure should be incremental to the counterfactual, which may itself involve deteriorating service or rising maintenance costs.

A final discipline is documentation. Each assumption (rate, horizon, unit values, growth rates) should carry a one-line source and a sensitivity note, so a reviewer can reproduce every headline number. Analyses built this way survive audits and budget hearings; analyses built on undocumented optimism do not.