Using Excel's cost-benefit analysis formula, you can compare several projects and find out which one to implement. As a result of the NPV model, the project with the highest NPV is selected.

How do you calculate ROI in cost benefit analysis? A Return on Investment is calculated by dividing the net benefits by the total cost. How does ROI information help the customer as part of business ...

Leonard, Dutch, and Richard Zeckhauser. "Cost-Benefit Analysis Applied to Risks: Its Philosophy and Legitimacy." In Values at Risk, edited by Douglas MacLean. Totowa, NJ: Roman & Allanheld, 1985.