Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
12-2016 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-10 City Revenues Prop Tax Rev 11-12 Property Tax Revenue Collection Status Expenditures 13-17 Expenditures by Fund and Department Debt 18-19 Debt Status Debt Monthly 20-21 Current Debt at Month End Headcount 22-25 Staffing Levels Distribution Mayor Pete Buttigieg Chief of Staff James Mueller Deputy Chief of Staff Suzanna Fritzberg Controller John Murphy Deputy Controller Jennifer Hockenhull City Finance Director Rahman Johnson Sr. Budget Analyst Amy O'Connor Department Heads Fiscal Officers City Common Council December 31, 2016 Controller Financial Report December 2016 Page 1 of 25 December 31, 2016 Financial Report The Financial Report provides current year financial information for each City fund in a condensed format. Information is provided for revenue (by type and fund), expenditures, property taxes, debt status, and staffing levels. This report is prepared monthly and supplements other reports that the City prepares such as the Controller's Cash Report, the Monthly Departmental Financial Report, and the Comprehensive Annual Financial Report (CAFR). Revenue by Type Revenue by Fund -Fund 291 (River Rescue). This is revenue related to training. Revenue is generated from registration fees. -Fund 258 (Human Rights). This is revenue related to grants received to battle housing and employment discrimination. -Fund 401 (Four Winds Field). This fund has exceeded its budgeted revenue by $25,955 or 267%. The City received $40,862 as an attendance bonus for the baseball stadium. -Fund 677 (Hall of Fame), is at 99% of its budgeted revenue. This is revenue received in the amount of $48,709 for the sale of the property, for construction of a new motel. -Fund 661 (2012 Sewer Bond), is at 99% of its budgeted revenue. This is revenue from bank and investment interest. Property Taxes Total property taxes collected for the year 2015 was~$70.9 million or 94.76%of the tax levy.Specifically,in 2015 the City of South Bend received a total of$46,171,932 in property tax revenue in the civil city funds(general fund,parks,College Football Hall of Fame,and CCD). For TIF funds, the City received a total of $24,742,902 in property tax revenue. Expenditures Debt Headcount If you have any questions regarding this report, please contact John Murphy at (574) 235-7678. As of December 2016,the City has spent 77%of budgeted expenditures,compared to 76%in December 2015.The General Fund has spent 95%of its 2016 budgeted expenditures,versus 97%in 2015.The following funds have reached 90%or more of their budgeted expenditures as a result of bond payments:Fund 313(Hall of Fame),Fund 410(UDAG),Fund 377(Professional Sports Development), and Fund 432 (TIF - Erskine Village). This month,various debt service payments were made in the amount of~$8.7 million to Sun Trust,Kansas State Bank,PNC Bank,U.S. Bank and Ricoh USA.Payments are related to IT equipment leases,police/public works vehicles,solid waste containers,and sewer bonds. The Full Time Headcount as of December was 1,079 vs.a budgeted amount of 1,102.Currently,there are a total of 23 vacant positions. The 23 open positions are in the following departments:General Government(1),Parks(2),Public Safety(9),Public Works(5),DCI(2), Code Enforcement / Animal Control (2), and Morris / Palais (2). For discussion on property taxes,see section listed below.The overall percentage of budgeted revenues that have been received by the city is 96%,compared to 99%in December 2015.Revenue type 369(Memorial Hospital)has reached 100%of its budgeted revenue.This is revenue from Leighton Plaza for common area fees.It is a lease between Memorial Hospital and the South Bend Redevelopment Commission.Also,all tax revenue types(311,316,312,and 335)have reached 100%of budgeted revenues.These consist of property, income, excise, and hotel/motel tax. As of December 2016,the general fund has reached 100%of its budgeted revenue,compared to 99%last year.The following funds have reached slightly above the normal percentage of their 2016 budgeted revenue amount at this time: Property taxes are received in June and December.Property taxes collected in 2016 totaled~$76.7 million.Civil city funds received ~$49.1 million and TIF funds received~$27.6 million.For 2016,the projected levy collection rate is 95%or$75.2 million.Please note, 2016 civil city funds are ~$2.4 million more than 2015 budget. - Funds 249 (PS LOIT), 404 (COIT), and 408 (EDIT) received normal and timely distributions this month. Financial Report December 2016 Page 2 of 25 City of South Bend Period Ending:December 31, 2016 Revenue by Type Report $ Fund% Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Property Tax 311 Property Tax Civil City various- - - - - 26,788,327 - - - - 22,279,206 49,067,532 49,067,534 100% 311 Property Tax TIF Districts various- - - - - 14,767,546 - - - - 12,873,336 27,640,882 28,042,276 99% Sub Total- - - - - 41,555,873 - - - - - 35,152,542 76,708,415 77,109,810 99% Income Tax 315 Econ Development Income Tax 408 799,550 799,550 799,550 799,550 799,550 799,550 799,550 799,550 799,550 799,550 799,550 799,550 9,594,602 9,594,602 100% 316 Rainy Day Fund 102- - - - 1,405,850 - - - - - - - 1,405,850 1,405,850 100% 316 Local Option Income Tax - PS 249 565,930 565,930 565,930 565,930 565,930 565,930 565,930 565,930 565,930 565,930 565,930 565,930 6,791,160 6,791,160 100% 316 LOIT 2016 Special Distribution 257- - - - 4,217,550 - - - - - - - 4,217,550 4,217,550 100% 316 County Option Income Tax 404 787,835 787,835 787,835 787,835 787,835 787,835 787,835 787,835 787,835 787,835 787,835 787,835 9,454,023 9,454,023 100% Sub Total 2,153,315 2,153,315 2,153,315 2,153,315 7,776,715 2,153,315 2,153,315 2,153,315 2,153,315 2,153,315 2,153,315 2,153,315 31,463,185 31,463,185 100% St Joseph County (Remitted by) 312 Auto Excise Tax various- - - - - 1,573,554 - - - - - 1,700,670 3,274,224 3,195,000 102% 312 Commercial Vehicle Tax various- - - - - 414,809 - - - - - 414,807 829,616 824,700 101% 317 Hotel Motel Tax Century Center 670 656,725 - - - - - - 656,725 - - - - 1,313,450 1,313,436 100% 317 Hotel Motel Tax Century Center 324- 198,500 - - - - - 197,500 - - 396,000 396,000 100% 317 Hotel Motel Tax Cum Cap Imprv 407 150,000 - - - - - - - - - - - 150,000 150,000 100% Sub Total 806,725 - - 198,500 - 1,988,363 - 656,725 - 197,500 - 2,115,477 5,963,290 5,879,136 101% State of Indiana (Remitted by) 312 CRED Tax 434- - - - - - - - - - - - - - NA 335 Cigarette Tax 101/407- - - - - 154,629 - - - - - 173,388 328,017 331,000 99% 335 State Pension Subsidy 701/702- - - - - 5,432,011 - - 5,426,011 - - - 10,858,021 10,858,021 100% 335 Gaming Proceeds 101- - - - - - - - 599,005 - - - 599,005 600,000 100% 335 Gasoline Tax 202/251 364,876 317,613 402,674 503,137 412,761 385,178 414,091 459,818 363,325 376,739 335,656 351,141 4,687,007 4,708,562 100% 335 Liquor Excise tax 101 44,798 - - - - 29,634 - - - - - - 74,432 74,432 100% 335 Liquor Gallonage Tax 101 57,692 - - 46,627 - - 55,925 - - 54,298 - - 214,542 200,000 107% 335 Prof Sports Development Tax 377 149,007 47,449 64,753 42,616 110,536 42,482 48,204 37,777 39,290 54,099 54,640 69,537 760,390 760,390 100% 335 Wheel Tax 202- - 510,537 217,294 223,843 - - 552,331 178,576 168,462 155,505 - 2,006,547 2,050,000 98% Sub Total 616,372 365,062 977,964 809,675 747,140 6,043,933 518,220 1,049,926 6,606,207 653,597 545,801 594,065 19,527,961 19,582,405 100% Other Intergovernmental Sources 336 Federal Drug 299- - - - - 1,093 - 4,178 5,515 - - - 10,786 160,000 7% 337 State Drug 216 11,910 3,173 - 764 - 9,402 - 2,659 - 2,275 - 1,762 31,946 35,000 91% 338 Payment in Lieu of Tax various 475,984 475,984 475,984 475,984 475,984 475,984 475,984 475,984 475,984 475,984 475,984 475,984 5,711,808 5,711,803 100% 339 Contractual Service 211 33,285 2,800 73,688 70,185 14,297 6,255 15,512 16,400 1,300 48,511 10,385 10,519 303,136 309,000 98% Sub Total 521,179 481,957 549,672 546,933 490,281 492,734 491,496 499,222 482,799 526,770 486,369 488,265 6,057,676 6,215,803 97% Charge for Service Internal City 340 Liability Insurance 226 183,301 185,290 183,301 189,268 183,301 183,301 187,279 183,301 187,279 183,301 189,268 183,301 2,221,491 2,223,483 100% 340 General Government Misc Chgs 101/289 35 20 - - - - - - - 120 - 64 239 6,000 4% 340 Police Take Home Vehicle 278 4,470 4,480 4,440 4,430 4,370 4,360 6,480 4,260 4,210 4,180 4,180 6,240 56,100 60,400 93% 349 Central Service 222 45,449 49,306 55,097 49,813 48,540 48,795 49,733 60,169 64,835 57,699 60,814 56,369 646,619 760,564 85% 380 Central Service 222 173,853 194,647 195,047 196,211 226,068 213,522 172,098 205,157 187,460 186,827 160,735 188,311 2,299,936 2,895,458 79% 380 Energy Office Reimbursements 222 338,206 425,619 387,718 342,687 355,964 331,820 370,329 407,639 357,599 376,967 282,039 441,616 4,418,203 4,589,542 96% 380 Internal Service Reimbursement various 332,216 151,731 95,086 261,942 144,655 90,363 168,857 142,885 145,243 154,336 113,269 196,897 1,997,479 2,255,041 89% 392 Administration Fee 101/279 357,493 357,917 358,676 358,565 358,996 357,616 370,395 355,999 355,963 356,553 355,276 369,037 4,312,486 4,323,915 100% 392 Internal Fund Transfers various 3,384,665 2,063,476 950,537 2,621,591 937,936 851,889 3,940,226 2,091,382 2,505,244 943,321 2,985,581 1,206,568 24,482,414 24,745,242 99% 395 Employee Benefits 711/713 1,380,393 1,364,636 1,389,431 1,404,154 1,395,299 1,386,929 1,412,570 1,363,218 1,387,295 1,389,577 1,381,129 1,386,961 16,641,593 17,257,182 96% Fin anc i al Re port Decembe r 2016 - Revenu e Report Page 3 of 25 City of South Bend Period Ending:December 31, 2016 Revenue by Type Report $ Fund% Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget 396 Central Service Refunds 222 1,725 1,337 - 3,051 1,775 - - 5,011 - 2,929 1,435 1,332 18,596 23,760 78% 396 Self Funded Employee Benefits 711 473 (217) - 140,236 20,511 446,817 151,808 113,592 93,856 69,847 476,294 72,386 1,585,602 850,000 187% Sub Total 6,202,279 4,798,241 3,619,332 5,571,947 3,677,416 3,915,414 6,829,774 4,932,614 5,288,982 3,725,657 6,010,020 4,109,082 58,680,758 59,990,587 98% 3rd Party Revenue 340 ND EMS Service 288- 1,365 - 54,110 - 20,786 10,478 3,944 - - 15,330 88,619 194,631 197,000 99% 340 Memorial Hospital Neo Natal 101 647 47 378 217 249 (1,538) - - - - - - - - NA 350 Job Target Penalty Fee 408- - 354,660 - - - - - - - - - 354,660 354,660 100% 364 Cable TV Franchise Fees 101- 182,827 - - 190,852 - - 193,266 - - 182,621 - 749,565 749,566 100% 366 AT&T Franchise Fees 101- 70,747 - - 65,898 - 63,695 - - - 56,271 - 256,611 284,000 90% 393 Sewer Bond Issuance 666- - - - - - - - - - - - - - NA Sub Total 647 254,986 355,038 54,327 256,999 19,248 74,173 197,210 - - 254,222 88,619 1,555,468 1,585,226 98% Grants 331 Federal Grants various 403,236 157,635 297,708 46,144 151,776 96,645 44,280 227,011 820,901 935,639 1,083,705 401,031 4,665,711 8,928,458 52% 332 Solar Energy Grant 222- - - - - - - - - - - - - - NA 334 State Grants various- - 300,000 767,681 - 7,550 - 944,679 27,520 117,804 37,434 - 2,202,668 3,025,381 73% Sub Total 403,236 157,635 597,708 813,825 151,776 104,195 44,280 1,171,690 848,421 1,053,444 1,121,139 401,031 6,868,379 11,953,839 57% Fees for Services External 320 Inspections Central Service 222 10 - - 400 100 190 60 10 - 30 320 - 1,120 1,450 77% 321 Business License 101/222 32,554 24,820 20,230 10,462 8,197 5,709 7,426 2,513 12,054 2,091 1,818 190 128,062 131,447 97% 321 Code and Animal Fees 600 5,176 4,450 6,783 3,752 4,533 5,604 5,204 6,730 4,118 5,039 4,390 3,910 59,688 69,650 86% 322 Building Fees 600 130,183 80,592 79,905 112,379 109,622 112,948 96,028 135,207 89,099 144,341 142,526 90,931 1,323,760 1,404,751 94% 322 Code Enforcement Fees 600 1,757 830 2,321 2,455 1,840 1,550 350 1,722 993 1,254 1,700 400 17,171 19,000 90% 322 EMS Operating Fund 288 1,190 2,555 1,352 1,356 2,055 3,390 1,428 904 1,147 2,046 2,389 1,190 21,002 25,500 82% 322 General Government Fees 101 2,655 1,925 3,015 13,803 3,515 4,535 7,670 7,600 5,740 5,795 7,770 11,758 75,781 78,198 97% 341 General Government Various various 976 956 9,068 2,129 1,047 2,835 644 1,422 11,390 3,139 1,824 4,686 40,117 41,505 97% 342 Highway & Streets 101/202 18,716 20,087 11,180 56,028 - 51,440 15,541 - - 11,482 - 32,158 216,632 281,433 77% 342 Public Safety various 23,010 20,523 14,085 13,039 11,112 10,514 11,024 11,369 9,212 12,828 11,840 15,769 164,324 145,000 113% 342 EMS - County Fees 288 289,512 144,756 144,756 144,756 144,756 144,756 144,756 144,756 144,756 144,756 144,756 - 1,737,069 1,740,000 100% 342 EMS - Capital Fund 287- 1,307,757 - - - - 460,971 378,271 - 313,776 - - 2,460,775 3,228,017 76% 342 EMS - Operating Fund 288 139,138 306,076 266,273 233,647 193,550 235,987 267,852 263,602 255,952 290,679 327,577 228,908 3,009,240 3,050,000 99% 342 EMS - Neo Natal / Transport 288 42,424 41,856 44,710 41,615 45,900 50,910 41,207 49,914 38,409 38,590 37,768 42,465 515,767 529,512 97% 344 Solid Waste 610 404,906 430,823 441,553 446,119 446,975 527,974 367,501 447,774 441,737 416,079 443,665 442,709 5,257,814 5,552,249 95% 344 Code Environmental Clean Up 101/219/600 17,032 19,170 15,674 15,947 17,270 20,894 17,264 17,069 17,271 24,089 24,443 22,206 228,328 241,000 95% 344 Sewage Waste Water 641 2,955,939 3,016,097 3,151,663 3,169,875 3,269,462 4,127,814 2,374,947 3,277,047 3,398,941 3,199,499 3,248,649 3,189,258 38,379,190 38,705,245 99% 344 Sewer Repair Insurance 640 52,097 51,842 51,161 51,987 51,750 61,752 42,460 52,629 52,479 53,146 52,180 53,338 626,821 608,145 103% 344 Water Leak Insurance 620 80,826 80,619 80,821 80,957 82,226 95,542 67,199 81,504 81,333 81,267 81,369 81,407 974,067 975,960 100% 346 Water Works Utility 620 990,163 1,008,174 1,034,732 1,005,700 1,020,900 1,495,842 1,275,770 1,497,061 1,379,103 1,207,590 1,138,205 1,013,754 14,066,994 14,167,156 99% 346 Solid Waste Misc 610 565 2,084 1,717 22,521 25,218 34,062 22,182 28,945 28,706 30,015 28,457 224 224,692 256,000 88% 346 Project ReLeaf 655 36,589 36,432 36,616 36,712 36,848 43,582 30,272 36,993 36,941 36,903 35,883 36,878 440,649 440,650 100% 347 Parks & Recreation various 79,924 101,243 290,639 216,615 287,997 356,118 358,015 367,121 257,367 120,331 53,773 144,950 2,634,093 3,409,605 77% 347 Sale of Merchandise 101 10 40 30 30 - 20 - 10 20 - - - 160 140 114% 347 Morris PAC 416 5,076 2,700 7,087 4,195 20,270 2,427 - 1,379 28,415 5,628 9,401 15,203 101,781 101,781 100% 349 Parking Garage Fees 601 82,893 80,963 84,467 77,393 94,198 70,609 53,913 82,771 111,068 148,658 63,987 58,633 1,009,552 936,101 108% 349 Code Demolition Board Up 219/600 1,095 7,958 23,676 5,554 (2,916) 28,579 7,878 29,172 9,591 - 17,637 3,062 131,284 224,100 59% 349 Parking Century Center 670 8,744 17,522 20,578 3,525 9,972 9,053 3,628 6,411 8,462 12,393 4,105 3,779 108,172 100,033 108% 349 Parking SBCDA 324/420429- - - - - - - 350 - 350 700 - 1,400 3,500 40% 351 Fines & Fees various 235,002 24,915 19,359 13,088 33,758 11,988 64,255 26,657 31,115 22,627 26,094 30,723 539,581 584,060 92% 352 Forfeits various 2,018 10,760 7,990 4,877 11,115 95,646 18,108 6,526 1,703 3,471 2,382 84,319 248,914 258,100 96% 354 Ordinance Violation various 1,210 2,514 13,097 2,689 27,101 (3,254) (7,426) 4,630 2,273 4,490 5,200 3,576 56,098 89,200 63% 360 Morris PAC various 31,967 25,382 167,961 38,667 145,583 113,944 3,163 12,797 481,150 80,336 75,277 262,413 1,438,642 1,438,645 100% 360 Palais Royale various 6,522 6,401 7,587 11,398 29,700 19,758 20,778 61,975 12,071 15,107 23,618 20,671 235,587 235,588 100% 360 Parks & Recreation various 9,797 7,359 2,837 5,880 7,740 5,072 10,194 3,184 7,389 10,924 3,723 3,787 77,887 99,071 79% 360 Police various 3,295 12,706 1,450 6,430 866 18,097 1,415 21,473 768 19,144 16,726 1,761 104,130 61,218 170% 360 Fire various- 9,485 - - - 150 - - - - - - 9,635 9,685 99% 360 TIF various 2,574 1,932 3,647 1,317 4,609 3,558 2,090 415 66,134 19,942 2,175 2,475 110,868 204,806 54% 360 Central Services 222 74 - 316 69 - 239 474 3,994 156 331 60 37,449 43,162 11,000 392% 360 Century Center 670 379 6,169 745 13 350 - 1,052 1,287 - 224 (180) - 10,038 8,707 115% 360 Dept. Of Community Investment 211/212 9 1,428 1,164 12 - - - - - - - - 2,613 893,648 0% 360 Economic Dev. State Grant 210- - 2,208 - - - - - - 1,170 - - 3,378 3,378 100% 360 EMS Operating Fund 288 200 - - 72,825 300 1,413 3,296 553 1,827 450 1,200 3,883 85,948 87,087 99% 360 Engineering / Curb & Sidewalk 101 75 1,901 70 - 350 475 150 1,471 300 200 - - 4,992 78,349 6% 360 Fire and Police Pension Fund 701/702- - - - - 3,080 - 1,564 - 11,721 1,088 1,600 19,052 19,080 100% 360 Self Funded Employee Benefits 711- - - - - - - - - - - - - - NA 360 General Government Various 101/3/226 13,698 25 345 332 186 232 1,883 139 - 356 120 1,108 18,423 33,998 54% 360 Motor Veh Highway Scrap Metal 202 456 299 747 - 1,180 - 418 316 154 355 344 367 4,637 4,637 100% 360 Motor Veh Highway Curb Prgm 202 2,029 1,978 1,419 1,836 1,033 865 751 703 664 - 131 35 11,445 60,000 19% Fin anc i al Re port Decembe r 2016 - Revenu e Report Page 4 of 25 City of South Bend Period Ending:December 31, 2016 Revenue by Type Report $ Fund% Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget 360 Local Roads and Streets 251- 435 400 117 - - 8,723 11,402 389 14,841 1,741 - 38,049 38,600 99% 360 Professional Sports Development 377 24,026 - - - - - 20,955 - - - - - 44,981 48,263 93% 360 C.O.I.T.404- - 526 - - - - - - - - - 526 526 100% 360 CCI / EDIT 407/408- - - - - - 2,766 - - - - - 2,766 2,766 100% 360 UDAG 410- - - - - - - - - - 195,491 - 195,491 195,517 100% 360 Code / Animal Control 600 23 - - 6,646 - - - - - 280 38 15 7,002 12,000 58% 360 Building Fees 600- - 17 - - - - - - - - - 17 100 17% 360 Parking Garage 601- - - 7 - - - 106 - - - - 113 7 1614% 360 Solid Waste Fund 610- - 265 - 153 - - 328 - 136 - 156 1,037 2,500 41% 360 Waste Water 641/7/9- 2,332 550 6,454 3,473 2,197 1,189 - - 165 30,711 4,347 51,418 69,526 74% 360 Water Works Utility 620- - - 11 23,084 - - 1,356 - - - 16,888 41,340 77,000 54% 360 Water Works Bond Reserve 626- - - - - - - - - - - 330,000 330,000 330,000 100% 362 Dept. Of Community Investment 212- 1,847 - 1,847 - - 1,847 - - - 1,847 - 7,387 8,000 92% 362 Palais Royale 101- 2,069 1,849 7,643 10,881 6,791 - 17,333 5,955 8,727 5,339 4,423 71,010 71,500 99% 362 Police 101 7,363 27,562 - - 7,198 - - - - - 14,664 - 56,788 42,123 135% 362 Parks & Recreation 201 1,506 2,558 6,226 3,896 5,331 3,179 2,797 2,832 1,823 705 673 767 32,292 43,000 75% 362 S Bend School Corp Fee 407- - - - - - - 25,000 - - - - 25,000 25,000 100% 362 Certified Technology Park 439- - - - - - - - - - - - - - NA 362 TIF Property various 16,786 16,360 16,697 9,116 17,555 16,652 22,814 10,214 261,624 20,458 20,533 16,333 445,139 481,098 93% 362 Self Funded Employee Benefits 711- - - - - - - - 500 - 335 - 835 - NA 369 Memorial Hosp Leighton Plaza 408 150,000 - - - - - - - - - - - 150,000 150,000 100% 371 Century Center Fees 670 124,325 373,230 204,013 117,602 254,965 209,879 147,114 202,104 256,939 194,209 63,571 668,906 2,816,857 2,582,808 109% 399 Bosch Retention Project 210 15,160 - - - 15,274 - - - - - - 46,512 76,946 76,946 100% 399 Principal on Loan various 633 19,550 19,146 19,749 19,552 19,646 19,005 20,636 22,014 19,807 19,597 19,848 219,183 227,788 96% 399 Principal Income various 146,068 586,589 - - - - - 100,000 92,105 647,777 - - 1,572,539 1,597,350 98% Sub Total 6,198,350 7,958,632 6,324,721 6,105,467 6,507,732 8,034,240 6,029,001 7,469,249 7,671,356 7,409,746 6,399,628 7,060,128 83,168,249 86,729,803 96% Interest Income 361 Bank Account Interest various 364,372 78,487 115,853 175,196 221,033 185,133 100,150 104,245 264,297 152,998 130,028 226,245 2,118,037 2,223,328 95% Sub Total 364,372 78,487 115,853 175,196 221,033 185,133 100,150 104,245 264,297 152,998 130,028 226,245 2,118,037 2,223,328 95% Donations 367 ND Contribution 101- - - - - - 330,000 - - - - - 330,000 337,500 98% 367 Donations various- 15 318 100 345 165 765 135,075 745 434 236 21,975 160,172 367,500 44% Sub Total- 15 318 100 345 165 330,765 135,075 745 434 236 21,975 490,172 705,000 70% Historic Preservation 368 Lamppost Program 227- 250 (250) - - - - - - - - - - - NA 368 C.O.I.T.404- - 500 - - 5,110 2,620 - - - - - 8,230 37,500 368 Palais 450- 2,117 298 727 1,110 1,345 1,020 2,644 1,104 1,295 2,360 1,733 15,753 17,000 93% Sub Total- 2,367 548 727 1,110 6,455 3,640 2,644 1,104 1,295 2,360 1,733 23,983 54,500 44% Sale of Assets 391 TIF (Property Sales / Land)various- - 48,755 6,780 243,237 5,000 79,974 - - 75,001 - - 458,746 458,791 100% 391 Property Sales 677- - - 48,709 - - - - - - - - 48,709 48,709 100% 391 Water Hydrant Reimbursement 620- - - - - - - - - - - - - 22,500 0% 391 Proceeds F.A. Disposal 600- - - - - - - - - - - - - 3,000 0% 391 Sale of Fixed Assets various- - - - 22 - - 107,230 - - - - 107,252 125,708 85% 391 Vehicle Damage Reimbursement various- - - 4,971 - - - - - 540 - - 5,511 6,000 92% Sub Total- - 48,755 60,459 243,259 5,000 79,974 107,230 - 75,541 - - 620,218 664,708 93% Revenue Total 17,266,476 16,250,698 14,743,224 16,490,472 20,073,804 64,504,067 16,654,787 18,479,145 23,317,226 15,950,297 17,103,117 52,412,477 293,245,790 304,157,331 96% report 17,266,476 16,250,697 14,743,225 16,490,472 20,073,804 64,504,068 16,654,787 18,479,145 23,317,226 15,950,297 17,103,117 52,412,477 293,245,789 304,157,331 (0) 0 (0) - 1 (0) 0 0 - - 0 - 0 - Fin anc i al Re port Decembe r 2016 - Revenu e Report Page 5 of 25 City of South Bend Period Ending:December 31, 2016 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget General Government 0000 General Revenues 101 890,848 998,846 744,957 796,087 985,410 23,897,865 1,176,310 914,711 1,347,686 779,300 1,298,704 20,347,955 54,178,681 54,049,882 100% 0101 Mayor 101 160 40 105 105 - 20 150 10 20 - - - 610 1,090 56% 0104 311 Call Center 101 2,224 1,586 - - - - - - - - 3,810 3,810 100% 0201 Clerk 101- - - - - - - - - - - NA 0301 Common Council 101- - - - - - - - - - - - - 250 0% 0401 Administration and Finance 101 13,548 - - - - 2,493 - 122 - - - 536 16,700 13,598 123% 0501 Legal 101- - - 37,719 - 43 20,208 10 - 18,475 10 22 76,486 50,000 153% Sub Total 904,556 998,886 747,286 835,497 985,410 23,900,422 1,196,668 914,853 1,347,706 797,775 1,298,714 20,348,512 54,276,287 54,118,630 100% Public Works 0602 Engineering 101 32,123 1,901 20 - 1,366 475 150 8,991 6,040 5,995 7,770 13,008 77,839 175,449 44% Sub Total 32,123 1,901 20 - 1,366 475 150 8,991 6,040 5,995 7,770 13,008 77,839 175,449 44% Public Safety 0801 Police 101 41,628 60,405 4,103 14,376 21,337 26,673 27,706 54,352 4,775 38,082 58,059 3,800 355,298 410,916 86% 0901 Fire 101 682 10,102 378 217 249 7,646 - - - 120 - 64 19,458 26,269 74% Sub Total 42,311 70,507 4,481 14,593 21,586 34,319 27,706 54,352 4,775 38,202 58,059 3,865 374,756 437,185 86% Code Enforcement 1201 Code 101- - - - - - - - - - - NA 1203 Code Hearing 101- - - - - - - - - - - NA 1204 Code Junk Vehicle 101- - - - - - - - - - - NA 1205 Code Unsafe Building 101- - - - (5,961) (726) - - - - - - (6,687) - NA 1207 Code Animal Control 101- - - - - - - - - - - - - - NA xxx xxx- - - - - - - - - - - NA Sub Total- - - - (5,961) (726) - - - - - - (6,687) - NA Arts & Culture 0404 Morris PAC 101 31,617 24,482 165,280 38,247 145,434 113,324 3,387 10,641 477,296 80,578 74,458 260,897 1,425,641 1,425,645 100% 0405 Palais Royale 101 6,762 9,025 10,036 19,597 43,525 28,507 22,416 83,786 19,219 25,015 31,477 27,318 326,684 327,175 100% xxx xxx- NA Sub Total 38,380 33,507 175,316 57,845 188,959 141,832 25,803 94,427 496,515 105,592 105,934 288,215 1,752,325 1,752,820 100% General Fund Revenue Total 1,017,369 1,104,801 927,103 907,934 1,191,361 24,076,322 1,250,328 1,072,623 1,855,036 947,565 1,470,477 20,653,600 56,474,519 56,484,084 100% Financial Report Dec ember 2016 - R evenue Summa ry Page 6 of 25 City of South Bend Period Ending:December 31, 2016 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Parks & Recreation 0000 Parks General revenue 201 86,846 78,467 78,887 78,950 78,001 4,714,127 85,325 79,969 81,275 79,172 78,507 4,013,061 9,532,588 9,513,502 100% 1100 Administration 201 1,508 2,562 6,228 3,901 5,335 3,189 2,809 2,876 1,830 709 675 767 32,390 43,600 74% 1101 Maintenance 201 6,220 7,757 3,806 24,061 29,277 30,532 33,825 36,814 42,143 30,568 3,481 60,172 308,655 343,482 90% 1102 Golf Operations 201 983 7,988 144,933 105,695 181,202 205,048 210,590 205,738 125,630 66,169 23,992 6,952 1,284,921 1,472,107 87% 1103 Recreation Division 201 21,022 6,327 584 1,430 1,528 24,158 39,478 29,278 3,696 1,061 95 1,222 129,879 168,640 77% 1104 Potawatomi Zoo 201- - - - - - - - - 1 - 1 - NA 1108 Graffiti Removal 201- - 15,856 - 14,599 7,503 - 9,273 - 14,611 - - 61,843 99,694 62% Recreation Non Reverting 203 59,146 87,227 144,974 91,318 83,304 101,600 77,871 98,280 53,263 34,021 30,330 82,070 943,402 1,448,565 65% East Race Waterway 271 2 0 1 1 1 1 1 1 2 1 1 1 12 30 41% Coveleski Stadium 401 137 30 40 52 33 56 28 28 40,862 52 62 76 41,455 15,500 267% Zoo Endowment 403 82 18 27 42 27 46 23 23 59 36 30 40 453 359 126% Park Non Reverting 405 925 446 753 1,109 1,154 1,078 868 694 633 262 289 301 8,514 162,500 5% Sub Total 176,871 190,822 396,090 306,558 394,460 5,087,338 450,818 462,974 349,392 226,664 137,464 4,164,663 12,344,113 13,267,979 93% Public Works Motor Vehicle Highway 202 1,148,770 254,903 834,492 1,866,801 551,533 347,166 1,175,464 1,009,745 466,062 468,921 1,242,593 297,129 9,663,579 9,841,002 98% Central Services 222 561,404 671,636 638,910 593,185 633,048 595,810 598,585 690,736 614,356 626,619 506,292 736,347 7,466,928 8,312,971 90% Central Services Capital 224 313 68 94 139 89 102 22 17 33 - 130,519 34 131,432 131,453 100% Local Roads & Streets 251 305,371 115,867 97,202 170,056 92,992 105,483 164,231 38,633 198,037 164,491 94,725 95,057 1,642,147 1,930,100 85% Project ReLeaf 655 38,110 36,779 37,150 37,561 37,403 44,224 30,606 37,337 37,873 37,486 36,391 37,546 448,466 448,628 100% Sub Total 2,053,969 1,079,254 1,607,849 2,667,743 1,315,066 1,092,786 1,968,907 1,776,468 1,316,361 1,297,516 2,010,521 1,166,113 19,352,551 20,664,154 94% Public Works Solid Waste Solid Waste Operations 610 405,999 459,788 443,628 468,863 472,529 562,429 389,909 500,004 470,868 475,238 472,348 443,452 5,565,056 5,863,990 95% Solid Waste Capital 611 251,011 25 311,000 40 160 196 251,088 150,136 222 134 106 262,030 1,226,149 1,226,547 100% Sub Total 657,011 459,812 754,629 468,904 472,689 562,624 640,997 650,140 471,090 475,372 472,455 705,481 6,791,205 7,090,537 96% Public Works Water Utility 0000 Water Works Revenues 620 925,034 941,353 967,601 950,561 975,856 1,368,739 1,139,563 1,360,643 1,281,269 1,111,546 1,058,850 963,880 13,044,896 13,216,156 99% 0630 Water Leak Insurance 620 80,826 80,619 80,821 80,957 81,226 95,542 67,199 81,504 81,333 81,267 81,369 81,407 974,068 975,960 100% 0660 Clay Water 620 73,493 71,779 73,463 73,819 75,270 134,488 139,953 151,219 108,084 102,782 84,784 74,943 1,164,077 1,175,500 99% Waterworks Capital 622 4,768 1,055 1,599 2,451 1,573 2,678 1,324 1,300 3,198 1,847 1,566 2,064 25,424 28,000 91% Waterworks Construction 623- - - - - - - - - - - - - - NA Waterworks Deposit 624 2,502 553 840 1,291 830 1,418 701 696 1,822 1,098 931 1,229 13,911 15,000 93% Waterworks Sinking 625 171,062 170,519 170,664 170,915 170,870 791 341,398 170,822 171,674 171,327 171,322 171,985 2,053,350 2,053,681 100% Waterworks Bond Reserve 626 2,662 589 892 1,380 882 1,496 745 734 1,916 1,150 997 331,339 344,781 346,000 100% Waterworks Debt Reserve 629 3,696 228,278 1,287 2,091 1,341 2,287 1,130 1,121 2,929 1,758 1,489 1,966 249,373 250,461 100% Sub Total 1,264,042 1,494,746 1,297,166 1,283,466 1,307,847 1,607,437 1,692,013 1,768,041 1,652,225 1,472,775 1,401,309 1,628,813 17,869,880 18,060,758 99% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 54,828 52,457 52,097 53,443 52,682 63,336 43,244 53,415 54,554 54,409 53,261 54,777 642,503 624,151 103% 0000 Wastewater Revenues 641 2,797,138 2,842,869 2,979,437 2,997,625 3,091,630 3,954,090 2,191,654 3,086,763 3,229,888 2,995,567 3,094,077 3,013,370 36,274,108 36,634,074 99% 0621 Sewer Department 641- - - 1,164 - 1,185 14,145 - - 623 - 17,117 17,117 100% 0625 Concrete Crew 641- 3,786 - 6,781 5,679 3,045 - - - - 21,733 9,128 50,151 74,500 67% 0630 Wastewater Operations 641- - - - - - - 3,312 - - - - 3,312 3,312 100% 0631 Organic Resources 641- - - - - - - 6,670 - - - - 6,670 6,670 100% 0650 Clay Sewage 641 176,341 176,890 180,624 183,360 182,446 188,013 191,313 198,372 190,463 187,689 178,035 185,212 2,218,758 2,244,160 99% Sewage Capital 642 14,620 3,000 4,485 6,773 4,288 7,172 3,412 1,003,293 1,495,035 5,259 4,690 6,111 2,558,137 2,559,500 100% Sewage Reserve 643 6,083 898,070 2,265 3,885 2,492 4,249 2,099 2,082 66,442 3,288 2,803 3,701 997,459 998,325 100% Sewer Bond 2007 647- - - - - - - - - - - - - - NA Sewage Bond Sinking 649 762,499 761,612 761,964 763,223 762,852 764,731 762,648 763,031 778,575 765,356 764,965 767,981 9,179,437 9,316,341 99% Sewer Bond 2007B 651- - - - - - - - - - - - - - NA Sewage Works DS Reserve 653 25 - 612 586 524 - 514 - 1,159 619 613 1,357 6,009 5,280 114% 2010 CSO Net Sewer Bond 658- - - - - - - - - - - - - - NA 2011 Sewer Bond 659 384 85 129 197 127 216 107 106 277 167 97 60 1,952 2,000 98% 2012 Sewer Bond 661 23,078 5,057 7,297 10,735 6,661 11,163 5,017 4,663 10,581 5,006 3,338 3,540 96,136 96,700 99% 2013A Sewer Refund Bonds 664 7 2 3 4 2 4 2 2 5 - - - 32 40 79% 2015 Sewer Refund Bonds 666 76 5 4 6 4 6 3 3 8 - - - 114 130 88% Sub Total 3,835,079 4,743,833 3,988,916 4,027,781 4,109,385 4,996,025 3,201,198 5,135,858 5,826,986 4,017,361 4,124,235 4,045,237 52,051,894 52,582,300 99% Financial Report Dec ember 2016 - R evenue Summa ry Page 7 of 25 City of South Bend Period Ending:December 31, 2016 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Public Safety - Police Police Seizures 216 12,241 3,253 119 947 118 9,603 102 2,762 271 2,438 138 1,986 33,978 36,636 93% Curfew Violations 218 33 54 32 10 19 49 43 6 27 9 33 10 325 1,000 33% Law Enforcement Education 220 30,704 27,445 27,926 15,784 17,577 16,249 22,861 18,280 17,831 36,571 24,928 17,775 273,931 236,825 116% Public Safety LOIT 249 567,011 566,039 566,326 566,640 566,310 566,657 566,186 566,228 566,761 566,635 566,608 566,747 6,798,149 6,797,160 100% Excess Welfare Public Safety 252- - - - - - - - - - - - - - NA Police Take Home Vehicle 278 9,999 9,197 9,243 9,425 9,108 9,356 13,279 8,841 9,270 8,877 8,804 13,066 118,465 112,400 105% Police Block Grant 280 6 1 2 3 2 4 2 2 5 3 2 3 35 20 176% Police Grants 292- - - - - - - - - - - - - - NA Police Academy 294 8,566 6,928 1,146 1,473 797 81 40 39 102 61 50 3,110 22,393 22,500 100% COPS More Grants 295 1,091 8,214 8,352 15,227 652 882 588 43,818 895 781 167,906 60,819 309,225 101,544 305% Drug Enforcement 299 94 115 115 116 112 1,209 114 18,835 5,636 121 128 126 26,720 162,000 16% K-9 Unit 705 6 1 2 3 2 4 2 2 5 2 2 2 33 2,020 2% Sub Total 629,753 621,248 613,264 609,629 594,696 604,093 603,216 658,811 600,802 615,497 768,599 663,645 7,583,254 7,472,105 101% Public Safety - Fire Emergency Telephone System 244- - - - - - - - - - - - - - NA EMS Capital 287 4,258 1,308,699 1,628 3,273 2,041 3,279 462,430 379,612 3,949 316,279 2,099 2,956 2,490,504 3,258,518 76% EMS Operating Fund 288 476,961 497,776 458,825 550,849 388,068 459,608 470,352 492,600 465,175 478,334 531,283 370,211 5,640,043 5,713,524 99% Hazmat 289 53 12 18 27 17 29 14 13 29 18 15 3,429 3,674 10,320 36% River Rescue 291 5,554 11,435 9,956 4,895 21,664 721 51,061 72 205 4,322 1,902 135 111,922 111,978 100% Sub Total 486,826 1,817,922 470,427 559,044 411,791 463,637 983,858 872,296 469,358 798,952 535,299 376,731 8,246,142 9,094,340 91% Department of Community Investment Studebaker/Oliver 209 6,330 405 27,904 11,414 600 30,612 18,231 100,502 1,430 43,375 720 41,378 282,902 593,500 48% State Grant 210 18,038 - 2,208 767,681 18,003 7,550 - 944,679 333 82,735 406 54,252 1,895,885 2,719,053 70% DCI Operating 211 527,096 5,114 194,422 563,271 17,109 7,695 428,055 16,985 2,990 383,344 465,921 11,876 2,623,877 2,634,925 100% 0000 Dept. of Community Investment 212 279,099 153,909 152,736 39,258 151,233 68,150 29,015 229,345 665,433 499,443 530,664 344,770 3,143,055 7,447,400 42% xxx Programs 212- - - - - - - - - - - - - - NA 0000 Economic Revenue Bond 281 45 10 15 23 15 26 13 13 33 20 17 22 250 150 167% Sub Total 830,609 159,437 377,285 1,381,648 186,959 114,032 475,314 1,291,523 670,219 1,008,917 997,728 452,298 7,945,969 13,395,028 59% Parking Garages 0000 Parking Garage Revenue 601 849 - 45 - 77 45 90 19 62 45 8,033 136 9,400 4,385 214% 0460 Main Street 601 20,681 17,090 26,345 24,194 29,496 20,281 15,697 17,269 37,503 21,192 15,706 29,452 274,904 252,867 109% 0462 Leighton Plaza 601 40,901 48,496 33,149 34,823 43,002 32,822 17,156 50,672 51,727 20,488 25,396 16,962 415,592 446,783 93% 0463 Enforcement 601 4,502 6,302 6,389 5,566 5,862 7,270 5,791 4,908 4,778 3,153 7,095 8,221 69,836 121,500 57% 0464 Wayne Street 601 21,191 15,197 24,344 18,247 21,610 18,097 20,925 14,813 21,647 19,911 22,795 12,085 230,861 234,048 99% 0465 Eddy Street Commons 601- - - - - - - - - - - - - 15,900 0% Sub Total 88,124 87,084 90,272 82,831 100,046 78,515 59,658 87,680 115,717 64,788 79,024 66,856 1,000,594 1,075,483 93% Capital / Debt Service Hall of Fame 313 9,343 9,343 9,343 9,343 9,343 787,685 9,343 9,343 9,343 9,343 9,343 663,010 1,544,126 1,544,724 100% COIT 404 998,628 836,789 838,012 848,996 837,567 846,216 846,604 835,603 937,132 841,014 848,382 916,059 10,431,000 10,371,010 101% Cum Capital Development 406 5,335 4,594 4,679 4,818 4,648 263,405 4,612 4,626 4,876 4,682 4,646 224,169 535,091 534,624 100% Cum Capital Improvement 407 150,502 144 154 236 151 121,753 172 25,174 258 172 146 136,401 435,264 437,352 100% EDIT 408 965,781 803,193 1,159,172 808,449 805,261 809,187 807,277 804,604 810,974 807,084 806,449 807,685 10,195,116 10,197,096 100% UDAG 410 1,139 196 269 412 265 452 223 222 580 309 195,730 453 200,249 201,627 99% Major Moves 412 3,574 587,379 1,223 65,617 58,775 2,286 1,122 1,037 2,688 649,378 1,585 2,235 1,376,900 1,491,633 92% Morris PAC Improvement 416 5,931 2,891 7,376 4,634 20,552 2,923 248 1,623 29,051 6,016 9,740 15,652 106,637 106,746 100% CRED 434 45 56 56 58 57 59 58 61 63 60 63 - 635 690 92% Palais Historic Preservation 450 126 2,145 341 794 1,153 1,420 1,058 2,682 1,205 1,357 2,413 1,804 16,497 17,761 93% Hall of Fame Capital 677 833 184 271 49,118 271 485 239 236 613 364 304 398 53,316 53,809 99% xxx xxx xxx- - - - - - - - - - - NA Sub Total 2,141,238 2,246,913 2,020,896 1,792,475 1,738,043 2,835,870 1,670,957 1,685,211 1,796,783 2,319,779 1,878,800 2,767,865 24,894,830 24,957,072 100% Financial Report Dec ember 2016 - R evenue Summa ry Page 8 of 25 City of South Bend Period Ending:December 31, 2016 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Other Miscellaneous Rainy Day 102 14,388 3,184 4,825 7,397 1,410,597 9,026 4,650 4,616 12,070 7,248 6,147 8,116 1,492,266 1,475,850 101% Excess Levy 103 6 1 - - - - - - - - - - 7 20 37% Gift, Donation, Bequest 217 107 39 354 155 381 226 145 135,105 523 509 299 11,057 148,900 360,800 41% Unsafe Building 219 360,372 37,823 47,700 26,838 55,310 90,628 278,845 18,520 14,458 23,503 161,042 24,936 1,139,974 1,231,140 93% Landlord Registration 221 10 100 1,115 1,225 500 245% Loss Recovery 227 1,648 614 300 841 530 904 447 444 1,160 695 590 780 8,952 7,660 117% LOIT 2016 Special Distribution 257- - - - 4,217,549 - - 1,760 87,788 40,846 - - 4,347,943 4,998,549 87% Human Rights 258 121,580 3,921 6,077 8,070 411 671 206 225 50,557 7,778 23,503 17,359 240,357 218,105 110% Morris Palais Marketing 273 400 911 2,912 1,178 1,426 1,649 26 2,642 3,945 2,254 1,221 2,384 20,947 20,956 100% 311 Call Center 279 38,778 39,201 39,960 39,849 40,281 38,900 51,679 37,284 37,248 37,837 36,560 50,321 487,897 499,358 98% Professional Sports Development 377 173,741 47,553 64,832 42,802 110,670 42,808 69,355 37,931 39,467 54,237 54,788 69,771 807,955 811,908 100% 1201 Code Enforcement 600 373,225 2,746 20,597 11,522 7,069 53,992 775,437 40,912 27,485 99,526 398,077 99,415 1,910,002 1,846,100 103% 1207 Animal Control 600 162,540 4,450 6,783 3,752 4,585 5,604 319,888 6,730 4,118 5,319 161,770 4,326 689,865 700,118 99% 1306 Building Operations 600 134,531 81,290 81,139 114,090 110,657 114,630 96,809 136,997 92,118 146,076 143,917 93,150 1,345,404 1,430,817 94% Century Center 670 790,173 396,920 225,335 121,140 265,287 218,932 151,794 866,527 265,401 206,826 67,496 672,685 4,248,517 4,004,984 106% Century Center Capital 671 85 79 85 82 82 76 76 75 73 74 72 74 932 932 100% Century Center Energy Saving 672 4 4 4 4 107,725 79,680 4 4 4 4 4 55,821 243,264 237,418 102% Sub Total 2,171,578 618,737 500,902 377,720 6,332,560 657,727 1,749,362 1,289,773 636,414 632,742 1,055,583 1,111,311 17,134,408 17,845,215 96% Business Insurance 0000 Business Insurance Revenues 226 190,814 186,949 185,820 193,181 185,876 187,786 189,457 185,371 192,716 186,525 192,073 187,073 2,263,642 2,266,083 100% 0418 Workers Compensation 226- 12,878 - - - 737 - - - - 572 14,187 23,300 61% Sub Total 190,814 199,828 185,820 193,181 185,876 188,523 189,457 185,371 192,716 186,525 192,645 187,073 2,277,829 2,289,383 99% Fiduciary Trust & Agency Fire Pension 701 929 131 - - - 2,437,715 - 63 2,431,636 1,600 810 2,525 4,875,408 4,877,051 100% Police Pension 702 2,088 374 311 - - 2,997,375 - 3,650 2,994,780 10,280 2,461 1,609 6,012,927 6,011,450 100% Employee Benefits 711 1,388,795 1,364,497 1,390,952 1,536,588 1,406,479 1,829,415 1,548,100 1,466,896 1,476,258 1,457,577 1,861,793 1,464,856 18,192,207 18,043,130 101% Unemployment Comp 713 445 1,837 1,311 12,303 12,190 12,662 18,961 12,613 12,361 6,301 185 536 91,706 107,282 85% City Cemetery Trust 730 47 10 16 24 16 27 13 13 34 20 17 23 261 150 174% Sub Total 1,392,305 1,366,849 1,392,590 1,548,915 1,418,684 7,277,194 1,567,074 1,483,235 6,915,068 1,475,778 1,865,267 1,469,549 29,172,509 29,039,063 100% Civil City Revenues 16,935,586 16,191,286 14,623,209 16,207,829 19,759,465 49,642,123 16,503,157 18,420,003 22,868,168 15,540,231 16,989,404 39,459,235 263,139,697 273,317,501 96% Tax Increment Financing TIF River West - Airport 324 62,565 39,097 92,026 257,011 285,004 9,826,825 127,855 42,471 342,160 373,819 83,425 8,439,926 19,972,184 20,225,222 99% TIF Central Development 420- - - - - - - - - - - - - - NA TIF West Washington 422 2,477 552 836 1,278 819 284,205 763 813 2,126 1,276 1,082 172,089 468,316 469,003 100% TIF Leighton Plaza 425 11,420 10,732 13,574 3,711 15,392 13,502 11,517 3,843 10,604 14,246 14,847 12,078 135,467 172,703 78% TIF Medical Service 426- - - - - - - - - - - - - - NA TIF River East DEV (NE)429 12,505 2,739 4,151 6,361 4,077 1,177,923 3,690 4,142 74,471 9,480 5,250 1,183,063 2,487,851 2,912,501 85% TIF Southside 430 9,942 2,233 3,363 5,017 3,168 1,256,789 2,795 2,880 6,728 3,458 2,559 1,152,476 2,451,409 2,453,252 100% TIF Erskine Village 432 8,776 1,827 2,741 4,202 2,697 4,601 2,275 2,235 5,758 3,457 2,932 3,872 45,372 52,700 86% TIF Douglas Road 435 234 56 28 10 7 231,300 66 111 290 174 96 113,986 346,356 346,612 100% TIF River East RES (NE RE)436 213,108 - - - - 2,061,402 - - - - - 1,871,103 4,145,613 4,146,448 100% Sub Total 321,026 57,236 116,718 277,590 311,164 14,856,547 148,961 56,494 442,137 405,911 110,191 12,948,592 30,052,567 30,778,441 98% Financial Report Dec ember 2016 - R evenue Summa ry Page 9 of 25 City of South Bend Period Ending:December 31, 2016 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Redevelopment Funds Administration 433 14 3 5 7 5 8 4 4 10 6 5 7 80 152 52% Certified Technology Park 439 3,792 833 1,262 1,935 1,174 1,986 982 975 2,549 1,530 1,298 1,714 20,029 23,037 87% Airport Urban Enterprise Zone 454 628 139 211 323 207 354 175 174 454 273 231 305 3,474 3,900 89% Sub Total 4,435 975 1,478 2,265 1,386 2,348 1,161 1,152 3,013 1,809 1,534 2,026 23,582 27,089 87% Debt Service Airport Debt Reserve 2003 315 1,718 380 576 882 566 965 477 473 1,236 742 628 829 9,471 14,000 68% Coveleski Bond Debt Reserve 317 841 186 282 432 277 473 234 232 607 365 309 408 4,647 5,300 88% Central Development reserve 328 2,870 635 962 1,474 945 1,612 797 790 2,065 1,239 1,050 1,385 15,824 15,000 105% Sub Total 5,429 1,201 1,820 2,788 1,789 3,050 1,507 1,495 3,908 2,345 1,987 2,623 29,942 34,300 87% Redevelopment Commission 330,890 59,411 120,016 282,643 314,339 14,861,945 151,629 59,141 449,058 410,065 113,713 12,953,241 30,106,091 30,839,830 98% City Operations Total 17,266,476 16,250,697 14,743,225 16,490,472 20,073,803 64,504,068 16,654,786 18,479,145 23,317,225 15,950,297 17,103,117 52,412,477 293,245,789 304,157,331 96% Revenue report 17,266,476 16,250,697 14,743,225 16,490,472 20,073,804 64,504,068 16,654,787 18,479,145 23,317,226 15,950,297 17,103,117 52,412,477 293,245,789 304,157,331 0 0 0 0(1)0(1)0(0)0 0 0(0)0 Financial Report Dec ember 2016 - R evenue Summa ry Page 10 of 25 City of South Bend Period Ending:December 31, 2016 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 Financial Report December 2016 - Property Tax Revenue Page 11 of 25 City of South Bend Period Ending:December 31, 2016 Property Tax Revenue 2014 Tax Pay 2015 Fund Fund #Levy Estimated Distribution 1 Distribution 2 Distribution 3 Distribution 4 Levy Per County Collection Projected 6/8/2015 6/16/2015 10/30/2015 12/15/2015 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate City General Fund 101 38,619,247.00 0.95 36,688,284.65 13,463,468.56 7,216,350.23 2,012,110.57 14,657,458.45 37,349,387.81 1,269,859.19 96.71% Parks & Recreation 201 7,742,127.00 0.95 7,355,020.65 2,699,065.71 1,446,685.42 403,374.41 2,938,428.80 7,487,554.34 254,572.66 96.71% College Football Hall of Fame 313 937,076.00 0.95 890,222.20 - 501,784.88 - 404,478.29 906,263.17 30,812.83 96.71% Cumulative Capital District 406 443,304.00 0.95 421,138.80 154,544.81 82,835.23 23,096.67 168,250.41 428,727.12 14,576.88 96.71% Fire Pension 701- 0.95 - - - - - - - - Police Pension 702- 0.95 - - - - - - - - Total - City 47,741,754.00 45,354,666.30 16,317,079.08 9,247,655.76 2,438,581.65 18,168,615.95 46,171,932.44 1,569,821.56 96.71% Tax Increment Financing Airport TIF District 324 17,709,737.84 0.95 16,824,250.95 - 9,396,167.91 - 6,897,072.02 16,293,239.93 1,416,497.91 92.00% South Bend Central TIF District 420- 0.95 - - - - - - - West Washington TIF District 422 512,917.39 0.95 487,271.52 - 195,865.56 - 207,045.03 402,910.59 110,006.80 78.55% Central Medical TIF District 426- 0.95 - - - - - - - Northeast Residential TIF District 436 3,273,328.42 0.95 3,109,662.00 - 1,663,572.10 - 1,466,109.03 3,129,681.13 143,647.29 95.61% Southside TIF District #1 430 2,504,494.11 0.95 2,379,269.40 - 1,298,974.33 - 906,847.80 2,205,822.13 298,671.98 88.07% Erskine Commons TIF District #2 431- 0.95 - - - - - - - Erskine Village TIF District #3 432 19,182.73 0.95 18,223.59 - 11,490.26 - 7,692.47 19,182.73 - 100.00% Douglas Road TIF District 435 327,887.96 0.95 311,493.56 - 163,943.98 - 106,813.87 270,757.85 57,130.11 82.58% Northeast TIF 429 2,743,819.42 0.95 2,606,628.45 - 1,391,012.32 - 1,030,295.80 2,421,308.12 322,511.30 88.25% Airport Urban Enterprise Zone 454- 0.95 - - - - - - - - Other xxx- - - - - - Total - Tax Increment Financing 27,091,367.87 25,736,799.48 - 14,121,026.46 - 10,621,876.02 24,742,902.48 2,348,465.39 91.33% Grand Total 74,833,121.87 71,091,465.78 16,317,079.08 23,368,682.22 2,438,581.65 28,790,491.97 70,914,834.92 3,918,286.95 94.76% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 6/8/15 2 Distribution 2 - Issued by St. Joseph County on 6/16/15 3 Distribution 3 - Issued by St. Joseph County on 10/30/15 Distribution 4 - Issued by St. Joseph County on 12/15/15 Financial Report December 2016 - Property Tax Revenue Page 12 of 25 City of South Bend Period Ending:December 31, 2016 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget General Government 0101 Mayor 101 62,117 48,772 50,030 46,449 48,335 47,667 81,896 48,128 51,692 54,065 53,751 86,523 679,425 749,883 91% 0104 311 Call Center 101- 1,629 595 1,586 - - - - - - - - 3,810 5,933 64% 0201 Clerk 101 31,055 31,491 37,749 26,701 32,713 31,544 46,248 30,500 22,500 21,912 23,871 38,723 375,008 443,475 85% 0301 Common Council 101 41,543 59,981 33,221 24,897 32,488 37,464 32,062 46,300 39,586 49,768 33,368 50,403 481,079 531,035 91% 0302 WNIT Contract 101- - - 43,000 - - - - - - - - 43,000 43,000 100% 0401 Administration and Finance 101 130,914 141,679 128,874 123,875 153,924 136,469 186,310 145,892 152,837 311,135 139,868 236,239 1,988,017 2,227,488 89% 0501 Legal Department 101 75,713 76,476 78,779 76,637 77,517 76,398 107,282 78,168 77,224 73,682 70,305 108,277 976,457 1,036,772 94% Sub Total 341,342 360,028 329,247 343,146 344,977 329,542 453,798 348,987 343,839 510,562 321,162 520,165 4,546,796 5,037,586 90% Public Works 0602 Engineering 101 60,668 91,788 89,283 80,759 85,036 92,517 109,677 127,421 71,011 73,450 63,791 69,687 1,015,088 1,225,137 83% Sub Total 60,668 91,788 89,283 80,759 85,036 92,517 109,677 127,421 71,011 73,450 63,791 69,687 1,015,088 1,225,137 83% Public Safety 0801 Police 101 1,839,872 1,836,378 1,935,878 1,851,538 1,928,033 2,039,599 2,594,999 1,847,457 2,079,900 2,037,166 1,911,521 2,999,390 24,901,730 26,399,474 94% 0805 Police -PS LOIT funded 101- - - - - - - - - - - - - - NA 0802 Police Communications 101- - 369,753 123,251 123,251 123,251 - - 369,753 123,251 246,502 - 1,479,012 1,479,012 100% 0901 Fire 101 1,349,693 1,406,545 1,437,795 1,551,497 1,471,613 1,515,308 2,018,170 1,498,234 1,403,223 1,337,067 1,459,535 2,118,824 18,567,503 18,775,089 99% 0905 Fire-PS LOIT funded 101- - - - - - - - - - - - - - NA Sub Total 3,189,565 3,242,923 3,743,426 3,526,286 3,522,897 3,678,158 4,613,169 3,345,691 3,852,875 3,497,484 3,617,558 5,118,214 44,948,246 46,653,575 96% Code Enforcement 1201 Code 101 202,164 - - - - - - (60) - - 400 202,504 202,104 100% Sub Total 202,164 - - - - - - - (60) - - 400 202,504 202,104 100% Arts & Culture 0404 Morris PAC 101 75,543 84,588 92,842 72,255 89,432 74,463 100,938 97,401 73,795 76,246 72,704 82,811 993,019 1,129,897 88% 0405 Palais Royale 101 36,586 48,725 38,176 29,957 37,155 39,288 30,684 43,677 26,998 29,731 38,043 28,447 427,467 498,438 86% Sub Total 112,129 133,313 131,018 102,212 126,588 113,751 131,622 141,078 100,793 105,977 110,747 111,258 1,420,486 1,628,335 87% Human Rights 1008 Human Rights 101 27,794 31,288 25,632 28,106 23,375 26,740 41,204 27,674 30,493 23,775 27,616 35,459 349,157 371,226 94% Sub Total 27,794 31,288 25,632 28,106 23,375 26,740 41,204 27,674 30,493 23,775 27,616 35,459 349,157 371,226 94% General Fund Expenditure Total 3,933,663 3,859,340 4,318,606 4,080,508 4,102,872 4,240,708 5,349,470 3,990,851 4,398,952 4,211,247 4,140,874 5,855,184 52,482,276 55,117,963 95% Financial Report Dec ember 2016 - Expend iture Summar y Page 13 of 25 City of South Bend Period Ending:December 31, 2016 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Parks & Recreation 1100 Administration 201 120,329 83,287 83,490 77,779 88,065 81,333 109,108 80,230 92,666 77,646 77,911 108,005 1,079,850 1,056,714 102% 1101 Maintenance 201 368,679 389,966 441,134 343,837 406,986 491,137 602,485 444,708 411,921 392,279 383,518 462,656 5,139,306 5,285,910 97% 1102 Golf Operations 201 49,757 92,103 89,804 120,631 199,079 162,933 171,012 149,297 127,219 112,926 103,768 89,946 1,468,475 1,703,202 86% 1103 Recreation Division 201 154,760 162,409 147,645 158,818 152,871 163,301 334,779 225,096 159,389 141,618 145,334 209,788 2,155,807 2,362,980 91% 1104 Potawatomi Zoo 201 5,034 5,339 405,050 5,383 4,946 5,247 7,644 339,831 5,058 5,423 5,564 7,441 801,960 800,352 100% 1106 Potawatomi Greenhouse 201 783 6,648 3,813 16,965 1,673 598 447 379 383 475 970 2,777 35,912 54,408 66% 1108 Graffiti Removal 201 8,180 7,676 7,468 7,131 7,503 7,762 9,273 7,832 6,779 8,042 7,060 12,863 97,569 99,893 98% Recreation Non Reverting 203 34,956 57,650 69,287 61,600 144,795 98,576 129,969 94,987 53,926 70,623 61,695 76,931 954,996 1,459,754 65% East Race Waterway 271- - - - - - - - - - - - - - NA Coveleski Stadium 401- 22,000 - - - - - - 3,430 - 8,045 - 33,475 36,000 93% Zoo Endowment 403- - - - - - - - - - - - - 49,000 0% Park Non Reverting 405- - 1,948 4,094 46,292 37,406 7,531 5,290 9,615 20,607 16,893 17,853 167,529 483,095 35% Sub Total 742,479 827,079 1,249,640 796,237 1,052,209 1,048,293 1,372,248 1,347,651 870,387 829,640 810,758 988,259 11,934,878 13,391,308 89% Public Works Motor Vehicle Highway 202 711,071 666,780 853,357 492,279 523,049 443,229 671,263 448,214 829,111 528,332 512,507 719,224 7,398,415 9,216,413 80% Curb and Sidewalk 202 63,314 46,745 43,357 31,186 198,087 63,460 72,304 72,458 273,930 76,573 73,828 257,547 1,272,789 1,760,996 72% Central Services 222 544,400 631,085 646,405 528,846 634,188 515,033 584,436 672,850 589,418 658,827 695,602 687,606 7,388,697 8,306,979 89% Central Services Capital 224- 23,369 - - 112,077 15,173 - 18,500 37,070 - - - 206,190 305,584 67% Local Roads & Streets 251 76,979 139,680 75,028 38,810 109,173 228,846 72,830 94,121 136,892 121,571 383,378 62,178 1,539,488 2,267,944 68% Project ReLeaf 655 14,595 2,629 2,937 378,442 2,928 3,295 14,713 2,921 12,046 29,411 15,805 17,473 497,194 528,358 94% Sub Total 1,410,360 1,510,289 1,621,083 1,469,563 1,579,502 1,269,035 1,415,546 1,309,063 1,878,468 1,414,714 1,681,120 1,744,028 18,302,772 22,386,274 82% Public Works Solid Waste Solid Waste Operations 610 658,357 359,794 375,760 335,581 380,928 395,728 671,025 560,319 425,065 437,428 381,860 667,865 5,649,709 5,867,412 96% Solid Waste Capital 611 250,879 236 11,143 83,883 20,064 11,080 250,861 146,752 11,105 83,794 20,129 218 890,145 925,197 96% Sub Total 909,235 360,030 386,903 419,464 400,992 406,808 921,886 707,071 436,170 521,222 401,989 668,083 6,539,853 6,792,609 96% Public Works Water Utility 0630 Water Leak Insurance 620 466 82,211 37,746 67,227 85,909 92,046 128,069 129,195 111,514 112,782 71,378 102,092 1,020,636 1,010,000 101% 0640 Water Works 620 1,055,327 1,445,433 1,071,284 1,047,483 1,167,937 993,681 1,374,868 1,366,862 1,296,876 1,226,214 1,135,137 1,254,182 14,435,285 16,034,157 90% 0660 Clay Water 620 51 - - - (0) (24) 1,045 287 15 - - - 1,374 3,500 39% Waterworks Capital 622- - - 6,750 - - 159,033 144,609 - - 7,925 - 318,317 821,797 39% Waterworks Deposit 624 534 553 840 1,291 830 1,418 701 696 1,822 1,098 931 1,514 12,228 13,400 91% Waterworks Sinking 625 551 14 159 410 365 347,055 738 717 1,169 822 817 1,654,780 2,007,598 2,053,681 98% Waterworks Bond Reserve 626- - 2,050 - - - - 4,481 - - - 550,448 556,979 564,948 99% Waterworks Debt Reserve 629 790 817 1,287 2,091 1,341 2,287 1,130 1,121 2,929 1,758 1,489 2,420 19,461 21,000 93% Sub Total 1,057,719 1,529,028 1,113,367 1,125,253 1,256,382 1,436,462 1,665,583 1,647,969 1,414,326 1,342,675 1,217,678 3,565,436 18,371,878 20,522,483 90% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 32,598 24,473 51,533 51,541 60,773 31,368 41,950 25,311 39,609 31,708 72,193 72,658 535,716 594,413 90% 0621 Sewer Repair 641 365,864 307,474 341,407 345,729 437,696 432,810 521,742 357,670 387,302 355,997 510,088 427,111 4,790,891 7,709,744 62% 0625 Concrete Crew 641 24,761 26,568 27,942 21,841 21,367 26,265 34,026 24,059 24,644 21,725 26,850 37,748 317,796 455,797 70% 0630 Wastewater Operations 641 2,056,393 2,751,269 1,840,284 1,856,140 1,994,573 2,077,685 2,032,855 3,006,735 3,860,814 1,878,428 1,981,055 2,231,155 27,567,386 30,546,550 90% 0631 Organic Resources 641 94,619 52,239 67,433 75,509 107,520 61,790 114,338 137,755 78,624 65,133 95,951 223,294 1,174,206 1,384,847 85% 0650 Clay Sewage 641 220 - - 88 25 (42) 2,797 181 56 - - (160) 3,164 500 633% Sewage Capital 642 635,043 53,387 150,821 130,215 126,925 373,826 152,058 1,411,024 372,651 305,388 273,903 92,232 4,077,475 7,631,946 53% Sewage Reserve 643 1,301 1,345 2,265 3,885 2,492 4,249 2,099 2,082 5,442 3,288 2,803 4,556 35,808 38,000 94% Sewage Bond Sinking 649 1,350 500 - 750 1,145,856 - - - - - 8,019,559 500 9,168,515 9,274,298 99% 2011 Sewer Bond 659- - - - - - - - - 162,482 19,687 - 182,169 232,689 78% 2012 Sewer Bond 661 118,335 1,143,403 445,588 92,338 284,179 1,430,384 563,036 2,894,143 1,573,247 1,623,256 5,996 945,916 11,119,822 20,187,062 55% 2013A Sewer Bond 664- - - - - - - - 4,538 - - 4,538 4,550 100% 2014 Sewer Bond 665- - - - - - - - - - NA 2015 Sewer Bond 666 2,500 - - - - - - - 6,705 - - 9,205 9,205 100% Sub Total 3,332,985 4,360,659 2,927,274 2,578,037 4,181,406 4,438,335 3,464,901 7,858,960 6,353,631 4,447,406 11,008,086 4,035,011 58,986,692 78,069,601 76% Financial Report Dec ember 2016 - Expend iture Summar y Page 14 of 25 City of South Bend Period Ending:December 31, 2016 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Public Safety - Police Police Seizures 216- - - - - - - 825 - 2,285 13,000 - 16,110 36,000 45% Curfew Violations 218- - - - - - - - - - - - - 1,000 0% Law Enforcement Education 220 16,882 35,846 13,572 11,028 22,588 96,409 13,227 42,648 17,459 12,571 38,923 50,733 371,885 743,508 50% Emergency Telephone System 244- - - - - - - - - - - - - - NA Public Safety LOIT 249 521,395 492,883 513,715 500,885 519,490 556,228 696,696 476,014 508,698 470,749 468,526 774,355 6,499,635 6,600,626 98% Excess Welfare Public Safety 252- - - - - - - - - - - - - 8 0% LOIT 2016 Special Distribution 257- - - - - - 2,200 178,905 80,796 41,734 15,204 4,037 322,876 1,000,000 32% Police Take Home Vehicle 278 53 - - - - - - - - - 7,033 - 7,086 10,000 71% Police Grants 292 6,713 5,925 6,188 12,138 1,001 1,275 - - - - 11,329 - 44,568 55,373 80% Police Academy 294 251 50 280 986 632 1,263 - 468 379 3,186 8,751 290 16,536 22,500 73% COPS More Grants 295 707 4,039 1,923 4,520 16,748 - - 12,232 13,610 147,942 (12,520) 4,158 193,358 314,787 61% Drug Enforcement 299- 1,290 10,752 - - - - 14,371 - - 27,000 - 53,413 168,965 32% K-9 Unit 705- - - - - - - 1,044 - - - - 1,044 2,020 52% Sub Total 546,001 540,033 546,430 529,557 560,459 655,175 712,123 726,506 620,942 678,466 577,246 833,573 7,526,511 8,954,787 84% Public Safety - Fire EMS Capital 287- - 152,919 - 432,134 411,578 63,198 164,248 88,657 42,453 72,571 5,452 1,433,210 3,180,386 45% EMS Operating Fund 288 582,267 370,131 374,778 355,722 529,369 547,074 743,344 378,207 420,937 419,285 435,091 880,360 6,036,566 6,140,643 98% Hazmat 289- - - 1,170 - - 6,439 - - - 1,353 - 8,962 10,000 90% River Rescue 291 1,200 1,311 3,610 271 6,280 5,444 5,347 6,944 2,436 9,541 2,616 20,346 65,346 105,300 62% xxx xxx xxx- - - - - - - - - - - - - NA Sub Total 583,467 371,442 531,308 357,163 967,783 964,096 818,327 549,399 512,030 471,279 511,632 906,159 7,544,084 9,436,329 80% Department of Community Investment Studebaker/Oliver 209 4,500 18,732 19,040 - 27,101 20,476 - 5,672 47,869 329,808 23,494 38,325 535,017 1,683,250 32% State Grant 210 858,470 604,022 31,790 - - 18,003 - 67,861 106,908 191 - 18,003 1,705,246 2,522,519 68% DCI Operating 211 193,791 183,367 177,764 177,360 207,513 184,292 233,459 199,742 189,238 213,951 185,193 237,949 2,383,619 2,687,313 89% 1001 Dept. of Community Investment 212 219,263 153,095 172,309 105,228 77,082 92,772 4,769 368,661 793,850 400,921 641,941 424,795 3,454,687 7,353,228 47% 1003 Administration 212- - - - - - - - - - - - - 4,235 0% xxx Programs 212- - - - (2,297) - - - - 2,297 - - - - NA Sub Total 1,276,023 959,216 400,902 282,589 309,399 315,543 238,228 641,936 1,137,865 947,168 850,628 719,071 8,078,569 14,250,545 57% Parking Garages 0400 General Administration 601- - - - - - - - - - - - - 248,250 0% 0460 Main Street 601 26,730 908 24,914 12,853 12,270 11,178 13,427 10,617 12,596 940 19,366 1,055 146,854 235,033 62% 0462 Leighton Plaza 601 44,392 2,288 47,457 25,257 24,656 25,386 23,384 15,931 25,015 2,235 29,303 2,309 267,611 558,648 48% 0463 Enforcement 601 14,403 487 17,211 8,161 7,371 8,408 7,752 7,746 8,213 487 16,181 487 96,907 97,994 99% 0464 Wayne Street 601 26,189 2,240 22,306 15,098 13,212 17,984 13,901 10,116 14,130 2,251 19,937 2,255 159,619 237,646 67% 0465 Eddy Street Commons 601- - - - - - - - - - - - - 15,900 0% Sub Total 111,714 5,924 111,888 61,368 57,510 62,955 58,463 44,409 59,954 5,913 84,786 6,107 670,990 1,393,471 48% Capital / Debt Service Hall of Fame 313 636,000 - - - - - 635,000 - - - - - 1,271,000 1,271,000 100% COIT 404 2,195,646 702,384 853,652 959,871 842,370 1,142,904 1,739,149 899,911 1,078,904 1,031,535 1,350,560 806,626 13,603,511 15,841,448 86% Cum Capital Development 406 112,650 - 56,546 - 135,726 56,546 112,650 27,896 - - 24,724 - 526,737 526,737 100% Cum Capital Improvement 407 184,125 - - - - - 184,125 - - - - - 368,250 368,250 100% EDIT 408 2,192,756 59,872 169,782 1,123,043 80,832 99,244 2,756,182 273,878 99,372 120,486 1,791,251 147,676 8,914,375 10,560,181 84% UDAG 410 146,068 - - - - - - - 92,105 - - - 238,173 238,173 100% Major Moves 412 110 312,495 38,870 34,165 146,498 58,844 18,881 25,705 1,226 22,038 510,965 - 1,169,799 2,448,588 48% Morris PAC Improvement 416- 10,464 2,467 4,978 315 1,599 6,780 1,990 3,590 - 1,346 - 33,530 78,923 42% CRED 434- - - - - - - - - 2,977 - 63 3,039 3,200 95% Palais Historic Preservation 450- - - - - - - - - - - - - 16,150 0% Hall of Fame Capital 677 4,658 15,819 6,938 2,373 3,043 2,787 2,591 4,533 9,480 4,807 2,123 1,601 60,752 84,801 72% Sub Total 5,472,013 1,101,034 1,128,255 2,124,429 1,208,785 1,361,924 5,455,358 1,233,913 1,284,677 1,181,843 3,680,969 955,966 26,189,166 31,437,451 83% Financial Report Dec ember 2016 - Expend iture Summar y Page 15 of 25 City of South Bend Period Ending:December 31, 2016 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Other Miscellaneous Excess Levy 103- 3,648 - - - - - 25 - - - 3,673 3,688 100% Gift, Donation, Bequest 217- - - - - - - 96,000 1,000 - - - 97,000 362,500 27% Unsafe Building 219- 14,797 20,481 139,794 108,516 69,479 47,108 75,081 71,043 76,233 73,189 75,017 770,740 951,497 81% Loss Recovery 227 8 3,200 20,008 - - - - 1,953 - - - 6,467 31,636 480,311 7% Human Rights 258 12,916 12,344 11,301 11,621 20,577 14,350 22,014 14,271 21,936 12,356 15,479 16,524 185,689 221,838 84% Morris Palais Marketing 273- - - - 2,457 - - 878 - 878 - - 4,212 18,878 22% 311 Call Center 279 38,778 39,201 40,140 39,669 40,281 38,900 51,679 37,284 37,428 37,659 36,557 50,321 487,897 499,357 98% Professional Sports Development 377 472,288 800 - - - - 364,964 - - - - - 838,051 838,052 100% 1201 Code Enforcement 600 134,860 98,504 97,400 114,564 138,852 132,188 130,639 101,376 103,804 188,595 96,478 120,429 1,457,689 1,803,657 81% 1207 Animal Control 600 50,246 54,812 60,621 51,121 46,642 48,492 66,046 64,736 46,976 51,064 57,767 73,686 672,210 729,330 92% 1209 Illegal Dumping Crew 600 35,125 41,910 40,652 (95,755) (21,931) - - - - - - - (0) - NA 1306 Building Operations 600 82,944 83,613 78,238 76,319 82,958 87,413 119,254 89,920 100,827 88,360 84,841 121,313 1,096,000 1,211,490 90% Century Center 670 329,357 310,741 316,542 286,177 370,652 491,964 374,975 313,118 319,130 356,613 319,603 434,534 4,223,406 4,318,944 98% Century Center Capital 671- - 38,747 - 56,406 13,848 9,001 - 12,545 - 6,471 137,018 188,621 73% Century Center Energy Saving 672- - - 140,609 - - - - - 95,523 - 111 236,243 237,132 100% Sub Total 1,156,521 663,569 685,384 802,866 789,002 939,192 1,190,528 803,643 702,144 919,825 683,914 904,874 10,241,463 11,865,295 86% Business Insurance 0403 Self Funded Liability Ins 226 17,058 14,315 14,138 13,343 15,017 11,494 22,195 20,070 15,039 18,082 19,107 23,105 202,965 237,860 85% 0412 Liability Insurance 226 13,955 19,262 32,319 18,246 132,533 15,813 68,150 85,963 143,882 21,031 35,311 215,165 801,630 1,383,363 58% 0417 Business Insurance 226 17,445 - 14,854 - 6,579 407,689 - 6,852 14,875 - - 9,374 477,669 647,125 74% 0418 Workers Compensation 226 48,983 203,070 39,908 25,926 17,412 45,053 54,354 42,073 32,961 59,297 61,112 83,328 713,476 852,000 84% Sub Total 97,441 236,647 101,220 57,515 171,540 480,049 144,700 154,959 206,757 98,410 115,530 330,972 2,195,740 3,120,348 70% Fiduciary Trust & Agency Fire Pension 701 427,167 402,025 407,173 524,845 414,901 534,598 414,385 425,823 402,142 391,333 402,247 433,500 5,180,140 5,464,843 95% Police Pension 702 516,452 528,448 651,745 520,019 520,015 517,495 531,209 518,397 518,701 517,054 525,557 512,702 6,377,793 6,797,398 94% Employee Benefits 711 634,312 1,803,358 1,576,792 1,282,480 1,326,426 1,793,912 1,145,972 1,373,710 938,527 876,036 1,979,719 1,099,214 15,830,459 17,378,890 91% Unemployment Comp 713 1,487 7,828 5,252 4,339 10,387 2,955 607 4,815 9,014 13,051 607 14,093 74,436 113,882 65% City Cemetery Trust 730- - - - - - - - - - - - 20,000 0% Sub Total 1,579,417 2,741,659 2,640,962 2,331,683 2,271,731 2,848,961 2,092,173 2,322,745 1,868,385 1,797,474 2,908,130 2,059,509 27,462,828 29,775,013 92% Civil City Expenditure 22,209,039 19,065,949 17,763,220 17,016,232 18,909,572 20,467,536 24,899,535 23,339,075 21,744,687 18,867,283 28,673,339 23,572,232 256,527,698 306,513,477 84% Tax Increment Financing TIF River West - Airport 324 4,064,434 1,454,126 1,749,039 554,649 907,744 551,962 3,790,327 1,095,671 820,229 1,348,530 1,241,100 2,612,650 20,190,461 44,502,077 45% TIF West Washington 422 3,366 3,461 2,195 1,350 550 - - 605 2,086 470 - 14,082 1,403,366 1% TIF Leighton Plaza 425 4,481 4,849 6,656 8,004 6,436 41,531 6,304 5,732 10,603 34,036 10,348 18,494 157,473 170,406 92% TIF River East DEV (NE)429 81,910 3,701 12,236 - 35,949 326,459 (2,334) 580,080 5,183 794,608 29,480 306,061 2,173,333 8,335,159 26% TIF Southside 430 280 153,970 142,775 1,590 421,414 89,625 584,193 937,013 567,688 566,698 325,357 134,297 3,924,900 7,411,815 53% TIF Erskine Village 432 365,835 - - - - - 123,668 - - - - - 489,503 490,503 100% TIF Douglas Road 435- 140,000 - - - - - - - 201,288 - - 341,288 354,200 96% TIF River East RES (NE RE)436 1,237,500 446,589 - - - - 1,236,500 - - 447,689 1,000 - 3,369,278 3,430,000 98% Sub Total 5,754,441 2,206,601 1,914,167 566,437 1,372,892 1,010,126 5,738,657 2,618,496 1,404,308 3,394,934 1,607,755 3,071,503 30,660,317 66,097,526 46% Financial Report Dec ember 2016 - Expend iture Summar y Page 16 of 25 City of South Bend Period Ending:December 31, 2016 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Redevelopment Funds Administration 433- - - - - - - - - - 329 - 329 4,500 7% Certified Technology Park 439- - 142,913 - - - - - - - - - 142,913 2,692,913 5% Airport Urban Enterprise Zone 454- - - - - - - - - - - - - 50,000 0% Sub Total- - 142,913 - - - - - - - 329 - 143,241 2,747,413 5% Debt Service Airport Debt Reserve 2003 315 367 380 576 882 566 965 477 473 1,236 742 628 1,021 8,312 14,000 59% Central Development reserve 328 614 635 962 1,474 945 1,612 797 790 2,065 1,239 1,050 1,706 13,888 15,000 93% Sub Total 981 1,015 1,538 2,356 1,511 2,577 1,273 1,263 3,300 1,981 1,678 2,727 22,199 29,000 77% Redevelopment Commission 5,755,422 2,207,615 2,058,618 568,794 1,374,403 1,012,703 5,739,931 2,619,759 1,407,609 3,396,915 1,609,761 3,074,229 30,825,758 68,873,939 45% City Operations Total 27,964,461 21,273,564 19,821,838 17,585,025 20,283,975 21,480,239 30,639,466 25,958,833 23,152,296 22,264,197 30,283,100 26,646,461 287,353,456 375,322,258 77% Expenditure report 27,964,461 21,273,564 19,821,838 17,585,025 20,283,975 21,480,239 30,639,466 25,958,833 23,152,296 22,264,197 30,283,100 26,646,461 287,353,456 375,322,258 0 0 0 0 0 0(0)0 0(0)0 0(0)0 Financial Report Dec ember 2016 - Expend iture Summar y Page 17 of 25 City of South Bend Period Ending:December 31, 2016 Debt Schedule Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at 2016 Princip al 2016 Inter est 2016 Debt a t 2016 Total D eb t In strumen t D ebt Pur po se Issue Refunding M aturity F un d 1st 2nd 3rd 4th Is sue 12/3 1/20 15 Paym ents Payme nt Addit ion 12/31/20 16 D ebt P aymen ts Civil City Debt Bond Deb t A mort s ch # 3 1 CEDIT Bond 199 7 200 6 20 17 40 8 2/1 8/1--11,870,00 0.00 1,265,000.00 8 35,000.00 49,030.00 0.00 430,000.00 884,03 0.00 3 6 Sout h B end Building C orporation Pu bl ic W orks Building 200 1 201 0 20 21 40 4/649 2/1 8/1--9,250,00 0.00 3,315,000.00 5 60,000.00 113,226.00 0.00 2,755,000.00 673,22 6.00 2 5 Wat er Works Impr ovemen ts W ater W orks 200 2 201 2 20 23 62 5 1/1 7/1--5,975,00 0.00 2,745,000.00 3 65,000.00 54,900.00 0.00 2,380,000.00 419,90 0.00 3 9 Sout h B end Building C orporation Fire HQ / P ol ice H Q 200 3 201 2 20 23 40 4/324 2/1 8/1--21,335,00 0.00 10,085,000.00 1,2 00,000.00 365,560.00 0.00 8,885,000.00 1,565,56 0.00 2 4 Wat er Works Impr ovemen ts W ater W orks 200 6 20 27 62 5 1/1 7/1--4,710,00 0.00 3,090,000.00 2 20,000.00 137,800.00 0.00 2,870,000.00 357,80 0.00 6 2 Cen tury Center Spec i al Tax Bonds C entury Center 200 8 20 28 42 0 5/1 11/1--4,655,00 0.00 3,465,000.00 2 90,000.00 97,612.50 0.00 3,175,000.00 387,61 2.50 6 9 Wat er Works Impr ovemen ts W ater W orks 200 9 20 30 62 5 1/1 7/1--5,380,00 0.00 4,555,000.00 2 30,000.00 250,978.00 0.00 4,325,000.00 480,97 8.00 7 0 Sewage W orks Reve nue Bon ds - 2009 Sewag e W orks 200 9 20 28 64 9 6/1 12/1--3,297,00 0.00 2,407,675.00 1 58,032.00 67,656.00 0.00 2,249,643.00 225,68 8.00 8 0 2 010 Sewage W orks Re v enue Bonds Sewag e W orks 201 0 20 30 64 9 6/1 12/1--9,345,00 0.00 7,530,000.00 3 85,000.00 314,017.50 0.00 7,145,000.00 699,01 7.50 9 3 Sewage W orks Reve nue Bon ds 201 1 Sewag e W orks 201 1 20 31 64 9 6/1 12/1--21,500,00 0.00 18,175,000.00 8 80,000.00 680,700.00 0.00 17,295,000.00 1,560,70 0.00 9 9 2 012 W ater Wo rks Reven ue Bond W ater W orks 201 2 20 33 62 5 1/1 7/1--8,300,00 0.00 7,275,000.00 3 50,000.00 216,786.26 0.00 6,925,000.00 566,78 6.26 10 1 2 012 Sewage W orks Re v enue Bonds Sewag e W orks 201 2 20 32 64 9 6/1 12/1--25,000,00 0.00 21,935,000.00 1,0 45,000.00 507,580.00 0.00 20,890,000.00 1,552,58 0.00 10 5 2 013A Sewer Bon d Refunding Sewag e W orks 201 3 201 3 20 24 64 9 6/1 12/1--14,765,00 0.00 9,970,000.00 1,9 20,000.00 193,418.00 0.00 8,050,000.00 2,113,41 8.00 11 6 2 013 Building C orporation EMS / Fire D epar t ment 201 3 20 33 28 8 2/1 8/1--5,580,00 0.00 5,365,000.00 2 20,000.00 184,155.00 0.00 5,145,000.00 404,15 5.00 13 3 St. Joseph Cou nty PS AP St. J oseph County PSA P 201 4 20 34 40 8 Monthly 2,657,69 6.50 2,386,507.92 0.00 0.00 0.00 2,386,507.92 0.00 13 9 Cen tury Center En ergy Saving s Impro v ements at Century Ctr.201 5 20 31 67 2 5/1 11/1 4,167,89 7.00 4,167,897.00 22,585.00 213,546.84 0.00 4,145,312.00 236,13 1.84 14 1 Park s and Rec reation Bo nd Parks Improveme nts 201 5 20 35 40 8 2/1 8/1--5,605,00 0.00 5,505,000.00 2 10,000.00 178,631.26 0.00 5,295,000.00 388,63 1.26 14 5 Sewage W orks Reve nue Bon ds -20 15 Sewer Impr ovemen ts 201 5 20 25 64 9 6/1 12/1--27,440,00 0.00 27,440,000.00 2,4 75,000.00 538,128.89 0.00 24,965,000.00 3,013,12 8.89 15 6 2 016 W ater Wo rks Refu nding Bon ds R efunding 20 00 / 2 006 SRF 201 6 20 27 62 5 1/1 7/1--3,300,00 0.00 0.00 0.00 0.00 3,3 00,0 00.00 3,300,000.00 0.00 xxx Total Bond Debt 2 34,877,59 3.50 140,677,079.92 11,3 65,617.00 4,163,726.25 3,3 00,0 00.00 132,611,462.92 15,529,34 3.25 Loa ns Payab le 6 8 State R evolving F und W ater W orks Improvement 200 9 20 30 62 5 1/1 7/1--427,33 2.00 352,793.00 20,231.00 11,889.12 0.00 332,562.00 32,12 0.12 8 2 In terfu nd Loan 41 0 - UDAG 1st Sour c e/Marriott Garage 201 0 20 15 41 0 6/15 12/1 5--2,700,00 0.00 1,589,770.50 2 38,172.75 0.00 0.00 1,351,597.75 238,17 2.75 2 6 State R evolving F und W ater W orks Improvements 200 0 20 19 62 5 1/1 7/1--2,600,00 0.00 698,431.00 1 67,193.00 20,254.00 0.00 531,238.00 187,44 7.00 xxx Total Loans Pa yable 29,822,33 2.00 2,640,994.50 4 25,596.75 32,143.12 0.00 2,215,397.75 457,73 9.87 Ca pita l Leases 5 1 Ch ase LE D Equipmen t 200 7 20 17 10 1 1/1 7/1--1,531,57 3.00 380,582.65 1 86,262.63 14,317.03 0.00 194,320.02 200,57 9.66 8 9 Sun Trust Police, Parks, Bl dg vehicles 201 1 20 16 40 4/20 1/600 3/15 6/15 9/15 12/15 2,068,20 2.00 215,915.15 2 15,915.15 1,567.54 0.00 0.00 217,48 2.69 9 0 Cap ital One Public Fundin g Solid Was te Cont ai ners/Truc k s 201 1 20 16 61 1 3/15 6/15 9/15 12/15 207,43 2.00 32,195.78 32,195.78 268.39 0.00 0.00 32,46 4.17 9 1 GE Cap ital I nfor mation Techn ology Police Dept Copier 201 1 20 16 10 1 1/11 4/11 7/11 10/11 3,83 6.00 437.96 437.96 7.40 0.00 0.00 44 5.36 9 2 Key Finance IT Phone S ystem 201 1 20 16 40 4 1/15 1,444,99 5.97 288,182.13 2 88,182.13 7,217.28 0.00 0.00 295,39 9.41 9 4 Iko n Office Solu t ions Mayor Ric oh M P 2851 SP Copier 201 1 20 16 10 1 2/15 5/15 8/15 11/15 2,56 9.53 570.81 571.81 17.67 1.00 0.00 58 9.48 9 5 Sun Trust E quipme nt F in ance Parks-Golf C ars Lease 201 2 20 16 20 1 4/15 10/1 5--344,50 0.00 44,305.79 44,305.79 355.45 0.00 0.00 44,66 1.24 9 7 Sun Trust E quipme nt F in ance Police Veh ic le s & Equ ipment 201 2 20 17 40 6 5/15 11/1 5--1,295,00 0.00 400,372.65 2 65,787.43 5,663.85 0.00 134,585.22 271,45 1.28 9 8 PNC Equipm ent F inance Pu bl ic W orks Vehicles Lease 201 2 20 17 20 2/64 1/640 5/15 11/1 5--945,67 4.38 291,194.81 1 93,401.30 3,657.54 0.00 97,793.51 197,05 8.84 10 0 PNC Equipm ent F inance Pu bl ic W orks Vehicles Lease 201 2 20 17 20 2/64 1/600/288 1/15 7/15--2,806,05 4.00 1,143,200.82 5 67,884.27 13,067.06 0.00 575,316.55 580,95 1.33 10 2 Iko n Office Solu t ions / Ricoh W astewater C opier 201 2 20 17 64 1 Monthly 1st 5,74 4.95 1,997.49 1,240.72 81.20 0.00 756.77 1,32 1.92 10 3 GE Cap ital I nfor mation Techn ology Fire Department Cop ie r 201 2 20 17 10 1 2/28 5/28 8/28 11/28 5,47 1.01 2,099.54 1,172.86 97.94 0.00 926.68 1,27 0.80 10 6 Ricoh U SA (N ew)C entra l Servi c es Copier 201 3 20 18 22 2 2/27 5/27 8/27 11/27 3,62 2.78 1,586.46 770.64 69.12 0.00 815.82 83 9.76 10 7 Ricoh U SA Street/Sewer Dept Copier 201 3 20 18 20 2/641 3/4 6/4 9/4 12/4 5,55 9.15 2,383.09 1,157.16 113.64 0.00 1,225.93 1,27 0.80 10 8 Ricoh U SA C ity Att orney C opier 201 3 20 18 10 1 2/12 5/12 8/12 11/12 5,55 9.15 2,395.32 1,162.59 108.21 0.00 1,232.73 1,27 0.80 10 9 Ricoh U SA Parks & Rec Ricoh Copi ers(3)201 3 20 18 20 1 2/21 5/21 8/21 11/21 16,12 9.94 6,948.65 3,373.56 313.68 0.00 3,575.09 3,68 7.24 11 0 PNC Equipm ent F inance Vehi c le/Equipmen t Lease 201 3 20 18 10 1/20 2/406/641 1/15 7/15--1,689,66 9.59 1,027,650.03 3 38,392.15 11,508.38 0.00 689,257.88 349,90 0.53 11 1 Ricoh U SA En gi neer in g P l otter/Scan ner 201 3 20 18 10 1 3/3 6/3 9/3 12/3 10,66 7.67 4,716.87 2,257.61 334.39 0.00 2,459.26 2,59 2.00 11 2 Ricoh U SA Bu ildin g Dept. Co pi er 201 3 20 18 60 0 Monthly 4,09 3.64 2,323.16 831.39 107.61 0.00 1,491.77 93 9.00 11 3 Sun Trust E quipme nt F in ance Police and PW vehicles 201 3 20 18 40 4/65 5/611/202 4/24 10/2 4--1,506,46 5.26 918,109.86 3 01,217.97 13,363.17 0.00 616,891.89 314,58 1.14 11 4 Ricoh U SA Admi n & Fina nce Copier 201 3 20 18 10 1 1/16 4/16 7/16 10/16 11,24 7.97 5,386.95 2,307.59 263.65 0.00 3,079.36 2,57 1.24 11 7 Police Dept. R ecord D iv. R icoh Police Rec ords Co pi er 201 3 20 18 10 1 Monthly 3rd--9,67 8.26 6,123.92 1,929.78 290.22 0.00 4,194.14 2,22 0.00 11 8 Wat er Works Main R i c oh Copier W ater W orks M ain Ricoh Co pi er 201 3 20 18 62 0 Monthly 10th--5,64 7.50 3,573.98 1,125.87 169.53 0.00 2,448.11 1,29 5.40 11 9 Wat er Works Colfax Ricoh C opier W ater W orks Colfa x R ico h Copier 201 3 20 18 62 0 Monthly 16th--4,73 2.65 2,995.07 943.45 142.07 0.00 2,051.62 1,08 5.52 12 0 Wat er Works Oliv e Ricoh Copier W ater W orks Olive Ricoh C opier 201 3 20 18 62 0 Monthly 10th--4,73 2.65 2,995.07 943.45 142.07 0.00 2,051.62 1,08 5.52 12 3 Police T raining D ept. Ricoh C opier Tra in i ng Copier 201 4 20 19 10 1 Monthly 30th--4,26 3.00 2,918.30 841.86 142.14 0.00 2,076.44 98 4.00 12 4 Police/Public Works V ehicle Leas e 2014 Ci ty V ehicles 201 4 20 19 Various 4/1 10/1--1,959,48 5.95 1,579,597.27 3 85,800.22 22,996.32 0.00 1,193,797.05 408,79 6.54 12 5 HP Computer Lease #1 C omputer Equipment Le ase 201 4 20 18 various Monthly 8th--137,10 4.95 94,725.09 31,199.46 3,624.89 0.00 63,525.63 34,82 4.35 12 6 HP Computer Lease #2 C omputer Equipment Le ase 201 4 20 18 20 1 and 620 Monthly 8th--4,00 0.00 2,854.47 907.46 113.02 0.00 1,947.01 1,02 0.48 12 7 HP Computer Lease #4 C omputer Equipment Le ase 201 4 20 18 40 4 Monthly 8th--5,88 6.15 4,154.42 1,359.12 136.92 0.00 2,795.30 1,49 6.04 12 8 HP Computer Lease #6 C omputer Equipment Le ase 201 4 20 18 20 1 Monthly 8th--3,75 5.50 2,759.48 841.49 115.63 0.00 1,917.99 95 7.12 12 9 HP Computer Lease #7 C omputer Equipment Le ase 201 4 20 18 62 0 Monthly 8th--1,32 6.00 1,009.77 303.72 33.12 0.00 706.05 33 6.84 13 0 Solid Waste C opier R icoh US A C opier 201 4 20 19 61 1 Monthly 17th--5,35 1.65 4,315.81 1,013.49 216.15 0.00 3,302.32 1,22 9.64 13 1 Police Com munications Copier R icoh US A C opier 201 4 20 19 10 1 Monthly 12th--8,84 3.00 6,583.31 1,706.32 325.50 0.00 4,876.99 2,03 1.82 13 2 Organic Resources & Was tewater R icoh US A C opiers 201 4 20 19 64 1 Monthly 21s t--12,26 0.18 8,934.98 2,376.82 440.18 0.00 6,558.16 2,81 7.00 13 4 Wat er Works Copier - Nort h S tation R icoh US A C opiers 201 4 20 19 62 0 Monthly 19th--4,73 2.65 3,071.37 939.12 146.40 0.00 2,132.25 1,08 5.52 13 6 HP Computer Lease #8 C omputer Equipment Le ase 201 5 20 19 40 4/20 1/611 Monthly 16th--19,60 3.94 16,169.83 4,315.69 716.87 0.00 11,854.14 5,03 2.56 13 7 Anima l Control Ricoh Copier R icoh US A C opiers 201 5 20 20 60 0 Monthly 30th--5,26 1.50 4,566.75 974.87 240.97 0.00 3,591.88 1,21 5.84 13 8 HP Computer Lease #9 C omputer Equipment Le ase 201 5 20 19 Various Monthly TBD--135,95 8.05 124,125.01 29,414.39 5,490.01 0.00 94,710.62 34,90 4.40 14 0 Vehicle & Equip. Lease Vehi c le/Equipmen t Lease 201 5 20 20 Various 1/15 7/15--3,425,27 3.58 3,425,273.58 6 61,428.23 51,237.13 0.00 2,763,845.35 712,66 5.36 14 3 HP Computer Lease #11 C omputer Equipment Le ase 201 5 20 19 40 4 Monthly--3,04 0.00 2,825.33 664.27 117.17 0.00 2,161.06 78 1.44 14 4 PNC Vehicle Lease No. 2 Vehi c le Lease Pu rchase 201 5 20 20 Various 5/15 11/1 5--1,267,18 3.00 1,267,183.00 2 45,327.64 19,067.24 0.00 1,021,855.36 264,39 4.88 14 6 Park s & Rec. Ricoh Cop ie r R icoh Copier 201 6 20 20 20 1 Monthly--4,30 2.06 4,219.84 765.12 221.52 0.00 3,454.72 98 6.64 14 7 Cen tral Services Lanier C opier C 5100 5 Copier 201 6 20 20 22 2 Monthly--32,52 5.00 0.00 3,857.81 1,086.03 32,5 25.00 28,667.19 4,94 3.84 14 8 Cen tral Services Lanier C opier C 6502 Copier 201 6 20 20 22 2 Monthly--11,41 3.00 0.00 1,353.69 381.11 11,4 13.00 10,059.31 1,73 4.80 14 9 Vehicle & Equip. Lease Pu bl ic W orks Vehicles Lease 201 6 20 21 Various 2/15 8/15--3,339,83 0.00 0.00 3 23,345.83 25,350.98 3,3 39,8 30.00 3,016,484.17 348,69 6.81 15 0 HP Computer Lease C opier L ease 201 6 20 20 Various Monthly--17,43 9.85 0.00 3,425.86 683.74 17,4 39.85 14,013.99 4,10 9.60 15 1 Admin and Finance R ic oh Copier C opier L ease 201 6 20 21 10 1 Monthly--10,92 3.63 0.00 1,985.36 519.88 10,9 23.63 8,938.27 2,50 5.24 15 2 PNC Vehicle / Equ ip Lease N o. 2 Vehi c le / E quipment Lea s e 201 6 20 21 Various 1/14 7/14--3,992,54 8.72 0.00 0.00 0.00 3,9 92,5 48.72 3,992,548.72 0.00 15 3 PNC Vehicle / Equ ip Lease Amend 1 Parks and R ecreat io n 201 6 20 21 20 1 1/17 7/17--78,80 8.00 0.00 0.00 0.00 78,8 08.00 78,808.00 0.00 15 4 PNC Vehicle / Equ ip Lease N o. 3 Parks & Rec / IT 201 6 20 21 20 1/279 4/19 10/1 9--1,256,09 6.99 0.00 0.00 0.00 1,2 56,0 96.99 1,256,096.99 0.00 15 5 HP Computer Lease No. 13 C omputer Equipment Le ase 201 6 20 20 Various Monthly---156,02 9.30 0.00 5,466.57 1,230.37 1 56,0 29.30 150,562.73 6,69 6.94 15 7 Venue, Parks, Ar t Copier R icoh Copier 201 6 20 21 20 1 Monthly---3,18 4.06 0.00 0.00 0.00 3,1 84.06 2,831.81 0.00 xxx T otal Cap ital L ease 30,212,98 7.87 11,343,531.62 4,1 63,385.45 207,877.38 8,8 98,7 99.55 16,078,593.47 4,371,26 2.83 To tal Civ i l C i ty 2 94,912,91 3.37 154,661,606.04 15,9 54,599.20 4,403,746.75 12,1 98,7 99.55 150,905,454.14 20,358,34 5.95 Fi nanci a l R e p or t De cembe r 2 0 1 6 - De b t Page 1 8 o f 25 City of South Bend Period Ending:December 31, 2016 Debt Schedule Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at 2016 Princip al 2016 Inter est 2016 Debt a t 2016 Total D eb t In strumen t D ebt Pur po se Issue Refunding M aturity F un d 1st 2nd 3rd 4th Is sue 12/3 1/20 15 Paym ents Payme nt Addit ion 12/31/20 16 D ebt P aymen ts Re dev elopment C ommis sion Debt Bond Deb t 7 Cen tury Center Lease Rental Reven ue C entury Center 199 4 2001/201 1 20 18 40 7 2/1 8/1--6,825,00 0.00 1,180,000.00 4 60,000.00 27,875.00 0.00 720,000.00 487,87 5.00 8 College Foot ball H all of Fame H al l of Fame 199 4 2000/201 1 20 18 31 3 2/1 8/1--15,370,00 0.00 3,010,000.00 1,1 80,000.00 88,015.00 0.00 1,830,000.00 1,268,01 5.00 1 1 Sout h B end Building C orporation Mor ris P AC 199 8 200 9 20 17 40 8 2/1 8/1--13,300,00 0.00 1,510,000.00 9 95,000.00 50,600.00 0.00 515,000.00 1,045,60 0.00 1 2 TJX Sp eci al Taxing D is t rict 200 2 201 4 20 22 32 4/40 4/414 1/1 7/1--6,620,00 0.00 2,615,000.00 4 05,000.00 78,450.00 0.00 2,210,000.00 483,45 0.00 5 Downt own Centr al Area T IF 200 3 201 1 20 24 42 0 2/1 8/1--19,795,00 0.00 13,760,000.00 1,2 60,000.00 655,958.00 0.00 12,500,000.00 1,915,95 8.00 6 Airport Development Are a TIF Airport TIF 200 3 201 1 20 24 32 4 2/1 8/1--14,420,00 0.00 7,845,000.00 7 20,000.00 373,987.50 0.00 7,125,000.00 1,093,98 7.50 2 2 Erskin e V illage TIF Development Bond Er s ki ne Vil la ge 200 5 20 27 43 2 2/1 8/1--5,485,00 0.00 4,035,000.00 2 35,000.00 254,502.50 0.00 3,800,000.00 489,50 2.50 5 4 L ease Ren t al R evenu e B onds of 200 8 Eddy S t reet Co mmons 200 8 20 27 42 9 2/15 8/15--36,000,00 0.00 31,450,000.00 1,3 75,000.00 1,095,929.43 0.00 30,075,000.00 2,470,92 9.43 8 1 Coveles k i Stadi um Reco v ery C oveleski S tadium 201 0 20 19 37 7 1/15 7/15--4,980,00 0.00 2,295,000.00 6 30,000.00 107,251.25 0.00 1,665,000.00 737,25 1.25 12 2 Synagogue at Coveleski Improvements C oveleski S tadium 201 4 20 18 37 7 1/31 500,00 0.00 300,000.00 1 00,000.00 0.00 0.00 200,000.00 100,00 0.00 13 5 2 015 Redevelopm ent Smar t St reets Smarts Stre ets 201 5 20 37 32 4 2/1 8/1 25,000,00 0.00 25,000,000.00 0.00 0.00 0.00 25,000,000.00 0.00 xxx Total Bond Debt 1 53,788,78 8.00 93,000,000.00 7,3 60,000.00 2,732,568.68 0.00 85,640,000.00 10,092,56 8.68 Loa ns Payab le 3 In di ana Development Finance Autho rity Bos c h P roperty (Nonforgive)200 1 20 21 21 0 3/22 6/22 9/22 12/22 1,040,00 0.00 363,854.70 61,785.55 10,224.89 0.00 302,069.15 72,01 0.44 4 In di ana Development Finance Autho rity Bos c h P roperty (Forgive)200 1 20 21 21 0----260,00 0.00 100,557.56 0.00 0.00 0.00 83,482.06 0.00 6 4 In terfu nd F und 412 - Major Mov es D ouglas Road TIF 200 9 20 29 43 5 2/15 8/15--1,040,31 9.00 635,520.00 3 12,515.00 28,673.00 0.00 323,005.00 341,18 8.00 8 4 In terfu nd F und 412 - Major Mov es Trian gle Development 201 1 20 29 43 6 2/15 8/15--2,000,00 0.00 1,422,330.30 92,756.87 27,985.13 0.00 1,329,573.43 120,74 2.00 8 5 In terfu nd F und 412 - Major Mov es Eddy S t reet Co mmons 201 1 20 26 43 6 2/15 8/15--4,100,00 0.00 3,013,862.52 6 29,514.66 142,921.34 0.00 2,384,347.86 772,43 6.00 8 6 In terfu nd F und 209 to Air port 324 Pr airie Ave Brownf ie ld Project 201 1 20 20 32 4 8/9---500,00 0.00 500,000.00 1 00,000.00 0.00 0.00 400,000.00 100,00 0.00 14 2 In terfu nd F und 412 - Major Mov es Parking Garage Improve ments 201 6 20 22 60 1 6/1 12/1 1,500,00 0.00 0.00 2 32,695.31 17,304.69 7 50,0 00.00 517,304.69 250,00 0.00 xxx Total Loans Pa yable 15,627,49 9.06 6,036,125.08 1,4 29,267.39 227,109.05 7 50,0 00.00 5,339,782.19 1,656,37 6.44 Ca pita l Lease xxx T otal Cap ital L ease 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Leas es 1 3 Tran s po Lea s e Main / C ol fax Gar age 200 6 20 25 40 4 3/15 9/15--2,510,27 8.00 1,558,918.00 1 23,580.00 76,420.00 0.00 1,435,338.00 200,00 0.00 xxx Tot al Lease 5,510,27 8.00 1,558,918.00 1 23,580.00 76,420.00 0.00 1,435,338.00 200,00 0.00 Tot al Red evelop ment Commiss ion 1 74,926,56 5.06 100,595,043.08 8,9 12,847.39 3,036,097.73 7 50,0 00.00 92,415,120.19 11,948,94 5.12 To tal Debt 4 69,839,47 8.43 255,256,649.12 24,8 67,446.59 7,439,844.48 12,9 48,7 99.55 243,320,574.33 32,307,29 1.07 Fi nanci a l R e p or t De cembe r 2 0 1 6 - De b t Page 1 9 o f 25 City of South Bend Period Ending:December 31, 2016 Monthly Debt Schedule Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at YT D Principa l Y TD Interes t YT D Debt a t D eb t In strumen t D ebt Pur po se Issue Refunding M aturity F un d 1st 2nd 3rd 4th Is sue 12/3 1/20 15 Paym ents Pay ments Ad ditions 12/31/20 16 Civil City Debt Bond Deb t A mort s ch # 3 1 CEDIT Bond 199 7 200 6 20 17 40 8 2/1 8/1--11,870,00 0.00 1,265,000.00 8 35,000.00 49,030.00 0.00 430,000.00 3 6 Sout h B end Building C orporation Pu bl ic W orks Building 200 1 201 0 20 21 40 4/649 2/1 8/1--9,250,00 0.00 3,315,000.00 5 60,000.00 113,226.00 0.00 2,755,000.00 2 5 Wat er Works Impr ovemen ts W ater W orks 200 2 201 2 20 23 62 5 7/1 12/3 1--5,975,00 0.00 2,745,000.00 3 65,000.00 54,900.00 0.00 2,380,000.00 3 9 Sout h B end Building C orporation Fire HQ / P ol ice H Q 200 3 201 2 20 23 40 4/324 2/1 8/1--21,335,00 0.00 10,085,000.00 1,2 00,000.00 365,560.00 0.00 8,885,000.00 2 4 Wat er Works Impr ovemen ts W ater W orks 200 6 20 27 62 5 7/1 12/3 1--4,710,00 0.00 3,090,000.00 2 20,000.00 137,800.00 0.00 2,870,000.00 6 2 Cen tury Center Spec i al Tax Bonds C entury Center 200 8 20 28 32 4 5/1 11/1--4,655,00 0.00 3,465,000.00 2 90,000.00 97,612.50 0.00 3,175,000.00 6 9 Wat er Works Impr ovemen ts W ater W orks 200 9 20 30 62 5 7/1 12/3 1--5,380,00 0.00 4,555,000.00 2 30,000.00 250,978.00 0.00 4,325,000.00 7 0 Sewage W orks Reve nue Bon ds - 2009 Sewag e W orks 200 9 20 28 64 9 6/1 12/1--3,297,00 0.00 2,407,675.00 1 58,032.00 67,656.00 0.00 2,249,643.00 8 0 2 010 Sewage W orks Re v enue Bonds Sewag e W orks 201 0 20 30 64 9 6/1 12/1--9,345,00 0.00 7,530,000.00 3 85,000.00 314,017.50 0.00 7,145,000.00 9 3 Sewage W orks Reve nue Bon ds 201 1 Sewag e W orks 201 1 20 31 64 9 6/1 12/1--21,500,00 0.00 18,175,000.00 8 80,000.00 680,700.00 0.00 17,295,000.00 9 9 2 012 W ater Wo rks Reven ue Bond W ater W orks 201 2 20 33 62 5 1/1 7/1--8,300,00 0.00 7,275,000.00 3 50,000.00 216,786.26 0.00 6,925,000.00 10 1 2 012 Sewage W orks Re v enue Bonds Sewag e W orks 201 2 20 32 64 9 6/1 12/1--25,000,00 0.00 21,935,000.00 1,0 45,000.00 507,580.00 0.00 20,890,000.00 10 5 2 013A Sewer Bon d Refunding Sewag e W orks 201 3 201 3 20 24 64 9 6/1 12/1--14,765,00 0.00 9,970,000.00 1,9 20,000.00 193,418.00 0.00 8,050,000.00 11 6 2 013 Building C orporation EMS / Fire D epar t ment 201 3 20 33 28 8 2/1 8/1--5,580,00 0.00 5,365,000.00 2 20,000.00 184,155.00 0.00 5,145,000.00 13 3 St. Joseph Cou nty PS AP St. J oseph County PSA P 201 4 20 34 40 8 Monthly---2,657,69 6.50 2,386,507.92 0.00 0.00 0.00 2,386,507.92 paid thru 2/28/1 7 13 9 Cen tury Center En ergy Saving s Impro v ements C entury Ctr.201 5 20 31 67 2 5/1 11/1--4,167,89 7.00 4,167,897.00 22,585.00 213,546.84 0.00 4,145,312.00 14 1 Park s and Rec Bo nd Parks Improveme nts 201 5 20 35 40 8 2/1 8/1--5,605,00 0.00 5,505,000.00 2 10,000.00 178,631.26 0.00 5,295,000.00 14 5 Sewage W orks Reve nue Bon ds - 2015 Sewer B ond Improvements 201 5 20 25 64 9 6/1 12/1--27,440,00 0.00 27,440,000.00 2,4 75,000.00 538,128.89 0.00 24,965,000.00 15 6 2 016 W ater Wo rks Refu nding Bon ds R efunding 20 00 / 2 006 SRF 201 6 20 27 62 5 1/1 7/1--3,300,00 0.00 0.00 3,3 00,0 00.00 3,300,000.00 xxx Total Bond Debt 2 34,877,59 3.50 140,677,079.92 11,3 65,617.00 4,163,726.25 3,3 00,0 00.00 132,611,462.92 Loa ns Payab le 6 8 State R evolving F und W ater W orks Improvement 200 9 20 30 62 5 7/1 12/3 1--427,33 2.00 352,793.00 20,231.00 11,889.12 0.00 332,562.00 8 2 In terfu nd Loan 41 0 - UDAG 1st Sour c e/Marriott Garage 201 0 20 15 41 0 6/15 12/1 5--2,700,00 0.00 1,589,770.50 2 38,172.75 0.00 0.00 1,351,597.75 2 6 State R evolving F und W ater W orks Improvements 200 0 20 19 62 5 7/1 12/3 1--2,600,00 0.00 698,431.00 1 67,193.00 20,254.00 0.00 531,238.00 xxx Total Loans Pa yable 29,822,33 2.00 2,640,994.50 4 25,596.75 32,143.12 0.00 2,215,397.75 Ca pita l Leases 5 1 Ch ase LE D Equipmen t 200 7 20 17 10 1 1/1 7/1--1,531,57 3.00 380,582.65 1 86,262.63 14,317.03 0.00 194,320.02 8 9 Sun Trust Police, Parks, Bl dg vehicles 201 1 20 16 40 4/20 1/600 3/15 6/15 9/15 12/15 2,068,20 2.00 215,915.15 2 15,915.17 1,567.53 0.00(0.02) 9 0 Cap ital One Public Fundin g Solid Was te Cont ai ners/Truc k s 201 1 20 16 61 1 3/15 6/15 9/15 12/15 207,43 2.00 32,195.78 32,195.78 268.39 0.00 0.00 9 1 GE Cap ital I nfor mation Techn ology Police Dept Copier 201 1 20 16 10 1 1/11 4/11 7/11 10/11 3,83 6.00 437.96 437.96 7.45 0.00 0.00 9 2 Key Finance IT Phone S ystem 201 1 20 16 40 4 1/15 1,444,99 5.97 288,182.13 2 88,182.13 7,217.28 0.00 0.00 9 4 Iko n Office Solu t ions Mayor Ric oh M P 2851 SP Copier 201 1 20 16 10 1 2/15 5/15 8/15 11/15 2,56 9.53 570.81 570.84 17.64 0.00(0.03) 9 5 Sun Trust E quipme nt F in ance Parks-Golf C ars Lease 201 2 20 16 20 1 4/15 10/1 5--344,50 0.00 44,305.79 44,305.79 355.45 0.00 0.00 9 7 Sun Trust E quipme nt F in ance Police Veh ic le s & Equ ipment 201 2 20 17 40 6 5/15 11/1 5--1,295,00 0.00 400,372.65 2 65,787.43 5,663.85 0.00 134,585.22 9 8 PNC Equipm ent F inance Pu bl ic W orks Vehicles Lease 201 2 20 17 20 2/64 1/640 5/15 11/1 5--945,67 4.38 291,194.81 1 93,401.30 3,657.54 0.00 97,793.51 10 0 PNC Equipm ent F inance Pu bl ic W orks Vehicles Lease 201 2 20 17 20 2/64 1/600/288 1/15 7/15--2,806,05 4.00 1,143,200.82 5 67,884.28 13,067.06 0.00 575,316.54 10 2 Iko n Office Solu t ions / Ricoh W astewater C opier 201 2 20 17 64 1 Monthly 1st--5,74 4.95 1,997.49 1,240.71 81.21 0.00 756.78 10 3 GE Cap ital I nfor mation Techn ology Fire Department Cop ie r 201 2 20 17 10 1 2/28 5/28 8/28 11/28 5,47 1.01 2,099.54 1,172.86 97.94 0.00 926.68 10 6 Ricoh U SA C entra l Servi c es Copier 201 3 20 18 22 2 2/27 5/27 8/27 11/27 3,62 2.78 1,586.46 774.43 65.33 0.00 812.03 10 7 Ricoh U SA Street/Sewer Dept Copier 201 3 20 18 20 2/641 3/4 6/4 9/4 12/4 5,55 9.15 2,383.09 1,157.16 113.64 0.00 1,225.93 10 8 Ricoh U SA C ity Att orney C opier 201 3 20 18 10 1 2/12 5/12 8/12 11/12 5,55 9.15 2,395.32 1,168.51 90.67 0.00 1,226.81 10 9 Ricoh U SA Parks & Rec Ricoh Copi ers(3)201 3 20 18 20 1 2/21 5/21 8/21 11/21 16,12 9.94 6,948.65 3,390.72 262.84 0.00 3,557.93 11 0 PNC Equipm ent F inance Vehi c le/Equipmen t Lease 201 3 20 18 10 1/20 2/406/641 1/15 7/15--1,689,66 9.59 1,027,650.03 3 38,392.14 11,508.38 0.00 689,257.89 11 1 Ricoh U SA En gi neer in g P l otter/Scan ner 201 3 20 18 10 1 3/3 6/3 9/3 12/3 10,66 7.67 4,716.87 2,257.61 334.39 0.00 2,459.26 11 2 Ricoh U SA Bu ildin g Dept. Co pi er 201 3 20 18 60 0 Monthly--4,09 3.64 2,323.16 831.38 107.62 0.00 1,491.78 11 3 Sun Trust E quipme nt F in ance Police and PW vehicles 201 3 20 18 40 4/65 5/611/202 4/24 10/2 4--1,506,46 5.26 918,109.86 3 01,217.97 13,363.17 0.00 616,891.89 11 4 Ricoh U SA Admi n & Fina nce Copier 201 3 20 18 10 1 1/16 4/16 7/16 10/16 11,24 7.97 5,386.95 2,307.59 263.65 0.00 3,079.36 11 7 Police Dept. R ecord D iv. R icoh Police Rec ords Co pi er 201 3 20 18 10 1 Monthly 3rd--9,67 8.26 6,123.92 1,929.77 290.23 0.00 4,194.15 11 8 Wat er Works Main R i c oh Copier W ater W orks M ain Ricoh Co pi er 201 3 20 18 62 0 Monthly 10th--5,64 7.50 3,573.98 1,125.86 169.54 0.00 2,448.12 11 9 Wat er Works Colfax Ricoh C opier W ater W orks Colfa x R ico h Copier 201 3 20 18 62 0 Monthly 16th--4,73 2.65 2,995.07 943.47 142.05 0.00 2,051.60 12 0 Wat er Works Oliv e Ricoh Copier W ater W orks Olive Ricoh C opier 201 3 20 18 62 0 Monthly 10th--4,73 2.65 2,995.07 943.47 142.05 0.00 2,051.60 12 3 Police T raining D ept. Ricoh C opier Tra in i ng Copier 201 4 20 19 10 1 Monthly 30th--4,26 3.00 2,918.30 841.86 142.14 0.00 2,076.44 12 4 Key Go v ernment Fi nance 2014 Ci ty V ehicles 201 4 20 19 various 4/1 10/1--1,959,48 5.95 1,579,597.27 3 85,800.22 22,996.32 0.00 1,193,797.05 12 5 HP Computer Lease #1 C omputer Equipment Le ase 201 4 20 18 various Monthly 8th--137,10 4.95 94,725.09 31,199.48 3,624.88 0.00 63,525.61 12 6 HP Computer Lease #2 C omputer Equipment Le ase 201 4 20 18 20 1 and 620 Monthly 8th--4,00 0.00 2,854.47 907.46 113.02 0.00 1,947.01 12 7 HP Computer Lease #4 C omputer Equipment Le ase 201 4 20 18 40 4 Monthly 8th--5,88 6.15 4,154.42 1,359.12 136.92 0.00 2,795.30 12 8 HP Computer Lease #6 C omputer Equipment Le ase 201 4 20 18 20 1 Monthly 8th--3,75 5.50 2,759.48 841.49 115.63 0.00 1,917.99 12 9 HP Computer Lease #7 C omputer Equipment Le ase 201 4 20 18 62 0 Monthly 8th--1,32 6.00 1,009.77 303.72 33.12 0.00 706.05 13 0 Solid Waste C opier R icoh US A C opier 201 4 20 19 61 1 Monthly 17th--5,35 1.65 4,315.81 1,013.49 216.15 0.00 3,302.32 13 1 Police Com munications Copier R icoh US A C opier 201 4 20 19 10 1 Monthly 12th--8,84 3.00 6,583.31 1,706.34 325.50 0.00 4,876.97 13 2 Organic Resources & Was tewater R icoh US A C opiers 201 4 20 19 64 1 Monthly 21s t--12,26 0.18 8,934.98 2,376.82 440.18 0.00 6,558.16 13 4 Wat er Works Copier - Nort h S tation R icho US A C opiers 201 4 20 19 62 0 Monthly 19th--4,73 2.65 3,071.37 939.13 146.39 0.00 2,132.24 13 6 HP Computer Lease #8 C omputer Equipment Le ase 201 5 20 19 40 4/20 1/611 Monthly 16th--19,60 3.94 16,169.83 4,315.69 716.87 0.00 11,854.14 13 7 Anima l Control Ricoh Copier R icoh US A C opiers 201 5 20 20 60 0 Monthly 30th--5,26 1.50 4,566.75 974.87 240.97 0.00 3,591.88 13 8 HP Computer Lease #9 C omputer Equipment Le ase 201 5 20 19 Various Monthly TBD--135,95 8.05 124,125.01 29,414.39 5,490.01 0.00 94,710.62 14 0 Vehicle & Equip. Lease Vehi c le/Equipmen t Lease 201 5 20 20 Various 1/15 7/15--3,425,27 3.58 3,425,273.58 6 61,428.23 51,237.13 0.00 2,763,845.35 14 3 HP Computer Lease #11 C omputer Equipment Le ase 201 5 20 19 40 4 Monthly 3,04 0.00 2,825.33 664.27 117.17 0.00 2,161.06 14 4 PNC Vehicle Lease No. 2 Vehi c le Lease Pu rchase 201 5 20 20 various 5/15 11/1 5--1,267,18 3.00 1,267,183.00 2 45,306.87 19,088.01 0.00 1,021,876.13 14 6 Park s & Rec reation Copier R icoh Copier 201 6 20 20 20 1 Monthly 4,30 2.06 4,219.84 765.12 221.52 0.00 3,454.72 14 7 Cen tral Services Lanier C opier C 5100 5 Copier 201 6 20 20 22 2 Monthly---32,52 5.00 0.00 3,857.81 1,086.03 32,5 25.00 28,667.19 14 8 Cen tral Services Lanier C opier C 6502 201 6 20 20 22 2 Monthly---11,41 3.00 0.00 1,353.69 381.11 11,4 13.00 10,059.31 14 9 Vehicle & Equip. Lease Pu bl ic W orks Vehicles Lease 201 6 20 21 various 2/15 8/15 3,339,83 0.00 0.00 3 23,345.83 25,350.98 3,3 39,8 30.00 3,016,484.17 15 0 HP Computer Lease C omputer Leas e- Ref resh 201 6 20 20 40 4/64 1/620 Monthly---17,43 9.85 0.00 3,425.86 683.74 17,4 39.85 14,013.99 15 1 Admin and Finance R ic oh Copier MPC800 2S P Copier 201 6 20 21 10 1 Monthly---10,92 3.63 0.00 1,985.36 519.88 10,9 23.63 8,938.27 15 2 PNC Vehicle / Equ ip Lease N o. 2 Vehi c le / E quipment Lea s e 201 6 20 21 various 1/14 7/14--3,992,54 8.72 0.00 0.00 0.00 3,9 92,5 48.72 3,992,548.72 15 3 PNC Vehicle / Equ ip Lease Amend 1 Parks and R ecreat io n 201 6 20 12 20 1 1/17 7/17--78,80 8.00 0.00 0.00 0.00 78,8 08.00 78,808.00 15 4 PNC Vehicle / Equ ip Lease N o. 3 Parks & Rec / IT 201 6 20 21 20 1/279 4/19 10/1 9--1,256,09 6.99 0.00 0.00 0.00 1,2 56,0 96.99 1,256,096.99 15 5 HP Computer Lease No. 13 C omputer Equipment Le ase 201 6 20 20 various Monthly 156,02 9.30 0.00 5,466.57 1,230.37 1 56,0 29.30 150,562.73 15 7 Venue, Parks, Ar t Copier R icoh Copier 201 6 20 21 20 1 Monthly 3,18 4.06 0.00 0.00 0.00 3,1 84.06 2,831.81 xxx T otal Cap ital L ease 30,212,98 7.87 11,343,531.62 4,1 63,390.65 207,825.97 8,8 98,7 98.55 16,078,587.27 To tal Civ i l C i ty 2 94,912,91 3.37 154,661,606.04 15,9 54,604.40 4,403,695.34 12,1 98,7 98.55 150,905,447.94 Fi nanci a l R e p or t De cembe r 2 0 1 6 - De b t Page 2 0 o f 25 City of South Bend Period Ending:December 31, 2016 Monthly Debt Schedule Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at YT D Principa l Y TD Interes t YT D Debt a t D eb t In strumen t D ebt Pur po se Issue Refunding M aturity F un d 1st 2nd 3rd 4th Is sue 12/3 1/20 15 Paym ents Pay ments Ad ditions 12/31/20 16 Re dev elopment C ommis sion Debt Bond Deb t 7 Cen tury Center Lease Rental Reven ue C entury Center 199 4 2001/201 1 20 18 40 7 2/1 8/1--6,825,00 0.00 1,180,000.00 4 60,000.00 27,875.00 0.00 720,000.00 8 College Foot ball H all of Fame H al l of Fame 199 4 2000/201 1 20 18 31 3 2/1 8/1--15,370,00 0.00 3,010,000.00 1,1 80,000.00 88,015.00 0.00 1,830,000.00 1 1 Sout h B end Building C orporation Mor ris P AC 199 8 200 9 20 17 40 8 2/1 8/1--13,300,00 0.00 1,510,000.00 9 95,000.00 50,600.00 0.00 515,000.00 1 2 TJX Sp eci al Taxing D is t rict 200 2 201 4 20 22 32 4/40 4/414 1/1 7/1--6,620,00 0.00 2,615,000.00 4 05,000.00 78,450.00 0.00 2,210,000.00 5 Downt own Centr al Area T IF 200 3 201 1 20 24 42 0 2/1 8/1--19,795,00 0.00 13,760,000.00 1,2 60,000.00 655,958.00 0.00 12,500,000.00 6 Airport Development Are a TIF Airport TIF 200 3 201 1 20 24 32 4 2/1 8/1--14,420,00 0.00 7,845,000.00 7 20,000.00 373,987.50 0.00 7,125,000.00 2 2 Erskin e V illage TIF Development Bond Er s ki ne Vil la ge 200 5 20 27 43 2 2/1 8/1--5,485,00 0.00 4,035,000.00 2 35,000.00 254,502.50 0.00 3,800,000.00 5 4 L ease Ren t al R evenu e B onds of 200 8 Eddy S t reet Co mmons 200 8 20 27 42 9 2/15 8/15--36,000,00 0.00 31,450,000.00 1,3 75,000.00 1,095,929.43 0.00 30,075,000.00 8 1 Coveles k i Stadi um Reco v ery C oveleski S tadium 201 0 20 19 37 7 1/15 7/15--4,980,00 0.00 2,295,000.00 6 30,000.00 107,251.25 0.00 1,665,000.00 12 2 Synagogue at Coveleski Improvements C oveleski S tadium 201 4 20 18 37 7 1/31 500,00 0.00 300,000.00 1 00,000.00 0.00 0.00 200,000.00 13 5 2 015 Redevelopm ent Smar t St reets Smart Stre ets 201 5 20 37 32 4 2/1 8/1 25,000,00 0.00 25,000,000.00 0.00 0.00 0.00 25,000,000.00 xxx Total Bond Debt 1 53,788,78 8.00 93,000,000.00 7,3 60,000.00 2,732,568.68 0.00 85,640,000.00 Loa ns Payab le 3 In di ana Development Finance Autho rity Bos c h P roperty (Nonforgive)200 1 20 21 21 0 3/22 6/22 9/22 12/22 1,040,00 0.00 363,854.70 61,785.55 10,224.89 0.00 302,069.15 4 In di ana Development Finance Autho rity Bos c h P roperty (Forgive)200 1 20 21 21 0----260,00 0.00 100,557.56 0.00 0.00 0.00 83,482.06 6 4 In terfu nd F und 412 - Major Mov es D ouglas Road TIF 200 9 20 29 43 5 2/15 8/15--1,040,31 9.00 635,520.00 3 12,515.00 28,673.00 0.00 323,005.00 8 4 In terfu nd F und 412 - Major Mov es Trian gle Development 201 1 20 29 43 6 2/15 8/15--2,000,00 0.00 1,422,330.30 92,756.87 27,985.13 0.00 1,329,573.43 8 5 In terfu nd F und 412 - Major Mov es Eddy S t reet Co mmons 201 1 20 26 43 6 2/15 8/15--4,100,00 0.00 3,013,862.52 6 29,514.66 142,921.34 0.00 2,384,347.86 8 6 In terfu nd F und 209 to Air port 324 Pr airie Ave Brownf ie ld Project 201 1 20 20 32 4 8/9---500,00 0.00 500,000.00 1 00,000.00 0.00 0.00 400,000.00 14 2 In terfu nd F und 412 - Major Mov es Parking Garage Improve ments 201 6 20 22 60 1 6/1 12/1--1,500,00 0.00 0.00 2 32,695.31 17,304.69 7 50,0 00.00 517,304.69 xxx Total Loans Pa yable 15,627,49 9.06 6,036,125.08 1,4 29,267.39 227,109.05 7 50,0 00.00 5,339,782.19 Ca pita l Lease xxx T otal Cap ital L ease 0.00 0.00 0.00 0.00 0.00 0.00 Leas es 1 3 Tran s po Lea s e Main / C ol fax Gar age 200 6 20 25 40 4 3/15 9/15--2,510,27 8.00 1,558,918.00 1 23,580.00 76,420.00 0.00 1,435,338.00 xxx Tot al Lease 5,510,27 8.00 1,558,918.00 1 23,580.00 76,420.00 0.00 1,435,338.00 Tot al Red evelop ment Commiss ion 1 74,926,56 5.06 100,595,043.08 8,9 12,847.39 3,036,097.73 7 50,0 00.00 92,415,120.19 To tal Debt 4 69,839,47 8.43 255,256,649.12 24,8 67,451.79 7,439,793.07 12,9 48,7 98.55 243,320,568.13 Fi nanci a l R e p or t De cembe r 2 0 1 6 - De b t Page 2 1 o f 25 City of South Bend Staffing Headcount Summary Budget Full Time Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Full Time Staff 1,102 1,078 1,087 1,082 1,079 1,078 1,072 1,068 1066 1072 1071 1075 1,079 Part Time Staff 122 115 115 137 135 114 116 117 103 133 118 103 Temporary / Seasonal 97 94 94 117 160 236 231 227 100 51 41 18 City Total 1,297 1,296 1,291 1,333 1,373 1,422 1,415 1410 1275 1255 1234 1,200 Financial Report December 2016 - Headcount Staffing Page 22 of 25 City of South Bend Staffing Headcount Full Time Staff Amended Budget FT Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor 7 7 6 6 6 6 6 6 6 7 7 7 6 311 Call Center 6 7 7 6 6 6 6 6 6 6 7 7 7 Admin & Finance 23 19 20 21 21 22 23 24 24 24 23 23 22 Innovation/ Technology Office 4 4 4 4 4 4 4 4 4 4 4 4 4 Safety & Risk 2 2 2 2 2 2 2 2 2 2 2 2 2 Clerk 5 5 5 5 5 5 5 5 4 4 4 5 5 Common Council 9 9 9 9 9 9 9 9 9 9 9 9 9 Legal Department 11 11 11 11 11 11 11 11 12 11 10 11 11 Sub Total 67 64 64 64 64 65 66 67 67 67 66 68 66 Code Enf. /Animal Control 24 24 24 24 24 24 24 24 24 24 22 23 22 Dept. of Community Investment 25 24 22 22 22 22 24 24 24 24 24 23 23 Parks & Recreation Administration 10 10 10 10 10 10 11 10 10 10 10 10 10 Maintenance 44 42 43 44 44 44 43 45 45 45 45 45 44 Golf Operations 10 7 7 7 8 8 8 8 8 8 8 7 7 Recreation Ops 25 25 25 25 24 25 25 25 25 25 25 25 25 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 1 1 1 1 1 1 1 Sub Total 91 87 88 89 89 90 90 91 91 91 91 90 89 Public Safety Police 306 299 304 299 297 296 292 287 284 283 289 289 287 Fire 258 261 259 258 254 254 251 251 251 259 259 257 268 Sub Total 564 560 563 557 551 550 543 538 535 542 548 546 555 Public Works Central Services 37 33 33 34 34 34 32 31 32 32 30 33 35 Office of Sustainability 2 1 1 1 1 1 1 2 2 2 2 2 2 Engineering 18 16 18 18 17 16 18 18 19 19 16 18 18 Maintenance 3 3 3 3 3 3 3 3 3 3 3 3 3 Solid Waste Operations 26 25 25 24 25 25 24 25 24 24 24 25 25 Code Clean Crew 4 4 4 4 4 4 4 4 4 4 4 4 4 Street Operations 58 56 58 58 58 58 58 58 58 58 59 59 59 Sewer Operations 31 30 30 32 32 32 32 31 32 32 33 33 31 Waste Water Ops 44 44 45 44 45 45 45 44 44 44 44 45 44 Organic Resources 6 6 6 6 6 6 6 6 6 6 6 6 6 Water Utility Ops 68 68 70 69 69 69 68 68 67 66 68 66 65 Sub Total 297 286 293 293 294 293 291 290 291 290 289 294 292 Building Department 14 13 12 13 14 13 14 14 14 14 14 14 14 Human Rights 6 6 6 6 6 6 6 6 6 6 6 6 6 Morris & Palais 14 14 15 14 15 15 14 14 14 14 11 11 12 City Total 1,102 1,078 1,087 1,082 1,079 1,078 1,072 1,068 1066 1072 1071 1075 1,079 Financial Report December 2016 - Headcount Staffing Page 23 of 25 City of South Bend Staffing Headcount Part Time Staff Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor 1 1 1 1 1 1 1 1 1 1 1 1 311 Call Center 1 1 1 2 2 2 2 2 2 0 0 0 Admin & Finance 1 1 1 1 2 1 1 1 0 0 0 0 Safety and Risk 0 0 0 0 0 0 0 0 0 0 0 0 Innovation/ Technology Office 0 0 0 0 0 1 0 1 1 1 1 1 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 Legal Department 1 1 1 1 1 1 1 1 1 1 1 1 Sub Total 4 4 4 5 6 6 5 6 5 3 3 3 Code Enf. / Animal Control 2 2 2 2 2 2 2 2 2 2 3 3 Dept. of Community Investment 0 0 0 0 0 0 0 0 0 0 0 0 Parks & Recreation Administration 6 6 6 6 4 3 3 3 3 3 6 3 Maintenance 7 6 6 9 10 11 11 11 10 14 14 9 Golf Operations 18 18 18 32 32 41 41 41 0 27 13 2 Recreation Ops 38 39 39 41 40 33 33 39 43 40 34 35 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 1 3 4 Sub Total 69 63 63 82 82 85 85 91 53 85 70 53 Public Safety Police 30 28 28 29 27 3 2 2 25 26 24 26 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 30 28 28 29 27 3 2 2 25 26 24 26 Public Works` Central Services 1 1 1 1 1 1 7 1 1 1 1 1 Engineering 2 2 2 2 2 2 1 1 1 1 1 1 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 4 4 4 4 4 4 4 4 4 4 8 8 Sewer Ops 2 2 2 4 3 3 2 2 4 3 0 0 Waste Water Ops 0 0 0 0 0 0 0 0 0 0 0 0 Water Utility Ops 4 4 4 3 3 3 3 3 3 3 3 3 Sub Total 13 13 13 14 13 13 17 11 13 12 13 13 Building Department 0 0 0 0 0 0 0 0 0 0 0 0 Human Rights 0 1 1 1 1 1 1 1 1 1 1 1 Morris & Palais 4 4 4 4 4 4 4 4 4 4 4 4 City Total 122 115 115 137 135 114 116 117 103 133 118 103 Financial Report December 2016 - Headcount Staffing Page 24 of 25 City of South Bend Staffing Headcount Paid Temporary, Seasonal, and Intern Staff Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor 0 0 0 0 0 0 0 0 0 0 0 0 Admin & Finance 0 0 0 1 0 2 2 2 0 1 1 1 Safety and Risk 0 0 0 0 0 0 0 1 1 1 1 1 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 Legal 0 0 0 0 0 0 0 0 0 0 0 0 Sub Total 0 0 0 1 0 2 2 3 1 2 2 2 Code Enfor. / Animal 2 2 1 2 2 1 1 1 2 2 1 1 Dept. of Community Investment 0 0 1 0 0 0 0 0 0 0 0 0 Parks & Recreation Administration 6 5 4 4 3 2 3 3 0 0 4 0 Maintenance 4 3 7 20 31 39 38 38 19 6 0 1 Golf Operations 8 7 14 15 12 13 12 12 44 0 0 0 Recreation Ops 50 50 43 49 83 137 135 129 21 20 14 7 Zoological Ops 0 0 0 0 0 0 0 0 0 0 0 0 Graffiti Removal 1 1 1 1 1 1 1 1 1 0 0 0 Sub Total 69 66 69 89 130 192 189 183 85 26 18 8 Public Safety Police 14 14 13 12 0 14 15 15 0 0 0 0 Communications 0 0 0 0 0 0 0 0 0 0 0 0 Fire 0 0 0 0 0 0 0 0 0 0 0 0 Sub Total 14 14 13 12 0 14 15 15 0 0 0 0 Public Works Central Services 0 0 0 0 0 1 7 8 0 0 0 0 Engineering 8 4 4 4 12 12 11 11 3 4 6 2 Energy / Sustainability 0 3 3 3 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 3 3 3 3 1 0 0 1 Street Ops 2 3 2 3 4 4 0 0 4 4 13 3 Sewer Ops 2 2 1 3 4 4 0 0 4 1 0 0 Leaf Pickup 0 0 0 0 0 0 0 0 0 11 0 0 Waste Water Ops 0 0 0 0 2 1 1 1 0 0 0 0 Organic Resources 0 0 0 0 0 0 0 0 0 0 0 0 Water Utility Ops 0 0 0 0 2 2 2 2 0 0 0 0 Sub Total 12 12 10 13 27 27 24 25 12 20 19 6 Building Department 0 0 0 0 1 0 0 0 0 0 0 0 Human Rights 0 0 0 0 0 0 0 0 0 0 0 0 Morris & Palais 0 0 0 0 0 0 0 0 0 1 1 1 City Total 97 94 94 117 160 236 231 227 100 51 41 18 Financial Report December 2016 - Headcount Staffing Page 25 of 25