Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017-12 Financial Report
Period Ending: Issued By: City of South Bend Financial Report Tab Page Contents Narrative 2 Brief discussion on notable fund activity Revenue 3-9 City Revenues Prop Tax Rev 10-11 Property Tax Revenue Collection Status Expenditures 12-15 Expenditures by Fund and Department Debt 16-17 Debt Status Debt Monthly 18-19 Current Debt at Month End Headcount 20-23 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 December 31, 2017 Controller 2017-12 Financial Report Page 1 of 23 December 31, 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 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. The Full Time Headcount as of December was 1,091 vs.a budgeted amount of 1,107.Currently,there are a total of 16 vacant positions. The 16 open positions are in the following departments:General Government(4),Parks(4),Police(4),Public Works(2),DCI(1),and Human Rights Commission (1). At this time, the Fire Department is over budget by eight positions (8) 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 95%,compared to 96%in December 2016.Auto excise tax higher than expected budget due to increased motor vehicle registration. PSDA(fund 377)and revenue type(335)was much lower than expected due to a lower percentage of the tax being distributed to the various businesses in the district,such as Four Winds Field South Bend Cubs,Century Center,and South Bend Museum of Art,to name a few. As of December 2017, the general fund has reached 99% of its budgeted revenue, similar to last year. Department of Community and Investment (Fund 212) and LOIT 2016 Special Distribution ( Fund 257) revenues are lower than budgeted as these funds are grant reimbursed. Although revenue is budgeted at the full amount, revenues are paid when eligible projects are completed. They are typically reimbursed 1-3 months after invoice. Grant funds are typically lower than budget. Parking enforcement fees are also lower than expected due to Amnesty Day. This year, the City Clerk, with legislation, was given the authority to declare a Parking Ticket Amnesty Day as well as allowing the first ticket in 2017 to be waived. The event brought in payments for over 500 unpaid parking tickets, but eliminated penalties. In 2017, the city won a Regional Cities grant and entered its portion of $5.0 million into the budget. As with most grants, this is reimbursable and paid 1-3 months after invoice. Therefore revenue is a timing issue. We expect this grant to be spent in 2018 Property taxes are received in June and December.Property taxes collected in 2017 totaled~$77.1 million.Civil city funds received ~$49.8 million or 98%of budget and TIF funds received~$27.2 million or 94%of budget.For 2017,the projected levy collection rate was 95% or $75.6 million. Lower than expected TIF collection due to various refunds and other TIF adjustments made by the county. As of December 2017,the City has spent 74%of budgeted expenditures,compared to 77%last year.The General Fund has spent 95% of its 2017 budgeted expenditures,similar to 2016.In 2017,the city won a Regional Cities grant and entered its portion of$5.0 million into the budget.As with most grants,this is reimbursable and paid 1-3 months after invoice.Therefore revenue is a timing issue.We expect this grant to be spent in 2018.Expenditures for Recreation Non Reverting lower than expected due to cancellation of programs this year, such as flag football,Jr.golf tour,and low attendance for the Daddy Daughter Dance.Local Road and Street(Fund 251)expenses lower than budgeted due to unforeseen circumstances causing project delays.However$1.03 million is encumbered and the projects will be completed in 2018.The 2017 Parks Bond(fund 471),is over budget as the expenditures for this was originally in fund 313(Hall of Fame). For expenditures related to TIF funds, please refer to the Departmental Financial Report. This month,various debt service payments were made in the amount of~$9.2 million.Payments are related to IT equipment leases.St. Joseph County PSAP, Indiana Finance Authority, and US Bank. 2017-12 Financial Report Page 2 of 23 City of South Bend Period Ending:December 31, 2017 Revenue by Type Report Fund% Revenue Type 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 - - - - - 22,369,647 49,858,701 49,770,000 100% 311 Property Tax TIF Districts various- - - - - 14,314,504 - - - - - 12,963,143 27,277,646 27,254,124 100% Sub Total- - - - - 41,803,558 - - - - - 35,332,790 77,136,347 77,024,124 100% 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 866,667 10,433,361 10,433,361 100% 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 622,302 7,467,618 7,467,618 100% 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 871,605 10,459,265 10,459,265 100% 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 2,360,574 28,360,244 28,360,244 100% St Joseph County (Remitted by) 312 Auto Excise Tax various- - - - - 1,680,548 - - - - - 1,864,665 3,545,213 3,206,500 111% 312 Commercial Vehicle Tax various- - - - - 402,188 - - - - - 402,187 804,375 843,000 95% 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 106,250 1,275,000 1,275,000 100% 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 2,373,102 6,168,588 5,868,500 105% State of Indiana (Remitted by) 335 Cigarette Tax 101/407- - - - - 148,523 - - - - - 164,459 312,982 328,000 95% 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,027 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 581,976 5,163,733 5,163,732 100% 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 224,717 100% 335 Prof Sports Development Tax 377 62,404 - 115,348 24,070 23,090 - - - - - - 184,747 409,659 700,000 59% 335 Wheel Tax 202- - 503,523 - 451,523 - 372,905 368,811 - 355,070 - 159,898 2,211,731 2,051,832 108% 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 1,091,081 20,117,822 20,267,199 99% 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 871,113 7,623,339 7,623,339 100% 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 12,133 203,551 316,000 64% Sub Total 537,143 886,481 555,675 888,436 527,215 528,918 524,618 574,930 883,999 527,430 529,309 883,245 7,847,397 13,004,339 60% 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 241,179 2,921,201 2,927,618 100% 349 Central Services 222 51,820 48,684 51,854 49,741 49,575 50,298 46,813 59,676 55,927 64,163 64,554 39,102 632,208 873,809 72% 380 Central Services 222 210,212 208,994 226,075 189,251 209,433 210,487 197,836 222,500 195,631 239,484 185,151 205,030 2,500,084 2,930,786 85% 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 374,185 4,401,679 4,492,800 98% 380 Police Take Home Vehicle 278- - - - - - 560 320 240 240 240 360 1,960 1,960 100% 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 430,621 5,167,452 5,205,034 99% 380 Beck's Lake Reimbursement 404- - 283,432 - - - - - - - - - 283,432 283,432 100% 380 Insurance Claim various- - - - - - - - 143,523 - 42,292 - 185,815 185,815 100% 380 INDOT SR 933 Transfer 251/324- - - - - - - - - - - - - 330,000 0% 380 Internal Service Reimbursement various 619 35,123 - - - 900 - 98 - 120 - - 36,861 606,741 6% 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 414,748 4,976,976 4,977,026 100% 392 Internal Fund Transfers various 1,085,348 9,754,150 4,553,300 4,585,904 1,649,180 1,807,518 1,279,407 5,585,586 4,161,903 1,713,919 1,704,144 3,160,537 41,040,895 41,746,693 98% 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 1,478,405 17,744,923 17,909,776 99% 396 Central Services Refunds 222 1,314 - 62,668 (56,756) 2,392 1,416 - - - 3,330 5,780 6,090 26,233 26,233 100% 396 Specific Stop Loss 711 6,503 (2,436) 496 - - 389 41,857 52,421 5,572 4,911 489 2,321 112,522 112,522 100% Sub Total 4,354,872 13,023,779 8,126,291 7,708,771 4,835,896 4,969,285 4,403,685 8,937,391 7,479,692 4,952,074 4,887,926 6,352,578 80,032,240 82,610,245 97% 2017-12 Financial Report - Revenue Re port 3 of 23 City of South Bend Period Ending:December 31, 2017 Revenue by Type Report Fund% Revenue Type Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget 3rd Party Revenue 340 ND EMS Service 288- - 44,904 - 1,338 14,152 2,832 - - - 6,753 77,946 147,925 150,000 99% 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 196,208 771,128 771,128 100% 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 - - 14,081,478 43,629,978 44,355,100 98% Sub Total 55,865 546,898 44,904 - 2,969,616 14,152 2,832 244,589 26,632,000 - 193,596 14,355,632 45,060,084 45,914,888 98% 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 530,449 4,396,803 9,102,745 48% 334 State Grants various- - 33,745 5,150 - 137,805 - 275,321 67,600 - - 142,718 662,340 704,055 94% 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 673,167 5,059,143 9,806,800 52% 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 28,818 15,746 12,407 11,383 4,566 1,656 10,809 7,191 2,485 1,075 415 127,469 135,833 94% 321 Code and Animal Fees 600 4,536 5,085 6,015 5,891 6,975 6,368 7,095 6,521 7,047 6,372 5,792 5,794 73,488 82,178 89% 322 Building Fees 600 90,363 86,593 108,895 95,111 141,205 195,184 108,716 170,070 124,307 125,105 108,312 86,787 1,440,646 1,494,833 96% 322 Code Enforcement Fees 600 1,050 300 3,000 1,500 600 2,800 1,200 900 1,200 600 3,100 2,700 18,950 20,000 95% 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 1,340 21,220 24,568 86% 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 10,288 117,880 117,365 100% 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 1,928 33,928 36,651 93% 342 Highway & Streets 202 38,686 - 16,474 2,320 43,516 13,142 - - - 37,381 - 75,810 227,329 227,329 100% 340 Public Safety various- - - - - - - - - 25 - - 25 500 5% 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 12,247 149,855 162,205 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 147,207 1,766,486 1,766,486 100% 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 367,012 283,950 328,536 306,433 232,306 3,114,576 4,244,544 73% 342 EMS - Neo Natal / Transport 288 16,185 18,553 16,128 14,553 4,909 167,113 37,377 32,230 34,401 42,260 48,629 39,992 472,330 509,400 93% 344 Solid Waste 610 444,203 460,843 468,017 403,574 285,268 412,168 416,424 414,479 415,555 416,566 414,816 412,518 4,964,430 5,825,375 85% 344 Code Environmental Clean Up 101/219/600 12,404 3,044 21,837 17,648 11,871 19,048 13,263 18,343 16,730 11,180 25,503 17,379 188,249 262,642 72% 344 Sewage Waste Water 641 3,209,590 3,128,008 3,112,831 3,105,649 3,096,610 3,192,879 3,215,485 3,297,280 3,280,685 3,276,064 3,181,526 3,133,628 38,230,235 38,425,442 99% 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 53,231 639,249 638,754 100% 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 82,066 981,297 981,198 100% 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 1,043,177 14,290,198 14,335,015 100% 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 13,811 381,745 419,552 91% 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 37,161 444,734 444,693 100% 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 460,474 3,374,643 4,195,491 80% 347 Sale of Merchandise 101- - - - - 70 - - - - 20 20 110 110 100% 347 Morris PAC 416- 12,214 13,143 11,334 5,563 2,871 4,291 1,840 594 4,654 2,350 14,654 73,508 100,000 74% 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 102,137 1,197,792 1,223,769 98% 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 747 107,844 141,493 76% 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 2,215 112,915 110,700 102% 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 25,655 345,110 397,181 87% 352 Forfeits various 734 616 3,897 5,014 1,556 23,381 8,542 456 3,570 8,725 5,048 75,895 137,435 200,500 69% 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 5,395 78,902 127,254 62% 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 7,805 76,604 82,500 93% 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) 1,103 47,189 50,344 94% 362 South 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 11,374 269,442 324,092 83% 369 Memorial Hosp Leighton Plaza 408 150,000 - - - - - - - - - - 150,000 300,000 300,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 202,618 2,846,044 3,011,548 95% 380 General Government 101- - - - - - - - - - - - - 3,100 0% Sub Total 5,942,193 7,728,937 6,072,213 5,925,103 5,982,669 6,701,095 6,690,516 8,505,513 6,757,220 6,844,958 6,307,190 6,469,876 79,927,483 84,998,231 94% 2017-12 Financial Report - Revenue Re port 4 of 23 City of South Bend Period Ending:December 31, 2017 Revenue by Type Report Fund% Revenue Type Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Other Income 360 Miscellaneous Revenue various 130,165 9,590 35,319 94,586 6,519 191,033 187,868 52,561 42,716 (35,440) 60,387 (468,686) 306,618 589,086 52% 360 Insurance Reimbursement various 8 43,872 6,115 4,529 5,091 19,242 550 40,311 274 4,496 - - 124,487 126,143 99% 360 Sale of Scrap Metal various 893 1,472 1,167 2,505 4,345 1,959 669 2,557 - 4,433 756 16,037 36,794 43,866 84% 360 General Government Various 101/226 12,254 - 176 238 244 - 149 25 874 120 219 - 14,300 14,300 100% 360 Engineering / Curb & Sidewalk 101- 50 50 - - - 50 - - - 100 - 250 1,000 25% 360 Motor Veh Highway Curb Prgm 202 11 - - - - - - - - - - - 11 32,000 0% 360 Code / Animal Control 600- - - - 181 - - - - - 6,000 - 6,181 6,181 100% 360 Waste Water 641- 1,965 - - - - - 18,939 - - - 11,900 32,804 45,000 73% 360 Sewage Depreciation Fund 642- 400,000 - - - - - - - - - - 400,000 400,000 100% 360 Century Center 670- - - 1,000 - - - - - - - - 1,000 1,000 100% 360 Morris PAC various 10,073 80,579 170,904 68,016 45,018 114,956 31,458 17,556 60,826 32,639 17,079 342,658 991,762 1,102,268 90% 360 Palais Royale various 24,371 4,131 9,256 7,929 19,759 18,450 32,907 37,310 18,800 21,982 18,182 32,201 245,278 250,657 98% 360 Common Area Maint. Fees various 2,420 2,330 2,555 1,930 1,930 1,930 1,930 1,930 1,930 1,130 2,730 1,930 24,673 46,245 53% 360 TIF Property Owners' Share various- - - - - 264,000 - 151,941 - - 151,064 (100,000) 467,005 467,008 100% 380 Miscellaneous Reimbursements various 65,173 54,742 171,192 77,763 111,522 103,356 102,973 49,498 594,472 45,794 123,465 62,928 1,562,876 1,710,426 91% 399 Bosch Retention Project 210- - 15,737 - - 15,855 - - - 15,974 - 16,094 63,660 63,661 100% 399 Principal on Loan various 19,897 100,821 19,726 20,742 601 577 1,241 17,866 52,020 437 2,382 693 237,004 236,888 100% 399 Principal Income various 30,702 515,610 - 31,814 - - 31,814 328,702 134,775 31,814 - - 1,105,228 1,105,228 100% Sub Total 295,966 1,215,161 432,198 311,051 195,210 731,358 391,607 719,197 906,686 123,379 382,364 (84,245) 5,619,932 6,240,957 90% 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 (7,109) 2,218,568 2,715,694 82% Sub Total 156,963 166,772 205,325 97,825 95,274 271,135 328,751 296,209 207,385 154,244 245,794 (7,109) 2,218,568 2,715,694 82% 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 11,450 397,551 467,914 85% Sub Total 75,816 1,040 70,660 440 25,155 55,987 374,782 83,148 27,285 1,102 686 11,450 727,551 805,414 90% Historic Preservation 368 Lamppost Program 227/404- - - 500 250 250 1,000 500 - - - - 2,500 3,500 71% 368 Palais Royale 450 1,838 114 345 390 646 1,410 2,472 2,815 1,616 1,848 1,507 1,423 16,423 16,500 100% Sub Total 1,838 114 345 890 896 1,660 3,472 3,315 1,616 1,848 1,507 1,423 18,923 20,000 95% Sale of Assets 391 TIF (Property Sales / Land)various- 60,000 2 1 61,029 - 1 - 224,892 - - 409,624 755,549 754,076 100% 391 Water Hydrant Reimbursement 620- - - - - - - - - - 2,772 - 2,772 2,772 100% 391 Sale of Fixed Assets various- - - - - 1,137 - 178,674 (23,000) - - 81,006 237,817 289,809 82% Sub Total- 60,000 2 1 61,029 1,137 1 178,674 201,892 - 2,772 490,630 996,138 1,046,657 95% Revenue Total 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 70,304,193 359,290,460 378,683,292 95% 2017-12 Financial Report - Revenue Re port 5 of 23 City of South Bend Period Ending:December 31, 2017 Revenue by Fund Report Fund% Division Recipient 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 20,670,626 56,790,735 56,846,828 100% 0101 Mayor 101- - - - - 70 - - - - 20 20 110 610 18% 0401 Administration and Finance 101 12,254 - 8 - - - - - - 11 327 - 12,600 12,642 100% 0501 Legal 101 18,475 - - - 18,875 - 18,875 - 874 10 - 18,875 75,984 76,251 100% 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 20,689,521 56,879,429 56,936,331 100% 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 10,288 275,090 334,702 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 10,288 275,090 334,702 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 18,491 657,013 738,122 89% 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 18,491 699,420 781,005 90% 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 342,847 1,027,341 1,133,477 91% 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 42,513 346,409 362,758 95% Sub Total 37,153 96,078 197,080 82,898 80,317 144,427 81,154 70,897 85,749 63,166 49,471 385,360 1,373,750 1,496,235 92% 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 21,103,660 59,227,689 59,548,273 99% 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 4,817,217 11,296,116 11,050,737 102% 1100 Administration 201 3,787 3,548 5,830 3,974 7,149 6,524 4,562 8,447 1,523 1,268 1 1,104 47,718 51,344 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 294,121 1,558,057 1,710,210 91% 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 10,526 1,267,172 1,540,692 82% 1103 Recreation Division 201 22 810 1,346 20 1,410 26,012 41,188 29,398 2,532 - - 408 103,145 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,389 69% 1110 Marketing and Events 201- - - 69 - 162 1,717 (125) 222 41,077 - 214,294 257,417 573,067 45% 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 52,864 949,896 1,157,768 82% 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 (3) 42,590 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 (35) 270,952 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 5,390,496 15,903,480 21,845,429 73% 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 1,637,090 10,356,311 10,269,857 101% 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 624,080 7,598,784 8,383,051 91% Central Services Capital 224 84 72 89 41 35 105 98 85 286,760 18 187 1 287,575 287,832 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 243,208 1,572,802 1,960,561 80% 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 37,217 452,847 453,881 100% 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 2,541,596 22,268,319 23,355,182 95% 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 426,203 5,424,644 6,324,149 86% Solid Waste Capital 611 179 240 100,039 83,600 20,027 290,004 65 200,348 7 85,029 62 28 779,627 836,713 93% Sub Total 446,110 471,922 580,873 578,168 349,604 745,646 459,884 658,345 483,060 546,003 458,426 426,231 6,204,271 7,160,862 87% 2017-12 Financial Report - Revenue Summary 6 of 23 City of South Bend Period Ending:December 31, 2017 Revenue by Fund Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget 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 982,278 13,297,375 13,354,209 100% 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 82,066 981,297 981,198 100% 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 75,927 1,154,195 1,157,688 100% Waterworks Capital 622 1,942 1,950 2,167 958 875 2,956 2,890 2,762 1,985 1,073 1,882 44,339 65,781 82,232 80% Waterworks Deposit 624 1,159 1,174 1,347 639 583 1,965 1,923 1,851 1,352 733 1,287 (79) 13,935 16,500 84% Waterworks Sinking 625 164,824 164,289 164,321 164,211 164,266 177,878 1,266 328,973 811 328,522 165,100 166,241 1,990,701 1,990,412 100% Waterworks Bond Reserve 626 1,154 1,073 1,235 594 548 1,828 1,791 1,732 1,278 705 1,217 (11) 13,144 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 (116) 175,076 179,000 98% 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 1,350,644 17,691,502 17,777,239 100% Public Works Wastewater Sewage 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 53,151 655,836 657,811 100% 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 2,927,659 36,191,847 36,386,897 99% 0621 Sewer Department 641- 1,261 - - - 1,191 - 23,915 - 1,502 - - 27,869 39,002 71% 0625 Concrete Crew 641- 3,040 - - - - - 33,569 - - - 28,443 65,053 77,249 84% 0630 Wastewater Operations 641- - - - - - - 11,132 - - - - 11,132 37,352 30% 0631 Organic Resources 641- - - - - - - 26,220 - - - - 26,220 37,352 70% 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 192,825 2,228,272 2,253,160 99% 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 (266) 4,401,733 4,911,464 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 (229) 562,731 569,561 99% 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 772,808 9,200,080 9,210,203 100% Sewage Works DS Reserve 653- 955 1,176 1,189 1,579 1,877 2,174 2,423 2,869 3,033 3,006 6,434 26,716 23,481 114% 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 (29) 19,175 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 3,980,795 53,416,818 54,253,733 98% Public Safety - Police Police Seizures 216 10,276 3,136 200 127 1,986 300 297 287 25,051 116 3,903 88 45,767 62,326 73% Curfew Violations 218 9 35 24 5 17 54 54 28 22 6 23 (1) 277 1,034 27% 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 22,011 278,175 294,886 94% 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 621,857 7,476,031 7,478,618 100% Police Take Home Vehicle 278 561 575 660 315 288 977 1,521 1,250 922 610 889 331 8,899 9,894 90% Police Block Grant 280 3 3 3 2 1 5 5 5 4 2 3 (0) 36 50 72% Police Academy 294 5,456 4,561 2,023 886 2,483 288 111 105 77 3,141 273 496 19,900 22,980 87% COPS More Grants 295 1,055 36,332 946 1,029 10,378 1,054 1,011 991 946 1,108 19,254 463 74,566 141,844 53% Drug Enforcement 299 149 162 148 166 161 168 182 23,201 (20,971) 218 50,184 103 53,871 82,048 66% K-9 Unit 705 2 2 3 1 1 4 4 4 3 1 2 (0) 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 645,348 7,957,548 8,095,716 98% 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 (90) 3,248,415 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 507,736 5,624,031 6,798,550 83% Hazmat 289 19 20 23 11 10 30 28 3,087 22 12 21 3,369 6,653 10,255 65% River Rescue 291 114 16,307 12,724 1,869 23,462 10,989 3,211 186 128 4,260 1,301 2,390 76,939 74,800 103% 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 513,405 8,956,038 11,412,954 78% 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 (7) 362,772 427,441 85% State Grant 210 242 268 18,311 148 135 18,459 455 3,130 319 18,176 302 71,191 131,134 262,837 50% 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 392,484 2,035,803 2,294,524 89% 0000 Dept. of Community Investment 212 310,284 201,138 42,852 164,474 83,939 239,114 31,360 49,702 229,167 58,202 711,123 316,760 2,438,116 5,452,490 45% 1013 Programs 212 93,743 - - - - 118,838 - 116,141 - - 12,466 15,655 356,843 356,843 100% Economic Revenue Bond 281 21 21 24 12 11 36 35 34 25 14 24 (1) 255 300 85% Sub Total 440,280 596,182 134,898 619,981 102,327 390,903 69,474 359,175 656,484 100,269 1,058,867 796,083 5,324,922 8,794,435 61% 2017-12 Financial Report - Revenue Summary 7 of 23 City of South Bend Period Ending:December 31, 2017 Revenue by Fund Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Parking Garages 0000 Parking Garage Revenue 601 284 671 1,020 40 - - 108 361 - - - (1,274) 1,209 9,100 13% 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 27,265 376,793 379,596 99% 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 60,250 568,147 599,633 95% 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 5,860 71,873 93,602 77% 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 14,260 255,185 256,022 100% 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 106,361 1,273,206 1,353,853 94% Capital / Debt Service Hall of Fame 313 50 6 23 8 10 474,777 12 14 77 18 18 393,179 868,192 894,300 97% 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 884,296 11,064,843 11,083,428 100% Cum Capital Development 406 357 436 410 184 169 259,526 492 674 395 201 353 215,788 478,984 486,245 99% Cum Capital Improvement 407 150,266 294 301 144 132 117,143 25,562 567 270 147 258 129,005 424,088 437,000 97% 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 1,018,025 11,937,260 11,954,109 100% UDAG 410 445 416 493 235 207 689 677 629 451 245 411 (21) 4,876 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 (132) 1,054,550 1,058,403 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 14,920 79,459 106,500 75% Palais Historic Preservation 450 1,907 187 428 429 683 1,534 2,596 2,937 1,708 1,898 1,597 1,414 17,319 17,541 99% 2017 Parks Bond 471- - - - - - - - - - - 14,081,478 14,081,478 13,856,100 102% Hall of Fame Capital 677 372 378 431 200 182 612 598 576 420 226 393 (4) 4,383 5,000 88% SB Building Corp 755- 1,326,786 210 65 117 169 191 1,323,992 754 333 330 714 2,653,662 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 32,026 386,307 391,891 99% Eddy St. Commons Debt 760- - - - - - - - 2,500,000 233 411 836 2,501,480 2,501,479 100% 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 16,771,525 45,556,882 45,452,606 100% 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 (468) 93,891 107,516 87% Gift, Donation, Bequest 217 50,900 1,097 69,994 5,639 220 51,058 513 1,726 885 1,153 675 1,452 185,312 214,383 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 163,206 795,492 906,930 88% Landlord Registration 221 2,260 270 1,245 155 60 25 20 5 865 1,655 880 1,035 8,475 7,480 113% Loss Recovery 227 730 741 851 404 368 1,244 1,217 1,176 793 418 733 (29) 8,645 9,766 89% 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 56,825 448,989 1,679,189 27% Human Rights 258 91,498 4,790 5,975 2,576 356 600 39,798 689 413 218 374 79,943 227,229 259,113 88% Morris Palais Marketing 273 34 582 1,132 577 947 3,950 58 60 1,532 744 1,243 2,881 13,739 18,495 74% 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 430,621 5,167,452 5,205,034 99% Professional Sports Development 377 80,547 318 115,357 24,107 23,146 214 14,680 213 - - - 195,802 454,383 734,325 62% 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 444,514 1,802,857 1,921,119 94% 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 188,085 804,832 817,543 98% 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 86,170 1,470,462 1,532,781 96% 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 311,083 4,234,959 4,408,248 96% Century Center Capital 671 74 66 74 71 74 71 74 74 71 74 71 73 866 793 109% Century Center Energy Saving 672 6 4 4 4 4 4 55,520 82,171 4 4 55,395 4 193,125 193,124 100% 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 1,961,198 15,910,710 18,015,839 88% 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 240,858 3,005,202 3,587,702 84% 0418 Workers Compensation 226 619 35,123 - - - 900 - - - - - - 36,642 36,643 100% Sub Total 247,298 282,599 245,267 248,740 243,026 253,998 246,803 246,533 244,966 254,535 287,222 240,858 3,041,844 3,624,345 84% 2017-12 Financial Report - Revenue Summary 8 of 23 City of South Bend Period Ending:December 31, 2017 Revenue by Fund Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Fiduciary Trust & Agency Fire Pension 701 335 84 - - - 2,461,856 - 292 2,458,856 - 3,238 1,101 4,925,762 4,927,101 100% Police Pension 702 2,386 1,224 5,915 565 595 3,108,612 290 1,049 3,100,921 12 2,089 1,611 6,225,269 6,226,825 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 1,480,638 17,937,949 18,115,868 99% Unemployment Comp 713 217 214 244 114 102 339 329 310 221 118 204 2 2,413 2,800 86% City Cemetery Trust 730 22 22 25 12 11 37 37 36 26 14 25 (1) 266 303 88% Equipment / Vehicle Leasing 750- 298 375 223 2,916,712 532 161,897 (160,372) 1,632,769 766 939 1,587 4,555,727 5,506,572 83% Parks Bond Capital 751- 369 539 485 517 632 652 624 637 588 1,457 200 6,700 7,500 89% Smart Street Bond Capital 753- 604 663 544 545 606 561 42,305 22,038 (19,750) 20,185 355 68,655 100,579 68% Eddy St. Commons Capital 759- - - - - - - - 22,500,000 - - - 22,500,000 22,500,000 100% 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 1,485,492 56,222,741 57,387,548 98% 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 57,313,692 318,955,971 338,078,014 94% 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 8,405,571 19,351,374 19,952,275 97% TIF West Washington 422 1,411 1,497 1,721 821 751 200,696 2,595 2,664 1,952 1,054 1,799 180,482 397,442 442,000 90% 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 13,405 116,772 197,051 59% 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,101,158 2,759,233 3,146,120 88% 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 1,147,149 3,885,283 3,931,958 99% 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 160,725 379,789 328,208 116% TIF River East RES (NE RE)436 442 - - - - 2,320,321 - - - - - 1,937,211 4,257,974 3,300,903 129% 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 12,945,701 31,156,387 31,307,035 100% Redevelopment Funds Administration 433 6 6 7 4 3 10 9 9 7 4 6 (0) 71 135 53% Certified Technology Park 439 1,614 1,641 1,887 900 825 1,064 456 253,066 397 299 523 (28) 262,643 302,625 87% Airport Urban Enterprise Zone 454 288 292 336 160 147 498 489 473 347 188 330 (18) 3,532 4,044 87% Industrial Revolving 754- - 21,526 9,673 14,952 12,238 7,388 7,961 - 51,814 - 43,671 169,223 239,705 71% Sub Total 1,908 1,940 23,757 10,737 15,927 13,810 8,342 261,509 750 52,304 860 43,625 435,470 546,509 80% Debt Service Airport Debt Reserve 2003 315 780 792 902 434 398 1,346 1,323 1,278 935 507 888 (46) 9,536 14,000 68% Coveleski Bond Debt Reserve 317 385 391 450 214 197 666 655 633 464 252 442 (24) 4,725 5,410 87% Central Development reserve 328 1,303 1,323 1,522 725 664 2,249 2,210 2,135 1,563 847 1,484 (79) 15,946 20,000 80% SB Redevelopment Authority 752- 772,669 1,236,763 395 197,726 305 195 1,484,222 400 682 196,765 750 3,890,871 3,890,771 100% Smart Streets Debt Svc 756- 179 263 197 218 277 291 856,782 381 329 282 574 859,774 859,771 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 1,176 8,742,633 8,751,734 100% Redevelopment Commission 108,430 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 12,990,501 40,334,489 40,605,278 99% City Operations Total 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 70,304,193 359,290,460 378,683,292 95% 2017-12 Financial Report - Revenue Summary 9 of 23 City of South Bend Period Ending:December 31, 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 12/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 17,747,933.08 - - 39,568,075.59 680,791.41 98.31% Parks & Recreation 201 9,179,442.00 0.95 8,720,469.90 4,976,456.29 4,057,274.45 - - 9,033,730.74 145,711.26 98.41% College Football Hall of Fame 313 833,277.00 0.95 791,613.15 451,820.36 368,250.79 - - 820,071.15 13,205.85 98.42% Cumulative Capital District 406 443,869.00 0.95 421,675.55 240,635.07 196,188.32 - - 436,823.39 7,045.61 98.41% Total - City 50,705,455.00 48,170,182.25 27,489,054.23 22,369,646.64 - - 49,858,700.87 846,754.13 98.33% Tax Increment Financing Airport TIF District 324 18,698,946.24 0.95 17,763,998.93 8,932,881.19 8,327,020.81 - - 17,259,902.00 1,439,044.24 92.30% West Washington TIF District 422 367,557.18 0.95 349,179.32 198,151.66 180,841.94 - - 378,993.60 (11,436.42) 103.11% Northeast Residential TIF District 436 4,405,723.00 0.95 4,185,436.85 2,320,321.06 1,942,596.42 - - 4,262,917.48 142,805.52 96.76% Southside TIF District #1 430 2,390,790.99 0.95 2,271,251.44 1,216,823.61 1,148,868.40 - - 2,365,692.01 25,098.98 98.95% Douglas Road TIF District 435 321,949.68 0.95 305,852.20 218,279.99 160,974.84 - - 379,254.83 (57,305.15) 117.80% Northeast TIF 429 2,766,113.25 0.95 2,627,807.59 1,428,045.99 1,202,840.55 - - 2,630,886.54 135,226.71 95.11% Total - Tax Increment Financing 28,951,080.34 27,503,526.32 14,314,503.50 12,963,142.96 - - 27,277,646.46 1,673,433.88 94.22% Grand Total 79,656,535.34 75,673,708.57 41,803,557.73 35,332,789.60 - - 77,136,347.33 2,520,188.01 96.84% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 6/20/17 2 Distribution 2 - Issued by St. Joseph County on 12/20/17 2017-12 Financial Report - Property Tax Revenue Page 10 of 23 City of South Bend Period Ending:December 31, 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-12 Financial Report - Property Tax Revenue Page 11 of 23 City of South Bend Period Ending:December 31, 2017 Expenditure Report Fund% Division Recipient 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 84,636 825,705 872,923 95% 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 49,577 468,303 536,216 87% 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 71,146 471,079 571,148 82% 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 242,410 2,408,921 2,476,351 97% 0501 Legal 101 87,585 86,783 87,565 116,630 75,744 109,460 80,722 95,963 75,203 69,972 74,044 120,563 1,080,233 1,158,567 93% Sub Total 402,773 416,575 385,606 467,764 444,284 537,304 406,485 437,008 414,597 420,441 396,073 568,331 5,297,242 5,658,205 94% 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 116,582 1,196,927 1,485,157 81% Sub Total 81,736 88,219 89,641 89,644 103,226 120,430 96,986 98,261 109,104 97,783 105,317 116,582 1,196,927 1,485,157 81% 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 3,801,371 28,166,148 29,668,433 95% 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 2,646,630 20,579,934 21,111,466 97% 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 6,448,002 48,746,082 50,779,899 96% 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 310,768 1,183,617 1,271,039 93% 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 211,504 495,908 530,200 94% Sub Total 99,730 110,260 58,436 77,434 78,798 94,553 78,483 81,189 78,122 321,444 78,804 522,272 1,679,525 1,801,239 93% 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 38,130 404,887 425,805 95% Sub Total 37,821 40,148 32,484 37,408 31,913 34,695 29,063 35,285 29,894 29,160 28,886 38,130 404,887 425,805 95% General Fund Expenses 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 7,693,317 57,324,663 60,150,305 95% 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 126,350 1,404,091 1,441,743 97% 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 640,775 6,335,078 6,957,861 91% 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 90,239 1,409,068 1,669,575 84% 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 171,323 2,008,072 2,153,817 93% 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 8,792 705,715 707,314 100% 1106 Potawatomi Greenhouse 201 5,013 4,555 2,550 2,375 1,198 15,764 411 408 566 665 1,482 2,724 37,710 46,058 82% 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 10,296 102,258 112,932 91% 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 91,036 746,809 953,588 78% 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 62,500 975,364 1,599,683 61% East Race Waterway 271- - - - - - 1,353 - - - - 3 1,356 1,367 99% Coveleski Stadium 401- - - 8,542 4,569 - 1,778 1,136 975 61,597 - - 78,597 79,000 99% 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) 12,505 404,956 553,024 73% 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 1,216,544 14,454,185 21,326,012 68% Public Works Motor Vehicle Highway 202 1,069,953 555,615 585,340 561,441 685,060 753,517 843,684 794,260 872,599 818,495 630,007 1,199,878 9,369,849 11,765,531 80% 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 783,895 7,888,268 8,564,643 92% Central Services Capital 224 10,575 4,009 - 16,964 - 11,786 - 16,597 114,180 25,071 - 6,255 205,438 326,025 63% Local Roads & Streets 251 209,999 4,801 3,018 35,678 92,276 81,399 305,836 166,252 2,321 146,800 - 18,911 1,067,290 2,308,544 46% Local Road & Bridge Grant 265- - - - - - 64 - - 1,400 465,271 540,322 1,007,057 2,000,000 50% 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 110,977 504,901 537,171 94% 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 2,660,238 20,042,803 25,501,914 79% 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 426,024 5,105,623 5,662,910 90% Solid Waste Capital 611 286,902 146,712 218 83,859 20,129 219 286,862 146,712 259 83,924 19,921 426 1,076,141 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 426,450 6,181,764 6,798,523 91% 2017-12 Financial Report - Expenditure Summary 12 of 23 City of South Bend Period Ending:December 31, 2017 Expenditure Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget 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 109,039 812,454 935,000 87% 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 1,476,188 14,734,230 16,788,754 88% 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 9,940 506,610 1,414,466 36% Waterworks Deposit 624 874 1,174 1,347 639 583 1,965 1,923 1,851 1,352 733 1,287 - 13,729 16,500 83% Waterworks Sinking 625 815 289 321 211 266 255,311 52,101 1,373 811 522 1,100 1,699,677 2,012,797 2,055,891 98% 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 27,500 85% 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 3,294,844 18,119,565 21,257,611 85% 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 67,408 547,016 634,509 86% 0621 Sewer Department 641 517,647 434,598 385,613 579,850 349,846 452,561 422,426 441,576 375,871 1,430,923 333,355 1,492,652 7,216,917 9,548,100 76% 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 50,659 337,481 474,389 71% 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 2,281,729 30,065,014 33,198,000 91% 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 68,453 1,288,328 1,608,946 80% 0650 Clay Sewage 641- 5 26 50 431 - 181 73 9 - 106 15 895 1,750 51% 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 52,850 4,270,370 8,051,255 53% 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 60,000 76% Sewage Bond Sinking 649 1,000 500 - - 830,476 249,650 - - - - 8,077,055 500 9,159,181 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 4,014,266 55,245,648 65,802,955 84% Public Safety - Police Police Seizures 216- - - - - - - - - - 5,868 63,338 69,206 216,000 32% 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 4,742 498,322 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 807,427 7,429,100 7,462,645 100% Excess Welfare Public Safety 252- - - - - - - - - - 8 - 8 8 101% Police Take Home Vehicle 278- 972 - (60) (120) (260) 340 100 - - 6,570 2,445 9,986 10,000 100% 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 56 8,637 22,500 38% COPS More Grants 295 10,980 3,436 108,583 11,664 915 240 347 - 180 19,534 960 19,995 176,834 263,767 67% 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 536,055 536,812 934,829 645,295 638,547 950,676 644,615 704,542 657,838 677,322 578,607 898,003 8,403,141 9,122,175 92% 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 11,591 2,570,479 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 709,602 5,487,336 6,137,914 89% Hazmat 289 430 255 - - 4,057 - - 200 826 - - 196 5,964 10,431 57% River Rescue 291 1,443 231 231 23,817 10,419 21,299 9,052 15,613 11,629 981 231 346 95,291 117,349 81% 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 721,735 8,159,070 10,257,160 80% 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 34,573 342,795 539,393 64% State Grant 210- - 18,003 - - 18,003 - - 18,003 - - 18,003 72,010 509,757 14% 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 238,525 2,285,446 2,775,376 82% 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 315,533 2,585,517 5,580,838 46% Sub Total 843,192 277,183 238,081 380,458 403,211 390,985 284,283 336,985 307,295 534,692 682,768 606,634 5,285,768 9,405,364 56% 2017-12 Financial Report - Expenditure Summary 13 of 23 City of South Bend Period Ending:December 31, 2017 Expenditure Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Parking Garages 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 20,614 196,455 261,894 75% 0461 St. Joseph 601- - - - 604 - (604) - - - - - - - NA 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 123,635 516,763 567,268 91% 0463 Enforcement 601 7,858 7,238 437 22,849 437 12,035 5,445 13,557 7,791 20,833 489 20,391 119,360 173,675 69% 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 17,274 187,496 244,417 77% 0465 Eddy Street Commons 601- - - 32 - 647 - 160 (840) - - - - - NA Sub Total 50,284 54,648 4,482 186,776 24,534 80,587 13,826 92,445 135,979 178,986 15,613 181,913 1,020,074 1,247,254 82% Capital / Debt Service Hall of Fame 313 635,000 - (3,265) - - - 633,000 - (121,315) 800 - (7,453) 1,136,767 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 1,175,908 11,375,975 12,071,593 94% 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 1,902,523 10,347,496 11,559,184 90% 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 203,766 253,719 401,144 63% Palais Historic Preservation 450- - - - - - - 627 - - - - 627 5,000 13% 2017 Parks Bond 471- - - - - - - - - - - 192,520 192,520 - NA 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 10,119 52,208 81,091 64% SB Building Corp 755- - 1,437,970 - - - 500 - 1,203,744 - 1,000 950 2,644,164 2,643,214 100% Parks Bond Debt Svc 757- - 198,566 - - - - - 191,916 - - - 390,481 391,482 100% Eddy St. Commons Debt 760- - - - - - - - - - - - - 2,500,000 0% 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 3,478,333 27,842,640 34,367,309 81% Other Miscellaneous Gift, Donation, Bequest 217 72,000 900 - 663 760 6,877 79,294 31,363 3,000 - 2,009 4,478 201,343 241,700 83% 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 51,299 789,079 905,479 87% Landlord Registration 221 5 5 - - - - - - - - - 5 15 1,000 2% Loss Recovery 227- 3,345 7,600 2,080 5,844 - - 102,343 - - 10,654 726 132,592 598,675 22% 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 104,056 2,192,717 3,757,457 58% 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 14,226 135,315 201,773 67% 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 378,735 3,578,369 5,205,034 69% 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 161,963 1,482,672 1,621,571 91% 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 85,368 802,876 851,892 94% 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 128,242 1,278,875 1,361,925 94% 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 414,497 4,156,573 4,342,610 96% 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,575,491 882,977 1,555,645 1,400,092 1,244,635 1,184,796 1,406,254 1,224,921 869,096 1,749,690 1,339,660 1,343,595 15,776,852 20,131,043 78% 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 20,093 211,107 235,471 90% 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 56,352 1,291,733 1,894,051 68% 0417 Business Insurance 226 45,354 - 21,392 120 21,404 - 386,775 25,962 19,855 - 6,529 6,260 533,651 635,678 84% 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 142,395 945,128 1,072,386 88% Sub Total 228,276 128,412 148,890 283,807 736,460 114,282 558,713 109,320 150,740 202,052 95,568 225,100 2,981,619 3,837,586 78% 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 387,898 4,629,305 5,098,269 91% 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 504,112 6,132,823 6,423,889 95% 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 981,693 14,748,082 17,803,200 83% 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 5,714 63,336 84,105 75% 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 657,909 4,134,997 6,455,670 64% Parks Bond Capital 751- 63,156 211,200 140,581 19,839 111,546 2,245 288,513 68,236 130,079 24,841 12,439 1,072,675 3,500,000 31% Smart Street Bond Capital 753- 986,652 285,891 512,350 617,149 341,706 1,077,051 659,978 20,695 406,356 26,452 23,673 4,957,952 10,000,000 50% Eddy St. Commons Capital 759- - - - - - - - 396,250 - - 6,000,000 6,396,250 22,500,000 28% 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 8,573,437 42,136,019 71,871,133 59% Civil City Expenses 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 35,334,410 282,973,810 361,076,344 78% 2017-12 Financial Report - Expenditure Summary 14 of 23 City of South Bend Period Ending:December 31, 2017 Expenditure Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Tax Increment Financing TIF River West - Airport 324 4,348,398 123,050 1,434,861 735,643 590,372 186,766 4,463,884 811,409 1,119,086 2,086,165 461,282 1,999,863 18,360,777 39,618,887 46% TIF West Washington 422- - 2,420 385 - - - - 65,778 4,008 - 9,485 82,076 1,428,292 6% 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 19,920 132,049 158,166 83% 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 326,980 1,957,740 10,602,696 18% TIF Southside 430 146,124 12,530 17,419 24,812 100,639 6,683 - 10,774 33,396 52,826 47,895 217,489 670,587 6,917,426 10% 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,147 1,210,493 1,488,086 2,279,003 545,084 2,573,738 29,572,822 67,378,709 44% 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 - 28,016 113,202 157,000 72% Sub Total- - 14,437 17,369 1,801,091 17,679 775 10,814 - 24,153 - 28,016 1,914,335 2,411,500 79% 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 (1,051) 14,653 15,000 98% SB Redevelopment Authority 752- 735,236 2,004,503 5 - 345,906 - - 1,475,853 - - 39,906 4,601,409 4,603,405 100% 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% 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 38,855 10,397,919 10,407,607 100% Redevelopment Commission 9,726,544 2,085,695 7,938,167 2,282,595 2,548,158 932,945 5,832,454 1,224,719 3,821,222 2,304,510 547,456 2,640,609 41,885,076 80,197,816 52% City Operations Total 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 37,975,019 324,858,886 441,274,160 74% 2017-12 Financial Report - Expenditure Summary 15 of 23 City of South Bend Period Ending:December 31, 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 Amort sch # 3 1 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 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 670,994.00 2 5 Water Works Improvements W ater 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 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 1,565,740.00 6 2 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 6 9 Water Works Improvements W ater 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 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 162,472.00 63,214.00 0.00 2,087,171.00 225,686.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 395,000.00 298,617.50 0.00 6,750,000.00 693,617.50 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 895,000.00 654,300.00 0.00 16,400,000.00 1,549,300.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 355,000.00 209,786.26 0.00 6,570,000.00 564,786.26 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 1,060,000.00 486,680.00 0.00 19,830,000.00 1,546,680.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 1,955,000.00 156,170.00 0.00 6,095,000.00 2,111,170.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 402,480.00 13 3 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 13 9 Century Center Energy Savings 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 14 1 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 14 5 Sewage W orks 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 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 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 6 8 State Rev olving Fund W ater 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 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 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 5 1 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 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 135,725.64 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.52 735.98 0.00(0.01)98,529.50 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.53 5,634.82 0.00 0.02 580,951.35 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 771.11 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 954.08 10 6 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 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 1,225.93 44.88 0.00 0.00 1,270.81 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,231.73 39.06 0.00 1.00 1,270.79 10 9 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 121.99 0.00 1.00 3,696.08 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 349,900.52 11 1 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 11 2 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 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 314,581.14 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,444.79 126.44 0.00 634.57 2,571.23 11 7 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 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,189.78 105.62 0.00 1,258.33 1,295.40 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 997.01 85.51 0.00 1,054.61 1,082.52 12 0 Water Works Olive Ricoh Copier W ater 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 12 3 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 12 4 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 12 5 HP Computer Lease #1 Computer Equipment Lease 2014 2018 v arious Monthly 8th--137,104.95 63,525.63 32,632.97 2,191.39 0.00 30,892.66 34,824.36 12 6 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 12 7 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 12 8 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 12 9 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 13 0 Solid Waste 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 13 1 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 13 2 Organic Resourc es & 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 13 4 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 13 6 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 13 7 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 13 8 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 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 712,665.36 14 3 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 14 4 PNC Vehicle Lease No. 2 Vehicle Lease Purchase 2015 2020 Various 5/15 11/15--1,267,183.00 1,021,855.36 249,615.64 14,779.24 0.00 772,239.72 264,394.88 14 6 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 14 7 Central Serv ices 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 14 8 Central Serv ices 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 2017-12 Financial Report - Debt Page 16 of 23 City of South Bend Period Ending:December 31, 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 14 9 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 15 0 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 15 1 Admin and Financ e 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 15 2 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 15 3 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 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 261,608.56 15 5 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 15 7 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 15 8 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 2,916,500.00 0.00 15 9 Mayor/Waste W ater/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 16 0 HP Computer Ref resh 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 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 0.00 xxx Total Capital Lease 34,787,495.21 16,078,945.72 4,804,968.77 245,069.65 4,574,507.34 15,848,484.29 5,047,826.02 Total Civil City 299,487,420.71 147,504,568.39 16,458,753.92 4,032,396.49 4,574,507.34 135,620,321.81 20,488,938.01 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 1 1 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 1 2 TJX Special Taxing 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 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 1,091,210.50 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 3,961,666.72 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 2,463,181.26 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 727,155.00 12 2 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 13 5 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 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 0.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 0.00 xxx Total Bond Debt 182,288,788.00 85,640,000.00 11,010,000.00 2,868,505.36 28,500,000.00 103,130,000.00 13,878,505.36 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 63,660.08 8,350.36 0.00 238,409.07 72,010.44 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 65,888.51 0.00 6 4 Interf und Fund 412 - Major Moves Douglas Road TIF 2009 2029 435 2/15 8/15--1,040,319.00 323,005.00 323,005.00 12,602.00 0.00 0.00 335,607.00 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 120,742.00 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 461,383.84 111,052.16 0.00 1,922,964.02 572,436.00 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 100,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 0.00 xxx Total Loans Payable 15,627,499.06 5,339,782.19 1,042,670.21 158,125.23 750,000.00 5,029,518.43 1,200,795.44 Leases 1 3 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 12,182,508.21 3,096,792.59 29,250,000.00 109,465,018.43 15,279,300.80 Total Debt 502,913,985.77 239,919,688.58 28,641,262.13 7,129,189.08 33,824,507.34 245,085,340.24 35,768,238.81 2017-12 Financial Report - Debt Page 17 of 23 City of South Bend Period Ending:December 31, 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 12/31/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 375,000.00 47,600.00 0.00 2,005,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 85,812.50 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 240,000.00 239,937.50 0.00 4,085,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 162,472.00 63,214.00 0.00 2,087,171.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 395,000.00 298,617.50 0.00 6,750,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 895,000.00 654,300.00 0.00 16,400,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 355,000.00 209,786.26 0.00 6,570,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 1,060,000.00 486,680.00 0.00 19,830,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 1,955,000.00 156,170.00 0.00 6,095,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 107,652.90 59,107.80 0.00 2,278,855.02 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 210,000.00 172,256.26 0.00 5,085,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 2,530,000.00 499,300.00 0.00 22,435,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 405,000.00 49,500.00 0.00 2,895,000.00 xxx Total Bond Debt 234,877,593.50 129,741,462.92 11,506,730.90 3,776,119.00 0.00 118,234,732.02 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 20,912.00 11,207.34 0.00 311,650.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 126,142.25 0.00 0.00 1,225,455.50 xxx Amy Shirk Total Loans Payable 29,822,332.00 1,684,159.75 147,054.25 11,207.34 0.00 1,537,105.50 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 1,225.93 45.39 0.00 0.00 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 3,575.09 121.99 0.00 0.00 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 2,459.28 124.64 0.00(0.02) 11 2 Ricoh USA Building Dept. Copier 2013 2018 600 Monthly--4,093.64 1,491.77 878.55 60.45 0.00 613.22 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 2,039.24 180.76 0.00 2,154.90 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,189.77 105.63 0.00 1,258.34 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 997.01 88.51 0.00 1,054.61 12 0 Water Works Olive Ricoh Copier W ater Works Olive Ricoh Copier 2013 2018 620 Monthly 10th--4,732.65 2,051.62 997.01 88.51 0.00 1,054.61 12 3 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 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 32,632.98 2,191.38 0.00 30,892.65 12 6 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 12 7 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 12 8 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 12 9 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 13 0 Solid Waste 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 13 1 Police Communications Copier Ricoh USA Copier 2014 2019 101 Monthly 12th--8,843.00 4,876.99 1,804.43 227.41 0.00 3,072.56 13 2 Organic Resourc es & 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 13 4 Water Works Copier - North Station Richo USA Copiers 2014 2019 620 Monthly 19th--4,732.65 2,132.25 992.44 93.08 0.00 1,139.81 13 6 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 13 7 Animal Control Ricoh Copier Ricoh USA Copiers 2015 2020 600 Monthly 30th--5,261.50 3,591.88 1,033.35 182.49 0.00 2,558.53 13 8 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 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 695.77 85.67 0.00 1,465.29 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 249,615.64 14,779.24 0.00 772,239.72 14 6 Parks & Recreation Copi er Ricoh Copier 2016 2020 201 Monthly 4,302.06 3,454.72 810.05 176.59 0.00 2,644.67 14 7 Central Serv ices 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 14 8 Central Serv ices Lanier Copier C6502 2016 2020 222 Monthly---11,413.00 10,059.31 2,121.84 480.36 0.00 7,937.47 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-12 Financial Report - Debt Page 18 of 23 City of South Bend Period Ending:December 31, 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 12/31/2017 15 0 HP Computer Lease Computer Lease- Refresh 2016 2020 404/641/620 Monthly---17,439.85 14,013.99 3,908.91 574.29 0.00 10,105.08 15 1 Admin and Financ e Ricoh Copier MPC8002SP Copier 2016 2021 101 Monthly---10,923.63 8,938.27 2,047.09 458.15 0.00 6,891.18 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 33,567.37 6,614.27 0.00 116,995.36 15 7 Venue, Parks, Art Copier Ricoh Copier 2016 2021 201 Monthly---3,184.06 3,184.06 918.53 382.49 0.00 2,265.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 3,285.05 843.03 15,702.09 12,417.04 16 0 HP Computer Ref resh 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 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,804,973.86 245,075.93 4,574,507.34 15,848,479.20 Total Civil City 299,487,420.71 147,504,568.39 16,458,759.01 4,032,402.27 4,574,507.34 135,620,316.72 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 415,000.00 66,300.00 0.00 1,795,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 100,000.00 0.00 0.00 100,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 394,784.38 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 11,010,000.00 2,868,505.36 28,500,000.00 103,130,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 63,660.08 8,350.36 0.00 238,409.07 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 6 4 Interf und Fund 412 - Major Moves Douglas Road TIF 2009 2029 435 2/15 8/15--1,040,319.00 323,005.00 323,005.00 12,602.00 0.00 0.00 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 461,383.84 111,052.16 0.00 1,922,964.02 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 1,042,670.21 158,125.23 750,000.00 5,030,036.48 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 12,182,507.21 3,096,793.59 29,250,000.00 109,465,537.48 Total Debt 502,913,985.77 239,919,688.58 28,641,266.22 7,129,195.86 33,824,507.34 245,085,854.20 2017-12 Financial Report - Debt Page 19 of 23 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 1,079 1,092 1,092 1,096 1,099 Part Time Staff 115 119 142 155 168 145 139 155 159 145 126 100 Temporary / Seasonal 12 11 13 41 86 206 202 80 39 30 21 5 City Total 1,207 1,199 1,237 1,274 1,330 1,444 1,430 1,314 1,290 1,267 1,243 1,204 2017-12 Financial Report - Headcount Staffing Page 20 of 23 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 7 311 Call Center 6 6 6 6 7 7 6 6 6 6 6 6 6 Admin & Finance 23 20 21 22 23 23 23 23 23 23 23 21 21 Innovation/ Technology Office 18 14 14 15 14 16 17 17 17 17 17 17 17 Safety & Risk 2 2 2 2 2 2 2 2 2 2 2 2 2 Clerk 5 5 5 5 5 5 5 5 5 5 6 5 5 Common Council 9 9 9 9 9 9 9 9 9 9 9 9 9 Central Services 40 38 39 37 37 38 39 38 38 40 40 39 40 Legal Department 11 11 11 10 10 10 10 11 9 9 9 11 10 Sub Total 121 111 113 112 112 116 119 119 117 120 120 117 117 Code Enf. /Animal Control/ Unsafe Bldg.29 24 26 28 28 29 28 29 29 29 29 29 29 Dept. of Community Investment 23 22 20 21 21 20 20 20 20 20 20 22 22 Parks & Recreation Administration 6 6 6 6 6 6 6 6 6 6 7 7 7 Maintenance 50 45 47 48 47 47 48 48 48 48 49 49 47 Golf Operations 8 7 8 7 8 8 8 8 8 8 8 8 7 Recreation Ops 21 22 21 21 21 21 22 22 22 21 21 21 21 Zoological Ops 1 1 1 1 1 1 1 1 1 1 1 1 1 Graffiti Removal 1 1 1 1 1 1 1 1 1 1 1 1 1 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 10 Sub Total 98 91 95 95 95 95 96 96 96 95 97 97 94 Public Safety Police 289 284 272 282 280 278 288 283 280 280 280 285 285 Fire 264 268 267 266 263 261 259 260 260 270 270 270 272 Sub Total 553 552 539 548 543 539 547 543 540 550 550 555 557 Public Works Office of Sustainability 2 2 2 2 2 2 2 2 2 2 1 1 1 Engineering 18 18 18 20 20 20 20 20 20 18 17 17 18 Solid Waste Operations 26 25 25 26 25 24 25 25 26 25 25 25 23 Street Operations 55 54 54 54 54 53 56 54 52 52 53 53 55 Sewer Operations 621 37 37 37 37 37 35 37 37 37 37 37 37 38 Waste Water Ops 630 45 45 45 44 44 45 45 45 42 45 44 44 45 Organic Resources 6 6 5 5 6 6 6 6 6 6 6 6 6 Water Utility Ops 65 64 63 63 63 64 65 66 65 66 66 66 66 Sub Total 254 251 249 251 251 249 256 255 250 251 249 249 252 Building Department 14 14 14 14 14 14 14 14 14 14 14 14 14 Human Rights 6 6 6 6 6 6 5 5 5 5 5 5 5 Morris & Palais 9 9 7 7 8 8 8 8 8 8 8 8 9 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 1,099 2017-12 Financial Report - Headcount Staffing Page 21 of 23 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 2 Admin & Finance 0 0 0 0 0 0 0 0 0 1 1 1 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 1 Legal Department 1 1 1 1 1 1 1 1 1 1 1 1 Sub Total 6 5 5 3 3 4 4 4 4 4 5 5 Code Enf. / Animal Control 3 2 3 3 3 4 4 4 4 4 5 4 Dept. of Community Investment 0 0 0 0 0 0 0 0 0 0 0 1 Parks & Recreation Administration 1 1 1 1 1 1 0 1 1 0 1 1 Maintenance 11 11 11 15 14 13 13 14 14 12 12 10 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 33 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 1 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 45 Public Safety Police 25 25 29 27 27 10 5 26 28 27 29 26 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 1 Sub Total 25 25 29 27 27 11 6 27 29 28 30 27 Public Works` Engineering 2 2 2 3 2 2 2 2 3 4 4 2 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 9 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 3 Sub Total 12 13 13 14 13 12 13 13 16 15 16 14 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 4 City Total 115 119 142 155 168 145 139 155 159 145 126 100 2017-12 Financial Report - Headcount Staffing Page 22 of 23 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 1 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 2 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 3 Public Safety Police 0 0 0 0 0 14 14 5 1 1 1 1 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 1 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 1 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 1 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 5 2017-12 Financial Report - Headcount Staffing Page 23 of 23