U.S. flag
        An official website of the United States government
          Here’s how you know
        Here’s how you know
        world globe
        Languages
      EnglishEspañolFrançaisKreyòlTiếng Việt简体中文한국어 **Official websites use .gov** A **.gov** website belongs to an official government organization in the United States.
 **Secure .gov websites use HTTPS** A **lock** (
A locked padlock
) or **https://** means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.
              .
  Apply for Assistance


                Toggle Menu

    close
            Disasters & Assistance
                  
                                                      Current DisastersCalifornia Severe StormsHermit's Peak/Calf Canyon FireMaine Severe StormsMichigan Severe StormsRhode Island Severe Storms (December 2023)Rhode Island Severe Storms (January 2024)Washington WildfiresWildfire ActionsWrangell Cooperative Association Severe StormAll Disaster Declarations
Assistance After a DisasterGovernments and Private Non-ProfitsIndividuals and Families
Tools to RecoverCommon RumorsDisaster Multimedia ToolkitDisaster-Related FAQFEMA in Your LanguageSave Your Family TreasuresVolunteer & Donate
General Disaster InformationSearch Your LocationHow a Disaster Gets DeclaredDisaster AuthoritiesHistoric DisastersGrants
                  
                                                      FEMA GrantsPreparedness GrantsHazard Mitigation Assistance GrantsResilience GrantsContinuing Training Grants ProgramEmergency Food and Shelter ProgramShelter and Services Program
Policy & GuidanceProcurement & Contracting"Buy America" PreferenceBipartisan Infrastructure LawLow-Carbon Goals2 CFR Policy Updates
ToolsAuthorized Equipment ListBenefit-Cost AnalysisEnvironmental & Historic Preservation GuidanceFEMA Grants Outcomes (FEMA GO)Grants Management Technical AssistanceNon-Disaster Grants Management SystemFloods & Maps
                  
                                                      Flood InsuranceFind an Insurance FormWork with National Flood InsuranceNFIP’s Pricing ApproachInsurance Outreach PublicationsRules and LegislationFlood Insurance Advocate
Floodplain ManagementManage Floodplain RiskGet Financial HelpCommunity Assistance Program for StatesCommunity Rating SystemFloodplains & Wildlife ConservationIntergovernmental Collaboration
Flood MapsFlood Data Viewers & Geospatial DataChange Your Flood Zone DesignationRisk MAPProducts and ToolsGuidance & ReportsCooperating Technical Partners
Know Your RiskHomeowners, Renters or Business OwnersCommunity OfficialsEngineers, Surveyors or ArchitectsReal Estate, Lending or Insurance ProfessionalsState, Local, Tribal or Territorial GovernmentsEmergency Management
                  
                                                      National PreparednessTraining & EducationNational Incident Management System (NIMS)National Planning FrameworksNational Preparedness GoalContinuity Resource ToolkitEquityExercises
Risk ManagementHazard Mitigation PlanningClimate ResilienceBuilding ScienceEarthquake RiskDam SafetyHurricane, Wind & Water Surge HazardsHazardous Response Capabilities
Tools for PractitionersIntegrated Public Alert & Warning System (IPAWS)Planning GuidesCommunity LifelinesEnvironmental Planning & Historic PreservationRecovery ResourcesCase Study LibraryPrepTalks
Individuals & CommunitiesPreparedness Activities, Research & WebinarsFaith-Based & Volunteer Partnership ResourcesYouth & Emergency PlanningCommunity Emergency Response Team (CERT)Activities to Reduce Risk for Your HomeAbout
                  
                                                      About UsHow FEMA WorksStrategic PlanOffices & LeadershipRegions, States & TerritoriesTribal AffairsHow to Pay FEMAHistory of FEMAContact Us
NewsroomBlogEventsFact SheetsFEMA LiveMobile ProductsNewslettersPress ReleasesPodcastSocial Media
Reports & DataAnnual ReportsData VisualizationsDisaster Relief Fund ReportsFEMA Guidance DocumentsGlossaryOpenFEMAResilience Analysis & Planning Tool
FEMA in ActionWe Are FEMADisaster ResilienceTwenty Years Later: 9/11Work With Us
                  
                                                      CareersBenefitsCareer PathsHow to ApplyRecruitment EventsFEMA Employee Resources
Business and OrganizationsDoing Business with FEMANational Business Emergency Operations Center
PartnershipsCommunity Disaster Resilience ZonesEmergency Manager ExchangeFederal Agency Mission AssignmentsResilient Nation Partnership NetworkApply for Assistance

world globe
        Languages
      EnglishEspañolFrançaisKreyòlTiếng Việt简体中文한국어  Tools
              
              
                                                                                                                                                                                                                                                                                                                                                                              
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    

              Benefit-Cost Analysis
                          Benefit-Cost Analysis

                      How to Perform a Full BCA
                  
                                        
                    
          
                    
                            
                                        
                    
          
                    
                            
                                        
                    
          
                    
                            
                                                    How to Complete a Streamlined BCA
                                                                      News & Notes
                                                Resources
                                                Training Materials
                              
                                                            Authorized Equipment List
                                                                                  Environmental & Historic Preservation Guidance
                                                        FEMA Grants Outcomes (FEMA GO)
                                                        Grants Management Technical Assistance
                                                        Non-Disaster Grants Management System
          How to Perform a Full BCA
world globeEnglish
This page provides guidance and instructions for the entire process of performing a full BCA using the BCA Toolkit, from download and installation of the BCA Add-In to exporting and attaching your completed BCA to your project subapplication.



Unless you use a methodology that does not require you to use the BCA  Toolkit, you will need to have the BCA Toolkit installed on your computer.



BCA Toolkit Download and Installation Requirements



For All Users



Graphic of a web network of people



Click the “Download BCA Toolkit Version 6.0 Template” button and open the Excel file.



Download BCA Toolkit Version 6.0 TemplateDownload Link Icon



For FEMA Users



Icon from Excel of the FEMA BCA V6.0 Add-In



Do not follow the instructions below. Instead, either (a) open the BCA Toolkit  6.0 template and select the FEMA BCA 6.0 icon in the top ribbon, or (b) download the Add-in from the FEMA Software Center, which will write a folder with the template file and some instructions to your desktop.



For Non-FEMA Users



Icon of an Excel document



Select the button below to view or access a printable file that explains how to install the BCA Toolkit for Excel Desktop or Excel Online.



BCA Toolkit 6.0 Excel Installation Instructions



System Requirements and BCA Toolkit Environments



The BCA Toolkit is an add-in for Microsoft Excel. The Add-in performs the best when using Excel 2016 or later. The BCA Toolkit can be run in one of two user environments:



Excel Online via an internet browserExcel Desktop via a computer that runs Excel



View instructions for both methods.



Within both environments, there is capability to import and export BCA files as a zip file, Excel Workbook, and as text. Therefore, both environments allow exported BCA files to be attached to a project subapplication in FEMA GO.



Note:



Excel 2016 build numbers follow the format, “16.0.*major number.minor number”.* Exporting a zip file is available only for Excel Online and for Microsoft 365 versions of Excel Desktop with a major Note: Excel 2016 build numbers follow the format, “16.0.*major number.minor number”.*



Exporting a zip file is available only for Excel Online and for Microsoft 365 versions of Excel Desktop with a major build number greater than or equal to 13628. Excel Desktop users with major build numbers lower than 13628 will have the option to export a BCA file to an Excel Workbook or text within the Excel template.



See the help content for how to determine your Excel build number.



Due to different agency security settings, some users will not be able to access the BCA Toolkit Excel Add-in via their computers and will have to use Excel Online. If a user does not have a Microsoft 365 subscription, Microsoft offers users the ability to create a free account and use a free version of Excel Online.



Subapplicants should find out what their Applicant agency’s (State’s, Tribe’s, or Territory’s) preferred exported BCA file format is because that may determine which environment is best for performing a BCA. For example, if the Applicant agency only accepts exported zip files, all subapplicants under that Applicant must use either Excel Online or an Excel major build version greater than or equal to 13628.



Generating BCA reports also varies depending on the user environments. Reports can be generated as a PDF file when using either Excel Online or a Microsoft 365 build version greater than or equal to 13628. If you are using other versions of Excel, BCA reports will be written to a worksheet in the template file, which can be printed as a normal worksheet from Excel.



Important:



It is advisable to **save a copy of the file to your local hard drive** by selecting File, then Save As, then Download a Copy, and then choose the option for Open with Microsoft Excel. Once the file opens, select File and then Save As, and save a copy to your local machine. Excel will maintain the file in Excel Online and will maintain a version history, which can be viewed with the file open in Excel Online. To open a file from your local hard drive in Excel Online, select Upload a Workbook and navigate to the file you wish to upload.
Last updated May 5, 2023

            Return to top Disasters & Assistance
      
    
                  Grants
      
    
                  Floods & Maps
      
    
                  Emergency Management
      
    
                  About
      
    
                  Work With Us

Facebook

          Instagram


          Twitter

          YouTube

          LinkedIn

          Newsletter

        Contact FEMA

DHS logo
              FEMA.govAn official website of the U.S. Department of Homeland Security
          Accessibility
                Accountability
                Careers
                Civil Rights
                Contact Us
                FOIA
                Glossary
                No FEAR Act
                Plug-Ins
                Privacy
                Report Disaster Fraud
                Website Information
                DHS.gov
                USA.gov
                Inspector General