Docstoc

cdfiTLRexcelSample

Document Sample
cdfiTLRexcelSample Powered By Docstoc
					Submitter Transmission
ID                         Project Number       Originator Transaction ID Client ID

               11/1/2006                    1   Tran - 1                  ID 118
                                            1   Tran - 1
                                            1   Tran - 1
                                            2   Tran - 2a                 ID 726
                                            2   Tran - 2b                 ID 726
                                                Tran - 3                  ID 929
                                         Original
                                         Loan/Investment
Investee Type   Date Originated          Amount              Purpose

BUS                           07/04/03              100,000.50 RERHCOM


CDFI                          07/04/03              150,000.75 RECOCOM
CDFI                          08/04/03                  35,000 RECOCOM
IND                           10/22/05              250,550.00 BUSINESS
Transaction Type   Interest Rate        Interest Type   Points

TERM                               4.200 FIXED                   2.000000


LOC                                4.200 ADJ                     3.250000
TERM
DEBTEQTY                           3.750 FIXED                   1.250000
Origination Fees      Amortization Type   Equity-Like Features   Term

                   125 FULLAMORT          NONE                          24


                    0 NONAMORT            OTHER                         60

                      PARTAMORT                                         120
Date First Payment
Due                   Guarantee   Lien Position   Collateral Type

              07/12/03 PERSONAL   FIRST           REC


              07/12/04 SBA        SECOND          VEH

                      USDA        OTHER           OTHER
Collateral Value At                                                         Investee Street
Origination                       Equity Injection Amount Forgivable Loan   Address Line 1

                      2,500,000                1,250,000 YES


                        50,000                    10,000 NO                 4501 Ford Avenue
                                                                            4501 Ford Avenue
                         1,000                         0 NO                 4501 Ford Avenue
Investee Street
Address Line 2    Investee City   Investee State   Investee Zip Code 5




Suite 1400        Alexandria      VA                               22302
Suite 1400        Alexandria      VA                               22302
Suite 1400        Alexandria      VA                               22302
Investee Zip Code Plus                      Project Street Address Line Project Street Address Line
4                      Investee FIPS Code   1                           2

                               13277990500 4501 Ford Avenue             Suite 1400
                                           601 13th St., NW             Suite 200 South

                 1435                       4501 Ford Avenue            Suite 1400
                 1435                       4501 Ford Avenue            Suite 1400
                 1435                       4501 Ford Avenue            Suite 210
Project City   Project State   Project Zip Code 5       Project Zip Code Plus 4

Alexandria     VA                               22302                     1435
Washington     DC                               20005                     3807

Alexandria     VA                               22302
Alexandria     VA                               22302
Alexandria     VA                               22302
Project FIPS Code      NAICS             SIC Code          Date Business Established

                       FP1234                       1234                    11/07/81

         13277990500
                                223344
                                                Women Owned or   Low Income Owned or
Entity Structure   Minority Owned or Controlled Controlled       Controlled

NONPROFIT          NO                        NO                  YES


TRIBAL             YES                       YES                 YES

FORPROFIT          YES                       YES                 NO
Jobs at Time of        Principal Balance
Loan/Investment        Outstanding           Loan Status   Days Delinquent

                                      100,000 REFIN                          120


                                       10,000 SOLD                            0
                                       30,000 ACTIVE                          0
                  15                   25,000 ACTIVE                          0
Number of Times 60
Days or More             Number of Times Loan Number of Times the       Refinanced-Original
Delinquent               Restructured         Loan Was Refinanced       Transaction ID

                     2                       1                      5 Tran-A


                     1                       1                      0
                                        Fair Value at   Fair Value at End of
Amount Charged Off   Amount Recovered   Origination     Reporting Period
Annual Gross Revenue
and Business                                  DS/FCOS Hours of
Operations Reported                           Assistance Provided
During the Reporting Jobs at Reporting        During Reporting
Period               Period End               Period                  Low-Income Status

            2,500,000                                           350


              250,000                                           160

                                         25                         80 VERYLOW
Other Targeted
Populations      LITP End Users   OTP End Users   IA End Users

NO               NO               NO              YES


NO               NO               YES             YES
HZ End Users   Credit Score         Gender   Race

YES                           640            WHITE


YES                           750 FEMALE     AMIND

                              450            HAWAIIAN
                  Female- Headed                         Banked at Time of
Hispanic Origin   Household        First-Time Home Buyer Intake

NO                NO                                     YES


NO                YES                                    YES

NO                NO                                     NO
                             DS/FCOS Hours of         DS/FCOS Hours of         Annual Gross Revenue from
Rejected by Bank or Credit   Assistance at Time of    Assistance - Post        Business Operations at
Union                        Investment               Loan/Investment          Time of Loan/Investment

NO                                              125                       75                     575,000


NO                                               40                       80

NO
                                                                                    Projected Jobs to be
                          Total Project Cost -      Total Project Cost - Affiliates Created at Businesses
Total Project Cost        Public Sources            & Related Program               Financed

               750,000                    650,000


              1,000,000
              1,000,000
                350,550                   200,000                       100,000                        25
                       Projected Jobs to be
Projected Jobs to be   Created at Tenant                            Capacity of Educational
Created - Construction Businesses              Community Facility   Community Facility

                    50                        0 NO


Don't Know               Don't Know            YES                  Don't Know
Not Applicable           Not Applicable        YES                  Not Applicable
Capacity of Childcare   Capacity of Healthcare Capacity of Arts Center Capacity of Other
Community Facility      Community Facility     Community Facility      Community Facility




                   200 Don't Know                                    0                    5000
                    35 Not Applicable          Not Applicable            Not Applicable
Square Feet of Real     Square Feet of Real    Square Feet of Real     Square Feet of Real
Estate - Total          Estate - Manufacturing Estate - Office         Estate - Retail

                 4000                        0                  3500                         500


Not Applicable                           3000                   1100                          0
Don't Know              Don't Know               Don't Know            Don't Know
Asking Rent Per                                                             Affordable Housing
Square Foot            Housing Units - Sale        Housing Units - Rental   Units - Sale

Don't Know             Don't Know                                      45 Don't Know


                  75                          89                       45                        23
                  75                          89                       45                        23
Affordable Housing                                     Other Impact (1) -      Other Impact (2) -
Units - Rental            Other Impact (1) - Explain   Number of Units         Explain

                     45 Provide Housing to seniors                          12 Childcare Slots


                     45
                     45
Other Impact (2) -
Number of Units

                 66

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:7
posted:5/16/2012
language:
pages:26
fanzhongqing fanzhongqing http://
About