7.1. HRA SR 11-01-2021 �J
etyof
ElkRequest for Action
River
To Item Number
Housing and Redevelopment Authoritv 7.1
Agenda Section Meeting Date Prepared by
General Business November 1, 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.
Two applications have been received in the last period. One application is going through the Minnesota
Housing Finance Agency and the other is under review under Elk River's program guidelines.
Staff met with Jim Hansik of CEE to discuss the current contract for underwriting and originating HRA loans.
The current contract expires at the end of this year. Staff anticipates consideration of a contract for 2022 being
on the HRA's December agenda. Note: the HRA and CEE have a separate contract for servicing existing loans
and those services are not affected by this contract.
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—September&October 2021
■ Quarterly Summary Loan Requests 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
CEE SERVICING
REPORT TYPE:LOAN SERVICING DASHBOARD
DATA SET DATE:10/1/2021
REPORTING PERIOD:Sep-21
INVESTOR:CITY OF ELK RIVER
CASH PROCESSING RESULTS AS OF SEPTEMBER 30, 2021
OPERATIONAL RESULTS AS OF SEPTEMBER 30, 2021
10 10
8
7 7 7
5
6
7
8
9
10
11
Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21
6 MONTH LOAN COUNT COMPARISON
$99,440.17$100,641.20$101,837.78$103,044.71$106,270.97$135,836.37Sep-21Aug-21Jul-21Jun-21May-21Apr-21
UNPAID PRINCIPAL BALANCE 6 MONTH COMPARISON
$8,453.14
$12,343.48
$12,400.40
$12,447.24
$13,981.96
$17,971.33
$21,842.62
$0.00 $5,000.00 $10,000.00 $15,000.00 $20,000.00 $25,000.00
19-015215
19-015209
19-015204
19-016564
19-015206
19-015217
19-016434
SEPTEMBER-2021 UNPAID PRINCIPAL BALANCE
DISTRIBUTION PER LOAN
$154.43
$162.79
$187.63
$192.33
$200.00
$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-016434
19-015204
19-015206
TOTAL AMOUNT COLLECTED AS OF SEPTEMBER 30, 2021
$97.57
$111.76
$125.37
$158.42
$173.72
$181.33
$352.86
$0.00 $50.00 $100.00 $150.00 $200.00 $250.00 $300.00 $350.00 $400.00
19-015217
19-016564
19-016434
19-015209
19-015215
19-015204
19-015206
TOTAL PRINCIPAL COLLECTED AS OF SEPTEMBER 30, 2021
$18.61
$26.71
$29.21
$42.67
$47.14
$65.22
$74.63
$0.00 $10.00 $20.00 $30.00 $40.00 $50.00 $60.00 $70.00 $80.00
19-015215
19-015204
19-015209
19-016564
19-015206
19-015217
19-016434
TOTAL INTEREST COLLECTED AS OF SEPTEMBER 30, 2021
DocuSign Envelope ID: A9D16E3C-A7DC-4E1B-9011-A710964196A3
CEE SERVICING
REPORT TYPE:PRELIMINARY INVOICE REPORT
DATA SET DATE:10/1/2021
REPORTING PERIOD:Sep-21
INVESTOR:ELK RIVER 212 3rd Avenue North, Suite 560
INVOICE #:8202109 Minneapolis, MN 55401
REPORTING MONTH: SEPTEMBER 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 INDEXSum of TRNX INDEX Sum of DELINQ INDEXSum of PMNT AMOUNTSum of PRN COLLECTEDSum of INT COLLECTED
HRA REHAB 7 0 0 0 $1,505.22 $1,201.03 $304.19 $0.00 $0.00 $42.00 $0.00 $42.00 $1,463.22
Grand Total 7 0 0 0 $1,505.22 $1,201.03 $304.19 $0.00 $0.00 $42.00 $0.00 $42.00 $1,463.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 9/13/2021 $192.33 $173.72 $18.61 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-015204 1420 5TH ST NW 1/25/2017 $22,069.00 9/20/2021 $208.04 $181.33 $26.71 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-015209 609 GATES AVE NW 9/22/2017 $19,665.00 9/10/2021 $187.63 $158.42 $29.21 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-015217 1811 MAIN ST 5/4/2018 $21,640.00 9/10/2021 $162.79 $97.57 $65.22 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-015206 870 VERNON AVE 12/27/2018 $25,000.00 9/29/2021 $400.00 $352.86 $47.14 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-016434 19135 TROY STREET NW 7/5/2019 $25,000.00 9/5/2021 $200.00 $125.37 $74.63 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-016564 403 3RD ST NW 7/15/2019 $15,252.22 9/15/2021 $154.43 $111.76 $42.67 0 0 0
$1,505.22 $1,201.03 $304.19
DocuSign Envelope ID: A9D16E3C-A7DC-4E1B-9011-A710964196A3
CEE SERVICING
REPORT TYPE:TRIAL BALANCE REPORT SUMMARY
DATA SET DATE:10/1/2021
REPORTING PERIOD:Sep-21
INVESTOR:ELK RIVER
TRIAL BALANCE PER POOL AS OF 9/30/2021
POOL LOAN COUNT LOAN VOLUME UNPAID PRN BAL
HRA REHAB 7 149,276.22$99,440.17$
Grand Total 7 149,276.22$99,440.17$
TRIAL BALANCE SUMMARY PER LOAN AS OF 9/30/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,453.14
19-015204 HRA REHAB 1420 5TH ST NW 1/25/2017 2.50 $22,069.00 $12,400.40
19-015209 HRA REHAB 609 GATES AVE NW 9/22/2017 2.75 $19,665.00 $12,343.48
19-015217 HRA REHAB 1811 MAIN ST 5/4/2018 4.25 $21,640.00 $17,971.33
19-015206 HRA REHAB 870 VERNON AVE 12/27/2018 4.00 $25,000.00 $13,981.96
19-016434 HRA REHAB 19135 TROY STREET NW 7/5/2019 4.00 $25,000.00 $21,842.62
19-016564 HRA REHAB 403 3RD ST NW 7/15/2019 4.00 $15,252.22 $12,447.24
149,276.22$99,440.17$
6 MONTH COMPARATIVE REPORT
REPORTED MONTH LOAN COUNT UNPAID PRN BAL
Apr-21 10 135,836.37$
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$
DocuSign Envelope ID: A9D16E3C-A7DC-4E1B-9011-A710964196A3
CEE SERVICING
REPORT TYPE:TRIAL BALANCE REPORT DETAIL
DATA SET DATE:10/1/2021
REPORTING PERIOD:Sep-21
INVESTOR:ELK RIVER
ACCOUNT DETAIL FOR ACTIVE LOANS AS OF 9/30/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,453.14 46
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,400.40 63
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,343.48 71
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,971.33 139
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,981.96 62
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 $21,842.62 151
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,447.24 94
149,276.22$99,440.17$
DocuSign Envelope ID: A9D16E3C-A7DC-4E1B-9011-A710964196A3
CEE SERVICING
REPORT TYPE:AGING DELINQUENCY REPORT
DATA SET DATE:10/1/2021
REPORTING PERIOD:Sep-21
INVESTOR:ELK RIVER
AGING DELINQUENCY DETAIL PER ACCOUNT AS OF 9/30/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,453.14 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 9/13/2021 $192.33
19-015204 1420 5TH ST NW 1/25/2017 $12,400.40 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 9/20/2021 $208.04
19-015209 609 GATES AVE NW 9/22/2017 $12,343.48 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 9/10/2021 $187.63
19-015217 1811 MAIN ST 5/4/2018 $17,971.33 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 9/10/2021 $162.79
19-015206 870 VERNON AVE 12/27/2018 $13,981.96 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 9/29/2021 $400.00
19-016434 19135 TROY STREET NW 7/5/2019 $21,842.62 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 9/5/2021 $200.00
19-016564 403 3RD ST NW 7/15/2019 $12,447.24 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 9/15/2021 $154.43
$99,440.17 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
DocuSign Envelope ID: A9D16E3C-A7DC-4E1B-9011-A710964196A3
CEE SERVICING
REPORT TYPE:LOAN SERVICING DASHBOARD
DATA SET DATE:10/27/2021
REPORTING PERIOD:Oct-21
INVESTOR:CITY OF ELK RIVER
CASH PROCESSING RESULTS AS OF OCTOBER 27, 2021
OPERATIONAL RESULTS AS OF OCTOBER 27, 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,864.52$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,981.96
$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
$0.00
$154.43
$162.79
$187.63
$192.33
$208.04
$21,950.12
$0.00 $5,000.00 $10,000.00 $15,000.00 $20,000.00 $25,000.00
19-015206
19-016564
19-015217
19-015209
19-015215
19-015204
19-016434
TOTAL AMOUNT COLLECTED AS OCTOBER 27, 2021
$0.00
$100.02
$113.51
$159.73
$177.22
$182.55
$21,842.62
$0.00 $5,000.00 $10,000.00 $15,000.00 $20,000.00 $25,000.00
19-015206
19-015217
19-016564
19-015209
19-015215
19-015204
19-016434
TOTAL PRINCIPAL COLLECTED AS OF OCTOBER 27, 2021
$0.00
$15.11
$25.49
$27.90
$40.92
$62.77
$107.50
$0.00 $20.00 $40.00 $60.00 $80.00 $100.00 $120.00
19-015206
19-015215
19-015204
19-015209
19-016564
19-015217
19-016434
TOTAL INTEREST COLLECTED AS OF OCTOBER 27, 2021
DocuSign Envelope ID: 8DA126CA-C95E-4AC7-8EED-6515072E973A
CEE SERVICING
REPORT TYPE:TRIAL BALANCE REPORT SUMMARY
DATA SET DATE:10/27/2021
REPORTING PERIOD:Oct-21
INVESTOR:ELK RIVER
TRIAL BALANCE PER POOL AS OF 10/27/2021
POOL LOAN COUNT LOAN VOLUME UNPAID PRN BAL
HRA REHAB 7 149,276.22$76,864.52$
Grand Total 7 149,276.22$76,864.52$
TRIAL BALANCE SUMMARY PER LOAN AS OF 10/27/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,981.96
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,864.52$
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,864.52$
DocuSign Envelope ID: 8DA126CA-C95E-4AC7-8EED-6515072E973A
CEE SERVICING
REPORT TYPE:TRIAL BALANCE REPORT DETAIL
DATA SET DATE:10/27/2021
REPORTING PERIOD:Oct-21
INVESTOR:ELK RIVER
ACCOUNT DETAIL FOR ACTIVE LOANS AS OF 10/27/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,981.96 62
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,864.52$
DocuSign Envelope ID: 8DA126CA-C95E-4AC7-8EED-6515072E973A
CEE SERVICING
REPORT TYPE:PAID IN FULL REPORT
DATA SET DATE:10/27/2021
REPORT PERIOD:Oct-21
INVESTOR:ELK RIVER
DETAIL OF LOANS PAID IN FULL PER POOL AS OF 10/27/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: 8DA126CA-C95E-4AC7-8EED-6515072E973A
CEE SERVICING
REPORT TYPE:AGING DELINQUENCY REPORT
DATA SET DATE:10/27/2021
REPORTING PERIOD:Oct-21
INVESTOR:ELK RIVER
AGING DELINQUENCY DETAIL PER ACCOUNT AS OF 10/27/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,981.96 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT -$0.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,864.52 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
DocuSign Envelope ID: 8DA126CA-C95E-4AC7-8EED-6515072E973A
Elk River Loan Summary Report
Activity for Period 7/1/2021 - 9/30/2021
Application packets requested/mailed:Year-to-Date: This period:0 0
Residential Advisor Visits:This period:Year-to-Date: 0 0
Loans currently in process for residents in your City/Neighborhood:1
Closed Loans This period:Year-to-Date:
Elk River UnitsUnits
Closed End 0.00 0 00.00
0.00 0Total 0.00 0
Units UnitsYear-to-Date:This period:Leveraged Funds
CEE 218,192.008,735.00 1
MHFA FUF 263,659.0014,059.00 1
Total 81,851.00 422,794.00 2
% of Total#Types of Properties Financed YTD
Single Family Residence 100.004
Types of Improvements Financed YTD # of Projects % of Total
Additions/Finishing off unused space 16.671
Air Conditioning 16.671
Electronic Ignition Hearth 16.671
Heating System 16.671
Other Exterior Improvements 16.671
Water Heater 16.671