{"text_format":"1","workbook":"xlsx","n_sheets":31,"sheets":["Cover (pg 1)","Submission Checklist (pg 2)","Development Info (pg 3)","Owner Info (pg 4)","Owner Info Cont'd (pg 5)","More Development Info (pg 6)","Structure and Units (pg 7)","Building Info (pg 8)","Unit Info (pg 9)","Add'l Unit Info (pg 10)","Add'l Unit Info (pg 11)","Set Aside & Comm Supp. (pg 12)","Income and Expenses (pg 13 )","Utilities and Rents (pg 14)","Income and Expenses (pg 15)","Income and Expenses (pg 16)","Income and Expenses (pg 17)","Income and Expenses (pg 18)","Annual Expenses (pg 19)","Proforma (pg 20)","Source of Funds (pg 21)","Sources and Uses (pg 22)","Intermediary Info (pg 23)","Bond Financing Info (pg 24)","Itemized Costs (pg 25)","Itemized Costs (pg 26)","Itemized Cost (pg 27)","Credit Determination (pg 28)","Acknowledgement (pg 29)","Acknowledgement Cont'd (pg 30)","Signature & Notary (pg 31)"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":1,"defined_names":382,"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":"Cover (pg 1)","index":0,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,5,27,10],[7,0,9,10],[2,0,2,10],[14,3,14,8],[25,5,25,10],[19,5,19,10],[21,5,21,10],[23,5,23,10]]}
[]
[]
["Indiana Housing and Community Development Authority"]
[]
[]
[]
[]
["Rental Housing Tax Credit FINAL Application"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Application for \"Final\" Allocation of Rental Housing Financing"]
[]
[]
[]
[]
["Date:"]
[]
["Development Name:"]
[]
["Development City:"]
[]
["Development County:"]
[]
["Building Identification Number (BIN):"]

{"sheet":"Submission Checklist (pg 2)","index":1,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,4,9]]}
["Indiana Housing and Community Development Authority"]
["Rental Housing Tax Credit Final Application"]
["Application for \"Final\" Allocation of Rental Housing Financing"]
["FINAL APPLICATION PACKAGE SUBMISSION CHECKLIST"]
[]
["The Owner must submit, at a minimum, the following documentation to the Authority within six (6) months from the time the"]
["Development is placed in service.  "]
["All documents must be submitted through OneDrive"]

{"sheet":"Development Info (pg 3)","index":2,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[11,1,11,5],[36,7,36,8],[39,3,41,10],[1,1,1,6],[2,5,2,10],[4,5,4,10],[6,3,6,5],[9,1,9,8],[10,1,10,8]]}
[]
["A.","Development Name and Location"]
[null,"1. Development Name"]
[]
[null,"    Street Address"]
[]
[null,"    City",null,null,null,null,null,"State",null,"Zip"]
[]
[]
[null,"Set-Aside Awarded From: See Development Summary"]
[null,"(Applicable for Rental Housing Tax Credits ONLY)"]
[]
[]
[]
[]
[]
[]
[]
[]
["B.","Types of Allocation/Allocation Year"]
[null,"1.  Date of Allocation:"]
[]
[null,"2.  Check the boxes that describe the allocation for the bulding (check those that apply):"]
[null," ","a."]
[null,null,"b."]
[null,null,"c."]
[null,null,"d."]
[null,null,"e."]
[null,null,"f."]
[null,null,"g."]
[]
[null,"3.  What was the first year the tax credits were claimed by the Owner?"]
[]
[null,"4.   At the time of initial application, was the developmetn located in a Qualified Census "]
[null,"      Tract or Difficult to Develop Area",null,null,null,null,null,"Yes","No"]
[]
[null,null,"a. If Yes, Census Tract #:"]
[]
[]
["footnotes:"]

{"sheet":"Owner Info (pg 4)","index":3,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[14,3,14,4],[37,1,37,6],[16,3,16,4],[44,0,44,2],[14,5,14,7],[44,3,45,13],[16,6,16,7],[28,8,28,13],[31,8,31,13],[40,8,40,13],[18,6,18,7],[34,8,34,13],[37,8,37,13],[20,6,20,7],[22,6,22,8],[26,0,26,13],[24,7,24,8],[40,1,40,6],[28,1,28,6],[34,1,34,6],[31,1,31,6],[1,1,1,4],[1,6,1,7],[4,5,4,13],[12,3,12,4],[6,3,6,4],[6,5,6,13],[8,4,8,5],[10,4,10,6],[10,8,10,11],[2,5,2,13],[4,3,4,4],[12,5,12,8]]}
["C.    Owner Information"]
[]
[null,null,null,"a.  Name of Owner"]
[]
[null,null,null,"     Contact Person"]
[]
[null,null,null,"     Street Address"]
[]
[null,null,null,"     City",null,null,"State",null,"Zip"]
[]
[null,null,null,"     Phone",null,null,null,"Fax"]
[]
[null,null,null,"     E-mail Address"]
[]
[null,null,null,"     Federal I.D. No."]
[]
[null,null,null,"     Type of entity:",null,null,"Limited Partnership"]
[]
[null,null,null,null,null,null,"Individual(s)"]
[]
[null,null,null,null,null,null,"Corporation"]
[]
[null,null,null,null,null,null,"Limited Liability Company"]
[]
[null,null,null,null,null,null,"Other"]
[]
["Provide Name and Signature for each Authorized Signatory on behalf of the Applicant."]
[]
["1."]
[null,"Printed Name & Title",null,null,null,null,null,null,"Signature"]
[]
["2."]
[null,"Printed Name & Title",null,null,null,null,null,null,"Signature"]
[]
["3."]
[null,"Printed Name & Title",null,null,null,null,null,null,"Signature"]
[]
["4."]
[null,"Printed Name & Title",null,null,null,null,null,null,"Signature"]
[]
["5."]
[null,"Printed Name & Title",null,null,null,null,null,null,"Signature"]
[]
[]
["footnotes:"]

{"sheet":"Owner Info Cont'd (pg 5)","index":4,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,2,37,11],[15,3,15,5],[14,3,14,5],[13,3,13,5],[34,0,34,1],[14,9,14,12],[15,9,15,12],[16,9,16,12],[17,9,17,12],[24,9,24,12],[18,0,18,2],[17,3,17,5],[17,0,17,2],[29,6,29,11],[30,6,30,11],[31,6,31,11],[18,3,18,5],[14,0,14,2],[16,0,16,2],[8,9,8,12],[9,9,9,12],[17,7,17,8],[18,7,18,8],[18,9,18,12],[16,7,16,8],[14,7,14,8],[15,7,15,8],[1,2,3,12],[16,3,16,5],[8,0,8,2],[9,0,9,2],[7,7,7,8],[8,7,8,8],[9,7,9,8],[8,3,8,5],[9,3,9,5],[10,3,10,5],[11,3,11,5],[11,7,11,8],[10,0,10,2],[13,0,13,2],[10,7,10,8],[12,7,12,8],[6,9,6,12],[7,9,7,12],[13,7,13,8],[11,0,11,2],[15,0,15,2],[12,0,12,2],[10,9,10,12],[11,9,11,12],[12,9,12,12],[13,9,13,12],[7,0,7,2],[6,7,6,8],[6,0,6,2],[6,3,6,5],[7,3,7,5],[12,3,12,5]]}
[]
[null,null,"b.  List all who have an ownership interest in Owner and the Development.  Must include names of all general partners (including, the principals of each general partner, if applicable), managing member, controlling shareholders, etc."]
[]
[]
[]
[]
[null,null,null,"Name",null,null,"Role","Phone #",null,"% Ownership"]
["General Partner (1)"]
["Principal"]
["Principal"]
["Principal"]
["General Partner (2)"]
["Principal"]
["Principal"]
["Principal"]
["Limited Partner"]
["Principal"]
["Principal"]
["Special Ltd Partner"]
[]
[]
["D.     Development Team Information"]
[]
[null,null,"a. Are there any changes to the Development Team?",null,null,null,null,"Yes","No"]
[null,null,"    If yes, please provide additional information regarding these changes in Tab J."]
[]
[null,null,"    Is the Owner/Developer's permanent address different than what is listed in this application?  "]
[null,null,null,null,null,null,null,null,"Yes",null,"No"]
[null,null,"    If yes, please provide the permanent address here:"]
[]
[]
[]
[]
[]
["footnotes:"]

{"sheet":"More Development Info (pg 6)","index":5,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[13,1,13,2],[17,1,17,2],[18,1,18,2],[13,3,13,4],[17,3,17,4],[18,3,18,4],[14,3,14,4],[15,3,15,4],[15,1,15,2],[16,1,16,2],[16,3,16,4],[40,3,45,10],[34,6,34,7],[35,6,35,7],[36,6,36,7],[30,2,30,5],[32,2,32,10],[38,2,38,4],[35,2,35,5],[36,2,36,5],[34,2,34,5],[2,2,2,11],[12,3,12,4],[11,3,11,4],[10,1,10,11],[11,1,11,2],[12,1,12,2],[5,4,6,11],[7,4,8,11],[19,3,19,4],[26,3,26,4],[27,1,27,2],[19,1,19,2],[14,1,14,2],[20,1,20,2],[26,1,26,2],[27,3,27,4],[20,3,20,4],[21,3,21,4]]}
["E.",null,"Development Information"]
[]
[null,"1.","Rental Housing Tax Credit and/or Multifamily Tax-Exempt Bond Unit Breakdowns"]
[null,null,"Indicate if the development will be subject to additional income restrictions and/or rent restrictions:"]
[]
[null,null,null,null,"The AMI percentage elected below will apply to both rent and income limits (Required if electing Income Averaging Minimum Set-Aside);"]
[]
[null,null,null,null,"The AMI percentage elected below will apply only to rent limits. All income limits will be based on the Federal Minimum Set-Aside election of 50% or 60% AMI. "]
[]
[]
[null,"List number of units and number of bedrooms for each income category in chart below:"]
[null,null,null,null,null,"0 Bedroom","1 Bedroom","2 Bedrooms","3 Bedrooms.","4 Bedrooms.","Total","% of Total"]
[null,"20 % AMI",null,"# Units",null,null,null,null,null,null,{"$f":"SUM(F13:J13)","v":0},{"$f":"Text130/jhfjh12","v":{"$error":"#DIV/0!"}}]
[null,"30% AMI",null,"# Units",null,null,null,null,null,null,{"$f":"SUM(F14:J14)","v":0},{"$f":"K14/jhfjh12","v":{"$error":"#DIV/0!"}}]
[null,"40 % AMI",null,"# Units",null,null,null,null,null,null,{"$f":"+SUM(F15:J15)","v":0},{"$f":"Text137/jhfjh12","v":{"$error":"#DIV/0!"}}]
[null,"50% AMI",null,"# Units",null,null,null,null,null,null,0,{"$f":"Text144/jhfjh12","v":{"$error":"#DIV/0!"}}]
[null,"60% AMI",null,"# Units",null,null,null,null,null,null,0,{"$f":"Text151/jhfjh12","v":{"$error":"#DIV/0!"}}]
[null,"70% AMI",null,"# Units",null,null,null,null,null,null,{"$f":"SUM(F18:J18)","v":0},{"$f":"K18/jhfjh12","v":{"$error":"#DIV/0!"}}]
[null,"80% AMI",null,"# Units",null,null,null,null,null,null,0,{"$f":"K19/jhfjh12","v":{"$error":"#DIV/0!"}}]
[null,"Market Rate    ",null,"# Units",null,null,null,null,null,null,{"$f":"+SUM(F20:J20)","v":0},{"$f":"Text158/jhfjh12","v":{"$error":"#DIV/0!"}}]
[null,"Development Total",null,"# Units",null,{"$f":"+SUM(F13:F20)","v":0},{"$f":"+SUM(G13:G20)","v":0},{"$f":"+SUM(H13:H20)","v":0},0,0,{"$f":"SUM(K13:K20)","v":0},{"$f":"SUM(L13:L20)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"# Bdrms.",null,{"$f":"F21*0","v":0},{"$f":"G21*1","v":0},{"$f":"H21*2","v":0},{"$f":"I21*3","v":0},{"$f":"J21*4","v":0},{"$f":"SUM(F22:J22)","v":0}]
[null,"*  No market rate units are permitted in scattered site developments per IRS Code Section 42(g)(7)"]
[]
[null,"Unit Size:"]
[null,"What percent of units, by bedroom type, meet or exceed the square footage requirements set forth in G.3(c) of the QAP?"]
[null,null,null,null,null,"0 Bedrooms","1 Bedroom","2 Bedrooms","3 Bedrooms","4 Bedrooms"]
[null,"All Unit Sizes & AMI Levels",null,"# Units"]
[null,"*  No market rate units are permitted in scattered site developments per IRS Code Section 42(g)(7)"]
[]
[null,"G.","Special Housing Needs"]
[null,null,"1.  Will this development be classified as Elderly Housing*?"]
[null,null,"2.  Identify the number of units set aside for special housing needs below*:"]
[]
[null,null,"Special Needs",null,null,null,"# of Units"]
[null,null,"Homeless *"]
[null,null,"Persons with disabilities"]
[null,null,"* This requirement will be contained within the Declaration of Rental Housing Commitment recorded on the property."]
[]
[]
[null,"footnotes:"]

{"sheet":"Structure and Units (pg 7)","index":6,"n_rows":47,"n_cols":14,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,2,0,4],[4,0,4,4],[4,5,4,7],[4,8,4,9],[5,0,5,4],[4,13,4,14],[2,2,2,10],[5,13,5,14],[6,13,6,14],[5,10,5,12],[6,10,6,12],[5,8,5,9],[6,8,6,9],[6,0,6,4],[4,10,4,12],[5,5,5,7],[6,5,6,7],[7,13,7,14],[8,13,8,14],[7,8,7,9],[7,0,7,4],[8,0,8,4],[7,10,7,12],[8,10,8,12],[8,5,8,7],[8,8,8,9],[7,5,7,7],[14,4,14,7],[13,9,13,10],[14,9,14,10],[12,9,12,10],[16,12,16,13],[18,2,18,9],[18,10,18,11],[18,12,18,13],[16,10,16,11],[24,9,24,14],[27,3,27,13],[28,3,28,14],[20,2,20,7],[20,10,20,11],[20,12,20,13],[22,2,22,7],[22,10,22,11],[22,12,22,13],[46,0,46,2],[41,2,41,14],[42,2,42,14],[43,2,43,14],[44,2,44,5],[46,3,48,13],[38,2,38,14],[37,2,37,12],[29,3,29,14],[37,13,37,14],[35,2,35,11],[33,10,33,11],[33,12,33,13],[33,2,33,9],[30,3,30,14],[31,3,31,10]]}
[null,"2.","Structure and Units"]
[]
[null,null,"a.  List unit type(s) and number of bedroom(s) by bedroom size."]
[]
["Unit Type",null,null,null,null,"0-1 Bedroom",null,null,"2 Bedrooms",null,"3 Bedrooms",null,null,"4 Bedrooms"]
["Substantial Rehabilitation"]
["Single Family (Infill) Scattered Site"]
["Historic Rehabilitation"]
["New Construction"]
[]
[null,null,"b.  The type(s) of unit is (are):"]
[]
[null,null,null," Standard Residential Rental",null,null,null,null,null,"No. of Units"]
[null,null,null," Single Room Occupancy Housing (SRO)",null,null,null,null,null,"No. of Units"]
[null,null,null," Other",null,null,null,null,null,"No. of Units"]
[]
[null,null,"c.  Gross Residential Floor Area (resident living space only)",null,null,null,null,null,null,null,null,null,"Sq Ft."]
[]
[null,null,"d.  Gross Common Area (hallways, community space, ect.)",null,null,null,null,null,null,null,null,null,"Sq Ft."]
[]
[null,null,"e.  Gross Floor Area (all buildings) [d + e]",null,null,null,null,null,null,null,null,null,"Sq Ft."]
[]
[null,null,"f.  Gross Commercial Floor Area (if applicable)",null,null,null,null,null,null,null,null,null,"Sq Ft."]
[]
[null,null,"g.  Intended Use of Commercial Area (if applicable)"]
[null,null,null,"(Use add'l sheets, if necessary)."]
[]
[null,null,null,"All commercial uses must be included in the Declaration of Extended Rental Housing "]
[null,null,null,"Commitment.  Additional information must be provided in Tab F of the application package"]
[null,null,null,"detailing the square footage layout of the building and/or property, identifying all residential"]
[null,null,null,"and commercial area; a time-line for complete construction showing that all commercial areas"]
[null,null,null,"will be completed prior to the residential areas being occupied."]
[]
[null,null,"h.  Total number of residential buildings in the Development:",null,null,null,null,null,null,null,null,null," building(s)"]
[]
[null,null,"i.  Will the development utilize a staff unit (security, maintenance unit)?",null,null,null,null,null,null,null,null,null,"Yes","No"]
[null,null,null,"  j. If yes: "]
[null,null,"k.  If yes, how will the unit be considered in the building's applicable fraction?"]
[null,null,"             Tax Credit Unit           Common Area"]
[null,null,"l.   If yes, Number of units requested : "]
[]
[null,null,"NOTE:  If the manager's unit will be utilized as common area, then the unit must remain in "]
[null,null,"the same building.  Developments with market rate units will not be allowed to designate tax"]
[null,null,"credit units as manager's, security, and/or maintenance units unless the tenant qualifies"]
[null,null,"under Section 42 guidelines."]
[]
["footnotes:"]

{"sheet":"Building Info (pg 8)","index":7,"n_rows":52,"n_cols":79,"rows_kept":52,"cut":false,"hidden":false,"merged":[[4,22,7,22],[39,53,39,57],[39,48,39,52],[39,43,39,47],[39,38,39,42],[38,53,38,57],[38,48,38,52],[38,43,38,47],[38,38,38,42],[24,53,24,57],[24,48,24,52],[24,43,24,47],[24,38,24,42],[24,33,24,37],[24,28,24,32],[21,38,21,42],[21,33,21,37],[29,53,29,57],[22,33,22,37],[22,38,22,42],[22,43,22,47],[21,28,21,32],[21,23,21,27],[23,48,23,52],[23,43,23,47],[23,38,23,42],[23,33,23,37],[23,28,23,32],[23,23,23,27],[29,43,29,47],[29,48,29,52],[22,23,22,27],[22,28,22,32],[24,23,24,27],[14,28,14,32],[15,28,15,32],[15,33,15,37],[15,38,15,42],[16,28,16,32],[16,33,16,37],[16,38,16,42],[14,33,14,37],[14,38,14,42],[9,15,9,21],[14,23,14,27],[13,23,13,27],[9,23,9,27],[17,15,17,21],[14,15,14,21],[19,15,19,21],[9,53,9,57],[9,48,9,52],[9,43,9,47],[9,38,9,42],[9,33,9,37],[9,28,9,32],[12,53,12,57],[12,48,12,52],[12,43,12,47],[11,53,11,57],[11,48,11,52],[12,33,12,37],[12,28,12,32],[13,48,13,52],[13,43,13,47],[13,38,13,42],[13,28,13,32],[18,78,18,82],[15,15,15,21],[18,15,18,21],[21,15,21,21],[23,15,23,21],[22,15,22,21],[20,23,20,27],[20,15,20,21],[16,23,16,27],[16,15,16,21],[15,23,15,27],[17,23,17,27],[18,43,18,47],[18,38,18,42],[18,33,18,37],[18,28,18,32],[18,23,18,27],[19,43,19,47],[19,38,19,42],[19,33,19,37],[19,28,19,32],[19,23,19,27],[21,63,21,67],[17,38,17,42],[41,78,41,82],[42,78,42,82],[43,78,43,82],[44,78,44,82],[4,78,7,82],[8,78,8,82],[9,78,9,82],[10,78,10,82],[11,78,11,82],[12,78,12,82],[25,78,25,82],[26,78,26,82],[27,78,27,82],[19,78,19,82],[20,78,20,82],[21,78,21,82],[22,78,22,82],[23,78,23,82],[24,78,24,82],[13,78,13,82],[14,78,14,82],[15,78,15,82],[16,78,16,82],[17,78,17,82],[28,78,28,82],[29,78,29,82],[30,78,30,82],[31,78,31,82],[32,78,32,82],[40,68,40,72],[41,68,41,72],[38,68,38,72],[38,73,38,77],[36,68,36,72],[33,78,33,82],[37,78,37,82],[36,78,36,82],[38,78,38,82],[39,78,39,82],[40,78,40,82],[35,73,35,77],[31,68,31,72],[34,78,34,82],[35,78,35,82],[39,73,39,77],[34,73,34,77],[32,73,32,77],[33,73,33,77],[50,78,50,82],[45,78,45,82],[46,63,46,67],[44,58,44,62],[49,68,49,72],[46,78,46,82],[47,78,47,82],[48,78,48,82],[49,78,49,82],[50,73,50,77],[49,73,49,77],[49,63,49,67],[48,68,48,72],[48,73,48,77],[46,68,46,72],[46,73,46,77],[47,73,47,77],[45,73,45,77],[51,68,51,72],[50,68,50,72],[10,58,10,62],[11,58,11,62],[12,58,12,62],[13,58,13,62],[14,58,14,62],[21,58,21,62],[22,58,22,62],[23,58,23,62],[47,68,47,72],[44,68,44,72],[45,68,45,72],[43,68,43,72],[42,63,42,67],[39,63,39,67],[39,68,39,72],[46,58,46,62],[47,58,47,62],[50,63,50,67],[42,68,42,72],[38,63,38,67],[34,68,34,72],[32,63,32,67],[51,63,51,67],[47,43,47,47],[45,53,45,57],[15,58,15,62],[16,58,16,62],[17,58,17,62],[48,58,48,62],[39,58,39,62],[38,58,38,62],[27,58,27,62],[28,58,28,62],[48,53,48,57],[49,53,49,57],[46,43,46,47],[46,48,46,52],[46,53,46,57],[34,53,34,57],[34,48,34,52],[34,43,34,47],[21,53,21,57],[21,48,21,52],[21,43,21,47],[47,63,47,67],[48,63,48,67],[49,15,49,21],[49,23,49,27],[29,58,29,62],[24,58,24,62],[25,58,25,62],[26,58,26,62],[51,23,51,27],[51,28,51,32],[51,33,51,37],[51,38,51,42],[51,43,51,47],[44,23,44,27],[44,28,44,32],[46,38,46,42],[34,38,34,42],[48,23,48,27],[48,15,48,21],[50,33,50,37],[50,28,50,32],[50,23,50,27],[50,15,50,21],[49,28,49,32],[48,33,48,37],[48,28,48,32],[50,38,50,42],[50,43,50,47],[50,48,50,52],[50,53,50,57],[23,53,23,57],[49,58,49,62],[50,58,50,62],[47,28,47,32],[47,33,47,37],[47,38,47,42],[32,58,32,62],[33,58,33,62],[40,58,40,62],[41,58,41,62],[34,58,34,62],[35,58,35,62],[36,58,36,62],[48,43,48,47],[48,48,48,52],[49,33,49,37],[49,38,49,42],[49,43,49,47],[49,48,49,52],[47,48,47,52],[47,53,47,57],[50,1,50,12],[49,1,49,12],[48,1,48,12],[47,1,47,12],[47,15,47,21],[47,23,47,27],[44,63,44,67],[45,1,45,12],[45,15,45,21],[45,23,45,27],[45,28,45,32],[45,33,45,37],[45,38,45,42],[45,63,45,67],[44,1,44,12],[44,15,44,21],[45,58,45,62],[44,38,44,42],[44,43,44,47],[44,48,44,52],[44,53,44,57],[45,43,45,47],[45,48,45,52],[48,38,48,42],[42,73,42,77],[43,73,43,77],[42,38,42,42],[42,43,42,47],[42,1,42,12],[42,15,42,21],[42,33,42,37],[46,1,46,12],[46,15,46,21],[46,23,46,27],[46,28,46,32],[46,33,46,37],[42,23,42,27],[43,1,43,12],[43,15,43,21],[43,23,43,27],[43,28,43,32],[43,33,43,37],[44,73,44,77],[44,33,44,37],[42,48,42,52],[42,53,42,57],[42,28,42,32],[43,38,43,42],[43,43,43,47],[43,48,43,52],[43,53,43,57],[43,63,43,67],[42,58,42,62],[43,58,43,62],[41,15,41,21],[41,23,41,27],[41,28,41,32],[41,33,41,37],[41,38,41,42],[41,43,41,47],[40,1,40,12],[40,15,40,21],[41,73,41,77],[40,38,40,42],[40,43,40,47],[40,48,40,52],[40,53,40,57],[40,63,40,67],[40,73,40,77],[41,1,41,12],[41,48,41,52],[41,53,41,57],[40,23,40,27],[40,28,40,32],[40,33,40,37],[41,63,41,67],[36,23,36,27],[36,28,36,32],[36,33,36,37],[39,1,39,12],[39,15,39,21],[39,23,39,27],[39,28,39,32],[39,33,39,37],[37,23,37,27],[37,28,37,32],[37,33,37,37],[38,1,38,12],[38,15,38,21],[38,23,38,27],[38,28,38,32],[38,33,38,37],[37,48,37,52],[37,73,37,77],[36,38,36,42],[36,43,36,47],[36,48,36,52],[36,53,36,57],[36,63,36,67],[36,73,36,77],[37,53,37,57],[37,58,37,62],[37,63,37,67],[34,1,34,12],[34,15,34,21],[34,23,34,27],[34,28,34,32],[34,33,34,37],[37,68,37,72],[36,1,36,12],[36,15,36,21],[37,1,37,12],[37,15,37,21],[34,63,34,67],[35,38,35,42],[35,43,35,47],[35,48,35,52],[35,53,35,57],[35,63,35,67],[35,1,35,12],[35,15,35,21],[35,23,35,27],[35,28,35,32],[35,33,35,37],[35,68,35,72],[37,38,37,42],[37,43,37,47],[33,1,33,12],[33,15,33,21],[33,23,33,27],[33,28,33,32],[33,33,33,37],[33,38,33,42],[33,43,33,47],[33,48,33,52],[32,68,32,72],[33,63,33,67],[33,68,33,72],[32,1,32,12],[32,15,32,21],[32,38,32,42],[32,43,32,47],[32,48,32,52],[32,53,32,57],[33,53,33,57],[32,23,32,27],[32,28,32,32],[32,33,32,37],[30,1,30,12],[30,15,30,21],[30,23,30,27],[30,28,30,32],[30,58,30,62],[31,58,31,62],[30,43,30,47],[30,48,30,52],[30,53,30,57],[31,38,31,42],[31,43,31,47],[31,48,31,52],[31,53,31,57],[31,63,31,67],[28,23,28,27],[28,28,28,32],[30,73,30,77],[31,1,31,12],[31,15,31,21],[31,23,31,27],[31,28,31,32],[31,33,31,37],[31,73,31,77],[30,38,30,42],[29,1,29,12],[29,15,29,21],[29,23,29,27],[29,28,29,32],[29,33,29,37],[29,38,29,42],[29,73,29,77],[28,38,28,42],[28,43,28,47],[28,48,28,52],[28,53,28,57],[28,63,28,67],[28,73,28,77],[28,15,28,21],[28,33,28,37],[26,68,26,72],[25,63,25,67],[27,1,27,12],[27,48,27,52],[27,53,27,57],[27,63,27,67],[27,68,27,72],[25,1,25,12],[25,15,25,21],[25,23,25,27],[25,28,25,32],[25,68,25,72],[27,15,27,21],[27,23,27,27],[27,28,27,32],[27,33,27,37],[26,1,26,12],[26,15,26,21],[26,23,26,27],[26,28,26,32],[26,33,26,37],[25,13,25,14],[26,73,26,77],[30,33,30,37],[28,68,28,72],[29,63,29,67],[29,68,29,72],[30,68,30,72],[30,63,30,67],[24,1,24,12],[24,15,24,21],[27,73,27,77],[26,38,26,42],[26,43,26,47],[26,48,26,52],[26,53,26,57],[26,63,26,67],[27,38,27,42],[27,43,27,47],[24,63,24,67],[24,68,24,72],[25,33,25,37],[25,38,25,42],[25,43,25,47],[25,48,25,52],[28,1,28,12],[25,73,25,77],[23,73,23,77],[23,63,23,67],[23,68,23,72],[22,48,22,52],[22,53,22,57],[22,68,22,72],[22,73,22,77],[22,63,22,67],[25,53,25,57],[24,73,24,77],[20,28,20,32],[20,33,20,37],[20,38,20,42],[20,58,20,62],[19,48,19,52],[19,53,19,57],[17,53,17,57],[19,68,19,72],[19,73,19,77],[19,63,19,67],[20,43,20,47],[20,48,20,52],[20,53,20,57],[20,63,20,67],[20,68,20,72],[20,73,20,77],[19,58,19,62],[18,53,18,57],[18,48,18,52],[17,63,17,67],[18,63,18,67],[18,68,18,72],[17,33,17,37],[17,28,17,32],[15,48,15,52],[15,43,15,47],[17,48,17,52],[17,43,17,47],[14,63,14,67],[14,68,14,72],[15,73,15,77],[21,68,21,72],[21,73,21,77],[10,1,10,12],[10,15,10,21],[10,23,10,27],[10,28,10,32],[10,33,10,37],[11,15,11,21],[11,23,11,27],[18,73,18,77],[18,58,18,62],[14,73,14,77],[17,68,17,72],[17,73,17,77],[16,73,16,77],[15,63,15,67],[15,68,15,72],[16,43,16,47],[16,48,16,52],[16,53,16,57],[14,48,14,52],[16,63,16,67],[16,68,16,72],[14,53,14,57],[14,43,14,47],[15,53,15,57],[11,38,11,42],[15,1,15,12],[14,1,14,12],[13,33,13,37],[10,68,10,72],[12,38,12,42],[11,68,11,72],[10,73,10,77],[13,73,13,77],[12,68,12,72],[12,73,12,77],[12,63,12,67],[13,53,13,57],[12,1,12,12],[12,15,12,21],[12,23,12,27],[10,38,10,42],[10,43,10,47],[10,48,10,52],[10,53,10,57],[13,63,13,67],[13,68,13,72],[13,15,13,21],[11,73,11,77],[17,1,17,12],[9,1,9,12],[13,1,13,12],[16,1,16,12],[9,58,9,62],[4,63,7,67],[4,58,7,62],[8,58,8,62],[9,63,9,67],[10,63,10,67],[8,1,8,12],[4,1,7,12],[4,15,7,21],[4,23,7,27],[4,28,7,32],[4,33,7,37],[4,38,7,42],[4,43,7,47],[8,15,8,21],[8,23,8,27],[8,28,8,32],[11,43,11,47],[11,28,11,32],[11,33,11,37],[2,1,2,6],[2,7,2,24],[22,1,22,12],[23,1,23,12],[21,1,21,12],[18,1,18,12],[8,63,8,67],[8,68,8,72],[8,73,8,77],[4,53,7,57],[4,48,7,52],[11,1,11,12],[19,1,19,12],[20,1,20,12],[4,68,7,72],[4,73,7,77],[8,33,8,37],[8,38,8,42],[8,43,8,47],[8,48,8,52],[8,53,8,57],[9,68,9,72],[9,73,9,77],[11,63,11,67],[4,13,7,14],[8,13,8,14],[9,13,9,14],[10,13,10,14],[11,13,11,14],[12,13,12,14],[13,13,13,14],[14,13,14,14],[15,13,15,14],[16,13,16,14],[17,13,17,14],[18,13,18,14],[19,13,19,14],[20,13,20,14],[21,13,21,14],[22,13,22,14],[23,13,23,14],[24,13,24,14],[26,13,26,14],[27,13,27,14],[28,13,28,14],[29,13,29,14],[30,13,30,14],[31,13,31,14],[32,13,32,14],[33,13,33,14],[34,13,34,14],[44,13,44,14],[45,13,45,14],[46,13,46,14],[47,13,47,14],[48,13,48,14],[49,13,49,14],[50,13,50,14],[35,13,35,14],[36,13,36,14],[37,13,37,14],[38,13,38,14],[39,13,39,14],[40,13,40,14],[41,13,41,14],[42,13,42,14],[43,13,43,14]]}
[]
[]
[null,"Project Address:"]
[]
[null,"Building Address",null,null,null,null,null,null,null,null,null,null,null,"Type (Acq/Rehab/NC)",null,"Building Identificaton Number",null,null,null,null,null,null,"Placed in Service Date (mm/dd/yy)","Number of Residential Units",null,null,null,null,"Number of LIHTC Units",null,null,null,null,"Building Residential Sq. Footage",null,null,null,null,"Building LIHTC Sq. Footage",null,null,null,null,"Eligible Basis",null,null,null,null,"Applicable Fraction (based on Sq. Footage)",null,null,null,null,"Applicable Fraction (based on # of units)",null,null,null,null,"Applicable Fraction ",null,null,null,null,"Building's Qualified Basis",null,null,null,null,"Tax Credit Amount",null,null,null,null,"Rate",null,null,null,null,"Maximum Qualified Basis               \"#3a on 8609\""]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH9=0,\"\",+AM9/AH9)","v":""},null,null,null,null,{"$f":"IF(X9=0,\"\",+AC9/X9)","v":""},null,null,null,null,{"$f":"IF(BB9<AW9,BB9,AW9)","v":""},null,null,null,null,{"$f":"IF(BG9=\"\",\"\",BG9*AR9)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BQ9/BV9","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH10=0,\"\",+AM10/AH10)","v":""},null,null,null,null,{"$f":"IF(X10=0,\"\",+AC10/X10)","v":""},null,null,null,null,{"$f":"IF(BB10<AW10,BB10,AW10)","v":""},null,null,null,null,{"$f":"IF(BG10=\"\",\"\",BG10*AR10)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BQ10/BV10","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH11=0,\"\",+AM11/AH11)","v":""},null,null,null,null,{"$f":"IF(X11=0,\"\",+AC11/X11)","v":""},null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BQ11/BV11","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,{"$f":"IF(X12=0,\"\",+AC12/X12)","v":""},null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X9:AB51)","v":0},null,null,null,null,{"$f":"SUM(AC9:AG51)","v":0},null,null,null,null,{"$f":"SUM(AH9:AL51)","v":0},null,null,null,null,{"$f":"SUM(AM9:AQ51)","v":0},null,null,null,null,{"$f":"SUM(AR9:AV51)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BL9:BP51)","v":0},null,null,null,null,{"$f":"SUM(BQ9:BU51)","v":0}]

{"sheet":"Unit Info (pg 9)","index":8,"n_rows":50,"n_cols":63,"rows_kept":50,"cut":false,"hidden":false,"merged":[[40,62,41,70],[42,0,43,13],[42,14,43,19],[42,20,43,25],[42,26,43,31],[42,32,43,37],[42,38,43,43],[42,44,43,49],[42,50,43,55],[42,56,43,61],[42,62,43,70],[40,0,41,13],[40,14,41,19],[40,20,41,25],[40,26,41,31],[40,32,41,37],[40,38,41,43],[40,44,41,49],[40,50,41,55],[40,56,41,61],[36,62,37,70],[38,0,39,13],[38,14,39,19],[38,20,39,25],[38,26,39,31],[38,32,39,37],[38,38,39,43],[38,44,39,49],[38,50,39,55],[38,56,39,61],[38,62,39,70],[36,0,37,13],[36,14,37,19],[36,20,37,25],[36,26,37,31],[36,32,37,37],[36,38,37,43],[36,44,37,49],[36,50,37,55],[36,56,37,61],[44,0,45,13],[46,0,47,13],[46,14,47,19],[44,44,45,49],[44,50,45,55],[44,56,45,61],[44,62,45,70],[44,14,45,19],[44,20,45,25],[44,26,45,31],[44,32,45,37],[44,38,45,43],[46,20,47,25],[46,26,47,31],[46,32,47,37],[46,38,47,43],[46,44,47,49],[46,50,47,55],[46,56,47,61],[46,62,47,70],[32,56,33,61],[32,62,33,70],[34,0,35,13],[34,14,35,19],[34,20,35,25],[34,26,35,31],[34,32,35,37],[34,38,35,43],[34,44,35,49],[34,50,35,55],[34,56,35,61],[34,62,35,70],[32,14,33,19],[32,20,33,25],[32,26,33,31],[32,32,33,37],[32,38,33,43],[32,44,33,49],[28,20,29,25],[28,26,29,31],[28,32,29,37],[28,38,29,43],[28,0,29,13],[30,32,31,37],[30,38,31,43],[30,44,31,49],[32,50,33,55],[30,50,31,55],[30,56,31,61],[30,62,31,70],[24,0,25,13],[32,0,33,13],[28,44,29,49],[28,50,29,55],[28,56,29,61],[28,62,29,70],[30,0,31,13],[30,14,31,19],[30,20,31,25],[30,26,31,31],[26,38,27,43],[26,44,27,49],[26,50,27,55],[26,56,27,61],[26,62,27,70],[24,14,25,19],[24,20,25,25],[24,26,25,31],[24,32,25,37],[24,38,25,43],[28,14,29,19],[24,44,25,49],[24,50,25,55],[24,56,25,61],[24,62,25,70],[26,0,27,13],[26,14,27,19],[26,20,27,25],[26,26,27,31],[26,32,27,37],[20,44,21,49],[20,50,21,55],[20,56,21,61],[20,62,21,70],[22,0,23,13],[22,14,23,19],[22,20,23,25],[22,26,23,31],[22,32,23,37],[20,0,21,13],[22,38,23,43],[22,44,23,49],[22,50,23,55],[22,56,23,61],[22,62,23,70],[20,14,21,19],[20,20,21,25],[20,26,21,31],[20,32,21,37],[20,38,21,43],[18,0,19,13],[18,14,19,19],[18,20,19,25],[18,26,19,31],[18,32,19,37],[18,38,19,43],[10,56,11,61],[18,44,19,49],[18,50,19,55],[18,56,19,61],[18,62,19,70],[16,14,17,19],[16,20,17,25],[16,26,17,31],[16,32,17,37],[16,38,17,43],[16,56,17,61],[16,62,17,70],[12,14,13,19],[12,20,13,25],[12,26,13,31],[12,32,13,37],[12,38,13,43],[12,44,13,49],[12,50,13,55],[12,56,13,61],[12,62,13,70],[3,1,3,13],[2,14,2,31],[3,14,3,42],[8,44,9,49],[8,50,9,55],[14,14,15,19],[14,20,15,25],[14,26,15,31],[14,32,15,37],[14,38,15,43],[10,0,11,13],[10,14,11,19],[10,20,11,25],[10,26,11,31],[14,44,15,49],[14,50,15,55],[8,14,9,19],[8,20,9,25],[8,26,9,31],[8,32,9,37],[8,38,9,43],[10,32,11,37],[10,38,11,43],[2,0,2,13],[49,5,49,70],[5,0,7,13],[5,14,7,19],[5,20,7,25],[5,26,7,31],[5,32,7,37],[5,38,7,43],[5,44,7,49],[5,50,7,55],[5,56,7,61],[8,0,9,13],[12,0,13,13],[16,44,17,49],[16,50,17,55],[14,0,15,13],[16,0,17,13],[5,62,7,70],[8,56,9,61],[8,62,9,70],[14,56,15,61],[14,62,15,70],[10,44,11,49],[10,50,11,55],[10,62,11,70]]}
["Please provide the following unit information for each building."]
[]
["Building Identification Number (BIN):"]
[null,"Address of Building:"]
[]
["Address & Unit Number (include city and zip code)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Type of Unit (LIHTC or Market Rate)",null,null,null,null,null,"Number of Bedrooms",null,null,null,null,null,"Unit Sq. Footage",null,null,null,null,null,"Current Tenant Income",null,null,null,null,null,"Monthly Rent Amount",null,null,null,null,null,"Rent AMI Level %",null,null,null,null,null,"Income AMI Level %",null,null,null,null,null,"Special Needs Unit?",null,null,null,null,null,"Annual Allocated Credit Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["footnotes: "]

{"sheet":"Add'l Unit Info (pg 10)","index":9,"n_rows":46,"n_cols":63,"rows_kept":46,"cut":false,"hidden":false,"merged":[[38,50,39,55],[38,56,39,61],[38,62,39,70],[2,14,2,31],[3,1,3,13],[3,14,3,42],[5,0,7,13],[5,14,7,19],[5,20,7,25],[5,26,7,31],[5,32,7,37],[5,38,7,43],[2,0,2,13],[5,44,7,49],[5,50,7,55],[5,56,7,61],[5,62,7,70],[8,0,9,13],[8,14,9,19],[8,20,9,25],[8,26,9,31],[8,32,9,37],[8,38,9,43],[8,44,9,49],[8,50,9,55],[8,56,9,61],[8,62,9,70],[10,62,11,70],[12,0,13,13],[12,14,13,19],[12,20,13,25],[12,26,13,31],[12,32,13,37],[12,38,13,43],[12,44,13,49],[12,50,13,55],[12,56,13,61],[12,62,13,70],[10,0,11,13],[10,14,11,19],[10,20,11,25],[10,26,11,31],[10,32,11,37],[10,38,11,43],[10,44,11,49],[10,50,11,55],[10,56,11,61],[14,62,15,70],[16,0,17,13],[16,14,17,19],[16,20,17,25],[16,26,17,31],[16,32,17,37],[16,38,17,43],[16,44,17,49],[16,50,17,55],[16,56,17,61],[16,62,17,70],[14,0,15,13],[14,14,15,19],[14,20,15,25],[14,26,15,31],[14,32,15,37],[14,38,15,43],[14,44,15,49],[14,50,15,55],[14,56,15,61],[18,62,19,70],[20,0,21,13],[20,14,21,19],[20,20,21,25],[20,26,21,31],[20,32,21,37],[20,38,21,43],[20,44,21,49],[20,50,21,55],[20,56,21,61],[20,62,21,70],[18,0,19,13],[18,14,19,19],[18,20,19,25],[18,26,19,31],[18,32,19,37],[18,38,19,43],[18,44,19,49],[18,50,19,55],[18,56,19,61],[22,62,23,70],[24,0,25,13],[24,14,25,19],[24,20,25,25],[24,26,25,31],[24,32,25,37],[24,38,25,43],[24,44,25,49],[24,50,25,55],[24,56,25,61],[24,62,25,70],[22,0,23,13],[22,14,23,19],[22,20,23,25],[22,26,23,31],[22,32,23,37],[22,38,23,43],[22,44,23,49],[22,50,23,55],[22,56,23,61],[26,62,27,70],[28,0,29,13],[28,14,29,19],[28,20,29,25],[28,26,29,31],[28,32,29,37],[28,38,29,43],[28,44,29,49],[28,50,29,55],[28,56,29,61],[28,62,29,70],[26,0,27,13],[26,14,27,19],[26,20,27,25],[26,26,27,31],[26,32,27,37],[26,38,27,43],[26,44,27,49],[26,50,27,55],[26,56,27,61],[30,62,31,70],[32,0,33,13],[32,14,33,19],[32,20,33,25],[32,26,33,31],[32,32,33,37],[32,38,33,43],[32,44,33,49],[32,50,33,55],[32,56,33,61],[32,62,33,70],[30,0,31,13],[30,14,31,19],[30,20,31,25],[30,26,31,31],[30,32,31,37],[30,38,31,43],[30,44,31,49],[30,50,31,55],[30,56,31,61],[34,62,35,70],[36,0,37,13],[36,14,37,19],[36,20,37,25],[36,26,37,31],[36,32,37,37],[36,38,37,43],[42,44,43,49],[42,50,43,55],[42,56,43,61],[42,62,43,70],[34,0,35,13],[34,14,35,19],[34,20,35,25],[34,26,35,31],[34,32,35,37],[34,38,35,43],[34,44,35,49],[34,50,35,55],[34,56,35,61],[40,0,41,13],[40,14,41,19],[40,20,41,25],[40,26,41,31],[45,5,45,70],[36,44,37,49],[36,50,37,55],[36,56,37,61],[36,62,37,70],[42,0,43,13],[42,14,43,19],[42,20,43,25],[42,26,43,31],[42,32,43,37],[42,38,43,43],[40,32,41,37],[40,38,41,43],[40,44,41,49],[40,50,41,55],[40,56,41,61],[40,62,41,70],[38,0,39,13],[38,14,39,19],[38,20,39,25],[38,26,39,31],[38,32,39,37],[38,38,39,43],[38,44,39,49]]}
["Please provide the following unit information for each building."]
[]
["Building Identification Number (BIN):"]
[null,"Address of Building:"]
[]
["Address & Unit Number (include city and zip code)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Type of Unit (LIHTC or Market Rate)",null,null,null,null,null,"Number of Bedrooms",null,null,null,null,null,"Unit Sq. Footage",null,null,null,null,null,"Current Tenant Income",null,null,null,null,null,"Monthly Rent Amount",null,null,null,null,null,"Rent AMI Level %",null,null,null,null,null,"Income AMI Level %",null,null,null,null,null,"Special Needs Unit?",null,null,null,null,null,"Annual Allocated Credit Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["footnotes: "]

{"sheet":"Add'l Unit Info (pg 11)","index":10,"n_rows":46,"n_cols":63,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,5,45,70],[36,44,37,49],[36,50,37,55],[36,56,37,61],[36,62,37,70],[42,0,43,13],[42,14,43,19],[42,20,43,25],[42,26,43,31],[42,32,43,37],[42,38,43,43],[40,0,41,13],[40,14,41,19],[40,20,41,25],[40,26,41,31],[40,32,41,37],[38,0,39,13],[38,14,39,19],[38,20,39,25],[38,26,39,31],[38,32,39,37],[40,38,41,43],[40,44,41,49],[40,50,41,55],[42,62,43,70],[40,56,41,61],[40,62,41,70],[38,38,39,43],[38,44,39,49],[38,50,39,55],[38,56,39,61],[38,62,39,70],[34,0,35,13],[34,14,35,19],[34,20,35,25],[34,26,35,31],[34,32,35,37],[34,38,35,43],[36,0,37,13],[36,14,37,19],[36,20,37,25],[36,26,37,31],[36,32,37,37],[36,38,37,43],[42,44,43,49],[42,50,43,55],[42,56,43,61],[34,44,35,49],[34,50,35,55],[34,56,35,61],[30,62,31,70],[32,0,33,13],[32,14,33,19],[32,20,33,25],[32,26,33,31],[32,32,33,37],[32,38,33,43],[32,44,33,49],[32,50,33,55],[32,56,33,61],[32,62,33,70],[30,0,31,13],[30,14,31,19],[30,20,31,25],[30,26,31,31],[30,32,31,37],[30,38,31,43],[30,44,31,49],[30,50,31,55],[30,56,31,61],[34,62,35,70],[26,62,27,70],[28,0,29,13],[28,14,29,19],[28,20,29,25],[28,26,29,31],[28,32,29,37],[28,38,29,43],[28,44,29,49],[28,50,29,55],[28,56,29,61],[28,62,29,70],[26,0,27,13],[26,14,27,19],[26,20,27,25],[26,26,27,31],[26,32,27,37],[26,38,27,43],[26,44,27,49],[26,50,27,55],[26,56,27,61],[22,62,23,70],[24,0,25,13],[24,14,25,19],[24,20,25,25],[24,26,25,31],[24,32,25,37],[24,38,25,43],[24,44,25,49],[24,50,25,55],[24,56,25,61],[24,62,25,70],[22,0,23,13],[22,14,23,19],[22,20,23,25],[22,26,23,31],[22,32,23,37],[22,38,23,43],[22,44,23,49],[22,50,23,55],[22,56,23,61],[18,62,19,70],[20,0,21,13],[20,14,21,19],[20,20,21,25],[20,26,21,31],[20,32,21,37],[20,38,21,43],[20,44,21,49],[20,50,21,55],[20,56,21,61],[20,62,21,70],[18,0,19,13],[18,14,19,19],[18,20,19,25],[18,26,19,31],[18,32,19,37],[18,38,19,43],[18,44,19,49],[18,50,19,55],[18,56,19,61],[14,62,15,70],[16,0,17,13],[16,14,17,19],[16,20,17,25],[16,26,17,31],[16,32,17,37],[16,38,17,43],[16,44,17,49],[16,50,17,55],[16,56,17,61],[16,62,17,70],[14,0,15,13],[14,14,15,19],[14,20,15,25],[14,26,15,31],[14,32,15,37],[14,38,15,43],[14,44,15,49],[14,50,15,55],[14,56,15,61],[10,62,11,70],[12,0,13,13],[12,14,13,19],[12,20,13,25],[12,26,13,31],[12,32,13,37],[12,38,13,43],[12,44,13,49],[12,50,13,55],[12,56,13,61],[12,62,13,70],[10,0,11,13],[10,14,11,19],[10,20,11,25],[10,26,11,31],[10,32,11,37],[10,38,11,43],[10,44,11,49],[10,50,11,55],[10,56,11,61],[5,44,7,49],[5,50,7,55],[5,56,7,61],[5,62,7,70],[8,0,9,13],[8,14,9,19],[8,20,9,25],[8,26,9,31],[8,32,9,37],[8,38,9,43],[8,44,9,49],[8,50,9,55],[8,56,9,61],[8,62,9,70],[2,0,2,13],[2,14,2,31],[3,1,3,13],[3,14,3,42],[5,0,7,13],[5,14,7,19],[5,20,7,25],[5,26,7,31],[5,32,7,37],[5,38,7,43]]}
["Please provide the following unit information for each building."]
[]
["Building Identification Number (BIN):"]
[null,"Address of Building:"]
[]
["Address & Unit Number (include city and zip code)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Type of Unit (LIHTC or Market Rate)",null,null,null,null,null,"Number of Bedrooms",null,null,null,null,null,"Unit Sq. Footage",null,null,null,null,null,"Current Tenant Income",null,null,null,null,null,"Monthly Rent Amount",null,null,null,null,null,"Rent AMI Level %",null,null,null,null,null,"Income AMI Level %",null,null,null,null,null,"Special Needs Unit?",null,null,null,null,null,"Annual Allocated Credit Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["footnotes: "]

{"sheet":"Set Aside & Comm Supp. (pg 12)","index":11,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[37,4,37,6],[38,4,38,6],[40,1,40,8],[37,1,37,3],[38,1,38,3],[34,1,34,3],[35,1,35,3],[33,1,33,3],[34,4,34,6],[35,4,35,6],[19,3,19,8],[20,3,20,7],[33,4,33,6],[0,2,0,8],[1,2,1,8],[23,3,23,8],[30,1,30,4],[36,1,36,3],[25,3,28,8],[3,3,6,8],[42,0,42,2],[42,3,43,8],[8,3,8,8],[9,3,9,8],[38,7,38,8],[33,7,33,8],[32,1,32,8],[34,7,34,8],[35,7,35,8],[36,7,36,8],[37,7,37,8],[36,4,36,6],[17,1,17,3]]}
[null,"10.","Election of the Minimum Set-Aside Requirement (this election is also made by the owner on IRS"]
[null,null,"Form 8609):  The Owner irrevocably elects one of the Minimum Set-Aside Requirements"]
[]
[null,null,null,"At least 20% of the rental residential units in this Development are rent-restricted and are to be occupied by individuals whose income is 50% or less of the area median gross income (if this election is chosen, all tax credit units must be rented to tenants at 50% area median income or below)"]
[]
[]
[]
[]
[null,null,null," At least 40% of the rental residential units in this Development are rent restricted and to be"]
[null,null,null," occupied by individuals whose income is 60% or less of the area median gross income."]
[]
[null,null,null," At least 40% of the rental residential units in this Development are rent restricted and to be"]
[null,null,null,"occupied by individuals whose income is 80% or less of the area median gross income. The"]
[null,null,null,"average income of the restricted units must be at or below 60% of the area median gross income."]
[]
[null,null,null," Deep Rent Skewing as defined in Section 42."]
[]
["F.","Tax Credit"]
[]
[null,"1.  ",null," This development will be subject to the 15 year Extended Use Agreement in addition to the"]
[null,null,null," mandatory 15 year Compliance Period (30 years)."]
[]
[null,"2.",null," This development will be subject to an additional                  (must be greater than 15 years) year"]
[null,null,null," Extended Use Agreement, in addition to the mandatory 15-year Compliance Period."]
[]
[null,"3.",null,"This development will be subject to the standard 15 year Compliance Period as part of a Lease Purchase Program (all units must be single-family detached structures) and will offer homeownership opportunities to qualified tenants after compliance period.  See IRS Revenue Ruling 95-48 and IHCDA’s Declaration of Extended Rental Housing Commitment."]
[]
[]
[]
[]
["G.","MBE/WBE Participation"]
[]
[null,"List of MBE/WBE Participants"]
[null,"MBE/WBE Business Name",null,null,"Entity Service \n(Professional Services/GC/Sub-contractors/Owner/Developer/Management Entity)",null,null,"% to Total Development Cost (NA if Owner/Developer/Management)"]
[]
[]
[]
[]
[]
[]
[null,"***If any of these participants have changed from initial application, please specify***"]
[]
["footnotes:"]

{"sheet":"Income and Expenses (pg 13 )","index":12,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,0,49,2],[49,3,50,10],[15,3,15,4],[13,5,13,9],[24,3,24,9],[1,1,1,3],[1,4,1,6],[1,7,1,10],[11,3,11,10],[10,1,10,7],[2,7,2,10],[3,7,3,10],[4,7,4,10],[5,2,5,9],[2,1,2,3],[3,1,3,3],[4,1,4,3],[2,4,2,6],[3,4,3,6],[4,4,4,6]]}
["H. ","Owner and Management Compliance Certification"]
[null,"Individual Name",null,null,"Owner or Management Agent",null,null,"Certification Completed? (Y/N)"]
[]
[]
[]
[null,null,"*Please refer to p.2 Checklist item h. and provide documentation accordingly"]
[]
["I.  ","Income and Expenses"]
[]
[null,"1.  Rental Assistance"]
[null,"  a.  Do or will any low-income units receive rental assistance?     ",null,null,null,null,null,null,"Yes","No"]
[null,"        ",null,"If yes, indicate type of rental assistance and attach copy of rental assistance contract (if appplicable):"]
[]
[null,null,null," Section 8 HAP",null,"      FmHA 515 Rental Assistance"]
[null,null,null,null,null,"      Other"]
[]
[null,"  b.  Number of units (by number of bedrooms) receiving assistance:"]
[null,null,null," (1) Bedroom",null," (2) Bedrooms"]
[]
[null,null,null," (3) Bedrooms",null," (4) Bedrooms"]
[]
[]
[null,"  c.  Number of years rental assistance contract    "]
[]
[null,null,null," Expiration date of contract"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["footnotes:"]

{"sheet":"Utilities and Rents (pg 14)","index":13,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,0,46,6],[31,0,31,6],[32,0,32,6],[33,0,33,6],[30,0,30,6],[38,0,38,6],[39,0,39,6],[40,0,40,6],[41,0,41,6],[42,0,42,6],[43,0,43,6],[44,0,44,6],[45,0,45,6],[29,0,29,6],[34,0,34,6],[35,0,35,6],[36,0,36,6],[37,0,37,6],[15,1,15,6],[17,6,17,7],[18,6,18,10],[20,1,20,11],[28,0,28,6],[27,0,27,6],[22,1,22,11],[23,1,23,10],[26,0,26,6],[25,0,25,6],[7,0,7,1],[12,0,12,1],[13,0,13,1],[13,2,13,6],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[6,0,6,1],[0,1,0,3],[3,7,3,11],[5,0,5,1],[3,2,4,2],[3,0,4,1],[3,3,4,6]]}
[null,"2.  Utilities and Rents"]
[null,"     a.  Monthly Utility Allowance Calculations - Entire Section Must Be Completed"]
[]
["Utilities",null,"Type of Utility (Gas, Electric, Oil, etc.)","Utilities Paid by:",null,null,null,"Enter Allowance Paid by Tenant ONLY"]
[null,null,null,null,null,null,null,"0 Bdrm","1 Bdrm","2 Bdrm","3 Bdrm","4 Bdrm"]
["Heating",null,null,null," Owner",null," Tenant"]
["Air Conditioning",null,null,null," Owner",null," Tenant"]
["Cooking",null,null,null," Owner",null," Tenant"]
["Lighting",null,null,null," Owner",null," Tenant"]
["Hot Water",null,null,null," Owner",null," Tenant"]
["Water ",null,null,null," Owner",null," Tenant"]
["Sewer",null,null,null," Owner",null," Tenant"]
["Trash",null,null,null," Owner",null," Tenant"]
[null,null,"Total Utility Allowance for Costs Paid by Tenant",null,null,null,null,{"$f":"SUM(H6:H13)","v":0},{"$f":"SUM(I6:I13)","v":0},{"$f":"SUM(J6:J13)","v":0},{"$f":"SUM(K6:K13)","v":0},{"$f":"SUM(L6:L13)","v":0}]
[]
[null,"     b.  Source of Utility Allowance Calculation"]
[]
[null,null,null,null," HUD",null," FmHA  515"]
[null,null,null,null," PHA",null," Utility Company (Provide letter from utility company)"]
[null,"     "]
[null,"     NOTE:  IRS regulations provide further guidance on how utility allowances must be determined."]
[]
[null,"     c.  List below the applicable rental housing tax credit monthly rent limits (based on the number of"]
[null,"          bedrooms) less the applicable utility allowance calculated in subpart 2.a. above:"]
[]
[null,null,null,null,null,null,null,"0 BR","1 BR","2 BR","3 BR","4 BR"]
["Maximum Allowable Rent for Tenants at 20% AMI"]
["Minus Utility Allowance Paid by Tenant",null,null,null,null,null,null,{"$f":"H14","v":0},{"$f":"I14","v":0},0,0,0]
["Equals Maximum Allowable rent for your Development",null,null,null,null,null,null,{"$f":"H27-H28","v":0},{"$f":"I27-I28","v":0},{"$f":"J27-J28","v":0},{"$f":"K27-K28","v":0},{"$f":"L27-L28","v":0}]
["Maximum Allowable Rent for Tenants at 30% AMI"]
["Minus Utility Allowance Paid by Tenant",null,null,null,null,null,null,{"$f":"H14","v":0},{"$f":"I14","v":0},0,0,0]
["Equals Maximum Allowable rent for your Development",null,null,null,null,null,null,{"$f":"H30-H31","v":0},{"$f":"I30-I31","v":0},{"$f":"J30-J31","v":0},{"$f":"K30-K31","v":0},{"$f":"L30-L31","v":0}]
["Maximum Allowable Rent for Tenants at 40% AMI"]
["Minus Utility Allowance Paid by Tenant",null,null,null,null,null,null,{"$f":"H14","v":0},{"$f":"I14","v":0},0,0,0]
["Equals Maximum Allowable rent for your Development",null,null,null,null,null,null,{"$f":"H33-H34","v":0},{"$f":"I33-I34","v":0},{"$f":"J33-J34","v":0},{"$f":"K33-K34","v":0},{"$f":"L33-L34","v":0}]
["Maximum Allowable Rent for Tenants at 50% AMI"]
["Minus Utility Allowance Paid by Tenant",null,null,null,null,null,null,{"$f":"H14","v":0},{"$f":"I14","v":0},0,0,0]
["Equals Maximum Allowable rent for your Development",null,null,null,null,null,null,{"$f":"H36-H37","v":0},{"$f":"I36-I37","v":0},{"$f":"J36-J37","v":0},{"$f":"K36-K37","v":0},{"$f":"L36-L37","v":0}]
["Maximum Allowable Rent for Tenants at 60% AMI",null,null,null,null,null,null,null,0]
["Minus Utility Allowance Paid by Tenant",null,null,null,null,null,null,{"$f":"H14","v":0},{"$f":"I14","v":0},0,0,0]
["Equals Maximum Allowable rent for your Development",null,null,null,null,null,null,{"$f":"H39-H40","v":0},{"$f":"I39-I40","v":0},{"$f":"J39-J40","v":0},{"$f":"K39-K40","v":0},{"$f":"L39-L40","v":0}]
["Maximum Allowable Rent for Tenants at 70% AMI",null,null,null,null,null,null,null,0]
["Minus Utility Allowance Paid by Tenant",null,null,null,null,null,null,{"$f":"H14","v":0},{"$f":"I14","v":0},0,0,0]
["Equals Maximum Allowable rent for your Development",null,null,null,null,null,null,{"$f":"H42-H43","v":0},{"$f":"I42-I43","v":0},{"$f":"J42-J43","v":0},{"$f":"K42-K43","v":0},{"$f":"L42-L43","v":0}]
["Maximum Allowable Rent for Tenants at 80% AMI",null,null,null,null,null,null,null,0]
["Minus Utility Allowance Paid by Tenant",null,null,null,null,null,null,{"$f":"H14","v":0},{"$f":"I14","v":0},0,0,0]
["Equals Maximum Allowable rent for your Development",null,null,null,null,null,null,{"$f":"H45-H46","v":0},{"$f":"I45-I46","v":0},{"$f":"J45-J46","v":0},{"$f":"K45-K46","v":0},{"$f":"L45-L46","v":0}]

{"sheet":"Income and Expenses (pg 15)","index":14,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":false,"merged":[[31,5,31,7],[32,5,32,7],[45,1,47,9],[5,0,5,4],[13,0,13,4],[16,0,16,4],[17,0,17,4],[38,0,40,9],[25,3,25,4],[9,0,9,4],[12,0,12,4],[26,3,26,4],[26,5,26,9],[0,1,0,10],[1,1,1,10],[8,0,8,4],[4,0,4,4],[3,0,3,4]]}
[null,"d.  List below the maximum rent limits minus tenant-paid utilities for all HOME-Assisted, "]
[null,"     and/or HOME-Eligible, Non-assisted units in the development. "]
[null,"     "]
[null,null,null,null,null,"0 BR (SRO w/o kitchen ans/or bath)","0 BR (SRO with kitchen and bath)","1 BR","2 BR","3 BR","4 BR"]
["Maximum Allowable Rent for beneficiaries at"]
["30% or less of area median income"]
["MINUS Utility Allowance Paid by Tenants",null,null,null,null,{"$f":"'Utilities and Rents (pg 14)'!H14","v":0},{"$f":"'Utilities and Rents (pg 14)'!H14","v":0},{"$f":"'Utilities and Rents (pg 14)'!I14","v":0},{"$f":"'Utilities and Rents (pg 14)'!J14","v":0},{"$f":"'Utilities and Rents (pg 14)'!K14","v":0},{"$f":"'Utilities and Rents (pg 14)'!L14","v":0}]
["Maximum Allowable Rent for Your Development",null,null,null,null,{"$f":"F6-F7","v":0},0,{"$f":"H6-H7","v":0},0,0,0]
["Maximum Allowable Rent for beneficiaries at"]
["40% or less of area median income"]
["MINUS Utility Allowance Paid by Tenants",null,null,null,null,{"$f":"'Utilities and Rents (pg 14)'!H14","v":0},{"$f":"'Utilities and Rents (pg 14)'!H14","v":0},{"$f":"'Utilities and Rents (pg 14)'!I14","v":0},{"$f":"'Utilities and Rents (pg 14)'!J14","v":0},{"$f":"'Utilities and Rents (pg 14)'!K14","v":0},{"$f":"'Utilities and Rents (pg 14)'!L14","v":0}]
["Maximum Allowable Rent for Your Development",null,null,null,null,{"$f":"F10-F11","v":0},0,0,0,0,0]
["Maximum Allowable Rent for beneficiaries at"]
["50% or less of area median income"]
["MINUS Utility Allowance Paid by Tenants",null,null,null,null,{"$f":"'Utilities and Rents (pg 14)'!H14","v":0},{"$f":"'Utilities and Rents (pg 14)'!H14","v":0},{"$f":"'Utilities and Rents (pg 14)'!I14","v":0},{"$f":"'Utilities and Rents (pg 14)'!J14","v":0},{"$f":"'Utilities and Rents (pg 14)'!K14","v":0},{"$f":"'Utilities and Rents (pg 14)'!L14","v":0}]
["Maximum Allowable Rent for Your Development",null,null,null,null,{"$f":"F14-F15","v":0},0,0,0,0,0]
["Maximum Allowable Rent for beneficiaries at"]
["60% or less of area median income"]
["MINUS Utility Allowance Paid by Tenants",null,null,null,null,{"$f":"'Utilities and Rents (pg 14)'!H14","v":0},{"$f":"'Utilities and Rents (pg 14)'!H14","v":0},{"$f":"'Utilities and Rents (pg 14)'!I14","v":0},{"$f":"'Utilities and Rents (pg 14)'!J14","v":0},{"$f":"'Utilities and Rents (pg 14)'!K14","v":0},{"$f":"'Utilities and Rents (pg 14)'!L14","v":0}]
["Maximum Allowable Rent for Your Development",null,null,null,null,{"$f":"F18-F19","v":0},0,0,0,0,0]
[]
[]
[null,"e.  Estimated Rents and Rental Income"]
[" ","     1.  Total Number of Low-Income Units",null,null,null,null,"(20% Rent Maximum)"]
[]
["Dev Fund","HOME ","RHTC","Unit Type",null,"Number of Baths","Number of Units","Net Sq. Ft. of Unit","Monthly Rent per Unit","Total Monthly Rent Unit Type"]
["Yes/No","Yes/No","Yes/No","# of bedrooms"]
[null,null,null,null,"Bedrooms",null,null,null,null,{"$f":"I28*G28","v":0}]
[null,null,null,null,"Bedrooms",null,null,null,null,{"$f":"I29*G29","v":0}]
[null,null,null,null,"Bedrooms",null,null,null,null,0]
[]
[null,null,null,"Other Income Source"]
[null,null,null,"Other Income Source"]
[]
[null,null,null,"Total Monthly Income",null,null,null,null,null,{"$f":"SUM(J27:J33)","v":0}]
[]
[null,null,null,"Annual Income",null,null,null,null,null,{"$f":"J35*12","v":0}]
[]
["** Please specify what funding type is going into each unit. If there is HOME and RHTC in the unit, for example, then indicate \"Yes\" to both and \"No\" for Development Fund. If there is not HOME or Development Fund financing indicate \"No\" in the Development Fund and HOME columns and \"Yes\" in Tax Credit column.**"]
[]
[]
[]
[]
[]
[]
["footnotes:"]

{"sheet":"Income and Expenses (pg 16)","index":15,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[[18,3,18,4],[19,3,19,4],[19,5,19,9],[40,5,40,7],[41,5,41,7],[24,5,24,7],[25,5,25,7],[34,3,34,4],[35,3,35,4],[35,5,35,9],[2,3,2,4],[3,3,3,4],[3,5,3,9],[8,5,8,7],[9,5,9,7]]}
[null,"     2.  Total Number of Low-Income Units",null,null,null,null,"(30% Rent Maximum)"]
[]
["Dev Fund","HOME ","RHTC","Unit Type",null,"Number of Baths","Number of Units","Net Sq. Ft. of Unit","Monthly Rent per Unit","Total Monthly Rent Unit Type"]
["Yes/No","Yes/No","Yes/No","# of bedrooms"]
[null,null,null,null,"Bedrooms",null,null,null,null,{"$f":"I5*G5","v":0}]
[null,null,null,null,"Bedrooms",null,null,null,null,0]
[null,null,null,null,"Bedrooms",null,null,null,null,0]
[]
[null,null,null,"Other Income Source"]
[null,null,null,"Other Income Source"]
[]
[null,null,null,"Total Monthly Income",null,null,null,null,null,{"$f":"SUM(J4:J10)","v":0}]
[]
[null,null,null,"Annual Income",null,null,null,null,null,{"$f":"J12*12","v":0}]
[]
[]
[null,"     3.  Total Number of Low-Income Units",null,null,null,null,"(40% Rent Maximum)"]
[]
["Dev Fund","HOME ","RHTC","Unit Type",null,"Number of Baths","Number of Units","Net Sq. Ft. of Unit","Monthly Rent per Unit","Total Monthly Rent Unit Type"]
["Yes/No","Yes/No","Yes/No","# of bedrooms"]
[null,null,null,null,"Bedrooms",null,null,null,null,{"$f":"I21*G21","v":0}]
[null,null,null,null,"Bedrooms",null,null,null,null,0]
[null,null,null,null,"Bedrooms",null,null,null,null,0]
[]
[null,null,null,"Other Income Source"]
[null,null,null,"Other Income Source"]
[]
[null,null,null,"Total Monthly Income",null,null,null,null,null,{"$f":"SUM(J20:J26)","v":0}]
[]
[null,null,null,"Annual Income",null,null,null,null,null,{"$f":"J28*12","v":0}]
[]
[]
[null,"     4.  Total Number of Low-Income Units",null,null,null,null,"(50% Rent Maximum)"]
[]
["Dev Fund","HOME ","RHTC","Unit Type",null,"Number of Baths","Number of Units","Net Sq. Ft. of Unit","Monthly Rent per Unit","Total Monthly Rent Unit Type"]
["Yes/No","Yes/No","Yes/No","# of bedrooms"]
[null,null,null,null,"Bedrooms",null,null,null,null,{"$f":"I37*G37","v":0}]
[null,null,null,null,"Bedrooms",null,null,null,null,{"$f":"I38*G38","v":0}]
[null,null,null,null,"Bedrooms",null,null,null,null,0]
[]
[null,null,null,"Other Income Source"]
[null,null,null,"Other Income Source"]
[]
[null,null,null,"Total Monthly Income",null,null,null,null,null,{"$f":"SUM(J36:J42)","v":0}]
[]
[null,null,null,"Annual Income",null,null,null,null,null,{"$f":"J44*12","v":0}]

{"sheet":"Income and Expenses (pg 17)","index":16,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[[16,3,16,4],[17,3,17,4],[17,5,17,9],[37,5,37,7],[38,5,38,7],[22,5,22,7],[23,5,23,7],[31,3,31,4],[32,3,32,4],[32,5,32,9],[1,3,1,4],[2,3,2,4],[2,5,2,9],[7,5,7,7],[8,5,8,7]]}
[null,"     5.  Total Number of Low-Income Units",null,null,null,null,"(60% Rent Maximum)"]
["Dev Fund","HOME ","RHTC","Unit Type",null,"Number of Baths","Number of Units","Net Sq. Ft. of Unit","Monthly Rent per Unit","Total Monthly Rent Unit Type"]
["Yes/No","Yes/No","Yes/No","# of bedrooms"]
[null,null,null,null,"Bedrooms",null,null,null,null,{"$f":"I4*G4","v":0}]
[null,null,null,null,"Bedrooms",null,null,null,null,0]
[null,null,null,null,"Bedrooms",null,null,null,null,0]
[]
[null,null,null,"Other Income Source"]
[null,null,null,"Other Income Source"]
[]
[null,null,null,"Total Monthly Income",null,null,null,null,null,{"$f":"SUM(J3:J9)","v":0}]
[]
[null,null,null,"Annual Income",null,null,null,null,null,{"$f":"J11*12","v":0}]
[]
[]
[null,"     6.  Total Number of Low-Income Units",null,null,null,null,"(70% Rent Maximum)"]
["Dev Fund","HOME ","RHTC","Unit Type",null,"Number of Baths","Number of Units","Net Sq. Ft. of Unit","Monthly Rent per Unit","Total Monthly Rent Unit Type"]
["Yes/No","Yes/No","Yes/No","# of bedrooms"]
[null,null,null,null,"Bedrooms",null,null,null,null,{"$f":"I19*G19","v":0}]
[null,null,null,null,"Bedrooms",null,null,null,null,0]
[null,null,null,null,"Bedrooms",null,null,null,null,0]
[]
[null,null,null,"Other Income Source"]
[null,null,null,"Other Income Source"]
[]
[null,null,null,"Total Monthly Income",null,null,null,null,null,{"$f":"SUM(J18:J24)","v":0}]
[]
[null,null,null,"Annual Income",null,null,null,null,null,{"$f":"J26*12","v":0}]
[]
[]
[null,"     7.  Total Number of Low-Income Units",null,null,null,null,"(80% Rent Maximum)"]
["Dev Fund","HOME ","RHTC","Unit Type",null,"Number of Baths","Number of Units","Net Sq. Ft. of Unit","Monthly Rent per Unit","Total Monthly Rent Unit Type"]
["Yes/No","Yes/No","Yes/No","# of bedrooms"]
[null,null,null,null,"Bedrooms",null,null,null,null,{"$f":"I34*G34","v":0}]
[null,null,null,null,"Bedrooms",null,null,null,null,0]
[null,null,null,null,"Bedrooms",null,null,null,null,0]
[]
[null,null,null,"Other Income Source"]
[null,null,null,"Other Income Source"]
[]
[null,null,null,"Total Monthly Income",null,null,null,null,null,{"$f":"SUM(J33:J39)","v":0}]
[]
[null,null,null,"Annual Income",null,null,null,null,null,{"$f":"J41*12","v":0}]

{"sheet":"Income and Expenses (pg 18)","index":17,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,1,27,8],[2,2,2,3],[3,2,3,3],[3,4,3,8],[11,5,11,6],[12,5,12,6],[13,5,13,6]]}
["8.  Total Number of Market Rate Units ",null,null,null,0]
[]
["HOME","RHTC","Unit Type",null,"Number of Baths","Number of Units","Net Sq. Ft. of Unit","Monthly Rent per Unit","Total Monthly Rent Unit Type"]
["Yes/No","Yes/No","# of bedrooms"]
[null,null,null,"Bedrooms",null,null,null,null,{"$f":"H5*F5","v":0}]
[null,null,null,"Bedrooms",null,null,null,null,{"$f":"H6*F6","v":0}]
[null,null,null,"Bedrooms",null,null,null,null,{"$f":"H7*F7","v":0}]
[null,null,null,"Bedrooms",null,null,null,null,0]
[null,null,null,"Bedrooms",null,null,null,null,0]
[null,null,null,"Bedrooms",null,null,null,null,0]
[]
[null,null,"Other Income Source"]
[null,null,"Other Income Source"]
[null,null,"Other Income Source"]
[]
[null,null,"Total Monthly Income",null,null,null,null,null,{"$f":"SUM(I4:I14)","v":0}]
[]
[null,null,"Annual Income",null,null,null,null,null,{"$f":"I16*12","v":0}]
[]
[]
[]
[]
[]
[]
[]
["footnotes:"]

{"sheet":"Annual Expenses (pg 19)","index":18,"n_rows":67,"n_cols":12,"rows_kept":67,"cut":false,"hidden":false,"merged":[[23,0,23,2],[25,0,25,2],[37,0,37,2],[37,10,37,11],[29,0,29,3],[29,4,29,5],[29,7,29,8],[29,10,29,11],[31,0,31,3],[31,4,31,5],[31,10,31,11],[35,10,35,11],[27,4,27,5],[27,7,27,8],[27,10,27,11],[23,10,23,11],[60,8,60,9],[39,0,39,2],[39,4,39,5],[39,10,39,11],[2,2,2,5],[2,7,2,8],[7,2,7,5],[7,7,7,8],[8,2,8,5],[8,7,8,8],[25,10,25,11],[23,4,23,5],[25,4,25,5],[25,7,25,9],[35,0,35,3],[35,4,35,5],[64,0,64,10],[51,0,51,3],[51,4,51,5],[51,7,51,8],[51,10,51,11],[54,0,54,5],[54,6,54,8],[54,10,54,11],[56,0,56,4],[56,6,56,8],[56,10,56,11],[62,0,62,10],[58,0,58,4],[58,6,58,8],[58,10,58,11],[60,0,60,7],[48,0,48,3],[47,10,47,11],[49,10,49,11],[41,0,41,1],[41,4,41,5],[41,10,41,11],[43,0,43,2],[43,4,43,5],[43,10,43,11],[45,10,45,11],[45,0,45,3],[45,4,45,5],[47,0,47,3],[47,4,47,5],[49,7,49,9],[19,7,19,8],[19,0,19,1],[10,7,10,8],[13,2,13,4],[21,7,21,8],[19,4,19,5],[17,1,17,4],[21,0,21,2],[0,1,0,7],[9,2,9,5],[9,7,9,8],[15,1,15,9],[3,2,3,5],[4,2,4,5],[3,7,3,8],[11,2,11,4],[4,7,4,8],[5,7,5,8],[6,7,6,8],[5,2,5,5],[6,2,6,5],[11,7,11,8],[13,7,13,8],[10,2,10,4]]}
[null,"6.  Summary of Estimated Rents and Rental Income"]
[]
[null,null,"Annual Income (20% Rent Maximum)",null,null,null,null,{"$f":"'Income and Expenses (pg 15)'!J37","v":0}]
[null,null,"Annual Income (30% Rent Maximum)",null,null,null,null,{"$f":"'Income and Expenses (pg 16)'!J14","v":0}]
[null,null,"Annual Income (40% Rent Maximum)",null,null,null,null,{"$f":"'Income and Expenses (pg 16)'!J30","v":0}]
[null,null,"Annual Income (50% Rent Maximum)",null,null,null,null,{"$f":"'Income and Expenses (pg 16)'!J46","v":0}]
[null,null,"Annual Income (60% Rent Maximum)",null,null,null,null,{"$f":"'Income and Expenses (pg 17)'!J13","v":0}]
[null,null,"Annual Income (70% Rent Maximum)",null,null,null,null,{"$f":"'Income and Expenses (pg 17)'!J28","v":0}]
[null,null,"Annual Income (80% Rent Maximum)",null,null,null,null,{"$f":"'Income and Expenses (pg 17)'!J43","v":0}]
[null,null,"Annual Income (Market Rate Units)",null,null,null,null,{"$f":"'Income and Expenses (pg 18)'!I18","v":0}]
[null,null,"Potential Gross Income",null,null,null,null,{"$f":"SUM(H3:I10)","v":0}]
[null,null,"Less Vacancy Allowance",null,null,null,null,{"$f":"H11*F12","v":0}]
[]
[null,null,"Effective Gross Income",null,null,null,null,{"$f":"H11-Text1153","v":0}]
[]
[null,"Devfault % increase in income over the Compliance Period",null,null,null,null,null,null,null,null,0.02]
[]
["J.","Annual Expense Information"]
[]
["(Check one)",null,null,"  Housing","OR",null,null,"  Commercial"]
[]
["Administrative",null,null,null,null,null,null,"Operating"]
[]
["1.  Advertising",null,null,null,null,null,null,"1.  Elevator"]
[]
["2.  Management",null,null,null,null,null,null,"2.  Fuel (heating & hot water)"]
[]
["3.  Legal/Partnership",null,null,null,null,null,null,"3.  Electricity"]
[]
["4.  Accounting/Audit",null,null,null,null,null,null,"4.  Water/Sewer"]
[]
["5.  Compliance Mont.",null,null,null,null,null,null,"5.  Gas"]
[]
["6.  Office Expenses",null,null,null,null,null,null,"6.  Trash Removal"]
[]
["Total Administrative",null,null,null,{"$f":"SUM(E24:F34)","v":0},null,null,"7.  Payroll/Payroll Taxes"]
[]
["Maintenance",null,null,null,null,null,null,"8.  Insurance"]
[]
["1.  Decorating",null,null,null,null,null,null,"9.  Real Estate Taxes*"]
[]
["2.  Repairs",null,null,null,null,null,null,"10.  Other Tax"]
[]
["3.  Exterminating",null,null,null,null,null,null,"11.  Annual Replacement  Reserve"]
[]
["4.  Ground Expense",null,null,null,null,null,null,"12.  Internet Expense"]
[]
["5.  Other (specify)",null,null,null,null,null,null,"13.  Resident Services"]
[]
[null,null,null,null,null,null,null,"14.  Other (specify)"]
[]
["Total Maintenance",null,null,null,{"$f":"SUM(E40:F48)","v":0},null,null,"Total Operating",null,null,{"$f":"SUM(K24:L50)","v":0}]
[]
[]
["Total Annual Administrative Expenses:",null,null,null,null,null,{"$f":"E36","v":0},null,null,"  Per Unit",{"$f":"G55/'More Development Info (pg 6)'!K21","v":{"$error":"#DIV/0!"}}]
[]
["Total Annual Maintenance Expenses:",null,null,null,null,null,{"$f":"E52","v":0},null,null,"Per Unit",{"$f":"G57/'More Development Info (pg 6)'!K21","v":{"$error":"#DIV/0!"}}]
[]
["Total Annual Operating Expenses:",null,null,null,null,null,{"$f":"K52","v":0},null,null,"Per Unit",{"$f":"G59/'More Development Info (pg 6)'!K21","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL OPERATING EXPENSES (Administrative + Operating + Maintenance):",null,null,null,null,null,null,null,{"$f":"G55+G57+G59","v":0},null,"Per Unit",{"$f":"I61/'More Development Info (pg 6)'!K21","v":{"$error":"#DIV/0!"}}]
[]
["Default annual percentage increase in expenses for the next 15 years",null,null,null,null,null,null,null,null,null,null,0.03]
[]
["Default annual percentage increase for replacement reserves for  the next 15 years",null,null,null,null,null,null,null,null,null,null,0.03]
[]
["* List full tax liability for the property - do not reflect tax abatement."]

{"sheet":"Proforma (pg 20)","index":19,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[[26,4,27,4],[26,3,27,3],[52,1,52,5],[10,3,11,3],[10,4,11,4],[42,3,43,3],[10,5,11,5],[42,4,43,4],[42,5,43,5],[26,5,27,5],[10,7,11,7],[26,7,27,7],[10,6,11,6],[42,7,43,7],[42,6,43,6],[26,6,27,6]]}
["K.","Projections for Financial Feasibility"]
[null,"Check one:  ",null,"  Housing  "]
[null,null,null,"  Commercial"]
[]
[null,"15 Year Projections of Cash Flow",null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"1.  Potential Gross Income",null,{"$f":"'Annual Expenses (pg 19)'!H11","v":0},{"$f":"'Proforma (pg 20)'!Text921*(1+'Annual Expenses (pg 19)'!$K$16)","v":0},{"$f":"'Proforma (pg 20)'!Text922*(1+'Annual Expenses (pg 19)'!$K$16)","v":0},{"$f":"'Proforma (pg 20)'!Text923*(1+'Annual Expenses (pg 19)'!$K$16)","v":0},{"$f":"'Proforma (pg 20)'!Text924*(1+'Annual Expenses (pg 19)'!$K$16)","v":0}]
[null,"2.  Less Vacancy Loss",null,{"$f":"-Text921*'Annual Expenses (pg 19)'!$F$12","v":0},{"$f":"-Text922*'Annual Expenses (pg 19)'!$F$12","v":0},{"$f":"-Text923*'Annual Expenses (pg 19)'!$F$12","v":0},{"$f":"-Text924*'Annual Expenses (pg 19)'!$F$12","v":0},{"$f":"-Text925*'Annual Expenses (pg 19)'!$F$12","v":0}]
[null,"3.  Effective Gross Income (1-2)",null,{"$f":"SUM(D6:D7)","v":0},{"$f":"SUM(E6:E7)","v":0},{"$f":"SUM(F6:F7)","v":0},{"$f":"SUM(G6:G7)","v":0},{"$f":"SUM(H6:H7)","v":0}]
[null,"4.  Less Operating Expenses",null,{"$f":"-('Annual Expenses (pg 19)'!I61-'Annual Expenses (pg 19)'!K46)","v":0},{"$f":"Text936*(1+'Annual Expenses (pg 19)'!$L$63)","v":0},{"$f":"Text937*(1+'Annual Expenses (pg 19)'!$L$63)","v":0},{"$f":"Text938*(1+'Annual Expenses (pg 19)'!$L$63)","v":0},{"$f":"Text939*(1+'Annual Expenses (pg 19)'!$L$63)","v":0}]
[null,"5.  Less Replacement Reserves",null,{"$f":"-'Annual Expenses (pg 19)'!$K$46","v":0},{"$f":"Text941*(1+'Annual Expenses (pg 19)'!L65)","v":0},{"$f":"Text942*(1+'Annual Expenses (pg 19)'!L65)","v":0},{"$f":"Text943*(1+'Annual Expenses (pg 19)'!L65)","v":0},{"$f":"Text944*(1+'Annual Expenses (pg 19)'!L65)","v":0}]
[null,"6.  Plus Tax Abatement"]
[null," (increase by expense rate, if applicable)"]
[null,"7.  Net Income (3-4-5+6)",null,{"$f":"SUM(D8:D12)","v":0},{"$f":"SUM(E8:E12)","v":0},{"$f":"SUM(F8:F12)","v":0},{"$f":"SUM(G8:G12)","v":0},{"$f":"SUM(H8:H12)","v":0}]
[null,"8.a.  Less Debt Service #1"]
[null,"8.b.  Less Debt Service #2"]
[null,"9.  Cash Flow (7-8)",null,{"$f":"Text951-Text956-Text961","v":0},{"$f":"Text952-Text957-Text962","v":0},{"$f":"Text953-Text958-Text963","v":0},{"$f":"Text954-Text959-Text964","v":0},{"$f":"Text955-Text960-Text965","v":0}]
[null,"10.  Debt Coverage Ratio (7/(8a +8b))",null,{"$f":"(Text951/(Text956+Text961))","v":{"$error":"#DIV/0!"}},{"$f":"(Text952/(Text957+Text962))","v":{"$error":"#DIV/0!"}},{"$f":"(Text953/(Text958+Text963))","v":{"$error":"#DIV/0!"}},{"$f":"(Text954/(Text959+Text964))","v":{"$error":"#DIV/0!"}},{"$f":"(Text955/(Text960+Text965))","v":{"$error":"#DIV/0!"}}]
[null,"11.  Deferred Developer Fee Payment"]
[null,"12.  Cash Flow after Def. Dev. Fee Pmt.",null,{"$f":"Text966-Text976","v":0},{"$f":"Text967-Text977","v":0},{"$f":"Text968-Text978","v":0},{"$f":"Text969-Text979","v":0},{"$f":"Text970-Text980","v":0}]
[null,"13.  Debt Coverage Ratio",null,{"$f":"Text951/(Text956+Text961+Text976)","v":{"$error":"#DIV/0!"}},{"$f":"Text952/(Text957+Text962+Text977)","v":{"$error":"#DIV/0!"}},{"$f":"Text953/(Text958+Text963+Text978)","v":{"$error":"#DIV/0!"}},{"$f":"Text954/(Text959+Text964+Text979)","v":{"$error":"#DIV/0!"}},{"$f":"Text955/(Text960+Text965+Text980)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Year 6","Year 7","Year 8","Year 9","Year 10"]
[null,"1.  Potential Gross Income",null,{"$f":"'Proforma (pg 20)'!Text925*(1+'Annual Expenses (pg 19)'!$K$16)","v":0},{"$f":"D22*(1+'Annual Expenses (pg 19)'!$K$16)","v":0},{"$f":"E22*(1+'Annual Expenses (pg 19)'!$K$16)","v":0},{"$f":"F22*(1+'Annual Expenses (pg 19)'!$K$16)","v":0},{"$f":"G22*(1+'Annual Expenses (pg 19)'!$K$16)","v":0}]
[null,"2.  Less Vacancy Loss",null,{"$f":"-D22*'Annual Expenses (pg 19)'!$F$12","v":0},{"$f":"-Text992*'Annual Expenses (pg 19)'!$F$12","v":0},{"$f":"-F22*'Annual Expenses (pg 19)'!$F$12","v":0},{"$f":"-G22*'Annual Expenses (pg 19)'!$F$12","v":0},{"$f":"-H22*'Annual Expenses (pg 19)'!$F$12","v":0}]
[null,"3.  Effective Gross Income (1-2)",null,{"$f":"SUM(D22:D23)","v":0},{"$f":"SUM(E22:E23)","v":0},{"$f":"SUM(F22:F23)","v":0},{"$f":"SUM(G22:G23)","v":0},{"$f":"SUM(H22:H23)","v":0}]
[null,"4.  Less Operating Expenses",null,{"$f":"Text940*(1+'Annual Expenses (pg 19)'!$L$63)","v":0},{"$f":"Text1006*(1+'Annual Expenses (pg 19)'!$L$63)","v":0},{"$f":"Text1007*(1+'Annual Expenses (pg 19)'!$L$63)","v":0},{"$f":"Text1008*(1+'Annual Expenses (pg 19)'!$L$63)","v":0},{"$f":"Text1009*(1+'Annual Expenses (pg 19)'!$L$63)","v":0}]
[null,"5.  Less Replacement Reserves",null,{"$f":"Text945*(1+'Annual Expenses (pg 19)'!L65)","v":0},{"$f":"Text1011*(1+'Annual Expenses (pg 19)'!L65)","v":0},{"$f":"Text1012*(1+'Annual Expenses (pg 19)'!L65)","v":0},{"$f":"Text1013*(1+'Annual Expenses (pg 19)'!L65)","v":0},{"$f":"Text1014*(1+'Annual Expenses (pg 19)'!L65)","v":0}]
[null,"6.  Plus Tax Abatement"]
[null," (increase by expense rate, if applicable)"]
[null,"7.  Net Income (3-4-5+6)",null,{"$f":"SUM(D24:D28)","v":0},{"$f":"SUM(E24:E28)","v":0},{"$f":"SUM(F24:F28)","v":0},{"$f":"SUM(G24:G28)","v":0},{"$f":"SUM(H24:H28)","v":0}]
[null,"8.a.  Less Debt Service #1"]
[null,"8.b.  Less Debt Service #2"]
[null,"9.  Cash Flow (7-8)",null,{"$f":"Text1020-(Text1025+Text1030)","v":0},{"$f":"Text1021-(Text1026+Text1031)","v":0},{"$f":"Text1022-(Text1027+Text1032)","v":0},{"$f":"Text1023-(Text1028+Text1033)","v":0},{"$f":"Text1024-(Text1029+Text1034)","v":0}]
[null,"10.  Debt Coverage Ratio (7/(8a+8b))",null,{"$f":"(Text1020/(Text1025+Text1030))","v":{"$error":"#DIV/0!"}},{"$f":"(Text1021/(Text1026+Text1031))","v":{"$error":"#DIV/0!"}},{"$f":"(Text1022/(Text1027+Text1032))","v":{"$error":"#DIV/0!"}},{"$f":"(Text1023/(Text1028+Text1033))","v":{"$error":"#DIV/0!"}},{"$f":"(Text1024/(Text1029+Text1034))","v":{"$error":"#DIV/0!"}}]
[null,"11.  Deferred Developer Fee Payment"]
[null,"12.  Cash Flow after Def. Dev. Fee Pmt.",null,{"$f":"Text1035-Text1045","v":0},{"$f":"Text1036-Text1046","v":0},{"$f":"Text1037-Text1047","v":0},{"$f":"Text1038-Text1048","v":0},{"$f":"Text1039-Text1049","v":0}]
[null,"13.  Debt Coverage Ratio",null,{"$f":"(Text1020/(Text1025+Text1030+Text1045))","v":{"$error":"#DIV/0!"}},{"$f":"(Text1021/(Text1026+Text1031+Text1046))","v":{"$error":"#DIV/0!"}},{"$f":"(Text1022/(Text1027+Text1032+Text1047))","v":{"$error":"#DIV/0!"}},{"$f":"(Text1023/(Text1028+Text1033+Text1048))","v":{"$error":"#DIV/0!"}},{"$f":"(Text1024/(Text1029+Text1034+Text1049))","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Year 11","Year 12","Year 13","Year 14","Year 15"]
[null,"1.  Potential Gross Income",null,{"$f":"Text995*(1+'Annual Expenses (pg 19)'!$K$16)","v":0},{"$f":"Text1060*(1+'Annual Expenses (pg 19)'!$K$16)","v":0},{"$f":"Text1061*(1+'Annual Expenses (pg 19)'!$K$16)","v":0},{"$f":"Text1062*(1+'Annual Expenses (pg 19)'!$K$16)","v":0},{"$f":"Text1063*(1+'Annual Expenses (pg 19)'!$K$16)","v":0}]
[null,"2.  Less Vacancy Loss",null,{"$f":"-Text1060*'Annual Expenses (pg 19)'!$F$12","v":0},{"$f":"-Text1061*'Annual Expenses (pg 19)'!$F$12","v":0},{"$f":"-Text1062*'Annual Expenses (pg 19)'!$F$12","v":0},{"$f":"-Text1063*'Annual Expenses (pg 19)'!$F$12","v":0},{"$f":"-Text1064*'Annual Expenses (pg 19)'!$F$12","v":0}]
[null,"3.  Effective Gross Income (1-2)",null,{"$f":"SUM(D38:D39)","v":0},{"$f":"SUM(E38:E39)","v":0},{"$f":"SUM(F38:F39)","v":0},{"$f":"SUM(G38:G39)","v":0},{"$f":"SUM(H38:H39)","v":0}]
[null,"4.  Less Operating Expenses",null,{"$f":"Text1010*(1+'Annual Expenses (pg 19)'!$L$63)","v":0},{"$f":"Text1076*(1+'Annual Expenses (pg 19)'!$L$63)","v":0},{"$f":"Text1077*(1+'Annual Expenses (pg 19)'!$L$63)","v":0},{"$f":"Text1078*(1+'Annual Expenses (pg 19)'!$L$63)","v":0},{"$f":"Text1079*(1+'Annual Expenses (pg 19)'!$L$63)","v":0}]
[null,"5.  Less Replacement Reserves",null,{"$f":"Text1015*(1+'Annual Expenses (pg 19)'!L65)","v":0},{"$f":"Text1080*(1+'Annual Expenses (pg 19)'!L65)","v":0},{"$f":"Text1081*(1+'Annual Expenses (pg 19)'!L65)","v":0},{"$f":"Text1082*(1+'Annual Expenses (pg 19)'!L65)","v":0},{"$f":"Text1083*(1+'Annual Expenses (pg 19)'!L65)","v":0}]
[null,"6.  Plus Tax Abatement"]
[null," (increase by expense rate, if applicable)"]
[null,"7.  Net Income (3-4-5+6)",null,{"$f":"SUM(D40:D44)","v":0},{"$f":"SUM(E40:E44)","v":0},{"$f":"SUM(F40:F44)","v":0},{"$f":"SUM(G40:G44)","v":0},{"$f":"SUM(H40:H44)","v":0}]
[null,"8.a.  Less Debt Service #1"]
[null,"8.b.  Less Debt Service #2"]
[null,"9.  Cash Flow (7-8)",null,{"$f":"D45-(Text1095+Text1100)","v":0},{"$f":"Text1091-(Text1096+Text1101)","v":0},{"$f":"Text1092-(Text1097+F47)","v":0},{"$f":"Text1093-(Text1098+Text1103)","v":0},{"$f":"Text1094-(Text1099+Text1104)","v":0}]
[null,"10.  Debt Coverage Ratio (7/(8a+8b))",null,{"$f":"(D45/(Text1095+Text1100))","v":{"$error":"#DIV/0!"}},{"$f":"(Text1091/(Text1096+Text1101))","v":{"$error":"#DIV/0!"}},{"$f":"(Text1092/(Text1097+F47))","v":{"$error":"#DIV/0!"}},{"$f":"(Text1093/(Text1098+Text1103))","v":{"$error":"#DIV/0!"}},{"$f":"(Text1094/(Text1099+Text1104))","v":{"$error":"#DIV/0!"}}]
[null,"11.  Deferred Developer Fee Payment"]
[null,"12.  Cash Flow after Def. Dev. Fee Pmt.",null,{"$f":"Text1105-Text1115","v":0},{"$f":"Text1106-Text1116","v":0},{"$f":"Text1107-Text1117","v":0},{"$f":"Text1108-Text1118","v":0},{"$f":"Text1109-Text1119","v":0}]
[null,"13.  Debt Coverage Ratio",null,{"$f":"(D45/(Text1095+Text1100+Text1115))","v":{"$error":"#DIV/0!"}},{"$f":"(Text1091/(Text1096+Text1101+Text1116))","v":{"$error":"#DIV/0!"}},{"$f":"(Text1092/(Text1097+F47+Text1117))","v":{"$error":"#DIV/0!"}},{"$f":"(Text1093/(Text1098+Text1103+Text1118))","v":{"$error":"#DIV/0!"}},{"$f":"(Text1094/(Text1099+Text1104+Text1119))","v":{"$error":"#DIV/0!"}}]
[null,"*The above Projections utilize the estimated annual percentage increases in income."]

{"sheet":"Source of Funds (pg 21)","index":20,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,0,35,2],[30,2,30,4],[30,7,30,8],[30,9,30,11],[31,2,31,4],[31,7,31,8],[32,1,32,4],[32,7,32,8],[32,9,32,11],[35,3,36,11],[27,1,27,4],[27,7,27,8],[27,9,27,11],[31,9,31,11],[28,2,28,4],[28,7,28,8],[28,9,28,11],[29,2,29,4],[29,7,29,8],[29,9,29,11],[25,1,25,10],[22,7,22,8],[22,1,22,4],[15,1,15,9],[17,1,17,4],[17,7,17,8],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[18,7,18,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[23,1,23,4],[23,7,23,8],[12,7,12,8],[8,9,8,11],[9,9,9,11],[10,9,10,11],[7,9,7,11],[11,7,11,8],[9,7,9,8],[7,1,7,4],[0,0,0,11],[2,1,2,10],[4,1,4,11],[14,1,14,11],[11,2,11,4],[7,7,7,8],[8,7,8,8],[12,1,12,4],[12,9,12,11],[5,1,5,9],[8,2,8,4],[11,9,11,11],[9,2,9,4],[10,2,10,4],[10,7,10,8]]}
["Commercial and Office Space:  IHCDA Rental Housing financing resources cannot be used to finance commercial space within a development.  Income generated and expenses incurred from this space, though, must be factored into IHCDA's underwriting for the development as a whole when reviewing the application.  If the development involves the development of commercial space the applicant will need to provide separate annual operating expense information and a separate 15-year proforma fro the commercial space.  Be sure to label which forms are for the housing and which ones are for the commercial space.  Also separate out all development costs associated with the commercial space on line M of the Development Costs chart."]
[]
["L. ","Sources of Funds/Developments (Include any IHCDA HOME requests)"]
[]
[null,"1.  Construction Financing.  List individually the sources of construction financing including any such loans"]
[null,"     financed through grant sources.  Please provide documentation in Tab G."]
[]
[null,"Source of Funds",null,null,null,"Date of Application","Date of Commitment","Amount of Funds",null,"Name and Telephone Numbers of Contact Person"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,"Total Amount of Funds",null,null,null,null,null,{"$f":"SUM(H9:I12)","v":0}]
[]
[null,"2.  Permanent Financing.  List individually the sources of permanent financing including any such loans"]
[null,"     financed through grant sources.  Please provide documentation in Tab G."]
[]
[null,"Source of Funds",null,null,null,"Date of Application","Date of Commitment","Amount of Funds",null,"Annual Debt Service Cost","Interest Rate of Loan","Amortization Period","Term of Loan"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,"Total Amount of Funds",null,null,null,null,null,{"$f":"SUM(H19:I22)","v":0}]
[null,"Deferred Developer Fee"]
[]
[null,"3.  Grants.  List all grants provided for the development.  Provide documentation in Tab G."]
[]
[null,"Source of Funds",null,null,null,"Date of Application","Date of Commitment","Amount of Funds",null,"Name and Telephone Numbers of Contact Person"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,"Total Amount of Funds",null,null,null,null,null,{"$f":"SUM(H29:I32)","v":0}]
[]
[]
["footnotes:"]

{"sheet":"Sources and Uses (pg 22)","index":21,"n_rows":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":false,"merged":[[22,1,22,2],[22,3,22,6],[22,8,22,11],[16,10,16,11],[18,4,18,11],[20,1,20,6],[20,7,20,11],[16,1,16,3],[16,4,16,7],[16,8,16,9],[5,1,5,3],[9,1,9,3],[9,4,9,5],[14,1,14,7],[11,7,11,8],[34,7,34,9],[36,2,36,4],[36,7,36,9],[24,1,24,4],[26,2,26,6],[26,7,26,9],[27,2,27,4],[27,7,27,9],[45,0,45,1],[45,2,46,11],[28,7,28,9],[29,2,29,4],[29,7,29,9],[28,2,28,4],[32,3,32,5],[32,7,32,9],[30,2,30,4],[30,7,30,9],[31,3,31,5],[31,7,31,9],[38,2,38,6],[41,2,41,3],[41,4,41,5],[34,2,34,4]]}
[null,"If the loan and any outstanding interest is not expected to be paid until the end of the Initial Compliance Period, "]
[null,"there must be reasonable expectation that the fair market value of the Development will be sufficient at "]
[null,"that time to pay the accrued interest and debt and that the net income of the Development will be sufficient "]
[null,"to sustain debt service. "]
[]
[null,"4.  Historic Tax Credits"]
[null,"     "]
[null,"     Have you applied for a Historic Tax Credit?",null,null,null,null,"           Yes","       No"]
[]
[null,"     If Yes, Please list amount "]
[]
[null,"     If Yes, indicate date Part I of application was duly filed: "]
[null,"    (Must be included with application. Please provide in Tab P.)"]
[]
[null,"5.  Other Sources of Funds (excluding any syndication proceeds)"]
[]
[null,"     a.  Source of Funds ",null,null,null,null,null,null,"Amount "]
[]
[null,"     b.  Timing of Funds "]
[]
[null,"     c.  Actual or Anticipated Name of Other Source "]
[]
[null,"     d.  Contact Person",null,null,null,null,null,"Phone "]
[]
[null,"6.  Sources and Uses Reconciliation"]
[]
[null,null,"Limited Partner Equity Investment* "]
[null,null,"General Partner Investment"]
[null,null,"Total Equity Investment",null,null,null,null,{"$f":"SUM(H27:J28)","v":0}]
[null,null,"Total Permanent Financing"]
[null,null,"Deferred Developer Fee"]
[null,null,"Other "]
[null,null,"Other "]
[null,null,"Other ","______________________"]
[null,null,"Total Source of Funds",null,null,null,null,{"$f":"SUM(H29:J34)","v":0}]
[]
[null,null,"Total Uses of Funds",null,null,null,null,{"$f":"+'Credit Determination (pg 28)'!H12:I12","v":0}]
[]
[null,null,"NOTE:  Sources and Uses MUST EQUAL"]
[]
[null,null,"*Load Fees included in Equity Investment?            ",null,null,null,null,"Yes","No"]
[null,null," Load Fees Amount"]
[]
[]
[]
["footnotes:"]

{"sheet":"Intermediary Info (pg 23)","index":22,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,0,46,1],[37,1,37,12],[38,1,38,12],[40,1,40,12],[41,1,41,12],[42,1,42,12],[43,1,43,12],[39,1,39,12],[46,2,53,11],[11,1,11,3],[11,4,11,10],[32,1,32,12],[35,1,35,12],[36,1,36,12],[20,4,20,5],[24,1,24,12],[25,1,25,12],[27,6,27,9],[0,1,0,5],[2,1,2,8],[17,1,17,12],[5,5,5,10],[22,7,22,12],[5,1,5,4],[3,1,3,5],[3,6,3,10],[15,1,15,11],[20,1,20,3],[19,1,19,12],[18,1,18,12],[7,1,7,2],[7,3,7,10],[13,1,13,2],[13,3,13,6]]}
[null,"7.  Intermediary Information"]
[]
[null,"     a.  Actual or Anticipated Name of Intermediary"]
[null,"          (e.g., Syndicator, act.)"]
[]
[null,"          Contact Person"]
[]
[null,"          Phone"]
[]
[null,"          Email","     ________________________________________________________________________"]
[]
[null,"          Street Address"]
[]
[null,"          City",null,null,null,null,null,"State",null,"Zip"]
[]
[null,"     b.  Investors:  Individuals and/or Corporate, or undetermined at this time"]
[]
[null,"     c.  As a percentage of the total credits to be received throughout the compliance period (assuming no"]
[null,"          recapture, should be the annual amount of credit times 10), how much are investors (excluding"]
[null,"          Owner's own equity) willing to invest toward development costs, excluding all syndication fees or"]
[null,"          charges?"]
[]
[null,null,null," check if estimated",null,null,null," check if based on commitment(s); if so please attach copies"]
[]
[null,"     d.  Has the intermediary (identified above) provided you with any documentation regarding the amount"]
[null,"          of syndication or other intermediary costs, fees, \"loads\" or other charges it will impose in"]
[null,"          with its services?"]
[null,null,null," Yes",null," No","If yes, please attach copies"]
[]
[]
[null,"8.  Tax-Exempt Bond Financing/Credit Enhancement"]
[]
[null,"     a.  If Multi-family Tax Exempt Bonds are requested, list percent such bonds represent of the aggregate"]
[null,"          basis of the building and land of the development:"]
[]
[null,"          If this percentage is 50% or more , a formal allocation of credits from IHCDA is not necessary (although"]
[null,"          the development must satisfy and comply with all requirements for an allocation under this Allocation"]
[null,"          Plan and Section 42 of the Code.  The Issuer of the bonds must determine the maximum amount of"]
[null,"          credits available to the development which, just as for developments which do need allocation, is "]
[null,"          limited to the amount of credits necessary to make the development financially feasible).  AT THE"]
[null,"          TIME OF SUBMITTING THIS APPLICATION, YOU MUST PROVIDE IHCDA WITH AN OPINION"]
[null,"          OF COUNSEL, SATISFACTORY TO IHCDA, THAT YOU ARE NOT REQUIRED TO OBTAIN AN"]
[null,"          ALLOCATION OF TAX CREDITS FROM IHCDA AND THAT THE DEVELOPMENT MEETS THE"]
[null,"          REQUIREMENTS OF THE ALLOCATION PLAN AND CODE."]
[]
[]
["footnotes:"]

{"sheet":"Bond Financing Info (pg 24)","index":23,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[22,1,22,8],[34,1,34,8],[23,1,23,10],[26,1,26,5],[31,1,31,11],[32,1,32,11],[4,2,4,4],[4,6,4,7],[6,1,6,3],[6,4,6,5],[0,3,0,10],[2,3,2,10],[4,9,4,10],[0,1,0,2],[2,1,2,2],[41,0,41,1],[41,2,50,10],[6,6,6,7],[6,8,6,10],[8,4,8,10],[14,3,14,5],[19,1,19,6],[21,1,21,6],[10,1,10,2],[10,3,10,10],[12,2,12,4],[12,6,12,7],[12,9,12,10],[14,6,14,7],[14,8,14,10],[16,1,16,11]]}
[null,"     b.  Name of Issuer"]
[]
[null,"          Street Address"]
[]
[null,"          City",null,null,null,"State",null,null,"Zip "]
[]
[null,"          Telephone Number",null,null,null,null,"            Email"]
[]
[null,"     c.  Name of Borrower"]
[]
[null,"          Street Address"]
[]
[null,"          City",null,null,null,"State",null,null,"Zip "]
[]
[null,"         Telephone Number",null,null,null,null,"         Email"]
[]
[null,"          If the Borrower is not the Owner, explain the relationship between the Borrower and Owner."]
[]
[null,"          If Development will be utilizing Multi-family Tax Exempt Bonds, you must provide a list"]
[null,"          of the entire development team in addition to above."]
[]
[null,"     d.  Does any of your financing have any credit enhancement?",null,null,null,null,null,null," Yes",null," No"]
[null,"          If yes, list which financing and describe the credit enhancement:"]
[]
[]
[null,"     e.  Is HUD approval for transfer of physical asset required?",null,null,null,null,null,null," Yes",null," No"]
[null,"          If yes, provide copy of TPA request to HUD."]
[]
[null,"     f.   Is Rural Development approval for transfer of physical asset required?"]
[null,"          If yes, has Rural Development been notified of your RHTC application?"]
[]
[null,"     g.   Is the Development a federally assisted low-income housing Development with at least 50% of"]
[null,"          its units in danger of being removed by a federal agency from the low-income housing market due"]
[null,"          to eligible prepayment, conversion, or financial difficulty?",null,null,null,null,null,null," Yes",null," No"]
[null,"          If yes, please provide documentation in Tab P of the application package."]
[]
[]
[]
[]
[]
[]
["footnotes:"]

{"sheet":"Itemized Costs (pg 25)","index":24,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[[46,1,46,3],[47,1,47,3],[48,1,48,3],[49,1,49,3],[50,1,50,3],[31,1,31,3],[29,1,29,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[50,5,51,5],[50,6,51,6],[6,4,7,4],[50,4,51,4],[35,1,35,3],[36,1,36,3],[35,6,36,6],[39,1,39,3],[38,1,38,3],[38,6,39,6],[38,4,39,4],[38,5,39,5],[35,5,36,5],[18,5,20,5],[29,6,30,6],[42,1,42,3],[24,1,24,3],[29,4,30,4],[2,1,2,5],[15,4,16,4],[15,5,16,5],[13,1,13,3],[9,1,9,3],[18,4,20,4],[19,1,19,3],[25,1,25,3],[21,1,21,3],[22,1,22,3],[29,5,30,5],[30,1,30,3],[41,1,41,3],[37,1,37,2],[0,1,0,4],[13,6,14,6],[10,4,11,4],[10,5,11,5],[10,6,11,6],[13,4,14,4],[13,5,14,5],[6,1,6,3],[7,1,7,3],[8,1,8,3],[10,1,10,3],[11,1,11,3],[26,1,26,3],[23,1,23,3],[53,0,53,3],[4,4,4,6],[4,0,5,3],[20,1,20,3],[14,1,14,3],[16,1,16,3],[15,1,15,3],[18,1,18,3],[51,1,51,3],[45,1,45,3],[43,1,43,3],[44,1,44,3],[35,4,36,4],[40,1,40,3],[15,6,16,6],[18,6,20,6]]}
["M.","Cost/Basis/Maximum Allowable Credit"]
[]
[null,"1.  Development Costs - List and Include Eligible Basis by Credit Type"]
[]
["ITEMIZED COST",null,null,null,"Eligible Basis by Credit Type"]
[null,null,null,null,"Project Costs","30%  PV \n[4% Credit]","70% PV \n[9% Credit]"]
["a.","To Purchase Land and Bldgs.",null,null,null," "]
[null,"1.  Land"]
[null,"2.  Demolition"]
[null,"3.  Existing Structures"]
[null,"4.  Other (specify)"]
[]
[]
["b.","For Site Work"]
[null,"1.  Site Work (not included in Construction Contract)"]
[null,"Other(s) (Specify)"]
[]
[]
["c.","For Rehab and New Construction"]
[null,"(Construction Contract Costs)"]
[null,"1.  Site Work"]
[null,"2.  New Building"]
[null,"3.  Rehabilitation"]
[null,"4.  Accessory Building"]
[null,"5.  General Requirements*"]
[null,"6.  Contractor Overhead*"]
[null,"7.  Contractor Profit*"]
[null,"8. Hard Cost"]
[]
["d.","For Architectural and Engineering Fees"]
[null,"1.  Architect Fee - Design"]
[null,"2.  Architect Fee - Supervision"]
[null,"3.  Consultant or Processing Agent"]
[null,"4.  Engineering Fees"]
[null,"5. High Performance Bldg Consultant"]
[null,"6.  Other Fees (specify)"]
[]
[]
["e.","Other Owner Costs"]
[null,"1.  Building Permits"]
[null,"2.  Tap Fees"]
[null,"3.  Soil Borings"]
[null,"4.  Real Estate Attorney"]
[null,"5. Devleoper Legal Fees"]
[null,"6.  Construction Loan - Legal"]
[null,"7.  Title and Recording"]
[null,"8.  Cost of Furniture"]
[null,"9.  Accounting"]
[null,"10.  Survyes"]
[null,"11.  Other (Specify)"]
[]
[]
[]
["SUBTOTAL -THIS PAGE - \nSPREADSHEET WILL CALCULATE",null,null,null,{"$f":"SUM(E7:E53)","v":0},{"$f":"SUM(F7:F53)","v":0},{"$f":"SUM(G7:G53)","v":0}]

{"sheet":"Itemized Costs (pg 26)","index":25,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[[50,1,50,5],[40,6,42,6],[37,4,38,4],[38,1,38,3],[19,5,20,5],[22,4,23,4],[44,4,45,4],[40,4,42,4],[40,5,42,5],[33,4,34,4],[3,6,4,6],[5,4,6,4],[5,5,6,5],[5,6,6,6],[31,1,31,3],[22,6,23,6],[19,6,20,6],[30,6,31,6],[30,4,31,4],[30,5,31,5],[3,4,4,4],[3,5,4,5],[11,4,12,4],[20,1,20,3],[22,5,23,5],[19,4,20,4]]}
["ITEMIZED COSTS",null,null,null,"Eligible Basis by Credit Type"]
[null,null,null,null,"Project Costs","30%  PV \n[4% Credit]","70% PV \n[9% Credit]"]
[null,"Subtotal from Previous Page",null,null,{"$f":"'Itemized Costs (pg 25)'!E54","v":0},{"$f":"'Itemized Costs (pg 25)'!F54","v":0},{"$f":"'Itemized Costs (pg 25)'!G54","v":0}]
["f.","For Interim Costs"]
[null,"1.  Construction Insurance"]
[null,"2.  Construction Interest & Other Capitalized"]
[null,"Operating Expenses"]
[null,"3.  Construction Loan Orig. Fee"]
[null,"4.  Construction Loan Credit Enhancement"]
[null,"5.  Taxes/Fixed Price Contract Guarantee"]
[null,"6. Construction Period Taxes"]
["g.","For Permanent Financing Fees & Expenses"]
[null,"1.  Bond Premium"]
[null,"2.  Credit Report"]
[null,"3.  Permanent Loan Orig. Fee"]
[null,"4.  Permanent Loan Credit Enhancement"]
[null,"5.  Cost of Iss/Underwriters Discount"]
[null,"6.  Title and Recording"]
[null,"7.  Counsel's Fee"]
[null,"8.  Other (Specify)"]
[]
[]
["h.","For Soft Costs"]
[null,"1.  Property Appraisal"]
[null,"2.  Market Study"]
[null,"3.  Environmental Report"]
[null,"4.  IHCDA Fees"]
[null,"5.  Consultant Fees"]
[null,"6.  Guarantee Fees"]
[null,"7. Soft Cost Contingency"]
[null,"8. Other (Specify)"]
[]
[]
["I.","For Syndication Costs"]
[null,"1.  Organizational (e.g. Partnership)"]
[null,"2.  Bridge Loan Fees and Exp"]
[null,"3.  Tax Opinion"]
[null,"4.  Other (specify)"]
[]
[]
["j.","Developer's Fee*"]
[null,null,"% Not-for Profit"]
[null,null,"% For-Profit"]
[]
["k.","For Development Reserves"]
[null,"1.  Rent-up Reserve"]
[null,"2.  Operating Reserve"]
[null,"3. Other Capitalized Reserves"]
["l.","Total Project Costs\n(spreadsheet will calculate)",null,null,{"$f":"SUM(E3:E48)","v":0},{"$f":"SUM(F3:F11)+SUM(F20:F33)+SUM(F40:F44)","v":0},{"$f":"SUM(G3:G11)+SUM(G20:G33)+SUM(G40:G44)","v":0}]
[]
[null,"* Denotes those items whose amounts are limited, pursuant to the Allocation Plan"]

{"sheet":"Itemized Cost (pg 27)","index":26,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[[38,1,38,3],[36,1,37,3],[41,0,42,6],[44,0,47,6],[30,5,31,5],[30,6,31,6],[25,5,26,5],[27,4,29,4],[30,4,31,4],[36,5,38,5],[36,6,38,6],[36,4,38,4],[19,6,24,6],[19,4,24,4],[17,6,18,6],[25,4,26,4],[33,1,34,3],[25,6,26,6],[27,5,29,5],[27,6,29,6],[25,1,25,3],[31,1,31,3],[32,4,35,4],[32,5,35,5],[32,6,35,6],[28,1,28,3],[32,1,32,3],[27,1,27,3],[17,5,18,5],[19,5,24,5],[21,1,22,3],[18,1,18,3],[24,1,24,3],[20,1,20,3],[19,1,19,3],[23,1,23,3],[0,0,1,3],[4,1,4,3],[30,1,30,3],[5,1,5,3],[15,1,15,3],[17,1,17,3],[8,1,8,3],[14,1,14,3],[9,1,10,3],[11,1,11,3],[26,1,26,3],[29,1,29,3],[50,0,50,1],[50,2,52,6],[0,4,0,6],[7,6,10,6],[12,1,13,3],[7,1,7,3],[6,1,6,3],[2,1,2,3],[3,1,3,3],[5,4,6,4],[12,6,13,6],[7,5,10,5],[9,4,10,4],[12,4,13,4],[12,5,13,5],[3,4,4,4]]}
["ITEMIZED COST",null,null,null,"Eligible Basis by Credit Type"]
[null,null,null,null,"Project Costs","30%  PV \n[4% Credit]","70% PV \n[9% Credit]"]
[null,"Subtotal from Previous Page",null,null,{"$f":"'Itemized Costs (pg 26)'!E49","v":0},{"$f":"'Itemized Costs (pg 26)'!F49","v":0},{"$f":"'Itemized Costs (pg 26)'!G49","v":0}]
["m.","Total Commercial Costs*"]
[]
["n.","Total Dev. Costs less Comm. Costs (l-m)",null,null,{"$f":"E3-E5","v":0}]
[]
["o.","Reductions in Eligible Basis"]
[null,"Subtract the following:"]
[null,"1.  Amount of Grant(s) used to finance Qualifying development costs"]
[]
[null,"2.  Amount of nonqualified recourse financing"]
[null,"3.  Costs of nonqualifying units of higher quality (or excess portion thereof)"]
[]
[null,"4.  Historic Tax Credits (residential portion)"]
[null,"5.  Subtotal (o.1 through 4 above)",null,null,null,{"$f":"SUM(F8:F15)","v":0},{"$f":"SUM(G8:G15)","v":0}]
[]
["p.","Eligible Basis (ll minus o.5)",null,null,null,{"$f":"F3-F16","v":0},{"$f":"G3-G16","v":0}]
[]
["q.","High Cost Area"]
[null,"Adjust to Eligible Basis"]
[null,"Please see 2022 QAP pg. 34 for eligibility criteria."]
[]
[null,"Adjustment Amount X 30%"]
[]
["r.","Adjusted Eligible Basis (p plus q)",null,null,null,{"$f":"F18+F20","v":0},{"$f":"G18+G20","v":0}]
[]
["s. ","Applicable Fraction"]
[null,"(% of development which is low income)"]
[null,"Based on Unit Mix or Sq Ft. (Type U or SF)"]
["t.","Total Qualified Basis (r multiplied by s)",null,null,null,{"$f":"F26*F28","v":0},{"$f":"G26*G28","v":0}]
[]
["u.","Applicable Percentage"]
[null,"(weighted average of the applicable percentage for each building and credit type)"]
[]
[]
["v.","Maximum Allowable Credit under IRS sec 42 (t multiplied by u)",null,null,null,{"$f":"F31*F33","v":0},{"$f":"G31*G33","v":0}]
[]
[]
["w.  ","Combined 30% and 70% PV Credit"]
[null,null,null,null,{"$f":"F37+G37","v":0}]
["* Commercial costs are defined as those costs that are not eligible basis and are attributed to non-residential areas of the Development (e.g. retail area of mixed-use development)."]
[]
[]
["Note:  The actual amount of credit for the Development is determined by IHCDA  If the Development is eligible for Historic Tax Credit, include a complete breakdown of the determination of eligible basis for the Historic Credit with the Application.  If the Development's basis has been adjusted because it is in a high cost or qualified census tract, the actual deduction for the Historic Cost items must be adjusted by multiplying the amount by 130%. This does not apply to Historic Tax Credits."]
[]
[]
[]
[]
[]
["footnotes:"]

{"sheet":"Credit Determination (pg 28)","index":27,"n_rows":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":false,"merged":[[27,1,28,5],[28,7,28,8],[22,1,22,4],[23,1,25,5],[15,1,15,4],[15,7,15,8],[17,1,18,5],[18,7,18,8],[20,1,20,3],[20,7,20,8],[25,7,25,8],[0,1,0,5],[2,0,8,9],[11,1,11,4],[11,7,11,8],[13,1,13,4],[13,7,13,8],[42,7,42,8],[44,7,44,8],[30,7,30,8],[38,7,38,8],[32,1,32,5],[32,7,32,8],[37,1,37,5],[40,7,40,8],[30,1,30,5],[34,7,34,8],[54,1,54,4],[55,1,55,6],[49,7,49,8],[56,2,56,4],[56,7,56,8],[47,7,47,8],[51,1,51,5],[52,7,52,8],[47,1,47,4],[52,1,52,5]]}
[null,"2.  Determination of Reservation Amount Needed"]
[]
["The following calculation of the amount of credits needed is substantially the same as the calculation which will be made by IHCDA to determine, as required by the IRS, the maximum amount of credits which may be reserved for the Development.  However, IHCDA at all times retains the right to substitute such information and assumptions as are determined by IHCDA to be reasonable for the information and assumptions provided herein as to costs (including development fees, profits, etc.) sources of funding, expected equity, ect.  Accordingly, if the development is selected by IHCDA for a reservation of credits, the amount of such reservation may differ significantly from the amount that is computed below."]
[]
[]
[]
[]
[]
[]
[]
[]
["a.","TOTAL DEVELOPMENT COSTS",null,null,null,null,"$",{"$f":"'Itemized Cost (pg 27)'!E3","v":0}]
[]
["b.","LESS SYNDICATION COSTS",null,null,null,null,"$",{"$f":"SUM('Itemized Costs (pg 26)'!E34:E39)","v":0}]
[]
["c.","TOTAL DEVELOPMENT COSTS (a - b)",null,null,null,null,"$",{"$f":"H12-H14","v":0}]
[]
["d.","LESS:  TOTAL SOURCES OF FUNDING EXCLUDING SYNDICATION PROCEEDS"]
[null,null,null,null,null,null,"$",{"$f":"'Sources and Uses (pg 22)'!H30:J30+'Sources and Uses (pg 22)'!H32:J32+'Sources and Uses (pg 22)'!H33:J33","v":0}]
[]
["e.","EQUITY GAP (c - d)",null,null,null,null,"$",{"$f":"H16-H19","v":0}]
[]
["f.","EQUITY PRICING PERCENTAGE"]
[null,"(Percentage of 10-year credit expected to be personally invested by you or raised as equity excluding syndication or similar costs to 3rd parties)"]
[]
[null,null,null,null,null,null,"$"]
[]
["g.","10-YEAR CREDIT AMOUNT NEEDED TO FUND THE EQUITY GAP (e/f)"]
[null,null,null,null,null,null,"$",{"$f":"H21/H26","v":{"$error":"#DIV/0!"}}]
[]
["h.","ANNUAL TAX CREDIT REQUIRED TO FUND EQUITY GAP (g/10)",null,null,null,null,"$",{"$f":"H29/10","v":{"$error":"#DIV/0!"}}]
[]
["i.","MAXIMUM ALLOWABLE CREDIT AMOUNT",null,null,null,null,"$",{"$f":"'Itemized Cost (pg 27)'!E41","v":0}]
[]
["j.","RESERVATION AMOUNT REQUESTED",null,null,null,null," $"]
[null,"(Amount must be no greater than the lesser of h. or i.)"]
[]
["k.","FINAL CREDIT AMOUNT"]
[null,"(Lesser of h or j for 9%; or Lessor of H or I for 4% Bond)",null,null,null,null,"$"]
[]
["l.","TOTAL EQUITY INVESTMENT (anticipated for intial app)",null,null,null,null,"$",{"$f":"'Sources and Uses (pg 22)'!H29:J29","v":0}]
[]
["m.","DEFERRED DEVELOPER FEE",null,null,null,null,"$",{"$f":"'Sources and Uses (pg 22)'!H31:J31","v":0}]
[]
["n.","FINANCIAL GAP",null,null,null,null,"$",{"$f":"H12-(H19+H41+H43)","v":0}]
[]
[null,"1.  CREDIT PER UNIT"]
[null,"     (j/Number of Units)",null,null,null,null,"$",{"$f":"H39/'More Development Info (pg 6)'!K21","v":{"$error":"#DIV/0!"}}]
[]
[null,"2.  MAX CREDIT/UNIT (QAP)",null,null,null,null,"$",{"$f":"H33/'More Development Info (pg 6)'!K21","v":{"$error":"#DIV/0!"}}]
[]
[null,"3.  CREDIT PER BEDROOM"]
[null,"     (j/Number of Bedrooms)",null,null,null,null,"$",{"$f":"H39/'More Development Info (pg 6)'!K22","v":{"$error":"#DIV/0!"}}]
[]
[null,"4.  COST PER UNIT"]
[null,"a - (Cost of Land + Commercial Costs + Historic Credits)"]
[null,null,"Total Number of Units",null,null,null,"$",{"$f":"(H12-('Itemized Costs (pg 25)'!E8+'Itemized Cost (pg 27)'!E5+'Itemized Cost (pg 27)'!G15))/'More Development Info (pg 6)'!K21","v":{"$error":"#DIV/0!"}}]

{"sheet":"Acknowledgement (pg 29)","index":28,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[[8,2,8,12],[0,0,0,5],[2,2,2,11],[4,2,4,11],[6,2,6,11],[38,3,38,12],[10,2,10,11],[12,2,12,11],[30,0,30,5],[32,3,32,12],[34,3,34,12],[36,3,36,12]]}
["The undersigned hereby acknowledges that :"]
[]
[null,"1.","This Application form, provided by IHCDA to applicants for funding, including the sections herein relative to basis, credit calculations and determinations of the amount of the credit necessary to make the development financially feasible, is provided only for the convenience of IHCDA in reviewing the reservation requests; completion hereof in no way guarantees eligibility for the credits or ensures that the amount of credits applied for has been computed in accordance with IRC requirements; any notations herein describing IRC requirements are offered only as general guides and not as legal advice;"]
[]
[null,"2.","The undersigned is responsible for ensuring that the proposed development will be comprised of qualified low-income buildings; that it will in all respects satisfy all applicable requirements of federal tax laws and any other requirements imposed upon it by the IHCDA; and that the IHCDA has no responsibility for ensuring that all or any funding allocated to the development may not be useable or may later be recaptured;"]
[]
[null,"3.","For purposes of reviewing this Application, IHCDA is entitled to rely upon the representations of the undersigned as to the inclusion of costs in eligible basis and as to all of the figures and calculations relating to the determinations of qualified basis for the development as a whole and for each building therein individually as well as the amounts and types of credit applicable thereto, and that the issuance of a reservation based on such representations in no way imposes any responsibility on the IHCDA for the accuracy of these representations or their compliance with IRC requirements;"]
[]
[null,"4.","The IHCDA offers no advice, opinion or guarantee that the Applicant or the proposed development will ultimately qualify for or receive low-income housing tax credits, Multi-family tax exempt Bonds, HOME funds or section 501 '(c)3 Bonds"]
[]
[null,"5.","Allocations of funding are not transferable without prior written notice and consent of the IHCDA;"]
[]
[null,"6.","The requirements for applying for funding and the terms of any reservation or allocation thereof are subject to change at any time by federal or state law, federal, state or IHCDA regulations, or other binding authority;"]
[]
[null,"7.  ","Applicant is submitting this Application on behalf of Owner, whether Owner has already been formed or is"]
[null,null,"a to-be-formed entity;"]
[]
[null,"8.","Applicant represents and warrants to IHCDA that it has all necessary authority to act for, obligate and execute"]
[null,null,"this Application on behalf of itself and Owner, and to engage in all acts necessary to consummate this"]
[null,null,"Application.  Applicant further represents and warrants to IHCDA that the signatories hereto have been duly"]
[null,null,"authorized and that this Application shall be the valid and binding act of the Applicant, enforceable according to "]
[null,null,"its terms;"]
[]
[null,"9.","In the event the Applicant is not the Owner, Applicant represents and warrants to IHCDA that it will take, and"]
[null,null,"not fail to take, any and all necessary actions to cause the Owner to ratify and confirm all repreesntations in and"]
[null,null,"comply with the terms and conditions of this Application;"]
[]
[null,"10.","Applicant represents and warrants to IHCDA that it will take any and all action necessary and not fail to cause the"]
[null,null,"Developer to ratify and confirm all representations in and comply with the terms and conditions of this Application."]
[]
["Further, the undersigned hereby certifies that:"]
[]
[null,null,"a)","All factual information provided herein or in connection herewith is true, correct and complete, and all estimates are reasonable; "]
[]
[null,null,"b)","It shall promptly notify the IHCDA of any corrections or changes to the information submitted to the IHCDA in connection with this Application upon becoming aware of same;"]
[]
[null,null,"c)","It is responsible for all calculations and figures used for the determination of the eligible basis and qualified basis for any and all buildings and other improvements, and it understands and agrees that the amount of funding to be reserved and allocated has been calculated pursuant to and in reliance upon the representations made herein; and"]
[]
[null,null,"d)","It will at all times indemnify, defend, and hold harmless IHCDA against all claims, losses, costs, damages, expenses and liabilities of any nature (including, without limitations attorney fees, and attorney fees to enforce the indemnity rights hereunder) directly or indirectly resulting from, arising out of, or relating to IHCDA's acceptance, consideration, approval or disapproval of this Application and the issuance or non-issuance of an allocation of funds in connection herewith;"]

{"sheet":"Acknowledgement Cont'd (pg 30)","index":29,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,3,2,15],[4,2,9,15],[11,2,15,15],[17,2,19,15],[0,2,2,2]]}
[null,null,"e)","It shall furnish the IHCDA with copies of any and all cost certifications made to any other governmental agency, including, but not limited to, cost certifications made to FmHA or FHA, at the time that such certifications are furnished to such other agency."]
[]
[]
[]
[null,"11.","Applicant hereby authorizes IHCDA and its successors, affiliates, agents and assigns to utilize in any manner and at anytime, any photograph, picture, or misrepresents in any other medium (collectively \"photographs\") of the property covered by this Application, without limitation, in any and all matters, publications, or endeavors, commercial or noncommercial, undertaken directly or indirectly by IHCDA at any time on or after the date of this Application without any limitation whatsoever.  Applicant understands that: (1) it is relinquishing any and all ownership rights in any such photographs; and (2) it is relinquishing any and all legal rights that it may now or hereafter have to, directly or indirectly, challenge, question or otherwise terminate the use of the photographs by IHCDA."]
[]
[]
[]
[]
[]
[]
[null,"12.","DISSEMINATION OF INFORMATION and AGREEMENT TO RELEASE AND INDEMNIFY.  The undersigned for and on behalf of itself, the Development, Owner and all participants in the Development, together with their respective officers, directors, shareholders, members, partners, agents, representatives, and affiliates (collectively, \"Applicant\") understands, acknowledges and agrees that this and any application for Rental Housing Tax Credits (\"Credits\") (including, but not limited to, all preliminary or final Applications, related amendments and information in support thereof and excepting personal financial information) are, and shall remain, available for dissemination and publication to the general public."]
[]
[]
[]
[]
[]
[null,null,"As additional consideration for IHCDA's review of its request for Credits, the Applicant does hereby release IHCDA and its directors, employees, attorneys, agents and representatives of and from any and all liability, expenses, costs and damage that applicant may, directly or indirectly, incur because of such dissemination or publication, and the Applicant hereby agrees to hold IHCDA harmless of and from any and all such liability, expense or damage."]

{"sheet":"Signature & Notary (pg 31)","index":30,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[[47,6,47,10],[37,1,37,3],[40,1,40,3],[34,1,34,5],[35,6,35,7],[34,6,34,7],[38,6,38,9],[38,1,38,3],[41,6,41,9],[41,1,41,3],[18,5,18,6],[18,7,18,12],[28,10,28,12],[29,2,29,3],[29,5,29,7],[26,1,26,2],[11,7,11,13],[12,7,12,13],[14,5,14,6],[14,7,14,12],[16,4,16,6],[16,7,16,12],[5,1,5,14],[6,1,6,2],[6,4,6,6],[6,8,6,10],[7,1,7,2],[7,4,7,6],[7,8,7,10]]}
[null,"AFFIRMATION OF APPLICANT.  Under penalty of perjury, I/we certify that the information, acknowledgements,"]
[null,"and representations in this application and its supporting documents are true and accurate to the best of my/our "]
[null,"knowledge.  The undersigned understands that providing false, misleading, or incomplete information herein "]
[null,"constitutes an act of fraud and may subject applicant to debarment and other legal recourse."]
[]
[null,"IN WITNESS WHEREOF, the undersigned, being duly authorized, has caused this document to be executed in its name on this"]
[null,null,null,"day of ",null,null,null,","]
[null,"day",null,null,"month",null,null,null,"year"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Legal Name of Applicant/Owner"]
[]
[null,null,null,null,null,"By:"]
[]
[null,null,null,null,"Printed Name:"]
[]
[null,null,null,null,null,"Its:"]
[]
[]
[]
[]
[]
[null,"STATE OF INDIANA",null,null,")"]
[null,null,null,null,") SS:"]
[null,"COUNTY OF ",null,null,null,")"]
[]
[null,"Before me, a Notary Public, in and for said County and State, personally appeared, "]
[null,"(the",null,null,"of ",null,null,null,"), the Applicant in the foregoing Application for Reservation"]
[null,"of",null,"(current year) funding, who acknowledged the execution of the foregoing instrument as his (her) "]
[null,"voluntary act and deed, and stated, to the best of his (her) knowledge and belief, that any and all representations"]
[null,"contained therein are true."]
[]
[null,"Witness my hand and Notarial Seal on this ",null,null,null,null,null,null,"day of ",null,",",null,"."]
[null,null,null,null,null,null,"day",null,null,"month",null,"year"]
[]
[null,"My Commission Expires:"]
[]
[null,null,null,null,null,null,"Notary Public"]
[null,"My County of Residence:"]
[]
[null,null,null,null,null,null,"Printed Name"]
[null,null,null,null,null,null,"(title)"]