Cash Flow Calculator

The Cash Flow Calculator allows users to develop a preliminary analysis of the cost effectiveness of an energy efficiency retrofit by comparing cash flows of various funding scenarios. The cost of inaction is illustrated to help building owners identify the impact to their budget if a project is delayed.

Four scenarios are provided:

  1. Appropriation awarded on year five,
  2. Loan taken immediately,
  3. Loan taken after a five year delay, and
  4. No action.

The cash flows are based on user inputs and a series of assumptions. Where significant to the user, the assumptions are either incorporated as a note visible when the user hovers over the cell or as a note in a separate cell. The tool is intended to be a starting point in the analysis of various funding options.

The calculator is to be used by project developers, facility managers, and others who will assist facility owners in deciding whether to pursue an energy retrofit project or not and defining what funding source will be cost effective.

The calculator is also intended to be used after the facility receives an energy audit, so the user can refer to the audit for the annual energy expenditure and credible estimates for project cost and annual energy savings.

For more information, contact:

Michael Spencer
Alaska Housing Finance Corporation
Research & Rural Development