Better Buildings C Better Buildings Challenge Financial Ally Reportin

---

Overview

Product Descriptions
Project Reporting 20121231
Portfolio Reporting 20121231
Data Validation Lists

---

Sheet 1: Product Descriptions

Better Buildings Challenge

OMB 1910-5141

Financial Ally Reporting

Expiration date: 8/31/2015

Product Description - Both Portfolio and Project Investments

Background: DOE would like to provide semi‐annual updates on the success of Better Buildings Challenge Financial Allies to fund energy efficiency projects. Please complete a column of this form for each investment product that you offer. The information may be published on the program website.

Financial Ally Name

Extend the table to additional Products as required

Product A

Product B

Product C

Product D

Product E

Product F

Product G

Product or Investment Designation (replace placeholder)

Product A

Product B

Product C

Product D

Product E

Product F

Product G

Date of Submission to Better Buildings Challenge

Please describe the financial product or investment fund.

General Description

What sort of asset owners is the product or fund aimed to serve?

Target Market / Description of Customers / Building Owners

What sort of investors is the product or fund aimed to serve?

Target Market / Description of Customers / Investors

Describe the market barriers that this product or fund is designed to overcome, and the innovation it utilizes

Barriers Overcome and Means

What are the benefits to building owners, and how are they accrued?

Value Proposition to Asset Owners

What are the benefits to investors, and how are they accrued?

Value Proposition to Investors

Describe any elements that provide additional security to investors and stakeholders, including collateral, nature of repayment method, debt service reserves, insurance, etc.

Risk Management

Describe who receives the value of energy savings, how it is calculated, whether values are assumptions, projections, or actuals, whether there are guarantees, shared savings, or insurance,and the structure of payments, as applicable

Method of Assigning the Value of Energy Savings

Describe the method used for calculating energy savings that you will use to report estimated projected energy savings to DOE (minimums set forth in contracts, engineering estimates, specific assumptions of savings per square foot, etc.)

Method of Calculating Energy Savings

Describe the period for which the product agreement is in effect, with any pertinent conditions or other bounds

Term

Public reporting burden for this collection of information is estimated to average 30 minutes per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to Office of the Chief Information Officer, Records Management Division, IM-23, Paperwork Reduction Project (1910-5141), U.S. Department of Energy, 1000 Independence Ave SW, Washington, DC, 20585-1290; and to the Office of Management and Budget (OMB), OIRA, Paperwork Reduction Project (1910-5141), Washington, DC 20503. In furtherance of the objectives of the Better Buildings Challenge, the Department of Energy (DOE) intends to publicly post information submitted in response to this template on the Better Buildings Challenge website. Information submitted to DOE will be handled in accordance with all applicable federal laws, rules, or regulations, including but not limited to the Trade Secrets Act, 18 U.S.C. §1905, and the Freedom of Information Act (FOIA), 5 U.S.C. §552, and DOE's implementing regulations at 10 CFR 1004. Participation in the Better Buildings Challenge is voluntary. Do not include any personal or confidential commercial and financial information in response to this template. Commercial and financial information is considered to be confidential when its release would be likely either to harm the submitterís commercial interests or to affect the agencyís ability to obtain information in the future. This statement serves as your written notice that DOE intends to publicly post this information. By submitting information in response to this template, you are certifying that this information does not contain confidential commercial or financial information.

---

Sheet 2: Project Reporting 20121231

Better Buildings Challenge

OMB 1910-5141

Financial Ally Reporting

Expiration date: 8/31/2015

Periodic Update for Completed Transactions

Individual Project Investments

Background: DOE would like to provide semi‐annual updates on the success of Better Buildings Challenge Financial Allies to fund energy efficiency projects. Please complete a copy of this form for each reporting period. The information provided will be published on the program website.

Financial Ally Name

Reporting Period Start Date

Reporting Period End Date

Form Submission Date

Select a unique identifier for each project or transaction

Select from the Products already designated in "Product Descriptions" tab

Select the number of buildings in the project. If 5 or fewer, please provide details on each; if More Than 5, aggregate all buildings into a single line (Building 1)

Building Description

For projects that aggregate multiple buildings, use the address of one of the centrally-located buildings

Select from the CBECS Building Use categories. For multi-use buildings, select the dominant use.

Financial Aspects

Total Project Cost is the sum of the preceding cells

Projected Annual Energy Savings

Energy Conservation Measures

Identify the measures implemented in the building(s) to improve efficiency and reduce overall energy consumption, to the degree possible.

Project Designation

Product Type

Number of Buildings in Project

Number of Buildings (per line)

Street Address

State

Zip Code

Building Owner Name

Primary Use

Square Feet

Funds Invested through Financial Ally

Building Owner Capital Employed

Incentives / Subsidies Captured

Other Sources of Financing

Total Project Cost

Cost Savings ($'s)

kWh Savings

Heating, Ventilation, Air-Conditioning (HVAC)

Building Envelope (including windows, doors, roof, insulation, etc.)

Controls (including energy management control systems, sensor, etc.)

Lighting

Active Building Management (including software services, continuous commissioning, equipment maintenance, operator training, occupant education, etc.)

On-Site Renewable Generation

Combined Heat & Power Generation

Other measures

Building 1 (or aggregation of all buildings if greater than 5)

$-

Building 2

$-

Building 3

$-

Building 4

$-

Building 5

$-

Building 1 (or aggregation of all buildings if greater than 5)

$-

Building 2

$-

Building 3

$-

Building 4

$-

Building 5

$-

Building 1 (or aggregation of all buildings if greater than 5)

$-

Building 2

$-

Building 3

$-

Building 4

$-

Building 5

$-

Building 1 (or aggregation of all buildings if greater than 5)

$-

Building 2

$-

Building 3

$-

Building 4

$-

Building 5

$-

Building 1 (or aggregation of all buildings if greater than 5)

$-

Building 2

$-

Building 3

$-

Building 4

$-

Building 5

$-

Building 1 (or aggregation of all buildings if greater than 5)

$-

Building 2

$-

Building 3

$-

Building 4

$-

Building 5

$-

Building 1 (or aggregation of all buildings if greater than 5)

$-

Building 2

$-

Building 3

$-

Building 4

$-

Building 5

$-

Building 1 (or aggregation of all buildings if greater than 5)

$-

Building 2

$-

Building 3

$-

Building 4

$-

Building 5

$-

Building 1 (or aggregation of all buildings if greater than 5)

$-

Building 2

$-

Building 3

$-

Building 4

$-

Building 5

$-

Building 1 (or aggregation of all buildings if greater than 5)

$-

Building 2

$-

Building 3

$-

Building 4

$-

Building 5

$-

Building 1 (or aggregation of all buildings if greater than 5)

$-

Building 2

$-

Building 3

$-

Building 4

$-

Building 5

$-

Building 1 (or aggregation of all buildings if greater than 5)

$-

Building 2

$-

Building 3

$-

Building 4

$-

Building 5

$-

Building 1 (or aggregation of all buildings if greater than 5)

$-

Building 2

$-

Building 3

$-

Building 4

$-

Building 5

$-

Building 1 (or aggregation of all buildings if greater than 5)

$-

Building 2

$-

Building 3

$-

Building 4

$-

Building 5

$-

Building 1 (or aggregation of all buildings if greater than 5)

$-

Building 2

$-

Building 3

$-

Building 4

$-

Building 5

$-

Building 1 (or aggregation of all buildings if greater than 5)

$-

Building 2

$-

Building 3

$-

Building 4

$-

Building 5

$-

Building 1 (or aggregation of all buildings if greater than 5)

$-

Building 2

$-

Building 3

$-

Building 4

$-

Building 5

$-

Public reporting burden for this collection of information is estimated to average 30 minutes per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to Office of the Chief Information Officer, Records Management Division, IM-23, Paperwork Reduction Project (1910-5141), U.S. Department of Energy, 1000 Independence Ave SW, Washington, DC, 20585-1290; and to the Office of Management and Budget (OMB), OIRA, Paperwork Reduction Project (1910-5141), Washington, DC 20503. In furtherance of the objectives of the Better Buildings Challenge, the Department of Energy (DOE) intends to publicly post information submitted in response to this template on the Better Buildings Challenge website. Information submitted to DOE will be handled in accordance with all applicable federal laws, rules, or regulations, including but not limited to the Trade Secrets Act, 18 U.S.C. §1905, and the Freedom of Information Act (FOIA), 5 U.S.C. §552, and DOE's implementing regulations at 10 CFR 1004. Participation in the Better Buildings Challenge is voluntary. Do not include any personal or confidential commercial and financial information in response to this template. Commercial and financial information is considered to be confidential when its release would be likely either to harm the submitterís commercial interests or to affect the agencyís ability to obtain information in the future. This statement serves as your written notice that DOE intends to publicly post this information. By submitting information in response to this template, you are certifying that this information does not contain confidential commercial or financial information.

---

Sheet 3: Portfolio Reporting 20121231

Better Buildings Challenge

OMB 1910-5141

Financial Ally Reporting

Expiration date: 8/31/2015

Periodic Update for Completed Transactions

Portfolio Investments

Background: DOE would like to provide semi‐annual updates on the success of Better Buildings Challenge Financial Allies to fund energy efficiency projects. Please complete a copy of this form for each reporting period. The information provided will be published on the program website.

Financial Ally Name

Reporting Period Start Date

Reporting Period End Date

Form Submission Date

Investment / Project Aspects

Select from the Products already designated in "Product Descriptions" tab

Please attempt to describe where the funds are to be invested. If the funds are to be invested across more than 5 states, select "More than 5 States" and aggregate data in the line for State 1. If 5 or fewer States, select "5 or Fewer States", and provide details broken out by each state.

Select from the CBECS Building Use categories. For multi-use buildings, select the dominant use.

Per building, total will be generated from # of buildings * sq ft

Calculation = Number of Buildings * Square Feet per Building

Financial Aspects

Estimated or typical, aggregated

Estimated or typical, aggregated

Estimated or typical, aggregated

Estimated or typical, aggregated

Calculation = Sum of Ally funds, Owner funds, Incentives and Other

Projected Annual Energy Savings

Energy Conservation Measures

Identify the measures implemented in the building(s) to improve efficiency and reduce overall energy consumption, to the degree possible.

Specific Investment / Project Identifier (replace placeholder below)

Product Type

Total Number of States in which Funds will be Invested

State

Number of Buildings (estimate if unknown)

Approximate percentage of funds by State

Building Owner (if identifiable)

Primary Use

Average Square Feet per Building

Total Square Feet, All Buildings

Funds Invested through Financial Ally

Building Owner Capital Employed

Incentives / Subsidies Captured

Other Sources of Financing

Description of Other Sources of Funding

Total Project Cost

Dollars

kWh

Heating, Ventilation, Air-Conditioning (HVAC)

Building Envelope (including windows, doors, roof, insulation, etc.)

Controls (including energy management control systems, sensor, etc.)

Lighting

Active Building Management (including software services, continuous commissioning, equipment maintenance, operator training, occupant education, etc.)

On-Site Renewable Generation

Combined Heat & Power Generation

Other measures

Investment 1

State 1 (or complete aggregation if >5 States)

-

$-

State 2

-

$-

State 3

-

$-

State 4

-

$-

State 5

-

$-

Investment 2

State 1 (or complete aggregation if >5 States)

-

$-

State 2

-

$-

State 3

-

$-

State 4

-

$-

State 5

-

$-

Investment 3

State 1 (or complete aggregation if >5 States)

-

$-

State 2

-

$-

State 3

-

$-

State 4

-

$-

State 5

-

$-

Investment 4

State 1 (or complete aggregation if >5 States)

-

$-

State 2

-

$-

State 3

-

$-

State 4

-

$-

State 5

-

$-

Investment 5

State 1 (or complete aggregation if >5 States)

-

$-

State 2

-

$-

State 3

-

$-

State 4

-

$-

State 5

-

$-

Investment 6

State 1 (or complete aggregation if >5 States)

-

$-

State 2

-

$-

State 3

-

$-

State 4

-

$-

State 5

-

$-

Investment 7

State 1 (or complete aggregation if >5 States)

-

$-

State 2

-

$-

State 3

-

$-

State 4

-

$-

State 5

-

$-

Investment 8

State 1 (or complete aggregation if >5 States)

-

$-

State 2

-

$-

State 3

-

$-

State 4

-

$-

State 5

-

$-

Investment 9

State 1 (or complete aggregation if >5 States)

-

$-

State 2

-

$-

State 3

-

$-

State 4

-

$-

State 5

-

$-

Investment 10

State 1 (or complete aggregation if >5 States)

-

$-

State 2

-

$-

State 3

-

$-

State 4

-

$-

State 5

-

$-

Investment 11

State 1 (or complete aggregation if >5 States)

-

$-

State 2

-

$-

State 3

-

$-

State 4

-

$-

State 5

-

$-

Investment 12

State 1 (or complete aggregation if >5 States)

-

$-

State 2

-

$-

State 3

-

$-

State 4

-

$-

State 5

-

$-

Investment 13

State 1 (or complete aggregation if >5 States)

-

$-

State 2

-

$-

State 3

-

$-

State 4

-

$-

State 5

-

$-

Investment 14

State 1 (or complete aggregation if >5 States)

-

$-

State 2

-

$-

State 3

-

$-

State 4

-

$-

State 5

-

$-

Investment 15

State 1 (or complete aggregation if >5 States)

-

$-

State 2

-

$-

State 3

-

$-

State 4

-

$-

State 5

-

$-

Investment 16

State 1 (or complete aggregation if >5 States)

-

$-

State 2

-

$-

State 3

-

$-

State 4

-

$-

State 5

-

$-

Investment 17

State 1 (or complete aggregation if >5 States)

-

$-

State 2

-

$-

State 3

-

$-

State 4

-

$-

State 5

-

$-

Public reporting burden for this collection of information is estimated to average 30 minutes per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to Office of the Chief Information Officer, Records Management Division, IM-23, Paperwork Reduction Project (1910-5141), U.S. Department of Energy, 1000 Independence Ave SW, Washington, DC, 20585-1290; and to the Office of Management and Budget (OMB), OIRA, Paperwork Reduction Project (1910-5141), Washington, DC 20503. In furtherance of the objectives of the Better Buildings Challenge, the Department of Energy (DOE) intends to publicly post information submitted in response to this template on the Better Buildings Challenge website. Information submitted to DOE will be handled in accordance with all applicable federal laws, rules, or regulations, including but not limited to the Trade Secrets Act, 18 U.S.C. §1905, and the Freedom of Information Act (FOIA), 5 U.S.C. §552, and DOE's implementing regulations at 10 CFR 1004. Participation in the Better Buildings Challenge is voluntary. Do not include any personal or confidential commercial and financial information in response to this template. Commercial and financial information is considered to be confidential when its release would be likely either to harm the submitterís commercial interests or to affect the agencyís ability to obtain information in the future. This statement serves as your written notice that DOE intends to publicly post this information. By submitting information in response to this template, you are certifying that this information does not contain confidential commercial or financial information.

---

Sheet 4: Data Validation Lists

DO NOT CHANGE THIS SHEET
	These lists are used in data validation of cells elsewhere in this workbook -- altering them will affect these other cells
		Ally List	State List	Building Use List	Product Type List	Number of Buildings / States List
		AFL-CIO	AL	Education	Product A	1
		Abundant Power	AK	Food Sales	Product B	2
		Blue Hill Partners	AZ	Food Service	Product C	3
		Citi	AR	Health Care	Product D	4
		Clean Fund	CA	Inpatient	Product E	5
		Energi	CO	Outpatient	Product F	More than 5
		GE Capital	CT	Lodging	Product G
		Green Campus Partners	DE	Retail (Other Than Mall)	0
		Greenwood Energy	FL	Retail (Mall)	0
		Metrus Energy	GA	Office
		Renewable Funding	HI	Public Assembly
		Samas Capital	ID	Public Order and Safety
		SCIEnergy	IL	Religious Worship
		Ygrene Energy	IN	Service
			IA	Warehouse and Storage
			KS	Other
			KY	Vacant
			LA
			ME
			MD
			MA
			MI
			MN
			MS
			MO
			MT
			NE
			NV
			NH
			NJ
			NM
			NY
			NC
			ND
			OH
			OK
			OR
			PA
			PR
			RI
			SC
			SD
			TN
			TX
			UT
			VT
			VA
			WA
			WV
			WI
			WY