Tertiary Loan Monitoring (TLM) Report

---

Overview

Instructions
Certifications and Signatures
Secondary Loans OC Calculation
Data Template
Loans Dropped from prior month
Hidden

---

Sheet 1: Instructions

CDFI Bond Guarantee Program Phone: (202) 653-0421 Email: [email protected]
TERTIARY LOAN MONITORING REPORT INSTRUCTIONS
The ECDFI that has secondary loans under the CDFI to Financing entity asset class through the CDFI Bond Guarantee Program should complete this CDFI Tertiary Loan Monitoring Report and reflect information pertinent to its own operations, unless otherwise noted. This report should only reflect Tertiary 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
A		ECDFI Loan ID #			Enter Loan ID number for tertiary loan. This should not exceed 25 alpha numeric characters
B		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.
C		ECDFI Name			Enter the "Eligible CDFI's" legal name.
D		Tertiary Loan Pledge Date			Enter the numerical date - two digits for the month, two digits for the day, and four digits for the year (mm/dd/yyyy) - on which the Tertiary Loan was pledge.
E		Reporting Period - Start			Enter the numerical date - two digits for the month, two digits for the day, and four digits for the year (mm/dd/yyyy) - corresponding with the reporting period start date for the information being reported on this form.
F		Reporting Period - End			Enter the numerical date - two digits for the month, two digits for the day, and four digits for the year (mm/dd/yyyy) - corresponding with the reporting period end date for the information being reported on this form.
G		Is Loan New to reporting period?			Select 'Yes' or 'No' from drop down if loan is new to the current reporting period.
H		Address 1			Leave blank
I		Address 2			Leave blank
J		City			Enter the city where tertiary loan is located
K		State or Territory			Enter State or Territory of where tertiary loan is located
L		Zip Code			Enter the 5-digit zip code of where tertiary loan is located
M		N/a			Leave blank
N		N/a			Leave blank
O		Congressional District Number			Enter the Congressional District number of tertiary loan
P		Borrower Census Tract/FIPS Code			Enter the five-digit zip code associated with the "Eligible CDFI's" street address.
Q		Collateral Type			Select one of the collateral type from drop down menu the collateral type of tertiary loan.
R		Original Loan Principal Balance			Enter the principal dollar amount of funds listed on the Tertiary Loan as the original loan amount.
S		Origination Date			Enter the numerical date - two digits for the month, two digits for the day and four digits for the year (mm/dd/yyyy) - on which the Tertiary Loan (and "Co-Borrower," if applicable) signed a legally binding note in favor of the Eligible CDFI submitting this report.
T		Current Unpaid Principal Balance			Enter the Current Loan principal balance amount of funds listed on the Tertiary Loan as the unpaid loan amount.
U		Interest Rate			In the form of a percentage (reported to three 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.
V		Loan Term (Months)			Enter the term of tertiary loan in months
W		Maturity Date			Enter the numerical date - two digits for the month, two digits for the day, and four digits for the year (mm/dd/yyyy) - on which the principal amount of the loan must be repaid in full.
X		Standard Monthly Payment			Enter monthly payment amount of tertiary loan.
Y		Loan Debt Service Frequency			Enter payment frequency of tertiary loan.
Z		Amortization Type			Select from drop down 'Full Amoritization,Partial Amortization, Non-Amortization, or Other'
AA		First Payment Due Date			Enter the numerical date - two digits for the month, two digits for the day, and four digits for the year (mm/dd/yyyy) - on which the first payment of the loan was made.
AB		Last Payment Received			Enter the numerical date - two digits for the month, two digits for the day, and four digits for the year (mm/dd/yyyy) - on which the most recent payment of the loan was made.
AC		Loan Financing Structure Type			Select from drop down 'Origination, Refinance - Origination, Refinance - Acquisition
AD		ECDFI Internal Loan Risk Rating			Enter Numeric or text value of internal score of loan.
AE		Payment Status			Select 'Current' or 'Past Due' from drop down for the payment status of loan.
AF		Total Days Past Due			enter how many days loan is past due. If loan is not past do leave blank.
AG		Loan Restructured, Rescheduled or Modified?			Select 'Yes' or 'No' from drop down if loan has any changes made to the promissory note (i.e. modifications such as change in term, payment etc.)
AH		Date of Loan Restructured, Rescheduled or Modified?			Enter the numerical date - two digits for the month, two digits for the day, and four digits for the year (mm/dd/yyyy) - on which the most recent loan modifications of the loan was made.
AI		Description of Loan Restructured, Rescheduled or Modified?			Enter the reason and type of restructure, reschedule or modifications made.
AJ		Appraisal of Valuation Method			Select from 'Book value', 'Independent third party' or 'Other valuation method' from the drop down of the type of appraisal method used for this tertiary loan.
AK		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 (mm/dd/yyyy) - on which the most recent loan appraisal or valuation date of the loan was made.
AL		Most Recent Inspection Date			Enter the numerical date - two digits for the month, two digits for the day, and four digits for the year (mm/dd/yyyy) - on which the most recent loan was inspected. Do not leave blank enter NA if no known recent date.
AM		Most Recent Appraised Value			Report the dollar value at which the underlying asset securing the loan was most recently appraised.
AN		Current LTV			Enter Current Loan to Value of this loan
AO		Notes/Comments			Enter any additional relevant information about this loan. Word limit of 255 characters or less. If none, please leave blank.
Loans Dropped from Prior Month
A		ECDFI Loan ID #			Enter Loan ID number for tertiary loan. This should not exceed 25 alpha numeric characters
B		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.
C		ECDFI Name			Enter the "Eligible CDFI's" legal name.
D		Is Loan Dropped this Reporting Period?			Select 'Yes' or 'No' from drop down menu if this loan is being released from current reporting period.
E		Principle Amount Paid Off			Enter final amount of loan to pay off total debt
F		Address 1			Leave blank, for any owner occupied homes
G		Address 2			Leave blank, for any owner occupied homes
H		City			Enter the city where tertiary loan is located
I		State or Territory			Enter State or Territory of where tertiary loan is located
J		Zip Code			Enter the 5-digit zip code of where tertiary loan is located
K		Reason For Drop			Enter reason for loan that is being released (i.e. Paid off, non-performing, etc.)
Certifications and Signatures
6		Certifying Official (Name)			Enter the first and last name of the "Eligible CDFI's" approved, "Certifying Official" who is responsible for reviewing and or approving this form.
6a.		Title			Enter the title of the "Eligible CDFI's" approved, "Certifying Official" who is responsible for reviewing and or approving this form.
7		Signature			The "Eligible CDFI's" approved, "Certifying Official" responsible for reviewing and approving this form must manually sign in the space associated with line 7.
7a.		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 "Certifying Official" identified in line 9a signed this form.
Secondary Loans OC Calculation
D2		Frequency			Select 'Monthly' or 'Quarterly' in the drop down for the frequency of TLM Report
D3		Reporting Date			Enter reporting date of the TLM report. This should be the last day of the repoting month
D4		Lender			Enter the ECDFI ticker name
D6		Number of tertiary loans pledged			Enter total count of tertiary loans from 'Data Template' Tab
D7		Tertiary Loans Unpaid Principal Balances (a)			Enter the total sum of all current pledged tertiary loan balances from column T from the 'Data Template' tab.
D8		Cash held in lieu of Tertiary Loans (b)			Enter the amount from The 'Restricted Account' balance used to fulfill OC amount, if needed. If no funds were used to fulfill OC, then list as $0.
D9		Non- performing Tertiary Loan Balances ( c )			if any, enter total balance amounts of all tertiary loan that as of the reporting date is more than 93 days delinquent.
D10		Number of tertiary loans pledged			Enter total count of tertiary loans from 'Data Template' Tab
D11		Secondary Loan Collateral, net (a)+ (b) - ( c )			Calculation: Net balance of Secondary loan collateral inlcuding cash held in restricted account and excluding any non-performing loans.
D13		Secondary Loan(s) Unpaid Principle Balance			Enter the current balance on the secondary loan(s) that the tertiary loan OC amount is being calculated against. Should match the PLM Report collateral balance for same month
D14		Required Overcollateralization rate (Tertiary loans)			Standard overcollateralization percentange for all ECDFIs who have loans in the CDFI to Financing entity asset class.
D15		Required Secondary Loan Overcollateralization Amt			Calculation: OC rate multiply by Secondary Loan UPB.
D17		Amount Over/(Under) Collateralized			Calculation: The amount (if positive) that can be returned to the ECDFI, or (if negative) needs to be placed in the restricted account.

---

Sheet 2: Certifications and Signatures

CDFI Bond Guarantee Program Tertiary Loan Report
For Each Tertiary Loan listed in the following tab, the CDFI undersigned hereby certifies the following:
1. That the Approved Financing Entity’s credit committee, or its equivalent, has approved each Tertiary Loan applicable to such requisition and listed on the following tab in accordance with the applicable Secondary Loan Requirements and the Approved Financing Entity’s underwriting procedures.
2. That the Approved Financing Entity has determined that the borrower of the Tertiary Loan proceeds has incurred costs that are “Costs of the Eligible Purpose” under the Act and the Agreement to Guarantee.
3. That if any Tertiary Loan that is the subject of this requisition is being acquired, or was previously acquired, and is being refinanced, albeit indirectly, with the proceeds of the Advance, the Borrower or the Approved Financing Entity certifies the original acquisition price of such Tertiary Loan and the current unpaid principal balance of such Tertiary Loan together with any additional details requested by Lender or the CDFI Fund for purposes of supporting the amount of the Advance to be allocated, albeit indirectly, to such Tertiary Loan as listed on the following tab.
4. That for any Tertiary Loan listed on the 'Data Template' tab, the requisite documentation to ensure that a perfected security interest in the associated collateral has been filed or is in the process of being filed by the Borrower or Approved Financing Entity.
5. That all original promissory notes and security agreements as well as conforming copies of all mortgages (as filed-stamped and recorded), deeds of trust (as filed-stamped and recorded) and other loan documents, as the case may be, executed in connection with any Tertiary Loan listed on the 'Data Template' tab, have been delivered or in the process of being delivered to the Custodian.
		6. Certifying Official (Name)	6a. Title
		7. Signature	7a. Date

---

Sheet 3: Secondary Loans OC Calculation

Tertiary Loan and Secondary Loan Overcollateralization Calculations
Frequency		Monthly
Reporting Date:
Lender		ABCD
Number of Tertiary Loans pledged
Tertiary Loans Unpaid Principal Balances (a)
Cash held in lieu of Tertiary Loans (b)
Non-Performing Tertiary Loan Balances (c)
COVID-19 Hardship Loan Deferments >93 dpd
Secondary Loan collateral, net (a)+(b)-(c)		$0
Secondary Loan(s) Unpaid Principal Balance
Required Overcollateralization rate (Tertiary loans)		125%
Required Secondary Loan Overcollateralization amt		$0
Amount Over / (Under) Collateralized		$0

---

Sheet 4: Data Template

CDFI Bond Guarantee Program - Tertiary Loan Monitoring Report

Data Template

1

2

3

4

5a

5b

6

7

8a

8b

8c

8d

8e

8f

9a

9b

10a

10b

10c

10d

10e

10f

10g

10h

10i

10j

10k

10l

10m

11a

11b

11c

11d

11e

11f

12a

12b

12c

12d

12e

12f

ECDFI Loan ID #

ECDFI ID#

ECDFI Name

Tertiary Loan Pledge Date

Reporting Period - Start (mm/dd/yyyy)

Reporting Period - End (mm/dd/yyyy)

Is Loan new to reporting period?

Address 1

Address 2

ECDFI City

State or Territory

ECDFI Zip

N/A

N/A

Congressional District Number

Borrower Census Tract/FIPS Code

Collateral Type

Original Loan Principal Balance

Origination Date (mm/dd/yyyy)

Current Unpaid Principal Balance

Interest Rate

Loan Term (Months)

Maturity Date (mm/dd/yyyy)

Standard Monthly Pmt (P&I)

Loan Debt Service Frequency

Amortization Type

First Payment Due Date (mm/dd/yyyy)

Last Payment Received Date (mm/dd/yyyy)

Loan Financing Structure Type

ECDFI Internal Loan Risk Rating

Payment Status

Total Days Payment Past Due

Loan Restructured, Rescheduled or Modified?

Date of Restructure, Resched or Mod (mm/dd/yyyy)

Description of Loan Restructure, Resched or Mod

Appraisal or Valuation Method

Most Recent Appraisal or Valuation Date (mm/dd/yyyy)

Most Recent Inspection Date (mm/dd/yyyy)

Most Recent Appraised Value

Current LTV

Notes/Comments

2/22/2022

---

Sheet 5: Loans Dropped from prior month

ECDFI Loan ID #

ECDFI ID#

ECDFI Name

Is Loan dropped this reporting period?

Principle Amount Paid Off

Address 1

Address 2

ECDFI City

State or Territory

ECDFI Zip

Reason for drop

---

Sheet 6: Hidden

6	10a	10i	10j	10m	11b	11d	12a
Yes	Owner Occupied Homes	Monthly	Full Amortization	Origination	Current	Yes	Book value		Yes	Paid Off
No	Commercial Real Estate	Quarterly	Partial Amortization	Refinance - Origination	Past Due	No	Independent third party appraisal		No	Non-Performing
	Multi-Family	Semi-Annual	Non-Amortization	Refinance - Acquisition			Other Valuation Method			Other
		Other	Other	Construction Ln