{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Completion Instructions","Annual Budget Pg 1","Rents and Other Income","Administrative","Salaries","Employee List","Maintenance & Repairs","Maintenance Contracts","Utilities","Rents","Tax,Inusurance, Debt Service","Capital Additions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"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":"Completion Instructions","index":0,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["ANNUAL BUDGET"]
["INSTRUCTIONS FOR COMPLETION"]
[]
[]
["NOTE: Each Schedule and/or Exhibit is located on a separate Tab in the Workbook"]
[]
[]
["1)","ONLY Complete the top portion of Page 1 where indicated in \"yellow\" Highlights."]
[]
["2)","Complete Schedules A thru G and Exhibits 1 thru 5 before completing Page 1 of the Budget."]
[]
["3)","Enter data in the \"yellow\" highlighted cells only."]
[]
["4)","All totals will be carried over to Page 1 of the Budget."]
[]
["5)","Print out pages 2 through 11 and then check to make sure all data has transferred over to"]
[null,"Page 1 accurately."]
[]
["6)","Complete Page 1 by entering any data required in the yellow highlighted area of the page."]
[]
["7)","When complete please sign and submit to (please copy your HMO):",null,null,null,null,null,null,"AM@NJHMFA.gov"]
[]
[null,"Please round all entries to the nearest hundred"]

{"sheet":"Annual Budget Pg 1","index":1,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["ANNUAL BUDGET"]
[]
[null,null,null,null,"HMFA#"]
[null,"DEVELOPMENT:",null,null,null,"YEAR ENDING:"]
[null,"ADDRESS:"]
[null,"SPONSOR/OWNER:",null,null,null,"APARTMENTS UNITS:"]
[null,null,null,null,null,"Superintendents) UNITS:"]
[null,null,null,null,null,"OTHER UNITS:"]
[null,null,null,null,null,"TOTAL:",{"$f":"SUM(G6:DG8)","v":0}]
[]
["R",null,null,null,"CURRENT YEAR"]
["E","ACCT.",null,"PRIOR YEAR","ACTUAL","ESTIMATED","BUDGET"]
["F","CODE","CLASSIFICATION","(AS AUDITED)","(MONTHS)","(MONTHS)","YEAR"]
[1,null,"INCOME:"]
[2,null,"APARTMENT RENTS (SCHEDULE A)",{"$f":"'Rents and Other Income'!D17","v":0},{"$f":"'Rents and Other Income'!E17","v":0},{"$f":"'Rents and Other Income'!F17","v":0},{"$f":"'Rents and Other Income'!G17","v":0}]
[3,null,"OTHER RENTS (SCHEDULE A)",{"$f":"'Rents and Other Income'!D23","v":0},{"$f":"'Rents and Other Income'!E23","v":0},{"$f":"'Rents and Other Income'!F23","v":0},{"$f":"'Rents and Other Income'!$G$23","v":0}]
[4,null,"TOTAL RENTS",{"$f":"SUM(D15:D16)","v":0},{"$f":"SUM(E15:E16)","v":0},{"$f":"SUM(F15:F16)","v":0},{"$f":"SUM(G15:G16)","v":0}]
[5,null,"OTHER INCOME (SCHEDULE B)",{"$f":"'Rents and Other Income'!D36","v":0},{"$f":"'Rents and Other Income'!E36","v":0},{"$f":"'Rents and Other Income'!F36","v":0},{"$f":"'Rents and Other Income'!$G$36","v":0}]
[6,null,"TOTAL INCOME",{"$f":"D17+D18","v":0},{"$f":"E17+E18","v":0},{"$f":"F17+F18","v":0},{"$f":"G17+G18","v":0}]
[7]
[8,null,"EXPENSES:"]
[9,5100,"ADMINISTRATIVE (SCHEDULE C)",{"$f":"Administrative!D37","v":0},{"$f":"Administrative!E37","v":0},{"$f":"Administrative!F37","v":0},{"$f":"Administrative!$G$37","v":0}]
[10,5200,"SALARIES (SCHEDULE D)",{"$f":"Salaries!F28","v":0},{"$f":"Salaries!G28","v":0},{"$f":"Salaries!H28","v":0},{"$f":"Salaries!$I$28","v":0}]
[11,5300,"MAINT. & REPAIRS (SCHEDULE E)",{"$f":"'Maintenance & Repairs'!D37","v":0},{"$f":"'Maintenance & Repairs'!E37","v":0},{"$f":"'Maintenance & Repairs'!F37","v":0},{"$f":"'Maintenance & Repairs'!$G$37","v":0}]
[12,5400,"MAINT. CONTRACTS (SCHEDULE F)",{"$f":"'Maintenance Contracts'!D28","v":0},{"$f":"'Maintenance Contracts'!E28","v":0},{"$f":"'Maintenance Contracts'!F28","v":0},{"$f":"'Maintenance Contracts'!$G$28","v":0}]
[13,5500,"UTILITIES (SCHEDULE G)",{"$f":"Utilities!D19","v":0},{"$f":"Utilities!E19","v":0},{"$f":"Utilities!F19","v":0},{"$f":"Utilities!$G$19","v":0}]
[14,5600,"MANAGING AGENTS FEE"]
[15,5710,"REAL ESTATE TAXES (EXHIBIT 2)"]
[16,5712,"INSURANCE (EXHIBIT 3)"]
[17,null,"TOTAL EXPENSES",{"$f":"SUM(D22:D29)","v":0},{"$f":"SUM(E22:E29)","v":0},{"$f":"SUM(F22:F29)","v":0},{"$f":"SUM(G22:G29)","v":0}]
[18]
[19,null,"NET INCOME (LOSS) FROM OPERATIONS",{"$f":"D19-D30","v":0},{"$f":"E19-E30","v":0},{"$f":"F19-F30","v":0},{"$f":"G19-G30","v":0}]
[20]
[21,"0000","DEBT SERVICE (EXHIBIT 4)",null,null,null,{"$f":"'Tax,Inusurance, Debt Service'!$G$42","v":0}]
[22,5813,"HOUSING FINANCE FUND"]
[23,5850,"REPAIR & REPLACEMENT RES."]
[24,null,"TOTAL DEBT SERVICE & RES.",{"$f":"SUM(D34:D36)","v":0},{"$f":"SUM(E34:E36)","v":0},{"$f":"SUM(F34:F36)","v":0},{"$f":"SUM(G34:G36)","v":0}]
[25]
[26,null,"NET INCOME (LOSS) FROM OPERATIONS",{"$f":"D32-D37","v":0},{"$f":"E32-E37","v":0},{"$f":"F32-F37","v":0},{"$f":"G32-G37","v":0}]
[27,null,"ADD:"]
[28,1997,"OTHER SOURCES OF FUNDS"]
[29,1998,"RESERVE REFUNDS",{"$f":"D39+D41","v":0},{"$f":"E39+E41","v":0},{"$f":"F39+F41","v":0}]
[30,null,"DEDUCT:"]
[31,1999,"CAPITAL ADDITIONS (EXHIBIT 5)",{"$f":"'Capital Additions'!D19","v":0},{"$f":"'Capital Additions'!E19","v":0},{"$f":"'Capital Additions'!F19","v":0},{"$f":"'Capital Additions'!G19","v":0}]
[32,2160]
[33,null,"PROJECTED CASH FLOW (DEFICIT)",{"$f":"D42-(D44+D45)","v":0},{"$f":"E42-(E44+E45)","v":0},{"$f":"F42-(F44+F45)","v":0},{"$f":"G39+G41+G42-G44","v":0}]
[]
[]
[]
[null,"Prepared by:",null,null,"Approved:"]
[]
[null,"Signature:",null,null,"Title:"]
[]
[null,"Date:",null,null,"Date:"]

{"sheet":"Rents and Other Income","index":2,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["ANNUAL BUDGET"]
["RENTS AND OTHER INCOME"]
["(SCHEDULES A AND B)"]
[]
[null,null,null,null,"HMFA#",{"$f":"'Annual Budget Pg 1'!$F$3","v":0}]
[null,"DEVELOPMENT:",{"$f":"'Annual Budget Pg 1'!C4","v":0},null,null,"YEAR ENDING:",{"$f":"'Annual Budget Pg 1'!$G$4","v":"00:00:00"}]
[null,"ADDRESS:",{"$f":"'Annual Budget Pg 1'!C5","v":0}]
[null,"SPONSOR/OWNER:",{"$f":"'Annual Budget Pg 1'!C6","v":0}]
[]
["R",null,null,null,"CURRENT YEAR"]
["E","ACCT.",null,"PRIOR YEAR","ACTUAL","ESTIMATED","BUDGET"]
["F","CODE","CLASSIFICATION","(AS AUDITED)","(___MONTHS)","(___MONTHS)","YEAR"]
[1,null,"RENTS (SCHEDULE A)"]
[2,4110,"    APARTMENT RENTS"]
[3,4210,"    LESS VACANCIES (      )%"]
[3,4211,"    LESS COLLECTION LOSSES"]
[4,null,"NET APARTMENT RENTS",{"$f":"D14-(D15+D16)","v":0},{"$f":"E14-(E15+E16)","v":0},{"$f":"F14-(F15+F16)","v":0},{"$f":"G14-(G15+G16)","v":0}]
[5,null,"OTHER RENTS"]
[6,4130,"    COMMERCIAL"]
[7,4150,"    GARAGE AND PARKING"]
[8,4220,"    Less GARAGE AND PARKING VACANCIES"]
[9,4230,"    Less COMMERCIAL VACANCIES"]
[10,null,"NET OTHER RENTS",{"$f":"SUM(D19:D20)-(D21+D22)","v":0},{"$f":"SUM(E19:E20)-(E21+E22)","v":0},{"$f":"SUM(F19:F20)-(F21+F22)","v":0},{"$f":"SUM(G19:G20)-(G21+G22)","v":0}]
[11,null,"TOTAL RENTAL INCOME*",{"$f":"D17+D23","v":0},{"$f":"E17+E23","v":0},{"$f":"F17+F23","v":0},{"$f":"G17+G23","v":0}]
[12]
[13,null,"OTHER INCOME (SCHEDULE B)"]
[14,4310,"    LAUNDRY MACHINES"]
[15,4320,"    AIR CONDITIONERS "]
[16,4340,"    VENDING MACHINES"]
[17,4350,"    MISCELLANEOUS SERVICE INCOME"]
[18,4410,"INCOME FROM INVESTMENTS"]
[19,4430,"LATE CHARGES AND OTHER"]
[20,4450,"INTEREST ON SECURITY DEPOSIT"]
[21,4500,"OTHER (List Below)**"]
[22]
[23,null,"TOTAL OTHER INCOME",{"$f":"SUM(D27:D34)","v":0},{"$f":"SUM(E27:E34)","v":0},{"$f":"SUM(F27:F34)","v":0},{"$f":"SUM(G27:G34)","v":0}]
[]
[]
[null,"**4500","OTHER INCOME:"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"* TOTALS WILL BE AUTOMATICALLY INSERTED ON PROPER LINE OF PAGE 1- CHECK TO MAKE SURE THEY AGREE"]

{"sheet":"Administrative","index":3,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["ANNUAL BUDGET"]
["ADMINISTRATION EXPENSES"]
["(SCHEDULE C)"]
[]
[null,null,null,null,"HMFA#",{"$f":"'Annual Budget Pg 1'!$F$3","v":0}]
[null,"DEVELOPMENT:",{"$f":"'Annual Budget Pg 1'!C4","v":0},null,null,"YEAR ENDING:",{"$f":"'Annual Budget Pg 1'!$G$4","v":"00:00:00"}]
[null,"ADDRESS:",{"$f":"'Annual Budget Pg 1'!C5","v":0}]
[null,"SPONSOR/OWNER:",{"$f":"'Annual Budget Pg 1'!C6","v":0}]
[]
["R",null,null,null,"CURRENT YEAR"]
["E","ACCT.",null,"PRIOR YEAR","ACTUAL","ESTIMATED","BUDGET"]
["F","CODE","CLASSIFICATION","(AS AUDITED)",{"$f":"'Rents and Other Income'!E12","v":"(___MONTHS)"},{"$f":"'Rents and Other Income'!F12","v":"(___MONTHS)"},"YEAR"]
[1,5121,"STATIONARY AND SUPPLIES"]
[2,5122,"TELEPHONE"]
[3,5123,"DUES AND SUBSCRIPTIONS"]
[4,5124,"POSTAGE"]
[5,5125,"OTHER OFFICE EXPENSES"]
[6,5126,"OTHER INSURANCE"]
[7,5127,"INSPECTION & OTHER FEES"]
[8,5128,"OTHER TAXES"]
[9,5151,"ADVERTISING"]
[10,5152,"OTHER PROFESSIONAL FEES"]
[11,5153,"LEGAL SERVICES"]
[12,5154,"CREDIT CHECK FEES"]
[13,5155,"AUDITING"]
[14,5156,"SOCIAL SERVICES"]
[15,5157,"NET CONGREGATE EXPENSES"]
[16,5158,"UNIFORM EXPENSES"]
[17,5159,"BOOKKEEPING, ACCOUNTING"]
[18,5160,"COMPUTER CHARGES"]
[19,5161,"ELECTRONIC SERVICES"]
[20,5195,"MISC. ADMIN. EXPENSES"]
[21]
[22]
[23]
[24]
[25,null,"TOTALS*",{"$f":"SUM(D13:D36)","v":0},{"$f":"SUM(E13:E36)","v":0},{"$f":"SUM(F13:F36)","v":0},{"$f":"SUM(G13:G36)","v":0}]
[]
[]
[null,"* TOTALS WILL BE AUTOMATICALLY INSERTED ON PROPER LINE OF PAGE 1- CHECK TO MAKE SURE THEY AGREE"]

{"sheet":"Salaries","index":4,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["ANNUAL BUDGET"]
["SALARIES AND RELATED CHARGES"]
["(SCHEDULE D)"]
[]
[null,null,null,null,"HMFA#",{"$f":"'Annual Budget Pg 1'!$F$3","v":0}]
[null,"DEVELOPMENT:",{"$f":"'Annual Budget Pg 1'!C4","v":0},null,null,"YEAR ENDING:",{"$f":"'Annual Budget Pg 1'!G4","v":"00:00:00"}]
[null,"ADDRESS:",{"$f":"'Annual Budget Pg 1'!C5","v":0}]
[null,"SPONSOR/OWNER:",{"$f":"'Annual Budget Pg 1'!C6","v":0}]
[]
["R",null,null,null,null,null,"CURRENT YEAR"]
["E","ACCT.",null,null,null,"PRIOR YEAR","ACTUAL","ESTIMATED","BUDGET"]
["F","CODE","CLASSIFICATION",null,null,"(AS AUDITED)",{"$f":"'Rents and Other Income'!E12","v":"(___MONTHS)"},{"$f":"'Rents and Other Income'!F12","v":"(___MONTHS)"},"YEAR"]
[1,5210,"SUPERINTENDENT'S SALARY"]
[2,5211,"JANITORIAL SALARIES"]
[3,5212,"GROUNDS & LANDSCAPING SALARIES"]
[4,5213,"SECURITY SALARIES"]
[5,5214,"SOCIAL SERVICE SALARIES"]
[6,5215,"OFFICE & ADMIN. SALARIES"]
[7,5216,"MAINTENANCE SALARIES"]
[8,5217,"OTHER SALARIES: **Explain Below"]
[9,5218,"BUS/VAN DRIVER SALARIES"]
[10,5261,"EMPLOYEE BENEFITS"]
[11,5262,"EMPLOYER'S PAYROLL TAXES"]
[12,5263,"WORKMAN'S COMPENSATION"]
[13,5264,"FIDELITY BONDS"]
[14]
[15]
[16,null,"TOTALS*",null,null,{"$f":"SUM(F13:F27)","v":0},{"$f":"SUM(G13:G27)","v":0},{"$f":"SUM(H13:H27)","v":0},{"$f":"SUM(I13:I27)","v":0}]
[]
[null,"** OTHER SALARIES:"]
[]
[]
["DETAILS OF PAYROLL"]
[]
["R",null,null,"CURRENT YEAR",null,null,"BUDGET YEAR"]
["E",null,null,"# OR","IND. GROSS",null,"# OR","IND. GROSS"]
["F","    CLASSIFICATION",null,"EMPL.","WKLY WAGES","TOTALS","EMPL.","WKLY WAGES","TOTALS"]
[1,"SUPERINTENDENT"]
[2,"JANITORIAL"]
[3,"GROUNDS & LANDSCAPING"]
[4,"SECURITY SALARIES"]
[5,"SOCIAL SERVICES"]
[6,"ADMINISTRATION"]
[7,"MAINTENANCE"]
[8,"OTHER**"]
[]
[null,"NOTE: PLEASE INDICATE IF EMPLOYEE IS PART-TIME"]
[]
[null,"** OTHER SALARIES:"]
[]
[]
[]
[null,"* TOTALS WILL BE AUTOMATICALLY INSERTED ON PROPER LINE OF PAGE 1- CHECK TO MAKE SURE THEY AGREE"]

{"sheet":"Employee List","index":5,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["HMFA#",{"$f":"'Annual Budget Pg 1'!$F$3","v":0},"YEAR ENDING:"]
[]
["DEVELOPMENT:",{"$f":"'Annual Budget Pg 1'!C4","v":0}]
["ADDRESS:",{"$f":"'Annual Budget Pg 1'!C5","v":0}]
["SPONSOR/OWNER:",{"$f":"'Annual Budget Pg 1'!C6","v":0}]
[]
[]
[]
[]
[null,null,"CURRENT ANNUAL","DATE OF"]
["EMPLOYEE","POSITION","SALARY","HIRE"]

{"sheet":"Maintenance & Repairs","index":6,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["ANNUAL BUDGET"]
["ADMINISTRATION EXPENSES"]
["(SCHEDULE C)"]
[]
[null,null,null,null,"HMFA#",{"$f":"'Annual Budget Pg 1'!$F$3","v":0}]
[null,"DEVELOPMENT:",{"$f":"'Annual Budget Pg 1'!C4","v":0},null,null,"YEAR ENDING:"]
[null,"ADDRESS:",{"$f":"'Annual Budget Pg 1'!C5","v":0}]
[null,"SPONSOR/OWNER:",{"$f":"'Annual Budget Pg 1'!C6","v":0}]
[]
["R",null,null,null,"CURRENT YEAR"]
["E","ACCT.",null,"PRIOR YEAR","ACTUAL","ESTIMATED","BUDGET"]
["F","CODE","CLASSIFICATION","(AS AUDITED)",{"$f":"'Rents and Other Income'!E12","v":"(___MONTHS)"},{"$f":"'Rents and Other Income'!F12","v":"(___MONTHS)"},"YEAR"]
[1,5321,"MASONRY"]
[2,5322,"CARPENTRY"]
[3,5323,"PLUMBING"]
[4,5324,"ELECTRICAL"]
[5,5325,"KITCHEN EQUIPMENT"]
[6,5327,"ELEVATOR"]
[7,5328,"WINDOWS AND GLASSES"]
[8,5329,"VEHICLES AND EQUIPMENT"]
[9,5330,"SNOW REMOVAL"]
[10,5331,"GROUNDS AND LANDSCAPING"]
[11,5340,"PAINTING AND DÉCOR. SUPPLIES"]
[12,5341,"SMALL EQUIPMENT & TOOLS"]
[13,5342,"JANITORIAL SUPPLIES & TOOLS"]
[14,5344,"HVAC SUPPLIES"]
[15,5345,"HARDWARE SUPPLIES"]
[16,5350,"MISC. MAINTENANCE SUPPLIES"]
[17,5390,"OTHER**Explain Below"]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25,null,"TOTALS*",{"$f":"SUM(D13:D36)","v":0},{"$f":"SUM(E13:E36)","v":0},{"$f":"SUM(F13:F36)","v":0},{"$f":"SUM(G13:G36)","v":0}]
[]
[]
[null,"* TOTALS WILL BE AUTOMATICALLY INSERTED ON PROPER LINE OF PAGE 1- CHECK TO MAKE SURE THEY AGREE"]
[]
[null,"** OTHER EXPLANATION:"]

{"sheet":"Maintenance Contracts","index":7,"n_rows":50,"n_cols":7,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["ANNUAL BUDGET"]
["MAINTENANCE CONTRACTS"]
["(SCHEDULE F)"]
[]
[null,null,null,null,"HMFA#",{"$f":"'Annual Budget Pg 1'!$F$3","v":0}]
[null,"DEVELOPMENT:",{"$f":"'Annual Budget Pg 1'!C4","v":0},null,null,"YEAR ENDING:",{"$f":"'Annual Budget Pg 1'!$G$4","v":"00:00:00"}]
[null,"ADDRESS:",{"$f":"'Annual Budget Pg 1'!C5","v":0}]
[null,"SPONSOR/OWNER:",{"$f":"'Annual Budget Pg 1'!C6","v":0}]
[]
["R",null,null,null,"CURRENT YEAR"]
["E","ACCT.",null,"PRIOR YEAR","ACTUAL","ESTIMATED","BUDGET"]
["F","CODE","CLASSIFICATION","(AS AUDITED)",{"$f":"'Rents and Other Income'!E12","v":"(___MONTHS)"},{"$f":"'Rents and Other Income'!F12","v":"(___MONTHS)"},"YEAR"]
[1,5413,"MONITORING & PROTECTION SERVICES"]
[2,5414,"FIRE SYSTEM MONITORING"]
[3,5415,"CLEANING"]
[4,5425,"ELEVATOR"]
[5,5426,"RUBBISH REMOVAL"]
[6,5430,"HEATING& AIR COND. MAINT."]
[7,5432,"GROUNDS, PARKING & LANDSCAPING"]
[8,5440,"PAINTING & DECORATING"]
[9,5460,"EXTERMINATING"]
[10,5490,"OTHER MAINT. CONTRACTS"]
[11]
[12]
[13]
[14]
[15]
[16,null,"TOTALS*",{"$f":"SUM(D13:D27)","v":0},{"$f":"SUM(E13:E27)","v":0},{"$f":"SUM(F13:F27)","v":0},{"$f":"SUM(G13:G27)","v":0}]
[]
[]
["DETAILS OF MAINTENANCE CONTRACTS"]
[]
["R"]
["E","DATE OF ","TYPE OF MAINTENANCE CONTRACT","EXP.","CURRENT ANNUAL","EST. RENEWAL"]
["F","CONTRACT","AND NAME OF CONTRACTOR","DATE","PAYMENT","PAYMENT"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[]
[]
[]
[]
[]
[]
[null,"* TOTALS WILL BE AUTOMATICALLY INSERTED ON PROPER LINE OF PAGE 1- CHECK TO MAKE SURE THEY AGREE"]

{"sheet":"Utilities","index":8,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["ANNUAL BUDGET"]
["UTILITY EXPENSES"]
["(SCHEDULE G)"]
[]
[null,null,null,null,"HMFA#",{"$f":"'Annual Budget Pg 1'!$F$3","v":0}]
[null,"DEVELOPMENT:",{"$f":"'Annual Budget Pg 1'!C4","v":0},null,null,"YEAR ENDING:",{"$f":"'Annual Budget Pg 1'!G4","v":"00:00:00"}]
[null,"ADDRESS:",{"$f":"'Annual Budget Pg 1'!C5","v":0}]
[null,"SPONSOR/OWNER:",{"$f":"'Annual Budget Pg 1'!C6","v":0}]
[]
["R",null,null,null,"CURRENT YEAR"]
["E","ACCT.",null,"PRIOR YEAR","ACTUAL","ESTIMATED","BUDGET"]
["F","CODE","CLASSIFICATION","(AS AUDITED)",{"$f":"'Rents and Other Income'!E12","v":"(___MONTHS)"},{"$f":"'Rents and Other Income'!F12","v":"(___MONTHS)"},"YEAR"]
[1,5521,"WATER"]
[2,5522,"SEWER CHARGES"]
[3,5523,"ELECTRICITY"]
[4,5524,"GAS"]
[5,5525,"FUEL"]
[6]
[7,null,"TOTALS*",{"$f":"SUM(D13:D18)","v":0},{"$f":"SUM(E13:E18)","v":0},{"$f":"SUM(F13:F18)","v":0},{"$f":"SUM(G13:G18)","v":0}]
[]
[]
[null,"* TOTALS WILL BE AUTOMATICALLY INSERTED ON PROPER LINE OF PAGE 1- CHECK TO MAKE SURE THEY AGREE"]

{"sheet":"Rents","index":9,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
["ANNUAL BUDGET"]
["DETAIL OF RENTS (EXHIBIT 1)"]
[]
[null,null,null,null,null,null,"HMFA#",{"$f":"'Annual Budget Pg 1'!$F$3","v":0}]
["DEVELOPMENT:",{"$f":"'Annual Budget Pg 1'!C4","v":0},null,null,null,null,null,"YEAR ENDING:",{"$f":"'Annual Budget Pg 1'!G4","v":"00:00:00"}]
["ADDRESS:",{"$f":"'Annual Budget Pg 1'!C5","v":0}]
["SPONSOR/OWNER:",{"$f":"'Annual Budget Pg 1'!C6","v":0}]
[]
[]
[]
[null,null,"MONTHLY CHARGE PER UNIT"]
[null,null,"PRIOR YEAR",null,"CURRENT YEAR",null,"PROPOSED",null,"ANNUAL TOTALS"]
[null,null,"MOS.",null,"MOS.",null,"MOS."]
["DESCRIPTION","NO. OF","IN",null,"IN",null,"IN",null,"PRIOR","CURRENT","BUDGET"]
["OF UNITS","UNITS","EFFECT","AMOUNT","EFFECT","AMOUNT","EFFECT","AMOUNT","YEARS","YEAR","YEAR"]
["EFFICIENCY",null,null,null,null,null,null,null,{"$f":"C17*D17","v":0},{"$f":"E17*F17","v":0},{"$f":"G17*H17","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"C18*D18","v":0},{"$f":"E18*F18","v":0},{"$f":"G18*H18","v":0}]
[null,null,null,null,null,null,null,null,0,0,0]
["1 BEDROOM",null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
["2 BEDROOM",null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
["3 BEDROOM",null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
["4 BEDROOM",null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
["5 BEDROOM",null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
["TOTALS",{"$f":"SUM(B17:B35)","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[null,"CODE OF TENANT SERVICES INCLUDED IN RENT (CIRCLE APPLICABLE ITEMS)"]
[]
[]
[null,"A","Apartment Electricity",null,null,"E","Security"]
[null,"B","Heat (gas, oil, electric)",null,null,"F","Recreational Facilities"]
[null,"C","Air Conditioning (gas, oil, electric)",null,null,"G","Other:"]
[null,"D","Cooking gas"]

{"sheet":"Tax,Inusurance, Debt Service","index":10,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
["ANNUAL BUDGET"]
[]
[null,null,null,null,"HMFA#",{"$f":"'Annual Budget Pg 1'!$F$3","v":0}]
["DEVELOPMENT:",{"$f":"'Annual Budget Pg 1'!C4","v":0},null,null,null,"YEAR ENDING:",{"$f":"'Annual Budget Pg 1'!G4","v":"00:00:00"}]
["ADDRESS:",{"$f":"'Annual Budget Pg 1'!C5","v":0}]
["SPONSOR/OWNER:",{"$f":"'Annual Budget Pg 1'!C6","v":0}]
[]
[]
["DETAILS OF REAL ESTATE TAX COMPUTATION (EXHIBIT 2)"]
[]
[null,null,null,null,"CURRENT YEAR"]
[null,null,null,"PRIOR YEAR","ACTUAL","ESTIMATED","BUDGET "]
["CLASSIFICATION",null,null,"(AS AUDITED)",{"$f":"'Rents and Other Income'!E12","v":"(___MONTHS)"},{"$f":"'Rents and Other Income'!F12","v":"(___MONTHS)"},"YEAR"]
["GROSS RENTS (LESS VACANCY)",null,null,{"$f":"'Rents and Other Income'!D14-'Rents and Other Income'!D15","v":0},{"$f":"'Rents and Other Income'!E14-'Rents and Other Income'!E15","v":0},{"$f":"'Rents and Other Income'!F14-'Rents and Other Income'!F15","v":0},1]
["LESS: UTILITIES (SCHEDULE G)"]
["      NET: \"GROSS SHELTERED RENTS\"",null,null,{"$f":"D15-D16","v":0},{"$f":"E15-E16","v":0},{"$f":"F15-F16","v":0},{"$f":"G15-G16","v":1}]
["*TAX %",null,null,null,{"$f":"E17*$B18","v":0},{"$f":"F17*$B18","v":0},{"$f":"G17*$B18","v":0}]
["    (AS PER TAX ABATEMENT AGREEMENT)*"]
["DETAILS OF INSURANCE (EXHIBIT 3)"]
[]
["DATE OF","TYPE OF INSURANCE, NAME ",null,"EXPIRATION","AMOUNT OF","CURRENT ","EST. RENEWAL"]
["POLICY","OF CARRIER AND POLICY NUMBER",null,"DATE","COVERAGE","ANNUAL PREMIUM","ANNUAL PREMIUM"]
[null,null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTALS*",null,null,null,{"$f":"SUM(F24:F31)","v":0},{"$f":"SUM(G24:G31)","v":1}]
[]
["DETAILS OF DEBT SERVICE REQUIREMENT (EXHIBIT 4)"]
[]
[null,null,null,"FEES",null,"LESS SEC.236"]
["CLASSIFICATION","INTEREST","PRINCIPAL","CHARGES","TOTAL","SUBSIDY","NET"]
["1ST MORTGAGE",null,null,null,1]
["2ND MORTGAGE",null,null,null,{"$f":"SUM(B39:D39)","v":0},null,{"$f":"E39-F39","v":0}]
[null,null,null,null,{"$f":"SUM(B40:D40)","v":0},null,{"$f":"E40-F40","v":0}]
[null,null,null,null,{"$f":"SUM(B41:D41)","v":0},null,{"$f":"E41-F41","v":0}]
["TOTALS*",{"$f":"SUM(B38:B41)","v":0},0,0,{"$f":"SUM(E38:E41)","v":1},0,0]
[]
[]
[]
[]
["** TOTALS WILL BE AUTOMATICALLY INSERTED ON PROPER LINE OF PAGE 1- CHECK TO MAKE SURE THEY AGREE"]

{"sheet":"Capital Additions","index":11,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
["ANNUAL BUDGET"]
[null,null,null,null,"HMFA#",{"$f":"'Annual Budget Pg 1'!$F$3","v":0}]
["DEVELOPMENT:",{"$f":"'Annual Budget Pg 1'!C4","v":0},null,null,null,"YEAR ENDING:",{"$f":"'Annual Budget Pg 1'!G4","v":"00:00:00"}]
["ADDRESS:",{"$f":"'Annual Budget Pg 1'!C5","v":0}]
["SPONSOR/OWNER:",{"$f":"'Annual Budget Pg 1'!C6","v":0}]
[]
[]
["DETAILS OF CAPITAL ADDITIONS (EXHIBIT 5)"]
[]
["ACCOUNT",null,null,"PRIOR YEAR","CURRENT YEAR"]
["CODE","CLASSIFICATION",null,"(AS AUDITED)",{"$f":"'Rents and Other Income'!E12","v":"(___MONTHS)"},{"$f":"'Rents and Other Income'!F12","v":"(___MONTHS)"},"BUDGET YEAR"]
[]
[]
[]
[]
[]
[]
[null,"TOTALS*",null,{"$f":"SUM(D13:D18)","v":0},{"$f":"SUM(E13:E18)","v":0},{"$f":"SUM(F13:F18)","v":0},{"$f":"SUM(G13:G18)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["* TOTALS WILL BE AUTOMATICALLY INSERTED ON PROPER LINE OF PAGE 1- CHECK TO MAKE SURE THEY AGREE"]