{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Tab 1 Applicant Information","Tab 2 Financial Statement","Tab 3 Rent Schedule","Tab 4 Utility Allowance","Tab 5 Current Operating Budget","Tab 6 Thirty Year Proforma","Tab 7 BuildingUnitConfiguration","Tab 8 CDBG Budget","Tab 9 Summary Sources and Uses"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":24,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tab 1 Applicant Information","index":0,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[11,0,12,8],[7,0,9,8],[0,0,0,8],[2,2,2,3],[3,5,3,7],[4,2,4,3]]}
["2018/2019 MULTIFAMILY UNIFORM APPLICATION PACKET - Attachment A - Exhibit C"]
[]
["Applicant Name:",null,"Applicant Representative"]
[null,null,null,null,null,"Signature of person or authorized representative"]
["Date:",null,"Date",null,null,"Type name of person or authorized representative"]
[]
[]
["WARNING: ANY PERSON WHO KNOWINGLY MAKES A FALSE CLAIM OR STATEMENT TO HUD MAY BE SUBJECT TO CIVIL OR CRIMINAL PENALTIES UNDER 18 U.S.C. §287, §1001, AND 31 U.S.C. §3729."]
[]
[]
[]
["Applicant should complete, in conjuction with the Multifamily Uniform Application, all applicable tabs contained herein. The following check list is provided to Applicant for convenience purposes."]
[]
[]
[null,null,"Tab No.","Tab Title"]
[null,null,1,"Applicant Information","________"]
[null,null,2,"Financial Statement","________"]
[null,null,3,"Rent Schedule","________"]
[null,null,4,"Utility Allowance","________"]
[null,null,5,"Current Operating Budget","________"]
[null,null,6,"Thirty Year Proforma","________"]
[null,null,7,"Building Unit Configuration ","________"]
[null,null,8,"CDBG Budget","________"]
[null,null,9,"Summary of Sources and Uses","________"]

{"sheet":"Tab 2 Financial Statement","index":1,"n_rows":95,"n_cols":8,"rows_kept":95,"cut":false,"hidden":false,"merged":[[92,1,92,2],[93,4,93,6],[94,1,94,2],[7,0,7,1],[7,4,7,5],[3,0,3,7],[88,0,89,7],[12,0,12,1],[12,4,12,5],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,4,18,5],[8,0,8,1],[8,4,8,5],[10,0,10,1],[11,0,11,1],[9,4,9,5],[10,4,10,5],[11,4,11,5],[9,0,9,1],[23,4,23,5],[24,4,24,5],[25,0,25,1],[25,4,25,5],[22,4,22,5],[26,4,26,5],[20,0,20,1],[21,0,21,1],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,0,22,1],[30,4,30,5],[34,0,34,1],[35,0,35,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[29,4,29,5],[26,0,26,1],[30,0,30,1],[36,0,36,1],[36,4,36,5],[37,0,37,1],[37,4,37,5],[40,0,40,1],[40,4,40,5],[31,4,31,5],[32,4,32,5],[33,4,33,5],[45,0,45,1],[45,4,45,5],[52,0,52,1],[52,4,52,5],[41,0,41,1],[43,4,43,5],[44,0,44,1],[44,4,44,5],[41,4,41,5],[42,4,42,5],[43,0,43,1],[42,0,42,1],[57,0,57,1],[57,4,57,5],[58,0,58,1],[58,4,58,5],[59,0,59,1],[61,4,61,5],[53,0,53,1],[53,4,53,5],[54,0,54,1],[55,0,55,1],[56,0,56,1],[56,4,56,5],[55,4,55,5],[54,4,54,5],[70,4,70,5],[62,0,62,1],[62,4,62,5],[63,0,63,1],[64,0,64,1],[65,4,65,5],[67,0,67,1],[66,4,66,5],[67,4,67,5],[0,0,0,7],[79,0,79,1],[79,4,79,5],[80,0,80,1],[80,4,80,5],[81,0,81,1],[81,4,81,5],[76,0,76,1],[76,4,76,5],[77,0,77,1],[77,4,77,5],[78,0,78,1],[78,4,78,5],[71,0,71,1],[71,4,71,5],[74,0,74,1],[74,4,74,5],[75,0,75,1],[75,4,75,5],[68,0,68,1],[68,4,68,5],[69,0,69,1],[69,4,69,5],[70,0,70,1]]}
["2018/2019 MULTIFAMILY UNIFORM APPLICATION PACKET - EXHIBIT A"]
[]
["FINANCIAL STATEMENT"]
["If additional space is needed, lines may be combined to include mutliple items; however, a separate attachment with an explanation of each item included is required."]
["ASSETS"]
["CURRENT ASSETS",null,null,null,"LONG TERM ASSETS"]
["Cash on Hand and in Banks",null,null,null,"Long Term Notes Receivable"]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
["Total Cash on Hand",null,null,{"$f":"SUM(C8:C13)","v":0},"Less Doubtful Notes",null,0]
["Savings Accounts",null,null,null,"Total L/T Notes Receivable",null,null,{"$f":"SUM(G8:G13)-ABS(G14)","v":0}]
[null,null,0,null,"Life Insurance (Cash Value)"]
[null,null,0,null,null,null,null,0]
[null,null,0,null,"Real Property (At Net)"]
["Total Savings",null,null,{"$f":"SUM(C16:C18)","v":0},null,null,0]
["IRA or Other Retirement Accounts",null,null,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
["Total Retirement",null,null,{"$f":"SUM(C21:C23)","v":0},null,null,0]
["Accounts & Notes Receivable",null,null,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,"Total Real Property",null,null,{"$f":"SUM(G19:G27)","v":0}]
[null,null,0,null,"Personal Property (At Net)"]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
["Less Doubtful Accounts",null,0,null,null,null,0]
["Total Receivables",null,null,{"$f":"SUM(C26:C31)-ABS(C32)","v":0},null,null,0]
["Stocks and Bonds (Market Value)",null,null,null,null,null,0]
[null,null,0,null,"Total Real Property",null,null,{"$f":"SUM(G30:G34)","v":0}]
[null,null,0,null,"Automobile (Present Value)"]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
["Total Stocks and Bonds",null,null,{"$f":"SUM(C35:C38)","v":0},"Total Automobiles",null,null,{"$f":"SUM(G37:G38)","v":0}]
["Other Current Assets",null,null,null,"Other Long Term Assets"]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
["Total Other Current Assets",null,null,{"$f":"SUM(C41:C46)","v":0},"Total Other Long Term Assets",null,null,{"$f":"SUM(G41:G46)","v":0}]
["TOTAL CURRENT ASSETS",null,null,{"$f":"D14+D19+D24+D33+D39+D47","v":0},"TOTAL LONG TERM ASSETS",null,null,{"$f":"H15+H17+H28+H35+H39+H47","v":0}]
[null,null,null,null,"TOTAL ASSETS",null,null,{"$f":"D48+H48","v":0}]
["LIABILITIES AND NET WORTH"]
["CURRENT LIABILITIES",null,null,null,"LONG TERM LIABILITIES"]
["Accounts Payable",null,null,null,"Long Term Notes Payable to Banks and Others"]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,"Total L/T Notes Payable",null,null,{"$f":"SUM(G53:G59)","v":0}]
["Total Accounts Payable",null,null,{"$f":"SUM(C53:C60)","v":0},"Loans on Life Insurance"]
["Current Notes Payable",null,null,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,"Total Loans on Life Insurance",null,null,{"$f":"SUM(G62:G63)","v":0}]
[null,null,0,null,"Long Term Real Estate Notes Payable"]
["Total Installment Accounts",null,null,{"$f":"SUM(C63:C65)","v":0},null,null,0]
["Current Real Estate Notes Payable",null,null,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
["Total Real Estate Notes Payable",null,null,{"$f":"SUM(C68:C72)","v":0},"Total Real Estate Notes Payable",null,null,{"$f":"SUM(G66:G72)","v":0}]
["Other Current Liabilities",null,null,null,"Other Long Term Liabilities"]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
["Total Other Liabilities",null,null,{"$f":"SUM(C75:C82)","v":0},"Total Other Liabilities",null,null,{"$f":"SUM(G75:G82)","v":0}]
["TOTAL CURRENT LIABILITIES",null,null,{"$f":"D61+D66+D73+D83","v":0},"LONG TERM LIABILITIES",null,null,{"$f":"H60+H64+H73+H83","v":0}]
[null,null,null,null,"TOTAL LIABILITIES",null,null,{"$f":"D84+H84","v":0}]
[null,null,null,null,"CONTINGENT LIABILITIES",null,0,"Attach Description"]
[null,null,null,null,"TOTAL NET WORTH",null,null,{"$f":"H49-H85","v":0}]
[]
["WARNING: ANY PERSON WHO KNOWINGLY MAKES A FALSE CLAIM OR STATEMENT TO HUD MAY BE SUBJECT TO CIVIL OR CRIMINAL PENALTIES UNDER 18 U.S.C. §287, §1001, AND 31 U.S.C. §3729."]
[]
[]
[]
["Name:","Person represented in Financial Statement"]
[null,null,null,null,"Signature of person or authorized representative"]
["As of:","Date of Financial Statement",null,null,"Type name of person or authorized representative"]

{"sheet":"Tab 3 Rent Schedule","index":2,"n_rows":76,"n_cols":14,"rows_kept":76,"cut":false,"hidden":false,"merged":[[52,0,52,13],[63,2,63,4],[69,2,69,4],[70,2,70,4],[71,10,71,12],[55,2,55,4],[56,2,56,4],[57,2,57,4],[64,2,64,4],[59,2,59,4],[60,2,60,4],[61,2,61,4],[58,2,58,4],[62,2,62,4],[62,10,62,12],[63,10,63,12],[73,0,73,13],[71,2,71,4],[66,2,66,4],[67,2,67,4],[68,2,68,4],[68,10,68,12],[70,10,70,12],[65,10,65,12],[66,10,66,12],[67,10,67,12],[65,2,65,4],[69,10,69,12],[55,10,55,12],[56,10,56,12],[57,10,57,12],[58,10,58,12],[59,10,59,12],[60,10,60,12],[61,10,61,12],[64,10,64,12],[49,3,49,12],[4,6,4,11],[50,3,50,12],[51,3,51,12],[44,9,44,12],[6,0,6,13],[45,9,45,12],[43,9,43,12],[8,0,8,13],[7,0,7,13],[10,2,10,8],[10,11,10,13],[42,6,42,8],[47,3,47,12],[42,3,42,4],[1,0,1,13],[0,0,0,13],[5,0,5,4],[4,0,4,4],[5,6,5,11],[3,0,3,13],[2,0,2,13],[75,0,75,13],[85,3,85,9],[86,3,86,10],[77,0,77,3],[78,1,78,11],[80,3,80,5],[81,3,81,9],[82,3,82,10],[84,3,84,5]]}
[]
["Rent Schedule (Required for All Rental Developments)"]
["Unit types should be entered from smallest to largest based on \"# of Bedrooms\"and \"Unit Size\", then within the same \"# of Bedrooms\" and \"unit Size\" from lowest to highest \"Rental Income/Unit\". "]
["Type of Unit designation should be one or more of the following based on the unit's rent restrictions:"]
["Tax Credit: (TC30%), (TC40%), (TC50%), (TC60%), Employee Occupied (EO), Market Rate (MR), as allowed by Sec. 42. ",null,null,null,null,null,"501(c)(3) Mortgage Revenue Bond: (MRB), (MRB30%), (MRB40%), (MRB50%), (MRB60%), Market Rate(MRBMR)."]
["HOME: High (HH), Low (LH), Employee Occupied non LI unit (MR/EO), Market Rate (MR)",null,null,null,null,null,"Other: describe any \"Other\" rental assistance or rent restrictions in the space provided; documentation supporting the rentl assistance or restrictions must be provided"]
["Housing Trust Fund: (HTF30%), (HTF40%), (HTF50%), (HTF60%), (HTF80%), Market Rate (MR)"]
["Units funded under more than one program, the \"Program Rent Limit\" should be the most restrictive - for example, a LH and TC60% unit would use the “LH” Program rent limit."]
["The rent and utility limits available at the time the MUA is submitted should be used to complete this form.  Gross Rent cannot exceed the HUD maximum rent limits unless documentation of project-based rental assistance is provided.  The unit mix and net rentable square footages must be consistent with the site plan and architectural drawings. "]
[]
[null,"Development Name: ",null,null,null,null,null,null,null,null,"City:"]
[]
["HTC Unit Designation","HOME Unit Designation ","HTF Unit Designation","MRB Unit Designation ","Other Designation/Subsidy","# of Units","# of         Bed-       rooms","# of Baths","Unit Size (Net Rentable Sq. Ft.)","Total Net Rentable Sq. Ft.","Program Rent Limit","Tenant Paid Utility Allow.","Rent Collected         /Unit","Total Monthly Rent"]
[null,null,null,null,null,"(A)",null,null,"(B)","(A) x (B)",null,null,"(E)","(A) x (E)"]
[null,null,null,null,null,null,null,null,null,{"$f":"+I15*F15","v":0},null,null,null,{"$f":"+M15*F15","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"+I22*F22","v":0},null,null,null,{"$f":"+M22*F22","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"+I29*F29","v":0},null,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"+I30*F30","v":0},null,null,null,{"$f":"+M30*F30","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"+I37*F37","v":0},null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,"TOTAL",null,{"$f":"SUM(F15:F42)","v":0},null,null,null,{"$f":"SUM(J15:J42)","v":0},null,null,null,{"$f":"SUM(N15:N42)","v":0}]
[null,null,null,"   Non Rental Income",null,null,{"$f":"IF(N44=0,0,N44/SUM($F$15:$F$42))","v":0},"per unit/month for:",null,"describe source here"]
[null,null,null,"   Non Rental Income",null,null,{"$f":"IF(N45=0,0,N45/SUM($F$15:$F$42))","v":0},"per unit/month for:",null,"describe source here"]
[null,null,null,"   Non Rental Income",null,null,{"$f":"IF(N46=0,0,N46/SUM($F$15:$F$42))","v":0},"per unit/month for:",null,"describe source here"]
[null,null,null,"+ TOTAL NONRENTAL INCOME",null,null,{"$f":"SUM(G44:G46)","v":0},"per unit/month",null,null,null,null,null,{"$f":"SUM(N44:N46)","v":0}]
[null,null,null,"= POTENTIAL GROSS MONTHLY INCOME",null,null,null,null,null,null,null,null,null,{"$f":"N43+N47","v":0}]
[null,null,null,"- Provision for Vacancy & Collection Loss ",null,null,null,null,null,null,null,"% of Potential Gross Income:",7.4999999999999997E-2,{"$f":"+N48*M49","v":0}]
[null,null,null,"- Rental Concessions"]
[null,null,null,"= EFFECTIVE GROSS MONTHLY INCOME",null,null,null,null,null,null,null,null,null,{"$f":"N48-N49-N50","v":0}]
[null,null,null,"x 12 = EFFECTIVE GROSS ANNUAL INCOME",null,null,null,null,null,null,null,null,null,{"$f":"N43*12+N47*12-(N49+N50)*12","v":0}]
["Populations Served"]
["Rent Schedule (Cont.)"]
[]
[null,null,"TC30%",null,null,{"$f":"SUMIF(A15:A42, \"TC30%\", F15:F42)","v":0},null,null,null,null,"HTF30%",null,null,{"$f":"SUMIF(C15:C42, \"HTF30%\", F15:F42)","v":0}]
[null,null,"TC40%",null,null,{"$f":"SUMIF(A15:A42, \"TC40%\", F15:F42)","v":0},null,null,"HOUSING",null,"HTF40%",null,null,{"$f":"SUMIF(C15:C42, \"HTF60%\", F15:F42)","v":0}]
["HOUSING",null,"TC50%",null,null,{"$f":"SUMIF(A15:A42, \"TC50%\", F15:F42)","v":0},null,null,null,null,"HTF50%",null,null,{"$f":"SUMIF(C15:C42, \"HTF50%\", F15:F42)","v":0}]
[null,null,"TC60%",null,null,{"$f":"SUMIF(A15:A42, \"TC60%\", F15:F42)","v":0},null,null,null,null,"HTF60%",null,null,{"$f":"SUMIF(C15:C42, \"HTF60%\", F15:F42)","v":0}]
["TAX",null,"HTC LI Total",null,null,{"$f":"SUM(F56:F59)","v":0},null,null,"TRUST",null,"HTF80%",null,null,{"$f":"SUMIF(C15:C42, \"HTF80%\", F15:F42)","v":0}]
[null,null,"TCEO",null,null,{"$f":"SUMIF(A15:A42, \"EO\", F15:F42)","v":0},null,null,null,null,"HTF LI Total",null,null,{"$f":"SUM(N56:N60)","v":0}]
["CREDITS",null,"MR",null,null,{"$f":"SUMIF(A15:A42, \"MR\", F15:F42)","v":0},null,null,null,null,"MR",null,null,{"$f":"SUMIF(C15:C42, \"MR\", F15:F42)","v":0}]
[null,null,"MR Total",null,null,{"$f":"SUM(F61:F62)","v":0},null,null,"FUND",null,"MR Total",null,null,{"$f":"SUM(N62)","v":0}]
[null,null,"TC Total",null,null,{"$f":"SUM(F60,F63)","v":0},null,null,null,null,"HTF Total",null,null,{"$f":"SUM(N61,N63)","v":0}]
[null,null,"MRB30%",null,null,{"$f":"SUMIF(D15:D42, \"MRB30%\", F15:F42)","v":0},null,null,null,null,"HOME HH",null,null,{"$f":"SUMIF(B15:B42, \"HH\", F15:F42)","v":0}]
[null,null,"MRB40%",null,null,{"$f":"SUMIF(D15:D42, \"MRB40%\", F15:F42)","v":0},null,null,null,null,"HOME LH",null,null,{"$f":"SUMIF(B15:B42, \"LH\", F15:F42)","v":0}]
["MORTGAGE",null,"MRB50%",null,null,{"$f":"SUMIF(D15:D42, \"MRB50%\", F15:F42)","v":0},null,null,"HOME",null,"HOME LI Total",null,null,{"$f":"SUM(N65:N66)","v":0}]
[null,null,"MRB60%",null,null,{"$f":"SUMIF(D15:D42, \"MRB60%\", F15:F42)","v":0},null,null,null,null,"MR/EO",null,null,{"$f":"SUMIF(B15:B42, \"MR/EO\", F15:F42)","v":0}]
["REVENUE",null,"MRB LI Total",null,null,{"$f":"SUM(F65:F68)","v":0},null,null,null,null,"MR",null,null,{"$f":"SUMIF(B15:B42, \"MR\", F15:F42)","v":0}]
[null,null,"MRBMR",null,null,{"$f":"SUMIF(D15:D42, \"MRBMR\", F15:F42)","v":0},null,null,null,null,"MR Total",null,null,{"$f":"SUM(N68:N69)","v":0}]
["BOND",null,"MRBMR Total",null,null,{"$f":"SUM(F70)","v":0},null,null,null,null,"HOME Total",null,null,{"$f":"SUM(N67,N70)","v":0}]
[null,null,"MRB Total",null,null,{"$f":"SUM(F69,F71)","v":0},null,null,"OTHER",null,"Total OT Units",null,null,{"$f":"SUMIF(E15:E42,\"*\",F15:F42)","v":0}]
[]
[]
[]
["·NOTE:  a minimum of 5% of the total units must be designated for persons with disabilities and an additional 2% of the total units must be designated for the hearing/visually impaired. "]

{"sheet":"Tab 4 Utility Allowance","index":3,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[16,4,16,7],[17,4,17,7],[9,2,9,5],[9,7,9,8],[2,0,2,8],[4,0,4,8],[5,0,5,8],[6,0,6,8],[7,0,7,8],[29,0,29,8],[0,0,0,8],[1,0,1,8],[24,1,24,7],[25,1,25,7],[26,1,26,7],[28,0,28,8],[18,4,18,7],[19,4,19,7],[22,1,22,7],[11,4,11,7],[12,4,12,7],[13,4,13,7],[23,1,23,7],[14,4,14,7],[15,4,15,7]]}
[]
["Utility Allowances"]
["Applicant must provide the information below in conjunction with Section 3.07 of the MUA. This exhibit must clearly indicate which utility costs are included in the estimate. "]
[]
["NOTE:"]
["If more than one entity (Sec. 8 administrator, public housing authority) is responsible for setting the utility allowance(s) in the area of the development location, then the selected utility allowance must be the one which most closely reflects the actual expenses."]
["If an independent utility cost evaluation is conducted it must include confirming documentation from all the relevant utility providers."]
["If other reductions to the tenant rent is required such as the cost of flood insurance for the tenant's contents, documentation for these reductions to gross rent should also be attached."]
[]
[null,"Development Name: ",null,null,null,null,"City:",{"$f":"IF('Tab 3 Rent Schedule'!L11=\"\",\"\",'Tab 3 Rent Schedule'!L11)","v":""}]
[]
["Utility(1)",null,"Energy Source (2)",null,"Source of Utility Allowance",null,null,null,"Effective Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Other (Describe)"]
[]
[]
[]
[]
[]
[]
["(1) Check the box if the TENANT will have to pay for this utility directly or will have to pay an extra fee for the appliances listed."]
["(2) Indicate the type of energy source used where applicable as follows: N= Natural Gas, P= Propane, E= Electric, L= Oil, O= Other  "]

{"sheet":"Tab 5 Current Operating Budget","index":4,"n_rows":60,"n_cols":12,"rows_kept":60,"cut":false,"hidden":false,"merged":[[2,3,2,6],[41,3,41,6],[29,0,29,9],[49,3,49,6],[0,0,0,11],[38,6,38,9],[12,3,12,6],[18,3,18,6],[27,3,27,6],[34,3,34,6],[2,9,2,11]]}
["CURRENT OPERATING BUDGET"]
[]
[null,null,"Development Name: ",{"$f":"IF('Tab 3 Rent Schedule'!C4=\"\",\"\",'Tab 3 Rent Schedule'!C4)","v":""},null,null,null,null,"City:",{"$f":"IF('Tab 3 Rent Schedule'!L4=\"\",\"\",'Tab 3 Rent Schedule'!L4)","v":""}]
[]
[" Annual Operating Expenses"]
["General & Administrative Expenses"]
[null,"Accounting ",null,null,null,null,null,"$"]
[null,"Advertising",null,null,null,null,null,"$"]
[null,"Legal fees",null,null,null,null,null,"$"]
[null,"Leased equipment",null,null,null,null,null,"$"]
[null,"Postage & office supplies ",null,null,null,null,null,"$"]
[null,"Telephone",null,null,null,null,null,"$"]
[null,"Other",null,{"$f":"IF(J13>0,\"PLEASE DESCRIBE\",\"Describe\")","v":"Describe"},null,null,null,"$"]
[null,"Total General & Administrative Expenses:",null,null,null,null,null,null,null,null,null,{"$f":"SUM(J7:J13)","v":0}]
["Management Fee:",null,null,null,null,null,null,null,"Percent of Effective Gross Income:",{"$f":"IF(L15=0,0,L15/'Tab 3 Rent Schedule'!N52)","v":0}]
["Payroll, Payroll Tax & Employee Benefits"]
[null,"Management",null,null,null,null,null,"$"]
[null,"Maintenance",null,null,null,null,null,"$"]
[null,"Other ",null,{"$f":"IF(J19>0,\"PLEASE DESCRIBE\",\"Describe\")","v":"Describe"},null,null,null,"$"]
["Total Payroll, Payroll Tax & Employee Benefits:",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J17:J19)","v":0}]
["Repairs & Maintenance"]
[null,"Elevator",null,null,null,null,null,"$"]
[null,"Exterminating",null,null,null,null,null,"$"]
[null,"Grounds",null,null,null,null,null,"$"]
[null,"Make-ready",null,null,null,null,null,"$"]
[null,"Repairs",null,null,null,null,null,"$"]
[null,"Pool",null,null,null,null,null,"$"]
[null,"Other ",null,{"$f":"IF(J28>0,\"PLEASE DESCRIBE\",\"Describe\")","v":"Describe"},null,null,null,"$"]
["Total Repairs & Maintenance:",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J22:J28)","v":0}]
["Utilities (Enter development owner expense)"]
[null,"Electric",null,null,null,null,null,"$"]
[null,"Natural gas",null,null,null,null,null,"$"]
[null,"Trash",null,null,null,null,null,"$"]
[null,"Water & sewer",null,null,null,null,null,"$"]
[null,"Other",null,{"$f":"IF(J35>0,\"PLEASE DESCRIBE\",\"Describe\")","v":"Describe"},null,null,null,"$"]
["Total Utilities:",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J31:J35)","v":0}]
["Annual Property Insurance:",null,null,null,null,null,"Rate per net rentable square foot:","$",null,{"$f":"IF(L37=0,0,L37/'Tab 3 Rent Schedule'!J43)","v":0}]
["Property Taxes:"]
[null,"Published Capitalization Rate:",null,null,null,"Source:"]
[null,"Annual Property Taxes:",null,null,null,null,null,"$"]
[null,"Payments in Lieu of Taxes:",null,null,null,null,null,"$"]
[null,"Other Taxes",null,{"$f":"IF(J42>0,\"PLEASE DESCRIBE\",\"Describe\")","v":"Describe"},null,null,null,"$"]
["Total Property Taxes:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J41=0,J40+J42,J41+J42)","v":0}]
["Reserve for Replacements:",null,null,null,null,null,"Annual reserves per unit:","$",null,null,null,{"$f":"IF(J44=0,0,J44*'Tab 3 Rent Schedule'!F43)","v":0}]
["Other Expenses"]
[null,"Cable TV",null,null,null,null,null,"$"]
[null,"Supportive service contract fees",null,null,null,null,null,"$"]
[null,"TDHCA Compliance fees",null,null,null,null,null,"$"]
[null,"Security",null,null,null,null,null,"$"]
[null,"Other",null,{"$f":"IF(J50>0,\"PLEASE DESCRIBE\",\"Describe\")","v":"Describe"},null,null,null,"$"]
[null,"Total Other Expenses:",null,null,null,null,null,null,null,null,null,{"$f":"SUM(J46:J50)","v":0}]
["TOTAL ANNUAL EXPENSES",null,null,null,null,null,"Expense per unit:","$",null,{"$f":"IF(L52=0,0,L52/'Tab 3 Rent Schedule'!F43)","v":0},null,{"$f":"SUM(L14:L51)","v":0}]
[null,null,null,null,null,null,"Expense to Income Ratio:",null,null,{"$f":"IF(L52=0,0%,L52/'Tab 3 Rent Schedule'!N52)","v":0}]
["NET OPERATING INCOME (before debt service)",null,null,null,null,null,null,null,null,null,null,{"$f":"'Tab 3 Rent Schedule'!N52-L52","v":0}]
["Annual Debt Service"]
[null,"Describe Source",null,null,null,null,null,"$"]
[null,"Describe Source",null,null,null,null,null,"$"]
[null,"Describe Source",null,null,null,null,null,"$"]
["TOTAL ANNUAL DEBT SERVICE",null,null,null,null,null,"Debt Coverage Ratio:",null,null,{"$f":"IF(L59=0,0,L54/L59)","v":0},null,{"$f":"SUM(J56:J58)","v":0}]
["NET CASH FLOW ",null,null,null,null,null,null,null,null,null,null,{"$f":"L54-L59","v":0}]

{"sheet":"Tab 6 Thirty Year Proforma","index":5,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,1,4,6],[4,8,4,11],[0,0,0,11],[1,0,1,11],[2,0,2,11]]}
[]
["30 Year Rental Housing Operating Proforma"]
["The pro forma should be based on the operating income and expense information for the base year (first year of stabilized occupancy using today’s best estimates of rental income and expenses), and principal and interest debt service.   The GLO currently considers an annual growth rate of 2% for income and 3% for expenses to be reasonably conservative estimates. Written explanation for any deviations from these growth rates or for assumptions other than straight-line growth made during the proforma period should be attached to this exhibit.. While the 30-year proforma projects 30 years of data, the standard for financial feasibility is 15 years."]
[]
["Development Name: ",null,null,null,null,null,null,"City:",{"$f":"'Tab 3 Rent Schedule'!L11","v":0}]
[]
["INCOME","LEASE-UP","YEAR 1","YEAR 2","YEAR 3","YEAR 4","YEAR 5","YEAR 10","YEAR 15","YEAR 20","YEAR 25","YEAR 30"]
["POTENTIAL GROSS ANNUAL RENTAL INCOME ",null,{"$f":"'Tab 3 Rent Schedule'!N43*12","v":0},{"$f":"C8*1.02","v":0},0,0,0,{"$f":"G8*1.02^5","v":0},0,0,0,0]
["Secondary Income",null,{"$f":"'Tab 3 Rent Schedule'!N47*12","v":0},0,0,0,0,0,0,0,0,0]
["POTENTIAL GROSS ANNUAL INCOME",{"$f":"B8+B9","v":0},{"$f":"C8+C9","v":0},0,0,0,0,0,0,0,0,0]
["Provision for Vacancy & Collection Loss",null,{"$f":"'Tab 3 Rent Schedule'!N49*12","v":0},{"$f":"C11*1.02","v":0},{"$f":"D11*1.02","v":0},{"$f":"E11*1.02","v":0},{"$f":"F11*1.02","v":0},{"$f":"G11*1.02^5","v":0},{"$f":"H11*1.02^5","v":0},{"$f":"I11*1.02^5","v":0},{"$f":"J11*1.02^5","v":0},{"$f":"K11*1.02^5","v":0}]
["Rental Conessions",null,{"$f":"'Tab 3 Rent Schedule'!N50*12","v":0}]
["EFFECTIVE GROSS ANNUAL INCOME",{"$f":"B10+B11","v":0},{"$f":"C10-C11-C12","v":0},{"$f":"D10-D11-D12","v":0},0,0,0,0,0,0,0,0]
["EXPENSES"]
["General & Administrative Expenses",null,{"$f":"'Tab 5 Current Operating Budget'!L14","v":0},{"$f":"C15*1.03","v":0},0,0,0,{"$f":"G15*1.03^5","v":0},0,0,0,0]
["Management Fee",null,{"$f":"'Tab 5 Current Operating Budget'!L15","v":0},0,0,0,0,0,0,0,0,0]
["Payroll, Payroll Tax & Employee Benefits",null,{"$f":"'Tab 5 Current Operating Budget'!L20","v":0},0,0,0,0,0,0,0,0,0]
["Repairs & Maintenance",null,{"$f":"'Tab 5 Current Operating Budget'!L29","v":0},0,0,0,0,0,0,0,0,0]
["Electric & Gas Utilities ",null,{"$f":"'Tab 5 Current Operating Budget'!J31+'Tab 5 Current Operating Budget'!J32+'Tab 5 Current Operating Budget'!J35","v":0},0,0,0,0,0,0,0,0,0]
["Water, Sewer & Trash Utilities",null,{"$f":"'Tab 5 Current Operating Budget'!J33+'Tab 5 Current Operating Budget'!J34","v":0},0,0,0,0,0,0,0,0,0]
["Annual Property Insurance Premiums",null,{"$f":"'Tab 5 Current Operating Budget'!L37","v":0},0,0,0,0,0,0,0,0,0]
["Property Tax",null,{"$f":"'Tab 5 Current Operating Budget'!L43","v":0},0,0,0,0,0,0,0,0,0]
["Reserve for Replacements",null,{"$f":"'Tab 5 Current Operating Budget'!L44","v":0},0,0,0,0,0,0,0,0,0]
["Other Expenses:",null,{"$f":"'Tab 5 Current Operating Budget'!L51","v":0},0,0,0,0,0,0,0,0,0]
["TOTAL ANNUAL EXPENSES",{"$f":"SUM(B15:B24)","v":0},0,0,0,0,0,0,0,0,0,0]
["NET OPERATING INCOME",{"$f":"B13-B25","v":0},{"$f":"C13-C25","v":0},0,0,0,0,0,0,0,0,0]
["DEBT SERVICE"]
["First Deed of Trust Annual Loan Payment"]
["Second Deed of Trust Annual Loan Payment"]
["Third Deed of Trust Annual Loan Payment"]
["Other Annual Required Payment:"]
["NET CASH FLOW",{"$f":"B26-SUM(B28:B31)","v":0},{"$f":"C26-SUM(C28:C31)","v":0},{"$f":"D26-SUM(D28:D31)","v":0},{"$f":"E26-SUM(E28:E31)","v":0},0,0,0,0,0,{"$f":"K26-SUM(K28:K31)","v":0},{"$f":"L26-SUM(L28:L31)","v":0}]
["Debt Coverage Ratio",{"$f":"B26/SUM(B28:B31)","v":{"$error":"#DIV/0!"}},{"$f":"C26/SUM(C28:C31)","v":{"$error":"#DIV/0!"}},{"$f":"D26/SUM(D28:D31)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"G26/SUM(G28:G31)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"K26/SUM(K28:K31)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]

{"sheet":"Tab 7 BuildingUnitConfiguration","index":6,"n_rows":39,"n_cols":27,"rows_kept":39,"cut":false,"hidden":false,"merged":[[9,0,9,3],[9,25,10,25],[9,26,10,26],[9,5,10,24],[0,0,0,26],[1,0,1,26],[2,0,2,26],[6,4,6,24],[6,25,7,25],[4,3,4,7],[4,9,4,26]]}
[]
["Building/Unit Type Configuration (Required for All Rental Developments)"]
["Unit types should be entered from smallest to largest based on \"# of Bedrooms\" and \"Sq. Ft. Per Unit.\"  \"Unit Label\" should correspond to the unit label or name used on the unit floor plan.  \"Building Label\" should conform to the building label or name on the building floor plan.  The total number of units per unit type and totals for \"Total # of Units\" and \"Total Sq Ft. for Unit Type\" should match the rent schedule and site plan.  If additional building types are needed, they are available by unhiding the columns between J and Z in Excel. "]
[]
[null,null,"Development Name: ",{"$f":"IF('Tab 3 Rent Schedule'!C11=\"\",\"\",'Tab 3 Rent Schedule'!C11)","v":""},null,null,null,null,"City:",{"$f":"IF('Tab 3 Rent Schedule'!L11=\"\",\"\",'Tab 3 Rent Schedule'!L11)","v":""}]
[]
[null,null,null,null,"Building Configuration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total # of Buildings"]
[null,null,null,null,"Building Label"]
[null,null,null,null,"Number of Buildings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F9:Y9)","v":0}]
["Unit Type",null,null,null,null,"Number of Units Per Building",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total # of Units","Total Sq Ft for Unit Type"]
["Unit Label","# of Bedrooms","# of Baths","Sq. Ft. Per Unit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(F12*F$9+G12*G$9+H12*H$9+I12*I$9+J12*J$9+K12*K$9+L12*L$9+M12*M$9+N12*N$9+O12*O$9+P12*P$9+Q12*Q$9+R12*R$9+S12*S$9+T12*T$9+U12*U$9+V12*V$9+W12*W$9+X12*X$9+Y12*Y$9)","v":0},{"$f":"Z12*D12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(F13*F$9+G13*G$9+H13*H$9+I13*I$9+J13*J$9+K13*K$9+L13*L$9+M13*M$9+N13*N$9+O13*O$9+P13*P$9+Q13*Q$9+R13*R$9+S13*S$9+T13*T$9+U13*U$9+V13*V$9+W13*W$9+X13*X$9+Y13*Y$9)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Z26*D26","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,"Totals",{"$f":"SUM(F12:F31)*F9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Z12:Z31)","v":0},{"$f":"SUM(AA12:AA31)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Rentable Square Footage from Rent Schedule",{"$f":"'Tab 3 Rent Schedule'!J43","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(AA32=AA34),\"If the net rentable square footage from the rent schedule and the net rentable square footage from this exhibit do not match, please check the unit square feet or the number of each unit type for consistency.\",\"\")","v":""}]
["Interior Corridors (for elevator served elderly or SRO or high-rise buildings)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(F37*F$9+G37*G$9+H37*H$9+I37*I$9+J37*J$9+K37*K$9+L37*L$9+M37*M$9+N37*N$9+O37*O$9+P37*P$9+Q37*Q$9+R37*R$9+S37*S$9+T37*T$9+U37*U$9+V37*V$9+W37*W$9+X37*X$9+Y37*Y$9)","v":0}]
["Common Area (for Single Room Occupancy buildings [see QAP §49.9(i)(8)])",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(F38*F$9+G38*G$9+H38*H$9+I38*I$9+J38*J$9+K38*K$9+L38*L$9+M38*M$9+N38*N$9+O38*O$9+P38*P$9+Q38*Q$9+R38*R$9+S38*S$9+T38*T$9+U38*U$9+V38*V$9+W38*W$9+X38*X$9+Y38*Y$9)","v":0}]
[null,null,null,null,"Totals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AA32+SUM(AA37:AA38)","v":0}]

{"sheet":"Tab 8 CDBG Budget","index":7,"n_rows":100,"n_cols":7,"rows_kept":100,"cut":false,"hidden":false,"merged":[[0,0,0,6],[5,6,7,6],[9,6,19,6],[22,3,40,3],[22,6,41,6],[44,6,47,6],[73,3,84,3],[73,6,85,6],[88,6,92,6],[48,0,48,1],[51,3,57,3],[51,6,57,6],[59,3,66,3],[59,6,66,6],[68,3,71,3],[68,6,71,6]]}
["CDBG BUDGET"]
[null,null,null,null,"Contract #"]
[]
[null,null,"Final Budget","CDBG Budget","Requested Funds"]
["ACQUISITION",null,null,null," (plus retainage)",null,"Comments"]
["Acquisition Contract Price",null,null,null,0]
["Acquisition Closing/Legal/Other",null,null,null,0]
["Total Acquisition",null,{"$f":"+SUM(C6:C7)","v":0},{"$f":"+SUM(D6:D7)","v":0},0]
[{"$f":"IF(D8>C8,\"HOME BUDGETED AMOUNT EXCEEDS TOTAL BUDGETED AMOUNT\",\"\")","v":""},null,null,{"$f":"IF(E8>D8,\"REQUESTED FUNDS EXCEEDS HOME BUDGETED AMOUNT\",\"\")","v":""}]
["OFF-SITES"]
["SITE WORK",null,null,null,0]
["DIRECT CONSTRUCTION COSTS",null,null,null,0]
["OTHER CONSTRUCTION COSTS",null,null,null,0]
["Contractor General requirements (<6%)",null,null,null,0]
["Contractor overhead (<2%)",null,null,null,0]
["Contractor profit (<6%)",null,null,null,0]
["Total Contractor Fee Budgeted",null,0,0,0]
[{"$f":"+CONCATENATE(\"Total Contractor Fee Limit: \",DOLLAR(SUM(C10:C13)*0.14,))","v":"Total Contractor Fee Limit: $0"}]
["Contingency (<5%)"]
["TOTAL DIRECT HARD COSTS",null,{"$f":"+SUM(C10:C19)-C17","v":0},{"$f":"+SUM(D10:D19)-D17","v":0},0]
[{"$f":"IF(D20>C20,\"HOME BUDGETED AMOUNT EXCEEDS TOTAL BUDGETED AMOUNT\",\"\")","v":""},null,null,{"$f":"IF(E20>D20,\"REQUESTED FUNDS EXCEEDS HOME BUDGETED AMOUNT\",\"\")","v":""}]
["INDIRECT/SOFT CONSTRUCTION COSTS"]
["Architectural - Design fees",null,null,null,0]
["Architectural - Supervision fees",null,null,null,0]
["Engineering fees",null,null,null,0]
["Real estate attorney/other legal fees",null,null,null,0]
["Accounting fees",null,null,null,0]
["Impact Fees",null,null,null,0]
["Building permits & related costs",null,null,null,0]
["Appraisal",null,null,null,0]
["Market analysis",null,null,null,0]
["Environmental assessment",null,null,null,0]
["Soils report ",null,null,null,0]
["Survey",null,null,null,0]
["Marketing ",null,null,null,0]
["Course of construction insurance",null,null,null,0]
["Hazard & liability insurance",null,null,null,0]
["Real property taxes"]
["Personal property taxes"]
["Tenant relocation expenses",null,null,null,0]
["Other Indirect/Soft Costs",null,null,null,0]
["Subtotal Indirect Const. Cost",null,{"$f":"+SUM(C23:C41)","v":0},null,0]
[{"$f":"+IF(D42>C42-C39-C38,\"HOME BUDGETED AMOUNT EXCEEDS ELIGIBLE BUDGETED COSTS\",\"\")","v":""},null,null,{"$f":"IF(E42>D42,\"REQUESTED FUNDS EXCEEDS HOME BUDGETED AMOUNT\",\"\")","v":""}]
["DEVELOPER FEES"]
["Housing consultant fees",null,null,null,0]
["Developer fee- General & Administrative",null,null,null,0]
["Developer fee- Profit or fee",null,null,null,0]
["Subtotal Developer's Fees",null,{"$f":"+SUM(C45:C47)","v":0},{"$f":"+SUM(D45:D47)","v":0},0]
["   MAX DEVELOPER FEE FROM REA REPORT",null,null,{"$f":"IF(E48>D48,\"REQUESTED FUNDS EXCEEDS HOME BUDGETED AMOUNT\",\"\")","v":""}]
["FINANCING COSTS:",null,{"$f":"IF(D48>C48,\"HOME BUDGETED AMOUNT EXCEEDS TOTAL BUDGETED AMOUNT\",\"\")","v":""}]
["CONSTRUCTION LOAN(S)"]
["Construction Loan Interest",null,null,null,0]
["Construction Loan origination fees",null,null,null,0]
["Construction Loan Title & recording fees",null,null,null,0]
["Construction Loan Closing costs & legal fees",null,null,null,0]
["Construction Loan - Inspection fees",null,null,null,0]
["Construction Loan - Credit Report",null,null,null,0]
["Construction Loan - Discount Points",null,null,null,0]
["PERMANENT LOAN(S)"]
["Permanent Loan Origination fees",null,null,null,0]
["Permanent Loan Title & recording fees",null,null,null,0]
["Permanent Loan Closing costs & legal",null,null,null,0]
["Permanent Loan Bond premium",null,null,null,0]
["Permanent Loan Credit report",null,null,null,0]
["Permanent Loan Discount points",null,null,null,0]
["Permanent Loan Credit enhancement fees",null,null,null,0]
["Permanent Loan Prepaid MIP",null,null,null,0]
["BRIDGE LOAN(S)"]
["Bridge Loan Interest",null,null,null,0]
["Bridge Loan Origination fees",null,null,null,0]
["Bridge Loan Title & recording fees",null,null,null,0]
["Bridge Loan Closing costs & legal fees",null,null,null,0]
["OTHER FINANCING COSTS"]
["Other Financing - Tax credit fees",null,null,null,0]
["Other Financing - Tax and/or bond counsel",null,null,null,0]
["Other Financing - Payment bonds",null,null,null,0]
["Other Financing - Performance bonds",null,null,null,0]
["Other Financing - Credit enhancement fees",null,null,null,0]
["Other Financing - Mortgage insurance premiums",null,null,null,0]
["Other Financing - Cost of underwriting & issuance",null,null,null,0]
["Other Financing - Syndication organizational cost",null,null,null,0]
["Other Financing - Tax opinion",null,null,null,0]
["Other Financing - Contractor Guarantee Fee",null,null,null,0]
["Other Financing - Developer Guarantee Fee",null,null,null,0]
["Other Financing Costs",null,null,null,0]
["Subtotal Financing Cost",null,{"$f":"+SUM(C52:C85)","v":0},null,0]
[{"$f":"IF(D86>C86,\"HOME BUDGETED AMOUNT EXCEEDS TOTAL BUDGETED AMOUNT\",\"\")","v":""},null,null,{"$f":"IF(E86>D86,\"REQUESTED FUNDS EXCEEDS HOME BUDGETED AMOUNT\",\"\")","v":""}]
["RESERVES",null,{"$f":"+IF(D90>0,\"PLEASE DISCUSS WITH YOUR PERFORMANCE SPECIALIST PRIOR TO BUDGETING HOME FUNDS FOR RESERVES\",\"\")","v":""}]
["Rent-up"]
["Operating",null,null,null,0]
["Replacement "]
["Escrows"]
["Subtotal Reserves",null,{"$f":"+SUM(C89:C92)","v":0},{"$f":"+SUM(D89:D92)","v":0},0]
[{"$f":"IF(D93>C93,\"HOME BUDGETED AMOUNT EXCEEDS TOTAL BUDGETED AMOUNT\",\"\")","v":""},null,null,{"$f":"IF(E93>D93,\"REQUESTED FUNDS EXCEEDS HOME BUDGETED AMOUNT\",\"\")","v":""}]
["TOTAL CDBG BUDGET",null,null,{"$f":"+SUM(D93,D86,D48,D42,D20,D8)","v":0},null,null,{"$f":"+IF(D95>'[1]Final Sources of Funds'!E9,\"DOES NOT MATCH THE FINAL SOURCES OF FUNDS EXHIBIT\",\"\")","v":""}]
["CDBG FUNDS DRAWN/REQUESTED TO DATE",null,null,null,0,null,{"$f":"+IF(E96>D95,\"REQUESTED MORE FUNDS THAN AVAILABLE\",\"\")","v":""}]
[]
["TOTAL HOUSING DEVELOPMENT COSTS",null,{"$f":"+C8+C20+C42+C48+C93+C86","v":0}]
["- Commercial Space Costs"]
["TOTAL RESIDENTIAL DEVELOPMENT COSTS",null,{"$f":"+C98-C99","v":0}]

{"sheet":"Tab 9 Summary Sources and Uses","index":8,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[29,0,29,5],[5,2,5,5],[1,0,1,5],[0,0,0,5],[26,0,26,5],[2,0,2,5],[3,0,3,5]]}
[]
["Summary Sources and Uses of Funds"]
["Describe all sources of funds and total uses of funds. Information must be consistent with the information provided throughout the Application (i.e. Financing Participants and Development Cost Schedule forms). Where funds such as tax credits, loan guarantees, bonds are used, only the proceeds going into the development should be identified so that \"sources\" match \"uses.\""]
["2 Applicants must attach a written narrative to this form that describes the financing plan for the Development. The narrative shall include: (a) any non-traditional financing arrangements; (b) the use of funds with respect to the Development; (c) the funding sources for the Development including construction, permanent and bridge loans, rents, operating subsidies, and replacement reserves; and (d) the commitment status of the funding sources"]
[]
[null,"Development Name: "]
[]
["Source #","Funding Description","Priority of Lien","Construction or Rehab. Loan Stage Amt.","Permanent Loan Stage Amount","Financing Participants"]
[1,"Conventional Loan"]
[2,"Conventional Loan/FHA "]
[3,"Conventional Loan/Letter of Credit"]
[4,"HOME"]
[5,"Housing Trust Fund"]
[6,"CDBG"]
[7,"Mortgage Revenue Bonds"]
[8,"HTC Syndication Proceeds "]
[9,"Historic Tax Credit Syndication Proceeds "]
[10,"USDA/ TXRD Loan(s) "]
[11,"Other Federal Loan or Grant "]
[12,"Other State Loan or Grant "]
[13,"Local Government Loan or Grant"]
[14,"Private Loan or Grant"]
[15,"Cash Equity"]
[16,"In-Kind Equity/Deferred Developer Fee"]
["TOTAL SOURCES OF FUNDS",null,null,{"$f":"SUM(D9:D24)","v":0},{"$f":"SUM(E9:E24)","v":0}]
["TOTAL USES OF FUNDS",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["(1) Indicate Exclusive Use Financing Paticipant only where funds from that source are dedicated only for a specific purpose, i.e. CDBG infrustructure funds used only for off-site construction"]