Benefit-cost ratio

Calculates monetised benefits relative to resource costs when present-value resource costs are positive.

Signature

BCR = PV_B / PV_C
Inputs
InputsDefinitionUnit
PV_BPresent value of all included monetised benefits under the stated perspectivecurrency in the stated price year
PV_CPresent value of all included resource costs under the stated perspectivethe same currency and price year as PV_B
Output
BCRPresent-value monetised benefits per unit of present-value resource costratio

Function

Monetised cost-benefit comparison function

Maps the present values of monetised benefits and resource costs to measures of net social value and relative return.

Try this function

Implementations

  • Excel

    Calculate the benefit-cost ratio

    Excel divides present-value benefits by present-value resource costs using named ranges.

    =PVBenefits/PVCosts

Assumptions

  • Positive resource costs

    Present-value resource costs are greater than zero because the ratio is undefined when the denominator equals zero.

  • Consistent cost-benefit classification

    Items are classified consistently as resource costs or monetised benefits under the stated perspective.

  • Common monetary basis for the BCR

    Benefits and costs use the same currency, price year, time horizon and timing convention.

Worked examples

  • Benefit-cost ratio of an option

    An option has present-value benefits of £251,505 and present-value resource costs of £133,168. Its benefit-cost ratio is approximately 1.89.

    BCR = 251505 / 133168 = 1.89

Common errors

  • Ranking mutually exclusive options by BCR alone

    The option with the highest benefit-cost ratio may not produce the greatest net present value because programme scale can change the ranking.

Sources

  • HM Treasury Green Book for the BCR

    HM Treasury. The Green Book: appraisal and evaluation in central government.

    View source

Canonical Identity

Stable URI · Machine-readable · Resolvable · CC BY 4.0