Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2013-12-31 South Bend Cash Benchmarking Report
Period Ending: December 31, 2013 Issued By: Controller City of South Bend South Bend Cash Benchmarking Report Page Numbers Contents 2 South Bend Cash Position Overview 3 -4 Cash Balances 5 -6 Cash Balances - Per Capita 7 -8 Cash Summary - Comparative Balances 9 -11 Cash Summary Detail 12 -13 South Bend Cash Balances 14 Mishawaka Cash Balances 15 -16 Evansville Cash Balances 17 -18 Bloomington Cash Balances 19 -20 Hammond Cash Balances 21 Carmel Cash Balances 22 -24 Gary Cash Balances 25 -26 Fort Wayne Cash Balances Distribution Mayor Pete Buttigieg Deputy Mayor Mark Neal Chief of Staff Kathryn Roos Deputy Chief of Staff Brian Pawleski City Controller John Murphy City Finance Director Rahman Johnson Financial Officer Cecil Eastman Financial Officer Danny Cocanower South Bend Cash Position Overview Methodology used The following charts and data information was compiled to compare the city of South Bend's cash position to the cash positions of similarly sized cities. South Bend is the 4`h largest city in Indiana behind Indianapolis, Fort Wayne and Evansville. City sizes were based on data from the 2010 Census. Based on the census, the cities that surveyed were Fort Wayne (2), Evansville (3), Bloomington (5), Hammond (6), and Carmel (7) and Gary (8). Included in the comparison was Mishawaka due to its proximity to South Bend. Indianapolis was not used because due to its size it was felt the numbers would not be comparative. Cash position information was obtained from the Indiana Gateway website. For all the cities, the 2013 cash positions were available. From the cash detail of each of the cities certain common funds were used to compare. The funds used to compare were General, Rainy Day, Parks, Motor Vehicle Highway, Local Road & Street, Firefighter's and Police Pension Fund in the General Governmental category. The two main Enterprise funds (Wastewater and Water) along with the enterprise fund subtotals were then compared. These funds and subtotals were then calculated on a per capita basis. Two sets of charts were created. The first set based on the dollar position of the funds and the second based on the per capita position of the funds. General comments South Bend cash position comparatively was strong in the Governmental funds. South Bend had larger balances in those funds available than even the second largest city in the state. The Enterprise fund cash balances for South Bend were reasonable based on the size of the cities compared. Overall, the grand total of all funds South Bend demonstrates that South Bend had a very good cash position comparatively at December 31, 2014. When reviewing the General and Parks /Recreation funds for Hammond they have negative balances. Hammond does keep monies in different listed funds such as Gaming Revenue and other TIF and Bond funds. The negative General Fund balance in Hammond was off set by the revenue funds giving the General Governmental balance a positive. Cash Benchmarking Report 4/4/2014 Total Cash Balances 350,000.00 v c c 300,000.00 r 250,000.00 200,000.00 150,000.00 100,000.00 50,000.00 SubTotal - General Governmental SubTotal - Enterprise Funds Grand Total Ft Wayne #2 ■ Evansville #3 ■ South Bend #4 ■ Bloomington #5 ■ Hammond #6 ■ Carmel #7 ■ Gary #8 ■ Mishawaka #17 Cash Benchamrking Report 4/4/2014 3 5,000,000.00 4,500,000.00 4,000,000.00 3,500,000.00 3,000,000.00 2,500,000.00 2,000,000.00 1,500,000.00 1,000,000.00 500,000.00 Fire and Police Pensions Cash Balances 1937 Firefighter's Pension 1925 Police Pension ■ Ft Wayne #2 ■ Evansville #3 ■ South Bend #4 ■ Bloomington #5 ■ Hammond #6 ■ Carmel #7 ■ Gary #8 ■ Mishawaka #17 Enterprise Funds Cash Balances 200,000,000.00 180,000,000.00 160,000,000.00 140,000,000.00 120,000,000.00 100,000,000.00 80,000,000.00 60,000,000.00 40,000,000.00 201000,000.00 Wastewater Water Other Eterprise Fund SubTotal - Enterprise Funds ■ Ft Wayne #2 ■ Evansville #3 ■ South Bend #4 ■ Bloomington #5 ■ Hammond #6 ■ Carmel #7 ■ Gary #8 ■ Mishawaka #17 Cash Benchamrking Report 4/4/2014 4 3,000.00 Total Cash Balances - Per Capita 2,500.00 2,000.00 1,500.00 1,000.00 500.00 SubTotal - General Governmental SubTotal - Enterprise Funds Grand Total Ft Wayne #2 ■ Evansville #3 ■ South Bend #4 ■ Bloomington #5 ■ Hammond #6 ■ Carmel #7 ■ Gary #8 ■ Mishawaka #17 400.00 300.00 200.00 100.00 (100.00) (200.00) (300.00) (400.00) (500.00) General Fund Cash Balances - Per Capita ■ Ft Wayne #2 ■ Evansville #3 ■ South Bend #4 ■ Bloomington #5 ■ Hammond #6 ■ Carmel #7 ■ Gary #8 ■ Mishawaka #17 Cash Benchmarking Report 4/4/2014 1,000.00 900.00 800.00 700.00 600.00 500.00 400.00 300.00 200.00 100.00 Enterprise Funds Cash Balances - Per Capita Wastewater Water Other Eterprise Fund SubTotal - Enterprise Funds ■ Ft Wayne #2 ■ Evansville #3 ■ South Bend #4 ■ Bloomington #S ■ Hammond #6 ■ Carmel #7 ■ Gary #8 ■ Mishawaka #17 Cash Benchmarking Report 4/4/2014 6 City Benchmarking Cash Summary Per Capita Ft Wayne #2 Evansville #3 South Bend #4 20.71 Dollar Amount 280.60 (0.00) 24.95 85.18 4.46 5.15 42.06 Fund Name South Bend #4 Mishawaka #17 Evansville #3 Bloomington #5 Hammond #6 Carmel #7 Gary #8 Ft Wayne #2 General Fund 28,388,090.82 4,393,023.80 769,009.57 5,655,187.88 (33,829,001.34) 3,704,607.65 (4,036,043.01) 5,254,137.81 Rainy Day Fund 8,617,704.61 1,063,964.52 2,930,358.01 4,618,556.96 - 8,976,882.24 11,264.14 (0.05) Parks & Recreation 4,255,159.85 861,583.68 604,508.36 56,357.91 (1,925,990.92) 3,577,802.41 568.50 1,132,053.67 Motor Vehicle Highway 3,679,914.90 1,852,468.90 404,347.62 1,221,535.45 (3,139,277.36) 2,933,636.07 213,520.28 1,551,134.45 Local Road & Street 1,941,374.71 258,461.11 4,097,040.45 - (971,506.92) 662,309.79 404.66 1,815,355.16 1937 Firefighter's Pension 938,100.31 887,819.94 4,296,773.06 1,421,525.36 4,113,820.94 810,079.30 2,225,148.17 435,674.16 1925 Police Pension 1,708,656.46 782,879.80 4,234,721.68 1,222,300.50 3,068,357.88 568,641.68 1,021,334.31 1,630,810.24 SubTotal - General Governmental 179,549,910.04 65,137,521.83 70,970,886.49 54,119,240.76 37,951,520.26 44,651,914.03 33,318,811.68 126,812,834.27 SubTotal - Enterprise Funds 67,799,867.26 38,052,788.25 100,757,479.14 23,779,571.03 49,510,154.96 8,552,174.36 24,195,117.92 177,106,283.74 Grand Total 247,349,777.30 103,190,310.08 171,728,365.63 77,898,811.79 87,461,675.22 53,204,088.39 57,513,929.60 303,919,118.01 Wastewater 50,211,851.26 27,847,837.50 54,412,531.52 13,013,516.04 37,940,734.00 6,939,154.36 20,906,375.91 134,388,190.21 Water 12,909,470.80 274,681.25 46,344,947.62 10,106,147.39 2,906,420.24 1,613,020.00 - 35,071,279.64 Other Eterprise Fund 4,678,545.20 9,930,269.50 - 659,907.60 8,663,000.72 - 3,288,742.01 7,646,813.89 SubTotal - Enterprise Funds 67,799,867.26 38,052,788.25 100,757,479.14 23,779,571.03 49,510,154.96 8,552,174.36 24,195,117.92 177,106,283.74 Per Capita Ft Wayne #2 Evansville #3 South Bend #4 20.71 6.55 280.60 (0.00) 24.95 85.18 4.46 5.15 42.06 6.11 3.44 36.37 7.16 34.89 19.19 1.72 36.59 9.27 6.43 36.06 16.89 499.87 604.37 1 ,774.77 698.12 858.03 670.17 1,197.99 1,462.40 2,444.94 529.73 463.37 496.32 138.24 394.66 127.60 30.14 - 46.25 698.12 858.03 670.17 Cash Benchmarking Report 4/4/2014 7 City Benchmarking Cash Summary Fund Name Bloomington #5 Hammond #6 Carmel #7 Gary #8 Mishawaka #17 General Fund 69.00 (418.52) 46.78 (50.98) 91.04 Rainy Day Fund 56.35 113.36 0.14 22.05 Parks & Recreation 0.69 (23.83) 45.18 0.01 17.86 Motor Vehicle Highway 14.90 (38.84) 37.05 2.70 38.39 Local Road & Street - (12.02) 8.36 0.01 5.36 1937 Firefighter's Pension 17.34 50.89 10.23 28.11 18.40 1925 Police Pension 14.91 37.96 7.18 12.90 16.22 SubTotal - General Governmental 660.29 469.52 563.85 420.85 1,349.94 SubTotal - Enterprise Funds 290.13 612.52 107.99 305.61 788.63 Grand Total 950.41 1,082.04 671.85 726.46 2,138.57 Wastewater 158.77 469.39 87.63 264.07 577.13 Water 123.30 35.96 20.37 - 5.69 Other Eterprise Fund 8.05 107.18 - 41.54 205.80 SubTotal - Enterprise Funds 290.13 612.52 107.99 305.61 788.63 Cash Benchmarking Report 4/4/2014 8 Cash Summary Detail South Bentl 101168 Mishawaka 48132 Evansville 11]429 Bloomington 81983 Nammond ...a. Carmel ]9191 Gary ]91]0 Ft Wayne 253691 Type End Cash Eod Cash End Cash End Cash End Cash End Cash End Cash End Cash &Inv Bal &Inv Sol &Inv Bal &Inv Bal &Inv Bat &1. Sal &Inv Bat &Inv Bal Local Fund Local Funtl Name Dec 31, 2013 Dec 31, 2013 Dec 31, 2013 Dec 31, 2013 Local Funtl Local Funtl Name Dec 31, 2013 Dec 31, 2013 Dec 31, 2013 Dec 31, 2013 Number Number Activities 280.6. 91.04 6.55 89.00 Activities (418.521 46.78 (50.98) 20.71 102 Rainy Day Funtl 80,617,71.61 85.18 $1,063,964.52 22.115 $2,930,358.01 24.95 $4,618,556.96 56.35 - $8,9]6,882.24 113.36 $11,266.16 0.14 40.05 (0.00; 201 Parks &Recreation $4,255,159.85 42.06 8061,503.68 1].86 $604,508.36 5.15 $56,35].91 O.fi9 204 PARK - $1,825,980.82 (23.831 $3,5]],802.41 45.18 8568.50 0.01 81,132,053.6] 4.qg 202 Motor Vehicle Highway $3,6]9,914.90 36.3] $1,852,1 38.39 $404,34].62 3.44 $1,221,535.45 14.90 201 M.V.H. - $3,138,2]].36 (38.841 $2,933.636.0] 3].05 $213,520.28 2.70 $1,551,134A 6.11 251 Local Road &street $1,941,3]4.]1 19.19 111 $250,461.11 5.36 $4,09],040.45 34.89 - 202 LRS $8]1,506.82 112.021 $662,309.]9 8.36 $406.66 0.01 $1,815,355.16 7.18 203 Recreation- NOnreverting $]]8,249.03 7.119 $355 ,400.68 7.3] - $1,95],384.03 23.88 - - 54,209.8] 0.05 5503.602.63 1.99 701 193]Firefightaf Pension $938,100.31 9.2] $68],819.94 18.40 34,298,]]3.06 36.59 $1,421,525.36 1].34 702 FIRE PENSION $4,113,820.94 50.89 $810.0]9.30 10.23 $2,225,148.1] 28.11 1396]4.16 1.]2 702 1925 Police Pension $1,708.656.41 16.89 $]82,8]9.60 16.22 $4,234,]21.80 36.06 $1,222,300.50 14.91 703 POLICE PENSION $3,088,35].88 3].98 $568.641.88 ].18 $1.021,334.31 12.90 $1,630.810.24 6.43 712 PUSH, Employees Retirement $695.88 O..1 $16,877,862.1 349.]9 - $400.00 0.00 010 CUT AND CLEAN $31,338.48 0.39 $4,707.06 $20,]23.48 0.08 711 Self - Funded Health Insurance $5.661 44710 55.96 $93,8]6.4] 1.94 430,416.14 10.26) $3]8,159.22 4.59 212 SELF INSURANCE $2,551,930.36 31.5] $3,2]2.223.02 41.32 - $1.033,928.]9 (13.011) $2.029,065.30 8.00 249 Public Setsy Lot FUnd $2,032,19408 20.D9 $2.400,667.05 49.]5 $1,]138] 0.01 $28,833.40 0.35 239 PUBLIC SAFETY $89,120.33 O.Bfi 50.00 $19,42].50 0.25 $]0.56 0.00 209 Studebaker /Oliver Revitallz Gams $1,083,38690 10.]1 - $904,10114 ].70 $1,532.94 0.02 011 GRAFFITI REMOVA $29.99 0.00 $166.180.23 2.10 $88,352.21 1.12 $32,937.52 0.13 210 Dept Community Investment State Gams $348.950,41 3.45 - $428.10 0.00 $39,8]0.]3 10.49) 012 HOMEBOUND $49,988.01 0.62 $205.486.05 2.59 $1.204,108.05 15.21 528],064.38 1.13 211 Dept. of Community Investment Operating $90],314.95 g.g7 $56,3]2.33 1.1] $98,81].48 0.84 $483,021.36 5.89 013 REDVPARTYFUND $282,80].39 3.50 $789.015.28 9.96 51,520.65 0.02 - $55,818.48 (0.22; 212 Dept of COmmuniy Investment Gams $590,181.96 $4.12 $2],340.53 $2,832.85 014 HPRP HOmdess Preventim $0.00 $459.849.04 $223,884.81 $1.393,395.09 5.83 0.00 (0.23) 0.03 - 5.81 2.83 5.49 216 Pdiw Stde Seizuas $158,686.56 1.57 $14,922.84 0.31 $2,566.]] 0.02 $2,610.00 0.03 015 NSPMEIGH STAB $145,963.30 1.81 $1,8]8,024.]] 23.]2 4714,593.08 (9.03) $1],926.63 0.07 21] Gfit,Dwdiw Bequest $]4,]34.28 0.14 $]0,146.54 1.45 $3,]99.18 0.03 $995.9] 0.01 016 ENGINEERING $2,]]8,312.95 1,37 $8,29].80 0.10 $1,5]9.]] 0.02 - $7,821.29 111 3; 218 Pdiw CUdew YOletions $11,54].89 0.11 - - $10,930.89 (0.09) $10.]8 0.00 01] ABAP GRANT $65,2]4.92 0.81 $386,401.49 4.88 $5,899.89 0.0] $34],550.93 1.37 220 Lan E "f...ot Cwti "ui"e Educad. $981,225.69 9.70 $]],365.35 1.60 $29,029.55 0.25 494,261.67 200 PUBLIC DEFENDER $1,575.00 0.02 $52],]58.38 6.a 58,226.18 0.08 4290,940.68 222 Central Services $1,485,]08.]8 14.49 $2,518.88 O.DS $98,81].40 0.86 $163,834.91 (1.15) 2..0 $576,185]2 ].28 $90,]11.22 1.15 - $56,529.25 (1.15; (0.22; 228 Liablllty Insurance $5,185,49].38 51.26 $34,783.50 0.72 $34,]00.01 0.30 $40,93].0] 0.50 $132,68488 1.68 $6,161.65 0.08 $884,457.08 3.49 227 Loss Recovery $],938,032.6] 78.44 - $0.00 _ $188,1]5.83 2.2] 203 HAZ -MAT $]],9]8.0] 0.98 $9]5,156.10 12.31 $12,643.88 0.16 - $633.93 (0.00; 252 Excess Welfare Di.sibution $1,149.81 $1],151.5] $]4,274.43 $88,604.08 $3.822,4]2.92 $0.95 - $63,180.63 0.01 0.36 0.63 1.18 - 48.27 0.00 (0.25; 21 Hume "Rights Gant $666,]74.9] 4.61 $1,325.89 0.03 $1,]]2,621.5] 15.10 $0.00 - 207 FED FORFERPRO $21,638.36 0.27 15.6] 0.00 $49,013.92 0.82 $0.00 - 271 Eestraca WaternaY $16,3]2.2] 0.14 $213,657.14 4.43 $46,]84.95 0.40 $68.90 0.00 209 EVIDENCE MONEY $20,628.82 026 $185,895.35 2.09 5190,28].86 2.40 11987].92 1,94 273 M.ois PauPalais Royale Marketing $2],985.28 0.28 $110,]43.96 2,30 $1,54].50 0.01 $1,6]8,389.59 20.48 213 HIDTA $44,395.93 055 $0.00 4398,686.]] (5.01) 43,502.16 (0.01; 21 Taka Home Police Vehicle $452,952.01 4.48 $8,989.16 0.19 487,326.81 (0.74) $8],930.95 1,07 214 POLICE DONATION $40,056.14 0.50 $595.63 0.01 $25,855.15 0.33 $1,]]2,354.]1 g,gg 2811 Pdiw Block Grants $3,81].211 O.04 $446.68 - $102,838.22 0.88 $13,305.68 0.16 215 PARKACTNRIES $40,850.98 0.51 $3,839.]] OAS $54,812.80 0.69 57085.2 0.03 281 Economic Development Revenue Bonds $27,12].]2 0.27 $58,15].66 1.21 $169,141.18 1.44 $19600.00 0.20 216 BACKGROUND CKS $355.14 0.00 $458.29 0.01 $10,569.23 0.13 $20,061.11 0.08 288 E-Tire Deparb"ent CaPiWI $5,554,584.56 $344,883.04 $5,525.82 $260,005.24 218 HIDTA Equipment Gant $388.39 $50,503.23 $100,807.55 - $29,]'95.6] 54.80 7.15 0.05 3.17 0.00 0.64 1.2] (0.12; 289 Hazmd FU"tl $16,20].39 0.18 $4,044.92 0.08 $23,511.]0 0.20 $83,590.1] 1.02 219 Recyding $215,133.00 2.86 $105,152.82 1.33 $91,594.]1 1.16 - $15,535.]0 (0.08; 291 Intliena River Rescue $95,]18.35 0.85 $0.00 - $2,802.61 0.02 $8,964.]1 0.11 220 STATE FORFIETED $30,131.24 0.3] $29.90 0.00 $1]],233.15 2,24 5129,299.12 11.51 292 Pdiw Gants $204,500.8] 2.02 $3,231,314.]7 66.87 $3,4]].80 0.03 $4,595.98 0.08 223 CLKS PERPETUAL $128,040.38 1.58 $17,1311.24 0.22 $13,585.68 0.17 $738,221.89 2.91 294 RegiwalPdiw Ara y $68,084.]5 0.67 $19915,263.10 350.58 $3811.94 0.00 $43,831.88 0.53 224 FED PRISONERS $403,918.39 5.00 :10A 0.70 0.02 4403,642.30 (5.10) $3,02],429.8] 11.93 295 Cops More Gant $113,362.60 1,12 $O.DO - - $113,]2].55 (0.54) $3,444,]31.00 42,03 226 Saatbelt Enforcement - $1,451.88 (0.02) 120,181.03 1.52 9635.03 0.08 3,839,4119.00 15.13 299 Pdiw Fed -Drug Enforcement $385,160.01 3.61 $3]6,552.20 7,90 $36,485.811 0.31 $2,]01,918.50 32.8] 227 IMPAIRED DRIVEI - $8,418.95 (0.10) $8,143.111 0.10 $83,955.]8 1.08 $27656 0.00 313 HBIIOf Fame Deb-m- $]16,335.66 7,08 $777,122.05 16,11 $186,408.1 7,40 $950,354.3] 11,59 228 REDEVELOPMENT $134,8]5.40 1,67 $394]9.59 0.38 $],355.39 0.08 $4,205,352.18 18.58 315 Aiacrt Debt Serviw $1,038,904..0 10.27 $O.DO - $]5,38].04 0.64 $82,828.25 1,01 230 C.-bia Plaza TIF $1,04],913.62 12,96 $48,043.68 01 $2.80 0.00 $3,665,958.]2 14,45 317 Cweleaki BO"d Debt Serviw Reserve $.3,472.41 4,88 $ %3.25 0.01 $323,691.52 2,76 $3,3]9,302.58 41,23 231 Lear TIF $2,400,358.5] 29.70 $112,2.10.98 079 - $18,101.55 (0.23) Woo - 319 Retlevelopment Bond - Blackthorn $0.00 $1,240,0]3.18 25.87 $423,953.61 3.81 $626,434.]8 7.84 232 PARKROURISM $4,]96,40 0.08 $4]2,003.38 598 $29176.81 0.34 $19,211.03 0.08 324 T'rf Dishict -amort $25,020,129A6 247.31 $2,161,833.10 44.80 $0.00 $4,0]8,996.25 49.]7 233 ECOO -URISM $28,909.33 0.38 $],959,588.33 100.51 $223,21].82 2.92 $2,552,066.25 10.06 32a Sbcd.2003D.d Rawrva $1,]35,040.0 17.16 $5,13.03 0.12 $86,]48.03 0.74 $1.1 439.53 23.53 234 Downtmm TIF $2,869,154.]1 33.03 548,411.08 0.61 $11,]85.92 0.15 $1,362,686.29 5.37 31 Professional sports Development $342,05],48 0.32 $103,506.90 3.80 $0.00 $90,025.55 1.10 236 CDBG ESCROW $225,339.90 2.79 $50.8]8.44 0.74 $8,]75.52 0.11 - $19,157A1 401 Coveleskl Stadium Capital $26,850.09 0.27 $3],2]5.05 0.77 $8]3,191.20 - 7.44 $1,133,164.02 13.83 237 HUMAN RELATIONS $6,401.27 0.08 $562,292.96 7.10 $33.752.6] 0.43 $331,845.98 (O..: 1.31 403 Zw Endowment $49,022.38 OA8 $5,801,029.8] 12922 $193,]81.]9 1.85 $181.988.53 1.98 240 GAMING REVENUE $28.439,]84.12 32].10 $261,318.20 3.30 $324.13 0.00 $438,908.]4 1.73 404 CwMy Optiw Income Tax $14,905,834.88 147.36 $1,586,926.82 32.89 $0.00 _ $28.8]0.98 0.35 246 WATER HYDRANTR $19],290.86 2.44 $241,941.24 3.06 $340,1]4.]] 4.30 $]9,038.38 0.31 405 Park NOnreveding Capitd $5]2,891.14 1.61 - $0.00 _ $44,]1].05 0.55 248 PENALTIES $2,643,448.06 32.]0 - $185,8]0.00 2.35 $3]0,583.53 1.46 406 Cumulative Capital Development $785,]98.58 7.77 - $252,442.82 2.15 $24.224.63 0.30 250 Human Rda0ws Gant $6,408.89 0.08 - $4,131.64 0.05 $810,198.51 3.19 40] Cumulative Capbdlmpmvement $1]6,]23.90 $0.00 $1,182,616.58 $6,851.30 251 HUMAN REL(FED) $81,152.48 $922.]9 $1,3]9,568.80 1.75 - 10.07 0.08 0.76 - 0.01 5.44 400 Economic Development Income Tax $10,842,12].9] 107.17 $1,960,97o.lo 40.81 $3,090,023.19 26.31 $2,018.18 0.02 252 Tansit $3]5,309.00 (q,1) $12,563.80 0.16 $212,056.63 1.11 010 Urban / do "Gant $27,58].- 0.27 $],106,231.10 60.60 $314,111.4] 3.83 253 LOCALSEIZURE $8,18].]0 (0.10) - $2,506.81 0.03 $1,907,370,47 7.52 412 MaIor -as $],143,09].92 ]0.61 $14,0]9,3]5.11 119.90 $15,348.29 0.19 262 C.D.B.G. 4350,0]0.22 (4.33) - $4,904,]42.3] 81.95 $2,009152,40 7.91 016 M"rris-oni"g Alta C.Pital $456,010.19 4.52 - $0.00 $16,3X.18 020 264 AMBULANCE FEES 4249,]34.54 (3.09) - $20,450.09 0.26 $4,269,]89.21 16.91 421 T'rf Dishict -Sbctla General $2,6X,4]4.13 25.74 - $]8,418.01 0.67 $1,059.12 0.01 266 CDBG DONATION $12,968.90 0.16 - - 1421,334,41 (5.32) $218,170,41 0.86 422 T'rf Di. - -West Weehloglon $612,862.22 6.06 - $32,151.34 0.27 $83,322.68 1.02 266 AC DONATION $2,855.13 0.04 - $651 Al 0.01 :38,154AS 0.15 425 T'rf Dishict- Leighton Plaza $133,066.50 1.32 $],856,9]9.59 86.89 $1,2]5,321.90 15.58 269 VEHICLE RELEASE $1],229.26 0.21 - $4],183.96 0.80 $61,]83.]6 0.24 426 Tit Disbid- Central Medical Sery $3,232,412.40 31.95 $8,598,143.5] 73.22 $0.00 270 UNEMPLOYMENT - $474,486.84 (6.87) - $14,]99.94 0.19 $95,236.56 0.38 429 T'rf Dils -11- Northeast $3,008,71.1 29.]4 - $68,]5].12 0.59 $8,908.33 0.11 272 ADULT PROBATION $99,694.43 1.23 - $58,524.00 0.74 $0.00 _ 430 T'rf Dm-- Smoh316e Developmen $3,639,64].92 34.00 - $447.]]926 3.61 $195,939.85 2.39 273 TOBACCO ED /JUDG $1],133.60 0.21 - $20].05 0.00 -$1,800,558.24 432 Td DiShict- Eakins Village $6,968,686.2] 68.88 - $536,]01.99 4.5] $195,203.24 2.38 276 HENRY UNIT - $1,298,452.]1 (18.081 - $3]6.00 0.00 $773,555.61 3.05 433 Retlevelopmen[Pdministration Genera $25,]40.52 0.25 - $231,240.26 1.97 $23,]11.55 0.29 282 PARK/GAMING $14,008.01 0.17 - $885.80 0.01 $1,088,]80.]5 429 434 Creetl FUnd $9,536.69 0.09 _ $1,491,]23.44 12.]0 $958,283.40 11.89 285 AFFORD HOUSING 4127,063.61 (1.57) - $22,45 0.00 $53,9:18A 021 435 T'rf Oia0ict- Douglas ROatl $296,600.35 2.91 - - $1,45].60 (0.01) $135,0]0.90 1.85 286 EMERGENCY /CDBG $38,36].86 0.47 - $1,000,360.28 12.64 $1,41],808AS 5.59 436 1111at Neighborhaxt R-d.11 Tif $2,5X,0]0.]9 25.25 _ $21],131.33 1.65 $47.0]9.93 0.5] 28] SECTION 108 $81,486.38 1.01 - 80.00 _ $792,214.62 3.12 439 C.6- Technology P- $3,602,585.46 36.40 - $11,9]].05 0.10 $53,8]0.39 0.86 288 TECHNICALGRANT $1,053,]]2.25 13.04 - $583,878.86 7.38 $1,286,988.90 5.07 450 Palais Royale Historic Preservation $53,385.30 0.53 - $6,0]5.61 0.05 $0.00 _ 290 Home Depot- $2,313,093.92 28.62 - $2.000,949.02 25.27 $3.680]08.32 14.51 41 Airyod Urban Entemrise Zone $3]6,3]1.5] 3,72 - $2,289.30 0.02 $52,689.12 0.64 291 Wootlmar TIF $4,11.139.]3 60.55 - $0.00 - $423,856.22 1.67 655 Project Reled $838,5]8.11 9.28 - $5,3]6.96 0.05 $2,653,548.88 32.3] 292 Wootlmar Gateways TIF $]80,518.68 9.66 - $860,000.00 10.88 $2,043,]26Al 9.08 6]] HaII Of Fame Depreciation $658,406.]3 6.51 - $734,402.53 6.25 $6,038,342.4] 73.67 293 INSPT/RENTAL $2]9,]53.05 (3.48) - $0.00 - $891,980.81 3.52 703 Pdic Fire19779tate Pension $2]3.49 0.00 - $133,641.65 1.14 $1,069166.92 13.01 295 Garewsys TIF $2,228,266.31 2].56 - $246,5]9.4] 3.11 $11,561.83 0.05 ]05 Pdiw K -9U "it $1,313.19 001 - $50,002.46 OAS $2,684,413.50 32.75 305 HD BOND 756775 $82,652.59 1.02 - $335,000.00 423 $1,5]2,842.18 6.20 ]09 Payroll FUnd $2,9]0.63 0..3 - $12,8X.66 0.11 $15,]05.00 0.19 306 CML CITY BOND - $15,850.3] (0.20) - $10.5]1,81].0] 133.53 $ 165,428.44 0.85 ]13 Unemployment Comp fund $260,030.03 2.57 - $0.00 _ $0.00 _ 307 H D PROJ ]56]]6 $0.00 - $]5,]53.80 0.96 ]18 State Tax Deduction $296,]40.83 2.91 - $0.00 _ $0.00 _ 309 RP GAM 756773 $2,013,]55.91 24.91 - $451,481.45 5.70 5717,44].]] 2.83 ]25 Morris /Palais BOx Offiw $1,338,58].81 13.24 - $253,442.]8 2.16 - 310 Judge Gen 756777 4350,501.25 (4.34) 80.56 0.00 511,013.43 0.65 ]3o City Cemetery Trust $36,9X.10 0.37 - $6]9,196.93 5.78 - 319 Poach -$0.16 (0.001 - $8,179.63 0.12 $663,]76.71 2.92 321 Potash Bond Inteast $0.00 _ $1],016.16 021 $1,168,061.18 4.60 322 Poach Bond COI $0.00 _ $21,310.56 0.2 $820,385.28 3.23 323 Potash Bond Co" -doo $],511,409.53 92.93 - 8983.50 0.01 861,646.44 (L. 324 Potash bond DSR $1,121,113.10 $21(io 77 $228,379.60 13.8] - 2.73 0.90 325 Jobs BIII Bond COI -$0.32 (0.00) - $0.30 0.00 $1,423,912.]4 5.61 326 Jobs BIII Bond DSR $1,735,424.02 21.47 - $20,708.19 0.26 -$34,685.28 (0.14; Cash Benchmarking Report 4/4/2014 9 Cash Summary Detail Type umber Local Fund Name South Bend End Cash &Inv Bat Dec 31, 2013 101168 Per Capita Mishawaka 48252 -C sh Blnv Bat Dec 31, 2013 Per Capita Evansville End Cash &Inv Bat Dec 31, 2013 117429 Per Capita Bloomington End Cash &Inv Bat Dec 31, 2013 81963 Per Capita Local Fpntl Number Local Emd Name Nammond End Cash &Inv Bat Dec 31, 2013 a.a30 Per Capita Carmel 19191 End Cash &1. Bel Dec 31, 2013 Per Caplb Gary End Cash &Inv "I Dec 31, 2013 ]91]0 Per Capita Ft Wayne ntl Cash &Inv Bal Dec 31, 2013 253691 Per Capita 327 Jobs Rebl $38,ld -3 0.45 - $2,034.96 0.03 $1,892,519.55 ].46 401 C.C.I.F. $58,]92.52 0.]3 - $4,010.]5 0.05 $43,012.00 0.1] 404 MPJOR MOVES $1],351.22 $329,196.23 $103,209.40 0.21 - 4.18 0.41 406 Red P & 1 4152,434.38 $13,395.00 $51,]00,]25.03 (1.89) - 0.17 203.79 408 -S/10-5 $1,360,835.60 $43,013.56 0.54 $38,34].]4 0.15 414 Potash Bond General $153,999.49 $9,988.20 $3.562,600.19 1.91 - 0.13 14.04 416 River Park Refunding Ganerd $1,300,658.16 16.09 $1,000,000.00 12.63 $998,102.75 3.93 417 Job, BIII Bond Gw,,l Fund $13,826.04 - $6,345.16 0.17 - 0.08 - .5 C.C.D.F. $361,803.11 4.48 $434.39 0.01 461 0 LFCOURSE 4244,289.55 (3.021 - - $1,082,440.68 13.67 - - :2,211.04 0.02 503 COST DUE COUNTY $0.00 _ $2,099.00 0.03 - $3.303.11 0.D3 504 CONTINUING ED $51,801.15 0.60 - $1,220.982.59 15.42 - $0.00 _ 505 DEFERRAL PROGRA $210,510.50 2.60 - $30.509.88 0.39 - $0.00 _ 508 PRETRWL DIVPG $2,630.00 0.03 - $445.11 0.01 - $535,476.11 4.58 002 FACADE $50,529.88 0.63 - $3.541.28 0.00 - $18.53 0.G0 004 CENTRE% - $]],443.21 (0.9fi1 - $20].240.56 2.62 - 008 DIESEL FUEL TAX $4,]98.84 O.o - $]5.08 0.00 - 00] COLLEGE BOUND $44,509.62 0.55 - $2.000.00 0.03 - 008 DEMOLRION $9]5,925.50 12.07 - $294.04 0.00 - 708 PAVWITHHOLDING $126,41].02 1.56 - $441.55 0.01 - CLRK City CleM Tru,t Fund, $2,992,720.04 37.02 - $4.838.43 0.06 - $261.38 0.00 - $311,611.15 3.94 - $15.818.09 0.20 - $1).848.01 0.14 - $1624].66 0.21 - $90.82726 1.15 - $153,719.30 1.94 $0.00 $9,202.fi5 - $494A9 0.01 - $19,9fi0.)9 0.25 - $0.00 Efi,264.32 0.08 - E8,63].50 0,11 - $63,19].5] 0.80 - $153,308.28 $1,098.00 1.94 0.01 $11,503.51 0.15 4250,489.5] (3.16) $]3,]62A9 0.93 - $Sfi,Bfi].OS 0.]2 $3,500.00 - 0.04 $50,134.08 0.83 - $64,828A6 0.82 - $31,963.13 0.40 - $518,650A5 6.55 - $459,691A7 5.81 - $ifi,886A9 0.21 - $4,012,244A1 50.68 - $349,698.fi8 4.41 _ $416,214A2 5.28 - $0.00 $15,]56.84 0.20 - $172,009A6 2.17 - $229,489.3] 2.90 - $90,982A 1.15 - $%. o - $]3,0]0.89 0.92 - $35,496.80 0.45 - $167 ,096.52 2.11 - $2.641.98 0.03 - $11,]92.52 0.15 - $811A 0.01 - $228,234.02 2.88 - $361,441.]9 4.5] - $15,621.40 0.20 - $2.189.21 0.03 - $0.01 0.00 - 830,]06.94 0.39 - $ubTOtal- Gen eral Governmental $1.1.9,910.04 1,11.]] 585,13],511.83 1,349.94 $]0,9]0,888.49 604.3] $54,119,140.]8 680.29 SobTOtel $37,951,520.26 469.52 $44,651,914.03 563.85 $33,318,811.68 420.85 $118,811,834.2] 499.B7 GOLF COURSE 619 Blacklhom Golf Course Operations $83,]29.44 $659,907.60 $42,921.20 $5.198,322.22 8.05 - - 0.54 20.49 SobTotel $83,]29.. 0.83 - $0.00 - _ $3,245,820.81 41.00 $548,]92.00 2.16 PARKING 601 PaMing Gemges $884,187.62 $659,907.60 $3,288,742.01 $0.00 GARAGES g.]4 - BOB - - 41.54 - SubTOtal $884,18].82 g,)4 _ _ _ - $5,748,114.22 22.66 SOLIDWASTE 610 Sdid Wa,te Opemdon, $]95,2]4.55 ].86 8649,225.01 13.45 - - - - $3]6,923.6] 1.49 611 Sdid Weae Cepila1 $118,440.52 1.17 - - - $376,923.67 1.49 Cash Benchmarking Report 4/4/2014 10 Cash Summary Detail Type Local Fund Number Local Fund Name South Bend End Cash &Inv Bal Dec 31, 2013 101168 Per Capita Mishawaka End Cash &Inv Bat Dec 31, 2013 48252 Per Capta Evansville End Cash &Inv Bal Dec 31, 2013 117429 Per Capita Bloomington End Cash &Inv Bat Dec 31, 2013 81963 Per Capita Local Fond Number Local Fond Name Hammond End Cash &1. Bat Dec 31, 2013 80830 Per CSPHa Carmel End Cash &1. Bel Dec 31,201S 19191 Per Capita Gary End Cash &Inv Bal Dec 31, 2013 ]91]0 Per CePlta Ft Wayne I." tl Cash lnv gal Dec 31, 2013 253691 Per Capita Sub,TPtel 5913 ,]15.0] 9.03 $849,225.01 13.45 - - - - - - WASTEWATER 640 Sewer Repel, insurance $1,363,695.84 $3,961.33 SANITARY A Operations - $1,29],624.00 $1,980.80 $10,540,61345 13.48 0.08 - - DISTRICT 116.05) - 0.03 41.55 641 Sewage WOMB OPeredOns $7,286,00308 $2,238,131.98 $5,40],03].93 $3,250,087.13 B Pre Treatment $406,492.00 $20,387.98 $2,434,395.25 $10.688,539.85 72.02 46.38 46.05 39.65 5.03 0.26 30.75 42.13 642 Sewage WOMS Capital $4,04a,566.m 39.98 $3,49D,582.25 72.34 $],03],849.30 59.93 $2,996,445.99 36.56 C Unemployment $51,380.00 0.64 $1,852,334.90 23.40 $15,082,181.56 59.45 643 Sewage Worts Reserve $3,292,599.55 $10,238,686.86 $1,781,936.81 $6,]24,52].01 D Debt Service Non Exempt $140,824.00 $0.03 - $2,142,703.05 $25,392,122.57 O &M 32.55 212.19 15.17 62.04 1.74 0.00 27.06 100.09 645 20-006 Sewer BOntls $0.00 $185,810.85 3.85 $27,422,866.60 233.53 $42,455.91 0.52 D2 Debt Service Exempt - $1,130,063.00 113.98) $182,191.08 2.30 $3,500,299.15 44.21 $152,082.33 0.60 64] 2007 Se -Bond $1,140.88 - $],]22,160.06 $332,157.66 $0.00 E Sewer $103,394.00 $120,890.52 $2],213.6] $18,120.54 0.01 160.04 2.63 - (1.28) 1.53 0.34 0.07 649 Sewage Works Bond Sinking $]82,806.62 7.74 $3,968,504.07 82.25 $12,430,683.22 105.86 G GIS $2,039.00 0.03 $2,800,374.19 35.36 $],1]3,451.81 90.61 $0.00 650 Clay Sewage W rkS $0.00 - H Slmm Water $1,755,211.00 $3,815,310.56 $2.995.348.85 $444,538.02 - Op"" "s - - - - 21.71 48.18 37.83 1.75 651 2007B Sewer BOntl $2.11 0.00 - - - Sanife5m - $448,613.00 (5.55) - $95,64S44 1,20 $8,395,900.0] 33.09 653 Sewage Works DS Reserve $],286,828.40 72.D3 11 Recyding - $995,320.00 $444,192.99 5.61 $0.00 658 2010 Sewage WOMB $2,215.16 - - - L Great Lakes Legacy $46,101.00 112.31) - $68.004.66 $1,096,]1].81 - Revenue Bond Cons 0.02 - - - 0.57 - 0.86 4.32 659 Sewer BOntl of2011 $7,848,499.09 ]7.58 N 2010 BOntl $4,978,534.00 61.59 $114,468AO 1.45 $62,577,374.02 246.67 661 2012 Sewer Bond $18,299,026.78 180.88 - - - - - - O SRF Loan $922,827.00 11.42 - - $56,633.04 0.72 - 684 2013A SEWER REFUND $4,46].]3 P Replacement $1,635,031.00 BOND 0.04 - - - 20.23 - - - O CapileI Pd-la BAN $1,670,416.10 20,67 - - - R SRF Loan ] $So1 So. ,]23.00 374,94 - - - SubTotsl $50,211,851.26 486.32 $27,847,837.50 5]].13 $64,412,531.52 463.37 $13,013,518.00 158.]7 SubTptel $37,940,734.00 469.38 $8,939,154.38 87.63 $20,908,3]5.91 264.0] $134,388,190.21 529.]3 WATER 620 Water WOdcs OpemSOns $3,509,]55.6] $3,002,060.30 $3,673,499.96 $3,824,2Bfi.61 WATER W Water UDliry $2,90fi,420.24 $19,25].84 $13,300,093.55 34.69 62.22 31.28 46.66 UTILITY 35.96 0.26 - 52.43 822 Water Works DaplUl $3,531,725.44 $379.55 $3,788,232.12 $35,150.00 $1,226,713.50 $26],46].98 34.91 0.01 32.28 0.43 - 15.49 - 1.05 623 Water WOdcs BOntl CepBel $812,630.2fi 8.03 $1,033,315.58 21.41 $122,809.05 1.05 $4,485.49 0.05 $0.16 0.00 $9,516,629.06 37.51 824 Water Works Customer $1,452,815.03 $825,416.]1 $1,095,178.16 - $39,190.00 - $9,444,343.68 Deposit 14.38 12.96 9.33 - - 0.49 - 37.23 625 Wale, WO- Sinking $5,33fi.6] 0.05 $1,356,2]9.57 28,11 $33,244,621.81 283.10 $598,610.18 7,30 - $32],755.80 4.14 - $788,116.65 3,11 626 Was, W- Bond Reserve $1,S65,fi7fi.05 15.48 $8,01],451.]1 124.]1 $392,1]9.]0 3.34 $5,643,615.11 fi8.86 $89.97 0.00 $1,441,581.55 S.S. 629 Water Works Reserve 0 &M $2,031,531.88 $4,028,426.83 - $12.73 - $0.00 20.08 - 34.31 - - 0.00 - - SubTotsl $12,909,470.80 12].60 $2]4,fie1.25 5.69 $46,344,947.82 394.fi6 $10,106,147.39 123.30 SubTOta1 $2,908,420.24 35.9fi 51,813,020.00 20.3] $313,24].19 1.23 CENTURY 670 Century Center $887,475.05 $18,349.76 PORT 415 2008 Revenue Bond $1,250,000.00 - $35,0]1,2]9.64 CENTER 8.77 0.38 - - AUTHORITY DSR 16.46 - - 138.24 671 Century Cenfer CBPBel $1,]5],69].36 17.37 $2,491,243.02 51.fi3 416 2008Revenue Bmtl Debt Service $1,222,375.86 15.12 $274,893.37 1.08 SubTotal $2,645,172.41 $]54,000.00 - - 626 Marina Operations $698,014.68 - - $16,149.03 26.15 7.40 - - 0.06 CONSOLIDATED 600 Consdidetetl Building fund $151,]40.66 $3,538,2]4.03 627 Marina DansWCOOn $2,986.031.43 - $26,17926 BUILDING DEPARTMENT 1.50 73.33 - - 36.94 - (0.10) SubTotal $151,]40.66 1.50 - - - 828 Gaming Fund $710,521.20 8.79 - $264,863.14 1.04 829 Lakefront $36,604.05 $1,256,912.86 Management 4.95 630 I- Mareh Golf Course $589,357.69 7.29 - - $1,256,912.86 4.95 831 Wolf Lake Op -tons $316,444.34 3.90 633 RDAPrajed $955,750.06 11.82 - - 708 Re Oland Withholding 498.47 (0.00) SubTotal $8,663,000.72 107.18 - - - - - - SubTotal - Enterprise Funds $67,799,867.26 6]0.1] $38,052,78835 788.63 $100,757,479.14 858.03 $23,779,571.03 290.13 $49,510,154.96 612.52 $8,552,1]4.36 107.99 $24,195,11].92 305.61 $177,10 .2.3.74 688.12 GRAND TOTAL $247,349,771.30 2,444.94 $103,190,310.48 2,138.57 $171,728,365.69 1,462,40 $77,898,811.79 950.41 GRAND TOTAL $17,461,6]5.22 1,OB2.04 $53,204,088.39 671.85 $3],513,929.60 72fi.4fi $ 303,919,118.01 1,197.99 $24],349,]]].30 $103,190,310.08 $171,728,3fi5.fi3 $]],898,811.]9 $8],461,6]5.22 $53,204,088.39 $5],513,929.fi0 $303,919,118.01 $0.00 $0.00 $0.00 $0.00 80on $0.00 80.00 $0.00 Cash Benchmarking Report 4/4/2014 11 12 South Bend Civil City, St. Joseph County, Indiana Cash & Investments Combined Statement - 2013 Beg Cash End Cash & Inv Bal & Inv Bal Local Fund Local Fund Name Jan 1, 2013 Receipts Disbursement Dec 31, 2013 Number Governmental Activities 101 General Fund $28,205,847.66 $62,367,950.13 $62,185,706.97 $28,388,090.82 102 Rainy Day Fund $8,588,180.46 $29,524.15 $0.00 $8,617,704.61 201 Parks & Recreation $4,885,352.16 $11,768,204.83 $12,398,397.14 $4,255,159.85 202 Motor Vehicle Highway $2,271,733.07 $9,139,123.46 $7,730,941.63 $3,679,914.90 203 Recreation - Nonreverting $671,131.84 $1,003,318.24 $896,201.05 $778,249.03 209 Studebaker /Oliver Revitaliz Grants $1,079,675.32 $3,711.58 $0.00 $1,083,386.90 210 Dept. Community Investment State Grants $918,454.91 $238,065.58 $807,570.08 $348,950.41 211 Dept. of Community Investment Operating $584,036.54 $2,491,610.65 $2,168,332.24 $907,314.95 212 Dept. of Community Investment Grants $514,341.13 $4,483,440.81 $4,407,619.98 $590,161.96 216 Police State Seizures $144,925.09 $27,470.27 $13,728.80 $158,666.56 217 Gfit, Donation Bequest $63,232.94 $11,501.34 $0.00 $74,734.28 218 Police Curfew Violations $10,884.70 $662.99 $0.00 $11,547.69 220 Law Enforcement Continuing Educatio $1,087,206.88 $194,527.76 $300,508.95 $981,225.69 222 Central Services $1,090,656.09 $7,254,876.33 $6,879,825.66 $1,465,706.76 226 Liability Insurance $5,245,412.02 $3,009,846.76 $3,069,761.40 $5,185,497.38 227 Loss Recovery $4,341,561.12 $3,845,642.67 $251,171.12 $7,936,032.67 249 Public Safety Loit Fund $2,989,940.29 $6,582,642.32 $7,540,388.53 $2,032,194.08 251 Local Road & Street $1,714,297.82 $1,008,942.88 $781,865.99 $1,941,374.71 252 Excess Welfare Distribution $1,145.87 $3.94 $0.00 $1,149.81 258 Human Rights Grant $486,164.25 $178,147.89 $197,537.17 $466,774.97 271 Eastrace Waterway $14,323.04 $49.23 $0.00 $14,372.27 273 Morris Pac /Palais Royale Marketing $28,762.72 $7,113.42 $7,890.86 $27,985.28 278 Take Home Police Vehicle $391,805.21 $124,847.60 $63,700.00 $452,952.81 280 Police Block Grants $3,804.12 $13.08 $0.00 $3,817.20 281 Economic Development Revenue Bonds $27,034.80 $92.92 $0.00 $27,127.72 288 Ems /Fire Department Capital $5,522,334.84 $8,323,033.45 $8,290,783.71 $5,554,584.58 289 Hazmat Fund $2,682.93 $16,762.02 $3,237.56 $16,207.39 291 Indiana River Rescue $119,423.45 $66,067.69 $89,772.79 $95,718.35 292 Police Grants $98,125.00 $162,837.89 $56,454.02 $204,508.87 294 Regional Police Academy $73,815.26 $21,013.43 $26,743.94 $68,084.75 295 Cops More Grant $107,288.86 $23,068.02 $17,014.28 $113,342.60 299 Police Federal Drug Enforcement $335,340.82 $194,568.72 $144,749.53 $385,160.01 313 Hall Of Fame Debt Service $574,438.99 $1,406,962.98 $1,265,066.31 $716,335.66 315 Airport Debt Service $1,038,904.00 $3,566.58 $3,566.58 $1,038,904.00 317 Coveleski Bond Debt Service Reserve $501,747.51 $1,724.90 $0.00 $503,472.41 319 Redevelopment Bond - Blackthorn $326,000.00 $463.63 $326,463.63 $0.00 324 TifDistrict - Airport $18,429,251.52 $15,818,784.21 $9,227,906.27 $25,020,129.46 328 Sbcda 2003 Debt Reserve $1,735,840.00 $5,959.19 $5,959.19 $1,735,840.00 377 Professional Sports Development $1,040,822.42 $677,704.63 $876,470.00 $842,057.05 401 Coveleski Stadium Capital $26,758.08 $92.01 $0.00 $26,850.09 403 Zoo Endowment $48,846.07 $176.31 $0.00 $49,022.38 404 County Option Income Tax $15,327,002.33 $8,509,056.80 $8,930,424.27 $14,905,634.86 405 Park Nonreverting Capital $492,385.07 $228,720.50 $148,214.43 $572,891.14 406 Cumulative Capital Development $835,769.21 $552,147.51 $602,118.14 $785,798.58 407 Cumulative Capital Improvement $97,720.44 $446,578.46 $367,575.00 $176,723.90 408 Economic Development Income Tax $9,984,411.08 $8,785,077.43 $7,927,360.54 $10,842,127.97 410 Urban Development Action Grant $23,753.29 $3,833.77 $0.00 $27,587.06 412 Major Moves $7,896,696.41 $500,881.81 $1,253,680.30 $7,143,897.92 416 Morris Performing Arts Capital $396,267.78 $101,947.06 $41,404.65 $456,810.19 420 Tif District - Sbcda General $2,843,356.75 $3,464,065.63 $3,702,948.25 $2,604,474.13 422 Tif District- West Washington $451,728.77 $495,043.07 $333,809.62 $612,962.22 425 Tif District - Leighton Plaza $95,394.64 $159,289.20 $121,617.26 $133,066.58 426 Tif District- Central Medical Sery $3,859,101.03 $1,233,918.58 $1,860,607.21 $3,232,412.40 429 Tif District - Northeast $2,219,622.79 $849,684.81 $60,517.06 $3,008,790.54 430 Tif District - Southside Developmen $5,394,776.59 $2,421,637.98 $4,376,766.65 $3,439,647.92 432 Tif District - Erskine Village $5,567,627.20 $1,891,063.62 $490,004.55 $6,968,686.27 433 Redevelopment Administration Genera $31,443.12 $103.55 $5,798.15 $25,748.52 434 Creed Fund $223,586.53 $244,899.16 $458,949.00 $9,536.69 435 Tif District - Douglas Road $160,925.75 $324,393.04 $190,718.44 $294,600.35 436 Northeast Neighborhood Resident Tif $3,501,311.10 $2,271,187.71 $3,218,420.02 $2,554,078.79 439 Certified Technology Park $816,361.78 $2,866,233.68 $0.00 $3,682,595.46 450 Palais Royale Historic Preservation $58,304.29 $15,561.01 $20,470.00 $53,395.30 454 Airport Urban Enterprise Zone $375,082.11 $1,289.46 $0.00 $376,371.57 655 Project Releaf $859,452.10 $435,939.89 $356,813.88 $938,578.11 677 Hall Of Fame Depreciation $719,086.15 $2,457.86 $63,137.28 $658,406.73 701 1937 Firefighter's Pension $1,346,414.54 $5,038,210.68 $5,446,524.91 $938,100.31 702 1925 Police Pension $2,310,075.76 $5,874,864.96 $6,476,284.26 $1,708,656.46 703 Police /Fire 1977 State Pension $530,225.46 $2,393,806.97 $2,923,758.94 $273.49 705 Police K -9 Unit $1,930.55 $7.64 $625.00 $1,313.19 709 Payroll Fund $0.00 $94,684,399.22 $94,681,420.59 $2,978.63 711 Self- Funded Health Insurance $7,428,190.64 $12,156,648.32 $13,923,391.86 $5,661,447.10 712 Public Employees Retirement $240,769.61 $420,557.53 $660,631.26 $695.88 713 Unemployment Comp fund $72,566.03 $252,907.02 $65,443.02 $260,030.03 718 State Tax Deduction $283,370.12 $3,361,110.01 $3,349,731.20 $294,748.93 725 Morris / Palais Box Office $1,383,306.44 $3,336,239.60 $3,379,948.23 $1,339,597.81 Cash Benchmarking Report 4/4/2014 12 Cash Benchmarking Report 4/412014 13 South Bend Civil City, St. Joseph County, Indiana Cash & Investments Combined Statement - 2013 Beg Cash End Cash & Inv Bal & Inv Bal Local Fund Local Fund Name Jan 1, 2013 Receipts Disbursement Dec 31, 2013 Number 730 City Cemetery Trust $41,112.09 $137.84 $4,315.83 $36,934.10 SubTotal $171,210,657.35 $303,818,017.87 $295,478,765.18 $179,549,910.04 GOLF COURSE 619 Blackthorn Golf Course Operations $45,371.49 $1,580,511.58 $1,542,153.63 $83,729.44 SubTotal $45,371.49 $1,580,511.58 $1,542,153.63 $83,729.44 PARKING GARAGES 601 Parking Garages $855,444.13 $971,598.05 $942,854.56 $884,187.62 SubTotal $855,444.13 $971,598.05 $942,854.56 $884,187.62 SOLID WASTE 610 Solid Waste Operations $1,169,979.65 $5,407,945.24 $5,782,650.34 $795,274.55 611 Solid Waste Capital $108.55 $830,707.32 $712,375.35 $118,440.52 SubTotal $1,170,088.20 $6,238,652.56 $6,495,025.69 $913,715.07 WASTEWATER 640 Sewer Repair Insurance $1,160,016.75 $552,868.74 $349,189.65 $1,363,695.84 641 Sewage Works Operations $4,431,602.79 $31,682,765.52 $28,828,365.23 $7,286,003.08 642 Sewage Works Capital $8,863,108.93 $194,409.99 $5,012,952.91 $4,044,566.01 643 Sewage Works Reserve O &M $3,092,303.65 $211,331.80 $11,035.90 $3,292,599.55 645 2004/2006 Sewer Bonds $12.43 $0.00 $12.43 $0.00 647 2007 Sewer Bond $19,040.75 $41.87 $17,941.74 $1,140.88 649 Sewage Works Bond Sinking $836,045.47 $9,463,724.16 $9,516,963.01 $782,806.62 650 Clay Sewage Works Operations $696.45 $1.81 $698.26 $0.00 651 2007B Sewer Bond $39,557.49 $68.98 $39,624.36 $2.11 653 Sewage Works Ds Reserve $9,710,816.93 $14,098.85 $2,438,087.38 $7,286,828.40 658 2010 Sewage Works Revenue Bond Cons $112,203.24 $215.58 $110,203.66 $2,215.16 659 Sewer Bond of 2011 $10,166,509.94 $30,970.18 $2,348,981.03 $7,848,499.09 661 2012 Sewer Bond $23,246,887.70 $65,015.76 $5,012,876.67 $18,299,026.79 664 2013A SEWER REFUND BOND $0.00 $85,746.98 $81,279.25 $4,467.73 SubTotal $61,678,802.52 $42,301,260.22 $53,768,211.48 $50,211,851.26 WATER 620 Water Works Operations $1,763,223.47 $15,109,623.03 $13,363,090.83 $3,509,755.67 622 Water Works Capital $4,145,317.31 $13,708.93 $627,300.80 $3,531,725.44 623 Water Works Bond Capital $5,802,836.53 $16,550.36 $5,006,756.63 $812,630.26 624 Water Works Customer Deposit $ 1,408,694.37 $49,021.41 $4,900.75 $1,452,815.03 625 Water Works Sinking $4,636.52 $2,056,003.60 $2,055,303.45 $5,336.67 626 Water Works Bond Reserve $1,311,688.08 $253,987.97 $0.00 $1,565,676.05 629 Water Works Reserve O &M $1,986,230.68 $52,227.60 $6,926.60 $2,031,531.68 SubTotal $16,422,626.96 $17,551,122.90 $21,064,279.06 $12,909,470.80 CENTURY CENTER 670 Century Center $901,198.47 $3,348,874.59 $3,362,598.01 $887,475.05 671 Century Center Capital $1,274,877.44 $675,315.38 $192,495.46 $1,757,697.36 SubTotal $2,176,075.91 $4,024,189.97 $3,555,093.47 $2,645,172.41 CONSOLIDATED 600 Consolidated Building fund $203,849.69 $954,228.26 $1,006,337.29 $151,740.66 BUILDING DEPARTMENT SubTotal $203,849.69 $954,228.26 $1,006,337.29 $151,740.66 GRAND TOTAL $253,762,916.25 $377,439,581.41 $383,852,720.36 $247,349,777.30 Cash Benchmarking Report 4/412014 13 Cash Benchmarking Report 4/4/2014 14 Mishawaka Civil City, St. Joseph County, Indiana Cash & Investments Combined Statement - 2013 Beg Cash End Cash & Inv Bal & Inv Bal Local Fund Local Fund Name Jan 1, 2013 Receipts Disbursement Dec 31, 2013 Number Governmental Activities 101 General $8,067,200.57 $27,990,895.42 $31,665,072.19 $4,393,023.80 201 Motor Vehicle Highway $3,101,865.78 $2,748,508.76 $3,997,905.64 $1,852,468.90 202 Local Road And Street $363,078.64 $432,694.64 $537,312.17 $258,461.11 204 Parks And Recreation $1,004,471.37 $2,931,068.20 $3,073,955.89 $861,583.68 210 Law Enforcement Continuing Ed $62,996.63 $60,579.67 $46,210.95 $77,365.35 211 Public Safety $2,531,464.63 $2,145,851.94 $2,276,649.52 $2,400,667.05 212 Self- Insurance $177,205.43 $11,778,394.97 $11,861,923.93 $93,676.47 214 Park Nonreverting Operating $348,284.02 $148,614.81 $141,498.15 $355,400.68 216 Park Donation $38,887.09 $87,264.07 $69,778.83 $56,372.33 218 Special Judgement Property $4.72 $0.00 $0.00 $4.72 220 Sidewalk And Curb Repair $5,470.02 $9,452.82 $0.00 $14,922.84 243 State Grant $70,146.54 $0.00 $0.00 $70,146.54 245 Rainy Day $1,063,964.52 $0.00 $0.00 $1,063,964.52 246 Rainy Day Public Safety $2,518.66 $0.00 $0.00 $2,518.66 270 Criminal Justice -State $63,931.46 $244,955.36 $274,103.32 $34,783.50 271 Police Arson /Drug Investigation $21,645.59 $955.98 $5,450.00 $17,151.57 272 Bicentennial Gift $1,325.61 $0.28 $0.00 $1,325.89 276 Mishawaka Gift $200,544.61 $52,679.00 $39,566.47 $213,657.14 277 NSP(3) $8,257.35 $702,461.44 $599,974.85 $110,743.94 282 Community Development $44,098.91 $716,889.89 $751,999.64 $8,989.16 283 Redevelopment Revolving $0.00 $136,430.09 $135,985.41 $444.68 287 Industrial Development $58,351.15 $1,617.21 $1,810.70 $58,157.66 288 Property Rehab Revolving $3,941.77 $926,484.37 $585,543.10 $344,883.04 292 Off - Street Parking $8,556.08 $7,902.50 $12,413.66 $4,044.92 293 TIF CBD General $0.00 $12,120.00 $12,120.00 $0.00 294 Tif Ss General $4,076,956.07 $971,173.37 $1,816,814.67 $3,231,314.77 295 Tif Nw General $19,105,081.89 $20,596,124.56 $22,785,943.35 $16,915,263.10 297 Nw Debt Reserve $1,233,094.65 $0.00 $1,233,094.65 $0.00 298 Ss Debt Reserve $376,552.28 $0.00 $0.00 $376,552.28 301 Corporation Bond (Sinking) $778,451.22 $1,657,669.58 $1,658,998.75 $777,122.05 311 Nw Bond And Interest $276,098.84 $1,393,857.59 $1,669,956.43 $0.00 312 Ss Bond And Interest $45,496.49 $288,631.76 $333,565.00 $563.25 401 Cumulative Capl Impry Cigarette Tax $1,118,540.71 $129,532.47 $0.00 $1,248,073.18 403 Local Major Moves $3,565,615.89 $515.86 $1,404,298.65 $2,161,833.10 405 Fire Station Construction $134,947.71 $80.32 $129,335.00 $5,693.03 417 Cumulative Capital Development $443,482.76 $317,688.35 $577,586.21 $183,584.90 429 Cumulative Fire $32,004.31 $33,441.36 $28,170.62 $37,275.05 430 Cedit Capital Projects $5,885,772.62 $2,932,638.96 $3,017,381.91 $5,801,029.67 432 Cumulative Sewer $1,753,151.36 $478,843.32 $645,067.86 $1,586,926.82 702 Fire Pension $1,018,421.53 $2,340,711.25 $2,471,312.84 $887,819.94 703 Police Pension $795,393.81 $1,413,162.88 $1,425,676.89 $782,879.80 704 Utilities Pension $14,817,278.23 $2,926,440.71 $865,856.30 $16,877,862.64 998 Mishawaka Building Corporation $0.00 $342,890.81 $342,890.81 $0.00 999 Mishawaka Bond Bank $1,283,463.50 $685,506.60 $0.00 $1,968,970.10 SubTotal $73,988,015.02 $87,644,731.17 $96,495,224.36 $65,137,521.83 ELECTRIC 610 Electric Utility- Operating $3,523,108.80 $50,071,681.69 $53,320,109.24 $274,681.25 612 Electric Utility- Deprec /Improve $41,302.80 $1,200,000.00 $1,222,953.04 $18,349.76 613 Electric Utility- Customer Deposit $2,394,432.90 $707,908.62 $611,098.50 $2,491,243.02 614 Electric Utility-Other #1 $754,000.00 $750,000.00 $750,000.00 $754,000.00 SubTotal $6,712,844.50 $52,729,590.31 $55,904,160.78 $3,538,274.03 TRASH 620 Trash Collection $544,554.19 $2,224,337.19 $2,119,666.37 $649,225.01 SubTotal $544,554.19 $2,224,337.19 $2,119,666.37 $649,225.01 WASTEWATER 605 Wastewater Utility- Customer Deposit $4,181.33 $100.00 $320.00 $3,961.33 606 Wastewater Utility- Operating $1,685,179.26 $14,314,456.22 $13,761,503.50 $2,238,131.98 607 Wastewater Util -Bond And Interest $3,809,290.23 $9,170,020.05 $9,488,728.03 $3,490,582.25 608 Wastewater Utility- Improvement $10,969,386.29 $2,341,383.58 $3,072,082.91 $10,238,686.96 609 Wastewater Utility-Other #2 $230,648.56 $231,865.04 $276,702.75 $185,810.85 616 Wastewater Utility- Construction $14,374,041.30 $353,678.97 $7,005,560.21 $7,722,160.06 617 Wastewater Utility-Other #1 $3,363,528.51 $604,975.56 $0.00 $3,968,504.07 SubTotal $34,436,255.48 $27,016,479.42 $33,604,897.40 $27,847,837.50 WATER 601 Water Utility-Operating $2,193,490.46 $9,579,935.08 $8,771,365.24 $3,002,060.30 602 Water Utility -Bond And Interest $1,717.01 $2,238,157.78 $2,239,495.24 $379.55 603 Water Utility- Improvement $1,468,710.83 $0.00 $435,395.25 $1,033,315.58 604 Water Utility- Customer Deposit $468,282.27 $236,168.44 $79,034.00 $625,416.71 618 Water Utility-Other #1 $1,466,651.41 $99,957.16 $210,329.00 $1,356,279.57 SubTotal $5,598,851.98 $12,154,218.46 $11,735,618.73 $6,017,451.71 GRAND TOTAL $121,280,521.17 $181,769,356.55 $199,859,567.64 $103,190,310.08 Cash Benchmarking Report 4/4/2014 14 Local Fund Number Evansville Civil City, Vanderburgh County, Indiana Cash & Investments Combined Statement - 2013 Beg Cash & Inv Bal Local Fund Name Jan 1, 2013 Receipts Disbursement End Cash & Inv Bal Dec 31, 2013 Governmental Activities 101 General $3,989,711.68 $76,452,660.01 $79,673,362.12 $769,009.57 201 Motor Vehicle Highway $917,656.94 $4,850,474.07 $5,363,783.39 $404,347.62 202 Local Road And Street $6,315,824.41 $1,264,273.04 $3,483,057.00 $4,097,040.45 204 Parks And Recreation $1,059,881.68 $9,761,813.26 $10,217,186.58 $604,508.36 211 Golf Course $235,369.89 $1,273,493.12 $1,539,279.15 - $30,416.14 217 Donations $4,759.02 $50,746.04 $53,791.19 $1,713.87 218 Economic Development Loan $1,014,859.63 $41,141.80 $151,900.29 $904,101.14 221 Area Plan Commission $414.80 $13.30 $0.00 $428.10 226 Parking $37,491.22 $0.00 $64,839.75 - $27,348.53 229 EMA Revolving Donation Fund $2,566.77 $0.00 $0.00 $2,566.77 230 Recovery Grant $138,582.30 $0.00 $134,783.12 $3,799.18 231 Community Dev Block Grant - $48,594.67 $2,299,297.95 $2,261,634.17 - $10,930.89 233 Law Enforcement $96,525.28 $159,667.10 $157,374.90 $98,817.48 241 UNSAFE BUILDING $0.00 $29,029.55 $0.00 $29,029.55 245 Rainy Day $3,079,490.62 $5,867.39 $155,000.00 $2,930,358.01 246 Certified Tech Park $62,845.01 $0.00 $28,145.00 $34,700.01 249 Redevelopment Bond of 1998 $26,446.21 $0.00 $26,446.21 $0.00 250 Rental Rehab $74,274.43 $0.00 $0.00 $74,274.43 251 Miscellaneous Grant $1,526,693.04 $736,337.97 $490,409.44 $1,772,621.57 253 Old Post Office $34,264.97 $12,499.98 $0.00 $46,764.95 269 Rental Housing Inspection $1,527.50 $20.00 $0.00 $1,547.50 270 Sports Non - Reverting $6,363.27 $244,350.96 $338,041.04 - $87,326.81 271 Hud Fair Housing $95,317.45 $60,070.00 $52,551.23 $102,836.22 272 Equal Emp Opportunity Commission $136,953.49 $79,025.00 $46,837.30 $169,141.19 273 Historic Preservation $5,289.24 $275.00 $38.62 $5,525.62 275 Zoo Animal Revolving $25,767.05 $745.80 $3,001.11 $23,511.74 276 Building Code Books $2,602.61 $0.00 $0.00 $2,602.61 277 Bicycle License Revolving $3,121.80 $356.00 $0.00 $3,477.80 278 Fire Donation $386.94 $0.00 $0.00 $386.94 279 Emergency Shelter Grant - $157,899.19 $411,055.12 $316,883.48 - $63,727.55 281 Housing Trust $43,703.87 $4,900.00 $12,118.01 $36,485.86 282 Ede Revolving Loan Fund $787,527.64 $920,327.32 $839,448.42 $868,406.54 283 Home Admin Investment Trust $100,975.94 $541,517.92 $567,106.82 $75,387.04 321 General Obligation # 2 $331,915.52 $0.00 $8,224.00 $323,691.52 322 Park District Bond Refunding 2010 $404,510.32 $1,235,753.52 $1,216,310.23 $423,953.61 323 Park Bond Refunding of 2003 $85,290.05 $0.00 $85,290.05 $0.00 324 Redevelopment TIF Project $86,746.03 $0.00 $0.00 $86,746.03 325 General Obligation Bond 2006 $0.00 $0.01 $0.01 $0.00 326 Greenway Project $905,720.38 $204,155.87 $236,685.05 $873,191.20 327 TIF Redevelopment Bond $167,315.08 $448,200.21 $421,753.50 $193,761.79 331 Park Bond Refunding 2012 $16,082.67 $85,290.05 $101,372.72 $0.00 401 Cumulative Capital Improvement $0.00 $315,238.11 $315,238.11 $0.00 405 Sidewalk Program $185,298.28 $67,600.54 $456.00 $252,442.82 406 Erc Capital Non Reverting $1,201,107.21 $40,367.37 $58,958.00 $1,182,516.58 407 Jacobsville TIF Projects $2,160,764.81 $1,055,256.41 $125,998.03 $3,090,023.19 408 Master Tif Projects $8,847,012.22 $7,531,085.81 $9,273,866.23 $7,104,231.80 446 Riverboat Capital Project $15,271,060.11 $11,801,310.77 $12,992,995.70 $14,079,375.18 449 Food And Beverage Tax Distribution $338,903.29 $776,565.97 $1,115,469.26 $0.00 454 Sidewalk Improvement Bond $78,418.81 $0.00 $0.00 $78,418.81 473 Redevelopment Arena Ban 2008 $31,151.34 $1,000.00 $0.00 $32,151.34 474 Local County Option Income Tax $10,151,476.95 $14,770,563.79 $17,067,061.15 $7,854,979.59 475 Arena Bond $3,968,784.00 $7,982,604.07 $3,353,244.50 $8,598,143.57 703 Purchasing Internal Service - $24,928.66 $569,077.11 $475,391.33 $68,757.12 704 Hospitalization $465,940.30 $21,930,979.39 $21,949,140.43 $447,779.26 705 Unemployment $453,529.40 $96,412.49 $13,239.90 $536,701.99 706 Workers Compensation $177,672.67 $1,222,587.20 $1,169,019.61 $231,240.26 707 Liability $714,058.34 $3,523,447.81 $2,745,782.71 $1,491,723.44 765 Accounts Receivable Clearing - $46,846.28 $366,363.65 $320,974.97 - $1,457.60 801 Fire Pension $4,568,862.34 $4,967,384.24 $5,239,473.52 $4,296,773.06 802 Police Pension $4,231,387.59 $6,839,070.79 $6,835,736.70 $4,234,721.68 806 Evansville Civil City Payroll $183.16 $32,412,199.78 $32,195,251.61 $217,131.33 820 Coleman Trust $11,944.91 $32.14 $0.00 $11,977.05 821 Mattie J Bayard Trust $6,058.16 $17.45 $0.00 $6,075.61 822 R T Legler Trust $2,281.92 $7.38 $0.00 $2,289.30 823 Oakhill Lease Escrow $5,376.96 $0.00 $0.00 $5,376.96 824 Oakhill Perpetual Care $729,092.85 $5,309.68 $0.00 $734,402.53 825 Locust Hill Perpetual Care $131,545.51 $2,096.14 $0.00 $133,641.65 826 MelzerTrust $50,002.46 $0.01 $0.01 $50,002.46 827 Evansville Community Trust $12,820.85 $13.81 $0.00 $12,834.66 829 Evansville Redevelopment $7,745.61 $418.29 $8,163.90 $0.00 836 CDBG - Metro SBAC Fund $35,857.86 $492,474.51 $528,332.37 $0.00 837 CDBG -City Bank Of Evansville $252,859.56 $583.22 $0.00 $253,442.78 838 CDBG -EDA Revolving Loan Fifth Third $678,757.44 $346,382.18 $345,942.69 $679,196.93 839 Berry Plastics $2,211.13 $518,161.76 $518,161.85 $2,211.04 854 American Gen Project 2010 $3,302.06 $481,112.09 $481,111.04 $3,303.11 857 2011 Berry Plastics Econ Dev $0.00 $0.01 $0.01 $0.00 Cash Benchmarking Report 4/4/2014 15 WASTEWATER WATERWORKS Evansville Civil City, Vanderburgh County, Indiana Cash & Investments Combined Statement - 2013 Cash Benchmarking Report 4/4/2014 16 Beg Cash End Cash & Inv Bal & Inv Bal Local Fund Local Fund Name Jan 1, 2013 Receipts Disbursement Dec 31, 2013 Number 858 Evansville Park 03 Escrow $13,278,422.87 $57,825.51 $13,336,248.38 $0.00 859 Evansville Park Refunding 2010 $0.44 $1,611,269.87 $1,075,794.20 $535,476.11 860 Evansville Park 12 Sinking $869.05 $777,331.67 $778,182.19 $18.53 SubTotal $89,601,266.41 $221,735,508.38 $240,365,888.30 $70,970,886.49 606 Sewer Operating $6,604,809.33 $38,620,903.42 $39,818,674.82 $5,407,037.93 607 Sewer Bond $6, 603, 352.43 $44,495,965.31 $44,061,468.44 $7,037,849.30 608 Sewer Improvement Fund $1,286,216.17 $2,148,199.90 $1,652,479.26 $1,781,936.81 609 Sewer Bond Construction $9,645,740.14 $34,984,245.34 $17,207,118.88 $27,422,866.60 641 Sewer Payroll $70,406.94 $2,669,384.61 $2,407,633.89 $332,157.66 643 Sewer Reserve Fund $10,280,181.61 $2,802,320.91 $651,819.30 $12,430,683.22 SubTotal $34,490,706.62 $125,721,019.49 $105,799,194.59 $54,412,531.52 601 Water Utility- Operating $3,609,665.45 $24,833,884.48 $24,770,049.97 $3,673,499.96 602 Water Utility -Bond & Int Sinking $3,639,149.04 $5,092,666.28 $4,943,583.20 $3,788,232.12 603 Water Improvement Fund $0.00 $1,084,000.16 $961,191.11 $122,809.05 604 Water Utility- Consumer Meter Deposit $1,008,277.44 $311,690.69 $224,789.98 $1,095,178.15 605 Water Utility- Construction $1,641,827.10 $41,633,544.19 $10,030,749.48 $33,244,621.81 640 Waterworks Payroll $105,774.27 $3,609,977.29 $3,323,571.86 $392,179.70 642 Waterworks Reserve $0.00 $4,128,426.83 $100,000.00 $4,028,426.83 SubTotal $10,004,693.30 $80,694,189.92 $44,353,935.60 $46,344,947.62 GRAND TOTAL $134,096,666.33 $428,150,717.79 $390,519,018.49 $171,728,365.63 Cash Benchmarking Report 4/4/2014 16 Cash Benchmarking Report 4/4/2014 17 Bloomington Civil City, Monroe County, Indiana Cash & Investments Combined Statement - 2013 Beg Cash End Cash & Inv Bal & Inv Bal Local Fund Local Fund Name Jan 1, 2013 Receipts Disbursement Dec 31, 2013 Number Governmental Activities 0 Petty Cash Accounts -City $14,015.00 $2,760.00 $1,070.00 $15,705.00 0 Petty Cash Accounts- Utilities $400.00 $0.00 $0.00 $400.00 101 General $4,591,554.22 $34,845,063.01 $33,781,429.35 $5,655,187.88 102 Rainy Day $4,604,420.30 $14,136.66 $0.00 $4,618,556.96 103 Restricted Donation $27,938.51 $44,096.33 $43,201.44 $28,833.40 200 Parks & Rec General - $226,361.77 $6,167,426.66 $5,884,706.98 $56,357.91 201 Parks Non Reverting Operating $1,807,016.98 $2,201,486.79 $2,051,139.74 $1,957,364.03 207 Parks Land Acquisition $992,417.79 $3,115.15 $994,000.00 $1,532.94 250 CDBG - $18,469.13 $835,937.50 $857,339.10 - $39,870.73 251 Bloomington Investlncent $379,592.08 $103,429.28 $0.00 $483,021.36 252 Affordable Housing $2,832.85 $0.00 $0.00 $2,832.85 253 Rental Rehab $2,610.00 $0.00 $0.00 $2,610.00 254 HOME - $35,308.10 $1,095,867.51 $1,059,563.44 $995.97 255 CDBG Escrow $10.76 $35,000.00 $35,000.00 $10.76 256 HAND Special Grants $60,775.26 $1,403,658.90 $1,558,695.83 - $94,261.67 312 Community Services $42,148.45 $56,659.12 $57,870.50 $40,937.07 350 Police Education $160,005.18 $38,381.33 $34,551.60 $163,834.91 355 Crime Control $49,587.80 $194,229.70 $57,641.67 $186,175.83 356 Dispatch Training $97,794.94 $4,950.00 $6,140.86 $96,604.08 357 Wireless Emergency $267,197.78 $0.00 $267,197.78 $0.00 360 B -Line Ph2 DNR -Grant $66.90 $0.00 $0.00 $66.90 401 Non Reverting Telecom $1,565,951.57 $956,296.64 $843,858.62 $1,678,389.59 402 Municipal Arts $90,838.52 $0.00 $2,907.57 $87,930.95 403 Arts Commission Operating $10,275.39 $8,937.00 $5,906.53 $13,305.86 404 Non Reverting Econ Develop $16,600.00 $0.00 $0.00 $16,600.00 405 Non Reverting Improve $280,962.58 $24,056.92 $45,014.26 $260,005.24 408 Unsafe Housing $86,146.35 $15,455.45 $18,011.63 $83,590.17 409 Electronic Map Generation $8,075.71 $889.00 $0.00 $8,964.71 410 Enhanced Access $4,430.96 $165.00 $0.00 $4,595.96 411 Rental Inspection Program $2,190.00 $167,457.31 $125,815.43 $43,831.88 430 CTP Downtown $2,481,614.55 $1,001,617.25 $38,500.00 $3,444,731.80 440 TIF Downtown $6,062,688.32 $3,465,565.28 $6,826,335.10 $2,701,918.50 442 TIF Tapp $1,929,860.34 $347,911.47 $1,327,417.44 $950,354.37 444 RDC $48,219.00 $36,164.25 $1,555.00 $82,828.25 445 TIF Adams $2,811,581.69 $852,098.61 $284,377.72 $3,379,302.58 446 TIF Prow $645,869.04 $124,769.30 $144,203.56 $626,434.78 447 TIF Whitehall $2,544,761.48 $3,503,450.62 $1,969,215.85 $4,078,996.25 448 TIF Thomson Walnut Winslow $2,793,932.77 $2,424,453.99 $3,289,947.23 $1,928,439.53 450 Local Road And Street - $197,524.32 $936,890.27 $649,340.40 $90,025.55 451 Motor Vehicle Highway $1,262,781.48 $3,534,064.93 $3,575,310.96 $1,221,535.45 452 Parking Enforcement $462,293.37 $3,528,339.30 $2,857,468.65 $1,133,164.02 454 Alternative Transportation $66,496.63 $350,117.02 $254,627.12 $161,986.53 508 BMFC Showers $47,430.66 $615,190.32 $633,750.00 $28,870.98 510 Police Station Lease $44,579.66 $137.39 $0.00 $44,717.05 511 98 Street Bond - $26,886.20 $936,903.33 $885,792.50 $24,224.63 512 Golf Course Bond $3,968.95 $271,387.35 $268,505.00 $6,851.30 513 BMFC 1998 Street Lease $43.77 $1,168,974.41 $1,167,000.00 $2,018.18 514 Redevelopment Dis Bond 2000 $311,242.70 $256,828.77 $253,960.00 $314,111.47 515 Fire Station #2 Lease $11,356.44 $192,991.85 $189,000.00 $15,348.29 516 2001 Parks Bond $66,165.65 $438,921.03 $488,732.50 $16,354.18 517 2011 Downtown Redevelop Bond $50.38 $1,055,807.50 $1,054,798.76 $1,059.12 600 Cumulative Improvement (Cig) $49,475.49 $215,847.19 $182,000.00 $83,322.68 601 Cumulative Cap Develop - $17,701.78 $2,723,406.02 $1,430,382.34 $1,275,321.90 604 Cumulative Cap Improve Rate $590,527.44 $265,189.30 $855,716.74 $0.00 605 Fire Capital $8,867.26 $41.07 $0.00 $8,908.33 610 Vehicle Replacement $351,564.81 $279,450.75 $435,075.71 $195,939.85 730 Solid Waste $195,203.24 $2,012,629.98 $2,012,629.98 $195,203.24 800 Risk Management $156,527.26 $529,135.57 $661,951.28 $23,711.55 801 Health Insurance $426,652.49 $9,407,890.08 $9,458,383.35 $376,159.22 802 Fleet Maintenance $724,408.99 $2,194,401.76 $1,960,527.35 $958,283.40 804 Insurance Voluntary Trust $155,622.06 $915,184.79 $935,735.95 $135,070.90 805 Umemployment Comp $39,302.80 $20,670.00 $12,892.87 $47,079.93 900 Police Pension $484,261.10 $2,031,747.39 $1,293,707.99 $1,222,300.50 901 Fire Pension $547,562.30 $2,738,402.22 $1,864,439.16 $1,421,525.36 902 Rosehill Trust $53,702.11 $168.28 $0.00 $53,870.39 904 Payroll $45,783.34 $6,846,905.84 $6,892,689.18 $0.00 920 Bloomington Technology Park $52,522.87 $166.25 $0.00 $52,689.12 921 Industrial Development $2,272,580.92 $2,008,877.71 $1,627,909.75 $2,653,548.88 922 Downtown CRED $5,330,602.44 $769,073.23 $61,333.20 $6,038,342.47 970 Debt Service Reserve For 440 TIF $1,062,729.46 $3,437.46 $0.00 $1,066,166.92 975 Surplus CTP Bond $0.00 $2,684,413.50 $0.00 $2,684,413.50 99908 PERF Pension Relief Fire $959,289.93 $563.25 $959,853.18 $0.00 99914 PERF Pension Relief Police $738,535.32 $433.63 $738,968.95 $0.00 SubTotal $50,484,263.09 $108,910,074.77 $105,275,097.10 $54,119,240.76 STORM WATER 011 Storm Water Utility- Operating $453,889.50 $1,613,654.30 $1,407,636.20 $659,907.60 021 Storm Water Utility- Construction $98,496.71 $43,575.43 $142,072.14 $0.00 Cash Benchmarking Report 4/4/2014 17 Bloomington Civil City, Monroe County, Indiana Cash & Investments Combined Statement - 2013 Cash Benchmarking Report 4/4/2014 18 Beg Cash End Cash & Inv Bal & Inv Bal Local Fund Local Fund Name Jan 1, 2013 Receipts Disbursement Dec 31, 2013 Number SubTotal $552,386.21 $1,657,229.73 $1,549,708.34 $659,907.60 WASTEWATER 010 Wastewater Utility- Operating $1,101,563.11 $21,864,485.20 $19,715,961.18 $3,250,087.13 020 Wastewater Util -Bond And Interest $56,366.93 $7,374,246.57 $7,388,157.59 $42,455.91 030 Wastewater Utility- Construction $3,173,751.30 $50,323.24 $227,628.55 $2,996,445.99 040 Wastewater Utility -Debt Reserve $6,456,060.27 $429,396.19 $160,929.45 $6,724,527.01 099 PAYROLL $0.00 $63,355.30 $63,355.30 $0.00 SubTotal $10,787,741.61 $29,781,806.50 $27,556,032.07 $13,013,516.04 WATER 009 Water O &M $677,034.80 $20,374,627.04 $17,227,375.23 $3,824,286.61 019 Water Hydrant Deposit $31,350.00 $22,100.00 $18,300.00 $35,150.00 029 Water Utility -Bond And Interest $4,542.55 $6,250,449.56 $6,250,506.62 $4,485.49 039 Water Utility- Construction $11,167,868.52 $1,250,336.92 $11,819,595.26 $598,610.18 040 Water Utility -Debt Reserve $5,641,713.34 $248,639.06 $246,737.29 $5,643,615.11 SubTotal $17,522,509.21 $28,146,152.58 $35,562,514.40 $10,106,147.39 GRAND TOTAL $79,346,900.12 $168,495,263.58 $169,943,351.91 $77,898,811.79 Cash Benchmarking Report 4/4/2014 18 Cash Benchmarking Report 4/4/2014 19 Hammond Civil City, Lake County, Indiana Cash & Investments Combined Statement - 2013 Beg Cash End Cash & Inv Bal & Inv Bal Local Fund Local Fund Name Jan 1, 2013 Receipts Disbursement Dec 31, 2013 Number Governmental Activities 002 FACADE $25,101.14 $100,000.00 $74,571.46 $50,529.68 004 CENTREX - $76,645.28 $17,659.09 $18,457.02 - $77,443.21 006 DIESEL FUEL TAX $12,969.04 $11,559.45 $19,731.85 $4,796.64 007 COLLEGE BOUND $32,986.09 $11,523.73 $0.00 $44,509.82 008 DEMOLITION $394,358.73 $1,063,103.48 $481,536.71 $975,925.50 010 CUT AND CLEAN $8,823.98 $175,273.50 $152,759.00 $31,338.48 011 GRAFFITI REMOVA $164.41 $0.00 $134.42 $29.99 012 HOMEBOUND $585.01 $200,522.00 $151,119.00 $49,988.01 013 REDV PARTY FUND $34,465.12 $2,300,100.00 $2,051,757.73 $282,807.39 014 HPRP Homeless Prevention - $16,082.73 $16,082.73 $0.00 $0.00 015 NSP /NEIGH STAB - $144,219.04 $1,972,587.74 $1,682,405.40 $145,963.30 016 ENGINEERING $1,584,015.18 $1,300,000.00 $105,702.23 $2,778,312.95 017 ASAP GRANT $65,274.92 $0.00 $0.00 $65,274.92 101 GENERAL - $23,409,240.04 $48,263,953.13 $58,683,714.43 - $33,829,001.34 200 PUBLIC DEFENDER $1,500.00 $75.00 $0.00 $1,575.00 201 M. V. H. - $2,519,738.65 $2,914,039.55 $3,533,578.26 - $3,139,277.36 202 LRS - $373,282.49 $771,193.52 $1,369,417.95 - $971,506.92 203 HAZ -MAT $12,184.01 $66,194.06 $20,400.00 $77,978.07 204 PARK - $3,467,050.17 $5,329,566.23 $3,788,506.98 - $1,925,990.92 207 FED FORFEIT PRO $38,695.92 $25,026.52 $42,084.10 $21,638.34 209 EVIDENCE MONEY $20,628.82 $43,688.29 $43,688.29 $20,628.82 212 SELF INSURANCE $498,739.76 $21,866,895.57 $19,813,704.97 $2,551,930.36 213 HIDTA $14,193.73 $99,475.76 $69,273.56 $44,395.93 214 POLICE DONATION $47,696.97 $6,690.00 $14,330.83 $40,056.14 215 PARK ACTIVITIES $123,296.39 $182,040.91 $264,486.32 $40,850.98 216 BACKGROUND CKS $550.14 $1,035.00 $1,230.00 $355.14 218 HIDTA Equipment Grant $386.39 $0.00 $0.00 $386.39 219 Recycling $0.00 $215,133.00 $0.00 $215,133.00 220 STATE FORFIETED $4,057.31 $38,070.93 $11,997.00 $30,131.24 223 CLKS PERPETUAL $124,364.92 $22,180.52 $18,505.06 $128,040.38 224 FED PRISONERS $165,452.72 $416,046.80 $177,581.13 $403,918.39 226 Seatbelt Enforcement $0.00 $0.00 $1,451.88 - $1,451.88 227 IMPAIRED DRIVEI - $13,675.00 $59,492.41 $54,236.36 - $8,418.95 228 REDEVELOPMENT $775,388.71 $340,461.71 $980,975.02 $134,875.40 230 Columbia Plaza TIF $374,780.55 $673,133.07 $0.00 $1,047,913.62 231 Lear TIF $2,032,135.85 $369,622.72 $1,400.00 $2,400,358.57 232 PARKITOURISM $8,027.78 $16,020.00 $19,253.38 $4,794.40 233 ECO DEV/TOURISM $21,646.52 $10,800.00 $3,537.19 $28,909.33 234 Downtown TIF $1,962,711.43 $772,344.17 $65,200.82 $2,669,854.78 236 CDBG ESCROW $175,109.96 $215,598.50 $165,368.56 $225,339.90 237 HUMAN RELATIONS $6,411.27 $100.00 $110.00 $6,401.27 239 PUBLIC SAFETY $23,817.15 $835,206.64 $789,903.46 $69,120.33 240 GAMING REVENUE $25,615,372.06 $37,141,361.77 $36,316,949.71 $26,439,784.12 246 WATER HYDRANT R $380,658.30 $0.00 $183,367.44 $197,290.86 248 PENALTIES $3,295,374.02 $32,392.82 $684,318.78 $2,643,448.06 250 Human Relations Grant - $464.68 $56,250.00 $49,376.43 $6,408.89 251 HUMAN REL (FED) $61,284.27 $15,074.00 $15,205.81 $61,152.46 252 Transit - $375,309.00 $0.00 $0.00 - $375,309.00 253 LOCAL SEIZURE - $8,187.70 $0.00 $0.00 - $8,187.70 262 C.D.B.G. - $219,185.79 $2,711,691.50 $2,842,575.93 - $350,070.22 264 AMBULANCE FEES - $125,000.00 $0.00 $124,734.54 - $249,734.54 266 CDBG DONATION $52,132.00 $7,425.00 $46,588.10 $12,968.90 268 A C DONATION $3,705.78 $1,919.62 $2,770.27 $2,855.13 269 VEHICLE RELEASE $15,352.27 $52,315.48 $50,438.51 $17,229.24 270 UNEMPLOYMENT - $461,131.79 $32,216.00 $45,571.05 - $474,486.84 272 ADULT PROBATION $125,437.35 $158,969.85 $184,712.77 $99,694.43 273 TOBACCO ED /JUDG $16,683.60 $3,250.00 $2,800.00 $17,133.60 276 HENRY UNIT - $856,471.85 $156,000.00 $597,980.86 - $1,298,452.71 282 PARKIGAMING $94,137.44 $765,736.77 $845,866.20 $14,008.01 285 AFFORD HOUSING - $172,727.41 $1,047,410.08 $1,001,746.28 - $127,063.61 286 EMERGENCY /CDBG - $15,395.50 $141,532.75 $87,769.39 $38,367.86 287 SECTION 108 $81,486.38 $0.00 $0.00 $81,486.38 288 TECHNICAL GRANT $598,775.25 $774,997.00 $320,000.00 $1,053,772.25 290 Home Depot TIF $2,041,841.88 $481,652.04 $210,400.00 $2,313,093.92 291 WoodmarTIF $4,165,744.24 $984,696.72 $256,301.23 $4,894,139.73 292 Woodmar Gateways TIF $954,056.70 $780,518.68 $954,056.70 $780,518.68 293 INSPT /RENTAL - $169,727.07 $1,008,148.02 $1,118,174.00 - $279,753.05 295 Gateways TIF $884,603.89 $1,390,085.56 $45,423.14 $2,229,266.31 305 H D BOND 756775 $1.00 $82,651.59 $0.00 $82,652.59 306 CIVIL CITY BOND $708,303.38 $250,951.25 $975,105.00 - $15,850.37 307 H D PROJ 756776 $5,401.35 $0.00 $5,401.35 $0.00 309 R P GAM 756773 $2,255,434.72 $2,068,297.78 $2,309,976.59 $2,013,755.91 310 Judge Gen 756777 $0.00 $0.00 $350,501.25 - $350,501.25 319 Potash $0.00 $0.00 $0.16 -$0.16 321 Potash Bond Interest $321,165.00 $17.32 $321,182.32 $0.00 322 Potash Bond COI $2,000.00 $0.45 $2,000.45 $0.00 Cash Benchmarking Report 4/4/2014 19 Hammond Civil City, Lake County, Indiana Cash & Investments Combined Statement - 2013 Cash Benchmarking Report 4/4/2014 20 Beg Cash End Cash & Inv Bal & Inv Bal Local Fund Local Fund Name Jan 1, 2013 Receipts Disbursement Dec 31, 2013 Number 323 Potash Bond Construction $7,499,749.00 $106,320.98 $94,660.45 $7,511,409.53 324 Potash bond DSR $1,121,001.00 $112.10 $0.00 $1,121,113.10 325 Jobs Bill Bond COI $15,000.00 $0.41 $15,000.73 -$0.32 326 Jobs Bill Bond DSR $1,735,418.00 $15,317.43 $15,311.41 $1,735,424.02 327 Jobs Rebt $0.00 $36,165.26 $0.83 $36,164.43 401 C.C.I.F. $223,233.72 $216,988.10 $381,429.30 $58,792.52 404 MAJOR MOVES $17,351.22 $0.00 $0.00 $17,351.22 406 Red P & 1 $0.00 $0.00 $152,434.38 - $152,434.38 408 CABELA'S /105415 $2,339,828.58 $954,057.02 $1,933,050.00 $1,360,835.60 414 Potash Bond General $175,129.00 $300,035.49 $321,165.00 $153,999.49 416 River Park Refunding General $148,192.00 $1,152,466.16 $0.00 $1,300,658.16 417 Jobs Bill Bond General Fund $13.00 $3,272,952.90 $3,259,139.86 $13,826.04 445 C.C.D.F. $737,850.88 $177,346.10 $553,393.87 $361,803.11 461 GOLF COURSE - $244,269.55 $0.00 $0.00 - $244,269.55 503 COST DUE COUNTY $0.00 $186,018.00 $186,018.00 $0.00 504 CONTINUING ED $38,029.05 $93,001.26 $79,229.16 $51,801.15 505 DEFERRAL PROGRA $304,793.50 $127,759.00 $222,042.00 $210,510.50 506 PRETRIAL DIV PG $3,710.00 $58,060.00 $59,140.00 $2,630.00 702 FIRE PENSION $3,913,685.08 $5,105,971.44 $4,905,835.58 $4,113,820.94 703 POLICE PENSION $2,355,102.68 $5,846,081.25 $5,132,826.05 $3,068,357.88 708 PAY WITHHOLDING $74,655.02 $12,127,322.05 $12,075,560.05 $126,417.02 CLRK City Clerk Trust Funds $1,799,837.81 $4,516,279.77 $3,323,397.54 $2,992,720.04 SubTotal $40,104,246.60 $175,180,312.50 $177,333,038.84 $37,951,520.26 SANITARY DISTRICT A Operations - $1,735,189.00 $19,869,919.00 $19,432,254.00 - $1,297,524.00 B Pre Treatment $357,142.00 $342,206.00 $292,856.00 $406,492.00 C Unemployment $47,677.00 $23,595.00 $19,892.00 $51,380.00 D Debt Service Non Exempt $139,329.00 $975,604.00 $974,109.00 $140,824.00 D2 Debt Service Exempt $2,140,636.00 $2,140,637.00 $5,411,336.00 - $1,130,063.00 E Sewer - $167,741.00 $1,911,004.00 $1,846,657.00 - $103,394.00 G GIS $2,039.00 $0.00 $0.00 $2,039.00 H Storm Water $1,490,490.00 $307,621.00 $42,900.00 $1,755,211.00 1 Sanitation - $296,506.00 $4,870,018.00 $5,022,125.00 - $448,613.00 J Recycling - $667,185.00 $925,283.00 $1,253,418.00 - $995,320.00 L Great Lakes Legacy $42,746.00 $20,026,923.00 $20,023,568.00 $46,101.00 N 2010 Bond $7,382,426.00 $4,357.00 $2,408,249.00 $4,978,534.00 O SRF Loan $2,586,049.00 $8,457.00 $1,671,679.00 $922,827.00 P Replacement $1,485,854.00 $400,000.00 $250,823.00 $1,635,031.00 Q Capital Projects BAN $3,675,573.00 $3,018.00 $2,008,105.00 $1,670,486.00 R SRF Loan 7 $0.00 $30,503,325.00 $196,602.00 $30,306,723.00 SubTotal $16,483,340.00 $82,311,967.00 $60,854,573.00 $37,940,734.00 WATER UTILITY W Water Utility $1,595, 328.00 $44,328,632.28 $43,017,540.04 $2,906,420.24 SubTotal $1,595,328.00 $44,328,632.28 $43,017,540.04 $2,906,420.24 PORT AUTHORITY 415 2008 Revenue Bond DSR $1,250,000.00 $0.00 $0.00 $1,250,000.00 416 2008 Revenue Bond Debt Service $1,017,541.53 $2,644,834.33 $2,440,000.00 $1,222,375.86 626 Marina Operations $643,123.39 $3,319,639.10 $3,364,747.93 $598,014.56 627 Marina Construction $3,858,988.05 $2,156,124.00 $3,029,080.62 $2,986,031.43 628 Gaming Fund $1,243,948.33 $7,048,252.22 $7,581,679.35 $710,521.20 629 Lakefront Management $25,242.63 $77,170.32 $66,808.90 $35,604.05 630 Lost Marsh Golf Course $630,947.14 $1,476,156.80 $1,517,746.25 $589,357.69 631 Wolf Lake Operations $253,777.77 $850,958.45 $789,291.88 $315,444.34 633 RDA Project $46,375.17 $3,766,045.70 $2,856,670.81 $955,750.06 708 Payroll and Withholding - $98.47 $405,042.57 $405,042.57 - $98.47 SubTotal $8,969,845.54 $21,744,223.49 $22,051,068.31 $8,663,000.72 GRAND TOTAL $67,152,760.14 $323,565,135.27 $303,256,220.19 $87,461,675.22 Cash Benchmarking Report 4/4/2014 20 Cash Benchmarking Report 4/4/2014 21 Carmel Civil City, Hamilton County, Indiana Cash & Investments Combined Statement - 2013 Beg Cash End Cash & Inv Bal & Inv Bal Local Fund Local Fund Name Jan 1, 2013 Receipts Disbursement Dec 31, 2013 Number Governmental Activities 0 Crc Regions Account $3,954,179.93 $1,416.11 $3,955,596.04 $0.00 0 Carmel City Court $628,505.00 $1,922,390.71 $2,384,735.48 $166,160.23 0 Payroll Fund $ 277, 146.38 $44,637,420.98 $44,709,101.31 $205,466.05 1 General $2,454,931.88 $73,229,636.52 $71,979,960.75 $3,704,607.65 102 Ambulance Fund $700,563.07 $1,122,658.50 $1,034,206.29 $789,015.28 103 Parks Capital $689,265.08 $731.49 $230,147.53 $459,849.04 106 Park Impact Fee Fund $1,905,206.45 $816,715.64 $843,897.32 $1,878,024.77 107 Hazardous Material Response Fund $7,536.05 $761.75 $0.00 $8,297.80 108 Parks Program Fund $1,173,985.54 $3,607,772.87 $3,028,294.40 $1,753,464.01 109 Parks Monon Fund $1, 509, 330.94 $4,852,955.92 $4,537,948.46 $1,824,338.40 201 Motor Vehicle Highway $2,705,139.74 $10,149,079.75 $9,920,583.42 $2,933,636.07 202 Local Road And Street $2,057,349.59 $1,132,695.20 $2,527,735.00 $662,309.79 203 Cumulative Capital Improvement $727,093.29 $213,279.35 $553,971.15 $386,401.49 206 Cumulative Capital Sewer $912,348.84 $720.13 $385,310.61 $527,758.36 209 Deferral Fund $559,717.63 $76,690.38 $60,222.29 $576,185.72 210 User Fee Fund $125,905.23 $117,621.31 $110,841.86 $132,684.68 211 Cumulative Captial Development $3,015,643.56 $1,725,408.72 $3,765,896.18 $975,156.10 212 Illinois St Construction Fund $700,177.79 $3,183,695.81 $61,400.68 $3,822,472.92 220 Barrett Law Fund $5.67 $0.00 $0.00 $5.67 221 Barrett Law Surplus $165,445.05 $250.30 $0.00 $165,695.35 301 Health Insurance Fund $3,377,674.77 $11,985,566.67 $12,091,018.42 $3,272,223.02 302 Workers Comp Fund $36,169.57 $270,969.85 $307,139.42 $0.00 402 Civic Square Construction Fund $595.41 $0.22 $0.00 $595.63 403 Lease Rental Fund $3,833.98 $5.79 $0.00 $3,839.77 450 Old Town /126Th Street $457.61 $0.68 $0.00 $458.29 501 Dnr/Tree City $50,223.19 $306.50 $26.46 $50,503.23 502 Clerk's Record Perpetuation $95,213.22 $19,510.06 $9,570.46 $105,152.82 503 Court Interperter Fund $3,429.14 $0.76 $3,400.00 $29.90 504 Support For The Arts $119,855.62 $740,036.62 $842,756.00 $17,136.24 505 Public Defenders Fund $1,028.60 $452.10 $0.00 $1,480.70 506 JUDICIAL SALARY FEES $90,394.78 $44,065.09 $14,278.84 $120,181.03 801 Police Pension Fund $2,384,605.10 $514,967.62 $2,089,493.42 $810,079.30 802 Fire Pension Fund $2,728,575.86 $574,793.65 $2,734,727.83 $568,641.68 851 Fire Gift Fund $5,726.48 $19,097.52 $16,680.84 $8,143.16 852 Police Gift $38,799.66 $12,171.23 $20,491.30 $30,479.59 853 Parks Gift Fund $49,714.66 $3,259.77 $4,930.95 $48,043.48 854 Community Relations Gift Fund $19,346.92 $84,061.80 $41,127.76 $62,280.96 900 Grant Fund $574,496.24 $50,521.67 $153,014.55 $472,003.36 902 Redevelopment Commission $14,353.15 $26,948,107.17 $19,002,871.99 $7,959,588.33 903 Economic Fund $38,351.26 $10,059.82 $0.00 $48,411.08 904 Housing Authority $58,589.79 $88.65 $0.00 $58,678.44 911 Drug Task Force $588,416.31 $143,520.14 $169,643.49 $562,292.96 912 Rainy Day $8,963,321.12 $13,561.12 $0.00 $8,976,882.24 919 Throughfare Fund $483,775.81 $417,005.67 $639,463.28 $261,318.20 920 Keystone Ave Fund $2,903,739.27 $3,294.43 $2,665,092.46 $241,941.24 SubTotal $46,900,164.23 $188,647,326.04 $190,895,576.24 $44,651,914.03 WASTEWATER 0 Wastewater Bond & Interest At Bony $2,450,635.52 $1,763,976.85 $1,414,238.18 $2,800,374.19 2012 Sewage Works Revenue Bonds $8,103,357.35 $51,081.81 $4,339,128.60 $3,815,310.56 651 Sewer Operating $65,158.54 $9,242,083.42 $9,286,853.98 $20,387.98 652 Sewer Depreciating $1.91 $229,454.48 $229,456.36 $0.03 659 Sewer Connection Fund $5,734.98 $410,849.10 $234,393.00 $182,191.08 660 Sewer Availability Fund $5,364.85 $118,682.03 $3,156.36 $120,890.52 SubTotal $10,630,253.15 $11,616,127.69 $15,507,226.48 $6,939,154.36 WATER 601 Water Operating $222,297.95 $25,138,840.00 $25,341,880.11 $19,257.84 602 Hydrant Meter Deposit Fund $36,965.00 $2,725.00 $500.00 $39,190.00 604 Water Depreciation $1.92 $225,994.26 $225,996.02 $0.16 605 Water Bond & Interest $1,146,139.50 $80,574.00 $0.00 $1,226,713.50 606 Water Sinking Fund $ 922, 465.56 $4,265,709.20 $4,860,418.96 $327,755.80 609 Water Connection $16,608.98 $2,111,162.37 $2,127,681.38 $89.97 610 Water Availability $0.00 $3,027,193.77 $3,027,181.04 $12.73 SubTotal $2,344,478.91 $34,652,198.60 $35,583,657.51 $1,613,020.00 GRAND TOTAL $59,874,896.29 $235,315,652.33 $241,986,460.23 $53,204,088.39 Cash Benchmarking Report 4/4/2014 21 Cash Benchmarking Report 4/4/2014 22 Gary Civil City, Lake County, Indiana Cash & Investments Combined Statement - 2013 Beg Cash End Cash & Inv Bal & Inv Bal Local Fund Local Fund Name Jan 1, 2013 Receipts Disbursement Dec 31, 2013 Number Governmental Activities 0 City Clerk - Civil Division $5,112.68 $95,329.57 $89,178.11 $11,264.14 0 City Clerk- Criminal Division $1,086,032.75 $1,485,026.46 $1,366,953.16 $1,204,106.05 0000 Metro Center $1,934.24 $211,302.21 $211,715.80 $1,520.65 101 General - $6,808,473.21 $68,370,873.95 $65,598,443.75 - $4,036,043.01 102 Payroll $4,707.06 $0.00 $0.00 $4,707.06 202 Protective Services Grant - $1,033,928.79 $0.00 $0.00 - $1,033,928.79 204 Equal Opportunity Commission Hr $2,035.09 $63,950.00 $46,557.59 $19,427.50 205 Tourism Project $49,991.10 $43,011.11 $4,650.00 $88,352.21 209 Youth Services Bureau $228,239.50 $127,119.24 $131,473.93 $223,884.81 210 County Health $1,542.52 $6,334.75 $6,297.50 $1,579.77 212 Home Program $7,107.32 $1,563,351.89 $1,564,559.32 $5,899.89 213 Emergency Shelter Grant $107.21 $163,919.74 $157,800.77 $6,226.18 214 Brownfield $260,790.19 $0.00 $170,078.97 $90,711.22 215 Healthy Families $12,776.80 $3,743.00 $10,358.15 $6,161.65 216 Marquette Park $3,982.59 $230,882.50 $222,221.21 $12,643.88 219 Gleason Golf Course $9,699.54 $167,891.95 $177,590.54 $0.95 220 Protective Services Grant Ii $55,087.20 $116,988.48 $123,061.76 $49,013.92 222 Emergency Shelter - $464,782.72 $522,023.05 $453,925.10 - $396,684.77 223 Comprehensive Community Program $58,324.83 $42,622.50 $75,092.18 $25,855.15 224 Ambulance /Ems Nonreverting - $822,137.65 $886,242.62 $9,292.17 $54,812.80 226 Empowerment Zone $39.29 $342,780.04 $332,250.10 $10,569.23 227 Law Enforcement Continuing Ed $160,960.24 $89,910.14 $60,602.52 $190,267.86 229 Unsafe Building $163,335.89 $54,341.00 $117,069.34 $100,607.55 231 Local Road And Street $108,612.34 $914,603.11 $1,022,810.79 $404.66 232 Motor Vehicle Highway $212,590.87 $2,414,164.18 $2,413,234.77 $213,520.28 233 Landfill Closure $101,042.54 $36,313.00 $45,760.83 $91,594.71 235 Solid Waste Recycling Project $249,186.62 $451,345.27 $523,298.74 $177,233.15 237 Environmental Management $13,585.68 $0.00 $0.00 $13,585.68 240 Health And Human Services - $451,910.96 $678,167.36 $629,898.70 - $403,642.30 241 Alcohol And Drug Treatment $56,673.93 $0.00 $50,238.90 $6,435.03 242 Supplemental Adult Probation Svcs $122,151.81 $96,867.50 $135,063.53 $83,955.78 243 Gary Health Department Rental $8,215.22 $3,300.00 $4,159.83 $7,355.39 250 Parks And Recreation $2,636.64 $939,130.23 $941,198.37 $568.50 251 Park Nonreverting $4,361.83 $125,765.81 $125,917.77 $4,209.87 254 Vehicle Auction $46,948.87 $21,607.19 $68,553.26 $2.80 258 Bioterrorism - $8,677.03 $47,803.23 $57,227.75 - $18,101.55 259 Cops Technology $82,949.31 $30.00 $56,104.70 $26,874.61 261 Community Development Block Grant $159,702.38 $3,525,931.21 $3,462,415.77 $223,217.82 265 Redevelopment Operating $52,918.33 $119,058.87 $160,191.28 $11,785.92 266 Summer Jobs Training Program $8,775.52 $0.00 $0.00 $8,775.52 267 Fair Housing Project $51,547.60 $33,334.00 $51,128.93 $33,752.67 268 Genesis Civic Center $6.97 $317.16 $0.00 $324.13 270 Media $389,401.95 $483,718.09 $532,945.27 $340,174.77 271 J- Pit/Landfill Management $82,477.50 $103,392.50 $0.00 $185,870.00 272 Empowerment Zone Revolving $6,497.99 $327,451.65 $329,818.10 $4,131.54 273 Microloan $5,322.79 $600.00 $5,000.00 $922.79 274 Clerk Perpetuation $14,796.02 $19,493.36 $21,725.58 $12,563.80 275 Fema Grant - Fire Department $1,538.09 $251,774.00 $250,807.28 $2,504.81 277 Riverboat $1,239,218.21 $27,318,021.44 $23,652,497.28 $4,904,742.37 279 Genesis Center Operating $19,666.70 $561,210.34 $560,426.95 $20,450.09 281 Leased Properties - Gary Bldg Corp. - $500,922.00 $79,587.59 $0.00 - $421,334.41 282 State Air Grant $10,738.71 $0.00 $10,087.30 $651.41 283 Hazardous Material $5,968.96 $41,915.00 $0.00 $47,883.96 288 Economic Development Bond Comm $14,837.52 $22.42 $60.00 $14,799.94 290 Supplemental Public Defender $45,018.00 $13,506.00 $0.00 $58,524.00 291 Empowerment Zone Sba Microloan $660.93 $37,194.00 $37,647.88 $207.05 292 Empowerment Zone Sba Loss Reserve $2,375.74 $0.26 $2,000.00 $376.00 293 ledc - Empowerment Zone $257.26 $628.54 $0.00 $885.80 296 New Birth Grant $22.45 $0.00 $0.00 $22.45 302 Redevelopment Bond $999,863.84 $496.44 $0.00 $1,000,360.28 310 Regional Development Authority $0.00 $3,500,000.00 $3,500,000.00 $0.00 314 2007 Go Judgment Funding Bonds $520,841.41 $951,928.08 $888,890.63 $583,878.86 317 Note Reserve ( 8.5 Million) $2,000,496.95 $452.07 $0.00 $2,000,949.02 318 Note Repayment $0.00 $2,410,261.78 $2,410,261.78 $0.00 319 TIF Bond Reserve $450,000.00 $410,000.00 $0.00 $860,000.00 320 2012 Note Payment $0.00 $888,697.00 $888,697.00 $0.00 321 Equipment Fund $0.00 $711,181.36 $464,601.89 $246,579.47 322 Equipment Lease Reserve $0.00 $437,928.78 $102,928.78 $335,000.00 374 Bond Revenue $11,171,951.77 $1,069.28 $601,203.98 $10,571,817.07 401 Cumulative Capital Improvement $29,872.05 $215,549.21 $169,667.46 $75,753.80 402 Cumulative Capital Development $330,366.65 $160,657.34 $39,542.54 $451,481.45 405 Baseball Maintenance $0.56 $150,000.00 $150,000.00 $0.56 406 Narcotics Vice $9,179.63 $0.00 $0.00 $9,179.63 408 Fire Capital Equipment $16,198.45 $815.69 $0.00 $17,014.14 410 2007 Multi Purpose Revenue Bonds $23,267.33 $178.23 $2,135.00 $21,310.56 411 Marquette Renovation $27,355.17 $6,549,142.90 $6,575,514.57 $983.50 Cash Benchmarking Report 4/4/2014 22 Gary Civil City, Lake County, Indiana Cash & Investments Combined Statement - 2013 Cash Benchmarking Report 4/4/2014 23 Beg Cash End Cash & Inv Bal & Inv Bal Local Fund Local Fund Name Jan 1, 2013 Receipts Disbursement Dec 31, 2013 Number 413 Cmaq Vehicles $5,360.47 $444,698.30 $234,000.00 $216,058.77 414 Major Moves Capital Projects $0.30 $0.00 $0.00 $0.30 416 Remote Encoding Center $181,466.57 $0.00 $160,758.38 $20,708.19 419 ARRA Public Works $1.43 $2,033.53 $0.00 $2,034.96 421 Health Radon Gas $4,010.75 $0.00 $0.00 $4,010.75 423 2012 Genesis Center Renovation $1,473,516.44 $533,639.67 $1,677,959.88 $329,196.23 424 Safe Route Plan $0.00 $13,395.00 $0.00 $13,395.00 430 Grant/Buchanan Street Project $106,070.17 $0.00 $63,056.61 $43,013.56 450 Park Construction $6,988.20 $3,000.00 $0.00 $9,988.20 472 Unsafe Building $0.00 $1,000,000.00 $0.00 $1,000,000.00 477 Casino Capital $0.00 $6,345.16 $0.00 $6,345.16 702 Fire Pension $2,718,573.60 $6,181,850.74 $6,675,276.17 $2,225,148.17 703 Mayor Donations $1,547.00 $18,272.32 $19,384.93 $434.39 704 Lakefront Development $1,082,440.68 $0.00 $0.00 $1,082,440.68 705 Social Services $1,596.10 $2,713.07 $2,210.17 $2,099.00 706 Landfill Trust $1,220,962.59 $0.00 $0.00 $1,220,962.59 707 Special Events $14,754.08 $17,995.00 $2,239.42 $30,509.66 708 City Council Donations $6,983.22 $0.00 $6,538.11 $445.11 709 Joint Public Safety Training $19,006.05 $2,500.00 $17,964.77 $3,541.28 710 Confiscated Property $234,979.92 $19,327.36 $47,066.72 $207,240.56 711 Special Project Donations $307.08 $0.00 $232.00 $75.08 712 Human Relations $2,000.00 $0.00 $0.00 $2,000.00 713 Clean Up /Beautification $616.99 $0.00 $322.95 $294.04 714 Lady Liberty Restoration $421.55 $20.00 $0.00 $441.55 718 Lets Move Project $3,665.70 $3,613.60 $2,440.87 $4,838.43 719 Fire Department Equipment $1,836.02 $0.00 $1,574.66 $261.36 720 Economic Development Trust $495,335.89 $7,914.01 $191,638.75 $311,611.15 721 Community Development Loan Program $16,058.09 $0.00 $240.00 $15,818.09 725 Police Donations $1,354.51 $14,085.00 $4,591.50 $10,848.01 730 Police Pension $1,298,617.81 $6,875,489.26 $7,152,772.76 $1,021,334.31 781 Miscellaneous Refunds $16,214.24 $33.42 $0.00 $16,247.66 786 Redevelopment Depository Trust $169,041.58 $6,077.43 $84,291.75 $90,827.26 788 Withholdings $901,201.22 $23,705,494.13 $24,452,976.05 $153,719.30 791 Self- Insurance $271,586.25 $10,812,453.36 $11,798,632.69 - $714,593.08 792 WCI /UCI Benefit $0.00 $1,055,822.08 $1,055,822.08 $0.00 801 Weed And Seed $9,202.65 $0.00 $0.00 $9,202.65 802 911 Equipment $494.49 $0.00 $0.00 $494.49 803 Salary Fee Judicial $13,031.93 $38,904.25 $31,975.39 $19,960.79 805 Grand Trunk Corp $1,045,016.75 $76,876.18 $1,121,892.93 $0.00 806 Welfare Excess $6,369.35 $7.09 $112.12 $6,264.32 807 Filming Fees $5,100.00 $3,537.50 $0.00 $8,637.50 808 Chrp $63,198.84 $289,848.73 $289,850.00 $63,197.57 809 Hope Vi Pilot $102,465.71 $79,243.00 $28,400.43 $153,308.28 810 Energy Efficient $515,976.40 $0.00 $514,878.40 $1,098.00 811 Geminus Grant $6,572.96 $21,333.35 $16,402.80 $11,503.51 812 FireFighter Safer Grant - $279,912.49 $1,347,121.80 $1,317,698.88 - $250,489.57 815 Neighborhood Stabilization Program $9,471.68 $2,508,864.01 $2,444,573.50 $73,762.19 816 Lead Base Paint Hazzard Control G $76,467.05 $0.00 $19,600.00 $56,867.05 819 Gun Buy Back $3,500.00 $0.00 $0.00 $3,500.00 820 Law Non - reverting $14,988.83 $109,381.40 $74,236.15 $50,134.08 821 Small Farms Tif District $100,110.91 $145,000.00 $180,282.85 $64,828.06 822 Downtown Mall Tif District $67,525.13 $0.00 $35,562.00 $31,963.13 823 Consolidated Area Tif District $796,532.91 $990,556.58 $1,268,239.04 $518,850.45 824 Madison Avenue Tif District $576,694.42 $73,677.60 $190,680.05 $459,691.97 825 Washington Manor Tif District $16,886.49 $0.00 $0.00 $16,886.49 826 Lakefront Tif District $5,905,322.09 $1,858,542.87 $3,751,620.05 $4,012,244.91 827 Consolidated Area Exp Tif District $102,441.61 $250,124.92 $3,067.85 $349,498.68 828 Midwest Center Tif District $418,214.42 $0.00 $0.00 $418,214.42 830 Lancaster Dusable Tif District $0.00 $29,080.70 $29,080.70 $0.00 831 Sr912 No. 1 Tif District $15,756.84 $0.00 $0.00 $15,756.84 832 Sr912 No. 2 Tif District $172,009.46 $0.00 $0.00 $172,009.46 833 County Market Tif District $340,538.83 $473,988.43 $585,037.89 $229,489.37 834 Dalton Arms Tif District $48,245.20 $314,402.20 $271,665.00 $90,982.40 835 Kenney's Ribs Tif District $133,749.42 $0.00 $133,749.42 $0.00 836 Tif Replacement $73,070.99 $0.00 $0.00 $73,070.99 837 Gary City Center Allocation Area $35,496.80 $0.00 $0.00 $35,496.80 838 Truck City Of Gary Allocation Area $116,207.76 $181,353.45 $130,464.69 $167,096.52 840 Guea Properties $2,641.98 $0.00 $0.00 $2,641.98 841 Department of Commerce $11,585.74 $206.78 $0.00 $11,792.52 842 Fair Housing $11,205.00 $33,615.00 $43,946.54 $873.46 843 Equipment Lease $0.00 $2,848,000.00 $2,619,765.98 $228,234.02 844 Inspection Program $0.00 $419,605.00 $58,163.21 $361,441.79 845 Green Urbanism $0.00 $15,621.40 $0.00 $15,621.40 846 Metro Center $2,189.21 $0.00 $0.00 $2,189.21 847 Public Health Program $0.00 $17,767.00 $17,766.99 $0.01 848 Elimination of Disparities $49,251.52 $444,169.48 $462,714.06 $30,706.94 Cash Benchmarking Report 4/4/2014 23 Cash Benchmarking Report 4/4/2014 24 Gary Civil City, Lake County, Indiana Cash & Investments Combined Statement - 2013 Beg Cash End Cash & Inv Bal & Inv Bal Local Fund Local Fund Name Jan 1, 2013 Receipts Disbursement Dec 31, 2013 Number SubTotal $31,565,208.15 $192,919,856.83 $191,166,253.30 $33,318,811.68 STORM WATER 426 GSDWM E. Ridge Road Project $127,623.04 $175,429.72 $260,131.56 $42,921.20 MANAGEMENT DISTRICT 677 Gary Storm Water Management District $1,671,831.29 $2,723,072.53 $1,149,083.01 $3,245,820.81 SubTotal $1,799,454.33 $2,898,502.25 $1,409,214.57 $3,288,742.01 GSD 239 Gsd/Wrep Economic Development $1,980.80 $0.00 $0.00 $1,980.80 371 Gad Debt Service $3,494,010.31 $1,760,514.94 $2,820,130.00 $2,434,395.25 372 Gad Bond And Interest $1,809,177.22 $3,226,144.14 $3,182,986.46 $1,852,334.90 373 Gad Debt Service Reserve $1,842,729.61 $300,023.02 $49.58 $2,142,703.05 431 Gad Grand Calumet Sedimentation $3,496,805.24 $3,493.91 $0.00 $3,500,299.15 433 Gad Sewer Construction $31,160.96 $128,052.61 $132,000.00 $27,213.57 435 Gad Equipment Replacement $4,857,374.66 $2,661,462.39 $345,385.24 $7,173,451.81 670 Gad Wwtp General Operating $2,953,559.35 $28,272,906.57 $28,231,117.07 $2,995,348.85 671 Gad Sewer Operating $95,322.55 $26.89 $0.00 $95,349.44 672 Gad Solid Waste Disposal $99,803.99 $5,838,002.00 $5,493,613.00 $444,192.99 674 Gad Beach Sampling $28,779.66 $39,225.00 $0.00 $68,004.66 675 Gad E Coli $88,260.00 $26,208.40 $0.00 $114,468.40 678 GSD Long Lake Water $56,633.04 $0.00 $0.00 $56,633.04 SubTotal $18,855,597.39 $42,256,059.87 $40,205,281.35 $20,906,375.91 GRAND TOTAL $52,220,259.87 $238,074,418.95 $232,780,749.22 $57,513,929.60 Cash Benchmarking Report 4/4/2014 24 Cash Benchmarking Report 4/4/2014 25 Fort Wayne Civil City, Allen County, Indiana Cash & Investments Combined Statement - 2013 Beg Cash End Cash & Inv Bal & Inv Bal Local Fund Local Fund Name Jan 1, 2013 Receipts Disbursement Dec 31, 2013 Number Governmental Activities 10 General $6,689,650.56 $82,803,169.68 $84,238,682.43 $5,254,137.81 11 Fire Department $1, 465, 745.17 $40,956,954.77 $41,424,597.19 $998,102.75 121 Parks And Recreation $1,656,487.14 $12,965,104.56 $13,489,538.03 $1,132,053.67 122 Park Upff Grant $70.50 $0.08 $0.00 $70.58 123 Redevelopment General $224,217.30 $424,550.33 $615,830.11 $32,937.52 124 Abandon Vehicle Fund $247,919.76 $41,503.44 $2,358.82 $287,064.38 128 Motor Vehilce Highway $1,023,292.42 $13,552,797.43 $13,024,955.40 $1,551,134.45 132 Parking Enforcement - $69,228.17 $567,500.41 $554,088.70 - $55,816.46 138 Local Road And Street $2,093,890.48 $2,913,481.50 $3,192,016.82 $1,815,355.16 140 Fire Pension $650,669.55 $6,772,388.66 $6,987,384.05 $435,674.16 141 Police Pension $1,058,586.49 $8,439,685.36 $7,867,461.61 $1,630,810.24 142 Sanitary Officers Pension $134,058.15 $348,724.39 $462,059.08 $20,723.46 153 Law Enforecement Training $1,243,146.50 $320,102.88 $169,854.29 $1,393,395.09 154 Fire Education $9,903.51 $14,645.89 $6,622.77 $17,926.63 160 Omnibus Crime - $15,166.50 $62,495.05 $55,149.84 - $7,821.29 166 Cable Television $393,210.96 $1,084,208.12 $1,129,868.15 $347,550.93 175 Community Development Block Grant - $218,844.49 $2,107,985.86 $2,180,082.05 - $290,940.68 180 Reimbursable State Grants $2,072.11 $697,605.59 $756,206.95 - $56,529.25 183 Unsafe Building $593,815.97 $1,204,048.20 $913,407.09 $884,457.08 186 Ded International Trade $5,286.47 $4.76 $5,925.16 - $633.93 187 Home - $119,260.88 $1,143,584.09 $1,087,503.84 - $63,180.63 189 Fwnp Program $0.00 $8,921.27 $8,921.27 $0.00 191 Federal Revolving $103,221.91 $3,398,375.81 $3,084,719.80 $416,877.92 193 Hands - $203.48 $218,827.72 $222,126.40 - $3,502.16 194 Hands - Renaissance Pointe $46,415.25 $1,755,682.35 $29,742.89 $1,772,354.71 195 Affordable Housing Trust $7,058.20 $7.07 $0.00 $7,065.27 197 Udag Grant $20,041.03 $20.08 $0.00 $20,061.11 198 Ft Wayne Urban Enterprise Assoc - $29,319.76 $400,596.11 $401,072.02 - $29,795.67 199 Emergency Shelter - $20,321.37 $143,328.70 $138,543.03 - $15,535.70 204 1991 Tiff Debt Service $129,287.13 $11.99 $0.00 $129,299.12 206 1992 Tiff Getz Road Bond $743,113.57 $66.65 $4,958.33 $738,221.89 208 Cc Urban Renewal -98 Reserve $6,999,053.85 $2,816,072.89 $6,787,696.87 $3,027,429.87 209 Tiff Ft Wayne Intl Airport $2,279,457.86 $1,660,011.14 $100,000.00 $3,839,469.00 211 2002 Infrastructure Bond $624.28 $0.28 $350.00 $274.56 213 Grand Wayne Property Misc Expense $2,073,841.43 $4,436,005.75 $2,304,495.00 $4,205,352.18 214 Grand Wayne Revenue Pool $3,662,289.77 $3,668.95 $0.00 $3,665,958.72 215 Grand Wayne Bond P And $0.00 $2,304,000.00 $2,304,000.00 $0.00 216 2005 Redevelopment Bond $19,441.75 $19.28 $250.00 $19,211.03 220 2009 Cedit Bond $4,526,084.03 $1,821.58 $1,975,839.36 $2,552,066.25 221 Lease Monies $451,264.40 $6,650,057.49 $5,738,835.60 $1,362,486.29 223 Neighborhood Stabilization - $759,972.51 $1,135,367.05 $394,552.02 - $19,157.48 226 Harrison Sq Taxable Lease $449,379.23 $2,193,466.75 $2,311,000.00 $331,845.98 227 Harrison Square Exempt Lease $381,127.00 $1,314,781.74 $1,257,000.00 $438,908.74 229 Neighborhood Stabilization $0.00 $700,359.41 $621,323.05 $79,036.36 312 Lima Wells Fernhill TIFF $94,077.68 $761,635.67 $485,129.82 $370,583.53 313 W Highway 30 TIFF $310,070.04 $508,101.47 $7,975.00 $810,196.51 314 E Illinois TIFF $830,468.99 $555,249.11 $6,151.30 $1,379,566.80 315 Lima Ley Tif $211,649.42 $70,511.50 $104.29 $282,056.63 316 Summit Park Tiff $1,943,318.89 $2,625.25 $38,574.07 $1,907,370.07 317 Apple Glen Tiff $3,932,487.80 $2,439,256.46 $4,365,592.26 $2,006,152.00 318 Chaple Ridge Tiff $4,300,254.23 $4,306.98 $14,772.00 $4,289,789.21 319 Brownfield Redevelopment $155,444.52 $351,888.41 $289,162.92 $218,170.01 320 Renaissance Point Economic Dev Tiff $0.00 $40,945.34 $2,091.29 $38,854.05 321 Southtown Mall Project $9,170.07 $730,430.17 $677,836.50 $61,763.74 322 Adams Center Economic Dev TIFF $0.00 $95,236.56 $0.00 $95,236.56 327 2005 Southtown Tax Exempt Bond - $321,918.76 $640,000.02 $318,081.26 $0.00 328 Public Safety Academy - $1,413,658.22 $2,855,000.00 $3,241,900.02 - $1,800,558.24 330 Centennial Industrial Park $832,743.23 $812.38 $60,000.00 $773,555.61 341 Harrison Sq Stadium Maintenance $954,274.22 $496,876.79 $362,370.26 $1,088,780.75 342 Harrison Sq Parking Garage $20,922.36 $178,070.60 $145,031.56 $53,961.40 344 Redevelopment District Capital $1,349,035.06 $479,004.72 $410,231.29 $1,417,808.49 345 Cumulative Capital Improvement $659,250.17 $758,330.40 $625,365.95 $792,214.62 355 Park Cumulative Building $2,047,705.79 $852,446.53 $1,613,163.42 $1,286,988.90 403 Insurance $1,494,172.24 $29,217,187.99 $27,030,651.91 $3,680,708.32 406 Central Garage $269,496.77 $7,488,469.20 $7,334,109.75 $423,856.22 408 Self Insurance Program Fund $2,079,277.59 $2,964,349.96 $3,014,562.25 $2,029,065.30 422 Park Trust $1,899,626.77 $1,391,806.54 $1,247,706.90 $2,043,726.41 424 General Trust $847,170.82 $692,857.46 $648,047.47 $891,980.81 428 Park Nonreverting Capital $489,208.43 $161,810.49 $147,416.29 $503,602.63 429 Domestic Violence $11,386.16 $7,749.08 $7,573.31 $11,561.93 431 Cedit Capital Improvement $4,904,291.43 $22,470,709.57 $25,802,158.82 $1,572,842.18 433 2005 Park Bond $165,262.90 $165.54 $0.00 $165,428.44 436 Rainy Day $2,091,272.95 $0.00 $2,091,273.00 -$0.05 437 Humane Trust $670,592.78 $193,922.98 $147,067.99 $717,447.77 438 Animal Control Special Project $163,590.68 $163,047.39 $162,624.64 $164,013.43 439 Park Nonreverting Operating $669,803.27 $1,678,455.75 $1,684,482.31 $663,776.71 Cash Benchmarking Report 4/4/2014 25 Fort Wayne Civil City, Allen County, Indiana Cash & Investments Combined Statement - 2013 Cash Benchmarking Report 4/4/2014 26 Beg Cash End Cash & Inv Bal & Inv Bal Local Fund Local Fund Name Jan 1, 2013 Receipts Disbursement Dec 31, 2013 Number 440 Economic Development Incentive $1,020,037.44 $804,691.04 $656,667.30 $1,168,061.18 441 Econ Dev Infrastructure Improv $1,023,290.44 $1,103,320.24 $1,306,225.40 $820,385.28 442 Cd Marketing $34,705.47 $795,126.47 $768,385.50 $61,446.44 443 Cd Strategic $190,599.68 $1,318,313.96 $1,280,534.04 $228,379.60 445 Consolidated Comm Partnership $894,648.05 $8,423,645.05 $7,894,380.36 $1,423,912.74 449 CSQ Parking Fund $67,446.76 $261,101.93 $363,213.97 - $34,665.28 490 Barrett Law Revolving $2,202,279.17 $230,295.08 $540,054.70 $1,892,519.55 491 Barrett Law Surplus $44,447.36 $682.35 $2,117.71 $43,012.00 492 Barrett Law Commercial $102,296.63 $912.77 $0.00 $103,209.40 498 Legacy Fund $56,300,753.82 $5,607,622.40 $10,207,651.19 $51,700,725.03 975 PSA Operating $66,540.22 $1,679.11 $29,871.59 $38,347.74 999 Municpal Building Corp. $3,710,011.00 $3,868,468.19 $4,015,879.00 $3,562,600.19 SubTotal $135,478,910.89 $306,229,130.01 $314,895,206.63 $126,812,834.27 STORM WATER 515 Storm Water- Operating $3,347,516.07 $11,044,991.78 $9,193,185.63 $5,199,322.22 515 Storm Water -Bond And Interest $634,083.00 $1,436,509.00 $1,521,800.00 $548,792.00 515 Storm Water -Pilot $0.00 $1,172,771.00 $1,172,771.00 $0.00 SubTotal $3,981,599.07 $13,654,271.78 $11,887,756.63 $5,748,114.22 YARD WASTE 517 Yard Waste $312,755.82 $196,372.37 $132,204.52 $376,923.67 SubTotal $312,755.82 $196,372.37 $132,204.52 $376,923.67 WASTEWATER 514 Sewage Utility- Construction 2011A Bond $22,273,710.45 $4,359.66 $11,737,456.66 $10,540,613.45 514 Sewage Utility-Bond And Interest $6,693,099.75 $22,770,599.76 $18,775,159.66 $10,688,539.85 514 Sewage Utility- Operating $14,995,364.29 $71,965,025.23 $71,878,207.97 $15,082,181.55 514 Sewage Utility- Reserve Account $20,450,216.32 $4,941,906.25 $0.00 $25,392,122.57 514 Sewage Utility- Restricted $115,269.91 $338,527.05 $301,714.63 $152,082.33 514 Sewage Utility -2009 Sri B $1,306,232.53 $0.01 $1,288,112.00 $18,120.54 514 Sewage Utility -Pilot $0.00 $3,840,297.00 $3,840,297.00 $0.00 514 Sewage Utility -2010 Bond $920,359.00 $183.25 $476,004.23 $444,538.02 514 Sewage Utility - 2012 B Bond $14,196,378.65 $3,470.65 $5,803,949.23 $8,395,900.07 514 Sewage Utility -2012 Refunder Bond $0.00 $8,132,821.96 $8,132,821.96 $0.00 514 Sewage Utility - SERF $1,096,717.81 $0.00 $0.00 $1,096,717.81 514 2013 A &B Construction Fund $0.00 $74,893,016.93 $12,315,642.91 $62,577,374.02 SubTotal $82,047,348.71 $186,890,207.75 $134,549,366.25 $134,388,190.21 WATER 0513 Water Utility - 2012 Water Bond Fund $18,172,421.57 $4,921.72 $4,877,249.74 $13,300,093.55 513 Water Utility -2011 SRF B Bond $10,079,771.12 $2,919.86 $9,815,223.00 $267,467.98 513 Water Utility - Reserve $10,282,583.43 $8,845.61 $775,000.00 $9,516,429.04 513 Water Utility- Operating $3,701,817.50 $41,850,060.12 $36,107,533.94 $9,444,343.68 513 Water Utility -Bond And Interest $748,415.39 $9,098,927.94 $9,059,226.68 $788,116.65 513 Water Utility- Customer Deposit $1,371,630.76 $69,950.79 $0.00 $1,441,581.55 513 Water Utility -Pilot $0.00 $3,504,030.50 $3,504,030.50 $0.00 513 Water Utility- Airport Expressway $313,247.19 $0.00 $0.00 $313,247.19 SubTotal $44,669,886.96 $54,539,656.54 $64,138,263.86 $35,071,279.64 PARKING GARAGES 131 Civic Center Parking Garage $301,729.83 $679,253.20 $706,089.66 $274,893.37 133 Midtowne Parking Garage $8,130.05 $89,053.31 $81,034.33 $16,149.03 222 2001 Parking Garage Addition $4,018.17 $221,275.52 $251,472.95 - $26,179.26 SubTotal $313,878.05 $989,582.03 $1,038,596.94 $264,863.14 SOLID WASTE 12 Solid Waste $1,642,884.95 $10,448,857.77 $10,834,829.86 $1,256,912.86 SubTotal $1,642,884.95 $10,448,857.77 $10,834,829.86 $1,256,912.86 GRAND TOTAL $268,447,264.45 $572,948,078.25 $537,476,224.69 $303,919,118.01 Cash Benchmarking Report 4/4/2014 26