Cost-Benefit Analysis: NPV, BCR Formula & HR Examples

Positive NPV indicates benefits exceed costs; the project is worthwhile.

Summarise this post with:

Cost-Benefit Analysis is a systematic framework for evaluating whether an investment is worthwhile by quantifying expected costs and benefits in monetary terms, using Net Present Value (NPV), Benefit-Cost Ratio (BCR), and Internal Rate of Return (IRR) as decision criteria.

Image showing the meaning of Cost-Benefit Analysis

The three core cba decision criteria

CBA uses three primary criteria. Mature analyses present all three:

Net present value (npv)

The difference between present value of expected benefits and costs over the project’s lifetime:

NPV = Sum of [(Bt – Ct) / (1 + r)^t] for t = 0 to n

Where Bt = benefits in year t, Ct = costs in year t, r = discount rate, n = project lifetime. Positive NPV indicates benefits exceed costs; the project is worthwhile.

Benefit-cost ratio (bcr)

BCR = PV of Benefits / PV of Costs

BCR greater than 1.0 indicates positive return. Particularly useful when comparing multiple projects against a fixed budget; higher BCR projects deliver more benefit per dollar invested.

Internal rate of return (irr)

The discount rate at which NPV equals zero. A project’s IRR is compared to the organisation’s hurdle rate or cost of capital; projects with IRR above the hurdle rate are accepted. IRR is intuitive (expressed as a percentage) but can produce multiple values for non-standard cash flow patterns and doesn’t reflect scale.

Worked example: HR training investment

Scenario: A company evaluates a $200,000 investment in a leadership development program. Expected benefits over 4 years: $80,000/year from reduced turnover, $30,000/year from improved productivity, $20,000/year from internal promotion (reduced external hiring cost). Discount rate: 8%.

Calculate annual benefits

Annual benefits = $80,000 + $30,000 + $20,000 = $130,000

Calculate present value of benefits

Year 1: $130,000 / 1.08^1 = $120,370
Year 2: $130,000 / 1.08^2 = $111,454
Year 3: $130,000 / 1.08^3 = $103,198
Year 4: $130,000 / 1.08^4 = $95,554
Total PV of benefits: $430,576

Calculate npv and bcr

NPV: $430,576 – $200,000 = $230,576 (positive, project is worthwhile)
BCR: $430,576 / $200,000 = 2.15 (every dollar invested produces $2.15 in present-value benefits)

Cba in HR contexts: where it’s applied

Training and development programs. Costs: design, delivery, materials, employee time. Benefits: improved productivity, reduced errors, retention, internal mobility.
Wellness programs. Costs: program design, vendor, employee time. Benefits: reduced healthcare costs, reduced absenteeism. Health Affairs: $2.73-$3.27 per dollar invested.
HR technology investments. Costs: licensing, implementation, training, maintenance. Benefits: HR efficiency, time saved, improved analytics, compliance risk reduction.
Retention bonuses. Costs: bonus payments. Benefits: avoided turnover cost (typically 50-200% of annual salary per departure per SHRM research).
Talent acquisition channel investment. Comparing sourcing channels on cost-per-hire and quality-of-hire dimensions.
Compensation structure changes. Cost of pay increases vs benefits from improved retention, attraction, and engagement.
Employee benefits expansion. Cost of new benefit vs benefits in retention, engagement, and employer brand.
DEI investments. Cost of programs vs benefits in talent attraction, retention, innovation, compliance, and customer perception.

8-step cba framework

1. Define the project / decision clearly. What investment is being evaluated? What is the alternative (often: do nothing)?

Identify all costs and benefits. Direct, indirect, opportunity costs. Direct, indirect, downstream benefits. Tangible and intangible.
Quantify costs and benefits in monetary terms. Direct costs typically straightforward. Benefits often require estimation with conservative assumptions.
Choose the analysis period. Typically 3-7 years for HR programs.
Select discount rate. Typically the organisation’s weighted average cost of capital (WACC) or hurdle rate.
Calculate NPV, BCR, and IRR. Use a spreadsheet (Excel NPV / IRR functions); document assumptions clearly.
Conduct sensitivity analysis. How sensitive is the result to changes in key assumptions? Run optimistic, base, and pessimistic scenarios.
Report results and recommendation. Present NPV, BCR, IRR, sensitivity analysis, and intangible considerations. Make a clear recommendation.

Common cba mistakes

Overstating benefits. Optimistic benefit assumptions inflate the case. Conservative estimates supported by data are more credible.
Understating costs. Implementation, ongoing operations, opportunity costs, change management, employee time, all routinely underestimated.
Ignoring opportunity costs. What else could the same investment achieve?
Wrong discount rate. Too low makes everything look attractive; too high rejects sound investments.
No sensitivity analysis. Point-estimate NPVs ignore the range of plausible outcomes.
Confirmation bias. Building the CBA to justify a decision already made.
Failure to track post-implementation. CBA assumes future benefits will materialise; tracking actual realisation disciplines future CBAs.

See also Cost Per Hire for a specific HR cost concept, Cost to Company (CTC) for compensation costs, Change Management for benefits realisation, and Big Data in HR for analytics enablement.

Frequently asked questions

Cost-benefit analysis (CBA) is a systematic framework for evaluating whether a proposed investment, project, or policy decision is worthwhile by quantifying expected costs and benefits in monetary terms and comparing them, with adjustment for the time value of money. Uses three primary criteria: Net Present Value (NPV), Benefit-Cost Ratio (BCR), and Internal Rate of Return (IRR). Also called benefit-cost analysis or BCA.

NPV = Sum of [(Bt – Ct) / (1 + r)^t] for t = 0 to n. Where Bt = benefits in year t, Ct = costs in year t, r = discount rate, n = project lifetime. Calculate the difference between benefits and costs in each year, divide by (1 + r) raised to the power of the year number to discount to present value, then sum across all years. Positive NPV means the project is worthwhile in present-value terms.

BCR = PV of Benefits / PV of Costs. The ratio of present value of benefits to present value of costs. BCR greater than 1.0 indicates positive return; the higher the BCR, the more attractive the project per unit of cost. BCR is particularly useful when comparing multiple projects against a fixed budget. BCR and NPV typically lead to the same accept/reject decision but can rank projects differently when budgets are constrained.

8 steps: (1) Define the project and the alternative (usually do nothing). (2) Identify all costs (direct, indirect, opportunity) and benefits (tangible, intangible). (3) Quantify costs and benefits in monetary terms using historical data and conservative assumptions. (4) Choose the analysis period (3-7 years typical for HR). (5) Select discount rate (typically organisation’s cost of capital). (6) Calculate NPV, BCR, and IRR. (7) Conduct sensitivity analysis on key uncertain variables. (8) Report results with clear recommendation. Track actual outcomes post-implementation.

Training and development programs, wellness programs (Health Affairs: $2.73-$3.27 per dollar invested in well-designed programs), HR technology investments, retention bonuses, talent acquisition channel investments, compensation structure changes, employee benefits expansion, office vs remote work models, and DEI investments. Any HR investment requiring business case justification benefits from structured CBA.

Both measure investment return but with different scope. ROI is a simple ratio: (Benefits – Costs) / Costs, typically as a percentage; doesn’t adjust for time value of money. CBA includes ROI-like calculation but with NPV adjustment for time value, multiple decision criteria (NPV, BCR, IRR), sensitivity analysis, and explicit treatment of intangible factors. CBA is more rigorous for significant investments and multi-year programs; ROI is simpler for short-horizon, point-in-time decisions.

Cost-Benefit Analysis