Loading...
HomeMy WebLinkAbout2017-07 Financial ReportPeriod Ending: Issued By: City of South Bend Financial Report Tab Page Contents Narrative 2 Brief discussion on notable fund activity Revenue 3-10 City Revenues Prop Tax Rev 11-12 Property Tax Revenue Collection Status Expenditures 13-17 Expenditures by Fund and Department Debt 18-19 Debt Status Debt Monthly 20-21 Current Debt at Month End Headcount 22-25 Staffing Levels Distribution Mayor Pete Buttigieg Chief of Staff Angela Kouters Deputy Chief of Staff Suzanna Fritzberg City Common Council Administration and Finance Department Heads Fiscal Officers July 31, 2017 Controller 2017-07 Financial Report Page 1 of 25 July 31, 2017 Financial Report The Financial Report provides current year financial information for each City fund in a condensed format. Information is provided for revenue (by type and fund), expenditures, property taxes, debt status, and staffing levels. This report is prepared monthly and supplements other reports that the City prepares such as the Controller's Cash Report, the Monthly Departmental Financial Report, and the Comprehensive Annual Financial Report (CAFR). Revenue by Type Revenue by Fund -Fund 291 (River Rescue), is at 151% of its budgeted revenue. This is revenue related to tuition fees for the river rescue class. -Fund 258 (Human Rights). This is revenue related to grants received to battle housing and employment discrimination. -Fund 294 (Police Academy). This is revenue related to the advancement of present and future police officers. -Fund 221(Landlord Registration), is at 58% of its budgeted revenue. This is revenue received from an Ordinance enacted by the Common Council in 2016. Property Taxes Expenditures Debt $3.5 million for façade improvements to the Studebaker project. Headcount If you have any questions regarding this report, please contact the Department of Administration and Finance at (574) 235-9216. As of July 2017, the City has spent 45% of budgeted expenditures, compared to 43% in July 2016. The General Fund has spent 53% of its 2017 budgeted expenditures,compared to 55%in 2016.The following funds have reached 60%or more of their budgeted expenditures as a result of bond payments: Fund 313 (Hall of Fame), Fund 377 (Professional Sports Development), and Fund 432 (TIF -Erskine Village). This month,various debt service payments were made in the amount of~$1.64 million to Sun Trust,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.Also this month, the City added ~$30 million of new debt. Items include $25 million for Eddy Street Phase II and The Full Time Headcount as of July was 1,089 vs.a budgeted amount of 1,107.Currently,there are a total of 18 vacant positions.The 18 open positions are in the following departments:Parks(2),Public Safety(10),Public Works(1),DCI(3),Morris and Palais(1),and Human Rights Commission (1). For discussion on property taxes,see section listed below.The overall percentage of budgeted revenues that have been received by the city is 54%,compared to 57%in July 2016.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 revenue type 317 (Hotel Motel Tax Cum Cap Improvements) has reached 100% of its budgeted revenue. As of July 2017,the general fund has reached 54%of its budgeted revenue,compared to 55%last year.The following funds have reached slightly above the normal percentage of their 2017 budgeted revenue amount at this time: Property taxes are received in June and December.Property taxes collected this month totaled~$41.8 million.Civil city funds received ~$27.5 million and TIF funds received~$14.3 million.For 2017,the projected levy collection rate is 95%or$75.6 million.Please note, 2017 civil city funds are budgeted to be ~$400,000 more than 2016 budget. - Funds 249 (PS LOIT), 404 (COIT), and 408 (EDIT) received normal and timely distributions this month. 2017-07 Financial Report Page 2 of 25 City of South Bend Period Ending:July 31, 2017 Revenue by Type Report $ Fund% Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Property Tax 311 Property Tax Civil City various- - - - - 27,489,054 - - - - - 27,489,054 50,071,000 55% 311 Property Tax TIF Districts various- - - - - 14,314,504 - - - - - 14,314,504 27,254,124 53% Sub Total- - - - - 41,803,558 - - - - - - 41,803,558 77,325,124 54% Income Tax 315 Econ Development Income Tax 408 883,344 883,344 866,667 866,667 866,667 866,667 866,667 - - - - - 6,100,024 10,433,361 58% 316 Local Option Income Tax - PS 249 622,302 622,302 622,302 622,302 622,302 622,302 622,302 - - - - - 4,356,111 7,467,618 58% 316 County Option Income Tax 404 871,605 871,605 871,605 871,605 871,605 871,605 871,605 - - - - - 6,101,238 10,459,265 58% Sub Total 2,377,250 2,377,250 2,360,574 2,360,574 2,360,574 2,360,574 2,360,574 - - - - - 16,557,373 28,360,244 58% St Joseph County (Remitted by) 312 Auto Excise Tax various- - - - - 1,680,548 - - - - - - 1,680,548 3,206,500 52% 312 Commercial Vehicle Tax various- - - - - 402,188 - - - - - - 402,188 843,000 48% 317 Hotel Motel Tax Century Center 670 637,500 - (318,750) 106,250 106,250 106,250 106,250 - - - - - 743,750 1,275,000 58% 317 Hotel Motel Tax Century Center 324- - - 197,500 - - - - - - - - 197,500 394,000 50% 317 Hotel Motel Tax Cum Cap Imprv 407 150,000 - - - - - - - - - - - 150,000 150,000 100% Sub Total 787,500 - (318,750) 303,750 106,250 2,188,986 106,250 - - - - - 3,173,986 5,868,500 54% State of Indiana (Remitted by) 335 Cigarette Tax 101/407- - - - - 148,523 - - - - - - 148,523 328,000 45% 335 State Pension Subsidy 701/702- - - - - 5,565,446 - - - - - - 5,565,446 11,124,891 50% 335 Gaming Proceeds 101- - - - - - - - - - - - - 599,000 0% 335 Gasoline Tax 202/251 361,601 314,230 394,563 456,411 426,999 355,323 422,807 - - - - - 2,731,934 4,668,000 59% 335 Liquor Excise tax 101- 42,158 - - - - 28,925 - - - - - 71,082 75,000 95% 335 Liquor Gallonage Tax 101 63,498 - - 44,056 - - 56,137 - - - - - 163,691 210,000 78% 335 Prof Sports Development Tax 377 62,404 - 115,348 24,070 23,090 - - - - - - - 224,912 700,000 32% 335 Wheel Tax 202- - 503,523 - 451,523 - 372,905 - - - - - 1,327,951 2,050,000 65% Sub Total 487,503 356,388 1,013,434 524,537 901,612 6,069,292 880,773 - - - - - 10,233,539 19,754,891 52% Other Intergovernmental Sources 336 Federal Drug 299- - - - - - - - - - - - - 30,000 0% 337 State Drug 216 10,113 2,962 - 30 1,897 - - - - - - - 15,003 35,000 43% 337 Regional Cities Grant 201- - - - - - - - - - - - - 5,000,000 0% 338 Payment in Lieu of Tax various 517,361 871,113 517,361 871,113 517,361 517,361 517,361 - - - - - 4,329,031 7,623,328 57% 339 Contractual Service 211 9,669 12,407 38,314 17,294 7,957 11,557 7,257 - - - - - 104,452 316,000 33% Sub Total 537,143 886,481 555,675 888,436 527,215 528,918 524,618 - - - - - 4,448,485 13,004,328 34% Charge for Service Internal City 340 Liability Insurance 226 243,168 243,964 241,179 246,749 241,179 246,749 241,179 - - - - - 1,704,167 2,927,591 58% 340 General Government Misc Chgs 101/289- - - - - - - - - - - - - 500 0% 349 Central Service 222 51,820 48,684 51,854 49,741 49,575 50,298 46,813 - - - - - 348,786 873,809 40% 380 Central Service 222 210,212 208,994 226,075 189,251 209,433 210,487 197,836 - - - - - 1,452,288 2,880,310 50% 380 Energy Office Reimbursements 222 411,202 429,754 368,989 361,064 360,950 322,928 276,803 - - - - - 2,531,690 4,492,800 56% 380 LOIT 2016 Special Distribution 257- - 152,895 - - 52,501 - - - - - - 205,397 153,000 134% 380 IT Innovation 311 Center 279 430,621 430,621 430,621 430,621 430,621 430,621 430,621 - - - - - 3,014,347 5,205,034 58% 380 Beck's Lake Reimbursement 404- - 283,432 - - - - - - - - - 283,432 283,432 100% 380 INDOT SR 933 Transfer 324- - - - - - - - - - - - - 4,100,000 0% 380 Internal Service Reimbursement various 65,792 89,865 18,297 77,763 111,522 51,754 103,533 - - - - - 518,525 1,423,071 36% 392 Administration Fee 101/279 414,748 414,748 414,748 414,748 414,748 414,748 414,748 - - - - - 2,903,236 4,977,026 58% 392 Internal Fund Transfers various 1,085,348 9,754,150 4,553,299 4,585,904 1,649,180 1,807,518 1,279,407 - - - - - 24,714,805 41,710,246 59% 395 Employee Benefits 711/713 1,499,317 1,460,178 1,492,929 1,487,450 1,477,818 1,483,231 1,473,862 - - - - - 10,374,785 17,755,850 58% 2017-07 Fin anc i al Re port - Rev enue Report Page 3 of 25 City of South Bend Period Ending:July 31, 2017 Revenue by Type Report $ Fund% Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget 396 Central Service Refunds 222 1,314 - 62,668 (56,756) 2,392 1,416 - - - - - - 11,033 21,000 53% 396 Self Funded Employee Benefits 711 6,503 (2,436) 496 - - 389 41,857 - - - - - 46,808 4,563 1026% xxx xxx xxx- NA Sub Total 4,420,045 13,078,521 8,297,481 7,786,534 4,947,418 5,072,640 4,506,658 - - - - - 48,109,298 86,808,232 55% 3rd Party Revenue 340 ND EMS Service 288- - 44,904 - 1,338 14,152 2,832 - - - - - 63,226 150,000 42% 350 Job Target Penalty Fee 408- 354,660 - - - - - - - - - - 354,660 354,660 100% 364 Cable TV Franchise Fees 101- 192,238 - - - - - - - - - - 192,238 748,000 26% 366 AT&T Franchise Fees 101 55,865 - - - 51,778 - - - - - - - 107,643 284,000 38% 393 Debt Proceeds 750- - - - 2,916,500 - - - - - - - 2,916,500 5,499,000 53% Sub Total 55,865 546,898 44,904 - 2,969,616 14,152 2,832 - - - - - 3,634,267 7,035,660 52% Grants 331 Federal Grants various 468,447 1,200,229 111,355 149,580 103,356 263,868 96,934 - - - - - 2,393,770 9,090,424 26% 334 State Grants various- - 33,745 5,150 - 137,805 - - - - - - 176,700 703,499 25% Sub Total 468,447 1,200,229 145,100 154,730 103,356 401,673 96,934 - - - - - 2,570,470 9,793,923 26% Fees for Services External 320 Inspections Central Service 222- - - 450 350 270 - - - - - - 1,070 1,450 74% 321 Business License 101/222 30,917 29,318 15,746 12,407 11,383 4,566 1,656 - - - - - 105,993 120,130 88% 321 Code and Animal Fees 600 4,536 4,585 6,015 5,891 6,975 6,368 7,095 - - - - - 41,463 54,500 76% 322 Building Fees 600 90,363 86,593 108,895 95,111 141,205 195,184 108,715 - - - - - 826,065 1,360,350 61% 322 Code Enforcement Fees 600 1,050 300 3,000 1,500 600 2,800 1,200 - - - - - 10,450 20,000 52% 322 EMS Operating Fund 288 1,923 1,380 1,542 910 2,973 2,613 1,609 - - - - - 12,950 24,000 54% 322 General Government Fees 101 32,047 7,275 12,535 6,200 3,925 4,200 9,080 - - - - - 75,262 100,000 75% 341 General Government Various various 3,316 959 5,210 5,841 1,367 3,126 3,262 - - - - - 23,081 27,005 85% 342 Highway & Streets 101/202 38,686 - 16,474 2,320 43,516 13,142 - - - - - - 114,139 223,365 51% 342 Public Safety various 12,869 10,404 21,290 12,093 12,302 8,422 10,567 - - - - - 87,948 150,000 59% 342 EMS - County Fees 288- 294,414 147,207 147,207 147,207 147,207 147,207 - - - - - 1,030,450 1,740,000 59% 342 EMS - Capital Fund 287- 1,798,417 - - - - - - - - - - 1,798,417 4,485,349 40% 342 EMS - Operating Fund 288 160,939 235,524 271,371 210,652 215,161 283,974 218,716 - - - - - 1,596,338 2,700,000 59% 342 EMS - Neo Natal / Transport 288 16,185 18,553 16,128 14,553 4,909 167,113 37,377 - - - - - 274,818 1,699,512 16% 344 Solid Waste 610 445,203 460,843 468,017 403,574 285,268 412,168 416,424 - - - - - 2,891,497 5,636,175 51% 344 Code Environmental Clean Up 101/219/600 12,404 3,044 22,134 17,648 11,871 19,048 13,263 - - - - - 99,412 180,000 55% 344 Sewage Waste Water 641 3,208,590 3,128,008 3,112,534 3,105,650 3,096,610 3,192,879 3,215,485 - - - - - 22,059,755 37,020,404 60% 344 Sewer Repair Insurance 640 53,614 52,952 53,742 52,772 52,682 55,215 52,659 - - - - - 373,635 613,924 61% 344 Water Leak Insurance 620 81,303 81,237 81,371 81,350 81,736 81,925 81,942 - - - - - 570,864 980,000 58% 346 Water Works Utility 620 1,039,872 1,012,523 1,016,299 1,006,997 1,032,846 1,254,697 1,441,297 - - - - - 7,804,531 14,590,122 53% 346 Solid Waste Misc 610 1,504 10,324 12,564 40,321 44,124 42,440 42,652 - - - - - 193,928 110,000 176% 346 Project ReLeaf 655 36,802 36,730 36,817 36,854 37,012 37,156 37,164 - - - - - 258,535 440,153 59% 347 Parks & Recreation various 74,837 77,843 366,527 173,383 231,644 355,839 316,702 - - - - - 1,596,775 4,343,134 37% 347 Sale of Merchandise 101- - - - - 70 - - - - - - 70 100 70% 347 Morris PAC 416- 12,214 13,143 11,334 5,563 2,871 4,291 - - - - - 49,416 100,000 49% 349 Parking Garage Fees 601 115,464 73,834 83,097 119,933 135,473 65,973 116,506 - - - - - 710,279 1,000,629 71% 349 Code Demolition Board Up 219/600 2,805 2,067 13,981 5,115 1,466 20,689 12,810 - - - - - 58,933 90,000 65% 349 Parking Century Center 670 12,814 19,676 20,911 11,526 7,998 3,915 2,900 - - - - - 79,739 100,033 80% 349 Parking SBCDA 324/429 350 700 350 350 350 350 - - - - - - 2,450 8,400 29% 351 Fines & Fees various 27,430 36,628 37,210 30,621 38,987 57,046 17,958 - - - - - 245,880 261,820 94% 352 Forfeits various 734 616 3,897 5,014 1,556 23,381 8,542 - - - - - 43,742 200,000 22% 354 Ordinance Violation various 5,163 7,326 9,708 (3,068) 2,333 2,278 8,232 - - - - - 31,972 72,500 44% 360 Morris PAC various 10,087 86,686 184,282 72,560 46,729 117,156 32,782 - - - - - 550,281 976,000 56% 360 Palais Royale various 24,371 4,131 9,256 7,929 19,759 18,450 34,802 - - - - - 118,698 256,572 46% 360 Parks & Recreation various 9,055 4,207 4,552 9,758 3,205 5,864 4,035 - - - - - 40,676 98,206 41% 360 Police various 4,432 3,558 7,482 1,016 759 14,104 1,717 - - - - - 33,069 25,000 132% 360 Fire various- 37,987 - - - - 9 - - - - - 37,996 - NA 360 TIF various 31,545 2,510 6,859 2,110 2,110 309,933 2,273 - - - - - 357,338 637,204 56% 360 Central Services 222 608 - 50 251 623 57 179 - - - - - 1,768 11,000 16% 360 Century Center 670- 120 578 303 - - - - - - - - 1,000 10,000 10% 360 Dept. Of Community Investment 211/212 65,547 23 - 67,821 291 119,174 55 - - - - - 252,911 197,000 128% 360 EMS Operating Fund 288 525 - - - 72 - 2,593 - - - - - 3,190 5,000 64% 360 Engineering / Curb & Sidewalk 101- 50 50 - 125 275 275 - - - - - 775 11,000 7% 360 Fire and Police Pension Fund 701/702 1,523 675 5,700 565 595 5,022 290 - - - - - 14,369 2,000 718% 360 Industrial Revolving 754- - 3,703 1,121 - - - - - - - - 4,824 27,000 18% 360 General Government Various 101/3/226 13,427 24 266 148 244 - 241 - - - - - 14,351 14,000 103% 360 Motor Veh Highway Scrap Metal 202 285 - 1,117 209 1,515 711 - - - - - - 3,838 4,896 78% 360 Motor Veh Highway Curb Prgm 202 11 - - 1,366 - - - - - - - - 1,377 32,000 4% 360 Local Roads and Streets 251- 274 - - - 3,812 - - - - - - 4,087 275 1486% 360 Professional Sports Development 377 17,864 - - - - - 14,460 - - - - - 32,324 30,000 108% 2017-07 Fin anc i al Re port - Rev enue Report Page 4 of 25 City of South Bend Period Ending:July 31, 2017 Revenue by Type Report $ Fund% Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget 360 C.O.I.T.404 725 - 1,450 5,051 - - - - - - - - 7,226 - NA 360 Code / Animal Control 600 170 5 - - 181 - - - - - - - 356 6,500 5% 360 Building Fees 600- - - 898 - - - - - - - - 898 - NA 360 Parking Garage 601 20 - 180 - 96 - - - - - - - 296 11,282 3% 360 Solid Waste Fund 610- 265 - 2,357 - 229 - - - - - - 2,850 2,650 108% 360 Waste Water 641/7/9- 3,437 - 5,103 4,546 4,002 690 - - - - - 17,777 52,500 34% 360 Water Works Utility 620 / 625- 39 18 2,167 2,237 12,780 25 - - - - - 17,266 37,751 46% 360 Sewage Depreciation Fund 642- 400,000 - - - - - - - - - - 400,000 400,000 100% 360 Equipment / Vehicle Leasing 750- - - - - - 161,154 - - - - - 161,154 NA 362 Dept. Of Community Investment 212 1,847 - - 1,847 - - - - - - - - 3,694 7,387 50% 362 Palais Royale 101- 5,114 1,940 1,745 11,426 11,032 10,491 - - - - - 41,748 82,500 51% 362 Police 101- - - 7,238 - - - - - - - - 7,238 48,000 15% 362 Parks & Recreation 201 3,786 3,545 5,828 3,970 6,820 6,514 4,422 - - - - - 34,885 43,500 80% 362 S Bend School Corp Fee 407- - - - - - 25,000 - - - - - 25,000 25,000 100% 362 TIF Property various 14,223 24,108 14,479 13,450 6,588 15,451 11,619 - - - - - 99,918 319,603 31% 369 Memorial Hosp Leighton Plaza 408 150,000 - - - - - - - - - - - 150,000 150,000 100% 371 Century Center Fees 670 260,617 191,881 72,253 282,346 298,445 201,174 303,672 - - - - - 1,610,388 2,809,278 57% 399 Bosch Retention Project 210- - 15,737 - - 15,855 - - - - - - 31,592 63,661 50% 399 Principal on Loan various 19,897 19,842 19,726 20,742 601 577 1,241 - - - - - 82,625 86,374 96% 399 Principal Income various 30,702 596,589 - 31,814 - - 31,814 - - - - - 690,918 1,254,928 55% Sub Total 6,172,987 8,889,356 6,333,219 6,158,391 6,066,357 7,329,097 6,979,149 - - - - - 47,928,556 86,191,122 56% Interest Income 361 Bank Account Interest various 156,963 166,772 205,325 97,825 95,274 271,135 328,751 - - - - - 1,322,045 1,719,848 77% Sub Total 156,963 166,772 205,325 97,825 95,274 271,135 328,751 - - - - - 1,322,045 1,719,848 77% Donations 367 ND Contribution 101- - - - - - 330,000 - - - - - 330,000 337,500 98% 367 Donations various 75,816 1,040 70,660 440 25,155 55,987 44,782 - - - - - 273,879 281,244 97% Sub Total 75,816 1,040 70,660 440 25,155 55,987 374,782 - - - - - 603,879 618,744 98% Historic Preservation 368 C.O.I.T.404- - - 500 250 250 1,000 - - - - - 2,000 - 368 Palais 450 1,838 114 345 390 646 1,410 2,472 - - - - - 7,214 16,500 44% Sub Total 1,838 114 345 890 896 1,660 3,472 - - - - - 9,214 16,500 56% Sale of Assets 391 TIF (Property Sales / Land)various- 60,000 2 1 61,029 - 1 - - - - - 121,033 137,331 88% 391 Water Hydrant Reimbursement 620- - - - - - - - - - - - - 20,000 0% 391 Proceeds F.A. Disposal 600- - - - - - - - - - - - - 3,000 0% 391 Sale of Fixed Assets various- - - - - 1,137 - - - - - - 1,137 15,000 8% 391 Vehicle Damage Reimbursement various- - - - - - - - - - - - - - NA - Sub Total- 60,000 2 1 61,029 1,137 1 - - - - - 122,170 175,331 70% Revenue Total 15,541,356 27,563,049 18,707,970 18,276,109 18,164,753 66,098,808 16,164,794 - - - - - 180,516,841 337,319,001 54% report 15,541,356 27,563,049 18,707,971 18,276,109 18,164,753 66,098,808 16,164,795 - - - - - 180,516,841 337,319,001 - 0 (1) 0 (0) 0 (1) - - - - - (0) - 2017-07 Fin anc i al Re port - Rev enue Report Page 5 of 25 City of South Bend Period Ending:July 31, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget General Government 0000 General Revenues 101 1,105,267 1,215,293 975,765 1,001,269 1,006,845 24,478,271 1,381,463 - - - - - 31,164,173 57,242,002 54% 0101 Mayor 101- - - - - 70 - - - - - - 70 600 12% 0401 Administration and Finance 101 12,254 - 8 - - - - - - - - - 12,262 12,304 100% 0501 Legal 101 18,475 - - - 18,875 - 18,875 - - - - - 56,225 75,377 75% Sub Total 1,135,996 1,215,293 975,773 1,001,269 1,025,720 24,478,341 1,400,338 - - - - - 31,232,729 57,330,283 54% Public Works 0602 Engineering 101 32,047 7,275 12,535 6,200 4,050 4,475 9,305 - - - - - 75,887 317,337 24% Sub Total 32,047 7,275 12,535 6,200 4,050 4,475 9,305 - - - - - 75,887 317,337 24% Public Safety 0801 Police 101 34,608 15,151 13,175 13,089 10,980 16,268 9,894 - - - - - 113,166 336,000 34% 0901 Fire 101 4,387 37,987 - - - - 9 - - - - - 42,382 1,500 2825% Sub Total 38,995 53,138 13,175 13,089 10,980 16,268 9,903 - - - - - 155,548 337,500 46% Arts & Culture 0404 Morris PAC 101 10,888 86,733 183,972 72,872 46,790 113,721 33,286 - - - - - 548,262 965,000 57% 0405 Palais Royale 101 26,265 9,345 13,108 10,025 33,527 30,706 47,868 - - - - - 170,845 358,902 48% xxx xxx- NA Sub Total 37,153 96,078 197,080 82,898 80,317 144,427 81,154 - - - - - 719,107 1,323,902 54% General Fund Revenue Total 1,244,191 1,371,784 1,198,563 1,103,455 1,121,067 24,643,511 1,500,699 - - - - - 32,183,272 59,309,022 54% 2017-07 Financial Report - Rev enue Summar y Page 6 of 25 City of South Bend Period Ending:July 31, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Parks & Recreation 0000 Parks General revenue 201 2,200 357,973 3,346 356,258 672 5,358,382 3,408 - - - - - 6,082,238 10,999,007 55% 1100 Administration 201 3,787 3,548 5,830 3,974 7,149 6,524 4,562 - - - - - 35,374 43,600 81% 1101 Maintenance 201 28,074 104,996 4,776 82,975 77,815 45,183 58,498 - - - - - 402,317 1,707,710 24% 1102 Golf Operations 201 1,356 402 152,340 98,890 148,871 194,599 197,540 - - - - - 793,999 1,525,934 52% 1103 Recreation Division 201 22 810 1,346 20 1,410 26,012 41,188 - - - - - 70,808 156,685 45% 1108 Graffiti Removal 201- - - - - 65,540 29,214 - - - - - 94,754 96,725 98% 1110 Marketing and Events 201- - - 69 - 162 1,717 - - - - - 1,948 570,471 0% 1111 Regional Cities Grant 201- - - - - - - - - - - - - 5,000,000 0% Recreation Non Reverting 203 75,681 75,021 213,432 75,516 66,022 68,745 106,575 - - - - - 680,990 1,381,787 49% East Race Waterway 271 1 1 1 1 1 2 2 - - - - - 8 22 35% Coveleski Stadium 401 68 69 79 38 35 104 99 - - - - - 492 40,900 1% Zoo Endowment 403 37 38 44 21 11 - - - - - - - 151 200 76% Park Non Reverting 405 4,566 174 571 25,620 26,282 1,232 1,027 - - - - - 59,471 439,850 14% Sub Total 115,792 543,031 381,765 643,382 328,266 5,766,485 443,830 - - - - - 8,222,550 21,962,891 37% Public Works Motor Vehicle Highway 202 317,873 1,223,876 828,325 1,361,365 833,924 286,692 703,745 - - - - - 5,555,800 9,934,110 56% Central Services 222 675,986 688,080 710,659 544,455 623,794 586,845 523,002 - - - - - 4,352,820 8,308,569 52% Central Services Capital 224 84 72 89 41 35 105 98 - - - - - 525 287,600 0% Local Roads & Streets 251 106,827 88,499 130,547 93,992 107,567 126,254 105,638 - - - - - 759,324 1,674,275 45% Local Road & Bridge Grant 265- 1,000,000 1,000,000 - - - - - - - - - 2,000,000 2,000,000 100% Project ReLeaf 655 37,450 37,428 37,604 37,214 37,325 38,215 38,248 - - - - - 263,485 444,556 59% Sub Total 1,138,220 3,037,955 2,707,224 2,037,067 1,602,646 1,038,111 1,370,730 - - - - - 12,931,953 22,649,110 57% Public Works Solid Waste Solid Waste Operations 610 445,931 471,682 480,834 494,568 329,577 455,642 459,819 - - - - - 3,138,053 5,799,475 54% Solid Waste Capital 611 179 240 100,039 83,600 20,027 290,004 65 - - - - - 494,153 836,313 59% Sub Total 446,110 471,922 580,873 578,168 349,604 745,646 459,884 - - - - - 3,632,206 6,635,788 55% Public Works Water Utility 0000 Water Works Revenues 620 973,972 948,744 947,938 952,254 965,980 1,147,589 1,322,131 - - - - - 7,258,608 13,578,036 53% 0630 Water Leak Insurance 620 81,303 81,237 81,371 81,350 81,736 81,925 81,942 - - - - - 570,864 980,000 58% 0660 Clay Water 620 72,507 69,573 74,940 69,858 75,790 126,952 129,104 - - - - - 618,723 1,192,586 52% Waterworks Capital 622 1,942 1,950 2,167 958 875 2,956 2,890 - - - - - 13,740 15,000 92% Waterworks Deposit 624 1,159 1,174 1,347 639 583 1,965 1,923 - - - - - 8,790 15,000 59% Waterworks Sinking 625 164,824 164,289 164,321 164,211 164,266 177,878 1,266 - - - - - 1,001,055 2,067,642 48% Waterworks Bond Reserve 626 1,154 1,073 1,235 594 548 1,828 1,791 - - - - - 8,223 16,000 51% Waterworks Debt Reserve 629 153,121 1,895 2,292 1,092 1,000 3,386 3,328 - - - - - 166,114 174,500 95% Sub Total 1,449,981 1,269,935 1,275,612 1,270,956 1,290,778 1,544,479 1,544,374 - - - - - 9,646,116 18,038,764 53% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 54,941 54,328 55,305 53,519 53,371 57,542 54,949 - - - - - 383,955 621,788 62% 0000 Wastewater Revenues 641 3,044,674 2,968,092 2,944,636 2,940,827 2,924,257 3,029,887 3,052,765 - - - - - 20,905,137 34,932,744 60% 0621 Sewer Department 641- 1,261 - - - 1,191 - - - - - - 2,452 2,500 98% 0625 Concrete Crew 641- 3,040 - - - - - - - - - - 3,040 74,500 4% 0650 Clay Sewage 641 177,865 174,732 185,177 179,053 184,419 191,141 188,087 - - - - - 1,280,473 2,162,160 59% Sewage Capital 642 5,472 404,555 5,255 444,486 502,267 508,096 508,114 - - - - - 2,378,246 4,887,000 49% Sewage Reserve 643 3,481 3,535 520,820 2,021 1,972 6,676 6,560 - - - - - 545,064 546,755 100% Sewage Bond Sinking 649 763,195 1,184 1,526,979 763,848 764,229 768,253 768,214 - - - - - 5,355,900 9,177,024 58% Sewage Works DS Reserve 653- 955 1,176 1,189 1,579 1,877 2,174 - - - - - 8,951 4,400 203% 2011 Sewer Bond 659 41 39 45 22 7 0 0 - - - - - 154 - NA 2012 Sewer Bond 661 2,379 2,201 2,530 1,144 984 3,053 2,666 - - - - - 14,959 50,000 30% Sub Total 4,052,047 3,613,922 5,241,923 4,386,109 4,433,084 4,567,716 4,583,529 - - - - - 30,878,330 52,458,871 59% 2017-07 Financial Report - Rev enue Summar y Page 7 of 25 City of South Bend Period Ending:July 31, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Public Safety - Police Police Seizures 216 10,276 3,136 200 127 1,986 300 297 - - - - - 16,322 36,000 45% Curfew Violations 218 9 35 24 5 17 54 54 - - - - - 198 1,000 20% Law Enforcement Education 220 31,608 16,002 30,754 31,643 18,459 16,970 17,860 - - - - - 163,296 221,500 74% Public Safety LOIT 249 622,980 622,745 623,084 622,832 622,663 623,768 623,678 - - - - - 4,361,750 7,473,618 58% Police Take Home Vehicle 278 561 575 660 315 288 977 1,521 - - - - - 4,897 4,000 122% Police Block Grant 280 3 3 3 2 1 5 5 - - - - - 22 50 45% Police Academy 294 5,456 4,561 2,023 886 2,483 288 111 - - - - - 15,808 22,500 70% COPS More Grants 295 1,055 36,332 946 1,029 10,378 1,054 1,011 - - - - - 51,804 123,500 42% Drug Enforcement 299 149 162 148 166 161 168 182 - - - - - 1,135 32,000 4% K-9 Unit 705 2 2 3 1 1 4 4 - - - - - 17 2,020 1% Sub Total 672,099 683,553 657,845 657,005 656,439 643,588 644,721 - - - - - 4,615,249 7,916,188 58% Public Safety - Fire EMS Capital 287 2,726 1,801,174 3,021 2,108 1,927 6,015 5,158 - - - - - 1,822,130 4,495,349 41% EMS Operating Fund 288 181,987 557,555 483,650 374,307 372,922 650,471 413,058 - - - - - 3,033,950 6,350,012 48% Hazmat 289 19 20 23 11 10 30 28 - - - - - 142 10,000 1% River Rescue 291 114 16,307 12,724 1,869 23,462 10,989 3,211 - - - - - 68,674 45,500 151% Sub Total 184,846 2,375,057 499,419 378,295 398,322 667,505 421,455 - - - - - 4,924,897 10,900,861 45% Department of Community Investment Studebaker/Oliver 209 25,242 626 34,113 56,725 9,707 1,070 28,801 - - - - - 156,283 422,587 37% State Grant 210 242 268 18,311 148 135 18,459 455 - - - - - 38,016 260,641 15% DCI Operating 211 10,748 394,129 39,598 398,624 8,536 13,387 8,822 - - - - - 873,844 2,291,309 38% 0000 Dept. of Community Investment 212 310,284 201,138 42,852 164,474 83,939 357,952 31,360 - - - - - 1,192,000 5,455,838 22% xxx Programs 212 93,743 - - - - - - - - - - - 93,743 - NA 0000 Economic Revenue Bond 281 21 21 24 12 11 36 35 - - - - - 159 200 80% Sub Total 440,280 596,182 134,898 619,981 102,326 390,903 69,474 - - - - - 2,354,045 8,430,575 28% Parking Garages 0000 Parking Garage Revenue 601 284 671 1,020 40 - - 108 - - - - - 2,122 9,100 23% 0460 Main Street 601 25,906 27,933 28,062 26,202 64,761 21,525 22,907 - - - - - 217,295 268,766 81% 0462 Leighton Plaza 601 58,466 24,331 25,191 82,032 58,385 19,301 73,829 - - - - - 341,534 497,484 69% 0463 Enforcement 601 4,969 4,623 7,202 3,586 4,680 6,223 10,585 - - - - - 41,869 89,500 47% 0464 Wayne Street 601 30,977 20,895 29,889 11,565 12,333 24,967 19,680 - - - - - 150,306 242,161 62% 0465 Eddy Street Commons 601- - - - - - - - - - - - - 15,900 0% Sub Total 120,601 78,453 91,364 123,425 140,159 72,016 127,108 - - - - - 753,125 1,122,911 67% Capital / Debt Service Hall of Fame 313 50 6 23 8 10 474,777 12 - - - - - 474,887 894,300 53% COIT 404 913,313 879,279 1,163,973 920,266 874,964 886,807 916,204 - - - - - 6,554,806 10,963,839 60% Cum Capital Development 406 357 436 410 184 169 259,526 492 - - - - - 261,573 484,500 54% Cum Capital Improvement 407 150,266 294 301 144 132 117,143 25,562 - - - - - 293,842 435,000 68% EDIT 408 1,041,459 1,981,678 877,267 871,706 870,753 882,446 882,180 - - - - - 7,407,488 11,733,257 63% UDAG 410 445 416 493 235 207 689 677 - - - - - 3,162 6,110 52% Major Moves 412 1,774 598,393 2,312 1,238 1,135 3,844 3,780 - - - - - 612,476 1,053,786 58% Morris PAC Improvement 416 436 12,664 13,666 11,585 5,797 3,677 5,090 - - - - - 52,915 104,000 51% Palais Historic Preservation 450 1,907 187 428 429 683 1,534 2,596 - - - - - 7,765 17,100 45% Hall of Fame Capital 677 372 378 431 200 182 612 598 - - - - - 2,772 5,000 55% SB Building Corp 755- 1,326,786 210 65 117 169 191 - - - - - 1,327,538 2,643,214 50% Parks Bond Debt Svc 757- 65,162 124 65,236 80 64,086 138 - - - - - 194,828 391,482 50% xxx xxx xxx- - - - - - - - - - - NA Sub Total 2,110,380 4,865,679 2,059,637 1,871,297 1,754,228 2,695,308 1,837,521 - - - - - 17,194,050 28,731,588 60% 2017-07 Financial Report - Rev enue Summar y Page 8 of 25 City of South Bend Period Ending:July 31, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Other Miscellaneous Rainy Day 102 7,644 7,773 8,937 4,262 3,906 13,232 13,013 - - - - - 58,768 60,000 98% Gift, Donation, Bequest 217 50,900 1,097 69,994 5,639 220 51,058 513 - - - - - 179,420 184,794 97% Unsafe Building 219 11,928 152,225 26,129 160,537 14,230 18,670 16,684 - - - - - 400,404 793,757 50% Landlord Registration 221 2,260 270 1,245 155 60 25 20 - - - - - 4,035 7,000 58% Loss Recovery 227 730 741 851 404 368 1,244 1,217 - - - - - 5,554 9,000 62% LOIT 2016 Special Distribution 257- 6,605 156,406 1,646 1,183 56,449 3,846 - - - - - 226,134 1,471,000 15% Human Rights 258 91,498 4,790 5,975 2,576 356 600 39,798 - - - - - 145,593 165,040 88% Morris Palais Marketing 273 34 582 1,132 577 947 3,950 58 - - - - - 7,280 18,300 40% IT / Innovation /311 Call Center 279 430,621 430,621 430,621 430,621 430,621 430,621 430,621 - - - - - 3,014,347 5,205,034 58% Professional Sports Development 377 80,547 318 115,357 24,107 23,146 214 14,680 - - - - - 258,368 732,000 35% 1201 Code Enforcement 600 12,749 366,188 37,109 380,781 6,482 53,138 29,672 - - - - - 886,118 1,810,451 49% 1207 Animal Control 600 4,706 187,306 6,015 188,107 6,975 6,368 7,095 - - - - - 406,570 789,865 51% 1306 Building Operations 600 92,341 88,523 111,064 97,168 142,392 199,102 112,431 - - - - - 843,020 1,376,150 61% Century Center 670 910,931 211,677 (225,009) 400,425 412,693 311,339 412,822 - - - - - 2,434,877 4,194,311 58% Century Center Capital 671 74 66 74 71 74 71 74 - - - - - 503 750 67% Century Center Energy Saving 672 6 4 4 4 4 4 55,520 - - - - - 55,546 192,297 29% Sub Total 1,696,966 1,458,786 745,904 1,697,080 1,043,657 1,146,084 1,138,062 - - - - - 8,926,538 17,009,749 52% Business Insurance 0000 Business Insurance Revenues 226 246,679 247,476 245,267 248,740 243,026 253,098 246,803 - - - - - 1,731,089 3,527,591 49% 0418 Workers Compensation 226 619 35,123 - - - 900 - - - - - - 36,642 30,000 122% Sub Total 247,298 282,599 245,267 248,740 243,026 253,998 246,803 - - - - - 1,767,732 3,557,591 50% Fiduciary Trust & Agency Fire Pension 701 335 84 - - - 2,461,856 - - - - - - 2,462,275 4,925,212 50% Police Pension 702 2,386 1,224 5,915 565 595 3,108,612 290 - - - - - 3,119,587 6,210,679 50% Employee Benefits 711 1,511,154 1,463,664 1,500,195 1,490,799 1,481,130 1,495,193 1,527,856 - - - - - 10,469,991 17,800,413 59% Unemployment Comp 713 217 214 244 114 102 339 329 - - - - - 1,559 2,000 78% City Cemetery Trust 730 22 22 25 12 11 37 37 - - - - - 167 200 83% Equipment / Vehicle Leasing 750- 298 375 223 2,916,712 532 161,897 - - - - - 3,080,037 5,501,000 56% Parks Bond Capital 751- 369 539 485 517 632 652 - - - - - 3,193 7,500 43% Smart Street Bond Capital 753- 604 663 544 545 606 561 - - - - - 3,523 17,000 21% Sub Total 1,514,115 1,466,478 1,507,957 1,492,742 4,399,611 7,067,807 1,691,621 - - - - - 19,140,331 34,464,004 56% Civil City Revenues 15,432,926 22,115,337 17,328,250 17,107,703 17,863,212 51,243,156 16,079,811 - - - - - 157,170,394 293,187,913 54% Tax Increment Financing TIF River West - Airport 324 78,976 118,077 87,148 235,509 71,358 9,426,694 42,749 - - - - - 10,060,511 23,498,324 43% TIF West Washington 422 1,411 1,497 1,721 821 751 200,696 2,595 - - - - - 209,491 436,000 48% TIF Leighton Plaza 425 10,467 14,196 10,498 8,768 8,762 8,914 9,074 - - - - - 70,677 197,014 36% TIF River East DEV (NE)429 5,927 6,699 11,342 3,606 3,279 1,437,646 9,487 - - - - - 1,477,986 3,221,467 46% TIF Southside 430 3,108 564,649 4,388 906,618 2,039 1,224,439 7,953 - - - - - 2,713,194 3,901,127 70% TIF Erskine Village 432 3,646 3,484 791 378 219 1 1 - - - - - 8,519 12,000 71% TIF Douglas Road 435 77 120 95 3 3 218,289 111 - - - - - 218,697 327,858 67% TIF River East RES (NE RE)436 442 - - - - 2,320,321 - - - - - - 2,320,763 3,300,903 70% Sub Total 104,055 708,721 115,983 1,155,702 86,411 14,837,000 71,969 - - - - - 17,079,840 34,894,693 49% 2017-07 Financial Report - Rev enue Summar y Page 9 of 25 City of South Bend Period Ending:July 31, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Redevelopment Funds Administration 433 6 6 7 4 3 10 9 - - - - - 46 135 34% Certified Technology Park 439 1,614 1,641 1,887 900 825 1,064 456 - - - - - 8,387 302,625 3% Airport Urban Enterprise Zone 454 288 292 336 160 147 498 489 - - - - - 2,211 3,900 57% Industrial Revolving 754- - 21,526 9,673 14,952 12,238 7,388 - - - - - 65,777 210,000 31% Sub Total 1,908 1,940 23,757 10,737 15,927 13,810 8,342 - - - - - 76,421 516,660 15% Debt Service Airport Debt Reserve 2003 315 780 792 902 434 398 1,346 1,323 - - - - - 5,974 14,000 43% Coveleski Bond Debt Reserve 317 385 391 450 214 197 666 655 - - - - - 2,957 5,000 59% Central Development reserve 328 1,303 1,323 1,522 725 664 2,249 2,210 - - - - - 9,996 15,000 67% SB Redevelopment Authority 752- 772,669 1,236,763 395 197,726 305 195 - - - - - 2,208,053 3,868,169 57% Smart Streets Debt Svc 756- 179 263 197 218 277 291 - - - - - 1,425 855,784 0% Erskine Village Debt. Svc 758- 3,961,697 82 1 - - - - - - - - 3,961,781 3,961,782 100% Sub Total 2,468 4,737,051 1,239,982 1,967 199,202 4,843 4,673 - - - - - 6,190,187 8,719,735 71% Redevelopment Commission 108,431 5,447,712 1,379,721 1,168,406 301,541 14,855,652 84,984 - - - - - 23,346,448 44,131,088 53% City Operations Total 15,541,357 27,563,049 18,707,971 18,276,109 18,164,753 66,098,808 16,164,795 - - - - - 180,516,842 337,319,001 54% Revenue report 15,541,356 27,563,049 18,707,971 18,276,109 18,164,753 66,098,808 16,164,795 0 0 0 0 0 180,516,842 337,319,001 0 0 0 0(0)0 0 0 0 0 0 0 0 0 2017-07 Financial Report - Rev enue Summar y Page 10 of 25 City of South Bend Period Ending:July 31, 2017 Property Tax Revenue 2016 Tax Pay 2017 Fund Fund #Levy Estimated Distribution 1 Distribution 2 Distribution 3 Distribution 4 Levy Per County Collection Projected 6/20/2017 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate City General Fund 101 40,248,867.00 0.95 38,236,423.65 21,820,142.51 - - - 21,820,142.51 18,428,724.49 54.21% Parks & Recreation 201 9,179,442.00 0.95 8,720,469.90 4,976,456.29 - - - 4,976,456.29 4,202,985.71 54.21% College Football Hall of Fame 313 833,277.00 0.95 791,613.15 451,820.36 - - - 451,820.36 381,456.64 54.22% Cumulative Capital District 406 443,869.00 0.95 421,675.55 240,635.07 - - - 240,635.07 203,233.93 54.21% Total - City 50,705,455.00 48,170,182.25 27,489,054.23 - - - 27,489,054.23 23,216,400.77 54.21% Tax Increment Financing Airport TIF District 324 18,698,946.24 0.95 17,763,998.93 8,932,881.19 - - - 8,932,881.19 9,766,065.05 47.77% West Washington TIF District 422 367,557.18 0.95 349,179.32 198,151.66 - - - 198,151.66 169,405.52 53.91% Northeast Residential TIF District 436 4,405,723.00 0.95 4,185,436.85 2,320,321.06 - - - 2,320,321.06 2,085,401.94 52.67% Southside TIF District #1 430 2,390,790.99 0.95 2,271,251.44 1,216,823.61 - - - 1,216,823.61 1,173,967.38 50.90% Douglas Road TIF District 435 321,949.68 0.95 305,852.20 218,279.99 - - - 218,279.99 103,669.69 67.80% Northeast TIF 429 2,766,113.25 0.95 2,627,807.59 1,428,045.99 - - - 1,428,045.99 1,338,067.26 51.63% Total - Tax Increment Financing 28,951,080.34 27,503,526.32 14,314,503.50 - - - 14,314,503.50 14,636,576.84 49.44% Grand Total 79,656,535.34 75,673,708.57 41,803,557.73 - - - 41,803,557.73 37,852,977.61 52.48% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 6/20/17 2017-07 Financial Report - Property Tax Revenue Page 11 of 25 City of South Bend Period Ending:July 31, 2017 Property Tax Revenue 2015 Tax Pay 2016 Fund Fund #Levy Estimated Distribution 1 Distribution 2 Distribution 3 Distribution 4 Levy Per County Collection Projected 6/14/2016 12/20/2016 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate City General Fund 101 40,360,212.00 0.95 38,342,201.40 21,490,881.50 17,871,257.85 - - 39,362,139.35 998,072.65 97.53% Parks & Recreation 201 8,090,885.00 0.95 7,686,340.75 4,312,625.82 3,590,369.07 - - 7,902,994.89 187,890.11 97.68% College Football Hall of Fame 313 1,396,308.00 0.95 1,326,492.60 744,229.93 617,281.74 - - 1,361,511.67 34,796.33 97.51% Cumulative Capital District 406 451,368.00 0.95 428,799.60 240,589.67 200,296.91 - - 440,886.58 10,481.42 97.68% Total - City 50,298,773.00 47,783,834.35 26,788,326.92 22,279,205.57 - - 49,067,532.49 1,231,240.51 97.55% Tax Increment Financing Airport TIF District 324 19,123,985.00 0.95 18,167,785.75 9,769,452.30 8,389,858.48 - - 18,159,310.78 964,674.22 94.96% West Washington TIF District 422 516,171.00 0.95 490,362.45 282,809.66 170,692.93 - - 453,502.59 62,668.41 87.86% Northeast Residential TIF District 436 3,913,816.00 0.95 3,718,125.20 2,061,402.42 1,871,544.98 - - 3,932,947.40 (19,131.40) 100.49% Southside TIF District #1 430 2,481,892.00 0.95 2,357,797.40 1,251,613.66 1,149,638.01 - - 2,401,251.67 80,640.33 96.75% Douglas Road TIF District 435 337,099.00 0.95 320,244.05 231,288.93 113,972.95 - - 345,261.88 (8,162.88) 102.42% Northeast TIF 429 2,586,566.00 0.95 2,457,237.70 1,170,979.07 1,177,628.87 - - 2,348,607.94 237,958.06 90.80% Total - Tax Increment Financing 28,959,529.00 27,511,552.55 14,767,546.04 12,873,336.22 - - 27,640,882.26 1,318,646.74 95.45% Grand Total 79,258,302.00 75,295,386.90 41,555,872.96 35,152,541.79 - - 76,708,414.75 2,549,887.25 96.78% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 6/14/16 Distribution 2 - Issued by St. Joseph County on 12/20/16 2017-07 Financial Report - Property Tax Revenue Page 12 of 25 City of South Bend Period Ending:July 31, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget General Government 0101 Mayor 101 59,009 57,926 57,827 61,110 54,678 84,839 65,163 - - - - - 440,552 872,923 50% 0201 Clerk 101 38,451 43,206 31,600 35,638 35,273 46,995 33,861 - - - - - 265,025 536,216 49% 0301 Common Council 101 33,451 49,728 27,207 50,580 28,885 34,287 33,776 - - - - - 257,913 571,148 45% 0302 WNIT Contract 101- - - - 43,000 - - - - - - - 43,000 43,000 100% 0401 Administration and Finance 101 184,278 178,933 181,407 203,805 206,704 261,723 192,964 - - - - - 1,409,814 2,476,351 57% 0501 Legal Department 101 87,585 86,783 87,565 116,630 75,744 109,460 80,722 - - - - - 644,488 1,158,567 56% Sub Total 402,773 416,575 385,606 467,764 444,284 537,304 406,485 - - - - - 3,060,792 5,658,205 54% Public Works 0602 Engineering 101 81,736 88,219 89,641 89,644 103,226 120,430 96,986 - - - - - 669,881 1,445,157 46% Sub Total 81,736 88,219 89,641 89,644 103,226 120,430 96,986 - - - - - 669,881 1,445,157 46% Public Safety 0801 Police 101 2,401,801 2,081,566 2,099,258 2,016,036 2,087,143 2,837,886 2,194,381 - - - - - 15,718,072 29,668,433 53% 0901 Fire 101 1,586,894 1,525,036 1,582,606 1,554,060 1,604,395 2,215,029 1,508,966 - - - - - 11,576,986 21,111,466 55% Sub Total 3,988,695 3,606,602 3,681,864 3,570,096 3,691,539 5,052,914 3,703,347 - - - - - 27,295,058 50,779,899 54% Code Enforcement Sub Total- - - - - - - - - - - - - - NA Arts & Culture 0404 Morris PAC 101 74,731 80,199 47,613 60,412 60,629 72,212 60,726 - - - - - 456,522 1,271,039 36% 0405 Palais Royale 101 24,999 30,061 10,824 17,021 18,169 22,340 17,757 - - - - - 141,172 530,200 27% Sub Total 99,730 110,260 58,436 77,434 78,798 94,553 78,483 - - - - - 597,694 1,801,239 33% Human Rights 1008 Human Rights 101 37,821 40,148 32,484 37,408 31,913 34,695 29,063 - - - - - 243,532 425,805 57% Sub Total 37,821 40,148 32,484 37,408 31,913 34,695 29,063 - - - - - 243,532 425,805 57% General Fund Expenditure Total 4,610,756 4,261,804 4,248,032 4,242,346 4,349,760 5,839,896 4,314,364 - - - - - 31,866,957 60,110,305 53% 2017-07 Financial Report - Expe nditu re Su mmary Page 13 of 25 City of South Bend Period Ending:July 31, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Parks & Recreation 1100 Administration 201 147,654 87,876 110,868 112,743 118,476 128,067 111,926 - - - - - 817,610 1,468,296 56% 1101 Maintenance 201 399,021 416,933 423,013 569,543 553,920 672,696 511,411 - - - - - 3,546,536 6,854,308 52% 1102 Golf Operations 201 54,483 75,381 77,362 180,384 131,801 173,015 147,904 - - - - - 840,330 1,638,575 51% 1103 Recreation Division 201 165,251 145,109 133,502 139,866 147,123 241,949 247,358 - - - - - 1,220,157 2,153,817 57% 1104 Potawatomi Zoo 201 355,692 7,425 7,231 7,208 289,717 8,923 6,660 - - - - - 682,856 704,464 97% 1106 Potawatomi Greenhouse 201 5,013 4,555 2,550 2,375 1,198 15,764 411 - - - - - 31,866 54,408 59% 1108 Graffiti Removal 201 13,483 12,628 11,465 10,265 8,529 10,420 7,557 - - - - - 74,347 97,861 76% 1110 Marketing and Events 201 16,583 45,412 58,810 61,326 60,810 83,508 58,196 - - - - - 384,644 953,588 40% 1111 Regional Cities Grant 201- - - - - - - - - - - - - 5,000,000 0% Recreation Non Reverting 203 51,478 47,722 45,821 94,361 71,392 92,875 159,108 - - - - - 562,756 1,599,683 35% East Race Waterway 271- - - - - - 1,353 - - - - - 1,353 1,367 99% Coveleski Stadium 401- - - 8,542 4,569 - 1,778 - - - - - 14,889 30,000 50% Zoo Endowment 403- - - 53,599 - (3,549) - - - - - - 50,049 49,688 101% Park Non Reverting 405 45,874 17,251 22,621 42,193 16,930 71,879 61,868 - - - - - 278,616 513,024 54% Sub Total 1,254,532 860,290 893,243 1,282,404 1,404,465 1,495,546 1,315,529 - - - - - 8,506,009 21,119,079 40% Public Works Motor Vehicle Highway 202 919,033 515,568 547,694 523,276 541,787 631,705 634,583 - - - - - 4,313,646 9,886,533 44% Curb and Sidewalk 202 150,920 40,047 37,646 38,164 143,273 121,813 209,102 - - - - - 740,965 1,878,998 39% Central Services 222 730,352 648,645 561,962 613,240 672,069 593,479 531,551 - - - - - 4,351,299 8,564,643 51% Central Services Capital 224 10,575 4,009 - 16,964 - 11,786 - - - - - - 43,335 326,025 13% Local Roads & Streets 251 209,999 4,801 3,018 35,678 92,276 81,399 305,836 - - - - - 733,006 2,211,544 33% Local Roads & Bridge 265- - - - - - 64 - - - - - 64 2,000,000 0% Project ReLeaf 655 15,049 90,567 3,684 115,917 3,108 3,165 14,951 - - - - - 246,441 525,416 47% Sub Total 2,035,929 1,303,638 1,154,005 1,343,240 1,452,512 1,443,345 1,696,086 - - - - - 10,428,755 25,393,159 41% Public Works Solid Waste Solid Waste Operations 610 489,623 312,159 388,501 385,830 347,815 685,660 407,427 - - - - - 3,017,016 5,662,910 53% Solid Waste Capital 611 286,902 146,712 218 83,859 20,129 219 286,862 - - - - - 824,899 1,135,613 73% Sub Total 776,525 458,871 388,720 469,689 367,944 685,879 694,289 - - - - - 3,841,915 6,798,523 57% Public Works Water Utility 0630 Water Leak Insurance 620 43,958 41,864 50,876 46,504 58,900 71,053 44,809 - - - - - 357,964 1,035,000 35% 0640 Water Works 620 1,417,876 1,256,524 1,085,407 1,142,917 1,117,427 1,222,741 987,180 - - - - - 8,230,072 16,688,754 49% 0660 Clay Water 620- - (0) 169 37 5 26 - - - - - 237 3,500 7% Waterworks Capital 622 111,938 177,777 13,775 9,295 8,299 17,201 58,155 - - - - - 396,439 1,414,466 28% Waterworks Deposit 624 874 1,174 1,347 639 583 1,965 1,923 - - - - - 8,505 15,000 57% Waterworks Sinking 625 815 289 321 211 266 255,311 52,101 - - - - - 309,314 2,054,891 15% Waterworks Bond Reserve 626- - - - - 10,000 - - - - - - 10,000 16,000 63% Waterworks Debt Reserve 629 1,394 1,895 2,292 1,092 1,000 3,386 3,328 - - - - - 14,387 23,000 63% Sub Total 1,576,855 1,479,523 1,154,018 1,200,827 1,186,511 1,581,662 1,147,523 - - - - - 9,326,919 21,250,611 44% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 48,400 46,390 29,841 52,988 63,829 41,714 55,751 - - - - - 338,914 534,509 63% 0621 Sewer Repair 641 517,647 434,598 385,613 579,850 349,846 452,561 422,426 - - - - - 3,142,541 9,248,687 34% 0625 Concrete Crew 641 30,239 20,767 19,975 30,713 26,000 34,774 27,113 - - - - - 189,581 474,389 40% 0630 Wastewater Operations 641 2,358,990 1,454,679 3,260,858 2,528,275 2,582,015 2,554,148 2,645,651 - - - - - 17,384,617 33,209,563 52% 0631 Organic Resources 641 124,773 126,931 80,689 53,682 214,126 78,314 116,920 - - - - - 795,434 1,608,946 49% 0650 Clay Sewage 641- 5 26 50 431 - 181 - - - - - 693 750 92% Sewage Capital 642 1,298,328 387,989 178,442 93,243 530,257 335,486 139,256 - - - - - 2,963,001 8,040,455 37% Sewage Reserve 643 2,625 3,535 4,065 2,021 1,972 6,676 6,560 - - - - - 27,453 30,000 92% Sewage Bond Sinking 649 1,000 500 - - 830,476 249,650 - - - - - - 1,081,626 9,163,754 12% 2011 Sewer Bond 659- - - 51,687 - - - - - - - - 51,687 51,688 100% 2012 Sewer Bond 661 3,000 166,950 113,521 180,305 269,318 115,454 988,844 - - - - - 1,837,393 3,010,364 61% Sub Total 4,385,001 2,642,343 4,073,031 3,572,814 4,868,271 3,868,777 4,402,703 - - - - - 27,812,940 65,373,105 43% 2017-07 Financial Report - Expe nditu re Su mmary Page 14 of 25 City of South Bend Period Ending:July 31, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Public Safety - Police Police Seizures 216- - - - - - - - - - - - - 36,000 0% Curfew Violations 218- - - - - - - - - - - - - 1,000 0% Law Enforcement Education 220 44,630 19,978 197,939 29,048 26,375 24,885 22,590 - - - - - 365,446 788,422 46% Emergency Telephone System 244- - - 4,708 - - - - - - - - 4,708 33,671 14% Public Safety LOIT 249 466,245 487,781 613,087 598,935 610,756 918,862 621,159 - - - - - 4,316,825 7,462,645 58% Excess Welfare Public Safety 252- - - - - - - - - - - - - 8 0% LOIT 2016 Special Distribution 257 21,360 21,991 1,050,366 38,621 39,807 69,470 81,018 - - - - - 1,322,632 3,757,457 35% Police Take Home Vehicle 278- 972 - (60) (120) (260) 340 - - - - - 872 10,000 9% Police Grants 292 2,796 1,266 1,330 90 106 - - - - - - - 5,587 10,805 52% Police Academy 294 162 283 692 909 515 3,776 179 - - - - - 6,516 22,500 29% COPS More Grants 295 10,980 3,436 108,583 11,664 915 240 347 - - - - - 136,165 263,767 52% Drug Enforcement 299 11,242 23,096 13,200 - - 3,172 - - - - - - 50,710 196,337 26% K-9 Unit 705- - - - - - - - - - - - - 2,020 0% Sub Total 557,416 558,803 1,985,195 683,915 678,354 1,020,145 725,633 - - - - - 6,209,461 12,584,632 49% Public Safety - Fire EMS Capital 287 235,792 150,604 - 386,321 136,287 547,964 290,622 - - - - - 1,747,590 3,991,466 44% EMS Operating Fund 288 438,601 356,431 401,753 451,805 437,873 602,509 371,814 - - - - - 3,060,784 6,117,914 50% Hazmat 289 430 255 - - 4,057 - - - - - - - 4,742 10,431 45% River Rescue 291 1,443 231 231 23,817 10,419 21,299 9,052 - - - - - 66,492 117,349 57% xxx xxx xxx- - - - - - - - - - - - - NA Sub Total 676,266 507,520 401,984 861,943 588,636 1,171,772 671,488 - - - - - 4,879,609 10,237,160 48% Department of Community Investment Studebaker/Oliver 209 70,702 4,592 23,072 39,510 43,825 - 31,342 - - - - - 213,043 539,393 39% State Grant 210- - 18,003 - - 18,003 - - - - - - 36,005 509,757 7% DCI Operating 211 197,318 171,937 175,385 177,600 195,239 226,245 174,958 - - - - - 1,318,681 2,750,376 48% 1001 Dept. of Community Investment 212 575,173 100,654 21,621 163,348 164,147 146,738 77,983 - - - - - 1,249,663 5,455,838 23% 1003 Administration 212- - - - - - - - - - - - - - NA xxx Programs 212- - - - - - - - - - - - - - NA Sub Total 843,192 277,183 238,081 380,458 403,211 390,985 284,283 - - - - - 2,817,393 9,255,364 30% Parking Garages 0461 St. Joseph 601- - 604 - (604) - - - - - - - NA 0460 Main Street 601 10,017 11,799 1,749 75,944 10,787 28,308 3,500 - - - - - 142,106 261,894 54% 0462 Leighton Plaza 601 20,044 21,722 1,360 55,854 7,114 18,879 3,926 - - - - - 128,900 596,368 22% 0463 Enforcement 601 7,858 7,238 437 22,849 437 12,035 5,445 - - - - - 56,299 128,675 44% 0464 Wayne Street 601 12,364 13,889 936 32,097 5,591 20,718 1,558 - - - - - 87,154 244,417 36% 0465 Eddy Street Commons 601- - - 32 - 647 - - - - - - 679 15,900 4% Sub Total 50,284 54,648 4,482 186,776 24,534 80,587 13,826 - - - - - 415,138 1,247,254 33% Capital / Debt Service Hall of Fame 313 635,000 - (3,265) - - - 633,000 - - - - - 1,264,735 1,268,999 100% COIT 404 1,172,640 1,270,520 840,369 1,585,347 13,821 530,881 881,651 - - - - - 6,295,229 12,071,593 52% Cum Capital Development 406 112,650 27,896 - - 149,081 - 112,650 - - - - - 402,278 476,500 84% Cum Capital Improvement 407 185,125 - - - - - 187,125 - - - - - 372,250 372,250 100% EDIT 408 697,093 1,928,675 70,750 2,317,413 62,665 58,366 82,427 - - - - - 5,217,389 11,559,184 45% UDAG 410 30,702 - - 31,814 - - 31,814 - - - - - 94,329 126,144 75% Major Moves 412 543 - 62 - 910 - 274,046 - - - - - 275,560 2,470,708 11% Morris PAC Improvement 416 408 - 1,645 1,423 540 - 334 - - - - - 4,350 401,144 1% Palais Historic Preservation 450- - - - - - - - - - - - - 5,000 0% Hall of Fame Capital 677 3,866 14,859 2,574 3,209 2,159 2,638 2,500 - - - - - 31,804 81,091 39% SB Building Corp 755- - 1,437,970 - - - 500 - - - - - 1,438,470 2,643,214 54% Parks Bond Debt 757- - 198,566 - - - - - - - - - 198,566 391,482 51% Sub Total 2,838,027 3,241,949 2,548,669 3,939,206 229,176 591,885 2,206,047 - - - - - 15,594,959 31,867,309 49% 2017-07 Financial Report - Expe nditu re Su mmary Page 15 of 25 City of South Bend Period Ending:July 31, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Other Miscellaneous Gift, Donation, Bequest 217 72,000 900 - 663 760 6,877 79,294 - - - - - 160,494 241,700 66% Unsafe Building 219 80,336 43,005 41,261 55,208 81,628 79,253 60,815 - - - - - 441,505 902,746 49% Landlord Registration 221 5 5 - - - - - - - - - - 10 1,000 1% Loss Recovery 227- 3,345 7,600 2,080 5,844 - - - - - - - 18,869 598,675 3% Human Rights 258 17,100 3,192 7,767 8,984 17,529 18,147 9,651 - - - - - 82,371 201,773 41% Morris Palais Marketing 273 2,798 - 878 - 1,998 - - - - - - - 5,673 21,675 26% IT / Innovation / 311 Call Center 279 325,330 207,081 205,525 260,505 495,245 278,491 182,978 - - - - - 1,955,154 5,205,034 38% Professional Sports Development 377 467,640 800 - - - - 359,515 - - - - - 827,955 827,955 100% 1201 Code Enforcement 600 128,453 94,686 101,457 110,099 112,811 146,364 122,698 - - - - - 816,568 1,625,378 50% 1207 Animal Control 600 68,101 59,652 58,318 65,964 68,163 74,484 66,442 - - - - - 461,124 790,517 58% 1306 Building Operations 600 110,343 98,842 97,813 101,286 98,111 129,067 111,279 - - - - - 746,741 1,361,925 55% Century Center 670 282,027 349,477 (15,339) 661,555 322,739 382,643 332,564 - - - - - 2,315,666 4,194,310 55% Century Center Energy Saving 672- - - 95,128 - - - - - - - - 95,128 192,297 49% Sub Total 1,554,131 860,986 505,279 1,361,472 1,204,828 1,115,326 1,325,236 - - - - - 7,927,257 16,164,985 49% Business Insurance 0403 Self Funded Liability Ins 226 17,866 17,273 20,527 15,424 16,015 21,466 15,567 - - - - - 124,137 235,471 53% 0412 Liability Insurance 226 45,537 23,578 52,779 27,697 640,369 40,160 62,615 - - - - - 892,735 2,034,051 44% 0417 Business Insurance 226 45,354 - 21,392 120 21,404 - 386,775 - - - - - 475,045 595,678 80% 0418 Workers Compensation 226 119,520 87,561 54,191 240,566 58,672 52,655 93,757 - - - - - 706,923 722,386 98% Sub Total 228,276 128,412 148,890 283,807 736,460 114,282 558,713 - - - - - 2,198,840 3,587,586 61% Fiduciary Trust & Agency Fire Pension 701 388,455 396,509 396,201 394,300 390,847 376,476 382,196 - - - - - 2,724,984 5,098,269 53% Police Pension 702 513,053 511,187 523,297 519,926 517,885 505,354 507,705 - - - - - 3,598,406 6,423,889 56% Employee Benefits 711 1,060,085 1,343,141 951,392 1,174,621 1,102,064 1,726,172 1,277,628 - - - - - 8,635,104 17,803,200 49% Unemployment Comp 713 6,038 8,041 4,389 5,340 3,324 5,526 7,729 - - - - - 40,387 84,105 48% City Cemetery Trust 730- - - - - - - - - - - - 6,000 0% Equipment / Vehicle Leasing 750- 983,042 489,584 65,756 135,750 128,509 - - - - - - 1,802,641 5,500,000 33% Parks Bond Capital 751- 63,156 211,200 140,581 19,839 111,546 2,245 - - - - - 548,567 3,500,000 16% Smart Street Bond 753- 986,652 285,891 512,350 617,149 341,706 1,077,051 - - - - - 3,820,799 10,000,000 38% xxx xxx xxx NA Sub Total 1,967,632 4,291,727 2,861,954 2,812,874 2,786,859 3,195,289 3,254,554 - - - - - 21,170,889 48,415,463 44% Civil City Expenditure 23,354,822 20,927,696 20,605,582 22,621,770 20,281,521 22,595,375 22,610,274 - - - - - 152,997,039 333,404,535 46% Tax Increment Financing TIF River West - Airport 324 4,348,398 123,050 1,434,861 735,643 590,372 186,766 4,463,883 - - - - - 11,882,972 39,618,887 30% TIF West Washington 422- - 2,420 385 - - - - - - - - 2,805 1,428,292 0% TIF Leighton Plaza 425 5,141 9,302 4,480 11,400 9,310 29,194 7,696 - - - - - 76,523 158,166 48% TIF River East DEV (NE)429 27,144 45,644 101,171 587,302 45,684 343,124 122,068 - - - - - 1,272,136 10,602,696 12% TIF Southside 430 146,124 12,530 17,419 24,812 100,639 6,683 - - - - - - 308,206 6,917,426 4% TIF Erskine Village 432 3,961,667 - - 904,519 - - - - - - - - 4,866,186 4,878,795 100% TIF Douglas Road 435- 150,000 - - - - - - - - - - 150,000 344,216 44% TIF River East RES (NE RE)436 1,236,500 446,589 - - - - 1,234,500 - - - - - 2,917,589 3,430,231 85% Sub Total 9,724,973 787,115 1,560,351 2,264,061 746,005 565,766 5,828,146 - - - - - 21,476,416 67,378,709 32% 2017-07 Financial Report - Expe nditu re Su mmary Page 16 of 25 City of South Bend Period Ending:July 31, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Redevelopment Funds Administration 433- - - 816 316 - - - - - - - 1,133 4,500 25% Certified Technology Park 439- - - 1,800,000 - - - - - - 1,800,000 2,200,000 82% Airport Urban Enterprise Zone 454- - - - - - - - - - - - - 50,000 0% Industrial Revolving 754- - 14,437 16,553 775 17,679 775 - - - - - 50,219 157,000 32% Sub Total- - 14,437 17,369 1,801,091 17,679 775 - - - - - 1,851,352 2,411,500 77% Debt Service Airport Debt Reserve 2003 315 588 792 902 434 398 1,346 1,323 - - - - - 5,782 14,000 41% Central Development reserve 328 983 1,323 1,522 725 664 2,249 2,210 - - - - - 9,676 15,000 65% SB Redevelopment Authority 752- 735,236 2,004,503 5 - 345,906 - - - - - - 3,085,650 4,603,405 67% Smart Streets Debt Svc 756- - 394,784 - - - - - - - - - 394,784 855,784 46% Erskine Village Debt Svc 758- 561,229 3,961,668 1 - - - - - - - - 4,522,898 4,522,918 100% xxx xxx xxx NA Sub Total 1,571 1,298,580 6,363,379 1,165 1,062 349,501 3,532 - - - - - 8,018,791 10,011,107 80% Redevelopment Commission 9,726,545 2,085,695 7,938,167 2,282,595 2,548,158 932,945 5,832,453 - - - - - 31,346,558 79,801,316 39% City Operations Total 33,081,366 23,013,391 28,543,749 24,904,365 22,829,679 23,528,321 28,442,727 - - - - - 184,343,598 413,205,851 45% Expenditure report 33,081,366 23,013,391 28,543,749 24,904,365 22,829,679 23,528,321 28,442,728 0 0 0 0 0 184,343,598 413,205,851 0 0 0 0 0 0(1)0 0 0 0 0(1)0 2017-07 Financial Report - Expe nditu re Su mmary Page 17 of 25 City of South Bend Period Ending:July 31, 2017 Debt Schedule Year of Year of Year o f Sch e duled Payme nts Debt (O rig / Refi)D e bt at 2017 P rincip al 2017 Interes t 2 0 1 7 Debt at 2017 To tal Deb t Inst rum e nt Deb t Pu rpo s e Issu e Refu ndin g Mat urit y Fu nd 1st 2n d 3rd 4th Issu e 12/31/2016 Payme nts Paym e nt A ddit i on 1 2/31/2017 Debt Paym e nts Civil C i ty D e bt Bon d D e bt Am o r t s ch # 31 CE DIT Bond 1997 2006 2017 408 2/1 8/1--11,870,000.0 0 430,0 0 0.00 4 3 0,0 00.00 9,932.50 0.00 0.00 439,932.50 36 South B e n d Building C o rporati on Publi c Wor ks B ui ld ing 2001 2010 2021 404/6 4 9 2/1 8/1--9,250,000.0 0 2,755,0 0 0.00 5 7 5,0 00.00 95,994.00 0.00 2,180,000.00 670,994.00 25 Water Works Impr o vem en t s Water Works 2002 2012 2023 625 1/1 7/1--5,975,000.0 0 2,380,0 0 0.00 3 7 5,0 00.00 47,600.00 0.00 2,005,000.00 422,600.00 39 South B e n d Building C o rporati on F ir e HQ / Pol i ce HQ 2003 2012 2023 404/3 2 4 2/1 8/1--21,335,000.0 0 8,885,0 0 0.00 1,2 4 0,0 00.00 3 25,740.00 0.00 7,645,000.00 1,565,740.00 24 Water Works Impr o vem en t s Water Works 2006 2027 625 1/1 7/1--4,710,000.0 0 0.00 0.00 0.00 0.00 0.00 0.00 62 Century Center S p ec ial Tax B o n d s Century Center 2008 2028 420 5/1 11/1--4,655,000.0 0 3,175,0 0 0.00 3 0 0,0 00.00 85,812.50 0.00 2,875,000.00 385,812.50 69 Water Works Impr o vem en t s Water Works 2009 2030 625 1/1 7/1--5,380,000.0 0 4,325,0 0 0.00 2 4 0,0 00.00 2 39,938.00 0.00 4,085,000.00 479,938.00 70 Sew a g e Wor ks Rev e n u e Bonds - 2009 Sew ag e Works 2009 2028 649 6/1 12/1--3,297,000.0 0 2,249,6 4 3.00 1 6 2,4 72.00 63,214.00 0.00 2,087,171.00 225,686.00 80 2 0 1 0 Sewage W o rk s Revenue Bonds Sew ag e Works 2010 2030 649 6/1 12/1--9,345,000.0 0 7,145,0 0 0.00 3 9 5,0 00.00 2 98,617.50 0.00 6,750,000.00 693,617.50 93 Sew a g e Wor ks Rev e n u e Bonds 2011 Sew ag e Works 2011 2031 649 6/1 12/1--21,500,000.0 0 17,295,0 0 0.00 8 9 5,0 00.00 6 54,300.00 0.00 16,400,000.00 1,549,300.00 99 2 0 1 2 W at er W or ks Reven u e Bond Water Works 2012 2033 625 1/1 7/1--8,300,000.0 0 6,925,0 0 0.00 3 5 5,0 00.00 2 09,786.26 0.00 6,570,000.00 564,786.26 1 01 2 0 1 2 Sewage W o rk s Revenue Bonds Sew ag e Works 2012 2032 649 6/1 12/1--25,000,000.0 0 20,890,0 0 0.00 1,0 6 0,0 00.00 4 86,680.00 0.00 19,830,000.00 1,546,680.00 1 05 2 0 1 3 A S ewer Bond Refundi n g Sew ag e Works 2013 2013 2024 649 6/1 12/1--14,765,000.0 0 8,050,0 0 0.00 1,9 5 5,0 00.00 1 56,170.00 0.00 6,095,000.00 2,111,170.00 1 16 2 0 1 3 Building C o rporati on EMS / Fi re D ep ar t ment 2013 2033 288 2/1 8/1--5,580,000.0 0 5,145,0 0 0.00 2 2 5,0 00.00 1 77,480.00 0.00 4,920,000.00 402,480.00 1 33 St. Joseph C ou n t y PS AP St. Josep h Count y PSAP 2014 2034 408 Mon t hl y 2,657,696.5 0 2,386,5 0 7.92 1 0 7,6 52.90 59,107.80 0.00 2,278,855.02 166,760.70 1 39 Century Center E n ergy Savings Im p rov e m ents at Centur y Ctr.2015 2031 672 5/1 11/1 4,167,897.0 0 4,145,3 1 2.00 4 6,6 06.00 1 44,690.68 0.00 4,098,706.00 191,296.68 1 41 Parks and R ecr eation Bond Parks I mprovements 2015 2035 408 2/1 8/1--5,605,000.0 0 5,295,0 0 0.00 2 1 0,0 00.00 1 72,256.26 0.00 5,085,000.00 382,256.26 1 45 Sew a g e Wor ks Rev e n u e Bonds -2015 Sew er Improvements 2015 2025 649 6/1 12/1--27,440,000.0 0 24,965,0 0 0.00 2,5 3 0,0 00.00 4 99,300.00 0.00 22,435,000.00 3,029,300.00 1 56 2 0 1 6 W at er W or ks Refunding B ond s Refunding 2000 / 2006 SRF 2016 2027 625 1/1 7/1--3,300,000.0 0 3,300,0 0 0.00 4 0 5,0 00.00 49,500.00 0.00 2,895,000.00 454,500.00 xxx Total Bo nd Debt 234,877,593.5 0 129,741,4 6 2.92 11,5 0 6,7 30.90 3,7 76,119.50 0.00 118,234,732.02 15,282,850.40 L oans Payable 68 State R evolving Fund Water Works Impr ovement 2009 2030 625 1/1 7/1--427,332.0 0 332,5 6 2.00 2 0,9 12.00 11,207.34 0.00 311,650.00 32,119.34 82 I n t e rfund Loan 410 - UD AG 1st Source/Marriott Garage 2010 2015 410 6/1 5 12/15--2,700,000.0 0 1,351,5 9 7.75 1 2 6,1 42.25 0.00 0.00 1,225,455.50 126,142.25 26 State R evolving Fund Water Works Impr ovements 2000 2019 625 1/1 7/1--2,600,000.0 0 0.00 0.00 0.00 0.00 0.00 0.00 xxx Amy S h i rk To t al Loans Paya ble 29,822,332.0 0 1,684,1 5 9.75 1 4 7,0 54.25 11,207.34 0.00 1,537,105.50 158,261.59 Capit a l Leases 51 Chase LED Equipment 2007 2017 101 1/1 7/1--1,531,573.0 0 194,3 2 0.02 1 9 4,3 19.97 6,259.69 0.00 0.05 200,579.66 89 Sun Tr u st Pol ice, Parks, Bldg vehicl es 2011 2016 404/201/600 3/1 5 6/15 9/15 1 2/15 2,068,202.0 0 0.00 0.00 0.00 0.00 0.00 0.00 90 Capital O ne Public Funding Sol id Waste Contai n e rs/Trucks 2011 2016 611 3/1 5 6/15 9/15 1 2/15 207,432.0 0 0.00 0.00 0.00 0.00 0.00 0.00 91 GE C a p ital Inform at i on Tec hnol ogy Pol ice Dept Cop i er 2011 2016 101 1/1 1 4/11 7/11 1 0/11 3,836.0 0 0.00 0.00 0.00 0.00 0.00 0.00 92 Key Finance IT Phone Sy stem 2011 2016 404 1/1 5 1,444,995.9 7 0.00 0.00 0.00 0.00 0.00 0.00 94 I kon Office Solutions Mayor Ri c o h MP 2851 SP Copier 2011 2016 101 2/1 5 5/15 8/15 1 1/15 2,569.5 3 0.00 0.00 0.00 0.00 0.00 0.00 95 Sun Tr u st Equipment F i n an ce Parks-G o lf Cars Lease 2012 2016 201 4/1 5 10/15--344,500.0 0 0.00 0.00 0.00 0.00 0.00 0.00 97 Sun Tr u st Equipment F i n an ce Pol ice Vehi c les & Equipm ent 2012 2017 406 5/1 5 11/15--1,295,000.0 0 134,5 8 5.22 1 3 4,5 85.22 1,140.42 0.00 0.00 135,725.64 98 PN C Equipment Finance Publi c Wor ks V eh i cles Lease 2012 2017 202/641/640 5/1 5 11/15--945,674.3 8 97,7 9 3.51 9 7,7 93.52 735.98 0.00(0.01)98,529.50 1 00 PN C Equipment Finance Publi c Wor ks V eh i cles Lease 2012 2017 202/641/6 0 0/288 1/1 5 7/15--2,806,054.0 0 575,3 1 6.55 5 7 5,3 16.53 5,634.82 0.00 0.02 580,951.35 1 02 I kon Office Solutions / Ri c oh Wastew a t e r Copier 2012 2017 641 Mon t hl y 1st 5,744.9 5 7 5 6.77 756.77 65.82 0.00 0.00 822.59 1 03 GE C a p ital Inform at i on Tec hnol ogy F ir e Departm en t Copier 2012 2017 101 2/2 8 5/28 8/28 1 1/28 5,471.0 1 9 2 6.68 926.68 27.40 0.00 0.00 954.08 1 06 Ricoh U SA (New)Central S er vices C op ier 2013 2018 222 2/2 7 5/27 8/27 1 1/27 3,622.7 8 8 1 5.82 814.82 24.94 0.00 1.00 839.76 1 07 Ricoh U SA Street/S e wer Dept Copi er 2013 2018 202/6 4 1 3/4 6/4 9/4 12/4 5,559.1 5 1,2 2 5.93 1,2 25.93 44.88 0.00 0.00 1,270.81 1 08 Ricoh U SA City Attor n e y Copier 2013 2018 101 2/1 2 5/12 8/12 1 1/12 5,559.1 5 1,2 3 2.73 1,2 31.73 39.06 0.00 1.00 1,270.79 1 09 Ricoh U SA Parks & Rec Ricoh Copi e rs(3)2013 2018 201 2/2 1 5/21 8/21 1 1/21 16,129.9 4 3,5 7 5.09 3,5 74.09 113.15 0.00 1.00 3,687.24 1 10 PN C Equipment Finance Vehi c le/Equipment Lease 2013 2018 101/202/4 0 6/641 1/1 5 7/15--1,689,669.5 9 689,2 5 7.88 3 4 2,5 33.13 7,367.39 0.00 346,724.75 349,900.52 1 11 Ricoh U SA Engineeri ng Plotter/Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10,667.6 7 2,4 5 9.26 2,4 58.26 133.72 0.00 1.00 2,591.98 1 12 Ricoh U SA Bui l d ing Dept. Copier 2013 2018 600 Mon t hl y 4,093.6 4 1,4 9 1.77 878.55 60.45 0.00 613.22 939.00 1 13 Sun Tr u st Equipment F i n an ce Pol ice and PW v e h icles 2013 2018 404/655/6 1 1/202 4/2 4 10/24--1,506,465.2 6 616,8 9 1.89 3 0 6,0 11.19 8,569.95 0.00 310,880.70 314,581.14 1 14 Ricoh U SA Admin & Financ e Copier 2013 2018 101 1/1 6 4/16 7/16 1 0/16 11,247.9 7 3,0 7 9.36 2,4 44.79 126.44 0.00 634.57 2,571.23 1 17 Pol i c e Dept. Rec ord D i v. Ricoh Pol ice Records C opier 2013 2018 101 Mon t hl y 3rd--9,678.2 6 4,1 9 4.14 2,0 39.23 180.77 0.00 2,154.91 2,220.00 1 18 Water Works Main R icoh Copier Water Works Main R icoh Copi er 2013 2018 620 Mon t hl y 10th--5,647.5 0 2,4 4 8.11 1,1 89.78 105.62 0.00 1,258.33 1,295.40 1 19 Water Works Col fax Ri c oh Copier Water Works C o lfax R i coh Copier 2013 2018 620 Mon t hl y 16th--4,732.6 5 2,0 5 1.62 997.01 85.51 0.00 1,054.61 1,082.52 1 20 Water Works Oli ve Ricoh C op ier Water Works Ol i ve Ric oh Copier 2013 2018 620 Mon t hl y 10th--4,732.6 5 2,0 5 1.62 997.01 85.51 0.00 1,054.61 1,082.52 1 23 Pol i c e Trai ni n g Dept. Ricoh C o p ier T rai n in g Copier 2014 2019 101 Mon t hl y 30th--4,263.0 0 2,0 7 6.44 890.27 93.73 0.00 1,186.17 984.00 1 24 Pol i c e/Publi c W o r k s Vehi c le Lease 2014 City V ehicles 2014 2019 Various 4/1 10/1--1,959,485.9 5 1,193,7 9 7.05 3 9 1,8 03.77 16,992.78 0.00 801,993.28 408,796.55 1 25 HP Com p u t e r Leas e #1 Computer Equipment Lease 2014 2018 various Mon t hl y 8th--137,104.9 5 63,5 2 5.63 3 2,6 32.97 2,191.39 0.00 30,892.66 34,824.36 1 26 HP Com p u t e r Leas e #2 Computer Equipment Lease 2014 2018 201 and 620 Mon t hl y 8th--4,000.0 0 1,9 4 7.01 950.39 70.09 0.00 996.62 1,020.48 1 27 HP Com p u t e r Leas e #4 Computer Equipment Lease 2014 2018 404 Mon t hl y 8th--5,886.1 5 2,7 9 5.30 1,4 12.70 83.34 0.00 1,382.60 1,496.04 1 28 HP Com p u t e r Leas e #6 Computer Equipment Lease 2014 2018 201 Mon t hl y 8th--3,755.5 0 1,9 1 7.99 883.34 73.78 0.00 1,034.65 957.12 1 29 HP Com p u t e r Leas e #7 Computer Equipment Lease 2014 2018 620 Mon t hl y 8th--1,326.0 0 7 0 6.05 315.44 21.40 0.00 390.61 336.84 1 30 Sol i d W aste Copi er Ric oh USA Copier 2014 2019 611 Mon t hl y 17th--5,351.6 5 3,3 0 2.32 1,0 71.78 157.86 0.00 2,230.54 1,229.64 1 31 Pol i c e Comm u n ications C o p ier Ric oh USA Copier 2014 2019 101 Mon t hl y 12th--8,843.0 0 4,8 7 6.99 1,8 04.44 227.40 0.00 3,072.55 2,031.84 1 32 Or g a n ic Resou rces & W astew at er Ric oh USA Copiers 2014 2019 641 Mon t hl y 21st--12,260.1 8 6,5 5 8.16 2,5 13.45 303.55 0.00 4,044.71 2,817.00 1 34 Water Works Copi er - N o rth S t a t ion Ric oh USA Copiers 2014 2019 620 Mon t hl y 19th--4,732.6 5 2,1 3 2.25 992.44 93.08 0.00 1,139.81 1,085.52 1 36 HP Com p u t e r Leas e #8 Computer Equipment Lease 2015 2019 404/201/611 Mon t hl y 16th--19,603.9 4 11,8 5 4.14 4,5 38.52 494.04 0.00 7,315.62 5,032.56 1 37 Animal C on t rol Ricoh C op i er Ric oh USA Copiers 2015 2020 600 Mon t hl y 30th--5,261.5 0 3,5 9 1.88 1,0 33.37 182.47 0.00 2,558.51 1,215.84 1 38 HP Com p u t e r Leas e #9 Computer Equipment Lease 2015 2019 Various Mon t hl y TBD--135,958.0 5 94,7 1 0.62 3 0,9 05.89 3,998.51 0.00 63,804.73 34,904.40 1 40 Vehic l e & E q u i p. Lease Vehi c le/Equipment Lease 2015 2020 Various 1/1 5 7/15--3,425,273.5 8 2,763,8 4 5.35 6 7 6,7 23.50 35,941.86 0.00 2,087,121.85 712,665.36 1 43 HP Com p u t e r Leas e #1 1 Computer Equipment Lease 2015 2019 404 Mon t hl y--3,040.0 0 2,1 6 1.06 695.77 85.67 0.00 1,465.29 781.44 1 44 PN C Vehi c le Lease No. 2 Vehi c le Lease P u rc has e 2015 2020 Various 5/1 5 11/15--1,267,183.0 0 1,021,8 5 5.36 2 4 9,5 80.62 14,814.26 0.00 772,274.74 264,394.88 1 46 Parks & Rec. R icoh Copier Ric oh Copier 2016 2020 201 Mon t hl y--4,302.0 6 3,4 5 4.72 810.05 176.59 0.00 2,644.67 986.64 1 47 Central S erv ices Lanier Copi e r C51005 Copi er 2016 2020 222 Mon t hl y--32,525.0 0 28,6 6 7.19 6,0 46.87 1,368.89 0.00 22,620.32 7,415.76 1 48 Central S erv ices Lanier Copi e r C6502 Copi e r 2016 2020 222 Mon t hl y--11,413.0 0 10,0 5 9.31 2,1 21.84 480.36 0.00 7,937.47 2,602.20 1 49 Vehic l e & E q u i p. Lease Publi c Wor ks V eh i cles Lease 2016 2021 Various 2/1 5 8/15--3,339,830.0 0 3,016,4 8 4.17 6 5 1,7 83.72 45,609.91 0.00 2,364,700.45 697,393.63 1 50 HP Com p u t e r Leas e Copier Leas e 2016 2020 Various Mon t hl y--17,439.8 5 14,0 1 3.99 3,9 08.91 574.29 0.00 10,105.08 4,483.20 1 51 Admin and F inance Ric oh Copier Copier Leas e 2016 2021 101 Mon t hl y--10,923.6 3 8,9 3 8.27 2,0 47.09 458.15 0.00 6,891.18 2,505.24 1 52 PN C Vehi c le / Equip Lease No. 2 Vehi c le / Equipment Lease 2016 2021 Various 1/1 4 7/14--3,992,548.7 2 3,992,5 4 8.72 7 7 0,3 91.63 62,984.68 0.00 3,222,157.09 833,376.31 1 53 PN C Vehi c le / Equip Lease Am e n d 1 Parks a n d Recreation 2016 2021 201 1/1 7 7/17--78,808.0 0 78,8 0 8.00 1 5,2 87.29 1,141.51 0.00 63,520.71 16,428.80 1 54 PN C Vehi c le / Equip Lease No. 3 Parks & Rec / IT 2016 2021 201/2 7 9 4/1 9 10/19--1,256,096.9 9 1,256,0 9 6.99 2 4 4,0 70.10 17,538.46 0.00 1,012,026.89 261,608.56 1 55 HP Com p u t e r Leas e No. 13 Computer Equipment Lease 2016 2020 Various Mon t hl y---156,029.3 0 150,5 6 2.73 3 3,5 67.37 6,602.27 0.00 116,995.36 40,169.64 1 57 Venue, P ar ks, Art Copi er Ric oh Copier 2016 2021 201 Mon t hl y---3,184.0 6 3,1 8 4.06 918.51 382.49 0.00 2,265.55 1,301.00 1 58 Publi c Financ e.c o m Inc 2017 Vehic l e L e a se No. 1 2017 2022 Various 1/1 4 7/14--2,916,500.0 0 0.00 0.00 0.00 2,916,500.00 0.00 0.00 1 59 Mayor/Waste W ater/Fire Ric oh 2017 Ricoh C o p ier L e a se 2017 2021 101/641/287 Mon t hl y---15,702.0 9 0.00 3,2 85.05 843.03 15,702.09 12,417.04 4,128.08 1 60 HP Com p u t e r Refr esh Lease No. 14 2017 Ricoh C o p ier L e a se 2017 2021 279/2 0 1 Mon t hl y---10,305.2 5 0.00 1,8 52.45 359.95 10,305.25 8,452.80 2,212.40 1 62 Vehic l e & E q u i p. Lease No. 2 Vehi c le / Equipment Lease 2017 2021 404 2/1 5 8/15--1,632,000.0 0 0.00 0.00 0.00 1,632,000.00 1,632,000.00 0.00 xxx To tal Ca pital L e ase 34,787,495.2 1 16,078,9 4 5.72 4,8 0 4,9 33.75 2 45,147.31 4,574,507.34 11,300,019.31 5,047,868.66 T otal Ci vi l Ci t y 299,487,420.7 1 147,504,5 6 8.39 16,4 5 8,7 18.90 4,0 32,474.15 4,574,507.34 131,071,856.83 20,488,980.65 2 01 7-07 F ina nc i al Re port - D ebt P age 18 o f 2 5 City of South Bend Period Ending:July 31, 2017 Debt Schedule Year of Year of Year o f Sch e duled Payme nts Debt (O rig / Refi)D e bt at 2017 P rincip al 2017 Interes t 2 0 1 7 Debt at 2017 To tal Deb t Inst rum e nt Deb t Pu rpo s e Issu e Refu ndin g Mat urit y Fu nd 1st 2n d 3rd 4th Issu e 12/31/2016 Payme nts Paym e nt A ddit i on 1 2/31/2017 Debt Paym e nts Redevelo pment Co mmissio n D e bt Bon d D e bt 7 Century Center Lease Rental Rev e n u e Century Center 1994 2001/2 0 1 1 2018 407 2/1 8/1--6,825,000.0 0 720,0 0 0.00 4 7 5,0 00.00 16,875.00 0.00 245,000.00 491,875.00 8 Coll eg e Footbal l Hall of Fame Hal l o f Fame 1994 2000/2 0 1 1 2018 313 2/1 8/1--15,370,000.0 0 1,830,0 0 0.00 1,2 1 5,0 00.00 53,407.50 0.00 615,000.00 1,268,407.50 11 South B e n d Building C o rporati on Morr i s PAC 1998 2009 2017 408 2/1 8/1--13,300,000.0 0 515,0 0 0.00 5 1 5,0 00.00 10,300.00 0.00 0.00 525,300.00 12 T J X S pec ial T a xing Di st ri ct 2002 2014 2022 324/404/414 1/1 7/1--6,620,000.0 0 2,210,0 0 0.00 4 1 5,0 00.00 66,300.00 0.00 1,795,000.00 481,300.00 5 Dow ntow n Centr al Area TIF 2003 2011 2024 420 2/1 8/1--19,795,000.0 0 12,500,0 0 0.00 1,3 1 5,0 00.00 5 98,625.00 0.00 11,185,000.00 1,913,625.00 6 Airport Developm e n t Area T I F Ai rport TI F 2003 2011 2024 324 2/1 8/1--14,420,000.0 0 7,125,0 0 0.00 7 5 0,0 00.00 3 41,210.50 0.00 6,375,000.00 1,091,210.50 22 Erski n e Vill ag e TIF Developm e n t Bond Ersk i n e Vil l ag e 2005 2027 432 2/1 8/1--5,485,000.0 0 3,800,0 0 0.00 3,8 0 0,0 00.00 1 61,666.72 0.00 0.00 3,961,666.72 54 L ease Rental Revenue B ond s of 2008 Eddy Str e et Comm o n s 2008 2027 429 2/1 5 8/15--36,000,000.0 0 30,075,0 0 0.00 1,3 1 5,0 00.00 1,1 48,181.26 0.00 28,760,000.00 2,463,181.26 81 Covel e ski S t a d ium Recovery Coveleski Stadium 2010 2019 377 1/1 5 7/15--4,980,000.0 0 1,665,0 0 0.00 6 5 0,0 00.00 77,155.00 0.00 1,015,000.00 727,155.00 1 22 Synagogue at Coveles ki Im prov e m ents Coveleski Stadium 2014 2018 377 1/3 1---500,000.0 0 200,0 0 0.00 1 0 0,0 00.00 0.00 0.00 100,000.00 100,000.00 1 35 2 0 1 5 Redevelopment S m art S t reets Smarts S t reets 2015 2037 324 2/1 8/1--25,000,000.0 0 25,000,0 0 0.00 4 6 0,0 00.00 3 94,784.38 0.00 24,540,000.00 854,784.38 1 61 Studebaker P roject F a çade Im prov em ent Bldg 8 4 2017 2018 324 One tim e---3,500,000.0 0 0.00 3,5 0 0,0 00.00 0.00 3,500,000.00 0.00 3,500,000.00 1 63 2 0 1 7 Eddy S t. C om mons Phase II Eddy St. Comm o n s Phase II 2017 2037 436 2/1 5 8/15--25,000,000.0 0 0.00 0.00 0.00 2 5,000,000.00 25,000,000.00 0.00 xxx Total Bo nd Debt 182,288,788.0 0 85,640,0 0 0.00 14,5 1 0,0 00.00 2,8 68,505.36 2 8,500,000.00 99,630,000.00 17,378,505.36 L oans Payable 3 I n d iana Devel opm en t Finance Auth or it y Bos c h Property (Nonforgive)2001 2021 210 3/2 2 6/22 9/22 1 2/22 1,040,000.0 0 302,0 6 9.15 6 3,6 60.08 8,350.36 0.00 238,409.07 72,010.44 4 I n d iana Devel opm en t Finance Auth or it y Bos c h Property (Forgiv e)2001 2021 210----260,000.0 0 83,4 8 2.06 0.00 0.00 0.00 65,888.51 0.00 64 I n t e rfund Fund 412 - Maj o r Mov es Douglas Road TI F 2009 2029 435 2/1 5 8/15--1,040,319.0 0 323,0 0 5.00 3 2 2,2 01.00 12,088.00 0.00 804.00 334,289.00 84 I n t e rfund Fund 412 - Maj o r Mov es T ri a n g l e Devel o p m ent 2011 2029 436 2/1 5 8/15--2,000,000.0 0 1,329,5 7 3.43 9 4,6 21.29 26,120.71 0.00 1,234,952.14 120,742.00 85 I n t e rfund Fund 412 - Maj o r Mov es Eddy Str e et Comm o n s 2011 2026 436 2/1 5 8/15--4,100,000.0 0 2,384,3 4 7.86 6 6 1,3 83.84 1 11,052.16 0.00 1,722,964.02 772,436.00 86 I n t e rfund Fund 209 t o Airport 3 2 4 Prairie Ave B row n f ield P roj ec t 2011 2020 324 8/9---500,000.0 0 400,0 0 0.00 1 0 0,0 00.00 0.00 0.00 300,000.00 100,000.00 1 42 I n t e rfund Fund 412 - Maj o r Mov es Parki n g G a rage Improvements 2016 2022 601 6/1 12/1 1,500,000.0 0 517,3 0 4.69 2 2 9,1 74.05 20,825.95 750,000.00 1,038,130.64 250,000.00 xxx To t al Loans Paya ble 15,627,499.0 6 5,339,7 8 2.19 1,4 7 1,0 40.26 1 78,437.18 750,000.00 4,601,148.38 1,649,477.44 Capit a l Lease xxx To tal Ca pital L e ase 0.0 0 0.00 0.00 0.00 0.00 0.00 0.00 L eases 13 T ranspo Lease Main / Colfax Garage 2006 2025 324 3/1 5 9/15--2,510,278.0 0 1,435,3 3 8.00 1 2 9,8 38.00 70,162.00 0.00 1,305,500.00 200,000.00 xxx Tot a l Lease 5,510,278.0 0 1,435,3 3 8.00 1 2 9,8 38.00 70,162.00 0.00 1,305,500.00 200,000.00 Tota l Red e v e l opme nt Commiss i on 203,426,565.0 6 92,415,1 2 0.19 16,1 1 0,8 78.26 3,1 17,104.54 2 9,250,000.00 105,536,648.38 19,227,982.80 To t al D e bt 502,913,985.7 7 239,919,6 8 8.58 32,5 6 9,5 97.16 7,1 49,578.69 3 3,824,507.34 236,608,505.21 39,716,963.45 2 01 7-07 F ina nc i al Re port - D ebt P age 19 o f 2 5 City of South Bend Period Ending:July 31, 2017 Monthly Debt Schedule` Year of Year of Year o f Sch e duled Payme nts Debt (O rig / Refi)D e bt at Y TD Pr i ncipal YTD Int e rest YT D Debt at Deb t Inst rum e nt Deb t Pu rpo s e Issu e Refu ndin g Mat urit y Fu nd 1st 2n d 3rd 4th Issu e 12/31/2016 Payme nts Paym e nts Addit i ons 7/31/2017 Civil C i ty D e bt Bon d D e bt Am o r t s ch # 31 CE DIT Bond 1997 2006 2017 408 2/1 8/1--11,870,000.0 0 430,0 0 0.00 4 3 0,0 00.00 9,932.50 0.00 0.00 36 South B e n d Building C o rporati on Publi c Wor ks B ui ld ing 2001 2010 2021 404/6 4 9 2/1 8/1--9,250,000.0 0 2,755,0 0 0.00 2 8 5,0 00.00 50,313.00 0.00 2,470,000.00 25 Water Works Impr o vem en t s Water Works 2002 2012 2023 625 7/1 12/31--5,975,000.0 0 2,380,0 0 0.00 0.00 23,800.00 0.00 2,380,000.00 39 South B e n d Building C o rporati on F ir e HQ / Pol i ce HQ 2003 2012 2023 404/3 2 4 2/1 8/1--21,335,000.0 0 8,885,0 0 0.00 6 2 0,0 00.00 1 64,730.00 0.00 8,265,000.00 24 Water Works Impr o vem en t s Water Works 2006 2027 625 7/1 12/31--4,710,000.0 0 0.00 0.00 0.00 0.00 0.00 62 Century Center S p ec ial Tax B o n d s Century Center 2008 2028 324 4/1 11/1--4,655,000.0 0 3,175,0 0 0.00 0.00 1 97,500.00 0.00 3,175,000.00 69 Water Works Impr o vem en t s Water Works 2009 2030 625 7/1 12/31--5,380,000.0 0 4,325,0 0 0.00 0.00 1 19,969.00 0.00 4,325,000.00 70 Sew a g e Wor ks Rev e n u e Bonds - 2009 Sew ag e Works 2009 2028 649 6/1 12/1--3,297,000.0 0 2,249,6 4 3.00 0.00 31,607.00 0.00 2,249,643.00 80 2 0 1 0 Sewage W o rk s Revenue Bonds Sew ag e Works 2010 2030 649 6/1 12/1--9,345,000.0 0 7,145,0 0 0.00 0.00 1 49,308.75 0.00 7,145,000.00 93 Sew a g e Wor ks Rev e n u e Bonds 2011 Sew ag e Works 2011 2031 649 6/1 12/1--21,500,000.0 0 17,295,0 0 0.00 0.00 3 27,150.00 0.00 17,295,000.00 99 2 0 1 2 W at er W or ks Reven u e Bond Water Works 2012 2033 625 1/1 7/1--8,300,000.0 0 6,925,0 0 0.00 0.00 1 04,893.13 0.00 6,925,000.00 1 01 2 0 1 2 Sewage W o rk s Revenue Bonds Sew ag e Works 2012 2032 649 6/1 12/1--25,000,000.0 0 20,890,0 0 0.00 0.00 2 43,340.00 0.00 20,890,000.00 1 05 2 0 1 3 A S ewer Bond Refundi n g Sew ag e Works 2013 2013 2024 649 6/1 12/1--14,765,000.0 0 8,050,0 0 0.00 0.00 78,085.00 0.00 8,050,000.00 1 16 2 0 1 3 Building C o rporati on EMS / Fi re D ep ar t ment 2013 2033 288 2/1 8/1--5,580,000.0 0 5,145,0 0 0.00 2 2 5,0 00.00 90,427.50 0.00 4,920,000.00 1 33 St. Joseph C ou n t y PS AP St. Josep h Count y PSAP 2014 2034 408 Mon t hl y---2,657,696.5 0 2,386,5 0 7.92 5 3,8 26.45 29,553.90 0.00 2,332,681.47 1 39 Century Center E n ergy Savings Im p rov e m ents Centur y Ctr.2015 2031 672 5/1 11/1--4,167,897.0 0 4,145,3 1 2.00 2 2,5 85.00 72,542.96 0.00 4,122,727.00 1 41 Parks and R ec Bond Parks I mprovements 2015 2035 408 2/1 8/1--5,605,000.0 0 5,295,0 0 0.00 1 1 0,0 00.00 88,566.00 0.00 5,185,000.00 1 45 Sew a g e Wor ks Rev e n u e Bonds - 2015 Sew er Bond Im p rov e m en t s 2015 2025 649 6/1 12/1--27,440,000.0 0 24,965,0 0 0.00 0.00 2 49,650.00 0.00 24,965,000.00 1 56 2 0 1 6 W at er W or ks Refunding B ond s Refunding 2000 / 2006 SRF 2016 2027 625 1/1 7/1--3,300,000.0 0 3,300,0 0 0.00 0.00 50,600.00 0.00 3,300,000.00 xxx Total Bo nd Debt 234,877,593.5 0 129,741,4 6 2.92 1,7 4 6,4 11.45 2,0 81,968.74 0.00 127,995,051.47 L oans Payable 68 State R evolving Fund Water Works Impr ovement 2009 2030 625 7/1 12/31--427,332.0 0 332,5 6 2.00 0.00 5,603.67 0.00 332,562.00 82 I n t e rfund Loan 410 - UD AG 1st Source/Marriott Garage 2010 2015 410 6/1 5 12/15--2,700,000.0 0 1,351,5 9 7.75 9 4,3 28.75 0.00 0.00 1,257,269.00 26 State R evolving Fund Water Works Impr ovements 2000 2019 625 7/1 12/31--2,600,000.0 0 0.00 0.00 0.00 0.00 0.00 xxx Amy S h i rk To t al Loans Paya ble 29,822,332.0 0 1,684,1 5 9.75 9 4,3 28.75 5,603.67 0.00 1,589,831.00 Capit a l Leases 51 Chase LED Equipment 2007 2017 101 1/1 7/1--1,531,573.0 0 194,3 2 0.02 1 9 4,3 20.02 6,259.69 0.00 0.00 89 Sun Tr u st Pol ice, Parks, Bldg vehicl es 2011 2016 404/201/600 3/1 5 6/15 9/15 1 2/15 2,068,202.0 0 0.00 0.00 0.00 0.00 0.00 90 Capital O ne Public Funding Sol id Waste Contai n e rs/Trucks 2011 2016 611 3/1 5 6/15 9/15 1 2/15 207,432.0 0 0.00 0.00 0.00 0.00 0.00 91 GE C a p ital Inform at i on Tec hnol ogy Pol ice Dept Cop i er 2011 2016 101 1/1 1 4/11 7/11 1 0/11 3,836.0 0 0.00 0.00 0.00 0.00 0.00 92 Key Finance IT Phone Sy stem 2011 2016 404 1/1 5 1,444,995.9 7 0.00 0.00 0.00 0.00 0.00 94 I kon Office Solutions Mayor Ri c o h MP 2851 SP Copier 2011 2016 101 2/1 5 5/15 8/15 1 1/15 2,569.5 3 0.00 0.00 0.00 0.00 0.00 95 Sun Tr u st Equipment F i n an ce Parks-G o lf Cars Lease 2012 2016 201 4/1 5 10/15--344,500.0 0 0.00 0.00 0.00 0.00 0.00 97 Sun Tr u st Equipment F i n an ce Pol ice Vehi c les & Equipm ent 2012 2017 406 5/1 5 11/15--1,295,000.0 0 134,5 8 5.22 0.00 0.00 0.00 134,585.22 98 PN C Equipment Finance Publi c Wor ks V eh i cles Lease 2012 2017 202/641/640 5/1 5 11/15--945,674.3 8 97,7 9 3.51 0.00 0.00 0.00 97,793.51 1 00 PN C Equipment Finance Publi c Wor ks V eh i cles Lease 2012 2017 202/641/6 0 0/288 1/1 5 7/15--2,806,054.0 0 575,3 1 6.55 5 7 5,3 16.55 5,634.81 0.00 0.00 1 02 I kon Office Solutions / Ri c oh Wastew a t e r Copier 2012 2017 641 Mon t hl y 1st--5,744.9 5 7 5 6.77 756.77 14.34 0.00 0.00 1 03 GE C a p ital Inform at i on Tec hnol ogy F ir e Departm en t Copier 2012 2017 101 2/2 8 5/28 8/28 1 1/28 5,471.0 1 9 2 6.68 612.62 22.78 0.00 314.06 1 06 Ricoh U SA Central S er vices C op ier 2013 2018 222 2/2 7 5/27 8/27 1 1/27 3,622.7 8 8 1 5.82 403.66 16.22 0.00 412.16 1 07 Ricoh U SA Street/S e wer Dept Copi er 2013 2018 202/6 4 1 3/4 6/4 9/4 12/4 5,559.1 5 1,2 2 5.93 604.12 31.28 0.00 621.81 1 08 Ricoh U SA City Attor n e y Copier 2013 2018 101 2/1 2 5/12 8/12 1 1/12 5,559.1 5 1,2 3 2.73 609.98 25.42 0.00 622.75 1 09 Ricoh U SA Parks & Rec Ricoh Copi e rs(3)2013 2018 201 3/2 1 6/21 9/21 1 2/21 16,129.9 4 3,5 7 5.09 1,7 69.96 90.82 0.00 1,805.13 1 10 PN C Equipment Finance Vehi c le/Equipment Lease 2013 2018 101/202/4 0 6/641 1/1 5 7/15--1,689,669.5 9 689,2 5 7.88 3 4 2,5 33.13 7,367.39 0.00 346,724.75 1 11 Ricoh U SA Engineeri ng Plotter/Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10,667.6 7 2,4 5 9.26 1,2 02.98 93.02 0.00 1,256.28 1 12 Ricoh U SA Bui l d ing Dept. Copier 2013 2018 600 Mon t hl y--4,093.6 4 1,4 9 1.77 506.59 41.16 0.00 985.18 1 13 Sun Tr u st Equipment F i n an ce Pol ice and PW v e h icles 2013 2018 404/655/6 1 1/202 4/2 4 10/24--1,506,465.2 6 616,8 9 1.89 1 5 2,4 01.70 4,888.87 0.00 464,490.19 1 14 Ricoh U SA Admin & Financ e Copier 2013 2018 101 1/1 6 4/16 7/16 1 0/16 11,247.9 7 3,0 7 9.36 1,8 20.29 108.06 0.00 1,259.07 1 17 Pol i c e Dept. Rec ord D i v. Ricoh Pol ice Records C opier 2013 2018 101 Mon t hl y 3rd--9,678.2 6 4,1 9 4.14 1,1 75.86 119.14 0.00 3,018.28 1 18 Water Works Main R icoh Copier Water Works Main R icoh Copi er 2013 2018 620 Mon t hl y 10th--5,647.5 0 2,4 4 8.11 686.03 69.62 0.00 1,762.08 1 19 Water Works Col fax Ri c oh Copier Water Works C o lfax R i coh Copier 2013 2018 620 Mon t hl y 16th--4,732.6 5 2,0 5 1.62 574.89 58.33 0.00 1,476.73 1 20 Water Works Oli ve Ricoh C op ier Water Works Ol i ve Ric oh Copier 2013 2018 620 Mon t hl y 10th--4,732.6 5 2,0 5 1.62 574.89 58.33 0.00 1,476.73 1 23 Pol i c e Trai ni n g Dept. Ricoh C o p ier T rai n in g Copier 2014 2019 101 Mon t hl y 30th--4,263.0 0 2,0 7 6.44 513.26 60.74 0.00 1,563.18 1 24 Key G o ver n m ent Finance 2014 City V ehicles 2014 2019 various 4/1 10/1--1,959,485.9 5 1,193,7 9 7.05 1 9 5,1 45.63 9,252.64 0.00 998,651.42 1 25 HP Com p u t e r Leas e #1 Computer Equipment Lease 2014 2018 various Mon t hl y 8th--137,104.9 5 63,5 2 5.63 1 8,8 57.53 1,456.68 0.00 44,668.10 1 26 HP Com p u t e r Leas e #2 Computer Equipment Lease 2014 2018 201 and 620 Mon t hl y 8th--4,000.0 0 1,9 4 7.01 549.04 46.24 0.00 1,397.97 1 27 HP Com p u t e r Leas e #4 Computer Equipment Lease 2014 2018 404 Mon t hl y 8th--5,886.1 5 2,7 9 5.30 817.43 55.26 0.00 1,977.87 1 28 HP Com p u t e r Leas e #6 Computer Equipment Lease 2014 2018 201 Mon t hl y 8th--3,755.5 0 1,9 1 7.99 510.07 48.25 0.00 1,407.92 1 29 HP Com p u t e r Leas e #7 Computer Equipment Lease 2014 2018 620 Mon t hl y 8th--1,326.0 0 7 0 6.05 182.55 13.94 0.00 523.50 1 30 Sol i d W aste Copi er Ric oh USA Copier 2014 2019 611 Mon t hl y 17th--5,351.6 5 3,3 0 2.32 617.91 99.38 0.00 2,684.41 1 31 Pol i c e Comm u n ications C o p ier Ric oh USA Copier 2014 2019 101 Mon t hl y 12th--8,843.0 0 4,8 7 6.99 1,0 40.31 144.93 0.00 3,836.68 1 32 Or g a n ic Resou rces & W astew at er Ric oh USA Copiers 2014 2019 641 Mon t hl y 21st--12,260.1 8 6,5 5 8.16 1,4 49.08 194.17 0.00 5,109.08 1 34 Water Works Copi er - N o rth S t a t ion Ric ho USA Copiers 2014 2019 620 Mon t hl y 19th--4,732.6 5 2,1 3 2.25 572.25 60.97 0.00 1,560.00 1 36 HP Com p u t e r Leas e #8 Computer Equipment Lease 2015 2019 404/201/611 Mon t hl y 16th--19,603.9 4 11,8 5 4.14 2,6 19.66 316.00 0.00 9,234.48 1 37 Animal C on t rol Ricoh C op i er Ric oh USA Copiers 2015 2020 600 Mon t hl y 30th--5,261.5 0 3,5 9 1.88 595.46 113.78 0.00 2,996.42 1 38 HP Com p u t e r Leas e #9 Computer Equipment Lease 2015 2019 Various Mon t hl y TBD--135,958.0 5 94,7 1 0.62 1 7,8 42.42 2,518.48 0.00 76,868.20 1 40 Vehic l e & E q u i p. Lease Vehi c le/Equipment Lease 2015 2020 Various 1/1 5 7/15--3,425,273.5 8 2,763,8 4 5.35 6 7 6,7 23.50 35,941.86 0.00 2,087,121.85 1 43 HP Com p u t e r Leas e #1 1 Computer Equipment Lease 2015 2019 404 Mon t hl y 3,040.0 0 2,1 6 1.06 401.95 53.89 0.00 1,759.11 1 44 PN C Vehi c le Lease No. 2 Vehi c le Lease P u rc has e 2015 2020 various 5/1 5 11/15--1,267,183.0 0 1,021,8 5 5.36 1 2 4,3 10.54 7,886.90 0.00 897,544.82 1 46 Parks & Recreation Copier Ric oh Copier 2016 2020 201 Mon t hl y 4,302.0 6 3,4 5 4.72 466.91 108.63 0.00 2,987.81 1 47 Central S erv ices Lanier Copi e r C51005 Copi er 2016 2020 222 Mon t hl y---32,525.0 0 28,6 6 7.19 3,4 88.57 837.29 0.00 25,178.62 1 48 Central S erv ices Lanier Copi e r C6502 2016 2020 222 Mon t hl y---11,413.0 0 10,0 5 9.31 1,2 24.13 293.82 0.00 8,835.18 1 49 Vehic l e & E q u i p. Lease Publi c Wor ks V eh i cles Lease 2016 2021 various 2/1 5 8/15 3,339,830.0 0 3,016,4 8 4.17 3 2 4,5 95.10 24,101.71 0.00 2,691,889.07 1 50 HP Com p u t e r Leas e Computer L ease- Refresh 2016 2020 404/641/620 Mon t hl y---17,439.8 5 14,0 1 3.99 2,2 57.92 357.28 0.00 11,756.07 1 51 Admin and F inance Ric oh Copier MPC 8 0 0 2 SP Copier 2016 2021 101 Mon t hl y---10,923.6 3 8,9 3 8.27 1,1 79.91 281.48 0.00 7,758.36 1 52 PN C Vehi c le / Equip Lease No. 2 Vehi c le / Equipment Lease 2016 2021 various 1/1 4 7/14--3,992,548.7 2 3,992,5 4 8.72 7 7 0,3 91.63 62,984.69 0.00 3,222,157.09 1 53 PN C Vehi c le / Equip Lease Am e n d 1 Parks a n d Recreation 2016 2012 201 1/1 7 7/17--78,808.0 0 78,8 0 8.00 1 5,2 87.29 1,141.51 0.00 63,520.71 1 54 PN C Vehi c le / Equip Lease No. 3 Parks & Rec / IT 2016 2021 201/2 7 9 4/1 9 10/19--1,256,096.9 9 1,256,0 9 6.99 1 2 1,7 61.99 9,042.29 0.00 1,134,335.00 1 55 HP Com p u t e r Leas e No. 13 Computer Equipment Lease 2016 2020 various Mon t hl y---156,029.3 0 150,5 6 2.73 1 9,3 81.70 4,057.59 0.00 131,181.03 1 57 Venue, P ar ks, Art Copi er Ric oh Copier 2016 2021 201 Mon t hl y---3,184.0 6 3,1 8 4.06 676.86 298.91 0.00 2,507.20 1 58 Publi c Financ e.c o m Inc 2017 Vehic l e L e a se No. 1 2017 2022 various 1/1 4 7/14--2,916,500.0 0 0.00 0.00 0.00 2,916,500.00 2,916,500.00 1 59 Mayor/Waste W ater/Fire Ric oh 2017 Ricoh C o p ier L e a se 2017 2021 101/641/287 Mon t hl y---15,702.0 9 0.00 1,8 08.38 443.30 15,702.09 13,893.71 1 60 HP Com p u t e r Refr esh Lease No. 14 2017 Ricoh C o p ier L e a se 2017 2021 279/2 0 1 Mon t hl y---10,305.2 5 0.00 917.44 188.76 10,305.25 9,387.81 1 62 Vehic l e & E q u i p. Lease No. 2 Vehi c le / Equipment Lease 2017 2021 404 2/1 5 8/15--1,632,000.0 0 0.00 0.00 0.00 1,632,000.00 1,632,000.00 xxx To tal Ca pital L e ase 34,787,495.2 1 16,078,9 4 5.72 3,5 8 2,0 56.46 1 87,300.65 4,574,507.34 17,071,396.60 T otal Ci vi l Ci t y 299,487,420.7 1 147,504,5 6 8.39 5,4 2 2,7 96.66 2,2 74,873.06 4,574,507.34 146,656,279.07 2 01 7-07 F ina nc i al Re port - D ebt P age 20 o f 2 5 City of South Bend Period Ending:July 31, 2017 Monthly Debt Schedule` Year of Year of Year o f Sch e duled Payme nts Debt (O rig / Refi)D e bt at Y TD Pr i ncipal YTD Int e rest YT D Debt at Deb t Inst rum e nt Deb t Pu rpo s e Issu e Refu ndin g Mat urit y Fu nd 1st 2n d 3rd 4th Issu e 12/31/2016 Payme nts Paym e nts Addit i ons 7/31/2017 Redevelo pment Co mmissio n D e bt Bon d D e bt 7 Century Center Lease Rental Rev e n u e Century Center 1994 2001/2 0 1 1 2018 407 2/1 8/1--6,825,000.0 0 720,0 0 0.00 2 3 5,0 00.00 10,200.00 0.00 485,000.00 8 Coll eg e Footbal l Hall of Fame Hal l o f Fame 1994 2000/2 0 1 1 2018 313 2/1 8/1--15,370,000.0 0 1,830,0 0 0.00 6 0 0,0 00.00 31,728.75 0.00 1,230,000.00 11 South B e n d Building C o rporati on Morr i s PAC 1998 2009 2017 408 2/1 8/1--13,300,000.0 0 515,0 0 0.00 5 1 5,0 00.00 10,300.00 0.00 0.00 12 T J X S pec ial T a xing Di st ri ct 2002 2014 2022 324/404/414 1/1 7/1--6,620,000.0 0 2,210,0 0 0.00 0.00 33,150.00 0.00 2,210,000.00 5 Dow ntow n Centr al Area TIF 2003 2011 2024 420 2/1 8/1--19,795,000.0 0 12,500,0 0 0.00 6 5 0,0 00.00 3 06,755.00 0.00 11,850,000.00 6 Airport Developm e n t Area T I F Ai rport TI F 2003 2011 2024 324 2/1 8/1--14,420,000.0 0 7,125,0 0 0.00 3 7 0,0 00.00 1 74,841.75 0.00 6,755,000.00 22 Erski n e Vill ag e TIF Developm e n t Bond Ersk i n e Vil l ag e 2005 2027 432 2/1 8/1--5,485,000.0 0 3,800,0 0 0.00 2 5 0,0 00.00 1 23,667.50 0.00 3,550,000.00 54 L ease Rental Revenue B ond s of 2008 Eddy Str e et Comm o n s 2008 2027 429 2/1 5 8/15--36,000,000.0 0 30,075,0 0 0.00 6 5 5,0 00.00 5 79,003.13 0.00 29,420,000.00 81 Covel e ski S t a d ium Recovery Coveleski Stadium 2010 2019 377 1/1 5 7/15--4,980,000.0 0 1,665,0 0 0.00 6 5 0,0 00.00 77,155.00 0.00 1,015,000.00 1 22 Synagogue at Coveles ki Im prov e m ents Coveleski Stadium 2014 2018 377 1/3 1---500,000.0 0 200,0 0 0.00 0.00 0.00 0.00 200,000.00 1 35 2 0 1 5 Redevelopment S m art S t reets Smart Streets 2015 2037 324 2/1 8/1--25,000,000.0 0 25,000,0 0 0.00 0.00 3 94,784.38 0.00 25,000,000.00 1 61 Studebaker P roject F a çade Im prov em ent Bldg 8 4 2017 2018 324 One-t im e---3,500,000.0 0 0.00 0.00 0.00 3,500,000.00 3,500,000.00 1 63 2 0 1 7 Eddy S t. C om mons Phase II Eddy St. Comm o n s Phase II 2017 2037 436 2/1 5 8/15--25,000,000.0 0 0.00 0.00 0.00 2 5,000,000.00 25,000,000.00 xxx Total Bo nd Debt 182,288,788.0 0 85,640,0 0 0.00 3,9 2 5,0 00.00 1,7 41,585.51 2 8,500,000.00 110,215,000.00 L oans Payable 3 I n d iana Devel opm en t Finance Auth or it y Bos c h Property (Nonforgive)2001 2021 210 3/2 2 6/22 9/22 1 2/22 1,040,000.0 0 302,0 6 9.15 3 1,5 92.21 4,413.01 0.00 270,476.94 4 I n d iana Devel opm en t Finance Auth or it y Bos c h Property (Forgiv e)2001 2021 210----260,000.0 0 83,4 8 2.06 0.00 0.00 0.00 66,406.56 64 I n t e rfund Fund 412 - Maj o r Mov es Douglas Road TI F 2009 2029 435 2/1 5 8/15--1,040,319.0 0 323,0 0 5.00 1 4 1,9 25.00 8,075.00 0.00 181,080.00 84 I n t e rfund Fund 412 - Maj o r Mov es T ri a n g l e Devel o p m ent 2011 2029 436 2/1 5 8/15--2,000,000.0 0 1,329,5 7 3.43 4 7,0 75.27 13,295.73 0.00 1,282,498.16 85 I n t e rfund Fund 412 - Maj o r Mov es Eddy Str e et Comm o n s 2011 2026 436 2/1 5 8/15--4,100,000.0 0 2,384,3 4 7.86 3 2 6,6 09.30 59,608.70 0.00 2,057,738.56 86 I n t e rfund Fund 209 t o Airport 3 2 4 Prairie Ave B row n f ield P roj ec t 2011 2020 324 8/9---500,000.0 0 400,0 0 0.00 0.00 0.00 0.00 400,000.00 1 42 I n t e rfund Fund 412 - Maj o r Mov es Parki n g G a rage Improvements 2016 2022 601 6/1 12/1--1,500,000.0 0 517,3 0 4.69 0.00 0.00 750,000.00 1,267,304.69 xxx To t al Loans Paya ble 15,627,499.0 6 5,339,7 8 2.19 5 4 7,2 01.78 85,392.44 750,000.00 5,525,504.91 Capit a l Lease xxx To tal Ca pital L e ase 0.0 0 0.00 0.00 0.00 0.00 0.00 L eases 13 T ranspo Lease Main / Colfax Garage 2006 2025 324 3/1 5 9/15--2,510,278.0 0 1,435,3 3 8.00 6 4,1 17.00 35,883.00 0.00 1,371,221.00 xxx Tot a l Lease 5,510,278.0 0 1,435,3 3 8.00 6 4,1 17.00 35,883.00 0.00 1,371,221.00 Tota l Red e v e l opme nt Commiss i on 203,426,565.0 6 92,415,1 2 0.19 4,5 3 6,3 18.78 1,8 62,860.95 2 9,250,000.00 117,111,725.91 To t al D e bt 502,913,985.7 7 239,919,6 8 8.58 9,9 5 9,1 15.44 4,1 37,734.01 3 3,824,507.34 263,768,004.98 2 01 7-07 F ina nc i al Re port - D ebt P age 21 o f 2 5 City of South Bend Staffing Headcount Summary Budget Full Time Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Full Time Staff 1,107 1,080 1,069 1,082 1,078 1,076 1,093 1,089 0 0 0 0 0 Part Time Staff 115 119 142 155 168 145 139 0 0 0 0 0 Temporary / Seasonal 12 11 13 41 86 206 202 0 0 0 0 0 City Total 1,207 1,199 1,237 1,274 1,330 1,444 1,430 0 0 0 0 0 2017-07 Financial Report - Headcount Staffing Page 22 of 25 City of South Bend Staffing Headcount Full Time Staff Amended Budget FT Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor 7 6 6 6 5 6 8 8 0 0 0 0 0 311 Call Center 6 6 6 6 7 7 6 6 0 0 0 0 0 Admin & Finance 23 20 21 22 23 23 23 23 0 0 0 0 0 Innovation/ Technology Office 18 14 14 15 14 16 17 17 0 0 0 0 0 Safety & Risk 2 2 2 2 2 2 2 2 0 0 0 0 0 Clerk 5 5 5 5 5 5 5 5 0 0 0 0 0 Common Council 9 9 9 9 9 9 9 9 0 0 0 0 0 Legal Department 11 11 11 10 10 10 10 11 0 0 0 0 0 Sub Total 81 73 74 75 75 78 80 81 0 0 0 0 0 Code Enf. /Animal Control/ Unsafe Bldg.29 24 26 28 28 29 28 29 0 0 0 0 0 Dept. of Community Investment 23 22 20 21 21 20 20 20 0 0 0 0 0 Parks & Recreation Administration 6 6 6 6 6 6 6 6 0 0 0 0 0 Maintenance 50 45 47 48 47 47 48 48 0 0 0 0 0 Golf Operations 8 7 8 7 8 8 8 8 0 0 0 0 0 Recreation Ops 21 22 21 21 21 21 22 22 0 0 0 0 0 Zoological Ops 1 1 1 1 1 1 1 1 0 0 0 0 0 Graffiti Removal 1 1 1 1 1 1 1 1 0 0 0 0 0 Recreation Non-reverting 1 1 1 1 1 1 0 0 0 0 0 0 0 Marketing and Events 10 8 10 10 10 10 10 10 0 0 0 0 0 Sub Total 98 91 95 95 95 95 96 96 0 0 0 0 0 Public Safety Police 289 284 272 282 280 278 288 283 0 0 0 0 0 Fire 264 268 267 266 263 261 259 260 0 0 0 0 0 Sub Total 553 552 539 548 543 539 547 543 0 0 0 0 0 Public Works Central Services 40 38 39 37 37 38 39 38 0 0 0 0 0 Office of Sustainability 2 2 2 2 2 2 2 2 0 0 0 0 0 Engineering 18 18 18 20 20 20 20 20 0 0 0 0 0 Solid Waste Operations 26 25 25 26 25 24 25 25 0 0 0 0 0 Street Operations 55 54 54 54 54 53 56 54 0 0 0 0 0 Sewer Operations 621 37 37 37 37 37 35 37 37 0 0 0 0 0 Waste Water Ops 630 45 45 45 44 44 45 45 45 0 0 0 0 0 Organic Resources 6 6 5 5 6 6 6 6 0 0 0 0 0 Water Utility Ops 65 64 63 63 63 64 65 66 0 0 0 0 0 Sub Total 294 289 288 288 288 287 295 293 0 0 0 0 0 Building Department 14 14 14 14 14 14 14 14 0 0 0 0 0 Human Rights 6 6 6 6 6 6 5 5 0 0 0 0 0 Morris & Palais 9 9 7 7 8 8 8 8 0 0 0 0 0 City Total 1,107 1,080 1,069 1,082 1,078 1,076 1,093 1,089 - - - - - 2017-07 Financial Report - Headcount Staffing Page 23 of 25 City of South Bend Staffing Headcount Part Time Staff Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor 1 1 1 1 1 0 0 0 0 0 0 0 311 Call Center 2 2 2 0 0 2 2 0 0 0 0 0 Admin & Finance 0 0 0 0 0 0 0 0 0 0 0 0 Safety and Risk 0 0 0 0 0 0 0 0 0 0 0 0 Innovation/ Technology Office 1 0 0 0 0 0 0 0 0 0 0 0 Clerk 0 0 0 0 0 0 0 0 0 0 0 0 Common Council 0 0 0 0 0 0 0 0 0 0 0 0 Legal Department 1 1 1 1 1 1 1 0 0 0 0 0 Sub Total 5 4 4 2 2 3 3 0 0 0 0 0 Code Enf. / Animal Control 3 2 3 3 3 4 4 0 0 0 0 0 Dept. of Community Investment 0 0 0 0 0 0 0 0 0 0 0 0 Parks & Recreation Administration 1 1 1 1 1 1 0 0 0 0 0 0 Maintenance 11 11 11 15 14 13 13 0 0 0 0 0 Golf Operations 2 0 18 41 54 54 53 0 0 0 0 0 Recreation Ops 46 54 54 46 48 42 40 0 0 0 0 0 Zoological Ops 0 0 0 0 0 0 0 0 0 0 0 0 Graffiti Removal 4 4 4 1 1 0 1 0 0 0 0 0 Marketing & Events 1 1 1 1 1 1 1 0 0 0 0 0 Sub Total 65 70 88 104 118 110 108 0 0 0 0 0 Public Safety Police 25 25 29 27 27 10 5 0 0 0 0 0 Communications 0 0 0 0 0 0 0 0 0 0 0 0 Fire 0 0 0 0 0 1 1 0 0 0 0 0 Sub Total 25 25 29 27 27 11 6 0 0 0 0 0 Public Works` Central Services 1 1 1 1 1 1 1 0 0 0 0 0 Engineering 2 2 2 3 2 2 2 0 0 0 0 0 Traffic & Lighting 0 0 0 0 0 0 0 0 0 0 0 0 Maintenance 0 0 0 0 0 0 0 0 0 0 0 0 Solid Waste Ops 0 0 0 0 0 0 0 0 0 0 0 0 Street Ops 7 8 9 9 9 7 7 0 0 0 0 0 Sewer Ops 0 0 0 0 0 0 0 0 0 0 0 0 Waste Water Ops 0 0 0 0 0 0 0 0 0 0 0 0 Water Utility Ops 3 3 2 2 2 3 4 0 0 0 0 0 Sub Total 13 14 14 15 14 13 14 0 0 0 0 0 Building Department 0 0 0 0 0 0 0 0 0 0 0 0 Human Rights 0 0 0 0 0 0 0 0 0 0 0 0 Morris & Palais 4 4 4 4 4 4 4 0 0 0 0 0 City Total 115 119 142 155 168 145 139 0 0 0 0 0 2017-07 Financial Report - Headcount Staffing Page 24 of 25 City of South Bend Staffing Headcount Paid Temporary, Seasonal, and Intern Staff Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor 0 0 0 0 0 0 1 0 0 0 0 0 Admin & Finance 1 1 0 0 1 1 1 0 0 0 0 0 Safety and Risk 1 0 0 0 0 0 0 0 0 0 0 0 Clerk 0 0 0 0 0 0 0 0 0 0 0 0 Common Council 0 0 0 0 0 0 0 0 0 0 0 0 Legal 0 0 0 0 0 0 0 0 0 0 0 0 Sub Total 2 1 0 0 1 1 2 0 0 0 0 0 Code Enfor. / Animal 1 1 1 1 1 0 2 0 0 0 0 0 Dept. of Community Investment 0 0 0 0 0 0 0 0 0 0 0 0 Parks & Recreation Administration 0 0 0 0 0 0 1 0 0 0 0 0 Maintenance 1 1 2 12 29 36 32 0 0 0 0 0 Golf Operations 0 0 1 1 2 3 5 0 0 0 0 0 Recreation Ops 3 2 2 15 40 129 127 0 0 0 0 0 Zoological Ops 0 0 0 0 0 0 0 0 0 0 0 0 Graffiti Removal 0 0 0 0 0 0 0 0 0 0 0 0 Sub Total 4 3 5 28 71 168 165 0 0 0 0 0 Public Safety Police 0 0 0 0 0 14 14 0 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 0 0 0 0 0 14 14 0 0 0 0 0 Public Works Central Services 0 0 0 0 0 1 0 0 0 0 0 0 Engineering 3 4 4 4 1 7 7 0 0 0 0 0 Energy / Sustainability 0 0 0 0 0 0 0 0 0 0 0 0 Traffic & Lighting 0 0 0 0 0 0 0 0 0 0 0 0 Maintenance 0 0 0 0 0 0 0 0 0 0 0 0 Solid Waste Ops 0 0 0 0 0 0 0 0 0 0 0 0 Street Ops 1 1 1 7 9 8 8 0 0 0 0 0 Sewer Ops 0 0 0 0 0 0 0 0 0 0 0 0 Leaf Pickup 0 0 0 0 0 0 0 0 0 0 0 0 Waste Water Ops 0 0 1 0 1 2 0 0 0 0 0 0 Organic Resources 0 0 0 0 0 1 0 0 0 0 0 0 Water Utility Ops 0 0 0 0 2 4 4 0 0 0 0 0 Sub Total 4 5 6 11 13 23 19 0 0 0 0 0 Building Department 0 0 0 0 0 0 0 0 0 0 0 0 Human Rights 0 0 0 0 0 0 0 0 0 0 0 0 Morris & Palais 1 1 1 1 0 0 0 0 0 0 0 0 City Total 12 11 13 41 86 206 202 0 0 0 0 0 2017-07 Financial Report - Headcount Staffing Page 25 of 25