Benefit Cost Ratio

The spreadsheet will calculate the Benefit Cost Ratio based on the input provided. The following tables will be calculated.

An example of a benefit cost table is provided below.

Links to more information about this topic

A project is considered potentially viable if the Benefit/Cost Ratio is greater than 1.0. Any project with a ratio of less than 1.0 is considered uneconomic and would be abandoned.