7.1. HRSR 08-02-2021 �J
etyof
ElkRequest for Action
River
To Item Number
Housing and Redevelopment Authoritv 7.1
Agenda Section Meeting Date Prepared by
General Business August 2,2021 Colleen Eddy, Economic Development Specialist
Item Description Reviewed by
HRA Housing Rehabilitation Loan Program Update Brent O'Neil, Economic Development Director
Reviewed by
Cal Portner, City Administrator
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.
CEE received two new applications both of which did not meet the HRA's guidelines; one request was for
$35,000 and the other did not meet the minimum requirements.
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 Report-July 2021
■ July 2021 Loan Fund Balance
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
REPORT DATE:7/27/2021
REPORT PERIOD:Jul-21
INVESTOR:CITY OF ELK RIVER
CASH PROCESSING RESULTS AS OF JULY 27, 2021
OPERATIONAL RESULTS AS OF JULY 27, 2021
11 11
10 10
8
7
5
6
7
8
9
10
11
12
Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21
6 MONTH LOAN COUNT COMPARISON
$102,189.99$103,044.71
$106,270.97
$135,836.37$137,414.91
$156,533.57
$-
$20,000.00
$40,000.00
$60,000.00
$80,000.00
$100,000.00
$120,000.00
$140,000.00
$160,000.00
$180,000.00
Jul-21Jun-21May-21Apr-21Mar-21Feb-21
UNPAID PRINCIPAL BALANCE 6 MONTH COMPARISON
$8,802.37
$12,659.96
$12,670.39
$12,762.68
$15,035.55
$18,166.11
$22,092.93
$0.00 $5,000.00 $10,000.00 $15,000.00 $20,000.00 $25,000.00
19-015215
19-015209
19-016564
19-015204
19-015206
19-015217
19-016434
JULY-2021 UNPAID PRINCIPAL BALANCE
DISTRIBUTION PER LOAN
$0.00
$154.43
$162.79
$187.63
$192.33
$200.00
$208.04
$0.00 $50.00 $100.00 $150.00 $200.00 $250.00
19-015206
19-016564
19-015217
19-015209
19-015215
19-016434
19-015204
TOTAL AMOUNT COLLECTED AS OF JULY 27 2021
$0.00
$98.99
$112.40
$126.95
$158.66
$176.28
$181.44
$0.00 $20.00 $40.00 $60.00 $80.00 $100.00 $120.00 $140.00 $160.00 $180.00 $200.00
19-015206
19-015217
19-016564
19-016434
19-015209
19-015215
19-015204
TOTAL PRINCIPAL COLLECTED AS OF JULY 2021
$0.00
$16.05
$26.60
$28.97
$42.03
$63.80
$73.05
$0.00 $10.00 $20.00 $30.00 $40.00 $50.00 $60.00 $70.00 $80.00
19-015206
19-015215
19-015204
19-015209
19-016564
19-015217
19-016434
TOTAL INTEREST COLLECTED AS OF JULY 2021
CEE SERVICING
REPORT TYPE:PRELIMINARY INVOICE REPORT
REPORT DATE:7/27/2021
REPORT PERIOD:Jul-21
INVESTOR:ELK RIVER 212 3rd Avenue North, Suite 560
Minneapolis, MN 55401
REPORTING MONTH: JULY 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 $1,105.22 $854.72 $250.50 $0.00 $0.00 $42.00 $0.00 $42.00 $1,063.22
Grand Total 7 0 0 0 $1,105.22 $854.72 $250.50 $0.00 $0.00 $42.00 $0.00 $42.00 $1,063.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 7/9/2021 $192.33 $176.28 $16.05 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-015204 1420 5TH ST NW 1/25/2017 $22,069.00 7/20/2021 $208.04 $181.44 $26.60 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-015209 609 GATES AVE NW 9/22/2017 $19,665.00 7/10/2021 $187.63 $158.66 $28.97 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-015217 1811 MAIN ST 5/4/2018 $21,640.00 7/10/2021 $162.79 $98.99 $63.80 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-015206 870 VERNON AVE 12/27/2018 $25,000.00 -$0.00 $0.00 $0.00 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-016434 19135 TROY STREET NW 7/5/2019 $25,000.00 7/5/2021 $200.00 $126.95 $73.05 0 0 0
ELK RIVER RESIDENTIAL HRA REHAB 19-016564 403 3RD ST NW 7/15/2019 $15,252.22 7/15/2021 $154.43 $112.40 $42.03 0 0 0
$1,105.22 $854.72 $250.50
CEE SERVICING
REPORT TYPE:TRIAL BALANCE REPORT SUMMARY
REPORT DATE:7/27/2021
REPORT PERIOD:Jul-21
INVESTOR:ELK RIVER
TRIAL BALANCE PER POOL AS OF 7/27/2021
POOL LOAN COUNT LOAN VOLUME UNPAID PRN BAL
HRA REHAB 7 149,276.22$102,189.99$
Grand Total 7 149,276.22$102,189.99$
TRIAL BALANCE SUMMARY PER LOAN AS OF 7/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,802.37
19-015204 HRA REHAB 1420 5TH ST NW 1/25/2017 2.50 $22,069.00 $12,762.68
19-015209 HRA REHAB 609 GATES AVE NW 9/22/2017 2.75 $19,665.00 $12,659.96
19-015217 HRA REHAB 1811 MAIN ST 5/4/2018 4.25 $21,640.00 $18,166.11
19-015206 HRA REHAB 870 VERNON AVE 12/27/2018 4.00 $25,000.00 $15,035.55
19-016434 HRA REHAB 19135 TROY STREET NW 7/5/2019 4.00 $25,000.00 $22,092.93
19-016564 HRA REHAB 403 3RD ST NW 7/15/2019 4.00 $15,252.22 $12,670.39
149,276.22$102,189.99$
6 MONTH COMPARATIVE REPORT
REPORTED MONTH LOAN COUNT UNPAID PRN BAL
Feb-21 11 156,533.57$
Mar-21 11 137,414.91$
Apr-21 10 135,836.37$
May-21 10 106,270.97$
Jun-21 8 103,044.71$
Jul-21 7 102,189.99$
CEE SERVICING
REPORT TYPE:TRIAL BALANCE REPORT DETAIL
REPORT DATE:7/27/2021
REPORT PERIOD:Jul-21
INVESTOR:ELK RIVER
ACCOUNT DETAIL FOR ACTIVE LOANS AS OF 7/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,802.37 48
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,762.68 65
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,659.96 73
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 $18,166.11 141
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 $15,035.55 67
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 $22,092.93 153
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,670.39 96
149,276.22$102,189.99$
CEE SERVICING
REPORT TYPE:AGING DELINQUENCY REPORT
REPORT DATE:7/27/2021
REPORT PERIOD:Jul-21
INVESTOR:ELK RIVER
AGING DELINQUENCY DETAIL PER ACCOUNT AS OF 7/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,802.37 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 7/9/2021 $192.33
19-015204 1420 5TH ST NW 1/25/2017 $12,762.68 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 7/20/2021 $208.04
19-015209 609 GATES AVE NW 9/22/2017 $12,659.96 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 7/10/2021 $187.63
19-015217 1811 MAIN ST 5/4/2018 $18,166.11 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 7/10/2021 $162.79
19-015206 870 VERNON AVE 12/27/2018 $15,035.55 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 $22,092.93 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 7/5/2021 $200.00
19-016564 403 3RD ST NW 7/15/2019 $12,670.39 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 CURRENT 7/15/2021 $154.43
$102,189.99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Program allocation $350,000 Designated program funds
Admin fees to CMHP (through 2018)$63,750
Admin fees to CEE (2019 to present)$6,506
Property Address Unpaid Principal Lead base paint fees $11,056 paid out for lead-based paint assessments
606 Jefferson Lane NW $8,978.65 Program balance $268,688
1420 5th St. NW $12,944.12
609 Gates Ave NW $12,818.62 Principal $103,045 Outstanding loan funds
810 Jackson Ave NW $0.00
1811 Main St. NW $18,265.10
870 Vernon Ave $15,035.55
19135 Troy St NW $22,219.88
403 3rd St NW $12,782.79 Available to loan $165,643 Total funds to be loaned out
$103,044.71
2021 Elk River HRA Homeowner Rehab Program Monthly Report July 2021
Updated: 7/28/21