Loading...
HomeMy WebLinkAbout11-2015 Financial ReportPeriod Ending: Issued By: City of South Bend Financial Report Tab Page Contents Narrative 2 Brief discussion on notable fund activity Revenue 3-10 City Revenues Prop Tax Rev 11-12 Property Tax Revenue Collection Status Expenditures 13-17 Expenditures by Fund and Department Debt 18-19 Debt Status Debt Monthly 20-21 Current Debt at Month End Headcount 22-25 Staffing Levels Distribution Mayor Pete Buttigieg Chief of Staff James Mueller Deputy Chief of Staff Brian Pawlowski Controller John Murphy Deputy Controller Jennifer Hockenhull City Finance Director Rahman Johnson Sr. Budget Analyst Cecil Eastman Department Heads Fiscal Officers City Common Council November 30, 2015 Controller Financial Report November 2015 Page 1 of 25 November 30, 2015 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 294 (Police Academy). This is tuition revenue related to the advancement of present and future police officers. -Fund 289 (Hazmat). This fund has reached 99% of its budgeted revenue. This is revenue generated by the South Bend Fire Department responding to hazardous materials incidents. -Fund 643 (Sewage Reserve), is at 102% of its budgeted revenue. This is due to a transfer of $256,085 from fund 641 (Sewage Works Operations) for reserve purposes. -Fund 661 (2012 Sewer Bond), is at 231% or $52,361 over 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%.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 Headcount If you have any questions regarding this report, please contact John Murphy at (574) 235-7678. As of November 2015,the City has spent 66%of budgeted expenditures,compared to 63%of budgeted expenditures in November 2014. The General Fund has spent 86%of its 2015 budgeted expenditures,versus 88%in 2014.The following funds have reached 90%or more of their budgeted expenditures as a result of bond payments:Fund 313(Hall of Fame),Fund 407(Cumulative Capital Improvement),Fund 377 (Professional Sports Development), Fund 432 (TIF - Erskine Village), and Fund 436 (Northeast Residential TIF). In November 2015,several debt service payments were made in the amount of~$1.8 million to Sun Trust,Kansas State Bank,PNC Bank, U.S.Bank and Ricoh USA.Payments are related to IT equipment leases,police/public works vehicles,solid waste containers,and sewer bonds. The Full Time Headcount as of November 2015 was 1,071 vs.a budgeted amount of 1,094.Currently,there are a total of 23 vacant positions.The 23 open positions are in the following departments:Parks and Recreation(3),Public Safety(5),Public Works(10),Code Enforcement/Animal Control(1),Morris and Palais(1),and General Government(3).*In Public Safety(Fire),the headcount was over budget in prior months,as there were currently three recruits in training to replace planned and unplanned departures.Currently,the actual headcount matches the budgeted headcount. For discussion on property taxes,see section listed below.The overall percentage of budgeted revenues that have been received by the city is 81%,compared to 79%in November 2014.Revenue type 344(Code Clean Up),is at 236%of its budgeted revenue.This is revenue from fees for environmental clean up.Revenue type 350(Penalty Fee),has also reached 100%of its budgeted revenue.This is money from AJ Wright for penalties due to the City.Revenue type 367(donations),has reached 100%as well.This is money($330,000) donated by the University of Notre Dame, as part of its ten year pledge that will expire in 2018. As of November 30,2015,the general fund has received 69%of its budgeted revenue,compared to 65%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 thus far have totaled~$39.6 million.Civil city funds received ~$28 million and TIF funds received~$14.1 million.For 2015,the projected levy collection rate is 95%or$71.1 million.Please note,2015 Civil City funds are ~$273,000 more than 2014 budget and TIF funds are ~$1.3 million less than 2014 budget. - Funds 249 (PS LOIT), 404 (COIT), and 408 (EDIT) received normal and timely distributions this month. Financial Report November 2015 Page 2 of 25 City of South Bend Period Ending:November 30, 2015 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- - - - - 25,564,735 - - - 2,438,582 - 28,003,316 45,606,508 61% 311 Property Tax TIF Districts various- - - - - 14,121,026 - - - - - 14,121,026 24,526,104 58% Sub Total- - - - - 39,685,761 - - - 2,438,582 - - 42,124,343 70,132,612 60% Income Tax 315 Econ Development Income Tax 408 765,101 765,101 - 1,463,758 748,490 748,490 748,490 - 1,496,980 765,101 765,101 - 8,266,609 9,031,710 92% 316 Local Option Income Tax - PS 249 538,849 538,849 - 1,077,698 538,849 538,849 538,849 - 1,077,698 538,849 538,849 - 5,927,341 6,466,190 92% 316 County Option Income Tax 404 738,326 738,326 - 1,476,652 738,326 738,326 738,326 - 1,476,652 738,326 738,326 - 8,121,586 8,859,912 92% Sub Total 2,042,276 2,042,276 - 4,018,108 2,025,665 2,025,665 2,025,665 - 4,051,330 2,042,276 2,042,276 - 22,315,536 24,357,812 92% St Joseph County (Remitted by) 312 Auto Excise Tax various- - - - - 1,549,713 - - - - - - 1,549,713 2,508,752 62% 312 Commercial Vehicle Tax various- - - - - 465,648 - - - - - - 465,648 883,438 53% 317 Hotel Motel Tax Century Center 670- - 656,725 - - - 656,725 - - - - - 1,313,450 1,313,436 100% 317 Hotel Motel Tax Century Center 324 292,000 200,000 492,000 490,500 100% 317 Hotel Motel Tax Cum Cap Imprv 407- - - - - - 150,000 - - - - - 150,000 150,000 100% Sub Total- - 656,725 292,000 - 2,015,361 806,725 - - 200,000 - - 3,970,811 5,346,126 74% State of Indiana (Remitted by) 312 CRED Tax 434- - - - - - - - - - - - - 150 0% 335 Cigarette Tax 101/407- - - - - 149,739 - - - - - - 149,739 317,818 47% 335 State Pension Subsidy 701/702- - - - - 5,705,692 - - 5,711,692 - - - 11,417,384 11,411,384 100% 335 Gaming Proceeds 101- - - - - - - - 599,027 - - - 599,027 600,000 100% 335 Gasoline Tax 202/251 348,926 369,636 422,676 426,523 435,833 373,229 381,514 467,969 391,826 385,115 355,334 - 4,358,582 4,692,000 93% 335 Liquor Excise tax 101 41,349 - - - - - 23,001 - - - - - 64,350 65,000 99% 335 Liquor Gallonage Tax 101 67,259 - - 30,798 - - 60,184 - - 53,678 - - 211,919 211,919 100% 335 Prof Sports Development Tax 377 63,326 142,874 63,470 35,855 29,251 42,734 102,397 - 44,865 43,419 60,070 - 628,261 747,750 84% 335 Wheel Tax 202 418,779 - 67,941 392,533 215,701 - - 529,741 - - 349,493 - 1,974,188 2,050,000 96% Sub Total 939,639 512,510 554,087 885,709 680,785 6,271,395 567,096 997,710 6,747,410 482,213 764,897 - 19,403,451 20,096,021 97% Other Intergovernmental Sources 336 Federal Drug 299 1,729 - 31,642 12,460 17,914 - - - - - 2,705 - 66,449 75,000 89% 337 State Drug 216- - 810 - - - 13,504 - - - - - 14,314 35,000 41% 338 Payment in Lieu of Tax various 453,318 453,318 453,318 453,318 453,318 453,318 453,318 453,318 453,318 453,318 453,318 - 4,986,498 5,439,810 92% 339 Contractual Service 211 13,183 11,261 14,750 69,400 8,480 37,285 8,590 62,757 13,337 8,125 1,400 - 248,568 243,000 102% Sub Total 468,230 464,579 500,519 535,178 479,712 490,603 475,412 516,075 466,655 461,443 457,423 - 5,315,829 5,792,810 92% Charge for Service Internal City 340 Liability Insurance 226 99,293 101,897 101,897 104,502 99,293 104,502 99,293 104,502 99,293 104,502 101,897 - 1,120,870 1,222,727 92% 340 General Government Misc Chgs 101/289- - - 50 - - - 280 150 15 - - 495 6,000 8% 340 Police Take Home Vehicle 278 7,060 4,680 4,670 4,640 4,590 4,560 6,770 4,510 4,510 4,480 4,460 - 54,930 61,100 90% 349 Central Service 222 51,890 62,282 48,246 51,834 52,953 53,072 51,034 54,087 55,370 47,371 44,327 - 572,466 798,302 72% 380 Central Service 222 199,523 201,656 208,098 203,681 214,579 195,611 183,083 189,840 191,193 190,924 159,196 - 2,137,383 2,800,655 76% 380 Energy Office Reimbursements 222 383,538 417,794 450,403 363,667 331,109 330,089 305,693 304,027 412,577 342,152 322,802 - 3,963,851 4,471,200 89% 380 Internal Service Reimbursement various 114,099 125,201 140,744 220,036 141,034 112,567 223,242 157,237 306,050 439,927 194,495 - 2,174,631 3,064,556 71% 392 Administration Fee 101 303,580 303,580 303,580 303,580 303,580 303,580 303,580 303,580 303,580 303,580 303,580 - 3,339,375 3,642,953 92% 392 Internal Fund Transfers various 966,983 3,518,478 7,340,433 1,062,256 6,327,336 1,021,220 2,472,104 4,957,261 2,632,376 2,634,942 1,616,139 - 34,549,528 34,330,476 101% 395 Employee Benefits 711 1,234,237 1,233,503 1,224,809 1,216,576 1,207,904 1,203,674 1,202,201 1,196,319 1,182,563 1,184,282 1,185,232 - 13,271,300 16,427,996 81% Fin anc i al Re port Novembe r 2015 - Revenu e Report Page 3 of 25 City of South Bend Period Ending:November 30, 2015 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- 2,968 1,971 1,970 1,742 1,618 - 2,965 1,383 1,948 14,272 - 30,836 22,000 140% 396 Self Funded Employee Benefits 711 13,173 - - - - - - - - - - - 13,173 13,200 100% Sub Total 3,373,375 5,972,039 9,824,850 3,532,789 8,684,121 3,330,492 4,846,999 7,274,607 5,189,044 5,254,123 3,946,400 - 61,228,837 66,861,165 92% 3rd Party Revenue 340 ND EMS Service 288- - 11,080 4,675 39,099 808 4,069 - 664 - 3,059 63,452 150,000 42% 340 Memorial Hospital Neo Natal 101 10,022 56,678 36,788 10,545 10,231 2,280 70 182 (126,795) 188 278 466 125,000 0% 350 Job Target Penalty Fee 408- - - - 354,660 - - - - - - - 354,660 354,660 100% 364 Cable TV Franchise Fees 101- 177,167 - - 183,970 - - 187,183 - - 175,355 - 723,676 724,000 100% 366 AT&T Franchise Fees 101- 69,037 - - 69,608 - - 73,131 - - 70,098 - 281,873 282,000 100% 393 Sewer Bond Issuance 666- - - - - - - - - - - - - - NA Sub Total 10,022 302,882 47,868 15,220 657,567 3,088 4,138 260,497 (126,132) 188 248,790 - 1,424,127 1,635,660 87% Grants 331 Federal Grants various 321,650 121,681 172,179 326,005 247,506 251,238 133,560 331,798 478,694 561,314 202,888 - 3,148,514 7,317,445 43% 332 Solar Energy Grant 222- - - - - - 29,167 - - - - - 29,167 29,167 100% 334 State Grants various- - - - - - 400,000 - 400,000 - - - 800,000 3,600,000 22% Sub Total 321,650 121,681 172,179 326,005 247,506 251,238 562,727 331,798 878,694 561,314 202,888 - 3,977,681 10,946,612 36% Fees for Services External 320 Inspections Central Service 222- - 330 490 10 230 40 - - - - - 1,100 1,400 79% 321 Business License 101/222 31,966 22,740 20,630 13,394 8,091 4,182 1,652 2,233 16,227 6,513 1,385 - 129,011 126,490 102% 321 Code and Animal Fees 600 3,725 4,795 5,793 6,503 3,595 5,346 4,447 5,073 4,966 4,858 2,892 - 51,992 75,200 69% 322 Building Fees 600 65,509 54,764 181,309 96,256 225,069 113,669 160,693 95,673 122,319 117,806 73,327 - 1,306,392 1,433,832 91% 322 Code Enforcement Fees 600 150 450 1,500 500 50 1,000 1,645 700 525 1,402 1,403 - 9,325 2,800 333% 322 EMS Operating Fund 288 2,233 2,460 1,295 2,375 2,046 2,074 2,237 1,689 1,040 1,570 1,371 - 20,390 25,000 82% 322 General Government Fees 101 6,640 725 1,030 2,430 2,115 1,605 2,030 5,620 5,050 1,990 1,490 - 30,725 13,000 236% 341 General Government Various various 1,736 1,940 1,164 1,602 4,952 2,701 1,448 1,331 2,944 512 1,095 - 21,424 33,405 64% 342 Highway & Streets 101/202 24,377 9,564 2,090 - 80,755 25,490 24,156 - - - 8,167 - 174,599 390,000 45% 342 Public Safety various 22,350 26,067 13,071 12,281 10,209 9,641 12,027 10,652 11,722 12,436 10,346 - 150,802 134,500 112% 342 EMS - County Fees 288- - 426,728 142,243 142,243 142,243 142,243 142,243 143,221 142,243 142,243 - 1,565,646 1,667,565 94% 342 EMS - Capital Fund 287- 396,727 - - - - - - 2,472,740 - - - 2,869,467 2,872,739 100% 342 EMS - Operating Fund 288 198,675 156,466 226,551 290,112 249,516 246,378 195,180 256,326 326,613 212,537 245,156 - 2,603,510 2,902,500 90% 342 EMS - Neo Natal / Transport 288- - - - - 74,340 40,500 23,695 90,000 35,976 37,781 - 302,292 385,000 79% 344 Solid Waste 610 401,357 397,131 400,073 405,112 406,770 408,056 407,018 407,657 407,365 408,923 405,116 - 4,454,578 5,091,168 87% 344 Code Environmental Clean Up 101/600 11,215 1,263 1,051 27,629 4,609 11,674 3,439 6,390 15,133 21,550 23,348 - 127,301 54,000 236% 344 Sewage Waste Water 641 2,776,091 2,783,483 2,821,111 2,926,251 2,971,386 2,975,155 3,138,427 3,139,072 3,202,027 3,196,230 3,037,071 - 32,966,304 35,234,467 94% 344 Sewer Repair Insurance 640 50,523 52,458 49,781 51,388 49,827 50,237 50,310 48,917 49,144 51,665 50,835 - 555,086 551,200 101% 344 Water Leak Insurance 620 80,558 79,817 80,181 74,113 80,653 80,717 80,647 80,683 80,622 80,852 80,383 - 879,223 960,000 92% 346 Water Works Utility 620 979,733 976,299 965,088 992,620 1,024,608 1,263,334 1,083,848 1,429,783 1,172,834 1,443,903 1,018,078 - 12,350,128 13,678,403 90% 346 Solid Waste Misc 610 5,075 4,623 6,710 97,941 7,710 8,274 4,328 4,115 1,958 502 1,721 - 142,956 128,148 112% 346 Project ReLeaf 655 36,473 36,203 36,396 36,456 36,590 36,613 36,605 36,590 36,623 36,714 36,452 - 401,716 429,000 94% 347 Parks & Recreation various 88,374 165,687 152,152 218,148 248,263 326,282 439,665 468,053 285,185 146,290 99,613 - 2,637,712 3,565,625 74% 347 Blackthorn Golf Club 619 99,156 20,083 (0) - 59 - - - - - - - 119,297 119,799 100% 347 Morris PAC 416 7,870 1,419 9,761 3,266 8,253 2,522 - 4,602 1,624 7,270 4,555 - 51,142 100,000 51% 349 Parking Garage Fees 601 77,130 56,458 83,412 67,492 90,594 81,037 75,732 76,940 59,796 101,711 58,785 - 829,086 908,675 91% 349 Code Demolition Board Up 101/600 2,932 9,994 467 12,513 11,595 22,467 22,601 - 6,303 19,361 1,260 - 109,491 39,000 281% 349 Parking Century Center 670 8,435 17,329 24,852 7,896 7,058 10,405 3,115 4,015 11,894 7,180 3,856 - 106,035 103,297 103% 349 Parking SBCDA 324/420 2,950 2,981 4,246 3,885 - - - - - - - - 14,061 18,000 78% 351 Fines & Fees various 21,684 35,187 12,331 11,314 27,382 12,826 233,090 14,834 16,026 19,722 20,284 - 424,679 484,020 88% 352 Forfeits various 3,455 875 2,775 4,570 2,352 19,150 5,508 8,289 10,456 3,715 3,385 - 64,530 258,820 25% 354 Ordinance Violation various 1,305 2,165 4,133 2,313 1,662 3,474 1,287 3,323 2,980 3,119 4,136 - 29,896 42,000 71% 360 Morris PAC various 52,561 22,635 129,679 31,466 52,867 108,722 6,419 19,207 67,038 78,112 45,155 - 613,860 934,900 66% 360 Palais Royale various 22,259 6,290 10,385 18,475 17,124 14,402 27,895 13,499 31,733 23,444 19,704 - 205,209 244,270 84% 360 Parks & Recreation various 26,797 14,565 4,051 10,548 20,675 12,889 4,294 17,376 13,724 8,475 16,886 - 150,281 106,700 141% 360 Police various 3,170 4,378 2,510 1,609 7,606 4,440 2,373 1,375 30,610 22,896 1,410 - 82,377 62,100 133% 360 TIF various 5,056 2,657 3,480 3,373 3,284 52,071 4,525 1,218 5,069 3,535 4,348 - 88,616 92,806 95% 360 Central Services 222 19,705 3,212 15 320 4,646 855 520 588 1,566 561 30 - 32,017 37,087 86% 360 Century Center 670(5,117) 4,970 (35,471) 3,054 7,135 324 676 2,608 3,495 86 390 - (17,850) 15,000 -119% 360 Dept. Of Community Investment 211/212 95,353 - 85,179 2,438 - 37 - 53,760 - - - - 236,767 349,500 68% 360 Economic Dev. State Grant 210- - - - - - - - 749 - - - 749 - NA 360 EMS Operating Fund 288- - 60 - 102 38,521 - 7,398 885 715 50 - 47,731 5,000 955% 360 Engineering / Curb & Sidewalk 101 209 200 (32,648) 500 660 785 475 775 (27) 179 125 - (28,766) 22,000 -131% 360 Fire and Police Pension Fund 701/702- - - 3,743 - - 1,477 1,252 - - - - 6,473 8,000 81% 360 Self Funded Employee Benefits 711 6,000 - - - - - - - - - - - 6,000 6,000 100% 360 General Government Various 101/3/226 196 853 1,386 - - - 12,290 284 39 - - - 15,048 4,250 354% 360 Motor Vehicle Highway Scrap Metal 202 1,735 - - 1,127 - - 900 - - 1,658 294 - 5,714 4,000 143% 360 Motor Vehicle Highway Curb Prgm 202 3,615 324 6,819 4,538 2,992 3,583 5,095 2,580 2,769 3,128 1,691 - 37,136 50,000 74% 360 Local Roads and Streets 251- - - 14,730 5,644 - - - - 3,225 14,826 - 38,425 22,000 175% Fin anc i al Re port Novembe r 2015 - Revenu e Report Page 4 of 25 City of South Bend Period Ending:November 30, 2015 Revenue by Type Report $ Fund% Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget 360 Professional Sports Development 377 29,523 - - - - - 26,710 - - - - - 56,233 60,661 93% 360 Cumulative Capital Improvement 407- - - - - - - - - - - - - 200 0% 360 UDAG 410- - 98,485 143,363 - - 10,000 - 787,604 - - - 1,039,452 1,039,576 100% 360 Code / Animal Control 600- - 0 - - - - - - - - - 0 100 0% 360 Parking Garage 601- - 3 - - - 4 - 4 - - - 11 - NA 360 Solid Waste Fund 610- - - - - - - 313 - - 178 - 491 2,000 25% 360 Waste Water 641/7/9 2,142 3,229 - 998 5,441 14,166 14,343 7,065 - 12,159 - - 59,542 55,200 108% 360 Water Works Utility 620- 908 1,318 17 - 1,382 - - - 16 2,000 - 5,641 39,580 14% 362 Dept. Of Community Investment 212 1,847 - - - 1,847 - - 1,847 - 1,847 - - 7,387 4,000 185% 362 Palais Royale 101 572 2,269 2,588 10,146 5,182 11,071 4,098 9,241 3,801 3,727 2,260 - 54,954 72,000 76% 362 Police 101- - - - - 7,262 - 7,699 - - 32,958 - 47,919 - NA 362 Parks & Recreation 201 2,064 4,531 4,138 4,574 6,162 2,701 2,717 3,215 2,092 - 1,105 - 33,298 40,000 83% 362 S Bend School Corp Fee 407- - - - - - - - 25,000 - - - 25,000 25,000 100% 362 Certified Technology Park 439- - - - - - - - - 48,335 - - 48,335 - NA 362 TIF Property various 15,621 17,156 19,059 30,447 12,509 22,614 11,903 16,104 21,335 10,156 17,979 - 194,882 339,025 57% 369 Memorial Hosp Leighton Plaza 408 150,000 - - - - - - - - - - - 150,000 150,000 100% 371 Century Center Fees 670 29,668 761,205 (442,960) 200,587 155,264 258,225 100,767 335,999 186,360 71,738 220,577 - 1,877,431 2,387,518 79% 399 Bosch Retention Project 210- - - - - 29,759 - - - - 15,047 - 44,806 59,966 75% 399 Principal on Loan various 1,799 20,705 18,387 19,002 18,841 36,515 2,067 36,608 19,526 1,715 18,939 - 194,103 218,398 89% 399 Principal Income xxx- 368,031 - 146,068 - - - 418,156 - - - - 932,255 1,226,890 76% Sub Total 5,476,452 6,558,266 5,412,473 6,162,214 6,036,003 6,561,444 6,413,465 7,236,660 9,760,703 6,382,255 5,791,487 - 71,791,420 79,512,780 90% Interest Income 361 Bank Account Interest various 197,258 51,054 75,698 118,454 65,582 223,194 147,082 55,519 137,385 105,416 83,642 - 1,260,284 1,198,226 105% Sub Total 197,258 51,054 75,698 118,454 65,582 223,194 147,082 55,519 137,385 105,416 83,642 - 1,260,284 1,198,226 105% Donations 367 ND Contribution 101- - - - - - 330,000 - - - - - 330,000 330,000 100% 367 Donations various 2,072 990 405 46 3,493 2,131 376 93 1,941 2,106 810 - 14,462 425,356 3% Sub Total 2,072 990 405 46 3,493 2,131 330,376 93 1,941 2,106 810 - 344,462 755,356 46% Historic Preservation 368 Lampost Program 227 19,750 5,750 750 1,000 500 - - 27,750 30,500 91% 368 Palais 450 1,225 3,703 357 982 1,115 592 1,556 864 2,209 1,458 892 - 14,953 16,000 93% Sub Total 1,225 3,703 20,107 6,732 1,865 1,592 2,056 864 2,209 1,458 892 - 42,703 46,500 92% Sale of Assets 391 TIF various 34,357 - 1,472,130 1 - - - - - 14,857 - - 1,521,345 2,554,487 60% 391 Water Hydrant Reimbursement 620- - 2,177 472 8,103 16,154 3,195 - - - - - 30,100 20,000 151% 391 Proceeds F.A. Disposal 600- - - - - - - - - - - - - - NA 391 Sale of Fixed Assets various- - - - - - - - 28,360 - - - 28,360 12,000 236% 391 Vehicle Damage Reimbursement various- - - - - - - - - - - - - 1,000 0% Sub Total 34,357 - 1,474,307 473 8,103 16,154 3,195 - 28,360 14,857 - - 1,579,806 2,587,487 61% Revenue Total 12,866,555 16,029,980 18,739,220 15,892,928 18,890,401 60,878,117 16,184,938 16,673,823 27,137,599 17,946,230 13,539,504 - 234,779,294 289,173,031 81% report 12,866,555 16,029,980 18,739,220 15,892,928 18,890,401 60,878,117 16,184,938 16,673,823 27,137,599 17,946,230 13,539,504 - 234,779,294 289,173,031 (0) 0 (0) (1) 0 (0) (0) 0 0 - (0) - (1) - Fin anc i al Re port Novembe r 2015 - Revenu e Report Page 5 of 25 City of South Bend Period Ending:November 30, 2015 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,167,120 944,443 669,668 734,592 944,924 23,042,910 1,117,315 951,306 1,307,397 2,757,304 930,664 34,567,642 50,256,101 69% 0101 Mayor 101 35 - 15 - 50 20 - - 20 23 - 163 700 23% 0104 311 Call Center 101 55,195 36,290 43,995 32,989 35,855 35,676 48,025 34,895 31,310 33,500 31,582 419,312 486,733 86% 0301 Common Council 101 41 31 15 231 31 31 46 31 31 31 31 548 8,666 6% 0401 Administration and Finance 101- 220 336 - - - - - - 612 1,168 600 195% 0501 Legal 101- 508 18,113 3 3 - 18,113 3,156 18,119 58,013 53,500 108% Sub Total 1,222,390 981,491 714,030 785,924 980,863 23,078,638 1,165,387 986,231 1,356,870 2,794,013 981,008 - 35,046,845 50,806,300 69% Public Works 0602 Engineering 101 225 303 1,104 635 275 625 (275) 2,092 125 - 5,108 77,027 7% Sub Total- - 225 303 1,104 635 275 625 (275) 2,092 125 - 5,108 77,027 7% Public Safety 0801 Police 101 6,604 11,372 38,367 2,321 20,918 11,729 17,010 43,217 50,850 46,694 37,649 286,731 555,200 52% 0901 Fire 101 10,022 59,625 37,787 11,021 10,231 2,280 4,152 462 (126,645) 203 923 10,060 138,300 7% Sub Total 16,625 70,998 76,154 13,343 31,149 14,009 21,162 43,679 (75,796) 46,897 38,571 - 296,792 693,500 43% Code Enforcement 1205 Code Unsafe Building 101(143) - (733) - - - - - - - - - (876) - NA Sub Total(143) - (733) - - - - - - - - - (876) - NA Arts & Culture 0404 Morris PAC 101 53,329 23,300 128,425 31,841 51,783 109,022 3,527 18,980 67,291 76,549 44,492 608,540 923,000 66% 0405 Palais Royale 101 24,368 9,347 13,572 30,163 23,990 26,667 34,420 23,726 37,939 29,357 23,290 276,839 335,270 83% Sub Total 77,697 32,647 141,998 62,003 75,773 135,689 37,947 42,706 105,231 105,907 67,782 - 885,380 1,258,270 70% General Fund Revenue Total 1,316,569 1,085,136 931,673 861,573 1,088,889 23,228,972 1,224,771 1,073,241 1,386,030 2,948,908 1,087,486 - 36,233,249 52,834,397 69% Financial Report Nov ember 2015 - R evenue Summa ry Page 6 of 25 City of South Bend Period Ending:November 30, 2015 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 76,460 74,383 77,445 74,566 73,993 4,547,155 75,491 100,334 77,827 478,253 90,809 5,746,718 8,860,875 65% 1100 Administration 201 2,119 4,537 4,158 4,527 6,168 2,736 2,757 3,229 2,135 30 1,107 33,505 40,600 83% 1101 Maintenance 201 19,996 2,425 3,330 1,823 4,085 2,915 99,072 48,521 46,312 27,790 18,157 274,425 319,600 86% 1102 Golf Operations 201 161 63,205 31,916 147,893 185,191 234,366 210,016 233,182 145,840 68,805 31,889 1,352,466 1,535,000 88% 1103 Recreation Division 201 26,067 16,036 5,765 54 3,370 19,150 37,653 21,670 846 23 886 131,518 185,640 71% 1108 Graffiti Removal 201- 11,341 - 13,003 7,268 - 6,941 6,483 9,103 9,239 17,589 80,968 89,000 91% Recreation Non Reverting 203 65,607 98,601 112,441 78,613 75,090 82,878 97,148 181,580 60,196 58,517 53,147 963,819 1,578,935 61% East Race Waterway 271 5 1 2 3 2 3 2 1 1 1 0 21 50 41% Coveleski Stadium 401 36 9 14 23 13 43 27 9 41,879 21 30 42,104 15,100 279% Zoo Endowment 403 43 11 17 28 15 52 33 11 31 24 18 284 200 142% Park Non Reverting 405 4,435 260 261 1,080 1,573 1,269 918 748 3,371 224 280 14,419 143,700 10% Sub Total 194,930 270,809 235,349 321,616 356,766 4,890,567 530,060 595,768 387,541 642,928 213,913 - 8,640,246 12,768,700 68% Public Works Motor Vehicle Highway 202 716,020 1,133,459 404,476 730,770 1,504,136 316,658 328,650 981,221 1,511,956 1,134,532 632,459 9,394,337 9,701,800 97% Central Services 222 655,888 688,603 709,665 623,157 619,227 584,294 570,801 552,107 671,725 586,705 542,400 6,804,573 8,180,351 83% Central Services Capital 224- - - - - - - - 271,850 49 271,899 271,850 100% Local Roads & Streets 251 87,782 90,155 98,666 112,757 99,309 97,010 97,383 23,823 261,693 228,919 143,035 - 1,340,533 1,832,300 73% Project ReLeaf 655 37,371 36,419 36,757 37,059 36,928 37,776 37,365 36,849 37,366 37,209 36,779 407,878 431,700 94% Sub Total 1,497,062 1,948,636 1,249,565 1,503,744 2,259,601 1,035,738 1,034,198 1,594,000 2,482,740 2,259,215 1,354,721 - 18,219,220 20,418,001 89% Public Works Solid Waste Solid Waste Operations 610 408,178 401,846 406,879 589,225 414,603 416,858 492,885 412,143 409,521 493,249 407,119 4,852,506 5,712,289 85% Solid Waste Capital 611 190,033 - 10,001 84,001 17 46,000 189,015 11,018 5 83,605 18 613,713 753,011 82% Sub Total 598,211 401,846 416,880 673,226 414,621 462,858 681,900 423,160 409,526 576,855 407,136 - 5,466,219 6,465,300 85% Public Works Water Utility 0000 Water Works Revenues 620 916,194 910,250 905,299 929,577 962,334 1,179,467 1,007,966 1,280,225 1,091,192 1,321,298 951,557 11,455,357 12,724,463 90% 0630 Water Leak Insurance 620 80,558 79,817 80,181 74,113 80,653 80,717 80,647 80,683 80,622 80,852 80,383 879,223 960,000 92% 0660 Clay Water 620 68,898 68,829 66,186 76,543 74,475 111,884 87,990 152,275 96,785 129,606 74,201 1,007,672 1,096,020 92% Waterworks Capital 622 2,776 682 1,098 1,741 946 3,225 2,006 655 1,819 1,413 1,043 17,404 10,000 174% Waterworks Construction 623 180 41 62 83 41 137 - - - - - 544 545 100% Waterworks Deposit 624 1,307 324 527 854 463 1,582 1,001 334 934 734 545 8,604 6,000 143% Waterworks Sinking 625 468 340,551 170,359 170,557 170,477 171,158 171,165 170,453 170,889 170,822 170,749 1,877,648 2,050,078 92% Waterworks Bond Reserve 626 1,425 353 572 - - - 1,078 359 1,005 786 584 6,163 9,500 65% Waterworks Debt Reserve 629 1,840 150,683 775 1,279 695 2,367 1,499 499 1,394 1,091 810 162,930 162,749 100% Sub Total 1,073,645 1,551,529 1,225,058 1,254,745 1,290,083 1,550,537 1,353,351 1,685,484 1,444,640 1,706,601 1,279,872 - 15,415,545 17,019,355 91% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 51,853 52,790 50,328 52,269 50,308 51,875 51,350 49,270 50,144 52,454 51,431 564,071 554,800 102% 0000 Wastewater Revenues 641 2,628,692 2,622,801 2,675,830 2,753,646 2,798,663 2,811,021 2,962,474 2,957,091 3,025,149 3,021,665 2,893,942 31,150,974 33,201,605 94% 0621 Sewer Department 641- - - 998 - 530 1,039 - 506 736 - 3,809 2,000 190% 0625 Concrete Crew 641- 4,705 - - 10,805 16,966 12,672 10,912 - 17,593 - 73,652 75,000 98% 0630 Wastewater Operations 641- - - - - - - - - - - - - NA 0631 Organic Resources 641- - - - - - - - 23 - - 23 - NA 0650 Clay Sewage 641 157,337 162,329 150,270 180,708 171,223 173,367 184,685 181,164 184,125 173,486 171,419 1,890,114 2,059,962 92% Sewage Capital 642 3,385 815 1,313 2,036 4,001,015 6,750 4,451 4,001,402 4,805 4,726 3,451 8,034,147 5,398,000 149% Sewage Reserve 643 3,020 256,833 1,248 2,104 1,143 3,895 2,466 821 2,294 1,795 1,333 276,953 271,612 102% Sewer Bond 2007 647- - - - - - - - - - - - - NA Sewage Bond Sinking 649 774,321 773,801 774,198 775,158 774,671 778,095 776,235 774,495 776,748 776,423 775,955 8,530,102 9,288,088 92% Sewer Bond 2007B 651 0 - - - - - - - - - - 0 - NA Sewage Works DS Reserve 653- - - - - - - - - - - - - NA 2010 CSO Net Sewer Bond 658 0 - - - - - - - - - - 0 - NA 2011 Sewer Bond 659 1,477 330 386 460 175 550 347 115 323 253 188 4,603 6,000 77% 2012 Sewer Bond 661 14,968 3,669 5,897 9,437 5,061 17,033 10,588 3,483 9,630 7,272 5,322 92,361 40,000 231% 2013A Sewer Refund Bonds 664 4 1 2 3 1 5 3 1 3 2 2 26 50 52% 2015 Sewer Refund Bonds 666- - - - - - - - - - - - - NA Sub Total 3,635,057 3,878,074 3,659,472 3,776,819 7,813,066 3,860,087 4,006,311 7,978,754 4,053,749 4,056,406 3,903,041 - 50,620,835 50,897,117 99% Financial Report Nov ember 2015 - R evenue Summa ry Page 7 of 25 City of South Bend Period Ending:November 30, 2015 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 162 41 876 108 59 200 13,631 43 126 99 73 15,418 36,050 43% Curfew Violations 218 11 3 17 7 4 38 21 40 8 31 42 220 1,025 21% Law Enforcement Education 220 24,859 28,459 17,376 64,238 18,300 17,495 20,976 18,422 23,916 24,572 17,352 275,964 270,000 102% Public Safety LOIT 249 540,008 539,058 430 1,078,221 539,072 539,985 539,392 187 1,078,181 539,121 539,125 5,932,780 6,472,240 92% Excess Welfare Public Safety 252 0 - - - - - - - - - - 0 - NA Police Take Home Vehicle 278 14,575 9,474 9,529 9,591 9,352 9,718 13,925 9,150 9,391 9,255 9,143 113,104 124,200 91% Police Block Grant 280 3 1 1 2 1 4 3 1 2 2 1 22 125 18% Police Grants 292 55 - - 56,891 - - - - - - - 56,947 90,000 63% Police Academy 294 11,010 7,628 1,101 893 21 68 43 14 39 1,433 26 22,276 22,700 98% COPS More Grants 295 564 782 681 33,633 619 832 807 2,367 781 26,189 7,834 75,087 150,258 50% Drug Enforcement 299 1,817 83 31,713 12,542 18,004 98 95 89 3,940 70 2,772 71,223 77,000 92% K-9 Unit 705 503 1 1 2 1 1,003 3 1 2 2 1 1,520 2,000 76% Sub Total 593,567 585,530 61,724 1,256,127 585,433 569,440 588,894 30,314 1,116,387 600,773 576,370 - 6,564,560 7,245,598 91% Public Safety - Fire Emergency Telephone System 244 19 - - - - - - - - - - - 19 20 97% EMS Capital 287- 396,727 13 206 112 383 242 81 2,472,963 1,251 1,004 2,872,983 3,623,089 79% EMS Operating Fund 288 204,337 169,122 667,161 441,484 434,559 508,444 386,909 432,486 565,302 530,235 440,448 4,780,488 5,679,065 84% Hazmat 289 3,732 10,095 10 18 10 34 21 7 20 16 12 13,975 14,100 99% River Rescue 291 3,093 2,423 3,038 651 12,628 694 8,455 17 52 39 1,228 32,320 45,350 71% Sub Total 211,182 578,368 670,222 442,360 447,309 509,554 395,628 432,591 3,038,338 531,541 442,692 - 7,699,785 9,361,624 82% Department of Community Investment Studebaker/Oliver 209 959 3,612 16,720 20,676 15,140 16,755 9,340 7,555 8,235 539 13,389 112,919 647,000 17% State Grant 210 290 70 112 181 93 36,192 400,000 35 400,938 219 18,148 856,281 3,673,510 23% DCI Operating 211 14,699 503,257 17,090 72,469 500,684 38,606 9,332 62,959 505,720 756,463 1,822 2,483,102 2,640,425 94% 0000 Dept. of Community Investment 212 3,790 122,753 240,619 202,172 106,570 83,119 85,649 373,186 410,921 145,761 184,550 1,959,091 5,890,000 33% xxx Programs 212 95,353 - - 124,819 154,530 - 2,168 43,346 420,216 - NA 0000 Economic Revenue Bond 281 24 6 10 16 8 29 18 6 17 13 10 157 300 52% Sub Total 115,115 629,699 274,551 295,513 747,314 329,231 504,340 445,910 1,369,177 902,997 217,919 - 5,831,766 12,851,235 45% Parking Garages 0000 Parking Garage Revenue 601 909 - - - 30 (30) - - 35 110 20 1,074 4,050 27% 0460 Main Street 601 20,879 17,180 24,111 20,473 21,925 20,694 18,076 18,140 16,832 22,627 19,453 220,390 267,737 82% 0462 Leighton Plaza 601 38,528 22,329 36,745 34,605 44,243 40,602 44,536 33,837 24,728 59,464 20,649 400,265 417,088 96% 0463 Enforcement 601 5,219 7,017 6,595 8,281 7,416 10,105 7,428 8,029 6,985 7,788 4,816 79,678 117,400 68% 0464 Wayne Street 601 17,498 16,724 22,424 12,234 24,291 19,471 13,079 24,198 18,095 19,531 18,269 205,814 222,950 92% 0465 Eddy Street Commons 601- - - - - 280 - - - - 280 15,900 2% Sub Total 83,033 63,250 89,875 75,593 97,905 91,123 83,119 84,204 66,674 109,519 63,207 - 907,500 1,045,125 87% Capital / Debt Service Hall of Fame 313 4,298 4,256 4,256 4,256 4,256 542,441 4,256 4,256 4,256 4,256 4,256 585,047 1,274,106 46% COIT 404 793,050 786,779 50,726 1,675,606 784,041 802,366 793,197 46,499 1,527,060 792,666 786,032 8,838,021 9,883,971 89% Cum Capital Development 406 4,847 4,467 4,518 4,622 4,482 260,870 4,642 4,459 4,598 27,641 4,477 329,623 542,691 61% Cum Capital Improvement 407 215 52 23 38 21 117,722 150,118 48 25,093 74 63 293,467 423,050 69% EDIT 408 924,052 767,359 3,568 1,469,176 1,106,220 759,510 755,698 2,467 1,503,131 769,689 768,596 8,829,465 9,599,470 92% UDAG 410 24 6 98,495 143,390 45 131 10,083 30 787,687 334 334 1,040,559 1,040,436 100% Major Moves 412 3,344 368,822 1,357 2,071 1,066 3,473 2,079 418,790 1,812 1,281 899 804,994 813,687 99% Morris PAC Improvement 416 8,323 1,532 9,946 3,564 8,413 3,069 349 4,718 1,943 7,521 4,740 54,117 101,500 53% CRED 434 28 27 24 27 30 32 31 33 34 32 32 330 450 73% Palais Historic Preservation 450 1,281 967 380 1,019 1,136 663 1,602 879 2,253 1,493 919 12,592 16,150 78% Hall of Fame Capital 677 495 122 196 312 168 568 358 119 329 255 186 3,107 4,700 66% xxx xxx xxx NA Sub Total 1,739,956 1,934,389 173,488 3,304,082 1,909,878 2,490,846 1,722,413 482,298 3,858,196 1,605,243 1,570,534 - 20,791,322 23,700,211 88% Financial Report Nov ember 2015 - R evenue Summa ry Page 8 of 25 City of South Bend Period Ending:November 30, 2015 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,630 1,888 3,064 4,949 2,689 9,170 5,809 1,936 5,413 4,237 3,148 49,933 34,680 144% Excess Levy 103- 1 1 2 1 4 2 1 2 2 1 18 20 89% Gift, Donation, Bequest 217 1,618 989 364 80 195 174 370 76 1,288 1,545 477 7,176 398,800 2% Loss Recovery 227 5,206 4,007 21,727 8,608 2,128 5,168 2,938 790 1,511 1,101 661 53,846 60,500 89% Human Rights 258 2,065 7,188 5,759 3,628 6,425 699 41,861 5,098 19,138 8,943 263 101,066 209,950 48% Morris Palais Marketing 273 274 6 1,373 366 1,258 428 3,164 256 69 1,633 1,110 9,937 18,000 55% Professional Sports Development 377 93,375 142,965 63,547 36,086 29,386 43,242 129,447 83 45,039 43,562 60,201 686,935 814,011 84% 1201 Code Enforcement 600 18,559 529,948 11,282 46,664 24,464 56,078 1,050,947 18,564 34,834 48,467 541,278 2,381,084 2,417,446 98% 1207 Animal Control 600 3,725 162,197 5,846 6,503 3,595 5,346 319,201 5,118 4,966 5,078 160,234 681,808 704,768 97% 1306 Building Operations 600 66,158 54,907 181,599 96,899 225,373 125,219 163,847 97,271 124,362 118,702 73,943 1,328,280 1,454,799 91% Century Center 670 32,985 783,504 203,146 211,537 169,457 268,954 761,283 342,621 201,749 79,005 224,824 3,279,066 3,819,265 86% Century Center Capital 671 24 21 23 22 74 106 95 - 181 92 86 724 500 145% Century Center Energy Saving 672- - - - 50,000 7 4 - 8 4 4 50,028 50,000 100% Sub Total 231,619 1,687,621 497,732 415,343 515,044 514,596 2,478,970 471,813 438,560 312,372 1,066,229 - 8,629,899 9,982,739 86% Business Insurance 0000 Business Insurance Revenues 226 104,344 103,108 103,815 107,554 100,942 112,231 102,631 105,519 102,048 106,649 104,184 1,153,025 1,245,602 93% 0418 Workers Compensation 226- - - - - - - - - 92,198 - 92,198 17,000 542% Sub Total 104,344 103,108 103,815 107,554 100,942 112,231 102,631 105,519 102,048 198,848 104,184 - 1,245,223 1,262,602 99% Fiduciary Trust & Agency Fire Pension 701 688 130 54 3,743 - 2,518,013 1,415 1,364 2,521,039 - 626 5,047,072 5,044,525 100% Police Pension 702 1,133 230 184 - - 3,187,679 62 237 3,190,993 59 965 6,381,542 6,385,359 100% Employee Benefits 711 1,248,718 1,226,227 1,217,884 1,210,699 1,200,922 1,200,207 1,197,000 1,189,005 1,177,072 1,178,161 1,178,497 13,224,393 16,357,770 81% Unemployment Comp 713 8,685 8,526 8,559 8,613 8,549 8,731 8,634 8,528 8,628 8,595 8,566 94,613 114,546 83% City Cemetery Trust 730 25 6 10 16 9 30 19 6 18 14 10 164 150 109% Sub Total 1,259,249 1,235,119 1,226,689 1,223,071 1,209,480 6,914,660 1,207,131 1,199,140 6,897,750 1,186,829 1,188,664 - 24,747,783 27,902,350 89% Civil City Revenues 12,653,540 15,953,113 10,816,094 15,511,366 18,836,330 46,560,441 15,913,717 16,602,196 27,051,356 17,639,034 13,475,968 - 211,013,153 253,754,354 83% Tax Increment Financing TIF River West - Airport 324 50,350 33,228 6,479,376 346,205 37,081 9,550,306 29,064 59,315 50,088 234,822 39,877 - 16,909,713 25,182,246 67% TIF Central Development 420 695 4,240 (4,935) - - - - - - - - - - NA TIF West Washington 422 996 261 423 675 364 197,102 849 305 852 667 496 202,990 429,800 47% TIF Leighton Plaza 425 18,229 12,971 10,040 21,366 8,977 15,860 13,156 6,162 19,644 11,245 14,425 152,075 190,423 80% TIF Medical Service 426 1,941 501 (2,442) - - - - - - - - 0 - NA TIF River East DEV (NE)429 23,215 993 1,434,000 2,685 1,830 1,397,241 4,408 1,623 4,512 3,523 2,610 2,876,641 3,829,653 75% TIF Southside 430 4,144 1,025 1,590 2,545 1,371 1,303,629 3,377 1,264 3,395 2,624 1,903 1,326,865 2,435,750 54% TIF Erskine Village 432 5,246 1,268 1,967 3,083 1,675 17,202 3,622 1,204 3,297 2,581 1,917 43,063 36,500 118% TIF Douglas Road 435 161 48 23 30 16 163,999 346 48 38 22 16 164,747 320,750 51% TIF River East RES (NE RE)436 1,215 352 5 - - 1,663,572 210,999 - - - 962 1,877,104 2,815,000 67% Sub Total 106,191 54,887 7,920,047 376,589 51,315 14,308,913 265,821 69,920 81,827 255,483 62,205 - 23,553,197 35,240,122 67% Financial Report Nov ember 2015 - R evenue Summa ry Page 9 of 25 City of South Bend Period Ending:November 30, 2015 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 9 2 4 6 3 11 7 2 6 5 4 58 252 23% Certified Technology Park 439 4,432 1,097 1,780 2,875 1,558 4,878 2,940 888 2,127 49,920 - 72,496 33,904 214% Airport Urban Enterprise Zone 454 333 82 134 216 117 401 254 85 236 185 137 2,181 2,800 78% Blackthorn Golf Operations 619 99,156 20,083 (0) - 59 - - - 119,297 119,799 100% Sub Total 103,930 21,264 1,917 3,097 1,737 5,290 3,201 974 2,370 50,110 141 - 194,032 156,755 124% Debt Service Airport Debt Reserve 2003 315 917 227 368 594 323 1,100 697 232 648 507 376 5,988 5,000 120% Coveleski Bond Debt Reserve 317 446 110 179 289 157 536 339 113 316 248 184 2,917 3,800 77% Central Development reserve 328 1,532 379 615 993 539 1,838 1,164 387 1,083 847 629 10,006 13,000 77% Sub Total 2,894 716 1,162 1,876 1,019 3,474 2,200 732 2,047 1,602 1,189 - 18,911 21,800 87% Redevelopment Commission 213,015 76,867 7,923,126 381,562 54,071 14,317,676 271,221 71,627 86,243 307,196 63,536 - 23,766,141 35,418,677 67% City Operations Total 12,866,555 16,029,980 18,739,220 15,892,928 18,890,401 60,878,117 16,184,938 16,673,823 27,137,599 17,946,230 13,539,504 - 234,779,294 289,173,031 81% Revenue report 12,866,555 16,029,980 18,739,220 15,892,928 18,890,401 60,878,117 16,184,938 16,673,823 27,137,599 17,946,230 13,539,504 0 234,779,294 289,173,031 0(0)0 0 0 0 0 0 1 0 0 0(0)0 Financial Report Nov ember 2015 - R evenue Summa ry Page 10 of 25 City of South Bend Period Ending:November 30, 2015 Property Tax Revenue 2014 Tax Pay 2015 Fund Fund #Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy Per County Collection Projected 6/8/2015 6/16/2015 10/30/2015 Total Property Tax Collection Records Factor 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 22,691,929.36 15,927,317.64 58.76% Parks & Recreation 201 7,742,127.00 0.95 7,355,020.65 2,699,065.71 1,446,685.42 403,374.41 4,549,125.54 3,193,001.46 58.76% College Football Hall of Fame 313 937,076.00 0.95 890,222.20 - 501,784.88 - 501,784.88 435,291.12 53.55% Cumulative Capital District 406 443,304.00 0.95 421,138.80 154,544.81 82,835.23 23,096.67 260,476.71 182,827.29 58.76% 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 28,003,316.49 19,738,437.51 58.66% Tax Increment Financing Airport TIF District 324 17,709,737.84 0.95 16,824,250.95 - 9,396,167.91 - 9,396,167.91 8,313,569.93 53.06% South Bend Central TIF District 420- 0.95 - - - - - - - West Washington TIF District 422 512,917.39 0.95 487,271.52 - 195,865.56 - 195,865.56 317,051.83 38.19% 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,663,572.10 1,609,756.32 50.82% Southside TIF District #1 430 2,504,494.11 0.95 2,379,269.40 - 1,298,974.33 - 1,298,974.33 1,205,519.78 51.87% 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 - 11,490.26 7,692.47 100.00% Douglas Road TIF District 435 327,887.96 0.95 311,493.56 - 163,943.98 - 163,943.98 163,943.98 50.00% Northeast TIF 429 2,743,819.42 0.95 2,606,628.45 - 1,391,012.32 - 1,391,012.32 1,352,807.10 50.70% 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 - 14,121,026.46 12,970,341.41 52.12% Grand Total 74,833,121.87 71,091,465.78 16,317,079.08 23,368,682.22 2,438,581.65 42,124,342.95 32,708,778.92 56.29% 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 2 - Issued by St. Joseph County on 10/30/15 Financial Report November 2015 - Property Tax Revenue Page 11 of 25 City of South Bend Period Ending:November 30, 2015 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 November 2015 - Property Tax Revenue Page 12 of 25 City of South Bend Period Ending:November 30, 2015 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget General Government 0101 Mayor 101 80,464 52,550 48,452 55,723 53,138 57,124 79,991 61,928 63,083 55,039 53,301 - 660,793 741,267 89% 0104 311 Call Center 101 55,195 36,290 43,995 32,989 35,855 35,676 48,025 34,895 31,310 33,500 31,582 - 419,312 486,733 86% 0201 Clerk 101 34,775 28,270 26,114 26,345 27,469 28,359 37,398 27,161 26,817 26,397 33,707 - 322,811 431,573 75% 0301 Common Council 101 33,803 24,869 110,974 30,970 47,806 24,460 26,243 25,524 33,047 18,005 34,007 - 409,707 490,150 84% 0302 WNIT Contract 101- - - - 43,000 - - - - - - - 43,000 43,000 100% 0401 Administration and Finance 101 187,531 134,271 139,736 136,435 154,038 136,652 198,795 124,777 124,684 128,374 140,141 - 1,605,434 2,020,544 79% 0501 Legal Department 101 99,178 73,129 64,725 70,589 73,432 71,133 95,236 70,736 70,684 73,004 73,242 - 835,088 1,006,979 83% Sub Total 490,946 349,379 433,994 353,052 434,738 353,404 485,688 345,022 349,624 334,318 365,980 - 4,296,146 5,220,246 82% Public Works 0602 Engineering 101 72,931 79,671 89,919 62,192 67,688 70,000 137,148 71,996 70,838 66,475 62,863 - 851,720 1,058,933 80% Sub Total 72,931 79,671 89,919 62,192 67,688 70,000 137,148 71,996 70,838 66,475 62,863 - 851,720 1,058,933 80% Public Safety 0801 Police 101 2,557,412 1,878,728 1,990,424 1,850,902 1,869,819 1,977,962 2,485,297 1,806,971 2,069,559 1,932,826 1,801,924 - 22,221,824 25,633,064 87% 0805 Police -PS LOIT funded 101 2,562 6,199 (8,761) - - - (212) 6,911 (6,699) - - - - - NA 0802 Police Communications 101 135,031 97 8 514,528 128,638 128,638 8 257,268 128,638 128,638 128,638 - 1,550,127 1,687,540 92% 0901 Fire 101 2,150,469 1,590,349 1,505,644 1,328,213 1,314,720 1,472,585 1,998,183 1,335,121 1,382,396 1,366,761 (44,742) - 15,399,698 17,774,474 87% 0905 Fire-PS LOIT funded 101 411 - - - - (411) 11,354 13,015 (24,369) - - - - - NA Sub Total 4,845,886 3,475,373 3,487,315 3,693,643 3,313,177 3,578,773 4,494,629 3,419,286 3,549,525 3,428,225 1,885,819 - 39,171,649 45,095,078 87% Code Enforcement 1201 Code 101- - - (710) - 710 - - - - - - 2,270 0% Sub Total- - - - (710) - 710 - - - - - - 2,270 0% Arts & Culture 0404 Morris PAC 101 96,838 87,590 80,670 75,338 75,072 81,843 94,489 84,313 75,303 74,055 69,116 - 894,627 1,093,132 82% 0405 Palais Royale 101 41,912 31,105 39,827 31,888 34,119 37,926 45,965 36,263 31,397 32,564 24,598 - 387,565 536,293 72% Sub Total 138,749 118,696 120,497 107,226 109,192 119,769 140,454 120,576 106,700 106,619 93,714 - 1,282,191 1,629,425 79% Human Rights 1008 Human Rights 101 50,323 31,896 19,693 30,347 27,284 23,670 37,717 26,959 36,829 23,862 26,509 - 335,089 373,179 90% Sub Total 50,323 31,896 19,693 30,347 27,284 23,670 37,717 26,959 36,829 23,862 26,509 - 335,089 373,179 90% General Fund Expenditure Total 5,598,836 4,055,015 4,151,418 4,246,460 3,951,368 4,145,615 5,296,345 3,983,839 4,113,515 3,959,500 2,434,884 - 45,936,796 53,379,131 86% Financial Report Nov ember 2015 - Expend iture Summar y Page 13 of 25 City of South Bend Period Ending:November 30, 2015 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Parks & Recreation 1100 Administration 201 104,226 71,673 67,013 81,921 79,879 83,369 98,496 72,911 89,937 69,029 67,076 - 885,531 967,568 92% 1101 Maintenance 201 435,157 348,338 455,082 344,569 398,104 448,976 525,758 426,831 474,858 345,725 335,829 - 4,539,227 5,178,905 88% 1102 Golf Operations 201 66,821 76,812 203,778 123,539 118,983 170,789 179,333 132,921 148,429 113,791 93,584 - 1,428,779 1,573,436 91% 1103 Recreation Division 201 193,339 143,079 147,938 140,851 152,356 160,490 313,935 224,088 146,023 151,002 148,922 - 1,922,024 2,328,698 83% 1104 Potawatomi Zoo 201 392,247 112,389 8,788 7,968 5,262 354,274 6,760 4,890 (92,653) 7,603 5,509 - 813,035 863,017 94% 1106 Potawatomi Greenhouse 201 5,079 20,391 5,260 3,156 2,005 1,101 821 910 360 873 1,557 - 41,515 53,997 77% 1108 Graffiti Removal 201 9,057 7,116 5,887 7,268 6,941 6,483 9,103 9,239 8,475 9,114 11,122 - 89,805 98,374 91% Recreation Non Reverting 203 43,898 60,957 66,785 87,752 84,777 111,498 117,396 157,046 78,605 70,135 57,931 - 936,780 1,549,469 60% East Race Waterway 271- - - 2,098 - - - 1,900 - - - - 3,998 4,000 100% Coveleski Stadium 401- - - - - - - - - - - - - - NA Zoo Endowment 403- - - - - - - - - - - - - 49,000 0% Park Non Reverting 405- - - 2,197 19,422 11,316 25,023 7,278 576 - - - 65,812 192,933 34% Sub Total 1,249,824 840,754 960,531 801,319 867,731 1,348,296 1,276,625 1,038,013 854,611 767,273 721,529 - 10,726,506 12,859,397 83% Public Works Motor Vehicle Highway 202 734,565 950,683 835,051 410,155 418,569 407,917 675,925 410,851 568,992 486,373 652,606 - 6,551,686 8,843,890 74% Curb and Sidewalk 202 112,714 39,990 31,802 29,933 21,753 32,125 60,560 56,355 59,562 66,720 58,965 - 570,479 1,641,496 35% Central Services 222 679,565 621,835 691,937 716,505 537,157 556,899 601,324 548,951 601,722 838,182 518,421 - 6,912,497 8,329,409 83% Central Services Capital 224- - - - - - - - 28,196 33,462 - 61,658 271,850 23% Local Roads & Streets 251 4,155 4,853 37,032 6,650 109,145 87,781 97,882 210,035 154,772 302,808 185,913 - 1,201,026 2,336,221 51% Project ReLeaf 655 15,357 2,281 2,386 27,010 2,442 2,899 14,293 2,796 359,542 31,405 33,457 - 493,869 528,358 93% Sub Total 1,546,355 1,619,642 1,598,209 1,190,253 1,089,066 1,087,621 1,449,984 1,228,989 1,772,786 1,758,949 1,449,361 - 15,791,214 21,951,224 72% Public Works Solid Waste Solid Waste Operations 610 635,488 341,051 339,903 382,803 461,210 482,019 641,738 428,284 404,307 459,552 403,354 - 4,979,709 5,873,863 85% Solid Waste Capital 611 223,749 143 11,054 83,702 168 45,686 189,188 (121) 11,179 83,836 196 - 648,780 752,811 86% Sub Total 859,237 341,194 350,957 466,506 461,378 527,706 830,925 428,164 415,486 543,388 403,550 - 5,628,490 6,626,674 85% Public Works Water Utility 0630 Water Leak Insurance 620 33,830 53,166 43,413 474 131,182 93,577 95,796 144,610 138,441 773 178,444 - 913,707 1,115,000 82% 0640 Water Works 620 906,773 1,320,043 1,131,090 1,058,030 1,143,612 1,164,702 1,166,484 1,074,463 1,267,995 1,023,708 1,154,417 - 12,411,316 14,725,471 84% 0660 Clay Water 620 22 - 309 26 13 9 113 182 187 245 67 - 1,174 4,000 29% Waterworks Capital 622 15,382 67,463 3,489 - - 109,780 25,331 - 40,828 - - - 262,273 838,893 31% Waterworks Construction 623 11,278 37,750 4,276 438 - 121,821 7,519 - - - - - 183,082 183,230 100% Waterworks Deposit 624 452 324 527 854 463 1,582 1,001 334 934 734 545 - 7,749 6,000 129% Waterworks Sinking 625 465 1 84 282 202 366,356 999 578 614 547 474 - 370,603 2,050,078 18% Waterworks Bond Reserve 626- 7,374 - - - - 1,438 - 2,374 11,185 14,500 77% Waterworks Debt Reserve 629 637 455 775 1,279 695 2,367 1,499 499 1,394 1,091 810 - 11,499 8,500 135% Sub Total 968,839 1,479,202 1,183,962 1,068,758 1,276,167 1,860,194 1,298,741 1,220,665 1,451,831 1,027,097 1,337,131 - 14,172,588 18,945,672 75% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 21,449 57,144 43,434 46,092 55,529 30,576 20,211 44,704 17,856 24,273 51,858 - 413,126 545,703 76% 0621 Sewer Repair 641 446,632 360,251 404,056 284,993 308,945 341,348 427,059 281,841 297,800 348,423 313,972 - 3,815,320 5,701,049 67% 0625 Concrete Crew 641 44,148 29,608 25,634 23,472 31,229 31,724 33,245 27,715 19,585 18,474 12,171 - 297,007 450,450 66% 0630 Wastewater Operations 641 2,004,256 2,110,111 1,803,497 1,776,763 5,782,494 1,787,251 2,014,017 5,849,027 1,836,184 1,754,602 1,771,506 - 28,489,706 31,016,913 92% 0631 Organic Resources 641 69,307 56,543 60,055 54,333 85,097 80,559 53,251 74,710 135,874 53,215 112,235 - 835,179 1,527,562 55% 0650 Clay Sewage 641 28 - 103 106 113 (5) 257 146 425 702 1,041 - 2,915 1,000 292% Sewage Capital 642 39,115 47,104 402,228 2,254 281,988 588,063 217,648 430,722 216,845 79,543 176,129 - 2,481,639 9,571,710 26% Sewage Reserve 643 1,045 747 1,248 2,104 1,143 3,895 2,466 821 2,294 1,795 1,333 - 18,893 15,000 126% Sewer Bond 2007 647- - - - - - 0 - - - - - 0 - NA Sewage Bond Sinking 649 1,000 850 - - 301,269 1,288,842 350 350 - - 1,484,231 - 3,076,893 9,283,609 33% Sewage Bond 2007 651- - - - - - 2 - - - - - 2 - NA Sewage Works DS Reserve 653- - - - - - - - - - - 3,181,211 0% 2010 CSO Net Sewer Bond 658- - - - - - 2 - - - - - 2 - NA 2011 Sewer Bond 659 143,037 502,799 246,856 184,257 8,408 - - 251 - - 286,684 - 1,372,292 3,711,838 37% 2012 Sewer Bond 661 39,170 249,076 234,187 81,154 302,659 245,591 201,706 398,397 318,755 448,078 258,489 - 2,777,261 16,624,275 17% 2015 Sewer Bond 666- - - - - - - - - - - - NA Sub Total 2,809,188 3,414,232 3,221,297 2,455,529 7,158,873 4,397,844 2,970,215 7,108,684 2,845,618 2,729,105 4,469,649 - 43,580,236 81,630,320 53% Financial Report Nov ember 2015 - Expend iture Summar y Page 14 of 25 City of South Bend Period Ending:November 30, 2015 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- - - - - - - - - - - - - 35,900 0% Curfew Violations 218- - - - - - - - - - - - - 1,000 0% Law Enforcement Education 220 15,730 29,274 27,290 24,802 29,310 45,024 41,268 28,910 59,717 19,954 9,764 - 331,044 402,478 82% Emergency Telephone System 244 20 1 (21) - - - - - - - - - - - NA Public Safety LOIT 249 732,055 515,347 549,323 505,155 516,948 559,128 718,301 503,168 568,812 518,642 636,819 - 6,323,698 7,246,551 87% Excess Welfare Public Safety 252- - - - - - - - - - - - - 8 0% Police Take Home Vehicle 278- - - - - - 1,086 - - - - - 1,086 71,100 2% Police Grants 292- 15,297 - - - - - - - - 8,538 - 23,835 105,145 23% Police Academy 294 2,725 9,673 242 11,678 476 678 284 713 (7,688) 862 1,006 - 20,648 23,750 87% COPS More Grants 295 20,490 784 4,485 1,262 479 2,403 387 7,135 2,061 790 19,495 - 59,771 172,335 35% Drug Enforcement 299 18,385 6,474 18,397 6,844 6,225 56,869 9,704 34,490 6,691 - - - 164,079 248,960 66% K-9 Unit 705- - 970 - - - - - - - - 970 2,000 49% Sub Total 789,405 576,850 600,685 549,741 553,438 664,102 771,031 574,416 629,593 540,248 675,621 - 6,925,130 8,309,227 83% Public Safety - Fire EMS Capital 287- 35,728 - - - - - 23,659 - 241,351 - - 300,738 750,000 40% EMS Operating Fund 288 247,977 32,280 210,228 382,360 383,042 402,139 721,466 483,130 350,528 376,344 1,702,276 - 5,291,770 6,855,366 77% Hazmat 289 20,939 602 - - - - - - - - - - 21,542 31,530 68% River Rescue 291 0 2,120 21,395 854 20,421 5,081 2,412 231 6,560 1,285 3,809 - 64,167 120,800 53% Sub Total 268,916 70,730 231,622 383,215 403,463 407,220 723,879 507,020 357,088 618,980 1,706,085 - 5,678,217 7,757,696 73% Department of Community Investment Studebaker/Oliver 209- 3,375 6,335 10,054 14,798 24,190 - 7,308 22,078 - 12,991 - 101,129 630,000 16% State Grant 210 12,200 - 18,003 - 400,000 19,293 11,175 3,435 184,678 142,430 312 - 791,525 3,694,412 21% DCI Operating 211 250,396 178,976 186,881 187,235 182,680 193,891 262,010 188,870 181,591 184,934 187,297 - 2,184,761 2,661,730 82% 1001 Dept. of Community Investment 212 102,720 134,503 161,537 515,770 284,129 140,658 220,716 142,648 287,830 492,844 56,539 - 2,539,894 5,899,970 43% 1003 Administration 212- - - - - - - - - - - - - - NA xxx Programs 212 4,101 12,414 - - - - - - - - - - 16,514 647,998 3% Sub Total 369,417 329,268 372,756 713,059 881,606 378,031 493,901 342,261 676,177 820,207 257,139 - 5,633,823 13,534,110 42% Parking Garages 0460 Main Street 601 16,261 29,534 14,520 689 11,980 25,848 11,161 9,999 29,913 13,417 12,078 - 175,399 262,391 67% 0461 St. Joseph 601- - - - - - - - 6,892 - (6,892) - - - NA 0462 Leighton Plaza 601 16,812 24,311 21,634 24,096 24,047 49,754 21,670 18,562 40,340 18,747 20,373 - 280,346 696,570 40% 0463 Enforcement 601 1,340 31,872 16,253 335 8,521 13,915 8,272 (17,024) 8,500 7,502 12,950 - 92,437 89,236 104% 0464 Wayne Street 601 54,617 27,884 11,887 11,750 59,817 25,387 47,078 26,730 25,327 54,958 11,671 - 357,105 742,615 48% 0465 Eddy Street Commons 601- - - - - - - - - - - - 15,900 0% Sub Total 89,030 113,600 64,293 36,871 104,364 114,904 88,181 38,267 110,973 94,624 50,180 - 905,287 1,806,712 50% Capital / Debt Service Hall of Fame 313 636,000 - - - - - 636,000 - - - - - 1,272,000 1,272,000 100% COIT 404 1,322,195 797,317 799,782 433,747 914,359 777,528 833,731 613,158 1,518,171 1,114,549 2,154,670 - 11,279,207 15,660,371 72% Cum Capital Development 406 112,650 - 56,546 - 135,726 56,546 112,650 - 56,546 - - - 530,663 542,691 98% Cum Capital Improvement 407 183,750 - - - - - 184,125 - - - - - 367,875 367,875 100% EDIT 408 577,062 1,795,231 126,960 154,855 1,034,072 88,516 2,289,212 57,166 1,575,955 1,063,121 942,240 - 9,704,390 10,133,749 96% UDAG 410- - - 146,068 - - - - - - - - 146,068 438,203 33% Major Moves 412 55,859 153,529 335,865 138,115 116,706 281,960 364,718 318,492 161,438 71,175 213,041 - 2,210,897 3,096,061 71% Morris PAC Improvement 416 1,268 1,665 11,946 11,079 - 1,740 13,568 888 681 11,361 - - 54,197 70,248 77% CRED 434 3,897 - - - - - 3,897 - - - - - 7,794 650,000 1% Palais Historic Preservation 450- - - - - - - - - - - - - 16,150 0% Hall of Fame Capital 677 6,843 6,370 5,998 4,253 3,276 2,621 3,444 2,860 6,159 12,153 2,658 - 56,635 188,824 30% Sub Total 2,899,524 2,754,112 1,337,096 888,116 2,204,138 1,208,912 4,441,346 992,564 3,318,949 2,272,359 3,312,609 - 25,629,724 32,436,172 79% Financial Report Nov ember 2015 - Expend iture Summar y Page 15 of 25 City of South Bend Period Ending:November 30, 2015 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Other Miscellaneous Gift, Donation, Bequest 217- 27,830 136 24,917 28,211 - - - - - - - 81,093 313,646 26% Loss Recovery 227 181,590 298,680 822,026 396,131 555,991 84,437 72,730 1,245,020 24,659 701,519 434,137 - 4,816,918 5,237,243 92% Human Rights 258 22,061 9,167 26,033 11,344 12,797 29,781 20,854 13,597 20,458 13,908 10,819 - 190,819 249,057 77% Morris Palais Marketing 273- 96 - 2,358 - 878 - - 3,332 - - - 6,664 18,974 35% Professional Sports Development 377 480,773 800 - - - - 374,030 - - - - - 855,603 855,603 100% 1201 Code Enforcement 600 120,449 101,851 94,621 183,959 101,999 106,108 187,286 169,077 91,581 203,790 128,937 - 1,489,658 2,414,485 62% 1207 Animal Control 600 57,484 47,550 49,635 42,055 56,024 53,681 65,856 48,875 50,599 49,478 51,175 - 572,411 696,216 82% 1306 Building Operations 600 104,444 75,646 91,217 76,910 80,817 79,524 112,900 74,188 81,412 72,349 81,753 - 931,160 1,094,700 85% Century Center 670 306,497 285,449 289,304 326,417 340,496 362,358 401,596 337,516 322,938 334,845 294,644 - 3,602,060 4,532,562 79% Century Center Capital 671- 66,156 - - 50,000 130,440 87,735 4,190 - - 78,879 - 417,400 605,656 69% Sub Total 1,273,296 913,225 1,372,972 1,064,090 1,226,335 847,207 1,322,987 1,892,462 594,977 1,375,889 1,080,344 - 12,963,784 16,018,142 81% Business Insurance 0403 Self Funded Liability Ins 226 26,134 26,675 14,630 19,531 15,003 11,661 27,374 14,350 19,418 12,480 13,026 - 200,283 282,900 71% 0412 Liability Insurance 226 156,054 7,585 32,230 286,937 18,509 39,921 60,211 22,800 39,119 22,670 25,811 - 711,848 1,184,891 60% 0417 Business Insurance 226 15,927 14,875 21,403 1,739 75,766 421,849 - 6,529 14,875 - 6,529 - 579,493 600,000 97% 0418 Workers Compensation 226 64,123 206,418 63,790 43,608 67,459 55,210 229,535 27,154 24,616 40,586 14,843 - 837,342 911,500 92% Sub Total 262,238 255,553 132,053 351,815 176,737 528,641 317,120 70,834 98,028 75,736 60,209 - 2,328,966 2,979,291 78% Fiduciary Trust & Agency Fire Pension 701 441,192 441,276 450,317 433,126 432,764 433,366 427,928 433,690 423,269 423,265 423,266 - 4,763,459 5,666,579 84% Police Pension 702 537,112 524,012 559,034 535,159 523,172 526,174 518,215 528,170 526,456 513,780 536,078 - 5,827,364 6,832,235 85% Employee Benefits 711 1,030,771 963,626 1,093,990 1,462,313 1,140,933 973,880 1,255,361 1,246,018 1,281,353 950,855 1,249,066 - 12,648,166 16,696,935 76% Unemployment Comp 713 10,126 5,167 9,025 7,309 10,788 5,683 8,171 5,122 4,817 952 1,952 - 69,114 226,796 30% City Cemetery Trust 730- - - - - - - - - - - - 20,000 0% Sub Total 2,019,201 1,934,080 2,112,366 2,437,907 2,107,658 1,939,103 2,209,676 2,213,001 2,235,896 1,888,853 2,210,362 - 23,308,102 29,442,545 79% Civil City Expenditure 21,003,306 18,697,459 17,690,217 16,653,639 22,462,321 19,455,397 23,490,956 21,639,180 19,475,529 18,472,209 20,168,652 - 219,208,864 307,676,313 71% Tax Increment Financing TIF River West - Airport 324 2,276,439 1,684,991 1,736,337 586,596 271,305 1,028,591 3,609,185 2,886,042 1,048,914 2,845,845 1,584,980 - 19,559,225 47,710,597 41% TIF Central Development 420 964,016 (957,248) 4,081,705 - - - - - - - - - 4,088,473 4,088,473 100% TIF West Washington 422- 15,300 7,650 7,344 - - - - - - 208 - 30,502 760,900 4% TIF Leighton Plaza 425 6,962 9,662 17,748 11,509 6,950 17,590 4,246 8,589 3,107 4,768 23,612 - 114,744 154,716 74% TIF Medical Service 426- - 2,294,533 - - - - - - - - - 2,294,533 2,294,533 100% TIF River East DEV (NE)429 112,956 5,000 - 16,291 4,700 6,600 3,438 56,721 - 48,811 1,130 - 255,647 7,239,524 4% TIF Southside 430 435,370 24,431 62,420 38,892 10,969 36,484 8,551 262,737 76,474 104,595 31,882 - 1,092,806 2,842,535 38% TIF Erskine Village 432 357,545 201,724 - - - - 130,835 - - - - - 690,104 691,380 100% TIF Douglas Road 435- 169,620 - - - - - 171,567 - - - - 341,187 345,389 99% TIF River East RES (NE RE)436 1,464,000 246,589 - - 1,000 - 1,467,450 246,589 - - - - 3,425,628 3,425,632 100% Sub Total 5,617,288 1,400,070 8,200,393 660,631 294,924 1,089,265 5,223,705 3,632,245 1,128,496 3,004,019 1,641,813 - 31,892,849 69,553,679 46% Financial Report Nov ember 2015 - Expend iture Summar y Page 16 of 25 City of South Bend Period Ending:November 30, 2015 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Redevelopment Funds Administration 433- - - - - - - - - - 1,447 - 1,447 6,000 24% Certified Technology Park 439- - 198 405,121 96,682 292,821 492,595 506,250 - 898,739 43,798 - 2,736,204 5,000,000 55% Blackthorn Golf Operations 619 69,055 89,358 22,845 - 227 19,744 - - - - - - 201,228 201,649 100% Sub Total 69,055 89,358 23,043 405,121 96,909 312,565 492,595 506,250 - 898,739 45,245 - 2,938,879 5,207,649 56% Debt Service Airport Debt Reserve 2003 315 317 227 368 594 323 1,100 697 232 648 507 376 - 5,389 5,000 108% Central Development reserve 328 530 379 615 993 539 1,838 1,164 387 1,083 847 629 - 9,004 6,000 150% Sub Total 847 606 983 1,587 862 2,938 1,860 619 1,731 1,354 1,005 - 14,393 11,000 131% Redevelopment Commission 5,687,190 1,490,033 8,224,418 1,067,340 392,695 1,404,768 5,718,161 4,139,114 1,130,226 3,904,112 1,688,063 - 34,846,121 74,772,328 47% City Operations Total 26,690,496 20,187,492 25,914,635 17,720,979 22,855,017 20,860,165 29,209,116 25,778,294 20,605,755 22,376,321 21,856,715 - 254,054,985 382,451,143 66% Expenditure report 26,690,496 20,187,492 25,914,635 17,720,979 22,855,017 20,860,165 29,209,116 25,778,294 20,605,755 22,376,321 21,856,715 0 254,054,985 382,451,143 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report Nov ember 2015 - Expend iture Summar y Page 17 of 25 City of South Bend Period Ending:November 30, 2015 Debt Schedule Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at 2015 Princip al 2015 Inter est 2015 Debt a t 2015 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 14 Paym ents Payme nt Addit ion 12/31/20 15 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 2,055,000.00 7 90,000.00 86,100.00 0.00 1,265,000.00 876,10 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,860,000.00 5 45,000.00 129,726.00 0.00 3,315,000.00 674,72 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 3,100,000.00 3 55,000.00 62,000.00 0.00 2,745,000.00 417,00 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 11,245,000.00 1,1 60,000.00 403,635.00 0.00 10,085,000.00 1,563,63 5.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,300,000.00 2 10,000.00 146,726.00 0.00 3,090,000.00 356,72 6.00 4 2 Sewage W orks Im provements (s ee#145)Sewag e W orks 200 6 20 26 64 9 6/1 12/1--7,630,00 0.00 5,740,000.00 5,7 40,000.00 255,491.26 0.00 0.00 5,995,49 1.26 4 0 Sewage W orks Im provements (s ee#145)Sewag e W orks 200 7 20 27 64 9 6/1 12/1--16,600,00 0.00 12,320,000.00 12,3 20,000.00 535,947.50 0.00 0.00 12,855,94 7.50 5 2 Sewage W orks Reve nue Bon ds 200 7B Sewag e W orks 200 7 20 27 64 9 6/1 12/1--16,515,00 0.00 12,280,000.00 12,2 80,000.00 524,341.26 0.00 0.00 12,804,34 1.26 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,750,000.00 2 85,000.00 107,687.50 0.00 3,465,000.00 392,68 7.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,775,000.00 2 20,000.00 261,098.00 0.00 4,555,000.00 481,09 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,561,387.00 1 53,712.00 71,974.00 0.00 2,407,675.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,905,000.00 3 75,000.00 325,267.50 0.00 7,530,000.00 700,26 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 19,040,000.00 8 65,000.00 706,650.00 0.00 18,175,000.00 1,571,65 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,620,000.00 3 45,000.00 223,686.26 0.00 7,275,000.00 568,68 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 22,965,000.00 1,0 30,000.00 528,180.00 0.00 21,935,000.00 1,558,18 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 11,855,000.00 1,8 85,000.00 229,987.00 0.00 9,970,000.00 2,114,98 7.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,580,000.00 2 15,000.00 190,680.00 0.00 5,365,000.00 405,68 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,657,696.50 2 71,188.58 161,242.68 0.00 2,386,507.92 432,43 1.26 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 0.00 0.00 0.00 4,1 67,8 97.00 4,167,897.00 0.00 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 0.00 1 00,000.00 90,039.53 5,6 05,0 00.00 5,505,000.00 190,03 9.53 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 0.00 0.00 0.00 27,4 40,0 00.00 27,440,000.00 0.00 xxx Total Bond Debt 2 31,577,59 3.50 142,609,083.50 39,1 44,900.58 5,040,459.49 37,2 12,8 97.00 140,677,079.92 44,185,36 0.07 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 372,364.00 19,571.00 12,548.66 0.00 352,793.00 32,11 9.66 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 2,027,973.00 4 38,202.50 0.00 0.00 1,589,770.50 438,20 2.50 4 4 State R evolving F und (Refun ding)Sewag e W orks I mprov ement 199 8 20 18 64 9 6/1 12/1--24,095,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 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 860,913.00 1 62,482.00 24,966.00 0.00 698,431.00 187,44 8.00 xxx Total Loans Pa yable 29,822,33 2.00 3,261,250.00 6 20,255.50 37,514.66 0.00 2,640,994.50 657,77 0.16 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 559,122.04 1 78,539.39 22,040.27 0.00 380,582.65 200,57 9.66 7 2 Kansas S t ate Bank C ode Enfo rcement Oce Copier 201 0 20 15 10 1 1/23 4/23 7/23 10/23 9,20 9.00 539.14 539.14 10.50 0.00 0.00 54 9.64 7 6 Kansas S t ate Bank C entra l Servi c es Copier 201 0 20 15 22 2 2/16 5/16 8/16 11/16 13,36 6.40 1,496.90 1,496.90 33.10 0.00 0.00 1,53 0.00 7 7 GE Cap ital I nfor mation Techn ology An imal Contr ol C opier 201 0 20 15 10 1 2/28 5/30 8/30 11/30 3,55 0.69 403.62 403.62 4.04 0.00 0.00 40 7.66 7 8 Kansas S t ate Bank Mayor Oce Cop ie r 201 0 20 15 10 1 1/8 4/8 7/8 10/8 9,20 9.00 1,586.72 1,586.72 62.20 0.00 0.00 1,64 8.92 7 9 Advan c ed Ima gi ng C entra l Servi c es Duplicators 201 0 20 15 22 2 1/15 4/15 7/15 10/15 10,51 1.02 2,455.77 2,455.77 139.59 0.00 0.00 2,59 5.36 8 7 Public Fi nance.c om Inc Solid Was te Cont ai ners/Truc k s 201 1 20 15 61 1 6/15 12/1 5--321,85 3.00 67,665.30 67,665.30 1,599.70 0.00 0.00 69,26 5.00 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 641,545.46 4 25,630.31 9,335.10 0.00 215,915.15 434,96 5.41 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 74,504.09 42,308.31 977.25 0.00 32,195.78 43,28 5.56 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 1,275.18 837.22 51.50 0.00 437.96 88 8.72 9 2 Key Finance IT Phone S ystem 201 1 20 16 40 4 1/15 1,444,99 5.97 569,323.31 2 81,141.18 14,258.23 0.00 288,182.13 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 1,110.31 539.50 48.98 0.00 570.81 58 8.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 131,862.30 87,556.51 1,765.97 0.00 44,305.79 89,32 2.48 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 661,712.34 2 61,339.69 10,111.59 0.00 400,372.65 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 481,717.95 1 90,523.14 6,535.71 0.00 291,194.81 197,05 8.85 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,703,748.90 5 60,548.08 20,403.26 0.00 1,143,200.82 580,95 1.34 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 3,170.10 1,172.61 149.31 0.00 1,997.49 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 3,205.85 1,106.31 164.49 0.00 2,099.54 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 2,315.31 728.85 110.91 0.00 1,586.46 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 3,475.34 1,092.25 178.55 0.00 2,383.09 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 3,492.63 1,097.31 173.49 0.00 2,395.32 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 10,132.91 3,184.26 502.98 0.00 6,948.65 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,361,951.27 3 34,301.24 15,599.28 0.00 1,027,650.03 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 6,790.21 2,073.34 518.66 0.00 4,716.87 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 3,109.92 786.76 152.24 0.00 2,323.16 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 1,214,609.68 2 96,499.82 18,081.32 0.00 918,109.86 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 7,565.05 2,178.10 393.14 0.00 5,386.95 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 7,950.10 1,826.18 393.82 0.00 6,123.92 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 4,639.36 1,065.38 230.08 0.00 3,573.98 1,29 5.46 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 3,887.84 892.77 192.75 0.00 2,995.07 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 3,887.84 892.77 192.75 0.00 2,995.07 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 3,714.38 796.08 187.92 0.00 2,918.30 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,959,485.95 3 79,888.68 28,907.87 0.00 1,579,597.27 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 124,554.02 29,828.93 4,995.44 0.00 94,725.09 34,82 4.37 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 3,720.95 866.48 154.00 0.00 2,854.47 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 5,461.99 1,307.57 188.47 0.00 4,154.42 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 3,561.10 801.62 155.50 0.00 2,759.48 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,302.13 294.22 42.62 0.00 1,007.91 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 5,351.65 1,035.84 296.27 0.00 4,315.81 1,33 2.11 13 1 Police Com munications Copier R icoh US A C opier 201 4 20 19 10 1 Monthly 12th 8,84 3.00 8,196.86 1,613.55 418.29 0.00 6,583.31 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 11,182.59 2,247.61 569.39 0.00 8,934.98 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,960.04 888.67 196.84 0.00 3,071.37 1,08 5.51 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 0.00 3,434.11 759.69 19,6 03.94 16,169.83 4,19 3.80 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 0.00 694.75 217.13 5,2 61.50 4,566.75 91 1.88 13 8 HP Computer Lease #9 C omputer Equipment Le ase 201 5 20 19 Various Monthly TBD 135,95 8.05 0.00 11,883.04 2,710.46 1 35,9 58.05 124,075.01 14,59 3.50 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 0.00 0.00 0.00 3,4 25,2 73.58 3,425,273.58 0.00 14 3 HP Computer Lease #11 C omputer Equipment Le ase 201 5 20 19 40 4 Monthly 3,04 0.00 0.00 214.67 45.81 3,0 40.00 2,825.33 26 0.48 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 0.00 0.00 0.00 1,2 67,1 83.00 1,267,183.00 0.00 xxx T otal Cap ital L ease 21,309,88 7.26 9,670,744.40 3,1 87,804.55 164,256.46 4,8 56,3 20.07 11,339,259.92 3,352,06 1.01 To tal Civ i l C i ty 2 82,709,81 2.76 155,541,077.90 42,9 52,960.63 5,242,230.61 42,0 69,2 17.07 154,657,334.34 48,195,19 1.24 Fi nanci a l R e p or t No vembe r 2 0 1 5 - De b t Page 1 8 o f 25 City of South Bend Period Ending:November 30, 2015 Debt Schedule Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at 2015 Princip al 2015 Inter est 2015 Debt a t 2015 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 14 Paym ents Payme nt Addit ion 12/31/20 15 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,630,000.00 4 50,000.00 37,500.00 0.00 1,180,000.00 487,50 0.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 4,160,000.00 1,1 50,000.00 116,820.00 0.00 3,010,000.00 1,266,82 0.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 2,460,000.00 9 50,000.00 87,212.50 0.00 1,510,000.00 1,037,21 2.50 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 3,010,000.00 3 95,000.00 86,350.00 0.00 2,615,000.00 481,35 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 14,965,000.00 1,2 05,000.00 709,525.00 0.00 13,760,000.00 1,914,52 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 8,535,000.00 6 90,000.00 404,611.50 0.00 7,845,000.00 1,094,61 1.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,255,000.00 2 20,000.00 268,380.00 0.00 4,035,000.00 488,38 0.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 33,020,000.00 33,0 20,000.00 1,853,268.00 31,4 50,0 00.00 31,450,000.00 34,873,26 8.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,915,000.00 6 20,000.00 134,802.50 0.00 2,295,000.00 754,80 2.50 10 4 2 012 G ates Downto wn C ampus VA Clinic Agmt L oan 201 2 20 15 42 0 3/1 8/1 1,700,00 0.00 566,666.68 5 66,666.68 0.00 0.00 0.00 566,66 6.68 12 1 Blackthorn Go lf C art L ease Blackthorn Golf 201 4 20 19 61 9 Monthly 14th 293,78 8.00 257,238.04 2 57,238.04 4,688.91 0.00 0.00 261,92 6.95 12 2 Synagogue at Coveleski Improvements C oveleski S tadium 201 4 20 18 37 7 1/31 500,00 0.00 400,000.00 1 00,000.00 0.00 0.00 300,000.00 100,00 0.00 13 5 2 015 Redevolpme nt S mart Streets Smarts Stre ets 201 5 20 37 32 4 2/1 8/1 25,000,00 0.00 0.00 0.00 0.00 25,0 00,0 00.00 25,000,000.00 0.00 xxx Total Bond Debt 1 53,788,78 8.00 76,173,904.72 39,6 23,904.72 3,703,158.41 56,4 50,0 00.00 93,000,000.00 43,327,06 3.13 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 423,820.93 59,966.23 12,044.21 0.00 363,854.70 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 117,130.26 0.00 0.00 0.00 100,557.56 0.00 6 0 HUD Section 108#8 Stu debake r Oliver 200 8 20 25 43 4 2/1 8/1--4,000,00 0.00 180,000.00 1 80,000.00 7,794.00 0.00 0.00 187,79 4.00 6 3 City of Misha waka D ouglas Road TIF 200 9 20 29 43 5 2/15 8/15--1,102,54 9.56 47,003.09 47,003.09 1,175.08 0.00 0.00 48,17 8.17 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 886,677.00 2 51,157.00 41,852.00 0.00 635,520.00 293,00 9.00 8 3 In terfu nd F und 619 - B la c k thorn Blackthorn Eq uip (go lf c arts)201 0 20 17 61 9 5/15 6/15 7/15 8/15 31,03 2.00 0.00 0.00 0.00 0.00 0.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,513,259.50 90,929.20 29,812.80 0.00 1,422,330.30 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,227,558.81 2 13,696.29 158,739.71 0.00 3,013,862.52 372,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 0.00 0.00 0.00 500,000.00 0.00 8 8 Blackthorn L oan from Airport Blackthorn Eq uip (mowe rs)201 1 20 18 61 9 5/15 6/15 7/15 8/15 53,59 8.50 0.00 0.00 0.00 0.00 0.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 0.00 0.00 0.00 0.00 0.00 xxx Total Loans Pa yable 15,627,49 9.06 6,895,449.59 8 42,751.81 251,417.80 0.00 6,036,125.08 1,094,16 9.61 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 3 7 Tran s po Lea s e Leighto n P laz a Gara ge 200 1 20 15 40 4 6/30 12/3 0--3,000,00 0.00 191,347.00 1 91,347.00 8,653.00 0.00 0.00 200,00 0.00 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,676,543.00 1 17,625.00 82,375.00 0.00 1,558,918.00 200,00 0.00 xxx Tot al Lease 5,510,27 8.00 1,867,890.00 3 08,972.00 91,028.00 0.00 1,558,918.00 400,00 0.00 Tot al Red evelop ment Commiss ion 1 74,926,56 5.06 84,937,244.31 40,7 75,628.53 4,045,604.21 56,4 50,0 00.00 100,595,043.08 44,821,23 2.74 To tal Debt 4 57,636,37 7.82 240,478,322.21 83,7 28,589.16 9,287,834.82 98,5 19,2 17.07 255,252,377.42 93,016,42 3.98 Fi nanci a l R e p or t No vembe r 2 0 1 5 - De b t Page 1 9 o f 25 City of South Bend Period Ending:November 30, 2015 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 14 Paym ents Pay ments Ad ditions 11/30/20 15 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 2,055,000.00 4 05,000.00 38,400.00 0.00 1,650,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,860,000.00 5 45,000.00 129,726.00 0.00 3,315,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 3,100,000.00 0.00 31,000.00 0.00 3,100,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 11,245,000.00 1,1 60,000.00 403,635.00 0.00 10,085,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,300,000.00 0.00 73,363.00 0.00 3,300,000.00 4 2 Sewage W orks Im provements Sewag e W orks 200 6 20 26 64 9 6/1 12/1--7,630,00 0.00 5,740,000.00 5,7 40,000.00 255,491.26 0.00 0.00 4 0 Sewage W orks Im provements Sewag e W orks 200 7 20 27 64 9 6/1 12/1--16,600,00 0.00 12,320,000.00 12,3 20,000.00 535,947.50 0.00 0.00 5 2 Sewage W orks Reve nue Bon ds 200 7B Sewag e W orks 200 7 20 27 64 9 6/1 12/1--16,515,00 0.00 12,280,000.00 12,2 80,000.00 524,341.26 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,750,000.00 2 85,000.00 55,981.25 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,775,000.00 0.00 130,549.00 0.00 4,775,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,561,387.00 0.00 35,987.00 0.00 2,561,387.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,905,000.00 0.00 162,633.75 0.00 7,905,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 19,040,000.00 0.00 353,325.00 0.00 19,040,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,620,000.00 3 45,000.00 227,086.26 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 22,965,000.00 0.00 264,090.00 0.00 22,965,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 11,855,000.00 0.00 114,993.50 0.00 11,855,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,580,000.00 2 15,000.00 190,680.00 0.00 5,365,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,657,696.50 2 71,188.58 161,242.68 0.00 2,386,507.92 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 0.00 0.00 0.00 4,1 67,8 97.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 0.00 33,333.34 30,013.18 5,6 05,0 00.00 5,571,666.66 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 0.00 0.00 0.00 27,4 40,0 00.00 27,440,000.00 xxx Total Bond Debt 2 31,577,59 3.50 142,609,083.50 33,5 99,521.92 3,718,485.64 37,2 12,8 97.00 146,222,458.58 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 372,364.00 0.00 6,274.33 0.00 372,364.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 2,027,973.00 1 46,067.50 0.00 0.00 1,881,905.50 4 4 State R evolving F und (sch# 105)Sewag e W orks I mprov ement 199 8 20 18 64 9 6/1 12/1--24,095,00 0.00 0.00 0.00 0.00 0.00 0.00 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 860,913.00 0.00 12,483.00 0.00 860,913.00 xxx Total Loans Pa yable 29,822,33 2.00 3,261,250.00 1 46,067.50 18,757.33 0.00 3,115,182.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 559,122.04 1 78,539.39 22,040.27 0.00 380,582.65 7 2 Kansas S t ate Bank C ode Enfo rcement Oce Copier 201 0 20 15 10 1 1/23 4/23 7/23 10/23 9,20 9.00 539.14 539.14 10.50 0.00 0.00 7 6 Kansas S t ate Bank C entra l Servi c es Copier 201 0 20 15 22 2 2/16 5/16 8/16 11/16 13,36 6.40 1,496.90 1,496.90 33.10 0.00 0.00 7 7 GE Cap ital I nfor mation Techn ology An imal Contr ol C opier 201 0 20 15 10 1 2/28 5/30 8/30 11/30 3,55 0.69 403.62 403.62 4.08 0.00 0.00 7 8 Kansas S t ate Bank Mayor Oce Cop ie r 201 0 20 15 10 1 1/8 4/8 7/8 10/8 9,20 9.00 1,586.72 1,586.72 62.20 0.00 0.00 7 9 Advan c ed Ima gi ng C entra l Servi c es Duplicators 201 0 20 15 22 2 1/15 4/15 7/15 10/15 10,51 1.02 2,455.77 2,455.77 139.59 0.00 0.00 8 7 Public Fi nance.c om Inc Solid Was te Cont ai ners/Truc k s 201 1 20 15 61 1 6/15 12/1 5--321,85 3.00 67,665.30 33,568.80 1,063.70 0.00 34,096.50 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 641,545.46 3 18,451.46 7,772.59 0.00 323,094.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 74,504.09 31,665.24 798.93 0.00 42,838.85 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 1,275.18 837.22 51.44 0.00 437.96 9 2 Key Finance IT Phone S ystem 201 1 20 16 40 4 1/15 1,444,99 5.97 569,323.31 2 81,141.18 14,258.23 0.00 288,182.13 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 1,110.31 401.76 39.60 0.00 708.55 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 131,862.30 87,556.52 1,765.96 0.00 44,305.78 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 661,712.34 2 61,339.69 10,111.59 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 481,717.95 1 90,523.14 6,535.70 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,703,748.90 5 60,548.08 20,403.26 0.00 1,143,200.82 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 3,170.10 972.55 129.05 0.00 2,197.55 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 3,205.85 1,106.31 125.36 0.00 2,099.54 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 2,315.31 736.21 103.55 0.00 1,579.10 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 3,475.34 813.25 139.85 0.00 2,662.09 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 3,492.63 1,108.82 161.98 0.00 2,383.81 10 9 Ricoh U SA Parks & Rec Ricoh Copi ers(3)201 3 20 18 20 1 2/21 5/21 8/21 11/21 16,12 9.94 10,132.91 3,217.62 469.62 0.00 6,915.29 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,361,951.27 3 34,301.24 15,599.28 0.00 1,027,650.03 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 6,790.21 1,538.34 405.66 0.00 5,251.87 11 2 Ricoh U SA Bu ildin g Dept. Co pi er 201 3 20 18 60 0 Monthly--4,09 3.64 3,109.92 652.60 129.90 0.00 2,457.32 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 1,214,609.68 2 96,499.83 18,081.31 0.00 918,109.85 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 7,565.05 2,178.10 393.14 0.00 5,386.95 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 7,950.10 1,670.11 364.89 0.00 6,279.99 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 4,639.36 974.34 213.11 0.00 3,665.02 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 3,887.84 816.48 178.58 0.00 3,071.36 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 3,887.84 816.48 178.58 0.00 3,071.36 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 3,714.38 728.04 173.96 0.00 2,986.34 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,959,485.95 3 79,888.68 28,907.87 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 124,554.02 27,291.69 4,630.64 0.00 97,262.33 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 3,720.95 792.73 142.71 0.00 2,928.22 12 7 HP Computer Lease #4 C omputer Equipment Le ase 201 4 20 18 40 4 Monthly 8th--5,88 6.15 5,461.99 1,196.66 174.71 0.00 4,265.33 12 8 HP Computer Lease #6 C omputer Equipment Le ase 201 4 20 18 20 1 Monthly 8th--3,75 5.50 3,561.10 733.32 144.04 0.00 2,827.78 12 9 HP Computer Lease #7 C omputer Equipment Le ase 201 4 20 18 62 0 Monthly 8th--1,32 6.00 1,302.13 267.57 41.20 0.00 1,034.56 13 0 Solid Waste C opier R icoh US A C opier 201 4 20 19 61 1 Monthly 17th--5,35 1.65 5,351.65 953.91 275.73 0.00 4,397.74 13 1 Police Com munications Copier R icoh US A C opier 201 4 20 19 10 1 Monthly 12th--8,84 3.00 8,196.86 1,475.62 386.90 0.00 6,721.24 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 11,182.59 2,055.47 526.78 0.00 9,127.12 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,960.04 812.74 182.32 0.00 3,147.30 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 0.00 3,084.18 690.24 19,6 03.94 16,519.76 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 0.00 616.03 194.53 5,2 61.50 4,645.47 13 8 HP Computer Lease #9 C omputer Equipment Le ase 201 5 20 19 Various Monthly TBD--135,95 8.05 0.00 9,446.88 2,187.92 1 35,9 58.05 126,511.17 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 0.00 0.00 0.00 3,4 25,2 73.58 3,425,273.58 14 3 HP Computer Lease #11 C omputer Equipment Le ase 201 5 20 19 40 4 Monthly 3,04 0.00 0.00 160.69 34.67 3,0 40.00 2,879.31 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 0.00 0.00 0.00 1,2 67,1 83.00 1,267,183.00 xxx T otal Cap ital L ease 21,309,88 7.26 9,670,744.40 3,0 27,961.12 160,458.82 4,8 56,3 20.07 11,499,103.35 To tal Civ i l C i ty 2 82,709,81 2.76 155,541,077.90 36,7 73,550.54 3,897,701.79 42,0 69,2 17.07 160,836,744.43 Fi nanci a l R e p or t No vembe r 2 0 1 5 - De b t Page 2 0 o f 25 City of South Bend Period Ending:November 30, 2015 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 14 Paym ents Pay ments Ad ditions 11/30/20 15 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,630,000.00 4 50,000.00 37,500.00 0.00 1,180,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 4,160,000.00 1,1 50,000.00 116,820.00 0.00 3,010,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 2,460,000.00 9 50,000.00 87,212.50 0.00 1,510,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 3,010,000.00 0.00 43,175.00 0.00 3,010,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 14,965,000.00 1,2 05,000.00 709,525.00 0.00 13,760,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 8,535,000.00 6 90,000.00 404,611.50 0.00 7,845,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,255,000.00 2 20,000.00 268,380.00 0.00 4,035,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 33,020,000.00 33,0 20,000.00 1,853,268.00 31,4 50,0 00.00 31,450,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,915,000.00 6 20,000.00 0.00 2,295,000.00 10 4 2 012 G ates Downto wn C ampus VA Clinic Agmt L oan 201 2 20 15 42 0/324 3/1 8/1--1,700,00 0.00 566,666.68 5 66,666.68 0.00 0.00 0.00 12 1 Blackthorn Go lf C art L ease Blackthorn Golf 201 4 20 19 61 9 Monthly 14th 293,78 8.00 257,238.04 2 57,238.04 535.91 0.00 0.00 12 2 Synagogue at Coveleski Improvements C oveleski S tadium 201 4 20 18 37 7 1/31 500,00 0.00 400,000.00 1 00,000.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 0.00 0.00 0.00 25,0 00,0 00.00 25,000,000.00 xxx Total Bond Debt 1 53,788,78 8.00 76,173,904.72 39,2 28,904.72 3,521,027.91 56,4 50,0 00.00 93,395,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 423,820.93 44,806.23 9,201.60 0.00 379,014.70 4 In di ana Development Finance Autho rity Bos c h P roperty (Forgive)200 1 20 21 21 0----260,00 0.00 117,130.26 0.00 0.00 0.00 117,130.26 6 0 HUD Section 108#8 Stu debake r Oliver 200 8 20 25 43 4 2/1 8/1--4,000,00 0.00 180,000.00 1 80,000.00 7,794.00 0.00 0.00 6 3 City of Misha waka D ouglas Road TIF 200 9 20 29 43 5 2/15 8/15--1,102,54 9.56 47,003.09 47,003.09 1,175.08 0.00 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 886,677.00 2 51,157.00 41,852.00 0.00 635,520.00 8 3 In terfu nd F und 619 - B la c k thorn Blackthorn Eq uip (go lf c arts)201 0 20 17 61 9 5/15 6/15 7/15 8/15 31,03 2.00 0.00 0.00 0.00 0.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,513,259.50 90,929.20 29,812.81 0.00 1,422,330.30 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,227,558.81 2 13,696.29 158,739.71 0.00 3,013,862.52 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 8 8 Blackthorn L oan from Airport Blackthorn Eq uip (mowe rs)201 1 20 18 61 9 5/15 6/15 7/15 8/15 53,59 8.50 0.00 0.00 0.00 0.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 0.00 0.00 0.00 0.00 xxx Total Loans Pa yable 15,627,49 9.06 6,895,449.59 8 27,591.81 248,575.20 0.00 6,067,857.78 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 3 7 Tran s po Lea s e Leighto n P laz a Gara ge 200 1 20 15 40 4 6/30 12/3 0--3,000,00 0.00 191,347.00 94,260.00 5,740.00 0.00 97,087.00 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,676,543.00 1 17,625.00 82,375.00 0.00 1,558,918.00 xxx Tot al Lease 5,510,27 8.00 1,867,890.00 2 11,885.00 88,115.00 0.00 1,656,005.00 Tot al Red evelop ment Commiss ion 1 74,926,56 5.06 84,937,244.31 40,2 68,381.53 3,857,718.11 56,4 50,0 00.00 101,118,862.78 To tal Debt 4 57,636,37 7.82 240,478,322.21 77,0 41,932.07 7,755,419.90 98,5 19,2 17.07 261,955,607.21 Fi nanci a l R e p or t No vembe r 2 0 1 5 - 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,094 1,084 1,076 1,077 1,072 1,073 1,074 1,065 1,071 1,067 1,066 1,071 0 Part Time Staff 68 70 90 101 110 109 101 113 107 105 131 0 Temporary / Seasonal 111 109 113 126 209 309 257 266 182 184 144 0 City Total 1,263 1,255 1,280 1,299 1,392 1,492 1,423 1,450 1,356 1,355 1,346 0 Financial Report November 2015 - 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 7 7 7 7 7 7 8 7 7 7 0 311 Call Center 7 7 7 7 7 7 7 7 6 7 7 7 0 Admin & Finance 21 21 21 21 21 21 20 19 19 20 20 20 0 Innovation/ Technology Office 4 2 3 3 3 3 3 3 3 3 3 3 0 Safety & Risk 3 3 2 2 2 2 2 2 2 2 2 2 0 Clerk 5 5 5 5 5 5 5 5 5 5 5 5 0 Common Council 9 9 9 9 9 9 9 9 9 9 9 9 0 Legal Department 11 10 11 11 11 11 11 9 11 11 11 11 0 Sub Total 67 64 65 65 65 65 64 61 63 64 64 64 0 Code Enf. /Animal Control 24 23 23 22 22 23 23 23 23 23 23 23 0 Dept. of Community Investment 25 23 23 24 24 24 25 25 24 24 24 25 0 Parks & Recreation Administration 10 10 10 10 10 10 10 10 11 10 10 10 0 Maintenance 44 44 44 44 43 43 44 45 44 42 42 42 0 Golf Operations 8 8 8 8 8 8 8 8 8 8 8 8 0 Recreation Ops 26 24 24 24 24 25 25 25 25 25 25 25 0 Zoological Ops 1 1 1 1 1 1 1 1 1 1 1 1 0 Graffiti Removal 1 1 1 1 1 1 1 1 1 1 1 1 0 Recreation Non-reverting 1 1 1 1 1 1 1 1 1 1 1 1 0 Sub Total 91 89 89 89 88 89 90 91 91 88 88 88 0 Public Safety Police 306 302 302 304 300 297 299 297 297 298 294 300 0 Communications 0 7 0 0 0 0 0 0 0 0 0 0 0 * see narrative Fire 258 258 258 260 260 260 259 258 259 259 259 259 0 Sub Total 564 567 560 564 560 557 558 555 556 557 553 559 0 Public Works Central Services 37 34 34 33 34 35 34 34 35 35 34 34 0 Office of Sustainability 2 2 2 2 2 2 2 2 2 2 2 2 0 Engineering 16 15 15 15 16 16 17 16 17 17 17 16 0 Maintenance 3 3 3 3 3 3 3 3 3 3 3 2 0 Solid Waste Operations 21 20 21 21 21 20 19 20 21 20 21 21 0 Code Clean Crew 4 4 4 4 4 4 4 4 4 4 4 4 0 Street Operations 56 56 56 55 56 56 56 56 55 53 53 53 0 Sewer Operations 33 33 30 30 28 30 31 30 29 30 30 30 0 Waste Water Ops 44 44 44 43 43 42 41 41 41 41 43 43 0 Organic Resources 6 6 6 6 6 5 5 5 6 6 6 6 0 Water Utility Ops 68 68 68 68 67 69 69 66 68 68 69 69 0 Sub Total 290 285 283 280 280 282 281 277 281 279 282 280 0 Building Department 13 13 13 13 13 13 13 13 13 12 12 13 0 Human Rights 6 6 6 6 6 6 6 6 6 6 6 6 0 Morris & Palais 14 14 14 14 14 14 14 14 14 14 14 13 0 City Total 1,094 1,084 1,076 1,077 1,072 1,073 1,074 1,065 1,071 1,067 1,066 1,071 0 Financial Report November 2015 - Headcount Staffing Page 23 of 25 City of South Bend Staffing Headcount Part Time Staff Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor 1 1 1 1 1 1 1 1 1 1 1 0 311 Call Center 1 1 1 1 1 1 1 1 0 0 0 0 Admin & Finance 1 1 1 1 1 1 1 1 0 0 0 0 Clerk 0 0 0 0 0 0 0 0 0 0 0 0 Common Council 0 0 0 0 0 0 0 0 0 0 0 0 Legal Department 1 1 1 1 1 1 1 1 1 1 1 0 Sub Total 4 4 4 4 4 4 4 4 2 2 2 0 Code Enf. / Animal Control 2 2 2 2 2 2 2 2 2 2 2 0 Dept. of Community Investment 0 0 0 0 0 0 0 0 0 0 0 0 Parks & Recreation Administration 5 5 5 4 4 4 2 4 4 3 6 0 Maintenance 3 3 4 7 12 13 13 11 10 9 10 0 Golf Operations 0 1 20 29 34 34 33 34 30 30 30 0 Recreation Ops 31 32 32 30 30 32 25 29 30 31 31 0 Zoological Ops 0 0 0 0 0 0 0 0 0 0 0 0 Graffiti Removal 0 0 1 1 1 0 0 0 0 0 0 0 Sub Total 39 41 62 71 81 83 73 78 74 73 77 0 Public Safety Police 5 5 5 5 5 7 2 9 9 6 29 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 5 5 5 5 5 7 2 9 9 6 29 0 Public Works` Central Services 1 1 - 1 1 1 1 1 1 1 1 0 Engineering 3 3 3 3 3 2 2 2 2 2 2 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 1 1 2 1 0 0 0 0 0 0 0 Street Ops 4 3 3 3 2 0 7 4 4 4 4 0 Sewer Ops 0 0 0 0 1 0 0 3 3 3 3 0 Waste Water Ops 0 0 0 0 0 0 0 0 0 0 0 0 Water Utility Ops 3 3 3 3 3 3 3 3 3 5 5 0 Sub Total 11 11 10 12 11 6 13 13 13 15 15 0 Building Department 0 0 0 0 0 0 0 0 0 0 0 0 Human Rights 2 2 2 2 2 2 2 2 2 2 1 0 Morris & Palais 5 5 5 5 5 5 5 5 5 5 5 0 City Total 68 70 90 101 110 109 101 113 107 105 131 0 Financial Report November 2015 - 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 1 1 1 1 0 0 0 Admin & Finance 4 1 1 1 2 5 5 2 1 1 1 0 Safety and Risk 0 0 0 0 0 1 1 1 1 1 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 4 1 1 1 2 7 7 4 3 2 1 0 Code Enforcement 0 0 0 0 1 0 0 2 3 3 3 0 Dept. of Community Investment 0 0 0 0 0 0 0 0 0 0 0 0 Parks & Recreation Administration 5 5 5 5 7 7 7 7 7 7 6 0 Maintenance 11 10 9 16 35 32 29 25 16 16 9 0 Golf Operations 2 3 10 11 16 25 20 22 18 18 18 0 Recreation Ops 46 47 38 46 83 160 147 135 71 67 52 0 Zoological Ops 0 0 0 0 0 0 0 0 0 0 0 0 Graffiti Removal 0 0 0 0 0 1 1 2 2 2 2 0 Sub Total 64 65 62 78 141 225 204 191 114 110 87 0 Public Safety Police 27 27 27 27 27 39 11 42 42 36 14 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 27 27 27 27 27 39 11 42 42 36 14 0 Public Works Central Services 0 0 0 0 0 1 1 0 0 0 0 0 Engineering 4 4 5 5 10 10 12 4 3 2 3 0 Energy / Sustainability 4 4 4 4 5 5 0 3 3 3 3 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 3 3 9 8 10 9 10 9 9 9 8 0 Street Ops 1 4 1 0 4 6 6 6 2 1 1 0 Sewer Ops 2 0 2 2 6 5 5 5 3 1 1 0 Leaf Pickup 1 0 1 1 0 0 0 0 0 17 23 0 Waste Water Ops 0 0 0 0 1 0 0 0 0 0 0 0 Organic Resources 0 0 0 0 0 0 0 0 0 0 0 0 Water Utility Ops 1 1 1 0 2 2 1 0 0 0 0 0 Sub Total 16 16 23 20 38 38 35 27 20 33 39 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 111 109 113 126 209 309 257 266 182 184 144 0 Financial Report November 2015 - Headcount Staffing Page 25 of 25