{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["1. Operating Budget Instruction","2. AMC 170 Checklist and Cert","3. AMC 171 Prop Cost of Opertns","4. AMC 172 Proposed CF Analysis","5. AMC 173 HCD Apprvd Ops Costs","6. AMC 174 HCD Apprvd Proratn","7. AMC 175 HCD Apprvd Cash Flow","8. AMC 180 Actual Opertng Costs","9. AMC 181 Actual CF Analysis"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":14,"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":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[10,0,10,12],[11,0,11,12],[5,0,5,12],[6,0,6,12],[7,0,7,12],[8,0,8,12],[9,0,9,12],[3,0,3,12],[4,0,4,12],[0,10,0,12],[1,0,1,12],[2,0,2,12],[0,0,0,9],[25,0,25,12],[24,0,24,12],[12,0,12,12],[14,0,14,12],[15,0,15,12],[19,0,19,12],[20,0,20,12],[21,0,21,12],[23,0,23,12],[18,0,18,12],[22,0,22,12],[13,0,13,12],[16,0,16,12],[17,0,17,12]]}
["1.  OPERATING BUDGET INSTRUCTIONS",null,null,null,null,null,null,null,null,null,"rev. 9/16/2022"]
["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 HCD's Audit 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-funded units are noted as Assisted, except for MHP-type Projects, which will be referred to as Restricted. This will change\n    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. The AMC Form 180 and AMC Form 181 worksheets (Tabs 8 and 9) are to be completed only if the project is not required to submit\n    Audited Financial Statements to HCD.  Audited Financial Statements submitted must include the CPA's Notes to the Financial Statements\n    and Supplemental Information, in accordance with the details and requirements in the HCD Audit Handbook."]
["This workbook consists of nine (9) Worksheets (Tabs) displayed at the bottom of the page. Each Tab indicates the name of the AMC Form/Worksheet. This Workbook must be saved to your computer before entering any data. To save this Workbook, HCD recommends Microsoft Edge as the browser to get the required results. Regardless of your browser, please download the form before entering any\ndata, and be sure to save it in the format known as \"Excel Macro-Enabled Workbook (*.xlsm). \nTo save this Microsoft Excel workbook to your computer using Microsoft Edge, click the \"File\" menu, choose the \"Save As\" option, then\nselect \"More options...\". In the pop-up window, you will find the field \"File name\", enter the name of your project, and in the field\n\"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:"]
["2. AMC Form 170 - Checklist and Certification, with Submittal Instructions\n3. AMC Form 171 - Prop Cost of Opertns (Proposed Cost of Operations - Operating Budget)\n4. AMC Form 172 - Proposed CF Analysis (Proposed Cash Flow Analysis - Operating Budget)\n    These worksheets are used for the Sponsor’s Proposed Operating Budget and are due along with the Schedule of Rental Income 60 days\n    before the beginning of the Project’s Fiscal Year. When completed, email the electronic versions of both the Operating Budget Workbook\n    and the Schedule of Rental Income to AMCBranch@hcd.ca.gov and \"CC\" your AMC Representatives' emails."]
["The next three worksheet Tabs (colored green) are for the Department's use only:"]
["5. AMC Form 173 - HCD Apprvd Ops Costs (HCD Approved Cost of Operations - Approved Operating Budget)\n6. AMC Form 174 - HCD Apprvd Proratn (HCD Approved Proration of Costs of Operations - Approved Operating Budget)\n7. AMC Form 175 - HCD Apprvd Cash Flow (HCD Approved Cash Flow Analysis - Approved Operating Budget)\n    The Department uses these worksheets for the HCD Approved Operating Budget. When approved, the AMC Representative will email the\n    approved copy of the Project Operating Budget Workbook to the Sponsor."]
["The last two worksheet tabs (colored in bright yellow) are to be completed by the Sponsor (if applicable):"]
["8. AMC Form 180 - Actual Opertng Costs (Actual Cost of Operations - Annual Report)\n9. AMC Form 181 - Actual CF Analysis (Actual Cash Flow Analysis - Annual Report)\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 HCD/CalHFA Audit Handbook. Refer to the HCD Web site for the Audit Handbook by following the link:"]
["https://www.hcd.ca.gov/grants-funding/already-have-funding/docs/hcdcalhfaaudithandbook.pdf"]
["If required, these two worksheets (AMC Form 180 & AMC Form 181) must be submitted as part of the Annual Reports along with other\nHCD Forms and Reports applicable to your Project/loan program. The Annual Report Package is due to the Department 90 days after the\nend of the Fiscal Year. Please 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. AMC 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 HCD Contract Numbers for the Project in the designated cells.\nc.  The Proration Percentage is calculated depending on the number of HCD-assisted units in the Project. For example, if the Project has \n     150 units total with 50 units assisted by an HCD 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.\nd.  Checklist of Required Items: check the box for each item once completed and prepare to email it to AMCBranch@hcd.ca.gov and \"CC\"\n     to your AMC Representatives.\ne.  Certification: complete this required area as described above."]
["3. AMC Form 171 - 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. \n     To see a description of the 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). \n     For SUHRP and CHRP-R Programs: this Account is to record Tenant Care Expenses for Group and Nursing Homes, Assisted Living\n     facilities, and Board and Care facilities.\ne.  Important: Any costs anticipated to be capitalized should not be included in the Cost of Operations."]
["4. AMC Form 172 - 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 Residential\n     and Commercial costs). If Project includes Commercial costs, enter the Total Proposed Commercial costs in Line 16 Column C. Column A\n     (Proposed Assisted Units costs) and Column B (Proposed Non-Assisted Units costs) are auto-filled by the proration percentage, using \n     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."]
["SUBMITTAL INSTRUCTIONS -- Worksheets (tabs) 2, 3 and 4:"]
["a. Complete the following tabs within the Operating Budget Workbook:\n     2. AMC Form 170 - Checklist and Certification\n     3. AMC Form 171 - Proposed Cost of Operations\n     4. AMC Form 172 - Proposed Cash Flow Analysis\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 Operating Budget Workbook and the Schedule of Rental Income (SRI) fully completed in Excel formats (not in PDF) to \n     AMCBranch@hcd.ca.gov and \"CC\" your AMC Representatives for review and input of approved amounts.\ne. Remember, if you don't know the name or email of your Representatives, you need to contact the HCD AMC Branch at \n    AMCBranch@hcd.ca.gov or (916) 263-2771 and ask for assistance."]
["HCD REVIEW AND APPROVAL -- Worksheets (tabs) 5, 6 and 7:"]
["a.  The following Worksheets are for AMC use only:\n     5. AMC Form 173 - HCD Approved Cost of Operations \n     6. AMC Form 174 - HCD Approved Proration of Cost of Operations \n     7. AMC Form 175 - HCD Approved Cash Flow Analysis\nb.  Upon completing the review and approval of these tabs, your AMC Representative(s) will fill out the green-shaded Operating Budget HCD\n     AMC Representative Approval section on Worksheet/Tab 2. AMC Form 170 - Checklist and Certification; and will email back Excel\n     Workbook with any additional approvals or conditions to the Management Agent, Borrower, or Sponsor to be retained for their records.\nc. \"Approved\" data entered by your AMC Representative on tabs 5, 6, and 7 will auto-fill to tabs 8 and 9. \n     The approved data on tabs 8 and 9 will be used at the end of the Project's Fiscal Year for the Annual Report, if the Project is not required\n     to submit Audited Financial Statements. \t\t"]
["ANNUAL REPORT -- Worksheets (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 HCD/CalHFA Audit Handbook (refer to the HCD'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. AMC Form 180 - Actual Cost of Operations and 9. AMC Form 181 - Actual Cash Flow Analysis, the entire\n    completed Excel Workbook must be emailed to HCD as part of the Annual Report and the Audit Report (if required by the Regulatory\n    Agreement), and other forms as required by the HCD Program.\ne. Upon completing these tabs, your AMC Representative(s) will fill out the green-shaded Annual Report HCD AMC Representative \n    Approval section on Worksheet/Tab 2. AMC 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. AMC 170 Checklist and Cert","index":1,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[46,0,46,11],[44,0,44,2],[45,0,45,11],[39,0,39,11],[38,0,38,11],[43,3,43,6],[43,8,43,9],[53,0,53,11],[51,0,52,2],[51,10,52,10],[51,7,52,7],[47,0,47,11],[48,0,48,11],[49,1,49,11],[51,3,51,6],[51,8,51,9],[52,3,52,6],[52,8,52,9],[50,0,50,11],[0,0,0,10],[3,7,3,10],[8,3,8,6],[6,3,6,6],[5,3,5,6],[8,0,8,2],[3,3,3,6],[2,0,2,2],[5,7,5,10],[6,7,6,11],[4,7,4,10],[4,3,4,6],[7,0,7,2],[7,8,7,11],[7,3,7,6],[1,0,1,11],[14,1,14,11],[17,0,17,11],[34,0,34,11],[25,0,25,11],[15,1,15,11],[31,3,31,6],[31,8,31,9],[30,3,30,6],[30,8,30,9],[28,1,28,11],[16,1,16,11],[18,0,18,11],[23,8,23,9],[27,0,27,11],[22,3,22,6],[22,8,22,9],[3,0,3,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[2,8,2,10],[8,7,8,11],[9,8,9,11],[10,4,10,11],[11,0,11,11],[13,0,13,11],[10,0,10,2],[9,4,9,5],[9,6,9,7],[9,0,9,2],[12,0,12,11],[29,0,29,11],[32,0,32,11],[33,0,33,11],[35,0,35,11],[19,0,19,11],[23,3,23,6],[26,0,26,11],[24,0,24,11],[20,0,20,2],[21,0,21,2],[22,0,22,2],[20,3,21,11],[23,0,23,2],[22,7,23,7],[22,10,23,10],[30,0,31,2],[30,7,31,7],[30,10,31,10],[41,0,41,2],[42,0,42,2],[43,0,43,2],[41,3,42,11],[43,7,44,7],[43,10,44,10],[44,3,44,6],[44,8,44,9],[40,0,40,11],[36,1,36,11],[37,1,37,11]]}
["2.  AMC Form 170 - CHECKLIST AND CERTIFICATION",null,null,null,null,null,null,null,null,null,null,{"$f":"'1. Operating Budget Instruction'!K1","v":"rev. 9/16/2022"},null,null,null,null,"Alameda"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alpine"]
["Reporting Period:",null,null,null,"to",null,null,{"$f":"IF(ISNUMBER(SEARCH(\"*MHP*\",ContractNumber)),\"Number of Restricted Units\",\"\")","v":""},{"$f":"IF(SUMPRODUCT(-- (ISNUMBER(SEARCH({\"*DRP*\",\"*FMTW*\",\"*FWHG*\",\"*GHI*\",\"*HOME\",\"*MHP*\",\"*TOD*\"},D6:D8)))),\"Number of Restricted Units: \",\"Number of Assisted Units: \")","v":"Number of Assisted Units: "},null,null,null,null,null,{"$f":"IF(I3=\"Number of Restricted Units: \",\"Restricted\",\"Assisted\")","v":"Assisted"},null,"Amador"]
["Project Name:",null,null,null,null,null,null,"Total Number of Units: ",null,null,null,null,null,null,null,null,"Butte"]
["Project Location-County:  ",null,null,null,null,null,null,{"$f":"CONCATENATE('2. AMC 170 Checklist and Cert'!O3,\" Units\",\"/Total Units Prorata: \")","v":"Assisted Units/Total Units Prorata: "},null,null,null,{"$f":"IF(L4=0,0,L3/L4)","v":0},null,null,null,null,"Calaveras"]
["1. HCD Contract #:  ",null,null,null,null,null,null,"Other Prorata % Used: ",null,null,null,null,null,null,null,null,"Colusa"]
["2. HCD Contract #:  ",null,null,null,null,null,null,"HCD Approved Other Prorata % based on:",null,null,null,null,null,null,null,null,"Contra Costa"]
["3. HCD Contract #:  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Del Norte"]
["Prepared by:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"El Dorado"]
["Date Prepared:",null,null,null,"Phone #:",null,null,null,null,null,null,null,null,null,null,null,"Fresno"]
["Date Revised:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glenn"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Humboldt"]
["OPERATING BUDGET - CHECKLIST OF REQUIRED ITEMS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Imperial"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inyo"]
[null,"2. AMC Form 170 - Checklist and Certification - yellow-shaded fields to be completed by Sponsor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kern"]
[null,"3. AMC Form 171 - Proposed Cost of Operations - yellow-shaded fields to be completed by Sponsor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kings"]
[null,"4. AMC Form 172 - Proposed Cash Flow Analysis - yellow-shaded fields to be completed by Sponsor",null,null,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,null,null,null,"Lassen"]
["OPERATING BUDGET CERTIFICATION:\nI certify that: I am authorized to provide the information contained in tabs 2 through 4 and it is accurate to the best of my knowledge. Certification is indicated by checking the appropriate box and completing the remainder of this certification block.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Los Angeles"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Madera"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mariposa"]
[null,null,null,"Name",null,null,null,null,"Title",null,null,"Date",null,null,null,null,"Mendocino"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Merced"]
["SUBMITTAL INSTRUCTIONS:  After completing the Certification section above, submit this Operating Budget Workbook together with your Schedule of Rental Income as email attachments to the Department at: AMCBranch@hcd.ca.gov and \"CC\" your Asset Management Representatives's emails.  Both items mentioned above MUST be submitted in Excel formats.  If you don't know the name or email of your AMC Representatives, please call (916) 263-2771.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modoc"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mono"]
["HCD AMC REPRESENTATIVE APPROVAL (for HCD Use only):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monterey"]
[null,"I hereby approve this Operating Budget, for all tabs through and including Tab 7, AMC Form 175 - HCD Approved Cash Flow Analysis.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Napa"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nevada"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orange"]
[null,null,null,"Name",null,null,null,null,"Title",null,null,"Date",null,null,null,null,"Placer"]
[null,null,null,null,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,null,null,null,"Riverside"]
["ANNUAL REPORT - CHECKLIST OF REQUIRED ITEMS:\n(only for Projects not required to submit Audited Financial Statements to HCD, or does not have the required supplimental information)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sacramento"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"San Benito"]
[null,"8. AMC Form 180 - Actual Cost of Operations - yellow-shaded fields to be completed by Sponsor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"San Bernardino"]
[null,"9. AMC Form 181 - Actual Cash Flow Analysis - yellow-shaded fields to be completed by Sponsor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"San Diego"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"San Francisco"]
["ANNUAL REPORT CERTIFICATION:\nI certify that: 1) I am authorized to provide the information contained in Items 1. through 4. above, as well as the Schedule of Rental Income (SRI), and 2) it is accurate to the best of my knowledge. Certification is indicated by checking the appropriate checkbox and completing the remainder of this certification block.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"San Joaquin"]
["I certify that: 1) I am authorized to provide the information contained in Tabs 8 through 9, and 2) it is accurate to the best of my knowledge. Certification is indicated by checking the appropriate checkbox and completing the remainder of this certification block.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"San Luis Obispo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"San Mateo"]
[null,null,null,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,null,null,null,"Santa Clara"]
[null,null,null,"Name",null,null,null,null,"Title",null,null,"Date",null,null,null,null,"Santa Cruz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shasta"]
["SUBMITTAL INSTRUCTIONS:  After completing the Certification, above, submit this Operating Budget workbook in Excel format as an email attachment to amcbranch@hcd.ca.gov and copy your Asset Management Representative.  If you don't know the name or email of your Representative, please call (916) 263-2771.",null,null,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,null,null,null,"Siskiyou"]
["HCD AMC REPRESENTATIVE APPROVAL (for HCD Use only):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solano"]
[null,"I hereby approve this Annual Operating Budget Report on tab 8, AMC Form 180 Actual Cost of Operations and on tab 9, AMC Form 181 Actual Cash Flow Analysis. ",null,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,null,null,null,"Stanislaus"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sutter"]
[null,null,null,"Name",null,null,null,null,"Title",null,null,"Date",null,null,null,null,"Tehama"]
[null,null,null,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,null,null,null,"Tulare"]
[null,null,null,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,null,null,null,"Ventura"]
[null,null,null,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,null,null,null,"Yuba"]

{"sheet":"3. AMC 171 Prop Cost of Opertns","index":2,"n_rows":124,"n_cols":10,"rows_kept":124,"cut":false,"hidden":false,"merged":[[68,1,68,7],[0,0,0,8],[3,5,3,6],[28,1,28,2],[30,1,30,2],[47,1,47,2],[3,0,3,1],[4,0,4,1],[3,3,3,4],[1,2,1,3],[5,0,5,1],[4,7,4,8],[14,1,14,2],[15,1,15,2],[11,1,11,2],[13,1,13,2],[12,1,12,2],[4,5,4,6],[4,3,4,4],[5,5,5,6],[19,1,19,2],[20,1,20,2],[45,1,45,2],[35,1,35,2],[48,1,48,2],[54,1,54,2],[62,1,62,2],[55,1,55,2],[60,1,60,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[44,1,44,2],[86,1,86,9],[1,7,1,8],[2,7,2,8],[3,7,3,8],[49,1,49,2],[5,7,5,8],[18,1,18,2],[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],[5,3,5,4],[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],[85,8,85,9],[75,8,75,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],[104,8,104,9],[106,1,106,7],[103,1,103,7],[101,1,101,7],[27,1,27,2],[83,1,83,7],[77,8,77,9],[78,8,78,9],[77,1,77,7],[88,8,88,9],[65,1,65,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],[38,1,38,2],[39,1,39,2],[85,1,85,7],[89,8,89,9],[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],[110,8,110,9],[109,1,109,7],[110,1,110,7],[114,1,114,7],[113,1,113,7],[112,8,112,9],[113,8,113,9],[115,1,115,9],[76,1,76,7],[73,8,73,9],[94,8,94,9],[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],[95,1,95,7],[90,1,90,7],[93,1,93,7],[94,1,94,7],[111,1,111,7],[107,8,107,9],[111,8,111,9],[101,8,101,9],[102,8,102,9],[103,8,103,9],[108,1,108,9],[102,1,102,7],[105,8,105,9],[106,8,106,9],[74,1,74,7],[75,1,75,7],[66,1,66,9],[71,8,71,9],[68,8,68,9],[65,8,65,9],[67,8,67,9],[100,8,100,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],[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],[1,0,2,1],[2,2,2,6],[6,0,6,9],[9,1,9,2],[8,1,8,2],[7,1,7,2],[72,1,72,7],[73,1,73,7],[69,1,69,7],[70,1,70,7],[71,1,71,7],[42,1,42,2],[63,1,63,2],[61,1,61,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[29,1,29,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[46,1,46,2],[50,1,50,2]]}
["3.  AMC Form 171 - PROPOSED COST OF OPERATIONS - Operating Budget",null,null,null,null,null,null,null,null,{"$f":"'1. Operating Budget Instruction'!K1","v":"rev. 9/16/2022"}]
[null,null,"Reporting Period:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D3=\"\",\"\",'2. AMC 170 Checklist and Cert'!D3)","v":""},"to",{"$f":"IF('2. AMC 170 Checklist and Cert'!F3=\"\",\"\",'2. AMC 170 Checklist and Cert'!F3)","v":""},"Date Prepared:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D10=\"\",\"\",'2. AMC 170 Checklist and Cert'!D10)","v":""}]
[null,null,null,null,null,null,null,"Date Revised:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D11=\"\",\"\",'2. AMC 170 Checklist and Cert'!D11)","v":""}]
["Project Name:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D4=\"\",\"\",'2. AMC 170 Checklist and Cert'!D4)","v":""},"1. HCD Contract #:  ",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D6=\"\",\"\",'2. AMC 170 Checklist and Cert'!D6)","v":""},null,{"$f":"CONCATENATE('2. AMC 170 Checklist and Cert'!O3,\" Units:\")","v":"Assisted Units:"},null,{"$f":"IF('2. AMC 170 Checklist and Cert'!L3=\"\",0,'2. AMC 170 Checklist and Cert'!L3)","v":0}]
["Project County:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D5=\"\",\"\",'2. AMC 170 Checklist and Cert'!D5)","v":""},"2. HCD Contract #:  ",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D7=\"\",\"\",'2. AMC 170 Checklist and Cert'!D7)","v":""},null,"Total Units:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!L4=\"\",0,'2. AMC 170 Checklist and Cert'!L4)","v":0}]
["Prepared By:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D9=\"\",\"\",'2. AMC 170 Checklist and Cert'!D9)","v":""},"3. HCD Contract #:  ",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D8=\"\",\"\",'2. AMC 170 Checklist and Cert'!D8)","v":""},null,"Proration %:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0}]
[]
[null,null,null,"Account\nCode","(A)\n Total \nBudget\nProposed","(B)","(C)","(D)","(E)","(F)"]
[null,null,null,null," Total ","Proration",{"$f":"'2. AMC 170 Checklist and Cert'!O3","v":"Assisted"},{"$f":"CONCATENATE(\"Non-\",'2. AMC 170 Checklist and Cert'!$O$3)","v":"Non-Assisted"}]
["Line #","Account Name",null,"Account\nCode","Budget\nProposed","Percentage\nProposed","Units\nProposed","Units\nProposed","Commercial\nProposed"," Total\n(C)+(D)+(E)"]
[null,"Administrative Expenses:"]
[1,"Conventions and Meetings",null,6203,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E12-I12)*F12","v":0},{"$f":"+(E12-G12-I12)","v":0},0,{"$f":"SUM(G12:I12)","v":0}]
[2,"Management Consultants",null,6204,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E13-I13)*F13","v":0},{"$f":"+(E13-G13-I13)","v":0},0,{"$f":"SUM(G13:I13)","v":0}]
[3,"Advertising and Marketing",null,6210,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0]
[4,"Other Renting Expenses",null,6250,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0]
[5,"Office Salaries",null,6310,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0]
[6,"Office Expenses",null,6311,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0]
[7,"Office or Model Apartment Rent",null,6312,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0]
[8,"Management Fee (do not include GP Management Fee)",null,6320,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0]
[9,"Manager or Superintendent Salaries",null,6330,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0]
[10,"Administrative Rent Free Unit",null,6331,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0]
[11,"Legal Expense - Project",null,6340,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0]
[12,"Audit Expense",null,6350,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E23-I23)*F23","v":0},{"$f":"+(E23-G23-I23)","v":0},0,{"$f":"SUM(G23:I23)","v":0}]
[13,"Bookkeeping Fees/ Accounting Services",null,6351,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E24-I24)*F24","v":0},{"$f":"+(E24-G24-I24)","v":0},0,{"$f":"SUM(G24:I24)","v":0}]
[14,"Bad Debts",null,6370,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E25-I25)*F25","v":0},{"$f":"+(E25-G25-I25)","v":0},0,0]
[15,"Misc. Administrative Expenses",null,6390,{"$f":"I86","v":0},{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E26-I26)*F26","v":0},{"$f":"+(E26-G26-I26)","v":0},0,{"$f":"SUM(G26:I26)","v":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}]
[null,"Utilities:"]
[17,"Electricity",null,6450,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E29-I29)*F29","v":0},{"$f":"+(E29-G29-I29)","v":0},0,0]
[18,"Water",null,6451,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E30-I30)*F30","v":0},{"$f":"+(E30-G30-I30)","v":0},0,0]
[19,"Gas",null,6452,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E31-I31)*F31","v":0},{"$f":"+(E31-G31-I31)","v":0},0,0]
[20,"Sewer",null,6453,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E32-I32)*F32","v":0},{"$f":"+(E32-G32-I32)","v":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}]
[null,"Operating and Maintenance Expenses:"]
[22,"Payroll",null,6510,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E35-I35)*F35","v":0},{"$f":"+(E35-G35-I35)","v":0},0,{"$f":"SUM(G35:I35)","v":0}]
[23,"Supplies",null,6515,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0]
[24,"Contracts",null,6520,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0]
[25,"Operating and Maintenance Rent Free Unit",null,6521,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E38-I38)*F38","v":0},{"$f":"+(E38-G38-I38)","v":0},0,{"$f":"SUM(G38:I38)","v":0}]
[26,"Garbage and Trash Removal",null,6525,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E39-I39)*F39","v":0},{"$f":"+(E39-G39-I39)","v":0},0,{"$f":"SUM(G39:I39)","v":0}]
[27,"Security Payroll/Contracts",null,6530,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E40-I40)*F40","v":0},{"$f":"+(E40-G40-I40)","v":0},0,{"$f":"SUM(G40:I40)","v":0}]
[28,"Security Rent Free Unit",null,6531,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E41-I41)*F41","v":0},{"$f":"+(E41-G41-I41)","v":0},0,{"$f":"SUM(G41:I41)","v":0}]
[29,"Heating/Cooling Repairs and Maintenance",null,6546,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E42-I42)*F42","v":0},{"$f":"+(E42-G42-I42)","v":0},0,{"$f":"SUM(G42:I42)","v":0}]
[30,"Snow Removal",null,6548,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0]
[31,"Vehicle and Maintenance Equip. Operation and Repairs",null,6570,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0]
[32,"Lease Expense",null,6580,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E45-I45)*F45","v":0},{"$f":"+(E45-G45-I45)","v":0},0,{"$f":"SUM(G45:I45)","v":0}]
[33,"Misc. Operating & Maintenance Expenses",null,6590,{"$f":"I107","v":0},{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":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}]
[null,"Taxes and Insurance:"]
[35,"Real Estate Taxes",null,6710,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E49-I49)*F49","v":0},{"$f":"+(E49-G49-I49)","v":0},0,{"$f":"SUM(G49:I49)","v":0}]
[36,"Payroll Taxes (Project's Share)",null,6711,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0]
[37,"Property & Liability Insurance (Hazard)",null,6720,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E51-I51)*F51","v":0},{"$f":"+(E51-G51-I51)","v":0},0,{"$f":"SUM(G51:I51)","v":0}]
[38,"Fidelity Bond Insurance",null,6721,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0]
[39,"Worker's Compensation",null,6722,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0]
[40,"Health Insurance and Other Employee Benefits",null,6723,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0]
[41,"Miscellaneous Taxes, Licenses, Permits and Insurance",null,6790,{"$f":"I115","v":0},{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":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}]
[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. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E58-I58)*F58","v":0},{"$f":"+(E58-G58-I58)","v":0},0,{"$f":"SUM(G58:I58)","v":0}]
[44,"On-site Services Coordinator Salaries and Benefits",null,null,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E59-I59)*F59","v":0},{"$f":"+(E59-G59-I59)","v":0},0,{"$f":"SUM(G59:I59)","v":0}]
[45,"On-site Other Supportive Services Staff Salaries",null,null,0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E60-I60)*F60","v":0},{"$f":"+(E60-G60-I60)","v":0},0,{"$f":"SUM(G60:I60)","v":0}]
[46,"Supportive Services Administrative Overhead",null,{"$f":"IF(E61=0,0,E61/E63)","v":0},0,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E61-I61)*F61","v":0},{"$f":"+(E61-G61-I61)","v":0},0,{"$f":"SUM(G61:I61)","v":0}]
[47,"Other Supportive Services Costs",null,6990,{"$f":"I124","v":0},{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(E62-I62)*F62","v":0},{"$f":"+(E62-G62-I62)","v":0},0,{"$f":"SUM(G62:I62)","v":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}]
[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}]
[]
[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]
[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":"4. AMC 172 Proposed CF Analysis","index":3,"n_rows":109,"n_cols":8,"rows_kept":109,"cut":false,"hidden":false,"merged":[[0,0,0,6],[75,6,75,7],[78,6,78,7],[100,6,100,7],[101,6,101,7],[95,6,95,7],[98,6,98,7],[10,1,10,2],[11,1,11,2],[12,1,12,2],[8,4,9,4],[8,5,9,5],[7,0,9,0],[3,3,3,4],[4,3,4,4],[5,3,5,4],[74,6,74,7],[8,7,9,7],[7,1,9,2],[13,1,13,2],[74,1,74,5],[3,0,3,1],[4,0,4,1],[5,0,5,1],[105,6,105,7],[75,1,75,5],[76,1,76,5],[77,1,77,5],[86,6,86,7],[93,6,93,7],[103,1,103,7],[92,6,92,7],[89,6,89,7],[97,6,97,7],[77,6,77,7],[76,6,76,7],[87,1,87,7],[79,6,79,7],[82,6,82,7],[83,6,83,7],[84,1,84,5],[84,6,84,7],[100,1,100,5],[89,1,89,5],[97,1,97,5],[98,1,98,5],[108,1,108,5],[88,1,88,5],[105,1,105,5],[106,1,106,5],[107,1,107,5],[108,6,108,7],[106,6,106,7],[107,6,107,7],[104,6,104,7],[99,6,99,7],[88,6,88,7],[102,6,102,7],[96,6,96,7],[104,1,104,5],[90,1,90,5],[91,1,91,5],[95,1,95,5],[96,1,96,5],[94,1,94,7],[91,6,91,7],[90,6,90,7],[92,1,92,5],[101,1,101,5],[99,1,99,5],[14,1,14,2],[17,1,17,2],[18,1,18,2],[20,1,20,2],[19,1,19,2],[31,1,31,2],[8,6,9,6],[7,3,9,3],[21,1,21,2],[22,1,22,2],[23,1,23,2],[25,1,25,2],[26,1,26,2],[30,1,30,2],[29,1,29,2],[24,1,24,2],[27,1,27,2],[28,1,28,2],[32,1,32,2],[33,1,33,2],[50,1,50,2],[34,1,34,2],[35,1,35,2],[47,1,47,2],[36,1,36,2],[40,1,40,2],[15,1,15,2],[16,1,16,2],[65,1,65,2],[51,1,51,2],[37,1,37,2],[38,1,38,2],[49,1,49,2],[44,1,44,2],[45,1,45,2],[48,1,48,2],[39,1,39,2],[46,1,46,2],[72,0,73,0],[72,1,72,5],[68,1,68,2],[54,1,54,2],[61,1,61,2],[70,1,70,2],[57,1,57,2],[63,1,63,2],[85,6,85,7],[81,6,81,7],[55,1,55,2],[73,1,73,7],[72,6,72,7],[82,1,82,5],[83,1,83,5],[66,1,66,2],[67,1,67,2],[80,1,80,7],[78,1,78,5],[56,1,56,2],[62,1,62,2],[81,1,81,5],[85,1,85,5],[64,1,64,2]]}
["4.  AMC Form 172 - PROPOSED CASH FLOW ANALYSIS - Operating Budget",null,null,null,null,null,null,{"$f":"'1. Operating Budget Instruction'!K1","v":"rev. 9/16/2022"}]
[null,null,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!C2","v":"Reporting Period:"},{"$f":"IF('2. AMC 170 Checklist and Cert'!D3=\"\",\"\",'2. AMC 170 Checklist and Cert'!D3)","v":""},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F2","v":"to"},{"$f":"IF('2. AMC 170 Checklist and Cert'!F3=\"\",\"\",'2. AMC 170 Checklist and Cert'!F3)","v":""},"Date Prepared:",{"$f":"IF('2. AMC 170 Checklist and Cert'!D10=\"\",\"\",'2. AMC 170 Checklist and Cert'!D10)","v":""}]
[null,null,null,null,null,null,"Date Revised:",{"$f":"IF('2. AMC 170 Checklist and Cert'!D11=\"\",\"\",'2. AMC 170 Checklist and Cert'!D11)","v":""}]
["Project Name:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D4=\"\",\"\",'2. AMC 170 Checklist and Cert'!D4)","v":""},"1. HCD Contract #:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D6=\"\",\"\",'2. AMC 170 Checklist and Cert'!D6)","v":""},{"$f":"CONCATENATE('2. AMC 170 Checklist and Cert'!O3,\" Units:\")","v":"Assisted Units:"},{"$f":"IF('2. AMC 170 Checklist and Cert'!L3=\"\",0,'2. AMC 170 Checklist and Cert'!L3)","v":0}]
["Project County:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D5=\"\",\"\",'2. AMC 170 Checklist and Cert'!D5)","v":""},"2. HCD Contract #:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D7=\"\",\"\",'2. AMC 170 Checklist and Cert'!D7)","v":""},"Total Units:",{"$f":"IF('2. AMC 170 Checklist and Cert'!L4=\"\",0,'2. AMC 170 Checklist and Cert'!L4)","v":0}]
["Prepared By:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D9=\"\",\"\",'2. AMC 170 Checklist and Cert'!D9)","v":""},"3. HCD Contract #:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D8=\"\",\"\",'2. AMC 170 Checklist and Cert'!D8)","v":""},"Proration %:",{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0}]
[]
["Line #","Account Name",null,"Account\nCode","(A)","(B)","(C)","(D)"]
[null,null,null,null,{"$f":"CONCATENATE('2. AMC 170 Checklist and Cert'!$O$3,\" Units Proposed\")","v":"Assisted Units Proposed"},{"$f":"CONCATENATE(\"Non-\",'2. AMC 170 Checklist and Cert'!$O$3,\" Units Proposed\")","v":"Non-Assisted Units Proposed"},"Commercial\nProposed","Total Project Proposed"]
[]
[null,"Rent Revenue:"]
[1,"Rent Revenue - Gross Potential",null,5120,0,0,null,{"$f":"SUM(E12:G12)","v":0}]
[2,"Tenant Assistance Payments",null,5121,0,0,null,{"$f":"SUM(E13:G13)","v":0}]
[3,"Rent Revenue - Stores and Commercial",null,5140,null,null,0,{"$f":"SUM(E14:G14)","v":0}]
[4,"Garage and Parking Spaces",null,5170,0,0,0,{"$f":"SUM(E15:G15)","v":0}]
[5,"Flexible Subsidy Revenue",null,5180,0,0,0,{"$f":"SUM(E16:G16)","v":0}]
[6,"Miscellaneous Rent Revenue",null,5190,{"$f":"(H17-G17)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"H17-E17-G17","v":0},0,{"$f":"G79","v":0}]
[7,"Total Rent Revenue",null,"5100T",{"$f":"SUM(E12:E17)","v":0},{"$f":"SUM(F12:F17)","v":0},{"$f":"SUM(G12:G17)","v":0},{"$f":"SUM(H12:H17)","v":0}]
[null,"Vacancies:"]
[8,"Vacancy %",null,null,0,0,0]
[9,"Apartments",null,5220,{"$f":"SUM(E12+E13)*E20","v":0},{"$f":"SUM(F12+F13)*F20","v":0},null,{"$f":"SUM(E21:G21)","v":0}]
[10,"Stores and Commercial",null,5240,null,null,{"$f":"G14*G20","v":0},{"$f":"SUM(E22:G22)","v":0}]
[11,"Rental Concessions",null,5250,0,0,0,{"$f":"SUM(E23:G23)","v":0}]
[12,"Garage and Parking Spaces",null,5270,0,0,0,{"$f":"SUM(E24:G24)","v":0}]
[13,"Miscellaneous Vacancies",null,5290,0,0,0,{"$f":"SUM(E25:G25)","v":0}]
[14,"Total Vacancies",null,"5200T",{"$f":"SUM(E21:E25)","v":0},{"$f":"SUM(F21:F25)","v":0},{"$f":"SUM(G21:G25)","v":0},{"$f":"SUM(H21:H25)","v":0}]
[15,"Net Rental Revenues (Rent Revenue Less Vacancies)",null,"5152N",{"$f":"E18-E26","v":0},{"$f":"F18-F26","v":0},{"$f":"G18-G26","v":0},{"$f":"H18-H26","v":0}]
[16,"Supportive Services Revenue (enter detail in lines 59-62):",null,5390,{"$f":"(H28-G28)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"H28-E28-G28","v":0},0,{"$f":"G86","v":0}]
[null,"Financial Revenue:"]
[17,"Financial Revenue (don't incl. Reserve Acct. Interest)",null,5410,{"$f":"(H30-G30)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"H30-E30-G30","v":0},0,0]
[18,"Revenue from Investments- Miscellaneous",null,5490,{"$f":"(H31-G31)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"H31-E31-G31","v":0},0,{"$f":"G93","v":0}]
[19,"Total Financial Revenue",null,"5400T",{"$f":"SUM(E30:E31)","v":0},{"$f":"SUM(F30:F31)","v":0},{"$f":"SUM(G30:G31)","v":0},{"$f":"SUM(H30:H31)","v":0}]
[null,"Other Revenue:"]
[20,"Laundry and Vending Revenue",null,5910,{"$f":"(H34-G34)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"H34-E34-G34","v":0},0,0]
[21,"Tenant Charges",null,5920,{"$f":"(H35-G35)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"H35-E35-G35","v":0},0,0]
[22,"Misc. Revenue (don't include Reserve Withdrawals)",null,5990,{"$f":"(H36-G36)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"H36-E36-G36","v":0},0,{"$f":"G102","v":0}]
[23,"Total Other Revenue",null,"5900T",{"$f":"SUM(E34:E36)","v":0},{"$f":"SUM(F34:F36)","v":0},{"$f":"SUM(G34:G36)","v":0},{"$f":"SUM(H34:H36)","v":0}]
[24,"Total Revenue",null,"5000T",{"$f":"E27+E28+E32+E37","v":0},{"$f":"F27+F28+F32+F37","v":0},{"$f":"G27+G28+G32+G37","v":0},{"$f":"H27+H28+H32+H37","v":0}]
[25,"Total Cost of Operations before Depreciation",null,"6000T",{"$f":"'3. AMC 171 Prop Cost of Opertns'!G64","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!H64","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I64","v":0},{"$f":"SUM(E39:G39)","v":0}]
[26,"Profit (Loss) before Depreciation",null,"5060T",{"$f":"E38-E39","v":0},{"$f":"F38-F39","v":0},{"$f":"G38-G39","v":0},{"$f":"H38-H39","v":0}]
[null,"Financial Expenses including mandatory debt service:"]
[27,"1st Mortgage (P&I)",null,6820,{"$f":"(H42-G42)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"H42-E42-G42","v":0},0,0]
[28,"2nd Mortgage (P&I)",null,6825,{"$f":"(H43-G43)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0]
[29,"3rd Mortgage (P&I)",null,6825,{"$f":"(H44-G44)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0]
[30,"HCD Required Payments",null,6825,{"$f":"(H45-G45)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0]
[31,"Lease Payment",null,6890,{"$f":"(H46-G46)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0]
[32,"Miscellaneous Financial Expenses",null,6890,{"$f":"(H47-G47)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,{"$f":"G109","v":0}]
[33,"Total Financial Expenses",null,"6800T",{"$f":"SUM(E42:E47)","v":0},{"$f":"SUM(F42:F47)","v":0},{"$f":"SUM(G42:G47)","v":0},{"$f":"SUM(H42:H47)","v":0}]
[null,"Reserves Deposits:"]
[34,"Replacement Reserve - Deposit",null,1320,{"$f":"(H50-G50)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"H50-E50-G50","v":0},0,0]
[35,"Operating Reserve - Deposit",null,1330,{"$f":"(H51-G51)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"H51-E51-G51","v":0},0,0]
[36,"Transition Reserve  - Deposit",null,1330,{"$f":"(H52-G52)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"H52-E52-G52","v":0},0,0]
[37,"Other (specify)",null,1330,{"$f":"(H53-G53)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"H53-E53-G53","v":0},0,0]
[38,"Other (specify)",null,1330,{"$f":"(H54-G54)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"H54-E54-G54","v":0},0,0]
[39,"Total Reserves Deposits",null,"1300T",{"$f":"SUM(E50:E54)","v":0},{"$f":"SUM(F50:F54)","v":0},{"$f":"SUM(G50:G54)","v":0},{"$f":"SUM(H50:H54)","v":0}]
[40,"Project Cash Flow",null,null,{"$f":"E40-E48-E55","v":0},{"$f":"F40-F48-F55","v":0},{"$f":"G40-G48-G55","v":0},{"$f":"H40-H48-H55","v":0}]
[null,"Additions to Cash Flow:"]
[41,"Borrower Contribution",null,null,{"$f":"(H58-G58)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"H58-E58-G58","v":0},0,0]
[42,"Other (specify)",null,null,{"$f":"(H59-G59)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"H59-E59-G59","v":0},0,0]
[43,"Other (specify)",null,null,{"$f":"(H60-G60)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"H60-E60-G60","v":0},0,0]
[44,"Other (specify)",null,null,{"$f":"(H61-G61)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"H61-E61-G61","v":0},0,0]
[45,"Total Additional Revenue",null,null,{"$f":"SUM(E58:E61)","v":0},{"$f":"SUM(F58:F61)","v":0},{"$f":"SUM(G58:G61)","v":0},{"$f":"SUM(H58:H61)","v":0}]
[null,"Use of Cash Flow (final approval with Annual Report):"]
[46,"Deferred Developer Fee Payments",null,"",{"$f":"(H64-G64)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"H64-E64-G64","v":0},0,0]
[47,"Asset Mgmt Fee (CHRP-R/SUHRP & HOME pre-UMR)",null,7190,{"$f":"(H65-G65)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0]
[48,"Asset Mgmt Fee/Prtrshp Costs (MHP/HOME under UMR)",null,7190,{"$f":"(H66-G66)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0]
[49,"Borrower Distributions",null,null,{"$f":"(H67-G67)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0]
[50,"Residual Receipt Loan Payments",null,null,{"$f":"(H68-G68)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0]
[51,"HCD Interest Payments",null,"",{"$f":"(H69-G69)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0]
[52,"Other (specify)",null,null,{"$f":"(H70-G70)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0]
[53,"Total Use of Cash Flow",null,null,{"$f":"SUM(E64:E70)","v":0},{"$f":"SUM(F64:F70)","v":0},{"$f":"SUM(G64:G70)","v":0},{"$f":"SUM(H64:H70)","v":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(G75:H78)","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(G82:H85)","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(G89:H92)","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(G96:H101)","v":0}]
[]
[null,"Account 6890 Miscellaneous Financial Expenses"]
[76]
[77]
[78]
[79]
[80,"Total Account 6890 Miscellaneous Financial Expenses",null,null,null,null,{"$f":"SUM(G105:H108)","v":0}]

{"sheet":"5. AMC 173 HCD Apprvd Ops Costs","index":4,"n_rows":64,"n_cols":10,"rows_kept":64,"cut":false,"hidden":false,"merged":[[56,8,62,8],[0,0,0,7],[7,8,9,8],[7,1,7,3],[7,0,9,0],[8,3,9,3],[7,4,7,5],[7,6,7,7],[3,3,3,4],[4,3,4,4],[5,3,5,4],[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],[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],[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],[36,1,36,2],[37,1,37,2],[38,1,38,2],[43,1,43,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[34,1,34,2],[39,1,39,2],[40,1,40,2],[35,1,35,2],[33,1,33,2],[41,1,41,2],[42,1,42,2]]}
["5.  AMC Form 173 - HCD APPROVED COST OF OPERATIONS - Approved Operating Budget",null,null,null,null,null,null,null,{"$f":"'1. Operating Budget Instruction'!K1","v":"rev. 9/16/2022"}]
[null,null,"                                             Reporting Period:",{"$f":"IF('2. AMC 170 Checklist and Cert'!D3=\"\",\"\",'2. AMC 170 Checklist and Cert'!D3)","v":""},"to",{"$f":"IF('2. AMC 170 Checklist and Cert'!F3=\"\",\"\",'2. AMC 170 Checklist and Cert'!F3)","v":""},null,"Date Prepared:",{"$f":"IF('2. AMC 170 Checklist and Cert'!D10=\"\",\"\",'2. AMC 170 Checklist and Cert'!D10)","v":""}]
[null,null,null,null,null,null,null,"Date Revised:",{"$f":"IF('2. AMC 170 Checklist and Cert'!D11=\"\",\"\",'2. AMC 170 Checklist and Cert'!D11)","v":""}]
["Project Name:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D4=\"\",\"\",'2. AMC 170 Checklist and Cert'!D4)","v":""},"1. HCD Contract #:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D6=\"\",\"\",'2. AMC 170 Checklist and Cert'!D6)","v":""},null,{"$f":"CONCATENATE('2. AMC 170 Checklist and Cert'!O3,\" Units:\")","v":"Assisted Units:"},{"$f":"IF('2. AMC 170 Checklist and Cert'!L3=\"\",0,'2. AMC 170 Checklist and Cert'!L3)","v":0}]
["Project County:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D5=\"\",\"\",'2. AMC 170 Checklist and Cert'!D5)","v":""},"2. HCD Contract #:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D7=\"\",\"\",'2. AMC 170 Checklist and Cert'!D7)","v":""},null,"Total Units:",{"$f":"IF('2. AMC 170 Checklist and Cert'!L4=\"\",0,'2. AMC 170 Checklist and Cert'!L4)","v":0}]
["Approved By:",null,null,"3. HCD Contract #:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D8=\"\",\"\",'2. AMC 170 Checklist and Cert'!D8)","v":""},null,"Phone #:",{"$f":"IF('2. AMC 170 Checklist and Cert'!G10=\"\",\"\",'2. AMC 170 Checklist and Cert'!G10)","v":""}]
[]
["Line #","HCD use only",null,null,"Total Proposed Budget",null,"Total HCD Approved Budget",null,"HCD Rep notes (HCD use only)"]
[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":"+'3. AMC 171 Prop Cost of Opertns'!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":"+'3. AMC 171 Prop Cost of Opertns'!E13","v":0},0,0,0]
[3,"Advertising and Marketing",null,6210,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E14","v":0},0,0,0]
[4,"Other Renting Expenses",null,6250,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E15","v":0},0,0,0]
[5,"Office Salaries",null,6310,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E16","v":0},0,0,0]
[6,"Office Expenses",null,6311,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E17","v":0},0,0,0]
[7,"Office or Model Apartment Rent",null,6312,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E18","v":0},0,0,0]
[8,"Management Fee (do not include GP Management Fee)",null,6320,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E19","v":0},0,0,0]
[9,"Manager or Superintendent Salaries",null,6330,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E20","v":0},0,0,0]
[10,"Administrative Rent Free Unit",null,6331,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E21","v":0},0,0,0]
[11,"Legal Expense - Project",null,6340,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E22","v":0},0,0,0]
[12,"Audit Expense",null,6350,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E23","v":0},0,0,0]
[13,"Bookkeeping Fees/ Accounting Services",null,6351,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E24","v":0},0,0,0]
[14,"Bad Debts",null,6370,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E25","v":0},0,0,0]
[15,"Misc. Administrative Expenses",null,6390,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!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":"+'3. AMC 171 Prop Cost of Opertns'!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":"+'3. AMC 171 Prop Cost of Opertns'!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":"+'3. AMC 171 Prop Cost of Opertns'!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":"+'3. AMC 171 Prop Cost of Opertns'!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":"+'3. AMC 171 Prop Cost of Opertns'!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":"+'3. AMC 171 Prop Cost of Opertns'!E36","v":0},0,0,0]
[24,"Contracts",null,6520,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E37","v":0},0,0,0]
[25,"Operating and Maintenance Rent Free Unit",null,6521,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E38","v":0},0,0,0]
[26,"Garbage and Trash Removal",null,6525,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E39","v":0},0,0,0]
[27,"Security Payroll/Contracts",null,6530,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E40","v":0},0,0,0]
[28,"Security Rent Free Unit",null,6531,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E41","v":0},0,0,0]
[29,"Heating/Cooling Repairs and Maintenance",null,6546,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E42","v":0},0,0,0]
[30,"Snow Removal",null,6548,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E43","v":0},0,0,0]
[31,"Vehicle and Maintenance Equip. Operation and Repairs",null,6570,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E44","v":0},0,0,0]
[32,"Lease Expense",null,6580,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!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":"+'3. AMC 171 Prop Cost of Opertns'!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":"+'3. AMC 171 Prop Cost of Opertns'!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":"+'3. AMC 171 Prop Cost of Opertns'!E50","v":0},0,0,0]
[37,"Property & Liability Insurance (Hazard)",null,6720,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E51","v":0},0,0,0]
[38,"Fidelity Bond Insurance",null,6721,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E52","v":0},0,0,0]
[39,"Worker's Compensation",null,6722,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E53","v":0},0,0,0]
[40,"Health Insurance and Other Employee Benefits",null,6723,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!E54","v":0},0,0,0]
[41,"Miscellaneous Taxes, Licenses, Permits and Insurance",null,6790,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!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":"+'3. AMC 171 Prop Cost of Opertns'!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":"+'3. AMC 171 Prop Cost of Opertns'!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":"+'3. AMC 171 Prop Cost of Opertns'!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":"+'3. AMC 171 Prop Cost of Opertns'!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":"+'3. AMC 171 Prop Cost of Opertns'!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":"6. AMC 174 HCD Apprvd Proratn","index":5,"n_rows":64,"n_cols":14,"rows_kept":64,"cut":false,"hidden":false,"merged":[[0,0,0,10],[5,10,5,11],[8,3,9,3],[7,4,7,7],[7,8,7,11],[3,6,3,7],[1,3,1,4],[4,6,4,7],[5,6,5,7],[7,0,9,0],[3,4,3,5],[4,4,4,5],[5,0,5,1],[5,4,5,5],[3,0,3,1],[4,0,4,1],[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],[32,1,32,2],[28,1,28,2],[29,1,29,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[30,1,30,2],[31,1,31,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],[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],[51,1,51,2],[42,1,42,2]]}
["6.  AMC Form 174 - HCD APPROVED PRORATION OF COST OF OPERATIONS - Approved Operating Budget",null,null,null,null,null,null,null,null,null,null,{"$f":"'1. Operating Budget Instruction'!K1","v":"rev. 9/16/2022"}]
[null,null,null,"                           Reporting Period:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D3=\"\",\"\",'2. AMC 170 Checklist and Cert'!D3)","v":""},"to",{"$f":"IF('2. AMC 170 Checklist and Cert'!F3=\"\",\"\",'2. AMC 170 Checklist and Cert'!F3)","v":""},null,null,"Date Prepared:",{"$f":"IF('2. AMC 170 Checklist and Cert'!D10=\"\",\"\",'2. AMC 170 Checklist and Cert'!D10)","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Date Revised:",{"$f":"IF('2. AMC 170 Checklist and Cert'!D11=\"\",\"\",'2. AMC 170 Checklist and Cert'!D11)","v":""}]
["Project Name:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D4=\"\",\"\",'2. AMC 170 Checklist and Cert'!D4)","v":""},null,"1. HCD Contract #:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D6=\"\",\"\",'2. AMC 170 Checklist and Cert'!D6)","v":""},{"$f":"'2. AMC 170 Checklist and Cert'!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"CONCATENATE('2. AMC 170 Checklist and Cert'!O3,\" Units:\")","v":"Assisted Units:"},{"$f":"IF('2. AMC 170 Checklist and Cert'!L3=\"\",0,'2. AMC 170 Checklist and Cert'!L3)","v":0}]
["Project County:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D5=\"\",\"\",'2. AMC 170 Checklist and Cert'!D5)","v":""},null,"2. HCD Contract #:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D7=\"\",\"\",'2. AMC 170 Checklist and Cert'!D7)","v":""},{"$f":"'2. AMC 170 Checklist and Cert'!I4","v":0},null,null,"Total Units:",{"$f":"IF('2. AMC 170 Checklist and Cert'!L4=\"\",0,'2. AMC 170 Checklist and Cert'!L4)","v":0}]
["Approved By:",null,null,null,"3. HCD Contract #:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D8=\"\",\"\",'2. AMC 170 Checklist and Cert'!D8)","v":""},{"$f":"'2. AMC 170 Checklist and Cert'!I5","v":0},null,"Phone #:",{"$f":"IF('2. AMC 170 Checklist and Cert'!G10=\"\",\"\",'2. AMC 170 Checklist and Cert'!G10)","v":""}]
[]
["Line #","HCD use only",null,null,"Prorated Proposed Budget",null,null,null,"Prorated HCD 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. AMC 170 Checklist and Cert'!$O$3,\" Units\")","v":"Assisted Units"},{"$f":"CONCATENATE(\"Non-\",'2. AMC 170 Checklist and Cert'!$O$3,\" Units\")","v":"Non-Assisted Units"},"Commercial","Proration\nPercentage",{"$f":"CONCATENATE('2. AMC 170 Checklist and Cert'!$O$3,\" Units\")","v":"Assisted Units"},{"$f":"CONCATENATE(\"Non-\",'2. AMC 170 Checklist and Cert'!$O$3,\" 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":"+'3. AMC 171 Prop Cost of Opertns'!F12","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G12","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H12","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I12","v":0},{"$f":"IF($N$11=TRUE,E12,0)","v":0},{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G12-'6. AMC 174 HCD Apprvd Proratn'!L12)*'6. AMC 174 HCD Apprvd Proratn'!I12","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G12-'6. AMC 174 HCD Apprvd Proratn'!L12-'6. AMC 174 HCD Apprvd Proratn'!J12","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I12","v":0}]
[2,"Management Consultants",null,6204,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F13","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G13","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H13","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I13","v":0},{"$f":"IF($N$11=TRUE,E13,0)","v":0},{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G13-'6. AMC 174 HCD Apprvd Proratn'!L13)*'6. AMC 174 HCD Apprvd Proratn'!I13","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G13-'6. AMC 174 HCD Apprvd Proratn'!L13-'6. AMC 174 HCD Apprvd Proratn'!J13","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I13","v":0}]
[3,"Advertising and Marketing",null,6210,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F14","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G14","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H14","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I14","v":0},{"$f":"IF($N$11=TRUE,E14,0)","v":0},{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G14-'6. AMC 174 HCD Apprvd Proratn'!L14)*'6. AMC 174 HCD Apprvd Proratn'!I14","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G14-'6. AMC 174 HCD Apprvd Proratn'!L14-'6. AMC 174 HCD Apprvd Proratn'!J14","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I14","v":0}]
[4,"Other Renting Expenses",null,6250,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F15","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G15","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H15","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I15","v":0},{"$f":"IF($N$11=TRUE,E15,0)","v":0},{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G15-'6. AMC 174 HCD Apprvd Proratn'!L15)*'6. AMC 174 HCD Apprvd Proratn'!I15","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G15-'6. AMC 174 HCD Apprvd Proratn'!L15-'6. AMC 174 HCD Apprvd Proratn'!J15","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I15","v":0}]
[5,"Office Salaries",null,6310,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F16","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G16","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H16","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I16","v":0},{"$f":"IF($N$11=TRUE,E16,0)","v":0},{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G16-'6. AMC 174 HCD Apprvd Proratn'!L16)*'6. AMC 174 HCD Apprvd Proratn'!I16","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G16-'6. AMC 174 HCD Apprvd Proratn'!L16-'6. AMC 174 HCD Apprvd Proratn'!J16","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I16","v":0}]
[6,"Office Expenses",null,6311,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F17","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G17","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H17","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I17","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G17-'6. AMC 174 HCD Apprvd Proratn'!L17)*'6. AMC 174 HCD Apprvd Proratn'!I17","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G17-'6. AMC 174 HCD Apprvd Proratn'!L17-'6. AMC 174 HCD Apprvd Proratn'!J17","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I17","v":0}]
[7,"Office or Model Apartment Rent",null,6312,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F18","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G18","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H18","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I18","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G18-'6. AMC 174 HCD Apprvd Proratn'!L18)*'6. AMC 174 HCD Apprvd Proratn'!I18","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G18-'6. AMC 174 HCD Apprvd Proratn'!L18-'6. AMC 174 HCD Apprvd Proratn'!J18","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I18","v":0}]
[8,"Management Fee (do not include GP Management Fee)",null,6320,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F19","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G19","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H19","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I19","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G19-'6. AMC 174 HCD Apprvd Proratn'!L19)*'6. AMC 174 HCD Apprvd Proratn'!I19","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G19-'6. AMC 174 HCD Apprvd Proratn'!L19-'6. AMC 174 HCD Apprvd Proratn'!J19","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I19","v":0}]
[9,"Manager or Superintendent Salaries",null,6330,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F20","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G20","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H20","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I20","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G20-'6. AMC 174 HCD Apprvd Proratn'!L20)*'6. AMC 174 HCD Apprvd Proratn'!I20","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G20-'6. AMC 174 HCD Apprvd Proratn'!L20-'6. AMC 174 HCD Apprvd Proratn'!J20","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I20","v":0}]
[10,"Administrative Rent Free Unit",null,6331,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F21","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G21","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H21","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I21","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G21-'6. AMC 174 HCD Apprvd Proratn'!L21)*'6. AMC 174 HCD Apprvd Proratn'!I21","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G21-'6. AMC 174 HCD Apprvd Proratn'!L21-'6. AMC 174 HCD Apprvd Proratn'!J21","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I21","v":0}]
[11,"Legal Expense - Project",null,6340,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F22","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G22","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H22","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I22","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G22-'6. AMC 174 HCD Apprvd Proratn'!L22)*'6. AMC 174 HCD Apprvd Proratn'!I22","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G22-'6. AMC 174 HCD Apprvd Proratn'!L22-'6. AMC 174 HCD Apprvd Proratn'!J22","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I22","v":0}]
[12,"Audit Expense",null,6350,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F23","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G23","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H23","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I23","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G23-'6. AMC 174 HCD Apprvd Proratn'!L23)*'6. AMC 174 HCD Apprvd Proratn'!I23","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G23-'6. AMC 174 HCD Apprvd Proratn'!L23-'6. AMC 174 HCD Apprvd Proratn'!J23","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I23","v":0}]
[13,"Bookkeeping Fees/ Accounting Services",null,6351,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F24","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G24","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H24","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I24","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G24-'6. AMC 174 HCD Apprvd Proratn'!L24)*'6. AMC 174 HCD Apprvd Proratn'!I24","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G24-'6. AMC 174 HCD Apprvd Proratn'!L24-'6. AMC 174 HCD Apprvd Proratn'!J24","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I24","v":0}]
[14,"Bad Debts",null,6370,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F25","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G25","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H25","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I25","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G25-'6. AMC 174 HCD Apprvd Proratn'!L25)*'6. AMC 174 HCD Apprvd Proratn'!I25","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G25-'6. AMC 174 HCD Apprvd Proratn'!L25-'6. AMC 174 HCD Apprvd Proratn'!J25","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I25","v":0}]
[15,"Misc. Administrative Expenses",null,6390,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F26","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G26","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H26","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I26","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G26-'6. AMC 174 HCD Apprvd Proratn'!L26)*'6. AMC 174 HCD Apprvd Proratn'!I26","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G26-'6. AMC 174 HCD Apprvd Proratn'!L26-'6. AMC 174 HCD Apprvd Proratn'!J26","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!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":"+'3. AMC 171 Prop Cost of Opertns'!F29","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G29","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H29","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I29","v":0},{"$f":"IF($N$11=TRUE,E29,0)","v":0},{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G29-'6. AMC 174 HCD Apprvd Proratn'!L29)*'6. AMC 174 HCD Apprvd Proratn'!I29","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G29-'6. AMC 174 HCD Apprvd Proratn'!L29-'6. AMC 174 HCD Apprvd Proratn'!J29","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I29","v":0}]
[18,"Water",null,6451,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F30","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G30","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H30","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I30","v":0},{"$f":"IF($N$11=TRUE,E30,0)","v":0},{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G30-'6. AMC 174 HCD Apprvd Proratn'!L30)*'6. AMC 174 HCD Apprvd Proratn'!I30","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G30-'6. AMC 174 HCD Apprvd Proratn'!L30-'6. AMC 174 HCD Apprvd Proratn'!J30","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I30","v":0}]
[19,"Gas",null,6452,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F31","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G31","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H31","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I31","v":0},{"$f":"IF($N$11=TRUE,E31,0)","v":0},{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G31-'6. AMC 174 HCD Apprvd Proratn'!L31)*'6. AMC 174 HCD Apprvd Proratn'!I31","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G31-'6. AMC 174 HCD Apprvd Proratn'!L31-'6. AMC 174 HCD Apprvd Proratn'!J31","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I31","v":0}]
[20,"Sewer",null,6453,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F32","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G32","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H32","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I32","v":0},{"$f":"IF($N$11=TRUE,E32,0)","v":0},{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G32-'6. AMC 174 HCD Apprvd Proratn'!L32)*'6. AMC 174 HCD Apprvd Proratn'!I32","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G32-'6. AMC 174 HCD Apprvd Proratn'!L32-'6. AMC 174 HCD Apprvd Proratn'!J32","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!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":"+'3. AMC 171 Prop Cost of Opertns'!F35","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G35","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H35","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I35","v":0},{"$f":"IF($N$11=TRUE,E35,0)","v":0},{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G35-'6. AMC 174 HCD Apprvd Proratn'!L35)*'6. AMC 174 HCD Apprvd Proratn'!I35","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G35-'6. AMC 174 HCD Apprvd Proratn'!L35-'6. AMC 174 HCD Apprvd Proratn'!J35","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I35","v":0}]
[23,"Supplies",null,6515,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F36","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G36","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H36","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I36","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G36-'6. AMC 174 HCD Apprvd Proratn'!L36)*'6. AMC 174 HCD Apprvd Proratn'!I36","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G36-'6. AMC 174 HCD Apprvd Proratn'!L36-'6. AMC 174 HCD Apprvd Proratn'!J36","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I36","v":0}]
[24,"Contracts",null,6520,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F37","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G37","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H37","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I37","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G37-'6. AMC 174 HCD Apprvd Proratn'!L37)*'6. AMC 174 HCD Apprvd Proratn'!I37","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G37-'6. AMC 174 HCD Apprvd Proratn'!L37-'6. AMC 174 HCD Apprvd Proratn'!J37","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I37","v":0}]
[25,"Operating and Maintenance Rent Free Unit",null,6521,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F38","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G38","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H38","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I38","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G38-'6. AMC 174 HCD Apprvd Proratn'!L38)*'6. AMC 174 HCD Apprvd Proratn'!I38","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G38-'6. AMC 174 HCD Apprvd Proratn'!L38-'6. AMC 174 HCD Apprvd Proratn'!J38","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I38","v":0}]
[26,"Garbage and Trash Removal",null,6525,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F39","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G39","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H39","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I39","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G39-'6. AMC 174 HCD Apprvd Proratn'!L39)*'6. AMC 174 HCD Apprvd Proratn'!I39","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G39-'6. AMC 174 HCD Apprvd Proratn'!L39-'6. AMC 174 HCD Apprvd Proratn'!J39","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I39","v":0}]
[27,"Security Payroll/Contracts",null,6530,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F40","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G40","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H40","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I40","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G40-'6. AMC 174 HCD Apprvd Proratn'!L40)*'6. AMC 174 HCD Apprvd Proratn'!I40","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G40-'6. AMC 174 HCD Apprvd Proratn'!L40-'6. AMC 174 HCD Apprvd Proratn'!J40","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I40","v":0}]
[28,"Security Rent Free Unit",null,6531,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F41","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G41","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H41","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I41","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G41-'6. AMC 174 HCD Apprvd Proratn'!L41)*'6. AMC 174 HCD Apprvd Proratn'!I41","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G41-'6. AMC 174 HCD Apprvd Proratn'!L41-'6. AMC 174 HCD Apprvd Proratn'!J41","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I41","v":0}]
[29,"Heating/Cooling Repairs and Maintenance",null,6546,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F42","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G42","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H42","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I42","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G42-'6. AMC 174 HCD Apprvd Proratn'!L42)*'6. AMC 174 HCD Apprvd Proratn'!I42","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G42-'6. AMC 174 HCD Apprvd Proratn'!L42-'6. AMC 174 HCD Apprvd Proratn'!J42","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I42","v":0}]
[30,"Snow Removal",null,6548,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F43","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G43","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H43","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I43","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G43-'6. AMC 174 HCD Apprvd Proratn'!L43)*'6. AMC 174 HCD Apprvd Proratn'!I43","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G43-'6. AMC 174 HCD Apprvd Proratn'!L43-'6. AMC 174 HCD Apprvd Proratn'!J43","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I43","v":0}]
[31,"Vehicle and Maintenance Equip. Operation and Repairs",null,6570,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F44","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G44","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H44","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I44","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G44-'6. AMC 174 HCD Apprvd Proratn'!L44)*'6. AMC 174 HCD Apprvd Proratn'!I44","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G44-'6. AMC 174 HCD Apprvd Proratn'!L44-'6. AMC 174 HCD Apprvd Proratn'!J44","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I44","v":0}]
[32,"Lease Expense",null,6580,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F45","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G45","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H45","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I45","v":0},{"$f":"IF($N$11=TRUE,E45,0)","v":0},{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G45-'6. AMC 174 HCD Apprvd Proratn'!L45)*'6. AMC 174 HCD Apprvd Proratn'!I45","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G45-'6. AMC 174 HCD Apprvd Proratn'!L45-'6. AMC 174 HCD Apprvd Proratn'!J45","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I45","v":0}]
[33,"Misc. Operating & Maintenance Expenses",null,6590,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F46","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G46","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H46","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I46","v":0},{"$f":"IF($N$11=TRUE,E46,0)","v":0},{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G46-'6. AMC 174 HCD Apprvd Proratn'!L46)*'6. AMC 174 HCD Apprvd Proratn'!I46","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G46-'6. AMC 174 HCD Apprvd Proratn'!L46-'6. AMC 174 HCD Apprvd Proratn'!J46","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!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":"+'3. AMC 171 Prop Cost of Opertns'!F49","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G49","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H49","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I49","v":0},{"$f":"IF($N$11=TRUE,E49,0)","v":0},{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G49-'6. AMC 174 HCD Apprvd Proratn'!L49)*'6. AMC 174 HCD Apprvd Proratn'!I49","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G49-'6. AMC 174 HCD Apprvd Proratn'!L49-'6. AMC 174 HCD Apprvd Proratn'!J49","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I49","v":0}]
[36,"Payroll Taxes (Project's Share)",null,6711,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F50","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G50","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H50","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I50","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G50-'6. AMC 174 HCD Apprvd Proratn'!L50)*'6. AMC 174 HCD Apprvd Proratn'!I50","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G50-'6. AMC 174 HCD Apprvd Proratn'!L50-'6. AMC 174 HCD Apprvd Proratn'!J50","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I50","v":0}]
[37,"Property & Liability Insurance (Hazard)",null,6720,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F51","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G51","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H51","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I51","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G51-'6. AMC 174 HCD Apprvd Proratn'!L51)*'6. AMC 174 HCD Apprvd Proratn'!I51","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G51-'6. AMC 174 HCD Apprvd Proratn'!L51-'6. AMC 174 HCD Apprvd Proratn'!J51","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I51","v":0}]
[38,"Fidelity Bond Insurance",null,6721,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F52","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G52","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H52","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I52","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G52-'6. AMC 174 HCD Apprvd Proratn'!L52)*'6. AMC 174 HCD Apprvd Proratn'!I52","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G52-'6. AMC 174 HCD Apprvd Proratn'!L52-'6. AMC 174 HCD Apprvd Proratn'!J52","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I52","v":0}]
[39,"Worker's Compensation",null,6722,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F53","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G53","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H53","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I53","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G53-'6. AMC 174 HCD Apprvd Proratn'!L53)*'6. AMC 174 HCD Apprvd Proratn'!I53","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G53-'6. AMC 174 HCD Apprvd Proratn'!L53-'6. AMC 174 HCD Apprvd Proratn'!J53","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I53","v":0}]
[40,"Health Insurance and Other Employee Benefits",null,6723,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F54","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G54","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H54","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I54","v":0},{"$f":"IF($N$11=TRUE,E54,0)","v":0},{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G54-'6. AMC 174 HCD Apprvd Proratn'!L54)*'6. AMC 174 HCD Apprvd Proratn'!I54","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G54-'6. AMC 174 HCD Apprvd Proratn'!L54-'6. AMC 174 HCD Apprvd Proratn'!J54","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I54","v":0}]
[41,"Miscellaneous Taxes, Licenses, Permits and Insurance",null,6790,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F55","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G55","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H55","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I55","v":0},0,{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G55-'6. AMC 174 HCD Apprvd Proratn'!L55)*'6. AMC 174 HCD Apprvd Proratn'!I55","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G55-'6. AMC 174 HCD Apprvd Proratn'!L55-'6. AMC 174 HCD Apprvd Proratn'!J55","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!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":"+'3. AMC 171 Prop Cost of Opertns'!F58","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G58","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H58","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I58","v":0},{"$f":"IF($N$11=TRUE,E58,0)","v":0},{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G58-'6. AMC 174 HCD Apprvd Proratn'!L58)*'6. AMC 174 HCD Apprvd Proratn'!I58","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G58-'6. AMC 174 HCD Apprvd Proratn'!L58-'6. AMC 174 HCD Apprvd Proratn'!J58","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I58","v":0}]
[44,"On-site Service Coordinator Salaries and Benefits",null,null,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F59","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G59","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H59","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I59","v":0},{"$f":"IF($N$11=TRUE,E59,0)","v":0},{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G59-'6. AMC 174 HCD Apprvd Proratn'!L59)*'6. AMC 174 HCD Apprvd Proratn'!I59","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G59-'6. AMC 174 HCD Apprvd Proratn'!L59-'6. AMC 174 HCD Apprvd Proratn'!J59","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I59","v":0}]
[45,"On-site Other Supportive Services Staff Salaries",null,null,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F60","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G60","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H60","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I60","v":0},{"$f":"IF($N$11=TRUE,E60,0)","v":0},{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G60-'6. AMC 174 HCD Apprvd Proratn'!L60)*'6. AMC 174 HCD Apprvd Proratn'!I60","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G60-'6. AMC 174 HCD Apprvd Proratn'!L60-'6. AMC 174 HCD Apprvd Proratn'!J60","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I60","v":0}]
[46,"Supportive Services Administrative Overhead",null,null,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F61","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G61","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H61","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I61","v":0},{"$f":"IF($N$11=TRUE,E61,0)","v":0},{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G61-'6. AMC 174 HCD Apprvd Proratn'!L61)*'6. AMC 174 HCD Apprvd Proratn'!I61","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G61-'6. AMC 174 HCD Apprvd Proratn'!L61-'6. AMC 174 HCD Apprvd Proratn'!J61","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!I61","v":0}]
[47,"Other Supportive Services Costs",null,6990,{"$f":"+'3. AMC 171 Prop Cost of Opertns'!F62","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!G62","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!H62","v":0},{"$f":"+'3. AMC 171 Prop Cost of Opertns'!I62","v":0},{"$f":"IF($N$11=TRUE,E62,0)","v":0},{"$f":"('5. AMC 173 HCD Apprvd Ops Costs'!G62-'6. AMC 174 HCD Apprvd Proratn'!L62)*'6. AMC 174 HCD Apprvd Proratn'!I62","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G62-'6. AMC 174 HCD Apprvd Proratn'!L62-'6. AMC 174 HCD Apprvd Proratn'!J62","v":0},{"$f":"'3. AMC 171 Prop Cost of Opertns'!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":"7. AMC 175 HCD Apprvd Cash Flow","index":6,"n_rows":71,"n_cols":17,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,0,0,10],[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],[3,5,3,6],[4,7,4,8],[4,5,4,6],[3,7,3,8],[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],[21,1,21,2],[22,1,22,2],[23,1,23,2],[25,1,25,2],[24,1,24,2],[37,1,37,2],[34,1,34,2],[36,1,36,2],[30,1,30,2],[29,1,29,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],[47,1,47,2],[54,1,54,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[66,1,66,2],[62,1,62,2],[55,1,55,2],[49,1,49,2],[50,1,50,2],[70,1,70,2],[71,0,71,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],[67,1,67,2],[68,1,68,2],[64,1,64,2],[65,1,65,2]]}
["7.  AMC Form 175 - HCD APPROVED CASH FLOW ANALYSIS - Approved Operating Budget",null,null,null,null,null,null,null,null,null,null,{"$f":"'1. Operating Budget Instruction'!K1","v":"rev. 9/16/2022"}]
[null,null,null,"Reporting Period:",{"$f":"IF('2. AMC 170 Checklist and Cert'!D3=\"\",\"\",'2. AMC 170 Checklist and Cert'!D3)","v":""},"to",{"$f":"IF('2. AMC 170 Checklist and Cert'!F3=\"\",\"\",'2. AMC 170 Checklist and Cert'!F3)","v":""},null,null,null,"Date Prepared:",{"$f":"IF('2. AMC 170 Checklist and Cert'!D10=\"\",\"\",'2. AMC 170 Checklist and Cert'!D10)","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Date Revised:",{"$f":"IF('2. AMC 170 Checklist and Cert'!D11=\"\",\"\",'2. AMC 170 Checklist and Cert'!D11)","v":""}]
["Project Name:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D4=\"\",\"\",'2. AMC 170 Checklist and Cert'!D4)","v":""},null,null,"1. HCD Contract #:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D6=\"\",\"\",'2. AMC 170 Checklist and Cert'!D6)","v":""},{"$f":"'2. AMC 170 Checklist and Cert'!J3","v":0},null,{"$f":"CONCATENATE('2. AMC 170 Checklist and Cert'!O3,\" Units:\")","v":"Assisted Units:"},{"$f":"IF('2. AMC 170 Checklist and Cert'!L3=\"\",0,'2. AMC 170 Checklist and Cert'!L3)","v":0}]
["Project County:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D5=\"\",\"\",'2. AMC 170 Checklist and Cert'!D5)","v":""},null,null,"2. HCD Contract #:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D7=\"\",\"\",'2. AMC 170 Checklist and Cert'!D7)","v":""},{"$f":"'2. AMC 170 Checklist and Cert'!J4","v":0},null,"Total Units:",{"$f":"IF('2. AMC 170 Checklist and Cert'!L4=\"\",0,'2. AMC 170 Checklist and Cert'!L4)","v":0}]
["Approved By:",null,null,null,null,"3. HCD Contract #:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D8=\"\",\"\",'2. AMC 170 Checklist and Cert'!D8)","v":""},{"$f":"'2. AMC 170 Checklist and Cert'!J5","v":0},null,"Proration %:",{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0}]
[]
["Line #","HCD use only",null,null,{"$f":"CONCATENATE('2. AMC 170 Checklist and Cert'!$O$3,\" Units\")","v":"Assisted Units"},{"$f":"CONCATENATE('2. AMC 170 Checklist and Cert'!$O$3,\" Units\")","v":"Assisted Units"},{"$f":"CONCATENATE(\"Non-\",'2. AMC 170 Checklist and Cert'!$O$3,\" Units\")","v":"Non-Assisted Units"},{"$f":"CONCATENATE(\"Non-\",'2. AMC 170 Checklist and Cert'!$O$3,\" 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","HCD Apprvd\nBudget","Proposed\nBudget","HCD Apprvd\nBudget","Proposed\nBudget","HCD Apprvd\nBudget","Proposed\nBudget","HCD Apprvd\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":"+'4. AMC 172 Proposed CF Analysis'!E12","v":0},{"$f":"IF($N$11=TRUE,E12,0)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F12","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":"+'4. AMC 172 Proposed CF Analysis'!E13","v":0},{"$f":"IF($N$11=TRUE,E13,0)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F13","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":"+'4. AMC 172 Proposed CF Analysis'!G14","v":0},{"$f":"IF($P$11=TRUE,I14,0)","v":0},0,0]
[4,"Garage and Parking Spaces",null,5170,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E15","v":0},{"$f":"IF($N$11=TRUE,E15,0)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F15","v":0},0,{"$f":"+'4. AMC 172 Proposed CF Analysis'!G15","v":0},{"$f":"IF($P$11=TRUE,I15,0)","v":0},0,0]
[5,"Flexible Subsidy Revenue",null,5180,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E16","v":0},0,{"$f":"+'4. AMC 172 Proposed CF Analysis'!F16","v":0},{"$f":"IF($O$11=TRUE,G16,0)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G16","v":0},{"$f":"IF($P$11=TRUE,I16,0)","v":0},0,0]
[6,"Miscellaneous Rent Revenue",null,5190,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E17","v":0},{"$f":"IF($N$11=TRUE,E17,0)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F17","v":0},{"$f":"IF($O$11=TRUE,G17,0)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G17","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":"+'4. AMC 172 Proposed CF Analysis'!E20","v":0},{"$f":"IF($N$11=TRUE,E20,0)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F20","v":0},{"$f":"IF($N$11=TRUE,G20,0)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G20","v":0},{"$f":"IF($N$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":"+'4. AMC 172 Proposed CF Analysis'!E21","v":0},{"$f":"SUM(F12+F13)*F20","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F21","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":"+'4. AMC 172 Proposed CF Analysis'!G22","v":0},{"$f":"J14*J20","v":0},0,{"$f":"F22+H22+J22","v":0}]
[11,"Rental Concessions",null,5250,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E23","v":0},{"$f":"IF($N$11=TRUE,E23,0)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F23","v":0},0,{"$f":"+'4. AMC 172 Proposed CF Analysis'!G23","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":"+'4. AMC 172 Proposed CF Analysis'!E24","v":0},{"$f":"IF($N$11=TRUE,E24,0)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F24","v":0},0,{"$f":"+'4. AMC 172 Proposed CF Analysis'!G24","v":0},0,{"$f":"+E24+G24+I24","v":0},{"$f":"F24+H24+J24","v":0}]
[13,"Miscellaneous Vacancies",null,5290,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E25","v":0},{"$f":"IF($N$11=TRUE,E25,0)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F25","v":0},{"$f":"IF($O$11=TRUE,G25,0)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G25","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":"+'4. AMC 172 Proposed CF Analysis'!E28","v":0},{"$f":"(L28-J28)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F28","v":0},{"$f":"L28-F28-J28","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G28","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":"+'4. AMC 172 Proposed CF Analysis'!E30","v":0},{"$f":"(L30-J30)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F30","v":0},{"$f":"L30-F30-J30","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G30","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":"+'4. AMC 172 Proposed CF Analysis'!E31","v":0},{"$f":"(L31-J31)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F31","v":0},{"$f":"L31-F31-J31","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G31","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":"+'4. AMC 172 Proposed CF Analysis'!E34","v":0},{"$f":"(L34-J34)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F34","v":0},{"$f":"L34-F34-J34","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G34","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":"+'4. AMC 172 Proposed CF Analysis'!E35","v":0},{"$f":"(L35-J35)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F35","v":0},{"$f":"L35-F35-J35","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G35","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":"+'4. AMC 172 Proposed CF Analysis'!E36","v":0},{"$f":"(L36-J36)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F36","v":0},{"$f":"L36-F36-J36","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G36","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":"+'4. AMC 172 Proposed CF Analysis'!E39","v":0},{"$f":"'6. AMC 174 HCD Apprvd Proratn'!J64","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F39","v":0},{"$f":"'6. AMC 174 HCD Apprvd Proratn'!K64","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G39","v":0},{"$f":"'6. AMC 174 HCD Apprvd Proratn'!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('4. AMC 172 Proposed CF Analysis'!C42=0,\" \",'4. AMC 172 Proposed CF Analysis'!C42)","v":" "},6820,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E42","v":0},{"$f":"(L42-J42)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F42","v":0},{"$f":"L42-F42-J42","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G42","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('4. AMC 172 Proposed CF Analysis'!C43=0,\" \",'4. AMC 172 Proposed CF Analysis'!C43)","v":" "},6825,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E43","v":0},{"$f":"(L43-J43)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F43","v":0},0,{"$f":"+'4. AMC 172 Proposed CF Analysis'!G43","v":0},0,0,0,{"$f":"+IF('4. AMC 172 Proposed CF Analysis'!C43=0,\" \",'4. AMC 172 Proposed CF Analysis'!C43)","v":" "}]
[29,"3rd Mortgage (P&I)",{"$f":"+IF('4. AMC 172 Proposed CF Analysis'!C44=0,\" \",'4. AMC 172 Proposed CF Analysis'!C44)","v":" "},6825,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E44","v":0},{"$f":"(L44-J44)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F44","v":0},0,{"$f":"+'4. AMC 172 Proposed CF Analysis'!G44","v":0},0,0,0,{"$f":"+IF('4. AMC 172 Proposed CF Analysis'!C44=0,\" \",'4. AMC 172 Proposed CF Analysis'!C44)","v":" "}]
[30,"HCD Required Payments",null,6825,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E45","v":0},{"$f":"(L45-J45)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F45","v":0},0,{"$f":"+'4. AMC 172 Proposed CF Analysis'!G45","v":0},0,0,0]
[31,"Lease Payment",null,6890,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E46","v":0},{"$f":"(L46-J46)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F46","v":0},0,{"$f":"+'4. AMC 172 Proposed CF Analysis'!G46","v":0},0,0,0]
[32,"Miscellaneous Financial Expenses",null,6890,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E47","v":0},{"$f":"(L47-J47)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F47","v":0},0,{"$f":"+'4. AMC 172 Proposed CF Analysis'!G47","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":"+'4. AMC 172 Proposed CF Analysis'!E50","v":0},{"$f":"(L50-J50)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F50","v":0},{"$f":"L50-F50-J50","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G50","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":"+'4. AMC 172 Proposed CF Analysis'!E51","v":0},{"$f":"(L51-J51)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F51","v":0},{"$f":"L51-F51-J51","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G51","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":"+'4. AMC 172 Proposed CF Analysis'!E52","v":0},{"$f":"(L52-J52)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F52","v":0},{"$f":"L52-F52-J52","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G52","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('4. AMC 172 Proposed CF Analysis'!C53=0,\" \",'4. AMC 172 Proposed CF Analysis'!C53)","v":" "},1330,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E53","v":0},{"$f":"(L53-J53)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F53","v":0},{"$f":"L53-F53-J53","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G53","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('4. AMC 172 Proposed CF Analysis'!C53=0,\" \",'4. AMC 172 Proposed CF Analysis'!C53)","v":" "}]
[38,"Other Reserves",{"$f":"+IF('4. AMC 172 Proposed CF Analysis'!C54=0,\" \",'4. AMC 172 Proposed CF Analysis'!C54)","v":" "},1330,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E54","v":0},{"$f":"(L54-J54)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F54","v":0},{"$f":"L54-F54-J54","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G54","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('4. AMC 172 Proposed CF Analysis'!C54=0,\" \",'4. AMC 172 Proposed CF Analysis'!C54)","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":"+'4. AMC 172 Proposed CF Analysis'!E58","v":0},{"$f":"(L58-J58)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F58","v":0},{"$f":"L58-F58-J58","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G58","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('4. AMC 172 Proposed CF Analysis'!C59=0,\" \",'4. AMC 172 Proposed CF Analysis'!C59)","v":" "},null,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E59","v":0},{"$f":"(L59-J59)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F59","v":0},{"$f":"L59-F59-J59","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G59","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('4. AMC 172 Proposed CF Analysis'!C60=0,\" \",'4. AMC 172 Proposed CF Analysis'!C60)","v":" "},null,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E60","v":0},{"$f":"(L60-J60)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F60","v":0},{"$f":"L60-F60-J60","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G60","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('4. AMC 172 Proposed CF Analysis'!C61=0,\" \",'4. AMC 172 Proposed CF Analysis'!C61)","v":" "},null,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E61","v":0},{"$f":"(L61-J61)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F61","v":0},{"$f":"L61-F61-J61","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G61","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('4. AMC 172 Proposed CF Analysis'!C61=0,\" \",'4. AMC 172 Proposed CF Analysis'!C61)","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":"+'4. AMC 172 Proposed CF Analysis'!E64","v":0},{"$f":"(L64-J64)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F64","v":0},{"$f":"L64-F64-J64","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!G64","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 Mgmt Fee (CHRP-R/SUHRP & HOME pre-UMR)",null,7190,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E65","v":0},{"$f":"(L65-J65)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F65","v":0},0,{"$f":"+'4. AMC 172 Proposed CF Analysis'!G65","v":0},0,0,0]
[48,"Asset Mgmt Fee/Prtrshp Costs (MHP/HOME under UMR)",null,7190,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E66","v":0},{"$f":"(L66-J66)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F66","v":0},0,{"$f":"+'4. AMC 172 Proposed CF Analysis'!G66","v":0},0,0,0]
[49,"Borrower Distributions",null,null,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E67","v":0},{"$f":"(L67-J67)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F67","v":0},0,{"$f":"+'4. AMC 172 Proposed CF Analysis'!G67","v":0},0,0,0]
[50,"Residual Receipt Loan Payments",null,null,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E68","v":0},{"$f":"(L68-J68)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F68","v":0},0,{"$f":"+'4. AMC 172 Proposed CF Analysis'!G68","v":0},0,0,0]
[51,"HCD Interest Payments",null,null,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E69","v":0},{"$f":"(L69-J69)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F69","v":0},0,{"$f":"+'4. AMC 172 Proposed CF Analysis'!G69","v":0},0,0,0]
[52,"Other (specify)",{"$f":"+IF('4. AMC 172 Proposed CF Analysis'!C70=0,\" \",'4. AMC 172 Proposed CF Analysis'!C70)","v":" "},null,{"$f":"+'4. AMC 172 Proposed CF Analysis'!E70","v":0},{"$f":"(L70-J70)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"+'4. AMC 172 Proposed CF Analysis'!F70","v":0},0,{"$f":"+'4. AMC 172 Proposed CF Analysis'!G70","v":0},0,0,0,{"$f":"+IF('4. AMC 172 Proposed CF Analysis'!C70=0,\" \",'4. AMC 172 Proposed CF Analysis'!C70)","v":" "}]
[53,"Total Use of Cash Flow",null,null,{"$f":"SUM(E64:E70)","v":0},0,0,0,0,0,0,0]

{"sheet":"8. AMC 180 Actual Opertng Costs","index":7,"n_rows":124,"n_cols":18,"rows_kept":124,"cut":false,"hidden":false,"merged":[[5,13,5,14],[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],[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],[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],[80,6,80,7],[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],[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],[108,1,108,7],[114,6,114,7],[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],[4,7,4,8],[5,7,5,8],[56,15,62,15],[5,5,5,6],[4,5,4,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],[38,1,38,2],[39,1,39,2],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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]]}
["8.  AMC Form 180 - ACTUAL COST OF OPERATIONS - Annual Report (may not be required, see Worksheet 1 for reporting instuctions)"]
[null,{"$f":"'1. Operating Budget Instruction'!K1","v":"rev. 9/16/2022"},null,null,null,null,null,"Reporting Period:",{"$f":"IF('2. AMC 170 Checklist and Cert'!D3=\"\",\"\",'2. AMC 170 Checklist and Cert'!D3)","v":""},"to",{"$f":"IF('2. AMC 170 Checklist and Cert'!F3=\"\",\"\",'2. AMC 170 Checklist and Cert'!F3)","v":""}]
[]
["Project Name:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D4=\"\",\"\",'2. AMC 170 Checklist and Cert'!D4)","v":""},null,null,"Date Prepared:",null,null,null,"1. HCD Contract #:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D6=\"\",\"\",'2. AMC 170 Checklist and Cert'!D6)","v":""},null,{"$f":"CONCATENATE('2. AMC 170 Checklist and Cert'!O3,\" Units:\")","v":"Assisted Units:"},null,{"$f":"IF('2. AMC 170 Checklist and Cert'!L3=\"\",0,'2. AMC 170 Checklist and Cert'!L3)","v":0}]
["Project County:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D5=\"\",\"\",'2. AMC 170 Checklist and Cert'!D5)","v":""},null,null,"Date Revised:",null,null,null,"2. HCD Contract #:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D7=\"\",\"\",'2. AMC 170 Checklist and Cert'!D7)","v":""},null,"Total Units:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!L4=\"\",0,'2. AMC 170 Checklist and Cert'!L4)","v":0}]
["Prepared by:",null,null,null,null,"Phone #:",null,null,null,"3. HCD Contract #:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D8=\"\",\"\",'2. AMC 170 Checklist and Cert'!D8)","v":""},null,"Proration %:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0}]
[]
["Line #","Account Name",null,"Acct.\nCode",{"$f":"CONCATENATE('2. AMC 170 Checklist and Cert'!$O$3,\" Units\")","v":"Assisted Units"},{"$f":"CONCATENATE('2. AMC 170 Checklist and Cert'!$O$3,\" Units\")","v":"Assisted Units"},{"$f":"CONCATENATE(\"Non-\",'2. AMC 170 Checklist and Cert'!$O$3,\" Units\")","v":"Non-Assisted Units"},{"$f":"CONCATENATE(\"Non-\",'2. AMC 170 Checklist and Cert'!$O$3,\" Units\")","v":"Non-Assisted Units"},"Commercial",null,"Project Total Costs",null,null,"Budget vs HCD",null,"HCD Rep notes (HCD use only)"]
[null,null,null,null,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)","(J)","(K)"]
[null,null,null,null,"Sponsor\nActuals","HCD Apprvd\nActuals","Sponsor\nActuals","HCD Apprvd\nActuals","Sponsor\nActuals","HCD Apprvd\nActuals","HCD Apprvd\nBudget","Sponsor\nActuals","HCD Apprvd\nActuals","Variance\nAmount","Var.\n%",null,false,false]
[null,"Administrative Expenses:"]
[1,"Conventions and Meetings",null,6203,{"$f":"(L12-I12)*'6. AMC 174 HCD Apprvd Proratn'!I12","v":0},{"$f":"(M12-J12)*'6. AMC 174 HCD Apprvd Proratn'!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":"'5. AMC 173 HCD Apprvd Ops Costs'!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)*'6. AMC 174 HCD Apprvd Proratn'!I13","v":0},{"$f":"(M13-J13)*'6. AMC 174 HCD Apprvd Proratn'!I13","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G13","v":0},0,0,0,0]
[3,"Advertising and Marketing",null,6210,{"$f":"(L14-I14)*'6. AMC 174 HCD Apprvd Proratn'!I14","v":0},{"$f":"(M14-J14)*'6. AMC 174 HCD Apprvd Proratn'!I14","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G14","v":0},0,0,0,0]
[4,"Other Renting Expenses",null,6250,{"$f":"(L15-I15)*'6. AMC 174 HCD Apprvd Proratn'!I15","v":0},{"$f":"(M15-J15)*'6. AMC 174 HCD Apprvd Proratn'!I15","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G15","v":0},0,0,0,0]
[5,"Office Salaries",null,6310,{"$f":"(L16-I16)*'6. AMC 174 HCD Apprvd Proratn'!I16","v":0},{"$f":"(M16-J16)*'6. AMC 174 HCD Apprvd Proratn'!I16","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G16","v":0},0,0,0,0]
[6,"Office Expenses",null,6311,{"$f":"(L17-I17)*'6. AMC 174 HCD Apprvd Proratn'!I17","v":0},{"$f":"(M17-J17)*'6. AMC 174 HCD Apprvd Proratn'!I17","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G17","v":0},0,0,0,0]
[7,"Office or Model Apartment Rent",null,6312,{"$f":"(L18-I18)*'6. AMC 174 HCD Apprvd Proratn'!I18","v":0},{"$f":"(M18-J18)*'6. AMC 174 HCD Apprvd Proratn'!I18","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G18","v":0},0,0,0,0]
[8,"Management Fee-don't inc GP Mngmt Fee",null,6320,{"$f":"(L19-I19)*'6. AMC 174 HCD Apprvd Proratn'!I19","v":0},{"$f":"(M19-J19)*'6. AMC 174 HCD Apprvd Proratn'!I19","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G19","v":0},0,0,0,0]
[9,"Manager or Superintendent Salaries",null,6330,{"$f":"(L20-I20)*'6. AMC 174 HCD Apprvd Proratn'!I20","v":0},{"$f":"(M20-J20)*'6. AMC 174 HCD Apprvd Proratn'!I20","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G20","v":0},0,0,0,0]
[10,"Administrative Rent Free Unit",null,6331,{"$f":"(L21-I21)*'6. AMC 174 HCD Apprvd Proratn'!I21","v":0},{"$f":"(M21-J21)*'6. AMC 174 HCD Apprvd Proratn'!I21","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G21","v":0},0,0,0,0]
[11,"Legal Expense - Project",null,6340,{"$f":"(L22-I22)*'6. AMC 174 HCD Apprvd Proratn'!I22","v":0},{"$f":"(M22-J22)*'6. AMC 174 HCD Apprvd Proratn'!I22","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G22","v":0},0,0,0,0]
[12,"Audit Expense",null,6350,{"$f":"(L23-I23)*'6. AMC 174 HCD Apprvd Proratn'!I23","v":0},{"$f":"(M23-J23)*'6. AMC 174 HCD Apprvd Proratn'!I23","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G23","v":0},0,0,0,0]
[13,"Bookkeeping Fees/ Accounting Services",null,6351,{"$f":"(L24-I24)*'6. AMC 174 HCD Apprvd Proratn'!I24","v":0},{"$f":"(M24-J24)*'6. AMC 174 HCD Apprvd Proratn'!I24","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G24","v":0},0,0,0,0]
[14,"Bad Debts",null,6370,{"$f":"(L25-I25)*'6. AMC 174 HCD Apprvd Proratn'!I25","v":0},{"$f":"(M25-J25)*'6. AMC 174 HCD Apprvd Proratn'!I25","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G25","v":0},0,0,0,0]
[15,"Misc. Administrative Expenses",null,6390,{"$f":"(L26-I26)*'6. AMC 174 HCD Apprvd Proratn'!I26","v":0},{"$f":"(M26-J26)*'6. AMC 174 HCD Apprvd Proratn'!I26","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G26","v":0},{"$f":"G86","v":0},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)*'6. AMC 174 HCD Apprvd Proratn'!I29","v":0},{"$f":"(M29-J29)*'6. AMC 174 HCD Apprvd Proratn'!I29","v":0},{"$f":"L29-E29-I29","v":0},0,0,{"$f":"IF($Q$10=TRUE,I29,0)","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!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)*'6. AMC 174 HCD Apprvd Proratn'!I30","v":0},{"$f":"(M30-J30)*'6. AMC 174 HCD Apprvd Proratn'!I30","v":0},0,0,0,{"$f":"IF($Q$10=TRUE,I30,0)","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!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)*'6. AMC 174 HCD Apprvd Proratn'!I31","v":0},{"$f":"(M31-J31)*'6. AMC 174 HCD Apprvd Proratn'!I31","v":0},0,0,0,{"$f":"IF($Q$10=TRUE,I31,0)","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!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)*'6. AMC 174 HCD Apprvd Proratn'!I32","v":0},{"$f":"(M32-J32)*'6. AMC 174 HCD Apprvd Proratn'!I32","v":0},0,0,0,{"$f":"IF($Q$10=TRUE,I32,0)","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!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)*'6. AMC 174 HCD Apprvd Proratn'!I35","v":0},{"$f":"(M35-J35)*'6. AMC 174 HCD Apprvd Proratn'!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":"'5. AMC 173 HCD Apprvd Ops Costs'!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)*'6. AMC 174 HCD Apprvd Proratn'!I36","v":0},{"$f":"(M36-J36)*'6. AMC 174 HCD Apprvd Proratn'!I36","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G36","v":0},0,0,0,0]
[24,"Contracts",null,6520,{"$f":"(L37-I37)*'6. AMC 174 HCD Apprvd Proratn'!I37","v":0},{"$f":"(M37-J37)*'6. AMC 174 HCD Apprvd Proratn'!I37","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G37","v":0},0,0,0,0]
[25,"Operating & Maintenance Rent Free Unit",null,6521,{"$f":"(L38-I38)*'6. AMC 174 HCD Apprvd Proratn'!I38","v":0},{"$f":"(M38-J38)*'6. AMC 174 HCD Apprvd Proratn'!I38","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G38","v":0},0,0,0,0]
[26,"Garbage and Trash Removal",null,6525,{"$f":"(L39-I39)*'6. AMC 174 HCD Apprvd Proratn'!I39","v":0},{"$f":"(M39-J39)*'6. AMC 174 HCD Apprvd Proratn'!I39","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G39","v":0},0,0,0,0]
[27,"Security Payroll/Contracts",null,6530,{"$f":"(L40-I40)*'6. AMC 174 HCD Apprvd Proratn'!I40","v":0},{"$f":"(M40-J40)*'6. AMC 174 HCD Apprvd Proratn'!I40","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G40","v":0},0,0,0,0]
[28,"Security Rent Free Unit",null,6531,{"$f":"(L41-I41)*'6. AMC 174 HCD Apprvd Proratn'!I41","v":0},{"$f":"(M41-J41)*'6. AMC 174 HCD Apprvd Proratn'!I41","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G41","v":0},0,0,0,0]
[29,"Heating/Cooling Repairs and Maintenance",null,6546,{"$f":"(L42-I42)*'6. AMC 174 HCD Apprvd Proratn'!I42","v":0},{"$f":"(M42-J42)*'6. AMC 174 HCD Apprvd Proratn'!I42","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G42","v":0},0,0,0,0]
[30,"Snow Removal",null,6548,{"$f":"(L43-I43)*'6. AMC 174 HCD Apprvd Proratn'!I43","v":0},{"$f":"(M43-J43)*'6. AMC 174 HCD Apprvd Proratn'!I43","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G43","v":0},0,0,0,0]
[31,"Vehicle & Maint Equip Operation/Repairs",null,6570,{"$f":"(L44-I44)*'6. AMC 174 HCD Apprvd Proratn'!I44","v":0},{"$f":"(M44-J44)*'6. AMC 174 HCD Apprvd Proratn'!I44","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G44","v":0},0,0,0,0]
[32,"Lease Expense",null,6580,{"$f":"(L45-I45)*'6. AMC 174 HCD Apprvd Proratn'!I45","v":0},{"$f":"(M45-J45)*'6. AMC 174 HCD Apprvd Proratn'!I45","v":0},{"$f":"L45-E45-I45","v":0},{"$f":"M45-F45-J45","v":0},0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G45","v":0},0,0,{"$f":"+K45-M45","v":0},0]
[33,"Misc. Operating & Maintenance Exp.",null,6590,{"$f":"(L46-I46)*'6. AMC 174 HCD Apprvd Proratn'!I46","v":0},{"$f":"(M46-J46)*'6. AMC 174 HCD Apprvd Proratn'!I46","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G46","v":0},{"$f":"G107","v":0},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)*'6. AMC 174 HCD Apprvd Proratn'!I49","v":0},{"$f":"(M49-J49)*'6. AMC 174 HCD Apprvd Proratn'!I49","v":0},{"$f":"L49-E49-I49","v":0},0,0,{"$f":"IF($Q$10=TRUE,I49,0)","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!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)*'6. AMC 174 HCD Apprvd Proratn'!I50","v":0},{"$f":"(M50-J50)*'6. AMC 174 HCD Apprvd Proratn'!I50","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G50","v":0},0,0,0,0]
[37,"Property & Liability Insurance (Hazard)",null,6720,{"$f":"(L51-I51)*'6. AMC 174 HCD Apprvd Proratn'!I51","v":0},{"$f":"(M51-J51)*'6. AMC 174 HCD Apprvd Proratn'!I51","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G51","v":0},0,0,0,0]
[38,"Fidelity Bond Insurance",null,6721,{"$f":"(L52-I52)*'6. AMC 174 HCD Apprvd Proratn'!I52","v":0},{"$f":"(M52-J52)*'6. AMC 174 HCD Apprvd Proratn'!I52","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G52","v":0},0,0,0,0]
[39,"Worker's Compensation",null,6722,{"$f":"(L53-I53)*'6. AMC 174 HCD Apprvd Proratn'!I53","v":0},{"$f":"(M53-J53)*'6. AMC 174 HCD Apprvd Proratn'!I53","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G53","v":0},0,0,0,0]
[40,"Health Ins. & Other Employee Benefits",null,6723,{"$f":"(L54-I54)*'6. AMC 174 HCD Apprvd Proratn'!I54","v":0},{"$f":"(M54-J54)*'6. AMC 174 HCD Apprvd Proratn'!I54","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G54","v":0},0,0,0,0]
[41,"Misc. Taxes, Licenses, Permits and Ins.",null,6790,{"$f":"(L55-I55)*'6. AMC 174 HCD Apprvd Proratn'!I55","v":0},{"$f":"(M55-J55)*'6. AMC 174 HCD Apprvd Proratn'!I55","v":0},0,0,0,0,{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G55","v":0},{"$f":"G115","v":0},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)*'6. AMC 174 HCD Apprvd Proratn'!I55","v":0},{"$f":"(M58-J58)*'6. AMC 174 HCD Apprvd Proratn'!I55","v":0},{"$f":"L58-E58-I58","v":0},0,0,{"$f":"IF($Q$10=TRUE,I58,0)","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!G58","v":0},0,null,{"$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)*'6. AMC 174 HCD Apprvd Proratn'!I62","v":0},{"$f":"(M59-J59)*'6. AMC 174 HCD Apprvd Proratn'!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":"'5. AMC 173 HCD Apprvd Ops Costs'!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)*'6. AMC 174 HCD Apprvd Proratn'!I56","v":0},{"$f":"(M60-J60)*'6. AMC 174 HCD Apprvd Proratn'!I56","v":0},0,0,0,{"$f":"IF($Q$10=TRUE,I60,0)","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!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)*'6. AMC 174 HCD Apprvd Proratn'!I57","v":0},{"$f":"(M61-J61)*'6. AMC 174 HCD Apprvd Proratn'!I57","v":0},0,0,0,{"$f":"IF($Q$10=TRUE,I61,0)","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!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)*'6. AMC 174 HCD Apprvd Proratn'!I62","v":0},{"$f":"(M62-J62)*'6. AMC 174 HCD Apprvd Proratn'!I62","v":0},0,0,0,{"$f":"IF($Q$10=TRUE,I62,0)","v":0},{"$f":"'5. AMC 173 HCD Apprvd Ops Costs'!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,"HCD Apprvd Actuals",null,"HCD Itemization of HCD 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,"HCD Apprvd 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,"HCD Apprvd 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,"HCD Apprvd 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"]

{"sheet":"9. AMC 181 Actual CF Analysis","index":8,"n_rows":108,"n_cols":19,"rows_kept":108,"cut":false,"hidden":false,"merged":[[83,6,83,7],[83,8,83,9],[83,10,83,14],[81,1,81,5],[81,6,81,7],[81,8,81,9],[81,10,81,14],[82,1,82,5],[82,6,82,7],[88,1,88,5],[85,6,85,7],[71,0,72,0],[71,1,71,5],[78,6,78,7],[73,1,73,5],[74,1,74,5],[72,1,72,7],[75,6,75,7],[76,6,76,7],[77,6,77,7],[75,1,75,5],[76,1,76,5],[77,1,77,5],[71,6,71,7],[73,6,73,7],[74,6,74,7],[84,1,84,5],[84,6,84,7],[86,1,86,7],[79,1,79,7],[80,6,80,7],[80,1,80,5],[83,1,83,5],[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],[64,1,64,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],[33,1,33,2],[26,1,26,2],[22,1,22,2],[25,1,25,2],[24,1,24,2],[93,1,93,7],[65,1,65,2],[63,1,63,2],[38,1,38,2],[56,1,56,2],[53,1,53,2],[69,1,69,2],[61,1,61,2],[48,1,48,2],[49,1,49,2],[62,1,62,2],[54,1,54,2],[92,6,92,7],[89,6,89,7],[90,6,90,7],[91,6,91,7],[89,1,89,5],[90,1,90,5],[91,1,91,5],[87,6,87,7],[88,6,88,7],[87,1,87,5],[66,1,66,2],[67,1,67,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],[96,6,96,7],[94,8,94,9],[95,8,95,9],[104,8,104,9],[99,6,99,7],[100,6,100,7],[101,6,101,7],[100,10,100,14],[102,1,102,7],[98,6,98,7],[96,1,96,5],[97,1,97,5],[98,1,98,5],[94,6,94,7],[95,6,95,7],[94,1,94,5],[95,1,95,5],[97,6,97,7],[99,1,99,5],[100,1,100,5],[101,8,101,9],[97,8,97,9],[98,8,98,9],[97,10,97,14],[105,1,105,5],[106,1,106,5],[107,1,107,5],[106,6,106,7],[107,6,107,7],[105,6,105,7],[107,8,107,9],[103,6,103,7],[104,6,104,7],[104,1,104,5],[103,1,103,5],[103,8,103,9],[71,10,71,14],[77,10,77,14],[78,10,78,14],[71,8,71,9],[73,8,73,9],[74,8,74,9],[75,8,75,9],[76,8,76,9],[77,8,77,9],[72,8,72,14],[89,8,89,9],[90,8,90,9],[91,8,91,9],[78,8,78,9],[87,8,87,9],[88,8,88,9],[92,8,92,9],[79,8,79,14],[96,8,96,9],[95,10,95,14],[96,10,96,14],[86,8,86,14],[93,8,93,14],[84,8,84,9],[84,10,84,14],[85,8,85,9],[85,10,85,14],[80,8,80,9],[80,10,80,14],[82,8,82,9],[82,10,82,14],[107,10,107,14],[73,10,73,14],[74,10,74,14],[75,10,75,14],[76,10,76,14],[87,10,87,14],[102,8,102,14],[101,10,101,14],[103,10,103,14],[104,10,104,14],[88,10,88,14],[89,10,89,14],[90,10,90,14],[94,10,94,14],[98,10,98,14],[99,10,99,14],[105,10,105,14],[99,8,99,9],[100,8,100,9],[106,10,106,14],[91,10,91,14],[92,10,92,14],[106,8,106,9],[105,8,105,9]]}
["9.  AMC Form 181 - ACTUAL CASH FLOW ANALYSIS - Annual Report (may not be required, see Worksheet 1 for reporting instuctions)"]
[null,{"$f":"'1. Operating Budget Instruction'!K1","v":"rev. 9/16/2022"},null,null,null,null,"  Reporting Period:",{"$f":"IF('2. AMC 170 Checklist and Cert'!D3=\"\",\"\",'2. AMC 170 Checklist and Cert'!D3)","v":""},"to",{"$f":"IF('2. AMC 170 Checklist and Cert'!F3=\"\",\"\",'2. AMC 170 Checklist and Cert'!F3)","v":""}]
[null,null,null,null,"Prepared by:",null,{"$f":"IF('8. AMC 180 Actual Opertng Costs'!C6=\"\",\"\",'8. AMC 180 Actual Opertng Costs'!C6)","v":""},null,null,"1. HCD Contract #:",{"$f":"IF('2. AMC 170 Checklist and Cert'!D6=\"\",\"\",'2. AMC 170 Checklist and Cert'!D6)","v":""},{"$f":"'2. AMC 170 Checklist and Cert'!J3","v":0},null,{"$f":"CONCATENATE('2. AMC 170 Checklist and Cert'!O3,\" Units:\")","v":"Assisted Units:"},{"$f":"IF('2. AMC 170 Checklist and Cert'!L3=\"\",0,'2. AMC 170 Checklist and Cert'!L3)","v":0}]
["Project Name:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D4=\"\",\"\",'2. AMC 170 Checklist and Cert'!D4)","v":""},null,"Date Prepared:",null,{"$f":"IF('8. AMC 180 Actual Opertng Costs'!H4=\"\",\"\",'8. AMC 180 Actual Opertng Costs'!H4)","v":""},null,null,"2. HCD Contract #:",{"$f":"IF('2. AMC 170 Checklist and Cert'!D7=\"\",\"\",'2. AMC 170 Checklist and Cert'!D7)","v":""},{"$f":"'2. AMC 170 Checklist and Cert'!J4","v":0},null,"Total Units:",{"$f":"IF('2. AMC 170 Checklist and Cert'!L4=\"\",0,'2. AMC 170 Checklist and Cert'!L4)","v":0}]
["Project County:",null,{"$f":"IF('2. AMC 170 Checklist and Cert'!D5=\"\",\"\",'2. AMC 170 Checklist and Cert'!D5)","v":""},null,"Date Revised:",null,{"$f":"IF('8. AMC 180 Actual Opertng Costs'!H5=\"\",\"\",'8. AMC 180 Actual Opertng Costs'!H5)","v":""},null,null,"3. HCD Contract #:",{"$f":"IF('2. AMC 170 Checklist and Cert'!D8=\"\",\"\",'2. AMC 170 Checklist and Cert'!D8)","v":""},{"$f":"'2. AMC 170 Checklist and Cert'!J5","v":0},null,"Proration %:",{"$f":"IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0}]
[]
["Line #","Account Name",null,"Acct.\nCode",{"$f":"CONCATENATE('2. AMC 170 Checklist and Cert'!O3,\" Units\")","v":"Assisted Units"},null,{"$f":"CONCATENATE(\"Non-\",'2. AMC 170 Checklist and Cert'!$O$3,\" Units\")","v":"Non-Assisted Units"},null,"Commercial",null,"Project Totals",null,null,"(J)\nBudget vs.\nHCD Apprvd\nActuals","HCD Rep notes (HCD use only)"]
[null,null,null,null,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)"]
[null,null,null,null,"Sponsor\nActuals","HCD Apprvd\nActuals","Sponsor\nActuals","HCD Apprvd\nActuals","Sponsor\nActuals","HCD Apprvd\nActuals","HCD Apprvd\nBudget","Sponsor\nActuals","HCD Apprvd\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,0,{"$f":"IF($P$10=TRUE,E11,0)","v":0},0,{"$f":"IF($Q$10=TRUE,G11,0)","v":0},null,null,{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!L12","v":0},{"$f":"E11+G11+I11","v":0},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":"'7. AMC 175 HCD Apprvd Cash Flow'!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":"'7. AMC 175 HCD Apprvd Cash Flow'!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":"'7. AMC 175 HCD Apprvd Cash Flow'!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":"'7. AMC 175 HCD Apprvd Cash Flow'!L16","v":0},0,0,0]
[6,"Miscellaneous Rent Revenue",null,5190,{"$f":"(L16-I16)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M16-J16)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","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":"'7. AMC 175 HCD Apprvd Cash Flow'!L17","v":0},{"$f":"G78","v":0},{"$f":"I78","v":0},0,{"$f":"IF(N16>999,\"Go to Worksheet 10; provide explanation of Miscellaneous Rent Revenue\",\"\")","v":""}]
[7,"Total Rent Revenue",null,"5100T",{"$f":"SUM(E11:E16)","v":0},0,0,0,0,0,0,0,0,0]
[null,"Vacancies:"]
[8,"Vacancy %",null,null,{"$f":"IF(E11=0,0,E20/(E11+E12))","v":0},0,0,0,0,0,{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!L20","v":0},{"$f":"IF(L11=0,0,L20/(L11+L12))","v":0},{"$f":"IF(M11=0,0,M20/(M11+M12))","v":0}]
[9,"Apartments",null,5220,0,{"$f":"IF($P$10=TRUE,E20,0)","v":0},0,{"$f":"IF($Q$10=TRUE,G20,0)","v":0},null,null,{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!L21","v":0},{"$f":"E20+G20+I20","v":0},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":"'7. AMC 175 HCD Apprvd Cash Flow'!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":"'7. AMC 175 HCD Apprvd Cash Flow'!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":"'7. AMC 175 HCD Apprvd Cash Flow'!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":"'7. AMC 175 HCD Apprvd Cash Flow'!L25","v":0},0,0,{"$f":"K24-M24","v":0}]
[14,"Total Vacancies",null,"5200T",{"$f":"SUM(E20:E24)","v":0},0,0,0,0,0,{"$f":"SUM(K20:K24)","v":0},{"$f":"SUM(L20:L24)","v":0},{"$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":0},0,0,0,0,0,{"$f":"K17-K25","v":0},{"$f":"L17-L25","v":0},{"$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. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M27-J27)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","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":"'7. AMC 175 HCD Apprvd Cash Flow'!L28","v":0},{"$f":"G85","v":0},{"$f":"I85","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. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M29-J29)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","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":"'7. AMC 175 HCD Apprvd Cash Flow'!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. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M30-J30)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","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":"'7. AMC 175 HCD Apprvd Cash Flow'!L31","v":0},{"$f":"G92","v":0},{"$f":"I92","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. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M33-J33)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"L33-E33-I33","v":0},0,0,{"$f":"IF($R$10=TRUE,I33,0)","v":0},{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!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. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M34-J34)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,{"$f":"IF($R$10=TRUE,I34,0)","v":0},{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!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. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M35-J35)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,{"$f":"IF($R$10=TRUE,I35,0)","v":0},{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!L36","v":0},{"$f":"G101","v":0},{"$f":"I101","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":0},0,0,0,0,0,0,0,0,0]
[25,"Total Cost of Operations before Depreciation",null,"6000T",{"$f":"'8. AMC 180 Actual Opertng Costs'!E64","v":0},{"$f":"'8. AMC 180 Actual Opertng Costs'!F64","v":0},{"$f":"'8. AMC 180 Actual Opertng Costs'!G64","v":0},{"$f":"'8. AMC 180 Actual Opertng Costs'!H64","v":0},{"$f":"'8. AMC 180 Actual Opertng Costs'!I64","v":0},{"$f":"'8. AMC 180 Actual Opertng Costs'!J64","v":0},{"$f":"'8. AMC 180 Actual Opertng Costs'!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":0},0,0,0,0,0,{"$f":"K37-K38","v":0},{"$f":"L37-L38","v":0},{"$f":"M37-M38","v":0},{"$f":"N37-N38","v":0}]
[null,"Financial Expenses including mandatory debt service:"]
[27,"1st Mortgage (P&I)",{"$f":"+IF('7. AMC 175 HCD Apprvd Cash Flow'!C42=0,\" \",'7. AMC 175 HCD Apprvd Cash Flow'!C42)","v":" "},6820,{"$f":"(L41-I41)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M41-J41)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"L41-E41-I41","v":0},0,0,{"$f":"IF($R$10=TRUE,I41,0)","v":0},{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!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('7. AMC 175 HCD Apprvd Cash Flow'!C43=0,\" \",'7. AMC 175 HCD Apprvd Cash Flow'!C43)","v":" "},6825,{"$f":"(L42-I42)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M42-J42)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0,{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!L43","v":0},0,{"$f":"IF($S$10=TRUE,L42,0)","v":0},0]
[29,"3rd Mortgage (P&I)",{"$f":"+IF('7. AMC 175 HCD Apprvd Cash Flow'!C44=0,\" \",'7. AMC 175 HCD Apprvd Cash Flow'!C44)","v":" "},6825,{"$f":"(L43-I43)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M43-J43)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0,{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!L44","v":0},0,{"$f":"IF($S$10=TRUE,L43,0)","v":0},0]
[30,"HCD Required Payments",null,6825,{"$f":"(L44-I44)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M44-J44)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0,{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!L45","v":0},0,{"$f":"IF($S$10=TRUE,L44,0)","v":0},0]
[31,"Lease Payment",null,6890,{"$f":"(L45-I45)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M45-J45)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0,{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!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. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M46-J46)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0,{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!L47","v":0},{"$f":"G108","v":0},{"$f":"I108","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. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M49-J49)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"L49-E49-I49","v":0},0,0,{"$f":"IF($R$10=TRUE,I49,0)","v":0},{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!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. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M50-J50)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,{"$f":"IF($R$10=TRUE,I50,0)","v":0},{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!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. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M51-J51)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,{"$f":"IF($R$10=TRUE,I51,0)","v":0},{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!L52","v":0},0,{"$f":"IF($S$10=TRUE,L51,0)","v":0},{"$f":"K51-M51","v":0}]
[37,"Other Reserves",{"$f":"+IF('7. AMC 175 HCD Apprvd Cash Flow'!C53=0,\" \",'7. AMC 175 HCD Apprvd Cash Flow'!C53)","v":" "},1330,{"$f":"(L52-I52)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M52-J52)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,{"$f":"IF($R$10=TRUE,I52,0)","v":0},{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!L53","v":0},0,{"$f":"IF($S$10=TRUE,L52,0)","v":0},{"$f":"K52-M52","v":0}]
[38,"Other Reserves",{"$f":"+IF('7. AMC 175 HCD Apprvd Cash Flow'!C54=0,\" \",'7. AMC 175 HCD Apprvd Cash Flow'!C54)","v":" "},1330,{"$f":"(L53-I53)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M53-J53)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,{"$f":"IF($R$10=TRUE,I53,0)","v":0},{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!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":0},0,0,0,0,0,0,0,0,0]
[null,"Additions to Cash Flow:"]
[41,"Borrower Contribution",null,null,{"$f":"(L57-I57)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M57-J57)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"L57-E57-I57","v":0},0,0,{"$f":"IF($R$10=TRUE,I57,0)","v":0},{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!L58","v":0},0,{"$f":"IF($S$10=TRUE,L57,0)","v":0},{"$f":"K57-M57","v":0}]
[42,"Other (specify)",{"$f":"+IF('7. AMC 175 HCD Apprvd Cash Flow'!C59=0,\" \",'7. AMC 175 HCD Apprvd Cash Flow'!C59)","v":" "},null,{"$f":"(L58-I58)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M58-J58)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,{"$f":"IF($R$10=TRUE,I58,0)","v":0},{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!L59","v":0},0,{"$f":"IF($S$10=TRUE,L58,0)","v":0},0]
[43,"Other (specify)",{"$f":"+IF('7. AMC 175 HCD Apprvd Cash Flow'!C60=0,\" \",'7. AMC 175 HCD Apprvd Cash Flow'!C60)","v":" "},null,{"$f":"(L59-I59)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M59-J59)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,{"$f":"IF($R$10=TRUE,I59,0)","v":0},{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!L60","v":0},0,{"$f":"IF($S$10=TRUE,L59,0)","v":0},0]
[44,"Other (specify)",{"$f":"+IF('7. AMC 175 HCD Apprvd Cash Flow'!C61=0,\" \",'7. AMC 175 HCD Apprvd Cash Flow'!C61)","v":" "},null,{"$f":"(L60-I60)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M60-J60)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,{"$f":"IF($R$10=TRUE,I60,0)","v":0},{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!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. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M63-J63)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"L63-E63-I63","v":0},0,0,{"$f":"IF($R$10=TRUE,I63,0)","v":0},{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!L64","v":0},0,{"$f":"IF($S$10=TRUE,L63,0)","v":0},0]
[47,"Asset Mgmt Fee (CHRP-R/SUHRP & HOME pre-UMR)",null,7190,{"$f":"(L64-I64)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M64-J64)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0,{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!L65","v":0},0,0,0]
[48,"Asset Mgmt Fee/Prtrshp Costs (MHP/HOME under UMR)",null,7190,{"$f":"(L65-I65)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M65-J65)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0,{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!L66","v":0},0,0,0]
[49,"Borrower Distributions",null,null,{"$f":"(L66-I66)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M66-J66)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0,{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!L67","v":0},0,0,0]
[50,"Residual Receipt Loan Payments",null,null,{"$f":"(L67-I67)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M67-J67)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0,{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!L68","v":0},0,0,0]
[51,"HCD Interest Payments",null,null,{"$f":"(L68-I68)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M68-J68)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0,{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!L69","v":0},0,0,0]
[52,"Other (specify)",{"$f":"+IF('7. AMC 175 HCD Apprvd Cash Flow'!C70=0,\" \",'7. AMC 175 HCD Apprvd Cash Flow'!C70)","v":" "},null,{"$f":"(L69-I69)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},{"$f":"(M69-J69)*IF('2. AMC 170 Checklist and Cert'!$L$6=0,'2. AMC 170 Checklist and Cert'!$L$5,'2. AMC 170 Checklist and Cert'!$L$6)","v":0},0,0,0,0,{"$f":"'7. AMC 175 HCD Apprvd Cash Flow'!L70","v":0},0,0,0]
[53,"Total Use of Cash Flow",null,null,{"$f":"SUM(E63:E69)","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(G74:H77)","v":0},null,{"$f":"SUM(I74:J77)","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(G81:H84)","v":0},null,{"$f":"SUM(I81:J84)","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(G88:H91)","v":0},null,{"$f":"SUM(I88:J91)","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(G95:H100)","v":0},null,{"$f":"SUM(I95:J100)","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(G104:H107)","v":0},null,{"$f":"SUM(I104:J107)","v":0},null,"Total Account 6890 Miscellaneous Financial Expenses"]