Benefit-cost analysis tool (IRP2-WP3)


In this work package we developed a Benefit: Cost Analysis (BCA) Tool tailored to assessing investments for water-sensitive cities. It is intended to support balanced and systematic decision making about these investments, and to provide evidence for use in business cases. The tool is based on sound economics and is fully consistent with guidelines prepared by Australian state and national governments.  The BCA Tool is part of a broader package of economic tools and resources, known as INFFEWS (Investment Framework For Economics of Water Sensitive cities).

For an outline of the features and flexibility of INFFEWS BCA Tool, download the Industry Note: Industry Note: INFFEWS Benefit: Cost Analysis Tool

INFFEWS is not publicly available, and the current version is being tested and applied by industry practitioners from CRCWSC Participant organisations.  The CRCWSC will provide the custom-built tool to non-members after INFFEWS training is completed.

Three different groups of users, with different needs, are envisaged for the tool.

Experienced economists. For this group, the aim is to provide a standard BCA tool that is flexible, convenient and easy to use. The tool should foster good BCA practice and enhance the comparability of different BCAs.

Non-economists who have been trained. For this group, the aim is to put BCA within the hands of sufficiently trained users who lack a previous background in economics. The tool should help these users avoid common errors and overcome challenges.

Managers who wish to understand BCA better. For this group, the aim is for them to become well-informed and effective purchasers of BCA services.


INFFEWS BCA Tool is made up of a package of documents, which should all be read in advance and continually referred to when undertaking the economic evaluation of your project.  The package consists of the following components:

  1. Benefit: Cost Analysis and Strategic Decision Making (pdf document): Covers BCA basics, guidance on strategic issues related to BCAs, and use of economic information, including BCAs, in strategic decision making.
  2. Rough BCA Tool - Guidelines (word document) and spreadsheet (excel): for a “Rough” BCA. This responds to the need for a very simple tool that captures the essence of BCA. It can also be useful as a first step towards conducting a full BCA.
  3. BCA Tool Spreadsheet (Excel): Captures qualitative and quantitative information, calculates BCA results and conducts sensitivity analysis to test the robustness of results.
  4. BCA Tool Guidelines (pdf document): Explains the structure and elements of the BCA Tool; information requirements and judgements needed to apply the tool; and suggested strategies for obtaining data for different parts of the tool.
  5. BCA Tool User Guide (pdf document): Provides a step-by-step process for entering the required information into the BCA Tool. Includes a template for capturing the qualitative aspects of that information.
  6. BCA Comparison Tool (excel): Makes it easy to compare the results from BCAs for multiple projects, or different versions of the same project.
  7. BCA Tool Training Resources.

Access to the INFFEWS BCA file (Excel Spreadsheet)

The updated 2020 version of the INFFEWS BCA file (Version 2020-05) is available for all to access.  However, each individual must register for a copy. We are keeping a record of who has obtained a copy and may contact you for your feedback.

To download a copy, CRCWSC members can click on the "Register Here" button below (please make sure you are logged in located at the top right hand corner of website).  You will be directed to a registration page to enter your details and accept the terms and conditions.  Once this form is submitted, you will be re-directed to the download page.

If you don't have a CRCWSC username and password, please complete the Request for Access to INFFEWS form and a copy will be emailed to you within 3 working days.  If any issues, email Tammie Harold at

As this file gets updated every 6 months we strongly encourage you to download a new version each time you want to conduct a BCA using INFFEWS.

Feedback or request for general assistance can be sent to

Last updated: 25th May 2020