Loan for Investment by cqh93112

VIEWS: 4 PAGES: 10

More Info
									                                                                                                           Annual
                                                                                aa7563b7-9c7e-4b68-b687-d19baa7c6a84.xls - CDFI TLR                 Borrower/
                                   Excel   New Field    Mandatory     Field is Conditionally                      Update    Transaction              Investee
CIIS TLR Data Field               Column   (CIIS 8.0)     Field           Required If…              Compliance   Required      Type       Purpose      Type                      Special Instructions
Transaction Identifier
Submitter Transmission ID           A
Project Number                      B                                                                                                                            Use "Project Number" to link Financial Notes to a
                                                                                                                                                                Project. "Project Number" must be consistent across
                                                                                                                                                                report years.
                                                                                                                                                                 Numeric field with a maximum of 8 digits.
Originator Transaction ID           C                                                                                                                           "Originator Transaction ID" must be consistent across
                                                                                                                                                                report years.
Client ID                           D
Investee Type                       E                      
Transaction Profile
Date Originated                     F                      
Original Loan/Investment Amount     G                                                                               
Purpose                             H                      
Transaction Type                    I                      
Interest Rate                       J                                Transaction Type = Term                                 Debt
                                                                    Loan, Line of Credit, or Debt
                                                                             with Equity
                                                                     AND Date Originated is >
                                                                            12/31/2005
Interest Type                       K                                Transaction Type = Term                                  Debt
                                                                    Loan, Line of Credit, or Debt
                                                                             with Equity
                                                                     AND Date Originated is >
                                                                            12/31/2005
Points                              L                                Transaction Type = Term                                  Debt
                                                                     Loan or Debt with Equity
                                                                     AND Date Originated is >
                                                                           12/31/2005

Origination Fees                    M                                Transaction Type = Term
                                                                    Loan, Line of Credit, or Debt
                                                                             with Equity
                                                                     AND Date Originated is >
                                                                            12/31/2005
Amortization Type                   N                                Transaction Type = Term                                  Debt
                                                                    Loan, Line of Credit, or Debt
                                                                             with Equity
                                                                     AND Date Originated is >
                                                                            12/31/2005
Equity-Like Features                O                                Transaction Type = Debt                                Debt with
                                                                                                                              Equity
                                                                          with Equity
                                                                     AND Date Originated is >
                                                                          12/31/2005




                                                                                                           1 of 10
                                                                                                           Annual
                                                                                aa7563b7-9c7e-4b68-b687-d19baa7c6a84.xls - CDFI TLR                          Borrower/
                                   Excel   New Field    Mandatory     Field is Conditionally                      Update    Transaction                       Investee
CIIS TLR Data Field               Column   (CIIS 8.0)     Field           Required If…              Compliance   Required      Type          Purpose            Type                     Special Instructions
Term (in months)                     P                               Transaction Type = Term                                 Debt                                       Numeric - No Decimals (In Months)
                                                                    Loan, Line of Credit, or Debt
                                                                             with Equity
                                                                     AND Date Originated is >
                                                                            12/31/2005
Date First Payment Due              Q                                                                                          Debt
Guarantee                           R                                Transaction Type = Term                                  Debt
                                                                    Loan, Line of Credit, or Debt
                                                                             with Equity
                                                                     AND Date Originated is >
                                                                            12/31/2005
Lien Position                       S                                Transaction Type = Term                                  Debt
                                                                    Loan, Line of Credit, or Debt
                                                                             with Equity
                                                                     AND Date Originated is >
                                                                            12/31/2005
Collateral Type                     T                                Transaction Type = Term
                                                                    Loan, Line of Credit, or Debt
                                                                             with Equity
                                                                     AND Date Originated is >
                                                                            12/31/2005
Collateral Value at Origination     U                                Transaction Type = Term
                                                                    Loan, Line of Credit, or Debt
                                                                             with Equity
                                                                     AND Date Originated is >
                                                                            12/31/2005
Equity Injection Amount             V                                                                                                     Business or Real
                                                                                                                                               Estate
Forgivable Loan                     W                                                                                          Debt
Investee Address
Investee Street Address Line 1      X                                                                                                                                   A complete Investee Addess OR an Investee FIPS
                                                                                                                                                                         Code is mandatory.
Investee Street Address Line 2      Y                                                                   
Investee City                       Z                                                                                                                                   A complete Investee Addess OR an Investee FIPS
                                                                                                                                                                         Code is mandatory.
Investee State                     AA                                                                                                                                   A complete Investee Addess OR an Investee FIPS
                                                                                                                                                                         Code is mandatory.
Investee Zipcode5                  AB                                                                                                                                   A complete Investee Addess OR an Investee FIPS
                                                                                                                                                                         Code is mandatory.
Investee Zipcode+4                 AC
Investee FIPS Code                 AD                                                                                                                                   A complete Investee Addess OR an Investee FIPS
                                                                                                                                                                         Code is mandatory.
Project Addresses
Project Street Address Line 1      AE                                                                                                                                   CIIS accepts multiple Project Addresses. A complete
                                                                                                                                                                         Project Addess(es) OR a Project FIPS Code(s) is
                                                                                                                                                                         mandatory.
Project Street Address Line 2      AF                                                                   
Project City                       AG                                                                                                                                   CIIS accepts multiple Project Addresses. A complete
                                                                                                                                                                         Project Addess(es) OR a Project FIPS Code(s) is
                                                                                                                                                                         mandatory.
                                                                                                            2 of 10
                                                                                                              Annual
                                                                                   aa7563b7-9c7e-4b68-b687-d19baa7c6a84.xls - CDFI TLR                          Borrower/
                                      Excel   New Field    Mandatory      Field is Conditionally                     Update    Transaction                       Investee
CIIS TLR Data Field                  Column   (CIIS 8.0)     Field            Required If…             Compliance   Required      Type          Purpose            Type                      Special Instructions
Project State                          AH                                                                                                                                  CIIS accepts multiple Project Addresses. A complete
                                                                                                                                                                            Project Addess(es) OR a Project FIPS Code(s) is
                                                                                                                                                                            mandatory.
Project Zipcode5                       AI                                                                                                                                  CIIS accepts multiple Project Addresses. A complete
                                                                                                                                                                            Project Addess(es) OR a Project FIPS Code(s) is
                                                                                                                                                                            mandatory.
Project Zipcode+4                     AJ
Project FIPS Code                     AK                                                                                                                                   CIIS accepts multiple Project Addresses. A complete
                                                                                                                                                                            Project Addess(es) OR a Project FIPS Code(s) is
                                                                                                                                                                            mandatory.
Borrower/Investee Profile
NAICS                                 AL                                                                                                     Business or Real
                                                                                                                                                  Estate
Date Business Established             AM                                                                                                     Business or Real
                                                                                                                                                  Estate
Entity Structure                      AN                                                                                                     Business or Real   Business
                                                                                                                                                  Estate
Minority Owned or Controlled          AO                                                                                                     Business or Real
                                                                                                                                                  Estate
Women Owned or Controlled             AP                                                                                                     Business or Real
                                                                                                                                                  Estate
Low-Income Owned or Controlled        AQ                                                                                                     Business or Real
                                                                                                                                                  Estate
Jobs at Time of Loan/Investment       AR                                 Purpose = Business or                                                 Business
                                                                             Microenterprise
Transaction Status
Principal Balance Outstanding         AS                                Transaction Type = Term                                Debt
                                                                       Loan, Line of Credit, or Debt
                                                                                with Equity
Loan Status                           AT                                                                                
Days Delinquent                       AU                                Transaction Type = Term                                Debt
                                                                       Loan, Line of Credit, or Debt
                                                                                with Equity
Number of Times 60 Days or More       AV                                                                                         Debt
Delinquent
Number of Times the Loan Was          AW                                                                                         Debt
Restructured
Number of Times the Loan Was          AX                                                                                         Debt
Refinanced
Refinanced-Original Transaction ID    AY

Amount Charged Off                    AZ                                                                                         Debt

Amount Recovered                      BA                                                                                         Debt

Fair Value at Origination             BB                                Transaction Type = Equity                               Equity
                                                                               Investment
Fair Value at End of Reporting        BC                                Transaction Type = Equity                             Equity
Period
                                                                               Investment
Annual Gross Revenue from             BD                                                                                                    Business or Real
Business Operations Reported                                                                                                                      Estate
During the Reporting Period
                                                                                                               3 of 10
                                                                                                             Annual
                                                                                  aa7563b7-9c7e-4b68-b687-d19baa7c6a84.xls - CDFI TLR                       Borrower/
                                       Excel   New Field    Mandatory    Field is Conditionally                  Update    Transaction                       Investee
CIIS TLR Data Field                   Column   (CIIS 8.0)     Field          Required If…          Compliance   Required      Type          Purpose            Type                        Special Instructions
Jobs at Reporting Period End            BE                               Purpose = Business or                                            Business
                                                                            Microenterprise
DS/FCOS Hours of Assistance            BF                                                                            
Provided During Reporting Period

Impact Profile
Low-Income Status                      BG                                                              
Other Targeted Populations             BH                                                              
LITP End Users                          BI                                                             
OTP End Users                          BJ                                                              
IA End Users                           BK                                                              
HZ End Users                           BL                                                              
Credit Score                           BM
Gender                                 BN                                                                                                                   Individual
Race                                   BO                                                                                                                   Individual
Hispanic Origin                        BP                                                                                                                   Individual
Female-Headed Household                BQ                                                                                                     Home          Individual
First-Time Homebuyer                   BR                                  Purpose = Home                                                    Home          Individual
                                                                               Purchase
Banked @ time of Intake                BS                                                                                                                   Individual
Rejected by Bank or Credit Union       BT                                                                                                                   Individual

DS/FCOS Hours of Assistance at         BU
Time of Investment
DS/FCOS Hours of Assistance -          BV
Post Loan/Investment
Annual Gross Revenue from              BW                                                                                                Business or Real
Business Operations At Time of                                                                                                                Estate
Loan/Investment
Total Project Cost                     BX                                                                                                Business or Real                 "Total Project Cost" includes the CDFI's contribution.
                                                                                                                                              Estate
Total Project Cost - Public Sources    BY                                                                                                Business or Real                 "Total Project Cost - Public Sources" is a subset of
                                                                                                                                              Estate                     "Total Project Cost."
Total Project Cost - Affiliates &      BZ                                                                                                Business or Real                 "Total Project Cost - Affiliates & Related Programs" is a
Related Program                                                                                                                               Estate                     subset of "Total Project Cost."
                                                                                                                                                                          Numeric field with 2 decimal places.
Projected Impacts
Type of Jobs Reported                  CA                               Purpose = Business,                                               Business,                    wValidation: If Purpose <> [not equal] "Business",
                                                                                                                                         Mircoenterprise
                                                                         Microenterprise or Real                                                                         "Microenterprise" and "Real-Estate", CIIS will reject any
                                                                                                                                         or Real Estate
                                                                                 Estate                                                                                  response to "Type of Jobs Reported."
                                                                                                                                                                         wOptions include:

Projected Jobs to Be Created at        CB                                Purpose = Business or                                             Business                      Numeric field with 2 decimals and “DK” [Don’t Know”]
Businesses Financed                                                                                                                                                      and “NA” [Not Applicable] options.
                                                                            Microenterprise
                                                                                                                                                                          Validation: If Purpose <> [not equal] "Business" or
                                                                                                                                                                         "Microenterprise", CIIS will reject any response to
                                                                                                                                                                         "Projected Jobs to be Created at Businesses Financed".
                                                                                                           4 of 10
                                                                                                              Annual
                                                                                   aa7563b7-9c7e-4b68-b687-d19baa7c6a84.xls - CDFI TLR                          Borrower/
                                     Excel   New Field    Mandatory      Field is Conditionally                       Update    Transaction                      Investee
CIIS TLR Data Field                 Column   (CIIS 8.0)     Field            Required If…               Compliance   Required      Type         Purpose            Type                         Special Instructions
Projected Jobs to be Created -        CC                                Purpose = Real Estate                                                 Real Estate                   Numeric field with 2 decimals and “DK” [Don’t Know”]
Construction                                                                                                                                                                and “NA” [Not Applicable] options.
                                                                                                                                                                             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      CD                                                                                                        Real Estate                   Numeric field with 2 decimals and “DK” [Don’t Know”]
Tenant Businesses                                                                                                                                                           and “NA” [Not Applicable] options.
                                                                                                                                                                             Validation: If Purpose <> [not equal] "Real Estate", CIIS
                                                                                                                                                                            will reject any response to "Projected Jobs to be Created
                                                                                                                                                                            at Tenant Businesses".
Source of Job Estimates              CE                                 Purpose = Business,                                                    Business,                  wValidation: If Purpose <> [not equal] "Business",
                                                                                                                                              Mircoenterprise
                                                                         Microenterprise or Real                                                                            "Microenterprise" and "Real-Estate", CIIS will reject any
                                                                                                                                              or Real Estate
                                                                                 Estate                                                                                     response to "Type of Jobs Reported."
                                                                                                                                                                            wOptions include:
                                                                                                                                                                            to make as a result of the new financing.
                                                                                                                                                                            (NEWFINANCING)

                                                                                                                                                                            projected wage and salary expenditures attributable to
                                                                                                                                                                            project financing. (WAGEDATA)

                                                                                                                                                                            systems such as IMPLAN, RIMSII, or REMI.
                                                                                                                                                                            (ECONOMICIMPACT)

                                                                                                                                                                            jobs created by type of business and square-footage
                                                                                                                                                                            built. (RULEOFTHUMB)


Source of Job Estimates - Other      CF                               Source of Job Estimates =                                                                           w User may enter up to 150 characters to describe the
                                                                                  Other                                                                                     "Other"
Community Facility                   CG
Capacity of Educational Community    CH                                Community Facility = Yes                                                                             CIIS Values are "YES", "NO", and "DK" [Don't Know].
Facility                                                                                                                                                                     Validation: If "Community Facility" = "YES", user must
                                                                      (For a community facility, CIIS
                                                                                                                                                                            provide a numeric response > 0 or DK for at least one of
                                                                        requires a capacity number
                                                                                                                                                                            the Community Facility Capacity data points that follow.
                                                                       (>0) or "Don't Know" for one
                                                                          or more capacity fields.)



Capacity of Childcare Community       CI                               Community Facility = Yes                                                                             Numeric field with 2 decimals points and “DK” [Don’t
Facility                                                                                                                                                                    Know”] and “NA” [Not Applicable] options.
                                                                      (For a community facility, CIIS
                                                                        requires a capacity number
                                                                       (>0) or "Don't Know" for one
                                                                          or more capacity fields.)



Capacity of Healthcare Community     CJ                                Community Facility = Yes                                                                             Numeric field with 2 decimals points and “DK” [Don’t
Facility                                                                                                                                                                    Know”] and “NA” [Not Applicable] options.
                                                                      (For a community facility, CIIS
                                                                        requires a capacity number
                                                                       (>0) or "Don't Know" for one
                                                                          or more capacity fields.)




                                                                                                               5 of 10
                                                                                                            Annual
                                                                                 aa7563b7-9c7e-4b68-b687-d19baa7c6a84.xls - CDFI TLR                      Borrower/
                                   Excel   New Field    Mandatory      Field is Conditionally                       Update    Transaction                  Investee
CIIS TLR Data Field               Column   (CIIS 8.0)     Field            Required If…               Compliance   Required      Type        Purpose         Type                       Special Instructions
Capacity of Arts Center Community   CK                               Community Facility = Yes                                                                         Numeric field with 2 decimals points and “DK” [Don’t
Facility                                                                                                                                                              Know”] and “NA” [Not Applicable] options.
                                                                    (For a community facility, CIIS
                                                                      requires a capacity number
                                                                     (>0) or "Don't Know" for one
                                                                        or more capacity fields.)



Capacity of Other Community           CL                              Community Facility = Yes                                                                        Numeric field with 2 decimals points and “DK” [Don’t
Facility                                                                                                                                                              Know”] and “NA” [Not Applicable] options.
                                                                    (For community facilities, CIIS
                                                                       requires a number (>0) or
                                                                     "Don't Know" for one or more
                                                                            capacity fields.)



Square Feet of Real Estate - Total    CM                              Purpose = Real Estate                                                Real Estate                "Square Feet of Real Estate - Total" is the total square
                                                                                                                                                                      footage developed for the project funded.
                                                                                                                                                                       Numeric field with no decimals.
Square Feet of Real Estate –          CN                              Purpose = Real Estate                                                Real Estate                "Square Feet of Real Estate - Manufacturing" is a
Manufacturing                                                                                                                                                         subset of "Square Feet of Real Estate - Total."
                                                                                                                                                                       Numeric field with no decimals and Don’t Know and
                                                                                                                                                                      Not Applicable options.
Square Feet of Real Estate – Office   CO                              Purpose = Real Estate                                                Real Estate                "Square Feet of Real Estate - Office" is a subset of
                                                                                                                                                                      "Square Feet of Real Estate - Total."
                                                                                                                                                                       Numeric field with no decimals and Don’t Know and
                                                                                                                                                                      Not Applicable options.
Square Feet of Real Estate-Retail     CP                              Purpose = Real Estate                                                Real Estate                "Square Feet of Real Estate - Retail" is a subset of
                                                                                                                                                                      "Square Feet of Real Estate - Total."
                                                                                                                                                                       Numeric field with no decimals and Don’t Know and
                                                                                                                                                                      Not Applicable options.
Asking Rent per Square Foot           CQ                                                                                                    Real Estate
Housing Units – Sale                  CR                              Purpose = Real Estate                                                Real Estate
Housing Units – Rental                CS                              Purpose = Real Estate                                                Real Estate
Affordable Housing Units – Sale       CT                              Purpose = Real Estate                                                Real Estate                "Affordable Housing Units - Sale" is a subset of
                                                                                                                                                                      "Housing Units - Sale."
Affordable Housing Units – Rental     CU                              Purpose = Real Estate                                                Real Estate                "Affordable Housing Units - Rental" is a subset of
                                                                                                                                                                      "Housing Units - Rental."
Other Impact (1) - Explain            CV
Other Impact (1) - Number of Units    CW                             Other Impact (1) - Explain
                                                                            is populated.
Other Impact (2) - Explain            CX
Other Impact (2) - Number of Units    CY                             Other Impact (2) - Explain
                                                                            is populated.




                                                                                                             6 of 10
QuickStart Definitions

Excel Column - The letters in this column indicate the column on the Excel Template for each data field.
New Field (CIIS 7.0) - A  in this column indicates that the field is new in CIIS Version 7.0 (FY 2009). NOTE: There are no new fields for C
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 assistance agreemen
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
Special Instructions - This column provides additional information including, but not limited to, changes to data field in CIIS 7.0 and comm
09). NOTE: There are no new fields for CIIS Version 7.0.
 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 assistance 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 busineses. "Individual" indicates that the field is relevant for transactions to individu
 nges to data field in CIIS 7.0 and common user errors.
 " 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.
eld is relevant for transactions to individuals.
ty" indicates that the data field is relevant for Debt with Equity transactions.

								
To top