{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Facts","Unit","PDC","FS","OpBudg","CF","County","BoardSummary","CreditInfo"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":388,"comments":2,"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":"Facts","index":0,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,7],[36,5,42,6]]}
[null,{"$f":"Facts_Project_Name & \", \" & TEXT(Facts_Application_Number, \"APP18-0000\")","v":", APP24-000"}]
[null,"Project Fact Sheet"]
[]
[null,"Target Population:",null,null,"Application # :","APP24-000"]
[null,"Project Name:",null,null,"Low-Income Units:",{"$f":"LowIncomeUnits","v":0}]
[null,"City:",null,null,"Market Units:",{"$f":"MarketUnits","v":0}]
[null,"County:",null,null,"Site Acreage:"]
[null,"Applicant:",null,null,"Median Income:",{"$f":"VLOOKUP(Facts_County,County!A:D,3,FALSE)","v":{"$error":"#N/A"}}]
[null,"Contractor:",null,null,"Selection:"]
[]
[]
[]
[null,"Project Development Costs",null,null,"Total","Per Unit","Percent"]
[null,"Construction (PDC lines 3-10, 27)",null,null,{"$f":"SUM(PDC!C8:C17)+PDC!C47","v":0},{"$f":"IF(E14=0,0,E14/(LowIncomeUnits+MarketUnits))","v":0},{"$f":"IF(E14=0,0,E14/$E$23)","v":0}]
[null,"Site Improvements (PDC line 2)",null,null,{"$f":"PDC!C6+PDC!C7","v":0},{"$f":"IF(E15=0,0,E15/(LowIncomeUnits+MarketUnits))","v":0},{"$f":"IF(E15=0,0,E15/$E$23)","v":0}]
[null,"Purchase of Building(s) (PDC line 1)",null,null,{"$f":"PDC!C5","v":0},0,0]
[null,"Soft Costs (PDC lines 11-16, 18-22, 28, 30)",null,null,{"$f":"SUM(PDC!C19:C35)+SUM(PDC!C37:C44)+PDC_Furnishings_and_Equipment+PDC_Rent_up_Expenses+PDC_Specify_Other_Non_Basis_Expense1+PDC_Specify_Other_Non_Basis_Expense2-PDC_Impact_Fees+PDC!C49+PDC!C50","v":0},{"$f":"IF(LowIncomeUnits=0,0,E17/(LowIncomeUnits+MarketUnits))","v":0},0]
[null,"Developer's Fee (PDC line 28)",null,null,{"$f":"PDC!C48","v":0},0,0]
[null,"Total Development Cost",null,null,{"$f":"SUM(E14:E18)","v":0},{"$f":"IF(LowIncomeUnits=0,0,E19/(LowIncomeUnits+MarketUnits))","v":0},0]
[null,"Water, Sewer and Impact Fees (PDC line 17)",null,null,{"$f":"PDC_Impact_Fees","v":0},0,{"$f":"IF(E20=0,0,E20/$E$23)","v":0}]
[null,"Reserves (PDC lines 31-33)",null,null,{"$f":"SUM(PDC!C55:'PDC'!C58)","v":0},{"$f":"IF(E21=0,0,E21/(LowIncomeUnits+MarketUnits))","v":0},{"$f":"IF(E21=0,0,E21/$E$23)","v":0}]
[null,"Land Cost (PDC line 34)",null,null,{"$f":"PDC_Land_Cost","v":0},{"$f":"IF(E22=0,0,E22/(LowIncomeUnits+MarketUnits))","v":0},{"$f":"IF(E22=0,0,E22/$E$23)","v":0}]
[null,"Total Replacement Cost",null,null,{"$f":"SUM(E19:E22)","v":0},{"$f":"IF(LowIncomeUnits=0,0,E23/(LowIncomeUnits+MarketUnits))","v":0},0]
[]
[null,"Project Funding Sources",null,null,"Amount","Rate","Term","Percent"]
[null,"Bank Loan",null,null,{"$f":"FS_BankLoan_Amount","v":0},{"$f":"FS!E5/100","v":0},{"$f":"FS!F5","v":0},{"$f":"FS!D5","v":""}]
[null,"RPLP Loan",null,null,{"$f":"FS_RPPLoan_Amount","v":0},{"$f":"FS!E6/100","v":0},{"$f":"FS!F6","v":0},{"$f":"FS!D6","v":""}]
[null,"Local Government",null,null,{"$f":"FS_LocGovLoan_Amount","v":0},{"$f":"FS!E7/100","v":0},{"$f":"FS!F7","v":0},{"$f":"FS!D7","v":""}]
[null,"RD 515 Loan",null,null,{"$f":"FS!C8","v":0},{"$f":"FS!E8/100","v":0},{"$f":"FS!F8","v":0},{"$f":"FS!D8","v":""}]
[null,"RD 538 Loan",null,null,{"$f":"FS!C9","v":0},{"$f":"FS!E9/100","v":0},{"$f":"FS!F9","v":0},{"$f":"FS!D9","v":""}]
[null,"AHP Loan",null,null,{"$f":"FS_AHPLoan_Amount","v":0},{"$f":"FS!E10/100","v":0},{"$f":"FS!F10","v":0},{"$f":"FS!D10","v":""}]
[null,"Other Loan",null,null,{"$f":"FS_Other1Loan_Amount","v":0},{"$f":"FS!E11/100","v":0},{"$f":"FS!F11","v":0},{"$f":"FS!D11","v":""}]
[null,"Other Loan",null,null,{"$f":"FS_Other2Loan_Amount","v":0},{"$f":"FS!E12/100","v":0},{"$f":"FS!F12","v":0},{"$f":"FS!D12","v":""}]
[null,"Other Loan",null,null,{"$f":"FS_Other3Loan_Amount","v":0},{"$f":"FS!E13/100","v":0},{"$f":"FS!F13","v":0},{"$f":"FS!D13","v":""}]
[null,"Tax Exempt Bond",null,null,{"$f":"FS_TEBondLoan_Amount","v":0},{"$f":"FS!E15/100","v":0},{"$f":"FS!F15","v":0},{"$f":"FS!D15","v":""}]
[null,"Workforce Housing Loan",null,null,{"$f":"FS_StateWHLP_Amount","v":0},{"$f":"FS!E16/100","v":0},{"$f":"FS!F16","v":30},{"$f":"FS!D16","v":""}]
[null,"Federal LIHTC",null,null,{"$f":"FS_FederalLIHTC_Amount","v":0},null,null,{"$f":"FS!D17","v":""}]
[null,"Non-Repayable Grant",null,null,{"$f":"FS_NonRepayableGrant_Amount","v":0},null,null,{"$f":"FS!D18","v":""}]
[null,"Historic Tax Credit",null,null,{"$f":"FS_HistoricTaxCredits_Amount","v":0},null,null,{"$f":"FS!D19","v":""}]
[null,"Deferred Developer Fee",null,null,{"$f":"FS_DeferredDevFees_Amount","v":0},null,null,{"$f":"FS!D20","v":""}]
[null,"Owner Investment",null,null,{"$f":"FS_OwnerInvestment_Amount","v":0},null,null,{"$f":"FS!D21","v":""}]
[null,"Other",null,null,{"$f":"FS_OtherEquity_Amount","v":0},null,null,{"$f":"FS!D22","v":""}]
[null,"Total Sources",null,null,{"$f":"SUM(E26:E42)","v":0},null,null,{"$f":"SUM(H26:H42)","v":0}]

{"sheet":"Unit","index":1,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,1,14]]}
[null,{"$f":"Facts_Project_Name & \",  \" & TEXT(Facts_Application_Number, \"APP05-0000\")","v":",  APP24-000"}]
[null,"Unit Mix and Rent Structure"]
[]
[null,"Low Income Units"]
[null,"Bedrooms","Number of Units","Type","Square Feet","Estimated Monthly Rent Recvd by Owner","Estimated Utilities Cost Not Included in Rent","Estimated Required Monthly Services Fees","Total Monthly Housing Cost to Tenant","HH Adjust.","Affordable To","% Med","HOME Trend?","1st Year Revenue","HOME Rents"]
[null,null,null,null,null,null,null,null,{"$f":"F6+G6","v":0},{"$f":"IF(ISBLANK(B6),\"\",VLOOKUP(B6,$B$27:$C$31,2,FALSE))","v":""},{"$f":"I6*12/30%","v":0},{"$f":"IF(B6=\"\",\"-\",K6/(CountyMedianIncome*J6))","v":"-"},null,{"$f":"F6*C6*12","v":0}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(B7),\"\",VLOOKUP(B7,$B$27:$C$31,2,FALSE))","v":""},0,"-",null,0]
[null,null,null,null,null,null,null,null,{"$f":"F8+G8","v":0},"",{"$f":"I8*12/30%","v":0},"-",null,{"$f":"F8*C8*12","v":0}]
[null,null,null,null,null,null,null,null,0,"",0,"-",null,0]
[null,null,null,null,null,null,null,null,0,"",0,"-",null,0]
[null,null,null,null,null,null,null,null,{"$f":"F11+G11","v":0},"",{"$f":"I11*12/30%","v":0},"-",null,{"$f":"F11*C11*12","v":0}]
[null,"Total Units",{"$f":"SUM(C6:C11)","v":0},null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(N6:N11)","v":0},{"$f":"SUM(O6:O11)","v":0}]
[]
[null,"Market Rate Units"]
[null,"Bedrooms","Number of Units","Type","Square Feet","Estimated Monthly Rent Recvd by Owner","Estimated Utilities Cost Not Included in Rent","Estimated Required Monthly Services Fees","Total Monthly Housing Cost to Tenant","HH Adjust.","Affordable To","% Med",null,"1st Year Revenue"]
[null,null,null,null,null,null,null,null,{"$f":"F16+G16","v":0},{"$f":"IF(ISBLANK(B16),\"\",VLOOKUP(B16,$B$27:$C$31,2,FALSE))","v":""},{"$f":"I16*12/30%","v":0},{"$f":"IF(B16=\"\",\"-\",K16/(CountyMedianIncome*J16))","v":"-"},null,{"$f":"F16*C16*12","v":0}]
[null,null,null,null,null,null,null,null,0,"",0,"-",null,0]
[null,null,null,null,null,null,null,null,0,"",0,"-",null,0]
[null,null,null,null,null,null,null,null,0,"",0,"-",null,0]
[null,null,null,null,null,null,null,null,0,"",0,"-",null,0]
[null,null,null,null,null,null,null,null,0,"",0,"-",null,0]
[null,"Total Units",{"$f":"SUM(C16:C21)","v":0},null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(N16:N21)","v":0}]
[]
[]
[null,"HH Adjustments"]
[null,"Bedrooms","Adjust."]
[null,"EFF",0.7]
[null,1,0.75]
[null,2,0.9]
[null,3,1.04]
[null,4,1.1599999999999999]

{"sheet":"PDC","index":2,"n_rows":75,"n_cols":8,"rows_kept":75,"cut":false,"hidden":false,"merged":[[50,4,57,5],[1,1,1,5],[2,4,2,5],[17,4,17,5],[29,4,35,5],[38,4,39,5],[41,4,44,5]]}
[null,{"$f":"Facts_Project_Name & \",  \" & TEXT(Facts_Application_Number, \"APP05-0000\")","v":",  APP24-000"}]
[null,"Project Development Costs"]
[null,null,null,null,"Eligible Basis"]
[null,"Cost Element","Total Cost",null,"30% PV","70% PV"]
[" ","1.    Purchase of Building(s)"]
[null,"2.    Demolition"]
[null,"3.    On-site Improvements"]
[null,"3.    Rehabilitation"]
[null,"5.    Construction of New Building(s)"]
[null,"6.    Accessory Building(s)"]
[null,"4.    General Requirements (max 6% lines 2-3)",null,{"$f":"IF(ISBLANK(C11),0,ROUND(C11/SUM(C6:C10),6))","v":0}]
[null,"5.    Contractor Overhead (max 2% lines 2-4)",null,{"$f":"IF(ISBLANK(C12),0,ROUND(C12/SUM(C6:C11),6))","v":0}]
[null,"6.    Contractor Profit (max 8% lines 2-4; 6% if Identity of Interest)",null,{"$f":"IF(ISBLANK(C13),0,ROUND(C13/SUM(C6:C11),6))","v":0}]
[null,"7.  Construction Contingency (max 10% lines 2-6)",null,{"$f":"IF(ISBLANK(C14),0,ROUND(C14/SUM(C6:C13),6))","v":0}]
[null,"8.  Architect's Fee - PNA/SOW (8+9 = max 3% lines 2-7)"]
[null,"9.  Architect's Fee - Inspection",null,{"$f":"IF(ISBLANK(C15),0,ROUND((C15+C16)/SUM(C6:C14),6))","v":0}]
[null,"10.  Engineering Costs"]
[null,"       Subtotal  (lines 1 through 10)",{"$f":"SUM(C5:C17)","v":0}]
[null,"11.  Construction Insurance (prorate)"]
[null,"12.  Construction Loan Origination Fee (prorate)"]
[null,"13.  Construction Loan Interest (prorate)"]
[null,"14.  Construction Loan Credit Enhancement (prorate)"]
[null,"15.  Construction Period Taxes (prorate)"]
[null,"16.  Building Permit Fee"]
[null,"17.  Water, Sewer and Impact Fees"]
[null,"18.  Survey"]
[null,"19.  Property Appraisal"]
[null,"20.  Environmental Report"]
[null,"24.  Market Study"]
[null,"25.  Bond Costs"]
[null,"26.  Bond Issuance Costs"]
[null,"27.  Placement Fee"]
[null,"21.  Permanent Loan Origination Fee  "]
[null,"29.  Permanent Loan Credit Enhancement  "]
[null,"22.  Title and Recording"]
[null,"       Subtotal  (lines 11 through 22)",{"$f":"SUM(C19:C35)","v":0}]
[null,"23.  Real Estate Attorney"]
[null,"24.  Other Attorney's Fees"]
[null,"33.  Tax Credit Application Fees (Preliminary and Full)"]
[null,"34.  Tax Credit Allocation Fee (0.90% of Total Qualified Basis)",null,{"$f":"ROUND((C68*0.009),0)","v":0}]
[null,"25.  Cost Certification / Accounting Fees"]
[null,"38.  Tax Opinion"]
[null,"39.  Organizational (Partnership)"]
[null,"26.  Monitoring Fee",{"$f":"1280*LowIncomeUnits","v":0},{"$f":"H48*(LowIncomeUnits+MarketUnits)","v":0},null,null,null,{"$f":"IF(PDC_Rehab+PDC_New_Bldg_Construction=0,\"\",IF(PDC_Rehab>0,\"Rehab\",IF(PDC_New_Bldg_Construction>0,\"New\",0)))","v":""}]
[null,"       Subtotal  (lines 23 through 26)",{"$f":"SUM(C37:C44)","v":0},null,null,null,null,{"$f":"IF(H44=\"New\",(LowIncomeUnits+MarketUnits)*20000,IF(H44=\"Rehab\",ROUND(PDC_Rehab*0.15,0),\"\"))","v":""}]
[null,"41.  Furnishings and Equipment"]
[null,"27.  Relocation Expense",null,{"$f":"H44","v":""}]
[null,"28.  Developer Fee",{"$f":"PDC_Rehab*0.15","v":0},{"$f":"IF(H45=\"\",0,H45)","v":0},null,null,null,{"$f":"IF(H49=\"Yes\",1580,1280)","v":1280}]
[null,"29.  Other Expense (specify)",null,null,null,null,null,"No"]
[null,"30.  Other Expense (specify)"]
[null,"46.  Rent-up Expense"]
[null,"47.  Other Non-Basis Expense (specify)"]
[null,"48.  Other Non-Basis Expense (specify)"]
[null,"       Subtotal  (lines 27 through 30)",{"$f":"SUM(C46:C53)","v":0}]
[null,"49.  Rent-up Reserve",null,{"$f":"300*(LowIncomeUnits+MarketUnits)","v":0},null,null,null,"$1,500/unit"]
[null,"31.  Operating Reserve",null,{"$f":"H59","v":0},null,null,null,{"$f":"1500*(LowIncomeUnits+MarketUnits)","v":0}]
[null,"32.  Other Reserve (specify)"]
[null,"33.  Other Reserve (specify)",null,null,null,null,null,"6 Mos DS/OE"]
[null,"       Development Cost (lines 31 through 33)",{"$f":"C18+C36+C45+C54+SUM(C55:C58)","v":0},null,{"$f":"SUM(E5:E58)","v":0},{"$f":"SUM(F5:F58)","v":0},null,{"$f":"(OpBudg!F60+CF!D27)/2","v":0}]
[null,"53.  Less Federally Funded Grant",null,null,null,{"$f":"PDC_Less_Fed_Financ_other_than_CDBG","v":0}]
[null,"54.  Less Disproportionate Standard "]
[null,"55.  Less Nonqualified Nonrecourse Financing"]
[null,"56.  Less Historic Tax Credit",null,null,null,{"$f":"PDC_Less_Historic_Tax_Credit","v":0}]
[null,"       Total Eligible Basis",{"$f":"E64+F64","v":0},null,{"$f":"E59-PDC_Less_Disproportionate_Std_30_PV-PDC_Less_Nonqual_Nonrecourse_Financ_30_PV","v":0},{"$f":"F59-PDC_Less_Fed_Financ_other_than_CDBG_70_PV-PDC_Less_Disproportionate_Std_70_PV-PDC_Less_Nonqual_Nonrecourse_Financ_70_PV-F63","v":0}]
[null,"57.  Applicable Fraction (percentage of Low Income units)",null,null,{"$f":"PDC_Times_Applicable_Fraction","v":0},{"$f":"C65","v":0}]
[null,"58.  Basis Before Boost",{"$f":"E66+F66","v":0},null,{"$f":"ROUND(E64*PDC_Times_Applicable_Fraction_30_PV,0)","v":0},{"$f":"ROUND(F64*PDC_Times_Applicable_Fraction_70_PV,0)","v":0}]
[null,"59.  Basis Boost of up to 130% (whole percentage only)",null,null,1]
[null,"       Total Qualified Basis",{"$f":"E68+F68","v":0},null,{"$f":"ROUND(E66*E67,0)","v":0},{"$f":"ROUND(F66*F67,0)","v":0}]
[null,"60.  Tax Credit Rate",null,null,0.04,0.09]
[null,"61.  Federal Tax Credits (maximum $1,200,000)",{"$f":"E70+F70","v":0},null,{"$f":"ROUND(E68*PDC_Tax_Credit_Rate_30_PV,0)","v":0},{"$f":"ROUND(F68*PDC_Tax_Credit_Rate_70_PV,0)","v":0}]
[null,"62.  Federal Tax Credits Requested (if less than line 61)",{"$f":"E71+F71","v":0}]
[null,"34.  Land Cost"]
[null,"       Total Replacement Cost",{"$f":"ROUND(C59+PDC_Land_Cost,0)","v":0}]
[]
[null,{"$f":"IF(PDC_Rehab>0,\"Total Replacement Cost per unit\",\"Project Development Cost per unit\")","v":"Project Development Cost per unit"},{"$f":"IF(C73=2880,0,IF(PDC_New_Bldg_Construction=0,C73/(LowIncomeUnits+MarketUnits),(PDC_New_Bldg_Construction+PDC_Accessory_Bldgs)/(LowIncomeUnits+MarketUnits)))","v":{"$error":"#DIV/0!"}}]

{"sheet":"FS","index":3,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[25,1,25,2],[0,1,0,2],[25,4,25,7],[29,4,29,6],[1,1,1,6],[6,10,6,11],[26,4,26,6],[27,4,27,6],[28,4,28,6],[18,4,18,5],[19,4,19,5],[20,4,20,5]]}
[null,{"$f":"Facts_Project_Name & \",  \" & TEXT(Facts_Application_Number, \"APP05-0000\")","v":",  APP24-000"}]
[null,"Project Funding Sources"]
[]
[null,"Source \n(Existing and Future Sources)","Amount","% of   Total","Rate","Term","Amort     Period","Annual DS","Existing or Future (/Proposed) Source?"]
[null,"Bank Loan",null,{"$f":"IF(C5=0,\"\",C5/$C$23)","v":""}]
[null,"RPLP Loan",null,""]
[null,"Local Government Loan",null,""]
[null,"RD 515 Loan",null,""]
[null,"RD 538 Loan",null,""]
[null,"AHP Loan",null,""]
[null,"Other Loan (specify)",null,""]
[null,"Other Loan (specify)",null,""]
[null,"Other Loan (specify)",null,""]
[null,"RD 515 Assumed"]
[null,"Tax Exempt Bond",null,""]
[null,"Workforce Housing Loan",null,"",0,30,30]
[null,"Federal LIHTC Equity",null,""]
[null,"Non-Repayable Grant",null,""]
[null,"Historic Tax Credit Equity",null,""]
[null,"Deferred Developer Fee",null,"",{"$f":"IF(FS_DeferredDevFees_Amount=0,\"\",ROUND(PDC_Developers_Fee/2,0))","v":""},null,{"$f":"IF(FS_DeferredDevFees_Amount=0,\"\",\"Max Deferred Fee\")","v":""}]
[null,"Owner Investment",null,"",{"$f":"IF(FS_DeferredDevFees_Amount=0,\"\",FS_DeferredDevFees_Amount/PDC!C48)","v":""},null,{"$f":"IF(FS_DeferredDevFees_Amount=0,\"\",\"Percent Deferred\")","v":""}]
[null,"Other (specify)",null,""]
[null,"Total Sources",{"$f":"ROUND(SUM(C5:C22),0)","v":0},{"$f":"IF(C23=0,\"\",SUM(D5:D22))","v":""}]
[null,{"$f":"IF(C24=\"\",\"\",IF(C24>0, \"Additional funds needed to balance\",\"Reduce sources to balance\"))","v":""},{"$f":"IF(PDC!C73-C23=0,\"\",+PDC!C73-C23)","v":""}]
[]
[null,"Federal LIHTC Equity Calculator",null,null,"Workforce Housing Loan Calculator"]
[null,"Federal Tax Credits",{"$f":"IF(PDC!C70=0,0,(IF(PDC!C71>0,IF(PDC!C71<PDC!C70,PDC!C71,PDC!C70),PDC!C70)))","v":0},null,"Total Eligible Basis",null,null,{"$f":"IF(FS_TEBondLoan_Amount>0,0,PDC!C64)","v":0}]
[null,"Limited Partner Interest",null,null,"County Income Designation",null,null,{"$f":"IF(Facts_County=\"\",\"\",getCountyDesignation(Facts_County))","v":""}]
[null,"Estimated pricing on sale of Credits",null,null,"WHLP Factor",null,null,{"$f":"IF(H27=0,\"\",IF(H28=\"O\",0,(IF(H28=\"H\",\"4%\",IF(H28=\"M\",\"12%\",IF(H28=\"L\",\"20%\",\"\"))))))","v":""}]
[null,"Total Federal Credit Equity",{"$f":"IF(C27>0,ROUND(C27*10*C28*C29,0),\"\")","v":""},null,"Total Workforce Housing Loan",null,null,{"$f":"IF(H27>0,ROUND(H27*H29,0),\"\")","v":""}]
[]
[]
[]
[null,"Existing"]
[null,"Future/Proposed"]

{"sheet":"OpBudg","index":4,"n_rows":72,"n_cols":6,"rows_kept":72,"cut":false,"hidden":false,"merged":[[62,1,62,5],[63,1,71,1],[67,2,67,4],[59,1,61,1],[70,2,70,4],[66,2,66,4],[69,2,69,4],[63,2,63,4],[64,2,64,4],[65,2,65,4],[59,2,59,4],[61,2,61,4],[60,2,60,4],[68,2,68,4],[72,2,72,4],[16,1,21,1],[22,1,43,1],[44,1,52,1],[53,1,57,1],[71,2,71,4],[51,2,51,4],[52,2,52,4],[53,2,53,4],[54,2,54,4],[55,2,55,4],[57,2,57,4],[58,2,58,4],[56,2,56,4],[49,2,49,4],[50,2,50,4],[48,2,48,4],[33,2,33,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[37,2,37,4],[38,2,38,4],[44,2,44,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[39,2,39,4],[40,2,40,4],[41,2,41,4],[42,2,42,4],[43,2,43,4],[32,2,32,4],[21,2,21,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[27,2,27,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[20,2,20,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[16,2,16,4],[15,2,15,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[0,1,0,5],[1,1,1,5],[2,1,15,1],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4]]}
[null,{"$f":"Facts_Project_Name & \",  \" & TEXT(Facts_Application_Number, \"APP05-0000\")","v":",  APP24-000"}]
[null,"Project Operations (Year 1)"]
[null,"Admin Expenses","Advertising"]
[null,null,"Office Salaries"]
[null,null,"Office Supplies"]
[null,null,"Office or Model Apartment Rent"]
[null,null,"Management Fee"]
[null,null,"Manager or Superintendent Salaries"]
[null,null,"Manager or Superintendent Rent Free Unit"]
[null,null,"Legal Expenses (Project)"]
[null,null,"Auditing Expenses (Project)"]
[null,null,"Bookkeeping Fees / Accounting Services"]
[null,null,"Telephone and Answering Service"]
[null,null,"Bad Debts"]
[null,null,"Other Administrative Expenses (specify)"]
[null,null,"     Total Administrative Expenses",null,null,{"$f":"SUM(F3:F15)","v":0}]
[null,"Utilities Expense","Fuel / Oil / Coal"]
[null,null,"Electricity (Light and Misc. Power)"]
[null,null,"Water"]
[null,null,"Gas"]
[null,null,"Sewer"]
[null,null,"     Total Utilities Expense",null,null,{"$f":"SUM(F17:F21)","v":0}]
[null,"Operating and Maintenance Expenses","Janitor and Cleaning Payroll"]
[null,null,"Janitor and Cleaning Supplies"]
[null,null,"Janitor and Cleaning Contract"]
[null,null,"Exterminating Payroll / Contract"]
[null,null,"Exterminating Supplies"]
[null,null,"Garbage and Trash Removal"]
[null,null,"Security Payroll / Contract "]
[null,null,"Grounds Payroll"]
[null,null,"Grounds Supplies"]
[null,null,"Grounds Contract"]
[null,null,"Repairs Payroll"]
[null,null,"Repairs Material"]
[null,null,"Repairs Contract"]
[null,null,"Elevator Maintenance / Contract"]
[null,null,"Heating / Cooling Repairs and Maintenance"]
[null,null,"Swimming Pool Maintenance / Contract"]
[null,null,"Snow Removal"]
[null,null,"Decorating Payroll / Contract"]
[null,null,"Decorating Supplies"]
[null,null,"Other (specify)"]
[null,null,"Miscellaneous Operating & Maintenance Expenses"]
[null,null,"     Total Operating & Maintenance Expenses",null,null,{"$f":"SUM(F23:F43)","v":0}]
[null,"Taxes and Insurance","Real Estate Taxes"]
[null,null,"Payroll Taxes (FICA)"]
[null,null,"Miscellaneous Taxes, Licenses and Permits"]
[null,null,"Property and Liability Insurance (Hazard)"]
[null,null,"Fidelity Bond Insurance"]
[null,null,"Workmen's Compensation"]
[null,null,"Health Insurance and Other Employee Benefits"]
[null,null,"Other Insurance (specify)"]
[null,null,"     Total Taxes and Insurance",null,null,{"$f":"SUM(F45:F52)","v":0}]
[null,"Supportive Service Expenses","Service Coordinator"]
[null,null,"Service Supplies"]
[null,null,"Tenant Association Funds"]
[null,null,"Other Expenses (specify)"]
[null,null,"     Total Supportive Service Expenses",null,null,{"$f":"SUM(F54:F57)","v":0}]
[null,"Reserves","Replacement Reserves "]
[null,null,"     Total Operating Expenses",null,null,{"$f":"SUM(F16+F22+F44+F53+F58)+F59","v":0}]
[null,null,"Per Unit Cost of Operations",null,null,{"$f":"IF(ISERR(F60/(LowIncomeUnits+MarketUnits)),0,F60/(LowIncomeUnits+MarketUnits))","v":0}]
[null,null,"     Per Unit Cost (less Reserves, RE Taxes, Support Serv Expenses)",null,null,{"$f":"IF(F61=0,0,F61-((ReplcmntReserves+F58+RETaxes)/(LowIncomeUnits+MarketUnits)))","v":0}]
[]
[null,"Rental and Other Income","Gross Rental Income",null,null,{"$f":"Unit!N12+Unit!N22+Unit!O12","v":0}]
[null,null,"Stores and Commercial"]
[null,null,"Laundry and Vending"]
[null,null,"Other Income (specify)"]
[null,null,"Total Gross Rental & Other Income Potential at 100% Occupancy",null,null,{"$f":"SUM(F64:F67)","v":0}]
[null,null,"Vacancy Rate",null,null,7.0000000000000007E-2]
[null,null,"Vacancy Allowance",null,null,{"$f":"F68*0.07","v":0}]
[null,null,"Net Rental and Other Income",null,null,{"$f":"F68-F70","v":0}]
[null,null,"Net Operating Income",null,null,{"$f":"F71-F60","v":0}]

{"sheet":"CF","index":5,"n_rows":104,"n_cols":33,"rows_kept":104,"cut":false,"hidden":false,"merged":[[103,1,103,2],[1,1,1,2],[1,4,1,9],[44,4,44,5],[45,4,45,5],[43,6,43,7],[44,6,44,7],[43,4,43,5]]}
[null,{"$f":"Facts_Project_Name & \",  \" & TEXT(Facts_Application_Number, \"APP05-0000\")","v":",  APP24-000"}]
[null,"Cash Flow Analysis"]
[null,"Income Trend",0.02,"YR 1","YR 2","YR 3","YR 4","YR 5","YR 6","YR 7","YR 8","YR 9","YR 10","YR 11","YR 12","YR 13","YR 14","YR 15","YR 16","YR 17","YR 18","YR 19","YR 20","YR 21","YR 22","YR 23","YR 24","YR 25","YR 26","YR 27","YR 28","YR 29","YR 30"]
[null,"Expense Trend",0.03]
[null,"   Gross Rent",null,{"$f":"LowIncomeRevenueTotal+MarketRevenueTotal","v":0},{"$f":"ROUND(D5*(1+$C$3),0)","v":0},{"$f":"ROUND(E5*(1+$C$3),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"+ HOME Rent",null,{"$f":"HOMERents","v":0},{"$f":"ROUND(D6*1.015,0)","v":0},{"$f":"ROUND(E6*1.015,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"+ Stores and Commercial",null,{"$f":"CashFlow_Commercial","v":0},{"$f":"ROUND(D7*(1+$C$3),0)","v":0},{"$f":"ROUND(E7*(1+$C$3),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"+ Laundry and Vending",null,{"$f":"CashFlow_Laundry","v":0},{"$f":"ROUND(D8*(1+$C$3),0)","v":0},{"$f":"ROUND(E8*(1+$C$3),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"+ Other Income",null,{"$f":"CashFlow_Other","v":0},{"$f":"ROUND(D9*(1+$C$3),0)","v":0},{"$f":"ROUND(E9*(1+$C$3),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"= Gross Income",null,{"$f":"SUM(D5:D9)","v":0},{"$f":"SUM(E5:E9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"-  7% Vacancy Allowance",null,{"$f":"ROUND(D10*CashFlow_VacancyRate,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"= Net Rental Income",null,{"$f":"D10-D11","v":0},{"$f":"E10-E11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"- Operating Expenses",null,{"$f":"OpBudg!F60-OpBudg!F59","v":0},{"$f":"ROUND(D13*(1+$C$4),0)","v":0},{"$f":"ROUND(E13*(1+$C$4),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"- Replacement Reserves",null,{"$f":"OpBudg!F59","v":0},{"$f":"ROUND(D14*1.04,0)","v":0},{"$f":"ROUND(E14*1.04,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"= Net Operating Income",null,{"$f":"D12-SUM(D13:D14)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"- \"&FS!B5","v":"- Bank Loan"},null,{"$f":"D38","v":0},{"$f":"E38","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"- \"&FS!B6","v":"- RPLP Loan"},null,{"$f":"D50","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"- \"&FS!B7","v":"- Local Government Loan"},null,{"$f":"D56","v":0},{"$f":"E56","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"- \"&FS!B8","v":"- RD 515 Loan"},null,{"$f":"D65","v":0},{"$f":"E65","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"- \"&FS!B9","v":"- RD 538 Loan"},null,{"$f":"D74","v":0},{"$f":"E74","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"- \"&FS!B10","v":"- AHP Loan"},null,{"$f":"D83","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"- \"&FS!B11","v":"- Other Loan (specify)"},null,{"$f":"D$92","v":0},{"$f":"E$92","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"- \"&FS!B12","v":"- Other Loan (specify)"},null,{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0},{"$f":"FS!$H$12","v":0}]
[null,{"$f":"\"- \"&FS!B13","v":"- Other Loan (specify)"},null,{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0},{"$f":"FS!$H$13","v":0}]
[null,{"$f":"\"- \"&FS!B14","v":"- RD 515 Assumed"},null,{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0},{"$f":"FS!$H$14","v":0}]
[null,{"$f":"\"- \"&FS!B15","v":"- Tax Exempt Bond"},null,{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0},{"$f":"FS!$H$15","v":0}]
[null,"Total Debt Service",null,{"$f":"SUM(D16:D26)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"= Net Cash Flow",null,{"$f":"D15-D27","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Debt Coverage Ratio - Bank Loan",null,{"$f":"IF(ISERR(D15/D16),0,D15/D16)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Debt Coverage Ratio - All Loans",null,{"$f":"IF(D27=0,0,D15/D27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"FS_DeferredDevFees_Amount","v":0},null,null,null,null,null,{"$f":"SUM(D28:R28)","v":0},{"$f":"IF(R32<L32,\"Unable to Repay Deferred Fee\",\"15 year Deferred Fee Repayment\")","v":"15 year Deferred Fee Repayment"}]
[]
[null,{"$f":"FS!B5","v":"Bank Loan"},null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Interest Rate",{"$f":"FS!$E$5/100","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Term",{"$f":"FS!$F$5","v":0},{"$f":"FS!G5*12","v":0},{"$f":"D36-12","v":-12},-24,-36,-48,-60,-72,-84,-96,-108,-120,-132,-144,-156,-168,-180,-192,-204,-216,-228,-240,-252,-264,-276,-288,-300,-312,-324,-336,-348]
[null,"Loan Principal",{"$f":"FS!$C$5","v":0},{"$f":"IF($C$37=0,0,PMT($C$35/12,$D$36,-$C$37))","v":0}]
[null,"P & I",{"$f":"FS!H5","v":0},{"$f":"IF($C$36<D34,0,$D$37*12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($C$36<AG34,0,$D$37*12)","v":0}]
[null,"   Interest Payment",null,{"$f":"IF($C$36<D34,\"\",D38-D40)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"   Principal Payment",null,{"$f":"IF($C$36<D34,\"\",PV($C$35/12,D36,-($D$37))-PV($C$35/12,E36,-($D$37)))","v":""},{"$f":"IF($C$36<E34,\"\",PV($C$35/12,E36,-($D$37))-PV($C$35/12,F36,-($D$37)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Remaining Principal",null,{"$f":"IF($C$36<D34,\"\",C37-D40)","v":""},{"$f":"IF($C$36<E34,\"\",D41-E40)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,"RPLP Loan",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,{"$f":"B35","v":"Interest Rate"},{"$f":"FS!E6/100","v":0},null,"Principal repaid as a ",null,"Total Payments"]
[null,{"$f":"B36","v":"Term"},{"$f":"FS!F6","v":0},null,"% of original loan",null,{"$f":"SUM(D50:AG50)","v":0}]
[null,{"$f":"B37","v":"Loan Principal"},{"$f":"FS!$C$6","v":0},null,{"$f":"IF(C46=0,0,SUM(D48:AG48)/C46)","v":0},null,"Interest",{"$f":"SUM(D47:AG47)","v":0}]
[null,"   Interest Payment",null,{"$f":"IF($C$46>0,C46*$C$44,\"\")","v":""},{"$f":"IF($C$46>0,D$49*$C$44,\"\")","v":""},{"$f":"IF($C$46>0,E$49*$C$44,\"\")","v":""},"","","","","","","","","","","","","","","","","",{"$f":"IF($C$46>0,W$49*$C$44,\"\")","v":""},{"$f":"IF($C$46>0,X$49*$C$44,\"\")","v":""},{"$f":"IF($C$46>0,Y$49*$C$44,\"\")","v":""},{"$f":"IF($C$46>0,Z$49*$C$44,\"\")","v":""},{"$f":"IF($C$46>0,AA$49*$C$44,\"\")","v":""},{"$f":"IF($C$46>0,AB$49*$C$44,\"\")","v":""},{"$f":"IF($C$46>0,AC$49*$C$44,\"\")","v":""},{"$f":"IF($C$46>0,AD$49*$C$44,\"\")","v":""},{"$f":"IF($C$46>0,AE$49*$C$44,\"\")","v":""},{"$f":"IF($C$46>0,AF$49*$C$44,\"\")","v":""}]
[null,"   Principal Payment",null,{"$f":"IF($C$46>0,D50-D47,\"\")","v":""},{"$f":"IF($C$46>0,E50-E47,\"\")","v":""},{"$f":"IF($C$46>0,F50-F47,\"\")","v":""},"","","","","",{"$f":"IF($C$46>0,L50-L47,\"\")","v":""},"","","","","","","","","","","",{"$f":"IF($C$46>0,X50-X47,\"\")","v":""},"","","","","","","","",""]
[null,"Remaining Principal",null,{"$f":"IF($C$46>0,C46-D48,\"\")","v":""},{"$f":"IF($C$46>0,D$49-E$48,\"\")","v":""},{"$f":"IF($C$46>0,E$49-F$48,\"\")","v":""},"","","","","","","","","","","","","","","","","",{"$f":"IF($C$46>0,W$49-X$48,\"\")","v":""},{"$f":"IF($C$46>0,X$49-Y$48,\"\")","v":""},{"$f":"IF($C$46>0,Y$49-Z$48,\"\")","v":""},{"$f":"IF($C$46>0,Z$49-AA$48,\"\")","v":""},{"$f":"IF($C$46>0,AA$49-AB$48,\"\")","v":""},{"$f":"IF($C$46>0,AB$49-AC$48,\"\")","v":""},{"$f":"IF($C$46>0,AC$49-AD$48,\"\")","v":""},{"$f":"IF($C$46>0,AD$49-AE$48,\"\")","v":""},{"$f":"IF($C$46>0,AE$49-AF$48,\"\")","v":""},{"$f":"IF($C$46>0,AF$49-AG$48,\"\")","v":""}]
[null,"RPP Annual P&I Payment",null,{"$f":"IF($C$46>0,D101,0)","v":0},{"$f":"IF($C$46>0,E101,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"  "]
[null,{"$f":"FS!B7","v":"Local Government Loan"},null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,{"$f":"B44","v":"Interest Rate"},{"$f":"FS!E7/100","v":0}]
[null,{"$f":"B45","v":"Term"},{"$f":"FS!F7","v":0},{"$f":"FS!G7*12","v":0},{"$f":"D54-12","v":-12},{"$f":"E54-12","v":-24},-36,-48,-60,-72,-84,-96,-108,-120,-132,-144,-156,-168,-180,-192,-204,-216,-228,-240,-252,-264,-276,-288,-300,-312,-324,-336,-348]
[null,{"$f":"B46","v":"Loan Principal"},{"$f":"FS!C7","v":0},{"$f":"IF($C$55=0,0,PMT($C$53/12,$D$54,-$C$55))","v":0}]
[null,"P & I",{"$f":"FS!$H$7","v":0},{"$f":"IF($C$54<D52,0,$D$55*12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Interest Payment",null,{"$f":"IF($C$54<D52,\"\",D56-D58)","v":""},{"$f":"IF($C$54<E52,\"\",E56-E58)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"   Principal Payment",null,{"$f":"IF($C$54<D52,\"\",PV($C$53/12,D54,-($D$55))-PV($C$53/12,E54,-($D$55)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Remaining Principal",null,{"$f":"IF($C$54<D52,\"\",C55-D58)","v":""},{"$f":"IF($C$54<E52,\"\",D59-E58)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,{"$f":"FS!B8","v":"RD 515 Loan"},null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Interest Rate",{"$f":"FS!$E$8/100","v":0}]
[null,{"$f":"B36","v":"Term"},{"$f":"FS!$F$8","v":0},{"$f":"FS!G8*12","v":0},{"$f":"D63-12","v":-12},-24,-36,-48,-60,-72,-84,-96,-108,-120,-132,-144,-156,-168,-180,-192,-204,-216,-228,-240,-252,-264,-276,-288,-300,-312,-324,-336,-348]
[null,"Loan Principal",{"$f":"FS!$C$8","v":0},{"$f":"IF($C$64=0,0,PMT($C$62/12,$D$63,-$C$64))","v":0}]
[null,"P & I",{"$f":"FS!$H$8","v":0},{"$f":"IF($C$63<D61,0,$D$64*12)","v":0},{"$f":"IF($C$63<E61,0,$D$64*12)","v":0},{"$f":"IF($C$63<F61,0,$D$64*12)","v":0},{"$f":"IF($C$63<G61,0,$D$64*12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Interest Payment",null,{"$f":"IF($C$63<D61,\"\",D65-D67)","v":""},{"$f":"IF($C$63<E61,\"\",E65-E67)","v":""},{"$f":"IF($C$63<F61,\"\",F65-F67)","v":""},{"$f":"IF($C$63<G61,\"\",G65-G67)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"   Principal Payment",null,{"$f":"IF($C$63<D61,\"\",PV($C$62/12,D63,-($D$64))-PV($C$62/12,E63,-($D$64)))","v":""},{"$f":"IF($C$63<E61,\"\",PV($C$62/12,E63,-($D$64))-PV($C$62/12,F63,-($D$64)))","v":""},{"$f":"IF($C$63<F61,\"\",PV($C$62/12,F63,-($D$64))-PV($C$62/12,G63,-($D$64)))","v":""},{"$f":"IF($C$63<G61,\"\",PV($C$62/12,G63,-($D$64))-PV($C$62/12,H63,-($D$64)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Remaining Principal",null,{"$f":"IF($C$63<D61,\"\",C64-D67)","v":""},{"$f":"IF($C$63<E61,\"\",D68-E67)","v":""},{"$f":"IF($C$63<F61,\"\",E68-F67)","v":""},{"$f":"IF($C$63<G61,\"\",F68-G67)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,{"$f":"FS!B9","v":"RD 538 Loan"},null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Interest Rate",{"$f":"FS!$E$9/100","v":0}]
[null,{"$f":"B45","v":"Term"},{"$f":"FS!$F$9","v":0},{"$f":"FS!G9*12","v":0},{"$f":"D72-12","v":-12},-24,-36,-48,-60,-72,-84,-96,-108,-120,-132,-144,-156,-168,-180,-192,-204,-216,-228,-240,-252,-264,-276,-288,-300,-312,-324,-336,-348]
[null,{"$f":"B46","v":"Loan Principal"},{"$f":"FS!$C$9","v":0},{"$f":"IF($C$73=0,0,PMT($C$71/12,$D$72,-$C$73))","v":0}]
[null,"P&I",{"$f":"FS!$H$9","v":0},{"$f":"IF($C$72<D70,0,$D$73*12)","v":0},{"$f":"IF($C$72<E70,0,$D$73*12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"B47","v":"   Interest Payment"},null,{"$f":"IF($C$72<D70,\"\",D74-D76)","v":""},{"$f":"IF($C$72<E70,\"\",E74-E76)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"B48","v":"   Principal Payment"},null,{"$f":"IF($C$72<D70,\"\",PV($C$71/12,D72,-($D$73))-PV($C$71/12,E72,-($D$73)))","v":""},{"$f":"IF($C$72<E70,\"\",PV($C$71/12,E72,-($D$73))-PV($C$71/12,F72,-($D$73)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"B49","v":"Remaining Principal"},null,{"$f":"IF($C$72<D70,\"\",C73-D76)","v":""},{"$f":"IF($C$72<E70,\"\",D77-E76)","v":""},{"$f":"IF($C$72<F70,\"\",E77-F76)","v":""},{"$f":"IF($C$72<G70,\"\",F77-G76)","v":""},{"$f":"IF($C$72<H70,\"\",G77-H76)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,{"$f":"FS!B10","v":"AHP Loan"},null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Interest Rate",{"$f":"FS!$E$10/100","v":0}]
[null,{"$f":"B54","v":"Term"},{"$f":"FS!$F$10","v":0},{"$f":"FS!G10*12","v":0},{"$f":"D81-12","v":-12},-24,-36,-48,-60,-72,-84,-96,-108,-120,-132,-144,-156,-168,-180,-192,-204,-216,-228,-240,-252,-264,-276,-288,-300,-312,-324,-336,-348]
[null,"Loan Principal",{"$f":"FS!$C$10","v":0},{"$f":"IF($C$82=0,0,PMT($C$80/12,$D$81,-$C$82))","v":0}]
[null,"P & I",{"$f":"FS!$H$10","v":0},{"$f":"IF($C$81<D79,0,$D$82*12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Interest Payment",null,{"$f":"IF($C$81<D79,\"\",D83-D85)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"   Principal Payment",null,{"$f":"IF($C$81<D79,\"\",PV($C$80/12,D81,-($D$82))-PV($C$80/12,E81,-($D$82)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Remaining Principal",null,{"$f":"IF($C$81<D79,\"\",C82-D85)","v":""},{"$f":"IF($C$81<E79,\"\",D86-E85)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,{"$f":"FS!B11","v":"Other Loan (specify)"},null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,{"$f":"B80","v":"Interest Rate"},{"$f":"FS!$E$11/100","v":0}]
[null,"Term",{"$f":"FS!$F$11","v":0},{"$f":"FS!G11*12","v":0},{"$f":"D90-12","v":-12},-24,-36,-48,-60,-72,-84,-96,-108,-120,-132,-144,-156,-168,-180,-192,-204,-216,-228,-240,-252,-264,-276,-288,-300,-312,-324,-336,-348]
[null,"Loan Principal",{"$f":"FS!$C$11","v":0},{"$f":"IF($C$91=0,0,PMT($C$89/12,$D$90,-$C$91))","v":0}]
[null,"P & I",{"$f":"FS!$H$11","v":0},{"$f":"IF($C$90<D88,0,$D$91*12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Interest Payment",null,{"$f":"IF($C$90<D88,\"\",D92-D94)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"   Principal Payment",null,{"$f":"IF($C$90<D88,\"\",PV($C$89/12,D90,-($D$91))-PV($C$89/12,E90,-($D$91)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Remaining Principal",null,{"$f":"IF($C$90<D88,\"\",C91-D94)","v":""},{"$f":"IF($C$90<E88,\"\",D95-E94)","v":""},{"$f":"IF($C$90<F88,\"\",E95-F94)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,"RPLP Payment Calculator",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Total Debt Service Supportable at 1.15",null,{"$f":"D15/1.15","v":0},{"$f":"E15/1.15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"X15/1.15","v":0},0,0,0,0,0,0,0,0,0]
[null,"-  Bank Payment",null,{"$f":"D16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"X16","v":0},0,0,0,0,0,0,0,0,0]
[null,"-  Other Priority Payment",null,{"$f":"SUM(D$18:D$26)","v":0},{"$f":"SUM(E$18:E$26)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"= RPP Payment Amount",null,{"$f":"D98-D99-D100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"X98-X99-X100","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"Changing Calculators"]
[null,"To have a calculator amortize another Source, link Name (in gray), IR, Term, Loan Principal and the cell adjacent to Term (in column C) to the corresponding cells on the Sources page for the Source you want to amortize.  For example: to change the AHP Loan calculator to the 2nd Other Loan, change all of the above mentioned cells from 8 (row the AHP Loan is on on the Sources page) to 10 (row the 2nd Other Loan is on on the Sources page).  You will then need to change the corresponding cells in the Debt Service section (rows 16 through 24)."]

{"sheet":"County","index":6,"n_rows":101,"n_cols":4,"rows_kept":101,"cut":false,"hidden":true,"merged":[]}
["County","Region","Median Income (2023)","Income Level"]
["Alamance","C",78800,"M"]
["Alexander","W",71400,"M"]
["Alleghany","W",54900,"L"]
["Anson","C",62700,"L"]
["Ashe","W",64200,"L"]
["Avery","W",66500,"L"]
["Beaufort","E",73000,"M"]
["Bertie","E",59300,"L"]
["Bladen","E",60100,"L"]
["Brunswick","E",89800,"H"]
["Buncombe","M",90300,"H"]
["Burke","W",71400,"M"]
["Cabarrus","C",102800,"H"]
["Caldwell","W",71400,"M"]
["Camden","E",85100,"M"]
["Carteret","E",80600,"M"]
["Caswell","C",71400,"M"]
["Catawba","W",71400,"M"]
["Chatham","C",116200,"H"]
["Cherokee","W",62700,"L"]
["Chowan","E",67500,"L"]
["Clay","W",67900,"L"]
["Cleveland","W",68300,"L"]
["Columbus","E",59400,"L"]
["Craven","E",77100,"M"]
["Cumberland","M",71600,"M"]
["Currituck","E",100500,"H"]
["Dare","E",97400,"H"]
["Davidson","C",70700,"M"]
["Davie","C",85800,"M"]
["Duplin","E",66100,"L"]
["Durham","M",116200,"H"]
["Edgecombe","E",77700,"M"]
["Forsyth","M",85800,"M"]
["Franklin","C",117000,"H"]
["Gaston","W",102800,"H"]
["Gates","E",74000,"M"]
["Graham","W",58600,"L"]
["Granville","C",80300,"M"]
["Greene","E",64600,"L"]
["Guilford","M",83600,"M"]
["Halifax","E",55100,"L"]
["Harnett","C",82700,"M"]
["Haywood","W",77100,"M"]
["Henderson","W",90300,"H"]
["Hertford","E",59400,"L"]
["Hoke","C",75200,"M"]
["Hyde","E",56600,"L"]
["Iredell","C",95600,"H"]
["Jackson","W",73700,"M"]
["Johnston","E",117000,"H"]
["Jones","E",72000,"M"]
["Lee","C",70500,"M"]
["Lenoir","E",60200,"L"]
["Lincoln","W",93600,"H"]
["Macon","W",71100,"M"]
["Madison","W",90300,"H"]
["Martin","E",61200,"L"]
["McDowell","W",67600,"L"]
["Mecklenburg","M",102800,"H"]
["Mitchell","W",71100,"M"]
["Montgomery","C",64400,"L"]
["Moore","C",98900,"H"]
["Nash","E",77700,"M"]
["New Hanover","E",103000,"H"]
["Northampton","E",57500,"L"]
["Onslow","E",71600,"M"]
["Orange","C",116200,"H"]
["Pamlico","E",79600,"M"]
["Pasquotank","E",83700,"M"]
["Pender","E",91700,"H"]
["Perquimans","E",78500,"M"]
["Person","C",78300,"M"]
["Pitt","E",77600,"M"]
["Polk","W",80500,"M"]
["Randolph","C",83600,"M"]
["Richmond","C",63000,"L"]
["Robeson","E",54700,"L"]
["Rockingham","C",70300,"M"]
["Rowan","C",76700,"M"]
["Rutherford","W",62800,"L"]
["Sampson","E",62900,"L"]
["Scotland","C",52900,"L"]
["Stanly","C",80500,"M"]
["Stokes","C",85800,"M"]
["Surry","W",68300,"L"]
["Swain","W",71500,"M"]
["Transylvania","W",78300,"M"]
["Tyrrell","E",60800,"L"]
["Union","C",102800,"H"]
["Vance","C",64600,"L"]
["Wake","M",117000,"H"]
["Warren","C",59200,"L"]
["Washington","E",62500,"L"]
["Watauga","W",87400,"H"]
["Wayne","E",72600,"M"]
["Wilkes","W",63400,"L"]
["Wilson","E",58600,"L"]
["Yadkin","W",85800,"M"]
["Yancey","W",70500,"M"]

{"sheet":"BoardSummary","index":7,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":true,"merged":[[28,2,28,7],[33,2,33,7],[21,1,21,3],[22,1,22,3],[23,1,23,3],[26,1,26,3],[24,1,24,3],[25,1,25,3],[27,1,27,3],[10,1,10,7],[12,1,12,7],[19,1,19,3],[20,1,20,2],[0,1,0,5],[3,1,3,4],[4,1,4,4],[6,1,6,4],[8,1,8,3],[8,4,8,5]]}
["NAME:",{"$f":"Facts_Project_Name","v":0}]
["RPP LOAN AMOUNT:",{"$f":"FS_RPPLoan_Amount","v":0}]
["WHLP LOAN AMOUNT:",{"$f":"FS_StateWHLP_Amount","v":0}]
["APPLICANT:",{"$f":"Facts_Applicant","v":0}]
["LOCATION:",{"$f":"Facts_County","v":0}]
["MANAGEMENT:"]
["CONTRACTOR:",{"$f":"Facts_Contractor","v":0}]
[]
["TARGETING:",null,null,null,"MEDIAN INCOME:",null,{"$f":"getMedianIncome(Facts_County)","v":{"$error":"#NAME?"}}]
[]
["SUMMARY:"]
[]
["SPONSOR:"]
[]
["UNIT MIX:","Bedrooms","Number of Units","Type","Square Feet","Monthly Rent","Utilities Cost","Monthly Housing Expense"]
[null,null,null,null,null,null,null,{"$f":"F16+G16","v":0}]
[]
[]
["PROJECT COSTS:",null,null,null,"Total","Per Unit"]
[null,"Construction ",null,null,{"$f":"Facts!$E$14","v":0},{"$f":"Facts!$F$14","v":0}]
[null,"Onsite Improvements",null,null,{"$f":"Facts!$E$15","v":0},{"$f":"Facts!$F$15","v":0}]
[null,"Soft Costs",null,null,{"$f":"Facts!$E$17","v":0},{"$f":"Facts!$F$17","v":0}]
[null,"Developer's Fee",null,null,{"$f":"Facts!$E$18","v":0},{"$f":"Facts!$F$18","v":0}]
[null,"Total Development Cost",null,null,{"$f":"SUM(E20:E23)","v":0},{"$f":"SUM(F20:F23)","v":0}]
[null,"Water, Sewer and Impact Fees",null,null,{"$f":"Facts!$E$20","v":0}]
[null,"Land",null,null,{"$f":"Facts!$E$22","v":0}]
[null,"Reserves ",null,null,{"$f":"Facts!$E$21","v":0}]
[null,"Total Replacement Cost",null,null,{"$f":"+E24+E25+E26+E27","v":0}]
[null,"Annotation:"]
[]
["FUNDING SOURCES:",null,null,null,"Amount","Rate","Term","Percent "]
[null,"RPP Loan",null,null,{"$f":"B3","v":0},{"$f":"Facts!$F$27","v":0},{"$f":"Facts!$G$27","v":0},{"$f":"Facts!$H$27","v":""}]
[null,"Total",null,null,{"$f":"SUM(E32:E32)","v":0},null,null,{"$f":"SUM(H32:H32)","v":0}]
[null,"Annotation:"]

{"sheet":"CreditInfo","index":8,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":true,"merged":[[14,5,14,6],[14,9,14,10],[14,12,14,13],[15,5,15,6],[15,9,15,10],[15,11,15,13],[13,1,13,2],[13,7,13,8],[1,1,1,13],[10,3,10,4],[10,5,10,6],[10,9,10,10],[10,12,10,13]]}
[]
[null,"Building by Building Credit Allocation"]
[]
[]
[null,"Project Name:",null,null,null,"Was this project in a QCT or DDA when credits were awarded?"]
[]
[null,"Project #:",null,null,null,"Does this project contain Market Rate units?"]
[null,null,null,null,"(if Yes, Applicable Fraction will not populate until Bldg Info page is complete)"]
[]
[]
[null,null,"Address of Building","Placed in Service Date",null,"Eligible Basis",null,"Applicable","QCT / DDA","Qualified Basis",null,"Credit","Credit Amount"]
[null,"BIN","(must be actual street address)","New / Rehab","Acquisition","New / Rehab","Acquisition","Fraction","Boost","New / Rehab","Acquisition","Rate","New / Rehab","Acquistion"]
[null,null,null,null,null,null,null,null,{"$f":"IF(B13=\"\",\"\",IF($E$5=\"\",\"\",IF(E13>0,\"100%\",IF(G13>0,\"100%\",IF($E$5=\"No\",\"100%\",\"130%\")))))","v":""},{"$f":"IF(I13=\"\",\"\",IF(H13=\"\",\"\",IF(F13>0,ROUND(F13*H13*I13,),\"\")))","v":""},{"$f":"IF(G13>0,ROUND(G13*H13,0),\"\")","v":""},null,{"$f":"IF(E13>0,\"\",IF(G13>0,\"\",IF(D13=\"\",\"\",IF(J13=\"\",\"\",IF(F13=\"\",\"\",ROUND(J13*L13,0))))))","v":""},{"$f":"IF(D13>0,\"\",IF(F13>0,\"\",IF(E13=\"\",\"\",IF(K13=\"\",\"\",ROUND(K13*L13,0)))))","v":""}]
[null,null,null,null,null,{"$f":"SUM(F13:F13)","v":0},{"$f":"SUM(G13:G13)","v":0},null,null,{"$f":"SUM(J13:J13)","v":0},{"$f":"SUM(K13:K13)","v":0},null,{"$f":"SUM(M13:M13)","v":0},{"$f":"SUM(N13:N13)","v":0}]
[null,null,null,null,null,{"$f":"F14+G14","v":0},null,null,null,{"$f":"SUM(J14:K14)","v":0},null,null,{"$f":"SUM(M14:N14)","v":0}]
[null,"Note: Acquisition credits should be entered on a separate line from New / Rehab credits",null,null,null,{"$f":"IF(F15<>PDC!$C$64,\"Does not equal Total\",\"\")","v":""},null,null,null,{"$f":"IF(J15<>PDC!$C$68,\"Does not equal Total\",\"\")","v":""},null,{"$f":"IF(M15>PDC!$C$71,\"         Credits exceed amount reserved\",\"\")","v":""}]