HomeMy WebLinkAboutBetter Buildings Financing Data Collection 09-27-2010
Better Buildings Proposed Reporting Metrics
8/30/2010
Contact Andrew.Chang@ee.doe.gov
*All reporting is assumed to be quarterly unless otherwise specified.
*Any fields that are already ARRA-required and are reported to federalreporting.gov will not need to be re-submitted to BetterBuildings directly.
COLOR KEY
Grantee SourceUtility Source
Privacy GuaranteedFinancial Institution Source
Voluntary ReportingDOE Analysis
Monthly ReportingInput Only Once
Programmatic DataRationale
List of credit enhancement (drop
Types of financing program options being offered and criteria needed to be eligible (target
down)
audience)
Loan type / repayment (drop down)
Building type (drop down)
Capital Source (drop down)
Financing
Min/max: FICO, annual income, debt-to-income ratio, loan-
Underwriting Criteria
to-value ratio, savings-to-investment ratio, combined loan-
to-value ratio, bankruptcy within X years, and other criteria
Secondary Market (drop down)
Individual Unit Data
Credit enhancement (drop down)Loan origination information
Loan Type /repayment (drop down)
Building type (drop down)
Capital Source (drop down)
Unique ID
Zipcode
Loan originator
Origination Date
Interest Rate (%)
Compounding Period (# of times per year)
Loan Term (# of Months)
With an understanding that there are multiple approaches to assess credit quality, we will only
require the data that lending institution uses to assess credit quality. No additional data
collection is required.
Annual Income ($)
Credit Score (FICO)
Residential
Debt-to-income ratio
Property Valuation (# or n/a)
Property Valuation Source
Utility bill payment history
Mortgage payment history
Outstanding Mortgage debt? ($)
Outstanding Home equity line? ($)
Outstanding other debt? ($)
Existing liens on property? ($)
Loan-to-value ratio
Combined loan-to-value ratio
Previous bankruptcy, repossession, foreclosure?
(Y/N)
Financing Origination Data
Gas utility account number and permission form
Electricity utility account number and permission
form
Credit enhancement (drop down)Loan origination information
Loan type / repayment (drop down)
Building type (drop down)
Capital Source (drop down)
Unique ID
Zipcode
Loan originator
Origination Date
Interest Rate (%)
Compounding Period (# of times per year)
Financing Loan Data
Loan Term (# of Months)
(track as relevant for your
With an understanding that there are multiple approaches to assess credit quality, we will only
program)
require the data that lending institution uses to assess credit quality. No additional data
Earnings ($)collection is required.
Corporate credit rating
Commercial
Credit rating agency
Tenant occupied building? (yes/no)
Financing Origination Data
Financing Loan Data
(track as relevant for your
program)
Commercial
Property Valuation (# or n/a)
Property Valuation Source
Date of loan sale (for loans sold to secondary
investors)
Loan-to-value ratio
Combined loan-to-value ratio
Outstanding Mortgage debt? ($)
Previous bankruptcy, repossession, foreclosure?
(Y/N)
Gas utility account number and permission form
Electricity utility account number and permission
form
Date payment dueLoan payment history is needed to highlight performance of loans
Date of actual payment
Payment history
Payment due ($)
Actual payment ($)
Date of charge-off
Charge-offs
Charge-off ($)
Date of pre-payment
Number of months prepaid
Early/prepayment
Financing Performance Data
Prepayment Penalty Assessed ($)
Pre-payment ($)
Date of foreclosure
Foreclosure
Foreclosure ($)
Lender Loss Experienced ($)
Servicing Loan servicer
Collection protocol
Stability rating
Rating agency
Total Project Cost
Amount of financing under Better Buildings program
Amount of financing ($)
Other sources of financing
Source of financing
Total Retrofit Cost Rebates received and source
Amount of rebates ($)
Source of rebates
Amount of tax credit ($)
Tax credits received and source
Source of tax credits
Owner direct contribution
Other costs
Loan Applicants Rejected Reason