{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Total Consolidated ","Consolidated for board","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":12,"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 2016 OPERATING BUDGET"]
[]
[null,null,null,null,null,null,null,"Actual","Actual"]
[null,null,"Budget",null,"Budget","Budget",null,null,"YTD "]
[null,null,"FY 2015",null,"FY 2016","FY 2016",null,"FY 2015","FY 2015"]
[null,null,"ANNUAL",null,"ANNUAL","Monthly",null,"12MO Esitmate","at 9/30/15"]
[]
["OPERATING RECEIPTS-TOTAL"]
["ORCHARD VALLEY ",null,{"$f":"'Orchard Valley'!B22","v":288360},null,{"$f":"'Orchard Valley'!C22","v":288750},{"$f":"'Orchard Valley'!D22","v":24062.500000000004},null,{"$f":"'Orchard Valley'!E22","v":291164.30666666676},{"$f":"'Orchard Valley'!F22","v":218373.22999999998}]
["RESPITE",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["UPHAM",null,{"$f":"UPHAM!B22","v":110200},null,{"$f":"UPHAM!C22","v":123330},{"$f":"UPHAM!D22","v":9177.4999999999982},null,{"$f":"UPHAM!E22","v":124075.45333333334},{"$f":"UPHAM!F22","v":93056.59}]
["WEST 40TH",null,{"$f":"'west 40'!B22","v":77030},null,{"$f":"'west 40'!C22","v":75230},{"$f":"'west 40'!D22","v":6269.1666666666679},null,{"$f":"'west 40'!E22","v":67333.266666666663},{"$f":"'west 40'!F22","v":50499.950000000004}]
["WHEAT RIDGE PARK",null,{"$f":"'WRP '!B22","v":169900},null,{"$f":"'WRP '!C22","v":163010},{"$f":"'WRP '!D22","v":13584.166666666668},null,{"$f":"'WRP '!E22","v":159028.89333333331},{"$f":"'WRP '!F22","v":119271.67}]
["HILLTOP",null,{"$f":"'Hilltop '!B23","v":284630},null,{"$f":"'Hilltop '!C23","v":299610},{"$f":"'Hilltop '!D23","v":24967.500000000004},null,{"$f":"'Hilltop '!E23","v":291359.60000000009},{"$f":"'Hilltop '!F23","v":218519.7}]
["WEST 46TH",null,{"$f":"'west 46 '!B21","v":88380},null,{"$f":"'west 46 '!C21","v":79680},{"$f":"'west 46 '!D21","v":6640},null,{"$f":"'west 46 '!E21","v":66842.600000000006},{"$f":"'west 46 '!F21","v":50131.95}]
["ARVADA COTTAGES",null,{"$f":"'Arvada Cottages '!B20","v":273750},null,{"$f":"'Arvada Cottages '!C20","v":251070},{"$f":"'Arvada Cottages '!D20","v":20922.5},null,{"$f":"'Arvada Cottages '!E20","v":270207.70666666661},{"$f":"'Arvada Cottages '!F20","v":202655.78}]
["ALLISON VILLAGE",null,{"$f":"'Allison Village'!B18","v":362970},null,{"$f":"'Allison Village'!C18","v":353220},{"$f":"'Allison Village'!D18","v":29435.000000000004},null,{"$f":"'Allison Village'!E18","v":340237.48},{"$f":"'Allison Village'!F18","v":253578.37999999998}]
["DISPERSED HOUSING",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["TOTAL OPERATING RECEIPTS",null,{"$f":"'Consolidated for board'!C21","v":1655220},null,{"$f":"'Consolidated for board'!E21","v":1633900},{"$f":"'Consolidated for board'!F21","v":135058.33333333334},null,{"$f":"'Consolidated for board'!H21","v":1610249.3066666669},{"$f":"'Consolidated for board'!I21","v":1206087.2499999998}]
[]
["OPERATING EXPENDITURES"]
["ORCHARD VALLEY ",null,{"$f":"'Orchard Valley'!B32","v":332155},null,{"$f":"'Orchard Valley'!D32","v":29295.031877777779},{"$f":"'Orchard Valley'!E32","v":380268.95333333337},null,{"$f":"'Orchard Valley'!G32","v":0},{"$f":"'Orchard Valley'!#REF!","v":{"$error":"#REF!"}}]
["RESPITE",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["UPHAM",null,{"$f":"UPHAM!B32","v":124840},null,{"$f":"UPHAM!D32","v":11693.315288888889},{"$f":"UPHAM!E32","v":110564.69333333333},null,{"$f":"UPHAM!G32","v":0},{"$f":"UPHAM!#REF!","v":{"$error":"#REF!"}}]
["WEST 40TH",null,{"$f":"'west 40'!B32","v":90140},null,{"$f":"'west 40'!D32","v":7783.3441555555555},{"$f":"'west 40'!E32","v":83036.053333333344},null,{"$f":"'west 40'!G32","v":0},{"$f":"'west 40'!#REF!","v":{"$error":"#REF!"}}]
["WHEAT RIDGE PARK",null,{"$f":"'WRP '!B32","v":196810},null,{"$f":"'WRP '!D32","v":15804.988944444443},{"$f":"'WRP '!E32","v":177222.19999999998},null,{"$f":"'WRP '!G32","v":0},{"$f":"'WRP '!#REF!","v":{"$error":"#REF!"}}]
["HILLTOP",null,{"$f":"'Hilltop '!B33","v":341390},null,{"$f":"'Hilltop '!D33","v":31084.14954888889},{"$f":"'Hilltop '!E33","v":326322.31222222222},null,{"$f":"'Hilltop '!G33","v":0},{"$f":"'Hilltop '!H33","v":0}]
["WEST 46TH",null,{"$f":"'west 46 '!B31","v":99870},null,{"$f":"'west 46 '!D31","v":8700.862222222222},{"$f":"'west 46 '!E31","v":88466.96},null,{"$f":"'west 46 '!G31","v":0},{"$f":"'west 46 '!#REF!","v":{"$error":"#REF!"}}]
["ARVADA COTTAGES",null,{"$f":"'Arvada Cottages '!B30","v":322793},null,{"$f":"'Arvada Cottages '!D30","v":27641.653411111114},{"$f":"'Arvada Cottages '!E30","v":301896.52666666667},null,{"$f":"'Arvada Cottages '!G30","v":0},{"$f":"'Arvada Cottages '!#REF!","v":{"$error":"#REF!"}}]
["ALLISON VILLAGE",null,{"$f":"'Allison Village'!B28","v":423770},null,{"$f":"'Allison Village'!D28","v":36919.180262222224},{"$f":"'Allison Village'!E28","v":408498.37777777773},null,{"$f":"'Allison Village'!G28","v":0},{"$f":"'Allison Village'!#REF!","v":{"$error":"#REF!"}}]
["DISPERSED HOUSING",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["TOTAL OPERATING EXPENSE",null,{"$f":"'Consolidated for board'!C33","v":1931768},null,{"$f":"'Consolidated for board'!E33","v":2013930.3085333335},{"$f":"'Consolidated for board'!F33","v":168922.52571111111},null,{"$f":"'Consolidated for board'!H33","v":163460.66555555552},{"$f":"'Consolidated for board'!I33","v":1471145.9899999998}]
["NET INCOME",null,{"$f":"SUM(C23-C37)","v":-276548},null,{"$f":"SUM(E23-E37)","v":-380030.30853333347},{"$f":"SUM(F23-F37)","v":-33864.19237777777},null,{"$f":"SUM(H23-H37)","v":1446788.6411111113},{"$f":"SUM(I23-I37)","v":-265058.74}]
[]
[]
[]
["ADMINISTRATIVE EXPENDITURES"]
["ORCHARD VALLEY ",null,{"$f":"'Orchard Valley'!B49","v":33910},null,{"$f":"'Orchard Valley'!D49","v":2891.6918777777773},{"$f":"'Orchard Valley'!E49","v":34509.346666666665},null,{"$f":"'Orchard Valley'!G49","v":0},{"$f":"'Orchard Valley'!#REF!","v":{"$error":"#REF!"}}]
["RESPITE",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["UPHAM",null,{"$f":"UPHAM!B48","v":21630},null,{"$f":"UPHAM!D48","v":2038.3333333333335},{"$f":"UPHAM!E48","v":22976.560000000001},null,{"$f":"UPHAM!G48","v":0},{"$f":"UPHAM!#REF!","v":{"$error":"#REF!"}}]
["WEST 40TH",null,{"$f":"'west 40'!B48","v":5200},null,{"$f":"'west 40'!D48","v":536.66859999999997},{"$f":"'west 40'!E48","v":5409.1333333333341},null,{"$f":"'west 40'!G48","v":0},{"$f":"'west 40'!#REF!","v":{"$error":"#REF!"}}]
["WHEAT RIDGE PARK",null,{"$f":"'WRP '!B48","v":21470},null,{"$f":"'WRP '!D48","v":1953.3333333333333},{"$f":"'WRP '!E48","v":21427.853333333333},null,{"$f":"'WRP '!G48","v":0},{"$f":"'WRP '!#REF!","v":{"$error":"#REF!"}}]
["HILLTOP",null,{"$f":"'Hilltop '!B49","v":33650},null,{"$f":"'Hilltop '!D49","v":3004.1847222222218},{"$f":"'Hilltop '!E49","v":35005.573333333334},null,{"$f":"'Hilltop '!G49","v":0},{"$f":"'Hilltop '!H49","v":0}]
["WEST 46TH",null,{"$f":"'west 46 '!B45","v":4530},null,{"$f":"'west 46 '!D45","v":487.52888888888896},{"$f":"'west 46 '!E45","v":4854.0933333333342},null,{"$f":"'west 46 '!G45","v":0},{"$f":"'west 46 '!#REF!","v":{"$error":"#REF!"}}]
["ARVADA COTTAGES",null,{"$f":"'Arvada Cottages '!B47","v":28190},null,{"$f":"'Arvada Cottages '!D47","v":2269.1534111111109},{"$f":"'Arvada Cottages '!E47","v":26391.546666666669},null,{"$f":"'Arvada Cottages '!G47","v":0},{"$f":"'Arvada Cottages '!#REF!","v":{"$error":"#REF!"}}]
["ALLISON VILLAGE",null,{"$f":"'Allison Village'!B46","v":59910},null,{"$f":"'Allison Village'!D46","v":5105.8333333333321},{"$f":"'Allison Village'!E46","v":62410.306666666664},null,{"$f":"'Allison Village'!G46","v":0},{"$f":"'Allison Village'!#REF!","v":{"$error":"#REF!"}}]
["DISPERSED HOUSING",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["TOTAL ADMINISTRATIVE",null,{"$f":"'Consolidated for board'!C49","v":208490},null,{"$f":"'Consolidated for board'!E49","v":219440.73},{"$f":"'Consolidated for board'!F49","v":18286.727499999997},null,{"$f":"'Consolidated for board'!H49","v":212984.41333333333},{"$f":"'Consolidated for board'!I49","v":159738.31}]
[]
["OPERATING EXPENDITURES"]
["ORCHARD VALLEY ",null,{"$f":"'Orchard Valley'!B56","v":43490},null,{"$f":"'Orchard Valley'!D56","v":3727.5066666666671},{"$f":"'Orchard Valley'!E56","v":42918.166666666664},null,{"$f":"'Orchard Valley'!G56","v":0},{"$f":"'Orchard Valley'!#REF!","v":{"$error":"#REF!"}}]
["RESPITE",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["UPHAM",null,{"$f":"UPHAM!B55","v":15230},null,{"$f":"UPHAM!D55","v":1251.6666666666665},{"$f":"UPHAM!E55","v":13120.08},null,{"$f":"UPHAM!G55","v":0},{"$f":"UPHAM!#REF!","v":{"$error":"#REF!"}}]
["WEST 40TH",null,{"$f":"'west 40'!B55","v":9250},null,{"$f":"'west 40'!D55","v":672.50000000000011},{"$f":"'west 40'!E55","v":7717.6533333333336},null,{"$f":"'west 40'!G55","v":0},{"$f":"'west 40'!#REF!","v":{"$error":"#REF!"}}]
["WHEAT RIDGE PARK",null,{"$f":"'WRP '!B55","v":16370},null,{"$f":"'WRP '!D55","v":1334.1711666666667},{"$f":"'WRP '!E55","v":15349.08},null,{"$f":"'WRP '!G55","v":0},{"$f":"'WRP '!#REF!","v":{"$error":"#REF!"}}]
["HILLTOP",null,{"$f":"'Hilltop '!B56","v":17280},null,{"$f":"'Hilltop '!D56","v":1431.6603822222223},{"$f":"'Hilltop '!E56","v":16520.946666666667},null,{"$f":"'Hilltop '!G56","v":0},{"$f":"'Hilltop '!H56","v":0}]
["WEST 46TH",null,{"$f":"'west 46 '!B52","v":5670},null,{"$f":"'west 46 '!D52","v":376.66666666666669},{"$f":"'west 46 '!E52","v":3576.04},null,{"$f":"'west 46 '!G52","v":0},{"$f":"'west 46 '!#REF!","v":{"$error":"#REF!"}}]
["ARVADA COTTAGES",null,{"$f":"'Arvada Cottages '!B54","v":21860},null,{"$f":"'Arvada Cottages '!D54","v":1460.8333333333335},{"$f":"'Arvada Cottages '!E54","v":16476.646666666667},null,{"$f":"'Arvada Cottages '!G54","v":0},{"$f":"'Arvada Cottages '!#REF!","v":{"$error":"#REF!"}}]
["ALLISON VILLAGE",null,{"$f":"'Allison Village'!B53","v":47820},null,{"$f":"'Allison Village'!D53","v":3397.4727622222217},{"$f":"'Allison Village'!E53","v":39166.239999999998},null,{"$f":"'Allison Village'!G53","v":0},{"$f":"'Allison Village'!#REF!","v":{"$error":"#REF!"}}]
["DISPERSED HOUSING",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["TOTAL OPERATING",null,{"$f":"'Consolidated for board'!C61","v":176970},null,{"$f":"'Consolidated for board'!E61","v":163829.73173333335},{"$f":"'Consolidated for board'!F61","v":13652.477644444445},null,{"$f":"'Consolidated for board'!H61","v":154844.85333333333},{"$f":"'Consolidated for board'!I61","v":117788.83}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["MAINTENANCE EXPENDITURES",null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["ORCHARD VALLEY ",null,{"$f":"'Orchard Valley'!B69","v":33230},null,{"$f":"'Orchard Valley'!D69","v":5485.833333333333},{"$f":"'Orchard Valley'!E69","v":49951.46666666666},null,{"$f":"'Orchard Valley'!G69","v":0},{"$f":"'Orchard Valley'!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["RESPITE",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["UPHAM",null,{"$f":"UPHAM!B68","v":32930},null,{"$f":"UPHAM!D68","v":3978.315288888889},{"$f":"UPHAM!E68","v":27719.373333333333},null,{"$f":"UPHAM!G68","v":0},{"$f":"UPHAM!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["WEST 40TH",null,{"$f":"'west 40'!B69","v":22400},null,{"$f":"'west 40'!D69","v":2787.5088888888886},{"$f":"'west 40'!E69","v":21140.306666666667},null,{"$f":"'west 40'!G69","v":0},{"$f":"'west 40'!#REF!","v":{"$error":"#REF!"}}]
["WHEAT RIDGE PARK",null,{"$f":"'WRP '!B69","v":44400},null,{"$f":"'WRP '!D69","v":4138.3177777777773},{"$f":"'WRP '!E69","v":39293.773333333331},null,{"$f":"'WRP '!G69","v":0},{"$f":"'WRP '!#REF!","v":{"$error":"#REF!"}}]
["HILLTOP",null,{"$f":"'Hilltop '!B69","v":36240},null,{"$f":"'Hilltop '!D69","v":6284.137777777778},{"$f":"'Hilltop '!E69","v":49946.240000000005},null,{"$f":"'Hilltop '!G69","v":0},{"$f":"'Hilltop '!H69","v":0},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["WEST 46TH",null,{"$f":"'west 46 '!B65","v":15910},null,{"$f":"'west 46 '!D65","v":2400.8333333333335},{"$f":"'west 46 '!E65","v":17771.32},null,{"$f":"'west 46 '!G65","v":0},{"$f":"'west 46 '!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["ARVADA COTTAGES",null,{"$f":"'Arvada Cottages '!B67","v":46580},null,{"$f":"'Arvada Cottages '!D67","v":4181.666666666667},{"$f":"'Arvada Cottages '!E67","v":38159.773333333331},null,{"$f":"'Arvada Cottages '!G67","v":0},{"$f":"'Arvada Cottages '!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["ALLISON VILLAGE",null,{"$f":"'Allison Village'!B67","v":62020},null,{"$f":"'Allison Village'!D67","v":8299.2075000000004},{"$f":"'Allison Village'!E67","v":72584.08},null,{"$f":"'Allison Village'!G67","v":0},{"$f":"'Allison Village'!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["DISPERSED HOUSING",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
[]
["TOTAL MAINTENANCE",null,{"$f":"'Consolidated for board'!C74","v":293710},null,{"$f":"'Consolidated for board'!E74","v":437529.8468},{"$f":"'Consolidated for board'!F74","v":37555.820566666669},null,{"$f":"'Consolidated for board'!H74","v":316566.33333333331},{"$f":"'Consolidated for board'!I74","v":237242.70999999996},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["GENERAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["ORCHARD VALLEY ",null,{"$f":"'Orchard Valley'!B80","v":88825},null,{"$f":"'Orchard Valley'!D80","v":7473.333333333333},{"$f":"'Orchard Valley'!E80","v":84821.186666666676},null,{"$f":"'Orchard Valley'!G80","v":0},{"$f":"'Orchard Valley'!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["RESPITE",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["UPHAM",null,{"$f":"UPHAM!B79","v":38950},null,{"$f":"UPHAM!D79","v":4025},{"$f":"UPHAM!E79","v":37957.199999999997},null,{"$f":"UPHAM!G79","v":0},{"$f":"UPHAM!#REF!","v":{"$error":"#REF!"}}]
["WEST 40TH",null,{"$f":"'west 40'!B80","v":17890},null,{"$f":"'west 40'!D80","v":1561.6666666666667},{"$f":"'west 40'!E80","v":15139.92},null,{"$f":"'west 40'!G80","v":0},{"$f":"'west 40'!#REF!","v":{"$error":"#REF!"}}]
["WHEAT RIDGE PARK",null,{"$f":"'WRP '!B80","v":49500},null,{"$f":"'WRP '!D80","v":4370},{"$f":"'WRP '!E80","v":47477.493333333332},null,{"$f":"'WRP '!G80","v":0},{"$f":"'WRP '!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["HILLTOP",null,{"$f":"'Hilltop '!B80","v":85510},null,{"$f":"'Hilltop '!D80","v":7334.1666666666661},{"$f":"'Hilltop '!E80","v":82807.973333333328},null,{"$f":"'Hilltop '!G80","v":0},{"$f":"'Hilltop '!H80","v":0},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["WEST 46TH",null,{"$f":"'west 46 '!B76","v":22810},null,{"$f":"'west 46 '!D76","v":2064.166666666667},{"$f":"'west 46 '!E76","v":21240.506666666668},null,{"$f":"'west 46 '!G76","v":0},{"$f":"'west 46 '!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["ARVADA COTTAGES",null,{"$f":"'Arvada Cottages '!B79","v":67173},null,{"$f":"'Arvada Cottages '!D79","v":5808.3333333333339},{"$f":"'Arvada Cottages '!E79","v":64492.56},null,{"$f":"'Arvada Cottages '!G79","v":0},{"$f":"'Arvada Cottages '!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["ALLISON VILLAGE",null,{"$f":"'Allison Village'!B78","v":97180},null,{"$f":"'Allison Village'!D78","v":8044.166666666667},{"$f":"'Allison Village'!E78","v":87435.973333333328},null,{"$f":"'Allison Village'!G78","v":0},{"$f":"'Allison Village'!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["DISPERSED HOUSING",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
[]
["TOTAL GENERAL EXPENSE",null,{"$f":"'Consolidated for board'!C86","v":467838},null,{"$f":"'Consolidated for board'!E86","v":488170},{"$f":"'Consolidated for board'!F86","v":40680.833333333328},null,{"$f":"'Consolidated for board'!H86","v":441372.8133333333},{"$f":"'Consolidated for board'!I86","v":342742.62000000005},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
[]
["FINANCING",null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["ORCHARD VALLEY ",null,{"$f":"'Orchard Valley'!B85","v":108800},null,{"$f":"'Orchard Valley'!D85","v":9066.6666666666661},{"$f":"'Orchard Valley'!E85","v":120889.46666666667},null,{"$f":"'Orchard Valley'!G85","v":0},{"$f":"'Orchard Valley'!#REF!","v":{"$error":"#REF!"}}]
["RESPITE",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["UPHAM",null,{"$f":"UPHAM!B84","v":0},null,{"$f":"UPHAM!D84","v":0},{"$f":"UPHAM!E84","v":0},null,{"$f":"UPHAM!G84","v":"No Mortgage"},{"$f":"UPHAM!#REF!","v":{"$error":"#REF!"}}]
["WEST 40TH",null,{"$f":"'west 40'!B86","v":23100},null,{"$f":"'west 40'!D86","v":1925},{"$f":"'west 40'!E86","v":23094.6},null,{"$f":"'west 40'!G86","v":0},{"$f":"'west 40'!#REF!","v":{"$error":"#REF!"}}]
["WHEAT RIDGE PARK",null,{"$f":"'WRP '!B85","v":43310},null,{"$f":"'WRP '!D85","v":3609.1666666666665},{"$f":"'WRP '!E85","v":48123.333333333328},null,{"$f":"'WRP '!G85","v":0},{"$f":"'WRP '!#REF!","v":{"$error":"#REF!"}}]
["HILLTOP",null,{"$f":"'Hilltop '!B85","v":130060},null,{"$f":"'Hilltop '!D85","v":10838.333333333332},{"$f":"'Hilltop '!E85","v":130060},null,{"$f":"'Hilltop '!G85","v":0},{"$f":"'Hilltop '!H85","v":0}]
["WEST 46TH",null,{"$f":"'west 46 '!B81","v":32580},null,{"$f":"'west 46 '!D81","v":2715},{"$f":"'west 46 '!E81","v":32580},null,{"$f":"'west 46 '!G81","v":0},{"$f":"'west 46 '!#REF!","v":{"$error":"#REF!"}}]
["ARVADA COTTAGES",null,{"$f":"'Arvada Cottages '!B84","v":142470},null,{"$f":"'Arvada Cottages '!D84","v":11872.5},{"$f":"'Arvada Cottages '!E84","v":142470},null,{"$f":"'Arvada Cottages '!G84","v":0},{"$f":"'Arvada Cottages '!#REF!","v":{"$error":"#REF!"}}]
["ALLISON VILLAGE",null,{"$f":"'Allison Village'!B83","v":123770},null,{"$f":"'Allison Village'!D83","v":10314.166666666668},{"$f":"'Allison Village'!E83","v":123770},null,{"$f":"'Allison Village'!G83","v":0},{"$f":"'Allison Village'!#REF!","v":{"$error":"#REF!"}}]
["DISPERSED HOUSING",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["TOTAL FINANCING",null,{"$f":"'Consolidated for board'!C99","v":604090},null,{"$f":"'Consolidated for board'!E99","v":604090},{"$f":"'Consolidated for board'!F99","v":50340.833333333328},null,{"$f":"'Consolidated for board'!H99","v":620987.4},{"$f":"'Consolidated for board'!I99","v":501472.2},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["RESERVES",null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["ORCHARD VALLEY ",null,{"$f":"'Orchard Valley'!B89","v":4800},null,{"$f":"'Orchard Valley'!D89","v":400},{"$f":"'Orchard Valley'!E89","v":4800},null,{"$f":"'Orchard Valley'!G89","v":0},{"$f":"'Orchard Valley'!#REF!","v":{"$error":"#REF!"}}]
["RESPITE",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["UPHAM",null,{"$f":"UPHAM!B88","v":4800},null,{"$f":"UPHAM!D88","v":400},{"$f":"UPHAM!E88","v":4800},null,{"$f":"UPHAM!G88","v":0},{"$f":"UPHAM!#REF!","v":{"$error":"#REF!"}}]
["WEST 40TH",null,{"$f":"'west 40'!B90","v":3600},null,{"$f":"'west 40'!D90","v":300},{"$f":"'west 40'!E90","v":3600},null,{"$f":"'west 40'!G90","v":0},{"$f":"'west 40'!#REF!","v":{"$error":"#REF!"}}]
["WHEAT RIDGE PARK",null,{"$f":"'WRP '!B89","v":4800},null,{"$f":"'WRP '!D89","v":400},{"$f":"'WRP '!E89","v":4800},null,{"$f":"'WRP '!G89","v":0},{"$f":"'WRP '!#REF!","v":{"$error":"#REF!"}}]
["HILLTOP",null,{"$f":"'Hilltop '!B89","v":3600},null,{"$f":"'Hilltop '!D89","v":300},{"$f":"'Hilltop '!E89","v":3600},null,{"$f":"'Hilltop '!G89","v":0},{"$f":"'Hilltop '!H89","v":0}]
["WEST 46TH",null,{"$f":"'west 46 '!B85","v":5400},null,{"$f":"'west 46 '!D85","v":450},{"$f":"'west 46 '!E85","v":5400},null,{"$f":"'west 46 '!G85","v":0},{"$f":"'west 46 '!#REF!","v":{"$error":"#REF!"}}]
["ARVADA COTTAGES",null,{"$f":"'Arvada Cottages '!B88","v":2400},null,{"$f":"'Arvada Cottages '!D88","v":200},{"$f":"'Arvada Cottages '!E88","v":2400},null,{"$f":"'Arvada Cottages '!G88","v":0},{"$f":"'Arvada Cottages '!#REF!","v":{"$error":"#REF!"}}]
["ALLISON VILLAGE",null,{"$f":"'Allison Village'!B87","v":15600},null,{"$f":"'Allison Village'!D87","v":1300},{"$f":"'Allison Village'!E87","v":15600},null,{"$f":"'Allison Village'!G87","v":0},{"$f":"'Allison Village'!#REF!","v":{"$error":"#REF!"}}]
["DISPERSED HOUSING",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["TOTAL RESERVES",null,{"$f":"'Consolidated for board'!C111","v":45000},null,{"$f":"'Consolidated for board'!E111","v":45000},{"$f":"'Consolidated for board'!F111","v":3750},null,{"$f":"'Consolidated for board'!H111","v":45000},{"$f":"'Consolidated for board'!I111","v":33750},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["CAPITAL EXPENDITURES",null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["ORCHARD VALLEY ",null,{"$f":"'Orchard Valley'!B99","v":19100},null,{"$f":"'Orchard Valley'!D99","v":250},{"$f":"'Orchard Valley'!E99","v":42379.32},null,{"$f":"'Orchard Valley'!G99","v":0},{"$f":"'Orchard Valley'!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["RESPITE",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["UPHAM",null,{"$f":"UPHAM!B98","v":11300},null,{"$f":"UPHAM!D98","v":0},{"$f":"UPHAM!E98","v":3991.4799999999996},null,{"$f":"UPHAM!G98","v":0},{"$f":"UPHAM!#REF!","v":{"$error":"#REF!"}}]
["WEST 40TH",null,{"$f":"'west 40'!B100","v":8700},null,{"$f":"'west 40'!D100","v":0},{"$f":"'west 40'!E100","v":6934.44},null,{"$f":"'west 40'!G100","v":0},{"$f":"'west 40'!#REF!","v":{"$error":"#REF!"}}]
["WHEAT RIDGE PARK",null,{"$f":"'WRP '!B99","v":16960},null,{"$f":"'WRP '!D99","v":0},{"$f":"'WRP '!E99","v":750.66666666666674},null,{"$f":"'WRP '!G99","v":0},{"$f":"'WRP '!#REF!","v":{"$error":"#REF!"}}]
["HILLTOP",null,{"$f":"'Hilltop '!B99","v":35050},null,{"$f":"'Hilltop '!D99","v":1891.6666666666665},{"$f":"'Hilltop '!E99","v":8381.5788888888892},null,{"$f":"'Hilltop '!G99","v":0},{"$f":"'Hilltop '!H99","v":0}]
["WEST 46TH",null,{"$f":"'west 46 '!B94","v":12970},null,{"$f":"'west 46 '!D94","v":206.66666666666666},{"$f":"'west 46 '!E94","v":3045},null,{"$f":"'west 46 '!G94","v":0},{"$f":"'west 46 '!#REF!","v":{"$error":"#REF!"}}]
["ARVADA COTTAGES",null,{"$f":"'Arvada Cottages '!B98","v":14120},null,{"$f":"'Arvada Cottages '!D98","v":1849.1666666666665},{"$f":"'Arvada Cottages '!E98","v":11506},null,{"$f":"'Arvada Cottages '!G98","v":0},{"$f":"'Arvada Cottages '!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["ALLISON VILLAGE",null,{"$f":"'Allison Village'!B97","v":17470},null,{"$f":"'Allison Village'!D97","v":458.33333333333337},{"$f":"'Allison Village'!E97","v":7531.7777777777774},null,{"$f":"'Allison Village'!G97","v":0},{"$f":"'Allison Village'!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["DISPERSED HOUSING",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
[]
["TOTAL CAPITAL EXP.",null,{"$f":"'Consolidated for board'!C123","v":135670},null,{"$f":"'Consolidated for board'!E123","v":55870},{"$f":"'Consolidated for board'!F123","v":4655.833333333333},null,{"$f":"'Consolidated for board'!H123","v":84520.263333333336},{"$f":"'Consolidated for board'!I123","v":78411.319999999992}]
[]
[]
["TOTAL EXPENDITURES",null,{"$f":"SUM(C140+C126+C112+C97+C83+C68+C54)","v":1931768},null,{"$f":"SUM(E140+E126+E112+E97+E83+E68+E54)","v":2013930.3085333332},{"$f":"SUM(F140+F126+F112+F97+F83+F68+F54)","v":168922.52571111111},null,{"$f":"SUM(H140+H126+H112+H97+H83+H68+H54)","v":1876276.0766666664},{"$f":"SUM(I140+I126+I112+I97+I83+I68+I54)","v":1471145.9900000002}]
[]
["NET GAIN/(LOSS)",null,{"$f":"SUM(C23-C143)","v":-276548},null,{"$f":"SUM(E23-E143)","v":-380030.30853333324},{"$f":"SUM(F23-F143)","v":-33864.19237777777},null,{"$f":"SUM(H23-H143)","v":-266026.76999999955},{"$f":"SUM(I23-I143)","v":-265058.74000000046}]
[]
[]
["DEPRECIATION INCLUDED IN GENERAL EXP.",null,{"$f":"'Consolidated for board'!C131","v":327211},null,{"$f":"'Consolidated for board'!E131","v":338260},{"$f":"'Consolidated for board'!F131","v":28188.333333333336},null,{"$f":"'Consolidated for board'!H131","v":325048.28000000003},{"$f":"'Consolidated for board'!I131","v":240284.99}]
[]
["NET INCOME(LOSS) AFTER DEPRCIATION",null,{"$f":"SUM(C145:C149)","v":50663},null,{"$f":"SUM(E145:E149)","v":-41770.308533333242},{"$f":"SUM(F145:F149)","v":-5675.8590444444344},null,{"$f":"SUM(H145:H149)","v":59021.510000000475},{"$f":"SUM(I145:I149)","v":-24773.750000000466}]

{"sheet":"Consolidated for board","index":1,"n_rows":133,"n_cols":13,"rows_kept":133,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"JEFFCO HOUSING CORPORATION"]
[null,null,null,null,"CONSOLIDATED"]
[null,null,null,null,"FY 2016 OPERATING BUDGET"]
[]
[null,null,null,null,null,null,null,"Actual","Actual"]
[null,null,"Budget",null,"Budget","Budget",null,null,"YTD "]
[null,null,"FY 2015",null,"FY 2016","FY 2016",null,"FY 2015","FY 2015"]
[null,null,"ANNUAL",null,"ANNUAL","Monthly",null,"12MO Estimate","at 9/30/15"]
[]
["OPERATING RECEIPTS-TOTAL"]
["ORCHARD VALLEY ",null,{"$f":"'Orchard Valley'!B22","v":288360},null,{"$f":"'Orchard Valley'!C22","v":288750},{"$f":"'Orchard Valley'!D22","v":24062.500000000004},null,{"$f":"'Orchard Valley'!E22","v":291164.30666666676},{"$f":"'Orchard Valley'!F22","v":218373.22999999998}]
["UPHAM & RESPITE",null,{"$f":"UPHAM!B22","v":110200},null,{"$f":"UPHAM!C22","v":123330},{"$f":"UPHAM!D22","v":9177.4999999999982},null,{"$f":"UPHAM!E22","v":124075.45333333334},{"$f":"UPHAM!F22","v":93056.59}]
["WEST 40TH",null,{"$f":"'west 40'!B22","v":77030},null,{"$f":"'west 40'!C22","v":75230},{"$f":"'west 40'!D22","v":6269.1666666666679},null,{"$f":"'west 40'!E22","v":67333.266666666663},{"$f":"'west 40'!F22","v":50499.950000000004}]
["WHEAT RIDGE PARK",null,{"$f":"'WRP '!B22","v":169900},null,{"$f":"'WRP '!C22","v":163010},{"$f":"'WRP '!D22","v":13584.166666666668},null,{"$f":"'WRP '!E22","v":159028.89333333331},{"$f":"'WRP '!F22","v":119271.67}]
["HILLTOP",null,{"$f":"'Hilltop '!B23","v":284630},null,{"$f":"'Hilltop '!C23","v":299610},{"$f":"'Hilltop '!D23","v":24967.500000000004},null,{"$f":"'Hilltop '!E23","v":291359.60000000009},{"$f":"'Hilltop '!F23","v":218519.7}]
["WEST 46TH",null,{"$f":"'west 46 '!B21","v":88380},null,{"$f":"'west 46 '!C21","v":79680},{"$f":"'west 46 '!D21","v":6640},null,{"$f":"'west 46 '!E21","v":66842.600000000006},{"$f":"'west 46 '!F21","v":50131.95}]
["ARVADA COTTAGES",null,{"$f":"'Arvada Cottages '!B20","v":273750},null,{"$f":"'Arvada Cottages '!C20","v":251070},{"$f":"'Arvada Cottages '!D20","v":20922.5},null,{"$f":"'Arvada Cottages '!E20","v":270207.70666666661},{"$f":"'Arvada Cottages '!F20","v":202655.78}]
["ALLISON VILLAGE",null,{"$f":"'Allison Village'!B18","v":362970},null,{"$f":"'Allison Village'!C18","v":353220},{"$f":"'Allison Village'!D18","v":29435.000000000004},null,{"$f":"'Allison Village'!E18","v":340237.48},{"$f":"'Allison Village'!F18","v":253578.37999999998}]
[]
["TOTAL OPERATING RECEIPTS",null,{"$f":"SUM(C12:C19)","v":1655220},null,{"$f":"SUM(E12:E19)","v":1633900},{"$f":"SUM(F12:F19)","v":135058.33333333334},null,{"$f":"SUM(H12:H19)","v":1610249.3066666669},{"$f":"SUM(I12:I19)","v":1206087.2499999998}]
[]
["OPERATING EXPENDITURES"]
["ORCHARD VALLEY ",null,{"$f":"'Orchard Valley'!B32","v":332155},null,{"$f":"'Orchard Valley'!C32","v":351540.38253333332},{"$f":"'Orchard Valley'!D32","v":29295.031877777779},null,{"$f":"'Orchard Valley'!E32","v":380268.95333333337},{"$f":"'Orchard Valley'!F32","v":285311.82}]
["UPHAM & RESPITE",null,{"$f":"UPHAM!B32","v":124840},null,{"$f":"UPHAM!C32","v":140319.78346666667},{"$f":"UPHAM!D32","v":11693.315288888889},null,{"$f":"UPHAM!E32","v":110564.69333333333},{"$f":"UPHAM!F32","v":83759.81}]
["WEST 40TH",null,{"$f":"'west 40'!B32","v":90140},null,{"$f":"'west 40'!C32","v":93400.12986666667},{"$f":"'west 40'!D32","v":7783.3441555555555},null,{"$f":"'west 40'!E32","v":83036.053333333344},{"$f":"'west 40'!F32","v":61505.679999999993}]
["WHEAT RIDGE PARK",null,{"$f":"'WRP '!B32","v":196810},null,{"$f":"'WRP '!C32","v":189659.86733333333},{"$f":"'WRP '!D32","v":15804.988944444443},null,{"$f":"'WRP '!E32","v":177222.19999999998},{"$f":"'WRP '!F32","v":137152.66999999998}]
["HILLTOP",null,{"$f":"'Hilltop '!B33","v":341390},null,{"$f":"'Hilltop '!C33","v":373009.79458666669},{"$f":"'Hilltop '!D33","v":31084.14954888889},null,{"$f":"'Hilltop '!E33","v":326322.31222222222},{"$f":"'Hilltop '!F33","v":269848.95}]
["WEST 46TH",null,{"$f":"'west 46 '!B31","v":99870},null,{"$f":"'west 46 '!C31","v":104410.34666666666},{"$f":"'west 46 '!D31","v":8700.862222222222},null,{"$f":"'west 46 '!E31","v":88466.96},{"$f":"'west 46 '!F31","v":68537.240000000005}]
["ARVADA COTTAGES",null,{"$f":"'Arvada Cottages '!B30","v":322793},null,{"$f":"'Arvada Cottages '!C30","v":331699.84093333333},{"$f":"'Arvada Cottages '!D30","v":27641.653411111114},null,{"$f":"'Arvada Cottages '!E30","v":301896.52666666667},{"$f":"'Arvada Cottages '!F30","v":240505.16}]
["ALLISON VILLAGE",null,{"$f":"'Allison Village'!B28","v":423770},null,{"$f":"'Allison Village'!C28","v":429890.16314666666},{"$f":"'Allison Village'!D28","v":36919.180262222224},null,{"$f":"'Allison Village'!E28","v":408498.37777777773},{"$f":"'Allison Village'!F28","v":324524.66000000003}]
[]
["TOTAL OPERATING EXPENSE",null,{"$f":"SUM(C24:C32)","v":1931768},null,{"$f":"SUM(E24:E32)","v":2013930.3085333335},{"$f":"SUM(F24:F32)","v":168922.52571111111},null,{"$f":"I33/9","v":163460.66555555552},{"$f":"SUM(I24:I32)","v":1471145.9899999998}]
["NET INCOME",null,{"$f":"SUM(C21-C33)","v":-276548},null,{"$f":"SUM(E21-E33)","v":-380030.30853333347},{"$f":"SUM(F21-F33)","v":-33864.19237777777},null,{"$f":"SUM(H21-H33)","v":1446788.6411111113},{"$f":"SUM(I21-I33)","v":-265058.74}]
[]
[]
[]
["ADMINISTRATIVE EXPENDITURES"]
[]
["ORCHARD VALLEY ",null,{"$f":"'Orchard Valley'!B49","v":33910},null,{"$f":"'Orchard Valley'!C49","v":34700.302533333335},{"$f":"'Orchard Valley'!D49","v":2891.6918777777773},null,{"$f":"'Orchard Valley'!E49","v":34509.346666666665},{"$f":"'Orchard Valley'!F49","v":25882.01}]
["UPHAM & RESPITE",null,{"$f":"UPHAM!B48","v":21630},null,{"$f":"UPHAM!C48","v":24460},{"$f":"UPHAM!D48","v":2038.3333333333335},null,{"$f":"UPHAM!E48","v":22976.560000000001},{"$f":"UPHAM!F48","v":17232.419999999998}]
["WEST 40TH",null,{"$f":"'west 40'!B48","v":5200},null,{"$f":"'west 40'!C48","v":6440.0231999999996},{"$f":"'west 40'!D48","v":536.66859999999997},null,{"$f":"'west 40'!E48","v":5409.1333333333341},{"$f":"'west 40'!F48","v":4056.85}]
["WHEAT RIDGE PARK",null,{"$f":"'WRP '!B48","v":21470},null,{"$f":"'WRP '!C48","v":23440},{"$f":"'WRP '!D48","v":1953.3333333333333},null,{"$f":"'WRP '!E48","v":21427.853333333333},{"$f":"'WRP '!F48","v":16070.89}]
["HILLTOP",null,{"$f":"'Hilltop '!B49","v":33650},null,{"$f":"'Hilltop '!C49","v":36050.216666666667},{"$f":"'Hilltop '!D49","v":3004.1847222222218},null,{"$f":"'Hilltop '!E49","v":35005.573333333334},{"$f":"'Hilltop '!F49","v":26254.18}]
["WEST 46TH",null,{"$f":"'west 46 '!B45","v":4530},null,{"$f":"'west 46 '!C45","v":5850.3466666666664},{"$f":"'west 46 '!D45","v":487.52888888888896},null,{"$f":"'west 46 '!E45","v":4854.0933333333342},{"$f":"'west 46 '!F45","v":3640.5699999999997}]
["ARVADA COTTAGES",null,{"$f":"'Arvada Cottages '!B47","v":28190},null,{"$f":"'Arvada Cottages '!C47","v":27229.840933333329},{"$f":"'Arvada Cottages '!D47","v":2269.1534111111109},null,{"$f":"'Arvada Cottages '!E47","v":26391.546666666669},{"$f":"'Arvada Cottages '!F47","v":19793.660000000003}]
["ALLISON VILLAGE",null,{"$f":"'Allison Village'!B46","v":59910},null,{"$f":"'Allison Village'!C46","v":61270},{"$f":"'Allison Village'!D46","v":5105.8333333333321},null,{"$f":"'Allison Village'!E46","v":62410.306666666664},{"$f":"'Allison Village'!F46","v":46807.73}]
[]
["TOTAL ADMINISTRATIVE",null,{"$f":"SUM(C40:C48)","v":208490},null,{"$f":"SUM(E40:E48)","v":219440.73},{"$f":"SUM(F40:F48)","v":18286.727499999997},null,{"$f":"SUM(H40:H48)","v":212984.41333333333},{"$f":"SUM(I40:I48)","v":159738.31}]
[null,null,null,null,null,null,null," "]
["OPERATING EXPENDITURES",null,null,null,null,null,null," "]
["ORCHARD VALLEY ",null,{"$f":"'Orchard Valley'!B56","v":43490},null,{"$f":"'Orchard Valley'!C56","v":44730.080000000002},{"$f":"'Orchard Valley'!D56","v":3727.5066666666671},null,{"$f":"'Orchard Valley'!E56","v":42918.166666666664},{"$f":"'Orchard Valley'!F56","v":31049.75}]
["UPHAM & RESPITE",null,{"$f":"UPHAM!B55","v":15230},null,{"$f":"UPHAM!C55","v":15020},{"$f":"UPHAM!D55","v":1251.6666666666665},null,{"$f":"UPHAM!E55","v":13120.08},{"$f":"UPHAM!F55","v":10449.06}]
["WEST 40TH",null,{"$f":"'west 40'!B55","v":9250},null,{"$f":"'west 40'!C55","v":8070},{"$f":"'west 40'!D55","v":672.50000000000011},null,{"$f":"'west 40'!E55","v":7717.6533333333336},{"$f":"'west 40'!F55","v":6136.24}]
["WHEAT RIDGE PARK",null,{"$f":"'WRP '!B55","v":16370},null,{"$f":"'WRP '!C55","v":16010.054},{"$f":"'WRP '!D55","v":1334.1711666666667},null,{"$f":"'WRP '!E55","v":15349.08},{"$f":"'WRP '!F55","v":11547.68}]
["HILLTOP",null,{"$f":"'Hilltop '!B56","v":17280},null,{"$f":"'Hilltop '!C56","v":17179.924586666668},{"$f":"'Hilltop '!D56","v":1431.6603822222223},null,{"$f":"'Hilltop '!E56","v":16520.946666666667},{"$f":"'Hilltop '!F56","v":13859.96}]
["WEST 46TH",null,{"$f":"'west 46 '!B52","v":5670},null,{"$f":"'west 46 '!C52","v":4520},{"$f":"'west 46 '!D52","v":376.66666666666669},null,{"$f":"'west 46 '!E52","v":3576.04},{"$f":"'west 46 '!F52","v":3018.0299999999997}]
["ARVADA COTTAGES",null,{"$f":"'Arvada Cottages '!B54","v":21860},null,{"$f":"'Arvada Cottages '!C54","v":17530},{"$f":"'Arvada Cottages '!D54","v":1460.8333333333335},null,{"$f":"'Arvada Cottages '!E54","v":16476.646666666667},{"$f":"'Arvada Cottages '!F54","v":11247.38}]
["ALLISON VILLAGE",null,{"$f":"'Allison Village'!B53","v":47820},null,{"$f":"'Allison Village'!C53","v":40769.673146666661},{"$f":"'Allison Village'!D53","v":3397.4727622222217},null,{"$f":"'Allison Village'!E53","v":39166.239999999998},{"$f":"'Allison Village'!F53","v":30480.73}]
[]
["TOTAL OPERATING",null,{"$f":"SUM(C52:C60)","v":176970},null,{"$f":"SUM(E52:E60)","v":163829.73173333335},{"$f":"SUM(F52:F60)","v":13652.477644444445},null,{"$f":"SUM(H52:H60)","v":154844.85333333333},{"$f":"SUM(I52:I60)","v":117788.83}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["MAINTENANCE EXPENDITURES",null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["ORCHARD VALLEY ",null,{"$f":"'Orchard Valley'!B69","v":33230},null,{"$f":"'Orchard Valley'!C69","v":65830},{"$f":"'Orchard Valley'!D69","v":5485.833333333333},null,{"$f":"'Orchard Valley'!E69","v":49951.46666666666},{"$f":"'Orchard Valley'!F69","v":37463.600000000006},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["UPHAM & RESPITE",null,{"$f":"UPHAM!B68","v":32930},null,{"$f":"UPHAM!C68","v":47739.783466666668},{"$f":"UPHAM!D68","v":3978.315288888889},null,{"$f":"UPHAM!E68","v":27719.373333333333},{"$f":"UPHAM!F68","v":20789.53},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["WEST 40TH",null,{"$f":"'west 40'!B69","v":22400},null,{"$f":"'west 40'!C69","v":33450.106666666667},{"$f":"'west 40'!D69","v":2787.5088888888886},null,{"$f":"'west 40'!E69","v":21140.306666666667},{"$f":"'west 40'!F69","v":15855.23}]
["WHEAT RIDGE PARK",null,{"$f":"'WRP '!B69","v":44400},null,{"$f":"'WRP '!C69","v":49659.813333333332},{"$f":"'WRP '!D69","v":4138.3177777777773},null,{"$f":"'WRP '!E69","v":39293.773333333331},{"$f":"'WRP '!F69","v":29470.329999999998}]
["HILLTOP",null,{"$f":"'Hilltop '!B69","v":36240},null,{"$f":"'Hilltop '!C69","v":75409.653333333335},{"$f":"'Hilltop '!D69","v":6284.137777777778},null,{"$f":"'Hilltop '!E69","v":49946.240000000005},{"$f":"'Hilltop '!F69","v":37452.339999999997},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["WEST 46TH",null,{"$f":"'west 46 '!B65","v":15910},null,{"$f":"'west 46 '!C65","v":28810},{"$f":"'west 46 '!D65","v":2400.8333333333335},null,{"$f":"'west 46 '!E65","v":17771.32},{"$f":"'west 46 '!F65","v":13328.490000000002},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["ARVADA COTTAGES",null,{"$f":"'Arvada Cottages '!B67","v":46580},null,{"$f":"'Arvada Cottages '!C67","v":50180},{"$f":"'Arvada Cottages '!D67","v":4181.666666666667},null,{"$f":"'Arvada Cottages '!E67","v":38159.773333333331},{"$f":"'Arvada Cottages '!F67","v":28619.829999999998},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["ALLISON VILLAGE",null,{"$f":"'Allison Village'!B67","v":62020},null,{"$f":"'Allison Village'!C67","v":86450.489999999991},{"$f":"'Allison Village'!D67","v":8299.2075000000004},null,{"$f":"'Allison Village'!E67","v":72584.08},{"$f":"'Allison Village'!F67","v":54263.360000000001},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
[]
["TOTAL MAINTENANCE",null,{"$f":"SUM(C65:C73)","v":293710},null,{"$f":"SUM(E65:E73)","v":437529.8468},{"$f":"SUM(F65:F73)","v":37555.820566666669},null,{"$f":"SUM(H65:H73)","v":316566.33333333331},{"$f":"SUM(I65:I73)","v":237242.70999999996},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null," ",null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["GENERAL",null,null,null,null,null,null," ",null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["ORCHARD VALLEY ",null,{"$f":"'Orchard Valley'!B80","v":88825},null,{"$f":"'Orchard Valley'!C80","v":89680},{"$f":"'Orchard Valley'!D80","v":7473.333333333333},null,{"$f":"'Orchard Valley'!E80","v":84821.186666666676},{"$f":"'Orchard Valley'!F80","v":64864.87},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["UPHAM & RESPITE",null,{"$f":"UPHAM!B79","v":38950},null,{"$f":"UPHAM!C79","v":48300},{"$f":"UPHAM!D79","v":4025},null,{"$f":"UPHAM!E79","v":37957.199999999997},{"$f":"UPHAM!F79","v":28695.19}]
["WEST 40TH",null,{"$f":"'west 40'!B80","v":17890},null,{"$f":"'west 40'!C80","v":18740},{"$f":"'west 40'!D80","v":1561.6666666666667},null,{"$f":"'west 40'!E80","v":15139.92},{"$f":"'west 40'!F80","v":11975.77}]
["WHEAT RIDGE PARK",null,{"$f":"'WRP '!B80","v":49500},null,{"$f":"'WRP '!C80","v":52440},{"$f":"'WRP '!D80","v":4370},null,{"$f":"'WRP '!E80","v":47477.493333333332},{"$f":"'WRP '!F80","v":38112.269999999997},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["HILLTOP",null,{"$f":"'Hilltop '!B80","v":85510},null,{"$f":"'Hilltop '!C80","v":88010},{"$f":"'Hilltop '!D80","v":7334.1666666666661},null,{"$f":"'Hilltop '!E80","v":82807.973333333328},{"$f":"'Hilltop '!F80","v":64078.760000000009},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["WEST 46TH",null,{"$f":"'west 46 '!B76","v":22810},null,{"$f":"'west 46 '!C76","v":24770},{"$f":"'west 46 '!D76","v":2064.166666666667},null,{"$f":"'west 46 '!E76","v":21240.506666666668},{"$f":"'west 46 '!F76","v":17349.95},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["ARVADA COTTAGES",null,{"$f":"'Arvada Cottages '!B79","v":67173},null,{"$f":"'Arvada Cottages '!C79","v":69700},{"$f":"'Arvada Cottages '!D79","v":5808.3333333333339},null,{"$f":"'Arvada Cottages '!E79","v":64492.56},{"$f":"'Arvada Cottages '!F79","v":50149.25},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["ALLISON VILLAGE",null,{"$f":"'Allison Village'!B78","v":97180},null,{"$f":"'Allison Village'!C78","v":96530},{"$f":"'Allison Village'!D78","v":8044.166666666667},null,{"$f":"'Allison Village'!E78","v":87435.973333333328},{"$f":"'Allison Village'!F78","v":67516.56},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
[]
["TOTAL GENERAL EXPENSE",null,{"$f":"SUM(C77:C85)","v":467838},null,{"$f":"SUM(E77:E85)","v":488170},{"$f":"SUM(F77:F85)","v":40680.833333333328},null,{"$f":"SUM(H77:H85)","v":441372.8133333333},{"$f":"SUM(I77:I85)","v":342742.62000000005},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
[]
["FINANCING",null,null,null,null,null,null," ",null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["ORCHARD VALLEY ",null,{"$f":"'Orchard Valley'!B85","v":108800},null,{"$f":"'Orchard Valley'!C85","v":108800},{"$f":"'Orchard Valley'!D85","v":9066.6666666666661},null,{"$f":"'Orchard Valley'!E85","v":120889.46666666667},{"$f":"'Orchard Valley'!F85","v":90667.1}]
["UPHAM & RESPITE",null,{"$f":"UPHAM!B84","v":0},null,{"$f":"UPHAM!C84","v":0},{"$f":"UPHAM!D84","v":0},null,{"$f":"UPHAM!E84","v":0},{"$f":"UPHAM!F84","v":0}]
["WEST 40TH",null,{"$f":"'west 40'!B86","v":23100},null,{"$f":"'west 40'!C86","v":23100},{"$f":"'west 40'!D86","v":1925},null,{"$f":"'west 40'!E86","v":23094.6},{"$f":"'west 40'!F86","v":17320.95}]
["WHEAT RIDGE PARK",null,{"$f":"'WRP '!B85","v":43310},null,{"$f":"'WRP '!C85","v":43310},{"$f":"'WRP '!D85","v":3609.1666666666665},null,{"$f":"'WRP '!E85","v":48123.333333333328},{"$f":"'WRP '!F85","v":36092.5}]
["HILLTOP",null,{"$f":"'Hilltop '!B85","v":130060},null,{"$f":"'Hilltop '!C85","v":130060},{"$f":"'Hilltop '!D85","v":10838.333333333332},null,{"$f":"'Hilltop '!E85","v":130060},{"$f":"'Hilltop '!F85","v":108379.5}]
["WEST 46TH",null,{"$f":"'west 46 '!B81","v":32580},null,{"$f":"'west 46 '!C81","v":32580},{"$f":"'west 46 '!D81","v":2715},null,{"$f":"'west 46 '!E81","v":32580},{"$f":"'west 46 '!F81","v":27150.2}]
["ARVADA COTTAGES",null,{"$f":"'Arvada Cottages '!B84","v":142470},null,{"$f":"'Arvada Cottages '!C84","v":142470},{"$f":"'Arvada Cottages '!D84","v":11872.5},null,{"$f":"'Arvada Cottages '!E84","v":142470},{"$f":"'Arvada Cottages '!F84","v":118726.95}]
["ALLISON VILLAGE",null,{"$f":"'Allison Village'!B83","v":123770},null,{"$f":"'Allison Village'!C83","v":123770},{"$f":"'Allison Village'!D83","v":10314.166666666668},null,{"$f":"'Allison Village'!E83","v":123770},{"$f":"'Allison Village'!F83","v":103135}]
[]
["TOTAL FINANCING",null,{"$f":"SUM(C90:C98)","v":604090},null,{"$f":"SUM(E90:E98)","v":604090},{"$f":"SUM(F90:F98)","v":50340.833333333328},null,{"$f":"SUM(H90:H98)","v":620987.4},{"$f":"SUM(I90:I98)","v":501472.2},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null," ",null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["RESERVES",null,null,null,null,null,null," ",null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["ORCHARD VALLEY ",null,{"$f":"'Orchard Valley'!B89","v":4800},null,{"$f":"'Orchard Valley'!C89","v":4800},{"$f":"'Orchard Valley'!D89","v":400},null,{"$f":"'Orchard Valley'!E89","v":4800},{"$f":"'Orchard Valley'!F89","v":3600}]
["UPHAM & RESPITE",null,{"$f":"UPHAM!B88","v":4800},null,{"$f":"UPHAM!C88","v":4800},{"$f":"UPHAM!D88","v":400},null,{"$f":"UPHAM!E88","v":4800},{"$f":"UPHAM!F88","v":3600}]
["WEST 40TH",null,{"$f":"'west 40'!B90","v":3600},null,{"$f":"'west 40'!C90","v":3600},{"$f":"'west 40'!D90","v":300},null,{"$f":"'west 40'!E90","v":3600},{"$f":"'west 40'!F90","v":2700}]
["WHEAT RIDGE PARK",null,{"$f":"'WRP '!B89","v":4800},null,{"$f":"'WRP '!C89","v":4800},{"$f":"'WRP '!D89","v":400},null,{"$f":"'WRP '!E89","v":4800},{"$f":"'WRP '!F89","v":3600}]
["HILLTOP",null,{"$f":"'Hilltop '!B89","v":3600},null,{"$f":"'Hilltop '!C89","v":3600},{"$f":"'Hilltop '!D89","v":300},null,{"$f":"'Hilltop '!E89","v":3600},{"$f":"'Hilltop '!F89","v":2700}]
["WEST 46TH",null,{"$f":"'west 46 '!B85","v":5400},null,{"$f":"'west 46 '!C85","v":5400},{"$f":"'west 46 '!D85","v":450},null,{"$f":"'west 46 '!E85","v":5400},{"$f":"'west 46 '!F85","v":4050}]
["ARVADA COTTAGES",null,{"$f":"'Arvada Cottages '!B88","v":2400},null,{"$f":"'Arvada Cottages '!C88","v":2400},{"$f":"'Arvada Cottages '!D88","v":200},null,{"$f":"'Arvada Cottages '!E88","v":2400},{"$f":"'Arvada Cottages '!F88","v":1800}]
["ALLISON VILLAGE",null,{"$f":"'Allison Village'!B87","v":15600},null,{"$f":"'Allison Village'!C87","v":15600},{"$f":"'Allison Village'!D87","v":1300},null,{"$f":"'Allison Village'!E87","v":15600},{"$f":"'Allison Village'!F87","v":11700}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["TOTAL RESERVES",null,{"$f":"SUM(C102:C110)","v":45000},null,{"$f":"SUM(E102:E110)","v":45000},{"$f":"SUM(F102:F110)","v":3750},null,{"$f":"SUM(H102:H110)","v":45000},{"$f":"SUM(I102:I110)","v":33750},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null," ",null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["CAPITAL EXPENDITURES",null,null,null,null,null,null," ",null,null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["ORCHARD VALLEY ",null,{"$f":"'Orchard Valley'!B99","v":19100},null,{"$f":"'Orchard Valley'!C99","v":3000},{"$f":"'Orchard Valley'!D99","v":250},null,{"$f":"'Orchard Valley'!E99","v":42379.32},{"$f":"'Orchard Valley'!F99","v":31784.49},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["UPHAM & RESPITE",null,{"$f":"UPHAM!B98","v":11300},null,{"$f":"UPHAM!C98","v":0},{"$f":"UPHAM!D98","v":0},null,{"$f":"UPHAM!E98","v":3991.4799999999996},{"$f":"UPHAM!F98","v":2993.6099999999997}]
["WEST 40TH",null,{"$f":"'west 40'!B100","v":8700},null,{"$f":"'west 40'!C100","v":0},{"$f":"'west 40'!D100","v":0},null,{"$f":"'west 40'!E100","v":6934.44},{"$f":"'west 40'!F100","v":3460.64}]
["WHEAT RIDGE PARK",null,{"$f":"'WRP '!B99","v":16960},null,{"$f":"'WRP '!C99","v":0},{"$f":"'WRP '!D99","v":0},null,{"$f":"'WRP '!E99","v":750.66666666666674},{"$f":"'WRP '!F99","v":2259}]
["HILLTOP",null,{"$f":"'Hilltop '!B99","v":35050},null,{"$f":"'Hilltop '!C99","v":22700},{"$f":"'Hilltop '!D99","v":1891.6666666666665},null,{"$f":"'Hilltop '!E99","v":8381.5788888888892},{"$f":"'Hilltop '!F99","v":17124.21}]
["WEST 46TH",null,{"$f":"'west 46 '!B94","v":12970},null,{"$f":"'west 46 '!C94","v":2480},{"$f":"'west 46 '!D94","v":206.66666666666666},null,{"$f":"'west 46 '!E94","v":3045},{"$f":"'west 46 '!F94","v":0}]
["ARVADA COTTAGES",null,{"$f":"'Arvada Cottages '!B98","v":14120},null,{"$f":"'Arvada Cottages '!C98","v":22190},{"$f":"'Arvada Cottages '!D98","v":1849.1666666666665},null,{"$f":"'Arvada Cottages '!E98","v":11506},{"$f":"'Arvada Cottages '!F98","v":10168.09},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
["ALLISON VILLAGE",null,{"$f":"'Allison Village'!B97","v":17470},null,{"$f":"'Allison Village'!C97","v":5500},{"$f":"'Allison Village'!D97","v":458.33333333333337},null,{"$f":"'Allison Village'!E97","v":7531.7777777777774},{"$f":"'Allison Village'!F97","v":10621.279999999999},null,null,null,{"$f":"#REF!*5%","v":{"$error":"#REF!"}}]
[]
["TOTAL CAPITAL EXP.",null,{"$f":"SUM(C114:C122)","v":135670},null,{"$f":"SUM(E114:E122)","v":55870},{"$f":"SUM(F114:F122)","v":4655.833333333333},null,{"$f":"SUM(H114:H122)","v":84520.263333333336},{"$f":"SUM(I114:I122)","v":78411.319999999992}]
[]
[null,null,null,null,null,null,null," "]
["TOTAL EXPENDITURES",null,{"$f":"SUM(C123+C111+C99+C86+C74+C61+C49)","v":1931768},null,{"$f":"SUM(E123+E111+E99+E86+E74+E61+E49)","v":2013930.3085333332},{"$f":"SUM(F123+F111+F99+F86+F74+F61+F49)","v":168922.52571111111},null,{"$f":"SUM(H123+H111+H99+H86+H74+H61+H49)","v":1876276.0766666664},{"$f":"SUM(I123+I111+I99+I86+I74+I61+I49)","v":1471145.9900000002}]
[null,null,null,null,null,null,null," "]
["NET GAIN/(LOSS)",null,{"$f":"SUM(C21-C126)","v":-276548},null,{"$f":"SUM(E21-E126)","v":-380030.30853333324},{"$f":"SUM(F21-F126)","v":-33864.19237777777},null,{"$f":"SUM(H21-H126)","v":-266026.76999999955},{"$f":"SUM(I21-I126)","v":-265058.74000000046}]
[]
[]
["DEPRECIATION INCLUDED IN GENERAL EXP.",null,{"$f":"'Orchard Valley'!B79+UPHAM!B78+'west 40'!B79+'WRP '!B79+'Hilltop '!B79+'west 46 '!B75+'Arvada Cottages '!B78+'Allison Village'!B77","v":327211},null,{"$f":"'Orchard Valley'!C79+UPHAM!C78+'west 40'!C79+'WRP '!C79+'Hilltop '!C79+'west 46 '!C75+'Arvada Cottages '!C78+'Allison Village'!C77","v":338260},{"$f":"'Orchard Valley'!D79+UPHAM!D78+'west 40'!D79+'WRP '!D79+'Hilltop '!D79+'west 46 '!D75+'Arvada Cottages '!D78+'Allison Village'!D77","v":28188.333333333336},null,{"$f":"'Orchard Valley'!E79+UPHAM!E78+'west 40'!E79+'WRP '!E79+'Hilltop '!E79+'west 46 '!E75+'Arvada Cottages '!E78+'Allison Village'!E77","v":325048.28000000003},{"$f":"'Orchard Valley'!F79+UPHAM!F78+'west 40'!F79+'WRP '!F79+'Hilltop '!F79+'west 46 '!F75+'Arvada Cottages '!F78+'Allison Village'!F77","v":240284.99}]
[]
["NET INCOME(LOSS) AFTER DEPRCIATION",null,{"$f":"SUM(C128:C132)","v":50663},null,{"$f":"SUM(E128:E132)","v":-41770.308533333242},{"$f":"SUM(F128:F132)","v":-5675.8590444444344},null,{"$f":"SUM(H128:H132)","v":59021.510000000475},{"$f":"SUM(I128:I132)","v":-24773.750000000466}]

{"sheet":"Orchard Valley","index":2,"n_rows":103,"n_cols":9,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"JEFFCO HOUSING CORPORATION"]
[null,null,"ORCHARD VALLEY APARTMENTS",null,null,null,"On 10/2015      Replacement Reserves       $83,847.60"]
[null,null,"FY 2016 OPERATING BUDGET",null,null,null,"                       Residual Receipts Reserve $58,826.63"]
[null,null,null,null,null,null,"                       Together total                  $142,674.23"]
[null,"Budget","Budget","Budget",null,"Actual"]
[null,null,null,null,null,"YTD ","3% increase over 12/31/2015 potential estimate"]
[null,"FY 2015","FY 2016","FY 2016","FY 2015","FY 2015","unless otherwise noted"]
["OPERATING RECEIPTS","ANNUAL","ANNUAL","Monthly","12MO Estimate","at 9/30/15"]
[]
["RENTAL INCOME",292800,293100,{"$f":"C15/12","v":24425},{"$f":"F15/9*12","v":292766.66666666669},219575]
["VACANCIES",-5850,-5860,-488.33333333333331,{"$f":"F16/9*12","v":-3943.92},-2957.94,"2% of Rental Income"]
["INTEREST INCOME",20,30,2.5,{"$f":"F17/9*12","v":28.533333333333331},21.4]
["LAUNDRY INCOME( Laundry)",1200,1200,100,1166.9866666666667,875.24]
["NSF & LATE CHARGES",140,200,16.666666666666668,194.66666666666666,146]
["OTHER INCOME",50,80,6.666666666666667,951.37333333333322,713.53,"Estimate  (2015 YTD included one time items)",null,"2015 includes $450 donation mile hi, $178 L Jaster"]
[]
["TOTAL OPERATING RECEIPTS",{"$f":"SUM(B15:B20)","v":288360},{"$f":"SUM(C15:C20)","v":288750},{"$f":"SUM(D15:D20)","v":24062.500000000004},{"$f":"SUM(E15:E20)","v":291164.30666666676},{"$f":"SUM(F15:F20)","v":218373.22999999998}]
[]
["OPERATING EXPENDITURES"]
["ADMINISTRATIVE",{"$f":"B49","v":33910},{"$f":"C49","v":34700.302533333335},{"$f":"D49","v":2891.6918777777773},{"$f":"E49","v":34509.346666666665},{"$f":"F49","v":25882.01}]
["OPERATING",{"$f":"B56","v":43490},{"$f":"C56","v":44730.080000000002},{"$f":"D56","v":3727.5066666666671},{"$f":"E56","v":42918.166666666664},{"$f":"F56","v":31049.75}]
["MAINTENANCE",{"$f":"B69","v":33230},{"$f":"C69","v":65830},{"$f":"D69","v":5485.833333333333},{"$f":"E69","v":49951.46666666666},{"$f":"F69","v":37463.600000000006}]
["GENERAL",{"$f":"B80","v":88825},{"$f":"C80","v":89680},{"$f":"D80","v":7473.333333333333},{"$f":"E80","v":84821.186666666676},{"$f":"F80","v":64864.87}]
["FINANCING",{"$f":"B85","v":108800},{"$f":"C85","v":108800},{"$f":"D85","v":9066.6666666666661},{"$f":"E85","v":120889.46666666667},{"$f":"F85","v":90667.1}]
["RESERVES",{"$f":"B89","v":4800},{"$f":"C89","v":4800},{"$f":"D89","v":400},{"$f":"E89","v":4800},{"$f":"F89","v":3600}]
["CAPITAL EXPENSE",{"$f":"B99","v":19100},{"$f":"C99","v":3000},{"$f":"D99","v":250},{"$f":"E99","v":42379.32},{"$f":"F99","v":31784.49}]
["TOTAL OPERATING EXPENSE",{"$f":"SUM(B25:B31)","v":332155},{"$f":"SUM(C25:C31)","v":351540.38253333332},{"$f":"SUM(D25:D31)","v":29295.031877777779},{"$f":"SUM(E25:E31)","v":380268.95333333337},{"$f":"SUM(F25:F31)","v":285311.82}]
["NET INCOME",{"$f":"SUM(B22-B32)","v":-43795},{"$f":"SUM(C22-C32)","v":-62790.382533333322},{"$f":"SUM(D22-D32)","v":-5232.5318777777757},{"$f":"SUM(E22-E32)","v":-89104.646666666609},{"$f":"SUM(F22-F32)","v":-66938.590000000026}]
[]
[]
["ADMINISTRATIVE EXPENDITURES"]
[]
["OFFICE SALARIES",12050,10590,{"$f":"C38/12","v":882.5},{"$f":"F38/9*12","v":12616},9462,"Reallocation of Salaries   reduced $2400 yr move to Harlan St Apts"]
["OFFICE SUPPLIES",240,250,{"$f":"C39/12","v":20.833333333333332},{"$f":"F39/9*12","v":240.88},180.66]
["DUES & MTG EXPENSE",200,110,9.1666666666666661,{"$f":"F40/9*12","v":106.26666666666668},79.7]
["REAL ESTATE/TENANT SERVS",0,60,{"$f":"C41/12","v":5},{"$f":"F41/9*12","v":55.399999999999991},41.55]
["MANAGEMENT FEE",14420,14440,1203.3333333333333,14556.8,10917.6,"5% of total income minus interest"]
["LEGAL",350,420,35,0,0,"One legal fee & sheriff"]
["ACCOUNTING/AUDIT",2780,3590,299.16666666666669,3482.586666666667,2611.94]
["TELEPHONE",1540,1260,105,1221.8266666666668,916.37]
["COMPUTER EXPENSES",0,1680,140,0,0,"Anchor Network 2016 @3% of contract $1242. and new server @ 3% 433.50 "]
["MISC. ADMIN. EXPENSE",1220,{"$f":"SUM(E47*1.03)","v":1350.3025333333335},112.52521111111112,1310.9733333333334,983.23]
["TRAVEL",1110,950,79.166666666666671,918.61333333333334,688.96]
["TOTAL ADMINISTRATIVE",{"$f":"SUM(B38:B48)","v":33910},{"$f":"SUM(C38:C48)","v":34700.302533333335},{"$f":"SUM(D38:D48)","v":2891.6918777777773},{"$f":"SUM(E38:E48)","v":34509.346666666665},{"$f":"SUM(F38:F48)","v":25882.01}]
[null,null,null,null," "]
["OPERATING EXPENDITURES",null,null,null," ",null,"Rate Increases for 2015/16 provided from Xcel Energy/Denver Water/Arvada "]
["ELECTRIC",21180,21840,{"$f":"C52/12","v":1820},{"$f":"F52/9*12","v":21020.73333333333},15765.55,"3.9%"]
["WATER",7070,7230,{"$f":"C53/12","v":602.5},6954.5,4077,"4.0.%                (2015 actual increased to estimate semi monthly billings)"]
["GAS",13220,{"$f":"SUM(E54*1.05)","v":12330.080000000002},{"$f":"C54/12","v":1027.5066666666669},11742.933333333334,8807.2000000000007,"5.%"]
["SEWER",2020,3330,{"$f":"C55/12","v":277.5},3200,2400,"4.% - Billed Quarterly   (raised 60% in 2015 over billings from 2014)"]
["TOTAL OPERATING",{"$f":"SUM(B52:B55)","v":43490},{"$f":"SUM(C52:C55)","v":44730.080000000002},{"$f":"SUM(D52:D55)","v":3727.5066666666671},{"$f":"SUM(E52:E55)","v":42918.166666666664},{"$f":"SUM(F52:F55)","v":31049.75}]
[]
["MAINTENANCE EXPENDITURES"]
["JANITORIAL CONTRACT(Supply)",2500,2580,{"$f":"C59/12","v":215},{"$f":"F59/9*12","v":2786.2133333333331},2089.66,"3% & Clean Laundry Rooms $100month($1200yr)  - $1300 for turnovers"]
["EXTERMINATING CONTRACT",1080,1080,90,725.33333333333326,544,"3% +Previous @ $75 month (900.) plus one unit bb spray treatment $150 "]
["TRASH REMOVAL",2010,2010,167.5,1947.2000000000003,1460.4]
["GROUNDS CONTRACT & SUPPLIES",5250,5560,463.33333333333331,5540,4155,"3% +$140 week April-Oct (30wks=$4200.) +$400 Sprinkler & $800 add cleanup."]
["REPAIR MATERIALS",5450,13000,1083.3333333333333,11272.399999999998,8454.2999999999993,"$10K Estimate  & 2 Laundry room floors $1498. (2996.) "]
["REPAIR CONTRACT COSTS",4130,15000,1250,12317.533333333333,9238.15,"$10K Estimate  & Ext Paint $1250. per bldg (5000.)"]
["CARPET & VINYL/PLANK",0,8000,{"$f":"C65/12","v":666.66666666666663},{"$f":"F65/9*12","v":0},0,"2 units carpet/vinyl plank @ $4000.00 ea  "]
["APPLIANCES ",0,2880,240,0,0,"2 Refrigerators ($600.ea), 2 Ranges ($475 ea), 2 Dishwashers ($365ea)"]
["REPAIR PAYROLL",10000,11370,947.5,11044,8283]
["SNOW REMOVAL",2810,4350,362.5,4318.7866666666669,3239.09," Bid at $145 per plow aprox. Estimate 30 times "]
["TOTAL MAINTENANCE",{"$f":"SUM(B59:B68)","v":33230},{"$f":"SUM(C59:C68)","v":65830},{"$f":"SUM(D59:D68)","v":5485.833333333333},{"$f":"SUM(E59:E68)","v":49951.46666666666},{"$f":"SUM(F59:F68)","v":37463.600000000006}]
[null,null,null,null," "]
["GENERAL",null,null,null," "]
["PAYROLL TAXES",1690,1680,{"$f":"C72/12","v":140},{"$f":"F72/9*12","v":1891.7333333333333},1418.8,"7.65% of Payroll "]
["PROP & LIAB. INSURANCE ",9061,10100,841.66666666666663,9810,9809.76]
["EMPLOYEE BENEFITS",6620,6590,549.16666666666663,5656.9866666666667,4242.74,"30% of payroll - Health, Dental, CCOERA & Mtn St Employ Council"]
["WORKMAN'S COMPENSATION",660,660,55,0,0,"3.% of payroll  per Mtn St Employ Council Paid in December-Estimate"]
["EMPLOYEE COMPENSATION",660,660,55,0,0,"3.% of payroll  per Mtn St Employ Council Paid in December-Estimate"]
["BAD DEBT LOSS",800,500,41.666666666666664,0,0,"Estimate"]
["LOSS ON DISPOSAL FIXED ASSET",853,1230,{"$f":"C78/12","v":102.5},1192.4666666666667,894.35,"Estimate"]
["DEPRECIATION",68481,68260,5688.333333333333,66270,48499.22]
["TOTAL GENERAL EXPENSE",{"$f":"SUM(B72:B79)","v":88825},{"$f":"SUM(C72:C79)","v":89680},{"$f":"SUM(D72:D79)","v":7473.333333333333},{"$f":"SUM(E72:E79)","v":84821.186666666676},{"$f":"SUM(F72:F79)","v":64864.87}]
[]
["FINANCING",null,null,null," "]
["INTEREST ON MORTGAGE      ",17050,11890,{"$f":"C83/12","v":990.83333333333337},{"$f":"F83/9*12","v":19408.173333333332},14556.13,"2016 Amortization Schedule"]
["MORTGAGE      ",91750,96910,{"$f":"C84/12","v":8075.833333333333},101481.29333333333,76110.97]
["TOTAL FINANCING",{"$f":"SUM(B83:B84)","v":108800},{"$f":"SUM(C83:C84)","v":108800},{"$f":"SUM(D83:D84)","v":9066.6666666666661},{"$f":"SUM(E83:E84)","v":120889.46666666667},{"$f":"SUM(F83:F84)","v":90667.1}]
[null,null,null,null," "]
["RESERVES",null,null,null," "]
["REPLACEMENT RESERVES",4800,4800,{"$f":"C88/12","v":400},{"$f":"F88/9*12","v":4800},3600]
["TOTAL RESERVES",{"$f":"B88","v":4800},{"$f":"C88","v":4800},{"$f":"D88","v":400},{"$f":"SUM(E88)","v":4800},{"$f":"SUM(F88)","v":3600}]
[null,null,null,null," "]
["CAPITAL EXPENDITURES",null,null,null," "]
["LAND & IMPROVEMENTS",{"$f":"SUM(D92*12*1.03)","v":0},0,{"$f":"C92/12","v":0},{"$f":"F92/9*12","v":0},0]
["BUILDING",0,0,{"$f":"C93/12","v":0},0,0]
["BUILDING IMPROVEMENTS",9200,0,{"$f":"C94/12","v":0},3419.5066666666671,2564.63]
["BLDG EQUIPT FIXED",3000,3000,250,20858.666666666664,15644,"One Water Heater $3,000"]
["BLDG. EQUIP. PORTABLE",2620,0,0,3034.6666666666665,2276]
["FURNISHINGS",4280,0,0,15066.48,11299.86]
["MISC. FIXED ASSETS",0,0,0,0,0]
["TOTAL CAPITAL EXP.",{"$f":"SUM(B93:B98)","v":19100},{"$f":"SUM(C93:C98)","v":3000},{"$f":"SUM(D93:D98)","v":250},{"$f":"SUM(E93:E98)","v":42379.32},{"$f":"SUM(F93:F98)","v":31784.49}]
[null,null,null,null," "]
["TOTAL EXPENDITURES",{"$f":"SUM(B99+B89+B85+B80+B69+B56+B49)","v":332155},{"$f":"SUM(C99+C89+C85+C80+C69+C56+C49)","v":351540.38253333338},{"$f":"SUM(D99+D89+D85+D80+D69+D56+D49)","v":29295.031877777779},{"$f":"SUM(E99+E89+E85+E80+E69+E56+E49)","v":380268.95333333337},{"$f":"SUM(F99+F89+F85+F80+F69+F56+F49)","v":285311.82}]
[null," "," ",null," "]
["NET GAIN/(LOSS)",{"$f":"SUM(B22-B101)","v":-43795},{"$f":"SUM(C22-C101)","v":-62790.382533333381},{"$f":"SUM(D22-D101)","v":-5232.5318777777757},{"$f":"SUM(E22-E101)","v":-89104.646666666609},{"$f":"SUM(F22-F101)","v":-66938.590000000026}]

{"sheet":"UPHAM","index":3,"n_rows":102,"n_cols":7,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"JEFFCO HOUSING CORPORATION"]
[null,"UPHAM STREET APTS.  & RESPITE HOME"]
[null,"FY 2016 OPERATING BUDGET",null,null,null,null,"On 10/2015  Upham  Replacement Reserves $86,506.57"]
[null,null,null,null,null,"Actual"]
[null,"Budget","Budget","Budget",null,"YTD ","3% increase over 12/31/2015 potential estimate"]
[null,"FY 2015","FY 2016","FY 2016","FY 2015","FY 2015","unless otherwise noted"]
["OPERATING RECEIPTS","ANNUAL","ANNUAL","Monthly","12MO Estimate","at 9/30/15"]
[]
["RENTAL INCOME-UPHAM",108870,108600,{"$f":"C15/12","v":9050},{"$f":"F15/9*12","v":108716.6},81537.45]
["LESS: VACANCIES UPHAM",-2180,-1800,-150,-752,-564,"1.65% Estimate based on lower vacancies in 2015"]
["RENTAL INCOME-RESPITE",0,13200,0,13200,9900]
["INTEREST ",40,20,1.6666666666666667,13.773333333333333,10.33]
["LAUNDRY INCOME - UPHAM",2719,2780,231.66666666666666,2699.52,2024.64]
["NSF & LATE FEES",211,170,14.166666666666666,162.66666666666666,122]
["OTHER INCOME",540,360,30,34.893333333333338,26.17," Collections and $310.00 approximately from City of Wheat Ridge-shared water"]
["TOTAL OPERATING RECEIPTS",{"$f":"SUM(B15:B21)","v":110200},{"$f":"SUM(C15:C21)","v":123330},{"$f":"SUM(D15:D21)","v":9177.4999999999982},{"$f":"SUM(E15:E21)","v":124075.45333333334},{"$f":"SUM(F15:F21)","v":93056.59}]
[]
["OPERATING EXPENDITURES"]
["ADMINISTRATIVE",{"$f":"B48","v":21630},{"$f":"C48","v":24460},{"$f":"D48","v":2038.3333333333335},{"$f":"E48","v":22976.560000000001},{"$f":"F48","v":17232.419999999998}]
["OPERATING",{"$f":"B55","v":15230},{"$f":"C55","v":15020},{"$f":"D55","v":1251.6666666666665},{"$f":"E55","v":13120.08},{"$f":"F55","v":10449.06}]
["MAINTENANCE",{"$f":"B68","v":32930},{"$f":"C68","v":47739.783466666668},{"$f":"D68","v":3978.315288888889},{"$f":"E68","v":27719.373333333333},{"$f":"F68","v":20789.53}]
["GENERAL",{"$f":"B79","v":38950},{"$f":"C79","v":48300},{"$f":"D79","v":4025},{"$f":"E79","v":37957.199999999997},{"$f":"F79","v":28695.19}]
["FINANCING",{"$f":"B84","v":0},{"$f":"C84","v":0},{"$f":"D84","v":0},{"$f":"E84","v":0},{"$f":"F84","v":0}]
["RESERVES",{"$f":"B88","v":4800},{"$f":"C88","v":4800},{"$f":"D88","v":400},{"$f":"E88","v":4800},{"$f":"F88","v":3600}]
["CAPITAL EXPENSE",{"$f":"B98","v":11300},{"$f":"C98","v":0},{"$f":"D98","v":0},{"$f":"E98","v":3991.4799999999996},{"$f":"F98","v":2993.6099999999997}]
["TOTAL OPERATING EXPENSE",{"$f":"SUM(B25:B31)","v":124840},{"$f":"SUM(C25:C31)","v":140319.78346666667},{"$f":"SUM(D25:D31)","v":11693.315288888889},{"$f":"SUM(E25:E31)","v":110564.69333333333},{"$f":"SUM(F25:F31)","v":83759.81}]
["NET INCOME",{"$f":"SUM(B22-B32)","v":-14640},{"$f":"SUM(C22-C32)","v":-16989.783466666675},{"$f":"SUM(D22-D32)","v":-2515.8152888888908},{"$f":"SUM(E22-E32)","v":13510.760000000009},{"$f":"SUM(F22-F32)","v":9296.7799999999988}]
[]
[]
["ADMINISTRATIVE EXPENDITURES"]
[]
["OFFICE SALARIES",13000,13770,{"$f":"C38/12","v":1147.5},{"$f":"F38/9*12","v":13361.773333333334},10021.33]
["OFFICE SUPPLIES",150,120,{"$f":"C39/12","v":10},108.05333333333334,81.040000000000006,"$110.00 Upham $10.00 Respite"]
["DUES & MTG EXPENSE",80,50,4.166666666666667,44.76,33.57]
["MANAGEMENT FEE",5510,5500,458.33333333333331,5543.6399999999994,4157.7299999999996,"Based on 5% of total income minus interest"]
["LEGAL",350,420,35,0,0,"One legal & one sheriff fee"]
["ACCOUNTING/AUDIT",1310,1760,146.66666666666666,1710.3333333333333,1282.75]
["TELEPHONE",0,300,25,294.17333333333329,220.63]
["COMPUTER EXPENSE",0,560,46.666666666666664,0,0,"Anchor Network 2016 @ 1% of contract $414.00 and new server @ 1% 144.50"]
["MISC. ADMIN. EXPENSE",860,820,68.333333333333329,793.02666666666664,594.77]
["TRAVEL",370,1160,96.666666666666671,1120.8000000000002,840.6]
["TOTAL ADMINISTRATIVE",{"$f":"SUM(B38:B47)","v":21630},{"$f":"SUM(C38:C47)","v":24460},{"$f":"SUM(D38:D47)","v":2038.3333333333335},{"$f":"SUM(E38:E47)","v":22976.560000000001},{"$f":"SUM(F38:F47)","v":17232.419999999998}]
[null," "," "," "]
["OPERATING EXPENDITURES"," "," "," ",null,null,"Rate Increases for 2015/16 provided from Xcel Energy/Denver Water/Arvada "]
["ELECTRIC",1720,1450,{"$f":"C51/12","v":120.83333333333333},{"$f":"F51/9*12","v":1390.3866666666665},1042.79,"3.9% all Upham           Respite billed to Tenant"]
["WATER",5180,5890,{"$f":"C52/12","v":490.83333333333331},4558.9333333333334,3419.2,"4.0.%               $4740.00 Upham    $1150.00 Respite"]
["GAS",5770,4970,{"$f":"C53/12","v":414.16666666666669},4734.76,3551.07,"5.%   all Upham            Respite billed to Tenant"]
["SEWER",2560,2710,{"$f":"C54/12","v":225.83333333333334},2436,2436,"4.% - Annual     $2530.00 Upham     $180.00 Respite"]
["TOTAL OPERATING",{"$f":"SUM(B51:B54)","v":15230},{"$f":"SUM(C51:C54)","v":15020},{"$f":"SUM(D51:D54)","v":1251.6666666666665},{"$f":"SUM(E51:E54)","v":13120.08},{"$f":"SUM(F51:F54)","v":10449.06}]
[]
["MAINTENANCE EXPENDITURES"]
["JANITORIAL CONTRACT & SUPPLIES",740,1130,{"$f":"C58/12","v":94.166666666666671},{"$f":"F58/9*12","v":1100},825]
["EXTERMINATION CONTRACT",1050,1080,90,1166.6666666666667,875,"3% & Contract $175 bi monthly ($1050.00.yr)     "]
["TRASH REMOVAL",1280,1280,106.66666666666667,1440.8400000000001,1080.6300000000001,"3% & Contract $103.09 month ($1237.yr) "]
["GROUNDS CONTRACT",3900,4270,355.83333333333331,2553.333333333333,1915,"3 % & 2014 rate of $116 wk April-Oct(30wks=$3480.)+$420 cleanup & $250.00 Respite"]
["REPAIR MATERIALS",6000,5460,455,5205.746666666666,3904.31,"3%   and    $100.00 Respite"]
["REPAIR CONTRACT ",8000,14090,1174.1666666666667,4084,3063,"3% plus Railings /Step replacements $4000. & Ext Paint 5000. and $880.00 Respite ($450clean carpet."]
["CARPET & VINYL/PLANK",0,4800,400,0,0,"3 units carpet / vinyl or vinyl plank $1600 each "]
["APPLIANCES ",0,3100,258.33333333333331,0,0,"2 Refridgerators $500 ea and 3 Ranges @$500 ea  and $600 Respite dishwasher"]
["REPAIR PAYROLL",11000,11000,916.66666666666663,10683.56,8012.67]
["SNOW REMOVAL",960,{"$f":"SUM(E67*1.03)","v":1529.7834666666668},127.48195555555556,1485.2266666666667,1113.92]
["TOTAL MAINTENANCE",{"$f":"SUM(B58:B67)","v":32930},{"$f":"SUM(C58:C67)","v":47739.783466666668},{"$f":"SUM(D58:D67)","v":3978.315288888889},{"$f":"SUM(E58:E67)","v":27719.373333333333},{"$f":"SUM(F58:F67)","v":20789.53}]
[null," "," "," "]
["GENERAL"]
["PAYROLL TAXES",1760,1900,{"$f":"C71/12","v":158.33333333333334},{"$f":"F71/9*12","v":2179.4266666666663},1634.57,"7.65% of Payroll    "]
["PROP & LIABILITY INSURANCE",3600,4220,{"$f":"C72/12","v":351.66666666666669},3554,3921.45,"$3660.00  Upham  and $560.00 Respite"]
["EMP BENEFITS",6900,7430,619.16666666666663,6623.7733333333326,4967.83,"30.% of payroll - Health, Dental, CCOERA & Mtn St Employ Council"]
["WORKMENS COMPENSATION",690,740,61.666666666666664,0,0,"3.% of payroll  per Mtn St Employ Council Paid in December-Estimate"]
["EMPLOYEE COMPENSATION",690,740,61.666666666666664,0,0,"3.% of payroll  per Mtn St Employ Council Paid in December-Estimate"]
["BAD DEBT LOSS",500,500,41.666666666666664,0,0,"esitmate"]
["LOSS ON DISPOSAL FIXED ASSET",1000,1140,{"$f":"C77/12","v":95},0,0,"esitmate  -  $1000.00 Upham   and  $140.00 Respite"]
["DEPRECIATION",23810,31630,2635.8333333333335,25600,18171.34,"$26,370.00  Upham  and $5260.00 Respite"]
["TOTAL GENERAL EXPENSE",{"$f":"SUM(B71:B78)","v":38950},{"$f":"SUM(C71:C78)","v":48300},4025,37957.199999999997,28695.19]
[]
["FINANCING"]
["MORTGAGE INTEREST",0,0,{"$f":"C82/12","v":0},{"$f":"F82/9","v":0},0]
["MORTGAGE PRINCIPAL",0,0,{"$f":"C83/12","v":0},{"$f":"F83/9","v":0},0]
["TOTAL FINANCING",{"$f":"SUM(B82:B83)","v":0},{"$f":"SUM(C82:C83)","v":0},{"$f":"SUM(D82:D83)","v":0},{"$f":"SUM(E82:E83)","v":0},{"$f":"SUM(F82:F83)","v":0},"No Mortgage"]
[null," "," "," "]
["RESERVES"," "," "," "]
["REPLACEMENT RESERVES",4800,4800,{"$f":"C87/12","v":400},{"$f":"F87/9*12","v":4800},3600]
["TOTAL RESERVES",{"$f":"B87","v":4800},{"$f":"C87","v":4800},{"$f":"D87","v":400},{"$f":"E87","v":4800},{"$f":"F87","v":3600}]
[null," "," "," "]
["CAPITAL EXPENDITURES"," "," "," "]
["LAND & IMPROVEMENTS",0,0,{"$f":"C91/12","v":0},{"$f":"F91/9*12","v":0},0]
["BUILDING",0,0,0,0,0]
["BUILDING IMPROVEMENTS",4000,0,{"$f":"C93/12","v":0},1307.3333333333333,980.5]
["BLDG. EQUIP. FIXED",0,0,0,0,0]
["BLDG. EQUIP. PORTABLE",2500,0,0,800,600]
["FURNISHINGS",4800,0,0,1884.1466666666665,1413.11]
["MISC. FIXED ASSETS",0,0,0,0,0]
["TOTAL CAPITAL EXP.",{"$f":"SUM(B91:B97)","v":11300},{"$f":"SUM(C91:C97)","v":0},{"$f":"SUM(D91:D97)","v":0},{"$f":"SUM(E91:E97)","v":3991.4799999999996},{"$f":"SUM(F91:F97)","v":2993.6099999999997}]
[]
["TOTAL EXPENDITURES",{"$f":"SUM(B98+B88+B84+B79+B68+B55+B48)","v":124840},{"$f":"SUM(C98+C88+C84+C79+C68+C55+C48)","v":140319.78346666667},{"$f":"SUM(D98+D88+D84+D79+D68+D55+D48)","v":11693.315288888889},{"$f":"SUM(E98+E88+E84+E79+E68+E55+E48)","v":110564.69333333333},{"$f":"SUM(F98+F88+F84+F79+F68+F55+F48)","v":83759.81}]
[]
["NET GAIN/LOSS",{"$f":"SUM(B22-B100)","v":-14640},{"$f":"SUM(C22-C100)","v":-16989.783466666675},{"$f":"SUM(D22-D100)","v":-2515.8152888888908},{"$f":"SUM(E22-E100)","v":13510.760000000009},{"$f":"SUM(F22-F100)","v":9296.7799999999988}]

{"sheet":"west 40","index":4,"n_rows":104,"n_cols":7,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"JEFFCO HOUSING CORPORATION"]
[null,"WEST 40th"]
[null,"FY 2016 OPERATING BUDGET"]
[null,null,null,null,null,null,"On 10/2015   Replacement Reserves $59,304.89"]
[null,null,null,null,null,"Actual"]
[null,"Budget","Budget","Budget",null,"YTD ","3% increase over 12/31/2015 potential estimate"]
[null,"FY 2015","FY 2016","FY 2016","FY 2015","FY 2015","unless otherwise noted"]
["OPERATING RECEIPTS","ANNUAL","ANNUAL","Monthly","12MO Estimate","at 9/30/15"]
[]
["RENTAL INCOME",66480,67800,{"$f":"C14/12","v":5650},{"$f":"F14/9*12","v":67336},50502,"Projected 2015 Rental Income "]
["VACANCIES",-1330,-1350,-112.5,-752.8,-564.6,"2% of Rental Income"]
["TRANSFER FROM RESERVES",11000,8000,666.66666666666663,0,0,"        "]
["INTEREST INCOME",20,20,1.6666666666666667,9.4266666666666659,7.07]
["LAUNDRY INCOME",810,740,61.666666666666664,722.66666666666663,542]
["NSF / LATE  CHARGES",30,{"$f":"SUM(E19*1.03)","v":0},0,0,0]
["OTHER INCOME",20,20,1.6666666666666667,17.973333333333336,13.48,"Estimated from collections "]
[]
["TOTAL OPERATING RECEIPTS",{"$f":"SUM(B14:B20)","v":77030},{"$f":"SUM(C14:C20)","v":75230},{"$f":"SUM(D14:D20)","v":6269.1666666666679},{"$f":"SUM(E14:E20)","v":67333.266666666663},{"$f":"SUM(F14:F20)","v":50499.950000000004}]
[]
["OPERATING EXPENDITURES"]
["ADMINISTRATIVE",{"$f":"B48","v":5200},{"$f":"C48","v":6440.0231999999996},{"$f":"D48","v":536.66859999999997},{"$f":"E48","v":5409.1333333333341},{"$f":"F48","v":4056.85}]
["OPERATING",{"$f":"B55","v":9250},{"$f":"C55","v":8070},{"$f":"D55","v":672.50000000000011},{"$f":"E55","v":7717.6533333333336},{"$f":"F55","v":6136.24}]
["MAINTENANCE",{"$f":"B69","v":22400},{"$f":"C69","v":33450.106666666667},{"$f":"D69","v":2787.5088888888886},{"$f":"E69","v":21140.306666666667},{"$f":"F69","v":15855.23}]
["GENERAL",{"$f":"B80","v":17890},{"$f":"C80","v":18740},{"$f":"D80","v":1561.6666666666667},{"$f":"E80","v":15139.92},{"$f":"F80","v":11975.77}]
["FINANCING",{"$f":"B86","v":23100},{"$f":"C86","v":23100},{"$f":"D86","v":1925},{"$f":"E86","v":23094.6},{"$f":"F86","v":17320.95}]
["RESERVES",{"$f":"B89","v":3600},{"$f":"C89","v":3600},{"$f":"D89","v":300},{"$f":"E90","v":3600},{"$f":"F90","v":2700}]
["CAPITAL EXPENSE",{"$f":"B100","v":8700},{"$f":"C100","v":0},{"$f":"D100","v":0},{"$f":"E100","v":6934.44},{"$f":"F100","v":3460.64}]
["TOTAL OPERATING EXPENSE",{"$f":"SUM(B25:B31)","v":90140},{"$f":"SUM(C25:C31)","v":93400.12986666667},{"$f":"SUM(D25:D31)","v":7783.3441555555555},{"$f":"SUM(E25:E31)","v":83036.053333333344},{"$f":"SUM(F25:F31)","v":61505.679999999993}]
["NET INCOME",{"$f":"SUM(B22-B32)","v":-13110},{"$f":"SUM(C22-C32)","v":-18170.12986666667},{"$f":"SUM(D22-D32)","v":-1514.1774888888876},{"$f":"SUM(E22-E32)","v":-15702.786666666681},{"$f":"SUM(F22-F32)","v":-11005.729999999989}]
[]
[]
["ADMINISTRATIVE EXPENDITURES"]
[]
["OFFICE SALARIES",0,{"$f":"SUM(E38*1.03)","v":0},{"$f":"C38/12","v":0},{"$f":"F38/9*12","v":0},0]
["OFFICE SUPPLIES",110,99.676533333333325,8.3063777777777776,96.773333333333326,72.58]
["DUES & MTG EXPENSE",50,30,2.5,27.973333333333336,20.98]
["MANAGEMENT FEE",3300,3360,280,3366.2,2524.65,"Based on 5% of total income minus interest & reserves"]
["LEGAL",350,420,35,0,0,"One legal & one sheriff fee"]
["ACCOUNTING/AUDIT",650,950.34666666666669,79.195555555555558,922.66666666666663,692]
["TELEPHONE",0,120,10,117.66666666666666,88.25]
["COMPUTER EXPENSE",0,560,46.666666666666664,0,0,"Anchor Network 2016 @ 1% of contract  $414.00 and new server @ 1% 144.50"]
["MISC. ADMIN. EXPENSE",610,570,47.5,555.13333333333333,416.35]
["TRAVEL",130,330,27.5,322.71999999999997,242.04]
["TOTAL ADMINISTRATIVE",{"$f":"SUM(B38:B47)","v":5200},{"$f":"SUM(C38:C47)","v":6440.0231999999996},{"$f":"SUM(D38:D47)","v":536.66859999999997},{"$f":"SUM(E38:E47)","v":5409.1333333333341},{"$f":"SUM(F38:F47)","v":4056.85}]
[null," "," "," "," "]
["OPERATING EXPENDITURES"," "," "," "," ",null,"Rate Increases for 2015/16 provided from Xcel Energy/Denver Water/Arvada "]
["ELECTRIC",560,410,{"$f":"C51/12","v":34.166666666666664},{"$f":"F51/9*12","v":392.22666666666669},294.17,"3.9%"]
["WATER",2240,2200,183.33333333333334,2112.7333333333331,1584.55,"4.0.%"]
["GAS",4500,4010,334.16666666666669,3820.6933333333336,2865.52,"5.%"]
["SEWER",1950,1450,120.83333333333333,1392,1392,"4.% - Annual"]
["TOTAL OPERATING",{"$f":"SUM(B51:B54)","v":9250},{"$f":"SUM(C51:C54)","v":8070},{"$f":"SUM(D51:D54)","v":672.50000000000011},{"$f":"SUM(E51:E54)","v":7717.6533333333336},{"$f":"SUM(F51:F54)","v":6136.24}]
[]
[]
["MAINTENANCE EXPENDITURES"]
["JANITORIAL CONTRACT & SUPPLIES",740,740,{"$f":"C59/12","v":61.666666666666664},{"$f":"F59/9*12","v":380},285,"Laundry Cleaning $40 per month($480. started mid 2015) & unit ($260)"]
["EXTERMINATING CONTRACT",1460,1500,125,1451.96,1088.97]
["TRASH REMOVAL",1240,1250,104.16666666666667,1216.6266666666666,912.47]
["GROUNDS CONTRACT",3900,3780,315,4433.3333333333339,3325,"2015 rate $116 week April-Oct (30wks=$3480.) plus 300. additional cleanup and maintenance"]
["REPAIR MATERIALS",1000,3300,275,3207.5466666666666,2405.66]
["REPAIR CONTRACT ",6860,6100,508.33333333333331,1249.3333333333335,937,"3% & Boiler cleaning $600. & Concrete work $3000. & $1200 increase for low 2015 costs"]
["CARPET & VINYL/PLANK",0,2700,225,0,0,"One unit carpet/vinyl or vinyl plank"]
["APPLIANCES ",0,4600,383.33333333333331,0,0,"One Range $400.  One Fridge $600 & 4 Swamp Coolers @ $900. ea ($3600)"]
["REPAIR PAYROLL",5900,{"$f":"SUM(E67*1.03)","v":7740.1066666666666},{"$f":"C67/12","v":645.00888888888892},{"$f":"F67/9*12","v":7514.6666666666661},5636]
["SNOW REMOVAL",1300,1740,145,1686.8400000000001,1265.1300000000001]
["TOTAL MAINTENANCE",{"$f":"SUM(B59:B68)","v":22400},{"$f":"SUM(C59:C68)","v":33450.106666666667},{"$f":"SUM(D59:D68)","v":2787.5088888888886},{"$f":"SUM(E59:E68)","v":21140.306666666667},{"$f":"SUM(F59:F68)","v":15855.23}]
[null," "," "," "," "]
["GENERAL"," "," "," "," "]
["PAYROLL TAXES",450,590,{"$f":"C72/12","v":49.166666666666664},{"$f":"F72/9*12","v":99.493333333333339},74.62,"7.65% of Payroll "]
["PROP & LIAB. INSURANCE ",2000,2140,178.33333333333334,2074,2176.33]
["EMPLOYEE BENEFITS",1770,2320,193.33333333333334,211.44,158.58000000000001,"30.% of payroll - Health, Dental, CCOERA & Mtn St Employ Council"]
["WORKMAN'S COMPENSATION",180,230,19.166666666666668,0,0,"3.% of payroll  per Mtn St Employ Council Paid in December-Estimate"]
["EMPLOYEE COMPENSATIONS",180,230,19.166666666666668,0,0,"3.% of payroll  per Mtn St Employ Council Paid in December-Estimate"]
["BAD DEBT LOSS",500,50,4.166666666666667,0,0]
["LOSS ON DISPOSAL FIXED ASSET",300,300,25,248.82666666666668,186.62,"estimate"]
["DEPRECIATION",12510,12880,1073.3333333333333,12506.16,9379.6200000000008]
["TOTAL GENERAL EXPENSE",{"$f":"SUM(B72:B79)","v":17890},{"$f":"SUM(C72:C79)","v":18740},1561.6666666666667,15139.92,11975.77]
[]
[null," "," "," "," "]
["FINANCING"," "," "," "," "]
["INT ON MORTGAGE PAYABLE",3650,2240,{"$f":"C84/12","v":186.66666666666666},{"$f":"F84/9*12","v":3764.8666666666668},2823.65,"2016 Amortization Schedule"]
["MORTGAGE      ",19450,20860,1738.3333333333333,19329.733333333334,14497.3]
["TOTAL FINANCING",{"$f":"SUM(B84:B85)","v":23100},{"$f":"SUM(C84:C85)","v":23100},{"$f":"SUM(D84:D85)","v":1925},{"$f":"SUM(E84:E85)","v":23094.6},{"$f":"SUM(F84:F85)","v":17320.95}]
[null," "," "," "," "]
["RESERVES"," "," "," "," "]
["REPLACEMENT RESERVES",3600,3600,{"$f":"C89/12","v":300},{"$f":"F89/9*12","v":3600},2700]
["TOTAL RESERVES",{"$f":"B89","v":3600},{"$f":"C89","v":3600},{"$f":"D89","v":300},{"$f":"E89","v":3600},{"$f":"F89","v":2700}]
[null," "," "," "," "]
["CAPITAL EXPENDITURES"," "," "," "," "]
["LAND & IMPROVEMENTS",0,0,{"$f":"C93/12","v":0},{"$f":"F93/9*12","v":0},0]
["BUILDING  ",0,0,0,0,0]
["BUILDING IMPROVEMENTS",3500,0,{"$f":"C95/12","v":0},3400,809.81]
["BUILDING EQUIP FIXED",3000,0,0,0,0]
["BLDG. EQUIP. PORTABLE",1000,0,0,0,0]
["FURNISHINGS",1200,0,0,3534.4399999999996,2650.83]
["MISC. FIXED ASSETS",0,0,0,0,0,"                      "]
["TOTAL CAPITAL EXP.",{"$f":"SUM(B93:B99)","v":8700},{"$f":"SUM(C93:C99)","v":0},{"$f":"SUM(D93:D99)","v":0},{"$f":"SUM(E93:E99)","v":6934.44},{"$f":"SUM(F93:F99)","v":3460.64}]
[null,null,null,null," "]
["TOTAL EXPENDITURES",{"$f":"SUM(B100+B90+B86+B80+B69+B55+B48)","v":90140},{"$f":"SUM(C100+C90+C86+C80+C69+C55+C48)","v":93400.129866666655},{"$f":"SUM(D100+D90+D86+D80+D69+D55+D48)","v":7783.3441555555555},{"$f":"SUM(E100+E90+E86+E80+E69+E55+E48)","v":83036.05333333333},{"$f":"SUM(F100+F90+F86+F80+F69+F55+F48)","v":61505.679999999993}]
[null,null,null,null," "]
["NET GAIN/LOSS",{"$f":"SUM(B22-B102)","v":-13110},{"$f":"SUM(C22-C102)","v":-18170.129866666655},{"$f":"SUM(D22-D102)","v":-1514.1774888888876},{"$f":"SUM(E22-E102)","v":-15702.786666666667},{"$f":"SUM(F22-F102)","v":-11005.729999999989}]

{"sheet":"WRP ","index":5,"n_rows":103,"n_cols":7,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"JEFFCO HOUSING CORPORATION"]
[null,"WHEAT RIDGE PARK"]
[null,"FY 2016 OPERATING BUDGET"]
[null,null,null,null,null,null,"On 10/2015    Replacement Reserves $46,676.99"]
[null,null,null,null,null,"Actual"]
[null,"Budget","Budget","Budget",null,"YTD ","3% increase over 12/31/2015 potential estimate"]
[null,"FY 2015","FY 2016","FY 2016","FY 2015","FY 2015","unless otherwise noted"]
["OPERATING RECEIPTS","ANNUAL","ANNUAL","Monthly","12MO Estimate","at 9/30/15"]
[]
["RENTAL INCOME",155700,159130,{"$f":"C14/12","v":13260.833333333334},{"$f":"F14/9*12","v":156852},117639]
["VACANCIES",-3110,-3180,-265,-886.66666666666663,-665,"2% of Rental Income"]
["TRANSFER FROM RESERVES",14000,4000,333.33333333333331,0,0]
["INTEREST INCOME",10,10,0.83333333333333337,7.1333333333333329,5.35,"Shared with 46th"]
["LAUNDRY INCOME",1730,1730,144.16666666666666,1889.5333333333333,1417.15]
["NSF / LATE  CHARGES",570,570,47.5,442.66666666666663,332]
["MISC INCOME",1000,750,62.5,724.22666666666657,543.16999999999996,"Income is from collections of previously written off tenants."]
[]
["TOTAL OPERATING RECEIPTS",{"$f":"SUM(B14:B20)","v":169900},{"$f":"SUM(C14:C20)","v":163010},{"$f":"SUM(D14:D20)","v":13584.166666666668},{"$f":"SUM(E14:E20)","v":159028.89333333331},{"$f":"SUM(F14:F20)","v":119271.67}]
[]
["OPERATING EXPENDITURES"]
["ADMINISTRATIVE",{"$f":"B48","v":21470},{"$f":"C48","v":23440},{"$f":"D48","v":1953.3333333333333},{"$f":"E48","v":21427.853333333333},{"$f":"F48","v":16070.89}]
["OPERATING",{"$f":"B55","v":16370},{"$f":"C55","v":16010.054},{"$f":"D55","v":1334.1711666666667},{"$f":"E55","v":15349.08},{"$f":"F55","v":11547.68}]
["MAINTENANCE",{"$f":"B69","v":44400},{"$f":"C69","v":49659.813333333332},{"$f":"D69","v":4138.3177777777773},{"$f":"E69","v":39293.773333333331},{"$f":"F69","v":29470.329999999998}]
["GENERAL",{"$f":"B80","v":49500},{"$f":"C80","v":52440},{"$f":"D80","v":4370},{"$f":"E80","v":47477.493333333332},{"$f":"F80","v":38112.269999999997}]
["FINANCING",{"$f":"B85","v":43310},{"$f":"C85","v":43310},{"$f":"D85","v":3609.1666666666665},{"$f":"E85","v":48123.333333333328},{"$f":"F85","v":36092.5}]
["RESERVES",{"$f":"B88","v":4800},{"$f":"C88","v":4800},{"$f":"D88","v":400},{"$f":"E89","v":4800},{"$f":"F89","v":3600}]
["CAPITAL EXPENSE",{"$f":"B99","v":16960},{"$f":"C99","v":0},{"$f":"D99","v":0},{"$f":"E99","v":750.66666666666674},{"$f":"F99","v":2259}]
["TOTAL OPERATING EXPENSE",{"$f":"SUM(B25:B31)","v":196810},{"$f":"SUM(C25:C31)","v":189659.86733333333},{"$f":"SUM(D25:D31)","v":15804.988944444443},{"$f":"SUM(E25:E31)","v":177222.19999999998},{"$f":"SUM(F25:F31)","v":137152.66999999998}]
["NET INCOME",{"$f":"SUM(B22-B32)","v":-26910},{"$f":"SUM(C22-C32)","v":-26649.867333333328},{"$f":"SUM(D22-D32)","v":-2220.8222777777755},{"$f":"SUM(E22-E32)","v":-18193.306666666671},{"$f":"SUM(F22-F32)","v":-17880.999999999985}]
[]
[]
["ADMINISTRATIVE EXPENDITURES"]
["OFFICE SALARIES",8700,9080,{"$f":"C37/12","v":756.66666666666663},{"$f":"F37/9*12","v":8816},6612]
["OFFICE SUPPLIES",210,230,19.166666666666668,221.05333333333331,165.79]
["DUES & MTG EXPENSE",120,70,5.833333333333333,67.12,50.34]
["CLIENT VERIFICATION SERVICES",70,70,5.833333333333333,{"$f":"F40/9*12","v":0},0,"Estimate"]
["MANAGEMENT FEE",7790,7950,662.5,7951.1333333333332,5963.35,"Based on 5% of total income minus interest & reserves"]
["LEGAL",350,420,35,0,0,"One legal & one sheriff fee"]
["ACCOUNTING/AUDIT",1790,2370,197.5,2301.08,1725.81]
["TELEPHONE",770,760,63.333333333333336,740.68,555.51]
["COMPUTER EXPENSE",0,1120,93.333333333333329,0,0,"Anchor Network 2016 @2% of contract $828. and new server @ 2% 289.00"]
["MISC. ADMIN. EXPENSE",930,570,47.5,555.13333333333333,416.35]
["TRAVEL",740,800,66.666666666666671,775.65333333333342,581.74]
["TOTAL ADMINISTRATIVE",{"$f":"SUM(B37:B47)","v":21470},{"$f":"SUM(C37:C47)","v":23440},{"$f":"SUM(D37:D47)","v":1953.3333333333333},{"$f":"SUM(E37:E47)","v":21427.853333333333},{"$f":"SUM(F37:F47)","v":16070.89}]
[null," "," "," "," "]
["OPERATING EXPENDITURES"," "," "," "," ",null,"Rate Increases for 2015/16 provided from Xcel Energy/Denver Water/Arvada "]
["ELECTRIC",2390,3170,{"$f":"C51/12","v":264.16666666666669},{"$f":"F51/9*12","v":3045.2666666666664},2283.9499999999998,"3.9%"]
["WATER",4080,4410,367.5,4239,2375.12,"4.0.%              (adj average for Wheat Ridge Water semi monthly billings)"]
["GAS",6630,{"$f":"SUM(E53*1.05)","v":4940.0540000000001},411.67116666666669,4704.8133333333335,3528.61,"5.%"]
["SEWER",3270,3490,290.83333333333331,3360,3360,"4.% - Semi Annual"]
["TOTAL OPERATING",{"$f":"SUM(B51:B54)","v":16370},{"$f":"SUM(C51:C54)","v":16010.054},{"$f":"SUM(D51:D54)","v":1334.1711666666667},{"$f":"SUM(E51:E54)","v":15349.08},{"$f":"SUM(F51:F54)","v":11547.68}]
[]
["MAINTENANCE EXPENDITURES"]
["JANITORIAL SUPPLIES",280,{"$f":"SUM(E58*1.03)","v":0},{"$f":"C58/12","v":0},{"$f":"F58/9*12","v":0},0]
["JANITORIAL CONTRACT",1950,1570,130.83333333333334,1520,1140]
["EXTERMINATING CONTRACT",3520,2520,210,5458.666666666667,4094,"2015 Contract $253 bi monthly ($1518.00) and  BB chg $1000"]
["TRASH REMOVAL",2740,2840,236.66666666666666,2731.0666666666666,2048.3000000000002,"3% & Contract $204.83 month ($2458.yr)- plus one rolloff $300"]
["GROUNDS CONTRACT",4490,4360,363.33333333333331,4480,3360,"$116 wk April-Oct (30wks=$3480)plus 300cleanup 580sprinklers"]
["REPAIR MATERIALS",11550,9580,798.33333333333337,5800.7333333333336,4350.55,"3% & unit entry doors @$450 ea x8 (3600.)"]
["REPAIR CONTRACT COSTS",10500,11390,949.16666666666663,7418.6666666666661,5564,"3% & Boiler cleaning @$250 each ($750) & Ext. Paint/Vinyl $3000"]
["CARPET & VINYL/PLANK",0,3000,250,0,0,"2 units carpet/vinyl $1,350 each  and two entries $150. each"]
["APPLIANCES ",0,2160,180,0,0,"2 Refrigerator $500., 1 Range $465, 2 Dishwasher $345."]
["REPAIR PAYROLL",8400,10659.813333333334,888.31777777777779,10349.333333333334,7762]
["SNOW REMOVAL",970,1580,131.66666666666666,1535.3066666666668,1151.48]
["TOTAL MAINTENANCE",{"$f":"SUM(B58:B68)","v":44400},{"$f":"SUM(C58:C68)","v":49659.813333333332},{"$f":"SUM(D58:D68)","v":4138.3177777777773},{"$f":"SUM(E58:E68)","v":39293.773333333331},{"$f":"SUM(F58:F68)","v":29470.329999999998}]
[null," "," "," "," "]
["GENERAL"," "," "," "," "]
["PAYROLL TAXES ",1310,1510,{"$f":"C72/12","v":125.83333333333333},{"$f":"F72/9*12","v":1290.56},967.92,"7.65% of Payroll "]
["PROP & LIAB. INSURANCE ",9200,11070,922.5,10750,10747.55]
["EMPLOYEE BENEFITS",5130,5920,493.33333333333331,4072.6,3054.45,"30.% of payroll - Health, Dental, CCOERA & Mtn St Employ Council"]
["WORKMAN'S COMPENSATION",510,590,49.166666666666664,0,0,"3.% of payroll  per Mtn St Employ Council Paid in December-Estimate"]
["EMPLOYEE COMPENSATION",510,590,49.166666666666664,0,0,"3.% of payroll  per Mtn St Employ Council Paid in December-Estimate"]
["BAD DEBT LOSS",1000,650,54.166666666666664,0,0,"estimate"]
["LOSS ON DISPOSAL FIXED ASSET",500,1000,83.333333333333329,1164.3333333333333,873.25,"estimate"]
["DEPRECIATION",31340,31110,2592.5,30200,22469.1]
["TOTAL GENERAL EXPENSE",{"$f":"SUM(B72:B79)","v":49500},{"$f":"SUM(C72:C79)","v":52440},{"$f":"SUM(D72:D79)","v":4370},{"$f":"SUM(E72:E79)","v":47477.493333333332},{"$f":"SUM(F72:F79)","v":38112.269999999997}]
[]
["FINANCING"," "," "," "," "]
["INT ON MORTGAGE PAYABLE",3090,1650,{"$f":"C83/12","v":137.5},{"$f":"F83/9*12","v":3581.0666666666666},2685.8,"2016 Amortization Schedule"]
["MORTGAGE      ",40220,41660,{"$f":"C84/12","v":3471.6666666666665},44542.266666666663,33406.699999999997]
["TOTAL FINANCING",{"$f":"SUM(B83:B84)","v":43310},{"$f":"SUM(C83:C84)","v":43310},{"$f":"SUM(D83:D84)","v":3609.1666666666665},{"$f":"SUM(E83:E84)","v":48123.333333333328},{"$f":"SUM(F83:F84)","v":36092.5}]
[null," "," "," "," "]
["RESERVES"," "," "," "," "]
["REPLACEMENT RESERVES",4800,4800,{"$f":"C88/12","v":400},{"$f":"F88/9*12","v":4800},3600]
["TOTAL RESERVES",{"$f":"B88","v":4800},{"$f":"C88","v":4800},{"$f":"D88","v":400},{"$f":"E88","v":4800},{"$f":"F88","v":3600}]
[null," "," "," "," "]
["CAPITAL EXPENDITURES"," "," "," "," "]
["LAND & IMPROVEMENTS",0,0,{"$f":"C92/12","v":0},0,0]
["BUILDING ",0,0,0,0,0]
["BUILDING IMPROVEMENTS",3000,0,{"$f":"C94/12","v":0},0,0]
["BLDG. EQUIP. FIXED ",4800,0,0,0,0]
["BLDG. EQUIP. PORTABLE",2160,0,0,{"$f":"F96/9*12","v":750.66666666666674},563]
["FURNISHINGS",3000,0,0,0,0]
["MISC. FIXED ASSETS",4000,0,0,0,1696]
["TOTAL CAPITAL EXP.",{"$f":"SUM(B92:B98)","v":16960},{"$f":"SUM(C92:C98)","v":0},{"$f":"SUM(D92:D98)","v":0},{"$f":"SUM(E92:E98)","v":750.66666666666674},{"$f":"SUM(F92:F98)","v":2259}]
[null,null,null,null," "]
["TOTAL EXPENDITURES",{"$f":"SUM(B99+B89+B85+B80+B69+B55+B48)","v":196810},{"$f":"SUM(C99+C89+C85+C80+C69+C55+C48)","v":189659.86733333333},{"$f":"SUM(D99+D89+D85+D80+D69+D55+D48)","v":15804.988944444443},{"$f":"SUM(E99+E89+E85+E80+E69+E55+E48)","v":177222.19999999998},{"$f":"SUM(F99+F89+F85+F80+F69+F55+F48)","v":137152.66999999998}]
[null,null,null,null," "]
["NET GAIN/LOSS",{"$f":"SUM(B22-B101)","v":-26910},{"$f":"SUM(C22-C101)","v":-26649.867333333328},{"$f":"SUM(D22-D101)","v":-2220.8222777777755},{"$f":"SUM(E22-E101)","v":-18193.306666666671},{"$f":"SUM(F22-F101)","v":-17880.999999999985}]

{"sheet":"Hilltop ","index":6,"n_rows":103,"n_cols":7,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"JEFFCO HOUSING CORPORATION"]
[null,"HILLTOP"]
[null,"FY 2016 OPERATING BUDGET"]
[null,null,null,null,null,null,"On 10/2015    Replacement Reserves $59,313.62"]
[null,null,null,null,null,"Actual"]
[null,"Budget","Budget","Budget",null,"YTD ","3% increase over 12/31/2015 potential estimate"]
[null,"FY 2015","FY 2016","FY 2016","FY 2015","FY 2015","unless otherwise noted"]
["OPERATING RECEIPTS","ANNUAL","ANNUAL","Monthly","12MO Estimate","at 9/30/15"]
[]
["RENTAL INCOME",288280,296190,{"$f":"C14/12","v":24682.5},{"$f":"F14/9*12","v":291346.66666666669},218510,"Projected 2015 Rental Income "]
["PET RENT",0,210,17.5,200,150,"Instituted on new leases"]
["VACANCIES",-5770,-5920,-493.33333333333331,-1930.7999999999997,-1448.1,"2% of Rental Income"]
["TRANSFER FROM RESERVES",0,8000,{"$f":"C17/12","v":666.66666666666663},{"$f":"F17/9*12","v":0},0]
["INTEREST INCOME",20,20,1.6666666666666667,9.5466666666666669,7.16]
["LAUNDRY INCOME",620,620,51.666666666666664,569.67999999999995,427.26]
["NSF / LATE  CHARGES",400,390,32.5,650.66666666666663,488,"Estimate"]
["OTHER INCOME",1080,100,8.3333333333333339,513.84,385.38,"Estimate"]
[]
["TOTAL OPERATING RECEIPTS",{"$f":"SUM(B14:B21)","v":284630},{"$f":"SUM(C14:C21)","v":299610},{"$f":"SUM(D14:D21)","v":24967.500000000004},{"$f":"SUM(E14:E21)","v":291359.60000000009},{"$f":"SUM(F14:F21)","v":218519.7}]
[]
["OPERATING EXPENDITURES"]
["ADMINISTRATIVE",{"$f":"B49","v":33650},{"$f":"C49","v":36050.216666666667},{"$f":"D49","v":3004.1847222222218},{"$f":"E49","v":35005.573333333334},{"$f":"F49","v":26254.18}]
["OPERATING",{"$f":"B56","v":17280},{"$f":"C56","v":17179.924586666668},{"$f":"D56","v":1431.6603822222223},{"$f":"E56","v":16520.946666666667},{"$f":"F56","v":13859.96}]
["MAINTENANCE",{"$f":"B69","v":36240},{"$f":"C69","v":75409.653333333335},{"$f":"D69","v":6284.137777777778},{"$f":"E69","v":49946.240000000005},{"$f":"F69","v":37452.339999999997}]
["GENERAL",{"$f":"B80","v":85510},{"$f":"C80","v":88010},{"$f":"D80","v":7334.1666666666661},{"$f":"E80","v":82807.973333333328},{"$f":"F80","v":64078.760000000009}]
["FINANCING",{"$f":"B85","v":130060},{"$f":"C85","v":130060},{"$f":"D85","v":10838.333333333332},{"$f":"E85","v":130060},{"$f":"F85","v":108379.5}]
["RESERVES",{"$f":"B88","v":3600},{"$f":"C88","v":3600},{"$f":"D89","v":300},{"$f":"E89","v":3600},{"$f":"F89","v":2700}]
["CAPITAL EXPENSE",{"$f":"B99","v":35050},{"$f":"C99","v":22700},{"$f":"D99","v":1891.6666666666665},{"$f":"E99","v":8381.5788888888892},{"$f":"F99","v":17124.21}]
["TOTAL OPERATING EXPENSE",{"$f":"SUM(B26:B32)","v":341390},{"$f":"SUM(C26:C32)","v":373009.79458666669},{"$f":"SUM(D26:D32)","v":31084.14954888889},{"$f":"SUM(E26:E32)","v":326322.31222222222},{"$f":"SUM(F26:F32)","v":269848.95}]
["NET INCOME",{"$f":"SUM(B23-B33)","v":-56760},{"$f":"SUM(C23-C33)","v":-73399.794586666685},{"$f":"SUM(D23-D33)","v":-6116.6495488888868},{"$f":"SUM(E23-E33)","v":-34962.712222222122},{"$f":"SUM(F23-F33)","v":-51329.25}]
[]
[]
["ADMINISTRATIVE EXPENDITURES"]
["OFFICE SALARIES",12000,12320,{"$f":"C38/12","v":1026.6666666666667},{"$f":"F38/9*12","v":11960},8970]
["OFFICE SUPPLIES",120,160,{"$f":"C39/12","v":13.333333333333334},{"$f":"F39/9*12","v":151.02666666666664},113.27]
["DUES & MTG EXPENSE",200,120,10,111.89333333333335,83.92]
["CLIENT VERIFICATION SERVICES",0,70,5.833333333333333,{"$f":"F41/9*12","v":0},0,"Estimate "]
["MANAGEMENT FEE",14230,14580,1215,14567.506666666666,10925.63,"Based on 5% of total income minus interest"]
["LEGAL",350,420,35,1702,1276.5,"One legal & sheriff fee "]
["ACCOUNTING/AUDIT",2770,3590,299.16666666666669,3482.5733333333333,2611.9299999999998]
["TELEPHONE",1640,1300,108.33333333333333,1266.44,949.83]
["COMPUTER EXPENSE",0,1670,139.16666666666666,0,0,"Anchor Network 2016 @3% of contract $1242. and new server @ 3% 433.50 "]
["MISC. ADMIN. EXPENSE",1130,{"$f":"SUM(E47*1.03)","v":980.21666666666681},81.684722222222234,951.66666666666674,713.75]
["TRAVEL",1210,840,70,812.4666666666667,609.35]
["TOTAL ADMINISTRATIVE",{"$f":"SUM(B38:B48)","v":33650},{"$f":"SUM(C38:C48)","v":36050.216666666667},{"$f":"SUM(D38:D48)","v":3004.1847222222218},{"$f":"SUM(E38:E48)","v":35005.573333333334},{"$f":"SUM(F38:F48)","v":26254.18}]
[null," "," "," "," "]
["OPERATING EXPENDITURES"," "," "," "," ",null,"Rate Increases for 2015/16 provided from Xcel Energy/Denver Water/Arvada "]
["ELECTRIC",3280,{"$f":"SUM(E52*1.039)","v":2929.9245866666665},{"$f":"C52/12","v":244.16038222222221},{"$f":"F52/9*12","v":2819.9466666666667},2114.96,"3.9%"]
["WATER",7250,7440,620,7152,5364,"4.0.%"]
["GAS",720,700,58.333333333333336,670,502.5,"5.%"]
["SEWER",6030,6110,509.16666666666669,5879,5878.5,"4.% - Annual "]
["TOTAL OPERATING",{"$f":"SUM(B52:B55)","v":17280},{"$f":"SUM(C52:C55)","v":17179.924586666668},{"$f":"SUM(D52:D55)","v":1431.6603822222223},{"$f":"SUM(E52:E55)","v":16520.946666666667},{"$f":"SUM(F52:F55)","v":13859.96}]
[]
["MAINTENANCE EXPENDITURES"]
["JANITORIAL CONTRACT & SUPPLIES",2990,2880,{"$f":"C59/12","v":240},{"$f":"F59/9*12","v":5286.6666666666661},3965,"3% & Laundry cleaning $150month($1800yr) & $1000 for turnover"]
["EXTERMINATING CONTRACT",320,500,41.666666666666664,0,0,"Estimate"]
["TRASH REMOVAL",3780,3670,305.83333333333331,3567,2667.91,"3% & Contract $297.23.month($3567.) "]
["GROUNDS CONTRACT",5790,5790,482.5,5116,3837,"3% & $150wk Apl-Oct(30wks=$4500)+ 580cleanup240sprinklers300trees/maintenance"]
["REPAIR MATERIALS",4210,11340,945,9460.1466666666656,7095.11,"3% & Mailboxes 2 @ $800. ea (1600)"]
["REPAIR CONTRACT ",5500,20750,1729.1666666666667,11603.626666666667,8702.7199999999993,"3% & 11 Deck repairs @$800. ($8,800)"]
["CARPET & VINYL/PLANK",0,4500,375,0,0,"3 units carpet/vinyl/plank  @ $1500 ea"]
["APPLIANCES ",0,10620,885,0,0,"2 Refrigerators ($500ea), 2 Ranges ($465ea), 2 Dishwashers ($345ea) &10AC units (8000.)"]
["REPAIR PAYROLL",11200,{"$f":"SUM(E67*1.03)","v":12439.653333333334},1036.6377777777777,12077.333333333334,9058]
["SNOW REMOVAL",2450,2920,243.33333333333334,2835.4666666666667,2126.6]
["TOTAL MAINTENANCE",{"$f":"SUM(B59:B68)","v":36240},{"$f":"SUM(C59:C68)","v":75409.653333333335},{"$f":"SUM(D59:D68)","v":6284.137777777778},{"$f":"SUM(E59:E68)","v":49946.240000000005},{"$f":"SUM(F59:F68)","v":37452.339999999997}]
[null," "," "," "," "]
["GENERAL"," "," "," "," "]
["PAYROLL TAXES",1770,1900,{"$f":"C72/12","v":158.33333333333334},{"$f":"F72/9*12","v":1982.1466666666665},1486.61,"7.65% of Payroll "]
["PROP & LIAB. INSURANCE ",9000,9200,766.66666666666663,8937,8937.3700000000008]
["EMPLOYEE BENEFITS",6960,7430,619.16666666666663,5997.4933333333329,4498.12,"30.% of payroll - Health, Dental, CCOERA & Mtn St Employ Council"]
["WORKMAN'S COMPENSATION",700,740,61.666666666666664,0,0,"3.% of payroll  per Mtn St Employ Council Paid in December-Estimate"]
["EMPLOYEE COMPENSATION",700,740,61.666666666666664,0,0,"3.% of payroll  per Mtn St Employ Council Paid in December-Estimate"]
["BAD DEBT LOSS",500,500,41.666666666666664,841.33333333333337,631,"estimate"]
["LOSS ON DISPOSAL FIXED ASSETS",500,500,41.666666666666664,0,0,"estimate"]
["DEPRECIATION",65380,67000,5583.333333333333,65050,48525.66]
["TOTAL GENERAL EXPENSE",{"$f":"SUM(B72:B79)","v":85510},{"$f":"SUM(C72:C79)","v":88010},7334.1666666666661,82807.973333333328,64078.760000000009]
[]
["FINANCING"," "," "," "," "]
["INT ON MORTGAGE PAYABLE",21740,16430,{"$f":"C83/12","v":1369.1666666666667},35590,18481.150000000001,"2016 Amortization Schedule"]
["MORTGAGE      ",108320,113630,{"$f":"C84/12","v":9469.1666666666661},94470,89898.35]
["TOTAL FINANCING",{"$f":"SUM(B83:B84)","v":130060},{"$f":"SUM(C83:C84)","v":130060},{"$f":"SUM(D83:D84)","v":10838.333333333332},{"$f":"SUM(E83:E84)","v":130060},{"$f":"SUM(F83:F84)","v":108379.5}]
[null," "," "," "," "]
["RESERVES"," "," "," "," "]
["REPLACEMENT RESERVES",3600,3600,{"$f":"C88/12","v":300},{"$f":"F88/9*12","v":3600},2700]
["TOTAL RESERVES",{"$f":"B88","v":3600},{"$f":"C88","v":3600},{"$f":"D88","v":300},{"$f":"E88","v":3600},{"$f":"F88","v":2700}]
[null," "," "," "," "]
["CAPITAL EXPENDITURES"," "," "," "," "]
["LAND & IMPROVEMENTS",0,0,{"$f":"C92/12","v":0},0,0]
["BUILDING ",0,0,0,0,0]
["BUILDING IMPROVEMENTS",4840,14500,{"$f":"C94/12","v":1208.3333333333333},0,0,"Roof"]
["BUILDING EQUIP. FIXED",23090,8200,683.33333333333337,5380,3358,"Furnaces-2 @ $2500ea($5000)   &  Water Htr -2@$1600.ea($3200)"]
["BLDG. EQUIP. PORTABLE",2620,0,0,1800,2952]
["FURNISHINGS",4500,0,0,{"$f":"F97/9","v":1201.5788888888887},10814.21]
["MISC. FIXED ASSETS",0,0,0,0,0]
["TOTAL CAPITAL EXP.",{"$f":"SUM(B92:B98)","v":35050},{"$f":"SUM(C92:C98)","v":22700},{"$f":"SUM(D92:D98)","v":1891.6666666666665},{"$f":"SUM(E92:E98)","v":8381.5788888888892},{"$f":"SUM(F92:F98)","v":17124.21}]
[null,null,null,null," "]
["TOTAL EXPENDITURES",{"$f":"SUM(B99+B89+B85+B80+B69+B56+B49)","v":341390},{"$f":"SUM(C99+C89+C85+C80+C69+C56+C49)","v":373009.79458666669},{"$f":"SUM(D99+D89+D85+D80+D69+D56+D49)","v":31084.149548888883},{"$f":"SUM(E99+E89+E85+E80+E69+E56+E49)","v":326322.31222222222},{"$f":"SUM(F99+F89+F85+F80+F69+F56+F49)","v":269848.95}]
[null,null,null,null," "]
["NET GAIN/LOSS",{"$f":"SUM(B23-B101)","v":-56760},{"$f":"SUM(C23-C101)","v":-73399.794586666685},{"$f":"SUM(D23-D101)","v":-6116.6495488888795},{"$f":"SUM(E23-E101)","v":-34962.712222222122},{"$f":"SUM(F23-F101)","v":-51329.25}]

{"sheet":"west 46 ","index":7,"n_rows":98,"n_cols":7,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"JEFFCO HOUSING CORPORATION"]
[null,"WEST 46th"]
[null,"FY 2016 OPERATING BUDGET"]
[null,null,null,null,null,null,"On 10/2015     Replacement Reserves $42,500.28"]
[null,null,null,null,null,"Actual"]
[null,"Budget","Budget","Budget",null,"YTD ","3% increase over 12/31/2015 potential estimate"]
[null,"FY 2015","FY 2016","FY 2016","FY 2015","FY 2015","unless otherwise noted"]
["OPERATING RECEIPTS","ANNUAL","ANNUAL","Monthly","12MO Estimate","at 9/30/15"]
[]
["RENTAL INCOME",64320,64320,{"$f":"C13/12","v":5360},{"$f":"F13/9*12","v":65017.333333333336},48763,"Projected 2015 Rental Income "]
["VACANCIES",-1290,-1290,-107.5,0,0,"2% of Rental Income"]
["TRANSFER FROM RESERVES",24000,15000,1250,0,0]
["INTEREST INCOME",20,20,1.6666666666666667,7.1199999999999992,5.34,"Interest from shared reserve account shared with WRP"]
["LAUNDRY INCOME",700,1000,83.333333333333329,923.33333333333326,692.5]
["NSF / LATE  CHARGES",60,60,5,46.666666666666664,35]
["OTHER INCOME",570,570,47.5,848.14666666666676,636.11,"Income from collections of previously written off tenants."]
[]
["TOTAL OPERATING RECEIPTS",{"$f":"SUM(B13:B20)","v":88380},{"$f":"SUM(C13:C20)","v":79680},{"$f":"SUM(D13:D20)","v":6640},{"$f":"SUM(E13:E20)","v":66842.600000000006},{"$f":"SUM(F13:F20)","v":50131.95}]
[]
["OPERATING EXPENDITURES"]
["ADMINISTRATIVE",{"$f":"B45","v":4530},{"$f":"C45","v":5850.3466666666664},{"$f":"D45","v":487.52888888888896},{"$f":"E45","v":4854.0933333333342},{"$f":"F45","v":3640.5699999999997}]
["OPERATING",{"$f":"B52","v":5670},{"$f":"C52","v":4520},{"$f":"D52","v":376.66666666666669},{"$f":"E52","v":3576.04},{"$f":"F52","v":3018.0299999999997}]
["MAINTENANCE",{"$f":"B65","v":15910},{"$f":"C65","v":28810},{"$f":"D65","v":2400.8333333333335},{"$f":"E65","v":17771.32},{"$f":"F65","v":13328.490000000002}]
["GENERAL",{"$f":"B76","v":22810},{"$f":"C76","v":24770},{"$f":"D76","v":2064.166666666667},{"$f":"E76","v":21240.506666666668},{"$f":"F76","v":17349.95}]
["FINANCING",{"$f":"B81","v":32580},{"$f":"C81","v":32580},{"$f":"D81","v":2715},{"$f":"E81","v":32580},{"$f":"F81","v":27150.2}]
["RESERVES",{"$f":"B85","v":5400},{"$f":"C85","v":5400},{"$f":"D85","v":450},{"$f":"E85","v":5400},{"$f":"F85","v":4050}]
["CAPITAL EXPENSE",{"$f":"B94","v":12970},{"$f":"C94","v":2480},{"$f":"D94","v":206.66666666666666},{"$f":"E94","v":3045},{"$f":"F94","v":0}]
["TOTAL OPERATING EXPENSE",{"$f":"SUM(B24:B30)","v":99870},{"$f":"SUM(C24:C30)","v":104410.34666666666},{"$f":"SUM(D24:D30)","v":8700.862222222222},{"$f":"SUM(E24:E30)","v":88466.96},{"$f":"SUM(F24:F30)","v":68537.240000000005}]
["NET INCOME",{"$f":"SUM(B21-B31)","v":-11490},{"$f":"SUM(C21-C31)","v":-24730.346666666665},{"$f":"SUM(D21-D31)","v":-2060.862222222222},{"$f":"SUM(E21-E31)","v":-21624.36},{"$f":"SUM(F21-F31)","v":-18405.290000000008}]
[]
["ADMINISTRATIVE EXPENDITURES"]
["OFFICE SUPPLIES",20,20,{"$f":"C35/12","v":1.6666666666666667},{"$f":"F35/9*12","v":0},0,"Estimate"]
["POSTAGE",90,100,8.3333333333333339,101.02666666666667,75.77,"Estimate"]
["DUES & MTG EXPENSE",50,30,2.5,27.973333333333336,20.98,"Estimate"]
["MANAGEMENT FEE",3220,3230,269.16666666666669,3341.8,2506.35,"Based on 5% of total income minus interest"]
["LEGAL",350,420,35,0,0,"One legal & one sheriff fee"]
["ACCOUNTING/AUDIT",650,{"$f":"SUM(E40*1.03)","v":950.34666666666669},79.195555555555558,922.66666666666663,692]
["TELEPHONE",0,120,10,117.66666666666666,88.25]
["COMPUTER EXPENSE",0,560,46.666666666666664,0,0,"Anchor Network 2016 @ 1% of contract $414.00 and new server @ 1% 144.50"]
["MISC. ADMIN. EXPENSE",70,70,5.833333333333333,0,0,"Estimate"]
["TRAVEL",80,350,29.166666666666668,342.96000000000004,257.22000000000003]
["TOTAL ADMINISTRATIVE",{"$f":"SUM(B35:B44)","v":4530},{"$f":"SUM(C35:C44)","v":5850.3466666666664},{"$f":"SUM(D35:D44)","v":487.52888888888896},{"$f":"SUM(E35:E44)","v":4854.0933333333342},{"$f":"SUM(F35:F44)","v":3640.5699999999997}]
[null," "," "," "," "]
["OPERATING EXPENDITURES"," "," "," "," ",null,"Rate Increases for 2015/16 provided from Xcel Energy/Denver Water/Arvada "]
["ELECTRIC",740,680,{"$f":"C48/12","v":56.666666666666664},{"$f":"F48/9*12","v":0},0,"3.9%        estimate for 2016 Laundry room/common area lights)"]
["WATER",3070,2320,193.33333333333334,2232.04,1674.03,"4.0.%"]
["GAS",550,120,10,0,0,"5.%          estimate for vacancy"]
["SEWER",1310,1400,116.66666666666667,1344,1344,"4.% - Semi Annual"]
["TOTAL OPERATING",{"$f":"SUM(B48:B51)","v":5670},{"$f":"SUM(C48:C51)","v":4520},{"$f":"SUM(D48:D51)","v":376.66666666666669},{"$f":"SUM(E48:E51)","v":3576.04},{"$f":"SUM(F48:F51)","v":3018.0299999999997}]
[]
["MAINTENANCE EXPENDITURES"]
["JANITORIAL CONTRACT",700,450,{"$f":"C55/12","v":37.5},{"$f":"F55/9*12","v":933.33333333333326},700,"Estimate for turnover"]
["EXTERMINATING CONTRACT",1940,1900,158.33333333333334,958.66666666666663,719,"3% & Contract $73 month (876yr)  & one bedbug treatment $1000."]
["TRASH REMOVAL",870,900,75,964.93333333333339,723.7,"3% & Contract $73.month($876.yr)   "]
["GROUNDS CONTRACT",2630,2620,218.33333333333334,2046.6666666666665,1535,"3% & $75wk Apl-Oct(30wks=$2250)+ 300 cleanup/maintenance"]
["REPAIR MATERIALS",2020,3990,332.5,3875.5466666666662,2906.66]
["REPAIR CONTRACT",3190,8190,682.5,2320,1740,"3 % & Ext Paint $3000.Paint Rails $1000. Stain Steps $1800.  "]
["CARPET & VINYL/PLANK",0,1800,150,0,0,"1 unit carpet / vinyl"]
["APPLIANCES ",0,2090,174.16666666666666,0,0,"1 Refrigerator $550 & 1 Range $500 & 3 DWs $1035."]
["REPAIR PAYROLL",3200,5140,428.33333333333331,4985.3333333333339,3739]
["SNOW REMOVAL",1360,1730,144.16666666666666,1686.8400000000001,1265.1300000000001]
["TOTAL MAINTENANCE",{"$f":"SUM(B55:B64)","v":15910},{"$f":"SUM(C55:C64)","v":28810},{"$f":"SUM(D55:D64)","v":2400.8333333333335},{"$f":"SUM(E55:E64)","v":17771.32},{"$f":"SUM(F55:F64)","v":13328.490000000002}]
[null," "," "," "," "]
["GENERAL"," "," "," "," "]
["PAYROLL TAXES",240,390,{"$f":"C68/12","v":32.5},{"$f":"F68/9*12","v":34.773333333333333},26.08,"7.65% of Payroll "]
["PROP & LIAB. INSURANCE ",4820,5850,487.5,5680,5679.57]
["EMPLOYEE BENEFITS",960,1540,128.33333333333334,103.61333333333333,77.709999999999994,"30.% of payroll - Health, Dental, CCOERA & Mtn St Employ Council"]
["WORKMAN'S COMPENSATION",100,150,12.5,0,0,"3.% of payroll  per Mtn St Employ Council Paid in December-Estimate"]
["EMPLOYEE COMPENSATION",100,150,12.5,0,0,"3.% of payroll  per Mtn St Employ Council Paid in December-Estimate"]
["BAD DEBT LOSS",500,600,50,0,0,"estimate"]
["LOSS ON DISPOSAL FIXED ASSET",200,200,16.666666666666668,0,0,"estimate"]
["DEPRECIATION",15890,15890,1324.1666666666667,15422.12,11566.59]
["TOTAL GENERAL EXPENSE",{"$f":"SUM(B68:B75)","v":22810},{"$f":"SUM(C68:C75)","v":24770},2064.166666666667,21240.506666666668,17349.95]
[]
["FINANCING"," "," "," "," "]
["INT ON MORTGAGE PAYABLE",9000,7650,{"$f":"C79/12","v":637.5},9000,7595.89,"2016 Amortization Schedule"]
["MORTGAGE      ",23580,24930,2077.5,23580,19554.310000000001]
["TOTAL FINANCING",{"$f":"SUM(B79:B80)","v":32580},{"$f":"SUM(C79:C80)","v":32580},{"$f":"SUM(D79:D80)","v":2715},{"$f":"SUM(E79:E80)","v":32580},{"$f":"SUM(F79:F80)","v":27150.2}]
[null," "," "," "," "]
["RESERVES"," "," "," "," "]
["REPLACEMENT RESERVES",5400,5400,{"$f":"C84/12","v":450},{"$f":"F84/9*12","v":5400},4050]
["TOTAL RESERVES",{"$f":"B84","v":5400},{"$f":"C84","v":5400},{"$f":"D84","v":450},{"$f":"E84","v":5400},{"$f":"F84","v":4050}]
[null," "," "," "," "]
["CAPITAL EXPENDITURES"," "," "," "," "]
["LAND & IMPROVEMENTS",0,0,{"$f":"C88/12","v":0},0,0]
["BUILDING IMPROVEMENTS",5800,0,{"$f":"C89/12","v":0},0,0]
["BUILDING EQUIP.  FIXED",2480,2480,206.66666666666666,2480,0,"1 Upright Furnace  $2,480. "]
["BLDG. EQUIP. PORTABLE",2090,0,0,565,0]
["FURNISHINGS",1800,0,0,0,0]
["MISC. FIXED ASSETS",800,0,0,0,0]
["TOTAL CAPITAL EXP.",{"$f":"SUM(B88:B93)","v":12970},{"$f":"SUM(C88:C93)","v":2480},{"$f":"SUM(D88:D93)","v":206.66666666666666},{"$f":"SUM(E88:E93)","v":3045},{"$f":"SUM(F88:F93)","v":0}]
[null,null,null,null," "]
["TOTAL EXPENDITURES",{"$f":"SUM(B94+B85+B81+B76+B65+B52+B45)","v":99870},{"$f":"SUM(C94+C85+C81+C76+C65+C52+C45)","v":104410.34666666666},{"$f":"SUM(D94+D85+D81+D76+D65+D52+D45)","v":8700.862222222222},{"$f":"SUM(E94+E85+E81+E76+E65+E52+E45)","v":88466.959999999992},{"$f":"SUM(F94+F85+F81+F76+F65+F52+F45)","v":68537.239999999991}]
[null,null,null,null," "]
["NET GAIN/(LOSS)",{"$f":"SUM(B21-B96)","v":-11490},{"$f":"SUM(C21-C96)","v":-24730.346666666665},{"$f":"SUM(D21-D96)","v":-2060.862222222222},{"$f":"SUM(E21-E96)","v":-21624.359999999986},{"$f":"SUM(F21-F96)","v":-18405.289999999994}]

{"sheet":"Arvada Cottages ","index":8,"n_rows":102,"n_cols":7,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"JEFFCO HOUSING CORPORATION"]
[null,"ARVADA COTTAGES"]
[null,"FY 2016 OPERATING BUDGET"]
[null,null,null,null,null,null,"On 10/2015 Replacement Reserves     $ 14,128.86                  "]
[null,null,null,null,null,null,"                  Operating Reserves          $ 21,124.52"]
[null,null,null,null,null,null,"                   Total Together                 $ 35,253.38"]
[null,null,null,null,null,"Actual"]
[null,"Budget","Budget","Budget",null,"YTD ","3% increase over 12/31/2015 potential estimate"]
[null,"FY 2015","FY 2016","FY 2016","FY 2015","FY 2015","unless otherwise noted"]
["OPERATING RECEIPTS","ANNUAL","ANNUAL","Monthly","12MO Estimate","at 9/30/15"]
[]
["RENTAL INCOME",55520,50890,{"$f":"C14/12","v":4240.833333333333},{"$f":"F14/9*12","v":28945.333333333336},21709,"   current rents                            CHAFA Subsidy( Tenant 20% Chafa 80%)"]
["TENANT ASSISTANCE",222050,203540,16961.666666666668,235761.33333333331,176821]
["VACANCIES",-5550,-5090,-424.16666666666669,-2442.6666666666665,-1832,"2% of Rental Income"]
["INTEREST INCOME",80,80,6.666666666666667,{"$f":"F17/9*12","v":69.74666666666667},52.31]
["NSF & LATE FEES",150,150,12.5,288,216]
["OTHER INCOME",1500,1500,125,7585.9600000000009,5689.47,"      ( Chafa adjustments and Retro Rent)"]
["TOTAL OPERATING RECEIPTS",{"$f":"SUM(B14:B19)","v":273750},{"$f":"SUM(C14:C19)","v":251070},{"$f":"SUM(D14:D19)","v":20922.5},{"$f":"SUM(E14:E19)","v":270207.70666666661},{"$f":"SUM(F14:F19)","v":202655.78}]
[]
["OPERATING EXPENDITURES"]
["ADMINISTRATIVE",{"$f":"B47","v":28190},{"$f":"C47","v":27229.840933333329},{"$f":"D47","v":2269.1534111111109},{"$f":"E47","v":26391.546666666669},{"$f":"F47","v":19793.660000000003}]
["OPERATING",{"$f":"B54","v":21860},{"$f":"C54","v":17530},{"$f":"D54","v":1460.8333333333335},{"$f":"E54","v":16476.646666666667},{"$f":"F54","v":11247.38}]
["MAINTENANCE",{"$f":"B67","v":46580},{"$f":"C67","v":50180},{"$f":"D67","v":4181.666666666667},{"$f":"E67","v":38159.773333333331},{"$f":"F67","v":28619.829999999998}]
["GENERAL",{"$f":"B79","v":67173},{"$f":"C79","v":69700},{"$f":"D79","v":5808.3333333333339},{"$f":"E79","v":64492.56},{"$f":"F79","v":50149.25}]
["FINANCING",{"$f":"B84","v":142470},{"$f":"C84","v":142470},{"$f":"D84","v":11872.5},{"$f":"E84","v":142470},{"$f":"F84","v":118726.95}]
["RESERVES",{"$f":"B87","v":2400},{"$f":"C87","v":2400},{"$f":"D87","v":200},{"$f":"E88","v":2400},{"$f":"F88","v":1800}]
["CAPITAL EXPENSE",{"$f":"B98","v":14120},{"$f":"C98","v":22190},{"$f":"D98","v":1849.1666666666665},{"$f":"E98","v":11506},{"$f":"F98","v":10168.09}]
["TOTAL OPERATING EXPENSE",{"$f":"SUM(B23:B29)","v":322793},{"$f":"SUM(C23:C29)","v":331699.84093333333},{"$f":"SUM(D23:D29)","v":27641.653411111114},{"$f":"SUM(E23:E29)","v":301896.52666666667},{"$f":"SUM(F23:F29)","v":240505.16}]
["NET INCOME",{"$f":"SUM(B20-B30)","v":-49043},{"$f":"SUM(C20-C30)","v":-80629.840933333326},{"$f":"SUM(D20-D30)","v":-6719.1534111111141},{"$f":"SUM(E20-E30)","v":-31688.820000000065},{"$f":"SUM(F20-F30)","v":-37849.380000000005}]
[]
[]
["ADMINISTRATIVE EXPENDITURES"]
[]
["OFFICE SALARIES",8670,8320,{"$f":"C36/12","v":693.33333333333337},{"$f":"F36/9*12","v":8081.0666666666666},6060.8]
["OFFICE SUPPLIES",370,{"$f":"SUM(E37*1.03)","v":260.4389333333333},21.70324444444444,252.8533333333333,189.64]
["DUES & MTG EXPENSE",160,120,10,119.66666666666666,89.75]
["CLIENT VERIFICATION SERVICES",1170,1199.6753333333331,{"$f":"C39/12","v":99.972944444444423},1164.7333333333331,873.55,"Able Real Estate-CHAFA reviews - Client Verification Services & REAC Fees"]
["MANAGEMENT FEE",13680,12500,1041.6666666666667,13506.933333333334,10130.200000000001,"Based on 5% of total income minus interest"]
["LEGAL",1350,1420,118.33333333333333,0,0,"One legal & one sheriff fee & Attys fees of $1000"]
["ACCOUNTING/AUDIT",1460,1460,121.66666666666667,1907.2533333333336,1430.44]
["TELEPHONE",0,300,25,294.17333333333329,220.63]
["COMPUTER EXPENSE",0,560,46.666666666666664,0,0,"Anchor Network 2016 @ 1% of contract  $414.00 and new server @ 1% 144.50"]
["MISC. ADMIN. EXPENSE",440,{"$f":"SUM(E45*1.03)","v":379.72666666666663},31.643888888888885,368.66666666666663,276.5]
["TRAVEL",890,710,59.166666666666664,696.2,522.15]
["TOTAL ADMINISTRATIVE",{"$f":"SUM(B36:B46)","v":28190},{"$f":"SUM(C36:C46)","v":27229.840933333329},{"$f":"SUM(D36:D46)","v":2269.1534111111109},{"$f":"SUM(E36:E46)","v":26391.546666666669},{"$f":"SUM(F36:F46)","v":19793.660000000003}]
[null," "," "," "," "]
["OPERATING EXPENDITURES"," "," "," "," ",null,"Rate Increases for 2015/16 provided from Xcel Energy/Denver Water/Arvada "]
["ELECTRIC",2970,4120,{"$f":"C50/12","v":343.33333333333331},{"$f":"F50/9*12","v":3966.6666666666665},2975,"3.9%"]
["WATER",10940,6250,520.83333333333337,6013.6,4510.2,"4.0.%  City of Arvada"]
["GAS",500,500,41.666666666666664,0,0,"5.%   Estimate vacant unit"]
["SEWER",7450,6660,555,6496.38,3762.18,"2.45% City of Arvada"]
["TOTAL OPERATING",{"$f":"SUM(B50:B53)","v":21860},{"$f":"SUM(C50:C53)","v":17530},{"$f":"SUM(D50:D53)","v":1460.8333333333335},{"$f":"SUM(E50:E53)","v":16476.646666666667},{"$f":"SUM(F50:F53)","v":11247.38}]
[]
["MAINTENANCE EXPENDITURES"]
["JANITORIAL CONTRACT & SUPPLIES",510,1000,{"$f":"C57/12","v":83.333333333333329},{"$f":"F57/9*12","v":973.33333333333337},730]
["EXTERMINATING CONTRACT",4650,4650,387.5,0,0,"2 BB @ $2200 ea(4400.) & regular spray 250."]
["TRASH REMOVAL",2450,2150,179.16666666666666,1950.48,1462.86,"Contract $179 month($2148yr)"]
["GROUNDS CONTRACT",3390,3390,282.5,7593.3333333333339,5695,"Spring Aerated/Fert-Fall est $1120+ $2170 Maint. & 3%"]
["REPAIR MATERIALS",14000,10780,898.33333333333337,10467.706666666667,7850.78]
["REPAIR CONTRACT COSTS",12000,9180,765,6002.666666666667,4502,"3% & $3000 concrete repairs"]
["CARPET & VINYL/PLANK",0,5000,416.66666666666669,0,0,"2 units carpet & vinyl @ $2500.ea ($5000)"]
["APPLIANCES ",0,1930,160.83333333333334,0,0,"2 Refrigerators $500. ea ($1000) &  2 Ranges $465ea (($930)"]
["REPAIR PAYROLL",8840,11360,946.66666666666663,11030.333333333334,8272.75]
["SNOW REMOVAL",740,740,61.666666666666664,141.91999999999999,106.44,"Estimate for vacant units"]
["TOTAL MAINTENANCE",{"$f":"SUM(B57:B66)","v":46580},{"$f":"SUM(C57:C66)","v":50180},{"$f":"SUM(D57:D66)","v":4181.666666666667},{"$f":"SUM(E57:E66)","v":38159.773333333331},{"$f":"SUM(F57:F66)","v":28619.829999999998}]
[null," "," "," "," "]
["GENERAL"," "," "," "," "]
["PAYROLL TAXES",1440,1510,{"$f":"C70/12","v":125.83333333333333},{"$f":"F70/9*12","v":1261.9466666666667},946.46,"7.65% of Payroll "]
["PROP & LIAB. INSURANCE ",8080,8020,668.33333333333337,7787,7787.21]
["EMPLOYEE BENEFITS",5253,5900,491.66666666666669,3878.6800000000003,2909.01,"30.% of payroll - Health, Dental, CCOERA & Mtn St Employ Council"]
["WORKMAN'S COMPENSATION",530,590,49.166666666666664,0,0,"3.% of payroll  per Mtn St Employ Council Paid in December-Estimate"]
["EMPLOYEE COMPENSATION",530,590,49.166666666666664,0,0,"3.% of payroll  per Mtn St Employ Council Paid in December-Estimate"]
["BAD DEBT LOSS",1000,1000,83.333333333333329,0,0,"Estimate"]
["LOSS ON DISPOSAL FIXED ASSET",1000,1000,83.333333333333329,2064.9333333333334,1548.7,"Estimate"]
["OTHER INTERST PAID",310,100,{"$f":"C77/12","v":8.3333333333333339},0,0,"Estimate    2% paid to Tenant at move out per lease"]
["DEPRECIATION",49030,50990,4249.166666666667,49500,36957.870000000003]
["TOTAL GENERAL EXPENSE",{"$f":"SUM(B70:B78)","v":67173},{"$f":"SUM(C70:C78)","v":69700},5808.3333333333339,64492.56,50149.25]
[]
["FINANCING"," "," "," "," "]
["INT ON MORTGAGE PAYABLE",45000,40420,{"$f":"C82/12","v":3368.3333333333335},45000,37813,"2016 Amortization Schedule"]
["MORTGAGE      ",97470,102050,{"$f":"C83/12","v":8504.1666666666661},97470,80913.95]
["TOTAL FINANCING",{"$f":"SUM(B82:B83)","v":142470},{"$f":"SUM(C82:C83)","v":142470},{"$f":"SUM(D82:D83)","v":11872.5},{"$f":"SUM(E82:E83)","v":142470},{"$f":"SUM(F82:F83)","v":118726.95}]
[null," "," "," "," "]
["RESERVES"," "," "," "," "]
["REPLACEMENT RESERVES",2400,2400,{"$f":"C87/12","v":200},{"$f":"F87/9*12","v":2400},1800]
["TOTAL RESERVES",{"$f":"B87","v":2400},{"$f":"C87","v":2400},{"$f":"D87","v":200},{"$f":"E87","v":2400},{"$f":"F87","v":1800}]
[null," "," "," "," "]
["CAPITAL EXPENDITURES"," "," "," "," "]
["LAND & IMPROVEMENTS",0,15000,{"$f":"C91/12","v":1250},0,0,"6 units Sprinkler Systems @ $2,500 each ($15,000)"]
["BUILDING ",0,0,0,0,0]
["BUILDING IMPROVEMENTS",0,0,0,0,1410]
["BLDG. EQUIP. FIXED",7190,7190,599.16666666666663,1372,4153,"2 Wtr Htrs $1595.($3190.) One unit cabinets $4000."]
["BLDG. EQUIP. PORTABLE",1930,0,0,{"$f":"F95/9*12","v":1536},1152]
["FURNISHINGS",5000,0,0,8598,3453.09]
["MISC. FIXED ASSETS",0,0,0,{"$f":"F97/9","v":0},0]
["TOTAL CAPITAL EXP.",{"$f":"SUM(B91:B97)","v":14120},{"$f":"SUM(C91:C97)","v":22190},{"$f":"SUM(D91:D97)","v":1849.1666666666665},{"$f":"SUM(E91:E97)","v":11506},{"$f":"SUM(F91:F97)","v":10168.09}]
[null,null,null,null," "]
["TOTAL EXPENDITURES",{"$f":"SUM(B98+B88+B84+B79+B67+B54+B47)","v":322793},{"$f":"SUM(C98+C88+C84+C79+C67+C54+C47)","v":331699.84093333333},{"$f":"SUM(D98+D88+D84+D79+D67+D54+D47)","v":27641.65341111111},{"$f":"SUM(E98+E88+E84+E79+E67+E54+E47)","v":301896.52666666667},{"$f":"SUM(F98+F88+F84+F79+F67+F54+F47)","v":240505.15999999997}]
[null,null,null,null," "]
["NET GAIN/LOSS",{"$f":"SUM(B20-B100)","v":-49043},{"$f":"SUM(C20-C100)","v":-80629.840933333326},{"$f":"SUM(D20-D100)","v":-6719.1534111111105},{"$f":"SUM(E20-E100)","v":-31688.820000000065},{"$f":"SUM(F20-F100)","v":-37849.379999999976}]

{"sheet":"Allison Village","index":9,"n_rows":101,"n_cols":7,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
[null,"JEFFCO HOUSING CORPORATION"]
[null,"ALLISON VILLAGE"]
[null,"FY 2016 OPERATING BUDGET"]
[null,null,null,null,null,null,"Replacement Reserves $108,313.53 at 10/2015"]
[null,null,null,null,null,"Actual"]
[null,"Budget","Budget","Budget",null,"YTD ","3% increase over 12/31/2015 potential estimate"]
[null,"FY 2015","FY 2016","FY 2016","FY 2015","FY 2015","unless otherwise noted"]
["OPERATING RECEIPTS","ANNUAL","ANNUAL","Monthly","12MO Estimate","at 9/30/15"]
[]
["RENTAL INCOME",111910,113390,{"$f":"C10/12","v":9449.1666666666661},{"$f":"F10/9*12","v":127373.33333333334},95530,"           current rents              (CHAFA Subsidy- Tenant 33% Chafa 67%)"]
["TENANT ASSISTANCE PAYMENTS",227250,230210,{"$f":"C11/12","v":19184.166666666668},213262.66666666669,159947]
["LESS: VACANCIES",-6780,-6870,{"$f":"C12/12","v":-572.5},-11676,-8757,"2% of Rental Income"]
["TRANSFER FROM RESERVES",22000,10000,{"$f":"C13/12","v":833.33333333333337},0,0]
["INTEREST INCOME",100,100,{"$f":"C14/12","v":8.3333333333333339},96,72]
["OTHER INCOME",4100,2000,166.66666666666666,6000,2900.27,"Estimate     Retro Rent   /  Chafa adjs"]
["LAUNDRY / VENDING REVENUE",3500,3500,291.66666666666669,4225.4799999999996,3169.11]
["NSF & LATE CHARGES",890,890,{"$f":"C17/12","v":74.166666666666671},{"$f":"F17/9*12","v":956},717]
["TOTAL OPERATING RECEIPTS",{"$f":"SUM(B10:B17)","v":362970},{"$f":"SUM(C10:C17)","v":353220},{"$f":"SUM(D10:D17)","v":29435.000000000004},{"$f":"SUM(E10:E17)","v":340237.48},{"$f":"SUM(F10:F17)","v":253578.37999999998}]
[]
["OPERATING EXPENDITURES"]
["ADMINISTRATIVE",{"$f":"B46","v":59910},{"$f":"C46","v":61270},{"$f":"D46","v":5105.8333333333321},{"$f":"E46","v":62410.306666666664},{"$f":"F46","v":46807.73}]
["OPERATING",{"$f":"B53","v":47820},{"$f":"C53","v":40769.673146666661},{"$f":"D53","v":3397.4727622222217},{"$f":"E53","v":39166.239999999998},{"$f":"F53","v":30480.73}]
["MAINTENANCE",{"$f":"B67","v":62020},{"$f":"C67","v":86450.489999999991},{"$f":"D67","v":8299.2075000000004},{"$f":"E67","v":72584.08},{"$f":"F67","v":54263.360000000001}]
["GENERAL",{"$f":"B78","v":97180},{"$f":"C78","v":96530},{"$f":"D78","v":8044.166666666667},{"$f":"E78","v":87435.973333333328},{"$f":"F78","v":67516.56}]
["FINANCING",{"$f":"B83","v":123770},{"$f":"C83","v":123770},{"$f":"D83","v":10314.166666666668},{"$f":"E83","v":123770},{"$f":"F83","v":103135}]
["RESERVES",{"$f":"B87","v":15600},{"$f":"C87","v":15600},{"$f":"D87","v":1300},{"$f":"E87","v":15600},{"$f":"F87","v":11700}]
["CAPITAL EXPENSE",{"$f":"B97","v":17470},{"$f":"C97","v":5500},{"$f":"D97","v":458.33333333333337},{"$f":"E97","v":7531.7777777777774},{"$f":"F97","v":10621.279999999999}]
["TOTAL OPERATING EXPENSE",{"$f":"SUM(B21:B27)","v":423770},{"$f":"SUM(C21:C27)","v":429890.16314666666},{"$f":"SUM(D21:D27)","v":36919.180262222224},{"$f":"SUM(E21:E27)","v":408498.37777777773},{"$f":"SUM(F21:F27)","v":324524.66000000003}]
["NET INCOME",{"$f":"SUM(B18-B28)","v":-60800},{"$f":"SUM(C18-C28)","v":-76670.163146666659},{"$f":"SUM(D18-D28)","v":-7484.1802622222203},{"$f":"SUM(E18-E28)","v":-68260.897777777747},{"$f":"SUM(F18-F28)","v":-70946.280000000057}]
[]
[]
[]
[]
["ADMINISTRATIVE EXPENDITURES"]
["SALARIES ",28700,30440,{"$f":"C35/12","v":2536.6666666666665},{"$f":"F35/9*12","v":29557.333333333336},22168]
["OFFICE SUPPLIES",890,730,60.833333333333336,712.97333333333336,534.73]
["DUES & MTG EXPENSE",380,290,24.166666666666668,283.37333333333333,212.53,"REACH membership &  corp board meeting "]
["CLIENT VERIFICATION SERVICES",2160,2330,194.16666666666666,{"$f":"F38/9*12","v":2258.3999999999996},1693.8,"Able Real Estate-CHAFA reviews - Client Verification Services & REAC Fees"]
["MANAGEMENT FEE",17040,17160,1430,16900.399999999998,12675.3,"Based on 5% of estimated 2015 total income minus interest"]
["LEGAL",350,420,35,4725.7733333333335,3544.33,"One legal fee & sheriff"]
["ACCOUNTING/AUDIT",3260,3220,268.33333333333331,3120.08,2340.06]
["TELEPHONE",3990,3340,278.33333333333331,3244.16,2433.12]
["COMPUTER EXPENSE",0,1680,140,0,0,"Anchor Network 2016 @3% of contract $1242. and new server @ 3% 433.50 "]
["MISC ADMIN ",1210,420,35,406,304.5]
["TRAVEL",1930,1240,103.33333333333333,1201.8133333333333,901.36]
["TOTAL ADMINISTRATIVE",{"$f":"SUM(B32:B45)","v":59910},{"$f":"SUM(C32:C45)","v":61270},{"$f":"SUM(D32:D45)","v":5105.8333333333321},{"$f":"SUM(E35:E45)","v":62410.306666666664},{"$f":"SUM(F35:F45)","v":46807.73}]
[null," "," "," "]
["OPERATING EXPENDITURES"," "," "," ",null,null,"Rate Increases for 2015/16 provided from Xcel Energy/Denver Water/Arvada "]
["ELECTRICITY",24640,{"$f":"SUM(E49*1.039)","v":19359.673146666661},{"$f":"C49/12","v":1613.306095555555},{"$f":"F49/9*12","v":18632.986666666664},13974.74,"3.9%"]
["WATER ",6130,8200,683.33333333333337,7889.0666666666666,5916.8,"4.0.%"]
["GAS",10360,7450,620.83333333333337,7099.1866666666674,5324.39,"5.%"]
["SEWER ",6690,5760,480,5545,5264.8,"4% Clear Crk-Sewer-Semi Annual($4900.yr)  2.45% Arvada-Wastewtr- Bi Monthly $860.yr)"]
["TOTAL OPERATING",{"$f":"SUM(B49:B52)","v":47820},{"$f":"SUM(C49:C52)","v":40769.673146666661},{"$f":"SUM(D49:D52)","v":3397.4727622222217},{"$f":"SUM(E49:E52)","v":39166.239999999998},{"$f":"SUM(F49:F52)","v":30480.73}]
[]
["MAINTENANCE EXPENDITURES"]
["JANITORIAL CONTRACT & SUPPLIES",3500,2580,{"$f":"C56/12","v":215},3403,2265,"Laundry $40wk($2080.yr) &  $420. for turnovers. & 3%"]
["EXTERMINATION",1610,2000,166.66666666666666,0,0,"Estimate for general treatment $2000 "]
["TRASH REMOVAL",2430,{"$f":"SUM(E58*1.03)","v":2660.4900000000002},221.70750000000001,2583,2049.8000000000002,"3% Increase + Contract $194.53month($2334.yr) plus extra for additional pickups"]
["GROUNDS CONTRACT",8000,8100,675,{"$f":"F59/9*12","v":8888},6666,"3% & Contract $494 month =$5928  &   $2000. for plantings & additional as needed"]
["REPAIR MATERIALS",12000,14500,1208.3333333333333,14079.466666666667,10559.6]
["REPAIR CONTRACT ",6400,15130,1260.8333333333333,10318.879999999999,7739.16,"3% & Boiler cleaning $1000. & Concrete work on sidewalks $3,500"]
["CARPET & VINYL/PLANK",0,4500,1470,0,0,"3 Units Carpet / Vinyl  or Vinyl Plank  @ $1,500. each"]
["APPLIANCES ",0,1470,122.5,0,0,"2 Refrigerators @$500.ea  &  1 Ranges @ $465"]
["SECURITY CONTRACT",0,6380,531.66666666666663,5026.3999999999996,3769.8,"3% & $1,200 Camera System                        "]
["REPAIR PAYROLL",20980,22430,1869.1666666666667,21778.666666666668,16334]
["SNOW REMOVAL",7100,6700,558.33333333333337,6506.6666666666661,4880]
["TOTAL MAINTENANCE",{"$f":"SUM(B55:B66)","v":62020},{"$f":"SUM(C55:C66)","v":86450.489999999991},{"$f":"SUM(D55:D66)","v":8299.2075000000004},{"$f":"SUM(E56:E66)","v":72584.08},{"$f":"SUM(F56:F66)","v":54263.360000000001}]
[null," "," "," "]
["GENERAL"," "," "," "]
["PAYROLL TAXES",3800,4050,{"$f":"C70/12","v":337.5},{"$f":"F70/9*12","v":3829.28},2871.96,"7.65% of Payroll "]
["PROP & LIAB. INSURANCE ",9560,10710,892.5,10397,10396.74]
["EMPLOYEE BENEFITS",14910,15860,1321.6666666666667,11758.56,8818.92,"30.% of payroll - Health, Dental, CCOERA & Mtn St Employ Council"]
["WORKMEN'S COMPENSATION",1490,1590,132.5,0,0,"3.% of payroll  per Mtn St Employ Council Paid in December-Estimate"]
["EMPLOYEE COMPENSATION",1490,1590,132.5,0,0,"3.% of payroll  per Mtn St Employ Council Paid in December-Estimate"]
["BAD DEBT LOSS",4800,2000,166.66666666666666,732.38666666666654,549.29,"Estimate "]
["LOSS ON DISPOSAL FIXED ASSETS",360,230,19.166666666666668,218.74666666666667,164.06,"Estimate "]
["DEPRECIATION EXPENSE ",60770,60500,5041.666666666667,60500,44715.59]
["TOTAL GENERAL EXPENSE",{"$f":"SUM(B70:B77)","v":97180},{"$f":"SUM(C70:C77)","v":96530},{"$f":"SUM(D70:D77)","v":8044.166666666667},{"$f":"SUM(E70:E77)","v":87435.973333333328},{"$f":"SUM(F70:F77)","v":67516.56}]
[]
["FINANCING"]
["MORTGAGE INTEREST",69680,67070,{"$f":"C81/12","v":5589.166666666667},69680,58225.61,"2016 Amortization Schedule"]
["MORTGAGE PRINCIPAL",54090,56700,4725,54090,44909.39]
["TOTAL FINANCING",{"$f":"SUM(B81:B82)","v":123770},{"$f":"SUM(C81:C82)","v":123770},{"$f":"SUM(D81:D82)","v":10314.166666666668},{"$f":"SUM(E81:E82)","v":123770},{"$f":"SUM(F81:F82)","v":103135}]
[null," "," "," "]
["RESERVES"," "," "," "]
["REPLACEMENT RESERVES ",15600,15600,{"$f":"C86/12","v":1300},{"$f":"F86/9*12","v":15600},11700]
["TOTAL RESERVES",{"$f":"B86","v":15600},{"$f":"C86","v":15600},{"$f":"SUM(D86)","v":1300},{"$f":"E86","v":15600},{"$f":"F86","v":11700}]
[null," "," "," "]
["CAPITAL EXPENDITURES"," "," "," "]
["LAND & IMPROVEMENTS",3500,0,{"$f":"C90/12","v":0},0,0]
["BUILDING ",0,0,0,0,0]
["BUILDING IMPROVEMENTS",0,0,{"$f":"C92/12","v":0},0,45]
["BLDG. EQUIP. FIXED",3000,3000,250,4345,1425,"2 Units Cabinets   @ $1500. ea  "]
["BLDG. EQUIP. PORTABLE",1470,0,0,{"$f":"F94/9","v":115.77777777777777},1042]
["FURNISHINGS",4500,0,0,3071,8109.28]
["MISC. FIXED ASSETS",5000,2500,208.33333333333334,0,0,"Storage Shed"]
["TOTAL CAPITAL EXP.",{"$f":"SUM(B90:B96)","v":17470},{"$f":"SUM(C90:C96)","v":5500},{"$f":"SUM(D90:D96)","v":458.33333333333337},{"$f":"SUM(E90:E96)","v":7531.7777777777774},{"$f":"SUM(F90:F96)","v":10621.279999999999}]
[]
["TOTAL EXPENDITURES",{"$f":"SUM(B97+B87+B83+B78+B67+B53+B46)","v":423770},{"$f":"SUM(C97+C87+C83+C78+C67+C53+C46)","v":429890.16314666666},{"$f":"SUM(D97+D87+D83+D78+D67+D53+D46)","v":36919.180262222217},{"$f":"SUM(E97+E87+E83+E78+E67+E53+E46)","v":408498.37777777773},{"$f":"SUM(F97+F87+F83+F78+F67+F53+F46)","v":324524.65999999997}]
[]
["NET GAIN/(LOSS)",{"$f":"SUM(B18-B99)","v":-60800},{"$f":"SUM(C18-C99)","v":-76670.163146666659},{"$f":"SUM(D18-D99)","v":-7484.1802622222131},{"$f":"SUM(E18-E99)","v":-68260.897777777747},{"$f":"SUM(F18-F99)","v":-70946.28}]

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