{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["A1 Index","A2 Summary","A3 Project Narrative","B1 Certification","B2 Defaults","B3 Resolution","B4 Experience","C1 Project Info","C2 Financing Info","C3 Development Cost","C4 Operating Budget","C5 Revenue and Cash Flow","C6 Proforma","C7-A Environ Effects","C11 Development Timetable","C14 Market"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":8,"defined_names":163,"comments":7,"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":"A1 Index","index":0,"n_rows":50,"n_cols":3,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,0,1,2],[4,0,4,2],[0,0,0,2],[2,0,2,2]]}
["Tab A 1. Application Index and Checklist"]
["Items underlined and in blue are attached forms "]
["Information for all other items must be included in Application on additional pages provided by Applicant."]
[]
["Instructions:  Applications must be submitted in a three-ring binder. Enter information on yellow shaded Tabs A1 to A3, B1, B2, B4, C1 to C6, C7-A and C11.  You may enter information and data only in yellow shaded fields on each form. Print these pages for inclusion in Application binder using divider tabs consistent with this index and checklist. Information required on all other tabs (non-underlined tab titles below) must be provided by Applicant and included in Application binder.  Contact the PDLP Loan Officer for assistance."]
[]
["Section A. Summary Info:","Tab #:","Tab Title:"]
[null,"A 1.","Application Index and Checklist"]
[null,"A 2.","Application Summary Information Form"]
[null,"A 3.","Project Narrative Description "]
[]
["Section B. Applicant Info:","Tab #:","Tab Title:"]
[null,"B 1.","Applicant Certification and Commitment of Responsibility"]
[null,"B 2.","No Defaults Statement"]
[null,"B 3.","Governing Board Resolution (Sample; see Notes at top of sample)"]
[null,"B 4.","Applicant Organization's Background and Experience Form"]
[null,"B 5.","Applicant & Partners' Staff & Directors' Brief Description of Experience or Resumes"]
[null,"B 6.","Applicant's & General Partners' (G.P.) Articles of Incorporation and By-Laws"]
[null,"B 7.","Audited Financial Statements for Last Two Years"]
[null,"B 8.","Certification of nonprofit status for Applicant or all G.P.s"]
[null," B 9. ","Organizational Chart of Applicant "]
[]
["Section C.  Project Info:","Tab #:","Tab Title:"]
[null,"C 1.","Project Information Form"]
[null,"C 2.","Lender Information and Proposed Financing"]
[null,"C 3.","Loan Purposes and Development/Operating Costs"]
[null,"C 4.","Operations Budget (Estimated; rental projects only)"]
[null,"C 5.","Revenue and Cash Flow"]
[null,"C 6.","15 Year Pro-Forma (Rental Projects Only)"]
[null,"C 7.","Environmental"]
[null,null,"A. Environmental Effects"]
[null,null,"B. Phase 1 Environmental Site Assessment, if Available"]
[null,null,"C. Any Soils, Geo-Technical and Engineering Reports, if Available"]
[null,"C 8.","Parcel Map, Location Map/Surrounding Area, & Proposed Site Plan, if Available"]
[null," C 9. ","Letters of Financing Commitments from Grantors or Lenders, if Available"]
[null,"C 10.","Evidence of Zoning/Use Permits or Other Necessary Local Approvals, if Available"]
[null,"C 11.","Development Timetable"]
[null,"C 12.","Purchase Option, Purchase Agreement, Grant Deed, or Other Site Control"]
[null,"C 13.","Most Recent Preliminary Title Report (no older than 6 months)"]
[null,"C 14.","Market Study , if Available, or Area Housing Needs"]
[null,"C 15.","Evidence of Utilities Availability, if Available"]
[null,"C 16.","Appraisal by certified appraiser (site acquisition/refinance loans only)"]
[null,"C 17.","Project Sources and Uses"]
[null,"C 18.","Rehabilitation Projects only: "]
[null,null,"A. Description of the Current Development"]
[null,null,"B. Current rent roll with household income levels."]
[null,null,"C. Number of units estimated as needing temporary/permanent relocation,"]
[null,null,"D.  Relocation Plan, if Available"]
[null,null,"E. Physical Needs Assessment, if Available"]
[null,null,"F. Rehab projects must also complete the 15year Pro-Forma (Tab C18)"]

{"sheet":"A2 Summary","index":1,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,0,49,2],[49,3,49,10],[14,0,14,10],[20,5,21,10],[0,0,0,10],[4,2,4,10],[6,0,6,1],[6,2,6,4],[6,7,6,10],[4,0,4,1],[5,0,5,1],[3,0,3,10],[1,0,1,10],[7,2,7,4],[7,7,7,10],[8,0,8,1],[7,0,7,1],[8,5,8,6],[9,0,9,1],[9,2,9,4],[9,7,9,10],[21,2,21,4],[23,0,23,1],[22,0,22,4],[8,2,8,4],[8,7,8,10],[33,2,33,3],[33,4,33,7],[33,8,33,10],[23,2,23,4],[10,0,10,4],[10,7,10,10],[11,0,11,4],[11,7,11,10],[15,6,15,10],[18,1,18,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[19,2,19,4],[20,2,20,4],[12,0,12,10],[43,7,43,10],[44,7,44,10],[37,0,37,10],[41,7,41,10],[34,2,34,10],[36,0,36,4],[36,6,36,10],[45,0,45,1],[42,7,42,10],[47,0,47,2],[48,0,48,2],[45,2,45,3],[45,4,45,5],[45,6,45,7],[47,3,47,10],[48,3,48,10],[38,4,44,4],[44,0,44,3],[38,2,38,3],[46,0,46,10],[38,7,38,10],[39,7,39,10],[40,7,40,10],[24,0,25,4],[30,0,30,10],[35,0,35,10],[27,8,27,10],[26,0,26,1],[31,4,31,7],[31,8,31,10],[27,0,27,4],[29,2,29,9],[31,0,31,1],[31,2,31,3],[32,0,32,1],[32,2,32,3],[32,4,32,7],[32,8,32,10],[33,0,33,1]]}
["Tab A 2. Application Summary Information"]
[]
["Company Information"]
[]
["Sponsor/Company Name:"]
["*Organization Type:"]
["Sreet Address/Suite :",null,null,null,null,null,"Incorporation date:"]
["P. O.  Box (if any):",null,null,null,null,null,"Contact Name:"]
["City/State/Zip:",null,null,null,null,"Job Title: "]
["List all General Partners/Type:",null,null,null,null,null,"Contact Phone:"]
[null,null,null,null,null,null,"Fax Number:"]
[null,null,null,null,null,null,"Email Address:"]
[]
["Project Information"]
[]
["Project Name:",null,null,null,null,null,"Proposed Development-check all that apply"]
["Project Address:",null,null,null,null,null,"Section \"A\"",null,null,"Section \"B\""]
["City/State/Zip Code:",null,null,null,null,null,"Homeownership:",null,null,"New:"]
["Project County:",null,null,null,null,null,"Cooperative:",null,null,"Rehabilitation:"]
[null,"Senate District/Name:",null,null,null,null,"Rental:",null,null,"Other:"]
[null,"Assembly District/Name:"]
[null,"Congressional District/Name:"]
[null,null,null,null,null,null,"Section \"C\"",null,null,"Section \"D\""]
["PDLP Amount Requested:",null,null,null,null,null,"Senior:",null,null,"Single-Family"]
[null,null,null,null,null,null,"Special Needs:",null,null,"2-4 Units"]
[null,null,null,null,null,null,"Veterans:",null,null,"Mfg. Housing:"]
["**Geographic Location:",null,null,null,null,null,"Family:",null,null,"Apartments"]
["“Urban area” means any portion of a county or the state which is not a rural area.\n"]
[null,null,null,null,null,null,null,null,null,"Mobilehome Pk"]
[null,"County Assessor Parcel #(s)."]
[]
["Census Tract (if Multifamily project):",null,null,null,"Estimated Date of Loan Repayment:"]
["Sales Total (Owned Only):",null,null,null,"Security for the Loan:"]
["Total Development Cost:",null,null,null,"Source(s) of funds to be used for repayment:"]
[null,"Ultimate Borower Name:"]
[]
["Site Control",null,null,null,null,null,"Other Information"]
[]
["Fee Title:",null,null,null,null,null,"Architect:"]
["Leasehold:",null,"Expire Date:",null,null,null,"General Contractor:"]
["Enforceable Option:",null,"Expire Date:",null,null,null,"Consultant(s):"]
["Disposition/Devel. Agreement:",null,"Expire Date:",null,null,null,"Property Manager:"]
["Exclusive Right to Negotiate:",null,"Expire Date:",null,null,null,"# Market Rate:"]
["Land Sales Contract:",null,"Expire Date:",null,null,null,"# Special Needs :"]
[null,null,null,null,null,null,"# Owner-occupied:"]
["Purchase Price of Site:",null,null,null,"Fair Market Value:"]
[]
["*See Health & Safety Code 50530.5(e) at:",null,null,"H&S Code 50530.5(e)"]
["** See Health & Safety Code 50199.21  at:",null,null,"H&S Code 50199.21"]
["                                ** See Health & Safety Code 50104.7 at:",null,null,"H&S Code 50104.7"]

{"sheet":"A3 Project Narrative","index":2,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,10],[2,0,2,10],[5,0,5,10],[7,0,7,10],[4,0,4,10],[6,0,6,10],[3,0,3,10]]}
["Tab A 3. Attach a Narrative Description of the Project and Design Features "]
[]
["Include a description of any significant design features (e.g. subterranean garage, hillside development, scattered sites, etc.) that affects project operating and/or development costs.  Also include how the project addresses tenant needs, local acceptance issues, livability and sustainability.  Use the space below and add an additional page if necessary."]
[]
["Narrative description of design features and how they affect project operating or development costs."]
[]
["Narrative description of how project addresses tenant needs, local acceptance issues, livability and sustainability."]

{"sheet":"B1 Certification","index":3,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,9],[25,1,25,5],[21,1,21,5],[21,7,21,8],[23,1,23,5],[15,1,17,8],[4,1,4,8],[2,0,2,9],[5,0,5,9],[19,0,19,9],[9,1,11,8],[13,1,13,7],[3,1,3,8],[7,1,7,8]]}
["Tab B 1. Applicant Certification and Commitment of Responsibility"]
[]
["As the official designated by the governing body, I hereby certify that, if approved by the California Department of Housing and Community Development for a Predevelopment Loan Program (PDLP) loan, "]
[]
[null,"(Applicant entity name)"]
["assumes the responsibilities specified in all applicable program regulations and statutes, and in the Department's Notice of Funding Availability (NOFA), under which this application is submitted.  I certify that:"]
[]
["A.","Applicant possesses the legal authority to apply for the PDLP loan;"]
[]
["B.","Applicant has resolved any audit findings or adverse actions taken by the Department within the last three years to the satisfaction of the Department or federal agency by which the funding was made;"]
[]
[]
[]
["C.","Applicant will comply with all statutes and regulations governing the PDLP;"]
[]
["D. ","The information, statements, and attachments contained in the application are, to the best of my knowledge and belief, true and correct.  This application, if approved for funding, will be a part of the Standard Agreement with the Department."]
[]
[]
[]
["I authorize the Department of Housing and Community Development to contact any agency, whether or not named in this application, which may assist in determining the capacity and/or experience of the Applicant.  All information contained in this application is acknowledged to be public information."]
[]
["Signature:",null,null,null,null,null,"Date:"]
[]
["Name:"]
[]
["Title:"]

{"sheet":"B2 Defaults","index":4,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[[28,2,28,7],[36,2,36,3],[34,0,34,1],[30,2,30,7],[32,2,32,7],[2,0,4,9],[8,2,8,6],[34,2,34,7],[0,0,0,9],[1,0,1,9],[5,0,5,9],[6,1,6,9],[23,1,23,9],[7,0,7,9],[11,0,11,9],[16,0,16,9],[13,0,13,9],[22,0,22,9],[19,0,19,9],[25,0,25,9],[26,0,26,9]]}
["Tab B 2. No Defaults Statement"]
[]
["Please respond to the six questions below, and if the answer to any question is \"yes,\" please explain the circumstances in writing on a separate page in this section.  This form must be signed by the authorized signatory of the Applicant(s)."]
[]
[]
[]
[" 1.","In the past five years, have you or the entity below, or any affiliate of yours or the entities below, acting as a principal in connection with any real estate project, experienced any of the following:"]
[]
[null,"a. ","A Default in the payment of the mortgage"]
[]
[null,"b. ","Foreclosure or delivery of a deed in lieu of foreclosure."]
[]
[" 2.","Have you, or any affiliate of yours, filed for bankruptcy?"]
[]
["  3. ","Are you, or any affiliate of yours, a defendant in any pending civil or criminal legal action?"]
[]
[]
[" 4. ","Are you, or any affiliate of yours, subject to any unsatisfied judgments or liens?"]
[]
[]
["5. ","Have you ever been charged with or convicted of a felony, or any fraud or securities violation?"]
[]
[]
["6. ","Are there any other conditions (financial/legal) not included above that would affect your ability to complete the project?"]
[]
[]
["I hereby authorize the Department of Housing and Community Development to contact any agency, whether or not named in this application, which may assist in verifying the information contained in this application."]
[]
[null,"Signature:"]
[]
[null,"Name:"]
[]
[null,"Title:"]
[]
["Entity Name:"]
[]
[null,"Date:"]

{"sheet":"B3 Resolution","index":5,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[[8,1,8,9],[26,0,26,8],[32,0,32,8],[36,0,36,8],[43,0,43,8],[16,0,16,9],[17,0,17,8],[18,1,18,9],[19,0,19,8],[20,1,20,9],[21,0,21,8],[9,0,9,8],[15,1,15,7],[24,5,24,8],[25,0,25,3],[25,6,25,8],[5,0,5,8],[7,0,7,8],[0,0,0,9],[4,1,4,9],[6,1,6,9],[11,0,11,8],[12,0,12,8],[13,0,13,9],[10,0,10,8],[28,2,28,4],[37,4,37,8],[44,2,44,6],[51,0,51,4],[51,6,51,8],[49,6,49,7],[49,0,49,4]]}
["Tab B 3. Sample Resolution of Governing Board of Directors"]
[]
["NOTES TO TAB B3:"]
[]
["1. ","This is intended to be a model for resolutions authorizing loan applications.  Applicants should use their own format if it contains substantially all the authorizations in the model."]
[]
["2. ","This model uses language appropriate to a nonprofit corporation or cooperative.  A housing authority or other government agency may want to substitute more appropriate terminology for \"Governing Board\" and \"Corporation.\""]
[]
["3. ","The person attesting to the vote of the Board or Governing Body cannot be the same person authorized to execute documents."]
[]
["Predevelopment Loan Resolution of the Governing Board of"]
[]
["(Full Legal Name of Applicant Entity)"]
["HEREBY AUTHORIZES THE SUBMITTAL OF A PREDEVELOPMENT LOAN PROGRAM (PDLP) APPLICATION, THE INCURRING OF AN INDEBTEDNESS, THE EXECUTION OF A LOAN AGREEMENT AND ANY AMENDMENTS THERETO, A PROMISSORY NOTE, AND ANY OTHER DOCUMENTS NECESSARY TO SECURE A HOUSING PREDEVELOPMENT LOAN FROM THE STATE OF CALIFORNIA."]
["WHEREAS"]
["A. "]
["(hereinafter referred to as \"Corporation\") is a corporate entity established under the laws of California and empowered to own property, borrow money, and give security for loans;"]
[]
["B.","The California Department of Housing and Community Development (hereinafter referred to as the \"State\") is authorized to make loans for the production of assisted housing for low-income persons;"]
[]
["C.","The Corporation wishes to obtain from the State a housing predevelopment loan for the development of such housing, and is an Eligible Sponsor under the PDLP;"]
[]
["IT IS NOW RESOLVED THAT:"]
["1.","The Corporation shall submit to the State an application for a predevelopment loan for "]
["the low-income housing project to be developed at:"]
[null,null,null,null,"in the County of"]
[]
["2.","If the loan is approved, the Corporation is hereby authorized to incur indebtedness in an "]
["amount not to exceed ",null,"$",null,null," or the amount approved by the State, and "]
["to enter into a loan agreement with the State for the purposes set forth in the loan application and"]
["approved by the State.  It also may give a promissory note, and execute security and other "]
["instruments necessary or required by the State to evidence and secure the indebtedness;"]
[]
["3. ","The Corporation is further authorized to request amendments, including increases in loan "]
["amounts up to amounts approved by the State, and to execute any and all documents required by "]
["the State to evidence and secure these amendments;"]
[]
["4.","The Corporation authorizes "]
["to execute in the name of the Corporation, the loan application and the loan agreement, "]
["promissory note, and security and other instruments necessary or required by the State for the "]
["making and securing of the loan, and any amendments thereto."]
["PASSED AND ADOPTED THIS",null,null,null,"DAY OF",null,", 20__, by the following vote:"]
["AYES:",null,"NAYS:",null,"ABSTAIN:",null,"ABSENT:"]
[]
["The undersigned",null,null,null,null,null,null,"of the Corporation"]
["heretofore named does hereby attest and certify that the foregoing is a true and full copy of a "]
["resolution of the Board of Directors adopted at a duly convened meeting on the date above-"]
["mentioned, which has not been altered, amended, or repealed."]
[]
[null,null,null,null,null,"Date:"]

{"sheet":"B4 Experience","index":6,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[28,2,28,12],[29,2,29,12],[30,2,30,12],[11,2,11,12],[17,2,17,12],[26,2,27,12],[23,2,24,12],[15,7,15,12],[14,7,14,12],[21,2,21,5],[21,6,21,11],[19,2,19,5],[19,6,19,8],[6,3,6,12],[0,2,0,12],[2,2,2,12],[4,2,4,12],[5,3,5,12],[7,3,7,12],[8,3,8,12],[9,3,9,12],[18,2,18,5],[18,6,18,11],[13,2,13,6],[14,2,14,6],[15,2,15,6],[13,7,13,12]]}
[null,null,"Tab B 4. Applicant Background and Experience"]
[]
[null,null,"Applicant Housing Development Experience"]
[]
[null,null,"List any current or past HCD loans or grants, including loans from the Predevelopment Loan Program.  Include loan number and loan program.  Also include any HCD loans or grants to any of the controlling partners of the Applicant entity. "]
[null,null,"1."]
[null,null,"2."]
[null,null,"3."]
[null,null,"4."]
[null,null,"5."]
[]
[null,null,"Number of projects and type of units (e.g. SRO, self-help, single-family, multi-family)"]
[]
[null,null,"Developed and Completed Projects and Unit Types:   "]
[null,null,"Project/Unit Types Currently Under Development:   "]
[null,null,"Project/Unit Types Currently Under Management:   "]
[]
[null,null,"Organization Financial Status"]
[null,null,"Source of Administrative Funds: (Describe)"]
[null,null,"Amount of Administrative Funds: (current fiscal year)"]
[]
[null,null,"Location(s) of Business Activity: (Cities/Counties)"]
[]
[null,null,"Note: Attach a narrative describing housing development experience, and a resume of each staff person who will be working on the proposed project.  Include resumes of contact staff, executive staff, Board of Directors, and any known affiliated entities involved in the development of the project.  For rentals, also state the type of ownership planned once the project development is fully developed and begins tenancy (e.g. multiple partners, affiliate entities, limited partnership, etc.).  Include the role and experience of each known entity."]
[]
[]
[null,null,"If applicant is a local government agency, attach evidence of housing element status in this Tab B4, per PDLP Regulation Section 7004(d)(9).  Noncompliance with the housing element does not automatically eliminate eligibility."]

{"sheet":"C1 Project Info","index":7,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[30,5,30,6],[38,0,38,4],[36,7,36,8],[53,7,53,8],[63,3,63,9],[68,0,68,10],[64,0,64,8],[65,0,65,7],[66,9,66,10],[66,0,66,7],[60,5,60,7],[44,0,44,10],[48,1,48,6],[49,1,49,6],[50,1,50,6],[51,1,51,6],[52,1,52,6],[53,1,53,6],[30,7,30,8],[61,0,61,1],[36,5,36,6],[58,0,58,1],[54,0,54,10],[43,4,43,10],[1,0,1,10],[18,5,18,7],[8,4,8,5],[25,0,25,3],[5,5,5,9],[8,0,8,3],[4,3,4,4],[4,5,4,9],[5,2,5,4],[23,0,23,3],[12,0,12,3],[15,0,15,10],[10,2,10,3],[28,5,28,6],[23,5,23,9],[21,5,21,9],[20,5,20,9],[12,5,12,6],[16,0,16,10],[12,7,12,9],[28,7,28,8],[29,7,29,8],[29,5,29,6],[26,0,26,10],[14,0,14,9],[19,5,19,9],[20,0,20,3],[21,0,21,3],[0,0,0,10],[11,5,11,9],[2,0,2,10],[4,0,4,2],[25,5,25,9],[24,5,24,9],[18,0,18,3],[9,5,9,9],[10,5,10,9],[13,0,13,9],[24,0,24,1],[22,5,22,9],[19,0,19,3],[22,0,22,1],[6,0,6,5],[6,6,6,10],[9,2,9,3],[11,0,11,1],[11,2,11,3],[7,0,7,3],[7,4,7,10],[8,6,8,10],[9,0,9,1],[10,0,10,1],[49,9,49,10],[47,9,47,10],[59,0,59,1],[31,5,31,6],[52,7,52,8],[32,5,32,6],[34,7,34,8],[35,5,35,6],[35,7,35,8],[33,5,33,6],[33,7,33,8],[32,7,32,8],[34,5,34,6],[47,7,47,8],[48,7,48,8],[49,7,49,8],[40,8,40,10],[31,7,31,8],[78,0,78,3],[78,5,78,7],[78,8,78,10],[70,0,70,9],[72,0,72,10],[41,0,41,10],[76,0,76,10],[61,3,61,4],[50,9,50,10],[62,0,62,1],[53,9,53,10],[45,0,45,10],[51,9,51,10],[52,9,52,10],[48,9,48,10],[62,5,62,10],[57,0,57,1],[61,5,61,10],[71,0,71,10],[73,0,73,10],[50,7,50,8],[51,7,51,8],[56,0,56,1],[60,0,60,1]]}
["Tab C1. Project Information"]
["* Include a parcel map and indicate location on map."]
["Project Site Information"]
[]
["Parcel Size (Sq. Ft./Acres):",null,null,null,null,"No. lots proposed or sub-divided (indicate which)*"]
["Present Zoning:",null,null,null,null,"No. structures proposed/existing (indicate which)*"]
["Are annexation, zoning change, use permit or variances required?"]
["If yes, please give details including timetable:"]
["Are utilities available to the site?  ",null,null,null,null,null," "]
["Water:",null,null,null,"Source:"]
["Sewer:",null,null,null,"Source:"]
["Gas/Electric:",null,null,null,"Source:"]
["Are on and/or off site improvements needed?",null,null,null,null,"If Yes, explain:"]
[]
["If loan funds are requested for site improvements, give specific details on work items and costs. "]
[]
["Proposed Housing Description"]
[]
["Number of Dwelling Structures:"]
["Number of Stories:",null,null,null,null,"Gross Sq. Footage of Child Care Center:"]
["Number of Elevators:",null,null,null,null,"Gross Sq. Footage of Social Svc. Facility:"]
["Total Land Area:",null,null,null,null,"Gross Sq. Footage of Common Areas:"]
["No.Parking Slots: ",null,null,"Est.ParkSq. Ft.:",null,"Gross Sq. Footage of Commercial Areas:"]
["Parking Type (grarage, at-grade, covered?):",null,null,null,null,"Gross Sq. Footage of Community Room:"]
["#Market-rate Units",null,null,"Sq. Ft. Mkt. Rate:",null,"Gross Sq. Footage of Other Areas (describe):"]
[" Gross Sq. Footage of Residential Units:",null,null,null,null,"Gross Sq. Footage of All Structures:"]
["Unit Description & Income (Categorized by number of bedrooms)"]
[]
[null,"# of Bedrooms","# of Units","Sq.Ft. of Unit","Mo.ResidentCost*","Sales Price",null,"HH Low Income**",null,"Very Low Income**","% of AMI "]
[]
[]
[]
[]
[]
[]
[]
[null,"Totals",{"$f":"SUM(C30:C36)","v":0},null,{"$f":"SUM(E30:E36)","v":0},null,null,{"$f":"SUM(H30:H36)","v":0},null,{"$f":"SUM(J30:J36)","v":0}]
[]
["*Rent or average monthly mortgage payment, UTILITIES INCLUDED",null,null,null,null,null,"**Maximums: 80% or 50% Area Median Income respectively"]
[]
["Explain what other costs the rent/mortgage will include (e.g. any taxes, insurance)"]
[]
["For subdivisions or condominums, attach a chart of expected sales prices categorized by number of bedrooms."]
["Rent Subsidy-length, type, source, amount?"]
[]
["Estimated Owner-Occupied Expenses "]
[]
[null,null,null,null,null,null,null,"Monthly Costs",null,"Per Unit Per Mo."]
[null,"Debt Service/Mortgage",null,null,null,null,null,0,null,{"$f":"H49/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}}]
[null,"Utilities",null,null,null,null,null,0,null,{"$f":"H50/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}}]
[null,"Insurance",null,null,null,null,null,0,null,{"$f":"H51/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}}]
[null,"Taxes",null,null,null,null,null,0,null,{"$f":"H52/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}}]
[null,"Operation/Maintenance",null,null,null,null,null,0,null,{"$f":"H53/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}}]
[null,"Total Estimated Operating/Owner Costs",null,null,null,null,null,{"$f":"SUM(H49:H53)","v":0},null,{"$f":"SUM(J49:K53)","v":{"$error":"#DIV/0!"}}]
["Project Location and Market Data - Proximity to Project of the Following"]
[]
["Schools:",null,null,null,"Public Transportation"]
["Hospital:",null,null,null,"Bus:"]
["Drugstore:",null,null,null,"Train:"]
["Park:",null,null,null,"Light rail/Trolley:"]
["Grocery Store:",null,null,null,"Other Services or Amenities:"]
["Police Dept.:",null,null,"Potential Employment Sources:"]
["Fire Dept.:"]
[]
["1.  Is project located in a \"public transit corridor\" as defined in H&S Code Section 50093.5?"]
["2.  Is project a preservation of \"at risk housing\" as defined in CCR Section 7002?"]
["3.  What is estimated fair market value of the land? (attach appraisal if available)"]
["4.  Describe any energy efficient measures which promote affordable development costs and/ or operating expenses:"]

{"sheet":"C2 Financing Info","index":8,"n_rows":52,"n_cols":15,"rows_kept":52,"cut":false,"hidden":false,"merged":[[18,1,18,2],[2,0,2,14],[12,0,12,14],[13,0,14,0],[13,1,14,2],[13,3,14,3],[13,4,14,4],[13,5,14,5],[13,6,14,6],[13,7,14,7],[13,8,14,8],[13,9,14,9],[13,10,14,10],[15,1,15,2],[16,1,16,2],[17,1,17,2],[26,1,26,2],[27,1,27,2],[28,2,28,3],[29,2,29,3],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[47,1,47,2],[41,1,41,2],[3,6,4,6],[6,1,6,2],[32,12,33,12],[34,1,34,2],[35,1,35,2],[36,1,36,2],[31,0,31,14],[32,0,33,0],[32,1,33,2],[32,3,33,3],[32,4,33,4],[32,5,32,6],[32,7,33,7],[32,8,32,9],[52,0,52,14],[3,1,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[10,2,10,3],[48,2,48,3],[37,1,37,2],[38,1,38,2],[39,1,39,2],[49,5,49,9],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[3,0,4,0],[40,1,40,2],[0,0,0,14],[7,1,7,2],[8,1,8,2],[9,2,9,3],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[5,1,5,2],[32,13,33,13],[32,14,33,14],[32,10,33,10],[32,11,33,11],[25,1,25,2]]}
["Tab C 2. Sources of Development Funds"]
[]
["PREDEVELOPMENT PERIOD SOURCES OF FUNDS "]
["Committed?","Source Name\n(listed in order of lien priority)",null,"Lien\nNo.","Amount","Interest\nRate","Required\nPayment ","Loan Term\n(months)","Tax Exempt\nAmount","Residential\nAmount","Commercial\nAmount"]
[]
[]
[]
[]
[]
[null,"Equity Investor",null,null,null," ",null,null,null,{"$f":"E10","v":0}]
[null,null,"TOTALS",null,{"$f":"SUM(E6:E10)","v":0}," ",null,null,{"$f":"SUM(I6:I9)","v":0},{"$f":"SUM(J6:J10)","v":0},{"$f":"SUM(K6:K9)","v":0},null," "]
[]
["CONSTRUCTION PERIOD SOURCES OF FUNDS "]
["Committed?","Source Name\n(listed in order of lien priority)",null,"Lien\nNo.","Amount","Interest\nRate","Required\nPayment ","Loan Term\n(months)","Tax Exempt\nAmount","Residential\nAmount","Commercial\nAmount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Equity Investor",null,null,null," ",null,null,null,{"$f":"E29","v":0}]
[null,null,"TOTALS",null,{"$f":"SUM(E16:E29)","v":0}," ",null,null,{"$f":"SUM(I16:I28)","v":0},{"$f":"SUM(J16:J29)","v":0},{"$f":"SUM(K16:K28)","v":0},null," "]
[]
["PERMANENT SOURCES OF FUNDS "]
["Committed?","Source Name\n(listed in order of lien priority)",null,"Lien\nNo.","Amount","Interest Rate ",null,"Amortization\nPeriod (yrs.)","Repayment Terms",null,"Required\nResidential\nDebt Service","Required\nCommercial\nDebt Service","Tax Exempt\nAmount","Residential\nAmount","Commerical\nAmount"]
[null,null,null,null,null,"Rate","Type ",null,"Type","Due in (yrs)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Equity Investor",null,null,null,null,null,null,null,null,null,null,null,{"$f":"E49","v":0}]
[null,null,null,"TOTALS",{"$f":"SUM(E35:E49)","v":0}," ",null,null,null,null,{"$f":"SUM(K35:K49)","v":0},{"$f":"SUM(L35:L49)","v":0},{"$f":"SUM(M35:M49)","v":0},{"$f":"SUM(N35:N49)","v":0},{"$f":"SUM(O35:O49)","v":0}]
[]
["Applicant Comments"]

{"sheet":"C3 Development Cost","index":9,"n_rows":56,"n_cols":13,"rows_kept":56,"cut":false,"hidden":false,"merged":[[11,3,11,11],[12,3,12,11],[13,3,13,11],[45,7,45,10],[46,7,46,10],[47,7,47,10],[48,7,48,10],[39,0,39,4],[19,3,19,11],[12,0,12,2],[13,0,13,2],[14,0,14,2],[16,0,16,2],[14,3,14,11],[15,3,15,11],[16,3,16,11],[17,3,17,11],[18,3,18,11],[49,7,49,10],[40,7,40,10],[41,7,41,10],[42,7,42,10],[43,7,43,10],[44,7,44,10],[35,7,35,10],[36,7,36,10],[37,7,37,10],[38,7,38,10],[39,7,39,10],[68,0,68,12],[23,11,24,12],[45,0,45,4],[38,0,38,4],[42,0,42,4],[35,0,35,4],[23,7,24,10],[23,5,24,5],[25,7,25,10],[26,7,26,10],[27,7,27,10],[28,7,28,10],[29,7,29,10],[30,7,30,10],[31,7,31,10],[32,7,32,10],[49,0,49,4],[50,0,50,4],[62,0,62,2],[52,0,52,4],[53,0,53,4],[51,0,51,4],[50,7,50,10],[51,7,51,10],[5,3,5,11],[6,3,6,11],[7,3,7,11],[8,3,8,11],[36,0,36,4],[37,0,37,4],[40,0,40,4],[31,0,31,4],[28,0,28,4],[18,0,18,2],[24,0,24,2],[20,1,20,2],[29,0,29,4],[32,0,32,4],[33,0,33,4],[30,0,30,4],[33,7,33,10],[34,7,34,10],[27,0,27,4],[25,0,25,4],[5,0,5,2],[9,0,9,2],[9,3,9,11],[10,3,10,11],[52,7,52,10],[53,7,53,10],[56,0,56,12],[6,0,6,2],[8,0,8,2],[0,0,0,12],[2,0,2,12],[22,0,22,12],[19,0,19,2],[10,0,10,2],[26,0,26,4],[11,0,11,2],[15,0,15,2],[7,0,7,2],[17,0,17,2],[34,0,34,4],[44,0,44,4],[43,0,43,4],[48,0,48,4],[47,0,47,4],[41,0,41,4],[46,0,46,4],[3,4,3,5],[4,3,4,11]]}
["Tab C 3. Development Costs and Proposed Use of Funds"]
[]
["HCD Predevelopment Loan Request"]
["Total PDLP Amount Requested:"]
["Proposed Use(s) of PDLP Funds:",null,null,"Comments"]
["Appraisal",null,null,null,null,null,null,null,null,null,null,null,0]
["Option to Purchase Land",null,null,null,null,null,null,null,null,null,null,null,0]
["Land Acquisition",null,null,null,null,null,null,null,null,null,null,null,0]
["Holding Costs ",null,null,null,null,null,null,null,null,null,null,null,0]
["Closing Costs",null,null,null,null,null,null,null,null,null,null,null,0]
["Engineering Fees",null,null,null,null,null,null,null,null,null,null,null,0]
["Environmental Reports",null,null,null,null,null,null,null,null,null,null,null,0]
["Architectural Fees",null,null,null,null,null,null,null,null,null,null,null,0]
["School Impact Fees",null,null,null,null,null,null,null,null,null,null,null,0]
["Local Planning/Permit Fees",null,null,null,null,null,null,null,null,null,null,null,0]
["Legal Fees",null,null,null,null,null,null,null,null,null,null,null,0]
["Loan/TCAC Fees",null,null,null,null,null,null,null,null,null,null,null,0]
["Consultant Fees",null,null,null,null,null,null,null,null,null,null,null,0]
["Other (specify)*",null,null,null,null,null,null,null,null,null,null,null,0]
["Other (specify)*",null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M6:M20)","v":0}]
[]
["Development Costs (If actual figures are not available, please provide best current estimate)"]
[null,null,null,null,null,"Per Project Costs:",null,"  Per Residential Unit:",null,null,null,"Per Residential Square Foot:"]
[]
["Land Cost or Value",null,null,null,null,0,null,{"$f":"F26/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F26/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Demolition",null,null,null,null,0,null,{"$f":"F27/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F27/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Off-Site Improvements/Site Development.",null,null,null,null,0,null,{"$f":"F28/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F28/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Relocation Expenses",null,null,null,null,0,null,{"$f":"F29/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F29/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Dwelling Structures (new/rehab)",null,null,null,null,0,null,{"$f":"F30/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F30/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Other Structures*",null,null,null,null,0,null,{"$f":"F31/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F31/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Contractor Overhead/Profit",null,null,null,null,0,null,{"$f":"F32/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F32/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Architectural",null,null,null,null,0,null,{"$f":"F33/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F33/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Construction Loan Interest & Fees",null,null,null,null,0,null,{"$f":"F34/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F34/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Permanent Financing Costs",null,null,null,null,0,null,{"$f":"F35/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F35/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Lender Legal Paid by Applicant",null,null,null,null,0,null,{"$f":"F36/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F36/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Legal Fees",null,null,null,null,0,null,{"$f":"F37/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F37/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Capitalized Operating Reserves",null,null,null,null,0,null,{"$f":"F38/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F38/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Capitalized Replacement Reserves",null,null,null,null,0,null,{"$f":"F39/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F39/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Appraisal/Market Study",null,null,null,null,0,null,{"$f":"F40/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F40/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Survey & Engineering",null,null,null,null,0,null,{"$f":"F41/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F41/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Construction Contingency",null,null,null,null,0,null,{"$f":"F42/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F42/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["TCAC App/Alloc/Monitor Fees",null,null,null,null,0,null,{"$f":"F43/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F43/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Environmental Audit",null,null,null,null,0,null,{"$f":"F44/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F44/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Local Development Impact Fees",null,null,null,null,0,null,{"$f":"F45/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F45/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Permit Processing Fees",null,null,null,null,0,null,{"$f":"F46/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F46/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Marketing",null,null,null,null,0,null,{"$f":"F47/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F47/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Furnishings ",null,null,null,null,0,null,{"$f":"F48/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F48/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Other (describe)*",null,null,null,null,0,null,{"$f":"F49/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F49/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Developer Overhead/Profit",null,null,null,null,0,null,{"$f":"F50/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F50/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Consultant/Processing Agent",null,null,null,null,0,null,{"$f":"F51/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F51/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Project Administration ",null,null,null,null,0,null,{"$f":"F52/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F52/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["Broker Fees Paid by Owner",null,null,null,null,0,null,{"$f":"F53/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F53/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
["      Total Development Costs",null,null,null,null,{"$f":"SUM(F26:F53)","v":0},null,{"$f":"F54/'C1 Project Info'!$C$37","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F54/'C1 Project Info'!$E$26","v":{"$error":"#DIV/0!"}}]
[]
[null,"*Specify \"Other\" costs:"]

{"sheet":"C4 Operating Budget","index":10,"n_rows":75,"n_cols":10,"rows_kept":75,"cut":false,"hidden":false,"merged":[[73,1,73,7],[73,8,73,9],[74,1,74,7],[74,8,74,9],[70,1,70,7],[70,8,70,9],[71,8,71,9],[72,1,72,9],[66,1,66,7],[66,8,66,9],[67,8,67,9],[68,1,68,9],[69,1,69,7],[69,8,69,9],[62,8,62,9],[63,1,63,9],[64,1,64,7],[64,8,64,9],[65,1,65,7],[65,8,65,9],[60,1,60,7],[60,8,60,9],[59,1,59,7],[59,8,59,9],[61,1,61,7],[61,8,61,9],[54,1,54,2],[55,1,55,2],[57,0,58,0],[57,1,57,7],[57,8,57,9],[58,1,58,9],[53,1,53,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],[41,1,41,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],[29,1,29,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],[17,1,17,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],[0,0,0,9],[1,0,1,1],[1,3,1,4],[1,7,1,8],[3,0,5,0],[3,3,5,3],[3,1,5,2]]}
["Tab C 4. Operating Budget"]
["Total Units:",null,null,"Assisted Units:",null,null,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: (Note: if Admin. Exp. detail is unavailable, enter total Administrative Expenses on line 16)"]
[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":"I62","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":"(E23-I23)*F23","v":0},{"$f":"+(E23-G23-I23)","v":0},{"$f":"SUM(I8:I22)","v":0},{"$f":"SUM(G23:I23)","v":0}]
[null,"Utilities: (Note: if Utilities detail is unavailable, enter total Utilities on line 21)"]
[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":"(E29-I29)*F29","v":0},{"$f":"+(E29-G29-I29)","v":0},{"$f":"SUM(I25:I28)","v":0},{"$f":"SUM(G29:I29)","v":0}]
[null,"Operating and Maintenance Expenses: (Note: if Operating & Maintenance Expense detail is unavailable, enter total Operating & Maintenance Expenses on line 34)"]
[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":"I67","v":0},0,0,0,0,0]
[34,"Total Operating and Maintenance Expenses",null,"6500T",{"$f":"SUM(E31:E42)","v":0},null,0,0,{"$f":"SUM(I31:I42)","v":0},0]
[null,"Taxes and Insurance: (Note: if Taxes and Insurance detail is unavailable, enter total Taxes and Insurance on line 42)"]
[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":"I71","v":0},0,0,0,0,0]
[42,"Total Taxes and Insurance",null,"6700T",{"$f":"SUM(E45:E51)","v":0},null,0,0,{"$f":"SUM(I45:I51)","v":0},{"$f":"SUM(G52:I52)","v":0}]
[null,"Assisted Living/Board & Care Expenses:"]
[43,"Other Service Expenses (describe below)",null,6990,{"$f":"I75","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":"SUM(G55:I55)","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":"SUM(G56:I56)","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,"Total Account 6390 Miscellaneous Administrative Expenses",null,null,null,null,null,null,{"$f":"SUM(I60:J61)","v":0}]
[]
[null,"Account 6590 Miscellaneous Operations & Maintenance Expenses"]
[49]
[50]
[51,"Total Account 6590 Miscellaneous Operations & Maintenance Expenses",null,null,null,null,null,null,{"$f":"SUM(I65:J66)","v":0}]
[]
[null,"Account 6790 Misc. Taxes, Licenses, Permits & Insurance"]
[52]
[53,"Total Account 6790 Misc. Taxes, Licenses, Permits & Insurance",null,null,null,null,null,null,{"$f":"SUM(I70:J70)","v":0}]
[]
[null,"Account 6990 Other Service Expenses"]
[54]
[55,"Total Account 6990 Other Service Expenses",null,null,null,null,null,null,{"$f":"SUM(I74:J74)","v":0}]

{"sheet":"C5 Revenue and Cash Flow","index":11,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[56,1,56,5],[56,6,56,7],[57,1,57,5],[57,6,57,7],[52,1,52,5],[52,6,52,7],[53,1,53,5],[53,6,53,7],[54,1,54,7],[55,1,55,5],[55,6,55,7],[51,1,51,5],[51,6,51,7],[45,0,46,0],[45,1,45,5],[45,6,45,7],[46,1,46,7],[47,1,47,5],[47,6,47,7],[48,1,48,5],[48,6,48,7],[49,1,49,5],[49,6,49,7],[50,1,50,7],[38,1,38,2],[39,1,39,2],[42,1,42,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],[28,1,28,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],[16,1,16,2],[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],[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]]}
["Tab C5. Proposed Revenue, Mandatory Debt and Reserve Deposits - Operating Budget"]
["Total Units:",null,{"$f":"'C4 Operating Budget'!C2","v":0},"Assisted Units:",null,{"$f":"'C4 Operating Budget'!F2","v":0},"Proration %:",{"$f":"'C4 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":"G50","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":"G54","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":"G58","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}]
[]
[]
["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(G48:H49)","v":0}]
[null,"Account 5990 Miscellaneous Revenue"]
[37,null,null,null,null,null,0]
[38]
[39,"Total Account 5990",null,null,null,null,{"$f":"SUM(G52:H53)","v":0}]
[null,"Account 6890 Miscellaneous Financial Expenses"]
[40]
[41]
[42,"Total Account 6890",null,null,null,null,{"$f":"SUM(G56:H57)","v":0}]

{"sheet":"C6 Proforma","index":12,"n_rows":48,"n_cols":27,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,16],[48,0,48,16]]}
["Tab C6. Cash Flow Pro-Forma"]
[null,"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 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,{"$f":"'C5 Revenue and Cash Flow'!E7","v":0},{"$f":"C4*($B$4+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"#REF!*($B$4+1)","v":{"$error":"#REF!"}},{"$f":"R4*($B$4+1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Rent Revenue - Non-Assisted",2.5000000000000001E-2,{"$f":"'C5 Revenue and Cash Flow'!F7","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"#REF!*($B$4+1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Tenant Assistance Payments",2.5000000000000001E-2,{"$f":"'C5 Revenue and Cash Flow'!H8","v":0},{"$f":"C6*($B$6+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"#REF!*($B$6+1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Rent Revenue - Commercial",2.5000000000000001E-2,{"$f":"'C5 Revenue and Cash Flow'!H9","v":0},{"$f":"C7*($B$7+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"#REF!*($B$7+1)","v":{"$error":"#REF!"}},{"$f":"R7*($B$7+1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Garage and Parking Spaces",2.5000000000000001E-2,{"$f":"'C5 Revenue and Cash Flow'!H10","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"#REF!*($B$7+1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Flexible Subsidy Revenue",2.5000000000000001E-2,{"$f":"'C5 Revenue and Cash Flow'!H11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"#REF!*($B$7+1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Miscellaneous Rent Revenue",2.5000000000000001E-2,{"$f":"'C5 Revenue and Cash Flow'!H12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"#REF!*($B$7+1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["TOTAL RENTAL REVENUE",null,{"$f":"'C5 Revenue and Cash Flow'!H13","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,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Vacancy - Assisted Units",0.05,{"$f":"'C5 Revenue and Cash Flow'!E16","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,{"$f":"IF(#REF!=0,0,(R11-R24-R7)*$B$12)","v":{"$error":"#REF!"}},{"$f":"IF(R12=0,0,(S11-S24-S7)*$B$12)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Vacancy - Non-Assisted Units",0.05,{"$f":"'C5 Revenue and Cash Flow'!F16","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,{"$f":"IF(#REF!=0,0,(R12-R11-R8)*$B$12)","v":{"$error":"#REF!"}},{"$f":"IF(R13=0,0,(S12-S11-S8)*$B$12)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Vacancy - Commercial",0.5,{"$f":"'C5 Revenue and Cash Flow'!H17","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,{"$f":"IF(#REF!=0,0,(R5*$B$17))","v":{"$error":"#REF!"}},{"$f":"IF(R14=0,0,(S5*$B$17))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Rental Concessions",2.5000000000000001E-2,{"$f":"'C5 Revenue and Cash Flow'!H18","v":0},{"$f":"C15*($B$16+1)","v":0},{"$f":"D15*($B$16+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]
["Vacancy - Garage and Parking",0.05,{"$f":"'C5 Revenue and Cash Flow'!H19","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]
["Miscellaneous Vacancies",0.05,{"$f":"'C5 Revenue and Cash Flow'!H20","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]
["TOTAL VACANCIES",null,{"$f":"'C5 Revenue and Cash Flow'!H21","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,{"$f":"R24-R11-R16","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["TOTAL NET RENTAL REVENUE",null,{"$f":"'C5 Revenue and Cash Flow'!H22","v":0},{"$f":"D11-D18","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Laundy and Vending Revenue",2.5000000000000001E-2,{"$f":"'C5 Revenue and Cash Flow'!H24","v":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]
["Tenant Charges",2.5000000000000001E-2,{"$f":"'C5 Revenue and Cash Flow'!H25","v":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]
["Miscellaneous Revenue",2.5000000000000001E-2,{"$f":"'C5 Revenue and Cash Flow'!H26","v":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]
["TOTAL OTHER REVENUE",null,{"$f":"'C5 Revenue and Cash Flow'!H27","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,{"$f":"R15-R16-R21","v":0},0,0,0,0,0,0,0,0,0]
["Transition 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]
["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,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["OP EXP & RESERVE DEP."]
["Total Op Exp. w/o RE taxes",3.5000000000000003E-2,{"$f":"'C4 Operating Budget'!J56-'C4 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":"#REF!*(1+$B$27)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Real Estate Taxes",0.02,{"$f":"'C4 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":"#REF!*($B$28+1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Replacement Reserve-Deposit",null,{"$f":"'C5 Revenue and Cash Flow'!H38","v":0},{"$f":"C29*($B$29+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"#REF!*($B$29+1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Operating Reserve-Deposit",null,{"$f":"'C5 Revenue and Cash Flow'!H39","v":0},{"$f":"C30*($B$30+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"#REF!*($B$30+1)","v":{"$error":"#REF!"}},{"$f":"R30*($B$30+1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Transition Reserve-Deposit",null,{"$f":"'C5 Revenue and Cash Flow'!H40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"#REF!*($B$30+1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"IF('[5]Rev, CF - Sp Rent Inc, FMTW,MHP'!C41=\"\",\"\",'[5]Rev, CF - Sp Rent Inc, FMTW,MHP'!C41)","v":""},null,{"$f":"'C5 Revenue and Cash Flow'!H41","v":0},{"$f":"C32*($B$32+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"#REF!*($B$32+1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"IF('[5]Rev, CF - Sp Rent Inc, FMTW,MHP'!C42=\"\",\"\",'[5]Rev, CF - Sp Rent Inc, FMTW,MHP'!C42)","v":""},null,{"$f":"'C5 Revenue and Cash Flow'!H42","v":0},{"$f":"C33*($B$33+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"#REF!*($B$33+1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["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,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["NET OPERATING INCOME",null,{"$f":"C25-C34","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["FINANCIAL EXP INC MAND DEBT"]
[null,null,{"$f":"'C5 Revenue and Cash Flow'!H30","v":0},{"$f":"C37","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"R37","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"IF('C5 Revenue and Cash Flow'!C31=\"\",\"\",'C5 Revenue and Cash Flow'!C31)","v":""},null,{"$f":"'C5 Revenue and Cash Flow'!H31","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"IF('C5 Revenue and Cash Flow'!C32=\"\",\"\",'C5 Revenue and Cash Flow'!C32)","v":""},null,{"$f":"'C5 Revenue and Cash Flow'!H32","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["HCD Required Payments",null,{"$f":"'C5 Revenue and Cash Flow'!H33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Lease Payment",null,{"$f":"'C5 Revenue and Cash Flow'!H34","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Misc. Financial Expenses",null,{"$f":"'C5 Revenue and Cash Flow'!H35","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["TOTAL FINANCIAL EXPENSES",null,{"$f":"SUM(C37:C42)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["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,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["AVAILABLE CASH FLOW",null,{"$f":"C35-C43","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["COMMENTS:"]

{"sheet":"C7-A Environ Effects","index":13,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[21,0,21,9],[18,0,18,9],[14,2,14,9],[15,2,15,9],[16,2,16,9],[17,2,17,9],[20,0,20,3],[12,2,12,9],[13,2,13,9],[0,0,0,9],[7,2,7,9],[8,2,8,9],[9,2,9,9],[10,2,10,9],[11,2,11,9],[2,2,2,9],[3,2,3,9],[4,2,4,9],[5,2,5,9],[6,2,6,9]]}
["Tab C 7 - A. Environmental Effects"]
["Discuss below all items checked \"yes\" (attach additional sheets as necessary).  Will the project:"]
["1.",null,"Change the existing features of any bays, tidelands, beaches, lakes or hills, or substantially alter ground contours?"]
["2.",null,"Change the scenic views or vistas from existing residential areas or public lands or roads?"]
["3.",null,"Change the pattern, scale or character of the general area of the project?"]
["4.",null,"Result in significant amounts of solid waste or litter?"]
["5.",null,"Be located in an area protected by the Endangered Species Act?"]
["6.",null,"Be located in a floodplain or wetlands area?"]
["7.",null,"Be located near any flammable oer explosive operations, or in an Airport Clear Zone?"]
["8.",null,"Increase the dust, ash, smoke, fumes or odors in the vicinity?"]
["9.",null,"Change the ocean, bay, lake, stream or ground water quality or quantity, or alter the existing drainage patterns?"]
["10.",null,"Substantially change the existing noise or vibration levels in the vicinity?"]
["11.",null,"Be located on a site on filled land or any slope of 10 percent of more?"]
["12.",null,"Use or discard potentially hazardous materials, such as toxic substances, flammables or explosives?"]
["13.",null,"Substantially change demand for municipal services (police, fire, water, sewage, etc.)?"]
["14.",null,"Substantially increase fossil fuel consumption (electricity, oil, natural gas, etc.)?"]
["15.",null,"Have a relationship to an associated project, anticipated incremental development, or to a larger project?"]
["16.",null,"Be affected by potentially toxic or hazardous contaminants on or near the site (e.g.  pesticide, underground tanks, lead paint, asbestos)?"]
["Please include an explanation of all \"yes\" answers in Comment section below.  Add a separate sheet of paper if needed.  Also, if a Phase I and other environmental reports are not yet completed on the site, include any other environmental concerns if known or suspected."]
[]
["Comments:"]

{"sheet":"C11 Development Timetable","index":14,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[[32,0,32,1],[36,1,36,2],[37,1,37,2],[41,1,41,2],[40,1,40,2],[39,1,39,2],[38,1,38,2],[35,1,35,2],[34,0,34,3],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[26,0,26,3],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[18,0,18,3],[0,0,0,3],[4,0,4,3],[6,1,6,2],[9,0,9,3],[2,1,2,3],[5,1,5,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[7,1,7,2],[11,1,11,2],[12,1,12,2],[10,1,10,2]]}
["Tab C11. Development Timetable"]
[]
["Project Name:                                                                  "]
[]
["SITE"]
["Scheduled Date  ",null,null,"Actual Date"]
[null,"Phase 1 or 2 Environmental Site Assessment Completed"]
[null,"Site Acquired (or Option or Sale Agreement)"]
[]
["LOCAL PERMITS/APPROVALS"]
["Scheduled Date  ",null,null,"Actual Date"]
[null,"Conditional Use Permit"]
[null,"Variance"]
[null,"Site Plan Review"]
[null,"Grading Permit"]
[null,"Building Permit"]
[null,"Density Bonus"]
[]
["CONSTRUCTION FINANCING"]
["Funding Source",null,"Date of Award\nor Commitment","Commitment Expiration Date"]
[]
[]
[]
[]
[]
[]
["PERMANENT FINANCING"]
["Funding Source",null,"Date of Award\nor Commitment","Commitment Expiration Date"]
[]
[]
[]
[]
[]
[]
["LOAN CLOSING"]
["Scheduled Date  ",null,null,"Actual Date"]
[null,"Construction Loan Closing"]
[null,"Construction Start"]
[null,"Construction Complete"]
[null,"TCAC Placed In Service Application"]
[null,"Occupancy of All Assisted Units"]
[null,"Permanent Loan Closing"]

{"sheet":"C14 Market","index":15,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[[20,0,20,8],[16,0,16,4],[23,0,23,8],[13,0,13,8],[17,0,17,8],[19,0,19,8],[21,0,21,8],[22,0,22,8],[24,0,24,8],[2,0,2,8],[3,0,3,8],[0,0,0,8],[4,0,4,2],[5,0,5,8],[6,0,6,8],[12,0,12,4],[10,0,10,8],[14,0,14,8],[18,0,18,8],[15,0,15,8],[7,0,7,8],[9,0,9,8],[11,0,11,8],[8,0,8,6]]}
[" Tab C14. Project Marketing Information"]
[]
["Include the following as separate pages:"]
[]
["Area Housing Needs:"]
["Please provide available quantitative information on the demand for housing of this type, in this market area.  Information may be available from local planning departments, housing authorities, or Councils of Governments."]
["Use separate page(s) to provide information regarding Area Housing Needs and include in Application binder."]
[]
["Project Marketing, and Tenant/ Owner Selection Criteria:"]
["Describe resident current or proposed recruitment efforts for the project, including numbers of low-income households contacted, waiting lists of those interested, whether the waiting list was screened for some or all of the eligibility requirements, demographics of those recruited, and advertising materials.  Describe tenant/owner selection criteria."]
["Use separate page(s) to provide information regarding Project Marketing, and Tenant/ Owner Selection Criteria and include in Application binder."]
[]
["Market Study/Information (if available):"]
["For example, the market area's:  average and range (high/low) of market rents; average and range of wages, and employment sources; vacancy rates of nearby comparable developments; standardized test-ranking, drop-out/graduation rates, student turnover, and availability of schools; and/or typical family size and demographics."]
["Use separate page(s) to provide information regarding Market Study/Information and include in Application binder."]
[]
["Tenant Amenities and Special Needs"]
["Any significant amenities in the neighborhood or in the development itself.  If any proposed tenant population has special needs, list any services proposed to be accessible to the development site, neighborhood, or otherwise accessible (and describe how the service would be accessible)."]
["Use separate page(s) to provide information regarding Tenant Amenities and Special Needs and include in Application binder."]
[]
["Description of buildings/residents currently on site, and any relocation plan (attach)"]
["Use separate page(s) to provide info regarding the description of buildings/residents currently on site, and any relocation plan and include in Application binder."]
[]
["Any other significant market or proposed development information not listed above."]
["Use separate page(s) to provide info regarding any other significant market or proposed development information not listed above and include in Application binder."]