6.1. HRSR 03-04-2024it ci
Elk*
River
Request for Action
To
Item Number
Housing and Redevelopment Authority
6.1
Agenda Section
Meeting Date
Prepared by
General Business
March 4, 2024
Joshua Mollan, Economic Development Specialist
Item Description
Reviewed by
Housing Rehabilitation Loan Program Update
Brent O'Neil, Economic Development Director
Reviewed by
Cal Portner, City Administrator
Action Requested
Receive updates on the Housing Rehabilitation Loan Program.
Background/Discussion
CEE reports that 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 remains available
for new loan disbursements.
Staff is also looking at completing another mailer to market the program in partnership with Elk River Municipal
Utilities.
Financial Impact
N/A
Mission/Policy/Goal
Improve existing housing stock by offering incentives or programs to repair and maintain residential properties.
Attachments
■ CEE Monthly Loan Activity Report
■ CEE Monthly Loan Activity Summary
The Elk River Vision
A n elcoming community with revolutionary and spirited resourcefulness, exceptional
service, and community engagement that encourages and inspires prosperity.
p I I E I E 0 IY
NATUREI
Updated.• January 2023
iifitff!!!lifliflf!lfii.ffff.!!!!!f!##!f#.##!l444#4#ff########4flf4flif#!i#ff!•
!lffffffflf!!!!!!lffffflrlrrlf!!l/fff.f•!!!.!!!!.
!iil.!!!!.!!!.r!!!!!!!!!rlrr!!!rrl.lfff!!t!!ll�����T��.������f.���������1 �����•
ii•••t••••ii�F�rlii}iiiFis��ii��iiii��i•f••!•••iiif iiiiiiyfi ii i iii iiiiiii iiiiiai
re•arlirrrlrrrrrrrrrrr!lrrrrrrlrrMrli.«a.«•«••4«•«•••a«a«ff««««««••••a
«••ltilt!!iiiirrrlrrrrrrrrlrrrrrrMrriltaf«««««•«••«••afaa•«««•««««•••a
+-- a••rrrrrrrrrrrrrrrrr!ltilt•rrrrrrMrri•.«••««•«««•«•••aaa«ra««•«•«••••a
.ai•••irrurrr.rrrrrrrra••••••f•.rrrMrwf.««a«««««««««••aaa«««•••««•«•••a
...... MU taiiiiiiiiiiri.iiiiirriiiifffa.•Maaaaaaaaaaaaaaaaaaaaaaaiaaaiaaa
iriiiiiiiiiiiiiiirrri iffiaaaaa•firrMrr!.iiaifaaaa.aaaaaaaaaaaaaa.aaaaaaaaaaaa
i aiiiiiiiiiiiiiiiiiiiiifffiaaaaa•airrMrrifaa.aaaaaaaaaaaaaaiaa.aaaaaaaaaa•
CITY OF ELK RIVER LOAN SERVICING REPORT
January 2024
Data Set: February 1st, 2024
LOAN SERVICING DEPARTMENT
cee:,o
Center for Energy and Environment
CONTENTS
1 Invoice Report
2 Trial Balance Report (Loan Detail)
3 New Loan Count
4 Total Loan Count (Monthly Detail)
5 Trial Balance Report (Monthly Detail in USD)
6 Monthly Payment Collection Per Loan
7 Total Payment Collection in USD (Monthly Detail)
8 Total Principal Collection in USD (Monthly Detail)
9 Total Interest Collection in USD (Monthly Detail)
CEE SERVICING
REPORT TYPE: INVOICE REPORT
DATA SET DATE: 2/1/2024 REPORTING PERIOD: Jan-24 cee�•
INVESTOR: CITY OF ELK RIVER Center for Energy and Environment
212 3rd Avenue North, Suite 560
Minneapolis, MN 55401
REPORTING MONTH: JANUARY 2024 Ph.:612.455.7805
ACCOUNT DETAIL FOR INVOICING
PORTFOLIO =�L
ELK RIVER RESIDENTIAL
HRA REHAB
19-015215
PROPERTY
606 JEFFERSON LN NW
CONTRACTDATE
8/3/2015
LOAN AMOUNT
$20,650.00
PIVINT DATE
1/12/2024
PIVINTAMOUNT
192.331
PRN COLLECTED
185.29
INT COLLECTED
$7.04
TRNXINDEX
0
NEW UN INDEX
0
DELINQ INDEX
0
ELK RIVER RESIDENTIAL
HRA REHAB
19-015204
1420 5TH ST NW
1/25/2017
$22,069.00
1/20/2024
$208.04
$192.44
$15.60
0
0
0
ELK RIVER RESIDENTIAL
HRA REHAB
19-015209
609 GATES AVE NW
9/22/2017
$19,665.00
1/10/2024
$187.63
$169.16
$18.47
0
0
0
ELK RIVER RESIDENTIAL
HRA REHAB
19-015217
1811 MAIN ST
5/4/2018
$21,640.00
1/10/2024
$162.79
$108.05
$54.74
0
0
0
ELK RIVER RESIDENTIAL
HRA REHAB
19-016564
403 3RD ST NW
7/15/2019
$15,252.22
1/15/2024
$154.43
$122.97
$31.46
0
0
0
ELK RIVER RESIDENTIAL
HRA REHAB
23-029012
18990 TWIN LAKES RD NW
4/21/2023
$34,749.06
1/18/2024
$260.00
$145.92
$114.08
0
0
0
ELK RIVER RESIDENTIAL
HRA REHAB
23-028654
13222 179 1/2 AVE NW
6/16/2023
$33,925.67
1/20/2024
$300.00
$188.36
$111.64
0
0
0
ELK RIVER RESIDENTIAL
HRA REHAB
23-029085
17931 GARY ST NW
6/20/2023
$30,223.00
1/20/2024
$306.00
$207.54
$98.46
0
0
0
ELK RIVER RESIDENTIAL
HRA REHAB
23-029618
13366181ST LN NW
10/2/20231
$23,780.00
1/29/2024
$500.00
$420.401
$79.60
0
0
0
CITY OF ELK RIVER
TRIAL BALANCE REPORT
Monthly Detail
19-015215 606JEFFERSON LN NW
19-015204 1420 5TH ST NW
19-015209 609 GATES AVE NW
19-015217 1811 MAIN ST
19-016564 403 3RD ST NW
23-029012 18990 TWIN LAKES RD NW
23-028654 13222179 112 AVE NW
23-029085 17931 GARY ST NW
23-029618 13366181ST LN NW
Grand Total
Q1 Q2
February March April May June
$5,406.21 $5,222.88 $5,040.85 $4,857.53 $4,674.48
$9,251.26 $9,060.97 $8,872.17 $8,682.37 $8,492.76
$9,585.00 $9,417.59 $9,251.96 $9,085.23 $8,918.82
$16,238.94 $16,129.09 $16,024.51 $15,917.70 $15,812.37
$10,476.17 $10,353.89 $10,234.63 $10,113.85 $9,993.78
$34,749.06 $34,749.06 $34,501.54
$33,925.67
$30,223.00
$50,957.58 $50,184.42 1 $84,173.18 $83,405.74 $146,542.42
2023 2024
Q3 Q4 Q1
July August September October November December January
$4,491.07 $4,307.32 $4,122.69 $3,938.49 $3,753.69 $3,568.52 $3,383.23
$8,302.17 $8,111.76 $7,920.95 $7,729.18 $7,537.55 $7,345.00 $7,152.56
$8,751.35 $8,584.15 $8,416.57 $8,247.97 $8,079.60 $7,910.24 $7,741.08
$15,704.82 $15,598.72 $15,492.24 $15,383.57 $15,276.30 $15,166.87 $15,058.82
$9,872.21 $9,751.32 $9,630.02 $9,507.25 $9,385.12 $9,261.55 $9,138.58
$34,309.60 $34,166.16 $34,022.23 $33,874.08 $33,729.16 $33,580.05 $33,434.13
$33,786.26 $33,614.84 $33,429.04 $33,238.94 $33,051.86 $32,860.52 $32,672.16
$30,016.36 $29,812.33 $29,607.61 $29,398.95 $29,192.83 $28,982.81 $28,775.27
$23,780.00 $23,552.47 $23,432.491 $21012.09
$145,233.84 $143,946.60 $142,641.35 $165,098.43 $163,558.58 $162,108.05 $160,367.92
CITY OF ELK RIVER
TOTAL LOAN COUNT
Monthly Detail
c
0
0
J
O1
Y
0
0
L
v
a
E
z
Q1
Q2
2023
Q3
Q4
2024
Q1
9
9
9
9
8
8 8
8
6 6
5 5
i ui
@
C
T
i
m
Q
m
E
o
E
E
LL
Q
O
o
N
Z
0
CITY OF ELK RIVER
NEW LOAN COUNT
Monthly Detail
0
w
0
a
Ln
z
a
0
J
Lu
w
z
LL
0
F
Z
0
V
CITY OF ELK RIVER
TRIAL BALANCE
Monthly Detail in USD
$150,000.00
a $100,000.00
c
a
-a
m
Q
c
Z)
$50,000.00
$0.00
Q1
Q2
2023
Q3
Q4
2024
Q1
m
NO
O
N
O
0
N
p
n
�
N1
�p
N
M
00
O
IS,Ln
�{}
H
tf}
lD
rl
ri
m
m
+
N
Ln
tsr
�
m
m
r,
,i
O
00
m
00
0
Ln
N
�
r
Ln
W
O
�
O
Ln
Ln
N
N
N
N
i
L
7
Q
V
>
o
u
m
LL
0
N
Z
a)m
CITY OF ELK RIVER
PAYMENT COLLECTION PER LOAN
Monthly Detail
ELK RIVER
Grand Total
Q1
February
March
April
Q2
May
June
2023
July
Q3
August
September
October
Q4
November
December
2024
Q1
January
19-015204
19-015209
19-015215
19-015217
1420 STH ST NW
609 GATES AVE NW
606JEFFERSON LN NW
1811 MAIN ST
$208.04
$187.63
$208.04
$187.63
$208.04
$208.04
$208.04
$208.04
$208.04
$208.04
$208.04
$208.04
$208.04
$208.0z
$187.63 $187.63 $187.63
$187.63 $187.63 $187.63
$187.63 $187.63 $187.63
$187.6;
$192.3;
$192.33 $192.33
$192.33 $192.33 $192.33
$192.33 $192.33 $192.33
$192.33 $192.33 $192.33
$162.79 $162.79
$162.79 $162.79 $162.79
$162.79 $162.79 $162.79
$162.79 $162.79 $162.79
$162.7�
19-016564
23-028654
4033RDSTNW
13222 1791/2 AVE NW
$154.43
$154.43
$154.43
$154.43
$154.43
$0.00
$154.43
$154.43
$154.43
$154.43
$154.43
$154.43
$154.4;
$251.95 $300.00 $300.00
$300.00 $300.00 $300.00
$300.0(
23-029012
18990 TWIN LAKES RD NW
$905.22
$905.221
$0.00
$0.00
$514.08
$260.00
$260.00
$260.00
$260.00
$260.00
$260.00
$260.0(
23-029085 17931 GARY ST NW
I $0.00
I
$905.22 $905.22 $1,419.30
$306.00 $306.00 $306.00
$306.00 $306.00 $306.00
$306.0(
23-029618 13366181ST LN NW
$0.00 $377.90 $201.00
$1,771.22 $2,149.12 $1,972.22
$500.0(
$1,723.17 $1,771.22 $1,771.221
$2,271.2;
CITY OF ELK RIVER
TOTAL PAYMENT COLLECTION (USD)
Monthly Detail
$2,250.00
0
w
H
J $1,500.00
0
V
N
H
Z
w
Q
a
J
Q
H
0
H
$750.00
$0.00
CITY OF ELK RIVER
TOTAL PRINCIPAL COLLECTION (USD)
Monthly Detail
$1,800.00
o $1,200.00
$600.00
Q1
Q2
2023
Q3
Q4
2024
Q1
M
c-I
O
n
c-I
Ln
W
O1
m
n
rn
Ln
�
r
o
N
co
�
N
N
tPr
co
m
N
�
Uj
N
m
lb
tPr
N
c-I
t}}
tPr
6l
Q1
c-I
O
c-I
fA
O
M
L
^
w
Q
°
71
E
V
E
E
C
LL
Q
v
41
O
6
LnZ
O
CITY OF ELK RIVER
TOTAL INTEREST COLLECTION(USD)
Monthly Detail
a
Tr
N
a
$675.00
$450.00
$225.00
$0.00
CEE SERVICING
REPORT TYPE:
AGING DELINQUENCY REPORT
DATA SET DATE:
2/1/2024
REPORTING PERIOD:
Jan-24
INVESTOR:
CITY OF ELK RIVER
AGING DELINQUENCY DETAIL PER ACCOUNT AS OF 1/31/2024
cee:'
Center for Energy and Environment
LOAN #
19-015215
BORROWER ADDRESS
606 JEFFERSON LN NW
CONTRACT
8/3/2015
UNPD PRN BAL
$3,383.23
DPD
0
TOTAL DUE
$0.00
I TO 15 DPD
$0.00
15+ DPD
$0.00
30+ DPD
$0.00
60+ DPD
$0.00
90+ DPD
$0.00
UNPID LATE FEES
$0.00
STATUS
CURRENT
LAST PMNT DATE
1/12/2024
LAST PMNT AMNT
$192.33
19-015204
1420 5TH ST NW
1/25/2017
$7,152.56
0
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
CURRENT
1/20/2024
$208.04
19-015209
609 GATES AVE NW
9/22/2017
$7,741.08
0
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
CURRENT
1/10/2024
$187.63
19-015217
1811 MAIN ST
5/4/2018
$15,058.82
0
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
CURRENT
1/10/2024
$162.79
19-016564
403 3RD ST NW
7/15/2019
$9,138.58
0
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
CURRENT
1/15/2024
$154.43
23-029012
18990 TWIN LAKES RD NW
4/21/2023
$33,434.13
0
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
CURRENT
1/18/2024
$260.00
23-028654
13222 179 1/2 AVE NW
6/16/2023
$32,672.16
0
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
CURRENT
1/20/2024
$300.00
23-029085
17931 GARY ST NW
6/20/2023
$28,775.27
0
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
CURRENT
1/20/2024
$306.00
23-029618 13366 1815T LN NW 10/2/2023
$23,012.09
0
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
CURRENT 1/29/20241
$500.00
CEE Monthly Loan Activity Summary
3/4/24 6.1 at2
' $
20.650.00
8/3/2015 8/ 1 /2025
Current
2.25%
$
192.33
$
192.33
$
3,383.23
` M M $
22,069.00
1 /25/2017 1 / 1 /2027
Current
2.50 %
$
208.04
$
208.04
$
7. 152.56
' $
19,665.00
9/22/2017 9/ 1 /2027
Current
2.75%
$
187.63
$
187.63
$
7,741.08
` M $
21,640.00
5/4/2018 5/ 1 /2033
Current
4.25 %
$
162.79
$
162.79
$
15,058.82
' $
15,252.22
7/ 15/2019 7/ 15/2029
Current
4.00%
$
154.43
$
154.43
$
9,138.58
' M $
34,749.06
4/21/2023 4/21/2038
Current
4.00%
$
260.00
$
260.00
$
33,434.13
$
33,925.67
6/16/2023 6/16/2038
Current
4.00%
$
300.00
$
300.00
$
32,672,.16
' M : $
30,223.00
6/20/2023 6/20/2033
Current
4.00%
$
306.00
$
306.00
$
28,775.27
$
23,780.00
10/2/2023 10/212038
Current
4.00%
$
201.00
$
500.00
$
23,012.09
$
221,953.95
$ 1,972.22
$ 2,271.22
$
160,367.92