{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Application Instructions","Funding - WITH Rent Subsidy","Funding - W.O. Rent Subsidy","D.1 Acq Predev Financing","D.2 Sources","D.3 Development Budget w Notes","D.4 Operating Budget w Notes","D.5 Unit Mix, Rents, Subsidy","D.6 20-Year Cash Flow","D.7.a. 9% Threshold Basis Limit","D.7.b. 9% Tax Credit Calc","4% Tiebreaker","D.8.a. 4% TC Threshold Basis","D.8.b. 4% Tax Credit Calc","4% TieBreak - HIDE","drop down menus","I.16 Sust. Bldg. Methods ","I.16a Hlthy. Design Elem. "],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":260,"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":"Application Instructions","index":0,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,0,12,7],[10,1,10,7],[0,1,0,7],[2,1,2,7],[6,1,6,7],[1,1,1,7],[4,3,4,7],[4,1,4,2]]}
[]
[null,"NOTICE OF FUNDING AVAILABILITY - UNOFA APPLICATION",null,null,null,null,null,null,"Rev. 5.15.2026"]
[null,"FINANCIAL PROFORMA"]
[]
[null,"PROJECT NAME: "]
[null,"Introduction:"]
[null,"This Financial UNOFA Proforma accompanies the Notice of Funding Availability, Round 32 (NOFA 32) Guidelines released by the Los Angeles County Development Authority (LACDA). Supporting information is found in the NOFA Guidelines and Supplemental Documents. Please consult the NOFA and other referenced documents for eligibility criteria and program guidelines. The NOFA 32 Guidelines and the application is for multifamily affordable rental housing projects serving identified qualified populations only.  \n\nPlease note that there are separate Funding Eligibility tabs for Projects Supported by Rental Subsidy (from the LACDA or any other local or federal issuer) and Projects without Rental Subsidy - utilize the tab applicable to the subject Project."]
[]
[null,"Instructions:"]
[]
[null,"1. Once the UNOFA proforma in Excel is completed, make sure to save the document on your computer by using the project's short name as its file name.\n\n2. Applicants must upload the completed proforma and any associated supporting documents and/or completed forms to the \"Financial Proforma\" tab of the UNOFA online application website (https://www.unofa.org/#/homepage). Upload the completed file that you have saved on your computer as one Excel file, with all information completed.  \n\n3. Download, complete, and upload the Proforma in the Supporting Documents Sections of the UNOFA application.\n\n4. Make sure to click \"Save\" on the online application page to save your proforma and any changes to your online application."]
[]
["END OF WORKSHEET"]

{"sheet":"Funding - WITH Rent Subsidy","index":1,"n_rows":59,"n_cols":11,"rows_kept":59,"cut":false,"hidden":false,"merged":[[58,0,58,7],[44,1,45,1],[44,2,44,5],[49,1,50,1],[49,2,49,5],[53,2,53,3],[54,2,54,3],[28,3,28,6],[36,2,36,3],[39,1,41,1],[39,2,39,5],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[22,1,22,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[17,1,17,2],[19,1,19,2],[20,1,20,2],[8,1,8,2],[3,1,3,7],[4,1,4,6],[6,3,7,3],[6,4,7,4],[6,5,6,6]]}
[]
[null,"Eligible Population / Funding Source - Projects Supported by a Rental Subsidy",null,null,null,null,{"$f":"IF('Application Instructions'!D5<>\"\",'Application Instructions'!D5,\"\")","v":""}]
[]
[null,"For the purpose of funding eligibility, indicate the number of units by primary target population and funding source. Do not double count. "]
[null,"GUIDANCE FOR PROJECTS SUPPORTED BY A RENTAL SUBSIDY:  At least 20% of Project units (excluding the manager's unit) must be set aside for eligible Special Needs populations earning no more than 30% of the Area Median Income (\"AMI\").  \n\nSpecial Needs Units are eligible for AHTF Assistance from the LACDA; General Affordable Units are not eligible for AHTF Assistance from the LACDA. \n\nThis guidance applies to Projects supported by a Rental Subsidy from the LACDA or any other local or federal issuer. Projects WITHOUT Rental Subsidy should utilize the tab labeled \"Funding -  W.O. Rent Subsidy.\""]
[]
[null,null,null,"\n\nTotal Units \n(Assisted and Unassisted)\n","\n\nLACDA\nAHTF Assisted Units\n","\n\nLACDA Rental Subsidy \n(PBVs or PBVASH, as applicable)",null,null,"Percent of Total","Percent of Total excluding Mgr Unit","Percent of Total excluding Mgr and Mkt Rate units"]
[null,null,null,null,null,"PBV","PBVASH"]
[null,"General Affordable Units"]
[null,"Family",null,null,null,null,null,null,{"$f":"IFERROR(D10/$D$29,\" \")","v":" "},{"$f":"IFERROR(D10/($D$29-$D$26),\" \")","v":" "},{"$f":"IFERROR(D10/($D$29-$D$28),\" \")","v":" "}]
[null,"Senior",null,null,null,null,null,null,{"$f":"IFERROR(D11/$D$29,\" \")","v":" "},{"$f":"IFERROR(D11/($D$29-$D$26),\" \")","v":" "},{"$f":"IFERROR(D11/($D$29-$D$28),\" \")","v":" "}]
[null,"Total General Affordable (Non-Special Needs) Units",null,{"$f":"D10+D11","v":0},null,null,null,null,{"$f":"IFERROR(D12/$D$29,\" \")","v":" "},{"$f":"IFERROR(D12/($D$29-$D$26),\" \")","v":" "},{"$f":"IFERROR(D12/($D$29-$D$28),\" \")","v":" "}]
[null,"Special Needs Units"]
[null,"Homeless ",null,null,null,null,null,null,{"$f":"IFERROR(D14/$D$29,\" \")","v":" "},{"$f":"IFERROR(D14/($D$29-$D$26),\" \")","v":" "},{"$f":"IFERROR(D14/($D$29-$D$28),\" \")","v":" "}]
[null,"Homeless Seniors",null,null,null,null,null,null," "," "," "]
[null,"Chronically Homeless ",null,null,null,null,null,null," "," "," "]
[null,"Homeless Veterans",null,null,null,null,null,null," "," "," "]
[null,"Homeless Persons Living with Mental Illness",null,null,null,null,null,null," "," "," "]
[null,"Homeless Transition Age Youth (TAY)",null,null,null,null,null,null," "," "," "]
[null,"Persons Living with HIV / AIDS",null,null,null,null,null,null," "," "," "]
[null,"People with Intellectual/Developmental Disabilities",null,null,null,null,null,null," "," "," "]
[null,"Transition Age Youth (TAY) (At-Risk of Homelessness)",null,null,null,null,null,null,{"$f":"IFERROR(D22/$D$29,\" \")","v":" "},{"$f":"IFERROR(D22/($D$29-$D$26),\" \")","v":" "},{"$f":"IFERROR(D22/($D$29-$D$28),\" \")","v":" "}]
[null,"Survivors of Domestic Violence/Human Trafficking/Sexual Assault",null,null,null,null,null,null,{"$f":"IFERROR(D23/$D$29,\" \")","v":" "},{"$f":"IFERROR(D23/($D$29-$D$26),\" \")","v":" "},{"$f":"IFERROR(D23/($D$29-$D$28),\" \")","v":" "}]
[null,"Total Special Needs Affordable Units",null,{"$f":"SUM(D14:D23)","v":0},{"$f":"SUM(E14:E23)","v":0},{"$f":"SUM(F18:F23,F14:F16)","v":0},{"$f":"G17","v":0},null,{"$f":"IFERROR(D24/$D$29,\" \")","v":" "},{"$f":"IFERROR(D24/($D$29-$D$26),\" \")","v":" "},{"$f":"IFERROR(D24/($D$29-$D$28),\" \")","v":" "}]
[null,"Other Units"]
[null,"Manager",null,null,null,null,null,null,{"$f":"IFERROR(D26/$D$29,\" \")","v":" "},"-","-"]
[null,"Market Rate",null,null,null,null,null,null,{"$f":"IFERROR(D27/$D$29,\" \")","v":" "},{"$f":"IFERROR(D27/($D$29-$D$26),\" \")","v":" "},"-"]
[null,"Total Other Units",null,{"$f":"D26+D27","v":0},null,null,null,null,{"$f":"IFERROR(D28/$D$29,\" \")","v":" "},{"$f":"IFERROR(D27/($D$29-$D$26),\" \")","v":" "},"-"]
[null,"TOTAL PROJECT UNITS",null,{"$f":"SUM(D12+D24+D28)","v":0},null,null,null,null,{"$f":"SUM(I12,I24,I28)","v":0},{"$f":"SUM(J12,J24,J28)","v":0},{"$f":"SUM(K12,K24,K28)","v":0}]
[null,null,null,{"$f":"IF(D29=('D.5 Unit Mix, Rents, Subsidy'!D63),\"ok\",\"ERROR: Does Not Match Total in Tab D.5 cell D63 total units\")","v":"ok"}]
[]
[null,"Percentage of total units reserved for Special Needs households:",null,{"$f":"J24","v":" "}]
[null,{"$f":"IF(D32<0.2,\"ERROR: if requesting Capital and PBVs, then a minimum of 20% of total units (excluding the manager's unit) must be reserved for a qualifying SN population\",\"\")","v":""}]
[]
[null,"Maximum Potential Subsidy"]
[]
[null,"Maximum Potential AHTF Subsidy",{"$f":"12000000","v":12000000}]
[]
[]
[null,"Capital Fund Per-Unit Subsidy Limits","Number of Bedrooms"]
[null,null,"Studio",1,2,3]
[null,null,180000,190000,200000,210000]
[]
[]
[null,"Assisted Units by Type & Funding","Number of Bedrooms"]
[null,null,"Studio",1,2,3,"Total"]
[null,"AHTF - Assisted",null,null,null,null,{"$f":"SUM(C47:F47)","v":0},{"$f":"IF(G47=(E12+E24),\"ok\",\"ERROR: unit count doesn't match AHTF request shown in table above\")","v":"ok"}]
[]
[]
[null,"Calculated Subsidy","Number of Bedrooms"]
[null,null,"Studio",1,2,3,"Total"]
[null,"AHTF Assisted Only",{"$f":"C47*C$42","v":0},{"$f":"D47*D$42","v":0},{"$f":"E47*E$42","v":0},{"$f":"F47*F$42","v":0},{"$f":"SUM(C52:F52)","v":0},{"$f":"IF(G52>C37,\"NOTE: total exceeds maximum subsidy per project; reduced to maximum below\",\"\")","v":""}]
[]
[null,"Maximum Subsidy",{"$f":"MIN(G52,C37)","v":0}]
[null,"Request  per Assisted Unit",{"$f":"IF(G47<>0,C54/G47,0)","v":0}]
[]
[]
[]
["END OF WORKSHEET"]

{"sheet":"Funding - W.O. Rent Subsidy","index":2,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":false,"merged":[[54,0,54,7],[23,1,23,2],[32,2,32,3],[40,2,40,5],[35,2,35,5],[23,3,23,4],[3,1,3,7],[8,1,8,2],[10,1,10,2],[11,1,11,2],[20,1,20,2],[6,4,7,4],[19,1,19,2],[12,1,12,2],[18,1,18,2],[6,3,7,3],[17,1,17,2],[4,1,4,6],[22,1,22,2],[50,2,50,3],[13,1,13,2],[9,1,9,2],[15,1,15,2],[14,1,14,2],[40,1,41,1],[45,1,46,1],[49,2,49,3],[21,1,21,2],[35,1,37,1],[45,2,45,5]]}
[]
[null,"Eligible Population / Funding Source - Projects WITHOUT Rental Subsidy",null,null,null,null,{"$f":"IF('Application Instructions'!D5<>\"\",'Application Instructions'!D5,\"\")","v":""}]
[]
[null,"For the purpose of funding eligibility, indicate the number of units by primary target population and funding source. Do not double count. "]
[null,"GUIDANCE FOR PROJECTS WITHOUT RENTAL SUBSIDY:  At least 10% of Project units (excluding the manager's unit) must be set aside for Extremely Low-Income (\"ELI\") households (either General Affordable or Non-Homeless Special Needs) earning no more than 30% of the Area Median Income (\"AMI\").  \n\nGeneral Affordable Units up to 80% AMI are eligible for AHTF Assistance from the LACDA (subject to the above restriction for the Minimum 10% ELI Units); Homeless Special Needs units are not eligible for AHTF Assistance from the LACDA.\n\nProjects supported by a Rental Subsidy from the LACDA or any other local or federal issuer should utilize the tab labeled \"Funding - WITH Rent Subsidy.\"\n\nNon-Homeless Special Needs Populations eligible for AHTF Assistance from the LACDA include: Persons Living with HIV/AIDs; People with Intellectual or Developmental Disabilities; Transition Age Youth; and Survivors of Domestic Violence, Human Trafficking or Sexual Assault."]
[]
[null,null,null,"Total Units \n(Assisted and Unassisted)","LACDA\nAHTF Assisted Units",null,null,null,"Percent of Total","Percent of Total excluding Mgr Unit","Percent of Total excluding Mgr and Mkt Rate units"]
[]
[null,"General Affordable Units"]
[null,"Extremely Low-Income (ELI) (up to 30% AMI)",null,null,null,null,null,null,{"$f":"IFERROR(D10/$D$24,\" \")","v":" "},{"$f":"IFERROR(D10/($D$24-$D$21),\" \")","v":" "},{"$f":"IFERROR(D10/($D$24-$D$23),\" \")","v":" "}]
[null,"Family",null,null,null,null,null,null,{"$f":"IFERROR(D11/$D$24,\" \")","v":" "},{"$f":"IFERROR(D11/($D$24-$D$21),\" \")","v":" "},{"$f":"IFERROR(D11/($D$24-$D$23),\" \")","v":" "}]
[null,"Senior",null,null,null,null,null,null,{"$f":"IFERROR(D12/$D$24,\" \")","v":" "},{"$f":"IFERROR(D12/($D$24-$D$21),\" \")","v":" "},{"$f":"IFERROR(D12/($D$24-$D$23),\" \")","v":" "}]
[null,"Total General Affordable (Non-Special Needs) Units",null,{"$f":"D11+D12+D10","v":0},{"$f":"SUM(E10:E12)","v":0},null,null,null,{"$f":"IFERROR(D13/$D$24,\" \")","v":" "},{"$f":"IFERROR(D13/($D$24-$D$21),\" \")","v":" "},{"$f":"IFERROR(D13/($D$24-$D$23),\" \")","v":" "}]
[null,"Non-Homeless Special Needs Units (up to 30% AMI)"]
[null,"Persons Living with HIV / AIDS",null,null,null,null,null,null,{"$f":"IFERROR(D15/$D$24,\" \")","v":" "},{"$f":"IFERROR(D15/($D$24-$D$21),\" \")","v":" "},{"$f":"IFERROR(D15/($D$24-$D$23),\" \")","v":" "}]
[null,"People with Intellectual/Developmental Disabilities",null,null,null,null,null,null," "," "," "]
[null,"Transition Age Youth (TAY)",null,null,null,null,null,null,{"$f":"IFERROR(D17/$D$24,\" \")","v":" "},{"$f":"IFERROR(D17/($D$24-$D$21),\" \")","v":" "},{"$f":"IFERROR(D17/($D$24-$D$23),\" \")","v":" "}]
[null,"Survivors of Domestic Violence/Human Trafficking/Sexual Assault",null,null,null,null,null,null,{"$f":"IFERROR(D18/$D$24,\" \")","v":" "},{"$f":"IFERROR(D18/($D$24-$D$21),\" \")","v":" "},{"$f":"IFERROR(D18/($D$24-$D$23),\" \")","v":" "}]
[null,"Total Non-Homeless Special Needs Affordable Units",null,{"$f":"SUM(D15:D18)","v":0},{"$f":"SUM(E15:E18)","v":0},null,null,null,{"$f":"IFERROR(D19/$D$24,\" \")","v":" "},{"$f":"IFERROR(D19/($D$24-$D$21),\" \")","v":" "},{"$f":"IFERROR(D19/($D$24-$D$23),\" \")","v":" "}]
[null,"Other Units"]
[null,"Manager",null,null,null,null,null,null,{"$f":"IFERROR(D21/$D$24,\" \")","v":" "},"-","-"]
[null,"Market Rate",null,null,null,null,null,null,{"$f":"IFERROR(D22/$D$24,\" \")","v":" "},{"$f":"IFERROR(D22/($D$24-$D$21),\" \")","v":" "},"-"]
[null,"Total Other Units",null,{"$f":"D21+D22","v":0},null,null,null,null,{"$f":"IFERROR(D23/$D$24,\" \")","v":" "},{"$f":"IFERROR(D22/($D$24-$D$21),\" \")","v":" "},"-"]
[null,"TOTAL PROJECT UNITS",null,{"$f":"SUM(D13+D19+D23)","v":0},null,null,null,null,{"$f":"SUM(I13,I19,I23)","v":0},{"$f":"SUM(J13,J19,J23)","v":0},{"$f":"SUM(K13,K19,K23)","v":0}]
[null,null,null,{"$f":"IF(D24=('D.5 Unit Mix, Rents, Subsidy'!D63),\"ok\",\"Error: Does not Match Total in Tab D.5 cell D63 total units\")","v":"ok"}]
[]
[]
[null,"Percentage of total units reserved for households with incomes up to 30% AMI:",null,{"$f":"IF(D24=0,\"\",J10+SUM(J15:J18))","v":""},{"$f":"IF(D24=0,\"\",IF(D28<0.1,\"ERROR: if requesting capital, a minimum of 10% of total units (excluding the manager's unit) must be reserved for households with incomes up to 30% AMI\",\"\"))","v":""}]
[]
[]
[null,"Maximum Potential Subsidy"]
[]
[null,"Maximum Potential AHTF Subsidy",12000000]
[]
[]
[null,"Capital Fund Per-Unit Subsidy Limits","Number of Bedrooms"]
[null,null,"Studio",1,2,3]
[null,null,180000,190000,200000,210000]
[]
[]
[null,"Assisted Units by Type & Funding","Number of Bedrooms"]
[null,null,"Studio",1,2,3,"Total"]
[null,"AHTF - Assisted",null,null,null,null,{"$f":"SUM(C43:F43)","v":0},{"$f":"IF(G43=(E13+E19),\"ok\",\"ERROR: unit count doesn't match AHTF request shown in table above\")","v":"ok"}]
[]
[]
[null,"Calculated Subsidy","Number of Bedrooms"]
[null,null,"Studio",1,2,3,"Total"]
[null,"AHTF Assisted Only",{"$f":"C43*C$38","v":0},{"$f":"D43*D$38","v":0},{"$f":"E43*E$38","v":0},{"$f":"F43*F$38","v":0},{"$f":"SUM(C48:F48)","v":0},{"$f":"IF(G48>C33,\"NOTE: total exceeds maximum subsidy per project; reduced to maximum below\",\"\")","v":""}]
[]
[null,"Maximum Subsidy",{"$f":"MIN(G48,C33)","v":0}]
[null,"Request  per Assisted Unit",{"$f":"IF(G43<>0,C50/G43,0)","v":0}]
[]
[]
[]
["END OF WORKSHEET"]

{"sheet":"D.1 Acq Predev Financing","index":3,"n_rows":61,"n_cols":7,"rows_kept":61,"cut":false,"hidden":false,"merged":[[14,4,14,6],[23,4,23,6],[37,4,37,6],[30,4,30,5],[26,4,26,6],[21,4,21,5],[28,4,28,6],[35,4,35,6],[36,4,36,6],[19,4,19,6],[20,4,20,6],[25,4,25,6],[24,4,24,6],[27,4,27,6],[29,4,29,6],[32,4,32,6],[16,4,16,6],[15,4,15,6],[17,4,17,6],[18,4,18,6],[34,4,34,6],[33,4,33,6],[51,4,51,6],[53,4,53,6],[54,4,54,6],[38,4,38,6],[50,4,50,6],[48,4,48,5],[45,4,45,6],[46,4,46,6],[47,4,47,6],[44,4,44,6],[41,4,41,6],[43,4,43,6],[42,4,42,6],[39,4,39,5],[57,4,57,5],[60,0,60,6],[55,4,55,6],[56,4,56,6],[52,4,52,6]]}
[]
[null,"D.1 Acquisition & Predevelopment Financing",null,null,null,null,{"$f":"IF('Application Instructions'!D5<>\"\",'Application Instructions'!D5,\"\")","v":""}]
[]
[null,null,"Lien Position","Name of Lender/Source","Term in Months","Interest Rate","Amount of Funds"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Total Funds for Acquisition/Predevelopment",{"$f":"SUM(G5:G12)","v":0}]
[]
[null,"1.","Name of Lender/Source"]
[null,null,"Contact Name"]
[null,null,"Street Address"]
[null,null,"City/State"]
[null,null,"Phone Number"]
[null,null,"Fax Number"]
[null,null,"Email Address"]
[null,null,"Use (menu selection)",null,"(Select)"]
[]
[null,"2.","Name of Lender/Source"]
[null,null,"Contact Name"]
[null,null,"Street Address"]
[null,null,"City/State"]
[null,null,"Phone Number"]
[null,null,"Fax Number"]
[null,null,"Email Address"]
[null,null,"Use (menu selection)",null,"(Select)"]
[]
[null,"3.","Name of Lender/Source"]
[null,null,"Contact Name"]
[null,null,"Street Address"]
[null,null,"City/State"]
[null,null,"Phone Number"]
[null,null,"Fax Number"]
[null,null,"Email Address"]
[null,null,"Use (menu selection)",null,"(Select)"]
[]
[null,"4.","Name of Lender/Source"]
[null,null,"Contact Name"]
[null,null,"Street Address"]
[null,null,"City/State"]
[null,null,"Phone Number"]
[null,null,"Fax Number"]
[null,null,"Email Address"]
[null,null,"Use (menu selection)",null,"(Select)"]
[]
[null,"5.","Name of Lender/Source"]
[null,null,"Contact Name"]
[null,null,"Street Address"]
[null,null,"City/State"]
[null,null,"Phone Number"]
[null,null,"Fax Number"]
[null,null,"Email Address"]
[null,null,"Use (menu selection)",null,"(Select)"]
[]
[]
["END OF WORKSHEET"]

{"sheet":"D.2 Sources","index":4,"n_rows":170,"n_cols":13,"rows_kept":170,"cut":false,"hidden":false,"merged":[[169,0,169,13],[94,4,94,6],[89,4,89,6],[87,4,87,5],[95,4,95,6],[140,4,140,5],[120,4,120,5],[118,4,118,5],[119,4,119,5],[122,4,122,6],[133,4,133,6],[137,4,137,6],[138,4,138,6],[139,4,139,6],[127,4,127,6],[128,4,128,6],[135,4,135,6],[134,4,134,6],[136,4,136,6],[129,4,129,5],[130,4,130,5],[131,4,131,5],[93,4,93,6],[164,4,164,5],[141,4,141,5],[142,4,142,5],[151,4,151,5],[152,4,152,5],[153,4,153,5],[147,4,147,6],[148,4,148,6],[149,4,149,6],[150,4,150,6],[144,4,144,6],[146,4,146,6],[145,4,145,6],[157,4,157,6],[156,4,156,6],[158,4,158,6],[159,4,159,6],[160,4,160,6],[161,4,161,6],[162,4,162,5],[163,4,163,5],[155,4,155,6],[3,11,4,11],[72,4,72,6],[73,4,73,6],[78,4,78,6],[80,4,80,6],[79,4,79,6],[81,4,81,6],[82,4,82,6],[67,4,67,6],[69,4,69,6],[70,4,70,6],[71,4,71,6],[68,4,68,6],[22,4,22,6],[23,4,23,6],[75,4,75,5],[76,4,76,5],[47,4,47,6],[50,2,50,12],[74,4,74,5],[84,4,84,6],[106,4,106,6],[104,4,104,6],[117,4,117,6],[105,4,105,6],[112,4,112,6],[114,4,114,6],[115,4,115,6],[116,4,116,6],[91,4,91,6],[107,4,107,5],[103,4,103,6],[101,4,101,6],[108,4,108,5],[111,4,111,6],[113,4,113,6],[109,4,109,5],[86,4,86,5],[96,4,96,5],[97,4,97,5],[98,4,98,5],[90,4,90,6],[92,4,92,6],[83,4,83,6],[85,4,85,5],[124,4,124,6],[123,4,123,6],[125,4,125,6],[126,4,126,6],[100,4,100,6],[1,11,1,12],[63,4,63,5],[54,4,54,6],[55,4,55,6],[56,4,56,6],[57,4,57,6],[58,4,58,6],[59,4,59,6],[60,4,60,6],[61,4,61,5],[62,4,62,5],[48,4,48,6],[2,1,2,11],[3,12,4,12],[28,11,29,11],[28,12,29,12],[1,1,1,3]]}
[]
[null,"D.2 Sources",null,null,null,null,null,null,null,null,null,{"$f":"IF('Application Instructions'!D5<>\"\",'Application Instructions'!D5,\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Residential Component","Commercial Component"]
[null,null,"CONSTRUCTION SOURCES"]
[null,null,"Lien Position","Name of Lender/Source","Notes for Lender/Source\n(if \"Other\", lender not specified, etc.)","Term in Months","Interest Rate","Amount of Funds",null,null,null,"Amount of Funds","Amount of Funds"]
[null,null,null,"(Select)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Total Tax Credit Equity"]
[null,null,null,null,"Total Funds for Construction",null,null,{"$f":"SUM(H7:H23)","v":0},null,null,null,{"$f":"SUM(L7:L23)","v":0},{"$f":"SUM(M7:M23)","v":0}]
[]
[null,null,"NOTE: Do not show deferred interest as a source."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Residential Component","Commercial Component"]
[null,null,"PERMANENT SOURCES"]
[null,null,"Lien Position","Name of Lender/Source","Notes for Lender/Source\n(if \"Other\", lender not specified, etc.)","Term in Months","Interest Rate","Amount of Funds","Annual Debt Service","Amortization Term",null,"Amount of Funds","Amount of Funds"]
[null,null,null,"(Select)"]
[]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,"Total Tax Credit Equity"]
[null,null,null,null,"Total Sources of Project Funds",null,null,{"$f":"SUM(H32:H48)","v":0},null,null,null,{"$f":"SUM(L32:L48)","v":0},0]
[]
[null,null,"*NOTE:  Cell B61 in the D.6 20-year cash flow tab is tied to the inputs in H32 to H47 as applicable. Review the formula and note in cell A61 on tab D.6 to ensure that it is calculating correctly. "]
[]
[null,null,"NOTE: Do not show deferred interest as a source."]
[]
[null,null,"Name of Tax Credit Investor"]
[null,null,"Contact Name"]
[null,null,"Street Address"]
[null,null,"City/State"]
[null,null,"Phone Number"]
[null,null,"Fax Number"]
[null,null,"Email Address"]
[null,null,"Type of Financing (menu selection)",null,"(Select)"]
[null,null,"Term of Financing (menu selection)",null,"(Select)"]
[null,null,"Committed (menu selection)",null,"(Select)"]
[]
[null,null,"List the sources below in the same order as the table above."]
[]
[null,"1.","Name of Lender/Source"]
[null,null,"Contact Name"]
[null,null,"Street Address"]
[null,null,"City/State"]
[null,null,"Phone Number"]
[null,null,"Fax Number"]
[null,null,"Email Address"]
[null,null,"Type of Financing (menu selection)",null,"(Select)"]
[null,null,"Term of Financing (menu selection)",null,"(Select)"]
[null,null,"Committed (menu selection)",null,"(Select)"]
[]
[null,"2.","Name of Lender/Source"]
[null,null,"Contact Name"]
[null,null,"Street Address"]
[null,null,"City/State"]
[null,null,"Phone Number"]
[null,null,"Fax Number"]
[null,null,"Email Address"]
[null,null,"Type of Financing (menu selection)",null,"(Select)"]
[null,null,"Term of Financing (menu selection)",null,"(Select)"]
[null,null,"Committed (menu selection)",null,"(Select)"]
[]
[null,"3.","Name of Lender/Source"]
[null,null,"Contact Name"]
[null,null,"Street Address"]
[null,null,"City/State"]
[null,null,"Phone Number"]
[null,null,"Fax Number"]
[null,null,"Email Address"]
[null,null,"Type of Financing (menu selection)",null,"(Select)"]
[null,null,"Term of Financing (menu selection)",null,"(Select)"]
[null,null,"Committed (menu selection)",null,"(Select)"]
[]
[null,"4.","Name of Lender/Source"]
[null,null,"Contact Name"]
[null,null,"Street Address"]
[null,null,"City/State"]
[null,null,"Phone Number"]
[null,null,"Fax Number"]
[null,null,"Email Address"]
[null,null,"Type of Financing (menu selection)",null,"(Select)"]
[null,null,"Term of Financing (menu selection)",null,"(Select)"]
[null,null,"Committed (menu selection)",null,"(Select)"]
[]
[null,"5.","Name of Lender/Source"]
[null,null,"Contact Name"]
[null,null,"Street Address"]
[null,null,"City/State"]
[null,null,"Phone Number"]
[null,null,"Fax Number"]
[null,null,"Email Address"]
[null,null,"Type of Financing (menu selection)",null,"(Select)"]
[null,null,"Term of Financing (menu selection)",null,"(Select)"]
[null,null,"Committed (menu selection)",null,"(Select)"]
[]
[null,"6.","Name of Lender/Source"]
[null,null,"Contact Name"]
[null,null,"Street Address"]
[null,null,"City/State"]
[null,null,"Phone Number"]
[null,null,"Fax Number"]
[null,null,"Email Address"]
[null,null,"Type of Financing (menu selection)",null,"(Select)"]
[null,null,"Term of Financing (menu selection)",null,"(Select)"]
[null,null,"Committed (menu selection)",null,"(Select)"]
[]
[null,"7.","Name of Lender/Source"]
[null,null,"Contact Name"]
[null,null,"Street Address"]
[null,null,"City/State"]
[null,null,"Phone Number"]
[null,null,"Fax Number"]
[null,null,"Email Address"]
[null,null,"Type of Financing (menu selection)",null,"(Select)"]
[null,null,"Term of Financing (menu selection)",null,"(Select)"]
[null,null,"Committed (menu selection)",null,"(Select)"]
[]
[null,"8.","Name of Lender/Source"]
[null,null,"Contact Name"]
[null,null,"Street Address"]
[null,null,"City/State"]
[null,null,"Phone Number"]
[null,null,"Fax Number"]
[null,null,"Email Address"]
[null,null,"Type of Financing (menu selection)",null,"(Select)"]
[null,null,"Term of Financing (menu selection)",null,"(Select)"]
[null,null,"Committed (menu selection)",null,"(Select)"]
[]
[null,"9.","Name of Lender/Source"]
[null,null,"Contact Name"]
[null,null,"Street Address"]
[null,null,"City/State"]
[null,null,"Phone Number"]
[null,null,"Fax Number"]
[null,null,"Email Address"]
[null,null,"Type of Financing (menu selection)",null,"(Select)"]
[null,null,"Term of Financing (menu selection)",null,"(Select)"]
[null,null,"Committed (menu selection)",null,"(Select)"]
[]
[null,null,"CONTINUE TO ADD SOURCE INFORMATION IF APPLICABLE"]
[]
[]
["END OF WORKSHEET"]

{"sheet":"D.3 Development Budget w Notes","index":5,"n_rows":139,"n_cols":11,"rows_kept":139,"cut":false,"hidden":false,"merged":[[4,6,5,6],[4,7,5,7],[4,9,5,9],[4,0,4,1],[9,10,9,16],[10,10,10,16],[13,10,13,16],[14,10,14,16],[15,10,15,16],[3,10,5,16],[1,10,1,16],[7,10,7,16],[8,10,8,16],[22,10,22,16],[23,10,23,16],[24,10,24,16],[25,10,25,16],[16,10,16,16],[17,10,17,16],[18,10,18,16],[19,10,19,16],[21,10,21,16],[20,10,20,16],[37,10,37,16],[38,10,38,16],[39,10,39,16],[40,10,40,16],[41,10,41,16],[26,10,26,16],[29,10,29,16],[30,10,30,16],[31,10,31,16],[34,10,34,16],[47,10,47,16],[48,10,48,16],[49,10,49,16],[50,10,50,16],[51,10,51,16],[42,10,42,16],[43,10,43,16],[44,10,44,16],[45,10,45,16],[46,10,46,16],[58,10,58,16],[61,10,61,16],[62,10,62,16],[63,10,63,16],[65,10,65,16],[52,10,52,16],[53,10,53,16],[54,10,54,16],[56,10,56,16],[57,10,57,16],[55,10,55,16],[64,10,64,16],[75,10,75,16],[76,10,76,16],[79,10,79,16],[80,10,80,16],[81,10,81,16],[66,10,66,16],[67,10,67,16],[70,10,70,16],[72,10,72,16],[73,10,73,16],[71,10,71,16],[74,10,74,16],[91,10,91,16],[94,10,94,16],[95,10,95,16],[96,10,96,16],[82,10,82,16],[83,10,83,16],[86,10,86,16],[89,10,89,16],[90,10,90,16],[103,10,103,16],[104,10,104,16],[105,10,105,16],[106,10,106,16],[107,10,107,16],[97,10,97,16],[99,10,99,16],[100,10,100,16],[101,10,101,16],[102,10,102,16],[98,10,98,16],[113,10,113,16],[114,10,114,16],[115,10,115,16],[116,10,116,16],[117,10,117,16],[108,10,108,16],[109,10,109,16],[110,10,110,16],[111,10,111,16],[112,10,112,16],[138,0,138,16],[132,10,132,16],[126,10,126,16],[127,10,127,16],[128,10,128,16],[129,10,129,16],[118,10,118,16],[119,10,119,16],[121,10,121,16],[124,10,124,16],[125,10,125,16]]}
[]
["D.3  Development Budget + Notes & Assumptions",null,null,null,null,null,null,null,null,null,{"$f":"IF('Application Instructions'!D5<>\"\",'Application Instructions'!D5,\"\")","v":""}]
[]
[null,null,null,null,null,null,"Eligible Basis",null,null,null,"Development Budget Notes & Assumptions \n\nAll individual line items must be completed, with details for assumptions, as applicable."]
["All budget items must be completed as applicable.",null,null,"Residential","Non-Residential",null,"New Construction / Rehab","Acquisition",null,"Residential Cost/Unit"]
[null,null,"Total",null,{"$f":"1-D6","v":1}]
["Acquisition"]
[null,"Total Land Cost",null,{"$f":"C8*D$6","v":0},{"$f":"C8-D8","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D8/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Existing Improvements Value",null,{"$f":"C9*D$6","v":0},{"$f":"C9-D9","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D9/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Legal / Title & Recording",null,{"$f":"C10*D$6","v":0},{"$f":"C10-D10","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D10/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Total - Acquisition Costs",{"$f":"SUM(C8:C10)","v":0},{"$f":"SUM(D8:D10)","v":0},{"$f":"SUM(E8:E10)","v":0},null,{"$f":"SUM(G8:G10)","v":0},{"$f":"SUM(H8:H10)","v":0},null,{"$f":"SUM(J8:J10)","v":0},"Provide justification if acquisition cost exceeds appraised value."]
[]
["Construction"]
[null,"Demolition",null,{"$f":"C14*D$6","v":0},{"$f":"C14-D14","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D14/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Toxic Abatement",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D15/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Offsite Improvements",null,0,{"$f":"C16-D16","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D16/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"On-site Improvements attributable to unusual conditions",null,0,{"$f":"C17-D17","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D17/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Site Work",null,0,{"$f":"C18-D18","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D18/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Structures",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D19/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Parking ",null,0,{"$f":"C20-D20","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D20/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0},"Provide a per-space cost "]
[null,"Security (during construction)",null,{"$f":"C21*D$6","v":0},{"$f":"C21-D21","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D21/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Payment & Performance Bond",null,{"$f":"C22*D$6","v":0},{"$f":"C22-D22","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D22/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"General Requirements",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D23/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Contractor Overhead",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D24/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Contractor Profit",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D25/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"General Liability Insurance",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D26/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Total - Construction Costs",{"$f":"SUM(C14:C26)","v":0},{"$f":"SUM(D14:D26)","v":0},{"$f":"SUM(E14:E26)","v":0},null,{"$f":"SUM(G14:G26)","v":0},{"$f":"SUM(H14:H26)","v":0},null,{"$f":"SUM(J14:J26)","v":0}]
[]
["Architectural Fees"]
[null,"Design",null,{"$f":"C30*D$6","v":0},{"$f":"C30-D30","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D30/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Supervision",null,{"$f":"C31*D$6","v":0},{"$f":"C31-D31","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D31/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Total  - Architectural Costs",{"$f":"SUM(C30:C31)","v":0},{"$f":"SUM(D30:D31)","v":0},{"$f":"SUM(E30:E31)","v":0},null,{"$f":"SUM(G30:G31)","v":0},{"$f":"SUM(H30:H31)","v":0},null,{"$f":"SUM(J30:J31)","v":0}]
[]
["Survey & Engineering"]
[null,"Total  - Survey & Engineering",null,{"$f":"C35*D$6","v":0},{"$f":"C35-D35","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D35/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[]
["Construction Interest & Fees"]
[null,"Construction Loan Interest",null,{"$f":"C38*D$6","v":0},{"$f":"C38-D38","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D38/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Origination Fee",null,{"$f":"C39*D$6","v":0},0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D39/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Costs of Bond Issuance"]
[null,"a)  Underwriter Fee",null,{"$f":"C41*D$6","v":0},0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D41/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"b)  Underwriter Counsel",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D42/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"c)  Issuer Fee",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D43/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"d)  Issuer Financial Advisor",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D44/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"e)  Bond Counsel",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D45/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"f)  Lender Origination/LOC Fee",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D46/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"g)  Lender Counsel",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D47/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"h)  Rating",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D48/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"i)  Trustee Fee",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D49/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"j)  Trustee Counsel",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D50/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"k)  Printing",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D51/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"l)  CDLAC Fees",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D52/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Property Taxes",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D53/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Insurance",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D54/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Title and Recording",null,{"$f":"C55*D$6","v":0},{"$f":"C55-D55","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D55/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Lender Due Diligence Fees/Costs",null,{"$f":"C56*D$6","v":0},{"$f":"C56-D56","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D56/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Other: (specify)",null,{"$f":"C57*D$6","v":0},{"$f":"C57-D57","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D57/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Other: (specify)",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D58/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Total - Construction Interest & Fees",{"$f":"SUM(C38:C58)","v":0},{"$f":"SUM(D38:D58)","v":0},{"$f":"SUM(E38:E58)","v":0},null,{"$f":"SUM(G38:G58)","v":0},{"$f":"SUM(H38:H58)","v":0},null,{"$f":"SUM(J38:J58)","v":0}]
[]
["Permanent Financing"]
[null,"Loan Origination Fee/Extension Fees",null,{"$f":"C62*D$6","v":0},{"$f":"C62-D62","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D62/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Credit Enhance. & App. Fee",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D63/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Title and Recording",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D64/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Lender Due Diligence Fees/Costs",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D65/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Other: (specify)",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D66/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Other: (specify)",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D67/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Total - Permanent Financing Costs",{"$f":"SUM(C62:C67)","v":0},{"$f":"SUM(D62:D67)","v":0},{"$f":"SUM(E62:E67)","v":0},null,{"$f":"SUM(G62:G67)","v":0},{"$f":"SUM(H62:H67)","v":0},null,{"$f":"SUM(J62:J67)","v":0}]
[]
["Legal Fees"]
[null,"Construction Lender Legal Pd. by Applicant",null,{"$f":"C71*D$6","v":0},{"$f":"C71-D71","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D71/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Permanent Lender Legal Pd. by Applicant",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D72/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Borrower - Transaction",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D73/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Syndication",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D74/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Organization Fee",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D75/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Other: (specify)",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D76/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Total - Attorney Costs",{"$f":"SUM(C71:C76)","v":0},{"$f":"SUM(D71:D76)","v":0},{"$f":"SUM(E71:E76)","v":0},null,{"$f":"SUM(G71:G76)","v":0},{"$f":"SUM(H71:H76)","v":0},null,{"$f":"SUM(J71:J76)","v":0}]
[]
["Reserves"]
[null,"Operating Reserves",null,{"$f":"C80*D$6","v":0},{"$f":"C80-D80","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D80/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Replacement Reserve",null,{"$f":"C81*D$6","v":0},{"$f":"C81-D81","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D81/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Transition Reserve",null,{"$f":"C82*D$6","v":0},{"$f":"C82-D82","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D82/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Other: (specify)",null,{"$f":"C83*D$6","v":0},{"$f":"C83-D83","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D83/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Total - Reserve Costs",{"$f":"SUM(C80:C83)","v":0},{"$f":"SUM(D80:D83)","v":0},{"$f":"SUM(E80:E83)","v":0},null,{"$f":"SUM(G80:G83)","v":0},{"$f":"SUM(H80:H83)","v":0},null,{"$f":"SUM(J80:J83)","v":0}]
[]
["Appraisal"]
[null,"Total - Appraisal Costs",null,{"$f":"C87*D$6","v":0},{"$f":"C87-D87","v":0},null,{"$f":"D87","v":0},0,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D87/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[]
["Contingency"]
[null,"Hard Cost Contingency",null,{"$f":"C90*D$6","v":0},{"$f":"C90-D90","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D90/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Soft Cost Contingency",null,{"$f":"C91*D$6","v":0},{"$f":"C91-D91","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D91/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Total - Contingency Costs",{"$f":"SUM(C90:C91)","v":0},{"$f":"SUM(D90:D91)","v":0},{"$f":"SUM(E90:E91)","v":0},null,{"$f":"SUM(G90:G91)","v":0},{"$f":"SUM(H90:H91)","v":0},null,{"$f":"SUM(J90:J91)","v":0}]
[]
["Other"]
[null,"TCAC App/Alloc/Monitor Fees",null,{"$f":"C95*D$6","v":0},{"$f":"C95-D95","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D95/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Environmental Audit",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D96/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Local Development Impact Fees",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D97/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Permit Processing Fees",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D98/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Utility Connection",null,{"$f":"C99*D$6","v":0},{"$f":"C99-D99","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D99/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"School Fees",null,{"$f":"C100*D$6","v":0},{"$f":"C100-D100","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D100/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Marketing",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D101/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Leasing (Lease-Up Expense)",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D102/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Leasing (Lease-Up) Fee",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D103/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Relocation Expenses",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D104/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Furnishings (common areas)",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D105/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Unit Furnishings (homeless units)",null,{"$f":"C106*D$6","v":0},{"$f":"C106-D106","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D106/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Accounting/Audit",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D107/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Acq/Predev Loan Fees & Expenses",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D108/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Acq/Predev Loan Interest",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D109/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Construction Management",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D110/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Deputy Inspection",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D111/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"LACDA - Reservation Fee",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D112/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0},"Covers year one monitoring fee ($7,512)"]
[null,"Holding Costs",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D113/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Market Study",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D114/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Security (during predevelopment)",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D115/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Green Building Certification",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D116/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Consultant",null,0,{"$f":"C117-D117","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D117/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Other: (specify)",null,0,{"$f":"C118-D118","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D118/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Other: (specify)",null,0,0,null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D119/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Total - Other Costs",{"$f":"SUM(C95:C119)","v":0},{"$f":"SUM(D95:D119)","v":0},{"$f":"SUM(E95:E119)","v":0},null,{"$f":"SUM(G95:G119)","v":0},{"$f":"SUM(H95:H119)","v":0},null,{"$f":"SUM(J95:J119)","v":0}]
[]
[null,"SUBTOTALS",{"$f":"SUM(C11,C27,C32,C35,C59,C68,C77,C84,C87,C92,C120)","v":0},{"$f":"SUM(D11,D27,D32,D35,D59,D68,D77,D84,D87,D92,D120)","v":0},{"$f":"SUM(E11,E27,E32,E35,E59,E68,E77,E84,E87,E92,E120)","v":0},null,{"$f":"SUM(G11,G27,G32,G35,G59,G68,G77,G84,G87,G92,G120)","v":0},{"$f":"SUM(H11,H27,H32,H35,H59,H68,H77,H84,H87,H92,H120)","v":0},null,{"$f":"SUM(J11,J27,J32,J35,J59,J68,J77,J84,J87,J92,J120)","v":0}]
[]
["Developer Costs"]
[null,"Developer Fee",null,{"$f":"C125*D$6","v":0},{"$f":"C125-D125","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D125/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Consultant/Processing Agent",null,{"$f":"C126*D$6","v":0},{"$f":"C126-D126","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D126/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Project Administration",null,{"$f":"C127*D$6","v":0},{"$f":"C127-D127","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D127/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Broker fees paid by owner",null,{"$f":"C128*D$6","v":0},{"$f":"C128-D128","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D128/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Other: (specify)",null,{"$f":"C129*D$6","v":0},{"$f":"C129-D129","v":0},null,null,null,null,{"$f":"IF('D.5 Unit Mix, Rents, Subsidy'!D$63<>0,'D.3 Development Budget w Notes'!D129/'D.5 Unit Mix, Rents, Subsidy'!D$63,0)","v":0}]
[null,"Total - Developer Costs",{"$f":"SUM(C125:C129)","v":0},{"$f":"SUM(D125:D129)","v":0},{"$f":"SUM(E125:E129)","v":0},null,{"$f":"SUM(G125:G129)","v":0},{"$f":"SUM(H125:H129)","v":0},null,{"$f":"SUM(J125:J129)","v":0}]
[]
[]
[null,"TOTAL DEVELOPMENT COSTS",{"$f":"SUM(C122,C130)","v":0},{"$f":"SUM(D122,D130)","v":0},{"$f":"SUM(E122,E130)","v":0},null,{"$f":"SUM(G122+G130)","v":0},{"$f":"SUM(H122+H130)","v":0},null,{"$f":"SUM(J122,J130)","v":0}]
[]
[null,null,null,null,null,"Bridge Loan Expense During Construction",0,0]
[null,null,null,null,null,"TOTAL ELIGIBLE BASIS",{"$f":"SUM(G133:G135)","v":0},{"$f":"SUM(H133:H135)","v":0}]
[]
[]
["END OF WORKSHEET"]

{"sheet":"D.4 Operating Budget w Notes","index":6,"n_rows":67,"n_cols":11,"rows_kept":67,"cut":false,"hidden":false,"merged":[[58,2,59,2],[58,3,59,3],[58,4,59,4],[58,5,59,5],[59,10,59,13],[62,6,62,13],[1,3,1,4],[2,2,3,2],[2,5,3,5],[65,0,65,3],[64,0,64,3],[60,2,61,2],[60,3,61,3],[60,4,61,4],[60,5,61,5],[7,6,7,13],[8,6,8,13],[9,6,9,13],[4,6,4,13],[6,6,6,13],[10,6,10,13],[11,6,11,13],[12,6,12,13],[13,6,13,13],[14,6,14,13],[15,6,15,13],[16,6,16,13],[17,6,17,13],[18,6,18,13],[19,6,19,13],[22,6,22,13],[23,6,23,13],[24,6,24,13],[25,6,25,13],[26,6,26,13],[27,6,27,13],[34,6,34,13],[35,6,35,13],[36,6,36,13],[58,6,58,13],[28,6,28,13],[29,6,29,13],[30,6,30,13],[31,6,31,13],[32,6,32,13],[42,6,42,13],[50,6,50,13],[57,6,57,13],[66,0,66,13],[60,6,60,13],[1,6,1,13],[3,6,3,13],[51,6,51,13],[52,6,52,13],[44,6,44,13],[45,6,45,13],[46,6,46,13],[55,6,55,13],[37,6,37,13],[38,6,38,13],[39,6,39,13],[40,6,40,13],[43,6,43,13],[33,6,33,13]]}
[]
["D.4  Operating Budget + Notes and Assumptions",null,null,null,null,null,{"$f":"IF('Application Instructions'!D5<>\"\",'Application Instructions'!D5,\"\")","v":""}]
[null,null,"Residential Component",null,null,"Commercial Component"]
[null,null,null,null,null,null,"All items must be completed, with details for assumptions, as applicable."]
[null,null,"Proposed Budget","Per Unit Per Month","Per Unit Per Year","Proposed Budget","Operating Budget Notes & Assumptions"]
[]
["Administrative Expenses"]
["   Office Salaries",null,null,{"$f":"$C8/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$f":"+D8*12","v":{"$error":"#DIV/0!"}}]
["   Emp Benefits & Insurance",null,null,{"$f":"$C9/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$f":"+D9*12","v":{"$error":"#DIV/0!"}}]
["   On-site Manager",null,null,{"$f":"$C10/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["   Maintenance Personnel",null,null,{"$f":"$C11/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["   Supportive Services",null,null,{"$f":"$C12/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["   Property Management Fee",null,null,{"$f":"$C13/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["   Office Supplies",null,null,{"$f":"$C14/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["   Advertising",null,null,{"$f":"$C15/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["   Legal",null,null,{"$f":"$C16/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["   Accounting/Audit",null,null,{"$f":"$C17/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["   Security",null,null,{"$f":"$C18/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["   Communication",null,null,{"$f":"$C19/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["   Miscellaneous Admin",null,null,{"$f":"$C20/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["Total Administrative Expenses",null,{"$f":"SUM(C8:C20)","v":0},{"$f":"SUM(D8:D20)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E8:E20)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F8:F20)","v":0}]
[]
["Maintenance Expenses"]
["   Maintenance supplies",null,null,{"$f":"$C24/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$f":"+D24*12","v":{"$error":"#DIV/0!"}}]
["   Pest Control",null,null,{"$f":"$C25/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$f":"+D25*12","v":{"$error":"#DIV/0!"}}]
["   Repairs Contract",null,null,{"$f":"$C26/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["   HVAC repairs & maintenance",null,null,{"$f":"$C27/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["   Landscape Contract",null,null,{"$f":"$C28/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["   Interior/exterior painting",null,null,{"$f":"$C29/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["   Elevator maintenance",null,null,{"$f":"$C30/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["   Interior cleaning",null,null,{"$f":"$C31/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$f":"+D31*12","v":{"$error":"#DIV/0!"}}]
["   Misc. Maintenance Expense",null,null,{"$f":"$C32/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["   Extra. Maintenance Expense *",null,null,{"$f":"$C33/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["Total Maintenance Expense",null,{"$f":"SUM(C24:C33)","v":0},{"$f":"SUM(D24:D33)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E24:E33)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F24:F33)","v":0}]
[]
["Utilities Expenses"]
["   Trash removal",null,null,{"$f":"$C37/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$f":"+D37*12","v":{"$error":"#DIV/0!"}}]
["   Electricity",null,null,{"$f":"$C38/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["   Water/sewer",null,null,{"$f":"$C39/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["   Gas",null,null,{"$f":"$C40/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["Total Utilities Expense",null,{"$f":"SUM(C37:C40)","v":0},{"$f":"SUM(D37:D40)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E37:E40)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F37:F40)","v":0}]
[]
["Tax & Insurance Expenses"]
["   Real estate taxes & assessments",null,null,{"$f":"$C44/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["   Licenses & Fees",null,null,{"$f":"$C45/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$f":"+D45*12","v":{"$error":"#DIV/0!"}}]
["   Property & liability insurance",null,null,{"$f":"$C46/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["Total Tax & Insurance",null,{"$f":"SUM(C44:C46)","v":0},{"$f":"SUM(D44:D46)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E44:E46)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F44:F46)","v":0}]
[]
["TOTAL OPERATING EXPENSES",null,{"$f":"SUM(C47,C41,C34,C21)","v":0},{"$f":"C49/'D.5 Unit Mix, Rents, Subsidy'!D63/12","v":{"$error":"#DIV/0!"}},{"$f":"+D49*12","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F47,F41,F34,F21)","v":0}]
[]
["Project Reserves"]
["   Operating Reserves",null,null,{"$f":"$C52/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["   Replacement Reserve",null,null,{"$f":"$C53/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$f":"+D53*12","v":{"$error":"#DIV/0!"}}]
["   Transition Reserve",null,null,{"$f":"$C54/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
["TOTAL EXPENSES",null,{"$f":"SUM(C52:C54,C49)","v":0},{"$f":"C56/'D.5 Unit Mix, Rents, Subsidy'!D63/12","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E52:E54,E49)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F52:F54,F49)","v":0}]
[]
["Partnership & Asset Management Fees"]
["   Fee to LP Tax Credit Investor",null,null,{"$f":"$C59/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,"Paid Through Year:",null,null,null,"Fee ceases after tax credit compliance period and/or LP exit"]
["   Fee to GP",null,null,{"$f":"$C61/'D.5 Unit Mix, Rents, Subsidy'!$D$63/12","v":{"$error":"#DIV/0!"}},{"$f":"+D61*12","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"Paid Through Year:"]
["Total Partnership & Asset Management Fees",null,{"$f":"SUM(C59:C61)","v":0},{"$f":"SUM(D59:D61)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E59:E61)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F59:F61)","v":0}]
[]
["* Funds for this line item will be taken from the replacement reserves."]
[]
["END OF WORKSHEET"]

{"sheet":"D.5 Unit Mix, Rents, Subsidy","index":7,"n_rows":198,"n_cols":50,"rows_kept":198,"cut":false,"hidden":false,"merged":[[197,0,197,16],[4,46,4,47],[145,2,145,5],[146,2,146,5],[123,2,123,5],[67,11,67,13],[50,4,50,6],[57,4,57,5],[68,11,68,13],[58,4,58,5],[67,5,68,5],[126,2,126,5],[62,1,62,2],[58,1,58,2],[29,1,29,11],[60,4,60,5],[2,1,2,11],[52,1,52,3],[30,1,30,11],[54,4,54,5],[54,1,54,3],[141,2,141,5],[59,4,59,5],[127,2,127,5],[94,1,94,8],[106,1,106,4],[104,3,104,5],[64,5,65,5],[67,1,67,3],[68,1,68,3],[104,1,104,2],[124,2,124,5],[125,2,125,5],[59,1,59,2],[57,1,57,2],[60,1,60,2],[56,1,56,2],[4,43,4,44],[4,39,4,41],[4,19,4,37],[52,4,52,5],[53,4,53,5],[25,13,27,13],[56,4,56,5],[51,4,51,5],[55,4,55,5],[55,1,55,2],[156,1,156,2],[156,3,156,5],[128,2,128,5],[129,2,129,5],[132,2,132,5],[133,2,133,5],[135,2,135,5],[134,2,134,5],[153,1,154,6],[147,2,147,5],[142,2,142,5],[144,2,144,5],[143,2,143,5],[136,2,136,5],[137,2,137,5],[138,2,138,5]]}
[]
[null,"D.  Unit Mix, Rents and Rental Subsidies",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Application Instructions'!D5<>\"\",'Application Instructions'!D5,\"\")","v":""},{"$f":"IF('Application Instructions'!E5<>\"\",'Application Instructions'!E5,\"\")","v":""}]
[]
[null,"Project Rent Schedule For Special Needs and Non-Special Needs Units"]
[null,"The most restrictive rents from Funding Sources must be used as the monthly gross rent. Manager's units and Market rate units will be counted separately in the tables below. ENTER RENTAL SUBSIDY INFORMATION ONLY IF APPLICABLE.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The information below is for reviewer's use only:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculation of Rent Subsidy Premium (e.g., Shelter Plus Care, PBV, or PBVASH)",null,null,null,"Calculation of Net Tenant Rent",null,null,"4% Tie Breaker Calcs"]
[null,"Unit Size","# of Units","% AMI","LACDA AHTF Assisted Units? (Y/N)","Target Population","Applicable Agency Rent (CTCAC or Other)","CTCAC Monthly Rent Limit \n(per unit)","Alternative Monthly Rent Limit \n(per unit)\n(Manual Input, in lieu of CTCAC Rents)","Monthly Rents\n(i.e. Rent Limit multiplied by the number of Units)"," Monthly Utility Allowance\n(i.e. UA multiplied by the number of Units)","Net Monthly Rents \n(i.e. Monthly Rent minus Monthly UA)","Rental Subsidy? \n(i.e. PBVs, PBVASH, FHSP)","Net Subsidy Payment Standard (per unit)\n(i.e. Gross Subsidy Payment Standard minus UA; the \"Contract Rent\")","Net Monthly Subsidy Payment Standard","Net Monthly Subsidy Premium \n(i.e. Net Monthly Subsidy Payment Standard minus Net Monthly Rents)","Total Monthly Income\n(i.e. Net Monthly Rents + Net Monthly Subsidy Premium)",null,null,"<= 30% AMI","31 - 50% AMI","\"LACDA-Assisted\"","\"Federal Vouchers\"","\"No Federal  Vouchers\"","\"SN\"","SN - Homeless","SN - Homeless Seniors","SN - Chronically Homeless","SN - Homeless Veterans","SN - Homeless Persons Living with a Mental Illness","SN - Homeless Transition Age Youth","SN - Persons Living with HIV/AIDS","SN - Persons with Intellectual and Developmental Disabilities","SN - At Risk Transition Age Youth","SN - Survivors of DV / HT / SA","General Affordable - Extremely Low Income","General Affordable - Family","General Affordable - Seniors",null,"Difference","Total Monthly Subsidy Premium","Annual Subsidy Premium",null,"SN Tenant Rent","Non-SN Tenant Rent",null,"Non-Federal Vouchers income Averaging","FMR","Monthly DELTA","DELTA x Units"]
[null,"(Select)",0,"(Select)","(Select)","(Select)","(Select)",{"$f":"IF(G7=\"CTCAC\",_xlfn.XLOOKUP($B7&$D7,'drop down menus'!$E$69:$E$134,'drop down menus'!$H$69:$H$134,\"Error\"),\"\")","v":""},null,{"$f":"IF($G7=\"CTCAC\",$H7*C7,$I7*C7)","v":0},{"$f":"((((((IF($B7=\"STUDIO\",$D$103,IF($B7=\"1-BEDROOM\",$E$103,IF($B7=\"2-BEDROOM\",$F$103,IF($B7=\"3-BEDROOM\",$G$103,IF($B7=\"4-BEDROOM\",$H$103,IF($B7=\"5-BEDROOM\",$I$103,0))))))*$C7))))))","v":0},{"$f":"J7-K7","v":0},"(Select)",null,{"$f":"IF(AND(LEFT(M7,3)=\"Yes\",ISNUMBER(N7)),N7*C7,\"\")","v":""},{"$f":"IF(AND(LEFT(M7,3)=\"Yes\",ISNUMBER(N7)),$O7-$L7,\"\")","v":""},{"$f":"IF(AND(LEFT(M7,3)=\"Yes\",ISNUMBER(N7)),($L7+$P7),$L7)","v":0},null,null,{"$f":"IF($D7<=0.3,$C7,0)","v":0},{"$f":"IF(AND($D7<=0.5,$D7>0.3),$C7,0)","v":0},{"$f":"IF($E7=\"Yes\",$C7,IF(OR($M7=\"Yes - LACDA PBVs\", $M7=\"Yes - LACDA PBVASH\"),$C7,0))","v":0},{"$f":"IF(OR(M7=\"Yes - LACDA PBVs\",M7=\"Yes - LACDA PBVASH\",M7=\"Yes - Other Issuer - Federal\"),C7,0)","v":0},{"$f":"C7-W7","v":0},{"$f":"SUM(Z7:AI7)","v":0},{"$f":"IF(($F7=$Z$6),$C7,0)","v":0},{"$f":"IF(($F7=AA$6),$C7,0)","v":0},0,0,0,0,0,0,0,0,{"$f":"IF(($F7=AJ$6),$C7,0)","v":0},0,0,null,{"$f":"IF(ISNUMBER($N7),$N7-$L7,0)","v":0},{"$f":"IF($P7<>\"\",$P7,0)","v":0},{"$f":"IF(ISNUMBER(AO7),$AO7*12,0)","v":0},null,{"$f":"IF(SUM(Z7:AI7)>0,L7,0)","v":0},{"$f":"IF(SUM(AJ7:AL7)>0,J7-K7,0)","v":0},null,{"$f":"(X7*D7)","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.XLOOKUP(B7,'drop down menus'!$G$34:$G$39,'drop down menus'!$H$34:$H$39,\"\")","v":""},{"$f":"IF(ISNUMBER(H7),AV7-H7,IF(ISNUMBER(I7),AV7-I7,0))","v":0},{"$f":"AW7*C7","v":0}]
[null,null,0,null,null,null,null,{"$f":"IF(G8=\"CTCAC\",_xlfn.XLOOKUP($B8&$D8,'drop down menus'!$E$69:$E$134,'drop down menus'!$H$69:$H$134,\"Error\"),\"\")","v":""},null,{"$f":"IF($G8=\"CTCAC\",$H8*C8,$I8*C8)","v":0},{"$f":"((((((IF($B8=\"STUDIO\",$D$103,IF($B8=\"1-BEDROOM\",$E$103,IF($B8=\"2-BEDROOM\",$F$103,IF($B8=\"3-BEDROOM\",$G$103,IF($B8=\"4-BEDROOM\",$H$103,IF($B8=\"5-BEDROOM\",$I$103,0))))))*$C8))))))","v":0},{"$f":"J8-K8","v":0},null,null,"",{"$f":"IF(AND(LEFT(M8,3)=\"Yes\",ISNUMBER(N8)),$O8-$L8,\"\")","v":""},{"$f":"IF(AND(LEFT(M8,3)=\"Yes\",ISNUMBER(N8)),($L8+$P8),$L8)","v":0},null,null,{"$f":"IF($D8<=0.3,$C8,0)","v":0},{"$f":"IF(AND($D8<=0.5,$D8>0.3),$C8,0)","v":0},0,0,0,{"$f":"SUM(Z8:AI8)","v":0},0,{"$f":"IF(($F8=AA$6),$C8,0)","v":0},0,0,0,0,0,0,0,0,{"$f":"IF(($F8=AJ$6),$C8,0)","v":0},0,0,null,{"$f":"IF(ISNUMBER($N8),$N8-$L8,0)","v":0},0,0,null,0,0,null,0,{"$f":"_xlfn.XLOOKUP(B8,'drop down menus'!$G$34:$G$39,'drop down menus'!$H$34:$H$39,\"\")","v":""},0,0]
[null,null,0,null,null,null,null,{"$f":"IF(G9=\"CTCAC\",_xlfn.XLOOKUP($B9&$D9,'drop down menus'!$E$69:$E$134,'drop down menus'!$H$69:$H$134,\"Error\"),\"\")","v":""},null,{"$f":"IF($G9=\"CTCAC\",$H9*C9,$I9*C9)","v":0},0,0,null,null,"","",0,null,null,{"$f":"IF($D9<=0.3,$C9,0)","v":0},0,0,0,0,{"$f":"SUM(Z9:AI9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(ISNUMBER($N9),$N9-$L9,0)","v":0},0,0,null,0,0,null,0,{"$f":"_xlfn.XLOOKUP(B9,'drop down menus'!$G$34:$G$39,'drop down menus'!$H$34:$H$39,\"\")","v":""},0,0]
[null,null,0,null,null,null,null,{"$f":"IF(G10=\"CTCAC\",_xlfn.XLOOKUP($B10&$D10,'drop down menus'!$E$69:$E$134,'drop down menus'!$H$69:$H$134,\"Error\"),\"\")","v":""},null,0,0,0,null,null,"","",0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(ISNUMBER($N10),$N10-$L10,0)","v":0},0,0,null,0,0,null,0,{"$f":"_xlfn.XLOOKUP(B10,'drop down menus'!$G$34:$G$39,'drop down menus'!$H$34:$H$39,\"\")","v":""},0,0]
[null,null,0,null,null,null,null,{"$f":"IF(G11=\"CTCAC\",_xlfn.XLOOKUP($B11&$D11,'drop down menus'!$E$69:$E$134,'drop down menus'!$H$69:$H$134,\"Error\"),\"\")","v":""},null,0,0,0,null,null,"","",0,null,null,0,0,0,0,0,0,0,{"$f":"IF(($F11=AA$6),$C11,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,null,0,0,null,0,{"$f":"_xlfn.XLOOKUP(B11,'drop down menus'!$G$34:$G$39,'drop down menus'!$H$34:$H$39,\"\")","v":""},0,0]
[null,null,0,null,null,null,null,{"$f":"IF(G12=\"CTCAC\",_xlfn.XLOOKUP($B12&$D12,'drop down menus'!$E$69:$E$134,'drop down menus'!$H$69:$H$134,\"Error\"),\"\")","v":""},null,0,0,0,null,null,"","",0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,null,0,0,null,0,{"$f":"_xlfn.XLOOKUP(B12,'drop down menus'!$G$34:$G$39,'drop down menus'!$H$34:$H$39,\"\")","v":""},0,0]
[null,null,0,null,null,null,null,{"$f":"IF(G13=\"CTCAC\",_xlfn.XLOOKUP($B13&$D13,'drop down menus'!$E$69:$E$134,'drop down menus'!$H$69:$H$134,\"Error\"),\"\")","v":""},null,0,0,0,null,null,"","",0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,null,0,0,null,0,{"$f":"_xlfn.XLOOKUP(B13,'drop down menus'!$G$34:$G$39,'drop down menus'!$H$34:$H$39,\"\")","v":""},0,0]
[null,null,0,null,null,null,null,{"$f":"IF(G14=\"CTCAC\",_xlfn.XLOOKUP($B14&$D14,'drop down menus'!$E$69:$E$134,'drop down menus'!$H$69:$H$134,\"Error\"),\"\")","v":""},null,0,0,0,null,null,"","",0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,null,0,0,null,0,{"$f":"_xlfn.XLOOKUP(B14,'drop down menus'!$G$34:$G$39,'drop down menus'!$H$34:$H$39,\"\")","v":""},0,0]
[null,null,0,null,null,null,null,{"$f":"IF(G15=\"CTCAC\",_xlfn.XLOOKUP($B15&$D15,'drop down menus'!$E$69:$E$134,'drop down menus'!$H$69:$H$134,\"Error\"),\"\")","v":""},null,0,0,0,null,null,"","",0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,null,0,0,null,0,{"$f":"_xlfn.XLOOKUP(B15,'drop down menus'!$G$34:$G$39,'drop down menus'!$H$34:$H$39,\"\")","v":""},0,0]
[null,null,0,null,null,null,null,{"$f":"IF(G16=\"CTCAC\",_xlfn.XLOOKUP($B16&$D16,'drop down menus'!$E$69:$E$134,'drop down menus'!$H$69:$H$134,\"Error\"),\"\")","v":""},null,0,0,0,null,null,"","",0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,null,0,0,null,0,{"$f":"_xlfn.XLOOKUP(B16,'drop down menus'!$G$34:$G$39,'drop down menus'!$H$34:$H$39,\"\")","v":""},0,0]
[null,null,0,null,null,null,null,{"$f":"IF(G17=\"CTCAC\",_xlfn.XLOOKUP($B17&$D17,'drop down menus'!$E$69:$E$134,'drop down menus'!$H$69:$H$134,\"Error\"),\"\")","v":""},null,0,0,0,null,null,"","",0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,null,0,0,null,0,{"$f":"_xlfn.XLOOKUP(B17,'drop down menus'!$G$34:$G$39,'drop down menus'!$H$34:$H$39,\"\")","v":""},0,0]
[null,null,0,null,null,null,null,{"$f":"IF(G18=\"CTCAC\",_xlfn.XLOOKUP($B18&$D18,'drop down menus'!$E$69:$E$134,'drop down menus'!$H$69:$H$134,\"Error\"),\"\")","v":""},null,0,0,0,null,null,"","",0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,null,0,0,null,0,{"$f":"_xlfn.XLOOKUP(B18,'drop down menus'!$G$34:$G$39,'drop down menus'!$H$34:$H$39,\"\")","v":""},0,0]
[null,null,0,null,null,null,null,{"$f":"IF(G19=\"CTCAC\",_xlfn.XLOOKUP($B19&$D19,'drop down menus'!$E$69:$E$134,'drop down menus'!$H$69:$H$134,\"Error\"),\"\")","v":""},null,0,0,0,null,null,"","",0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,null,0,0,null,0,{"$f":"_xlfn.XLOOKUP(B19,'drop down menus'!$G$34:$G$39,'drop down menus'!$H$34:$H$39,\"\")","v":""},0,0]
[null,null,0,null,null,null,null,{"$f":"IF(G20=\"CTCAC\",_xlfn.XLOOKUP($B20&$D20,'drop down menus'!$E$69:$E$134,'drop down menus'!$H$69:$H$134,\"Error\"),\"\")","v":""},null,0,0,0,null,null,"","",0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,null,0,0,null,0,{"$f":"_xlfn.XLOOKUP(B20,'drop down menus'!$G$34:$G$39,'drop down menus'!$H$34:$H$39,\"\")","v":""},0,0]
[null,null,0,null,null,null,null,{"$f":"IF(G21=\"CTCAC\",_xlfn.XLOOKUP($B21&$D21,'drop down menus'!$E$69:$E$134,'drop down menus'!$H$69:$H$134,\"Error\"),\"\")","v":""},null,0,0,0,null,null,"","",0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,null,0,0,null,0,{"$f":"_xlfn.XLOOKUP(B21,'drop down menus'!$G$34:$G$39,'drop down menus'!$H$34:$H$39,\"\")","v":""},0,0]
[null,null,0,null,null,null,null,{"$f":"IF(G22=\"CTCAC\",_xlfn.XLOOKUP($B22&$D22,'drop down menus'!$E$69:$E$134,'drop down menus'!$H$69:$H$134,\"Error\"),\"\")","v":""},null,0,0,0,null,null,"","",0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,null,0,0,null,0,{"$f":"_xlfn.XLOOKUP(B22,'drop down menus'!$G$34:$G$39,'drop down menus'!$H$34:$H$39,\"\")","v":""},0,0]
[null,null,0,null,null,null,null,{"$f":"IF(G23=\"CTCAC\",_xlfn.XLOOKUP($B23&$D23,'drop down menus'!$E$69:$E$134,'drop down menus'!$H$69:$H$134,\"Error\"),\"\")","v":""},null,0,0,0,null,null,"","",0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,null,0,0,null,0,{"$f":"_xlfn.XLOOKUP(B23,'drop down menus'!$G$34:$G$39,'drop down menus'!$H$34:$H$39,\"\")","v":""},0,0]
[null,null,0,null,null,null,null,{"$f":"IF(G24=\"CTCAC\",_xlfn.XLOOKUP($B24&$D24,'drop down menus'!$E$69:$E$134,'drop down menus'!$H$69:$H$134,\"Error\"),\"\")","v":""},null,0,0,0,null,null,"","",0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,null,0,0,null,0,{"$f":"_xlfn.XLOOKUP(B24,'drop down menus'!$G$34:$G$39,'drop down menus'!$H$34:$H$39,\"\")","v":""},0,0]
[null,null,0,null,null,null,null,{"$f":"IF(G25=\"CTCAC\",_xlfn.XLOOKUP($B25&$D25,'drop down menus'!$E$69:$E$134,'drop down menus'!$H$69:$H$134,\"Error\"),\"\")","v":""},null,0,0,0,null,null,"","",0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,null,0,0,null,0,{"$f":"_xlfn.XLOOKUP(B25,'drop down menus'!$G$34:$G$39,'drop down menus'!$H$34:$H$39,\"\")","v":""},0,0]
[null,null,{"$f":"SUM(C7:C25)","v":0},null,null,null,null,null,null,null,null,null,null,"*If using a non-LACDA rental subsidy source, write name here",null,"Subtotal Monthly Income",{"$f":"SUM(Q7:Q25)","v":0},null,null,{"$f":"SUM($T7:$T25)","v":0},{"$f":"SUM($U7:$U25)","v":0},{"$f":"SUM($V7:$V25)","v":0},{"$f":"SUM($W7:$W25)","v":0},{"$f":"SUM($X7:$X25)","v":0},{"$f":"SUM($Y7:$Y25)","v":0},{"$f":"SUM(Z$7:Z$25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AN$7:AN$25)","v":0},{"$f":"SUM(AO$7:AO$25)","v":0},{"$f":"SUM(AP$7:AP$25)","v":0},null,{"$f":"SUM(AR$7:AR$25)","v":0},{"$f":"SUM(AS$7:AS$25)","v":0},null,{"$f":"SUM(AU7:AU25)/X26","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(AW7:AW25)","v":0},{"$f":"SUM(AX7:AX25)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal SN Income",{"$f":"AO26+AR26","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal Non-SN Income",{"$f":"AS26","v":0}]
[]
[null,"For tax credit projects, assisted units must be the greater of 15 units or 20% of total project units and be set aside for a qualifying Special Needs population."]
[null,"For projects that do not use tax credits, assisted units must be equal to 20% of total project units and be set aside for a qualifying Special Needs population."]
[]
[null,"Manager's Unit(s)"]
[null,"Unit Size","Number of Unit(s)","Monthly Rent","Total Monthly Rent","FT/PT"]
[null,null,0,0,{"$f":"C35*D35","v":0},"(Select)"]
[null,null,0,0,{"$f":"C36*D36","v":0},"(Select)"]
[null,null,0,0,{"$f":"C37*D37","v":0},"(Select)"]
[null,null,0,0,{"$f":"C38*D38","v":0},"(Select)"]
[null,"Total Units",{"$f":"SUM(C35:C38)","v":0},null,"Subtotal Rents",{"$f":"SUM(E35:E38)","v":0}]
[]
[null,"Market Rate Units"]
[null,"Unit Size","Number of Unit(s)","Monthly Rent","Total Monthly Rent"]
[null,null,0,0,{"$f":"C43*D43","v":0}]
[null,null,0,0,{"$f":"C44*D44","v":0}]
[null,null,0,0,{"$f":"C45*D45","v":0}]
[null,null,0,0,{"$f":"C46*D46","v":0}]
[null,null,0,0,{"$f":"C47*D47","v":0}]
[null,"Total Units",{"$f":"SUM(C43:C47)","v":0},null,{"$f":"SUM(E43:E47)","v":0}]
[]
[]
[null,null,null,null,"Special Needs Populations"]
[null,null,null,null,"Homeless",null,{"$f":"Z26","v":0}]
[null,null,null,null,"Homeless Seniors",null,{"$f":"AA26","v":0}]
[null,null,null,null,"Chronically Homeless",null,{"$f":"AB26","v":0}]
[null,"Non-Special Needs (SN) Populations",null,null,"Homeless Veterans",null,{"$f":"AC26","v":0}]
[null,"General Affordable Extremely - Low Income",null,{"$f":"AJ26","v":0},"Homeless Persons Living with a Mental Illness",null,{"$f":"AD26","v":0}]
[null,"General Affordable - Family",null,{"$f":"AK26","v":0},"Persons Living with HIV/AIDS",null,{"$f":"AF26","v":0}]
[null,"General Affordable - Seniors",null,{"$f":"AL26","v":0},"Persons with Intellectual and Developmental Disabilities",null,{"$f":"AG26","v":0}]
[null,"Market Rate",null,{"$f":"$C$48","v":0},"Transition Age Youth (Homeless and At-Risk)",null,{"$f":"AH26","v":0}]
[null,"Manager Unit/s",null,{"$f":"$C$39","v":0},"Survivors of DV / HT / SA",null,{"$f":"AI26","v":0}]
[null,"TOTAL Non-SN Non-HM Units",null,{"$f":"SUM(D56:D60)","v":0},"TOTAL SN Units",null,{"$f":"SUM(G52:G60)","v":0}]
[]
[null,"TOTAL # OF UNITS",null,{"$f":"SUM(D61+G61+J61)","v":0}]
[]
[null,"AGGREGATE MONTHLY RENTS",null,null,null,{"$f":"SUM(E48+F39+AR26+AS26)","v":0}]
[null,"FOR ALL UNITS"]
[]
[null,"AGGREGATE ANNUAL",null,null,null,{"$f":"F65*12","v":0}]
[null,"RENTS FOR ALL UNITS"]
[]
[null,"Rent Subsidy Premium"]
[]
[null,"Total Annual Rental Subsidy",null,null,null,{"$f":"AP26","v":0}]
[]
[null,"Commercial Component"]
[]
[null,"Monthly Rent",null,null,null,0,"/Mo."]
[null,"Type of Lease"]
[null,"Initial Lease Term",null,null,null,null,"Years"]
[null,"Total Annual Commercial Rental Income",null,null,null,{"$f":"F77*12","v":0}]
[]
[]
[null,"Miscellaneous Income"]
[]
[null,"Annual Income from Laundry Facilities",null,null,null,0]
[null,"Annual Income from Vending Machines",null,null,null,0]
[null,"Annual Interest Income",null,null,null,0]
[null,"Other Annual Income (Specify)",null,null,null,0]
[null,"Total Miscellaneous Income",null,null,null,{"$f":"SUM(F85:F88)","v":0}]
[]
[null,"TOTAL ANNUAL POTENTIAL GROSS INCOME",null,null,null,{"$f":"F68+F89+F73","v":0}]
[null,"(From Residential Sources)"]
[]
[null,"Utility Allowances"]
[null,"Utility allowance must be itemized and correlate with the local Housing Authority's utility allowance schedule."]
[]
[null,null,null,"STUDIO","1 BR","2 BR ","3 BR","4 BR","5 BR"]
[null,"Space Heating"]
[null,"Water Heating"]
[null,"Cooking"]
[null,"Lighting"]
[null,"Other (Specify)"]
[null,"TOTAL",null,{"$f":"SUM(D98:D102)","v":0},{"$f":"SUM(E98:E102)","v":0},{"$f":"SUM(F98:F102)","v":0},{"$f":"SUM(G98:G102)","v":0},{"$f":"SUM(H98:H102)","v":0},{"$f":"SUM(I98:I102)","v":0}]
[]
[null,"PHA Providing Utility Allowances:"]
[]
[null,"Is the above utility allowances based on a CUAC estimate?\n Y or N"]
[]
[]
[null,"Rental Subsidies"]
[]
[null,"Subsidy Source","Subsidy Program","Date of Application (actual or anticipated)","Date of Award (actual or anticipated)","Initial Term of Subsidy (years)","Number of Subsidized Units","Target AMI"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Total",{"$f":"SUM(G113:G121)","v":0}]
[]
[null,"Name of Source listed above"]
[null,"Contact Name"]
[null,"Street Address"]
[null,"City/State"]
[null,"Phone Number"]
[null,"Fax Number"]
[null,"Email Address"]
[null,"Committed (menu selection)","(Select)"]
[]
[null,"Name of Source listed above"]
[null,"Contact Name"]
[null,"Street Address"]
[null,"City/State"]
[null,"Phone Number"]
[null,"Fax Number"]
[null,"Email Address"]
[null,"Committed (menu selection)","(Select)"]
[]
[null,"Name of Source listed above"]
[null,"Contact Name"]
[null,"Street Address"," "]
[null,"City/State"]
[null,"Phone Number"]
[null,"Fax Number"]
[null,"Email Address"]
[null,"Committed (menu selection)","(Select)"]
[]
[]
[]
[null,"Allowable Rents by Funding Source"]
[null,"Insert the project's funding sources and the allowable rents that can be charged for each unit type and Area Median Income (AMI) level. Replace \"Source\" with the funding source name (e.g. \"VHHP\").  Add funding sources and rows as necessary.\nReplace \"Source\" with the funding source name (e.g. \"VHHP\").  Add funding sources and rows as necessary."]
[]
[]
[null,"Unit Information",null,"Allowable Rents by Funding Source"]
[null,"Unit Number","# of Bedrooms","Source","Source","Source","Source"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["END OF WORKSHEET"]

{"sheet":"D.6 20-Year Cash Flow","index":8,"n_rows":84,"n_cols":22,"rows_kept":84,"cut":false,"hidden":false,"merged":[[2,0,2,8],[1,20,1,21],[83,0,83,21]]}
[]
["D.6  20-Year Cash Flow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Application Instructions'!D5","v":0}]
[]
[{"$f":"IF('Application Instructions'!D5<>\"\",'Application Instructions'!D5,\"\")","v":""},null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[]
["Gross Potential Income - SN Residential Rent",2.5000000000000001E-2,{"$f":"+'D.5 Unit Mix, Rents, Subsidy'!AR26*12","v":0},{"$f":"C6*(1+$B$6)","v":0},{"$f":"D6*(1+$B$6)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Gross Potential Income - General Affordable Residential Rent",2.5000000000000001E-2,{"$f":"+'D.5 Unit Mix, Rents, Subsidy'!AS26*12","v":0},{"$f":"C7*(1+$B$6)","v":0},{"$f":"D7*(1+$B$6)","v":0},{"$f":"E7*(1+$B$6)","v":0},{"$f":"F7*(1+$B$6)","v":0},{"$f":"G7*(1+$B$6)","v":0},{"$f":"H7*(1+$B$6)","v":0},{"$f":"I7*(1+$B$6)","v":0},{"$f":"J7*(1+$B$6)","v":0},{"$f":"K7*(1+$B$6)","v":0},{"$f":"L7*(1+$B$6)","v":0},{"$f":"M7*(1+$B$6)","v":0},{"$f":"N7*(1+$B$6)","v":0},{"$f":"O7*(1+$B$6)","v":0},{"$f":"P7*(1+$B$6)","v":0},{"$f":"Q7*(1+$B$6)","v":0},{"$f":"R7*(1+$B$6)","v":0},{"$f":"S7*(1+$B$6)","v":0},{"$f":"T7*(1+$B$6)","v":0},{"$f":"U7*(1+$B$6)","v":0}]
["Gross Potential Income - Rent Subsidy",2.5000000000000001E-2,{"$f":"+'D.5 Unit Mix, Rents, Subsidy'!F73","v":0},{"$f":"C8*(1+$B$8)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Project-funded Capitalized Subsidy Reserve"]
["Gross Potential Income - Commercial",2.5000000000000001E-2,{"$f":"'D.5 Unit Mix, Rents, Subsidy'!F80","v":0},{"$f":"C10*(1+$B$10)","v":0},{"$f":"D10*(1+$B$10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Miscellaneous Income",2.5000000000000001E-2,{"$f":"+'D.5 Unit Mix, Rents, Subsidy'!F89","v":0},{"$f":"C12*(1+$B$12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Vacancy Loss - SN Residential Rent",0.1,{"$f":"-(C6)*$B14","v":0},{"$f":"-(D6)*$B14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"-(R6)*$B14","v":0},0,0,0,0]
["Vacancy Loss - General Affordable Residential Rent",0.05,{"$f":"-(C7)*$B15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Vacancy Loss - Rent Subsidy",0.1,{"$f":"-C8*$B16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"-R8*$B16","v":0},{"$f":"-S8*$B16","v":0},{"$f":"-T8*$B16","v":0},{"$f":"-U8*$B16","v":0},{"$f":"-V8*$B16","v":0}]
["Vacancy Loss - Commercial",0.1,{"$f":"-C10*$B17","v":0},{"$f":"-D10*$B17","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"-R10*$B17","v":0},{"$f":"-S10*$B17","v":0},{"$f":"-T10*$B17","v":0},{"$f":"-U10*$B17","v":0},{"$f":"-V10*$B17","v":0}]
["Vacancy Loss - Miscellaneous Income",0.1,{"$f":"-C12*$B18","v":0},{"$f":"-D12*$B18","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"-R12*$B18","v":0},{"$f":"-S12*$B18","v":0},{"$f":"-T12*$B18","v":0},{"$f":"-U12*$B18","v":0},{"$f":"-V12*$B18","v":0}]
[]
["EFFECTIVE GROSS INCOME",null,{"$f":"SUM(C6:C18)","v":0},{"$f":"SUM(D6:D18)","v":0},{"$f":"SUM(E6:E18)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Operating Expenses - Residential",3.5000000000000003E-2,{"$f":"-('D.4 Operating Budget w Notes'!C49-'D.4 Operating Budget w Notes'!C44-'D.4 Operating Budget w Notes'!C13-'D.4 Operating Budget w Notes'!C12)","v":0},{"$f":"C22*(1+$B22)","v":0},{"$f":"D22*(1+$B22)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Operating Expenses - Commercial",3.5000000000000003E-2,{"$f":"-'D.4 Operating Budget w Notes'!F49","v":0},{"$f":"C23*(1+$B23)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Property Management Fee",0,{"$f":"-'D.4 Operating Budget w Notes'!C13","v":0},{"$f":"C24*(1+$B24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Real Estate Taxes & Assessments - Residential",0.02,{"$f":"-'D.4 Operating Budget w Notes'!C44","v":0},{"$f":"C25*(1+$B25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Real Estate Taxes & Assessments - Commercial",0.02,{"$f":"-'D.4 Operating Budget w Notes'!F44","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Supportive Services",3.5000000000000003E-2,{"$f":"-'D.4 Operating Budget w Notes'!C12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Replacement Reserve - Residential",0,{"$f":"-'D.4 Operating Budget w Notes'!C53","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Cumulative Replacement Reserve - Residential",null,{"$f":"-C28","v":0},{"$f":"IF(C29-D28>0,C29-D28,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Replacement Reserve - Commercial",0,{"$f":"-'D.4 Operating Budget w Notes'!F53","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Cumulative Replacement Reserve - Commercial",null,{"$f":"-C30","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Operating Reserve",0,{"$f":"-'D.4 Operating Budget w Notes'!C52","v":0},{"$f":"C32*(1+$B32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Cumulative Operating Reserve",null,{"$f":"-C32","v":0},{"$f":"IF(C33-D32>0,C33-D32,0)","v":0},{"$f":"IF(D33-E32>0,D33-E32,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Transition Reserve",0,{"$f":"-'D.4 Operating Budget w Notes'!C54","v":0},{"$f":"C34*(1+$B34)","v":0},{"$f":"D34*(1+$B34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Cumulative Transition Reserve",null,{"$f":"-C34","v":0},{"$f":"IF(C35-D34>0,C35-D34,0)","v":0},{"$f":"IF(D35-E34>0,D35-E34,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTAL OPERATING EXPENSES & RESERVES",null,{"$f":"SUM(C22:C28,C30,C32,C34)","v":0},{"$f":"SUM(D22:D28,D30,D32,D34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["NET OPERATING INCOME",null,{"$f":"SUM(C20,C36)","v":0},{"$f":"SUM(D20,D36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Residential Component",null,{"$f":"SUM(C6:C9,C12,C14:C16,C18)+SUM(C22,C24,C25,C27,C28,C32,C34)","v":0},{"$f":"SUM(D6:D9,D12,D14:D16,D18)+SUM(D22,D24,D25,D27,D28,D32,D34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Commercial Components",null,{"$f":"+C38-C40","v":0},{"$f":"+D38-D40","v":0},{"$f":"+E38-E40","v":0},{"$f":"+F38-F40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["DEBT SERVICE  "]
["LACDA Monitoring/Asset Management Pmt (55 yrs)",2.5000000000000001E-2,0,0,{"$f":"D$44*(1+$B$44)","v":0},{"$f":"E$44*(1+$B$44)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["LENDER NAME",0,0,{"$f":"C45*(1+$B45)","v":0},{"$f":"D45*(1+$B45)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["LENDER NAME",0,0,{"$f":"C46*(1+$B46)","v":0},{"$f":"D46*(1+$B46)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["LENDER NAME",0,0,{"$f":"C47*(1+$B47)","v":0},{"$f":"D47*(1+$B47)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["ANNUAL DEBT SERVICE RESIDENTIAL",null,{"$f":"SUM(C44:C47)","v":0},{"$f":"SUM(D44:D47)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Debt Service Coverage Ratio (Residential NOI)",null,{"$f":"IF(C49=0,\"N/A\",-C38/C49)","v":"N/A"},{"$f":"IF(D49=0,\"N/A\",-D38/D49)","v":"N/A"},"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[]
["NET CASH FLOW",null,{"$f":"C38+C49","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["Potential Aggregate Partnership and Asset Management Fee",0,{"$f":"SUM(C56:C57)","v":0},{"$f":"SUM(D56:D57)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Potential Fee to LP Tax Credit Investor (through TC period)",{"$f":"B55","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!J60),'D.4 Operating Budget w Notes'!C59,IF(C4>'D.4 Operating Budget w Notes'!J60,0,'D.4 Operating Budget w Notes'!C59))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$60),C56+(C56*$B$56),\nIF(D4>'D.4 Operating Budget w Notes'!$J$60,0,C56+(C56*$B$56)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$60),D56+(D56*$B$56),\nIF(E4>'D.4 Operating Budget w Notes'!$J$60,0,D56+(D56*$B$56)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$60),E56+(E56*$B$56),\nIF(F4>'D.4 Operating Budget w Notes'!$J$60,0,E56+(E56*$B$56)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$60),F56+(F56*$B$56),\nIF(G4>'D.4 Operating Budget w Notes'!$J$60,0,F56+(F56*$B$56)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$60),G56+(G56*$B$56),\nIF(H4>'D.4 Operating Budget w Notes'!$J$60,0,G56+(G56*$B$56)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$60),H56+(H56*$B$56),\nIF(I4>'D.4 Operating Budget w Notes'!$J$60,0,H56+(H56*$B$56)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$60),I56+(I56*$B$56),\nIF(J4>'D.4 Operating Budget w Notes'!$J$60,0,I56+(I56*$B$56)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$60),J56+(J56*$B$56),\nIF(K4>'D.4 Operating Budget w Notes'!$J$60,0,J56+(J56*$B$56)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$60),K56+(K56*$B$56),\nIF(L4>'D.4 Operating Budget w Notes'!$J$60,0,K56+(K56*$B$56)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$60),L56+(L56*$B$56),\nIF(M4>'D.4 Operating Budget w Notes'!$J$60,0,L56+(L56*$B$56)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$60),M56+(M56*$B$56),\nIF(N4>'D.4 Operating Budget w Notes'!$J$60,0,M56+(M56*$B$56)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$60),N56+(N56*$B$56),\nIF(O4>'D.4 Operating Budget w Notes'!$J$60,0,N56+(N56*$B$56)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$60),O56+(O56*$B$56),\nIF(P4>'D.4 Operating Budget w Notes'!$J$60,0,O56+(O56*$B$56)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$60),P56+(P56*$B$56),\nIF(Q4>'D.4 Operating Budget w Notes'!$J$60,0,P56+(P56*$B$56)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$60),Q56+(Q56*$B$56),\nIF(R4>'D.4 Operating Budget w Notes'!$J$60,0,Q56+(Q56*$B$56)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$60),R56+(R56*$B$56),\nIF(S4>'D.4 Operating Budget w Notes'!$J$60,0,R56+(R56*$B$56)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$60),S56+(S56*$B$56),\nIF(T4>'D.4 Operating Budget w Notes'!$J$60,0,S56+(S56*$B$56)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$60),T56+(T56*$B$56),\nIF(U4>'D.4 Operating Budget w Notes'!$J$60,0,T56+(T56*$B$56)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$60),U56+(U56*$B$56),\nIF(V4>'D.4 Operating Budget w Notes'!$J$60,0,U56+(U56*$B$56)))","v":0}]
["Potential Fee to GP",{"$f":"B55","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!J62),'D.4 Operating Budget w Notes'!C61,IF(C4>'D.4 Operating Budget w Notes'!J62,0,'D.4 Operating Budget w Notes'!C61))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$62),C57+(C57*$B$57),\nIF(D4>'D.4 Operating Budget w Notes'!$J$62,0,C57+(C57*$B$57)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$62),D57+(D57*$B$57),\nIF(E4>'D.4 Operating Budget w Notes'!$J$62,0,D57+(D57*$B$57)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$62),E57+(E57*$B$57),\nIF(F4>'D.4 Operating Budget w Notes'!$J$62,0,E57+(E57*$B$57)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$62),F57+(F57*$B$57),\nIF(G4>'D.4 Operating Budget w Notes'!$J$62,0,F57+(F57*$B$57)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$62),G57+(G57*$B$57),\nIF(H4>'D.4 Operating Budget w Notes'!$J$62,0,G57+(G57*$B$57)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$62),H57+(H57*$B$57),\nIF(I4>'D.4 Operating Budget w Notes'!$J$62,0,H57+(H57*$B$57)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$62),I57+(I57*$B$57),\nIF(J4>'D.4 Operating Budget w Notes'!$J$62,0,I57+(I57*$B$57)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$62),J57+(J57*$B$57),\nIF(K4>'D.4 Operating Budget w Notes'!$J$62,0,J57+(J57*$B$57)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$62),K57+(K57*$B$57),\nIF(L4>'D.4 Operating Budget w Notes'!$J$62,0,K57+(K57*$B$57)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$62),L57+(L57*$B$57),\nIF(M4>'D.4 Operating Budget w Notes'!$J$62,0,L57+(L57*$B$57)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$62),M57+(M57*$B$57),\nIF(N4>'D.4 Operating Budget w Notes'!$J$62,0,M57+(M57*$B$57)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$62),N57+(N57*$B$57),\nIF(O4>'D.4 Operating Budget w Notes'!$J$62,0,N57+(N57*$B$57)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$62),O57+(O57*$B$57),\nIF(P4>'D.4 Operating Budget w Notes'!$J$62,0,O57+(O57*$B$57)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$62),P57+(P57*$B$57),\nIF(Q4>'D.4 Operating Budget w Notes'!$J$62,0,P57+(P57*$B$57)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$62),Q57+(Q57*$B$57),\nIF(R4>'D.4 Operating Budget w Notes'!$J$62,0,Q57+(Q57*$B$57)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$62),R57+(R57*$B$57),\nIF(S4>'D.4 Operating Budget w Notes'!$J$62,0,R57+(R57*$B$57)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$62),S57+(S57*$B$57),\nIF(T4>'D.4 Operating Budget w Notes'!$J$62,0,S57+(S57*$B$57)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$62),T57+(T57*$B$57),\nIF(U4>'D.4 Operating Budget w Notes'!$J$62,0,T57+(T57*$B$57)))","v":0},{"$f":"IF(ISBLANK('D.4 Operating Budget w Notes'!$J$62),U57+(U57*$B$57),\nIF(V4>'D.4 Operating Budget w Notes'!$J$62,0,U57+(U57*$B$57)))","v":0}]
["   Fee to LP Tax Credit Investor",{"$f":"B55","v":0},{"$f":"-IF(AND(C$52>0,ISNUMBER(C56)),MIN(C$52,C56))","v":0},{"$f":"-IF(AND(D$52>0,ISNUMBER(D56)),MIN(D$52,D56))","v":0},{"$f":"-IF(AND(E$52>0,ISNUMBER(E56)),MIN(E$52,E56))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["   Fee to GP",{"$f":"B55","v":0},{"$f":"-IF(AND(C$52>0,ISNUMBER(C57)),MIN(C$52,C57,C52+C58))","v":0},{"$f":"-IF(AND(D$52>0,ISNUMBER(D57)),MIN(D$52,D57,D52+D58))","v":0},{"$f":"-IF(AND(E$52>0,ISNUMBER(E57)),MIN(E$52,E57,E52+E58))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["CASH FLOW after Partnership Management Fee",null,{"$f":"IF(C58+C59+C52>0,C58+C59+C52,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Deferred Developer Fee ",null,{"$f":"-(IF(C61>0,MIN(B64,C61),0))","v":0},{"$f":"-(IF(D61>0,MIN(C64,D61),0))","v":0},{"$f":"-(IF(E61>0,MIN(D64,E61),0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Deferred Developer Fee Balance",0,{"$f":"B64+C63","v":0},{"$f":"C64+D63","v":0},0,{"$f":"E64+F63","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["CASH FLOW after Def Developer Fee Pmt",null,{"$f":"C61+C63","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["RESIDUAL RECEIPTS"]
["Borrower",0.5,{"$f":"$B$68*C65","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["LACDA",0.5,{"$f":"$B$69*C65","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["[other Residual Receipt lender]",0,{"$f":"$B$70*C65","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["[other Residual Receipt lender]",0,{"$f":"$B$71*C65","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["* Must be 10% for NPLH and SN units or 5% for General Affordable (non-SN) units"]
[]
[]
["PROJECT-FUNDED CAPITALIZED SUBSIDY RESERVE***"]
["Starting Reserve Balance",null,null,{"$f":"+C81","v":0},{"$f":"+D81","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Annual Interest on Reserve",7.4999999999999997E-3,null,{"$f":"+C78*$B79","v":0},{"$f":"+D78*$B79","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Annual Reserve Contribution",null,{"$f":"-C9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Ending Reserve Balance",null,{"$f":"SUM(C78:C80)","v":0},{"$f":"SUM(D78:D80)","v":0},{"$f":"SUM(E78:E80)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R78:R80)","v":0},{"$f":"SUM(S78:S80)","v":0},{"$f":"SUM(T78:T80)","v":0},{"$f":"SUM(U78:U80)","v":0},{"$f":"SUM(V78:V80)","v":0}]
[]
[]
["END OF WORKSHEET"]

{"sheet":"D.7.a. 9% Threshold Basis Limit","index":9,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,0,39,6],[22,2,22,4],[14,1,15,1],[15,2,15,4],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[11,1,11,3],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[34,2,34,6],[36,2,36,6],[27,2,27,4],[23,2,23,4],[26,2,26,4],[31,2,31,4],[24,2,24,4],[25,2,25,4],[32,2,32,4],[5,5,5,6],[14,2,14,4],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[10,1,10,2],[12,1,12,4],[13,1,13,4],[11,5,11,6],[14,5,15,5],[14,6,15,6],[12,5,12,6]]}
[null,null,null,null,null,null,null," "]
[null,"D.7.a  Tax Credit Threshold Basis Limit - 9% Projects",null,null,null,null,{"$f":"IF('Application Instructions'!D5<>\"\",'Application Instructions'!D5,\"\")","v":""}]
[]
[null,"Determination of Threshold Basis"]
[]
[null,"Unit Size",null,"Unit Basis Limit","No. Of Units","Basis x No. Of Units"]
[null,"Studio",null,437727,null,{"$f":"D7*E7","v":0}]
[null,"1-Bedroom",null,504695,null,{"$f":"D8*E8","v":0}]
[null,"2-Bedroom",null,608800,null,{"$f":"D9*E9","v":0}]
[null,"3-Bedroom",null,779264,null,{"$f":"D10*E10","v":0}]
[null,"4-Bedroom",null,868149,null,{"$f":"D11*E11","v":0}]
[null,"TOTAL UNITS",null,null,{"$f":"SUM(E7:E11)","v":0}]
[null,"TOTAL = Threshold Basis Limit",null,null,null,{"$f":"SUM(F7:G11)","v":0}]
[null,"Note: Items (a) through (e) and (h) below are derived/calculated from this figure. "]
[null,"(a)","Plus (+) 20% basis adjustment for projects paid in whole or part out of public funds subject to a legal requirement for the payment of state or federal prevailing wages or financed in part by a labor-affiliated organization requiring the employment of construction workers who are paid at least state or federal prevailing wages. List source(s) or labor-affiliated organization(s):\n\n",null,null,"(Select)",{"$f":"IF(F15=\"Y\",F13*I15,0)","v":0},null,0.2]
[]
[null,null,"Plus (+) 5% basis adjustment for projects that certify that (1) they are subject to a project labor agreement within the meaning of Section 2500(b)(1) of the Public Contract Code, or (2) they will use a skilled and trained workforce as defined by Section 25536.7 of the Health and Safety Code to perform all onsite work within an apprenticeable occupation in the building and construction trades.",null,null,"(Select)",{"$f":"IF(F17=\"Y\",F13*I17,0)","v":0},null,0.05]
[null,"(b)","Plus (+) 10% basis adjustment for new construction projects which are required to provide parking beneath residential units (but not “tuck under” parking) or through construction of an on-site parking structure of two or more levels.",null,null,"(Select)",{"$f":"IF(F18=\"Y\",F13*I18,0)","v":0},null,0.1]
[null,"(c) ","Plus (+) 2% basis adjustment for projects where a day care center is part of the development. ",null,null,"(Select)",{"$f":"IF(F19=\"Y\",F13*I19,0)","v":0},null,0.02]
[".","(d)","Plus (+) 2% basis adjustment for projects where 100 percent of the low-income units are for Special Needs populations.",null,null,"(Select)",{"$f":"IF(F20=\"Y\",F13*I20,0)","v":0},null,0.02]
[null,"(e)","Plus (+) up to 10% basis adjustment for projects applying under Section 10325 or Section 10326 of CTCAC's regulations that include one or more of the features in the section: Item (e) features",null,null,0,{"$f":"IF(F21=0,0,F13*F21)","v":0}]
[null,"(f)","Plus (+) the lesser of the associated costs or up to a 15% basis adjustment for projects requiring seismic upgrading of existing structures, and/ or projects requiring toxic or other environmental mitigation as certified by the project architect/engineer + costs.",null,null,null,0]
[null,"(g)","Plus (+) local development impact fees required to be paid to local government entities. Waived impact fees are ineligible.",null,null,null,0]
[null,"(h)","Plus (+) 10% basis adjustment for a development wherein at least 95% of the project’s upper floor units are serviced by an elevator. ",null,null,"(Select)",{"$f":"IF(F24=\"Y\",F13*I24,0)","v":0},null,0.1]
[null,"(i)","Plus (+) 15% basis adjustment - Type I Construction\na fifteen percent (15%) increase to the limits for a development wherein at least 95% of the building(s) is constructed as Type I as defined in the California Building Code, in which case, the Type III increase below shall not be allowed.",null,null,"(Select)",{"$f":"IF(F25=\"Y\",F13*I25,0)","v":0},null,0.15]
[null,"(j)","Plus (+) 10% basis adjustment - Type III Construction\na ten percent (10%) increase to the limits for a development wherein at least 95% of the building(s) is constructed as 1) Type III as defined in the California Building Code, or Type III/Type I combination, in which case, the Type I increase below shall not be allowed.",null,null,"(Select)",{"$f":"IF(F26=\"Y\",F13*I26,0)","v":0},null,0.1]
[null,"(k)","Plus (+) 10% basis adjustment for projects that is: (1) in a county that has an unadjusted 9% threshold basis limit for 2-bedroom units equal to or less than $400,000; AND (ii) is located in a census tract designated on the CTCAC/HCD Opportunity Area Map as Highest or High Resource",null,null,"(Select)",{"$f":"IF(F27=\"Y\",F13*I27,0)","v":0},null,0.1]
[null,null,"= Adjusted Threshold Basis Limit",null,null,null,{"$f":"SUM(F13,G15:G27)","v":0}]
[]
[null,null,"High Cost Test"]
[]
[null,null,"Total Eligible Basis",null,null,null,{"$f":"SUM('D.3 Development Budget w Notes'!G136:H136)","v":0}]
[null,null,"Percentage of the Adjusted Threshold Basis Limit:\n(Total Eligible Basis vs Adjusted Threshold Basis Limit)",null,null,null,{"$f":"IF(G32=0,\"\",G32/G28)","v":""}]
[]
[null,null,"If the Percentage of the Adjusted Threshold Basis Limit is equal to or exceeds 130%, describe how the project will adhere to CTCAC's requirements for high cost projects (per TCAC Regulation Section 10325(d))"]
[]
[]
[]
[]
["END OF WORKSHEET"]

{"sheet":"D.7.b. 9% Tax Credit Calc","index":10,"n_rows":80,"n_cols":5,"rows_kept":80,"cut":false,"hidden":false,"merged":[[3,1,3,4],[23,2,23,4],[43,2,43,4],[66,1,66,4],[79,0,79,5]]}
[]
[null,"D.7.b  Tax Credit Calculation - 9% Projects",null,null,{"$f":"IF('Application Instructions'!D5<>\"\",'Application Instructions'!D5,\"\")","v":""}]
[]
[null,"Tax credit factors shall be limited to the allowable prices defined by TCAC. "]
[]
[null,"Determination of Eligible and Qualified Basis"]
[]
[null,null,"New Construction or Rehabilitation",null,"Acquisition"]
[null,"Total Eligible Basis (from D.3)",{"$f":"'D.3 Development Budget w Notes'!G136","v":0},null,{"$f":"'D.3 Development Budget w Notes'!H136","v":0}]
[null,"Deduct From Eligible Basis:"]
[null,"Grant Proceeds Used to Finance Costs in Eligible Basis"]
[null,"Non-Qualified Non-Recourse Financing"]
[null,"Non-Qualifying Portion of Higher Quality Units"]
[null,"Photovoltaic Credit (as applicable)"]
[null,"Historic Credit (residential portion only)"]
[null,"Ineligible Basis Related to Excess Parking"]
[null,"Other ineligible amounts: _______________________"]
[null,"Total Ineligible Amounts",{"$f":"SUM(C11:C17)","v":0},null,{"$f":"SUM(E11:E17)","v":0}]
[null,"Total Eligible Basis Amount Voluntarily Excluded"]
[null,"TOTAL BASIS REDUCTION",{"$f":"-SUM(C18:C19)","v":0},null,{"$f":"-SUM(E18:E19)","v":0}]
[]
[null,"TOTAL REQUESTED UNADJUSTED ELIGIBLE BASIS",{"$f":"C9+C20","v":0},null,{"$f":"E9+E20","v":0}]
[]
[null,"TOTAL ADJUSTED THRESHOLD BASIS LIMIT",{"$f":"'D.7.a. 9% Threshold Basis Limit'!Text84","v":0}]
[]
[null,"Project located in Qualified Census Tract (CQT) or Difficult to Develop Area (DDA) Adjustment?","(Select)"]
[]
[null,"    x  QCT or DDA Adjustment",{"$f":"IF(C26=\"Yes\",130%,100%)","v":1},null,1]
[]
[null,"TOTAL ADJUSTED ELIGIBLE BASIS",{"$f":"C22*C28","v":0},null,{"$f":"E22*E28","v":0}]
[]
[null,"    x  Applicable Fraction"]
[]
[null,"QUALIFIED BASIS",{"$f":"C30*C32","v":0},null,{"$f":"E30*E32","v":0}]
[]
[null,"TOTAL QUALIFIED BASIS",null,null,{"$f":"C34+E34","v":0}]
[]
[]
[null,"Determination of Federal Credit"]
[null,null,"New Construction or Rehabilitation",null,"Acquisition"]
[null,"1. Qualified Basis",{"$f":"IF(C24>=(C22+E22),C34,0)","v":0},null,{"$f":"IF(C24>=(C22+E22),E34,0)","v":0}]
[null,"2. Applicable Percentage (from TCAC 2022 application)",0.09,null,0.04]
[null,"3. Subtotal Annual Federal Credit",{"$f":"C41*C42","v":0},null,{"$f":"E41*E42","v":0}]
[null,"4. Total Combined Annual Credit",{"$f":"IF((C43+E43)>2500000,2500000,(C43+E43))","v":0}]
[]
[null,"Determination of Minimum Federal Credit Necessary for Feasibility"]
[]
[null,"1. Total Project Cost",{"$f":"'D.3 Development Budget w Notes'!C133","v":0}]
[null,"2. Permanent Financing",{"$f":"SUM('D.2 Sources'!H32:H47)","v":0}]
[null,"3. Funding Gap",{"$f":"C48-C49","v":0}]
[null,"4. Federal Tax Credit Factor"]
[]
[null,"Total Credits Necessary for Feasibility",{"$f":"ROUND(IF(ISERROR((C50/C51)),0,(C50/C51)),0)","v":0}]
[null,"Annual Federal Credit Necessary for Feasibility",{"$f":"C53/10","v":0}]
[null,"Maximum Annual Federal Credits",{"$f":"(IF((C44<C54),C44,C54))","v":0}]
[null,"Equity Raised from Federal Credit",{"$f":"ROUND((10*C55*C51),0)","v":0}]
[]
[null,"Remaining Funding Gap",{"$f":"C50-C56","v":0}]
[]
[]
[null,"Determination of State Credit"]
[]
[null,"Does the project include State Credit?","(Select)"]
[null,"Does the project involve State Acquisition Credit?","(Select)"]
[null,null,"New Construction or Rehabilitation",null,"Acquisition"]
[null,"1.  State Credit Basis",0,null,0]
[null,"Rehabilitation or new construction basis only (no acquisition basis), except in rare cases of At-Risk projects eligible for State Credit on the acquisition basis at the 0.13 factor when no 130% basis increase is used."]
[null,"2.   x Factor Amount"]
[null,"3.  Maximum Total State Credit",{"$f":"C66*C68","v":0},null,{"$f":"E66*E68","v":0}]
[]
[null,"Determination of Minimum State Credit Necessary for Feasibility"]
[null,"State Credit Factor"]
[null,"State Credit Necessary for Feasibility",null,null,{"$f":"ROUND(IF(ISERROR((C58/E72)),0,(C58/E72)),0)","v":0}]
[null,"Maximum State Credit",null,null,{"$f":"IF((C69+E69<E73),C69+E69,E73)","v":0}]
[null,"Equity Raised from State Credit",null,null,{"$f":"E72*E74","v":0}]
[]
[null,"Remaining Funding Gap",null,null,{"$f":"C50-(C56+E75)","v":0}]
[]
[]
["END OF WORKSHEET"]

{"sheet":"4% Tiebreaker","index":11,"n_rows":105,"n_cols":12,"rows_kept":105,"cut":false,"hidden":true,"merged":[[104,0,104,12],[82,4,82,5],[75,3,75,4],[76,3,76,4],[77,3,77,4],[77,5,77,6],[101,1,101,6],[101,7,101,8],[83,4,84,5],[97,1,97,6],[97,7,97,8],[98,1,98,6],[98,7,98,8],[99,1,99,6],[99,7,99,8],[93,1,93,6],[94,1,94,6],[94,7,94,8],[95,1,95,6],[96,1,96,6],[86,4,86,5],[34,5,34,6],[62,1,62,12],[78,7,78,8],[70,7,71,8],[72,7,72,8],[73,7,73,8],[81,4,81,5],[80,4,80,5],[72,3,72,4],[73,3,73,4],[74,3,74,4],[70,5,71,6],[72,5,72,6],[73,5,73,6],[74,5,74,6],[77,7,77,8],[66,1,66,14],[70,3,71,4],[49,1,49,3],[49,4,50,4],[49,5,50,5],[49,6,49,9],[39,8,39,9],[52,5,52,6],[29,5,29,6],[11,5,11,6],[11,1,11,3],[24,5,24,6],[27,1,27,3],[22,5,22,6],[25,5,25,6],[19,5,19,6],[20,1,20,3],[27,5,27,6],[21,5,21,6],[21,1,21,3],[22,1,22,3],[6,1,6,3],[6,6,6,9],[7,1,7,3],[7,6,7,9],[6,5,7,5],[6,4,7,4],[19,1,19,3],[20,5,20,6],[17,5,17,6],[18,5,18,6],[12,5,12,6],[13,5,13,6],[16,1,16,3],[17,1,17,3],[18,1,18,3],[1,10,1,12],[20,11,20,12],[39,11,39,12],[40,11,40,12],[45,8,46,9],[45,10,45,12],[44,10,44,12],[6,10,7,10],[19,11,19,12],[18,11,18,12],[39,5,39,6],[40,5,40,6],[38,5,38,6],[75,7,75,8],[76,7,76,8],[74,7,74,8],[75,5,75,6],[76,5,76,6],[59,5,59,6],[50,6,50,9],[57,2,57,12],[50,1,50,3],[47,10,47,12],[44,5,44,6],[45,5,45,6],[47,5,47,6],[61,1,61,10],[49,10,50,10]]}
[]
[null,"D.7.c  Tax Credit - 9% Projects Tie Breaker Self-Score",null,null,null,null,null,null,null,null,{"$f":"IF('Application Instructions'!D5<>\"\",'Application Instructions'!D5,\"\")","v":""}]
[]
[null,"Tie Breaker Formula"]
[]
[]
[null,"Committed Permanent Leveraged Soft Financing Defraying Residential Costs \nX Size Factor",null,null,"\n\n+"," \n \n(( 1  ¾   ","Requested Unadjusted Eligible Basis",null,null,null," \n \n) / 2)"]
[null,"Total residential project development costs",null,null,null,null,"Total residential project development costs"]
[]
[null,"Soft Financing, Committed"]
[]
[null,"Capitalized Value of Rent Differentials of Public Rent or Operating Subsidies\n(Calculated Below)"]
[null,"Total donated land value"]
[null,"Total fee waivers"]
[]
[null,"List leveraged soft financing, excluding donated land and fee waivers:",null,null,null,null,null,null,"HYBRID PROJECT (NEW CONSTRUCTION)"]
[null,null,null,null,null,null,null,null,"4% Development Project Costs:"]
[]
[null,null,null,null,null,null,null,null,"Residential Project Development Cost"]
[null,null,null,null,null,null,null,null,"Commercial Project Development Cost"]
[null,null,null,null,null,null,null,null,"Total 4% Project Cost",null,null,{"$f":"SUM(L19:M20)","v":0}]
[]
[]
[]
[null,"Less Excess Purchase Price Over Appraised Value"]
[null,"Less Ineligible Offsites"]
[]
[null,"Total leveraged soft financing excluding donated land and fee waivers",null,null,null,{"$f":"SUM(F18:G23)-F25-F26","v":0}]
[]
[null,"Total",null,null,null,{"$f":"SUM(F12:G14)+F28","v":0}]
[]
[]
[null,"Mixed Use Projects"]
[]
[null,"Total commercial cost / Total project cost",null,null,null,{"$f":"IF('D.3 Development Budget w Notes'!C133=0,0,('D.3 Development Budget w Notes'!E133+L20)/('D.3 Development Budget w Notes'!C133+L21))","v":0}]
[]
[null,"Size Factor Calculation"]
[]
[null,"New Construction:",null,null,null,"(Select)",null,null,"HYBRID (NEW CONSTRUCTION) - 4% Development Units"]
[null,"Amount of 9% Tax Credit Units",null,null,null,null,null,null,"Amount of 4% Tax Credit Units"]
[null,"Size Factor",null,null,null,{"$f":"MIN(IF(AND(F39=\"YES\",L41>=50),(0.75+(L41/200)),1),1.5)","v":1},null,null,null,"Total Tax Credit Units",null,{"$f":"F40+L40","v":0}]
[]
[null,"Final Tie Breaker Calculation"]
[]
[null,"Leveraged Soft Financing less commercial portion",null,null,null,{"$f":"F30*(1-F35)","v":0},null,null,"Residential Development Costs",null,{"$f":"'D.3 Development Budget w Notes'!D133","v":0}]
[null,"Leveraged Soft Financing times Size Factor",null,null,null,{"$f":"F45*F41","v":0},null,null,"less ineligible offisites and excess purchase price as a % of res. costs",null,{"$f":"-((1-F35)*(F25+F26))","v":0}]
[]
[null,"Requested unadjusted eligible Basis",null,null,null,{"$f":"'D.7.b. 9% Tax Credit Calc'!C22+'D.7.b. 9% Tax Credit Calc'!E22","v":0},null,null,"Total Residential Development Costs",null,{"$f":"K45+K46","v":0}]
[]
[null,{"$f":"F46","v":0},null,null,"+","(( 1  ¾   ",{"$f":"F48","v":0},null,null,null,") / 2)"]
[null,{"$f":"K48","v":0},null,null,null,null,{"$f":"K48","v":0}]
[]
[null,"Tie Breaker Self-Score",null,null,null,{"$f":"IF(OR(B50=0,G50=0),0,IF(OR(B51<>0,G51<>0),((B50/B51)+((1-(G50/G51))/2)),0))","v":0}]
[]
[null,"BONUS for new construction large-family projects in high/higher resource areas based on TCAC/HCD Opportunity Area Map"]
[null,"Please see TCAC Regulations 10325(c)(9)(C) for projects excluded:"]
[]
[null,{"$f":"IF(C58='drop down menus'!G23,0.2,IF(C58='drop down menus'!G24,0.1,IF(C58='drop down menus'!G25,0.1,IF(C58='drop down menus'!G26,0.05,0))))","v":0},"(Select)"]
[]
[null,"FINAL TIE BREAKER SELF-SCORE",null,null,null,{"$f":"F53+B58","v":0}]
[]
[null,"If tie breaker self-score is less than 40%, please explain how project will be competitive."]
[]
[]
[]
[null,"Continued below."]
[null,"CAPITALIZED VALUE OF RENT DIFFERENTIALS ATTRIBUTABLE TO PUBLIC RENT OR PUBLIC OPERATING SUBSIDIES CALCULATION"]
[]
[null,"Annual Rental Income Differential for Public Rent Subsidies:"]
[]
[null,null,null,"Monthly Rent Limit:\nUse 30% AMI for Special Needs Projects",null,"Monthly Public Subsidy Contract Rent",null,"Calculated Annual Rent"]
[null,"Unit Type","# of Units"]
[null,"1 bedroom",3,1040,null,1791,null,{"$f":"((F73-D73)*C73)*12","v":27036}]
[null,"1 bedroom",12,1040,null,1791,null,108144]
[null,"2 bedroom",11,1248,null,2259,null,133452]
[null,"SELECT",null,null,null,null,null,0]
[null,"SELECT",null,null,null,null,null,0]
[null,"SELECT",null,null,null,null,null,0]
[null,null,null,null,null,"Annual Rent Differential for Public Rent Subsidies:",null,{"$f":"SUM(H73:H78)","v":268632}]
[]
[null,"Total Rent Differentials",null,null,{"$f":"H79+H102","v":268632},null,null,"Loan Term (years)",null,15]
[null,"Less Vacancy",null,null,0.05,null,null,"Interest Rate (annual)",null,0.04]
[null,"Net Rental Income",null,null,{"$f":"E81-(E81*E82)","v":255200.4},null,null,"Debt Coverage Ratio",null,1.1499999999999999]
[null,"Available for Debt Service",null,null,{"$f":"IF(J83=\"\",0,E83/J83)","v":221913.39130434784}]
[null,{"$f":"CONCATENATE(\"@ \",J83,\" Debt Coverage Ratio:\")","v":"@ 1.15 Debt Coverage Ratio:"}]
[]
[null,"Capitalized Value of Rent Differentials",null,null,{"$f":"PV(J82/12,J81*12,-E84/12, ,0)","v":2500079.0155475065}]
[]
[]
[]
[]
[null,"Annual Rental Income Differential for Public Operating Subsidies:"]
[]
[null,"If annual operating subsidy amount are similar in each year, enter:"]
[null,"Annual Operating Subsidy Amount in Year 1:"]
[null,"OR\n"]
[null,"If the contract does not specify an annual subsidy amount, enter:"]
[null,"Aggregate Subsidy Amount:"]
[null,"Number of Years in the Subsidy Contract:"]
[null,"Average Annual Operating Subsidy Amount:",null,null,null,null,null,{"$f":"IF(H99=\"\",0,H98/H99)","v":0}]
[]
[null,"Annual Public Operating Subsidies:",null,null,null,null,null,{"$f":"MAX(H95,H100)","v":0}]
[]
[]
["END OF WORKSHEET"]

{"sheet":"D.8.a. 4% TC Threshold Basis","index":12,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,0,34,7],[12,1,12,4],[12,5,12,6],[8,1,8,2],[8,5,8,6],[9,1,9,2],[9,5,9,6],[10,1,10,2],[10,5,10,6],[14,6,15,6],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[13,1,13,4],[14,2,14,4],[26,8,28,8],[27,2,27,3],[28,2,28,3],[23,2,23,4],[22,2,22,4],[29,6,31,6],[30,2,30,3],[31,2,31,3],[2,2,2,3],[15,2,15,4],[5,1,5,2],[5,5,5,6],[6,1,6,2],[6,5,6,6],[7,1,7,2],[7,5,7,6],[26,6,28,6],[16,2,16,4],[26,5,28,5],[14,1,15,1],[21,2,21,4],[32,2,32,5],[25,2,25,4],[26,2,26,4],[14,5,15,5],[11,1,11,3],[24,2,24,4],[29,2,29,4],[29,5,31,5]]}
[null,null,null,null,null,null,null," "]
[null,"D.8.a Tax Credit Threshold Basis Limit - 4% Projects",null,null,null,null,{"$f":"IF('Application Instructions'!D5<>\"\",'Application Instructions'!D5,\"\")","v":""}]
[]
[null,"Determination of Threshold Basis"]
[]
[null,"Unit Size",null,"Unit Basis Limit","No. Of Units","Basis x No. Of Units",null,null,"9% Tax Credits"]
[null,"Studio",null,437727,null,{"$f":"D7*E7","v":0},null,null,218001]
[null,"1-Bedroom",null,504695,null,{"$f":"D8*E8","v":0},null,null,251353]
[null,"2-Bedroom",null,608800,null,{"$f":"D9*E9","v":0},null,null,303200]
[null,"3-Bedroom",null,779264,null,{"$f":"D10*E10","v":0},null,null,388096]
[null,"4-Bedroom",null,868149,null,{"$f":"D11*E11","v":0},null,null,432363]
[null,"TOTAL UNITS:",null,null,{"$f":"SUM(E7:E11)","v":0}]
[null,"TOTAL = Threshold Basis Limit",null,null,null,{"$f":"SUM(F7:G11)","v":0}]
[null,"Note: Items (a) through (e) and (h) below are derived/calculated from this figure. "]
[null,"(a)","Plus (+) 20% basis adjustment for projects paid in whole or part out of public funds subject to a legal requirement for the payment of state or federal prevailing wages or financed in part by a labor-affiliated organization requiring the employment of construction workers who are paid at least state or federal prevailing wages. List source(s) or labor-affiliated organization(s):\n\n",null,null,"(Select)",{"$f":"IF(F15=\"Y\",F13*I15,0)","v":0},null,0.2]
[]
[null,null,"Plus (+) 5% basis adjustment for projects that certify that (1) they are subject to a project labor agreement within the meaning of Section 2500(b)(1) of the Public Contract Code, or (2) they will use a skilled and trained workforce as defined by Section 25536.7 of the Health and Safety Code to perform all onsite work within an apprenticeable occupation in the building and construction trades.",null,null,"(Select)",{"$f":"IF(F17=\"Y\",F13*I17,0)","v":0},null,0.05]
[null,"(b)","Plus (+) 10% basis adjustment for new construction projects which are required to provide parking beneath residential units (but not “tuck under” parking) or through construction of an on-site parking structure of two or more levels.",null,null,"(Select)",{"$f":"IF(F18=\"Y\",F13*I18,0)","v":0},null,0.1]
[null,"(c) ","Plus (+) 2% basis adjustment for projects where a day care center is part of the development. ",null,null,"(Select)",{"$f":"IF(F19=\"Y\",F13*I19,0)","v":0},null,0.02]
[".","(d)","Plus (+) 2% basis adjustment for projects where 100 percent of the low-income units are for Special Needs populations.",null,null,"(Select)",{"$f":"IF(F20=\"Y\",F13*I20,0)","v":0},null,0.02]
[null,"(e)","Plus (+) up to 10% basis adjustment for projects that include one or more of the features in described in Section 10325 or Section 10326 of the TCAC Regulations: Item (e) features",null,null,"(Select)",{"$f":"IF(OR(F21=0,F21=\"(Select)\"),0,F13*F21)","v":0}]
[null,"(f)","Plus (+) the lesser of the associated costs or up to a 15% basis adjustment for projects requiring seismic upgrading of existing structures, and/ or projects requiring toxic or other environmental mitigation as certified by the project architect/engineer + costs."]
[null,"(g)","Plus (+) local development impact fees required to be paid to local government entities. Waived impact fees are ineligible."]
[null,"(h)","Plus (+) 10% basis adjustment for a development wherein at least 95% of the project’s upper floor units are serviced by an elevator. ",null,null,"(Select)",{"$f":"IF(F24=\"Y\",F13*I24,0)","v":0},null,0.1]
[null,"(i)","Plus (+) 15% basis adjustment - Type I Construction\na fifteen percent (15%) increase to the limits for a development wherein at least 95% of the building(s) is constructed as Type I as defined in the California Building Code, in which case, the Type III increase below shall not be allowed.\n\nOR\n\nPlus (+) 10% basis adjustment - Type III Construction\na ten percent (10%) increase to the limits for a development wherein at least 95% of the building(s) is constructed as 1) Type III as defined in the California Building Code, or Type III/Type I combination, in which case, the Type I increase above shall not be allowed.",null,null,"(Select)",{"$f":"IF(F25=\"Y - 15% for Type I\",F13*0.15,IF(F25=\"Y - 10% for Type III\",F13*0.1,0))","v":0}]
[null,"(j)","Plus (+) 10% basis adjustment for projects that is: (1) in a county that has an unadjusted 9% threshold basis limit for 2-bedroom units equal to or less than $500,000; AND (ii) is located in a census tract designated on the TCAC/HCD Opportunity Area Map as Highest or High Resource",null,null,"(Select)",{"$f":"IF(F26=\"Y\",F13*I26,0)","v":0},null,0.1]
[null,null,"4% Tax Credit Projects ONLY:\nPlus (+) 1% basis adjustment for each 1% of units income-targeted to 50% to 36% of AMI",null,null,null,{"$f":"IF((E28>0),F13*MROUND(E29/E28,0.01),0)","v":0}]
[null,null,"Rental Units:"]
[null,null,"Total Units @ 50% to 36% of AMI:"]
[null,null,"4% Tax Credit Projects ONLY:\nPlus (+) 2% basis adjustment for each 1% of units income-targeted to 35% of AMI and below",null,null,null,{"$f":"IF((E31=\"\"),0,2*F13*MROUND(E32/E31,0.01))","v":0}]
[null,null,"Rental Units:",null,{"$f":"IF(E28=\"\",\"\",E28)","v":""}]
[null,null,"Total Units @ 35% of AMI or less:"]
[null,null,"= Adjusted Threshold Basis Limit",null,null,null,{"$f":"SUM(F13,G15:G32)","v":0}]
[]
["END OF WORKSHEET"]

{"sheet":"D.8.b. 4% Tax Credit Calc","index":13,"n_rows":89,"n_cols":5,"rows_kept":89,"cut":false,"hidden":false,"merged":[[88,0,88,5],[3,1,3,4],[23,2,23,4],[43,2,43,4],[66,1,66,4]]}
[]
[null,"D.8.b  Tax Credit Calculation - 4% Projects",null,null,{"$f":"IF('Application Instructions'!D5<>\"\",'Application Instructions'!D5,\"\")","v":""}]
[]
[null,"Tax credit factors shall be limited to the allowable prices defined by TCAC. "]
[]
[null,"Determination of Eligible and Qualified Basis"]
[]
[null,null,"New Construction or Rehabilitation",null,"Acquisition"]
[null,"Total Eligible Basis (from D.3)",{"$f":"'D.3 Development Budget w Notes'!G135","v":0},null,{"$f":"'D.3 Development Budget w Notes'!H135","v":0}]
[null,"Deduct From Eligible Basis:"]
[null,"Grant Proceeds Used to Finance Costs in Eligible Basis"]
[null,"Non-Qualified Non-Recourse Financing"]
[null,"Non-Qualifying Portion of Higher Quality Units"]
[null,"Photovoltaic Credit (as applicable)"]
[null,"Historic Credit (residential portion only)"]
[null,"Other ineligible amounts: _______________________"]
[null,"Other ineligible amounts: _______________________"]
[null,"Total Ineligible Amounts",{"$f":"SUM(C11:C17)","v":0},null,{"$f":"SUM(E11:E17)","v":0}]
[null,"Total Eligible Basis Amount Voluntarily Excluded"]
[null,"TOTAL BASIS REDUCTION",{"$f":"-SUM(C18:C19)","v":0},null,{"$f":"-SUM(E18:E19)","v":0}]
[]
[null,"TOTAL REQUESTED UNADJUSTED ELIGIBLE BASIS",{"$f":"C9+C20","v":0},null,{"$f":"E9+E20","v":0}]
[]
[null,"TOTAL ADJUSTED THRESHOLD BASIS LIMIT",{"$f":"'D.8.a. 4% TC Threshold Basis'!Text84","v":0}]
[]
[null,"Project located in Qualified Census Tract (CQT) or Difficult to Develop Area (DDA) Adjustment?","(Select)"]
[]
[null,"    x  QCT or DDA Adjustment",{"$f":"IF(C26=\"Yes\",130%,100%)","v":1},null,1]
[]
[null,"TOTAL ADJUSTED ELIGIBLE BASIS",{"$f":"C22*C28","v":0},null,{"$f":"E22*E28","v":0}]
[]
[null,"    x  Applicable Fraction"]
[]
[null,"QUALIFIED BASIS",{"$f":"C30*C32","v":0},null,{"$f":"E30*E32","v":0}]
[]
[null,"TOTAL QUALIFIED BASIS",null,null,{"$f":"C34+E34","v":0}]
[]
[]
[null,"Determination of Federal Credit"]
[null,null,"New Construction or Rehabilitation",null,"Acquisition"]
[null,"1. Qualified Basis",{"$f":"IF(C24>=(C22+E22),C34,0)","v":0},null,{"$f":"IF(C24>=(C22+E22),E34,0)","v":0}]
[null,"2. Applicable Percentage ",0.04,null,0.04]
[null,"3. Subtotal Annual Federal Credit",{"$f":"C41*C42","v":0},null,{"$f":"E41*E42","v":0}]
[null,"4. Total Combined Annual Credit",{"$f":"(C43+E43)","v":0}]
[]
[null,"Determination of Minimum Federal Credit Necessary for Feasibility"]
[]
[null,"1. Total Project Cost",{"$f":"'D.3 Development Budget w Notes'!C133","v":0}]
[null,"2. Permanent Financing",{"$f":"SUM('D.2 Sources'!H32:H47)","v":0}]
[null,"3. Funding Gap",{"$f":"C48-C49","v":0}]
[null,"4. Federal Tax Credit Factor"]
[]
[null,"Total Credits Necessary for Feasibility",{"$f":"ROUND(IF(ISERROR((C50/C51)),0,(C50/C51)),0)","v":0}]
[null,"Annual Federal Credit Necessary for Feasibility",{"$f":"C53/10","v":0}]
[null,"Maximum Annual Federal Credits",{"$f":"(IF((C44<C54),C44,C54))","v":0}]
[null,"Equity Raised from Federal Credit",{"$f":"ROUND((10*C55*C51),0)","v":0}]
[]
[null,"Remaining Funding Gap",{"$f":"C50-C56","v":0}]
[]
[]
[null,"Determination of State Credit"]
[]
[null,"Does the project include State Credit?","(Select)"]
[null,"Does the project involve State Acquisition Credit?","(Select)"]
[null,null,"New Construction or Rehabilitation",null,"Acquisition"]
[null,"1.  State Credit Basis",0]
[null,"Rehabilitation or new construction basis only (no acquisition basis), except in rare cases of At-Risk projects eligible for State Credit on the acquisition basis at the 0.13 factor when no 130% basis increase is used."]
[null,"2.   x Factor Amount"]
[null,"3.  Maximum Total State Credit",{"$f":"C66*C68","v":0},null,{"$f":"E66*E68","v":0}]
[]
[null,"Determination of Minimum State Credit Necessary for Feasibility"]
[null,"State Credit Factor",null,null,0]
[null,"State Credit Necessary for Feasibility",null,null,{"$f":"ROUND(IF(ISERROR((C58/E72)),0,(C58/E72)),0)","v":0}]
[null,"Maximum State Credit",null,null,{"$f":"IF(((C69+E69)<E73),C69+E69,E73)","v":0}]
[null,"Equity Raised from State Credit",null,null,{"$f":"E72*E74","v":0}]
[]
[null,"Remaining Funding Gap",null,null,{"$f":"C50-(C56+E75)","v":0}]
[]
[null,"Calculation of LIHTC Equity","Federal",null,"State"]
[null,"Total Annual Credits",{"$f":"C55","v":0}]
[null,"Total Credits",{"$f":"C80*10","v":0},null,{"$f":"SUM(C69,E69)","v":0}]
[null,"Limited Partner Share (Percentage)"]
[null,"Total Limited Partner Credits",{"$f":"C81*C82","v":0},null,{"$f":"E81*E82","v":0}]
[null,"Tax Credit Pricing ($$ / credit)",0,null,0]
[null,"Limited Partner Equity",{"$f":"C83*C84","v":0},null,{"$f":"E83*E84","v":0}]
[]
[null,"Total Limited Partner Equity*",{"$f":"SUM(C85:E85)","v":0}]
[]
["END OF WORKSHEET"]

{"sheet":"4% TieBreak - HIDE","index":14,"n_rows":169,"n_cols":9,"rows_kept":169,"cut":false,"hidden":true,"merged":[[86,2,87,5],[13,6,13,7],[14,1,14,3],[15,1,15,3],[8,1,8,3],[8,6,8,7],[9,1,9,3],[9,6,9,7],[10,1,10,3],[10,6,10,7],[14,6,14,7],[23,0,23,1],[24,0,24,1],[28,2,28,3],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[35,0,35,1],[36,0,36,1],[38,0,38,1],[38,2,40,7],[39,0,39,1],[5,0,5,1],[6,0,6,1],[7,1,7,4],[7,6,7,8],[11,1,11,3],[12,1,12,3],[12,6,12,8],[13,1,13,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[15,6,15,7],[16,6,16,7],[18,0,18,1],[20,0,20,1],[21,2,22,2],[21,3,22,3],[16,1,16,3],[17,1,17,3],[40,0,40,1],[59,0,59,1],[60,0,60,1],[61,0,61,1],[62,0,62,1],[63,0,63,1],[64,0,64,1],[47,0,47,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[52,0,52,1],[53,0,53,1],[54,0,54,1],[55,0,55,1],[56,0,56,1],[58,0,58,1],[71,0,71,1],[72,0,72,1],[73,0,73,1],[74,0,74,1],[75,0,75,1],[76,0,76,1],[65,0,65,1],[66,0,66,1],[67,0,67,1],[68,0,68,1],[69,0,69,1],[70,0,70,1],[77,0,77,1],[78,0,78,1],[79,0,79,1],[81,0,81,1],[82,0,82,1],[83,0,83,1],[84,0,84,1],[85,0,85,1],[86,0,86,1],[91,0,91,1],[93,0,93,1],[94,0,94,1],[96,0,96,1],[97,0,97,1],[98,0,98,1],[87,0,87,1],[88,0,88,1],[89,0,89,1],[90,0,90,1],[92,0,92,1],[106,0,106,1],[107,0,107,1],[108,0,108,1],[109,0,109,1],[110,0,110,1],[111,0,111,1],[99,0,99,1],[100,0,100,1],[101,0,101,1],[102,0,102,1],[103,0,103,1],[104,0,104,1],[118,0,118,1],[119,0,119,1],[120,0,120,1],[121,0,121,1],[122,0,122,1],[123,0,123,1],[112,0,112,1],[113,0,113,1],[114,0,114,1],[115,0,115,1],[116,0,116,1],[117,0,117,1],[131,0,131,1],[132,0,132,1],[132,2,133,5],[133,0,133,1],[134,0,134,1],[135,0,135,1],[124,0,124,1],[125,0,125,1],[126,0,126,1],[127,0,127,1],[128,0,128,1],[129,0,129,1],[153,0,153,1],[135,6,137,7],[136,0,136,1],[137,0,137,1],[138,0,138,1],[139,0,139,1],[139,2,141,5],[140,0,140,1],[141,0,141,1],[164,0,164,1],[165,0,165,1],[168,0,168,9],[142,0,142,1],[143,0,143,1],[143,2,146,5],[144,0,144,1],[145,0,145,1],[146,0,146,1],[161,0,161,1],[162,0,162,1],[163,0,163,1],[154,0,154,1],[155,0,155,1],[157,0,157,1],[158,0,158,1],[159,0,159,1],[159,2,160,5],[160,0,160,1],[147,0,147,1],[149,0,149,1],[150,0,150,1],[151,0,151,1],[152,0,152,1]]}
["D.8.c  4% Tax Credit - Tie Breaker Calculation",null,null,null,null,null,{"$f":"IF('Application Instructions'!D5<>\"\",'Application Instructions'!D5,\"\")","v":""}]
[]
[null,null,null,null,null,"Public Benefit Numerator",null,{"$f":"E18","v":0}]
[null,null,null,null,null,"Cost-Adjusted Bond and State Credit Allocation Denominator","÷",{"$f":"I18","v":0}]
[null,null,null,null,null,"Tiebreaker",null,{"$f":"IFERROR(H3/H4,0)","v":0}]
[]
[]
[null,"Numerator",null,null,null,null,"Denominator"]
[null,"A. Unit Production Benefit",null,null,{"$f":"G33","v":0},null,"Bond Request"]
[null,"B. Rent Savings Benefit",null,null,{"$f":"G47","v":0},null,"State Credits",null,{"$f":"'D.8.b. 4% Tax Credit Calc'!E74","v":0}]
[null,"C. Population Benefit",null,null,{"$f":"SUM(E13,E12)","v":0},null,"Total Allocations",null,{"$f":"I9+I10","v":0}]
[null,"(i) Extremely Low Income Benefit",null,null,{"$f":"G56","v":0}]
[null,"(ii) Special Populations Benefit",null,null,{"$f":"IF(G67=\"Yes\",MAX(G65,G79),G65)","v":0},null,"Adjustments"]
[null,"D. Location Benefit",null,null,{"$f":"MAX(E15,E16)+E17","v":0},null,"Prevailing Wages / Labor",null,{"$f":"IF(AND(G134=\"Yes\",G136<>\"\"),IF(OR(G141=\"Yes\",G145=\"Yes\"),18%,15%),0)","v":0}]
[null,"(i) Resource Area Benefit",null,null,{"$f":"G94","v":0},null,"Construction Type",null,{"$f":"IF('D.8.a. 4% TC Threshold Basis'!F25='drop down menus'!B26,10%,IF('D.8.a. 4% TC Threshold Basis'!F25='drop down menus'!B27,5%,0))","v":0}]
[null,"(ii) Community Revitalization Benefit",null,null,{"$f":"G104","v":0},null,"SWBD * .25",null,{"$f":"G155","v":2.1785714285714287E-2}]
[null,"(iii) Transit/Walkability Benefit",null,null,{"$f":"G129","v":0},null,"Seismic/Environmental",null,{"$f":"IF(AND(G161=\"Yes\",G159),IF(G165>15%,15%,G165),0)","v":0}]
[null,"Public Benefit",null,null,{"$f":"SUM(E9:E11,E14)","v":0},null,"Cost-Adjusted Allocation",null,{"$f":"I11-((I11*I14)+(I11*I15)+(I11*I16)+(I11*I17))","v":0}]
[]
[null,"A. Unit Production Benefit"]
[]
[null,null,"Bedroom Count","Adjustment Factor","Actual Low Income Unit Count","Adjusted Unit Count","Adjusted Units"]
[]
[null,null,0,0.9,null,{"$f":"E24","v":0},{"$f":"D24*F24","v":0}]
[null,null,1,1,null,{"$f":"E25","v":0},{"$f":"D25*F25","v":0}]
[null,null,2,1.25,null,{"$f":"IF(ISNUMBER(E26),SUM(E26:E28)-SUM(F27:F28),0)","v":0},{"$f":"D26*F26","v":0}]
[null,null,3,1.5,null,{"$f":"IF(ISNUMBER(E27),MIN(E27,ROUNDDOWN(E29*30%,0)),0)","v":0},{"$f":"D27*F27","v":0}]
[null,null,4,1.75,null,{"$f":"IF(ISNUMBER(E28),MIN(E28,ROUNDDOWN(E29*10%,0)),0)","v":0},{"$f":"D28*F28","v":0}]
[null,null,"Total",null,{"$f":"SUM(E24:E28)","v":0},{"$f":"SUM(F24:F28)","v":0},{"$f":"SUMPRODUCT(D24:D28,F24:F28)","v":0}]
[]
[null,null,null,null,"Adjusted Units",null,{"$f":"G29","v":0}]
[null,null,null,null,"Benefit Multiplier","×",50000]
[null,null,null,null,"Unit Production Benefit",null,{"$f":"G32*G31","v":0}]
[]
[null,"B. Rent Savings Benefit"]
[]
[null,null,null,null,"Acquisition/Rehabilitation Project:",null,"(Select)"]
[null,null,null,null,"Actual rents are less than the CTCAC rent limits:",null,"(Select)"]
[null,null,{"$f":"IF(AND(G37=\"Yes\",G38=\"Yes\",G38<>\"\"),\"FLAG: Enter the average rent charged for each unit type over the last three years, as documented with rent rolls or property audits, in cells Q20:Q44\",\"\")","v":""}]
[]
[]
[null,null,null,null,"Average AMI of Units without Federal Rental Assistance:",null,{"$f":"'D.5 Unit Mix, Rents, Subsidy'!AU26","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"Average is less than 40%:",null,{"$f":"G42<40%","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Monthly Rent Savings",null,{"$f":"'D.5 Unit Mix, Rents, Subsidy'!AX26","v":0}]
[null,null,null,null,"Benefit Multiplier (12 months × 15 years)","×",{"$f":"12*15","v":180}]
[null,null,null,null,"Rent Savings Benefit",null,{"$f":"G45*G46","v":0}]
[]
[null,"C. Population Benefit: (i) Extremely Low Income Benefit"]
[]
[null,null,null,null,"Units serving Extremely Low Income Households:",null,{"$f":"'D.5 Unit Mix, Rents, Subsidy'!T26","v":0}]
[null,null,null,null,"Maximum (50% of Low-Income Units):",null,{"$f":"ROUNDDOWN(E29*50%,0)","v":0}]
[]
[null,null,null,null,"Special Population Quantity",null,{"$f":"MIN(G51:G52)","v":0}]
[null,null,null,null,"Benefit Multiplier","×",20000]
[null,null,null,null,"Extremely Low Income Benefit",null,{"$f":"G54*G55","v":0}]
[]
[null,"C. Population Benefit: (ii) Special Populations Benefit"]
[]
[null,null,null,null,"Units serving Special Needs, Homeless, or Veterans:",null,{"$f":"'D.5 Unit Mix, Rents, Subsidy'!Y26","v":0}]
[null,null,null,null,"Maximum (50% of Low-Income Units):",null,{"$f":"ROUNDDOWN(E29*50%,0)","v":0}]
[]
[null,null,null,null,"Special Population Quantity",null,{"$f":"MIN(G60:G61)","v":0}]
[null,null,null,null,"Benefit Multiplier","×",10000]
[null,null,null,null,"Special Needs Population Benefit",null,{"$f":"G63*G64","v":0}]
[]
[null,null,null,null,"Project applied for the Homeless Set-Aside:",null,"(Select)"]
[null,null,null,null,"Units designated for Homeless households:",null,{"$f":"SUM('D.5 Unit Mix, Rents, Subsidy'!Z26:AE26)","v":0}]
[]
[null,null,null,null,"City Point in Time Homeless Count:"]
[null,null,null,null,"City Population (Census Estimate):"]
[null,null,null,null,"City Homelessness Rate Per 100k:",null,{"$f":"IF(G71=0,0,(G70/G71)*100000)","v":0}]
[null,null,null,null,"County Point in Time Homeless Count:"]
[null,null,null,null,"County Population (Census Estimate):"]
[null,null,null,null,"County Homelessness Rate Per 100k:",null,{"$f":"IF(G74=0,0,(G73/G74)*100000)","v":0}]
[]
[null,null,null,null,"Special Population Quantity",null,{"$f":"IF(OR(G75>G72,G71<100000),G75*G68,G72*#REF!)","v":0}]
[null,null,null,null,"Benefit Multiplier","×",100]
[null,null,null,null,"Special Needs Population Benefit",null,{"$f":"G77*G78","v":0}]
[]
[null,"D. Location Benefit: (i) Resource Area Benefit"]
[]
[null,null,"Project meets the CDLAC new construction definition",null,null,null,"(Select)"]
[null,null,"Project is Large Family housing type",null,null,null,"(Select)"]
[null,null,"Project is Permanent Supportive Housing",null,null,null,"(Select)"]
[null,null,"Opportunity Area Designation",null,null,null,"(Select)"]
[null,null,"Project is located in a neighborhood experiencing neighborhood change, as specified on the HCD Neighborhood Change Map",null,null,null,"(Select)"]
[]
[]
[null,null,null,null,"Eligible:",null,{"$f":"OR(AND(COUNTIFS(G84:G85,\"Yes\")>=1,G83=\"Yes\"),G87=\"Yes\")","v":false}]
[]
[null,null,null,null,"Bedroom-Adjusted Low-Income Units","×",{"$f":"G29","v":0}]
[null,null,null,null,"Benefit Multiplier",null,{"$f":"IFERROR(IF($G$87=\"Yes\",30000,INDEX('drop down menus'!I14:I16,MATCH(LEFT(G86,17),'drop down menus'!G14:G16,0))),0)","v":0}]
[null,null,null,null,"Resource Area Benefit",null,{"$f":"G92*G93*G90","v":0}]
[]
[null,"D. Location Benefit: (ii) Community Revitalization Benefit"]
[]
[null,null,null,null,null,"Project is a component of the Area's Community Revitalization Plan","(Select)"]
[]
[null,null,null,null,"Eligible:",null,{"$f":"G98=\"Yes\"","v":false}]
[]
[null,null,null,null,"Bedroom-Adjusted Low-Income Units",null,{"$f":"G29","v":0}]
[null,null,null,null,"Benefit Multiplier","×",20000]
[null,null,null,null,"Community Revitalization Benefit",null,{"$f":"G100*G103*G102","v":0}]
[]
[null,"D. Location Benefit: (iii) Transit/Walkability Benefit"]
[]
[null,null,null,null,"Transit Site Amenity Points (from 4% Application)",null,"(Select)"]
[null,null,null,null,"Benefit Multiplier","×",4000]
[null,null,null,null,"Bedroom-Adjusted Low-Income Units","×",{"$f":"G29","v":0}]
[null,null,null,null,"Transit Benefit",null,{"$f":"IF(G108=\"(Select)\",0,G108*G109*G110)","v":0}]
[]
[null,null,null,null,"Walkable Amenity Count (from 4% Application)",null,"(Select)"]
[null,null,null,null,"Benefit Multiplier","×",4000]
[null,null,null,null,"Walkability Benefit",null,{"$f":"IF(G113=\"(Select)\",0,G110*G113*G114)","v":0}]
[]
[null,null,"Project has:"]
[null,null,"an award of HCD TOD funding",null,null,null,"(Select)"]
[null,null,"an award of HCD AHSC funding",null,null,null,"(Select)"]
[null,null,"a transit stop within ¼ mile with service every 30 min",null,null,null,"(Select)"]
[null,null,"a transit stop within ½ mile with service every 15 min",null,null,null,"(Select)"]
[]
[null,null,null,null,"Eligible:",null,{"$f":"COUNTIFS(G118:G121,\"Yes\")>=1","v":false}]
[]
[null,null,null,null,"Bedroom-Adjusted Low-Income Units","×",{"$f":"G29","v":0}]
[null,null,null,null,"Benefit Multiplier","×",25000]
[null,null,null,null,"Mass Transit Benefit",null,{"$f":"G123*G126*G110","v":0}]
[]
[null,null,null,null,"Transit/Walkability Benefit",null,{"$f":"G127+G115+G111","v":0}]
[]
[null,"Prevailing Wages"]
[]
[null,null,"Project has a legal requirement for payment of federal or state prevailing wage on the entire project"]
[null,null,null,null,null,null,"(Select)"]
[]
[null,null,"Public funding source(s) requiring prevailing wage:"]
[]
[]
[]
[null,null,"Project is subject to a project labor agreement that requires the employment of construction workers who are paid at least state or federal prevailing wages (within the meaning of Section 2500(b)(1) of the Public Contract Code)"]
[null,null,null,null,null,null,"(Select)"]
[]
[]
[null,null,"The project's general contractor has an enforceable commitment to participate in state-approved apprenticeship training programs and provide health care for construction workers and their dependents"]
[null,null,null,null,null,null,"(Select)"]
[]
[]
[]
[null,"Statewide Basis Delta"]
[]
[null,null,null,null,"County:",null,"Los Angeles"]
[]
[null,null,null,null,"2-Bedroom (select one) County Basis Limit",null,{"$f":"'D.8.a. 4% TC Threshold Basis'!D9","v":608800}]
[null,null,null,null,"Statewide Median Basis Limit",null,560000]
[null,null,null,null,"25% of Statewide Basis Delta",null,{"$f":"((G153-G154)/G154)*0.25","v":2.1785714285714287E-2}]
[]
[null,"Seismic or Environmental Remediation"]
[]
[null,null,null,null,"Acquisition/Rehabilitation Project:",null,{"$f":"G37","v":"(Select)"}]
[null,null,"Project requires seismic upgrading of existing residential structures, and/or requires on-site environmental remediation"]
[null,null,null,null,null,null,"(Select)"]
[]
[null,null,null,null,"Cost certified by project architect or seismic engineer:",null,0]
[]
[null,null,null,null,"Percentage of bond related to such costs:",null,{"$f":"IF(I9=0,0,G163/I9)","v":0}]
[null,null,null,null,"Maximum Adjustment (15% of Bond Request):",null,{"$f":"I9*0.15","v":0}]
[]
[]
["END OF WORKSHEET"]

{"sheet":"drop down menus","index":15,"n_rows":134,"n_cols":17,"rows_kept":134,"cut":false,"hidden":true,"merged":[[57,6,57,10],[13,6,13,7],[14,6,14,7],[15,6,15,7]]}
["(Select)","(Select)"]
["Yes","General Affordable - Extremely Low Income",null,null,null,null,null,"(Select)"]
["No","General Affordable - Family",null,"(Select)",null,null,"(Select)","Unincorporated LA County"]
[null,"General Affordable - Seniors",null,"Seller",null,null,"SPA 1","Incorporated area, outside the City of Los Angeles"]
["(Select)","SN - Homeless",null,"Owner",null,null,"SPA 2","LACDA/County - Owned Land"]
["Non-profit","SN - Homeless Seniors",null,"Tenant",null,null,"SPA 3"]
["For-profit","SN - Chronically Homeless",null,null,null,null,"SPA 4"]
["(Select)","SN - Homeless Veterans",null,null,null,null,"SPA 5"]
["Mixed Population","SN - Homeless Persons Living with a Mental Illness",null,"(Select)",null,null,"SPA 6"]
["Special Needs","SN - Homeless Transition Age Youth",null,"Single Family",null,null,"SPA 7"]
[null,"SN - Persons Living with HIV/AIDS",null,"Multifamily (Apts)",null,null,"SPA 8"]
["(Select)","SN - Persons with Intellectual and Developmental Disabilities",null,null,null,null,"County-Owned Land"]
["Construction only","SN - At Risk Transition Age Youth",null,"(Select)"]
["Permanent only","SN - Survivors of DV / HT / SA",null,"Full Time",null,null,"Highest Resource",null,30000]
["Construction & Perm",null,null,"Part Time",null,null,"High Resource",null,20000]
[null,null,null,null,null,null,"Moderate Resource",null,10000]
["(Select)","(Select)"]
["Hard payments","Yes - LACDA PBVs",null,"(Select)",null,null,"(Select)"]
["Soft debt","Yes - LACDA PBVASH",null,"4% Tax Credits",null,null,"Predevelopment"]
["Grant","Yes - Other Issuer - Federal",null,"9% Tax Credits",null,null,"Construction"]
["Other","Yes - Other Issuer - Local",null,"Not Applying for Tax Credits"]
["4% Equity","No",null,null,null,null,"(Select)"]
["9% Equity",null,null,"(Select)",null,null,"Non-rural project, Census Tract is Highest Resource (20 Percentage Points)"]
[null,null,null,"No Place Like Home",null,null,"Non-rural project, Census Tract is High Resource (10 Percentage Points)"]
["(Select)","(Select)",null,"Affordable Housing Trust Funds",null,null,"Rural project, Census Tract is Highest Resource (10 Percentage Points)"]
["Y","Y - 15% for Type I",null,"HOME",null,null,"Rural project, Census Tract is High Resource (5 Percentage Points)"]
["N","Y - 10% for Type III",null,"Measure A",null,null,"N/A"]
[null,"N",null,"Measure H"]
["(Select)",null,null,"MHHP",null,null,"(Select)"]
["Studio","(Select)",null,null,null,null,"Capital"]
["1-Bedroom","Highest Resource",null,"(Select)",null,null,"Preservation"]
["2-Bedroom","High Resource",null,"Capital"]
["3-Bedroom","Moderate Resource",null,"Capital & Rental Assistance",null,null,"CTCAC/CDLAC - 2026 App - Fair Market Rents"]
["4-Bedroom","Low Resource",null,"Preservation",null,null,"Studio",1856]
["5-Bedroom","Missing/Insufficient Data",null,"PBVASH only",null,null,"1-Bedroom",2081]
[null,null,null,null,null,null,"2-Bedroom",2625]
["(Select)",null,null,null,null,null,"3-Bedroom",3335]
["Acquisition",null,null,null,null,null,"4-Bedroom",3698]
["Predevelopment",null,null,null,null,null,"5-Bedroom",3698]
["Acq & Predevelopment"]
[]
["(Select)"]
[0]
[0.01,null,null,null,"(Select)",null,"Studio","1-br","2-br","3-br","4-br","5-br"]
[0.02,null,null,null,0.2,"20% AMI",530,568,681,787,878,969]
[0.03,null,null,null,0.3,"30% AMI",795,852,1022,1181,1317,1454]
[0.04,null,null,null,0.35,"35% AMI",927,994,1192,1378,1537,1696]
[0.05,null,null,null,0.4,"40% AMI",1060,1136,1363,1575,1757,1939]
[0.06,null,null,null,0.45,"45% AMI",1192,1278,1533,1772,1976,2181]
[7.0000000000000007E-2,null,null,null,0.5,"50% AMI",1325,1420,1703,1969,2196,2423]
[0.08,null,null,null,0.55000000000000004,"55% AMI",1457,1562,1874,2166,2415,2666]
[0.09,null,null,null,0.6,"60% AMI",1590,1704,2044,2363,2635,2908]
[0.1,null,null,null,0.7,"70% AMI",1855,1988,2385,2757,3074,3393]
[0.11,null,null,null,0.8,"80% AMI",2120,2272,2726,3151,3514,3878]
[0.12,null,null,null,1,"100% AMI",2650,2840,3406,3938,4392,4846]
[0.13]
[0.14000000000000001]
[0.15,null,null,null,null,null,"2025 LA County TCAC Rent Limits"]
[0.16,null,null,null,null,"Unit Size","20% AMI","30% AMI","35% AMI","40% AMI","45% AMI","50% AMI","55% AMI","60% AMI","70% AMI","80% AMI","100% AMI"]
[0.17,null,null,null,null,{"$f":"TRANSPOSE(G44:L55)","v":"Studio"},530,795,927,1060,1192,1325,1457,1590,1855,2120,2650]
[0.18,null,null,null,null,"1-br",568,852,994,1136,1278,1420,1562,1704,1988,2272,2840]
[0.19,null,null,null,null,"2-br",681,1022,1192,1363,1533,1703,1874,2044,2385,2726,3406]
[0.2,null,null,null,null,"3-br",787,1181,1378,1575,1772,1969,2166,2363,2757,3151,3938]
[null,null,null,null,null,"4-br",878,1317,1537,1757,1976,2196,2415,2635,3074,3514,4392]
[null,null,null,null,null,"5-br",969,1454,1696,1939,2181,2423,2666,2908,3393,3878,4846]
[]
[]
[null,null,null,null,"Helper","Unit Size","AMI","Rent Limit (2025)"]
[null,null,null,null,{"$f":"$F69&$G69","v":"Studio0.2"},"Studio",0.2,{"$f":"TRANSPOSE(G60:Q60)","v":530}]
[null,null,null,null,{"$f":"$F70&$G70","v":"Studio0.3"},"Studio",0.3,795]
["Construction Loan","Permanent",null,null,{"$f":"$F71&$G71","v":"Studio0.35"},"Studio",0.35,927]
["(Select)","(Select)",null,null,"Studio0.4","Studio",0.4,1060]
["Construction Loan","Permanent Loan",null,null,"Studio0.45","Studio",0.45,1192]
["LAHD - AHMP","LAHD - AHMP",null,null,"Studio0.5","Studio",0.5,1325]
["LAHD - HHH","LAHD - HHH",null,null,"Studio0.55","Studio",0.55000000000000004,1457]
["LAHD - ULA","LAHD - ULA",null,null,"Studio0.6","Studio",0.6,1590]
["LAHD - Land","LAHD - Land",null,null,"Studio0.7","Studio",0.7,1855]
["LAHD - Other","LAHD - Other",null,null,"Studio0.8","Studio",0.8,2120]
["LACDA - AHTF","LACDA - AHTF",null,null,"Studio1","Studio",1,2650]
["LACDA - HOME","LACDA - HOME",null,null,{"$f":"$F80&$G80","v":"1-Bedroom0.2"},"1-Bedroom",0.2,{"$f":"TRANSPOSE(G61:Q61)","v":568}]
["LACDA - Measure A","LACDA - Measure A",null,null,{"$f":"$F81&$G81","v":"1-Bedroom0.3"},"1-Bedroom",0.3,852]
["LACDA - NPLH","LACDA - NPLH",null,null,{"$f":"$F82&$G82","v":"1-Bedroom0.35"},"1-Bedroom",0.35,994]
["LACDA - Other","LACDA - Other",null,null,"1-Bedroom0.4","1-Bedroom",0.4,1136]
["State HCD - AHSC","State HCD - AHSC",null,null,"1-Bedroom0.45","1-Bedroom",0.45,1278]
["State HCD - IIG","State HCD - IIG",null,null,"1-Bedroom0.5","1-Bedroom",0.5,1420]
["State HCD - MHP","State HCD - MHP",null,null,"1-Bedroom0.55","1-Bedroom",0.55000000000000004,1562]
["State HCD - TOD","State HCD - TOD",null,null,"1-Bedroom0.6","1-Bedroom",0.6,1704]
["State HCD - Homekey+","State HCD - Homekey+",null,null,"1-Bedroom0.7","1-Bedroom",0.7,1988]
["State HCD - NPLH","State HCD - NPLH",null,null,"1-Bedroom0.8","1-Bedroom",0.8,2272]
["State HCD - Other","State HCD - Other",null,null,"1-Bedroom1","1-Bedroom",1,2840]
["Tranche B Loan","Tranche B Loan",null,null,{"$f":"$F91&$G91","v":"2-Bedroom0.2"},"2-Bedroom",0.2,{"$f":"TRANSPOSE(G62:Q62)","v":681}]
["FHLB - AHP","FHLB - AHP",null,null,{"$f":"$F92&$G92","v":"2-Bedroom0.3"},"2-Bedroom",0.3,1022]
["Sponsor Loan","Sponsor Loan",null,null,{"$f":"$F93&$G93","v":"2-Bedroom0.35"},"2-Bedroom",0.35,1192]
["Seller's Note","Seller's Note",null,null,"2-Bedroom0.4","2-Bedroom",0.4,1363]
["Deferred Developer Fee","Deferred Developer Fee",null,null,"2-Bedroom0.45","2-Bedroom",0.45,1533]
["Deferred Costs","Deferred Costs",null,null,"2-Bedroom0.5","2-Bedroom",0.5,1703]
["Contributed Developer Fee ","Contributed Developer Fee",null,null,"2-Bedroom0.55","2-Bedroom",0.55000000000000004,1874]
["GP Equity","GP Equity",null,null,"2-Bedroom0.6","2-Bedroom",0.6,2044]
["Other","Other",null,null,"2-Bedroom0.7","2-Bedroom",0.7,2385]
[null,null,null,null,"2-Bedroom0.8","2-Bedroom",0.8,2726]
["(Select)",null,null,null,"2-Bedroom1","2-Bedroom",1,3406]
[0,null,null,null,{"$f":"$F102&$G102","v":"3-Bedroom0.2"},"3-Bedroom",0.2,{"$f":"TRANSPOSE(G63:Q63)","v":787}]
[1,null,null,null,{"$f":"$F103&$G103","v":"3-Bedroom0.3"},"3-Bedroom",0.3,1181]
[2,null,null,null,{"$f":"$F104&$G104","v":"3-Bedroom0.35"},"3-Bedroom",0.35,1378]
[3,null,null,null,"3-Bedroom0.4","3-Bedroom",0.4,1575]
[4,null,null,null,"3-Bedroom0.45","3-Bedroom",0.45,1772]
[5,null,null,null,"3-Bedroom0.5","3-Bedroom",0.5,1969]
[6,null,null,null,"3-Bedroom0.55","3-Bedroom",0.55000000000000004,2166]
[7,null,null,null,"3-Bedroom0.6","3-Bedroom",0.6,2363]
[8,null,null,null,"3-Bedroom0.7","3-Bedroom",0.7,2757]
[9,null,null,null,"3-Bedroom0.8","3-Bedroom",0.8,3151]
[10,null,null,null,"3-Bedroom1","3-Bedroom",1,3938]
[null,null,null,null,{"$f":"$F113&$G113","v":"4-Bedroom0.2"},"4-Bedroom",0.2,{"$f":"TRANSPOSE(G64:Q64)","v":878}]
[null,null,null,null,{"$f":"$F114&$G114","v":"4-Bedroom0.3"},"4-Bedroom",0.3,1317]
[null,null,null,null,{"$f":"$F115&$G115","v":"4-Bedroom0.35"},"4-Bedroom",0.35,1537]
[null,null,null,null,"4-Bedroom0.4","4-Bedroom",0.4,1757]
[null,null,null,null,"4-Bedroom0.45","4-Bedroom",0.45,1976]
[null,null,null,null,"4-Bedroom0.5","4-Bedroom",0.5,2196]
[null,null,null,null,"4-Bedroom0.55","4-Bedroom",0.55000000000000004,2415]
[null,null,null,null,"4-Bedroom0.6","4-Bedroom",0.6,2635]
[null,null,null,null,"4-Bedroom0.7","4-Bedroom",0.7,3074]
[null,null,null,null,"4-Bedroom0.8","4-Bedroom",0.8,3514]
[null,null,null,null,"4-Bedroom1","4-Bedroom",1,4392]
[null,null,null,null,{"$f":"$F124&$G124","v":"5-Bedroom0.2"},"5-Bedroom",0.2,{"$f":"TRANSPOSE(G65:Q65)","v":969}]
[null,null,null,null,{"$f":"$F125&$G125","v":"5-Bedroom0.3"},"5-Bedroom",0.3,1454]
[null,null,null,null,{"$f":"$F126&$G126","v":"5-Bedroom0.35"},"5-Bedroom",0.35,1696]
[null,null,null,null,"5-Bedroom0.4","5-Bedroom",0.4,1939]
[null,null,null,null,"5-Bedroom0.45","5-Bedroom",0.45,2181]
[null,null,null,null,"5-Bedroom0.5","5-Bedroom",0.5,2423]
[null,null,null,null,"5-Bedroom0.55","5-Bedroom",0.55000000000000004,2666]
[null,null,null,null,"5-Bedroom0.6","5-Bedroom",0.6,2908]
[null,null,null,null,"5-Bedroom0.7","5-Bedroom",0.7,3393]
[null,null,null,null,"5-Bedroom0.8","5-Bedroom",0.8,3878]
[null,null,null,null,"5-Bedroom1","5-Bedroom",1,4846]

{"sheet":"I.16 Sust. Bldg. Methods ","index":16,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":true,"merged":[[11,1,11,2],[29,1,29,3],[1,1,1,3],[4,1,4,4],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4]]}
[]
[null,"I.16 Sustainable Building Methods Compliance Certification"]
[null,{"$f":"IF(#REF!<>\"\",#REF!,\"\")","v":{"$error":"#REF!"}}]
[]
[null,"REQUIRED SUSTAINABLE BUILDING METHODS"]
[null,1,"Minimum Energy Efficiency: New Construction and Rehabilitation projects must be designed to meet the minimum construction requirements as defined by TCAC Regulations Section 10325(f)(7)(A).  Rehabilitation projects will need to demonstrate a 20% reduction in energy use from tabulated baseline, based on the HERS verified existing condition.  "]
[null,2,"Outdoor water conservation measures that include (not applicable for projects with graywater irrigation systems): \n1) Use native or drought-tolerant plants for a minimum of 75% of landscaped area; select plants from Los Angeles County's Drought-tolerant Plant List found at http://planning.lacounty.gov/green, or the local jurisdiction’s drought-tolerant plant list, if required to do so by the local jurisdiction. \n2) Limit conventional grass/turf to 25% of landscaped area.\n3) Group plants with similar watering needs (hydrozones). \n4) Install high efficiency irrigation system with smart irrigation controls for all landscaping.\n"]
[null,3,"At minimum the project shall recycle and/or salvage 70% of non-hazardous construction and demolition debris. "]
[null,4,"The project shall provide an easily-accessible recycling area for tenant use that serves the entire building. "]
[null,5,"Project team shall conduct a design charrette prior to the NOFA application deadline that meets the criteria specified by Enterprise Green Communities charrettes or requirements of LEED for Homes. At minimum the charrette shall include the architect, civil, MEP, landscape architect, structural, and the energy modeler.   Meeting minutes shall be provided as evidence of the design charrette."]
[null,6,"Property manager and maintenance staff shall be trained in the use of a Green Operations and Maintenance Manual. The manual shall be prepared at pre-lease up using Green Communities' template or shall be organized to satisfy the requirements of LEED for Homes AEc1.1.  \nMust include reference in Property Management Plan "]
[null,"ADDITIONAL SUSTAINABLE BUILDING METHODS\n8 POINTS MINIMUM / 40 POINTS MAXIMUM ",null,"Available Points","Points Selected by Project",null,0]
[null,1,"Graywater Irrigation: An eligible project must have a minimum of 3,000 square feet of landscaping on grade, and must include at a minimum all front, rear, and side yards, courtyards, and parking lot landscape areas.  See eligibility criteria and requirements in Appendix 7.  \nMust include reference in Property Management Plan. ",10,10]
[null,2,"DOE Zero Energy Ready Home:  Projects that incorporate DOE Zero Energy Ready Home requirements will receive 10 points.  Projects shall certify to using the DOE Zero Energy Ready Homes criteria (which includes ENERGY STAR Homes and portions of the EPA WaterSense specifications as prerequisites).  See eligibility criteria and requirements in Appendix 7.",10]
[null,3,"ENERGY STAR Homes:  Projects (not receiving HOME funding) that certify to using ENERGY STAR Homes v. 3 will receive 10 points.  At the time of application, project teams shall acknowledge this requirement, and shall identify the ENERGY STAR Rater who will work on the project.  Progress ENERGY STAR checklists (latest version), prepared and signed by the ENERGY STAR Rater, shall be submitted to the Commission at the time of the Loan Committee review (as early as five (5) months after the award).",10]
[null,4,"Green Building Certification Program: Projects that seek above the minimum certification in at least one (1) green building program will receive five (5) points.  See incentive structure and requirements in Appendix 7.     ",5]
[null,5,"Reduce Domestic Hot Water Energy Use:  Projects that reduce energy use associated with domestic hot water heating by a minimum of 40% (as measured in kTDV/Ft2-year using the 2016 Energy Code) will receive five (5) points.  Projects shall submit a conceptual energy analysis prepared by a qualified CEA demonstrating minimum compliance and a conceptual narrative of the approach that will be taken.  Detailed energy analyses and energy models are not required for the application phase.",5]
[null,6,"EPA WaterSense Specification:  Projects that incorporate EPA WaterSense Specification will receive five (5) points.  Project teams shall incorporate the EPA WaterSense Specification into the project documents, and shall ensure that these requirements are clearly understood and adopted by the architect, the plumbing engineer, and the landscape irrigation designer at the time of the design charrette.  In order to qualify for the incentive, the project team shall submit drawings and specifications for Commission review at the Loan Committee phase.",5]
[null,7,"ENERGY STAR ceiling fans:  Installation of ENERGY STAR rated ceiling fans in all bedrooms and living rooms will receive five (5) points.",5]
[null,8,"Increased Energy Efficiency:\na) For new construction projects that exceed Title 24 energy standards by 25% for new construction of low-rise multifamily (3 or fewer habitable stories) and 20% for new construction of high-rise multifamily (4 or more habitable stories), or rehabilitation project, not subject to Title 24, that reduces energy use on a per square foot basis by 25% will receive four (4) points.\n\nb) For rehabilitation projects, not subject to Title 24, use of fluorescent light fixtures for at least 75% of light fixtures or comparable energy lighting for the project’s total lighting throughout the compliance period will receive two (2) points.","Up to 4"]
[null,9,"Quality Insulation Installation:  Projects that incorporate Quality Insulation Installation will be eligible for three (3) points and up to $350 per unit.  Project teams shall utilize Quality Insulation Installation, meeting the 2016 Energy Code Standard as a HERS-verified energy feature.  A cost estimate must be provided to justify the maximum incentive.",3,null,null,5]
[null,10,"Electric Vehicle Parking: Projects that commit to equip 5% of the parking stalls (for use by owner and residents) with a receptacle to accommodate use by electric vehicles charging equipment will receive three (3) points.  To receive points projects must provide:  \n1) A parking plan with 5% of parking stalls designated for plug-in electric vehicles. \n2) Sufficient space in electrical room for future installation of electric equipment necessary for 100% of parking stalls for use by residential component of the building. \n3) A description of how the 5% of parking stalls will be shared.\n4) Explanation as to why this is appropriate for the project.",3,null,null,10]
[null,11,"High Efficiency Toilets: Projects that install high efficiency toilets that require 1.06 gallons or less to flush and meet a minimum MaP threshold of 600 grams of waste removed from the toilet in a single flush.  Toilets must be EPA WaterSense-qualified.  Quiet flush or very low-noise models are recommended.  Applicants are encouraged to check with their appropriate water utility or water district to take advantage of available rebates.",3]
[null,12,"Nonsmoking buildings.",3]
[null,13,"Use of energy conservation measures for all building locations include:  \n1) ENERGY STAR labeled refrigerators\n2) ENERGY STAR labeled dishwashers (4.25 gpc or less)\n3) ENERGY STAR clothes washers that are a current Consortium for Energy Efficiency (CEE) Tier 3, or 4 model with a Modified Energy Factor (MEF) of 2.4 or greater and a Water Factor (WF) of 4.0 or less.\n4) ENERGY STAR lighting for interior \n5) ENERGY STAR bathroom fan/light\n6) ENERGY STAR approved exterior lighting, or High Efficacy as defined by the California Energy Commission.",2]
[null,14,"Indoor water conservation measures:    \n1) Use of showerheads that are water efficient (1.5 gpm or less).\n2) Use water-saving fixtures or flow restrictors in the kitchen and bathrooms (1.5 gpm or less).",2]
[null,15,"Incorporate design to retain, infiltrate and/or treat on-site the first one-half (1/2) inch of rainfall in a 24-hour period.",2]
[null,16,"Use of no-VOC interior paint (5 g/l or less).",2]
[null,17,"Use of at least one (1) of the following recycled materials at the designated levels: \na) Cast-in-place concrete (20% flyash for foundations, slabs, and site concrete); \nb) Carpet and pad (25%); \nc) Road base, fill or landscaped amendments (30%).",2]
[null,"TOTAL  (40 PTS MAX)",null,null,{"$f":"IF(SUM(E13:E29)>40,40,SUM(E13:E29))","v":10}]
[]
[]
[null,null,"By checking this box, applicant certifies that the above items will be incorporated into the project's design."]

{"sheet":"I.16a Hlthy. Design Elem. ","index":17,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":true,"merged":[[28,1,28,3],[1,1,1,3],[4,1,4,2],[11,1,11,3],[16,1,16,3],[19,1,19,3],[2,1,2,3]]}
[]
[null,"I.16a Healthy Design Elements Compliance Certification"]
[null,{"$f":"IF(#REF!<>\"\",#REF!,\"\")","v":{"$error":"#REF!"}}]
[]
[null,"VOLUNTARY HEALTHY DESIGN ELEMENTS - 20 POINTS MAX",null,"Points","Proposed Project"]
[null,1,"Onsite gym incentive:  Projects that include an onsite gym will receive ten (10) points.  Applicants must include at least three varieties of cardio equipment as well as strength training equipment. Room must be open at convenient times (before and after work hours and at lunch, and a minimum of 10 hours per day). ",10]
[null,2,"Designated Exercise Room: Projects that provide a designated exercise room will receive five (5) points.  The room must be open at convenient times (before and after work hours and at lunch, and a minimum of 10 hours per day). Capacity and class offerings should allow 10% of building occupants to take one class weekly.  The exercise room must be set aside for its own use and cannot be part of a community room or other dual-use space.  ",5]
[null,3,"Edible Garden Program:  Projects that provide an Edible Garden Program that includes education, on-site garden space, composting area, and necessary resources will receive five (5) points.  A vertical garden of equal area or an off-site program will be considered.  See incentive requirements in Appendix 7.  Must include reference to the Edible Garden in Service Plan",5]
[null,4,"Container Garden and Edible Landscaping Program:  Projects that do not have enough space to fully integrate an Edible Garden Program into the site plan may propose a Container Garden and Edible Landscaping Program for the development to receive three (3) points.  This program would involve the use of edible landscape components, which could include fruit trees, culinary herbs, and shrubs such as berries that could be put in designated areas of the landscape, such as along walls, fences, and walkways.  Must include reference to the Container Garden and Edible Landscaping Program in Service Plan",3]
[null,5,"Bike racks/secure storage: Projects that provide exterior bike racks and a secure interior bike storage room will receive (3) points.  See eligibility criteria and requirements in Appendix 7.",3]
[null,6,"DESIGN FOR INCREASED STAIR USE\nA maximum of 15 points are available.  If this option is selected, 5 base points are given for Required Design Items.  A maximum of 10 additional points are then available from the Optional Design Items.",5]
[null,"Stair Location"]
[null,"6a","VISIBILITY:  Position at least one stair to be visible from the building’s main lobby. A maximum of 25 feet travel and no turns should be required to reach stairs from the building’s main entry.","Required"]
[null,"6b","LOCATION WITH RESPECT TO ELEVATORS PRIORITY - Position at least one stair before access to elevators from the main building lobby, along the principal path of travel.  ","Required"]
[null,"6c","LOCATION WITH RESPECT TO ELEVATORS VISIBILITY - Position at least one stair within view of the elevators.",2]
[null,"6d","LOCATION ON PRINCIPAL PATH OF TRAVEL - At least one stair shall be located on, and visible from, the principal path of travel on each floor.",2]
[null,"Circulation Signage"]
[null,"6e","SIGNAGE PROMPTS AT STAIRS - Include permanent signage encouraging stair use to be integrated with the building’s way-finding program.","Required"]
[null,"6f","SIGNAGE PROMPTS AT ELEVATORS - Include permanent signage encouraging stair use to be integrated with the building’s way-finding program.","Required"]
[null,"Stair Design and Aesthetics"]
[null,"6g","ELECTRICAL LIGHTING - Incorporate a professionally-designed lighting program utilizing architectural fixtures that provide the light level and quality mandated by code and consistent with lighting in the building corridors.","Required"]
[null,"6h","NATURAL LIGHTING - Provide windows or skylight at each level. ",3]
[null,"6i","MUSIC - Provide music system within the stairs.",1]
[null,"6j","ARTWORK - Include permanent non-combustible artwork to increase visual interest within the stairs.",3]
[null,"6k","FINISHES - Provide similar or better quality finishes as building corridors.",1]
[null,"6l","VENTILATION - Provide same heat and air-conditioning level as building corridors.","Required"]
[null,"6m","SECURITY - Provide closed-caption television monitoring or similar system as provided in building corridors, or better.","Required"]
[null,"6n","SIZE - Provide stair width that is at least 20% greater than the minimum required by code.",3]
[null,"TOTAL (20 PTS MAX)",null,null,{"$f":"IF(SUM(E28,E22:E25,E15:E16,E6:E11)>20,20,SUM(E28,E22:E25,E15:E16,E6:E11))","v":0}]
[]
[]
[null,null,"By checking this box, applicant certifies that the above items will be incorporated into the project's design."]