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