{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["1. Operating Budget Instruction"," 2. Checklist and Cert - 170","3. Proposed Cash Flow -171","4. Proposed Cost of Ops - 172","5. Approved Cash Flow - 173","6. Approved Cost of Ops - 174 ","7. Approved Proration - 175","8. Actual Cash Flow-180","9. Actual Cost of Ops-181"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":16,"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":"1. Operating Budget Instruction","index":0,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,0,26,11],[25,0,25,11],[15,0,15,11],[16,0,16,11],[18,0,18,11],[21,0,21,11],[22,0,22,11],[24,0,24,11],[17,0,17,11],[23,0,23,11],[14,0,14,11],[19,0,19,11],[20,0,20,11],[3,0,3,11],[4,0,4,11],[0,10,0,11],[1,0,1,11],[2,0,2,11],[0,0,0,9],[13,0,13,11],[5,0,5,11],[7,0,7,11],[8,0,8,11],[10,0,10,11],[11,0,11,11]]}
["1. Combined Operating Budget Instructions",null,null,null,null,null,null,null,null,null,"2025-04-16"]
["Please use the Tab key to navigate through the form."]
["PLEASE READ - what's new:"]
["1. Upon opening this workbook you may receive a banner that says, \"PROTECTED VIEW: Be careful---files from the Internet can\n    contain viruses. Unless you need to edit, it's safer to stay in Protected View.\" \n             * If you receive this banner, Click \"Enable Editing\".\n2. Upon opening this workbook you will receive a banner that says, \"SECURITY WARNING: Macros have been disabled.\" \n              * When you see this banner, Click \"Enable Content\".\n    2A. When you see the dialog box asking, \"Do you want to make this file a Trusted Document?\" \n               * Click \"Yes\".\n3. Operating Revenue and Expense Accounts have been revised to conform to the latest HUD Chart of Accounts and Combined Audit \n    Handbook.\n4. Miscellaneous revenues and expenses must be itemized within the appropriate \"Miscellaneous\" section at the bottom of the worksheets\n    on Tabs 3, 4, 8 and 9. Do not attach separate worksheets for itemizing Miscellaneous revenues and expenses.\n5. On Tab 2, HCD/CalHFA-funded units are noted as Assisted, except for HCD MHP-type Projects, which will be referred to as Restricted.\n    This will change the cell name in the upper right corner of Tab 2 and auto-populate column headings on Tabs 3, 4, 7, 8, and 9.  \n    Assisted/Restricted units include managers units, but do not include Market-Rate units.\n6. If Applicable for HCD funded developments only - The Form 180 and Form 181 worksheets (Tabs 8 and 9) are to be completed only if the \n    project is not required to submit Audited Financial Statements."]
["This workbook consists of nine (9) Worksheets (Tabs) displayed at the bottom of the page. Each Tab indicates the name of the Form/Worksheet. This Workbook must be saved to your computer before entering any data. To save this Workbook, the Agencies' recommend Microsoft Edge as the browser to get the required results. Regardless of your browser, please download the form before entering any data, and be sure to save it in the format known as \"Excel Macro-Enabled Workbook (*.xlsm). To save this Microsoft Excel workbook to your computer using Microsoft Edge, click the \"File\" menu, choose the \"Save As\" option, then select \"More options...\". In the pop-up window, you will find the field \"File name\", enter the name of your project, and in the field \"Save as type\", select the type \"Excel Macro-Enanled Workbook (*.xlsm)\".\n"]
["The following three worksheet Tabs (colored in light yellow) are to be completed by the Sponsor:"]
[]
["Tab 2. Form 170 - Checklist and Certification, with Submittal Instructions\nTab 3. Form 171 - Proposed Cash Flow\nTab 4. Form 172 - Proposed Cost of Operations\nThese worksheets are used for the Sponsor’s Proposed Operating Budget and are due 60 days before the beginning of the Project’s Fiscal Year. "]
["The next three worksheet Tabs (colored green) are for the Agency's use only:"]
[]
["Tab 5. Form 173 - Approved Cash Flow\nTab 6. Form 174 - Approved Costs of Operations  \nTab 7. Form 175 - Approved Proration \nWhen approved, Agency's Representative will email the approved copy of the Project Operating Budget Workbook to the Sponsor."]
["HCD Developments Only - The last two worksheet tabs (colored in orange) are to be completed by the Sponsor (if applicable):"]
[]
["Tab 8. Form 180 - Actual Cash Flow \nTab 9. Form 181 - Actual Operating Costs \n These worksheets are to be completed only if the Project is not required to submit Audited Financial Statements; or if the Project is required\n to submit Audited Financial Statements, but the submitted Audit does not include the supplemental information described in the most recent\n Financial Statement Audit Handbook. The Annual Report Package is due to the Department 90 days after the end of the Fiscal Year. Please\n refer to  the Department's website for additional forms, requirements, and instructions, at the following link:"]
["https://www.hcd.ca.gov/reporting-and-compliance-loan-programs"]
["2. Form 170 - CHECKLIST AND CERTIFICATION:"]
["a.  The Sponsor is required to complete all light yellow-shaded fields on this Workbook! When data is entered in these light yellow-shaded\n      fields, the information is automatically populated on the linked worksheets in this workbook.\nb.  Enter all  Contract Numbers for the Project in the designated cells.\nc.  The Proration Percentage is calculated depending on the number of -assisted units in the Project. For example, if the Project has \n     150 units total with 50 units assisted by an  Program, the Proration Percentage would be 33%. \n      If you use a Proration Percentage calculated on a different basis, you must provide the rationale and explain the basis used. \n      If you have questions about the appropriate Proration Factor for your Project, contact your AMC Representative or CalHFA Asset Manager.\nd.  Checklist of Required Items: check the box for each item once completed and email it to AMCBranch@hcd.ca.gov and \"CC\" your AMC\n      Representative or AssetManagement@calhfa.ca.gov and \"CC\" your MultiFamily (MF) Asset Manager.\ne.  Certification: complete this required area as described above."]
["3. Form 171 - PROPOSED CASH FLOW ANALYSIS:"]
["a.  The Sponsor is required to complete all yellow-shaded fields on this Workbook. Enter the amounts in appropriate yellow-shaded fields for\n      Lines 1 through 13 in Columns A through C. Enter the Total Proposed Budget costs in Line 16 Column D (include amounts for all\n      Residential and Commercial costs). If Project includes Commercial costs, enter the Total Proposed Commercial costs in Line 16 Column C.\n      Column A (Proposed Assisted Units costs) and Column B (Proposed Non-Assisted Units costs) are auto-filled by the proration percentage, \n      using the difference between Column D less Column C and applying the proration percentage. To see a description of the expenses to be \n      included in the Account, hover your mouse over the corresponding Account Name field.\nb.  Line 8, enter proposed Vacancy Percentage related to Apartments and Commercial costs (the Vacancy amount will auto calculate). \nc.  Lines 11 through 13, enter the Proposed Vacancy amount related to Stores and Commercial costs; Rental Concessions; Garage and\n     Parking Spaces; and Miscellaneous Vacancies.\nd.  Line 25 Total Cost of Operations will auto-fill from Worksheet (tab) 3. Proposed Cost of Operations.\ne.  Lines 27 through 52 (light yellow-shaded fields), enter any amounts applicable according to the Program(s) Regulations, Guidelines and/or \n     Regulatory Agreement for which you are submitting the Budget."]
["4. Form 172 - PROPOSED COST OF OPERATIONS:"]
["a.  The Sponsor is required to complete all yellow-shaded fields on this Workbook. Enter the Total Proposed Budget amounts in Column A\n     (include all Residential and Commercial costs). If Project includes Commercial costs, enter the total Proposed Commercial amounts in\n     Column E. Column C (Proposed Assisted Units costs) and Column D (Proposed Non-Assisted Units costs) are auto-filled by the proration\n     percentage, using the difference between Column A less Column C and applying the proration percentage. To see a description of the\n     expenses to be included in the Account, hover your mouse over the Account Name field.\nb.  Line 8 Management Fees - must comply with HUDs allowed per unit per month amount.\nc.  Line 15 Miscellaneous Administrative Expenses - itemize the information if expenses total more than $2,500 for this Account Code, in the \n     section labelled \"Account 6390 Miscellaneous Administrative Expenses,\" and Misc Admin Expenses for Commercial space in Column E.\nd.  Line 47  Other Services Expenses - this Account is to record salary costs and benefits of the Service Coordinators. (Enter details in the\n     section labelled \"Account 6990 Other Supportive Services Costs\" and the amounts will auto-populate Line 47.) If Project is regulated by \n     the 2017 HCD Uniform Multifamily Regulations, this Account is to record the Cost of Providing Tenants Service Coordination, Case\n     Management, and Direct Resident and Supportive Services costs - see §8301 (t) and (u). For SUHRP and CHRP-R Programs: this Account\n     is to record Tenant Care Expenses for Group and Nursing Homes, Assisted Living facilities, and Board and Care facilities.\ne.  Important: Any costs anticipated to be capitalized should not be included in the Cost of Operations."]
["5. SUBMITTAL INSTRUCTIONS -- Worksheets (tabs) 2, 3 and 4:"]
["a. Complete the following tabs within the Operating Budget Workbook:\n     Tab 2. Form 170 - Checklist and Certification\n     Tab 3. Form 171 - Proposed Cash Flow\n     Tab 4. Form 172 - Proposed Cost of Operations\nb. Save the Operating Budget Workbook file for your records.\nc. Obtain approval from the Borrower or the Authorized Representative(s) and fill in the Certification area(s) on Worksheet/Tab 2.\nd. Email the fully completed Operating Budget Workbook in Excel format (not PDF) to 'The Box (Insert Link)' for combined HCD/CalHFA\n    developments. CalHFA only funded devleopments, submit to AssetManagement@calhfa.ca.gov and \"CC\" your MultiFamily (MF) Asset\n    Manager. For HCD only funded developments, submit to AMCBranch@hcd.ca.gov and \"CC\" your AMC Representative.\n"]
["6. INTERNAL AGENCY REVIEW AND APPROVAL -- Worksheets 173, 174 & 175 (tabs 5, 6 and 7):"]
["a.  The following Worksheets are for Agency use only:\n     Tab 5. Form 173 -  Approved Cost of Operations \n     Tab 6. Form 174 -  Approved Proration of Cost of Operations \n     Tab 7. Form 175 -  Approved Cash Flow Analysis\nb.  Once the review and approval of these tabs are complete, the Representative/Asset Manager will complete the green-shaded cells in Tab\n     2 – Form 170 (Checklist and Certification). They will then email the Excel Workbook, including any additional approvals or conditions, to the\n     Management Agent, Borrower, or Sponsor for record-keeping.\nc.  The 'Approved' data entered by the Representative/Asset Manager in Tabs 5, 6, and 7 will automatically populate Tabs 8 and 9. This\n     approved data will be utilized at the end of the Project’s Fiscal Year for the Annual Report if the Project is not required to submit Audited \n     Financial Statements. \t\t"]
["7. INTERNAL HCD ONLY - ANNUAL REPORT - Worksheets 180 & 181 (tabs 8 and 9):"]
["a. The Sponsor is required to complete all yellow-shaded fields in this Workbook. \nb. IMPORTANT: These worksheets are to be completed only if the Project is not required to submit Audited Financial Statements, or if the\n    Project is required to submit Audited Financial Statements but the submitted Audit does not include the supplemental information as\n    described in the Financial Statement Audit Handbook (refer to the 's website link in Section 1 above).\nc. These worksheets are due, along with other required forms, following the end of the Project's Fiscal Year for which this Operating Budget\n    has been prepared. Please visit the Department's website (refer to the website's link in Section 1 above) for further instructions regarding\n    the submission of the Project's Annual Report, including the CPA-certified Audit Report.\nd. Upon completion of tabs 8. Form 180 - Actual Cost of Operations and 9. Form 181 - Actual Cash Flow Analysis, the entire\n    completed Excel Workbook must be emailed to  as part of the Annual Report and the Audit Report (if required by the Regulatory\n    Agreement), and other forms as required by the  Program.\ne. Upon completing these tabs, the HCD Representative(s) will fill out the green-shaded Annual Report  HCD Representative \n    Approval section on Worksheet/Tab 2. Form 170 - Checklist and Certification; and will email back the Excel Workbook with any\n    additional approvals or conditions to the Management Agent, Borrower, or Sponsor to be retained for their records."]

{"sheet":" 2. Checklist and Cert - 170","index":1,"n_rows":56,"n_cols":14,"rows_kept":56,"cut":false,"hidden":false,"merged":[[38,2,38,6],[38,7,38,10],[31,3,31,7],[34,0,34,11],[36,0,36,11],[35,0,35,1],[35,2,35,11],[37,2,37,6],[37,7,37,10],[33,0,33,11],[32,3,32,7],[32,8,32,10],[32,0,32,2],[31,0,31,2],[30,0,30,11],[29,0,29,11],[31,8,31,10],[18,3,18,7],[19,3,19,7],[18,8,18,10],[19,8,19,10],[21,2,21,11],[21,0,21,1],[23,2,23,6],[24,2,24,6],[23,7,23,10],[24,7,24,10],[27,0,27,1],[28,0,28,1],[22,0,22,11],[26,0,26,11],[9,0,9,2],[12,0,12,1],[13,0,13,1],[14,0,14,1],[17,0,17,2],[18,0,18,2],[17,3,17,11],[19,0,19,2],[1,8,1,10],[15,0,15,11],[25,0,25,11],[16,0,16,11],[20,0,20,11],[11,0,11,11],[7,0,7,2],[7,3,7,6],[2,0,2,2],[3,0,3,2],[4,0,4,2],[5,0,5,2],[8,8,8,10],[9,4,9,5],[9,6,9,7],[0,0,0,11],[10,9,10,10],[2,7,2,10],[8,3,8,6],[5,3,5,6],[4,3,4,6],[8,0,8,2],[2,3,2,6],[1,0,1,2],[4,7,4,10],[5,7,5,11],[3,7,3,10],[3,3,3,6],[6,0,6,2],[6,8,6,11],[6,3,6,6]]}
["Combined Operating Budget Checklist and Certification",null,null,null,null,null,null,null,null,null,null,null,null,"Alameda"]
["Reporting Period:",null,null,null,"to",null,null,{"$f":"IF(ISNUMBER(SEARCH(\"*MHP*\",ContractNumber)),\"Number of Restricted Units\",\"\")","v":""},{"$f":"IF(SUMPRODUCT(-- (ISNUMBER(SEARCH({\"*AHSC*\",\"*FMTW*\",\"*FWHG*\",\"*GHI*\",\"*HOME\",\"*MHP*\",\"*NPLH*\",\"*TOD*\",\"*VHHP*\"},D5:D7)))),\"Number of Restricted Units: \",\"Number of Assisted Units: \")","v":"Number of Assisted Units: "},null,null,null,{"$f":"IF(I2=\"Number of Restricted Units: \",\"Restricted\",\"Assisted\")","v":"Assisted"},"Alpine"]
["Project Name:",null,null,null,null,null,null,"Total Number of Units: ",null,null,null,null,null,"Amador"]
["Project Location-County:  ",null,null,null,null,null,null,{"$f":"CONCATENATE(' 2. Checklist and Cert - 170'!M2,\" Units\",\"/Total Units Prorata: \")","v":"Assisted Units/Total Units Prorata: "},null,null,null,{"$f":"IF(L3=0,0,L2/L3)","v":0},null,"Butte"]
["1. HCD/CalHFA #:  ",null,null,null,null,null,null,"Other Prorata % Used: ",null,null,null,null,null,"Calaveras"]
["2. HCD/CalHFA #:  ",null,null,null,null,null,null,"Approved Other Prorata % based on:",null,null,null,null,null,"Colusa"]
["3. HCD/CalHFA #:  ",null,null,null,null,null,null,null,null,null,null,null,null,"Contra Costa"]
["4. HCD/CalHFA #:  ",null,null,null,null,null,null,null,null,null,null,null,null,"Del Norte"]
["Prepared by:",null,null,null,null,null,null,null,"Date Revised:",null,null,null,null,"El Dorado"]
["Date Prepared:",null,null,null,"Phone #:",null,null,null,null,null,null,null,null,"Fresno"]
[null,null,null,null,null,null,null,null,null,"Operating Budget Version:",null,{"$f":"'1. Operating Budget Instruction'!K1","v":"2025-04-16"},null,"Glenn"]
["Checklist of Required Items",null,null,null,null,null,null,null,null,null,null,null,null,"Humboldt"]
[null,null,"Tab 170 - Checklist and Certification",null,null,null,null,null,null,null,null,null,null,"Imperial"]
[null,null,"Tab 171 - Proposed Cash Flow",null,null,null,null,null,null,null,null,null,null,"Inyo"]
[null,null,"Tab 172 - Proposed Cost of Operations",null,null,null,null,null,null,null,null,null,null,"Kern"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Kings"]
["Operating Budget Certification: By selecting the applicable Certifier Type and completing the remainder of this block, I certify that I am authorized to provide the information contained in the Checklist and Certification, Proposed Cash Flow, and Proposed Cost of Operations worksheets and it is accurate to the best of my knowledge.",null,null,null,null,null,null,null,null,null,null,null,null,"Lake"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Lassen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Los Angeles"]
["Certifier Type",null,null,"Name",null,null,null,null,"Title",null,null,"Date",null,"Madera"]
["HCD/CalHFA Representative Approval (for HCD/CalHFA Use only):",null,null,null,null,null,null,null,null,null,null,null,null,"Mariposa"]
[null,null,"I hereby approve this Operating Budget through the Approved Cash Flow worksheet",null,null,null,null,null,null,null,null,null,null,"Mendocino"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Merced"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Modoc"]
[null,null,"Name",null,null,null,null,"Title",null,null,null,"Date",null,"Mono"]
["Annual Report - Required Items (only for HCD Projects not required to submit Audited Financial Statements)",null,null,null,null,null,null,null,null,null,null,null,null,"Monterey"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Napa"]
[null,null,"Actual Cash Flow",null,null,null,null,null,null,null,null,null,null,"Nevada"]
[null,null,"Actual Cost of Operations",null,null,null,null,null,null,null,null,null,null,"Orange"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Placer"]
["Annual Report Certification: By selecting the applicable Certifier Type and completing the remainder of this block, I certify that I am authorized to provide the information contained in the Actual Cash Flow and Actual Cost of Operations worksheets as well as the Schedule of Rental Income (SRI), and it is accurate to the best of my knowledge.",null,null,null,null,null,null,null,null,null,null,null,null,"Plumas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Riverside"]
["Certifier Type",null,null,"Name",null,null,null,null,"Title",null,null,"Date",null,"Sacramento"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"San Benito"]
["Representative Approval (for HCD/CalHFA Use only):",null,null,null,null,null,null,null,null,null,null,null,null,"San Diego"]
[null,null,"I hereby approve this Annual Report - Actual Cost of Operations and Actual Cash Flow worksheets",null,null,null,null,null,null,null,null,null,null,"San Francisco"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"San Joaquin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"San Luis Obispo"]
[null,null,"Name",null,null,null,null,"Title",null,null,null,"Date",null,"San Mateo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Santa Barbara"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Santa Clara"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Santa Cruz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Shasta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sierra"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Siskiyou"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Solano"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sonoma"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Stanislaus"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sutter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tehama"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Trinity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tulare"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tuolumne"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ventura"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yolo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yuba"]

{"sheet":"3. Proposed Cash Flow -171","index":2,"n_rows":107,"n_cols":13,"rows_kept":107,"cut":false,"hidden":false,"merged":[[1,10,1,11],[2,10,2,11],[3,10,3,11],[4,10,4,11],[5,10,5,11],[70,0,71,0],[70,1,70,5],[66,1,66,2],[53,1,53,2],[60,1,60,2],[68,1,68,2],[56,1,56,2],[62,1,62,2],[50,1,50,2],[21,1,21,2],[22,1,22,2],[24,1,24,2],[25,1,25,2],[7,1,8,2],[64,1,64,2],[65,1,65,2],[7,5,8,5],[7,8,8,8],[7,10,8,10],[7,12,8,12],[2,4,2,5],[3,4,3,5],[4,4,4,5],[5,4,5,5],[36,1,36,2],[37,1,37,2],[7,9,8,9],[2,6,2,7],[3,6,3,7],[4,6,4,7],[5,6,5,7],[14,1,14,2],[20,1,20,2],[7,7,8,7],[7,6,8,6],[9,1,9,2],[10,1,10,2],[11,1,11,2],[106,1,106,5],[86,1,86,5],[103,1,103,5],[104,1,104,5],[105,1,105,5],[106,6,106,7],[104,6,104,7],[105,6,105,7],[102,6,102,7],[97,6,97,7],[86,6,86,7],[94,6,94,7],[102,1,102,5],[88,1,88,5],[89,1,89,5],[93,1,93,5],[94,1,94,5],[92,1,92,7],[89,6,89,7],[88,6,88,7],[90,1,90,5],[99,1,99,5],[103,6,103,7],[101,1,101,7],[63,1,63,2],[48,1,48,2],[43,1,43,2],[44,1,44,2],[47,1,47,2],[38,1,38,2],[15,1,15,2],[13,1,13,2],[16,1,16,2],[17,1,17,2],[19,1,19,2],[18,1,18,2],[30,1,30,2],[54,1,54,2],[49,1,49,2],[33,1,33,2],[34,1,34,2],[55,1,55,2],[61,1,61,2],[46,1,46,2],[35,1,35,2],[39,1,39,2],[71,1,71,7],[70,6,70,7],[80,1,80,5],[90,6,90,7],[87,6,87,7],[95,6,95,7],[75,6,75,7],[74,6,74,7],[85,1,85,7],[80,6,80,7],[76,1,76,5],[73,1,73,5],[74,1,74,5],[75,1,75,5],[82,6,82,7],[87,1,87,5],[95,1,95,5],[73,6,73,7],[76,6,76,7],[83,6,83,7],[79,6,79,7],[99,6,99,7],[93,6,93,7],[97,1,97,5],[96,6,96,7],[83,1,83,5],[77,1,77,7],[81,6,81,7],[82,1,82,5],[78,1,78,7],[81,1,81,5],[79,1,79,5],[98,1,98,5],[96,1,96,5],[98,6,98,7],[107,1,107,10],[84,1,84,7],[91,1,91,7],[100,1,100,7],[6,1,6,2],[7,0,8,0],[7,3,8,3],[7,11,8,11],[0,0,0,12],[72,6,72,7],[7,4,8,4],[12,1,12,2],[72,1,72,5],[3,0,3,1],[4,0,4,1],[5,0,5,1],[29,1,29,2],[28,1,28,2],[23,1,23,2],[26,1,26,2],[27,1,27,2],[45,1,45,2],[31,1,31,2],[32,1,32,2]]}
["Proposed Cash Flow"]
[null,{"$f":"'1. Operating Budget Instruction'!K1","v":"2025-04-16"},{"$f":"+'4. Proposed Cost of Ops - 172'!C2","v":"Reporting Period:"},{"$f":"IF(' 2. Checklist and Cert - 170'!D2=\"\",\"\",' 2. Checklist and Cert - 170'!D2)","v":""},{"$f":"+'4. Proposed Cost of Ops - 172'!F2","v":"to"},{"$f":"IF(' 2. Checklist and Cert - 170'!F2=\"\",\"\",' 2. Checklist and Cert - 170'!F2)","v":""},null,null,null,null,"Date Prepared:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!D10=\"\",\"\",' 2. Checklist and Cert - 170'!D10)","v":""}]
[null,null,null,null,{"$f":"' 2. Checklist and Cert - 170'!A5","v":"1. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D5=\"\",\"\",' 2. Checklist and Cert - 170'!D5)","v":""},null,null,null,"Date Revised:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!L9=\"\",\"\",' 2. Checklist and Cert - 170'!L9)","v":""}]
["Project Name:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!D3=\"\",\"\",' 2. Checklist and Cert - 170'!D3)","v":""},null,{"$f":"' 2. Checklist and Cert - 170'!A6","v":"2. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D6=\"\",\"\",' 2. Checklist and Cert - 170'!D6)","v":""},null,null,null,{"$f":"CONCATENATE(' 2. Checklist and Cert - 170'!M2,\" Units:\")","v":"Assisted Units:"},null,{"$f":"IF(' 2. Checklist and Cert - 170'!L2=\"\",0,' 2. Checklist and Cert - 170'!L2)","v":0}]
["Project County:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!D4=\"\",\"\",' 2. Checklist and Cert - 170'!D4)","v":""},null,{"$f":"' 2. Checklist and Cert - 170'!A7","v":"3. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D7=\"\",\"\",' 2. Checklist and Cert - 170'!D7)","v":""},null,null,null,"Total Units:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!L3=\"\",0,' 2. Checklist and Cert - 170'!L3)","v":0}]
["Prepared By:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!D9=\"\",\"\",' 2. Checklist and Cert - 170'!D9)","v":""},null,{"$f":"' 2. Checklist and Cert - 170'!A8","v":"4. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D8=\"\",\"\",' 2. Checklist and Cert - 170'!D8)","v":""},null,null,null,"Proration %:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0}]
[null,null,null,null,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)"]
["Line #","Account Name",null,"Account\nCode","Total Proposed Budget",{"$f":"CONCATENATE(' 2. Checklist and Cert - 170'!$M$2,\" Units Proposed\")","v":"Assisted Units Proposed"},{"$f":"CONCATENATE(\"Non-\",' 2. Checklist and Cert - 170'!$M$2,\" Units Proposed\")","v":"Non-Assisted Units Proposed"},"Commercial Proposed","Current Year 8 Month Actuals","12 Month Actuals Projected","Budget vs. Current Year 12 Months   $ Variance","Budget vs. Current Year 12 Months   % Variance","Comments or Variance Explanation"]
[]
[null,"Rent Revenue:"]
[1,"Rent Revenue - Gross Potential",null,5120,{"$f":"SUM(F11:H11)","v":0},0,0,null,0,{"$f":"SUM(I11/8)*12","v":0},{"$f":"E11-J11","v":0},{"$f":"IFERROR(K11/J11,0)","v":0}]
[2,"Tenant Assistance Payments",null,5121,{"$f":"SUM(F12:H12)","v":0},0,0,null,0,{"$f":"SUM(I12/8)*12","v":0},0,{"$f":"IFERROR(K12/J12,0)","v":0}]
[3,"Rent Revenue - Stores and Commercial",null,5140,{"$f":"SUM(F13:H13)","v":0},null,null,0,0,0,0,0]
[4,"Garage and Parking Spaces",null,5170,{"$f":"SUM(F14:H14)","v":0},0,0,0,0,0,0,0]
[5,"Flexible Subsidy Revenue",null,5180,{"$f":"SUM(F15:H15)","v":0},0,0,0,0,0,0,0]
[6,"Miscellaneous Rent Revenue",null,5190,{"$f":"G77","v":0},{"$f":"(E16-H16)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"E16-F16-H16","v":0},0,0,0,0,0]
[7,"Total Rent Revenue",null,"5100T",{"$f":"SUM(E11:E16)","v":0},{"$f":"SUM(F11:F16)","v":0},{"$f":"SUM(G11:G16)","v":0},{"$f":"SUM(H11:H16)","v":0},{"$f":"SUM(I11:I16)","v":0},0,0,0]
[null,"Vacancies:"]
[8,"Vacancy %",null,null,null,0,0,0,null,null,{"$f":"E19-J19","v":0}]
[9,"Apartments",null,5220,{"$f":"SUM(F20:H20)","v":0},{"$f":"SUM(F11+F12)*F19","v":0},{"$f":"SUM(G11+G12)*G19","v":0},null,0,{"$f":"SUM(I20/8)*12","v":0},0,{"$f":"IFERROR(K20/J20,0)","v":0}]
[10,"Stores and Commercial",null,5240,{"$f":"SUM(F21:H21)","v":0},null,null,{"$f":"H19*H13","v":0},0,0,0,{"$f":"IFERROR(K21/J21,0)","v":0}]
[11,"Rental Concessions",null,5250,{"$f":"SUM(F22:H22)","v":0},0,0,0,0,0,0,0]
[12,"Garage and Parking Spaces",null,5270,{"$f":"SUM(F23:H23)","v":0},0,0,0,0,0,0,0]
[13,"Miscellaneous Vacancies",null,5290,{"$f":"SUM(F24:H24)","v":0},0,0,0,0,0,0,0]
[14,"Total Vacancies",null,"5200T",{"$f":"SUM(E20:E24)","v":0},{"$f":"SUM(F20:F24)","v":0},{"$f":"SUM(G20:G24)","v":0},{"$f":"SUM(H20:H24)","v":0},{"$f":"SUM(I20:I24)","v":0},0,0,0]
[15,"Net Rental Revenues (Rent Revenue Less Vacancies)",null,"5152N",{"$f":"E17-E25","v":0},{"$f":"F17-F25","v":0},{"$f":"G17-G25","v":0},{"$f":"H17-H25","v":0},{"$f":"I17-I25","v":0},0,0,0]
[16,"Supportive Services Revenue (enter detail in lines 59-62):",null,5390,{"$f":"G84","v":0},{"$f":"(E27-H27)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"E27-F27-H27","v":0},0,0,0,0,0]
[null,"Financial Revenue:"]
[17,"Financial Revenue (don't incl. Reserve Acct. Interest)",null,5410,0,{"$f":"(E29-H29)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"E29-F29-H29","v":0},0,0,{"$f":"SUM(I29/8)*12","v":0},{"$f":"E29-J29","v":0},{"$f":"IFERROR(K29/J29,0)","v":0}]
[18,"Revenue from Investments- Miscellaneous",null,5490,{"$f":"G91","v":0},{"$f":"(E30-H30)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"E30-F30-H30","v":0},0,0,0,{"$f":"E30-J30","v":0},0]
[19,"Total Financial Revenue",null,"5400T",{"$f":"SUM(E29:E30)","v":0},{"$f":"SUM(F29:F30)","v":0},{"$f":"SUM(G29:G30)","v":0},{"$f":"SUM(H29:H30)","v":0},{"$f":"SUM(I29:I30)","v":0},0,{"$f":"E31-J31","v":0},0]
[null,"Other Revenue:"]
[20,"Laundry and Vending Revenue",null,5910,0,{"$f":"(E33-H33)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"E33-F33-H33","v":0},0,0,{"$f":"SUM(I33/8)*12","v":0},{"$f":"E33-J33","v":0},{"$f":"IFERROR(K33/J33,0)","v":0}]
[21,"Tenant Charges",null,5920,0,{"$f":"(E34-H34)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"E34-F34-H34","v":0},0,0,0,0,0]
[22,"Misc. Revenue (don't include Reserve Withdrawals)",null,5990,{"$f":"G100","v":0},{"$f":"(E35-H35)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"E35-F35-H35","v":0},0,0,0,0,0]
[23,"Total Other Revenue",null,"5900T",{"$f":"SUM(E33:E35)","v":0},{"$f":"SUM(F33:F35)","v":0},{"$f":"SUM(G33:G35)","v":0},{"$f":"SUM(H33:H35)","v":0},{"$f":"SUM(I33:I35)","v":0},0,0,0]
[24,"Total Revenue",null,"5000T",{"$f":"E26+E27+E31+E36","v":0},{"$f":"F26+F27+F31+F36","v":0},{"$f":"G26+G27+G31+G36","v":0},{"$f":"H26+H27+H31+H36","v":0},{"$f":"I26+I27+I31+I36","v":0},0,0,0]
[25,"Total Cost of Operations before Depreciation",null,"6000T",{"$f":"'4. Proposed Cost of Ops - 172'!E64","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!G64","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!H64","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I64","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!J64","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!K64","v":0},0,0]
[26,"Profit (Loss) before Depreciation",null,"5060T",{"$f":"E37-E38","v":0},{"$f":"F37-F38","v":0},{"$f":"G37-G38","v":0},{"$f":"H37-H38","v":0},{"$f":"I37-I38","v":0},0,0,0]
[null,"Financial Expenses including mandatory debt service:"]
[27,"1st Mortgage (P&I)",null,6820,0,{"$f":"(E41-H41)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"E41-F41-H41","v":0},0,0,{"$f":"SUM(I41/8)*12","v":0},{"$f":"E41-J41","v":0},{"$f":"IFERROR(K41/J41,0)","v":0}]
[28,"2nd Mortgage (P&I)",null,6825,0,{"$f":"(E42-H42)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0]
[29,"3rd Mortgage (P&I)",null,6825,0,{"$f":"(E43-H43)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0]
[30,"HCD Req. Payments & CalHFA Servicing/Monitoring Fee",null,6825,0,{"$f":"(E44-H44)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0]
[31,"Lease Payment",null,6890,0,{"$f":"(E45-H45)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0]
[32,"Miscellaneous Financial Expenses",null,6890,{"$f":"G107","v":0},{"$f":"(E46-H46)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0]
[33,"Total Financial Expenses",null,"6800T",{"$f":"SUM(E41:E46)","v":0},{"$f":"SUM(F41:F46)","v":0},{"$f":"SUM(G41:G46)","v":0},{"$f":"SUM(H41:H46)","v":0},{"$f":"SUM(I41:I46)","v":0},0,0,0]
[null,"Reserves Deposits:"]
[34,"Replacement Reserve - Deposit",null,1320,0,{"$f":"(E49-H49)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"E49-F49-H49","v":0},0,0,{"$f":"SUM(I49/8)*12","v":0},{"$f":"E49-J49","v":0},{"$f":"IFERROR(K49/J49,0)","v":0}]
[35,"Operating Reserve - Deposit",null,1330,0,{"$f":"(E50-H50)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"E50-F50-H50","v":0},0,0,0,0,0]
[36,"Transition Reserve  - Deposit",null,1330,0,{"$f":"(E51-H51)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"E51-F51-H51","v":0},0,0,0,0,0]
[37,"Other (specify)",null,1330,0,{"$f":"(E52-H52)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"E52-F52-H52","v":0},0,0,0,0,0]
[38,"Other (specify)",null,1330,0,{"$f":"(E53-H53)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"E53-F53-H53","v":0},0,0,0,0,0]
[39,"Total Reserves Deposits",null,"1300T",{"$f":"SUM(E49:E53)","v":0},{"$f":"SUM(F49:F53)","v":0},{"$f":"SUM(G49:G53)","v":0},{"$f":"SUM(H49:H53)","v":0},{"$f":"SUM(I49:I53)","v":0},0,0,0]
[40,"Project Cash Flow",null,null,{"$f":"E39-E47-E54","v":0},{"$f":"F39-F47-F54","v":0},{"$f":"G39-G47-G54","v":0},{"$f":"H39-H47-H54","v":0},{"$f":"I39-I47-I54","v":0},0,0,0]
[null,"Additions to Cash Flow:"]
[41,"Borrower Contribution",null,null,0,{"$f":"(E57-H57)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"E57-F57-H57","v":0},0,0,{"$f":"SUM(I57/8)*12","v":0},{"$f":"E57-J57","v":0},{"$f":"IFERROR(K57/J57,0)","v":0}]
[42,"Other (specify)",null,null,0,{"$f":"(E58-H58)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"E58-F58-H58","v":0},0,0,0,{"$f":"E58-J58","v":0},0]
[43,"Other (specify)",null,null,0,{"$f":"(E59-H59)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"E59-F59-H59","v":0},0,0,0,{"$f":"E59-J59","v":0},0]
[44,"Other (specify)",null,null,0,{"$f":"(E60-H60)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"E60-F60-H60","v":0},0,0,0,{"$f":"E60-J60","v":0},0]
[45,"Total Additional Revenue",null,null,{"$f":"SUM(E57:E60)","v":0},{"$f":"SUM(F57:F60)","v":0},{"$f":"SUM(G57:G60)","v":0},{"$f":"SUM(H57:H60)","v":0},{"$f":"SUM(I57:I60)","v":0},0,{"$f":"E61-J61","v":0},0]
[null,"Use of Cash Flow (final approval with Annual Report):"]
[46,"Deferred Developer Fee Payments",null,"",0,{"$f":"(E63-H63)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"E63-F63-H63","v":0},0,0,{"$f":"SUM(I63/8)*12","v":0},{"$f":"E63-J63","v":0},{"$f":"IFERROR(K63/J63,0)","v":0}]
[47,"Asset Management Fee/Partnership Costs",null,7190,0,{"$f":"(E64-H64)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0]
[48,"Borrower Distributions",null,null,0,{"$f":"(E65-H65)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0]
[49,"Residual Receipt Loan Payments",null,null,0,{"$f":"(E66-H66)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0]
[50,"HCD Interest Payments",null,"",0,{"$f":"(E67-H67)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0]
[51,"Other (specify)",null,null,0,{"$f":"(E68-H68)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0]
[52,"Total Use of Cash Flow",null,null,{"$f":"SUM(E63:E68)","v":0},{"$f":"SUM(F63:F68)","v":0},{"$f":"SUM(G63:G68)","v":0},{"$f":"SUM(H63:H68)","v":0},{"$f":"SUM(I63:I68)","v":0},0,0,0]
[]
["Item #","For each account below, itemize the revenues/expenses (total will flow to account above)",null,null,null,null,"Amount"]
[null,"Account 5190 Miscellaneous Rent Revenue"]
[54]
[55]
[56]
[57]
[58,"Total Account 5190 Miscellaneous Rent Revenue",null,null,null,null,{"$f":"SUM(G73:H76)","v":0}]
[]
[null,"Account 5390 Supportive Services Revenue"]
[59]
[60]
[61]
[62]
[63,"Total Account 5390 Other Service Revenue",null,null,null,null,{"$f":"SUM(G80:H83)","v":0}]
[]
[null,"Account 5490 Revenue from Investments- Miscellaneous"]
[64]
[65]
[66]
[67]
[68,"Total Account 5490 Revenue from Investments- Miscellaneous",null,null,null,null,{"$f":"SUM(G87:H90)","v":0}]
[]
[null,"Account 5990 Miscellaneous Revenue"]
[69]
[70]
[71]
[72]
[73]
[74]
[75,"Total Account 5990 Miscellaneous Revenue",null,null,null,null,{"$f":"SUM(G94:H99)","v":0}]
[]
[null,"Account 6890 Miscellaneous Financial Expenses"]
[76,null,null,null,null,null,0]
[77]
[78]
[79]
[80,"Total Account 6890 Miscellaneous Financial Expenses",null,null,null,null,{"$f":"SUM(G103:H106)","v":0}]

{"sheet":"4. Proposed Cost of Ops - 172","index":3,"n_rows":124,"n_cols":15,"rows_kept":124,"cut":false,"hidden":false,"merged":[[1,10,1,12],[1,7,1,8],[3,0,3,1],[4,0,4,1],[1,2,1,3],[5,0,5,1],[0,0,0,13],[8,10,9,10],[8,11,9,11],[8,0,9,0],[8,1,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8],[8,9,9,9],[8,13,9,13],[2,10,2,12],[3,10,3,12],[4,10,4,12],[5,10,5,12],[2,4,2,5],[2,6,2,7],[3,4,3,5],[3,6,3,7],[4,4,4,5],[4,6,4,7],[5,4,5,5],[5,6,5,7],[6,0,6,9],[7,1,7,2],[50,1,50,2],[66,1,66,9],[71,8,71,9],[68,8,68,9],[49,1,49,2],[62,1,62,2],[60,1,60,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[65,1,65,7],[65,8,65,9],[55,1,55,2],[69,1,69,7],[70,1,70,7],[71,1,71,7],[63,1,63,2],[61,1,61,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[90,8,90,9],[87,1,87,9],[78,1,78,7],[81,1,81,7],[88,1,88,7],[89,1,89,7],[98,8,98,9],[67,1,67,7],[90,1,90,7],[93,1,93,7],[94,1,94,7],[94,8,94,9],[89,8,89,9],[85,1,85,7],[68,1,68,7],[74,8,74,9],[79,8,79,9],[80,8,80,9],[81,8,81,9],[79,1,79,7],[80,1,80,7],[67,8,67,9],[85,8,85,9],[75,8,75,9],[95,8,95,9],[96,8,96,9],[97,8,97,9],[99,1,99,7],[98,1,98,7],[91,8,91,9],[92,8,92,9],[99,8,99,9],[95,1,95,7],[93,8,93,9],[91,1,91,7],[92,1,92,7],[123,1,123,7],[123,8,123,9],[120,8,120,9],[121,8,121,9],[122,1,122,7],[117,1,117,7],[118,1,118,7],[100,1,100,7],[96,1,96,7],[97,1,97,7],[105,1,105,7],[104,1,104,7],[116,1,116,9],[114,8,114,9],[112,1,112,7],[109,8,109,9],[111,1,111,7],[111,8,111,9],[101,8,101,9],[102,8,102,9],[103,8,103,9],[108,1,108,9],[102,1,102,7],[100,8,100,9],[112,8,112,9],[113,8,113,9],[115,1,115,9],[104,8,104,9],[106,1,106,7],[103,1,103,7],[101,1,101,7],[122,8,122,9],[120,1,120,7],[121,1,121,7],[117,8,117,9],[118,8,118,9],[119,8,119,9],[119,1,119,7],[105,8,105,9],[106,8,106,9],[110,8,110,9],[109,1,109,7],[110,1,110,7],[114,1,114,7],[113,1,113,7],[107,1,107,9],[83,8,83,9],[76,8,76,9],[69,8,69,9],[70,8,70,9],[82,1,82,7],[84,8,84,9],[84,1,84,7],[72,8,72,9],[82,8,82,9],[76,1,76,7],[73,8,73,9],[74,1,74,7],[75,1,75,7],[72,1,72,7],[73,1,73,7],[86,1,86,9],[83,1,83,7],[77,8,77,9],[78,8,78,9],[77,1,77,7],[88,8,88,9],[10,1,10,2],[36,1,36,2],[56,1,56,2],[25,1,25,2],[26,1,26,2],[24,1,24,2],[23,1,23,2],[16,1,16,2],[17,1,17,2],[37,1,37,2],[40,1,40,2],[41,1,41,2],[21,1,21,2],[22,1,22,2],[34,1,34,2],[43,1,43,2],[48,1,48,2],[54,1,54,2],[8,12,9,12],[28,1,28,2],[30,1,30,2],[47,1,47,2],[27,1,27,2],[14,1,14,2],[15,1,15,2],[11,1,11,2],[13,1,13,2],[12,1,12,2],[19,1,19,2],[20,1,20,2],[45,1,45,2],[35,1,35,2],[18,1,18,2],[29,1,29,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[46,1,46,2],[38,1,38,2],[39,1,39,2],[44,1,44,2],[42,1,42,2]]}
["Proposed Cost of Operations"]
[null,{"$f":"'1. Operating Budget Instruction'!K1","v":"2025-04-16"},"Reporting Period:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!D2=\"\",\"\",' 2. Checklist and Cert - 170'!D2)","v":""},"to",{"$f":"IF(' 2. Checklist and Cert - 170'!F2=\"\",\"\",' 2. Checklist and Cert - 170'!F2)","v":""},null,null,null,"Date Prepared:",null,null,{"$f":"IF(' 2. Checklist and Cert - 170'!D10=\"\",\"\",' 2. Checklist and Cert - 170'!D10)","v":""}]
[null,null,null,null,{"$f":"' 2. Checklist and Cert - 170'!A5","v":"1. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D5=\"\",\"\",' 2. Checklist and Cert - 170'!D5)","v":""},null,null,null,"Date Revised:",null,null,{"$f":"IF(' 2. Checklist and Cert - 170'!L9=\"\",\"\",' 2. Checklist and Cert - 170'!L9)","v":""}]
["Project Name:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!D3=\"\",\"\",' 2. Checklist and Cert - 170'!D3)","v":""},null,{"$f":"' 2. Checklist and Cert - 170'!A6","v":"2. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D6=\"\",\"\",' 2. Checklist and Cert - 170'!D6)","v":""},null,null,null,{"$f":"CONCATENATE(' 2. Checklist and Cert - 170'!M2,\" Units:\")","v":"Assisted Units:"},null,null,{"$f":"IF(' 2. Checklist and Cert - 170'!L2=\"\",0,' 2. Checklist and Cert - 170'!L2)","v":0}]
["Project County:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!D4=\"\",\"\",' 2. Checklist and Cert - 170'!D4)","v":""},null,{"$f":"' 2. Checklist and Cert - 170'!A7","v":"3. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D7=\"\",\"\",' 2. Checklist and Cert - 170'!D7)","v":""},null,null,null,"Total Units:",null,null,{"$f":"IF(' 2. Checklist and Cert - 170'!L3=\"\",0,' 2. Checklist and Cert - 170'!L3)","v":0}]
["Prepared By:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!D9=\"\",\"\",' 2. Checklist and Cert - 170'!D9)","v":""},null,{"$f":"' 2. Checklist and Cert - 170'!A8","v":"4. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D8=\"\",\"\",' 2. Checklist and Cert - 170'!D8)","v":""},null,null,null,"Proration %:",null,null,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0}]
[]
[null,null,null,null,"(A)\n Total \nBudget\nProposed","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)","(J)"]
["Line #","Account Name",null,"Account\nCode","Total\nProposed Budget","Proration Percentage Proposed",{"$f":"CONCATENATE(' 2. Checklist and Cert - 170'!$M$2,\" Units Proposed\")","v":"Assisted Units Proposed"},{"$f":"CONCATENATE(\"Non-\",' 2. Checklist and Cert - 170'!$M$2,\" Units Proposed\")","v":"Non-Assisted Units Proposed"},"Commercial\nProposed","Current Year 8 Month Actuals","12 Month Actuals Projected","Budget vs. Current Year 12 Months   $ Variance","Budget vs. Current Year 12 Months   % Variance","Comments or Variance Explanation"]
[]
[null,"Administrative Expenses:"]
[1,"Conventions and Meetings",null,6203,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E12-I12)*F12","v":0},{"$f":"+(E12-G12-I12)","v":0},0,0,{"$f":"SUM(J12/8)*12","v":0},{"$f":"E12-K12","v":0},{"$f":"IFERROR(L12/K12,0)","v":0}]
[2,"Management Consultants",null,6204,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E13-I13)*F13","v":0},{"$f":"+(E13-G13-I13)","v":0},0,0,{"$f":"SUM(J13/8)*12","v":0},{"$f":"E13-K13","v":0},{"$f":"IFERROR(L13/K13,0)","v":0}]
[3,"Advertising and Marketing",null,6210,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0,0]
[4,"Other Renting Expenses",null,6250,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0,0]
[5,"Office Salaries",null,6310,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0,0]
[6,"Office Expenses",null,6311,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0,0]
[7,"Office or Model Apartment Rent",null,6312,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0,0]
[8,"Management Fee (do not include GP Management Fee)",null,6320,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0,0]
[9,"Manager or Superintendent Salaries",null,6330,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0,0]
[10,"Administrative Rent Free Unit",null,6331,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0,0]
[11,"Legal Expense - Project",null,6340,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0,0]
[12,"Audit Expense",null,6350,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E23-I23)*F23","v":0},{"$f":"+(E23-G23-I23)","v":0},0,0,0,0,0]
[13,"Bookkeeping Fees/ Accounting Services",null,6351,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E24-I24)*F24","v":0},{"$f":"+(E24-G24-I24)","v":0},0,0,0,0,0]
[14,"Bad Debts",null,6370,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E25-I25)*F25","v":0},{"$f":"+(E25-G25-I25)","v":0},0,0,0,0,0]
[15,"Misc. Administrative Expenses",null,6390,{"$f":"I86","v":0},{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E26-I26)*F26","v":0},{"$f":"+(E26-G26-I26)","v":0},0,0,0,0,0]
[16,"Total Administrative Expenses",null,"6263T",{"$f":"SUM(E12:E26)","v":0},null,{"$f":"SUM(G12:G26)","v":0},{"$f":"SUM(H12:H26)","v":0},{"$f":"SUM(I12:I26)","v":0},{"$f":"SUM(J12:J26)","v":0},0,0,0]
[null,"Utilities:"]
[17,"Electricity",null,6450,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E29-I29)*F29","v":0},{"$f":"+(E29-G29-I29)","v":0},0,0,{"$f":"SUM(J29/8)*12","v":0},{"$f":"E29-K29","v":0},{"$f":"IFERROR(L29/K29,0)","v":0}]
[18,"Water",null,6451,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E30-I30)*F30","v":0},{"$f":"+(E30-G30-I30)","v":0},0,0,0,0,0]
[19,"Gas",null,6452,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E31-I31)*F31","v":0},{"$f":"+(E31-G31-I31)","v":0},0,0,0,0,0]
[20,"Sewer",null,6453,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E32-I32)*F32","v":0},{"$f":"+(E32-G32-I32)","v":0},0,0,0,0,0]
[21,"Total Utilities Expenses",null,"6400T",{"$f":"SUM(E29:E32)","v":0},null,{"$f":"SUM(G29:G32)","v":0},{"$f":"SUM(H29:H32)","v":0},{"$f":"SUM(I29:I32)","v":0},{"$f":"SUM(J29:J32)","v":0},0,0,0]
[null,"Operating and Maintenance Expenses:"]
[22,"Payroll",null,6510,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E35-I35)*F35","v":0},{"$f":"+(E35-G35-I35)","v":0},0,0,{"$f":"SUM(J35/8)*12","v":0},{"$f":"E35-K35","v":0},{"$f":"IFERROR(L35/K35,0)","v":0}]
[23,"Supplies",null,6515,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0,0]
[24,"Contracts",null,6520,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0,0]
[25,"Operating and Maintenance Rent Free Unit",null,6521,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E38-I38)*F38","v":0},{"$f":"+(E38-G38-I38)","v":0},0,0,0,0,0]
[26,"Garbage and Trash Removal",null,6525,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E39-I39)*F39","v":0},{"$f":"+(E39-G39-I39)","v":0},0,0,0,0,0]
[27,"Security Payroll/Contracts",null,6530,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E40-I40)*F40","v":0},{"$f":"+(E40-G40-I40)","v":0},0,0,0,0,0]
[28,"Security Rent Free Unit",null,6531,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E41-I41)*F41","v":0},{"$f":"+(E41-G41-I41)","v":0},0,0,0,0,0]
[29,"Heating/Cooling Repairs and Maintenance",null,6546,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E42-I42)*F42","v":0},{"$f":"+(E42-G42-I42)","v":0},0,0,0,0,0]
[30,"Snow Removal",null,6548,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0,0]
[31,"Vehicle and Maintenance Equip. Operation and Repairs",null,6570,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0,0]
[32,"Lease Expense",null,6580,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E45-I45)*F45","v":0},{"$f":"+(E45-G45-I45)","v":0},0,0,0,0,0]
[33,"Misc. Operating & Maintenance Expenses",null,6590,{"$f":"I107","v":0},{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0,0]
[34,"Total Operating and Maintenance Expenses",null,"6500T",{"$f":"SUM(E35:E46)","v":0},null,{"$f":"SUM(G35:G46)","v":0},{"$f":"SUM(H35:H46)","v":0},{"$f":"SUM(I35:I46)","v":0},{"$f":"SUM(J35:J46)","v":0},0,0,0]
[null,"Taxes and Insurance:"]
[35,"Real Estate Taxes",null,6710,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E49-I49)*F49","v":0},{"$f":"+(E49-G49-I49)","v":0},0,0,{"$f":"SUM(J49/8)*12","v":0},{"$f":"E49-K49","v":0},{"$f":"IFERROR(L49/K49,0)","v":0}]
[36,"Payroll Taxes (Project's Share)",null,6711,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0,0]
[37,"Property & Liability Insurance (Hazard)",null,6720,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E51-I51)*F51","v":0},{"$f":"+(E51-G51-I51)","v":0},0,0,0,0,0]
[38,"Fidelity Bond Insurance",null,6721,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0,0]
[39,"Worker's Compensation",null,6722,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0,0]
[40,"Health Insurance and Other Employee Benefits",null,6723,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0,0]
[41,"Miscellaneous Taxes, Licenses, Permits and Insurance",null,6790,{"$f":"I115","v":0},{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,0,0,0]
[42,"Total Taxes and Insurance",null,"6700T",{"$f":"SUM(E49:E55)","v":0},null,{"$f":"SUM(G49:G55)","v":0},{"$f":"SUM(H49:H55)","v":0},{"$f":"SUM(I49:I55)","v":0},{"$f":"SUM(J49:J55)","v":0},0,0,0]
[null,"Supportive Services Costs:",null,6990]
[43,"Staff Supervisors Salaries",null,{"$f":"IF(E58=0,0,IF(E59+E60=0,1,E58/(E59+E60)))","v":0},0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E58-I58)*F58","v":0},{"$f":"+(E58-G58-I58)","v":0},0,0,{"$f":"SUM(J58/8)*12","v":0},{"$f":"E58-K58","v":0},{"$f":"IFERROR(L58/K58,0)","v":0}]
[44,"On-site Services Coordinator Salaries and Benefits",null,null,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E59-I59)*F59","v":0},{"$f":"+(E59-G59-I59)","v":0},0,0,0,0,0]
[45,"On-site Other Supportive Services Staff Salaries",null,null,0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E60-I60)*F60","v":0},{"$f":"+(E60-G60-I60)","v":0},0,0,0,0,0]
[46,"Supportive Services Administrative Overhead",null,{"$f":"IF(E61=0,0,E61/E63)","v":0},0,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E61-I61)*F61","v":0},{"$f":"+(E61-G61-I61)","v":0},0,0,0,0,0]
[47,"Other Supportive Services Costs",null,6990,{"$f":"I124","v":0},{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(E62-I62)*F62","v":0},{"$f":"+(E62-G62-I62)","v":0},0,0,0,0,0]
[48,"Total Supportive Services Costs",null,"6900T",{"$f":"SUM(E58:E62)","v":0},null,{"$f":"SUM(G58:G62)","v":0},{"$f":"SUM(H58:H62)","v":0},{"$f":"SUM(I58:I62)","v":0},{"$f":"SUM(J58:J62)","v":0},0,0,0]
[49,"Total Cost of Operations",null,"6000T",{"$f":"E27+E33+E47+E56+E63","v":0},null,{"$f":"G27+G33+G47+G56+G63","v":0},{"$f":"H27+H33+H47+H56+H63","v":0},{"$f":"I27+I33+I47+I56+I63","v":0},{"$f":"J27+J33+J47+J56+J63","v":0},0,0,0]
[]
[null,"For each account below, itemize the expenses (total will flow to account above)",null,null,null,null,null,null,"Amount"]
["Line #","Account 6390 Miscellaneous Administrative Expenses"]
[50]
[51,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rep"]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68,"Total Account 6390 Miscellaneous Administrative Expenses",null,null,null,null,null,null,{"$f":"SUM(I68:J85)","v":0}]
[]
[null,"Account 6590 Miscellaneous Operations & Maintenance Expenses"]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87,"Total Account 6590 Miscellaneous Operations & Maintenance Expenses",null,null,null,null,null,null,{"$f":"SUM(I89:J106)","v":0}]
[]
[null,"Account 6790 Misc. Taxes, Licenses, Permits & Insurance"]
[88]
[89]
[90]
[91]
[92]
[93,"Total Account 6790 Misc. Taxes, Licenses, Permits & Insurance",null,null,null,null,null,null,{"$f":"SUM(I110:J114)","v":0}]
[]
[null,"Account 6990 Other Supportive Services Costs"]
[94]
[95]
[96]
[97]
[98]
[99]
[100,"Total Account 6990 Other Supportive Services Costs",null,null,null,null,null,null,{"$f":"SUM(I118:J123)","v":0}]

{"sheet":"5. Approved Cash Flow - 173","index":4,"n_rows":70,"n_cols":17,"rows_kept":70,"cut":false,"hidden":false,"merged":[[3,7,3,8],[69,1,69,2],[70,0,70,11],[7,10,7,11],[7,6,7,7],[7,8,7,9],[51,1,51,2],[63,1,63,2],[44,1,44,2],[45,1,45,2],[48,1,48,2],[46,1,46,2],[57,1,57,2],[66,1,66,2],[67,1,67,2],[64,1,64,2],[65,1,65,2],[62,1,62,2],[55,1,55,2],[3,5,3,6],[49,1,49,2],[50,1,50,2],[47,1,47,2],[54,1,54,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[26,1,26,2],[35,1,35,2],[28,1,28,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[27,1,27,2],[37,1,37,2],[34,1,34,2],[36,1,36,2],[30,1,30,2],[29,1,29,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[25,1,25,2],[24,1,24,2],[4,0,4,1],[3,2,3,4],[4,2,4,4],[5,2,5,3],[20,1,20,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[19,1,19,2],[17,1,17,2],[18,1,18,2],[6,0,6,1],[0,0,0,11],[11,1,11,2],[5,0,5,1],[5,5,5,6],[5,7,5,8],[7,0,9,0],[7,1,7,3],[10,1,10,2],[3,0,3,1],[8,3,9,3],[8,1,9,2],[7,4,7,5],[2,5,2,6],[4,7,4,8],[4,5,4,6],[2,7,2,8]]}
["Approved Cash Flow"]
[null,{"$f":"'1. Operating Budget Instruction'!K1","v":"2025-04-16"},null,"Reporting Period:",{"$f":"IF(' 2. Checklist and Cert - 170'!D2=\"\",\"\",' 2. Checklist and Cert - 170'!D2)","v":""},"to",{"$f":"IF(' 2. Checklist and Cert - 170'!F2=\"\",\"\",' 2. Checklist and Cert - 170'!F2)","v":""},null,null,null,"Date Prepared:",{"$f":"IF(' 2. Checklist and Cert - 170'!D10=\"\",\"\",' 2. Checklist and Cert - 170'!D10)","v":""}]
[null,null,null,null,null,{"$f":"' 2. Checklist and Cert - 170'!A5","v":"1. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D5=\"\",\"\",' 2. Checklist and Cert - 170'!D5)","v":""},{"$f":"' 2. Checklist and Cert - 170'!J2","v":0},null,"Date Revised:",{"$f":"IF(' 2. Checklist and Cert - 170'!L9=\"\",\"\",' 2. Checklist and Cert - 170'!L9)","v":""}]
["Project Name:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!D3=\"\",\"\",' 2. Checklist and Cert - 170'!D3)","v":""},null,null,{"$f":"' 2. Checklist and Cert - 170'!A6","v":"2. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D6=\"\",\"\",' 2. Checklist and Cert - 170'!D6)","v":""},{"$f":"' 2. Checklist and Cert - 170'!J3","v":0},null,{"$f":"CONCATENATE(' 2. Checklist and Cert - 170'!M2,\" Units:\")","v":"Assisted Units:"},{"$f":"IF(' 2. Checklist and Cert - 170'!L2=\"\",0,' 2. Checklist and Cert - 170'!L2)","v":0}]
["Project County:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!D4=\"\",\"\",' 2. Checklist and Cert - 170'!D4)","v":""},null,null,{"$f":"' 2. Checklist and Cert - 170'!A7","v":"3. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D7=\"\",\"\",' 2. Checklist and Cert - 170'!D7)","v":""},{"$f":"' 2. Checklist and Cert - 170'!J4","v":0},null,"Total Units:",{"$f":"IF(' 2. Checklist and Cert - 170'!L3=\"\",0,' 2. Checklist and Cert - 170'!L3)","v":0}]
["Approved By:",null,null,null,null,{"$f":"' 2. Checklist and Cert - 170'!A8","v":"4. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D8=\"\",\"\",' 2. Checklist and Cert - 170'!D8)","v":""},{"$f":"' 2. Checklist and Cert - 170'!J5","v":0},null,"Proration %:",{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0}]
[]
["Line #","HCD/CalHFA use only",null,null,{"$f":"CONCATENATE(' 2. Checklist and Cert - 170'!$M$2,\" Units\")","v":"Assisted Units"},{"$f":"CONCATENATE(' 2. Checklist and Cert - 170'!$M$2,\" Units\")","v":"Assisted Units"},{"$f":"CONCATENATE(\"Non-\",' 2. Checklist and Cert - 170'!$M$2,\" Units\")","v":"Non-Assisted Units"},{"$f":"CONCATENATE(\"Non-\",' 2. Checklist and Cert - 170'!$M$2,\" Units\")","v":"Non-Assisted Units"},"Commercial",null,"Total Project"]
[null,"Account Name",null,"Acct.\nCode","(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)"]
[null,null,null,null,"Proposed\nBudget","Approved\nBudget","Proposed\nBudget","Approved\nBudget","Proposed\nBudget","Approved\nBudget","Proposed\nBudget","Approved\nBudget",null,"HCD Use Only",null,null,"HCD Use Only"]
[null,"Rent Revenue:",null,null,null,null,null,null,null,null,null,null,null,false,false,false,false]
[1,"Rent Revenue - Gross Potential",null,5120,{"$f":"+'3. Proposed Cash Flow -171'!F11","v":0},{"$f":"IF($N$11=TRUE,E12,0)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G11","v":0},{"$f":"IF($O$11=TRUE,G12,0)","v":0},null,null,{"$f":"+E12+G12+I12","v":0},{"$f":"F12+H12+J12","v":0}]
[2,"Tenant Assistance Payments",null,5121,{"$f":"+'3. Proposed Cash Flow -171'!F12","v":0},{"$f":"IF($N$11=TRUE,E13,0)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G12","v":0},{"$f":"IF($O$11=TRUE,G13,0)","v":0},null,null,0,0]
[3,"Rent Revenue - Stores and Commercial",null,5140,null,null,null,null,{"$f":"+'3. Proposed Cash Flow -171'!H13","v":0},{"$f":"IF($P$11=TRUE,I14,0)","v":0},0,0]
[4,"Garage and Parking Spaces",null,5170,{"$f":"+'3. Proposed Cash Flow -171'!F14","v":0},{"$f":"IF($N$11=TRUE,E15,0)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G14","v":0},{"$f":"IF($O$11=TRUE,G15,0)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H14","v":0},{"$f":"IF($P$11=TRUE,I15,0)","v":0},0,0]
[5,"Flexible Subsidy Revenue",null,5180,{"$f":"+'3. Proposed Cash Flow -171'!F15","v":0},{"$f":"IF($N$11=TRUE,E16,0)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G15","v":0},{"$f":"IF($O$11=TRUE,G16,0)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H15","v":0},{"$f":"IF($P$11=TRUE,I16,0)","v":0},0,0]
[6,"Miscellaneous Rent Revenue",null,5190,{"$f":"+'3. Proposed Cash Flow -171'!F16","v":0},{"$f":"IF($N$11=TRUE,E17,0)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G16","v":0},{"$f":"IF($O$11=TRUE,G17,0)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H16","v":0},{"$f":"IF($P$11=TRUE,I17,0)","v":0},0,0]
[7,"Total Rent Revenue",null,"5100T",{"$f":"SUM(E12:E17)","v":0},0,0,0,0,0,0,0]
[null,"Vacancies:"]
[8,"Vacancy %",null,null,{"$f":"+'3. Proposed Cash Flow -171'!F19","v":0},{"$f":"IF($N$11=TRUE,E20,0)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G19","v":0},{"$f":"IF($O$11=TRUE,G20,0)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H19","v":0},{"$f":"IF($P$11=TRUE,I20,0)","v":0},{"$f":"IF(K21=0,0,K21/(K12+K13))","v":0},{"$f":"IF(L21=0,0,L21/(L12+L13))","v":0}]
[9,"Apartments",null,5220,{"$f":"+'3. Proposed Cash Flow -171'!F20","v":0},{"$f":"SUM(F12+F13)*F20","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G20","v":0},{"$f":"SUM(H12+H13)*H20","v":0},null,null,{"$f":"+E21+G21+I21","v":0},{"$f":"F21+H21+J21","v":0}]
[10,"Stores and Commercial",null,5240,null,null,null,null,{"$f":"+'3. Proposed Cash Flow -171'!H21","v":0},{"$f":"J14*J20","v":0},0,{"$f":"F22+H22+J22","v":0}]
[11,"Rental Concessions",null,5250,{"$f":"+'3. Proposed Cash Flow -171'!F22","v":0},{"$f":"IF($N$11=TRUE,E23,0)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G22","v":0},{"$f":"IF($O$11=TRUE,G23,0)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H22","v":0},{"$f":"IF($P$11=TRUE,I23,0)","v":0},{"$f":"+E23+G23+I23","v":0},{"$f":"F23+H23+J23","v":0}]
[12,"Garage and Parking Spaces",null,5270,{"$f":"+'3. Proposed Cash Flow -171'!F23","v":0},{"$f":"IF($N$11=TRUE,E24,0)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G23","v":0},{"$f":"IF($O$11=TRUE,G24,0)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H23","v":0},{"$f":"IF($P$11=TRUE,I24,0)","v":0},{"$f":"+E24+G24+I24","v":0},{"$f":"F24+H24+J24","v":0}]
[13,"Miscellaneous Vacancies",null,5290,{"$f":"+'3. Proposed Cash Flow -171'!F24","v":0},{"$f":"IF($N$11=TRUE,E25,0)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G24","v":0},{"$f":"IF($O$11=TRUE,G25,0)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H24","v":0},{"$f":"IF($P$11=TRUE,I25,0)","v":0},{"$f":"+E25+G25+I25","v":0},{"$f":"F25+H25+J25","v":0}]
[14,"Total Vacancies",null,"5200T",{"$f":"SUM(E21:E25)","v":0},0,0,0,0,0,0,0]
[15,"Net Rental Revenues (Rent Revenue Less Vacancies)",null,"5152N",{"$f":"E18-E26","v":0},0,0,0,0,0,0,0]
[16,"Supportive Services Revenue:",null,5390,{"$f":"+'3. Proposed Cash Flow -171'!F27","v":0},{"$f":"(L28-J28)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G27","v":0},{"$f":"L28-F28-J28","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H27","v":0},{"$f":"IF($P$11=TRUE,I28,0)","v":0},{"$f":"+E28+G28+I28","v":0},{"$f":"IF($Q$11=TRUE,K28,0)","v":0}]
[null,"Total Financial Revenue:"]
[17,"Financial Revenue (don't incl. Reserve Acct. Interest)",null,5410,{"$f":"+'3. Proposed Cash Flow -171'!F29","v":0},{"$f":"(L30-J30)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G29","v":0},{"$f":"L30-F30-J30","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H29","v":0},{"$f":"IF($P$11=TRUE,I30,0)","v":0},{"$f":"+E30+G30+I30","v":0},{"$f":"IF($Q$11=TRUE,K30,0)","v":0}]
[18,"Revenue from Investments- Miscellaneous",null,5490,{"$f":"+'3. Proposed Cash Flow -171'!F30","v":0},{"$f":"(L31-J31)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G30","v":0},{"$f":"L31-F31-J31","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H30","v":0},{"$f":"IF($P$11=TRUE,I31,0)","v":0},{"$f":"+E31+G31+I31","v":0},0]
[19,"Total Financial Revenue",null,"5400T",{"$f":"SUM(E30:E31)","v":0},0,0,0,0,0,0,0]
[null,"Other Revenue:"]
[20,"Laundry and Vending Revenue",null,5910,{"$f":"+'3. Proposed Cash Flow -171'!F33","v":0},{"$f":"(L34-J34)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G33","v":0},{"$f":"L34-F34-J34","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H33","v":0},{"$f":"IF($P$11=TRUE,I34,0)","v":0},{"$f":"+E34+G34+I34","v":0},{"$f":"IF($Q$11=TRUE,K34,0)","v":0}]
[21,"Tenant Charges",null,5920,{"$f":"+'3. Proposed Cash Flow -171'!F34","v":0},{"$f":"(L35-J35)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G34","v":0},{"$f":"L35-F35-J35","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H34","v":0},{"$f":"IF($P$11=TRUE,I35,0)","v":0},{"$f":"+E35+G35+I35","v":0},{"$f":"IF($Q$11=TRUE,K35,0)","v":0}]
[22,"Misc. Revenue (don't include Reserve Withdrawals)",null,5990,{"$f":"+'3. Proposed Cash Flow -171'!F35","v":0},{"$f":"(L36-J36)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G35","v":0},{"$f":"L36-F36-J36","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H35","v":0},{"$f":"IF($P$11=TRUE,I36,0)","v":0},{"$f":"+E36+G36+I36","v":0},{"$f":"IF($Q$11=TRUE,K36,0)","v":0}]
[23,"Total Other Revenue",null,"5900T",{"$f":"SUM(E34:E36)","v":0},0,0,0,0,0,0,0]
[24,"Total Revenue",null,"5000T",{"$f":"E27+E28+E32+E37","v":0},0,0,0,0,0,0,0]
[25,"Total Cost of Operations before Depreciation",null,"6000T",{"$f":"+'3. Proposed Cash Flow -171'!F38","v":0},{"$f":"'7. Approved Proration - 175'!J64","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G38","v":0},{"$f":"'7. Approved Proration - 175'!K64","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H38","v":0},{"$f":"'7. Approved Proration - 175'!L64","v":0},{"$f":"+E39+G39+I39","v":0},{"$f":"+F39+H39+J39","v":0}]
[26,"Profit (Loss) before Depreciation",null,"5060T",{"$f":"E38-E39","v":0},0,0,0,0,0,0,0]
[null,"Financial Expenses including mandatory debt service:"]
[27,"1st Mortgage (P&I)",{"$f":"+IF('3. Proposed Cash Flow -171'!C41=0,\" \",'3. Proposed Cash Flow -171'!C41)","v":" "},6820,{"$f":"+'3. Proposed Cash Flow -171'!F41","v":0},{"$f":"(L42-J42)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G41","v":0},{"$f":"L42-F42-J42","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H41","v":0},{"$f":"IF($P$11=TRUE,I42,0)","v":0},{"$f":"+E42+G42+I42","v":0},{"$f":"IF($Q$11=TRUE,K42,0)","v":0}]
[28,"2nd Mortgage (P&I)",{"$f":"+IF('3. Proposed Cash Flow -171'!C42=0,\" \",'3. Proposed Cash Flow -171'!C42)","v":" "},6825,{"$f":"+'3. Proposed Cash Flow -171'!F42","v":0},{"$f":"(L43-J43)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G42","v":0},0,{"$f":"+'3. Proposed Cash Flow -171'!H42","v":0},0,0,0,{"$f":"+IF('3. Proposed Cash Flow -171'!C42=0,\" \",'3. Proposed Cash Flow -171'!C42)","v":" "}]
[29,"3rd Mortgage (P&I)",{"$f":"+IF('3. Proposed Cash Flow -171'!C43=0,\" \",'3. Proposed Cash Flow -171'!C43)","v":" "},6825,{"$f":"+'3. Proposed Cash Flow -171'!F43","v":0},{"$f":"(L44-J44)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G43","v":0},0,{"$f":"+'3. Proposed Cash Flow -171'!H43","v":0},0,0,0,{"$f":"+IF('3. Proposed Cash Flow -171'!C43=0,\" \",'3. Proposed Cash Flow -171'!C43)","v":" "}]
[30,"HCD Req. Payments & CalHFA Servicing/Monitoring Fee",null,6825,{"$f":"+'3. Proposed Cash Flow -171'!F44","v":0},{"$f":"(L45-J45)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G44","v":0},0,{"$f":"+'3. Proposed Cash Flow -171'!H44","v":0},0,0,0]
[31,"Lease Payment",null,6890,{"$f":"+'3. Proposed Cash Flow -171'!F45","v":0},{"$f":"(L46-J46)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G45","v":0},0,{"$f":"+'3. Proposed Cash Flow -171'!H45","v":0},0,0,0]
[32,"Miscellaneous Financial Expenses",null,6890,{"$f":"+'3. Proposed Cash Flow -171'!F46","v":0},{"$f":"(L47-J47)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G46","v":0},0,{"$f":"+'3. Proposed Cash Flow -171'!H46","v":0},0,0,0]
[33,"Total Financial Expenses",null,"6800T",{"$f":"SUM(E42:E47)","v":0},0,0,0,0,0,0,0]
[null,"Reserves Deposits:"]
[34,"Replacement Reserve - Deposit",null,1320,{"$f":"+'3. Proposed Cash Flow -171'!F49","v":0},{"$f":"(L50-J50)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G49","v":0},{"$f":"L50-F50-J50","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H49","v":0},{"$f":"IF($P$11=TRUE,I50,0)","v":0},{"$f":"+E50+G50+I50","v":0},{"$f":"IF($Q$11=TRUE,K50,0)","v":0}]
[35,"Operating Reserve - Deposit",null,1330,{"$f":"+'3. Proposed Cash Flow -171'!F50","v":0},{"$f":"(L51-J51)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G50","v":0},{"$f":"L51-F51-J51","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H50","v":0},{"$f":"IF($P$11=TRUE,I51,0)","v":0},{"$f":"+E51+G51+I51","v":0},{"$f":"IF($Q$11=TRUE,K51,0)","v":0}]
[36,"Transition Reserve  - Deposit",null,1330,{"$f":"+'3. Proposed Cash Flow -171'!F51","v":0},{"$f":"(L52-J52)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G51","v":0},{"$f":"L52-F52-J52","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H51","v":0},{"$f":"IF($P$11=TRUE,I52,0)","v":0},{"$f":"+E52+G52+I52","v":0},{"$f":"IF($Q$11=TRUE,K52,0)","v":0}]
[37,"Other Reserves",{"$f":"+IF('3. Proposed Cash Flow -171'!C52=0,\" \",'3. Proposed Cash Flow -171'!C52)","v":" "},1330,{"$f":"+'3. Proposed Cash Flow -171'!F52","v":0},{"$f":"(L53-J53)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G52","v":0},{"$f":"L53-F53-J53","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H52","v":0},{"$f":"IF($P$11=TRUE,I53,0)","v":0},{"$f":"+E53+G53+I53","v":0},{"$f":"IF($Q$11=TRUE,K53,0)","v":0},{"$f":"+IF('3. Proposed Cash Flow -171'!C52=0,\" \",'3. Proposed Cash Flow -171'!C52)","v":" "}]
[38,"Other Reserves",{"$f":"+IF('3. Proposed Cash Flow -171'!C53=0,\" \",'3. Proposed Cash Flow -171'!C53)","v":" "},1330,{"$f":"+'3. Proposed Cash Flow -171'!F53","v":0},{"$f":"(L54-J54)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G53","v":0},{"$f":"L54-F54-J54","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H53","v":0},{"$f":"IF($P$11=TRUE,I54,0)","v":0},{"$f":"+E54+G54+I54","v":0},{"$f":"IF($Q$11=TRUE,K54,0)","v":0},{"$f":"+IF('3. Proposed Cash Flow -171'!C53=0,\" \",'3. Proposed Cash Flow -171'!C53)","v":" "}]
[39,"Total Reserves Deposits",null,"1300T",{"$f":"SUM(E50:E54)","v":0},0,0,0,0,0,0,0]
[40,"Project Cash Flow",null,null,{"$f":"E40-E48-E55","v":0},0,0,0,0,0,0,0]
[null,"Additions to Cash Flow:"]
[41,"Borrower Contribution",null,null,{"$f":"+'3. Proposed Cash Flow -171'!F57","v":0},{"$f":"(L58-J58)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G57","v":0},{"$f":"L58-F58-J58","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H57","v":0},{"$f":"IF($P$11=TRUE,I58,0)","v":0},{"$f":"+E58+G58+I58","v":0},{"$f":"IF($Q$11=TRUE,K58,0)","v":0}]
[42,"Other (specify)",{"$f":"+IF('3. Proposed Cash Flow -171'!C58=0,\" \",'3. Proposed Cash Flow -171'!C58)","v":" "},null,{"$f":"+'3. Proposed Cash Flow -171'!F58","v":0},{"$f":"(L59-J59)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G58","v":0},{"$f":"L59-F59-J59","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H58","v":0},{"$f":"IF($P$11=TRUE,I59,0)","v":0},{"$f":"+E59+G59+I59","v":0},{"$f":"IF($Q$11=TRUE,K59,0)","v":0}]
[43,"Other (specify)",{"$f":"+IF('3. Proposed Cash Flow -171'!C59=0,\" \",'3. Proposed Cash Flow -171'!C59)","v":" "},null,{"$f":"+'3. Proposed Cash Flow -171'!F59","v":0},{"$f":"(L60-J60)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G59","v":0},{"$f":"L60-F60-J60","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H59","v":0},{"$f":"IF($P$11=TRUE,I60,0)","v":0},{"$f":"+E60+G60+I60","v":0},{"$f":"IF($Q$11=TRUE,K60,0)","v":0}]
[44,"Other (specify)",{"$f":"+IF('3. Proposed Cash Flow -171'!C60=0,\" \",'3. Proposed Cash Flow -171'!C60)","v":" "},null,{"$f":"+'3. Proposed Cash Flow -171'!F60","v":0},{"$f":"(L61-J61)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G60","v":0},{"$f":"L61-F61-J61","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H60","v":0},{"$f":"IF($P$11=TRUE,I61,0)","v":0},{"$f":"+E61+G61+I61","v":0},{"$f":"IF($Q$11=TRUE,K61,0)","v":0},{"$f":"+IF('3. Proposed Cash Flow -171'!C60=0,\" \",'3. Proposed Cash Flow -171'!C60)","v":" "}]
[45,"Total Additional Revenue",null,null,{"$f":"SUM(E58:E61)","v":0},0,0,0,0,0,0,0]
[null,"Use of Cash Flow (final approval with Annual Report):"]
[46,"Deferred Developer Fee Payments",null,"",{"$f":"+'3. Proposed Cash Flow -171'!F63","v":0},{"$f":"(L64-J64)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G63","v":0},{"$f":"L64-F64-J64","v":0},{"$f":"+'3. Proposed Cash Flow -171'!H63","v":0},{"$f":"IF($P$11=TRUE,I64,0)","v":0},{"$f":"+E64+G64+I64","v":0},{"$f":"IF($Q$11=TRUE,K64,0)","v":0}]
[47,"Asset Management Fee/Partnership Costs",null,7190,{"$f":"+'3. Proposed Cash Flow -171'!F64","v":0},{"$f":"(L65-J65)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G64","v":0},0,{"$f":"+'3. Proposed Cash Flow -171'!H64","v":0},0,0,0]
[48,"Borrower Distributions",null,null,{"$f":"+'3. Proposed Cash Flow -171'!F65","v":0},{"$f":"(L66-J66)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G65","v":0},0,{"$f":"+'3. Proposed Cash Flow -171'!H65","v":0},0,0,0]
[49,"Residual Receipt Loan Payments",null,null,{"$f":"+'3. Proposed Cash Flow -171'!F66","v":0},{"$f":"(L67-J67)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G66","v":0},0,{"$f":"+'3. Proposed Cash Flow -171'!H66","v":0},0,0,0]
[50,"HCD Interest Payments",null,null,{"$f":"+'3. Proposed Cash Flow -171'!F67","v":0},{"$f":"(L68-J68)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G67","v":0},0,{"$f":"+'3. Proposed Cash Flow -171'!H67","v":0},0,0,0]
[51,"Other (specify)",{"$f":"+IF('3. Proposed Cash Flow -171'!C68=0,\" \",'3. Proposed Cash Flow -171'!C68)","v":" "},null,{"$f":"+'3. Proposed Cash Flow -171'!F68","v":0},{"$f":"(L69-J69)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"+'3. Proposed Cash Flow -171'!G68","v":0},0,{"$f":"+'3. Proposed Cash Flow -171'!H68","v":0},0,0,0,{"$f":"+IF('3. Proposed Cash Flow -171'!C68=0,\" \",'3. Proposed Cash Flow -171'!C68)","v":" "}]
[52,"Total Use of Cash Flow",null,null,{"$f":"SUM(E64:E69)","v":0},0,0,0,0,0,0,0]

{"sheet":"6. Approved Cost of Ops - 174 ","index":5,"n_rows":64,"n_cols":10,"rows_kept":64,"cut":false,"hidden":false,"merged":[[42,1,42,2],[39,1,39,2],[40,1,40,2],[35,1,35,2],[33,1,33,2],[41,1,41,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[34,1,34,2],[63,1,63,2],[55,1,55,2],[56,1,56,2],[62,1,62,2],[25,1,25,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[44,1,44,2],[61,1,61,2],[45,1,45,2],[49,1,49,2],[48,1,48,2],[46,1,46,2],[60,1,60,2],[14,1,14,2],[17,1,17,2],[28,1,28,2],[15,1,15,2],[16,1,16,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[18,1,18,2],[19,1,19,2],[27,1,27,2],[23,1,23,2],[24,1,24,2],[36,1,36,2],[37,1,37,2],[10,1,10,2],[59,1,59,2],[57,1,57,2],[11,1,11,2],[3,0,3,1],[26,1,26,2],[4,0,4,1],[6,0,6,1],[12,1,12,2],[13,1,13,2],[8,1,9,2],[5,0,5,1],[47,1,47,2],[58,1,58,2],[38,1,38,2],[43,1,43,2],[0,0,0,8],[7,8,9,8],[7,1,7,3],[7,0,9,0],[8,3,9,3],[7,4,7,5],[7,6,7,7],[2,3,2,4],[4,3,4,4],[5,3,5,4],[3,3,3,4]]}
["Approved Cost of Operations"]
[null,{"$f":"'1. Operating Budget Instruction'!K1","v":"2025-04-16"},"                                             Reporting Period:",{"$f":"IF(' 2. Checklist and Cert - 170'!D2=\"\",\"\",' 2. Checklist and Cert - 170'!D2)","v":""},"to",{"$f":"IF(' 2. Checklist and Cert - 170'!F2=\"\",\"\",' 2. Checklist and Cert - 170'!F2)","v":""},null,"Date Prepared:",{"$f":"IF(' 2. Checklist and Cert - 170'!D10=\"\",\"\",' 2. Checklist and Cert - 170'!D10)","v":""}]
[null,null,null,{"$f":"' 2. Checklist and Cert - 170'!A5","v":"1. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D5=\"\",\"\",' 2. Checklist and Cert - 170'!D5)","v":""},null,"Date Revised:",{"$f":"IF(' 2. Checklist and Cert - 170'!L9=\"\",\"\",' 2. Checklist and Cert - 170'!L9)","v":""}]
["Project Name:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!D3=\"\",\"\",' 2. Checklist and Cert - 170'!D3)","v":""},{"$f":"' 2. Checklist and Cert - 170'!A6","v":"2. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D6=\"\",\"\",' 2. Checklist and Cert - 170'!D6)","v":""},null,{"$f":"CONCATENATE(' 2. Checklist and Cert - 170'!M2,\" Units:\")","v":"Assisted Units:"},{"$f":"IF(' 2. Checklist and Cert - 170'!L2=\"\",0,' 2. Checklist and Cert - 170'!L2)","v":0}]
["Project County:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!D4=\"\",\"\",' 2. Checklist and Cert - 170'!D4)","v":""},{"$f":"' 2. Checklist and Cert - 170'!A7","v":"3. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D7=\"\",\"\",' 2. Checklist and Cert - 170'!D7)","v":""},null,"Total Units:",{"$f":"IF(' 2. Checklist and Cert - 170'!L3=\"\",0,' 2. Checklist and Cert - 170'!L3)","v":0}]
["Approved By:",null,null,{"$f":"' 2. Checklist and Cert - 170'!A8","v":"4. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D8=\"\",\"\",' 2. Checklist and Cert - 170'!D8)","v":""},null,"Phone #:",{"$f":"IF(' 2. Checklist and Cert - 170'!G10=\"\",\"\",' 2. Checklist and Cert - 170'!G10)","v":""}]
[]
["Line #","HCD/CalHFA use only",null,null,"Total Proposed Budget",null,"Total Approved Budget",null,"HCD/CalHFA Rep notes"]
[null,"Account Name",null,"Account\nCode","(A)","(B)","(C)","(D)"]
[null,null,null,null,"Annual Budget","Per Unit\nPer Month","Annual Budget","Per Unit\nPer Month",null,"HCD Use Only"]
[null,"Administrative Expenses:",null,null,null,null,null,null,null,false]
[1,"Conventions and Meetings",null,6203,{"$f":"+'4. Proposed Cost of Ops - 172'!E12","v":0},{"$f":"IF($I$5=0,0,E12/$I$5/12)","v":0},{"$f":"IF($J$11=TRUE,E12,0)","v":0},{"$f":"IF($I$5=0,0,G12/$I$5/12)","v":0}]
[2,"Management Consultants",null,6204,{"$f":"+'4. Proposed Cost of Ops - 172'!E13","v":0},0,0,0]
[3,"Advertising and Marketing",null,6210,{"$f":"+'4. Proposed Cost of Ops - 172'!E14","v":0},0,0,0]
[4,"Other Renting Expenses",null,6250,{"$f":"+'4. Proposed Cost of Ops - 172'!E15","v":0},0,0,0]
[5,"Office Salaries",null,6310,{"$f":"+'4. Proposed Cost of Ops - 172'!E16","v":0},0,0,0]
[6,"Office Expenses",null,6311,{"$f":"+'4. Proposed Cost of Ops - 172'!E17","v":0},0,0,0]
[7,"Office or Model Apartment Rent",null,6312,{"$f":"+'4. Proposed Cost of Ops - 172'!E18","v":0},0,0,0]
[8,"Management Fee (do not include GP Management Fee)",null,6320,{"$f":"+'4. Proposed Cost of Ops - 172'!E19","v":0},0,0,0]
[9,"Manager or Superintendent Salaries",null,6330,{"$f":"+'4. Proposed Cost of Ops - 172'!E20","v":0},0,0,0]
[10,"Administrative Rent Free Unit",null,6331,{"$f":"+'4. Proposed Cost of Ops - 172'!E21","v":0},0,0,0]
[11,"Legal Expense - Project",null,6340,{"$f":"+'4. Proposed Cost of Ops - 172'!E22","v":0},0,0,0]
[12,"Audit Expense",null,6350,{"$f":"+'4. Proposed Cost of Ops - 172'!E23","v":0},0,0,0]
[13,"Bookkeeping Fees/ Accounting Services",null,6351,{"$f":"+'4. Proposed Cost of Ops - 172'!E24","v":0},0,0,0]
[14,"Bad Debts",null,6370,{"$f":"+'4. Proposed Cost of Ops - 172'!E25","v":0},0,0,0]
[15,"Misc. Administrative Expenses",null,6390,{"$f":"+'4. Proposed Cost of Ops - 172'!E26","v":0},0,0,0]
[16,"Total Administrative Expenses",null,"6263T",{"$f":"SUM(E12:E26)","v":0},{"$f":"SUM(F12:F26)","v":0},{"$f":"SUM(G12:G26)","v":0},{"$f":"SUM(H12:H26)","v":0}]
[null,"Utilities Expenses:"]
[17,"Electricity",null,6450,{"$f":"+'4. Proposed Cost of Ops - 172'!E29","v":0},{"$f":"IF($I$5=0,0,E29/$I$5/12)","v":0},{"$f":"IF($J$11=TRUE,E29,0)","v":0},{"$f":"IF($I$5=0,0,G29/$I$5/12)","v":0}]
[18,"Water",null,6451,{"$f":"+'4. Proposed Cost of Ops - 172'!E30","v":0},{"$f":"IF($I$5=0,0,E30/$I$5/12)","v":0},{"$f":"IF($J$11=TRUE,E30,0)","v":0},{"$f":"IF($I$5=0,0,G30/$I$5/12)","v":0}]
[19,"Gas",null,6452,{"$f":"+'4. Proposed Cost of Ops - 172'!E31","v":0},{"$f":"IF($I$5=0,0,E31/$I$5/12)","v":0},{"$f":"IF($J$11=TRUE,E31,0)","v":0},{"$f":"IF($I$5=0,0,G31/$I$5/12)","v":0}]
[20,"Sewer",null,6453,{"$f":"+'4. Proposed Cost of Ops - 172'!E32","v":0},{"$f":"IF($I$5=0,0,E32/$I$5/12)","v":0},{"$f":"IF($J$11=TRUE,E32,0)","v":0},{"$f":"IF($I$5=0,0,G32/$I$5/12)","v":0}]
[21,"Total Utilities Expenses",null,"6400T",{"$f":"SUM(E29:E32)","v":0},{"$f":"SUM(F29:F32)","v":0},{"$f":"SUM(G29:G32)","v":0},{"$f":"SUM(H29:H32)","v":0}]
[null,"Operating and Maintenance Expenses:"]
[22,"Payroll",null,6510,{"$f":"+'4. Proposed Cost of Ops - 172'!E35","v":0},{"$f":"IF($I$5=0,0,E35/$I$5/12)","v":0},{"$f":"IF($J$11=TRUE,E35,0)","v":0},{"$f":"IF($I$5=0,0,G35/$I$5/12)","v":0}]
[23,"Supplies",null,6515,{"$f":"+'4. Proposed Cost of Ops - 172'!E36","v":0},0,0,0]
[24,"Contracts",null,6520,{"$f":"+'4. Proposed Cost of Ops - 172'!E37","v":0},0,0,0]
[25,"Operating and Maintenance Rent Free Unit",null,6521,{"$f":"+'4. Proposed Cost of Ops - 172'!E38","v":0},0,0,0]
[26,"Garbage and Trash Removal",null,6525,{"$f":"+'4. Proposed Cost of Ops - 172'!E39","v":0},0,0,0]
[27,"Security Payroll/Contracts",null,6530,{"$f":"+'4. Proposed Cost of Ops - 172'!E40","v":0},0,0,0]
[28,"Security Rent Free Unit",null,6531,{"$f":"+'4. Proposed Cost of Ops - 172'!E41","v":0},0,0,0]
[29,"Heating/Cooling Repairs and Maintenance",null,6546,{"$f":"+'4. Proposed Cost of Ops - 172'!E42","v":0},0,0,0]
[30,"Snow Removal",null,6548,{"$f":"+'4. Proposed Cost of Ops - 172'!E43","v":0},0,0,0]
[31,"Vehicle and Maintenance Equip. Operation and Repairs",null,6570,{"$f":"+'4. Proposed Cost of Ops - 172'!E44","v":0},0,0,0]
[32,"Lease Expense",null,6580,{"$f":"+'4. Proposed Cost of Ops - 172'!E45","v":0},{"$f":"IF($I$5=0,0,E45/$I$5/12)","v":0},{"$f":"IF($J$11=TRUE,E45,0)","v":0},{"$f":"IF($I$5=0,0,G45/$I$5/12)","v":0}]
[33,"Misc. Operating & Maintenance Expenses",null,6590,{"$f":"+'4. Proposed Cost of Ops - 172'!E46","v":0},0,0,0]
[34,"Total Operating and Maintenance Expenses",null,"6500T",{"$f":"SUM(E35:E46)","v":0},{"$f":"SUM(F35:F46)","v":0},{"$f":"SUM(G35:G46)","v":0},{"$f":"SUM(H35:H46)","v":0}]
[null,"Taxes and Insurance:"]
[35,"Real Estate Taxes",null,6710,{"$f":"+'4. Proposed Cost of Ops - 172'!E49","v":0},{"$f":"IF($I$5=0,0,E49/$I$5/12)","v":0},{"$f":"IF($J$11=TRUE,E49,0)","v":0},{"$f":"IF($I$5=0,0,G49/$I$5/12)","v":0}]
[36,"Payroll Taxes (Project's Share)",null,6711,{"$f":"+'4. Proposed Cost of Ops - 172'!E50","v":0},0,0,0]
[37,"Property & Liability Insurance (Hazard)",null,6720,{"$f":"+'4. Proposed Cost of Ops - 172'!E51","v":0},0,0,0]
[38,"Fidelity Bond Insurance",null,6721,{"$f":"+'4. Proposed Cost of Ops - 172'!E52","v":0},0,0,0]
[39,"Worker's Compensation",null,6722,{"$f":"+'4. Proposed Cost of Ops - 172'!E53","v":0},0,0,0]
[40,"Health Insurance and Other Employee Benefits",null,6723,{"$f":"+'4. Proposed Cost of Ops - 172'!E54","v":0},0,0,0]
[41,"Miscellaneous Taxes, Licenses, Permits and Insurance",null,6790,{"$f":"+'4. Proposed Cost of Ops - 172'!E55","v":0},0,0,0]
[42,"Total Taxes and Insurance",null,"6700T",{"$f":"SUM(E49:E55)","v":0},{"$f":"SUM(F49:F55)","v":0},{"$f":"SUM(G49:G55)","v":0},{"$f":"SUM(H49:H55)","v":0}]
[null,"Supportive Services Costs:",null,6990]
[43,"Staff Supervisors Salaries",null,{"$f":"IF(G58=0,0,G58/(G59+G60))","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!E58","v":0},{"$f":"IF($I$5=0,0,E58/$I$5/12)","v":0},{"$f":"IF($J$11=TRUE,E58,0)","v":0},{"$f":"IF($I$5=0,0,G58/$I$5/12)","v":0}]
[44,"On-site Service Coordinator Salaries and Benefits",null,null,{"$f":"+'4. Proposed Cost of Ops - 172'!E59","v":0},{"$f":"IF($I$5=0,0,E59/$I$5/12)","v":0},{"$f":"IF($J$11=TRUE,E59,0)","v":0},{"$f":"IF($I$5=0,0,G59/$I$5/12)","v":0}]
[45,"On-site Other Supportive Services Staff Salaries",null,null,{"$f":"+'4. Proposed Cost of Ops - 172'!E60","v":0},{"$f":"IF($I$5=0,0,E60/$I$5/12)","v":0},{"$f":"IF($J$11=TRUE,E60,0)","v":0},{"$f":"IF($I$5=0,0,G60/$I$5/12)","v":0}]
[46,"Supportive Services Administrative Overhead",null,{"$f":"IF(G61=0,0,G61/G63)","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!E61","v":0},{"$f":"IF($I$5=0,0,E61/$I$5/12)","v":0},{"$f":"IF($J$11=TRUE,E61,0)","v":0},{"$f":"IF($I$5=0,0,G61/$I$5/12)","v":0}]
[47,"Other Supportive Services Costs",null,6990,{"$f":"+'4. Proposed Cost of Ops - 172'!E62","v":0},{"$f":"IF($I$5=0,0,E62/$I$5/12)","v":0},{"$f":"IF($J$11=TRUE,E62,0)","v":0},{"$f":"IF($I$5=0,0,G62/$I$5/12)","v":0}]
[48,"Total Supportive Services Costs",null,"6900T",{"$f":"SUM(E58:E62)","v":0},{"$f":"SUM(F58:F62)","v":0},{"$f":"SUM(G58:G62)","v":0},{"$f":"SUM(H58:H62)","v":0}]
[49,"Total Cost of Operations",null,"6000T",{"$f":"E27+E33+E47+E56+E63","v":0},{"$f":"F27+F33+F47+F56+F63","v":0},{"$f":"G27+G33+G47+G56+G63","v":0},{"$f":"H27+H33+H47+H56+H63","v":0}]

{"sheet":"7. Approved Proration - 175","index":6,"n_rows":64,"n_cols":14,"rows_kept":64,"cut":false,"hidden":false,"merged":[[3,4,3,5],[3,6,3,7],[64,0,64,11],[36,1,36,2],[48,1,48,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[62,1,62,2],[54,1,54,2],[63,1,63,2],[55,1,55,2],[56,1,56,2],[49,1,49,2],[50,1,50,2],[61,1,61,2],[33,1,33,2],[53,1,53,2],[46,1,46,2],[47,1,47,2],[37,1,37,2],[52,1,52,2],[34,1,34,2],[35,1,35,2],[44,1,44,2],[43,1,43,2],[45,1,45,2],[58,1,58,2],[60,1,60,2],[59,1,59,2],[57,1,57,2],[51,1,51,2],[42,1,42,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[32,1,32,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[6,0,6,1],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[7,1,7,3],[8,1,9,2],[10,1,10,2],[11,1,11,2],[15,1,15,2],[16,1,16,2],[12,1,12,2],[13,1,13,2],[18,1,18,2],[17,1,17,2],[14,1,14,2],[0,0,0,11],[5,10,5,11],[8,3,9,3],[7,4,7,7],[7,8,7,11],[2,6,2,7],[1,3,1,4],[4,6,4,7],[5,6,5,7],[7,0,9,0],[2,4,2,5],[4,4,4,5],[5,0,5,1],[5,4,5,5],[3,0,3,1],[4,0,4,1]]}
["Approved Proration of Cost of Operations"]
[null,{"$f":"'1. Operating Budget Instruction'!K1","v":"2025-04-16"},null,"                           Reporting Period:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!D2=\"\",\"\",' 2. Checklist and Cert - 170'!D2)","v":""},"to",{"$f":"IF(' 2. Checklist and Cert - 170'!F2=\"\",\"\",' 2. Checklist and Cert - 170'!F2)","v":""},null,null,"Date Prepared:",{"$f":"IF(' 2. Checklist and Cert - 170'!D10=\"\",\"\",' 2. Checklist and Cert - 170'!D10)","v":""}]
[null,null,null,null,{"$f":"' 2. Checklist and Cert - 170'!A5","v":"1. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D5=\"\",\"\",' 2. Checklist and Cert - 170'!D5)","v":""},{"$f":"' 2. Checklist and Cert - 170'!#REF!","v":{"$error":"#REF!"}},null,null,"Date Revised:",{"$f":"IF(' 2. Checklist and Cert - 170'!L9=\"\",\"\",' 2. Checklist and Cert - 170'!L9)","v":""}]
["Project Name:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!D3=\"\",\"\",' 2. Checklist and Cert - 170'!D3)","v":""},null,{"$f":"' 2. Checklist and Cert - 170'!A6","v":"2. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D6=\"\",\"\",' 2. Checklist and Cert - 170'!D6)","v":""},{"$f":"' 2. Checklist and Cert - 170'!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"CONCATENATE(' 2. Checklist and Cert - 170'!M2,\" Units:\")","v":"Assisted Units:"},{"$f":"IF(' 2. Checklist and Cert - 170'!L2=\"\",0,' 2. Checklist and Cert - 170'!L2)","v":0}]
["Project County:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!D4=\"\",\"\",' 2. Checklist and Cert - 170'!D4)","v":""},null,{"$f":"' 2. Checklist and Cert - 170'!A7","v":"3. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D7=\"\",\"\",' 2. Checklist and Cert - 170'!D7)","v":""},{"$f":"' 2. Checklist and Cert - 170'!#REF!","v":{"$error":"#REF!"}},null,null,"Total Units:",{"$f":"IF(' 2. Checklist and Cert - 170'!L3=\"\",0,' 2. Checklist and Cert - 170'!L3)","v":0}]
["Approved By:",null,null,null,{"$f":"' 2. Checklist and Cert - 170'!A8","v":"4. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D8=\"\",\"\",' 2. Checklist and Cert - 170'!D8)","v":""},{"$f":"' 2. Checklist and Cert - 170'!#REF!","v":{"$error":"#REF!"}},null,"Phone #:",{"$f":"IF(' 2. Checklist and Cert - 170'!G10=\"\",\"\",' 2. Checklist and Cert - 170'!G10)","v":""}]
[]
["Line #","HCD/CalHFA use only",null,null,"Prorated Proposed Budget",null,null,null,"Prorated Approved Budget"]
[null,"Account Name",null,"Account\nCodes","(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)"]
[null,null,null,null,"Proration\nPercentage",{"$f":"CONCATENATE(' 2. Checklist and Cert - 170'!$M$2,\" Units\")","v":"Assisted Units"},{"$f":"CONCATENATE(\"Non-\",' 2. Checklist and Cert - 170'!$M$2,\" Units\")","v":"Non-Assisted Units"},"Commercial","Proration\nPercentage",{"$f":"CONCATENATE(' 2. Checklist and Cert - 170'!$M$2,\" Units\")","v":"Assisted Units"},{"$f":"CONCATENATE(\"Non-\",' 2. Checklist and Cert - 170'!$M$2,\" Units\")","v":"Non-Assisted Units"},"Commercial",null,"HCD Use Only"]
[null,"Administrative Expenses:",null,null,null,null,null,null,null,null,null,null,null,false]
[1,"Conventions and Meetings",null,6203,{"$f":"+'4. Proposed Cost of Ops - 172'!F12","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G12","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H12","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I12","v":0},{"$f":"IF($N$11=TRUE,E12,0)","v":0},{"$f":"('6. Approved Cost of Ops - 174 '!G12-'7. Approved Proration - 175'!L12)*'7. Approved Proration - 175'!I12","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G12-'7. Approved Proration - 175'!L12-'7. Approved Proration - 175'!J12","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I12","v":0}]
[2,"Management Consultants",null,6204,{"$f":"+'4. Proposed Cost of Ops - 172'!F13","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G13","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H13","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I13","v":0},{"$f":"IF($N$11=TRUE,E13,0)","v":0},{"$f":"('6. Approved Cost of Ops - 174 '!G13-'7. Approved Proration - 175'!L13)*'7. Approved Proration - 175'!I13","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G13-'7. Approved Proration - 175'!L13-'7. Approved Proration - 175'!J13","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I13","v":0}]
[3,"Advertising and Marketing",null,6210,{"$f":"+'4. Proposed Cost of Ops - 172'!F14","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G14","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H14","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I14","v":0},{"$f":"IF($N$11=TRUE,E14,0)","v":0},{"$f":"('6. Approved Cost of Ops - 174 '!G14-'7. Approved Proration - 175'!L14)*'7. Approved Proration - 175'!I14","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G14-'7. Approved Proration - 175'!L14-'7. Approved Proration - 175'!J14","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I14","v":0}]
[4,"Other Renting Expenses",null,6250,{"$f":"+'4. Proposed Cost of Ops - 172'!F15","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G15","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H15","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I15","v":0},{"$f":"IF($N$11=TRUE,E15,0)","v":0},{"$f":"('6. Approved Cost of Ops - 174 '!G15-'7. Approved Proration - 175'!L15)*'7. Approved Proration - 175'!I15","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G15-'7. Approved Proration - 175'!L15-'7. Approved Proration - 175'!J15","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I15","v":0}]
[5,"Office Salaries",null,6310,{"$f":"+'4. Proposed Cost of Ops - 172'!F16","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G16","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H16","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I16","v":0},{"$f":"IF($N$11=TRUE,E16,0)","v":0},{"$f":"('6. Approved Cost of Ops - 174 '!G16-'7. Approved Proration - 175'!L16)*'7. Approved Proration - 175'!I16","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G16-'7. Approved Proration - 175'!L16-'7. Approved Proration - 175'!J16","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I16","v":0}]
[6,"Office Expenses",null,6311,{"$f":"+'4. Proposed Cost of Ops - 172'!F17","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G17","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H17","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I17","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G17-'7. Approved Proration - 175'!L17)*'7. Approved Proration - 175'!I17","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G17-'7. Approved Proration - 175'!L17-'7. Approved Proration - 175'!J17","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I17","v":0}]
[7,"Office or Model Apartment Rent",null,6312,{"$f":"+'4. Proposed Cost of Ops - 172'!F18","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G18","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H18","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I18","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G18-'7. Approved Proration - 175'!L18)*'7. Approved Proration - 175'!I18","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G18-'7. Approved Proration - 175'!L18-'7. Approved Proration - 175'!J18","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I18","v":0}]
[8,"Management Fee (do not include GP Management Fee)",null,6320,{"$f":"+'4. Proposed Cost of Ops - 172'!F19","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G19","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H19","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I19","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G19-'7. Approved Proration - 175'!L19)*'7. Approved Proration - 175'!I19","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G19-'7. Approved Proration - 175'!L19-'7. Approved Proration - 175'!J19","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I19","v":0}]
[9,"Manager or Superintendent Salaries",null,6330,{"$f":"+'4. Proposed Cost of Ops - 172'!F20","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G20","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H20","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I20","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G20-'7. Approved Proration - 175'!L20)*'7. Approved Proration - 175'!I20","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G20-'7. Approved Proration - 175'!L20-'7. Approved Proration - 175'!J20","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I20","v":0}]
[10,"Administrative Rent Free Unit",null,6331,{"$f":"+'4. Proposed Cost of Ops - 172'!F21","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G21","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H21","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I21","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G21-'7. Approved Proration - 175'!L21)*'7. Approved Proration - 175'!I21","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G21-'7. Approved Proration - 175'!L21-'7. Approved Proration - 175'!J21","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I21","v":0}]
[11,"Legal Expense - Project",null,6340,{"$f":"+'4. Proposed Cost of Ops - 172'!F22","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G22","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H22","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I22","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G22-'7. Approved Proration - 175'!L22)*'7. Approved Proration - 175'!I22","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G22-'7. Approved Proration - 175'!L22-'7. Approved Proration - 175'!J22","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I22","v":0}]
[12,"Audit Expense",null,6350,{"$f":"+'4. Proposed Cost of Ops - 172'!F23","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G23","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H23","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I23","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G23-'7. Approved Proration - 175'!L23)*'7. Approved Proration - 175'!I23","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G23-'7. Approved Proration - 175'!L23-'7. Approved Proration - 175'!J23","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I23","v":0}]
[13,"Bookkeeping Fees/ Accounting Services",null,6351,{"$f":"+'4. Proposed Cost of Ops - 172'!F24","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G24","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H24","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I24","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G24-'7. Approved Proration - 175'!L24)*'7. Approved Proration - 175'!I24","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G24-'7. Approved Proration - 175'!L24-'7. Approved Proration - 175'!J24","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I24","v":0}]
[14,"Bad Debts",null,6370,{"$f":"+'4. Proposed Cost of Ops - 172'!F25","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G25","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H25","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I25","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G25-'7. Approved Proration - 175'!L25)*'7. Approved Proration - 175'!I25","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G25-'7. Approved Proration - 175'!L25-'7. Approved Proration - 175'!J25","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I25","v":0}]
[15,"Misc. Administrative Expenses",null,6390,{"$f":"+'4. Proposed Cost of Ops - 172'!F26","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G26","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H26","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I26","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G26-'7. Approved Proration - 175'!L26)*'7. Approved Proration - 175'!I26","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G26-'7. Approved Proration - 175'!L26-'7. Approved Proration - 175'!J26","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I26","v":0}]
[16,"Total Administrative Expenses",null,"6263T",null,{"$f":"SUM(F12:F26)","v":0},{"$f":"SUM(G12:G26)","v":0},{"$f":"SUM(H12:H26)","v":0},null,{"$f":"SUM(J12:J26)","v":0},{"$f":"SUM(K12:K26)","v":0},{"$f":"SUM(L12:L26)","v":0}]
[null,"Utilities:"]
[17,"Electricity",null,6450,{"$f":"+'4. Proposed Cost of Ops - 172'!F29","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G29","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H29","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I29","v":0},{"$f":"IF($N$11=TRUE,E29,0)","v":0},{"$f":"('6. Approved Cost of Ops - 174 '!G29-'7. Approved Proration - 175'!L29)*'7. Approved Proration - 175'!I29","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G29-'7. Approved Proration - 175'!L29-'7. Approved Proration - 175'!J29","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I29","v":0}]
[18,"Water",null,6451,{"$f":"+'4. Proposed Cost of Ops - 172'!F30","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G30","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H30","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I30","v":0},{"$f":"IF($N$11=TRUE,E30,0)","v":0},{"$f":"('6. Approved Cost of Ops - 174 '!G30-'7. Approved Proration - 175'!L30)*'7. Approved Proration - 175'!I30","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G30-'7. Approved Proration - 175'!L30-'7. Approved Proration - 175'!J30","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I30","v":0}]
[19,"Gas",null,6452,{"$f":"+'4. Proposed Cost of Ops - 172'!F31","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G31","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H31","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I31","v":0},{"$f":"IF($N$11=TRUE,E31,0)","v":0},{"$f":"('6. Approved Cost of Ops - 174 '!G31-'7. Approved Proration - 175'!L31)*'7. Approved Proration - 175'!I31","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G31-'7. Approved Proration - 175'!L31-'7. Approved Proration - 175'!J31","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I31","v":0}]
[20,"Sewer",null,6453,{"$f":"+'4. Proposed Cost of Ops - 172'!F32","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G32","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H32","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I32","v":0},{"$f":"IF($N$11=TRUE,E32,0)","v":0},{"$f":"('6. Approved Cost of Ops - 174 '!G32-'7. Approved Proration - 175'!L32)*'7. Approved Proration - 175'!I32","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G32-'7. Approved Proration - 175'!L32-'7. Approved Proration - 175'!J32","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I32","v":0}]
[21,"Total Utilities Expenses",null,"6400T",null,{"$f":"SUM(F29:F32)","v":0},{"$f":"SUM(G29:G32)","v":0},{"$f":"SUM(H29:H32)","v":0},null,{"$f":"SUM(J29:J32)","v":0},{"$f":"SUM(K29:K32)","v":0},{"$f":"SUM(L29:L32)","v":0}]
[null,"Operating and Maintenance Expenses:"]
[22,"Payroll",null,6510,{"$f":"+'4. Proposed Cost of Ops - 172'!F35","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G35","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H35","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I35","v":0},{"$f":"IF($N$11=TRUE,E35,0)","v":0},{"$f":"('6. Approved Cost of Ops - 174 '!G35-'7. Approved Proration - 175'!L35)*'7. Approved Proration - 175'!I35","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G35-'7. Approved Proration - 175'!L35-'7. Approved Proration - 175'!J35","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I35","v":0}]
[23,"Supplies",null,6515,{"$f":"+'4. Proposed Cost of Ops - 172'!F36","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G36","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H36","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I36","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G36-'7. Approved Proration - 175'!L36)*'7. Approved Proration - 175'!I36","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G36-'7. Approved Proration - 175'!L36-'7. Approved Proration - 175'!J36","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I36","v":0}]
[24,"Contracts",null,6520,{"$f":"+'4. Proposed Cost of Ops - 172'!F37","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G37","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H37","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I37","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G37-'7. Approved Proration - 175'!L37)*'7. Approved Proration - 175'!I37","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G37-'7. Approved Proration - 175'!L37-'7. Approved Proration - 175'!J37","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I37","v":0}]
[25,"Operating and Maintenance Rent Free Unit",null,6521,{"$f":"+'4. Proposed Cost of Ops - 172'!F38","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G38","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H38","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I38","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G38-'7. Approved Proration - 175'!L38)*'7. Approved Proration - 175'!I38","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G38-'7. Approved Proration - 175'!L38-'7. Approved Proration - 175'!J38","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I38","v":0}]
[26,"Garbage and Trash Removal",null,6525,{"$f":"+'4. Proposed Cost of Ops - 172'!F39","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G39","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H39","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I39","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G39-'7. Approved Proration - 175'!L39)*'7. Approved Proration - 175'!I39","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G39-'7. Approved Proration - 175'!L39-'7. Approved Proration - 175'!J39","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I39","v":0}]
[27,"Security Payroll/Contracts",null,6530,{"$f":"+'4. Proposed Cost of Ops - 172'!F40","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G40","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H40","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I40","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G40-'7. Approved Proration - 175'!L40)*'7. Approved Proration - 175'!I40","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G40-'7. Approved Proration - 175'!L40-'7. Approved Proration - 175'!J40","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I40","v":0}]
[28,"Security Rent Free Unit",null,6531,{"$f":"+'4. Proposed Cost of Ops - 172'!F41","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G41","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H41","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I41","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G41-'7. Approved Proration - 175'!L41)*'7. Approved Proration - 175'!I41","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G41-'7. Approved Proration - 175'!L41-'7. Approved Proration - 175'!J41","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I41","v":0}]
[29,"Heating/Cooling Repairs and Maintenance",null,6546,{"$f":"+'4. Proposed Cost of Ops - 172'!F42","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G42","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H42","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I42","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G42-'7. Approved Proration - 175'!L42)*'7. Approved Proration - 175'!I42","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G42-'7. Approved Proration - 175'!L42-'7. Approved Proration - 175'!J42","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I42","v":0}]
[30,"Snow Removal",null,6548,{"$f":"+'4. Proposed Cost of Ops - 172'!F43","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G43","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H43","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I43","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G43-'7. Approved Proration - 175'!L43)*'7. Approved Proration - 175'!I43","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G43-'7. Approved Proration - 175'!L43-'7. Approved Proration - 175'!J43","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I43","v":0}]
[31,"Vehicle and Maintenance Equip. Operation and Repairs",null,6570,{"$f":"+'4. Proposed Cost of Ops - 172'!F44","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G44","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H44","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I44","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G44-'7. Approved Proration - 175'!L44)*'7. Approved Proration - 175'!I44","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G44-'7. Approved Proration - 175'!L44-'7. Approved Proration - 175'!J44","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I44","v":0}]
[32,"Lease Expense",null,6580,{"$f":"+'4. Proposed Cost of Ops - 172'!F45","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G45","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H45","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I45","v":0},{"$f":"IF($N$11=TRUE,E45,0)","v":0},{"$f":"('6. Approved Cost of Ops - 174 '!G45-'7. Approved Proration - 175'!L45)*'7. Approved Proration - 175'!I45","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G45-'7. Approved Proration - 175'!L45-'7. Approved Proration - 175'!J45","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I45","v":0}]
[33,"Misc. Operating & Maintenance Expenses",null,6590,{"$f":"+'4. Proposed Cost of Ops - 172'!F46","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G46","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H46","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I46","v":0},{"$f":"IF($N$11=TRUE,E46,0)","v":0},{"$f":"('6. Approved Cost of Ops - 174 '!G46-'7. Approved Proration - 175'!L46)*'7. Approved Proration - 175'!I46","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G46-'7. Approved Proration - 175'!L46-'7. Approved Proration - 175'!J46","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I46","v":0}]
[34,"Total Operating and Maintenance Expenses",null,"6500T",null,{"$f":"SUM(F35:F46)","v":0},{"$f":"SUM(G35:G46)","v":0},{"$f":"SUM(H35:H46)","v":0},null,{"$f":"SUM(J35:J46)","v":0},{"$f":"SUM(K35:K46)","v":0},{"$f":"SUM(L35:L46)","v":0}]
[null,"Taxes and Insurance:"]
[35,"Real Estate Taxes",null,6710,{"$f":"+'4. Proposed Cost of Ops - 172'!F49","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G49","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H49","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I49","v":0},{"$f":"IF($N$11=TRUE,E49,0)","v":0},{"$f":"('6. Approved Cost of Ops - 174 '!G49-'7. Approved Proration - 175'!L49)*'7. Approved Proration - 175'!I49","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G49-'7. Approved Proration - 175'!L49-'7. Approved Proration - 175'!J49","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I49","v":0}]
[36,"Payroll Taxes (Project's Share)",null,6711,{"$f":"+'4. Proposed Cost of Ops - 172'!F50","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G50","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H50","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I50","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G50-'7. Approved Proration - 175'!L50)*'7. Approved Proration - 175'!I50","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G50-'7. Approved Proration - 175'!L50-'7. Approved Proration - 175'!J50","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I50","v":0}]
[37,"Property & Liability Insurance (Hazard)",null,6720,{"$f":"+'4. Proposed Cost of Ops - 172'!F51","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G51","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H51","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I51","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G51-'7. Approved Proration - 175'!L51)*'7. Approved Proration - 175'!I51","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G51-'7. Approved Proration - 175'!L51-'7. Approved Proration - 175'!J51","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I51","v":0}]
[38,"Fidelity Bond Insurance",null,6721,{"$f":"+'4. Proposed Cost of Ops - 172'!F52","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G52","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H52","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I52","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G52-'7. Approved Proration - 175'!L52)*'7. Approved Proration - 175'!I52","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G52-'7. Approved Proration - 175'!L52-'7. Approved Proration - 175'!J52","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I52","v":0}]
[39,"Worker's Compensation",null,6722,{"$f":"+'4. Proposed Cost of Ops - 172'!F53","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G53","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H53","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I53","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G53-'7. Approved Proration - 175'!L53)*'7. Approved Proration - 175'!I53","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G53-'7. Approved Proration - 175'!L53-'7. Approved Proration - 175'!J53","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I53","v":0}]
[40,"Health Insurance and Other Employee Benefits",null,6723,{"$f":"+'4. Proposed Cost of Ops - 172'!F54","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G54","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H54","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I54","v":0},{"$f":"IF($N$11=TRUE,E54,0)","v":0},{"$f":"('6. Approved Cost of Ops - 174 '!G54-'7. Approved Proration - 175'!L54)*'7. Approved Proration - 175'!I54","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G54-'7. Approved Proration - 175'!L54-'7. Approved Proration - 175'!J54","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I54","v":0}]
[41,"Miscellaneous Taxes, Licenses, Permits and Insurance",null,6790,{"$f":"+'4. Proposed Cost of Ops - 172'!F55","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G55","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H55","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I55","v":0},0,{"$f":"('6. Approved Cost of Ops - 174 '!G55-'7. Approved Proration - 175'!L55)*'7. Approved Proration - 175'!I55","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G55-'7. Approved Proration - 175'!L55-'7. Approved Proration - 175'!J55","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I55","v":0}]
[42,"Total Taxes and Insurance",null,"6700T",null,{"$f":"SUM(F49:F55)","v":0},{"$f":"SUM(G49:G55)","v":0},{"$f":"SUM(H49:H55)","v":0},null,{"$f":"SUM(J49:J55)","v":0},{"$f":"SUM(K49:K55)","v":0},{"$f":"SUM(L49:L55)","v":0}]
[null,"Supportive Services Costs:",null,6990]
[43,"Staff Supervisors Salaries",null,null,{"$f":"+'4. Proposed Cost of Ops - 172'!F58","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G58","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H58","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I58","v":0},{"$f":"IF($N$11=TRUE,E58,0)","v":0},{"$f":"('6. Approved Cost of Ops - 174 '!G58-'7. Approved Proration - 175'!L58)*'7. Approved Proration - 175'!I58","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G58-'7. Approved Proration - 175'!L58-'7. Approved Proration - 175'!J58","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I58","v":0}]
[44,"On-site Service Coordinator Salaries and Benefits",null,null,{"$f":"+'4. Proposed Cost of Ops - 172'!F59","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G59","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H59","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I59","v":0},{"$f":"IF($N$11=TRUE,E59,0)","v":0},{"$f":"('6. Approved Cost of Ops - 174 '!G59-'7. Approved Proration - 175'!L59)*'7. Approved Proration - 175'!I59","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G59-'7. Approved Proration - 175'!L59-'7. Approved Proration - 175'!J59","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I59","v":0}]
[45,"On-site Other Supportive Services Staff Salaries",null,null,{"$f":"+'4. Proposed Cost of Ops - 172'!F60","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G60","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H60","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I60","v":0},{"$f":"IF($N$11=TRUE,E60,0)","v":0},{"$f":"('6. Approved Cost of Ops - 174 '!G60-'7. Approved Proration - 175'!L60)*'7. Approved Proration - 175'!I60","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G60-'7. Approved Proration - 175'!L60-'7. Approved Proration - 175'!J60","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I60","v":0}]
[46,"Supportive Services Administrative Overhead",null,null,{"$f":"+'4. Proposed Cost of Ops - 172'!F61","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G61","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H61","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I61","v":0},{"$f":"IF($N$11=TRUE,E61,0)","v":0},{"$f":"('6. Approved Cost of Ops - 174 '!G61-'7. Approved Proration - 175'!L61)*'7. Approved Proration - 175'!I61","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G61-'7. Approved Proration - 175'!L61-'7. Approved Proration - 175'!J61","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I61","v":0}]
[47,"Other Supportive Services Costs",null,6990,{"$f":"+'4. Proposed Cost of Ops - 172'!F62","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!G62","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!H62","v":0},{"$f":"+'4. Proposed Cost of Ops - 172'!I62","v":0},{"$f":"IF($N$11=TRUE,E62,0)","v":0},{"$f":"('6. Approved Cost of Ops - 174 '!G62-'7. Approved Proration - 175'!L62)*'7. Approved Proration - 175'!I62","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G62-'7. Approved Proration - 175'!L62-'7. Approved Proration - 175'!J62","v":0},{"$f":"'4. Proposed Cost of Ops - 172'!I62","v":0}]
[48,"Total Supportive Services Costs",null,"6900T",null,{"$f":"SUM(F58:F62)","v":0},{"$f":"SUM(G58:G62)","v":0},{"$f":"SUM(H58:H62)","v":0},null,{"$f":"SUM(J58:J62)","v":0},{"$f":"SUM(K58:K62)","v":0},{"$f":"SUM(L58:L62)","v":0}]
[49,"Total Cost of Operations",null,"6000T",null,{"$f":"F27+F33+F47+F56+F63","v":0},{"$f":"G27+G33+G47+G56+G63","v":0},{"$f":"H27+H33+H47+H56+H63","v":0},null,{"$f":"J27+J33+J47+J56+J63","v":0},{"$f":"K27+K33+K47+K56+K63","v":0},{"$f":"L27+L33+L47+L56+L63","v":0}]

{"sheet":"8. Actual Cash Flow-180","index":7,"n_rows":107,"n_cols":19,"rows_kept":107,"cut":false,"hidden":false,"merged":[[106,10,106,14],[72,10,72,14],[73,10,73,14],[74,10,74,14],[75,10,75,14],[86,10,86,14],[101,8,101,14],[100,10,100,14],[102,10,102,14],[103,10,103,14],[87,10,87,14],[88,10,88,14],[89,10,89,14],[93,10,93,14],[97,10,97,14],[98,10,98,14],[104,10,104,14],[98,8,98,9],[99,8,99,9],[105,10,105,14],[90,10,90,14],[91,10,91,14],[105,8,105,9],[104,8,104,9],[88,8,88,9],[89,8,89,9],[90,8,90,9],[77,8,77,9],[86,8,86,9],[87,8,87,9],[91,8,91,9],[78,8,78,14],[95,8,95,9],[94,10,94,14],[95,10,95,14],[85,8,85,14],[92,8,92,14],[83,8,83,9],[83,10,83,14],[84,8,84,9],[84,10,84,14],[79,8,79,9],[79,10,79,14],[81,8,81,9],[81,10,81,14],[70,10,70,14],[76,10,76,14],[77,10,77,14],[70,8,70,9],[72,8,72,9],[73,8,73,9],[74,8,74,9],[75,8,75,9],[76,8,76,9],[71,8,71,14],[104,1,104,5],[105,1,105,5],[106,1,106,5],[105,6,105,7],[106,6,106,7],[104,6,104,7],[106,8,106,9],[102,6,102,7],[103,6,103,7],[103,1,103,5],[102,1,102,5],[102,8,102,9],[95,6,95,7],[93,8,93,9],[94,8,94,9],[103,8,103,9],[98,6,98,7],[99,6,99,7],[100,6,100,7],[99,10,99,14],[101,1,101,7],[97,6,97,7],[95,1,95,5],[96,1,96,5],[97,1,97,5],[93,6,93,7],[94,6,94,7],[93,1,93,5],[94,1,94,5],[96,6,96,7],[98,1,98,5],[99,1,99,5],[100,8,100,9],[96,8,96,9],[97,8,97,9],[96,10,96,14],[87,6,87,7],[86,1,86,5],[65,1,65,2],[66,1,66,2],[4,6,4,7],[60,1,60,2],[39,1,39,2],[44,1,44,2],[50,1,50,2],[27,1,27,2],[30,1,30,2],[31,1,31,2],[36,1,36,2],[15,1,15,2],[29,1,29,2],[28,1,28,2],[18,1,18,2],[23,1,23,2],[21,1,21,2],[17,1,17,2],[20,1,20,2],[19,1,19,2],[13,1,13,2],[14,1,14,2],[33,1,33,2],[26,1,26,2],[22,1,22,2],[25,1,25,2],[24,1,24,2],[92,1,92,7],[64,1,64,2],[38,1,38,2],[56,1,56,2],[53,1,53,2],[68,1,68,2],[61,1,61,2],[48,1,48,2],[49,1,49,2],[62,1,62,2],[54,1,54,2],[91,6,91,7],[88,6,88,7],[89,6,89,7],[90,6,90,7],[88,1,88,5],[89,1,89,5],[90,1,90,5],[86,6,86,7],[0,0,0,14],[6,10,6,12],[6,13,8,13],[6,4,6,5],[6,6,6,7],[12,1,12,2],[6,8,6,9],[6,0,8,0],[6,14,8,14],[3,10,3,11],[2,6,2,7],[2,10,2,11],[3,0,3,1],[4,0,4,1],[2,4,2,5],[3,4,3,5],[4,10,4,11],[3,6,3,7],[10,1,10,2],[6,1,8,2],[11,1,11,2],[6,3,8,3],[9,1,9,2],[4,4,4,5],[87,1,87,5],[84,6,84,7],[70,0,71,0],[70,1,70,5],[77,6,77,7],[72,1,72,5],[73,1,73,5],[71,1,71,7],[74,6,74,7],[75,6,75,7],[76,6,76,7],[74,1,74,5],[75,1,75,5],[76,1,76,5],[70,6,70,7],[72,6,72,7],[73,6,73,7],[83,1,83,5],[83,6,83,7],[85,1,85,7],[78,1,78,7],[79,6,79,7],[79,1,79,5],[82,1,82,5],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[5,10,5,11],[82,6,82,7],[82,8,82,9],[82,10,82,14],[80,1,80,5],[80,6,80,7],[80,8,80,9],[80,10,80,14],[81,1,81,5],[81,6,81,7],[63,1,63,2],[32,1,32,2],[16,1,16,2],[35,1,35,2],[34,1,34,2],[47,1,47,2],[45,1,45,2],[46,1,46,2],[43,1,43,2],[37,1,37,2]]}
["Actual Cash Flow (generally not required because of Audit requirement; see Checklist and Certification worksheet for reporting instructions)"]
[null,{"$f":"'1. Operating Budget Instruction'!K1","v":"2025-04-16"},null,null,null,null,"  Reporting Period:",{"$f":"IF(' 2. Checklist and Cert - 170'!D2=\"\",\"\",' 2. Checklist and Cert - 170'!D2)","v":""},"to",{"$f":"IF(' 2. Checklist and Cert - 170'!F2=\"\",\"\",' 2. Checklist and Cert - 170'!F2)","v":""}]
[null,null,null,null,"Prepared by:",null,{"$f":"IF('9. Actual Cost of Ops-181'!C6=\"\",\"\",'9. Actual Cost of Ops-181'!C6)","v":""},null,{"$f":"' 2. Checklist and Cert - 170'!A5","v":"1. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D5=\"\",\"\",' 2. Checklist and Cert - 170'!D5)","v":""},{"$f":"' 2. Checklist and Cert - 170'!J2","v":0},null,{"$f":"CONCATENATE(' 2. Checklist and Cert - 170'!M2,\" Units:\")","v":"Assisted Units:"},{"$f":"IF(' 2. Checklist and Cert - 170'!L2=\"\",0,' 2. Checklist and Cert - 170'!L2)","v":0}]
["Project Name:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!D3=\"\",\"\",' 2. Checklist and Cert - 170'!D3)","v":""},null,"Date Prepared:",null,{"$f":"IF('9. Actual Cost of Ops-181'!H4=\"\",\"\",'9. Actual Cost of Ops-181'!H4)","v":""},null,{"$f":"' 2. Checklist and Cert - 170'!A6","v":"2. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D6=\"\",\"\",' 2. Checklist and Cert - 170'!D6)","v":""},{"$f":"' 2. Checklist and Cert - 170'!J3","v":0},null,"Total Units:",{"$f":"IF(' 2. Checklist and Cert - 170'!L3=\"\",0,' 2. Checklist and Cert - 170'!L3)","v":0}]
["Project County:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!D4=\"\",\"\",' 2. Checklist and Cert - 170'!D4)","v":""},null,"Date Revised:",null,{"$f":"IF('9. Actual Cost of Ops-181'!H5=\"\",\"\",'9. Actual Cost of Ops-181'!H5)","v":""},null,{"$f":"' 2. Checklist and Cert - 170'!A7","v":"3. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D7=\"\",\"\",' 2. Checklist and Cert - 170'!D7)","v":""},{"$f":"' 2. Checklist and Cert - 170'!J4","v":0},null,"Proration %:",{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"' 2. Checklist and Cert - 170'!A8","v":"4. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D8=\"\",\"\",' 2. Checklist and Cert - 170'!D8)","v":""},{"$f":"' 2. Checklist and Cert - 170'!J5","v":0}]
["Line #","Account Name",null,"Acct.\nCode",{"$f":"CONCATENATE(' 2. Checklist and Cert - 170'!M2,\" Units\")","v":"Assisted Units"},null,{"$f":"CONCATENATE(\"Non-\",' 2. Checklist and Cert - 170'!$M$2,\" Units\")","v":"Non-Assisted Units"},null,"Commercial",null,"Project Totals",null,null,"(J)\nBudget vs.\nApproved\nActuals","Rep notes (HCD/CalHFA use only)"]
[null,null,null,null,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)"]
[null,null,null,null,"Sponsor\nActuals","Approved\nActuals","Sponsor\nActuals","Approved\nActuals","Sponsor\nActuals","Approved\nActuals","Approved\nBudget","Sponsor\nActuals","Approved\nActuals"]
[null,"Rent Revenue:",null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false]
[1,"Rent Revenue (Gross Potential Rent)",null,5120,100000,{"$f":"IF($P$10=TRUE,E11,0)","v":0},0,{"$f":"IF($Q$10=TRUE,G11,0)","v":0},null,null,{"$f":"'5. Approved Cash Flow - 173'!L12","v":0},{"$f":"E11+G11+I11","v":100000},0,{"$f":"K11-M11","v":0}]
[2,"Tenant Assistance Payments",null,5121,0,{"$f":"IF($P$10=TRUE,E12,0)","v":0},0,{"$f":"IF($Q$10=TRUE,G12,0)","v":0},null,null,{"$f":"'5. Approved Cash Flow - 173'!L13","v":0},0,0,0]
[3,"Rent Revenue - Stores and Commercial",null,5140,null,null,null,null,0,{"$f":"IF($R$10=TRUE,I13,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L14","v":0},0,0,0]
[4,"Garage and Parking Spaces",null,5170,0,{"$f":"IF($P$10=TRUE,E14,0)","v":0},0,{"$f":"IF($Q$10=TRUE,G14,0)","v":0},0,{"$f":"IF($R$10=TRUE,I14,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L15","v":0},0,0,0]
[5,"Flexible Subsidy Revenue",null,5180,0,{"$f":"IF($P$10=TRUE,E15,0)","v":0},0,{"$f":"IF($Q$10=TRUE,G15,0)","v":0},0,{"$f":"IF($R$10=TRUE,I15,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L16","v":0},0,0,0]
[6,"Miscellaneous Rent Revenue",null,5190,{"$f":"(L16-I16)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M16-J16)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"L16-E16-I16","v":0},{"$f":"M16-F16-J16","v":0},0,{"$f":"IF($R$10=TRUE,I16,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L17","v":0},{"$f":"G77","v":0},{"$f":"I77","v":0},0]
[7,"Total Rent Revenue",null,"5100T",{"$f":"SUM(E11:E16)","v":100000},0,0,0,0,0,0,100000,0,0]
[null,"Vacancies:"]
[8,"Vacancy %",null,null,{"$f":"IF(E11=0,0,E20/(E11+E12))","v":0.1},0,0,0,0,0,{"$f":"'5. Approved Cash Flow - 173'!L20","v":0},{"$f":"IF(L11=0,0,L20/(L11+L12))","v":0.1},{"$f":"IF(M11=0,0,M20/(M11+M12))","v":0}]
[9,"Apartments",null,5220,10000,{"$f":"IF($P$10=TRUE,E20,0)","v":0},0,{"$f":"IF($Q$10=TRUE,G20,0)","v":0},null,null,{"$f":"'5. Approved Cash Flow - 173'!L21","v":0},{"$f":"E20+G20+I20","v":10000},0,{"$f":"K20-M20","v":0}]
[10,"Stores and Commercial",null,5240,null,null,null,null,0,{"$f":"IF($R$10=TRUE,I21,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L22","v":0},0,0,{"$f":"K21-M21","v":0}]
[11,"Rental Concessions",null,5250,0,{"$f":"IF($P$10=TRUE,E22,0)","v":0},0,{"$f":"IF($Q$10=TRUE,G22,0)","v":0},0,{"$f":"IF($R$10=TRUE,I22,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L23","v":0},0,0,{"$f":"K22-M22","v":0}]
[12,"Garage and Parking Spaces",null,5270,0,{"$f":"IF($P$10=TRUE,E23,0)","v":0},0,{"$f":"IF($Q$10=TRUE,G23,0)","v":0},0,{"$f":"IF($R$10=TRUE,I23,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L24","v":0},0,0,{"$f":"K23-M23","v":0}]
[13,"Miscellaneous Vacancies",null,5290,0,{"$f":"IF($P$10=TRUE,E24,0)","v":0},0,{"$f":"IF($Q$10=TRUE,G24,0)","v":0},0,{"$f":"IF($R$10=TRUE,I24,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L25","v":0},0,0,{"$f":"K24-M24","v":0}]
[14,"Total Vacancies",null,"5200T",{"$f":"SUM(E20:E24)","v":10000},0,0,0,0,0,{"$f":"SUM(K20:K24)","v":0},{"$f":"SUM(L20:L24)","v":10000},{"$f":"SUM(M20:M24)","v":0},{"$f":"SUM(N20:N24)","v":0}]
[15,"Net Rental Revenues (Rent Revenue Less Vacancies)",null,"5152N",{"$f":"E17-E25","v":90000},0,0,0,0,0,{"$f":"K17-K25","v":0},{"$f":"L17-L25","v":90000},{"$f":"M17-M25","v":0},{"$f":"N17-N25","v":0}]
[16,"Supportive Services Revenue (enter detail in lines 59-62):",null,5390,{"$f":"(L27-I27)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M27-J27)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"L27-E27-I27","v":0},{"$f":"M27-F27-J27","v":0},0,{"$f":"IF($R$10=TRUE,I27,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L28","v":0},{"$f":"G84","v":0},{"$f":"I84","v":0},{"$f":"K27-M27","v":0}]
[null,"Total Financial Revenue:"]
[17,"Financial Revenue (don't incl. Reserve Acct. Interest)",null,5410,{"$f":"(L29-I29)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M29-J29)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"L29-E29-I29","v":0},{"$f":"M29-F29-J29","v":0},0,{"$f":"IF($R$10=TRUE,I29,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L30","v":0},0,{"$f":"IF($S$10=TRUE,L29,0)","v":0},{"$f":"K29-M29","v":0}]
[18,"Revenue from Investments- Miscellaneous",null,5490,{"$f":"(L30-I30)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M30-J30)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"L30-E30-I30","v":0},{"$f":"M30-F30-J30","v":0},0,{"$f":"IF($R$10=TRUE,I30,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L31","v":0},{"$f":"G91","v":0},{"$f":"I91","v":0},{"$f":"K30-M30","v":0}]
[19,"Total Financial Revenue",null,"5400T",{"$f":"SUM(E29:E30)","v":0},0,0,0,0,0,0,0,0,0]
[null,"Other Revenue:"]
[20,"Laundry and Vending Revenue",null,5910,{"$f":"(L33-I33)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M33-J33)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"L33-E33-I33","v":0},0,0,{"$f":"IF($R$10=TRUE,I33,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L34","v":0},0,{"$f":"IF($S$10=TRUE,L33,0)","v":0},{"$f":"K33-M33","v":0}]
[21,"Tenant Charges",null,5920,{"$f":"(L34-I34)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M34-J34)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,{"$f":"IF($R$10=TRUE,I34,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L35","v":0},0,{"$f":"IF($S$10=TRUE,L34,0)","v":0},{"$f":"K34-M34","v":0}]
[22,"Misc. Revenue (don't include Reserve Withdrawals)",null,5990,{"$f":"(L35-I35)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M35-J35)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,{"$f":"IF($R$10=TRUE,I35,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L36","v":0},{"$f":"G100","v":0},{"$f":"I100","v":0},{"$f":"K35-M35","v":0}]
[23,"Total Other Revenue",null,"5900T",{"$f":"SUM(E33:E35)","v":0},0,0,0,0,0,0,{"$f":"SUM(L33:L35)","v":0},{"$f":"SUM(M33:M35)","v":0},{"$f":"SUM(N33:N35)","v":0}]
[24,"Total Revenue",null,"5000T",{"$f":"+E26+E27+E31+E36","v":90000},0,0,0,0,0,0,90000,0,0]
[25,"Total Cost of Operations before Depreciation",null,"6000T",{"$f":"'9. Actual Cost of Ops-181'!E64","v":0},{"$f":"'9. Actual Cost of Ops-181'!F64","v":0},{"$f":"'9. Actual Cost of Ops-181'!G64","v":0},{"$f":"'9. Actual Cost of Ops-181'!H64","v":0},{"$f":"'9. Actual Cost of Ops-181'!I64","v":0},{"$f":"'9. Actual Cost of Ops-181'!J64","v":0},{"$f":"'9. Actual Cost of Ops-181'!K64","v":0},{"$f":"E38+G38+I38","v":0},{"$f":"F38+H38+J38","v":0},{"$f":"K38-M38","v":0}]
[26,"Profit (Loss) before Depreciation",null,"5060T",{"$f":"E37-E38","v":90000},0,0,0,0,0,{"$f":"K37-K38","v":0},{"$f":"L37-L38","v":90000},{"$f":"M37-M38","v":0},{"$f":"N37-N38","v":0}]
[null,"Financial Expenses including mandatory debt service:"]
[27,"1st Mortgage (P&I)",{"$f":"+IF('5. Approved Cash Flow - 173'!C42=0,\" \",'5. Approved Cash Flow - 173'!C42)","v":" "},6820,{"$f":"(L41-I41)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M41-J41)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"L41-E41-I41","v":0},0,0,{"$f":"IF($R$10=TRUE,I41,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L42","v":0},0,{"$f":"IF($S$10=TRUE,L41,0)","v":0},{"$f":"K41-M41","v":0}]
[28,"2nd Mortgage (P&I)",{"$f":"+IF('5. Approved Cash Flow - 173'!C43=0,\" \",'5. Approved Cash Flow - 173'!C43)","v":" "},6825,{"$f":"(L42-I42)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M42-J42)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,{"$f":"'5. Approved Cash Flow - 173'!L43","v":0},0,{"$f":"IF($S$10=TRUE,L42,0)","v":0},0]
[29,"3rd Mortgage (P&I)",{"$f":"+IF('5. Approved Cash Flow - 173'!C44=0,\" \",'5. Approved Cash Flow - 173'!C44)","v":" "},6825,{"$f":"(L43-I43)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M43-J43)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,{"$f":"'5. Approved Cash Flow - 173'!L44","v":0},0,{"$f":"IF($S$10=TRUE,L43,0)","v":0},0]
[30,"HCD Req. Payments & CalHFA Servicing/Monitoring Fee",null,6825,{"$f":"(L44-I44)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M44-J44)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,{"$f":"'5. Approved Cash Flow - 173'!L45","v":0},0,{"$f":"IF($S$10=TRUE,L44,0)","v":0},0]
[31,"Lease Payment",null,6890,{"$f":"(L45-I45)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M45-J45)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,{"$f":"'5. Approved Cash Flow - 173'!L46","v":0},0,{"$f":"IF($S$10=TRUE,L45,0)","v":0},0]
[32,"Miscellaneous Financial Expenses",null,6890,{"$f":"(L46-I46)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M46-J46)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,{"$f":"'5. Approved Cash Flow - 173'!L47","v":0},{"$f":"G107","v":0},{"$f":"I107","v":0},0]
[33,"Total Financial Expenses",null,"6800T",{"$f":"SUM(E41:E46)","v":0},0,0,0,0,0,{"$f":"SUM(K41:K46)","v":0},{"$f":"SUM(L41:L46)","v":0},{"$f":"SUM(M41:M46)","v":0},{"$f":"SUM(N41:N46)","v":0}]
[null,"Reserves Deposits:"]
[34,"Replacement Reserve - Deposit",null,1320,{"$f":"(L49-I49)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M49-J49)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"L49-E49-I49","v":0},0,0,{"$f":"IF($R$10=TRUE,I49,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L50","v":0},0,{"$f":"IF($S$10=TRUE,L49,0)","v":0},{"$f":"K49-M49","v":0}]
[35,"Operating Reserve - Deposit",null,1330,{"$f":"(L50-I50)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M50-J50)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,{"$f":"IF($R$10=TRUE,I50,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L51","v":0},0,{"$f":"IF($S$10=TRUE,L50,0)","v":0},{"$f":"K50-M50","v":0}]
[36,"Transition Reserve  - Deposit",null,1330,{"$f":"(L51-I51)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M51-J51)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,{"$f":"IF($R$10=TRUE,I51,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L52","v":0},0,{"$f":"IF($S$10=TRUE,L51,0)","v":0},{"$f":"K51-M51","v":0}]
[37,"Other Reserves",{"$f":"+IF('5. Approved Cash Flow - 173'!C53=0,\" \",'5. Approved Cash Flow - 173'!C53)","v":" "},1330,{"$f":"(L52-I52)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M52-J52)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,{"$f":"IF($R$10=TRUE,I52,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L53","v":0},0,{"$f":"IF($S$10=TRUE,L52,0)","v":0},{"$f":"K52-M52","v":0}]
[38,"Other Reserves",{"$f":"+IF('5. Approved Cash Flow - 173'!C54=0,\" \",'5. Approved Cash Flow - 173'!C54)","v":" "},1330,{"$f":"(L53-I53)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M53-J53)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,{"$f":"IF($R$10=TRUE,I53,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L54","v":0},0,{"$f":"IF($S$10=TRUE,L53,0)","v":0},{"$f":"K53-M53","v":0}]
[39,"Total Reserves Deposits",null,"1300T",{"$f":"SUM(E49:E53)","v":0},0,0,0,0,0,0,0,0,0]
[40,"Project Cash Flow",null,null,{"$f":"+E39-E47-E54","v":90000},0,0,0,0,0,0,90000,0,0]
[null,"Additions to Cash Flow:"]
[41,"Borrower Contribution",null,null,{"$f":"(L57-I57)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M57-J57)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"L57-E57-I57","v":0},0,0,{"$f":"IF($R$10=TRUE,I57,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L58","v":0},0,{"$f":"IF($S$10=TRUE,L57,0)","v":0},{"$f":"K57-M57","v":0}]
[42,"Other (specify)",{"$f":"+IF('5. Approved Cash Flow - 173'!C59=0,\" \",'5. Approved Cash Flow - 173'!C59)","v":" "},null,{"$f":"(L58-I58)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M58-J58)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,{"$f":"IF($R$10=TRUE,I58,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L59","v":0},0,{"$f":"IF($S$10=TRUE,L58,0)","v":0},0]
[43,"Other (specify)",{"$f":"+IF('5. Approved Cash Flow - 173'!C60=0,\" \",'5. Approved Cash Flow - 173'!C60)","v":" "},null,{"$f":"(L59-I59)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M59-J59)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,{"$f":"IF($R$10=TRUE,I59,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L60","v":0},0,{"$f":"IF($S$10=TRUE,L59,0)","v":0},0]
[44,"Other (specify)",{"$f":"+IF('5. Approved Cash Flow - 173'!C61=0,\" \",'5. Approved Cash Flow - 173'!C61)","v":" "},null,{"$f":"(L60-I60)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M60-J60)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,{"$f":"IF($R$10=TRUE,I60,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L61","v":0},0,{"$f":"IF($S$10=TRUE,L60,0)","v":0},0]
[45,"Total Additional Revenue",null,null,{"$f":"SUM(E57:E60)","v":0},0,0,0,0,0,0,0,0,0]
[null,"Use of Cash Flow (final approval with Annual Report):"]
[46,"Deferred Developer Fee Payments",null,"",{"$f":"(L63-I63)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M63-J63)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"L63-E63-I63","v":0},0,0,{"$f":"IF($R$10=TRUE,I63,0)","v":0},{"$f":"'5. Approved Cash Flow - 173'!L64","v":0},0,{"$f":"IF($S$10=TRUE,L63,0)","v":0},0]
[47,"Asset Management Fee/Partnership Costs",null,7190,{"$f":"(L64-I64)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M64-J64)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,{"$f":"'5. Approved Cash Flow - 173'!L65","v":0},0,0,0]
[48,"Borrower Distributions",null,null,{"$f":"(L65-I65)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M65-J65)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,{"$f":"'5. Approved Cash Flow - 173'!L66","v":0},0,0,0]
[49,"Residual Receipt Loan Payments",null,null,{"$f":"(L66-I66)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M66-J66)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,{"$f":"'5. Approved Cash Flow - 173'!L67","v":0},0,0,0]
[50,"HCD Interest Payments",null,null,{"$f":"(L67-I67)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M67-J67)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,{"$f":"'5. Approved Cash Flow - 173'!L68","v":0},0,0,0]
[51,"Other (specify)",{"$f":"+IF('5. Approved Cash Flow - 173'!C69=0,\" \",'5. Approved Cash Flow - 173'!C69)","v":" "},null,{"$f":"(L68-I68)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},{"$f":"(M68-J68)*IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0},0,0,0,0,{"$f":"'5. Approved Cash Flow - 173'!L69","v":0},0,0,0]
[52,"Total Use of Cash Flow",null,null,{"$f":"SUM(E63:E68)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Item #","Sponsor itemization of misc. revenues/expenses (total will flow to account above)",null,null,null,null,"Sponsor Actuals",null,"HCD Approved Actuals",null,"HCD Itemization of HCD Approved Actuals"]
[null,"Account 5190 Miscellaneous Rent Revenue",null,null,null,null,null,null,"Account 5190 Miscellaneous Rent Revenue"]
[54]
[55]
[56]
[57]
[58,"Total Account 5190 Miscellaneous Rent Revenue",null,null,null,null,{"$f":"SUM(G73:H76)","v":0},null,{"$f":"SUM(I73:J76)","v":0},null,"Total Account 5190 Miscellaneous Rent Revenue"]
[null,null,null,null,null,null,"Sponsor Actuals",null,"HCD Approved Actuals"]
[null,"Account 5390 Other Service Revenue",null,null,null,null,null,null,"Account 5390 Other Service Revenue"]
[59]
[60]
[61]
[62]
[63,"Total Account 5390 Other Service Revenue",null,null,null,null,{"$f":"SUM(G80:H83)","v":0},null,{"$f":"SUM(I80:J83)","v":0},null,"Total Account 5390 Other Service Revenue"]
[null,null,null,null,null,null,"Sponsor Actuals",null,"HCD Approved Actuals"]
[null,"Account 5490 Revenue from Investments- Miscellaneous",null,null,null,null,null,null,"Account 5490 Revenue from Investments- Miscellaneous"]
[64]
[65]
[66]
[67]
[68,"Total Account 5490 Revenue from Investments- Miscellaneous",null,null,null,null,{"$f":"SUM(G87:H90)","v":0},null,{"$f":"SUM(I87:J90)","v":0},null,"Total Account 5490 Revenue from Investments- Miscellaneous"]
[null,null,null,null,null,null,"Sponsor Actuals",null,"HCD Approved Actuals"]
[null,"Account 5990 Miscellaneous Revenue",null,null,null,null,null,null,"Account 5990 Miscellaneous Revenue"]
[69]
[70]
[71]
[72]
[73]
[74]
[75,"Total Account 5990 Miscellaneous Revenue",null,null,null,null,{"$f":"SUM(G94:H99)","v":0},null,{"$f":"SUM(I94:J99)","v":0},null,"Total Account 5990 Miscellaneous Revenue"]
[null,null,null,null,null,null,"Sponsor Actuals",null,"HCD Approved Actuals"]
[null,"Account 6890 Miscellaneous Financial Expenses",null,null,null,null,null,null,"Account 6890 Miscellaneous Financial Expenses"]
[76]
[77]
[78]
[79]
[80,"Total Account 6890 Miscellaneous Financial Expenses",null,null,null,null,{"$f":"SUM(G103:H106)","v":0},null,{"$f":"SUM(I103:J106)","v":0},null,"Total Account 6890 Miscellaneous Financial Expenses"]

{"sheet":"9. Actual Cost of Ops-181","index":8,"n_rows":124,"n_cols":18,"rows_kept":124,"cut":false,"hidden":false,"merged":[[103,10,103,15],[89,8,89,9],[90,8,90,9],[98,10,98,15],[99,10,99,15],[96,8,96,9],[90,10,90,15],[70,10,70,15],[65,8,65,9],[67,8,67,9],[68,8,68,9],[75,10,75,15],[76,10,76,15],[77,10,77,15],[78,10,78,15],[71,10,71,15],[72,10,72,15],[73,10,73,15],[74,10,74,15],[78,8,78,9],[85,10,85,15],[82,8,82,9],[84,8,84,9],[83,8,83,9],[123,10,123,15],[119,10,119,15],[120,10,120,15],[122,10,122,15],[104,10,104,15],[118,10,118,15],[80,10,80,15],[81,10,81,15],[82,10,82,15],[83,10,83,15],[84,10,84,15],[93,10,93,15],[94,10,94,15],[95,10,95,15],[87,8,87,15],[101,10,101,15],[111,8,111,9],[112,8,112,9],[113,8,113,9],[100,10,100,15],[92,10,92,15],[111,10,111,15],[112,10,112,15],[91,8,91,9],[121,10,121,15],[115,10,115,15],[108,8,108,15],[114,8,114,9],[104,8,104,9],[91,10,91,15],[107,8,107,9],[98,8,98,9],[99,8,99,9],[106,10,106,15],[102,8,102,9],[110,10,110,15],[109,10,109,15],[107,10,107,15],[117,8,117,9],[105,8,105,9],[106,8,106,9],[118,8,118,9],[116,8,116,15],[114,10,114,15],[113,10,113,15],[117,10,117,15],[105,10,105,15],[102,10,102,15],[96,10,96,15],[97,10,97,15],[100,8,100,9],[92,8,92,9],[93,8,93,9],[95,8,95,9],[94,8,94,9],[100,6,100,7],[100,1,100,5],[94,6,94,7],[93,1,93,5],[93,6,93,7],[88,1,88,5],[91,6,91,7],[89,1,89,5],[88,10,88,15],[89,10,89,15],[91,1,91,5],[92,1,92,5],[81,1,81,5],[86,10,86,15],[77,8,77,9],[79,8,79,9],[80,8,80,9],[79,10,79,15],[81,8,81,9],[86,6,86,7],[85,8,85,9],[86,8,86,9],[82,1,82,5],[85,6,85,7],[84,6,84,7],[83,1,83,5],[84,1,84,5],[79,1,79,5],[38,1,38,2],[72,8,72,9],[88,8,88,9],[99,6,99,7],[99,1,99,5],[101,6,101,7],[98,1,98,5],[97,8,97,9],[101,8,101,9],[101,1,101,5],[95,1,95,5],[95,6,95,7],[98,6,98,7],[97,6,97,7],[96,1,96,5],[97,1,97,5],[96,6,96,7],[94,1,94,5],[86,1,86,5],[88,6,88,7],[87,1,87,7],[78,6,78,7],[79,6,79,7],[77,6,77,7],[70,8,70,9],[71,8,71,9],[73,8,73,9],[74,8,74,9],[72,6,72,7],[73,6,73,7],[74,6,74,7],[32,1,32,2],[42,1,42,2],[46,1,46,2],[36,1,36,2],[72,1,72,5],[73,1,73,5],[74,1,74,5],[35,1,35,2],[45,1,45,2],[43,1,43,2],[40,1,40,2],[49,1,49,2],[47,1,47,2],[62,1,62,2],[48,1,48,2],[51,1,51,2],[65,6,65,7],[67,6,67,7],[68,6,68,7],[54,1,54,2],[77,1,77,5],[75,6,75,7],[76,6,76,7],[75,1,75,5],[76,1,76,5],[70,6,70,7],[71,6,71,7],[65,1,65,5],[67,1,67,5],[63,1,63,2],[55,1,55,2],[70,1,70,5],[71,1,71,5],[65,0,66,0],[3,11,3,12],[4,11,4,12],[13,1,13,2],[28,1,28,2],[29,1,29,2],[10,1,10,2],[27,1,27,2],[26,1,26,2],[37,1,37,2],[33,1,33,2],[22,1,22,2],[14,1,14,2],[20,1,20,2],[31,1,31,2],[30,1,30,2],[21,1,21,2],[7,4,7,5],[56,1,56,2],[53,1,53,2],[61,1,61,2],[4,7,4,8],[6,9,6,10],[5,5,5,6],[3,5,3,6],[65,10,65,15],[67,10,67,15],[7,6,7,7],[16,1,16,2],[18,1,18,2],[17,1,17,2],[12,1,12,2],[15,1,15,2],[11,1,11,2],[19,1,19,2],[7,1,9,2],[52,1,52,2],[50,1,50,2],[41,1,41,2],[44,1,44,2],[34,1,34,2],[60,1,60,2],[58,1,58,2],[59,1,59,2],[57,1,57,2],[5,13,5,14],[6,11,6,12],[39,1,39,2],[0,0,0,15],[7,0,9,0],[7,15,9,15],[7,13,7,14],[7,3,9,3],[25,1,25,2],[7,8,7,9],[7,10,7,12],[3,0,3,1],[4,0,4,1],[5,0,5,1],[3,2,3,4],[4,2,4,4],[5,2,5,4],[4,13,4,14],[3,13,3,14],[23,1,23,2],[24,1,24,2],[3,9,3,10],[4,9,4,10],[5,9,5,10],[3,7,3,8],[5,7,5,8],[4,5,4,6],[115,8,115,9],[111,6,111,7],[112,6,112,7],[104,1,104,5],[105,1,105,5],[106,1,106,5],[109,8,109,9],[110,8,110,9],[108,1,108,7],[114,6,114,7],[122,8,122,9],[123,8,123,9],[119,8,119,9],[120,6,120,7],[119,1,119,5],[120,1,120,5],[120,8,120,9],[121,8,121,9],[119,6,119,7],[122,6,122,7],[123,6,123,7],[121,6,121,7],[121,1,121,5],[122,1,122,5],[123,1,123,5],[118,1,118,5],[115,6,115,7],[116,1,116,7],[117,6,117,7],[118,6,118,7],[115,1,115,5],[102,6,102,7],[104,6,104,7],[103,6,103,7],[103,1,103,5],[102,1,102,5],[107,1,107,5],[112,1,112,5],[111,1,111,5],[113,6,113,7],[113,1,113,5],[114,1,114,5],[105,6,105,7],[109,1,109,5],[110,1,110,5],[110,6,110,7],[109,6,109,7],[107,6,107,7],[106,6,106,7],[5,11,5,12],[117,1,117,5],[103,8,103,9],[69,8,69,9],[66,8,66,15],[68,1,68,5],[69,1,69,5],[69,6,69,7],[68,10,68,15],[69,10,69,15],[83,6,83,7],[66,1,66,7],[81,6,81,7],[90,1,90,5],[92,6,92,7],[89,6,89,7],[90,6,90,7],[75,8,75,9],[76,8,76,9],[85,1,85,5],[82,6,82,7],[78,1,78,5],[80,1,80,5],[80,6,80,7]]}
["Actual Cost of Operations (generally not required because of Audit requirement; see Checklist and Certification worksheet for reporting instructions)"]
[null,{"$f":"'1. Operating Budget Instruction'!K1","v":"2025-04-16"},null,null,null,null,null,"Reporting Period:",{"$f":"IF(' 2. Checklist and Cert - 170'!D2=\"\",\"\",' 2. Checklist and Cert - 170'!D2)","v":""},"to",{"$f":"IF(' 2. Checklist and Cert - 170'!F2=\"\",\"\",' 2. Checklist and Cert - 170'!F2)","v":""}]
[]
["Project Name:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!D3=\"\",\"\",' 2. Checklist and Cert - 170'!D3)","v":""},null,null,"Date Prepared:",null,null,null,{"$f":"' 2. Checklist and Cert - 170'!A5","v":"1. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D5=\"\",\"\",' 2. Checklist and Cert - 170'!D5)","v":""},null,{"$f":"CONCATENATE(' 2. Checklist and Cert - 170'!M2,\" Units:\")","v":"Assisted Units:"},null,{"$f":"IF(' 2. Checklist and Cert - 170'!L2=\"\",0,' 2. Checklist and Cert - 170'!L2)","v":0}]
["Project County:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!D4=\"\",\"\",' 2. Checklist and Cert - 170'!D4)","v":""},null,null,"Date Revised:",null,null,null,{"$f":"' 2. Checklist and Cert - 170'!A6","v":"2. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D6=\"\",\"\",' 2. Checklist and Cert - 170'!D6)","v":""},null,"Total Units:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!L3=\"\",0,' 2. Checklist and Cert - 170'!L3)","v":0}]
["Prepared by:",null,null,null,null,"Phone #:",null,null,null,{"$f":"' 2. Checklist and Cert - 170'!A7","v":"3. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D7=\"\",\"\",' 2. Checklist and Cert - 170'!D7)","v":""},null,"Proration %:",null,{"$f":"IF(' 2. Checklist and Cert - 170'!$L$5=0,' 2. Checklist and Cert - 170'!$L$4,' 2. Checklist and Cert - 170'!$L$5)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"' 2. Checklist and Cert - 170'!A8","v":"4. HCD/CalHFA #:  "},null,{"$f":"IF(' 2. Checklist and Cert - 170'!D8=\"\",\"\",' 2. Checklist and Cert - 170'!D8)","v":""}]
["Line #","Account Name",null,"Acct.\nCode",{"$f":"CONCATENATE(' 2. Checklist and Cert - 170'!$M$2,\" Units\")","v":"Assisted Units"},{"$f":"CONCATENATE(' 2. Checklist and Cert - 170'!$M$2,\" Units\")","v":"Assisted Units"},{"$f":"CONCATENATE(\"Non-\",' 2. Checklist and Cert - 170'!$M$2,\" Units\")","v":"Non-Assisted Units"},{"$f":"CONCATENATE(\"Non-\",' 2. Checklist and Cert - 170'!$M$2,\" Units\")","v":"Non-Assisted Units"},"Commercial",null,"Project Total Costs",null,null,"Budget vs Approved",null,"Rep notes (HCD/CalHFA use only)"]
[null,null,null,null,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)","(J)","(K)"]
[null,null,null,null,"Sponsor\nActuals","Approved\nActuals","Sponsor\nActuals","Approved\nActuals","Sponsor\nActuals","Approved\nActuals","Approved\nBudget","Sponsor\nActuals","Approved\nActuals","Variance\nAmount","Var.\n%",null,false,false]
[null,"Administrative Expenses:"]
[1,"Conventions and Meetings",null,6203,{"$f":"(L12-I12)*'7. Approved Proration - 175'!I12","v":0},{"$f":"(M12-J12)*'7. Approved Proration - 175'!I12","v":0},{"$f":"L12-E12-I12","v":0},{"$f":"M12-F12-J12","v":0},0,{"$f":"IF($Q$10=TRUE,I12,0)","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G12","v":0},0,{"$f":"IF($R$10=TRUE,L12,0)","v":0},{"$f":"+K12-M12","v":0},{"$f":"IF(AND(K12=0,M12<>0),\"NA\",IF(N12<0,-N12/K12,0))","v":0}]
[2,"Management Consultants",null,6204,{"$f":"(L13-I13)*'7. Approved Proration - 175'!I13","v":0},{"$f":"(M13-J13)*'7. Approved Proration - 175'!I13","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G13","v":0},0,0,0,0]
[3,"Advertising and Marketing",null,6210,{"$f":"(L14-I14)*'7. Approved Proration - 175'!I14","v":0},{"$f":"(M14-J14)*'7. Approved Proration - 175'!I14","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G14","v":0},0,0,0,0]
[4,"Other Renting Expenses",null,6250,{"$f":"(L15-I15)*'7. Approved Proration - 175'!I15","v":0},{"$f":"(M15-J15)*'7. Approved Proration - 175'!I15","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G15","v":0},0,0,0,0]
[5,"Office Salaries",null,6310,{"$f":"(L16-I16)*'7. Approved Proration - 175'!I16","v":0},{"$f":"(M16-J16)*'7. Approved Proration - 175'!I16","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G16","v":0},0,0,0,0]
[6,"Office Expenses",null,6311,{"$f":"(L17-I17)*'7. Approved Proration - 175'!I17","v":0},{"$f":"(M17-J17)*'7. Approved Proration - 175'!I17","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G17","v":0},0,0,0,0]
[7,"Office or Model Apartment Rent",null,6312,{"$f":"(L18-I18)*'7. Approved Proration - 175'!I18","v":0},{"$f":"(M18-J18)*'7. Approved Proration - 175'!I18","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G18","v":0},0,0,0,0]
[8,"Management Fee-don't inc GP Mngmt Fee",null,6320,{"$f":"(L19-I19)*'7. Approved Proration - 175'!I19","v":0},{"$f":"(M19-J19)*'7. Approved Proration - 175'!I19","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G19","v":0},0,0,0,0]
[9,"Manager or Superintendent Salaries",null,6330,{"$f":"(L20-I20)*'7. Approved Proration - 175'!I20","v":0},{"$f":"(M20-J20)*'7. Approved Proration - 175'!I20","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G20","v":0},0,0,0,0]
[10,"Administrative Rent Free Unit",null,6331,{"$f":"(L21-I21)*'7. Approved Proration - 175'!I21","v":0},{"$f":"(M21-J21)*'7. Approved Proration - 175'!I21","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G21","v":0},0,0,0,0]
[11,"Legal Expense - Project",null,6340,{"$f":"(L22-I22)*'7. Approved Proration - 175'!I22","v":0},{"$f":"(M22-J22)*'7. Approved Proration - 175'!I22","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G22","v":0},0,0,0,0]
[12,"Audit Expense",null,6350,{"$f":"(L23-I23)*'7. Approved Proration - 175'!I23","v":0},{"$f":"(M23-J23)*'7. Approved Proration - 175'!I23","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G23","v":0},0,0,0,0]
[13,"Bookkeeping Fees/ Accounting Services",null,6351,{"$f":"(L24-I24)*'7. Approved Proration - 175'!I24","v":0},{"$f":"(M24-J24)*'7. Approved Proration - 175'!I24","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G24","v":0},0,0,0,0]
[14,"Bad Debts",null,6370,{"$f":"(L25-I25)*'7. Approved Proration - 175'!I25","v":0},{"$f":"(M25-J25)*'7. Approved Proration - 175'!I25","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G25","v":0},0,0,0,0]
[15,"Misc. Administrative Expenses",null,6390,{"$f":"(L26-I26)*'7. Approved Proration - 175'!I26","v":0},{"$f":"(M26-J26)*'7. Approved Proration - 175'!I26","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G26","v":0},{"$f":"G86","v":0},{"$f":"I86","v":0},0,0]
[16,"Total Administrative Expenses",null,"6263T",{"$f":"SUM(E12:E26)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Utilities Expenses:"]
[17,"Electricity",null,6450,{"$f":"(L29-I29)*'7. Approved Proration - 175'!I29","v":0},{"$f":"(M29-J29)*'7. Approved Proration - 175'!I29","v":0},{"$f":"L29-E29-I29","v":0},0,0,{"$f":"IF($Q$10=TRUE,I29,0)","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G29","v":0},0,{"$f":"IF($R$10=TRUE,L29,0)","v":0},{"$f":"+K29-M29","v":0},{"$f":"IF(AND(K29=0,M29<>0),\"NA\",IF(N29<0,-N29/K29,0))","v":0}]
[18,"Water",null,6451,{"$f":"(L30-I30)*'7. Approved Proration - 175'!I30","v":0},{"$f":"(M30-J30)*'7. Approved Proration - 175'!I30","v":0},0,0,0,{"$f":"IF($Q$10=TRUE,I30,0)","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G30","v":0},0,{"$f":"IF($R$10=TRUE,L30,0)","v":0},{"$f":"+K30-M30","v":0},{"$f":"IF(AND(K30=0,M30<>0),\"NA\",IF(N30<0,-N30/K30,0))","v":0}]
[19,"Gas",null,6452,{"$f":"(L31-I31)*'7. Approved Proration - 175'!I31","v":0},{"$f":"(M31-J31)*'7. Approved Proration - 175'!I31","v":0},0,0,0,{"$f":"IF($Q$10=TRUE,I31,0)","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G31","v":0},0,{"$f":"IF($R$10=TRUE,L31,0)","v":0},{"$f":"+K31-M31","v":0},{"$f":"IF(AND(K31=0,M31<>0),\"NA\",IF(N31<0,-N31/K31,0))","v":0}]
[20,"Sewer",null,6453,{"$f":"(L32-I32)*'7. Approved Proration - 175'!I32","v":0},{"$f":"(M32-J32)*'7. Approved Proration - 175'!I32","v":0},0,0,0,{"$f":"IF($Q$10=TRUE,I32,0)","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G32","v":0},0,{"$f":"IF($R$10=TRUE,L32,0)","v":0},{"$f":"+K32-M32","v":0},{"$f":"IF(AND(K32=0,M32<>0),\"NA\",IF(N32<0,-N32/K32,0))","v":0}]
[21,"Total Utilities Expenses",null,"6400T",{"$f":"SUM(E29:E32)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AND(K33=0,M33<>0),\"NA\",IF(N33<0,-N33/K33,0))","v":0}]
[null,"Operating and Maintenance Expenses:"]
[22,"Payroll",null,6510,{"$f":"(L35-I35)*'7. Approved Proration - 175'!I35","v":0},{"$f":"(M35-J35)*'7. Approved Proration - 175'!I35","v":0},{"$f":"L35-E35-I35","v":0},{"$f":"M35-F35-J35","v":0},0,{"$f":"IF($Q$10=TRUE,I35,0)","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G35","v":0},0,{"$f":"IF($R$10=TRUE,L35,0)","v":0},{"$f":"+K35-M35","v":0},{"$f":"IF(AND(K35=0,M35<>0),\"NA\",IF(N35<0,-N35/K35,0))","v":0}]
[23,"Supplies",null,6515,{"$f":"(L36-I36)*'7. Approved Proration - 175'!I36","v":0},{"$f":"(M36-J36)*'7. Approved Proration - 175'!I36","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G36","v":0},0,0,0,0]
[24,"Contracts",null,6520,{"$f":"(L37-I37)*'7. Approved Proration - 175'!I37","v":0},{"$f":"(M37-J37)*'7. Approved Proration - 175'!I37","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G37","v":0},0,0,0,0]
[25,"Operating & Maintenance Rent Free Unit",null,6521,{"$f":"(L38-I38)*'7. Approved Proration - 175'!I38","v":0},{"$f":"(M38-J38)*'7. Approved Proration - 175'!I38","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G38","v":0},0,0,0,0]
[26,"Garbage and Trash Removal",null,6525,{"$f":"(L39-I39)*'7. Approved Proration - 175'!I39","v":0},{"$f":"(M39-J39)*'7. Approved Proration - 175'!I39","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G39","v":0},0,0,0,0]
[27,"Security Payroll/Contracts",null,6530,{"$f":"(L40-I40)*'7. Approved Proration - 175'!I40","v":0},{"$f":"(M40-J40)*'7. Approved Proration - 175'!I40","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G40","v":0},0,0,0,0]
[28,"Security Rent Free Unit",null,6531,{"$f":"(L41-I41)*'7. Approved Proration - 175'!I41","v":0},{"$f":"(M41-J41)*'7. Approved Proration - 175'!I41","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G41","v":0},0,0,0,0]
[29,"Heating/Cooling Repairs and Maintenance",null,6546,{"$f":"(L42-I42)*'7. Approved Proration - 175'!I42","v":0},{"$f":"(M42-J42)*'7. Approved Proration - 175'!I42","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G42","v":0},0,0,0,0]
[30,"Snow Removal",null,6548,{"$f":"(L43-I43)*'7. Approved Proration - 175'!I43","v":0},{"$f":"(M43-J43)*'7. Approved Proration - 175'!I43","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G43","v":0},0,0,0,0]
[31,"Vehicle & Maint Equip Operation/Repairs",null,6570,{"$f":"(L44-I44)*'7. Approved Proration - 175'!I44","v":0},{"$f":"(M44-J44)*'7. Approved Proration - 175'!I44","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G44","v":0},0,0,0,0]
[32,"Lease Expense",null,6580,{"$f":"(L45-I45)*'7. Approved Proration - 175'!I45","v":0},{"$f":"(M45-J45)*'7. Approved Proration - 175'!I45","v":0},{"$f":"L45-E45-I45","v":0},{"$f":"M45-F45-J45","v":0},0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G45","v":0},0,0,{"$f":"+K45-M45","v":0},0]
[33,"Misc. Operating & Maintenance Exp.",null,6590,{"$f":"(L46-I46)*'7. Approved Proration - 175'!I46","v":0},{"$f":"(M46-J46)*'7. Approved Proration - 175'!I46","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G46","v":0},{"$f":"G107","v":0},{"$f":"I107","v":0},0,0]
[34,"Total Operating & Maintenance Exp.",null,"6500T",{"$f":"SUM(E35:E46)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Taxes and Insurance:"]
[35,"Real Estate Taxes",null,6710,{"$f":"(L49-I49)*'7. Approved Proration - 175'!I49","v":0},{"$f":"(M49-J49)*'7. Approved Proration - 175'!I49","v":0},{"$f":"L49-E49-I49","v":0},0,0,{"$f":"IF($Q$10=TRUE,I49,0)","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G49","v":0},0,{"$f":"IF($R$10=TRUE,L49,0)","v":0},{"$f":"+K49-M49","v":0},{"$f":"IF(AND(K49=0,M49<>0),\"NA\",IF(N49<0,-N49/K49,0))","v":0}]
[36,"Payroll Taxes (Project's Share)",null,6711,{"$f":"(L50-I50)*'7. Approved Proration - 175'!I50","v":0},{"$f":"(M50-J50)*'7. Approved Proration - 175'!I50","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G50","v":0},0,0,0,0]
[37,"Property & Liability Insurance (Hazard)",null,6720,{"$f":"(L51-I51)*'7. Approved Proration - 175'!I51","v":0},{"$f":"(M51-J51)*'7. Approved Proration - 175'!I51","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G51","v":0},0,0,0,0]
[38,"Fidelity Bond Insurance",null,6721,{"$f":"(L52-I52)*'7. Approved Proration - 175'!I52","v":0},{"$f":"(M52-J52)*'7. Approved Proration - 175'!I52","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G52","v":0},0,0,0,0]
[39,"Worker's Compensation",null,6722,{"$f":"(L53-I53)*'7. Approved Proration - 175'!I53","v":0},{"$f":"(M53-J53)*'7. Approved Proration - 175'!I53","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G53","v":0},0,0,0,0]
[40,"Health Ins. & Other Employee Benefits",null,6723,{"$f":"(L54-I54)*'7. Approved Proration - 175'!I54","v":0},{"$f":"(M54-J54)*'7. Approved Proration - 175'!I54","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G54","v":0},0,0,0,0]
[41,"Misc. Taxes, Licenses, Permits and Ins.",null,6790,{"$f":"(L55-I55)*'7. Approved Proration - 175'!I55","v":0},{"$f":"(M55-J55)*'7. Approved Proration - 175'!I55","v":0},0,0,0,0,{"$f":"'6. Approved Cost of Ops - 174 '!G55","v":0},{"$f":"G115","v":0},{"$f":"I115","v":0},0,0]
[42,"Total Taxes and Insurance",null,"6700T",{"$f":"SUM(E49:E55)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Supportive Services Costs:",null,6990]
[43,"Staff Supervisors Salaries",null,{"$f":"IF(M58=0,0,IF(M59+M60=0,1,M58/(M59+M60)))","v":0},{"$f":"(L58-I58)*'7. Approved Proration - 175'!I55","v":0},{"$f":"(M58-J58)*'7. Approved Proration - 175'!I55","v":0},{"$f":"L58-E58-I58","v":0},0,0,{"$f":"IF($Q$10=TRUE,I58,0)","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G58","v":0},0,0,{"$f":"+K58-M58","v":0},{"$f":"IF(AND(K58=0,M58<>0),\"NA\",IF(N58<0,-N58/K58,0))","v":0}]
[44,"Service Coordinator Salaries and Benefits",null,null,{"$f":"(L59-I59)*'7. Approved Proration - 175'!I62","v":0},{"$f":"(M59-J59)*'7. Approved Proration - 175'!I62","v":0},{"$f":"L59-E59-I59","v":0},{"$f":"M59-F59-J59","v":0},0,{"$f":"IF($Q$10=TRUE,I59,0)","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G59","v":0},0,{"$f":"IF($R$10=TRUE,L59,0)","v":0},{"$f":"+K59-M59","v":0},{"$f":"IF(AND(K59=0,M59<>0),\"NA\",IF(N59<0,-N59/K59,0))","v":0}]
[45,"Other Supportive Services Staff Salaries",null,null,{"$f":"(L60-I60)*'7. Approved Proration - 175'!I56","v":0},{"$f":"(M60-J60)*'7. Approved Proration - 175'!I56","v":0},0,0,0,{"$f":"IF($Q$10=TRUE,I60,0)","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G60","v":0},0,{"$f":"IF($R$10=TRUE,L60,0)","v":0},{"$f":"+K60-M60","v":0},0]
[46,"Supportive Serv Administrative Overhead",null,{"$f":"IF(M61=0,0,M61/M63)","v":0},{"$f":"(L61-I61)*'7. Approved Proration - 175'!I57","v":0},{"$f":"(M61-J61)*'7. Approved Proration - 175'!I57","v":0},0,0,0,{"$f":"IF($Q$10=TRUE,I61,0)","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G61","v":0},0,{"$f":"IF($R$10=TRUE,L61,0)","v":0},{"$f":"+K61-M61","v":0},0]
[47,"Other Supportive Services Costs",null,6990,{"$f":"(L62-I62)*'7. Approved Proration - 175'!I62","v":0},{"$f":"(M62-J62)*'7. Approved Proration - 175'!I62","v":0},0,0,0,{"$f":"IF($Q$10=TRUE,I62,0)","v":0},{"$f":"'6. Approved Cost of Ops - 174 '!G62","v":0},{"$f":"G124","v":0},{"$f":"I124","v":0},{"$f":"+K62-M62","v":0},0]
[48,"Total Supportive Services Costs",null,"6900T",{"$f":"SUM(E58:E62)","v":0},{"$f":"SUM(F58:F62)","v":0},0,0,0,0,0,0,0,0,0]
[49,"Total Cost of Operations",null,"6000T",{"$f":"E27+E33+E47+E56+E63","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["Line #","Sponsor itemization of misc. rev./exp. (total flows to account above)",null,null,null,null,"Sponsor Actuals",null,"Approved Actuals",null,"Itemization of Approved Actuals"]
[null,"Account 6390 Miscellaneous Administrative Expenses",null,null,null,null,null,null,"Account 6390 Miscellaneous Administrative Expenses"]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68,"Total Account 6390 Miscellaneous Administrative Expenses",null,null,null,null,{"$f":"SUM(G68:H85)","v":0},null,{"$f":"SUM(I68:J85)","v":0},null,"Total Account 6390 Miscellaneous Administrative Expenses"]
[null,null,null,null,null,null,"Sponsor Actuals",null,"Approved Actuals"]
[null,"Account 6590 Miscellaneous Operations & Maintenance Expenses",null,null,null,null,null,null,"Account 6590 Miscellaneous Operations & Maintenance Expenses"]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87,"Total Account 6590 Miscellaneous Operations & Maintenance Expenses",null,null,null,null,{"$f":"SUM(G89:H106)","v":0},null,{"$f":"SUM(I89:J106)","v":0},null,"Total Account 6590 Miscellaneous Operations & Maintenance Expenses"]
[null,null,null,null,null,null,"Sponsor Actuals",null,"Approved Actuals"]
[null,"Account 6790 Misc. Taxes, Licenses, Permits & Insurance",null,null,null,null,null,null,"Account 6790 Misc. Taxes, Licenses, Permits & Insurance"]
[88]
[89]
[90]
[91]
[92]
[93,"Total Account 6790 Misc. Taxes, Licenses, Permits & Insurance",null,null,null,null,{"$f":"SUM(G110:H114)","v":0},null,{"$f":"SUM(I110:J114)","v":0},null,"Total Account 6790 Misc. Taxes, Licenses, Permits & Insurance"]
[null,null,null,null,null,null,"Sponsor Actuals",null,"Approved Actuals"]
[null,"Account 6990 Other Supportive Services Costs",null,null,null,null,null,null,"Account 6990 Other Supportive Services Costs"]
[94]
[95]
[96]
[97]
[98]
[99]
[100,"Total Account 6990 Other Supportive Services Costs",null,null,null,null,{"$f":"SUM(G118:H123)","v":0},null,{"$f":"SUM(I118:J123)","v":0},null,"Total Account 6990 Other Supportive Services Costs"]