{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["INSTRUCTIONS","1) Application","2) Repair Budget","3) Construction Costs","4) Sources & Uses","5) Units & Revenue","6) Operating Budget","7) Living Wage","8) 1099","Compliance","9) New Owner","Eligibility","Evaluation","Review","Rate"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":3,"defined_names":161,"comments":1,"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":"INSTRUCTIONS","index":0,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,2],[2,0,2,2],[7,0,7,2],[35,0,35,2],[23,6,23,7],[25,0,25,2],[29,0,29,2],[32,0,32,2],[34,0,34,2],[11,6,11,7],[12,0,12,2],[17,0,17,2],[20,0,20,2],[17,6,17,7]]}
["INSTRUCTIONS FOR COMPLETING THE TORNADO REPAIR & PRESERVATION APPLICATION & PROFORMA WORKSHEETS"]
[]
["General Instructions"]
[null,"A.","You will only be able to enter information into yellow input cells. All other cells are protected or are for AHC use."]
[null,"B.","Complete the following worksheets in the order corresponding to their numbering: 1) Application, 2) Repair Budget, 3) Construction Costs, 4) Sources & Uses, 5) Units & Revenue, 6) Operating Budget, 7) Living Wage, 8) 1099, and 9) New Owner."]
[null,"C.","All worksheets above must be completed.  Information on each worksheet is linked to other sheets."]
[null,"D.","To print this entire file, click on File>Print and select \"Print Entire Workbook.\""]
["1) Application"]
[null,"A.","This is the general application form. Fill all applicable yellow cells. Many sections will prompt you with drop-down menus. Some cells will initially be blank and will populate once you have completed other sheets in this workbook."]
[null,"B.","All Sources of Funds, including Insurance, FEMA Disaster Assistance, and other assistance to repair the units should be entered into the Application (Tab 1: B127 - B140). They should fill into the Sources & Uses Sheet (Tab 4)."]
[null,"C.","Include all documents & exhibits listed in the Application Checklist (Section V) with two printed hard copy applications (worksheets 1-9) to AHC before the deadline. Email this Excel Spreadsheet file to AHC's Housing Analyst at: ahcrecoveryrepairs@stlouis-mo.gov. One copy must be in a three-ring binder, with tabs corresponding to each number (on the checklist). One copy must be secured with a single binder clip and submitted without tabs, staples or paperclips. 3) Applicants must provide a complete copy of the application and all exhibits on a labeled USB Flash drive.  If you have questions about your proposal, funding requirements or procedures, please email Loretta Hiner at ahcrecoveryrepairs@stlouis-mo.gov before the deadline. The 1st funding round deadline is Friday, September 11, 2026 at 5 p.m. It is anticipated funding allocations for this funding round will be made by Friday, October 16, 2026.  The 2nd funding round deadline is Friday, October 2, 2026. It is anticipated that allocation decisions will be made by Friday, November 20, 2026."]
[null,"D.","Sign the Certifications Section VI. Submit the two (2) hard copies with original signatures to AHC."]
["2) Repair Budget"]
[null,"A.","The Repair Budget is 1 page.  Note: Construction Costs are entered on Tab 3, labeled Construction Costs."]
[null,"B.","The worksheet will calculate Total Costs (TDC)."]
[null,"C.","AHC requires verification by a title company of clear title prior to disbursing any funds.  You are advised to include the fee for the Title Report in the Repair Budget.  "]
[null,"D.","Grant funds will be disbursed through a disbursing agent (title company). You are advised to include the Disbursing Fee in the Repair Budget.  Disbursing Fees typically run .5% of the amount of funds to be disbursed."]
["3) Construction Costs"]
[null,"A.","Enter detailed construction costs."]
[null,"B.","After completing this Worksheet, review Repair Budget (Tab 2), to insure cost data transferred properly."]
["4) Summary Sources & Uses"]
[null,"A.","Enter the amount of your Grant Request in Cell E21."]
[null,"B.","All other Sources of Funds (Insurance, FEMA Disaster Assistance, and other assistance to repair the damaged units should be entered into the Application (Tab 1: B127 - B140). They should fill into the Sources & Uses Sheet (Tab 4)."]
[null,"C.","Check that Total Costs = Total Sources of Funds."]
[null,"D.","Enter Annual Debt Service in Cell B52."]
["5) Units & Revenue"]
[null,"A.","Unit: Enter Number of Units, Type of Units, Square Footage, and Rent. Include the Contract Rent (the rent charged to tenants or rent that a voucher will provide). The Square Footage in the far right column will calculate."]
[null,"B.","Other Income: Enter other sources of revenue you are reasonably confident the project will receive."]
[null,"C.","Annual Operating Subsidies: If the project will receive an operating subsidy, enter the source & amount."]
["6) Annual Operating Budget"]
[null,"A.","Input a vacancy rate (7% is the default).  You may modify this as appropriate."]
[null,"B.","Enter the expected stabilized operating expenses."]
["7) Living Wage Acknowledgement & Acceptance"]
[null,"A.","Complete this form.  If the applicant is a non-profit agency that previously received AHC funding and there have been no changes to the agency's: 1) non-profit status, 2) Articles of Incorporation and 3) By-laws, please sign the No Change Affidavit."]
["8) 1099"]
["9) New Ownership "]
[null,null,"Explain how the new ownership is consistent with the intent of this Tornado Repair & Preservation Grant program."]

{"sheet":"1) Application","index":1,"n_rows":301,"n_cols":23,"rows_kept":301,"cut":false,"hidden":false,"merged":[[27,19,27,20],[27,6,27,14],[22,18,22,19],[28,5,28,13],[28,16,28,20],[29,3,29,11],[29,12,29,13],[29,14,29,20],[30,2,30,9],[30,12,30,14],[30,16,30,19],[31,5,31,9],[31,13,31,15],[170,1,170,20],[154,13,154,15],[153,13,153,15],[160,1,160,7],[160,11,160,20],[160,9,160,10],[139,1,139,10],[137,13,137,15],[138,13,138,15],[139,13,139,15],[141,13,141,15],[140,13,140,15],[142,13,142,15],[137,1,137,10],[161,1,161,15],[148,13,148,15],[151,13,151,15],[149,13,149,15],[106,17,106,20],[128,9,128,10],[152,13,152,15],[132,9,132,10],[193,1,193,3],[193,4,193,9],[193,10,193,18],[196,1,196,9],[196,10,196,20],[197,16,197,20],[198,3,198,11],[198,12,198,13],[193,19,193,20],[198,14,198,20],[197,7,197,13],[191,1,191,3],[191,4,191,9],[191,10,191,18],[191,19,191,20],[192,1,192,3],[192,4,192,9],[192,10,192,18],[192,19,192,20],[190,19,190,20],[190,1,190,3],[190,4,190,9],[190,10,190,18],[184,16,184,17],[183,13,183,15],[188,1,188,3],[176,9,176,10],[180,13,180,15],[180,16,180,17],[178,16,178,17],[179,9,179,10],[181,13,181,15],[181,16,181,17],[182,13,182,15],[174,1,174,8],[175,1,175,8],[176,1,176,8],[177,1,177,8],[178,1,178,8],[179,1,179,8],[174,9,174,10],[174,13,174,15],[174,16,174,17],[175,9,175,10],[175,13,175,15],[175,16,175,17],[189,19,189,20],[177,13,177,15],[177,16,177,17],[178,9,178,10],[178,13,178,15],[179,13,179,15],[179,16,179,17],[163,1,163,20],[164,1,164,20],[173,13,173,15],[173,16,173,17],[183,16,183,17],[189,1,189,3],[189,4,189,9],[189,10,189,18],[182,16,182,17],[176,13,176,15],[176,16,176,17],[177,9,177,10],[184,13,184,15],[169,1,169,20],[188,4,188,9],[188,10,188,18],[188,19,188,20],[107,17,107,20],[108,17,108,20],[109,17,109,20],[110,17,110,20],[143,13,143,15],[110,1,110,10],[107,12,107,15],[150,13,150,15],[127,9,127,10],[130,9,130,10],[131,9,131,10],[133,19,133,20],[136,13,136,15],[136,1,136,10],[120,1,120,20],[117,1,117,12],[115,9,115,10],[118,9,118,20],[119,1,119,20],[213,2,213,17],[218,1,221,20],[211,12,211,13],[215,2,215,17],[213,18,213,19],[215,18,215,19],[209,10,209,20],[209,1,209,9],[210,16,210,20],[212,2,212,9],[210,5,210,13],[202,1,205,20],[199,2,199,9],[199,12,199,14],[199,16,199,19],[217,1,217,20],[284,2,284,20],[289,2,289,20],[282,1,282,10],[255,2,255,20],[260,1,260,12],[287,2,287,20],[286,2,286,20],[285,2,285,20],[283,2,283,20],[260,15,260,20],[259,1,259,20],[265,16,265,17],[281,3,281,10],[281,16,281,20],[256,2,256,20],[268,5,268,14],[267,5,267,14],[264,2,264,13],[265,2,265,4],[265,5,265,14],[264,14,264,20],[266,2,268,4],[265,18,265,20],[266,5,266,14],[297,10,300,11],[297,1,297,9],[293,1,293,9],[300,12,300,20],[299,12,299,20],[291,2,291,20],[288,2,288,20],[290,2,290,20],[298,1,298,9],[298,12,298,20],[300,1,300,9],[299,1,299,9],[297,12,297,20],[253,2,253,20],[263,2,263,4],[261,2,262,20],[249,2,249,20],[225,1,225,20],[252,2,252,20],[251,2,251,20],[260,13,260,14],[263,5,263,20],[242,2,242,20],[241,2,241,20],[248,0,248,20],[232,10,232,20],[238,1,238,20],[239,1,239,20],[240,1,240,20],[243,2,243,20],[250,2,250,20],[254,2,254,20],[246,1,246,20],[247,1,247,20],[237,1,237,20],[257,2,257,20],[35,5,35,20],[35,1,35,4],[36,1,36,4],[37,1,37,4],[7,16,7,20],[7,5,7,13],[244,2,244,20],[245,1,245,20],[234,1,234,20],[235,1,235,20],[236,1,236,20],[233,1,233,20],[226,1,231,20],[40,1,40,10],[40,13,40,20],[41,1,41,10],[41,13,41,20],[42,13,42,20],[108,1,108,10],[109,1,109,10],[37,14,37,15],[36,17,36,20],[138,1,138,10],[212,16,212,19],[36,14,36,16],[36,5,36,13],[37,19,37,20],[39,1,39,6],[42,1,42,10],[54,1,54,7],[54,9,54,10],[80,1,80,20],[76,7,76,8],[82,12,82,20],[83,12,83,20],[103,12,103,19],[57,12,57,19],[47,18,47,19],[51,1,51,8],[99,9,99,10],[100,9,100,10],[102,9,102,10],[103,9,103,10],[47,4,47,5],[47,14,47,15],[58,1,58,8],[64,1,64,2],[9,16,9,19],[10,5,10,9],[52,1,52,8],[52,9,52,10],[53,1,53,8],[53,9,53,10],[57,9,57,10],[56,9,56,10],[212,12,212,14],[211,14,211,20],[211,3,211,11],[55,1,55,8],[107,1,107,10],[65,1,65,2],[66,1,66,2],[67,1,67,2],[68,1,68,2],[12,18,12,19],[110,12,110,15],[60,6,60,12],[10,13,10,15],[97,9,97,10],[98,9,98,10],[16,1,16,20],[8,12,8,13],[8,3,8,11],[6,16,6,20],[9,2,9,9],[60,14,60,20],[6,4,6,12],[55,9,55,10],[59,1,59,8],[58,9,58,10],[8,14,8,20],[59,9,59,10],[43,1,43,10],[56,1,56,8],[47,10,47,11],[57,1,57,8],[47,6,47,7],[47,8,47,9],[47,12,47,13],[33,10,34,20],[37,16,37,18],[37,7,37,10],[9,12,9,14],[51,9,51,10],[13,18,13,19],[17,1,17,20],[111,12,111,15],[124,9,124,20],[125,9,125,10],[125,15,125,20],[126,9,126,10],[101,9,101,10],[69,1,69,2],[70,1,70,2],[71,1,71,2],[71,5,71,20],[43,13,43,20],[44,1,44,10],[47,2,47,3],[47,16,47,17],[108,12,108,15],[109,12,109,15],[117,14,117,19],[50,1,50,20],[114,9,114,10],[56,14,56,19],[79,14,79,20],[86,1,93,20],[81,1,81,20]]}
["TORNADO REPAIR & PRESERVATION GRANT"]
["AFFORDABLE HOUSING COMMISSION"]
[]
[]
[]
["I.","Owner/Applicant Information"]
[null,"Entity Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Federal I.D. #:"]
[null,"Contact Person:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone:"]
[null,"Address:",null,null,null,null,null,null,null,null,null,null,"Email:"]
[null,"City:",null,null,null,null,null,null,null,null,null,"State:",null,null,null,"Zip:"]
[null,"Legal Form:",null,null,null,null,null,null,null,null,"Date Entity Formed",null,null,null,null,null,"State of Organization"]
[]
[null,"Is owner/applicant a mission-driven nonprofit housing provider?"]
[null,"Is owner/applicant a certified Community Development Corporation?"]
[]
[null,"If owner/applicant is a nonprofit housing provider or certified CDC, describe organization mission:"]
[]
[]
[]
[null,"Ownership is Consistent with Ownership on May 16, 2025"]
[null,"Is the owner of the property (to be repaired) substantially the same ownership as it was on May 16, 2026? Ownership changes"]
[null,"not materially altering ownership or control include: transfers among family members, co-owners, trusts, estates, or other"]
[null,"similar circumstances."]
[]
[null,"If ownership has materially changed, complete Tab 9 (New Owner). Explain how the new ownership is consistent with this program."]
[]
[]
[null,"Owner May 16, 2025:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Federal I.D. #:"]
[null,"Contact Person:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone:"]
[null,"Address:",null,null,null,null,null,null,null,null,null,null,"Email:"]
[null,"City:",null,null,null,null,null,null,null,null,null,"State:",null,null,null,"Zip:"]
[null,"Legal Form:",null,null,null,null,null,null,null,null,"Date Entity Formed",null,null,null,null,null,"State of Organization"]
[]
[null,"General Information"]
[null,"Project Information"]
[null,"Repair Project Name:"]
[null,"Street Address:",null,null,null,null,null,null,null,null,null,null,null,null,"Neighborhood:"]
[null,"St. Louis, MO",null,null,null,null,"Zip:",null,null,null,null,null,null,"Ward:",null,null,"Census Tract:"]
[]
[null,"Property ID#:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"You Must Input # of Units in this Section"]
[null,"Total Number of Damaged Units",null,null,null,null,null,null,null,{"$f":"SUM(J53:K60)","v":0}]
[null,"Number of Market Units",null,null,null,null,null,null,null,null,null,"Funding not provided for Market Rate Units"]
[null,"Number of Units at 80%"]
[null,"Number of Units at 70%"]
[null,"Number of Units at 60%"]
[null,"Number of Units at 50%",null,null,null,null,null,null,null,null,null,null,null,null,"Number of LMI Units",null,null,null,null,null,{"$f":"J54+J55+J56+J57+J58+J59+J60","v":0}]
[null,"Number of Units at 40%",null,null,null,null,null,null,null,null,null,null,"Number of Damaged LMI Units"]
[null,"Number of Units at 30%"]
[null,"Number of Units at 20%"]
[null,"Housing Type"]
[]
[null,"Population Served"]
[null,"Describe the tenant population served:"]
[null,null,null,"Disabled"]
[null,null,null,"Elderly"]
[null,null,null,"Previously Homeless"]
[null,null,null,"Youth & Families"]
[null,null,null,"Veterans"]
[null,null,null,"Formerly incarcerated"]
[null,null,null,"LGBT"]
[null,null,null,"Other"]
[]
[null,"Income Restrictions"]
[null,"If the owner is not a tax-exempt organization, the property must hold proof of an active Land Use Restriction Agreement (LURA)"]
[null,"or, Agreement for Covenants & Restrictions that limit the rent and the income level of residents."]
[null,"Is owner Tax-Exempt?"]
[]
[null,"Does this property have an active or recently active LURA or Agreement for Covenants & Restrictions?"]
[null,"Describe the income and rent restrictions currently on the property:"]
[]
[]
[]
[null,"Name of Grantee (entity requiring the income restriction) "]
[]
[null,"Describe the damage and repairs and how you will ensure construction commences within 6 months of a contract."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Property Information"]
[]
[null,"Year Constructed:"]
[null,"Number of Residential Buildings:"]
[null,"Total Number of Rental Units:"]
[null,"Number of Affordable Rental Units:"]
[null,"Occupancy prior to the tornado:"]
[null,"Current Occupancy Rate:"]
[null,"Is the property currently habitable?",null,null,null,null,null,null,null,null,null,null,"Number of currently habitable units:",null,null,null,null,null,null,null,0]
[]
["II.","Financial Capacity"]
[null,"Mortgage Holder(s)",null,null,null,null,null,null,null,null,null,null,"Mortgage Balance",null,null,null,null,"Status",null,null,null,null,"Reasons Property was not insured"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insurance was unavailable or prohibitively expensive"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Property was underinsured"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coverage did not include tornado damage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other"]
[null,"Total Mortgages",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M108:P111)","v":0}]
[]
[null,"Insurance and other Assistance"]
[null,"Was property insured May 16, 2025?"]
[null,"Was insurance required by lender?"]
[null,"If No, state the reason the property was not insured.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Not having insurance is not a disqualification."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use Drop-Down Box to left"]
[null,"Explain why property was not insured:"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Insurance Company              Address                                   Phone"]
[null,"Current Insurance Company:"]
[null,"Has an insurance claim been filed?",null,null,null,null,null,null,null,null,null,null,"Claim Number:"]
[null,"Insurance Proceeds Received:"]
[null,"Insurance Proceeds Pending:"]
[null,"Insurance Deductible:"]
[]
[null,"Has FEMA assistance been received?"]
[null,"Amount of FEMA assistance received:"]
[null,"Assistance Received:",null,null,null,null,null,null,null,{"$f":"J127+J128+J132","v":0}]
[null,"Has assistance been received from any other federal, state, local, nonprofit, or private source?"]
[]
[null,"Other Assistance, only include funds for repairs",null,null,null,null,null,null,null,null,null,null,null,"Assistance Received"]
[null,"Source 4: "]
[null,"Source 5:"]
[null,"Source 6:"]
[]
[null,"Other Assistance Subtotal",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N137:P140)","v":0}]
[null,"Total Assistance Received",null,null,null,null,null,null,null,null,null,null,null,{"$f":"N141+J133","v":0}]
[null,"Owner Contributrion (Owner Equity):"]
[null,"Sources of Funds: Assistance + Owner Equity",null,null,null,null,null,null,null,null,null,null,null,{"$f":"N142+N143","v":0}]
[]
[]
[null,"Repair Costs, Available Sources & Funding Request"]
[]
[null,"Total Repair Cost",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2) Repair Budget'!I80","v":0},null,null,"Repair Budget = I80"]
[null,"Insurance Deductible",null,null,null,null,null,null,null,null,null,null,null,{"$f":"J129","v":0}]
[null,"Total Dev. Cost: Cost to Repair + Insurance Deductible",null,null,null,null,null,null,null,null,null,null,null,{"$f":"N149+N150","v":0}]
[null,"Sources: Assistance + Owner Equity (before Grant)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"N142+N143","v":0}]
[null,"Repair GAP (Cost to repair prior to Grant)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"N151-N152","v":0}]
[null,"Requested Grant",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'4) Sources & Uses'!E21","v":0}]
[null,"Gap after City Funded Grant",null,null,null,null,null,null,null,null,null,null,null,{"$f":"N153-N154","v":0}]
[]
["III.","Capacity, Track Record & Readiness to Proceed"]
[]
[null,"Access to financing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lender Commitment Letter"]
[null,"If there is an unfunded repair gap above and beyond the Owner's Contribution and a City Grant, does the applicant have:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lender Letter of Intent"]
[null,null,null,null,null,null,null,null,null,"If other:",null,null,null,null,null,null,null,null,null,null,null,null,"Relationship with a Bank"]
[null,"Describe how remaining repair costs will be funded if grant does not cover the total Gap:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other:"]
[]
[]
[]
[]
[]
[null,"Describe applicant's experience owning, managing and repairing affordable rental housing."]
[]
[]
[]
[]
[]
[null,"Repair Schedule",null,null,null,null,null,null,null,"Completed",null,null,null,"Month",null,null,"Year"]
[null,"Insurance Claim Filed"]
[null,"FEMA Application Submitted"]
[null,"Contractor Selected"]
[null,"Cost Estimates Obtained"]
[null,"Status of Permits"]
[null,"Financing Secured"]
[null,"Construction Start"]
[null,"Construction Complete"]
[null,"Unit Occupied"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Construction Schedule:",null,null,null,"months"]
[null,null,null,null,null,null,"Number of months after October 2026",null,null,null,null,null,null,null,null,null,"months"]
[]
[null,"Construction/Repair Team Information if known at time of application"]
[null,null,null,null,"Name",null,null,null,null,"Address",null,null,null,null,null,null,null,null,null,"Phone"]
[null,"Contractor:"]
[null,"Consultant:"]
[null,"Attorney:"]
[null,"Tax Accountant:"]
[null,"Architect:"]
[null,"Engineer:"]
[]
[null,"Construction/Repair Manager"]
[null,"Construction Management Company/Consultant"]
[null,"Construction/Repair Manager:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone:"]
[null,"Address:",null,null,null,null,null,null,null,null,null,null,"Email:"]
[null,"City:",null,null,null,null,null,null,null,null,null,"State:",null,null,null,"Zip:"]
[null,"Describe Construction Manager's experience scheduling repairs, inspecting work, submitting expenditures, "]
[null,"and managing construction projects."]
[]
[]
[]
[]
[]
[]
["IV.","Property Management"]
[null,"Name of management staff/company:"]
[null,"Property Manager:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone:"]
[null,"Address:",null,null,null,null,null,null,null,null,null,null,"Email:"]
[null,"City:",null,null,null,null,null,null,null,null,null,"State:",null,null,null,"Zip:"]
[null,null,"How many units is your staff or 3rd party mgt company currently managing?"]
[]
[null,null,"How many income-restricted units is your staff/mgt company currently managing?"]
[]
[null,"Staff/Manager's experience managing income-restricted rental units and performing & providing compliance documentation."]
[]
[]
[]
[]
[]
[]
[]
[null,"Omissions:  List all required documents that are not included in this application."]
[]
[]
[]
[]
[]
[]
["V.","Application Checklist",null,null,null,null,null,null,null,null,{"$f":"project","v":0}]
[1,"Include all documents & exhibits listed in the Application Checklist (Section V) with two printed hard copy applications (worksheets 1-9) to AHC before the deadline. One copy must be in a three-ring binder, with tabs corresponding to each number (on the checklist).  One copy must be secured with a single binder clip and submitted without tabs, staples or paperclips.  Applicants must provide a complete copy of the application and all exhibits on a labeled USB Flash drive, and, all applicants must email the Excel spreadsheet file to Loretta Hiner at: ahcrecoveryrepairs@stlouis-mo.gov."]
[2,"Locator Map - indicating the location of the proposed repair project."]
[3,"Completed City of St. Louis Tornado Repair & Preservation Grant Application.  All omissions must be stated in Cell B227 of the application.  The Certifications Section VI. Must Be Signed."]
[4,"A copy of all assistance received to repair units damaged by the May 16, 2025 tornado, or to be received.  Includes Insurance Payout if it exists, FEMA assistance, etc…"]
[5,"Proof of non-duplication of benefits."]
[6,"Applicant's Certificate of Corporate Good Standing, dated within the last 6 months."]
[7,"City of St. Louis Business License, dated within the last 12 months."]
[8,"Owner/Applicant"]
[null,"a.","Articles of Incorporation, if applicable"]
[null,"b.","By-Laws, if applicable"]
[null,"c.","Certificate of Incorporation, if applicable"]
[null,"d.","IRS Non-Profit Determination Letter 501(C)(3) federal Tax Exemption Letter, if applicable"]
[9,"Evidence of Proper Zoning."]
[10,"Active Land Use Restriction Agreement if Owner/Applicant is not Tax-Exempt"]
[11,"Documented tornado related damage with date-of-loss evidence"]
["Tornado Repair & Preservation Grant Application Worksheets (tabs)"]
[null,1,"AHC Application"]
[null,2,"Repair Budget"]
[null,3,"Construction Costs"]
[null,4,"Sources & Uses"]
[null,5,"Units & Revenue"]
[null,6,"Operating Budget"]
[null,7,"Living Wage"]
[null,8,1099]
[null,9,"New Owner Tab, if owner is materially different than on May 16, 2025."]
["VI.","Certification"]
[null,"The undersigned applicant(s) hereby each certify that, to the best of my/our knowledge, all of the information in this application and all supporting documentation is correct, complete and accurate.                       "]
[null,"I certify all units will be made Lead Safe"]
[null,null,"All rehabilitation projects must comply with the City's Lead Safe requirements and receive a Lead Safe Clearance performed by a State Licensed Lead Inspector at the project's conclusion."]
[]
[null,null,"I certify that ",null,null,{"$f":"+project","v":0}]
[null,null,"will comply with the City's Lead Safe Requirements."]
[null,null,"Signed:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,null,null,null,null,"Owner Signature"]
[]
[null,null,null,null,null,"Owner Print Name"]
[]
[null,"All recipients of Funds must agree to obtain adequate insurance throughout the term of the Land Use Restriction"]
[null,"Agreement (LURA).  The Affordable Housing Commission is to be listed as an additional insured."]
[null,"All recipients of Funds must agree to execute a new Land Use Restriction Agreement (LURA)."]
[null,"The new Land Use Restriction Agreement will remain in effect for six (6) years from the date of project completion."]
[null,"During the term of the Land Use Restriction Agreement (LURA), the applicant agrees to annually submit income"]
[null,"compliance reports and insurance certifications with the Affordable Housing Commission listed as an additional insured."]
[null,"After all obligations are met and upon successful completion of the six-year affordability period, the grant shall be forgiven."]
[null,"If the Land Use Restriction Agreement (LURA) is breached, the full award amount must be repaid."]
[null,"Applicant understands and agrees to these terms:"]
[]
[null,"Signed:"]
[null,null,null,"Applicant",null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[null,"I/We further certify that:"]
[null,"1.","The costs listed in the application are reasonable, sufficient, and necessary to complete the repairs to full habitability."]
[null,"2.","I agree to hold harmless and indemnify the Affordable Housing Commission and the individual directors, employees, members, officers, and agents of AHC in the event that the owner or anyone acting on the owner's behalf, at the owner's request or by and through the owner incurs any loss in conjunction with the repair project."]
[null,"3.","The owner will provide any funds necessary to complete the repairs over and above those shown in the Sources of Funds form as available to complete the project and confirm it has such funds available to pay such costs."]
[null,"4.","The owner agrees not to take any profit from the project assistance applied for in this application."]
[null,"5.","But for the project assistance being applied for in this application, the repairs would not be made."]
[null,"6.","I understand and agree that my application for funds, all attachments thereto, and all correspondence relating to my application are subject to a disclosure request, and I expressly consent to such disclosure.  I further understand that any and all correspondence to me from AHC or other AHC-generated documents relating to my application are subject to a request for disclosure and I expressly consent to such disclosure.  I agree to hold harmless AHC and the individual directors, employees, members, officers, and agents of AHC against all losses, costs, damages, expenses, and liability of whatsoever nature or kind (including, but not limited to, attorney's fees, litigation, and court costs) directly or indirectly resulting from or arising out of the release of all information pertaining to my application pursuant to a disclosure request."]
[null,"7.","I understand that any misrepresentations in this application or supporting documentation may result in a withdrawal of grant funds and my (and related parties) being barred from future program participation."]
[null,"8.","All tornado assistance and insurance has been disclosed and revealed. There is no overlap of funds with prior City tornado funding for the same units or scope, and the applicant attests there is no duplication of benefits."]
[null,"9.","All information provided in the application and all documents submitted are true, correct, and complete, to the best of my knowledge."]
["Applicant Signatures:"]
[]
[null,"Printed Name",null,null,null,null,null,null,null,null,null,null,"Printed Name"]
[]
[null,"Signature",null,null,null,null,null,null,null,null,null,null,"Signature"]
[]
[null,"Title",null,null,null,null,null,null,null,null,null,null,"Title"]
[]
[null,"Date",null,null,null,null,null,null,null,null,null,null,"Date"]

{"sheet":"2) Repair Budget","index":2,"n_rows":80,"n_cols":17,"rows_kept":80,"cut":false,"hidden":false,"merged":[[79,8,79,9],[2,7,2,10],[44,7,44,10],[74,8,74,9],[75,8,75,9],[76,8,76,9],[77,8,77,9],[78,8,78,9],[69,8,69,9],[64,8,64,9],[65,8,65,9],[66,8,66,9],[67,8,67,9],[70,8,70,9],[71,8,71,9],[72,8,72,9],[73,8,73,9],[68,8,68,9],[58,8,58,9],[60,8,60,9],[63,8,63,9],[0,0,0,16],[1,0,1,16],[2,2,2,3],[3,7,3,10],[5,8,5,9],[4,7,4,10],[6,8,6,9],[51,1,51,3],[51,4,51,6],[29,8,29,9],[30,8,30,9],[31,8,31,9],[32,8,32,9],[27,8,27,9],[28,8,28,9],[38,8,38,9],[39,8,39,9],[40,8,40,9],[39,1,39,3],[25,8,25,9],[9,8,9,9],[19,8,19,9],[76,1,76,3],[76,4,76,6],[74,1,74,3],[74,4,74,6],[75,1,75,3],[75,4,75,6],[67,1,67,3],[67,4,67,6],[68,1,68,3],[68,4,68,6],[66,1,66,3],[66,4,66,6],[15,8,15,9],[33,8,33,9],[14,8,14,9],[16,6,16,11],[17,8,17,9],[18,8,18,9],[26,8,26,9],[20,8,20,9],[23,8,23,9],[24,8,24,9],[8,8,8,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[57,8,57,9],[65,1,65,3],[65,4,65,6],[36,8,36,9],[37,8,37,9],[52,8,52,9],[54,8,54,9],[39,4,39,6],[48,8,48,9],[49,8,49,9],[50,8,50,9],[51,8,51,9],[42,0,42,16],[43,0,43,16],[44,2,44,3],[45,7,45,10]]}
["Tornado Repair & Preservation Grant Application/Proforma"]
["REPAIR BUDGET"]
[null,"Project:",{"$f":"project","v":0},null,null,null,"Applicant:",{"$f":"dev","v":0},null,null,null,"Square Feet",null,{"$f":"'5) Units & Revenue'!J40","v":0},null,"Total Units:",{"$f":"'1) Application'!J52","v":0}]
["AHC Request:",null,null,{"$f":"'4) Sources & Uses'!E21","v":0},null,null,"Address:",{"$f":"'1) Application'!F37","v":0},null,null,null,null,null,null,null,"LMI Units:",{"$f":"'1) Application'!U57","v":0}]
[null,null,null,null,null,null,"Housing Type:",{"$f":"'1) Application'!G61","v":0}]
[null,null,null,null,null,null,null,null,"Total"]
[null,"Total Construction Cost",null,null,null,null,null,null,{"$f":"'3) Construction Costs'!K73","v":0},null,null,"From Construction Cost, Tab 3"]
[]
[null,"SOFT COSTS",null,null,null,null,null,null,"TOTAL",null,null,"Per Unit",null,"Per SF",null,"% TDC"]
[null,"Architect & Engineering Fee-Design",null,null,null,null,null,null,null,null,null,{"$f":"I10/$Q$3","v":{"$error":"#DIV/0!"}}]
[null,"Architect Fee - Supervision",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Soils Report",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Survey",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Engineering ",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I10:J14)","v":0},null,null,{"$error":"#DIV/0!"},null,{"$f":"I15/N3","v":{"$error":"#DIV/0!"}},null,{"$f":"I15/$I$80","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,{"$f":"I7+I15","v":0}]
[null,"CONSTRUCTION COSTS",null,null,null,null,"fills from Construction Costs Tab 3"]
[null,"General Cond., Overhead & Profit",null,null,null,null,null,null,{"$f":"'3) Construction Costs'!K66+'3) Construction Costs'!K70+'3) Construction Costs'!K71","v":0},null,null,{"$f":"I18/$Q$3","v":{"$error":"#DIV/0!"}}]
[null,"Construction Contingency",null,null,null,null,null,null,{"$f":"'3) Construction Costs'!K72","v":0},null,null,{"$f":"I19/$Q$3","v":{"$error":"#DIV/0!"}}]
[null,"Construction Hard Costs",null,null,null,null,null,null,{"$f":"'3) Construction Costs'!K73-'2) Repair Budget'!I18-'2) Repair Budget'!I19","v":0},null,null,{"$f":"I20/$Q$3","v":{"$error":"#DIV/0!"}}]
[null,"Total Construction",null,null,null,null,null,null,{"$f":"SUM(I18:I20)","v":0},null,null,{"$f":"I21/$Q$3","v":{"$error":"#DIV/0!"}},null,{"$f":"I21/N3","v":{"$error":"#DIV/0!"}},null,{"$f":"I21/$I$80","v":{"$error":"#DIV/0!"}}]
[]
[null,"CARRYING AND CONSTRUCTION FINANCING COSTS"]
[null,"Construction Loan Interest",null,null,null,null,null,null,null,null,null,{"$f":"I24/$Q$3","v":{"$error":"#DIV/0!"}}]
[null,"Construction Period R.E.Taxes",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Construction Period Insurance",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other Construction Loan Fee",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other Construction Inspection Fee",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other Permanent Financing Fee",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Environmental Study",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Market Study ",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Appraisal",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Title Recording & Disbursing (Construction Loan)",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Total Carrying/Finance:",null,null,null,null,null,null,{"$f":"SUM(I24:J33)","v":0},null,null,{"$error":"#DIV/0!"},null,{"$f":"I34/N3","v":{"$error":"#DIV/0!"}},null,{"$f":"I34/$I$80","v":{"$error":"#DIV/0!"}}]
[]
[null,"PERMANENT FINANCING"]
[null,"Title Recording & Disbursing (Permanent Loan)",null,null,null,null,null,null,null,null,null,{"$f":"I37/$Q$3","v":{"$error":"#DIV/0!"}}]
[null,"Legal ",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Environmental Abatement",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other: ",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Total Permanent Financing",null,null,null,null,null,null,{"$f":"SUM(I37:J40)","v":0},null,null,{"$error":"#DIV/0!"},null,{"$f":"I41/N3","v":{"$error":"#DIV/0!"}},null,{"$f":"I41/$I$80","v":{"$error":"#DIV/0!"}}]
[]
["Affordable Housing Commission Rental Production Application/Proforma, Page 2"]
["DEVELOPMENT BUDGET"]
[null,"Project:",{"$f":"project","v":0},null,null,null,"Developer:",{"$f":"dev","v":0},null,null,null,"Square Feet",null,{"$f":"N3","v":0},null,"Total Units:",{"$f":"'1) Application'!J52","v":0}]
[null,null,null,null,null,null,"Address:",{"$f":"'1) Application'!F37","v":0},null,null,null,null,null,null,null,"LMI Units:",{"$f":"'1) Application'!U57","v":0}]
[]
[]
[null,"PROFESSIONAL SERVICES",null,null,null,null,null,null,"TOTAL",null,null,"Per Unit",null,"Per SF",null,"% TDC"]
[null,"Relocation ",null,null,null,null,null,null,null,null,null,{"$f":"I50/$Q$45","v":{"$error":"#DIV/0!"}}]
[null,"FF & E",null,null,null,null,null,null,null,null,null,{"$f":"I51/$Q$45","v":{"$error":"#DIV/0!"}}]
[null,"Other:(Describe)",null,"Security Systems",null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Total Professional Services",null,null,null,null,null,null,{"$f":"SUM(I50:J52)","v":0},null,null,{"$error":"#DIV/0!"},null,{"$f":"I53/N45","v":{"$error":"#DIV/0!"}},null,{"$f":"I53/$I$80","v":{"$error":"#DIV/0!"}}]
[]
[null,"Replacement Cost w/o Acquisition",null,null,null,null,null,null,{"$f":"I53+I41+I34+I16","v":0},null,null,{"$f":"I55/Q45","v":{"$error":"#DIV/0!"}}]
[]
[null,"BUILDING AND PROPERTY ACQUISITION"]
[null,"Other Acquisition Related Costs",null,null,null,null,null,null,null,null,null,{"$f":"I58/$Q$45","v":{"$error":"#DIV/0!"}}]
[null,"Acquisition Cost",null,null,null,null,null,null,{"$f":"SUM(I58:J58)","v":0},null,null,{"$f":"I59/$Q$45","v":{"$error":"#DIV/0!"}},null,{"$f":"I59/N45","v":{"$error":"#DIV/0!"}},null,{"$f":"I59/$I$80","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Replacement Cost (lines 53-57)",null,null,null,null,null,null,{"$f":"SUM(I55:J58)","v":0},null,null,{"$f":"I61/Q45","v":{"$error":"#DIV/0!"}},null,{"$f":"I61/N45","v":{"$error":"#DIV/0!"}},null,{"$f":"I61/$I$80","v":{"$error":"#DIV/0!"}}]
[]
[null,"FEES/MISC"]
[null,"Consultant's Fee",null,null,null,null,null,null,null,null,null,{"$f":"I64/$Q$45","v":{"$error":"#DIV/0!"}}]
[null,"Lease-up/Marketing",null,null,null,null,null,null,null,null,null,{"$f":"I65/$Q$45","v":{"$error":"#DIV/0!"}}]
[null,"Other:(Describe)",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other:(Describe)",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other:(Describe)",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other:(Describe)",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Total Fees/Misc",null,null,null,null,null,null,{"$f":"SUM(I64:J69)","v":0},null,null,{"$error":"#DIV/0!"},null,{"$f":"I70/N45","v":{"$error":"#DIV/0!"}},null,{"$f":"I70/$I$80","v":{"$error":"#DIV/0!"}}]
[]
[null,"RESERVES"]
[null,"Operating Reserve (cash escrow)",null,null,null,null,null,null,null,null,null,{"$f":"I73/$Q$45","v":{"$error":"#DIV/0!"}}]
[null,"Replacement Reserve (cash escrow)",null,null,null,null,null,null,null,null,null,{"$f":"I74/$Q$45","v":{"$error":"#DIV/0!"}}]
[null,"Other Escrow(s):",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other Escrow(s):",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other Escrow(s):",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Total Reserves",null,null,null,null,null,null,{"$f":"SUM(I73:J77)","v":0},null,null,{"$error":"#DIV/0!"},null,{"$f":"I78/N45","v":{"$error":"#DIV/0!"}},null,{"$f":"I78/$I$80","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Repair Cost",null,null,null,null,null,null,{"$f":"I78+I70+I61","v":0},null,null,{"$f":"I80/Q3","v":{"$error":"#DIV/0!"}},null,{"$f":"I80/N45","v":{"$error":"#DIV/0!"}},null,{"$f":"I80/$I$80","v":{"$error":"#DIV/0!"}}]

{"sheet":"3) Construction Costs","index":3,"n_rows":78,"n_cols":21,"rows_kept":78,"cut":false,"hidden":false,"merged":[[1,10,1,11],[1,12,1,15],[10,10,10,13],[8,17,8,22],[2,4,2,6],[76,15,76,16],[25,20,25,21],[27,20,27,21],[28,20,28,21],[23,20,23,21],[14,20,14,21],[15,20,15,21],[15,10,15,13],[18,20,18,21],[14,10,14,13],[21,20,21,21],[22,20,22,21],[26,20,26,21],[16,10,16,13],[17,10,17,13],[16,20,16,21],[17,20,17,21],[26,10,26,13],[24,10,24,13],[24,20,24,21],[18,10,18,13],[23,10,23,13],[32,20,32,21],[28,10,28,13],[29,20,29,21],[32,10,32,13],[31,10,31,13],[30,20,30,21],[31,20,31,21],[34,20,34,21],[33,10,33,13],[30,10,30,13],[29,10,29,13],[36,20,36,21],[35,10,35,13],[33,20,33,21],[40,10,40,13],[40,20,40,21],[39,10,39,13],[35,20,35,21],[39,20,39,21],[38,10,38,13],[38,20,38,21],[37,10,37,13],[36,10,36,13],[41,20,41,21],[43,20,43,21],[42,10,42,13],[42,20,42,21],[37,20,37,21],[57,20,57,21],[54,20,54,21],[56,20,56,21],[45,10,45,13],[53,20,53,21],[52,20,52,21],[47,10,47,13],[48,20,48,21],[57,10,57,13],[45,20,45,21],[52,10,52,13],[41,10,41,13],[43,10,43,13],[46,10,46,13],[44,10,44,13],[70,20,70,21],[69,10,69,13],[67,20,67,21],[58,10,58,13],[59,10,59,13],[60,10,60,13],[62,10,62,13],[71,10,71,13],[44,20,44,21],[65,20,65,21],[66,20,66,21],[48,10,48,13],[49,10,49,13],[49,20,49,21],[53,10,53,13],[55,20,55,21],[67,10,67,13],[61,10,61,13],[0,0,0,22],[70,10,70,13],[72,10,72,13],[63,10,63,13],[69,20,69,21],[65,10,65,13],[75,10,75,13],[75,15,75,16],[76,10,76,13],[5,3,5,6],[61,4,61,6],[58,20,58,21],[59,4,59,6],[60,1,60,3],[60,4,60,6],[61,20,61,21],[46,20,46,21],[72,20,72,21],[54,10,54,13],[71,20,71,21],[47,20,47,21],[60,20,60,21],[59,20,59,21],[63,20,63,21],[6,3,6,8],[3,2,3,8],[4,3,4,9],[55,10,55,13],[56,10,56,13],[77,15,77,16],[7,15,7,17],[11,10,11,13],[74,10,74,13],[73,15,73,16],[74,15,74,16],[61,1,61,3],[59,1,59,3],[77,10,77,13],[34,10,34,13],[25,10,25,13],[21,10,21,13],[22,10,22,13],[27,10,27,13]]}
["CONTRACTOR'S/MORTGAGOR'S COST BREAKDOWN"]
[null,null,null,null,null,null,null,null,null,null,"Square Feet: ",null,{"$f":"'5) Units & Revenue'!J40","v":0},null,null,null,"Units:",null,{"$f":"'1) Application'!J52","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LMI Units:",null,{"$f":"'1) Application'!U57","v":0}]
["Project:",null,{"$f":"project","v":0}]
["Owner:",null,null,{"$f":"dev","v":0}]
["AHC Request:",null,null,{"$f":"'4) Sources & Uses'!E21","v":0}]
["Address:",null,null,{"$f":"'1) Application'!F37","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date of Plans used for estimate: "]
[]
[null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,"Per   ",null,"Per  ",null,"%"]
[null,"Item Description of Work",null,null,null,null,null,null,null,null,"Scheduled Value",null,null,null,null,null,"Unit",null,"SF",null,"Construction"]
[]
["Site Work"]
[1,"Earthwork",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K15/$S$2","v":{"$error":"#DIV/0!"}},null,{"$f":"K15/$M$2","v":{"$error":"#DIV/0!"}},null,{"$f":"K15/$K$73","v":{"$error":"#DIV/0!"}}]
[2,"Site Utilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K16/$S$2","v":{"$error":"#DIV/0!"}},null,{"$f":"K16/$M$2","v":{"$error":"#DIV/0!"}},null,{"$f":"K16/$K$73","v":{"$error":"#DIV/0!"}}]
[3,"Roads & Walks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"K17/$K$73","v":{"$error":"#DIV/0!"}}]
[4,"Off Site Work",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"K18/$K$73","v":{"$error":"#DIV/0!"}}]
["Subtotal Sitework",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K15:N18)","v":0},null,null,null,null,null,{"$f":"SUM(Q15:Q18)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(S15:S18)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(U15:V18)","v":{"$error":"#DIV/0!"}}]
[]
["New Building/Rehabilitation"]
[5,"Concrete",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"K22/$K$73","v":{"$error":"#DIV/0!"}}]
[6,"Masonry",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[7,"Structural Metals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[8,"Rough Carpentry",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[9,"Finish Carpentry",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[10,"Cabinets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[11,"Waterproofing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[12,"Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[13,"Roofing Systems",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[14,"Siding",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[15,"Gutters & Downspouts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[16,"Doors & Hardware",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[17,"Windows",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[18,"Drywall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[19,"Flooring",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[20,"Carpet",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[21,"Painting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[22,"Signage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[23,"Bathroom & Closet Accessories",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[24,"Appliances",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[25,"Window Coverings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[26,"Plumbing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[27,"Fire Sprinklers",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[28,"HVAC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[29,"Electrical",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[30,"Fire Alarm Systems",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[31,"Special Equipment",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[32,"Landscaping",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
["Subtotal Structure",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K22:N49)","v":0},null,null,null,null,null,{"$f":"SUM(Q22:Q49)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(S22:S49)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(U22:V49)","v":{"$error":"#DIV/0!"}}]
[]
["Demolition/Other"]
[33,"Other",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"K53/$K$73","v":{"$error":"#DIV/0!"}}]
[34,"Accessory Bldg",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[35,"Demolition (interior rehab)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[36,"Demolition (land make-ready)",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[37,"Sheet Metal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[38,"Bonding",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[39,"Building Permits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[40,"Other",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[41,"Other",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[42,"Other",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
["Demolition Subtotal",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K53:N62)","v":0}]
["Construction Subtotal",null,null,null,null,null,null,null,null,null,{"$f":"K63+K50+K19","v":0},null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[]
["General Requirements (Attach separate",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K66/K64","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"K66/$K$73","v":{"$error":"#DIV/0!"}}]
[null,"   page detailing costs)"]
["Subtotal",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K64:N66)","v":0},null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"K68/$K$73","v":{"$error":"#DIV/0!"}}]
[]
["Builder's Overhead",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K70/K64","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"K70/$K$73","v":{"$error":"#DIV/0!"}}]
["Builder's Profit",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K71/K64","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"K71/$K$73","v":{"$error":"#DIV/0!"}}]
["Construction Contingency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K72/S2","v":{"$error":"#DIV/0!"}},null,{"$f":"K72/M2","v":{"$error":"#DIV/0!"}},null,{"$f":"K72/K73","v":{"$error":"#DIV/0!"}}]
["TOTAL CONSTRUCTION",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K68:N72)","v":0},null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"K73/$K$73","v":{"$error":"#DIV/0!"}}]
[]
["General Requirements",null,null,null,null,null,null,null,null,null,"% Construction",null,null,null,null,"Limits"]
["General Requirement",null,null,null,null,null,null,null,null,null,{"$f":"K66/K73","v":{"$error":"#DIV/0!"}},null,null,null,null,0.06]
["Builder's Overhead",null,null,null,null,null,null,null,null,null,{"$f":"K70/K73","v":{"$error":"#DIV/0!"}},null,null,null,null,0.02]
["Builders Profit",null,null,null,null,null,null,null,null,null,{"$f":"K71/K73","v":{"$error":"#DIV/0!"}},null,null,null,null,0.08]

{"sheet":"4) Sources & Uses","index":4,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[22,7,22,9],[23,7,23,9],[24,7,24,9],[25,7,25,9],[26,7,26,9],[21,7,21,9],[6,7,6,8],[30,1,30,6],[52,7,52,8],[7,5,7,6],[21,1,21,3],[23,1,23,3],[22,1,22,3],[24,1,24,3],[26,1,26,3],[29,7,29,8],[5,5,5,6],[1,170,1,179],[1,80,1,89],[1,90,1,99],[1,100,1,109],[1,110,1,119],[1,120,1,129],[1,30,1,39],[1,40,1,49],[1,50,1,59],[1,60,1,69],[1,70,1,79],[3,2,3,3],[10,7,10,8],[20,7,20,9],[4,6,4,7],[5,2,5,3],[4,2,4,3],[19,7,19,9],[26,10,29,11],[11,7,11,8],[6,5,6,6],[25,1,25,3],[0,0,0,9],[1,0,1,9],[1,10,1,19],[1,20,1,29],[1,130,1,139],[1,330,1,339],[1,340,1,349],[1,350,1,359],[1,360,1,369],[1,370,1,379],[1,280,1,289],[1,290,1,299],[1,300,1,309],[1,310,1,319],[1,320,1,329],[1,230,1,239],[1,240,1,249],[1,250,1,259],[1,260,1,269],[1,270,1,279],[1,180,1,189],[1,190,1,199],[1,200,1,209],[1,210,1,219],[1,220,1,229],[1,140,1,149],[1,150,1,159],[1,160,1,169],[1,530,1,539],[1,540,1,549],[1,550,1,559],[1,560,1,569],[1,570,1,579],[1,480,1,489],[1,490,1,499],[1,500,1,509],[1,510,1,519],[1,520,1,529],[1,430,1,439],[1,440,1,449],[1,450,1,459],[1,460,1,469],[1,470,1,479],[1,380,1,389],[1,390,1,399],[1,400,1,409],[1,410,1,419],[1,420,1,429],[1,730,1,739],[1,740,1,749],[1,750,1,759],[1,760,1,769],[1,770,1,779],[1,680,1,689],[1,690,1,699],[1,700,1,709],[1,710,1,719],[1,720,1,729],[1,630,1,639],[1,640,1,649],[1,650,1,659],[1,660,1,669],[1,670,1,679],[1,580,1,589],[1,590,1,599],[1,600,1,609],[1,610,1,619],[1,620,1,629],[1,930,1,939],[1,940,1,949],[1,950,1,959],[1,960,1,969],[1,970,1,979],[1,880,1,889],[1,890,1,899],[1,900,1,909],[1,910,1,919],[1,920,1,929],[1,830,1,839],[1,840,1,849],[1,850,1,859],[1,860,1,869],[1,870,1,879],[1,780,1,789],[1,790,1,799],[1,800,1,809],[1,810,1,819],[1,820,1,829],[1,1130,1,1139],[1,1140,1,1149],[1,1150,1,1159],[1,1160,1,1169],[1,1170,1,1179],[1,1080,1,1089],[1,1090,1,1099],[1,1100,1,1109],[1,1110,1,1119],[1,1120,1,1129],[1,1030,1,1039],[1,1040,1,1049],[1,1050,1,1059],[1,1060,1,1069],[1,1070,1,1079],[1,980,1,989],[1,990,1,999],[1,1000,1,1009],[1,1010,1,1019],[1,1020,1,1029],[1,1330,1,1339],[1,1340,1,1349],[1,1350,1,1359],[1,1360,1,1369],[1,1370,1,1379],[1,1280,1,1289],[1,1290,1,1299],[1,1300,1,1309],[1,1310,1,1319],[1,1320,1,1329],[1,1230,1,1239],[1,1240,1,1249],[1,1250,1,1259],[1,1260,1,1269],[1,1270,1,1279],[1,1180,1,1189],[1,1190,1,1199],[1,1200,1,1209],[1,1210,1,1219],[1,1220,1,1229],[1,1530,1,1539],[1,1540,1,1549],[1,1550,1,1559],[1,1560,1,1569],[1,1570,1,1579],[1,1480,1,1489],[1,1490,1,1499],[1,1500,1,1509],[1,1510,1,1519],[1,1520,1,1529],[1,1430,1,1439],[1,1440,1,1449],[1,1450,1,1459],[1,1460,1,1469],[1,1470,1,1479],[1,1380,1,1389],[1,1390,1,1399],[1,1400,1,1409],[1,1410,1,1419],[1,1420,1,1429],[1,1730,1,1739],[1,1740,1,1749],[1,1750,1,1759],[1,1760,1,1769],[1,1770,1,1779],[1,1680,1,1689],[1,1690,1,1699],[1,1700,1,1709],[1,1710,1,1719],[1,1720,1,1729],[1,1630,1,1639],[1,1640,1,1649],[1,1650,1,1659],[1,1660,1,1669],[1,1670,1,1679],[1,1580,1,1589],[1,1590,1,1599],[1,1600,1,1609],[1,1610,1,1619],[1,1620,1,1629],[1,1930,1,1939],[1,1940,1,1949],[1,1950,1,1959],[1,1960,1,1969],[1,1970,1,1979],[1,1880,1,1889],[1,1890,1,1899],[1,1900,1,1909],[1,1910,1,1919],[1,1920,1,1929],[1,1830,1,1839],[1,1840,1,1849],[1,1850,1,1859],[1,1860,1,1869],[1,1870,1,1879],[1,1780,1,1789],[1,1790,1,1799],[1,1800,1,1809],[1,1810,1,1819],[1,1820,1,1829],[1,2130,1,2139],[1,2140,1,2149],[1,2150,1,2159],[1,2160,1,2169],[1,2170,1,2179],[1,2080,1,2089],[1,2090,1,2099],[1,2100,1,2109],[1,2110,1,2119],[1,2120,1,2129],[1,2030,1,2039],[1,2040,1,2049],[1,2050,1,2059],[1,2060,1,2069],[1,2070,1,2079],[1,1980,1,1989],[1,1990,1,1999],[1,2000,1,2009],[1,2010,1,2019],[1,2020,1,2029],[1,2330,1,2339],[1,2340,1,2349],[1,2350,1,2359],[1,2360,1,2369],[1,2370,1,2379],[1,2280,1,2289],[1,2290,1,2299],[1,2300,1,2309],[1,2310,1,2319],[1,2320,1,2329],[1,2230,1,2239],[1,2240,1,2249],[1,2250,1,2259],[1,2260,1,2269],[1,2270,1,2279],[1,2180,1,2189],[1,2190,1,2199],[1,2200,1,2209],[1,2210,1,2219],[1,2220,1,2229],[1,2530,1,2539],[1,2540,1,2549],[1,2550,1,2559],[1,2560,1,2569],[1,2570,1,2579],[1,2480,1,2489],[1,2490,1,2499],[1,2500,1,2509],[1,2510,1,2519],[1,2520,1,2529],[1,2430,1,2439],[1,2440,1,2449],[1,2450,1,2459],[1,2460,1,2469],[1,2470,1,2479],[1,2380,1,2389],[1,2390,1,2399],[1,2400,1,2409],[1,2410,1,2419],[1,2420,1,2429],[1,2730,1,2739],[1,2740,1,2749],[1,2750,1,2759],[1,2760,1,2769],[1,2770,1,2779],[1,2680,1,2689],[1,2690,1,2699],[1,2700,1,2709],[1,2710,1,2719],[1,2720,1,2729],[1,2630,1,2639],[1,2640,1,2649],[1,2650,1,2659],[1,2660,1,2669],[1,2670,1,2679],[1,2580,1,2589],[1,2590,1,2599],[1,2600,1,2609],[1,2610,1,2619],[1,2620,1,2629],[1,2930,1,2939],[1,2940,1,2949],[1,2950,1,2959],[1,2960,1,2969],[1,2970,1,2979],[1,2880,1,2889],[1,2890,1,2899],[1,2900,1,2909],[1,2910,1,2919],[1,2920,1,2929],[1,2830,1,2839],[1,2840,1,2849],[1,2850,1,2859],[1,2860,1,2869],[1,2870,1,2879],[1,2780,1,2789],[1,2790,1,2799],[1,2800,1,2809],[1,2810,1,2819],[1,2820,1,2829],[1,3130,1,3139],[1,3140,1,3149],[1,3150,1,3159],[1,3160,1,3169],[1,3170,1,3179],[1,3080,1,3089],[1,3090,1,3099],[1,3100,1,3109],[1,3110,1,3119],[1,3120,1,3129],[1,3030,1,3039],[1,3040,1,3049],[1,3050,1,3059],[1,3060,1,3069],[1,3070,1,3079],[1,2980,1,2989],[1,2990,1,2999],[1,3000,1,3009],[1,3010,1,3019],[1,3020,1,3029],[1,3330,1,3339],[1,3340,1,3349],[1,3350,1,3359],[1,3360,1,3369],[1,3370,1,3379],[1,3280,1,3289],[1,3290,1,3299],[1,3300,1,3309],[1,3310,1,3319],[1,3320,1,3329],[1,3230,1,3239],[1,3240,1,3249],[1,3250,1,3259],[1,3260,1,3269],[1,3270,1,3279],[1,3180,1,3189],[1,3190,1,3199],[1,3200,1,3209],[1,3210,1,3219],[1,3220,1,3229],[1,3530,1,3539],[1,3540,1,3549],[1,3550,1,3559],[1,3560,1,3569],[1,3570,1,3579],[1,3480,1,3489],[1,3490,1,3499],[1,3500,1,3509],[1,3510,1,3519],[1,3520,1,3529],[1,3430,1,3439],[1,3440,1,3449],[1,3450,1,3459],[1,3460,1,3469],[1,3470,1,3479],[1,3380,1,3389],[1,3390,1,3399],[1,3400,1,3409],[1,3410,1,3419],[1,3420,1,3429],[1,3730,1,3739],[1,3740,1,3749],[1,3750,1,3759],[1,3760,1,3769],[1,3770,1,3779],[1,3680,1,3689],[1,3690,1,3699],[1,3700,1,3709],[1,3710,1,3719],[1,3720,1,3729],[1,3630,1,3639],[1,3640,1,3649],[1,3650,1,3659],[1,3660,1,3669],[1,3670,1,3679],[1,3580,1,3589],[1,3590,1,3599],[1,3600,1,3609],[1,3610,1,3619],[1,3620,1,3629],[1,3930,1,3939],[1,3940,1,3949],[1,3950,1,3959],[1,3960,1,3969],[1,3970,1,3979],[1,3880,1,3889],[1,3890,1,3899],[1,3900,1,3909],[1,3910,1,3919],[1,3920,1,3929],[1,3830,1,3839],[1,3840,1,3849],[1,3850,1,3859],[1,3860,1,3869],[1,3870,1,3879],[1,3780,1,3789],[1,3790,1,3799],[1,3800,1,3809],[1,3810,1,3819],[1,3820,1,3829],[1,4130,1,4139],[1,4140,1,4149],[1,4150,1,4159],[1,4160,1,4169],[1,4170,1,4179],[1,4080,1,4089],[1,4090,1,4099],[1,4100,1,4109],[1,4110,1,4119],[1,4120,1,4129],[1,4030,1,4039],[1,4040,1,4049],[1,4050,1,4059],[1,4060,1,4069],[1,4070,1,4079],[1,3980,1,3989],[1,3990,1,3999],[1,4000,1,4009],[1,4010,1,4019],[1,4020,1,4029],[1,4330,1,4339],[1,4340,1,4349],[1,4350,1,4359],[1,4360,1,4369],[1,4370,1,4379],[1,4280,1,4289],[1,4290,1,4299],[1,4300,1,4309],[1,4310,1,4319],[1,4320,1,4329],[1,4230,1,4239],[1,4240,1,4249],[1,4250,1,4259],[1,4260,1,4269],[1,4270,1,4279],[1,4180,1,4189],[1,4190,1,4199],[1,4200,1,4209],[1,4210,1,4219],[1,4220,1,4229],[1,4530,1,4539],[1,4540,1,4549],[1,4550,1,4559],[1,4560,1,4569],[1,4570,1,4579],[1,4480,1,4489],[1,4490,1,4499],[1,4500,1,4509],[1,4510,1,4519],[1,4520,1,4529],[1,4430,1,4439],[1,4440,1,4449],[1,4450,1,4459],[1,4460,1,4469],[1,4470,1,4479],[1,4380,1,4389],[1,4390,1,4399],[1,4400,1,4409],[1,4410,1,4419],[1,4420,1,4429],[1,4730,1,4739],[1,4740,1,4749],[1,4750,1,4759],[1,4760,1,4769],[1,4770,1,4779],[1,4680,1,4689],[1,4690,1,4699],[1,4700,1,4709],[1,4710,1,4719],[1,4720,1,4729],[1,4630,1,4639],[1,4640,1,4649],[1,4650,1,4659],[1,4660,1,4669],[1,4670,1,4679],[1,4580,1,4589],[1,4590,1,4599],[1,4600,1,4609],[1,4610,1,4619],[1,4620,1,4629],[1,4930,1,4939],[1,4940,1,4949],[1,4950,1,4959],[1,4960,1,4969],[1,4970,1,4979],[1,4880,1,4889],[1,4890,1,4899],[1,4900,1,4909],[1,4910,1,4919],[1,4920,1,4929],[1,4830,1,4839],[1,4840,1,4849],[1,4850,1,4859],[1,4860,1,4869],[1,4870,1,4879],[1,4780,1,4789],[1,4790,1,4799],[1,4800,1,4809],[1,4810,1,4819],[1,4820,1,4829],[1,5130,1,5139],[1,5140,1,5149],[1,5150,1,5159],[1,5160,1,5169],[1,5170,1,5179],[1,5080,1,5089],[1,5090,1,5099],[1,5100,1,5109],[1,5110,1,5119],[1,5120,1,5129],[1,5030,1,5039],[1,5040,1,5049],[1,5050,1,5059],[1,5060,1,5069],[1,5070,1,5079],[1,4980,1,4989],[1,4990,1,4999],[1,5000,1,5009],[1,5010,1,5019],[1,5020,1,5029],[1,5330,1,5339],[1,5340,1,5349],[1,5350,1,5359],[1,5360,1,5369],[1,5370,1,5379],[1,5280,1,5289],[1,5290,1,5299],[1,5300,1,5309],[1,5310,1,5319],[1,5320,1,5329],[1,5230,1,5239],[1,5240,1,5249],[1,5250,1,5259],[1,5260,1,5269],[1,5270,1,5279],[1,5180,1,5189],[1,5190,1,5199],[1,5200,1,5209],[1,5210,1,5219],[1,5220,1,5229],[1,5530,1,5539],[1,5540,1,5549],[1,5550,1,5559],[1,5560,1,5569],[1,5570,1,5579],[1,5480,1,5489],[1,5490,1,5499],[1,5500,1,5509],[1,5510,1,5519],[1,5520,1,5529],[1,5430,1,5439],[1,5440,1,5449],[1,5450,1,5459],[1,5460,1,5469],[1,5470,1,5479],[1,5380,1,5389],[1,5390,1,5399],[1,5400,1,5409],[1,5410,1,5419],[1,5420,1,5429],[1,5730,1,5739],[1,5740,1,5749],[1,5750,1,5759],[1,5760,1,5769],[1,5770,1,5779],[1,5680,1,5689],[1,5690,1,5699],[1,5700,1,5709],[1,5710,1,5719],[1,5720,1,5729],[1,5630,1,5639],[1,5640,1,5649],[1,5650,1,5659],[1,5660,1,5669],[1,5670,1,5679],[1,5580,1,5589],[1,5590,1,5599],[1,5600,1,5609],[1,5610,1,5619],[1,5620,1,5629],[1,5930,1,5939],[1,5940,1,5949],[1,5950,1,5959],[1,5960,1,5969],[1,5970,1,5979],[1,5880,1,5889],[1,5890,1,5899],[1,5900,1,5909],[1,5910,1,5919],[1,5920,1,5929],[1,5830,1,5839],[1,5840,1,5849],[1,5850,1,5859],[1,5860,1,5869],[1,5870,1,5879],[1,5780,1,5789],[1,5790,1,5799],[1,5800,1,5809],[1,5810,1,5819],[1,5820,1,5829],[1,6130,1,6139],[1,6140,1,6149],[1,6150,1,6159],[1,6160,1,6169],[1,6170,1,6179],[1,6080,1,6089],[1,6090,1,6099],[1,6100,1,6109],[1,6110,1,6119],[1,6120,1,6129],[1,6030,1,6039],[1,6040,1,6049],[1,6050,1,6059],[1,6060,1,6069],[1,6070,1,6079],[1,5980,1,5989],[1,5990,1,5999],[1,6000,1,6009],[1,6010,1,6019],[1,6020,1,6029],[1,6330,1,6339],[1,6340,1,6349],[1,6350,1,6359],[1,6360,1,6369],[1,6370,1,6379],[1,6280,1,6289],[1,6290,1,6299],[1,6300,1,6309],[1,6310,1,6319],[1,6320,1,6329],[1,6230,1,6239],[1,6240,1,6249],[1,6250,1,6259],[1,6260,1,6269],[1,6270,1,6279],[1,6180,1,6189],[1,6190,1,6199],[1,6200,1,6209],[1,6210,1,6219],[1,6220,1,6229],[1,6530,1,6539],[1,6540,1,6549],[1,6550,1,6559],[1,6560,1,6569],[1,6570,1,6579],[1,6480,1,6489],[1,6490,1,6499],[1,6500,1,6509],[1,6510,1,6519],[1,6520,1,6529],[1,6430,1,6439],[1,6440,1,6449],[1,6450,1,6459],[1,6460,1,6469],[1,6470,1,6479],[1,6380,1,6389],[1,6390,1,6399],[1,6400,1,6409],[1,6410,1,6419],[1,6420,1,6429],[1,6730,1,6739],[1,6740,1,6749],[1,6750,1,6759],[1,6760,1,6769],[1,6770,1,6779],[1,6680,1,6689],[1,6690,1,6699],[1,6700,1,6709],[1,6710,1,6719],[1,6720,1,6729],[1,6630,1,6639],[1,6640,1,6649],[1,6650,1,6659],[1,6660,1,6669],[1,6670,1,6679],[1,6580,1,6589],[1,6590,1,6599],[1,6600,1,6609],[1,6610,1,6619],[1,6620,1,6629],[1,6930,1,6939],[1,6940,1,6949],[1,6950,1,6959],[1,6960,1,6969],[1,6970,1,6979],[1,6880,1,6889],[1,6890,1,6899],[1,6900,1,6909],[1,6910,1,6919],[1,6920,1,6929],[1,6830,1,6839],[1,6840,1,6849],[1,6850,1,6859],[1,6860,1,6869],[1,6870,1,6879],[1,6780,1,6789],[1,6790,1,6799],[1,6800,1,6809],[1,6810,1,6819],[1,6820,1,6829],[1,7130,1,7139],[1,7140,1,7149],[1,7150,1,7159],[1,7160,1,7169],[1,7170,1,7179],[1,7080,1,7089],[1,7090,1,7099],[1,7100,1,7109],[1,7110,1,7119],[1,7120,1,7129],[1,7030,1,7039],[1,7040,1,7049],[1,7050,1,7059],[1,7060,1,7069],[1,7070,1,7079],[1,6980,1,6989],[1,6990,1,6999],[1,7000,1,7009],[1,7010,1,7019],[1,7020,1,7029],[1,7330,1,7339],[1,7340,1,7349],[1,7350,1,7359],[1,7360,1,7369],[1,7370,1,7379],[1,7280,1,7289],[1,7290,1,7299],[1,7300,1,7309],[1,7310,1,7319],[1,7320,1,7329],[1,7230,1,7239],[1,7240,1,7249],[1,7250,1,7259],[1,7260,1,7269],[1,7270,1,7279],[1,7180,1,7189],[1,7190,1,7199],[1,7200,1,7209],[1,7210,1,7219],[1,7220,1,7229],[1,7530,1,7539],[1,7540,1,7549],[1,7550,1,7559],[1,7560,1,7569],[1,7570,1,7579],[1,7480,1,7489],[1,7490,1,7499],[1,7500,1,7509],[1,7510,1,7519],[1,7520,1,7529],[1,7430,1,7439],[1,7440,1,7449],[1,7450,1,7459],[1,7460,1,7469],[1,7470,1,7479],[1,7380,1,7389],[1,7390,1,7399],[1,7400,1,7409],[1,7410,1,7419],[1,7420,1,7429],[1,7730,1,7739],[1,7740,1,7749],[1,7750,1,7759],[1,7760,1,7769],[1,7770,1,7779],[1,7680,1,7689],[1,7690,1,7699],[1,7700,1,7709],[1,7710,1,7719],[1,7720,1,7729],[1,7630,1,7639],[1,7640,1,7649],[1,7650,1,7659],[1,7660,1,7669],[1,7670,1,7679],[1,7580,1,7589],[1,7590,1,7599],[1,7600,1,7609],[1,7610,1,7619],[1,7620,1,7629],[1,7930,1,7939],[1,7940,1,7949],[1,7950,1,7959],[1,7960,1,7969],[1,7970,1,7979],[1,7880,1,7889],[1,7890,1,7899],[1,7900,1,7909],[1,7910,1,7919],[1,7920,1,7929],[1,7830,1,7839],[1,7840,1,7849],[1,7850,1,7859],[1,7860,1,7869],[1,7870,1,7879],[1,7780,1,7789],[1,7790,1,7799],[1,7800,1,7809],[1,7810,1,7819],[1,7820,1,7829],[1,8130,1,8139],[1,8140,1,8149],[1,8150,1,8159],[1,8160,1,8169],[1,8170,1,8179],[1,8080,1,8089],[1,8090,1,8099],[1,8100,1,8109],[1,8110,1,8119],[1,8120,1,8129],[1,8030,1,8039],[1,8040,1,8049],[1,8050,1,8059],[1,8060,1,8069],[1,8070,1,8079],[1,7980,1,7989],[1,7990,1,7999],[1,8000,1,8009],[1,8010,1,8019],[1,8020,1,8029],[1,8330,1,8339],[1,8340,1,8349],[1,8350,1,8359],[1,8360,1,8369],[1,8370,1,8379],[1,8280,1,8289],[1,8290,1,8299],[1,8300,1,8309],[1,8310,1,8319],[1,8320,1,8329],[1,8230,1,8239],[1,8240,1,8249],[1,8250,1,8259],[1,8260,1,8269],[1,8270,1,8279],[1,8180,1,8189],[1,8190,1,8199],[1,8200,1,8209],[1,8210,1,8219],[1,8220,1,8229],[1,8530,1,8539],[1,8540,1,8549],[1,8550,1,8559],[1,8560,1,8569],[1,8570,1,8579],[1,8480,1,8489],[1,8490,1,8499],[1,8500,1,8509],[1,8510,1,8519],[1,8520,1,8529],[1,8430,1,8439],[1,8440,1,8449],[1,8450,1,8459],[1,8460,1,8469],[1,8470,1,8479],[1,8380,1,8389],[1,8390,1,8399],[1,8400,1,8409],[1,8410,1,8419],[1,8420,1,8429],[1,8730,1,8739],[1,8740,1,8749],[1,8750,1,8759],[1,8760,1,8769],[1,8770,1,8779],[1,8680,1,8689],[1,8690,1,8699],[1,8700,1,8709],[1,8710,1,8719],[1,8720,1,8729],[1,8630,1,8639],[1,8640,1,8649],[1,8650,1,8659],[1,8660,1,8669],[1,8670,1,8679],[1,8580,1,8589],[1,8590,1,8599],[1,8600,1,8609],[1,8610,1,8619],[1,8620,1,8629],[1,8930,1,8939],[1,8940,1,8949],[1,8950,1,8959],[1,8960,1,8969],[1,8970,1,8979],[1,8880,1,8889],[1,8890,1,8899],[1,8900,1,8909],[1,8910,1,8919],[1,8920,1,8929],[1,8830,1,8839],[1,8840,1,8849],[1,8850,1,8859],[1,8860,1,8869],[1,8870,1,8879],[1,8780,1,8789],[1,8790,1,8799],[1,8800,1,8809],[1,8810,1,8819],[1,8820,1,8829],[1,9130,1,9139],[1,9140,1,9149],[1,9150,1,9159],[1,9160,1,9169],[1,9170,1,9179],[1,9080,1,9089],[1,9090,1,9099],[1,9100,1,9109],[1,9110,1,9119],[1,9120,1,9129],[1,9030,1,9039],[1,9040,1,9049],[1,9050,1,9059],[1,9060,1,9069],[1,9070,1,9079],[1,8980,1,8989],[1,8990,1,8999],[1,9000,1,9009],[1,9010,1,9019],[1,9020,1,9029],[1,9330,1,9339],[1,9340,1,9349],[1,9350,1,9359],[1,9360,1,9369],[1,9370,1,9379],[1,9280,1,9289],[1,9290,1,9299],[1,9300,1,9309],[1,9310,1,9319],[1,9320,1,9329],[1,9230,1,9239],[1,9240,1,9249],[1,9250,1,9259],[1,9260,1,9269],[1,9270,1,9279],[1,9180,1,9189],[1,9190,1,9199],[1,9200,1,9209],[1,9210,1,9219],[1,9220,1,9229],[1,9530,1,9539],[1,9540,1,9549],[1,9550,1,9559],[1,9560,1,9569],[1,9570,1,9579],[1,9480,1,9489],[1,9490,1,9499],[1,9500,1,9509],[1,9510,1,9519],[1,9520,1,9529],[1,9430,1,9439],[1,9440,1,9449],[1,9450,1,9459],[1,9460,1,9469],[1,9470,1,9479],[1,9380,1,9389],[1,9390,1,9399],[1,9400,1,9409],[1,9410,1,9419],[1,9420,1,9429],[1,9730,1,9739],[1,9740,1,9749],[1,9750,1,9759],[1,9760,1,9769],[1,9770,1,9779],[1,9680,1,9689],[1,9690,1,9699],[1,9700,1,9709],[1,9710,1,9719],[1,9720,1,9729],[1,9630,1,9639],[1,9640,1,9649],[1,9650,1,9659]],"merged_total":1668,"flags":["merged_cut"]}
["Tornado Repair & Preservation Grant Application/Proforma"]
["Sources & Uses Summary"]
[]
[null,"Project Name",{"$f":"project","v":0},null,null,null,null,"Total Units:",{"$f":"'1) Application'!J52","v":0}]
[null,"Owner:",{"$f":"dev","v":0},null,"Total Square Feet:",{"$f":"'5) Units & Revenue'!J40","v":0},"LMI Units:",null,{"$f":"'1) Application'!U57","v":0}]
[null,"Grant Requested:",{"$f":"E21","v":0},null,"Avg SqFt/Unit:",{"$f":"F5/I4","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Average Rent",{"$f":"'5) Units & Revenue'!S31","v":{"$error":"#DIV/0!"}}]
[]
[null,"Repair Costs",null,null,"Total","Per Unit","% of Total"]
[null,"Total Construction",null,null,{"$f":"'2) Repair Budget'!I21","v":0},{"$f":"E11/$I$4","v":{"$error":"#DIV/0!"}},{"$f":"E11/$E$17","v":{"$error":"#DIV/0!"}},"Const.Cost/SqFt:",null,{"$f":"E11/F5","v":{"$error":"#DIV/0!"}}]
[null,"Total Professional Services",null,null,{"$f":"'2) Repair Budget'!I53","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Total Cost/SqFt:",null,{"$f":"E17/F5","v":{"$error":"#DIV/0!"}}]
[null,"Total Carrying & Construction Financing",null,null,{"$f":"'2) Repair Budget'!I34","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Total Permanent Financing",null,null,{"$f":"'2) Repair Budget'!I41","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Total Reserves",null,null,{"$f":"'2) Repair Budget'!I78","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Total Fees/Misc",null,null,{"$f":"'2) Repair Budget'!I70","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Total Repair Cost",null,null,{"$f":"SUM(E11:E16)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Insurance Deductible",null,null,{"$f":"'1) Application'!J129","v":0}]
[null,"Total Cost",null,null,{"$f":"SUM(E17:E18)","v":0}]
[null,"Construction Financing",null,"List Source","Total","Per Unit","% of Total","Status of Funds: Secured or Not Secured"]
[null,"Grant requested*",null,null,null,{"$f":"E21/$I$4","v":{"$error":"#DIV/0!"}},{"$f":"E21/'2) Repair Budget'!$I$80","v":{"$error":"#DIV/0!"}},"Pending"]
[null,"Owner Equity - fills from Application B127",null,null,{"$f":"'1) Application'!N143","v":0},{"$error":"#DIV/0!"},{"$f":"E22/'2) Repair Budget'!$I$80","v":{"$error":"#DIV/0!"}}]
[null,"Insurance Payout - fills from Application B111+B112",null,null,{"$f":"'1) Application'!J127+'1) Application'!J128","v":0},{"$error":"#DIV/0!"},{"$f":"E23/'2) Repair Budget'!$I$80","v":{"$error":"#DIV/0!"}}]
[null,"FEMA Assistance - fills from Application B117",null,null,{"$f":"'1) Application'!J132","v":0},{"$error":"#DIV/0!"},{"$f":"E24/'2) Repair Budget'!$I$80","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'1) Application'!B137","v":"Source 4: "},null,null,{"$f":"'1) Application'!N137","v":0},{"$error":"#DIV/0!"},{"$f":"E25/'2) Repair Budget'!$I$80","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'1) Application'!B138","v":"Source 5:"},null,null,{"$f":"'1) Application'!N138","v":0},{"$error":"#DIV/0!"},{"$f":"E26/'2) Repair Budget'!$I$80","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'1) Application'!B139","v":"Source 6:"},null,null,{"$f":"'1) Application'!N139","v":0},{"$error":"#DIV/0!"},{"$f":"E27/'2) Repair Budget'!$I$80","v":{"$error":"#DIV/0!"}}]
[null,"Total Sources",null,null,{"$f":"SUM(E21:E27)","v":0},{"$error":"#DIV/0!"},{"$f":"E28/E19","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"(GAP) or Surplus",null,null,{"$f":"E28-E17","v":0},{"$error":"#DIV/0!"},{"$f":"(E30/'2) Repair Budget'!I80)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF(E28=E17,\"\",\"Sources & Uses Do Not Match\")","v":""}]
[]
[]
[null,"Unit Mix","Efficiency","1 BR","2 BR","3 BR","4 BR","Total"]
[null,"20% AMI",{"$f":"'5) Units & Revenue'!C7","v":0},{"$f":"'5) Units & Revenue'!C18","v":0},{"$f":"'5) Units & Revenue'!C29","v":0},{"$f":"'5) Units & Revenue'!N7","v":0},{"$f":"'5) Units & Revenue'!N18","v":0},{"$f":"SUM(C35:G35)","v":0}]
[null,"30% AMI",{"$f":"+'5) Units & Revenue'!C8","v":0},{"$f":"+'5) Units & Revenue'!C19","v":0},{"$f":"+'5) Units & Revenue'!C30","v":0},{"$f":"+'5) Units & Revenue'!N8","v":0},{"$f":"+'5) Units & Revenue'!N19","v":0},0]
[null,"40% AMI",{"$f":"'5) Units & Revenue'!C9","v":0},{"$f":"'5) Units & Revenue'!C20","v":0},{"$f":"'5) Units & Revenue'!C31","v":0},{"$f":"'5) Units & Revenue'!N9","v":0},{"$f":"'5) Units & Revenue'!N20","v":0},0]
[null,"50% AMI",{"$f":"'5) Units & Revenue'!C10","v":0},{"$f":"'5) Units & Revenue'!C21","v":0},{"$f":"'5) Units & Revenue'!C32","v":0},{"$f":"'5) Units & Revenue'!N10","v":0},{"$f":"'5) Units & Revenue'!N21","v":0},0]
[null,"60% AMI",{"$f":"'5) Units & Revenue'!C11","v":0},{"$f":"'5) Units & Revenue'!C22","v":0},{"$f":"'5) Units & Revenue'!C33","v":0},{"$f":"'5) Units & Revenue'!N11","v":0},{"$f":"'5) Units & Revenue'!N22","v":0},0]
[null,"70% AMI",{"$f":"+'5) Units & Revenue'!C12","v":0},{"$f":"+'5) Units & Revenue'!C23","v":0},{"$f":"+'5) Units & Revenue'!C34","v":0},{"$f":"+'5) Units & Revenue'!N12","v":0},{"$f":"+'5) Units & Revenue'!N23","v":0},0]
[null,"80% AMI",{"$f":"+'5) Units & Revenue'!C13","v":0},{"$f":"+'5) Units & Revenue'!C24","v":0},{"$f":"+'5) Units & Revenue'!C35","v":0},{"$f":"+'5) Units & Revenue'!N13","v":0},{"$f":"+'5) Units & Revenue'!N24","v":0},0]
[null,"Market Rate",{"$f":"'5) Units & Revenue'!C14","v":0},{"$f":"'5) Units & Revenue'!C25","v":0},{"$f":"'5) Units & Revenue'!C36","v":0},{"$f":"'5) Units & Revenue'!N14","v":0},{"$f":"'5) Units & Revenue'!N25","v":0},0]
[null,"Total ",{"$f":"SUM(C35:C42)","v":0},0,0,0,0,{"$f":"SUM(H35:H42)","v":0}]
[]
[null,"Operating Budget",null,"Annual","Per Unit","Assumptions"]
[null,"Gross Rent Potential",null,{"$f":"'5) Units & Revenue'!T29","v":0},{"$f":"D46/$I$4","v":{"$error":"#DIV/0!"}},"Vacancy Rate:",null,{"$f":"'6) Operating Budget'!C13","v":7.0000000000000007E-2}]
[null,"Other Income",null,{"$f":"'5) Units & Revenue'!T41","v":0},{"$f":"D47/$I$4","v":{"$error":"#DIV/0!"}},"Inflation",null,"1-2%"]
[null,"Vacancy",null,{"$f":"'6) Operating Budget'!D13","v":0},{"$error":"#DIV/0!"},"Administrative Inflation",null,0.03]
[null,"Adjusted Gross Income",null,{"$f":"'6) Operating Budget'!D14","v":0},{"$error":"#DIV/0!"}]
[null,"Operating Expenses",null,{"$f":"'6) Operating Budget'!I32","v":0},{"$error":"#DIV/0!"}]
[null,"Net Operating Income",null,{"$f":"'6) Operating Budget'!I36","v":0},{"$error":"#DIV/0!"}]
[null,"Annual Debt Service",null,0,{"$error":"#DIV/0!"}]

{"sheet":"5) Units & Revenue","index":5,"n_rows":47,"n_cols":22,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,1,0,21],[1,1,1,21],[3,14,3,15],[3,12,3,13],[2,14,2,15],[2,1,2,3],[2,4,2,7],[2,9,2,10],[3,16,3,17],[39,6,39,8],[59,5,59,20],[42,15,42,18],[3,2,3,3],[3,4,3,7],[3,8,3,10],[27,12,27,17],[29,12,29,13],[30,12,30,13],[38,14,38,16],[39,13,39,16],[31,12,31,13]]}
[null,{"$f":"'4) Sources & Uses'!A1","v":"Tornado Repair & Preservation Grant Application/Proforma"}]
[null,"Unit Information & Gross Revenue Potential"]
[null,"Project:",null,null,{"$f":"project","v":0},null,null,null,null,"Owner:",null,null,{"$f":"dev","v":0},null,"Total Units:",{"$f":"'1) Application'!#REF!","v":{"$error":"#REF!"}},{"$f":"'1) Application'!J52","v":0},null,"LMI Units:",{"$f":"'1) Application'!U57","v":0}]
[null,null,"Address:",null,{"$f":"'1) Application'!F37","v":0},null,null,null,"Grant Request:",null,null,null,{"$f":"'4) Sources & Uses'!E21","v":0},null,"Housing Type:",null,{"$f":"'1) Application'!G61","v":0}]
[null,"Efficiency Units"]
[null,null,"# of Units","% AMI Targeted","Baths","Sq. Ft.","Rent","Monthly Rent","Annual Rent","# LMI Units","Sq.Ft.",null,"3 BR Units","# of Units","% AMI Targeted","Baths","Sq. Ft.","Rent","Monthly Rent","Annual Rent","# LMI Units","Sq.Ft."]
[null,null,null,0.2,null,null,null,{"$f":"C7*G7","v":0},{"$f":"H7*12","v":0},null,{"$f":"F7*C7","v":0},null,null,null,0.2,null,null,null,{"$f":"N7*R7","v":0},{"$f":"S7*12","v":0},null,{"$f":"Q7*N7","v":0}]
[null,null,null,0.3,null,null,null,0,0,null,{"$f":"F8*C8","v":0},null,null,null,0.3,null,null,null,{"$f":"N8*R8","v":0},0,null,{"$f":"Q8*N8","v":0}]
[null,null,null,0.4,null,null,null,0,0,null,0,null,null,null,0.4,null,null,null,0,0,null,0]
[null,null,null,0.5,null,null,null,0,0,null,0,null,null,null,0.5,null,null,null,0,0,null,0]
[null,null,null,0.6,null,null,null,0,0,null,0,null,null,null,0.6,null,null,null,0,0,null,0]
[null,null,null,0.7,null,null,null,0,0,null,0,null,null,null,0.7,null,null,null,0,0,null,0]
[null,null,null,0.8,null,null,null,0,0,null,{"$f":"F13*C13","v":0},null,null,null,0.8,null,null,null,0,0,null,0]
[null,null,null,"Market Rate",null,null,null,0,0,null,0,null,null,null,"Market Rate",null,null,null,0,0,null,0]
[null,"Subtotal",{"$f":"SUM(C7:C14)","v":0},null,null,null,null,{"$f":"SUM(H7:H14)","v":0},{"$f":"SUM(I7:I14)","v":0},{"$f":"+J7+J8+J9+J10+J11+J12+J13+J14","v":0},{"$f":"SUM(K7:K14)","v":0},null,"Subtotal",{"$f":"SUM(N7:N14)","v":0},null,null,null,null,{"$f":"SUM(S7:S14)","v":0},{"$f":"SUM(T7:T14)","v":0},{"$f":"+U7+U8+U9+U10+U11+U12+U13+U14","v":0},{"$f":"SUM(V7:V14)","v":0}]
[]
[null,"1 BR Units","# of Units","% AMI Targeted","Baths","Sq. Ft.","Rent","Monthly Rent","Annual Rent","# LMI Units","Sq.Ft.",null,"4 BR Units","# of Units","% AMI Targeted","Baths","Sq. Ft.","Rent","Monthly Rent","Annual Rent","# LMI Units","Sq.Ft."]
[null,null,null,0.2,null,null,null,{"$f":"C18*G18","v":0},{"$f":"H18*12","v":0},null,{"$f":"F18*C18","v":0},null,null,null,0.2,null,null,null,{"$f":"N18*R18","v":0},{"$f":"S18*12","v":0},null,{"$f":"Q18*N18","v":0}]
[null,null,null,0.3,null,null,null,0,0,null,0,null,null,null,0.3,null,null,null,{"$f":"N19*R19","v":0},0,null,{"$f":"Q19*N19","v":0}]
[null,null,null,0.4,null,null,null,0,0,null,0,null,null,null,0.4,null,null,null,0,0,null,0]
[null,null,null,0.5,null,null,null,0,0,null,0,null,null,null,0.5,null,null,null,0,0,null,0]
[null,null,null,0.6,null,null,null,0,0,null,0,null,null,null,0.6,null,null,null,0,0,null,0]
[null,null,null,0.7,null,null,null,0,0,null,0,null,null,null,0.7,null,null,null,0,0,null,0]
[null,null,null,0.8,null,null,null,0,0,null,0,null,null,null,0.8,null,null,null,0,0,null,0]
[null,null,null,"Market Rate",null,null,null,0,0,null,0,null,null,null,"Market Rate",null,null,null,0,0,null,0]
[null,"Subtotal",{"$f":"SUM(C18:C25)","v":0},null,null,null,null,{"$f":"SUM(H18:H25)","v":0},{"$f":"SUM(I18:I25)","v":0},{"$f":"+J18+J19+J20+J21+J22+J23+J24+J25","v":0},{"$f":"SUM(K18:K25)","v":0},null,"Subtotal",{"$f":"SUM(N18:N25)","v":0},null,null,null,null,{"$f":"SUM(S18:S25)","v":0},{"$f":"SUM(T18:T25)","v":0},{"$f":"+U18+U19+U20+U21+U22+U23+U24+U25","v":0},{"$f":"SUM(V18:V25)","v":0}]
[]
[null,"2 BR Units","# of Units","% AMI Targeted","Baths","Sq. Ft.","Rent","Monthly Rent","Annual Rent","# LMI Units","Sq.Ft.",null,null,null,null,null,null,null,"Monthly Rent","Annual Rent"]
[null,null,null,0.2,null,null,null,{"$f":"C29*G29","v":0},{"$f":"H29*12","v":0},null,{"$f":"F29*C29","v":0},null,"Total Units",null,{"$f":"N26+N15+C37+C26+C15","v":0},null,null,"Gross Rent Potential",{"$f":"S26+S15+H37+H26+H15","v":0},{"$f":"T26+T15+I37+I26+I15","v":0}]
[null,null,null,0.3,null,null,null,{"$f":"C30*G30","v":0},0,null,{"$f":"F30*C30","v":0},null,"Total LMI Units",null,{"$f":"+J15+J26+J37+U15+U26","v":0}]
[null,null,null,0.4,null,null,null,0,0,null,{"$f":"F31*C31","v":0},null,null,null,null,null,null,"Per Unit Avg",{"$f":"S29/O29","v":{"$error":"#DIV/0!"}},{"$f":"T29/O29","v":{"$error":"#DIV/0!"}}]
[null,null,null,0.5,null,null,null,0,0,null,0]
[null,null,null,0.6,null,null,null,0,0,null,0,null,"Other Income",null,null,null,null,null,"Monthly","Annually"]
[null,null,null,0.7,null,null,null,0,0,null,0]
[null,null,null,0.8,null,null,null,0,0,null,0,null,"Miscellaneous & Interest",null,null,null,null,null,null,{"$f":"S35*12","v":0}]
[null,null,null,"Market Rate",null,null,null,0,0,null,0,null,"Laundry",null,null,null,null,null,null,0]
[null,"Subtotal",{"$f":"SUM(C29:C36)","v":0},null,null,null,null,{"$f":"SUM(H29:H36)","v":0},{"$f":"SUM(I29:I36)","v":0},{"$f":"+J29+J30+J31+J32+J33+J34+J35+J36","v":0},{"$f":"SUM(K29:K36)","v":0},null,"Carports/Garages",null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Tenant Charges (late fees, insufficient funds, etc)",null,null,null,null,null,null,0]
[null,null,"Special Populations Review",null,null,null,"Square Footage",null,null,null,null,null,"Operating Subsidy:",null,"(source)",null,null,null,null,0]
[null,null,{"$f":"'1) Application'!B65","v":0},"Disabled",null,null,"Residential Square Footage",null,null,{"$f":"K15+K26+K37+U15+U26","v":0},null,null,"Other:",null,null,null,null,null,null,0]
[null,null,{"$f":"'1) Application'!B66","v":0},"Elderly",null,null,null,null,null,null,null,null,"Totals",null,null,null,null,null,{"$f":"SUM(S35:S40)","v":0},{"$f":"SUM(T35:T40)","v":0}]
[null,null,{"$f":"'1) Application'!B67","v":0},"Previously Homeless"]
[null,null,{"$f":"'1) Application'!B68","v":0},"Youth & Families",null,null,null,null,null,null,null,null,null,null,null,"Gross Annual Income Potential",null,null,null,{"$f":"T29+T41","v":0}]
[null,null,{"$f":"'1) Application'!B69","v":0},"Veterans"]
[null,null,{"$f":"'1) Application'!B70","v":0},"Formerly incarcerated"]
[null,null,{"$f":"'1) Application'!B71","v":0},"LGBT"]
[null,null,{"$f":"'1) Application'!B72","v":0},"Other"]

{"sheet":"6) Operating Budget","index":6,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":false,"merged":[[5,2,5,4],[4,2,4,4],[0,1,0,10],[1,1,1,10],[2,2,2,4],[2,6,2,7],[3,2,3,6]]}
[null,{"$f":"'4) Sources & Uses'!A1","v":"Tornado Repair & Preservation Grant Application/Proforma"}]
[null,"ANNUAL OPERATING BUDGET"]
[null,"Project:",{"$f":"project","v":0},null,null,null,"Owner:",null,{"$f":"dev","v":0}]
[null,"Address:",{"$f":"'1) Application'!F37","v":0},null,null,null,null,"LMI Units:",{"$f":"'1) Application'!U57","v":0}]
[null,"AHC Request:",{"$f":"'4) Sources & Uses'!E21","v":0},null,null,null,null,"Total Units:",{"$f":"'1) Application'!J52","v":0}]
[null,"Housing:",{"$f":"'1) Application'!G61","v":0}]
[]
[]
[null,"REVENUE",null,"Annual","Per Unit","% Adj Income",null,"Operating","Annual","Per Unit","% Adj Income"]
[null,"Gross Rent Potential",null,{"$f":"'5) Units & Revenue'!T29","v":0},{"$f":"D10/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}},null,null,"Security",null,{"$f":"I10/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,"Other Revenue",null,{"$f":"'5) Units & Revenue'!T41","v":0},{"$f":"D11/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}},null,null,"Common Electricity",null,{"$f":"I11/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,"Subtotal",null,{"$f":"SUM(D10:D11)","v":0},{"$f":"D12/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}},null,null,"Water/Sewer",null,{"$f":"I12/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,"Combined Vacancy Rate",7.0000000000000007E-2,{"$f":"D12*C13","v":0},{"$f":"D13/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}},null,null,"Gas",null,{"$f":"I13/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,"Adjusted Gross Income",null,{"$f":"D12-D13","v":0},{"$f":"D14/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}},null,null,"Trash Removal",null,{"$f":"I14/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Payroll",null,{"$f":"I15/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,"OPERATING EXPENSES",null,null,null,null,null,"Payroll Taxes & Fringes",null,{"$f":"I16/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Other:",null,{"$f":"I17/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,"Administrative Costs",null,"Annual","Per Unit",null,null,"Other:",null,{"$f":"I18/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,"Advertising",null,null,{"$f":"D19/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}},null,null,"Other:",null,{"$f":"I19/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,"Management",null,null,{"$f":"D20/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}},null,null,"Subtotal",{"$f":"SUM(I10:I19)","v":0},{"$f":"I20/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}},{"$f":"(I20/$D$14)","v":{"$error":"#DIV/0!"}}]
[null,"Legal/Partnership",null,null,{"$f":"D21/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,"Accounting/Audit",null,null,{"$f":"D22/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}},null,null,"Escrows & Reserves","Annual","Per Unit"]
[null,"Compliance Monitoring",null,null,{"$f":"D23/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}},null,null,"Insurance",null,{"$f":"I23/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,"Other:",null,null,{"$f":"D24/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}},null,null,"Real Estate Taxes",null,{"$f":"I24/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,"Other:",null,null,{"$f":"D25/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}},null,null,"Other Taxes",null,{"$f":"I25/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,"Other:",null,null,{"$f":"D26/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}},null,null,"Other",null,{"$f":"I26/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,"Other:",null,null,{"$f":"D27/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}},null,null,"Other:",null,{"$f":"I27/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,"Subtotal",null,{"$f":"SUM(D19:D27)","v":0},{"$f":"D28/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}},{"$f":"(D28/$D$14)","v":{"$error":"#DIV/0!"}},null,"Other:",null,{"$f":"I28/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Other:",null,{"$f":"I29/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,"Maintenance",null,"Annual","Per Unit",null,null,"Subtotal",{"$f":"SUM(I23:I29)","v":0},{"$f":"I30/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}},{"$f":"(I30/$D$14)","v":{"$error":"#DIV/0!"}}]
[null,"Decorating",null,null,{"$f":"D31/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,"Repairs",null,null,{"$f":"D32/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}},null,null,"Total Operating Expenses",{"$f":"D28+D39+I20+I30","v":0},{"$f":"I32/'1) Application'!J52","v":{"$error":"#DIV/0!"}},{"$f":"(I32/$D$14)","v":{"$error":"#DIV/0!"}}]
[null,"Exterminating",null,null,{"$f":"D33/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,"Grounds",null,null,{"$f":"D34/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}},null,null,"Replacement Reserve",null,{"$f":"I34/'1) Application'!J52","v":{"$error":"#DIV/0!"}}]
[null,"Other",null,null,{"$f":"D35/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}},null,null,"Op Expenses + Replace. Reserve",{"$f":"I34+I32","v":0}]
[null,"Other:",null,null,{"$f":"D36/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}},null,null,"NET OPERATING INCOME",{"$f":"D14-I32-I34","v":0},{"$f":"E14-J32-J34","v":{"$error":"#DIV/0!"}},{"$f":"(I36/$D$14)","v":{"$error":"#DIV/0!"}}]
[null,"Other:",null,null,{"$f":"D37/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,"Other:",null,null,{"$f":"D38/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}}]
[null,"Subtotal",null,{"$f":"SUM(D31:D38)","v":0},{"$f":"D39/'1) Application'!$J$52","v":{"$error":"#DIV/0!"}},{"$f":"(D39/$D$14)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Annual Income and Expenses"]
[null,"Adjusted Gross Income",null,null,{"$f":"D14","v":0}]
[null,"Annual Operating Expense + Replacement Reserve",null,null,{"$f":"I32+I34","v":0}]
[null,"Net Operating Income (Effective Income - Expenses)",null,null,{"$f":"D14-I35","v":0}]
[null,"Annual Debt Service AHC (based on 30-year amortization)",null,null,{"$f":"'4) Sources & Uses'!D52","v":0}]

{"sheet":"7) Living Wage","index":7,"n_rows":83,"n_cols":13,"rows_kept":83,"cut":false,"hidden":false,"merged":[[0,0,2,12],[4,1,5,11],[8,0,8,5],[8,7,8,12],[10,0,10,5],[10,7,10,12],[12,0,12,5],[12,7,12,12],[14,0,14,3],[14,7,14,12],[16,0,16,5],[16,7,16,12],[36,0,36,8],[18,0,18,5],[18,7,18,12],[20,0,20,5],[20,7,20,12],[22,0,22,5],[22,7,22,12],[24,0,24,5],[24,7,24,12],[26,0,31,12],[33,0,33,7],[35,0,35,8],[39,0,39,2],[39,7,39,12],[41,0,41,2],[41,7,41,12],[43,0,43,2],[43,7,43,12],[47,0,47,12],[48,0,48,12],[51,2,51,7],[51,8,51,12],[52,0,52,6],[52,7,52,12],[67,4,67,11],[53,0,53,12],[54,0,54,3],[57,0,57,12],[60,1,60,5],[60,8,60,10],[61,1,61,5],[61,8,61,10],[63,1,63,4],[63,6,63,7],[63,8,63,12],[65,3,65,4],[65,9,65,12],[69,0,69,12],[82,0,82,1],[82,2,82,5],[82,7,82,9],[82,10,82,12]]}
["LIVING WAGE ACKNOWLEDGEMENT AND ACCEPTANCE DECLARATION"]
[]
[]
[]
[null,"(To be completed by each respondent to a bid/proposal solicitation when that solicitation has included Living Wage Advertisement/Solicitation Language)"]
[]
[]
[]
["CONTRACTING AGENCY",null,null,null,null,null,null,"Affordable Housing Commission"]
[]
["AGENCY CONTRACT NUMBER",null,null,null,null,null,null,1430010]
[]
["BIDDER'S PROPONENT'S NAME:"]
[]
["DATE PREPARED:"]
[]
["PREPARED BY:"]
[]
["PREPARER'S TELEPHONE NUMBER:"]
[]
["PREPARER'S E-MAIL ADDRESS:"]
[]
["PREPARER'S CELL PHONE NUMBER:"]
[]
["PREPARER'S ADDRESS AND ZIP CODE:"]
[]
["As the authorized representative of the above-referenced bidder or proponent, I hereby acknowledge that the bidder/proponent understands that the contract or agreement that will be executed with a successful bidder/proponent pursuant to this solicitation "]
[]
[]
[]
[]
[]
[]
["AUTHORIZED REPRESENTATIVE CERTIFICATION:"]
[]
[]
["Signature"]
[]
[]
["NAME:"]
[]
["TITLE:"]
[]
["DATE:"]
[]
[]
[]
["Living Wage Change/No Change Affidavit for Contracts With"]
["Not-For-Profit Entities"]
[]
[]
[null,"I",null,null,null,null,null,null,"swear that there have been no changes in"]
[null,null,null,null,null,null,null,"circumstances affecting its earlier certification as"]
["a non-profit entity conforming to the definition of Exempt Non-Profit Organization in accordance with the Living Wage Ordinance 65597 Subparagraph (A)(iv).  I swear there have been no material changes in the information provided to Affordable Housing Commission the organization's IRS Tax-Exemption Status Determination Letter, Articles of Incorporation and By-laws submitted on"]
[null,null,null,null,"."]
[]
[]
["I specifically swear the following changes have been made (Documentation of Changes shall be submitted with this affidavit):"]
[]
[]
[]
[null,"Signature",null,null,null,null,null,null,"Date"]
[]
["State of",null,null,null,null,null,", City/County of"]
[]
["On this",null,"day of",null,null,2026,"before me appeared"]
["to me personally known, who, being duly sworn, did execute the foregoing affidavit and did state that he or "]
["she was properly authorized by",null,null,null,null,null,null,null,null,null,null,null,","]
[null,null,null,null,"name of firm"]
["to execute the affidavit and did so as his or her free act and deed."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["(SEAL/STAMP)"]
[]
["Notary Public",null,null,null,null,null,null,"Commission Expires"]

{"sheet":"8) 1099","index":8,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":false,"merged":[[7,3,7,5],[33,0,34,9],[10,1,10,9],[11,1,11,9],[9,1,9,9],[15,1,16,9]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2026-06-12"]
[]
[null,"Affordable Housing Commission"]
[null,"1520 Market Street, Suite 2080"]
[null,"St. Louis, MO 63103"]
[]
[null,"To Whom It May Concern:"]
[]
[null,"The Internal Revenue Service Tax Equity and Fiscal Responsibility Act of 1982 requires the City of St Louis to have either a Social Security Number for individuals or proprietorships, or a Federal Identification on file for all vendors subject to 1099 reportable payments of $600.00 or more."]
[]
[]
[null,null,"Please complete the information below and return this letter to us within fifteen days."]
[null," WE ARE UNABLE TO PROCESS ANY PAYMENTS WITHOUT THIS INFORMATION."]
[]
[null,"1. Check the Appropriate Company",null,"2. I.D. Number (Complete One)"]
[]
[null,"    _____ Corporation",null,null,"     _____­________________________"]
[null,null,null,null,null,"         Federal I.D. xx-xxxxxxx"]
[null,"    _____ Partnership"]
[]
[null,"    _____ Individual/Proprietorship","Individual/Proprietorship",null,"     _____­________________________"]
[null,null,null,null,null,"         S.S. Number xxx-xx-xxxx"]
[null,"    _____ LLC - ____ (Corp) ____ (Partnership)"]
[null,"                          (Check one of the two above spaces"]
[null,"                            for tax classification if an LLC)"]
[]
["If you are providing a social security number, please write your name clearly. The IRS will not accept a company name with a social security number for 1099 purposes."]
[]
[]
[null,null,"I certify that the information provided above is true, correct and complete."]
[]
[null,"________________________________",null,"_______________________________"]
[null,"Authorized Signature",null,"Title"]
[]
[]
[null,"________________________________",null,"_______________________________"]
[null,"Company Name",null,"Date"]
[]
[]
[null,"________________________________",null,"_______________________________"]
[null,"Address",null,"City, State, Zip"]
[]
[null,"PLEASE RETURN TO: Affordable Housing Commission"]
[null,"FAX #: 314-613-7015"]

{"sheet":"Compliance","index":9,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,1,0,7],[1,1,1,7],[2,1,2,7],[3,2,3,3],[17,6,17,7],[19,4,19,5],[21,0,21,5],[19,6,19,7],[6,0,6,8],[7,0,7,8]]}
[null,"Tornado Repair & Preservation Grant Application/Proforma"]
[null,"COMPLIANCE CHECK"]
[null,"For AHC Staff Use "]
[null,"Project:",{"$f":"project","v":0}]
[]
[]
["2026 Income Guidelines"]
["City of St. Louis"]
["Family Size",1,2,3,4,5,6,7,8]
[0.2,{"$f":"E10*0.7","v":15889.999999999998},{"$f":"E10*0.8","v":18160},{"$f":"E10*0.9","v":20430},{"$f":"113500*0.2","v":22700},{"$f":"E10*1.08","v":24516},{"$f":"E10*1.16","v":26332},{"$f":"E10*1.24","v":28148},{"$f":"E10*1.3208","v":29982.16}]
[0.3,23850,27250,30650,34050,38680,44360,50040,55720]
[0.4,{"$f":"E12*0.7","v":31779.999999999996},36320,40860,{"$f":"113500*0.4","v":45400},{"$f":"E12*1.08","v":49032},{"$f":"E12*1.16","v":52664},{"$f":"E12*1.24","v":56296},{"$f":"E12*1.3208","v":59964.32}]
[0.5,39750,45400,51100,56750,61300,65850,70400,74950]
[0.6,{"$f":"E14*0.7","v":47670},{"$f":"E14*0.8","v":54480},{"$f":"E14*0.9","v":61290},{"$f":"113500*0.6","v":68100},{"$f":"E14*1.08","v":73548},{"$f":"E14*1.16","v":78996},{"$f":"E14*1.24","v":84444},{"$f":"E14*1.3208","v":89946.48}]
[0.65,{"$f":"E15*0.7","v":51642.5},{"$f":"E15*0.8","v":59020},{"$f":"E15*0.9","v":66397.5},{"$f":"113500*0.65","v":73775},{"$f":"E15*1.08","v":79677},{"$f":"E15*1.16","v":85579},{"$f":"E15*1.24","v":91481},{"$f":"E15*1.3208","v":97442.02}]
[0.7,{"$f":"E16*0.7","v":55615},63560,71505,{"$f":"113500*0.7","v":79450},{"$f":"E16*1.08","v":85806},{"$f":"E16*1.16","v":92162},{"$f":"E16*1.24","v":98518},{"$f":"E16*1.3208","v":104937.56}]
[0.8,63600,72650,81750,90800,98100,105350,112600,119900]
["St. Louis Area (MO-IL) Median Family Income (AMI) for year 2026 is $113,500."]
["Source:  HUD Income Limits, huduser.gov/portal/datasets,  June 2026."]
[]
[]
["2026 Fair Market Rents By Unit Bedrooms"]
["Final FY 2026","Efficiency","One-Bedroom","Two-Bedroom","Three-Bedroom","Four-Bedroom"]
[null,955,995,1218,1568,1812]
["Source: https://www.huduser.gov/portal/datasets/fmr/fmrs/FY2026_code/2026state_summary.odn, July 2026"]

{"sheet":"9) New Owner","index":10,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[18,1,18,8],[19,1,19,8],[20,1,20,8],[21,1,21,8],[6,1,6,8],[7,1,7,8],[8,1,8,8],[9,1,9,8],[11,1,11,8]]}
["Tornado Repair & Preservation Grant Application"]
["New Ownership (changed since May 16, 2025)"]
[]
[]
[null,"Ownership Change"]
[null,"Explain why the ownership of the rental property(ies) changed since May 2025:"]
[]
[]
[]
[]
[]
[null,"Does the new ownership:"]
["1.",null,"Serve a public purpose."]
["2.",null,"Preserve the recovery objectives of the affordable housing preservation program."]
["3.",null,"Advance the City's recovery goals."]
[]
[]
[null,"If you answered Yes, explain how the ownership change is supports the objectives of this program."]

{"sheet":"Eligibility","index":11,"n_rows":53,"n_cols":15,"rows_kept":53,"cut":false,"hidden":true,"merged":[[44,4,44,14],[45,4,45,14],[46,4,46,14],[47,4,47,14],[38,4,38,14],[39,4,39,14],[40,4,40,14],[41,4,41,14],[42,4,42,14],[43,4,43,14],[34,4,34,14],[35,4,35,14],[36,4,36,14],[37,4,37,14],[30,4,30,14],[31,4,31,14],[32,4,32,14],[33,4,33,14],[26,4,26,14],[27,4,27,14],[28,4,28,14],[29,4,29,14],[2,2,2,3],[2,7,2,10],[3,7,3,10],[4,7,4,10],[3,0,3,1],[3,4,3,6],[3,2,3,3],[2,5,2,6],[25,4,25,14],[20,4,20,14],[4,5,4,6],[14,4,14,14],[3,11,3,13],[0,0,0,14],[21,0,21,14],[22,0,22,14],[23,1,23,14],[24,1,24,14],[8,4,8,14],[9,4,9,14],[10,4,10,14],[11,4,11,14],[12,4,12,14],[13,4,13,14],[15,4,15,14],[16,4,16,14],[17,4,17,14],[18,4,18,14],[19,4,19,14]]}
["ELIGIBILITY ANALYSIS & COMPLETENESS REVIEW"]
[]
[null,"Project:",{"$f":"Evaluation!C2","v":0},null,null,"Applicant:",null,{"$f":"'1) Application'!E7","v":0},null,null,null,null,null,"Total Units:",{"$f":"'1) Application'!J52","v":0}]
["AHC Request:",null,{"$f":"'4) Sources & Uses'!E21","v":0},null,"Project Address:",null,null,{"$f":"'1) Application'!F37","v":0},null,null,null,"Damaged LMI Units:",null,null,{"$f":"'1) Application'!U58","v":0}]
[null,null,null,null,null,"Housing Type:",null,{"$f":"'1) Application'!G61","v":0}]
[null,"Reviewed by:"]
[]
[null,"Eligibility Analysis"]
[null,"N/A","YES","NO","DESCRIPTION"]
[null,null,null,null,"1. Application received on or by 5 p.m., Friday, September 11, 2026"]
[null,null,null,null,"2. Federal Identification Number provided"]
[null,null,null,null,"3. City of St. Louis tax and business license successfully verified by AHC Staff (CBI Clearance)"]
[null,null,null,null,"4. Complete & satisfactory AHC Conflict of Interest Disclosure Statement provided"]
[null,null,null,null,"5. State of Missouri Certificate of Corporate Good Standing provided, dated no more than 6 months old"]
[null,null,null,null,"6. Three hard copies of Tornado Repair & Preservation Grant Application & Proforma provided"]
[null,null,null,null,"7. One original copy of Tornado Repair & Preservation Grant Application & Proforma with original signatures provided"]
[null,null,null,null,"8. One electronic copy of Excel-based Tornado Repair & Preservation Grant & Proforma emailed to hinerl@stlouis-mo.gov"]
[null,null,null,null,"9. All items on checklist are submitted in order and each item is clearly identified"]
[null,null,null,null,"10. Applicant has not defaulted on a previous AHC loan."]
[null,null,null,null,"11. Proposal is eligible to apply: it is located in the Tornado Impact Area; It proposes to repair rental housing units serving LMI residents; LMI rental housing units were damaged in the May 2025 tornado; The owner agrees to sign a new 6-year Land Use Restriction Agreement (LURA) if awarded funds; and, if the owner is not a tax-exempt organization, the property currently holds proof of an active Land Use Restriction Agreement (LURA) or Covenants for Agreements & Restrictions restricting the income of residents."]
[null,null,null,null,"12. lf the ownership has materially changed since May 16, 2025, the owner has satisfactorily shown the project is consistent with, and advances, the City's tornado recovery goals."]
["Section Intentionally Left Blank"]
["Continue to Page 2"]
[null,"Proposal Completeness Review"]
[null,"If NO is checked for any section, the application will be determined to be incomplete."]
[null,"N/A","YES","NO","DESCRIPTION"]
[null,null,null,null,"1. Locator Map - indicating the location of the proposed repair project."]
[null,null,null,null,"2. All omissions must be stated in Cell B227 of the application.                                                                      Certifications Section VI. Must Be Signed."]
[null,null,null,null,"3. A copy of all tornado financial assistance received, or to be received.  Includes Insurance payout (if exists), FEMA assistance, and all charitable contributions."]
[null,null,null,null,"4. Proof of non-duplication of benefits."]
[null,null,null,null,"5. City of St. Louis Business License, dated within the last 12 months."]
[null,null,null,null,"a. Owner/Applicant Articles of Incorporation, if applicable.","Articles of Incorporation, if applicable"]
[null,null,null,null,"b. Owner/Applicant By-Laws, if applicable.","By-Laws, if applicable"]
[null,null,null,null,"c. Owner/Applicant Certificate of Incorporation, if applicable.","Certificate of Incorporation, if applicable"]
[null,null,null,null,"d. Owner/Applicant IRS Non-Profit Determination Letter 501(C)(3) federal Tax Exemption Letter, if applicable.","IRS Non-Profit Determination Letter 501(C)(3) federal Tax Exemption Letter, if applicable"]
[null,null,null,null,"6. Evidence of Proper Zoning."]
[null,null,null,null,"7. Copy of active Land Use Restriction Agreement if Owner/Applicant is not Tax-Exempt."]
[null,null,null,null,"8. Documented tornado related damage with date-of-loss evidence."]
[null,null,null,null,"Tornado Repair & Preservation Grant Application Worksheets (tabs)"]
[null,null,null,null,"Tab 1. Tornado Repair & Preservation Grant Application"]
[null,null,null,null,"Tab 2. Tornado Repair & Preservation Grant Application"]
[null,null,null,null,"Tab 3. Construction Costs"]
[null,null,null,null,"Tab 4. Sources & Uses"]
[null,null,null,null,"Tab 5. Units & Revenue"]
[null,null,null,null,"Tab 6. Operating Budget"]
[null,null,null,null,"Tab 7. Living Wage"]
[null,null,null,null,"Tab 8. 1099"]
[null,null,null,null,"Tab 9. New Owner, if owner is materially different than on May 16, 2025."]
[]
[null,"AHC STAFF USE ONLY"]
[null,"Date Received:",null,null,null,null,null,"Time Received:",null,null,null,null,null,"By (initials)"]
[]
[null,"Proposal Complete?",null,null,null,null,"YES",null,null,"NO"]

{"sheet":"Evaluation","index":12,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":true,"merged":[[49,0,49,3],[49,4,49,5],[49,8,49,9],[59,0,61,10],[51,0,51,3],[57,0,57,3],[57,4,57,5],[57,8,57,9],[53,0,55,10],[51,4,51,10],[47,0,47,6],[47,7,47,10],[19,6,19,9],[24,0,26,10],[13,0,13,7],[16,3,16,9],[14,0,14,7],[29,0,31,10],[34,0,36,10],[39,0,41,10],[44,0,45,10],[1,9,1,10],[1,0,1,1],[1,2,1,3],[18,0,18,9],[17,0,17,9],[4,9,4,10],[5,9,5,10],[6,9,6,10],[2,1,2,4],[2,7,2,10],[2,5,2,6],[3,9,3,10]]}
[]
["PROPOSAL #:",null,null,null,null,null,null,null,"Ward #",{"$f":"'1) Application'!O38","v":0}]
["NAME:",{"$f":"project","v":0},null,null,null,"OWNER:",null,{"$f":"dev","v":0}]
[null,null,null,null,null,null,null,null,"Amount Requested:",{"$f":"'4) Sources & Uses'!E21","v":0}]
[null,null,null,null,null,null,null,null,"Total Cost:",{"$f":"Review!F33","v":0}]
[null,null,null,null,null,null,null,null,"Number of Damaged LMI Units:",{"$f":"'1) Application'!U58","v":0}]
[null,null,null,null,null,null,null,null,"Total Number of Damaged Units:",{"$f":"'1) Application'!J52:K52","v":0}]
["PROPOSAL DESCRIPTION (including leverage sources)"]
[]
[]
[]
[]
[]
["Calculation of Grant Funds Per Affordable Unit Rehabilitated.",null,null,null,null,null,null,null,null,null,{"$f":"J4/J6","v":{"$error":"#DIV/0!"}}]
["Calculation of % of total project budget to requested amount:",null,null,null,null,null,null,null,null,null,{"$f":"J4/J5","v":{"$error":"#DIV/0!"}}]
[]
["NOFA Priority:"]
["Applicant is a certified Community Development Corporation",null,null,null,null,null,null,null,null,null,{"$f":"'1) Application'!S14","v":0}]
["Applicant is a non-profit, mission-driven affordable housing provider",null,null,null,null,null,null,null,null,null,{"$f":"'1) Application'!S13","v":0}]
[null,null,null,null,null,null,"Receives Priority Consideration",null,null,null,{"$f":"IF(OR(K18=\"Yes\", K19=\"Yes\"), \"Yes\", \"No\")","v":"No"}]
[]
["Insured May 16, 2025?",null,null,{"$f":"'1) Application'!J115","v":0},null,"If No:",{"$f":"'1) Application'!B118","v":0}]
[]
["Eligibility:"]
[]
[]
[]
[]
["Project Readiness & Contractor Capacity"]
[]
[]
[]
[]
["Costs, Cost/Benefit,  of Affordable Housing Preservation"]
[]
[]
[]
[]
["Organizational Capacity"]
[]
[]
[]
[]
["Additional Comments/Observations"]
[]
[]
[]
["DISCLOSURE OF COMMISSIONER CONFLICT (if any):",null,null,null,null,null,null,"N/A"]
[]
["STAFF RECOMMENDATION:",null,null,null,null,null,null,"Amount:"]
[]
["REASONS NOT TO FUND:"]
[]
["STAFF RECOMMENDED TERMS: "]
[]
[]
[]
["COMMISSION APPROVAL:",null,null,null,null,null,null,"Amount:"]
[]
["COMMISSION RECOMMENDED TERMS: "]

{"sheet":"Review","index":13,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":true,"merged":[[0,8,0,9],[3,2,3,5],[1,8,1,9],[2,8,2,9],[0,1,0,5],[1,2,1,5],[2,2,2,5],[9,5,9,6],[9,8,9,9],[10,5,10,6],[11,5,11,6],[4,2,4,3],[4,4,4,6]]}
["Project Name:",{"$f":"'1) Application'!F36","v":0},null,null,null,null,null,"Neighborhood:",{"$f":"'1) Application'!R37","v":0}]
["Project Number:",null,{"$f":"Evaluation!C2:D2","v":0},null,null,null,null,"Ward:",{"$f":"'1) Application'!O38","v":0}]
["Owner/Applicant:",null,{"$f":"'1) Application'!E7","v":0},null,null,null,null,"Project Address:",{"$f":"'1) Application'!F37","v":0}]
["Funding Request:",null,{"$f":"'4) Sources & Uses'!E21","v":0}]
["Total Cost:",null,{"$f":"F33","v":0}]
["Insured May 16, 2025:",null,{"$f":"'1) Application'!J115","v":0}]
["Reason Not Insured:",null,{"$f":"'1) Application'!B118","v":0}]
["Explanation:",null,{"$f":"'1) Application'!J119","v":0}]
[]
["Income Served","# Units","LMI Units",null,null,"Timeframe",null,{"$f":"'1) Application'!N185","v":0},"Months after October 2026"]
["20% AMI",{"$f":"'1) Application'!J60","v":0},null,null,null,"Complete",null,{"$f":"'1) Application'!N182","v":0},{"$f":"'1) Application'!Q182","v":0}]
["30% AMI",{"$f":"'1) Application'!J59","v":0},null,null,null,"Occupied",null,{"$f":"'1) Application'!N183","v":0},{"$f":"'1) Application'!Q183","v":0}]
["40% AMI",{"$f":"'1) Application'!J58","v":0}]
["50% AMI",{"$f":"'1) Application'!J57","v":0}]
["60% AMI",{"$f":"'1) Application'!J56","v":0}]
["70% AMI",{"$f":"'1) Application'!J55","v":0}]
["80% AMI",{"$f":"'1) Application'!J54","v":0}]
["Market-Rate",{"$f":"'1) Application'!J53","v":0}]
["Total",{"$f":"SUM(B11:B18)","v":0},{"$f":"'1) Application'!U57","v":0}]
[]
[]
["Sources of Funds",null,null,null,null,"Amount",null,"% of Total Cost","Status"]
["Owner Equity",null,null,null,null,{"$f":"'4) Sources & Uses'!E22","v":0},null,{"$f":"F23/$C$5","v":{"$error":"#DIV/0!"}},{"$f":"'4) Sources & Uses'!H22:J22","v":0}]
["Insurance Payout",null,null,null,null,{"$f":"'4) Sources & Uses'!E23","v":0},null,{"$error":"#DIV/0!"},{"$f":"'4) Sources & Uses'!H23:J23","v":0}]
["FEMA Assistance",null,null,null,null,{"$f":"'4) Sources & Uses'!E24","v":0},null,{"$error":"#DIV/0!"},{"$f":"'4) Sources & Uses'!H24:J24","v":0}]
[{"$f":"'4) Sources & Uses'!B25","v":"Source 4: "},null,null,null,null,{"$f":"'4) Sources & Uses'!E25","v":0},null,{"$error":"#DIV/0!"},{"$f":"'4) Sources & Uses'!H25:J25","v":0}]
[{"$f":"'4) Sources & Uses'!B26","v":"Source 5:"},null,null,null,null,{"$f":"'4) Sources & Uses'!E26","v":0},null,{"$error":"#DIV/0!"},{"$f":"'4) Sources & Uses'!H26:J26","v":0}]
[{"$f":"'4) Sources & Uses'!B27","v":"Source 6:"},null,null,null,null,{"$f":"'4) Sources & Uses'!E27","v":0},null,{"$error":"#DIV/0!"},{"$f":"'4) Sources & Uses'!H27:J27","v":0}]
[{"$f":"'4) Sources & Uses'!B21","v":"Grant requested*"},null,null,null,null,{"$f":"'4) Sources & Uses'!E21","v":0},null,{"$error":"#DIV/0!"},"Pending"]
[{"$f":"'4) Sources & Uses'!B28","v":"Total Sources"},null,null,null,null,{"$f":"SUM(F23:G29)","v":0},null,{"$f":"SUM(H23:H29)","v":{"$error":"#DIV/0!"}}]
[]
["Summary",null,null,null,null,"Amount",null,"% of Total Cost"]
["Total Cost (Includes Insurance Deductible)",null,null,null,null,{"$f":"F34+'1) Application'!J129","v":0},null,1]
["Total Repair Cost",null,null,null,null,{"$f":"'4) Sources & Uses'!E17","v":0},null,{"$f":"F34/F33","v":{"$error":"#DIV/0!"}}]
["Repair Gap (Cost to repair prior to Grant)",null,null,null,null,{"$f":"'1) Application'!N153","v":0},null,{"$f":"F35/F33","v":{"$error":"#DIV/0!"}}]
["Requested Grant",null,null,null,null,{"$f":"F29","v":0},null,{"$f":"F36/F33","v":{"$error":"#DIV/0!"}}]
[{"$f":"'1) Application'!B155","v":"Gap after City Funded Grant"},null,null,null,null,{"$f":"'1) Application'!N155","v":0},null,{"$f":"F37/F33","v":{"$error":"#DIV/0!"}}]
["Hard Construction Cost",null,null,null,null,{"$f":"'3) Construction Costs'!K73","v":0},null,{"$f":"F38/$C$5","v":{"$error":"#DIV/0!"}}]
["Soft Costs",null,null,null,null,{"$f":"'4) Sources & Uses'!E12+'4) Sources & Uses'!E13+'4) Sources & Uses'!E14+'4) Sources & Uses'!E15+'4) Sources & Uses'!E16","v":0},null,{"$f":"F39/$C$5","v":{"$error":"#DIV/0!"}}]
["Contingency",null,null,null,null,{"$f":"'3) Construction Costs'!K72","v":0},null,{"$f":"F40/$C$5","v":{"$error":"#DIV/0!"}}]
["Repair Cost Per Damaged LMI Unit",null,null,null,null,{"$f":"F33/'1) Application'!U58","v":{"$error":"#DIV/0!"}}]
["Cost Per Square Foot",null,null,null,null,{"$f":"'2) Repair Budget'!N80","v":{"$error":"#DIV/0!"}}]
["Grant Per Damaged LMI Unit",null,null,null,null,{"$f":"F29/'1) Application'!U58","v":{"$error":"#DIV/0!"}}]
["Return on Public Investment per year affordability",null,null,null,null,{"$f":"F36/6","v":0}]
["Leveraging Ratio",null,null,null,null,{"$f":"F33/F36","v":{"$error":"#DIV/0!"}}]
["Net Operating Income",null,null,null,null,{"$f":"'6) Operating Budget'!I36","v":0},null,{"$f":"F46/'1) Application'!U58","v":{"$error":"#DIV/0!"}},"NOI/Unit"]
["Insurance Payout Per Damaged LMI Unit",null,null,null,null,{"$f":"('1) Application'!J127+'1) Application'!J128)/'1) Application'!U58","v":{"$error":"#DIV/0!"}}]
["Owner Equity Per Damaged LMI Unit",null,null,null,null,{"$f":"'1) Application'!N143/'1) Application'!U58","v":{"$error":"#DIV/0!"}}]
["If Ownership has Materially Changed since May 16, 2025:",null,null,null,null,{"$f":"'9) New Owner'!B13","v":0},"Serves a public purpose"]
[null,null,null,null,null,{"$f":"'9) New Owner'!B14","v":0},"Preserves the recovery objectives of the program"]
[null,null,null,null,null,{"$f":"'9) New Owner'!B15","v":0},"Advances the City’s recovery goals"]

{"sheet":"Rate","index":14,"n_rows":44,"n_cols":18,"rows_kept":44,"cut":false,"hidden":true,"merged":[[26,0,27,0],[26,1,26,2],[26,3,26,4],[26,5,26,6],[26,7,26,8],[26,9,26,10],[26,11,26,12],[27,1,27,8],[27,9,27,16],[26,15,26,16],[39,7,39,12],[39,13,39,18],[30,7,30,8],[30,9,30,10],[35,13,35,18],[34,17,34,18],[43,13,43,18],[42,0,43,0],[34,0,35,0],[31,1,31,6],[31,7,31,12],[31,13,31,18],[30,0,31,0],[35,1,35,6],[38,0,39,0],[43,1,43,6],[43,7,43,12],[39,1,39,6],[42,11,42,12],[38,13,38,14],[23,1,23,6],[23,7,23,12],[23,13,23,18],[22,0,23,0],[20,1,20,6],[20,7,20,12],[22,1,22,2],[22,3,22,4],[22,5,22,6],[22,7,22,8],[22,9,22,10],[22,11,22,12],[22,13,22,14],[22,17,22,18],[38,11,38,12],[30,17,30,18],[42,15,42,16],[42,17,42,18],[38,17,38,18],[34,1,34,2],[34,3,34,4],[34,5,34,6],[34,7,34,8],[34,9,34,10],[34,11,34,12],[34,13,34,14],[34,15,34,16],[30,1,30,2],[30,3,30,4],[30,5,30,6],[42,7,42,8],[42,9,42,10],[42,1,42,2],[38,15,38,16],[30,11,30,12],[30,13,30,14],[30,15,30,16],[42,13,42,14],[15,0,16,0],[2,1,2,6],[11,11,11,12],[7,13,7,14],[8,13,8,18],[7,15,7,16],[7,17,7,18],[19,0,20,0],[2,11,2,17],[15,13,15,14],[15,15,15,16],[15,17,15,18],[15,11,15,12],[15,1,15,2],[15,3,15,4],[16,1,16,6],[16,7,16,12],[16,13,16,18],[7,0,8,0],[11,0,12,0],[20,13,20,18],[19,17,19,18],[1,1,1,6],[4,1,4,6],[3,1,3,6],[0,1,0,6],[0,8,0,10],[11,1,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[8,1,8,6],[8,7,8,12],[7,1,7,2],[7,3,7,4],[7,5,7,6],[7,11,7,12],[0,11,0,17],[1,11,1,17],[7,7,7,8],[7,9,7,10],[11,13,11,14],[42,3,42,4],[42,5,42,6],[11,15,11,16],[12,9,12,16],[26,13,26,14],[22,15,22,16],[19,1,19,2],[19,3,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[19,13,19,14],[19,15,19,16],[15,5,15,6],[15,7,15,8],[15,9,15,10],[12,1,12,8],[35,7,35,12],[38,1,38,2],[38,3,38,4],[38,5,38,6],[38,7,38,8],[38,9,38,10]]}
["Project Number:",{"$f":"Evaluation!C2","v":0},null,null,null,null,null,null,"Neighborhood:",null,null,{"$f":"'1) Application'!R37","v":0}]
["Project Name:",{"$f":"'1) Application'!F36","v":0},null,null,null,null,null,null,null,null,"Ward:",{"$f":"'1) Application'!O38","v":0}]
["Owner/Applicant:",{"$f":"'1) Application'!E7","v":0},null,null,null,null,null,null,null,null,"Project Address:",{"$f":"'1) Application'!F37","v":0}]
["Funding Request:",{"$f":"'4) Sources & Uses'!E21","v":0}]
["Total Cost:",{"$f":"Review!F33","v":0}]
[]
["Date of Rating:"]
["Priorities: The proposal attains the NOFA priorities.",1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9]
[null,"Proposal is not a priority. ",null,null,null,null,null,"Does not attain priority status, but meets basic qualifications",null,null,null,null,null,"High Priority: Owner/Applicant is a CDC or a mission-driven nonprofit organization"]
[]
[]
["Target Area: The proposed project is located in the Tornado Impact Area",1,null,2,null,3,null,4,null,5,null,6,null,7,8,8]
[null,"Not located in Tornado Impact Area",null,null,null,null,null,null,null,"Located in the Tornado Impact Area."]
[]
[]
["Targeted Households: The proposed project provides affordable housing to income-eligible households.",1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9]
[null,"Not eligible: Market-Rate",null,null,null,null,null,"Meets eligibility ≤80% AMI",null,null,null,null,null,"Exceeds eligibility ≤50%-60% AMI or below AMI"]
[]
[]
["Capacity: The applicant sufficiently demonstrates capacity to commence construction within 6 months of contract execution and successfully complete the project within 12-months.",1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9]
[null,"Below: Fails to demonstate ability to marshal resources, commence construction and successfully complete the project and maintain it as affordable for 6 years.",null,null,null,null,null,"Owner/Applicant's limited experience, abilities, and/or financial resources make this project a challenge.  Consider scaling the project down or hiring a consultant.",null,null,null,null,null,"Exceeds: Confident Owner/Applicant is capable of undertaking and completing this project and preserving LMI units for 6-years."]
[]
["Financial Strength: The applicant has the capacity, resources and expertise to leverage needed financing to complete the project.",1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9]
[null,"Poor/insufficient or not                    adequately leveraged",null,null,null,null,null,"Limited equity invested and/or financial capacity",null,null,null,null,null,"Financial sources identified and/or raised and adequate equity invested"]
[]
[]
["Scope of work: The proposed repairs are reasonable and necessary to return the damaged LMI units to full habitability.",1,null,2,null,3,null,4,null,5,null,6,null,7,null,8]
[null,"Scope of work is unclear, inappropriate, or not sufficient for repairing units to full habitability",null,null,null,null,null,null,null,"Scope of work is reasonable and necessary to restore units for full habitability for 6-years"]
[]
[]
["Construction Costs: The proposed costs to repair the units for full habitability are reasonable and necessary.",1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9]
[null,"Budget is not clear nor well-defined",null,null,null,null,null,"Budgeted costs are too low or too high",null,null,null,null,null,"Budget is clear and well defined and costs are reasonable"]
[]
[]
["Need for Housing Serving Vulnerable Residents: The number of units serving very low-income residents, seniors, people with disabilities, and other vulnerable people justifies the costs.",1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9]
[null,"Below",null,null,null,null,null,"Meets",null,null,null,null,null,"Exceeds"]
[]
[]
["Tornado Damage Documented: The applicant provided sufficient documentation of tornado-related damage with date of loss estimates.",1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9]
[null,"Below",null,null,null,null,null,"Meets",null,null,null,null,null,"Exceeds"]
[]
[]
["Cost/Benefit of Affordable Housing Preservation: Preserving these affordable units supports the case for public investment.",1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9]
[null,"Below",null,null,null,null,null,"Meets",null,null,null,null,null,"Exceeds"]