{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["TS Certification & Project Desc","General Summary","Project Narrative","Project Contacts","Closing Checklist","Funding Sources","Development Budget","Operating Budget","Revenue-Cash Flow non FMTW,MHP","Revenue-CF Sp Rent Inc,FMTW,MHP","Proforma - non FMTW, MHP","Proforma - Sp Rent Inc,FMTW,MHP","Remaining Useful Life","Reserves","Dropdown Lists","Developer Fee","PTR Liens-HCD Use Only","Special Conditions-HCD Use Only"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":8,"defined_names":258,"comments":8,"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":"TS Certification & Project Desc","index":0,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":true,"merged":[[0,0,0,3],[1,1,1,3],[2,1,2,3],[3,1,3,3],[3,5,3,7],[0,4,0,9],[51,1,51,5],[51,7,51,9],[43,1,43,9],[8,0,8,9],[9,8,9,9],[10,1,10,6],[10,8,10,9],[11,1,11,9],[13,1,13,5],[13,7,13,9],[14,1,14,5],[14,7,14,9],[15,1,15,5],[15,7,15,9],[16,1,16,9],[18,1,18,5],[4,1,4,3],[4,5,4,7],[5,1,5,3],[5,5,5,7],[6,1,6,3],[6,5,6,7],[18,7,18,9],[19,1,19,5],[19,7,19,9],[20,1,20,5],[20,7,20,9],[21,1,21,9],[23,1,23,5],[23,7,23,9],[24,1,24,5],[24,7,24,9],[25,1,25,5],[25,7,25,9],[26,1,26,9],[28,1,28,5],[28,7,28,9],[29,1,29,5],[29,7,29,9],[30,1,30,5],[30,7,30,9],[31,1,31,9],[33,1,33,5],[33,7,33,9],[34,1,34,5],[34,7,34,9],[35,1,35,5],[35,7,35,9],[36,1,36,9],[38,1,38,5],[38,7,38,9],[39,1,39,5],[39,7,39,9],[49,1,49,5],[49,7,49,9],[50,1,50,5],[50,7,50,9],[40,1,40,5],[40,7,40,9],[41,1,41,9],[44,1,44,5],[44,7,44,9],[56,1,56,5],[56,7,56,9],[1,5,1,7],[2,5,2,7],[9,1,9,6],[53,1,53,5],[53,7,53,9],[54,1,54,5],[55,1,55,5],[45,1,45,5],[45,7,45,9],[54,7,54,9],[55,7,55,9],[46,1,46,9],[48,1,48,5],[48,7,48,9]]}
["Draft Transaction Summary",null,null,null,"(Rev. 10/24/12)"]
["HCD Loan Rep:"]
[null,"(enter Rep's name above)",null,null,null,"Signature",null,null,null,"Date Signed"]
["HCD Manager:"]
[null,"(enter Manager's name above)",null,null,null,"Signature",null,null,null,"Date Signed"]
["Borrower: "]
[null,"(enter Borrower's name and title above)",null,null,null,"Signature",null,null,null,"Date Signed"]
[]
["I.  PROJECT AND CONTACT INFORMATION"]
["Project Name:",null,null,null,null,null,null,"Contract #:"]
["Street Address:",null,null,null,null,null,null,"County:"]
["City/State/Zip Code:"]
[]
["Sponsor Name:",null,null,null,null,null,"Contact:"]
["Type of Entity:",null,null,null,null,null,"Phone:"]
["Mailing Address:",null,null,null,null,null,"Email:"]
["City/State/Zip Code:"]
[]
["Co-Sponsor Name:",null,null,null,null,null,"Contact:"]
["Type of Entity:",null,null,null,null,null,"Phone:"]
["Mailing Address:",null,null,null,null,null,"Email:"]
["City/State/Zip Code:"]
[]
["Ultimate Borrower:",null,null,null,null,null,"Contact:"]
["Type of Entity:",null,null,null,null,null,"Phone:"]
["Mailing Address:",null,null,null,null,null,"Email:"]
["City/State/Zip Code:"]
[]
["General Partner:",null,null,null,null,null,"Contact:"]
["Type of Entity:",null,null,null,null,null,"Phone:"]
["Mailing Address:",null,null,null,null,null,"Email:"]
["City/State/Zip Code:"]
[]
["Co-General Partner:",null,null,null,null,null,"Contact:"]
["Type of Entity:",null,null,null,null,null,"Phone:"]
["Mailing Address:",null,null,null,null,null,"Email:"]
["City/State/Zip Code:"]
[]
["Equity Investor:",null,null,null,null,null,"Contact:"]
["Type of Entity:",null,null,null,null,null,"Phone:"]
["Mailing Address:",null,null,null,null,null,"Email:"]
["City/State/Zip Code:"]
[]
["Property Mgmt. Co.:"]
["Contact:",null,null,null,null,null,"Phone:"]
["Mailing Address:",null,null,null,null,null,"Email:"]
["City/State/Zip Code:"]
[]
["Title Company:",null,null,null,null,null,"Contact:"]
["Mailing Address:",null,null,null,null,null,"Phone:"]
["City/State/Zip Code:",null,null,null,null,null,"Email:"]
["PTR date (wi 30 days):",null,null,null,null,null,"Order #:"]
[]
["Escrow Company:",null,null,null,null,null,"Contact:"]
["Type of Entity:",null,null,null,null,null,"Phone:"]
["Mailing Address:",null,null,null,null,null,"Email:"]
["City/State/Zip Code:",null,null,null,null,null,"Escrow #:"]

{"sheet":"General Summary","index":1,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,0,2,7],[2,8,2,10],[3,0,3,10],[4,0,4,7],[4,8,4,10],[5,9,5,10],[5,0,5,1],[11,5,11,8],[6,2,6,10],[10,0,10,3],[10,5,10,9],[11,0,11,1],[6,0,6,1],[9,7,9,9],[9,4,9,5],[7,0,7,1],[7,2,7,6],[7,8,7,10],[8,3,8,5],[9,0,9,1],[8,7,8,8],[8,9,8,10],[13,0,13,1],[13,2,13,4],[12,2,12,4],[13,5,13,8],[25,1,25,5],[15,5,15,8],[16,2,16,4],[25,6,25,8],[25,9,25,10],[15,0,15,1],[23,1,23,5],[23,6,23,8],[15,2,15,4],[24,9,24,10],[17,0,17,10],[24,0,24,5],[24,6,24,8],[16,5,16,8],[26,9,26,10],[27,9,27,10],[29,8,29,10],[29,0,29,7],[27,1,27,5],[27,6,27,8],[26,1,26,5],[26,6,26,8],[28,1,28,5],[28,6,28,8],[28,9,28,10],[38,0,38,10],[35,0,35,7],[35,8,35,10],[37,0,37,10],[30,7,30,10],[36,8,36,10],[33,0,33,10],[30,3,30,6],[36,0,36,7],[32,0,32,7],[32,8,32,10],[34,0,34,7],[34,8,34,10],[31,0,31,7],[31,8,31,10],[30,0,30,2],[0,0,0,6],[0,7,0,10],[22,9,22,10],[23,9,23,10],[21,0,21,2],[22,0,22,5],[22,6,22,8],[8,0,8,1],[12,5,12,8],[14,5,14,8],[11,2,11,4],[19,0,19,10],[21,3,21,4],[5,2,5,7],[18,0,18,10],[14,2,14,4]]}
["HCD Loan Portfolio Restructuring (LPR) Application"]
[]
["APPLICATION STAGE"]
[]
["PROJECT INFORMATION",null,null,null,null,null,null,null,"(Version 7/18/17)"]
["Project Name:",null,null,null,null,null,null,null,"LPR Loan #:"]
["Street Address:"]
["City/State/Zip Code:",null,null,null,null,null,null,"County:"]
["Total Number Units:",null,null,"Total Number of Assisted Units:",null,null,null,"Project Fiscal Year:"]
["Application Info:\n(Must be Included):",null,"Date:",null,"Fee Amount:",null,null,"Cashier's Check No.:"]
["Application Approval Date (HCD Use Only):",null,null,null,null,"Restructuring Approval Date (HCD Use):"]
["HCD Loan Rep:"]
[null,null,"Rep's name (enter above)"]
["HCD Manager:"]
[null,null,"Manager's name (enter above)",null,null,"Signature (represents conditional approval)",null,null,null,null,"Date Signed"]
["Borrower: "]
[null,null,"Borrower's name and title (enter above)",null,null,"Signature",null,null,null,null,"Date Signed"]
["Application must be submitted in a three ring binder with dividers with the tab/worksheet name, i.e. \"General Summary\"."]
["PROJECT ELIGIBILITY  (contact your HCD Rep if the selections in A or B below do not apply to you)"]
["A.  Select the applicable Restructuring provision(s). Section 100(b)"]
[null,null,null,null,null,null,null,null,null,null,"(AFR) "]
[]
["B.  Select applicable eligible Original HCD Loan Program",null,null,null,null,null,"HCD Principal Loan Balance",null,null,"HCD Contract #"]
["1."]
["C.  Enter all other Original HCD Program funding for this project",null,null,null,null,null,"HCD Principal Loan Balance",null,null,"HCD Contract #"]
["2."]
["3."]
["4."]
["5."]
["D.  If your transaction involves rehabilitation, did you attach a third party property condition assessment (PCA) based on the FNMA Guidelines below? If no, explain below. If N/A, please complete the self-certified Remaining Useful Life tab."]
["PNA Fannie Mae - Form 4327",null,null,"PNA Fannie Mae Guidelines - Form 4099",null,null,null,"Fannie Mae Guidance - see 4099 A-H"]
["Does the PCA report the project's useful life, upon completion of the rehab, equal or exceed the extended loan term; and does it include all building systems and cost estimates for replacing and maintaining these systems for a minimum of 20 years? If no, please explain."]
["E.  Is the Sponsor or Borrower in breach or default of the Original Program loan documents or other HCD Program loan documents (excluding a loan maturity date that has passed)? Section 102(c) of the LPR Program Guidelines."]
["If yes, contact HCD prior to completing this application (defaults or violations must be cured prior to transaction closing)."]
["F.  Will the Sponsor have full control over the Borrower, within an organizational legal structure having no more than three levels of business entities? If No or a new organizational structure has not yet been determined, please explain below. "]
["G.  Does the project profroma within the application demonstrate positive cash flow for 15 years after close of escrow including the anticipated LPR Program HCD loan monitoring fees? If no, please explain your financial mitigation plan below."]
["H.  If tenants are being relocated (temporary or permanent displacement) during rehabilitation, did you attach a relocation plan (plans must be approved by HCD prior to close of  this transaction)?  If no, please explain below."]
["I.  Use this area to explain \"No\" answers above or for further explanation."]

{"sheet":"Project Narrative","index":2,"n_rows":34,"n_cols":1,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[{"$f":"CONCATENATE(\"NARRATIVE of PROPOSED PROJECT - attach additional pages if necessary    \",'General Summary'!I5)","v":"NARRATIVE of PROPOSED PROJECT - attach additional pages if necessary    (Version 7/18/17)"}]
[{"$f":"'General Summary'!C6","v":0}]
["1)  Describe this transaction's major components: HCD loan extension, change in ownership structure, new or refinance senior debt, new construction and permanent loans, new/existing junior loans, AFR, etc."]
[]
["2)  Provide this transaction's targeted closing date and the absolute deadline closing date. What is driving the absolute deadline date (tax credit deadline, loan maturity, etc.)?"]
[]
["3)  Describe the development type (highrise, garden, fourplexes, scattered sites, mixed-use, etc.) and site conditions or difficult characteristics. If the transaction combines separate developments into one project, describe all properties including existing HCD funding and addresses. "]
[]
["4)  Describe the existing tenant population including special occupancy restrictions. Describe all proposed unit mix, population, special occupancy changes, etc."]
[]
["5) Describe on-site supportive services, costs and funding sources."]
[]
["6)  Describe specific Issues (relocation, environmental, historical, zoning limitations, etc.)"]
[]
["7)  If not requesting a Special Rent Increase enter \"No Special Rent Increase Requested\". If requesting a Special Rent Increase, include the date and why it is needed. If requesting an Early Special Rent Increase, indicate when it will end and why it is needed?"]
[]
["8)  Describe the scope and provide an overview of proposed rehabilitation work including demolition."]
[]
["9)  Describe all ground leases in place, being assigned, or being terminated, etc., and the parties involved. State whether security for the HCD loan will be the fee estate, leasehold estate or both."]
[]
["10)  Describe rent subsidies including funding, project-based/tenant-based, length of contract, number of units, etc."]
[]
[" 11)  Describe any \"excess payments\" to either buyer, seller or affiliates.  Cash out financing is prohibited under LPR Guidelines."]
[]
["12)  Describe developer fee calculations, and whether seller or affiliate carryback loans are contemplated."]
[]
["13)  Describe any past changes or replacements in borrower's organizational structure including General Partner, Sponsor/Lessor/Lessee, property transfers and other financing  not already documented in HCD's original or amended loan documents currently in your possession (this excludes any Limited Partner changes)."]
[]
["14)  Describe any other issues that require explanation or appear to be in conflict with LPR Program Guidelines."]
[]
["15)  If you are requesting waiver or deferral of HCD Monitoring Fees, describe justification per LPR Guidelines Section 113."]
[]
["16)  List all other HCD Funded properties that you or an affiliate are the Sponsor, Borrower/G.P or Lender."]
["Include:  Project Name - HCD Contract/Loan Number - Sponsor's Relationship to Project (add additional pages if needed)"]

{"sheet":"Project Contacts","index":3,"n_rows":125,"n_cols":7,"rows_kept":125,"cut":false,"hidden":false,"merged":[[0,0,0,2],[0,3,0,9],[48,1,48,9],[47,3,47,9],[73,7,73,9],[45,1,45,5],[66,1,66,5],[66,7,66,9],[70,1,70,5],[70,7,70,9],[64,1,64,5],[69,1,69,5],[69,7,69,9],[72,7,72,9],[53,1,53,9],[55,1,55,5],[55,7,55,9],[56,1,56,5],[68,7,68,9],[62,7,62,9],[56,7,56,9],[57,1,57,5],[57,7,57,9],[63,0,63,9],[58,1,58,9],[67,1,67,4],[65,7,65,9],[67,7,67,9],[39,1,39,5],[39,7,39,9],[40,1,40,5],[40,7,40,9],[41,1,41,9],[43,1,43,5],[43,7,43,9],[44,1,44,5],[44,7,44,9],[36,1,36,9],[38,1,38,5],[38,7,38,9],[23,1,23,5],[23,7,23,9],[24,1,24,5],[62,1,62,5],[24,7,24,9],[61,7,61,9],[33,7,33,9],[34,1,34,5],[34,7,34,9],[31,0,31,9],[35,7,35,9],[35,1,35,5],[33,1,33,5],[27,1,27,5],[25,1,25,9],[45,7,45,9],[46,1,46,9],[50,1,50,5],[50,7,50,9],[61,1,61,5],[27,7,27,9],[83,7,83,9],[100,1,100,5],[100,7,100,9],[95,7,95,9],[93,1,93,5],[92,7,92,9],[97,7,97,9],[99,1,99,5],[99,7,99,9],[87,7,87,9],[85,1,85,5],[85,7,85,9],[88,1,88,5],[84,7,84,9],[106,7,106,9],[4,1,4,5],[4,7,4,9],[9,1,9,5],[9,7,9,9],[10,1,10,9],[12,1,12,5],[12,7,12,9],[5,1,5,9],[7,1,7,5],[7,7,7,9],[8,1,8,5],[8,7,8,9],[14,7,14,9],[15,1,15,9],[17,1,17,5],[17,7,17,9],[18,1,18,5],[18,7,18,9],[19,1,19,5],[19,7,19,9],[75,1,75,5],[74,1,74,5],[83,1,83,5],[2,1,2,5],[2,7,2,9],[3,1,3,5],[3,7,3,9],[1,0,1,9],[94,7,94,9],[95,1,95,5],[103,1,103,5],[103,7,103,9],[28,1,28,5],[28,7,28,9],[29,1,29,5],[29,7,29,9],[6,0,6,9],[11,0,11,9],[16,0,16,9],[21,0,21,9],[26,0,26,9],[20,1,20,9],[22,1,22,5],[22,7,22,9],[13,1,13,5],[13,7,13,9],[14,1,14,5],[113,0,113,9],[68,1,68,5],[118,1,118,5],[118,7,118,9],[114,1,114,5],[114,7,114,9],[115,1,115,5],[117,0,117,9],[116,1,116,5],[116,7,116,9],[76,0,76,9],[81,0,81,9],[86,0,86,9],[79,7,79,9],[77,7,77,9],[101,0,101,9],[108,1,108,5],[108,7,108,9],[104,7,104,9],[102,1,102,5],[102,7,102,9],[91,0,91,9],[96,0,96,9],[106,1,106,5],[112,1,112,5],[112,7,112,9],[105,0,105,9],[115,7,115,9],[75,7,75,9],[88,7,88,9],[89,1,89,5],[89,7,89,9],[90,1,90,5],[90,7,90,9],[82,7,82,9],[79,1,79,5],[107,1,107,5],[107,7,107,9],[78,1,78,5],[78,7,78,9],[80,1,80,5],[80,7,80,9],[104,1,104,5],[98,1,98,5],[98,7,98,9],[93,7,93,9],[94,1,94,5],[84,1,84,5],[124,1,124,5],[124,7,124,9],[119,1,119,5],[119,7,119,9],[120,1,120,5],[120,7,120,9],[122,1,122,5],[122,7,122,9],[121,0,121,9],[123,1,123,5],[123,7,123,9],[110,1,110,5],[110,7,110,9],[111,1,111,5],[30,0,30,9],[37,0,37,9],[32,0,32,9],[42,0,42,9],[49,0,49,9],[54,0,54,9],[51,1,51,5],[51,7,51,9],[52,1,52,5],[52,7,52,9],[60,1,60,5],[60,7,60,9],[73,1,73,5],[67,5,67,6],[74,7,74,9],[71,0,71,9],[64,7,64,9],[65,1,65,5],[59,0,59,9],[111,7,111,9],[109,0,109,9]]}
[{"$f":"CONCATENATE(\"Project Contacts   \",'General Summary'!I5)","v":"Project Contacts   (Version 7/18/17)"},null,null,{"$f":"'General Summary'!C6","v":0}]
["EXISTING PROJECT CONTACTS - if combining multiple projects, attach separate contact pages for each project"]
["Sponsor Name",null,null,null,null,null,"Contact"]
["Type of Entity",null,null,null,null,null,"Phone"]
["Mailing Address",null,null,null,null,null,"Email"]
["City/State/Zip Code"]
[]
["Co-Sponsor Name",null,null,null,null,null,"Contact"]
["Type of Entity",null,null,null,null,null,"Phone"]
["Mailing Address",null,null,null,null,null,"Email"]
["City/State/Zip Code"]
[]
["Current Borrower",null,null,null,null,null,"Contact"]
["Type of Entity",null,null,null,null,null,"Phone"]
["Mailing Address",null,null,null,null,null,"Email"]
["City/State/Zip Code"]
[]
["Gen Partner/Member",null,null,null,null,null,"Contact"]
["Type of Entity",null,null,null,null,null,"Phone"]
["Mailing Address",null,null,null,null,null,"Email"]
["City/State/Zip Code"]
[]
["Co-GP/Member",null,null,null,null,null,"Contact"]
["Type of Entity",null,null,null,null,null,"Phone"]
["Mailing Address",null,null,null,null,null,"Email"]
["City/State/Zip Code"]
[]
["Current Prop Mgr",null,null,null,null,null,"Contact"]
["Mailing Address",null,null,null,null,null,"Phone"]
["City/State/Zip Code",null,null,null,null,null,"Email"]
[]
["NEW (PROPOSED) PROJECT CONTACTS"]
[]
["Sponsor Name",null,null,null,null,null,"Contact"]
["Type of Entity",null,null,null,null,null,"Phone"]
["Mailing Address",null,null,null,null,null,"Email"]
["City/State/Zip Code"]
[]
["Co-Sponsor Name",null,null,null,null,null,"Contact"]
["Type of Entity",null,null,null,null,null,"Phone"]
["Mailing Address",null,null,null,null,null,"Email"]
["City/State/Zip Code"]
[]
["New Borrower",null,null,null,null,null,"Contact"]
["Type of Entity",null,null,null,null,null,"Phone"]
["Mailing Address",null,null,null,null,null,"Email"]
["City/State/Zip Code"]
["Physical Address/place of business-if different"]
["City/State/Zip Code"]
[]
["Gen Partner/Member",null,null,null,null,null,"Contact"]
["Type of Entity",null,null,null,null,null,"Phone"]
["Mailing Address",null,null,null,null,null,"Email"]
["City/State/Zip Code"]
[]
["Co-GP/Member",null,null,null,null,null,"Contact"]
["Type of Entity",null,null,null,null,null,"Phone"]
["Mailing Address",null,null,null,null,null,"Email"]
["City/State/Zip Code"]
[]
["Property Mangmt Co",null,null,null,null,null,"Contact"]
["Mailing Address",null,null,null,null,null,"Phone"]
["City/State/Zip Code",null,null,null,null,null,"Email"]
[]
["Title Company",null,null,null,null,null,"Contact"]
["Mailing Address",null,null,null,null,null,"Phone"]
["City/State/Zip Code",null,null,null,null,null,"Email"]
["Title Order Number",null,null,null,null,"Escrow Number"]
["Escrow Company",null,null,null,null,null,"Contact"]
["Mailing Address",null,null,null,null,null,"Phone"]
["City/State/Zip Code",null,null,null,null,null,"Email"]
[]
["Development Funding Source",null,null,null,null,null,"Contact"]
["Legal Name",null,null,null,null,null,"Phone"]
["Mailing Address",null,null,null,null,null,"Fax No."]
["City/State/Zip Code",null,null,null,null,null,"Email"]
[]
["Development Funding Source",null,null,null,null,null,"Contact"]
["Legal Name",null,null,null,null,null,"Phone"]
["Mailing Address",null,null,null,null,null,"Fax No."]
["City/State/Zip Code",null,null,null,null,null,"Email"]
[]
["Development Funding Source",null,null,null,null,null,"Contact"]
["Legal Name",null,null,null,null,null,"Phone"]
["Mailing Address",null,null,null,null,null,"Fax No."]
["City/State/Zip Code",null,null,null,null,null,"Email"]
[]
["Development Funding Source",null,null,null,null,null,"Contact"]
["Legal Name",null,null,null,null,null,"Phone"]
["Mailing Address",null,null,null,null,null,"Fax No."]
["City/State/Zip Code",null,null,null,null,null,"Email"]
[]
["Development Funding Source",null,null,null,null,null,"Contact"]
["Legal Name",null,null,null,null,null,"Phone"]
["Mailing Address",null,null,null,null,null,"Fax No."]
["City/State/Zip Code",null,null,null,null,null,"Email"]
[]
["Development Funding Source",null,null,null,null,null,"Contact"]
["Legal Name",null,null,null,null,null,"Phone"]
["Mailing Address",null,null,null,null,null,"Fax No."]
["City/State/Zip Code",null,null,null,null,null,"Email"]
[]
["Tax Credit Investor",null,null,null,null,null,"Contact"]
["Mailing Address",null,null,null,null,null,"Phone"]
["City/State/Zip Code",null,null,null,null,null,"Email"]
[]
["Borrower Counsel",null,null,null,null,null,"Contact"]
["Mailing Address",null,null,null,null,null,"Phone"]
["City/State/Zip Code",null,null,null,null,null,"Email"]
[]
["Transaction Consult.",null,null,null,null,null,"Contact"]
["Mailing Address",null,null,null,null,null,"Phone"]
["City/State/Zip Code",null,null,null,null,null,"Email"]
[]
["Financial Consult.",null,null,null,null,null,"Contact"]
["Mailing Address",null,null,null,null,null,"Phone"]
["City/State/Zip Code",null,null,null,null,null,"Email"]
[]
["Bond Counsel",null,null,null,null,null,"Contact"]
["Mailing Address",null,null,null,null,null,"Phone"]
["City/State/Zip Code",null,null,null,null,null,"Email"]
[]
["Bond Underwriter",null,null,null,null,null,"Contact"]
["Mailing Address",null,null,null,null,null,"Phone"]
["City/State/Zip Code",null,null,null,null,null,"Email"]

{"sheet":"Closing Checklist","index":4,"n_rows":94,"n_cols":8,"rows_kept":94,"cut":false,"hidden":false,"merged":[[87,7,87,8],[88,7,88,8],[89,7,89,8],[90,7,90,8],[91,7,91,8],[82,7,82,8],[83,7,83,8],[84,7,84,8],[85,7,85,8],[34,7,34,8],[27,7,27,8],[26,7,26,8],[25,7,25,8],[51,7,51,8],[48,7,48,8],[69,7,69,8],[80,7,80,8],[79,7,79,8],[78,7,78,8],[77,7,77,8],[76,7,76,8],[73,7,73,8],[70,7,70,8],[28,0,28,8],[29,0,31,0],[32,0,36,0],[39,0,41,0],[30,7,30,8],[29,7,29,8],[45,7,45,8],[46,7,46,8],[47,7,47,8],[44,7,44,8],[37,0,38,0],[42,7,42,8],[41,7,41,8],[40,7,40,8],[39,7,39,8],[38,7,38,8],[37,7,37,8],[36,7,36,8],[35,7,35,8],[42,0,47,0],[43,7,43,8],[56,0,57,0],[58,0,59,0],[65,0,74,0],[50,7,50,8],[49,7,49,8],[55,7,55,8],[54,7,54,8],[53,7,53,8],[52,7,52,8],[61,7,61,8],[60,7,60,8],[59,7,59,8],[58,7,58,8],[68,7,68,8],[12,7,12,8],[13,7,13,8],[93,0,93,8],[76,0,80,0],[53,0,55,0],[60,0,63,0],[64,0,64,8],[92,0,92,8],[57,7,57,8],[56,7,56,8],[63,7,63,8],[62,7,62,8],[67,7,67,8],[66,7,66,8],[65,7,65,8],[74,7,74,8],[72,7,72,8],[71,7,71,8],[81,0,81,8],[33,7,33,8],[32,7,32,8],[31,7,31,8],[48,0,52,0],[75,0,75,8],[0,0,0,4],[0,5,0,7],[1,0,1,2],[3,0,3,2],[3,5,3,6],[1,5,1,8],[2,5,2,8],[2,0,2,2],[4,0,4,2],[4,5,4,8],[5,0,5,8],[23,3,25,3],[6,0,6,8],[23,1,25,1],[7,7,7,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[17,7,17,8],[20,7,20,8],[19,7,19,8],[18,7,18,8],[8,0,11,0],[12,0,19,0],[23,2,25,2],[24,7,24,8],[23,7,23,8],[22,7,22,8],[21,7,21,8],[23,0,25,0],[8,7,8,8],[9,7,9,8],[10,7,10,8],[11,7,11,8]]}
[{"$f":"CONCATENATE(\"Closing Checklist of Required Documents  \",'General Summary'!I5)","v":"Closing Checklist of Required Documents  (Version 7/18/17)"},null,null,null,null,"Date of this Closing Checklist"]
["Project Name",null,null,{"$f":"'General Summary'!C6","v":0},"New Sponsor"]
["LPR Loan #",null,null,{"$f":"'General Summary'!J6","v":0},"Sponsor Contact"]
["Trans Unit Loan Officer ",null,null,null,"Sponsor Phone",null,null,"Email"]
["Existing Borrower",null,null,null,"Proposed (New) Borrower"]
["Instructions: Your Application and proposal must include the documents marked “Yes” in the “Required” column below. Items marked \"Yes\" in Section A must be submitted with the Application. Those in Section B are required to close the transaction and must be submitted within 21 days of Application Acceptance. To submit required documentation: scan the document, attach it to an email, and send the email to the Closings Section Transactions Unit Loan Officer. \nNOTE: If a document is not yet ready (such as draft loan documents for new loans being made in this transaction), please describe the reason and the anticipated date of completion of that document  in the “Deficiency/Comments” column. Sponsor must submit all required checklist items, within 21 days of receiving Application approval. HCD requires notification when any of the required submittals are amended, rescinded or altered in any way."]
[" A.   Items Due At Time of Application Submittal"]
["Topic","Item\nNo.","Required","Item Description","Reference/Guidelines","Date Received","Date\nHCD Approved","Deficiency/Comment"]
["Sponsor\nInformation",1,null,"Initial application fee of $1,000 made payable to \"HCD\""]
[null,2,null,"Completed application, with required attachments"]
[null,3,null,"Diagram of current Borrower organizational structure"]
[null,4,null,"Sponsor / Owner / Borrower signature blocks for the existing Borrower (in MS Word format)","Needed even if current Borrower is transferring property to another entity"]
["Organizational\nDocuments",5,null,"Diagram of proposed new Borrower organizational structure"]
[null,6,null,"Sponsor / Owner / Borrower signature blocks for proposed new Borrower (in MS Word format)"]
[null,7,null,"Proposed new Partnership Borrower: all partnership agreement documents including amendments, LP-1, LP-2, loan authorization and certificate of status from Secretary of State","Final LPA required prior to transaction closing and must be approved by HCD prior to closing.",null,null,"Negotiated LPA must be submitted for HCD approval no less than 60 days prior to anticipated closing date"]
[null,8,null,"Proposed new Corporate Managing/Administrative G.P. or Borrower or Sole-Member/Manager: articles of incorporation, by-laws, resolution, certificate of status from the Secretary of State",null,null,null,"NOTE: organizational documents required for every entity in the ownership chain."]
[null,9,null,"Proposed new LLC Managing/Adminstrative G.P. or Borrower:\narticles of organization, operating agreement, resolution, certificate of status from the Secretary of State",null,null,null,"NOTE: organizational documents required for every entity in the ownership chain."]
[null,10,null,"Resolution/Authorization from every level of the Borrower organizational structure authorizing the transaction.  NOTE: If there is a transfer of the property, Selling organization Resolution/Authorization submittal will also be required",null,null,null,"Consult with your Transactions Unit Loan Officer to ensure you submit the correct documentation."]
[null,11,null,"Evidence of Welfare Property Tax Exemption ","Alternatively: IRS and Franchise Tax Board letters confirming nonprofit status."]
[null,12,null,"Proof of 501(c)(3) eligible status"]
["Title",13,null,"Current/Updated Preliminary Title Report (PTR) with hyperlinks. If there is a ground lease, two hyperlinked PTRs are required: one for fee estate and one for leasehold estate. If combining multiple properties into one development submit: PTR with all properties identified, copies of all leases on all properties and copies of any unrecorded financing/loan documents.","Less than 30 days old.                         NOTE: An updated PTR will be required prior to closing the transaction."]
["Appraisal",14,null,"Appraisal showing \"As-is\" value and \"As-Restricted\" value of property being purchased.  If a rehab project is proposed, also provide \"After Rehab\" Value","Other lender appraisals are acceptable.  NOTE: Appraisal must be current within 180 days of date of Application"]
["Relocatn",15,null,"Relocation Plan - with current rent roll"]
["PNA",16,null,"Physical Needs Assessment (PNA) which includes a Replacement Reserve Study (RRS).  If no rehabilitation is planned, complete the Remaining Useful Life (RUL) Evaluation form in the Application","Fannie Mae Guidance - Forms 4099 A-H  ",null,null,"Guidelines with Model Contract Addendum."]
[null,null,null,null,"Fannie Mae PNA Guidelines - Form 4099"]
[null,null,null,null,"Fannie Mae PNA Form 4327.",null,null,"NOTE: 20-year forecast is required."]
["Rent",17,null,"Rent Roll information, needed to verify data - including household income, move-in date,utility allowances, subsidies, etc.","Sponsor must submit the stand-alone Schedule of Rental Income (Excel workbook) based on original loan program",null,null,"Consult with your Transactions Unit Loan Officer to ensure you submit the correct documentation."]
["Operating Expenses",18,null,"Verifications for Proposed Operating Budget if different from most recent approved Operating Expenses","Verification/explanation of differences between most recent AMC approved Operating Expenses compared to Expenses included in Application",null,null,"HCD will require most recent Audited Financial Statements/Annual Report"]
["B.   Items Due Within 21 Days of Application Acceptance - required items must be approved by HCD prior to closing"]
["Property Transfer Documents",19,null,"Ground Lease and any amendments"]
[null,20,null,"Purchase and Sale Agreement and any amendments, and any supporting or other documents to a sale or transfer of the real property","If Option to Purchase is included in LPA then note here and in Transaction Summary"]
[null,21,null,"Notice of Exercise of Option"]
["Reserves",22,null,"Replacement Reserve - approved annual deposit","Verify timing of capitalization of reserve account if required",null,null,"Verify according to original Regulatory Agreement, PNA and Replacement Reserve Study (RRS)"]
[null,23,null,"Operating Reserve - Proper calculation and approve annual deposit",null,null,null,"Verify according to PNA/RRS and conforms to UMRs"]
[null,24,null,"Additional Reserve Accounts Required - Specify","If required by HCD or other lender"]
[null,25,null,"Additional Reserve Accounts Required - Specify","If required by HCD or other lender"]
[null,26,null,"Bank statements of balances for all Reserve Accounts"]
["TCAC & CDLAC",27,null,"Application to CDLAC and/or TCAC"]
[null,28,null,"TCAC and/or CDLAC Award Letter","Include time extension letters, if applicable"]
["Leases",29,null,"Commercial Lease(s), plus contact info for all parties to all commercial leases, laundry leases, cell tower leases, if applicable","Master Lease must include all of commercial square footage identified in the application."]
[null,30,null,"Unrecorded Leases, if any, such as solar equipment leases,  etc."]
[null,31,null,"All Joint Use and Maintenance Agreements"]
["Financial Sources and Loan Documents",32,null,"Letter of Intent from equity investor."]
[null,33,null,"Letter of Commitment from new senior lender"]
[null,34,null,"New Construction loan (provide information regarding whether it is construction funding only or if it will convert to a permanent senior loan) - Senior Permanent Lender Loan/Bond Financing Term Sheet and all draft documents. Final documents, exhibits and attachments due prior to closing.","If applicable, enter name of 1st Senior Construction lender, loan amount, & lien position in comments field. ",null,null,"Draft loan documents must be submitted for HCD approval no less than 30 days prior to anticipated closing date"]
[null,35,null,"New permanent loan that will be on title at the time of HCD loan recordation - Senior Permanent Lender Loan/Bond Financing Term Sheet and all draft documents.  Executed documents, exhibits and attachments due prior to closing. Final documents, exhibits and attachments due prior to closing.","If applicable, enter name of 1st Senior Permanent lender, loan amount, & lien position in comments field. ",null,null,"Draft loan documents must be submitted for HCD approval no less than 30 days prior to anticipated closing date"]
[null,36,null,"Permanent junior lender  (provide information regarding whether it will be used for construction funding or only permanent funding) - provide draft documents with all exhibits and attachments.  If already funded, provide all fully executed loan documents, with all exhibits and attachments","If applicable, enter name of 1st junior lender, loan amount and lien position in comments field.",null,null,"Draft loan documents must be submitted for HCD approval no less than 30 days prior to anticipated closing date"]
[null,37,null,"Permanent junior lender  (provide information regarding whether it will be used for construction funding or only permanent funding) - provide draft documents with all exhibits and attachments.  If already funded, provide all fully executed loan documents, with all exhibits and attachments","If applicable, enter name of 2nd junior lender, loan amount and lien position in comments field.",null,null,"Draft loan documents must be submitted for HCD approval no less than 30 days prior to anticipated closing date"]
["Financial Sources and Loan Documents (continued)",38,null,"Permanent junior lender  (provide information regarding whether it will be used for construction funding or only permanent funding) - provide draft documents with all exhibits and attachments.  If already funded, provide all fully executed loan documents, with all exhibits and attachments","If applicable, enter name of 3rd junior lender, loan amount and lien position in comments field.",null,null,"Draft loan documents must be submitted for HCD approval no less than 30 days prior to anticipated closing date"]
[null,39,null,"Permanent junior lender  (provide information regarding whether it will be used for construction funding or only permanent funding) - provide draft documents with all exhibits and attachments.  If already funded, provide all fully executed loan documents, with all exhibits and attachments. ","If applicable, enter name of 4th junior lender, loan amount and lien position in comments field.",null,null,"Draft loan documents must be submitted for HCD approval no less than 30 days prior to anticipated closing date"]
[null,40,null,"Permanent Non-Public Agency junior lender - (provide information regarding whether it will be used for construction funding or only permanent funding) - provide draft documents with all exhibits and attachments.  If already funded, provide all fully executed loan documents, with all exhibits and attachments"," If applicable, enter name of Non-Agency Lender (Sponsor, Seller, GP, etc.), terms of the loan, and loan amount in the comments field.",null,null,"Draft loan documents must be submitted for HCD approval no less than 30 days prior to anticipated closing date"]
[null,41,null,"Grants - all fully executed grant documents, exhibits and attachments.","If applicable, enter name of grantor and the amount and terms of the grant.",null,null,"Draft loan documents must be submitted for HCD approval no less than 30 days prior to anticipated closing date"]
[null,42,null,"Bridge loans - all fully executed loan documents, exhibits, and attachments, if applicable.  If loan will be executed at permanent closing, provide draft documents",null,null,null,"Draft loan documents must be submitted for HCD approval no less than 30 days prior to anticipated closing date"]
["Development Budget",43,null,"Detailed Scope - must be in sufficient detail to show compliance with PNA recommendations","Submit the Construction Lender's approved Scope of Work documentation."]
[null,44,null,"Architect's Cost Estimate for all items described in Scope of Work"]
[null,45,null,"Development Budget supporting documentation - any items that require explanation beyond what is included in the Development Budget tab of the Transaction Summary.","Development Budget must address all aspects of the Scope of Work, and must be in sufficient detail to show compliance with PNA recommendations and all rehabilitation plans, designs and cost estimates.  "]
["Rental Income",46,null,"Project Based Rental Subsidy contracts or commitments, if applicable"]
[null,47,null,"Letter from local housing authority transmitting current utility allowance chart, with relevant components circled"]
["Social Services",48,null,"If applicable to an HCD program that requires supportive services, submit plans for childcare and other supportive services not covered by the previous checklist item.  Include detailed plans for any space that will be used for supportive services.  Identify service providers and include agreements between borrower and providers.  Specify services to be delivered, services funding source and criteria for determining eligibility for services.","Submit back-up documentation for all applicable items."]
[null,49,null,"Social Services provider contracts"]
["Special Conditions",50,null,"ALTA Survey, with Certificate of Survey naming HCD as party to the Survey, to be provided for HCD approval.","Misc. Documents"]
[null,51,null,"Anything required to document the project specific requirements listed in the Special Conditions tab","Misc. Documents"]
[null,52,null,"Other","Misc. Documents"]
[null,53,null,"Other","Misc. Documents"]
["C.  Management Section - will be reviewed & approved by AMC Branch"]
["Management Documents and AMC Approvals ",54,null,"Evidence of hazard and liability insurance. Submit certificate with the liability endorsement","HCD Insurance Guidelines",null,null,"If project will have separate policies during construction and after, include both."]
[null,55,null,"Proposal for New Management Agent","Use model format; HCD requires signature.",null,null,"Proposed new Management Agent must be approved by HCD's AMC division prior to close of transaction."]
[null,56,null,"New Management Contract","Use model format.",null,null,"Proposed new Management Contract must be approved by HCD's AMC division prior to close of transaction."]
[null,57,null,"New Contract Checklist","Use model format.",null,null,"Proposed new Management Contract Checklist must be approved by HCD's AMC division prior to close of transaction."]
[null,58,null,"Management Plan Checklist","Use model format.",null,null,"Proposed new Management Plan must be approved by HCD's AMC division prior to close of transaction."]
[null,59,null,"New Management Plan",null,null,null,"Proposed new Management Plan must be approved by HCD's AMC division prior to close of transaction."]
[null,60,null,"Rental Agreement, exhibits and HCD Lease Addendum","Refer to HCD \"Tenant Lease Addendum\" ",null,null,"Proposed new rental agreements and/or leases must be approved by HCD's AMC division prior to close of transaction."]
[null,61,null,"Appeal and grievance procedure","Refer to HCD Appeal and Grievance Procedure",null,null,"Proposed new Management Plan must include HCD approved appeal and grievance procedure to be approved by HCD's AMC division prior to close of transaction."]
[null,62,null,"Lease agreements for child care and other spaces used for supportive services, if applicable"]
[null,63,null,"Resolution of non-compliance issues(s)  (e.g., back interest due; occupancy, rent deficiencies; past due reports for all projects associated with Sponsor or Borrower, etc.)","HCD Regs regarding sponsor compliance with all HCD loan programs and projects owned and/or operated",null,null,"Transactions Unit Loan Officer will consult with all HCD divisions and report results to Sponsor in order to resolve any compliance issues"]
["D.  Escrow Closing Items - needed prior to closing the transaction"]
["Escrow Closing",64,null,"Buyer's and Seller's Settlement Statements","Provided by Escrow Officer. Estimated Closing Statements are required to be delivered and approved by HCD prior to authorizing recordation."]
[null,65,null,"Proforma Title Insurance Policy","Provided by Escrow Officer. Estimated Closing Statements are required to be delivered and approved by HCD prior to authorizing recordation."]
[null,66,null,"Escrow Instructions Acknowledgement and Receipt executed"]
[null,67,null,"Anything required to satisfy Special Escrow Closing Conditions"]
[null,68,null,"Other","Misc. Documents"]
["E.  Permanent Conversion"]
[null,{"$f":"B81+1","v":69},null,"Verification that deal points comply with the terms and conditions of the Department's Regulatory Agreement and the information provided to the Department during the construction loan closing process.",null,null,null,"Verify with AMC"]
[null,{"$f":"B83+1","v":70},null,"Current/Updated Preliminary Title Report (PTR) with hyperlinks. If there is a ground lease, two hyperlinked PTRs are required: one for fee estate and one for leasehold estate. If combining multiple properties into one development submit: PTR with all properties identified, copies of all leases on all properties and copies of any unrecorded financing/loan documents.","Less than 30 days old.                         NOTE: An updated PTR will be required prior to closing the transaction."]
[null,{"$f":"B84+1","v":71},null,"Verification that reserve accounts have been capitalized as required by the Department",null,null,null,"If required by the Regulatory Agreement at permanent close, provide bank statements showing that reserve accounts have been capitalized OR provide an estimated settlement statement showing that funds from escrow will be disbursed to those reserve accounts at close"]
[null,{"$f":"B85+1","v":72},null,"New permanent loan that will be on title at the time of HCD loan recordation - Bond Financing Term Sheet and  all draft documents.  Executed documents, exhibits and attachments due prior to closing. Final documents, exhibits and attachments","If applicable, enter name of 1st Senior Permanent lender, loan amount, & lien position in comments field. ",null,null,"Draft loan documents must be submitted for HCD approval no less than 30 days prior to anticipated closing date"]
[null,{"$f":"B86+1","v":73},null,"Estimated cost certification"]
[null,74,null,"Resolution of non-compliance issues(s)  (e.g., back interest due; occupancy, rent deficiencies; past due reports for all projects associated with Sponsor or Borrower, etc.)","HCD Regs regarding sponsor compliance with all HCD loan programs and projects owned and/or operated",null,null,"Transactions Unit Loan Officer will consult with all HCD divisions and report results to Sponsor in order to resolve any compliance issues"]
[null,75,null,"Buyer's and Seller's Settlement Statements","Provided by Escrow Officer. Estimated Closing Statements are required to be delivered and approved by HCD prior to authorizing recordation."]
[null,76,null,"Proforma Title Insurance Policy","Provided by Escrow Officer. Estimated Closing Statements are required to be delivered and approved by HCD prior to authorizing recordation."]
[null,77,null,"Escrow Instructions Acknowledgement and Receipt executed"]
[null,78,null,"Other","Misc. Documents"]
["1.  HCD may require additional documents after reviewing submittals from this Attachments Checklist."]
["2.  An updated hyperlinked Preliminary Title Report will be required within 60 days of transaction closing date, or at the time HCD starts drafting loan documents, whichever comes first."]

{"sheet":"Funding Sources","index":5,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[15,10,15,11],[16,2,16,4],[14,10,14,11],[7,10,7,11],[46,0,46,1],[46,2,46,4],[29,10,29,11],[31,0,31,1],[31,2,31,4],[16,0,16,1],[24,10,24,11],[19,10,19,11],[21,10,21,11],[22,10,22,11],[23,10,23,11],[30,10,30,11],[32,0,32,11],[17,0,17,11],[18,10,18,11],[25,10,25,11],[26,10,26,11],[20,10,20,11],[27,10,27,11],[28,10,28,11],[3,10,3,11],[4,10,4,11],[0,0,0,1],[12,10,12,11],[13,10,13,11],[2,0,2,11],[8,10,8,11],[5,10,5,11],[0,2,0,4],[9,10,9,11],[10,10,10,11],[6,10,6,11],[11,10,11,11]]}
[{"$f":"CONCATENATE(\"Funding Sources  \",'General Summary'!I5)","v":"Funding Sources  (Version 7/18/17)"},null,{"$f":"'General Summary'!C6","v":0}]
[]
["Existing Funding Sources"]
["Lien Positn","Name of Lender ","Type of Entity ","Term to\nMaturity\n(months)","Interest\nRate","Interest Rate\nType","Principal\nAmount","Accrued\nInterest\nAmount","Annual\nPayment ","Funding Type","Comments (if HCD, enter contract #)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Totals",null,null,null,{"$f":"SUM(G5:G16)","v":0},{"$f":"SUM(H5:H16)","v":0},{"$f":"SUM(I5:I16)","v":0}]
["Construction Funding Sources"]
["Lien Positn","Name of Lender ","Type of Entity ","Term to\nMaturity\n(months)","Interest\nRate","Interest Rate\nType","Principal\nAmount","Accrued\nInterest\nAmount","Annual\nPayment ","Funding Type","Comments (if HCD, enter contract #)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Totals",null,null,null,{"$f":"SUM(G20:G31)","v":0},{"$f":"SUM(H20:H31)","v":0},{"$f":"SUM(I20:I31)","v":0}]
["Permanent Funding Sources"]
["Lien Positn","Name of Lender ","Type of Entity ","Term to\nMaturity\n(years)","Interest Rate","Interest Rate\nType","Principal\nAmount","Accrued\nInterest\nAmount","Annual\nPayment ","Funding Type","Loan\nStatus","Comments\n(if HCD, enter contract #)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Totals",null,null,null,{"$f":"SUM(G35:G46)","v":0},{"$f":"SUM(H35:H46)","v":0},{"$f":"SUM(I35:I46)","v":0}]

{"sheet":"Development Budget","index":6,"n_rows":130,"n_cols":22,"rows_kept":130,"cut":false,"hidden":false,"merged":[[110,0,110,1],[111,0,111,1],[112,0,112,1],[113,0,113,1],[114,0,114,1],[115,0,115,1],[104,0,104,1],[105,0,105,1],[106,0,106,1],[107,0,107,1],[108,0,108,1],[109,0,109,1],[128,0,128,1],[129,0,129,1],[122,0,122,1],[123,0,123,1],[124,0,124,1],[125,0,125,1],[126,0,126,1],[127,0,127,1],[116,0,116,1],[117,0,117,1],[118,0,118,1],[119,0,119,1],[120,0,120,1],[121,0,121,1],[98,0,98,1],[99,0,99,1],[100,0,100,1],[101,0,101,1],[102,0,102,1],[103,0,103,1],[92,0,92,1],[93,0,93,1],[94,0,94,1],[95,0,95,1],[96,0,96,1],[97,0,97,1],[86,0,86,1],[87,0,87,1],[88,0,88,1],[89,0,89,1],[90,0,90,1],[91,0,91,1],[80,0,80,1],[81,0,81,1],[82,0,82,1],[83,0,83,1],[84,0,84,1],[85,0,85,1],[74,0,74,1],[75,0,75,1],[76,0,76,1],[77,0,77,1],[78,0,78,1],[79,0,79,1],[68,0,68,1],[69,0,69,1],[70,0,70,1],[71,0,71,1],[72,0,72,1],[73,0,73,1],[61,0,61,1],[62,0,62,1],[63,0,63,1],[64,0,64,1],[65,0,65,1],[67,0,67,1],[55,0,55,1],[56,0,56,1],[57,0,57,1],[58,0,58,1],[59,0,59,1],[60,0,60,1],[48,0,48,1],[49,0,49,1],[50,0,50,1],[52,0,52,1],[53,0,53,1],[54,0,54,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[47,0,47,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[2,21,3,21],[4,0,4,1],[5,0,5,1],[2,15,3,15],[2,16,3,16],[2,17,3,17],[2,9,3,9],[2,11,3,11],[2,12,3,12],[2,13,3,13],[2,14,3,14],[1,5,1,16],[2,18,3,18],[1,19,1,20],[2,7,3,7],[2,8,3,8],[2,10,3,10],[2,19,3,19],[2,20,3,20],[2,0,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[0,0,1,1],[0,2,0,6]]}
[{"$f":"CONCATENATE(\"Development Budget  \",'General Summary'!I5)","v":"Development Budget  (Version 7/18/17)"},null,{"$f":"'General Summary'!C6","v":0}]
[null,null,null,null,null,"Residential Permanent Sources of Funds",null,null,null,null,null,null,null,null,null,null,null,null,null,"Commercial Sources"]
["Uses of Funds",null,"Total Costs\nResidential\n&\nCommercial","Commercial\nCosts","Residential\nCosts",{"$f":"IF('Funding Sources'!B35=\"\",\"\",'Funding Sources'!B35)","v":""},{"$f":"IF('Funding Sources'!B36=\"\",\"\",'Funding Sources'!B36)","v":""},{"$f":"IF('Funding Sources'!B37=\"\",\"\",'Funding Sources'!B37)","v":""},{"$f":"IF('Funding Sources'!B38=\"\",\"\",'Funding Sources'!B38)","v":""},{"$f":"IF('Funding Sources'!B39=\"\",\"\",'Funding Sources'!B39)","v":""},{"$f":"IF('Funding Sources'!B40=\"\",\"\",'Funding Sources'!B40)","v":""},{"$f":"IF('Funding Sources'!B41=\"\",\"\",'Funding Sources'!B41)","v":""},{"$f":"IF('Funding Sources'!B42=\"\",\"\",'Funding Sources'!B42)","v":""},{"$f":"IF('Funding Sources'!B43=\"\",\"\",'Funding Sources'!B43)","v":""},{"$f":"IF('Funding Sources'!B44=\"\",\"\",'Funding Sources'!B44)","v":""},{"$f":"IF('Funding Sources'!B45=\"\",\"\",'Funding Sources'!B45)","v":""},{"$f":"IF('Funding Sources'!B46=\"\",\"\",'Funding Sources'!B46)","v":""},"Total\nResidential\nSources","Residential\nCosts\nDifference\nDev Budget\nvs. Sources","Source Name:","Source Name:","Commercial\nCosts\nDifference\nDev Budget\nvs. Sources"]
[]
["ACQUISITION"]
["Lesser of Land Cost or Value ",null,null,null,{"$f":"C6-D6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F6:Q6)","v":0},{"$f":"E6-R6","v":0},null,null,{"$f":"D6-T6-U6","v":0}]
["Demolition",null,null,null,{"$f":"C7-D7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F7:Q7)","v":0},0,null,null,{"$f":"D7-T7-U7","v":0}]
["Legal & Closing Costs ",null,null,null,{"$f":"C8-D8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F8:Q8)","v":0},0,null,null,0]
["Verifiable Carrying Costs",null,null,null,{"$f":"C9-D9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F9:Q9)","v":0},0,null,null,0]
["Subtotal ",null,{"$f":"SUM(C6:C9)","v":0},0,0,0,0,0,0,{"$f":"SUM(J6:J9)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(R6:R9)","v":0},0,{"$f":"SUM(T6:T9)","v":0},{"$f":"SUM(U6:U9)","v":0},0]
["Existing Improvements Cost",null,null,null,{"$f":"C11-D11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F11:Q11)","v":0},0,null,null,0]
["Other - describe",null,null,null,{"$f":"C12-D12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F12:Q12)","v":0},0,null,null,0]
["Total Acquisition ",null,{"$f":"SUM(C10:C12)","v":0},{"$f":"SUM(D10:D12)","v":0},{"$f":"SUM(E10:E12)","v":0},{"$f":"SUM(F10:F12)","v":0},{"$f":"SUM(G10:G12)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R10:R12)","v":0},0,0,{"$f":"SUM(U10:U12)","v":0},0]
["REHABILITATION "]
["Off-Site Improvements ",null,null,null,{"$f":"C15-D15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F15:Q15)","v":0},{"$f":"E15-R15","v":0},null,null,{"$f":"D15-T15-U15","v":0}]
["Environmental Remediation",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Site Work",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Structures ",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["General Requirements",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Contractor Overhead",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Contractor Profit",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["General Liability Insurance",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Other - describe",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Total Rehabilitation Costs",null,{"$f":"SUM(C15:C23)","v":0},{"$f":"SUM(D15:D23)","v":0},{"$f":"SUM(E15:E23)","v":0},{"$f":"SUM(F15:F23)","v":0},{"$f":"SUM(G15:G23)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R15:R23)","v":0},0,0,0,0]
["RELOCATION"]
["Temporary Relocation ",null,null,null,{"$f":"C26-D26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F26:Q26)","v":0},{"$f":"E26-R26","v":0},null,null,{"$f":"D26-T26-U26","v":0}]
["Permanent Relocation ",null,null,null,{"$f":"C27-D27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F27:Q27)","v":0},{"$f":"E27-R27","v":0},null,null,0]
["Total Relocation ",null,{"$f":"SUM(C26:C27)","v":0},{"$f":"SUM(D26:D27)","v":0},{"$f":"SUM(E26:E27)","v":0},{"$f":"SUM(F26:F27)","v":0},{"$f":"SUM(G26:G27)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R26:R27)","v":0},{"$f":"E28-R28","v":0},0,0,0]
["NEW CONSTRUCTION "]
["Off-Site Improvements ",null,null,null,{"$f":"C30-D30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F30:Q30)","v":0},{"$f":"E30-R30","v":0},null,null,{"$f":"D30-T30-U30","v":0}]
["Environmental Remediation",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Site Work (hard costs)",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Structures (hard costs)",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["General Requirements ",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Contractor Overhead",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Contractor Profit",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["General Liability Insurance",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Other - describe",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Total New Construction",null,{"$f":"SUM(C30:C38)","v":0},{"$f":"SUM(D30:D38)","v":0},{"$f":"SUM(E30:E38)","v":0},{"$f":"SUM(F30:F38)","v":0},{"$f":"SUM(G30:G38)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R30:R38)","v":0},0,0,0,0]
["ARCHITECTURAL "]
["Design",null,null,null,{"$f":"C41-D41","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F41:Q41)","v":0},{"$f":"E41-R41","v":0},null,null,{"$f":"D41-T41-U41","v":0}]
["Supervision",null,null,null,{"$f":"C42-D42","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F42:Q42)","v":0},{"$f":"E42-R42","v":0},null,null,0]
["Total Architectural Costs",null,{"$f":"SUM(C41:C42)","v":0},{"$f":"SUM(D41:D42)","v":0},{"$f":"SUM(E41:E42)","v":0},{"$f":"SUM(F41:F42)","v":0},{"$f":"SUM(G41:G42)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R41:R42)","v":0},{"$f":"E43-R43","v":0},0,0,0]
["SURVEY & ENGINEERING "]
["Engineering ",null,null,null,{"$f":"C45-D45","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F45:Q45)","v":0},{"$f":"E45-R45","v":0},null,null,{"$f":"D45-T45-U45","v":0}]
["ALTA Land Survey ",null,null,null,{"$f":"C46-D46","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F46:Q46)","v":0},{"$f":"E46-R46","v":0},null,null,0]
["Total Survey & Engineering",null,{"$f":"SUM(C45:C46)","v":0},{"$f":"SUM(D45:D46)","v":0},{"$f":"SUM(E45:E46)","v":0},{"$f":"SUM(F45:F46)","v":0},{"$f":"SUM(G45:G46)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R45:R46)","v":0},{"$f":"E47-R47","v":0},0,0,0]
["CONTINGENCY COSTS"]
["Hard Cost Contingency",null,null,null,{"$f":"C49-D49","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F49:Q49)","v":0},{"$f":"E49-R49","v":0},null,null,{"$f":"D49-T49-U49","v":0}]
["Soft Cost Contingency ",null,null,null,{"$f":"C50-D50","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F50:Q50)","v":0},{"$f":"E50-R50","v":0},null,null,0]
["Total Contingency Costs",null,{"$f":"SUM(C49:C50)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R49:R50)","v":0},{"$f":"E51-R51","v":0},0,0,0]
["CONSTRUCTION PERIOD EXPENSES"]
["Construction Loan Interest",null,null,null,{"$f":"C53-D53","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F53:Q53)","v":0},{"$f":"E53-R53","v":0},null,null,{"$f":"D53-T53-U53","v":0}]
["Origination Fee",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Credit Enhance. & App Fee",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Owner Paid Bonds/Insurance",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Lender Inspection Fees",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Taxes During Construction ",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Prevailing Wage Monitor",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Insurance during Construction",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Title and Recording Fees",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Construction Mgmt. & Testing",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Predevelopment Interest Exp. ",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Other - describe",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Other - describe",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Total Construction Expenses",null,{"$f":"SUM(C53:C65)","v":0},{"$f":"SUM(D53:D65)","v":0},{"$f":"SUM(E53:E65)","v":0},{"$f":"SUM(F53:F65)","v":0},{"$f":"SUM(G53:G65)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R53:R65)","v":0},0,0,0,0]
["PERMANENT FINANCING EXPENSES"]
["Loan Origination Fee(s)",null,null,null,{"$f":"C68-D68","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F68:Q68)","v":0},{"$f":"E68-R68","v":0},null,null,{"$f":"D68-T68-U68","v":0}]
["Credit Enhance. & App. Fee",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Title and Recording",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Property Taxes  ",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Insurance ",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Other - describe",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Other - describe",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Total Permanent Financing",null,{"$f":"SUM(C68:C74)","v":0},{"$f":"SUM(D68:D74)","v":0},{"$f":"SUM(E68:E74)","v":0},{"$f":"SUM(F68:F74)","v":0},{"$f":"SUM(G68:G74)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R68:R74)","v":0},0,0,0,0]
["LEGAL FEES"]
["Construct. Lender Legal Exp.",null,null,null,{"$f":"C77-D77","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F77:Q77)","v":0},{"$f":"E77-R77","v":0},null,null,{"$f":"D77-T77-U77","v":0}]
["Perm. Lender Legal Fees",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Sponsor Legal Fees",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Organizational Legal Fees",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Syndication Legal Fees ",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Other - describe",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Total Legal Fees",null,{"$f":"SUM(C77:C82)","v":0},{"$f":"SUM(D77:D82)","v":0},{"$f":"SUM(E77:E82)","v":0},{"$f":"SUM(F77:F82)","v":0},{"$f":"SUM(G77:G82)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R77:R82)","v":0},0,0,0,0]
["CAPITALIZED RESERVES"]
["Operating Reserve",null,null,null,{"$f":"C85-D85","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F85:Q85)","v":0},{"$f":"E85-R85","v":0},null,null,{"$f":"D85-T85-U85","v":0}]
["Replacement Reserve",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Rent-Up Reserve",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Transition Reserve ",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Other - describe",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Other - describe",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Total Capitalized Reserves",null,{"$f":"SUM(C85:C90)","v":0},0,0,0,0,0,{"$f":"SUM(I85:I90)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(R85:R90)","v":0},0,{"$f":"SUM(T85:T90)","v":0},{"$f":"SUM(U85:U90)","v":0},0]
["REPORTS & STUDIES "]
["Appraisal(s)",null,null,null,{"$f":"C93-D93","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F93:Q93)","v":0},{"$f":"E93-R93","v":0},null,null,{"$f":"D93-T93-U93","v":0}]
["Market Study",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Physical Needs Assessment",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Environmental Studies ",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Other - describe",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Other - describe",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Other - describe",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Other - describe",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Total Reports & Studies",null,{"$f":"SUM(C93:C100)","v":0},{"$f":"SUM(D93:D100)","v":0},{"$f":"SUM(E93:E100)","v":0},{"$f":"SUM(F93:F100)","v":0},{"$f":"SUM(G93:G100)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R93:R100)","v":0},0,0,0,0]
["OTHER"]
["CTCAC App/Alloc/Monitr Fee",null,null,null,{"$f":"C103-D103","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F103:Q103)","v":0},{"$f":"E103-R103","v":0},null,null,{"$f":"D103-T103-U103","v":0}]
["CDLAC Fees",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Local Permit Fees ",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Local Develop. Impact Fees",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Other Bond Issuance Costs",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Syndicator/Invest. Fees & Exp.",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Furnishings",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Final Cost Audit Expense",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Marketing ",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Financial Consulting",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Other - describe",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Other - describe",null,null,null,0,null,null,null," ",null,null,null,null,null,null,null,null,0,0,null,null,0]
["Other - describe",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Other - describe",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Total Other Costs",null,{"$f":"SUM(C103:C116)","v":0},{"$f":"SUM(D103:D116)","v":0},{"$f":"SUM(E103:E116)","v":0},{"$f":"SUM(F103:F116)","v":0},{"$f":"SUM(G103:G116)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R103:R116)","v":0},0,0,0,0]
["SUBTOTAL ",null,{"$f":"SUM(C13,C24,C28,C39,C43,C47,C51,C66,C75,C83,C91,C101,C117)","v":0},{"$f":"SUM(D13,D24,D28,D39,D43,D47,D51,D66,D75,D83,D91,D101,D117)","v":0},{"$f":"SUM(E13,E24,E28,E39,E43,E47,E51,E66,E75,E83,E91,E101,E117)","v":0},{"$f":"SUM(F13,F24,F28,F39,F43,F47,F51,F66,F75,F83,F91,F101,F117)","v":0},{"$f":"SUM(G13,G24,G28,G39,G43,G47,G51,G66,G75,G83,G91,G101,G117)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R13,R24,R28,R39,R43,R47,R51,R66,R75,R83,R91,R101,R117)","v":0},0,0,{"$f":"SUM(U13,U24,U28,U39,U43,U47,U51,U66,U75,U83,U91,U101,U117)","v":0},0]
["DEVELOPER COSTS"]
["Develop Fee/Overhead/Profit",null,null,null,{"$f":"C120-D120","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F120:Q120)","v":0},{"$f":"E120-R120","v":0},null,null,{"$f":"D120-T120-U120","v":0}]
["Consultant/Processing Agent",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Project Administration",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Syndicator Consultant Fees",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Guarantee Fees",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Broker Fees to Related Party",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Const. Oversight & Mgmt.",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Other - describe",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Other - describe",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0]
["Total Developer Costs",null,{"$f":"SUM(C120:C128)","v":0},{"$f":"SUM(D120:D128)","v":0},{"$f":"SUM(E120:E128)","v":0},{"$f":"SUM(F120:F128)","v":0},{"$f":"SUM(G120:G128)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R120:R128)","v":0},0,0,0,0]
["TOTAL DEVELOPMENT COST",null,{"$f":"+C118+C129","v":0},{"$f":"+D118+D129","v":0},{"$f":"+E118+E129","v":0},{"$f":"+F118+F129","v":0},{"$f":"+G118+G129","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+R118+R129","v":0},0,0,0,0]

{"sheet":"Operating Budget","index":7,"n_rows":116,"n_cols":10,"rows_kept":116,"cut":false,"hidden":false,"merged":[[1,0,1,1],[1,3,1,4],[1,7,1,8],[3,0,5,0],[3,3,5,3],[3,1,5,2],[6,1,6,2],[7,1,7,2],[0,0,0,3],[0,4,0,9],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[57,0,58,0],[57,1,57,7],[57,8,57,9],[58,1,58,9],[59,1,59,7],[59,8,59,9],[60,1,60,7],[60,8,60,9],[61,1,61,7],[61,8,61,9],[62,1,62,7],[62,8,62,9],[63,1,63,7],[63,8,63,9],[64,1,64,7],[64,8,64,9],[65,1,65,7],[65,8,65,9],[66,1,66,7],[66,8,66,9],[67,1,67,7],[67,8,67,9],[68,1,68,7],[68,8,68,9],[69,1,69,7],[69,8,69,9],[70,1,70,7],[70,8,70,9],[71,1,71,7],[71,8,71,9],[72,1,72,7],[72,8,72,9],[73,1,73,7],[73,8,73,9],[74,1,74,7],[74,8,74,9],[75,1,75,7],[75,8,75,9],[76,1,76,7],[76,8,76,9],[77,1,77,7],[77,8,77,9],[78,8,78,9],[79,1,79,9],[80,1,80,7],[80,8,80,9],[81,1,81,7],[81,8,81,9],[82,1,82,7],[82,8,82,9],[83,1,83,7],[83,8,83,9],[84,1,84,7],[84,8,84,9],[85,1,85,7],[85,8,85,9],[86,1,86,7],[86,8,86,9],[87,1,87,7],[87,8,87,9],[88,1,88,7],[88,8,88,9],[89,1,89,7],[89,8,89,9],[90,1,90,7],[90,8,90,9],[91,1,91,7],[91,8,91,9],[92,1,92,7],[92,8,92,9],[93,1,93,7],[93,8,93,9],[94,1,94,7],[94,8,94,9],[95,1,95,7],[95,8,95,9],[96,1,96,7],[96,8,96,9],[97,1,97,7],[97,8,97,9],[98,1,98,7],[98,8,98,9],[99,8,99,9],[100,1,100,9],[101,1,101,7],[101,8,101,9],[102,1,102,7],[102,8,102,9],[103,1,103,7],[103,8,103,9],[104,1,104,7],[104,8,104,9],[105,1,105,7],[105,8,105,9],[106,1,106,7],[106,8,106,9],[113,1,113,7],[113,8,113,9],[114,1,114,7],[114,8,114,9],[115,1,115,7],[115,8,115,9],[107,8,107,9],[108,1,108,9],[109,1,109,7],[109,8,109,9],[110,1,110,7],[110,8,110,9],[111,1,111,7],[111,8,111,9],[112,1,112,7],[112,8,112,9]]}
[{"$f":"CONCATENATE(\"Operating Budget  \",'General Summary'!I5)","v":"Operating Budget  (Version 7/18/17)"},null,null,null,{"$f":"'General Summary'!C6","v":0}]
["Total Units:",null,{"$f":"'General Summary'!C9","v":0},"Assisted Units:",null,{"$f":"'General Summary'!G9","v":0},null,"Proration Percentage:",null,{"$f":"IF(C2=0,0,F2/C2)","v":0}]
[]
["Line #","Account Name",null,"Account\nCode","(A)","(B)","(C)","(D)","(E)","(F)"]
[null,null,null,null," Total","Proration","Assisted","Non-Assisted"]
[null,null,null,null,"Budget\nProposed","Percentage\nProposed","Units\nProposed","Units\nProposed","Commercial\nProposed"," Total\n(C)+(D)+(E)"]
[null,"Administrative Expenses:"]
[1,"Conventions and Meetings",null,6203,0,{"$f":"$J$2","v":0},{"$f":"(E8-I8)*F8","v":0},{"$f":"+(E8-G8-I8)","v":0},0,{"$f":"SUM(G8:I8)","v":0}]
[2,"Management Consultants",null,6204,0,{"$f":"$J$2","v":0},{"$f":"(E9-I9)*F9","v":0},{"$f":"+(E9-G9-I9)","v":0},0,{"$f":"SUM(G9:I9)","v":0}]
[3,"Advertising and Marketing",null,6210,0,0,0,0,0,0]
[4,"Other Renting Expenses",null,6250,0,0,0,0,0,0]
[5,"Office Salaries",null,6310,0,0,0,0,0,0]
[6,"Office Expenses",null,6311,0,0,0,0,0,0]
[7,"Office or Model Apartment Rent",null,6312,0,0,0,0,0,0]
[8,"Management Fee (do not include GP Management Fee)",null,6320,0,0,0,0,0,0]
[9,"Manager or Superintendent Salaries",null,6330,0,0,0,0,0,0]
[10,"Administrative Rent Free Unit",null,6331,0,0,0,0,0,0]
[11,"Legal Expense - Project",null,6340,0,0,0,0,0,0]
[12,"Audit Expense",null,6350,0,0,{"$f":"(E19-I19)*F19","v":0},{"$f":"+(E19-G19-I19)","v":0},0,{"$f":"SUM(G19:I19)","v":0}]
[13,"Bookkeeping Fees/ Accounting Services",null,6351,0,0,{"$f":"(E20-I20)*F20","v":0},{"$f":"+(E20-G20-I20)","v":0},0,{"$f":"SUM(G20:I20)","v":0}]
[14,"Bad Debts",null,6370,0,0,{"$f":"(E21-I21)*F21","v":0},{"$f":"+(E21-G21-I21)","v":0},0,0]
[15,"Misc. Admin. Exp. (including Service Coord. Salary/Benefits)",null,6390,{"$f":"I78","v":0},0,{"$f":"(E22-I22)*F22","v":0},{"$f":"+(E22-G22-I22)","v":0},0,{"$f":"SUM(G22:I22)","v":0}]
[16,"Total Administrative Expenses",null,"6263T",{"$f":"SUM(E8:E22)","v":0},null,{"$f":"SUM(G8:G22)","v":0},{"$f":"SUM(H8:H22)","v":0},{"$f":"SUM(I8:I22)","v":0},{"$f":"SUM(J8:J22)","v":0}]
[null,"Utilities:"]
[17,"Electricity",null,6450,0,{"$f":"$J$2","v":0},{"$f":"(E25-I25)*F25","v":0},{"$f":"+(E25-G25-I25)","v":0},0,0]
[18,"Water",null,6451,0,{"$f":"$J$2","v":0},{"$f":"(E26-I26)*F26","v":0},{"$f":"+(E26-G26-I26)","v":0},0,0]
[19,"Gas",null,6452,0,{"$f":"$J$2","v":0},{"$f":"(E27-I27)*F27","v":0},{"$f":"+(E27-G27-I27)","v":0},0,0]
[20,"Sewer",null,6453,0,{"$f":"$J$2","v":0},{"$f":"(E28-I28)*F28","v":0},{"$f":"+(E28-G28-I28)","v":0},0,0]
[21,"Total Utilities Expenses",null,"6400T",{"$f":"SUM(E25:E28)","v":0},null,{"$f":"SUM(G25:G28)","v":0},{"$f":"SUM(H25:H28)","v":0},{"$f":"SUM(I25:I28)","v":0},{"$f":"SUM(J25:J28)","v":0}]
[null,"Operating and Maintenance Expenses:"]
[22,"Payroll",null,6510,0,{"$f":"$J$2","v":0},{"$f":"(E31-I31)*F31","v":0},{"$f":"+(E31-G31-I31)","v":0},0,{"$f":"SUM(G31:I31)","v":0}]
[23,"Supplies",null,6515,0,0,0,0,0,0]
[24,"Contracts",null,6520,0,0,0,0,0,0]
[25,"Operating and Maintenance Rent Free Unit",null,6521,0,0,{"$f":"(E34-I34)*F34","v":0},{"$f":"+(E34-G34-I34)","v":0},0,{"$f":"SUM(G34:I34)","v":0}]
[26,"Garbage and Trash Removal",null,6525,0,0,{"$f":"(E35-I35)*F35","v":0},{"$f":"+(E35-G35-I35)","v":0},0,{"$f":"SUM(G35:I35)","v":0}]
[27,"Security Payroll/Contracts",null,6530,0,0,{"$f":"(E36-I36)*F36","v":0},{"$f":"+(E36-G36-I36)","v":0},0,{"$f":"SUM(G36:I36)","v":0}]
[28,"Security Rent Free Unit",null,6531,0,0,{"$f":"(E37-I37)*F37","v":0},{"$f":"+(E37-G37-I37)","v":0},0,{"$f":"SUM(G37:I37)","v":0}]
[29,"Heating/Cooling Repairs and Maintenance",null,6546,0,0,{"$f":"(E38-I38)*F38","v":0},{"$f":"+(E38-G38-I38)","v":0},0,{"$f":"SUM(G38:I38)","v":0}]
[30,"Snow Removal",null,6548,0,0,0,0,0,0]
[31,"Vehicle and Maintenance Equip. Operation and Repairs",null,6570,0,0,0,0,0,0]
[32,"Lease Expense",null,6580,0,0,{"$f":"(E41-I41)*F41","v":0},{"$f":"+(E41-G41-I41)","v":0},0,{"$f":"SUM(G41:I41)","v":0}]
[33,"Misc. Operating & Maintenance Expenses",null,6590,{"$f":"I99","v":0},0,0,0,0,0]
[34,"Total Operating and Maintenance Expenses",null,"6500T",{"$f":"SUM(E31:E42)","v":0},null,{"$f":"SUM(G31:G42)","v":0},{"$f":"SUM(H31:H42)","v":0},{"$f":"SUM(I31:I42)","v":0},{"$f":"SUM(J31:J42)","v":0}]
[null,"Taxes and Insurance:"]
[35,"Real Estate Taxes",null,6710,0,{"$f":"$J$2","v":0},{"$f":"(E45-I45)*F45","v":0},{"$f":"+(E45-G45-I45)","v":0},0,{"$f":"SUM(G45:I45)","v":0}]
[36,"Payroll Taxes (Project's Share)",null,6711,0,0,0,0,0,0]
[37,"Property & Liability Insurance (Hazard)",null,6720,0,0,{"$f":"(E47-I47)*F47","v":0},{"$f":"+(E47-G47-I47)","v":0},0,{"$f":"SUM(G47:I47)","v":0}]
[38,"Fidelity Bond Insurance",null,6721,0,0,0,0,0,0]
[39,"Worker's Compensation",null,6722,0,0,0,0,0,0]
[40,"Health Insurance and Other Employee Benefits",null,6723,0,0,0,0,0,0]
[41,"Miscellaneous Taxes, Licenses, Permits and Insurance",null,6790,{"$f":"I107","v":0},0,0,0,0,0]
[42,"Total Taxes and Insurance",null,"6700T",{"$f":"SUM(E45:E51)","v":0},null,{"$f":"SUM(G45:G51)","v":0},{"$f":"SUM(H45:H51)","v":0},{"$f":"SUM(I45:I51)","v":0},{"$f":"SUM(J45:J51)","v":0}]
[null,"Assisted Living/Board & Care Expenses:"]
[43,"Other Service Expenses (see cell comment)",null,6990,{"$f":"I116","v":0},{"$f":"$J$2","v":0},{"$f":"(E54-I54)*F54","v":0},{"$f":"+(E54-G54-I54)","v":0},0,{"$f":"SUM(G54:I54)","v":0}]
[44,"Total Assisted Living/Board & Care Expenses",null,"6900T",{"$f":"E54","v":0},null,{"$f":"G54","v":0},{"$f":"H54","v":0},{"$f":"I54","v":0},{"$f":"J54","v":0}]
[45,"Total Cost of Operations",null,"6000T",{"$f":"E23+E29+E43+E52+E55","v":0},null,{"$f":"G23+G29+G43+G52+G55","v":0},{"$f":"H23+H29+H43+H52+H55","v":0},{"$f":"I23+I29+I43+I52+I55","v":0},{"$f":"J23+J29+J43+J52+J55","v":0}]
[]
["Line #","For each account below, itemize the expenses (total will flow to account above)",null,null,null,null,null,null,"Amount"]
[null,"Account 6390 Miscellaneous Administrative Expenses"]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64,"Total Account 6390 Miscellaneous Administrative Expenses",null,null,null,null,null,null,{"$f":"SUM(I60:J77)","v":0}]
[]
[null,"Account 6590 Miscellaneous Operations & Maintenance Expenses"]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83,"Total Account 6590 Miscellaneous Operations & Maintenance Expenses",null,null,null,null,null,null,{"$f":"SUM(I81:J98)","v":0}]
[]
[null,"Account 6790 Misc. Taxes, Licenses, Permits & Insurance"]
[84]
[85]
[86]
[87]
[88]
[89,"Total Account 6790 Misc. Taxes, Licenses, Permits & Insurance",null,null,null,null,null,null,{"$f":"SUM(I102:J106)","v":0}]
[]
[null,"Account 6990 Other Service Expenses"]
[90]
[91]
[92]
[93]
[94]
[95]
[96,"Total Account 6990 Other Service Expenses",null,null,null,null,null,null,{"$f":"SUM(I110:J115)","v":0}]

{"sheet":"Revenue-Cash Flow non FMTW,MHP","index":8,"n_rows":68,"n_cols":8,"rows_kept":68,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,1,1],[1,3,1,4],[2,0,4,0],[2,1,4,2],[2,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[22,1,22,2],[23,1,23,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[47,0,47,3],[28,1,28,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[42,1,42,2],[44,0,44,7],[60,1,60,7],[59,1,59,5],[59,6,59,7],[57,6,57,7],[58,6,58,7],[58,1,58,5],[55,0,56,0],[55,1,55,5],[57,1,57,5],[48,4,50,7],[51,4,52,7],[55,6,55,7],[56,1,56,7],[48,0,48,3],[53,4,53,7],[45,4,45,7],[46,4,47,7],[53,0,53,3],[49,0,49,3],[52,0,52,3],[51,0,51,3],[50,0,50,3],[46,0,46,3],[45,0,45,3],[61,1,61,5],[67,6,67,7],[65,6,65,7],[64,1,64,7],[66,6,66,7],[63,1,63,5],[63,6,63,7],[65,1,65,5],[66,1,66,5],[67,1,67,5],[62,1,62,5],[61,6,61,7],[62,6,62,7]]}
["PROPOSED REVENUE, MANDATORY DEBT AND RESERVE DEPOSITS - Operating Budget\nUse this form if Original Program funding was CHRP-R, SUHRP, SERA, RHCP-O, CALDAP, DPRLP, FHDP, or RHCP-B"]
["Total Units:",null,{"$f":"'Operating Budget'!C2","v":0},"Assisted Units:",null,{"$f":"'Operating Budget'!F2","v":0},"Proration %:",{"$f":"'Operating Budget'!J2","v":0}]
["Line #","Account Name",null,"Account\nCode","(A)","(B)","(C)","(D)"]
[null,null,null,null,"Assisted\nUnits","Non-Assisted\nUnits","Commercial\nProposed","Total Project"]
[]
[null,"Rent Revenue: *See instructions below for lines 1-3"]
[1,"Rent Revenue - Gross Potential",null,5120,0,0,null,{"$f":"SUM(E7:G7)","v":0}]
[2,"Tenant Assistance Payments",null,5121,0,0,null,{"$f":"SUM(E8:G8)","v":0}]
[3,"Rent Revenue - Stores and Commercial",null,5140,null,null,0,{"$f":"SUM(E9:G9)","v":0}]
[4,"Garage and Parking Spaces",null,5170,0,0,0,{"$f":"SUM(E10:G10)","v":0}]
[5,"Flexible Subsidy Revenue",null,5180,0,0,0,{"$f":"SUM(E11:G11)","v":0}]
[6,"Miscellaneous Rent Revenue",null,5190,{"$f":"(H12-G12)*$H$2","v":0},{"$f":"H12-E12-G12","v":0},0,{"$f":"G60","v":0}]
[7,"Total Rent Revenue",null,"5100T",{"$f":"SUM(E7:E12)","v":0},{"$f":"SUM(F7:F12)","v":0},{"$f":"SUM(G7:G12)","v":0},{"$f":"SUM(H7:H12)","v":0}]
[null,"Vacancies:"]
[8,"Vacancy %",null,null,0,0,0]
[9,"Apartments",null,5220,{"$f":"E7*E15","v":0},{"$f":"F7*F15","v":0},null,{"$f":"SUM(E16:G16)","v":0}]
[10,"Stores and Commercial",null,5240,null,null,{"$f":"G9*G15","v":0},{"$f":"SUM(E17:G17)","v":0}]
[11,"Rental Concessions",null,5250,0,0,0,{"$f":"SUM(E18:G18)","v":0}]
[12,"Garage and Parking Spaces",null,5270,0,0,0,{"$f":"SUM(E19:G19)","v":0}]
[13,"Miscellaneous Vacancies",null,5290,0,0,0,{"$f":"SUM(E20:G20)","v":0}]
[14,"Total Vacancies",null,"5200T",{"$f":"SUM(E16:E20)","v":0},{"$f":"SUM(F16:F20)","v":0},{"$f":"SUM(G16:G20)","v":0},{"$f":"SUM(H16:H20)","v":0}]
[15,"Net Rental Revenues (Rent Revenue Less Vacancies)",null,"5152N",{"$f":"E13-E21","v":0},{"$f":"F13-F21","v":0},{"$f":"G13-G21","v":0},{"$f":"H13-H21","v":0}]
[null,"Other Revenue:"]
[16,"Laundry and Vending Revenue",null,5910,{"$f":"(H24-G24)*$H$2","v":0},{"$f":"H24-E24-G24","v":0},0,0]
[17,"Tenant Charges",null,5920,{"$f":"(H25-G25)*$H$2","v":0},{"$f":"H25-E25-G25","v":0},0,0]
[18,"Miscellaneous Revenue",null,5990,{"$f":"(H26-G26)*$H$2","v":0},{"$f":"H26-E26-G26","v":0},0,{"$f":"G64","v":0}]
[19,"Total Other Revenue",null,"5900T",{"$f":"SUM(E24:E26)","v":0},{"$f":"SUM(F24:F26)","v":0},{"$f":"SUM(G24:G26)","v":0},{"$f":"SUM(H24:H26)","v":0}]
[20,"Total Revenue",null,"5000T",{"$f":"E22+E27","v":0},{"$f":"F22+F27","v":0},{"$f":"G22+G27","v":0},{"$f":"H22+H27","v":0}]
[null,"Financial Expenses including mandatory debt service:"]
[21,"1st Mortgage (P&I)",null,6820,{"$f":"(H30-G30)*$H$2","v":0},{"$f":"H30-E30-G30","v":0},0,0]
[22,"2nd Mortgage (P&I)",null,6825,0,0,0,0]
[23,"3rd Mortgage (P&I)",null,6825,0,0,0,0]
[24,"HCD Required Payments",null,6825,0,0,0,0]
[25,"Lease Payment",null,6890,0,0,0,0]
[26,"Miscellaneous Financial Expenses",null,6890,0,0,0,{"$f":"G68","v":0}]
[27,"Total Financial Expenses",null,"6800T",{"$f":"SUM(E30:E35)","v":0},{"$f":"SUM(F30:F35)","v":0},{"$f":"SUM(G30:G35)","v":0},{"$f":"SUM(H30:H35)","v":0}]
[null,"Reserves Deposits:"]
[28,"Replacement Reserve - Deposit",null,1320,{"$f":"(H38-G38)*$H$2","v":0},{"$f":"H38-E38-G38","v":0},0,0]
[29,"Operating Reserve - Deposit",null,1330,{"$f":"(H39-G39)*$H$2","v":0},{"$f":"H39-E39-G39","v":0},0,0]
[30,"Transition Reserve  - Deposit",null,1330,{"$f":"(H40-G40)*$H$2","v":0},{"$f":"H40-E40-G40","v":0},0,0]
[31,"Other (specify)",null,1330,{"$f":"(H41-G41)*$H$2","v":0},{"$f":"H41-E41-G41","v":0},0,0]
[32,"Other (specify)",null,1330,{"$f":"(H42-G42)*$H$2","v":0},{"$f":"H42-E42-G42","v":0},0,0]
[33,"Total Reserves Deposits",null,"1300T",{"$f":"SUM(E38:E42)","v":0},{"$f":"SUM(F38:F42)","v":0},{"$f":"SUM(G38:G42)","v":0},{"$f":"SUM(H38:H42)","v":0}]
[]
["*Click on the appropriate link below to complete the applicable Schedule of Rental Income (SRI) corresponding to the Project's existing Program funding. The applicable completed SRI must be attached to this application as Exhibit A. It serves as the source document for Revenues in lines 1-3 above. Please make sure the Revenues on this worksheet match what is reported in the SRI."]
["Eligible Original HCD Loan Program",null,null,null,"For Transactions NOT requesting a Special Rent Increase use the SRI links below according to the original HCD Loan Program"]
["- Family Home Demonstration Program (FHDP)",null,null,null,"RHCP-Bond & FHDP"]
["- Rental Housing Construction Program (RHCP-Bond)"]
["- California Housing Rehabilitation Program-Rental (CHRP-R)",null,null,null,"CHRP, SUHRP & SERA"]
["- Special User Housing Rehabilitation Program (SUHRP)"]
["- State Earthquake Rehabilitation Assistance Program (SERA)"]
["- Calif. Natural Disaster Assistance Program-Rental (CALDAP-R)",null,null,null,"CALDAP-R & DPRLP"]
["- Deferred Payment Rehabilitation Loan Program (DPRLP) - Rental"]
["- Rental Housing Construction Program (RHCP-Original)",null,null,null,"RHCP-Original"]
[]
["Item #","For each account below, itemize the revenues (total will flow to account above)",null,null,null,null,"Amount"]
[null,"Account 5190 Miscellaneous Rent Revenue"]
[34]
[35]
[36,"Total Account 5190",null,null,null,null,{"$f":"SUM(G58:H59)","v":0}]
[null,"Account 5990 Miscellaneous Revenue"]
[37]
[38]
[39,"Total Account 5990",null,null,null,null,{"$f":"SUM(G62:H63)","v":0}]
[null,"Account 6890 Miscellaneous Financial Expenses"]
[40]
[41]
[42,"Total Account 6890",null,null,null,null,{"$f":"SUM(G66:H67)","v":0}]

{"sheet":"Revenue-CF Sp Rent Inc,FMTW,MHP","index":9,"n_rows":61,"n_cols":8,"rows_kept":61,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,1,1],[1,3,1,4],[2,0,4,0],[2,1,4,2],[2,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[51,6,51,7],[51,1,51,5],[38,1,38,2],[39,1,39,2],[42,1,42,2],[44,0,44,7],[45,0,45,3],[45,4,46,7],[46,0,46,3],[48,0,49,0],[48,1,48,5],[48,6,48,7],[49,1,49,7],[50,6,50,7],[50,1,50,5],[60,1,60,5],[60,6,60,7],[52,1,52,5],[52,6,52,7],[53,1,53,7],[54,6,54,7],[55,6,55,7],[56,1,56,5],[56,6,56,7],[54,1,54,5],[55,1,55,5],[58,1,58,5],[59,1,59,5],[57,1,57,7],[58,6,58,7],[59,6,59,7]]}
["PROPOSED REVENUE, MANDATORY DEBT AND RESERVE DEPOSITS - Operating Budget\nUse this form for Special Rent Increase (MHP) and Families Moving to Work Original Program Funding"]
["Total Units:",null,{"$f":"'Operating Budget'!C2","v":0},"Assisted Units:",null,{"$f":"'Operating Budget'!F2","v":0},"Proration %:",{"$f":"'Operating Budget'!J2","v":0}]
["Line #","Account Name",null,"Account\nCode","(A)","(B)","(C)","(D)"]
[null,null,null,null,"Assisted\nUnits","Non-Assisted\nUnits","Commercial\nProposed","Total Project"]
[]
[null,"Rent Revenue: *See instructions below for lines 1-3"]
[1,"Rent Revenue - Gross Potential",null,5120,0,0,null,{"$f":"SUM(E7:G7)","v":0}]
[2,"Tenant Assistance Payments",null,5121,0,0,null,{"$f":"SUM(E8:G8)","v":0}]
[3,"Rent Revenue - Stores and Commercial",null,5140,null,null,0,{"$f":"SUM(E9:G9)","v":0}]
[4,"Garage and Parking Spaces",null,5170,0,0,0,{"$f":"SUM(E10:G10)","v":0}]
[5,"Flexible Subsidy Revenue",null,5180,0,0,0,{"$f":"SUM(E11:G11)","v":0}]
[6,"Miscellaneous Rent Revenue",null,5190,{"$f":"(H12-G12)*$H$2","v":0},{"$f":"H12-E12-G12","v":0},0,{"$f":"G53","v":0}]
[7,"Total Rent Revenue",null,"5100T",{"$f":"SUM(E7:E12)","v":0},{"$f":"SUM(F7:F12)","v":0},{"$f":"SUM(G7:G12)","v":0},{"$f":"SUM(H7:H12)","v":0}]
[null,"Vacancies:"]
[8,"Vacancy %",null,null,0,0,0]
[9,"Apartments",null,5220,{"$f":"E7*E15","v":0},{"$f":"F7*F15","v":0},null,{"$f":"SUM(E16:G16)","v":0}]
[10,"Stores and Commercial",null,5240,null,null,{"$f":"G9*G15","v":0},{"$f":"SUM(E17:G17)","v":0}]
[11,"Rental Concessions",null,5250,0,0,0,{"$f":"SUM(E18:G18)","v":0}]
[12,"Garage and Parking Spaces",null,5270,0,0,0,{"$f":"SUM(E19:G19)","v":0}]
[13,"Miscellaneous Vacancies",null,5290,0,0,0,{"$f":"SUM(E20:G20)","v":0}]
[14,"Total Vacancies",null,"5200T",{"$f":"SUM(E16:E20)","v":0},{"$f":"SUM(F16:F20)","v":0},{"$f":"SUM(G16:G20)","v":0},{"$f":"SUM(H16:H20)","v":0}]
[15,"Net Rental Revenues (Rent Revenue Less Vacancies)",null,"5152N",{"$f":"E13-E21","v":0},{"$f":"F13-F21","v":0},{"$f":"G13-G21","v":0},{"$f":"H13-H21","v":0}]
[null,"Other Revenue:"]
[16,"Laundry and Vending Revenue",null,5910,{"$f":"(H24-G24)*$H$2","v":0},{"$f":"H24-E24-G24","v":0},0,0]
[17,"Tenant Charges",null,5920,{"$f":"(H25-G25)*$H$2","v":0},{"$f":"H25-E25-G25","v":0},0,0]
[18,"Miscellaneous Revenue",null,5990,{"$f":"(H26-G26)*$H$2","v":0},{"$f":"H26-E26-G26","v":0},0,{"$f":"G57","v":0}]
[19,"Total Other Revenue",null,"5900T",{"$f":"SUM(E24:E26)","v":0},{"$f":"SUM(F24:F26)","v":0},{"$f":"SUM(G24:G26)","v":0},{"$f":"SUM(H24:H26)","v":0}]
[20,"Total Revenue",null,"5000T",{"$f":"E22+E27","v":0},{"$f":"F22+F27","v":0},{"$f":"G22+G27","v":0},{"$f":"H22+H27","v":0}]
[null,"Financial Expenses including mandatory debt service:"]
[21,"1st Mortgage (P&I)",null,6820,{"$f":"(H30-G30)*$H$2","v":0},{"$f":"H30-E30-G30","v":0},0,0]
[22,"2nd Mortgage (P&I)",null,6825,0,0,0,0]
[23,"3rd Mortgage (P&I)",null,6825,0,0,0,0]
[24,"HCD Required Payments",null,6825,0,0,0,0]
[25,"Lease Payment",null,6890,0,0,0,0]
[26,"Miscellaneous Financial Expenses",null,6890,0,0,0,{"$f":"G61","v":0}]
[27,"Total Financial Expenses",null,"6800T",{"$f":"SUM(E30:E35)","v":0},{"$f":"SUM(F30:F35)","v":0},{"$f":"SUM(G30:G35)","v":0},{"$f":"SUM(H30:H35)","v":0}]
[null,"Reserves Deposits:"]
[28,"Replacement Reserve - Deposit",null,1320,{"$f":"(H38-G38)*$H$2","v":0},{"$f":"H38-E38-G38","v":0},0,0]
[29,"Operating Reserve - Deposit",null,1330,{"$f":"(H39-G39)*$H$2","v":0},{"$f":"H39-E39-G39","v":0},0,0]
[30,"Transition Reserve  - Deposit",null,1330,{"$f":"(H40-G40)*$H$2","v":0},{"$f":"H40-E40-G40","v":0},0,0]
[31,"Other (specify)",null,1330,{"$f":"(H41-G41)*$H$2","v":0},{"$f":"H41-E41-G41","v":0},0,0]
[32,"Other (specify)",null,1330,{"$f":"(H42-G42)*$H$2","v":0},{"$f":"H42-E42-G42","v":0},0,0]
[33,"Total Reserves Deposits",null,"1300T",{"$f":"SUM(E38:E42)","v":0},{"$f":"SUM(F38:F42)","v":0},{"$f":"SUM(G38:G42)","v":0},{"$f":"SUM(H38:H42)","v":0}]
[]
["*Click on the link below to complete the applicable Schedule of Rental Income (SRI). The applicable completed SRI must be attached to this application as Exhibit A. It serves as the source document for Revenues in lines 1-3 above. Please make sure the Revenues on this worksheet match what is reported in the SRI."]
["- Requesting a Special Rent Increase; or",null,null,null,"http://www.hcd.ca.gov/fa/amc/mhp_rentincsched.xlsm"]
["- Families Moving to Work (FMTW) original program funding"]
[]
["Item #","For each account below, itemize the revenues (total will flow to account above)",null,null,null,null,"Amount"]
[null,"Account 5190 Miscellaneous Rent Revenue"]
[34]
[35]
[36,"Total Account 5190",null,null,null,null,{"$f":"SUM(G51:H52)","v":0}]
[null,"Account 5990 Miscellaneous Revenue"]
[37]
[38]
[39,"Total Account 5990",null,null,null,null,{"$f":"SUM(G55:H56)","v":0}]
[null,"Account 6890 Miscellaneous Financial Expenses"]
[40]
[41]
[42,"Total Account 6890",null,null,null,null,{"$f":"SUM(G59:H60)","v":0}]

{"sheet":"Proforma - non FMTW, MHP","index":10,"n_rows":72,"n_cols":32,"rows_kept":72,"cut":false,"hidden":false,"merged":[[0,0,0,14],[65,0,65,21],[0,15,0,16],[0,17,0,21],[62,0,62,7],[63,0,63,7]]}
["Cash Flow Pro-Forma - use this form if Original Program funding was CHRP-R, SUHRP, SERA, RHCP-O, CALDAP, DPRLP, FHDP, or RHCP-B)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Name:",null,{"$f":"'General Summary'!C6","v":0}]
[{"$f":"'General Summary'!I5","v":"(Version 7/18/17)"},"Growth Factor","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20","Year 21","Year 22","Year 23","Year 24","Year 25","Year 26","Year 27","Year 28","Year 29","Year 30"]
["TOTAL OPERATING REVENUE"]
["Rent Revenue - Assisted Units",2.5000000000000001E-2,0,{"$f":"C4*($B$4+1)","v":0},0,0,{"$f":"F4*($B$4+1)","v":0},{"$f":"G4*($B$4+1)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"Q4*($B$4+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Rent Revenue - Non-Assisted",2.5000000000000001E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Tenant Assistance Payments",2.5000000000000001E-2,0,{"$f":"C6*($B$6+1)","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]
["Rent Revenue - Commercial",2.5000000000000001E-2,0,{"$f":"C7*($B$7+1)","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]
["Garage and Parking Spaces",2.5000000000000001E-2,0,{"$f":"C8*($B$7+1)","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]
["Flexible Subsidy Revenue",2.5000000000000001E-2,0,{"$f":"C9*($B$7+1)","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]
["Miscellaneous Rent Revenue-provide detail below",2.5000000000000001E-2,0,{"$f":"C10*($B$7+1)","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]
["TOTAL RENTAL REVENUE",null,{"$f":"SUM(C4:C10)","v":0},{"$f":"SUM(D4:D10)","v":0},{"$f":"SUM(E4:E10)","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]
["Vacancy - Assisted Units",0.05,{"$f":"IF(B12=0,0,(C4*$B$12))","v":0},{"$f":"IF(C12=0,0,(D4*$B$12))","v":0},{"$f":"IF(D12=0,0,(E4*$B$12))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(V12=0,0,(W11-W24-W7)*$B$12)","v":0},0,0,0,0,0,0,0,0,0]
["Vacancy - Non-Assisted Units",0.05,{"$f":"IF(B13=0,0,(C5*$B$13))","v":0},{"$f":"IF(C13=0,0,(D5*$B$13))","v":0},{"$f":"IF(D13=0,0,(E5*$B$13))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(V13=0,0,(W12-W11-W8)*$B$12)","v":0},0,0,0,0,0,0,0,0,0]
["Vacancy - Commercial",0.5,{"$f":"IF(B14=0,0,(C7*$B$14))","v":0},{"$f":"IF(C14=0,0,(D7*$B$14))","v":0},{"$f":"IF(D14=0,0,(E7*$B$14))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(V14=0,0,(W5*$B$17))","v":0},0,0,0,0,0,0,0,0,0]
["Rental Concessions",2.5000000000000001E-2,0,{"$f":"C15*($B$15+1)","v":0},{"$f":"D15*($B$15+1)","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]
["Vacancy - Garage and Parking",0.05,{"$f":"IF(B16=0,0,(C8*$B$16))","v":0},{"$f":"IF(C16=0,0,(D8*$B$16))","v":0},{"$f":"IF(D16=0,0,(E8*$B$16))","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]
["Miscellaneous Vacancies",0.05,{"$f":"IF(B17=0,0,(C10*$B$17))","v":0},{"$f":"IF(C17=0,0,(D10*$B$17))","v":0},{"$f":"IF(D17=0,0,(E10*$B$17))","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]
["TOTAL VACANCIES",null,{"$f":"SUM(C12:C17)","v":0},{"$f":"SUM(D12:D17)","v":0},{"$f":"SUM(E12:E17)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"W24-W11-W16","v":0},0,0,0,0,0,0,0,0,0]
["TOTAL NET RENTAL REVENUE",null,{"$f":"C11-C18","v":0},{"$f":"D11-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]
["Laundry and Vending Revenue",2.5000000000000001E-2,0,{"$f":"C20*($B$20+1)","v":0},{"$f":"D20*($B$20+1)","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]
["Tenant Charges",2.5000000000000001E-2,0,{"$f":"C21*($B$21+1)","v":0},{"$f":"D21*($B$21+1)","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]
["Misc Revenue-provide detail below",2.5000000000000001E-2,0,{"$f":"C22*($B$22+1)","v":0},{"$f":"D22*($B$22+1)","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]
["TOTAL OTHER REVENUE",null,{"$f":"SUM(C20:C22)","v":0},{"$f":"SUM(D20:D22)","v":0},{"$f":"SUM(E20:E22)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"W15-W16-W21","v":0},0,0,0,0,0,0,0,0,0]
["Transition/Operating Reserve",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTAL REVENUE",null,{"$f":"C19+C23+C24","v":0},{"$f":"D19+D23+D24","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]
["OP EXP & RESERVE DEP."]
["Total Op Exp. w/o RE taxes",3.5000000000000003E-2,{"$f":"'Operating Budget'!J56-'Operating Budget'!J45","v":0},{"$f":"C27*(1+$B$27)","v":0},{"$f":"D27*(1+$B$27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q27*(1+$B$27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Real Estate Taxes",0.02,{"$f":"'Operating Budget'!J45","v":0},{"$f":"C28*($B$28+1)","v":0},{"$f":"D28*($B$28+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q28*($B$28+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Replacement Reserve-Deposit",null,0,{"$f":"C29","v":0},{"$f":"D29","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"V29*($B$29+1)","v":0},0,0,0,0,0,0,0,0,0]
["Operating Reserve-Deposit",null,0,{"$f":"C30","v":0},{"$f":"D30","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"V30*($B$30+1)","v":0},0,0,0,0,0,0,0,0,0]
["Transition Reserve-Deposit",null,0,{"$f":"C31","v":0},{"$f":"D31","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"V31*($B$30+1)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,0,{"$f":"C32","v":0},{"$f":"D32","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"V32*($B$32+1)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,0,{"$f":"C33","v":0},{"$f":"D33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"V33*($B$33+1)","v":0},0,0,0,0,0,0,0,0,0]
["TOTAL OP EXP & RES. DEP.",null,{"$f":"SUM(C27:C33)","v":0},{"$f":"SUM(D27:D33)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R27:R33)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["NET OPERATING INCOME",null,{"$f":"C25-C34","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]
["FINANCIAL EXP. INC. MAND. DEBT","Senior Debt"]
[null,"No",0,{"$f":"C37","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q37","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,{"$f":"C38","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q38","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,{"$f":"C39","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q39","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["HCD Monitoring Fee",2.5000000000000001E-2,{"$f":"IF($B$61=\"Above\",C61,0)","v":0},{"$f":"IF($B$61=\"Above\",D61,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]
["Lease Payment",null,0,{"$f":"C41","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]
["Misc Fin. Exp-provide detail below",null,0,{"$f":"C42","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Q42","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTAL FINANCIAL EXPENSES",null,{"$f":"SUM(C37:C42)","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]
["DEBT SERVICE COVERAGE",null,{"$f":"IF(C43=0,0,C35/C43)","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]
["AVAILABLE CASH FLOW",null,{"$f":"C35-C43","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]
["HCD Monitoring Fee",2.5000000000000001E-2,{"$f":"IF($B$61=\"Below\",IF(C45<1,0,C69+C70+C72),0)","v":0},{"$f":"IF($B$61=\"Below\",IF(D45<1,0,D69+D70+D72),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]
["Asset Mgmt. + Similar Fees",null,{"$f":"IF(C45-46<0,0,IF(C45-C46<=C62,C45-C46,C62))","v":0},{"$f":"IF(D45-46<0,0,IF(D45-D46<=D62,D45-D46,D62))","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]
["Deferred Developer Fee",null,{"$f":"IF(C45-C46-C47<0,0,IF(C45-C46-C47<=$I$63,C45-C46-C47,$I$63))","v":0},{"$f":"IF(D45-D46-D47<0,0,IF(D45-D46-D47<=$I$63,D45-D46-D47,$I$63))","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]
["CASH AVAILABLE FOR RR & DIST",null,{"$f":"C45-C46-C47-C48","v":0},{"$f":"D45-D46-D47-D48","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"V45-V46-V47-V48","v":0},{"$f":"W45-W46-W47-W48","v":0},{"$f":"X45-X46-X47-X48","v":0},{"$f":"Y45-Y46-Y47-Y48","v":0},{"$f":"Z45-Z46-Z47-Z48","v":0},{"$f":"AA45-AA46-AA47-AA48","v":0},{"$f":"AB45-AB46-AB47-AB48","v":0},{"$f":"AC45-AC46-AC47-AC48","v":0},{"$f":"AD45-AD46-AD47-AD48","v":0},{"$f":"AE45-AE46-AE47-AE48","v":0},{"$f":"AF45-AF46-AF47-AF48","v":0}]
["Sponsor Distributions",0.5,{"$f":"IF(C49<1,0,C49*$B$50)","v":0},{"$f":"IF(D49<1,0,D49*$B$50)","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]
["HCD Residual Payment",0,{"$f":"IF(C49<1,0,C49*$B$51)","v":0},{"$f":"IF(D49<1,0,D49*$B$51)","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('Funding Sources'!J36=\"Residual Receipts\",'Funding Sources'!B36,\"Residual Payment\")","v":"Residual Payment"},0,{"$f":"IF(C49<1,0,C49*$B$52)","v":0},{"$f":"IF(D49<1,0,D49*$B$52)","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('Funding Sources'!J37=\"Residual Receipts\",'Funding Sources'!B37,\"Residual Payment\")","v":"Residual Payment"},0,{"$f":"IF(C49<1,0,C49*$B$53)","v":0},{"$f":"IF(D49<1,0,D49*$B$53)","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('Funding Sources'!J38=\"Residual Receipts\",'Funding Sources'!B38,\"Residual Payment\")","v":"Residual Payment"},0,{"$f":"IF(C49<1,0,C49*$B$54)","v":0},{"$f":"IF(D49<1,0,D49*$B$54)","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('Funding Sources'!J39=\"Residual Receipts\",'Funding Sources'!B39,\"Residual Payment\")","v":"Residual Payment"},0,{"$f":"IF(C49<1,0,C49*$B$55)","v":0},{"$f":"IF(D49<1,0,D49*$B$55)","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('Funding Sources'!J40=\"Residual Receipts\",'Funding Sources'!B40,\"Residual Payment\")","v":"Residual Payment"},0,{"$f":"IF(C49<1,0,C49*$B$56)","v":0},{"$f":"IF(D49<1,0,D49*$B$56)","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('Funding Sources'!J41=\"Residual Receipts\",'Funding Sources'!B41,\"Residual Payment\")","v":"Residual Payment"},0,{"$f":"IF(C49<1,0,C49*$B$57)","v":0},{"$f":"IF(D49<1,0,D49*$B$57)","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('Funding Sources'!J44=\"Residual Receipts\",'Funding Sources'!B44,\"Residual Payment\")","v":"Residual Payment"},0,{"$f":"IF(C49<1,0,C49*$B$58)","v":0},{"$f":"IF(D49<1,0,D49*$B$58)","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]
["12% of Operating Expenses",null,{"$f":"(C27+C28)*0.12","v":0}]
["Cumulative Paid Deferred Fee",null,{"$f":"C48","v":0},{"$f":"D48+C60","v":0},{"$f":"E48+D60","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]
["HCD Monitoring Fee","Above",0,{"$f":"C61*1.025","v":0},{"$f":"D61*1.025","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]
["Max Asset Mgmt+Similar Fees",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Enter Total Deferred Developer Fee budgeted for payment prior to distributions and residual receipt payments:",null,null,null,null,null,null,null,0]
["Enter Total Deferred Developer Fee budgeted for payment from Distributions:",null,null,null,null,null,null,null,0]
["Comments and Miscellaneous Revenue/Expense Detail:"]
[]
["Available Cash Flow ",null,{"$f":"C45","v":0},{"$f":"D45","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]
["HCD Monitoring Fee",null,{"$f":"C61","v":0},{"$f":"D61","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]
["Monitoring Fee - if senior debt",{"$f":"IF(OR(B37=\"Yes\",B38=\"Yes\",B39=\"Yes\"),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND($B$61=\"Below\",$B$69=\"Yes\"),IF(C68<C67,C68,IF(C67<0,0,C67)),0)","v":0},{"$f":"IF(AND($B$61=\"Below\",$B$69=\"Yes\"),IF(D68<D67,D68,IF(D67<0,0,D67)),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]
["Lesser of 50% of fee or CF 113(h)(1)",null,{"$f":"IF(OR($B$69=\"Yes\",C67<1),0,IF(C67>(C68*0.5),C68*0.5,C67))","v":0},{"$f":"IF(OR($B$69=\"Yes\",D67<1),0,IF(D67>(D68*0.5),D68*0.5,D67))","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]
["Available Cash Flow ",null,{"$f":"C67-C69-C70","v":0},{"$f":"D67-D69-D70","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]
["50% of Available Cash Flow 113(h)((2)",null,{"$f":"IF($B$69=\"Yes\",0,IF(C71<1,0,MIN(C71*0.5,C68-C70)))","v":0},{"$f":"IF($B$69=\"Yes\",0,IF(D71<1,0,MIN(D71*0.5,D68-D70)))","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]

{"sheet":"Proforma - Sp Rent Inc,FMTW,MHP","index":11,"n_rows":72,"n_cols":32,"rows_kept":72,"cut":false,"hidden":false,"merged":[[65,0,65,21],[0,0,0,11],[0,12,0,13],[0,14,0,18],[62,0,62,7],[63,0,63,7]]}
["Cash Flow Pro-Forma - use this form for Special Rent Increase (MHP) and Families Moving to Work Original Program Funding",null,null,null,null,null,null,null,null,null,null,null,"Project Name:",null,{"$f":"'General Summary'!C6","v":0}]
[{"$f":"'General Summary'!I5","v":"(Version 7/18/17)"},"Growth Factor","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20","Year 21","Year 22","Year 23","Year 24","Year 25","Year 26","Year 27","Year 28","Year 29","Year 30"]
["TOTAL OPERATING REVENUE"]
["Rent Revenue - Assisted Units",2.5000000000000001E-2,0,0,0,0,0,{"$f":"G4*($B$4+1)","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]
["Rent Revenue - Non-Assisted",2.5000000000000001E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Tenant Assistance Payments",2.5000000000000001E-2,0,{"$f":"C6*($B$6+1)","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]
["Rent Revenue - Commercial",2.5000000000000001E-2,0,{"$f":"C7*($B$7+1)","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]
["Garage and Parking Spaces",2.5000000000000001E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Flexible Subsidy Revenue",2.5000000000000001E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Miscellaneous Rent Revenue-provide detail below",2.5000000000000001E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTAL RENTAL REVENUE",null,{"$f":"SUM(C4:C10)","v":0},{"$f":"SUM(D4:D10)","v":0},{"$f":"SUM(E4:E10)","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]
["Vacancy - Assisted Units",0.05,{"$f":"C4*$B$12","v":0},{"$f":"IF(C12=0,0,(D4*$B$12))","v":0},{"$f":"IF(D12=0,0,(E4*$B$12))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(V12=0,0,(W11-W24-W7)*$B$12)","v":0},0,0,0,0,0,0,0,0,0]
["Vacancy - Non-Assisted Units",0.05,{"$f":"C5*$B$13","v":0},{"$f":"IF(C13=0,0,(D5*$B$13))","v":0},{"$f":"IF(D13=0,0,(E5*$B$13))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(V13=0,0,(W12-W11-W8)*$B$12)","v":0},0,0,0,0,0,0,0,0,0]
["Vacancy - Commercial",0.5,{"$f":"C7*$B$14","v":0},{"$f":"IF(C14=0,0,(D7*$B$14))","v":0},{"$f":"IF(D14=0,0,(E7*$B$14))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(V14=0,0,(W5*$B$17))","v":0},0,0,0,0,0,0,0,0,0]
["Rental Concessions",2.5000000000000001E-2,0,{"$f":"C15*($B$15+1)","v":0},{"$f":"D15*($B$15+1)","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]
["Vacancy - Garage and Parking",0.05,{"$f":"C8*$B$16","v":0},{"$f":"IF(C16=0,0,(D8*$B$16))","v":0},{"$f":"IF(D16=0,0,(E8*$B$16))","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]
["Miscellaneous Vacancies",0.05,{"$f":"C10*$B$17","v":0},{"$f":"IF(C17=0,0,(D10*$B$17))","v":0},{"$f":"IF(D17=0,0,(E10*$B$17))","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]
["TOTAL VACANCIES",null,{"$f":"SUM(C12:C17)","v":0},{"$f":"SUM(D12:D17)","v":0},{"$f":"SUM(E12:E17)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"W24-W11-W16","v":0},0,0,0,0,0,0,0,0,0]
["TOTAL NET RENTAL REVENUE",null,{"$f":"C11-C18","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]
["Laundry and Vending Revenue",2.5000000000000001E-2,0,{"$f":"C20*($B$20+1)","v":0},{"$f":"D20*($B$20+1)","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]
["Tenant Charges",2.5000000000000001E-2,0,{"$f":"C21*($B$21+1)","v":0},{"$f":"D21*($B$21+1)","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]
["Misc Revenue-provide detail below",2.5000000000000001E-2,0,{"$f":"C22*($B$22+1)","v":0},{"$f":"D22*($B$22+1)","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]
["TOTAL OTHER REVENUE",null,{"$f":"SUM(C20:C22)","v":0},{"$f":"SUM(D20:D22)","v":0},{"$f":"SUM(E20:E22)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"W15-W16-W21","v":0},0,0,0,0,0,0,0,0,0]
["Transition/Operating Reserve",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTAL REVENUE",null,{"$f":"C19+C23+C24","v":0},{"$f":"D19+D23+D24","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]
["OP EXP & RESERVE DEP."]
["Total Op Exp. w/o RE taxes",3.5000000000000003E-2,{"$f":"'Operating Budget'!J56-'Operating Budget'!J45","v":0},{"$f":"C27*(1+$B$27)","v":0},{"$f":"D27*(1+$B$27)","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]
["Real Estate Taxes",0.02,{"$f":"'Operating Budget'!J45","v":0},{"$f":"C28*($B$28+1)","v":0},{"$f":"D28*($B$28+1)","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]
["Replacement Reserve-Deposit",null,0,{"$f":"C29","v":0},{"$f":"D29","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"V29*($B$29+1)","v":0},0,0,0,0,0,0,0,0,0]
["Operating Reserve-Deposit",null,0,{"$f":"C30","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"V30*($B$30+1)","v":0},0,0,0,0,0,0,0,0,0]
["Transition Reserve-Deposit",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"V31*($B$30+1)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,0,{"$f":"C32","v":0},{"$f":"D32","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"V32*($B$32+1)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,0,{"$f":"C33","v":0},{"$f":"D33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"V33*($B$33+1)","v":0},0,0,0,0,0,0,0,0,0]
["TOTAL OP EXP & RES. DEP.",null,{"$f":"SUM(C27:C33)","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]
["NET OPERATING INCOME",null,{"$f":"C25-C34","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]
["FINANCIAL EXP. INC. MAND. DEBT","Senior Debt"]
[null,"Yes",0,{"$f":"C37","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,0,0,0,0,0,0,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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["HCD Monitoring Fee",2.5000000000000001E-2,{"$f":"IF($B$61=\"Above\",C61,0)","v":0},{"$f":"IF($B$61=\"Above\",D61,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]
["Lease Payment",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Misc Fin. Exp-provide detail below",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTAL FINANCIAL EXPENSES",null,{"$f":"SUM(C37:C42)","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]
["DEBT SERVICE COVERAGE",null,{"$f":"IF(C43=0,0,C35/C43)","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]
["AVAILABLE CASH FLOW",null,{"$f":"C35-C43","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]
["HCD Monitoring Fee",2.5000000000000001E-2,{"$f":"IF($B$61=\"Below\",IF(C45<1,0,C69+C70+C72),0)","v":0},{"$f":"IF($B$61=\"Below\",IF(D45<1,0,D69+D70+D72),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]
["Asset Mgmt. + Similar Fees",null,{"$f":"IF(C45-46<0,0,IF(C45-C46<=C62,C45-C46,C62))","v":0},{"$f":"IF(D45-46<0,0,IF(D45-D46<=D62,D45-D46,D62))","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]
["Deferred Developer Fee",null,{"$f":"IF(C45-C46-C47<0,0,IF(C45-C46-C47<=$I$63,C45-C46-C47,$I$63))","v":0},{"$f":"IF(D45-D46-D47<0,0,IF(D45-D46-D47<=$I$63,D45-D46-D47,$I$63))","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]
["CASH AVAILABLE FOR RR & DIST",null,{"$f":"C45-C46-C47-C48","v":0},{"$f":"D45-D46-D47-D48","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]
["Sponsor Distributions",0.5,{"$f":"IF(C49<1,0,C49*$B$50)","v":0},{"$f":"IF(D49<1,0,D49*$B$50)","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]
["HCD Residual Payment",0,{"$f":"IF(C49<1,0,C49*$B$51)","v":0},{"$f":"IF(D49<1,0,D49*$B$51)","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('Funding Sources'!J36=\"Residual Receipts\",'Funding Sources'!B36,\"Residual Payment\")","v":"Residual Payment"},0,{"$f":"IF(C49<1,0,C49*$B$52)","v":0},{"$f":"IF(D49<1,0,D49*$B$52)","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('Funding Sources'!J37=\"Residual Receipts\",'Funding Sources'!B37,\"Residual Payment\")","v":"Residual Payment"},0,{"$f":"IF(C49<1,0,C49*$B$53)","v":0},{"$f":"IF(D49<1,0,D49*$B$53)","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('Funding Sources'!J38=\"Residual Receipts\",'Funding Sources'!B38,\"Residual Payment\")","v":"Residual Payment"},0,{"$f":"IF(C49<1,0,C49*$B$54)","v":0},{"$f":"IF(D49<1,0,D49*$B$54)","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('Funding Sources'!J39=\"Residual Receipts\",'Funding Sources'!B39,\"Residual Payment\")","v":"Residual Payment"},0,{"$f":"IF(C49<1,0,C49*$B$55)","v":0},{"$f":"IF(D49<1,0,D49*$B$55)","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('Funding Sources'!J40=\"Residual Receipts\",'Funding Sources'!B40,\"Residual Payment\")","v":"Residual Payment"},0,{"$f":"IF(C49<1,0,C49*$B$56)","v":0},{"$f":"IF(D49<1,0,D49*$B$56)","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('Funding Sources'!J41=\"Residual Receipts\",'Funding Sources'!B41,\"Residual Payment\")","v":"Residual Payment"},0,{"$f":"IF(C49<1,0,C49*$B$57)","v":0},{"$f":"IF(D49<1,0,D49*$B$57)","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('Funding Sources'!J44=\"Residual Receipts\",'Funding Sources'!B44,\"Residual Payment\")","v":"Residual Payment"},0,{"$f":"IF(C49<1,0,C49*$B$58)","v":0},{"$f":"IF(D49<1,0,D49*$B$58)","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]
["12% of Operating Expenses",null,{"$f":"(C27+C28)*0.12","v":0}]
["Cumulative Paid Deferred Fee",null,{"$f":"C48","v":0},{"$f":"D48+C60","v":0},{"$f":"E48+D60","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]
["HCD Monitoring Fee","Above",0,{"$f":"C61*1.025","v":0},{"$f":"D61*1.025","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]
["Max Asset Mgmt+Similar Fees",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Enter Total Deferred Developer Fee budgeted for payment prior to distributions and residual receipt payments:",null,null,null,null,null,null,null,0]
["Enter Total Deferred Developer Fee budgeted for payment from Distributions:",null,null,null,null,null,null,null,0]
["Comments and Miscellaneous Revenue/Expense Detail:"]
[]
["Available Cash Flow ",null,{"$f":"C45","v":0},{"$f":"D45","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]
["HCD Monitoring Fee",null,{"$f":"C61","v":0},{"$f":"D61","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]
["Monitoring Fee - if senior debt",{"$f":"IF(OR(B37=\"Yes\",B38=\"Yes\",B39=\"Yes\"),\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(AND($B$61=\"Below\",$B$69=\"Yes\"),IF(C68<C67,C68,IF(C67<0,0,C67)),0)","v":0},{"$f":"IF(AND($B$61=\"Below\",$B$69=\"Yes\"),IF(D68<D67,D68,IF(D67<0,0,D67)),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]
["Lesser of 50% of fee or CF 113(h)(1)",null,{"$f":"IF(OR($B$69=\"Yes\",C67<1),0,IF(C67>(C68*0.5),C68*0.5,C67))","v":0},{"$f":"IF(OR($B$69=\"Yes\",D67<1),0,IF(D67>(D68*0.5),D68*0.5,D67))","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]
["Available Cash Flow ",null,{"$f":"C67-C69-C70","v":0},{"$f":"D67-D69-D70","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]
["50% of Available Cash Flow 113(h)((2)",null,{"$f":"IF($B$69=\"Yes\",0,IF(C71<1,0,MIN(C71*0.5,C68-C70)))","v":0},{"$f":"IF($B$69=\"Yes\",0,IF(D71<1,0,MIN(D71*0.5,D68-D70)))","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]

{"sheet":"Remaining Useful Life","index":12,"n_rows":44,"n_cols":5,"rows_kept":44,"cut":false,"hidden":false,"merged":[[3,1,3,4],[41,0,41,3],[10,0,10,3],[12,0,12,4],[15,0,15,3],[16,0,16,3],[17,0,17,4],[24,0,24,4],[9,0,9,3],[4,0,4,4],[36,0,36,3],[37,0,37,3],[0,0,0,4],[38,0,38,4],[1,0,1,4],[11,0,11,4],[25,0,25,4],[28,0,28,3],[5,0,5,3],[6,0,6,3],[7,0,7,3],[8,0,8,3],[2,1,2,3],[26,0,26,3],[27,0,27,3],[18,0,18,4],[22,0,22,3],[23,0,23,3],[42,2,43,2],[42,3,43,4],[13,0,13,3],[14,0,14,3],[19,0,19,3],[20,0,20,3],[21,0,21,3],[35,0,35,4],[34,0,34,4],[29,0,29,3],[31,0,31,3],[32,0,32,3],[30,0,30,3],[33,0,33,3],[39,0,39,4],[40,0,40,1]]}
["Remaining Useful Life - in lieu of  Physical Needs Assessment if no rehab proposed."]
["For any box checked \"No\" explain the noncompliance in the yellow shaded box below the corresponding section."]
["Project Name:",{"$f":"'General Summary'!C6","v":0},null,null,{"$f":"'General Summary'!I5","v":"(Version 7/18/17)"}]
["Property Address:"]
["BUILDING/ARCHITECTURE (for any box checked \"No\" explain the noncompliance in the yellow shaded box below)"]
["Premises - no infestation of insects or vermin, free of standing water or improper drainage that has or will affect the property condition "]
["Exterior Walls - in good condition, no holes, missing sections, defective product(s) that need(s) replacement or signs of deterioration"]
["Vent Screens - no missing or damaged crawl space, attic or foundation vent screens"]
["Stairway/landing/treads/risers/guardrails/handrails - in good conditions, well secured, not loose or deteriorated"]
["Roofs - in good condition without any leaks"]
["Foundation - no major cracks, crumbling sections or supports significantly out of alignment "]
[]
["MECHANICAL/ELECTRICAL (for any box checked \"No\" explain the noncompliance in the yellow shaded box below)"]
["Exterior Lighting - no exposed wiring, disrepair that, may cause a safety issue, or, jeopardize the general condition of the property"]
["Electrical Panel - all breakers/fuses are labeled, in working condition, and there is no exposed wiring "]
["HVAC - heaters/cooling units are premanently installed and properly functioning"]
["Water Heaters - water heaters are installed in an approved location, and have seismic strapping, operable temperature relief valve and drain line, venting, and a minimum 120 degrees water temperature"]
[]
["SITE (CONDITION/SYSTEMS) (for any box checked \"No\" explain the noncompliance in the yellow shaded box below)"]
["Retaining Walls - in good condition, secure, sound, and adequately designed to serve intended purpose"]
["Fencing - on site fencing is in good condition and free from any conditions that could pose a safety hazard "]
["Common Areas - in a safe and sanitary condition"]
["Parking Lot - asphalt/gravel (applicable) in good condition "]
["Plumbing/piping - properly installed and in good conditions without any leaks or clogs "]
[]
["DWELLING UNITS (for any box checked \"No\" explain the noncompliance in the yellow shaded box below)"]
["Ceilings - in good conditions/no evidence of water stains to indicate leaks "]
["Entry Doors - all doors and door jambs have strike plates that are secure, not loose; entry doors have a standard deadbolt with thumb latch at interior, a viewer, and are weather sealed"]
["Window and Window locks - windows can be opened and closed easily, and have no missing or broken glazing - no condition present to cause safety hazard"]
["Kitchen counters and sink surfaces - surfaces are in good condition, no significant cracked, chipped or missing pieces"]
["Floor Coverings - coverings do not create tripping hazards or unsanitary conditions "]
["Interior Plumbing/piping - properly installed and in good conditions without any leaks or clogs "]
["Smoke Detectors - smoke detectors are in working condition "]
["Electrical - in good condition, no exposed wiring"]
[]
["FUNDS FOR MAINTENANCE & CAPITAL NEEDS"]
["Operating Budget - includes sufficient amounts for routine maintenance and repairs"]
["Replacement Reserves - account balance and annual deposits include sufficient amounts to pay for capital needs when such needs are anticipated to occur for the remaining useful life of the project"]
["According to the LPR Program Guidelines, Section 101(g) and Section 102(b), HCD may require additional information from the Borrower or independent third parties, as necessary to adequately determine the Remaining Useful Life. "]
["CERTIFICATION"]
["Sponsor's Determination of Property's Remaining Useful Life (years):",null,null,"Date:"]
["I certify I have inspected this property and the information presented in the Property Useful Life Evaluation Checklist and Property Useful Life Descriptions is true and correct to the best of my knowledge:"]
["Name of Preparer:",null,"Title of Preparer:"]
["Name of CEO:"]

{"sheet":"Reserves","index":13,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[[53,0,53,10],[38,0,38,10],[48,1,48,8],[49,1,49,8],[50,1,50,8],[51,1,51,8],[52,0,52,10],[40,1,40,9],[41,1,41,9],[42,1,42,10],[43,1,43,8],[44,1,44,8],[47,1,47,8],[39,0,39,10],[45,1,45,8],[46,1,46,8],[35,1,35,7],[35,9,36,10],[36,1,36,7],[37,9,37,10],[37,1,37,8],[34,1,34,10],[28,1,28,10],[29,1,29,7],[29,9,29,10],[30,1,30,7],[30,9,30,10],[31,9,32,10],[32,3,32,4],[32,5,32,7],[33,1,33,8],[33,9,33,10],[31,0,32,0],[31,1,32,2],[31,3,31,4],[31,5,31,7],[31,8,32,8],[27,0,27,10],[19,0,19,3],[19,5,19,9],[20,5,20,9],[21,0,21,10],[22,0,22,2],[22,4,22,7],[22,8,22,9],[23,0,23,3],[23,5,23,9],[24,5,24,9],[25,0,25,10],[26,0,26,10],[18,0,18,2],[18,4,18,7],[18,8,18,9],[11,0,11,3],[11,5,11,9],[12,0,12,3],[12,5,12,9],[13,0,13,10],[14,0,14,2],[14,4,14,7],[14,8,14,9],[15,0,15,3],[15,5,15,9],[16,0,16,3],[16,5,16,9],[17,0,17,10],[10,0,10,2],[10,4,10,7],[10,8,10,9],[3,0,3,3],[3,5,3,9],[4,0,4,3],[4,5,4,9],[5,0,5,10],[6,0,6,2],[6,4,6,7],[6,8,6,9],[7,0,7,3],[7,5,7,9],[8,0,8,3],[8,5,8,9],[9,0,9,10],[2,6,2,7],[2,0,2,2],[2,8,2,9],[0,0,0,10],[1,0,1,1],[2,3,2,5],[1,2,1,7],[1,8,1,10]]}
["Reserve Balances and Requirements (all reserve withdrawals will require prior HCD approval)"]
["Project Name:",null,{"$f":"'General Summary'!C6","v":0},null,null,null,null,null,{"$f":"'General Summary'!I5","v":"(Version 7/18/17)"}]
["Replacement Reserve:",null,null,"Based On PNA Dated:",null,null,null,null,"Current Balance:"]
["Amount capitalized from Development Budget (if any):",null,null,null,null,"Capitalized Amount deposit due date:"]
["Annual Deposit (due by Borrower's fiscal year end):",null,null,null,{"$f":"J38","v":0},"Per Unit Annual Deposit:",null,null,null,null,{"$f":"IF(E5=0,0,E5/'General Summary'!$C$9)","v":0}]
[]
["Operating Reserve:",null,null,"Based On:",null,null,null,null,"Current Balance:"]
["Amount capitalized from Development Budget:",null,null,null,null,"Capitalized Amount deposit due date:"]
["HCD required minimum capitalized amount:",null,null,null,{"$f":"IF(E7=\"Tax Credit Project (3 months)\",K51,IF(E7=\"Non-tax Credit Project (4 months)\",K52,0))","v":0},"Per Unit Amount:",null,null,null,null,{"$f":"IF(E9=0,0,E9/'General Summary'!$C$9)","v":0}]
[]
["Operating Reserve II:",null,null,"Based On:",null,null,null,null,"Current Balance:"]
["Amount capitalized from Development Budget (if any):",null,null,null,null,"Capitalized Amount deposit due date:"]
["Annual Deposit (if any, due by Borrower's FY end):",null,null,null,0,"Per Unit Annual Deposit:",null,null,null,null,{"$f":"IF(E13=0,0,E13/'General Summary'!$C$9)","v":0}]
[]
["Transition Reserve:",null,null,"Based On:",null,null,null,null,"Current Balance:"]
["Amount capitalized from Development Budget (if any):",null,null,null,null,"Capitalized Amount deposit due date:"]
["Annual Deposit (if any, due by Borrower's FY end):",null,null,null,0,"Per Unit Annual Deposit:",null,null,null,null,{"$f":"IF(E17=0,0,E17/'General Summary'!$C$9)","v":0}]
[]
["Enter other reserve type here",null,null,"Based On:",null,null,null,null,"Current Balance:"]
["Amount capitalized from Development Budget (if any):",null,null,null,null,"Capitalized Amount deposit due date:"]
["Annual Deposit (if any, due by Borrower's FY end):",null,null,null,0,"Per Unit Annual Deposit:",null,null,null,null,{"$f":"IF(E21=0,0,E21/'General Summary'!$C$9)","v":0}]
[]
["Enter other reserve type here",null,null,"Based On:",null,null,null,null,"Current Balance:"]
["Amount capitalized from Development Budget (if any):",null,null,null,null,"Capitalized Amount deposit due date:"]
["Annual Deposit (if any, due by Borrower's FY end):",null,null,null,0,"Per Unit Annual Deposit:",null,null,null,null,{"$f":"IF(E25=0,0,E25/'General Summary'!$C$9)","v":0}]
[]
[]
["Replacement Reserve Calculator"]
[1,"NEW CONSTRUCTION Projects only:"]
["(a)","Cost of Structures excluding General Contractor Profit, Overhead, General Requirements and General Liability Insurance:",null,null,null,null,null,null,{"$f":"'Development Budget'!C39-'Development Budget'!C34-'Development Budget'!C35-'Development Budget'!C36-'Development Budget'!C37","v":0},{"$f":"I30*0.006","v":0}]
["(b)","If Project received CalHFA permanent financing, check the box at right.",null,null,null,null,null,null,null,null,null,null,false]
["(c)","Enter number of new construction units (cell I-32):",null,"MHP per unit amount:",null,600,null,null,0,{"$f":"IF(M31=TRUE,I32*F33,I32*F32)","v":0}]
[null,null,null,"CalHFA per unit amount:",null,500]
["(d)","New Construction Replacement Reserve amount = lesser of (a) and (c) above",null,null,null,null,null,null,null,{"$f":"IF(I32>0,MIN(J32,J30),0)","v":0}]
[2,"REHABILITATION or EXTENSION ONLY Projects:"]
["(a)","Enter number of rehabilitation units or total number of units in the Project:",null,null,null,null,null,null,0,{"$f":"I36*I37","v":0}]
["(b)","Enter Replacement Reserve per unit amount:",null,null,null,null,null,null,0]
[null,"HCD Required Replacement Reserve Amount:",null,null,null,null,null,null,null,{"$f":"SUM(J34:J36)","v":0}]
[]
["Operating Reserve Calculator"]
[1,"Total Operating Expenses (including Property Taxes and excluding Service Coordinator salary).",null,null,null,null,null,null,null,null,{"$f":"MAX(('Proforma - non FMTW, MHP'!C27+'Proforma - non FMTW, MHP'!C28),('Proforma - Sp Rent Inc,FMTW,MHP'!C27+'Proforma - Sp Rent Inc,FMTW,MHP'!C28))","v":0}]
[2,"Replacement Reserve amount from above:",null,null,null,null,null,null,null,null,{"$f":"J38","v":0}]
[3,"Mandatory Permanent Debt Service (Enter lender name and amount of annual debt service below)"]
["(a)",{"$f":"IF('Proforma - non FMTW, MHP'!A37=\"\",IF('Proforma - Sp Rent Inc,FMTW,MHP'!A37=\"\",\"\",'Proforma - Sp Rent Inc,FMTW,MHP'!A37),'Proforma - non FMTW, MHP'!A37)","v":""},null,null,null,null,null,null,null,null,{"$f":"MAX('Proforma - non FMTW, MHP'!C37,'Proforma - Sp Rent Inc,FMTW,MHP'!C37)","v":0}]
["(b)",{"$f":"IF('Proforma - non FMTW, MHP'!A38=\"\",IF('Proforma - Sp Rent Inc,FMTW,MHP'!A38=\"\",\"\",'Proforma - Sp Rent Inc,FMTW,MHP'!A38),'Proforma - non FMTW, MHP'!A38)","v":""},null,null,null,null,null,null,null,null,{"$f":"MAX('Proforma - non FMTW, MHP'!C38,'Proforma - Sp Rent Inc,FMTW,MHP'!C38)","v":0}]
["(c)",{"$f":"IF('Proforma - non FMTW, MHP'!A39=\"\",IF('Proforma - Sp Rent Inc,FMTW,MHP'!A39=\"\",\"\",'Proforma - Sp Rent Inc,FMTW,MHP'!A39),'Proforma - non FMTW, MHP'!A39)","v":""},null,null,null,null,null,null,null,null,{"$f":"MAX('Proforma - non FMTW, MHP'!C39,'Proforma - Sp Rent Inc,FMTW,MHP'!C39)","v":0}]
["(d)",{"$f":"IF('Proforma - non FMTW, MHP'!A40=\"\",IF('Proforma - Sp Rent Inc,FMTW,MHP'!A40=\"\",\"\",'Proforma - Sp Rent Inc,FMTW,MHP'!A40),'Proforma - non FMTW, MHP'!A40)","v":"HCD Monitoring Fee"},null,null,null,null,null,null,null,null,{"$f":"MAX('Proforma - non FMTW, MHP'!C40,'Proforma - Sp Rent Inc,FMTW,MHP'!C40)","v":0}]
["(e)",{"$f":"IF('Proforma - non FMTW, MHP'!A41=\"\",IF('Proforma - Sp Rent Inc,FMTW,MHP'!A41=\"\",\"\",'Proforma - Sp Rent Inc,FMTW,MHP'!A41),'Proforma - non FMTW, MHP'!A41)","v":"Lease Payment"},null,null,null,null,null,null,null,null,{"$f":"MAX('Proforma - non FMTW, MHP'!C41,'Proforma - Sp Rent Inc,FMTW,MHP'!C41)","v":0}]
["(f)",{"$f":"IF('Proforma - non FMTW, MHP'!A42=\"\",IF('Proforma - Sp Rent Inc,FMTW,MHP'!A42=\"\",\"\",'Proforma - Sp Rent Inc,FMTW,MHP'!A42),'Proforma - non FMTW, MHP'!A42)","v":"Misc Fin. Exp-provide detail below"},null,null,null,null,null,null,null,null,{"$f":"MAX('Proforma - non FMTW, MHP'!C42,'Proforma - Sp Rent Inc,FMTW,MHP'!C42)","v":0}]
[null,"Total Annual Mandatory Debt Service:",null,null,null,null,null,null,null,null,{"$f":"MAX('Proforma - non FMTW, MHP'!C43,'Proforma - Sp Rent Inc,FMTW,MHP'!C43)","v":0}]
["4a","HCD Required Operating Reserve Amount (Tax Credit Project - 3 months)",null,null,null,null,null,null,null,null,{"$f":"(K41+K42+K50)/4","v":0}]
["4b","HCD Required Operating Reserve Amount (Non-Tax Credit Project - 4 months)",null,null,null,null,null,null,null,null,{"$f":"(K41+K42+K50)/3","v":0}]
["If Reserve amounts are different than the required amount, enter reserve amounts and how they are calculated below:"]

{"sheet":"Dropdown Lists","index":14,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["County","Use dropdown list to enter HCD 1699 Eligible Program","Other HCD Funding Programs","Restructuring Provision","SNP_Category","Support_Services","Replacement_Reserves","Op_Reserves","Special_Conditions","Funding_Name","Funding_Type","Round","NOFA Date"]
["Alameda","Rental Housing Construction Program (RHCP-Original)","No other HCD funding exists in this project","Extension of the term of exisiting Original Program loan","Not a SNP Project","Not a SH or SNP Project","Physical Needs Assessment","Tax Credit Project (3 months)","All Special Conditions have been satisfied","Department of Housing and Community Development","Deferred Developer Fee"]
["Alpine","Special User Housing Rehabilitation Program (SUHRP)","Department of Developmental Services Program (DDS)","Subordination of the Original Program loan to new debt","Agricultural Workers","Adult Day Care",".6% of structures cost - new const.","Tax Credit Investor Requirement","No Special Conditions have been identified","California Housing Finance Agency","Forgiveable Loan","MHP 1C-1 - 06/07","2007-01-25"]
["Amador","Deferred Payment Rehabilitation Loan Program (DPRLP) - Rental","HOME Investment Partnership Program (HOME)","New investment of tax credit equity","Chronic Substance Abusers","Attendant Care","$600 per unit - new construction","Senior Lender Requirement","Outstanding Special Conditions (provide comments below)","Tax Credit Equity","Grant","MHP 1C-2 - 07/08","2007-08-22"]
["Butte","California Natural Disaster Assistance Program-Rental (CALDAP-R)","Joe Serna, Jr. Farmworker Housing Grant Program (JSJFWHG)",null,"Developmentally Disabled Households","Benefits","$500 per unit - CalHFA","Other Public Agency Requirement",null,null,"Required Debt Service","MHP 1C-3 - 07/08","2008-01-31"]
["Calaveras","State Earthquake Rehabilitation Assistance Program (SERA)","Multifamily Housing Program (MHP)",null,"Disabled Households","Case Management",null,"Non-tax Credit Project (4 months)",null,null,"Residual Receipts","MHP 1C-4 - 08/09","2008-08-19"]
["Colusa","California Housing Rehabilitation Program-Rental (CHRP-R)","MHP Governor's Homeless Initiative (GHI)",null,"Displaced Teenage Parent","Child Care/Children's Services",null,"CalHFA Requirement",null,null,"Sponsor Residual Receipts","MHP 1C-5 - 10/11","2010-05-03"]
["Contra Costa","Rental Housing Construction Program (RHCP-Bond)","MHP Homeless Youth Program (HY) ",null,"Homeless Persons or Persons At-risk","Education",null,null,null,null,"Sponsor/GP Equity","MHP 1C-6 - 11/12","2011-06-14"]
["Del Norte","Family Home Demonstration Program (FHDP)","MHP Supportive Housing Program (SH)",null,"Homeless Youth","Employment",null,null,null,null,"4% Tax Credit Equity","MHP 46 B5 - 04/05","2005-01-26"]
["El Dorado","Families Moving to Work Program (FMTW)","Mobilehome Park Assistance Program (MPAP)",null,"Individuals exiting institutional settings","End of Life Counseling",null,null,null,null,"9% Tax Credit Equity","MHP 46 B6 - 05/06","2005-08-22"]
["Fresno",null,"Mobilehome Park Resident Ownership Program (MPROP)",null,"Long-term Chronic Health Condition","Green Education",null,null,null,null,null,"MHP 46 B7 - 05/06","2006-02-15"]
["Glenn",null,"Transit Oriented Development Housing Program (TOD)",null,"Mentally Disabled Households","Health Care",null,null,null,null,null,"Serna 1C MF-1","2007-01-18"]
["Humboldt",null,null,null,"Persons with HIV/AIDS","Housing Placement/Outplacement",null,null,null,null,null,"Serna 1C MF-3","2008-05-14"]
["Imperial",null,null,null,"Single Parent Housholds","Information and Referral",null,null,null,null,null,"Serna 1C MF-4","2010-05-14"]
["Inyo",null,null,null,"Survivors of Physical Abuse","Legal",null,null,null,null,null,"SH 1C-2","2008-03-03"]
["Kern",null,null,null,null,"Life Skills",null,null,null,null,null,"SH 1C-3","2008-09-30"]
["Kings",null,null,null,null,"Medication Management",null,null,null,null,null,"SH 1C-6","2011-06-14"]
["Lake",null,null,null,null,"Mental Health",null,null,null,null,null,"SH 46 3B","2005-03-09"]
["Lassen",null,null,null,null,"Money Management",null,null,null,null,null,"SH 46 4B","2006-03-07"]
["Los Angeles",null,null,null,null,"Parenting",null,null,null,null,null,"GHI 46","2005-11-15"]
["Madera",null,null,null,null,"Peer Advocacy",null,null,null,null,null,"GHI 46-2","2011-06-14"]
["Marin",null,null,null,null,"Recreational/Social",null,null,null,null,null,"HY 1C","2007-01-31"]
["Mariposa",null,null,null,null,"Representative Payee",null,null,null,null,null,"HY 1C-5-10/11 MHP","2010-05-03"]
["Mendocino",null,null,null,null,"Substance Abuse",null,null,null,null,null,"HY 1C-6","2011-06-14"]
["Merced",null,null,null,null,"Transportation Plan",null,null,null,null,null,"TOD 1C-1","2007-12-11"]
["Modoc",null,null,null,null,null,null,null,null,null,null,"TOD 1C-2","2009-01-30"]
["Mono"]
["Monterey"]
["Napa"]
["Nevada"]
["Orange"]
["Placer"]
["Plumas"]
["Riverside"]
["Sacramento"]
["San Benito"]
["San Bernardino"]
["San Diego"]
["San Francisco"]
["San Joaquin"]
["San Luis Obispo"]
["San Mateo"]
["Santa Barbara"]
["Santa Clara"]
["Santa Cruz"]
["Shasta"]
["Sierra"]
["Siskiyou"]
["Solano"]
["Sonoma"]
["Stanislaus"]
["Sutter"]
["Tehama"]
["Trinity"]
["Tulare"]
["Tuolumne"]
["Ventura"]
["Yolo"]
["Yuba"]

{"sheet":"Developer Fee","index":15,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[[39,1,39,3],[40,1,40,3],[41,1,41,3],[28,1,28,3],[33,0,33,4],[35,2,36,3],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[34,4,35,4],[38,0,38,4],[34,0,36,1],[37,0,37,4],[10,1,10,4],[16,0,16,4],[11,0,11,4],[20,1,20,3],[21,1,21,3],[14,0,14,4],[15,0,15,4],[17,0,17,3],[18,1,18,3],[19,1,19,3],[12,0,12,4],[13,0,13,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[9,1,9,4],[6,0,6,4],[7,1,7,4],[8,1,8,4],[4,0,4,4],[5,0,5,4],[25,1,25,3],[26,1,26,3],[27,1,27,3],[22,0,22,3],[23,1,23,3],[24,1,24,3]]}
[{"$f":"CONCATENATE(\"Developer Fee Limits   \",'General Summary'!I5)","v":"Developer Fee Limits   (Version 7/18/17)"}]
["(1) Projects not requesting a Special Rent Increase: the Developer Fee is not limited by the LPR Guidelines, but must comply with limitations imposed by other funding sources. Contact the HCD Loan Officer for instructions on completing this tab. (2) Projects requesting a Special Rent Increase: the Developer Fee is calculated using the TCAC Low-Income Housing Tax Credit 9% Program Rules. The explanation and calculations below will assist the Sponsor and HCD in confirming the allowable Developer Fee as part of the overall development budget. Follow the instructions below and enter the correct numbers in the spaces provided. Amounts and calculations will be verified against the Sponsor's final approved TCAC project application. Use this method even for 4% Tax Credit projects. Those seeking a deferral or waiver of HCD monitoring fees, or requesting an Early Special Rent Increase, should refer to Special Limitations below for additional guidance."]
["The Basic Rule:"]
["The developer fee includable in 9% tax credit eligible basis is limited to the lesser of:"]
["●  $1,400,000 or"]
["●  15% of construction-related eligible basis; or for rehabilitation projects that involve acquisition-based credit,  the sum of 15% of construction-related eligible basis plus 5% of acquisition-related eligible basis. "]
["Instructions:"]
["1.","If you are calculating a Developer Fee based on New Construction or Rehabilitation Only, use Table 1."]
["2.","If you are calculating a Developer Fee based on an Acquisition-Rehab transaction, use Table 2."]
["3.","Enter the dollar amounts in lines A, B, and C - based on the approved basis in the TCAC Application."]
["4.","For Lines D and E, follow the instructions based on transaction/basis type.  Line F will auto-calculate."]
["New Construction -- or -- Rehabilitation ONLY (project does not include acquisition basis)"]
["Use Table 1:  Multiply eligible basis x 0.15; if less than $1,400,000, or if you are requesting less than the calculated amount, insert your calculated/requested amount in Line D.  If the sum is more than $1,400,000, then insert $1,400,000 in Line D."]
["Rehabilitation and Acquisition"]
["Using Table 2:  Step 1: Multiply rehabilitation-portion of eligible basis x 0.15.  If the sum of the construction-related basis is less than $1,400,000, or if you are requesting less than the calculated amount, insert your calculated/requested amount in Line D.  If the sum is $1,400,000 or more, insert $1,400,000 in Line D.   Step 2: Multiply the acquisition-portion of eligible basis x 0.05.  Enter the sum of the acquisition-related eligible basis, or a lesser amount if you are requesting less than the calculated amount, in Line E. "]
["NOTE: The term \"Actual\" in the Tables below means the following for each line: (A) the project cost before developer fee as submitted by Sponsor; (B) TCAC-approved construction-related eligible basis; (C) TCAC-approved acquisition-related eligible basis; (D) the straight calculation of construction-related basis x 15%, or a lesser amount is so requested by Sponsor; (E) the straight calculation of acquisition-related basis x 5%, or a lesser amount is so requested by Sponsor; and (F) the total Developer Fee based on straight calculation of percentages or lesser total Developer Fee is so requested by Sponsor. "]
["Deveoper Fee Calculations"]
["TABLE 1: Transaction/Basis Type: use the dropdown to select New Construction or Rehab Only ",null,null,null,"(Select a type)"]
["A.","Subtotal project cost before developer fee",null,null,0]
["B.","Subtotal construction-related eligible basis before developer fee",null,null,0]
["C.","Applicant's construction-related developer fee (B x 15%; or voluntarily less)",null,null,0]
["D.","Maximum Allowable Developer Fee",null,null,{"$f":"IF(E20*0.15>1400000,1400000,E20*0.15)","v":0}]
["TABLE 2:  Transaction/Basis Type: Rehab and Acquisition ",null,null,null,"Rehab & Acquisition"]
["A.","Subtotal project cost before developer fee",null,null,0]
["B.","Subtotal construction-related eligible basis before developer fee",null,null,0]
["C.","Subtotal acquisition-related eligible basis before developer fee",null,null,0]
["D.","Applicant's construction-related developer fee (B x 15%; or voluntarily less)",null,null,0]
["E.","Applicant's acquisition-related developer fee (C x .05; or voluntarily less)",null,null,0]
["F.","Total developer fee",null,null,{"$f":"E27+E28","v":0}]
[null,null,"Actual",null,"Maximum"]
["New Construction: ",null,{"$f":"IF(E18=\"New Construction\",E27,0)","v":0},null,{"$f":"IF(E25*0.15>1400000,1400000,E25*0.15)","v":0}]
["Rehab ONLY: ",null,{"$f":"IF(E18=\"Rehabilitation\",E27,0)","v":0},null,{"$f":"IF(E25*0.15>1400000,1400000,E25*0.15)","v":0}]
["Rehab & Acquisition: ",null,{"$f":"IF(E23=\"Rehab & Acquisition\",E27+E28,0)","v":0},null,{"$f":"IF(((E25*0.15)+(E26*0.05))>1400000,1400000,((E25*0.15)+(E26*0.05)))","v":0}]
["Special Limitations:"]
["If an Early Special Rent Increase is requested per Section 108(b)(4)(A), or if Sponsor requests deferral or waiver of HCD Monitoring Fees per Section 113(f), then Net Developer Fee must be less than 50% of the allowable Developer Fee.  If Special Limitation applies, enter amount here."]
[null,null,"Special Limited Developer Fee:"]
[null,null,null,null,0]
["Comments (include justification for higher Developer Fee limits, in accoradance with TCAC rules, for projects over 201 units): "]
[]
["A.","Total HCD Approved Developer Fee",null,null,0]
["B.","Total HCD Approved Deferred Developer Fee prior to Distributions",null,null,0]
["C.","Total HCD Approved Deferred Developer Fee from Distributions",null,null,0]

{"sheet":"PTR Liens-HCD Use Only","index":16,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,0,1,4],[2,0,2,1],[2,3,2,4],[0,0,0,4]]}
[{"$f":"CONCATENATE(\"Disposition of Preliminary Title Report Liens, Exceptions, Regulatory Agreements and CC&R's   \",'General Summary'!I5)","v":"Disposition of Preliminary Title Report Liens, Exceptions, Regulatory Agreements and CC&R's   (Version 7/18/17)"}]
["FOR HCD USE ONLY"]
["Preliminary Title Report dated:",null,null,{"$f":"'General Summary'!C6","v":0}]
["Exception\nItem\nnumber ","Beneficiary","Lien\nAmount","Final\nLien\nOrder","Disposition of Beneficiary Lien"]

{"sheet":"Special Conditions-HCD Use Only","index":17,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,4,0,9],[0,0,0,3],[18,0,18,9],[25,0,25,8],[2,0,2,9],[10,0,10,3],[10,4,10,8],[11,4,11,8],[1,0,1,9],[3,6,3,9],[4,6,4,9],[3,0,3,4],[4,0,4,4],[16,0,16,3],[17,0,17,3],[5,0,5,4],[26,0,26,8],[12,0,12,3],[12,4,12,8],[22,0,22,3],[22,4,22,8],[13,0,13,3],[13,4,13,8],[24,0,24,9],[14,4,14,8],[23,4,23,8],[20,0,20,3],[21,0,21,3],[19,4,19,8],[20,4,20,8],[21,4,21,8],[15,0,15,3],[5,6,5,9],[9,0,9,9],[11,0,11,3],[14,0,14,3],[8,0,8,9],[6,6,6,8],[7,0,7,8],[15,4,15,8],[16,4,16,8],[17,4,17,8],[19,0,19,3],[23,0,23,3]]}
[{"$f":"CONCATENATE(\"Special Conditions   \",'General Summary'!I5)","v":"Special Conditions   (Version 7/18/17)"},null,null,null,{"$f":"'General Summary'!C6","v":0}]
["FOR HCD USE ONLY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,".42% Interest - if already required, provide payment info and total monitoring fees"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Additional Reserves - provide capitalized amt. and timing; required annual deposit"]
["Early Special Rent Increase (Y/N): ",null,null,null,null,null,"  If No, skip to next item.",null,null,null,null,null,null,null,null,null,"Annual operating income requested for use as Source for development budget"]
["If Yes, is Developer Fee only 50% of Allowable (Y/N)?",null,null,null,null,null,"  If No, recalculate, or call HCD Loan Officer.",null,null,null,null,null,null,null,null,null,"Balloon payment appears in loan documents of new senior or junior lender"]
["Protected tenants rent roll changed since Application (Y/N)?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combination of two or more projects into one development"]
["Is HCD monitoring fee paid in advance thru this transaction (Y/N)?",null,null,null,null,null,"If Yes, enter fee payment amount:",null,null,null,null,null,null,null,null,null,"If Special Rent Increase, rehab cost per unit must exceed avg of TCAC 4% and 9%"]
["If HCD monitoring fee is not paid thru this transaction, enter the Fiscal Year 2014 annual monitoring fee amount:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operating Reserves - provide capitalized amt. and timing; required annual deposit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payment of HCD monitoring fee causes low DCR on new senior loan"]
["A. Special Conditions for Exhibit C of the Regulatory Agreement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reconfiguration of Units - describe the new unit mix"]
["List any Special Conditions",null,null,null,"Details of the Special Condition",null,null,null,null,"Date\nSatisfied",null,null,null,null,null,null,"Replacement Reserves - provide capitalized amt. and timing; required annual deposit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RHCP-O Annutity continues after this conversion transaction"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Special Rent Increase or Early Special Rent Increase being requested"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sponsor Distribution - describe calculation & amt; note deviation from UMR 8314"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sponsor requesting monitoring fee be deferred, reduced, waived or below the line"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sponsor requesting to pre-pay HCD monitoring fees"]
[]
[]
["B. Special Conditions Prior to Closing"]
[]
[]
[]
[]
[]
["C. Attachments Required to Satisfy Special Conditions"]