Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
06-2015 Financial Report
Period Ending: Issued By: June 30, 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 June 2015 Page 1 of 25 June 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 For discussion on property taxes, see section listed below. The overall percentage of budgeted revenues that have been received by the city is 50 %. The overall percentage of collected revenue amount for June 2014 was 50 %. 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 by fund As of June 30, 2015, the general fund has received 54% of its budgeted revenue, compared to 52% 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 107% or $17,631 over its budgeted revenue. This is due to a transfer of $256,085 from fund 641 (Sewage Works Operations) for reserve purposes. Fund 439 (Certified Technology Park), is at 377% or $12,217 over its budgeted revenue. This is revenue from bank and investment interest. Fund 661(2012 Sewer Bond), is at 280% or $36,066 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 June 2015, the City has spent 36% of budgeted expenditures, compared to 33% of budgeted expenditures in June 2014. The General Fund has spent 49% of its 2015 budgeted expenditures, versus 47% 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 June 2015, several debt service payments were made in the amount of - $420,865 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. Headcount The Full Time Headcount as of June 2015 was 1,074 vs. a budgeted amount of 1,094. Currently, there are a total of 20 vacant positions. The 20 open positions are in the following departments: Public Safety (6), Public Works (9), Code Enforcement / Animal Control (1), Parks Recreation (1) and other (3). * In Public Safety (Fire), the headcount is over budget as there are currently three recruits in training to replace planned and unplanned departures. If you have any questions regarding this report, please contact John Murphy at (574) 235 -7678. Financial Report June 2015 Page 2 of 25 City of South Bend Period Ending: June 30, 2015 Revenue by Type Report 2,601,930 Fund % Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Budget of Bud et Property Tax ,to Excise Tax various 1,549,713 1,549,713 2,508,752 311 Property Tax Civil City various 465,648 465,648 883,438 tel Motel Tax Century Center 25,564,735 25,564,735 45,606,508 56% 311 Property Tax TIF Districts various 292,000 292,000 490,500 tel Motel Tax Century Center 14,121,026 14,121,026 24,514,604 58% Sub Total 407 453,318 453,318 150,000 b Total 39,685,761 39,685,761 70,121,112 57% Income Tax 439 13,183 11,261 14,750 69,400 _ _ _ _ _ _ _ _ _ NA 315 Econ Development Income Tax 408 765,101 765,101 1,463,758 748,490 748,490 4,490,939 8,981,877 50% 316 Local Option Income Tax -PS 249 538,849 538,849 1,077,698 538,849 538,849 3,233,095 6,466,190 50% 316 County Option Income Tax 404 738,326 738,326 1,476,652 738,326 738,326 4,429,956 8,859,912 50% Sub Total 101 2,042,276 2,042,276 4,018,108 2,025,665 2,025,665 12,153,990 24,307,979 50% ;ounty (Remitted by) ,to Excise Tax various 1,549,713 1,549,713 2,508,752 mmercial Vehicle Tax various 465,648 465,648 883,438 tel Motel Tax Century Center 670 656,725 656,725 1,313, 436 tel Motel Tax Century Center 324 292,000 292,000 490,500 tel Motel Tax Century Center 420 _ _ _ _ _ _ _ _ _ _ _ _ _ _ tel Motel Tax Cum Cap Impm 407 453,318 453,318 150,000 b Total 5,705,692 656,725 292,000 2,015,361 2,964,086 5,346,126 State of Indiana Remitted b 312 CRED Tax 434 1,729 226 31,642 12, 460 17,914 104,502 150 0% 335 Cigarette Tax 1011407 50% 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 5,705,692 11,411,384 50% 335 CTP Distribution 439 13,183 11,261 14,750 69,400 _ _ _ _ _ _ _ _ _ NA 335 Gaming Proceeds 101 48,246 51,834 52,953 53,072 320,277 798,302 600,000 0% 335 Gasoline Tax 2021251 348,926 369,636 422,676 426,523 435,833 373,229 2,376,823 4,647,000 51% 335 Liquor Excise tax 101 41,349 222 383,538 417,794 450,403 41,349 65,000 64% 335 Liquor Gallonage Tax 101 67,259 380 30,798 various 114,099 98,057 200,000 49% 335 ProfSports Development Tax 377 63,326 142,874 63,470 35,855 29,251 42,734 377,510 747,750 50% 335 Wheel Tax 202 418,779 67,941 392,533 215,701 50% 1,094,954 2,050,000 53% Sub Total 3,518,478 939,639 512,510 554,087 885,709 680,785 6,271,395 9,844,125 20,039,102 49% governmental Sources deral Drug 299 1,729 226 31,642 12, 460 17,914 104,502 63,744 75,000 vte Drug 216 50% 340 810 1011289 810 35,000 yment in Lieu of Tax various 453,318 453,318 453,318 453,318 453,318 453,318 2,719,908 5,439,810 ntractual Service 211 13,183 11,261 14,750 69,400 8,480 37,285 154,360 243,000 nds various 48,246 51,834 52,953 53,072 320,277 798,302 40% 380 b Total 222 468,230 464,579 500,519 535,178 479,712 490,603 2,938,821 5,792,810 Charge for Service Internal City 340 Liability Insurance 226 99,293 101,897 101,897 104,502 99,293 104,502 611,384 1,222,727 50% 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 30,200 61,100 49% 349 Central Service 222 51,890 62,282 48,246 51,834 52,953 53,072 320,277 798,302 40% 380 Central Service 222 199,523 201,656 208,098 203,681 214,579 195,611 1,223,148 2,800,655 44% 380 Energy Office Reimbursements 222 383,538 417,794 450,403 363,667 331,109 330,089 2,276,600 4,471,200 51% 380 Internal Service Reimbursement various 114,099 125,201 140,744 220,036 141,034 112,567 853,680 3,048,181 28% 392 Administration Fee 101 303,580 303,580 303,580 303,580 303,580 303,580 1,821,477 3,642,953 50% 392 Internal Fund Transfers various 966,983 3,518,478 7,340,433 1,062,256 6,327,336 1,021,220 20,236,706 34,300,476 592L 395 Employee Benefits 711 1,234,237 1,233,503 1,224,809 1,216,576 1,207,904 1,203,674 7,320,702 16,427,996 45% Financial Report June 2015 - Revenue Report Page 3 025 City of South Bend Period Ending: June 30, 2015 Revenue by Type Report 2,601,930 Fund % Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Budget I -fBudeiet 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 34,717,665 66,814,790 52 d Party Revenue 340 No EMS Service 288 320 Inspections Central Service 11,080 4,675 39,099 808 55,661 150,000 37 340 Memorial Hospital Neo Natal 101 10,022 56,678 36,788 10,545 10,231 2,280 126,543 125,000 101 350 Job Target Penalty Fee 408 4,182 101,002 126,490 354,660 354,660 354,660 106 364 Cable TV Franchise Fees 101 177,167 3,595 5,346 183,970 361,137 700,000 52 366 AT &T Franchise Fees 101 69,037 181,309 96,256 69,608 138,644 276,000 56 Sub Total 322 Code Enforcement Fees 10,022 302,882 47,868 15,220 657,567 3,088 1,036, 646 1,605,660 65 ants 331 Federal Grants various 321,650 121,681 172,179 326,005 247,506 251,238 1,440,260 7,317,445 20 334 State Grants various 3,600,000 0 Sub Total 321,650 121,681 172,179 326,005 247,506 251,238 1,440,260 10,917,445 13 Fees for Services External 320 Inspections Central Service 222 330 490 10 230 1,060 1,400 76% 321 Business License 1011222 31,966 22,740 20,630 13,394 8,091 4,182 101,002 126,490 80% 321 Code and Animal Fees 600 3,725 4,795 5,793 6,503 3,595 5,346 29,757 75,200 40% 322 Building Fees 600 65,509 54,764 181,309 96,256 225,069 113,669 736,575 1,083,832 68% 322 Code Enforcement Fees 600 150 450 1,500 500 50 1,000 3,650 2,800 130% 322 EMS Operating Fund 288 2,233 2,460 1,295 2,375 2,046 2,074 12,483 25,000 50% 322 General Government Fees 101 6,640 725 1,030 2,430 2,115 1,605 14,545 13,000 112% 341 General Government Various various 1,736 1,940 1,164 1,602 4,952 2,701 14,095 33,405 42% 342 Highway & Streets 1011202 24,377 9,564 2,090 80,755 25,490 142,276 390,000 36% 342 Public Safety various 22,350 26,067 13,071 12,281 10,209 9,641 93,619 134,500 70% 342 EMS - Count Fees 288 426,728 142,243 142,243 142,243 853,455 1,667,565 51% 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 1,367,698 2,902,500 47% 342 EMS - Neo Natal 288 74,340 74,340 385,000 19% 344 Solid Waste 610 401,357 397,131 400,073 405,112 406,770 408,056 2,418,500 5,091,168 48% 344 Code Environmental Clean Up 1017600 11,215 1,263 1,051 27,629 4,609 11,674 57,441 54,000 106% 344 Sewage Waste Water 641 2,776,091 2,783,483 2,821,111 2,926,251 2,971,386 2,975,155 17,253,476 35,234,467 49% 344 Sewer Repair Insurance 640 50,523 52,458 49,781 51,388 49,827 50,237 304,214 551,200 55% 344 Water Leak Insurance 620 80,558 79,817 80,181 74,113 80,653 80,717 476,037 960,000 50% 346 Water Works Utility 620 979,733 976,299 965,088 992,620 1,024,608 1,263,334 6,201,682 13,678,403 45% 346 Solid Waste Misc 610 5,075 4,623 6,710 97,941 7,710 8,274 130,332 128,148 102% 346 Project ReLeaf 655 36,473 36,203 36,396 36,456 36,590 36,613 218,731 429,000 51% 347 Parks & Recreation various 88,374 165,687 152,152 218,148 248,263 326,282 1,198,906 3,565,625 34% 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 Z522 33,091 100,000 33% 349 Parking Garage Fees 601 77,130 56,458 83,412 67,492 90,594 81,037 456,123 908,675 50% 349 Code Demolition Board Up 1017600 2,932 9,994 467 12,513 11,595 22,467 59,967 39,000 154% 349 Parking Century Center 670 8,435 17,329 24,852 7,896 7,058 10,405 75,975 103,297 74% 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 120,723 484,020 25% 352 Forfeits various 3,455 875 2,775 4,570 2,352 19,150 33,177 258,820 13% 354 Ordinance Violation various 1,305 2,165 4,133 2,313 1,662 3,474 15,052 42,000 36% 360 Morris PAC various 52,561 22,635 129,679 31,466 52,867 108,722 397,929 934,900 43% 360 Palais Royale various 22,259 6,290 10,385 18,475 17,124 14,402 88,934 244,270 36% 360 Parks & Recreation various 26,797 14,565 4,051 10,548 20,675 12,889 89,526 106,700 84% 360 Police various 3,170 4,378 Z510 1,609 7,606 4,440 23,713 62,100 38% 360 TIF various 5,056 2,657 3,480 3,373 3,284 52,071 69,921 44,806 156% 360 Central Services 222 19,705 3,212 15 320 4,646 855 28,752 37,087 78% 360 Century Center 670 5,117 4,970 35,471 3,054 7,135 324 25,106 15,000 - 167% 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 30,294 22,000 - 138% 360 Fire and Police Pension Fund 7011702 3,743 3,743 8,000 47% 360 Self Funded Employee Benefits 711 6,000 6,000 6,000 100% 360 General Government Various 101131226 196 853 1,386 2,436 4,250 57% 360 Motor Vehicle Highway Scrap Meta 202 1,735 1,127 2,863 4,000 72% 360 Motor Vehicle Highway Curb Pr gm 202 3,615 324 6,819 4,538 2,992 3,583 21,871 50,000 44% 360 Local Roads and Streets 251 14,730 5,644 20,375 22,000 93% 360 ProfessionalSports Development 377 29,523 29,523 60,661 49% 360 Cumulative Capital Improvement 407 200 0% 360 UDAG 410 98,485 143,363 241,849 528,576 46% Financial Report June 2015 - Revenue Report Page 4 025 City of South Bend Period Ending: June 30, 2015 Revenue by Type Report 2,601,930 Fund % Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Budget of Bud et 360 Code/ Animal Control 600 18,739,220 15,892,928 0 60,878,117 - - - various 34,357 1,472,130 1 0 100 0% 360 Parking Garage 601 26,905 20,000 3 600 1 0 3 le of Fixed Assets NA 360 Solid Waste Fund 610 12,000 hicle Damage Reimbursement various 1,000 b Total 2,000 0% 360 Waste Water 6411719 2,142 3,229 998 5,441 14,166 25,975 55,200 47% 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 31,827 72,000 44% 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 24,170 40,000 60% 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 117,405 339,025 35% 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 961,989 2,387,518 40% 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 115,247 218,398 53% 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 36,206,850 76,128,541 48% ome nk Account Interest various 197,258 51,054 75,698 118,454 65,582 223,194 731,240 840,686 b Total 197,258 51,054 75,698 118,454 65,582 223,194 731,240 840,686 I Contribution 101 330,000 nations various 2,072 990 405 46 3,493 2,131 9,136 425,356 b Total 2,072 990 405 46 3,493 2,131 9,136 755,356 enervation mpost Program 227 19,750 5,750 750 1,000 27,250 30,000 lais 450 1,225 3,703 357 982 1,115 592 7,974 16,000 b Total 1,225 3,703 20,107 6,732 1,865 1,592 35,224 46,000 ets 16,029,980 18,739,220 15,892,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 26,905 20,000 oceeds F.A. Disposal 600 1 0 0 le of Fixed Assets various 12,000 hicle Damage Reimbursement various 1,000 b Total 34,357 1,474,307 473 8,103 16,154 1,533,393 2,587,487 Revenue Total 12,866,555 16,029,980 18,739,220 15,892,928 18,890,401 60,878,117 - - - - - - 143,297,201 285,302,944 50% report 12,866,555 16,029,980 18,739,220 15,892,928 18,890,401 60,878,117 - - - - - - 143,297,201 285,302,944 0 0 0 1 0 0 0 Financial Report June 2015 - Revenue Report Page 5025 City of South Bend Revenue by Fund Report Period Ending: June 30, 2015 s i Fund Jan I Feb I Mar I Apr I May Jun I Jul I u Se P 1 Oct Nov 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 27,503,656 50,243,482 55% 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 240,000 486,733 49% 0301 Common Council 101 41 31 15 231 31 31 379 8,655 4% 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 27,763,337 50,793,681 55% Public Works 0602 Engineering 101 225 303 1,104 635 2,267 77,027 3% Sub Total 225 303 1,104 635 2,267 77,027 3% Public Safety 0801 Police 101 6,604 11,372 38,367 2,321 20,918 11,729 91,312 555,200 16% 0901 Fire 101 10,022 59,625 37,787 11,021 10,231 2,280 130,966 138,300 95% Sub Total 16,625 70,998 76,154 13,343 31,149 14,009 222,278 693,500 32% 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 397,700 923,000 43% 0405 Palais Royale 101 24,368 9,347 13,572 30,163 23,990 26,667 128,107 335,270 38% Sub Total 77,697 3Z647 141,998 62 003 75,773 135,689 525,807 1,258,270 42% General Fund Revenue Total 1,316,569 1,085,136 931,673 861,573 1,088,889 23,228,972 - - - - - - 28,512,812 52,822,478 54% Financial Report June 2015. Expenditure Summary Page 6 of 25 City of South Bend Revenue by Fund Report Period Ending: June 30, 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 4,924,003 8,860,875 56% 1100 Administration 201 2,119 4,537 4,158 4,527 6,168 2,736 24,246 40,600 60% 1101 Maintenance 201 19,996 2425 3,330 1,823 4,085 2915 34,573 319,600 11% 1102 GolfOperations 201 161 63,205 31,916 147,893 185,191 234,366 55Z 733 1,535,000 43% 1103 Recreation Division 201 26,067 16,036 5,765 54 3,370 19,150 70,441 185,640 38% 1104 Potawatomi Zoo 201 NA 1108 Grafd Removal 201 11,341 13,003 7,268 31,612 89,000 36% Recreation Non Reverting 203 65,607 98,601 lIZ441 78,613 75,090 82,878 513,230 1,578,935 33% East Race Waterway 271 5 1 2 3 2 3 16 50 32% Coveleski Stadium 401 36 9 14 23 13 43 138 15,100 1% Zoo Endowment 403 43 11 17 28 15 52 167 200 84% Park Non Reverting 405 4,435 260 261 1,080 1,573 1,269 8,878 143,700 6% Sub Total 194,930 270,809 235,349 321,616 356,766 4,890,567 6,270,037 12,768,700 49% Public Works Motor Vehicle Highway 202 716,020 1,133,459 404,476 730,770 1,504,136 316,658 4,805,519 9,701,800 50% Central Services 222 655,888 688,603 709,665 623,157 619,227 584,294 3,880,835 8,151,184 48% Central Services Capital 224 271,850 0% Local Roads & Streets 251 87,782 90,155 98,666 112 757 99,309 97,010 585,680 1,776,300 33% Pro'ect ReLeaf 655 37,371 36,419 36,757 37,059 36,928 37,776 22Z312 431,700 51% Sub Total 1,497,062 1 948 636 1,249,565 1 503 744 Z259,601 601 1 035 738 9,494,345 20 332,834 47% Public Works Solid Waste Solid Waste Operations 610 408,178 401,846 406,879 589,225 414,603 416,858 2 637,589 5712 289 46% Solid Waste Capital 611 190,033 10,001 84,001 17 46,000 330,053 753,011 44% Sub Total 598,211 401,846 416,880 673,226 414,621 46Z858 Z967,642 6,465,300 46% Public Works Water Utility 0000 Water Works Revenues 620 916,194 910,250 905,299 929,577 96Z334 1,179,467 5 803,120 12 724,463 46% 0630 Water Leak Insurance 620 80,558 79,817 80,181 74,113 80,653 80,717 476,037 960,000 50% 0660 Clay Water 620 68,898 68,829 66,186 76,543 74,475 111,884 466,814 1,096,020 43% Waterworks Capital 622 Z 776 682 1,098 1,741 946 3,225 10,467 10,000 105% Waterworks Construction 623 180 41 62 83 41 137 544 450 121% Waterworks Deposit 624 1,307 324 527 854 463 1,582 5,056 6,000 84% Waterworks Sinking 625 468 340,551 170,359 170,557 170,477 171,158 1,023,571 2,050,078 50% Waterworks Bond Reserve 626 1,425 353 572 2351 9,500 25% Waterworks Debt Reserve 629 1,840 150,683 775 1,279 695 2367 157,637 16Z 749 97% Sub Total 1,073,645 1,551,529 1,225,058 1,254,745 1,290,083 1,550,537 7,945,597 17,019,260 47% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 51,853 52,790 50,328 52,269 50,308 51,875 309,423 554,800 56% 0000 Wastewater Revenues 641 2,628,692 2,622,801 2,675,830 2,753,646 2,798,663 2,811,021 16,290,654 33,201,605 49% 0621 Sewer Department 641 998 530 1,528 2,000 76% 0625 Concrete Crew 641 4,705 10,805 16,966 32,476 75,000 43% 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 995,234 2,059,962 48% Sewage Ca ital 642 3,385 815 1,313 2036 4,001,015 6,750 4,015,313 5,398,000 74% Sewage Reserve 643 3,020 256,833 1,248 2,104 1,143 3,895 268,243 271,612 99% Sewer Bond 2007 647 NA Sewage Bond Sinking 649 774,321 773,801 774,198 775,158 774,671 778,095 4,650,245 9,288,088 50% 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 3,378 6,000 56% 2012 Sewer Bond 661 14,968 3,669 5,897 9,437 5,061 17,033 56,066 40,000 140% 2013A Sewer Refund Bonds 664 4 1 2 3 1 5 15 50 30% Sub Total 3,635,057 3,878,074 3,659,472 3,776,819 7,813,066 3,860,087 26,622,574 50,897,117 52% Financial Report June 2015. Expenditure Summary Page 7 of 25 City of South Bend Revenue by Fund Report Period Ending: June 30, 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 1,445 36,050 4% Curfew Violations 218 11 3 17 7 4 38 78 1,025 8% Law Enforcement Educadon 220 24,859 28,459 17,376 64,238 18,300 17,495 170,726 270,000 63% Public Safe Lon. 249 540,008 539,058 430 1,078,221 539,072 539,985 3,236,774 6,472,240 50% 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 62,239 124,200 50% Police Block Grant 280 3 1 1 2 1 4 13 NA Police Grants 292 55 56,891 56,947 90,000 63% Police cademy 294 11,010 7,628 1,101 893 21 68 20,721 22,700 91% COPS More Grants 295 564 782 681 33,633 619 832 37,110 150,258 25% Drua Enforcement 299 1,817 83 31,713 12,542 18,004 98 64,257 77,000 83% K -9 Unit 705 503 1 1 2 1 1,003 1,511 2,000 76% Sub Total 593,567 585,530 61,724 1,256,127 585,433 569,440 3,651,821 7,245,473 505, Publie Safe - Fire nc Te /e hone S stem 244 19 19 20 97% ital 287 396,727 13 206 112 383 397,442 1,150,350 35% erafin Fund U 288 204,337 169,122 667,161 441,484 434,559 508,444 2,425,107 5,679,065 43% 289 3 732 10 095 10 18 f 0 34 13 900 14 100 99% scue 291 3,093 Z423 3,038 651 12 628 694 2Z528 45,350 50% Sub Total 211,182 578,368 670,222 44Z360 447,309 509,554 Z858,995 6,888,885 42% Department of mmunity Investment Studebaker /0liver 209 959 3,612 16,720 20,676 15,140 16,755 73 862 644,000 11 State Grant 210 290 70 112 181 93 36,192 36,939 3,673,510 1% ,,Cl Operating 211 14,699 503,257 17,090 72,469 500,684 38,606 1,146,805 Z 634,425 44% 0000 Dept of Community Investment 212 3,790 12Z 753 240,619 202 172 106,570 83,119 759,023 5,890,000 13% xxx Programs 212 95,353 124,819 154,530 374,702 NA 0000 Economic Revenue Bond 281 24 6 10 16 8 29 93 300 31 Sub Total 115,115 629,699 274,551 295,513 747,314 329,231 Z391,423 12 842,235 19% 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 125,262 267,737 47% 0462 Leighton Plaza 601 38,528 22,329 36,745 34,605 44,243 40,602 217,052 417,088 52% 0463 Enforcement 601 5,219 7,017 6,595 8,281 7,416 10,105 44,632 117,400 38% 0464 Wayne Street 601 17,498 16,724 22,424 12,234 24,291 19,471 112,642 222,950 51% 0465 Eddv Street Commons 601 - - - - - 280 280 15.900 2% Financial Report June 2015. Expenditure Summary Page 8 of 25 City of South Bend Revenue by Fund Report Period Ending: June 30, 2015 s % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Se 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 29,391 34,680 85% Excess Le 103 1 1 2 1 4 9 NA Gift Donation Bequest 217 1,618 989 364 80 195 174 3,420 398,800 1% Loss Recovery 227 5,206 4,007 21,727 8,608 2,128 5,168 46,844 50,000 94% Human Rights 258 2,065 7,188 5,759 3,628 6,425 699 25,763 209,950 12% Morris Palais Marketing 273 274 6 1,373 366 1,258 428 3,704 18,000 21% Professional Sports Development 377 93,375 142,965 63,547 36,086 29,386 43,242 408,502 809,511 50% 1201 Code Enforcement 600 18,559 529,948 11,282 46,664 24,464 56,078 686,994 2,417,446 28% 1207 Animal Control 600 3,725 162,197 5,846 6,503 3,595 5,346 187,212 704,768 27% 1306 Building Operations 600 66,158 54,907 181,599 96,899 225,373 125,219 750,155 1,086,999 59% Century Center 670 32,985 783,504 203,146 211,537 169,457 268,954 1,669,583 3,819,251 44% Century Center Capital 671 24 21 23 22 74 106 270 500 54% Century Center Energy Saying 672 50,000 7 50,007 50,000 100% Sub Total 231,619 1,687,621 497,732 415,343 515,044 514,596 3,861,955 9,599,905 40% Business Insurance 0000 Business Insurance Revenues 226 104,344 103,108 103,815 107,554 100,942 112,231 531,994 1,243,227 51% 0418 Workers Compensation 226 17,000 0% Sub Total 104,344 103,108 103,815 107,554 100,942 112 231 631,994 1,260,227 50% Fiducia Trust & Agency Fire Pension 701 688 130 54 3,743 2 518 013 2 522, 628 5,044,525 50% Police Pension 702 1,133 230 184 3,187,679 3189,226 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 7,304,658 16 357, 770 45% Unemployment Comp 713 8,685 8,526 8,559 8,613 8,549 8,731 51,662 113,796 45% Cemetery Trust 730 25 6 10 16 9 30 97 150 64% Sub Total 1,259,249 1 235 119 1,226,689 1 223 071 1,209,480 6 914 660 13 068,270 27 901, 600 47% Civil City Revenues 12,653,540 15,953,113 10,816,094 15,511,366 18,836,330 46,560,441 - - - - - - 120,330,883 250,198,967 48% Tax Increment Financing TIF Airport 324 50,350 33,228 6,479,376 346,205 37,081 9,550,306 16,496,546 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 199,821 422,800 47% TIF Leighton Plaza 425 18,229 12,971 10,040 21,366 8,977 15,860 87,443 189,423 46% 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 2,859,965 3,829,653 75% TIF Southside 430 4,144 1,025 1,590 2,545 1,371 1,303,629 1,314,304 2,410,750 55% TIF Erskine Village 432 5,246 1,268 1,967 3,083 1,675 17,202 30,441 25,000 122% TIF Douglas Road 435 161 48 23 30 16 163,999 164,277 320,750 51% Northeast Residential TlF 436 1,215 352 5 1,663,572 1,665,144 2,815,000 59% Sub Total 106,191 54,887 7,920,047 376,589 51,315 14,308,913 22,817,941 34,957,622 65% Financial Report June 2015. Expenditure Summary Page 9 of 25 City of South Bend Revenue by Fund Report Period Ending: June 30, 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 - - - - - - 22,966,318 35,103,877 65% City Operations Total 12,866,555 16,029,980 18,739,220 15,892,928 18,890,401 60,878,117 - - - - - - 143,297,201 285,302,944 50% Revenue report 12,866,555 16,029,980 18,739,220 15,892,928 18,890,401 60,878,117 0 0 0 0 0 0 143,297,201 285,302,944 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report June 2015. Expenditure Summary Page 10 of 25 City of South Bend Property Tax Revenue 2014 Tax Pay 2015 Fund Period Ending: June 30, 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 June 2015 - Property Tax Revenue Page 11 of 25 City of South Bend Property Tax Revenue 2013 Tax Pay 2014 Fund Period Ending: June 30, 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 June 2015 - Property Tax Revenue Page 12 of 25 City of South Bend Period Ending: June 30, 2015 Expenditure Report 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 Budget of Bud et vemment ryor 101 80,464 52,550 48,452 55,723 53,138 57,124 347,451 741,267 1 Call Center 101 55,195 36,290 43,995 32,989 35,855 35,676 240,000 486,733 erk 101 34,775 28,270 26,114 26,345 27,469 28,359 171,331 431,573 ommon Council 101 33,803 24,869 110,974 30,970 47,806 24,460 272,882 490,150 NIT Contract 101 411 43,000 (411) 43,000 43,000 Iministration and Finance 101 187,531 134,271 139,736 136,435 154,038 136,652 888,663 2,020,544 gal Department 101 99,178 73,129 64,725 70,589 73,432 71,133 452,186 1,006,979 ib Total 490,946 349,379 433,994 353,052 434,738 353,404 2,415,513 5,220,246 cs igineering 101 72,931 79,671 89,919 62,192 67,688 70,000 442,400 1,058,933 ib Total 72,931 79,671 89,919 62,192 67,688 70,000 442,400 1,058,933 ty dice 101 2,557,412 1,878,728 1,990,424 1,850,902 1,869,819 1,977,962 12,125,248 25,633,064 lice -PS LOIT funded 101 2,562 6,199 (8,761) Mice Communications 101 135,031 97 8 514,528 128,638 128,638 906,939 1,687,540 •e 101 2,150,469 1,590,349 1,505,644 1,328,213 1,314,720 1,472,585 9,361,980 17,774,474 v-PS LOIT funded 101 411 (411) x ib Total 4,845,886 3,475,373 3,487,315 3,693,643 3,313,177 3,578,773 22,394,166 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 497,351 1,093,132 dais Royale 101 41,912 31,105 39,827 31,888 34,119 37,926 216,778 536,293 ib Total 138,749 118,696 120,497 107,226 109,192 119,769 714,129 1,629,425 Ws iman Rights 101 50,323 31,896 19,693 30,347 27,284 23,670 183,214 373,179 ib Total 50,323 31,896 19,693 30,347 27,284 23,670 183,214 373,179 General Fund Expenditure Total 5,598,836 4,055,015 4,151,418 4,246,460 3,951,368 4,145,615 - - - - - - 26,148,712 53,379,131 49% Financial Report June 2015. Expenditure Summary Page 13 of 25 City of South Bend Period Ending: June 30, 2015 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun Jul I Aug 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 488,082 967,568 50% 1101 Maintenance 201 435,157 348,338 455,082 344,569 398,104 448,976 2,430,226 5,178,905 47% 1102 GolfOperations 201 66,821 76,812 203,778 123,539 118,983 170,789 760,722 1,573,436 48% 1103 Recreation Division 201 193,339 143,079 147,938 140,851 152,356 160,490 938,054 2,328,698 40% 1104 Potawatomi Zoo 201 392,247 lIZ389 8,788 7,968 5,262 354,274 880,927 863,017 102% 1106 Potawatomi Greenhouse 201 5,079 20,391 5,260 3,156 2005 1,101 36,993 53,997 69% 1108 Graffiti Removal 201 9,057 7,116 5,887 7,268 6,941 6,483 42,752 98,374 43% Recreation Non Reverting 203 43,898 60,957 66,785 87,752 84,777 111,498 455,667 1,549,469 29% East Race Waterway 271 637 455 775 2098 695 2367 2098 4,000 52% Coveleski Stadium 401 968,839 1,479,202 1,183,962 1,068,758 1,276,167 1,860,194 7,837,122 3,540 0% Zoo Endowment 403 _ _ _ _ _ _ _ _ _ _ _ _ _ 49,000 0% Park Non Reverting 405 - - - 2,197 19,422 11,316 32,935 192,933 17% Sub Total 659 1,249,824 840,754 960,531 801,319 867,731 1,348,296 6,068,455 12,862,937 47% Vorks Motor Vehicle Highay 202 734,565 950,683 835,051 410,155 418,569 407,917 3,756,939 8,843,890 Curb and Sidewalk 202 lIZ714 39,990 31,802 29,933 21,753 32,125 268,317 1,641,496 Central Services 222 679,565 621,835 691,937 716,505 537,157 556,899 3,803,897 8,300,242 Central Services Capital 224 4,000 9% Waterworks Capital 622 15,382 67,463 3,489 271,850 Local Roads & Streets 251 4,155 4,853 37,032 6,650 109,145 87,781 249,616 2 126,221 Project ReLeaf 655 15,357 2281 2386 27,010 2442 2899 52,375 528,358 Sub Total 854 1,546,355 1,619,642 1,598,209 1,190,253 1,089,066 1,087,621 8,131,145 21,712,057 Vorks Solid Waste Solid Waste Operations 610 635,488 341,051 339,903 382,803 461,210 482,019 2,642,475 5,873,863 Solid Waste Capital 611 223,749 143 11,054 83,702 168 45,686 364,502 752,811 Sub Total 859,237 341,194 350,957 466,506 461,378 527,706 3,006,977 6,626,674 Public Works Water Utility 0630 Water Leak Insurance 620 33,830 53,166 43,413 474 131,182 93,577 355,643 1,115,000 329/ 0640 Water Works 620 906,773 1,320,043 1,131,090 1,058,030 1,143,612 1,164,702 6,724,251 14,725,471 46% 0660 Clay Water 620 22 29,608 309 26 13 9 379 4,000 9% Waterworks Capital 622 15,382 67,463 3,489 1,776,763 5,782,494 109,780 196,114 838,893 23% Waterworks Construction 623 11,278 37,750 4,276 438 85,097 121,821 175,564 53,085 331% Waterworks Deposit 624 452 324 527 854 463 1,582 4,201 6,000 70% Waterworks Sinking 625 465 1 84 282 202 366,356 367,391 2,050,078 18% Waterworks Bond Reserve 626 1,045 747 1,248 7,374 1,143 3,895 7,374 14,500 51% Waterworks Debt Reserve 629 637 455 775 1,279 695 2367 6,206 8,500 73% Sub Total 649 968,839 1,479,202 1,183,962 1,068,758 1,276,167 1,860,194 7,837,122 18,815,527 42% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 21,449 57,144 43,434 46,092 55,529 30,576 254,223 545,703 47% 0621 Sewer Repair 641 446,632 360,251 404,056 284,993 308,945 341,348 2,146,225 7,201,049 30% 0625 Concrete Crew 641 44,148 29,608 25,634 23,472 31,229 31,724 185,816 450,450 41% 0630 Wastewater Operations 641 2,004,256 2,110,111 1,803,497 1,776,763 5,782,494 1,787,251 15,264,372 31,017,413 49% 0631 Organic Resources 641 69,307 56,543 60,055 54,333 85,097 80,559 405,894 1,527,562 27% 0650 Clay Sewage 641 28 103 106 113 5 344 500 69% Sewage Ca ital 642 39,115 47,104 402228 2254 281,988 588,063 1,360,753 7,071,710 19% Sewage Reserve 643 1,045 747 1,248 2,104 1,143 3,895 10,182 15,000 68% Sewer Bond 2007 647 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA Sewage Bond Sinking 649 1,000 850 301,269 1,288,842 1,591,961 9,282,109 17% Sewage Bond 2007 651 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA 2010 CSO Net Sewer Bond 658 - - - - - - - - - - - - - - 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 1,151,836 16,624,275 7% 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 23,456,964 77,447,609 30% Financial Report June 2015. Expenditure Summary Page 14 of 25 City of South Bend Period Ending: June 30, 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 Public Safe - Police EMS Ca ital 287 35,728 35,728 Seizures 216 288 247,977 32,280 210,228 382,360 383,042 402,139 1,658,026 6,855,366 Hazmat 289 35,900 0% Violations 218 River Rescue 291 0 2,120 21,395 854 20,421 5,081 49,870 120,800 Sub Total 1,000 0% forcement Education 220 15,730 29,274 27,290 24,802 29,310 45,024 171,430 362,478 47% nc Tele hone S stem 244 20 1 21 5,899,970 Administration 212 183,750 365,625 NA Safe LOIT UE-ergency 249 73 2,055 515,347 549,323 505,155 516,948 559,128 3,377,956 7,246,551 47% Welfare Pu61ic Safet 252 16,514 647,998 Sub Total 146,068 369,417 329,268 372,756 1,146 0% Take Home Vehicle 278 13,534,110 153,529 335,865 138,115 116,706 281,960 1,082,033 71,100 0% Grants 292 1,268 15,297 11,946 11,079 1,740 15,297 105,145 15% Academ 294 2,725 9,673 242 11,678 476 678 25,471 23,750 107% More Grants 295 20,490 784 4,485 1,262 479 2,403 29,903 172,335 17% Dnfa Enforcement 299 18,385 6,474 18,397 6,844 6,225 56,869 113,194 248,960 45% K -9 Unit 705 2,899,524 2,754,112 970 888,116 2,204,138 1,208,912 970 2,000 49% Sub Total 789,405 576,850 600,685 549,741 553,438 664,102 3,734,221 8,270,365 45% 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 1,658,026 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 49,870 120,800 Sub Total 211 268,916 70,730 231,622 383,215 403,463 407,220 1,765,166 7,757,696 ent of Community Investment StudebakeLVOliver 209 16,261 3,375 6,335 10,054 14,798 24,190 58,751 630,000 State Grant 210 12,200 24,311 18,003 24,096 400,000 19,293 449,495 3,694,412 DCI Operating 211 250,396 178,976 186,881 187,235 182,680 193,891 1,180,059 2,661,730 Dept, of Community Investment 212 102,720 134,503 161,537 515,770 284,129 140,658 1,339,317 5,899,970 Administration 212 183,750 365,625 50% EDIT 408 577,062 1,795,231 15,900 Programs 212 4,101 12,414 64,293 36,871 104,364 114,904 16,514 647,998 Sub Total 146,068 369,417 329,268 372,756 713,059 881,606 378,031 3,044,138 13,534,110 Garages Main Street 601 16,261 29,534 14,520 689 11,980 25,848 98,831 262,391 Leighton Plaza 601 16,812 24,311 21,634 24,096 24,047 49,754 160,653 696,570 Enforcement 601 1,340 31,872 16,253 335 8,521 13,915 72,236 89,236 Wayne Street 601 54,617 27,884 11,887 11,750 59,817 25,387 191,341 742,615 Eddy Street Commons 601 183,750 365,625 50% EDIT 408 577,062 1,795,231 15,900 Sub Total 1,034,072 89,030 113,600 64,293 36,871 104,364 114,904 523,062 1,806,712 Ce I I /Debt Service Hall of Fame 313 636,000 636,000 1,266,820 50% COIT 404 1,322,195 797,317 799,782 433,747 914,359 777,528 5,044,928 15,660,371 32% Cum Capital Development 406 112,650 56,546 135,726 56,546 361,467 542,691 67% Cum Ca ita /Improvement 407 183,750 183,750 365,625 50% EDIT 408 577,062 1,795,231 126,960 154,855 1,034,072 88,516 3,776,696 9,943,709 38% UDAG 410 146,068 146,068 438,203 33% Major Moves 412 55,859 153,529 335,865 138,115 116,706 281,960 1,082,033 3,096,061 35% Morris PAC Improvement 416 1,268 1,665 11,946 11,079 1,740 27,698 70,248 39% CRED 434 3,897 3,897 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 29,361 188,824 16% Sub Total 2,899,524 2,754,112 1,337,096 888,116 2,204,138 1,208,912 11,291,898 32,238,702 359/ Financial Report June 2015. Expenditure Summary Page 15 of 25 City of South Bend Period Ending: June 30, 2015 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun 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 113,634 81,093 297,182 27% Loss Recovery 227 181,590 298,680 822,026 396,131 555,991 84,437 2,338,854 5,237,243 45% Human Ri hts 258 22,061 9,167 26,033 11,344 12,797 29,781 111,184 247,357 45% Morris Palais Marketin 273 67,459 96 500,608 2,358 Sub Total 878 3,332 18,974 18% ProfessionalSports Development 377 480,773 800 3,056,791 Sub Total 2,019,201 481,573 855,603 56% 1201 Code Enforcement 600 120,449 101,851 94,621 183,959 101,999 106,108 708,987 2,414,485 29% 1207 Animal Control 600 57,484 47,550 49,635 42,055 56,024 53,681 306,429 696,216 44% 1306 Building Operations 600 104,444 75,646 91,217 76,910 80,817 79,524 508,558 1,094,700 46% Century Center 670 306,497 285,449 289,304 326,417 340,496 362,358 1,910,521 4,532,562 42% Century Center Capital 671 1,464,000 66,156 50,000 130,440 246,596 605,656 41% Sub Total 1,273,296 913,225 1,372,972 1,064,090 1,226,335 847,207 6,697,125 15,999,978 42% s Insurance Self Funded Liability Ins 226 26,134 26,675 14,630 19,531 15,003 11,661 113,634 282,900 Liability Insurance 226 156,054 7,585 32,230 286,937 18,509 39,921 541,237 1,184,891 Business Insurance 226 15,927 14,875 21,403 1,739 75,766 421,849 551,560 600,000 Workers Compensation 226 64,123 206,418 63,790 43,608 67,459 55,210 500,608 989,000 Sub Total 730 262,238 255,553 132,053 351,815 176,737 528,641 1,707,038 3,056,791 Trust & A enc Fire Pension 701 441,192 441,276 450,317 433,126 432764 433,366 2,632,041 5,666,579 Police Pension 702 537,112 524,012 559,034 535,159 523,172 526,174 3,204,664 6,832,235 Employee Benefits 711 1,030,771 963 626 1,093,990 1 462 313 1,140,933 973 880 6,665,513 16, 696,935 Unemployment Comp 713 10,126 5,167 9,025 7,309 10,788 5,683 48,099 226,796 Cit Cemetery Trust 730 70,421 154,716 46% TIF Medical Service 426 20,000 Sub Total 2,019,201 1,934,080 2,112,366 2,437,907 2,107,658 1,939,103 12,550,316 29,442,545 Civil City Expenditure 21,003,306 18,697,459 17,690,217 16,653,639 22,462,321 19,455,397 - - - - - - 115,962,339 302,950,834 38% Tax Increment Financing TIFAir ort 324 2,276,439 1,684,991 1,736,337 586,596 271,305 1,028,591 7,584,258 47,710,597 16% 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 70,421 154,716 46% 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 145,547 7,239,524 2% TIF Southside 430 435,370 24,431 62,420 38,892 10,969 36,484 608,566 2,842,535 21% TIF Erskine Village 432 357,545 201,724 559,269 691,380 81% TIF Douglas Road 435 169,620 169,620 345,389 49% Northeast Residential TIF 436 1,464,000 246,589 1,000 1,711,589 3,425,632 50% Sub Total 5,617,288 1,400,070 8,200,393 660,631 294,924 1,089,265 17,262,571 69,553,679 25% Financial Report June 2015. Expenditure Summary Page 16 of 25 City of South Bend Period Ending: June 30, 2015 Expenditure Report S i Fund I Jan I Feb I Mar I Apr I May Jun Jul I Aug Sep I Oct I 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 794,823 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 996,050 5,207,649 Cervlce Airport Debt Reserve 2003 315 317 227 368 594 323 1,100 2,929 5,000 Central Development reserve 328 530 379 615 993 539 1,838 4,894 6,000 Sub Total M 847 606 983 1,587 862 2,938 7,823 11,000 Financial Report June 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 - - - - - - 18,266,444 74,772,328 24% City Operations Total 26,690,496 20,187,492 25,914,635 17,720,979 22,855,017 20,860,165 - - - - - - 134,228,783 377,718,476 36% Expenditure report 26,690,496 20,187,492 25,914,635 17,720,979 22,855,017 20,860,165 0 0 0 0 0 0 134,228,783 377,718,476 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report June 2015. Expenditure Summary Page 17 of 25 City of South Bend Period Ending: June 30, 2015 Debt Schedule Yearof I Yearof Yearof Schetlulatl Payments Debt lOng/Renr Debtaf 2015Prfncipal 20151aterest 2015 Debt at 2015 Total Debt lnsWment Debt PU Issue Refuntlin Mafi Fund 1st 2ntl 3n1 4th Issue 1213112014 Pa ants Pa eat AtltllOOa 12/312015 Debt Pa rents 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 Coroomllon 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 mprovements Water Works 2002 2012 2023 625 1/1 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 2/1 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 Work s Improvements Water Works 2006 2027 625 1/1 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 Sewsoa 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 20078 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 Cenlury Canter 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 1/1 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 Sewage 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 es 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 ss 2012Water Works Revenue Bond Water Works 2012 2033 625 1/1 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 101 2012 Sewace 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 Corporation EMS / Fire Department 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 f33 St. Joseoh County PSAP St. Joseoh County PSAP 2014 2034 408 Month M 2.657.696.50 2.657.696.50 123.377.50 75.951.55 0.00 2.534.319.00 199.329.05 f39 Cenlury Center En- Savings Improvements 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 Total Bond Debt 198.532.593.50 142.609.083.50 10.352.089.50 4.865.128.83 4.167.897.00 136.424.891.00 15.217.218.33 Loans Payable ss State RevaNing 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 Sourca/Mam tt Garage 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 Revolving Fund (Refunding) Sewage Works Improvement 1998 2018 649 6/1 1211 - - 24.09 .000. 00 0.00 0.00 0.00 0.00 0.00 0.00 zs State Revolving Fund Water Works Improvements 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 Payable 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 st Chase LED Eauipment 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 200.579.66 ]2 Kansas State Bank Code Enfwcement Ow Copier 2010 2015 101 1/23 4/23 7/23 10/23 9.209.00 539.14 539.14 10.50 0.00 0.00 549.64 ]s Kansas State Bank Cenirel Be,!- Ceder 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 Ind- b- Technolagv 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 ]s Kansas State Bank Mavw 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 1.648.92 ]a Advanced Imaoina 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 s] Public Finance- Inc Solid Waste Containers /crocks 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.21067% 2.00 641.545.46 425.630.31 9.335.10 0.00 215.915.15 434.965.41 ao Capital One Public Funding Solid Waste ContainersiTrocks 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 n GE Capital Information Technolwv Police Dept Copier 2011 2016 101 1/11 4/11 7/11 10/11 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 a4 Ikon Office Solutions Mavw Ricoh MP 2851 SP Co.!., 2011 2016 101 2115 5115 8115 11/15 2.569.53 1.110.31 539.50 48.98 0.00 570.81 588.48 as Sun Trost Eauipment 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 a7 Sun Trust Eauapmont Finance Police Vehicles &Eauapmont 2012 2 1 406 5/15 11/15 - - 1.295.000.00 661.712.34 261.339.69 10.111.59 0.00 400.372.65 271.451.28 as PNC Eauipment Finance Pubic Works Vehicles Lease 2012 2 1 202/641/640 5/15 11/15 - - 945.674.38 481.717.95 190.523.14 6.535.71 0.00 291.194.81 197.058.85 0o PNC Eauipment Finance Public Works Vehicles Lease 2012 2017 202/641/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 Solutions /Ricoh Wastewater Copier 2012 2 1 641 MonihN 1st 5.744.95 3.170.10 1.172.61 149.31 0.00 1.997.49 1.321.92 pp GE Capital lnfoa t- Tachnoloov Fire Department Copier 2012 2 1 101 2/28 5/26 8/28 11/28 5.471.01 3.205.85 1.106.31 164.49 0.00 2.099.54 1.270.80 pa Ricoh USA (New) Central Services Copier 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 s] Ricoh USA StreebSewer Dept Copier 2013 2018 202/641 3/4 6/4 9/4 1214 5.559.15 3.475.34 1.092.25 178.55 0.00 2.383.09 1.270.80 as Ricoh USA ON Attwnev Cooler 2013 2018 101 2112 5/12 8112 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 & Rac Ricoh Cod -43) 2013 2018 201 2121 5121 821 1121 16.129.94 10.132.91 3.184.26 502.98 0.00 6.948.65 3.687.24 to PNC Eauipment Finance Vehide/Eauipment Lease 2013 2018 101/202/406/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 11 Ricoh USA Enaineedna Plo6er /Scanner 2013 2018 101 3/3 fi/3 9/3 12/3 10.667.67 6.790.21 2.073.34 518.66 0.00 4.716.87 2.592.00 t2 Ricoh USA Buildinq Dad. Caller 2013 2018 600 MonihN 4.093.64 3.109.92 786.76 152.24 0.00 2.323.16 939.00 fs Sun Trust Eauipment Finance Police and PW vehicles 2013 2018 404/655/611/202 424 1024 1.506.465.26 1.214.609.68 296.499.82 18.081.32 0.00 918.109.86 314.581.14 t4 Ricoh USA Adman & Finance Copier 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 Dent. Recem Div. Ricoh Police Records Copier 2013 2018 101 MonfN 3rd 9.678.26 7.950.10 1.826.18 393.82 0.00 6.123.92 2.220.00 fa Water Works Main Racah Copier Water Works Main Ricoh Cooler 2013 2018 620 MonihN 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 Copier Water Works Colfax Ricoh Cable 2013 2018 620 MonihN 16th 4.732.65 3.887.84 892.77 192.75 0.00 2.995.07 1.085.52 12o Water Works Olive Ricoh Cooler Water Works Olive Racah Cooler 2013 2018 620 MonihN 10th 4.732.65 3.887.84 892.77 192.75 0.00 2.995.07 1.085.52 2a Police Treinina Dept. Ricoh Copier Tminina Caller 2014 2019 101 MonihN 30th 4.263.00 3.714.38 796.08 187.92 0.00 2.918.30 984.00 24 PolicalPublac Works Vehicle Lease 2014 Citv Vehicles 2014 2019 Various 4/1 1011 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 Computer Lease #1 Computw Eauipmont Lease 2014 2016 MonlhN 8th 137.104.95 12d .55d.02 29.828.93 4.995.44 0.00 94.725.09 34.824.37 1z6 HP Computer Lease #2 Computer Eauapment Lease 2014 2018 201 and 620 Monffi 8th 4.000.00 3.720.95 866.48 154.00 0.00 2.854.47 1.020.48 z] HPComruterl-mse#4 Computer Eauipment Lease 2014 2018 404 Mont, 8th 5.886.15 5.461.99 1.307.57 188.47 0.00 4.154.42 1.496.04 fze HPComruterl-mse#6 Co..tar Eauipment Lease 2014 2018 201 Monffi 8th 3.755.50 3.561.10 801.62 155.50 0.00 2.759.48 957.12 za HP Computer Lease #7 Compu[w Eauarrent Lease 2014 2018 620 Monffi 8th 1.326.00 1.302.13 294.22 42.62 0.00 1.007.91 336.84 13p Solid Waste Cader Ricoh USA Coder 2014 2019 611 MonlhM 17th 5.351.65 5.351.65 1.035.84 296.27 0.00 4.315.81 1.332.11 tat Police Communications Cader 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 &Wastewater Ricoh USA Coders 2014 2019 641 MonlhM 21st 12.260.18 11.182.59 2.247.61 569.39 0.00 8.934.98 2.817.00 te4 Water Works Cader- Nadh Station Ricoh USA Caders 2014 2019 620 MonlhM 19th 4.732.65 3.960.04 888.67 196.84 0.00 3.071.37 1.085.51 tea HP Computer Lease #B Computor Eauapment Lease 2015 2019 404201/611 Monffi 16th 19.603.94 0.00 3.434.11 759.69 19.603.94 16.169.83 4.193.80 13] Animal Control Ricoh Cader Ricoh USA Caders 2015 2020 600 Monffi 30th 5.261.50 0.00 694.75 217.13 5.261.50 4.566.75 911.88 138 HP Computer Lease #9 Co-ter , Eauapmont Lease 2015 2019 Various MonlhM TBD 135.958.05 0.00 14.229.04 3.223.14 135.958.05 121.729.01 17.452.18 too Vehide &Eauap. Lease Vehids/Eauarrant 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 0.00 Total Capital Lease 20,039,664.26 9,670,744.40 3,189,935.88 164,723.33 3,586,097.07 10,088,905.59 3,354,859.21 a,- City of South Bend Period Ending: June 30, 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 Refunding Matu Fund 1st 2ntl 3n1 4th Issue 1213112014 Pa Boas Pa wit AtltllOOn 121312015 Debt Pa ments 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 Authority Bosch PropeM (NOMOrgivel 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 Brownfield 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 City of South Bend Period Ending: June 30, 2015 Monthly Debt Schedule Yearof I Yearof Yearof SchetluhM Payments Debt lOrg /Rani Debtaf YTD Pdnclpal YTD lnlenast YTD DeWitt Debt lnsWment Debt PU Issue Refuntlin Mafi w Fund 1st 2ntl 3n1 4th Issue 121312014 P.,_. Pa ants Atltli6ons I 6130/2015 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 Coroordlon 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 mprovements Water Works 2002 2012 2023 625 7/1 12/31 - - 5.975.000.00 3.100.000.00 0.00 0.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 Works Improvements Water Works 2006 2027 625 7/1 12/31 - - 4.710.000.00 3.300.000.00 0.00 0.00 0.00 3.300.000.00 42 Sewsoa 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 Sawaga 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 s2 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 s9 Water Works Improvements Water Works 2009 2030 625 7/1 12/31 - - 5.380.000.00 4.775.000.00 0.00 0.00 0.00 4.775.000.00 70 Sawa oa Works Revenue Bonds - 2009 Sawaga 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 es 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 115.243.13 0.00 7.275.000.00 101 2012 Sewage 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 16 2013 Buildino Corporation 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 Monthiv - - - 2.657.696.50 2.657.696.50 61.688.76 37.975.80 0.00 2.596.007.74 f39 Century Center En- Savings Improvements Century Cb, 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 Total Bond Debt 198.532.593.50 142.609.083.50 1.951.688.76 2.189.289.94 4.167.897.00 144.825.291.74 Loans Payable ss State Revolving Fund Water Works Improvement 2009 2030 625 7/1 12/31 - - 427.332.00 372.364.00 0.00 0.00 0.00 372.364.00 s2 Interfund Lean 410 - UDAG 1 st Sourca4Mamott 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.50 44 State Revolving Fund (ach# 1051 Sewage Works Improvement 1998 2018 649 6/1 1211 - - 24.095.000.00 0.00 0.00 0.00 0.00 0.00 zs State Revolving Fund Water Works Improvements 2000 2019 625 7/1 12/31 - - 2.600.000.00 860.913.00 0.00 0.00 0.00 860.913.00 Total Loans Payable 29.822.332.00 3.261.250.00 146.067.50 0.00 0.00 3.115.182.50 Capital Leases st Chase LED Eauipment 2007 2017 101 1/1 7/1 1.531.573.00 559.122.04 88.324.62 11.965.21 0.00 470.797.42 ]z Kansas State Bank Code Enfwcement Ow Copier 2010 2015 101 1/23 4/23 7/23 10123 9.209.00 539.14 539.14 10.50 0.00 0.00 ]s Kansas State Bank Central Be,!- Copier 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 Tach -licav 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 ]s Kansas State Bank Mavw Ow Copier 2010 2015 101 1/8 4/8 7/8 1018 9.209.00 1.586.72 1.047.58 51.70 0.00 539.14 ]a Advanced Imaging Central Services Duplicators 2010 2015 222 1/15 4/15 7/15 10115 10.511.02 2.455.77 1.200.63 97.05 0.00 1.255.14 a] Public Finance- Inc Solid Waste Containers /crocks 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 Solid Waste ContainersiTrocks 2011 2016 611 3/15 6/15 9/15 12/15 207.432.00 74.504.09 21.0 6.29 576.49 0.00 53.437.80 n GE Capital Information Technolwv Police Dept Copier 2011 2016 101 1/11 4/11 7/11 10111 3.836.00 1.275.18 412.60 31.76 0.00 862.58 az Kev Finance IT Phone Svstam 2011 2016 404 1/15 1.444.995.97 569.323.31 281.141.18 14.258.23 0.00 288.182.13 a4 Ikon Office Solutions Mavw Ricoh MP 2851 SP Copier 2011 2016 101 2115 5115 8115 11115 2.569.53 1.110.31 265.95 28.29 0.00 844.36 as Sun Trust Eauipment 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 a7 Sun Trust Eautpmont Finance Police Vehicles &Eautpmont 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 Eauipmon[Finance Public Works Vehicles Lease 2012 2 1 202/641/640 5/15 11/15 - - 945.674.38 481.717.95 94.904.49 3.624.93 0.00 386.813.46 0o PNC Eauipment Finance Public Works Vehicles Lease 2012 201] 202/641/600/288 1/15 7/15 - - 2.806.054.00 1.703.748.90 279.362.97 11.112.70 0.00 1.424.385.93 oz Ikon Office Solutions /Ricoh Wastewater Copier 2012 2 1 641 MonthN 1st 5.744.95 3.170.10 578.03 82.93 0.00 2.592.07 pp GE Capital lnfor t- Tachnoloav Fire Department Canner 2012 2 1 101 2128 5/26 8/28 11/28 5.471.01 3.205.85 545.08 90.32 0.00 2.660.77 pa Ricoh USA Central Services Gooier 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 SbeebSewer Deal Copier 2013 2018 202/641 3/4 6/4 9/4 1214 5.559.15 3.475.34 538.25 97.15 0.00 2.937.09 as Ricoh USA CiN Attar- Cooler 2013 2018 101 2112 5/12 8/12 11/12 5.559.15 3.492.63 554.91 80.49 0.00 2.937.72 o& Ricoh USA Parks & Rac Ricoh Caolers(3) 2013 2018 201 2121 521 821 1121 16.129.94 10.132.91 1.610.26 233.36 0.00 8.522.65 to PNC Eauipment Finance Vehide/Eauianent Lease 2013 2018 1011202/406/641 1/15 7/15 1.689.669.59 1.361.951.27 166.642.36 8.307.90 0.00 1.195.308.91 11 Ricoh USA Enaineedna Plotter /Scanner 2013 2018 101 3/3 6/3 9/3 1213 10.0667.67 6.790.21 1.014.60 281.40 0.00 5.775.61 12 Ricoh USA Buildinq Data. Gooier 2013 2018 600 Monffi - - 4.093.64 3.109.92 387.95 81.55 0.00 2.721.97 fs Sun Trust Eauipment Finance Police and PW vehicles 2013 2018 4041655/611/202 424 1024 1.506.465.26 1.214.609.68 147.664.79 9.625.78 0.00 1106:944.89 t4 Ricoh USA Adman & Finance Cagier 2013 2018 101 1/16 4/16 7/16 10116 11.247.97 7.565.05 1.073.33 212.29 0.00 6.491.72 n Police Deta. Racerd Div. Ricoh Police Records Copier 2013 2018 101 ManthN 3rd - - 9.678.26 7.950.10 900.49 209.51 0.00 7.049.61 fa Water Works Main Ricoh Copier Water Works Main Ricoh Cooler 2013 2018 620 MonthN 10th - - 5.647.50 4.639.36 525.34 122.36 0.00 4.114.02 f& Water Works Colfax Ricoh Copier Water Works Colfax Ricoh Conte 2013 2018 620 MonthN 16th - - 4.732.65 3.887.84 440.23 102.53 0.00 3.447.61 12o Water Works Olive Ricoh Cooler Water Works Olive Rtcah Cooler 2013 2018 620 MonthN 10th - - 4.732.65 3.887.84 440.23 102.53 0.00 3.447.61 2a Police Train no Dept. Ricoh Cagier Tminina Copier 2014 2019 101 MonthN 30th - - 4.263.00 3.714.38 392.48 99.52 0.00 3.321.90 24 Kev Goverment Finance 2014 City Vehicles 2014 2019 4/1 1011 - - 1.959.485.95 1.959.485.95 189.211.09 15.187.18 0.00 1.770.274.86 125 HPCombutsr Lease #1 Comonter Eauipment Lease 2014 2018 MonlhN 8th - - 137.104.95 124.554.02 14.746.98 2.665.20 0.00 109.807.04 1ze HP Computer Lease #2 Coa nutty Eauarr ent Lease 2014 2018 201 and 620 MonlhN 8th - - 4.000.00 3.720.95 428.23 82.01 0.00 3.292.72 z] HP Computer Lease #4 Coa nutty Eauipment Lease 2014 2018 404 MonlhN 8th - - 5.886.15 5.461.99 647.46 100.56 0.00 4.814.53 fze HPComputer Lease#6 Co..tar Eauipment Lease 2014 2018 201 MonlhN 8th - - 3.755.50 3.561.10 395.95 82.61 0.00 3.165.15 za HP Computer Lease #7 Comu der Eauarr ent Lease 2014 2018 620 MonlhN 8th - - 1.326.00 1.302.13 144.79 23.63 0.00 1.157.34 13p Solid Waste Career Ricoh USA Copier 2014 2019 611 MonlhN 17th - - 5.351.65 5.351.65 549.96 167.33 0.00 4.801.69 131 Police Communications Career Ricoh USA Carter 2014 2019 101 MonlhN 12th - - 8.843.00 8.196.86 795.50 220.42 0.00 7.401.36 13z Organic Resources &Wast --ter Ricoh USA Carters 2014 2019 641 MonlhN 21st - - 12.260.18 11.182.59 1.108.10 300.40 0.00 10.074.49 fe4 Water Works Career -Nodh Station Richo USA Carters 2014 2019 620 MonlhN 19th - - 4.732.65 3.960.04 438.21 104.55 0.00 3.521.83 tea HP Computer Lease #B Computer Eauipment Lease 2015 2019 404201/611 MonlhN 16th - - 19.603.94 0.00 1.356.37 321.15 19.603.94 18.247.57 13] Animal Control Ricoh Career Ricoh USA Careers 2015 2020 600 MonlhN 30th - - 5.261.50 0.00 228.21 75.75 5.261.50 5.033.29 138 HP Computer Lease #9 Computer Eauapmont Lease 2015 2019 Various MonlhN TBD - - 135.958.05 0.00 0.00 0.00 135.958.05 135.958.05 too Vehide &Equip. Lease Vehide/Eauarrent 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 Total Ca Ital Lease 20.039.664.26 9.670.744.40 1.722.972.72 1 94.328.84 3.586.097.07 11.533.868.75 Total CN#Clfy 248.394.589.76 155.541.077.90 3.820.728.98 1 2283.618.78 7.753.994.07 159.474.342.99 City of South Bend Period Ending: June 30, 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 w Fund 1st 2ntl 3n1 4th Issue 12131/2014 P.,_. Pa enfs Atltlifions 1 613012015 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 0.00 0.00 3,010,000.00 5 Downlonn 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 310.000.00 70.772.50 0.00 2,605,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 3.900.571.37 1.837.693.41 25.000.000.00 97.273.333.35 Loans Payable 3 Indiana Development Finance Authority Bosch Property (Nonfagive) 2001 2021 210 3/22 6/22 9/22 12/22 1.040.000.00 423.620.93 29.759.08 6.246.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 Imertund 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.51 .259.50 45238.41 15.132.60 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 Capffal 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.379.721.98 2.014.654.20 25.000.000.00 1 105.557.522.33 City of South Bend Staffing Headcount Summary Budget Full Time I Jan Feb I Mar I Apr I May Jun I Jul 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 0.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 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report June 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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.00 0.00 QWO 0.00 0.00 0.00 Financial Report June 2015 - Headcount Staffing Page 23 of 25 City of South Bend Staffing Headcount Part Time Staff Financial Report June 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 0.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 0.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 0.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 0.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 0.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 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 Administration 5.00 5.00 5.00 4.00 4.00 4.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 3.00 3.00 4.00 7.00 12.00 13.00 0.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 0.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 0.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 0.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 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 Engineering 3.00 3.00 3.00 3.00 3.00 2.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 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 0.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 0.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 0.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 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report June 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 0.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 0.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 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 11.00 10.00 9.00 16.00 35.00 32.00 0.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 0.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 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 Police 27.00 27.00 27.00 27.00 27.00 39.00 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 Engineering 4.00 4.00 5.00 5.00 10.00 10.00 0.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 0.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 0.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 0.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 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report June 2015 - Headcount Staffing Page 25 of 25