Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017-01 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 January 31, 2017 Controller 2017-01 Financial Report January Page 1 of 25 January 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 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 271% 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 January 2017,the City has spent 8%of budgeted expenditures,similar to 8%in January 2016.The General Fund has spent 8%of its 2016 budgeted expenditures,versus 7%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~$1.6 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 January was 1,080 vs. a budgeted amount of 1,116. Currently, there are a total of 36 vacant positions. The 36 open positions are in the following departments:General Government(7),Parks(7),Public Safety(1),Public Works(11),DCI(1),and Code Enforcement / Animal Control (9). For discussion on property taxes,see section listed below.The overall percentage of budgeted revenues that have been received by the city is 5%,compared to 6%in January 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 January 2017,the general fund has reached 2%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-01 Financial Report January Page 2 of 25 City of South Bend Period Ending:January 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- - - - - - - - - - - - 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 10,433,361 8% 316 Local Option Income Tax - PS 249 622,302 - - - - - - - - - - - 622,302 7,467,618 8% 316 County Option Income Tax 404 871,605 - - - - - - - - - - - 871,605 10,459,265 8% Sub Total 2,377,250 - - - - - - - - - - - 2,377,250 28,360,244 8% 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 - - - - - - - - - - - 361,601 4,668,000 8% 335 Liquor Excise tax 101- - - - - - - - - - - - - 75,000 0% 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 - - - - - - - - - - - 487,503 19,972,638 2% Other Intergovernmental Sources 336 Federal Drug 299- - - - - - - - - - - - - 30,000 0% 337 State Drug 216 10,113 - - - - - - - - - - - 10,113 35,000 29% 338 Payment in Lieu of Tax various 517,361 - - - - - - - - - - - 517,361 7,623,328 7% 339 Contractual Service 211 9,669 - - - - - - - - - - - 9,669 316,000 3% Sub Total 537,143 - - - - - - - - - - - 537,143 8,004,328 7% Charge for Service Internal City 340 Liability Insurance 226 243,168 - - - - - - - - - - - 243,168 2,927,591 8% 340 General Government Misc Chgs 101/289- - - - - - - - - - - - - 500 0% 340 Police Take Home Vehicle 278- - - - - - - - - - - - - 122,200 0% 349 Central Service 222 51,820 - - - - - - - - - - - 51,820 873,809 6% 380 Central Service 222 210,212 - - - - - - - - - - - 210,212 2,880,310 7% 380 Energy Office Reimbursements 222 411,202 - - - - - - - - - - - 411,202 4,492,800 9% 380 IT Innovation 311 Center 279 430,621 - - - - - - - - - - - 430,621 5,197,431 380 INDOT SR 933 Transfer 324- - - - - - - - - - - - - 4,100,000 380 Internal Service Reimbursement various 65,792 - - - - - - - - - - - 65,792 1,404,921 5% 392 Administration Fee 101/279 414,748 - - - - - - - - - - - 414,748 4,977,026 8% 392 Internal Fund Transfers various 1,085,348 - - - - - - - - - - - 1,085,348 39,699,016 3% 395 Employee Benefits 711/713 1,499,317 - - - - - - - - - - - 1,499,317 17,836,850 8% 2017-01 Fin anc i al Re port Janu ary - R eve nue Report Page 3 of 25 City of South Bend Period Ending:January 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 - - - - - - - - - - - 1,314 21,000 6% 396 Self Funded Employee Benefits 711 6,503 - - - - - - - - - - - 6,503 - NA Sub Total 4,420,045 - - - - - - - - - - - 4,420,045 84,533,454 5% 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 0% 364 Cable TV Franchise Fees 101- - - - - - - - - - - - - 748,000 0% 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 - - - - - - - - - - - 55,865 7,035,660 1% Grants 331 Federal Grants various 468,447 - - - - - - - - - - - 468,447 5,587,386 8% 332 Solar Energy Grant 222- - - - - - - - - - - - - - NA 334 State Grants various- - - - - - - - - - - - - 3,025,381 0% Sub Total 468,447 - - - - - - - - - - - 468,447 8,612,767 5% Fees for Services External 320 Inspections Central Service 222- - - - - - - - - - - - - 1,450 0% 321 Business License 101/222 30,917 - - - - - - - - - - - 30,917 120,130 26% 321 Code and Animal Fees 600 4,536 - - - - - - - - - - - 4,536 54,500 8% 322 Building Fees 600 90,363 - - - - - - - - - - - 90,363 1,360,350 7% 322 Code Enforcement Fees 600 1,050 - - - - - - - - - - - 1,050 20,000 5% 322 EMS Operating Fund 288 1,923 - - - - - - - - - - - 1,923 24,000 8% 322 General Government Fees 101 32,047 - - - - - - - - - - - 32,047 100,000 32% 341 General Government Various various 3,316 - - - - - - - - - - - 3,316 27,005 12% 342 Highway & Streets 101/202 38,686 - - - - - - - - - - - 38,686 223,365 17% 342 Public Safety various 12,869 - - - - - - - - - - - 12,869 150,000 9% 342 EMS - County Fees 288- - - - - - - - - - - - - 1,740,000 0% 342 EMS - Capital Fund 287- - - - - - - - - - - - - 1,275,000 0% 342 EMS - Operating Fund 288 160,939 - - - - - - - - - - - 160,939 2,700,000 6% 342 EMS - Neo Natal / Transport 288 16,185 - - - - - - - - - - - 16,185 1,699,512 1% 344 Solid Waste 610 445,203 - - - - - - - - - - - 445,203 5,636,175 8% 344 Code Environmental Clean Up 101/219/600 12,404 - - - - - - - - - - - 12,404 180,000 7% 344 Sewage Waste Water 641 3,208,590 - - - - - - - - - - - 3,208,590 37,020,404 9% 344 Sewer Repair Insurance 640 53,614 - - - - - - - - - - - 53,614 613,924 9% 344 Water Leak Insurance 620 81,303 - - - - - - - - - - - 81,303 1,173,361 7% 346 Water Works Utility 620 1,039,872 - - - - - - - - - - - 1,039,872 16,175,473 6% 346 Solid Waste Misc 610 1,504 - - - - - - - - - - - 1,504 110,000 1% 346 Project ReLeaf 655 36,802 - - - - - - - - - - - 36,802 440,153 8% 347 Parks & Recreation various 74,837 - - - - - - - - - - - 74,837 4,337,134 2% 347 Sale of Merchandise 101- - - - - - - - - - - - - 100 0% 347 Morris PAC 416- - - - - - - - - - - - - 100,000 0% 349 Parking Garage Fees 601 115,464 - - - - - - - - - - - 115,464 986,129 12% 349 Code Demolition Board Up 219/600 2,805 - - - - - - - - - - - 2,805 90,000 3% 349 Parking Century Center 670 12,814 - - - - - - - - - - - 12,814 100,033 13% 349 Parking SBCDA 324/420429 350 - - - - - - - - - - - 350 - NA 351 Fines & Fees various 27,430 - - - - - - - - - - - 27,430 252,720 11% 352 Forfeits various 734 - - - - - - - - - - - 734 200,000 0% 354 Ordinance Violation various 5,163 - - - - - - - - - - - 5,163 72,500 7% 360 Morris PAC various 10,087 - - - - - - - - - - - 10,087 976,000 1% 360 Palais Royale various 24,371 - - - - - - - - - - - 24,371 256,572 9% 360 Parks & Recreation various 9,055 - - - - - - - - - - - 9,055 94,206 10% 360 Police various 4,432 - - - - - - - - - - - 4,432 25,000 18% 360 Fire various- - - - - - - - - - - - - - NA 360 TIF various 31,545 - - - - - - - - - - - 31,545 52,725 60% 360 Central Services 222 608 - - - - - - - - - - - 608 11,000 6% 360 Century Center 670- - - - - - - - - - - - - 10,000 0% 360 Dept. Of Community Investment 211/212 65,547 - - - - - - - - - - - 65,547 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- - - - - - - - - - - - - 11,000 0% 360 Fire and Police Pension Fund 701/702 1,523 - - - - - - - - - - - 1,523 2,000 76% 360 Self Funded Employee Benefits 711- - - - - - - - - - - - - - NA 360 Industrial Revolving 754- - - - - - - - - - - - - 27,000 360 General Government Various 101/3/226 13,427 - - - - - - - - - - - 13,427 14,000 96% 360 Motor Veh Highway Scrap Metal 202 285 - - - - - - - - - - - 285 4,896 6% 2017-01 Fin anc i al Re port Janu ary - R eve nue Report Page 4 of 25 City of South Bend Period Ending:January 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 Motor Veh Highway Curb Prgm 202 11 - - - - - - - - - - - 11 32,000 0% 360 Local Roads and Streets 251- - - - - - - - - - - - - - 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 - - - - - - - - - - - 170 6,500 3% 360 Building Fees 600- - - - - - - - - - - - - - NA 360 Parking Garage 601 20 - - - - - - - - - - - 20 11,282 0% 360 Solid Waste Fund 610- - - - - - - - - - - - - 2,000 0% 360 Waste Water 641/7/9- - - - - - - - - - - - - 52,500 0% 360 Water Works Utility 620- - - - - - - - - - - - - 25,000 0% 360 Water Works Bond Reserve 626- - - - - - - - - - - - - - NA 362 Dept. Of Community Investment 212 1,847 - - - - - - - - - - - 1,847 - NA 362 Palais Royale 101- - - - - - - - - - - - - 82,500 0% 362 Police 101- - - - - - - - - - - - - 48,000 0% 362 Parks & Recreation 201 3,786 - - - - - - - - - - - 3,786 43,500 9% 362 S Bend School Corp Fee 407- - - - - - - - - - - - - 25,000 0% 362 Certified Technology Park 439- - - - - - - - - - - - - - NA 362 TIF Property various 14,223 - - - - - - - - - - - 14,223 319,603 4% 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 - - - - - - - - - - - 260,617 2,809,278 9% 399 Bosch Retention Project 210- - - - - - - - - - - - - 63,661 0% 399 Principal on Loan various 19,897 - - - - - - - - - - - 19,897 76,374 26% 399 Principal Income various 30,702 - - - - - - - - - - - 30,702 1,703,614 2% Sub Total 6,172,987 - - - - - - - - - - - 6,172,987 84,150,629 7% Interest Income 361 Bank Account Interest various 156,963 - - - - - - - - - - - 156,963 1,634,789 10% Sub Total 156,963 - - - - - - - - - - - 156,963 1,634,789 10% Donations 367 ND Contribution 101- - - - - - - - - - - - - 337,500 0% 367 Donations various 75,816 - - - - - - - - - - - 75,816 25,250 300% Sub Total 75,816 - - - - - - - - - - - 75,816 362,750 21% Historic Preservation 368 Lamppost Program 227- - - - - - - - - - - - - - NA 368 C.O.I.T.404- - - - - - - - - - - - - - 368 Palais 450 1,838 - - - - - - - - - - - 1,838 16,500 11% Sub Total 1,838 - - - - - - - - - - - 1,838 16,500 11% Sale of Assets 391 TIF (Property Sales / Land)various- - - - - - - - - - - - - 77,331 0% 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- - - - - - - - - - - - - 115,331 0% Revenue Total 15,541,356 - - - - - - - - - - - 15,541,356 320,865,097 5% report 15,541,356 - - - - - - - - - - - 15,541,356 320,865,097 - - - - - - - - - - - - - - 2017-01 Fin anc i al Re port Janu ary - R eve nue Report Page 5 of 25 City of South Bend Period Ending:January 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,105,267 56,530,002 2% 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,135,996 56,618,029 2% Public Works 0602 Engineering 101 32,047 - - - - - - - - - - - 32,047 317,337 10% Sub Total 32,047 - - - - - - - - - - - 32,047 317,337 10% Public Safety 0801 Police 101 34,608 - - - - - - - - - - - 34,608 326,500 11% 0901 Fire 101 4,387 - - - - - - - - - - - 4,387 1,500 292% Sub Total 38,995 - - - - - - - - - - - 38,995 328,000 12% 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 - - - - - - - - - - - 10,888 965,000 1% 0405 Palais Royale 101 26,265 - - - - - - - - - - - 26,265 358,902 7% xxx xxx- NA Sub Total 37,153 - - - - - - - - - - - 37,153 1,323,902 3% General Fund Revenue Total 1,244,191 - - - - - - - - - - - 1,244,191 58,587,268 2% 2017-01 Financial Report J anuary - Rev enue Summar y Page 6 of 25 City of South Bend Period Ending:January 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 - - - - - - - - - - - 2,200 9,973,007 0% 1100 Administration 201 3,787 - - - - - - - - - - - 3,787 43,600 9% 1101 Maintenance 201 28,074 - - - - - - - - - - - 28,074 1,215,363 2% 1102 Golf Operations 201 1,356 - - - - - - - - - - - 1,356 1,519,934 0% 1103 Recreation Division 201 22 - - - - - - - - - - - 22 156,685 0% 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,681 1,381,787 5% East Race Waterway 271 1 - - - - - - - - - - - 1 - NA Coveleski Stadium 401 68 - - - - - - - - - - - 68 40,200 0% Zoo Endowment 403 37 - - - - - - - - - - - 37 200 19% Park Non Reverting 405 4,566 - - - - - - - - - - - 4,566 145,000 3% Sub Total 115,792 - - - - - - - - - - - 115,792 15,142,972 1% Public Works Motor Vehicle Highway 202 317,873 - - - - - - - - - - - 317,873 9,934,110 3% Central Services 222 675,986 - - - - - - - - - - - 675,986 8,298,569 8% Central Services Capital 224 84 - - - - - - - - - - - 84 287,600 0% Local Roads & Streets 251 106,827 - - - - - - - - - - - 106,827 1,344,000 8% Local Road & Bridge Grant 265- - - - - - - - - - - - - - NA Project ReLeaf 655 37,450 - - - - - - - - - - - 37,450 444,556 8% Sub Total 1,138,220 - - - - - - - - - - - 1,138,220 20,308,835 6% Public Works Solid Waste Solid Waste Operations 610 445,931 - - - - - - - - - - - 445,931 5,782,675 8% Solid Waste Capital 611 179 - - - - - - - - - - - 179 835,813 0% Sub Total 446,110 - - - - - - - - - - - 446,110 6,618,488 7% Public Works Water Utility 0000 Water Works Revenues 620 973,972 - - - - - - - - - - - 973,972 15,080,627 6% 0630 Water Leak Insurance 620 81,303 - - - - - - - - - - - 81,303 1,173,361 7% 0660 Clay Water 620 72,507 - - - - - - - - - - - 72,507 1,265,346 6% Waterworks Capital 622 1,942 - - - - - - - - - - - 1,942 15,000 13% Waterworks Construction 623- - - - - - - - - - - - - - NA Waterworks Deposit 624 1,159 - - - - - - - - - - - 1,159 15,000 8% Waterworks Sinking 625 164,824 - - - - - - - - - - - 164,824 2,054,891 8% Waterworks Bond Reserve 626 1,154 - - - - - - - - - - - 1,154 16,000 7% Waterworks Debt Reserve 629 153,121 - - - - - - - - - - - 153,121 97,500 157% Sub Total 1,449,981 - - - - - - - - - - - 1,449,981 19,717,725 7% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 54,941 - - - - - - - - - - - 54,941 621,788 9% 0000 Wastewater Revenues 641 3,044,674 - - - - - - - - - - - 3,044,674 34,932,744 9% 0621 Sewer Department 641- - - - - - - - - - - - - 2,500 0% 0625 Concrete Crew 641- - - - - - - - - - - - - 74,500 0% 0630 Wastewater Operations 641- - - - - - - - - - - - - - NA 0631 Organic Resources 641- - - - - - - - - - - - - - NA 0650 Clay Sewage 641 177,865 - - - - - - - - - - - 177,865 2,162,160 8% Sewage Capital 642 5,472 - - - - - - - - - - - 5,472 4,487,000 0% Sewage Reserve 643 3,481 - - - - - - - - - - - 3,481 53,721 6% Sewer Bond 2007 647- - - - - - - - - - - - - - NA Sewage Bond Sinking 649 763,195 - - - - - - - - - - - 763,195 9,177,024 8% Sewer Bond 2007B 651- - - - - - - - - - - - - - NA Sewage Works DS Reserve 653- - - - - - - - - - - - - 4,400 0% 2010 CSO Net Sewer Bond 658- - - - - - - - - - - - - - NA 2011 Sewer Bond 659 41 - - - - - - - - - - - 41 - NA 2012 Sewer Bond 661 2,379 - - - - - - - - - - - 2,379 50,000 5% 2013A Sewer Refund Bonds 664- - - - - - - - - - - - - - NA 2015 Sewer Refund Bonds 666- - - - - - - - - - - - - - NA Sub Total 4,052,047 - - - - - - - - - - - 4,052,047 51,565,837 8% 2017-01 Financial Report J anuary - Rev enue Summar y Page 7 of 25 City of South Bend Period Ending:January 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 - - - - - - - - - - - 10,276 36,000 29% Curfew Violations 218 9 - - - - - - - - - - - 9 1,000 1% Law Enforcement Education 220 31,608 - - - - - - - - - - - 31,608 221,500 14% Public Safety LOIT 249 622,980 - - - - - - - - - - - 622,980 7,473,618 8% Excess Welfare Public Safety 252- - - - - - - - - - - - - - NA Police Take Home Vehicle 278 561 - - - - - - - - - - - 561 126,200 0% Police Block Grant 280 3 - - - - - - - - - - - 3 - NA Police Grants 292- - - - - - - - - - - - - - NA Police Academy 294 5,456 - - - - - - - - - - - 5,456 22,500 24% COPS More Grants 295 1,055 - - - - - - - - - - - 1,055 92,000 1% Drug Enforcement 299 149 - - - - - - - - - - - 149 32,000 0% K-9 Unit 705 2 - - - - - - - - - - - 2 2,020 0% Sub Total 672,099 - - - - - - - - - - - 672,099 8,006,838 8% Public Safety - Fire Emergency Telephone System 244- - - - - - - - - - - - - - NA EMS Capital 287 2,726 - - - - - - - - - - - 2,726 1,285,000 0% EMS Operating Fund 288 181,987 - - - - - - - - - - - 181,987 6,350,012 3% Hazmat 289 19 - - - - - - - - - - - 19 10,000 0% River Rescue 291 114 - - - - - - - - - - - 114 45,500 0% Sub Total 184,846 - - - - - - - - - - - 184,846 7,690,512 2% Department of Community Investment Studebaker/Oliver 209 25,242 - - - - - - - - - - - 25,242 104,000 24% State Grant 210 242 - - - - - - - - - - - 242 73,512 0% DCI Operating 211 10,748 - - - - - - - - - - - 10,748 2,291,309 0% 0000 Dept. of Community Investment 212 310,284 - - - - - - - - - - - 310,284 3,254,000 10% xxx Programs 212 93,743 - - - - - - - - - - - 93,743 - NA 0000 Economic Revenue Bond 281 21 - - - - - - - - - - - 21 200 10% Sub Total 440,280 - - - - - - - - - - - 440,280 5,723,021 8% Parking Garages 0000 Parking Garage Revenue 601 284 - - - - - - - - - - - 284 4,000 7% 0460 Main Street 601 25,906 - - - - - - - - - - - 25,906 267,966 10% 0462 Leighton Plaza 601 58,466 - - - - - - - - - - - 58,466 487,484 12% 0463 Enforcement 601 4,969 - - - - - - - - - - - 4,969 80,000 6% 0464 Wayne Street 601 30,977 - - - - - - - - - - - 30,977 241,961 13% 0465 Eddy Street Commons 601- - - - - - - - - - - - - 15,900 0% Sub Total 120,601 - - - - - - - - - - - 120,601 1,097,311 11% Capital / Debt Service Hall of Fame 313 50 - - - - - - - - - - - 50 1,269,000 0% COIT 404 913,313 - - - - - - - - - - - 913,313 10,680,407 9% Cum Capital Development 406 357 - - - - - - - - - - - 357 476,500 0% Cum Capital Improvement 407 150,226 - - - - - - - - - - - 150,226 435,000 35% EDIT 408 1,041,459 - - - - - - - - - - - 1,041,459 10,998,021 9% UDAG 410 445 - - - - - - - - - - - 445 6,110 7% Major Moves 412 1,774 - - - - - - - - - - - 1,774 1,502,472 0% Morris PAC Improvement 416 436 - - - - - - - - - - - 436 104,000 0% CRED 434- - - - - - - - - - - - - - NA Palais Historic Preservation 450 1,907 - - - - - - - - - - - 1,907 17,100 11% Hall of Fame Capital 677 372 - - - - - - - - - - - 372 5,000 7% SB Building Corp 755- - - - - - - - - - - - - 2,643,214 0% Parks Bond Debt Svc 757- - - - - - - - - - - - - 391,482 0% xxx xxx xxx- - - - - - - - - - - NA Sub Total 2,110,340 - - - - - - - - - - - 2,110,340 28,528,306 7% 2017-01 Financial Report J anuary - Rev enue Summar y Page 8 of 25 City of South Bend Period Ending:January 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,644 60,000 13% Excess Levy 103- - - - - - - - - - - - - - NA Gift, Donation, Bequest 217 50,900 - - - - - - - - - - - 50,900 18,800 271% Unsafe Building 219 11,928 - - - - - - - - - - - 11,928 793,757 2% Landlord Registration 221 2,260 - - - - - - - - - - - 2,260 1,000 226% Loss Recovery 227 730 - - - - - - - - - - - 730 1,000 73% LOIT 2016 Special Distribution 257- - - - - - - - - - - - - 1,318,000 0% Human Rights 258 91,498 - - - - - - - - - - - 91,498 165,040 55% Morris Palais Marketing 273 34 - - - - - - - - - - - 34 18,300 0% 311 Call Center 279 430,621 - - - - - - - - - - - 430,621 5,197,431 8% Professional Sports Development 377 80,547 - - - - - - - - - - - 80,547 732,000 11% 1201 Code Enforcement 600 12,749 - - - - - - - - - - - 12,749 1,810,451 1% 1207 Animal Control 600 4,706 - - - - - - - - - - - 4,706 789,865 1% 1306 Building Operations 600 92,341 - - - - - - - - - - - 92,341 1,368,350 7% Century Center 670 910,931 - - - - - - - - - - - 910,931 4,194,311 22% Century Center Capital 671 74 - - - - - - - - - - - 74 750 10% Century Center Energy Saving 672 6 - - - - - - - - - - - 6 192,297 0% Sub Total 1,696,966 - - - - - - - - - - - 1,696,966 16,661,352 10% Business Insurance 0000 Business Insurance Revenues 226 246,679 - - - - - - - - - - - 246,679 3,527,591 7% 0418 Workers Compensation 226 619 - - - - - - - - - - - 619 30,000 2% Sub Total 247,298 - - - - - - - - - - - 247,298 3,557,591 7% Fiduciary Trust & Agency Fire Pension 701 335 - - - - - - - - - - - 335 5,217,138 0% Police Pension 702 2,386 - - - - - - - - - - - 2,386 6,136,500 0% Employee Benefits 711 1,511,154 - - - - - - - - - - - 1,511,154 17,795,850 8% Unemployment Comp 713 217 - - - - - - - - - - - 217 83,000 0% City Cemetery Trust 730 22 - - - - - - - - - - - 22 200 11% Equipment / Vehicle Leasing 750- - - - - - - - - - - - - 5,500,000 0% Parks Bond Capital 751- - - - - - - - - - - - - 7,500 0% Smart Street Bond Capital 753- - - - - - - - - - - - - 17,000 0% Sub Total 1,514,115 - - - - - - - - - - - 1,514,115 34,757,188 4% Civil City Revenues 15,432,886 - - - - - - - - - - - 15,432,886 277,963,244 6% Tax Increment Financing TIF River West - Airport 324 78,976 - - - - - - - - - - - 78,976 22,763,295 0% TIF Central Development 420- - - - - - - - - - - - - - NA TIF West Washington 422 1,411 - - - - - - - - - - - 1,411 436,000 0% TIF Leighton Plaza 425 10,467 - - - - - - - - - - - 10,467 197,014 5% TIF Medical Service 426- - - - - - - - - - - - - - NA TIF River East DEV (NE)429 5,927 - - - - - - - - - - - 5,927 3,057,000 0% TIF Southside 430 3,108 - - - - - - - - - - - 3,108 3,881,127 0% TIF Erskine Village 432 3,646 - - - - - - - - - - - 3,646 6,000 61% TIF Douglas Road 435 77 - - - - - - - - - - - 77 327,858 0% TIF River East RES (NE RE)436 442 - - - - - - - - - - - 442 3,300,903 0% Sub Total 104,055 - - - - - - - - - - - 104,055 33,969,197 0% 2017-01 Financial Report J anuary - Rev enue Summar y Page 9 of 25 City of South Bend Period Ending:January 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 135 5% Certified Technology Park 439 1,614 - - - - - - - - - - - 1,614 - NA Airport Urban Enterprise Zone 454 288 - - - - - - - - - - - 288 3,900 7% Industrial Revolving 754- - - - - - - - - - - - - 210,000 0% Sub Total 1,908 - - - - - - - - - - - 1,908 214,035 1% Debt Service Airport Debt Reserve 2003 315 780 - - - - - - - - - - - 780 14,000 6% Coveleski Bond Debt Reserve 317 385 - - - - - - - - - - - 385 5,000 8% Central Development reserve 328 1,303 - - - - - - - - - - - 1,303 15,000 9% SB Redevelopment Authority 752- - - - - - - - - - - - - 3,868,169 0% Smart Streets Debt Svc 756- - - - - - - - - - - - - 855,784 0% Erskine Village Debt. Svc 758- - - - - - - - - - - - - 3,960,668 0% Sub Total 2,468 - - - - - - - - - - - 2,468 8,718,621 0% Redevelopment Commission 108,431 - - - - - - - - - - - 108,431 42,901,853 0% City Operations Total 15,541,356 - - - - - - - - - - - 15,541,356 320,865,097 5% Revenue report 15,541,356 0 0 0 0 0 0 0 0 0 0 0 15,541,356 320,865,097 (0)0 0 0 0 0 0 0 0 0 0 0(0)0 2017-01 Financial Report J anuary - Rev enue Summar y Page 10 of 25 City of South Bend Period Ending:January 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-01 Financial Report January - Property Tax Revenue Page 11 of 25 City of South Bend Period Ending:January 31, 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-01 Financial Report January - Property Tax Revenue Page 12 of 25 City of South Bend Period Ending:January 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 - - - - - - - - - - - 59,009 872,923 7% 0104 311 Call Center 101- - - - - - - - - - - - - - NA 0201 Clerk 101 38,451 - - - - - - - - - - - 38,451 536,216 7% 0301 Common Council 101 33,451 - - - - - - - - - - - 33,451 571,148 6% 0302 WNIT Contract 101- - - - - - - - - - - - - 43,000 0% 0401 Administration and Finance 101 184,278 - - - - - - - - - - - 184,278 2,476,351 7% 0501 Legal Department 101 87,585 - - - - - - - - - - - 87,585 1,158,567 8% Sub Total 402,773 - - - - - - - - - - - 402,773 5,658,205 7% Public Works 0602 Engineering 101 81,736 - - - - - - - - - - - 81,736 1,445,157 6% Sub Total 81,736 - - - - - - - - - - - 81,736 1,445,157 6% Public Safety 0801 Police 101 2,401,801 - - - - - - - - - - - 2,401,801 29,668,433 8% 0805 Police -PS LOIT funded 101- - - - - - - - - - - - - - NA 0802 Police Communications 101- - - - - - - - - - - - - - NA 0901 Fire 101 1,586,894 - - - - - - - - - - - 1,586,894 20,968,466 8% 0905 Fire-PS LOIT funded 101- - - - - - - - - - - - - - NA Sub Total 3,988,695 - - - - - - - - - - - 3,988,695 50,636,899 8% Code Enforcement 1201 Code 101- - - - - - - - - - - - - NA Sub Total- - - - - - - - - - - - - - NA Arts & Culture 0404 Morris PAC 101 74,731 - - - - - - - - - - - 74,731 1,271,039 6% 0405 Palais Royale 101 24,999 - - - - - - - - - - - 24,999 530,200 5% Sub Total 99,730 - - - - - - - - - - - 99,730 1,801,239 6% Human Rights 1008 Human Rights 101 37,821 - - - - - - - - - - - 37,821 425,805 9% Sub Total 37,821 - - - - - - - - - - - 37,821 425,805 9% General Fund Expenditure Total 4,610,756 - - - - - - - - - - - 4,610,756 59,967,305 8% 2017-01 Financial Report J anuary - Expenditure Su mm ary Page 13 of 25 City of South Bend Period Ending:January 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 - - - - - - - - - - - 147,654 1,468,296 10% 1101 Maintenance 201 399,021 - - - - - - - - - - - 399,021 6,588,961 6% 1102 Golf Operations 201 54,483 - - - - - - - - - - - 54,483 1,638,575 3% 1103 Recreation Division 201 165,251 - - - - - - - - - - - 165,251 2,153,817 8% 1104 Potawatomi Zoo 201 355,692 - - - - - - - - - - - 355,692 704,464 50% 1106 Potawatomi Greenhouse 201 5,013 - - - - - - - - - - - 5,013 54,408 9% 1108 Graffiti Removal 201 13,483 - - - - - - - - - - - 13,483 97,861 14% 1110 Marketing and Events 201 16,583 - - - - - - - - - - - 16,583 953,588 2% Recreation Non Reverting 203 51,478 - - - - - - - - - - - 51,478 1,599,683 3% 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 - - - - - - - - - - - 45,874 228,024 20% Sub Total 1,254,532 - - - - - - - - - - - 1,254,532 15,568,732 8% Public Works Motor Vehicle Highway 202 919,033 - - - - - - - - - - - 919,033 9,686,533 9% Curb and Sidewalk 202 150,920 - - - - - - - - - - - 150,920 1,878,998 8% Central Services 222 730,352 - - - - - - - - - - - 730,352 8,554,643 9% Central Services Capital 224 10,575 - - - - - - - - - - - 10,575 326,025 3% Local Roads & Streets 251 209,999 - - - - - - - - - - - 209,999 2,086,544 10% Project ReLeaf 655 15,049 - - - - - - - - - - - 15,049 525,416 3% Sub Total 2,035,929 - - - - - - - - - - - 2,035,929 23,058,159 9% Public Works Solid Waste Solid Waste Operations 610 489,623 - - - - - - - - - - - 489,623 5,662,910 9% Solid Waste Capital 611 286,902 - - - - - - - - - - - 286,902 1,135,613 25% Sub Total 776,525 - - - - - - - - - - - 776,525 6,798,523 11% Public Works Water Utility 0630 Water Leak Insurance 620 43,958 - - - - - - - - - - - 43,958 1,035,000 4% 0640 Water Works 620 1,417,876 - - - - - - - - - - - 1,417,876 16,688,754 8% 0660 Clay Water 620- - - - - - - - - - - - - 3,500 0% Waterworks Capital 622 111,938 - - - - - - - - - - - 111,938 1,414,466 8% Waterworks Deposit 624 874 - - - - - - - - - - - 874 15,000 6% Waterworks Sinking 625 815 - - - - - - - - - - - 815 2,054,891 0% Waterworks Bond Reserve 626- - - - - - - - - - - - - 16,000 0% Waterworks Debt Reserve 629 1,394 - - - - - - - - - - - 1,394 23,000 6% Sub Total 1,576,855 - - - - - - - - - - - 1,576,855 21,250,611 7% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 48,400 - - - - - - - - - - - 48,400 534,509 9% 0621 Sewer Repair 641 517,647 - - - - - - - - - - - 517,647 9,248,687 6% 0625 Concrete Crew 641 30,239 - - - - - - - - - - - 30,239 474,389 6% 0630 Wastewater Operations 641 2,358,990 - - - - - - - - - - - 2,358,990 33,209,563 7% 0631 Organic Resources 641 124,773 - - - - - - - - - - - 124,773 1,608,946 8% 0650 Clay Sewage 641- - - - - - - - - - - - - 750 0% Sewage Capital 642 1,298,328 - - - - - - - - - - - 1,298,328 7,640,455 17% Sewage Reserve 643 2,625 - - - - - - - - - - - 2,625 30,000 9% Sewage Bond Sinking 649 1,000 - - - - - - - - - - - 1,000 9,163,754 0% 2011 Sewer Bond 659- - - - - - - - - - - - - 11,617 0% 2012 Sewer Bond 661 3,000 - - - - - - - - - - - 3,000 3,010,364 0% 2013A Sewer Bond 664- - - - - - - - - - - - - 4,550 0% 2014 Sewer Bond 665- - - - - - - - - - - - - - NA 2015 Sewer Bond 666- - - - - - - - - - - - - 9,205 0% Sub Total 4,385,001 - - - - - - - - - - - 4,385,001 64,946,789 7% 2017-01 Financial Report J anuary - Expenditure Su mm ary Page 14 of 25 City of South Bend Period Ending:January 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 - - - - - - - - - - - 44,630 788,422 6% Emergency Telephone System 244- - - - - - - - - - - - - - NA Public Safety LOIT 249 466,245 - - - - - - - - - - - 466,245 7,462,645 6% Excess Welfare Public Safety 252- - - - - - - - - - - - - 8 0% LOIT 2016 Special Distribution 257 21,360 - - - - - - - - - - - 21,360 2,757,457 1% Police Take Home Vehicle 278- - - - - - - - - - - - - 10,000 0% Police Grants 292 2,796 - - - - - - - - - - - 2,796 10,805 26% Police Academy 294 162 - - - - - - - - - - - 162 22,500 1% COPS More Grants 295 10,980 - - - - - - - - - - - 10,980 155,467 7% Drug Enforcement 299 11,242 - - - - - - - - - - - 11,242 196,337 6% K-9 Unit 705- - - - - - - - - - - - - 2,020 0% Sub Total 557,416 - - - - - - - - - - - 557,416 11,442,661 5% Public Safety - Fire EMS Capital 287 235,792 - - - - - - - - - - - 235,792 2,700,377 9% EMS Operating Fund 288 438,601 - - - - - - - - - - - 438,601 5,980,914 7% Hazmat 289 430 - - - - - - - - - - - 430 10,431 4% River Rescue 291 1,443 - - - - - - - - - - - 1,443 89,349 2% xxx xxx xxx- - - - - - - - - - - - - NA Sub Total 676,266 - - - - - - - - - - - 676,266 8,781,071 8% Department of Community Investment Studebaker/Oliver 209 70,702 - - - - - - - - - - - 70,702 539,393 13% State Grant 210- - - - - - - - - - - - - 509,757 0% DCI Operating 211 197,318 - - - - - - - - - - - 197,318 2,650,376 7% 1001 Dept. of Community Investment 212 575,173 - - - - - - - - - - - 575,173 5,455,838 11% 1003 Administration 212- - - - - - - - - - - - - - NA xxx Programs 212- - - - - - - - - - - - - - NA Sub Total 843,192 - - - - - - - - - - - 843,192 9,155,364 9% Parking Garages 0400 General Administration 601- - - - - - - - - - - - - - NA 0460 Main Street 601 10,017 - - - - - - - - - - - 10,017 261,894 4% 0462 Leighton Plaza 601 20,044 - - - - - - - - - - - 20,044 596,368 3% 0463 Enforcement 601 7,858 - - - - - - - - - - - 7,858 128,675 6% 0464 Wayne Street 601 12,364 - - - - - - - - - - - 12,364 244,417 5% 0465 Eddy Street Commons 601- - - - - - - - - - - - - 15,900 0% Sub Total 50,284 - - - - - - - - - - - 50,284 1,247,254 4% Capital / Debt Service Hall of Fame 313 635,000 - - - - - - - - - - - 635,000 1,268,999 50% COIT 404 1,172,640 - - - - - - - - - - - 1,172,640 11,921,593 10% Cum Capital Development 406 112,650 - - - - - - - - - - - 112,650 476,500 24% Cum Capital Improvement 407 185,125 - - - - - - - - - - - 185,125 372,250 50% EDIT 408 697,093 - - - - - - - - - - - 697,093 11,501,484 6% 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 - - - - - - - - - - - 3,866 81,091 5% SB Building Corp 755- - - - - - - - - - - - - 2,643,214 0% Parks Bond Debt 757- - - - - - - - - - - - - 391,482 0% Sub Total 2,838,027 - - - - - - - - - - - 2,838,027 31,364,609 9% 2017-01 Financial Report J anuary - Expenditure Su mm ary Page 15 of 25 City of South Bend Period Ending:January 31, 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 - - - - - - - - - - - 72,000 38,700 186% Unsafe Building 219 80,336 - - - - - - - - - - - 80,336 902,746 9% Landlord Registration 221 5 - - - - - - - - - - - 5 1,000 1% Loss Recovery 227- - - - - - - - - - - - - 598,675 0% Human Rights 258 17,100 - - - - - - - - - - - 17,100 201,773 8% Morris Palais Marketing 273 2,798 - - - - - - - - - - - 2,798 21,675 13% 311 Call Center 279 325,330 - - - - - - - - - - - 325,330 5,205,034 6% Professional Sports Development 377 467,640 - - - - - - - - - - - 467,640 827,955 56% 1201 Code Enforcement 600 128,453 - - - - - - - - - - - 128,453 1,625,378 8% 1207 Animal Control 600 68,101 - - - - - - - - - - - 68,101 790,517 9% 1209 Illegal Dumping Crew 600- - - - - - - - - - - - - - NA 1306 Building Operations 600 110,343 - - - - - - - - - - - 110,343 1,361,925 8% Century Center 670 282,027 - - - - - - - - - - - 282,027 4,194,310 7% Century Center Capital 671- - - - - - - - - - - - - - NA Century Center Energy Saving 672- - - - - - - - - - - - - 192,297 0% Sub Total 1,554,131 - - - - - - - - - - - 1,554,131 15,961,985 10% Business Insurance 0403 Self Funded Liability Ins 226 17,866 - - - - - - - - - - - 17,866 235,471 8% 0412 Liability Insurance 226 45,537 - - - - - - - - - - - 45,537 2,034,051 2% 0417 Business Insurance 226 45,354 - - - - - - - - - - - 45,354 595,678 8% 0418 Workers Compensation 226 119,520 - - - - - - - - - - - 119,520 722,386 17% Sub Total 228,276 - - - - - - - - - - - 228,276 3,587,586 6% Fiduciary Trust & Agency Fire Pension 701 388,455 - - - - - - - - - - - 388,455 5,098,269 8% Police Pension 702 513,053 - - - - - - - - - - - 513,053 6,423,889 8% Employee Benefits 711 1,060,085 - - - - - - - - - - - 1,060,085 17,803,200 6% Unemployment Comp 713 6,038 - - - - - - - - - - - 6,038 84,105 7% City Cemetery Trust 730- - - - - - - - - - - - 6,000 0% Equipment / Vehicle Leasing 750- - - - - - - - - - - - 5,500,000 0% Parks Bond Capital 751- - - - - - - - - - - - 3,500,000 0% Smart Street Bond 753- - - - - - - - - - - - 10,000,000 0% xxx xxx xxx NA Sub Total 1,967,632 - - - - - - - - - - - 1,967,632 48,415,463 4% Civil City Expenditure 23,354,822 - - - - - - - - - - - 23,354,822 321,546,112 7% Tax Increment Financing TIF River West - Airport 324 4,348,398 - - - - - - - - - - - 4,348,398 37,618,887 12% TIF West Washington 422- - - - - - - - - - - - - 1,428,292 0% TIF Leighton Plaza 425 5,141 - - - - - - - - - - - 5,141 158,166 3% TIF River East DEV (NE)429 27,144 - - - - - - - - - - - 27,144 10,602,696 0% TIF Southside 430 146,124 - - - - - - - - - - - 146,124 6,917,426 2% TIF Erskine Village 432 3,961,667 - - - - - - - - - - - 3,961,667 4,848,795 82% TIF Douglas Road 435- - - - - - - - - - - - - 344,216 0% TIF River East RES (NE RE)436 1,236,500 - - - - - - - - - - - 1,236,500 3,430,231 36% Sub Total 9,724,973 - - - - - - - - - - - 9,724,973 65,348,709 15% 2017-01 Financial Report J anuary - Expenditure Su mm ary Page 16 of 25 City of South Bend Period Ending:January 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- - - - - - - - - - - - - 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 - - - - - - - - - - - 588 14,000 4% Central Development reserve 328 983 - - - - - - - - - - - 983 15,000 7% SB Redevelopment Authority 752- - - - - - - - - - - - - 3,868,169 0% Smart Streets Debt Svc 756- - - - - - - - - - - - - 855,784 0% Erskine Village Debt Svc 758- - - - - - - - - - - - - 4,521,668 0% xxx xxx xxx NA Sub Total 1,571 - - - - - - - - - - - 1,571 9,274,621 0% Redevelopment Commission 9,726,545 - - - - - - - - - - - 9,726,545 74,834,830 13% City Operations Total 33,081,366 - - - - - - - - - - - 33,081,366 396,367,179 8% Expenditure report 33,081,366 0 0 0 0 0 0 0 0 0 0 0 33,081,366 396,367,179 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2017-01 Financial Report J anuary - Expenditure Su mm ary Page 17 of 25 City of South Bend Period Ending:January 31, 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-01 Finan cial Report J a nuary - Debt Page 1 8 o f 25 City of South Bend Period Ending:January 31, 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-01 Finan cial Report J a nuary - Debt Page 1 9 o f 25 City of South Bend Period Ending:January 31, 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 1/3 1/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 0.00 0.00 0.00 430,000.00 3 6 Sout h B end Building C orporation Pu bl ic W orks Building 200 1 201 0 20 21 40 4/649 2/1 8/1--9,250,00 0.00 2,755,000.00 0.00 0.00 0.00 2,755,000.00 2 5 Wat er Works Impr ovemen ts W ater W orks 200 2 201 2 20 23 62 5 7/1 12/3 1--5,975,00 0.00 2,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 0.00 0.00 0.00 8,885,000.00 2 4 Wat er Works Impr ovemen ts W ater W orks 200 6 20 27 62 5 7/1 12/3 1--4,710,00 0.00 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 0.00 0.00 0.00 5,145,000.00 13 3 St. Joseph Cou nty PS AP St. J oseph County PSA P 201 4 20 34 40 8 Monthly---2,657,69 6.50 2,386,507.92 0.00 0.00 0.00 2,386,507.92 paid thru 2/28/1 7 13 9 Cen tury Center En ergy Saving s Impro v ements C entury Ctr.201 5 20 31 67 2 5/1 11/1--4,167,89 7.00 4,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 0.00 0.00 0.00 5,295,000.00 14 5 Sewage W orks Reve nue Bon ds - 2015 Sewer B ond Improvements 201 5 20 25 64 9 6/1 12/1--27,440,00 0.00 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 0.00 0.00 0.00 129,741,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 106.59 3.57 0.00 650.18 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 0.00 0.00 0.00 926.68 10 6 Ricoh U SA C entra l Servi c es Copier 201 3 20 18 22 2 2/27 5/27 8/27 11/27 3,62 2.78 815.82 0.00 0.00 0.00 815.82 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 0.00 0.00 0.00 1,232.73 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 0.00 0.00 0.00 3,575.09 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 71.38 6.87 0.00 1,420.39 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 165.67 19.33 0.00 4,028.47 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 96.66 11.29 0.00 2,351.45 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 81.00 9.46 0.00 1,970.62 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 81.00 9.46 0.00 1,970.62 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 72.30 9.70 0.00 2,004.14 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 2,663.77 238.26 0.00 60,861.86 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 77.53 7.51 0.00 1,869.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 115.65 9.02 0.00 2,679.65 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 71.99 7.77 0.00 1,846.00 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 25.83 2.24 0.00 680.22 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 87.04 15.43 0.00 3,215.28 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 146.55 22.77 0.00 4,730.44 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 204.13 30.62 0.00 6,354.03 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 80.63 9.83 0.00 2,051.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 369.54 49.84 0.00 11,484.60 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 83.83 17.49 0.00 3,508.05 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 2,517.51 391.19 0.00 92,193.11 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 56.76 8.36 0.00 2,104.30 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 65.75 16.47 0.00 3,388.97 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 491.83 126.15 0.00 28,175.36 14 8 Cen tral Services Lanier C opier C 6502 201 6 20 20 22 2 Monthly---11,41 3.00 10,059.31 172.58 44.27 0.00 9,886.73 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 0.00 0.00 0.00 3,016,484.17 15 0 HP Computer Lease C omputer Leas e- Ref resh 201 6 20 20 40 4/64 1/620 Monthly---17,43 9.85 14,013.99 318.80 54.80 0.00 13,695.19 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 166.16 42.61 0.00 8,772.11 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 2,735.16 613.31 0.00 147,827.57 39 8 Venue, Parks, Ar t Copier R icoh Copier 201 6 20 21 20 1 Monthly 3,18 4.06 3,184.06 397.67 187.80 0.00 2,786.39 xxx T otal Cap ital L ease 30,212,98 7.87 16,078,945.72 1,2 91,723.75 69,358.71 0.00 14,787,221.97 To tal Civ i l C i ty 2 94,912,91 3.37 147,504,568.39 1,2 91,723.75 69,358.71 0.00 146,212,844.64 2 0 1 7-01 Finan cial Report J a nuary - Debt Page 2 0 o f 25 City of South Bend Period Ending:January 31, 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 1/3 1/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 0.00 0.00 0.00 720,000.00 8 College Foot ball H all of Fame H al l of Fame 199 4 2000/201 1 20 18 31 3 2/1 8/1--15,370,00 0.00 1,830,000.00 0.00 0.00 0.00 1,830,000.00 1 1 Sout h B end Building C orporation Mor ris P AC 199 8 200 9 20 17 40 8 2/1 8/1--13,300,00 0.00 515,000.00 0.00 0.00 0.00 515,000.00 1 2 TJX Sp eci al Taxing D is t rict 200 2 201 4 20 22 32 4/40 4/414 1/1 7/1--6,620,00 0.00 2,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 0.00 0.00 0.00 12,500,000.00 6 Airport Development Are a TIF Airport TIF 200 3 201 1 20 24 32 4 2/1 8/1--14,420,00 0.00 7,125,000.00 0.00 0.00 0.00 7,125,000.00 2 2 Erskin e V illage TIF Development Bond Er s ki ne Vil la ge 200 5 20 27 43 2 2/1 8/1--5,485,00 0.00 3,800,000.00 0.00 0.00 0.00 3,800,000.00 5 4 L ease Ren t al R evenu e B onds of 200 8 Eddy S t reet Co mmons 200 8 20 27 42 9 2/15 8/15--36,000,00 0.00 30,075,000.00 0.00 0.00 0.00 30,075,000.00 8 1 Coveles k i Stadi um Reco v ery C oveleski S tadium 201 0 20 19 37 7 1/15 7/15--4,980,00 0.00 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 0.00 0.00 25,000,000.00 xxx Total Bond Debt 1 53,788,78 8.00 85,640,000.00 3 25,000.00 42,640.00 0.00 85,315,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 0.00 0.00 0.00 323,005.00 8 4 In terfu nd F und 412 - Major Mov es Trian gle Development 201 1 20 29 43 6 2/15 8/15--2,000,00 0.00 1,329,573.43 0.00 0.00 0.00 1,329,573.43 8 5 In terfu nd F und 412 - Major Mov es Eddy S t reet Co mmons 201 1 20 26 43 6 2/15 8/15--4,100,00 0.00 2,384,347.86 0.00 0.00 0.00 2,384,347.86 8 6 In terfu nd F und 209 to Air port 324 Pr airie Ave Brownf ie ld Project 201 1 20 20 32 4 8/9---500,00 0.00 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 0.00 0.00 7 50,0 00.00 6,072,706.69 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 3 25,000.00 42,640.00 7 50,0 00.00 92,823,044.69 To tal Debt 4 69,839,47 8.43 239,919,688.58 1,6 16,723.75 111,998.71 7 50,0 00.00 239,035,889.33 2 0 1 7-01 Finan cial Report J a nuary - 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 - - - - - - 0 0 0 0 0 Part Time Staff 115 - 0 0 0 0 0 0 0 0 0 0 Temporary / Seasonal 12 - 0 0 0 0 0 0 0 0 0 0 City Total 1,207 - - - - - - 0 0 0 0 0 2017-01 Financial Report January - 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 0 0 0 0 0 0 0 0 0 0 0 311 Call Center 6 6 0 0 0 0 0 0 0 0 0 0 0 Admin & Finance 23 20 0 0 0 0 0 0 0 0 0 0 0 Innovation/ Technology Office 18 14 0 0 0 0 0 0 0 0 0 0 0 Safety & Risk 2 2 0 0 0 0 0 0 0 0 0 0 0 Clerk 5 5 0 0 0 0 0 0 0 0 0 0 0 Common Council 9 9 0 0 0 0 0 0 0 0 0 0 0 Legal Department 10 11 0 0 0 0 0 0 0 0 0 0 0 Sub Total 80 73 0 0 0 0 0 0 0 0 0 0 0 Code Enf. /Animal Control 29 20 0 0 0 0 0 0 0 0 0 0 0 Dept. of Community Investment 23 22 0 0 0 0 0 0 0 0 0 0 0 Parks & Recreation Administration 6 6 0 0 0 0 0 0 0 0 0 0 0 Maintenance 46 45 0 0 0 0 0 0 0 0 0 0 0 Golf Operations 8 7 0 0 0 0 0 0 0 0 0 0 0 Recreation Ops 25 22 0 0 0 0 0 0 0 0 0 0 0 Zoological Ops 1 1 0 0 0 0 0 0 0 0 0 0 0 Graffiti Removal 1 1 0 0 0 0 0 0 0 0 0 0 0 Recreation Non-reverting 1 1 Marketing and Events 10 8 0 0 0 0 0 0 0 0 0 0 0 Sub Total 98 91 0 0 0 0 0 0 0 0 0 0 0 Public Safety Police 289 284 0 0 0 0 0 0 0 0 0 0 0 Fire 264 268 0 0 0 0 0 0 0 0 0 0 0 Sub Total 553 552 0 0 0 0 0 0 0 0 0 0 0 Public Works Central Services 37 35 0 0 0 0 0 0 0 0 0 0 0 Office of Sustainability 2 2 0 0 0 0 0 0 0 0 0 0 0 Engineering 18 18 0 0 0 0 0 0 0 0 0 0 0 Maintenance 3 3 0 0 0 0 0 0 0 0 0 0 0 Solid Waste Operations 26 25 0 0 0 0 0 0 0 0 0 0 0 Unsafe Bldg Code Clean Crew 4 4 0 0 0 0 0 0 0 0 0 0 0 Street Operations 55 54 0 0 0 0 0 0 0 0 0 0 0 Sewer Operations 37 37 0 0 0 0 0 0 0 0 0 0 0 Waste Water Ops 45 45 0 0 0 0 0 0 0 0 0 0 0 Organic Resources 6 6 0 0 0 0 0 0 0 0 0 0 0 Water Utility Ops 71 64 0 0 0 0 0 0 0 0 0 0 0 Sub Total 304 293 0 0 0 0 0 0 0 0 0 0 0 Building Department 14 14 0 0 0 0 0 0 0 0 0 0 0 Human Rights 6 6 0 0 0 0 0 0 0 0 0 0 0 Morris & Palais 9 9 0 0 0 0 0 0 0 0 0 0 0 City Total 1,116 1,080 - - - - - - - - - - - 2017-01 Financial Report January - 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 0 0 0 0 0 0 0 0 0 0 0 311 Call Center 2 0 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 0 0 0 0 0 0 0 0 0 0 0 Sub Total 5 0 0 0 0 0 0 0 0 0 0 0 Code Enf. / Animal Control 3 0 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 0 0 0 0 0 0 0 0 0 0 0 Maintenance 11 0 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 0 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 0 0 0 0 0 0 0 0 0 0 0 Marketing & Events 1 0 0 0 0 0 0 0 0 0 0 0 Sub Total 65 0 0 0 0 0 0 0 0 0 0 0 Public Safety Police 25 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 25 0 0 0 0 0 0 0 0 0 0 0 Public Works` Central Services 1 0 0 0 0 0 0 0 0 0 0 0 Engineering 2 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 7 0 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 0 0 0 0 0 0 0 0 0 0 0 Sub Total 13 0 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 0 0 0 0 0 0 0 0 0 0 0 City Total 115 - 0 0 0 0 0 0 0 0 0 0 2017-01 Financial Report January - 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 0 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 0 0 0 0 0 0 0 0 0 0 0 Code Enfor. / Animal 1 0 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 0 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 0 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 0 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 0 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 0 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 - 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 0 0 0 0 0 0 0 0 0 0 0 City Total 12 0 0 0 0 0 0 0 0 0 0 0 2017-01 Financial Report January - Headcount Staffing Page 25 of 25