{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["INSTRUCTIONS","1) Application","2) Development Budget","3) Construction Costs","4) Sources & Uses","5) Utilities","6) Units & Revenue","7) Operating Budget","8) Cash Flow","9) MVA","10) Priorities","11) UD","12) Living Wage","13) SIS","14) 1099","Compliance","Evaluation","Review","Rating"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":6,"defined_names":177,"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":49,"n_cols":3,"rows_kept":49,"cut":false,"hidden":false,"merged":[[11,6,11,7],[12,0,12,2],[15,0,15,2],[18,6,18,7],[19,0,19,2],[15,6,15,7],[49,0,49,2],[22,6,22,7],[27,0,27,2],[32,0,32,2],[44,0,44,2],[38,0,38,2],[48,0,48,2],[46,0,46,2],[0,0,0,2],[2,0,2,2],[8,0,8,2],[40,0,40,2],[42,0,42,2],[25,0,25,2],[36,0,36,2]]}
["INSTRUCTIONS FOR COMPLETING THE AHC RENTAL APPLICATION & PROFORMA WORKSHEETS"]
[]
["General Instructions"]
[null,"A.","You will only be able to enter information into yellow input cells. All other cells are protected or for AHC use."]
[null,"B.","Some cells appear black based on data inputted in early sheets/cells. Do not fill in blacked-out cells."]
[null,"C.","Complete the following worksheets in the order corresponding to their numbering: 1) Application, 2) Development Budget, 3) Construction Costs, 4) Sources & Uses, 5) Utilities, 6) Units & Revenue, 7) Operating Budget, 8) Cash Flow 9) MVA, 10) Priorities, 11) UD (Universal Design, 12) Living Wage, 13) Sustainabilty Impact Statement, and 14) 1099."]
[null,"D.","All worksheets above must be completed.  Information on each worksheet is linked to other sheets."]
[null,"E.","To print this entire file, click on File>Print and select \"Print Entire Workbook.\""]
["1) Application"]
[null,"A.","This is the general application form. Fill all applicable yellow cells. Many sections will prompt you with drop-down menus. Some cells will initially be blank and will populate once you have completed other sheets in this workbook."]
[null,"C.","Include all documents & exhibits listed in the Application Checklist (Section XI) with each of the three printed hard copy applications (worksheets 1-15) to AHC before the deadline. Email this Excel Spreadsheet file to AHC's Housing Analyst at: hinerl@stlouis-mo.gov.  One copy must be in a three-ring binder, with tabs corresponding to each number (on the 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.  If you have any questions about your proposal, AHC's funding requirements or procedures, or the Excel file, please call Loretta Hiner at 314-657-3883 well before the deadline. The deadline is October 18 at 4:00 p.m."]
[null,"D.","Sign the certifications on the final page of the Rental Application. Submit the three (3) hard copies with original signatures to AHC."]
["2) Development Budget"]
[null,"A.","The Development Budget is 2 pages.  Note: construction costs are entered on Tab 3, labeled Construction Costs."]
[null,"B.","The worksheet will automatically calculate Total Development Costs (TDC)."]
["3) Construction Costs"]
[null,"A.","Enter detailed construction costs."]
[null,"B.","Note AHC limits for overhead, general conditions and profits.  Stay within the allowable percentage limits."]
[null,"C.","After completing this Worksheet, review Development Budget (Tab 2), to insure cost data transferred properly."]
["4) Summary Sources & Uses"]
[null,"A.","Enter all permanent sources of financing, debt, and equity.  Include interest rates where applicable."]
[null,"B.","Enter the amount of your request to AHC in Cell E25 \"AHC Permanent Loan\" you may enter 0% interest or another interest rate."]
[null,"C.","Enter all construction sources along with interest rates. Some may be identical to permanent sources."]
[null,"D.","Check that permanent sources = uses AND that construction sources = uses."]
[null,"E.","Enter any additional information you wish to provide to AHC  in the \"Developer's Notes\" section at the bottom of the sheet."]
["5) Utilities"]
[null,"A.","Utility Allowances: Indicate the type of utilities the project will have, as well as which will be paid by the owner and which will be paid by tenants. For utilities paid by tenants, enter the utility allowance for each using the utility allowance tables found at www.slha.org/for-partners/owners/forms/"]
["6) Units & Revenue"]
[null,"A.","Unit Distribution: For each bedroom type, input the requested information.  Include the Contract Rent (the rent charged to tenants or rent that a voucher will provide)."]
[null,"B.","Square Footage Breakdown: Enter the commercial square footage and common area square footage, if applicable."]
[null,"C.","Other Income: Enter other sources of revenue you are reasonably confident the project will receive."]
[null,"D.","Annual Operating Subsidies: If the project will receive an operating subsidy, enter the source & amount."]
["7) Annual Operating Budget"]
[null,"A.","Input a vacancy rate (7% is the default).  You may modify this as appropriate."]
[null,"B.","Enter the expected stabilized operating expenses."]
[null,"C.","Review the Estimated Mortgage calculations.  This is the estimated permanent debt your project can support."]
["8) Operating Cash Flow Projections"]
[null,"A.","AHC will assess the project's ability to repay debt. You may modify the default vacancy factor.  Be prepared to justify changes."]
["9)  Market Value Analysis (MVA)"]
[null,"A.","This section is one (1) page. Follow instructions."]
["10) 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 additional consideration."]
["11) Universal Design Budget"]
[null,"A.","If new construction, input costs to make the AHC-Assisted Units Universally Designed. Sign the UD certification on page 14 (Tab 1)."]
["12) Living Wage Acknowledgement & Acceptance"]
[null,"A.","Complete this form.  If the applicant is a non-profit agency that previously received AHC funding and there have been no changes to the agency's: 1) non-profit status, 2) Articles of Incorporation and 3) By-laws, please sign the No Change Affidavit."]
["13) Sustainability Impact Statement"]
[null,"A.","Indicate all activities in your project that advance the City's Sustainability Plan."]
["14) 1099"]

{"sheet":"1) Application","index":1,"n_rows":562,"n_cols":21,"rows_kept":562,"cut":false,"hidden":false,"merged":[[348,1,348,3],[354,2,354,20],[353,2,353,20],[421,1,421,11],[421,15,421,19],[421,12,421,13],[418,4,418,20],[417,1,417,3],[417,4,417,20],[385,1,388,20],[350,1,350,3],[419,1,419,3],[400,1,400,19],[419,4,419,11],[419,16,419,20],[419,13,419,15],[369,1,369,18],[377,1,377,18],[358,1,359,20],[395,1,395,19],[408,1,414,20],[349,10,349,15],[349,16,349,18],[366,1,367,20],[530,3,530,10],[530,16,530,20],[469,1,469,20],[470,1,470,20],[471,1,471,20],[293,9,293,13],[294,9,294,13],[295,9,295,13],[293,14,293,16],[294,14,294,16],[295,14,295,16],[293,17,293,20],[294,17,294,20],[295,17,295,20],[346,10,346,15],[346,16,346,18],[347,10,347,15],[347,16,347,18],[489,2,489,20],[338,14,338,16],[337,17,337,18],[338,17,338,18],[428,1,428,17],[342,17,342,18],[31,6,31,12],[27,14,28,19],[27,9,27,10],[117,1,117,4],[117,5,117,9],[149,15,149,20],[155,1,155,17],[156,1,156,17],[130,13,130,14],[124,1,127,20],[133,13,133,14],[148,1,148,12],[118,1,118,20],[139,16,139,17],[46,1,59,20],[32,6,32,12],[63,16,63,17],[77,1,77,19],[115,5,115,9],[115,19,115,20],[115,14,115,16],[115,17,115,18],[114,10,114,11],[114,19,114,20],[26,9,26,10],[148,15,148,16],[149,1,149,14],[156,19,156,20],[155,19,155,20],[141,15,141,16],[138,8,138,10],[30,1,30,8],[29,9,29,10],[90,14,90,20],[94,13,94,14],[106,16,106,17],[99,3,99,9],[97,16,97,18],[91,16,91,19],[69,12,69,13],[69,9,69,11],[69,14,69,15],[68,12,68,13],[28,9,28,10],[68,9,68,11],[30,9,30,10],[137,16,137,17],[62,16,62,17],[341,14,341,16],[344,19,344,20],[348,10,348,15],[115,12,115,13],[115,1,115,4],[111,18,111,19],[69,18,69,19],[316,1,316,20],[19,4,19,5],[19,14,19,15],[19,16,19,17],[31,14,31,20],[29,1,29,8],[91,12,91,14],[72,1,75,20],[90,12,90,13],[90,3,90,11],[88,16,88,20],[78,1,78,19],[91,2,91,9],[32,14,32,20],[83,1,85,20],[88,4,88,12],[114,12,114,13],[422,12,422,13],[422,15,422,19],[422,1,422,11],[157,1,157,17],[19,2,19,3],[26,1,26,8],[34,1,45,20],[350,4,350,9],[351,4,351,9],[371,1,374,20],[396,1,399,20],[365,2,365,20],[335,2,336,7],[335,17,335,18],[335,14,335,16],[336,14,336,16],[336,8,336,13],[346,1,346,3],[340,14,340,16],[339,17,339,18],[340,17,340,18],[339,14,339,16],[341,17,341,18],[342,14,342,16],[360,1,360,20],[364,2,364,20],[361,2,361,20],[363,2,363,20],[416,1,416,17],[383,1,383,18],[355,2,355,20],[356,2,356,20],[352,1,352,18],[423,2,423,19],[425,2,425,19],[418,1,418,3],[351,10,351,15],[347,1,347,3],[346,4,346,9],[347,4,347,9],[348,4,348,9],[330,17,330,18],[343,14,343,16],[343,17,343,18],[392,1,394,20],[406,1,406,20],[337,14,337,16],[349,1,349,3],[348,16,348,18],[344,1,344,10],[350,16,350,18],[420,4,420,20],[424,3,424,18],[420,1,420,3],[351,16,351,18],[350,10,350,15],[349,4,349,9],[295,0,295,3],[326,14,326,16],[327,17,327,18],[329,8,329,13],[331,17,331,18],[257,16,257,20],[333,14,333,16],[294,0,294,3],[333,17,333,18],[327,8,327,13],[326,2,330,7],[328,8,328,13],[259,2,259,9],[295,4,295,8],[279,1,282,20],[216,9,216,10],[218,9,218,10],[218,18,218,19],[332,14,332,16],[219,18,219,19],[306,1,309,20],[312,1,315,20],[299,12,299,20],[300,12,300,20],[301,12,301,20],[302,12,302,20],[327,14,327,16],[331,2,334,7],[222,18,222,19],[259,12,259,14],[258,14,258,20],[328,17,328,18],[326,8,326,13],[258,3,258,11],[220,18,220,19],[278,1,278,18],[247,1,251,20],[229,1,243,20],[228,1,228,20],[200,17,200,20],[204,16,204,17],[202,17,202,20],[201,1,201,15],[203,17,203,20],[176,2,176,5],[215,9,215,10],[211,9,211,10],[182,17,182,18],[176,11,176,15],[213,9,213,10],[212,12,212,14],[214,9,214,10],[215,12,215,14],[214,12,214,14],[181,17,181,18],[187,17,187,18],[199,1,199,20],[186,12,186,15],[189,5,189,18],[184,16,184,18],[190,5,190,18],[183,6,183,8],[186,17,186,18],[191,7,191,8],[174,2,174,5],[175,7,175,9],[194,1,194,20],[137,13,137,15],[169,7,169,12],[147,17,147,20],[173,7,173,9],[175,2,175,5],[174,16,174,20],[176,7,176,9],[216,12,216,14],[209,12,209,13],[187,12,187,15],[15,1,15,10],[13,1,13,10],[27,1,27,8],[26,12,26,20],[19,10,19,11],[28,1,28,8],[19,6,19,7],[19,8,19,9],[19,12,19,13],[19,18,19,19],[22,1,22,8],[22,9,22,10],[22,12,22,19],[23,1,23,8],[23,9,23,10],[23,12,23,18],[24,1,24,8],[24,9,24,10],[24,12,24,18],[13,13,13,20],[14,1,14,10],[3,10,4,20],[7,16,7,18],[7,7,7,10],[7,14,7,15],[6,17,6,20],[6,14,6,16],[6,5,6,13],[7,19,7,20],[9,1,9,6],[5,5,5,20],[5,1,5,4],[6,1,6,4],[7,1,7,4],[18,16,18,18],[10,1,10,10],[10,13,10,20],[11,1,11,10],[11,13,11,20],[12,1,12,10],[362,2,362,20],[370,1,370,18],[357,2,357,20],[351,1,351,3],[277,16,277,20],[335,8,335,13],[268,1,268,20],[328,14,328,16],[325,17,325,18],[336,17,336,18],[276,19,276,20],[269,1,273,20],[329,17,329,18],[12,13,12,20],[89,16,89,20],[89,5,89,13],[79,1,79,19],[167,7,167,12],[483,2,483,20],[436,18,436,19],[436,1,436,17],[442,1,442,20],[475,2,475,20],[476,1,476,20],[477,1,477,20],[461,1,461,20],[462,1,462,20],[463,1,463,20],[464,1,464,20],[465,1,465,20],[466,1,466,20],[467,1,467,20],[468,1,468,20],[460,1,460,20],[453,1,458,20],[439,18,439,19],[438,18,438,19],[438,1,438,17],[437,1,437,17],[479,2,479,20],[452,1,452,20],[482,2,482,20],[515,5,515,14],[513,17,513,20],[513,2,513,4],[504,5,504,14],[503,5,503,14],[500,2,500,13],[501,2,501,4],[501,5,501,14],[505,13,505,14],[510,2,512,4],[500,14,500,20],[507,2,507,4],[505,1,505,12],[508,2,508,20],[507,5,507,20],[502,2,504,4],[501,18,501,20],[502,5,502,14],[514,1,516,4],[514,15,517,20],[516,5,516,14],[511,5,511,14],[510,5,510,14],[512,5,512,14],[481,2,481,20],[426,3,426,18],[474,2,474,20],[480,2,480,20],[440,18,440,19],[440,1,440,17],[441,1,441,17],[441,18,441,19],[473,2,473,20],[472,2,472,20],[435,1,435,19],[429,1,432,20],[478,0,478,20],[427,2,427,19],[459,10,459,20],[513,15,513,16],[484,2,484,20],[499,2,499,4],[497,2,498,20],[496,15,496,20],[509,17,509,20],[495,1,495,20],[496,13,496,14],[487,2,487,20],[488,2,488,20],[513,5,513,14],[499,5,499,20],[509,5,509,14],[501,16,501,17],[485,2,485,20],[496,1,496,12],[490,2,490,20],[491,2,491,20],[492,2,492,20],[493,2,493,20],[486,2,486,20],[558,10,561,11],[558,1,558,9],[554,1,554,9],[561,12,561,20],[560,12,560,20],[552,2,552,20],[549,2,549,20],[551,2,551,20],[559,1,559,9],[559,12,559,20],[561,1,561,9],[560,1,560,9],[558,12,558,20],[548,2,548,20],[547,2,547,20],[546,2,546,20],[543,2,543,20],[545,2,545,20],[544,2,544,20],[550,2,550,20],[542,1,542,10],[533,16,533,17],[532,3,532,10],[514,5,514,14],[532,16,532,20],[277,1,277,14],[334,8,334,13],[331,14,331,16],[333,8,333,13],[332,17,332,18],[529,3,529,10],[522,1,526,20],[529,16,529,20],[520,1,521,20],[443,1,450,20],[437,18,437,19],[439,1,439,17],[510,15,512,20],[283,16,283,17],[323,1,323,20],[284,16,284,17],[286,1,286,6],[286,7,286,20],[290,18,290,19],[291,0,291,15],[293,0,293,3],[220,9,220,10],[257,5,257,13],[252,1,253,19],[262,18,262,19],[256,10,256,20],[260,2,260,17],[264,1,267,20],[401,1,404,20],[384,1,384,18],[378,1,381,20],[390,1,390,19],[376,1,376,18],[276,1,276,18],[290,1,290,16],[223,1,223,20],[224,1,226,20],[221,9,221,10],[334,14,334,16],[334,17,334,18],[255,10,255,18],[325,14,325,16],[330,8,330,13],[326,17,326,18],[330,14,330,16],[97,19,97,20],[92,5,92,9],[113,12,113,13],[113,10,113,11],[113,19,113,20],[111,16,111,17],[98,3,98,9],[109,14,109,16],[107,16,107,17],[106,1,106,15],[111,11,111,12],[99,14,99,18],[100,3,100,9],[101,14,101,16],[103,14,103,16],[115,10,115,11],[93,13,93,14],[100,14,100,18],[100,19,100,20],[114,14,114,16],[113,14,113,16],[114,17,114,18],[113,17,113,18],[298,22,298,30],[162,1,162,17],[174,7,174,9],[173,2,173,5],[203,1,203,15],[192,7,192,8],[184,6,184,8],[206,1,208,20],[114,1,114,4],[114,5,114,9],[212,9,212,10],[219,9,219,10],[213,12,213,14],[294,4,294,8],[152,1,154,20],[150,1,150,20],[116,1,116,4],[138,1,138,4],[136,6,136,12],[145,1,146,20],[139,5,139,9],[138,17,138,19],[123,1,123,20],[135,13,135,14],[116,5,116,9],[117,10,117,11],[117,19,117,20],[116,14,116,16],[141,17,141,20],[116,17,116,18],[116,19,116,20],[116,12,116,13],[140,14,140,15],[137,6,137,12],[131,13,131,14],[119,1,122,20],[138,11,138,13],[138,5,138,7],[138,14,138,16],[116,10,116,11],[134,13,134,14],[167,14,167,20],[175,16,175,20],[170,7,170,12],[168,14,168,20],[168,7,168,12],[170,14,170,20],[158,19,158,20],[161,19,161,20],[160,1,160,17],[159,19,159,20],[157,19,157,20],[162,19,162,20],[169,14,169,20],[159,1,159,17],[158,1,158,17],[161,1,161,17],[160,19,160,20],[117,17,117,18],[329,14,329,16],[176,16,176,20],[165,14,165,20],[205,1,205,17],[195,1,197,20],[258,12,258,13],[293,4,293,8],[287,5,287,13],[262,2,262,17],[260,18,260,19],[211,12,211,14],[201,17,201,20],[202,1,202,15],[191,12,191,13],[183,10,183,11],[179,17,179,18],[180,17,180,18],[183,12,183,14],[191,3,191,6],[141,10,141,14],[259,16,259,19],[147,1,147,14],[147,15,147,16],[17,1,17,15],[17,16,17,18],[317,1,321,20],[287,16,287,20],[288,3,288,11],[288,12,288,13],[288,14,288,20],[289,2,289,9],[289,12,289,14],[289,16,289,20],[221,18,221,19],[222,9,222,10],[256,1,256,9],[255,1,255,9],[263,1,263,17],[25,1,25,7],[311,1,311,20],[305,1,305,18],[25,9,25,10],[140,1,140,13],[148,17,148,20],[98,14,98,20],[117,12,117,13],[117,14,117,16]]}
["RENTAL HOUSING PROGRAMS APPLICATION"]
["AFFORDABLE HOUSING COMMISSION"]
[]
["I.","General Information"]
["u","Development Information"]
[null,"Development Name:"]
[null,"Street Address:",null,null,null,null,null,null,null,null,null,null,null,null,"Neighborhood:"]
[null,"St. Louis, MO",null,null,null,null,"Zip:",null,null,null,null,null,null,"Ward:",null,null,"Census Tract:"]
[]
[null,"Property ID#:"]
[]
[]
[]
[]
[]
[]
[]
[null,"Is property located on or north of Delmar Blvd?"]
[null,"Is property in one of the Zip Codes below?"]
[null,null,63101,null,63102,null,63103,null,63106,null,63107,null,63108,null,63112,null,63113,null,63115,null,63147]
[]
[]
[null,"Total Number of Units Planned",null,null,null,null,null,null,null,{"$f":"SUM(J24:K31)","v":0},null,null,"Total Number of AHC-Assisted Units"]
[null,"Number of Market Units",null,null,null,null,null,null,null,null,null,null,"AHC-Assisted ≤20% AMI Units"]
[null,"Number of Units at 80%",null,null,null,null,null,null,null,null,null,null,"# LMI Units",null,null,null,null,null,null,null,{"$f":"J25+J26+J27+J28+J29+J30+J31","v":0}]
[null,"Number of Units at 70%"]
[null,"Number of Units at 60%",null,null,null,null,null,null,null,null,null,null,"You Must Input # of Units in this Section"]
[null,"Number of Units at 50%"]
[null,"Number of Units at 40%"]
[null,"Number of Units at 30%"]
[null,"Number of Units at 20%"]
[null,"Construction Type"]
[null,"Housing Type"]
[null,"Project Summary  Briefly describe your project."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"AHC Subsidy Request (information comes from the Sources & Uses tab, Worksheet 2)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per AHC-Assisted",null,null,null,"Subsidy Per 20%"]
[null,null,null,null,null,null,null,null,null,"Total",null,null,"Per Unit",null,"Unit",null,null,null,"AMI-Assisted Unit"]
[null,"Trust Fund Dollars Request",null,null,null,null,null,null,null,{"$f":"'4) Sources & Uses'!E25","v":0}]
[null,"Total Requested",null,null,null,null,null,null,null,{"$f":"SUM(J69)","v":0},null,null,{"$f":"J70/J23","v":{"$error":"#DIV/0!"}},null,{"$f":"J70/U23","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"(J70/U23)*U24","v":{"$error":"#DIV/0!"}}]
["*AHC funding construction funding will transfer to permanent financing when the project is complete unless otherwise stated."]
[null,"Indicate preferred repayment terms: "]
[]
[]
[]
[]
[]
[null,"All AHC-assisted rental projects should provide affordable housing for 30 years unless otherwise requested."]
[null,"Will this project create and maintain AHC-assisted housing for 30 years?"]
[null,"If this project plans to create and maintain AHC-assisted housing for a shorter restriction period, how long will units remain affordable?"]
[]
[null,"If the project intends to maintain affordable housing for LESS than 30 years, explain why:"]
[]
[]
[]
[]
[]
[null,"Developer Information"]
[null,"Entity Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Federal I.D. #:"]
[null,"Contact Person:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone:"]
[null,"Address:",null,null,null,null,null,null,null,null,null,null,"Email:"]
[null,"City:",null,null,null,null,null,null,null,null,null,"State:",null,null,null,"Zip:"]
[null,"Legal Form:"]
[null,"Is firm a certified Minority-owned Business Enterprise (MBE)?"]
[null,"Is firm a certified Women-owned Business Enterprise (WBE)?"]
[]
[null,"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,"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. #"]
[null,"Is firm a certified Minority-owned Business Enterprise (MBE)?"]
[]
[null,"Is firm a certified Women-owned Business Enterprise (WBE)?"]
[]
[null,"Previous Development Experience"]
[null,"How many full-time equivalent (FTE) employees at developer/CHDO?"]
[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,null,null,null,"New Construction",null,null,null,"#","units:",null,null,null,"Rehab",null,"# units:"]
[null,"List most recently completed projects:"]
[null,"Project Name",null,null,null,"Address",null,null,null,null,"Construction Type",null,"Tenure Type",null,"Target Residents",null,null,"# Units",null,"Total Development. Costs"]
[]
[]
[]
[]
[null,"Describe the experience of the specific staff members who will manage this project.  Attach resumes."]
[]
[]
[]
[]
[null,"If developer has been involved in residential development projects in some other capacity, please specify:"]
[]
[]
[]
[]
[]
["II.","Development Plan Information"]
[null,"Total number of rental units planned",null,null,null,null,null,null,null,null,null,null,null,{"$f":"J23","v":0},null,"units"]
[null,"Number of AHC-Assisted Units planned",null,null,null,null,null,null,null,null,null,null,null,{"$f":"U23","v":0},null,"units"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(info below from Units & Revenue)"]
[null,"Residential Floor Area planned",null,null,null,null,null,null,"fills from Units & Revenue",null,null,null,null,{"$f":"'6) Units & Revenue'!E43","v":0},null,"gross sq. ft.",null,null,{"$f":"IF(N134>=50000,\"Required to Benchmark Energy on an Annual Basis\",\"\")","v":""}]
[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":"G32","v":0}]
[null,"Housing Type",null,null,null,null,{"$f":"G33","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,null,null,null,null,null,null,null,null,"Number of parking spaces"]
[null,"Will the project target special populations beyond Low/Mod Income?"]
[null,null,"If yes, indicate which populations:",null,null,null,null,null,null,null,null,null,null,null,null,"&"]
[]
["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,"This project will be built to a national green standard "]
[null,"If yes, indicate the national green building standard sought:"]
[]
["u","Energy Efficiency - Rehabilitation"]
[null,"AHC gives priority consideration for comprehensive retrofits that will be designed and built to a national green building standard (see Funding Priorities).  All other rehabilitation projects are encouraged to include the following sustainable features.  Indicate which 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,"Description",null,null,null,null,null,null,"Sustainability Certification in addition to"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EPA EnergyStar.  Describe:"]
[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,"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 this project and plans with the Cultural Resources Office?"]
[null,"Property acquired from Land Reutilization Authority?"]
[null,"Form of Site Control:",null,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,"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,"List properties (from above) which have an existing mortgage and state the amount of the outstanding loan."]
[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, 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,"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."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Existing Loan Subsidies in Developments to be Acquired"]
[null,"Does your development plan include acquisition of units with existing subsidies?"]
[null,"If yes, indicate the kind of existing subsidy."]
[]
[]
[]
[]
[]
[null,"Does your development plan seek to preserve federally-assisted low-income housing which would otherwise convert to market rate use through mortgage prepayment, foreclosure or expiring subsidies?"]
[]
["IV.","Ongoing Management Experience, Structure & Capacity"]
[null,"Who will perform property management?"]
[null,"Name of management staff/company:"]
["u","Contact Person:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone:"]
[null,"Address:",null,null,null,null,null,null,null,null,null,null,"Email:"]
[null,"City:",null,null,null,null,null,null,null,null,null,"State:",null,null,null,"Zip:"]
[null,null,"How many units is your staff or 3rd party mgt company currently managing?"]
[]
[null,null,"How many income-restricted units is your staff/mgt company currently managing?"]
[null,"Describe staff/mgt company's experience managing income-restricted rental units."]
[]
[]
[]
[]
[null,"Describe how the roles of property management, asset management & ongoing compliance will be delegated."]
[]
[]
[]
[]
[]
[]
[null,"Rental & Operating Assistance Information"]
[null,"Do you expect to receive or are you currently receiving any rental subsidies for this development?"]
[null,"If you answered yes, check the types of subsidy expected:"]
[null,"If you answered yes, describe the source and purpose of subsides:"]
[]
[]
[]
[]
[null,"Number of units expected to receive assistance:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"units"]
[null,"Number of years in assistance contract:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"years"]
["V.","Supportive Services Information"]
[null,"Entity to perform services"]
[null,"Contact Person:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone:"]
[null,"Address:",null,null,null,null,null,null,null,null,null,null,"Email:"]
[null,"City:",null,null,null,null,null,null,null,null,null,"State:",null,null,null,"Zip:"]
[null,"Is the provider experienced providing affordable housing services?"]
["List locations/projects where provider currently provides services:"]
["Project Name",null,null,null,"Address",null,null,null,null,"Services",null,null,null,null,"Phone",null,null,"Email contact person"]
[]
[]
[]
[]
[null,"Supportive Services"]
[null,null,"Case management",null,null,null,null,null,null,null,null,null,"Other Supportive Services:"]
[null,null,"Healthcare resources"]
[null,null,"Food"]
[null,null,"Housing counseling"]
[null,null,"Job training & placement"]
[null,"(Attach copies of letter of intent from service providers.)"]
[null,"If you plan to provide supportive services to your tenants, please provide the following:"]
["u","Description of the population to be served:"]
[]
[]
[]
[]
[]
[null,"Description of the services to be provided:"]
[]
[]
[]
[]
[null,"Description of the intended benefits of the services to be provided:"]
[]
[]
[]
[]
[]
["VI.","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,"Unit(s) Fully Leased"]
[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,null,null,"Number of months after January 2025",null,null,null,null,null,null,null,null,null,"months"]
["VII.","Development Team Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Certified"]
[null,null,null,null,"Name",null,null,null,null,"Address",null,null,null,null,null,null,"Phone",null,null,"MBE","WBE"]
[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.\n"]
[null,"2."]
[null,"3."]
[null,"4."]
[null,"5."]
[null,"Additional Information:"]
[]
[null,"Track record of architect — list the architect's five most recently completed projects:"]
[null,"1.\n"]
[null,"2."]
[null,"3."]
[null,"4."]
[null,"5."]
[null,"Additional Information:"]
[]
[]
[null,"Does developer or owner hold a direct financial interest in any development team member?"]
[null,"If yes, provide details of the relationship:"]
[]
[]
[]
[]
[]
[null,"Is the Developer, Sponsor, or any Development Team Member, including owners, partners, or board members, currently debarred from contracting opportunities by any agency or Government?"]
[null,"If yes, provide details:"]
[]
[]
[]
[]
[]
[null,"Has the Developer, Sponsor, or any Development Team Member, or any owner, partner, or board member ever been debarred from contracting opportunities by any agency or government?"]
[null,"If yes, provide details:"]
[]
[]
[]
[]
["VIII.","Market Assessment & Leasing"]
[null,"Describe how you determined the need/market demand for the proposed project."]
[]
[]
[]
[]
[null,"Explain how you arrived at the projected rents:"]
[]
[]
[]
[]
[null,"How will you insure lease-up to eligible tenants within 18 months? "]
[]
[]
[]
[]
[]
[null,"Explain how this project positions itself using the neighborhood submarket (from the 2019 MVA, TAB 9) to strategically invest Trust Fund dollars into a housing development that is part of an equitable plan to improve life for low and moderate-income households."]
[]
[]
[]
[]
[]
[]
[]
[]
["IX.","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,null,"Is the sponsor of the proposed development a non-profit?"]
[null,null,null,"If yes, is the non-profit designation registered with the State of Missouri?"]
[null,null,"Has a non-profit determination been made by the Internal Revenue Service?"]
[null,null,null,"If yes, indicate your Internal Revenue Code designation?"]
[null,null,"Is \"fostering low-income housing\" listed among the nonprofit's purposes in Articles of Incorporation and/or By-Laws? (Provide copy)."]
[null,"Explain the role and activities of the Housing or neighborhood organization sponsor in the project."]
[]
[]
[]
[]
[]
["X. Relocation Information"]
[null,"Relocation is the moving of existing residential or commercial occupants from their current space."]
[null,"Will your development require any households to move temporarily?"]
[null,"# of households to move temporarily:"]
[null,"Will your plans require any occupants to move permanently?"]
[null,"# of households to move permanently:"]
[null,"Will your development require any commercial occupants to move?"]
[null,"# of commercial occupants to move:"]
[null,"If you answered yes to any of the above questions, describe your relocation plan."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Omissions:  List all required documents that are not included in this application."]
[]
[]
[]
[]
[]
[]
["XI.","Application Checklist",null,null,null,null,null,null,null,null,{"$f":"project","v":0}]
[1,"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-15) 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."]
[2,"Locator Map - indicating the location of the proposed development."]
[3,"Completed City of St. Louis Affordable Housing Commission Rental Housing Programs Application.  All omissions must be stated on page 12 of the application.  CERTIFICATIONS MUST BE SIGNED."]
[4,"A single copy of all other funding applications for each source of funding sought.  Insert into binder copy."]
[5,"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."]
[6,"Letter of Interest from a construction lender or proof of funds, dated within the last 6 months."]
[7,"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."]
[8,"Aldermanic letter of support from project ward Alderman, dated within the last 6 months."]
[9,"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."]
[10,"Applicant's Certificate of Corporate Good Standing, dated within the last 6 months."]
[11,"City of St. Louis Business License, dated within the last 12 months."]
[null,"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."]
["AHC Rental Housing Application Worksheets (tabs)"]
[null,1,"AHC Application"]
[null,2,"Development Budget"]
[null,3,"Construction Costs"]
[null,4,"Sources & Uses"]
[null,5,"Utilities"]
[null,6,"Units & Revenue"]
[null,7,"Operating Budget"]
[null,8,"Cash Flow"]
[null,9,"MVA"]
[null,10,"Priorities"]
[null,11,"UD Universal Design"]
[null,12,"Living Wage"]
[null,13,"Sustainability Impact Statement."]
[null,14,1099]
[]
["XII.","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":"+project","v":0}]
[null,null,"will comply with the City's Lead Safe Requirements."]
[null,null,"Signed:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,null,null,null,null,"Developer Signature"]
[]
[null,null,null,null,null,"Developer Print Name"]
[null,"Is this a new construction project?"]
[]
[null,null,"I certify that ",null,null,{"$f":"+project","v":0}]
[null,null,"will comply with the Affordable Housing Commission'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"]
[]
[null,"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:"]
[]
[]
[]
[]
[]
[]
[null,"I certify the above statements that support this application’s UD Waiver are true and accurate:"]
[]
[]
[null,null,null,"Registered Architect Print Name",null,null,null,null,null,null,null,null,null,null,null,null,"Firm"]
[]
[null,"Signed:"]
[null,null,null,"Registered Architect Signature",null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[null,null,null,"No exceptions will be granted to the basic four elements:"]
[null,null,null,"1)   one no-step entry."]
[null,null,null,"2)   minimum door and hallway width requirements."]
[null,null,null,"3)   provisions for useable bathroom facilities in the unit on an accessible level."]
[null,null,null,"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":112,"n_cols":17,"rows_kept":112,"cut":false,"hidden":false,"merged":[[4,13,4,15],[108,1,108,3],[108,4,108,6],[105,1,105,3],[105,4,105,6],[106,1,106,3],[106,4,106,6],[107,1,107,3],[107,4,107,6],[67,1,67,3],[67,4,67,6],[104,1,104,3],[104,4,104,6],[97,1,97,3],[97,4,97,6],[98,1,98,3],[98,4,98,6],[96,1,96,3],[96,4,96,6],[95,1,95,3],[95,4,95,6],[42,8,42,9],[43,8,43,9],[10,8,10,9],[0,0,0,16],[1,0,1,16],[2,2,2,3],[3,7,3,10],[7,8,7,9],[8,8,8,9],[63,1,63,3],[63,4,63,6],[44,8,44,9],[35,8,35,9],[36,8,36,9],[37,8,37,9],[38,8,38,9],[31,8,31,9],[32,8,32,9],[33,8,33,9],[34,8,34,9],[49,8,49,9],[50,8,50,9],[51,8,51,9],[52,8,52,9],[51,1,51,3],[27,8,27,9],[11,8,11,9],[16,8,16,9],[18,6,18,11],[19,8,19,9],[20,8,20,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[17,8,17,9],[65,4,65,6],[64,1,64,3],[64,4,64,6],[30,8,30,9],[21,8,21,9],[22,8,22,9],[25,8,25,9],[26,8,26,9],[39,8,39,9],[28,8,28,9],[29,8,29,9],[68,8,68,9],[70,8,70,9],[73,8,73,9],[74,8,74,9],[51,4,51,6],[45,8,45,9],[46,8,46,9],[47,8,47,9],[48,8,48,9],[64,8,64,9],[65,8,65,9],[66,8,66,9],[67,8,67,9],[60,8,60,9],[61,8,61,9],[62,8,62,9],[63,8,63,9],[54,0,54,16],[55,0,55,16],[56,2,56,3],[57,7,57,10],[66,1,66,3],[66,4,66,6],[65,1,65,3],[89,8,89,9],[90,8,90,9],[91,8,91,9],[92,8,92,9],[93,8,93,9],[75,8,75,9],[76,8,76,9],[77,8,77,9],[79,8,79,9],[87,8,87,9],[88,8,88,9],[4,7,4,10],[111,8,111,9],[2,7,2,10],[56,7,56,10],[105,8,105,9],[106,8,106,9],[107,8,107,9],[108,8,108,9],[109,8,109,9],[110,8,110,9],[99,8,99,9],[104,8,104,9],[94,8,94,9],[95,8,95,9],[96,8,96,9],[97,8,97,9],[100,8,100,9],[101,8,101,9],[102,8,102,9],[103,8,103,9],[82,8,82,9],[83,8,83,9],[98,8,98,9],[84,8,84,9]]}
["Affordable Housing Commission Rental Production Application/Proforma"]
["DEVELOPMENT BUDGET"]
[null,"Project:",{"$f":"project","v":0},null,null,null,"Developer:",{"$f":"dev","v":0},null,null,null,"Square Feet",null,{"$f":"'3) Construction Costs'!M2","v":0},null,"Total Units:",{"$f":"'1) Application'!J23","v":0}]
["AHC Request:",null,null,{"$f":"'1) Application'!J70","v":0},null,null,"Address:",{"$f":"'1) Application'!F7","v":0},null,null,null,"Construction",null,{"$f":"'1) Application'!G32","v":0},null,"AHC Units:",{"$f":"'1) Application'!U23","v":0}]
["Construction:",null,null,{"$f":"'1) Application'!G32","v":0},null,null,"Housing Type:",{"$f":"'1) Application'!G33","v":0},null,null,null,null,null,"≤20% AMI Units:",null,null,{"$f":"'1) Application'!U24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LMI Units:",{"$f":"'1) Application'!U25","v":0}]
[]
[null,"DEVELOPMENT COSTS",null,null,null,null,null,null,"Total"]
[null,"Total Construction Cost",null,null,null,null,null,null,{"$f":"'3) Construction Costs'!K73","v":0},null,null,"From Construction Cost, Tab 3"]
[]
[null,"PREDEVELOPMENT COST",null,null,null,null,null,null,"TOTAL",null,null,"Per Unit",null,"Per SF",null,"% TDC"]
[null,"Architect & Engineering Fee-Design",null,null,null,null,null,null,null,null,null,{"$f":"I12/$Q$3","v":{"$error":"#DIV/0!"}}]
[null,"Architect Fee - Supervision",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Soils Report",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Survey",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Engineering ",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Total Predevelopment:",null,null,null,null,null,null,{"$f":"SUM(I12:J16)","v":0},null,null,{"$error":"#DIV/0!"},null,{"$f":"I17/SqFt","v":{"$error":"#DIV/0!"}},null,{"$f":"I17/$I$112","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,{"$f":"I9+I17","v":0}]
[null,"CONSTRUCTION COSTS",null,null,null,null,"fills from Construction Costs Tab 3"]
[null,"General Cond., Overhead & Profit",null,null,null,null,null,null,{"$f":"'3) Construction Costs'!K66+'3) Construction Costs'!K70+'3) Construction Costs'!K71","v":0},null,null,{"$f":"I20/$Q$3","v":{"$error":"#DIV/0!"}}]
[null,"Construction Contingency",null,null,null,null,null,null,{"$f":"'3) Construction Costs'!K72","v":0},null,null,{"$f":"I21/$Q$3","v":{"$error":"#DIV/0!"}}]
[null,"Construction Hard Costs",null,null,null,null,null,null,{"$f":"'3) Construction Costs'!K73-'2) Development Budget'!I20-'2) Development Budget'!I21","v":0},null,null,{"$f":"I22/$Q$3","v":{"$error":"#DIV/0!"}}]
[null,"Total Construction",null,null,null,null,null,null,{"$f":"SUM(I20:I22)","v":0},null,null,{"$f":"I23/$Q$3","v":{"$error":"#DIV/0!"}},null,{"$f":"I23/SqFt","v":{"$error":"#DIV/0!"}},null,{"$f":"I23/$I$112","v":{"$error":"#DIV/0!"}}]
[]
[null,"CARRYING AND CONSTRUCTION FINANCING COSTS"]
[null,"Construction Loan Interest",null,null,null,null,null,null,null,null,null,{"$f":"I26/$Q$3","v":{"$error":"#DIV/0!"}}]
[null,"Construction Period R.E.Taxes",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Construction Period Insurance",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"MHDC Rental Production Application Fee",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"MHDC Construction Loan Fee",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other Construction Loan Fee",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"MHDC Construction Inspection Fee",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other Construction Inspection Fee",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"MHDC Permanent Financing Fee ",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other Permanent Financing Fee",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Environmental Study",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Market Study ",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Appraisal",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Title Recording & Disbursing (Construction Loan)",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Total Carrying/Finance:",null,null,null,null,null,null,{"$f":"SUM(I26:J39)","v":0},null,null,{"$error":"#DIV/0!"},null,{"$f":"I40/SqFt","v":{"$error":"#DIV/0!"}},null,{"$f":"I40/$I$112","v":{"$error":"#DIV/0!"}}]
[]
[null,"PERMANENT FINANCING"]
[null,"Title Recording & Disbursing (Permanent Loan)",null,null,null,null,null,null,null,null,null,{"$f":"I43/$Q$3","v":{"$error":"#DIV/0!"}}]
[null,"Legal (Construction)",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Legal (Permanent)",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Organization (Legal/Fees)",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Cost Certification",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Accountant's Fee",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Prepaid MIP (Risk Share only)",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Environmental Abatement",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Historic Credit Fees",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other: ",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Total Permanent Financing",null,null,null,null,null,null,{"$f":"SUM(I43:J52)","v":0},null,null,{"$error":"#DIV/0!"},null,{"$f":"I53/SqFt","v":{"$error":"#DIV/0!"}},null,{"$f":"I53/$I$112","v":{"$error":"#DIV/0!"}}]
[]
["Affordable Housing Commission Rental Production Application/Proforma, Page 2"]
["DEVELOPMENT BUDGET"]
[null,"Project:",{"$f":"project","v":0},null,null,null,"Developer:",{"$f":"dev","v":0},null,null,null,"Square Feet",null,{"$f":"SqFt","v":0},null,"Total Units:",{"$f":"'1) Application'!J23","v":0}]
[null,null,null,null,null,null,"Address:",{"$f":"'1) Application'!F7","v":0},null,null,null,"Construction",null,{"$f":"'1) Application'!G32","v":0},null,"AHC Units:",{"$f":"'1) Application'!U23","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20% AMI Units:",{"$f":"'1) Application'!U24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LMI Units:",{"$f":"'1) Application'!U25","v":0}]
[null,"PROFESSIONAL SERVICES",null,null,null,null,null,null,"TOTAL",null,null,"Per Unit",null,"Per SF",null,"% TDC"]
[null,"Relocation ",null,null,null,null,null,null,null,null,null,{"$f":"I62/$Q$57","v":{"$error":"#DIV/0!"}}]
[null,"FF & E",null,null,null,null,null,null,null,null,null,{"$f":"I63/$Q$57","v":{"$error":"#DIV/0!"}}]
[null,"Other:(Describe)",null,"Security Systems",null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other:(Describe)",null,"Historic Consult",null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other:(Describe)",null,"Resnet/HRS",null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other:(Describe)",null,"Investor Legal",null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other:(Describe)",null,"MHDC Cost Analysis",null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Total Professional Services",null,null,null,null,null,null,{"$f":"SUM(I62:J68)","v":0},null,null,{"$error":"#DIV/0!"},null,{"$f":"I69/SqFt","v":{"$error":"#DIV/0!"}},null,{"$f":"I69/$I$112","v":{"$error":"#DIV/0!"}}]
[]
[null,"Replacement Cost w/o Acquisition",null,null,null,null,null,null,{"$f":"I69+I53+I40+I18","v":0},null,null,{"$f":"I71/Q57","v":{"$error":"#DIV/0!"}}]
[]
[null,"BUILDING AND PROPERTY ACQUISITION"]
[null,"Legal (Acquisition & Recording)",null,null,null,null,null,null,null,null,null,{"$f":"I74/$Q$57","v":{"$error":"#DIV/0!"}}]
[null,"Acquisition-Cost of Buildings",null,null,null,null,null,null,null,null,null,{"$f":"I75/$Q$57","v":{"$error":"#DIV/0!"}}]
[null,"Other Acquisition Related Costs",null,null,null,null,null,null,null,null,null,{"$f":"I76/$Q$57","v":{"$error":"#DIV/0!"}}]
[null,"Acquisition-Cost of Land",null,null,null,null,null,null,null,null,null,{"$f":"I77/$Q$57","v":{"$error":"#DIV/0!"}}]
[null,"Acquisition Cost",null,null,null,null,null,null,{"$f":"SUM(I74:J77)","v":0},null,null,{"$f":"I78/$Q$57","v":{"$error":"#DIV/0!"}},null,{"$f":"I78/SqFt","v":{"$error":"#DIV/0!"}},null,{"$f":"I78/$I$112","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Replacement Cost (lines 53-57)",null,null,null,null,null,null,{"$f":"SUM(I71:J77)","v":0},null,null,{"$f":"I80/Q57","v":{"$error":"#DIV/0!"}},null,{"$f":"I80/SqFt","v":{"$error":"#DIV/0!"}},null,{"$f":"I80/$I$112","v":{"$error":"#DIV/0!"}}]
[]
[null,"FEES/MISC"]
[null,"Developer's Fee (Before Completion)",null,null,null,null,null,null,null,null,null,{"$f":"I83/$Q$57","v":{"$error":"#DIV/0!"}},null,{"$f":"I83/SqFt","v":{"$error":"#DIV/0!"}},null,{"$f":"I83/$I$112","v":{"$error":"#DIV/0!"}}]
[null,"Developer's Fee (At/After Completion)",null,null,null,null,null,null,null,null,null,{"$f":"I84/$Q$57","v":{"$error":"#DIV/0!"}},null,{"$f":"I84/SqFt","v":{"$error":"#DIV/0!"}},null,{"$f":"I84/$I$112","v":{"$error":"#DIV/0!"}}]
[null,"Total Developer Fee",null,null,null,null,null,null,{"$f":"SUM(I83:J84)","v":0},null,null,{"$f":"I85/$Q$57","v":{"$error":"#DIV/0!"}},null,{"$f":"I85/N3","v":{"$error":"#DIV/0!"}},null,{"$f":"I85/I112","v":{"$error":"#DIV/0!"}}]
[]
[null,"OTHER FEES/BONDS/MISC"]
[null,"Consultant's Fee (Before Completion)",null,null,null,null,null,null,null,null,null,{"$f":"I88/$Q$57","v":{"$error":"#DIV/0!"}}]
[null,"Consultant's Fee (At/After Completion)",null,null,null,null,null,null,null,null,null,{"$f":"I89/$Q$57","v":{"$error":"#DIV/0!"}}]
[null,"Tax Credit Allocation Fee (7%)",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Tax Credit Monitoring Fee",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"AHAP Application & Reservation Fee",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Bond Related Costs",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Syndication Costs",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Lease-up/Marketing",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other:(Describe)",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other:(Describe)",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other:(Describe)",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other:(Describe)",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Total Fees/Misc",null,null,null,null,null,null,{"$f":"SUM(I88:J99)","v":0},null,null,{"$error":"#DIV/0!"},null,{"$f":"I100/SqFt","v":{"$error":"#DIV/0!"}},null,{"$f":"I100/$I$112","v":{"$error":"#DIV/0!"}}]
[]
[null,"RESERVES"]
[null,"Operating Reserve (cash escrow)",null,null,null,null,null,null,null,null,null,{"$f":"I103/$Q$57","v":{"$error":"#DIV/0!"}}]
[null,"Replacement Reserve (cash escrow)",null,null,null,null,null,null,null,null,null,{"$f":"I104/$Q$57","v":{"$error":"#DIV/0!"}}]
[null,"Other Escrow(s):",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other Escrow(s):",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other Escrow(s):",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other Escrow(s):",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Other Escrow(s):",null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Total Reserves",null,null,null,null,null,null,{"$f":"SUM(I103:J109)","v":0},null,null,{"$error":"#DIV/0!"},null,{"$f":"I110/SqFt","v":{"$error":"#DIV/0!"}},null,{"$f":"I110/$I$112","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Development Costs",null,null,null,null,null,null,{"$f":"I110+I100+I85+I80","v":0},null,null,{"$f":"I112/Q3","v":{"$error":"#DIV/0!"}},null,{"$f":"I112/SqFt","v":{"$error":"#DIV/0!"}},null,{"$f":"I112/$I$112","v":{"$error":"#DIV/0!"}}]

{"sheet":"3) Construction Costs","index":3,"n_rows":107,"n_cols":21,"rows_kept":107,"cut":false,"hidden":false,"merged":[[6,3,6,8],[3,2,3,8],[4,3,4,9],[91,10,91,12],[92,10,92,12],[93,10,93,12],[90,10,90,12],[103,10,103,12],[104,10,104,12],[87,9,87,12],[84,2,84,8],[84,12,84,15],[85,3,85,8],[55,10,55,13],[56,10,56,13],[86,3,86,8],[77,15,77,16],[7,15,7,17],[11,10,11,13],[74,10,74,13],[73,15,73,16],[74,15,74,16],[61,1,61,3],[59,1,59,3],[106,10,106,12],[102,4,102,6],[103,4,103,6],[104,4,104,6],[94,10,94,12],[95,10,95,12],[96,10,96,12],[97,10,97,12],[98,10,98,12],[101,10,101,12],[102,10,102,12],[99,10,99,12],[100,10,100,12],[0,0,0,22],[81,0,81,22],[70,10,70,13],[72,10,72,13],[63,10,63,13],[69,20,69,21],[65,10,65,13],[75,10,75,13],[83,4,83,6],[75,15,75,16],[80,0,80,22],[76,10,76,13],[77,10,77,13],[83,12,83,13],[5,3,5,6],[61,4,61,6],[58,20,58,21],[59,4,59,6],[60,1,60,3],[60,4,60,6],[61,20,61,21],[46,20,46,21],[72,20,72,21],[54,10,54,13],[71,20,71,21],[47,20,47,21],[60,20,60,21],[59,20,59,21],[63,20,63,21],[65,20,65,21],[66,20,66,21],[48,10,48,13],[49,10,49,13],[49,20,49,21],[53,10,53,13],[55,20,55,21],[67,10,67,13],[61,10,61,13],[70,20,70,21],[69,10,69,13],[67,20,67,21],[58,10,58,13],[59,10,59,13],[60,10,60,13],[62,10,62,13],[71,10,71,13],[44,20,44,21],[41,20,41,21],[43,20,43,21],[42,10,42,13],[42,20,42,21],[37,20,37,21],[57,20,57,21],[54,20,54,21],[56,20,56,21],[45,10,45,13],[53,20,53,21],[52,20,52,21],[47,10,47,13],[48,20,48,21],[57,10,57,13],[45,20,45,21],[52,10,52,13],[41,10,41,13],[43,10,43,13],[46,10,46,13],[44,10,44,13],[36,20,36,21],[35,10,35,13],[33,20,33,21],[40,10,40,13],[40,20,40,21],[39,10,39,13],[35,20,35,21],[39,20,39,21],[38,10,38,13],[38,20,38,21],[37,10,37,13],[36,10,36,13],[32,20,32,21],[28,10,28,13],[29,20,29,21],[32,10,32,13],[31,10,31,13],[30,20,30,21],[31,20,31,21],[34,10,34,13],[34,20,34,21],[33,10,33,13],[30,10,30,13],[29,10,29,13],[17,20,17,21],[26,10,26,13],[24,10,24,13],[25,10,25,13],[21,10,21,13],[22,10,22,13],[27,10,27,13],[24,20,24,21],[18,10,18,13],[23,10,23,13],[1,10,1,11],[2,10,2,11],[2,12,2,15],[1,12,1,15],[6,18,6,19],[10,10,10,13],[8,17,8,22],[2,4,2,6],[76,15,76,16],[25,20,25,21],[27,20,27,21],[28,20,28,21],[23,20,23,21],[14,20,14,21],[15,20,15,21],[15,10,15,13],[18,20,18,21],[14,10,14,13],[21,20,21,21],[22,20,22,21],[26,20,26,21],[16,10,16,13],[17,10,17,13],[16,20,16,21]]}
["CONTRACTOR'S/MORTGAGOR'S COST BREAKDOWN"]
[null,null,null,null,null,null,null,null,null,null,"Square Feet: ",null,{"$f":"'6) Units & Revenue'!E43","v":0},null,null,null,"Units:",null,{"$f":"'1) Application'!J23","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Construction:",null,{"$f":"'1) Application'!G32","v":0},null,null,null,"AHC Units:",null,{"$f":"'1) Application'!U23","v":0}]
["Project:",null,{"$f":"project","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"20% AMI Units:",null,{"$f":"'1) Application'!U24","v":0}]
["Developer:",null,null,{"$f":"dev","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"LMI Units:",null,{"$f":"'1) Application'!U25","v":0}]
["AHC Request:",null,null,{"$f":"'1) Application'!J70","v":0}]
["Address:",null,null,{"$f":"'1) Application'!F7","v":0},null,null,null,null,null,null,"Costs are based on prevailing wage rates:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date of Plans used for estimate: "]
[]
[null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,"Per   ",null,"Per  ",null,"%"]
[null,"Item Description of Work",null,null,null,null,null,null,null,null,"Scheduled Value",null,null,null,null,null,"Unit",null,"SF",null,"Construction"]
[]
["Site Work"]
[1,"Earthwork",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K15/$S$2","v":{"$error":"#DIV/0!"}},null,{"$f":"K15/$M$2","v":{"$error":"#DIV/0!"}},null,{"$f":"K15/$K$73","v":{"$error":"#DIV/0!"}}]
[2,"Site Utilities",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$f":"K16/$S$2","v":{"$error":"#DIV/0!"}},null,{"$f":"K16/$M$2","v":{"$error":"#DIV/0!"}},null,{"$f":"K16/$K$73","v":{"$error":"#DIV/0!"}}]
[3,"Roads & Walks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"K17/$K$73","v":{"$error":"#DIV/0!"}}]
[4,"Off Site Work",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"K18/$K$73","v":{"$error":"#DIV/0!"}}]
["Subtotal Sitework",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K15:N18)","v":0},null,null,null,null,null,{"$f":"SUM(Q15:Q18)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(S15:S18)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(U15:V18)","v":{"$error":"#DIV/0!"}}]
[]
["New Building/Rehabilitation"]
[5,"Concrete",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"K22/$K$73","v":{"$error":"#DIV/0!"}}]
[6,"Masonry",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[7,"Structural Metals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[8,"Rough Carpentry",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[9,"Finish Carpentry",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[10,"Cabinets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[11,"Waterproofing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[12,"Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[13,"Roofing Systems",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[14,"Siding",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[15,"Gutters & Downspouts",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[16,"Doors & Hardware",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[17,"Windows",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[18,"Drywall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[19,"Flooring",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[20,"Carpet",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[21,"Painting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[22,"Signage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[23,"Bathroom & Closet Accessories",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[24,"Appliances",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[25,"Window Coverings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[26,"Plumbing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[27,"Fire Sprinklers",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[28,"HVAC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[29,"Electrical",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[30,"Fire Alarm Systems",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[31,"Special Equipment",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[32,"Landscaping",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
["Subtotal Structure",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K22:N49)","v":0},null,null,null,null,null,{"$f":"SUM(Q22:Q49)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(S22:S49)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(U22:V49)","v":{"$error":"#DIV/0!"}}]
[]
["Demolition/Other"]
[33,"MHDC Approved Impact Fees",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"K53/$K$73","v":{"$error":"#DIV/0!"}}]
[34,"Accessory Bldg",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[35,"Demolition (interior rehab)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[36,"Demolition (land make-ready)",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[37,"Sheet Metal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[38,"Bonding",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[39,"Building Permits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[40,"Other",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[41,"Other",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[42,"Other",null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
["Demolition Subtotal",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K53:N62)","v":0}]
["Construction Subtotal",null,null,null,null,null,null,null,null,null,{"$f":"K63+K50+K19","v":0},null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[]
["General Requirements (Attach separate",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K66/K64","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"K66/$K$73","v":{"$error":"#DIV/0!"}}]
[null,"   page detailing costs)"]
["Subtotal",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K64:N66)","v":0},null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"K68/$K$73","v":{"$error":"#DIV/0!"}}]
[]
["Builder's Overhead",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K70/K64","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"K70/$K$73","v":{"$error":"#DIV/0!"}}]
["Builder's Profit",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K71/K64","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"K71/$K$73","v":{"$error":"#DIV/0!"}}]
["Construction Contingency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K72/S2","v":{"$error":"#DIV/0!"}},null,{"$f":"K72/M2","v":{"$error":"#DIV/0!"}},null,{"$f":"K72/K73","v":{"$error":"#DIV/0!"}}]
["TOTAL CONSTRUCTION",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K68:N72)","v":0},null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"K73/$K$73","v":{"$error":"#DIV/0!"}}]
[]
["General Requirements",null,null,null,null,null,null,null,null,null,"% Construction",null,null,null,null,"Limits"]
["General Requirement",null,null,null,null,null,null,null,null,null,{"$f":"K66/K73","v":{"$error":"#DIV/0!"}},null,null,null,null,0.06]
["Builder's Overhead",null,null,null,null,null,null,null,null,null,{"$f":"K70/K73","v":{"$error":"#DIV/0!"}},null,null,null,null,0.02]
["Builders Profit",null,null,null,null,null,null,null,null,null,{"$f":"K71/K73","v":{"$error":"#DIV/0!"}},null,null,null,null,0.08]
[]
[]
["CONTRACTOR'S/MORTGAGOR'S COST BREAKDOWN"]
["SUPPLEMENTAL SHEET FOR GENERAL REQUIREMENTS"]
[]
[null,null,null,null,null,null,null,null,null,null,"Square Feet: ",null,{"$f":"'4) Sources & Uses'!F5","v":0},null,null,null,"Units:",null,{"$f":"S2","v":0}]
["Project  ",null,{"$f":"project","v":0},null,null,null,null,null,null,null,"Construction:",null,{"$f":"'1) Application'!G137","v":0},null,null,null,"AHC Units:",null,{"$f":"S3","v":0}]
["Developer",null,null,{"$f":"dev","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"20% AMI Units:",null,{"$f":"'1) Application'!U24","v":0}]
["Address",null,null,{"$f":"'1) Application'!F7","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LMI Units:",null,{"$f":"'1) Application'!U25","v":0}]
[null,"Item Description of Work",null,null,null,null,null,null,null,null,"Scheduled Value"]
[]
[1,"Supervision",null,null,null,null,null,null,null,null,0]
[2,"Field Engineering",null,null,null,null,null,null,null,null,0]
[3,"Field Office Expense",null,null,null,null,null,null,null,null,0]
[4,"Building Permits",null,null,null,null,null,null,null,null,0]
[5,"Temporary Facilities",null,null,null,null,null,null,null,null,0]
[6,"Temporary Utilities",null,null,null,null,null,null,null,null,0]
[7,"Cleaning/Rubbish Removal",null,null,null,null,null,null,null,null,0]
[8,"Watchman Wages",null,null,null,null,null,null,null,null,0]
[9,"Builder's Risk Insurance",null,null,null,null,null,null,null,null,0]
[10,"Testing",null,null,null,null,null,null,null,null,0]
[11,"Bond Premium",null,null,null,null,null,null,null,null,0]
[12,"Contractor's Cost Certification",null,null,null,null,null,null,null,null,0]
[13,"Other Fees:",null,null,null,null,null,null,null,null,0]
[14,"Other Fees:",null,null,null,null,null,null,null,null,0]
[15,"Other Fees:",null,null,null,null,null,null,null,null,0]
[]
["GENERAL REQUIREMENTS SUBTOTAL",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K91:M106)","v":0}]

{"sheet":"4) Sources & Uses","index":4,"n_rows":86,"n_cols":10,"rows_kept":86,"cut":false,"hidden":false,"merged":[[32,10,35,11],[13,7,13,8],[35,8,36,9],[95,1,95,6],[86,1,86,6],[36,1,36,6],[77,3,77,4],[78,3,78,4],[79,3,79,4],[82,5,82,6],[81,3,81,4],[80,3,80,4],[94,1,94,6],[42,1,42,4],[43,1,43,4],[74,3,74,4],[12,7,12,8],[6,5,6,6],[31,1,31,3],[26,1,26,3],[37,1,37,3],[6,2,6,3],[4,2,4,3],[3,5,3,6],[5,2,5,3],[76,5,76,6],[7,5,7,6],[75,3,75,4],[43,8,43,9],[44,8,44,9],[45,8,45,9],[0,1,0,9],[1,1,1,9],[37,8,37,9],[25,1,25,3],[27,1,27,3],[29,1,29,3],[28,1,28,3],[30,1,30,3],[32,1,32,3],[34,7,34,8],[5,5,5,6],[4,5,4,6],[3,2,3,3],[73,7,73,8],[72,7,72,8],[74,7,74,8],[62,5,62,7],[74,5,74,6],[70,3,70,8],[82,3,82,4],[82,7,82,8],[76,7,76,8],[77,7,77,8],[75,7,75,8],[80,7,80,8],[81,7,81,8],[78,7,78,8],[79,7,79,8],[77,5,77,6],[78,5,78,6],[79,5,79,6],[76,3,76,4],[75,5,75,6],[80,5,80,6],[81,5,81,6],[38,8,38,9],[39,8,39,9],[40,8,40,9],[41,8,41,9],[42,8,42,9]]}
[null,"Affordable Housing Commission Rental Production Application/Proforma"]
[null,"Sources & Uses Summary"]
[]
[null,"Project Name",{"$f":"project","v":0},null,"Unit Type",{"$f":"'1) Application'!G138","v":0},null,"Total Units:",{"$f":"'1) Application'!J23","v":0}]
[null,"Developer",{"$f":"dev","v":0},null,"Total Square Feet:",{"$f":"SqFt","v":0},null,"AHC Units:",{"$f":"'1) Application'!U23","v":0}]
[null,"Project Type:",{"$f":"'1) Application'!G137","v":0},null,"Avg SqFt/Unit:",{"$f":"F5/I4","v":{"$error":"#DIV/0!"}},null,"20% AMI Units:",{"$f":"'1) Application'!U24","v":0}]
[null,"AHC Request:",{"$f":"'1) Application'!J70","v":0},null,"Target Population:",{"$f":"'1) Application'!K142","v":0},null,"LMI Units:",{"$f":"'1) Application'!U25","v":0}]
[null,null,null,null,"Average Rent",{"$f":"'6) Units & Revenue'!S31","v":{"$error":"#DIV/0!"}}]
[]
[null,"Development Costs",null,null,"Total","Per Unit","% of Total"]
[null,"Total Predevelopment",null,null,{"$f":"'2) Development Budget'!I17","v":0},{"$f":"E11/$I$4","v":{"$error":"#DIV/0!"}},{"$f":"E11/$E$21","v":{"$error":"#DIV/0!"}}]
[null,"Total Acquisition",null,null,{"$f":"'2) Development Budget'!I78","v":0},{"$f":"E12/$I$4","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"Total Construction",null,null,{"$f":"'2) Development Budget'!I23","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Construction Cost/SqFt:",null,{"$f":"E13/F5","v":{"$error":"#DIV/0!"}}]
[null,"Total Professional Services",null,null,{"$f":"'2) Development Budget'!I69","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Total Cost/SqFt:",null,{"$f":"E21/F5","v":{"$error":"#DIV/0!"}}]
[null,"Total Carrying & Construction Financing",null,null,{"$f":"'2) Development Budget'!I40","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Total Permanent Financing",null,null,{"$f":"'2) Development Budget'!I53","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Total Reserves",null,null,{"$f":"'2) Development Budget'!I110","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Total Fees/Misc (not Developer Fee)",null,null,{"$f":"'2) Development Budget'!I100","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Developer Fee before completion",null,null,{"$f":"'2) Development Budget'!I83","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Developer Fee after completion",null,null,{"$f":"'2) Development Budget'!I84","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Total Development Costs",null,null,{"$f":"SUM(E11:E20)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Permanent Sources",null,"Source:","Total","Per Unit","% of Total","Interest Rate","Loan Term","Annual Payment"]
[null,"Bank Mortgage ","Est. mortgage:",{"$f":"'7) Operating Budget'!I45","v":0},null,{"$f":"E24/$I$4","v":{"$error":"#DIV/0!"}},{"$f":"E24/'2) Development Budget'!$I$112","v":{"$error":"#DIV/0!"}}]
[null,"AHC Permanent Loan requested*",null,null,null,{"$f":"E25/$I$4","v":{"$error":"#DIV/0!"}},{"$f":"E25/'2) Development Budget'!$I$112","v":{"$error":"#DIV/0!"}}]
[null,"Estimated MO State Historic Tax Credits",null,null,null,{"$error":"#DIV/0!"},{"$f":"E26/'2) Development Budget'!$I$112","v":{"$error":"#DIV/0!"}}]
[null,"Estimated Federal Historic Tax Credits",null,null,null,{"$error":"#DIV/0!"},{"$f":"E27/'2) Development Budget'!$I$112","v":{"$error":"#DIV/0!"}}]
[null,"Developer Equity",null,null,null,{"$error":"#DIV/0!"},{"$f":"E28/'2) Development Budget'!$I$112","v":{"$error":"#DIV/0!"}}]
[null,"Source 1: CDA",null,null,null,{"$error":"#DIV/0!"},{"$f":"E29/'2) Development Budget'!$I$112","v":{"$error":"#DIV/0!"}}]
[null,"Source 2:",null,null,null,{"$error":"#DIV/0!"},{"$f":"E30/'2) Development Budget'!$I$112","v":{"$error":"#DIV/0!"}}]
[null,"Source 3:",null,null,null,{"$error":"#DIV/0!"},{"$f":"E31/'2) Development Budget'!$I$112","v":{"$error":"#DIV/0!"}}]
[null,"Source 4:",null,null,null,{"$error":"#DIV/0!"},{"$f":"E32/'2) Development Budget'!$I$112","v":{"$error":"#DIV/0!"}}]
[null,"Source 5:",null,null,null,{"$error":"#DIV/0!"},{"$f":"E33/'2) Development Budget'!$I$112","v":{"$error":"#DIV/0!"}}]
[null,"Total Sources",null,null,{"$f":"SUM(E24:E33)","v":0},{"$error":"#DIV/0!"},{"$f":"E34/'2) Development Budget'!I112","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(J24:J33)","v":0}]
[null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"(GAP) or Surplus",null,null,{"$f":"E34-E21","v":0},{"$error":"#DIV/0!"},{"$f":"(E36/'2) Development Budget'!I112)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF('7) Operating Budget'!I37/J34<'7) Operating Budget'!I41,\"Debt Payments Exceed Amount Allowed by DCR!\", \"\")","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF(E34=E21,\"\",\"Sources & Uses Do Not Match\")","v":""}]
[null,"Construction Financing Sources            (May include permanent sources listed above.)",null,null,null,"Amount Available During Construction","% TDC","Const. Loan Interest Rate","Developer Notes"]
[null,"Private Construction Loan  (bank financing)",null,null,null,null,{"$f":"F39/'2) Development Budget'!$I$112","v":{"$error":"#DIV/0!"}}]
[null,"Developer Equity  (Self-financing for acquisition, predevelopment, etc.)",null,null,null,null,{"$f":"F40/'2) Development Budget'!$I$112","v":{"$error":"#DIV/0!"}}]
[null,"Deferred Developer Fee",null,null,null,null,{"$f":"F41/'2) Development Budget'!$I$112","v":{"$error":"#DIV/0!"}}]
[null,"Other:  CDA",null,null,null,null,{"$f":"F42/'2) Development Budget'!$I$112","v":{"$error":"#DIV/0!"}}]
[null,"Other Source 2:",null,null,null,null,{"$f":"F43/'2) Development Budget'!$I$112","v":{"$error":"#DIV/0!"}}]
[null,"Other Source 3:",null,null,null,null,{"$f":"F44/'2) Development Budget'!$I$112","v":{"$error":"#DIV/0!"}}]
[null,"AHC Construction Loan requested*",null,null,null,null,{"$f":"F45/'2) Development Budget'!$I$112","v":{"$error":"#DIV/0!"}}]
[null,"Costs not incurred during construction (reserves, dev. fee)",null,null,null,{"$f":"'2) Development Budget'!I85+'2) Development Budget'!I110-'2) Development Budget'!I83","v":0},{"$f":"F46/'2) Development Budget'!$I$112","v":{"$error":"#DIV/0!"}}]
[null,"Total Construction Sources",null,null,null,{"$f":"SUM(F39:F46)","v":0},{"$f":"F47/'2) Development Budget'!$I$112","v":{"$error":"#DIV/0!"}}]
[null,"Construction Financing Surplus/(Gap)?",null,null,null,{"$f":"F47-'2) Development Budget'!I112","v":0},{"$f":"F48/'2) Development Budget'!I112","v":{"$error":"#DIV/0!"}}]
[]
[null,"*AHC construction funding will transfer to permanent financing when the project is complete unless otherwise stated."]
[]
[null,"Unit Mix","Efficiency","1 BR","2 BR","3 BR","4 BR","Total"]
[null,"20% AMI",{"$f":"'6) Units & Revenue'!C7","v":0},{"$f":"'6) Units & Revenue'!C18","v":0},{"$f":"'6) Units & Revenue'!C29","v":0},{"$f":"'6) Units & Revenue'!N7","v":0},{"$f":"'6) Units & Revenue'!N18","v":0},{"$f":"SUM(C53:G53)","v":0}]
[null,"30% AMI",{"$f":"+'6) Units & Revenue'!C8","v":0},{"$f":"+'6) Units & Revenue'!C19","v":0},{"$f":"+'6) Units & Revenue'!C30","v":0},{"$f":"+'6) Units & Revenue'!N8","v":0},{"$f":"+'6) Units & Revenue'!N19","v":0},0]
[null,"40% AMI",{"$f":"'6) Units & Revenue'!C9","v":0},{"$f":"'6) Units & Revenue'!C20","v":0},{"$f":"'6) Units & Revenue'!C31","v":0},{"$f":"'6) Units & Revenue'!N9","v":0},{"$f":"'6) Units & Revenue'!N20","v":0},0]
[null,"50% AMI",{"$f":"'6) Units & Revenue'!C10","v":0},{"$f":"'6) Units & Revenue'!C21","v":0},{"$f":"'6) Units & Revenue'!C32","v":0},{"$f":"'6) Units & Revenue'!N10","v":0},{"$f":"'6) Units & Revenue'!N21","v":0},0]
[null,"60% AMI",{"$f":"'6) Units & Revenue'!C11","v":0},{"$f":"'6) Units & Revenue'!C22","v":0},{"$f":"'6) Units & Revenue'!C33","v":0},{"$f":"'6) Units & Revenue'!N11","v":0},{"$f":"'6) Units & Revenue'!N22","v":0},0]
[null,"70% AMI",{"$f":"+'6) Units & Revenue'!C12","v":0},{"$f":"+'6) Units & Revenue'!C23","v":0},{"$f":"+'6) Units & Revenue'!C34","v":0},{"$f":"+'6) Units & Revenue'!N12","v":0},{"$f":"+'6) Units & Revenue'!N23","v":0},0]
[null,"80% AMI",{"$f":"+'6) Units & Revenue'!C13","v":0},{"$f":"+'6) Units & Revenue'!C24","v":0},{"$f":"+'6) Units & Revenue'!C35","v":0},{"$f":"+'6) Units & Revenue'!N13","v":0},{"$f":"+'6) Units & Revenue'!N24","v":0},0]
[null,"Market Rate",{"$f":"'6) Units & Revenue'!C14","v":0},{"$f":"'6) Units & Revenue'!C25","v":0},{"$f":"'6) Units & Revenue'!C36","v":0},{"$f":"'6) Units & Revenue'!N14","v":0},{"$f":"'6) Units & Revenue'!N25","v":0},0]
[null,"Total ",{"$f":"SUM(C53:C60)","v":0},0,0,0,0,0]
[]
[null,"Operating Budget",null,"Annual","Per Unit","Assumptions"]
[null,"Gross Rent Potential",null,{"$f":"'6) Units & Revenue'!T29","v":0},{"$f":"D64/$I$4","v":{"$error":"#DIV/0!"}},"Vacancy Rate:",null,{"$f":"'7) Operating Budget'!C14","v":7.0000000000000007E-2}]
[null,"Other Income",null,{"$f":"'6) Units & Revenue'!T41","v":0},{"$f":"D65/$I$4","v":{"$error":"#DIV/0!"}},"Inflation",null,"1-2%"]
[null,"Vacancy",null,{"$f":"'7) Operating Budget'!D14","v":0},{"$error":"#DIV/0!"},"Administrative Inflation",null,0.03]
[null,"Adjusted Gross Income",null,{"$f":"'7) Operating Budget'!D15","v":0},{"$error":"#DIV/0!"}]
[null,"Operating Expenses",null,{"$f":"'7) Operating Budget'!I33","v":0},{"$error":"#DIV/0!"}]
[null,"Net Operating Income",null,{"$f":"'7) Operating Budget'!I37","v":0},{"$error":"#DIV/0!"}]
[null,"Debt Service",null,{"$f":"J34","v":0},{"$error":"#DIV/0!"}]
[null,null,null,"You Must Include Source & Status of All Funds Sought"]
[]
[null,"Status of",null,null,null,null,null,"Date Secured"]
[null,"Permanent Financing",null,"Name of Institution",null,"Secured/Not Secured",null,"or Awarded"]
[null,{"$f":"B24","v":"Bank Mortgage "}]
[null,"State Historic Tax Credits"]
[null,"Federal Historic Tax Credits"]
[null,{"$f":"B29","v":"Source 1: CDA"}]
[null,{"$f":"B30","v":"Source 2:"}]
[null,{"$f":"B31","v":"Source 3:"}]
[null,{"$f":"B32","v":"Source 4:"}]
[null,{"$f":"B33","v":"Source 5:"}]
[null,{"$f":"B28","v":"Developer Equity"}]
[]
[]
[null,"Developer Notes",null,null,null,null,null,"Date Entered"]

{"sheet":"5) Utilities","index":5,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,8],[1,1,1,8],[27,2,27,3],[20,2,20,4],[20,5,20,7],[20,1,21,1],[8,4,8,8],[30,1,33,8],[3,5,3,6],[2,2,2,3],[2,5,2,6],[56,3,56,8],[54,1,55,8],[8,1,9,1],[8,3,9,3],[74,3,74,8],[34,1,34,8],[35,4,35,5],[35,6,35,7],[36,1,37,8],[72,1,73,8],[38,3,38,8]]}
[null,{"$f":"'4) Sources & Uses'!B1:H1","v":"Affordable Housing Commission Rental Production Application/Proforma"}]
[null,"Utilities"]
[null,"Project:",{"$f":"project","v":0},null,"Developer:",{"$f":"dev","v":0},null,"Total Units:",{"$f":"'1) Application'!J23","v":0}]
[null,null,null,null,"Address:",{"$f":"'1) Application'!F7:N7","v":0},null,"AHC Units:",{"$f":"'1) Application'!U23","v":0}]
[null,null,null,null,null,null,null,"20% AMI Units:",{"$f":"'1) Application'!U24","v":0}]
[null,null,null,null,null,null,null,"LMI Units:",{"$f":"'1) Application'!U25","v":0}]
[]
[null,"Utility Allowance Calculation: use Utility Allowance tables at www.slha.org/for-partners/owners/forms/"]
[null,"Utility","Type of Utility","Utilities Paid By:","Allowance for Utilities Paid by Tenant Only"]
[null,null,"(gas, oil, etc.)",null,"0 BR","1 BR","2 BR","3 BR","4 BR"]
[null,"Cooking"]
[null,"Other, Lighting","Electric"]
[null,"Hot Water"]
[null,"Water"]
[null,"Heating  "]
[null,"Cooling"]
[null,"Sewer"]
[null,"Trash Collection"]
[null,"TOTAL",null,null,{"$f":"SUM(E11:E18)","v":0},{"$f":"SUM(F11:F18)","v":0},{"$f":"SUM(G11:G18)","v":0},{"$f":"SUM(H11:H18)","v":0},{"$f":"SUM(I11:I18)","v":0}]

{"sheet":"6) Units & Revenue","index":6,"n_rows":50,"n_cols":22,"rows_kept":50,"cut":false,"hidden":false,"merged":[[42,15,42,18],[46,12,46,18],[47,12,47,18],[48,12,48,18],[49,12,49,18],[46,6,46,8],[47,6,47,8],[48,6,48,8],[49,6,49,8],[3,2,3,3],[3,4,3,7],[40,1,40,3],[27,12,27,17],[39,1,39,3],[29,12,29,13],[30,12,30,13],[38,14,38,16],[39,13,39,16],[31,12,31,13],[4,14,4,15],[3,9,3,10],[3,12,3,13],[2,14,2,15],[0,1,0,19],[2,1,2,3],[2,4,2,7],[1,1,1,19],[2,9,2,10]]}
[null,{"$f":"'4) Sources & Uses'!B1:H1","v":"Affordable Housing Commission Rental Production Application/Proforma"}]
[null,"Unit Information & Gross Revenue Potential"]
[null,"Project:",null,null,{"$f":"project","v":0},null,null,null,null,"Developer:",null,null,{"$f":"dev","v":0},null,"Total Units:",{"$f":"'1) Application'!#REF!","v":{"$error":"#REF!"}},{"$f":"'1) Application'!J23","v":0},null,"20% AMI Units:",{"$f":"'1) Application'!U24","v":0}]
[null,null,"Address:",null,{"$f":"'1) Application'!F7","v":0},null,null,null,null,"AHC Request:",null,null,{"$f":"'1) Application'!J70","v":0},null,null,"AHC Units:",{"$f":"'1) Application'!U23","v":0},null,"LMI Units:",{"$f":"'1) Application'!U25","v":0}]
[null,"Efficiency Units",null,null,null,null,null,null,null,null,"Construction:",null,{"$f":"'1) Application'!G32","v":0},null,"Housing Type:",null,{"$f":"'1) Application'!G33","v":0}]
[null,null,"# of Units","% AMI Targeted","Baths","Sq. Ft.","Rent","Monthly Rent","Annual Rent","# AHC Units","Sq.Ft.",null,"3 BR Units","# of Units","% AMI Targeted","Baths","Sq. Ft.","Rent","Monthly Rent","Annual Rent","# AHC Units","Sq.Ft."]
[null,null,null,0.2,null,null,null,{"$f":"C7*G7","v":0},{"$f":"H7*12","v":0},null,{"$f":"F7*C7","v":0},null,null,null,0.2,null,null,null,{"$f":"N7*R7","v":0},{"$f":"S7*12","v":0},null,{"$f":"Q7*N7","v":0}]
[null,null,null,0.3,null,null,null,0,0,null,{"$f":"F8*C8","v":0},null,null,null,0.3,null,null,null,{"$f":"N8*R8","v":0},0,null,{"$f":"Q8*N8","v":0}]
[null,null,null,0.4,null,null,null,0,0,null,0,null,null,null,0.4,null,null,null,0,0,null,0]
[null,null,null,0.5,null,null,null,0,0,null,0,null,null,null,0.5,null,null,null,0,0,null,0]
[null,null,null,0.6,null,null,null,0,0,null,0,null,null,null,0.6,null,null,null,0,0,null,0]
[null,null,null,0.7,null,null,null,0,0,null,0,null,null,null,0.7,null,null,null,0,0,null,0]
[null,null,null,0.8,null,null,null,0,0,null,0,null,null,null,0.8,null,null,null,0,0,null,0]
[null,null,null,"Market Rate",null,null,null,0,0,null,0,null,null,null,"Market Rate",null,null,null,0,0,null,0]
[null,"Subtotal",{"$f":"SUM(C7:C14)","v":0},null,null,null,null,{"$f":"SUM(H7:H14)","v":0},{"$f":"SUM(I7:I14)","v":0},{"$f":"+J7+J8+J9+J10+J11+J12+J13+J14","v":0},{"$f":"SUM(K7:K14)","v":0},null,"Subtotal",{"$f":"SUM(N7:N14)","v":0},null,null,null,null,{"$f":"SUM(S7:S14)","v":0},{"$f":"SUM(T7:T14)","v":0},{"$f":"+U7+U8+U9+U10+U11+U12+U13+U14","v":0},{"$f":"SUM(V7:V14)","v":0}]
[]
[null,"1 BR Units","# of Units","% AMI Targeted","Baths","Sq. Ft.","Rent","Monthly Rent","Annual Rent","# AHC Units","Sq.Ft.",null,"4 BR Units","# of Units","% AMI Targeted","Baths","Sq. Ft.","Rent","Monthly Rent","Annual Rent","# AHC Units","Sq.Ft."]
[null,null,null,0.2,null,null,null,{"$f":"C18*G18","v":0},{"$f":"H18*12","v":0},null,{"$f":"F18*C18","v":0},null,null,null,0.2,null,null,null,{"$f":"N18*R18","v":0},{"$f":"S18*12","v":0},null,{"$f":"Q18*N18","v":0}]
[null,null,null,0.3,null,null,null,0,0,null,0,null,null,null,0.3,null,null,null,{"$f":"N19*R19","v":0},0,null,{"$f":"Q19*N19","v":0}]
[null,null,null,0.4,null,null,null,0,0,null,0,null,null,null,0.4,null,null,null,0,0,null,0]
[null,null,null,0.5,null,null,null,0,0,null,0,null,null,null,0.5,null,null,null,0,0,null,0]
[null,null,null,0.6,null,null,null,0,0,null,0,null,null,null,0.6,null,null,null,0,0,null,0]
[null,null,null,0.7,null,null,null,0,0,null,0,null,null,null,0.7,null,null,null,0,0,null,0]
[null,null,null,0.8,null,null,null,0,0,null,0,null,null,null,0.8,null,null,null,0,0,null,0]
[null,null,null,"Market Rate",null,null,null,0,0,null,0,null,null,null,"Market Rate",null,null,null,0,0,null,0]
[null,"Subtotal",{"$f":"SUM(C18:C25)","v":0},null,null,null,null,{"$f":"SUM(H18:H25)","v":0},{"$f":"SUM(I18:I25)","v":0},{"$f":"+J18+J19+J20+J21+J22+J23+J24+J25","v":0},{"$f":"SUM(K18:K25)","v":0},null,"Subtotal",{"$f":"SUM(N18:N25)","v":0},null,null,null,null,{"$f":"SUM(S18:S25)","v":0},{"$f":"SUM(T18:T25)","v":0},{"$f":"+U18+U19+U20+U21+U22+U23+U24+U25","v":0},{"$f":"SUM(V18:V25)","v":0}]
[]
[null,"2 BR Units","# of Units","% AMI Targeted","Baths","Sq. Ft.","Rent","Monthly Rent","Annual Rent","# AHC Units","Sq.Ft.",null,null,null,null,null,null,null,"Monthly Rent","Annual Rent"]
[null,null,null,0.2,null,null,null,{"$f":"C29*G29","v":0},{"$f":"H29*12","v":0},null,{"$f":"F29*C29","v":0},null,"Total Units",null,{"$f":"N26+N15+C37+C26+C15","v":0},null,null,"Gross Rent Potential",{"$f":"S26+S15+H37+H26+H15","v":0},{"$f":"T26+T15+I37+I26+I15","v":0}]
[null,null,null,0.3,null,null,null,{"$f":"C30*G30","v":0},0,null,{"$f":"F30*C30","v":0},null,"Total AHC Units",null,{"$f":"+J15+J26+J37+U15+U26","v":0}]
[null,null,null,0.4,null,null,null,0,0,null,{"$f":"F31*C31","v":0},null,"# 20% AMI Units",null,{"$f":"+N18+N7+C29+C18+C7","v":0},null,null,"Per Unit Avg",{"$f":"S29/O29","v":{"$error":"#DIV/0!"}},{"$f":"T29/O29","v":{"$error":"#DIV/0!"}}]
[null,null,null,0.5,null,null,null,0,0,null,0,null,"# AHC 20% AMI Units",null,{"$f":"+J7+J18+J29+U7+U18","v":0}]
[null,null,null,0.6,null,null,null,0,0,null,0,null,"Other Income",null,null,null,null,null,"Monthly","Annually"]
[null,null,null,0.7,null,null,null,0,0,null,0]
[null,null,null,0.8,null,null,null,0,0,null,0,null,"Miscellaneous & Interest",null,null,null,null,null,null,{"$f":"S35*12","v":0}]
[null,null,null,"Market Rate",null,null,null,0,0,null,0,null,"Laundry",null,null,null,null,null,null,0]
[null,"Subtotal",{"$f":"SUM(C29:C36)","v":0},null,null,null,null,{"$f":"SUM(H29:H36)","v":0},{"$f":"SUM(I29:I36)","v":0},{"$f":"+J29+J30+J31+J32+J33+J34+J35+J36","v":0},{"$f":"SUM(K29:K36)","v":0},null,"Carports/Garages",null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Tenant Charges (late fees, insufficient funds, etc)",null,null,null,null,null,null,0]
[null,"Square Footage Breakdown",null,null,null,null,null,null,null,null,null,null,"Operating Subsidy:",null,"(source)",null,null,null,null,0]
[null,"Residential Square Footage",null,null,{"$f":"K15+K26+K37+V15+V26","v":0},{"$f":"UnitsSqFt/SqFt","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Other:",null,null,null,null,null,null,0]
[null,"Common Areas Sq. Ft.",null,null,null,{"$f":"E41/SqFt","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Totals",null,null,null,null,null,{"$f":"SUM(S35:S40)","v":0},{"$f":"SUM(T35:T40)","v":0}]
[null,"Commercial Sq. Ft.",null,null,null,{"$f":"E42/SqFt","v":{"$error":"#DIV/0!"}}]
[null,"Total Square Footage",null,null,{"$f":"SUM(E40:E42)","v":0},{"$f":"E43/SqFt","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"Gross Annual Income Potential",null,null,null,{"$f":"T29+T41","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Accessibility Review",null,null,null,null,null,null,null,null,"Special Populations Review"]
[null,null,null,null,null,null,"Total Units:",null,null,{"$f":"O29","v":0},null,null,"# Units - Elderly Housing:"]
[null,null,null,null,null,null,"# Universal Design Units:",null,null,null,null,null,"# Units - Previously Subsidized Housing:"]
[null,null,null,null,null,null,"# Accessible Units:",null,null,null,null,null,"# Units - Project-Based Rental Assistance:"]
[null,null,null,null,null,null,"% Accessible (hearing) Units:",null,null,"%",null,null,"# Units - Housing for Persons with HIV/AIDS:"]

{"sheet":"7) Operating Budget","index":7,"n_rows":70,"n_cols":11,"rows_kept":70,"cut":false,"hidden":false,"merged":[[5,2,5,4],[6,2,6,4],[4,2,4,4],[0,1,0,10],[1,1,1,10],[2,2,2,4],[2,6,2,7],[3,2,3,6],[52,1,52,3],[52,4,52,8],[53,1,53,3],[53,4,53,9],[49,1,49,3],[49,4,49,9],[50,1,50,3],[50,4,50,9],[51,1,51,3],[51,4,51,9],[54,1,54,3],[54,4,54,9],[56,1,56,3],[56,4,56,9],[57,1,57,3],[57,4,57,8],[55,1,55,3],[58,1,58,3],[58,4,58,9],[59,1,59,3],[59,4,59,9],[60,1,60,3],[60,4,60,9],[61,1,61,3],[61,4,61,8],[62,1,62,3],[62,4,62,9],[63,1,63,3],[63,4,63,9],[64,1,64,3],[64,4,64,9],[65,1,65,3],[65,4,65,8],[66,1,66,3],[66,4,66,9],[67,1,67,3],[67,4,67,9],[68,1,68,3],[68,4,68,9],[69,1,69,3],[69,4,69,9]]}
[null,{"$f":"'6) Units & Revenue'!B1:T1","v":"Affordable Housing Commission Rental Production Application/Proforma"}]
[null,"ANNUAL OPERATING BUDGET"]
[null,"Project:",{"$f":"project","v":0},null,null,null,"Developer:",null,{"$f":"dev","v":0}]
[null,"Address:",{"$f":"'1) Application'!F7","v":0},null,null,null,null,"AHC-Assisted Units:",{"$f":"'1) Application'!U23","v":0}]
[null,"AHC Request:",{"$f":"'1) Application'!J69","v":0},null,null,null,null,"20% AMI Units:",{"$f":"'1) Application'!U24","v":0}]
[null,"Construction:",{"$f":"'1) Application'!G32","v":0},null,null,null,null,"LMI Units:",{"$f":"'1) Application'!U25","v":0}]
[null,"Housing:",{"$f":"'1) Application'!G33","v":0},null,null,null,null,"Total Units:",{"$f":"'1) Application'!J23","v":0}]
[]
[]
[null,"REVENUE",null,"Annual","Per Unit","% Adj Income",null,"Operating","Annual","Per Unit","% Adj Income"]
[null,"Gross Rent Potential",null,{"$f":"'6) Units & Revenue'!T29","v":0},{"$f":"D11/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}},null,null,"Security",null,{"$f":"I11/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,"Other Revenue",null,{"$f":"'6) Units & Revenue'!T41","v":0},{"$f":"D12/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}},null,null,"Common Electricity",null,{"$f":"I12/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,"Subtotal",null,{"$f":"SUM(D11:D12)","v":0},{"$f":"D13/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}},null,null,"Water/Sewer",null,{"$f":"I13/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,"Combined Vacancy Rate",{"$f":"Compliance!D7","v":7.0000000000000007E-2},{"$f":"D13*C14","v":0},{"$f":"D14/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}},null,null,"Gas",null,{"$f":"I14/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,"Adjusted Gross Income",null,{"$f":"D13-D14","v":0},{"$f":"D15/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}},null,null,"Trash Removal",null,{"$f":"I15/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Payroll",null,{"$f":"I16/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,"OPERATING EXPENSES",null,null,null,null,null,"Payroll Taxes & Fringes",null,{"$f":"I17/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Other:",null,{"$f":"I18/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,"Administrative Costs",null,"Annual","Per Unit",null,null,"Other:",null,{"$f":"I19/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,"Advertising",null,null,{"$f":"D20/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}},null,null,"Other:",null,{"$f":"I20/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,"Management",null,null,{"$f":"D21/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}},null,null,"Subtotal",{"$f":"SUM(I11:I20)","v":0},{"$f":"I21/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}},{"$f":"(I21/$D$15)","v":{"$error":"#DIV/0!"}}]
[null,"Legal/Partnership",null,null,{"$f":"D22/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,"Accounting/Audit",null,null,{"$f":"D23/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}},null,null,"Escrows & Reserves","Annual","Per Unit"]
[null,"Compliance Monitoring",null,null,{"$f":"D24/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}},null,null,"Insurance",null,{"$f":"I24/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,"Other:",null,null,{"$f":"D25/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}},null,null,"Real Estate Taxes",null,{"$f":"I25/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,"Other:",null,null,{"$f":"D26/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}},null,null,"Other Taxes",null,{"$f":"I26/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,"Other:",null,null,{"$f":"D27/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}},null,null,"Other",null,{"$f":"I27/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,"Other:",null,null,{"$f":"D28/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}},null,null,"Other:",null,{"$f":"I28/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,"Subtotal",null,{"$f":"SUM(D20:D28)","v":0},{"$f":"D29/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}},{"$f":"(D29/$D$15)","v":{"$error":"#DIV/0!"}},null,"Other:",null,{"$f":"I29/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Other:",null,{"$f":"I30/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,"Maintenance",null,"Annual","Per Unit",null,null,"Subtotal",{"$f":"SUM(I24:I30)","v":0},{"$f":"I31/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}},{"$f":"(I31/$D$15)","v":{"$error":"#DIV/0!"}}]
[null,"Decorating",null,null,{"$f":"D32/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,"Repairs",null,null,{"$f":"D33/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}},null,null,"Total Operating Expenses",{"$f":"D29+D40+I21+I31","v":0},{"$f":"I33/'1) Application'!J23","v":{"$error":"#DIV/0!"}},{"$f":"(I33/$D$15)","v":{"$error":"#DIV/0!"}}]
[null,"Exterminating",null,null,{"$f":"D34/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,"Grounds",null,null,{"$f":"D35/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}},null,null,"Replacement Reserve",null,{"$f":"I35/'1) Application'!J23","v":{"$error":"#DIV/0!"}}]
[null,"Other",null,null,{"$f":"D36/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}},null,null,"Op Expenses + Replace. Reserve",{"$f":"I35+I33","v":0}]
[null,"Other:",null,null,{"$f":"D37/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}},null,null,"NET OPERATING INCOME",{"$f":"D15-I33-I35","v":0},{"$f":"E15-J33-J35","v":{"$error":"#DIV/0!"}},{"$f":"(I37/$D$15)","v":{"$error":"#DIV/0!"}}]
[null,"Other:",null,null,{"$f":"D38/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,"Other:",null,null,{"$f":"D39/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}}]
[null,"Subtotal",null,{"$f":"SUM(D32:D39)","v":0},{"$f":"D40/'1) Application'!$J$23","v":{"$error":"#DIV/0!"}},{"$f":"(D40/$D$15)","v":{"$error":"#DIV/0!"}},null,"Estimated Mortgage"]
[null,null,null,null,null,null,null,"Debt Coverage Ratio Year 1",{"$f":"Compliance!D17","v":1.25}]
[null,"Annual Income and Expenses",null,null,null,null,null,"Interest Rate"]
[null,"Adjusted Gross Income",null,null,{"$f":"D15","v":0},null,null,"Term"]
[null,"Annual Operating Expense + Replacement Reserve",null,null,{"$f":"I33+I35","v":0},null,null,"Annual Payment",{"$f":"I37/I41","v":0}]
[null,"Net Operating Income (Effective Income - Expenses)",null,null,{"$f":"D15-I36","v":0},null,null,"Mortgage Amount (PV)",{"$f":"PV(I42/12,I43*12,-I44/12)","v":0}]
[null,"Annual Debt Service priority loan 1",null,null,{"$f":"I44","v":0}]
[null,"Annual Debt Service priority loan 2",null,null,null,null,null,"NCF Year 1 (stabilized)",{"$f":"I37-I44","v":0},{"$f":"I47/'1) Application'!J23","v":{"$error":"#DIV/0!"}}]
[null,"Annual Debt Service AHC (based on 30-year amortization)",null,null,{"$f":"('4) Sources & Uses'!F45)/30","v":0}]
[null,"AHC Underwriting Summary"]
[null,"1. General Justification for Funding:"]
[]
[null,"2. Why is the project needed?  "]
[null,"3. Examine the sources & uses:                  "]
[null,"a. Are costs reasonable (necessary & sufficient)?"]
[null,"b. Has adequate funding been secured?"]
[null,"c. Strong financial and community support?"]
[null,"c. Does the project support its debt?"]
[null,"4. Assess neighborhood market conditions: "]
[null,"a. Equitably invests in LMI housing to improve life?"]
[null,"b. Sound plan to lease units quickly to eligible tenants?"]
[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":"8) Cash Flow","index":8,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[10,0,10,3],[36,3,36,6],[37,3,37,6],[4,5,4,6],[12,3,12,5],[6,5,6,6],[5,5,5,6],[3,5,3,6],[4,2,4,4],[3,1,3,4],[5,2,5,4],[0,0,0,8],[1,0,1,8],[2,5,2,6],[2,7,2,8],[2,1,2,4]]}
["Affordable Housing Commission Rental Production Application"]
["Cash Flow"]
["Project:",{"$f":"project","v":0},null,null,null,"Developer:",null,{"$f":"dev","v":0}]
["Address:",{"$f":"'1) Application'!F7","v":0},null,null,null,"AHC-Assisted Units:",null,{"$f":"'1) Application'!U23","v":0}]
["Construction:",null,{"$f":"'1) Application'!G32","v":0},null,null,"20% AMI Units:",null,{"$f":"'1) Application'!U24","v":0}]
["Housing:",null,{"$f":"'1) Application'!G33","v":0},null,null,"LMI Units:",null,{"$f":"'1) Application'!U25","v":0}]
[null,null,null,null,null,"Total Units:",null,{"$f":"'1) Application'!J23","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Year 1"]
["REVENUE"]
[null,"Gross Income Potential",null,null,null,null,null,{"$f":"'7) Operating Budget'!D11","v":0}]
[null,"Operating Subsidy (source)"]
[null,"Vacancy Factor",null,{"$f":"'7) Operating Budget'!C14","v":7.0000000000000007E-2},null,null,null,{"$f":"'7) Operating Budget'!D14","v":0}]
["Net Income",null,null,null,null,null,null,{"$f":"H12+H13-H14","v":0}]
[]
[]
["OPERATING EXPENSES",null,null,null,null,null,null,null,"% Adj Income"]
[null,"Administration",null,null,null,null,null,{"$f":"'7) Operating Budget'!D29","v":0},{"$f":"'7) Operating Budget'!F29","v":{"$error":"#DIV/0!"}}]
[null,"Maintenance",null,null,null,null,null,{"$f":"'7) Operating Budget'!D40","v":0},{"$f":"'7) Operating Budget'!F40","v":{"$error":"#DIV/0!"}}]
[null,"Operating",null,null,null,null,null,{"$f":"'7) Operating Budget'!I21","v":0},{"$f":"'7) Operating Budget'!K21","v":{"$error":"#DIV/0!"}}]
[null,"Escrows & Reserves",null,null,null,null,null,{"$f":"'7) Operating Budget'!I31","v":0},{"$f":"'7) Operating Budget'!K31","v":{"$error":"#DIV/0!"}}]
["Total Operating Expenses",null,null,null,null,null,null,{"$f":"SUM(H19:H22)","v":0},{"$f":"SUM(I19:I22)","v":{"$error":"#DIV/0!"}}]
[]
["Net Operating Income",null,null,null,null,null,null,{"$f":"H15-H23","v":0}]
["Per Unit",null,null,null,null,null,null,{"$f":"H25/'1) Application'!J23","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
["Replacement Reserve Contribution",null,null,null,null,null,null,{"$f":"'7) Operating Budget'!I35","v":0}]
["AHC Annual Debt Service",null,null,null,null,null,null,{"$f":"'4) Sources & Uses'!J25","v":0}]
["Other Debt Service",null,null,null,null,null,null,{"$f":"'4) Sources & Uses'!J34-'4) Sources & Uses'!J25","v":0}]
["Debt Coverage Ratio",null,null,null,null,null,null,{"$f":"('7) Operating Budget'!I37-'7) Operating Budget'!I35)/('8) Cash Flow'!H32+'8) Cash Flow'!H33)","v":{"$error":"#DIV/0!"}}]
["CASH FLOW",null,null,null,null,null,null,{"$f":"H25-H31-H32-H33","v":0}]
[]
["Payments Out of Cash Flow:",null,null,"identify"]
["Payments Out of Cash Flow:",null,null,"identify"]
[]
["FINAL CASH FLOW",null,null,null,null,null,null,{"$f":"H35-H37-H38","v":0}]
[null,"Per Unit",null,null,null,null,null,{"$f":"H40/'1) Application'!J23","v":{"$error":"#DIV/0!"}}]

{"sheet":"9) MVA","index":9,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[13,8,47,9],[0,0,0,6],[1,0,1,6],[10,3,10,4],[19,2,49,4]]}
["Affordable Housing Commission Rental Production Application"]
["Utilizes 2019 Residential Market Analysis"]
[]
["Project:",null,{"$f":"project","v":0},"Project Address:",{"$f":"'1) Application'!F7","v":0}]
[null,null,null,"Total Units:",{"$f":"'1) Application'!J23","v":0}]
["Developer:",null,{"$f":"dev","v":0},"AHC Units:",{"$f":"'1) Application'!U23","v":0}]
["AHC Request:",null,{"$f":"'1) Application'!J69","v":0},"20% AMI Units:",{"$f":"'1) Application'!U24","v":0}]
["Construction:",null,{"$f":"'1) Application'!G32","v":0},"LMI Units:",{"$f":"'1) Application'!U25","v":0}]
["Housing:",null,{"$f":"'1) Application'!G33","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":"10) Priorities","index":10,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,11],[2,8,2,9],[3,8,3,9],[4,8,4,9],[1,0,1,11],[35,5,35,10],[35,1,35,4],[13,1,18,10],[5,7,5,9],[29,4,29,5],[29,7,29,8],[34,1,34,9],[24,0,24,11],[27,1,27,9],[28,1,28,4],[28,6,28,10],[37,1,37,9],[38,1,38,9],[36,1,36,4],[36,5,36,7],[36,8,36,10]]}
["Affordable Housing Commission Rental Production Application"]
["Funding Priorities"]
[null,"Project:",null,{"$f":"'1) Application'!F6","v":0},null,null,null,null,"AHC-assisted Units:",null,{"$f":"'1) Application'!U23","v":0}]
[null,"Developer:",null,{"$f":"dev","v":0},null,null,null,null,"≤20% AMI Units:",null,{"$f":"'1) Application'!U24","v":0}]
[null,"Address:",null,{"$f":"'1) Application'!F7","v":0},null,null,null,null,"LMI Units:","LMI Units:",{"$f":"'1) Application'!U25","v":0}]
[null,null,null,null,null,null,null,"Total Units:",null,null,{"$f":"'1) Application'!J23:K23","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?"]
["-","If yes, explain how the project prevents homelessness:"]
[null,"This project prevents homelessness by"]
[]
[]
[]
[]
[]
[]
["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,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?"]
["-","If yes, indicate which green standard:"]
[]
[]
["7.","Proposes housing with three or more bedrooms & serves households with incomes ≤80% AMI."]
[]
[null,"Summary"]
[{"$f":"A8","v":"1."},{"$f":"K8","v":0},"≤20% AMI"]
[{"$f":"A10","v":"2."},{"$f":"K10","v":0},"≤30% AMI & PSH"]
[{"$f":"A12","v":"3."},{"$f":"K12","v":0},"Prevents Homeless"]
[{"$f":"A21","v":"4."},{"$f":"K21","v":0}," ≥15 Green Object."]
[{"$f":"A28","v":"5."},{"$f":"K28","v":0},"Public Transit"]
[{"$f":"A35","v":"6."},{"$f":"K35","v":0},"EE Rehab"]
[{"$f":"A39","v":"7."},{"$f":"K39","v":0},"3+ Bedrooms"]
["Total",{"$f":"COUNTIF(B42:B48, \"Yes\")","v":0},"Priorities to be attained"]

{"sheet":"11) UD","index":11,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[[3,2,3,5],[4,2,4,5],[0,0,0,10],[2,2,2,5],[22,0,22,3],[22,4,22,5],[22,6,22,8],[22,9,22,10],[16,4,16,5],[17,4,17,5],[18,4,18,5],[1,0,1,10],[16,6,16,8],[16,9,16,10],[16,0,16,3],[15,4,15,5],[14,0,14,3],[14,4,14,5],[14,6,14,8],[14,9,14,10],[9,0,11,10],[17,6,17,8],[17,9,17,10],[7,0,8,0],[42,0,42,8],[42,9,42,10],[19,9,19,10],[19,0,19,3],[23,0,23,3],[23,4,23,5],[20,9,20,10],[41,0,41,8],[41,9,41,10],[24,0,24,3],[26,0,26,3],[26,4,26,5],[26,6,26,8],[26,9,26,10],[24,6,24,8],[24,9,24,10],[25,0,25,3],[25,4,25,5],[25,6,25,8],[21,6,21,8],[21,9,21,10],[21,0,21,3],[21,4,21,5],[31,4,31,5],[15,0,15,3],[15,6,15,8],[15,9,15,10],[20,0,20,3],[20,4,20,5],[20,6,20,8],[19,4,19,5],[17,0,17,3],[18,0,18,3],[19,6,19,8],[18,6,18,8],[18,9,18,10],[32,4,32,5],[29,6,29,8],[29,9,29,10],[30,9,30,10],[31,9,31,10],[32,9,32,10],[30,6,30,8],[31,6,31,8],[29,4,29,5],[28,0,28,3],[23,6,23,8],[23,9,23,10],[28,6,28,8],[28,9,28,10],[25,9,25,10],[24,4,24,5],[30,0,30,3],[30,4,30,5],[29,0,29,3],[28,4,28,5],[40,9,40,10],[40,0,40,8],[39,0,39,5],[39,9,39,10],[36,0,36,3],[36,4,36,5],[36,6,36,8],[36,9,36,10],[31,0,31,3],[32,0,32,3],[35,0,35,3],[35,4,35,5],[35,6,35,8],[35,9,35,10],[34,6,34,8],[38,9,38,10],[34,4,34,5],[33,0,33,3],[34,0,34,3],[33,4,33,5],[33,9,33,10],[34,9,34,10],[33,6,33,8],[32,6,32,8]]}
["Affordable Housing Commission Rental Production Application"]
["Universal Design Budget"]
[null,"Project:",{"$f":"project","v":0},null,null,null,null,"AHC Units:",{"$f":"'1) Application'!U23","v":0}]
[null,"Developer:",{"$f":"dev","v":0},null,null,null,null,"20% AMI Units:",{"$f":"'1) Application'!U24","v":0}]
[null,"Address:",{"$f":"'1) Application'!F7","v":0},null,null,null,null,"LMI Units:",{"$f":"'1) Application'!U25","v":0}]
[null,null,null,null,null,null,null,"Total Units",{"$f":"'1) Application'!U23","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 in hard copy from AHC, and 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":"E16+G16","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"E17+G17","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E18:I18)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E19:I19)","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]
["Subtotal",null,null,null,{"$f":"SUM(E16:F26)","v":0},null,{"$f":"SUM(G16:I26)","v":0},null,null,{"$f":"SUM(J16:K26)","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(E30:I30)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E31:I31)","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]
["Subtotal",null,null,null,{"$f":"SUM(E30:F36)","v":0},null,{"$f":"SUM(G30:I36)","v":0},null,null,{"$f":"SUM(J30:K36)","v":0}]
[]
["Number of AHC-assisted, universally designed homes in project:",null,null,null,null,null,null,null,null,{"$f":"'1) Application'!U23","v":0}]
["Number of affordable homes in project:",null,null,null,null,null,null,null,null,{"$f":"'1) Application'!U25","v":0}]
["Number of homes in project:",null,null,null,null,null,null,null,null,{"$f":"'1) Application'!J23","v":0}]
["Cost for Universal Design",null,null,null,null,null,null,null,null,{"$f":"G37+G27","v":0}]
["Cost for Universal Design per AHC-Assisted Home",null,null,null,null,null,null,null,null,{"$f":"J42/J39","v":{"$error":"#DIV/0!"}}]

{"sheet":"12) Living Wage","index":12,"n_rows":83,"n_cols":13,"rows_kept":83,"cut":false,"hidden":false,"merged":[[48,0,48,12],[47,0,47,12],[51,8,51,12],[51,2,51,7],[53,0,53,12],[52,7,52,12],[52,0,52,6],[60,1,60,5],[60,8,60,10],[61,8,61,10],[54,0,54,3],[57,0,57,12],[61,1,61,5],[82,0,82,1],[82,2,82,5],[82,7,82,9],[82,10,82,12],[69,0,69,12],[67,4,67,11],[63,1,63,4],[65,3,65,4],[65,9,65,12],[63,8,63,12],[63,6,63,7],[35,0,35,8],[22,0,22,5],[24,0,24,5],[43,0,43,2],[36,0,36,8],[39,0,39,2],[41,0,41,2],[22,7,22,12],[24,7,24,12],[26,0,31,12],[39,7,39,12],[41,7,41,12],[43,7,43,12],[33,0,33,7],[18,0,18,5],[20,0,20,5],[18,7,18,12],[20,7,20,12],[14,0,14,3],[14,7,14,12],[0,0,2,12],[4,1,5,11],[8,7,8,12],[8,0,8,5],[16,7,16,12],[16,0,16,5],[10,0,10,5],[12,0,12,5],[10,7,10,12],[12,7,12,12]]}
["LIVING WAGE ACKNOWLEDGEMENT AND ACCEPTANCE DECLARATION"]
[]
[]
[]
[null,"(To be completed by each respondent to a bid/proposal solicitation when that solicitation has included Living Wage Advertisement/Solicitation Language)"]
[]
[]
[]
["CONTRACTING AGENCY",null,null,null,null,null,null,"Affordable Housing Commission"]
[]
["AGENCY CONTRACT NUMBER",null,null,null,null,null,null,1430010]
[]
["BIDDER'S PROPONENT'S NAME:"]
[]
["DATE PREPARED:"]
[]
["PREPARED BY:"]
[]
["PREPARER'S TELEPHONE NUMBER:"]
[]
["PREPARER'S E-MAIL ADDRESS:"]
[]
["PREPARER'S CELL PHONE NUMBER:"]
[]
["PREPARER'S ADDRESS AND ZIP CODE:"]
[]
["As the authorized representative of the above-referenced bidder or proponent, I hereby acknowledge that the bidder/proponent understands that the contract or agreement that will be executed with a successful bidder/proponent pursuant to this solicitation "]
[]
[]
[]
[]
[]
[]
["AUTHORIZED REPRESENTATIVE CERTIFICATION:"]
[]
[]
["Signature"]
[]
[]
["NAME:"]
[]
["TITLE:"]
[]
["DATE:"]
[]
[]
[]
["Living Wage Change/No Change Affidavit for Contracts With"]
["Not-For-Profit Entities"]
[]
[]
[null,"I",null,null,null,null,null,null,"swear that there have been no changes in"]
[null,null,null,null,null,null,null,"circumstances affecting its earlier certification as"]
["a non-profit entity conforming to the definition of Exempt Non-Profit Organization in accordance with the Living Wage Ordinance 65597 Subparagraph (A)(iv).  I swear there have been no material changes in the information provided to Affordable Housing Commission the organization's IRS Tax-Exemption Status Determination Letter, Articles of Incorporation and By-laws submitted on"]
[null,null,null,null,"."]
[]
[]
["I specifically swear the following changes have been made (Documentation of Changes shall be submitted with this affidavit):"]
[]
[]
[]
[null,"Signature",null,null,null,null,null,null,"Date"]
[]
["State of",null,null,null,null,null,", City/County of"]
[]
["On this",null,"day of",null,null,2024,"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":"13) SIS","index":13,"n_rows":440,"n_cols":4,"rows_kept":440,"cut":false,"hidden":false,"merged":[[2,2,2,3],[3,2,3,3],[436,0,436,1],[437,0,437,1],[438,0,438,1]]}
[null,null,"EXHIBIT E"]
[null,null,"SUSTAINABILITY IMPACT STATEMENT"]
["Project:",null,{"$f":"'1) Application'!F6","v":0}]
["Developer:",null,{"$f":"'1) Application'!E89","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, Culture & Innovation"]
[null,null,"A. Utilize the Arts, Culture, Design, Creative, and Innovation Industries for Economic and Community Development"]
[1,null,"Continue to attract and sponsor major arts, design, and cultural events"]
[2,null,"Market the City's arts, cultural, 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 culture projects and programs"]
[4,null,"Encourage the development of affordable artist housing, studios, and venues"]
[5,null,"Diversify the City's range of arts, creative, 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 Diversity of Arts & Culture"]
[1,null,"Provide affordable after-school, summer sports and arts camps"]
[2,null,"Ensure existing arts and cultural events and venues are easily accessible"]
[3,null,"Provide all residents with access to basic arts and cultural 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 cultural events"]
[]
[null,null,"C. Develop Multi-Use, Transit Accessible Arts and Cultural Districts"]
[1,null,"Ensure arts & cultural districts are multi-use, walkable, and well served by transit"]
[2,null,"Facilitate development of arts, culture, and innovation TOD's"]
[3,null,"Encourage synergies within arts and cultural development"]
[4,null,"Ensure arts and cultural districts remain affordable and diverse"]
[5,null,"Target developing arts & cultural 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 culture 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 cultural 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, Cultural and Innovation Facilities, Resources, and Events"]
[1,null,"Revitalize existing, and develop new arts and cultural facilities"]
[2,null,"Encourage the expansion of arts and cultural 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, cultural groups and venues in the promotion of their work"]
[]
[null,null,"G. Build Arts, Design and Cultural Leadership, Volunteerism, Stewardship and Funding"]
[1,null,"Provide leadership training in community oriented arts"]
[2,null,"Foster collaboration between arts and cultural 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 culture 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,"Empowerment, Diversity & Equity"]
[null,null,"A. Embrace the Value of Diversity, Aspire Towards Equity, and Attract and Retain a Diverse Population and Culture"]
[1,null,"Support and strengthen programs to retain the City's diverse population"]
[2,null,"Conduct an open dialogue within the community, educational institutions, and businesses about race, gender, class, and lifestyle differences"]
[3,null,"Enhance opportunities available for minorities, women, and the disadvantaged"]
[4,null,"Establish St. Louis as a community of opportunity for all lifestyles"]
[5,null,"Offer a variety of cultural events and awareness programs that celebrate diversity in the City of St. Louis"]
[6,null,"Assist those who immigrate to the City of St. Louis and seek to attract new, diverse residents"]
[7,null,"Enforce civil and equal rights for all"]
[]
[null,null,"B. Encourage Civic Engagement, Transparency and Leadership"]
[1,null,"Involve the public in decisions that are relevant to their communities"]
[2,null,"Expand accessibility of public meetings to increase public input on community issues"]
[3,null,"Increase turnout for voting opportunities"]
[4,null,"Promote the diversity of City boards and commissions to reflect the City's cultural, economic, social, and geographic mix"]
[5,null,"Empower community development corporations, neighborhood advisory committees, and sustainability advocacy groups"]
[]
[null,null,"C. 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,"D. 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,"E. 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,"F. Ensure Equal 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 cultural 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 a diverse 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 Diverse and 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:D439)","v":0}]

{"sheet":"14) 1099","index":14,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":false,"merged":[[34,0,35,9],[16,1,17,10],[7,2,7,5],[10,1,10,9],[11,1,11,9],[9,1,9,9],[12,1,12,9]]}
[]
[]
[]
[]
[]
[]
[]
[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":"Compliance","index":15,"n_rows":72,"n_cols":9,"rows_kept":72,"cut":false,"hidden":false,"merged":[[30,6,30,7],[18,0,18,8],[19,0,19,8],[31,5,31,6],[31,7,31,8],[29,6,29,7],[62,1,62,2],[42,4,43,5],[55,4,56,5],[40,4,40,5],[56,1,56,2],[39,3,40,3],[11,5,11,7],[12,5,12,7],[45,4,46,5],[31,2,31,4],[37,2,37,3],[32,3,36,5],[13,1,13,2],[13,5,13,7],[14,1,14,2],[14,5,14,7],[15,1,15,2],[15,5,15,7],[16,1,16,2],[16,5,16,7],[32,7,36,8],[30,4,30,5],[0,1,0,7],[1,1,1,7],[2,1,2,7],[41,6,41,7],[39,7,40,7],[5,1,5,2],[5,5,5,7],[6,1,6,2],[6,5,6,7],[9,1,12,1],[7,1,7,2],[7,5,7,7],[8,1,8,2],[8,5,8,7],[9,5,9,7],[10,5,10,7]]}
[null,"Rental Production Application/Proforma"]
[null,"COMPLIANCE CHECK"]
[null,"For AHC Staff Use "]
[null,"Project:",{"$f":"project","v":0}]
[]
[null,"Underwriting Standards",null,"Target","Applicant's #","If outside standards, briefly explain:"]
[null,"Vacancy Rate ",null,7.0000000000000007E-2,{"$f":"'7) Operating Budget'!C14","v":7.0000000000000007E-2}]
[null,"Rent Inflation Rate Years 1-3",null,0.02,0.02]
[null,"Rent Inflation Rate Years 4+ ",null,0.02,0.02]
[null,"Inflation Rates for      Operating Costs","Administrative",0.03,0.03]
[null,null,"Operating/Maint.",0.03,0.03]
[null,null,"Utilities",0.03,0.03]
[null,null,"Taxes/Insurance",0.03,0.03]
[null,"Replacement Reserve - Rehab",null,325,{"$f":"'7) Operating Budget'!I35","v":0}]
[null,"Replacement Reserve - New Construction",null,275,275]
[null,"Annual Operating Costs Per Unit",null,3500,{"$f":"'7) Operating Budget'!J33","v":{"$error":"#DIV/0!"}}]
[null,"Debt Coverage Ratio Year 1",null,1.25,{"$f":"'7) Operating Budget'!I41","v":1.25}]
[]
["2024 Income Guidelines"]
["City of St. Louis"]
["Family Size",1,2,3,4,5,6,7,8]
[0.2,{"$f":"E22*0.7","v":14447.999999999998},{"$f":"E22*0.8","v":16512},{"$f":"E22*0.9","v":18576},{"$f":"103200*0.2","v":20640},{"$f":"E22*1.08","v":22291.200000000001},{"$f":"E22*1.16","v":23942.399999999998},{"$f":"E22*1.24","v":25593.599999999999},{"$f":"E22*1.3208","v":27261.311999999998}]
[0.3,21700,24800,27900,31200,36580,41960,47340,52720]
[0.4,{"$f":"E24*0.7","v":28895.999999999996},33024,37152,{"$f":"103200*0.4","v":41280},{"$f":"E24*1.08","v":44582.400000000001},{"$f":"E24*1.16","v":47884.799999999996},{"$f":"E24*1.24","v":51187.199999999997},{"$f":"E24*1.3208","v":54522.623999999996}]
[0.5,36150,41300,46450,51600,55750,59900,64000,68150]
[0.6,{"$f":"E26*0.7","v":43344},{"$f":"E26*0.8","v":49536},{"$f":"E26*0.9","v":55728},{"$f":"103200*0.6","v":61920},{"$f":"E26*1.08","v":66873.600000000006},{"$f":"E26*1.16","v":71827.199999999997},{"$f":"E26*1.24","v":76780.800000000003},{"$f":"E26*1.3208","v":81783.936000000002}]
[0.65,{"$f":"E27*0.7","v":46956},{"$f":"E27*0.8","v":53664},{"$f":"E27*0.9","v":60372},{"$f":"103200*0.65","v":67080},{"$f":"E27*1.08","v":72446.400000000009},{"$f":"E27*1.16","v":77812.799999999988},{"$f":"E27*1.24","v":83179.199999999997},{"$f":"E27*1.3208","v":88599.263999999996}]
[0.7,50568,57792,65016,{"$f":"103200*0.7","v":72240},{"$f":"E28*1.08","v":78019.200000000012},{"$f":"E28*1.16","v":83798.399999999994},{"$f":"E28*1.24","v":89577.600000000006},{"$f":"E28*1.3208","v":95414.592000000004}]
[0.8,57800,66050,74300,82550,89200,95800,102400,109000]
["Source:  HUD Income Limits, huduser.gov/portal/datasets, April 2024."]
[]
[null,null,"2024 Fair Market Rent By Unit Bedrooms"]
[null,"0 Bedrooms",928,"*Rent may not exceed 30% of household income."]
[null,"1 Bedroom  ",972]
[null,"2 Bedrooms",1209]
[null,"3 Bedrooms",1565]
[null,"4 Bedrooms",1818]
[null,null,"Source: HUD, April 2024"]
[]
[null,"Development Costs Standards",null,"Maximum ",null,null,null,"Within Limits?"]
[null,null,"Minimum ",null,"Notes",null,"Project #s"]
[null,"Construction Contingency",null,null,null,null,{"$f":"'1) Application'!G137:M137","v":0}]
[null,"New Construction",0.05,7.4999999999999997E-2,"of Construction  - recommendation only",null,{"$f":"IF(G42=\"New Construction\",'3) Construction Costs'!U72,\"-\")","v":"-"},{"$f":"AND(G43<=D43,G42=\"New Construction\")","v":false}]
[null,"Rehab",7.4999999999999997E-2,0.1,null,null,{"$f":"IF(G42=\"Rehab\",'3) Construction Costs'!U72,\"-\")","v":"-"},{"$f":"AND(G44>=C44,G44<=D44,G42=\"Rehab\")","v":false}]
[null,"Developer Fee"]
[null,"New Construction","na",0.12,"of TDC (excluding Dev Fee itself)",null,{"$f":"IF($G$42=\"New Construction\",'2) Development Budget'!P85,\"-\")","v":"-"},{"$f":"IF(G46<=D46,\"Yes\",\"No\")","v":"No"}]
[null,"Rehab","na",0.15,null,null,{"$f":"IF($G$42=\"Rehab\",'2) Development Budget'!P85,\"-\")","v":"-"},{"$f":"IF(G47<=D47,\"Yes\",\"No\")","v":"No"}]
[null,"Contractor's Fees"]
[null,"Indirect Overhead","na",0.06,"of Construction (less profit, overhead, contingency)",null,{"$f":"'3) Construction Costs'!P76","v":0.06},{"$f":"IF(G49<=D49,\"Yes\",\"No\")","v":"Yes"}]
[null,"Direct Overhead","na",0.02,"of Construction (less profit, overhead, contingency)",null,{"$f":"'3) Construction Costs'!P77","v":0.02},{"$f":"IF(G50<=D50,\"Yes\",\"No\")","v":"Yes"}]
[null,"Profit","na",0.08,"of Construction (less profit, overhead, contingency)",null,{"$f":"'3) Construction Costs'!P78","v":0.08},{"$f":"IF(G51<=D51,\"Yes\",\"No\")","v":"Yes"}]
[null,"TDC = Total Development Costs"]
[]
[null,"Cost & Compliance"]
[null,"Total Development Costs",null,{"$f":"'2) Development Budget'!I112","v":0}]
[null,"Total AHC Funds Requested",null,{"$f":"'4) Sources & Uses'!E25","v":0}]
[null,"AHC Subsidy as % of Total Development Costs",null,{"$f":"D56/D55","v":{"$error":"#DIV/0!"}}]
[null,"Housing Units Developed"]
[null,"# Units in Project",null,{"$f":"'1) Application'!J23","v":0},"Cost Per Unit",null,{"$f":"'4) Sources & Uses'!E21/Compliance!D59","v":{"$error":"#DIV/0!"}}]
[null,"# LMI units in the Project",null,{"$f":"'1) Application'!U25","v":0},"Cost Per LMI Unit",null,{"$f":"'4) Sources & Uses'!E21/Compliance!D60","v":{"$error":"#DIV/0!"}}]
[null,"#AHC-Assisted 20% AMI Units",null,{"$f":"'1) Application'!U24","v":0},"AHC $ Per 20% AMI Unit",null,{"$f":"(D56/D62)*D61","v":{"$error":"#DIV/0!"}}]
[null,"# AHC-assisted Units",null,{"$f":"'1) Application'!U23","v":0},"AHC $ Per AHC-assisted Unit",null,{"$f":"D56/D62","v":{"$error":"#DIV/0!"}}]
[null,"Affordability Period",null,"15 or 30 years"]
[]
[null,"Breakdown of AHC Units by Bedroom Type:"]
[null,"Bedrooms ","# of Units"]
[null,"0 Bedroom",{"$f":"'4) Sources & Uses'!C61","v":0}]
[null,"1 Bedroom",{"$f":"'4) Sources & Uses'!D$61","v":0}]
[null,"2 Bedroom",{"$f":"'4) Sources & Uses'!E$61","v":0}]
[null,"3 Bedroom",{"$f":"'4) Sources & Uses'!F$61","v":0}]
[null,"4 Bedroom",{"$f":"'4) Sources & Uses'!G$61","v":0}]
[null,"Total",{"$f":"SUM(C67:C71)","v":0}]

{"sheet":"Evaluation","index":16,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":true,"merged":[[3,1,3,4],[3,7,3,10],[3,5,3,6],[0,0,0,11],[2,9,2,10],[2,0,2,1],[2,2,2,3],[4,9,4,10],[48,0,50,10],[42,0,42,6],[41,0,41,1],[41,4,41,5],[33,0,33,9],[34,0,34,3],[34,4,34,5],[4,0,4,1],[23,3,23,9],[21,0,21,7],[24,0,24,9],[26,0,26,9],[27,0,27,9],[29,0,29,9],[38,0,39,10],[35,4,35,5],[5,9,5,10],[6,9,6,10],[7,9,7,10],[9,0,19,10],[20,0,20,7],[34,6,34,8],[5,0,5,1],[6,0,6,1],[31,5,31,7],[46,4,46,10],[31,0,31,2],[54,0,56,10],[46,0,46,3],[30,0,30,9],[52,0,52,3],[52,4,52,5],[52,8,52,9],[42,7,42,10],[44,0,44,3],[44,4,44,5],[44,8,44,9],[35,0,35,3],[35,7,35,9],[36,0,36,1],[36,3,36,9]]}
["FALL 2024 RENTAL PROPOSAL EVALUATION"]
[]
["PROPOSAL #:",null,null,null,null,null,null,null,"Ward #",{"$f":"'1) Application'!O8","v":0}]
["NAME:",{"$f":"project","v":0},null,null,null,"DEVELOPER:",null,{"$f":"dev","v":0}]
["TYPE of Request:",null,null,null,null,null,null,null,"Amount Requested:",{"$f":"'1) Application'!J70","v":0}]
["Repayable Loan",null,"X",null,null,null,null,null,"Total Project Budget:",{"$f":"'4) Sources & Uses'!E21","v":0}]
["Forgivable Loan",null,"X",null,null,null,null,null,"# ≤20% AMI AHC Units:",{"$f":"'1) Application'!U24","v":0}]
[null,null,null,null,null,null,null,null,"# ≤80% AMI AHC Units:",{"$f":"'1) Application'!U23","v":0}]
["PROPOSAL DESCRIPTION (including leverage sources)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Calculation of AHC cost per unit or client served to requested amount:",null,null,null,null,null,null,null,null,null,{"$f":"'1) Application'!O70","v":{"$error":"#DIV/0!"}}]
["Calculation of % of total project budget to requested amount:",null,null,null,null,null,null,null,null,null,{"$f":"'4) Sources & Uses'!E25/'4) Sources & Uses'!E21","v":{"$error":"#DIV/0!"}}]
[]
["NOFA Priority:"]
["Proposes housing or shelter for persons and families with incomes ≤20% AMI.",null,null,null,null,null,null,null,null,null,{"$f":"'10) Priorities'!K8","v":0}]
["Proposes permanent supportive housing for special needs & vulnerable households ≤30% AMI.",null,null,null,null,null,null,null,null,null,{"$f":"'10) Priorities'!K10","v":0}]
["Provides assistance to prevent homelessness.",null,null,null,null,null,null,null,null,null,{"$f":"'10) Priorities'!K12","v":0}]
["Develops affordable housing units while advancing 15 or more Sustainability Plan objectives.",null,null,null,null,null,null,null,null,null,{"$f":"'10) Priorities'!K21","v":0}]
["Develops affordable housing within ½ mile of public transportation.",null,null,null,null,null,null,null,null,null,{"$f":"'10) Priorities'!K28","v":0}]
["Comprehensively rehabilitates affordable housing to a green building standard or attains HERS ≤85.",null,null,null,null,null,null,null,null,null,{"$f":"'10) Priorities'!K35","v":0}]
["Proposes housing with three or more bedrooms & serves households  ≤80% AMI.",null,null,null,null,null,null,null,null,null,{"$f":"'10) Priorities'!K39","v":0}]
["Economic Justice Area 1 or 2?",null,null,null,null,"Located North of Delmar?",null,null,{"$f":"'1) Application'!Q18","v":0},"Priorities",{"$f":"COUNTIF(K25:K31, \"Yes\")","v":0}]
[]
["NEW CONSTRUCTION - Designed & built to a national green building standard?",null,null,null,null,null,null,null,null,null,{"$f":"'1) Application'!P149","v":0}]
["UD CERTIFICATION:",null,null,null,{"$f":"'1) Application'!N506","v":0},null,"REQUESTS UD WAIVER?",null,null,{"$f":"'1) Application'!U519","v":0},"N/A Rehab"]
["PREVIOUS AWARDEE:",null,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,null,"Amount:"]
[]
["REASONS NOT TO FUND:"]
[]
["STAFF RECOMMENDED TERMS: "]
[]
[]
[]
["COMMISSION APPROVAL:",null,null,null,null,null,null,"Amount:"]
[]
["COMMISSION RECOMMENDED TERMS: "]

{"sheet":"Review","index":17,"n_rows":69,"n_cols":10,"rows_kept":69,"cut":false,"hidden":true,"merged":[[49,0,49,4],[35,5,35,6],[36,5,36,6],[40,5,40,6],[37,5,37,6],[38,5,38,6],[47,0,47,4],[44,5,44,6],[48,5,48,6],[48,0,48,4],[41,5,41,6],[23,0,23,3],[46,5,46,6],[47,5,47,6],[43,5,43,6],[0,0,0,10],[30,5,30,6],[34,5,34,6],[12,3,12,4],[4,8,4,10],[7,2,7,7],[10,2,10,10],[6,2,6,3],[6,4,6,5],[5,4,5,5],[2,8,2,10],[5,8,5,10],[58,0,58,4],[58,5,58,6],[57,0,57,4],[57,5,57,6],[50,5,50,6],[50,0,50,4],[54,5,54,6],[55,5,55,6],[56,0,56,4],[56,5,56,6],[55,0,55,4],[52,5,52,6],[51,0,51,4],[54,0,54,4],[53,5,53,6],[51,5,51,6],[33,5,33,6],[31,5,31,6],[28,5,28,6],[29,5,29,6],[49,5,49,6],[42,5,42,6],[39,5,39,6],[12,6,12,10],[23,5,23,6],[27,5,27,6],[26,5,26,6],[25,5,25,6],[24,5,24,6],[3,2,3,5],[5,2,5,3],[4,2,4,5],[2,6,2,7],[3,6,3,7],[4,6,4,7],[2,1,2,5]]}
["FALL 2024 RENTAL PROJECT REVIEW"]
[]
["Project Name:",{"$f":"'1) Application'!F6","v":0},null,null,null,null,"Neighborhood:",null,{"$f":"'1) Application'!R7","v":0}]
["Project Number:",null,{"$f":"Evaluation!C3:D3","v":0},null,null,null,"Ward:",null,{"$f":"'1) Application'!O8","v":0}]
["Applicant/Developer:",null,{"$f":"'1) Application'!E89","v":0},null,null,null,"Project Address:",null,{"$f":"'1) Application'!F7","v":0}]
["Funding Request:",null,{"$f":"Evaluation!J5","v":0},null,null,null,null,"Sponsor:",{"$f":"'1) Application'!E418","v":0}]
["Total Project Cost:",null,{"$f":"Evaluation!J6","v":0},null,null,null,null,null,"MBE","WBE"]
["General Contractor:",null,{"$f":"'1) Application'!E347","v":0},null,null,null,null,null,{"$f":"'1) Application'!T347","v":0},{"$f":"'1) Application'!U347","v":0}]
["Located in Promise Zone?",null,{"$f":"'1) Application'!Q19","v":0},null,null,null,null,"Located North of Delmar?",null,{"$f":"'1) Application'!Q18","v":0}]
["Located in Economic Justice Area 1 or 2?",null,null,{"$f":"Evaluation!D32","v":0}]
["Preferred Repayment Terms:",null,{"$f":"'1) Application'!B73","v":0}]
[]
["Income Served","# Units","LMI Units","AHC-Assisted Units",null,null,"Support Services to be offered to residents"]
["20% AMI",{"$f":"'1) Application'!J31","v":0},null,{"$f":"'1) Application'!U24","v":0},null,null,{"$f":"'1) Application'!B299","v":0},"Case management"]
["30% AMI",{"$f":"'1) Application'!J30","v":0},null,null,null,null,{"$f":"'1) Application'!B300","v":0},"Healthcare resources"]
["40% AMI",{"$f":"'1) Application'!J29","v":0},null,null,null,null,{"$f":"'1) Application'!B301","v":0},"Food"]
["50% AMI",{"$f":"'1) Application'!J28","v":0},null,null,null,null,{"$f":"'1) Application'!B302","v":0},"Housing counseling"]
["60% AMI",{"$f":"'1) Application'!J27","v":0},null,null,null,null,{"$f":"'1) Application'!B303","v":0},"Job training & placement"]
["70% AMI",{"$f":"'1) Application'!J26","v":0},null,null,null,null,null,"Other, describe below"]
["80% AMI",{"$f":"'1) Application'!J25","v":0}]
["Market-Rate",{"$f":"'1) Application'!J24","v":0}]
["Total",{"$f":"SUM(B14:B21)","v":0},{"$f":"'1) Application'!U25","v":0},{"$f":"'1) Application'!U23","v":0}]
[]
["Interim Leveraging Sources:",null,null,null,null,"Amount",null,"% (of TDC)"]
[{"$f":"'4) Sources & Uses'!B39","v":"Private Construction Loan  (bank financing)"},null,null,null,null,{"$f":"'4) Sources & Uses'!F39","v":0},null,{"$f":"F25/$C$7","v":{"$error":"#DIV/0!"}}]
["Developer Equity",null,null,null,null,{"$f":"'4) Sources & Uses'!F40","v":0},null,{"$f":"F26/$C$7","v":{"$error":"#DIV/0!"}}]
[{"$f":"'4) Sources & Uses'!B41","v":"Deferred Developer Fee"},null,null,null,null,{"$f":"'4) Sources & Uses'!F41","v":0},null,{"$error":"#DIV/0!"}]
[{"$f":"'4) Sources & Uses'!B42","v":"Other:  CDA"},null,null,null,null,{"$f":"'4) Sources & Uses'!F42","v":0},null,{"$error":"#DIV/0!"}]
[{"$f":"'4) Sources & Uses'!B43","v":"Other Source 2:"},null,null,null,null,{"$f":"'4) Sources & Uses'!F43","v":0},null,{"$error":"#DIV/0!"}]
[{"$f":"'4) Sources & Uses'!B44","v":"Other Source 3:"},null,null,null,null,{"$f":"'4) Sources & Uses'!F44","v":0},null,{"$error":"#DIV/0!"}]
[{"$f":"'4) Sources & Uses'!B45","v":"AHC Construction Loan requested*"},null,null,null,null,{"$f":"'4) Sources & Uses'!F45","v":0},null,{"$error":"#DIV/0!"}]
["Total Construction Financing",null,null,null,null,{"$f":"SUM(F25:G31)","v":0},null,{"$f":"F32/C7","v":{"$error":"#DIV/0!"}}]
[]
["Permanent Leveraging Sources:",null,null,null,null,"Amount",null,"% (of TDC)","Status","Date"]
[{"$f":"'4) Sources & Uses'!B24","v":"Bank Mortgage "},null,null,null,null,{"$f":"'4) Sources & Uses'!E24","v":0},null,{"$f":"F35/$C$7","v":{"$error":"#DIV/0!"}},{"$f":"'4) Sources & Uses'!F75","v":0},{"$f":"'4) Sources & Uses'!H75","v":"00:00:00"}]
[{"$f":"'4) Sources & Uses'!B26","v":"Estimated MO State Historic Tax Credits"},null,null,null,null,{"$f":"'4) Sources & Uses'!E26","v":0},null,{"$f":"F36/$C$7","v":{"$error":"#DIV/0!"}},{"$f":"'4) Sources & Uses'!F76","v":0},{"$f":"'4) Sources & Uses'!H76","v":"00:00:00"}]
[{"$f":"'4) Sources & Uses'!B27","v":"Estimated Federal Historic Tax Credits"},null,null,null,null,{"$f":"'4) Sources & Uses'!E27","v":0},null,{"$error":"#DIV/0!"},{"$f":"'4) Sources & Uses'!F77","v":0},{"$f":"'4) Sources & Uses'!H77","v":"00:00:00"}]
[{"$f":"'4) Sources & Uses'!B29","v":"Source 1: CDA"},null,null,null,null,{"$f":"'4) Sources & Uses'!E29","v":0},null,{"$error":"#DIV/0!"},{"$f":"'4) Sources & Uses'!F78","v":0},{"$f":"'4) Sources & Uses'!H78","v":"00:00:00"}]
[{"$f":"'4) Sources & Uses'!B30","v":"Source 2:"},null,null,null,null,{"$f":"'4) Sources & Uses'!E30","v":0},null,{"$error":"#DIV/0!"},{"$f":"'4) Sources & Uses'!F79","v":0},{"$f":"'4) Sources & Uses'!H79","v":"00:00:00"}]
[{"$f":"'4) Sources & Uses'!B31","v":"Source 3:"},null,null,null,null,{"$f":"'4) Sources & Uses'!E31","v":0},null,{"$error":"#DIV/0!"},{"$f":"'4) Sources & Uses'!F80","v":0},{"$f":"'4) Sources & Uses'!H80","v":"00:00:00"}]
[{"$f":"'4) Sources & Uses'!B32","v":"Source 4:"},null,null,null,null,{"$f":"'4) Sources & Uses'!E32","v":0},null,{"$error":"#DIV/0!"},{"$f":"'4) Sources & Uses'!F81","v":0},{"$f":"'4) Sources & Uses'!H81","v":"00:00:00"}]
[{"$f":"'4) Sources & Uses'!B33","v":"Source 5:"},null,null,null,null,{"$f":"'4) Sources & Uses'!E33","v":0},null,{"$error":"#DIV/0!"},{"$f":"'4) Sources & Uses'!F82","v":0},{"$f":"'4) Sources & Uses'!H82","v":"00:00:00"}]
[{"$f":"'4) Sources & Uses'!B28","v":"Developer Equity"},null,null,null,null,{"$f":"'4) Sources & Uses'!E28","v":0},null,{"$error":"#DIV/0!"},{"$f":"'4) Sources & Uses'!F83","v":0},{"$f":"'4) Sources & Uses'!H83","v":"00:00:00"}]
[{"$f":"'4) Sources & Uses'!B25","v":"AHC Permanent Loan requested*"},null,null,null,null,{"$f":"'4) Sources & Uses'!E25","v":0},null,{"$error":"#DIV/0!"},{"$f":"'4) Sources & Uses'!E25","v":0},{"$f":"'4) Sources & Uses'!H84","v":"00:00:00"}]
["Total Permanent Financing",null,null,null,null,{"$f":"SUM(F35:G44)","v":0},null,{"$f":"F45/C7","v":{"$error":"#DIV/0!"}}]
[]
["Summary",null,null,null,null,"Amount",null,"% (of TDC)"]
["Total Development Cost",null,null,null,null,{"$f":"'4) Sources & Uses'!E21","v":0}]
["Hard Construction Cost",null,null,null,null,{"$f":"'3) Construction Costs'!K73","v":0},null,{"$f":"F49/$C$7","v":{"$error":"#DIV/0!"}}]
["Soft Costs",null,null,null,null,{"$f":"'4) Sources & Uses'!E14+'4) Sources & Uses'!E15+'4) Sources & Uses'!E16+'4) Sources & Uses'!E17+'4) Sources & Uses'!E18+'4) Sources & Uses'!E19+'4) Sources & Uses'!E20","v":0},null,{"$f":"F50/$C$7","v":{"$error":"#DIV/0!"}}]
["Developer Fee (included in soft costs)",null,null,null,null,{"$f":"'2) Development Budget'!I85","v":0},null,{"$f":"F51/$C$7","v":{"$error":"#DIV/0!"}}]
["Builder's Profit (not in hard/soft costs)",null,null,null,null,{"$f":"'3) Construction Costs'!K71","v":0},null,{"$f":"F52/$C$7","v":{"$error":"#DIV/0!"}}]
["Contingency",null,null,null,null,{"$f":"'3) Construction Costs'!K72","v":0},null,{"$f":"F53/$C$7","v":{"$error":"#DIV/0!"}}]
["Land & Building",null,null,null,null,{"$f":"'2) Development Budget'!I75+'2) Development Budget'!I77","v":0}]
["Cost Per Unit",null,null,null,null,{"$f":"C7/'1) Application'!J23","v":{"$error":"#DIV/0!"}}]
["Cost Per Square Foot",null,null,null,null,{"$f":"'2) Development Budget'!N112","v":{"$error":"#DIV/0!"}}]
["AHC Funds Per AHC-Assisted Unit",null,null,null,null,{"$f":"'4) Sources & Uses'!E25/'1) Application'!U23","v":{"$error":"#DIV/0!"}}]
["AHC Funds Per 20% AMI AHC-Assisted Unit",null,null,null,null,{"$f":"'1) Application'!S70","v":{"$error":"#DIV/0!"}}]
["AHC % of Total Project Cost",null,null,null,null,{"$f":"F44/F48","v":{"$error":"#DIV/0!"}}]
[]
["Priorities to be Attained",null,null,null,null,"Location"]
[{"$f":"'10) Priorities'!K8","v":0},"≤20% AMI",null,null,null,"Located in Promise Zone?",null,null,null,{"$f":"'1) Application'!Q19","v":0}]
[{"$f":"'10) Priorities'!K10","v":0},"≤30% AMI & PSH",null,null,null,"Located in Economic Justice Area 1 or 2?",null,null,null,{"$f":"D10","v":0}]
[{"$f":"'10) Priorities'!K12","v":0},"Prevents Homeless",null,null,null,"Located North of Delmar:",null,null,null,{"$f":"'1) Application'!Q18","v":0}]
[{"$f":"'10) Priorities'!K21","v":0}," ≥15 Green Object."]
[{"$f":"'10) Priorities'!K28","v":0},"Public Transit"]
[{"$f":"'10) Priorities'!K35","v":0},"EE Rehab"]
[{"$f":"'10) Priorities'!K39","v":0},{"$f":"'10) Priorities'!C48","v":"3+ Bedrooms"}]
[{"$f":"COUNTIF(A62:A68, \"Yes\")","v":0},"Priorities to be Attained"]

{"sheet":"Rating","index":18,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":true,"merged":[[38,9,38,10],[39,0,39,10],[22,0,22,6],[36,0,36,6],[27,0,27,6],[31,0,31,6],[33,0,33,6],[34,0,34,6],[32,0,32,6],[29,0,29,4],[37,0,37,6],[41,0,41,2],[38,0,38,4],[38,5,38,7],[30,0,30,6],[21,0,21,6],[23,0,23,6],[26,0,26,6],[24,0,24,6],[25,0,25,6],[28,0,28,6],[35,0,35,6],[0,0,0,10],[17,0,17,6],[18,0,18,6],[20,0,20,6],[4,3,4,4],[16,0,16,6],[3,3,3,7],[6,3,6,9],[13,3,13,10],[2,2,2,7],[5,3,5,4],[19,0,19,6],[11,3,11,8],[8,7,8,9],[7,6,7,9]]}
["FALL 2024 RENTAL RATING SHEET"]
[]
["Name:",null,{"$f":"project","v":0},null,null,null,null,null,null,"Ward #",{"$f":"'1) Application'!O8","v":0}]
["Applicant/Developer:",null,null,{"$f":"'1) Application'!E89","v":0},null,null,null,null,null,"Proj. #",{"$f":"Evaluation!C3","v":0}]
["Funding Request:",null,null,{"$f":"'4) Sources & Uses'!E25","v":0}]
["Total Project Cost:",null,null,{"$f":"Review!C7","v":0}]
["Project Address:",null,null,{"$f":"'1) Application'!F7","v":0}]
["In the St. Louis Promise Zone?",null,null,{"$f":"'1) Application'!Q19","v":0},null,null,"In Economic Justice Area 1 or 2?",null,null,null,{"$f":"Evaluation!D32","v":0}]
["AHC-Assisted Units:",null,null,{"$f":"'1) Application'!U23","v":0},null,null,null,"Located North of Delmar?",null,null,{"$f":"'1) Application'!Q18","v":0}]
["≤20% AMI Units:",null,null,{"$f":"'1) Application'!U24","v":0},null,null,null,null,null,"LMI Units:",{"$f":"'1) Application'!U25","v":0}]
["Site control from Land Reutilization Authority?",null,null,null,{"$f":"'1) Application'!R183","v":0},null,null,null,null,"Total Units:",{"$f":"'1) Application'!J23:K23","v":0}]
["Neighborhood or housing sponsor:",null,null,{"$f":"'1) Application'!E418","v":0}]
[]
["Preferred Repayment:",null,null,{"$f":"'1) Application'!B73","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."]
["Sources & Uses"]
["Costs are reasonable & sufficient."]
["Strong financial support and the project supports its debt."]
["Significant community support."]
["Neighborhood & Market"]
["Marketing plan supports proposed rents?"]
["Strengthens & capitalizes on existing assets to benefit the neighborhood."]
["Utilizes the MVA toward a strategic, equitable use of Trust Fund dollars."]
["Development Team"]
["The project team is qualified & experienced."]
["Projected time frame:  The project is to be complete within 16 months.",null,null,null,null,{"$f":"'1) Application'!O343","v":0},"months"]
["NOFA Priority"]
["Provides housing or shelter for persons or families earning ≤20% AMI.",null,null,null,null,null,null,null,null,{"$f":"'10) Priorities'!K8","v":0}]
["Provides permanent supportive housing for persons or families earning ≤30% AMI.",null,null,null,null,null,null,null,null,{"$f":"'10) Priorities'!K10","v":0}]
["Provides assistance to prevent homelessness.",null,null,null,null,null,null,null,null,{"$f":"'10) Priorities'!K12","v":0}]
["Develops affordable housing units while advancing 15 or more Sustainability Plan objectives.",null,null,null,null,null,null,null,null,{"$f":"'10) Priorities'!K21","v":0}]
["Develops affordable housing within ½ mile of public transportation.",null,null,null,null,null,null,null,null,{"$f":"'10) Priorities'!K28","v":0}]
["Comprehensively rehabilitates affordable housing to a national green building standard or attains a HERS of ≤85.",null,null,null,null,null,null,null,null,{"$f":"'10) Priorities'!K35","v":0}]
[{"$f":"'10) Priorities'!B39","v":"Proposes housing with three or more bedrooms & serves households with incomes ≤80% AMI."},null,null,null,null,null,null,null,null,{"$f":"'10) Priorities'!K39","v":0}]
["AHC Recommendation for funding",null,null,null,null,null,null,null,null,"$"]
["AHC Terms:"]
[]
["Comments/Concerns:"]