Loading...
7.4. HRSR 02-01-2021 �j City of Elk Request for Action River To Item Number Housing and Redevelopment Authority 7.4 Agenda Section Meeting Date Prepared by General Business February 1, 2021 Colleen Eddy, Economic Development Specialist 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. Originations are overall quiet as applications slowed considerably in comparison with previous months. Two new applications were received and are under review at this time. 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—December 2020 ■ CEE 2020 Year End Report The Elk River Vision A )relcom' community aa)ith revolutionary and spirited zesourcefulness, 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 DECEMBER 2020 Data source January 1st, 2021 LOAN SERVICING DEPARTMENT DocuSign Envelope ID: 6FB21F98-C7B8-4CCB-8835-1042DA8AA38B Pg. 2 Table of Contents •Loan Servicing Dashboard•Invoice Report•Trial Balance Summary•Trial Balance Detail•Aging Delinquency Report DocuSign Envelope ID: 6FB21F98-C7B8-4CCB-8835-1042DA8AA38B CEE SERVICING REPORT TYPE:LOAN SERVICING DASHBOARD REPORT DATE:1/1/2021 REPORT PERIOD:Dec-20 INVESTOR:CITY OF ELK RIVER CASH PROCESSING RESULTS FOR DECEMBER 2020 OPERATIONAL RESULTS FOR DECEMBER 2020 13 13 13 12 12 11 5 6 7 8 9 10 11 12 13 14 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 6 MONTH LOAN COUNT COMPARISON $160,158.13 $162,014.82 $163,666.98$164,458.19 $186,425.84 $188,203.91 $145,000.00 $150,000.00 $155,000.00 $160,000.00 $165,000.00 $170,000.00 $175,000.00 $180,000.00 $185,000.00 $190,000.00 $195,000.00 Dec-20Nov-20Oct-20Sep-20Aug-20Jul-20 UNPAID PRINCIPAL BALANCE 6 MONTH COMPARISON $2,592.44 $9,074.96 $10,027.54 $13,446.68 $13,761.08 $14,023.14 $17,108.01 $17,438.71 $18,847.55 $20,872.50 $22,965.52 $- $5,000.00 $10,000.00 $15,000.00 $20,000.00 $25,000.00 19-015211 19-015212 19-015215 19-016564 19-015209 19-015204 19-015206 19-015216 19-015217 19-015207 19-016434 DECEMBER-2020 UNPAID PRINCIPAL BALANCE DISTRIBUTION PER LOAN $115.24 $154.43 $162.79 $175.67 $180.00 $187.63 $192.33 $200.00 $208.04 $347.54 $400.00 $0.00 $50.00 $100.00 $150.00 $200.00 $250.00 $300.00 $350.00 $400.00 $450.00 19-015211 19-016564 19-015217 19-015207 19-015216 19-015209 19-015215 19-016434 19-015204 19-015212 19-015206 TOTAL AMOUNT COLLECTED DURING DECEMBER 2020 $96.62 $109.86 $110.24 $119.60 $124.09 $126.83 $156.17 $170.33 $178.86 $317.66 $346.43 $0.00 $50.00 $100.00 $150.00 $200.00 $250.00 $300.00 $350.00 $400.00 19-015217 19-016564 19-015211 19-015207 19-016434 19-015216 19-015209 19-015215 19-015204 19-015212 19-015206 TOTAL PRINCIPAL COLLECTED DURING DECEMBER 2020 $5.00 $22.00 $29.18 $29.88 $31.46 $44.57 $53.17 $53.57 $56.07 $66.17 $75.91 $0.00 $10.00 $20.00 $30.00 $40.00 $50.00 $60.00 $70.00 $80.00 19-015211 19-015215 19-015204 19-015212 19-015209 19-016564 19-015216 19-015206 19-015207 19-015217 19-016434 TOTAL INTEREST COLLECTED DURING DECEMBER 2020 DocuSign Envelope ID: 6FB21F98-C7B8-4CCB-8835-1042DA8AA38B CEE SERVICING REPORT TYPE:INVOICE REPORT REPORT DATE:1/1/2021 REPORT PERIOD:Dec-20 INVESTOR:ELK RIVER 212 3rd Avenue North, Suite 560 Minneapolis, MN 55401 REPORTING MONTH: DECEMBER 2020 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 11 0 0 0 $2,323.67 $1,856.69 $466.98 $0.00 $0.00 $66.00 $0.00 66.00$2,257.67$ Grand Total 11 0 0 0 $2,323.67 $1,856.69 $466.98 $0.00 $0.00 $66.00 $0.00 66.00$2,257.67$ 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 12/14/2020 $192.33 $170.33 $22.00 0 0 0 ELK RIVER RESIDENTIAL HRA REHAB 19-015212 525 8TH ST NW 8/3/2015 $18,657.00 12/16/2020 $347.54 $317.66 $29.88 0 0 0 ELK RIVER RESIDENTIAL HRA REHAB 19-015216 602 GATES AVE NW 9/3/2015 $25,000.00 12/2/2020 $180.00 $126.83 $53.17 0 0 0 ELK RIVER RESIDENTIAL HRA REHAB 19-015207 1205 4TH ST NW 3/13/2016 $25,000.00 12/10/2020 $175.67 $119.60 $56.07 0 0 0 ELK RIVER RESIDENTIAL HRA REHAB 19-015204 1420 5TH ST NW 1/25/2017 $22,069.00 12/20/2020 $208.04 $178.86 $29.18 0 0 0 ELK RIVER RESIDENTIAL HRA REHAB 19-015209 609 GATES AVE NW 9/22/2017 $19,665.00 12/10/2020 $187.63 $156.17 $31.46 0 0 0 ELK RIVER RESIDENTIAL HRA REHAB 19-015211 810 JACKSON AVE NW 10/31/2017 $6,534.00 12/1/2020 $115.24 $110.24 $5.00 0 0 0 ELK RIVER RESIDENTIAL HRA REHAB 19-015217 1811 MAIN ST 5/4/2018 $21,640.00 12/10/2020 $162.79 $96.62 $66.17 0 0 0 ELK RIVER RESIDENTIAL HRA REHAB 19-015206 870 VERNON AVE 12/27/2018 $25,000.00 12/28/2020 $400.00 $346.43 $53.57 0 0 0 ELK RIVER RESIDENTIAL HRA REHAB 19-016434 19135 TROY STREET NW 7/5/2019 $25,000.00 12/4/2020 $200.00 $124.09 $75.91 0 0 0 ELK RIVER RESIDENTIAL HRA REHAB 19-016564 403 3RD ST NW 7/15/2019 $15,252.22 12/15/2020 $154.43 $109.86 $44.57 0 0 0 2,323.67$1,856.69$466.98$ DocuSign Envelope ID: 6FB21F98-C7B8-4CCB-8835-1042DA8AA38B CEE SERVICING REPORT TYPE:TRIAL BALANCE REPORT SUMMARY REPORT DATE:1/1/2021 REPORT PERIOD:Dec-20 INVESTOR:ELK RIVER TRIAL BALANCE PER POOL AS OF 12/31/2020 POOL LOAN COUNT LOAN VOLUME UNPAID PRN BAL HRA REHAB 11 224,467.22$160,158.13$ Grand Total 11 224,467.22$160,158.13$ TRIAL BALANCE SUMMARY PER LOAN AS OF 12/31/2020 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$10,027.54$ 19-015212 HRA REHAB 525 8TH ST NW 8/3/2015 2.25 18,657.00$9,074.96$ 19-015216 HRA REHAB 602 GATES AVE NW 9/3/2015 3.25 25,000.00$17,438.71$ 19-015207 HRA REHAB 1205 4TH ST NW 3/13/2016 4.00 25,000.00$20,872.50$ 19-015204 HRA REHAB 1420 5TH ST NW 1/25/2017 2.50 22,069.00$14,023.14$ 19-015209 HRA REHAB 609 GATES AVE NW 9/22/2017 2.75 19,665.00$13,761.08$ 19-015211 HRA REHAB 810 JACKSON AVE NW 10/31/2017 2.25 6,534.00$2,592.44$ 19-015217 HRA REHAB 1811 MAIN ST 5/4/2018 4.25 21,640.00$18,847.55$ 19-015206 HRA REHAB 870 VERNON AVE 12/27/2018 4.00 25,000.00$17,108.01$ 19-016434 HRA REHAB 19135 TROY STREET NW 7/5/2019 4.00 25,000.00$22,965.52$ 19-016564 HRA REHAB 403 3RD ST NW 7/15/2019 4.00 15,252.22$13,446.68$ 224,467.22$160,158.13$ 6 MONTH COMPARATIVE REPORT REPORTED MONTH LOAN COUNT UNPAID PRN BAL Jul-20 13 188,203.91$ Aug-20 13 186,425.84$ Sep-20 13 164,458.19$ Oct-20 12 163,666.98$ Nov-20 12 162,014.82$ Dec-20 11 160,158.13$ DocuSign Envelope ID: 6FB21F98-C7B8-4CCB-8835-1042DA8AA38B CEE SERVICING REPORT TYPE:TRIAL BALANCE REPORT DETAIL REPORT DATE:1/1/2021 REPORT PERIOD:Dec-20 INVESTOR:ELK RIVER ACCOUNT DETAIL FOR ACTIVE LOANS AS OF 12/31/2020 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 $10,027.54 56 19-015212 ELK RIVER RESIDENTIAL HRA REHAB 525 8TH ST NW ELK RIVER MN 55330 2.25 8/3/2015 8/1/2025 18,657.00$120 $9,074.96 56 19-015216 ELK RIVER RESIDENTIAL HRA REHAB 602 GATES AVE NW ELK RIVER MN 55330 3.25 9/3/2015 9/1/2030 25,000.00$180 $17,438.71 116 19-015207 ELK RIVER RESIDENTIAL HRA REHAB 1205 4TH ST NW ELK RIVER MN 55330 4.00 3/13/2016 3/13/2031 25,000.00$180 $20,872.50 144 19-015204 ELK RIVER RESIDENTIAL HRA REHAB 1420 5TH ST NW ELK RIVER MN 55330 2.50 1/25/2017 1/1/2027 22,069.00$120 $14,023.14 73 19-015209 ELK RIVER RESIDENTIAL HRA REHAB 609 GATES AVE NW ELK RIVER MN 55330 2.75 9/22/2017 9/1/2027 19,665.00$120 $13,761.08 81 19-015211 ELK RIVER RESIDENTIAL HRA REHAB 810 JACKSON AVE NW ELK RIVER MN 55330 2.25 10/31/2017 11/1/2022 6,534.00$60 $2,592.44 23 19-015217 ELK RIVER RESIDENTIAL HRA REHAB 1811 MAIN ST ELK RIVER MN 55330 4.25 5/4/2018 5/1/2033 21,640.00$180 $18,847.55 149 19-015206 ELK RIVER RESIDENTIAL HRA REHAB 870 VERNON AVE ELK RIVER MN 55330 4.00 12/27/2018 5/1/2028 25,000.00$120 $17,108.01 78 19-016434 ELK RIVER RESIDENTIAL HRA REHAB 19135 TROY STREET NW ELK RIVER MN 55330 4.00 7/5/2019 7/5/2034 25,000.00$180 $22,965.52 162 19-016564 ELK RIVER RESIDENTIAL HRA REHAB 403 3RD ST NW ELK RIVER MN 55330 4.00 7/15/2019 7/15/2029 15,252.22$120 $13,446.68 103 224,467.22$160,158.13$ DocuSign Envelope ID: 6FB21F98-C7B8-4CCB-8835-1042DA8AA38B CEE SERVICING REPORT TYPE:AGING DELINQUENCY REPORT REPORT DATE:1/1/2021 REPORT PERIOD:Dec-20 INVESTOR:ELK RIVER AGING DELINQUENCY DETAIL PER ACCOUNT AS OF 12/31/2020 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 10,027.54$0 -$-$-$-$-$-$-$CURRENT 12/14/2020 $192.33 19-015212 525 8TH ST NW 8/3/2015 9,074.96$0 -$-$-$-$-$-$-$CURRENT 12/16/2020 $347.54 19-015216 602 GATES AVE NW 9/3/2015 17,438.71$0 -$-$-$-$-$-$-$CURRENT 12/2/2020 $180.00 19-015207 1205 4TH ST NW 3/13/2016 20,872.50$0 -$-$-$-$-$-$-$CURRENT 12/10/2020 $175.67 19-015204 1420 5TH ST NW 1/25/2017 14,023.14$0 -$-$-$-$-$-$-$CURRENT 12/20/2020 $208.04 19-015209 609 GATES AVE NW 9/22/2017 13,761.08$0 -$-$-$-$-$-$-$CURRENT 12/10/2020 $187.63 19-015211 810 JACKSON AVE NW 10/31/2017 2,592.44$0 -$-$-$-$-$-$-$CURRENT 12/1/2020 $115.24 19-015217 1811 MAIN ST 5/4/2018 18,847.55$0 -$-$-$-$-$-$-$CURRENT 12/10/2020 $162.79 19-015206 870 VERNON AVE 12/27/2018 17,108.01$0 -$-$-$-$-$-$-$CURRENT 12/28/2020 $400.00 19-016434 19135 TROY STREET NW 7/5/2019 22,965.52$0 -$-$-$-$-$-$-$CURRENT 12/4/2020 $200.00 19-016564 403 3RD ST NW 7/15/2019 13,446.68$0 -$-$-$-$-$-$-$CURRENT 12/15/2020 $154.43 160,158.13$-$-$-$-$-$-$-$2,323.67$ DocuSign Envelope ID: 6FB21F98-C7B8-4CCB-8835-1042DA8AA38B Electronic Record and Signature Disclosure Certificate Of Completion Envelope Id: 6FB21F98C7B84CCB88351042DA8AA38B Status: Completed Subject: Loan Servicing Report December 2020 Source Envelope: Document Pages: 14 Signatures: 0 Envelope Originator: Certificate Pages: 5 Initials: 0 Marco Landoni AutoNav: Enabled EnvelopeId Stamping: Enabled Time Zone: (UTC-06:00) Central Time (US & Canada) 212 3rd Avenue North Minneapolis, MN 55401 mlandoni@mncee.org IP Address: 73.242.75.5 Record Tracking Status: Original 1/11/2021 3:08:36 PM Holder: Marco Landoni mlandoni@mncee.org Location: DocuSign Signer Events Signature Timestamp In Person Signer Events Signature Timestamp Editor Delivery Events Status Timestamp Agent Delivery Events Status Timestamp Intermediary Delivery Events Status Timestamp Certified Delivery Events Status Timestamp Collen Eddy CEddy@elkrivermn.gov Security Level: Email, Account Authentication (None), Access Code Using IP Address: 156.99.27.161 Sent: 1/11/2021 3:14:45 PM Viewed: 1/11/2021 3:48:26 PM Electronic Record and Signature Disclosure: Accepted: 10/13/2020 2:27:31 PM ID: 67c87a9c-e1d7-4bb1-a15f-dad8f7079cec Carbon Copy Events Status Timestamp Finance Department Elk River, MN Finance@elkrivermn.gov Security Level: Email, Account Authentication (None) Sent: 1/11/2021 3:14:45 PM Electronic Record and Signature Disclosure: Accepted: 7/3/2019 12:05:11 PM ID: a86cffc0-7b65-45c6-8260-4fa0923f98d6 Witness Events Signature Timestamp Notary Events Signature Timestamp Envelope Summary Events Status Timestamps Envelope Sent Hashed/Encrypted 1/11/2021 3:14:45 PM Certified Delivered Security Checked 1/11/2021 3:48:26 PM Completed Security Checked 1/11/2021 3:48:27 PM Payment Events Status Timestamps Electronic Record and Signature Disclosure ELECTRONIC RECORD AND SIGNATURE DISCLOSURE From time to time, Center for Energy and Environment (we, us or Company) may be required by law to provide to you certain written notices or disclosures. Described below are the terms and conditions for providing to you such notices and disclosures electronically through your DocuSign, Inc. (DocuSign) Express user account. Please read the information below carefully and thoroughly, and if you can access this information electronically to your satisfaction and agree to these terms and conditions, please confirm your agreement by clicking the 'I agree' button at the bottom of this document. Getting paper copies At any time, you may request from us a paper copy of any record provided or made available electronically to you by us. For such copies, as long as you are an authorized user of the DocuSign system you will have the ability to download and print any documents we send to you through your DocuSign user account for a limited period of time (usually 30 days) after such documents are first sent to you. After such time, if you wish for us to send you paper copies of any such documents from our office to you, you will be charged a $0.00 per-page fee. You may request delivery of such paper copies from us by following the procedure described below. Withdrawing your consent If you decide to receive notices and disclosures from us electronically, you may at any time change your mind and tell us that thereafter you want to receive required notices and disclosures only in paper format. How you must inform us of your decision to receive future notices and disclosure in paper format and withdraw your consent to receive notices and disclosures electronically is described below. Consequences of changing your mind If you elect to receive required notices and disclosures only in paper format, it will slow the speed at which we can complete certain steps in transactions with you and delivering services to you because we will need first to send the required notices or disclosures to you in paper format, and then wait until we receive back from you your acknowledgment of your receipt of such paper notices or disclosures. To indicate to us that you are changing your mind, you must withdraw your consent using the DocuSign 'Withdraw Consent' form on the signing page of your DocuSign account. This will indicate to us that you have withdrawn your consent to receive required notices and disclosures electronically from us and you will no longer be able to use your DocuSign Express user account to receive required notices and consents electronically from us or to sign electronically documents from us. All notices and disclosures will be sent to you electronically Unless you tell us otherwise in accordance with the procedures described herein, we will provide electronically to you through your DocuSign user account all required notices, disclosures, authorizations, acknowledgements, and other documents that are required to be provided or made available to you during the course of our relationship with you. To reduce the chance of you inadvertently not receiving any notice or disclosure, we prefer to provide all of the required notices and disclosures to you by the same method and to the same address that you have given us. Thus, you can receive all the disclosures and notices electronically or in paper format through the paper mail delivery system. If you do not agree with this process, please let us know as described below. Please also see the paragraph immediately above that describes the consequences of your electing not to receive delivery of the notices and disclosures electronically from us. Electronic Record and Signature Disclosure created on: 6/17/2016 9:43:53 AM Parties agreed to: Collen Eddy, Finance Department Elk River, MN How to contact Center for Energy and Environment: You may contact us to let us know of your changes as to how we may contact you electronically, to request paper copies of certain information from us, and to withdraw your prior consent to receive notices and disclosures electronically as follows: To contact us by phone call: 612-335-5884 To contact us by email send messages to: loaninfo@mncee.org To advise Center for Energy and Environment of your new e-mail address To let us know of a change in your e-mail address where we should send notices and disclosures electronically to you, you must send an email message to us at loaninfo@mncee.org and in the body of such request you must state: your previous e-mail address, your new e-mail address. We do not require any other information from you to change your email address.. In addition, you must notify DocuSign, Inc to arrange for your new email address to be reflected in your DocuSign account by following the process for changing e-mail in DocuSign. To request paper copies from Center for Energy and Environment To request delivery from us of paper copies of the notices and disclosures previously provided by us to you electronically, you must send us an e-mail to loaninfo@mncee.org and in the body of such request you must state your e-mail address, full name, US Postal address, and telephone number. We will bill you for any fees at that time, if any. To withdraw your consent with Center for Energy and Environment To inform us that you no longer want to receive future notices and disclosures in electronic format you may: i. decline to sign a document from within your DocuSign account, and on the subsequent page, select the check-box indicating you wish to withdraw your consent, or you may; ii. send us an e-mail to loaninfo@mncee.org and in the body of such request you must state your e-mail, full name, IS Postal Address, telephone number, and account number. We do not need any other information from you to withdraw consent.. The consequences of your withdrawing consent for online documents will be that transactions may take a longer time to process.. Required hardware and software Operating Systems: Windows2000? or WindowsXP? Browsers (for SENDERS): Internet Explorer 6.0? or above Browsers (for SIGNERS): Internet Explorer 6.0?, Mozilla FireFox 1.0, NetScape 7.2 (or above) Email: Access to a valid email account Screen Resolution: 800 x 600 minimum Enabled Security Settings: •Allow per session cookies •Users accessing the internet behind a Proxy Server must enable HTTP 1.1 settings via proxy connection ** These minimum requirements are subject to change. If these requirements change, we will provide you with an email message at the email address we have on file for you at that time providing you with the revised hardware and software requirements, at which time you will have the right to withdraw your consent. Acknowledging your access and consent to receive materials electronically To confirm to us that you can access this information electronically, which will be similar to other electronic notices and disclosures that we will provide to you, please verify that you were able to read this electronic disclosure and that you also were able to print on paper or electronically save this page for your future reference and access or that you were able to e-mail this disclosure and consent to an address where you will be able to print on paper or save it for your future reference and access. Further, if you consent to receiving notices and disclosures exclusively in electronic format on the terms and conditions described above, please let us know by clicking the 'I agree' button below. By checking the 'I Agree' box, I confirm that: • I can access and read this Electronic CONSENT TO ELECTRONIC RECEIPT OF ELECTRONIC RECORD AND SIGNATURE DISCLOSURES document; and • I can print on paper the disclosure or save or send the disclosure to a place where I can print it, for future reference and access; and • Until or unless I notify Center for Energy and Environment as described above, I consent to receive from exclusively through electronic means all notices, disclosures, authorizations, acknowledgements, and other documents that are required to be provided or made available to me by Center for Energy and Environment during the course of my relationship with you. CITY OF ELK RIVER LOAN SERVICING REPORT YEARLY OPERATIONAL RESULTS FY 2020 From January 1, 2020 to December 31, 2020 LOAN SERVICING DEPARTMENT DocuSign Envelope ID: 0AE46E8E-A68B-4BAF-B6FC-B49F79E32B50 Pg. 2 Table of Contents •Loan Servicing Dashboard•Trial Balance Detail as of 12/31/2020•Number of Active Accounts: Monthly Detail FY 2020•Unpaid Principal Balance: Monthly Detail FY 2020•Unpaid Principal Balance: as of 12/31/2020•P&I Collected Table: Monthly Detail FY 2020•P&I Collected Graphic: Monthly Detail FY 2020•Principal Collected Table: Monthly Detail FY 2020•Principal Collected Graphic: Monthly Detail FY 2020•Interest Collected Table: Monthly Detail FY 2020•Interest Collected Graphic: Monthly Detail FY 2020 DocuSign Envelope ID: 0AE46E8E-A68B-4BAF-B6FC-B49F79E32B50 CITY OF ELK RIVER FY 2020 LOAN SERVICING REPORT January February March April May June July August September October November December SERVICING MONTH [2020] 0K 10K 20K TOTAL P&I COLLECTED$22,332.89$21,068.94 $2,929.90$2,524.64 $2,474.64 $2,350.87 $2,323.67 $2,274.64 $2,274.64$2,274.64 $2,071.20 $1,944.64 P&I COLLECTED Monthly Detail FY 2020 January March May July September SERVICING MONTH [2020] $0K $10K $20K TOTAL PRINCIPAL COLLEC..$21,967.65$20,562.68 $2,352.29$2,032.72 $2,026.29 $1,856.69$1,842.85 PRINCIPAL COLLECTED Monthly Detail FY 2020 January March May July September SERVICING MONTH [2020] $100.00 $200.00 $300.00 $400.00 $500.00 $600.00 INTEREST COLLECTED$365.24 $491.92 $466.98 $577.61$496.57$506.26$508.02 $448.84 $448.35 $521.14 $522.55 $419.04 INTEREST COLLECTED Monthly Detail FY 2020 Source Company ELK RIVER DocuSign Envelope ID: 0AE46E8E-A68B-4BAF-B6FC-B49F79E32B50 Sub-Portfol..Loan #Address Contract Date Servicing Month 2020 Q1 January February March Q2 April May June Q3 July August September Q4 October November December HRA REHAB 19-015204 1420 5TH S..1/25/2017 19-015206 870 VERNO..12/27/2018 19-015207 1205 4TH S..3/13/2016 19-015208 806 HOLT A..9/10/2017 19-015209 609 GATES ..9/22/2017 19-015210 501 6TH ST 10/22/2015 19-015211 810 JACKS..10/31/2017 19-015212 525 8TH ST ..8/3/2015 19-015214 730 JACKS..8/2/2017 19-015215 606 JEFFER..8/3/2015 19-015216 602 GATES ..9/3/2015 19-015217 1811 MAIN ..5/4/2018 19-016434 19135 TRO..7/5/2019 19-016564 403 3RD ST ..7/15/2019 Grand Total $15,614.66$15,791.34$15,965.47 $15,087.82$15,263.45$15,439.77 $14,557.64$14,734.40$14,910.78 $14,023.14$14,202.00$14,379.51 $20,145.39$20,809.57$20,809.57 $19,142.79$19,474.50$19,807.21 $18,473.73$18,473.73$18,805.72 $17,108.01$17,454.44$17,788.17 $20,749.37$20,749.37$20,749.37 $20,249.37$20,449.37$20,749.37 $19,849.37$20,249.37$20,249.37 $20,872.50$20,992.10$21,109.20 $21,072.58$21,213.59$21,350.12 $20,657.26$20,795.44$20,935.21 $0.00$20,377.67$20,516.68 $15,148.59$15,302.78$15,454.31 $14,689.64$14,842.61$14,996.34 $14,227.49$14,381.54$14,535.22 $13,761.08$13,917.25$14,072.02 $700.73$800.32$899.87 $401.43$501.30$601.11 $101.14$201.36$301.47 $0.00$101.14 $3,576.30$3,685.18$3,793.17 $3,250.47$3,359.28$3,468.11 $2,922.56$3,032.00$3,141.24 $2,592.44$2,702.68$2,812.72 $10,623.88$10,623.88$10,952.09 $10,166.50$10,318.64$10,318.64 $9,705.08$9,862.43$10,010.28 $9,074.96$9,392.62$9,552.85 $18,826.51$19,250.04$19,438.53 $0.00$18,616.23 $11,578.58$11,752.79$11,920.14 $11,055.76$11,228.70$11,408.37 $10,544.53$10,715.72$10,885.24 $10,027.54$10,197.87$10,369.75 $18,484.02$18,742.55$18,742.55 $18,091.07$18,220.78$18,353.39 $17,832.19$17,832.19$17,962.62 $17,438.71$17,565.54$17,565.54 $19,742.09$19,833.29$19,926.47 $19,415.59$19,507.97$19,602.29 $19,134.19$19,227.58$19,320.63 $18,847.55$18,944.17$19,038.24 $24,055.05$24,180.85$24,298.30 $23,652.33$23,818.10$23,939.40 $23,336.57$23,456.88$23,576.78 $22,965.52$23,089.61$23,213.29 $14,414.99$14,523.26$14,627.99 $14,095.97$14,202.15$14,309.53 $13,773.70$13,880.97$13,987.88 $13,446.68$13,556.54$13,664.55 $214,732.74$217,258.81$218,927.95 $189,956.00$191,982.29$212,544.97 $164,458.19$186,425.84$188,203.91 $160,158.13$162,014.82$163,666.98 CITY OF ELK RIVER TRIAL BALANCE DETAIL Account Detail for Active Loan as of 12/31/2020 DocuSign Envelope ID: 0AE46E8E-A68B-4BAF-B6FC-B49F79E32B50 January 2020February 2020March 2020April 2020May 2020June 2020July 2020August 2020September2020October 2020November 2020December 20200 10 20 Loan Count14 14 14 14 14 13 13 13 13 12 12 11 Number of Active Accounts per Month Monthly Detail FY 2020 Source Company ELK RIVER DocuSign Envelope ID: 0AE46E8E-A68B-4BAF-B6FC-B49F79E32B50 January 2020 February 2020 March 2020 April 2020 May 2020 June 2020 July 2020 August 2020 September 2020 October 2020 November 2020 December 2020 $0.00 $100,000.00 $200,000.00 Unpaid Principal Balance$218,927.95$217,258.81$214,732.74$212,544.97$191,982.29$189,956.00$188,203.91$186,425.84$164,458.19$163,666.98$162,014.82$160,158.13Unpaid Principal Balance per Month Monthly Detail FY 2020 Source Company ELK RIVER DocuSign Envelope ID: 0AE46E8E-A68B-4BAF-B6FC-B49F79E32B50 Year of Ser..Quarter of ..Month of S..Loan #Sub-Portfolio 2020 Q4 December 19-016434 HRA REHAB 19-015207 HRA REHAB 19-015217 HRA REHAB 19-015216 HRA REHAB 19-015206 HRA REHAB 19-015204 HRA REHAB 19-015209 HRA REHAB 19-016564 HRA REHAB 19-015215 HRA REHAB 19-015212 HRA REHAB 19-015211 HRA REHAB $22,965.52 $20,872.50 $18,847.55 $17,438.71 $17,108.01 $14,023.14 $13,761.08 $13,446.68 $10,027.54 $9,074.96 $2,592.44 CITY OF ELK RIVER Unpaid Principal Balance per Account Results as of the Last Day of the Reporting Period FY 2020 DocuSign Envelope ID: 0AE46E8E-A68B-4BAF-B6FC-B49F79E32B50 Source Com..Loan #Sub-Portfolio Address Servicing Month 2020 Q1 January February March Q2 April May June Q3 July August September Q4 October November December ELK RIVER 19-015204 HRA REHAB 1420 5TH ST NW 19-015206 HRA REHAB 870 VERNON AVE 19-015207 HRA REHAB 1205 4TH ST NW 19-015208 HRA REHAB 806 HOLT AVE NW 19-015209 HRA REHAB 609 GATES AVE NW 19-015210 HRA REHAB 501 6TH ST 19-015211 HRA REHAB 810 JACKSON AVE NW 19-015212 HRA REHAB 525 8TH ST NW 19-015214 HRA REHAB 730 JACKSON AVE NW 19-015215 HRA REHAB 606 JEFFERSON LN NW 19-015216 HRA REHAB 602 GATES AVE NW 19-015217 HRA REHAB 1811 MAIN ST 19-016434 HRA REHAB 19135 TROY STREET NW 19-016564 HRA REHAB 403 3RD ST NW Grand Total $208.04$208.04$208.04 $208.04$208.04$208.04 $208.04$208.04$208.04 $208.04$208.04$208.04 $400.00$0.00$400.00 $400.00$400.00$400.00 $0.00$400.00$400.00 $400.00$400.00$800.00 $0.00$0.00$0.00 $200.00$300.00$0.00 $400.00$0.00$0.00 $175.67$175.67$375.67 $200.00$200.00$200.00 $200.00$200.00$200.00 $20,438.25$200.00$200.00 $187.63$187.63$187.63 $187.63$187.63$187.63 $187.63$187.63$187.63 $187.63$187.63$187.63 $100.41$100.41$100.41 $100.41$100.41$100.41 $100.41$100.41$100.41 $101.30$0.00 $115.24$115.24$115.24 $115.24$115.24$115.24 $115.24$115.24$115.24 $115.24$115.24$115.24 $0.00$173.77$173.77 $173.77$0.00$173.77 $173.77$173.77$173.77 $347.54$173.77$173.77 $250.00$250.00$0.00 $18,668.07$250.00 $192.33$192.33$192.33 $192.33$192.33$192.33 $192.33$192.33$192.33 $192.33$192.33$192.33 $180.00$0.00$180.00 $180.00$180.00$180.00 $0.00$180.00$180.00 $180.00$0.00$360.00 $162.79$162.79$162.79 $162.79$162.79$162.79 $162.79$162.79$162.79 $162.79$162.79$162.79 $200.00$200.00$200.00 $200.00$200.00$200.00 $200.00$200.00$200.00 $200.00$200.00$200.00 $154.43$154.43$154.43 $154.43$154.43$154.43 $154.43$154.43$154.43 $154.43$154.43$154.43 $2,350.87$1,944.64$2,274.64 $2,474.64$21,068.94$2,524.64 $22,332.89$2,274.64$2,274.64 $2,323.67$2,071.20$2,929.90 CITY OF ELK RIVER P&I Collected Monthly Detail in USD FY 2020 DocuSign Envelope ID: 0AE46E8E-A68B-4BAF-B6FC-B49F79E32B50 January February March April May June July August September October November December SERVICING MONTH [2020] 0K 10K 20K TOTAL P&I COLLECTED$22,332.89 $21,068.94 $2,929.90$2,524.64 $2,474.64 $2,350.87 $2,323.67 $2,274.64$2,274.64$2,274.64 $2,071.20$1,944.64 P&I COLLECTED Monthly Detail FY 2020 Source Company ELK RIVER DocuSign Envelope ID: 0AE46E8E-A68B-4BAF-B6FC-B49F79E32B50 Source Com..Sub-Portfol..Loan #Address Servicing Month 2020 Q1 January February March Q2 April May June Q3 July August September Q4 October November December ELK RIVER HRA REHAB 19-015204 1420 5TH ST NW 19-015206 870 VERNON AVE 19-015207 1205 4TH ST NW 19-015208 806 HOLT AVE NW 19-015209 609 GATES AVE NW 19-015210 501 6TH ST 19-015211 810 JACKSON AVE NW 19-015212 525 8TH ST NW 19-015214 730 JACKSON AVE NW 19-015215 606 JEFFERSON LN NW 19-015216 602 GATES AVE NW 19-015217 1811 MAIN ST 19-016434 19135 TROY STREET NW 19-016564 403 3RD ST NW Grand Total $176.68$174.13$173.77 $175.63$176.32$174.89 $176.76$176.38$177.04 $178.86$177.51$178.13 $327.03$0.00$328.19 $331.71$332.71$338.18 $0.00$331.99$337.07 $346.43$333.73$685.56 $0.00$0.00$0.00 $200.00$300.00$0.00 $400.00$0.00$0.00 $119.60$117.10$301.25 $141.01$136.53$136.13 $138.18$139.77$137.37 $20,377.67$139.01$140.58 $154.19$151.53$151.18 $152.97$153.73$152.25 $154.05$153.68$154.42 $156.17$154.77$155.47 $99.59$99.55$99.45 $99.87$99.81$99.62 $100.22$100.11$99.96 $101.14$0.00 $108.88$107.99$107.79 $108.81$108.83$108.19 $109.44$109.24$109.23 $110.24$110.04$109.84 $0.00$154.87$146.40 $152.14$0.00$150.19 $157.35$147.85$156.22 $317.66$160.23$152.23 $209.39$188.49$0.00 $18,616.23$210.28 $174.21$167.35$170.72 $172.94$179.67$170.21 $171.19$169.52$170.52 $170.33$171.88$174.78 $126.60$0.00$127.91 $129.71$132.61$130.63 $0.00$130.43$128.45 $126.83$0.00$266.65 $91.20$93.18$90.53 $92.38$94.32$139.80 $93.39$93.05$94.96 $96.62$94.07$95.95 $125.80$117.45$117.05 $165.77$121.30$115.65 $120.31$119.90$75.55 $124.09$123.68$123.28 $108.27$104.73$104.38 $106.18$107.38$105.46 $107.27$106.91$108.09 $109.86$108.01$109.15 $1,842.85$1,495.80$1,753.50 $2,026.29$20,562.68$2,032.72 $21,967.65$1,778.07$1,752.09 $1,856.69$1,652.16$2,352.29 CITY OF ELK RIVER Principal Collected Monthly Detail in USD FY 2020 DocuSign Envelope ID: 0AE46E8E-A68B-4BAF-B6FC-B49F79E32B50 January February March April May June July August September October November December SERVICING MONTH [2020] $0K $10K $20K TOTAL PRINCIPAL COLLECTED$21,967.65 $20,562.68 $2,352.29$2,032.72 $2,026.29 $1,856.69$1,842.85 $1,778.07$1,753.50 $1,752.09 $1,652.16$1,495.80 PRINCIPAL COLLECTED Monthly Detail FY 2020 Source Company ELK RIVER DocuSign Envelope ID: 0AE46E8E-A68B-4BAF-B6FC-B49F79E32B50 Source Com..Sub-Portfol..Loan #Address Servicing Month 2020 Q1 January February March Q2 April May June Q3 July August Septem.. Q4 October Novem..Decemb.. ELK RIVER HRA REHAB 19-015204 1420 5TH ST NW 19-015206 870 VERNON AVE 19-015207 1205 4TH ST NW 19-015208 806 HOLT AVE NW 19-015209 609 GATES AVE NW 19-015210 501 6TH ST 19-015211 810 JACKSON AVE NW 19-015212 525 8TH ST NW 19-015214 730 JACKSON AVE NW 19-015215 606 JEFFERSON LN NW 19-015216 602 GATES AVE NW 19-015217 1811 MAIN ST 19-016434 19135 TROY STREET NW 19-016564 403 3RD ST NW Grand Total $31.36$33.91$34.27 $32.41$31.72$33.15 $31.28$31.66$31.00 $29.18$30.53$29.91 $72.97$0.00$71.81 $68.29$67.29$61.82 $0.00$68.01$62.93 $53.57$66.27$114.44 $0.00$0.00$0.00 $0.00$0.00$0.00 $0.00$0.00$0.00 $56.07$58.57$74.42 $58.99$63.47$63.87 $61.82$60.23$62.63 $60.58$60.99$59.42 $33.44$36.10$36.45 $34.66$33.90$35.38 $33.58$33.95$33.21 $31.46$32.86$32.16 $0.82$0.86$0.96 $0.54$0.60$0.79 $0.19$0.30$0.45 $0.16$0.00 $6.36$7.25$7.45 $6.43$6.41$7.05 $5.80$6.00$6.01 $5.00$5.20$5.40 $0.00$18.90$27.37 $21.63$0.00$23.58 $16.42$25.92$17.55 $29.88$13.54$21.54 $40.61$61.51$0.00 $51.84$39.72 $18.12$24.98$21.61 $19.39$12.66$22.12 $21.14$22.81$21.81 $22.00$20.45$17.55 $53.40$0.00$52.09 $50.29$47.39$49.37 $0.00$49.57$51.55 $53.17$0.00$93.35 $71.59$69.61$72.26 $70.41$68.47$22.99 $69.40$69.74$67.83 $66.17$68.72$66.84 $74.20$82.55$82.95 $34.23$78.70$84.35 $79.69$80.10$124.45 $75.91$76.32$76.72 $46.16$49.70$50.05 $48.25$47.05$48.97 $47.16$47.52$46.34 $44.57$46.42$45.28 $508.02$448.84$521.14 $448.35$506.26$491.92 $365.24$496.57$522.55 $466.98$419.04$577.61 CITY OF ELK RIVER Interest COLLECTED Monthly Detail in USD FY 2020 DocuSign Envelope ID: 0AE46E8E-A68B-4BAF-B6FC-B49F79E32B50 January February March April May June July August September October November December SERVICING MONTH [2020] $0.00 $100.00 $200.00 $300.00 $400.00 $500.00 $600.00 INTEREST COLLECTED$365.24 $491.92 $466.98 $577.61 $496.57$506.26$508.02 $448.84 $448.35 $521.14 $522.55 $419.04 INTEREST COLLECTED Monthly Detail FY 2020 Source Company ELK RIVER DocuSign Envelope ID: 0AE46E8E-A68B-4BAF-B6FC-B49F79E32B50 Electronic Record and Signature Disclosure Certificate Of Completion Envelope Id: 0AE46E8EA68B4BAFB6FCB49F79E32B50 Status: Completed Subject: FY 2020 Loan Servicing Report Source Envelope: Document Pages: 26 Signatures: 0 Envelope Originator: Certificate Pages: 4 Initials: 0 Marco Landoni AutoNav: Enabled EnvelopeId Stamping: Enabled Time Zone: (UTC-06:00) Central Time (US & Canada) 212 3rd Avenue North Minneapolis, MN 55401 mlandoni@mncee.org IP Address: 73.242.75.5 Record Tracking Status: Original 1/26/2021 11:22:13 AM Holder: Marco Landoni mlandoni@mncee.org Location: DocuSign Signer Events Signature Timestamp In Person Signer Events Signature Timestamp Editor Delivery Events Status Timestamp Agent Delivery Events Status Timestamp Intermediary Delivery Events Status Timestamp Certified Delivery Events Status Timestamp Collen Eddy CEddy@elkrivermn.gov Security Level: Email, Account Authentication (None), Access Code Using IP Address: 156.99.27.161 Sent: 1/26/2021 11:26:50 AM Viewed: 1/26/2021 11:29:18 AM Electronic Record and Signature Disclosure: Accepted: 10/13/2020 2:27:31 PM ID: 67c87a9c-e1d7-4bb1-a15f-dad8f7079cec Carbon Copy Events Status Timestamp Witness Events Signature Timestamp Notary Events Signature Timestamp Envelope Summary Events Status Timestamps Envelope Sent Hashed/Encrypted 1/26/2021 11:26:50 AM Certified Delivered Security Checked 1/26/2021 11:29:18 AM Completed Security Checked 1/26/2021 11:29:18 AM Payment Events Status Timestamps Electronic Record and Signature Disclosure ELECTRONIC RECORD AND SIGNATURE DISCLOSURE From time to time, Center for Energy and Environment (we, us or Company) may be required by law to provide to you certain written notices or disclosures. Described below are the terms and conditions for providing to you such notices and disclosures electronically through your DocuSign, Inc. (DocuSign) Express user account. Please read the information below carefully and thoroughly, and if you can access this information electronically to your satisfaction and agree to these terms and conditions, please confirm your agreement by clicking the 'I agree' button at the bottom of this document. Getting paper copies At any time, you may request from us a paper copy of any record provided or made available electronically to you by us. For such copies, as long as you are an authorized user of the DocuSign system you will have the ability to download and print any documents we send to you through your DocuSign user account for a limited period of time (usually 30 days) after such documents are first sent to you. After such time, if you wish for us to send you paper copies of any such documents from our office to you, you will be charged a $0.00 per-page fee. You may request delivery of such paper copies from us by following the procedure described below. Withdrawing your consent If you decide to receive notices and disclosures from us electronically, you may at any time change your mind and tell us that thereafter you want to receive required notices and disclosures only in paper format. How you must inform us of your decision to receive future notices and disclosure in paper format and withdraw your consent to receive notices and disclosures electronically is described below. Consequences of changing your mind If you elect to receive required notices and disclosures only in paper format, it will slow the speed at which we can complete certain steps in transactions with you and delivering services to you because we will need first to send the required notices or disclosures to you in paper format, and then wait until we receive back from you your acknowledgment of your receipt of such paper notices or disclosures. To indicate to us that you are changing your mind, you must withdraw your consent using the DocuSign 'Withdraw Consent' form on the signing page of your DocuSign account. This will indicate to us that you have withdrawn your consent to receive required notices and disclosures electronically from us and you will no longer be able to use your DocuSign Express user account to receive required notices and consents electronically from us or to sign electronically documents from us. All notices and disclosures will be sent to you electronically Unless you tell us otherwise in accordance with the procedures described herein, we will provide electronically to you through your DocuSign user account all required notices, disclosures, authorizations, acknowledgements, and other documents that are required to be provided or made available to you during the course of our relationship with you. To reduce the chance of you inadvertently not receiving any notice or disclosure, we prefer to provide all of the required notices and disclosures to you by the same method and to the same address that you have given us. Thus, you can receive all the disclosures and notices electronically or in paper format through the paper mail delivery system. If you do not agree with this process, please let us know as described below. Please also see the paragraph immediately above that describes the consequences of your electing not to receive delivery of the notices and disclosures electronically from us. Electronic Record and Signature Disclosure created on: 6/17/2016 9:43:53 AM Parties agreed to: Collen Eddy How to contact Center for Energy and Environment: You may contact us to let us know of your changes as to how we may contact you electronically, to request paper copies of certain information from us, and to withdraw your prior consent to receive notices and disclosures electronically as follows: To contact us by phone call: 612-335-5884 To contact us by email send messages to: loaninfo@mncee.org To advise Center for Energy and Environment of your new e-mail address To let us know of a change in your e-mail address where we should send notices and disclosures electronically to you, you must send an email message to us at loaninfo@mncee.org and in the body of such request you must state: your previous e-mail address, your new e-mail address. We do not require any other information from you to change your email address.. In addition, you must notify DocuSign, Inc to arrange for your new email address to be reflected in your DocuSign account by following the process for changing e-mail in DocuSign. To request paper copies from Center for Energy and Environment To request delivery from us of paper copies of the notices and disclosures previously provided by us to you electronically, you must send us an e-mail to loaninfo@mncee.org and in the body of such request you must state your e-mail address, full name, US Postal address, and telephone number. We will bill you for any fees at that time, if any. To withdraw your consent with Center for Energy and Environment To inform us that you no longer want to receive future notices and disclosures in electronic format you may: i. decline to sign a document from within your DocuSign account, and on the subsequent page, select the check-box indicating you wish to withdraw your consent, or you may; ii. send us an e-mail to loaninfo@mncee.org and in the body of such request you must state your e-mail, full name, IS Postal Address, telephone number, and account number. We do not need any other information from you to withdraw consent.. The consequences of your withdrawing consent for online documents will be that transactions may take a longer time to process.. Required hardware and software Operating Systems: Windows2000? or WindowsXP? Browsers (for SENDERS): Internet Explorer 6.0? or above Browsers (for SIGNERS): Internet Explorer 6.0?, Mozilla FireFox 1.0, NetScape 7.2 (or above) Email: Access to a valid email account Screen Resolution: 800 x 600 minimum Enabled Security Settings: •Allow per session cookies •Users accessing the internet behind a Proxy Server must enable HTTP 1.1 settings via proxy connection ** These minimum requirements are subject to change. If these requirements change, we will provide you with an email message at the email address we have on file for you at that time providing you with the revised hardware and software requirements, at which time you will have the right to withdraw your consent. Acknowledging your access and consent to receive materials electronically To confirm to us that you can access this information electronically, which will be similar to other electronic notices and disclosures that we will provide to you, please verify that you were able to read this electronic disclosure and that you also were able to print on paper or electronically save this page for your future reference and access or that you were able to e-mail this disclosure and consent to an address where you will be able to print on paper or save it for your future reference and access. Further, if you consent to receiving notices and disclosures exclusively in electronic format on the terms and conditions described above, please let us know by clicking the 'I agree' button below. By checking the 'I Agree' box, I confirm that: • I can access and read this Electronic CONSENT TO ELECTRONIC RECEIPT OF ELECTRONIC RECORD AND SIGNATURE DISCLOSURES document; and • I can print on paper the disclosure or save or send the disclosure to a place where I can print it, for future reference and access; and • Until or unless I notify Center for Energy and Environment as described above, I consent to receive from exclusively through electronic means all notices, disclosures, authorizations, acknowledgements, and other documents that are required to be provided or made available to me by Center for Energy and Environment during the course of my relationship with you.