Get documents about "Loan and Investment Agreement
W
Description
Loan and Investment Agreement document sample
Document Sample
Project or Excel Annual
64dd50c9-29a6-43fa-9f8c-1ea6624b8aea.xls - CDE QuickStart Borrower/
Financial Worksheet: New Field Mandatory Field is Conditionally Update Transaction Investee
CIIS TLR Data Field Note Field Column (CIIS 6.0) Field Required If… Compliance Required Type Purpose Type QLICI Type SPE Special Instructions
Project and Financial Note Identifiers
Submitter Transmission ID Notes-
Investments: A
Project Number P Projects: A Use "Project Number" to link Financial Notes to a Project.
"Project Number" must be consistent across report years.
In the Excel Template, "Project Number" is required on multiple
worksheets including, Notes-Investments: B and Addresses: A.
Numeric field with a maximum of 8 digits.
Originator Transaction ID FN Notes- "Originator Transaction ID" must be consistent across report
Investments: C years.
In the Excel Template, "Originator Transaction ID" is required on
multiple worksheets including Disbursements: A.
FINANCIAL NOTES DATA
Terms
Date Originated FN Notes-
Investments: D
Original Loan/Investment Amount FN Notes-
Investments: E
Refinancing FN Notes- Debt
Investments: F
Purpose FN Notes-
Investments: G
Construction or Permanent Financing FN Notes- Purpose = Real Real Estate
Investments: H
Estate -
Construction/Permanent/
Acquisition w/o Rehab-
Commercial
Take-out or Acquisition Financing FN Notes- Construction or Real Estate
Investments: I
Permanent Financing =
Permanent or Both
Construction and
Permanent
Acquisition or Rehabilitation FN Notes- Purpose = Real Real Estate
Investments: J
Estate - Rehabilitation -
Commercial
Rehabilitation Amount FN Notes- Acquisition or Real Estate
Investments: K
Rehabilitation =
Acquisition and
Rehabilitation
Origination Fees FN Notes- Transaction Type = Debt
Investments: L
Term Loan, Line of
Credit, or Debt with
Equity
Use of Origination Fees FN Notes- Origination Fees > 0 Debt Options include:
Investments: M • Allocatee’s Operating Costs
and Date Originated >
• Other CDE’s Operating Costs
12/31/2005
• Parent’s Operating Costs
• Community Development Activities
• Other
Transaction Type FN Notes-
Investments: N
Interest Rate at Origination FN Notes- Transaction Type = Debt
Investments: O
Term Loan, Line of
Credit, or Debt with
Equity and Date
Originated > 12/31/2005
Interest Rate FN Notes- Transaction Type = Debt
Investments: P
Term Loan, Line of
Credit, or Debt with
Equity
4/18/2011 Page 1 of 13
Project or Excel Annual
64dd50c9-29a6-43fa-9f8c-1ea6624b8aea.xls - CDE QuickStart Borrower/
Financial Worksheet: New Field Mandatory Field is Conditionally Update Transaction Investee
CIIS TLR Data Field Note Field Column (CIIS 6.0) Field Required If… Compliance Required Type Purpose Type QLICI Type SPE Special Instructions
Interest Type FN Notes- Transaction Type = Debt
Investments: Q
Term Loan, Line of
Credit, or Debt with
Equity
Points FN Notes- Transaction Type = Debt
Investments: R
Term Loan or Debt with
Equity
Amortization Type FN Notes- Transaction Type = Debt
Investments: S
Term Loan, Line of
Credit, or Debt with
Equity
Period of Interest Only Payments (in FN Notes- Transaction Type = Debt "Period of Interest Only Payments (in months)" is a numeric field
months) Investments: T with no decimals.
Term Loan
Term (in months) FN Notes- Transaction Type = Debt
Investments: U
Term Loan, Line of
Credit, or Debt with
Equity
Date First Payment Due FN Notes- Debt
Investments: V
Guarantee FN Notes- Transaction Type = Debt
Investments: W
Term Loan, Line of
Credit, or Debt with
Equity
Lien Position FN Notes- Transaction Type = Debt
Investments: X
Term Loan, Line of
Credit, or Debt with
Equity
Collateral Type FN Notes- Transaction Type = Debt
Investments: Y
Term Loan, Line of
Credit, or Debt with
Equity
Collateral Value at Origination FN Notes- Transaction Type = Debt
Investments: Z
Term Loan, Line of
Credit, or Debt with
Equity
Equity-Like Features FN Notes- Transaction Type = Debt with
Investments: AA Equity
Debt with Equity
Equity Injection Amount FN Notes-
Investments: AB
Advance Purchase Commitment FN Notes- QLICI Type = QALICB
Investments: AC
QALICB
Seller Organization FN Notes- Advance Purchase QALICB
Investments: AD
Commitment = Yes
Better Rates & Terms (FN)
Equity Product FN Notes-
Investments: AE
Equity-Equivalent Terms & Conditions FN Notes-
Investments: AF
Debt with Equity Features FN Notes- Validation: If Debt with Equity Features = YES AND Transaction
Investments: AG Type = Term Loan or Line of Credit , CIIS will reject the transaction.
Subordinated Debt FN Notes-
Investments: AH
Below Market Interest Rate at Origination FN Notes-
Investments: AI
Comparable Interest Rate at Origination FN Notes- Below Market Interest
Investments: AJ
Rate at Origination =
Yes and Date Originated
> 12/31/2005
Below Market Interest Rate Required under FN Notes- CIIS Values are "YES", "NO", and "NA"
Allocation Agreement (Financial Note) Investments: AK
4/18/2011 Page 2 of 13
Project or Excel Annual
64dd50c9-29a6-43fa-9f8c-1ea6624b8aea.xls - CDE QuickStart Borrower/
Financial Worksheet: New Field Mandatory Field is Conditionally Update Transaction Investee
CIIS TLR Data Field Note Field Column (CIIS 6.0) Field Required If… Compliance Required Type Purpose Type QLICI Type SPE Special Instructions
Below Market Interest Rate (Financial FN Notes-
Note) Investments: AL
What is Interest Rate Comparable? FN Notes- Below Market Interest Debt Options include:
Investments: AM • CDE’s Non-NMTC transaction
Rate (Financial Note) =
• CDE’s Parent/Affiliate
Yes and Date Originated
• Banks
> 12/31/2005
• Other
Interest Rate Comparable Other FN Notes- What is Interest Rate Debt User may enter up to 150 characters to describe the "Other"
Investments: AN Comparable
Interest Rate
Comparable? = Other
Lower than Standard Origination Fees FN Notes-
(Financial Note) Investments: AO
What is Standard Origination Fees FN Notes- Lower than Standard Debt Options include:
(Financial Note) Comparable? Investments: AP • CDE’s Non-NMTC transaction
Origination Fees
• CDE’s Parent/Affiliate
(Financial Note) = Yes
• Banks
and Date Originated >
• Other
12/31/2005
Standard Origination Fees (Financial FN Notes- What is Standard Debt User may enter up to 150 characters to describe the "Other"
Note) Comparable Other Investments: AQ Comparable
Origination Fees
(Financial Note)
Comparable? = Other
Standard Origination Fees (Financial Note) FN Notes- Lower than Standard Debt Numeric field with no decimals.
Investments: AR
Origination Fees
(Financial Note) = Yes
Longer than Standard Period of Interest FN Notes-
Only Payments Investments: AS
Standard Period of Interest Only Payments FN Notes- Longer than Standard Debt Numeric field with no decimals.
(in months) Investments: AT
Period of Interest Only
Payments = Yes
What is Standard Period of Interest FN Notes- Longer than Standard Debt Options include:
Comparable? Investments: AU • CDE’s Non-NMTC transaction
Period of Interest Only
• CDE’s Parent/Affiliate
Payments = Yes and
• Banks
Date Originated >
• Other
12/31/2005
Standard Period of Interest FN Notes- What is Standard Debt User may enter up to 150 characters to describe the "Other"
Comparable Other Investments: AV Comparable
Period of Interest
Comparable? = Other
Longer than Standard Amortization Period FN Notes-
Investments: AW
Standard Amortization Period (in months) FN Notes- If Longer than Debt Numeric field with no decimals.
Investments: AX
Standard Amortization
Period = Yes
What is Standard Amortization Period FN Notes- Longer than Standard Debt Options include: .
Comparable? Investments: AY • CDE’s Non-NMTC transaction
Amortization Period =
• CDE’s Parent/Affiliate
Yes and Date Originated
• Banks
> 12/31/2005
• Other
Standard Amortization Period FN Notes- What is Standard Debt User may enter up to 150 characters to describe the "Other"
Comparable Other Investments: AZ Comparable
Amortization Period
Comparable? = Other
Nontraditional Forms of Collateral FN Notes-
Investments: BA
Traditional Form of Collateral FN Notes- Nontraditional Forms "Traditional Form of Collateral" has the same CIIS values as
Investments: BB "Collateral Type" (see crosswalk).
of Collateral = Yes
4/18/2011 Page 3 of 13
Project or Excel Annual
64dd50c9-29a6-43fa-9f8c-1ea6624b8aea.xls - CDE QuickStart Borrower/
Financial Worksheet: New Field Mandatory Field is Conditionally Update Transaction Investee
CIIS TLR Data Field Note Field Column (CIIS 6.0) Field Required If… Compliance Required Type Purpose Type QLICI Type SPE Special Instructions
What is Traditional Form of Collateral FN Notes- Nontraditional Forms Options include: .
Comparable? Investments: BC • CDE’s Non-NMTC transaction
of Collateral = Yes and
• CDE’s Parent/Affiliate
Date Originated >
• Banks
12/31/2005
• Other
Traditional Form of Collateral FN Notes- What is Traditional User may enter up to 150 characters to describe the "Other"
Comparable Other Investments: BD Comparable
Form of Collateral
Comparable? = Other
Reporting Period Activity
Loan Status FN Notes-
Investments: BE
Not Yet Disbursed / Projected QEI FN Disbursements: B Disbursement fields
(Disbursement ID,
Disbursement Date,
Total Disbursement
Amount, Disbursement
Source, Source Amount)
are not populated
Disbursement ID FN Disbursements: C Not Yet Users may enter multiple "Disbursement IDs" (one ID for each
disbursement).
Disbursed/Projected QEI
is not populated
Disbursement Date FN Disbursements: D Not Yet Users may enter multiple "Disbursement Dates" (one date for
each "Disbursement ID").
Disbursed/Projected QEI
is not populated
Total Disbursement Amount FN Disbursements: E Not Yet Users may enter multiple "Disbursement Amounts" (one amount
for each "Disbursement ID").
Disbursed/Projected QEI
is not populated
Disbursement Source FN Disbursements: F Not Yet "Disbursement Sources" references the QEI(s) that sourced the
disbursement. Users may enter multiple "Disbursement Sources"
Disbursed/Projected QEI
(one source for each QEI that sourced the "Disbursement ID.")
is not populated
Source Amount FN Disbursements: G Not Yet "Disbursement Amount" references the amount of the QEI that
sourced the disbursement. Users may enter multiple "Source
Disbursed/Projected QEI
Amounts" (one amount for each QEI that sourced the "Disbursement
is not populated
ID.")
Disbursement Street Address Line 1 FN Disbursements: H Disbursement ID is
populated AND Date
Originated is >
12/31/2007
Disbursement Street Address Line 2 FN Disbursements: I
Disbursement City FN Disbursements: J Disbursement ID is
populated AND Date
Originated is >
12/31/2007
Disbursement State FN Disbursements: K Disbursement ID is
populated AND Date
Originated is >
12/31/2007
Disbursement Zip Code 5 FN Disbursements: L Disbursement ID is
populated AND Date
Originated is >
12/31/2007
Disbursement Zip Code +4 FN Disbursements: M
Disbursement FIPS Code FN CIIS unable to verify CIIS will allow users to enter a "Disbursement FIPS Code" if the
system is unable to verify a Disbursement Address.
Disbursement Address
QLICI Level FN Notes-
Investments: BF
4/18/2011 Page 4 of 13
Project or Excel Annual
64dd50c9-29a6-43fa-9f8c-1ea6624b8aea.xls - CDE QuickStart Borrower/
Financial Worksheet: New Field Mandatory Field is Conditionally Update Transaction Investee
CIIS TLR Data Field Note Field Column (CIIS 6.0) Field Required If… Compliance Required Type Purpose Type QLICI Type SPE Special Instructions
Principal Balance Outstanding FN Notes- Transaction Type = Debt
Investments: BG
Term Loan, Line of
Credit, or Debt with
Equity
Days Delinquent FN Notes- Debt
Investments: BH
Number of Time 60 Days or More FN Notes- Debt
Delinquent Investments: BI
Number of Times Loan was Restructured FN Notes- Debt
Investments: BJ
Amount Charged Off FN Notes- Debt
Investments: BK
Amount Recovered FN Notes- Debt
Investments: BL
Fair Value at End of Reporting Period FN Notes- Transaction Type = Equity
Investments: BM
Equity Investment
Projected Internal Rate of Return FN Notes- Transaction Type = Equity Numeric field with 3 decimals.
Investments: BN Validation: If Transaction Type = Term Loan or Line of Credit, CIIS
Equity Investment AND
will reject any response to Projected Internal Rate of Return
Date Originated is >
12/31/2005
Projected Grant to QALICB FN Notes- Numeric field with no decimals.
Investments: BO
PROJECTS DATA
Total Project Cost
Total Project Cost P Projects: B "Total Project Cost" includes the CDE's contribution.
Total Project Cost – Public Sources P Projects: C "Total Project Cost - Public Sources" is a subset of "Total Project
Cost."
Total Project Cost – Affiliates & Related P Projects: D "Total Project Cost - Affiliates & Related Programs" is a subset of
Programs "Total Project Cost."
Underwriting Criteria
Loan-to-Value Ratio P Projects: E Transaction Type = Debt Numeric field with 3 decimals.
Term Loan
Debt Service Coverage Ratio P Projects: F Transaction Type = Debt Numeric field with 3 decimals.
Term Loan
Loan Loss Reserve Requirement P Projects: G Transaction Type = Debt Numeric field with no decimals.
Term Loan
Investee Profile
Client ID P Projects: H
QLICI Type P Projects: I
Investee Type P Projects: J
Investee TIN P Projects: K QLICI Type = CDE CDE Validation: If QLICI Type = QALICB, CIIS will reject any response
to "Investee TIN".
Date Business Established P Projects: L Parent
Company
Entity Structure P Projects: M Business Parent
Company
Minority Owned or Controlled P Projects: N Business Parent
Company
Women Owned or Controlled P Projects: O Business Parent
Company
Low Income Owned or Controlled P Projects: P Business Parent
Company
Gender P Projects: Q Individual
Race P Projects: R Individual
Hispanic Origin P Projects: S Individual
Credit Score P Projects: T Parent
Company
DS/FCOS Hours of Assistance at Time of P Projects: U Parent
Investment Company
and SPE
Business Description P Projects: V QLICI Type = QALICB
QALICB
NAICS P Projects: W Parent
Company
Addresses 4/18/2011 Page 5 of 13
Project or Excel Annual
64dd50c9-29a6-43fa-9f8c-1ea6624b8aea.xls - CDE QuickStart Borrower/
Financial Worksheet: New Field Mandatory Field is Conditionally Update Transaction Investee
CIIS TLR Data Field Note Field Column (CIIS 6.0) Field Required If… Compliance Required Type Purpose Type QLICI Type SPE Special Instructions
Investee Street Address Line 1 P Addresses: B Parent
Company
Investee Street Address Line 2 P Addresses: C Parent
Company
Investee City P Addresses: D Parent
Company
Investee State P Addresses: E Parent
Company
Investee Zip Code 5 P Addresses: F Parent
Company
Investee Zip Code +4 P Addresses: G Parent
Company
Investee FIPS Code P CIIS unable to verify Parent CIIS will allow users to enter an "Investee FIPS Code" if the
Company system is unable to verify the Investee Address.
Investee Address
Project Street Address Line 1 P Addresses: H CIIS accepts multiple Project Addresses.
Project Street Address Line 2 P Addresses: I CIIS accepts multiple Project Addresses.
Project City P Addresses: J CIIS accepts multiple Project Addresses.
Project State P Addresses: K CIIS accepts multiple Project Addresses.
Project Zip Code 5 P Addresses: L CIIS accepts multiple Project Addresses.
Project Zip Code +4 P Addresses: M CIIS accepts multiple Project Addresses.
Project FIPS Code P CIIS unable to verify CIIS will allow users to enter a "Project FIPS Code" if the system
is unable to verify a Project Address.
Project Address
Outcomes
Annual Gross Revenue from Business P Projects: X Business Parent
Operations At Time of Loan/Investment Company
Annual Gross Revenue from Business P Projects: Y Business Parent
Operations Reported During the Reporting Company
Period
Jobs at Time of Loan/Investment P Projects: Z Purpose = Business Business Parent
Company
or Microenterprise
Jobs at Reporting Period End P Projects: AA Purpose = Business Business Parent
Company
or Microenterprise
Projected Jobs to be Created at P Projects: AB Purpose = Business Business Parent Numeric field with 2 decimals and “DK” [Don’t Know”] and “NA”
Businesses Financed Company [Not Applicable] options.
or Microenterprise
Validation: If Purpose <> [not equal] "Business" or
"Microenterprise", CIIS will reject any response to "Projected Jobs to
be Created at Businesses Financed".
Projected Jobs to be Created – P Projects: AC Purpose = Real Real Estate Parent Numeric field with 2 decimals and “DK” [Don’t Know”] and “NA”
Construction Company [Not Applicable] options.
Estate
Validation: If Purpose <> [not equal] "Real Estate", CIIS will reject
any response to "Projected Jobs to be Created Construction".
Projected Jobs to be Created at Tenant P Projects: AD Real Estate Numeric field with 2 decimals and “DK” [Don’t Know”] and “NA”
Businesses [Not Applicable] options.
Validation: If Purpose <> [not equal] "Real Estate", CIIS will reject
any response to "Projected Jobs to be Created at Tenant
Businesses".
Square Feet of Real Estate - Total P Projects: AE Purpose = Real Real Estate "Square Feet of Real Estate - Total" is the total square footage
developed for the project funded.
Estate
Numeric field with no decimals.
Square Feet of Real Estate - P Projects: AF Purpose = Real Real Estate "Square Feet of Real Estate - Manufacturing" is a subset of
Manufacturing "Square Feet of Real Estate - Total."
Estate
Numeric field with no decimals and Don’t Know and Not Applicable
options.
Square Feet of Real Estate - Office P Projects: AG Purpose = Real Real Estate "Square Feet of Real Estate - Office" is a subset of "Square Feet
of Real Estate - Total."
Estate
Numeric field with no decimals and Don’t Know and Not Applicable
options.
Square Feet of Real Estate – Retail P Projects: AH Purpose = Real Real Estate "Square Feet of Real Estate - Retail" is a subset of "Square Feet
of Real Estate - Total."
Estate
Numeric field with no decimals and Don’t Know and Not Applicable
options.
Asking Rent4/18/2011 Foot
per Square P Projects: AI Page 6 of 13 Real Estate
Project or Excel Annual
64dd50c9-29a6-43fa-9f8c-1ea6624b8aea.xls - CDE QuickStart Borrower/
Financial Worksheet: New Field Mandatory Field is Conditionally Update Transaction Investee
CIIS TLR Data Field Note Field Column (CIIS 6.0) Field Required If… Compliance Required Type Purpose Type QLICI Type SPE Special Instructions
Housing Units – Sale P Projects: AJ Purpose = Real Real Estate
Estate
Housing Units – Rental P Projects: AK Purpose = Real Real Estate
Estate
Affordable Housing Units – Sale P Projects: AL Purpose = Real Real Estate "Affordable Housing Units - Sale" is a subset of "Housing Units -
Sale."
Estate
Affordable Housing Units – Rental P Projects: AM Purpose = Real Real Estate "Affordable Housing Units - Rental" is a subset of "Housing Units -
Rental."
Estate
Community Facility P Projects: AN CIIS Values are "YES", "NO", and "DK" [Don't Know].
Validation: If "Community Facility" = "YES", user must provide a
numeric response > 0 or DK for at least one of the Community
Facility Capacity data points that follow.
Capacity of Educational Community Facility P Projects: AO Community Facility = Numeric field with 2 decimals points and “DK” [Don’t Know”] and
“NA” [Not Applicable] options.
Yes
(For a community facility,
CIIS requires a capacity
number (>0) or "Don't
Know" for one or more
capacity fields.)
Capacity of Childcare Community Facility P Projects: AP Community Facility = Numeric field with 2 decimals points and “DK” [Don’t Know”] and
“NA” [Not Applicable] options.
Yes
(For a community facility,
CIIS requires a capacity
number (>0) or "Don't
Know" for one or more
capacity fields.)
Capacity of Healthcare Community Facility P Projects: AQ Community Facility = Numeric field with 2 decimals points and “DK” [Don’t Know”] and
“NA” [Not Applicable] options.
Yes
(For a community facility,
CIIS requires a capacity
number (>0) or "Don't
Know" for one or more
capacity fields.)
Capacity of Arts Center Community Facility P Projects: AR Community Facility = Numeric field with 2 decimals points and “DK” [Don’t Know”] and
“NA” [Not Applicable] options.
Yes
(For a community facility,
CIIS requires a capacity
number (>0) or "Don't
Know" for one or more
capacity fields.)
Capacity of Other Community Facility P Projects: AS Community Facility = Numeric field with 2 decimals points and “DK” [Don’t Know”] and
“NA” [Not Applicable] options.
Yes
(For a community facility,
CIIS requires a capacity
number (>0) or "Don't
Know" for one or more
capacity fields.)
DS/FCOS Hours of Assistance Provided P Projects: AT Parent
During the Reporting Period Company
and SPE
Other Impacts (1) Explain P Projects: AU
Other Impacts (1) Number of Units P Projects: AV Other Impact (1) -
Explain is populated.
Other Impacts (2) Explain P Projects: AW
Other Impacts (2) Number of Units P Projects: AX Other Impact (2) -
Explain is populated.
NMTC Program Criteria
Investor TIN P Projects: AY
4/18/2011 Page 7 of 13
Project or Excel Annual
64dd50c9-29a6-43fa-9f8c-1ea6624b8aea.xls - CDE QuickStart Borrower/
Financial Worksheet: New Field Mandatory Field is Conditionally Update Transaction Investee
CIIS TLR Data Field Note Field Column (CIIS 6.0) Field Required If… Compliance Required Type Purpose Type QLICI Type SPE Special Instructions
QALICB Type P Projects: AZ QLICI Type = QALICB
QALICB
NMTC Eligibility Criteria P Projects: BA
1990 FIPS Code P Projects: BB NMTC Eligibility
Criteria = 1990 Census
Related Entity P Projects: BC
Better Rates & Terms (P)
Below Market Interest Rate Required under P Projects: BD CIIS Values are "YES", "NO", and "NA"
Allocation Agreement (Project)
Below Market Interest Rate (Project) P Projects: BE
Blended Interest Rate P Projects: BF Below Market Interest Debt Numeric field with 3 decimals.
Rate (Project) = Yes
Comparable Blended Interest Rate P Projects: BG Below Market Interest Debt Numeric field with 3 decimals.
Rate (Project) = Yes
What is Blended Interest Rate P Projects: BH Below Market Interest Debt Options include: .
Comparable? • CDE’s Non-NMTC transaction
Rate (Project) = Yes and
• CDE’s Parent/Affiliate
Date Originated >
• Banks
12/31/2005
• Other
Blended Interest Rate Comparable P Projects: BI What is Blended Debt User may enter up to 150 characters to describe the "Other"
Other Comparable
Interest Rate
Comparable? = Other
Lower than Standard Origination Fees P Projects: BJ CIIS Values are "YES" and "NO".
(Project)
Standard Origination Fees (Project) P Projects: BK Lower than Standard Debt Numeric field with no decimals.
Origination Fees
(Project) = Yes
What is Standard Origination Fees P Projects: BL Lower than Standard Debt Options include:
(Project) Comparable? • CDE’s Non-NMTC transaction
Origination Fees
• CDE’s Parent/Affiliate
(Project) = Yes and Date
• Banks
Originated > 12/31/2005
• Other
Standard Origination Fees (Project) P Projects: BM What is Standard Debt User may enter up to 150 characters to describe the "Other"
Comparable Other Comparable
Origination Fees
(Project) Comparable? =
Other
Higher than Standard Loan to Value Ratio P Projects: BN
Standard Loan-to-Value Ratio P Projects: BO If Higher than Debt Numeric field with 3 decimals.
Standard Loan-to-Value
Ratio = Yes
What is Standard Loan-to-Value Ratio P Projects: BP If Higher than Debt Options include: .
Comparable? • CDE’s Non-NMTC transaction
Standard Loan-to-Value
• CDE’s Parent/Affiliate
Ratio = Yes and Date
• Banks
Originated > 12/31/2005
• Other
Standard Loan-to-Value Ratio P Projects: BQ What is Standard Debt User may enter up to 150 characters to describe the "Other"
Comparable Other Comparable
Loan-to-Value Ratio
Comparable? = Other
More Flexible Borrower Credit Standards P Projects: BR
Lower than Standard Debt Service P Projects: BS
Coverage Ratio
Standard Debt Service Coverage Ratio P Projects: BT Lower than Standard Debt Numeric field with 3 decimals.
Debt Service Coverage
Ratio = Yes
4/18/2011 Page 8 of 13
Project or Excel Annual
64dd50c9-29a6-43fa-9f8c-1ea6624b8aea.xls - CDE QuickStart Borrower/
Financial Worksheet: New Field Mandatory Field is Conditionally Update Transaction Investee
CIIS TLR Data Field Note Field Column (CIIS 6.0) Field Required If… Compliance Required Type Purpose Type QLICI Type SPE Special Instructions
What is Standard Debt Service P Projects: BU Lower than Standard Debt Options include:
Coverage Ratio Comparable? • CDE’s Non-NMTC transaction
Debt Service Coverage
• CDE’s Parent/Affiliate
Ratio = Yes and Date
• Banks
Originated > 12/31/2005
• Other
Standard Debt Service Coverage P Projects: BV What is Standard Debt User may enter up to 150 characters to describe the "Other"
Ratio Comparable Other Comparable
Debt Service Coverage
Ratio Comparable? =
Other
Lower than Standard Loan Loss Reserve P Projects: BW
Requirement
Standard Loan Loss Reserve Requirement P Projects: BX Lower than Standard Debt Numeric field with no decimals.
Loan Loss Reserve
Requirement = Yes
What is Standard Loan Loss Reserve P Projects: BY Lower than Standard Debt Options include:
Requirement Comparable? • CDE’s Non-NMTC transaction
Loan Loss Reserve
• CDE’s Parent/Affiliate
Requirement = Yes and
• Banks
Date Originated >
• Other
12/31/2005
Standard Loan Loss Reserve P Projects: BZ What is Standard Debt User may enter up to 150 characters to describe the "Other"
Requirement Comparable Other Comparable
Loan Loss Reserve
Requirement
Comparable? = Other
Areas of Higher Distress
Poverty Rates Greater than 25% P Projects: CA
Poverty Rates Greater than 30% P Projects: CB
Median Income Less than 60% of Area P Projects: CC
Median Income
Median Income Less than 70% of Area P Projects: CD
Median Income
Unemployment at Least 1.25 Times the P Projects: CE
National Average
Unemployment at Least 1.5 Times the P Projects: CF
National Average
Designated for Redevelopment P Projects: CG
Designated EZ, EC, or RC P Projects: CH
SBA Designated HUB Zone P Projects: CI
Designated Native American or Alaska P Projects: CJ
Native Area, Hawaiian Homeland, or
Redevelopment Area by Tribe or Other
Authority
Brownfield Redevelopment Area P Projects: CK
Encompassed by HOPE VI Redevelopment P Projects: CL
Plan
Located in a Hot Zone P Projects: CM
Appalachian Regional Commission or Delta P Projects: CN
Regional Authority
Colonias P Projects: CO
Medically Underserved Area P Projects: CP
TIF District or Enterprise Zone Program P Projects: CQ
High Migration Rural County P Projects: CR CIIS Values are "YES", "NO", and "NA"
4/18/2011 Page 9 of 13
QuickStart Definitions
Project or Financial Note Field - This field indicates whether the data field is collected on the Financial Note (FN) or Project (P) level. For
Excel Worksheet: Column - The names in this column indicate the worksheet in the Excel Template for each data field. The letters in this c
New Field (CIIS 6.0) - A in this column indicates that the field is new in CIIS version 6.0 (FY 2008).
Mandatory - A in this column indicates that users must provide valid data in this field for every transaction in order to complete the Trans
Conditionally Required if... - A in this column indicates that users must provide valid data in this field for every transaction that meets th
Compliance - A in this column indicates that the field may be used to test the organization's compliance with their allocation agreement.
Annual Update Required - A in this column indicates that users must provide an annual update to the data field if the data has change
Transaction Type - Users may use this column to organize the data fields by Transaction Type. "Debt" indicates that the data field is relev
Purpose - Users may use this column to organize the data fields by Purpose. "Business" indicates that the data field is relevant for Busines
Borrower/Investee Type - Users may use this column to organize the data fields by Investee Type. "Business" indicates that the data field
QLICI Type - Users may use this column to organize the data fields by QLICI Type (CDE and QALICB).
SPE - User may use this column to organize the data fields for a Special Purpose Entity (SPE) borrower. "Parent Business" indicates that if
Special Instructions - This column provides additional information including, but not limited to, changes to data field in CIIS6.0 and commo
ncial Note (FN) or Project (P) level. For additional information about Financial Notes and Projects, see the "Allocatee - TLR - Instructions at http://www.cd
te for each data field. The letters in this column indicate the column on the worksheet in the Excel Template.
ansaction in order to complete the Transaction Level Report (TLR).
s field for every transaction that meets the noted condition in order to complete the Transaction Level Report (TLR).
mpliance with their allocation agreement.
e to the data field if the data has changed since the previous reporting period.
Debt" indicates that the data field is relevant for Term Loans, Lines of Credit, Debt with Equity transactions. "Equity" indicates that the data field is relevant
that the data field is relevant for Business and Microenterprise transactions. "Real Estate" indicates that the field is relevant for any Real Estate transactio
. "Business" indicates that the data field is relevant for transactions to businesses. "Individual" indicates that the field is relevant for transactions to individ
ower. "Parent Business" indicates that if the borrower is an SPE, the user should enter data for the parent business. For additional information about SPE
nges to data field in CIIS6.0 and common user errors.
tee - TLR - Instructions at http://www.cdfifund.gov/what_we_do/ciis.asp
" indicates that the data field is relevant for Equity Investments and Debt with Equity transactions. "Debt with Equity" indicates that the data field is relevan
s relevant for any Real Estate transactions.
ield is relevant for transactions to individuals.
ss. For additional information about SPEs, see the "Allocatee - TLR - Instructions at http://www.cdfifund.gov/what_we_do/ciis.asp
ty" indicates that the data field is relevant for Debt with Equity transactions.
_we_do/ciis.asp
Related docs
Other docs by fkm44501
