Guerriero C, Papirio S, Pirozzi F, Ranzi A, Loria Rebolledo LE, Watson V. Case study: a realistic contaminated site remediation and different scenarios of intervention. In: Guerriero, C, editors. Cost-benefit analysis of environmental health interventions. London: United Kindgom. Academic Press; 2020. p.229-56. doi: 10.1016/B978-0-12-812885-5.00011-1


This chapter presents a practical case study illustrating step-by-step how to conduct a cost–benefit analysis (CBA) of remediating an industrial site in Mexico. The objective of the chapter is to guide the reader in the construction of a CBA using Excel. The case study described follows the order of the previous chapters. It starts with a description of the industrial site and the interventions available for remediation. The chapter describes how to perform each step of CBA in Excel from “defining the analysis” (Step 1) to “testing the sensitivity of the results” (Step 7). Each section is complemented with an Excel spreadsheet and solution file.

Share on: