CDFI Form 0007 Allocatee TLR Excel Template

---

Overview

Notes-Investments
Disbursements
Projects
Addresses

---

Sheet 1: Notes-Investments

Submitter Transmission ID

Project Number

Originator Transaction ID

Date Originated

Original Loan/Investment Amount

Refinancing

Purpose

Construction or Permanent Financing

Take-Out Or Acquisition Financing

Acquisition or Rehabilitation

Rehabilitation Amount

Origination Fees

Transaction Type

Interest Rate

Interest Type

Points

Amortization Type

Period of Interest Only Payments (in months)

Term (in months)

Date First Payment Due

Guarantee

Lien Position

Collateral Type

Collateral Value at Origination

Equity-Like Features

Equity Injection Amount

Advance Purchase Commitment

Seller Organization

Equity Product

Equity-Equivalent Terms & Conditions

Debt with Equity Features

Subordinated Debt

Below Market Interest Rate

Comparable Interest Rate

Lower than Standard Origination Fees (Financial Note)

Standard Origination Fees (Financial Note)

Longer than Standard Period of Interest Only Payments

Standard Period Of Interest Only Payments (in months)

Longer than Standard Amortization Period

Standard Amortization Period (in months)

Nontraditional Forms of Collateral

Traditional Form Of Collateral

Loan Status

QLICI Level

Principal Balance Outstanding

Days Delinquent

Number of Times 60 Days or More Delinquent

Number of Times Loan was Restructured

Amount Charged Off

Amount Recovered

Fair Value at End of Reporting Period

---

Sheet 2: Disbursements

Originator Transaction ID

Not Yet Disbursed / Projected QEI

Disbursement ID

Disbursement Date

Total Disbursement Amount

Disbursement Source

Source Amount

---

Sheet 3: Projects

Project Number

Total Project Cost

Total Project Cost - Public Sources

Total Project Cost - Affiliates & Related Programs

Loan-to-Value Ratio

Debt Service Coverage Ratio

Loan Loss Reserve Requirement

Client ID

QLICI Type

Investee Type

Investee TIN

Date Business Established

Entity Structure

Minority Owned or Controlled

Women Owned or Controlled

Low Income Owned or Controlled

Gender

Race

Hispanic Origin

Credit Score

DS/FCOS Hours of Assistance at Time of Investment

Business Description

NAICS

SIC Code

Annual Gross Revenue from Business Operations at Time of Loan/Investment

Annual Gross Revenue and Business Operations Reported During the Reporting Period

Jobs at Time of Loan/Investment

Jobs at Reporting Period End

Projected Jobs to be Created at Businesses Financed

Projected Jobs to be Created - Construction

Projected Jobs to be Created at Tenant Businesses

Square Feet of Real Estate - Total

Square of Real Estate - Manufacturing

Square of Real Estate - Office

Square of Real Estate - Retail

Asking Rent per Square Foot

Housing Units - Sale

Housing Units - Rental

Affordable Housing Units - Sale

Affordable Housing Units - Rental

Community Facility

Capacity of Educational Community Facility

Capacity of Childcare Community Facility

Capacity of Healthcare Community Facility

Capacity of Arts Center Community Facility

Capacity of Other Community Facility

DS/FCOS Hours of Assistance Provided During Reporting Period

Other Impact (1) - Explain

Other Impact (1) - Number of Units

Other Impact (2) - Explain

Other Impact (2) - Number of Units

Investor TIN

QALICB Type

NMTC Eligibility Criteria

1990 FIPS Code

Related Entity

Below Market Interest Rate

Blended Interest Rate

Comparable Blended Interest Rate

Lower than Standard Origination Fees (Project)

Standard Origination Fees (Project)

Higher than Standard Loan to Value Ratio

Standard Loan-to-Value Ratio

More Flexible Borrower Credit Standards

Lower than Standard Debt Service Coverage Ratio

Standard Debt Service Coverage Ratio

Lower than Standard Loan Loss Reserve Requirement

Standard Loan Loss Reserve Requirement

Poverty Rates Greater than 30%

Median Income Less than 60% of Area Median Income

Unemployment at Least 1.5 Times the National Average

Designated for Redevelopment

Designated EZ, EC, or RC

SBA Designated HUB Zone

Designated Native American or Alaska Native Area, Hawaiian Homeland, or Redevelopment Area by Tribe or Other Authority

Brownfield Redevelopment Area

Encompassed by HOPE VI Redevelopment Plan

Located in a Hot Zone

Appalachian Regional Commission or Delta Regional Authority

Colonias

Medically Underserved Area

TIF District or Enterprise Zone Program

Other Areas of Higher Distress

---

Sheet 4: Addresses

Project Number

Investee Street Address Line 1

Investee Street Address Line 2

Investee City

Investee State

Investee Zip Code 5

Investee Zip Code +4

Project Street Address Line 1

Project Street Address Line 2

Project City

Project State

Project Zip Code 5

Project Zip Code +4