Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017-02 Financial Report
Period Ending: Issued By: City of South Bend Financial Report Tab Page Contents Narrative 2 Brief discussion on notable fund activity Revenue 3-10 City Revenues Prop Tax Rev 11-12 Property Tax Revenue Collection Status Expenditures 13-17 Expenditures by Fund and Department Debt 18-19 Debt Status Debt Monthly 20-21 Current Debt at Month End Headcount 22-25 Staffing Levels Distribution Mayor Pete Buttigieg Chief of Staff James Mueller Deputy Chief of Staff Suzanna Fritzberg Controller John Murphy Deputy Controller Jennifer Hockenhull City Finance Director Rahman Johnson Sr. Budget Analyst Amy O'Connor Department Heads Fiscal Officers City Common Council February 28, 2017 Controller 2017-02 Financial Report Page 1 of 25 February 28, 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 216 (Police Seizures). This is revenue related to law enforcement and the sale of confiscated property. -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 217(Gift, Donation), is at 277% of its budgeted revenue. This is revenue received in the amount $50,000 from Notre Dame for the Dr. Martin Luther King and the Reverend Father Theodore Hesburgh statue. Property Taxes Total property taxes collected for the year 2015 was~$70.9 million or 94.76%of the tax levy.Specifically,in 2015 the City of South Bend received a total of$46,171,932 in property tax revenue in the civil city funds(general fund,parks,College Football Hall of Fame,and CCD). For TIF funds, the City received a total of $24,742,902 in property tax revenue. Expenditures Debt Headcount If you have any questions regarding this report, please contact John Murphy at (574) 235-7678. As of February 2017,the City has spent 14%of budgeted expenditures,similar to 14%in February 2016.The General Fund has spent 15%of its 2017 budgeted expenditures,versus 14%in 2016.The following funds have reached 50%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~$5.8 million to Sun Trust,Kansas State Bank,PNC Bank,U.S. Bank and Ricoh USA.Payments are related to IT equipment leases,police/public works vehicles,solid waste containers,and sewer bonds. The Full Time Headcount as of February was 1,069 vs.a budgeted amount of 1,116.Currently,there are a total of 47 vacant positions. The 47 open positions are in the following departments:General Government(6),Parks(3),Public Safety(14),Public Works(12),DCI (3), Morris and Palais (2), and Code Enforcement / Animal Control (7). For discussion on property taxes,see section listed below.The overall percentage of budgeted revenues that have been received by the city is 13%,compared to 12%in February 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) has reached 50% of its budgeted revenue. As of February 2017,the general fund has reached 4%of its budgeted revenue,same as 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 in 2016 totaled~$76.7 million.Civil city funds received ~$49.1 million and TIF funds received~$27.6 million.For 2016,the projected levy collection rate is 95%or$75.2 million.Please note, 2016 civil city funds are ~$2.4 million more than 2015 budget. - Funds 249 (PS LOIT), 404 (COIT), and 408 (EDIT) received normal and timely distributions this month. 2017-02 Financial Report Page 2 of 25 City of South Bend Period Ending:February 28, 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- - - - - - - - - - - - 48,373,228 0% 311 Property Tax TIF Districts various- - - - - - - - - - - - 27,254,124 0% Sub Total- - - - - - - - - - - - - 75,627,352 0% Income Tax 315 Econ Development Income Tax 408 883,344 883,344 - - - - - - - - - - 1,766,687 10,433,361 17% 316 Local Option Income Tax - PS 249 622,302 622,302 - - - - - - - - - - 1,244,603 7,467,618 17% 316 County Option Income Tax 404 871,605 871,605 - - - - - - - - - - 1,743,211 10,459,265 17% Sub Total 2,377,250 2,377,250 - - - - - - - - - - 4,754,501 28,360,244 17% St Joseph County (Remitted by) 312 Auto Excise Tax various- - - - - - - - - - - - - 3,206,500 0% 312 Commercial Vehicle Tax various- - - - - - - - - - - - - 843,000 0% 317 Hotel Motel Tax Century Center 670 637,500 - - - - - - - - - - - 637,500 1,275,000 50% 317 Hotel Motel Tax Century Center 324- - - - - - - - - - - - - 394,000 0% 317 Hotel Motel Tax Cum Cap Imprv 407 150,000 - - - - - - - - - - - 150,000 150,000 100% Sub Total 787,500 - - - - - - - - - - - 787,500 5,868,500 13% State of Indiana (Remitted by) 312 CRED Tax 434- - - - - - - - - - - - - - NA 335 Cigarette Tax 101/407- - - - - - - - - - - - - 328,000 0% 335 State Pension Subsidy 701/702- - - - - - - - - - - - - 11,342,638 0% 335 Gaming Proceeds 101- - - - - - - - - - - - - 599,000 0% 335 Gasoline Tax 202/251 361,601 314,230 - - - - - - - - - - 675,831 4,668,000 14% 335 Liquor Excise tax 101- 42,158 - - - - - - - - - - 42,158 75,000 56% 335 Liquor Gallonage Tax 101 63,498 - - - - - - - - - - - 63,498 210,000 30% 335 Prof Sports Development Tax 377 62,404 - - - - - - - - - - - 62,404 700,000 9% 335 Wheel Tax 202- - - - - - - - - - - - - 2,050,000 0% Sub Total 487,503 356,388 - - - - - - - - - - 843,891 19,972,638 4% Other Intergovernmental Sources 336 Federal Drug 299- - - - - - - - - - - - - 30,000 0% 337 State Drug 216 10,113 2,962 - - - - - - - - - - 13,076 35,000 37% 338 Payment in Lieu of Tax various 517,361 871,113 - - - - - - - - - - 1,388,474 7,623,328 18% 339 Contractual Service 211 9,669 12,407 - - - - - - - - - - 22,075 316,000 7% Sub Total 537,143 886,481 - - - - - - - - - - 1,423,624 8,004,328 18% Charge for Service Internal City 340 Liability Insurance 226 243,168 243,964 - - - - - - - - - - 487,132 2,927,591 17% 340 General Government Misc Chgs 101/289- - - - - - - - - - - - - 500 0% 340 Police Take Home Vehicle 278- - - - - - - - - - - - - 122,200 0% 349 Central Service 222 51,820 48,684 - - - - - - - - - - 100,504 873,809 12% 380 Central Service 222 210,212 208,994 - - - - - - - - - - 419,206 2,880,310 15% 380 Energy Office Reimbursements 222 411,202 429,754 - - - - - - - - - - 840,956 4,492,800 19% 380 IT Innovation 311 Center 279 430,621 430,621 - - - - - - - - - - 861,242 5,197,431 17% 380 INDOT SR 933 Transfer 324- - - - - - - - - - - - - 4,100,000 0% 380 Internal Service Reimbursement various 65,792 89,865 - - - - - - - - - - 155,657 1,404,921 11% 392 Administration Fee 101/279 414,748 414,748 - - - - - - - - - - 829,496 4,977,026 17% 392 Internal Fund Transfers various 1,085,348 9,754,150 - - - - - - - - - - 10,839,498 39,699,016 27% 395 Employee Benefits 711/713 1,499,317 1,460,178 - - - - - - - - - - 2,959,495 17,836,850 17% 2017-02 Fin anc i al Re port - Rev enue Report Page 3 of 25 City of South Bend Period Ending:February 28, 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 - - - - - - - - - - - 1,314 21,000 6% 396 Self Funded Employee Benefits 711 6,503 (2,436) - - - - - - - - - - 4,067 - NA xxx xxx xxx- NA Sub Total 4,420,045 13,078,521 - - - - - - - - - - 17,498,565 84,533,454 21% 3rd Party Revenue 340 ND EMS Service 288- - - - - - - - - - - - - 150,000 0% 340 Memorial Hospital Neo Natal 101- - - - - - - - - - - - - - NA 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 - - - - - - - - - - - 55,865 284,000 20% 393 Debt Proceeds 750- - - - - - - - - - - - - 5,499,000 0% Sub Total 55,865 546,898 - - - - - - - - - - 602,763 7,035,660 9% Grants 331 Federal Grants various 468,447 1,200,229 - - - - - - - - - - 1,668,676 5,587,386 30% 332 Solar Energy Grant 222- - - - - - - - - - - - - - NA 334 State Grants various- - - - - - - - - - - - - 3,025,381 0% Sub Total 468,447 1,200,229 - - - - - - - - - - 1,668,676 8,612,767 19% Fees for Services External 320 Inspections Central Service 222- - - - - - - - - - - - - 1,450 0% 321 Business License 101/222 30,917 29,318 - - - - - - - - - - 60,235 120,130 50% 321 Code and Animal Fees 600 4,536 4,585 - - - - - - - - - - 9,120 54,500 17% 322 Building Fees 600 90,363 86,593 - - - - - - - - - - 176,955 1,360,350 13% 322 Code Enforcement Fees 600 1,050 300 - - - - - - - - - - 1,350 20,000 7% 322 EMS Operating Fund 288 1,923 1,380 - - - - - - - - - - 3,303 24,000 14% 322 General Government Fees 101 32,047 7,275 - - - - - - - - - - 39,322 100,000 39% 341 General Government Various various 3,316 959 - - - - - - - - - - 4,275 27,005 16% 342 Highway & Streets 101/202 38,686 - - - - - - - - - - - 38,686 223,365 17% 342 Public Safety various 12,869 10,404 - - - - - - - - - - 23,273 150,000 16% 342 EMS - County Fees 288- 294,414 - - - - - - - - - - 294,414 1,740,000 17% 342 EMS - Capital Fund 287- 1,798,417 - - - - - - - - - - 1,798,417 1,275,000 141% 342 EMS - Operating Fund 288 160,939 235,524 - - - - - - - - - - 396,464 2,700,000 15% 342 EMS - Neo Natal / Transport 288 16,185 18,553 - - - - - - - - - - 34,738 1,699,512 2% 344 Solid Waste 610 445,203 460,843 - - - - - - - - - - 906,046 5,636,175 16% 344 Code Environmental Clean Up 101/219/600 12,404 3,044 - - - - - - - - - - 15,448 180,000 9% 344 Sewage Waste Water 641 3,208,590 3,128,008 - - - - - - - - - - 6,336,598 37,020,404 17% 344 Sewer Repair Insurance 640 53,614 52,952 - - - - - - - - - - 106,566 613,924 17% 344 Water Leak Insurance 620 81,303 81,237 - - - - - - - - - - 162,540 1,173,361 14% 346 Water Works Utility 620 1,039,872 1,012,523 - - - - - - - - - - 2,052,395 16,175,473 13% 346 Solid Waste Misc 610 1,504 10,324 - - - - - - - - - - 11,828 110,000 11% 346 Project ReLeaf 655 36,802 36,730 - - - - - - - - - - 73,532 440,153 17% 347 Parks & Recreation various 74,837 77,843 - - - - - - - - - - 152,680 4,337,134 4% 347 Sale of Merchandise 101- - - - - - - - - - - - - 100 0% 347 Morris PAC 416- 12,214 - - - - - - - - - - 12,214 100,000 12% 349 Parking Garage Fees 601 115,464 73,834 - - - - - - - - - - 189,298 986,129 19% 349 Code Demolition Board Up 219/600 2,805 2,067 - - - - - - - - - - 4,872 90,000 5% 349 Parking Century Center 670 12,814 19,676 - - - - - - - - - - 32,490 100,033 32% 349 Parking SBCDA 324/420429 350 700 - - - - - - - - - - 1,050 - NA 351 Fines & Fees various 27,430 36,628 - - - - - - - - - - 64,058 252,720 25% 352 Forfeits various 734 616 - - - - - - - - - - 1,351 200,000 1% 354 Ordinance Violation various 5,163 7,326 - - - - - - - - - - 12,489 72,500 17% 360 Morris PAC various 10,087 86,686 - - - - - - - - - - 96,772 976,000 10% 360 Palais Royale various 24,371 4,131 - - - - - - - - - - 28,502 256,572 11% 360 Parks & Recreation various 9,055 4,207 - - - - - - - - - - 13,262 94,206 14% 360 Police various 4,432 3,558 - - - - - - - - - - 7,990 25,000 32% 360 Fire various- 37,987 - - - - - - - - - - 37,987 - NA 360 TIF various 31,545 2,510 - - - - - - - - - - 34,054 52,725 65% 360 Central Services 222 608 - - - - - - - - - - - 608 11,000 6% 360 Century Center 670- 120 - - - - - - - - - - 120 10,000 1% 360 Dept. Of Community Investment 211/212 65,547 23 - - - - - - - - - - 65,570 197,000 33% 360 Economic Dev. State Grant 210- - - - - - - - - - - - - - NA 360 EMS Operating Fund 288 525 - - - - - - - - - - - 525 5,000 11% 360 Engineering / Curb & Sidewalk 101- 50 - - - - - - - - - - 50 11,000 0% 360 Fire and Police Pension Fund 701/702 1,523 675 - - - - - - - - - - 2,198 2,000 110% 360 Self Funded Employee Benefits 711- - - - - - - - - - - - - - NA 360 Industrial Revolving 754- - - - - - - - - - - - - 27,000 360 General Government Various 101/3/226 13,427 24 - - - - - - - - - - 13,452 14,000 96% 2017-02 Fin anc i al Re port - Rev enue Report Page 4 of 25 City of South Bend Period Ending:February 28, 2017 Revenue by Type Report $ Fund% Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget 360 Motor Veh Highway Scrap Metal 202 285 - - - - - - - - - - - 285 4,896 6% 360 Motor Veh Highway Curb Prgm 202 11 - - - - - - - - - - - 11 32,000 0% 360 Local Roads and Streets 251- 274 - - - - - - - - - - 274 - NA 360 Professional Sports Development 377 17,864 - - - - - - - - - - - 17,864 30,000 60% 360 C.O.I.T.404 725 - - - - - - - - - - - 725 - NA 360 CCI / EDIT 407/408- - - - - - - - - - - - - - NA 360 UDAG 410- - - - - - - - - - - - - - NA 360 Code / Animal Control 600 170 5 - - - - - - - - - - 175 6,500 3% 360 Building Fees 600- - - - - - - - - - - - - - NA 360 Parking Garage 601 20 - - - - - - - - - - - 20 11,282 0% 360 Solid Waste Fund 610- 265 - - - - - - - - - - 265 2,000 13% 360 Waste Water 641/7/9- 3,437 - - - - - - - - - - 3,437 52,500 7% 360 Water Works Utility 620- 39 - - - - - - - - - - 39 25,000 0% 360 Water Works Bond Reserve 626- - - - - - - - - - - - - - NA 360 Sewage Depreciation Fund 642- 400,000 - - - - - - - - - - 400,000 - NA 362 Dept. Of Community Investment 212 1,847 - - - - - - - - - - - 1,847 - NA 362 Palais Royale 101- 5,114 - - - - - - - - - - 5,114 82,500 6% 362 Police 101- - - - - - - - - - - - - 48,000 0% 362 Parks & Recreation 201 3,786 3,545 - - - - - - - - - - 7,331 43,500 17% 362 S Bend School Corp Fee 407- - - - - - - - - - - - - 25,000 0% 362 Certified Technology Park 439- - - - - - - - - - - - - - NA 362 TIF Property various 14,223 24,108 - - - - - - - - - - 38,332 319,603 12% 362 Self Funded Employee Benefits 711- - - - - - - - - - - - - - NA 369 Memorial Hosp Leighton Plaza 408 150,000 - - - - - - - - - - - 150,000 150,000 100% 371 Century Center Fees 670 260,617 191,881 - - - - - - - - - - 452,498 2,809,278 16% 399 Bosch Retention Project 210- - - - - - - - - - - - - 63,661 0% 399 Principal on Loan various 19,897 19,842 - - - - - - - - - - 39,738 76,374 52% 399 Principal Income various 30,702 596,589 - - - - - - - - - - 627,291 1,703,614 37% Sub Total 6,172,987 8,889,356 - - - - - - - - - - 15,062,343 84,150,629 18% Interest Income 361 Bank Account Interest various 156,963 166,772 - - - - - - - - - - 323,735 1,634,789 20% Sub Total 156,963 166,772 - - - - - - - - - - 323,735 1,634,789 20% Donations 367 ND Contribution 101- - - - - - - - - - - - - 337,500 0% 367 Donations various 75,816 1,040 - - - - - - - - - - 76,856 25,250 304% Sub Total 75,816 1,040 - - - - - - - - - - 76,856 362,750 21% Historic Preservation 368 Lamppost Program 227- - - - - - - - - - - - - - NA 368 C.O.I.T.404- - - - - - - - - - - - - - 368 Palais 450 1,838 114 - - - - - - - - - - 1,952 16,500 12% Sub Total 1,838 114 - - - - - - - - - - 1,952 16,500 12% Sale of Assets 391 TIF (Property Sales / Land)various- 60,000 - - - - - - - - - - 60,000 77,331 78% 391 Property Sales 677- - - - - - - - - - - - - - NA 391 Water Hydrant Reimbursement 620- - - - - - - - - - - - - 20,000 0% 391 Proceeds F.A. Disposal 600- - - - - - - - - - - - - 3,000 0% 391 Sale of Fixed Assets various- - - - - - - - - - - - - 15,000 0% 391 Vehicle Damage Reimbursement various- - - - - - - - - - - - - - NA - Sub Total- 60,000 - - - - - - - - - - 60,000 115,331 52% Revenue Total 15,541,356 27,563,049 - - - - - - - - - - 43,104,406 321,793,758 13% report 15,541,356 27,563,049 - - - - - - - - - - 43,104,406 321,793,758 - 0 - - - - - - - - - - 0 - 2017-02 Fin anc i al Re port - Rev enue Report Page 5 of 25 City of South Bend Period Ending:February 28, 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 - - - - - - - - - - 2,320,560 56,530,002 4% 0101 Mayor 101- - - - - - - - - - - - - 600 0% 0104 311 Call Center 101- - - - - - - - - - - - - - NA 0201 Clerk 101- - - - - - - - - - - - - - NA 0301 Common Council 101- - - - - - - - - - - - - - NA 0401 Administration and Finance 101 12,254 - - - - - - - - - - - 12,254 12,050 102% 0501 Legal 101 18,475 - - - - - - - - - - - 18,475 75,377 25% Sub Total 1,135,996 1,215,293 - - - - - - - - - - 2,351,289 56,618,029 4% Public Works 0602 Engineering 101 32,047 7,275 - - - - - - - - - - 39,322 317,337 12% Sub Total 32,047 7,275 - - - - - - - - - - 39,322 317,337 12% Public Safety 0801 Police 101 34,608 15,151 - - - - - - - - - - 49,760 326,500 15% 0901 Fire 101 4,387 37,987 - - - - - - - - - - 42,373 1,500 2825% Sub Total 38,995 53,138 - - - - - - - - - - 92,133 328,000 28% Code Enforcement 1201 Code 101- - - - - - - - - - - NA 1203 Code Hearing 101- - - - - - - - - - - NA 1204 Code Junk Vehicle 101- - - - - - - - - - - NA 1205 Code Unsafe Building 101- - - - - - - - - - - - - - NA 1207 Code Animal Control 101- - - - - - - - - - - - - - NA xxx xxx- - - - - - - - - - - NA Sub Total- - - - - - - - - - - - - - NA Arts & Culture 0404 Morris PAC 101 10,888 86,733 - - - - - - - - - - 97,621 965,000 10% 0405 Palais Royale 101 26,265 9,345 - - - - - - - - - - 35,610 358,902 10% xxx xxx- NA Sub Total 37,153 96,078 - - - - - - - - - - 133,232 1,323,902 10% General Fund Revenue Total 1,244,191 1,371,784 - - - - - - - - - - 2,615,976 58,587,268 4% 2017-02 Financial Report - Rev enue Summar y Page 6 of 25 City of South Bend Period Ending:February 28, 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 - - - - - - - - - - 360,172 9,973,007 4% 1100 Administration 201 3,787 3,548 - - - - - - - - - - 7,335 43,600 17% 1101 Maintenance 201 28,074 104,996 - - - - - - - - - - 133,070 1,440,710 9% 1102 Golf Operations 201 1,356 402 - - - - - - - - - - 1,758 1,519,934 0% 1103 Recreation Division 201 22 810 - - - - - - - - - - 832 156,685 1% 1104 Potawatomi Zoo 201- - - - - - - - - - - - - - NA 1108 Graffiti Removal 201- - - - - - - - - - - - - 96,725 0% 1110 Marketing and Events 201- - - - - - - - - - - - - 570,471 0% Recreation Non Reverting 203 75,681 75,021 - - - - - - - - - - 150,702 1,381,787 11% East Race Waterway 271 1 1 - - - - - - - - - - 2 - NA Coveleski Stadium 401 68 69 - - - - - - - - - - 137 40,200 0% Zoo Endowment 403 37 38 - - - - - - - - - - 76 200 38% Park Non Reverting 405 4,566 174 - - - - - - - - - - 4,740 339,850 1% Sub Total 115,792 543,031 - - - - - - - - - - 658,823 15,563,169 4% Public Works Motor Vehicle Highway 202 317,873 1,223,876 - - - - - - - - - - 1,541,749 9,934,110 16% Central Services 222 675,986 688,080 - - - - - - - - - - 1,364,066 8,308,569 16% Central Services Capital 224 84 72 - - - - - - - - - - 157 287,600 0% Local Roads & Streets 251 106,827 88,499 - - - - - - - - - - 195,326 1,344,000 15% Local Road & Bridge Grant 265- 1,000,000 - - - - - - - - - - 1,000,000 - NA Project ReLeaf 655 37,450 37,428 - - - - - - - - - - 74,878 444,556 17% Sub Total 1,138,220 3,037,955 - - - - - - - - - - 4,176,176 20,318,835 21% Public Works Solid Waste Solid Waste Operations 610 445,931 471,682 - - - - - - - - - - 917,613 5,782,675 16% Solid Waste Capital 611 179 240 - - - - - - - - - - 419 835,813 0% Sub Total 446,110 471,922 - - - - - - - - - - 918,032 6,618,488 14% Public Works Water Utility 0000 Water Works Revenues 620 973,972 948,744 - - - - - - - - - - 1,922,716 15,080,627 13% 0630 Water Leak Insurance 620 81,303 81,237 - - - - - - - - - - 162,540 1,173,361 14% 0660 Clay Water 620 72,507 69,573 - - - - - - - - - - 142,079 1,265,346 11% Waterworks Capital 622 1,942 1,950 - - - - - - - - - - 3,892 15,000 26% Waterworks Construction 623- - - - - - - - - - - - - - NA Waterworks Deposit 624 1,159 1,174 - - - - - - - - - - 2,333 15,000 16% Waterworks Sinking 625 164,824 164,289 - - - - - - - - - - 329,113 2,054,891 16% Waterworks Bond Reserve 626 1,154 1,073 - - - - - - - - - - 2,227 16,000 14% Waterworks Debt Reserve 629 153,121 1,895 - - - - - - - - - - 155,016 97,500 159% Sub Total 1,449,981 1,269,935 - - - - - - - - - - 2,719,916 19,717,725 14% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 54,941 54,328 - - - - - - - - - - 109,269 621,788 18% 0000 Wastewater Revenues 641 3,044,674 2,968,092 - - - - - - - - - - 6,012,766 34,932,744 17% 0621 Sewer Department 641- 1,261 - - - - - - - - - - 1,261 2,500 50% 0625 Concrete Crew 641- 3,040 - - - - - - - - - - 3,040 74,500 4% 0630 Wastewater Operations 641- - - - - - - - - - - - - - NA 0631 Organic Resources 641- - - - - - - - - - - - - - NA 0650 Clay Sewage 641 177,865 174,732 - - - - - - - - - - 352,597 2,162,160 16% Sewage Capital 642 5,472 404,555 - - - - - - - - - - 410,026 4,487,000 9% Sewage Reserve 643 3,481 3,535 - - - - - - - - - - 7,015 53,721 13% Sewer Bond 2007 647- - - - - - - - - - - - - - NA Sewage Bond Sinking 649 763,195 1,184 - - - - - - - - - - 764,378 9,177,024 8% Sewer Bond 2007B 651- - - - - - - - - - - - - - NA Sewage Works DS Reserve 653- 955 - - - - - - - - - - 955 4,400 22% 2010 CSO Net Sewer Bond 658- - - - - - - - - - - - - - NA 2011 Sewer Bond 659 41 39 - - - - - - - - - - 80 - NA 2012 Sewer Bond 661 2,379 2,201 - - - - - - - - - - 4,580 50,000 9% 2013A Sewer Refund Bonds 664- - - - - - - - - - - - - - NA 2015 Sewer Refund Bonds 666- - - - - - - - - - - - - - NA Sub Total 4,052,047 3,613,922 - - - - - - - - - - 7,665,969 51,565,837 15% 2017-02 Financial Report - Rev enue Summar y Page 7 of 25 City of South Bend Period Ending:February 28, 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 - - - - - - - - - - 13,412 36,000 37% Curfew Violations 218 9 35 - - - - - - - - - - 44 1,000 4% Law Enforcement Education 220 31,608 16,002 - - - - - - - - - - 47,610 221,500 21% Public Safety LOIT 249 622,980 622,745 - - - - - - - - - - 1,245,725 7,473,618 17% Excess Welfare Public Safety 252- - - - - - - - - - - - - - NA Police Take Home Vehicle 278 561 575 - - - - - - - - - - 1,136 126,200 1% Police Block Grant 280 3 3 - - - - - - - - - - 6 - NA Police Grants 292- - - - - - - - - - - - - - NA Police Academy 294 5,456 4,561 - - - - - - - - - - 10,017 22,500 45% COPS More Grants 295 1,055 36,332 - - - - - - - - - - 37,386 92,000 41% Drug Enforcement 299 149 162 - - - - - - - - - - 311 32,000 1% K-9 Unit 705 2 2 - - - - - - - - - - 4 2,020 0% Sub Total 672,099 683,553 - - - - - - - - - - 1,355,651 8,006,838 17% Public Safety - Fire Emergency Telephone System 244- - - - - - - - - - - - - - NA EMS Capital 287 2,726 1,801,174 - - - - - - - - - - 1,803,900 1,285,000 140% EMS Operating Fund 288 181,987 557,555 - - - - - - - - - - 739,542 6,350,012 12% Hazmat 289 19 20 - - - - - - - - - - 40 10,000 0% River Rescue 291 114 16,307 - - - - - - - - - - 16,421 45,500 36% Sub Total 184,846 2,375,057 - - - - - - - - - - 2,559,902 7,690,512 33% Department of Community Investment Studebaker/Oliver 209 25,242 626 - - - - - - - - - - 25,868 104,000 25% State Grant 210 242 268 - - - - - - - - - - 510 73,512 1% DCI Operating 211 10,748 394,129 - - - - - - - - - - 404,877 2,291,309 18% 0000 Dept. of Community Investment 212 310,284 201,138 - - - - - - - - - - 511,423 3,348,000 15% xxx Programs 212 93,743 - - - - - - - - - - - 93,743 - NA 0000 Economic Revenue Bond 281 21 21 - - - - - - - - - - 42 200 21% Sub Total 440,280 596,182 - - - - - - - - - - 1,036,462 5,817,021 18% Parking Garages 0000 Parking Garage Revenue 601 284 671 - - - - - - - - - - 955 4,000 24% 0460 Main Street 601 25,906 27,933 - - - - - - - - - - 53,839 267,966 20% 0462 Leighton Plaza 601 58,466 24,331 - - - - - - - - - - 82,797 487,484 17% 0463 Enforcement 601 4,969 4,623 - - - - - - - - - - 9,592 80,000 12% 0464 Wayne Street 601 30,977 20,895 - - - - - - - - - - 51,872 241,961 21% 0465 Eddy Street Commons 601- - - - - - - - - - - - - 15,900 0% Sub Total 120,601 78,453 - - - - - - - - - - 199,054 1,097,311 18% Capital / Debt Service Hall of Fame 313 50 6 - - - - - - - - - - 56 938,228 0% COIT 404 913,313 879,279 - - - - - - - - - - 1,792,592 10,680,407 17% Cum Capital Development 406 357 436 - - - - - - - - - - 793 476,500 0% Cum Capital Improvement 407 150,226 294 - - - - - - - - - - 150,520 435,000 35% EDIT 408 1,041,459 1,981,678 - - - - - - - - - - 3,023,137 11,733,257 26% UDAG 410 445 416 - - - - - - - - - - 860 6,110 14% Major Moves 412 1,774 598,393 - - - - - - - - - - 600,167 1,502,472 40% Morris PAC Improvement 416 436 12,664 - - - - - - - - - - 13,100 104,000 13% CRED 434- - - - - - - - - - - - - - NA Palais Historic Preservation 450 1,907 187 - - - - - - - - - - 2,094 17,100 12% Hall of Fame Capital 677 372 378 - - - - - - - - - - 750 5,000 15% SB Building Corp 755- 1,326,786 - - - - - - - - - - 1,326,786 2,643,214 50% Parks Bond Debt Svc 757- 65,162 - - - - - - - - - - 65,162 391,482 17% xxx xxx xxx- - - - - - - - - - - NA Sub Total 2,110,340 4,865,679 - - - - - - - - - - 6,976,019 28,932,770 24% 2017-02 Financial Report - Rev enue Summar y Page 8 of 25 City of South Bend Period Ending:February 28, 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 - - - - - - - - - - 15,417 60,000 26% Excess Levy 103- - - - - - - - - - - - - - NA Gift, Donation, Bequest 217 50,900 1,097 - - - - - - - - - - 51,996 18,800 277% Unsafe Building 219 11,928 152,225 - - - - - - - - - - 164,153 793,757 21% Landlord Registration 221 2,260 270 - - - - - - - - - - 2,530 1,000 253% Loss Recovery 227 730 741 - - - - - - - - - - 1,471 1,000 147% LOIT 2016 Special Distribution 257- 6,605 - - - - - - - - - - 6,605 1,318,000 1% Human Rights 258 91,498 4,790 - - - - - - - - - - 96,287 165,040 58% Morris Palais Marketing 273 34 582 - - - - - - - - - - 617 18,300 3% 311 Call Center 279 430,621 430,621 - - - - - - - - - - 861,242 5,197,431 17% Professional Sports Development 377 80,547 318 - - - - - - - - - - 80,865 732,000 11% 1201 Code Enforcement 600 12,749 366,188 - - - - - - - - - - 378,936 1,810,451 21% 1207 Animal Control 600 4,706 187,306 - - - - - - - - - - 192,012 789,865 24% 1306 Building Operations 600 92,341 88,523 - - - - - - - - - - 180,864 1,368,350 13% Century Center 670 910,931 211,677 - - - - - - - - - - 1,122,607 4,194,311 27% Century Center Capital 671 74 66 - - - - - - - - - - 140 750 19% Century Center Energy Saving 672 6 4 - - - - - - - - - - 9 192,297 0% Sub Total 1,696,966 1,458,786 - - - - - - - - - - 3,155,752 16,661,352 19% Business Insurance 0000 Business Insurance Revenues 226 246,679 247,476 - - - - - - - - - - 494,155 3,527,591 14% 0418 Workers Compensation 226 619 35,123 - - - - - - - - - - 35,742 30,000 119% Sub Total 247,298 282,599 - - - - - - - - - - 529,897 3,557,591 15% Fiduciary Trust & Agency Fire Pension 701 335 84 - - - - - - - - - - 419 5,217,138 0% Police Pension 702 2,386 1,224 - - - - - - - - - - 3,610 6,136,500 0% Employee Benefits 711 1,511,154 1,463,664 - - - - - - - - - - 2,974,818 17,795,850 17% Unemployment Comp 713 217 214 - - - - - - - - - - 431 83,000 1% City Cemetery Trust 730 22 22 - - - - - - - - - - 44 200 22% Equipment / Vehicle Leasing 750- 298 - - - - - - - - - - 298 5,500,000 0% Parks Bond Capital 751- 369 - - - - - - - - - - 369 7,500 5% Smart Street Bond Capital 753- 604 - - - - - - - - - - 604 17,000 4% Sub Total 1,514,115 1,466,478 - - - - - - - - - - 2,980,593 34,757,188 9% Civil City Revenues 15,432,886 22,115,337 - - - - - - - - - - 37,548,223 278,891,905 13% Tax Increment Financing TIF River West - Airport 324 78,976 118,077 - - - - - - - - - - 197,053 22,763,295 1% TIF Central Development 420- - - - - - - - - - - - - - NA TIF West Washington 422 1,411 1,497 - - - - - - - - - - 2,908 436,000 1% TIF Leighton Plaza 425 10,467 14,196 - - - - - - - - - - 24,663 197,014 13% TIF Medical Service 426- - - - - - - - - - - - - - NA TIF River East DEV (NE)429 5,927 6,699 - - - - - - - - - - 12,626 3,057,000 0% TIF Southside 430 3,108 564,649 - - - - - - - - - - 567,757 3,881,127 15% TIF Erskine Village 432 3,646 3,484 - - - - - - - - - - 7,130 6,000 119% TIF Douglas Road 435 77 120 - - - - - - - - - - 197 327,858 0% TIF River East RES (NE RE)436 442 - - - - - - - - - - - 442 3,300,903 0% Sub Total 104,055 708,721 - - - - - - - - - - 812,775 33,969,197 2% 2017-02 Financial Report - Rev enue Summar y Page 9 of 25 City of South Bend Period Ending:February 28, 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 - - - - - - - - - - 13 135 10% Certified Technology Park 439 1,614 1,641 - - - - - - - - - - 3,255 - NA Airport Urban Enterprise Zone 454 288 292 - - - - - - - - - - 580 3,900 15% Industrial Revolving 754- - - - - - - - - - - - - 210,000 0% Sub Total 1,908 1,940 - - - - - - - - - - 3,849 214,035 2% Debt Service Airport Debt Reserve 2003 315 780 792 - - - - - - - - - - 1,572 14,000 11% Coveleski Bond Debt Reserve 317 385 391 - - - - - - - - - - 776 5,000 16% Central Development reserve 328 1,303 1,323 - - - - - - - - - - 2,626 15,000 18% SB Redevelopment Authority 752- 772,669 - - - - - - - - - - 772,669 3,868,169 20% Smart Streets Debt Svc 756- 179 - - - - - - - - - - 179 855,784 0% Erskine Village Debt. Svc 758- 3,961,697 - - - - - - - - - - 3,961,697 3,960,668 100% Sub Total 2,468 4,737,051 - - - - - - - - - - 4,739,519 8,718,621 54% Redevelopment Commission 108,431 5,447,712 - - - - - - - - - - 5,556,143 42,901,853 13% City Operations Total 15,541,356 27,563,049 - - - - - - - - - - 43,104,405 321,793,758 13% Revenue report 15,541,356 27,563,049 0 0 0 0 0 0 0 0 0 0 43,104,406 321,793,758 (0)0 0 0 0 0 0 0 0 0 0 0(0)0 2017-02 Financial Report - Rev enue Summar y Page 10 of 25 City of South Bend Period Ending:February 28, 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-02 Financial Report - Property Tax Revenue Page 11 of 25 City of South Bend Period Ending:February 28, 2017 Property Tax Revenue 2014 Tax Pay 2015 Fund Fund #Levy Estimated Distribution 1 Distribution 2 Distribution 3 Distribution 4 Levy Per County Collection Projected 6/8/2015 6/16/2015 10/30/2015 12/15/2015 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate City General Fund 101 38,619,247.00 0.95 36,688,284.65 13,463,468.56 7,216,350.23 2,012,110.57 14,657,458.45 37,349,387.81 1,269,859.19 96.71% Parks & Recreation 201 7,742,127.00 0.95 7,355,020.65 2,699,065.71 1,446,685.42 403,374.41 2,938,428.80 7,487,554.34 254,572.66 96.71% College Football Hall of Fame 313 937,076.00 0.95 890,222.20 - 501,784.88 - 404,478.29 906,263.17 30,812.83 96.71% Cumulative Capital District 406 443,304.00 0.95 421,138.80 154,544.81 82,835.23 23,096.67 168,250.41 428,727.12 14,576.88 96.71% Fire Pension 701- 0.95 - - - - - - - - Police Pension 702- 0.95 - - - - - - - - Total - City 47,741,754.00 45,354,666.30 16,317,079.08 9,247,655.76 2,438,581.65 18,168,615.95 46,171,932.44 1,569,821.56 96.71% Tax Increment Financing Airport TIF District 324 17,709,737.84 0.95 16,824,250.95 - 9,396,167.91 - 6,897,072.02 16,293,239.93 1,416,497.91 92.00% South Bend Central TIF District 420- 0.95 - - - - - - - West Washington TIF District 422 512,917.39 0.95 487,271.52 - 195,865.56 - 207,045.03 402,910.59 110,006.80 78.55% Central Medical TIF District 426- 0.95 - - - - - - - Northeast Residential TIF District 436 3,273,328.42 0.95 3,109,662.00 - 1,663,572.10 - 1,466,109.03 3,129,681.13 143,647.29 95.61% Southside TIF District #1 430 2,504,494.11 0.95 2,379,269.40 - 1,298,974.33 - 906,847.80 2,205,822.13 298,671.98 88.07% Erskine Commons TIF District #2 431- 0.95 - - - - - - - Erskine Village TIF District #3 432 19,182.73 0.95 18,223.59 - 11,490.26 - 7,692.47 19,182.73 - 100.00% Douglas Road TIF District 435 327,887.96 0.95 311,493.56 - 163,943.98 - 106,813.87 270,757.85 57,130.11 82.58% Northeast TIF 429 2,743,819.42 0.95 2,606,628.45 - 1,391,012.32 - 1,030,295.80 2,421,308.12 322,511.30 88.25% Airport Urban Enterprise Zone 454- 0.95 - - - - - - - - Other xxx- - - - - - Total - Tax Increment Financing 27,091,367.87 25,736,799.48 - 14,121,026.46 - 10,621,876.02 24,742,902.48 2,348,465.39 91.33% Grand Total 74,833,121.87 71,091,465.78 16,317,079.08 23,368,682.22 2,438,581.65 28,790,491.97 70,914,834.92 3,918,286.95 94.76% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 6/8/15 2 Distribution 2 - Issued by St. Joseph County on 6/16/15 3 Distribution 3 - Issued by St. Joseph County on 10/30/15 Distribution 4 - Issued by St. Joseph County on 12/15/15 2017-02 Financial Report - Property Tax Revenue Page 12 of 25 City of South Bend Period Ending:February 28, 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 - - - - - - - - - - 116,935 872,923 13% 0104 311 Call Center 101- - - - - - - - - - - - - - NA 0201 Clerk 101 38,451 43,206 - - - - - - - - - - 81,656 536,216 15% 0301 Common Council 101 33,451 49,728 - - - - - - - - - - 83,179 571,148 15% 0302 WNIT Contract 101- - - - - - - - - - - - - 43,000 0% 0401 Administration and Finance 101 184,278 178,933 - - - - - - - - - - 363,211 2,476,351 15% 0501 Legal Department 101 87,585 86,783 - - - - - - - - - - 174,368 1,158,567 15% Sub Total 402,773 416,575 - - - - - - - - - - 819,348 5,658,205 14% Public Works 0602 Engineering 101 81,736 88,219 - - - - - - - - - - 169,955 1,445,157 12% Sub Total 81,736 88,219 - - - - - - - - - - 169,955 1,445,157 12% Public Safety 0801 Police 101 2,401,801 2,081,566 - - - - - - - - - - 4,483,368 29,668,433 15% 0805 Police -PS LOIT funded 101- - - - - - - - - - - - - - NA 0802 Police Communications 101- - - - - - - - - - - - - - NA 0901 Fire 101 1,586,894 1,525,036 - - - - - - - - - - 3,111,930 20,968,466 15% 0905 Fire-PS LOIT funded 101- - - - - - - - - - - - - - NA Sub Total 3,988,695 3,606,602 - - - - - - - - - - 7,595,298 50,636,899 15% Code Enforcement 1201 Code 101- - - - - - - - - - - - - NA Sub Total- - - - - - - - - - - - - - NA Arts & Culture 0404 Morris PAC 101 74,731 80,199 - - - - - - - - - - 154,930 1,271,039 12% 0405 Palais Royale 101 24,999 30,061 - - - - - - - - - - 55,060 530,200 10% Sub Total 99,730 110,260 - - - - - - - - - - 209,990 1,801,239 12% Human Rights 1008 Human Rights 101 37,821 40,148 - - - - - - - - - - 77,969 425,805 18% Sub Total 37,821 40,148 - - - - - - - - - - 77,969 425,805 18% General Fund Expenditure Total 4,610,756 4,261,804 - - - - - - - - - - 8,872,560 59,967,305 15% 2017-02 Financial Report - Expe nditu re Su mmary Page 13 of 25 City of South Bend Period Ending:February 28, 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 - - - - - - - - - - 235,529 1,468,296 16% 1101 Maintenance 201 399,021 416,933 - - - - - - - - - - 815,953 6,588,961 12% 1102 Golf Operations 201 54,483 75,381 - - - - - - - - - - 129,864 1,638,575 8% 1103 Recreation Division 201 165,251 145,109 - - - - - - - - - - 310,360 2,153,817 14% 1104 Potawatomi Zoo 201 355,692 7,425 - - - - - - - - - - 363,117 704,464 52% 1106 Potawatomi Greenhouse 201 5,013 4,555 - - - - - - - - - - 9,568 54,408 18% 1108 Graffiti Removal 201 13,483 12,628 - - - - - - - - - - 26,111 97,861 27% 1110 Marketing and Events 201 16,583 45,412 - - - - - - - - - - 61,995 953,588 7% Recreation Non Reverting 203 51,478 47,722 - - - - - - - - - - 99,200 1,599,683 6% East Race Waterway 271- - - - - - - - - - - - - 1,367 0% Coveleski Stadium 401- - - - - - - - - - - - - 30,000 0% Zoo Endowment 403- - - - - - - - - - - - - 49,688 0% Park Non Reverting 405 45,874 17,251 - - - - - - - - - - 63,125 228,024 28% Sub Total 1,254,532 860,290 - - - - - - - - - - 2,114,822 15,568,732 14% Public Works Motor Vehicle Highway 202 919,033 515,568 - - - - - - - - - - 1,434,601 9,686,533 15% Curb and Sidewalk 202 150,920 40,047 - - - - - - - - - - 190,967 1,878,998 10% Central Services 222 730,352 648,645 - - - - - - - - - - 1,378,997 8,554,643 16% Central Services Capital 224 10,575 4,009 - - - - - - - - - - 14,585 326,025 4% Local Roads & Streets 251 209,999 4,801 - - - - - - - - - - 214,800 2,086,544 10% Project ReLeaf 655 15,049 90,567 - - - - - - - - - - 105,617 525,416 20% Sub Total 2,035,929 1,303,638 - - - - - - - - - - 3,339,567 23,058,159 14% Public Works Solid Waste Solid Waste Operations 610 489,623 312,159 - - - - - - - - - - 801,782 5,662,910 14% Solid Waste Capital 611 286,902 146,712 - - - - - - - - - - 433,613 1,135,613 38% Sub Total 776,525 458,871 - - - - - - - - - - 1,235,396 6,798,523 18% Public Works Water Utility 0630 Water Leak Insurance 620 43,958 41,864 - - - - - - - - - - 85,822 1,035,000 8% 0640 Water Works 620 1,417,876 1,256,524 - - - - - - - - - - 2,674,400 16,688,754 16% 0660 Clay Water 620- - - - - - - - - - - - - 3,500 0% Waterworks Capital 622 111,938 177,777 - - - - - - - - - - 289,715 1,414,466 20% Waterworks Deposit 624 874 1,174 - - - - - - - - - - 2,048 15,000 14% Waterworks Sinking 625 815 289 - - - - - - - - - - 1,104 2,054,891 0% Waterworks Bond Reserve 626- - - - - - - - - - - - - 16,000 0% Waterworks Debt Reserve 629 1,394 1,895 - - - - - - - - - - 3,289 23,000 14% Sub Total 1,576,855 1,479,523 - - - - - - - - - - 3,056,378 21,250,611 14% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 48,400 46,390 - - - - - - - - - - 94,790 534,509 18% 0621 Sewer Repair 641 517,647 434,598 - - - - - - - - - - 952,245 9,248,687 10% 0625 Concrete Crew 641 30,239 20,767 - - - - - - - - - - 51,005 474,389 11% 0630 Wastewater Operations 641 2,358,990 1,454,679 - - - - - - - - - - 3,813,669 33,209,563 11% 0631 Organic Resources 641 124,773 126,931 - - - - - - - - - - 251,704 1,608,946 16% 0650 Clay Sewage 641- 5 - - - - - - - - - - 5 750 1% Sewage Capital 642 1,298,328 387,989 - - - - - - - - - - 1,686,317 7,640,455 22% Sewage Reserve 643 2,625 3,535 - - - - - - - - - - 6,160 30,000 21% Sewage Bond Sinking 649 1,000 500 - - - - - - - - - - 1,500 9,163,754 0% 2011 Sewer Bond 659- - - - - - - - - - - - - 11,617 0% 2012 Sewer Bond 661 3,000 166,950 - - - - - - - - - - 169,950 3,010,364 6% 2013A Sewer Bond 664- - - - - - - - - - - - - 4,550 0% 2014 Sewer Bond 665- - - - - - - - - - - - - - NA 2015 Sewer Bond 666- - - - - - - - - - - - - 9,205 0% Sub Total 4,385,001 2,642,343 - - - - - - - - - - 7,027,344 64,946,789 11% 2017-02 Financial Report - Expe nditu re Su mmary Page 14 of 25 City of South Bend Period Ending:February 28, 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 - - - - - - - - - - 64,609 788,422 8% Emergency Telephone System 244- - - - - - - - - - - - - - NA Public Safety LOIT 249 466,245 487,781 - - - - - - - - - - 954,027 7,462,645 13% Excess Welfare Public Safety 252- - - - - - - - - - - - - 8 0% LOIT 2016 Special Distribution 257 21,360 21,991 - - - - - - - - - - 43,351 2,757,457 2% Police Take Home Vehicle 278- 972 - - - - - - - - - - 972 10,000 10% Police Grants 292 2,796 1,266 - - - - - - - - - - 4,062 10,805 38% Police Academy 294 162 283 - - - - - - - - - - 445 22,500 2% COPS More Grants 295 10,980 3,436 - - - - - - - - - - 14,416 155,467 9% Drug Enforcement 299 11,242 23,096 - - - - - - - - - - 34,337 196,337 17% K-9 Unit 705- - - - - - - - - - - - - 2,020 0% Sub Total 557,416 558,803 - - - - - - - - - - 1,116,218 11,442,661 10% Public Safety - Fire EMS Capital 287 235,792 150,604 - - - - - - - - - - 386,396 2,700,377 14% EMS Operating Fund 288 438,601 356,431 - - - - - - - - - - 795,032 5,980,914 13% Hazmat 289 430 255 - - - - - - - - - - 685 10,431 7% River Rescue 291 1,443 231 - - - - - - - - - - 1,674 89,349 2% xxx xxx xxx- - - - - - - - - - - - - NA Sub Total 676,266 507,520 - - - - - - - - - - 1,183,787 8,781,071 13% Department of Community Investment Studebaker/Oliver 209 70,702 4,592 - - - - - - - - - - 75,294 539,393 14% State Grant 210- - - - - - - - - - - - - 509,757 0% DCI Operating 211 197,318 171,937 - - - - - - - - - - 369,255 2,650,376 14% 1001 Dept. of Community Investment 212 575,173 100,654 - - - - - - - - - - 675,826 5,455,838 12% 1003 Administration 212- - - - - - - - - - - - - - NA xxx Programs 212- - - - - - - - - - - - - - NA Sub Total 843,192 277,183 - - - - - - - - - - 1,120,375 9,155,364 12% Parking Garages 0400 General Administration 601- - - - - - - - - - - - - - NA 0460 Main Street 601 10,017 11,799 - - - - - - - - - - 21,817 261,894 8% 0462 Leighton Plaza 601 20,044 21,722 - - - - - - - - - - 41,766 596,368 7% 0463 Enforcement 601 7,858 7,238 - - - - - - - - - - 15,096 128,675 12% 0464 Wayne Street 601 12,364 13,889 - - - - - - - - - - 26,253 244,417 11% 0465 Eddy Street Commons 601- - - - - - - - - - - - - 15,900 0% Sub Total 50,284 54,648 - - - - - - - - - - 104,932 1,247,254 8% Capital / Debt Service Hall of Fame 313 635,000 - - - - - - - - - - - 635,000 1,268,999 50% COIT 404 1,172,640 1,270,520 - - - - - - - - - - 2,443,159 11,921,593 20% Cum Capital Development 406 112,650 27,896 - - - - - - - - - - 140,546 476,500 29% Cum Capital Improvement 407 185,125 - - - - - - - - - - - 185,125 372,250 50% EDIT 408 697,093 1,928,675 - - - - - - - - - - 2,625,768 11,501,484 23% UDAG 410 30,702 - - - - - - - - - - - 30,702 126,144 24% Major Moves 412 543 - - - - - - - - - - - 543 2,470,708 0% Morris PAC Improvement 416 408 - - - - - - - - - - - 408 106,144 0% CRED 434- - - - - - - - - - - - - - NA Palais Historic Preservation 450- - - - - - - - - - - - - 5,000 0% Hall of Fame Capital 677 3,866 14,859 - - - - - - - - - - 18,725 81,091 23% SB Building Corp 755- - - - - - - - - - - - - 2,643,214 0% Parks Bond Debt 757- - - - - - - - - - - - - 391,482 0% Sub Total 2,838,027 3,241,949 - - - - - - - - - - 6,079,976 31,364,609 19% 2017-02 Financial Report - Expe nditu re Su mmary Page 15 of 25 City of South Bend Period Ending:February 28, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Other Miscellaneous Excess Levy 103- - - - - - - - - - - - - - NA Gift, Donation, Bequest 217 72,000 900 - - - - - - - - - - 72,900 38,700 188% Unsafe Building 219 80,336 43,005 - - - - - - - - - - 123,341 902,746 14% Landlord Registration 221 5 5 - - - - - - - - - - 10 1,000 1% Loss Recovery 227- 3,345 - - - - - - - - - - 3,345 598,675 1% Human Rights 258 17,100 3,192 - - - - - - - - - - 20,293 201,773 10% Morris Palais Marketing 273 2,798 - - - - - - - - - - - 2,798 21,675 13% 311 Call Center 279 325,330 207,081 - - - - - - - - - - 532,410 5,205,034 10% Professional Sports Development 377 467,640 800 - - - - - - - - - - 468,440 827,955 57% 1201 Code Enforcement 600 128,453 94,686 - - - - - - - - - - 223,139 1,625,378 14% 1207 Animal Control 600 68,101 59,652 - - - - - - - - - - 127,753 790,517 16% 1209 Illegal Dumping Crew 600- - - - - - - - - - - - - - NA 1306 Building Operations 600 110,343 98,842 - - - - - - - - - - 209,185 1,361,925 15% Century Center 670 282,027 349,477 - - - - - - - - - - 631,504 4,194,310 15% Century Center Capital 671- - - - - - - - - - - - - - NA Century Center Energy Saving 672- - - - - - - - - - - - - 192,297 0% Sub Total 1,554,131 860,986 - - - - - - - - - - 2,415,117 15,961,985 15% Business Insurance 0403 Self Funded Liability Ins 226 17,866 17,273 - - - - - - - - - - 35,138 235,471 15% 0412 Liability Insurance 226 45,537 23,578 - - - - - - - - - - 69,114 2,034,051 3% 0417 Business Insurance 226 45,354 - - - - - - - - - - - 45,354 595,678 8% 0418 Workers Compensation 226 119,520 87,561 - - - - - - - - - - 207,081 722,386 29% Sub Total 228,276 128,412 - - - - - - - - - - 356,688 3,587,586 10% Fiduciary Trust & Agency Fire Pension 701 388,455 396,509 - - - - - - - - - - 784,964 5,098,269 15% Police Pension 702 513,053 511,187 - - - - - - - - - - 1,024,240 6,423,889 16% Employee Benefits 711 1,060,085 1,343,141 - - - - - - - - - - 2,403,227 17,803,200 13% Unemployment Comp 713 6,038 8,041 - - - - - - - - - - 14,079 84,105 17% City Cemetery Trust 730- - - - - - - - - - - - 6,000 0% Equipment / Vehicle Leasing 750- 983,042 - - - - - - - - - - 5,500,000 0% Parks Bond Capital 751- 63,156 - - - - - - - - - - 3,500,000 0% Smart Street Bond 753- 986,652 - - - - - - - - - - 10,000,000 0% xxx xxx xxx NA Sub Total 1,967,632 4,291,727 - - - - - - - - - - 6,259,359 48,415,463 13% Civil City Expenditure 23,354,822 20,927,696 - - - - - - - - - - 44,282,518 321,546,112 14% Tax Increment Financing TIF River West - Airport 324 4,348,398 123,050 - - - - - - - - - - 4,471,448 37,618,887 12% TIF West Washington 422- - - - - - - - - - - - - 1,428,292 0% TIF Leighton Plaza 425 5,141 9,302 - - - - - - - - - - 14,443 158,166 9% TIF River East DEV (NE)429 27,144 45,644 - - - - - - - - - - 72,788 10,602,696 1% TIF Southside 430 146,124 12,530 - - - - - - - - - - 158,654 6,917,426 2% TIF Erskine Village 432 3,961,667 - - - - - - - - - - - 3,961,667 4,848,795 82% TIF Douglas Road 435- 150,000 - - - - - - - - - - 150,000 344,216 44% TIF River East RES (NE RE)436 1,236,500 446,589 - - - - - - - - - - 1,683,089 3,430,231 49% Sub Total 9,724,973 787,115 - - - - - - - - - - 10,512,088 65,348,709 16% 2017-02 Financial Report - Expe nditu re Su mmary Page 16 of 25 City of South Bend Period Ending:February 28, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Redevelopment Funds Administration 433- - - - - - - - - - - - - 4,500 0% Certified Technology Park 439- - - - - - - - - - - - NA Airport Urban Enterprise Zone 454- - - - - - - - - - - - - 50,000 0% Industrial Revolving 754- - - - - - - - - - - - - 157,000 0% Sub Total- - - - - - - - - - - - - 211,500 0% Debt Service Airport Debt Reserve 2003 315 588 792 - - - - - - - - - - 1,380 14,000 10% Central Development reserve 328 983 1,323 - - - - - - - - - - 2,306 15,000 15% SB Redevelopment Authority 752- 735,236 - - - - - - - - - - 735,236 3,868,169 19% Smart Streets Debt Svc 756- - - - - - - - - - - - - 855,784 0% Erskine Village Debt Svc 758- 561,229 - - - - - - - - - - 561,229 4,521,668 12% xxx xxx xxx NA Sub Total 1,571 1,298,580 - - - - - - - - - - 1,300,151 9,274,621 14% Redevelopment Commission 9,726,545 2,085,695 - - - - - - - - - - 11,812,239 74,834,830 16% City Operations Total 33,081,366 23,013,391 - - - - - - - - - - 56,094,757 396,367,179 14% Expenditure report 33,081,366 23,013,391 0 0 0 0 0 0 0 0 0 0 56,094,757 396,367,179 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2017-02 Financial Report - Expe nditu re Su mmary Page 17 of 25 City of South Bend Period Ending:February 28, 2017 Debt Schedule Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at 2017 Princip al 2017 Inter est 2017 Debt a t 2017 Total D eb t In strumen t D ebt Pur po se Issue Refunding M aturity F un d 1st 2nd 3rd 4th Is sue 12/3 1/20 16 Paym ents Payme nt Addit ion 12/31/20 17 D ebt P aymen ts Civil City Debt Bond Deb t A mort s ch # 3 1 CEDIT Bond 199 7 200 6 20 17 40 8 2/1 8/1--11,870,00 0.00 430,000.00 4 30,000.00 9,932.50 0.00 0.00 439,93 2.50 3 6 Sout h B end Building C orporation Pu bl ic W orks Building 200 1 201 0 20 21 40 4/649 2/1 8/1--9,250,00 0.00 2,755,000.00 5 75,000.00 95,994.00 0.00 2,180,000.00 670,99 4.00 2 5 Wat er Works Impr ovemen ts W ater W orks 200 2 201 2 20 23 62 5 1/1 7/1--5,975,00 0.00 2,380,000.00 3 75,000.00 47,600.00 0.00 2,005,000.00 422,60 0.00 3 9 Sout h B end Building C orporation Fire HQ / P ol ice H Q 200 3 201 2 20 23 40 4/324 2/1 8/1--21,335,00 0.00 8,885,000.00 1,2 40,000.00 325,740.00 0.00 7,645,000.00 1,565,74 0.00 2 4 Wat er Works Impr ovemen ts W ater W orks 200 6 20 27 62 5 1/1 7/1--4,710,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6 2 Cen tury Center Spec i al Tax Bonds C entury Center 200 8 20 28 42 0 5/1 11/1--4,655,00 0.00 3,175,000.00 3 00,000.00 85,812.50 0.00 2,875,000.00 385,81 2.50 6 9 Wat er Works Impr ovemen ts W ater W orks 200 9 20 30 62 5 1/1 7/1--5,380,00 0.00 4,325,000.00 2 40,000.00 239,938.00 0.00 4,085,000.00 479,93 8.00 7 0 Sewage W orks Reve nue Bon ds - 2009 Sewag e W orks 200 9 20 28 64 9 6/1 12/1--3,297,00 0.00 2,249,643.00 1 62,472.00 63,214.00 0.00 2,087,171.00 225,68 6.00 8 0 2 010 Sewage W orks Re v enue Bonds Sewag e W orks 201 0 20 30 64 9 6/1 12/1--9,345,00 0.00 7,145,000.00 3 95,000.00 298,617.50 0.00 6,750,000.00 693,61 7.50 9 3 Sewage W orks Reve nue Bon ds 201 1 Sewag e W orks 201 1 20 31 64 9 6/1 12/1--21,500,00 0.00 17,295,000.00 8 95,000.00 654,300.00 0.00 16,400,000.00 1,549,30 0.00 9 9 2 012 W ater Wo rks Reven ue Bond W ater W orks 201 2 20 33 62 5 1/1 7/1--8,300,00 0.00 6,925,000.00 3 55,000.00 209,786.26 0.00 6,570,000.00 564,78 6.26 10 1 2 012 Sewage W orks Re v enue Bonds Sewag e W orks 201 2 20 32 64 9 6/1 12/1--25,000,00 0.00 20,890,000.00 1,0 60,000.00 486,680.00 0.00 19,830,000.00 1,546,68 0.00 10 5 2 013A Sewer Bon d Refunding Sewag e W orks 201 3 201 3 20 24 64 9 6/1 12/1--14,765,00 0.00 8,050,000.00 1,9 55,000.00 156,170.00 0.00 6,095,000.00 2,111,17 0.00 11 6 2 013 Building C orporation EMS / Fire D epar t ment 201 3 20 33 28 8 2/1 8/1--5,580,00 0.00 5,145,000.00 2 25,000.00 177,480.00 0.00 4,920,000.00 402,48 0.00 13 3 St. Joseph Cou nty PS AP St. J oseph County PSA P 201 4 20 34 40 8 Monthly 2,657,69 6.50 2,386,507.92 1 07,652.90 59,107.80 0.00 2,278,855.02 166,76 0.70 13 9 Cen tury Center En ergy Saving s Impro v ements at Century Ctr.201 5 20 31 67 2 5/1 11/1 4,167,89 7.00 4,145,312.00 46,606.00 144,690.68 0.00 4,098,706.00 191,29 6.68 14 1 Park s and Rec reation Bo nd Parks Improveme nts 201 5 20 35 40 8 2/1 8/1--5,605,00 0.00 5,295,000.00 2 10,000.00 172,256.26 0.00 5,085,000.00 382,25 6.26 14 5 Sewage W orks Reve nue Bon ds -20 15 Sewer Impr ovemen ts 201 5 20 25 64 9 6/1 12/1--27,440,00 0.00 24,965,000.00 2,5 30,000.00 499,300.00 0.00 22,435,000.00 3,029,30 0.00 15 6 2 016 W ater Wo rks Refu nding Bon ds R efunding 20 00 / 2 006 SRF 201 6 20 27 62 5 1/1 7/1--3,300,00 0.00 3,300,000.00 4 05,000.00 49,500.00 0.00 2,895,000.00 454,50 0.00 xxx Total Bond Debt 2 34,877,59 3.50 129,741,462.92 11,5 06,730.90 3,776,119.50 0.00 118,234,732.02 15,282,85 0.40 Loa ns Payab le 6 8 State R evolving F und W ater W orks Improvement 200 9 20 30 62 5 1/1 7/1--427,33 2.00 332,562.00 20,912.00 11,207.34 0.00 311,650.00 32,11 9.34 8 2 In terfu nd Loan 41 0 - UDAG 1st Sour c e/Marriott Garage 201 0 20 15 41 0 6/15 12/1 5--2,700,00 0.00 1,351,597.75 1 26,142.25 0.00 0.00 1,225,455.50 126,14 2.25 2 6 State R evolving F und W ater W orks Improvements 200 0 20 19 62 5 1/1 7/1--2,600,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 xxx Total Loans Pa yable 29,822,33 2.00 1,684,159.75 1 47,054.25 11,207.34 0.00 1,537,105.50 158,26 1.59 Ca pita l Leases 5 1 Ch ase LE D Equipmen t 200 7 20 17 10 1 1/1 7/1--1,531,57 3.00 194,320.02 1 94,319.97 6,259.69 0.00 0.05 200,57 9.66 8 9 Sun Trust Police, Parks, Bl dg vehicles 201 1 20 16 40 4/20 1/600 3/15 6/15 9/15 12/15 2,068,20 2.00 0.00 0.00 0.00 0.00 0.00 0.00 9 0 Cap ital One Public Fundin g Solid Was te Cont ai ners/Truc k s 201 1 20 16 61 1 3/15 6/15 9/15 12/15 207,43 2.00 0.00 0.00 0.00 0.00 0.00 0.00 9 1 GE Cap ital I nfor mation Techn ology Police Dept Copier 201 1 20 16 10 1 1/11 4/11 7/11 10/11 3,83 6.00 0.00 0.00 0.00 0.00 0.00 0.00 9 2 Key Finance IT Phone S ystem 201 1 20 16 40 4 1/15 1,444,99 5.97 0.00 0.00 0.00 0.00 0.00 0.00 9 4 Iko n Office Solu t ions Mayor Ric oh M P 2851 SP Copier 201 1 20 16 10 1 2/15 5/15 8/15 11/15 2,56 9.53 0.00 0.00 0.00 0.00 0.00 0.00 9 5 Sun Trust E quipme nt F in ance Parks-Golf C ars Lease 201 2 20 16 20 1 4/15 10/1 5--344,50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 9 7 Sun Trust E quipme nt F in ance Police Veh ic le s & Equ ipment 201 2 20 17 40 6 5/15 11/1 5--1,295,00 0.00 134,585.22 1 34,585.22 1,140.42 0.00 0.00 135,72 5.64 9 8 PNC Equipm ent F inance Pu bl ic W orks Vehicles Lease 201 2 20 17 20 2/64 1/640 5/15 11/1 5--945,67 4.38 97,793.51 97,793.52 735.98 0.00(0.01)98,52 9.50 10 0 PNC Equipm ent F inance Pu bl ic W orks Vehicles Lease 201 2 20 17 20 2/64 1/600/288 1/15 7/15--2,806,05 4.00 575,316.55 5 75,316.53 5,634.82 0.00 0.02 580,95 1.35 10 2 Iko n Office Solu t ions / Ricoh W astewater C opier 201 2 20 17 64 1 Monthly 1st 5,74 4.95 756.77 756.77 65.82 0.00 0.00 82 2.59 10 3 GE Cap ital I nfor mation Techn ology Fire Department Cop ie r 201 2 20 17 10 1 2/28 5/28 8/28 11/28 5,47 1.01 926.68 926.68 27.40 0.00 0.00 95 4.08 10 6 Ricoh U SA (N ew)C entra l Servi c es Copier 201 3 20 18 22 2 2/27 5/27 8/27 11/27 3,62 2.78 815.82 814.82 24.94 0.00 1.00 83 9.76 10 7 Ricoh U SA Street/Sewer Dept Copier 201 3 20 18 20 2/641 3/4 6/4 9/4 12/4 5,55 9.15 1,225.93 1,225.93 44.88 0.00 0.00 1,27 0.81 10 8 Ricoh U SA C ity Att orney C opier 201 3 20 18 10 1 2/12 5/12 8/12 11/12 5,55 9.15 1,232.73 1,231.73 39.06 0.00 1.00 1,27 0.79 10 9 Ricoh U SA Parks & Rec Ricoh Copi ers(3)201 3 20 18 20 1 2/21 5/21 8/21 11/21 16,12 9.94 3,575.09 3,574.09 113.15 0.00 1.00 3,68 7.24 11 0 PNC Equipm ent F inance Vehi c le/Equipmen t Lease 201 3 20 18 10 1/20 2/406/641 1/15 7/15--1,689,66 9.59 689,257.88 3 42,533.13 7,367.39 0.00 346,724.75 349,90 0.52 11 1 Ricoh U SA En gi neer in g P l otter/Scan ner 201 3 20 18 10 1 3/3 6/3 9/3 12/3 10,66 7.67 2,459.26 2,458.26 133.72 0.00 1.00 2,59 1.98 11 2 Ricoh U SA Bu ildin g Dept. Co pi er 201 3 20 18 60 0 Monthly 4,09 3.64 1,491.77 878.55 60.45 0.00 613.22 93 9.00 11 3 Sun Trust E quipme nt F in ance Police and PW vehicles 201 3 20 18 40 4/65 5/611/202 4/24 10/2 4--1,506,46 5.26 616,891.89 3 06,011.19 8,569.95 0.00 310,880.70 314,58 1.14 11 4 Ricoh U SA Admi n & Fina nce Copier 201 3 20 18 10 1 1/16 4/16 7/16 10/16 11,24 7.97 3,079.36 2,444.79 126.44 0.00 634.57 2,57 1.23 11 7 Police Dept. R ecord D iv. R icoh Police Rec ords Co pi er 201 3 20 18 10 1 Monthly 3rd--9,67 8.26 4,194.14 2,039.23 180.77 0.00 2,154.91 2,22 0.00 11 8 Wat er Works Main R i c oh Copier W ater W orks M ain Ricoh Co pi er 201 3 20 18 62 0 Monthly 10th--5,64 7.50 2,448.11 1,189.78 105.62 0.00 1,258.33 1,29 5.40 11 9 Wat er Works Colfax Ricoh C opier W ater W orks Colfa x R ico h Copier 201 3 20 18 62 0 Monthly 16th--4,73 2.65 2,051.62 997.01 85.51 0.00 1,054.61 1,08 2.52 12 0 Wat er Works Oliv e Ricoh Copier W ater W orks Olive Ricoh C opier 201 3 20 18 62 0 Monthly 10th--4,73 2.65 2,051.62 997.01 85.51 0.00 1,054.61 1,08 2.52 12 3 Police T raining D ept. Ricoh C opier Tra in i ng Copier 201 4 20 19 10 1 Monthly 30th--4,26 3.00 2,076.44 890.27 93.73 0.00 1,186.17 98 4.00 12 4 Police/Public Works V ehicle Leas e 2014 Ci ty V ehicles 201 4 20 19 Various 4/1 10/1--1,959,48 5.95 1,193,797.05 3 91,803.77 16,992.78 0.00 801,993.28 408,79 6.55 12 5 HP Computer Lease #1 C omputer Equipment Le ase 201 4 20 18 various Monthly 8th--137,10 4.95 63,525.63 32,632.97 2,191.39 0.00 30,892.66 34,82 4.36 12 6 HP Computer Lease #2 C omputer Equipment Le ase 201 4 20 18 20 1 and 620 Monthly 8th--4,00 0.00 1,947.01 950.39 70.09 0.00 996.62 1,02 0.48 12 7 HP Computer Lease #4 C omputer Equipment Le ase 201 4 20 18 40 4 Monthly 8th--5,88 6.15 2,795.30 1,412.70 83.34 0.00 1,382.60 1,49 6.04 12 8 HP Computer Lease #6 C omputer Equipment Le ase 201 4 20 18 20 1 Monthly 8th--3,75 5.50 1,917.99 883.34 73.78 0.00 1,034.65 95 7.12 12 9 HP Computer Lease #7 C omputer Equipment Le ase 201 4 20 18 62 0 Monthly 8th--1,32 6.00 706.05 315.44 21.40 0.00 390.61 33 6.84 13 0 Solid Waste C opier R icoh US A C opier 201 4 20 19 61 1 Monthly 17th--5,35 1.65 3,302.32 1,071.78 157.86 0.00 2,230.54 1,22 9.64 13 1 Police Com munications Copier R icoh US A C opier 201 4 20 19 10 1 Monthly 12th--8,84 3.00 4,876.99 1,804.44 227.40 0.00 3,072.55 2,03 1.84 13 2 Organic Resources & Was tewater R icoh US A C opiers 201 4 20 19 64 1 Monthly 21s t--12,26 0.18 6,558.16 2,513.45 303.55 0.00 4,044.71 2,81 7.00 13 4 Wat er Works Copier - Nort h S tation R icoh US A C opiers 201 4 20 19 62 0 Monthly 19th--4,73 2.65 2,132.25 992.44 93.08 0.00 1,139.81 1,08 5.52 13 6 HP Computer Lease #8 C omputer Equipment Le ase 201 5 20 19 40 4/20 1/611 Monthly 16th--19,60 3.94 11,854.14 4,538.52 494.04 0.00 7,315.62 5,03 2.56 13 7 Anima l Control Ricoh Copier R icoh US A C opiers 201 5 20 20 60 0 Monthly 30th--5,26 1.50 3,591.88 1,033.37 182.47 0.00 2,558.51 1,21 5.84 13 8 HP Computer Lease #9 C omputer Equipment Le ase 201 5 20 19 Various Monthly TBD--135,95 8.05 94,710.62 30,905.89 3,998.51 0.00 63,804.73 34,90 4.40 14 0 Vehicle & Equip. Lease Vehi c le/Equipmen t Lease 201 5 20 20 Various 1/15 7/15--3,425,27 3.58 2,763,845.35 6 76,723.50 35,941.86 0.00 2,087,121.85 712,66 5.36 14 3 HP Computer Lease #11 C omputer Equipment Le ase 201 5 20 19 40 4 Monthly--3,04 0.00 2,161.06 695.77 85.67 0.00 1,465.29 78 1.44 14 4 PNC Vehicle Lease No. 2 Vehi c le Lease Pu rchase 201 5 20 20 Various 5/15 11/1 5--1,267,18 3.00 1,021,855.36 2 49,580.62 14,814.26 0.00 772,274.74 264,39 4.88 14 6 Park s & Rec. Ricoh Cop ie r R icoh Copier 201 6 20 20 20 1 Monthly--4,30 2.06 3,454.72 810.05 176.59 0.00 2,644.67 98 6.64 14 7 Cen tral Services Lanier C opier C 5100 5 Copier 201 6 20 20 22 2 Monthly--32,52 5.00 28,667.19 6,046.87 1,368.89 0.00 22,620.32 7,41 5.76 14 8 Cen tral Services Lanier C opier C 6502 Copier 201 6 20 20 22 2 Monthly--11,41 3.00 10,059.31 2,121.84 480.36 0.00 7,937.47 2,60 2.20 14 9 Vehicle & Equip. Lease Pu bl ic W orks Vehicles Lease 201 6 20 21 Various 2/15 8/15--3,339,83 0.00 3,016,484.17 6 51,783.72 45,609.91 0.00 2,364,700.45 697,39 3.63 15 0 HP Computer Lease C opier L ease 201 6 20 20 Various Monthly--17,43 9.85 14,013.99 3,908.91 574.29 0.00 10,105.08 4,48 3.20 15 1 Admin and Finance R ic oh Copier C opier L ease 201 6 20 21 10 1 Monthly--10,92 3.63 8,938.27 2,047.09 458.15 0.00 6,891.18 2,50 5.24 15 2 PNC Vehicle / Equ ip Lease N o. 2 Vehi c le / E quipment Lea s e 201 6 20 21 Various 1/14 7/14--3,992,54 8.72 3,992,548.72 7 70,391.63 62,984.68 0.00 3,222,157.09 833,37 6.31 15 3 PNC Vehicle / Equ ip Lease Amend 1 Parks and R ecreat io n 201 6 20 21 20 1 1/17 7/17--78,80 8.00 78,808.00 15,287.29 1,141.51 0.00 63,520.71 16,42 8.80 15 4 PNC Vehicle / Equ ip Lease N o. 3 Parks & Rec / IT 201 6 20 21 20 1/279 4/19 10/1 9--1,256,09 6.99 1,256,096.99 2 44,070.10 17,538.46 0.00 1,012,026.89 261,60 8.56 15 5 HP Computer Lease No. 13 C omputer Equipment Le ase 201 6 20 20 Various Monthly---156,02 9.30 150,562.73 33,567.37 6,602.27 0.00 116,995.36 40,16 9.64 15 7 Venue, Parks, Ar t Copier R icoh Copier 201 6 20 21 20 1 Monthly---3,18 4.06 3,184.06 918.51 382.49 0.00 2,265.55 1,30 1.00 xxx T otal Cap ital L ease 30,212,98 7.87 16,078,945.72 4,7 99,796.25 243,944.33 0.00 11,279,149.47 5,043,74 0.58 To tal Civ i l C i ty 2 94,912,91 3.37 147,504,568.39 16,4 53,581.40 4,031,271.17 0.00 131,050,986.99 20,484,85 2.57 2 0 1 7-02 Finan cial Report - Debt Page 1 8 o f 25 City of South Bend Period Ending:February 28, 2017 Debt Schedule Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at 2017 Princip al 2017 Inter est 2017 Debt a t 2017 Total D eb t In strumen t D ebt Pur po se Issue Refunding M aturity F un d 1st 2nd 3rd 4th Is sue 12/3 1/20 16 Paym ents Payme nt Addit ion 12/31/20 17 D ebt P aymen ts Re dev elopment C ommis sion Debt Bond Deb t 7 Cen tury Center Lease Rental Reven ue C entury Center 199 4 2001/201 1 20 18 40 7 2/1 8/1--6,825,00 0.00 720,000.00 4 75,000.00 16,875.00 0.00 245,000.00 491,87 5.00 8 College Foot ball H all of Fame H al l of Fame 199 4 2000/201 1 20 18 31 3 2/1 8/1--15,370,00 0.00 1,830,000.00 1,2 15,000.00 53,407.50 0.00 615,000.00 1,268,40 7.50 1 1 Sout h B end Building C orporation Mor ris P AC 199 8 200 9 20 17 40 8 2/1 8/1--13,300,00 0.00 515,000.00 5 15,000.00 10,300.00 0.00 0.00 525,30 0.00 1 2 TJX Sp eci al Taxing D is t rict 200 2 201 4 20 22 32 4/40 4/414 1/1 7/1--6,620,00 0.00 2,210,000.00 4 15,000.00 66,300.00 0.00 1,795,000.00 481,30 0.00 5 Downt own Centr al Area T IF 200 3 201 1 20 24 42 0 2/1 8/1--19,795,00 0.00 12,500,000.00 1,3 15,000.00 598,625.00 0.00 11,185,000.00 1,913,62 5.00 6 Airport Development Are a TIF Airport TIF 200 3 201 1 20 24 32 4 2/1 8/1--14,420,00 0.00 7,125,000.00 7 50,000.00 341,210.50 0.00 6,375,000.00 1,091,21 0.50 2 2 Erskin e V illage TIF Development Bond Er s ki ne Vil la ge 200 5 20 27 43 2 2/1 8/1--5,485,00 0.00 3,800,000.00 3,8 00,000.00 161,666.72 0.00 0.00 3,961,66 6.72 5 4 L ease Ren t al R evenu e B onds of 200 8 Eddy S t reet Co mmons 200 8 20 27 42 9 2/15 8/15--36,000,00 0.00 30,075,000.00 1,3 15,000.00 1,148,181.26 0.00 28,760,000.00 2,463,18 1.26 8 1 Coveles k i Stadi um Reco v ery C oveleski S tadium 201 0 20 19 37 7 1/15 7/15--4,980,00 0.00 1,665,000.00 6 50,000.00 77,155.00 0.00 1,015,000.00 727,15 5.00 12 2 Synagogue at Coveleski Improvements C oveleski S tadium 201 4 20 18 37 7 1/31 500,00 0.00 200,000.00 1 00,000.00 0.00 0.00 100,000.00 100,00 0.00 13 5 2 015 Redevelopm ent Smar t St reets Smarts Stre ets 201 5 20 37 32 4 2/1 8/1 25,000,00 0.00 25,000,000.00 4 60,000.00 394,784.38 0.00 24,540,000.00 854,78 4.38 xxx Total Bond Debt 1 53,788,78 8.00 85,640,000.00 11,0 10,000.00 2,868,505.36 0.00 74,630,000.00 13,878,50 5.36 Loa ns Payab le 3 In di ana Development Finance Autho rity Bos c h P roperty (Nonforgive)200 1 20 21 21 0 3/22 6/22 9/22 12/22 1,040,00 0.00 302,069.15 63,660.08 8,350.36 0.00 238,409.07 72,01 0.44 4 In di ana Development Finance Autho rity Bos c h P roperty (Forgive)200 1 20 21 21 0----260,00 0.00 83,482.06 0.00 0.00 0.00 65,888.51 0.00 6 4 In terfu nd F und 412 - Major Mov es D ouglas Road TIF 200 9 20 29 43 5 2/15 8/15--1,040,31 9.00 323,005.00 3 22,201.00 12,088.00 0.00 804.00 334,28 9.00 8 4 In terfu nd F und 412 - Major Mov es Trian gle Development 201 1 20 29 43 6 2/15 8/15--2,000,00 0.00 1,329,573.43 94,621.29 26,120.71 0.00 1,234,952.14 120,74 2.00 8 5 In terfu nd F und 412 - Major Mov es Eddy S t reet Co mmons 201 1 20 26 43 6 2/15 8/15--4,100,00 0.00 2,384,347.86 6 61,383.84 111,052.16 0.00 1,722,964.02 772,43 6.00 8 6 In terfu nd F und 209 to Air port 324 Pr airie Ave Brownf ie ld Project 201 1 20 20 32 4 8/9---500,00 0.00 400,000.00 1 00,000.00 0.00 0.00 300,000.00 100,00 0.00 14 2 In terfu nd F und 412 - Major Mov es Parking Garage Improve ments 201 6 20 22 60 1 6/1 12/1 1,500,00 0.00 517,304.69 2 29,174.05 20,825.95 7 50,0 00.00 1,038,130.64 250,00 0.00 xxx Total Loans Pa yable 15,627,49 9.06 5,339,782.19 1,4 71,040.26 178,437.18 7 50,0 00.00 4,601,148.38 1,649,47 7.44 Ca pita l Lease xxx T otal Cap ital L ease 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Leas es 1 3 Tran s po Lea s e Main / C ol fax Gar age 200 6 20 25 40 4 3/15 9/15--2,510,27 8.00 1,435,338.00 1 29,838.00 70,162.00 0.00 1,305,500.00 200,00 0.00 xxx Tot al Lease 5,510,27 8.00 1,435,338.00 1 29,838.00 70,162.00 0.00 1,305,500.00 200,00 0.00 Tot al Red evelop ment Commiss ion 1 74,926,56 5.06 92,415,120.19 12,6 10,878.26 3,117,104.54 7 50,0 00.00 80,536,648.38 15,727,98 2.80 To tal Debt 4 69,839,47 8.43 239,919,688.58 29,0 64,459.66 7,148,375.71 7 50,0 00.00 211,587,635.37 36,212,83 5.37 2 0 1 7-02 Finan cial Report - Debt Page 1 9 o f 25 City of South Bend Period Ending:February 28, 2017 Monthly Debt Schedule Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at YT D Principa l Y TD Interes t YT D Debt a t D eb t In strumen t D ebt Pur po se Issue Refunding M aturity F un d 1st 2nd 3rd 4th Is sue 12/3 1/20 16 Paym ents Pay ments Ad ditions 2/2 8/2017 Civil City Debt Bond Deb t A mort s ch # 3 1 CEDIT Bond 199 7 200 6 20 17 40 8 2/1 8/1--11,870,00 0.00 430,000.00 4 30,000.00 9,932.50 0.00 0.00 3 6 Sout h B end Building C orporation Pu bl ic W orks Building 200 1 201 0 20 21 40 4/649 2/1 8/1--9,250,00 0.00 2,755,000.00 2 85,000.00 50,313.00 0.00 2,470,000.00 2 5 Wat er Works Impr ovemen ts W ater W orks 200 2 201 2 20 23 62 5 7/1 12/3 1--5,975,00 0.00 2,380,000.00 0.00 0.00 0.00 2,380,000.00 3 9 Sout h B end Building C orporation Fire HQ / P ol ice H Q 200 3 201 2 20 23 40 4/324 2/1 8/1--21,335,00 0.00 8,885,000.00 6 20,000.00 164,730.00 0.00 8,265,000.00 2 4 Wat er Works Impr ovemen ts W ater W orks 200 6 20 27 62 5 7/1 12/3 1--4,710,00 0.00 0.00 0.00 0.00 0.00 0.00 6 2 Cen tury Center Spec i al Tax Bonds C entury Center 200 8 20 28 32 4 5/1 11/1--4,655,00 0.00 3,175,000.00 0.00 0.00 0.00 3,175,000.00 6 9 Wat er Works Impr ovemen ts W ater W orks 200 9 20 30 62 5 7/1 12/3 1--5,380,00 0.00 4,325,000.00 0.00 0.00 0.00 4,325,000.00 7 0 Sewage W orks Reve nue Bon ds - 2009 Sewag e W orks 200 9 20 28 64 9 6/1 12/1--3,297,00 0.00 2,249,643.00 0.00 0.00 0.00 2,249,643.00 8 0 2 010 Sewage W orks Re v enue Bonds Sewag e W orks 201 0 20 30 64 9 6/1 12/1--9,345,00 0.00 7,145,000.00 0.00 0.00 0.00 7,145,000.00 9 3 Sewage W orks Reve nue Bon ds 201 1 Sewag e W orks 201 1 20 31 64 9 6/1 12/1--21,500,00 0.00 17,295,000.00 0.00 0.00 0.00 17,295,000.00 9 9 2 012 W ater Wo rks Reven ue Bond W ater W orks 201 2 20 33 62 5 1/1 7/1--8,300,00 0.00 6,925,000.00 0.00 0.00 0.00 6,925,000.00 10 1 2 012 Sewage W orks Re v enue Bonds Sewag e W orks 201 2 20 32 64 9 6/1 12/1--25,000,00 0.00 20,890,000.00 0.00 0.00 0.00 20,890,000.00 10 5 2 013A Sewer Bon d Refunding Sewag e W orks 201 3 201 3 20 24 64 9 6/1 12/1--14,765,00 0.00 8,050,000.00 0.00 0.00 0.00 8,050,000.00 11 6 2 013 Building C orporation EMS / Fire D epar t ment 201 3 20 33 28 8 2/1 8/1--5,580,00 0.00 5,145,000.00 2 25,000.00 90,427.50 0.00 4,920,000.00 13 3 St. Joseph Cou nty PS AP St. J oseph County PSA P 201 4 20 34 40 8 Monthly---2,657,69 6.50 2,386,507.92 0.00 0.00 0.00 2,386,507.92 paid thru 2/28/1 7 13 9 Cen tury Center En ergy Saving s Impro v ements C entury Ctr.201 5 20 31 67 2 5/1 11/1--4,167,89 7.00 4,145,312.00 0.00 0.00 0.00 4,145,312.00 14 1 Park s and Rec Bo nd Parks Improveme nts 201 5 20 35 40 8 2/1 8/1--5,605,00 0.00 5,295,000.00 1 10,000.00 88,566.00 0.00 5,185,000.00 14 5 Sewage W orks Reve nue Bon ds - 2015 Sewer B ond Improvements 201 5 20 25 64 9 6/1 12/1--27,440,00 0.00 24,965,000.00 0.00 0.00 0.00 24,965,000.00 15 6 2 016 W ater Wo rks Refu nding Bon ds R efunding 20 00 / 2 006 SRF 201 6 20 27 62 5 1/1 7/1--3,300,00 0.00 3,300,000.00 0.00 0.00 0.00 3,300,000.00 xxx Total Bond Debt 2 34,877,59 3.50 129,741,462.92 1,6 70,000.00 403,969.00 0.00 128,071,462.92 Loa ns Payab le 6 8 State R evolving F und W ater W orks Improvement 200 9 20 30 62 5 7/1 12/3 1--427,33 2.00 332,562.00 0.00 0.00 0.00 332,562.00 8 2 In terfu nd Loan 41 0 - UDAG 1st Sour c e/Marriott Garage 201 0 20 15 41 0 6/15 12/1 5--2,700,00 0.00 1,351,597.75 0.00 0.00 0.00 1,351,597.75 2 6 State R evolving F und W ater W orks Improvements 200 0 20 19 62 5 7/1 12/3 1--2,600,00 0.00 0.00 0.00 0.00 0.00 0.00 xxx Total Loans Pa yable 29,822,33 2.00 1,684,159.75 0.00 0.00 0.00 1,684,159.75 Ca pita l Leases 5 1 Ch ase LE D Equipmen t 200 7 20 17 10 1 1/1 7/1--1,531,57 3.00 194,320.02 96,131.38 4,158.45 0.00 98,188.64 8 9 Sun Trust Police, Parks, Bl dg vehicles 201 1 20 16 40 4/20 1/600 3/15 6/15 9/15 12/15 2,068,20 2.00 0.00 0.00 0.00 0.00 0.00 9 0 Cap ital One Public Fundin g Solid Was te Cont ai ners/Truc k s 201 1 20 16 61 1 3/15 6/15 9/15 12/15 207,43 2.00 0.00 0.00 0.00 0.00 0.00 9 1 GE Cap ital I nfor mation Techn ology Police Dept Copier 201 1 20 16 10 1 1/11 4/11 7/11 10/11 3,83 6.00 0.00 0.00 0.00 0.00 0.00 9 2 Key Finance IT Phone S ystem 201 1 20 16 40 4 1/15 1,444,99 5.97 0.00 0.00 0.00 0.00 0.00 9 4 Iko n Office Solu t ions Mayor Ric oh M P 2851 SP Copier 201 1 20 16 10 1 2/15 5/15 8/15 11/15 2,56 9.53 0.00 0.00 0.00 0.00 0.00 9 5 Sun Trust E quipme nt F in ance Parks-Golf C ars Lease 201 2 20 16 20 1 4/15 10/1 5--344,50 0.00 0.00 0.00 0.00 0.00 0.00 9 7 Sun Trust E quipme nt F in ance Police Veh ic le s & Equ ipment 201 2 20 17 40 6 5/15 11/1 5--1,295,00 0.00 134,585.22 0.00 0.00 0.00 134,585.22 9 8 PNC Equipm ent F inance Pu bl ic W orks Vehicles Lease 201 2 20 17 20 2/64 1/640 5/15 11/1 5--945,67 4.38 97,793.51 0.00 0.00 0.00 97,793.51 10 0 PNC Equipm ent F inance Pu bl ic W orks Vehicles Lease 201 2 20 17 20 2/64 1/600/288 1/15 7/15--2,806,05 4.00 575,316.55 2 86,723.17 3,752.50 0.00 288,593.38 10 2 Iko n Office Solu t ions / Ricoh W astewater C opier 201 2 20 17 64 1 Monthly 1st--5,74 4.95 756.77 213.68 6.64 0.00 543.09 10 3 GE Cap ital I nfor mation Techn ology Fire Department Cop ie r 201 2 20 17 10 1 2/28 5/28 8/28 11/28 5,47 1.01 926.68 304.08 13.62 0.00 622.60 10 6 Ricoh U SA C entra l Servi c es Copier 201 3 20 18 22 2 2/27 5/27 8/27 11/27 3,62 2.78 815.82 202.33 7.61 0.00 613.49 10 7 Ricoh U SA Street/Sewer Dept Copier 201 3 20 18 20 2/641 3/4 6/4 9/4 12/4 5,55 9.15 1,225.93 0.00 0.00 0.00 1,225.93 10 8 Ricoh U SA C ity Att orney C opier 201 3 20 18 10 1 2/12 5/12 8/12 11/12 5,55 9.15 1,232.73 305.77 11.93 0.00 926.96 10 9 Ricoh U SA Parks & Rec Ricoh Copi ers(3)201 3 20 18 20 1 2/21 5/21 8/21 11/21 16,12 9.94 3,575.09 887.23 34.58 0.00 2,687.86 11 0 PNC Equipm ent F inance Vehi c le/Equipmen t Lease 201 3 20 18 10 1/20 2/406/641 1/15 7/15--1,689,66 9.59 689,257.88 1 70,745.79 4,204.47 0.00 518,512.09 11 1 Ricoh U SA En gi neer in g P l otter/Scan ner 201 3 20 18 10 1 3/3 6/3 9/3 12/3 10,66 7.67 2,459.26 0.00 0.00 0.00 2,459.26 11 2 Ricoh U SA Bu ildin g Dept. Co pi er 201 3 20 18 60 0 Monthly--4,09 3.64 1,491.77 143.08 13.42 0.00 1,348.69 11 3 Sun Trust E quipme nt F in ance Police and PW vehicles 201 3 20 18 40 4/65 5/611/202 4/24 10/2 4--1,506,46 5.26 616,891.89 0.00 0.00 0.00 616,891.89 11 4 Ricoh U SA Admi n & Fina nce Copier 201 3 20 18 10 1 1/16 4/16 7/16 10/16 11,24 7.97 3,079.36 598.03 44.70 0.00 2,481.33 11 7 Police Dept. R ecord D iv. R icoh Police Rec ords Co pi er 201 3 20 18 10 1 Monthly 3rd--9,67 8.26 4,194.14 332.11 37.89 0.00 3,862.03 11 8 Wat er Works Main R i c oh Copier W ater W orks M ain Ricoh Co pi er 201 3 20 18 62 0 Monthly 10th--5,64 7.50 2,448.11 193.76 22.14 0.00 2,254.35 11 9 Wat er Works Colfax Ricoh C opier W ater W orks Colfa x R ico h Copier 201 3 20 18 62 0 Monthly 16th--4,73 2.65 2,051.62 162.37 18.55 0.00 1,889.25 12 0 Wat er Works Oliv e Ricoh Copier W ater W orks Olive Ricoh C opier 201 3 20 18 62 0 Monthly 10th--4,73 2.65 2,051.62 162.37 18.55 0.00 1,889.25 12 3 Police T raining D ept. Ricoh C opier Tra in i ng Copier 201 4 20 19 10 1 Monthly 30th--4,26 3.00 2,076.44 144.94 19.06 0.00 1,931.50 12 4 Key Go v ernment Fi nance 2014 Ci ty V ehicles 201 4 20 19 various 4/1 10/1--1,959,48 5.95 1,193,797.05 0.00 0.00 0.00 1,193,797.05 12 5 HP Computer Lease #1 C omputer Equipment Le ase 201 4 20 18 various Monthly 8th--137,10 4.95 63,525.63 5,337.54 466.52 0.00 58,188.09 12 6 HP Computer Lease #2 C omputer Equipment Le ase 201 4 20 18 20 1 and 620 Monthly 8th--4,00 0.00 1,947.01 155.36 14.72 0.00 1,791.65 12 7 HP Computer Lease #4 C omputer Equipment Le ase 201 4 20 18 40 4 Monthly 8th--5,88 6.15 2,795.30 231.67 17.67 0.00 2,563.63 12 8 HP Computer Lease #6 C omputer Equipment Le ase 201 4 20 18 20 1 Monthly 8th--3,75 5.50 1,917.99 144.27 15.25 0.00 1,773.72 12 9 HP Computer Lease #7 C omputer Equipment Le ase 201 4 20 18 62 0 Monthly 8th--1,32 6.00 706.05 51.74 4.40 0.00 654.31 13 0 Solid Waste C opier R icoh US A C opier 201 4 20 19 61 1 Monthly 17th--5,35 1.65 3,302.32 174.49 30.45 0.00 3,127.83 13 1 Police Com munications Copier R icoh US A C opier 201 4 20 19 10 1 Monthly 12th--8,84 3.00 4,876.99 293.78 44.86 0.00 4,583.21 13 2 Organic Resources & Was tewater R icoh US A C opiers 201 4 20 19 64 1 Monthly 21s t--12,26 0.18 6,558.16 409.21 60.29 0.00 6,148.95 13 4 Wat er Works Copier - Nort h S tation R icho US A C opiers 201 4 20 19 62 0 Monthly 19th--4,73 2.65 2,132.25 161.63 19.29 0.00 1,970.62 13 6 HP Computer Lease #8 C omputer Equipment Le ase 201 5 20 19 40 4/20 1/611 Monthly 16th--19,60 3.94 11,854.14 740.64 98.12 0.00 11,113.50 13 7 Anima l Control Ricoh Copier R icoh US A C opiers 201 5 20 20 60 0 Monthly 30th--5,26 1.50 3,591.88 168.07 34.57 0.00 3,423.81 13 8 HP Computer Lease #9 C omputer Equipment Le ase 201 5 20 19 Various Monthly TBD--135,95 8.05 94,710.62 5,045.41 771.99 0.00 89,665.21 14 0 Vehicle & Equip. Lease Vehi c le/Equipmen t Lease 201 5 20 20 Various 1/15 7/15--3,425,27 3.58 2,763,845.35 3 37,194.29 19,138.39 0.00 2,426,651.06 14 3 HP Computer Lease #11 C omputer Equipment Le ase 201 5 20 19 40 4 Monthly 3,04 0.00 2,161.06 113.74 16.50 0.00 2,047.32 14 4 PNC Vehicle Lease No. 2 Vehi c le Lease Pu rchase 201 5 20 20 various 5/15 11/1 5--1,267,18 3.00 1,021,855.36 0.00 0.00 0.00 1,021,855.36 14 6 Park s & Rec reation Copier R icoh Copier 201 6 20 20 20 1 Monthly 4,30 2.06 3,454.72 131.82 32.62 0.00 3,322.90 14 7 Cen tral Services Lanier C opier C 5100 5 Copier 201 6 20 20 22 2 Monthly---32,52 5.00 28,667.19 985.82 250.14 0.00 27,681.37 14 8 Cen tral Services Lanier C opier C 6502 201 6 20 20 22 2 Monthly---11,41 3.00 10,059.31 345.92 87.78 0.00 9,713.39 14 9 Vehicle & Equip. Lease Pu bl ic W orks Vehicles Lease 201 6 20 21 various 2/15 8/15 3,339,83 0.00 3,016,484.17 3 24,595.10 24,101.71 0.00 2,691,889.07 15 0 HP Computer Lease C omputer Leas e- Ref resh 201 6 20 20 40 4/64 1/620 Monthly---17,43 9.85 14,013.99 638.84 108.36 0.00 13,375.15 15 1 Admin and Finance R ic oh Copier MPC800 2S P Copier 201 6 20 21 10 1 Monthly---10,92 3.63 8,938.27 333.12 84.42 0.00 8,605.15 15 2 PNC Vehicle / Equ ip Lease N o. 2 Vehi c le / E quipment Lea s e 201 6 20 21 various 1/14 7/14--3,992,54 8.72 3,992,548.72 3 81,193.11 35,495.05 0.00 3,611,355.61 15 3 PNC Vehicle / Equ ip Lease Amend 1 Parks and R ecreat io n 201 6 20 12 20 1 1/17 7/17--78,80 8.00 78,808.00 7,614.67 599.73 0.00 71,193.33 15 4 PNC Vehicle / Equ ip Lease N o. 3 Parks & Rec / IT 201 6 20 21 20 1/279 4/19 10/1 9--1,256,09 6.99 1,256,096.99 0.00 0.00 0.00 1,256,096.99 15 5 HP Computer Lease No. 13 C omputer Equipment Le ase 201 6 20 20 various Monthly 156,02 9.30 150,562.73 5,481.46 1,215.48 0.00 145,081.27 15 7 Venue, Parks, Ar t Copier R icoh Copier 201 6 20 21 20 1 Monthly 3,18 4.06 3,184.06 443.40 207.12 0.00 2,740.66 xxx T otal Cap ital L ease 30,212,98 7.87 16,078,945.72 1,6 29,235.19 95,279.54 0.00 14,449,710.53 To tal Civ i l C i ty 2 94,912,91 3.37 147,504,568.39 3,2 99,235.19 499,248.54 0.00 144,205,333.20 2 0 1 7-02 Finan cial Report - Debt Page 2 0 o f 25 City of South Bend Period Ending:February 28, 2017 Monthly Debt Schedule Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at YT D Principa l Y TD Interes t YT D Debt a t D eb t In strumen t D ebt Pur po se Issue Refunding M aturity F un d 1st 2nd 3rd 4th Is sue 12/3 1/20 16 Paym ents Pay ments Ad ditions 2/2 8/2017 Re dev elopment C ommis sion Debt Bond Deb t 7 Cen tury Center Lease Rental Reven ue C entury Center 199 4 2001/201 1 20 18 40 7 2/1 8/1--6,825,00 0.00 720,000.00 2 35,000.00 10,200.00 0.00 485,000.00 8 College Foot ball H all of Fame H al l of Fame 199 4 2000/201 1 20 18 31 3 2/1 8/1--15,370,00 0.00 1,830,000.00 6 00,000.00 31,728.75 0.00 1,230,000.00 1 1 Sout h B end Building C orporation Mor ris P AC 199 8 200 9 20 17 40 8 2/1 8/1--13,300,00 0.00 515,000.00 5 15,000.00 10,300.00 0.00 0.00 1 2 TJX Sp eci al Taxing D is t rict 200 2 201 4 20 22 32 4/40 4/414 1/1 7/1--6,620,00 0.00 2,210,000.00 0.00 0.00 0.00 2,210,000.00 5 Downt own Centr al Area T IF 200 3 201 1 20 24 42 0 2/1 8/1--19,795,00 0.00 12,500,000.00 6 50,000.00 306,755.00 0.00 11,850,000.00 6 Airport Development Are a TIF Airport TIF 200 3 201 1 20 24 32 4 2/1 8/1--14,420,00 0.00 7,125,000.00 3 70,000.00 174,841.75 0.00 6,755,000.00 2 2 Erskin e V illage TIF Development Bond Er s ki ne Vil la ge 200 5 20 27 43 2 2/1 8/1--5,485,00 0.00 3,800,000.00 2 50,000.00 123,667.50 0.00 3,550,000.00 5 4 L ease Ren t al R evenu e B onds of 200 8 Eddy S t reet Co mmons 200 8 20 27 42 9 2/15 8/15--36,000,00 0.00 30,075,000.00 6 55,000.00 579,003.13 0.00 29,420,000.00 8 1 Coveles k i Stadi um Reco v ery C oveleski S tadium 201 0 20 19 37 7 1/15 7/15--4,980,00 0.00 1,665,000.00 3 25,000.00 42,640.00 0.00 1,340,000.00 12 2 Synagogue at Coveleski Improvements C oveleski S tadium 201 4 20 18 37 7 1/31 500,00 0.00 200,000.00 0.00 0.00 0.00 200,000.00 13 5 2 015 Redevelopm ent Smar t St reets Smart Stre ets 201 5 20 37 32 4 2/1 8/1 25,000,00 0.00 25,000,000.00 0.00 394,784.38 0.00 25,000,000.00 xxx Total Bond Debt 1 53,788,78 8.00 85,640,000.00 3,6 00,000.00 1,673,920.51 0.00 82,040,000.00 Loa ns Payab le 3 In di ana Development Finance Autho rity Bos c h P roperty (Nonforgive)200 1 20 21 21 0 3/22 6/22 9/22 12/22 1,040,00 0.00 302,069.15 0.00 0.00 0.00 302,069.15 4 In di ana Development Finance Autho rity Bos c h P roperty (Forgive)200 1 20 21 21 0----260,00 0.00 83,482.06 0.00 0.00 0.00 66,406.56 6 4 In terfu nd F und 412 - Major Mov es D ouglas Road TIF 200 9 20 29 43 5 2/15 8/15--1,040,31 9.00 323,005.00 1 41,925.00 8,075.00 0.00 181,080.00 8 4 In terfu nd F und 412 - Major Mov es Trian gle Development 201 1 20 29 43 6 2/15 8/15--2,000,00 0.00 1,329,573.43 47,075.27 13,295.73 0.00 1,282,498.16 8 5 In terfu nd F und 412 - Major Mov es Eddy S t reet Co mmons 201 1 20 26 43 6 2/15 8/15--4,100,00 0.00 2,384,347.86 3 26,609.30 59,608.70 0.00 2,057,738.56 8 6 In terfu nd F und 209 to Air port 324 Pr airie Ave Brownf ie ld Project 201 1 20 20 32 4 8/9---500,00 0.00 400,000.00 0.00 0.00 0.00 400,000.00 14 2 In terfu nd F und 412 - Major Mov es Parking Garage Improve ments 201 6 20 22 60 1 6/1 12/1--1,500,00 0.00 517,304.69 0.00 0.00 7 50,0 00.00 1,267,304.69 xxx Total Loans Pa yable 15,627,49 9.06 5,339,782.19 5 15,609.57 80,979.43 7 50,0 00.00 5,557,097.12 Ca pita l Lease xxx T otal Cap ital L ease 0.00 0.00 0.00 0.00 0.00 0.00 Leas es 1 3 Tran s po Lea s e Main / C ol fax Gar age 200 6 20 25 40 4 3/15 9/15--2,510,27 8.00 1,435,338.00 0.00 0.00 0.00 1,435,338.00 xxx Tot al Lease 5,510,27 8.00 1,435,338.00 0.00 0.00 0.00 1,435,338.00 Tot al Red evelop ment Commiss ion 1 74,926,56 5.06 92,415,120.19 4,1 15,609.57 1,754,899.94 7 50,0 00.00 89,032,435.12 To tal Debt 4 69,839,47 8.43 239,919,688.58 7,4 14,844.76 2,254,148.48 7 50,0 00.00 233,237,768.32 2 0 1 7-02 Finan cial Report - Debt Page 2 1 o f 25 City of South Bend Staffing Headcount Summary Budget Full Time Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Full Time Staff 1,110 1,080 1,069 - - - - - 0 0 0 0 0 Part Time Staff 115 119 0 0 0 0 0 0 0 0 0 0 Temporary / Seasonal 12 11 0 0 0 0 0 0 0 0 0 0 City Total 1,207 1,199 - - - - - 0 0 0 0 0 2017-02 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 0 0 0 0 0 0 0 0 0 0 311 Call Center 6 6 6 0 0 0 0 0 0 0 0 0 0 Admin & Finance 23 20 21 0 0 0 0 0 0 0 0 0 0 Innovation/ Technology Office 18 14 14 0 0 0 0 0 0 0 0 0 0 Safety & Risk 2 2 2 0 0 0 0 0 0 0 0 0 0 Clerk 5 5 5 0 0 0 0 0 0 0 0 0 0 Common Council 9 9 9 0 0 0 0 0 0 0 0 0 0 Legal Department 10 11 11 0 0 0 0 0 0 0 0 0 0 Sub Total 80 73 74 0 0 0 0 0 0 0 0 0 0 Code Enf. /Animal Control 29 20 22 0 0 0 0 0 0 0 0 0 0 Dept. of Community Investment 23 22 20 0 0 0 0 0 0 0 0 0 0 Parks & Recreation Administration 6 6 6 0 0 0 0 0 0 0 0 0 0 Maintenance 46 45 47 0 0 0 0 0 0 0 0 0 0 Golf Operations 8 7 8 0 0 0 0 0 0 0 0 0 0 Recreation Ops 25 22 21 0 0 0 0 0 0 0 0 0 0 Zoological Ops 1 1 1 0 0 0 0 0 0 0 0 0 0 Graffiti Removal 1 1 1 0 0 0 0 0 0 0 0 0 0 Recreation Non-reverting 1 1 1 Marketing and Events 10 8 10 0 0 0 0 0 0 0 0 0 0 Sub Total 98 91 95 0 0 0 0 0 0 0 0 0 0 Public Safety Police 289 284 272 0 0 0 0 0 0 0 0 0 0 Fire 264 268 267 0 0 0 0 0 0 0 0 0 0 Sub Total 553 552 539 0 0 0 0 0 0 0 0 0 0 Public Works Central Services 37 35 36 0 0 0 0 0 0 0 0 0 0 Office of Sustainability 2 2 2 0 0 0 0 0 0 0 0 0 0 Engineering 18 18 18 0 0 0 0 0 0 0 0 0 0 Maintenance 3 3 3 0 0 0 0 0 0 0 0 0 0 Solid Waste Operations 26 25 25 0 0 0 0 0 0 0 0 0 0 Unsafe Bldg Code Clean Crew 4 4 4 0 0 0 0 0 0 0 0 0 0 Street Operations 55 54 54 0 0 0 0 0 0 0 0 0 0 Sewer Operations 37 37 37 0 0 0 0 0 0 0 0 0 0 Waste Water Ops 45 45 45 0 0 0 0 0 0 0 0 0 0 Organic Resources 6 6 5 0 0 0 0 0 0 0 0 0 0 Water Utility Ops 71 64 63 0 0 0 0 0 0 0 0 0 0 Sub Total 304 293 292 0 0 0 0 0 0 0 0 0 0 Building Department 14 14 14 0 0 0 0 0 0 0 0 0 0 Human Rights 6 6 6 0 0 0 0 0 0 0 0 0 0 Morris & Palais 9 9 7 0 0 0 0 0 0 0 0 0 0 City Total 1,116 1,080 1,069 - - - - - - - - - - 2017-02 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 0 0 0 0 0 0 0 0 0 0 311 Call Center 2 2 0 0 0 0 0 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 0 0 0 0 0 0 0 0 0 0 Sub Total 5 4 0 0 0 0 0 0 0 0 0 0 Code Enf. / Animal Control 3 2 0 0 0 0 0 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 0 0 0 0 0 0 0 0 0 0 Maintenance 11 11 0 0 0 0 0 0 0 0 0 0 Golf Operations 2 0 0 0 0 0 0 0 0 0 0 0 Recreation Ops 46 54 0 0 0 0 0 0 0 0 0 0 Zoological Ops 0 0 0 0 0 0 0 0 0 0 0 0 Graffiti Removal 4 4 0 0 0 0 0 0 0 0 0 0 Marketing & Events 1 1 0 0 0 0 0 0 0 0 0 0 Sub Total 65 70 0 0 0 0 0 0 0 0 0 0 Public Safety Police 25 25 0 0 0 0 0 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 25 25 0 0 0 0 0 0 0 0 0 0 Public Works` Central Services 1 1 0 0 0 0 0 0 0 0 0 0 Engineering 2 2 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 7 8 0 0 0 0 0 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 0 0 0 0 0 0 0 0 0 0 Sub Total 13 14 0 0 0 0 0 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 0 0 0 0 0 0 0 0 0 0 City Total 115 119 0 0 0 0 0 0 0 0 0 0 2017-02 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 0 0 0 0 0 0 Admin & Finance 1 1 0 0 0 0 0 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 0 0 0 0 0 0 0 0 Code Enfor. / Animal 1 1 0 0 0 0 0 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 0 0 0 0 0 0 Maintenance 1 1 0 0 0 0 0 0 0 0 0 0 Golf Operations 0 0 0 0 0 0 0 0 0 0 0 0 Recreation Ops 3 2 0 0 0 0 0 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 0 0 0 0 0 0 0 0 0 0 Public Safety Police 0 0 0 0 0 0 0 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 0 0 0 0 0 0 Public Works Central Services 0 0 0 0 0 0 0 0 0 0 0 0 Engineering 3 4 0 0 0 0 0 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 0 0 0 0 0 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 0 0 0 0 0 0 0 0 0 0 Organic Resources 0 0 0 0 0 0 0 0 0 0 0 0 Water Utility Ops 0 0 0 0 0 0 0 0 0 0 0 0 Sub Total 4 5 0 0 0 0 0 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 0 0 0 0 0 0 0 0 0 0 City Total 12 11 0 0 0 0 0 0 0 0 0 0 2017-02 Financial Report - Headcount Staffing Page 25 of 25