Form 6 Pledged Loan Monitoring Report

Bond Guarantee Program

Pledged Loan Monitoring Report.xlsx

Pledged Loan Monitoring Report

OMB: 1559-0044

Document [xlsx]
Download: xlsx | pdf

Overview

Submission Guidelines
Definitions
Instructions
Data Template


Sheet 1: Submission Guidelines

PLM Report Submission Guidelines




Populating the Data File

The Data Template contains sample data for two fictional loans, as an example.

Note: The first data field is for the ECDFI loan ID number for the Secondary Loan or Other Pledged Loan

Note: The Instructions tab and the Definitions tab are copied from the Office of Management and Budget-approved PLM Report form.

Note: Comments have been inserted into many of the column headings to provide clarification on formatting and/or content restrictions on data entries for a given field.

Data is required every month, in every field, except those for which the column heading is highlighted in blue. A complete form must be submitted even if the data for columns highlighted in yellow has not changed. Optional (blue) fields may be left blank if not applicable.









Submitting the Data File

The ECDFI is to post the data file to the Midland SharePoint site by the 20th of each month (or next business day)

The ECDFI is to post a completed and signed .pdf of Page 1 from the official PLM Report form to the Midland SharePoint site by the 20th

The SharePoint site is at:



http://docexchange.commloanservices.com/sites/docexportal/ls/Portfolioadmin/MLSCDFI/default.aspx
The ECDFI will use this template for submisison.

The template used can not be altered, other than the data that is input. The columns and headings will remain and all of the tabs will remain and named as is.

The ECDFI should post the files in their respective document library, to at the path [ECDFI name] > "Reports" > "Pledged Loan Monitoring Report" > [year] folder

When the ECDFI posts the file to the SharePoint site, the QI will receive an email informing them that the file has been posted (if the QI has set up a notice)

A courtesy email to the QI, MS/T and CDFI Fund, that the file is available for review, would also be appreciated

The QI is to review the PLM Report data file within 3 business days of it being posted to the SharePoint site

The QI is to post the reviewed final PLM Report data file to the SharePoint site by the 3rd business day. If the QI makes no changes then there is no need to post the report again.
The QI is to post a completed and signed .pdf of Page 1 from the official PLM Report form, with signatures from the ECDFI and the QI, to the Midland SharePoint site by the 3rd business day.
The QI should post the files in the same folder as the ECDFI.

When the QI has posts the file to the SharePoint site, the MS/T and the CDFI Fund will receive an email informing them that the file has been posted.


Sheet 2: Definitions

CDFI Bond Guarantee Program
Phone: (202) 653-0421 Email: [email protected]










PLEDGED LOAN MONITORING REPORT
DEFINITIONS
OMB Approval No.



1559-0044













Term
Definition
Advance Request Form
The QI submits this form to the FFB to make an advance of funds under, pursuant to, and in accordance with the applicable terms of the Bond.
Asset Class
Approved lending categories for Secondary Loan funds, as outlined in the Secondary Loan Requirements.
Bond Identifier
The FFB assigns a unique number to each Bond.
Book Value
As defined in the Secondary Loan Requirements, "book value" appraisals shall value collateral using the cost approach, net of depreciation, and shall be required for the following: inventory; accounts receivable; machinery, equipment, and movables less than or equal to an aggregate value of $250,000; and fixtures.
Co-Borrower
The individual or entity that is a co-applicant to the Secondary Loan.
Current
Loans for which payments are not currently outstanding beyond the indicated number of days, as of the reporting period end. Loans are considered "current" if a payment was made within the ECDFI's provided loan payment cure period.
Designated Officer
An organizational representative who is listed on the Designated Officers List and is approved to sign programmatic reports that do not require a legally authorized signatory.
Eligible CDFI (ECDFI)
As defined in 12 C.F.R. 1808, a Certified CDFI that has applied through a QI for a Bond Loan, been deemed creditworthy based on the Bond Loan Requirements, has been approved and certified by the Secretary of the Treasury, and has received a Bond Loan.
For-Profit
Based on the IRS categorization for tax purposes.
Full Amortization
Amortization that includes both principal and interest payments throughout the life of the loan.
Independent Third Party Appraisal
As defined in the Secondary Loan Requirements, "independent third party appraisals" shall conform to the standards set forth in The Uniform Standards of Professional Appraisal Practice (USPAP) established by The Appraisal Foundation. Independent third party appraisals shall be required for the following: real estate; all fixtures, machinery and equipment and movables stock valued in excess of an aggregate value of $250,000; and contracted revenue streams from non-federal creditworthy counterparties provided the Secondary Borrower pledges all assets, rights and interests necessary to generate such revenue stream.
Individual
Based on the IRS categorization for tax purposes.
Itemization of Collateral Form
As defined in the Bond Loan Agreement, this means an itemized schedule of Secondary Loans and Other Pledged Loans.
Non-Amortization
An amortization schedule that is structured with interest-only payments, and a single principal or balloon payment at maturity.
Not-for-Profit
Based on the IRS categorization for tax purposes.
Other
All other entity types that do not fit the descriptions of "Not-for-Profit Organization," "For-Profit Business," or "Tribal" are considered to fall under the category of "Other." This includes government or quasi-governmental entities.
Other Pledged Loan
As defined in the Bond Loan Agreement, this refers to other loans pledged as Bond Loan Collateral, owned by the ECDFI, the terms of which comply with the requirements for Secondary Loans such that they would be classified as Secondary Loans if they were made from Bond Loan proceeds.
Other Valuation Method
All other valuation methods that are provided for in the Secondary Loan Requirements and do not fit the description of "Independent Third Party Appraisal" or "Book Value" are considered to fall under the category of "Other Valuation Method." The use of such "Other Valuation Method" is subject to the CDFI Fund's review and approval.
Partial Amortization
An amortization schedule that is structured with some principal payments through the life of the loan, with a larger principal payment at maturity.
Past Due
Loans for which payments are currently outstanding beyond the indicated number of days, exclusive of charge-offs, as of the reporting period end.
Qualified Issuer (QI)
An entity that has applied, and received approval as a QI under the requirements set forth in 12 C.F.R. 1808.200. The QI issues Bonds on behalf of ECDFIs. The FFB purchases these Bonds.
Refinance
As defined in the Bond Loan Agreement, this refers to the use of Bond Proceeds to refinance an ECDFI’s or Secondary Borrower’s existing loan, which loan must have been used for an Eligible Purpose. Refinancing may include origination or acquisition.
Restructured, Rescheduled, or Modified
Loans for which one or more terms has been modified to accommodate borrower hardship or difficulty, or to avoid default. This includes forbearance or forgiveness of principal amounts owed, and the origination of any new loans that replace the outstanding balance of an older or existing loan for such purposes.
Secondary Borrower
An entity that has made application to the ECDFI for a Secondary Loan, been deemed creditworthy by the ECDFI, meets the criteria set forth in the applicable Secondary Loan Requirements to receive a Secondary Loan, and has received a Secondary Loan.
Secondary Loan
The use of Bond Loan proceeds by an Eligible CDFI to finance or "Refinance" a loan to a Secondary Borrower for Eligible Purposes (as defined in 12 C.F.R. 1808), which meets the applicable Secondary Loan Requirements.
Secondary Loan Requirements
As defined in the Bond Loan Agreement, the minimum required criteria, such as is in effect at the time the loan is made or when it becomes an Other Pledged Loan or Secondary Loan established by the CDFI Fund and used by the Borrower (in addition to the Borrower’s underwriting criteria) to evaluate a request by a Secondary Borrower applicant for a Secondary Loan.
Target Market
As defined in the CDFI Fund's Community Investment Impact System (CIIS) Glossary, for the CDFI program, an Investment Area(s), a Low-Income Targeted Population, or an Other Targeted Population.
Tribal
An entity may be a tribal or village government, whether or not it has been federally recognized.
Paperwork Burden Statement
According to the Paperwork Reduction Act, as amended, no persons are required to respond to a collection of information unless it displays a valid Office of Management and Budget (OMB) Approval Number. This form's Approval Number is 1559-0044. Public reporting burden for this collection of information is estimated to average 2.0 hours per response, including time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding the burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to the Community Development Financial Institutions Fund, 1500 Pennsylvania Avenue, NW, Washington, DC 20220.


Sheet 3: Instructions

CDFI Bond Guarantee Program
Phone: (202) 653-0421 Email: [email protected]













PLEDGED LOAN MONITORING REPORT
INSTRUCTIONS

OMB Approval No.




1559-0044




The ECDFI that has received Bond Loan proceeds through the CDFI Bond Guarantee Program should complete this CDFI Pledged Loan Monitoring Report and reflect information pertinent to its own operations, unless otherwise noted. This report should only reflect Pledged Loans with activity during the specified reporting period.

Please refer to the Definitions section of this form for corresponding definitions of terms identified below in "quotations."

Line
Reporting Item
Instructions
1
Federal Agency and Program to Which Report is Submitted
This is for Agency use only, and the information is pre-filled by the receiving Agency.
2
ECDFI ID
Enter the four-letter identification code assigned to the "Eligible CDFI" by the Portfolio Management and Loan Monitoring department of the CDFI Fund Bond Guarantee Program.
3
FFB Bond Identifier
Enter the "Bond Identifier" that the Federal Financing Bank (FFB) assigned to the Bond. This number is listed on the "Advance Request Form."
4
QI Name
Enter the legal name of the "Qualified Issuer" associated with the Guarantee Application.
5a.
Reporting Period - Start
Enter the numerical date - two digits for the month, two digits for the day, and four digits for the year - corresponding with the reporting period start date for the information being reported on this form.
5b.
Reporting Period - End
Enter the numerical date - two digits for the month, two digits for the day, and four digits for the year - corresponding with the reporting period end date for the information being reported on this form.
6
ECDFI Name
Enter the "Eligible CDFI's" legal name.
7
ECDFI EIN
Enter the "Eligible CDFI's" Employer Identification Number (EIN), as provided by the Internal Revenue Service (IRS).
8a.
Line 1
Enter the first line of the "Eligible CDFI's" street address.
8b.
Line 2
If necessary, enter the second line of the "Eligible CDFI's" street address.
8c.
City
Enter the city associated with the "Eligible CDFI's" street address.
8d.
State / Territory
From the dropdown menu, select the two letter state or territory abbreviation associated with the "Eligible CDFI's" street address.
8e.
Zip Code
Enter the five-digit zip code associated with the "Eligible CDFI's" street address.
ECDFI Signatures
9a.
Designated Officer Name
Enter the first and last name of the "Eligible CDFI's" approved, "Designated Officer" who is responsible for reviewing and approving this form.
9b.
Officer Title
Enter the title of the "Eligible CDFI's" approved, "Designated Officer" who is responsible for reviewing and approving this form.
9c.
Signature of the Designated Officer
The "Eligible CDFI's" approved, "Designated Officer" responsible for reviewing and approving this form must manually sign in the space associated with line 9c.
9d.
Date (Month/Day/Year)
Enter the numerical date - two digits for the month, two digits for the day, and four digits for the year - on which the "Designated Officer" identified in line 9a signed this form.
9e.
Designated Officer Name
Enter the first and last name of the "Eligible CDFI's" approved, "Designated Officer" who is responsible for reviewing and approving this form.
9f.
Officer Title
Enter the title of the "Eligible CDFI's" approved, "Designated Officer" who is responsible for reviewing and approving this form.
9g.
Signature of the Designated Officer
The "Eligible CDFI's" approved, "Designated Officer" responsible for reviewing and approving this form must manually sign in the space associated with line 9g.
9h.
Date (Month/Day/Year)
Enter the numerical date - two digits for the month, two digits for the day, and four digits for the year - on which the "Designated Officer" identified in line 9e signed this form.
9i.
Date on Which ECDFI Submitted Report to QI
Enter the numerical date - two digits for the month, two digits for the day, and four digits for the year - on which the "Eligible CDFI" submitted this report to the respective "Qualified Issuer."
QI Signatures
10a.
Designated Officer Name
Enter the first and last name of the "Qualified Issuer's" approved, "Designated Officer" who is responsible for reviewing and approving this form.
10b.
Officer Title
Enter the title of the "Qualified Issuer's" approved, "Designated Officer" who is responsible for reviewing and approving this form.
10c.
Signature of the Designated Officer
The "Qualified Issuer's" approved, "Designated Officer" responsible for reviewing and approving this form must manually sign in the space associated with line 10c.
10d.
Date (Month/Day/Year)
Enter the numerical date - two digits for the month, two digits for the day, and four digits for the year - on which the "Designated Officer" identified in line 10a signed this form.
10e.
Date on Which QI Submitted Report to Master Servicer/Trustee
Enter the numerical date - two digits for the month, two digits for the day, and four digits for the year - on which the "Qualified Issuer" submitted this report to the Master Servicer/Trustee.
Secondary Borrower Profile
11a.
Secondary Borrower Name
Enter the "Secondary Borrower's" legal name.
11b.
Secondary Borrower ID
Enter the unique identification number that the "Eligible CDFI" uses to identify the "Secondary Borrower" listed in line 10a.
11c.
Secondary Borrower Type
From the dropdown menu, select the "Secondary Borrower's" organization type ("Individual," "Not-for-Profit," "For-Profit," "Tribal," or "Other").
11d.
Secondary Borrower Address - Line 1
Enter the first line of the "Secondary Borrower's" street address.
11e.
Secondary Borrower Address - Line 2
If necessary, enter the second line of the "Secondary Borrower's" street address.
11f.
Secondary Borrower Address - City
Enter the city associated with the "Secondary Borrower's" street address.
11g.
Secondary Borrower Address -
State / Territory

From the dropdown menu, select the two letter state or territory abbreviation associated with the "Secondary Borrower's" street address.
11h.
Secondary Borrower Address - Zip Code
Enter the five-digit zip code associated with the "Secondary Borrower's" street address.
11i.
Secondary Borrower Congressional District
Enter the state-level congressional district number associated with the "Secondary Borrower's address."
11j.
Secondary Borrower Census Tract / FIPS Code
The CDFI Fund Information and Mapping System (CIMS3) has an integrated feature that allows institutions to extract detailed geographic information about addresses in the United States. CIMS3 may be accessed from the CDFI Fund's website, www.cdfifund.gov. Utilize the search features within CIMS3 to report the 11-digit Census Tract identifier, or Federal Information Processing Standards (FIPS) code, that corresponds to the "Secondary Borrower's" indicated address. Please note that, as Census Tract boundaries may change over time, this information should be verified periodically. For more information about CIMS3, contact the CDFI Fund by email at [email protected], or by phone at (202) 653-0300.
Note: The "Secondary Co-Borrower Information" section (lines 11k - 11t) should only be completed in the event that a "Co-Borrower" is listed on the "Secondary Loan" or "Other Pledged Loan."
11k.
Co-Borrower Name
If applicable, enter the Secondary "Co-Borrower's" legal name.
11l.
Co-Borrower ID
If applicable, enter the unique identification number that the Eligible CDFI uses to identify the Secondary "Co-Borrower" listed in 11k. This number is used to track the Secondary "Co-Borrower" across projects and reporting periods.
11m.
Co-Borrower Type
From the dropdown menu, select the Secondary "Co-Borrower's" organizational type ("Individual," "Not-for-Profit," "For-Profit," "Tribal," or "Other").
11n.
Co-Borrower Address - Line 1
If applicable, enter the first line of the Secondary "Co-Borrower's" street address.
11o.
Co-Borrower Address - Line 2
If applicable, enter the second line of the Secondary" Co-Borrower's" street address.
11p.
Co-Borrower Address - City
If applicable, enter the city associated with the Secondary "Co-Borrower's" street address.
11q.
Co-Borrower Address - State / Territory
If applicable, select the two letter state or territory abbreviation from the dropdown menu that is associated with the Secondary "Co-Borrower's" street address.
11s.
Co-Borrower Address - Zip Code
Enter the five-digit zip code associated with the Secondary "Co-Borrower's" street address.
11t.
Co-Borrower Census Tract / FIPS Code
See instructions for line 11j.
11u.
Is this loan being made to an approved, eligible Target Market?
From the dropdown menu, select either Yes or No to verify whether the loan is being made in one of the ECDFI's approved, eligible "Target Markets."
Loan Profile
12a.
Collateral Type
From the dropdown menu, select the collateral type (either "Secondary Loan" or "Other Pledged Loan.")
12b.
Original Loan Principal Balance
Enter the principal dollar amount of funds listed on the "Secondary Loan" or "Other Pledged Loan" as the original loan amount.
12c.
Origination Date
Enter the numerical date - two digits for the month, two digits for the day and four digits for the year - on which the "Secondary Borrower" (and "Co-Borrower," if applicable) signed a legally binding note in favor of the Eligible CDFI submitting this report.
12d.
Asset Class
From the dropdown menu, select the "Asset Class" corresponding to the loan.
12e.
Outstanding Balance
Report the loan's principal balance outstanding as of the reporting period end date listed in 5b.
12f.
Interest Rate
In the form of a percentage (reported to two decimal places), enter the interest rate in effect on the loan at the reporting period end. If the loan was paid off during the reporting period, report the interest rate at the time that the loan was paid off.
12g.
Maturity Date
Enter the numerical date - two digits for the month, two digits for the day, and four digits for the year - on which the principal amount of the loan must be repaid in full.
12h.
Loan Debt Service Frequency
From the dropdown, select the frequency (Monthly, Quarterly, Semi-Annual, or Other) with which debt service is paid on the loan.
12i.
Amortization Type
From the dropdown menu, select the amortization type for the loan (either "Full Amortization," "Partial Amortization," "Non-Amortization," or "Other")
12j.
First Payment Due Date
Enter the numerical date - two digits for the month, two digits for the day, and four digits for the year - on which the "Secondary Borrower" was required to make the initial payment on the loan. Include both principal and interest payments.
12k.
Last Payment Received Date
Enter the numerical date - two digits for the month, two digits for the day, and four digits for the year - on which the "Secondary Borrower" made the most recent payment on the loan. Include both principal and interest payments.
12l.
Loan Financing Structure Type
From the dropdown menu, select the loan's financing structure type (Origination, Refinance - Origination, or Refinance - Acquisition) (see Definitions tab for "Refinance").
12m.
Was Secondary Borrower or Co-Borrower previously unable to access affordable, conventional sources of capital?
From the dropdown menu, select either Yes or No as to whether the "Secondary Borrower" or "Co-Borrower" was previously unable to access affordable, conventional sources of capital, prior to receiving the loan in question.
Risk Profile
13a.
ECDFI Internal Loan Risk Rating
Report the risk rating that the "Eligible CDFI" assigns to the loan in question.
13b.
Payment Status
From the dropdown menu, select the appropriate loan payment status at the reporting period end - either "Current" or "Past Due." If a "Secondary Borrower" made a partial payment on the due date, or if any of the required amount remains outstanding, report that payment as past due.
13c.
Total Days Payment Past Due
If the response listed on line 13b is " Past Due," report the number of days by which the "Secondary Borrower's" loan payment is "Past Due."
13d.
Number of Times 30-59 Days Past Due
Report the number of times that payments on the loan have been between 30 and 59 days "Past Due" since the pledge date listed on the 'Itemization of Collateral" form.
13e.
Number of Times 60-89 Days Past Due
Report the number of times that payments on the loan have been between 60 and 89 days "Past Due" since the pledge date listed on the 'Itemization of Collateral" form.
13f.
Number of Times 90 Days or More Past Due
Report the number of times that payments on the loan have been between more than 90 days "Past Due" since the pledge date listed on the 'Itemization of Collateral" form.
13g.
Loan Restructured, Rescheduled, or Modified?
From the dropdown menu, select either Yes or No as to whether the loan has been "Restructured, Rescheduled, or Modified" within the current reporting period.
13h.
Date of Loan Restructure, Reschedule, or Modification
If the response listed on line 13g is Yes, enter the numerical date - two digits for the month, two digits for the day, and four digits for the year - on which the loan was "Restructured, Rescheduled, or Modified."
13i.
Description of Loan Restructure, Reschedule, or Modification
If the response listed on line 13g is Yes, provide a brief description (255 characters maximum) as to why the loan was "Restructured, Rescheduled, or Modified," and report the new loan terms.
Underlying Asset Profile
14a.
Underlying Asset Description
Provide a brief description (255 characters maximum) of the underlying asset(s) that is used to secure the loan. This description should note the location of the asset (city and state), asset type (e.g., real property, personal property, fixtures), building use (e.g., office building, residential building), and include a brief description of any third-party guarantees provided on the Secondary Loan (e.g., value, guarantor name). For Secondary Loans that are supported by tertiary or quaternary loans, please limit the information listed in 14a to that which concerns the underlying physical asset(s) securing the loan and do not provide information on any underlying loans (e.g., loan balance, borrower). Should multiple assets be used to secure the loan, such that the descriptive content requested here exceeds the character limitation, supplementary documentation may be provided to the CDFI Fund and Master Servicer/Trustee in a format approved previously by the CDFI Fund.
14b.
Appraisal or Valuation Method
From the dropdown menu, select the method ("Book Value," "Independent Third Party Appraisal," or "Other Valuation Method") that the ECDFI used to appraise or value the underlying asset for the loan in question, as required and outlined in the "Secondary Loan Requirements."
14c.
Most Recent Appraisal or Valuation Date
Enter the numerical date - two digits for the month, two digits for the day, and four digits for the year - on which the underlying asset that is used to secure the loan (and described in line 14a) was most recently appraised or valued. In instances where multiple assets are used to secure the loan, only one appraisal or valuation date may be listed. Such date should correspond to the date on which the value listed in line 14e was generated.
14d.
Most Recent Inspection Date
Enter the numerical date - two digits for the month, two digits for the day, and four digits for the year - on which the underlying asset securing the loan (and described in line 14a) was most recently inspected. Underlying assets should be re-inspected according to the frequency outlined in the ECDFI's policies and procedures. In instances where multiple assets are used to secure the loan, only one inspection date may be listed. Such date should correspond to the date on which the majority of the assets listed in line 14a were inspected.
14e.
Most Recent Appraised Value
Report the dollar value at which the underlying asset securing the loan (and described in line 14a) was most recently appraised. In instances where multiple assets are used to secure the loan and multiple appraisals were generated, the ECDFI shall provide additional documentation to the CDFI Fund and Master Servicer/Trustee, in a format approved previously by the CDFI Fund, that illustrates the contribution of each individual asset's most recent appraised value toward the total value listed on this line.














Sheet 4: Data Template

CDFI Bond Guarantee Program - Pledged Loan Monitoring Report









































































Data Template









































































1 2 3 4 5a 5b 6 7 8a 8b 8c 8d 8e 9a 9b 9c 9d 9e 9f 9g 9h 9i 10a 10b 10c 10d 10e 11a 11b 11c 11d 11e 11f 11g 11h 11i 11j 11k 11l 11m 11n 11o 11p 11q 11r 11s 11t 11u 12a 12b 12c 12d 12e 12f 12g 12h 12i 12j 12k 12l 12m 13a 13b 13c 13d 13e 13f 13g 13h 13i 14a 14b 14c 14d 14e
alpha numeric, not to exceed 25 characters ECDFI Loan ID # ECDFI ID# FFB Bond Identifier Qualified Issuer Name Reporting Period - Start
(mm/dd/yyyy)
Reporting Priod - End
(mm/dd/yyyy)
ECDFI Name ECDFI EIN ECDFI Address 1 ECDFI Address 2 ECDFI City Use the 2 letter state or territory abbreviation. ECDFI State or Territory Use five digit zip code. ECDFI Zip Leave blank NA Leave blank NA Leave blank NA Leave blank NA Leave blank NA Leave blank NA Leave blank NA Leave blank NA Leave blank NA Leave blank NA leave blank NA Leave blank NA Leave blank NA Leave blank NA Secondary Borrower Name Secondary Borrower ID One of the following: Individual Not-for-Profit For-Profit Tribal Other These are case sensitive Secondary Borrower Type Secondary Borrower Address 1 If NA, leave blank Secondary Borrower Address 2 Secondary Borrower Address - City Use the 2 letter state or territory abbreviation. Secondary Borrower Address - State/Territory Use 5 digit zip code. Secondary Borrower Address - Zip Code Input should be only numeric: the district number - limited to three characters Secondary Borrower Congressional District Number See instructions Secondary Borrower Census Tract/FIPS Code If NA, leave blank Co-Borrower Name If NA, leave blank Co-Borrower ID If NA, leave blank If applicable, one of the following: Individual Not-for-Profit For-Profit Tribal Other These are case sensitive Co-Borrower Type If NA, leave blank Co-Borrower Address 1 If NA, leave blank Co-Borrower Address 2 If NA, leave blank Co-Borrower City If NA, leave blank. If applicable, use the 2 letter state or territory abbreviation. Co-Borrower State or Territory If NA, leave blank. If applicable, use 5 digit zip code. Co-Borrower Zip Code If NA, leave blank If applicable, input should be only numeric: the district number - limited to two characters Co-Borrower Congressional District Number See instructions Co-Borrower Census Tract/FIPS Code "Yes" or "No" Case Sensitive Is loan made to an approved, eligible Target Market One of the following: Secondary Loan Other Pledged Loan Case Sensitive Collateral Type Original Loan Principal Balance Origination Date One of the following: CDFI-to-CDFI CDFI to Financing Entity Charter School Commercial Real Estate Daycare Center Healthcare Facility Senior Living and Long Term Care Facility Not-for-Profit Organization Owner-Occupied Home Rental Housing Rural Infrastructure Small Business (for-profit) Case Sensitive Asset Class Outstanding Balance Report in form of a percentage, to two decimal points. Example: 3.35 Interest Rate Maturity Date
(mm/dd/yyyy)
One of the following: Monthly Quarterly Semi-Annual Other Case Sensitive Loan Debt Service Frequency One of the following: Full Amortization Partial Amortization Non-Amortization Other Case Sensitive Amorization Type First Payment Due Date
(mm/dd/yyyy)
Last Payment Received Date
(mm/dd/yyyy)
One of the following: Origination Refinance - Origination Refinance - Acquisition Case Sensitive Loan Financing Structure Type See Instructions, "Yes" or "No" Was Borrower unable to access conventional capital? numeric or text - max 255 characters ECDFI Internal Loan Risk Rating One of the following: Current Past Due Case Sensitive Payment Status If NA leave blank Total Days Payment Past Due If NA leave blank Number of Times 30-59 Days Past Due If NA leave blank Number of Times 60-89 Days Past Due If NA leave blank Number of Times 90 Days or More Past Due "Yes" or "No" Case Sensitive Loan Restructured, Rescheduled or Modified? If NA leave blank Date of Restructure, Resched or Mod
(mm/dd/yyyy)
If NA leave blank. If applicable, text - maximum of 255 characters Description of Loan Restructure, Resched or Mod See instructions. Text entry maximum of 255 characters. Underlying Asset Description See instructions. Enter one of the following: "Book Value," "Independent Third Party Appraisal," or "Other Valuation Method." Case sensitive. Appraisal or Valuation Method Most Recent Appraisal or Valuation Date
(mm/dd/yyyy)
Most Recent Inspection Date
(mm/dd/yyyy)
Most Recent Appraised Value
AY7695876 ABCD CDFIQI 0001 Community Development Corporation QI 8/15/2015 9/15/2015 Community Helping Hands 71-555889 Alpha Avenue Suite 100 New York NY 10018













Happy Childcare 852963 Not-for-Profit 1253 Appeldorn
Somewhere NY 10023 24 12365498735 Mega Childcare 582693 Not-for-Profit 1356 Maple Lane Suite 200 Somewhere NY 10023 24 35697648215 Yes Secondary Loan 10000000 3/28/2014 Daycare Center 9850000 3.35 3/28/2042 Monthly Full Amortization 4/1/2014 4/1/2014 Origination Yes 3 Current



Yes 12/13/2013 Rescheduled Daycare center building and HVAC located in Newark, NJ Independent Third Party Appraisal 12/1/2013 12/1/2013 12000000
CLGG-295-01 EFGH CDFIQI 0001 Community Development Corporation QI 8/15/2015 9/15/2015 Building Community 71-624387 Bravo Street
Tampa FL 92630













Mortis Healthcare 741852 For-Profit 26 Katwijkweg
Anywhere CA 56231 11 26523987354










Secondary Loan 7500000 6/15/2013 Healthcare Facility 7480000 3.42 4/25/2041 Monthly Non-Amortization 7/1/2013 2/1/2014 Refinance - Acquisition Yes Stable Past Due 45 1

Yes 6/13/2013 Modification Hospital building, hvac and medical equipment in San Diego, CA Independent Third Party Appraisal 6/13/2013 5/5/2013 9000000























































































































































































































































































































































































































































































































































































































File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy