Docstoc

Multiple Project Value Template

Document Sample
Multiple Project Value Template Powered By Docstoc
					                                                                                                      4c039bce-7408-482c-9943-ae20f1a8c307.xls - CDE QuickStart
                                         Project or      Excel                                                                        Annual                                 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

            7/19/2010                                                                                                           Page 1 of 14
                                                                                                          4c039bce-7408-482c-9943-ae20f1a8c307.xls - CDE QuickStart
                                            Project or       Excel                                                                      Annual                             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
                                                         Investments: AJ
                                                                                                     Interest Rate at
                                                                                                  Origination = Yes and
                                                                                                    Date Originated >
                                                                                                        12/31/2005

            7/19/2010                                                                                                              Page 2 of 14
                                                                                                            4c039bce-7408-482c-9943-ae20f1a8c307.xls - CDE QuickStart
                                             Project or        Excel                                                                       Annual                             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 Required              FN            Notes-                                                                                                                                      CIIS Values are "YES", "NO", and "NA"
under Allocation Agreement (Financial                     Investments: AK
Note)
Below Market Interest Rate (Financial           FN             Notes-                                                            
Note)                                                      Investments: AL
What is Interest Rate Comparable?               FN             Notes-                                  Below Market                                     Debt                                               Options include:
                                                          Investments: AM                                                                                                                                  • CDE’s Non-NMTC transaction
                                                                                                   Interest Rate (Financial
                                                                                                                                                                                                           • CDE’s Parent/Affiliate
                                                                                                    Note) = Yes and Date
                                                                                                                                                                                                           • Banks
                                                                                                   Originated > 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                                     Debt                                               Numeric field with no decimals.
(in months)                                               Investments: AT
                                                                                                      Standard Period of
                                                                                                   Interest Only Payments
                                                                                                             = Yes
What is Standard Period of Interest             FN             Notes-                                   Longer than                                     Debt                                               Options include:
Comparable?                                               Investments: AU                                                                                                                                  • CDE’s Non-NMTC transaction
                                                                                                      Standard Period of
                                                                                                                                                                                                           • CDE’s Parent/Affiliate
                                                                                                   Interest Only Payments
                                                                                                                                                                                                           • Banks
                                                                                                       = Yes and Date
                                                                                                                                                                                                           • Other
                                                                                                   Originated > 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                                     Debt                                               Options include: .
Comparable?                                               Investments: AY                                                                                                                                  • CDE’s Non-NMTC transaction
                                                                                                   Standard Amortization
                                                                                                                                                                                                           • CDE’s Parent/Affiliate
                                                                                                   Period = Yes and Date
                                                                                                                                                                                                           • Banks
                                                                                                   Originated > 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
           7/19/2010                                                                                                                  Page 3 of 14
                                                                                                        4c039bce-7408-482c-9943-ae20f1a8c307.xls - CDE QuickStart
                                         Project or        Excel                                                                      Annual                             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
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

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
                                                                                                                                                                                                      (one source for each QEI that sourced the "Disbursement ID.")
                                                                                                QEI 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
                                                                                                                                                                                                      Amounts" (one amount for each QEI that sourced the
                                                                                                QEI is not populated
                                                                                                                                                                                                      "Disbursement 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      

            7/19/2010                                                                                                            Page 4 of 14
                                                                                                           4c039bce-7408-482c-9943-ae20f1a8c307.xls - CDE QuickStart
                                            Project or      Excel                                                                         Annual                             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
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
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,
                                                                                                   Equity Investment AND
                                                                                                                                                                                                              CIIS 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


             7/19/2010                                                                                                               Page 5 of 14
                                                                                                     4c039bce-7408-482c-9943-ae20f1a8c307.xls - CDE QuickStart
                                           Project or     Excel                                                                     Annual                                 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
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
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.



               7/19/2010                                                                                                       Page 6 of 14
                                                                                                        4c039bce-7408-482c-9943-ae20f1a8c307.xls - CDE QuickStart
                                             Project or      Excel                                                                       Annual                                 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
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 Rent per Square Foot                      P        Projects: AI                                                                                            Real Estate
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.)
           7/19/2010                                                                                                               Page 7 of 14
                                                                                                      4c039bce-7408-482c-9943-ae20f1a8c307.xls - CDE QuickStart
                                           Project or      Excel                                                                      Annual                             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
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                                                        
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            P        Projects: BD                                                                                                                                      CIIS Values are "YES", "NO", and "NA"
under Allocation Agreement (Project)
Below Market Interest Rate (Project)           P        Projects: BE                                                        
Blended Interest Rate                          P        Projects: BF                             Below Market                                     Debt                                                   Numeric field with 3 decimals.
                                                                                             Interest Rate (Project) =
                                                                                                        Yes
Comparable Blended Interest Rate               P        Projects: BG                              Below Market                                    Debt                                                   Numeric field with 3 decimals.
                                                                                             Interest Rate (Project) =
                                                                                                        Yes
What is Blended Interest Rate                  P        Projects: BH                              Below Market                                     Debt                                                   Options include: .
Comparable?                                                                                                                                                                                               • CDE’s Non-NMTC transaction
                                                                                             Interest Rate (Project) =
                                                                                                                                                                                                          • CDE’s Parent/Affiliate
                                                                                             Yes and 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

            7/19/2010                                                                                                            Page 8 of 14
                                                                                                    4c039bce-7408-482c-9943-ae20f1a8c307.xls - CDE QuickStart
                                          Project or      Excel                                                                    Annual                             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
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

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                        P        Projects: CL                                                      
Redevelopment Plan
Located in a Hot Zone                         P        Projects: CM                                                      
Appalachian Regional Commission or            P        Projects: CN                                                      
Delta Regional Authority
Colonias
           7/19/2010
                                              P        Projects: CO                                                         Page 9 of 14
                                                                                                    4c039bce-7408-482c-9943-ae20f1a8c307.xls - CDE QuickStart
                                          Project or      Excel                                                                   Annual                             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
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"




           7/19/2010                                                                                                         Page 10 of 14
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

				
DOCUMENT INFO
Description: Multiple Project Value Template document sample