7.1. HRSR 12-06-2021 �j
City of
Elk Request for Action
River
To Item Number
Housing and Redevelopment Authority 7.1
Agenda Section Meeting Date Prepared by
General Business December 6, 2021 Brent O'Neil, Economic Development Director
Item Description Reviewed by
HRA Housing Rehabilitation Loan Program Update Cal Portner, City Administrator
Reviewed by
Action Requested
Receive update on the Rehabilitation Loan Program.
Background/Discussion
CEE reports all accounts are current and the HRA's portfolio is performing as expected with no delinquencies
or late payments.
Financial Impact
N/A
Mission/Policy/Goal
The goal of the HRA is to improve existing housing stock by offering incentives or programs to repair and
maintain residential properties.
Attachments
■ CEE Monthly Loan Activity Report
The Elk River Vision
A welcom' community with revolutionary and spirited resourcefulness, exceptional p o w E A E u e r
service, and community engagement that encourages and inspires prosperity®
CITY OF ELK RIVER
LOAN SERVICING REPORT
OPERATIONAL RESULTS
OCTOBER 2021
November 1st, 2021
LOAN SERVICING DEPARTMENT
DocuSign Envelope ID: D2465DD7-9CF5-4E85-B350-C2DF80BFEC80
Pg. 2
Table of Contents
•Loan Servicing Dashboard•Invoice Report•Trial Balance Summary•Trial Balance Detail•Aging Delinquency Report
DocuSign Envelope ID: D2465DD7-9CF5-4E85-B350-C2DF80BFEC80
CEE SERVICING
REPORT TYPE:LOAN SERVICING DASHBOARD
DATA SET DATE:11/1/2021
REPORTING PERIOD:Oct-21
INVESTOR:CITY OF ELK RIVER
CASH PROCESSING RESULTS AS OF OCTOBER 31, 2021
OPERATIONAL RESULTS AS OF OCTOBER 31, 2021
10
8
7 7 7 7
5
6
7
8
9
10
11
May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21
6 MONTH LOAN COUNT COMPARISON
$76,510.48$99,440.17$100,641.20$101,837.78$103,044.71$106,270.97Oct-21Sep-21Aug-21Jul-21Jun-21May-21
UNPAID PRINCIPAL BALANCE 6 MONTH COMPARISON
$0.00
$8,275.92
$12,183.75
$12,217.85
$12,333.73
$13,627.92
$17,871.31
$0.00 $2,000.00 $4,000.00 $6,000.00 $8,000.00 $10,000.00 $12,000.00 $14,000.00 $16,000.00 $18,000.00 $20,000.00
19-016434
19-015215
19-015209
19-015204
19-016564
19-015206
19-015217
OCTOBER-2021 UNPAID PRINCIPAL BALANCE
DISTRIBUTION PER LOAN
$154.43
$162.79
$187.63
$192.33
$208.04
$400.00
$21,950.12
$0.00 $5,000.00 $10,000.00 $15,000.00 $20,000.00 $25,000.00
19-016564
19-015217
19-015209
19-015215
19-015204
19-015206
19-016434
TOTAL AMOUNT COLLECTED AS OCTOBER 31, 2021
$100.02
$113.51
$159.73
$177.22
$182.55
$354.04
$21,842.62
$0.00 $5,000.00 $10,000.00 $15,000.00 $20,000.00 $25,000.00
19-015217
19-016564
19-015209
19-015215
19-015204
19-015206
19-016434
TOTAL PRINCIPAL COLLECTED AS OF OCTOBER 31, 2021
$15.11
$25.49
$27.90
$40.92
$45.96
$62.77
$107.50
$0.00 $20.00 $40.00 $60.00 $80.00 $100.00 $120.00
19-015215
19-015204
19-015209
19-016564
19-015206
19-015217
19-016434
TOTAL INTEREST COLLECTED AS OF OCTOBER 31, 2021
DocuSign Envelope ID: D2465DD7-9CF5-4E85-B350-C2DF80BFEC80
CEE SERVICING
REPORT TYPE: PRELIMINARY INVOICE REPORT
DATA SET DATE: 11/1/2021
REPORTING PERIOD:Oct-21
INVESTOR:ELK RIVER 212 3rd Avenue North, Suite 560
INVOICE #:8202110 Minneapolis, MN 55401
REPORTING MONTH: OCTOBER 2021 Ph.: 612.455.7805
POOL Total Count of
Loans New Loans Added Loans Transferred for
Serviving
Count of Active
Delinquent Accounts
Total Amount Collected
During the Month
Principal Collected During
the Month
Interest Collected During
the Month
New Loan On-
boarding Fee @
$20/Account
Loan Transfer On-
Boarding Fee @
$20/Account
Monthly Servicing
@ $6/Account
Delinquent Loan
Management @
$3/Account
Total Monthly
Fees
Netted Amount to
Transfer to Investor
Row Labels Count of LOAN # Sum of NEW LN INDEX Sum of TRNX INDEX Sum of DELINQ INDEX Sum of PMNT AMOUNT Sum of PRN COLLECTED Sum of INT COLLECTED
HRA REHAB 7 0 0 0 $23,255.34 $22,929.69 $325.65 $0.00 $0.00 $42.00 $0.00 $42.00 $23,213.34
Grand Total 7 0 0 0 $23,255.34 $22,929.69 $325.65 $0.00 $0.00 $42.00 $0.00 $42.00 $23,213.34
ACCOUNT DETAIL FOR INVOICING
PORTFOLIO POOL LOAN #PROPERTY CONTRACT DATE LOAN AMOUNT PMNT DATE PMNT AMOUNT PRN COLLECTED INT COLLECTED TRNX INDEX NEW LN INDEX DELINQ INDEX
ELK RIVER RESIDENTIAL HRA REHAB 19-015215 606 JEFFERSON LN NW 8/3/2015 $20,650.00 10/12/2021 $192.33 $177.22 $15.11 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-015204 1420 5TH ST NW 1/25/2017 $22,069.00 10/20/2021 $208.04 $182.55 $25.49 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-015209 609 GATES AVE NW 9/22/2017 $19,665.00 10/10/2021 $187.63 $159.73 $27.90 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-015217 1811 MAIN ST 5/4/2018 $21,640.00 10/10/2021 $162.79 $100.02 $62.77 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-015206 870 VERNON AVE 12/27/2018 $25,000.00 10/29/2021 $400.00 $354.04 $45.96 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-016434 19135 TROY STREET NW 7/5/2019 $25,000.00 10/9/2021 $21,950.12 $21,842.62 $107.50 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-016564 403 3RD ST NW 7/15/2019 $15,252.22 10/15/2021 $154.43 $113.51 $40.92 0 0 0
$23,255.34 $22,929.69 $325.65
DocuSign Envelope ID: D2465DD7-9CF5-4E85-B350-C2DF80BFEC80
CEE SERVICING
REPORT TYPE:TRIAL BALANCE REPORT SUMMARY
DATA SET DATE:11/1/2021
REPORTING PERIOD:Oct-21
INVESTOR:ELK RIVER
TRIAL BALANCE PER POOL AS OF 10/31/2021
POOL LOAN COUNT LOAN VOLUME UNPAID PRN BAL
HRA REHAB 7 149,276.22$76,510.48$
Grand Total 7 149,276.22$76,510.48$
TRIAL BALANCE SUMMARY PER LOAN AS OF 10/31/2021
LOAN #POOL PROPERTY CONTRACT DATE INT RATE LOAN AMOUNT UNPAID PRN BAL
19-015215 HRA REHAB 606 JEFFERSON LN NW 8/3/2015 2.25 $20,650.00 $8,275.92
19-015204 HRA REHAB 1420 5TH ST NW 1/25/2017 2.50 $22,069.00 $12,217.85
19-015209 HRA REHAB 609 GATES AVE NW 9/22/2017 2.75 $19,665.00 $12,183.75
19-015217 HRA REHAB 1811 MAIN ST 5/4/2018 4.25 $21,640.00 $17,871.31
19-015206 HRA REHAB 870 VERNON AVE 12/27/2018 4.00 $25,000.00 $13,627.92
19-016434 HRA REHAB 19135 TROY STREET NW 7/5/2019 4.00 $25,000.00 $0.00
19-016564 HRA REHAB 403 3RD ST NW 7/15/2019 4.00 $15,252.22 $12,333.73
149,276.22$76,510.48$
6 MONTH COMPARATIVE REPORT
REPORTED MONTH LOAN COUNT UNPAID PRN BAL
May-21 10 106,270.97$
Jun-21 8 103,044.71$
Jul-21 7 101,837.78$
Aug-21 7 100,641.20$
Sep-21 7 99,440.17$
Oct-21 7 76,510.48$
DocuSign Envelope ID: D2465DD7-9CF5-4E85-B350-C2DF80BFEC80
CEE SERVICING
REPORT TYPE:TRIAL BALANCE REPORT DETAIL
DATA SET DATE:11/1/2021
REPORTING PERIOD:Oct-21
INVESTOR:ELK RIVER
ACCOUNT DETAIL FOR ACTIVE LOANS AS OF 10/31/2021
LOAN #PORTFOLIO POOL ADDRESS CITY STATE ZIP CODE INT RATE CONTRACT MATURITY LOAN AMOUNT TERM UNPD PRN BAL RMNG TERM
19-015215 ELK RIVER RESIDENTIAL HRA REHAB 606 JEFFERSON LN NW ELK RIVER MN 55330 2.25 8/3/2015 8/1/2025 $20,650.00 120 $8,275.92 45
19-015204 ELK RIVER RESIDENTIAL HRA REHAB 1420 5TH ST NW ELK RIVER MN 55333 2.50 1/25/2017 1/1/2027 $22,069.00 120 $12,217.85 62
19-015209 ELK RIVER RESIDENTIAL HRA REHAB 609 GATES AVE NW ELK RIVER MN 55334 2.75 9/22/2017 9/1/2027 $19,665.00 120 $12,183.75 70
19-015217 ELK RIVER RESIDENTIAL HRA REHAB 1811 MAIN ST ELK RIVER MN 55336 4.25 5/4/2018 5/1/2033 $21,640.00 180 $17,871.31 138
19-015206 ELK RIVER RESIDENTIAL HRA REHAB 870 VERNON AVE ELK RIVER MN 55337 4.00 12/27/2018 1/1/2029 $25,000.00 120 $13,627.92 60
19-016434 ELK RIVER RESIDENTIAL HRA REHAB 19135 TROY STREET NW ELK RIVER MN 55338 4.00 7/5/2019 7/5/2034 $25,000.00 180 $0.00 0
19-016564 ELK RIVER RESIDENTIAL HRA REHAB 403 3RD ST NW ELK RIVER MN 55339 4.00 7/15/2019 7/15/2029 $15,252.22 120 $12,333.73 93
149,276.22$76,510.48$
DocuSign Envelope ID: D2465DD7-9CF5-4E85-B350-C2DF80BFEC80
CEE SERVICING
REPORT TYPE:PAID IN FULL REPORT
DATA SET DATE:11/1/2021
REPORT PERIOD:Oct-21
INVESTOR:ELK RIVER
DETAIL OF LOANS PAID IN FULL PER POOL AS OF 10/31/2021
LOAN #PORTFOLIO POOL ADDRESS PAYOFF DATE CLOSED DATE AMOUNT RECEIVED PRINCIPAL RECEIVED INTEREST RECEIVED FEES RECEIVED
19-016434 ELK RIVER RESIDENTIAL HRA REHAB 19135 TROY STREET NW 10/18/2021 10/18/2021 $21,950.12 $21,842.62 $107.50 $0.00
$21,950.12 $21,842.62 $107.50 $0.00
DocuSign Envelope ID: D2465DD7-9CF5-4E85-B350-C2DF80BFEC80
CEE SERVICING
REPORT TYPE:AGING DELINQUENCY REPORT
DATA SET DATE:11/1/2021
REPORTING PERIOD:Oct-21
INVESTOR:ELK RIVER
AGING DELINQUENCY DETAIL PER ACCOUNT AS OF 10/31/2021
LOAN #BORROWER ADDRESS CONTRACT UNPD PRN BAL DPD TOTAL DUE 1 TO 15 DPD 15+ DPD 30+ DPD 60+ DPD 90+ DPD UNPD LATE FEES STATUS LAST PMNT DATE LAST PMNT AMNT
19-015215 606 JEFFERSON LN NW 8/3/2015 $8,275.92 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 10/12/2021 $192.33
19-015204 1420 5TH ST NW 1/25/2017 $12,217.85 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 10/20/2021 $208.04
19-015209 609 GATES AVE NW 9/22/2017 $12,183.75 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 10/10/2021 $187.63
19-015217 1811 MAIN ST 5/4/2018 $17,871.31 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 10/10/2021 $162.79
19-015206 870 VERNON AVE 12/27/2018 $13,627.92 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 10/29/2021 $400.00
19-016434 19135 TROY STREET NW 7/5/2019 $0.00 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 10/9/2021 $21,950.12
19-016564 403 3RD ST NW 7/15/2019 $12,333.73 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 10/15/2021 $154.43
$76,510.48 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 23,255.34$
DocuSign Envelope ID: D2465DD7-9CF5-4E85-B350-C2DF80BFEC80