USA Banner

Official US Government Icon

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure Site Icon

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Site Notification

Site Notification

U.S. Department of Transportation U.S. Department of Transportation Icon United States Department of Transportation United States Department of Transportation
FHWA Highway Safety Programs

Illinois Benefit-Cost Analysis (BCA) Spreadsheet


The Illinois Benefit-Cost Analysis (BCA) spreadsheet provides a quantitative method for evaluating and comparing the cost-effectiveness of proposals for roadway improvements. This tool consists of two parts: 1) input data, and 2) output data.

  • Input Data: The input data includes five components, which are project type selection, project information entry, project input, crash data input, and countermeasure selection. Users can select from a list of predefined countermeasures or input user-defined countermeasures. The tool allows for users to input crash modification factors (CMFs) for countermeasures. State-specific or national CMFs can be added into the system from research results or the CMF Clearinghouse.
  • Output Data: The output data component consists of four applications, which calculate the benefit-cost ratio, develop summary tables, export data to a new spreadsheet, and clean all sheets.
Tool Type:
Owner Source:

The tool is available free of charge at the following link: Illinois BCA Spreadsheet.
The user manual is available at: Illinois BCA User Manual.


This information is disseminated under the sponsorship of the U.S. Department of Transportation in the interest of information exchange. The U.S. Government assumes no liability for the use of the information contained herein. This information does not constitute a standard, specification, or regulation. The U.S. Government does not endorse products or manufacturers. Trademarks or manufacturer's names appear in this information only because they are considered essential to the objective of this publication.

Any opinions, findings, and conclusions or recommendations, and translations thereof, expressed in this publication are those of the author(s) and do not necessarily reflect the views of the Federal Highway Administration.