Net present value

Calculates the absolute difference between the present value of monetised benefits and the present value of resource costs.

Signature

NPV = 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
NPVMonetised benefits remaining after resource costs are subtractedcurrency in the stated price year

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 net present value

    Excel subtracts present-value costs from present-value benefits using named ranges.

    =PVBenefits-PVCosts

Assumptions

  • Credible baseline

    Costs and benefits are measured incrementally against a baseline that represents what would occur without the evaluated option.

  • Consistent analytical perspective

    Included costs and benefits follow the same stated perspective and affected population.

  • Common monetary basis

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

  • No double counting

    Overlapping consequences and transfers are identified so that the same social effect is not counted more than once.

Worked examples

  • Net present value of an option

    An option has present-value benefits of £251,505 and present-value resource costs of £133,168. Its net present value is £118,337.

    NPV = 251505 - 133168 = 118337

Common errors

  • Treating positive NPV as an adoption decision

    A positive net present value indicates positive monetised net social value under the stated assumptions but does not establish affordability or require adoption.

Sources

  • HM Treasury Green Book

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

    View source

Canonical Identity

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