{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["INSTRUCTIONS","1) Application","2) Development Budget","3) Construction Costs","4) Sources & Uses","5) MVA","6) Priorities","7) UD","8) Living Wage","9) SIS","10) 1099","11) Compliance Info","Evaluation","Review","Rating"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":5,"defined_names":174,"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,3],[18,6,18,7],[6,6,6,7],[11,0,11,2],[11,6,11,7],[14,0,14,2],[14,6,14,7],[18,0,18,2],[39,0,39,2],[2,0,2,2],[6,0,6,2],[34,0,34,2],[25,0,25,2],[37,0,37,2],[38,0,38,2],[27,0,27,2],[23,0,23,2]]}
["INSTRUCTIONS FOR COMPLETING THE AHC FOR SALE APPLICATION & PROFORMA WORKSHEETS"]
[]
["General Instructions"]
[null,"A.","You will only be able to enter information into yellow input cells. All other cells are protected for AHC use."]
[null,"B.","Complete the following worksheets in the order corresponding to their numbering: 1) Application, 2) Development Budget, 3) Construction Costs, 4) Sources & Uses, 5) MVA, 6) Priorities, 7) UD (Universal Design), 8) Living Wage, 9) SIS (Sustainability Impact Statement), and 10) 1099."]
[null,"C.","To print this entire file, click on File>Print and select \"Print Entire Workbook.\" "]
["1) Application"]
[null,"A.","This is the general application form.  Insert the amount of your request in Cell Q64.  The amount of your request will automatically flow to the Source & Use Worksheet."]
[null,"B.","Fill in all applicable yellow cells.  Many sections will prompt you with drop-down menus."]
[null,"C.","Include all documents and exhibits listed in the Application Checklist (Section VIII) with each of the three hard copy applications.  Email this Excel Spreadsheet file to AHC's Housing Analyst at: hinerl@stlouis-mo.gov.  Applicants must also submit three (3) printed hard copy applications (worksheets 1-11) with all exhibits and original signatures on the final certifications page. One copy must be in a three-ring binder, with tabs corresponding to each number (on this checklist). Two (2) copies must be secured with a single binder clip and submitted without tabs, staples or paperclips.  3) Applicants must also provide a complete copy of the application and all exhibits on a labeled USB Flash drive."]
[null,"D.","When you print a hard copy of this file, be sure to carefully read and sign the certifications on the final page.  Submit the three (3) hard copies with original signatures to AHC."]
["2) Development Budget"]
[null,"A.","Enter development costs for the project.  Note: construction costs are entered on the Construction Cost Tab (Worksheet 3)."]
[null,"B.","The worksheet will automatically calculate the Development Subsidy needed."]
["3) Construction Costs"]
[null,"A.","Enter detailed construction costs."]
[null,"B.","Note AHC's limits for overhead, general conditions and profits.  Stay within the allowable percentage limits."]
[null,"C.","After completing this sheet, check worksheet 2 (Development Budget Worksheet) to insure applicable cost data transferred properly."]
["4) Proforma Summary - Sources & Uses"]
[null,"A.","Enter all permanent sources of financing, debt, and equity."]
[null,"B.","Enter all construction sources along with interest rates. Some may be identical to permanent sources."]
[null,"C.","Check that permanent sources = uses AND that construction sources = uses."]
[null,"D.","Enter additional information if necessary in the \"Developer's Notes\" section at the bottom of the sheet."]
["5) Market Value Analysis (MVA)"]
[null,"A.","This section is one (1) page. Follow instructions."]
["6) Priorities (to be Attained)"]
[null,"A.","All projects MUST provide housing for households ≤80% AMI.  This section outlines AHC's priorities for this funding round. Projects that attain funding priorities will receive priority consideration."]
["7) Universal Design Budget"]
[null,"A.","If new construction, input costs attributed to making the AHC-Assisted Units Universally Designed. Sign the UD certification at the end of the Application (Worksheet 1)."]
["8) Living Wage Acknowledgment and Acceptance Declaration"]
[null,"A.","Complete this form.  If the applicant is a non-profit agency that has previously received funding from AHC and there have been no changes to your agency's non-profit status, Articles of Incorporation and By-laws, sign the No Change Affidavit."]
["9) Sustainability Impact (SIS)"]
[null,"A.","Indicate all activities in your project that advance the City's Sustainability Plan."]
["10) 1099",null,"Print and complete this form."]
["11) Compliance Info"]
[null,"A.","This sheet outlines AHC's program & eligibility requirements."]
[null,"B.","You will not input information on this sheet, but should review it to insure your project remains within Program Limits."]

{"sheet":"1) Application","index":1,"n_rows":484,"n_cols":21,"rows_kept":484,"cut":false,"hidden":false,"merged":[[30,6,30,12],[26,1,26,8],[24,9,24,10],[29,9,29,10],[57,16,57,17],[212,9,212,10],[213,9,213,10],[338,1,345,20],[254,17,254,18],[254,14,254,16],[254,5,254,13],[239,8,239,13],[215,18,215,19],[195,17,195,20],[193,17,193,20],[218,12,218,17],[218,18,218,19],[218,9,218,10],[215,2,215,8],[216,2,216,8],[216,9,216,10],[217,18,217,19],[139,17,139,20],[210,12,210,14],[469,2,469,20],[415,5,415,14],[360,1,360,19],[236,14,236,16],[227,1,227,20],[198,16,198,17],[424,5,424,14],[424,17,424,20],[422,2,422,4],[422,5,422,20],[409,13,409,14],[409,15,409,20],[418,13,418,14],[417,5,417,14],[408,1,408,20],[409,1,409,12],[410,2,411,20],[412,2,412,4],[412,5,412,20],[216,18,216,19],[413,14,413,20],[298,1,298,3],[249,14,249,16],[217,12,217,17],[253,14,253,16],[252,14,252,16],[295,1,295,3],[249,17,249,18],[250,17,250,18],[250,14,250,16],[484,0,485,20],[463,1,463,20],[482,1,482,9],[482,12,482,20],[470,2,470,20],[471,2,471,20],[472,2,472,20],[476,12,476,20],[423,2,423,20],[480,1,480,9],[480,12,480,20],[473,2,473,20],[476,1,476,9],[454,3,454,10],[448,0,448,20],[450,0,450,1],[450,3,450,10],[450,16,450,20],[236,17,236,18],[221,1,225,20],[238,14,238,16],[238,17,238,18],[237,2,241,7],[239,17,239,18],[237,17,237,18],[237,8,237,13],[219,9,219,10],[219,18,219,19],[219,12,219,17],[235,1,235,20],[228,1,233,20],[6,5,6,20],[8,7,8,10],[8,14,8,15],[7,17,7,20],[7,5,7,13],[6,1,6,4],[7,1,7,4],[8,19,8,20],[14,1,14,10],[7,14,7,16],[8,16,8,18],[8,11,8,13],[8,1,8,4],[8,5,8,6],[11,13,11,20],[12,13,12,20],[13,13,13,20],[14,13,14,20],[10,1,10,6],[11,1,11,10],[12,1,12,10],[13,1,13,10],[28,9,28,10],[23,9,23,10],[22,13,22,19],[27,9,27,10],[29,1,29,8],[15,1,15,10],[16,1,16,10],[28,16,28,18],[27,1,27,8],[25,12,25,21],[23,20,23,21],[28,1,28,8],[132,1,132,8],[129,1,129,9],[121,1,121,11],[152,1,152,14],[151,19,151,20],[152,19,152,20],[125,6,125,12],[21,9,21,10],[21,13,21,19],[23,13,23,19],[33,1,40,20],[31,6,31,12],[58,16,58,17],[63,16,63,18],[58,2,58,15],[42,1,54,20],[21,1,21,8],[25,1,25,8],[23,1,23,8],[24,1,24,8],[22,1,22,8],[22,9,22,10],[26,9,26,10],[25,9,25,10],[125,13,125,15],[109,1,109,4],[105,2,105,18],[126,8,126,10],[108,1,108,4],[116,1,118,20],[126,17,126,20],[110,1,110,4],[111,5,111,9],[110,10,110,11],[110,12,110,13],[123,13,123,14],[122,13,122,14],[106,16,106,17],[112,14,112,16],[112,5,112,9],[112,10,112,11],[177,1,177,15],[87,1,87,4],[129,15,129,16],[128,1,128,15],[127,5,127,9],[109,19,109,20],[109,14,109,16],[109,17,109,18],[109,10,109,11],[108,17,108,18],[106,18,106,19],[108,10,108,11],[108,12,108,13],[104,14,104,16],[131,1,131,8],[111,19,111,20],[111,1,111,4],[113,1,113,4],[112,1,112,4],[113,5,113,9],[177,18,177,19],[159,7,159,12],[112,12,112,13],[128,16,128,17],[57,1,57,15],[65,16,65,18],[76,19,76,20],[67,2,67,13],[73,11,73,16],[73,1,73,10],[71,11,71,16],[72,17,72,19],[73,17,73,19],[74,17,74,19],[76,16,76,18],[75,17,75,19],[75,1,75,12],[213,2,213,8],[196,1,196,15],[143,1,144,20],[151,1,151,14],[113,10,113,11],[132,12,132,13],[133,12,133,13],[137,1,138,20],[133,1,133,11],[113,14,113,16],[115,1,115,20],[126,5,126,7],[126,1,126,4],[163,7,163,9],[140,15,140,20],[146,1,146,14],[147,1,147,14],[148,1,148,14],[139,1,139,14],[139,15,139,16],[145,19,145,20],[146,19,146,20],[147,19,147,20],[149,1,149,17],[102,1,102,15],[104,2,104,13],[106,2,106,8],[106,13,106,15],[157,14,157,20],[83,1,83,3],[83,13,83,15],[66,16,66,18],[64,16,64,18],[84,16,84,20],[84,14,84,15],[84,5,84,13],[85,14,85,20],[85,3,85,11],[85,12,85,13],[72,1,72,12],[74,13,74,14],[75,13,75,14],[74,1,74,12],[71,1,71,10],[67,16,67,18],[72,13,72,14],[76,12,76,14],[76,1,76,8],[83,16,83,20],[71,17,71,19],[299,1,299,3],[265,7,265,8],[265,15,265,16],[265,18,265,19],[79,1,81,20],[241,14,241,16],[241,8,241,13],[259,1,259,5],[260,1,260,5],[266,7,266,8],[268,18,268,19],[282,1,286,20],[264,1,264,5],[265,1,265,5],[266,1,266,5],[257,7,257,8],[260,7,260,8],[260,15,260,16],[260,18,260,19],[252,17,252,18],[83,4,83,12],[108,5,108,9],[84,1,84,4],[85,1,85,2],[468,2,468,20],[464,2,464,20],[465,2,465,20],[466,2,466,20],[467,2,467,20],[351,4,351,11],[351,13,351,15],[355,1,355,19],[352,1,352,3],[353,1,353,11],[351,16,351,20],[371,1,373,20],[419,1,419,14],[415,2,417,4],[415,15,418,20],[418,1,418,12],[416,5,416,14],[414,2,414,4],[413,2,413,13],[451,3,451,9],[433,20,433,21],[435,1,437,20],[438,1,446,20],[428,2,428,4],[428,17,428,20],[350,4,350,20],[352,4,352,20],[354,1,354,11],[354,12,354,13],[354,15,354,19],[350,1,350,3],[353,12,353,13],[353,15,353,19],[362,1,362,20],[357,1,357,19],[356,1,356,19],[358,1,358,19],[359,1,359,19],[351,1,351,3],[414,5,414,14],[414,16,414,17],[425,2,427,4],[425,5,425,14],[406,2,406,21],[393,1,393,21],[394,1,394,21],[420,2,421,20],[392,2,392,21],[429,1,431,4],[429,5,429,14],[429,15,432,20],[430,5,430,14],[431,5,431,14],[425,15,427,20],[426,5,426,14],[427,5,427,14],[363,1,368,20],[383,1,383,21],[384,1,384,21],[381,1,381,21],[382,1,382,21],[378,1,378,21],[379,1,379,21],[380,1,380,21],[377,1,377,21],[376,12,376,21],[389,2,389,21],[391,2,391,20],[390,2,390,21],[370,1,370,20],[428,5,428,14],[428,15,428,16],[175,1,175,15],[176,18,176,19],[165,11,165,15],[165,16,165,20],[175,18,175,19],[172,17,172,18],[165,2,165,5],[165,7,165,9],[244,8,244,13],[181,17,181,20],[190,1,190,20],[295,18,295,20],[296,18,296,20],[245,17,245,18],[245,14,245,16],[220,1,220,20],[240,17,240,18],[219,2,219,8],[148,19,148,20],[150,19,150,20],[174,1,174,15],[174,18,174,19],[157,7,157,12],[149,19,149,20],[162,2,162,5],[210,9,210,10],[208,9,208,10],[210,2,210,8],[176,1,176,16],[206,1,206,12],[181,3,181,6],[181,7,181,8],[182,7,182,8],[184,1,184,20],[191,17,191,20],[194,1,194,15],[185,1,188,20],[182,1,182,6],[181,12,181,13],[193,1,193,15],[192,1,192,15],[196,17,196,20],[259,18,259,19],[296,1,296,3],[269,1,269,5],[281,1,281,20],[268,15,268,16],[261,1,261,5],[262,1,262,5],[263,1,263,5],[289,1,292,20],[287,1,288,20],[271,3,271,4],[273,1,273,20],[269,7,269,8],[269,15,269,16],[269,18,269,19],[271,11,271,13],[271,19,271,20],[261,7,261,8],[268,7,268,8],[259,7,259,8],[295,4,295,9],[296,4,296,9],[179,5,179,18],[195,1,195,15],[197,1,197,15],[197,17,197,20],[209,9,209,10],[247,14,247,16],[192,17,192,20],[246,8,246,13],[247,8,247,13],[212,12,212,14],[217,2,217,8],[241,17,241,18],[244,14,244,16],[240,8,240,13],[240,14,240,16],[242,14,242,16],[246,17,246,18],[243,14,243,16],[245,8,245,13],[242,2,245,7],[244,17,244,18],[247,17,247,18],[246,14,246,16],[208,2,208,8],[140,1,140,14],[168,1,168,5],[168,6,168,8],[156,14,156,20],[158,7,158,12],[158,14,158,20],[171,13,171,15],[171,17,171,18],[169,6,169,8],[159,14,159,20],[150,1,150,14],[164,2,164,5],[164,7,164,9],[164,16,164,20],[153,14,155,20],[156,7,156,12],[168,9,168,11],[168,12,168,14],[169,1,169,5],[163,16,163,20],[169,9,169,15],[162,7,162,9],[163,11,163,15],[163,2,163,5],[86,1,86,2],[86,3,86,9],[96,14,96,18],[148,25,148,38],[97,14,97,15],[108,19,108,20],[109,5,109,9],[112,19,112,20],[110,17,110,18],[113,19,113,20],[111,12,111,13],[111,14,111,16],[113,17,113,18],[110,19,110,20],[111,17,111,18],[112,17,112,18],[113,12,113,13],[110,5,110,9],[110,14,110,16],[129,10,129,14],[126,14,126,16],[125,16,125,18],[126,11,126,13],[129,17,129,20],[94,14,94,18],[90,4,90,16],[94,3,94,9],[96,3,96,9],[95,14,95,18],[86,16,86,19],[86,12,86,14],[86,10,86,11],[87,5,87,9],[97,1,97,13],[111,10,111,11],[95,3,95,9],[266,15,266,16],[266,18,266,19],[268,1,268,5],[180,5,180,18],[172,1,172,12],[172,13,172,15],[169,16,169,18],[109,12,109,13],[102,16,102,17],[106,11,106,12],[108,14,108,16],[238,8,238,13],[243,17,243,18],[242,17,242,18],[122,1,122,11],[124,6,124,12],[121,12,121,14],[131,12,131,13],[200,1,205,20],[206,13,206,14],[123,1,123,11],[406,25,406,44],[395,1,395,21],[396,2,396,21],[397,2,397,21],[398,2,398,21],[399,2,399,21],[400,2,400,21],[401,2,401,21],[402,2,402,21],[404,2,404,21],[405,2,405,21],[258,7,258,8],[258,15,258,16],[259,15,259,16],[295,10,295,17],[296,10,296,17],[297,10,297,17],[298,10,298,17],[299,10,299,17],[300,10,300,17],[274,1,280,20],[264,15,264,16],[264,18,264,19],[297,1,297,3],[262,18,262,19],[261,15,261,16],[261,18,261,19],[264,7,264,8],[262,15,262,16],[300,1,300,3],[262,7,262,8],[263,7,263,8],[263,15,263,16],[263,18,263,19],[293,19,293,20],[258,18,258,19],[194,17,194,20],[258,1,258,5],[253,17,253,18],[248,14,248,16],[251,14,251,16],[251,17,251,18],[248,17,248,18],[237,14,237,16],[239,14,239,16],[215,9,215,10],[215,12,215,17],[211,2,211,8],[211,12,211,14],[211,9,211,10],[213,12,213,14],[212,2,212,8],[218,2,218,8],[217,9,217,10],[216,12,216,17],[209,2,209,8],[246,2,247,7],[208,12,208,14],[209,12,209,14],[349,1,349,3],[349,4,349,20],[312,2,312,20],[315,1,315,20],[316,1,318,20],[328,1,328,19],[322,1,326,20],[320,1,320,19],[348,1,348,17],[330,1,334,20],[314,1,314,19],[321,1,321,20],[336,1,336,20],[329,1,329,20],[297,18,297,20],[298,18,298,20],[299,18,299,20],[300,18,300,20],[387,1,387,21],[388,1,388,21],[385,1,385,21],[386,1,386,21],[403,2,403,21],[311,2,311,20],[303,2,303,20],[304,2,304,20],[297,4,297,9],[298,4,298,9],[299,4,299,9],[300,4,300,9],[302,2,302,20],[301,1,301,20],[305,2,305,20],[306,2,306,20],[307,1,307,20],[308,2,308,20],[309,2,309,20],[310,2,310,20]]}
["FOR-SALE HOUSING PRODUCTION APPLICATION"]
["AFFORDABLE HOUSING COMMISSION"]
["AHC: (314) 657-3880"]
[]
["I.","General Information"]
["u","Development Information"]
[null,"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,"Zip:",null,null,null,null,null,"Ward:",null,null,null,null,"Census Tract:"]
[]
[null,"Property ID#:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total Number of Units planned",null,null,null,null,null,null,null,{"$f":"SUM(J23:K30)","v":0},null,"units",null,"Total Number of AHC-Assisted Units"]
[null,"Number of Market Rate Units",null,null,null,null,null,null,null,null,null,"units",null,"AHC-Assisted ≤20% AMI Units"]
[null,"Number of Low/Mod Units at 80% AMI",null,null,null,null,null,null,null,null,null,null,null,"# LMI Units",null,null,null,null,null,null,{"$f":"J24+J25+J26+J27+J28+J29+J30","v":0}]
[null,"Number of Low/Mod Units at 70% AMI"]
[null,"Number of Low/Mod Units at 60% AMI",null,null,null,null,null,null,null,null,null,null,"You Must Input # of Units in this Section"]
[null,"Number of Low/Mod Units at 50% AMI"]
[null,"Number of Low/Mod Units at 40% AMI"]
[null,"Number of Low/Mod Units at 30% AMI"]
[null,"Number of Low/Mod Units at 20% AMI"]
[null,"Construction Type"]
[null,"Housing Type"]
[null,"Project Summary  Briefly describe your project."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Project description (continued)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Do you plan to seek real property tax abatement for this development?"]
[null,null,"If yes, is development in a designated redevelopment area under:  "]
[]
[null,null,"Percent Occupied:",null,null,null,null,null,"%"]
[]
["u","Assistance Request Information"]
[null,null,"Amount requested?"]
[null,null,"Requested Forgivable Developer Subsidy?"]
[null,null,"Requested Repayable Buyer Subsidy (total sum)?"]
[null,null,"Number of Repayable Buyer Subsidies Requested:"]
[null,null,"Amount of each Repayable Buyer Subsidy:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per AHC-Assisted",null,null,null,"Subsidy per"]
[null,"AHC Funding Request",null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,"Unit",null,null,"20% AMI Unit"]
[null,"Short-Term Financing"]
[null,"AHC Construction Loan requested",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q65","v":0}]
[null,"Permanent Financing"]
[null,"AHC Development Subsidy requested",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q65","v":0}]
[null,"AHC Homebuyer Subsidy requested",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q66","v":0}]
[null,"Total AHC Funding",null,null,null,null,null,null,null,null,null,null,{"$f":"N75+N76","v":0},null,null,null,{"$f":"M77/U22","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(M77/U22)*U23","v":{"$error":"#DIV/0!"}}]
[]
[null,"Indicate preferred funding & repayment terms: "]
[]
[]
[]
["u","Developer Information"]
[null,"Entity Name:",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,"Phone:"]
[null,"Address:",null,null,null,null,null,null,null,null,null,null,"Email:"]
[null,"City:",null,null,null,null,null,null,null,null,"State:",null,null,null,null,"Zip:"]
[null,"Legal Form:"]
[]
[]
[]
[]
["u","General Partner/Corporate Officer Information (if applicable)"]
[null,"(List Managing General Partner on first line.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ownership %"]
[null,"Name:",null,null,null,null,null,null,null,null,"Fed. ID/Soc. Sec. #"]
[null,"Name:",null,null,null,null,null,null,null,null,"Fed. ID/Soc. Sec. #"]
[null,"Name:",null,null,null,null,null,null,null,null,"Fed. ID/Soc. Sec. #"]
[]
[]
[]
[]
["u","Previous Development Experience"]
[null,"Has the developer completed other residential development projects?"]
[null,null,"If yes, please answer the following:"]
[null,null,"How many projects has the developer completed?"]
[null,null,"How many dwelling units has the developer been responsible for producing?"]
[null,null,"New Construction",null,null,null,null,null,null,"#","units:",null,null,"Rehab",null,null,"# units:"]
[null,"List most recently completed projects:"]
[null,"Project Name",null,null,null,"Address",null,null,null,null,"Construct Type",null,"Tenure Type",null,"Target Residents",null,null,"# Units",null,"Total Dev. Costs"]
[]
[]
[]
[]
[]
[]
[null,"If developer has been involved in residential development projects in some other capacity, please specify:"]
[]
[]
[]
[]
["II.","Development Plan Information"]
[null,"Residential Floor Area planned",null,null,null,null,null,null,null,null,null,null,{"$f":"'2) Development Budget'!C7","v":0},null,null,"gross sq. ft."]
[null,"Total number of Buildings planned",null,null,null,null,null,null,null,null,null,null,null,null,null,"buildings"]
[null,"Age of existing Building(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,"years old"]
[null,"Construction Type",null,null,null,null,{"$f":"G31","v":0}]
[null,"Housing Type",null,null,null,null,{"$f":"G32","v":0},null,null,null,null,null,null,"# of Stories:"]
[null,"Structural System",null,null,null,null,null,null,"Basement",null,null,null,null,null,"Exterior"]
[null,"Parking"]
[null,"Is this project targeting special populations in addition to Low/Mod Income?"]
[null,"If yes, indicate which populations:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Other:"]
[]
[null,"# of Accessible Units Planned:"]
[null,"% Accessible (hearing) Units Planned:",null,null,null,null,null,null,null,null,null,null,"%"]
[null,"# of Universally Designed Units Planned:"]
[]
["u","New Construction - Must Adhere to National Green Building Standard"]
[]
[null,"All new construction projects must build to a national green building standard (LEED, Enterprise Green, NGBS, or EnergyStar with a RESNET energy auditor)."]
[]
[null,"This is a new construction project"]
[null,"If yes, indicate the national green building standard sought:"]
[]
["u","Energy Efficiency - Rehabilitation"]
[null,"AHC gives priority consideration for comprehensive rehabilitation projects designed and built to a national green building standard (Funding Priorities).  All other rehabilitation projects are encouraged to include the following sustainable features.  Indicate which sustainable features will be included."]
[]
[null,"Sealed combustion furnace (if gas) greater or equal to 92% AFUE, properly sized"]
[null,"High efficiency furnace (if electric), properly sized"]
[null,"Caulk and seal package"]
[null,"Energy Star bath exhaust fan with a timer"]
[null,"All newly installed appliances should be ENERGY STAR Certified"]
[null,"90% of lights should be LED"]
[null,"Low VOC paint & flooring "]
[null,"WaterSense certified plumbing fixtures"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sustainability Certification in addition to\nEPA Energy Star?  Describe:"]
[null,null,null,null,null,null,null,"Description:"]
[]
[null,"Heating System:"]
[null,"Air Conditioning System:"]
[null,"Domestic Hot Water:"]
[null,"Appliances:"]
[]
["u","Equipment included with Income Restricted Units"]
[null,null,"Microwave",null,null,null,null,"Refrigerator",null,null,null,"Kitchen Exhaust Duct",null,null,null,null,null,"Other:"]
[null,null,"Range & Oven",null,null,null,null,"Ceiling Fans",null,null,null,"Common On-site Laundry"]
[null,null,"Garbage Disposal",null,null,null,null,"Fireplace",null,null,null,"Security Alarm"]
[null,null,"Dishwasher",null,null,null,null,"Blinds/Drapes",null,null,null,"Laundry in unit"]
[]
["III.","Site Information"]
[null,"Form of Site Control:",null,null,null,null,null,null,null,"Price:"]
[null,"Date of Acquisition:",null,null,null,null,null,null,null,"Expiration date of option/contract:"]
[]
[null,"Total Site Area (purchased in this transaction):"]
[null,"Project Site Area (utilized for proposed development):"]
[]
[null,"Are any project buildings in a National or City historic district?"]
[null,"Are any project buildings within 300 feet of a park?"]
[null,"If YES, have you discussed your project w/ the Cultural Resources Office?"]
[null,"Property acquired from the City's Land Reutilization Authority?"]
[]
[null,"Seller's Name:"]
[null,"Mailing Address:"]
[null,"City:",null,null,null,null,null,"State:",null,null,null,"Zip:",null,null,null,"Phone:"]
[null,"Arms-Length Transaction?"]
[]
[null,"Explain the relationship between buyer and seller.  Provide sales contract from last arms-length transaction."]
[]
[]
[]
[]
[]
[null,"Of the project properties, list those with an existing mortgage as well as the outstanding loan amount:"]
[null,"Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mortgage Balance"]
[]
[]
[]
[]
[]
[]
[null,"Does current site zoning allow the proposed residential use?"]
[null,"If no, please explain what steps have been or will be taken to obtain zoning approval."]
[]
[]
[]
[]
[]
[]
[null,"Will the current site(s) require lots to be subdivided?"]
[null,"Are the following utilities now located on the site?"]
[null,null,"Public Water Supply",null,null,null,null,null,null,null,null,null,null,null,null,"Feet from Site"]
[null,null,"Public Sewer System",null,null,null,null,null,null,null,null,null,null,null,null,"Feet from Site"]
[null,null,"Natural Gas Distribution System",null,null,null,null,null,null,null,null,null,null,null,null,"Feet from Site"]
[null,null,"Electric Power System",null,null,null,null,null,null,null,null,null,null,null,null,"Feet from Site"]
[null,null,"Cable Television System",null,null,null,null,null,null,null,null,null,null,null,null,"Feet from Site"]
[null,null,"Telephone System",null,null,null,null,null,null,null,null,null,null,null,null,"Feet from Site"]
[null,"Are the following conditions present at the proposed development site?"]
[null,null,"All or part in 100-yr. floodplain",null,null,null,null,null,null,null,null,null,"Standing water"]
[null,null,"Railroad tracks within 300 feet",null,null,null,null,null,null,null,null,null,"Creek, lake, river frontage"]
[null,null,"High tension wires",null,null,null,null,null,null,null,null,null,"Ravines or steep grades"]
[null,null,"High noise levels",null,null,null,null,null,null,null,null,null,"Industrial sites"]
[null,null,"Hazardous waste sites",null,null,null,null,null,null,null,null,null,"Commercial sites"]
[null,"Please describe any other unusual site conditions:"]
[]
[]
[]
[]
[]
[]
[null,"Describe neighborhood assets such as high performing schools, employment options, low poverty, as well as, the project's alignment with a neighborhood plan, if one exists, and other noteworthy developments that may have a positive impact on the marketability of the development."]
[]
[]
[]
[]
[]
[]
["IV.","Development Schedule"]
[null,"In the chart below, enter the month and year that the item was accomplished, or for future events, the month and year when that item is expected to be accomplished.  If an item does not apply to your development, enter N/A or leave blank."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Month",null,null,"Year"]
[null,null,"Site",null,null,null,null,null,"Option"]
[null,null,null,null,null,null,null,null,"Contract"]
[null,null,null,null,null,null,null,null,"Closing"]
[null,null,null,null,null,null,null,null,"Zoning"]
[null,null,null,null,null,null,null,null,"Site Analysis"]
[null,null,"Construction Financing",null,null,null,null,null,"Application Submission"]
[null,null,null,null,null,null,null,null,"Conditional Commitment"]
[null,null,null,null,null,null,null,null,"Firm Commitment"]
[null,null,null,null,null,null,null,null,"Closing"]
[null,null,"Plans",null,null,null,null,null,"Preliminary Drawings"]
[null,null,null,null,null,null,null,null,"Working Drawings"]
[null,null,"Construction Loan Closing"]
[null,null,"Construction Start"]
[null,null,"Marketing Start-Up"]
[null,null,"Construction Complete"]
[null,null,"All Units Sold"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Construction Schedule:",null,null,null,"months"]
[null,null,null,null,null,"Number of months after January 2026",null,null,null,null,null,null,null,null,null,null,null,"months"]
["V.","Home Pricing & Market Assessment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projected",null,null,"AHC Repayable"]
[null,"Street Address",null,null,null,null,null,"SF",null,null,"BR",null,"BA",null,null,"Sale Price",null,null,"Buyer Subsidy"]
["Unit 1"]
["Unit 2"]
["Unit 3"]
["Unit 4"]
["Unit 5"]
["Unit 6"]
["Unit 7"]
["Unit 8"]
["Unit 9"]
["Unit 10"]
["Unit 11"]
["Unit 12"]
[null,"*Buyer Assistance typically ranges between $8,000 - $10,000 per home."]
["Square Feet:",null,null,{"$f":"SUM(H259:I271)","v":0},null,null,"Home Sale Proceeds",null,null,null,null,{"$f":"SUM(P259:Q271)","v":0},null,null,null,"Sum Buyer Subsidies",null,null,null,{"$f":"SUM(S259:T270)","v":0}]
[]
[null,"Describe how you determined the need/market demand for the proposed project."]
[]
[]
[]
[]
[]
[]
[]
[null,"Explain how you arrived at the projected home sales prices:"]
[]
[]
[]
[]
[]
[null,"Describe how you will pre-sell homes or market them during construction."]
[]
[]
[]
[]
[]
["VI.","Development Team Information"]
[null,null,null,null,"Name",null,null,null,null,"Address",null,null,null,null,null,null,null,null,"Phone"]
[null,"Contractor:"]
[null,"Consultant:"]
[null,"Attorney:"]
[null,"Tax Accountant:"]
[null,"Architect:"]
[null,"Engineer:"]
[null,"Track record of prime contractor — list the contractor's five most recently completed projects:"]
[null,"1."]
[null,"2."]
[null,"3."]
[null,"4."]
[null,"5."]
[null,"Track record of architect — list the architect's five most recently completed projects:"]
[null,"1."]
[null,"2."]
[null,"3."]
[null,"4."]
[null,"5."]
[]
[null,"Does developer or owner hold a direct financial interest in any other team member?"]
[null,"If yes, provide details of the relationship:"]
[]
[]
[]
[]
[null,"Is the Developer, Sponsor, or any other Development Team Member, including any of their owners, partners, or board members currently debarred from contracting opportunities by any agency or government?"]
[null,"If yes, please provide details:"]
[]
[]
[]
[]
[]
[]
[null,"Has the Developer, Sponsor, or any other Development Team Member listed on the previous page, including any of their owners, partners, or board members ever been debarred from contracting opportunities by any agency or government?"]
[null,"If yes, please provide details:"]
[]
[]
[]
[]
[]
[]
[null,"Market Value Analysis\nUsing the 2024 Residential Market Analysis (Tab 5) explain how the project is part of an equitable plan that strategically invests Trust Fund dollars to improve life for low and moderate-income households."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["VII.","Housing/Neighborhood Organization Sponsor"]
[null,"All projects must be sponsored by a housing or neighborhood organization."]
[null,"Name of sponsor:"]
[null,"Sponsor Address:"]
[null,"Sponsor phone:",null,null,null,null,null,null,null,null,null,null,null,"Sponsor Fax:"]
[null,"Sponsor email:"]
[null,"Is the sponsor a Community Based Development Organization (CBDO)?",null,null,null,null,null,null,null,null,null,null,null,null,null,"Is the Designation from CDA?"]
[null,"Is the sponsor a Community Housing Development Organization (CHDO)?",null,null,null,null,null,null,null,null,null,null,null,null,null,"Is the Designation from CDA?"]
[null,"Is the sponsor of the proposed development a non-profit?"]
[null,"If yes, is the non-profit designation registered with the State of Missouri?"]
[null,"Has a non-profit determination been made by the Internal Revenue Service?"]
[null,"If yes, indicate your Internal Revenue Code designation:"]
[]
[null,"Is \"fostering low-income housing\" listed among the nonprofit's purposes in Articles of Incorporation and/or By-Laws?  (Please provide copy)"]
[]
[null,"Explain the role and activities of the housing or neighborhood organization sponsor in the construction and ownership phases of the development."]
[]
[]
[]
[]
[]
[]
[]
[null,"Omissions: List all required documents that are not included in this application."]
[]
[]
[]
[]
[]
["VIII.","Application Checklist",null,null,null,null,null,null,null,null,null,null,{"$f":"F7","v":0}]
[null,"Email this Excel Spreadsheet file to AHC's Housing Analyst at: hinerl@stlouis-mo.gov.  Applicants must submit three (3) printed hard copy applications (worksheets 1-11) with all exhibits. One copy must be in a three-ring binder, with tabs corresponding to each number (on this checklist). Two (2) copies must be secured with a single binder clip and submitted without tabs, staples or paperclips.  3) Applicants must also provide a complete copy of the application and all exhibits on a labeled USB flash drive."]
[1,"Locator Map - indicating the location of the proposed development."]
[2,"Completed City of St. Louis Affordable Housing Commission For-Sale Housing Program Application.  All omissions must be stated in Cell B371 of the application.  CERTIFICATIONS MUST BE SIGNED."]
[3,"A  copy of all other funding applications for each source of funding sought.  Insert into binder copy."]
[4,"A copy of all funding commitment letters, tax credit approval certifications, bond allocation and/or tax credit reservation approval letters for all secured funds. Omissions of other sources or incomplete information may disqualify the proposal from consideration."]
[5,"Letter of Interest from a construction lender or proof of funds, dated within the last 6 months."]
[6,"City of St. Louis Community Development Administration - CDBG and/or HOME funding.  If the project has a commitment for CDBG and/or HOME funding from the City of St. Louis, include a copy of the funding commitment letter."]
[7,"Aldermanic letter of support from project ward Alderman, dated within the last 6 months is recommended."]
[8,"Letters of Support - for the proposed project from local elected officials and community/neighborhood and/or social service organizations representing the area where the project is to be located are recommended."]
[9,"Applicant's Certificate of Corporate Good Standing, dated within the last 6 months."]
[10,"City of St. Louis Business License, dated within the last 12 months."]
[11,"For Non-Profit Applicants/Developers/Sponsors Only:"]
[null,"a.","Copy of the non-profit corporation's Articles of Incorporation"]
[null,"b.","Copy of the non-profit corporation's By-Laws"]
[null,"c.","Copy of the non-profit corporation's Certificate of Incorporation"]
[null,"d.","Copy of the non-profit corporation's IRS Non-Profit Determination Letter 501(C)(3) federal Tax Exemption Letter."]
[12,"Preliminary Schematic Plans (Including site plans and floorplans)."]
[13,"Evidence of Proper Zoning."]
[null,"AHC For-Sale Application Worksheets"]
[null,1,"Application"]
[null,2,"Development Budget"]
[null,3,"Construction Costs"]
[null,4,"Sources & Uses"]
[null,5,"MVA"]
[null,6,"Priorities"]
[null,7,"UD Universal Design"]
[null,8,"Living Wage"]
[null,9,"Sustainability Impact Statement (SIS)"]
[null,10,1099]
[]
["IX.","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,"Is this a rehabilitation project?"]
[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":"F7","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,"Developer Signature"]
[]
[null,null,null,null,null,"Developer Print Name"]
[null,"Is this a new construction project?"]
[null,"Note: Complete Universal Design Budget (worksheet 10)"]
[null,null,"All new construction projects must comply with AHC's Universal Design Requirements."]
[]
[null,null,"I certify that ",null,null,{"$f":"F7","v":0}]
[null,null,"will comply with the City's Universal Design Requirements."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,null,null,null,null,"Registered Architect Signature"]
[]
[null,null,null,null,null,"Registered Architect Print Name"]
[null,null,"Signed:",null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,null,null,null,null,"Developer Signature"]
[]
[null,null,null,null,null,"Developer Print Name"]
[]
["u","Universal Design Waiver",null,null,null,null,null,null,"Are you requesting a waiver from Universal Design?"]
[]
[null,"If this application does not adhere to all UD Requirements, you should request a UD Waiver (exceptions to AHC's UD Requirements are discouraged). Explain: 1) each area of noncompliance, 2) why compliance with UD Requirements is not possible, and 3) provide alternative designs that address resident accessibility and ease of use.  A registered architect must certify that the reasons for the design exception(s) are true:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["I certify the above statements that support this application’s UD Waiver are true and accurate:"]
[]
["Signed:"]
[null,null,null,"Registered Architect Print Name",null,null,null,null,null,null,null,null,null,null,null,null,"Firm"]
[]
[]
[]
[null,null,null,"Registered Architect Signature",null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
["No exceptions will be granted to the basic four elements:"]
["1)   one no-step entry."]
["2)   minimum door and hallway width requirements."]
["3)   provisions for useable bathroom facilities in the unit on an accessible level."]
["4)   at least one accessible bedroom on an accessible level connected to an accessible route."]
[]
[null,"I/We further certify that:"]
[null,"1.","The costs listed above are based upon firm bids or estimates and are reasonable and sufficient to complete the proposed development project."]
[null,"2.","The costs listed above include only those costs that are reasonable and directly necessary to the construction and financing of the project."]
[null,"3.","The developer understands that AHC makes no representations or warranties regarding the financial feasibility of the development and that any and all AHC financing of the development is solely based on representations made by the developer.  I therefore agree to hold harmless and indemnify AHC and the individual directors, employees, members, officers, and agents of AHC in the event that the developer or anyone acting on the developer's behalf, at the developer's request or by and through the developer incurs any loss in conjunction with the development."]
[null,"4.","The developer will provide any funds necessary to complete the development of the project 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,"5.","The developer agrees not to take its profit from the project assistance applied for in this application."]
[null,"6.","But for the project assistance being applied for in this application, this project would not be developed."]
[null,"7.","I understand and agree that my application for financing, 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,"8.","I understand that any misrepresentations in this application or supporting documentation may result in a withdrawal of AHC financing and my (and related parties) being barred from future program participation."]
[null,"9.","All Federal, State and local subsidies have been disclosed and revealed."]
[null,"10.","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) Development Budget","index":2,"n_rows":75,"n_cols":8,"rows_kept":75,"cut":false,"hidden":false,"merged":[[70,0,70,2],[0,0,0,7],[1,0,1,7],[2,2,2,3],[3,2,3,3]]}
["Affordable Housing Commission For Sale Production Application"]
["Homeownership Development Budget"]
[null,"Project:",{"$f":"'1) Application'!F7","v":0},null,"AHC Units",{"$f":"'1) Application'!U22","v":0}]
[null,"Developer/Owner:",{"$f":"'1) Application'!E84","v":0},null,"≤20% AMI Units",{"$f":"'1) Application'!U23","v":0}]
[null,"Sales Commission %",6.5000000000000002E-2,null,"LMI Units",{"$f":"'1) Application'!U24","v":0}]
[null,null,null,null,"Total Units",{"$f":"units","v":0}]
[null,"Square Feet"]
[]
[null,"Unit Type: Insert                                            # Bedrooms, # Bathrooms","# of Units","Base Sales Price","Total Sales","Sales Commission","Per Unit or Average","Per Sq Ft"]
[null,"3 Bedroom, 2 Bath",0,0,{"$f":"C10*D10","v":0},{"$f":"E10*$C$5","v":0},null,{"$f":"D10/SqFt","v":{"$error":"#DIV/0!"}}]
[null,"3 Bedroom, 2 Bath",0,0,{"$f":"C11*D11","v":0},{"$f":"E11*$C$5","v":0},null,{"$error":"#DIV/0!"}]
[null,"3 Bedroom, 2 Bath",0,0,0,{"$f":"E12*$C$5","v":0},null,{"$error":"#DIV/0!"}]
[null,"3 Bedroom, 2 Bath",0,0,0,0,null,{"$error":"#DIV/0!"}]
[null,"3 Bedroom, 2 Bath",0,0,0,0,null,{"$error":"#DIV/0!"}]
[null,"3 Bedroom, 2 Bath",0,0,0,{"$f":"E15*$C$5","v":0},null,{"$error":"#DIV/0!"}]
[null,"3 Bedroom, 2 Bath",0,0,0,0,null,{"$error":"#DIV/0!"}]
[null,"3 Bedroom, 2 Bath",0,0,0,0,null,{"$error":"#DIV/0!"}]
[null,"3 Bedroom, 2 Bath",0,0,0,0,null,{"$error":"#DIV/0!"}]
[null,"4 Bedroom, 2 Bath",0,0,0,0,null,{"$error":"#DIV/0!"}]
[null,"3 Bedroom, 2 Bath",0,0,0,0,null,{"$error":"#DIV/0!"}]
[null,"3 Bedroom, 2 Bath",0,0,0,0,null,{"$error":"#DIV/0!"}]
[null,null,{"$f":"SUM(C10:C21)","v":0},null,{"$f":"SUM(E10:E21)","v":0},{"$f":"SUM(F10:F21)","v":0},{"$f":"SUM(G10:G21)","v":0}]
[]
[null,null,null,"PROJECT"]
[null,null,null,"TOTAL","Per Unit"]
["DEVELOPMENT COSTS"]
[null,"PREDEVELOPMENT COST",null,"TOTAL","Per Unit","Per SF",null,"% TDC"]
[null,"Architect & Structural Engineer",null,null,{"$f":"D28/units","v":{"$error":"#DIV/0!"}}]
[null,"Asbestos & Lead Based Paint Testing",null,null,{"$error":"#DIV/0!"}]
[null,"Phase I Environmental Inspections",null,null,{"$error":"#DIV/0!"}]
[null,"Market Analysis",null,null,{"$error":"#DIV/0!"}]
[null,"Survey & Civil Engineering",null,null,{"$error":"#DIV/0!"}]
[null,"Other:",null,null,{"$error":"#DIV/0!"}]
[null,null,"Total Predevelopment:",{"$f":"SUM(D28:D33)","v":0},{"$f":"SUM(E28:E33)","v":{"$error":"#DIV/0!"}},{"$f":"D34/SqFt","v":{"$error":"#DIV/0!"}},null,{"$f":"D34/TDC","v":{"$error":"#DIV/0!"}}]
[null,"BUILDING  AND PROPERTY ACQUISITION"]
[null,"Land & Building (Price or your offer to City)",null,null,{"$f":"D36/units","v":{"$error":"#DIV/0!"}}]
[null,"Settlement Costs (Title Ins., Recording Fees)",null,null,{"$f":"D37/units","v":{"$error":"#DIV/0!"}}]
[null,"Relocation",null,null,{"$f":"D38/units","v":{"$error":"#DIV/0!"}}]
[null,"Other:",null,null,{"$f":"D39/units","v":{"$error":"#DIV/0!"}}]
[null,null,"Total Acquisition:",{"$f":"SUM(D36:D39)","v":0},{"$f":"SUM(E36:E39)","v":{"$error":"#DIV/0!"}},{"$f":"D40/SqFt","v":{"$error":"#DIV/0!"}},null,{"$f":"D40/TDC","v":{"$error":"#DIV/0!"}}]
[null,"CONSTRUCTION COSTS  (complete sheet #3)"]
[null,"General Cond., Overhead & Profit",null,{"$f":"'3) Construction Costs'!M12+'3) Construction Costs'!M13+'3) Construction Costs'!M14","v":0},{"$f":"D42/units","v":{"$error":"#DIV/0!"}}]
[null,"Construction Contingency",null,{"$f":"'3) Construction Costs'!M98","v":0},{"$f":"D43/units","v":{"$error":"#DIV/0!"}}]
[null,"Construction Hard Costs",null,{"$f":"Construction-'2) Development Budget'!D43","v":0},{"$f":"D44/units","v":{"$error":"#DIV/0!"}}]
[null,null,"Total Construction:",{"$f":"D44+D42+D43","v":0},{"$f":"SUM(E42:E44)","v":{"$error":"#DIV/0!"}},{"$f":"D45/SqFt","v":{"$error":"#DIV/0!"}},null,{"$f":"D45/TDC","v":{"$error":"#DIV/0!"}}]
[null,"PROFESSIONAL SERVICES"]
[null,"Consultant",null,null,{"$f":"D47/units","v":{"$error":"#DIV/0!"}}]
[null,"Legal",null,null,{"$f":"D48/units","v":{"$error":"#DIV/0!"}}]
[null,"Marketing/Advertising",null,null,{"$f":"D49/units","v":{"$error":"#DIV/0!"}}]
[null,"Fees Related to State Tax Credits",null,null,{"$f":"D50/units","v":{"$error":"#DIV/0!"}}]
[null,"Other:  ",null,null,{"$f":"D51/units","v":{"$error":"#DIV/0!"}}]
[null,null,"Total Professional Services:",{"$f":"SUM(D47:D51)","v":0},{"$f":"SUM(E47:E51)","v":{"$error":"#DIV/0!"}},{"$f":"D52/SqFt","v":{"$error":"#DIV/0!"}},null,{"$f":"D52/TDC","v":{"$error":"#DIV/0!"}}]
[null,"CARRYING AND FINANCING COSTS"]
[null,"Inspection & Draw Fees",null,null,{"$f":"D54/units","v":{"$error":"#DIV/0!"}}]
[null,"Points & Bank Fees: Construction Loan",null,null,{"$error":"#DIV/0!"}]
[null,"Title Insurance: Construction Loans",null,null,{"$error":"#DIV/0!"}]
[null,"CDA Construction Loan Interest",null,null,{"$f":"D57/units","v":{"$error":"#DIV/0!"}}]
[null,"Builder's Risk Insurance",null,null,{"$error":"#DIV/0!"}]
[null,"Property Liability Insurance",null,null,{"$error":"#DIV/0!"}]
[null,"Real Estate Taxes During Development",null,null,{"$error":"#DIV/0!"}]
[null,"Other:",null,null,{"$error":"#DIV/0!"}]
[null,null,"Total Carrying Costs:",{"$f":"SUM(D54:D61)","v":0},{"$f":"SUM(E54:E61)","v":{"$error":"#DIV/0!"}},{"$f":"D62/SqFt","v":{"$error":"#DIV/0!"}},null,{"$f":"D62/TDC","v":{"$error":"#DIV/0!"}}]
[null,"SELLER'S CLOSING COSTS"]
[null,"Realtor Commission",null,null,{"$f":"D64/units","v":{"$error":"#DIV/0!"}}]
[null,"Closing Costs ",null,null,{"$f":"D65/units","v":{"$error":"#DIV/0!"}}]
[null,"Homeowner Warranty ",null,null,{"$f":"D66/units","v":{"$error":"#DIV/0!"}}]
[null,"Other:",null,null,{"$f":"D67/units","v":{"$error":"#DIV/0!"}}]
[null,null,"Total Seller's Closing Costs:",{"$f":"SUM(D64:D67)","v":0},{"$f":"SUM(E64:E67)","v":{"$error":"#DIV/0!"}},{"$f":"D68/SqFt","v":{"$error":"#DIV/0!"}},null,{"$f":"D68/TDC","v":{"$error":"#DIV/0!"}}]
[null,"DEVELOPER FEE ",{"$f":"D69/(D68+D62+D52+D45+D34)","v":{"$error":"#DIV/0!"}},null,{"$f":"D69/units","v":{"$error":"#DIV/0!"}},{"$f":"D69/SqFt","v":{"$error":"#DIV/0!"}},null,{"$f":"D69/TDC","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL DEVELOPMENT COSTS (TDC):",null,null,{"$f":"D34+D40+D45+D52+D62+D68+D69","v":0},{"$f":"E34+E40+E45+E52+E62+E68+E69","v":{"$error":"#DIV/0!"}},{"$f":"D71/SqFt","v":{"$error":"#DIV/0!"}},null,{"$f":"D71/TDC","v":{"$error":"#DIV/0!"}}]
[]
["Development Gap "]
["HOME SALES PROCEEDS",null,null,{"$f":"E22","v":0},{"$f":"D74/units","v":{"$error":"#DIV/0!"}}]
["Development Gap/Surplus",null,null,{"$f":"D74-TDC","v":0},{"$f":"D75/units","v":{"$error":"#DIV/0!"}}]

{"sheet":"3) Construction Costs","index":3,"n_rows":101,"n_cols":16,"rows_kept":101,"cut":false,"hidden":false,"merged":[[62,1,62,2],[100,1,102,15],[24,1,24,9],[96,1,96,9],[97,1,97,9],[66,1,66,2],[78,1,78,2],[90,3,90,9],[90,1,90,2],[28,1,28,9],[29,1,29,9],[66,3,66,9],[64,1,64,9],[26,1,26,2],[36,1,36,9],[37,1,37,9],[52,1,52,9],[53,1,53,9],[25,1,25,9],[33,1,33,9],[38,3,38,9],[32,1,32,9],[34,1,34,2],[34,3,34,9],[38,1,38,2],[50,3,50,9],[50,1,50,2],[21,1,21,9],[18,1,18,2],[18,3,18,9],[20,1,20,9],[11,1,11,9],[14,1,14,9],[13,1,13,9],[12,1,12,9],[17,1,17,9],[9,1,9,9],[16,1,16,9],[3,4,3,7],[8,1,8,10],[7,1,7,10],[10,1,10,9],[4,4,4,7],[0,1,0,15],[1,1,1,15],[2,1,2,3],[2,4,2,7],[3,1,3,3],[22,1,22,2],[26,3,26,9],[46,1,46,2],[46,3,46,9],[42,1,42,2],[42,3,42,9],[22,3,22,9],[99,1,99,10],[93,1,93,9],[40,1,40,9],[58,3,58,9],[60,1,60,9],[58,1,58,2],[70,3,70,9],[70,1,70,2],[69,1,69,9],[77,1,77,9],[86,1,86,2],[86,3,86,9],[81,1,81,9],[84,1,84,9],[85,1,85,9],[56,1,56,9],[72,1,72,9],[74,1,74,2],[65,1,65,9],[30,1,30,2],[30,3,30,9],[44,1,44,9],[45,1,45,9],[48,1,48,9],[68,1,68,9],[41,1,41,9],[54,3,54,9],[54,1,54,2],[62,3,62,9],[49,1,49,9],[61,1,61,9],[57,1,57,9],[94,1,94,2],[73,1,73,9],[76,1,76,9],[80,1,80,9],[92,1,92,9],[88,1,88,9],[89,1,89,9],[74,3,74,9],[82,3,82,9],[78,3,78,9],[82,1,82,2],[94,3,94,9]]}
[null,"Affordable Housing Commission For Sale Production Application"]
[null,"Construction Budget (Based on CSI)"]
[null,"Project:",null,null,{"$f":"'4) Sources & Uses'!D5","v":0},null,null,null,null,null,"Square Feet: ",{"$f":"'2) Development Budget'!C7","v":0},"AHC Units:",{"$f":"'1) Application'!U22","v":0}]
[null,"Developer/Owner:",null,null,{"$f":"'4) Sources & Uses'!D6","v":0},null,null,null,null,null,"Construction:",{"$f":"'1) Application'!G31","v":0},"≤20% AMI Units:",{"$f":"'1) Application'!U23","v":0}]
[null,"Address:",null,null,{"$f":"'1) Application'!F8","v":0},null,null,null,null,null,null,null,"LMI Units:",{"$f":"'1) Application'!U24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Units:",{"$f":"units","v":0}]
[]
[]
[null,"Square Footage:",null,null,null,null,null,null,null,null,null,null,"Total Cost","Per Unit","Per SF","% Const."]
[null,"1. General Requirements",null,null,null,null,null,null,null,null,"Limit"]
[null,"A. General Contractor Responsibilities"]
[null,"Indirect Overhead: Office expenses such as office rent, utilities, supplies, equipment, office salaries, professional fees, marketing, etc.",null,null,null,null,null,null,null,null,0.02,null,null,null,null,{"$f":"M12/(Construction-M12-M13-M14-M98)","v":{"$error":"#DIV/0!"}}]
[null,"Direct Overhead: Job supervision, temporary utilities & alarm service monitoring during construction, job site toilets, tool rental & storage, clean up, etc.",null,null,null,null,null,null,null,null,0.06,null,null,null,null,{"$f":"M13/(Construction-M12-M13-M14-M98)","v":{"$error":"#DIV/0!"}}]
[null,"Contractor Profit",null,null,null,null,null,null,null,null,{"$f":"'11) Compliance Info'!D61","v":0.08},null,null,null,null,{"$f":"M14/(Construction-M12-M13-M14-M98)","v":{"$error":"#DIV/0!"}}]
[null,"B. City/County Fee & Building Permit"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M12:M15)","v":0},{"$f":"M16/units","v":{"$error":"#DIV/0!"}},{"$f":"M16/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M16/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"2. Existing Conditions"]
[null,"Environmental, interior/exterior demolition"]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M18:M19)","v":0},{"$f":"M20/units","v":{"$error":"#DIV/0!"}},{"$f":"M20/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M20/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"3. Concrete"]
[null,"Basement, foundation, flatwork, piecing, walls"]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M22:M23)","v":0},{"$f":"M24/units","v":{"$error":"#DIV/0!"}},{"$f":"M24/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M24/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"4. Masonry"]
[null,"Foundation walls, veneer, fireplace, chimney"]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M26:M27)","v":0},{"$f":"M28/units","v":{"$error":"#DIV/0!"}},{"$f":"M28/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M28/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"5. Metals"]
[null,"Structural, wrought iron"]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M30:M31)","v":0},{"$f":"M32/units","v":{"$error":"#DIV/0!"}},{"$f":"M32/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M32/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"6. Wood & Composites"]
[null,"Rough & finish carpentry"]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M34:M35)","v":0},{"$f":"M36/units","v":{"$error":"#DIV/0!"}},{"$f":"M36/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M36/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"7. Thermal & Moisture Protection"]
[null,"Roofing, insulation, siding, trim, gutters"]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M38:M39)","v":0},{"$f":"M40/units","v":{"$error":"#DIV/0!"}},{"$f":"M40/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M40/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"8. Openings"]
[null,"Windows, interior/exterior doors, hardware"]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M42:M43)","v":0},{"$f":"M44/units","v":{"$error":"#DIV/0!"}},{"$f":"M44/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M44/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"9. Finishes"]
[null,"Wallboard, lath, plaster, ceramic tile, flooring"]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M46:M47)","v":0},{"$f":"M48/units","v":{"$error":"#DIV/0!"}},{"$f":"M48/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M48/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"10. Specialties"]
[null,"Mirrors, shelving, bath furnishing, mailbox"]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M50:M51)","v":0},{"$f":"M52/units","v":{"$error":"#DIV/0!"}},{"$f":"M52/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M52/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"11. Equipment"]
[null,"Equipment, appliances"]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M54:M55)","v":0},{"$f":"M56/units","v":{"$error":"#DIV/0!"}},{"$f":"M56/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M56/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"12. Furnishings"]
[null,"Cabinets, countertops, window treatments"]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M58:M59)","v":0},{"$f":"M60/units","v":{"$error":"#DIV/0!"}},{"$f":"M60/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M60/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"13. Special Construction"]
[null,"Porch, deck, off-street parking, accessibility"]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M62:M63)","v":0},{"$f":"M64/units","v":{"$error":"#DIV/0!"}},{"$f":"M64/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M64/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"14. Fire Suppression Systems"]
[null,"Sprinkler System"]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M66:M67)","v":0},{"$f":"M68/units","v":{"$error":"#DIV/0!"}},{"$f":"M68/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M68/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"15. Plumbing"]
[null,"Rough and finish plumbing, fixtures"]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M70:M71)","v":0},{"$f":"M72/units","v":{"$error":"#DIV/0!"}},{"$f":"M72/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M72/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"16. HVAC"]
[null,"HVAC, sheet metal/ductwork"]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M74:M75)","v":0},{"$f":"M76/units","v":{"$error":"#DIV/0!"}},{"$f":"M76/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M76/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"17. Electrical"]
[null,"Rough and finish electrical, fixtures"]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M78:M79)","v":0},{"$f":"M80/units","v":{"$error":"#DIV/0!"}},{"$f":"M80/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M80/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"18. Communications"]
[null,"Security & Alarm Systems, phone, cable"]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M82:M83)","v":0},{"$f":"M84/units","v":{"$error":"#DIV/0!"}},{"$f":"M84/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M84/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"19. Earthwork"]
[null,"Excavation, trenching, backfill, site grading"]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M86:M87)","v":0},{"$f":"M88/units","v":{"$error":"#DIV/0!"}},{"$f":"M88/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M88/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"20. Exterior Improvements"]
[null,"Paving & Sidewalks, fencing, gates, landscaping"]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M90:M91)","v":0},{"$f":"M92/units","v":{"$error":"#DIV/0!"}},{"$f":"M92/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M92/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"21. Utilities"]
[null,"Utility Connections, sewer laterals"]
[null,"Other:"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M94:M95)","v":0},{"$f":"M96/units","v":{"$error":"#DIV/0!"}},{"$f":"M96/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M96/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"22. Total Project Contingency"]
[null,"Contingency"]
[null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(M98:M98)","v":0},{"$f":"M99/units","v":{"$error":"#DIV/0!"}},{"$f":"M99/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M99/(Construction-M99)","v":{"$error":"#DIV/0!"}}]
[null,"Total Construction:",null,null,null,null,null,null,null,null,null,"TDC",{"$f":"M16+M20+M24+M28+M36+M40+M44+M48+M52+M56+M60+M64+M68+M72+M76+M80+M84+M88+M92+M96+M32+M99","v":0},{"$f":"M100/units","v":{"$error":"#DIV/0!"}},{"$f":"M100/$L$3","v":{"$error":"#DIV/0!"}},{"$f":"M100/$M$100","v":{"$error":"#DIV/0!"}}]
[null,"All estimates should be substantiated with bids and proposals. AHC does not increase funding for projects after proposal submission."]

{"sheet":"4) Sources & Uses","index":4,"n_rows":81,"n_cols":11,"rows_kept":81,"cut":false,"hidden":false,"merged":[[4,1,4,2],[5,1,5,2],[6,1,6,2],[4,3,4,4],[5,3,5,4],[6,3,6,4],[0,1,0,10],[1,1,1,10],[29,8,29,9],[30,8,30,9],[31,8,31,9],[26,8,26,9],[7,1,7,2],[7,3,7,4],[26,1,26,3],[25,1,25,3],[17,8,17,9],[13,10,14,10],[18,8,18,9],[24,8,24,9],[25,8,25,9],[12,8,14,9],[39,9,39,10],[28,8,28,9],[55,1,55,7],[57,1,57,7],[28,1,28,3],[37,9,37,10],[39,2,39,3],[29,1,29,3],[37,1,37,3],[35,1,35,4],[30,1,30,3],[31,1,31,3],[38,9,38,10],[40,9,40,10],[56,1,56,7],[80,1,80,3],[80,4,80,9],[70,1,70,3],[70,4,70,9],[78,4,78,9],[74,4,74,9],[75,1,75,3],[75,4,75,9],[77,1,77,3],[77,4,77,9],[78,1,78,3],[76,1,76,3],[76,4,76,8],[74,1,74,3],[73,1,73,3],[72,1,72,3],[21,8,21,10],[20,8,20,10],[71,1,71,3],[71,4,71,9],[72,4,72,8],[67,1,67,3],[67,4,67,9],[68,1,68,3],[68,4,68,8],[69,1,69,3],[69,4,69,9],[66,1,66,3],[65,1,65,3],[64,1,64,3],[64,4,64,9],[60,1,60,3],[65,4,65,9],[66,4,66,9],[40,2,40,3],[73,4,73,9],[79,1,79,3],[79,4,79,9],[60,4,60,9],[62,4,62,9],[63,1,63,3],[63,4,63,8],[62,1,62,3],[61,1,61,3],[61,4,61,9]]}
[null,"Affordable Housing Commission For Sale Housing Production Application"]
[null,"For Sale Housing Production: Proforma Summary (Source & Use)"]
[]
[]
[null,"Project Name:",null,{"$f":"'1) Application'!F7","v":0},null,"Construction:",{"$f":"'1) Application'!G125","v":0},"AHC Units:",{"$f":"'1) Application'!U22","v":0}]
[null,"Developer/Owner:",null,{"$f":"'1) Application'!E84","v":0},null,"Unit Type:",{"$f":"'1) Application'!G126","v":0},"≤20% AMI Units:",{"$f":"'1) Application'!U23","v":0}]
[null,"Total Units:",null,{"$f":"units","v":0},null,"AvgSqFt:",{"$f":"SqFt/units","v":{"$error":"#DIV/0!"}},"LMI Units:",{"$f":"'1) Application'!U24","v":0}]
[null,"Address:",null,{"$f":"'1) Application'!F8","v":0},null,"Total SqFt:",{"$f":"'2) Development Budget'!C7","v":0},"Total Units:",{"$f":"units","v":0}]
[]
[]
[null,"SUMMARY SOURCES & USES"]
[null,"Uses (Development Costs) ",null,null,null,"Total","Per Unit","% of Total"]
[null,"Predevelopment:",null,null,null,{"$f":"'2) Development Budget'!D34","v":0},{"$f":"F13/units","v":{"$error":"#DIV/0!"}},{"$f":"F13/$F$20","v":{"$error":"#DIV/0!"}},"Developer Fee as % of            (TDC-Acquisition-Dev Fee):"]
[null,"Acquisition:",null,null,null,{"$f":"'2) Development Budget'!D40","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$f":"'2) Development Budget'!C69","v":{"$error":"#DIV/0!"}}]
[null,"Construction/Rehab:",null,null,null,{"$f":"'2) Development Budget'!D45","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Professional Fees:",null,null,null,{"$f":"'2) Development Budget'!D52","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Finance & Carrying Costs:",null,null,null,{"$f":"'2) Development Budget'!D62","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Seller's Closing Costs",null,null,null,{"$f":"'2) Development Budget'!D68","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Construction Cost/SqFt:",null,{"$f":"F15/G8","v":{"$error":"#DIV/0!"}}]
[null,"Developer Fee",null,null,null,{"$f":"'2) Development Budget'!D69","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Total Cost/SqFt:",null,{"$f":"F20/G8","v":{"$error":"#DIV/0!"}}]
[null,"Total Development Costs",null,null,null,{"$f":"SUM(F13:F19)","v":0},{"$f":"SUM(G13:G19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H13:H19)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"You Must Include Source & Status"]
[null,null,null,null,null,null,null,null,"of All Funds Sought"]
[null,null,null,null,null,null,null,null,null,null,"Date to be"]
[null,"Permanent Sources",null,null,null,"Total","Per Unit","% of Total","Status",null,"Awarded"]
[null,"Home Sales Proceeds (Mortgage, Downpayment)",null,null,null,{"$f":"'2) Development Budget'!D74","v":0},{"$f":"F25/units","v":{"$error":"#DIV/0!"}},{"$f":"F25/$F$20","v":{"$error":"#DIV/0!"}}]
[null,"Estimated MO State Historic Tax Credits",null,null,{"$f":"AND('1) Application'!Q158=\"Yes\",'1) Application'!G125=\"Rehab\",'1) Application'!U356=\"No\")","v":false},{"$f":"IF(E26=TRUE,0.9*('2) Development Budget'!D45+'2) Development Budget'!D69)*0.25*0.85,0)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Neighborhood Preservation Tax Credits",null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"AHC Funding",null,null,null,{"$f":"'1) Application'!N75+'1) Application'!N76","v":0},{"$error":"#DIV/0!"},{"$f":"F28/$F$20","v":{"$error":"#DIV/0!"}}]
[null,"MO State HOME Funds",null,null,null,null,{"$f":"F29/units","v":{"$error":"#DIV/0!"}},{"$f":"F29/$F$20","v":{"$error":"#DIV/0!"}}]
[null,"Other:  ",null,null,null,null,{"$error":"#DIV/0!"},{"$f":"F30/$F$20","v":{"$error":"#DIV/0!"}}]
[null,"Other:",null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Other:",null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Total Sources",null,null,null,{"$f":"SUM(F25:F32)","v":0},{"$f":"SUM(G25:G32)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H25:H32)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Development Surplus/(Gap)?",null,null,null,{"$f":"F33-F20","v":0},{"$f":"G33-G20","v":{"$error":"#DIV/0!"}},{"$f":"F35/F20","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"F33-F20","v":0}]
[null,"Interim Construction Financing Sources",null,null,null,"Total","% of Total","Const. Loan Interest Rate","LTV Ratio","Status"]
[null,"Conventional Bank Construction Loan",null,null,null,null,{"$f":"F38/$F$44","v":{"$error":"#DIV/0!"}},0,{"$f":"F38/$F$25","v":{"$error":"#DIV/0!"}}]
[null,"Developer Equity (self-financing for acquisition, predevelopment)",null,null,null,null,{"$error":"#DIV/0!"},0]
[null,"Source 3",null,null,null,null,{"$error":"#DIV/0!"},0]
[null,"Source 4",null,null,null,null,{"$error":"#DIV/0!"},0]
[null,{"$f":"B28","v":"AHC Funding"},null,null,null,{"$f":"E49","v":0},{"$error":"#DIV/0!"}]
[null,"Costs Not Incurred During Construction (dev. fee, closing costs)",null,null,null,{"$f":"('2) Development Budget'!D69+'2) Development Budget'!D68)","v":0},{"$error":"#DIV/0!"}]
[null,"Total Sources",null,null,null,{"$f":"SUM(F38:F43)","v":0},{"$f":"SUM(G38:G43)","v":{"$error":"#DIV/0!"}}]
[null,"Construction Financing Surplus/(Gap)?",null,null,null,{"$f":"F44-F20","v":0},{"$f":"F45/$F$44","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total AHC Funding Request",null,null,"Total","Per Unit","Per AHC Unit","% TDC"]
[null,"Short-Term Subsidy"]
[null,"AHC Construction Loan",null,null,{"$f":"'1) Application'!N75","v":0},{"$f":"E49/units","v":{"$error":"#DIV/0!"}}]
[null,"Permanent Financing"]
[null,"AHC Development Subsidy",null,null,{"$f":"'1) Application'!N75","v":0},{"$f":"E51/units","v":{"$error":"#DIV/0!"}}]
[null,"AHC Repayable Buyer Subsidy",null,null,{"$f":"'1) Application'!N76","v":0},{"$f":"E52/units","v":{"$error":"#DIV/0!"}}]
[null,"Total AHC Funding",null,null,{"$f":"SUM(E51:E52)","v":0},{"$f":"E53/units","v":{"$error":"#DIV/0!"}},{"$f":"E53/'1) Application'!U22","v":{"$error":"#DIV/0!"}},{"$f":"E53/F20","v":{"$error":"#DIV/0!"}}]
[]
[null,"Developer Notes",null,null,null,null,null,null,"Date Entered"]
[]
[]
[]
[]
[null,"AHC Underwriting Summary"]
[null,"1. General Justification for Funding:"]
[]
[null,"2. Why is the project needed?  "]
[null,"3. Examine the sources & uses above.                    "]
[null,"a. Are costs reasonable (necessary & sufficient)?"]
[null,"b. How was this determined?"]
[null,"c. Has adequate funding been secured?"]
[null,"d. What is the status of other funding sources?"]
[null,"4. Assess neighborhood market conditions: "]
[null,"a. What supports proposed home prices?"]
[null,"b. How will homes be sold within 6 months?"]
[null,"c. Concerns & Other info:"]
[null,"5. Assess the capacity of the developer."]
[null,"a. Completed similar projects successfully?"]
[null,"b. Any problem projects current or past?"]
[null,"c. Concerns & Other info:"]
[null,"6. Assess project risks."]
[null,"a. Is project likely to be completed in a timely manner?"]
[null,"b. Any foreseeable obstacles to completion?"]
[null,"c. How will team mitigate risk?"]
[null,"d. Concerns & Other info:"]

{"sheet":"5) MVA","index":5,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[11,3,11,6],[21,2,51,4]]}
["Affordable Housing Commission For-Sale Production Application"]
["Utilizes 2024 Residential Market Analysis"]
[]
["Project:",null,{"$f":"'1) Application'!F7","v":0},"Project Address:",{"$f":"'1) Application'!F8","v":0}]
["Developer:",null,{"$f":"'1) Application'!E84","v":0},"AHC Units:",{"$f":"'1) Application'!U22","v":0}]
["AHC Request:",null,{"$f":"'1) Application'!Q64","v":0},"≤20% AMI Units:",{"$f":"'1) Application'!U23","v":0}]
["Project Type:",null,{"$f":"'1) Application'!G31","v":0},"LMI Units:",{"$f":"'1) Application'!U24","v":0}]
["Unit Type:",null,{"$f":"'1) Application'!G32","v":0},"Total Units:",{"$f":"units","v":0}]
[]
[]
[null,null,"Instructions"]
["1.",null,"Click on Website:","www.stlouis-mo.gov/data/dashboards/market-value-analysis/index.cfm"]
["2.",null,"Click \"OK\" in blue box (lower right splash screen)."]
["3.",null,"Enter primary site address."]
["4.",null,"Click on black dot."]
["5.",null,"A new window with MVA Block Group Statistics will pop up."]
["6.",null,"Maximize window by clicking on icon in upper right corner."]
["7.",null,"Select text while scrolling down and copy all text."]
["8.",null,"Paste selected text below (in yellow box)"]

{"sheet":"6) Priorities","index":6,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10],[4,2,4,7],[13,1,18,9],[23,1,23,8],[19,1,19,8],[21,0,21,10],[2,2,2,3],[3,2,3,3],[2,4,2,5],[3,4,3,5],[2,6,2,7],[3,6,3,7],[32,1,32,8],[28,1,28,9],[29,1,29,8],[24,1,24,3],[24,5,24,9],[25,3,25,4],[25,6,25,7],[30,4,30,9]]}
["Affordable Housing Commission For Sale Production Application"]
["Funding Priorities"]
[null,"Project:",{"$f":"'1) Application'!F7","v":0},null,"Construction Type:",null,{"$f":"'1) Application'!G31","v":0},null,"AHC Units:",{"$f":"'1) Application'!U22","v":0}]
[null,"Developer:",{"$f":"'1) Application'!E84","v":0},null,"Housing Type:",null,{"$f":"'1) Application'!G32","v":0},null,"≤20% AMI Units:",{"$f":"'1) Application'!U23","v":0}]
[null,"Address:",{"$f":"'1) Application'!F8","v":0},null,null,null,null,null,"LMI Units:",{"$f":"'1) Application'!U24","v":0}]
[null,null,null,null,null,null,null,null,"Total Units:",{"$f":"units","v":0}]
["Priorities"]
["1.","Will this proposal create or preserve housing/shelter for households ≤20% of the area median income?"]
["-","If yes, state the number of ≤20% AMI units:"]
["2.","Proposes permanent supportive housing for special needs & vulnerable households  ≤30% AMI? "]
["-","If yes, state the number of ≤30% AMI permanent supportive housing units:"]
["3.","Will this proposal prevent homelessness for households or individuals earning at or below 80% AMI.?"]
["-","If yes, explain how the project prevents homelessness:"]
[]
[]
[]
[]
[]
[]
["4.","Will this proposal create affordable housing while advancing ≥15 Sustainability Plan objectives?"]
[null,"All applicants must complete the Sustainability Impact Statement at the end of the application."]
["http://www.stlouis-mo.gov/government/departments/planning/documents/city-of-st-louis-sustainability-plan.cfm"]
["Proximity to public transportation"]
["5.","Is this development within one-half mile of public transportation?"]
["-","MetroLink Station/Bus Line Name:"]
["-","Station/Stop Address:",null,null,null,null,"Distance:",null,null,"mile(s)"]
[]
["Comprehensive Energy Efficient Rehabilitation"]
[]
["6","Is this a comprehensive, energy efficient rehab that will be designed & built to a national green building standard? Or, at completion will the project have an energy audit and attain a HERS of 85 or less?"]
["-","What national green standard?"]
[]
["7","Proposes housing with three or more bedrooms & serves households  ≤80% AMI."]
[]
[]
["Summary"]
[null,null,null,null,{"$f":"J8","v":0},"≤20% AMI"]
[null,null,null,null,{"$f":"J10","v":0},"≤30% AMI & PSH"]
[null,null,null,null,{"$f":"J12","v":0},"Prevents Homeless"]
[null,null,null,null,{"$f":"J20","v":0}," ≥15 Green Objectives"]
[null,null,null,null,{"$f":"J24","v":0},"Public Transit"]
[null,null,null,null,{"$f":"J30","v":0},"Energy Efficient Rehab"]
[null,null,null,null,{"$f":"J33","v":0},"3+ Bedrooms"]
[null,null,null,null,{"$f":"COUNTIF(E37:E43, \"Yes\")","v":0},"Priorities to be attained"]

{"sheet":"7) UD","index":7,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[[24,9,24,10],[24,6,24,8],[15,0,15,3],[7,1,8,9],[7,0,8,0],[29,0,29,3],[29,4,29,5],[30,4,30,5],[30,0,30,3],[14,9,14,10],[19,0,19,3],[19,4,19,5],[20,4,20,5],[20,6,20,8],[19,6,19,8],[17,9,17,10],[27,4,27,5],[29,6,29,8],[30,6,30,8],[27,6,27,8],[27,9,27,10],[28,0,28,3],[23,4,23,5],[25,0,25,3],[32,4,32,5],[38,0,38,5],[38,9,38,10],[35,6,35,8],[34,4,34,5],[33,9,33,10],[34,9,34,10],[35,9,35,10],[34,0,34,3],[35,0,35,3],[35,4,35,5],[34,6,34,8],[33,4,33,5],[33,0,33,3],[31,0,31,3],[41,0,41,8],[41,9,41,10],[18,9,18,10],[18,0,18,3],[22,0,22,3],[22,4,22,5],[19,9,19,10],[40,0,40,8],[18,4,18,5],[37,9,37,10],[40,9,40,10],[20,0,20,3],[23,9,23,10],[24,0,24,3],[22,6,22,8],[22,9,22,10],[23,0,23,3],[32,6,32,8],[33,6,33,8],[31,4,31,5],[27,0,27,3],[32,9,32,10],[32,0,32,3],[25,4,25,5],[25,6,25,8],[25,9,25,10],[39,9,39,10],[39,0,39,8],[2,2,2,4],[4,2,4,4],[9,0,10,10],[23,6,23,8],[24,4,24,5],[16,6,16,8],[14,0,14,3],[14,4,14,5],[15,9,15,10],[14,6,14,8],[13,0,13,3],[13,4,13,5],[28,4,28,5],[28,6,28,8],[30,9,30,10],[31,9,31,10],[28,9,28,10],[31,6,31,8],[29,9,29,10],[0,0,0,10],[21,0,21,3],[21,4,21,5],[21,6,21,8],[21,9,21,10],[15,4,15,5],[16,4,16,5],[16,0,16,3],[13,6,13,8],[17,0,17,3],[17,6,17,8],[13,9,13,10],[17,4,17,5],[20,9,20,10],[11,0,11,10],[1,0,1,10],[15,6,15,8],[3,2,3,4],[18,6,18,8],[16,9,16,10]]}
["Affordable Housing Commission For-Sale Production Application"]
["Universal Design Budget"]
[null,"Project:",{"$f":"'1) Application'!F7","v":0},null,null,null,"AHC Units:",{"$f":"'1) Application'!U22","v":0}]
[null,"Developer:",{"$f":"'1) Application'!E84","v":0},null,null,null,"≤20% AMI Units:",{"$f":"'1) Application'!U23","v":0}]
[null,"Address:",{"$f":"'1) Application'!F8","v":0},null,null,null,"LMI Units:",{"$f":"'1) Application'!U24","v":0}]
[null,null,null,null,null,null,"Total Units:",{"$f":"units","v":0}]
[]
["u","Universal Design (UD) Requirements (Complete for New Construction Only)"]
[]
["All new construction projects must adhere to the Commission's Universal Design Requirements.  AHC's UD Requirements are available at: www.affordablehousingcommissonstl.org."]
[]
[]
["Universal Design Budget"]
["Materials/Supplies",null,null,null,"Cost without UD",null,"Additional Cost due to UD",null,null,"Total Cost"]
[null,null,null,null,null,null,null,null,null,{"$f":"E15+G15","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"E16+G16","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E17:I17)","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
["Subtotal",null,null,null,{"$f":"SUM(E15:F25)","v":0},null,{"$f":"SUM(G15:I25)","v":0},null,null,{"$f":"SUM(J15:K25)","v":0}]
[]
["Other",null,null,null,"Cost without UD",null,"Additional Cost due to UD",null,null,"Total Cost"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E29:I29)","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
["Subtotal",null,null,null,{"$f":"SUM(E29:F35)","v":0},null,{"$f":"SUM(G29:I35)","v":0},null,null,{"$f":"SUM(J29:K35)","v":0}]
[]
["Number of AHC-assisted, universally designed homes in project:",null,null,null,null,null,null,null,null,{"$f":"'1) Application'!M134","v":0}]
["Number of affordable homes in project:",null,null,null,null,null,null,null,null,{"$f":"'1) Application'!U24","v":0}]
["Number of homes in project:",null,null,null,null,null,null,null,null,{"$f":"'1) Application'!J22:K22","v":0}]
["Cost for Universal Design",null,null,null,null,null,null,null,null,{"$f":"G36+G26","v":0}]
["Cost for Universal Design per AHC-Assisted Home",null,null,null,null,null,null,null,null,{"$f":"J41/J38","v":{"$error":"#DIV/0!"}}]

{"sheet":"8) Living Wage","index":8,"n_rows":82,"n_cols":13,"rows_kept":82,"cut":false,"hidden":false,"merged":[[0,0,2,12],[3,1,4,11],[7,7,7,12],[7,0,7,5],[13,0,13,3],[13,7,13,12],[9,0,9,5],[11,0,11,5],[9,7,9,12],[11,7,11,12],[15,7,15,12],[15,0,15,5],[17,0,17,5],[19,0,19,5],[17,7,17,12],[19,7,19,12],[42,0,42,2],[35,0,35,8],[38,0,38,2],[40,0,40,2],[21,7,21,12],[23,7,23,12],[25,0,30,12],[42,7,42,12],[32,0,32,7],[38,7,38,12],[40,7,40,12],[34,0,34,8],[21,0,21,5],[23,0,23,5],[62,8,62,12],[62,6,62,7],[59,1,59,5],[62,1,62,4],[81,0,81,1],[81,2,81,5],[81,7,81,9],[81,10,81,12],[67,4,67,11],[68,0,68,12],[66,0,66,3],[66,4,66,11],[64,3,64,4],[64,6,64,8],[64,9,64,12],[65,0,65,12],[46,0,46,12],[47,0,47,12],[59,8,59,10],[60,1,60,5],[60,8,60,10],[53,0,53,3],[56,0,56,12],[50,8,50,12],[50,2,50,7],[52,0,52,12],[51,7,51,12],[51,0,51,6]]}
["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,"2025,","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":"9) SIS","index":9,"n_rows":430,"n_cols":4,"rows_kept":430,"cut":false,"hidden":false,"merged":[[3,2,3,3]]}
[null,null,"Exhibit E"]
[null,null,"SUSTAINABILITY IMPACT STATEMENT"]
["Project:",null,{"$f":"'1) Application'!F7","v":0},{"$f":"Evaluation!B2","v":0}]
["Developer:",null,{"$f":"'1) Application'!E84","v":0}]
[null,null,"SUSTAINABILITY IMPACT STATEMENT"]
[null,null,"Below are the Objectives in the City's Sustainability Plan. Indicate activities in your project that advance the City's Sustainability Plan with a \"1\" in Column D","Included"]
[]
[null,null,"Urban Character, Vitality & Ecology"]
[null,null,"A. Support Designated Districts that Focus on Job Creation and Economic Prosperity"]
[1,null,"Reinforce the City's Central Corridor as the dynamic \"heart\" of the region"]
[2,null,"Provide and market a smart grid, Wi-Fi Hot spots and technological infrastructure"]
[3,null,"Develop designated areas via incentives for \"green\" and technical industries"]
[4,null,"Increase riverfront development and provide safe public access and associated recreational activities"]
[5,null,"Provide development incentives to encourage transit-oriented-development"]
[]
[null,null,"B. Develop Healthy, Compact, Transit-Served Smart Neighborhoods"]
[1,null,"Prioritize infill development to develop thriving compact communities and vibrant mixed-use main streets"]
[2,null,"Update local street design standards and implement the Complete Streets Ordinance"]
[3,null,"Create Citywide, and multiple neighborhood scale mobility plans"]
[4,null,"Discourage development that reduces transit, bike, and pedestrian use"]
[5,null,"Create Form-Based Code Overlay Districts"]
[6,null,"Expand on the safe routes to school program for neighborhood children"]
[7,null,"Encourage communities to improve their own neighborhood"]
[]
[null,null,"C. Strengthen Use, Access, and Programming of Civic Amenities, Public Spaces and Streets"]
[1,null,"Design public spaces and neighborhood streets as gathering spaces for people"]
[2,null,"Increase support and funding to bring programs and activities to public spaces"]
[3,null,"Expand neighborhood access to school grounds and other public facilities during off times"]
[4,null,"Improve school yards, playgrounds, fields, and gyms for physical activity"]
[5,null,"Maintain public spaces and neighborhood streets"]
[]
[null,null,"D. Support and Increase the City's Greenscape, Including its Existing Park System and Tree Canopy"]
[1,null,"Ensure all residents have access to parks, recreation facilities, and open spaces"]
[2,null,"Develop a healthy active living program that utilizes City parks"]
[3,null,"Development a regional greenway and trail system"]
[4,null,"Develop funding, operations, and management partnerships for public parks"]
[5,null,"Update City park and open space plans"]
[6,null,"Increase visual identity and branding of City parks"]
[7,null,"Expand the City's tree canopy"]
[8,null,"Develop a City-wide public and private reforestation campaign"]
[9,null,"Utilize existing park and green space improvements to drive economic and community development"]
[10,null,"Use volunteers as park stewards for all City parks"]
[]
[null,null,"E. Promote Conservation and Revitalization of the City's Unique Biodiversity and Natural Resources"]
[1,null,"Celebrate and increase activity along the Mississippi Riverfront"]
[2,null,"Remove/change infrastructure to improve riverfront access"]
[3,null,"Restore, clean and activate the City's waterways"]
[4,null,"Conduct a regional natural resources inventory and implement protections"]
[5,null,"Promote inclusion of native plants and habitats on public and private land"]
[6,null,"Provide public education on the City's natural heritage and resources"]
[7,null,"Create a long range City wildlife plan to connect key wildlife areas"]
[]
[null,null,"F. Preserve the City's Historically & Architecturally Significant Districts, Buildings, Landmarks, and Landscapes"]
[1,null,"Preserve and reuse buildings as a means of achieving sustainability"]
[2,null,"Continue to integrate preservation into the planning and building approval process"]
[3,null,"Create additional events, resources and publications that document and celebrate the City's heritage"]
[4,null,"Protect historic residential and commercial properties vulnerable to foreclosure, tax forfeiture, or demolition"]
[5,null,"Promote the redevelopment of historic homes and commercial properties"]
[6,null,"Prevent scavenging of bricks, metals, and other building materials from vacant buildings"]
[7,null,"Encourage the re-use of historic building materials"]
[8,null,"Promote public engagement in the historic preservation movement"]
[]
[null,null,"G. Increase Access to Affordable Housing in Neighborhoods with Access to Transit and Amenities"]
[1,null,"Develop affordable housing in concert with long range transit and economic development planning"]
[2,null,"Encourage mixed income/use affordable housing in high amenity neighborhoods"]
[3,null,"Expand inclusionary policies in order to create economically-integrated communities"]
[4,null,"Integrate low income housing into market-rate and mixed use developments"]
[5,null,"Promote neighborhood stabilization efforts"]
[6,null,"Experiment with new ways to raise funds and build partnerships to build sustainable and affordable housing"]
[7,null,"Support the development of housing with embedded supportive services"]
[8,null,"Offer housing that is energy efficient and environmentally sustainable"]
[]
[null,null,"H. Encourage Creative, Smart and Sustainable Uses for Under-Utilized Land and Buildings"]
[1,null,"Develop a City-wide strategic plan for maintaining and developing vacant land and property"]
[2,null,"Actively market and publicize the available properties and buildings that LRA owns"]
[3,null,"Provide special lot-purchasing programs and encourage creative temporary or permanent land uses"]
[4,null,"Continue to remove site contamination and promote brownfield redevelopment"]
[5,null,"Assess the viability of employing natural systems for remediation of contaminated land"]
[6,null,"Maintain appearance of vacant land and abandoned properties"]
[7,null,"Take action to eliminate illegal dumping and other environmental crimes"]
[8,null,"Enhance community cleaning and beautification efforts"]
[]
[null,null,"I. Build a Vibrant, Community-Based Agriculture Industry"]
[1,null,"Facilitate agriculture practices with zoning code updates"]
[2,null,"Broaden the definition of acceptable forms of farming"]
[3,null,"Develop policies and programs that permit leasing of vacant lots for community gardens"]
[4,null,"Ensure urban agriculture is a profitable, viable enterprise"]
[5,null,"Partner with neighborhoods and developers to provide a community development aspect to urban agriculture"]
[6,null,"Incubate innovative new urban agriculture ventures"]
[]
[null,null,"J. Facilitate Place-Based, Integrated Sustainability Planning"]
[1,null,"Engage in place-based planning and improvements around community anchors"]
[2,null,"Use zoning and land-use planning to foster sustainable development"]
[3,null,"Employ form-based zoning to promote healthy, compact and active communities"]
[4,null,"Preserve neighborhood residential areas and commercial and mixed uses on corners and major corridors"]
[5,null,"Increase the effectiveness of major commercial corridors"]
[6,null,"Develop codes for transit oriented development districts"]
[7,null,"Integrate sustainable parking practices into neighborhood and district plans"]
[8,null,"Incorporate sustainability in economic development programs"]
["SAA2",null,"Make LRA land available at no cost for smart, productive, create re-use of the land"]
["SAA4",null,"Increase the number of trees planted by 16,000 or 15%"]
[]
[null,null,"Arts & Innovation"]
[null,null,"A. Utilize the Arts, Design, Creative, and Innovation Industries for Economic and Community Development"]
[1,null,"Continue to attract and sponsor major arts and design events"]
[2,null,"Market the City's arts and innovative industries in order to attract and retain \"young professionals\" and the \"creative class\""]
[3,null,"Include youth development and education within art and creative projects and programs"]
[4,null,"Encourage the development of affordable artist housing, studios, and venues"]
[5,null,"Diversify the City's range of arts, philosophy and innovation industries"]
[6,null,"Develop a long-range \"arts culture and innovation\" policy and master plan"]
[7,null,"Encourage sustainable practices and community-wide leadership"]
[]
[null,null,"B. Increase Affordable and Equitable Access to a Range of Arts & Culture"]
[1,null,"Provide affordable after-school, summer sports and arts camps"]
[2,null,"Ensure existing arts and creative events and venues are easily accessible"]
[3,null,"Provide all residents with access to basic arts and creative amenities, experiences, events, instruction, and resources"]
[4,null,"Support the expansion of the Zoo Museum District (ZMD) to additional venues"]
[5,null,"Ensure all residents have access to information about arts and creative events"]
[]
[null,null,"C. Develop Multi-Use, Transit Accessible Arts and Creative Districts"]
[1,null,"Ensure art districts are multi-use, walkable, and well served by transit"]
[2,null,"Facilitate development of arts and innovation TOD's"]
[3,null,"Encourage synergies within arts and creative developments"]
[4,null,"Ensure arts and creative districts remain affordable."]
[5,null,"Target developing art districts for streetscape and public space improvements"]
[]
[null,null,"D. Encourage Innovation through Smart Learning Hubs and Venture Capital"]
[1,null,"Develop smart learning hubs as centers of research and innovation"]
[2,null,"Improve access to smart technology in all innovation districts and corridors"]
[3,null,"Facilitate venture capital and human capital support for smart learning hubs"]
[4,null,"Develop a systematic commitment to creating a philosophy of innovation"]
[5,null,"Create a social and environmental innovation research lab for sustainability"]
[]
[null,null,"E. Encourage Public Art and Design that Builds Vibrancy and Identity"]
[1,null,"Use distinctive public art, architecture, landscape, and streetscape to build City and neighborhood identity"]
[2,null,"Implement the 1% for public art program"]
[3,null,"Expand arts and creative events and out-door programs"]
[4,null,"Use temporary public art projects and programs to revitalize underutilized City areas"]
[5,null,"Develop a long-range public art and design plan"]
[6,null,"Foster art and design that beautifies public transit"]
[7,null,"Encourage collaborations that build places and destinations through art"]
[]
[null,null,"F. Promote and Develop Arts, Creative and Innovation Facilities, Resources, and Events"]
[1,null,"Revitalize existing, and develop new art facilities"]
[2,null,"Encourage the expansion of arts and creative events and showcases"]
[3,null,"Create a City-wide \"art and design week\""]
[4,null,"Develop a cohesive City-wide national marketing strategy"]
[5,null,"Expand existing online resources for information on arts and culture"]
[6,null,"Develop a \"homesteading\" live/work program"]
[7,null,"Assist artists, creative groups and venues in the promotion of their work"]
[]
[null,null,"G. Build Arts, Design and Leadership, Volunteerism, Stewardship and Funding"]
[1,null,"Provide leadership training in community oriented arts"]
[2,null,"Foster collaboration between arts and organizations to share knowledge and build capacity"]
[3,null,"Harness community energy and interest in the arts through volunteer programs"]
[4,null,"Involve artists and the \"creative class\" in the community"]
[5,null,"Support small / mid-sized community arts and organizations and individual artists"]
[6,null,"Develop partnerships to find new venues for artists and creative industries"]
["SAA6",null,"Build Phase II of CORTEX bioscience and technology research district"]
[]
[null,null,"Civic Engagement, Participation & Leadership"]
[null,null,"A. Encourage Civic Engagement, Transparency and Leadership"]
[1,null,"Involve the public in decisions that are relevant to the City"]
[2,null,"Expand accessibility of public meetings to increase public input on community issues"]
[3,null,"Increase turnout for voting opportunities"]
[5,null,"Empower community development corporations, neighborhood advisory committees, and sustainability advocacy groups"]
[]
[null,null,"B. Promote Youth Development, Education, Engagement and Empowerment"]
[1,null,"Provide early-education and supplemental youth education programs"]
[2,null,"Provide affordable after-school, summer enrichment, and volunteer programs"]
[3,null,"Develop supervised entertainment, recreation, and commercial areas for youth"]
[4,null,"Provide prevention/intervention programs, and mental/emotional health counseling"]
[5,null,"Direct youth towards college and technical school from an early age"]
[6,null,"Create opportunities for youth as they enter young adulthood and the workforce"]
[7,null,"Develop a green jobs program for youth"]
[8,null,"Encourage youth civic engagement at all levels"]
[9,null,"Improve the availability of transportation for youth"]
[10,null,"Ensure youth and families have access to healthy food"]
[]
[null,null,"C. Promote Senior Civic Involvement, Empowerment, and Intergenerational Engagement"]
[1,null,"Encourage and facilitate \"Aging-In-Place\""]
[2,null,"Offer safe, affordable and convenient transportation for seniors"]
[3,null,"Encourage intergenerational programs that bring together seniors and youth"]
[4,null,"Expand efforts to engage seniors in civic and volunteer programs"]
[5,null,"Promote healthy senior living programs at community facilities"]
[]
[null,null,"D. Reduce Homelessness and Support Low Income Families & the Unemployed"]
[1,null,"Develop and enhance the homeless services continuum of care"]
[2,null,"Develop measures to prevent people from falling into poverty or homelessness"]
[3,null,"Provide a safety net of social services in case of emergencies or personal crisis"]
[4,null,"Expand the capacity to create additional affordable housing units"]
[5,null,"Create pathways for qualified low-income families to become homeowners"]
[6,null,"Support efforts to reduce foreclosures and evictions"]
[7,null,"Provide job placement services for the unemployed and underemployed"]
[8,null,"Develop an online public resource of available human, medical, and social services in the City"]
[]
[null,null,"E. Ensure Access to Amenities, Business Opportunities, Transportation, and Safety and Healthy Neighborhoods"]
[1,null,"Address blighting and environmental health hazards"]
[2,null,"Ensure residents have access to public transit and alternate modes of transportation"]
[3,null,"Ensure all neighborhoods are safe and are perceived to be safe"]
[4,null,"Ensure equal distribution of healthy food options"]
[5,null,"Conduct a City-wide equity assessment"]
[6,null,"Ensure the application of universal design and accessibility codes"]
["SAA10",null,"Implement Board Bill 297 pertaining to workforce inclusion"]
[]
[null,null,"Health, Well-Being & Safety"]
[null,null,"A. Advance Positive Behavior, Nonviolent Conflict Resolution, and Crime Prevention"]
[1,null,"Establish a community security structure"]
[2,null,"Create opportunities for positive dialog between Police officers and the local community"]
[3,null,"Develop more school (and afterschool) programs"]
[4,null,"Provide services to reduce mental and physical pain and suffering from criminal and emotionally disruptive events"]
[5,null,"Plan and design buildings, spaces, and environments for safety"]
[]
[null,null,"B. Reduce Toxins in the Environment"]
[1,null,"Promote awareness, education and program development around air quality issues"]
[2,null,"Enforce regulatory standards and ordinances around air quality"]
[3,null,"Reduce air pollution and other harmful emissions from vehicles and engine-driven equipment"]
[4,null,"Educate residents about alternatives to use of toxic materials and hazardous chemicals"]
[5,null,"Reduce exposure of lead-based paint poisoning and remediate lead-based paint hazards"]
[6,null,"Remediate and redevelop contaminated land"]
[]
[null,null,"C. Increase Access to Healthy, Local Food, and Nutritional Information"]
[1,null,"Eliminate food deserts and improve access to fresh produce"]
[2,null,"Connect food growers with food consumers"]
[3,null,"Support agriculture opportunities in the City"]
[4,null,"Begin healthy food choice education at the elementary level"]
[5,null,"Make farmers markets and other local food access systems readily available to everyone"]
[6,null,"Make healthy food options the most convenient choice"]
[7,null,"Provide education on nutrition"]
[8,null,"Deliver healthy food to those in need"]
[]
[null,null,"D. Encourage Physical Activity, Fitness, and Recreation"]
[1,null,"Include activity options, program opportunities and creative attributes in greenways and public spaces"]
[2,null,"Promote public events that feature fitness and physical activity"]
[3,null,"Encourage physical activity and healthy modes of commuting"]
[4,null,"Design buildings to encourage physical activity"]
[]
[null,null,"E. Ensure Access to Local Health Systems, Services, and Information"]
[1,null,"Offer a health information resource database system"]
[2,null,"Identify sectors which are at risk of not receiving quality health care, and create strategies to provide services to them"]
[3,null,"Conduct community-based wellness programs"]
[4,null,"Encourage preventative care"]
[5,null,"Offer safe and convenient ways of disposing of medicines"]
[6,null,"Streamline incompatibilities across different healthcare systems"]
[7,null,"Perform capital improvements to disadvantaged healthcare facilities"]
[]
[null,null,"F. Minimize Vulnerability to Hazards and Disasters"]
[1,null,"Facilitate awareness, access, and training around emergency preparedness resources"]
[2,null,"Promote discussion of emergency prevention and response at the neighborhood and family level"]
["SAA14",null,"End chronic Homelessness"]
[]
[null,null,"Infrastructure, Facilities & Transportation"]
[null,null,"A. Facilitate Affordable, Efficient, Convenient, Accessible, Safe, and Healthy Transport of People and Goods"]
[1,null,"Advance the City of St. Louis as a transportation hub"]
[2,null,"Encourage transit oriented development"]
[3,null,"Pilot transportation improvement districts"]
[4,null,"Promote cycling amenities and infrastructure"]
[5,null,"Develop funds for public transit based on revenues"]
[6,null,"Conduct outreach and advocacy programs which advance multi-modal commuting options"]
[7,null,"Offer balanced traffic flow"]
[8,null,"Increase shared-vehicle programs and opportunities"]
[9,null,"Use highly efficient, low-emitting vehicles"]
[]
[null,null,"B. Promote Energy Efficiency and Utilize Cleaner Forms of Energy"]
[1,null,"Encourage home and business energy efficiency through energy efficiency and conservation programs"]
[2,null,"Increase the installed base of renewable energy"]
[3,null,"Conduct ongoing energy performance measurement and tracking"]
[4,null,"Conduct investment-grade energy audits at large buildings and complexes"]
[5,null,"Purchase Energy Star certified equipment"]
[6,null,"Establish a renewable energy standard for City government operations"]
[7,null,"Upgrade streetlights with energy efficient bulbs"]
[8,null,"Make water pumps and related infrastructure more energy efficient"]
[9,null,"Study the potential for development of hydroelectric resources"]
[10,null,"Utilize utility scale options to reduce overall community energy consumption"]
[11,null,"Advance developing and innovative energy solutions and infrastructure"]
[12,null,"Offer innovative financing for energy efficiency and clean energy improvements"]
[]
[null,null,"C. Reduce Greenhouse Gas Emissions"]
[1,null,"Measure and report greenhouse gas emissions"]
[2,null,"Engage in climate action planning"]
[3,null,"Support regional cooperation on abating climate change"]
[4,null,"Reduce greenhouse gas emissions"]
[5,null,"Develop resiliency and adaptation capacity in response to climate change"]
[]
[null,null,"D. Minimize Landfill-Bound Waste"]
[1,null,"Offer recycling throughout the City"]
[2,null,"Support materials and equipment repurposing programs"]
[3,null,"Provide residential and business hazardous waste collection opportunities"]
[4,null,"Collect and compost organics and yard debris"]
[5,null,"Use waste diversion as a source of revenue"]
[6,null,"Advance waste diversion education and outreach programs"]
[7,null,"Reduce the manufacture and waste of retail packaging and plastics"]
[8,null,"Reduce virgin paper use and increase use of paper with recycled content"]
[]
[null,null,"E. Manage Stormwater and Wastewater to Protect and Enhance Property and Natural Systems"]
[1,null,"Develop a natural stormwater management masterplan"]
[2,null,"Incorporate green infrastructure practices"]
[3,null,"Use pilot projects to explore ways to achieve net zero stormwater discharge"]
[4,null,"Reduce wastewater treatment loads and divert wastewater treatment sludge from landfills"]
[5,null,"Evaluate innovations in water pollution prevention"]
[6,null,"Raise awareness of storm/wastewater impacts through education and outreach programs"]
[]
[null,null,"F. Provide the Best Quality Water from Sustainable Sources"]
[1,null,"Ensure clean water is available for City use"]
[2,null,"Advance responsible water use"]
[3,null,"Make data on water usage available by property"]
[4,null,"Encourage limits on outdoor potable water consumption"]
[5,null,"Develop a water delivery and treatment system which accommodates multiple levels of water quality"]
[6,null,"Reduce consumption of bottled water"]
[7,null,"Continue to supply potable water that exceeds drinking water standards"]
[8,null,"Attract water-driven businesses to St. Louis"]
[]
[null,null,"G. Advance Health and Resource Efficiency in Buildings"]
[1,null,"Collect and share data on local climate conditions and place drivers"]
[2,null,"Strive for the highest levels of energy efficiency and maximize the deployment of clean energy solutions in buildings"]
[3,null,"Ensure building and site development integrates with natural site ecology"]
[4,null,"Advance the use of high-efficiency building related water systems and technologies"]
[5,null,"Encourage re-use of materials and divert waste from landfills"]
[6,null,"Provide healthy interior environments in commercial and public buildings"]
[7,null,"Evolve local codes and ordinances to meet or exceed national and international standards"]
[8,null,"Compile data on high efficiency building performance"]
[9,null,"Offer integrated green building education"]
[]
[null,null,"H. Facilitate Access to Leading Edge Information Exchange Systems"]
[1,null,"Develop a virtual meeting network"]
[2,null,"Provide Wi-Fi and high speed internet access across the entire City"]
[3,null,"Encourage innovative and useful app and website development"]
[4,null,"Brand the City as a communications hub"]
[5,null,"Make computers and internet access broadly available"]
["SAA18",null,"Increase bike racks by 150%"]
[]
[null,null,"Education, Training & Leadership"]
[null,null,"A. Increase the High School Graduation Rate and the Quality of the K-12 Educational Experience"]
[1,null,"Build a strong connection between individual schools and the neighborhoods and families they serve"]
[2,null,"Assure that every child enters kindergarten ready for school"]
[3,null,"Build capacity of teachers and administrative staff within the schools using professional development and cross-training opportunities"]
[4,null,"Make post-secondary education financially viable for any graduate of City schools"]
[5,null,"Incentivize high quality graduates of education programs to teach in the St. Louis public school system"]
[6,null,"Prepare K-12 students for post-secondary life or careers through college counseling and career mapping exercises"]
[7,null,"Provide healthy food options in St. Louis Public Schools"]
[]
[null,null,"B. Provide Continuing Education Opportunities"]
[1,null,"Increase the amount and quality of child day care facilities to make it easier for parents to participate in continuing education programs"]
[2,null,"Make books, reading opportunities, and literacy initiatives widely available"]
[3,null,"Provide transportation to and scholarships for early childhood programs"]
[4,null,"Boost workers' abilities to pass standard employment training entry tests"]
[5,null,"Leverage the strength of the local labor unions for job creation through preapprenticeship programs"]
[]
[null,null,"C. Link National Economic Growth Sectors to Local Training"]
[1,null,"Link employees to information and the variety of education and training programs to assure that fundamental and specialized skills are taught and kept current"]
[2,null,"Increase communications to employees about training and grant opportunities"]
[3,null,"Rebrand vocational education programs as valuable and lucrative options for growing technical or craft-based industries that could lead to entrepreneurship"]
[4,null,"Provide more on-the-job training programs within stable and emerging industries"]
[]
[null,null,"D. Nurture Leadership and Management Capabilities in Business, Government, and Neighborhoods"]
[1,null,"Promote professional development continuing education credits"]
[2,null,"Encourage and celebrate new ideas and programs developed by City employees or departments"]
[3,null,"Collaborate to offer cross-discipline and cross-sector professional development training"]
[4,null,"Encourage professional development at regular time intervals"]
[5,null,"Develop strategic plans for each neighborhood"]
[6,null,"Offer a neighborhood/community leadership program to train people in the skills needed for neighborhood planning and advocacy"]
[]
[null,null,"E. Increase Citizens' Environmental Literacy"]
[1,null,"Educate and empower citizens in methods and benefits of being environmentally sustainable"]
[2,null,"Incorporate environmental literacy tenets in curricula in elementary and high schools"]
[3,null,"Celebrate local sustainable practices by professionals and citizens alike"]
[4,null,"Facilitate spaces and programs which strive to nourish children's curiosity, growth, and creativity through unstructured play time outside in nature and other outdoor activities"]
[]
[null,null,"Prosperity, Opportunity & Employment"]
[null,null,"A. Assure the Employability of the Entire Labor Force"]
[1,null,"Increase the post-high school education and training rate"]
[2,null,"Offer job training programs at accessible community-based locations"]
[3,null,"Make information available about jobs both in and outside the City"]
[4,null,"Adapt \"green\" jobs training both new and existing occupations"]
[5,null,"Link schools and education with the professional workforce"]
[6,null,"Provide rewards or incentives for firms hiring/training City residents"]
[7,null,"Make public transit more widely accessible, frequent, and affordable"]
[8,null,"Construct sustainable infrastructure improvements"]
[]
[null,null,"B. Market the City's Assets and Special Competencies"]
[1,null,"Increase the inventory and availability of business and industrial real estate through environmental clean-up and land assembly"]
[2,null,"Encourage small scale redevelopment with economic incentives"]
[3,null,"Collaborate on economic issues to integrate City interests with regional efforts"]
[4,null,"Leverage the Mississippi River as an inexpensive transportation, drinking water, and recreation resource"]
[5,null,"Assure that the City's economic development policies, strategies, and practices enhance the City's competitive positioning in the global economy"]
[6,null,"Build on and market a megalopolitan economic strategy that leverages existing networks with other Midwestern cities"]
[7,null,"Market assets and accomplishments of the City to attract new and retain existing residents"]
[8,null,"Include sustainability as an area of award and recognition at the Mayor's Annual Business Luncheon"]
[]
[null,null,"C. Nurture Innovation in Business, Government, Philanthropy"]
[1,null,"Emphasize growth in an array of the most promising economic sectors"]
[2,null,"Align and streamline business development services offered by government, academia, and the private sector"]
[3,null,"Focus on small and local businesses as a key part of the City economy"]
[4,null,"Re-use existing buildings for inexpensive incubation of entrepreneurial ideas"]
[]
[null,null,"D. Maximize Economic Productivity by Enhancing Neighborhood Quality of Life"]
[1,null,"Pursue transit oriented development at MetroLink stations and major bus nodes to encourage more walking and fewer carbon emissions"]
[2,null,"Encourage continuing education for individual career advancement"]
[3,null,"Encourage volunteerism to utilize skills and experience of those not directly in the laborforce"]
[4,null,"Routinely involve younger adults in the labor force in efforts to understand and take advantage of opportunities to attract and retain highly talented residents"]
[5,null,"Market and encourage living within the City of St. Louis for recent college graduates"]
[]
[null,null,"E. Redevelop Real Estate Using Sustainability Practices"]
[1,null,"Monitor land use regulations to assure that development and redevelopment are encouraged, while improving social and environmental conditions"]
[2,null,"Host a biannual \"Developers' Forum\" to present crucial information on changing development opportunities in the City"]
[3,null,"Promote flexible development approaches by developers, land owners, and business firms"]
[4,null,"Direct new commercial and mixed use development to designated corridors and districts that demonstrate appropriate market support and localized leadership"]
[]
[null,null,"F. Maintain a Valuable Tax Base"]
[1,null,"Demonstrate regional and national leader-ship with modernized taxing policies implemented through local elections and/or fresh state enabling legislation"]
[2,null,"Document relative competitiveness (\"cost of conducting business\") of the tax base in relation to other cities/counties in metro St. Louis and the Midwest"]
[]
[null,null,"G. Strategically Invest in Forward-Thinking Ideas"]
[1,null,"Study quality of life factors in highly successful cities, determine how those might be improved or introduced in St. Louis, and identify the human and financial resources necessary to implement"]
[2,null,"Identify the \"critical technologies\" that will lead the national and world economies in the next decade and determine which of those can be developed or marketed in the City of St. Louis"]
[3,null,"Foster innovation"]
[4,null,"Market City assets to draw visitors to City neighborhoods"]
[5,null,"Create partnerships with adjacent cities and counties in metro St. Louis to share fiscal resources and responsibilities to implement common plans"]
[]
[null,null,"H. Create Economic Prosperity Through Investments in Human Capital"]
[1,null,"Cultivate family-friendly workplaces and target training programs to disadvantaged populations"]
[2,null,"Fund more programs that teach individuals tangible job skills and generate usable products/benefits for the community"]
[3,null,"Expand programs that teach crucial business skills in entrepreneurship, banking, accounting, budgeting, loan payments and credit building, and marketing"]
[4,null,"Remove obstacles that residents face in accessing formal banking"]
[5,null,"Help social programs attract sustainable funding sources"]
[6,null,"Distribute the City of St. Louis Sustainability Plan widely, but especially to recognized civic and business leaders"]
["SAA26",null,"Require a sustainability Impact statement for all new City development"]
["SAA27",null,"Create at least 8,500 new jobs at Ballpark Village, CORTEX, Carondelet Coke, St. Louis Army Ammunition Plant and North Riverfront"]
["SAA28",null,"Remediate and prepare at least 40 vacant properties for redevelopment"]
[null,null,"Total",{"$f":"COUNT(D9:D429)","v":0}]

{"sheet":"10) 1099","index":10,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[[34,0,35,9],[7,2,7,5],[9,1,9,9],[10,1,10,9],[11,1,11,9],[12,1,12,9],[16,1,17,10]]}
[]
[]
[]
[]
[]
[]
[]
[null,"Date:"]
[]
[null,"Contact"]
[null,"Entity Name"]
[null,"Address 1"]
[null,"Address 2"]
[]
[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"]

{"sheet":"11) Compliance Info","index":11,"n_rows":64,"n_cols":12,"rows_kept":64,"cut":false,"hidden":false,"merged":[[54,4,54,5],[60,4,60,5],[61,4,61,5],[62,4,62,5],[57,4,57,5],[22,1,22,2],[22,4,22,5],[23,4,23,5],[5,7,5,8],[6,7,6,8],[27,0,27,1],[3,3,3,4],[3,7,3,8],[3,1,3,2],[0,0,0,11],[1,0,1,11],[4,5,4,6],[4,3,4,4],[3,5,3,6],[21,0,21,11],[4,7,4,8],[23,1,23,2],[7,0,7,8],[8,0,8,8],[4,1,4,2],[5,1,5,2]]}
["Affordable Housing Commission For Sale Housing Production Program"]
["Compliance Information & Underwriting Guidelines"]
[]
["Project:",{"$f":"'1) Application'!F7","v":0},null,"Housing Type:",null,{"$f":"'1) Application'!G32","v":0},null,"AHC Units:",null,{"$f":"'1) Application'!U22","v":0}]
["Developer:",{"$f":"'1) Application'!E84","v":0},null,"Construction Type:",null,{"$f":"'1) Application'!G31","v":0},null,"≤20% AMI Units:",null,{"$f":"'1) Application'!U23","v":0}]
["Address:",{"$f":"'1) Application'!F8","v":0},null,null,null,null,null,"LMI Units:",null,{"$f":"'1) Application'!U24","v":0}]
[null,null,null,null,null,null,null,"Total Units:",null,{"$f":"units","v":0}]
["2025 Homebuyer Income Limits for AHC-assisted For-Sale Units"]
["City of St. Louis"]
["Family Size",1,2,3,4,5,6,7,8]
[0.2,{"$f":"E11*0.7","v":15595.999999999998},{"$f":"E11*0.8","v":17824},{"$f":"E11*0.9","v":20052},{"$f":"111400*0.2","v":22280},{"$f":"E11*1.08","v":24062.400000000001},{"$f":"E11*1.16","v":25844.799999999999},{"$f":"E11*1.24","v":27627.200000000001},{"$f":"E11*1.3208","v":29427.423999999999}]
[0.3,23400,26750,30100,33400,37650,43150,48650,54150]
[0.4,{"$f":"E13*0.7","v":31191.999999999996},35648,40104,{"$f":"111400*0.4","v":44560},{"$f":"E13*1.08","v":48124.800000000003},{"$f":"E13*1.16","v":51689.599999999999},{"$f":"E13*1.24","v":55254.400000000001},{"$f":"E13*1.3208","v":58854.847999999998}]
[0.5,39000,44600,50150,55700,60200,64650,69100,73550]
[0.6,{"$f":"E15*0.7","v":46788},{"$f":"E15*0.8","v":53472},{"$f":"E15*0.9","v":60156},{"$f":"111400*0.6","v":66840},{"$f":"E15*1.08","v":72187.200000000012},{"$f":"E15*1.16","v":77534.399999999994},{"$f":"E15*1.24","v":82881.600000000006},{"$f":"E15*1.3208","v":88282.271999999997}]
[0.65,{"$f":"E16*0.7","v":50687},{"$f":"E16*0.8","v":57928},{"$f":"E16*0.9","v":65169},{"$f":"111400*0.65","v":72410},{"$f":"E16*1.08","v":78202.8},{"$f":"E16*1.16","v":83995.599999999991},{"$f":"E16*1.24","v":89788.4},{"$f":"E16*1.3208","v":95639.127999999997}]
[0.7,{"$f":"E17*0.7","v":54586},62384,70182,{"$f":"111400*0.7","v":77980},{"$f":"E17*1.08","v":84218.400000000009},{"$f":"E17*1.16","v":90456.799999999988},{"$f":"E17*1.24","v":96695.2},{"$f":"E17*1.3208","v":102995.984}]
[0.8,62400,71300,80200,89100,96250,103400,110500,117650]
["St. Louis Area (MO-IL) Median Family Income (AMI) for year 2025 is $111,400."]
["Source:  HUD Income Limits, huduser.gov/portal/datasets,  June 2025."]
[]
["Maximum Sales Price of Trust Fund-Assisted Units"]
[null,"Single Family",null,215000,"3 Family (triplex)",null,324000]
[null,"2 Family (duplex)",null,268000,"4 Family (quad)",null,401000]
[]
[]
[]
["Developer Fee Calculation"]
["9% APPLICATION"]
["HARD COST (CONSTRUCTION CONTRACT VALUE)",{"$f":"'2) Development Budget'!D44","v":0}]
["TOTAL DEVELOPMENT COST",{"$f":"TDC","v":0}]
["TOTAL UNITS",{"$f":"'2) Development Budget'!F6","v":0}]
[]
[]
[null,null,"Flat Rate","$/unit","% Hard Cost","% TDC",null,"$/unit","% Hard Cost","% TDC",null,"Fee Allowed"]
["New Construction",null,4000000,45000,"N/A",0.13,null,{"$f":"IF(D36=\"N/A\",\"\",D36*B32)","v":0},{"$f":"IF(E36=\"N/A\",\"\",ROUND(E36*B$4,-3))","v":""},{"$f":"ROUND(F36*B$5,-3)","v":0},null,{"$f":"IF(C36=\"N/A\",MIN(H36,J36),MIN(C36,H36,J36))","v":0}]
["Acq Rehab",null,6000000,"N/A",0.35,0.13,null,{"$f":"IF(D37=\"N/A\",\"\",D37*B33)","v":""},{"$f":"IF(E37=\"N/A\",\"\",ROUND(E37*B$4,-3))","v":0},{"$f":"ROUND(F37*B$5,-3)","v":0},null,{"$f":"IF(C37=\"N/A\",MIN(H37,J37),MIN(C37,H37,J37))","v":0}]
["Combo",null,null,null,null,null,null,null,null,null,null,{"$f":"+MIN(L36:L37)","v":0}]
[]
["4% APPLICATION"]
["HARD COST (CONSTRUCTION CONTRACT VALUE)",{"$f":"'2) Development Budget'!D44","v":0}]
["TOTAL DEVELOPMENT COST",{"$f":"TDC","v":0}]
["TOTAL UNITS",{"$f":"'2) Development Budget'!F6","v":0}]
[]
[]
[null,null,"Flat Rate","$/unit","% Hard Cost","% TDC",null,"$/unit","% Hard Cost","% TDC",null,"Fee Allowed"]
["New Construction",null,"N/A",45000,"N/A",0.13,null,{"$f":"IF(D47=\"N/A\",\"\",D47*B43)","v":0},{"$f":"IF(E47=\"N/A\",\"\",ROUND(E47*B$14,-3))","v":""},{"$f":"ROUND(F47*B$15,-3)","v":6000},null,{"$f":"IF(C47=\"N/A\",MIN(H47,J47),MIN(C47,H47,J47))","v":0}]
["Acq Rehab",null,"N/A","N/A",0.35,0.13,null,"",{"$f":"IF(E48=\"N/A\",\"\",ROUND(E48*B$14,-3))","v":14000},{"$f":"ROUND(F48*B$15,-3)","v":6000},null,6000]
["Combo",null,null,null,null,null,null,null,null,null,null,{"$f":"+MIN(L47:L48)","v":0}]
[]
["2024 MHDC Development Costs Standards"]
[]
[null,null,"Minimum ","Maximum","Notes",null,"Project #s","Within Limits?"]
["Construction Contingency",null,null,null,null,null,{"$f":"'1) Application'!G31:M31","v":0}]
["New Construction",null,0.05,7.4999999999999997E-2,"of Construction Costs - recommendation only",null,{"$f":"IF(G54=\"New Construction\",'3) Construction Costs'!P99,\"-\")","v":"-"},{"$f":"IF(G55<=D55,G54=\"New Construction\")","v":false}]
["Rehab",null,7.4999999999999997E-2,0.1,null,null,{"$f":"IF(G54=\"Rehab\",'3) Construction Costs'!P99,\"-\")","v":"-"},{"$f":"IF(G56<=D56,G55=\"Rehab\")","v":false}]
["Developer Fee"]
["New Construction",null,"na",0.12,"of TDC (excluding Developer Fee)",null,{"$f":"IF(G54=\"New Construction\",'2) Development Budget'!H69,\"-\")","v":"-"},{"$f":"IF(G58<=D58,\"Yes\",\"No\")","v":"No"}]
["Rehab",null,"na",0.15,null,null,{"$f":"IF(G54=\"Rehab\",'2) Development Budget'!H69,\"-\")","v":"-"},{"$f":"IF(G59<=D59,\"Yes\",\"No\")","v":"No"}]
["Contractor's Fees"]
["Profit",null,"na",0.08,"of Construction (less profit, overhead, contingency)",null,{"$f":"'3) Construction Costs'!P14","v":{"$error":"#DIV/0!"}},{"$f":"IF(G61<=D61,\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
["Overhead",null,"na",0.02,"of Construction (less profit, overhead, contingency)",null,{"$f":"'3) Construction Costs'!P12","v":{"$error":"#DIV/0!"}},{"$f":"IF(G62<=D62,\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
["General Conditions",null,"na",0.06,"of Construction (less profit, overhead, contingency)",null,{"$f":"'3) Construction Costs'!P13","v":{"$error":"#DIV/0!"}},{"$f":"IF(G63<=D63,\"Yes\",\"No\")","v":{"$error":"#DIV/0!"}}]
["TDC = Total Development Costs"]

{"sheet":"Evaluation","index":12,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":true,"merged":[[34,0,34,8],[53,3,53,4],[53,7,53,8],[47,3,47,9],[46,0,46,2],[46,3,46,4],[46,7,46,8],[47,0,47,2],[53,0,53,2],[35,0,35,2],[36,0,36,2],[35,5,35,6],[8,0,19,9],[3,1,3,5],[55,0,57,9],[37,0,37,1],[37,2,37,8],[35,7,35,8],[36,6,36,8],[54,0,54,4],[49,0,51,9],[39,0,41,9],[42,0,42,9],[43,0,43,2],[43,3,43,4],[45,0,45,5],[45,6,45,9],[32,5,32,6],[2,1,2,5],[27,0,27,8],[29,0,29,8],[30,0,30,8],[1,8,1,9],[24,0,24,8],[26,0,26,8],[25,0,25,8],[20,0,20,6],[3,8,3,9],[1,1,1,2],[21,0,21,6],[23,2,23,8],[4,8,4,9],[5,8,5,9],[6,8,6,9]]}
[]
["PROPOSAL #:",null,null,null,null,null,null,"WARD #",{"$f":"'1) Application'!O9","v":0}]
["PROJECT:",{"$f":"'1) Application'!F7","v":0}]
["DEVELOPER:",{"$f":"'1) Application'!E84","v":0},null,null,null,null,null,"Amount Requested:",{"$f":"'1) Application'!Q64","v":0}]
["Forgivable Developer Subsidy ",null,{"$f":"'1) Application'!Q65","v":0},null,null,null,null,"Total Project Budget:",{"$f":"'4) Sources & Uses'!F20","v":0}]
["Repayable Buyer Subsidy ",null,{"$f":"'1) Application'!Q66","v":0},"Eight (8) Forgivable Buyer Subsidies of $35,000 each.",null,null,null,"# ≤20% AMI AHC Units:",{"$f":"'1) Application'!U23","v":0}]
[null,null,null,null,null,null,null,"# ≤80% AMI AHC Units:",{"$f":"'1) Application'!U22","v":0}]
["SUMMARY PROPOSAL DESCRIPTION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Calculation of AHC cost per unit or client served to requested amount:",null,null,null,null,null,null,null,null,{"$f":"'1) Application'!Q77","v":{"$error":"#DIV/0!"}}]
["Calculation of % of total project budget to requested amount:",null,null,null,null,null,null,null,null,{"$f":"'4) Sources & Uses'!H53","v":{"$error":"#DIV/0!"}}]
[]
["NOFA PRIORITY:"]
["Proposes housing or shelter for persons and families with income ≤20% AMI.",null,null,null,null,null,null,null,null,{"$f":"'6) Priorities'!J8","v":0}]
["Proposes permanent supportive housing for special needs & vulnerable households ≤30% AMI.",null,null,null,null,null,null,null,null,{"$f":"'6) Priorities'!J10","v":0}]
["Provides assistance to prevent homelessness for households or individuals earning at or below 80% AMI.",null,null,null,null,null,null,null,null,{"$f":"'6) Priorities'!J12","v":0}]
["Develops affordable housing units while advancing 15 or more Sustainability Plan objectives.",null,null,null,null,null,null,null,null,{"$f":"'6) Priorities'!J20","v":0}]
["Develops affordable housing within ½ mile of public transportation.",null,null,null,null,null,null,null,null,{"$f":"'6) Priorities'!J24","v":0}]
["Comprehensively rehabilitates affordable housing to a national green building standard or attains a HERS ≤85.",null,null,null,null,null,null,null,null,{"$f":"'6) Priorities'!J30","v":0}]
["Proposes housing with three or more bedrooms & serves households  ≤80% AMI.",null,null,null,null,null,null,null,null,{"$f":"'6) Priorities'!J33","v":0}]
[]
[null,null,null,null,null,null,null,null,"Priorities",{"$f":"COUNTIF(J25:J31, \"Yes\")","v":0}]
[]
["NEW CONSTRUCTION - Designed & built to a national green building standard?",null,null,null,null,null,null,null,null,{"$f":"'1) Application'!P140","v":0}]
["UD CERTIFICATION:",null,null,{"$f":"'1) Application'!N419","v":0},null,"REQUESTS UD WAIVER?",null,{"$f":"'1) Application'!U434","v":0},null,"N/A Rehab"]
["PREVIOUS AWARDEE?",null,null,null,null,"DATE:"]
["RECENT AWARDS:"]
["Additional Comments/Observations"]
[]
[]
[]
[]
["SUPPORT LETTERS"]
[]
["DISCLOSURE OF COMMISSIONER CONFLICT (if any):"]
["STAFF RECOMMENDATION:",null,null,null,null,null,"AMOUNT:"]
["REASONS NOT TO FUND:"]
[]
["STAFF RECOMMENDED TERMS:   "]
[]
[]
[]
["COMMISSION APPROVAL:",null,null,null,null,null,"AMOUNT:"]
[]
["COMMISSION RECOMMENDED TERMS:   "]

{"sheet":"Review","index":13,"n_rows":69,"n_cols":10,"rows_kept":69,"cut":false,"hidden":true,"merged":[[5,2,5,9],[55,0,55,3],[37,0,37,3],[38,0,38,3],[39,0,39,3],[50,0,50,3],[51,0,51,3],[48,0,48,3],[47,0,47,3],[43,0,43,3],[44,0,44,3],[45,0,45,3],[46,0,46,3],[49,0,49,3],[52,0,52,3],[53,0,53,3],[54,0,54,3],[0,7,0,9],[0,2,0,5],[31,7,31,8],[4,2,4,4],[2,7,2,9],[3,7,3,9],[1,7,1,9],[2,2,2,5],[1,2,1,3],[3,2,3,4],[26,7,26,8],[27,7,27,8],[28,7,28,8],[9,2,9,9],[23,7,23,8],[24,7,24,8],[25,7,25,8],[38,7,38,8],[39,7,39,8],[36,7,36,8],[37,7,37,8],[29,7,29,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[35,7,35,8],[36,0,36,3],[32,0,32,3],[33,0,33,3],[34,0,34,3],[40,7,40,8],[24,0,24,3],[25,0,25,3],[35,0,35,3],[26,0,26,3],[27,0,27,3],[28,0,28,3]]}
["Project Name:",null,{"$f":"'1) Application'!F7","v":0},null,null,null,"Neighborhood:",{"$f":"'1) Application'!R8","v":0}]
["Project Number:",null,{"$f":"Evaluation!B2","v":0},null,null,null,"Ward:",{"$f":"'1) Application'!O9","v":0}]
["Applicant/Developer:",null,{"$f":"'1) Application'!E84","v":0},null,null,null,"Project Address:",{"$f":"'1) Application'!F8","v":0}]
["Funding Request:",null,{"$f":"'1) Application'!Q64","v":0},null,null,null,"Sponsor:",{"$f":"'1) Application'!E350","v":0}]
["Total Project Cost:",null,{"$f":"'4) Sources & Uses'!F20","v":0}]
["General Contractor:",null,{"$f":"'1) Application'!E296","v":0}]
[]
[]
[]
["Preferred Repayment Terms:",null,{"$f":"'1) Application'!B80","v":0}]
[]
[]
["Income Served","# Units","LMI Units","AHC-Assisted Units",null,"Homes","Description","Square Footage","Sale Price","Buyer Subsidy"]
["20% AMI",{"$f":"'1) Application'!J30","v":0},null,{"$f":"'1) Application'!U23","v":0},null,1,"1 Bedroom, 1 bath",{"$f":"'1) Application'!H259","v":0},{"$f":"'1) Application'!P259","v":0},{"$f":"'1) Application'!S259","v":0}]
["30% AMI",{"$f":"'1) Application'!J29","v":0},null,null,null,1,"2 Bedroom, 1 bath",{"$f":"'1) Application'!H260","v":0},{"$f":"'1) Application'!P260","v":0},{"$f":"'1) Application'!S260","v":0}]
["40% AMI",{"$f":"'1) Application'!J28","v":0},null,null,null,1,"2 Bedroom, 2 bath",{"$f":"'1) Application'!H261","v":0},{"$f":"'1) Application'!P261","v":0},{"$f":"'1) Application'!S261","v":0}]
["50% AMI",{"$f":"'1) Application'!J27","v":0},null,null,null,1,"3 Bedroom, 1 bath",{"$f":"'1) Application'!H262","v":0},{"$f":"'1) Application'!P262","v":0},{"$f":"'1) Application'!S262","v":0}]
["60% AMI",{"$f":"'1) Application'!J26","v":0},null,null,null,1,"3 Bedroom, 2 bath",{"$f":"'1) Application'!H263","v":0},{"$f":"'1) Application'!P263","v":0},{"$f":"'1) Application'!S263","v":0}]
["70% AMI",{"$f":"'1) Application'!J25","v":0},null,null,null,1,"4 Bedroom, 1 bath",{"$f":"'1) Application'!H264","v":0},{"$f":"'1) Application'!P264","v":0},{"$f":"'1) Application'!S264","v":0}]
["80% AMI",{"$f":"'1) Application'!J24","v":0},null,null,null,1,"4 Bedroom, 2 bath",{"$f":"'1) Application'!H265","v":0},{"$f":"'1) Application'!P265","v":0},{"$f":"'1) Application'!S265","v":0}]
["Market-Rate",{"$f":"'1) Application'!J23","v":0},null,null,null,1,"5 Bedroom, 2 bath",{"$f":"'1) Application'!H266","v":0},{"$f":"'1) Application'!P266","v":0},{"$f":"'1) Application'!S266","v":0}]
["Total",{"$f":"SUM(B14:B21)","v":0},{"$f":"'1) Application'!U24","v":0},{"$f":"'1) Application'!U22","v":0},"Total",{"$f":"SUM(F14:F21)","v":8},null,{"$f":"SUM(H14:H21)","v":0},{"$f":"SUM(I14:I21)","v":0},{"$f":"SUM(J14:J21)","v":0}]
[]
["Interim Leveraging Sources:",null,null,null,"Amount",null,"% (of TDC)","Secured"]
[{"$f":"'4) Sources & Uses'!B38","v":"Conventional Bank Construction Loan"},null,null,null,{"$f":"'4) Sources & Uses'!F38","v":0},null,{"$f":"E25/$C$5","v":{"$error":"#DIV/0!"}},{"$f":"'4) Sources & Uses'!J38","v":0}]
[{"$f":"'4) Sources & Uses'!B39","v":"Developer Equity (self-financing for acquisition, predevelopment)"},null,null,null,{"$f":"'4) Sources & Uses'!F39","v":0},null,{"$f":"E26/$C$5","v":{"$error":"#DIV/0!"}},{"$f":"'4) Sources & Uses'!J39","v":0}]
[{"$f":"'4) Sources & Uses'!B40","v":"Source 3"},null,null,null,{"$f":"'4) Sources & Uses'!F40","v":0},null,{"$f":"E27/$C$5","v":{"$error":"#DIV/0!"}},{"$f":"'4) Sources & Uses'!J40","v":0}]
[{"$f":"'4) Sources & Uses'!B41","v":"Source 4"},null,null,null,{"$f":"'4) Sources & Uses'!F41","v":0},null,{"$f":"E28/$C$5","v":{"$error":"#DIV/0!"}},{"$f":"'4) Sources & Uses'!J41","v":0}]
[{"$f":"'4) Sources & Uses'!B42","v":"AHC Funding"},null,null,null,{"$f":"'4) Sources & Uses'!F42","v":0},null,{"$f":"E29/$C$5","v":{"$error":"#DIV/0!"}}]
["Total Interim Financing",null,null,null,{"$f":"SUM(E25:E29)","v":0},null,{"$f":"SUM(G25:G29)","v":{"$error":"#DIV/0!"}}]
[]
["Permanent Sources",null,null,null,"Amount",null,"% (of TDC)","Secured",null,"Date"]
["Home Sales Proceeds (Mortgage, Downpayment)",null,null,null,{"$f":"'4) Sources & Uses'!F25","v":0},null,{"$f":"E33/$C$5","v":{"$error":"#DIV/0!"}},{"$f":"'4) Sources & Uses'!I25","v":0},null,{"$f":"'4) Sources & Uses'!K25","v":"00:00:00"}]
["Estimated MO State Historic Tax Credits",null,null,null,{"$f":"'4) Sources & Uses'!F26","v":0},null,{"$error":"#DIV/0!"},{"$f":"'4) Sources & Uses'!I26","v":0},null,{"$f":"'4) Sources & Uses'!K26","v":"00:00:00"}]
["Neighborhood Preservation Tax Credits",null,null,null,{"$f":"'4) Sources & Uses'!F27","v":0},null,{"$error":"#DIV/0!"},{"$f":"'4) Sources & Uses'!I27","v":0},null,{"$f":"'4) Sources & Uses'!K27","v":"00:00:00"}]
["MO State HOME Funds",null,null,null,{"$f":"'4) Sources & Uses'!F29","v":0},null,{"$error":"#DIV/0!"},{"$f":"'4) Sources & Uses'!I28","v":0},null,{"$f":"'4) Sources & Uses'!K29","v":"00:00:00"}]
["Affordable Housing Commission",null,null,null,{"$f":"'1) Application'!M77","v":0},null,{"$error":"#DIV/0!"}]
[{"$f":"'4) Sources & Uses'!B30","v":"Other:  "},null,null,null,{"$f":"'4) Sources & Uses'!F30","v":0},null,{"$error":"#DIV/0!"},{"$f":"'4) Sources & Uses'!I30","v":0},null,{"$f":"'4) Sources & Uses'!K30","v":"00:00:00"}]
[{"$f":"'4) Sources & Uses'!B31","v":"Other:"},null,null,null,{"$f":"'4) Sources & Uses'!F31","v":0},null,{"$error":"#DIV/0!"},{"$f":"'4) Sources & Uses'!I31","v":0},null,{"$f":"'4) Sources & Uses'!K31","v":"00:00:00"}]
[{"$f":"'4) Sources & Uses'!B32","v":"Other:"},null,null,null,{"$f":"'4) Sources & Uses'!F32","v":0},null,{"$error":"#DIV/0!"},{"$f":"'4) Sources & Uses'!I32","v":0},null,{"$f":"'4) Sources & Uses'!K32","v":"00:00:00"}]
["Total Permanent Financing",null,null,null,{"$f":"SUM(E33:E40)","v":0},null,{"$f":"SUM(G33:G40)","v":{"$error":"#DIV/0!"}}]
[]
["Summary",null,null,null,"Amount",null,"% (of TDC)"]
["Total Development Cost",null,null,null,{"$f":"'4) Sources & Uses'!F20","v":0}]
["Hard Construction Cost",null,null,null,{"$f":"'2) Development Budget'!D44","v":0},null,{"$f":"E45/$C$5","v":{"$error":"#DIV/0!"}}]
["Soft Costs",null,null,null,{"$f":"'4) Sources & Uses'!F16+'4) Sources & Uses'!F17+'4) Sources & Uses'!F18+'4) Sources & Uses'!F19","v":0},null,{"$error":"#DIV/0!"}]
["Developer Fee (included in soft costs)",null,null,null,{"$f":"'4) Sources & Uses'!F19","v":0},null,{"$error":"#DIV/0!"}]
["Sales Proceeds",null,null,null,{"$f":"'2) Development Budget'!D74","v":0},null,{"$error":"#DIV/0!"}]
["Sales Commission",null,null,null,{"$f":"'2) Development Budget'!D64","v":0},null,{"$error":"#DIV/0!"}]
["Builder's Profit (not in hard/soft costs)",null,null,null,{"$f":"'3) Construction Costs'!M14","v":0},null,{"$error":"#DIV/0!"}]
["Contingency",null,null,null,{"$f":"'3) Construction Costs'!M98","v":0},null,{"$error":"#DIV/0!"}]
["Land & building",null,null,null,{"$f":"'2) Development Budget'!D36","v":0}]
["Cost Per Unit",null,null,null,{"$f":"'2) Development Budget'!E71","v":{"$error":"#DIV/0!"}}]
["Cost Per Square Foot",null,null,null,{"$f":"'2) Development Budget'!F71","v":{"$error":"#DIV/0!"}}]
["AHC Funds Per AHC-Assisted Unit",null,null,null,{"$f":"'1) Application'!Q77","v":{"$error":"#DIV/0!"}}]
["AHC % of Total Project Cost",null,null,null,{"$f":"E37/E44","v":{"$error":"#DIV/0!"}}]
["# Accessible Units",null,null,null,{"$f":"'1) Application'!M132","v":0}]
["% Hearing Accessible Units:",null,null,null,{"$f":"'1) Application'!M133","v":"%"}]
["# Universally Designed Units",null,null,null,{"$f":"'1) Application'!M134","v":0}]
[]
["Priorities to be Attained"]
[{"$f":"'6) Priorities'!J8","v":0},"≤20% AMI"]
[{"$f":"'6) Priorities'!J10","v":0},"≤30% AMI & PSH"]
[{"$f":"'6) Priorities'!J12","v":0},"Prevents Homeless"]
[{"$f":"'6) Priorities'!J20","v":0}," ≥15 Green Objectives"]
[{"$f":"'6) Priorities'!J24","v":0},"Public Transit"]
[{"$f":"'6) Priorities'!J30","v":0},"Energy Efficient Rehab"]
[{"$f":"'6) Priorities'!J33","v":0},{"$f":"'6) Priorities'!F43","v":"3+ Bedrooms"}]
[{"$f":"COUNTIF(A62:A68, \"Yes\")","v":0},"Priorities to be attained"]

{"sheet":"Rating","index":14,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":true,"merged":[[7,6,7,7],[22,0,22,6],[24,0,24,6],[18,0,18,4],[18,5,18,6],[23,0,23,6],[19,0,19,6],[21,0,21,6],[20,0,20,6],[34,7,34,9],[26,0,26,6],[38,0,38,2],[31,0,31,6],[32,0,32,6],[30,0,30,6],[27,0,27,6],[35,8,35,10],[28,0,28,6],[29,0,29,6],[33,0,33,6],[1,2,1,8],[4,2,4,3],[1,0,1,1],[6,0,6,1],[4,0,4,1],[2,0,2,1],[3,0,3,1],[3,2,3,3],[2,2,2,8],[6,6,6,7],[5,2,5,8],[5,0,5,1],[49,0,49,2],[9,3,9,10],[25,0,25,4],[45,0,45,2],[46,0,46,2],[47,0,47,2],[48,0,48,2],[15,0,15,6],[12,0,12,6],[13,0,13,6],[14,0,14,6],[11,5,11,6],[16,0,16,4],[16,5,16,6],[17,0,17,4],[17,5,17,6]]}
[]
["Project:",null,{"$f":"'1) Application'!F7","v":0},null,null,null,null,null,null,"Ward #",{"$f":"'1) Application'!O9","v":0}]
["Applicant/Developer:",null,{"$f":"'1) Application'!E84","v":0},null,null,null,null,null,null,"Proj. # ",{"$f":"Evaluation!B2","v":0}]
["Funding Request:",null,{"$f":"'1) Application'!Q64","v":0}]
["Total Project Cost:",null,{"$f":"'4) Sources & Uses'!F20","v":0}]
["Project Address:",null,{"$f":"'1) Application'!F8","v":0}]
["AHC-Assisted Units:",null,{"$f":"'1) Application'!U22","v":0},null,null,"LMI Units:",{"$f":"'1) Application'!U24","v":0}]
["≤20% AMI Units:",null,{"$f":"'1) Application'!U23","v":0},null,null,"Total Units:",{"$f":"units","v":0}]
["Site control from Land Reutilization Authority?",null,null,{"$f":"'1) Application'!S178","v":0}]
["Neighborhood or housing sponsor:",null,null,{"$f":"'1) Application'!E350","v":0}]
[]
[null,null,null,null,null,null,null,"Good","Fair","Poor","Comments"]
["Energy Efficient"]
["If new construction, the project will be built to a national green building standard."]
["If rehabilitation, the project incorporates AHC's recommended energy-saving features into construction."]
["Sources & Uses"]
["Costs are reasonable & sufficient."]
["Strong financial support and the project supports its debt."]
["Significant community support."]
["Neighborhood & Market"]
["Marketing plan supports proposed home prices."]
["Has a reasonable plan to sell homes quickly (within 1-year)."]
["Utilizes the MVA toward a strategic, equitable use of Trust Fund dollars."]
["Development Team"]
["The project team is qualified & experienced."]
["Projected time frame: Complete within 16 months from January 2026.",null,null,null,null,{"$f":"'1) Application'!O255","v":0},"months"]
["NOFA Priority"]
["Provides housing or shelter for persons or families earning ≤20% Area Median Income.",null,null,null,null,null,null,null,{"$f":"'6) Priorities'!J8","v":0}]
["Provides permanent supportive housing for persons or families earning ≤30% Area Median Income.",null,null,null,null,null,null,null,{"$f":"'6) Priorities'!J10","v":0}]
["Provide assistance or initiatives that prevent homelessness for households or individuals earning at or below 80% AMI",null,null,null,null,null,null,null,{"$f":"'6) Priorities'!J12","v":0}]
["Develops affordable housing units while advancing 15 or more Sustainability Plan objectives.",null,null,null,null,null,null,null,{"$f":"'6) Priorities'!J20","v":0}]
["Develops affordable housing within ½ mile of public transportation.",null,null,null,null,null,null,null,{"$f":"'6) Priorities'!J24","v":0}]
["Comprehensively rehabilitates affordable housing to a national green building standard or HERS of ≤85.",null,null,null,null,null,null,null,{"$f":"'6) Priorities'!J30","v":0}]
["Creates housing with three or more bedrooms and serves households ≤80% AMI.",null,null,null,null,null,null,null,{"$f":"'6) Priorities'!J33","v":0}]
[]
["AHC Recommendation for funding",null,null,null,null,null,null,null,"$"]
["AHC Terms: "]
[]
["Comments:"]