{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Application","CHFA-Recommendation"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Application","index":0,"n_rows":92,"n_cols":16,"rows_kept":92,"cut":false,"hidden":false,"merged":[[0,0,0,13],[33,1,33,3],[34,1,34,3],[35,1,35,3],[0,18,0,24],[47,7,47,9],[84,4,84,11],[88,4,88,11],[5,13,5,16],[33,5,33,6],[33,10,33,11],[34,10,34,11],[35,15,35,16],[33,15,33,16],[2,0,2,16],[8,0,8,16],[22,5,22,10],[35,10,35,11],[61,1,61,16],[46,7,46,9],[20,5,20,10],[34,15,34,16],[58,9,58,10],[58,6,58,7],[27,15,27,16],[29,1,29,16],[35,5,35,6],[34,5,34,6],[10,5,10,10],[12,5,12,10],[14,5,14,10],[16,5,16,10],[18,5,18,10],[91,14,91,15],[12,13,12,15],[18,13,18,15],[20,13,20,15],[38,9,38,10],[22,13,22,15],[87,2,87,9],[78,5,78,9],[48,7,48,9],[16,13,16,15],[83,1,83,15],[53,9,53,15],[52,9,52,15],[90,4,90,11],[89,4,89,11],[63,7,63,16]]}
["Connecticut Housing Finance Authority\nApplication for Forbearance due to COVID-19"]
[]
["INSTRUCTIONS: "]
[null,"Please complete the available fields within this Application, in its entirety. "]
[null,"The Application and Attachments are due within 10 days of the conditional approval email.  "]
[null,"The Application is to be submitted to your CHFA Asset Manager and through the CHFA secured portal:",null,null,null,null,null,null,null,null,null,null,null,"https://www.chfa.org/sharefile-forbearance/"]
[null,"All Attached files uploaded should include the CHFA Development # and the Development Name in the file name."]
[]
["I. DEVELOPMENT INFORMATION:"]
[]
[null,null,null,null,"CHFA DEVELOPMENT #:",null,null,null,null,null,null,null,"DATE:"]
[]
[null,null,null,null,"DEVELOPMENT NAME:",null,null,null,null,null,null,null,"CHFA ASSET MANAGER:"]
[]
[null,null,null,null,"PROPERTY ADDRESS:",null,null,null,null,null,null,null,"NUMBER OF UNITS:"]
[]
[null,null,null,null,"OWNER LEGAL NAME:",null,null,null,null,null,null,null,"MANAGEMENT CO.:"]
[]
[null,null,null,null,"OWNER CONTACT (Name):",null,null,null,null,null,null,null,"MANAGEMENT AGENT:"]
[]
[null,null,null,null,"CONTACT EMAIL:",null,null,null,null,null,null,null,"CONTACT EMAIL:"]
[]
[null,null,null,null,"CONTACT PHONE:",null,null,null,null,null,null,null,"CONTACT PHONE:"]
[]
[]
["II. DEVELOPMENT INFORMATION AND FINANCIALS:"]
[]
[null,"Is the development in default with any branch of the State of Connecticut or the federal government?  If yes, please specify below."]
[]
[]
[]
[null,"CHFA Loan Information"]
[null,"Loan #",null,null,null,"Current As Of",null,null,"Loan Rate",null,"Maturity Date",null,null,"Balance",null,"Monthly Debt Svc"]
[1]
[2]
[3]
[]
[null,"Reserve Information"]
[null,"Most Recent Balance Sheet Dated:",null,null,null,null,null,null,null,null,null,null,null,"Balance",null,"Per Unit"]
[null,"Enter amount reflected in Reserve Cash - Saving and Investments (Acct. 1123)",null,null,null,null,null,null,null,null,null,null,"+",null,null,{"$f":"IF(ISBLANK($N$15),0,N40/$N$15)","v":0}]
[null,"Plus: Replacement Reserve (Acct. 1320)",null,null,null,null,null,null,null,null,null,null,"+",null,null,{"$f":"IF(ISBLANK($N$15),0,N41/$N$15)","v":0}]
[null,"Plus: General Operating Reserves (Acct. 1365)",null,null,null,null,null,null,null,null,null,null,"+",null,null,{"$f":"IF(ISBLANK($N$15),0,N42/$N$15)","v":0}]
[null,"Plus: Residual Receipts Reserve: (Acct. 1340)",null,null,null,null,null,null,null,null,null,null,"+",null,null,0]
[null,"Plus: Other Operating Reserves (Acct. 1330)",null,null,null,null,null,null,null,null,null,null,"+",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Reserves :",{"$f":"SUM(N40:N44)","v":0},null,0]
[null,"Income/Expense "]
[null,"2019 Income",null,null,null,null,null,null,null,null,null,"Rental Revenue (January)"]
[null,"2019 Expense",null,null,null,null,null,null,null,null,null,"Rental Revenue (February)"]
[null,"Real Estate Tax (Monthly)",null,null,null,null,null,null,null,null,null,"Rental Revenue (March)"]
[null,null,null,null,null,null,null,null,null,null,null,"Rental Revenue (April)"]
[]
[null,null,null,null,null,null,null,null,null,"Comments related to Vacancy"]
[null,"Current Vacant Residential Units"]
[null,"Current Vacant - Commercial"]
[]
["III. FORBEARANCE REQUEST:"]
[]
[]
[null,"Requested Forbearance Period",null,null,null,null,null,null,"to "]
[]
[null,"Proposed Repayment Plan:"]
[]
[]
[null,"Business interruption insurance status:"]
[]
["IV. ATTACHMENTS INCLUDED:   Note: All files uploaded should include the CHFA Development # and the Development Name in the file name."]
[]
[null,null,"    Rent Rolls [stabilized (January, February, March) and impacted(April, May,June)]"]
[null,null,"    Rent Collection Policy related to COVID-19"]
[null,null,"    Log of rent waiver approvals"]
[null,null,"    Year-to-Date(YTD) Interim Statement of Operations    (submit Excel CHFA form link:",null,null,null,null,null,null,null,null,null,"CHFA - DOH Budget Interim Workbook)"]
[null,null,"    YTD Balance Sheet (submit the same Excel CHFA workbook as above; completing the Balance Sheet-Assets and Bal Sheet-Liabs&Equity tabs)"]
[null,null,"    YTD Aged Accounts Receivable"]
[null,null,"    YTD Aged Accounts Payable"]
[null,null,"    Consent of Tax Credit Investor/Board of Directors to enter into a Forbearance Agreement; either executed or requested (if applicable)"]
[null,null,"    Evidence of application for Paycheck Protection Program (PPP) or other Federal/State Relief"]
[null,null,"    Evidence of application for Real Estate Tax Forbearance"]
[null,null,"    Evidence of expenses related to COVID-19"]
[null,null,"    Other (specify):"]
[]
[]
["V. CERTIFICATION:"]
[]
[null,"False Statement\nThe undersigned acknowledges that he/she may be prosecuted for false statement under the laws of the State of Connecticut under Section 53a-157b of the General Statutes, as amended from time to time, for any false statement made herein.  The undersigned understands that CHFA will rely on the information in this application and that the undersigned is under a continuing obligation to inform CHFA in writing of any corrections, omissions or material changes in this application and its exhibits. \n\nAuthorization\nThe undersigned has been duly authorized by resolution of the Applicant’s governing body to submit the attached in its name.  The undersigned is not in default with any branch of the State of Connecticut or the federal government, except as has been specifically and fully disclosed in this application.\n\nCertification\nI understand that any forbearance may be conditional upon CHFA Board Approval.  I also understand that this request is for forbearance and that I am required to re-pay any and all payments deferred associated with this application. "]
[]
[null,null,null,null,"Signature of Owner/Applicant"]
[]
[]
[null,null,null,"Printed Name:"]
[null,null,null,"Its:"]
[null,null,null,"Date:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev 5.06.2020"]

{"sheet":"CHFA-Recommendation","index":1,"n_rows":53,"n_cols":20,"rows_kept":53,"cut":false,"hidden":true,"merged":[[7,1,7,9],[8,1,8,9],[9,1,9,9],[10,1,10,9],[11,1,11,9],[22,0,22,9],[41,1,41,9],[29,1,29,9],[17,1,17,9],[18,1,18,9],[19,1,19,9],[39,1,39,9],[40,1,40,9],[23,1,23,9],[24,1,24,9],[25,1,25,9],[26,1,26,9],[27,1,27,9],[28,1,28,9],[35,0,35,14],[51,5,51,8],[6,11,6,14],[7,11,7,14],[8,11,8,14],[9,11,9,14],[10,11,10,14],[11,11,11,14],[12,11,12,14],[13,11,13,14],[14,11,14,14],[15,11,15,14],[16,11,16,14],[17,11,17,14],[18,11,18,14],[32,0,32,14],[47,5,47,8],[25,11,25,14],[26,11,26,14],[27,11,27,14],[28,11,28,14],[50,5,50,8],[48,5,48,8],[49,5,49,8],[37,11,37,12],[38,11,38,12],[39,11,39,12],[40,11,40,12],[41,11,41,12],[45,10,45,11],[29,11,29,14],[38,1,38,9],[37,0,37,9],[1,3,1,10],[3,3,3,10],[4,5,4,10],[0,0,0,14],[24,11,24,14],[19,11,19,14],[20,11,20,14],[20,1,20,9],[23,11,23,14],[22,11,22,14],[12,1,12,9],[13,1,13,9],[14,1,14,9],[15,1,15,9],[16,1,16,9],[6,0,6,9]]}
["Internal Checklist - MF Property(ies) request for Forbearance due to COVID-19"]
["Property Name:",null,null,{"$f":"IF(ISBLANK(+Application!F13),\"\",Application!F13)","v":""}]
["Loan Number(s):",null,null,{"$f":"IF(ISBLANK(+Application!B34),\"\",Application!B34)","v":""},null,{"$f":"IF(ISBLANK(+Application!B35),\"\",Application!B35)","v":""},null,{"$f":"IF(ISBLANK(+Application!B36),\"\",Application!B36)","v":""},null,null,null,null,"Telephone:"]
["Owner Contact:",null,null,{"$f":"IF(ISBLANK(+Application!F19),\"\",Application!F19)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(+Application!F23),\"\",Application!F23)","v":""}]
["Management Agent Contact:",null,null,null,null,{"$f":"IF(ISBLANK(+Application!N19),\"\",Application!N19)","v":""},null,null,null,null,null,null,{"$f":"IF(ISBLANK(+Application!N23),\"\",Application!N23)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["Submission Requirements for Forbearance Consideration",null,null,null,null,null,null,null,null,null,"Documents Acceptable?","Comments",null,null,null,null,null,null,null,"No"]
[1,"Written description of the mortgagor's hardship and proposal for relief specific to each property/loan number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[2,"Specific expenses directly attributable to COVID-19 - broken out as paid, incurred not paid and anticipated"]
[3,"Evidence of steps taken to mitigate the loss of rental income; provide copy of resident rent payment notice/policy related to COVID-19, evidence of on-going collection efforts "]
[4,"Actual amount of resident rent received directly or from subsidies for 1st 3 months of 2020"]
[5,"Actual amount of resident rent received directly or from subsidies for April, and estimated revenue for the next 3 months"]
[6,"Rent roll documenting resident hardships, payment plans"]
[7,"Actual expenses for current month and projected operating expenses for next 3 months"]
[8,"Commercial space status, if applicable"]
[9,"Business interruption insurance - notification of approval/denial, if applicable"]
[10,"Consent of tax credit investor, if applicable "]
[11,"Balance Sheet and YTD Statement of Operations"]
[12,"Other: (please specify):"]
[13,"Other: (please specify):"]
[14,"Other: (please specify):"]
[]
["Criteria for approval:",null,null,null,null,null,null,null,null,null,"Yes/No","Comments:"]
[1,"Is the property currently on the Sustainability List? "]
[2,"Did the property identify if it is in default or non-compliance with any  State or Federal agencies?"]
[3,"Does documentation support that the hardship is related to COVID-19?"]
[4,"Have rental assistance subsidies been received (Section 8, state, local, other type of assistance)?"]
[5,"Were all reserve accounts reviewed? "]
[6,"Are funds available in reserves to make loans current?"]
[7,"Is repayment plan acceptable?"]
[]
["Recommendation of Asset Manager (Approve or Deny request and brief summary comments):"]
[]
[]
["Recommendation of Quality Control Asset Manager (Approve or Deny request and brief summary comments):"]
[]
[]
["Follow-up Requirements",null,null,null,null,null,null,null,null,null,"Documents Received?","Due Date of Documents"]
[1,"Executed Legal documentation (Forbearance Agreement)"]
[2,"Balance Sheet and YTD Statement of Operations - Monthly"]
[3,"Aged Accounts Receivable - Monthly"]
[4,"Aged Accounts Payable - Monthly"]
[]
[]
[]
[null,"CHFA Approval",null,null,null,"Signature",null,null,null,null,"Date"]
[]
[null,null,null,"Asset Manager:"]
[null,null,null,"Quality Control Asset Manager:"]
[null,null,null,"Director:"]
[null,null,null,"Managing Director:"]
[null,null,null,"Chief Executive Officer:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Application!O92","v":"Rev 5.06.2020"}]