Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

CFI_CRE_Listing_Template_and_Instructions - Excel

VIEWS: 1 PAGES: 15

									                                                                                                                                                                                                                               Listing Instructions for CFI Farm, CFI Business, CFI Agri-Business, and Commercial Real Estate Loans



                                                                This workbook contains four tabs:
                                                                Data Fields and Instructions - Contains the listing data elements and data requirements
                                                                Data Codes - Contains the data codes for the fields indicated in the Description / Format / Example column
                                                                Listing File Template - The data elements arranged in a spreadsheet layout that can be used to prepare a listing file
                                                                Version History - A list of updates (download the workbook from eBanking to ensure you have the latest version)


                                                                By providing the maximum number of data elements (including optional data), the market value of the listed loans may improve.
                                                                The specified format for each data element must be followed in order for the listing file to be accepted.
                                                                Optional data that is not applicable or provided should be left blank.
                                                                Submitted listing files must pass data validation checks before they will be loaded into the FHLBC collateral system.

                                                                There are 2 ways to use this Excel workbook to prepare a listing file in CSV format:
                                                                  1. Work with your IT department to create an automated process (preferred); or
                                                                  2. Manually populate the Listing File Template worksheet and save it in CSV format.
                                                                If manually populating the Listing File Template, please adhere to the following steps and recommendations:
                                                                  1. All data entry and updates must be made to the Listing File Template worksheet while it is in an Excel (.xls) format.
                                                                  2. If pasting data to the worksheet, use "Paste Special… -> Values" in order to retain the cell formatting.
                                                                  3. Upon completion of data entry, save the workbook in its original Excel (.xls) format.
                                                                  4. Once all changes have been made the user should then save the Listing File Template worksheet as a .CSV file.
                                                                     a. To save the file in the .CSV format strike the ALT + F8 keys at the same time to bring up the Macro dialog box.
                                                                     b. The macro to automatically convert the Listing File Template into the .CSV format is titled “Format_And_SaveAsCSV.” Highlight this macro and click on the "Run" button.
                         Loan Types                                  c. When the "Format_And_SaveAsCSV" macro process is completed, a message will appear to verify for the user that the file is ready for uploading into eBanking. If the file is opened after it has been

                B          Small Business CFI                          saved as a .CSV file the leading zeros will fall off, creating formatting errors when the file is submitted. If changes are to be made to the .CSV file, please do so in the Excel version and resave it as a

                F          Small Farm CFI                              .CVS file after all changes have been completed.

                A          Small Agri-Business CFI                   d. In addition to converting the file format, the macro also totals a count of all loans to be processed. This count should be used to verify the number of loans in the listing file against the number the member intended to submit.

                G          Govt. Guaranteed CFI                      e. Once this macro has successfully been run, an authorized signer can upload the listing file into eBanking.

                C          Commercial Real Estate               Submit the listing file by following the Loan Collateral Listing Preparation and Uploading Instructions located under the Collateral QCR and Listing Submission link on eBanking.


                                                      Listing
           Data Required                             Template                                                 Data Type
Required   for Loan Type        Data Number           Column                    Field Name                    (Length)                                                                         Description / Format / Example                                                                                               Notes
                                                                                                                  Text
  Yes          B,F,A,G,C              1                 A              Member ID                                                     Lead zero filled 5 character FHLBC member number (e.g. 174 = 00174)
                                                                                                                  (5)
                                                                                                                  Text
  Yes          B,F,A,G,C              2                 B              Loan Number                                                   Member assigned Loan Number                                                                                                                                           May be alphanumeric and contain dashes.
                                                                                                                  (25)
                                                                                                                                                                                                                                                                                                           If loan has been modified, refinanced or
                                                                                                                                                                                                                                                                                                           renewed since origination, use the loan
                                                                                                                    Numeri
  Yes          B,F,A,G,C              3                 C              Original Loan Balance                                         Rounded to the nearest whole dollar amount (no $, cents, or commas)                                                                                                   amount from the most current note or
                                                                                                                    c
                                                                                                                                                                                                                                                                                                           modification. If a line of credit, use the total
                                                                                                                                                                                                                                                                                                           commitment amount.

                                                                                                                    Numeri
  Yes          B,F,A,G,C              4                 D              Unpaid Principal Balance                                      Rounded to the nearest whole dollar amount (no $, cents, or commas)
                                                                                                                    c
                                                                                                                    Text
  Yes          B,F,A,G,C              5                 E              Property Type                                                 (See Data Codes)
                                                                                                                    (2)
                                                                                                                                                                                                                                                                                                           The percentage of the total guaranteed
                                                                                                                    Numeri
  Yes          G                      6                 F              Guaranteed %                                                  Whole number (75 = 75%)                                                                                                                                               amount owned by the member which is
                                                                                                                    c
                                                                                                                                                                                                                                                                                                           being pledged.

                                                                                                                                                                                                                                                                                                           If loan has been modified, refinanced, or
                                                                                                                    Text
  Yes          B,F,A,C                7                 G              Note Date                                                     YYYYMMDD (e.g. July 1, 1997 = 19970701)                                                                                                                               renewed since origination, use the date
                                                                                                                    (8)
                                                                                                                                                                                                                                                                                                           from the most current note or modification.

                                                                                                                    Text
  Yes          B,F,A,G,C              8                 H              Maturity Date                                                 YYYYMMDD (e.g. June 1, 2020 = 20200601)
                                                                                                                    (8)
                                                                                                                    Text
  Yes          B,F,A,C                9                 I              City                                                          City where the property is located
                                                                                                                    (35)
                                                                                                                    Text
                                      10                J              County                                                        County where the property is located
                                                                                                                    (50)
                                                                                                                    Text
  Yes          B,F,A,C                11                K              State                                                         Two-character State code of state where the property is located, such as “IL”
                                                                                                                    (2)
                                                                                                                    Text
  Yes          B,F,A,C                12                L              Property Zip Code                                             Zip code where the property is located (5 or 10 character format supported)
                                                                                                                    (10)
                                                                                                                    Text
  Yes          B,F,A,G,C              13                M              Next Payment Date                                             YYYYMMDD (e.g. June 1, 2009 = 20090601)
                                                                                                                    (8)
                                                                                                                                                                                                                                                                                                           Monthly P&I is required to be greater than
                                                                                                                    Numeri
  Yes          B,F,A,C                14                N              Principal and Interest Payment                                Rounded to the nearest whole dollar amount (no $, cents, or commas)                                                                                                   0. If interest only, use the most recent
                                                                                                                    c
                                                                                                                                                                                                                                                                                                           payment amount.

                                                                                                                    Text
  Yes          B,F,A,C                15                O              Payment Frequency                                             (See Data Codes)
                                                                                                                    (2)
                                                                                                                    Numeri
                                      16                P              Original Interest Rate                                        Rate multiplied by 1000 and entered as a whole number. (no commas, percentage signs, or decimals) Example: 5.125*1000=5125
                                                                                                                    c
                                                                                                                    Numeri
  Yes          B,F,A,G,C              17                Q              Current Interest Rate                                         Rate multiplied by 1000 and entered as a whole number. (no commas, percentage signs, or decimals) Example: 5.125*1000=5125
                                                                                                                    c
                                                                                                                    Text
                                      18                R              Interest Rate Index                                           (See Data Codes)                                                                                                                                                      ARMs only. Leave blank if fixed rate loan.
                                                                                                                    (2)

                                                                                                                    Text                                                                                                                                                                                   ARMs only. Date of first interest rate
                                      19                S              First Interest Rate Adjustment                                YYYYMMDD (e.g. June 1, 2009 = 20090601)
                                                                                                                    (8)                                                                                                                                                                                    adjustment. Leave blank if fixed rate loan.

                                                                       Interest Rate Adjustment                     Numeri
                                      20                T                                                                            After first interest rate adjustment; whole number in months (e.g. 12 for annually)                                                                                   ARMs only. Leave blank if fixed rate loan.
                                                                       Frequency                                    c

                                                                                                                                                                                                                                                                                                           ARMs only. The maximum rate of interest
                                                                                                                    Numeri
                                      21                U              Lifetime Maximum Rate                                         Rate multiplied by 1000 and entered as a whole number. (no commas, percentage signs, or decimals) Example: 5.125*1000=5125                                            that can be applied to an ARM over the life
                                                                                                                    c
                                                                                                                                                                                                                                                                                                           of the loan. Leave blank if fixed rate loan.


                                                                                                                    Numeri                                                                                                                                                                                 ARMs only. Spread added to index rate for
                                      22                V              Margin                                                        Rate multiplied by 1000 and entered as a whole number. (no commas, percentage signs, or decimals) Example: 5.125*1000=5125
                                                                                                                    c                                                                                                                                                                                      ARMs. Leave blank if fixed rate loan.


                                                                                                                                                                                                                                                                                                           ARMs only. The maximum amount the
                                                                       Periodic Rate Cap after First                Numeri                                                                                                                                                                                 interest rate can increase on each
                                      23                W                                                                            Rate multiplied by 1000 and entered as a whole number. (no commas, percentage signs, or decimals) Example: 5.125*1000=5125
                                                                       Adjustment Date                              c                                                                                                                                                                                      adjustment date after the initial adjustment
                                                                                                                                                                                                                                                                                                           date. Leave blank if fixed rate loan.

                                                                                                                    Text
  Yes          B,F,A,G,C              24                X              Pledge Type                                                   (See Data Codes)
                                                                                                                    (3)
                                                                                                                    Text
                                      25                Y              First Payment Date                                            YYYYMMDD (e.g. April 1, 2009 = 20090401)
                                                                                                                    (8)

                                                                                                                                                                                                                                                                                                           For real estate, use most current
                                                                                                                    Numeri                                                                                                                                                                                 appraised value or original appraisal. For
  Yes          B,F,A,C                26                Z              Appraised Value                                               Rounded to the nearest whole dollar amount (no $, cents, or commas)
                                                                                                                    c                                                                                                                                                                                      non-real estate, use the most recent value
                                                                                                                                                                                                                                                                                                           for the asset(s) securing the loan.

                                                                                                                                                                                                                                                                                                           "Y" if the terms of the note contain a
                                                                                                                    Text
                                      27               AA              Lockout Provision                                             Y = Yes, N = No                                                                                                                                                       provision preventing pre-payment for a
                                                                                                                    (1)
                                                                                                                                                                                                                                                                                                           defined period after origination.

                                                                                                                    Numeri
                                      28               AB              Lockout End Term in Months                                    Whole number in months
                                                                                                                    c

                                                                                                                                                                                                                                                                                                           "Y" if the terms of the note contain a
                                                                                                                    Text
                                      29               AC              Prepayment Penalty Flag                                       Y = Yes, N = No                                                                                                                                                       penalty for pre-payment for a defined
                                                                                                                    (1)
                                                                                                                                                                                                                                                                                                           period after origination.

                                                                                                                                                                                                                                                                                                           The number of months during which a
                                                                                                                    Numeri                                                                                                                                                                                 penalty would be incurred if the loan is
                                      30               AD              Prepayment Penalty Term                                       Whole number in months
                                                                                                                    c                                                                                                                                                                                      prepaid in full. (e.g. No prepayment penalty
                                                                                                                                                                                                                                                                                                           = 0, 1 year = 12)

                                                                                                                                                                                                                                                                                                           Hard: The prepayment penalty is incurred
                                                                                                                                                                                                                                                                                                           regardless of the reason the loan is
                                                                                                                    Text                                                                                                                                                                                   prepaid in full.
                                      31               AE              Prepayment Penalty Type                                       H = Hard, S = Soft
                                                                                                                    (1)                                                                                                                                                                                    Soft: The prepayment penalty is incurred
                                                                                                                                                                                                                                                                                                           only if the loan is prepaid in full due to a
                                                                                                                                                                                                                                                                                                           refinancing.
                                                                                                                    Numeri
                                      32               AF              Amortization Term                                             Whole number in months
                                                                                                                    c




                                                                                                                                                                                                                                                                                                               Page 1 of 15
                                                                                                                                                                                          Listing Instructions for CFI Farm, CFI Business, CFI Agri-Business, and Commercial Real Estate Loans



                                          Listing
           Data Required                 Template                                    Data Type
Required   for Loan Type   Data Number    Column           Field Name                (Length)                                                             Description / Format / Example                                                               Notes
                                                                                         Text                                                                                                                                          ARMs only. Date of next interest rate
                               33          AG       Next Rate Adjustment Date                     YYYYMMDD (e.g. March 1, 2010 = 20100301)
                                                                                         (8)                                                                                                                                           adjustment. Leave blank if fixed rate loan.

                                                                                                                                                                                                                                       ARMs only. The maximum amount the
                                                                                         Numeri                                                                                                                                        interest rate can decrease on each
                               34          AH       Periodic Floor                                Rate multiplied by 1000 and entered as a whole number. (no commas, percentage signs, or decimals) Example: 5.125*1000=5125
                                                                                         c                                                                                                                                             adjustment date. Leave blank if fixed rate
                                                                                                                                                                                                                                       loan.


                                                                                                                                                                                                                                       ARMs only. The minimum rate of interest
                                                                                         Numeri
                               35           AI      Lifetime Floor                                Rate multiplied by 1000 and entered as a whole number. (no commas, percentage signs, or decimals) Example: 5.125*1000=5125           that can be applied to an ARM for the life
                                                                                         c
                                                                                                                                                                                                                                       of the loan. Leave blank if fixed rate loan.


                                                                                         Text                                                                                                                                          Use most current appraisal date. If not
                               36          AJ       Appraisal Date                                YYYYMMDD (e.g. November 1, 2006 = 20061101)
                                                                                         (8)                                                                                                                                           applicable, use original appraisal date.

                                                                                         Numeri                                                                                                                                        Commercial real-estate loans only with
  Yes          C               37          AK       Debt Service Coverage Ratio                   Ratio multiplied by 1000 and entered as a whole number. (no commas, percentage signs, or decimals) Example: 1.160*1000=1160
                                                                                         c                                                                                                                                             property type = 24 or 25.
                                                                                         Numeri
                               38          AL       Net Operating Income                          Rounded to the nearest whole dollar amount (no $, cents, or commas)
                                                                                         c
                                                                                         Numeri
                               39          AM       Number Of Units                               Whole number (1, 2, 3. e.g. CFI Small Business loan secured by property consisting of 6 units = 6)
                                                                                         c
                                                                                         Numeri
                               40          AN       Total Square Footage                          Whole number (no commas)
                                                                                         c
                                                                                         Numeri                                                                                                                                        Internal loan risk rating assigned by
                               41          AO       Loan Rating                                   Whole number
                                                                                         c                                                                                                                                             member.

                                                                                                                                                                                                                                       Percentage of property units or square
                                                                                         Numeri
                               42          AP       Percent Occupied                              Whole number (75 = 75%)                                                                                                              footage securing loan that are occupied by
                                                                                         c
                                                                                                                                                                                                                                       owner and/or leased.


                                                                                                                                                                                                                                       To calculate Loan-to-Value for loans
                                                                                                                                                                                                                                       secured by real estate use the current
                                                                                                                                                                                                                                       unpaid principal balance divided by the
                                                                                         Numeri                                                                                                                                        most current appraised value or original
  Yes          B,F,A,C         43          AQ       Loan-to-Value Ratio                           Value multiplied by 1000 and entered as a whole number. (no commas, percentage signs, or decimals) Example: 87.650*1000=87560
                                                                                         c                                                                                                                                             appraised value. For loans secured by non-
                                                                                                                                                                                                                                       real estate use the most recent valuation
                                                                                                                                                                                                                                       of the asset(s) securing the loan rather
                                                                                                                                                                                                                                       than the appraised value.


                                                                                                                                                                                                                                       If loan is owned by an affiliate/subsidiary or
                                                                                                                                                                                                                                       other entity, enter affiliate/subsidiary or
                                                    Legal Name of Entity that Owns       Text
  Yes          B,F,A,C         44          AR                                                     Legal name of entity that owns loan                                                                                                  other entity's legal name in this field. If the
                                                    Loan                                 (100)
                                                                                                                                                                                                                                       loan is Member-owned, enter the Member
                                                                                                                                                                                                                                       name in this field.

                                                                                         Text
  Yes          B,F,A           45          AS       CFI Collateral Type                           (See Data Codes)
                                                                                         (2)
                                                                                                                                                                                                                                       For loans secured by real estate, the
                                                                                         Numeri                                                                                                                                        number of separate properties securing
                               46          AT       Number of Properties                          Whole number (maximum value of 99)
                                                                                         c                                                                                                                                             the loan. For loans secured solely by non-
                                                                                                                                                                                                                                       real estate, 0.
                                                                                         Text
                               47          AU       Interest Only Flag                            Y = Yes, N = No
                                                                                         (1)
                                                                                         Text
                               48          AV       ARM Flag                                      Y = Yes, N = No
                                                                                         (1)
                                                                                         Text
                               49          AW       Loan Program                                  e.g. USDA, FSA
                                                                                         (4)
                                                                                         Text                                                                                                                                          Required for CRE loans to determine
  Yes          C               50          AX       Renewal                                       Y = Yes, N=No
                                                                                         (1)                                                                                                                                           seasoning.
                                                                                        Text
                               51          AY       Property Name                                 Name of the property
                                                                                        (150)
                                                                                        Text
  Yes          C               52          AZ       CMSA Property Type                            (See Data Codes)
                                                                                        (8)
                                                                                       Text
                               53          BA       Reserved                                      Leave Blank
                                                                                         Numeri
                               54          BB       Interest Only Periods                         Whole number in months
                                                                                         c
                                                                                         Text
                               55          BC       Accrual Method                                e.g. 30/360, 365/365, 360/365
                                                                                         (7)
                                                                                         Numeri
                               56          BD       Servicing Fee                                 Fee multiplied by 1000 and entered as a whole number value (no commas, percentage signs or decimals). Example: 5.000 * 1000 = 5000
                                                                                         c
                                                                                         Text
  Yes          B,F,A,C         57          BE       Street Address                                Street address where the property is located
                                                                                         (50)

                                                                                         Text                                                                                                                                          Borrower as listed under the first signature
  Yes          B,F,A,G,C       58          BF       Borrower Name                                 Full name (First and Last separated by a space)
                                                                                         (30)                                                                                                                                          line of the note.

  Yes                                      BG
               B,F,A,G,C       59                   As Of Date                        Text (8)    YYYYMMDD (e.g. April 1, 2009 = 20090401)                                                                                             Listing effective as of date.




                                                                                                                                                                                                                                        Page 2 of 15
         Listing Data Codes for CFI Farm, CFI Business, CFI Agri-Business, and Commercial Real Estate Loans
Column         Field Name         Code    Description of Code
   E          Property Type        19     Other Construction Loans
                                   20     Land Development and Other Land Loans
                                   21     Small Farm Loans (CFI Only)
                                   24     Loans Secured by Owner-occupied Nonfarm Nonresidential Properties (Commercial RE)
                                   25     Loans Secured by Other Nonfarm Nonresidential Properties (Commercial RE)
                                   26     Small Business Loans (CFI Only)
                                   27     Loans Secured by Automobiles
                                   28     Loans Secured by Other Assets
                                   34     Small Agri-Business Loans (CFI only)
                                   35     Purchased Government Guaranteed Small Farm Loans (CFI Only)
                                   36     Purchased Government Guaranteed Small Business Loans (CFI Only)
                                   37     Purchased Government Guaranteed Agri-Business Loans (CFI Only)

Column         Field Name         Code    Description of Code
   O        Payment Frequency      01     Monthly
                                   02     Quarterly
                                   03     Semi-Annually
                                   04     Annually
                                   05     Other

Column          Field Name        Code    Description of Code
   R        Interest Rate Index    01     Prime
                                   02     1 Month LIBOR
                                   03     2 Month LIBOR
                                   04     3 Month LIBOR
                                   05     6 Month LIBOR
                                   06     9 Month LIBOR
                                   07     12 Month LIBOR
                                   08     Treasury - 3 mos
                                   09     Treasury - 6 mos
                                   10     Treasury - 1 yr
                                   11     Treasury - 2 yr
                                   12     Treasury - 3 yr
                                   13     Treasury - 5 yr
                                   14     Treasury - 7 yr
                                   15     Treasury - 10 yr
                                   16     Treasury - 30 yr
                                   17     Treasury Avg - 12 mos

                                                       Page 3 of 15
         Listing Data Codes for CFI Farm, CFI Business, CFI Agri-Business, and Commercial Real Estate Loans
Column          Field Name         18     USD Swap 1 Year
   R        Interest Rate Index    19     USD Swap 5 Year
                                   20     USD Swap 10 Year
                                   21     COFI
                                   22     Freddie Mac - 1 mo
                                   23     Freddie Mac - 3 mos
                                   24     Freddie Mac - 6 mos
                                   25     Freddie Mac - 12 mos
                                   26     FHLB - 1 yr
                                   27     FHLB - 2 yr
                                   28     FHLB - 3 yr
                                   29     FHLB - 5 yr
                                   30     FHLB - 7 yr
                                   31     FHLB - 10 yr
                                   32     Euribor - 3 mos
                                   33     Euribor - 6 mos
                                   34     Bank of NY US Prime
                                   35     Other

Column         Field Name         Code    Description of Code
   X           Pledge Type        RRM     Renegotiable Rate Mortgage
                                  AGA     Small Agri-Business Adjustable Rate
                                  AGB     Small Agri-Business Balloon Payment
                                  AGF     Small Agri-Business Fixed Rate
                                  CMF     Commercial Fixed Rate
                                  CMA     Commercial Adjustable Rate
                                  CMB     Commercial Balloon Payment
                                  SBA     Small Business Adjustable Rate
                                  SBB     Small Business Balloon Payment
                                  SBF     Small Business Fixed Rate
                                  SFA     Small Farm Adjustable Rate
                                  SFB     Small Farm Balloon Payment
                                  SFF     Small Farm Fixed Rate
                                  CMP     Commercial Participation
                                   IOR    Interest Only Residential
                                   IOC    Interest Only Commercial
                                  FSG     Farm Service Administration Guarantee
                                  USG     U.S. Dept. of Agriculture Guarantee
                                  SBG     Small Business Association Guarantee

                                                       Page 4 of 15
         Listing Data Codes for CFI Farm, CFI Business, CFI Agri-Business, and Commercial Real Estate Loans

Column         Field Name          Code     Description of Code
  AS        CFI Collateral Type     2       CFI SSBL Real Estate
                                    4       CFI SSBL Other
                                    6       CFI Farm Other

Column         Field Name          Code     Description of Code
  AZ        CMSA Property Type      OF      Office
                                    RT      Retail
                                    MF      Multi-family
                                    CH      Coop Housing
                                    LO      Lodging
                                     IN     Industrial
                                    HC      Healthcare
                                    SS      Self Storage
                                    MU      Mixed Use
                                    WH      Warehouse
                                    MH      Mobile Homes
                                    OT      Other
                                    CTL     Credit Tenant Lease
                                  OF-PLUS   Predominantly Office, Mixed Use




                                                         Page 5 of 15
                              CFI Farm, CFI Business, CFI Agri-Business, and Commerical Real Estate
                                                     Loans Listing Template

       A            B                      C                         D                    E                F            G

1   Member ID   Loan Number       Original Loan Balance   Unpaid Principal Balance   Property Type    Guaranteed %   Note Date




                                                             Page 6 of 15
                           CFI Farm, CFI Business, CFI Agri-Business, and Commerical Real Estate
                                                  Loans Listing Template

         H           I                J                       K                        L                   M                          N

1   Maturity Date   City            County                  State               Property Zip Code   Next Payment Date   Principal and Interest Payment




                                                        Page 7 of 15
                                                 CFI Farm, CFI Business, CFI Agri-Business, and Commerical Real Estate
                                                                        Loans Listing Template

           O                      P                           Q                       R                           S                                  T                             U

1   Payment Frequency   Original Interest Rate       Current Interest Rate    Interest Rate Index   First Interest Rate Adjustment   Interest Rate Adjustment Frequency   Lifetime Maximum Rate




                                                                              Page 8 of 15
                                             CFI Farm, CFI Business, CFI Agri-Business, and Commerical Real Estate
                                                                    Loans Listing Template

      V                   W                            X                         Y                     Z                    AA                      AB
             Periodic Rate Cap after First
1   Margin        Adjustment Date                  Pledge Type           First Payment Date      Appraised Value     Lockout Provision   Lockout End Term in Months




                                                                           Page 9 of 15
                                                        CFI Farm, CFI Business, CFI Agri-Business, and Commerical Real Estate
                                                                               Loans Listing Template

             AC                        AD                            AE                     AF                      AG                     AH               AI

1   Prepayment Penalty Flag   Prepayment Penalty Term      Prepayment Penalty Type   Amortization Term    Next Rate Adjustment Date   Periodic Floor   Lifetime Floor




                                                                                     Page 10 of 15
                                                   CFI Farm, CFI Business, CFI Agri-Business, and Commerical Real Estate
                                                                          Loans Listing Template

         AJ                     AK                             AL                     AM                       AN                AO               AP

1   Appraisal Date   Debt Service Coverage Ratio       Net Operating Income     Number Of Units        Total Square Footage   Loan Rating   Percent Occupied




                                                                                Page 11 of 15
                                                           CFI Farm, CFI Business, CFI Agri-Business, and Commerical Real Estate
                                                                                  Loans Listing Template

           AQ                          AR                              AS                      AT                      AU              AV           AW
                          Legal Name of Entity that Owns
1   Loan-to-Value Ratio               Loan                      CFI Collateral Type    Number of Properties     Interest Only Flag   ARM Flag   Loan Program




                                                                                        Page 12 of 15
                              CFI Farm, CFI Business, CFI Agri-Business, and Commerical Real Estate
                                                     Loans Listing Template

      AX           AY                    AZ                      BA                       BB                   BC              BD

1   Renewal   Property Name       CMSA Property Type         RESERVED             Interest Only Periods   Accrual Method   Servicing Fee




                                                           Page 13 of 15
                                     CFI Farm, CFI Business, CFI Agri-Business, and Commerical Real Estate
                                                            Loans Listing Template

         BE               BF                    BG

1   Street Address   Borrower Name           As of Date




                                                                  Page 14 of 15
   Date     Description of Change
2/19/2008   SAMPLE release
2/26/2009   Updates to data in the "Description / Format / Example" and "Notes" columns in the "Data
            Fields and Instructions" tab.
2/27/2009   Changed loan number data type from numeric to text.
            Added "As of Date" field
            Added Macros:
               - formatting helpers
9/10/2009      - save as CSV
9/12/2009   Fixed script formatting issue with column "N" related to zero padding.
9/16/2009   Updated instructions to include the new process for saving files in CSV format.
9/28/2009   Updated formatting macro to ignore date related columns: F, G, L, X, AF, AI, BF
 4/9/2010   Renewal flag requirements updated to include CFI Business and CRE loans.
5/11/2010   Legal Name of Entity that Owns Loan - changed field length from Text(50) to Text(100)
            Changes to reflect New Member Credit Framework requirements
            - Guaranteed % column added
            - "CFI SSBL Collateral Type" title now "CFI Collateral Type"
6/7/2011    - "Interest Rate Index - ARM" title now "Interest Rate Index"




                                                              Page 15 of 15

								
To top