{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","Costs","Sources","Credit Info","Bldg Info","Unit Mix","Op Budg","Cash Flow","Owner Cert","Auditor Cert"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":22,"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":"Instructions","index":0,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[[47,5,47,7],[1,1,1,10],[41,6,41,7],[3,1,8,10],[10,1,16,10],[45,7,45,8],[43,5,43,6],[45,5,45,6],[22,1,23,11]]}
[]
[null,"Final Cost Certification Instructions"]
[]
[null,"To complete the Final Cost Certification, use your 'Tab' key to move through each field of each page.  The entire form and each page should be completed in order, from left to right.  Because some data flows through multiple pages, failure to complete the form in order could cause some fields to not fill or calculate.  'Shift-Tab' will move you back to previous cells.  To move between sections, click on the desired tab below.  Please refer to the Qualified Allocation Plan (\"QAP\") for the year in which your project was awarded credits to ensure your project meets all of that year's QAP requirements."]
[]
[]
[]
[]
[]
[]
[null,"When you have completed the Final Cost Certification, save and email a copy to the Development Analyst who is assigned to your project.  You will also need to mail all of the items listed below.  Once all of those items are received, NCHFA will have a minimum of 30 days to issue 8609s.  Depending on the time of year, the minimum time may be longer.  Prior to issuing 8609s, the Development Analyst will email the Final Cost Certification with any changes to the developer.  The developer will need to print the entire document, complete and sign the Certification page, and mail it back to NCHFA along with the Independent Auditors' Report (Auditor Cert tab) on auditors' letterhead."]
[]
[]
[]
[]
[]
[]
[]
[null,"Should you have any problems or questions completing this form, please contact Chris Austin"]
[null,"at (919) 877-5662 or by email at",null,null,null,"claustin@nchfa.com"]
[]
[]
[null,"The items below must be submitted to NCHFA, at the time the Final Cost Certification is emailed to the Development Analyst, 2-hole punched at the top of the page in the following order:"]
[]
[]
[null,"1.   Current Certificate of Existence for LP or LLC"]
[null,"2.   Any amendments to the Operating Agreement not previously submitted to NCHFA's Legal Department"]
[null,"3.   Certificate of Occupancy for each building"]
[null,"4.   Executed Promissory Note or most recent commitment letter (less than 6 months old) from all lenders"]
[null,"5.   Investor Certification Letter - letter from the equity provider indicating the per credit pricing, total equity"]
[null,null,null,null,"contributed to the project as well as their ownership interest in the project"]
[null,"6.   Current utility allowance schedule"]
[null,"7.   Executed Rental Assistance contract (if applicable)"]
[null,"8.   Copy of latest tax and insurance bills"]
[null,"9.   Final Site Visit form issued by NCHFA and signed by the owner"]
[null,"10. Energy Star certification"]
[null,"11. Evidence owner and management company have attended Agency approved LIHTC compliance seminar"]
[null,null,"within the last 12 months.  \"Owner\" is defined as an individual within the ownership entity who has"]
[null,null,"decision-making authority."]
[null,"12. Listing of the name and address for all contractors and subcontractors (2012 awards and later)"]
[null,"13. Monitoring Fee"]
[]
[]
[null,"Mailing Address:",null,null,null,{"$f":"IF(H44=\"\",\"\",\"Project Name:  \")","v":""},null,{"$f":"IF(Costs!B6=\"\",\"\",Costs!B6)","v":""}]
[null,"NCHFA"]
[null,"Attn: Rental Investment",null,null,null,{"$f":"IF(H46=\"\",\"\",\"Project #:  \")","v":""},null,{"$f":"IF(Costs!F6=\"\",\"\",Costs!F6)","v":""}]
[null,"3508 Bush Street"]
[null,"Raleigh, NC  27609-7509",null,null,null,"Version 1.6"]
[]
[null,"Last Updated"]
[null,"2006-03-13"]

{"sheet":"Costs","index":1,"n_rows":85,"n_cols":11,"rows_kept":85,"cut":false,"hidden":false,"merged":[[8,4,8,5],[1,1,1,5],[84,1,84,2]]}
[]
[null,"Project Development Costs"]
[]
[]
[null,"Project Name:",null,"Year Awarded:",null,"Project #:"]
[]
[]
[null,null,null,null,null,null,null,2011]
[null,"Cost","Total",null,"Eligible Basis",null,null,2012]
[null,"Element","Cost",null,"30% PV","70% PV",null,2013]
[null,"1.    Purchase of Building(s) (Rehab / Adaptive Reuse only)",null,null,null,null,null,2014]
[null,"2.    Demolition (Rehab / Adaptive Reuse only)"]
[null,"3.    On-site Improvements"]
[null,"4.    Rehabilitation"]
[null,"5.    Construction of New Building(s)"]
[null,"6.    Accessory Building(s)"]
[null,"7.    General Requirements (max 6% lines 2-6)",null,{"$f":"IF(ISBLANK(C17),0,C17/SUM(C12:C16))","v":0}]
[null,"8.    Contractor Overhead (max 2% lines 2-7)",null,{"$f":"IF(ISBLANK(C18),0,C18/SUM(C12:C17))","v":0}]
[null,"9.    Contractor Profit (max 8% lines 2-7; 6% if Identity of Interest)",null,{"$f":"IF(ISBLANK(C19),0,C19/SUM(C12:C17))","v":0}]
[null,"10.  Construction Contingency (max 5% lines 2-9, Rehabs 10%)",null,{"$f":"IF(ISBLANK(C20),0,C20/SUM(C12:C19))","v":0}]
[null,"11.  Architect's Fee - Design (11 + 12 = max 3% lines 2-10)"]
[null,"12.  Architect's Fee - Inspection",null,{"$f":"IF(ISBLANK(C21),0,(C21+C22)/SUM(C12:C20))","v":0}]
[null,"13.  Engineering Costs"]
[null,"       Subtotal  (lines 1 through 13)",{"$f":"SUM(C11:C23)","v":0}]
[null,"14.  Construction Insurance (prorate)"]
[null,"15.  Construction Loan Origination Fee (prorate)"]
[null,"16.  Construction Loan Interest (prorate)"]
[null,"17.  Construction Loan Credit Enhancement (prorate)"]
[null,"18.  Construction Period Taxes (prorate)"]
[null,"19.  Water, Sewer and Impact Fees"]
[null,"20.  Survey"]
[null,"21.  Property Appraisal"]
[null,"22.  Environmental Report"]
[null,"23.  Market Study"]
[null,"24.  Bond Costs"]
[null,"25.  Bond Issuance Costs"]
[null,"26.  Placement Fee"]
[null,"27.  Permanent Loan Origination Fee  "]
[null,"28.  Permanent Loan Credit Enhancement  "]
[null,"29.  Title and Recording"]
[null,"       Subtotal  (lines 14 through 29)",{"$f":"SUM(C25:C40)","v":0}]
[null,"30.  Real Estate Attorney"]
[null,"31.  Other Attorney's Fees"]
[null,"32.  Tax Credit Application Fees (Preliminary and Full)",{"$f":"IF(D6=\"\",0,IF(D6=2011,2400,IF(D6=2012,2440,IF(D6=2013,2480,2520))))","v":0},"Amount Paid"]
[null,"33.  Tax Credit Allocation Fee",null,null,null,null,null,"STC","RPP"]
[null,"34.  State Tax Credit Closing Fee",{"$f":"H46","v":0},null,null,null,null,{"$f":"IF(Sources!C19>0,1500,0)","v":0},{"$f":"IF(Sources!C10>0,2000,0)","v":0}]
[null,"35.  RPP Closing Fee",{"$f":"I46","v":0}]
[null,"36.  Cost Certification / Accounting Fees",null,null,null,null,null,null,{"$f":"IF(D6=\"\",0,IF(D6=2011,740,IF(D6=2012,760,IF(D6=2013,780,IF(D6=2014,800,0)))))","v":0},"Asset Mgmt Fee"]
[null,"37.  Tax Opinion"]
[null,"38.  Organizational (Partnership)",null,null,null,null,null,null,"New",null,{"$f":"IF(C15=\"\",0,IF(D6=2011,0,IF(D6=2012,0,IF(D6=2013,0,IF(I51>1100000,1100000,I51)))))","v":0}]
[null,"39.  Tax Credit Monitoring Fee",null,{"$f":"I48*('Unit Mix'!F35)","v":0},null,null,null,"Rehab",{"$f":"IF(C14>0,0,J51*'Unit Mix'!F35)","v":0},{"$f":"IF(D6=\"\",0,IF(D6=2011,11500,IF(D6=2014,12500,12000)))","v":0},{"$f":"IF(C15=\"\",0,IF(D6=2014,0,IF(I51>1000000,1000000,I51)))","v":0}]
[null,"       Subtotal  (lines 30 through 39)",{"$f":"SUM(C42:C51)","v":0},null,null,null,null,{"$f":"IF(C15>0,0,IF(C14=\"\",0,IF(D6=2014,0,IF(H53>1000000,1000000,H53))))","v":0},{"$f":"IF(C15>0,0,IF(C14=\"\",0,IF(D6=2011,0,IF(D6=2012,0,IF(D6=2013,0,IF(H53>1100000,1100000,H53))))))","v":0}]
[null,"40.  Furnishings and Equipment",null,null,null,null,null,{"$f":"J53*C14","v":0},"% of rehab",{"$f":"IF(D6=\"\",0,IF(D6=2011,0.275,IF(D6=2014,0.285,0.28)))","v":0}]
[null,"41.  Relocation Expense",null,"Max Dev Fee"]
[null,"42.  Developer Fee",null,{"$f":"H52+K50+K51+I52","v":0}]
[null,"43.  Additional Contingency (line 68 must equal or be less than Award)"]
[null,"44.  Other Basis Expense (specify)"]
[null,"45.  Other Basis Expense (specify)",null,null,null,null,null,"$1,500/unit"]
[null,"46.  Rent-up Expense",null,null,null,null,null,{"$f":"1500*'Unit Mix'!F35","v":0}]
[null,"47.  Other Non-Basis Expense (specify)"]
[null,"48.  Other Non-Basis Expense (specify)",null,null,null,null,null,"6 Mos DS/OE"]
[null,"       Subtotal  (lines 40 through 48)",{"$f":"SUM(C53:C61)","v":0},null,null,null,null,{"$f":"ROUND(('Op Budg'!F65+'Cash Flow'!D28)/2,0)","v":0}]
[null,"49.  Rent-up Reserve",null,{"$f":"300*'Unit Mix'!F35","v":0}]
[null,"50.  Operating Reserve",null,{"$f":"IF(H59>H62,H59,H62)","v":0}]
[null,"51.  Other Reserve (specify)"]
[null,"52.  Other Reserve (specify)"]
[null,"53.  Development Cost (lines 1 through 52)",{"$f":"C24+C41+C52+C62+SUM(C63:C66)","v":0},null,{"$f":"SUM(E11:E66)","v":0},{"$f":"SUM(F11:F66)","v":0}]
[null,"54.  Less Federally Funded Grant",null,null,null,{"$f":"PDC_Less_Fed_Financ_other_than_CDBG","v":0}]
[null,"55.  Less Disproportionate Standard "]
[null,"56.  Less Nonqualified Nonrecourse Financing"]
[null,"57.  Less Historic Tax Credit",null,null,null,{"$f":"PDC_Less_Historic_Tax_Credit","v":0}]
[null,"58.  Total Eligible Basis",{"$f":"E72+F72","v":0},null,{"$f":"E67-PDC_Less_Disproportionate_Std_30_PV-PDC_Less_Nonqual_Nonrecourse_Financ_30_PV","v":0},{"$f":"F67-PDC_Less_Fed_Financ_other_than_CDBG_70_PV-PDC_Less_Disproportionate_Std_70_PV-PDC_Less_Nonqual_Nonrecourse_Financ_70_PV-F71","v":0}]
[null,"59.  Applicable Fraction (percentage of Low Income units)",null,null,1,1]
[null,"60.  Basis Before Boost",{"$f":"E74+F74","v":0},null,{"$f":"E72*PDC_Times_Applicable_Fraction_30_PV","v":0},{"$f":"F72*PDC_Times_Applicable_Fraction_70_PV","v":0}]
[null,"61.  Basis Boost of up to 130%",null,null,1,1]
[null,"62.  Total Qualified Basis",{"$f":"E76+F76","v":0},null,{"$f":"E74*E75","v":0},{"$f":"IF(F75>1,ROUND(F74*F75,0),F74*F75)","v":0}]
[null,"63.  Tax Credit Rate",null,null,0,0]
[null,"64.  Federal Tax Credits at Locked In Rate",{"$f":"E78+F78","v":0},null,{"$f":"E76*PDC_Tax_Credit_Rate_30_PV","v":0},{"$f":"F76*PDC_Tax_Credit_Rate_70_PV","v":0}]
[null,"65.  Federal Tax Credits Reserved per Carryover Agreement"]
[null,"66.  Federal Tax Credits Requested (if less than line 65)",{"$f":"E80+F80","v":0},null,0,0]
[null,"67.  Land Cost"]
[null,"68.  Total Replacement Cost",{"$f":"C67+PDC_Land_Cost","v":0}]
[]
[null,"Project Development Cost per Unit (New Construction only)",{"$f":"IF(C15=\"\",\"\",IF('Unit Mix'!F35=0,\"\",C15/'Unit Mix'!F35))","v":""}]
[null,"Will not calculate until Unit Mix page is complete"]

{"sheet":"Sources","index":2,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,1,1,7],[30,1,30,2],[30,4,34,7],[37,1,43,7]]}
[]
[null,"Project Funding Sources"]
[]
[null,"Project Name:"]
[null,{"$f":"IF(Costs!B6=\"\",\"\",Costs!B6)","v":""},null,null,null,"Project #:",{"$f":"IF(Costs!F6=\"\",\"\",Costs!F6)","v":""}]
[]
[]
[null,"Source","Amount","% of   Total","Rate","Term","Amort     Period","Annual D.S."]
[null,"Bank Loan",null,{"$f":"IF($C$27=0,0,C9/$C$27)","v":0}]
[null,"RPP Loan",null,0]
[null,"Local Government Loan",null,0]
[null,"RD 515 Loan",null,0]
[null,"AHP Loan",null,0]
[null,"Other Loan",null,0]
[null,"Non-Amortizing Loan*",null,0]
[null,"Non-Amortizing Loan*",null,0]
[null,"Non-Amortizing Loan*",null,0]
[null,"Tax Exempt Bond*",null,0]
[null,"State Tax Credit (Loan)",null,0,0,30,30]
[null,"State Tax Credit (Direct Refund)",null,0]
[null,"Federal LIHTC Equity",null,0]
[null,"Non-Repayable Grant",null,0]
[null,"Historic Tax Credit",null,0]
[null,"Deferred Developer Fee",null,0]
[null,"Owner Investment",null,0]
[null,"Other",null,{"$f":"IF($C$26=0,0,C26/$C$27)","v":0}]
[null,"Total Sources",{"$f":"SUM(C9:C26)","v":0},{"$f":"SUM(D9:D26)","v":0}]
[null,{"$f":"IF(C28=\"\",\"\",IF(C28>0, \"Additional funds needed to balance\",\"Reduce sources to balance\"))","v":""},{"$f":"IF(Costs!C82-Sources!C27=0,\"\",Costs!C82-Sources!C27)","v":""}]
[null,"*Debt Service entered will carry to the Cash Flow page but can be edited on the Cash Flow page"]
[null,null,null,null,{"$f":"IF(C21<>C35,\"Explain why actual equity differs from calculated equity\",\"\")","v":""}]
[null,"Federal LIHTC Equity Calculator"]
[null,"Total Credits (from Credit Info page)",{"$f":"('Credit Info'!L53+'Credit Info'!M53)","v":0}]
[null,"Limited Partner Interest"]
[null,"Price on sale of Federal LIHTC Credits"]
[null,"Total Federal LIHTC Equity",{"$f":"IF(C32>0,ROUND(C32*10*C33*C34,0),\"\")","v":""}]
[]
[null,"Describe any significant changes to the funding sources since full application"]

{"sheet":"Credit Info","index":3,"n_rows":57,"n_cols":13,"rows_kept":57,"cut":false,"hidden":false,"merged":[[1,1,1,12],[8,3,8,4],[8,5,8,6],[8,11,8,12],[8,8,8,9],[4,9,4,10],[55,11,55,12],[52,1,52,2],[54,10,54,12],[53,11,53,12],[54,5,54,6],[54,8,54,9],[55,5,55,6],[55,8,55,9],[53,8,53,9],[53,5,53,6]]}
[]
[null,"Building by Building Credit Allocation"]
[]
[]
[null,"Project Name:",{"$f":"IF(Costs!B6=\"\",\"\",Costs!B6)","v":""},null,null,null,null,null,null,"Project #:",null,{"$f":"IF(Costs!F6=\"\",\"\",Costs!F6)","v":""}]
[]
[null,null,null,"No","Was this project in a QCT or DDA when credits were awarded?",null,null,null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,"Address of Building","Placed in Service Date",null,"Eligible Basis",null,"QCT / DDA","Qualified Basis",null,"Credit","Credit Amount"]
[null,"BIN","(must be actual street address)","New / Rehab","Acquisition","New / Rehab","Acquisition","Boost","New / Rehab","Acquisition","Rate","New / Rehab","Acquistion"]
[null,null,null,null,null,null,null,{"$f":"IF(B11=\"\",\"\",IF($D$7=\"\",\"\",IF(E11>0,\"100%\",IF(G11>0,\"100%\",IF($D$7=\"\",\"\",IF($D$7=\"No\",\"100%\",\"130%\"))))))","v":""},{"$f":"IF(H11=\"\",\"\",IF(F11=\"\",\"\",IF(H11=100,F11*H11,ROUND(F11*H11,0))))","v":""},{"$f":"IF(H11=\"\",\"\",IF(G11>0,G11*H11,\"\"))","v":""},null,{"$f":"IF(E11>0,\"\",IF(G11>0,\"\",IF(H11=\"\",\"\",IF(F11=0,\"\",IF(D11=\"\",\"\",ROUND(I11*K11,0))))))","v":""},{"$f":"IF(D11>0,\"\",IF(F11>0,\"\",IF(G11=0,\"\",IF(J11=\"\",\"\",IF(E11=\"\",\"\",ROUND(J11*K11,0))))))","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IF(H12=\"\",\"\",IF(F12=\"\",\"\",IF(H12=100,F12*H12,ROUND(F12*H12,0))))","v":""},{"$f":"IF(H12=\"\",\"\",IF(G12>0,G12*H12,\"\"))","v":""},null,{"$f":"IF(E12>0,\"\",IF(G12>0,\"\",IF(H12=\"\",\"\",IF(F12=0,\"\",IF(D12=\"\",\"\",ROUND(I12*K12,0))))))","v":""},{"$f":"IF(D12>0,\"\",IF(F12>0,\"\",IF(G12=0,\"\",IF(J12=\"\",\"\",IF(E12=\"\",\"\",ROUND(J12*K12,0))))))","v":""}]
[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,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,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,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,{"$f":"SUM(F11:F52)","v":0},{"$f":"SUM(G11:G52)","v":0},null,{"$f":"SUM(I11:I52)","v":0},{"$f":"SUM(J11:J52)","v":0},null,{"$f":"SUM(L11:L52)","v":0},{"$f":"SUM(M11:M52)","v":0}]
[null,"Note: Acquisition credits should be entered on a separate line from New / Rehab credits",null,null,null,{"$f":"F53+G53","v":0},null,null,{"$f":"I53+J53","v":0},null,null,{"$f":"L53+M53","v":0}]
[null,null,null,null,null,{"$f":"IF(F54<>F57,\"Does not equal Costs Total\",\"\")","v":""},null,null,{"$f":"IF(I54<>I57,\"Does not equal Costs Total\",\"\")","v":""},null,{"$f":"IF(L54>L57,\"         Credits exceed amount Reserved\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(F54<>F57,\"Eligible Basis (Costs Page)\",\"\")","v":""},null,null,{"$f":"IF(I54<>I57,\"Qualified Basis (Costs Page)\",\"\")","v":""},null,null,{"$f":"IF(L54>L57,\"         (line 64 of Costs page)\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"Costs!C72","v":0},null,null,{"$f":"Costs!C76","v":0},null,null,{"$f":"Costs!C79","v":0}]

{"sheet":"Bldg Info","index":4,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[51,1,51,7],[1,1,1,9],[4,5,4,6],[4,7,4,9],[7,3,7,8]]}
[]
[null,"Building Unit Info"]
[]
[]
[null,"Project Name:",{"$f":"IF('Credit Info'!C5=0,\"\",'Credit Info'!C5)","v":""},null,null,"Project #:",null,{"$f":"IF('Credit Info'!L5=0,\"\",'Credit Info'!L5)","v":""}]
[]
[]
[null,null,null,"Unit Info"]
[null,"BIN","Address of Building","Eff","1BR","2BR","3BR","4BR","5BR","Total"]
[null,{"$f":"IF('Credit Info'!B11=\"\",\"\",IF('Credit Info'!G11>0,\"\",'Credit Info'!B11))","v":""},{"$f":"IF('Credit Info'!C11=\"\",\"\",IF('Credit Info'!G11>0,\"\",'Credit Info'!C11))","v":""},null,null,null,null,null,null,{"$f":"IF(B10=\"\",\"\",(SUM(D10:I10)))","v":""}]
[null,{"$f":"IF('Credit Info'!B12=\"\",\"\",IF('Credit Info'!G12>0,\"\",'Credit Info'!B12))","v":""},{"$f":"IF('Credit Info'!C12=\"\",\"\",IF('Credit Info'!G12>0,\"\",'Credit Info'!C12))","v":""},null,null,null,null,null,null,{"$f":"IF(B11=\"\",\"\",(SUM(D11:I11)))","v":""}]
[null,{"$f":"IF('Credit Info'!B13=\"\",\"\",IF('Credit Info'!G13>0,\"\",'Credit Info'!B13))","v":""},{"$f":"IF('Credit Info'!C13=\"\",\"\",IF('Credit Info'!G13>0,\"\",'Credit Info'!C13))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B14=\"\",\"\",IF('Credit Info'!G14>0,\"\",'Credit Info'!B14))","v":""},{"$f":"IF('Credit Info'!C14=\"\",\"\",IF('Credit Info'!G14>0,\"\",'Credit Info'!C14))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B15=\"\",\"\",IF('Credit Info'!G15>0,\"\",'Credit Info'!B15))","v":""},{"$f":"IF('Credit Info'!C15=\"\",\"\",IF('Credit Info'!G15>0,\"\",'Credit Info'!C15))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B16=\"\",\"\",IF('Credit Info'!G16>0,\"\",'Credit Info'!B16))","v":""},{"$f":"IF('Credit Info'!C16=\"\",\"\",IF('Credit Info'!G16>0,\"\",'Credit Info'!C16))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B17=\"\",\"\",IF('Credit Info'!G17>0,\"\",'Credit Info'!B17))","v":""},{"$f":"IF('Credit Info'!C17=\"\",\"\",IF('Credit Info'!G17>0,\"\",'Credit Info'!C17))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B18=\"\",\"\",IF('Credit Info'!G18>0,\"\",'Credit Info'!B18))","v":""},{"$f":"IF('Credit Info'!C18=\"\",\"\",IF('Credit Info'!G18>0,\"\",'Credit Info'!C18))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B19=\"\",\"\",IF('Credit Info'!G19>0,\"\",'Credit Info'!B19))","v":""},{"$f":"IF('Credit Info'!C19=\"\",\"\",IF('Credit Info'!G19>0,\"\",'Credit Info'!C19))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B20=\"\",\"\",IF('Credit Info'!G20>0,\"\",'Credit Info'!B20))","v":""},{"$f":"IF('Credit Info'!C20=\"\",\"\",IF('Credit Info'!G20>0,\"\",'Credit Info'!C20))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B21=\"\",\"\",IF('Credit Info'!G21>0,\"\",'Credit Info'!B21))","v":""},{"$f":"IF('Credit Info'!C21=\"\",\"\",IF('Credit Info'!G21>0,\"\",'Credit Info'!C21))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B22=\"\",\"\",IF('Credit Info'!G22>0,\"\",'Credit Info'!B22))","v":""},{"$f":"IF('Credit Info'!C22=\"\",\"\",IF('Credit Info'!G22>0,\"\",'Credit Info'!C22))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B23=\"\",\"\",IF('Credit Info'!G23>0,\"\",'Credit Info'!B23))","v":""},{"$f":"IF('Credit Info'!C23=\"\",\"\",IF('Credit Info'!G23>0,\"\",'Credit Info'!C23))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B24=\"\",\"\",IF('Credit Info'!G24>0,\"\",'Credit Info'!B24))","v":""},{"$f":"IF('Credit Info'!C24=\"\",\"\",IF('Credit Info'!G24>0,\"\",'Credit Info'!C24))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B25=\"\",\"\",IF('Credit Info'!G25>0,\"\",'Credit Info'!B25))","v":""},{"$f":"IF('Credit Info'!C25=\"\",\"\",IF('Credit Info'!G25>0,\"\",'Credit Info'!C25))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B26=\"\",\"\",IF('Credit Info'!G26>0,\"\",'Credit Info'!B26))","v":""},{"$f":"IF('Credit Info'!C26=\"\",\"\",IF('Credit Info'!G26>0,\"\",'Credit Info'!C26))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B27=\"\",\"\",IF('Credit Info'!G27>0,\"\",'Credit Info'!B27))","v":""},{"$f":"IF('Credit Info'!C27=\"\",\"\",IF('Credit Info'!G27>0,\"\",'Credit Info'!C27))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B28=\"\",\"\",IF('Credit Info'!G28>0,\"\",'Credit Info'!B28))","v":""},{"$f":"IF('Credit Info'!C28=\"\",\"\",IF('Credit Info'!G28>0,\"\",'Credit Info'!C28))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B29=\"\",\"\",IF('Credit Info'!G29>0,\"\",'Credit Info'!B29))","v":""},{"$f":"IF('Credit Info'!C29=\"\",\"\",IF('Credit Info'!G29>0,\"\",'Credit Info'!C29))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B30=\"\",\"\",IF('Credit Info'!G30>0,\"\",'Credit Info'!B30))","v":""},{"$f":"IF('Credit Info'!C30=\"\",\"\",IF('Credit Info'!G30>0,\"\",'Credit Info'!C30))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B31=\"\",\"\",IF('Credit Info'!G31>0,\"\",'Credit Info'!B31))","v":""},{"$f":"IF('Credit Info'!C31=\"\",\"\",IF('Credit Info'!G31>0,\"\",'Credit Info'!C31))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B32=\"\",\"\",IF('Credit Info'!G32>0,\"\",'Credit Info'!B32))","v":""},{"$f":"IF('Credit Info'!C32=\"\",\"\",IF('Credit Info'!G32>0,\"\",'Credit Info'!C32))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B33=\"\",\"\",IF('Credit Info'!G33>0,\"\",'Credit Info'!B33))","v":""},{"$f":"IF('Credit Info'!C33=\"\",\"\",IF('Credit Info'!G33>0,\"\",'Credit Info'!C33))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B34=\"\",\"\",IF('Credit Info'!G34>0,\"\",'Credit Info'!B34))","v":""},{"$f":"IF('Credit Info'!C34=\"\",\"\",IF('Credit Info'!G34>0,\"\",'Credit Info'!C34))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B35=\"\",\"\",IF('Credit Info'!G35>0,\"\",'Credit Info'!B35))","v":""},{"$f":"IF('Credit Info'!C35=\"\",\"\",IF('Credit Info'!G35>0,\"\",'Credit Info'!C35))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B36=\"\",\"\",IF('Credit Info'!G36>0,\"\",'Credit Info'!B36))","v":""},{"$f":"IF('Credit Info'!C36=\"\",\"\",IF('Credit Info'!G36>0,\"\",'Credit Info'!C36))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B37=\"\",\"\",IF('Credit Info'!G37>0,\"\",'Credit Info'!B37))","v":""},{"$f":"IF('Credit Info'!C37=\"\",\"\",IF('Credit Info'!G37>0,\"\",'Credit Info'!C37))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B38=\"\",\"\",IF('Credit Info'!G38>0,\"\",'Credit Info'!B38))","v":""},{"$f":"IF('Credit Info'!C38=\"\",\"\",IF('Credit Info'!G38>0,\"\",'Credit Info'!C38))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B39=\"\",\"\",IF('Credit Info'!G39>0,\"\",'Credit Info'!B39))","v":""},{"$f":"IF('Credit Info'!C39=\"\",\"\",IF('Credit Info'!G39>0,\"\",'Credit Info'!C39))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B40=\"\",\"\",IF('Credit Info'!G40>0,\"\",'Credit Info'!B40))","v":""},{"$f":"IF('Credit Info'!C40=\"\",\"\",IF('Credit Info'!G40>0,\"\",'Credit Info'!C40))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B41=\"\",\"\",IF('Credit Info'!G41>0,\"\",'Credit Info'!B41))","v":""},{"$f":"IF('Credit Info'!C41=\"\",\"\",IF('Credit Info'!G41>0,\"\",'Credit Info'!C41))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B42=\"\",\"\",IF('Credit Info'!G42>0,\"\",'Credit Info'!B42))","v":""},{"$f":"IF('Credit Info'!C42=\"\",\"\",IF('Credit Info'!G42>0,\"\",'Credit Info'!C42))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B43=\"\",\"\",IF('Credit Info'!G43>0,\"\",'Credit Info'!B43))","v":""},{"$f":"IF('Credit Info'!C43=\"\",\"\",IF('Credit Info'!G43>0,\"\",'Credit Info'!C43))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B44=\"\",\"\",IF('Credit Info'!G44>0,\"\",'Credit Info'!B44))","v":""},{"$f":"IF('Credit Info'!C44=\"\",\"\",IF('Credit Info'!G44>0,\"\",'Credit Info'!C44))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B45=\"\",\"\",IF('Credit Info'!G45>0,\"\",'Credit Info'!B45))","v":""},{"$f":"IF('Credit Info'!C45=\"\",\"\",IF('Credit Info'!G45>0,\"\",'Credit Info'!C45))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B46=\"\",\"\",IF('Credit Info'!G46>0,\"\",'Credit Info'!B46))","v":""},{"$f":"IF('Credit Info'!C46=\"\",\"\",IF('Credit Info'!G46>0,\"\",'Credit Info'!C46))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B47=\"\",\"\",IF('Credit Info'!G47>0,\"\",'Credit Info'!B47))","v":""},{"$f":"IF('Credit Info'!C47=\"\",\"\",IF('Credit Info'!G47>0,\"\",'Credit Info'!C47))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B48=\"\",\"\",IF('Credit Info'!G48>0,\"\",'Credit Info'!B48))","v":""},{"$f":"IF('Credit Info'!C48=\"\",\"\",IF('Credit Info'!G48>0,\"\",'Credit Info'!C48))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B49=\"\",\"\",IF('Credit Info'!G49>0,\"\",'Credit Info'!B49))","v":""},{"$f":"IF('Credit Info'!C49=\"\",\"\",IF('Credit Info'!G49>0,\"\",'Credit Info'!C49))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B50=\"\",\"\",IF('Credit Info'!G50>0,\"\",'Credit Info'!B50))","v":""},{"$f":"IF('Credit Info'!C50=\"\",\"\",IF('Credit Info'!G50>0,\"\",'Credit Info'!C50))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B51=\"\",\"\",IF('Credit Info'!G51>0,\"\",'Credit Info'!B51))","v":""},{"$f":"IF('Credit Info'!C51=\"\",\"\",IF('Credit Info'!G51>0,\"\",'Credit Info'!C51))","v":""},null,null,null,null,null,null,""]
[null,{"$f":"IF('Credit Info'!B52=\"\",\"\",IF('Credit Info'!G52>0,\"\",'Credit Info'!B52))","v":""},{"$f":"IF('Credit Info'!C52=\"\",\"\",IF('Credit Info'!G52>0,\"\",'Credit Info'!C52))","v":""},null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J10:J51)","v":0}]
[null,"Note: for Rehab & Acquisition, info should only be entered once for each building"]

{"sheet":"Unit Mix","index":5,"n_rows":105,"n_cols":20,"rows_kept":105,"cut":false,"hidden":false,"merged":[[48,4,54,13],[43,9,43,10],[7,2,7,5],[1,1,1,13],[10,12,10,13],[4,1,4,2],[4,3,4,6]]}
[]
[null,"Unit Mix"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"County","Median Income"]
[null,"Project Name:",null,{"$f":"IF('Credit Info'!C5=0,\"\",'Credit Info'!C5)","v":""},null,null,null,null,null,null,null,"Project #:",{"$f":"IF('Credit Info'!L5=0,\"\",'Credit Info'!L5)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alamance",56100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alexander",51100]
[null,"County:",null,null,null,null,null,null,null,null,"Median Income:",{"$f":"IF(C8=\"\",\"\",VLOOKUP(C8,S5:T105,2))","v":""},null,null,null,null,null,null,"Alleghany",41000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anson",42100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ashe",49500]
[null,null,null,null,"HOME",null,"Accessible","Net","Monthly","Utility","Total Housing","% of","Yearly Income",null,{"$f":"'Bldg Info'!J52","v":0},null,null,null,"Avery",50600]
[null,"# BRs","Type*","# Baths","Trend?","# of Units","Units","Sq Feet","Rent","Allowance","Cost","Median","Non-HOME","HOME",null,null,null,null,"Beaufort",52800]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B13=0,\"\",I13+J13)","v":""},{"$f":"IF($L$8=\"\",\"\",IF(B13=\"\",\"\",IF(B13=\"Eff\",K13*12/0.3/($L$8*0.7),IF(B13=1,K13*12/0.3/($L$8*0.75),IF(B13=2,K13*12/0.3/($L$8*0.9),IF(B13=3,K13*12/0.3/($L$8*1.04),K13*12/0.3/($L$8*1.16)))))))","v":""},{"$f":"IF(B13=\"\",\"\",IF(F13=\"\",\"\",IF(E13=\"No\",F13*I13*12,\"\")))","v":""},{"$f":"IF(B13=\"\",\"\",IF(F13=\"\",\"\",IF(E13=\"Yes\",F13*I13*12,\"\")))","v":""},null,null,null,null,"Bertie",41900]
[null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"Bladen",44600]
[null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"Brunswick",62700]
[null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"Buncombe",58400]
[null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"Burke",51100]
[null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"Cabarrus",64100]
[null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"Caldwell",51100]
[null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"Camden",79000]
[null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"Carteret",60600]
[null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"Caswell",4720]
[null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"Catawba",51100]
[null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"Chatham",67700]
[null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"Cherokee",47800]
[null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"Chowan",48800]
[null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"Clay",41900]
[null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"Cleveland",50500]
[null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"Columbus",48000]
[null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"Craven",58000]
[null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"Cumberland",52700]
[null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"Currituck",73300]
[null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"Dare",69900]
[null,null,null,null,null,null,null,null,null,null,"","","","",null,null,null,null,"Davidson",56700]
[null,null,null,null,null,{"$f":"SUM(F13:F34)","v":0},{"$f":"SUM(G13:G34)","v":0},null,null,null,null,null,{"$f":"SUM(M13:M34)","v":0},{"$f":"SUM(N13:N34)","v":0},null,null,null,null,"Davie",59500]
[null,null,null,null,null,{"$f":"IF(F35<>O11,\"Does not equal Total from Bldg Info page\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Duplin",43300]
[null,"Note: HOME units must be listed on a separate line from non-HOME units",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Durham",67700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Edgecombe",55300]
[null,null,"*Legend",null,null,null,null,"Rent includes the following Utilities",null,null,null,null,null,null,null,null,null,null,"Forsyth",59500]
[null,null,"G = Garden",null,null,null,null,null,"Water / Sewer",null,null,null,null,null,null,null,null,null,"Franklin",79900]
[null,null,"T = Townhouse",null,null,null,null,null,"Electric",null,null,null,null,null,null,null,null,null,"Gaston",64100]
[null,null,"D = Duplex",null,null,null,null,null,"Gas",null,null,null,null,null,null,null,null,null,"Gates",59000]
[null,null,"S = Single Family",null,null,null,null,null,"Trash",null,null,null,null,null,null,null,null,null,"Graham",37000]
[null,null,null,null,null,null,null,null,"Other",null,null,null,null,null,null,null,null,null,"Granville",60800]
[null,"Eff","G",1,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,"Greene",51400]
[null,1,"T",1.5,"Yes","x",null,null,null,null,null,null,null,null,null,null,null,null,"Guilford",58000]
[null,2,"D",1.75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Halifax",43100]
[null,3,"S",2,"Describe any special restrictions on units",null,null,null,null,null,null,null,null,null,null,null,null,null,"Harnett",55700]
[null,4,null,2.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Haywood",54800]
[null,5,null,2.75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Henderson",58400]
[null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hertford",42500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hoke",50300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hyde",47200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iredell",61800]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jackson",52600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Johnston",79900]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jones",48800]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lee",56700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lenoir",45000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lincoln",58200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Macon",50300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Madison",58400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Martin",46000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"McDowell",50200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mecklenburg",64100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mitchell",44300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Montgomery",46500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moore",63600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nash",55300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Hanover",62700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Northampton",42800]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Onslow",48800]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orange",67700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pamlico",54900]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pasquotank",58200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pender",57500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perquimans",51900]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Person",58200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pitt",57600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polk",59400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Randolph",58000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Richmond",41300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Robeson",33700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rockingham",51000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rowan",57000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rutherford",41300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sampson",47100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scotland",39600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stanly",61800]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stokes",59500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surry",48900]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Swain",51100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transylvania",56700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tyrrell",40100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Union",64100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vance",43600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wake",79900]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warren",42900]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Washington",43600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Watauga",59600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wayne",54000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wilkes",42500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wilson",45800]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yadkin",59500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yancey",44900]

{"sheet":"Op Budg","index":6,"n_rows":76,"n_cols":6,"rows_kept":76,"cut":false,"hidden":false,"merged":[[9,2,9,4],[14,2,14,4],[10,2,10,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[19,2,19,4],[20,2,20,4],[21,1,26,1],[21,2,21,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[7,1,20,1],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[7,2,7,4],[8,2,8,4],[27,1,48,1],[27,2,27,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[34,2,34,4],[35,2,35,4],[40,2,40,4],[41,2,41,4],[42,2,42,4],[43,2,43,4],[36,2,36,4],[37,2,37,4],[44,2,44,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[38,2,38,4],[39,2,39,4],[60,2,60,4],[61,2,61,4],[62,2,62,4],[48,2,48,4],[56,2,56,4],[53,2,53,4],[54,2,54,4],[55,2,55,4],[76,2,76,4],[63,2,63,4],[64,1,66,1],[64,2,64,4],[65,2,65,4],[66,2,66,4],[71,2,71,4],[72,2,72,4],[73,2,73,4],[74,2,74,4],[69,2,69,4],[1,1,1,5],[3,1,3,2],[4,1,4,3],[68,1,75,1],[68,2,68,4],[70,2,70,4],[75,2,75,4],[57,2,57,4],[58,1,62,1],[58,2,58,4],[49,1,57,1],[49,2,49,4],[50,2,50,4],[51,2,51,4],[52,2,52,4],[59,2,59,4]]}
[]
[null,"Project Operations"]
[]
[null,"Project Name:",null,null,null,"Project #:"]
[null,{"$f":"IF(Costs!B6=\"\",\"\",Costs!B6)","v":""},null,null,null,{"$f":"IF(Costs!F6=\"\",\"\",Costs!F6)","v":""}]
[]
[]
[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(F8:F20)","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(F22:F26)","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(F28:F48)","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(F50:F57)","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(F59:F62)","v":0}]
[null,"Reserves","Replacement Reserves "]
[null,null,"     Total Operating Expenses",null,null,{"$f":"SUM(F21+F27+F49+F58+SuppSvcExp)+F64","v":0}]
[null,null,"Per Unit Cost of Operations",null,null,{"$f":"IF(ISERR(F65/('Unit Mix'!F35)),0,F65/('Unit Mix'!F35))","v":0}]
[null,null,"     Per Unit Cost (less Reserves, RE Taxes, Support Service Expenses)",null,null,{"$f":"IF(F66=0,0,F66-((ReplcmntReserves+SuppSvcExp+RETaxes)/('Unit Mix'!F35)))","v":0}]
[]
[null,"Rental and Other Income","Gross Rental Income",null,null,{"$f":"'Unit Mix'!M35+'Unit Mix'!N35","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(F69:F72)","v":0}]
[null,null,"7% Vacancy Allowance",null,null,{"$f":"F73*0.07","v":0}]
[null,null,"Net Rental and Other Income",null,null,{"$f":"F73-F74","v":0}]
[null,null,"Net Operating Income",null,null,{"$f":"F75-F65","v":0}]

{"sheet":"Cash Flow","index":7,"n_rows":96,"n_cols":33,"rows_kept":96,"cut":false,"hidden":false,"merged":[[95,1,95,2],[44,4,44,5],[44,6,44,7],[2,1,2,2],[45,4,45,5],[45,6,45,7],[46,4,46,5],[32,1,32,2]]}
[]
[null,"Project Name:",null,null,null,"Project #:"]
[null,{"$f":"IF(Costs!B6=\"\",\"\",Costs!B6)","v":""},null,null,null,{"$f":"IF(Costs!F6=\"\",\"\",Costs!F6)","v":""}]
[]
[]
[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,"Expenses Trend",0.03]
[null,"   Gross Rent",null,{"$f":"'Unit Mix'!M35","v":0},{"$f":"D8*(1+$C$6)","v":0},{"$f":"E8*(1+$C$6)","v":0},{"$f":"F8*(1+$C$6)","v":0},{"$f":"G8*(1+$C$6)","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]
[null,"+ HOME Rent (trends at 1.5%)",null,{"$f":"'Unit Mix'!N35","v":0},{"$f":"D9*1.015","v":0},{"$f":"E9*1.015","v":0},{"$f":"F9*1.015","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,"+ Stores/Commercial, Laundry/Vending",null,{"$f":"'Op Budg'!F70+'Op Budg'!F71","v":0},{"$f":"D10*(1+$C$6)","v":0},{"$f":"E10*(1+$C$6)","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":"'Op Budg'!F72","v":0},{"$f":"D11*(1+$C$6)","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,"= Gross Income",null,{"$f":"SUM(D8:D11)","v":0},{"$f":"SUM(E8: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,"-  7% Vacancy Allowance",null,{"$f":"D12*0.07","v":0},{"$f":"E12*0.07","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,"= Net Rental Income",null,{"$f":"D12-D13","v":0},{"$f":"E12-E13","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":"'Op Budg'!F65-'Op Budg'!ReplcmntReserves","v":0},{"$f":"D15*(1+$C$7)","v":0},{"$f":"E15*(1+$C$7)","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":"'Op Budg'!ReplcmntReserves","v":0},{"$f":"D16*(1.04)","v":0},{"$f":"E16*(1.04)","v":0},{"$f":"F16*(1.04)","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,"= Net Operating Income",null,{"$f":"D14-SUM(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,"- Bank Loan",null,{"$f":"D39","v":0},{"$f":"E39","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 Loan",null,{"$f":"D51","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,"- Local Government Loan",null,{"$f":"D57","v":0},{"$f":"E57","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,"- RD 515 Loan",null,{"$f":"D66","v":0},{"$f":"E66","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,"- AHP Loan",null,{"$f":"D75","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,"- Other Loan",null,{"$f":"D$84","v":0},{"$f":"E$84","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,"- Non-Amortizing Loan",null,{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0},{"$f":"Sources!$H$15","v":0}]
[null,"- Non-Amortizing Loan",null,{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0},{"$f":"Sources!$H$16","v":0}]
[null,"- Non-Amortizing Loan",null,{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0},{"$f":"Sources!$H$17","v":0}]
[null,"- Tax Exempt Bond",null,{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0},{"$f":"Sources!$H$18","v":0}]
[null,"Total Debt Service",null,{"$f":"SUM(D18: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,"= Net Cash Flow",null,{"$f":"D17-D28","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(D17/D18),0,D17/D18)","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(D28=0,0,D17/D28)","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":"Sources!C24","v":0},{"$f":"IF(Sources!C24>0,SUM(D29:M29),\"\")","v":""},{"$f":"IF(Sources!C24=\"\",\"\",IF(M33<L33,\"Unable to Repay Deferred Fee within 10 years\",\"10 year Deferred Fee Repayment\"))","v":""},null,null,null,{"$f":"IF(Sources!C24=\"\",\"\",SUM(D29:R29))","v":""},{"$f":"IF(Sources!C24=\"\",\"\",IF(R33<R34,\"Unable to Repay Deferred Fee within 15 years\",\"15 year Deferred Fee Repayment\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L33","v":0}]
[null,{"$f":"Sources!B9","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":"Sources!E9","v":0}]
[null,"Term",{"$f":"Sources!F9","v":0},{"$f":"Sources!G9*12","v":0},{"$f":"D37-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":"Sources!C9","v":0},{"$f":"IF($C$38=0,0,PMT($C$36/12,$D$37,-$C$38))","v":0}]
[null,"P & I",{"$f":"Sources!H9","v":0},{"$f":"IF($C$37<D35,0,$D$38*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$37<AG35,0,$D$38*12)","v":0}]
[null,"   Interest Payment",null,{"$f":"IF($C$37<D35,\"\",D39-D41)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"   Principal Payment",null,{"$f":"IF($C$37<D35,\"\",PV($C$36/12,D37,-($D$38))-PV($C$36/12,E37,-($D$38)))","v":""},{"$f":"IF($C$37<E35,\"\",PV($C$36/12,E37,-($D$38))-PV($C$36/12,F37,-($D$38)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Remaining Principal",null,{"$f":"IF($C$37<D35,\"\",C38-D41)","v":""},{"$f":"IF($C$37<E35,\"\",D42-E41)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,"RPP 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":"B36","v":"Interest Rate"},{"$f":"Sources!E10","v":0},null,"Principal repaid as a ",null,"Total Payments"]
[null,{"$f":"B37","v":"Term"},{"$f":"Sources!F10","v":0},null,"% of original loan",null,{"$f":"SUM(D51:W51)","v":0}]
[null,{"$f":"B38","v":"Loan Principal"},{"$f":"Sources!C10","v":0},null,{"$f":"IF(C47=0,0,SUM(D49:W49)/C47)","v":0},null,"Interest",{"$f":"SUM(D48:W48)","v":0}]
[null,"   Interest Payment",null,{"$f":"IF($C$47>0,C47*$C$45,\"\")","v":""},{"$f":"IF($C$47>0,D$50*$C$45,\"\")","v":""},{"$f":"IF($C$47>0,E$50*$C$45,\"\")","v":""},"","","","","","","","","","","","","","","","",""]
[null,"   Principal Payment",null,{"$f":"IF($C$47>0,D51-D48,\"\")","v":""},{"$f":"IF($C$47>0,E51-E48,\"\")","v":""},{"$f":"IF($C$47>0,F51-F48,\"\")","v":""},"","","","","","","","","","","","","","","","",""]
[null,"Remaining Principal",null,{"$f":"IF($C$47>0,C47-D49,\"\")","v":""},{"$f":"IF($C$47>0,D$50-E$49,\"\")","v":""},{"$f":"IF($C$47>0,E$50-F$49,\"\")","v":""},"","","","","","","","","","","","","","","","",""]
[null,"RPP Annual P&I Payment",null,{"$f":"IF($C$47>0,D93,0)","v":0},{"$f":"IF($C$47>0,E93,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"  "]
[null,{"$f":"Sources!B11","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":"B45","v":"Interest Rate"},{"$f":"Sources!E11","v":0}]
[null,{"$f":"B46","v":"Term"},{"$f":"Sources!F11","v":0},{"$f":"Sources!G11*12","v":0},{"$f":"D55-12","v":-12},{"$f":"E55-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":"B47","v":"Loan Principal"},{"$f":"Sources!C11","v":0},{"$f":"IF($C$56=0,0,PMT($C$54/12,$D$55,-$C$56))","v":0}]
[null,"P & I",{"$f":"Sources!H11","v":0},{"$f":"IF($C$55<D53,0,$D$56*12)","v":0},{"$f":"IF($C$55<E53,0,$D$56*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,"   Interest Payment",null,{"$f":"IF($C$55<D53,\"\",D57-D59)","v":""},{"$f":"IF($C$55<E53,\"\",E57-E59)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"   Principal Payment",null,{"$f":"IF($C$55<D53,\"\",PV($C$54/12,D55,-($D$56))-PV($C$54/12,E55,-($D$56)))","v":""},{"$f":"IF($C$55<E53,\"\",PV($C$54/12,E55,-($D$56))-PV($C$54/12,F55,-($D$56)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Remaining Principal",null,{"$f":"IF($C$55<D53,\"\",C56-D59)","v":""},{"$f":"IF($C$55<E53,\"\",D60-E59)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,{"$f":"Sources!B12","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":"Sources!E12","v":0}]
[null,{"$f":"B37","v":"Term"},{"$f":"Sources!F12","v":0},{"$f":"Sources!G12*12","v":0},{"$f":"D64-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":"Sources!C12","v":0},{"$f":"IF($C$65=0,0,PMT($C$63/12,$D$64,-$C$65))","v":0}]
[null,"P & I",{"$f":"Sources!H12","v":0},{"$f":"IF($C$64<D62,0,$D$65*12)","v":0},{"$f":"IF($C$64<E62,0,$D$65*12)","v":0},{"$f":"IF($C$64<F62,0,$D$65*12)","v":0},{"$f":"IF($C$64<G62,0,$D$65*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$64<D62,\"\",D66-D68)","v":""},{"$f":"IF($C$64<E62,\"\",E66-E68)","v":""},{"$f":"IF($C$64<F62,\"\",F66-F68)","v":""},{"$f":"IF($C$64<G62,\"\",G66-G68)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"   Principal Payment",null,{"$f":"IF($C$64<D62,\"\",PV($C$63/12,D64,-($D$65))-PV($C$63/12,E64,-($D$65)))","v":""},{"$f":"IF($C$64<E62,\"\",PV($C$63/12,E64,-($D$65))-PV($C$63/12,F64,-($D$65)))","v":""},{"$f":"IF($C$64<F62,\"\",PV($C$63/12,F64,-($D$65))-PV($C$63/12,G64,-($D$65)))","v":""},{"$f":"IF($C$64<G62,\"\",PV($C$63/12,G64,-($D$65))-PV($C$63/12,H64,-($D$65)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Remaining Principal",null,{"$f":"IF($C$64<D62,\"\",C65-D68)","v":""},{"$f":"IF($C$64<E62,\"\",D69-E68)","v":""},{"$f":"IF($C$64<F62,\"\",E69-F68)","v":""},{"$f":"IF($C$64<G62,\"\",F69-G68)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,{"$f":"Sources!B13","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":"Sources!E13","v":0}]
[null,{"$f":"B55","v":"Term"},{"$f":"Sources!F13","v":0},{"$f":"Sources!G13*12","v":0},{"$f":"D73-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":"Sources!C13","v":0},{"$f":"IF($C$74=0,0,PMT($C$72/12,$D$73,-$C$74))","v":0}]
[null,"P & I",{"$f":"Sources!H13","v":0},{"$f":"IF($C$73<D71,0,$D$74*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$73<D71,\"\",D75-D77)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"   Principal Payment",null,{"$f":"IF($C$73<D71,\"\",PV($C$72/12,D73,-($D$74))-PV($C$72/12,E73,-($D$74)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Remaining Principal",null,{"$f":"IF($C$73<D71,\"\",C74-D77)","v":""},{"$f":"IF($C$73<E71,\"\",D78-E77)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,{"$f":"Sources!B14","v":"Other 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":"B72","v":"Interest Rate"},{"$f":"Sources!E14","v":0}]
[null,"Term",{"$f":"Sources!F14","v":0},{"$f":"Sources!G14*12","v":0},{"$f":"D82-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":"Sources!C14","v":0},{"$f":"IF($C$83=0,0,PMT($C$81/12,$D$82,-$C$83))","v":0}]
[null,"P & I",{"$f":"Sources!H14","v":0},{"$f":"IF($C$82<D80,0,$D$83*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$82<D80,\"\",D84-D86)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"   Principal Payment",null,{"$f":"IF($C$82<D80,\"\",PV($C$81/12,D82,-($D$83))-PV($C$81/12,E82,-($D$83)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Remaining Principal",null,{"$f":"IF($C$82<D80,\"\",C83-D86)","v":""},{"$f":"IF($C$82<E80,\"\",D87-E86)","v":""},{"$f":"IF($C$82<F80,\"\",E87-F86)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,"RPP 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":"D17/1.15","v":0},{"$f":"E17/1.15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"-  Bank Payment",null,{"$f":"D18","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"-  Other Priority Payment",null,{"$f":"SUM(D$20:D$27)","v":0},{"$f":"SUM(E$20:E$27)","v":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":"D90-D91-D92","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Changing Calculators"]
[null,"To have a calculator amortize another Source, link Name (in light blue), 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":"Owner Cert","index":8,"n_rows":59,"n_cols":16,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,1,1,11],[3,3,3,6],[5,5,5,8],[7,3,7,5],[56,10,56,11],[52,8,52,11],[53,5,53,7],[54,3,54,4],[54,5,54,7],[54,9,54,11],[52,3,52,4],[52,5,52,7],[48,2,48,6],[49,5,49,6],[9,3,9,5],[44,1,44,6],[57,1,57,2],[45,2,45,4],[46,2,46,4],[58,3,58,4],[58,5,58,6],[56,1,56,2],[56,3,56,4],[56,5,56,7]]}
[]
[null,"Owner Certification"]
[]
[null,"Project Name:",null,{"$f":"IF(Costs!B6=\"\",\"\",Costs!B6)","v":""},null,null,null,"(\"Project\")",null,"Project #:",{"$f":"IF(Costs!F6=\"\",\"\",Costs!F6)","v":""}]
[]
[null,"Name of Ownership Entity:",null,null,null,null,null,null,null,"(\"Owner\")"]
[]
[null,"Tax ID Number:"]
[]
[null,"The undersigned ",null,null,null,null,"of the Owner, in connection with the award and allocation by the North Carolina",null,null,null,null,null,null,null,null,"general partner"]
[null,"Federal Tax Reform Allocation Committee (“NCTRAC”) of low-income housing credits (“Allocation”) hereby certifies ",null,null,null,null,null,null,null,null,null,null,null,null,null,"managing member"]
[null,"on behalf of the Owner as follows:"]
[]
[null,"(a) The Owner (i) is validly existing and qualified to transact business under the laws of North Carolina, (ii) has the full "]
[null,"power and authority to own its properties and assets and to carry on its business as now being conducted, and (iii) has",null,null,null,null,null,null,null,null,null,null,null,null,null,"partnership"]
[null,"the full legal right, power and authority to execute and deliver this document.",null,null,null,null,null,null,null,null,null,null,null,null,null,"liability company"]
[]
[null,"(b) There is no action, suit or proceeding at law or in equity or by or before any governmental instrumentality or other"]
[null,"agency now pending, or, to the knowledge of the Owner, threatened against or affecting it or any of its properties or"]
[null,"rights, which, if adversely determined, would materially impair its right to carry on business substantially as now conducted"]
[null,"or would materially adversely affect its financial condition or which would impair the use of the Project as contemplated"]
[null,"by this document."]
[]
[null,"(c) the information contained herein is accurate."]
[]
[null,"The Owner authorizes the NCTRAC to utilize this information to calculate the amount of federal low-income housing tax"]
[null,"credits and acknowledges that the following constitute conditions to the Allocation:"]
[]
[null,"(1) accuracy of the facts and compliance with representations contained in the Allocation documentation and the "]
[null,"Project's application for low-income housing tax credits (\"Application\"),"]
[]
[null,"(2) completion of construction as depicted on the site layout, floor plan and elevations submitted with the Application,"]
[]
[null,"(3) adherence to the Qualified Allocation Plan for the year in which the credits were awarded, and"]
[]
[null,"(4) provision and maintenance of those certain unit and project amenities for the benefit of the tenants described in"]
[null,"the Application."]
[]
[null,"The Owner's or Project's failure to comply with all such conditions without prior written authorization from the NCTRAC"]
[null,"will entitle the NCTRAC, in its discretion, to deem the Allocation to be cancelled by mutual consent.  After any such"]
[null,"cancellation, Owner acknowledges that neither it nor the Project will have any right to claim Credits pursuant to the"]
[null,"Allocation.  The NCTRAC reserves the right, in its discretion, to modify and/or waive any such failed condition."]
[]
[]
[null,{"$f":"IF(F6=\"\",\"\",F6)","v":""}]
[null,"a",null,null,null,"limited"]
[null,null,"(state)"]
[]
[null,"By:"]
[null,null,null,null,"its",{"$f":"IF(D10=\"\",\"\",D10)","v":""}]
[]
[]
[null,null,null,"By:",null,null,null,null,"ATTEST:  (if applicable)"]
[null,null,null,null,null,"(signature)"]
[null,null,null,"Name:"]
[]
[null,"[Corporate Seal]",null,"Title:",null,null,null,null,null,null,"Secretary"]
[null,"(if applicable)"]
[null,null,null,"Date:"]

{"sheet":"Auditor Cert","index":9,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":false,"merged":[[3,9,3,10],[50,1,50,3],[1,1,1,12],[3,3,3,6],[5,4,5,8],[8,1,8,3],[39,7,39,10]]}
[]
[null,"Independent Auditors' Report"]
[]
[null,"Project Name:",null,{"$f":"IF(Costs!B6=\"\",\"\",Costs!B6)","v":""},null,null,null,"(\"Project\")",null,"Project #:",null,{"$f":"IF(Costs!F6=\"\",\"\",Costs!F6)","v":""}]
[]
[null,"Name of Ownership Entity:",null,null,{"$f":"IF('Owner Cert'!F6=\"\",\"\",'Owner Cert'!F6)","v":""},null,null,null,null,"(\"Owner\")"]
[]
[null,"We have audited the costs included in the accompanying Final Cost Certification of the Owner for the Project as of"]
[null,null,null,null,"(date).  Our responsibility is to express an opinion on the following pages"]
[null,"contained in the Final Cost Certification based on our audit: Costs, Sources and Credit Info (\"financial statements\").  "]
[null,"The remaining information, statements and representations contained in this report are the responsibility of the Owner"]
[null,"and the Owner's management which has not been subjected to the auditing procedures applied in the audit of the "]
[null,"financial statements and we make no claim to its authenticity nor do we express an opinion on its accuracy."]
[]
[null,"Auditor's Responsibility"]
[null,"We conducted our audit in accordance with auditing standards generally accepted in the United States of America.  "]
[null,"Those standards require we plan and perform the audit to obtain reasonable assurance about whether the financial "]
[null,"statements are free of material misstatement."]
[]
[null,"An audit involves performing procedures to obtain audit evidence about the amounts and disclosures in the financial"]
[null,"statements.  The procedures selected depend on the auditor's judgment, including the assessment of the risks of"]
[null,"material misstatement of the financial statements, whether due to fraud or error.  In making those risk assessments,"]
[null,"the auditor considers internal control relevant to the entity's preparation and fair presentation of the financial"]
[null,"statements in order to design audit procedures that are appropriate in the circumstances, but not for the purpose of"]
[null,"expressing an opinion on the effectiveness of the entity's internal control.  Accordningly, we express no such"]
[null,"opinion.  An audit also includes evaluating the appropriateness of accounting policies used and the reasonableness"]
[null,"of significant accounting estimates made by management, as well as evaluating the overall presentation of the"]
[null,"financial statements."]
[]
[null,"Basis of Accounting"]
[null,"The accompanying financial statements were prepared in conformity with the accounting practices prescribed by"]
[null,"the Internal Revenue Service, under the accrual method of accounting, and in conformity with the format and"]
[null,"Qualified Allocation Plan rules set by the North Carolina Federal Tax Federal Reform Allocation Committee (\"NCTRAC\"),"]
[null,"which is a comprehensive basis of accounting other than generally accepted accounting principles in the United States"]
[null,"of America, to comply with the requirements of the Internal Revenue Service.  Our opinion is not modified with"]
[null,"respect to that matter."]
[]
[null,"Opinion"]
[null,"In our opinion the financial statements present fairly, in all material respects, the actual costs to the Owner of"]
[null,{"$f":"IF(Costs!C82=0,\"\",Costs!C82)","v":""}," and qualified basis of ",null,{"$f":"IF(Costs!C76=0,\"\",Costs!C76)","v":""}," for the Project as of",null,null,null,null,null," (date) on"]
[null,"the basis of accounting described above and in accordance with the financial reporting provisions of the Internal"]
[null,"Revenue Service."]
[]
[null,"Restricion on Use"]
[null,"This report is intended solely for the information and use of the Owner and the Owner's management and for filing"]
[null,"with NCTRAC and should not be used by anyone other than these specified parties."]
[]
[null,"We have no financial interest in the Project other than in the practice of our profession."]
[]
[]
[]
[null,"Date"]