{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Annual & Close Out Reporting"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"Annual & Close Out Reporting","index":0,"n_rows":75,"n_cols":17,"rows_kept":75,"cut":false,"hidden":false,"merged":[[0,0,0,16],[1,1,1,16],[2,1,2,16],[14,1,15,16],[73,0,73,1],[10,5,10,6],[11,5,11,6],[12,5,12,6],[18,0,18,13],[3,0,3,1],[17,0,17,2],[14,0,15,0],[13,1,13,6],[4,1,4,2],[8,5,8,6],[6,0,6,1],[74,1,74,2],[74,4,74,5],[19,17,19,20],[56,1,56,2],[71,1,71,2],[71,4,71,5],[66,11,66,12],[19,0,19,5],[19,12,19,16],[41,0,41,16],[56,4,56,5],[19,6,19,10],[42,8,42,13],[42,0,42,7]]}
[]
["Annual Report INSTRUCTIONS","Please complete Section 2 and Section 3, as applicable.  An electronic signature may be made by typing your name in the \"Administrator Signature\" section after Section3.  A completed report for each open award is due to Minnesota Housing no later than January 31st of each year.  If you'd like to add additional narrative, please do so in a word document and attach it.  Consult your Impact Fund Fund Availability, Disbursement and Loan/Grant Agreement (\"Agreement\"), including any amendments, for assistance in completing this report."]
["Final Close Out INSTRUCTIONS","Complete Section 4 and submit when the Impact Fund Award is complete.  Submit at ANY time during the year. An Impact Fund award is complete when all Impact Fund Dollars have been expended or returned to Minnesota Housing, all completed Projects have been reported to Minnesota Housing via Household Demographic Project Information forms, and, if the award includes Deferred Loan Funds, all necessary Deferred Loan documents have been recorded and submitted to Minnesota Housing as required. Any Impact Fund Dollars received and not yet reported or expended on eligible activities must be returned with this report.  An electronic signature may be made by typing your name and date after Section 4.  "]
["SECTION 1:  General Impact Fund Award Information"]
["Impact Fund Administrator (Organization) Name"]
["Impact Fund Award ID #"]
["Awarded Funding, including Amendments "]
["Award Termination Date"]
["Grant",0]
["Deferred Loan",0]
["Housing Infrastructure Bond Proceeds",0]
["Interim Loan",0]
["                     Total Award ",{"$f":"SUM(B9:B12)","v":0}]
["Project Name:"]
["Brief Project / Program Description:"]
[]
[]
["SECTION 2:  Complete for all Projects completed under this award"]
["A Project is considered complete when all Eligible Activities to be performed on a Project (e.g., loan closing, construction, and rehabilitation) have been performed, the Qualified Dwelling Unit has been conveyed to or is occupied by an Owner-Occupant, and, if the Project is supported by Deferred Loan Funds, all necessary Deferred loan Documents have been recorded and submitted to Minnesota Housing. Refer to the Impact Fund Procedural Manual for details."]
["Completed Project Information",null,null,null,null,null,"Impact Fund Expenditures",null,null,null,null,"Admin/Dev Fees","Impact Fund Documents Submitted\n(Use drop down menu; Answer \"Yes\" if submitted)"]
["Click button to add more lines below:","BUTTON"]
["Homebuyer / Homeowner \nLast Name ","Homebuyer / Homeowner        \nFirst Name ","Property Street Address","Property City","Property Zip \nCode","Date of Closing      ","Interim Loan"," Grant ","Deferred Loan ","Housing Infrastr  Bond (HIB) Proceeds ","TOTAL","Amount of Administration or Developer Fee from Impact Fund Dollars","Household Demographic Project Information Form","Impact Fund Mortgage\n(Deferred Loan only)","Impact Fund Mortgage Note\n(Deferred Loan only)","Assignment of Mortgage\n(Deferred Loan only)","Closing Disclosure, HUD-1, HUD-1A, or memo"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G23:J23)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G24:J24)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G25:J25)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G26:J26)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G27:J27)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G28:J28)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G32:J32)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G33:J33)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G36:J36)","v":0},0]
[null,null,null,null,null,null,{"$f":"SUM(G23:G36)","v":0},{"$f":"SUM(H23:H36)","v":0},{"$f":"SUM(I23:I36)","v":0},{"$f":"SUM(J23:J36)","v":0},{"$f":"SUM(G23:J36)","v":0},{"$f":"SUM(L23:L36)","v":0}]
[]
[" "]
[null,null,null,null,null,null," Interim Loan"," Grant ","Deferred loan ","HIB Proceeds ","Total Balance"]
[null,null,null,null,null,null,{"$f":"B12-G37","v":0},{"$f":"B9-H37","v":0},{"$f":"B10-I37","v":0},{"$f":"B11-J37","v":0},{"$f":"SUM(G41:J41)","v":0}]
["SECTION 3:  Complete for all pending Projects to be completed under this award"]
["Pending Project Information",null,null,null,null,null,null,null,"Impact Fund Expenditures (Pending and Actual)"]
["Click button to add more lines below:","BUTTON"]
["Homebuyer / Homeowner \nLast Name ","Homebuyer / Homeowner        \nFirst Name ","Property Street Address","Property City","Property Zip \nCode","Is Property Listed for Sale? \n(Acq-Rehab-Resale and New Constr.)","Closing Date (Pending or Actual)","Estimated Project Completion Date","Interim Loan"," Grant ","Deferred Loan ","Housing Infrastr  Bond Proceeds ","Total","Projected Administration or Developer Fee from Impact Fund Dollars "]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I46:L46)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I46:I54)","v":0},{"$f":"SUM(J46:J54)","v":0},{"$f":"SUM(K46:K54)","v":0},{"$f":"SUM(L46:L54)","v":0},{"$f":"SUM(I46:L54)","v":0},{"$f":"SUM(N46:N54)","v":0}]
[]
["Administrator Signature: \n",null,null,"Title:",null,null,"Date: "]
[]
["SECTION 4: Final Close Out Report (To be completed and submitted to Minnesota Housing when the Impact Fund Award is complete.)"]
["Total number of units (Projects)  to be completed with this award (refer to the Loan/Grant Agreement):"]
["Total number of units (Projects) completed with this Impact Fund award (all must be listed above as complete):"]
[]
["Indicate the amount of unspent/unused Impact Fund Dollars being returned to Minnesota Housing. ","Unspent Impact Fund Dollars being returned. "]
["Housing Bond Proceeds "]
["Inter Constr Loan"]
["Grant"]
["Deferred Loan"]
["Unspent Impact Fund Funds ",{"$f":"SUM(B64:B67)","v":0}]
[]
["By signing below, I certify that the awarded Impact Fund Dollars have been used in accordance with the Loan/Grant Agreement."]
["All required documentation has been submitted to Minnesota Housing.  If there are unspent Impact Fund Dollars, these funds have been returned to Minnesota Housing or are being returned with this Final Close Out Report."]
["Administrator Signature: \n",null,null,"Title:",null,null,"Date: "]
[]
["For Minnesota Housing Use Only "]
["Minnesota Housing Signature: \n",null,null,"Date: "]