Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
03-2014 Financial Report
Period Ending: Issued BY: March 2014 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 -15 Property Tax Revenue Collection Status Expenditures 16 -20 Expenditures by Fund and Department Debt 21 -22 Debt Status Debt Monthly 23 -24 Current Debt at Month End Headcount 25 -28 Staffing Levels Distribution Mayor Deputy Mayor Chief of Staff Deputy Chief of Staff Controller City Finance Director Financial Specialist Senior Department Heads Fiscal Officers City Common Council Pete Buttigieg Mark Neal Kathryn Roos Brian Pawlowski John Murphy Rahman Johnson Cecil Eastman Financial Report March 2014 Page 1 of 28 March 2014 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 15 %. In comparison, the collected revenue amount for March 2013 was 15% overall of budgeted revenues. Revenue type 344 (State Grants), has reached 100% of its budgeted revenue. This is 911 revenue received by the county. This was formerly in the general fund and is now in fund 244 the Telephone Emergency System. Also, revenue type 350 (Job Target Penalty Fee) has reached 100% of its budgeted revenue. This is money received from AJ Wright for penalties due to the City. Revenue by fund As of March 2014, the general fund has received 6% of its budgeted revenue versus 8% last year. In 2013, the City made an early quarter transfer from the Public Safety LOIT fund to the general fund. This quarterly transfer was in the amount of $1,775,439.25 and was made in January 2013. Some following funds have reached 50% of their 2014 budgeted revenue amount: Fund 642 (Sewage Capital) is at 112% of its budgeted revenue. In January, a transfer from fund 641 was made for capital projects. Also in January, a transfer was made from fund 641 (Sewage Works Operations) to fund 643 (Sewage Reserve) per city policy. Fund 244, the Telephone Emergency System has reached 100% of its budgeted revenue. This is 911 revenue received by the county. This was formerly in the general fund. Property taxes Property taxes are received in June and December. Information on property taxes payable in 2014 will be available in the coming months. Total property taxes collected for the year 2012 was $72.9 million or 91.56% of the levy collection rate. For 2013, the projected levy collection rate is 95 %. The first distribution amount received was in June 2013 for $38.4 million compared to $39.5 million in June 2012. The second distribution amount was received in December 2013, in the amount of $31.5 million compared to $33.3 million in December 2012. Specifically, in 2013 the City of South Bend received a total of $45,189,966.17 in property tax revenue in the civil city funds (general fund, parks, College Football Hall of Fame, and CCD). This is a shortfall of -$3.7 million compared to 2012, in which $48.8 million was received. For TIF funds, the City received a total of $24,790,321.99 in property tax revenue. This is a surplus of $729,194 as compared to 2012, in which $24,061,128 was received. Overall, total property taxes collected in 2013 is -$70.0 million, which is a net reduction of $2.9 million from 2012. Information on property taxes payable in 2014 will be available in the coming months. Expenditures As of March 2014, the City has spent 18% of budgeted expenditures, similar to 18% of budgeted expenditures in March 2013. The General Fund has spent 24% of its 2014 budgeted expenditures, also similar to 24% in 2013. 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), and fund 432 (TIF - Erskine Village). Debt In March, several debt service payments were made in the amount of - $510,000 to Sun Trust Capital One Public Funding, 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 March, 2014 was 1,106 vs. a budgeted amount of 1,160. Currently, there are a total of 54 open positions. The open positions are in Parks (20), Public Safety (15), Public Works (9), Code Enforcement and Animal Control (5) and other (5). City of South Bend Period Ending: March 2014 Revenue by Type Report S Fund Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Bud et of Bud et Property Tax 312 Auto Excise Tax various 311 Pro a Tax Civil City various 2,504,793 0% 312 Commercial Vehicle Tax van.ous 45,307,800 0% 311 Pro a Tax TIF Districts various 312 Financial Institutions Tax van.ous 101 26,325,126 0% 311 Pro a Tax Civil City - Prior various 656,725 1,313,436 0% 317 Hotel Motel Tax Century Center 420 NA 311 Property Tax TIF Districts - Prior various 0% 317 Hotel Motel Tax Cum Cap Im ry 407 337,414 150,000 NA xxx xxx xxx 101 666,334 2,600,000 NA xxx xxx NA Sub Total 6611623 NA xxx xxx xxx 71,632,926 0% Income Tax 342 EMS County Contract 101 136,239 136,239 136,239 1,588,824 0% xxx xxx 315 Econ Development Income Tax -Prh 102 222 109,590 NA Sub Total xxx NA 315 Econ Development Income Tax 408 733,068 733,068 733,068 2,199,205 8,796,821 25% 316 Local Option Income Tax -PS 249 531,669 531,669 531,669 1,595,007 6,380,029 25% 316 County Option Income Tax 404 720,484 720,484 720,484 2,161,453 8,645,811 25% 316 County Option Income Tax -Prior Yr 102 8,365,608 26,031,652 32% 395 Employee Benefits various NA Sub Total 1,985,222 1,985,222 1,985,222 5,955,665 23,822,661 25% St Joseph Count Remitted b 312 Auto Excise Tax various decal Drug 2,504,793 0% 312 Commercial Vehicle Tax van.ous 241,463 882,628 0% 312 Financial Institutions Tax van.ous 101 NA 317 Hotel Motel Tax Century Center 670 656,725 1,313,436 0% 317 Hotel Motel Tax Century Center 420 4,533,175 401,000 0% 317 Hotel Motel Tax Cum Cap Im ry 407 337,414 150,000 0% 335 Liquor Excise tax 101 666,334 2,600,000 NA xxx xxx xxx 55,845 6611623 NA xxx xxx xxx 66,547 113,592 NA 342 EMS County Contract 101 136,239 136,239 136,239 1,588,824 0% xxx xxx xxx 222 109,590 NA Sub Total xxx 136,239 792,964 136,239 1,065,442 6,840,681 16% State of Indiana (Remitted by) 312 CREED Tax 434 decal Drug 299 226 335 Cigarette Tax 1011407 241,463 75,000 ite Drug 335 State Pension Subsidy 7011702 101 335 CTP Distribution 439 various 377,765 377,765 335 Gaming Proceeds 101 4,533,175 ntractual Service 211 335 Gasoline Tax 2021251 337,414 362,053 381,987 335 Liquor Excise tax 101 666,334 2,600,000 38,577 335 Liquor Gallonage Tax 101 55,845 6611623 46,909 335 Prof Sports Development Tax 377 66,547 113,592 K 335 Century Center 671 192,354 582,059 2,545,960 335 Wheel Tax 202 222 109,590 74,990 xxx xxx xxx 25,841,975 27% 380 Internal Service Reimbursement Sub Total 138,730 459,805 585,235 495,555 governmental Sources decal Drug 299 226 235,157 235,157 241,463 75,000 ite Drug 216 340 General Government Misc Ch s 101 35,000 yment in Lieu of Tax various 377,765 377,765 377,765 1,133,295 4,533,175 ntractual Service 211 13,419 11,183 29,006 53,609 198,800 nds various 666,334 2,600,000 26% 349 Central Service 21,000,000 nd premium 6611623 46,909 143,585 619,002 23% 380 Central Service K XXX 185,484 192,354 582,059 2,545,960 23% b Total 222 391,184 388,948 406,771 1,186,904 25,841,975 Charge for Service Internal City 340 Liability Insurance 226 235,157 235,157 241,463 711,777 2,859,690 25% 340 General Government Misc Ch s 101 160 160 NA 340 Police Take Home Vehicle 278 7,160 4,730 4,640 16,530 60,580 27% 342 EMS Capital 288 151,160 281,678 233,496 666,334 2,600,000 26% 349 Central Service 222 47,661 49,015 46,909 143,585 619,002 23% 380 Central Service 222 204,221 185,484 192,354 582,059 2,545,960 23% 380 Energy Office Reimbursements 222 417,066 432,016 417,491 1,266,573 4,632,222 27% 380 Internal Service Reimbursement various 138,730 122,721 267,168 528,620 2,156,750 25% 392 Administration Fee 101 289,249 289,249 289,249 867,747 3,470,989 25% 392 Internal Fund Transfers various 4,314,974 1,011,355 3,039,278 8,365,608 26,031,652 32% 395 Employee Benefits various 946,856 995,209 1,002,625 2,944,691 13,621,548 22% Financial Report March 2014 - Revenue Report Page 3 or28 City of South Bend Revenue by Type Report Period Ending: March 2014 S Fund Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Bud et of Bud et 396 Central Service Refunds 222 1,763 1,798 3,561 22,000 16% 396 Self Funded Employee Benefits 711 11,182 11,182 NA xxx xxx xxx NA Sub Total 6,753,998 3,608,413 5,746,016 16,108,427 58,620,393 27% 3rd Party Revenue 331 Federal Grants various 186,142 152,888 51,992 340 No EMS Service 101 9% 28,006 28,006 90,000 31% 340 Memorial Hospital Neo Natal 101 40,938 39,124 35,592 115,654 365,000 32% 350 Job Target Penalty Fee 408 354,660 NA 354,660 354,660 100% 364 Cable TV Franchise Fees 101 180,787 180,787 750,000 24% 366 AT&T Franchise Fees 101 55,613 55,613 202,000 28% 380 Loss Recovery 227 NA 380 Bosch Reimbursement/ DCI 324 NA Sub Total 40,938 630,184 63,598 734,720 1,761,660 42% Grants 331 Federal Grants various 186,142 152,888 51,992 391,022 4,518,787 9% 334 State Grants various 215,000 215,000 215,000 100% 360 UDAG 410 NA xxx xxx NA Sub Total 401,142 152,888 51,992 606,022 4,733,787 13% Fees foi 320 321 321 322 322 322 322 341 342 342 343 344 344 344 344 344 346 346 346 347 347 347 349 349 349 349 351 352 354 360 360 360 360 360 360 360 360 360 360 360 360 360 360 Financial Report March 2014 - Revenue Report Page 4 028 City of South Bend Period Ending: March 2014 Revenue by Type Report S Fund Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Bud et of Bud et 360 Fire 701 NA 360 Police Pension Fund 702 8,245 eter Hydrant Reimbursement 620 4,000 0% 360 General Government Various 101131226 oceeds F.A. Disposal 36,377 803 37,180 1,100 3380% 360 P -Card Commissions 101 12,000 hicle Damage Reimbursement 80,000 0% 360 General SBCDA Account 420 1,000 K XXX NA 360 Hall of Fame 3131677 11,797 11,421 23,218 34,500 NA 360 Motor Vehicle Highway 202 NA 360 Motor Vehicle Highway Scrap Meta 202 4,000 0% 360 Motor Vehicle Highway Curb Pr gm 202 6,563 8,579 4,684 19,826 25,000 79% 360 Parking Garage Fund 601 275 78 353 NA 360 ProfessionalSports Development 377 34,608 34,608 74,228 47% 360 Solid Waste Fund 610 1,000 0% 360 Waste Water 6411719 2,621 2,611 5,321 10,554 24,620 43% 360 Sewage Depreciation Fund 642 NA 360 Streets Scrap Metal Sale 101 NA 360 Water Works Utility 620 31,554 846 58 32,458 39,580 82% 362 General Fund 101 NA 362 Dept. Of Community Investment 212 1,847 1,847 NA 362 Palais Royale 101 2,490 990 1,848 5,328 84,000 6% 362 Parks & Recreation 201 1,329 2,226 5,680 9,235 43,900 21% 362 S Bend School Corp Fee 407 25,000 0% 362 TIF Property various 14,675 17,473 10,973 43,121 201,951 2191 362 UDAG 410 NA 369 Memorial Hosp Leighton Plaza 408 150,000 0% 371 Century Center Fees 670 90,135 146,746 129,551 366,432 3,031,462 12% 399 Bosch Retention Project 210 58,203 0% 399 Principal on Loan various 19,196 21,428 1,967 42,591 195,349 22% 399 Principal Income xxx 186,218 41,443 227,661 556,798 41% xxx xxx xxx NA Sub Total 4,937,828 5,353,133 5,089,003 15,379,963 70,123,276 2291 ome nit Account Interest various 32,479 87,965 108,404 228,848 992,030 K XXX K XXX b Total 32,479 87,965 108,404 228,848 992,030 I Contribution 101 330,000 nations van.ous 268 22,291 62 22,621 32,740 K XXX b Total 268 22,291 62 22,621 362,740 enervation lais 450 1,796 334 125 2,255 16,000 �neral Fund 101 - - - - - - - - - - - - - - K XXX b Total 1,796 334 125 2,255 16,000 ets 4201324 8,245 8,245 eter Hydrant Reimbursement 620 11,797 3,176 14,973 20,000 oceeds F.A. Disposal 600 1,500 le of Fixed Assets van.ous 12,000 hicle Damage Reimbursement various 1,000 K XXX b Total 11,797 11,421 23,218 34,500 Revenue Total 15,140,898 13,619,374 14,094,408 - - - - - - - - - 42,854,680 287,194,697 1511 report 15,140,898 13,619,374 14,094,408 42,854,680 287,194,697 Financial Report March 2014 - Revenue Report Page 5028 City of South Bend Revenue by Fund Report Period Ending: March 2014 s % 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 831,705 1,001,393 800,251 2,633,349 51,660,458 5% 0101 Mayor 101 227 151 35 413 600 69% 0104 311 Call Center 101 26,509 109,227 135,736 480,077 28% 0201 Clerk 101 NA 0301 Common Council 101 41 27 27 95 8,300 1% 0401 Controller 101 80,050 0% 0501 Legal 101 15 1,044 8 1,066 72,350 1% xxx xxx NA Sub Total 858,496 1,002,615 909,548 2,770,659 52,301,835 5% Public Works 0600 Energy Office 101 NA 0602 Engineering 101 115 115 6,100 2% 0606 Building Maintenance 101 NA 0607 Traffic & Lighting 101 NA xxx xxx NA Sub Total 115 115 6,100 2% Public Safety 0801 Police 101 38,053 30,089 10,162 78,304 337,700 23% 0802 Police Communications 101 NA 0805 Police -PS LOIT funded 101 NA 0901 Fire 101 41,063 39,253 63,964 144,280 1616,000 9% 0905 Fire-PS LOIT funded 101 NA Sub Total 79,116 69,341 74,126 22Z584 1,953,700 11 % Code Enforcement 1201 Code 101 NA 1203 Code Hearing 101 NA 1204 Code Junk Vehicle 101 NA 1205 Code Unsafe Building 101 2 150 2 150 4,300 NA 1207 Code Animal Control 101 NA xxx xxx NA Sub Total 2,150 2,150 4,300 NA Arts 8 Culture 0404 Morris PAC 101 56,152 47,987 141,683 245,821 882,000 28% 0405 Palais Royale 101 29,101 7,384 7,641 44,126 309,981 14% xxx xxx NA Sub Total 85,253 55,371 149,324 289,947 1,191,981 24% Human Rights 1008 Human Rights 101 NA xxx xxx NA Sub Total NA General Fund Revenue Total 1,025,130 1,127,327 1,135,147 - - - - - - - - - 3,287,605 55,453,616 6% Financial Report March 2014 - &p-dk- Summary Page 6 of 28 City of South Bend Revenue by Fund Report Period Ending: March 2014 a % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sap I Oct Nov Dec I Year I Budget I of8ud et Parks & Recreation 0000 Parks General revenue 201 61,214 62,071 62,107 185,392 8,770,213 2% 1100 Administration 201 1,551 2251 5,730 9,532 45,750 21% 1101 Maintenance 201 6,893 7,305 7,508 21,706 299,000 7% 1102 Golfo erations 201 2,568 71,543 11,607 80,582 1,582,000 5% 1103 Recreation Division 201 18,881 13,633 7,265 39,779 184,140 22% 1104 Potawatomi Zoo 201 265 34 299 NA 1106 Potawatomi Greenhouse 201 NA 1107 Community Svc Block Grant 201 NA 1108 Grafd Removal 201 6,464 6,425 3,296 15,185 99,304 16% Recreation Non Reverting 203 76,057 104,016 91,333 271,406 1,449,592 19% East Race Waterway 271 2 5 7 14 100 14% Coveleski Stadium 401 3 10 13 27 500 5% Zoo Endowment 403 6 18 24 49 2900 2% Park Non Reverting 405 79 7,670 443 8,191 195,700 4% xxx x xxx NA Sub Total 168,582 275,212 189,369 633,163 12,629,199 5% Public Works Motor Vehicle Ni hway 202 285,523 416,631 384,110 1,086,264 9,106,300 12% Central Services 222 670,844 738,759 669,859 Z079,462 7,847,374 26% Local Roads & Streets 251 87,148 91,181 93,475 271,804 1,088,000 25% Protect ReLeaf 655 36,373 36,471 36,737 109,581 431,700 25% xxx xxx xxx NA Sub Total 1,079,887 1 283 043 1,184,182 3 547,112 18,473,374 19% Public Works Solid Waste Solid Waste Operations 610 400,585 396,447 396,179 1,193,211 5,257,701 23% Solid Waste Capital 611 230,437 27 80,040 310,504 736,202 42% xxx x xxx NA Sub Total 631,022 396,474 476,219 1,503,715 5,993,903 25% Public Works Water Utility 0000 Water Works Revenues 620 863,045 1,048,116 935 227 2,846,388 12 655,313 22% 0630 Water Leak Insurance 620 80,687 80,448 80,578 241,714 960,000 25% 0640 Water Works 620 NA 0660 Clay Water 620 74,439 74,966 75,443 224,848 1,096,020 21% Waterworks Capital 622 453 1,296 1,756 3,504 10,000 35% Waterworks Construction 623 223 296 311 829 5,000 17% Waterworks Deposit 624 186 534 724 1,444 6,000 24% Waterworks Sinking 625 171,006 170,846 170,967 512820 2,057,224 25% Waterworks Bond Reserve 626 8,761 9,130 9,337 27,229 90,073 30% Waterworks Debt Reserve 629 261 54,253 1,021 55,534 70,312 79% xxx xxx xxx NA Sub Total 1,199,062 1,439,885 1,275,364 3,914,310 16,949,942 23% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 47,833 46,355 48,966 143,154 549,200 26% 0000 Wastewater Revenues 641 2,517,238 2,480,217 2,496,145 7,493,600 32,588,386 23% 0621 Sewer Department 641 2,000 0% 0625 Concrete Crew 641 4,008 4,376 6,385 14,769 47,000 31% 0630 Wastewater Operations 641 NA 0631 Organic Resources 641 NA 0650 Clay Sewage 641 153,599 152,617 158,751 464,967 1,915,802 24% Sewage Ca ital 642 2,000,563 1,522 2,002,341 4,004,427 3,566,580 112% Sewage Reserve 643 130,386 1,221 1,702 133,310 238,715 56% Sewer Bond 200612006 645 NA Sewer Bond 2007 647 1 0 1 2 NA Sewage Bond Sinking 649 775,028 775,371 775,900 2,326,299 9,804,645 24% Clay Sewage General 650 NA Sewage Bond 2007 651 NA Sewage Works DS Reserve 653 NA 2010 CSO Net Sewer Bond 658 0 1 1 2 NA 2011 Sewer Bond 659 1,034 2810 3,709 7,553 25,000 30% 2012 Sewer Bond 661 2372 6,686 8,940 17,998 45,000 40% 2013 Sewer Bond 663 60,000 0% 2013A Sewer Refund Bonds 664 1 2 2 4 NA 2014 Sewer Bond 665 21,000,000 0% Sub Total 5,632,063 3,471,179 5,502844 14,606,085 69,842,328 21% Financial Report March 2014 - &p-dk- Summary Page 7 of 28 City of South Bend Revenue by Fund Report Period Ending: March 2014 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 Bud et I ofeud et Public Safe - Police 601 0460 Main Street 601 0462 Leighton Plaza 601 0463 Enforcement 601 Police Seizures 216 20 58 79 157 35,900 0% Curfew Violations 218 14 39 83 136 1,025 13% Law Enforcement Education 220 30,247 12,673 17,643 60,562 211,000 29% Public Safety LOIT 249 531,895 532,362 532,719 1,595,977 6,391,029 25% Excess Welfare Public Safety 252 0 0 1 1 NA Police Take Home Vehicle 278 14,378 9,629 9,407 33,413 123,160 27% Police Block Grant 280 0 1 2 4 NA Police Grants 292 66,716 66,716 NA Pnli-Academy 294 13,159 4,127 41 17,327 22,000 79% COPS More Grants 295 863 992 957 2,812 41,600 7% Drua Enforcement 299 91 81 73 245 77,000 0% K -9 Unit 705 0 1,000 1 1,002 2,000 50% xxx xxx Sub Total xxx 657,384 560,963 561,005 1,779,353 6,904,714 NA 26% Publie Safe - Fire enc Tele hone S stem 244 215,000 215,000 215,000 100% a ital U 288 154,587 286,614 238,953 680,154 2,661,000 26% t 289 2 6 8 16 10.000 0% River Rescue 291 Z412 Z435 7,249 12 096 45,200 27% xxx xxx xxx NA Sub Total 372,001 289,056 246,209 907,266 2,931,200 31 Department of Communi Investment Studebaker /Oliver 209 139 398 539 1,076 305,000 0% State Grant 210 85 128 174 387 77,016 1% DC/ Operating 211 435,848 11,776 40,226 487,850 Z278,246 21 0000 Dept of Community Investment 212 125,073 158,522 95,663 379,258 3,811,000 10% xxx Programs 212 NA 0000 Economic Revenue Bond 281 3 10 14 27 NA xxx xxx xxx NA Sub Total 561,149 170,834 136,615 868,597 6,471,262 13% 0000 Parking Garage Revenue 601 0460 Main Street 601 0462 Leighton Plaza 601 0463 Enforcement 601 0464 Wayne Street 601 0465 Eddy Street Commons 601 xxx xxx xxx Financial Report March 2014 - &p-dk- Summary Page 8 of 28 City of South Bend Revenue by Fund Report Period Ending: March 2014 a 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 I of8ud et Other Miscellaneous Rain Da 102 1,105 3,164 4,289 8,557 52,000 16% Gift Donation Be nest 217 10 21,140 38 21,188 7,290 291 Loss Recove 227 1,018 2,913 3,945 7,876 17,000 46% Human Ri hts 258 89 4,817 9,168 14,074 210,700 7% Morris Palais Marketing 273 354 3,005 542 3,901 8,100 48% Professional Sports Development 377 101,255 113,844 299 215,399 678,228 32% 1201 Code Enforcement 600 585,873 8,041 13,979 607,894 2,596,460 23% 1207 Animal Control 600 5,770 4,102 4,463 14,335 57,000 25% 1306 Building Operations 600 80,574 51,956 84,261 216,791 1,159,100 19% Century Center 670 101,443 830,395 167,457 1,099,295 4,564,898 24% Century Center Capital 671 30 57 87 100,500 0% xxx xxz xxx NA Sub Total 877,520 1,043,378 288,498 2,209,397 9,451,276 23% Business Insurance 0000 Business Insurance Revenues 226 235,841 273,423 244,661 753,925 2,881,690 26% 0403 Self Funded Liability Ins 226 - - - - - - - - - - - - - - NA 0412 Liability Insurance 226 - - - - - - - - - - - - - - NA 0417 Business Insurance 226 - - - - - - - - - - - - - - NA 0418 Workers Compensation 226 17,000 0% xxx xxx xxx NA Sub Total 235,841 273,423 244,661 753,925 Z898,690 690 26% Trust Fiduc- Trust & A enc Fire Pension 701 157 330 223 711 5391,332 0% Police Pension 702 261 614 539 1,415 6,310,000 0% Police / Fire Pension 703 NA Employee Benerits 711 939 099 988 883 1 008 404 2 936,386 13 418,450 22% Unemployment Comp 713 8,564 8,625 8,658 25,847 236,898 11 Cemtery Trust 730 5 14 18 37 250 15% xxx xxx xxx NA Sub Total 948,086 998,466 1,017,843 2 964,395 25 356,930 12% Civil City Revenues 15,022,977 13,469,813 13,985,515 - - - - - - - - - 42,478,306 256,637,317 17% Tax Increment Financing ort 324 2,853 9,393 12,246 24,493 13,484,612 0% tr al Develo ment 420 30,402 30,591 15,776 76,769 4,418,336 2% st Washin ton 422 58 225 305 588 422,000 0% hton Plaza 425 9,940 15,407 12,374 37,721 164,303 23% UTIFAirport dical Service 426 371 1,141 1,524 3,036 1,615,000 0% heast 429 349 1,104 1,497 2,950 827,000 0% uthside 430 402 1,246 1,669 3,317 3,615,000 0% kine Commons 431 NA kineW a a 432 762 2,277 3,012 6,051 15,000 40% u /as Road 435 23 108 147 278 320,750 0% Northeast Residential TIF 436 244 920 502 1,666 2,510,000 0% xxx xxx xxx NA Sub Total 45,404 62,412 49,053 156,870 27,392,001 1% Financial Report March 2014 - &p-dk- Summary Page 9 of 28 City of South Bend Revenue by Fund Report Period Ending: March 2014 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 Bud et I of Bud et Redevelo ment Funds Central Bond Proceeds 305 NA District Capital 2003 428 NA Administration 433 3 9 10 22 NA Coveleski Bond Construction 438 NA Certified Technology Park 439 472 1,352 1,833 3,657 1,453,000 0% Airport Urban Enterprise Zone 454 48 138 187 374 1,500 25% Blackthorn Golfo erations 619 71,571 84,446 56,179 212,195 1,696,879 13% xxx xxz xxx NA Sub Total 72,094 85,944 58,208 216,247 3,151,379 7% Debt Service Public Improvement 1990 314 - - - - - - - - - - - - - - NA Airport Debt Reserve 2003 315 133 381 517 1,031 5,000 21% Coveleski Bond Debt Reserve 317 65 185 251 500 3,000 17% Blackthorn Debt Service 319 NA Central Development reserve 328 223 637 863 1,723 6,000 29% xxx x xxx NA Sub Total 420 1,203 1,631 3,254 14,000 23% Redevelopment Commsssion 117,919 149,560 108,892 - - - - - - - - - 376,371 30,557,380 1% City Operations Total 15,140,896 13,619,373 14,094,408 - - - - - - - - - 42,854,677 287,194,697 15% Revenue report 15,140,898 13,619,374 14,094,408 42,854,680 287,194,697 2 0 0 0 0 0 0 0 0 0 0 0 2 0 Financial Report March 2014 - Expenditure Summary Page 10 of 28 City of South Bend Property Tax Revenue 2012 Tax Pay 2013 Fund Period Ending: March 2014 Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy Per County Collection Projected 61412013 611712013 1212312013 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Receivable Rate Citv Airport TIF District General Fund 101 38,369,939.03 0.95 36,451,442.08 13,051,204.28 6,798,591.66 16,401,600.74 36,251,396.68 2,118,542.35 94.48% Parks & Recreation 201 7,623,780.24 0.95 7,242,591.23 2,593,163.21 1,350,822.26 3,263,074.28 7,207,059.75 416,720.49 94.53% College Football Hall of Fame 313 1,341,607.54 0.95 1,274,527.16 - 693,822.13 574,356.46 1,268,178.59 73,428.95 94.53% Cumulative Capital District 406 490,121.50 0.95 465,615.43 166,710.61 86,842.35 209,778.19 463,331.15 26,790.35 94.53% Fire Pension 701 - 0.95 - - - 2,618,580.97 - - - Police Pension 702 214,165.13 0.95 Erskine Commons TIF District #2 431 0.95 - - Total - City - 47,825,448.31 Erskine Village TIF District #3 45,434,175.89 15,811,078.10 8,930,078.40 20,448,809.67 45,189,966.17 2,635,482.14 94.49% Tax Increment Financinq Airport TIF District 324 15,275,702.92 0.95 14,511,917.77 7,111,555.29 6,228,798.58 13,340,353.87 1,935,349.05 87.33% South Bend Central TIF District 420 3,761,712.00 0.95 3,573,626.40 1,705,490.58 885,317.48 2,590,808.06 1,170,903.94 68.87% West Washington TIF District 422 584,897.07 0.95 555,652.22 264,689.94 228,918.51 493,608.45 91,288.62 84.39% Central Medical TIFDistrict 426 2,128,725.48 0.95 2,022,289.21 613,184.76 608,491.41 1,221,676.17 907,049.31 57.39% Northeast Residential TIF District 436 2,607,578.70 0.95 2,477,199.77 1,340,027.53 922,737.17 2,262,764.70 344,814.00 86.78% Southside TIF District # 1 430 2,618,580.97 0.95 2,487,651.92 1,381,537.24 1,022,878.60 2,404,415.84 214,165.13 91.82% Erskine Commons TIF District #2 431 0.95 - - - - Erskine Village TIF District #3 432 1,319,469.76 0.95 1,253,496.27 659,734.88 651,393.90 1,311,128.78 8,340.98 99.37% Douglas Road TIF District 435 322,082.97 0.95 305,978.82 164,167.82 159,770.93 323,938.75 (1,855.78) 100.58% Northeast TIF 429 1,152,857.67 0.95 1,095,214.79 431,978.67 409,648.70 841,627.37 311,230.30 73.00% Airport Urban Enterprise Zone 454 0.95 - - - - - Other xxx 0.95 - Total - Tax Increment Financing 29,771,607.54 28,283,027.16 13,672,366.71 11,117,955.28 24,790,321.99 4,981,285.55 83.27% Grand Total 77,597,055.85 73,717,203.06 15,811,078.10 22,602,445.11 31,566,764.95 69,980,288.16 7,616,767.69 90.18% State Board 2010 Audit Fee Revised Total 77,597,055.85 73,717,203.06 15,811,078.10 22,602,445.11 31,566,764.95 69,980,288.16 7,616,767.69 90.18% Note(s) 1 Distribution 1 - 2 Distribution 2 - 3 Distribution 3 - x Financial Report March 2014 - Property Tax Revenue Page 11 of 28 City of South Bend Property Tax Revenue i1 Tax Pay 2012 Fund Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy Per County Collection Projected 61112012 612212012 1212812012 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Receivable Rate Cit General Fund 101 42,159,959.10 0.95 40,051,961.15 14,149,210.75 7,476,750.77 17,742,469.36 39,368,430.88 2,791,528.22 93.38% Parks & Recreation 201 8,374,886.47 0.95 7,956,142.15 2,810,677.15 1,485,222.94 3,528,156.04 7,824,056.13 550,830.34 93.42% College Football Hall of Fame 313 859,959.09 0.95 816,961.14 - 622,017.06 511,188.06 1,133,205.12 (273,246.03) 131.77% Cumulative Capital District 406 554,158.31 0.95 526,450.39 185,979.85 98,275.80 233,454.74 517,710.39 36,447.92 93.42% Fire Pension 701 - 0.95 - - - - - - Police Pension 702 0.95 Total - City 51,948,962.97 49,351,514.82 17,145,867.75 9,682,266.57 22,015,268.20 48,843,402.52 3,105,560.45 94.02% Tax Increment Financing Airport TIF District 324 12,266,234.17 0.95 11,652,922.46 6,111,684.64 5,519,602.49 11,631,287.13 634,947.04 94.82% South Bend Central TIF District 420 3,781,492.40 0.95 3,592,417.78 1,909,554.48 1,761,923.84 3,671,478.32 110,014.08 97.09% West Washington TIF District 422 483,719.73 0.95 459,533.74 225,083.13 197,631.37 422,714.50 61,005.23 87.39% Central Medical TIFDistrict 426 3,668,649.86 0.95 3,485,217.37 876,400.86 730,513.97 1,606,914.83 2,061,735.03 43.80% Northeast Residential TIF District 436 2,542,578.19 0.95 2,415,449.28 1,252,274.84 1,261,773.08 2,514,047.92 28,530.27 98.88% Southside TIF District #1 430 2,608,924.21 0.95 2,478,478.00 1,337,317.29 1,128,885.46 2,466,202.75 142,721.46 94.53% Erskine Commons TIF District #2 431 0.95 - - Erskine Village TIF District #3 432 - 0.95 - - - - - - Douglas Road TIF District 435 561,079.06 0.95 533,025.11 264,862.03 20,851.19 285,713.22 275,365.84 50.92% Northeast TIF 429 1,685,484.97 0.95 1,601,210.72 693,351.99 657,696.09 1,351,048.08 334,436.89 80.16% Airport Urban Enterprise Zone 454 74,480.84 0.95 70,756.80 37,240.42 74,480.84 111,721.26 (37,240.42) 150.00% Other xxx 0.95 - - - - Total -Tax Increment Financing 27,672,643.43 26,289,011.26 12,707,769.68 11,353,358.33 24,061,128.01 3,611,515.42 86.95% Grand Total 79,621,606.40 75,640,526.08 17,145,867.75 22,390,036.25 33,368,626.53 72,904,530.53 6,717,075.87 91.56' tate Board 2010 Audit Fee Revised Total 79,621,606.40 75,640,526.08 17,145,867.75 22,390,036.25 33,368,626.53 72,904,530.53 6,717,075.87 91.56' Note(s) 1 Distribution 1 - 2 Distribution 2 - 3 Distribution 3 - x Comment(s) Financial Report March 2014 - Property Tax Revenue Page 12 of 28 City of South Bend Property Tax Revenue 2010 Tax Pay 2011 Fund Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy Per County Collection Projected 612112011 1212812011 Date Total Property Tax Collection General Fund Records Factor Collections Collections Collections Collections Collections Receivable Rate Citv General Fund 101 42,066,376.79 0.95 39,963,057.95 21,251,193.18 17,263,356.48 38,514,549.66 3,551,827.13 91.56% Parks & Recreation 201 8,312,858.52 0.95 7,897,215.59 4,199,509.82 3,414,250.57 7,613,760.39 699,098.13 91.59% College Football Hall of Fame 313 1,254,347.89 0.95 1,191,630.50 854,618.51 695,335.24 1,549,953.75 (295,605.86) 123.57% Cumulative Capital District 406 590,078.38 0.95 560,574.46 298,097.21 242,356.51 540,453.72 49,624.66 91.59% Fire Pension 701 - 0.95 - - - - - - Police Pension 702 2,370,799.58 0.95 2,252,259.60 1,136,488.71 672,463.54 1,808,952.25 561,847.33 - Total - City 431 52,223,661.58 0.95 49,612,478.50 26,603,418.72 21,615,298.80 - 48,218,717.52 4,004,944.06 92.33% Tax Increment Financinq Airport TIF District 324 11,653,069.38 0.95 11,070,415.91 5,952,841.44 5,234,926.22 11,187,767.66 465,301.72 96.01% South Bend Central TIF District 420 3,859,762.90 0.95 3,666,774.76 2,014,629.66 1,618,843.54 3,633,473.20 226,289.70 94.14% West Washington TIF District 422 478,174.00 0.95 454,265.30 196,385.97 234,699.42 431,085.39 47,088.61 90.15% Central Medical TIFDistrict 426 3,695,172.21 0.95 3,510,413.60 852,442.61 851,795.76 1,704,238.37 1,990,933.84 46.12% Northeast Residential TIF District 436 2,488,091.54 0.95 2,363,686.96 1,227,023.65 1,219,079.25 2,446,102.90 41,988.64 98.31% Southside TIF District # 1 430 2,370,799.58 0.95 2,252,259.60 1,136,488.71 672,463.54 1,808,952.25 561,847.33 76.30% Erskine Commons TIF District #2 431 2,698,264.66 0.95 2,563,351.43 1,362,916.56 (578,543.97) 784,372.59 1,913,892.07 29.07% Erskine Village TIF District #3 432 2,570,770.65 0.95 2,442,232.12 1,285,385.33 317,796.76 1,603,182.09 967,588.56 62.36% Douglas Road TIF District 435 517,502.30 0.95 491,627.19 183,946.89 122,106.31 306,053.20 211,449.10 59.14% Northeast TIF 429 841,360.54 0.95 799,292.51 374,489.89 340,572.61 715,062.50 126,298.04 84.99% Airport Urban Enterprise Zone 454 123,164.82 0.95 117,006.58 61,582.41 61,582.41 123,164.82 - 100.00% Other xxx - 0.95 - - - Total - Tax Increment Financing 31,296,132.58 29,731,325.95 14,648,133.12 10,095,321.85 - 24,743,454.97 6,552,677.61 79.06% Grand Total 83,519,794.16 79,343,804.45 41,251,551.84 31,710,620.65 - 72,962,172.49 10,557,621.67 87.36% State Board 2010 Audit Fee Revised Total 83,519,794.16 79,343,804.45 41,251,551.84 31,710,620.65 0.00 72,962,172.49 10,557,621.67 87.360/6 Note(s) 1 Distribution 1 - Issued by St. Joseph County on 6121111 2 Distribution 2 - 3 Distribution 3 - x Comment(s) Financial Report March 2014 - Property Tax Revenue Page 13 of 28 City of South Bend Property Tax Revenue 2009 Tax Pay 2010 Fund Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Distribution 4 Levy Per County Collection Projected 5/27/2010 612912010 111912010 1212912010 Total Property Tax Collection Airport TIF District Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate Citv Airport TIF District 324 General Fund 101 43,440,450.00 0.95 41,268,427.50 13,247,102.10 9,621,576.15 4,648,299.56 12,297,565.55 39,814,543.36 3,625,906.64 91.65% Parks & Recreation 201 8,483,379.00 0.95 8,059,210.05 2,586,993.98 1,878,973.94 907,754.99 2,401,561.33 7,775,284.24 708,094.76 91.65% College Football Hall of Fame 313 1,295,350.00 0.95 1,230,582.50 - 869,696.83 - 646,790.08 1,516,486.91 (221,136.91) 117.07% Cumulative Capital District 406 659,240.00 0.95 626,278.00 201,034.29 146,014.34 70,541.30 186,624.39 604,214.32 55,025.68 91.65% Fire Pension 701 - 0.95 - - 1,315,314.36 - - - - - Police Pension 702 3,004,554.55 0.95 1,565,972.05 3,140,749.75 21,939.25 99.31% Erskine Village TIF District #3 432 1,919,446.00 - Total - City 959,722.81 53,878,419.00 1,858,426.55 51,184,498.05 16,035,130.37 12,516,261.26 5,626,595.85 15,532,541.35 49,710,528.83 4,167,890.17 92.26% Tax Increment Financinq Airport TIF District 324 10,906,735.00 0.95 10,361,398.25 5,390,314.95 6,030,692.29 11,421,007.24 (514,272.24) 104.72% South Bend Central TIF District 420 3,558,777.00 0.95 3,380,838.15 1,685,661.11 2,229,497.21 3,915,158.32 (356,381.32) 110.01% West Washington TIF District 422 426,766.00 0.95 405,427.70 88,267.35 543,077.60 631,344.95 (204,578.95) 147.94% Central Medical TIFDistrict 426 3,593,126.00 0.95 3,413,469.70 849,441.76 909,586.45 1,759,028.21 1,834,097.79 48.96% Northeast TIF District 429 208,326.00 0.95 197,909.70 103,892.25 77,373.83 181,266.08 27,059.92 87.01% Southside TIF District # 1 430 2,202,865.00 0.95 2,092,721.75 1,134,619.79 1,315,314.36 2,449,934.15 (247,069.15) 111.22% Erskine Commons TIF District #2 431 3,162,689.00 0.95 3,004,554.55 1,574,777.70 1,565,972.05 3,140,749.75 21,939.25 99.31% Erskine Village TIF District #3 432 1,919,446.00 0.95 1,823,473.70 959,722.81 898,703.74 1,858,426.55 61,019.45 96.82% Douglas Road TIF District 435 321,325.00 0.95 305,258.75 137,583.10 135,928.49 273,511.59 47,813.41 85.12% Northeast Residential TIF 436 1,815,862.00 0.95 1,725,068.90 897,114.07 918,714.85 1,815,828.92 33.08 100.00% Airport Urban Enterprise Zone 454 132,020.00 0.95 125,419.00 66,009.75 66,009.75 132,019.50 0.50 100.00% Other xxx - 0.95 - - - - - - Total - Tax Increment Financing 28,247,937.00 26,835,540.15 - 12,887,404.64 - 14,690,870.62 27,578,275.26 669,661.74 97.63% Grand Total 82,126,356.00 78,020,038.20 16,035,130.37 25,403,665.90 5,626,595.85 30,223,411.97 77,288,804.09 4,837,551.91 94.11% State Board 2008 Audit Fee Revised Total 82,126,356.00 78,020,038.20 16,035,130.37 25,403,665.90 5,626,595.85 30,223,411.97 77,288,804.09 4,837,551.91 94.11% 2 Distribution 2 - Issued by County on June 29 3 Distribution 3 - Draw issued by County on November 9 X Comment(s) Financial Report March 2014 - Property Tax Revenue Page 14 of 28 City of South Bend Property Tax Revenue 2008 Tax Pay 2009 Fund Fund # Levy Estimated Levy Per County Collection Projected Distribution 1 Distribution 2 Distribution 3 Distribution 4 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate Citv General Fund 101 46,551,387.02 0.95 44,223,817.67 42,771,228.00 (991,832.22) 41,779,395.78 4,771,991.24 89.75% Parks & Recreation 201 8,605,545.37 0.95 8,175,268.10 7,906,741.00 (183,351.88) 7,723,389.12 882,156.25 89.75% College Football Hall of Fame 313 1,315,782.24 0.95 1,249,993.13 1,208,935.00 (28,033.85) 1,180,901.15 134,881.09 89.75% Cumulative Capital District 406 805,004.52 0.95 764,754.29 739,635.00 (17,151.21) 722,483.79 82,520.73 89.75% Fire Pension 701 275,396.27 0.95 261,626.46 253,033.00 (5,867.38) 247,165.62 28,230.65 89.75% Police Pension 702 444,870.93 0.95 422,627.38 408,746.00 (9,479.00) 399,267.00 45,603.93 89.75% Total - City 57,997,986.35 55,098,087.03 53,288,318.00 (1,235,715.54) 52,052,602.46 5,945,383.89 89.75% Tax Increment Financinq Airport TIF District 324 10,058,437.13 0.95 9,555,515.27 10,087,422.39 10,087,422.39 (28,985.26) 100.29% South Bend Central TIF District 420 3,526,506.54 0.95 3,350,181.21 3,420,958.84 3,420,958.84 105,547.70 97.01% West Washington TIF District 422 256,464.52 0.95 243,641.29 228,704.14 228,704.14 27,760.38 89.18% Central Medical TIFDistrict 426 3,614,010.63 0.95 3,433,310.10 1,765,934.06 1,765,934.06 1,848,076.57 48.86% Northeast TIF District 429 14,133.54 0.95 13,426.86 14,133.72 14,133.72 (0.18) 100.00% Southside TIF District # 1 430 1,937,246.72 0.95 1,840,384.38 1,644,200.70 1,644,200.70 293,046.02 84.87% Erskine Commons TIF District #2 431 2,850,711.91 0.95 2,708,176.31 2,837,842.49 2,837,842.49 12,869.42 99.55% Erskine Village TIF District #3 432 2,771,936.93 0.95 2,633,340.08 1,900,860.36 1,900,860.36 871,076.57 68.58% Douglas Road TIF District 435 218,606.56 0.95 207,676.23 187,247.91 187,247.91 31,358.65 85.66% Airport Urban Enterprise Zone 454 169,410.67 0.95 160,940.14 169,410.67 169,410.67 - 100.00% Other xxx - 0.95 - 0.23 0.23 (0.23) #DIV /0! Total - Tax Increment Financing 25,417,465.15 24,146,591.89 22,256,715.51 22,256,715.51 3,160,749.64 87.56% Grand Total 83,415,451.50 79,244,678.93 53,288,318.00 21,020,999.97 - - 74,309,317.97 9,106,133.53 89.08% State Board 2008 Audit Fee (18,844.00) (18,844.00) Revised Total 83,415,451.50 79,244,678.93 53,288,318.00 21,002,155.97 0.00 0.00 74,290,473.97 9,106,133.53 89.06% Note(s) 1 2 X X Comment(s) Financial Report March 2014 - Property Tax Revenue Page 15 of 28 City of South Bend Period Ending: March 2014 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 Bud et vemment We ryor 101 73,969 52,004 52,578 178,552 711,711 1 Call Center 101 39,235 38,732 31,260 109,227 488,908 erk 101 33,254 24,949 24,763 82,965 394,608 immon Council 101 33,804 16,129 22,696 72,628 472,598 ontroller 101 184,882 129,923 146,822 461,626 2,091,944 gal 101 111,670 74,144 74,485 260,299 1,025,635 K 740 4,254 4,776,421 3,539,947 3,470,493 11,786,861 48,011,105 ib Total 476,814 335,881 352,603 1,165,298 5,185,404 cs iergy Office 101 igineering 101 100,714 83,713 46,461 230,888 1,126,302 affic 8 Lighting 101 K ib Total 100,714 83,713 46,461 230,888 1,126,302 ty We lice 101 2,352,204 1,889,108 1,847,740 6,089,052 24,725,204 Mice Communications 101 205,840 146,325 143,663 495,828 2,236,486 /ice -PS LOIT funded 101 ode Junk Vehicle 101 ,e 101 2,004,690 1,591,802 1,605,489 5,201,981 21,049,415 -e-PS LOIT funded 101 213,687 (87,288) (126,399) 612 2,254 K ib Total ib Total 740 4,254 4,776,421 3,539,947 3,470,493 11,786,861 48,011,105 cement We 101 740 3,642 (2,402) 1,980 5,225 eights and Measure 101 ode Hearing 101 ode Junk Vehicle 101 ode Unsafe Building 101 ode Animal Control 101 612 (0) 612 2,254 X ib Total 740 4,254 (2,403) 2,592 7,479 ire wis PAC 101 87,838 86,253 87,012 261,103 1,063,527 dais Royale 101 43,724 31,427 36,381 111,532 523,710 K ib Total 131,562 117,680 123,393 372,635 1,587,237 Ws iman Rights 101 31,977 26,096 24,523 82,595 367,262 K ib Total 31,977 26,096 24,523 82,595 367,262 General Fund Expenditure Total 5,518,227 4,107,572 4,015,071 - - - - - - - - - 13,640,869 56,284,789 24% Financial Report March 2014 - &p-dk- Summary Page 16 of 28 City of South Bend Period Ending: March 2014 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 did Waste Operations 610 672,124 364,775 527,277 1,564,177 5,439,463 ,11d Waste Capital 611 264,795 79,617 45,260 )tor Vehicle Highway 1100 Administration 201 113,658 84,616 98,120 296,394 1,564,813 19% 1101 Maintenance 201 440,988 353,914 390,644 1,185,547 4,947,775 24% 1102 Golfo eradons 201 79,201 66,423 162,024 307,648 1,526,640 20% 1103 Recreation Division 201 195,148 128,820 129,384 453,352 2,114,512 21% 1104 Potawatomi Zoo 201 669,326 24,910 19,666 713,902 2,283,664 31% 1106 Potawatomi Greenhouse 201 8,161 7,588 5,995 21,745 59,614 36% 1107 Community Svc Block Grant 201 196 36 157 390 2,057,224 NA 1108 Graffiti Removal 201 7,701 4,982 7,622 20,306 103,860 20% Recreation Non Reverting 203 42,584 72,465 55,717 170,766 1,479,064 12% East Race Waterway 271 10,346 0% Coveleski Stadium 401 1,220,608 1,289,727 1,080,910 3,591,245 3,540 0% Park Non Reverting 405 4,814 111,962 116,776 205,217 57% xxx )oot xxx NA Sub Total 653 1,561,582 855,681 869,172 - - - 3,286,434 14,299,045 23% (s did Waste Operations 610 672,124 364,775 527,277 1,564,177 5,439,463 ,11d Waste Capital 611 264,795 79,617 45,260 )tor Vehicle Highway 202 818,846 888,630 620,621 2,328,097 8,555,846 irb and Sidewalk 202 49,312 36,865 30,043 116,220 1,152,802 antral Services 222 672,962 610,722 687,806 1,971,490 8,036,532 Ical Roads &Streets 251 19,206 IZ316 11,761 43,282 1,124,520 oiect ReLeaf 655 14,433 3,216 2324 19,973 430,114 X xxx 4,436 217,508 811,011 27% Waterworks Deposit ib Total 186 1,574,759 1,551,748 1,352,556 4,479,063 19,299,814 rs Solid Waste did Waste Operations 610 672,124 364,775 527,277 1,564,177 5,439,463 ,11d Waste Capital 611 264,795 79,617 45,260 389,673 896,070 X xxx 60,631 71,687 ib Total 936,920 444,393 572,537 1,953,849 6,335,533 Public Works Water Utility 0630 Water Leak Insurance 620 60,631 71,687 52,589 184,907 1,115,000 17% 0640 Water Works 620 1,137,738 1,021,433 1,021,980 3,181,151 13,724,004 23% 0660 Clay Water 620 215 37,262 3 218 3,000 7% Waterworks Capital 622 3,600 1,880,989 3,676,419 3,600 978,258 0% Waterworks Construction 623 17,780 195,292 4,436 217,508 811,011 27% Waterworks Deposit 624 186 534 724 1,444 6,000 24% Waterworks Sinking 625 196 36 157 390 2,057,224 0% Waterworks Bond Reserve 626 422 1,221 1,702 3,346 15,000 NA Waterworks Debt Reserve 629 261 746 1,021 2027 8,500 24% xxx xxx xxx 1,138 NA Sub Total 649 1,220,608 1,289,727 1,080,910 3,591,245 18,702,997 1991 Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 17,250 30,211 23,925 71,386 549,978 13% 0621 Sewer Repair 641 461,905 389,062 283,083 1,134,050 5,132,912 22% 0625 Concrete Crew 641 39,120 37,262 32,982 109,364 453,145 24% 0630 Wastewater Operations 641 4,020,021 1,880,989 3,676,419 9,577,430 28,766,521 33% 0631 Organic Resources 641 78,091 82,861 91,592 252,543 1,202,616 21% 0650 Clay Sewage 641 978 0 978 1,000 -98% Sewage Capital 642 978,994 416,435 421,874 1,817,302 9,267,941 20% Sewage Reserve 643 422 1,221 1,702 3,346 15,000 22% Sewer Bond 200612006 645 NA Sewer Bond 2007 647 1,138 0% Sewage Bond Sinking 649 500 850 1,350 9,802,031 0% Clay Sewage General 650 NA Sewage Bond 2007 651 NA Sewage Works DS Reserve 653 NA 2010 CSO Net Sewer Bond 658 NA 2011 Sewer Bond 659 275,419 265,818 144,834 686,071 13,598,486 5% 2012 Sewer Bond 661 272,470 216,156 17,815 506,441 18,868,570 3% 2013 Sewer Bond 663 19,100,000 0% 2014 Sewer Bond 665 500,000 0% Sub Total 6,143,212 3,320,865 4,694,227 - - - - - - - - - 14,158,303 107,259,338 13% Financial Report March 2014 - &p-dk- Summary Page 17 of 28 City of South Bend Period Ending: March 2014 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 Public Safe - Police 4S Capital 288 449,207 280,578 359,503 1,089,288 5,402,215 Seizures 216 15,801 10,000 ver Rescue 291 199 1,283 0 40,000 0% Curfew Violations 218 1,612,310 385,712 ib Total 449,407 281,861 359,503 1,000 0% Law Enforcement Education 220 11,075 20,490 23,204 54,769 294,802 19% Emer enc Tele hone System 244 27,387 16,003 16,999 60,389 215,000 28% Public Safe LOIT 249 517,291 613,746 709,196 1,840,232 7,214,658 26% IPolice Excess Welfare Public Safety 252 xxx 1,146 0% Police Take Home Vehicle 278 15,269 811 12 709 28,789 80,580 0% Police Block Grant 280 29,594 71,075 113,460 214,129 5,823,729 NA Police Grants 292 337,650 358,693 138,059 138,059 228,060 61% PoliceAcademy294 434 136 197 330 664 23,750 3% COPS More Grants 295 175 1,484 1,185 2,844 141,600 2% Drug Enforcement 299 6,273 2,731 3,839 6,569 151,499 4% K -9 Unit 705 2,000 0% xxx xxx xxx 4,831,372 709,183 802,655 6,343,210 29,290,528 NA Sub Total 556,065 654,651 892,811 - - - - - - - - - 2,103,527 8,394,095 25% ty - Fire 4S Capital 288 449,207 280,578 359,503 1,089,288 5,402,215 mmat 289 15,801 10,000 ver Rescue 291 199 1,283 0 1,483 52,300 X xxx 1,612,310 385,712 ib Total 449,407 281,861 359,503 1,090,771 5,464,515 De artmento mmunity Investment Z iin Street StudebakedOliver 209 15,801 740 39,273 203,425 1,385,000 0% State Grant 210 1,612,310 385,712 18,003 18,003 117,886 15% CED Operating 211 236,843 167,810 175,126 579,779 2,404,884 24% 1001 Dept. of Community Investment 212 85,538 190,071 52,948 328,557 6,499,680 5% 1002 Dept. of Community Investment 212 Idy Street Commons 601 176,179 2,650,433 10,014,984 NA 1003 Administration 212 xxx 2,328 0% xxx Programs 212 15,269 811 12 709 28,789 408,775 7% xxx xxx xxx 29,594 71,075 113,460 214,129 5,823,729 NA Sub Total 416 337,650 358,693 258,786 955,128 10,818,553 9% Capital /Debt Service Z iin Street 601 22,732 15,801 740 39,273 203,425 Joseph 601 COIT 404 1,612,310 385,712 447,510 ighton Plaza 601 39,122 41,189 2,241 82,552 337,008 iforoement 601 13,486 4,479 196 18,161 90,606 ayne Street 601 21,424 12,784 718 34,927 150,869 Idy Street Commons 601 176,179 2,650,433 10,014,984 26% 15,900 X xxx NA ib Total 410 96,764 74,254 3,896 174,913 797,808 Capital /Debt Service Hall of Fame 313 634,500 634,500 1,268,116 50% COIT 404 1,612,310 385,712 447,510 2,445,532 10,193,285 24% Cum Capital Development 406 112,650 56,546 169,196 722,935 23% Cum Capital Improvement 407 185,250 185,250 364,762 51% EDIT 408 2,229,819 244,434 176,179 2,650,433 10,014,984 26% Cumulative Sewer 409 NA UDAG 410 NA Major Moves 412 29,594 71,075 113,460 214,129 5,823,729 4% Morris PAC Improvement 416 2,911 2,911 53,200 5% CREED 434 20,975 20,975 650,950 3% Palais Historic Preservation 450 10,000 0% Hall of Fame Capital 677 6,273 7,962 6,049 20,284 188,567 11% xxx xxx xxx NA Sub Total 4,831,372 709,183 802,655 6,343,210 29,290,528 22% Financial Report March 2014 - Expenditure Summary Page 18 of 28 City of South Bend Period Ending: March 2014 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 226 Excess Levy 103 18,955 57,964 253,743 Liability Insurance 226 NA 243,446 Gift, Donation, Bequest 217 1,028,811 Business Insurance 226 6,557 51,010 0% 63,213 Loss Recovery 227 5,154 6,805 201,942 213,901 5,615,805 4% xxx General Grant 250 657,534 0% TIF Lei Leighton Plaza 20,595 Sub Total NA 103,406 Human Rights 258 19,647 10,646 9,995 40,288 224,001 18% 2,421,899 Morris Palais Marketing 273 3,628 429 982 4,610 8,100 57% 2,806,117 Economic Revenue Bond 281 430 81,949 8,298 169,406 259,653 NA 4% ProfessionalSports Development 377 382,873 800 383,673 865,746 44% 1201 Code Enforcement 600 87,023 68,770 63,184 218,976 1,836,074 12% 1207 Animal Control 600 58,611 49,070 47,679 155,360 689,215 23% 1306 Building Operations 600 102,831 81,636 75,880 260,347 1,273,620 20% Century Center 670 314,629 427,425 323,712 1,065,766 4,564,898 23% 1,003,928 Century Center Capital 671 13% 106,684 0% xxx xxx xxx NA Sub Total 974,395 645,150 723,375 2,342,920 15,235,153 15% m Insurance Self Funded Liability Ins 226 20,289 18,720 18,955 57,964 253,743 Liability Insurance 226 39,002 243,446 47,138 329,586 1,028,811 Business Insurance 226 6,557 29,628 27,028 63,213 572,300 Workers Compensation 226 37,558 198,648 118,501 354,706 1,042,346 xxx xxx 319 657,534 0% TIF Lei Leighton Plaza 20,595 Sub Total xxx 103,406 490,442 211,622 805,469 2,897,200 y Trust & Agency Fire Pension 701 457,164 448,542 448,687 1,354,393 5,874,445 Police Pension 702 542603 643,997 645,479 1,832,078 7,221,941 Employee Benefits 711 526,930 1,807,630 1,315,439 3,649,999 14,483,463 Unemployment Comp 713 9,673 16,224 12 294 38,190 227,974 City Cemetery Trust 730 319 657,534 0% TIF Lei Leighton Plaza 20,595 xxx xxx 13,842 31,584 149,425 21% TIF Medical Service Sub Total 169,224 1,536,369 2,916,392 2,421,899 6,874,660 27,828,418 Civil City Expenditure 25,840,735 17,700,611 18,259,018 - - - - - - - - - 61,800,363 322,907,786 19% Tax Increment Financing TIF Air ort 324 1,403,524 250,577 673,576 2,327,677 27,286,693 9% TIF Sam le Ewing 414 NA TIF Central Development 420 1,015,931 314,263 51,873 1,382,067 5,829,261 24% TIF West Washington 422 319 319 657,534 0% TIF Lei Leighton Plaza 425 4,077 13,665 13,842 31,584 149,425 21% TIF Medical Service 426 169,224 169,224 4,103,504 4% TIF Northeast 429 617 617 2,806,117 0% TIF Southside 430 81,949 8,298 169,406 259,653 6,487,957 4% TIF Erskine Commons 431 NA TIF Erskine Villa a 432 354,606 354,606 494,151 72% TIF Dou las Road 435 160 95,231 95,391 399,823 24% North east Residential TlF 436 1,464,500 400,791 1,865,291 3,583,228 52% xxx xxx xxx NA Sub Total 4,494,908 987,594 1,003,928 6,486,429 51,797,693 13% Financial Report March 2014 - Expendk- Summary Page 19 of 28 City of South Bend Period Ending: March 2014 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 Redevelo ment Funds 1,042,292 1,075,730 - - - - - - - - - 6,666,915 57,100,399 12% central Bond Proceeds 305 City Operations Total 30,389,628 18,742,903 19,334,748 - NA District Capital 2003 428 133 381 517 1,031 NA Administration 433 6,072 4,140 10,212 20,000 51% Coveleski Bond Construction 438 NA CertlBed Technology Park 439 223 637 863 3,600,000 0% Air ort Urban Enterprise Zone 454 NA Blackthorn Goff Operations 619 47,557 53,680 66,283 167,519 1,671,706 10% xxx xxx xxx NA Sub Total 53,629 53,680 70,422 177,731 5,291,706 3% e 1,042,292 1,075,730 - - - - - - - - - 6,666,915 57,100,399 12% iblic Improvement 1990 314 City Operations Total 30,389,628 18,742,903 19,334,748 - - - - - - - - - 68,467,278 rport Debt Reserve 2003 315 133 381 517 1,031 5,000 rveleski Bond Debt Reserve 317 0 0 0 0 0 0 0 0 0 0 ackthorn Debt Service 319 ?ntral Development reserve 328 223 637 863 1,723 6,000 X xxx ib Total 356 1,019 1,380 2,755 11,000 Redevelopment Commsssion 4,548,893 1,042,292 1,075,730 - - - - - - - - - 6,666,915 57,100,399 12% City Operations Total 30,389,628 18,742,903 19,334,748 - - - - - - - - - 68,467,278 380,008,185 18% Expenditure report 30,389,627 18,742,903 19,334,748 68,467,278 380,008,185 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report March 2014 - Expenditure Summary Page 20 of 28 City of South Bend Debt Schedule Period Ending; March 2014 Year of I Year of Year of Scheduled Payments Debt (Orig / Ref•) Debt at 2014 Principal 2014 Interest 2014 Debt at 2114 Total Debt Instrument Debt Purpose Issue Refundin Maturi Fund list 2nd 3rd 4th Issue 12/31/2013 Payments Payment Addition 12/31/2014 Debt Pa menu Civil City Debt Bond Debt Arran scb k 3/ CEDIT Bond 1997 2006 2017 408 2/1 8/1 - - 11,870,000.00 2,815,000.00 760,000.00 121,520.00 0.00 2,055,000.00 881,520.00 36 South Bend Building Corporation Public Works Building 2001 2010 2021 404/649 2/1 8/1 - - 9,250,000.00 4,385,000.00 525,000.00 145,626.00 0.00 3,860,000.00 670,626.00 25 Water Works Improvements Water Works 2002 2012 2023 625 1/1 7/1 - - 5,975,000.00 3,450,000.00 350,000.00 69,000.00 0.00 3,100,000.00 419,000.00 39 South Bend Building Corporation Fire HO / Police HO 2003 2012 2023 404/324 2/1 8/1 - - 21,335,000.00 12,365,000.00 1,120,000.00 446,010.00 0.00 11,245,000.00 1,566,010.00 41 Sewage Works Improvements Sewage Works 2004 2024 649 611 12/1 - - 11,425,000.00 0.00 0.00 0.00 0.00 0.00 0.00 24 Water Works Improvements Water Works 2006 2027 625 1/1 7/1 - - 4,710,000.00 3,505,000.00 205,000.00 155,438.00 0.00 3,300,000.00 360,438.00 42 Sewage Works Improvements Sewage Works 2006 2026 649 6/1 12/1 - - 7,630,000.00 6,090,000.00 350,000.00 269,491.26 0.00 5,740,000.00 619,491.26 4o Saw age Works Improvements Sewage Works 2007 2027 649 6/1 12/1 - - 16,600,000.00 13,010,000.00 690,000.00 563,547.50 0.00 12,320,000.00 1,253,547.50 52 Sewage Works Revenue Bonds 2007B Sewage Works 2007 2027 649 6/1 12/1 - - 16,515,000.00 12,960,000.00 680,000.00 551,541.26 0.00 12,280,000.00 1,231,541.26 62 Century Center Special Tax Bonds Century Center 2008 2028 420 5/1 11/1 - - 4,655,000.00 3,990,000.00 240,000.00 104,308.26 0.00 3,750,000.00 344,308.26 6s Water Works Improvements Water Works 2009 2030 625 1/1 7/1 - - 5,380,000.00 4,985,000.00 210,000.00 270,232.00 0.00 4,775,000.00 480,232.00 70 Sewage Works Revenue Bonds -2009 Sewage Works 2009 2028 649 6/1 12/1 - - 3,297,000.00 2,710,898.00 149,511.00 76,176.00 0.00 2,561,387.00 225,687.00 eo 2010 Sewage Works Revenue Bonds Sewage Works 2010 2030 649 6/1 12/1 - - 9,345,000.00 8,270,000.00 365,000.00 336,217.50 0.00 7,905,000.00 701,217.50 93 Sewage Works Revenue Bonds 2011 Sewage Works 2011 2031 649 6/1 12/1 - - 21,500,000.00 19,895,000.00 855,000.00 732,300.00 0.00 19,040,000.00 1,587,300.00 sg 2012 Water Works Revenue Bond Water Works 2012 2033 625 1/1 7/1 - - 8,300,000.00 7,960,000.00 340,000.00 233,886.26 0.00 7,620,000.00 573,886.26 101 2012 Sewage Works Revenue Bonds Sewage Works 2012 2032 649 6/1 12/1 - - 25,000,000.00 23,985,000.00 1,020,000.00 548,580.00 0.00 22,965,000.00 1,568,580.00 fo52013A Sewer Bond Refunding Sewage Works 2013 2013 2024 649 6/1 12/1 - - 14,765,000.00 13,700,000.00 1,845,000.00 265,780.00 0.00 11,855,000.00 2,110,780.00 116 2013 Building Corporation xxx EMS / Fire Department 2013 2033 288 2/1 8/1 - - 5,580,000.00 5,580,000.00 0.00 142,197.00 0.00 5,580,000.00 142,197.00 Total Bond Debt 225 632 000.00 149 655 898.00 9,704,511.00 5 031 851.04 0.00 139 951 387.00 14 736 362.04 Loans Payable 1 State Revolving Fund Bosch Property 2002 2022 210 1/30 10/30 - - 506,448.00 0.00 0.00 0.00 0.00 0.00 0.00 6e State Revolving Fund Water Works Improvement 2009 2030 625 1/1 7/1 - - 427,332.00 391,297.00 18,933.00 13,186.70 0.00 372,364.00 32,119.70 82 Interfund Loan 410 - UDAG 1st Source/Marriott Garage 2010 2015 410 6/15 12/15 - - 2,700,000.00 2,027,973.00 0.00 0.00 0.00 2,027,973.00 0.00 44 State Revolving Fund (Refunding) 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 26 State Revolving Fund Water Works Improvements 2000 2019 625 1/1 7/1 - - 2,600,000.00 1,018,815.00 157,902.00 29,546.00 0.00 860,913.00 187,448.00 Total Loans Pa able 35 533 780.00 3.438.085.00 176 835.00 42 732.70 0.00 3.261.250.00 219 567.70 Capital Leases 27 LaSalle Bank - Fire Fire Equipment 2007 2012 288 6/1 12/1 - - 621,520.00 0.00 0.00 0.00 0.00 0.00 0.00 sf Chase LED Equipment 2007 2017 101 1/1 711 - - 1,531,573.00 730,258.41 171,136.37 29,443.29 0.00 559,122.04 200,579.66 5s Commerce Bank Police Vehicles 2008 2008 406 6/1 12/1 - - 963,508.00 0.00 0.00 0.00 0.00 0.00 0.00 56 Oce Copier 209 N Main 2008 2013 620 Monthly - - - 12,078.21 0.00 0.00 0.00 0.00 0.00 0.00 57 Lanier Copier 830 N Michigan 2008 2013 620 Monthly - - - 5,154.00 0.00 0.00 0.00 0.00 0.00 0.00 5s Lanier Copier 915 Oil- 2008 2013 620 Monthly - - - 5,154.00 0.00 0.00 0.00 0.00 0.00 0.00 59 Lanier Copier Street 2008 2013 202 Monthly - - - 4,300.00 0.00 0.00 0.00 0.00 0.00 0.00 67 Sun Trust Solid Waste Containers/Tri 2009 2014 611 9/1 3/1 - - 720,990.00 78,167.28 78,167.28 1,450.00 0.00 0.00 79,617.28 71 Kansas State Bank Clark Lanier Oce Copier 2010 2014 101 1/23 4/23 7/23 10/23 9,209.00 638.84 638.84 10.63 0.00 0.00 649.47 72 Kansas State Bank Code Enforcement Oce Copier 2010 2015 101 1/23 4/23 7/23 10/23 9,209.00 2,594.75 2,055.52 143.04 0.00 539.23 2,198.56 73 Kansas State Bank Engineering Lanier Oce Copier 2010 2014 101 1/23 4/23 7/23 10/23 9,391.00 651.47 651.47 10.84 0.00 0.00 662.31 74 CSI Leasing Inc IT Netapp San 2010 2014 404 1/1 4/1 7/1 10/1 207,521.37 14,236.41 14,236.41 210.59 0.00 0.00 14,447.00 76 Kansas State Bank Central Services Copier 2010 2015 222 2/16 5/16 8/16 11/16 13,366.40 4,362.77 2,865.87 194.13 0.00 1,496.90 3,060.00 n GE Capital Information Technology Animal Control Copier 2010 2015 101 2128 5/30 8/30 11130 3,550.69 1,161.97 758.35 57.05 0.00 403.62 815.40 7e Kansas State Bank Mayor Oce Copier 2010 2015 101 1/8 4/8 7/8 10/8 9,209.00 3,564.45 1,977.73 220.83 0.00 1,586.72 2,198.56 7s Advanced Imaging Central Services Duplicators 2010 2015 222 1/15 4/15 7/15 10/15 10,511.02 4,702.41 2,246.64 348.72 0.00 2,455.77 2,595.36 87 Public Finance.com Inc Solid Waste Containers /Trucks 2011 2015 611 6/15 12/15 - - 321,853.00 133,252.34 65,587.04 3,677.96 0.00 67,665.30 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 1,05 04 84 417,495.38 17,470.02 0.00 641,545.46 434,965.40 so Capital One Public Funding Solid Waste Containers /Trucks 2011 2016 611 3/15 6/15 9/15 12/15 207,432.00 116,115.23 41,611.14 1,674.42 0.00 74,504.09 43,285.56 s1 GE Capital Information Technology Police Dept Copier 2011 2016 101 1/11 4/11 7/11 10/11 3,836.00 2,065.68 790.50 98.22 0.00 1,275.18 888.72 s2 Key Finance IT Phone System 2011 2016 404 1/15 1,444,995.97 843,595.57 274,272.26 21,127.15 0.00 569,323.31 295,399.41 s4 Ikon Office Solutions Mayor Ricoh MP 2851 SP Copiei 2011 2016 101 2115 5/15 8/15 11/15 2,569.53 1,620.15 509.86 78.62 0.00 1,110.29 588.48 s5 Sun Trust Equipment Finance Parks -Golf Cars Lease 2012 2016 201 4/15 10/15 - - 344,500.00 218,030.66 86,168.37 3,154.11 0.00 131,862.29 89,322.48 s7 Sun Trust Equipment Finance Police Vehicles & Equipment 2012 2017 406 5/15 11/15 - - 1,295,000.00 918,678.73 256,966.38 14,484.90 0.00 661,712.35 271,451.28 s3 PNC Equipment Finance Public Works Vehicles Lease 2012 2017 202/641/640 5/15 11/15 - - 945,674.38 669,405.77 187,687.81 9,371.03 0.00 481,717.96 197,058.84 too PNC Equipment Finance Public Works Vehicles Lease 2012 2017 202/641/600/288 1/15 7/15 - - 2,806,054.00 2,257,055.55 553,306.66 27,644.68 0.00 1,703,748.89 580,951.34 foe Ikon Office Solutions /Ricoh Wastewater Copier 2012 2017 641 Monthly 1st 5,744.95 4,278.32 1,108.22 213.70 0.00 3,170.10 1,321.92 1. GE Capital Information Technology Fire Department Copier 2012 2017 101 2/28 5/28 8/28 11128 5,471.01 4,249.41 1,043.56 227.24 0.00 3,205.85 1,270.80 foe Ricoh USA (New) Central Services Copier 2013 2018 222 2/27 5/27 8/27 11/27 3,622.78 3,004.64 689.33 150.43 0.00 2,315.31 839.76 107 Ricoh USA StreeUSewer Dept Copier 2013 2018 202/641 3/4 6/4 9/4 12/4 5,559.15 4,506.34 1,031.00 239.80 0.00 3,475.34 1,270.80 toe Ricoh USA City Attorney Copier 2013 2018 101 2/12 5112 8112 11/12 5,559.15 4,528.32 1,035.69 235.11 0.00 3,492.63 1,270.80 ms Ricoh USA Parks & Rep Ricoh Copiem(3) 2013 2018 201 2121 5/21 8/21 11121 16,129.94 13,138.50 3,005.59 681.65 0.00 10,132.91 3,687.24 Ile INC Equipment Finance Vehicle/Equipment Lease 2013 2018 1011202/406/641 1115 7115 - - 1,689,669.59 1,689,669.59 327,718.32 22,182.20 0.00 1,361,951.27 349,900.52 111 Ricoh USA Engineering Plotter /Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10,667.67 8,694.31 1,904.10 687.90 0.00 6,790.21 2,592.00 112 Ricoh USA Building Dept. Copier 2013 2018 600 Monthly 4,093.64 3,854.45 744.53 194.47 0.00 3,109.92 939.00 113 Sun Trust Equipment Finance Police and PW vehicles 2013 2018 404/655/611/202 4/24 10/24 - - 1,506,465.26 1,506,465.26 291,855.59 22,725.55 0.00 1,214,609.67 314,581.14 114 Ricoh USA Admin & Finance Copier 2013 2018 101 1116 4116 7116 10/16 11,247.97 9,620.91 2,055.86 515.39 0.00 7,565.05 2,571.25 115 CSI Leasing Inc 2010 Server IT Lease 2010 2014 404 211 5/1 8/1 11/1 28,588.00 5,869.74 5,869.79 169.81 0.00 (0.05) 6,039.60 fn Police Dept. Record Div. Ricoh Police Records Copier 2013 2018 101 Monthly 3rd 9,678.26 9,678.26 1,728.17 491.83 0.00 7,950.09 2,220.00 113 Water Works Main Ricoh Copier Water Works Main Ricoh Copier 2013 2018 620 Monthly 10th 5,647.50 5,647.50 1,008.13 287.27 0.00 4,639.37 1,295.40 fts Water Works Colfax Ricoh Copier Water Works Colfax Ricoh Co k 2013 2018 620 Monthly 16th 4,732.65 4,732.65 844.81 240.71 0.00 3,887.84 1,085.52 12o Water Works Olive Ricoh Copier xxx Water Works Olive Ricoh Copier 2013 2018 620 Monthly 10th 4,732.65 4,732.65 844.81 240.71 0.00 3,887.84 1,085.52 Total Capital Lease 18 788 201.74 10 341 870.13 1 2.801.617.38 180 354.00 0.00 7,540,252.75 2 981 971.38 Total Civil City 279,953,981.74 163,435,853.13 12,682,963.38 5,254,937.74 0.60 150,752,889.75 17,937,901.12 Financial RepW M-h 2014 - Debf Page 21 0/28 City of South Bend Debt Schedule Period Ending; March 2014 Year of I Year of Year of Scheduled Payments Debt (Orig / Reb) Debt at 2014 Principal 2014 Interest 2014 Debt at 2tl4 Total Debt Instrument Debt Purpose Issue Refunding maturity Fund 1st 2ntl 3rd 4th Issue 12/31/2013 Payments Payment Addition 12/31/2014 Debt Pa menu Redevelopment Commission Debt Bond Debt 9 Central Business TIF 1990 1996 2012 420 2J 1 8/1 - - 3,790,000.00 0.00 0.00 0.00 0.00 0.00 0.00 to Blackthom Golf Course Blackthorn Golf 1992 1998 2013 619 3/1 9/1 - - 6,135,000.00 0.00 0.00 0.00 0.00 0.00 0.00 7 Century Center Lease Rental Revenue Century Center 1994 2001/2011 2018 407 2J 1 811 - - 6,825,000.00 2,070,000.00 440,000.00 46,350.00 0.00 1,630,000.00 486,350.00 a College Football Hall of Fame Hall of Fame 1994 2000/2011 2018 313 211 8/1 - - 15,370,000.00 5,285,000.00 1,130,000.00 137,687.50 0.00 4,155,000.00 1,267,687.50 ti South Bend Building Corporation Morris PAC 1998 2009 2017 408 2J 1 811 - - 13,300,000.00 3,380,000.00 920,000.00 120,262.50 0.00 2,460,000.00 1,040,262.50 12 TJX Special Taxing District 2002 2022 324/404/414 1/1 7/1 - - 6,620,000.00 3,405,000.00 360,000.00 152,712.50 0.00 3,045,000.00 512,712.50 5 Downtown Central Area TIF 2003 2011 2024 420 2J 8/1 - - 19,795,000.00 16,120,000.00 1,155,000.00 759,297.00 0.00 14,965,000.00 1,914,297.00 5 Airport Development Area TIF Airport TIF 2003 2011 2024 324 211 8/1 - - 14,420,000.00 9,195,000.00 660,000.00 433,067.75 0.00 8,535,000.00 1,093,067.75 22 Erskine Village TIF Development Bond Erskine Village 2005 2027 432 2J 1 8/1 - - 5,485,000.00 4,465,000.00 210,000.00 281,495.00 0.00 4,255,000.00 491,495.00 sa Lease Rental Revenue Bonds of 2008 Eddy Street Commons 2008 2027 429 2/15 8/15 - - 36,000,000.00 34,050,000.00 1,030,000.00 1,894,868.00 0.00 33,020,000.00 2,924,868.00 at Coveleski Stadium Recovery Coveleski Stadium 2010 2019 377 1/15 7/15 - - 4,980,000.00 3,520,000.00 605,000.00 159,745.00 0.00 2,915,000.00 764,745.00 as SB Economic Develop Revenue Bonds Career Academy 2011 2014 324 2/15 5/15 8/15 11/15 1,500,000.00 500,000.00 500,000.00 12,500.00 0.00 0.00 512,500.00 too 2012 Gatos Downtown Campus VA Clinic Agmt Loan 2012 2015 420 3/1 8/1 1,700,000.00 1,133,333.34 566,666.66 0.00 0.00 566,666.68 566,666.66 121 Blackthom Golf Cart Lease xxx Blackthorn Golf 2014 2019 619 Monthly 14th 293,788.00 0.00 36,549.96 5,248.60 293,788.00 257,238.04 41,798.56 Total Bond Debt 139 713 788.00 83 123 333.34 7,613,216.62 4 003 233.85 293 788.00 75 803 904.72 11 616 450.47 Loans Payable 3 Indiana Development Finance Authority Bosch Property (Nonforgive) 2001 2021 210 3/22 6/22 9/22 12/22 1,040,000.00 482,021.41 58,200.48 13,809.96 0.00 423,820.93 72,010.44 4 Indiana Development Finance Authority Bosch Property (Forgive) 2001 2021 210 - - - - 260,000.00 133,214.96 16,084.70 3,816.62 0.00 117,130.26 19,901.32 2 State Industrial Development Fund Bosch Property 2002 2017 210 4/1 10/1 - - 1,000,000.00 0.00 0.00 0.00 0.00 0.00 0.00 14 Indiana Development Finance Authority Frederickson Park 2003 2012 404 3131 6/30 9130 12131 764,809.60 0.00 0.00 0.00 0.00 0.00 0.00 15 Indiana Development Finance Authority Frederickson Park (Forgive) 2003 2012 404 - - - - 191,202.40 0.00 0.00 0.00 0.00 0.00 0.00 is Indiana Development Finance Authority Anchor 2005 2014 404 6130 12131 - - 600,000.00 66,666.72 66,666.72 1,250.00 0.00 0.00 67,916.72 17 Indiana Development Finance Authority Anchor (Forgive) 2005 2014 404 6/30 12/31 - - 75,000.00 10,714.32 10,714.32 200.89 0.00 0.00 10,915.21 eo HUD Section 108#8 Studebaker Oliver 2008 2025 434 211 811 - - 4,000,000.00 1,005,000.00 825,000.00 41,949.00 0.00 180,000.00 866,949.00 w City of Mishawaka Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1,102,549.56 343,532.46 91,529.37 16,046.63 0.00 252,003.09 107,576.00 e4 Intertund Fund 412 - Major Moves Douglas Road TIF 2009 2029 435 2115 8/15 - - 1,040,319.00 923,829.00 37,152.00 45,733.00 0.00 886,677.00 82,885.00 as Interfund Fund 619 - Blackthom Blackthorn Equip (golf carts) 2010 2017 619 5/15 6/15 7/15 8/15 31,032.00 15,516.00 3,879.00 0.00 0.00 11,637.00 3,879.00 a4 Interfund Fund 4112 Major Moves Triangle Development 2011 2029 436 2115 8115 - - 2,000,000.00 1,558,050.00 44,790.50 15,580.50 0.00 1,513,259.50 60,371.00 a5 ntedund Fund 412 - Major Moves Eddy Street Commons 2011 2026 436 2/15 8/15 - - 4,100,000.00 3,430,958.01 203,399.20 169,036.80 0.00 3,227,558.81 372,436.00 es Interfund Fund 209 to Airport 324 Prairie Ave Brownfield Project 2011 2020 324 819 - - - 500,000.00 500,000.00 0.00 0.00 0.00 500,000.00 0.00 ae Blackthom Loan from Airport xxx Blackthorn Equip (mowers) 2011 2018 619 5/15 6/15 7/15 8/15 53,598.50 36,848.90 6,699.84 0.00 0.00 30,149.06 6,699.84 Total Loans Payable 22 058 511.06 8,506,351.78 1 364 116.13 307 423.40 0.00 7,142.235.65 1 671 539.53 Capital Lease 75 PNC Equipment Financing xxx Blackthorn Golf Carts 2010 2015 619 Monthly 246,509.64 106,802.80 52,087.76 4,333.24 0.00 54,715.04 56,421.00 Total Capital Lease 246,509.64 106,802.80 52,087.76 4,333.24 0.00 54,715.04 56,421.00 Leases 37 Transpo Lease Leighton Plaza Garage 2001 2015 404 6/30 12/30 - - 3,000,000.00 371,710.00 180,363.00 19,637.00 0.00 191,347.00 200,000.00 13 Transpo Lease xxz Main / Colfax Garage 2006 2025 404 3/15 9/15 - - 2,510,278.00 1,788,501.00 111,958.00 88,042.00 0.00 1,676,543.00 200,000.00 Total Lease 5,510,278.00 2 160 211.00 1 292 321.00 1 107 679.00 0.00 1 1,867,890.00 400 000.00 Total Redeve /opment commisslon 167,529,086.70 93,896,698.92 1 9,321,741.51 1 4,422,669.49 293,788.00 1 84,868,745.41 13,744,411.00 Financial Report Maroh 2014 - Debt City of South Bend Period Ending; March 2014 Monthly Debt Schedule Year of I Year of Year of Scheduled Payments Debt (Orig / Ref•) Debt at YTD Principal YTD Interest YTD Debt at Debt Instrument Debt Purpose Issue Refunding Maturi Fund let 2nd 3rd 4th Issue 12/31/2013 Pa ments Payments ALMons 1 3131 12014 Bond Debt Fire Equipment 2007 2012 288 6/1 12/1 - - 621,520.00 0.00 0.00 Arran scb k LED Equipment 2007 2017 101 1/1 711 - - 1,531,573.00 730,258.41 84,662.30 15,627.53 645,596.11 3/ CEDIT Bond Police Vehicles 1997 2006 2017 408 2/1 8/1 - - 11,870,000.00 2,815,000.00 375,000.00 65,050.00 2,440,000.00 36 South Bend Building Corporation Public Works Building 2001 2010 2021 404/649 2/1 8/1 - - 9,250,000.00 4,385,000.00 260,000.00 74,763.00 4,125,000.00 25 Water Works Improvements Water Works 2002 2012 2023 625 711 12/31 - - 5,975,000.00 3,450,000.00 0.00 3,450,000.00 39 South Bend Building Corporation Fire HO / Police HO 2003 2012 2023 404/324 2/1 8/1 - - 21,335,000.00 12,365,000.00 555,000.00 227,167.50 11,810,000.00 41 Sawage Works Improvements Sewage Works 2004 2013 2024 649 611 12/1 - - 11,425,000.00 0.00 0.00 0.00 24 Water Works Improvements Water Works 2006 2014 2027 625 7/1 12/31 - - 4,710,000.00 3,505,000.00 78,167.28 78,167.28 1,450.00 3,505,000.00 42 Sewage Works Improvements Sewage Works 2006 2014 2026 649 6/1 12/1 - - 7,630,000.00 6,090,000.00 638.84 638.84 10.63 6,090,000.00 4o Sawage Works Improvements Sewage Works 2007 2015 2027 649 6/1 12/1 - - 16,600,000.00 13,010,000.00 2,594.75 499.11 50.53 13,010,000.00 52 Sewage We Revenue Bonds 2007B Sawage Works 2007 2014 2027 649 6/1 12/1 - - 16,515,000.00 12,960,000.00 651.47 651.47 10.84 12,960,000.00 62 Century Center Special Tax Bonds Century Center 2008 2014 2028 420 5/1 11/1 - - 46 500000 3,990,000.00 14,236.41 3,990,000.00 69 Water Works Improvements Water Works 2009 2015 2030 625 7/1 12131 - - 5,380,000.00 4,985,000.00 4,362.77 700.86 64.14 4,985,000.00 7o Sewage Works Revenue Bonds -2009 Sewage Works 2009 2015 2028 649 6/1 12/1 - - 3,297,000.00 2,710,898.00 1,161.97 186.33 17.52 2,710,898.00 so 2010 Sawage Works Revenue Bonds Sewage Works 2010 2015 2030 649 6/1 12/1 - - 9,345,000.00 8,270,000.00 3,564.45 480.22 69.42 8,270,000.00 93 Sewage Works Revenue Bonds 2011 Sewage Works 2011 2015 2031 649 6/1 12/1 - - 21,500,000.00 19,895,000.00 4,702.41 19,895,000.00 99 2012 Water Works Revenue Bond Water Works 2012 2015 2033 625 1/1 7/1 - - 8,300,000.00 7,960,000.00 340,000.00 118,643.13 0.00 7,620,000.00 101 2012 Sewage Works Revenue Bonds Sewage Works 2012 2016 2032 649 6/1 12/1 - - 25,000,000.00 23,985,000.00 1,059,040.84 103,619.75 5,121.60 23,985,000.00 fo5 2013A Sewer Bond Refunding Sewage Works 2013 2013 2024 649 6/1 12/1 - - 14,765,000.00 13,700,000.00 116,115.23 10,338.06 483.33 13,700,000.00 116 2013 Building Corporation xxx EMS / Fire Department 2013 2016 2033 288 2/1 8/1 - - 5,580,000.00 5,580,000.00 2,065.68 45,244.50 28.79 5,580,000.00 Total Bond Debt IT Phone System 2011 2016 404 1/15 225 632 000.00 149 655 898.00 1,530,000.00 530 868.13 0.00 148 125 898.00 Loans Payable Mayor Ricoh MP 2851 SP Copies 2011 2016 101 2115 5/15 8/15 11/15 2,569.53 1,620.15 124.78 22.34 1,495.37 1 State Rev olvng Fund Bosch Property 2002 2016 2022 210 1/30 4/30 7/30 10/30 506,448.00 0.00 0.00 0.00 0.00 6e State Revolving Fund Water Works Improvement 2009 2017 2030 625 711 17131 - - 427,332.00 391,297.00 918,678.73 391,297.00 82 Interfund Loan 410 - UDAG tat Source/Marriott Garage 2010 2017 2015 410 6/15 12/15 - - 2,700,000.00 2,027,973.00 669,405.77 2,027,973.00 44 State Revolving Fund Sewage Works Improvement 1998 2017 2018 649 6/1 12/1 - - 24,095,000.00 0.00 2,257,055.55 275,754.03 290,475.67 0.00 26 State Revolving Fund Water Works Improvements 2000 2017 2019 625 7/1 12/31 - - 2,600,000.00 1,018,815.00 4,278.32 271.21 59.26 1,018,815.00 Capital Leases 27 LaSalle Bank - Fire Fire Equipment 2007 2012 288 6/1 12/1 - - 621,520.00 0.00 0.00 sf Chase LED Equipment 2007 2017 101 1/1 711 - - 1,531,573.00 730,258.41 84,662.30 15,627.53 645,596.11 m Commerce Bank Police Vehicles 2008 2008 406 6/1 12/1 - - 963,508.00 0.00 0.00 56 Oce Copier 209 N Main 2008 2013 620 Monthly - - - 12,078.21 0.00 0.00 57 Lanier Copier 830 N Michigan 2008 2013 620 Monthly - - - 5,154.00 0.00 0.00 5s Lanier Copier 915 Oil- 2008 2013 620 Monthly - - - 5,154.00 0.00 0.00 5e Lanier Copier Street 2008 2013 202 Monthly - - - 4,300.00 0.00 0.00 67 Sun Trust Solid Waste Containers/Trucks 2009 2014 611 3/1 9/1 - - 720,990.00 78,167.28 78,167.28 1,450.00 0.00 71 Kansas State Bank Clerk Lanier Oce Copier 2010 2014 101 1/23 4/23 7/23 10/23 9,209.00 638.84 638.84 10.63 0.00 n Kansas State Bank Code Enforcement Oce Copier 2010 2015 101 1/23 4/23 7/23 10/23 9,209.00 2,594.75 499.11 50.53 2,095.64 73 Kansas State Bank Engineering Lanier Oce Copier 2010 2014 101 1/23 4/23 7/23 10/23 9,391.00 651.47 651.47 10.84 0.00 74 CSI Leasing Inc IT Netapp San 2010 2014 404 4/1 7/1 10/1 12/31 207,521.37 14,236.41 14,236.41 76 Kansas State Bank Central Services Copier 2010 2015 222 2116 5/16 8/16 11/16 13,366.40 4,362.77 700.86 64.14 3,661.91 n GE Capital Information Technology Animal Control Copier 2010 2015 101 2/28 5/30 8/30 11130 3,550.69 1,161.97 186.33 17.52 975.64 78 Kansas State Bank Mayor Oce Copier 2010 2015 101 1/8 4/8 7/8 10/8 9,209.00 3,564.45 480.22 69.42 3,084.23 7s Advanced Imaging Central Services Duplicators 2010 2015 222 1/15 4/15 7/15 10/15 10,511.02 4,702.41 4,702.41 87 Public Finance.com Inc Solid Waste Containers /Trucks 2011 2015 611 6/15 12115 - - 321,853.00 133,252.34 133,252.34 es Sun Trust Police, Parks, Bldg vehicles 2011 2016 404/201/600 3/15 6/15 9/15 12/15 2,068,202.00 1,059,040.84 103,619.75 5,121.60 955,421.09 so Capital One Public Funding Solid Waste Containers /Trucks 2011 2016 611 3/15 6/15 9/15 12115 207,432.00 116,115.23 10,338.06 483.33 105,777.17 s1 GE Capital Information Technology Police Dept Copier 2011 2016 101 1/11 4/11 7/11 10/11 3,836.00 2,065.68 193.39 28.79 1,872.29 s2 Key Finance IT Phone System 2011 2016 404 1/15 1,444,995.97 843,595.57 274,272.26 21,127.15 569,323.31 s4 Ikon Office Solutions Mayor Ricoh MP 2851 SP Copies 2011 2016 101 2115 5/15 8/15 11/15 2,569.53 1,620.15 124.78 22.34 1,495.37 s5 Sun Trust Equipment Finance Parks -Golf Cars Lease 2012 2016 201 4/15 10/15 - - 344,500.00 218,030.66 218,030.66 s7 Sun Trust Equipment Finance Police Vehicles & Equipment 2012 2017 406 5/15 11/15 - - 1,295,000.00 918,678.73 918,678.73 s8 PNC Equipment Finance Public Works Vehicles Lease 2012 2017 202/641/640 5/15 11/15 - - 945,674.38 669,405.77 669,405.77 too PNC Equipment Finance Public Works Vehicles Lease 2012 2017 202/641/600/288 1/15 7/15 - - 2,806,054.00 2,257,055.55 275,754.03 290,475.67 1,981,301.52 foe Ikon Office Solutions / Ricoh Wastewater Copier 2012 2017 641 Monthly 1st 5,744.95 4,278.32 271.21 59.26 4,007.11 1. GE Capital Information Technology Fire Department Copier 2012 2017 101 2/28 5/28 8/28 11/28 5,471.01 4,249.41 255.21 62.49 3,994.20 Ice Ricoh USA Central Services Copier 2013 2018 222 2127 5/27 8/27 11/27 3,622.78 3,004.64 181.89 28.05 2,822.75 107 Ricoh USA Street/Sewer Dept Copier 2013 2018 202/641 3/4 6/4 9/4 12/4 5,559.15 4,506.34 252.20 65.50 4,254.14 toe Ricoh USA City Attorney Copier 2013 2018 101 2/12 5112 8112 11/12 5,559.15 4,528.32 273.87 43.82 4,254.45 127 Ricoh USA Parks & R. Ricoh Copiers(3) 2013 2018 201 2/21 5/21 8/21 11121 16,129.94 13,138.49 794.75 127.06 12,343.74 11c INC Equipment Finance Vehide/Equipirent Lease 2013 2018 1011202/406/641 1115 7115 - - 1,689,669.59 1,689,669.59 162,086.32 12,863.94 1,527,583.27 111 Ricoh USA Engineering Plotter /Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10,667.67 8,694.31 460.94 187.06 8,233.37 112 Ricoh USA Building Dept. Copier 2013 2018 600 Monthly 4,093.64 3,854.47 182.31 52.44 3,672.16 113 Sun Trust Equipment Finance Police and PW vehicles 2013 2018 404/655/611/202 4/24 10/24 - - 1,506,465.26 1,506,465.26 1,506,465.26 114 Ricoh USA Admin & Finance Copier 2013 2018 101 1116 4116 7116 10/16 11,247.97 9,620.91 502.88 139.93 9,118.03 115 CSI Leasing Inc 2010 Server IT Lease 2010 2014 404 2/1 5/1 8/1 11/1 28,588.00 5,869.74 1,928.70 84.50 3,941.04 117 Police Dept. Record Div. Ricoh Police Records Copier 2013 2018 101 Monthly 3rd 9,678.26 9,678.26 423.15 131.85 9,255.11 118 Water Works Main Ricoh Copier Water Works Main Ricoh Copier 2013 2018 620 Monthly 10th 5,647.50 5,647.50 246.84 77.01 5,400.66 119 Water Works Colfax Ricoh Copier Water Works Colfax Ricoh Copie 2013 2018 620 Monthly 16th 4,732.65 4,732.65 206.85 64.53 4,525.80 12o Water Works Olive Ricoh Copier Water Works Olive Ricoh Copier 2013 2018 620 Monthly 10th 4,732.65 4,732.65 206.85 64.53 4,525.80 Financial RepW March 2014 - Debt Page 23 0/28 City of South Bend Monthly Debt Schedule Period Ending; March 2014 Year of I Year of Year of Scheduled Payments Debt (Orig / Reh) Debt at YTD Principal YTD Interest YTD Debt at Debt Instrument Debt Purpose Issue Refunding Maturi Fund let 2rd 3rd 4th Issue 12/31/2013 Payments Payments Atidttions 1 3131 12014 Redevelopment Commission Debt Bond Debt 9 Central Business TIF 1990 1996 2012 420 2J 1 8/1 - - 3,790,000.00 0.00 0.00 0.00 0.00 0.00 to Blackthom Golf Course Blackthorn Golf 1992 1998 2013 619 3/1 9/1 - - 6,135,000.00 0.00 0.00 0.00 0.00 0.00 7 Century Center Lease Rental Revenue Century Center 1994 2001/2011 2018 407 2J 1 811 - - 6,825,000.00 2,070,000.00 220,000.00 24,275.00 0.00 1,850,000.00 a College Football Hall of Fame Hall of Fame 1994 2000/2011 2018 313 211 8/1 - - 15,370,000.00 5,285,000.00 560,000.00 71,083.75 0.00 4,725,000.00 tt South Bend Building Corporation Morris PAC 1998 2009 2017 408 2J 1 811 - - 13,300,000.00 3,380,000.00 455,000.00 64,112.50 0.00 2,925,000.00 12 TJX Special Taxing District 2002 2022 324/404/414 1/1 7/1 - - 6,620,000.00 3,405,000.00 345,000.00 83,256.25 0.00 3,060,000.00 5 Downtown Central Area TIF 2003 2011 2024 420 2J1 811 - - 19,795,000.00 16,120,000.00 570,000.00 385,676.25 0.00 15,550,000.00 s Airport Development Area TIF Airport TIF 2003 2011 2024 324 211 8/1 - - 14,420,000.00 9,195,000.00 325,000.00 219,970.75 0.00 8,870,000.00 22 Erskine Village TIF Development Bond Erskine Village 2005 2027 432 2J 1 8/1 - - 5,485,000.00 4,465,000.00 210,000.00 143,950.00 0.00 4,255,000.00 sa Lease Rental Revenue Bonds of 2008 Eddy Street Commons 2008 2027 429 2/15 8/15 - - 36,000,000.00 34,050,000.00 510,000.00 952,534.00 0.00 33,540,000.00 at Coveleski Stadium Recovery Coveleski Stadium 2010 2019 377 1/15 7/15 - - 4,980,000.00 3,520,000.00 300,000.00 82,872.50 0.00 3,220,000.00 96 SB Economic Develop Revenue Bonds Career Academy 2011 2014 324 2/15 5/15 8/15 11/15 1,500,000.00 500,000.00 125,000.00 5,000.00 0.00 375,000.00 too 2012 Gates Downtown Campus VA Clinic Agmt Loan 2012 2015 420 3/1 8/1 - - 1,700,000.00 1,133,333.34 283,333.33 0.00 0.00 850,000.01 121 Blackthorn Golf Cart Lease xxx Blackthorn Golf 2014 2019 619 Monthly 14th 293,788.00 0.00 0.00 0.00 293,788.00 293,788.00 Total Bond Debt 139 713 788.00 83 123 333.34 3,903,333.33 2 032 731.00 293 788.00 79 513 788.01 Loans Payable 3 Indiana Development Finance Authority Bosch Property (Nonforgive) 2001 2021 210 3/22 6/22 9/22 12/22 1,040,000.00 482,021.41 14,387.45 3,615.16 0.00 467,633.96 4 Indiana Development Finance Authority Bosch Property (Forgive) 2001 2021 210 - - - - 260,000.00 133,214.96 0.00 133,214.96 2 State Industrial Development Fund Bosch Property 2002 2017 210 4/1 10/1 - - 1,000,000.00 0.00 0.00 0.00 14 Indiana Development Finance Authority Frederickson Park 2003 2012 404 3131 6130 9130 12131 764,809.60 0.00 0.00 0.00 15 Indiana Development Finance Authority Frederickson Park (Forgive) 2003 2012 404 - - - - 191,202.40 0.00 0.00 0.00 is Indiana Development Finance Authority Anchor 2005 2014 404 6/30 12131 - - 600,000.00 66,666.72 0.00 66,666.72 17 Indiana Development Finance Authority Anchor (Forgive) 2005 2014 404 - - - - 75,000.00 10,714.32 0.00 10,714.32 so HUD Section 108#8 Studebaker Oliver 2008 2025 434 211 811 - - 4,000,000.00 1,005,000.00 20,974.00 0.00 1,005,000.00 w City of Mishawaka Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1,102,549.56 343,532.46 45,199.69 8,588.31 0.00 298,332.77 sa Intertund Fund 412 - Major Moves Douglas Road TIF 2009 2029 435 7115 8/15 - - 1,040,319.00 923,829.00 18,347.00 23,096.00 0.00 905,482.00 a1 in erfund Fund 619 - Blackthom Blackthorn Equip (golf carts) 2010 2017 619 5/15 6/15 7/15 8/15 31,032.00 15,516.00 0.00 15,516.00 84 Interfund Fund 412 - Major Moves Triangle Development 2011 2029 436 2115 8115 - - 2,000,000.00 1,558,050.00 0.00 1,558,050.00 85 Intedund Fund 412 - Major Moves Eddy Street Commons 2011 2026 436 2/15 8/15 - - 4,100,000.00 3,430,958.01 100,444.05 85,773.95 0.00 3,330,513.96 es Interfund Fund 209 to Airport 324 Prairie Ave Brownfield Project 2011 2020 324 819 - - - 500,000.00 500,000.00 0.00 500,000.00 ae Blackthom Loan from Airport Blackthorn Equip (mowers) 2011 2018 619 5/15 6/15 7/15 8/15 53,598.50 36,848.90 0.00 36,848.90 Total Loans Pa able 22058511. 178 378.19 142 047.42 0.00 8,327,973.59 Capital Lease 75 PNC Equipment Financing Blackthorn Golf Carts 2010 2015 619 Monthly 246,509.64 106,802.80 1,321.54 0.00 106,802.80 Total Capital Lease 246,509.64 106,802.80 0.00 1,321.54 0.00 106,802.80 Leases 37 Transpo Lease Leighton Plaza Garage 2001 2015 404 6/30 12/30 - - 3,000,000.00 371,710.00 0.00 371,710.00 13 Transpo Lease xxz Main / Colfax Garage 2006 2025 404 3/15 9/15 - - 2,510,278.00 1,788,501.00 55,288.00 44,712.00 0.00 1,733,213.00 Total Lease 5,510,278.00 2 160 211.00 1 55 288.00 1 44 712.00 0.00 2,104,923.00 Total Redevelopment Commission 167,529,086.70 93,896,698.92 1 4,136,999.52 1 2,220,811.96 293,788.00 90,053,487.40 Financial Repent March 2014 - Debt Page 24 0/28 City of South Bend Staffing Headcount Summary City Total 1328.00 1316.00 1298.00 1.00 4.00 3.00 2.00 2.00 2.00 2.00 1.00 1.00 0.00 Financial Report March 2014 - Headcount Staffing Page 25 of 28 Budget I I I I I I I Prior Full Time Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec I Year End Full Time Staff 1160.00 1116.00 1104.00 1106.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Part Time Staff 74.00 74.00 71.00 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Temporary /Seasonal 1 138.00 138.00 121.00 1.00 3.00 3.00 2.00 2.00 2.00 2.00 1.00 1.00 0.00 City Total 1328.00 1316.00 1298.00 1.00 4.00 3.00 2.00 2.00 2.00 2.00 1.00 1.00 0.00 Financial Report March 2014 - Headcount Staffing Page 25 of 28 City of South Bend Staffing Headcount Full Time Staff General Government Mayor 7.00 7.00 7.00 7.00 311 Call Center 7.00 7.00 7.00 7.00 Admin & Finance 23.00 21.00 21.00 21.00 Safety & Risk 3.00 3.00 3.00 3.00 Clerk 5.00 5.00 5.00 5.00 Common Council 9.00 9.00 9.00 9.00 L al De artment 10.00 9.00 9.00 9.00 Sub Total 64.00 61.00 61.00 61.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Code Enfor. /Animal Control 26.00 24.00 21.00 21.00 Dept. of Community Investment 26.00 26.00 26.00 26.00 Parks & Recreation Public Safety Public Works Administration 12.00 11.00 11.00 11.00 Maintenance 44.00 44.00 44.00 44.00 Golf Operations 8.00 8.00 8.00 8.00 Recreation Cps/ 26.00 26.00 26.00 27.00 Zoological Ops 23.00 3.00 3.00 3.00 Greenhouse Ops 0.00 0.00 0.00 0.00 Graffiti Removal 1.00 1.00 1.00 1.00 Recreation Nonreverting 1.00 1.00 1.00 1.00 Sub Total 115.00 94.00 94.00 95.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Police 297.00 289.00 283.00 285.00 Communications 38.00 32.00 33.00 34.00 Fire 260.00 263.00 260.00 261.00 Sub Total 595.00 584.00 576.00 580.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Central Services 40.00 37.00 37.00 37.00 Engineering 16.00 14.00 14.00 16.00 Maintenance 3.00 3.00 3.00 3.00 Solid Waste Operations 25.00 25.00 25.00 25.00 Street Operations 60.00 60.00 60.00 59.00 Sewer Operations 35.00 35.00 35.00 32.00 Waste Water Ops 44.00 44.00 44.00 44.00 Organic Resources 6.00 6.00 6.00 6.00 Water Utilit O s 70.00 69.00 69.00 68.00 Sub Total 299.00 293.00 293.00 290.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Building Department 15.00 14.00 13.00 13.00 Human Rights 6.00 6.00 6.00 6.00 Morris & Palais 14.00 14.00 14.00 14.00 City Total 1160.00 1116.00 1104.00 1106.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report March 2014 - Headcount Staffing Page 26 of 28 City of South Bend Staffing Headcount Part Time Staff General Government Code Ent. /Animal Control Prior Jan Feb Mar I Apr May I Jun I Jul Aug I Sep I Oct Nov I Dec Year End Mayor 1.00 1.00 1.00 Admin & Finance Clerk Common Council Le al De artment 4.00 4.00 4.00 Sub Total 5.00 5.00 5.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2.00 2.00 2.00 Dept. of Community Investment 1.00 1.00 Parks & Recreation Public Safety Administration 5.00 5.00 5.00 Maintenance 3.00 3.00 3.00 Golf Operations 4.00 4.00 1.00 Recreation Ops 30.00 30.00 28.00 Zoological Ops 6.00 6.00 3.00 Greenhouse Ops 2.00 2.00 2.00 Graffiti Removal 3.00 3.00 5.00 Sub Total 44.00 44.00 40.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Police 4.00 4.00 5.00 Communications Fire 1.00 1.00 1.00 Sub Total 5.00 5.00 6.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Public Works 1.00 5.00 1.00 5.00 2.00 0.00 5.00 Central Services 1.00 1.00 1.00 1.00 0.00 Engineering 4.00 4.00 2.00 Traffic & Lighting Maintenance Solid Waste Ops 2.00 2.00 2.00 Street Ops 3.00 3.00 5.00 Sewer Ops Waste Water Ops Water Utilit Ops 1.00 1.00 1.00 Sub Total 11.00 11.00 11.00 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Building Department 0.00 Human Rights Morris & Palais 1.00 5.00 1.00 5.00 2.00 0.00 5.00 City Total 74.00 74.00 71.00 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report March 2014 - Headcount Staffing Page 27 of 28 City of South Bend Staffing Headcount Temporay,Seasonal, and Intern Staff Public Works Building Department Human Rights Morris & Palais Central Services Engineering 1.00 1.00 1.00 Traffic & Lighting Maintenance Prior Solid Waste Ops Jan Feb Mar Apr P I May y l Jun Jul Au Aug l Se P Oct Nov Dec Year End General Government Waste Water Ops Organic Resources 1.00 1.00 1.00 Water Utilit Ops 3.00 3.00 3.00 Sub Total 20.00 Mayor 17.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Admin & Finance 1.00 2.00 2.00 Clerk Common Council Le al Sub Total 1.00 2.00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Code Enforcement 1.00 0.00 1.00 1.00 3.00 3.00 2.00 2.00 2.00 2.00 1.00 1.00 0.00 Dept. of Community Investment Parks & Recreation Administration 5.00 5.00 5.00 Maintenance 17.00 17.00 9.00 Golf Operations 1.00 1.00 24.00 Recreation Ops 51.00 51.00 35.00 Zoological Ops 0.00 0.00 0.00 Greenhouse Ops 0.00 0.00 0.00 Graffiti Removal 1.00 1.00 1.00 Sub Total 75.00 75.00 74.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Public Safety Police 41.00 41.00 27.00 Communications Fire Sub Total 41.00 41.00 27.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Public Works Building Department Human Rights Morris & Palais Central Services Engineering 1.00 1.00 1.00 Traffic & Lighting Maintenance Solid Waste Ops 8.00 8.00 5.00 Street Ops 2.00 2.00 2.00 Sewer Ops 5.00 5.00 5.00 Leaf Pickup Waste Water Ops Organic Resources 1.00 1.00 1.00 Water Utilit Ops 3.00 3.00 3.00 Sub Total 20.00 20.00 17.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 City Total 138.00 138.00 121.00 1.00 3.00 3.00 2.00 2.00 2.00 2.00 1.00 1.00 0.00 Financial Report March 2014 - Headcount Staffing Page 28 of 28