{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Total Consolidated ","Sheet2","Orchard Valley","UPHAM","west 40","WRP ","Hilltop ","west 46 ","Arvada Cottages ","Allison Village","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":19,"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":"Total Consolidated ","index":0,"n_rows":150,"n_cols":13,"rows_kept":150,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"JEFFCO HOUSING CORPORATION"]
[null,null,null,null,"CONSOLIDATED"]
[null,null,null,null,"FY 2017 OPERATING BUDGET"]
[]
[null,null,null,null,null,null,null,"Actual","Actual"]
[null,null,"Budget",null,"Budget","Budget",null,null,"YTD "]
[null,null,"FY 2016",null,"FY 2017","FY 2017",null,"FY 2016","FY 2016"]
[null,null,"ANNUAL",null,"ANNUAL","Monthly",null,"12MO Esitmate","at 9/30/16"]
[]
["OPERATING RECEIPTS-TOTAL"]
["ORCHARD VALLEY ",null,288750,null,402040,33503.333333333328,null,317473.65333333332,234070.24]
["RESPITE",null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"}]
["UPHAM",null,123330,null,132780,11064.999999999998,null,126803.25333333334,84046.81]
["WEST 40TH",null,75230,null,90440,7536.666666666667,null,68248.453333333338,51186.34]
["WHEAT RIDGE PARK",null,163010,null,178730,14894.166666666668,null,165797.68,124348.26000000001]
["HILLTOP",null,299610,null,320841,26736.750000000004,null,300445.68000000005,224490.51]
["WEST 46TH",null,79680,null,73870,6155.833333333333,null,65264.346666666672,48935.76]
["ARVADA COTTAGES",null,251070,null,261490,21790.833333333336,null,253061.88,189796.41]
["ALLISON VILLAGE",null,353220,null,365428,30452.333333333332,null,356794.69333333336,264641.68]
["DISPERSED HOUSING",null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["TOTAL OPERATING RECEIPTS",null,1633900,null,1825619,152134.91666666666,null,1653889.6400000001,1232273.97]
[]
["OPERATING EXPENDITURES"]
["ORCHARD VALLEY ",null,351540,null,35779.166666666664,348696.80000000005,null,0,{"$error":"#REF!"}]
["RESPITE",null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"}]
["UPHAM",null,140320,null,12224.107788888889,115811.42666666667,null,0,{"$error":"#REF!"}]
["WEST 40TH",null,93400,null,9016.7052999999996,87712.053333333344,null,0,{"$error":"#REF!"}]
["WHEAT RIDGE PARK",null,189660,null,15335.833333333334,180805.17333333334,null,0,{"$error":"#REF!"}]
["HILLTOP",null,373010,null,31118.362300000001,366939.64,null,0,0]
["WEST 46TH",null,104410,null,8517.4999999999982,91910.573333333334,null,0,{"$error":"#REF!"}]
["ARVADA COTTAGES",null,331700,null,26188.324444444446,311478.47333333333,null,0,{"$error":"#REF!"}]
["ALLISON VILLAGE",null,429890,null,37124.975116666668,411622.73333333328,null,0,{"$error":"#REF!"}]
["DISPERSED HOUSING",null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["TOTAL OPERATING EXPENSE",null,2013930,null,2089319.6993999998,175304.97495,null,1914976.8733333331,1530503.92]
["NET INCOME",null,-380030,null,-263700.69939999981,-23170.058283333346,null,-261087.23333333293,-298229.94999999995]
[]
[]
[]
["ADMINISTRATIVE EXPENDITURES"]
["ORCHARD VALLEY ",null,34700,null,6505.8333333333339,35333.213333333333,null,0,{"$error":"#REF!"}]
["RESPITE",null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"}]
["UPHAM",null,24460,null,2143.3055666666664,23495.439999999999,null,0,{"$error":"#REF!"}]
["WEST 40TH",null,6440,null,540.86334444444446,5654.16,null,0,{"$error":"#REF!"}]
["WHEAT RIDGE PARK",null,23440,null,1986.6666666666665,22182.506666666668,null,0,{"$error":"#REF!"}]
["HILLTOP",null,36050,null,2965.8623000000002,33977.133333333331,null,0,0]
["WEST 46TH",null,5850,null,475.83333333333331,4743.8133333333326,null,0,{"$error":"#REF!"}]
["ARVADA COTTAGES",null,27230,null,2235.833333333333,24731.25333333333,null,0,{"$error":"#REF!"}]
["ALLISON VILLAGE",null,61270,null,5090.8333333333321,59317.306666666664,null,0,{"$error":"#REF!"}]
["DISPERSED HOUSING",null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["TOTAL ADMINISTRATIVE",null,219440,null,263340.37453333335,21945.031211111109,null,209434.82666666669,159882.82]
[]
["OPERATING EXPENDITURES"]
["ORCHARD VALLEY ",null,44730,null,3702.5,42477.693333333336,null,0,{"$error":"#REF!"}]
["RESPITE",null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"}]
["UPHAM",null,15020,null,1474.1666666666667,18420.64,null,0,{"$error":"#REF!"}]
["WEST 40TH",null,8070,null,595,6778.8933333333334,null,0,{"$error":"#REF!"}]
["WHEAT RIDGE PARK",null,16010,null,1263.3333333333335,14386.626666666667,null,0,{"$error":"#REF!"}]
["HILLTOP",null,17180,null,1439.1666666666665,16296.466666666665,null,0,0]
["WEST 46TH",null,4520,null,502.5,5646.1466666666665,null,0,{"$error":"#REF!"}]
["ARVADA COTTAGES",null,17530,null,1899.991111111111,21081.153333333332,null,0,{"$error":"#REF!"}]
["ALLISON VILLAGE",null,40770,null,3557.5146999999993,42324.626666666663,null,0,{"$error":"#REF!"}]
["DISPERSED HOUSING",null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["TOTAL OPERATING",null,163830,null,173210.06973333334,14434.172477777776,null,167412.24666666664,126414.39]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["MAINTENANCE EXPENDITURES",null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["ORCHARD VALLEY ",null,65830,null,6471.666666666667,71375.346666666679,null,0,{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
["RESPITE",null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
["UPHAM",null,47740,null,4264.9688888888886,26234.28,null,0,{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
["WEST 40TH",null,33450,null,3835.8419555555552,29072.960000000003,null,0,{"$error":"#REF!"}]
["WHEAT RIDGE PARK",null,49660,null,5532.4999999999991,44444.586666666662,null,0,{"$error":"#REF!"}]
["HILLTOP",null,75410,null,5644.166666666667,90172.786666666667,null,0,0,null,null,null,{"$error":"#REF!"}]
["WEST 46TH",null,28810,null,2146.6666666666665,17593.746666666666,null,0,{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
["ARVADA COTTAGES",null,50180,null,4031.6666666666665,57945.426666666674,null,0,{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
["ALLISON VILLAGE",null,86450,null,8601.6666666666679,72313.346666666665,null,0,{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
["DISPERSED HOUSING",null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
[]
["TOTAL MAINTENANCE",null,437530,null,472009.73013333336,40529.14417777778,null,409152.48000000004,306864.36,null,null,null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["GENERAL",null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["ORCHARD VALLEY ",null,89680,null,7549.1666666666661,85910.546666666662,null,0,{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
["RESPITE",null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"}]
["UPHAM",null,48300,null,3891.666666666667,42861.066666666666,null,0,{"$error":"#REF!"}]
["WEST 40TH",null,18740,null,1570,16511.439999999999,null,0,{"$error":"#REF!"}]
["WHEAT RIDGE PARK",null,52440,null,4372.5,51681.453333333331,null,0,{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
["HILLTOP",null,88010,null,7205.833333333333,85653.253333333327,null,0,0,null,null,null,{"$error":"#REF!"}]
["WEST 46TH",null,24770,null,2020.833333333333,23466.866666666669,null,0,{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
["ARVADA COTTAGES",null,69700,null,5331.6666666666661,61478.64,null,0,{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
["ALLISON VILLAGE",null,96530,null,8260.7937500000007,91679.453333333338,null,0,{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
["DISPERSED HOUSING",null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
[]
["TOTAL GENERAL EXPENSE",null,488170,null,482429.52500000002,40202.460416666669,null,459242.72000000009,360255.85000000003,null,null,null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
[]
["FINANCING",null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["ORCHARD VALLEY ",null,108800,null,9066.6666666666661,108800,null,0,{"$error":"#REF!"}]
["RESPITE",null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"}]
["UPHAM",null,0,null,0,0,null,"No Mortgage",{"$error":"#REF!"}]
["WEST 40TH",null,23100,null,1925,23094.600000000002,null,0,{"$error":"#REF!"}]
["WHEAT RIDGE PARK",null,43310,null,1780.8333333333335,43310,null,0,{"$error":"#REF!"}]
["HILLTOP",null,130060,null,10838.333333333334,130060,null,0,0]
["WEST 46TH",null,32580,null,2715,32580,null,0,{"$error":"#REF!"}]
["ARVADA COTTAGES",null,142470,null,11872.5,142470,null,0,{"$error":"#REF!"}]
["ALLISON VILLAGE",null,123770,null,10314.166666666666,123770,null,0,{"$error":"#REF!"}]
["DISPERSED HOUSING",null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["TOTAL FINANCING",null,604090,null,582150,48512.5,null,604084.6,501472.65,null,null,null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["RESERVES",null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["ORCHARD VALLEY ",null,4800,null,400,4800,null,0,{"$error":"#REF!"}]
["RESPITE",null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"}]
["UPHAM",null,4800,null,450,4800,null,0,{"$error":"#REF!"}]
["WEST 40TH",null,3600,null,300,3600,null,0,{"$error":"#REF!"}]
["WHEAT RIDGE PARK",null,4800,null,400,4800,null,0,{"$error":"#REF!"}]
["HILLTOP",null,3600,null,400,3600,null,0,0]
["WEST 46TH",null,5400,null,450,5400,null,0,{"$error":"#REF!"}]
["ARVADA COTTAGES",null,2400,null,400,2400,null,0,{"$error":"#REF!"}]
["ALLISON VILLAGE",null,15600,null,1300,15600,null,0,{"$error":"#REF!"}]
["DISPERSED HOUSING",null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["TOTAL RESERVES",null,45000,null,49200,4100,null,45000,33750,null,null,null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["CAPITAL EXPENDITURES",null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["ORCHARD VALLEY ",null,3000,null,2083.3333333333335,0,null,0,{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
["RESPITE",null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"}]
["UPHAM",null,0,null,0,0,null,0,{"$error":"#REF!"}]
["WEST 40TH",null,0,null,250,3000,null,0,{"$error":"#REF!"}]
["WHEAT RIDGE PARK",null,0,null,0,0,null,0,{"$error":"#REF!"}]
["HILLTOP",null,22700,null,2625,7180,null,0,0]
["WEST 46TH",null,2480,null,206.66666666666666,2480,null,0,{"$error":"#REF!"}]
["ARVADA COTTAGES",null,22190,null,416.66666666666669,1372,null,0,{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
["ALLISON VILLAGE",null,5500,null,0,6618,null,0,{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
["DISPERSED HOUSING",null,{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,{"$error":"#REF!"}]
[]
["TOTAL CAPITAL EXP.",null,55870,null,66980,5581.6666666666679,null,20650,41863.85]
[]
[]
["TOTAL EXPENDITURES",null,2013930,null,2089319.6993999998,175304.97495000003,null,1914976.8733333333,1530503.92]
[]
["NET GAIN/(LOSS)",null,-380030,null,-263700.69939999981,-23170.058283333376,null,-261087.23333333316,-298229.94999999995]
[]
[]
["DEPRECIATION INCLUDED IN GENERAL EXP.",null,338260,null,332520,27709.999999999996,null,328251.31999999995,245471.45999999996]
[]
["NET INCOME(LOSS) AFTER DEPRCIATION",null,-41770,null,68819.300600000191,4539.9417166666208,null,67164.086666666786,-52758.489999999991]

{"sheet":"Sheet2","index":1,"n_rows":109,"n_cols":6,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"JEFFCO HOUSING CORPORATION"]
[null,null,"FY 2017 OPERATING BUDGET"]
[]
[null,"Budget","Budget","Budget",null,"Actual"]
[null,null,null,null,null,"YTD "]
[null,"FY 2016","FY 2017","FY 2017","FY 2016","FY 2016"]
[null,"ANNUAL","ANNUAL","Monthly","12MO Estimate","at 9/30/16"]
["OPERATING RECEIPTS"]
["RENTAL INCOME",1166830,1279761,106646.75000000001,1237273.6666666667,923039]
["TENNANT ASSISTANCE",433750,443158,36929.833333333328,408717.33333333331,306538]
["VACANCIES",-31360,-28660,-2388.333333333333,-17287.826666666668,-12965.869999999999]
["TRANSFER FROM RESERVES",45000,72200,6016.666666666667,0,0]
["INTEREST INCOME",300,260,21.666666666666671,248.05333333333334,186.04000000000002]
["LAUNDRY INCOME( Laundry)",11570,11930,994.16666666666674,13168.72,9876.5399999999991]
["NSF & LATE CHARGES",2430,2020,168.33333333333334,1986.6666666666665,1490]
["OTHER INCOME",5380,19950,1662.5,9783.0266666666666,4110.26]
["GRANT INCOME",0,25000,2083.3333333333335,0,0]
["TOTAL OPERATING RECEIPTS",1633900,1825619,152134.91666666666,1653889.64,1232273.97]
[]
["OPERATING EXPENDITURES"]
["ADMINISTRATIVE",219440,263340.37453333335,21945.031211111109,209434.82666666669,159882.82]
["OPERATING",163830,173210.06973333334,14434.172477777776,167412.24666666664,126414.39]
["MAINTENANCE",437530,472009.73013333336,40529.14417777778,409152.48000000004,306864.36]
["GENERAL",488170,482429.52500000002,40202.460416666669,459242.72000000009,360255.85000000003]
["FINANCING",604090,582150,48512.5,604084.6,501472.65]
["RESERVES",45000,49200,4100,45000,33750]
["CAPITAL EXPENSE",55870,66980,5581.6666666666679,20650,41863.85]
["TOTAL OPERATING EXPENSE",2013930,2089319.6994,175304.97494999997,1914976.8733333335,1530503.9200000004]
["NET INCOME (LOSS)",-380030,-263700.69940000004,-23170.058283333317,-261087.23333333363,-298229.95000000042]
[]
[]
["ADMINISTRATIVE EXPENDITURES"]
["OFFICE SALARIES",84520,87880,7323.3333333333339,85320.013333333336,63990.01]
["CONTRACT SALARY - DIRECTOR",0,25000,2083.3333333333335,0,0]
["CONTRACT EXPENSES - DIRECTOR",0,15000,1250,27.733333333333334,20.8]
["OFFICE SUPPLIES",1970,2959.6668,246.63889999999998,3554,2665.5]
["DUES & MTG EXPENSE",820,1250,104.16666666666666,1189.1066666666666,891.82999999999993]
["CLIENT VERIFICATION SERVICES",3730,1130,94.166666666666657,878.2,2131.8500000000004]
["MANAGEMENT FEE",78720,85640,7136.6666666666661,81422.026666666658,61066.52]
["LEGAL",4360,4440,370,0,0]
["ACCOUNTING/AUDIT",17890,17080,1423.3333333333335,16497,13706.25]
["TELEPHONE",7500,9220,768.33333333333337,7656.0533333333333,5742.04]
["COMPUTER EXPENSES",8390,780.36013333333335,65.030011111111108,732.4,549.29999999999995]
["MISC. ADMIN. EXPENSE",5160,6000.3476000000001,500.02896666666663,5409.9066666666668,4057.43]
["TRAVEL",6380,6960,580,6748.3866666666672,5061.29]
["TOTAL ADMINISTRATIVE",219440,263340.37453333335,21945.031211111105,209434.82666666666,159882.82]
[null,null,null,null," "]
["OPERATING EXPENDITURES",null,null,null," "]
["ELECTRIC",53960,51940.06973333333,4328.3391444444442,50374.733333333337,37781.050000000003]
["WATER",43940,60870,5072.5,57114.679999999993,41099.46]
["GAS",35020,28520,2376.666666666667,26934.720000000001,20201.04]
["SEWER",30910,31880,2656.6666666666665,32988.113333333335,27332.84]
["TOTAL OPERATING",163830,173210.06973333334,14434.172477777776,167412.24666666667,126414.39000000001]
[]
["MAINTENANCE EXPENDITURES"]
["JANITORIAL CONTRACT & SUPPLY",12930,11040,920.00000000000011,11692,8769]
["EXTERMINATING CONTRACT",15230,16470,1372.5,14073.333333333332,10555]
["TRASH REMOVAL",16760,16820.103466666667,1401.6752888888891,15473.146666666667,11604.859999999999]
["GROUNDS CONTRACT & SUPPLIES",37870,44470,3705.8333333333335,56255.546666666662,42191.66]
["REPAIR MATERIALS",71950,80140,6678.3333333333339,61681.893333333333,46261.42]
["REPAIR CONTRACT COSTS",99830,94240,7853.3333333333339,91526.573333333348,68644.929999999993]
["CARPET & VINYL/PLANK",34300,35440,4148.3333333333339,46423.64,34817.730000000003]
["APPLIANCES ",28850,39490,3290.833333333333,16567.96,12425.97]
["REPAIR PAYROLL",92140,76549.626666666663,6379.1355555555556,74289.866666666669,55717.4]
["SNOW REMOVAL",21290,20520,1710.0000000000005,13113.333333333332,9835]
["CABINETS & FURNITURE",0,18500,1541.6666666666667,1916.2666666666669,1437.2]
["SECURITY",6380,18330,1527.5,6138.9199999999992,4604.1899999999996]
["TOTAL MAINTENANCE",437530,472009.7301333333,40529.144177777773,409152.48000000004,306864.36000000004]
[null,null,null,null," "]
["GENERAL",null,null,null," "]
["PAYROLL TAXES",13530,12590,1049.1666666666665,11942.64,8956.98]
["PROP & LIAB. INSURANCE ",61310,66519.524999999994,5543.2937499999998,64325,64759.09]
["EMPLOYEE BENEFITS",52990,49330,4110.833333333333,37299.919999999998,27974.94]
["WORKMAN'S COMPENSATION",5290,5110,425.83333333333337,8736.52,6552.3899999999994]
["EMPLOYEE COMPENSATION",5290,5110,425.83333333333337,0,0]
["BAD DEBT LOSS",5800,5040,420,4040.4933333333333,3055.87]
["LOSS ON DISPOSAL FIXED ASSET",5600,6190,515.83333333333326,4646.8266666666659,3485.12]
["DEPRECIATION",338260,332520,27709.999999999996,328251.31999999995,245471.45999999996]
["OTHER INTEREST PAID",100,20,1.6666666666666667,0,0]
["TOTAL GENERAL EXPENSE",488170,482429.52500000002,40202.460416666661,459242.72,360255.85]
[]
["FINANCING",null,null,null," "]
["INTEREST ON MORTGAGE      ",147350,129850,10820.833333333332,175188.12,124184.65]
["MORTGAGE      ",456740,452300,37691.666666666672,428896.48,377288]
["TOTAL FINANCING",604090,582150,48512.5,604084.6,501472.65]
[null,null,null,null," "]
["RESERVES",null,null,null," "]
["REPLACEMENT RESERVES",45000,49200,4100,45000,33750]
["TOTAL RESERVES",45000,49200,4100,45000,33750]
[null,null,null,null," "]
["CAPITAL EXPENDITURES",null,null,null," "]
["LAND & IMPROVEMENTS",15000,5000,416.66666666666669,0,0]
["BUILDING",0,0,0,0,0]
["BUILDING IMPROVEMENTS",14500,0,0,0,17774]
["BLDG EQUIPT FIXED",23870,61980,5165.0000000000009,12232,17472]
["BLDG. EQUIP. PORTABLE",0,0,0,1800,0]
["FURNISHINGS",0,0,0,0,0]
["MISC. FIXED ASSETS",2500,0,0,6618,6617.85]
["TOTAL CAPITAL EXP.",55870,66980,5581.6666666666679,20650,41863.85]
[null,null,null,null," "]
["TOTAL EXPENDITURES",2013930,2089319.6993999998,175304.97494999997,1914976.8733333335,1530503.9200000002]
[null," "," "," "," "," "]
["NET INCOME (LOSS)",-380030,-263700.69939999981,-23170.058283333317,-261087.23333333363,-298229.95000000019]
[]
["DEPRECIATION INCLUDED ABOVE",338260,332520,27709.999999999996,328251.31999999995,245471.45999999996]
[]
["NET INCOME(LOSS) AFTER DEPRECIATION",-41770,68819.300600000191,4539.941716666679,67164.086666666321,-52758.490000000224]

{"sheet":"Orchard Valley","index":2,"n_rows":111,"n_cols":7,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"JEFFCO HOUSING CORPORATION"]
[null,null,"ORCHARD VALLEY APARTMENTS",null,null,null,"On 09/30/2016  Replacement Reserves       $87,863.28"]
[null,null,"FY 2017 OPERATING BUDGET",null,null,null,"                       Residual Receipts Reserve  $58,837.34"]
[null,null,null,null,null,null,"                       Together total                   $146,700.62"]
[null,"Budget","Budget","Budget",null,"Actual","32 Units"]
[null,null,null,null,null,"YTD ","3% increase over 12/31/2016 potential estimate"]
[null,"FY 2016","FY 2017","FY 2017","FY 2016","FY 2016","unless otherwise noted                                                            "]
[null,"ANNUAL","ANNUAL","Monthly","12MO Estimate","at 9/30/16","Mortgage Ends July 2018"]
["OPERATING RECEIPTS"]
["RENTAL INCOME",293100,341710,{"$f":"C13/12","v":28475.833333333332},317580,234150,"proposed increases (aprox. 7.6% )"]
[]
["VACANCIES",-5860,-6480,-540,{"$f":"F15/9*12","v":-2443.3333333333335},-1832.5,"2% of Rental Income"]
["TRANSFER FROM RESERVES",0,25000,2083.3333333333335,0,0,"Transfer to cover cost of boiler."]
["INTEREST INCOME",30,30,2.5,{"$f":"F17/9*12","v":29.333333333333336},22]
["LAUNDRY INCOME( Laundry)",1200,1600,133.33333333333334,1605.3333333333333,1204,"Based on projected 12/31/2016 "]
["NSF & LATE CHARGES",200,100,8.3333333333333339,24,18,"Rents collected in a more timely basis - reduced amount of late fees"]
["OTHER INCOME",80,15080,1256.6666666666667,678.32,508.74,"Grant Award for CHDO Admin  & collections from Jeffco"]
["GRANT INCOME",0,25000,{"$f":"C21/12","v":2083.3333333333335},{"$f":"F21/9*12","v":0},0,"Grant Award for CHDO Operating Funds  from CDOH"]
["TOTAL OPERATING RECEIPTS",{"$f":"SUM(B13:B21)","v":288750},{"$f":"SUM(C13:C21)","v":402040},33503.333333333328,317473.65333333332,234070.24]
[]
["OPERATING EXPENDITURES"]
["ADMINISTRATIVE",{"$f":"B50","v":34700},{"$f":"C50","v":78070},{"$f":"D50","v":6505.8333333333339},{"$f":"E50","v":35333.213333333333},{"$f":"F50","v":26784.91}]
["OPERATING",{"$f":"B57","v":44730},{"$f":"C57","v":44430},{"$f":"D57","v":3702.5},{"$f":"E57","v":42477.693333333336},{"$f":"F57","v":31858.269999999997}]
["MAINTENANCE",{"$f":"B72","v":65830},{"$f":"C72","v":77660},{"$f":"D72","v":6471.666666666667},{"$f":"E72","v":71375.346666666679},{"$f":"F72","v":53531.509999999995}]
["GENERAL",{"$f":"B84","v":89680},{"$f":"C84","v":90590},{"$f":"D84","v":7549.1666666666661},{"$f":"E84","v":85910.546666666662},{"$f":"F84","v":68530.28}]
["FINANCING",{"$f":"B89","v":108800},{"$f":"C89","v":108800},{"$f":"D89","v":9066.6666666666661},{"$f":"E89","v":108800},{"$f":"F89","v":90667.099999999991}]
["RESERVES",{"$f":"B93","v":4800},{"$f":"C93","v":4800},{"$f":"D93","v":400},{"$f":"E93","v":4800},{"$f":"F93","v":3600}]
["CAPITAL EXPENSE",{"$f":"B103","v":3000},{"$f":"C103","v":25000},{"$f":"D103","v":2083.3333333333335},{"$f":"E103","v":0},{"$f":"F103","v":0}]
["TOTAL OPERATING EXPENSE",{"$f":"SUM(B25:B31)","v":351540},{"$f":"SUM(C25:C31)","v":429350},{"$f":"SUM(D25:D31)","v":35779.166666666664},{"$f":"SUM(E25:E31)","v":348696.80000000005},{"$f":"SUM(F25:F31)","v":274972.06999999995}]
["NET INCOME (LOSS)",{"$f":"SUM(B22-B32)","v":-62790},{"$f":"SUM(C22-C32)","v":-27310},{"$f":"SUM(D22-D32)","v":-2275.8333333333358},{"$f":"SUM(E22-E32)","v":-31223.146666666726},{"$f":"SUM(F22-F32)","v":-40901.829999999958}]
[]
[]
["ADMINISTRATIVE EXPENDITURES"]
["OFFICE SALARIES",10590,13050,{"$f":"C37/12","v":1087.5},{"$f":"F37/9*12","v":12672},9504]
["CONTRACT - DIRECTOR",0,25000,{"$f":"C38/12","v":2083.3333333333335},{"$f":"F38/9*12","v":0},0,"Grant stipulates Salary Wages Benefits only "]
["CONTRACT EXPENSES",0,15000,1250,27.733333333333334,20.8,"Operating Funds to support admin to acquire & rehab site for affodable housing - Paid to JHC"]
["OFFICE SUPPLIES",250,260,{"$f":"C40/12","v":21.666666666666668},{"$f":"F40/9*12","v":254.49333333333334},190.87]
["DUES & MTG EXPENSE",110,110,9.1666666666666661,{"$f":"F41/9*12","v":97.946666666666658},73.459999999999994]
["CLIENT VERFICATION SERVICES",60,150,{"$f":"C42/12","v":12.5},{"$f":"F42/9*12","v":147.20000000000002},110.4]
["MANAGEMENT FEE",14440,16850,1404.1666666666667,15603.226666666666,11702.42,"5% of total income minus interest & Grants & Transfers from Reserves"]
["LEGAL",420,430,35.833333333333336,0,0,"One legal $245 + $50 & one sheriff fee $135"]
["ACCOUNTING/AUDIT",3590,3290,274.16666666666669,3190,2677.5]
["TELEPHONE",1260,1420,118.33333333333333,1256.5066666666667,942.38,"Increase for tablets"]
["COMPUTER EXPENSES",1680,160,13.333333333333334,156.30666666666667,117.23]
["MISC. ADMIN. EXPENSE",1350,1420,118.33333333333333,1024.2666666666667,768.2]
["TRAVEL & TRAINING",950,930,77.5,903.5333333333333,677.65]
["TOTAL ADMINISTRATIVE",{"$f":"SUM(B37:B49)","v":34700},{"$f":"SUM(C37:C49)","v":78070},{"$f":"SUM(D37:D49)","v":6505.8333333333339},{"$f":"SUM(E37:E49)","v":35333.213333333333},{"$f":"SUM(F37:F49)","v":26784.91}]
[null,null,null,null," "]
["OPERATING EXPENDITURES",null,null,null," "]
["ELECTRIC",21840,20280,{"$f":"C53/12","v":1690},{"$f":"F53/9*12","v":19691.706666666669},14768.78,0.03]
["WATER",7230,11270,{"$f":"C54/12","v":939.16666666666663},10434,7825.5,"8%"]
["GAS",12330,9520,{"$f":"C55/12","v":793.33333333333337},9151.9866666666676,6863.99,"4%"]
["SEWER",3330,{"$f":"E56+E56*5%","v":3360},{"$f":"C56/12","v":280},3200,2400,"5% - Billed Quarterly   "]
["TOTAL OPERATING",{"$f":"SUM(B53:B56)","v":44730},{"$f":"SUM(C53:C56)","v":44430},{"$f":"SUM(D53:D56)","v":3702.5},{"$f":"SUM(E53:E56)","v":42477.693333333336},{"$f":"SUM(F53:F56)","v":31858.269999999997}]
[]
["MAINTENANCE EXPENDITURES"]
["JANITORIAL CONTRACT & SUPPLY",2580,1900,{"$f":"C60/12","v":158.33333333333334},{"$f":"F60/9*12","v":1838.6666666666667},1379,"3% & Clean Laundry Rooms $100month($1200yr)  - $1300 for turnovers"]
["EXTERMINATING CONTRACT",1080,2230,185.83333333333334,1101.3333333333333,826,"Contract $169 mo $2028. year plus $200 for extra services."]
["TRASH REMOVAL",2010,1980,165,1906.2133333333336,1429.66,"4%"]
["GROUNDS CONTRACT & SUPPLIES",5560,5870,489.16666666666669,9240,6930,"3% +$130 week April-Oct (30wks=$3900.) +$800 Sprinkler & $1000 add cleanup(trees/shrubs)."]
["REPAIR MATERIALS",13000,14930,1244.1666666666667,14494.96,10871.22,"3%                          2017 items  $2100. Lighting, $200 Dumster Gates ,&2 Laundry room floors $2500. "]
["REPAIR CONTRACT COSTS",15000,13850,1154.1666666666667,13439.773333333334,10079.83,"3%                          2017 $7500.Paint 2 blds,          "]
["CARPET & VINYL/PLANK",8000,8000,{"$f":"C66/12","v":666.66666666666663},{"$f":"F66/9*12","v":17487.733333333334},13115.8,"2 units plank @ $4000.00 ea  "]
["APPLIANCES ",2880,8780,731.66666666666663,1697.3333333333335,1273,"2 Refrigerators ($600.ea), 2 Ranges ($475 ea), 2 Dishwashers ($385ea)  4Washer/4Dryer@$700 ea($5600)"]
["REPAIR PAYROLL",11370,8260,688.33333333333337,8022.6666666666661,6017]
["SNOW REMOVAL",4350,3860,321.66666666666669,2146.6666666666665,1610,"                6 yr average x 10 snow days"]
["CABINETS & FURNITURE",0,0,{"$f":"C70/12","v":0},{"$f":"F70/9*12","v":0},0]
["SECURITY",0,8000,666.66666666666663,0,0,"Estimate for Cameras"]
["TOTAL MAINTENANCE",{"$f":"SUM(B60:B71)","v":65830},{"$f":"SUM(C60:C71)","v":77660},{"$f":"SUM(D60:D71)","v":6471.666666666667},71375.346666666679,53531.509999999995]
[]
["GENERAL",null,null,null," "]
["PAYROLL TAXES",1680,1630,{"$f":"C75/12","v":135.83333333333334},{"$f":"F75/9*12","v":1569.5200000000002},1177.1400000000001,"7.65% of Payroll    "]
["PROP & LIAB. INSURANCE ",10100,11060,921.66666666666663,10743,10743,"3.5% for General Liability No Increase in Property Liability"]
["EMPLOYEE BENEFITS",6590,6390,532.5,4970.68,3728.01,"30.% of payroll - Health, Dental, CCOERA"]
["WORKMAN'S COMPENSATION",660,820,68.333333333333329,793.98666666666668,595.49,"3.% of payroll "]
["EMPLOYEE COMPENSATION",660,820,68.333333333333329,0,0,"3.% of payroll "]
["BAD DEBT LOSS",500,790,65.833333333333329,766,766,"Estimate"]
["LOSS ON DISPOSAL FIXED ASSET",1230,820,{"$f":"C81/12","v":68.333333333333329},797.3599999999999,598.02,"Estimate"]
["DEPRECIATION",68260,68260,5688.333333333333,66270,50922.62]
[]
["TOTAL GENERAL EXPENSE",{"$f":"SUM(B75:B82)","v":89680},{"$f":"SUM(C75:C82)","v":90590},{"$f":"SUM(D75:D82)","v":7549.1666666666661},{"$f":"SUM(E75:E82)","v":85910.546666666662},{"$f":"SUM(F75:F82)","v":68530.28}]
[]
["FINANCING",null,null,null," "]
["INTEREST ON MORTGAGE      ",11890,11890,{"$f":"C87/12","v":990.83333333333337},11890,10278.870000000001,"Amortization Schedule     "]
["MORTGAGE      ",96910,96910,{"$f":"C88/12","v":8075.833333333333},96910,80388.23]
["TOTAL FINANCING",{"$f":"SUM(B87:B88)","v":108800},{"$f":"SUM(C87:C88)","v":108800},{"$f":"SUM(D87:D88)","v":9066.6666666666661},{"$f":"SUM(E87:E88)","v":108800},{"$f":"SUM(F87:F88)","v":90667.099999999991}]
[null,null,null,null," "]
["RESERVES",null,null,null," "]
["REPLACEMENT RESERVES",4800,4800,{"$f":"C92/12","v":400},{"$f":"F92/9*12","v":4800},3600]
["TOTAL RESERVES",{"$f":"B92","v":4800},{"$f":"C92","v":4800},{"$f":"D92","v":400},{"$f":"SUM(E92)","v":4800},{"$f":"SUM(F92)","v":3600}]
[null,null,null,null," "]
["CAPITAL EXPENDITURES",null,null,null," "]
["LAND & IMPROVEMENTS",{"$f":"SUM(D96*12*1.03)","v":0},0,{"$f":"C96/12","v":0},{"$f":"F96/9*12","v":0},0]
["BUILDING",0,0,{"$f":"C97/12","v":0},0,0]
["BUILDING IMPROVEMENTS",0,0,{"$f":"C98/12","v":0},0,0]
["BLDG EQUIPT FIXED",3000,25000,2083.3333333333335,0,0,"Boiler"]
["BLDG. EQUIP. PORTABLE",0,0,0,0,0]
["FURNISHINGS",0,0,0,0,0]
["MISC. FIXED ASSETS",0,0,0,0,0]
["TOTAL CAPITAL EXP.",{"$f":"SUM(B96:B102)","v":3000},{"$f":"SUM(C96:C102)","v":25000},2083.3333333333335,0,0]
[null,null,null,null," "]
["TOTAL EXPENDITURES",{"$f":"SUM(B103+B93+B89+B84+B72+B57+B50)","v":351540},{"$f":"SUM(C103+C93+C89+C84+C72+C57+C50)","v":429350},{"$f":"SUM(D103+D93+D89+D84+D72+D57+D50)","v":35779.166666666664},{"$f":"SUM(E103+E93+E89+E84+E72+E57+E50)","v":348696.8},{"$f":"SUM(F103+F93+F89+F84+F72+F57+F50)","v":274972.07}]
[null," "," ",null," "]
["NET INCOME (LOSS)",{"$f":"SUM(B22-B105)","v":-62790},{"$f":"SUM(C22-C105)","v":-27310},{"$f":"SUM(D22-D105)","v":-2275.8333333333358},{"$f":"SUM(E22-E105)","v":-31223.146666666667},{"$f":"SUM(F22-F105)","v":-40901.830000000016}]
[]
["DEPRECIATION INCLUDED ABOVE",68260,68260,5688,66270,50923]
[]
["NET INCOME(LOSS) AFTER DEPRECIATION",{"$f":"B107+B109","v":5470},{"$f":"C107+C109","v":40950},3412.1666666666642,35046.853333333333,10021.169999999984]

{"sheet":"UPHAM","index":3,"n_rows":111,"n_cols":9,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"JEFFCO HOUSING CORPORATION"]
[]
[null,"UPHAM STREET APTS.  & RESPITE HOME"]
[null,"FY 2017 OPERATING BUDGET",null,null,null,null,"Respite","Upham","On 9/30/2016  Upham  Replacement Reserves $90,526.03"]
[null,null,null,null,null,"Combined","Actual","Actual","14 Units"]
[null,"Budget","Budget","Budget",null,"YTD ","YTD ","YTD ","3% increase over 12/31/2016 potential estimate"]
[null,"FY 2016","FY 2017","FY 2017","FY 2016","FY 2016","FY 2016","FY 2016","unless otherwise noted"]
[null,"ANNUAL","ANNUAL","Monthly","12MO Estimate","at 9/30/16","at 9/30/16","at 9/30/16","Mortgage paid off 2009"]
["OPERATING RECEIPTS"]
["RENTAL INCOME-UPHAM",108600,116300,{"$f":"C13/12","v":9691.6666666666661},{"$f":"F13/9*12","v":108600},{"$f":"G13+H13","v":81450},0,81450,"Upham extimate 7% increase proposed changes"]
[]
["LESS: VACANCIES UPHAM",-1800,-1740,-145,0,{"$f":"G15+H15","v":0},0,0,"1.5% Estimate based on lower vacancies in 2016"]
["RENTAL INCOME-RESPITE",13200,14400,1200,14300,10700,10700,0,"No Increase"]
["INTEREST ",20,20,1.6666666666666667,19.28,14.46,0,14.46]
["LAUNDRY INCOME - UPHAM",2780,3000,250,3079.3066666666664,2309.48,0,2309.48]
["NSF & LATE FEES",170,50,4.166666666666667,54.666666666666664,41,0,41]
["OTHER INCOME",360,750,62.5,750,289.83,57.96,231.87," Collections and approximately $700.00 from City of Wheat Ridge-shared water costs"]
[]
["TOTAL OPERATING RECEIPTS",{"$f":"SUM(B13:B21)","v":123330},132780,11064.999999999998,126803.25333333334,94804.77,10757.96,84046.81]
[]
["OPERATING EXPENDITURES"]
["ADMINISTRATIVE",{"$f":"B50","v":24460},{"$f":"C50","v":25719.666799999999},{"$f":"D50","v":2143.3055666666664},{"$f":"E50","v":23495.439999999999},{"$f":"F50","v":17756.580000000002},7.67,{"$f":"H50","v":17748.91}]
["OPERATING",{"$f":"B57","v":15020},{"$f":"C57","v":17690},{"$f":"D57","v":1474.1666666666667},{"$f":"E57","v":18420.64},{"$f":"F57","v":13124.2},893.01,{"$f":"H57","v":12231.19}]
["MAINTENANCE",{"$f":"B72","v":47740},{"$f":"C72","v":51179.626666666663},{"$f":"D72","v":4264.9688888888886},{"$f":"E72","v":26234.28},{"$f":"F72","v":19675.71},264.67,{"$f":"H72","v":19411.04}]
["GENERAL",{"$f":"B84","v":48300},{"$f":"C84","v":46700},{"$f":"D84","v":3891.666666666667},{"$f":"E84","v":42861.066666666666},{"$f":"F84","v":33396.39},4163.0199999999995,{"$f":"H84","v":29233.37}]
["FINANCING",{"$f":"B89","v":0},{"$f":"C89","v":0},{"$f":"D89","v":0},{"$f":"E89","v":0},{"$f":"F89","v":0},0,{"$f":"H89","v":0}]
["RESERVES",{"$f":"B93","v":4800},{"$f":"C93","v":5400},{"$f":"D93","v":450},{"$f":"E93","v":4800},{"$f":"F93","v":3600},0,{"$f":"H93","v":3600}]
["CAPITAL EXPENSE",{"$f":"B103","v":0},{"$f":"C103","v":0},{"$f":"D103","v":0},{"$f":"E103","v":0},{"$f":"F103","v":0},0,{"$f":"H103","v":0}]
["TOTAL OPERATING EXPENSE",{"$f":"SUM(B25:B31)","v":140320},{"$f":"SUM(C25:C31)","v":146689.29346666666},{"$f":"SUM(D25:D31)","v":12224.107788888889},{"$f":"SUM(E25:E31)","v":115811.42666666667},{"$f":"SUM(F25:F31)","v":87552.88},5328.369999999999,{"$f":"SUM(H25:H31)","v":82224.509999999995}]
["NET INCOME (LOSS)",{"$f":"SUM(B22-B32)","v":-16990},{"$f":"SUM(C22-C32)","v":-13909.293466666655},{"$f":"SUM(D22-D32)","v":-1159.1077888888904},{"$f":"SUM(E22-E32)","v":10991.826666666675},{"$f":"SUM(F22-F32)","v":7251.8899999999994},5429.59,{"$f":"SUM(H22-H32)","v":1822.3000000000029}]
[]
[]
["ADMINISTRATIVE EXPENDITURES"]
["OFFICE SALARIES",13770,14070,{"$f":"C37/12","v":1172.5},{"$f":"F37/9*12","v":13656},{"$f":"G37+H37","v":10242},0,10242]
[]
[]
["OFFICE SUPPLIES",120,{"$f":"E40+E40*3%","v":209.66679999999997},{"$f":"C40/12","v":17.472233333333332},203.55999999999997,152.66999999999999,7.67,145,"$110.00 Upham $10.00 Respite  New - Respite 20.00 & Upham $190.00"]
["DUES & MTG EXPENSE",50,120,10,120,90,0,90,"                                    contains CPM dues for Mike Hunter"]
["CLIENT VERIFICATION SERV.",0,100,8.3333333333333339,0,0,0,0,"Estimate"]
["MANAGEMENT FEE",5500,6620,551.66666666666663,5602.1333333333341,4201.6000000000004,0,4201.6000000000004,"Based on 5% of total income minus interest   UPHAM Only"]
["LEGAL",420,430,35.833333333333336,0,0,0,0,"One legal $245 + $50 & one sheriff fee $135"]
["ACCOUNTING/AUDIT",1760,1550,129.16666666666666,1500,1260,0,1260]
["TELEPHONE",300,500,41.666666666666664,367.6,275.7,0,275.7,"increase for tablets"]
["COMPUTER EXPENSE",560,120,10,111.44,83.58,0,83.58]
["MISC. ADMIN. EXPENSE",820,960,80,926.66666666666674,695,0,695]
["TRAVEL & TRAINING",1160,1040,86.666666666666671,1008.04,756.03,0,756.03]
["TOTAL ADMINISTRATIVE",{"$f":"SUM(B37:B49)","v":24460},25719.666799999999,2143.3055666666664,23495.439999999999,17756.580000000002,7.67,17748.91]
[null," "," "," "]
["OPERATING EXPENDITURES"," "," "," "]
["ELECTRIC",1450,1170,{"$f":"C53/12","v":97.5},{"$f":"F53/9*12","v":1134.7333333333331},{"$f":"G53+H53","v":851.05},0,851.05,"3.0% all Upham           Respite billed to Tenant"]
["WATER",5890,10150,{"$f":"C54/12","v":845.83333333333337},10150,7048.72,719.01,6329.71,"8%              $9115.00 Upham    $1035.00 Respite"]
["GAS",4970,3630,{"$f":"C55/12","v":302.5},3485.9066666666668,2614.4299999999998,0,2614.4299999999998,"4%   all Upham            Respite billed to Tenant"]
["SEWER",2710,2740,{"$f":"C56/12","v":228.33333333333334},3650,2610,174,2436,"5% - Annual     $3410.00 Upham     $240.00 Respite"]
["TOTAL OPERATING",{"$f":"SUM(B53:B56)","v":15020},{"$f":"SUM(C53:C56)","v":17690},{"$f":"SUM(D53:D56)","v":1474.1666666666667},{"$f":"SUM(E53:E56)","v":18420.64},{"$f":"SUM(F53:F56)","v":13124.2},893.01,{"$f":"SUM(H53:H56)","v":12231.19}]
[]
["MAINTENANCE EXPENDITURES"]
["JANITORIAL CONTRACT & SUPPLIES",1130,850,{"$f":"C60/12","v":70.833333333333329},{"$f":"F60/9*12","v":820},{"$f":"G60+H60","v":615},0,615]
["EXTERMINATION CONTRACT",1080,1390,115.83333333333333,761.33333333333326,571,0,571,"Contract $99 mo $1188. year plus $200 for extra services."]
["TRASH REMOVAL",1280,1220,101.66666666666667,1318.32,988.74,0,988.74,"4% & Contract $109.86 month ($1318.yr) "]
["GROUNDS CONTRACT",4270,4020,335,3186.6666666666665,2390,75,2315,"3% + 2016 rate of $95. wk April-Oct(30wks=$2850.)+$350 trim junipers $450 cleanup & $250.00 Respite"]
["REPAIR MATERIALS",5460,5270,439.16666666666669,5114.4533333333329,3835.84,5.67,3830.17,"3%   and    $100.00 Respite"]
["REPAIR CONTRACT ",14090,19650,1637.5,4634.666666666667,3476,184,3292,"3% + Steps $5k & Ext Paint $10k, Doors $1k. Alsphalt $1k Mailbox $1.2k & $880.00 Respite "]
["CARPET & VINYL/PLANK",4800,2500,208.33333333333334,486.84000000000003,365.13,0,365.13,"2 units carpet / vinyl  $1250 each "]
["APPLIANCES ",3100,6100,508.33333333333331,713.33333333333326,535,0,535,"2 Refridge $600 ea & 3 Ranges @$500 ea & 2 Wash/ 2 Dry $2,800 + $600 Respite dishwasher"]
["REPAIR PAYROLL",11000,{"$f":"E68+E68*3%","v":7929.6266666666661},660.80222222222221,7698.6666666666661,5774,0,5774]
["SNOW REMOVAL",1530,2250,187.5,1500,1125,0,1125,"based on  average $225 per snow x 10 incidents  "]
["CABINETS & FURNITURE",0,0,{"$f":"C70/12","v":0},0,0,0,0]
["SECURITY",0,0,{"$f":"C71/12","v":0},{"$f":"F71/9*12","v":0},0,0,0]
["TOTAL MAINTENANCE",{"$f":"SUM(B60:B71)","v":47740},{"$f":"SUM(C60:C71)","v":51179.626666666663},4264.9688888888886,26234.28,19675.71,264.67,19411.04]
[]
["GENERAL"]
["PAYROLL TAXES",1900,1680,{"$f":"C75/12","v":140},{"$f":"F75/9*12","v":1867.4933333333333},{"$f":"G75+H75","v":1400.62},0,1400.62,"7.65% of Payroll    "]
["PROP & LIABILITY INSURANCE",4220,5180,{"$f":"C76/12","v":431.66666666666669},5001,5001.34,305.95999999999998,4695.38,"3.5% for General Liability = $4860.Upham & $320. Respite    No Increase in Property Liability"]
["EMP BENEFITS",7430,6600,550,5799.8933333333334,4349.92,0,4349.92,"30.% of payroll - Health, Dental, CCOERA"]
["WORKMENS COMPENSATION",740,660,55,793.98666666666668,595.49,0,595.49,"3.% of payroll "]
["EMPLOYEE COMPENSATION",740,660,55,0,0,0,0,"3.% of payroll "]
["BAD DEBT LOSS",500,500,41.666666666666664,0,0,0,0,"esitmate"]
["LOSS ON DISPOSAL FIXED ASSET",1140,1140,{"$f":"C81/12","v":95},0,0,0,0,"esitmate  -  $1000.00 Upham   and  $140.00 Respite"]
["DEPRECIATION",31630,30280,2523.3333333333335,29398.693333333333,22049.02,3857.06,18191.96,"$26,370.00  Upham  and $5260.00 Respite"]
[]
["TOTAL GENERAL EXPENSE",{"$f":"SUM(B75:B82)","v":48300},{"$f":"SUM(C75:C82)","v":46700},3891.666666666667,42861.066666666666,{"$f":"SUM(F75:F82)","v":33396.39},4163.0199999999995,29233.37]
[]
["FINANCING"]
["MORTGAGE INTEREST",0,0,{"$f":"C87/12","v":0},{"$f":"H87/9","v":0},{"$f":"G87+H87","v":0},0,0]
["MORTGAGE PRINCIPAL",0,0,{"$f":"C88/12","v":0},{"$f":"H88/9","v":0},0,0,0]
["TOTAL FINANCING",{"$f":"SUM(B87:B88)","v":0},{"$f":"SUM(C87:C88)","v":0},{"$f":"SUM(D87:D88)","v":0},{"$f":"SUM(E87:E88)","v":0},{"$f":"SUM(F87:F88)","v":0},0,{"$f":"SUM(H87:H88)","v":0},"No Mortgage"]
[null," "," "," "]
["RESERVES"," "," "," "]
["REPLACEMENT RESERVES",4800,5400,{"$f":"C92/12","v":450},{"$f":"F92/9*12","v":4800},{"$f":"G92+H92","v":3600},0,3600,"Increase due to age of building"]
["TOTAL RESERVES",{"$f":"B92","v":4800},{"$f":"C92","v":5400},{"$f":"D92","v":450},{"$f":"E92","v":4800},{"$f":"F92","v":3600},0,{"$f":"H92","v":3600}]
[null," "," "," "]
["CAPITAL EXPENDITURES"," "," "," "]
["LAND & IMPROVEMENTS",0,0,{"$f":"C96/12","v":0},{"$f":"F96/9*12","v":0},{"$f":"G96+H96","v":0},0,0]
["BUILDING",0,0,0,0,0,0,0]
["BUILDING IMPROVEMENTS",0,0,{"$f":"C98/12","v":0},0,0,0,0]
["BLDG. EQUIP. FIXED",0,0,0,0,0,0,0]
["BLDG. EQUIP. PORTABLE",0,0,0,0,0,0,0]
["FURNISHINGS",0,0,0,0,0,0,0]
["MISC. FIXED ASSETS",0,0,0,0,0,0,0]
["TOTAL CAPITAL EXP.",{"$f":"SUM(B96:B102)","v":0},{"$f":"SUM(C96:C102)","v":0},{"$f":"SUM(D96:D102)","v":0},{"$f":"SUM(E96:E102)","v":0},{"$f":"SUM(F96:F102)","v":0},0,{"$f":"SUM(H96:H102)","v":0}]
[]
["TOTAL EXPENDITURES",{"$f":"SUM(B103+B93+B89+B84+B72+B57+B50)","v":140320},146689.29346666666,12224.107788888889,115811.42666666667,87552.88,5328.37,82224.509999999995]
[]
["NET INCOME (LOSS)",{"$f":"SUM(B22-B105)","v":-16990},-13909.293466666655,-1159.1077888888904,10991.826666666675,7251.8899999999994,5429.5899999999992,1822.3000000000029]
[]
["DEPRECIATION INCLUDED ABOVE",{"$f":"B82","v":31630},30280,2523.3333333333335,29398.693333333333,22049.02,3857.06,18191.96]
[]
["NET INCOME(LOSS) AFTER DEPRECIATION",{"$f":"B107+B109","v":14640},{"$f":"C107+C109","v":16370.706533333345},1364.2255444444431,40390.520000000004,29300.91,{"$f":"G107+G109","v":9286.65},20014.260000000002]

{"sheet":"west 40","index":4,"n_rows":111,"n_cols":7,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"JEFFCO HOUSING CORPORATION"]
[null,"WEST 40th"]
[null,"FY 2017 OPERATING BUDGET"]
[null,null,null,null,null,null,"On 9/30/2016  Replacement Reserves $62,318.26"]
[null,null,null,null,null,"Actual","8 Units"]
[null,"Budget","Budget","Budget",null,"YTD ","3% increase over 12/31/2016 potential estimate"]
[null,"FY 2016","FY 2017","FY 2017","FY 2016","FY 2016","unless otherwise noted"]
[null,"ANNUAL","ANNUAL","Monthly","12MO Estimate","at 9/30/16","Mortgage Ends July 2018"]
["OPERATING RECEIPTS"]
["RENTAL INCOME",67800,74800,{"$f":"C13/12","v":6233.333333333333},{"$f":"F13/9*12","v":70100},52575,"proposed increases (aprox. 6.7% )"]
[]
["VACANCIES",-1350,-1500,-125,-2527.5466666666666,-1895.66,"2% of Rental Income"]
["TRANSFER FROM RESERVES",8000,16500,1375,0,0,"Transfer  for Doors $8500.  Swamp Coolers $4600. Water Heater $3000."]
["INTEREST INCOME",20,20,1.6666666666666667,13.333333333333334,10]
["LAUNDRY INCOME",740,600,50,508,381]
["NSF / LATE  CHARGES",{"$f":"SUM(D19*1.03)","v":0},0,0,0,0]
["OTHER INCOME",20,20,1.6666666666666667,154.66666666666669,116,"Estimate"]
[]
["TOTAL OPERATING RECEIPTS",{"$f":"SUM(B13:B21)","v":75230},90440,7536.666666666667,68248.453333333338,{"$f":"SUM(F13:F21)","v":51186.34}]
[]
["OPERATING EXPENDITURES"]
["ADMINISTRATIVE",{"$f":"B50","v":6440},{"$f":"C50","v":6490.3601333333336},{"$f":"D50","v":540.86334444444446},{"$f":"E50","v":5654.16},{"$f":"F50","v":4195.6200000000008}]
["OPERATING",{"$f":"B57","v":8070},{"$f":"C57","v":7140},{"$f":"D57","v":595},{"$f":"E57","v":6778.8933333333334},{"$f":"F57","v":5432.17}]
["MAINTENANCE",{"$f":"B72","v":33450},{"$f":"C72","v":46030.103466666667},{"$f":"D72","v":3835.8419555555552},{"$f":"E72","v":29072.960000000003},{"$f":"F72","v":21804.720000000001}]
["GENERAL",{"$f":"B84","v":18740},{"$f":"C84","v":18840},{"$f":"D84","v":1570},{"$f":"E84","v":16511.439999999999},{"$f":"F84","v":13054.830000000002}]
["FINANCING",{"$f":"B89","v":23100},{"$f":"C89","v":23100},{"$f":"D89","v":1925},{"$f":"E89","v":23094.600000000002},{"$f":"F89","v":17320.95}]
["RESERVES",{"$f":"B92","v":3600},{"$f":"C92","v":3600},{"$f":"D92","v":300},{"$f":"E93","v":3600},{"$f":"F93","v":2700}]
["CAPITAL EXPENSE",{"$f":"B103","v":0},{"$f":"C103","v":3000},{"$f":"D103","v":250},{"$f":"E103","v":3000},{"$f":"F103","v":2250}]
["TOTAL OPERATING EXPENSE",{"$f":"SUM(B25:B31)","v":93400},{"$f":"SUM(C25:C31)","v":108200.4636},{"$f":"SUM(D25:D31)","v":9016.7052999999996},{"$f":"SUM(E25:E31)","v":87712.053333333344},{"$f":"SUM(F25:F31)","v":66758.290000000008}]
["NET INCOME (LOSS)",{"$f":"SUM(B22-B32)","v":-18170},{"$f":"SUM(C22-C32)","v":-17760.463600000003},{"$f":"SUM(D22-D32)","v":-1480.0386333333327},{"$f":"SUM(E22-E32)","v":-19463.600000000006},{"$f":"SUM(F22-F32)","v":-15571.950000000012}]
[]
[]
["ADMINISTRATIVE EXPENDITURES"]
["OFFICE SALARIES",{"$f":"SUM(D37*1.03)","v":0},{"$f":"E37+E37*3%","v":0},{"$f":"C37/12","v":0},{"$f":"F37/9*12","v":0},0]
[null,null,0]
[null,null,0]
["OFFICE SUPPLIES",100,150,12.5,144.66666666666666,108.5]
["DUES & MTG EXPENSE",30,30,2.5,25.773333333333333,19.329999999999998]
["CLIENT VERIFICATION SERV.",0,110,{"$f":"C42/12","v":9.1666666666666661},{"$f":"F42/9*12","v":100.93333333333334},75.7]
["MANAGEMENT FEE",3360,3690,307.5,3411.7333333333336,2558.8000000000002,"Based on 5% of total income minus interest & transfer from reserves"]
["LEGAL",420,430,35.833333333333336,0,0,"One legal $245 + $50 & one sheriff fee $135"]
["ACCOUNTING/AUDIT",950,930,77.5,900,630]
["TELEPHONE",120,200,16.666666666666668,147.05333333333334,110.29,"increase for tablets"]
["COMPUTER EXPENSE",560,50.36013333333333,4.1966777777777775,48.893333333333331,36.67]
["MISC. ADMIN. EXPENSE",570,560,46.666666666666664,546.05333333333328,409.54]
["TRAVEL & TRAINING",330,340,28.333333333333332,329.05333333333328,246.79]
["TOTAL ADMINISTRATIVE",{"$f":"SUM(B37:B49)","v":6440},{"$f":"SUM(C37:C49)","v":6490.3601333333336},{"$f":"SUM(D37:D49)","v":540.86334444444446},{"$f":"SUM(E37:E49)","v":5654.16},{"$f":"SUM(F37:F49)","v":4195.6200000000008}]
[null," "," "," "," "]
["OPERATING EXPENDITURES"," "," "," "," "]
["ELECTRIC",410,400,{"$f":"C53/12","v":33.333333333333336},{"$f":"F53/9*12","v":383.15999999999997},287.37,"3%"]
["WATER",2200,2060,171.66666666666666,1910.6133333333332,1432.96,"8%"]
["GAS",4010,3220,268.33333333333331,3093.12,2319.84,"4%"]
["SEWER",1450,1460,121.66666666666667,1392,1392,"5% - Annual"]
["TOTAL OPERATING",{"$f":"SUM(B53:B56)","v":8070},{"$f":"SUM(C53:C56)","v":7140},{"$f":"SUM(D53:D56)","v":595},{"$f":"SUM(E53:E56)","v":6778.8933333333334},{"$f":"SUM(F53:F56)","v":5432.17}]
[]
["MAINTENANCE EXPENDITURES"]
["JANITORIAL CONTRACT & SUPPLIES",740,850,{"$f":"C60/12","v":70.833333333333329},{"$f":"F60/9*12","v":820},615,"Laundry Cleaning $40 per month($480. started mid 2015) & unit ($260)"]
["EXTERMINATING CONTRACT",1500,1390,115.83333333333333,1604,1203,"Contract $99 mo $1188. year plus $200 for extra services."]
["TRASH REMOVAL",1250,{"$f":"E62+E62*4%","v":1400.1034666666667},116.67528888888889,1346.2533333333333,1009.69,"4% "]
["GROUNDS CONTRACT",3780,3690,307.5,3893.3333333333335,2920,"3%+ 2016 rate $75. week April-Oct (30wks=$2250.0.) + $1000. cleanup and maintenance & $300 sprinklers"]
["REPAIR MATERIALS",3300,13960,1163.3333333333333,3059.04,2294.2800000000002,"3% Paint Doors/chauk window $2000 & Replace Doors 17@500.ea (8500.00 "]
["REPAIR CONTRACT ",6100,5790,482.5,2619,1964.25,"3% Electrical work $1600. & Mailboxes $1100. & Restripe parking lot $300.00"]
["CARPET & VINYL/PLANK",2700,5250,437.5,5098.0400000000009,3823.53,"One unit carpet/vinyl or vinyl plank"]
["APPLIANCES ",4600,6300,525,3454.6266666666661,2590.9699999999998,"One Range $400.  One Fridge $600 & 4 Swamp Coolers @ $1,150. ea ($4,600)  & One Dryer $700"]
["REPAIR PAYROLL",7740,6060,{"$f":"C68/12","v":505},{"$f":"F68/9*12","v":5878.666666666667},4409]
["SNOW REMOVAL",1740,1340,111.66666666666667,1300,975,"                6 yr average x 10 snow days"]
["CABINETS & FURNITURE",0,0,0,0,0]
["SECURITY",0,0,0,0,0]
["TOTAL MAINTENANCE",{"$f":"SUM(B60:B71)","v":33450},{"$f":"SUM(C60:C71)","v":46030.103466666667},3835.8419555555552,29072.960000000003,21804.720000000001]
[null," "," "," "," "]
["GENERAL"," "," "," "," "]
["PAYROLL TAXES",590,460,{"$f":"C75/12","v":38.333333333333336},{"$f":"F75/9*12","v":57.226666666666674},42.92,"7.65% of Payroll    "]
["PROP & LIAB. INSURANCE ",2140,2770,230.83333333333334,2686,2685.75,"3.5% for General Liability No Increase in Property Liability"]
["EMPLOYEE BENEFITS",2320,1820,151.66666666666666,179.53333333333336,134.65,"30.% of payroll - Health, Dental, CCOERA"]
["WORKMAN'S COMPENSATION",230,180,15,793.98666666666668,595.49,"3.% of payroll "]
["EMPLOYEE COMPENSATIONS",230,180,15,0,0,"3.% of payroll "]
["BAD DEBT LOSS",50,50,4.166666666666667,0,0]
["LOSS ON DISPOSAL FIXED ASSET",300,480,40,460.88,345.66,"estimate"]
["DEPRECIATION",12880,12900,1075,12333.813333333334,9250.36]
[]
["TOTAL GENERAL EXPENSE",{"$f":"SUM(B75:B83)","v":18740},{"$f":"SUM(C75:C83)","v":18840},{"$f":"SUM(D75:D83)","v":1570},16511.439999999999,13054.830000000002]
[]
["FINANCING"," "," "," "," "]
["INT ON MORTGAGE PAYABLE",2240,1080,{"$f":"C87/12","v":90},{"$f":"F87/9*12","v":2378.12},1783.59,"Amortization Schedule"]
["MORTGAGE      ",20860,22020,1835,20716.480000000003,15537.36]
["TOTAL FINANCING",{"$f":"SUM(B87:B88)","v":23100},{"$f":"SUM(C87:C88)","v":23100},{"$f":"SUM(D87:D88)","v":1925},{"$f":"SUM(E87:E88)","v":23094.600000000002},{"$f":"SUM(F87:F88)","v":17320.95}]
[null," "," "," "," "]
["RESERVES"," "," "," "," "]
["REPLACEMENT RESERVES",3600,3600,{"$f":"C92/12","v":300},{"$f":"F92/9*12","v":3600},2700]
["TOTAL RESERVES",{"$f":"B92","v":3600},{"$f":"C92","v":3600},{"$f":"D92","v":300},{"$f":"E92","v":3600},{"$f":"F92","v":2700}]
[null," "," "," "," "]
["CAPITAL EXPENDITURES"," "," "," "," "]
["LAND & IMPROVEMENTS",0,0,{"$f":"C96/12","v":0},{"$f":"F96/9*12","v":0},0]
["BUILDING  ",0,0,0,0,0]
["BUILDING IMPROVEMENTS",0,0,{"$f":"C98/12","v":0},0,0]
["BUILDING EQUIP FIXED",0,3000,250,3000,2250,"Water Heater"]
["BLDG. EQUIP. PORTABLE",0,0,0,0,0]
["FURNISHINGS",0,0,0,0,0]
["MISC. FIXED ASSETS",0,0,0,0,0,"                      "]
["TOTAL CAPITAL EXP.",{"$f":"SUM(B96:B102)","v":0},{"$f":"SUM(C96:C102)","v":3000},{"$f":"SUM(D96:D102)","v":250},{"$f":"SUM(E96:E102)","v":3000},{"$f":"SUM(F96:F102)","v":2250}]
[null,null,null,null," "]
["TOTAL EXPENDITURES",{"$f":"SUM(B103+B93+B89+B84+B72+B57+B50)","v":93400},{"$f":"SUM(C103+C93+C89+C84+C72+C57+C50)","v":108200.4636},{"$f":"SUM(D103+D93+D89+D84+D72+D57+D50)","v":9016.7052999999996},{"$f":"SUM(E103+E93+E89+E84+E72+E57+E50)","v":87712.053333333344},{"$f":"SUM(F103+F93+F89+F84+F72+F57+F50)","v":66758.289999999994}]
[null,null,null,null," "]
["NET INCOME (LOSS)",{"$f":"SUM(B22-B105)","v":-18170},{"$f":"SUM(C22-C105)","v":-17760.463600000003},{"$f":"SUM(D22-D105)","v":-1480.0386333333327},{"$f":"SUM(E22-E105)","v":-19463.600000000006},{"$f":"SUM(F22-F105)","v":-15571.949999999997}]
[]
["DEPRECIATION INCLUDED ABOVE",{"$f":"B82","v":12880},{"$f":"C82","v":12900},{"$f":"D82","v":1075},{"$f":"E82","v":12333.813333333334},{"$f":"F82","v":9250.36}]
[]
["NET INCOME(LOSS) AFTER DEPRECIATION",{"$f":"B107+B109","v":-5290},{"$f":"C107+C109","v":-4860.4636000000028},-405.03863333333265,-7129.7866666666723,-6321.5899999999965]

{"sheet":"WRP ","index":5,"n_rows":111,"n_cols":7,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"JEFFCO HOUSING CORPORATION"]
[null,"WHEAT RIDGE PARK"]
[null,"FY 2017 OPERATING BUDGET"]
[null,null,null,null,null,null,"On 9/30/2016    Replacement Reserves $50,887.61"]
[null,null,null,null,null,"Actual","20 Units "]
[null,"Budget","Budget","Budget",null,"YTD ","3% increase over 12/31/2016 potential estimate"]
[null,"FY 2016","FY 2017","FY 2017","FY 2016","FY 2016","unless otherwise noted"]
[null,"ANNUAL","ANNUAL","Monthly","12MO Estimate","at 9/30/16","Mortgage Ends June 2017"]
["OPERATING RECEIPTS"]
["RENTAL INCOME",159130,179580,{"$f":"C13/12","v":14965},{"$f":"F13/9*12","v":165088},123816,"proposed increases (aprox. 8.75% )"]
[]
["VACANCIES",-3180,-3590,-299.16666666666669,-2261.8666666666668,-1696.4,"2% of Rental Income"]
["TRANSFER FROM RESERVES",4000,0,0,0,0]
["INTEREST INCOME",10,10,0.83333333333333337,10.373333333333333,7.78,"Shared with 46th"]
["LAUNDRY INCOME",1730,2100,175,2036.7333333333331,1527.55]
["NSF / LATE  CHARGES",570,230,19.166666666666668,224,168]
["MISC INCOME",750,400,33.333333333333336,700.44,525.33000000000004,"Estimate"]
[]
["TOTAL OPERATING RECEIPTS",{"$f":"SUM(B13:B21)","v":163010},{"$f":"SUM(C13:C21)","v":178730},{"$f":"SUM(D13:D21)","v":14894.166666666668},165797.68,124348.26000000001]
[]
["OPERATING EXPENDITURES"]
["ADMINISTRATIVE",{"$f":"B50","v":23440},{"$f":"C50","v":23840},{"$f":"D50","v":1986.6666666666665},{"$f":"E50","v":22182.506666666668},{"$f":"F50","v":16822.88}]
["OPERATING",{"$f":"B57","v":16010},{"$f":"C57","v":15160},{"$f":"D57","v":1263.3333333333335},{"$f":"E57","v":14386.626666666667},{"$f":"F57","v":11426.279999999999}]
["MAINTENANCE",{"$f":"B72","v":49660},{"$f":"C72","v":66390},{"$f":"D72","v":5532.4999999999991},{"$f":"E72","v":44444.586666666662},{"$f":"F72","v":33333.440000000002}]
["GENERAL",{"$f":"B84","v":52440},{"$f":"C84","v":52470},{"$f":"D84","v":4372.5},{"$f":"E84","v":51681.453333333331},{"$f":"F84","v":40251.710000000006}]
["FINANCING",{"$f":"B89","v":43310},{"$f":"C89","v":21370},{"$f":"D89","v":1780.8333333333335},{"$f":"E89","v":43310},{"$f":"F89","v":36092.5}]
["RESERVES",{"$f":"B92","v":4800},{"$f":"C92","v":4800},{"$f":"D92","v":400},{"$f":"E93","v":4800},{"$f":"F93","v":3600}]
["CAPITAL EXPENSE",{"$f":"B103","v":0},{"$f":"C103","v":0},{"$f":"D103","v":0},{"$f":"E103","v":0},{"$f":"F103","v":0}]
["TOTAL OPERATING EXPENSE",{"$f":"SUM(B25:B31)","v":189660},{"$f":"SUM(C25:C31)","v":184030},{"$f":"SUM(D25:D31)","v":15335.833333333334},{"$f":"SUM(E25:E31)","v":180805.17333333334},{"$f":"SUM(F25:F31)","v":141526.81}]
["NET INCOME (LOSS)",{"$f":"SUM(B22-B32)","v":-26650},{"$f":"SUM(C22-C32)","v":-5300},{"$f":"SUM(D22-D32)","v":-441.66666666666606},{"$f":"SUM(E22-E32)","v":-15007.493333333347},{"$f":"SUM(F22-F32)","v":-17178.549999999988}]
[]
[]
["ADMINISTRATIVE EXPENDITURES"]
["OFFICE SALARIES",9080,9220,{"$f":"C37/12","v":768.33333333333337},{"$f":"F37/9*12","v":8952.0133333333342},6714.01]
[]
[]
["OFFICE SUPPLIES",230,280,23.333333333333332,275.10666666666668,206.33]
["DUES & MTG EXPENSE",70,130,10.833333333333334,120,90,"                  Board Meetings & CPM dues -Mike Hunter"]
["CLIENT VERIFICATION SERVICES",70,180,15,{"$f":"F42/9*12","v":121.33333333333333},91]
["MANAGEMENT FEE",7950,8940,745,8289.3333333333339,6217,"Based on 5% of total income minus interest "]
["LEGAL",420,430,35.833333333333336,0,0,"One legal $245 + $50 & one sheriff fee $135"]
["ACCOUNTING/AUDIT",2370,2120,176.66666666666666,2062,1732.5]
["TELEPHONE",760,1000,83.333333333333329,873.45333333333338,655.09,"increase for tablets"]
["COMPUTER EXPENSE",1120,100,8.3333333333333339,92.426666666666662,69.319999999999993]
["MISC. ADMIN. EXPENSE",570,600,50,586.66666666666663,440,"                  Bank Fees & Maintenance t-shirts"]
["TRAVEL & TRAINING",800,840,70,810.1733333333334,607.63]
["TOTAL ADMINISTRATIVE",{"$f":"SUM(B37:B49)","v":23440},{"$f":"SUM(C37:C49)","v":23840},{"$f":"SUM(D37:D49)","v":1986.6666666666665},{"$f":"SUM(E37:E49)","v":22182.506666666668},{"$f":"SUM(F37:F49)","v":16822.88}]
[null," "," "," "," "]
["OPERATING EXPENDITURES"," "," "," "," "]
["ELECTRIC",3170,2020,{"$f":"C53/12","v":168.33333333333334},{"$f":"F53/9*12","v":1958.3999999999999},1468.8,"3%"]
["WATER",4410,4860,405,4500,3111.31,"8%"]
["GAS",4940,4500,375,4328.2266666666665,3246.17,"4%"]
["SEWER",3490,3780,315,3600,3600,"5%"]
["TOTAL OPERATING",{"$f":"SUM(B53:B56)","v":16010},{"$f":"SUM(C53:C56)","v":15160},{"$f":"SUM(D53:D56)","v":1263.3333333333335},{"$f":"SUM(E53:E56)","v":14386.626666666667},{"$f":"SUM(F53:F56)","v":11426.279999999999}]
[]
["MAINTENANCE EXPENDITURES"]
["JANITORIAL CONTRACT",1570,1650,{"$f":"C60/12","v":137.5},{"$f":"F60/9*12","v":1600},1200,"             Water Extraction, Carpet Cleaning,  Turnover,  "]
["EXTERMINATING CONTRACT",2520,2000,166.66666666666666,2000,1500,"New contract - $129 month (1548 yr) plus $450 for Extras...Wasps, snakes &spiders"]
["TRASH REMOVAL",2840,2970,247.5,2553.7200000000003,1915.29,"4% & Contract $212.81 m($2553.72.yr)- plus one rolloff $300"]
["GROUNDS CONTRACT",4360,8760,730,6073.333333333333,4555,"Lndscp$1,000 Irrigate $2000. & $120wk April-Oct (30wks=$3600)plus 1300cleanup 600sprinklers"]
["REPAIR MATERIALS",9580,10770,897.5,6578.4266666666663,4933.82,"3% & unit entry doors @$400 ea x 10 (4000.)"]
["REPAIR CONTRACT COSTS",11390,11360,946.66666666666663,11277.333333333334,8458,"3%& Boiler cleaning @$250 each ($750) & Ext. Paint/Vinyl $3000,minus $4k for 2016 plumbing issues"]
["CARPET & VINYL/PLANK",3000,3090,257.5,1932.44,1449.33,"2 units carpet/vinyl $1,350 each  and two entries $150. each"]
["APPLIANCES ",2160,6360,530,3326.666666666667,2495,"2 Refrigerator $500., 1 Range $465, 2 Dishwasher $345. & 3 Washers/3Dryers @$700 ea. ($4200)"]
["REPAIR PAYROLL",10660,8100,675,7842.6666666666661,5882]
["SNOW REMOVAL",1580,1330,110.83333333333333,1260,945,"                6 yr average x 10 snow days"]
["CABINETS & FURNITURE",0,6000,500,0,0,"2 units Cabinets $3000 per unit"]
["SECURITY",0,4000,{"$f":"C71/12","v":333.33333333333331},{"$f":"F71/9*12","v":0},0,"Camera System"]
["TOTAL MAINTENANCE",{"$f":"SUM(B60:B71)","v":49660},{"$f":"SUM(C60:C71)","v":66390},{"$f":"SUM(D60:D71)","v":5532.4999999999991},44444.586666666662,33333.440000000002]
[]
["GENERAL"," "," "," "," "]
["PAYROLL TAXES ",1510,1330,{"$f":"C75/12","v":110.83333333333333},{"$f":"F75/9*12","v":1314.3733333333332},985.78,"7.65% of Payroll    "]
["PROP & LIAB. INSURANCE ",11070,12900,1075,12461,12461.01,"3.5% for General Liability No Increase in Property Liability"]
["EMPLOYEE BENEFITS",5920,5200,433.33333333333331,4150.9066666666668,3113.18,"30.% of payroll - Health, Dental, CCOERA"]
["WORKMAN'S COMPENSATION",590,520,43.333333333333336,1589.3066666666668,1191.98,"3.% of payroll "]
["EMPLOYEE COMPENSATION",590,520,43.333333333333336,0,0,"3.% of payroll "]
["BAD DEBT LOSS",650,1000,83.333333333333329,1140,1139,"estimate"]
["LOSS ON DISPOSAL FIXED ASSET",1000,1000,83.333333333333329,825.86666666666667,619.4,"estimate"]
["DEPRECIATION",31110,30000,2500,30200,20741.36,"Lower due to appliances & carpet/vinyl taken out of service"]
[]
["TOTAL GENERAL EXPENSE",{"$f":"SUM(B75:B83)","v":52440},{"$f":"SUM(C75:C83)","v":52470},{"$f":"SUM(D75:D83)","v":4372.5},51681.453333333331,40251.710000000006]
[]
["FINANCING"," "," "," "," "]
["INT ON MORTGAGE PAYABLE",1650,230,{"$f":"C87/12","v":19.166666666666668},1650,1478.68,"    Mortgage Ends 6/30/2017"]
["MORTGAGE      ",41660,21140,{"$f":"C88/12","v":1761.6666666666667},41660,34613.82]
["TOTAL FINANCING",{"$f":"SUM(B87:B88)","v":43310},{"$f":"SUM(C87:C88)","v":21370},{"$f":"SUM(D87:D88)","v":1780.8333333333335},{"$f":"SUM(E87:E88)","v":43310},{"$f":"SUM(F87:F88)","v":36092.5}]
[null," "," "," "," "]
["RESERVES"," "," "," "," "]
["REPLACEMENT RESERVES",4800,4800,{"$f":"C92/12","v":400},{"$f":"F92/9*12","v":4800},3600]
["TOTAL RESERVES",{"$f":"B92","v":4800},{"$f":"C92","v":4800},{"$f":"D92","v":400},{"$f":"E92","v":4800},{"$f":"F92","v":3600}]
[null," "," "," "," "]
["CAPITAL EXPENDITURES"," "," "," "," "]
["LAND & IMPROVEMENTS",0,0,{"$f":"C96/12","v":0},0,0]
["BUILDING ",0,0,0,0,0]
["BUILDING IMPROVEMENTS",0,0,{"$f":"C98/12","v":0},0,0]
["BLDG. EQUIP. FIXED ",0,0,0,0,0]
["BLDG. EQUIP. PORTABLE",0,0,0,{"$f":"F100/9*12","v":0},0]
["FURNISHINGS",0,0,0,0,0]
["MISC. FIXED ASSETS",0,0,0,0,0]
["TOTAL CAPITAL EXP.",{"$f":"SUM(B96:B102)","v":0},{"$f":"SUM(C96:C102)","v":0},{"$f":"SUM(D96:D102)","v":0},{"$f":"SUM(E96:E102)","v":0},{"$f":"SUM(F96:F102)","v":0}]
[null,null,null,null," "]
["TOTAL EXPENDITURES",{"$f":"SUM(B103+B93+B89+B84+B72+B57+B50)","v":189660},{"$f":"SUM(C103+C93+C89+C84+C72+C57+C50)","v":184030},{"$f":"SUM(D103+D93+D89+D84+D72+D57+D50)","v":15335.833333333332},{"$f":"SUM(E103+E93+E89+E84+E72+E57+E50)","v":180805.17333333334},{"$f":"SUM(F103+F93+F89+F84+F72+F57+F50)","v":141526.81}]
[null,null,null,null," "]
["NET INCOME (LOSS)",{"$f":"SUM(B22-B105)","v":-26650},{"$f":"SUM(C22-C105)","v":-5300},{"$f":"SUM(D22-D105)","v":-441.66666666666424},{"$f":"SUM(E22-E105)","v":-15007.493333333347},{"$f":"SUM(F22-F105)","v":-17178.549999999988}]
[]
["DEPRECIATION INCLUDED ABOVE",{"$f":"B82","v":31110},{"$f":"C82","v":30000},{"$f":"D82","v":2500},{"$f":"E82","v":30200},{"$f":"F82","v":20741.36}]
[]
["NET INCOME(LOSS) AFTER DEPRECIATION",{"$f":"B107+B109","v":4460},{"$f":"C107+C109","v":24700},2058.3333333333358,15192.506666666653,3562.8100000000122]

{"sheet":"Hilltop ","index":6,"n_rows":111,"n_cols":7,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"JEFFCO HOUSING CORPORATION"]
[null,"HILLTOP"]
[null,"FY 2017 OPERATING BUDGET"]
[null,null,null,null,null,null,"On 9/30/2016    Replacement Reserves $62,326.99"]
[null,null,null,null,null,"Actual","33 Units "]
[null,"Budget","Budget","Budget",null,"YTD ","3% increase over 12/31/2016 potential estimate"]
[null,"FY 2016","FY 2017","FY 2017","FY 2016","FY 2016","unless otherwise noted"]
[null,"ANNUAL","ANNUAL","Monthly","12MO Estimate","at 9/30/16","Mortgage Ends June 2019"]
["OPERATING RECEIPTS"]
["RENTAL INCOME",296190,314141,{"$f":"C13/12","v":26178.416666666668},302741,226212,"proposed increases (aprox. 3.75% )"]
["PET RENT",210,0,0,{"$f":"F14/9*12","v":45.333333333333329},34,"Now incorporated with the rent."]
["VACANCIES",-5920,-6280,-523.33333333333337,-4018.413333333333,-3013.81,"2% of Rental Income"]
["TRANSFER FROM RESERVES",8000,12000,{"$f":"C16/12","v":1000},{"$f":"F16/9*12","v":0},0,"Transfer for 1/2 of Rooftop A/C Units"]
["INTEREST INCOME",20,20,1.6666666666666667,13.413333333333334,10.06]
["LAUNDRY INCOME",620,470,39.166666666666664,455.25333333333333,341.44]
["NSF / LATE  CHARGES",390,390,32.5,566.66666666666663,425,"Estimate"]
["OTHER INCOME",100,100,8.3333333333333339,642.42666666666662,481.82,"Estimate"]
[]
["TOTAL OPERATING RECEIPTS",{"$f":"SUM(B13:B21)","v":299610},{"$f":"SUM(C13:C21)","v":320841},{"$f":"SUM(D13:D21)","v":26736.750000000004},300445.68000000005,224490.51]
[]
["OPERATING EXPENDITURES"]
["ADMINISTRATIVE",{"$f":"B50","v":36050},{"$f":"C50","v":35590.347600000001},{"$f":"D50","v":2965.8623000000002},{"$f":"E50","v":33977.133333333331},{"$f":"F50","v":25770.1}]
["OPERATING",{"$f":"B57","v":17180},{"$f":"C57","v":17270},{"$f":"D57","v":1439.1666666666665},{"$f":"E57","v":16296.466666666665},{"$f":"F57","v":13657.85}]
["MAINTENANCE",{"$f":"B72","v":75410},{"$f":"C72","v":67730},{"$f":"D72","v":5644.166666666667},{"$f":"E72","v":90172.786666666667},{"$f":"F72","v":67629.59}]
["GENERAL",{"$f":"B84","v":88010},{"$f":"C84","v":86470},{"$f":"D84","v":7205.833333333333},{"$f":"E84","v":85653.253333333327},{"$f":"F84","v":66336.06}]
["FINANCING",{"$f":"B89","v":130060},{"$f":"C89","v":130060},{"$f":"D89","v":10838.333333333334},{"$f":"E89","v":130060},{"$f":"F89","v":108379.5}]
["RESERVES",{"$f":"B92","v":3600},{"$f":"C92","v":4800},{"$f":"D93","v":400},{"$f":"E93","v":3600},{"$f":"F93","v":2700}]
["CAPITAL EXPENSE",{"$f":"B103","v":22700},{"$f":"C103","v":31500},{"$f":"D103","v":2625},{"$f":"E103","v":7180},{"$f":"F103","v":26946}]
["TOTAL OPERATING EXPENSE",{"$f":"SUM(B25:B31)","v":373010},{"$f":"SUM(C25:C31)","v":373420.34759999998},{"$f":"SUM(D25:D31)","v":31118.362300000001},{"$f":"SUM(E25:E31)","v":366939.64},{"$f":"SUM(F25:F31)","v":311419.09999999998}]
["NET INCOME (LOSS)",{"$f":"SUM(B22-B32)","v":-73400},{"$f":"SUM(C22-C32)","v":-52579.347599999979},{"$f":"SUM(D22-D32)","v":-4381.612299999997},{"$f":"SUM(E22-E32)","v":-66493.959999999963},{"$f":"SUM(F22-F32)","v":-86928.589999999967}]
[]
[]
["ADMINISTRATIVE EXPENDITURES"]
["OFFICE SALARIES",12320,12740,{"$f":"C37/12","v":1061.6666666666667},{"$f":"F37/9*12","v":12370.666666666668},9278]
[]
[]
["OFFICE SUPPLIES",160,410,{"$f":"C40/12","v":34.166666666666664},{"$f":"F40/9*12","v":398.94666666666666},299.20999999999998]
["DUES & MTG EXPENSE",120,110,9.1666666666666661,103.12,77.34]
["CLIENT VERIFICATION SERVICES",70,120,10,108.73333333333332,81.55]
["MANAGEMENT FEE",14580,15440,1286.6666666666667,14965.399999999998,11224.05,"Based on 5% of total income minus interest & transfer from reserves"]
["LEGAL",420,430,35.833333333333336,0,0,"One legal $245 + $50 & one sheriff fee $135"]
["ACCOUNTING/AUDIT",3590,3290,274.16666666666669,3187,2677.5]
["TELEPHONE",1300,1400,116.66666666666667,1242.5066666666667,931.88,"increase for tablets"]
["COMPUTER EXPENSE",1670,90,7.5,86.853333333333325,65.14]
["MISC. ADMIN. EXPENSE",980,{"$f":"E48+E48*3%","v":1010.3476000000001},84.195633333333333,980.92000000000007,735.69]
["TRAVEL & TRAINING",840,550,45.833333333333336,532.98666666666668,399.74]
["TOTAL ADMINISTRATIVE",{"$f":"SUM(B37:B49)","v":36050},{"$f":"SUM(C37:C49)","v":35590.347600000001},{"$f":"SUM(D37:D49)","v":2965.8623000000002},{"$f":"SUM(E37:E49)","v":33977.133333333331},{"$f":"SUM(F37:F49)","v":25770.1}]
[null," "," "," "," "]
["OPERATING EXPENDITURES"," "," "," "," "]
["ELECTRIC",2930,2970,{"$f":"C53/12","v":247.5},{"$f":"F53/9*12","v":2881.6666666666665},2161.25,"3%"]
["WATER",7440,7710,642.5,7136,5352,"8%"]
["GAS",700,560,46.666666666666664,536.79999999999995,402.6,"4%"]
["SEWER",6110,6030,502.5,5742,5742,"5% - Annual "]
["TOTAL OPERATING",{"$f":"SUM(B53:B56)","v":17180},{"$f":"SUM(C53:C56)","v":17270},{"$f":"SUM(D53:D56)","v":1439.1666666666665},{"$f":"SUM(E53:E56)","v":16296.466666666665},{"$f":"SUM(F53:F56)","v":13657.85}]
[]
["MAINTENANCE EXPENDITURES"]
["JANITORIAL CONTRACT & SUPPLIES",2880,2890,{"$f":"C60/12","v":240.83333333333334},{"$f":"F60/9*12","v":3933.333333333333},2950,"3% & Laundry cleaning $150month($1800yr) & $1000 for turnover"]
["EXTERMINATING CONTRACT",500,1190,99.166666666666671,1129.3333333333335,847,"New contract - $99 month (1188 yr) "]
["TRASH REMOVAL",3670,3350,279.16666666666669,3217.333333333333,2413,"4%"]
["GROUNDS CONTRACT",5790,5820,485,10503.333333333334,7877.5,"3% & $150wk Apl-Oct(30wks=$4500)+ 1000.cleanup1140sprinklers 2500 trees"]
["REPAIR MATERIALS",11340,10150,845.83333333333337,9849.8533333333326,7387.39]
["REPAIR CONTRACT ",20750,15860,1321.6666666666667,36127.613333333335,27095.71,"  3%  Lighting work $1500.  Deck upgrades $2000.  minus Aprox $15k of 2016 amount is Colo Cus Trim"]
["CARPET & VINYL/PLANK",4500,4500,375,10852.786666666667,8139.59,"3 units carpet/vinyl  @ $1500 ea"]
["APPLIANCES ",10620,4230,352.5,3497.3333333333335,2623,"2 Refrigerators ($570ea), 2 Ranges ($460ea), 2 Dishwashers ($385ea)  1 Washers/1Dryers $700 ea "]
["REPAIR PAYROLL",12440,8620,718.33333333333337,8361.8666666666668,6271.4]
["SNOW REMOVAL",2920,3620,301.66666666666669,2700,2025,"                6 yr average x 10 snow days"]
["CABINETS & FURNITURE",0,7500,{"$f":"C70/12","v":625},{"$f":"F70/9*12","v":0},0," NEW - 5 units at $1500 ea ($7500)"]
["SECURITY",0,0,0,0,0]
["TOTAL MAINTENANCE",{"$f":"SUM(B60:B71)","v":75410},{"$f":"SUM(C60:C71)","v":67730},{"$f":"SUM(D60:D71)","v":5644.166666666667},90172.786666666667,67629.59]
[null," "," "," "," "]
["GENERAL"," "," "," "," "]
["PAYROLL TAXES",1900,1640,{"$f":"C75/12","v":136.66666666666666},{"$f":"F75/9*12","v":1918.7466666666664},1439.06,"7.65% of Payroll    "]
["PROP & LIAB. INSURANCE ",9200,10690,890.83333333333337,10331,10331.299999999999,"3.5% for General Liability No Increase in Property Liability"]
["EMPLOYEE BENEFITS",7430,6410,534.16666666666663,5946.1066666666666,4459.58,"30.% of payroll - Health, Dental, CCOERA"]
["WORKMAN'S COMPENSATION",740,640,53.333333333333336,793.98666666666668,595.49,"3.% of payroll "]
["EMPLOYEE COMPENSATION",740,640,53.333333333333336,0,0,"3.% of payroll "]
["BAD DEBT LOSS",500,600,50,600,0,"estimate      write off scheduled for Dec 2016"]
["LOSS ON DISPOSAL FIXED ASSETS",500,1050,87.5,1013.4133333333332,760.06,"estimate"]
["DEPRECIATION",67000,64800,5400,65050,48750.57]
[]
["TOTAL GENERAL EXPENSE",{"$f":"SUM(B75:B82)","v":88010},{"$f":"SUM(C75:C82)","v":86470},7205.833333333333,85653.253333333327,66336.06]
[]
["FINANCING"," "," "," "," "]
["INT ON MORTGAGE PAYABLE",16430,10860,{"$f":"C87/12","v":905},35590,14069.83,"Amortization Schedule"]
["MORTGAGE      ",113630,119200,{"$f":"C88/12","v":9933.3333333333339},94470,94309.67]
["TOTAL FINANCING",{"$f":"SUM(B87:B88)","v":130060},{"$f":"SUM(C87:C88)","v":130060},{"$f":"SUM(D87:D88)","v":10838.333333333334},{"$f":"SUM(E87:E88)","v":130060},{"$f":"SUM(F87:F88)","v":108379.5}]
[null," "," "," "," "]
["RESERVES"," "," "," "," "]
["REPLACEMENT RESERVES",3600,4800,{"$f":"C92/12","v":400},{"$f":"F92/9*12","v":3600},2700,"Increase due to age of building"]
["TOTAL RESERVES",{"$f":"B92","v":3600},{"$f":"C92","v":4800},{"$f":"D92","v":400},{"$f":"E92","v":3600},{"$f":"F92","v":2700}]
[null," "," "," "," "]
["CAPITAL EXPENDITURES"," "," "," "," "]
["LAND & IMPROVEMENTS",0,0,{"$f":"C96/12","v":0},0,0]
["BUILDING ",0,0,0,0,0]
["BUILDING IMPROVEMENTS",14500,0,{"$f":"C98/12","v":0},0,17774]
["BUILDING EQUIP. FIXED",8200,31500,2625,5380,9172,"Furnaces-3 @ $2500ea($7500)  Rooftop AC units $24,000.  "]
["BLDG. EQUIP. PORTABLE",0,0,0,1800,0]
["FURNISHINGS",0,0,0,{"$f":"F101/9","v":0},0]
["MISC. FIXED ASSETS",0,0,0,0,0]
["TOTAL CAPITAL EXP.",{"$f":"SUM(B96:B102)","v":22700},{"$f":"SUM(C96:C102)","v":31500},{"$f":"SUM(D96:D102)","v":2625},{"$f":"SUM(E96:E102)","v":7180},{"$f":"SUM(F96:F102)","v":26946}]
[null,null,null,null," "]
["TOTAL EXPENDITURES",{"$f":"SUM(B103+B93+B89+B84+B72+B57+B50)","v":373010},{"$f":"SUM(C103+C93+C89+C84+C72+C57+C50)","v":373420.34759999998},{"$f":"SUM(D103+D93+D89+D84+D72+D57+D50)","v":31118.362300000004},{"$f":"SUM(E103+E93+E89+E84+E72+E57+E50)","v":366939.64},{"$f":"SUM(F103+F93+F89+F84+F72+F57+F50)","v":311419.09999999998}]
[null,null,null,null," "]
["NET INCOME (LOSS)",{"$f":"SUM(B22-B105)","v":-73400},{"$f":"SUM(C22-C105)","v":-52579.347599999979},{"$f":"SUM(D22-D105)","v":-4381.6123000000007},{"$f":"SUM(E22-E105)","v":-66493.959999999963},{"$f":"SUM(F22-F105)","v":-86928.589999999967}]
[]
["DEPRECIATION INCLUDED ABOVE",{"$f":"B82","v":67000},{"$f":"C82","v":64800},{"$f":"D82","v":5400},{"$f":"E82","v":65050},{"$f":"F82","v":48750.57}]
[]
["NET INCOME(LOSS) AFTER DEPRECIATION",{"$f":"B107+B109","v":-6400},{"$f":"C107+C109","v":12220.652400000021},1018.3876999999993,-1443.9599999999627,-38178.019999999968]

{"sheet":"west 46 ","index":7,"n_rows":111,"n_cols":7,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"JEFFCO HOUSING CORPORATION"]
[null,"WEST 46th"]
[null,"FY 2016 OPERATING BUDGET"]
[null,null,null,null,null,null,"On 9/30/2016     Replacement Reserves $47,460.95"]
[null,null,null,null,null,"Actual","8 Units - 4 Apts. & 4 Townhouses"]
[null,"Budget","Budget","Budget",null,"YTD ","3% increase over 12/31/2016 potential estimate"]
[null,"FY 2016","FY 2017","FY 2017","FY 2016","FY 2016","unless otherwise noted"]
[null,"ANNUAL","ANNUAL","Monthly","12MO Estimate","at 9/30/16","Mortgage Ends June 2021"]
["OPERATING RECEIPTS"]
["RENTAL INCOME",64320,70760,{"$f":"C13/12","v":5896.666666666667},64690,48505,"proposed increases (aprox. 9.25% )"]
[]
["VACANCIES",-1290,-1420,-118.33333333333333,{"$f":"F15/9*12","v":-289.33333333333331},-217,"2% of Rental Income"]
["TRANSFER FROM RESERVES",15000,3700,308.33333333333331,0,0,"Transfer for Mailboxes $1200. &  Water Heater $2480."]
["INTEREST INCOME",20,10,0.83333333333333337,10.44,7.83,"Interest from shared reserve account shared with WRP"]
["LAUNDRY INCOME",1000,660,55,641.33333333333326,481]
["NSF / LATE  CHARGES",60,60,5,57.333333333333329,43]
["OTHER INCOME",570,100,8.3333333333333339,154.57333333333335,115.93,"Estimate"]
[]
["TOTAL OPERATING RECEIPTS",{"$f":"SUM(B13:B21)","v":79680},{"$f":"SUM(C13:C21)","v":73870},{"$f":"SUM(D13:D21)","v":6155.833333333333},65264.346666666672,48935.76]
[]
["OPERATING EXPENDITURES"]
["ADMINISTRATIVE",{"$f":"B50","v":5850},{"$f":"C50","v":5710},{"$f":"D50","v":475.83333333333331},{"$f":"E50","v":4743.8133333333326},{"$f":"F50","v":3557.8599999999997}]
["OPERATING",{"$f":"B57","v":4520},{"$f":"C57","v":6030},{"$f":"D57","v":502.5},{"$f":"E57","v":5646.1466666666665},{"$f":"F57","v":4594.6099999999997}]
["MAINTENANCE",{"$f":"B72","v":28810},{"$f":"C72","v":25760},{"$f":"D72","v":2146.6666666666665},{"$f":"E72","v":17593.746666666666},{"$f":"F72","v":13195.31}]
["GENERAL",{"$f":"B84","v":24770},{"$f":"C84","v":24250},{"$f":"D84","v":2020.833333333333},{"$f":"E84","v":23466.866666666669},{"$f":"F84","v":19454.14}]
["FINANCING",{"$f":"B89","v":32580},{"$f":"C89","v":32580},{"$f":"D89","v":2715},{"$f":"E89","v":32580},{"$f":"F89","v":27150.2}]
["RESERVES",{"$f":"B93","v":5400},{"$f":"C93","v":5400},{"$f":"D93","v":450},{"$f":"E93","v":5400},{"$f":"F93","v":4050}]
["CAPITAL EXPENSE",{"$f":"B103","v":2480},{"$f":"C103","v":2480},{"$f":"D103","v":206.66666666666666},{"$f":"E103","v":2480},{"$f":"F103","v":2050}]
["TOTAL OPERATING EXPENSE",{"$f":"SUM(B25:B31)","v":104410},{"$f":"SUM(C25:C31)","v":102210},{"$f":"SUM(D25:D31)","v":8517.4999999999982},{"$f":"SUM(E25:E31)","v":91910.573333333334},{"$f":"SUM(F25:F31)","v":74052.12}]
["NET INCOME (LOSS)",{"$f":"SUM(B22-B32)","v":-24730},{"$f":"SUM(C22-C32)","v":-28340},{"$f":"SUM(D22-D32)","v":-2361.6666666666652},{"$f":"SUM(E22-E32)","v":-26646.226666666662},{"$f":"SUM(F22-F32)","v":-25116.359999999993}]
[]
[]
["ADMINISTRATIVE EXPENDITURES"]
["OFFICE SALARIES",0,{"$f":"E37+E37*3%","v":0},0,0,0]
[null,null,0]
[null,null,0]
["OFFICE SUPPLIES & POSTAGE",120,140,{"$f":"C40/12","v":11.666666666666666},{"$f":"F40/9*12","v":133.33333333333331},100]
["DUES & MTG EXPENSE",30,30,{"$f":"C41/12","v":2.5},{"$f":"F41/9*12","v":25.773333333333333},19.329999999999998]
["CLIENT VERIFICATION SERV.",0,50,4.166666666666667,0,0,"Estimate"]
["MANAGEMENT FEE",3230,3510,292.5,3261.8666666666668,2446.4,"Based on 5% of total income minus interest & transfer from reserves"]
["LEGAL",420,430,35.833333333333336,0,0,"One legal $245 + $50 & one sheriff fee $135"]
["ACCOUNTING/AUDIT",950,930,77.5,840,630]
["TELEPHONE",120,200,16.666666666666668,147.05333333333334,110.29,"increase for tablets"]
["COMPUTER EXPENSE",560,50,4.166666666666667,35.333333333333336,26.5]
["MISC. ADMIN. EXPENSE",70,70,5.833333333333333,7.32,5.49,"Estimate"]
["TRAVEL & TRAINING",350,300,25,293.13333333333333,219.85]
["TOTAL ADMINISTRATIVE",{"$f":"SUM(B37:B49)","v":5850},{"$f":"SUM(C37:C49)","v":5710},{"$f":"SUM(D37:D49)","v":475.83333333333331},4743.8133333333326,3557.8599999999997]
[null," "," "," "," "]
["OPERATING EXPENDITURES"," "," "," "," "]
["ELECTRIC",680,900,{"$f":"C53/12","v":75},{"$f":"F53/9*12","v":829.85333333333324},622.39,"        Increase for  Laundry room/common area lights)"]
["WATER",2320,3200,266.66666666666669,2964.6266666666666,2223.4699999999998,"8%"]
["GAS",120,420,35,411.66666666666669,308.75,"4%       Estimate for Vacancy                           "]
["SEWER",1400,1510,125.83333333333333,1440,1440,"5% - Semi Annual"]
["TOTAL OPERATING",{"$f":"SUM(B53:B56)","v":4520},{"$f":"SUM(C53:C56)","v":6030},{"$f":"SUM(D53:D56)","v":502.5},{"$f":"SUM(E53:E56)","v":5646.1466666666665},{"$f":"SUM(F53:F56)","v":4594.6099999999997}]
[]
["MAINTENANCE EXPENDITURES"]
["JANITORIAL CONTRACT",450,100,{"$f":"C60/12","v":8.3333333333333339},{"$f":"F60/9*12","v":60},45,"Estimate one carpet cleaning"]
["EXTERMINATING CONTRACT",1900,1390,115.83333333333333,660,495,"Contract $99 mo $1188. year plus $200 for extra services."]
["TRASH REMOVAL",900,940,78.333333333333329,902.28,676.71,"4% & Contract $75.19.month($902.28.yr)   "]
["GROUNDS CONTRACT",2620,2320,193.33333333333334,2226.6666666666665,1670,"3% & $65wk Apl-Oct(30wks=$1950.)+ 300 cleanup & sprinklers"]
["REPAIR MATERIALS",3990,4340,361.66666666666669,2464.7999999999997,1848.6,"3%  +  Mailboxes $1200.00 + Tub surrounds $600.             minus laundry room buildout 2016"]
["REPAIR CONTRACT",8190,4750,395.83333333333331,4610.666666666667,3458,"3%                               minus sewer work completed 2016."]
["CARPET & VINYL/PLANK",1800,1800,150,0,0,"1 unit carpet / vinyl"]
["APPLIANCES ",2090,3600,300,638.66666666666663,479,"2 Refrigerator $570ea  & 2 Stoves  $460ea  &  4 DWs $385 ea"]
["REPAIR PAYROLL",5140,4880,406.66666666666669,4730.666666666667,3548]
["SNOW REMOVAL",1730,1640,136.66666666666666,1300,975,"                6 yr average x 10 snow days"]
["CABINETS & FURNITURE",0,0,0,0,0]
["SECURITY",0,0,0,0,0]
["TOTAL MAINTENANCE",{"$f":"SUM(B60:B71)","v":28810},{"$f":"SUM(C60:C71)","v":25760},{"$f":"SUM(D60:D71)","v":2146.6666666666665},17593.746666666666,13195.31]
[null," "," "," "," "]
["GENERAL"," "," "," "," "]
["PAYROLL TAXES",390,380,{"$f":"C75/12","v":31.666666666666668},{"$f":"F75/9*12","v":40},30,"7.65% of Payroll    "]
["PROP & LIAB. INSURANCE ",5850,5880,490,5680,6113.99,"3.5% for General Liability No Increase in Property Liability"]
["EMPLOYEE BENEFITS",1540,1460,121.66666666666667,124.52000000000001,93.39,"30.% of payroll - Health, Dental, CCOERA"]
["WORKMAN'S COMPENSATION",150,150,12.5,793.98666666666668,595.49,"3.% of payroll "]
["EMPLOYEE COMPENSATION",150,150,12.5,0,0,"3.% of payroll "]
["BAD DEBT LOSS",600,600,50,1049.5466666666666,787.16,"estimate"]
["LOSS ON DISPOSAL FIXED ASSET",200,200,16.666666666666668,0,0,"estimate"]
["DEPRECIATION",15890,15430,1285.8333333333333,15778.813333333335,11834.11]
[]
["TOTAL GENERAL EXPENSE",{"$f":"SUM(B75:B83)","v":24770},{"$f":"SUM(C75:C83)","v":24250},{"$f":"SUM(D75:D83)","v":2020.833333333333},23466.866666666669,19454.14]
[]
["FINANCING"," "," "," "," "]
["INT ON MORTGAGE PAYABLE",7650,6220,{"$f":"C87/12","v":518.33333333333337},9000,6472.32,"Amortization Schedule"]
["MORTGAGE      ",24930,26360,2196.6666666666665,23580,20677.88]
["TOTAL FINANCING",{"$f":"SUM(B87:B88)","v":32580},{"$f":"SUM(C87:C88)","v":32580},{"$f":"SUM(D87:D88)","v":2715},{"$f":"SUM(E87:E88)","v":32580},{"$f":"SUM(F87:F88)","v":27150.2}]
[null," "," "," "," "]
["RESERVES"," "," "," "," "]
["REPLACEMENT RESERVES",5400,5400,{"$f":"C92/12","v":450},{"$f":"F92/9*12","v":5400},4050]
["TOTAL RESERVES",{"$f":"B92","v":5400},{"$f":"C92","v":5400},{"$f":"D92","v":450},{"$f":"E92","v":5400},{"$f":"F92","v":4050}]
[null," "," "," "," "]
["CAPITAL EXPENDITURES"," "," "," "," "]
["LAND & IMPROVEMENTS",0,0,{"$f":"C96/12","v":0},0,0]
["BUILDING",0,0,{"$f":"C97/12","v":0},0,0]
["BUILDING IMPROVEMENTS",0,0,{"$f":"C98/12","v":0},0,0]
["BUILDING EQUIP.  FIXED",2480,2480,206.66666666666666,2480,2050,"Water Heater                                     "]
["BLDG. EQUIP. PORTABLE",0,0,0,0,0]
["FURNISHINGS",0,0,0,0,0]
["MISC. FIXED ASSETS",0,0,0,0,0]
["TOTAL CAPITAL EXP.",{"$f":"SUM(B96:B102)","v":2480},{"$f":"SUM(C96:C102)","v":2480},{"$f":"SUM(D96:D102)","v":206.66666666666666},{"$f":"SUM(E96:E102)","v":2480},{"$f":"SUM(F96:F102)","v":2050}]
[null,null,null,null," "]
["TOTAL EXPENDITURES",{"$f":"SUM(B103+B93+B89+B84+B72+B57+B50)","v":104410},{"$f":"SUM(C103+C93+C89+C84+C72+C57+C50)","v":102210},{"$f":"SUM(D103+D93+D89+D84+D72+D57+D50)","v":8517.5},{"$f":"SUM(E103+E93+E89+E84+E72+E57+E50)","v":91910.573333333348},{"$f":"SUM(F103+F93+F89+F84+F72+F57+F50)","v":74052.12}]
[null,null,null,null," "]
["NET INCOME (LOSS)",{"$f":"SUM(B22-B105)","v":-24730},{"$f":"SUM(C22-C105)","v":-28340},{"$f":"SUM(D22-D105)","v":-2361.666666666667},{"$f":"SUM(E22-E105)","v":-26646.226666666676},{"$f":"SUM(F22-F105)","v":-25116.359999999993}]
[]
["DEPRECIATION INCLUDED ABOVE",{"$f":"B82","v":15890},{"$f":"C82","v":15430},{"$f":"D82","v":1285.8333333333333},{"$f":"E82","v":15778.813333333335},{"$f":"F82","v":11834.11}]
[]
["NET INCOME(LOSS) AFTER DEPRECIATION",{"$f":"B107+B109","v":-8840},{"$f":"C107+C109","v":-12910},-1075.8333333333337,-10867.413333333341,-13282.249999999993]

{"sheet":"Arvada Cottages ","index":8,"n_rows":111,"n_cols":8,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
[]
[null,"JEFFCO HOUSING CORPORATION"]
[null,"ARVADA COTTAGES"]
[null,"FY 2017 OPERATING BUDGET",null,null,null,null,"On 9/30/2016  Replacement Reserves     $ 16,132.12                 "]
[null,null,null,null,null,null,"                      Operating Reserves          $ 21,141.56"]
[null,null,null,null,null,null,"                      Total Together                  $ 37,273.68"]
[]
[null,null,null,null,null,"Actual","16 Homes - 15 -4bdrm  & 1 - 3bdrm "]
[null,"Budget","Budget","Budget",null,"YTD ","3% increase over 12/31/2016 potential estimate"]
[null,"FY 2016","FY 2017","FY 2017","FY 2016","FY 2016","unless otherwise noted"]
[null,"ANNUAL","ANNUAL","Monthly","12MO Estimate","at 9/30/16","Mortgage Ends October 2023"]
["OPERATING RECEIPTS"]
["RENTAL INCOME",50890,51740,{"$f":"C13/12","v":4311.666666666667},{"$f":"F13/9*12","v":54530.666666666672},40898," Estimated rents                        HUD Subsidy( Tenant 20% Chafa 80%)"]
["TENANT ASSISTANCE",203540,206980,17248.333333333332,201253.33333333331,150940]
["VACANCIES",-5090,-4080,-340,-3850.666666666667,-2888," based on three unit months (2% is $5174.00)"]
["TRANSFER FROM RESERVES",0,5000,{"$f":"C16/12","v":416.66666666666669},0,0,"Transfer for sprinkler system at two units"]
["INTEREST INCOME",80,50,4.166666666666667,{"$f":"F17/9*12","v":61.946666666666673},46.46]
[]
["NSF & LATE FEES",150,300,25,364,273]
["OTHER INCOME",1500,1500,125,702.6,526.95000000000005," Estimate      CHFA adjustments and Retro Rent"]
[]
["TOTAL OPERATING RECEIPTS",{"$f":"SUM(B13:B21)","v":251070},{"$f":"SUM(C13:C21)","v":261490},21790.833333333336,253061.88,189796.41]
[]
["OPERATING EXPENDITURES"]
["ADMINISTRATIVE",{"$f":"B50","v":27230},{"$f":"C50","v":26830},{"$f":"D50","v":2235.833333333333},{"$f":"E50","v":24731.25333333333},{"$f":"F50","v":19110.190000000002}]
["OPERATING",{"$f":"B57","v":17530},{"$f":"C57","v":22799.893333333333},{"$f":"D57","v":1899.991111111111},{"$f":"E57","v":21081.153333333332},{"$f":"F57","v":15486.619999999999}]
["MAINTENANCE",{"$f":"B72","v":50180},{"$f":"C72","v":48380},{"$f":"D72","v":4031.6666666666665},{"$f":"E72","v":57945.426666666674},{"$f":"F72","v":43459.07}]
["GENERAL",{"$f":"B84","v":69700},{"$f":"C84","v":63980},{"$f":"D84","v":5331.6666666666661},{"$f":"E84","v":61478.64},{"$f":"F84","v":47111.199999999997}]
["FINANCING",{"$f":"B89","v":142470},{"$f":"C89","v":142470},{"$f":"D89","v":11872.5},{"$f":"E89","v":142470},{"$f":"F89","v":118727.4}]
["RESERVES",{"$f":"B92","v":2400},{"$f":"C92","v":4800},{"$f":"D92","v":400},{"$f":"E93","v":2400},{"$f":"F93","v":1800}]
["CAPITAL EXPENSE",{"$f":"B103","v":22190},{"$f":"C103","v":5000},{"$f":"D103","v":416.66666666666669},{"$f":"E103","v":1372},{"$f":"F103","v":4000}]
["TOTAL OPERATING EXPENSE",{"$f":"SUM(B25:B31)","v":331700},{"$f":"SUM(C25:C31)","v":314259.89333333331},{"$f":"SUM(D25:D31)","v":26188.324444444446},{"$f":"SUM(E25:E31)","v":311478.47333333333},{"$f":"SUM(F25:F31)","v":249694.47999999998}]
["NET INCOME (LOSS)",{"$f":"SUM(B22-B32)","v":-80630},{"$f":"SUM(C22-C32)","v":-52769.893333333312},{"$f":"SUM(D22-D32)","v":-4397.4911111111105},{"$f":"SUM(E22-E32)","v":-58416.593333333323},{"$f":"SUM(F22-F32)","v":-59898.069999999978}]
[]
[]
["ADMINISTRATIVE EXPENDITURES"]
["OFFICE SALARIES",8320,8220,{"$f":"C37/12","v":685},{"$f":"F37/9*12","v":7981.333333333333},5986]
[]
[]
["OFFICE SUPPLIES",260,510,42.5,492.98666666666668,369.74]
["DUES & MTG EXPENSE",120,150,12.5,142.46666666666667,106.85,"                  contains CPM dues - Mike Hunter"]
["CLIENT VERIFICATION SERVICES",1200,210,{"$f":"C42/12","v":17.5},200,559.5,"Estimate based on Yardi Client Verification only "]
["MANAGEMENT FEE",12500,12820,1068.3333333333333,12650,9487.5,"Based on 5% of total income minus interest"]
["LEGAL",1420,1430,119.16666666666667,0,0,"One legal $245 + $50  & one sheriff fee $135  & Attys fees of $1000"]
["ACCOUNTING/AUDIT",1460,1740,145,1687,1417.5]
["TELEPHONE",300,500,41.666666666666664,367.6,275.7,"increase for tablets"]
["COMPUTER EXPENSE",560,80,6.666666666666667,76.106666666666669,57.08]
["MISC. ADMIN. EXPENSE",380,350,29.166666666666668,338.86666666666667,254.15]
["TRAVEL & TRAINING",710,820,68.333333333333329,794.89333333333332,596.16999999999996]
["TOTAL ADMINISTRATIVE",{"$f":"SUM(B37:B49)","v":27230},{"$f":"SUM(C37:C49)","v":26830},{"$f":"SUM(D37:D49)","v":2235.833333333333},{"$f":"SUM(E37:E49)","v":24731.25333333333},{"$f":"SUM(F37:F49)","v":19110.190000000002}]
[null," "," "," "," "]
["OPERATING EXPENDITURES"," "," "," "," "]
["ELECTRIC",4120,{"$f":"E53+E53*3%","v":5649.8933333333334},{"$f":"C53/12","v":470.82444444444445},{"$f":"F53/9*12","v":5485.333333333333},4114,"3%"]
["WATER",6250,9830,819.16666666666663,9099.4399999999987,6824.58,"8%                                                             ",9822.66]
["GAS",500,500,41.666666666666664,0,0,"4%                    Estimate for vacant"]
["SEWER",6660,6820,568.33333333333337,6496.38,4548.04,"5% "]
["TOTAL OPERATING",{"$f":"SUM(B53:B56)","v":17530},{"$f":"SUM(C53:C56)","v":22799.893333333333},{"$f":"SUM(D53:D56)","v":1899.991111111111},{"$f":"SUM(E53:E56)","v":21081.153333333332},{"$f":"SUM(F53:F56)","v":15486.619999999999}]
[]
["MAINTENANCE EXPENDITURES"]
["JANITORIAL CONTRACT & SUPPLIES",1000,300,{"$f":"C60/12","v":25},{"$f":"F60/9*12","v":306.66666666666669},230,"Estimate cleaning for turnover"]
["EXTERMINATING CONTRACT",4650,4880,406.66666666666669,6553.333333333333,4915,"1 BB @ $2478.  & regular spraying / and treatments 2400."]
["TRASH REMOVAL",2150,2210,184.16666666666666,1624.6266666666666,1218.47,"4% Contract $177.00 month($2124.yr)"]
["GROUNDS CONTRACT",3390,5000,416.66666666666669,13466.666666666666,10100,"Estimate           2016 had excessive work on bushes"]
["REPAIR MATERIALS",10780,7400,616.66666666666663,7187.0266666666666,5390.27]
["REPAIR CONTRACT COSTS",9180,8530,710.83333333333337,8284.8533333333344,6213.64]
["CARPET & VINYL/PLANK",5000,7000,583.33333333333337,8792.6533333333336,6594.49,"2 units carpet & vinyl @ $3500. ea "]
["APPLIANCES ",1930,2060,171.66666666666666,1265.3333333333333,949,"2 Refrigerators $570. ea  &  2 Ranges $460ea"]
["REPAIR PAYROLL",11360,8800,{"$f":"C68/12","v":733.33333333333337},{"$f":"F68/9*12","v":8548},6411]
["SNOW REMOVAL",740,200,{"$f":"C69/12","v":16.666666666666668},{"$f":"F69/9*12","v":0},0,"Estimate for vacant units"]
["CABINETS & FURNITURE",0,2000,{"$f":"C70/12","v":166.66666666666666},{"$f":"F70/9*12","v":1916.2666666666669},1437.2,"One unit cabinets"]
["SECURITY ",0,{"$f":"E71+E71*3%","v":0},0,{"$f":"F71/9*12","v":0},0]
["TOTAL MAINTENANCE",{"$f":"SUM(B60:B71)","v":50180},{"$f":"SUM(C60:C70)","v":48380},{"$f":"SUM(D60:D70)","v":4031.6666666666665},{"$f":"SUM(E60:E70)","v":57945.426666666674},{"$f":"SUM(F60:F70)","v":43459.07}]
[]
["GENERAL"," "," "," "," "]
["PAYROLL TAXES",1510,1300,{"$f":"C75/12","v":108.33333333333333},{"$f":"F75/9*12","v":1163.04},872.28,"7.65% of Payroll    "]
["PROP & LIAB. INSURANCE ",8020,5190,432.5,5008,5007.9799999999996,"3.5% for General Liability No Increase in Property Liability"]
["EMPLOYEE BENEFITS",5900,5110,425.83333333333331,3675.5866666666666,2756.69,"30.% of payroll - Health, Dental, CCOERA"]
["WORKMAN'S COMPENSATION",590,510,42.5,793.98666666666668,595.49,"3.% of payroll "]
["EMPLOYEE COMPENSATION",590,510,42.5,0,0,"3.% of payroll "]
["BAD DEBT LOSS",1000,1000,83.333333333333329,0,0,"Estimate"]
["LOSS ON DISPOSAL FIXED ASSET",1000,1000,83.333333333333329,1338.0266666666666,1003.52,"Estimate"]
["DEPRECIATION",50990,49350,{"$f":"C82/12","v":4112.5},49500,36875.24]
["OTHER INTERST PAID",100,10,{"$f":"C83/12","v":0.83333333333333337},{"$f":"F83/9*12","v":0},0,"Estimate     2% paid to Tenant on deposit refund  at move out - per lease"]
["TOTAL GENERAL EXPENSE",{"$f":"SUM(B75:B83)","v":69700},{"$f":"SUM(C75:C83)","v":63980},{"$f":"SUM(D75:D83)","v":5331.6666666666661},{"$f":"SUM(E75:E83)","v":61478.64},{"$f":"SUM(F75:F83)","v":47111.199999999997}]
[]
["FINANCING"," "," "," "," "]
["INT ON MORTGAGE PAYABLE",40420,35630,{"$f":"C87/12","v":2969.1666666666665},45000,34011.919999999998,"2016 Amortization Schedule"]
["MORTGAGE      ",102050,106840,{"$f":"C88/12","v":8903.3333333333339},97470,84715.48]
["TOTAL FINANCING",{"$f":"SUM(B87:B88)","v":142470},{"$f":"SUM(C87:C88)","v":142470},{"$f":"SUM(D87:D88)","v":11872.5},{"$f":"SUM(E87:E88)","v":142470},{"$f":"SUM(F87:F88)","v":118727.4}]
[null," "," "," "," "]
["RESERVES"," "," "," "," "]
["REPLACEMENT RESERVES",2400,4800,{"$f":"C92/12","v":400},{"$f":"F92/9*12","v":2400},1800,"Increase due to age of building"]
["TOTAL RESERVES",{"$f":"B92","v":2400},{"$f":"C92","v":4800},{"$f":"D92","v":400},{"$f":"E92","v":2400},{"$f":"F92","v":1800}]
[null," "," "," "," "]
["CAPITAL EXPENDITURES"," "," "," "," "]
["LAND & IMPROVEMENTS",15000,5000,{"$f":"C96/12","v":416.66666666666669},0,0,"2 units Sprinkler Systems @ $2,500 each  (lowered from 2016 budget) "]
["BUILDING ",0,0,0,0,0]
["BUILDING IMPROVEMENTS",0,0,0,0,0]
["BLDG. EQUIP. FIXED",7190,0,0,1372,4000]
["BLDG. EQUIP. PORTABLE",0,0,0,{"$f":"F100/9*12","v":0},0]
["FURNISHINGS",0,0,0,0,0]
["MISC. FIXED ASSETS",0,0,0,{"$f":"F102/9","v":0},0]
["TOTAL CAPITAL EXP.",{"$f":"SUM(B96:B102)","v":22190},{"$f":"SUM(C96:C102)","v":5000},{"$f":"SUM(D96:D102)","v":416.66666666666669},{"$f":"SUM(E96:E102)","v":1372},{"$f":"SUM(F96:F102)","v":4000}]
[null,null,null,null," "]
["TOTAL EXPENDITURES",{"$f":"SUM(B103+B93+B89+B84+B72+B57+B50)","v":331700},{"$f":"SUM(C103+C93+C89+C84+C72+C57+C50)","v":314259.89333333331},{"$f":"SUM(D103+D93+D89+D84+D72+D57+D50)","v":26188.324444444443},{"$f":"SUM(E103+E93+E89+E84+E72+E57+E50)","v":311478.47333333339},{"$f":"SUM(F103+F93+F89+F84+F72+F57+F50)","v":249694.47999999998}]
[null,null,null,null," "]
["NET INCOME (LOSS)",{"$f":"SUM(B22-B105)","v":-80630},{"$f":"SUM(C22-C105)","v":-52769.893333333312},{"$f":"SUM(D22-D105)","v":-4397.4911111111069},{"$f":"SUM(E22-E105)","v":-58416.593333333381},{"$f":"SUM(F22-F105)","v":-59898.069999999978}]
[]
["DEPRECIATION INCLUDED ABOVE",{"$f":"B82","v":50990},{"$f":"C82","v":49350},{"$f":"D82","v":4112.5},{"$f":"E82","v":49500},{"$f":"F82","v":36875.24}]
[]
["NET INCOME(LOSS) AFTER DEPRECIATION",{"$f":"B107+B109","v":-29640},{"$f":"C107+C109","v":-3419.8933333333116},-284.99111111110687,-8916.5933333333815,-23022.82999999998]

{"sheet":"Allison Village","index":9,"n_rows":111,"n_cols":7,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"JEFFCO HOUSING CORPORATION"]
[null,"ALLISON VILLAGE"]
[null,"FY 2017 OPERATING BUDGET"]
[null,null,null,null,null,null,"On 9/30/2016    Replacement Reserves $71,401.36"]
[null,null,null,null,null,"Actual","37 Units"]
[null,"Budget","Budget","Budget",null,"YTD ","3% increase over 12/31/2016 potential estimate"]
[null,"FY 2016","FY 2017","FY 2017","FY 2016","FY 2016","unless otherwise noted"]
[null,"ANNUAL","ANNUAL","Monthly","12MO Estimate","at 9/30/16","Mortgage Ends October 2031"]
["OPERATING RECEIPTS"]
["RENTAL INCOME",113390,116330,{"$f":"C13/12","v":9694.1666666666661},{"$f":"F13/9*12","v":139598.66666666669},104699,"Rents based on current & new contracts effective 5/1/17  (HUD Subsidy- Tenant 33% Chafa 67%)"]
["TENANT ASSISTANCE PAYMENTS",230210,236178,{"$f":"C14/12","v":19681.5},207464,155598]
["LESS: VACANCIES",-6870,-3570,{"$f":"C15/12","v":-297.5},-1896.6666666666665,-1422.5,"Two unit months 2bdrm & Two unit months 2bdrm"]
["TRANSFER FROM RESERVES",10000,10000,{"$f":"C16/12","v":833.33333333333337},0,0,"Transfer for Concrete Work $3500.  Carpet/Vinyl $3300.00  Cabinets $3000."]
["INTEREST INCOME",100,100,{"$f":"C17/12","v":8.3333333333333339},89.933333333333337,67.45]
["LAUNDRY / VENDING REVENUE",3500,3500,{"$f":"C18/12","v":291.66666666666669},{"$f":"F18/9*12","v":4842.76},3632.07]
["NSF & LATE CHARGES",890,890,{"$f":"C19/12","v":74.166666666666671},{"$f":"F19/9*12","v":696},522]
["OTHER INCOME",2000,2000,{"$f":"C20/12","v":166.66666666666666},6000,1545.66,"Estimate     Retro Rent   /  CHFA adjs"]
[]
["TOTAL OPERATING RECEIPTS",{"$f":"SUM(B13:B20)","v":353220},{"$f":"SUM(C13:C20)","v":365428},{"$f":"SUM(D13:D20)","v":30452.333333333332},{"$f":"SUM(E13:E20)","v":356794.69333333336},{"$f":"SUM(F13:F20)","v":264641.68}]
[]
["OPERATING EXPENDITURES"]
["ADMINISTRATIVE",{"$f":"B50","v":61270},{"$f":"C50","v":61090},{"$f":"D50","v":5090.8333333333321},{"$f":"E50","v":59317.306666666664},{"$f":"F50","v":45884.68}]
["OPERATING",{"$f":"B57","v":40770},{"$f":"C57","v":42690.176399999997},{"$f":"D57","v":3557.5146999999993},{"$f":"E57","v":42324.626666666663},{"$f":"F57","v":30834.390000000003}]
["MAINTENANCE",{"$f":"B72","v":86450},{"$f":"C72","v":88880},{"$f":"D72","v":8601.6666666666679},{"$f":"E72","v":72313.346666666665},{"$f":"F72","v":54235.01}]
["GENERAL",{"$f":"B84","v":96530},{"$f":"C84","v":99129.524999999994},{"$f":"D84","v":8260.7937500000007},{"$f":"E84","v":91679.453333333338},{"$f":"F84","v":72121.239999999991}]
["FINANCING",{"$f":"B89","v":123770},{"$f":"C89","v":123770},{"$f":"D89","v":10314.166666666666},{"$f":"E89","v":123770},{"$f":"F89","v":103135}]
["RESERVES",{"$f":"B93","v":15600},{"$f":"C93","v":15600},{"$f":"D93","v":1300},{"$f":"E93","v":15600},{"$f":"F93","v":11700}]
["CAPITAL EXPENSE",{"$f":"B103","v":5500},{"$f":"C103","v":0},{"$f":"D103","v":0},{"$f":"E103","v":6618},{"$f":"F103","v":6617.85}]
["TOTAL OPERATING EXPENSE",{"$f":"SUM(B25:B31)","v":429890},{"$f":"SUM(C25:C31)","v":431159.70140000002},{"$f":"SUM(D25:D31)","v":37124.975116666668},{"$f":"SUM(E25:E31)","v":411622.73333333328},{"$f":"SUM(F25:F31)","v":324528.17}]
["NET INCOME (LOSS)",{"$f":"SUM(B22-B32)","v":-76670},{"$f":"SUM(C22-C32)","v":-65731.70140000002},{"$f":"SUM(D22-D32)","v":-6672.6417833333362},{"$f":"SUM(E22-E32)","v":-54828.039999999921},{"$f":"SUM(F22-F32)","v":-59886.489999999991}]
[]
[]
["ADMINISTRATIVE EXPENDITURES"]
["OFFICE SALARIES ",30440,30580,{"$f":"C37/12","v":2548.3333333333335},{"$f":"F37/9*12","v":29688},22266]
[null,null,null,null,0]
[null,null,null,null,0]
["OFFICE SUPPLIES",730,1000,83.333333333333329,1650.9066666666668,1238.18,"Estimate                                                     2016 High due to waiting list mailing "]
["DUES & MTG EXPENSE",290,570,47.5,554.02666666666664,415.52,"REACH membership &  corp board meeting   & CPM dues-Mike Hunter"]
["CLIENT VERIFICATION SERVICES",2330,210,17.5,200,1213.7,"Estimate based on Yardi Client Verification only "]
["MANAGEMENT FEE",17160,17770,1480.8333333333333,17638.333333333332,13228.75,"Based on 5% of estimated 2015 total income minus interest"]
["LEGAL",420,430,35.833333333333336,0,0,"One legal $245 + $50 & one sheriff fee $135"]
["ACCOUNTING/AUDIT",3220,3230,269.16666666666669,3131,2681.25]
["TELEPHONE",3340,4000,333.33333333333331,3254.2799999999997,2440.71,"increase for tablets"]
["COMPUTER EXPENSE",1680,130,10.833333333333334,125.03999999999999,93.78]
["MISC ADMIN ",420,1030,85.833333333333329,999.14666666666665,749.36]
["TRAVEL & TRAINING",1240,2140,178.33333333333334,2076.5733333333333,1557.43]
["TOTAL ADMINISTRATIVE",{"$f":"SUM(B37:B49)","v":61270},61090,5090.8333333333321,{"$f":"SUM(E37:E49)","v":59317.306666666664},{"$f":"SUM(F37:F49)","v":45884.68}]
[null," "," "," "]
["OPERATING EXPENDITURES"," "," "," "]
["ELECTRICITY",19360,{"$f":"E53+E53*3%","v":18550.176399999997},{"$f":"C53/12","v":1545.848033333333},{"$f":"F53/9*12","v":18009.879999999997},13507.41,"3%"]
["WATER ",8200,11790,982.5,10920,7280.92,"8%"]
["GAS",7450,6170,514.16666666666663,5927.0133333333342,4445.26,"4%"]
["SEWER ",5760,6180,515,7467.7333333333336,5600.8,"5% Clear Crk-Sewer-Semi Annual($5020.yr)   Arvada-Wastewtr- Bi Monthly $860.yr)"]
["TOTAL OPERATING",{"$f":"SUM(B53:B56)","v":40770},{"$f":"SUM(C53:C56)","v":42690.176399999997},{"$f":"SUM(D53:D56)","v":3557.5146999999993},{"$f":"SUM(E53:E56)","v":42324.626666666663},{"$f":"SUM(F53:F56)","v":30834.390000000003}]
[]
["MAINTENANCE EXPENDITURES"]
["JANITORIAL CONTRACT & SUPPLIES",2580,2500,{"$f":"C60/12","v":208.33333333333334},{"$f":"F60/9*12","v":2313.333333333333},1735,"3% + Laundry $40wk($2080.yr) &  $420. for turnovers"]
["EXTERMINATION",2000,2000,166.66666666666666,264,198,"Estimate for general treatment $2000 "]
["TRASH REMOVAL",2660,2750,229.16666666666666,2604.4,1953.3,"4% Increase + Contract $211.70 month($2540.yr) plus $100 extra for additional pickups"]
["GROUNDS CONTRACT",8100,8990,749.16666666666663,7665.5466666666671,5749.16,"3% & Contract $160. wk x 30wks $4800. & $1000.Sprinklers & $500.landscape & $2500 Tree Trim"]
["REPAIR MATERIALS",14500,13320,1110,12933.333333333334,9700,"3.%                                       minus $500. for shed buildout."]
["REPAIR CONTRACT ",15130,14450,1204.1666666666667,10532.666666666666,7899.5,"3%    Boiler cleaning $1000. & Concrete work on sidewalks $3,500  minus $1000 shed build out"]
["CARPET & VINYL/PLANK",4500,3300,1470,1773.1466666666665,1329.86,"3%    3 Units Carpet/Vinyl   @ $1,100. ea"]
["APPLIANCES ",1470,2060,171.66666666666666,1974.6666666666665,1481,"2 Refrigerators @$570.ea  &  2 Stoves @ $460"]
["REPAIR PAYROLL",22430,23900,{"$f":"C68/12","v":1991.6666666666667},23206.666666666668,17405]
["SNOW REMOVAL",6700,6280,{"$f":"C69/12","v":523.33333333333337},2906.666666666667,2180,"                6 yr average x 10 snow days"]
["CABINETS & FURNITURE",0,3000,{"$f":"C70/12","v":250},0,0,"2 Units Cabinets @$1,500 ea"]
["SECURITY CONTRACT",6380,6330,{"$f":"C71/12","v":527.5},6138.9199999999992,4604.1899999999996]
["TOTAL MAINTENANCE",{"$f":"SUM(B60:B71)","v":86450},{"$f":"SUM(C60:C71)","v":88880},{"$f":"SUM(D60:D71)","v":8601.6666666666679},72313.346666666665,54235.01]
[]
["GENERAL"," "," "," "]
["PAYROLL TAXES",4050,4170,{"$f":"C75/12","v":347.5},{"$f":"F75/9*12","v":4012.24},3009.18,"7.65% of Payroll    "]
["PROP & LIAB. INSURANCE ",10710,{"$f":"E76+E76*3.5%","v":12849.525},1070.79375,12415,12414.72,"3.5% for General Liability No Increase in Property Liability"]
["EMPLOYEE BENEFITS",15860,16340,1361.6666666666667,12452.693333333335,9339.52,"30.% of payroll - Health, Dental, CCOERA"]
["WORKMEN'S COMPENSATION",1590,1630,135.83333333333334,2383.2933333333335,1787.47,"3.% of payroll "]
["EMPLOYEE COMPENSATION",1590,1630,135.83333333333334,0,0,"3.% of payroll "]
["BAD DEBT LOSS",2000,500,41.666666666666664,484.9466666666666,363.71,"Estimate "]
["LOSS ON DISPOSAL FIXED ASSETS",230,500,41.666666666666664,211.28000000000003,158.46,"Estimate "]
["DEPRECIATION EXPENSE ",60500,61500,5125,59720,45048.18]
["OTHER INTERST PAID",0,10,0.83333333333333337,{"$f":"F83/9*12","v":0},0,"Estimate     2% paid to Tenant on deposit refund  at move out - per lease"]
["TOTAL GENERAL EXPENSE",{"$f":"SUM(B75:B83)","v":96530},{"$f":"SUM(C75:C83)","v":99129.524999999994},{"$f":"SUM(D75:D83)","v":8260.7937500000007},91679.453333333338,72121.239999999991]
[]
["FINANCING"]
["MORTGAGE INTEREST",67070,63940,{"$f":"C87/12","v":5328.333333333333},69680,56089.440000000002,"2016 Amortization Schedule"]
["MORTGAGE PRINCIPAL",56700,59830,4985.833333333333,54090,47045.56]
["TOTAL FINANCING",{"$f":"SUM(B87:B88)","v":123770},{"$f":"SUM(C87:C88)","v":123770},{"$f":"SUM(D87:D88)","v":10314.166666666666},{"$f":"SUM(E87:E88)","v":123770},{"$f":"SUM(F87:F88)","v":103135}]
[null," "," "," "]
["RESERVES"," "," "," "]
["REPLACEMENT RESERVES ",15600,15600,{"$f":"C92/12","v":1300},{"$f":"F92/9*12","v":15600},11700]
["TOTAL RESERVES",{"$f":"B92","v":15600},{"$f":"C92","v":15600},{"$f":"SUM(D92)","v":1300},{"$f":"E92","v":15600},{"$f":"F92","v":11700}]
[null," "," "," "]
["CAPITAL EXPENDITURES"," "," "," "]
["LAND & IMPROVEMENTS",0,0,{"$f":"C96/12","v":0},0,0]
["BUILDING ",0,0,0,0,0]
["BUILDING IMPROVEMENTS",0,0,{"$f":"C98/12","v":0},0,0]
["BLDG. EQUIP. FIXED",3000,0,0,0,0]
["BLDG. EQUIP. PORTABLE",0,0,0,{"$f":"F100/9","v":0},0]
["FURNISHINGS",0,0,0,0,0]
["MISC. FIXED ASSETS",2500,0,0,6618,6617.85]
["TOTAL CAPITAL EXP.",{"$f":"SUM(B96:B102)","v":5500},{"$f":"SUM(C96:C102)","v":0},{"$f":"SUM(D96:D102)","v":0},{"$f":"SUM(E96:E102)","v":6618},{"$f":"SUM(F96:F102)","v":6617.85}]
[]
["TOTAL EXPENDITURES",{"$f":"SUM(B103+B93+B89+B84+B72+B57+B50)","v":429890},{"$f":"SUM(C103+C93+C89+C84+C72+C57+C50)","v":431159.70140000002},{"$f":"SUM(D103+D93+D89+D84+D72+D57+D50)","v":37124.975116666668},{"$f":"SUM(E103+E93+E89+E84+E72+E57+E50)","v":411622.73333333328},{"$f":"SUM(F103+F93+F89+F84+F72+F57+F50)","v":324528.17}]
[]
["NET INCOME (LOSS)",{"$f":"SUM(B22-B105)","v":-76670},{"$f":"SUM(C22-C105)","v":-65731.70140000002},{"$f":"SUM(D22-D105)","v":-6672.6417833333362},{"$f":"SUM(E22-E105)","v":-54828.039999999921},{"$f":"SUM(F22-F105)","v":-59886.489999999991}]
[]
["DEPRECIATION INCLUDED ABOVE",{"$f":"B82","v":60500},{"$f":"C82","v":61500},{"$f":"D82","v":5125},{"$f":"E82","v":59720},{"$f":"F82","v":45048.18}]
[]
["NET INCOME(LOSS) AFTER DEPRECIATION",{"$f":"B107+B109","v":-16170},{"$f":"C107+C109","v":-4231.7014000000199},-1547.6417833333362,4891.9600000000792,-14838.30999999999]

{"sheet":"Sheet1","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}