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.

Benefit-Cost Analysis Spreadsheet Template for Discretionary Grant Programs

Document
USDOT BCA Spreadsheet Template 1.31.24.xlsx

Benefit-Cost Analysis Spreadsheet Template for Discretionary Grant Programs

*Note - This version dated 1/31/24 corrects a formula error in cells D12-D16 of the "Residual Value" sheet. Applicants who are not making use of those rows may continue to use the previous version dated 12/5/23. It also corrects a formula error in cells B23-B52 on the same sheet. Applicants using previous versions dated 12/5/23 and 1/4/24 should copy and paste the formula from this spreadsheet into the previous versions, or simply use this updated version dated 1/31/24.

DOT is committed to ensuring that information is available in appropriate alternative formats to meet the requirements of persons who have a disability. If you require an alternative version of files provided on this page, please contact jordan.riesenberg@dot.gov.
Last updated: Wednesday, January 31, 2024