7.1. HRSR 04-04-2022 �J
etyof
ElkRequest for Action
River
To Item Number
Housing and Redevelopment Authoritv 7.1
Agenda Section Meeting Date Prepared by
General Business April 4, 2022 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
Minnesota Center for Energy and Environment (CEE) reports all accounts are current and the HRA's portfolio
is performing as expected with no delinquencies or late payments. There have been no new loans issued this
period and $150,000 is available for new loan disbursements.
An ad promoting the program is running in the April 2, 2022, Star News, and concurrently for the subsequent
week, an ad banner will display on rotation on the Star News web page.
Following discussion at the March HRA meeting, staff is coordinating with CEE on program changes and new
programs for the HRA to consider at a future meeting.
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 Y�elcoming community nvith revolutionary and spirited resourcefulness, exceptional P U W E H E o s r
service, and community engagement that encourages and inspires prosperity ,g /` UR
CITY OF ELK RIVER
LOAN SERVICING REPORT
OPERATIONAL RESULTS
FEBRUARY 2022
Data set: March 1st, 2022
LOAN SERVICING DEPARTMENT
DocuSign Envelope ID: 4F4BF2FE-E3A4-45CB-86BE-6BE83FA9B21B
Pg. 2
Table of Contents
•Dashboard
•Invoice Report
•Trial Balance Summary
•Trial Balance Detail
•Aging Delinquency Report
DocuSign Envelope ID: 4F4BF2FE-E3A4-45CB-86BE-6BE83FA9B21B
CEE SERVICING
REPORT TYPE:LOAN SERVICING DASHBOARD
DATA SET DATE:3/1/2022
REPORTING PERIOD:Feb-22
INVESTOR:CITY OF ELK RIVER
CASH PROCESSING RESULTS AS OF FEBRUARY 28, 2022
OPERATIONAL RESULTS AS OF FEBRUARY 28, 2022
7 7
6 6 6 6
5
6
6
7
7
8
Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22
6 MONTH LOAN COUNT COMPARISON
$72,155.43$73,243.58$74,338.18$75,426.65$76,510.48$99,440.17Feb-22Jan-22Dec-21Nov-21Oct-21Sep-21
UNPAID PRINCIPAL BALANCE 6 MONTH COMPARISON
$7,568.26
$11,486.31
$11,543.91
$11,879.97
$12,203.00
$17,473.98
$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-015215
19-015204
19-015209
19-016564
19-015206
19-015217
FEBRUARY 2022 UNPAID PRINCIPAL BALANCE
DISTRIBUTION PER LOAN
$154.43
$162.79
$187.63
$192.33
$208.04
$400.00
$0.00 $50.00 $100.00 $150.00 $200.00 $250.00 $300.00 $350.00 $400.00 $450.00
19-016564
19-015217
19-015209
19-015215
19-015204
19-015206
TOTAL AMOUNT COLLECTED AS OF FEBRUARY 28, 2022
$99.35
$113.68
$160.29
$175.62
$183.25
$355.96
$0.00 $50.00 $100.00 $150.00 $200.00 $250.00 $300.00 $350.00 $400.00
19-015217
19-016564
19-015209
19-015215
19-015204
19-015206
TOTAL PRINCIPAL COLLECTED AS OF FEBRUARY 28, 2022
$16.71
$24.79
$27.34
$40.75
$44.04
$63.44
$0.00 $10.00 $20.00 $30.00 $40.00 $50.00 $60.00 $70.00
19-015215
19-015204
19-015209
19-016564
19-015206
19-015217
TOTAL INTEREST COLLECTED AS OF FEBRUARY, 2022
DocuSign Envelope ID: 4F4BF2FE-E3A4-45CB-86BE-6BE83FA9B21B
CEE SERVICING
REPORT TYPE:INVOICE REPORT
DATA SET DATE:3/1/2022
REPORTING PERIOD:Feb-22
INVESTOR:CITY OF ELK RIVER 212 3rd Avenue North, Suite 560
INVOICE REF#:8202202 Minneapolis, MN 55401
REPORTING MONTH: FEBRUARY 2022 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 INDEXSum of TRNX INDEX Sum of DELINQ INDEXSum of PMNT AMOUNTSum of PRN COLLECTEDSum of INT COLLECTED
HRA REHAB 6 0 0 0 $1,305.22 $1,088.15 $217.07 $0.00 $0.00 $36.00 $0.00 $36.00 $1,269.22
Grand Total 6 0 0 0 $1,305.22 $1,088.15 $217.07 $0.00 $0.00 $36.00 $0.00 $36.00 $1,269.22
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 2/14/2022 $192.33 $175.62 $16.71 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-015204 1420 5TH ST NW 1/25/2017 $22,069.00 2/20/2022 $208.04 $183.25 $24.79 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-015209 609 GATES AVE NW 9/22/2017 $19,665.00 2/10/2022 $187.63 $160.29 $27.34 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-015217 1811 MAIN ST 5/4/2018 $21,640.00 2/10/2022 $162.79 $99.35 $63.44 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-015206 870 VERNON AVE 12/27/2018 $25,000.00 2/28/2022 $400.00 $355.96 $44.04 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-016564 403 3RD ST NW 7/15/2019 $15,252.22 2/15/2022 $154.43 $113.68 $40.75 0 0 0
$1,305.22 $1,088.15 $217.07
DocuSign Envelope ID: 4F4BF2FE-E3A4-45CB-86BE-6BE83FA9B21B
CEE SERVICING
REPORT TYPE:TRIAL BALANCE REPORT SUMMARY
DATA SET DATE:3/1/2022
REPORTING PERIOD:Feb-22
INVESTOR:CITY OF ELK RIVER
TRIAL BALANCE PER POOL AS OF 2/28/2022
POOL LOAN COUNT LOAN VOLUME UNPAID PRN BAL
HRA REHAB 6 124,276.22$72,155.43$
Grand Total 6 124,276.22$72,155.43$
TRIAL BALANCE SUMMARY PER LOAN AS OF 2/28/2022
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 $7,568.26
19-015204 HRA REHAB 1420 5TH ST NW 1/25/2017 2.50 $22,069.00 $11,486.31
19-015209 HRA REHAB 609 GATES AVE NW 9/22/2017 2.75 $19,665.00 $11,543.91
19-015217 HRA REHAB 1811 MAIN ST 5/4/2018 4.25 $21,640.00 $17,473.98
19-015206 HRA REHAB 870 VERNON AVE 12/27/2018 4.00 $25,000.00 $12,203.00
19-016564 HRA REHAB 403 3RD ST NW 7/15/2019 4.00 $15,252.22 $11,879.97
124,276.22$72,155.43$
6 MONTH COMPARATIVE REPORT
REPORTED MONTH LOAN COUNT UNPAID PRN BAL
Sep-21 7 99,440.17$
Oct-21 7 76,510.48$
Nov-21 6 75,426.65$
Dec-21 6 74,338.18$
Jan-22 6 73,243.58$
Feb-22 6 72,155.43$
DocuSign Envelope ID: 4F4BF2FE-E3A4-45CB-86BE-6BE83FA9B21B
CEE SERVICING
REPORT TYPE:TRIAL BALANCE REPORT DETAIL
DATA SET DATE:3/1/2022
REPORTING PERIOD:Feb-22
INVESTOR:CITY OF ELK RIVER
ACCOUNT DETAIL FOR ACTIVE LOANS AS OF 2/28/2022
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 $7,568.26 41
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 $11,486.31 58
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 $11,543.91 66
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,473.98 134
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 $12,203.00 53
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 $11,879.97 89
124,276.22$72,155.43$
DocuSign Envelope ID: 4F4BF2FE-E3A4-45CB-86BE-6BE83FA9B21B
CEE SERVICING
REPORT TYPE:AGING DELINQUENCY REPORT
DATA SET DATE:3/1/2022
REPORTING PERIOD:Feb-22
INVESTOR:CITY OF ELK RIVER
AGING DELINQUENCY DETAIL PER ACCOUNT AS OF 2/28/2022
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 $7,568.26 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 2/14/2022 $192.33
19-015204 1420 5TH ST NW 1/25/2017 $11,486.31 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 2/20/2022 $208.04
19-015209 609 GATES AVE NW 9/22/2017 $11,543.91 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 2/10/2022 $187.63
19-015217 1811 MAIN ST 5/4/2018 $17,473.98 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 2/10/2022 $162.79
19-015206 870 VERNON AVE 12/27/2018 $12,203.00 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 2/28/2022 $400.00
19-016564 403 3RD ST NW 7/15/2019 $11,879.97 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 2/15/2022 $154.43
$72,155.43 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 1,305.22$
DocuSign Envelope ID: 4F4BF2FE-E3A4-45CB-86BE-6BE83FA9B21B