Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
07-2015 Financial Report
Period Ending: Issued By: July 31, 2015 Controller 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 Chief of Staff Deputy Chief of Staff Controller Deputy Controller City Finance Director Sr. Budget Analyst Department Heads Fiscal Officers City Common Council Pete Buttigieg James Mueller Brian Pawlowski John Murphy Jennifer Hockenhull Rahman Johnson Cecil Eastman Financial Report July 2015 Page 1 of 25 July 31, 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 For discussion on property taxes, see section listed below. The overall percentage of budgeted revenues that have been received by the city is 56 %. The overall percentage of collected revenue amount for July 2014 was 55 %. Revenue type 369 (Memorial Hospital), has reached 100% of its budgeted revenue. This is revenue from Leighton Plaza for common area fees. It is a lease between Memorial Hospital and the South Bend Redevelopment Commission. 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. Revenue by fund As of July 30, 2015, the general fund has received 56% of its budgeted revenue, compared to 54% last year. The following funds have reached slightly above the normal percentage of their 2015 budgeted revenue amount at this time: Funds 249, 404, and 408 received their distributions on time this month. 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 139% 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 100% of its budgeted revenue. This is due to a transfer of $256,085 from fund 641 (Sewage Works Operations) for reserve purposes. Fund 227 (loss recovery), is at 100% of its budgeted revenue. This is revenue from both interest as well as the lamppost program. Fund 661(2012 Sewer Bond), is at 167% or $26,654 over its budgeted revenue. This is revenue from bank and investment interest. Property taxes Property taxes are received in June and December. Property taxes collected in June 2015 totaled -$39.6 million. Civil city funds received -$25.5 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. 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 As of July 2015, the City has spent 43% of budgeted expenditures, compared to 40% of budgeted expenditures in July 2014. The General Fund has spent 59% of its 2015 budgeted expenditures, versus 55% in 2014. The following funds have reached 50% 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). This month, Funds 420 and 426 had higher expenditures as money was transferred to Fund 324 (River West - Airport). This is a result of the TIF realignment. Debt In July 2015, several debt service payments were made in the amount of - $865,539 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. Also this month, $5.6 million new debt was added for the Parks and Recreation bond. Headcount The Full Time Headcount as of July 2015 was 1,065 vs. a budgeted amount of 1,094. Currently, there are a total of 29 vacant positions. The 29 open positions are in the following departments: Public Safety (9), Public Works (13), Code Enforcement / Animal Control (1), and General Government (6). * 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. If you have any questions regarding this report, please contact John Murphy at (574) 235 -7678. Financial Report July 2015 Page 2 of 25 City of South Bend Period Ending: July 31, 2015 Revenue by Type Report S Fund % Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Budget I f Bud et Property Tax ,to Excise Tax various 1,549,713 1,549,713 311 Property Tax Civil City various various 465,648 31,642 465,648 25,564,735 tel Motel Tax Century Center 25,564,735 45,606,508 56% 311 Property Tax TIF Districts various tel Motel Tax Century Center 324 292,000 1011289 14,121,026 490,500 14,121,026 24,514,604 58% Sub Total _ _ _ _ _ tel Motel Tax Cum Cap Impm 407 453,318 39,685,761 150,000 39,685,761 70,121,112 57% Income Tax 806,725 3,770,811 5,346,126 14,750 69,400 _ _ _ _ _ _ _ _ _ NA 315 Econ Development Income Tax 408 765,101 765,101 1,463,758 748,490 748,490 748,490 5,239,428 8,981,877 58% 316 Local Option Income Tax -PS 249 538,849 538,849 1,077,698 538,849 538,849 538,849 3,771,944 6,466,190 58% 316 County Option Income Tax 404 738,326 738,326 1,476,652 738,326 738,326 738,326 5,168,282 8,859,912 58% Sub Total 101 2,042,276 2,042,276 4,018,108 2,025,665 2,025,665 2,025,665 14,179,654 24,307,979 58% ;ounty (Remitted by) ,to Excise Tax various 1,549,713 1,549,713 2,508,752 mmercial Vehicle Tax various 465,648 31,642 465,648 883,438 tel Motel Tax Century Center 670 656,725 656,725 1,313,450 1,313,436 tel Motel Tax Century Center 324 292,000 1011289 292,000 490,500 tel Motel Tax Century Center 420 _ _ _ _ _ _ _ _ _ _ _ _ _ _ tel Motel Tax Cum Cap Impm 407 453,318 150,000 150,000 150,000 b Total 50% 656,725 292,000 2,015,361 806,725 3,770,811 5,346,126 State of Indiana Remitted b 312 CRED Tax 434 1,729 226 31,642 12, 460 17,914 104,502 99,293 150 0% 335 Cigarette Tax 1011407 58% 340 810 1011289 149,739 149,739 317,818 47% 335 State Pension Subsidy 7011702 453,318 453,318 453,318 453,318 5,705,692 453,318 5,705,692 11,411,384 50% 335 CTP Distribution 439 13,183 11,261 14,750 69,400 _ _ _ _ _ _ _ _ _ NA 335 Gaming Proceeds 101 51,834 52,953 53,072 51,034 371,311 798,302 47% 600,000 0% 335 Gasoline Tax 2021251 348,926 369,636 422,676 426,523 435,833 373,229 381,514 2,758,338 4,692,000 59% 335 Liquor Excise tax 101 41,349 383,538 417,794 450,403 363,667 23,001 64,350 65,000 99% 335 Liquor Gallonage Tax 101 67,259 Internal Service Reimbursement 30,798 114,099 125,201 60,184 158,241 200,000 79% 335 ProfSports Development Tax 377 63,326 142,874 63,470 35,855 29,251 42,734 102,397 479,907 747,750 64% 335 Wheel Tax 202 418,779 67,941 392,533 215,701 392 Internal Fund Transfers 1,094,954 2,050,000 53% Sub Total 1,062,256 939,639 512,510 554,087 885,709 680,785 6,271,395 567,096 10,411,221 20,084,102 52% governmental Sources deral Drug 299 1,729 226 31,642 12, 460 17,914 104,502 99,293 63,744 75,000 vte Drug 216 58% 340 810 1011289 13,504 14,314 35,000 yment in Lieu of Tax various 453,318 453,318 453,318 453,318 453,318 453,318 453,318 3,173,226 5,439,810 ntractual Service 211 13,183 11,261 14,750 69,400 8,480 37,285 8,590 162,950 243,000 nds various 51,834 52,953 53,072 51,034 371,311 798,302 47% 380 Central Service b Total 199,523 468,230 464,579 500,519 535,178 479,712 490,603 475,412 3,414,234 5,792,810 Charge for Service Internal City 340 Liability Insurance 226 99,293 101,897 101,897 104,502 99,293 104,502 99,293 710,677 1,222,727 58% 340 General Government Misc Ch s 1011289 50 50 6,000 1% 340 Police Take Home Vehicle 278 7,060 4,680 4,670 4,640 4,590 4,560 6,770 36,970 61,100 61% 349 Central Service 222 51,890 62,282 48,246 51,834 52,953 53,072 51,034 371,311 798,302 47% 380 Central Service 222 199,523 201,656 208,098 203,681 214,579 195,611 183,083 1,406,230 2,800,655 50% 380 Energy Office Reimbursements 222 383,538 417,794 450,403 363,667 331,109 330,089 305,693 2,582,293 4,471,200 58% 380 Internal Service Reimbursement various 114,099 125,201 140,744 220,036 141,034 112,567 223,242 1,076,922 3,050,556 35% 392 Administration Fee 101 303,580 303,580 303,580 303,580 303,580 303,580 303,580 2,125,057 3,642,953 58% 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 22,708,809 34,300,476 662L 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 8,522,903 16,427,996 52% Financial Report July 2015 - Revenue Report Page 3 025 City of South Bend Period Ending: July 31, 2015 Revenue by Type Report S Fund Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Budget I of Bud et 396 Central Service Refunds 222 2,968 1,971 1,970 1,742 1,618 10,268 22,000 47� 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 39,564,664 66,817,165 595 ,d Party Revenue 331 Federal Grants various 321,650 121,681 172,179 326,005 247,506 251,238 133,560 1,573,820 7,317,445 225 332 Solar Energy Grant 222 29,167 29,167 N! 340 No EMS Service 288 400,000 3,600,000 115 11,080 4,675 39,099 808 4,069 59,730 150,000 40� 340 Memorial Hospital Neo Natal 101 10,022 56,678 36,788 10,545 10,231 2,280 70 126,613 125,000 1015 350 Job Target Penalty Fee 408 13,394 8,091 4,182 354,660 354,660 354,660 100 364 Cable TV Franchise Fees 101 177,167 4,795 5,793 183,970 361,137 700,000 52� 366 AT&T Franchise Fees 101 69,037 322 Building Fees 600 69,608 138,644 276,000 50� Sub Total 113,669 10,022 302,882 47,868 15,220 657,567 3,088 4,138 1,040,785 1,605,660 655 rants 331 Federal Grants various 321,650 121,681 172,179 326,005 247,506 251,238 133,560 1,573,820 7,317,445 225 332 Solar Energy Grant 222 29,167 29,167 N! 334 State Grants various 400,000 400,000 3,600,000 115 Sub Total 321,650 121,681 172,179 326,005 247,506 251,238 562,727 2,002,987 10,917,445 18`, Fees for Services External 320 Inspections Central Service 222 330 490 10 230 40 1,100 1,400 79% 321 Business License 1011222 31,966 22,740 20,630 13,394 8,091 4,182 1,652 102,654 126,490 81% 321 Code and Animal Fees 600 3,725 4,795 5,793 6,503 3,595 5,346 4,447 34,204 75,200 45% 322 Building Fees 600 65,509 54,764 181,309 96,256 225,069 113,669 160,693 897,268 1,083,832 83% 322 Code Enforcement Fees 600 150 450 1,500 500 50 1,000 1,645 5,295 2,800 189% 322 EMS Operating Fund 288 2,233 2,460 1,295 2,375 2,046 2,074 2,237 14,720 25,000 59% 322 General Government Fees 101 6,640 725 1,030 2,430 2,115 1,605 2,030 16,575 13,000 128% 341 General Government Various various 1,736 1,940 1,164 1,602 4,952 2,701 1,448 15,543 33,405 47% 342 Highway &Streets 1011202 24,377 9,564 2,090 80,755 25,490 24,156 166,433 390,000 43% 342 Public Safety various 22,350 26,067 13,071 12,281 10,209 9,641 12,027 105,647 134,500 79% 342 EMS - Count Fees 288 426,728 142,243 142,243 142,243 142,243 995,698 1,667,565 60% 342 EMS - Capital Fund 287 396,727 396,727 400,000 99% 342 EMS - Operating Fund 288 198,675 156,466 226,551 290,112 249,516 246,378 195,180 1,562,878 2,902,500 54% 342 EMS - Neo Natal 288 74,340 40,500 114,841 385,000 30% 344 Solid Waste 610 401,357 397,131 400,073 405,112 406,770 408,056 407,018 2,825,517 5,091,168 55% 344 Code Environmental Clean Up 101 1600 11,215 1,263 1,051 27,629 4,609 11,674 3,439 60,880 54,000 113% 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 20,391,903 35,234,467 58% 344 Sewer Repair Insurance 640 50,523 52,458 49,781 51,388 49,827 50,237 50,310 354,524 551,200 64% 344 Water Leak Insurance 620 80,558 79,817 80,181 74,113 80,653 80,717 80,647 556,684 960,000 58% 346 Water Works Utility 620 979,733 976,299 965,088 992,620 1,024,608 1,263,334 1,083,848 7,285,530 13,678,403 53% 346 Solid Waste Misc 610 5,075 4,623 6,710 97,941 7,710 8,274 4,328 134,660 128,148 105% 346 Project ReLeaf 655 36,473 36,203 36,396 36,456 36,590 36,613 36,605 255,337 429,000 60% 347 Parks& Recreation various 88,374 165,687 152,152 218,148 248,263 326,282 439,665 1,638,571 3,565,625 46% 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 33,091 100,000 33% 349 Parking Garage Fees 601 77,130 56,458 83,412 67,492 90,594 81,037 75,732 531,855 908,675 59% 349 Code Demolition Board Up 1011600 2,932 9,994 467 12,513 11,595 22,467 22,601 82,568 39,000 212% 349 Parking Century Center 670 8,435 17,329 24,852 7,896 7,058 10,405 3,115 79,090 103,297 77% 349 Parking SBCDA 3241420 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 353,813 484,020 73% 352 Forfeits various 3,455 875 2,775 4,570 2,352 19,150 5,508 38,686 258,820 15% 354 Ordinance Violation various 1,305 2,165 4,133 2,313 1,662 3,474 1,287 16,339 42,000 39% 360 Morris PAC various 52,561 22,635 129,679 31,466 52,867 108,722 6,419 404,348 934,900 43% 360 Palais Royale various 22,259 6,290 10,385 18,475 17,124 14,402 27,895 116,829 244,270 48% 360 Parks& Recreation various 26,797 14,565 4,051 10,548 20,675 12,889 4,294 93,820 106,700 88% 360 Police various 3,170 4,378 2,510 1,609 7,606 4,440 2,373 26,086 62,100 42% 360 TIF various 5,056 2,657 3,480 3,373 3,284 52,071 4,525 74,446 44,806 166% 360 Central Services 222 19,705 3,212 15 320 4,646 855 520 29,273 37,087 79% 360 Century Center 670 5,117 4,970 35,471 3,054 7,135 324 676 24,429 15,000 - 163% 360 Dept Of Community Investment 2111212 95,353 85,179 2,438 37 183,007 349,500 52% 360 EMS Operating Fund 288 60 102 38,521 38,684 5,000 774% 360 Engineering / Curb & Sidewalk 101 209 200 32,648 500 660 785 475 29,819 22,000 - 136% 360 Fire and Police Pension Fund 7011702 3,743 1,477 5,221 8,000 65% 360 Self Funded Employee Benefits 711 6,000 6,000 6,000 100% 360 General Government Various 101131226 196 853 1,386 12,290 14,725 4,250 346% 360 Motor Vehicle Highway Scrap Meta 202 1,735 1,127 900 3,762 4,000 94% 360 Motor Vehicle Highway Curb Pr gm 202 3,615 324 6,819 4,538 2,992 3,583 5,095 26,967 50,000 54% 360 Local Roads and Streets 251 14,730 5,644 20,375 22,000 93% 360 ProfessionalSports Development 377 29,523 26,710 56,233 60,661 93% 360 Cumulative Capital Improvement 407 200 0% Financial Report July 2015 - Revenue Report Page 4 025 City of South Bend Period Ending: July 31, 2015 Revenue by Type Report S Fund % Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Budget I of Bud et 360 UDAG 410 18, 739, 220 15,89Z 928 98,485 143,363 various 34,357 1,472,130 1 10,000 251,849 528,576 48% 360 Code /Animal Control 600 20,000 oceeds F.A. Disposal 0 0 0 1 le of Fixed Assets 0 100 0% 360 Parking Garage 601 various 3 1,000 b Total 34,357 4 7 2,587,487 NA 360 Solid Waste Fund 610 2,000 0% 360 Waste Water 6411719 2,142 3,229 998 5,441 14,166 14,343 40,318 55,200 73% 360 Water Works Utility 620 908 1,318 17 1,382 3,625 39,580 9% 362 Dept Of Community Investment 212 1,847 1,847 3,694 4,000 92% 362 Palais Royale 101 572 2,269 2,588 10,146 5,182 11,071 4,098 35,925 72,000 50% 362 Police 101 7,262 7,262 NA 362 Parks B Recreation 201 2,064 4,531 4,138 4,574 6,162 2,701 2,717 26,887 40,000 67% 362 S Bend School Corp Fee 407 25,000 0% 362 TIF Property various 15,621 17,156 19,059 30,447 12,509 22,614 11,903 129,309 339,025 38% 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 1,062,756 2,387,518 45% 399 Bosch Retention Project 210 29,759 29,759 59,966 50% 399 Principal on Loan various 1,799 20,705 18,387 19,002 18,841 36,515 2,067 117,314 218,398 54% 399 Principal Income xxx 368,031 146,068 514,099 1,224,390 42% Sub Total 5,476,452 6,558,266 5,412,473 6,162,214 6,036,003 6,561,444 6,413,465 42,620,316 76,128,541 56% ome nk Account Interest various 197,258 51,054 75,698 118,454 65,582 223,194 147,082 878,323 872,801 b Total 197,258 51,054 75,698 118,454 65,582 223,194 147,082 878,323 872,801 i Contribution 101 330,000 330,000 330,000 nations various 2,072 990 405 46 3,493 2,131 376 9,512 425,356 b Total 2,072 990 405 46 3,493 2,131 330,376 339,512 755,356 enervation mpost Program 227 19,750 5,750 750 1,000 500 27,750 30,000 lais 450 1,225 3,703 357 982 1,115 592 1,556 9,530 16,000 b Total 1,225 3,703 20,107 6,732 1,865 1,592 2,056 37,280 46,000 ets 16, 029, 980 18, 739, 220 15,89Z 928 18, 890, 401 60, 878,117 various 34,357 1,472,130 1 1,506,488 2,554,487 eter Hydrant Reimbursement 620 2,177 472 8,103 16,154 3,195 30,100 20,000 oceeds F.A. Disposal 600 0 0 1 le of Fixed Assets various 0 0 12,000 hicle Damage Reimbursement various 1,000 b Total 34,357 1,474,307 473 8,103 16,154 3,195 1,536,588 2,587,487 Revenue Total 12, 866, 555 16, 029, 980 18, 739, 220 15,89Z 928 18, 890, 401 60, 878,117 16,184, 938 - - - - - 159,482,138 285,382,434 56% report 12, 866, 555 16, 029, 980 18, 739, 220 15,89Z 928 18, 890, 401 60, 878,117 16,184, 938 - - - - - 159,482,138 285,382,434 0 0 0 1 0 0 0 0 Financial Repot My 2015 - Reven. Report Page 5025 City of South Bend Revenue by Fund Report Period Ending: July 31, 2015 s i Fund Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I Bud et I ofeud et General Government 0000 General Revenues 101 1,167,120 944,443 669,668 734,592 944,924 23,042,910 1,117,315 28,620,972 50,243,482 57% 0101 Mayor 101 35 15 50 20 120 700 17% 0104 311 Call Center 101 55,195 36,290 43,995 32,989 35,855 35,676 48,025 288,025 486,733 59% 0301 Common Council 101 41 31 15 231 31 31 46 425 8,666 5% 0401 Administration and Finance 101 220 336 556 600 93% 0501 Legal 101 508 18,113 3 3 18,626 53,500 35% Sub Total 1,222,390 981,491 714,030 785,924 980,863 23,078,638 1,165,387 28,928,724 50,793,681 57% Public Works 0602 Engineering 101 225 303 1,104 635 275 2,542 77,027 3% Sub Total 225 303 1,104 635 275 2,542 77,027 3% Public Safety 0801 Police 101 6,604 11,372 38,367 2,321 20,918 11,729 17,010 108,322 555,200 20% 0901 Fire 101 10,022 59,625 37,787 11,021 10,231 2,280 4,152 135,118 138,300 98% Sub Total 16,625 70,998 76,154 13,343 31,149 14,009 21,162 243,440 693,500 35% Code Enforcement 1205 Code Unsafe Building 101 143 733 876 NA 1207 Code Animal Control 101 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 401,227 923,000 43% 0405 Palais Royale 101 24,368 9,347 13,572 30,163 23,990 26,667 34,420 16Z527 335,270 48% Sub Total 77,697 3Z647 141,998 62 003 75,773 135,689 37,947 563,754 1,258,270 45% General Fund Revenue Total 1,316,569 1,085,136 931,673 861,573 1,088,889 23,228,972 1,224,771 - - - - - 29,737,583 52,822,478 56% Financial Report July 2015 - Expenditure Summary Page 6 of 25 City of South Bend Revenue by Fund Report Period Ending: July 31, 2015 a % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I Budget I of8ud et Parks & Recreation 0000 Parks General revenue 201 76,460 74,383 77,445 74,566 73,993 4,547,155 75,491 4,999,495 8,860,875 56% 1100 Administration 201 2,119 4,537 4,158 4,527 6,168 2,736 2757 27,003 40,600 67% 1101 Maintenance 201 19,996 2425 3,330 1,823 4,085 2915 99,072 133,645 319,600 42% 1102 GolfOperations 201 161 63,205 31,916 147,893 185,191 234,366 210,016 872,750 1,535,000 57% 1103 Recreation Division 201 26,067 16,036 5,765 54 3,370 19,150 37,653 108,093 185,640 58% 1104 Potawatomi Zoo 201 NA 1108 Grafd Removal 201 11,341 13,003 7,268 6,941 38,554 89,000 43% Recreation Non Reverting 203 65,607 98,601 lIZ441 78,613 75,090 82,878 97,148 610,379 1,578,935 39% East Race Waterway 271 5 1 2 3 2 3 2 18 50 36% Coveleski Stadium 401 36 9 14 23 13 43 27 165 15,100 1% Zoo Endowment 403 43 11 17 28 15 52 33 200 200 100% Park Non Reverting 405 4,435 260 261 1,080 1,573 1,269 918 9,796 143,700 7% Sub Total 194,930 270,809 235,349 321,616 356,766 4,890,567 530,060 6,800,097 12,758,700 53% Public Works Motor Vehicle Highway 202 716,020 1,133,459 404,476 730,770 1,504,136 316,658 328,650 5,134,169 9,701,800 53% Central Services 222 655,888 688,603 709,665 623,157 619,227 584,294 570,801 4,451,636 8,151,184 55% Central Services Capital 224 271,850 0% Local Roads & Streets 251 87,782 90,155 98,666 112 757 99,309 97,010 97,383 683,063 1,821,300 38% Pro'ect ReLeaf 655 37,371 36,419 36,757 37,059 36,928 37,776 37,365 259,676 431,700 60% Sub Total 1,497,062 1 948 636 1,249,565 1 503 744 Z259,601 601 1 035 738 1,034,198 10 528,543 20 377,834 52% Public Works Solid Waste Solid Waste Operations 610 408,178 401,846 406,879 589,225 414,603 416,858 492 885 3,130,475 5712,289 55% Solid Waste Capital 611 190,033 10,001 84,001 17 46,000 189,015 519,067 753,011 69% Sub Total 598,211 401,846 416,880 673,226 414,621 46Z858 681,900 3,649,542 6,465,300 56% Public Works Water Utility 0000 Water Works Revenues 620 916,194 910,250 905,299 929,577 96Z334 1,179,467 1 007 966 6,811,086 12 724,463 54% 0630 Water Leak Insurance 620 80,558 79,817 80,181 74,113 80,653 80,717 80,647 556,684 960,000 58% 0660 Clay Water 620 68,898 68,829 66,186 76,543 74,475 111,884 87,990 554,805 1,096,020 51% Waterworks Capital 622 Z 776 682 1,098 1,741 946 3,225 Z006 12 473 10,000 125% 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 6,057 6,000 101% Waterworks Sinking 625 468 340,551 170,359 170,557 170,477 171,158 171,165 1,194,735 2,050,078 58% Waterworks Bond Reserve 626 1,425 353 572 1,078 3,429 9,500 36% Waterworks Debt Reserve 629 1,840 150,683 775 1,279 695 2367 1,499 159,136 162,749 98% Sub Total 1,073,645 1,551,529 1,225,058 1,254,745 1,290,083 1,550,537 1,353,351 9,298,948 17,019,355 55% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 51,853 52,790 50,328 52,269 50,308 51,875 51,350 360,773 554,800 65% 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 19,253,128 33,201,605 58% 0621 Sewer Department 641 998 530 1,039 2567 2,000 128% 0625 Concrete Crew 641 4,705 10,805 16,966 IZ672 45,147 75,000 60% 0630 Wastewater Operations 641 NA 0631 Organic Resources 641 NA 0650 Clay Sewage 641 157,337 162,329 150,270 180,708 171,223 173,367 184,685 1,179,920 2,059,962 57% Sewage Ca ital 642 3,385 815 1,313 2036 4,001,015 6,750 4,451 4,019,764 5,398,000 74% Sewage Reserve 643 3,020 256,833 1,248 2,104 1,143 3,895 2466 270,710 271,612 100% Sewer Bond 2007 647 NA Sewage Bond Sinking 649 774,321 773,801 774,198 775,158 774,671 778,095 776,235 5,426,480 9,288,088 58% 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 3,724 6,000 62% 2012 Sewer Bond 661 14,968 3,669 5,897 9,437 5,061 17,033 10,588 66,654 40,000 167% 2013A Sewer Refund Bonds 664 4 1 2 3 1 5 3 18 50 37% Sub Total 3,635,057 3,878,074 3,659,472 3,776,819 7,813,066 3,860,087 4,006,311 30,628,885 50,897,117 60% Financial Report July 2015 - Expenditure Summary Page 7 of 25 City of South Bend Revenue by Fund Report Period Ending: July 31, 2015 s % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I Budget I ofeud et Public Safe - Police 601 909 30 (30) 909 4,050 22% Police Seizures 216 162 41 876 108 59 200 13,631 15,076 36,050 42% Curfew Violations 218 11 3 17 7 4 38 21 99 1,025 10% Law Enforcement Education 220 24,859 28,459 17,376 64,238 18,300 17,495 20,976 191,702 270,000 71% Public Safety LOIT 249 540,008 539,058 430 1,078,221 539,072 539,985 539,392 3,776,166 6,472,240 58% Excess Welfare Public Safety 252 0 - - - - 280 - 0 15.900 NA Police Take Home Vehicle 278 14,575 9,474 9,529 9,591 9,352 9,718 13,925 76,164 124,200 61% Police Block Grant 280 3 1 1 2 1 4 3 16 NA Police Grants 292 55 56,891 56,947 90,000 63% Police cademy 294 11,010 7,628 1,101 893 21 68 43 20,764 22,700 91% COPS More Grants 295 564 782 681 33,633 619 832 807 37,916 150,258 25% Drua Enforcement 299 1,817 83 31,713 12,542 18,004 98 95 64,352 77,000 84% K -9 Unit 705 503 1 1 2 1 1,003 3 1,513 2,000 76% Sub Total 593,567 585,530 61,724 1,256,127 585,433 569,440 588,894 4,240,715 7,245,473 595, Publie Safe - Fire Emerge' Telephone System 244 19 19 20 97% ital 287 396,727 13 206 112 383 242 397,684 1,150,350 35% erafin Fund 288 204,337 16 9,122 667,161 441,484 434,559 508,444 386,909 2,812,016 5,679,065 50% 289 3 732 10 095 10 18 f0 34 21 13 921 14 100 99% scue 291 3,093 Z423 3,038 651 12 628 694 8,455 30,983 45,350 68% Sub Total 211,182 578,368 670,222 44Z360 447,309 509,554 395,628 3,254,623 6,888,885 47% Department of mmunity Investment Studebaker /0liver 209 959 3,612 16,720 20,676 15,140 16,755 9,340 83,202 644,000 13% State Grant 210 290 70 112 181 93 36,192 400,000 436,939 3,673,510 12% ,,Cl Operating 211 14,699 503,257 17,090 72,469 500,684 38,606 9,332 1,156,137 Z 634,425 44% 0000 Dept of Community Investment 212 3,790 12Z 753 240,619 202 172 106,570 83,119 85,649 844,673 5,890,000 14% xxx Programs 212 95,353 124,819 154,530 374,702 NA 0000 Economic Revenue Bond 281 24 6 10 16 8 29 18 111 300 37% Sub Total 115,115 629,699 274,551 295,513 747,314 329,231 504,340 Z895,764 764 12 842,235 23% 0000 Parking Garage Revenue 601 909 30 (30) 909 4,050 22% 0460 Main Street 601 20,879 17,180 24,111 20,473 21,925 20,694 18,076 143,338 267,737 54% 0462 Leighton Plaza 601 38,528 22,329 36,745 34,605 44,243 40,602 44,536 261,588 417,088 63% 0463 Enforcement 601 5,219 7,017 6,595 8,281 7,416 10,105 7,428 52,060 117,400 44% 0464 Wayne Street 601 17,498 16,724 22,424 12,234 24,291 19,471 13,079 125,721 222,950 56% 0465 Eddv Street Commons 601 - - - - - 280 - 280 15.900 2% Financial Report July 2015 - Expenditure Summary Page 8 of 25 City of South Bend Revenue by Fund Report Period Ending: July 31, 2015 s % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep 1 Oct Nov Dec I Year I Budget I ofeud et Other Miscellaneous Rain Da 102 7,630 1,888 3,064 4,949 2,689 9,170 5,809 35,200 34,680 101% Excess Le 103 1 1 2 1 4 2 12 20 58% Gift Donation Bequest 217 1,618 989 364 80 195 174 370 3,791 398,800 1% Loss Recovery 227 5,206 4,007 21,727 8,608 2,128 5,168 2,938 49,782 50,000 83% Human Rights 258 2,065 7,188 5,759 3,628 6,425 699 41,861 67,625 209,950 32% Morris Palais Marketing 273 274 6 1,373 366 1,258 428 3,164 5,868 18,000 38% Professional Sports Development 377 93,375 142,965 63,547 36,086 29,386 43,242 129,447 538,050 809,511 66% 1201 Code Enforcement 600 18,559 529,948 11,282 46,664 24,464 56,078 1,050,947 1,737,941 2,417,446 72% 1207 Animal Control 600 3,725 162,197 5,846 6,503 3,595 5,346 319,201 506,413 704,768 72% 1306 Building Operations 600 66,158 54,907 181,599 96,899 225,373 125,219 163,847 914,002 1,086,999 84% Century Center 670 32,985 783,504 203,146 211,537 169,457 268,954 761,283 2,430,867 3,819,251 64% Century Center Capital 671 24 21 23 22 74 106 95 366 500 73% Century Center Energy Saying 672 50,000 7 4 50,011 50,000 100% Sub Total 231,619 1,687,621 497,732 415,343 515,044 514,596 2,478,970 6,340,925 9,609,925 66% Business Insurance 0000 Business Insurance Revenues 226 104,344 103,108 103,815 107,554 100,942 112,231 102,631 734,625 1,245,602 59% 0418 Workers Compensation 226 17,000 0% Sub Total 104,344 103,108 103,815 107,554 100,942 112 231 102 631 734,625 1,262,602 58% Fiducia Trust & Agency Fire Pension 701 688 130 54 3,743 2 518 013 1,415 2 524,043 5,044,525 50% Police Pension 702 1,133 230 184 3,187,679 62 3189,288 6385,359 50% Employee Benefits lCi 711 1,248,718 1 226 227 1,217,884 1 210 699 1,200,922 1 200 207 1,197,000 8 501, 658 16 357, 770 52% Unemployment Comp 713 8,685 8,526 8,559 8,613 8,549 8,731 8,634 60,296 113,796 53% Cemetery Trust 730 25 6 10 16 9 30 19 116 150 77% Sub Total 1,259,249 1 235 119 1,226,689 1 223 071 1,209,480 6 914 660 1,207,131 14 275,401 27 901, 600 51 Civil City Revenues 12,653,540 15,953,113 10,816,094 15,511,366 18,836,330 46,560,441 15,913,717 - - - - - 136,244,600 250,256,457 54% Tax Increment Financing TIF Airport 324 50,350 33,228 6,479,376 346,205 37,081 9,550,306 29,064 16,525,611 24,944,246 66% TIF Central Development 420 695 4,240 (4,935) NA TIF West Washington 422 996 261 423 675 364 197,102 849 200,670 422,800 47% TIF Leighton Plaza 425 18,229 12,971 10,040 21,366 8,977 15,860 13,156 100,599 189,423 53% TIF Medical Service 426 1,941 501 (2,442) 0 NA TIF Northeast 429 23,215 993 1,434,000 2,685 1,830 1,397,241 4,408 2,864,373 3,829,653 75% TIF Southside 430 4,144 1,025 1,590 2,545 1,371 1,303,629 3,377 1,317,681 2,410,750 55% TIF Erskine Village 432 5,246 1,268 1,967 3,083 1,675 17,202 3,622 34,064 25,000 136% TIF Douglas Road 435 161 48 23 30 16 163,999 346 164,623 320,750 51% Northeast Residential TIF 436 1,215 352 5 1,663,572 210,999 1,876,143 2,815,000 67% Sub Total 106,191 54,887 7,920,047 376,589 51,315 14,308,913 265,821 23,083,761 34,957,622 66% Financial Report July 2015 - Expenditure Summary Page 9 of 25 City of South Bend Revenue by Fund Report Period Ending: July 31, 2015 s i Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I ud et I Of Bud et Redevelopment Commission 213,015 76,867 7,923,126 381,562 54,071 14,317,676 271,221 - - - - - 23,237,539 35,125,877 66% City Operations Total 12,866,555 16,029,980 18,739,220 15,892,928 18,890,401 60,878,117 16,184,938 - - - - - 159,482,138 285,382,434 56% Revenue report 12,866,555 16,029,980 18,739,220 15,892,928 18,890,401 60,878,117 16,184,938 0 0 0 0 0 159,482,138 285,382,434 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report July 2015 - Expenditure Summary Page 10 of 25 City of South Bend Property Tax Revenue 2014 Tax Pay 2015 Fund Period Ending: July 31, 2015 Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy Per County Collection Projected 61812015 611612015 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Receivable Rate Citv Airport TIF District General Fund 101 38,619,247.00 0.95 36,688,284.65 13,463,468.56 7,216,350.23 20,679,818.79 17,939,428.21 53.55% Parks & Recreation 201 7,742,127.00 0.95 7,355,020.65 2,699,065.71 1,446,685.42 4,145,751.13 3,596,375.87 53.55% 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 237,380.04 205,923.96 53.55% Fire Pension 701 - 0.95 - - - - - - Police Pension 702 51.87% 0.95 431 - 0.95 - - - Total - City - 47,741,754.00 432 45,354,666.30 16,317,079.08 9,247,655.76 25,564,734.84 22,177,019.16 53.55% Tax Increment Financinq 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 - - - - - NortheastResidentialTIFDistrict 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 - 39,685,761.30 35,147,360.57 53.03% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 618115 2 Distribution 2 - Issued by St. Joseph County on 6116115 Financial Report July 2015 - Property Tax Revenue Page 11 of 25 City of South Bend Property Tax Revenue 2013 Tax Pay 2014 Fund Period Ending: July 31, 2015 Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy Per County Collection Projected 61612014 612512014 1212412014 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Receivable Rate Citv Airport TIF District 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 - - - 2,478,709.77 - - - Police Pension 702 99,497.78 0.95 Erskine Commons TIF District #2 431 0.95 - Total - City - 47,454,285.14 Erskine Village TIF District #3 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 Financinq 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 616114 2 Distribution 2 - Issued by St. Joseph County on 6125114 3 Distribution 3 - Issued by St. Joseph County on 12124114 Financial Report July 2015 - Property Tax Revenue Page 12 of 25 City of South Bend Period Ending: July 31, 2015 Expenditure Report S i Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Au I Sep 1 Oct 1 Nov I Dec I Year I Budget of Bud et vemment ryor 101 80,464 52,550 48,452 55,723 53,138 57,124 79,991 427,442 741,267 1 Call Center 101 55,195 36,290 43,995 32,989 35,855 35,676 48,025 288,025 486,733 erk 101 34,775 28,270 26,114 26,345 27,469 28,359 37,398 208,729 431,573 ommon Council 101 33,803 24,869 110,974 30,970 47,806 24,460 26,243 299,124 490,150 NIT Contract 101 411 43,000 (411) 11,354 43,000 43,000 Iministration and Finance 101 187,531 134,271 139,736 136,435 154,038 136,652 198,795 1,087,458 2,020,544 gal Department 101 99,178 73,129 64,725 70,589 73,432 71,133 95,236 547,423 1,006,979 ib Total 490,946 349,379 433,994 353,052 434,738 353,404 485,688 2,901,201 5,220,246 cs igineering 101 72,931 79,671 89,919 62,192 67,688 70,000 137,148 579,548 1,058,933 ib Total 72,931 79,671 89,919 62,192 67,688 70,000 137,148 579,548 1,058,933 ty dice 101 2,557,412 1,878,728 1,990,424 1,850,902 1,869,819 1,977,962 2,485,297 14,610,545 25,633,064 lice -PS LOIT funded 101 2,562 6,199 (8,761) (212) (212) Mice Communications 101 135,031 97 8 514,528 128,638 128,638 8 906,947 1,687,540 •e 101 2,150,469 1,590,349 1,505,644 1,328,213 1,314,720 1,472,585 1,998,183 11,360,163 17,774,474 v-PS LOIT funded 101 411 (411) 11,354 11,354 x ib Total 4,845,886 3,475,373 3,487,315 3,693,643 3,313,177 3,578,773 4,494,629 26,888,795 45,095,078 cement ode 101 (710) 710 2,270 ode Unsafe Building 101 ode Animal Control 101 ib Total (710) 710 2,270 Ire nris PAC 101 96,838 87,590 80,670 75,338 75,072 81,843 94,489 591,840 1,093,132 dais Royale 101 41,912 31,105 39,827 31,888 34,119 37,926 45,965 262,742 536,293 ib Total 138,749 118,696 120,497 107,226 109,192 119,769 140,454 854,582 1,629,425 Ws iman Rights 101 50,323 31,896 19,693 30,347 27,284 23,670 37,717 220,931 373,179 ib Total 50,323 31,896 19,693 30,347 27,284 23,670 37,717 220,931 373,179 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 - - - - - 31,445,058 53,379,131 59% Financial Report July 2015 - Expenditure Summary Page 13 of 25 City of South Bend Period Ending: July 31, 2015 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Au I Sep I Oct I Nov I Dec I Year I Budget of Bud et Parks & Recreation Motor Vehicle Highay 1100 Administration 201 104,226 71,673 67,013 81,921 79,879 83,369 98,496 586,578 967,568 61% 1101 Maintenance 201 435,157 348,338 455,082 344,569 398,104 448,976 525,758 2,955,985 5,178,905 57% 1102 GolfOperations 201 66,821 76,812 203,778 123,539 118,983 170,789 179,333 940,055 1,573,436 60% 1103 Recreation Division 201 193,339 143,079 147,938 140,851 152,356 160,490 313,935 1,251,989 2,328,698 54% 1104 Potawatomi Zoo 201 392,247 lIZ389 8,788 7,968 5,262 354,274 6,760 887,687 863,017 103% 1106 Potawatomi Greenhouse 201 5,079 20,391 5,260 3,156 2005 1,101 821 37,814 53,997 70% 1108 Graffiti Removal 201 9,057 7,116 5,887 7,268 6,941 6,483 9,103 51,854 98,374 53% Recreation Non Reverting 203 43,898 60,957 66,785 87,752 84,777 111,498 117,396 573,063 1,549,469 37% East Race Waterway 271 637 455 775 2098 695 2367 1,499 2098 4,000 52% Coveleski Stadium 401 968,839 1,479,202 1,183,962 1,068,758 1,276,167 1,860,194 1,298,741 9,135,863 3,540 0% Zoo Endowment 403 2 2 49,000 0% Park Non Reverting 405 2,197 19,422 11,316 25,023 57,958 192,933 30% Sub Total 659 1,249,824 840,754 960,531 801,319 867,731 1,348,296 1,276,625 7,345,080 12,862,937 57% Vorks Motor Vehicle Highay 202 734,565 950,683 835,051 410,155 418,569 407,917 675,925 4,432,865 8,843,890 Curb and Sidewalk 202 lIZ714 39,990 31,802 29,933 21,753 32,125 60,560 328,877 1,641,496 Central Services 222 679,565 621,835 691,937 716,505 537,157 556,899 601,324 4,405,221 8,300,242 Central Services Capital 224 4,000 12% Waterworks Capital 622 15,382 67,463 3,489 1,776,763 271,850 Local Roads & Streets 251 4,155 4,853 37,032 6,650 109,145 87,781 97,882 347,498 2 126,221 Project ReLeaf 655 15,357 2281 2386 27,010 2442 2899 14,293 66,668 528,358 Sub Total 463 1,546,355 1,619,642 1,598,209 1,190,253 1,089,066 1,087,621 1,449,984 9,581,129 21,712,057 Vorks Solid Waste Solid Waste Operations 610 635,488 341,051 339,903 382,803 461,210 482,019 641,738 3,284,213 5,873,863 Solid Waste Capital 611 223,749 143 11,054 83,702 168 45,686 189,188 553,690 752,811 Sub Total 859,237 341,194 350,957 466,506 461,378 527,706 830,925 3,837,902 6,626,674 Public Works Water Utility 0630 Water Leak Insurance 620 33,830 53,166 43,413 474 131,182 93,577 95,796 451,439 1,115,000 40% 0640 Water Works 620 906,773 1,320,043 1,131,090 1,058,030 1,143,612 1,164,702 1,166,484 7,890,734 14,725,471 54% 0660 Clay Water 620 22 29,608 309 26 13 9 113 493 4,000 12% Waterworks Capital 622 15,382 67,463 3,489 1,776,763 5,782,494 109,780 25,331 221,445 838,893 26% Waterworks Construction 623 11,278 37,750 4,276 438 85,097 121,821 7,519 183,082 53,330 343% Waterworks Deposit 624 452 324 527 854 463 1,582 1,001 5,202 6,000 87% Waterworks Sinking 625 465 1 84 282 202 366,356 999 368,390 2,050,078 18% Waterworks Bond Reserve 626 1,045 747 1,248 7,374 1,143 3,895 2466 7,374 14,500 51% Waterworks Debt Reserve 629 637 455 775 1,279 695 2367 1,499 7,705 8,500 91% Sub Total 649 968,839 1,479,202 1,183,962 1,068,758 1,276,167 1,860,194 1,298,741 9,135,863 18,815,772 49% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 21,449 57,144 43,434 46,092 55,529 30,576 20,211 274,435 545,703 50% 0621 Sewer Repair 641 446,632 360,251 404,056 284,993 308,945 341,348 427,059 2,573,284 7,201,049 36% 0625 Concrete Crew 641 44,148 29,608 25,634 23,472 31,229 31,724 33,245 219,061 450,450 49% 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 17,278,388 31,017,413 56% 0631 Organic Resources 641 69,307 56,543 60,055 54,333 85,097 80,559 53,251 459,145 1,527,562 30% 0650 Clay Sewage 641 28 103 106 113 5 257 601 500 120% Sewage Ca ital 642 39,115 47,104 402228 2254 281,988 588,063 217,648 1,578,401 7,071,710 22% Sewage Reserve 643 1,045 747 1,248 2,104 1,143 3,895 2466 12,649 15,000 84% Sewer Bond 2007 647 0 0 NA Sewage Bond Sinking 649 1,000 850 301,269 1,288,842 350 1,592,311 9,282,109 17% Sewage Bond 2007 651 2 2 NA 2010 CSO Net Sewer Bond 658 2 2 NA 2011 Sewer Bond 659 143,037 50Z 799 246,856 184,257 8,408 1,085,357 3,711,838 29% 2012 Sewer Bond 661 39,170 249,076 234,187 81,154 302,659 245,591 201,706 1,353,542 16,624,275 8% 2013 Sewer Bond 663 NA Sub Total 2,809,188 3,414,232 3,221,297 2,455,529 7,158,873 4,397,844 2,970,215 26,427,179 77,447,609 34% Financial Report July 2015 - Expenditure Summary Page 14 of 25 City of South Bend Period Ending: July 31, 2015 Expenditure Report S Fund I Jan I Feb I Mar I Apr I May Jun Jul I Au I Sep I Oct I Nov I Dec I Year I Budget of Bud et OOIim EMS Ca ital 287 35,728 35,728 750,000 Seizures 216 247,977 32,280 210,228 382,360 383,042 402,139 721,466 2,379,492 6,855,366 Hazmat 289 20,939 602 35,900 0% vViolations 218 0 2,120 21,395 854 20,421 5,081 2,412 52,283 120,800 Sub Total 460,670 268,916 70,730 231,622 383,215 403,463 407,220 723,879 1,000 0% nforcement Education 220 15,730 29,274 27,290 24,802 29,310 45,024 41,268 212,698 362,478 59% !ency Telephone System 244 20 1 21 1,560,033 5,899,970 Administration 212 367,875 365,625 NA SafetyLOIT 249 732,055 515,347 549,323 505,155 516,948 559,128 718,301 4,096,257 7,246,551 57% E Welfare Public Safety 252 88,181 16,514 647,998 Sub Total 369,417 329,268 372,756 1,146 0% Take Home Vehicle 278 3,538,038 13,534,110 335,865 138,115 116,706 281,960 1,086 1,086 71,100 2% Grants 292 1,268 15,297 11,946 11,079 1,740 13,568 15,297 105,145 15% Academy 294 2,725 9,673 242 11,678 476 678 284 25,755 23,750 108% More Grants 295 20,490 784 4,485 1,262 479 2,403 387 30,290 172,335 18% enforcement 299 18,385 6,474 18,397 6,844 6,225 56,869 9,704 122,898 248,960 49% tit 705 2,899,524 2,754,112 970 888,116 2,204,138 1,208,912 4,441,346 970 2,000 49% Dtal 789,405 576,850 600,685 549,741 553,438 664,102 771,031 4,505,252 8,270,365 54% sfe - Fire EMS Ca ital 287 35,728 35,728 750,000 EMSO eratin Fund 288 247,977 32,280 210,228 382,360 383,042 402,139 721,466 2,379,492 6,855,366 Hazmat 289 20,939 602 21,542 31,530 River Rescue 291 0 2,120 21,395 854 20,421 5,081 2,412 52,283 120,800 Sub Total 460,670 268,916 70,730 231,622 383,215 403,463 407,220 723,879 2,489,044 7,757,696 ent of Community Investment StudebakeL10iver 209 16,261 3,375 6,335 10,054 14,798 24,190 11,161 58,751 630,000 State Grant 210 12,200 24,311 18,003 24,096 400,000 19,293 11,175 460,670 3,694,412 DCI Operating 211 250,396 178,976 186,881 187,235 182,680 193,891 262,010 1,442,069 2,661,730 Dept, of Community Investment 212 102,720 134,503 161,537 515,770 284,129 140,658 220,716 1,560,033 5,899,970 Administration 212 367,875 365,625 101% EDIT 408 577,062 1,795,231 126,960 15,900 Programs 212 4,101 12,414 64,293 36,871 104,364 114,904 88,181 16,514 647,998 Sub Total 369,417 329,268 372,756 713,059 881,606 378,031 493,901 3,538,038 13,534,110 Garages Main Street 601 16,261 29,534 14,520 689 11,980 25,848 11,161 109,992 262,391 Leighton Plaza 601 16,812 24,311 21,634 24,096 24,047 49,754 21,670 182,323 696,570 Enforcement 601 1,340 31,872 16,253 335 8,521 13,915 8,272 80,508 89,236 Wayne Street 601 54,617 27,884 11,887 11,750 59,817 25,387 47,078 238,419 742,615 Eddy Street Commons 601 367,875 365,625 101% EDIT 408 577,062 1,795,231 126,960 15,900 Sub Total 88,516 89,030 113,600 64,293 36,871 104,364 114,904 88,181 611,243 1,806,712 Cs I I /Debt Service Hall of Fame 313 636,000 636,000 1,272,000 1,266,820 100% COIT 404 1,322,195 797,317 799,782 433,747 914,359 777,528 833,731 5,878,659 15,660,371 38% Cum Capital Development 406 112,650 56,546 135,726 56,546 112,650 474,118 542,691 87% Cum Ca ita /Improvement 407 183,750 184,125 367,875 365,625 101% EDIT 408 577,062 1,795,231 126,960 154,855 1,034,072 88,516 2,289,212 6,065,908 9,943,709 61% 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 1,446,751 3,096,061 47% Morris PAC Improvement 416 1,268 1,665 11,946 11,079 1,740 13,568 41,266 70,248 59% CRED 434 3,897 3,897 7,794 650,000 1% Palais Historic Preservation 450 16,150 0% Hall of Fame Ca ital 677 6,843 6,370 5,998 4,253 3,276 2,621 3,444 32,805 188,824 17% Sub Total 2,899,524 2,754,112 1,337,096 888,116 2,204,138 1,208,912 4,441,346 15,733,243 32,238,702 49% Financial Report July 2015 - Expenditure Summary Page 15 of 25 City of South Bend Period Ending: July 31, 2015 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I Budget of Bud et Other Miscellaneous Self Funded Liability Ins Gift Donation _Bequest 217 26,675 27,830 136 24,917 28,211 27,374 141,009 81,093 297,182 27% Loss Recovery 227 181,590 298,680 822,026 396,131 555,991 84,437 72,730 2,411,584 5,237,243 46% Human Ri hts 258 22,061 9,167 26,033 11,344 12,797 29,781 20,854 132,038 247,357 53% Morris Palais Marketin 273 67,459 96 229,535 2,358 989,000 878 730 3,332 18,974 18% ProfessionalSports Development 377 480,773 800 2,024,158 3,056,791 Sub Total 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 896,273 2,414,485 37% 1207 Animal Control 600 57,484 47,550 49,635 42,055 56,024 53,681 65,856 372,285 696,216 53% 1306 Building Operations 600 104,444 75,646 91,217 76,910 80,817 79,524 112,900 621,458 1,094,700 57% Century Center 670 306,497 285,449 289,304 326,417 340,496 362,358 401,596 2,312,117 4,532,562 51% Century Center Capital 671 1,464,000 66,156 50,000 130,440 87,735 334,331 605,656 55% Sub Total 1,273,296 913,225 1,372,972 1,064,090 1,226,335 847,207 1,322,987 8,020,113 15,999,978 50% s Insurance Self Funded Liability Ins 226 26,134 26,675 14,630 19,531 15,003 11,661 27,374 141,009 282,900 Liability Insurance 226 156,054 7,585 32,230 286,937 18,509 39,921 60,211 601,447 1,184,891 Business Insurance 226 15,927 14,875 21,403 1,739 75,766 421,849 1,255,361 551,560 600,000 Workers Compensation 226 64,123 206,418 63,790 43,608 67,459 55,210 229,535 730,143 989,000 Sub Total 730 262,238 255,553 132,053 351,815 176,737 528,641 317,120 2,024,158 3,056,791 Trust & A enc Fire Pension 701 441,192 441,276 450,317 433,126 43Z 764 433,366 427,928 3,059,969 5,666,579 Police Pension 702 537,112 524,012 559,034 535,159 523,172 526,174 518,215 3,722,879 6,832,235 Employee Benefits 711 1,030,771 963 626 1,093,990 1 462 313 1,140,933 973 880 1,255,361 7,920,873 16, 696,935 Unemployment Comp 713 10,126 5,167 9,025 7,309 10,788 5,683 8,171 56,270 226,796 Cit Cemetery Trust 730 74,668 154,716 48% TIF Medical Service 426 2,294,533 20,000 Sub Total 2,019,201 1,934,080 2,112,366 2,437,907 2,107,658 1,939,103 2,209,676 14,759,991 29,442,545 Civil City Expenditure 21,003,306 18,697,459 17,690,217 16,653,639 22,462,321 19,455,397 23,490,956 - - - - - 139,453,295 302,951,079 46% Tax Increment Financing TIFAir ort 324 2,276,439 1,684,991 1,736,337 586,596 271,305 1,028,591 3,609,185 11,193,443 47,710,597 23% 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 30,294 760,900 4% TIF Leighton Plaza 425 6,962 9,662 17,748 11,509 6,950 17,590 4,246 74,668 154,716 48% TIF Medical Service 426 2,294,533 2,294,533 2,294,533 100% TIF Northeast 429 112,956 5,000 16,291 4,700 6,600 3,438 148,985 7,239,524 2% TIF Southside 430 435,370 24,431 62,420 38,892 10,969 36,484 8,551 617,117 2,842,535 22% TIF Erskine Village 432 357,545 201,724 130,835 690,104 691,380 100% TIF Douglas Road 435 169,620 169,620 345,389 49% Northeast Residential TIF 436 1,464,000 246,589 1,000 1,467,450 3,179,039 3,425,632 93% Sub Total 5,617,288 1,400,070 8,200,393 660,631 294,924 1,089,265 5,223,705 22,486,276 69,553,679 32% Financial Report July 2015 - Expenditure Summary Page 16 of 25 City of South Bend Period Ending: July 31, 2015 Expenditure Report S i Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Au I Sep 1 Oct 1 Nov I Dec I Year I Budget of laud et �elo ment Funds Adminlstratlon 433 6,000 Certified Technology Park 439 198 405,121 96,682 292,821 492,595 1,287,418 5,000,000 Blackthorn Golf Operations 619 69,055 89,358 22,845 227 19,744 201,228 201,649 Sub Total 69,055 89,358 23,043 405,121 96,909 312,565 492,595 1,488,646 5,207,649 Cervlce Airport Debt Reserve 2003 315 317 227 368 594 323 1,100 697 3,626 5,000 Central Development reserve 328 530 379 615 993 539 1,838 1,164 6,058 6,000 Sub Total M 847 606 983 1,587 862 2,938 1,860 9,683 11,000 Financial Report July 2015 - Expenditure Summary Page 17 of 25 Redevelopment Commission 5,687,190 1,490,033 8,224,418 1,067,340 392,695 1,404,768 5,718,161 - - - - - 23,984,605 74,772,328 32% City Operations Total 26,690,496 20,187,492 25,914,635 17,720,979 22,855,017 20,860,165 29,209,116 - - - - - 163,437,900 377,718,721 43% Expenditure report 26,690,496 20,187,492 25,914,635 17,720,979 22,855,017 20,860,165 29,209,116 0 0 0 0 0 163,437,900 377,718,721 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report July 2015 - Expenditure Summary Page 17 of 25 City of South Bend Period Ending: July 31, 2015 Debt Schedule Year of Yearof Yearof Schetluktl Payments Debt (OdylRe1)i Debtaf 2015Principal 20151nterest 2015 Debt at 2015 Total Debt lnsWment Debt PU Issue Refunding Matu Fund 1st 2ntl 3b 4th Issue 12/31/2014 Pa ants Pa ent AtlOW15- 121312015 Debt Payments CN#C#y Debt Bond Debt A_-k 3f CEDIT Bond 1997 2006 2017 408 2/1 8/1 - - 11.870.000.00 2.055.000.00 790.000.00 86.100.00 0.00 1.265.000.00 876.100.00 36 South Bend Build Coroordlon Public Works Buildlno 2001 2010 2021 4041649 2/1 8/1 - - 9.250.000.00 3.860.000.00 545.000.00 129.726.00 0.00 3.315.000.00 674.726.00 25 Water Works l mwovements Water Works 2002 2012 2023 625 111 7/1 - - 5.975.000.00 3.100.000.00 355.000.00 62.000.00 0.00 2.745.000.00 417.000.00 ,South Bend Buildinq Corporation Fire HQ/ Police HQ 2003 2012 2023 4041324 21 8/1 - - 21.335.000.00 11.245.000.00 1.160.000.00 403.635.00 0.00 10.085.000.00 1.563.635.00 24 Water Works Improvements Water Works 2006 2027 625 111 7/1 - - 4.710.000.00 3.300.000.00 210.000.00 146.726.00 0.00 3.090.000.00 356.726.00 42 Sewsoe Works Improvements Sewage Works 2006 2026 649 6/1 12/1 - - 7.630.000.00 5.740.000.00 365.000.00 255.491.26 0.00 5.375.000.00 620.491.26 40 Sewage Works Improvements Sewage Works 2007 2027 649 6/1 12/1 - - 16.600.000.00 12.320.000.00 720.000.00 535.947.50 0.00 11.600.000.00 1.255.947.50 52 Sewage Works Revenue Bonds 2007B Sewage Works 2007 2027 649 6/1 12/1 - - 16.515.000.00 12.280.000.00 710.000.00 524.341.26 0.00 11.570.000.00 1.234.341.26 s2 Century Center Special Tax Bonds Cent- Center 2008 2028 420 5/1 11/1 - - 4.655.000.00 3.750.000.00 285.000.00 107.687.50 0.00 3.465.000.00 392.687.50 s9 Water Works Improvements Water Works 2009 2030 625 111 7/1 - - 5.380.000.00 4.775.000.00 220.000.00 261.098.00 0.00 4.555.000.00 481.098.00 70 Sewage Works Revenue Bonds - 2009 Sewage Works 2009 2028 649 6/1 12/1 - - 3.297.000.00 2.561.387.00 153.712.00 71.974.00 0.00 2.407.675.00 225.686.00 so 2010 S- Works Revenue Bonds Sewage Works 2010 2030 649 6/1 12/1 - - 9.345.000.00 7.905.000.00 375.000.00 325.267.50 0.00 7.530.000.00 700.267.50 9a Sewage Works Revenue Bonds 2011 Sewage Works 2011 2031 649 6/1 12/1 - - 21.500.000.00 19.040.000.00 865.000.00 706.650.00 0.00 18.175.000.00 1.571.650.00 992012Water Works Revenue Bond Water Works 2012 2033 625 111 7/1 - - 8.300.000.00 7.620.000.00 345.000.00 223.686.26 0.00 7.275.000.00 568.686.26 fof 2012 Seaace Works Revenue Bonds Sewage Works 2012 2032 649 6/1 12/1 - - 25.000.000.00 22.965.000.00 1.030.000.00 528.180.00 0.00 21.935.000.00 1.558.180.00 1. 20, 3A Sewer Bond Refunding Sewage Works 2013 2013 2024 649 6/1 12/1 - - 14.765.000.00 11.855.000.00 1.885.000.00 229.987.00 0.00 9.970.000.00 2.114.987.00 16 2013 Buildino Corooration EMS / Fire Depadment 2013 2033 288 2/1 8/1 - - 5.580.000.00 5.580.000.00 215.000.00 190.680.00 0.00 5.365.000.00 405.680.00 f?? St. Joseoh County PSAP St. Joseoh County PSAP 2014 2034 408 Mon1hN 2.657.696.50 2.657.696.50 123.377.50 75.951.55 0.00 2.534.319.00 199.329.05 - Century Center En- Savinos I- ements at Century Ctr, 2015 2031 672 5/1 11/1 4.167.897.00 0.00 0.00 0.00 4.167.897.00 4.167.897.00 0.00 fof Parks and Reocreabon Bond Parks Improvements 2015 2035 408 2/1 8/1 - - 5.605.000.00 0.00 0.00 0.00 5.605.000.00 5.605.000.00 0.00 Tokl Bond Debt IN 204.137.593.50 142.609.083.50 10.352.089.50 4.865.128.83 9.772.897.00 142.029.891.00 15.217.218.33 Loans Payabk ss Sods Revolving Fund Water Works Improvement 2009 2030 625 1/1 7/1 - - 427.332.00 372.364.00 19.571.00 12.548.66 0.00 352.793.00 32.119.66 az Interfund Lean 410 - UDAG 1 st S- ace/Manoft G.- 2010 2015 410 6/15 12/15 - - 2.700.000.00 2.027.973.00 438.202.50 0.00 0.00 1.589.770.50 438.202.50 44 State Re..Mac Fund (Refundina) Sewage Works Improvement 1998 2018 649 6/1 12/1 - - 24.095.000.00 0.00 0.00 0.00 0.00 0.00 0.00 zs State Revolving Fund Water Works Imorrovemerts 2000 2019 625 1/1 7/1 - - 2.600.000.00 860.913.00 162.482.00 24.966.00 0.00 698.431.00 187.448.00 Total Loans Pa abk J 29.822.332.00 3.261.250.00 620.255.50 37.514.66 0.00 2.640.994.60 657.770.16 Capital Leases sf Chase LED Equipment 2007 2017 101 111 711 1.531.573.00 559.122.04 178.539.39 22.040.27 0.00 380.582.065 200.579.66 ]z Kansas State Bank Code Enfwcement Oce Copier 2010 2015 101 1/23 4/23 7/23 10123 9.209.00 539.14 539.14 10.50 0.00 0.00 649.64 7s Kansas State Bank Centret Services Gooier 2010 2015 222 2116 5/16 8/16 11/16 13.366.40 1.496.90 1.496.90 33.10 0.00 0.00 1.530.00 n GE Capital Information Technolonv Animal Control Copier 2010 2015 101 2128 5/30 8/30 11/30 3.550.69 403.62 403.62 4.04 0.00 0.00 407.66 ]a Kansas Stale Bank Mavw Oce Copier 2010 2015 101 1/8 4/8 7/8 10/8 9.209.00 1.586.72 1.586.72 62.20 0.00 0.00 1.648.92 7a Advanced Imaging Central Services Duplicators 2010 2015 222 1/15 4/15 7/15 10/15 10.511.02 2.455.77 2.455.77 139.59 0.00 0.00 2.595.36 s7 Public Finance.com Inc Solid Waste Conteiners/trocks 2011 2015 611 6/15 12/15 321.853.00 67.665.30 67.665.30 1.599.70 0.00 0.00 69.265.00 as Sun Trust Police. Parks. Bldg vehicles 2011 2016 404/201/600 3/15 6/15 9/15 12/15 2.068.202.00 641.545.46 425.630.31 9.335.10 0.00 215.915.15 434.965.41 ao Capital One Public Fundinq So lid Waste ConteinersiTrocks 2011 2016 611 3/15 6/15 9/15 12/15 207.432.00 74.504.09 42.308.31 977.25 0.00 32.195.78 43.285.56 of GE Capital Information Tschnolaov Police Debt Copier 2011 2016 101 1/11 4/11 7/11 10111 3.836.00 1.275.18 837.22 51.50 0.00 437.96 888.72 az Kev Finance IT Phone Svstem 2011 2016 404 1/15 1.444.995.97 569.323.31 281.141.18 14.258.23 0.00 288.182.13 295.399.41 &4 Ikon Office Solutions Mavw Ricoh MP 2851 SP Coble, 2011 2016 101 2115 5/15 8/15 11/15 2.569.53 1.110.31 539.50 48.98 0.00 570.81 588.48 s5 Sun Trost Enuiomsat Finance Parks -Goff Cars Lease 2012 2016 201 4/15 10115 - - 344.500.00 131.862.30 87.556.51 1.765.97 0.00 44.305.79 89.322.48 w Sun Trost Eauibmon[Finance Police Vehicles B Eauibmont 2012 2 1 406 5/15 11/15 - - 1.295.000.00 661.712.34 261.339.69 10.111.59 0.00 400.3]2.65 271.451.28 &a PNC Eauiomeat Finance Public Works Vehicles Lease 2012 2 1 20216411640 5/15 11/15 - - 945.674.38 481.717.95 190.523.14 6.535.71 0.00 291.194.81 197.058.85 oo PNC Eauiomeat Finance Public Works Vehicles Lease 2012 2017 202641/600/288 1/15 7/15 - - 2.806.054.00 1.703.748.90 560.548.08 20.403.26 0.00 1.143.200.82 580.951.34 oz Ikon Office SdWions /Ricoh Wastewater Cooler 2012 201] 641 MonthN 1st 5.744.95 3.170.10 1.172.61 149.31 0.00 1.997.49 1.321.92 oa GE Capital information Technolwv Fire Department Gooier 2012 2 1 101 2126 5/26 8128 11128 5.471.01 3.205.85 1.106.31 164.49 0.00 2.099.54 1.270.80 oa Ricoh USA (New) Central Services Gooier 2013 2018 222 2127 5/27 8/27 1127 3.622.78 2.315.31 728.85 110.91 0.00 1.586.46 839.76 a] Ricoh USA StreetlSewer Den Copier 2013 2018 202641 3/4 06/4 9/4 12/4 5.559.15 3.475.34 1.092.25 178.55 0.00 2.383.09 1.270.80 as Ricoh USA Citv Agar- 2013 2018 101 2112 5/12 8/12 11/12 5.559.15 3.492.63 1.097.31 173.49 0.00 2.395.32 1.270.80 o& Ricoh USA Parks & Rec Ricoh Caoiers(3) 2013 2018 201 2121 5121 8121 1121 16.129.94 10.132.91 3.184.26 502.98 0.00 6.948.65 3.687.24 f. PNC Eau Pawl Finance Vehide/Eauioment Lease 2013 2018 101/202406/641 1/15 7/15 1.689.669.59 1.361.951.27 334.301.24 15.599.28 0.00 1.027.650.03 349.900.52 1f Ricoh USA Encineedna Plotter /Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10.0667.67 6.790.21 2.073.34 518.66 0.00 4.716.87 2.592.00 12 Ricoh USA Buildinq Den. Calmer 2013 2018 600 MonthN 4.093.64 3.109.92 786.76 152.24 0.00 2.323.16 939.00 fa Sun Trust Enuiomeat Finance Police and PW vehicles 2013 2018 404/655/611/202 4/24 10/24 1.506.465.26 1.214.609.68 296.499.82 18.081.32 0.00 918.109.86 314.581.14 f4 Ricoh USA Adman B Finance Coder 2013 2018 101 1/16 4/16 7/16 10/16 11.247.97 7.565.05 2.178.10 393.14 0.00 5.386.95 2.571.24 n Police Den. Record Div. Ricoh Police Records Cooaw 2013 2018 101 MonthN 3rd 9.678.26 7.950.10 1.826.18 393.82 0.00 6.123.92 2.220.00 fa Water Works Main Racbh Cooaw Water Works Main Racbh Cooaw 2013 2018 620 MonthN 10th 5.647.50 4.639.36 1.065.38 230.08 0.00 3.573.98 1.295.46 fa Water Works Colfax Ricoh Coder Water Works Colfax Ricoh Cade 2013 2018 620 MonthN 16th 4.732.65 3.887.84 892.77 192.75 0.00 2.995.07 1.085.52 zp Water Works Olive Racah Cooaw Water Works Olive Racah Cooaw 2013 2018 620 MonthN 10th 4.732.65 3.887.84 892.77 192.75 0.00 2.995.07 1.085.52 za Police Treinina Debt. Ricoh Cagier Tminina Caller 2014 2019 101 MonthN 30th 4.263.00 3.714.38 796.08 187.92 0.00 2.918.30 984.00 z4 Police/Public Works Vehicle Lease 2014 CiN Vehicles 2014 2019 Various 4/1 10/1 1.959.485.95 1.959.485.95 379.888.68 28.907.87 0.00 1.579.597.27 408.796.55 125 HP Combaer Lease #1 Combutw Eauibmsat Lease 2014 2018 MonlhN 8th 137.104.95 124.554.02 29.828.93 4.995.44 0.00 94.725.09 34.824.37 1z6 HP Combaer Lease #2 Computer Eauibmont Lease 2014 2018 201 and 620 MonlhN 8th 4.000.00 3.720.95 866.48 154.00 0.00 2.854.47 1.020.48 z] HPCombner Leass#4 Computer Eauibment Lease 2014 2018 404 MonlhN 8th 5.886.15 5.461.99 1.307.57 188.47 0.00 4.154.42 1.496.04 tea HPCombuter Leass#6 Computer Eauibmsat Lease 2014 2018 201 MonlhN 8th 3.755.50 3.561.10 801.62 155.50 0.00 2.759.48 957.12 ze HP Combater Lease #7 Computo, Eauibment Lease 2014 2018 620 MonlhN 8th 1.326.00 1.302.13 294.22 42.62 0.00 1.007.91 336.84 130 Solid Waste Caner Ricoh USA Coder 2014 2019 611 MonlhN 17th 5.351.65 5.351.65 1.035.84 296.27 0.00 4.315.81 1.332.11 131 Police Communicetaons Career Ricoh USA Coder 2014 2019 101 MonlhN 12th 8.843.00 8.196.86 1.613.55 418.29 0.00 6.583.31 2.031.84 13z Organic Resources B Wastewater Ricoh USA Callers 2014 2019 641 MonlhN 21st 12.260.18 11.182.59 2.247.61 569.39 0.00 8.934.98 2.817.00 1a4 Water Works Career - Nwfh Station Ricoh USA Callers 2014 2019 620 MonlhN 19th 4.732.65 3.960.04 888.67 196.84 0.00 3.071.37 1.085.51 1a6 HP Combater Lease #B Combutw Eauabmeat Lease 2015 2019 404/201/611 MonlhN 16th 19.603.94 0.00 3.434.11 759.69 19.603.94 16.169.83 4.193.80 13] Animal Control Ricoh Caner Ricoh USA Coners 2015 2020 600 MonlhN 30th 5.261.50 0.00 694.75 217.13 5.261.50 4.566.75 911.88 138 HP Combater Lease #9 Computer Eauabment Lease 2015 2019 Vadous MonlhN TBD 135.958.05 0.00 14.229.04 3.223.14 135.958.05 121.729.01 17.452.18 too Vehicle &Eauab. Lease VehidcIEr.ibment Lease 2015 2020 Vadous 1/15 7/15 3.425.273.58 0.00 0.00 0.00 3.425.273.58 3.425.273.58 0.00 Total Capital Lease 20,039,664.26 9,670,744.40 1 3,189,935.88 164,723.33 3,586,097.07 10,066,905.59 1 3,354,659.21 foal uvn uq I as.sas.gas.fo iaage i.uf f.su fa. io <eau.aa auof.soo.a4 1s.saa.ssa.uf - iaa.lsf.ls i.us _is.e4s.oaf.fu FlnanGpl Report July 2015 -.. City of South Bend Period Ending: July 31, 2015 Debt Schedule Year of Yearof Yearof Schetluletl Payments Debf lOng/Renr Debtaf 2015Principal 20151nterest 2015 Debt at 2015 Total Debt lnsWment Debt PU Issue Refundin Matu Fund 1st 2ntl 3n1 4th Issue 12/31/2014 Pa Boas Pa wit Atltlifion 121312015 Debt Pa yments Retlevelopment Commission Dabf Bontl Debf 7 Century Center Lease Rental Revenue Century Center 1994 2001/2011 2018 407 2/1 8/1 - - 6.825.000.00 1.630.000.00 450.000.00 37.500.00 0.00 1,180,000.00 487,500.00 8 College Football Hall of Fame Hall of Fame 1994 2000/2011 2018 313 2/1 8/1 - - 15.370.000.00 4.160.000.00 1.150.000.00 116.820.00 0.00 3,010,000.00 1,266,820.00 11 Soulh Bend Building Corporation Mom PAC 1998 2009 2017 408 2/1 8/1 - - 13.300.000.00 2.460.000.00 950.000.00 87.212.50 0.00 1,510,000.00 1,037,212.50 12 TJX Special Taxinq Dist ct 2002 2014 2022 324/404/414 1/1 7/1 - - 6.620.000.00 3.010.000.00 395.000.00 86,350.00 0.00 2,615,000.00 481,350.00 5 Dovmtonn Centel Area TI F 2003 2011 2024 420 2/1 8/1 - - 19.795.000.00 14.965.000.00 1.205.000.00 709.525.00 0.00 13,760.000.00 1,914,525.00 6 Airoad Development Area TI F Airport TIF 2003 2011 2024 324 2/1 8/1 - - 14.420.000.00 8.535.000.00 690.000.00 404.611.50 0.00 7,845,000.00 1,094,611.50 22 Erskine Village TIF Development Bond Erskine Village 2005 2027 432 2/1 8/1 - - 5.485.000.00 4255.000.00 220.000.00 268.380.00 0.00 4,035,000.00 488,380.00 54 Lease Rental Revenue Bwdsof2008 Eddy Street Commons 2008 2027 429 2/15 8/15 - - 36.000.000.00 33.020.000.00 1.075.000.00 1,853.268.00 0.00 31,945.000.00 2,928,268.00 81 Coveleski Stadium Recovery Coveleski Stadium 2010 2019 377 1/15 7/15 - - 4.980.000.00 2,915.000.00 620.000.00 134.802.50 0.00 2.295,000.00 754,802.50 104 2012 Gates Dovmtown Campus VA Clinic Agmt Loan 2012 2015 420 3/1 8/1 1.700.000.00 566.666.68 568.666.68 0.00 0.00 0.00 566,666.68 121 Blackthorn Golf Carl Lease Blackthorn Golf 2014 2019 619 Monthlv 14th 293.788.00 257.238.04 257.238.04 4.688.91 0.00 0.00 261,926.95 122 Synagogue at Coveleski Improvements Coveleski Stadium 2014 2018 377 1/31 500.000.00 400.000.00 100.000.00 0.00 0.00 300.000.00 100.000.00 135 2015 Redevolament Smart Streets Smarts Streets 2015 2037 324 2/1 8/1 25.000.000.00 0.00 0.00 0.00 25.000.000.00 25.000.000.00 0.00 Totaleontl Debt 153.788.788.00 76.173.904.72 7.678.904.72 3.703.158.41 25.000.000.00 93.495.000.00 11,382.063.13 Loans Payable 3 Intliana Development Finance AUthaiN Bosch PropeM (NOMagivel 2001 2021 210 3/22 6/22 9/22 12/22 1,040,000.00 423,820.93 59,968.23 12,044.21 0.00 383.854.70 72,010.44 4 Intliana Development Finance Authority Bosch Prodedy (Fomive) 2001 2021 210 - - 260,000.00 117,130.26 0.00 0.00 0.00 100.557.56 0.00 60 HUD Section 108 #8 Studebaker Oliver 2008 2025 434 2/1 8/1 - - 4.000.000.00 180.000.00 180.000.00 7.794.00 0.00 0.00 187,794.00 63 City of Mishawaka Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1,102.549.56 47.003.09 47.003.09 1.175.08 0.00 0.00 48,178.17 64 Intertund Fund 412 -Maio, Moves Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1.040,319.00 888,877.00 251,157.00 41,852.00 0.00 635.520.00 293.009.00 83 in terfund Fund 619 - Blackthom Blackthorn Equip (golf carts) 2010 2017 619 5/15 6/15 7/15 8/15 31.032.00 0.00 0.00 0.00 0.00 0.00 0.00 84 Intedund Fund 412 -Major Moves Triangle Development 2011 2029 436 2/15 8/15 - - 2.000.000.00 1.513.259 50 90.929.20 29.812.80 0.00 1,422.330.30 120.742.00 85 Into Id FUntl 412 -Major Moves Eddy Street Commons 2011 2028 436 2/15 8/15 - - 4,100,000.00 3227,558.81 213,888.28 158,739.71 0.00 3,013,882.52 372,438.00 86 Interfund Funtl 209 to Aimort 324 Pmide Ave Broomfield Prgect 2011 2020 324 8/9 - - - 500.000.00 500.000.00 0.00 0.00 0.00 500.000.00 0.00 88 Blackthorn Loan from Aimort Blackthorn Equip (mowers) 2011 2018 619 5/15 6/15 7/15 8/15 53.598.50 0.00 0.00 0.00 0.00 0.00 0.00 Total Loans Payable 14.127.499.06 6.895.449.59 842.751.81 251.417.80 0.00 6,036.125.08 1,094.169.61 CapOal Lease Total Ca bal Lease 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Leases 37 Tmnsoo Lease Leiqhton Plaza Game 2001 2015 404 6/30 12/30 - - 3.000.000.00 191.347.00 191,347.00 8.653.00 0.00 0.00 200,000.00 13 Transoo Lease Main /Colas Game 2006 2025 404 3/15 9/15 - - 2.510278.00 1.676.543.00 117.825.00 82.375.00 0.00 1,558,918.00 200,000.00 Total Lease 5.510278.00 1.867.890.00 308.972.00 91.028.00 0.00 1,558.918.00 1 400,000.00 Tofal Retlevelopment Commission 173.426.565.06 84.937.244.31 1 8.830.628.53 I 4.045.604.21 25.000.000.00 101.090.043.08 12,876,232.74 FlnanGal Report Juty 2015 -peDf City of South Bend Period Ending: July 31, 2015 Monthly Debt Schedule Yearof I Yearof Yearof Sch;ndd~1 Payments Debt lOrg /Rani Debtaf YTD Pmclpal YTD Interest YTD Debtat Debt lnsWment Debt PU Issue Refunding Matu Fund 1st 2ntl 3n1 4th Issue 1231/2014 Pa ants Pa ants AtltliOOns 1 713112015 CN#C#y Debt Bond Debt A_-k 3f CEDIT Bond 1997 2006 2017 408 2/1 8/1 - - 11.870.000.00 2.055.000.00 200.000.00 21.200.00 0.00 1.855.000.00 36 South Bend Build Corporation Public Works Buildlno 2001 2010 2021 4041649 2/1 8/1 - - 9.250.000.00 3.860.000.00 270.000.00 66.888.00 0.00 3.590.000.00 25 Water Works l mbrovements Water Works 2002 2012 2023 625 7/1 12/31 - - 5.975.000.00 3.100.000.00 0.00 31.000.00 0.00 3.100.000.00 ,South Bend Buildinq Corporation Fire HQ/ Police HQ 2003 2012 2023 4041324 2/1 8/1 - - 21.335.000.00 11.245.000.00 575.000.00 206.130.00 0.00 10.670.000.00 24 Water Work s Improvements Water Works 2006 2027 625 7/1 12/31 - - 4.710.000.00 3.300.000.00 0.00 73.363.00 0.00 3.300.000.00 42 Sewsoe Works Improvements Sewage Works 2006 2026 649 6/1 12/1 - - 7.630.000.00 5.740.000.00 0.00 127.745.63 0.00 5.740.000.00 40 Sewage Works Improvements Sewage Works 2007 2027 649 6/1 12/1 - - 16.600.000.00 12.320.000.00 0.00 267.973.75 0.00 12.320.000.00 52 Sewage Works Revenue Bonds 20078 Sewage Works 2007 2027 649 6/1 12/1 - - 16.515.000.00 12.280.000.00 0.00 262.170.63 0.00 12.280.000.00 a2 Century Center Special Tax Bonds Century Center 2008 2028 420 5/1 11/1 - - 4.655.000.00 3.750.000.00 285.000.00 55.981.25 0.00 3.465.000.00 a9 Water Works Improvements proveents Water Works 2009 2030 625 7/1 12/31 - - 5.380.000.00 4.775.000.00 0.00 130.549.00 0.00 4.775.000.00 70 Sewage Works Revenue Bonds - 2009 Sewage Works 2009 2028 649 6/1 12/1 - - 3.297.000.00 2.561.387.00 0.00 35.987.00 0.00 2.561.387.00 so 2010 Sewage Works Revenue Bonds Sewage Works 2010 2030 649 6/1 12/1 - - 9.345.000.00 7.905.000.00 0.00 162.633.75 0.00 7.905.000.00 9a Sewage Works Revenue Bonds 2011 Sewage Works 2011 2031 649 6/1 12/1 - - 21.500.000.00 19.040.000.00 0.00 353.325.00 0.00 19.040.000.00 992012Water Works Revenue Bond Water Works 2012 2033 625 1/1 7/1 - - 8.300.000.00 7.620.000.00 345.000.00 227.086.26 0.00 7.275.000.00 101 2012 Seaaoe Works Revenue Bonds Sewage Works 2012 2032 649 6/1 12/1 - - 25.000.000.00 22.965.000.00 0.00 264.090.00 0.00 22.965.000.00 1. 20, 3A Sewer Bond Refunding Sewage Works 2013 2013 2024 649 6/1 12/1 - - 14.765.000.00 11.855.000.00 0.00 114.993.50 0.00 11.855.000.00 fa 2013 BOldino Comoration EMS / Fire Depadment 2013 2033 288 2/1 8/1 - - 5.580.000.00 5.580.000.00 215.000.00 96.952.50 0.00 5.365.000.00 f33 St. Joseph County PSAP St. Joseph County PSAP 2014 2034 408 Monthlv - - - 2.657.696.50 2.657.696.50 71.970.22 44.305.10 0.00 2.585.726.28 f39 Century Center En- Savings Improvements Century Ctr. 2015 2031 672 5/1 11/1 - - 4.167.897.00 0.00 0.00 0.00 4.167.897.00 4.167.897.00 141 Parks and Rec Bond Parks Improvements 2015 2035 408 2/1 8/1 - - 5.605.000.00 0.00 0.00 0.00 5.605.000.00 5.605.000.00 Total Bond Debt 204.137.593.50 142.609.083.50 1.961.970.22 2.542.374.37 9.772.897.00 150.420.010.28 Loans Payabk sa State Revolving Fund Water Works Improvement 2009 2030 625 7/1 12/31 - - 427.332.00 372.364.00 0.00 6.274.33 0.00 372.364.00 az Interfund Lean 410 - UDAG 1 st S- ace/Maniod Garage 2010 2015 410 6/15 12115 - - 2.700.000.00 2.027.973.00 146.067.50 0.00 0.00 1.881.905.60 44 State Revolving Fund (sch# 1051 Sewage Works Improvement 1998 2018 649 6/1 1211 - - 24.095.000.00 0.00 0.00 0.00 0.00 0.00 z5 State Revolving Fund Water Works Improvements 2000 2019 625 7/1 12/31 - - 2.600.000.00 860.913.00 0.00 12.483.00 0.00 860.913.00 Total Loans Pa abk 29.822.332.00 3.261.250.00 146.067.50 18.757.33 0.00 3.115.182.60 Capital Leases 51 Chase LED Equipment 2007 2017 101 1/1 7/1 1.531.573.00 559.122.04 178.539.39 22.040.27 0.00 380.582.65 ]z K. as. State Bank Code Enforcement Oce Copier 2010 2015 101 1/23 4/23 7/23 10123 9.209.00 539.14 539.14 10.50 0.00 0.00 ]a Kansas State Bank Central Services Gooier 2010 2015 222 2116 5/16 8/16 11116 13.366.40 1.496.90 1.496.90 33.10 0.00 0.00 n GE Capital Information Tachnologv Animal Control Copier 2010 2015 101 2128 5/30 8/30 11130 3.550.69 403.62 403.62 4.08 0.00 0.00 7a Kansas Stale Bank Mavar Ow Copier 2010 2015 101 1/8 4/8 7/8 1018 9.209.00 1.586.72 1.586.72 62.20 0.00 0.00 7a Advanced Imaaina Central Services Duplicators 2010 2015 222 1/15 4/15 7/15 10115 10.511.02 2.455.77 1.821.31 125.21 0.00 634.46 a] Public Finance. -.Inc Solid Waste Conteiners/Irocks 2011 2015 611 6/15 12/15 321.853.00 67.665.30 33.568.80 1.063.70 0.00 34.096.50 as Sun Trust Police. Parks. Bldg vehicles 2011 2016 404/201/600 3/15 6/15 9/15 12/15 2.068.202.00 641.545.46 211.788.45 5.694.25 0.00 429.757.01 ao Capital One Public Funding So lid Waste ConteinersiTrocks 2011 2016 611 3/15 6/15 9/15 12/15 207.432.00 74.504.09 21.066.29 576.49 0.00 53.437.80 at GE Capital Information Tachnol- Police Debt Copier 2011 2016 101 1/11 4/11 7/11 10/11 3.836.00 1.275.18 623.38 43.10 0.00 651.80 az Kev Finance IT Phone Svstem 2011 2016 404 1/15 1.444.995.97 569.323.31 281.141.18 14.258.23 0.00 288.182.13 &4 Ikon Office Solutions Ma for Ricoh MP 2851 SP Cable, 2011 2016 101 2115 5/15 8/15 11/15 2.569.53 1.110.31 265.95 28.29 0.00 844.36 as Sun Trust Equibment Finance Parks -Goff Cars Lease 2012 2016 201 4/15 10115 - - 344.500.00 131.862.30 43.603.35 1.057.89 0.00 88.258.95 w Sun Trust Equibment Finance Police Vehicles B Eauabment 2012 2 1 406 5/15 11/15 - - 1.295.000.00 661.712.34 130.118.56 5.607.08 0.00 531.593.78 as PNC Equipment Finance Public Works Vehicles Lease 2012 2 1 20216411640 5/15 11/15 - - 945.674.38 481.717.95 94.904.49 3.624.93 0.00 386.813.46 ao PNC Eauabmant Finance Public Works Vehicles Lease 2012 201] 202641/600/288 1/15 7/15 - - 2.806.054.00 1.703.748.90 560.548.08 20.403.26 0.00 1.143.200.82 oz Ikon Office SdWians /Ricoh Wastewater Cooler 2012 2 1 641 MonthN 1st 5.744.95 3.170.10 675.96 95.16 0.00 2.494.14 oa GE Capital Information Technolwv Fire Department Gooier 2012 201] 101 2126 5/26 8126 11128 5.471.01 3.205.85 545.08 90.32 0.00 2.660.77 oa Ricoh USA Central Services Caviar 2013 2018 222 2127 5/27 8/27 1127 3.622.78 2.315.31 368.41 51.47 0.00 1.946.90 a] Ricoh USA StreetlSewer Deal Copier 2013 2018 202641 3/4 fi/4 9/4 12/4 5.559.15 3.475.34 538.25 97.15 0.00 2.937.09 pa Ricoh USA Citv Afton- Cobiar 2013 2018 101 2112 5/12 8112 11112 5.559.15 3.492.63 554.91 80.49 0.00 2.937.72 o& Ricoh USA Parks & R- Ricoh Cabiers(3) 2013 2018 201 2121 5121 8121 1121 16.129.94 10.132.91 1.610.26 233.36 0.00 8.522.65 to PNC Eau Pawl Finance Vehicle/Eauibment Lseas 2013 2018 101/202406/641 1/15 7/15 1.689.669.59 1.361.951.27 334.301.24 15.599.28 0.00 1.027.650.03 11 Ricoh USA Encineerina Plotter /Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10.0667.67 6.790.21 1.014.60 281.40 0.00 5.7]5.61 1z Ricoh USA Buildinq Deal. Copier 2013 2018 600 MonthN - - 4.093.64 3.109.92 453.66 94.09 0.00 2.656.26 to Sun Trust Equipment Finance Police and PW vehicles 2013 2018 404/655/611/202 4/24 10/24 1.506.465.26 1.214.609.68 147.664.79 9.625.78 0.00 1.066.944.89 t4 Ricoh USA Adman B Finance Copier 2013 2018 101 1/16 4/16 7/16 10/16 11.247.97 7.565.05 1.621.72 306.71 0.00 5.943.33 n Police Deal. Record Div. Ricoh Police Records Cable, 2013 2018 101 MonthN 3rd - - 9.678.26 7.950.10 1.053.00 242.00 0.00 6.897.10 to Water Works Main Racah Cable, Water Works Main Racah Cable, 2013 2018 620 MonthN 10th - - 5.647.50 4.639.36 614.31 141.34 0.00 4.025.05 t& Water Works Colfax Ricoh Copier Water Works Colfax Ricoh Code 2013 2018 620 MonthN 16th - - 4.732.65 3.887.84 514.79 118.43 0.00 3.373.05 zp Water Works Olave Racah Cable, Water Works Olave Racah Cable, 2013 2018 620 MonthN 10th - - 4.732.65 3.887.84 514.79 118.43 0.00 3.373.05 za Police Train no Dept. Ricoh Cagier Tminina Comer 2014 2019 101 MonthN 30th - - 4.263.00 3.714.38 458.97 115.03 0.00 3.255.41 z4 Kev Goverment Finance 2014 CiN Vehioles 2014 2019 4/1 10/1 - - 1.959.485.95 1.959.485.95 189.211.09 15.187.18 0.00 1.7]0.2]4.86 125 HP Combuter Lease #1 Computer Eauion eat Lease 2014 2018 MonlhN 8th - - 137.104.95 124.554.02 17.237.17 l 77.04 0.00 107.316.85 1z6 HP Computer Laaaa #2 Compuer Eauibmant Lease 2014 2018 201 end 620 MonlhN 8th - - 4.000.00 3.720.95 500.57 94.71 0.00 3.220.38 z] HPCombuter Laaaa#4 Computer Eauibmant Lease 2014 2018 404 MonlhN 8th - - 5.886.15 5.461.99 756.59 116.10 0.00 4.705.40 128 HPCombuter Laasa#6 Computer Eauibment Lease 2014 2018 201 MonlhN 8th - - 3.755.50 3.561.10 462.88 95.44 0.00 3.098.22 za HP Computer Lease #7 Computor Eauirrawt Lease 2014 2018 620 MonlhN 8th - - 1.326.00 1.302.13 169.19 27.30 0.00 1.132.94 130 Solid Waste Career Ricoh USA Cooler 2014 2019 611 MbnlhN 17th - - 5.351.65 5.351.65 630.00 189.76 0.00 4.721.65 tat Police Communicetians Career Ricoh USA Cooler 2014 2019 101 Mbnff, 12th - - 8.843.00 8.196.86 930.26 254.98 0.00 7.266.60 13z Organic Resources B Wastewater Ricoh USA Copiers 2014 2019 641 MbnlhN 21st - - 12.260.18 11.182.59 1.295.81 347.44 0.00 9.886.78 ta4 Water Works Career -Nadh SWtaan Racho USA Copiers 2014 2019 620 Mbnff, 19th - - 4.732.65 3.960.04 512.43 120.79 0.00 3.447.61 tab HP Computer Lease #B Combater Eauaomeat Lease 2015 2019 404/201/611 MbnlhN 16th - - 19.603.94 0.00 1.699.04 397.86 19.603.94 17.904.90 13] Animal Control Ricoh Career Ricoh USA Coolers 2015 2020 600 MonlhN 30th - - 5.261.50 0.00 305.02 100.26 5.261.50 4.956.48 138 HP Combater Lease #9 Compuer Eauibmen[Lease 2015 2019 Various MonlhN TBD - - 135.958.05 0.00 0.00 0.00 135.958.05 135.958.05 too Vehime &Eauab. Lease Vehidc/Er.ioment Lease 2015 2020 Various 1/15 7/15 - - 3.425.273.58 0.00 0.00 0.00 3.425.273.58 3.425.273.58 Tote /Ca iial Lease 20.039.664.26 9.670.744.40 2.268.230.40 121.931.88 3.586.097.07 10.988.611.07 Total Ch* City 253.999.589.76 155.541.077.90 4.376268.12 2.683.063.58 13.358.994.07 1 164.523.803.85 FlnanGal Report Juty 2015 -OeDf City of South Bend Period Ending: July 31, 2015 Monthly Debt Schedule Yearof I Yearof Yearof Schetluletl Payments Debf lOrg /Rani Debtof YTD Principal YTD Interest YTD Debtat Debt lnsWment Debt PU Issue Refunding Matu Fund 1st 2ntl 3n1 4th Issue 1213112014 P.,_. Pa enfs Atltlifions 1 7/31/2015 Retlevelopment Commission Debf Bontl Debf 7 Century Center Lease Rental Revenue Century Center 1994 2001/2011 2018 407 2/1 8/1 - - 6.825.000.00 1.630.000.00 225.000.00 19.875.00 0.00 1,405,000.00 8 College Football Hall of Fame Hall of Fame 1994 2000/2011 2018 313 2/1 8/1 - - 15.370.000.00 4.160.000.00 570.000.00 61.758.75 0.00 3,590,000.00 11 Soulh Bend Building Coroomtion Mom PAC 1998 2009 2017 408 2/1 8/1 - - 13.300.000.00 2.460.000.00 470.000.00 48.012.50 0.00 1,990,000.00 12 TJX Special Tazinq Dist ct 2002 2014 2022 324/404/414 1/1 7/1 - - 6.620.000.00 3.010.000.00 0.00 43.175.00 0.00 3,010,000.00 5 Downtown Centel Area TIF 2003 2011 2024 420 2/1 8/1 - - 19.795.000.00 14.965.000.00 595.000.00 361.248.00 0.00 14,370.000.00 6 Airoad Development Area TI F Airport TIF 2003 2011 2024 324 2/1 8/1 - - 14.420.000.00 8.535.000.00 340.000.00 206.011.75 0.00 8,195,000.00 22 Erskine Village TIF Development Bond Erskine Village 2005 2027 432 2/1 8/1 - - 5.485.000.00 4255.000.00 220.000.00 137.545.00 0.00 4,035,000.00 54 Lease Rental Revenue B.d. of 2008 Eddy Street Commons 2008 2027 429 2/15 8/15 - - 36.000.000.00 33.020.000.00 530.000.00 931.934.00 0.00 32,490.000.00 81 Coveleski Stadium Recovery Cm leski Stadium 2010 2019 377 1/15 7/15 - - 4.980.000.00 2,915.000.00 620.000.00 134.802.50 0.00 2,295,000.00 104 2012 Gates Downtown Campus VA Clinic Acmt Loan 2012 2015 4201324 3/1 8/1 - - 1.700.000.00 566.666.68 283.333.33 0.00 0.00 283,333.35 121 Blackthorn Golf Cad Lease Blackthorn Golf 2014 2019 619 Monthly 14th 293.788.00 257.238.04 257.238.04 535.91 0.00 0.00 122 Svnscogue at Coveleski Improvements Coveleski Stadium 2014 2018 377 1/31 500.000.00 400.000.00 100.000.00 0.00 0.00 300,000.00 135 2015 Redevelopment Smart Streets Smart Streets 2015 2037 324 2/1 8/1 25.000.000.00 0.00 0.00 0.00 25.000.000.00 25.000.000.00 Tofal BOntl Debt 153.788.788.00 76.173.904.72 4.210.571.37 1.944.898.41 25.000.000.00 96.963.333.35 Loans Payable 3 Indiana Development Finance Authority Bosch Property (NoMagive) 2001 2021 210 3/22 6/22 9/22 12/22 1.040.000.00 423.620.93 29.759.08 8.248.14 0.00 394.061.85 4 IntlI na Development Finance Authority Bosch Property (Fomive) 2001 2021 210 - - 260.000.00 117.130.26 0.00 0.00 0.00 117,130.26 60 HUD Section 108 #8 Sludebaka Oliver 2008 2025 434 2/1 8/1 - - 4.000.000.00 180.000.00 0.00 3.897.00 0.00 180,000.00 63 City of Mishawaka Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1.102.549.56 47.003.09 47.003.09 1.175.08 0.00 0.00 64 Intertund Fund 412 -Maior Moves Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1.040.319.00 886.677.00 99275.00 22.167.00 0.00 787402.00 83 in tertund Fund 619 - BlacMhom Blackthorn Equip (qdf carts) 2010 2017 619 5/15 6/15 7/15 8/15 31.032.00 0.00 0.00 0.00 0.00 0.00 84 Intedund FUnd 412 -Maior Moves Triangle Development 2011 2029 436 2/15 8/15 - - 2.000.000.00 1.513259.50 45238.41 15.132.80 0.00 1,468.021.08 85 Intedund FUntl 412 -Maior Moves Eddy Street Commons 2011 2028 436 2/15 8/15 - - 4,100,000.00 3227,558.81 105,529.03 80,888.97 0.00 3,122,029.78 86 Interfund Funtl 209 to Aimort 324 Pmide Ave Brownfield Prgact 2011 2020 324 8/9 - - - 500.000.00 500.000.00 0.00 0.00 0.00 500.000.00 88 Blackthorn Loan from Aimort Blackthorn Equip (mowers) 2011 2018 619 5/15 6/15 7/15 8/15 53,598.50 0.00 0.00 0.00 0.00 0.00 Total Loans Payable 14.127.499.06 6.895.449.59 326.804.61 129.306.79 0.00 6,568.644.98 CapOal Lease Total Ca hal Lease 0.00 0.00 0.00 0.00 0.00 0.00 Leases 37 Tmnsoo Lease Leighton Plaza Game 2001 2015 404 6/30 12/30 - - 3.000.000.00 191.347.00 94260.00 5.740.00 0.00 97,087.00 13 Tranam Lease Main /COHaz Game 2006 2025 404 3/15 9/15 - - 2.510278.00 1.676.543.00 58.088.00 41,914.00 0.00 1,818,457.00 Total Lease 5.510278.00 1.867.890.00 152.346.00 47.654.00 0.00 1 1,715.544.00 Tofal Retlevelopment Commission 173.426.565.06 84.937.244.31 4,689,721.98 2.121.859.20 25.000.000.00 1 105.247.522.33 FlnanGal Report Juty 2015 -peDf City of South Bend Staffing Headcount Summary Budget Full Time I Jan Feb I Mar I Apr I May Jun I Jul I Aug I Sep I Oct I Nov I Dec Full Time Staff 1094.00 1084.00 1076.00 1077.00 1072.00 1073.00 1074.00 1065.00 0.00 0.00 0.00 0.00 0.00 Part Time Staff 68.00 70.00 90.00 101.00 110.00 109.00 101.00 0.00 0.00 0.00 0.00 0.00 Temporary /Seasonal 111.00 109.00 113.00 126.00 209.00 309.00 257.00 0.00 0.00 0.00 0.00 0.00 City Total 1263.00 1255.00 1280.00 1299.00 1392.00 1492.00 1423.00 0.00 0.00 0.00 0.00 0.00 Financial Report July 2015 - Headcount Staffing Page 22 of 25 City of South Bend Staffing Headcount Full Time Staff Amended Budget General Government Mayor 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 0.00 0.00 0.00 0.00 0.00 311 Call Center 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 0.00 0.00 0.00 0.00 0.00 Admin & Finance 21.00 21.00 21.00 21.00 21.00 21.00 20.00 19.00 0.00 0.00 0.00 0.00 0.00 Innovation/ Technology Office 4.00 2.00 3.00 3.00 3.00 3.00 3.00 3.00 0.00 0.00 0.00 0.00 0.00 Safety & Risk 3.00 3.00 2.00 2.00 2.00 2.00 2.00 2.00 0.00 0.00 0.00 0.00 0.00 Clerk 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 0.00 0.00 0.00 0.00 0.00 Common Council 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 0.00 0.00 0.00 0.00 0.00 L al De artment 11.00 10.00 11.00 11.00 11.00 11.00 11.00 9.00 0.00 0.00 0.00 0.00 0.00 Sub Total 67.00 64.00 65.00 65.00 65.00 65.00 64.00 61.00 0.00 0.00 0.00 0.00 0.00 Code Ent. /Animal Control 24.00 23.00 23.00 22.00 22.00 23.00 23.00 23.00 0.00 0.00 0.00 0.00 0.00 Dept. of Community Investment 25.00 23.00 23.00 24.00 24.00 24.00 25.00 25.00 0.00 0.00 0.00 0.00 0.00 Parks & Recreation Administration 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 0.00 0.00 0.00 0.00 0.00 Maintenance 44.00 44.00 44.00 44.00 43.00 43.00 44.00 45.00 0.00 0.00 0.00 0.00 0.00 Golf Operations 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 0.00 0.00 0.00 0.00 0.00 Recreation Ops 26.00 24.00 24.00 24.00 24.00 25.00 25.00 25.00 0.00 0.00 0.00 0.00 0.00 Zoological Ops 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 Graffiti Removal 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 Recreation Non-reverting 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 Sub Total 91.00 89.00 89.00 89.00 88.00 89.00 90.00 91.00 0.00 0.00 0.00 0.00 0.00 Public Safety Police 306.00 302.00 302.00 304.00 300.00 297.00 299.00 297.00 0.00 0.00 0.00 0.00 0.00 Communications 0.00 7.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 see narrative Fire 258.00 258.00 258.00 260.00 260.00 260.00 259.00 258.00 0.00 0.00 0.00 0.00 0.00 Sub Total 564.00 567.00 560.00 564.00 560.00 557.00 558.00 555.00 0.00 0.00 0.00 0.00 0.00 Public Works Central Services 37.00 34.00 34.00 33.00 34.00 35.00 34.00 34.00 0.00 0.00 0.00 0.00 0.00 Office of Sustainability 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 0.00 0.00 0.00 0.00 0.00 Engineering 16.00 15.00 15.00 15.00 16.00 16.00 17.00 16.00 0.00 0.00 0.00 0.00 0.00 Maintenance 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 0.00 0.00 0.00 0.00 0.00 Solid Waste Operations 21.00 20.00 21.00 21.00 21.00 20.00 19.00 20.00 0.00 0.00 0.00 0.00 0.00 Code Clean Crew 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 0.00 0.00 0.00 0.00 0.00 Street Operations 56.00 56.00 56.00 55.00 56.00 56.00 56.00 56.00 0.00 0.00 0.00 0.00 0.00 Sewer Operations 33.00 33.00 30.00 30.00 28.00 30.00 31.00 30.00 0.00 0.00 0.00 0.00 0.00 Waste Water Ops 44.00 44.00 44.00 43.00 43.00 42.00 41.00 41.00 0.00 0.00 0.00 0.00 0.00 Organic Resources 6.00 6.00 6.00 6.00 6.00 5.00 5.00 5.00 0.00 0.00 0.00 0.00 0.00 Water Utilit Ops 68.00 68.00 68.00 68.00 67.00 69.00 69.00 66.00 0.00 0.00 0.00 0.00 0.00 Sub Total 290.00 285.00 283.00 280.00 280.00 282.00 281.00 277.00 0.00 0.00 0.00 0.00 0.00 Building Department 13.00 13.00 13.00 13.00 13.00 13.00 13.00 13.00 0.00 0.00 0.00 0.00 0.00 Human Rights 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 0.00 0.00 0.00 0.00 0.00 Morris & Palais 14.00 14.00 14.00 14.00 14.00 14.00 14.00 14.00 0.00 0.00 0.00 0.00 0.00 City Total 1094.00 1084.00 1076.00 1077.00 1072.00 1073.00 1074.00 1065.00 0.00 QWO 0.00 0.00 0.00 Financial Report July 2015 - Headcount Staffing Page 23 of 25 City of South Bend Staffing Headcount Part Time Staff Financial Report July 2015 - Headcount Staffing Page 24 of 25 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 311 Call Center 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 Admin & Finance 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 Clerk 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Common Council 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Le al De artment 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 Sub Total 4.00 4.00 4.00 4.00 4.00 4.00 4.00 0.00 0.00 0.00 0.00 0.00 Code Enf. /Animal Control 2.00 2.00 2.00 2.00 2.00 2.00 2.00 0.00 0.00 0.00 0.00 0.00 Dept. of Community Investment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Parks & Recreation Administration 5.00 5.00 5.00 4.00 4.00 4.00 2.00 0.00 0.00 0.00 0.00 0.00 Maintenance 3.00 3.00 4.00 7.00 12.00 13.00 13.00 0.00 0.00 0.00 0.00 0.00 Golf Operations 0.00 1.00 20.00 29.00 34.00 34.00 33.00 0.00 0.00 0.00 0.00 0.00 Recreation Ops 31.00 32.00 32.00 30.00 30.00 32.00 25.00 0.00 0.00 0.00 0.00 0.00 Zoological Ops 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Graffiti Removal 0.00 0.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 39.00 41.00 62.00 71.00 81.00 83.00 73.00 0.00 0.00 0.00 0.00 0.00 Public Safety Police 5.00 5.00 5.00 5.00 5.00 7.00 2.00 0.00 0.00 0.00 0.00 0.00 Communications Fire Sub Total 5.00 5.00 5.00 5.00 5.00 7.00 2.00 0.00 0.00 0.00 0.00 0.00 Public Works Central Services 1.00 1.00 0.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 Engineering 3.00 3.00 3.00 3.00 3.00 2.00 2.00 0.00 0.00 0.00 0.00 0.00 Traffic & Lighting 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Solid Waste Ops 0.00 1.00 1.00 2.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Street Ops 4.00 3.00 3.00 3.00 2.00 0.00 7.00 0.00 0.00 0.00 0.00 0.00 Sewer Ops 0.00 0.00 0.00 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Waste Water Ops 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water Utilit Ops 3.00 3.00 3.00 3.00 3.00 3.00 3.00 0.00 0.00 0.00 0.00 0.00 Sub Total 11.00 11.00 10.00 12.00 11.00 6.00 13.00 0.00 0.00 0.00 0.00 0.00 Building Department 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Human Rights 2.00 2.00 2.00 2.00 2.00 2.00 2.00 0.00 0.00 0.00 0.00 0.00 Morris & Palais 5.00 5.00 5.00 5.00 5.00 5.00 5.00 0.00 0.00 0.00 0.00 0.00 City Total 68.00 70.00 90.00 101.00 110.00 109.00 101.00 0.00 0.00 0.00 0.00 0.00 Financial Report July 2015 - Headcount Staffing Page 24 of 25 City of South Bend Staffing Headcount Temporary, Seasonal, and Intern Staff General Government Jan I Feb Mar I Apr May I Jun Jul I Aug Sep I Oct I Nov Dec Mayor 0.00 0.00 0.00 0.00 0.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 Admin & Finance 4.00 1.00 1.00 1.00 2.00 5.00 5.00 0.00 0.00 0.00 0.00 0.00 Safety and Risk 0.00 0.00 0.00 0.00 0.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 Clerk 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Common Council 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Le al 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 4.00 1.00 1.00 1.00 2.00 7.00 7.00 0.00 0.00 0.00 0.00 0.00 Code Enforcement 0.00 0.00 0.00 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Dept. of Community Investment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Parks & Recreation Public Safety Public Works Building Department Human Rights Morris & Palais Administration 5.00 5.00 5.00 5.00 7.00 7.00 7.00 0.00 0.00 0.00 0.00 0.00 Maintenance 11.00 10.00 9.00 16.00 35.00 32.00 29.00 0.00 0.00 0.00 0.00 0.00 Golf Operations 2.00 3.00 10.00 11.00 16.00 25.00 20.00 0.00 0.00 0.00 0.00 0.00 Recreation Ops 46.00 47.00 38.00 46.00 83.00 160.00 147.00 0.00 0.00 0.00 0.00 0.00 Zoological Ops 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Graffiti Removal 0.00 0.00 0.00 0.00 0.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 Sub Total 64.00 65.00 62.00 78.00 141.00 225.00 204.00 0.00 0.00 0.00 0.00 0.00 Police 27.00 27.00 27.00 27.00 27.00 39.00 11.00 0.00 0.00 0.00 0.00 0.00 Communications 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fire 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 27.00 27.00 27.00 27.00 27.00 39.00 11.00 0.00 0.00 0.00 0.00 0.00 Central Services 0.00 0.00 0.00 0.00 0.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 Engineering 4.00 4.00 5.00 5.00 10.00 10.00 12.00 0.00 0.00 0.00 0.00 0.00 Energy /Sustainability 4.00 4.00 4.00 4.00 5.00 5.00 0.00 0.00 0.00 0.00 0.00 0.00 Traffic & Lighting 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Solid Waste Ops 3.00 3.00 9.00 8.00 10.00 9.00 10.00 0.00 0.00 0.00 0.00 0.00 Street Ops 1.00 4.00 1.00 0.00 4.00 6.00 6.00 0.00 0.00 0.00 0.00 0.00 Sewer Ops 2.00 0.00 2.00 2.00 6.00 5.00 5.00 0.00 0.00 0.00 0.00 0.00 Leaf Pickup 1.00 0.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Waste Water Ops 0.00 0.00 0.00 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Organic Resources 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water Utilit Ops 1.00 1.00 1.00 0.00 2.00 2.00 1.00 0.00 0.00 0.00 0.00 0.00 Sub Total 16.00 16.00 23.00 20.00 38.00 38.00 35.00 0.00 0.00 0.00 0.00 0.00 City Total 111.00 109.00 113.00 126.00 209.00 309.00 257.00 0.00 0.00 0.00 0.00 0.00 Financial Report July 2015 - Headcount Staffing Page 25 of 25