The Building Upgrade Value Calculator, developed by the U.S. EPA, is a product of the partnership between ENERGY STAR, BOMA International, and the BOMA Foundation. This calculator was developed as part of BOMA’s Energy Efficiency Program (BEEP), a series of courses designed to help commercial real estate practitioners improve their buildings’ energy efficiency performance. The calculator tool was developed to help property professionals assess the financial value of investments in a property’s energy performance and is part of the BEEP course 5 Valuing Energy Enhancement Projects & Financial Returns .
The Building Upgrade Value Calculator estimates the financial impact of proposed investments in energy efficiency in office properties. The calculations are based on data input by the user, representing scenarios and conditions present at their properties. Required inputs are limited to general characteristics of the building, plus information on the proposed investments in energy efficiency upgrades.
The calculator’s analysis includes the following information:
In addition to the above outputs, the calculator also estimates the impact the proposed changes will have on a property’s ENERGY STAR rating.
The tool provides two ways to use its calculations: users can save and print a summary of their results, or generate a letter that highlights the financial value for use as part of a capital investment proposal.
This tool requires a download of two files, one Microsoft Excel file and one Word file. Please note the criteria for use of these files:
Note: This tool is not available for users with Macintosh computers running Microsoft Office software.
The EPA will periodically update and revise the tool. In order to download the current version, please register your email address, which will permit the EPA to send you a notice when an updated version of this tool has been released.
(Your email address will be kept confidential)
Select the software version you wish to download.
When prompted, choose to "Enable Macros" to continue to the main screen. Choosing "Disable Macros" will open the file, but navigation and calculation functions will not be available.
Macro security may be turned off if a screen such as shown in above is not encountered. However, if a message such as “The macros in this project are disabled” is received upon attempting to use the tool, Excel macro security is set to the “High” level. To change this, choose Tools > Macro > Security… from the pull-down menu. Under the tab marked “Security Level”, choose the “Medium” security and choose “OK.” The file will need to be closed and reopened in order to use the functionality of the tool.
NOTE: This file MUST be saved in the same directory as the Excel tool file selected in Step 2 or the tool will be unable to generate the customized letter with your inputs and results.