Loading...
HomeMy WebLinkAbout2017-11 Financial ReportPeriod Ending: Issued By: City of South Bend Financial Report Tab Page Contents Narrative 2 Brief discussion on notable fund activity Revenue 3-10 City Revenues Prop Tax Rev 11-12 Property Tax Revenue Collection Status Expenditures 13-17 Expenditures by Fund and Department Debt 18-19 Debt Status Debt Monthly 20-21 Current Debt at Month End Headcount 22-25 Staffing Levels Distribution Mayor Pete Buttigieg Chief of Staff Laura O'Sullivan Deputy Chief of Staff Suzanna Fritzberg South Bend Common Council Members Administration and Finance Department Heads Fiscal Officers November 30, 2017 Controller 2017-11 Financial Report Page 1 of 25 November 30, 2017 Financial Report The Financial Report provides current year financial information for each City fund in a condensed format. Information is provided for revenue (by type and fund), expenditures, property taxes, debt status, and staffing levels. This report is prepared monthly and supplements other reports that the City prepares such as the Controller's Cash Report, the Monthly Departmental Financial Report, and the Comprehensive Annual Financial Report (CAFR). Revenue by Type Revenue by Fund -Fund 291 (River Rescue), is at 107% of its budgeted revenue. This is revenue related to tuition fees for the river rescue class. -Fund 216 (Police Seizures) is 23% above of its budgeted revenue. This is revenue from confiscated property. -Fund 294 (Police Academy) is at 84% of its budget. This is revenue related to the advancement of present and future police officers. -Fund 221(Landlord Registration), is at 106% of its budgeted revenue. This is revenue received from an Ordinance enacted by the Common Council in 2016. Property Taxes Expenditures Debt Headcount If you have any questions regarding this report, please contact the Department of Administration and Finance at (574) 235-9216. As of November 2017,the City has spent 69%of budgeted expenditures,compared to 70%last year.The General Fund has spent 83% of its 2017 budgeted expenditures,compared to 85%in 2016.The following funds have reached 80%or more of their budgeted expenditures as a result of bond payments:Fund 313(Hall of Fame),Fund 377(Professional Sports Development),and Fund 432(TIF- Erskine Village). This month,various debt service payments were made in the amount of~$347,000.Payments are related to IT equipment leases.St. Joseph County PSAP, Indiana Finance Authority, and US Bank. The Full Time Headcount as of October was 1,096 vs.a budgeted amount of 1,107.Currently,there are a total of 17 vacant positions. The 17 open positions are in the following departments:General Government(4),Parks(1),Police(4),Public Works(5),DCI(1),Morris and Palais (1), and Human Rights Commission (1). At this time, the Fire Department is over budget by six positions (6) due to fire recruits. For discussion on property taxes,see section listed below.The overall percentage of budgeted revenues that have been received by the city is 80%,compared to 81%in November 2016.Revenue types 350(Job Penalty Fee)335(State Pension Subsidy and Gaming Proceeds) and 317 (Hotel / Motel Tax) have all reached 100% of their budgeted revenue. As of November 2017,the general fund has reached 64%of its budgeted revenue,similar to last year.The following funds have reached slightly above the normal percentage of their 2017 budgeted revenue amount at this time: Property taxes are received in June and December.Property taxes collected this month totaled~$41.8 million.Civil city funds received ~$27.5 million and TIF funds received~$14.3 million.For 2017,the projected levy collection rate is 95%or$75.6 million.Please note, 2017 civil city funds are budgeted to be ~$400,000 more than 2016 budget. - Funds 249 (PS LOIT), 404 (COIT), and 408 (EDIT) received normal and timely distributions this month. 2017-11 Financial Report Page 2 of 25 City of South Bend Period Ending:November 30, 2017 Revenue by Type Report $ Fund% Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Property Tax 311 Property Tax Civil City various- - - - - 27,489,054 - - - - - 27,489,054 49,770,000 55% 311 Property Tax TIF Districts various- - - - - 14,314,504 - - - - - 14,314,504 27,254,124 53% Sub Total- - - - - 41,803,558 - - - - - - 41,803,558 77,024,124 54% Income Tax 315 Econ Development Income Tax 408 883,344 883,344 866,667 866,667 866,667 866,667 866,667 866,667 866,667 866,667 866,667 - 9,566,694 10,433,361 92% 316 Local Option Income Tax - PS 249 622,302 622,302 622,302 622,302 622,302 622,302 622,302 622,302 622,302 622,302 622,302 - 6,845,317 7,467,618 92% 316 County Option Income Tax 404 871,605 871,605 871,605 871,605 871,605 871,605 871,605 871,605 871,605 871,605 871,605 - 9,587,660 10,459,265 92% Sub Total 2,377,250 2,377,250 2,360,574 2,360,574 2,360,574 2,360,574 2,360,574 2,360,574 2,360,574 2,360,574 2,360,574 - 25,999,670 28,360,244 92% St Joseph County (Remitted by) 312 Auto Excise Tax various- - - - - 1,680,548 - - - - - - 1,680,548 3,206,500 52% 312 Commercial Vehicle Tax various- - - - - 402,188 - - - - - - 402,188 843,000 48% 317 Hotel Motel Tax Century Center 670 637,500 - (318,750) 106,250 106,250 106,250 106,250 106,250 106,250 106,250 106,250 - 1,168,750 1,275,000 92% 317 Hotel Motel Tax Century Center 324- - - 197,500 - - - - - 196,500 - - 394,000 394,000 100% 317 Hotel Motel Tax Cum Cap Imprv 407 150,000 - - - - - - - - - - - 150,000 150,000 100% Sub Total 787,500 - (318,750) 303,750 106,250 2,188,986 106,250 106,250 106,250 302,750 106,250 - 3,795,486 5,868,500 65% State of Indiana (Remitted by) 335 Cigarette Tax 101/407- - - - - 148,523 - - - - - - 148,523 328,000 45% 335 State Pension Subsidy 701/702- - - - - 5,565,446 - - 5,559,446 - - - 11,124,892 11,124,891 100% 335 Gaming Proceeds 101- - - - - - - - 599,027 - - - 599,027 599,000 100% 335 Gasoline Tax 202/251 361,601 314,230 394,563 456,411 426,999 355,323 422,807 165,846 501,809 629,893 552,275 - 4,581,757 4,668,000 98% 335 Liquor Excise tax 101- 42,158 - - - - 28,925 - - - - - 71,082 75,000 95% 335 Liquor Gallonage Tax 101 63,498 - - 44,056 - - 56,137 - - 61,026 - - 224,717 210,000 107% 335 Prof Sports Development Tax 377 62,404 - 115,348 24,070 23,090 - - - - - - - 224,912 700,000 32% 335 Wheel Tax 202- - 503,523 - 451,523 - 372,905 368,811 - 355,070 - - 2,051,832 2,050,000 100% Sub Total 487,503 356,388 1,013,434 524,537 901,612 6,069,292 880,773 534,657 6,660,282 1,045,990 552,275 - 19,026,742 19,754,891 96% Other Intergovernmental Sources 336 Federal Drug 299- - - - - - - - 1,823 - - - 1,823 30,000 6% 337 State Drug 216 10,113 2,962 - 30 1,897 - - - - - 3,682 - 18,684 35,000 53% 337 Regional Cities Grant 201- - - - - - - - - - - - - 5,000,000 0% 338 Payment in Lieu of Tax various 517,361 871,113 517,361 871,113 517,361 517,361 517,361 517,361 871,113 517,361 517,361 - 6,752,226 7,623,328 89% 339 Contractual Service 211 9,669 12,407 38,314 17,294 7,957 11,557 7,257 57,569 11,063 10,069 8,267 - 191,418 316,000 61% Sub Total 537,143 886,481 555,675 888,436 527,215 528,918 524,618 574,930 883,999 527,430 529,309 - 6,964,152 13,004,328 54% Charge for Service Internal City 340 Liability Insurance 226 243,168 243,964 241,179 246,749 241,179 246,749 241,179 241,179 241,179 252,319 241,179 - 2,680,022 2,927,591 92% 340 General Government Misc Chgs 101- - - - - - - - - 25 - - 25 500 5% 349 Central Service 222 51,820 48,684 51,854 49,741 49,575 50,298 46,813 59,676 55,927 64,163 64,554 - 593,105 873,809 68% 380 Central Service 222 210,212 208,994 226,075 189,251 209,433 210,487 197,836 222,500 195,631 239,484 185,151 - 2,295,054 2,880,310 80% 380 Energy Office Reimbursements 222 411,202 429,754 368,989 361,064 360,950 322,928 276,803 432,821 355,622 367,851 339,510 - 4,027,494 4,492,800 90% 380 LOIT 2016 Special Distribution 257- - 152,895 - - 52,501 - - 55,792 - - - 261,189 205,397 127% 380 IT Innovation 311 Center 279 430,621 430,621 430,621 430,621 430,621 430,621 430,621 430,621 430,621 430,621 430,621 - 4,736,831 5,205,034 91% 380 Beck's Lake Reimbursement 404- - 283,432 - - - - - - - - - 283,432 283,432 100% 380 Insurance Claim various- - - - - - - - 143,523 - - - 143,523 143,523 100% 380 INDOT SR 933 Transfer 251 /324- - - - - - - - - - - - - 330,000 0% 380 TIF 324- - - - - - - - 151,064 - (151,064) - - - NA 380 Internal Service Reimbursement various 65,792 89,865 18,297 77,763 111,522 51,754 103,533 49,917 387,855 46,154 317,061 - 1,319,513 2,341,441 56% 392 Administration Fee 101/279 414,748 414,748 414,748 414,748 414,748 414,748 414,748 414,748 414,748 414,748 414,748 - 4,562,228 4,977,026 92% 392 Internal Fund Transfers various 1,085,348 9,754,150 4,553,299 4,585,904 1,649,180 1,807,518 1,279,407 5,585,586 4,161,903 1,713,919 1,704,144 - 37,880,357 41,795,537 91% 395 Employee Benefits 711/713 1,499,317 1,460,178 1,492,929 1,487,450 1,477,818 1,483,231 1,473,862 1,497,421 1,474,726 1,460,367 1,459,219 - 16,266,518 17,770,850 92% 2017-11 Fin anc i al Re port - Rev enue Report Page 3 of 25 City of South Bend Period Ending:November 30, 2017 Revenue by Type Report $ Fund% Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget 396 Central Service Refunds 222 1,314 - 62,668 (56,756) 2,392 1,416 - - - 3,330 5,780 - 20,143 21,000 96% 396 Self Funded Employee Benefits 711 6,503 (2,436) 496 - - 389 41,857 52,421 5,572 4,911 489 - 110,201 46,809 235% xxx xxx xxx- NA Sub Total 4,420,045 13,078,521 8,297,481 7,786,534 4,947,418 5,072,640 4,506,658 8,986,890 8,074,163 4,997,893 5,011,391 - 75,179,634 84,295,059 89% 3rd Party Revenue 340 ND EMS Service 288- - 44,904 - 1,338 14,152 2,832 - - - 6,753 - 69,978 150,000 47% 350 Job Target Penalty Fee 408- 354,660 - - - - - - - - - - 354,660 354,660 100% 364 Cable TV Franchise Fees 101- 192,238 - - - - - 195,839 - - 186,844 - 574,920 748,000 77% 366 AT&T Franchise Fees 101 55,865 - - - 51,778 - - 48,750 - - - - 156,394 284,000 55% 393 Debt Proceeds various- - - - 2,916,500 - - - 26,632,000 - - - 29,548,500 30,499,000 97% Sub Total 55,865 546,898 44,904 - 2,969,616 14,152 2,832 244,589 26,632,000 - 193,596 - 30,704,452 32,035,660 96% Grants 331 Federal Grants various 468,447 1,200,229 111,355 149,580 103,356 263,868 96,934 77,343 302,268 68,852 1,024,121 - 3,866,355 8,916,624 43% 334 State Grants various- - 33,745 5,150 - 137,805 - 275,321 67,600 - - - 519,622 703,499 74% Sub Total 468,447 1,200,229 145,100 154,730 103,356 401,673 96,934 352,664 369,868 68,852 1,024,121 - 4,385,976 9,620,123 46% Fees for Services External 320 Inspections Central Service 222- - - 450 350 270 - 10 330 - - - 1,410 1,450 97% 321 Business License 101/222 30,917 29,318 15,746 12,407 11,383 4,566 1,656 10,809 7,191 2,485 1,075 - 127,554 129,532 98% 321 Code and Animal Fees 600 4,536 4,585 6,015 5,891 6,975 6,368 7,095 6,521 7,047 6,372 5,792 - 67,194 63,300 106% 322 Building Fees 600 90,363 86,593 108,895 95,111 141,205 195,184 108,715 170,070 124,307 125,105 108,312 - 1,353,859 1,369,350 99% 322 Code Enforcement Fees 600 1,050 300 3,000 1,500 600 2,800 1,200 900 1,200 600 3,100 - 16,250 20,000 81% 322 EMS Operating Fund 288 1,923 1,380 1,542 910 2,973 2,613 1,609 3,218 1,380 1,047 1,285 - 19,880 24,238 82% 322 General Government Fees 101 32,047 7,275 12,535 6,200 3,925 4,200 9,080 4,240 4,530 10,500 13,060 - 107,592 106,127 101% 341 General Government Various various 3,316 959 5,210 5,841 1,367 3,126 3,262 982 1,166 1,411 5,360 - 32,000 31,062 103% 342 Highway & Streets 101/202 38,686 - 16,474 2,320 43,516 13,142 - - - 37,381 - - 151,520 223,365 68% 342 Public Safety various 12,869 10,404 21,290 12,093 12,302 8,422 10,567 13,087 9,553 15,129 11,891 - 137,608 150,000 92% 342 EMS - County Fees 288- 294,414 147,207 147,207 147,207 147,207 147,207 147,207 147,207 147,207 147,207 - 1,619,279 1,740,000 93% 342 EMS - Capital Fund 287- 1,798,417 - - - - - 1,411,931 - - - - 3,210,349 4,485,349 72% 342 EMS - Operating Fund 288 160,939 235,524 271,371 210,652 215,161 283,974 218,716 352,673 283,950 328,536 306,433 - 2,867,930 2,700,000 106% 342 EMS - Neo Natal / Transport 288 16,185 18,553 16,128 14,553 4,909 167,113 37,377 46,570 34,401 42,260 48,629 - 446,678 1,699,512 26% 344 Solid Waste 610 445,203 460,843 468,017 403,574 285,268 412,168 416,424 414,479 415,555 416,566 414,816 - 4,552,913 5,636,175 81% 344 Code Environmental Clean Up 101/219/600 12,404 3,044 22,134 17,648 11,871 19,048 13,263 13,913 16,730 10,580 25,503 - 166,137 254,258 65% 344 Sewage Waste Water 641 3,208,590 3,128,008 3,112,534 3,105,650 3,096,610 3,192,879 3,215,485 3,301,710 3,280,685 3,276,664 3,181,525 - 35,100,340 37,233,004 94% 344 Sewer Repair Insurance 640 53,614 52,952 53,742 52,772 52,682 55,215 52,659 52,452 53,412 52,805 53,713 - 586,018 613,924 95% 344 Water Leak Insurance 620 81,303 81,237 81,371 81,350 81,736 81,925 81,942 82,009 81,955 82,227 82,177 - 899,231 980,000 92% 346 Water Works Utility 620 1,039,872 1,012,523 1,016,299 1,006,997 1,032,846 1,254,697 1,441,297 1,448,047 1,454,002 1,332,942 1,207,498 - 13,247,020 14,685,122 90% 346 Solid Waste Misc 610 1,504 10,324 12,564 40,321 44,124 42,440 42,652 43,023 43,931 43,882 43,170 - 367,934 389,100 95% 346 Project ReLeaf 655 36,802 36,730 36,817 36,854 37,012 37,156 37,164 37,212 37,209 37,346 37,272 - 407,573 440,153 93% 347 Parks & Recreation various 74,837 77,843 366,527 173,383 231,644 355,839 316,702 486,025 242,812 441,531 147,026 - 2,914,168 4,193,585 69% 347 Sale of Merchandise 101- - - - - 70 - - - - 20 - 90 100 90% 347 Morris PAC 416- 12,214 13,143 11,334 5,563 2,871 4,291 1,840 594 4,654 2,350 - 58,854 100,000 59% 349 Parking Garage Fees 601 115,464 73,834 83,097 119,933 135,473 65,973 116,506 119,677 61,382 114,171 90,146 - 1,095,655 1,039,479 105% 349 Code Demolition Board Up 219/600 2,805 2,067 13,981 5,115 1,466 20,689 12,810 3,414 20,141 120 24,490 - 107,097 103,000 104% 349 Parking Century Center 670 12,814 19,676 20,911 11,526 7,998 3,915 2,900 4,800 11,215 8,046 6,900 - 110,700 100,033 111% 349 Parking SBCDA 324/429 350 700 350 350 350 350 - - - - - - 2,450 8,400 29% 351 Fines & Fees various 27,430 36,628 37,210 30,621 38,987 57,046 17,958 14,697 11,990 20,321 26,567 - 319,455 348,635 92% 352 Forfeits various 734 616 3,897 5,014 1,556 23,381 8,542 456 3,570 8,725 5,048 - 61,540 200,500 31% 354 Ordinance Violation various 5,163 7,326 9,708 (3,068) 2,333 2,278 8,232 11,059 8,511 6,693 15,274 - 73,507 102,176 72% 360 Morris PAC various 10,087 86,686 184,282 72,560 46,729 117,156 32,782 17,918 62,083 34,022 24,245 - 688,549 976,000 71% 360 Palais Royale various 24,371 4,131 9,256 7,929 19,759 18,450 34,802 37,340 18,800 21,982 18,182 - 215,002 256,572 84% 360 Parks & Recreation various 9,055 4,207 4,552 9,758 3,205 5,864 4,035 1,982 11,374 (33,897) 302 - 20,436 98,206 21% 360 Police various 4,432 3,558 7,482 1,016 759 14,104 1,717 80,829 23,808 3,785 5,889 - 147,380 25,000 590% 360 Fire various- 37,987 - - - - 9 - - - - - 37,996 - NA 360 TIF various 31,545 2,510 6,859 2,110 2,110 309,933 2,273 154,051 2,110 1,310 153,974 - 668,783 788,269 85% 360 Central Services 222 608 - 50 251 623 57 179 7,784 - 709 492 - 10,752 11,000 98% 360 Century Center 670- 120 578 303 - - - - - - - - 1,000 10,000 10% 360 Dept. Of Community Investment 211/212 65,547 23 - 67,821 291 119,174 55 116,427 641 - 40,449 - 410,427 315,838 130% 360 EMS Operating Fund 288 525 - - - 72 - 2,593 - 25 - 3,614 - 6,829 5,000 137% 360 Engineering / Curb & Sidewalk 101- 50 50 - 125 275 275 100 125 80 100 - 1,180 11,000 11% 360 Fire and Police Pension Fund 701/702 1,523 675 5,700 565 595 5,022 290 120 79 12 1,956 - 16,535 2,000 827% 360 Self Funded Employee Benefits 711- - - - - - - - - - 228 - 228 - NA 360 Industrial Revolving 754- - 3,703 1,121 - - - - - 12,210 - - 17,034 27,000 63% 360 General Government Various 101/3/226 13,427 24 266 148 244 - 241 24 874 131 546 - 15,927 14,000 114% 360 Motor Veh Highway Scrap Metal 202 285 - 1,117 209 1,515 711 - 393 - 1,417 264 - 5,912 4,896 121% 360 Motor Veh Highway Curb Prgm 202 11 - - 1,366 - - - - - - - - 1,377 32,000 4% 360 Local Roads and Streets 251- 274 - - - 3,812 - 4,422 - - - - 8,508 275 3094% 2017-11 Fin anc i al Re port - Rev enue Report Page 4 of 25 City of South Bend Period Ending:November 30, 2017 Revenue by Type Report $ Fund% Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget 360 Professional Sports Development 377 17,864 - - - - - 14,460 - - - - - 32,324 30,000 108% 360 C.O.I.T.404 725 - 1,450 5,051 - - - - - 2,250 - - 9,476 - NA 360 Code / Animal Control 600 170 5 - - 181 - - - - 914 6,265 - 7,535 6,500 116% 360 Building Fees 600- - - 898 - - - - 1,050 - - - 1,948 - NA 360 Parking Garage 601 20 - 180 - 96 - - - 4,423 - - - 4,719 11,282 42% 360 Solid Waste Fund 610- 265 - 2,357 - 229 - - - 362 - - 3,212 2,650 121% 360 Waste Water 641/7/9- 3,437 - 5,103 4,546 4,002 690 41,171 - 4,051 - - 62,999 86,480 73% 360 Water Works Utility 620 / 625- 39 18 2,167 2,237 12,780 25 1,723 28 22 13 - 19,053 37,751 50% 360 Sewage Depreciation Fund 642- 400,000 - - - - - - - - - - 400,000 400,000 100% 360 Equipment / Vehicle Leasing 750- - - - - - 161,154 (161,154) - - - - - - NA 360 Smart Street Bond Cap 753- - - - - - - 20,000 - (20,000) - - - 20,000 0% 362 Dept. Of Community Investment 212 1,847 - - 1,847 - - - 1,847 - 1,847 - - 7,387 7,387 100% 362 Palais Royale 101- 5,114 1,940 1,745 11,426 11,032 10,491 11,008 4,326 5,949 5,769 - 68,799 82,500 83% 362 Police 101- - - 7,238 - - - - 14,475 - 7,317 - 29,030 48,000 60% 362 Parks & Recreation 201 3,786 3,545 5,828 3,970 6,820 6,514 4,422 8,432 1,511 1,259 (2) - 46,085 49,000 94% 362 S Bend School Corp Fee 407- - - - - - 25,000 - - - - - 25,000 25,000 100% 362 TIF Property various 14,223 24,108 14,479 13,450 6,588 15,451 11,619 12,350 134,034 2,961 8,805 - 258,068 319,603 81% 369 Memorial Hosp Leighton Plaza 408 150,000 - - - - - - - - - - - 150,000 150,000 100% 371 Century Center Fees 670 260,617 191,881 72,253 282,346 298,445 201,174 303,672 268,845 236,919 257,612 269,663 - 2,643,427 2,842,650 93% 399 Bosch Retention Project 210- - 15,737 - - 15,855 - - - - - - 31,592 63,661 50% 399 Principal on Loan various 19,897 19,842 19,726 20,742 601 577 1,241 514 576 437 2,382 - 86,536 86,374 100% 399 Principal Income various 30,702 596,589 - 31,814 - - 31,814 346,054 186,218 47,788 - - 1,270,977 1,254,928 101% Sub Total 6,172,987 8,889,356 6,333,219 6,158,391 6,066,357 7,329,097 6,979,149 9,175,212 7,069,434 6,922,517 6,566,090 - 77,661,809 87,271,751 89% Interest Income 361 Bank Account Interest various 156,963 166,772 205,325 97,825 95,274 271,135 328,751 296,209 207,385 154,244 245,794 - 2,225,677 2,385,015 93% Sub Total 156,963 166,772 205,325 97,825 95,274 271,135 328,751 296,209 207,385 154,244 245,794 - 2,225,677 2,385,015 93% Donations 367 ND Contribution 101- - - - - - 330,000 - - - - - 330,000 337,500 98% 367 Donations various 75,816 1,040 70,660 440 25,155 55,987 44,782 83,148 27,285 1,102 686 - 386,101 467,494 83% Sub Total 75,816 1,040 70,660 440 25,155 55,987 374,782 83,148 27,285 1,102 686 - 716,101 804,994 89% Historic Preservation 368 C.O.I.T.404- - - 500 250 250 1,000 500 - - - - 2,500 3,500 71% 368 Palais 450 1,838 114 345 390 646 1,410 2,472 2,815 1,616 1,848 1,507 - 15,000 16,500 91% Sub Total 1,838 114 345 890 896 1,660 3,472 3,315 1,616 1,848 1,507 - 17,500 20,000 88% Sale of Assets 391 TIF (Property Sales / Land)various- 60,000 2 1 61,029 - 1 - 224,892 - - - 345,924 137,331 252% 391 Water Hydrant Reimbursement 620- - - - - - - - - - 2,772 - 2,772 20,000 14% 391 Proceeds F.A. Disposal 600- - - - - - - - - - - - - 3,000 0% 391 Sale of Fixed Assets various- - - - - 1,137 - 178,674 (23,000) - - - 156,811 131,779 119% 391 Vehicle Damage Reimbursement various- - - - - - - - - - - - - - NA - Sub Total- 60,000 2 1 61,029 1,137 1 178,674 201,892 - 2,772 - 505,507 292,110 173% Revenue Total 15,541,356 27,563,049 18,707,970 18,276,109 18,164,753 66,098,808 16,164,794 22,897,112 52,594,748 16,383,200 16,594,365 - 288,986,266 360,553,652 80% report 15,541,356 27,563,049 18,707,971 18,276,109 18,164,753 66,098,808 16,164,795 22,897,112 52,594,748 16,383,200 16,594,366 - 288,986,267 360,553,652 - 0 (1) 0 (0) 0 (1) 0 (0) (0) (0) - (1) - 2017-11 Fin anc i al Re port - Rev enue Report Page 5 of 25 City of South Bend Period Ending:November 30, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget General Government 0000 General Revenues 101 1,105,267 1,215,293 975,765 1,001,269 1,006,845 24,478,271 1,381,463 1,233,581 1,566,326 1,011,265 1,144,765 - 36,120,109 56,731,833 64% 0101 Mayor 101- - - - - 70 - - - - 20 - 90 600 15% 0401 Administration and Finance 101 12,254 - 8 - - - - - - 11 327 - 12,600 12,304 102% 0501 Legal 101 18,475 - - - 18,875 - 18,875 - 874 10 - - 57,109 75,377 76% Sub Total 1,135,996 1,215,293 975,773 1,001,269 1,025,720 24,478,341 1,400,338 1,233,581 1,567,200 1,011,286 1,145,112 - 36,189,908 56,820,114 64% Public Works 0602 Engineering 101 32,047 7,275 12,535 6,200 4,050 4,475 9,305 4,401 4,655 10,580 169,279 - 264,802 323,464 82% Sub Total 32,047 7,275 12,535 6,200 4,050 4,475 9,305 4,401 4,655 10,580 169,279 - 264,802 323,464 82% Public Safety 0801 Police 101 34,608 15,151 13,175 13,089 10,980 16,268 9,894 131,366 331,988 10,423 51,579 - 638,522 668,408 96% 0901 Fire 101 4,387 37,987 - - - - 9 - - 25 - - 42,407 42,883 99% Sub Total 38,995 53,138 13,175 13,089 10,980 16,268 9,903 131,366 331,988 10,448 51,579 - 680,929 711,291 96% Arts & Culture 0404 Morris PAC 101 10,888 86,733 183,972 72,872 46,790 113,721 33,286 18,425 60,791 33,429 23,587 - 684,494 976,645 70% 0405 Palais Royale 101 26,265 9,345 13,108 10,025 33,527 30,706 47,868 52,472 24,958 29,737 25,884 - 303,895 359,502 85% xxx xxx- NA Sub Total 37,153 96,078 197,080 82,898 80,317 144,427 81,154 70,897 85,749 63,166 49,471 - 988,389 1,336,147 74% General Fund Revenue Total 1,244,191 1,371,784 1,198,563 1,103,455 1,121,067 24,643,511 1,500,699 1,440,245 1,989,592 1,095,479 1,415,441 - 38,124,028 59,191,016 64% 2017-11 Financial Report - Rev enue Summar y Page 6 of 25 City of South Bend Period Ending:November 30, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Parks & Recreation 0000 Parks General revenue 201 2,200 357,973 3,346 356,258 672 5,358,382 3,408 8,311 385,747 (249) 2,853 - 6,478,900 11,044,007 59% 1100 Administration 201 3,787 3,548 5,830 3,974 7,149 6,524 4,562 8,447 1,523 1,268 1 - 46,613 50,000 93% 1101 Maintenance 201 28,074 104,996 4,776 82,975 77,815 45,183 58,498 84,665 390,850 287,232 98,873 - 1,263,936 1,710,210 74% 1102 Golf Operations 201 1,356 402 152,340 98,890 148,871 194,599 197,540 232,475 137,390 81,010 11,773 - 1,256,647 1,539,195 82% 1103 Recreation Division 201 22 810 1,346 20 1,410 26,012 41,188 29,398 2,532 - - - 102,737 118,435 87% 1104 Potawatomi Zoo 201- - - - - - - - 9,451 (9,451) - - - - NA 1108 Graffiti Removal 201- - - - - 65,540 29,214 7,557 - 7,946 - - 110,258 160,000 69% 1110 Marketing and Events 201- - - 69 - 162 1,717 (125) 222 41,077 - - 43,123 572,471 8% 1111 Regional Cities Grant 201- - - - - - - - - - - - - 5,000,000 0% Recreation Non Reverting 203 75,681 75,021 213,432 75,516 66,022 68,745 106,575 97,011 48,289 33,284 37,458 - 897,032 1,157,768 77% East Race Waterway 271 1 1 1 1 1 2 2 1 - - - - 9 22 40% Coveleski Stadium 401 68 69 79 38 35 104 99 95 41,883 39 85 - 42,593 42,715 100% Zoo Endowment 403 37 38 44 21 11 - - - - - - - 151 200 76% Park Non Reverting 405 4,566 174 571 25,620 26,282 1,232 1,027 887 210,340 130 158 - 270,987 439,850 62% Sub Total 115,792 543,031 381,765 643,382 328,266 5,766,485 443,830 468,720 1,228,228 442,285 151,201 - 10,512,984 21,834,873 48% Public Works Motor Vehicle Highway 202 317,873 1,223,876 828,325 1,361,365 833,924 286,692 703,745 539,275 1,374,593 852,455 397,099 - 8,719,221 10,023,367 87% Central Services 222 675,986 688,080 710,659 544,455 623,794 586,845 523,002 737,413 611,840 676,545 596,086 - 6,974,704 8,308,569 84% Central Services Capital 224 84 72 89 41 35 105 98 85 286,760 18 187 - 287,575 287,600 100% Local Roads & Streets 251 106,827 88,499 130,547 93,992 107,567 126,254 105,638 45,608 184,421 176,319 163,922 - 1,329,593 1,692,997 79% Local Road & Bridge Grant 265- 1,000,000 1,000,000 - - - - - - - - - 2,000,000 2,000,000 100% Project ReLeaf 655 37,450 37,428 37,604 37,214 37,325 38,215 38,248 38,302 38,029 37,789 38,026 - 415,630 449,153 93% xxx xxx xxx NA Sub Total 1,138,220 3,037,955 2,707,224 2,037,067 1,602,646 1,038,111 1,370,730 1,360,683 2,495,642 1,743,126 1,195,319 - 19,726,724 22,761,686 87% Public Works Solid Waste Solid Waste Operations 610 445,931 471,682 480,834 494,568 329,577 455,642 459,819 457,997 483,053 460,975 458,364 - 4,998,441 6,103,341 82% Solid Waste Capital 611 179 240 100,039 83,600 20,027 290,004 65 200,348 7 85,029 62 - 779,599 836,713 93% xxx xxx xxx NA Sub Total 446,110 471,922 580,873 578,168 349,604 745,646 459,884 658,345 483,060 546,003 458,426 - 5,778,041 6,940,054 83% Public Works Water Utility 0000 Water Works Revenues 620 973,972 948,744 947,938 952,254 965,980 1,147,589 1,322,131 1,351,352 1,342,694 1,223,667 1,138,776 - 12,315,097 13,696,536 90% 0630 Water Leak Insurance 620 81,303 81,237 81,371 81,350 81,736 81,925 81,942 82,009 81,955 82,227 82,177 - 899,231 980,000 92% 0660 Clay Water 620 72,507 69,573 74,940 69,858 75,790 126,952 129,104 140,138 121,037 113,261 85,109 - 1,078,268 1,192,586 90% Waterworks Capital 622 1,942 1,950 2,167 958 875 2,956 2,890 2,762 1,985 1,073 1,882 - 21,442 82,000 26% Waterworks Deposit 624 1,159 1,174 1,347 639 583 1,965 1,923 1,851 1,352 733 1,287 - 14,014 16,500 85% Waterworks Sinking 625 164,824 164,289 164,321 164,211 164,266 177,878 1,266 328,973 811 328,522 165,100 - 1,824,460 2,068,642 88% Waterworks Bond Reserve 626 1,154 1,073 1,235 594 548 1,828 1,791 1,732 1,278 705 1,217 - 13,155 16,000 82% Waterworks Debt Reserve 629 153,121 1,895 2,292 1,092 1,000 3,386 3,328 3,214 2,354 1,276 2,235 - 175,192 179,000 98% xxx xxx xxx NA Sub Total 1,449,981 1,269,935 1,275,612 1,270,956 1,290,778 1,544,479 1,544,374 1,912,030 1,553,466 1,751,464 1,477,782 - 16,340,858 18,231,264 90% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 54,941 54,328 55,305 53,519 53,371 57,542 54,949 54,686 55,048 53,701 55,297 - 602,686 632,424 95% 0000 Wastewater Revenues 641 3,044,674 2,968,092 2,944,636 2,940,827 2,924,257 3,029,887 3,052,765 3,134,863 3,111,210 3,098,520 3,014,458 - 33,264,188 35,247,267 94% 0621 Sewer Department 641- 1,261 - - - 1,191 - 23,915 - 1,502 - - 27,869 26,416 105% 0625 Concrete Crew 641- 3,040 - - - - - 33,569 - - - - 36,610 74,500 49% 0630 Wastewater Operations 641- - - - - - - 11,132 - - - - 11,132 11,132 100% 0631 Organic Resources 641- - - - - - - 26,220 - - - - 26,220 26,220 100% 0650 Clay Sewage 641 177,865 174,732 185,177 179,053 184,419 191,141 188,087 193,939 187,143 189,761 184,131 - 2,035,446 2,162,160 94% Sewage Capital 642 5,472 404,555 5,255 444,486 502,267 508,096 508,114 508,122 506,095 503,426 506,110 - 4,401,999 4,894,000 90% Sewage Reserve 643 3,481 3,535 520,820 2,021 1,972 6,676 6,560 6,337 4,640 2,515 4,405 - 562,960 561,755 100% Sewage Bond Sinking 649 763,195 1,184 1,526,979 763,848 764,229 768,253 768,214 768,750 767,847 765,892 768,883 - 8,427,272 9,190,024 92% Sewage Works DS Reserve 653- 955 1,176 1,189 1,579 1,877 2,174 2,423 2,869 3,033 3,006 - 20,282 15,000 135% 2011 Sewer Bond 659 41 39 45 22 7 0 0 0 0 0 0 - 155 201 77% 2012 Sewer Bond 661 2,379 2,201 2,530 1,144 984 3,053 2,666 2,176 958 505 607 - 19,204 50,000 38% Sub Total 4,052,047 3,613,922 5,241,923 4,386,109 4,433,084 4,567,716 4,583,529 4,766,131 4,635,809 4,618,854 4,536,898 - 49,436,022 52,891,099 93% 2017-11 Financial Report - Rev enue Summar y Page 7 of 25 City of South Bend Period Ending:November 30, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Public Safety - Police Police Seizures 216 10,276 3,136 200 127 1,986 300 297 287 25,051 116 3,903 - 45,679 37,000 123% Curfew Violations 218 9 35 24 5 17 54 54 28 22 6 23 - 277 1,000 28% Law Enforcement Education 220 31,608 16,002 30,754 31,643 18,459 16,970 17,860 30,427 14,125 20,150 28,167 - 256,164 246,175 104% Public Safety LOIT 249 622,980 622,745 623,084 622,832 622,663 623,768 623,678 623,559 623,187 622,735 622,942 - 6,854,174 7,478,618 92% Police Take Home Vehicle 278 561 575 660 315 288 977 1,521 1,250 922 610 889 - 8,568 8,360 102% Police Block Grant 280 3 3 3 2 1 5 5 5 4 2 3 - 36 50 72% Police Academy 294 5,456 4,561 2,023 886 2,483 288 111 105 77 3,141 273 - 19,404 22,980 84% COPS More Grants 295 1,055 36,332 946 1,029 10,378 1,054 1,011 991 946 1,108 19,254 - 74,102 123,500 60% Drug Enforcement 299 149 162 148 166 161 168 182 23,201 (20,971) 218 50,184 - 53,768 63,000 85% K-9 Unit 705 2 2 3 1 1 4 4 4 3 1 2 - 26 2,036 1% Sub Total 672,099 683,553 657,845 657,005 656,439 643,588 644,721 679,857 643,364 648,088 725,641 - 7,312,200 7,982,719 92% Public Safety - Fire EMS Capital 287 2,726 1,801,174 3,021 2,108 1,927 6,015 5,158 1,416,814 3,510 2,252 3,798 - 3,248,505 4,529,349 72% EMS Operating Fund 288 181,987 557,555 483,650 374,307 372,922 650,471 413,058 564,862 473,638 522,004 521,840 - 5,116,295 6,385,015 80% Hazmat 289 19 20 23 11 10 30 28 3,087 22 12 21 - 3,284 10,250 32% River Rescue 291 114 16,307 12,724 1,869 23,462 10,989 3,211 186 128 4,260 1,301 - 74,549 69,400 107% Sub Total 184,846 2,375,057 499,419 378,295 398,322 667,505 421,455 1,984,949 477,298 528,528 526,960 - 8,442,633 10,994,014 77% Department of Community Investment Studebaker/Oliver 209 25,242 626 34,113 56,725 9,707 1,070 28,801 131,345 34,453 13,383 27,313 - 362,779 425,787 85% State Grant 210 242 268 18,311 148 135 18,459 455 3,130 319 18,176 302 - 59,943 262,141 23% DCI Operating 211 10,748 394,129 39,598 398,624 8,536 13,387 8,822 58,823 392,519 10,494 307,638 - 1,643,318 2,294,524 72% 0000 Dept. of Community Investment 212 310,284 201,138 42,852 164,474 83,939 357,952 31,360 49,702 229,167 58,202 711,123 - 2,240,194 5,574,676 40% xxx Programs 212 93,743 - - - - - - 116,141 - - 12,466 - 222,350 - NA 0000 Economic Revenue Bond 281 21 21 24 12 11 36 35 34 25 14 24 - 256 300 85% xxx xxx xxx NA Sub Total 440,280 596,182 134,898 619,981 102,326 390,903 69,474 359,175 656,484 100,269 1,058,867 - 4,528,839 8,557,428 53% Parking Garages 0000 Parking Garage Revenue 601 284 671 1,020 40 - - 108 361 - - - - 2,483 9,100 27% 0460 Main Street 601 25,906 27,933 28,062 26,202 64,761 21,525 22,907 40,399 24,541 31,901 35,392 - 349,528 306,516 114% 0462 Leighton Plaza 601 58,466 24,331 25,191 82,032 58,385 19,301 73,829 49,105 24,549 59,425 33,285 - 507,897 497,484 102% 0463 Enforcement 601 4,969 4,623 7,202 3,586 4,680 6,223 10,585 6,212 5,234 5,899 6,799 - 66,013 91,000 73% 0464 Wayne Street 601 30,977 20,895 29,889 11,565 12,333 24,967 19,680 29,994 16,625 22,711 21,289 - 240,925 243,261 99% 0465 Eddy Street Commons 601- - - - - - - - - - - - - 15,900 0% Sub Total 120,601 78,453 91,364 123,425 140,159 72,016 127,108 126,071 70,949 119,935 96,765 - 1,166,845 1,163,261 100% Capital / Debt Service Hall of Fame 313 50 6 23 8 10 474,777 12 14 77 18 18 - 475,013 894,300 53% COIT 404 913,313 879,279 1,163,973 920,266 874,964 886,807 916,204 883,875 947,994 914,931 878,940 - 10,180,546 11,063,418 92% Cum Capital Development 406 357 436 410 184 169 259,526 492 674 395 201 353 - 263,196 485,600 54% Cum Capital Improvement 407 150,266 294 301 144 132 117,143 25,562 567 270 147 258 - 295,083 437,000 68% EDIT 408 1,041,459 1,981,678 877,267 871,706 870,753 882,446 882,180 882,560 878,800 873,124 877,262 - 10,919,235 11,794,400 93% UDAG 410 445 416 493 235 207 689 677 629 451 245 411 - 4,898 6,110 80% Major Moves 412 1,774 598,393 2,312 1,238 1,135 3,844 3,780 249,486 188,822 1,380 2,519 - 1,054,682 1,056,786 100% Morris PAC Improvement 416 436 12,664 13,666 11,585 5,797 3,677 5,090 2,616 1,165 4,958 2,885 - 64,539 106,500 61% Palais Historic Preservation 450 1,907 187 428 429 683 1,534 2,596 2,937 1,708 1,898 1,597 - 15,905 17,500 91% Hall of Fame Capital 677 372 378 431 200 182 612 598 576 420 226 393 - 4,387 5,000 88% SB Building Corp 755- 1,326,786 210 65 117 169 191 1,323,992 754 333 330 - 2,652,947 2,654,500 100% Parks Bond Debt Svc 757- 65,162 124 65,236 80 64,086 138 32,152 31,927 31,815 63,559 - 354,281 391,482 90% Eddy St. Commons Debt 760- - - - - - - - 2,500,000 233 411 - 2,500,644 2,500,700 100% xxx xxx xxx Sub Total 2,110,380 4,865,679 2,059,637 1,871,297 1,754,228 2,695,308 1,837,521 3,380,078 4,552,784 1,829,510 1,828,935 - 28,785,356 31,413,296 92% 2017-11 Financial Report - Rev enue Summar y Page 8 of 25 City of South Bend Period Ending:November 30, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Other Miscellaneous Rainy Day 102 7,644 7,773 8,937 4,262 3,906 13,232 13,013 12,585 9,225 5,005 8,776 - 94,359 90,000 105% Gift, Donation, Bequest 217 50,900 1,097 69,994 5,639 220 51,058 513 1,726 885 1,153 675 - 183,860 214,094 86% Unsafe Building 219 11,928 152,225 26,129 160,537 14,230 18,670 16,684 22,297 163,559 13,846 32,182 - 632,287 884,475 71% Landlord Registration 221 2,260 270 1,245 155 60 25 20 5 865 1,655 880 - 7,440 7,000 106% Loss Recovery 227 730 741 851 404 368 1,244 1,217 1,176 793 418 733 - 8,674 9,000 96% LOIT 2016 Special Distribution 257- 6,605 156,406 1,646 1,183 56,449 3,846 103,670 58,430 1,475 2,455 - 392,164 1,623,397 24% Human Rights 258 91,498 4,790 5,975 2,576 356 600 39,798 689 413 218 374 - 147,286 258,740 57% Morris Palais Marketing 273 34 582 1,132 577 947 3,950 58 60 1,532 744 1,243 - 10,858 18,450 59% IT / Innovation /311 Call Center 279 430,621 430,621 430,621 430,621 430,621 430,621 430,621 430,621 430,621 430,621 430,621 - 4,736,831 5,205,034 91% Professional Sports Development 377 80,547 318 115,357 24,107 23,146 214 14,680 213 - - - - 258,581 734,325 35% 1201 Code Enforcement 600 12,749 366,188 37,109 380,781 6,482 53,138 29,672 11,774 393,616 13,627 53,207 - 1,358,343 1,863,717 73% 1207 Animal Control 600 4,706 187,306 6,015 188,107 6,975 6,368 7,095 6,521 190,313 7,286 6,057 - 616,747 798,835 77% 1306 Building Operations 600 92,341 88,523 111,064 97,168 142,392 199,102 112,431 177,174 126,756 126,481 110,861 - 1,384,292 1,398,154 99% Century Center 670 910,931 211,677 (225,009) 400,425 412,693 311,339 412,822 379,895 354,384 371,908 382,813 - 3,923,877 4,228,683 93% Century Center Capital 671 74 66 74 71 74 71 74 74 71 74 71 - 793 750 106% Century Center Energy Saving 672 6 4 4 4 4 4 55,520 82,171 4 4 55,395 - 193,121 192,297 100% xxx xxx xxx NA Sub Total 1,696,966 1,458,786 745,904 1,697,080 1,043,657 1,146,084 1,138,062 1,230,651 1,731,467 974,514 1,086,342 - 13,949,512 17,526,951 80% Business Insurance 0000 Business Insurance Revenues 226 246,679 247,476 245,267 248,740 243,026 253,098 246,803 246,533 244,966 254,535 287,222 - 2,764,344 3,539,591 78% 0403 Self Funded Liability Ins 226- - - - - - - - - - - - - - NA 0412 Liability Insurance 226- - - - - - - - - - - - - - NA 0417 Business Insurance 226- - - - - - - - - - - - - - NA 0418 Workers Compensation 226 619 35,123 - - - 900 - - - - - - 36,642 36,643 100% xxx xxx xxx NA Sub Total 247,298 282,599 245,267 248,740 243,026 253,998 246,803 246,533 244,966 254,535 287,222 - 2,800,986 3,576,234 78% Fiduciary Trust & Agency Fire Pension 701 335 84 - - - 2,461,856 - 292 2,458,856 - 3,238 - 4,924,661 4,925,212 100% Police Pension 702 2,386 1,224 5,915 565 595 3,108,612 290 1,049 3,100,921 12 2,089 - 6,223,659 6,223,679 100% Employee Benefits 711 1,511,154 1,463,664 1,500,195 1,490,799 1,481,130 1,495,193 1,527,856 1,560,739 1,488,470 1,469,820 1,468,292 - 16,457,311 17,892,659 92% Unemployment Comp 713 217 214 244 114 102 339 329 310 221 118 204 - 2,412 2,800 86% City Cemetery Trust 730 22 22 25 12 11 37 37 36 26 14 25 - 267 280 95% Equipment / Vehicle Leasing 750- 298 375 223 2,916,712 532 161,897 (160,372) 1,632,769 766 939 - 4,554,140 5,502,900 83% Parks Bond Capital 751- 369 539 485 517 632 652 624 637 588 1,457 - 6,499 7,500 87% Smart Street Bond Capital 753- 604 663 544 545 606 561 42,305 22,038 (19,750) 20,185 - 68,300 58,880 116% Eddy St. Commons Capital 759- - - - - - - - 22,500,000 - - - 22,500,000 22,500,000 100% xxx xxx xxx NA Sub Total 1,514,115 1,466,478 1,507,957 1,492,742 4,399,611 7,067,807 1,691,621 1,444,982 31,203,938 1,451,568 1,496,429 - 54,737,249 57,113,910 96% Civil City Revenues 15,432,926 22,115,337 17,328,250 17,107,703 17,863,212 51,243,156 16,079,811 20,058,449 51,967,048 16,104,158 16,342,229 - 261,642,278 320,177,805 82% Tax Increment Financing TIF River West - Airport 324 78,976 118,077 87,148 235,509 71,358 9,426,694 42,749 47,660 600,265 212,113 25,254 - 10,945,803 19,689,389 56% TIF West Washington 422 1,411 1,497 1,721 821 751 200,696 2,595 2,664 1,952 1,054 1,799 - 216,960 442,000 49% TIF Leighton Plaza 425 10,467 14,196 10,498 8,768 8,762 8,914 9,074 10,331 7,249 3,553 11,558 - 103,368 197,014 52% TIF River East DEV (NE)429 5,927 6,699 11,342 3,606 3,279 1,437,646 9,487 161,939 7,377 3,955 6,817 - 1,658,075 3,236,467 51% TIF Southside 430 3,108 564,649 4,388 906,618 2,039 1,224,439 7,953 9,233 6,328 3,426 5,954 - 2,738,134 3,916,127 70% TIF Erskine Village 432 3,646 3,484 791 378 219 1 1 - - - - - 8,519 8,520 100% TIF Douglas Road 435 77 120 95 3 3 218,289 111 277 36 20 34 - 219,064 328,208 67% TIF River East RES (NE RE)436 442 - - - - 2,320,321 - - - - - - 2,320,763 3,300,903 70% Sub Total 104,055 708,721 115,983 1,155,702 86,411 14,837,000 71,969 232,103 623,207 224,120 51,416 - 18,210,686 31,118,628 59% 2017-11 Financial Report - Rev enue Summar y Page 9 of 25 City of South Bend Period Ending:November 30, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Redevelopment Funds Administration 433 6 6 7 4 3 10 9 9 7 4 6 - 72 135 53% Certified Technology Park 439 1,614 1,641 1,887 900 825 1,064 456 253,066 397 299 523 - 262,671 302,625 87% Airport Urban Enterprise Zone 454 288 292 336 160 147 498 489 473 347 188 330 - 3,550 3,900 91% Industrial Revolving 754- - 21,526 9,673 14,952 12,238 7,388 7,961 - 51,814 - - 125,552 223,824 56% Sub Total 1,908 1,940 23,757 10,737 15,927 13,810 8,342 261,509 750 52,304 860 - 391,845 530,484 74% Debt Service Airport Debt Reserve 2003 315 780 792 902 434 398 1,346 1,323 1,278 935 507 888 - 9,582 14,000 68% Coveleski Bond Debt Reserve 317 385 391 450 214 197 666 655 633 464 252 442 - 4,748 5,000 95% Central Development reserve 328 1,303 1,323 1,522 725 664 2,249 2,210 2,135 1,563 847 1,484 - 16,025 20,000 80% SB Redevelopment Authority 752- 772,669 1,236,763 395 197,726 305 195 1,484,222 400 682 196,765 - 3,890,122 3,868,669 101% Smart Streets Debt Svc 756- 179 263 197 218 277 291 856,782 381 329 282 - 859,200 857,284 100% Erskine Village Debt. Svc 758- 3,961,697 82 1 - - - - - - - - 3,961,781 3,961,782 100% Sub Total 2,468 4,737,051 1,239,982 1,967 199,202 4,843 4,673 2,345,050 3,743 2,617 199,861 - 8,741,457 8,726,735 100% Redevelopment Commission 108,431 5,447,712 1,379,721 1,168,406 301,541 14,855,652 84,984 2,838,662 627,701 279,042 252,137 - 27,343,989 40,375,847 68% City Operations Total 15,541,357 27,563,049 18,707,971 18,276,109 18,164,753 66,098,808 16,164,795 22,897,112 52,594,748 16,383,200 16,594,366 - 288,986,267 360,553,652 80% Revenue report 15,541,356 27,563,049 18,707,971 18,276,109 18,164,753 66,098,808 16,164,795 22,897,112 52,594,748 16,383,200 16,594,366 0 288,986,267 360,553,652 0 0 0 0(0)0 0 0 0 0(0)0(0)0 2017-11 Financial Report - Rev enue Summar y Page 10 of 25 City of South Bend Period Ending:November 30, 2017 Property Tax Revenue 2016 Tax Pay 2017 Fund Fund #Levy Estimated Distribution 1 Distribution 2 Distribution 3 Distribution 4 Levy Per County Collection Projected 6/20/2017 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate City General Fund 101 40,248,867.00 0.95 38,236,423.65 21,820,142.51 - - - 21,820,142.51 18,428,724.49 54.21% Parks & Recreation 201 9,179,442.00 0.95 8,720,469.90 4,976,456.29 - - - 4,976,456.29 4,202,985.71 54.21% College Football Hall of Fame 313 833,277.00 0.95 791,613.15 451,820.36 - - - 451,820.36 381,456.64 54.22% Cumulative Capital District 406 443,869.00 0.95 421,675.55 240,635.07 - - - 240,635.07 203,233.93 54.21% Total - City 50,705,455.00 48,170,182.25 27,489,054.23 - - - 27,489,054.23 23,216,400.77 54.21% Tax Increment Financing Airport TIF District 324 18,698,946.24 0.95 17,763,998.93 8,932,881.19 - - - 8,932,881.19 9,766,065.05 47.77% West Washington TIF District 422 367,557.18 0.95 349,179.32 198,151.66 - - - 198,151.66 169,405.52 53.91% Northeast Residential TIF District 436 4,405,723.00 0.95 4,185,436.85 2,320,321.06 - - - 2,320,321.06 2,085,401.94 52.67% Southside TIF District #1 430 2,390,790.99 0.95 2,271,251.44 1,216,823.61 - - - 1,216,823.61 1,173,967.38 50.90% Douglas Road TIF District 435 321,949.68 0.95 305,852.20 218,279.99 - - - 218,279.99 103,669.69 67.80% Northeast TIF 429 2,766,113.25 0.95 2,627,807.59 1,428,045.99 - - - 1,428,045.99 1,338,067.26 51.63% Total - Tax Increment Financing 28,951,080.34 27,503,526.32 14,314,503.50 - - - 14,314,503.50 14,636,576.84 49.44% Grand Total 79,656,535.34 75,673,708.57 41,803,557.73 - - - 41,803,557.73 37,852,977.61 52.48% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 6/20/17 2017-11 Financial Report - Property Tax Revenue Page 11 of 25 City of South Bend Period Ending:November 30, 2017 Property Tax Revenue 2015 Tax Pay 2016 Fund Fund #Levy Estimated Distribution 1 Distribution 2 Distribution 3 Distribution 4 Levy Per County Collection Projected 6/14/2016 12/20/2016 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate City General Fund 101 40,360,212.00 0.95 38,342,201.40 21,490,881.50 17,871,257.85 - - 39,362,139.35 998,072.65 97.53% Parks & Recreation 201 8,090,885.00 0.95 7,686,340.75 4,312,625.82 3,590,369.07 - - 7,902,994.89 187,890.11 97.68% College Football Hall of Fame 313 1,396,308.00 0.95 1,326,492.60 744,229.93 617,281.74 - - 1,361,511.67 34,796.33 97.51% Cumulative Capital District 406 451,368.00 0.95 428,799.60 240,589.67 200,296.91 - - 440,886.58 10,481.42 97.68% Total - City 50,298,773.00 47,783,834.35 26,788,326.92 22,279,205.57 - - 49,067,532.49 1,231,240.51 97.55% Tax Increment Financing Airport TIF District 324 19,123,985.00 0.95 18,167,785.75 9,769,452.30 8,389,858.48 - - 18,159,310.78 964,674.22 94.96% West Washington TIF District 422 516,171.00 0.95 490,362.45 282,809.66 170,692.93 - - 453,502.59 62,668.41 87.86% Northeast Residential TIF District 436 3,913,816.00 0.95 3,718,125.20 2,061,402.42 1,871,544.98 - - 3,932,947.40 (19,131.40) 100.49% Southside TIF District #1 430 2,481,892.00 0.95 2,357,797.40 1,251,613.66 1,149,638.01 - - 2,401,251.67 80,640.33 96.75% Douglas Road TIF District 435 337,099.00 0.95 320,244.05 231,288.93 113,972.95 - - 345,261.88 (8,162.88) 102.42% Northeast TIF 429 2,586,566.00 0.95 2,457,237.70 1,170,979.07 1,177,628.87 - - 2,348,607.94 237,958.06 90.80% Total - Tax Increment Financing 28,959,529.00 27,511,552.55 14,767,546.04 12,873,336.22 - - 27,640,882.26 1,318,646.74 95.45% Grand Total 79,258,302.00 75,295,386.90 41,555,872.96 35,152,541.79 - - 76,708,414.75 2,549,887.25 96.78% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 6/14/16 Distribution 2 - Issued by St. Joseph County on 12/20/16 2017-11 Financial Report - Property Tax Revenue Page 12 of 25 City of South Bend Period Ending:November 30, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget General Government 0101 Mayor 101 59,009 57,926 57,827 61,110 54,678 84,839 65,163 76,317 72,597 78,827 72,777 - 741,070 872,923 85% 0201 Clerk 101 38,451 43,206 31,600 35,638 35,273 46,995 33,861 36,722 39,439 40,750 36,791 - 418,726 536,216 78% 0301 Common Council 101 33,451 49,728 27,207 50,580 28,885 34,287 33,776 38,408 39,952 33,663 29,997 - 399,933 571,148 70% 0302 WNIT Contract 101- - - - 43,000 - - - - - - - 43,000 43,000 100% 0401 Administration and Finance 101 184,278 178,933 181,407 203,805 206,704 261,723 192,964 189,599 187,406 197,229 182,464 - 2,166,511 2,476,351 87% 0501 Legal Department 101 87,585 86,783 87,565 116,630 75,744 109,460 80,722 95,963 75,203 69,972 74,044 - 959,670 1,158,567 83% Sub Total 402,773 416,575 385,606 467,764 444,284 537,304 406,485 437,008 414,597 420,441 396,073 - 4,728,910 5,658,205 84% Public Works 0602 Engineering 101 81,736 88,219 89,641 89,644 103,226 120,430 96,986 98,261 109,104 97,783 105,317 - 1,080,345 1,485,157 73% Sub Total 81,736 88,219 89,641 89,644 103,226 120,430 96,986 98,261 109,104 97,783 105,317 - 1,080,345 1,485,157 73% Public Safety 0801 Police 101 2,401,801 2,081,566 2,099,258 2,016,036 2,087,143 2,837,886 2,194,381 2,006,824 2,131,759 2,294,848 2,213,274 - 24,364,777 29,668,433 82% 0901 Fire 101 1,586,894 1,525,036 1,582,606 1,554,060 1,604,395 2,215,029 1,508,966 1,445,712 1,524,297 1,741,647 1,644,661 - 17,933,303 21,111,466 85% Sub Total 3,988,695 3,606,602 3,681,864 3,570,096 3,691,539 5,052,914 3,703,347 3,452,537 3,656,056 4,036,494 3,857,936 - 42,298,080 50,779,899 83% Arts & Culture 0404 Morris PAC 101 74,731 80,199 47,613 60,412 60,629 72,212 60,726 61,783 58,942 234,731 60,870 - 872,849 1,271,039 69% 0405 Palais Royale 101 24,999 30,061 10,824 17,021 18,169 22,340 17,757 19,406 19,179 86,714 17,934 - 284,404 530,200 54% Sub Total 99,730 110,260 58,436 77,434 78,798 94,553 78,483 81,189 78,122 321,444 78,804 - 1,157,253 1,801,239 64% Human Rights 1008 Human Rights 101 37,821 40,148 32,484 37,408 31,913 34,695 29,063 35,285 29,894 29,160 28,886 - 366,757 425,805 86% Sub Total 37,821 40,148 32,484 37,408 31,913 34,695 29,063 35,285 29,894 29,160 28,886 - 366,757 425,805 86% General Fund Expenditure Total 4,610,756 4,261,804 4,248,032 4,242,346 4,349,760 5,839,896 4,314,364 4,104,281 4,287,772 4,905,322 4,467,015 - 49,631,346 60,150,305 83% 2017-11 Financial Report - Expe nditu re Su mmary Page 13 of 25 City of South Bend Period Ending:November 30, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Parks & Recreation 1100 Administration 201 147,654 87,876 110,868 112,743 118,476 128,067 111,926 111,828 113,095 114,622 120,586 - 1,277,741 1,468,296 87% 1101 Maintenance 201 399,021 416,933 423,013 569,543 553,920 672,696 511,411 561,135 453,106 658,697 474,830 - 5,694,304 6,914,308 82% 1102 Golf Operations 201 54,483 75,381 77,362 180,384 131,801 173,015 147,904 146,830 134,209 108,194 89,267 - 1,318,830 1,669,575 79% 1103 Recreation Division 201 165,251 145,109 133,502 139,866 147,123 241,949 247,358 212,855 135,982 133,540 134,215 - 1,836,749 2,153,817 85% 1104 Potawatomi Zoo 201 355,692 7,425 7,231 7,208 289,717 8,923 6,660 6,601 5,369 (4,949) 7,046 - 696,922 715,964 97% 1106 Potawatomi Greenhouse 201 5,013 4,555 2,550 2,375 1,198 15,764 411 408 566 665 1,482 - 34,987 54,408 64% 1108 Graffiti Removal 201 13,483 12,628 11,465 10,265 8,529 10,420 7,557 7,946 (6,469) 7,915 8,221 - 91,961 112,932 81% 1110 Marketing and Events 201 16,583 45,412 58,810 61,326 60,810 83,508 58,196 67,592 57,881 73,844 71,812 - 655,773 953,588 69% 1111 Regional Cities Grant 201- - - - - - - - - 149,910 45,150 - 195,060 5,000,000 4% Recreation Non Reverting 203 51,478 47,722 45,821 94,361 71,392 92,875 159,108 155,475 75,309 70,450 48,875 - 912,865 1,599,683 57% East Race Waterway 271- - - - - - 1,353 - - - - - 1,353 1,367 99% Coveleski Stadium 401- - - 8,542 4,569 - 1,778 1,136 975 61,597 - - 78,597 30,000 262% Zoo Endowment 403- - - 53,599 - (3,549) - - - - - - 50,049 50,050 100% Park Non Reverting 405 45,874 17,251 22,621 42,193 16,930 71,879 61,868 19,760 120,486 (22,800) (3,610) - 392,451 553,024 71% Sub Total 1,254,532 860,290 893,243 1,282,404 1,404,465 1,495,546 1,315,529 1,291,565 1,090,510 1,351,684 997,874 - 13,237,641 21,277,012 62% Public Works Motor Vehicle Highway 202 919,033 515,568 547,694 523,276 541,787 631,705 634,583 681,127 817,893 636,586 574,716 - 7,023,968 9,886,533 71% Curb and Sidewalk 202 150,920 40,047 37,646 38,164 143,273 121,813 209,102 113,133 54,706 181,909 55,291 - 1,146,004 1,878,998 61% Central Services 222 730,352 648,645 561,962 613,240 672,069 593,479 531,551 706,728 844,083 630,259 572,004 - 7,104,373 8,564,643 83% Central Services Capital 224 10,575 4,009 - 16,964 - 11,786 - 16,597 114,180 25,071 - - 199,182 326,025 61% Local Roads & Streets 251 209,999 4,801 3,018 35,678 92,276 81,399 305,836 166,252 2,321 146,800 - - 1,048,379 2,308,544 45% Local Roads & Bridge 265- - - - - - 64 - - 1,400 465,271 - 466,735 2,000,000 23% Project ReLeaf 655 15,049 90,567 3,684 115,917 3,108 3,165 14,951 3,270 100,821 28,300 15,093 - 393,924 537,171 73% Sub Total 2,035,929 1,303,638 1,154,005 1,343,240 1,452,512 1,443,345 1,696,086 1,687,108 1,934,004 1,650,324 1,682,375 - 17,382,565 25,501,914 68% Public Works Solid Waste Solid Waste Operations 610 489,623 312,159 388,501 385,830 347,815 685,660 407,427 582,186 353,087 425,165 302,144 - 4,679,599 5,662,910 83% Solid Waste Capital 611 286,902 146,712 218 83,859 20,129 219 286,862 146,712 259 83,924 19,921 - 1,075,715 1,135,613 95% Sub Total 776,525 458,871 388,720 469,689 367,944 685,879 694,289 728,898 353,346 509,089 322,065 - 5,755,313 6,798,523 85% Public Works Water Utility 0630 Water Leak Insurance 620 43,958 41,864 50,876 46,504 58,900 71,053 44,809 145,869 99,045 70,498 30,040 - 703,416 1,035,000 68% 0640 Water Works 620 1,417,876 1,256,524 1,085,407 1,142,917 1,117,427 1,222,741 987,180 1,504,301 1,136,327 1,211,390 1,175,952 - 13,258,042 16,688,754 79% 0660 Clay Water 620- - (0) 169 37 5 26 13 14 2 14 - 280 3,500 8% Waterworks Capital 622 111,938 177,777 13,775 9,295 8,299 17,201 58,155 8,110 - 2 92,118 - 496,670 1,414,466 35% Waterworks Deposit 624 874 1,174 1,347 639 583 1,965 1,923 1,851 1,352 733 1,287 - 13,729 15,000 92% Waterworks Sinking 625 815 289 321 211 266 255,311 52,101 1,373 811 522 1,100 - 313,119 2,054,891 15% Waterworks Bond Reserve 626- - - - - 10,000 - - - - 6,000 - 16,000 16,000 100% Waterworks Debt Reserve 629 1,394 1,895 2,292 1,092 1,000 3,386 3,328 3,214 2,354 1,276 2,235 - 23,465 23,000 102% Sub Total 1,576,855 1,479,523 1,154,018 1,200,827 1,186,511 1,581,662 1,147,523 1,664,732 1,239,903 1,284,422 1,308,746 - 14,824,721 21,250,611 70% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 48,400 46,390 29,841 52,988 63,829 41,714 55,751 28,271 35,884 43,442 33,097 - 479,607 634,509 76% 0621 Sewer Repair 641 517,647 434,598 385,613 579,850 349,846 452,561 422,426 441,576 375,871 1,430,923 333,355 - 5,724,265 9,548,100 60% 0625 Concrete Crew 641 30,239 20,767 19,975 30,713 26,000 34,774 27,113 25,357 22,159 24,865 24,861 - 286,822 474,389 60% 0630 Wastewater Operations 641 2,358,990 1,454,679 3,260,858 2,528,275 2,582,015 2,554,148 2,645,651 2,822,548 2,378,990 2,660,466 2,536,665 - 27,783,285 33,198,000 84% 0631 Organic Resources 641 124,773 126,931 80,689 53,682 214,126 78,314 116,920 145,157 68,948 101,374 108,961 - 1,219,874 1,608,946 76% 0650 Clay Sewage 641- 5 26 50 431 - 181 73 9 - 106 - 880 1,750 50% Sewage Capital 642 1,298,328 387,989 178,442 93,243 530,257 335,486 139,256 298,108 286,199 402,622 267,590 - 4,217,520 8,051,255 52% Sewage Reserve 643 2,625 3,535 4,065 2,021 1,972 6,676 6,560 6,337 4,640 2,515 4,405 - 45,349 30,000 151% Sewage Bond Sinking 649 1,000 500 - - 830,476 249,650 - - - - 8,077,055 - 9,158,681 9,163,754 100% 2011 Sewer Bond 659- - - 51,687 - - - - - - - - 51,687 51,888 100% 2012 Sewer Bond 661 3,000 166,950 113,521 180,305 269,318 115,454 988,844 - 190,669 235,348 - - 2,263,409 3,010,364 75% Sub Total 4,385,001 2,642,343 4,073,031 3,572,814 4,868,271 3,868,777 4,402,703 3,767,427 3,363,367 4,901,553 11,386,094 - 51,231,381 65,772,955 78% 2017-11 Financial Report - Expe nditu re Su mmary Page 14 of 25 City of South Bend Period Ending:November 30, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Public Safety - Police Police Seizures 216- - - - - - - - - - 5,868 - 5,868 116,000 5% Curfew Violations 218- - - - - - - - - - - - - 1,000 0% Law Enforcement Education 220 44,630 19,978 197,939 29,048 26,375 24,885 22,590 25,405 16,652 59,013 27,063 - 493,580 788,422 63% Emergency Telephone System 244- - - 4,708 - - - 28,963 (0) - - - 33,671 33,671 100% Public Safety LOIT 249 466,245 487,781 613,087 598,935 610,756 918,862 621,159 628,089 620,854 518,805 537,099 - 6,621,673 7,462,645 89% Excess Welfare Public Safety 252- - - - - - - - - - 8 - 8 8 101% LOIT 2016 Special Distribution 257 21,360 21,991 1,050,366 38,621 39,807 69,470 81,018 26,739 20,191 331,499 387,600 - 2,088,661 3,757,457 56% Police Take Home Vehicle 278- 972 - (60) (120) (260) 340 100 - - 6,570 - 7,541 10,000 75% Police Grants 292 2,796 1,266 1,330 90 106 - - 21,735 630 226 - - 28,178 35,805 79% Police Academy 294 162 283 692 909 515 3,776 179 249 523 254 1,039 - 8,581 22,500 38% COPS More Grants 295 10,980 3,436 108,583 11,664 915 240 347 - 180 19,534 960 - 156,839 263,767 59% Drug Enforcement 299 11,242 23,096 13,200 - - 3,172 - - 19,000 79,491 - - 149,201 286,337 52% K-9 Unit 705- - - - - - - - - - - - - 2,020 0% Sub Total 557,416 558,803 1,985,195 683,915 678,354 1,020,145 725,633 731,281 678,029 1,008,821 966,207 - 9,593,799 12,779,632 75% Public Safety - Fire EMS Capital 287 235,792 150,604 - 386,321 136,287 547,964 290,622 431,636 177,672 138,888 63,102 - 2,558,888 3,991,466 64% EMS Operating Fund 288 438,601 356,431 401,753 451,805 437,873 602,509 371,814 451,602 452,361 392,910 420,077 - 4,777,734 6,137,914 78% Hazmat 289 430 255 - - 4,057 - - 200 826 - - - 5,768 10,431 55% River Rescue 291 1,443 231 231 23,817 10,419 21,299 9,052 15,613 11,629 981 231 - 94,945 117,349 81% xxx xxx xxx Sub Total 676,266 507,520 401,984 861,943 588,636 1,171,772 671,488 899,050 642,487 532,779 483,410 - 7,437,334 10,257,160 73% Department of Community Investment Studebaker/Oliver 209 70,702 4,592 23,072 39,510 43,825 - 31,342 25,919 15,560 26,237 27,462 - 308,221 539,393 57% State Grant 210- - 18,003 - - 18,003 - - 18,003 - - - 54,008 509,757 11% DCI Operating 211 197,318 171,937 175,385 177,600 195,239 226,245 174,958 184,330 168,181 165,449 210,278 - 2,046,921 2,775,376 74% 1001 Dept. of Community Investment 212 575,173 100,654 21,621 163,348 164,147 146,738 77,983 126,737 105,551 343,006 445,027 - 2,269,984 5,455,838 42% 1003 Administration 212- - - - - - - - - - - - - - NA xxx Programs 212- - - - - - - - - - - - - - NA Sub Total 843,192 277,183 238,081 380,458 403,211 390,985 284,283 336,985 307,295 534,692 682,768 - 4,679,134 9,280,364 50% Parking Garages 0461 St. Joseph 601- - 604 - (604) - - - - - - - NA 0460 Main Street 601 10,017 11,799 1,749 75,944 10,787 28,308 3,500 28,758 (26,473) 26,398 5,054 - 175,842 261,894 67% 0462 Leighton Plaza 601 20,044 21,722 1,360 55,854 7,114 18,879 3,926 28,168 126,180 102,835 7,045 - 393,128 596,368 66% 0463 Enforcement 601 7,858 7,238 437 22,849 437 12,035 5,445 13,557 7,791 20,833 489 - 98,969 128,675 77% 0464 Wayne Street 601 12,364 13,889 936 32,097 5,591 20,718 1,558 21,801 29,321 28,921 3,025 - 170,222 244,417 70% 0465 Eddy Street Commons 601- - - 32 - 647 - 160 (840) - - - - 15,900 0% Sub Total 50,284 54,648 4,482 186,776 24,534 80,587 13,826 92,445 135,979 178,986 15,613 - 838,161 1,247,254 67% Capital / Debt Service Hall of Fame 313 635,000 - (3,265) - - - 633,000 - (121,315) 800 - - 1,144,220 1,268,999 90% COIT 404 1,172,640 1,270,520 840,369 1,585,347 13,821 530,881 881,651 450,575 1,889,332 1,134,105 430,827 - 10,200,068 12,071,593 84% Cum Capital Development 406 112,650 27,896 - - 149,081 - 112,650 27,896 - 10,711 (2,644) - 438,241 476,500 92% Cum Capital Improvement 407 185,125 - - - - - 187,125 - (1,000) 800 - - 372,050 372,250 100% EDIT 408 697,093 1,928,675 70,750 2,317,413 62,665 58,366 82,427 572,803 2,119,508 215,858 319,415 - 8,444,973 11,559,184 73% UDAG 410 30,702 - - 31,814 - - 31,814 - - 31,814 - - 126,142 126,144 100% Major Moves 412 543 - 62 - 910 - 274,046 142,171 - 93,796 721 - 512,248 2,470,708 21% Morris PAC Improvement 416 408 - 1,645 1,423 540 - 334 2,704 10,825 - 32,075 - 49,954 401,144 12% Palais Historic Preservation 450- - - - - - - 627 - - - - 627 5,000 13% Hall of Fame Capital 677 3,866 14,859 2,574 3,209 2,159 2,638 2,500 3,993 2,785 2,067 1,440 - 42,089 81,091 52% SB Building Corp 755- - 1,437,970 - - - 500 - 1,203,744 - 1,000 - 2,643,214 2,643,214 100% Parks Bond Debt 757- - 198,566 - - - - - 191,916 - - - 390,481 391,482 100% Eddy St. Commons Debt Svc.760- - - - - - - - - - - - - - NA xxx xxx xxx NA Sub Total 2,838,027 3,241,949 2,548,669 3,939,206 229,176 591,885 2,206,047 1,200,770 5,295,793 1,489,951 782,835 - 24,364,307 31,867,309 76% 2017-11 Financial Report - Expe nditu re Su mmary Page 15 of 25 City of South Bend Period Ending:November 30, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Other Miscellaneous Gift, Donation, Bequest 217 72,000 900 - 663 760 6,877 79,294 31,363 3,000 - 2,009 - 196,866 241,700 81% Unsafe Building 219 80,336 43,005 41,261 55,208 81,628 79,253 60,815 103,231 55,606 94,695 42,744 - 737,781 905,479 81% Landlord Registration 221 5 5 - - - - - - - - - - 10 1,000 1% Loss Recovery 227- 3,345 7,600 2,080 5,844 - - 102,343 - - 10,654 - 131,866 598,675 22% Human Rights 258 17,100 3,192 7,767 8,984 17,529 18,147 9,651 14,458 8,429 8,794 7,038 - 121,089 201,773 60% Morris Palais Marketing 273 2,798 - 878 - 1,998 - - - - - - - 5,673 21,675 26% IT / Innovation / 311 Call Center 279 325,330 207,081 205,525 260,505 495,245 278,491 182,978 249,728 181,011 558,378 255,363 - 3,199,634 5,205,034 61% Professional Sports Development 377 467,640 800 - - - - 359,515 - - - - - 827,955 827,955 100% 1201 Code Enforcement 600 128,453 94,686 101,457 110,099 112,811 146,364 122,698 114,832 113,507 138,485 137,318 - 1,320,709 1,613,201 82% 1207 Animal Control 600 68,101 59,652 58,318 65,964 68,163 74,484 66,442 65,853 63,349 66,287 60,895 - 717,508 810,517 89% 1306 Building Operations 600 110,343 98,842 97,813 101,286 98,111 129,067 111,279 102,136 109,926 95,273 96,557 - 1,150,633 1,361,925 84% Century Center 670 282,027 349,477 (15,339) 661,555 322,739 382,643 332,564 414,240 314,078 360,110 337,982 - 3,742,075 4,194,310 89% Century Center Capital 671- - - - - - - - - - 1,500 - 1,500 - NA Century Center Energy Saving 672- - - 95,128 - - - - - 96,169 - - 191,297 192,297 99% Sub Total 1,554,131 860,986 505,279 1,361,472 1,204,828 1,115,326 1,325,236 1,198,182 848,906 1,418,191 952,060 - 12,344,596 16,175,541 76% Business Insurance 0403 Self Funded Liability Ins 226 17,866 17,273 20,527 15,424 16,015 21,466 15,567 19,357 14,973 17,697 14,850 - 191,014 235,471 81% 0412 Liability Insurance 226 45,537 23,578 52,779 27,697 640,369 40,160 62,615 40,802 96,968 165,041 39,835 - 1,235,381 1,894,051 65% 0417 Business Insurance 226 45,354 - 21,392 120 21,404 - 386,775 25,962 19,855 - 6,529 - 527,391 735,678 72% 0418 Workers Compensation 226 119,520 87,561 54,191 240,566 58,672 52,655 93,757 23,199 18,944 19,313 34,354 - 802,733 722,386 111% Sub Total 228,276 128,412 148,890 283,807 736,460 114,282 558,713 109,320 150,740 202,052 95,568 - 2,756,519 3,587,586 77% Fiduciary Trust & Agency Fire Pension 701 388,455 396,509 396,201 394,300 390,847 376,476 382,196 380,446 380,376 378,976 376,627 - 4,241,408 5,098,269 83% Police Pension 702 513,053 511,187 523,297 519,926 517,885 505,354 507,705 507,885 507,795 507,795 506,830 - 5,628,711 6,423,889 88% Employee Benefits 711 1,060,085 1,343,141 951,392 1,174,621 1,102,064 1,726,172 1,277,628 1,631,987 1,049,110 1,206,650 1,243,538 - 13,766,389 17,803,200 77% Unemployment Comp 713 6,038 8,041 4,389 5,340 3,324 5,526 7,729 3,827 5,733 4,323 3,352 - 57,622 84,105 69% City Cemetery Trust 730- - - - - - - - 599 - - 599 6,000 10% Equipment / Vehicle Leasing 750- 983,042 489,584 65,756 135,750 128,509 - 501,098 23,547 912,178 237,624 - 3,477,088 5,500,000 63% Parks Bond Capital 751- 63,156 211,200 140,581 19,839 111,546 2,245 288,513 68,236 130,079 24,841 - 1,060,236 3,500,000 30% Smart Street Bond 753- 986,652 285,891 512,350 617,149 341,706 1,077,051 659,978 20,695 406,356 26,452 - 4,934,279 10,000,000 49% Eddy St. Commons Capital 759- - - - - - - - 396,250 - - - 396,250 - NA xxx xxx xxx NA Sub Total 1,967,632 4,291,727 2,861,954 2,812,874 2,786,859 3,195,289 3,254,554 3,973,734 2,451,740 3,546,955 2,419,264 - 33,562,582 48,415,463 69% Civil City Expenditure 23,354,822 20,927,696 20,605,582 22,621,770 20,281,521 22,595,375 22,610,274 21,785,777 22,779,871 23,514,820 26,561,893 - 247,639,400 334,361,629 74% Tax Increment Financing TIF River West - Airport 324 4,348,398 123,050 1,434,861 735,643 590,372 186,766 4,463,883 811,409 1,119,086 2,086,165 461,282 - 16,360,913 39,618,887 41% TIF West Washington 422- - 2,420 385 - - - - 65,778 4,008 - - 72,591 1,428,292 5% TIF Leighton Plaza 425 5,141 9,302 4,480 11,400 9,310 29,194 7,696 12,611 7,484 6,020 9,491 - 112,129 158,166 71% TIF River East DEV (NE)429 27,144 45,644 101,171 587,302 45,684 343,124 122,068 129,047 76,124 127,537 25,916 - 1,630,760 10,602,696 15% TIF Southside 430 146,124 12,530 17,419 24,812 100,639 6,683 - 10,774 33,396 52,826 47,895 - 453,098 6,917,426 7% TIF Erskine Village 432 3,961,667 - - 904,519 - - - 598 - - - - 4,866,784 4,878,795 100% TIF Douglas Road 435- 150,000 - - - - - 185,608 - 116 - - 335,724 344,216 98% TIF River East RES (NE RE)436 1,236,500 446,589 - - - - 1,234,500 60,446 186,218 2,331 500 - 3,167,084 3,430,231 92% Sub Total 9,724,973 787,115 1,560,351 2,264,061 746,005 565,766 5,828,146 1,210,493 1,488,086 2,279,003 545,084 - 26,999,083 67,378,709 40% 2017-11 Financial Report - Expe nditu re Su mmary Page 16 of 25 City of South Bend Period Ending:November 30, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Redevelopment Funds Administration 433- - - 816 316 - - - - - - - 1,133 4,500 25% Certified Technology Park 439- - - 1,800,000 - - - - - - 1,800,000 2,200,000 82% Airport Urban Enterprise Zone 454- - - - - - - - - - - - - 50,000 0% Industrial Revolving 754- - 14,437 16,553 775 17,679 775 10,814 - 24,153 - - 85,186 157,000 54% Sub Total- - 14,437 17,369 1,801,091 17,679 775 10,814 - 24,153 - - 1,886,319 2,411,500 78% Debt Service Airport Debt Reserve 2003 315 588 792 902 434 398 1,346 1,323 1,278 935 507 888 - 9,390 14,000 67% Central Development reserve 328 983 1,323 1,522 725 664 2,249 2,210 2,135 1,563 847 1,484 - 15,705 15,000 105% SB Redevelopment Authority 752- 735,236 2,004,503 5 - 345,906 - - 1,475,853 - - - 4,561,503 4,603,405 99% Smart Streets Debt Svc 756- - 394,784 - - - - - 854,784 - - - 1,249,569 1,252,284 100% Erskine Village Debt Svc 758- 561,229 3,961,668 1 - - - - - - - - 4,522,898 4,522,918 100% xxx xxx xxx NA Sub Total 1,571 1,298,580 6,363,379 1,165 1,062 349,501 3,532 3,412 2,333,136 1,354 2,372 - 10,359,064 10,407,607 100% Redevelopment Commission 9,726,545 2,085,695 7,938,167 2,282,595 2,548,158 932,945 5,832,453 1,224,719 3,821,222 2,304,510 547,456 - 39,244,466 80,197,816 49% City Operations Total 33,081,366 23,013,391 28,543,749 24,904,365 22,829,679 23,528,321 28,442,727 23,010,496 26,601,093 25,819,330 27,109,349 - 286,883,867 414,559,445 69% Expenditure report 33,081,366 23,013,391 28,543,749 24,904,365 22,829,679 23,528,321 28,442,728 23,010,496 26,601,093 25,819,330 27,109,349 0 286,883,867 414,559,445 0 0 0 0 0 0(1)0 0 0 0 0(1)0 2017-11 Financial Report - Expe nditu re Su mmary Page 17 of 25 City of South Bend Period Ending:November 30, 2017 Debt Schedule Year of Year of Year of Scheduled Payments Debt (Orig / Refi)Debt at 2017 Principal 2017 Interest 2017 Debt at 2017 Total Debt Instrument Debt Purpose Issue Refunding Maturity Fund 1st 2nd 3rd 4th Issue 12/31/2016 Payments Payment Addition 12/31/2017 Debt Payments Civil City Debt Bond Debt Amo rt sch # 31 CEDIT Bond 1997 2006 2017 408 2/1 8/1--11,870,000.00 430,000.00 430,000.00 9,932.50 0.00 0.00 439,932.50 36 South Bend Building Corporation Public Works Building 2001 2010 2021 404/649 2/1 8/1--9,250,000.00 2,755,000.00 575,000.00 95,994.00 0.00 2,180,000.00 670,994.00 25 Water Works Improvements Water Works 2002 2012 2023 625 1/1 7/1--5,975,000.00 2,380,000.00 375,000.00 47,600.00 0.00 2,005,000.00 422,600.00 39 South Bend Building Corporation Fire HQ / Police HQ 2003 2012 2023 404/324 2/1 8/1--21,335,000.00 8,885,000.00 1,240,000.00 325,740.00 0.00 7,645,000.00 1,565,740.00 62 Century Center Special Tax Bonds Century Center 2008 2028 420 5/1 11/1--4,655,000.00 3,175,000.00 300,000.00 85,812.50 0.00 2,875,000.00 385,812.50 69 Water Works Improvements Water Works 2009 2030 625 1/1 7/1--5,380,000.00 4,325,000.00 240,000.00 239,938.00 0.00 4,085,000.00 479,938.00 70 Sewage Works Revenue Bonds - 2009 Sewage Work s 2009 2028 649 6/1 12/1--3,297,000.00 2,249,643.00 162,472.00 63,214.00 0.00 2,087,171.00 225,686.00 80 2010 Sewage Work s Revenue Bonds Sewage Work s 2010 2030 649 6/1 12/1--9,345,000.00 7,145,000.00 395,000.00 298,617.50 0.00 6,750,000.00 693,617.50 93 Sewage Works Revenue Bonds 2011 Sewage Work s 2011 2031 649 6/1 12/1--21,500,000.00 17,295,000.00 895,000.00 654,300.00 0.00 16,400,000.00 1,549,300.00 99 2012 Water Works Revenue Bond Water Works 2012 2033 625 1/1 7/1--8,300,000.00 6,925,000.00 355,000.00 209,786.26 0.00 6,570,000.00 564,786.26 101 2012 Sewage Work s Revenue Bonds Sewage Work s 2012 2032 649 6/1 12/1--25,000,000.00 20,890,000.00 1,060,000.00 486,680.00 0.00 19,830,000.00 1,546,680.00 105 2013A Sewer Bond Refunding Sewage Work s 2013 2013 2024 649 6/1 12/1--14,765,000.00 8,050,000.00 1,955,000.00 156,170.00 0.00 6,095,000.00 2,111,170.00 116 2013 Building Corporation EMS / Fire Department 2013 2033 288 2/1 8/1--5,580,000.00 5,145,000.00 225,000.00 177,480.00 0.00 4,920,000.00 402,480.00 133 St. Joseph County PSAP St. Joseph County PSAP 2014 2034 408 Monthly 2,657,696.50 2,386,507.92 107,652.90 59,107.80 0.00 2,278,855.02 166,760.70 139 Century Center Energy Sav ings Improvements at Century Ctr.2015 2031 672 5/1 11/1 4,167,897.00 4,145,312.00 46,606.00 144,690.68 0.00 4,098,706.00 191,296.68 141 Parks and Recreation Bond Parks Improvements 2015 2035 408 2/1 8/1--5,605,000.00 5,295,000.00 210,000.00 172,256.26 0.00 5,085,000.00 382,256.26 145 Sewage Works Revenue Bonds -2015 Sewer Improvements 2015 2025 649 6/1 12/1--27,440,000.00 24,965,000.00 2,530,000.00 499,300.00 0.00 22,435,000.00 3,029,300.00 156 2016 Water Works Refunding Bonds Ref unding 2000 / 2006 SRF 2016 2027 625 1/1 7/1--3,300,000.00 3,300,000.00 405,000.00 49,500.00 0.00 2,895,000.00 454,500.00 xxx Total Bond Debt 234,877,593.50 129,741,462.92 11,506,730.90 3,776,119.50 0.00 118,234,732.02 15,282,850.40 Loans Payable 68 State Revolving Fund Water Works Improvement 2009 2030 625 1/1 7/1--427,332.00 332,562.00 20,912.00 11,207.34 0.00 311,650.00 32,119.34 82 Interfund Loan 410 - UDAG 1st Source/Marriott Garage 2010 2015 410 6/15 12/15--2,700,000.00 1,351,597.75 126,142.25 0.00 0.00 1,225,455.50 126,142.25 xxx Total Loans Payable 29,822,332.00 1,684,159.75 147,054.25 11,207.34 0.00 1,537,105.50 158,261.59 Capital Leases 51 Chase LED Equipment 2007 2017 101 1/1 7/1--1,531,573.00 194,320.02 194,319.97 6,259.69 0.00 0.05 200,579.66 97 Sun Trust Equipment Finance Police Vehicles & Equipment 2012 2017 406 5/15 11/15--1,295,000.00 134,585.22 134,585.22 1,140.42 0.00 0.00 135,725.64 98 PNC Equipment Finance Public Works Vehicles Lease 2012 2017 202/641/640 5/15 11/15--945,674.38 97,793.51 97,793.52 735.98 0.00(0.01)98,529.50 100 PNC Equipment Finance Public Works Vehicles Lease 2012 2017 202/641/600/288 1/15 7/15--2,806,054.00 575,316.55 575,316.53 5,634.82 0.00 0.02 580,951.35 102 Ik on Office Solutions / Ricoh Wastewater Copier 2012 2017 641 Monthly 1st 5,744.95 756.77 756.77 65.82 0.00 0.00 822.59 103 GE Capital Information Technology Fire Department Copier 2012 2017 101 2/28 5/28 8/28 11/28 5,471.01 926.68 926.68 27.40 0.00 0.00 954.08 106 Ricoh USA (New)Central Services Copier 2013 2018 222 2/27 5/27 8/27 11/27 3,622.78 815.82 814.82 24.94 0.00 1.00 839.76 107 Ricoh USA Street/Sewer Dept Copier 2013 2018 202/641 3/4 6/4 9/4 12/4 5,559.15 1,225.93 1,225.93 44.88 0.00 0.00 1,270.81 108 Ricoh USA City Attorney Copier 2013 2018 101 2/12 5/12 8/12 11/12 5,559.15 1,232.73 1,231.73 39.06 0.00 1.00 1,270.79 109 Ricoh USA Parks & Rec Ricoh Copiers(3)2013 2018 201 2/21 5/21 8/21 11/21 16,129.94 3,575.09 3,574.09 113.15 0.00 1.00 3,687.24 110 PNC Equipment Finance Vehicle/Equipment Lease 2013 2018 101/202/406/641 1/15 7/15--1,689,669.59 689,257.88 342,533.13 7,367.39 0.00 346,724.75 349,900.52 111 Ricoh USA Engineering Plotter/Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10,667.67 2,459.26 2,458.26 133.72 0.00 1.00 2,591.98 112 Ricoh USA Building Dept. Copier 2013 2018 600 Monthly 4,093.64 1,491.77 878.55 60.45 0.00 613.22 939.00 113 Sun Trust Equipment Finance Police and PW vehicles 2013 2018 404/655/611/202 4/24 10/24--1,506,465.26 616,891.89 306,011.19 8,569.95 0.00 310,880.70 314,581.14 114 Ricoh USA Admin & Finance Copier 2013 2018 101 1/16 4/16 7/16 10/16 11,247.97 3,079.36 2,444.79 126.44 0.00 634.57 2,571.23 117 Police Dept. Record Div. Ricoh Police Records Copier 2013 2018 101 Monthly 3rd--9,678.26 4,194.14 2,039.23 180.77 0.00 2,154.91 2,220.00 118 Water Works Main Ricoh Copier Water Works Main Ricoh Copier 2013 2018 620 Monthly 10th--5,647.50 2,448.11 1,189.78 105.62 0.00 1,258.33 1,295.40 119 Water Works Colfax Ricoh Copier Water Works Colfax Ricoh Copier 2013 2018 620 Monthly 16th--4,732.65 2,051.62 997.01 85.51 0.00 1,054.61 1,082.52 120 Water Works Olive Ricoh Copier Water Works Olive Ricoh Copier 2013 2018 620 Monthly 10th--4,732.65 2,051.62 997.01 85.51 0.00 1,054.61 1,082.52 123 Police Training Dept. Ricoh Copier Training Copier 2014 2019 101 Monthly 30th--4,263.00 2,076.44 890.27 93.73 0.00 1,186.17 984.00 124 Police/Public Works Vehicle Lease 2014 City Vehicles 2014 2019 Various 4/1 10/1--1,959,485.95 1,193,797.05 391,803.77 16,992.78 0.00 801,993.28 408,796.55 125 HP Computer Lease #1 Computer Equipment Lease 2014 2018 various Monthly 8th--137,104.95 63,525.63 32,632.97 2,191.39 0.00 30,892.66 34,824.36 126 HP Computer Lease #2 Computer Equipment Lease 2014 2018 201 and 620 Monthly 8th--4,000.00 1,947.01 950.39 70.09 0.00 996.62 1,020.48 127 HP Computer Lease #4 Computer Equipment Lease 2014 2018 404 Monthly 8th--5,886.15 2,795.30 1,412.70 83.34 0.00 1,382.60 1,496.04 128 HP Computer Lease #6 Computer Equipment Lease 2014 2018 201 Monthly 8th--3,755.50 1,917.99 883.34 73.78 0.00 1,034.65 957.12 129 HP Computer Lease #7 Computer Equipment Lease 2014 2018 620 Monthly 8th--1,326.00 706.05 315.44 21.40 0.00 390.61 336.84 130 Solid W aste Copier Ricoh USA Copier 2014 2019 611 Monthly 17th--5,351.65 3,302.32 1,071.78 157.86 0.00 2,230.54 1,229.64 131 Police Communications Copier Ricoh USA Copier 2014 2019 101 Monthly 12th--8,843.00 4,876.99 1,804.44 227.40 0.00 3,072.55 2,031.84 132 Organic Resources & Wastewater Ricoh USA Copiers 2014 2019 641 Monthly 21st--12,260.18 6,558.16 2,513.45 303.55 0.00 4,044.71 2,817.00 134 Water Works Copier - North Station Ricoh USA Copiers 2014 2019 620 Monthly 19th--4,732.65 2,132.25 992.44 93.08 0.00 1,139.81 1,085.52 136 HP Computer Lease #8 Computer Equipment Lease 2015 2019 404/201/611 Monthly 16th--19,603.94 11,854.14 4,538.52 494.04 0.00 7,315.62 5,032.56 137 Animal Control Ricoh Copier Ricoh USA Copiers 2015 2020 600 Monthly 30th--5,261.50 3,591.88 1,033.37 182.47 0.00 2,558.51 1,215.84 138 HP Computer Lease #9 Computer Equipment Lease 2015 2019 Various Monthly TBD--135,958.05 94,710.62 30,905.89 3,998.51 0.00 63,804.73 34,904.40 140 Vehicle & Equip. Lease Vehicle/Equipment Lease 2015 2020 Various 1/15 7/15--3,425,273.58 2,763,845.35 676,723.50 35,941.86 0.00 2,087,121.85 712,665.36 143 HP Computer Lease #11 Computer Equipment Lease 2015 2019 404 Monthly--3,040.00 2,161.06 695.77 85.67 0.00 1,465.29 781.44 144 PNC Vehicle Lease No. 2 Vehicle Lease Purchase 2015 2020 Various 5/15 11/15--1,267,183.00 1,021,855.36 249,580.62 14,814.26 0.00 772,274.74 264,394.88 146 Parks & Rec. Ricoh Copier Ricoh Copier 2016 2020 201 Monthly--4,302.06 3,454.72 810.05 176.59 0.00 2,644.67 986.64 147 Central Services Lanier Copier C51005 Copier 2016 2020 222 Monthly--32,525.00 28,667.19 6,046.87 1,368.89 0.00 22,620.32 7,415.76 148 Central Services Lanier Copier C6502 Copier 2016 2020 222 Monthly--11,413.00 10,059.31 2,121.84 480.36 0.00 7,937.47 2,602.20 149 Vehicle & Equip. Lease Public Works Vehicles Lease 2016 2021 Various 2/15 8/15--3,339,830.00 3,016,484.17 651,783.72 45,609.91 0.00 2,364,700.45 697,393.63 150 HP Computer Lease Copier Lease 2016 2020 Various Monthly--17,439.85 14,013.99 3,908.91 574.29 0.00 10,105.08 4,483.20 2017-11 Financial Re port - Deb t P age 18 of 25 City of South Bend Period Ending:November 30, 2017 Debt Schedule Year of Year of Year of Scheduled Payments Debt (Orig / Refi)Debt at 2017 Principal 2017 Interest 2017 Debt at 2017 Total Debt Instrument Debt Purpose Issue Refunding Maturity Fund 1st 2nd 3rd 4th Issue 12/31/2016 Payments Payment Addition 12/31/2017 Debt Payments 151 Admin and Finance Ricoh Copier Copier Lease 2016 2021 101 Monthly--10,923.63 8,938.27 2,047.09 458.15 0.00 6,891.18 2,505.24 152 PNC Vehicle / Equip Lease No. 2 Vehicle / Equipment Lease 2016 2021 Various 1/14 7/14--3,992,548.72 3,992,548.72 770,391.63 62,984.68 0.00 3,222,157.09 833,376.31 153 PNC Vehicle / Equip Lease Amend 1 Parks and Recreation 2016 2021 201 1/17 7/17--78,808.00 78,808.00 15,287.29 1,141.51 0.00 63,520.71 16,428.80 154 PNC Vehicle / Equip Lease No. 3 Parks & Rec / IT 2016 2021 201/279 4/19 10/19--1,256,096.99 1,256,096.99 244,070.10 17,538.46 0.00 1,012,026.89 261,608.56 155 HP Computer Lease No. 13 Computer Equipment Lease 2016 2020 Various Monthly---156,029.30 150,562.73 33,567.37 6,602.27 0.00 116,995.36 40,169.64 157 Venue, Parks, Art Copier Ricoh Copier 2016 2021 201 Monthly---3,184.06 3,184.06 918.51 382.49 0.00 2,265.55 1,301.00 158 Public Finance.com Inc 2017 Vehicle Lease No. 1 2017 2022 Various 1/14 7/14--2,916,500.00 0.00 0.00 0.00 2,916,500.00 0.00 0.00 159 Mayor/Waste Water/Fire Ricoh 2017 Ricoh Copier Lease 2017 2021 101/641/287 Monthly---15,702.09 0.00 3,285.05 843.03 15,702.09 12,417.04 4,128.08 160 HP Computer Refres h Lease No. 14 2017 Ricoh Copier Lease 2017 2021 279/201 Monthly---10,305.25 0.00 1,852.45 359.95 10,305.25 8,452.80 2,212.40 162 Vehicle & Equip. Lease No. 2 Vehicle / Equipment Lease 2017 2021 404 2/15 8/15--1,632,000.00 0.00 0.00 0.00 1,632,000.00 1,632,000.00 0.00 xxx Total Capital Lease 34,787,495.21 16,078,945.72 4,804,933.75 245,147.31 4,574,507.34 11,300,019.31 5,047,868.66 Total Civil City 299,487,420.71 147,504,568.39 16,458,718.90 4,032,474.15 4,574,507.34 131,071,856.83 20,488,980.65 Redevelopment Commission Debt Bond Debt 7 Century Center Lease Rental Revenue Century Center 1994 2001/2011 2018 407 2/1 8/1--6,825,000.00 720,000.00 475,000.00 16,875.00 0.00 245,000.00 491,875.00 8 College Football Hall of Fame Hall of Fame 1994 2000/2011 2018 313 2/1 8/1--15,370,000.00 1,830,000.00 1,215,000.00 53,407.50 0.00 615,000.00 1,268,407.50 11 South Bend Building Corporation Morris PAC 1998 2009 2017 408 2/1 8/1--13,300,000.00 515,000.00 515,000.00 10,300.00 0.00 0.00 525,300.00 12 TJX Special Taxi ng District 2002 2014 2022 324/404/414 1/1 7/1--6,620,000.00 2,210,000.00 415,000.00 66,300.00 0.00 1,795,000.00 481,300.00 5 Downtown Central Area TIF 2003 2011 2024 420 2/1 8/1--19,795,000.00 12,500,000.00 1,315,000.00 598,625.00 0.00 11,185,000.00 1,913,625.00 6 Airport Devel opment Area TIF Airport TIF 2003 2011 2024 324 2/1 8/1--14,420,000.00 7,125,000.00 750,000.00 341,210.50 0.00 6,375,000.00 1,091,210.50 22 Erskine Village TIF Development Bond Erskine Village 2005 2027 432 2/1 8/1--5,485,000.00 3,800,000.00 3,800,000.00 161,666.72 0.00 0.00 3,961,666.72 54 Lease Rental Revenue Bonds of 2008 Eddy Street Commons 2008 2027 429 2/15 8/15--36,000,000.00 30,075,000.00 1,315,000.00 1,148,181.26 0.00 28,760,000.00 2,463,181.26 81 Coveleski Stadi um Recovery Coveleski Stadium 2010 2019 377 1/15 7/15--4,980,000.00 1,665,000.00 650,000.00 77,155.00 0.00 1,015,000.00 727,155.00 122 Synagogue at Coveleski Improvements Coveleski Stadium 2014 2018 377 1/31---500,000.00 200,000.00 100,000.00 0.00 0.00 100,000.00 100,000.00 135 2015 Redevelopment Smart Streets Smarts Streets 2015 2037 324 2/1 8/1--25,000,000.00 25,000,000.00 460,000.00 394,784.38 0.00 24,540,000.00 854,784.38 161 Studebaker Project Façade Improvement Bldg 84 2017 2018 324 One time---3,500,000.00 0.00 3,500,000.00 0.00 3,500,000.00 0.00 3,500,000.00 163 2017 Eddy St. Commons Phase II Eddy St. Commons Phase II 2017 2037 436 2/15 8/15--25,000,000.00 0.00 0.00 0.00 25,000,000.00 25,000,000.00 0.00 xxx Total Bond Debt 182,288,788.00 85,640,000.00 14,510,000.00 2,868,505.36 28,500,000.00 99,630,000.00 17,378,505.36 Loans Payable 3 Indiana Development Finance Authority Bosch Property (Nonforgi ve)2001 2021 210 3/22 6/22 9/22 12/22 1,040,000.00 302,069.15 63,660.08 8,350.36 0.00 238,409.07 72,010.44 4 Indiana Development Finance Authority Bosch Property (Forgive)2001 2021 210----260,000.00 83,482.06 0.00 0.00 0.00 65,888.51 0.00 64 Interfund Fund 412 - Major Moves Douglas Road TIF 2009 2029 435 2/15 8/15--1,040,319.00 323,005.00 322,201.00 12,088.00 0.00 804.00 334,289.00 84 Interfund Fund 412 - Major Moves Triangle Development 2011 2029 436 2/15 8/15--2,000,000.00 1,329,573.43 94,621.29 26,120.71 0.00 1,234,952.14 120,742.00 85 Interfund Fund 412 - Major Moves Eddy Street Commons 2011 2026 436 2/15 8/15--4,100,000.00 2,384,347.86 661,383.84 111,052.16 0.00 1,722,964.02 772,436.00 86 Interfund Fund 209 to Airport 324 Prairie Ave Brownfield Project 2011 2020 324 8/9---500,000.00 400,000.00 100,000.00 0.00 0.00 300,000.00 100,000.00 142 Interfund Fund 412 - Major Moves Parking Garage Improvements 2016 2022 601 6/1 12/1 1,500,000.00 517,304.69 229,174.05 20,825.95 750,000.00 1,038,130.64 250,000.00 xxx Total Loans Payable 15,627,499.06 5,339,782.19 1,471,040.26 178,437.18 750,000.00 4,601,148.38 1,649,477.44 Capital Lease xxx Total Capital Lease 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Leases 13 Transpo Lease Main / Colfax Garage 2006 2025 324 3/15 9/15--2,510,278.00 1,435,338.00 129,838.00 70,162.00 0.00 1,305,500.00 200,000.00 xxx Total Lease 5,510,278.00 1,435,338.00 129,838.00 70,162.00 0.00 1,305,500.00 200,000.00 Total Redevelopment Commission 203,426,565.06 92,415,120.19 16,110,878.26 3,117,104.54 29,250,000.00 105,536,648.38 19,227,982.80 Total Debt 502,913,985.77 239,919,688.58 32,569,597.16 7,149,578.69 33,824,507.34 236,608,505.21 39,716,963.45 2017-11 Financial Re port - Deb t P age 19 of 25 City of South Bend Period Ending:November 30, 2017 Monthly Debt Schedule` Year of Year of Year of Scheduled Payments Debt (Orig / Refi)Debt at YTD Principal YTD Interest YTD Debt at Debt Instrument Debt Purpose Issue Refunding Maturity Fund 1st 2nd 3rd 4th Issue 12/31/2016 Payments Payments Additions 11/30/2017 Civil City Debt Bond Debt Amort sch # 3 6 South Bend Building Corporation Public Works Building 2001 2010 2021 404/649 2/1 8/1--9,250,000.00 2,755,000.00 575,000.00 95,994.00 0.00 2,180,000.00 2 5 Water Works Improvements W ater Works 2002 2012 2023 625 7/1 12/31--5,975,000.00 2,380,000.00 0.00 23,800.00 0.00 2,380,000.00 3 9 South Bend Building Corporation Fire HQ / Police HQ 2003 2012 2023 404/324 2/1 8/1--21,335,000.00 8,885,000.00 1,240,000.00 325,740.00 0.00 7,645,000.00 6 2 Century Center Special Tax Bonds Century Center 2008 2028 324 4/1 11/1--4,655,000.00 3,175,000.00 300,000.00 50,093.75 0.00 2,875,000.00 6 9 Water Works Improvements W ater Works 2009 2030 625 7/1 12/31--5,380,000.00 4,325,000.00 0.00 119,969.00 0.00 4,325,000.00 7 0 Sewage W orks Revenue Bonds - 2009 Sewage Works 2009 2028 649 6/1 12/1--3,297,000.00 2,249,643.00 0.00 31,607.00 0.00 2,249,643.00 8 0 2010 Sewage W orks Revenue Bonds Sewage Works 2010 2030 649 6/1 12/1--9,345,000.00 7,145,000.00 0.00 149,308.75 0.00 7,145,000.00 9 3 Sewage W orks Revenue Bonds 2011 Sewage Works 2011 2031 649 6/1 12/1--21,500,000.00 17,295,000.00 0.00 327,150.00 0.00 17,295,000.00 9 9 2012 Water Works Rev enue Bond W ater Works 2012 2033 625 1/1 7/1--8,300,000.00 6,925,000.00 0.00 104,893.13 0.00 6,925,000.00 10 1 2012 Sewage W orks Revenue Bonds Sewage Works 2012 2032 649 6/1 12/1--25,000,000.00 20,890,000.00 0.00 243,340.00 0.00 20,890,000.00 10 5 2013A Sewer Bond Refunding Sewage Works 2013 2013 2024 649 6/1 12/1--14,765,000.00 8,050,000.00 0.00 78,085.00 0.00 8,050,000.00 11 6 2013 Building Corporation EMS / Fire Department 2013 2033 288 2/1 8/1--5,580,000.00 5,145,000.00 225,000.00 177,480.00 0.00 4,920,000.00 13 3 St. Joseph County PSAP St. Joseph County PSAP 2014 2034 408 Monthly---2,657,696.50 2,386,507.92 96,887.61 53,197.02 0.00 2,289,620.31 13 9 Century Center Energy Savings Improvements Century Ctr.2015 2031 672 5/1 11/1--4,167,897.00 4,145,312.00 46,606.00 144,690.68 0.00 4,098,706.00 14 1 Parks and Rec Bond Parks Improvements 2015 2035 408 2/1 8/1--5,605,000.00 5,295,000.00 215,000.00 175,482.00 0.00 5,080,000.00 14 5 Sewage W orks Revenue Bonds - 2015 Sewer Bond Improvements 2015 2025 649 6/1 12/1--27,440,000.00 24,965,000.00 0.00 249,650.00 0.00 24,965,000.00 15 6 2016 Water Works Refunding Bonds Refundi ng 2000 / 2006 SRF 2016 2027 625 1/1 7/1--3,300,000.00 3,300,000.00 0.00 50,600.00 0.00 3,300,000.00 xxx Total Bond Debt 234,877,593.50 129,741,462.92 3,128,493.61 2,411,012.83 0.00 126,612,969.31 Loans Payable 6 8 State Rev olving Fund W ater Works Improvement 2009 2030 625 7/1 12/31--427,332.00 332,562.00 0.00 5,603.67 0.00 332,562.00 8 2 Interf und Loan 410 - UDAG 1st Source/Marriott Garage 2010 2015 410 6/15 12/15--2,700,000.00 1,351,597.75 94,328.75 0.00 0.00 1,257,269.00 xxx Amy Shirk Total Loans Payable 29,822,332.00 1,684,159.75 94,328.75 5,603.67 0.00 1,589,831.00 Capital Leases 5 1 Chase LED Equipment 2007 2017 101 1/1 7/1--1,531,573.00 194,320.02 194,320.02 6,259.69 0.00 0.00 9 7 Sun Trust Equipment Finance Police Vehicles & Equipment 2012 2017 406 5/15 11/15--1,295,000.00 134,585.22 134,585.22 1,140.42 0.00 0.00 9 8 PNC Equipment Finance Public Works Vehicles Lease 2012 2017 202/641/640 5/15 11/15--945,674.38 97,793.51 97,793.51 735.90 0.00 0.00 10 0 PNC Equipment Finance Public Works Vehicles Lease 2012 2017 202/641/600/288 1/15 7/15--2,806,054.00 575,316.55 575,316.55 5,634.81 0.00 0.00 10 2 Ikon Office Solutions / Ricoh W astewater Copier 2012 2017 641 Monthly 1st--5,744.95 756.77 756.77 14.34 0.00 0.00 10 3 GE Capital Information Technology Fire Department Copier 2012 2017 101 2/28 5/28 8/28 11/28 5,471.01 926.68 926.68 27.40 0.00 0.00 10 6 Ricoh USA Central Services Copier 2013 2018 222 2/27 5/27 8/27 11/27 3,622.78 815.82 815.82 23.94 0.00 0.00 10 7 Ricoh USA Street/Sewer Dept Copier 2013 2018 202/641 3/4 6/4 9/4 12/4 5,559.15 1,225.93 909.23 43.87 0.00 316.70 10 8 Ricoh USA City Attorney Copier 2013 2018 101 2/12 5/12 8/12 11/12 5,559.15 1,232.73 1,232.73 38.07 0.00 0.00 10 9 Ricoh USA Parks & Rec Ricoh Copiers(3)2013 2018 201 3/21 6/21 9/21 12/21 16,129.94 3,575.09 2,665.52 117.07 0.00 909.57 11 0 PNC Equipment Finance Vehicle/Equipment Lease 2013 2018 101/202/406/641 1/15 7/15--1,689,669.59 689,257.88 342,533.13 7,367.39 0.00 346,724.75 11 1 Ricoh USA Engineering Plotter/Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10,667.67 2,459.26 1,823.95 120.05 0.00 635.31 11 2 Ricoh USA Building Dept. Copier 2013 2018 600 Monthly--4,093.64 1,491.77 803.47 57.28 0.00 688.30 11 3 Sun Trust Equipment Finance Police and PW vehicles 2013 2018 404/655/611/202 4/24 10/24--1,506,465.26 616,891.89 306,011.19 8,569.95 0.00 310,880.70 11 4 Ricoh USA Admin & Finance Copier 2013 2018 101 1/16 4/16 7/16 10/16 11,247.97 3,079.36 2,445.81 125.35 0.00 633.55 11 7 Police Dept. Record Div. Ricoh Police Records Copier 2013 2018 101 Monthly 3rd--9,678.26 4,194.14 1,864.97 170.03 0.00 2,329.17 11 8 Water Works Main Ricoh Copier W ater Works Main Ricoh Copier 2013 2018 620 Monthly 10th--5,647.50 2,448.11 1,088.09 99.36 0.00 1,360.02 11 9 Water Works Colfax Ricoh Copier W ater Works Colf ax Ricoh Copier 2013 2018 620 Monthly 16th--4,732.65 2,051.62 911.81 83.25 0.00 1,139.81 12 0 Water Works Olive Ricoh Copier W ater Works Olive Ricoh Copier 2013 2018 620 Monthly 10th--4,732.65 2,051.62 911.81 83.25 0.00 1,139.81 12 3 Police Training Dept. Ricoh Copier Training Copier 2014 2019 101 Monthly 30th--4,263.00 2,076.44 814.16 87.84 0.00 1,262.28 12 4 Key Gov ernment Finance 2014 City Vehicles 2014 2019 v arious 4/1 10/1--1,959,485.95 1,193,797.05 391,803.76 16,992.78 0.00 801,993.29 12 5 HP Computer Lease #1 Computer Equipment Lease 2014 2018 v arious Monthly 8th--137,104.95 63,525.63 29,857.22 2,065.11 0.00 33,668.41 12 6 HP Computer Lease #2 Computer Equipment Lease 2014 2018 201 and 620 Monthly 8th--4,000.00 1,947.01 869.50 65.94 0.00 1,077.51 12 7 HP Computer Lease #4 Computer Equipment Lease 2014 2018 404 Monthly 8th--5,886.15 2,795.30 1,292.88 78.49 0.00 1,502.42 12 8 HP Computer Lease #6 Computer Equipment Lease 2014 2018 201 Monthly 8th--3,755.50 1,917.99 808.08 69.28 0.00 1,109.91 12 9 HP Computer Lease #7 Computer Equipment Lease 2014 2018 620 Monthly 8th--1,326.00 706.05 288.69 20.08 0.00 417.36 13 0 Solid Waste Copier Ricoh USA Copier 2014 2019 611 Monthly 17th--5,351.65 3,302.32 980.16 147.01 0.00 2,322.16 13 1 Police Communications Copier Ricoh USA Copier 2014 2019 101 Monthly 12th--8,843.00 4,876.99 1,650.18 212.34 0.00 3,226.81 13 2 Organic Resourc es & Wastewater Ricoh USA Copiers 2014 2019 641 Monthly 21st--12,260.18 6,558.16 2,298.59 283.66 0.00 4,259.57 13 4 Water Works Copier - North Station Richo USA Copiers 2014 2019 620 Monthly 19th--4,732.65 2,132.25 907.63 87.43 0.00 1,224.62 13 6 HP Computer Lease #8 Computer Equipment Lease 2015 2019 404/201/611 Monthly 16th--19,603.94 11,854.14 4,151.52 461.66 0.00 7,702.62 13 7 Animal Control Ricoh Copier Ricoh USA Copiers 2015 2020 600 Monthly 30th--5,261.50 3,591.88 944.92 169.60 0.00 2,646.96 13 8 HP Computer Lease #9 Computer Equipment Lease 2015 2019 Various Monthly TBD--135,958.05 94,710.62 28,271.61 3,724.09 0.00 66,439.01 14 0 Vehicle & Equip. Lease Vehicle/Equipment Lease 2015 2020 Various 1/15 7/15--3,425,273.58 2,763,845.35 676,723.50 35,941.86 0.00 2,087,121.85 14 3 HP Computer Lease #11 Computer Equipment Lease 2015 2019 404 Monthly 3,040.00 2,161.06 636.55 79.77 0.00 1,524.51 14 4 PNC Vehicle Lease No. 2 Vehicle Lease Purchase 2015 2020 v arious 5/15 11/15--1,267,183.00 1,021,855.36 124,310.54 7,886.90 0.00 897,544.82 14 6 Parks & Recreation Copi er Ricoh Copier 2016 2020 201 Monthly 4,302.06 3,454.72 740.77 163.65 0.00 2,713.95 14 7 Central Serv ices Lanier Copier C51005 Copier 2016 2020 222 Monthly---32,525.00 28,667.19 5,530.71 1,267.07 0.00 23,136.48 14 8 Central Serv ices Lanier Copier C6502 2016 2020 222 Monthly---11,413.00 10,059.31 1,940.72 444.63 0.00 8,118.59 14 9 Vehicle & Equip. Lease Public Works Vehicles Lease 2016 2021 v arious 2/15 8/15 3,339,830.00 3,016,484.17 651,783.72 45,609.90 0.00 2,364,700.45 2017-11 Financial Report - Debt Page 20 of 25 City of South Bend Period Ending:November 30, 2017 Monthly Debt Schedule` Year of Year of Year of Scheduled Payments Debt (Orig / Refi)Debt at YTD Principal YTD Interest YTD Debt at Debt Instrument Debt Purpose Issue Refunding Maturity Fund 1st 2nd 3rd 4th Issue 12/31/2016 Payments Payments Additions 11/30/2017 15 0 HP Computer Lease Computer Lease- Refresh 2016 2020 404/641/620 Monthly---17,439.85 14,013.99 3,576.13 533.47 0.00 10,437.86 15 1 Admin and Financ e Ricoh Copier MPC8002SP Copier 2016 2021 101 Monthly---10,923.63 8,938.27 1,872.00 424.47 0.00 7,066.27 15 2 PNC Vehicle / Equip Lease No. 2 Vehicle / Equipment Lease 2016 2021 v arious 1/14 7/14--3,992,548.72 3,992,548.72 770,391.63 62,984.69 0.00 3,222,157.09 15 3 PNC Vehicle / Equip Lease Amend 1 Parks and Recreation 2016 2012 201 1/17 7/17--78,808.00 78,808.00 15,287.29 1,141.51 0.00 63,520.71 15 4 PNC Vehicle / Equip Lease No. 3 Parks & Rec / IT 2016 2021 201/279 4/19 10/19--1,256,096.99 1,256,096.99 244,070.10 17,538.46 0.00 1,012,026.89 15 5 HP Computer Lease No. 13 Computer Equipment Lease 2016 2020 v arious Monthly---156,029.30 150,562.73 30,707.12 6,126.05 0.00 119,855.61 15 7 Venue, Parks, Art Copier Ricoh Copier 2016 2021 201 Monthly---3,184.06 3,184.06 869.53 366.44 0.00 2,314.53 15 8 Public Finance.com Inc 2017 Vehicle Lease No. 1 2017 2022 v arious 1/14 7/14--2,916,500.00 0.00 0.00 0.00 2,916,500.00 2,916,500.00 15 9 Mayor/Waste W ater/Fire Ricoh 2017 Ricoh Copier Lease 2017 2021 101/641/287 Monthly---15,702.09 0.00 2,986.17 766.63 15,702.09 12,715.92 16 0 HP Computer Ref resh Lease No. 14 2017 Ricoh Copier Lease 2017 2021 279/201 Monthly---10,305.25 0.00 1,664.03 327.13 10,305.25 8,641.22 16 2 Vehicle & Equip. Lease No. 2 Vehicle / Equipment Lease 2017 2021 404 2/15 8/15--1,632,000.00 0.00 0.00 0.00 1,632,000.00 1,632,000.00 xxx Total Capital Lease 34,787,495.21 16,078,945.72 4,665,745.69 236,779.36 4,574,507.34 15,987,707.37 Total Civil City 299,487,420.71 147,504,568.39 7,888,568.05 2,653,395.86 4,574,507.34 144,190,507.68 Redevelopment Commission Debt Bond Debt 7 Century Center Lease Rental Revenue Century Center 1994 2001/2011 2018 407 2/1 8/1--6,825,000.00 720,000.00 475,000.00 16,875.00 0.00 245,000.00 8 College Football Hall of Fame Hall of Fame 1994 2000/2011 2018 313 2/1 8/1--15,370,000.00 1,830,000.00 1,215,000.00 53,407.50 0.00 615,000.00 1 2 TJX Special Taxing District 2002 2014 2022 324/404/414 1/1 7/1--6,620,000.00 2,210,000.00 0.00 33,150.00 0.00 2,210,000.00 5 Downtown Central Area TIF 2003 2011 2024 420 2/1 8/1--19,795,000.00 12,500,000.00 1,315,000.00 598,625.00 0.00 11,185,000.00 6 Airport Development Area TIF Airport TIF 2003 2011 2024 324 2/1 8/1--14,420,000.00 7,125,000.00 750,000.00 341,210.50 0.00 6,375,000.00 2 2 Erskine Village TIF Development Bond Erskine Village 2005 2027 432 2/1 8/1--5,485,000.00 3,800,000.00 3,800,000.00 161,666.72 0.00 0.00 5 4 Lease Rental Revenue Bonds of 2008 Eddy Street Commons 2008 2027 429 2/15 8/15--36,000,000.00 30,075,000.00 1,315,000.00 1,148,181.26 0.00 28,760,000.00 8 1 Coveleski Stadium Recovery Coveleski Stadium 2010 2019 377 1/15 7/15--4,980,000.00 1,665,000.00 650,000.00 77,155.00 0.00 1,015,000.00 12 2 Synagogue at Coveleski Improvements Coveleski Stadium 2014 2018 377 1/31---500,000.00 200,000.00 0.00 0.00 0.00 200,000.00 13 5 2015 Redevelopment Smart Streets Smart Streets 2015 2037 324 2/1 8/1--25,000,000.00 25,000,000.00 460,000.00 789,568.76 0.00 24,540,000.00 16 1 Studebaker Project Façade Improvement Bldg 84 2017 2018 324 One-time---3,500,000.00 0.00 0.00 0.00 3,500,000.00 3,500,000.00 16 3 2017 Eddy St. Commons Phas e II Eddy St. Commons Phase II 2017 2037 436 2/15 8/15--25,000,000.00 0.00 0.00 0.00 25,000,000.00 25,000,000.00 xxx Total Bond Debt 182,288,788.00 85,640,000.00 10,495,000.00 3,230,139.74 28,500,000.00 103,645,000.00 Loans Payable 3 Indiana Development Finance Authority Bos ch Property (Nonforgive)2001 2021 210 3/22 6/22 9/22 12/22 1,040,000.00 302,069.15 47,566.24 6,441.59 0.00 254,502.91 4 Indiana Development Finance Authority Bos ch Property (Forgiv e)2001 2021 210----260,000.00 83,482.06 0.00 0.00 0.00 66,406.56 8 4 Interf und Fund 412 - Major Moves Triangle Development 2011 2029 436 2/15 8/15--2,000,000.00 1,329,573.43 94,621.29 26,120.71 0.00 1,234,952.14 8 5 Interf und Fund 412 - Major Moves Eddy Street Commons 2011 2026 436 2/15 8/15--4,100,000.00 2,384,347.86 326,609.30 59,608.70 0.00 2,057,738.56 8 6 Interf und Fund 209 to Airport 324 Prairie Ave Brownfield Project 2011 2020 324 8/9---500,000.00 400,000.00 100,000.00 0.00 0.00 300,000.00 14 2 Interf und Fund 412 - Major Moves Parking Garage Improvements 2016 2022 601 6/1 12/1--1,500,000.00 517,304.69 0.00 0.00 750,000.00 1,267,304.69 xxx Total Loans Payable 15,627,499.06 5,339,782.19 891,801.83 104,773.00 750,000.00 5,180,904.86 Capital Lease xxx Total Capital Lease 0.00 0.00 0.00 0.00 0.00 0.00 Leases 1 3 Transpo Lease Main / Colfax Garage 2006 2025 324 3/15 9/15--2,510,278.00 1,435,338.00 129,837.00 70,163.00 0.00 1,305,501.00 xxx Total Lease 5,510,278.00 1,435,338.00 129,837.00 70,163.00 0.00 1,305,501.00 Total Redevelopment Commission 203,426,565.06 92,415,120.19 11,516,638.83 3,405,075.74 29,250,000.00 110,131,405.86 Total Debt 502,913,985.77 239,919,688.58 19,405,206.88 6,058,471.60 33,824,507.34 254,321,913.54 2017-11 Financial Report - Debt Page 21 of 25 City of South Bend Staffing Headcount Summary Budget Full Time Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Full Time Staff 1,107 1,080 1,069 1,082 1,078 1,076 1,093 1,089 1079 1092 1092 1096 0 Part Time Staff 115 119 142 155 168 145 139 155 159 145 126 0 Temporary / Seasonal 12 11 13 41 86 206 202 80 39 30 21 0 City Total 1,207 1,199 1,237 1,274 1,330 1,444 1,430 1314 1290 1267 1243 0 2017-11 Financial Report - Headcount Staffing Page 22 of 25 City of South Bend Staffing Headcount Full Time Staff Amended Budget FT Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor 7 6 6 6 5 6 8 8 8 9 8 7 0 311 Call Center 6 6 6 6 7 7 6 6 6 6 6 6 0 Admin & Finance 23 20 21 22 23 23 23 23 23 23 23 21 0 Innovation/ Technology Office 18 14 14 15 14 16 17 17 17 17 17 17 0 Safety & Risk 2 2 2 2 2 2 2 2 2 2 2 2 0 Clerk 5 5 5 5 5 5 5 5 5 5 6 5 0 Common Council 9 9 9 9 9 9 9 9 9 9 9 9 0 Central Services 40 38 39 37 37 38 39 38 38 40 40 39 0 Legal Department 11 11 11 10 10 10 10 11 9 9 9 11 0 Sub Total 121 111 113 112 112 116 119 119 117 120 120 117 0 Code Enf. /Animal Control/ Unsafe Bldg.29 24 26 28 28 29 28 29 29 29 29 29 0 Dept. of Community Investment 23 22 20 21 21 20 20 20 20 20 20 22 0 Parks & Recreation Administration 6 6 6 6 6 6 6 6 6 6 7 7 0 Maintenance 50 45 47 48 47 47 48 48 48 48 49 49 0 Golf Operations 8 7 8 7 8 8 8 8 8 8 8 8 0 Recreation Ops 21 22 21 21 21 21 22 22 22 21 21 21 0 Zoological Ops 1 1 1 1 1 1 1 1 1 1 1 1 0 Graffiti Removal 1 1 1 1 1 1 1 1 1 1 1 1 0 Recreation Non-reverting 1 1 1 1 1 1 0 0 0 0 0 0 0 Marketing and Events 10 8 10 10 10 10 10 10 10 10 10 10 0 Sub Total 98 91 95 95 95 95 96 96 96 95 97 97 0 Public Safety Police 289 284 272 282 280 278 288 283 280 280 280 285 0 Fire 264 268 267 266 263 261 259 260 260 270 270 270 0 Sub Total 553 552 539 548 543 539 547 543 540 550 550 555 0 Public Works Office of Sustainability 2 2 2 2 2 2 2 2 2 2 1 1 0 Engineering 18 18 18 20 20 20 20 20 20 18 17 17 0 Solid Waste Operations 26 25 25 26 25 24 25 25 26 25 25 25 0 Street Operations 55 54 54 54 54 53 56 54 52 52 53 53 0 Sewer Operations 621 37 37 37 37 37 35 37 37 37 37 37 37 0 Waste Water Ops 630 45 45 45 44 44 45 45 45 42 45 44 44 0 Organic Resources 6 6 5 5 6 6 6 6 6 6 6 6 0 Water Utility Ops 65 64 63 63 63 64 65 66 65 66 66 66 0 Sub Total 254 251 249 251 251 249 256 255 250 251 249 249 0 Building Department 14 14 14 14 14 14 14 14 14 14 14 14 0 Human Rights 6 6 6 6 6 6 5 5 5 5 5 5 0 Morris & Palais 9 9 7 7 8 8 8 8 8 8 8 8 0 City Total 1,107 1,080 1,069 1,082 1,078 1,076 1,093 1,089 1,079 1,092 1,092 1,096 - 2017-11 Financial Report - Headcount Staffing Page 23 of 25 City of South Bend Staffing Headcount Part Time Staff Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor 1 1 1 1 1 0 0 0 0 0 0 0 311 Call Center 2 2 2 0 0 2 2 2 2 2 2 0 Admin & Finance 0 0 0 0 0 0 0 0 0 1 1 0 Safety and Risk 0 0 0 0 0 0 0 0 0 0 0 0 Innovation/ Technology Office 1 0 0 0 0 0 0 0 0 0 0 0 Clerk 0 0 0 0 0 0 0 0 0 0 0 0 Common Council 0 0 0 0 0 0 0 0 0 0 0 0 Central Services 1 1 1 1 1 1 1 1 1 0 1 0 Legal Department 1 1 1 1 1 1 1 1 1 1 1 0 Sub Total 6 5 5 3 3 4 4 4 4 4 5 0 Code Enf. / Animal Control 3 2 3 3 3 4 4 4 4 4 5 0 Dept. of Community Investment 0 0 0 0 0 0 0 0 0 0 0 0 Parks & Recreation Administration 1 1 1 1 1 1 0 1 1 0 1 0 Maintenance 11 11 11 15 14 13 13 14 14 12 12 0 Golf Operations 2 0 18 41 54 54 53 44 38 28 7 0 Recreation Ops 46 54 54 46 48 42 40 43 48 48 44 0 Zoological Ops 0 0 0 0 0 0 0 0 0 0 0 0 Graffiti Removal 4 4 4 1 1 0 1 1 1 1 1 0 Marketing & Events 1 1 1 1 1 1 1 1 1 1 1 0 Sub Total 65 70 88 104 118 110 108 103 102 90 66 0 Public Safety Police 25 25 29 27 27 10 5 26 28 27 29 0 Communications 0 0 0 0 0 0 0 0 0 0 0 0 Fire 0 0 0 0 0 1 1 1 1 1 1 0 Sub Total 25 25 29 27 27 11 6 27 29 28 30 0 Public Works` Engineering 2 2 2 3 2 2 2 2 3 4 4 0 Traffic & Lighting 0 0 0 0 0 0 0 0 0 0 0 0 Maintenance 0 0 0 0 0 0 0 0 0 0 0 0 Solid Waste Ops 0 0 0 0 0 0 0 0 0 0 0 0 Street Ops 7 8 9 9 9 7 7 7 9 8 9 0 Sewer Ops 0 0 0 0 0 0 0 0 0 0 0 0 Waste Water Ops 0 0 0 0 0 0 0 0 0 0 0 0 Water Utility Ops 3 3 2 2 2 3 4 4 4 3 3 0 Sub Total 12 13 13 14 13 12 13 13 16 15 16 0 Building Department 0 0 0 0 0 0 0 0 0 0 0 0 Human Rights 0 0 0 0 0 0 0 0 0 0 0 0 Morris & Palais 4 4 4 4 4 4 4 4 4 4 4 0 City Total 115 119 142 155 168 145 139 155 159 145 126 0 2017-11 Financial Report - Headcount Staffing Page 24 of 25 City of South Bend Staffing Headcount Paid Temporary, Seasonal, and Intern Staff Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor 0 0 0 0 0 0 1 1 0 0 0 0 Admin & Finance 1 1 0 0 1 1 1 0 0 0 0 0 Safety and Risk 1 0 0 0 0 0 0 0 0 0 0 0 Clerk 0 0 0 0 0 0 0 0 0 0 0 0 Common Council 0 0 0 0 0 0 0 0 0 0 0 0 Central Services 0 0 0 0 0 1 0 1 0 0 0 0 Legal 0 0 0 0 0 0 0 0 0 0 0 0 Sub Total 2 1 0 0 1 2 2 2 0 0 0 0 Code Enfor. / Animal 1 1 1 1 1 0 2 2 0 0 0 0 Dept. of Community Investment 0 0 0 0 0 0 0 0 0 0 0 0 Parks & Recreation Administration 0 0 0 0 0 0 1 0 0 0 0 0 Maintenance 1 1 2 12 29 36 32 24 17 8 3 0 Golf Operations 0 0 1 1 2 3 5 7 3 2 0 0 Recreation Ops 3 2 2 15 40 129 127 29 11 3 4 0 Zoological Ops 0 0 0 0 0 0 0 0 0 0 0 0 Graffiti Removal 0 0 0 0 0 0 0 0 0 0 0 0 Sub Total 4 3 5 28 71 168 165 60 31 13 7 0 Public Safety Police 0 0 0 0 0 14 14 5 1 1 1 0 Communications 0 0 0 0 0 0 0 0 0 0 0 0 Fire 0 0 0 0 0 0 0 0 0 0 0 0 Sub Total 0 0 0 0 0 14 14 5 1 1 1 0 Public Works Engineering 3 4 4 4 1 7 7 1 1 1 1 0 Energy / Sustainability 0 0 0 0 0 0 0 0 0 0 0 0 Traffic & Lighting 0 0 0 0 0 0 0 0 0 0 0 0 Maintenance 0 0 0 0 0 0 0 0 0 0 0 0 Solid Waste Ops 0 0 0 0 0 0 0 0 0 0 0 0 Street Ops 1 1 1 7 9 8 8 7 6 0 0 0 Sewer Ops 0 0 0 0 0 0 0 0 0 0 0 0 Leaf Pickup 0 0 0 0 0 0 0 0 0 15 12 0 Waste Water Ops 0 0 1 0 1 2 0 1 0 0 0 0 Organic Resources 0 0 0 0 0 1 0 0 0 0 0 0 Water Utility Ops 0 0 0 0 2 4 4 2 0 0 0 0 Sub Total 4 5 6 11 13 22 19 11 7 16 13 0 Building Department 0 0 0 0 0 0 0 0 0 0 0 0 Human Rights 0 0 0 0 0 0 0 0 0 0 0 0 Morris & Palais 1 1 1 1 0 0 0 0 0 0 0 0 City Total 12 11 13 41 86 206 202 80 39 30 21 0 2017-11 Financial Report - Headcount Staffing Page 25 of 25