The URL can be used to link to this page

Home My WebLink About02-2014 Financial ReportPeriod Ending: Issued BY: February 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 February 2014 Page 1 of 28 February 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 10 %. In comparison, the collected revenue amount for February 2013 was 10% 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. Revenue by fund As of February 2014, the general fund has received 4% of its budgeted revenue versus 7% 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 55% of its budgeted revenue. Last month, 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 February 2014, the City has spent 13% of budgeted expenditures compared to 13% of budgeted expenditures in February 2013. The General Fund has spent 17% of its 2014 budgeted expenditures, compared to 14% 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 February, several debt service payments were made in the amount of - $4.3 million to Bank of New York, 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 February, 2014 was 1,104 vs. a budgeted amount of 1,160. Currently, there are a total of 56 open positions. The open positions are in Parks (21), Public Safety (19), Public Works (6), Code Enforcement and Animal Control (5) and other (5). City of South Bend Period Ending: February 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 CREED Tax 312 Auto Excise Tax 311 Pro a Tax Civil City various 299 2,504,793 0% 45,307,800 0% 311 Pro a Tax TIF Districts various 882,628 0% 312 Financial Institutions Tax 26,325,126 0% 311 Pro a Tax Civil City - Prior various NA 317 Hotel Motel Tax Century Center 670 656,725 NA 311 Property Tax TIF Districts - Prior various 317 Hotel Motel Tax Century Center 420 362,053 401,000 NA xxx xxx xxx 407 335 Liquor Gallonage Tax 150,000 0% NA Sub Total 377 66,547 NA 71,632,926 0% Income Tax XXX NA xxx xxx xxx 109,590 315 Econ Development Income Tax -Prh 102 NA 342 EMS County Contract 101 136,239 136,239 NA 315 Econ Development Income Tax 408 733,068 733,068 1,466,137 8,796,821 17% 316 Local Option Income Tax -PS 249 531,669 531,669 1,063,338 6,380,029 17% 316 County Option Income Tax 404 720,484 720,484 1,440,968 8,645,811 17% 316 County Option Income Tax -Prior Yr 102 1,011,355 5,326,329 26,031,652 20% NA Sub Total 1,985,222 1,985,222 3,970,443 23,822,661 17% St Joseph Count Remitted b 312 CREED Tax 312 Auto Excise Tax various 299 2,504,793 0% 312 Commercial Vehicle Tax van.ous 335 State Pension Subsidy 882,628 0% 312 Financial Institutions Tax van.ous 439 yment in Lieu of Tax NA 317 Hotel Motel Tax Century Center 670 656,725 1,313,436 0% 317 Hotel Motel Tax Century Center 420 362,053 401,000 0% 317 Hotel Motel Tax Cum Cap Im ry 407 335 Liquor Gallonage Tax 150,000 0% 21,000,000 335 Prof Sports Development Tax 377 66,547 NA xxx xxx xxx K XXX NA xxx xxx xxx 109,590 xxx xxx NA 342 EMS County Contract 101 136,239 136,239 1,588,824 0% xxx xxx xxx various 138,730 NA Sub Total 2,156,750 136,239 792,964 929,203 6,840,681 14% State of Indiana (Remitted by) 312 CREED Tax 434 decal Drug 299 335 Cigarette Tax 1011407 235,157 75,000 335 State Pension Subsidy 7011702 340 General Government Misc Ch s 101 335 CTP Distribution 439 yment in Lieu of Tax various 335 Gaming Proceeds 101 755,530 4,533,175 335 Gasoline Tax 2021251 337,414 362,053 335 Liquor Excise tax 101 nds various 335 Liquor Gallonage Tax 101 55,845 21,000,000 335 Prof Sports Development Tax 377 66,547 113,592 335 Century Center 671 K XXX 335 Wheel Tax 202 389,705 109,590 xxx xxx xxx 391,184 388,948 Sub Total 25,841,975 459,805 585,235 governmental Sources decal Drug 299 226 235,157 235,157 75,000 ite Drug 216 340 General Government Misc Ch s 101 35,000 yment in Lieu of Tax various 377,765 377,765 755,530 4,533,175 ntractual Service 211 13,419 11,183 24,602 198,800 nds various 432,838 2,600,000 17% 21,000,000 nd premium 6611623 49,015 96,676 619,002 16% K XXX 204,221 185,484 389,705 2,545,960 b Total 380 Energy Office Reimbursements 391,184 388,948 780,132 25,841,975 Charge for Service Internal City 340 Liability Insurance 226 235,157 235,157 470,314 2,859,690 16% 340 General Government Misc Ch s 101 NA 340 Police Take Home Vehicle 278 7,160 4,730 11,890 60,580 20% 342 EMS Capital 288 151,160 281,678 432,838 2,600,000 17% 349 Central Service 222 47,661 49,015 96,676 619,002 16% 380 Central Service 222 204,221 185,484 389,705 2,545,960 15% 380 Energy Office Reimbursements 222 417,066 432,016 849,082 4,632,222 18% 380 Internal Service Reimbursement various 138,730 122,721 261,452 2,156,750 12% 392 Administration Fee 101 289,249 289,249 578,498 3,470,989 17% 392 Internal Fund Transfers various 4,314,974 1,011,355 5,326,329 26,031,652 20% 395 Employee Benefits various 946,856 995,209 1,942,065 13,621,548 14% Financial Report February 2014 - Revenue Report Page 3 or28 City of South Bend Revenue by Type Report Period Ending: February 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 NA xxx xxx xxx NA Sub Total 6,753,998 3,608,413 10,362,411 58,620,393 18% 3rd Party Revenue 331 Federal Grants 340 ND EMS Service 101 4,518,787 8% 90,000 0% 340 Memorial Hospital Neo Natal 101 40,938 39,124 80,062 365,000 22% 350 Job Target Penalty Fee 408 354,660 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 671,122 1,761,660 38 Grants 331 Federal Grants various 186,142 152,888 339,030 4,518,787 8% 334 State Grants various 215,000 215,000 215,000 100% 360 UDAG 410 NA xxx xxx NA Sub Total 401,142 152,888 554,030 4,733,787 12% 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 Financial Report February 2014 - Revenue Report Page 4 028 City of South Bend Period Ending: February 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 Centu Center 670 1,805 7,700 9,505 45,000 21% 360 Code 1011600 46 51 96 1,000 109/ 360 Cumulative Capital Improvement 4061407 van.ous 12,000 hicle Damage Reimbursement various NA 360 Dept. Of Community Investment 2111212 XXX 6 6 283,000 0% 360 Stud. /Oliver Rev. Grants 209 300,000 0% 360 EMS Capital 288 59 117 176 16,000 1% 360 Engineering/ Curb & Sidewalk 101 89 189 279 22,000 1% 360 Fire 701 NA 360 Police Pension Fund 702 4,000 0% 360 General Government Various 101131226 36,377 36,377 1,100 3307% 360 P -Card Commissions 101 80,000 0% 360 General SBCDA Account 420 NA 360 Hall of Fame 3131677 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 15,143 25,000 61% 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,232 24,620 21% 360 Sewage Depreciation Fund 642 NA 360 Streets Scrap Metal Sale 101 NA 360 Water Works Utility 620 31,554 846 32,400 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 3,480 84,000 4% 362 Parks & Recreation 201 1,329 2,226 3,555 43,900 8% 362 S Bend School Corp Fee 407 25,000 0% 362 TIF Property various 14,675 17,473 32,148 201,951 169/ 362 UDAG 410 NA 369 Memorial Hosp Leighton Plaza 408 150,000 0% 371 Century Center Fees 670 90,135 146,746 236,881 3,031,462 T9 399 Bosch Retention Project 210 58,203 0% 399 Principal on Loan various 19,196 21,428 40,624 195,349 21% 399 Principal Income xxx 186,218 186,218 556,798 33% xxx xxx xxx NA Sub Total 4,937,828 5,353,133 10,290,961 70,123,276 15% ome nk Account Interest various 32,479 87,965 120,445 992,030 K XXX K XXX b Total 32,479 87,965 120,445 992,030 I Contribution 101 330,000 nations van.ous 268 22,291 22,559 32,740 K XXX b Total 268 22,291 22,559 362,740 enervation lais 450 1,796 334 2,130 16,000 ,neral Fund 101 _ _ _ _ _ _ _ _ _ _ _ _ _ _ K XXX b Total 1,796 334 2,130 16,000 ets 4207324 iter Hydrant Reimbursement 620 11,797 11,797 20,000 oceeds F.A. Disposal 600 1,500 to of Fixed Assets van.ous 12,000 hicle Damage Reimbursement various 1,000 K XXX b Total 11,797 11,797 34,500 Revenue Total 15,140,898 13,619,374 - - - - - - - - - - 28,760,272 287,194,697 101/ report 15,140, 898 13, 619, 374 28, 760,272 287,194, 697 Financial Report February 2014 - Revenue Report Page 5028 City of South Bend Revenue by Fund Report Period Ending: February 2014 s i Fund Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I Bud et I ofeud et General Government 0000 General Revenues 101 831,705 1,001,393 1,833,098 51,660,458 4% 0101 Mayor 101 227 151 379 600 63% 0104 311 Call Center 101 26,509 26,509 480,077 6% 0201 Clerk 101 NA 0301 Common Council 101 41 27 68 8,300 1% 0401 Controller 101 80,050 0% 0501 Legal 101 15 1,044 1,058 72,350 1% xxx xxx NA Sub Total 858,496 1,002,615 1,861,112 52,301,835 4% 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 68,142 337,700 20% 0802 Police Communications 101 NA 0805 Police -PS LOIT funded 101 NA 0901 Fire 101 41,063 39,253 80,316 1,616,000 5% 0905 Fire-PS LOIT funded 101 NA Sub Total 79,116 69,341 148,458 1,953,700 8% 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 NA 1207 Code Animal Control 101 NA xxx xxx NA Sub Total 2,150 2,150 NA Arts 8 Culture 0404 Morris PAC 101 56,152 47,987 104,139 882,000 12% 0405 Palais Royale 101 29,101 7,384 36,485 309,981 12% xxx xxx NA Sub Total 85,253 55,371 140,623 1,191,981 12% Human Rights 1008 Human Rights 101 NA xxx xxx NA Sub Total NA General Fund Revenue Total 1,025,130 1,127,327 - - - - - - - - - - 2,152,458 55,453,616 4% Financial Report February 2014 - Expenditure Summary Page 6 of 28 City of South Bend Revenue by Fund Report Period Ending: February 2014 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 61,214 62,071 123,285 8,770,213 1% 1100 Administration 201 1,551 2251 3,802 45,750 8% 1101 Maintenance 201 6,893 7,305 14,198 299,000 5% 1102 Golfo erations 201 2,568 71,543 68,975 1,582,000 4% 1103 Recreation Division 201 18,881 13,633 32,514 184,140 18% 1104 Potawatomi Zoo 201 265 265 NA 1106 Potawatomi Greenhouse 201 NA 1107 Community Svc Block Grant 201 NA 1108 Grafd Removal 201 6,464 6,425 IZ889 99,304 13% Recreation Non Reverting 203 76,057 104,016 180,073 1,449,592 12% East Race 144 terway 271 2 5 7 100 7% Coveleski Stadium 401 3 10 13 500 3% Zoo Endowment 403 6 18 24 2900 1% Park Non Reverting 405 79 7,670 7,748 195,700 4% xxx x xxx NA Sub Total 168,582 275,212 443,794 12,629,199 4% Public Works Motor Vehicle Ni hway 202 285,523 416,631 702,154 9,106,300 8% Central Services 222 670,844 738,759 1409,603 7847,374 18% Local Roads & Streets 251 87,148 91,181 178,329 1,088,000 16% Pro'ect ReLeaf 655 36,373 36,471 72,844 431,700 17% xxx xxx xxx NA Sub Total 1,079,887 1 283 043 Z362,930 18,473,374 13% Public Works Solid Waste Solid Waste Operations 610 400,585 396,447 797,032 5,257,701 15% Solid Waste Ca ital 611 230,437 27 230,464 736,202 31% xxx x xxx NA Sub Total 631,022 396,474 1027,495 5,993,903 17% Public Works Water Utility 0000 Water Works Revenues 620 863,045 1,048,116 1,911,161 12 655,313 15% 0630 Water Leak Insurance 620 80,687 80,448 161,135 960,000 17% 0640 Water Works 620 NA 0660 Clay Water 620 74,439 74,966 149,405 1,096,020 14% Waterworks Capital 622 453 1,296 1,749 10,000 17% Waterworks Construction 623 223 296 519 5,000 10% Waterworks Deposit 624 186 534 720 6,000 12% Waterworks Sinking 625 171,006 170,846 341,853 2,057,224 17% Waterworks Bond Reserve 626 8,761 9,130 17,892 90,073 20% Waterworks Debt Reserve 629 261 54,253 54,513 70,312 78% xxx xxx xxx NA Sub Total 1,199,062 1,439,885 Z638,947 16,949,942 1651 Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 47,833 46,355 94,188 549,200 17% 0000 Wastewater Revenues 641 2,517,238 2,480,217 4,997,455 32,588,386 15% 0621 Sewer Department 641 2,000 0% 0625 Concrete Crew 641 4,008 4,376 8,384 47,000 18% 0630 Wastewater Operations 641 NA 0631 Organic Resources 641 NA 0650 Clay Sewage 641 153,599 152,617 306,216 1,915,802 16% eCa ital 642 2,000,563 1,522 2,002,085 3,566,580 56% eReserve 643 130,386 1,221 131,607 238,715 55% r Bond 200612006 645 NA r Bond 2007 647 1 0 1 NA eBond Sinkin 649 775,028 775,371 1,550,399 9,804,645 16% ewa a General 650 NA a Bond 2007 651 NA a Works DS Reserve IN 653 NA CSO Net Sewer Bond 658 0 1 1 NA Sewer Bond 659 1,034 2810 3,844 25,000 15% Sewer Bond 661 2372 6,686 9,058 45,000 20% Sewer Bond 663 60,000 0% Sewer Refund Bonds 664 1 2 2 NA Sewer Bond 665 21,000,000 0% Sub Total 5,632,063 3,471,179 9,103,241 69,842,328 13% Financial Report February 2014 - Expenditure Summary Page 7 of 28 City of South Bend Revenue by Fund Report Period Ending: February 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 Police Seizures 216 20 58 78 35,900 0% Curfew Violations 218 14 39 53 1,025 5% Law Enforcement Education 220 30,247 12,673 42,920 211,000 20% Public Safety LOIT 249 531,895 532,362 1,064,258 6,391,029 17% Excess Welfare Public Safety 252 0 0 1 NA Police Take Home Vehicle 278 14,378 9,629 24,006 123,160 19% Police Block Grant 280 0 1 2 NA Police Grants 292 66,716 66,716 NA Pnlic-Academy 294 13,159 4,127 17,286 22,000 79% COPS More Grants 295 863 992 1,855 41,600 4% Drua Enforcement 299 91 81 172 77,000 0% K -9 Unit 705 0 1,000 1,001 2,000 50% xxx xxx Sub Total xxx 657,384 560,963 1,218,348 6,904,714 NA 18% Publie Safe - Fire enc Tele hone S stem 244 215,000 215,000 215,000 100% a ital U 288 154,587 286,614 441,201 2,661,000 17% t 289 2 6 8 10.000 0% River Rescue 291 Z412 Z435 4,848 45,200 11 xxx xxx xxx NA Sub Total 372,001 289,056 661,056 2,931,200 23% Department of Communi Investment Studebaker /Oliver 209 139 398 537 305,000 0% State Grant 210 85 128 213 77,016 0% DCI Operating 211 435,848 11,776 447,624 Z278,246 20% 0000 De t. of Community Investment 212 125,073 158,522 283,595 3,811,000 7% xxx Pro rams 212 NA 0000 Economic Revenue Bond 281 3 10 13 NA xxx xxx xxx NA Sub Total 561,149 170,834 731,983 6,471,262 11 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 February 2014 - Expenditure Summary Page 8 of 28 City of South Bend Revenue by Fund Report Period Ending: February 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,269 52,000 8% Gift Donation Be nest 217 10 21,140 21,150 7,290 290% Loss Recove 227 1,018 2,913 3,931 17,000 23% Human Ri hts 258 89 4,817 4,906 210,700 2% Morris Palais Marketing 273 354 3,005 3,359 8,100 41% Professional Sports Development 377 101,255 113,844 215,099 678,228 32% 1201 Code Enforcement 600 585,873 8,041 593,915 2,596,460 23% 1207 Animal Control 600 5,770 4,102 9,871 57,000 17% 1306 Building Operations 600 80,574 51,956 132,530 1,159,100 11% Century Center 670 101,443 830,395 931,838 4,564,898 20% Century Center Capital 671 30 30 100,500 0% xxx xxx xxx NA Sub Total 877,520 1,043,378 1,920,898 9,451,276 20% Business Insurance 0000 Business Insurance Revenues 226 235,841 273,423 509,264 2,881,690 18% 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 509,264 Z898,690 690 18% Fiducia Trust & Agency Fire Pension 701 157 330 488 5391,332 0% Police Pension 702 261 614 875 6,310,000 0% Police / Fire Pension lCi 703 NA Employee Benerits 711 939,099 988,883 1,927,982 13 418,450 14% Unemployment Comp 713 8,564 8,625 17,188 236,898 7% Cemtery Trust 730 5 14 18 250 7% xxx xxx xxx NA Sub Total 948,086 998,466 1946,552 25356,930 8% Civil City Revenues 15,022,977 13,469,813 - - - - - - - - - - 28,492,791 256,637,317 11% Tax Increment Financing rt 324 2,853 9,393 12,247 13,484,612 0% ral Develo ment 420 30,402 30,591 60,993 4,418,336 1% Washin ton 422 58 225 283 422,000 0% ton Plaza 425 9,940 15,407 25,347 164,303 15% cal Service RNortheast 426 371 1,141 1,512 1,615,000 0% east 429 349 1,104 1,453 827,000 0% hside 430 402 1,246 1,648 3,615,000 0% ine Commons 431 NA TIF Erskine Village 432 762 2,277 3,039 15,000 20% TIF Douglas Road 435 23 108 131 320,750 0% Northeast Residential TIF 436 244 920 1,164 2,510,000 0% xxx xxx xxx NA Sub Total 45,404 62,412 107,816 27,392,001 0% Financial Report February 2014 - Expenditure Summary Page 9 of 28 City of South Bend Revenue by Fund Report Period Ending: February 2014 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 of Bud et Redevelo ment Funds Central Bond Proceeds 305 NA District Capital 2003 428 NA Administration 433 3 9 12 NA Coveleski Bond Construction 438 NA Certified Technology Park 439 472 1,352 1,824 1,453,000 0% Airport Urban Enterprise Zone 454 48 138 186 1,500 12% Blackthorn Golfo erations 619 71,571 84,446 156,016 1,696,879 9% xxx xxz xxx NA Sub Total 72,094 85,944 158,039 3,151,379 5% Debt Service Public Improvement 1990 314 - - - - - - - - - - - - - - NA Airport Debt Reserve 2003 315 133 381 515 5,000 10% Coveleski Bond Debt Reserve 317 65 185 249 3,000 8% Blackthorn Debt Service 319 NA Central Development reserve 328 223 637 860 6,000 14% xxx x xxx NA Sub Total 420 1,203 1,524 14,000 12% Redevelopment Commsssion 117,919 149,560 - - - - - - - - - - 267,479 30,557,380 1% City Operations Total 15,140,896 13,619,373 - - - - - - - - - - 28,760,270 287,194,697 10% Revenue report 15,140,898 13,619,374 28,760,272 287,194,697 2 0 0 0 0 0 0 0 0 0 0 0 2 0 Financial Report February 2014 - Expenditure Summary Page 10 of 28 City of South Bend Property Tax Revenue 2012 Tax Pay 2013 Fund Period Ending: February 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 February 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 February 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 February 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 February 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 February 2014 - Property Tax Revenue Page 15 of 28 City of South Bend Period Ending: February 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 125,973 711,711 1 Call Center 101 39,235 38,732 77,967 488,908 erk 101 33,254 24,949 58,202 394,608 ommon Council 101 33,804 16,129 49,933 472,598 ontroller 101 184,882 129,923 314,805 2,091,944 gal 101 111,670 74,144 185,814 1,025,635 K 4,994 4,176,421 3,539,947 8,316,368 47,969,186 ib Total 476,814 335,881 812,695 5,185,404 cs iergy Office 101 igineering 101 100,714 83,713 184,427 1,126,302 affic 8 Lighting 101 K ib Total 100, 714 83,713 184,427 1,126,302 ty We lice 101 2,352,204 1,889,108 4,241,312 24,725,204 Mice Communications 101 205,840 146,325 352,165 2,236,486 /ice -PS LOIT funded 101 ode Junk Vehicle 101 ,e 101 2,004,690 1,591,802 3,596,492 21,007,496 •e-PS LOIT funded 101 213,687 (87,288) 126,399 X K ib Total ib Total 4,994 4,176,421 3,539,947 8,316,368 47,969,186 cement We 101 740 3,642 4,382 5,225 eights and Measure 101 ode Hearing 101 ode Junk Vehicle 101 ode Unsafe Building 101 ode Animal Control 101 612 612 2,254 X ib Total 740 4,254 4,994 7,479 ire rrris PAC 101 87,838 86,253 174,091 1,063,527 dais Royale 101 43,724 31,427 75,151 523,710 K ib Total 131,562 117,680 249,242 1,587,237 Ws iman Rights 101 31,977 26,096 58,073 367,262 K ib Total 31,977 26,096 58,073 367,262 General Fund Expenditure Total 5,518,227 4,107,572 - - - - - - - - - - 9,625,799 56,242,870 17% Financial Report February 2014 - Expenditure Summary Page 16 0/ 28 City of South Bend Period Ending: February 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 1,036,900 5,439,463 )tor Vehicle Highway 1100 Administration 201 113,658 84,616 198,274 1,564,813 13% 1101 Maintenance 201 440,988 353,914 794,903 4,947,775 16% 1102 Golfo eradons 201 79,201 66,423 145,624 1,526,640 10% 1103 Recreation Division 201 195,148 128,820 323,968 2,114,512 15% 1104 Potawatomi Zoo 201 669,326 24,910 694,236 2,283,664 30% 1106 Potawatomi Greenhouse 201 8,161 7,588 15,750 59,614 26% 1107 Community Svc Block Grant 201 196 36 233 2,057,224 NA 1108 Graffiti Removal 201 7,701 4,982 IZ684 103,860 12% Recreation Non Reverting 203 42,584 72,465 115,049 1,479,064 8% East Race Waterway 271 10,346 0% Coveleski Stadium 401 1,220,608 1,289,727 2,510,335 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 - - - - 2,417,262 14,299,045 17% (s did Waste Operations 610 672,124 364,775 1,036,900 5,439,463 )tor Vehicle Highway 202 818,846 888,630 1,707,476 8,555,846 irb and Sidewalk 202 49,312 36,865 86,177 1,152,802 antral Services 222 672,962 610,722 1,283,684 7,796,032 Ical Roads &Streets 251 19,206 IZ316 31,522 1,124,520 oiect ReLeaf 655 14,433 3,216 17,648 430,114 X xxx 195,292 213,072 811,011 26% ib Total 624 1,574,759 1,551,748 3,126,507 19,059,314 rs Solid Waste did Waste Operations 610 672,124 364,775 1,036,900 5,439,463 ,11d Waste Capital 611 264,795 79,617 344,413 896,070 X xxx 71,687 132,318 ib Total 936,920 444,393 1,381,312 6,335,533 Public Works Water Utility 0630 Water Leak Insurance 620 60,631 71,687 132,318 1,115,000 12% 0640 Water Works 620 1,137,738 1,021,433 2,159,171 13,724,004 16% 0660 Clay Water 620 215 37,262 215 3,000 7% Waterworks Capital 622 3,600 1,880,989 3,600 978,258 0% Waterworks Construction 623 17,780 195,292 213,072 811,011 26% Waterworks Deposit 624 186 534 720 6,000 12% Waterworks Sinking 625 196 36 233 2,057,224 0% Waterworks Bond Reserve 626 422 1,221 1,643 15,000 NA Waterworks Debt Reserve 629 261 746 1,006 8,500 12% xxx xxx xxx 1,138 NA Sub Total 649 1,220,608 1,289,727 2,510,335 18,702,997 13% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 17,250 30,211 47,461 549,978 9% 0621 Sewer Repair 641 461,905 389,062 850,967 5,132,912 17% 0625 Concrete Crew 641 39,120 37,262 76,382 453,145 17% 0630 Wastewater Operations 641 4,020,021 1,880,989 5,901,010 28,766,521 21% 0631 Organic Resources 641 78,091 82,861 160,951 1,202,616 13% 0650 Clay Sewage 641 978 978 1,000 -98% Sewage Capital 642 978,994 416,435 1,395,429 9,267,941 15% Sewage Reserve 643 422 1,221 1,643 15,000 11% 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 541,236 13,598,486 4% 2012 Sewer Bond 661 272,470 216,156 488,626 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 - - - - - - - - - - 9,464,077 107,259,338 9% Financial Report February 2014 - Expenditure Summary Page 17 of 28 City of South Bend Period Ending: February 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 729,785 4,572,215 mmat Seizures 216 ver Rescue 291 199 1,283 1,483 52,300 40,000 0% Curfew Violations 218 449,407 281,861 731,268 4,634,515 ighton Plaza 1,000 0% Law Enforcement Education 220 11,075 20,490 31,565 294,802 11% Emer enc Tele hone System 244 27,387 16,003 43,391 215,000 20% Public Safe LOIT 249 517,291 613,746 1,131,036 7,214,658 16% IPolice Excess Welfare Public Safety 252 1,146 0% Police Take Home Vehicle 278 15,269 811 16,080 80,580 0% Police Block Grant 280 29,594 71,075 100,669 5,823,729 NA Police Grants 292 337,650 358,693 696,343 90,000 0% PoliceAcademy294 434 136 197 334 23,750 1% COPS More Grants 295 175 1,484 1,659 141,600 1% Drug Enforcement 299 6,273 2,731 2,731 151,499 2% K -9 Unit 705 2,000 0% xxx xxx xxx 4,831,372 709,183 5,540,555 29,073,445 NA Sub Total 556,065 654,651 - - - - - - - - - - 1,210,715 8,256,035 15% ty - Fire 4S Capital 288 449,207 280,578 729,785 4,572,215 mmat 289 10,000 ver Rescue 291 199 1,283 1,483 52,300 X xxx State Grant ib Total 449,407 281,861 731,268 4,634,515 De artmento mmunity Investment Z tin Street StudebakedOliver 209 15,801 38,533 203,425 1,385,000 0% State Grant 210 1,612,310 385,712 ighton Plaza 117,886 0% CEDO eretin 211 236,843 167,810 404,653 2,404,884 17% 1001 De t, of Communi Investment 212 85,538 190,071 275,609 6,499,680 4% 1002 Dept. of Community Investment 212 601 244,434 2,474,253 10,014,984 NA 1003 Administration 212 2,328 0% xxx Programs 212 15,269 811 16,080 408,775 4% xxx xxx xxx 29,594 71,075 100,669 5,823,729 NA Sub Total 416 337,650 358,693 696,343 10,818,553 6% Capital /Debt Service Z tin Street 601 22,732 15,801 38,533 203,425 Joseph 601 COIT 404 1,612,310 385,712 ighton Plaza 601 39,122 41,189 80,312 337,008 iforoement 601 13,486 4,479 17,965 90,606 ayne Street 601 21,424 12,784 34,208 150,869 Idy Street Commons 601 244,434 2,474,253 10,014,984 15,900 X xxx ib Total UDAG 96,764 74,254 171,018 797,808 Capital /Debt Service Hall of Fame 313 634,500 634,500 1,268,116 50% COIT 404 1,612,310 385,712 1,998,022 9,976,202 20% Cum Capital Development 406 112,650 112,650 722,935 16% Cum Capital Improvement 407 185,250 185,250 364,762 51% EDIT 408 2,229,819 244,434 2,474,253 10,014,984 25% Cumulative Sewer 409 NA UDAG 410 NA Major Moves 412 29,594 71,075 100,669 5,823,729 2% Morris PAC Improvement 416 53,200 0% 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 14,235 188,567 8% xxx xxx xxx NA Sub Total 4,831,372 709,183 5,540,555 29,073,445 19% Financial Report February 2014 - Expenditure Summary Page 18 of 28 City of South Bend Period Ending: February 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 39,009 253,743 Liability Insurance 226 NA 243,446 Gift, Donation, Bequest 217 Business Insurance 226 6,557 1,310 0% 572,300 Loss Recovery 227 5,154 6,805 11,958 5,615,805 0% xxx General Grant 250 0% 20,595 Sub Total xxx NA 490,442 Human Rights 258 19,647 10,646 30,293 224,001 14% 27,828,418 Morris Palais Marketing 273 3,628 617 3,628 8,100 45% 0% Economic Revenue Bond 281 81,949 8,298 90,247 6,487,957 NA TIF Erskine Commons ProfessionalSports Development 377 382,873 800 383,673 865,746 44% 1201 Code Enforcement 600 87,023 68,770 155,792 1,836,074 8% 1207 Animal Control 600 58,611 49,070 107,681 689,215 16% 1306 Building Operations 600 102,831 81,636 184,467 1,273,620 14% Century Center 670 314,629 427,425 742,053 4,564,898 16% 51,797,693 Century Center Capital 671 NA xxx xxx xxx NA Sub Total 974,395 645,150 1,619,545 15,078,769 115/ m Insurance Self Funded Liability Ins 226 20,289 18,720 39,009 253,743 Liability Insurance 226 39,002 243,446 282,448 1,028,811 Business Insurance 226 6,557 29,628 36,185 572,300 Workers Compensation 226 37,558 198,648 236,206 1,042,346 xxx xxx 319 657,534 0% 20,595 Sub Total xxx 103,406 490,442 593,848 2,897,200 y Trust & Agency Fire Pension 701 457,164 448,542 905,706 5,874,445 Police Pension 702 54Z603 643,997 1,186,599 7,221,941 Employee Benefits 711 526,930 1,807,630 2,334,560 14,483,463 Unemployment Comp 713 9,673 16,224 25,897 227,974 City Cemetery Trust 730 319 657,534 0% 20,595 xxx xxx 13,665 17,742 149,425 12% Sub Total 426 1,536,369 2,916,392 4,452,762 27,828,418 Civil City Expenditure 25,840,735 17,700,611 - - - - - - - - - - 43,541,345 321,283,840 14% Tax Increment Financing TIF Air ort 324 1,403,524 250,577 1,654,101 27,286,693 6% TIF Sam le Ewing 414 NA TIF Central Development 420 1,015,931 314,263 1,330,194 5,829,261 23% TIF West Washington 422 319 319 657,534 0% TIF Lei Leighton Plaza 425 4,077 13,665 17,742 149,425 12% 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 90,247 6,487,957 1% TIF Erskine Commons 431 NA TIF Erskine Villa a 432 354,606 354,606 494,151 72% TIF Dou las Road 435 160 160 399,823 0% Northeast 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 5,482,502 51,797,693 11% Financial Report February 2014 - Expenditure Summary Page 19 of 28 City of South Bend Period Ending: February 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 - - - - - - - - - - 5,591,185 57,100,399 10% central Bond Proceeds 305 City Operations Total 30,389,628 18,742,903 - - - - - - - - - - 49,132,530 NA District Capital 2003 428 133 381 515 NA Administration 433 6,072 6,072 20,000 30% Coveleski Bond Construction 438 NA CertlBed Technolo Park 439 223 637 3,600,000 0% Air ort Urban Zone 454 NA =Zone Blackthorn Golf 0 erations 619 47,557 53,680 101,236 1,671,706 6% xxx xxx xxx NA Sub Total 53,629 53,680 107,309 5,291,706 2% e 1,042,292 - - - - - - - - - - 5,591,185 57,100,399 10% iblic Improvement 1990 314 City Operations Total 30,389,628 18,742,903 - - - - - - - - - - 49,132,530 378,384,239 13% rport Debt Reserve 2003 315 133 381 515 5,000 rveleski Bond Debt Reserve 317 ackthorn Debt Service 319 ?ntral Development reserve 328 223 637 860 6,000 X xxx ib Total 356 1,019 1,374 11,000 Redevelopment Commsssion 4,548,893 1,042,292 - - - - - - - - - - 5,591,185 57,100,399 10% City Operations Total 30,389,628 18,742,903 - - - - - - - - - - 49,132,530 378,384,239 13% Expenditure report 30,389,627 18,742,903 49,132,530 378,384,239 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report February 2014 - Expenditure Summary Page 20 of 28 City of South Bend Debt Schedule Period Ending; February 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 Arri 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 12115 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 2128 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 Report February 2014 - Debt Page 21 0/28 City of South Bend Debt Schedule Period Ending; February 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 2nd 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 tfD 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 Repot February 2014 - Debl City of South Bend Period Ending; February 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 1231/2013 Pa ments Payments ALMons 1 22812014 Bond Debt Fire Equipment 2007 2012 288 6/1 12/1 - - 621,520.00 0.00 0.00 Amen 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 1231 - - 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 Z1 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 1231 - - 4,710,000.00 3,505,000.00 78,167.28 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 1231 - - 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 tot 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 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 13,700,000.00 tt6 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 Copiei 2011 2016 101 2115 5/15 8/15 11/15 2,569.53 1,620.15 124.78 22.34 1,495.37 t 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 ae State Revolving Fund Water Works Improvement 2009 2017 2030 625 711 1231 - - 427,332.00 391,297.00 918,678.73 391,297.00 82 lnterfund Loan 410 - UDAG tat Source/Marriott Garage 2010 2017 2015 410 6/15 1215 - - 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 180.38 39.93 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 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 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 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 1231 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 228 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 a7 Public Finance.- 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 1215 2,068,202.00 1,059,040.84 1,059,040.84 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 116,115.23 91 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 92 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 N 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 124.78 22.34 1,495.37 95 Sun Trust Equipment Finance Parks -Golf Cars Lease 2012 2016 201 4/15 10/15 - - 344,500.00 218,030.66 218,030.66 97 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 2021641/640 5/15 11/15 - - 945,674.38 669,405.77 669,405.77 fop 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 (o2 Ikon Office Solutions / Ricoh Wastewater Copier 2012 2017 641 Monthly 1st 5,744.95 4,278.32 180.38 39.93 4,097.94 103 GE Capital Information Technology Fire Department Copier 2012 2017 101 228 5/28 8/28 11/28 5,471.01 4,249.41 255.21 62.49 3,994.20 toe Ricoh USA Central Services Copier 2013 2018 222 227 5127 8/27 11/27 3,622.78 3,004.64 181.89 28.05 2,822.75 107 Ricoh USA StraeUSewer Dept Copier 2013 2018 202/641 3/4 6/4 9/4 12/4 5,559.15 4,506.34 4,506.34 foe Ricoh USA City Attorney Copier 2013 2018 101 2/12 5/12 8/12 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 221 5/21 8/21 11/21 16,129.94 13,138.49 794.75 127.06 12,343.74 (to PNC 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 8,694.31 112 Ricoh USA Building Dept. Copier 2013 2018 600 Monthly 4,093.64 3,854.47 121.26 35.24 3,733.21 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 Z1 5/1 8/1 11/1 28,588.00 5,869.74 1,928.70 84.50 3,941.04 fn Police Dept. Record Div. Ricoh Police Records Copier 2013 2018 101 Monthly 3rd 9,678.26 9,678.26 281.45 88.55 9,396.81 118 Water Works Main Ricoh Copier Water Works Main Ricoh Copier 2013 2018 620 Monthly 10th 5,647.50 5,647.50 164.18 51.72 5,483.32 119 Water Works Colfax Ricoh Copier Water Works Colfax Ricoh Copie 2013 2018 620 Monthly 16th 4,732.65 4,732.65 137.58 43.34 4,595.07 12o Water Works Olive Ricoh Copier Water Works Olive Ricoh Copier 2013 2018 620 Monthly 10th 4,732.65 4,732.65 137.58 43.34 4,595.07 Financial RepW February 2014 - Debt Page 23 0/28 City of South Bend Period Ending; February 2014 Monthly Debt Schedule 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 Maturity Fund let 2nd 3rd 4th Issue 12/31/2013 Pa ments Payments Atidttions 1 212812014 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 et 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 0.00 1,133,333.34 121 Blackthorn 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 Total Bond Debt 139 713 788.00 83 123 333.34 3,656,549.96 2 037 979.60 293 788.00 79 760 571.38 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 0.00 482,021.41 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 s3 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. 163 990.74 138 432.26 0.00 8,342,361.04 Capital Lease 75 PNC Equipment Financing Blackthorn Golf Carts 2010 2015 619 Monthly 246,509.64 106,802.80 879.22 0.00 106,802.80 Total Capital Lease 246,509.64 106,802.80 0.00 879.22 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 0.00 1,788,501.00 Total Lease 5,510,278.00 2 160 211.00 1 0.00 1 0.00 0.00 2,160,211.00 Total Redevelopment Commission 167,529,086.70 93,896,698.92 1 3,820,540.70 1 2,177,291.08 293,788.00 90,369,946.22 Total Debt 447,483,068.44 257,332,552.06 6,155,750.34 3,049,315.68 293,788.00 251,470,589.72 41,798.56 Financial Repent February 2014 - Debl Page 24 of 28 City of South Bend Staffing Headcount Summary City Total 1328.00 1316.00 0.00 1.00 4.00 3.00 2.00 2.00 2.00 2.00 1.00 1.00 0.00 Financial Report February 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 0.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 0.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 0.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 0.00 1.00 4.00 3.00 2.00 2.00 2.00 2.00 1.00 1.00 0.00 Financial Report February 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 311 Call Center 7.00 7.00 7.00 Admin & Finance 23.00 21.00 21.00 Safety & Risk 3.00 3.00 3.00 Clerk 5.00 5.00 5.00 Common Council 9.00 9.00 9.00 L al De artment 10.00 9.00 9.00 Sub Total 64.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 0.00 Code Enfor. /Animal Control 26.00 24.00 21.00 Dept. of Community Investment 26.00 26.00 26.00 Parks & Recreation Public Safety Public Works Administration 12.00 11.00 11.00 Maintenance 44.00 44.00 44.00 Golf Operations 8.00 8.00 8.00 Recreation Cps/ 26.00 26.00 26.00 Zoological Ops 23.00 3.00 3.00 Greenhouse Ops 0.00 0.00 0.00 Graffiti Removal 1.00 1.00 1.00 Recreation Nonreverting 1.00 1.00 1.00 Sub Total 115.00 94.00 94.00 0.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 Communications 38.00 32.00 33.00 Fire 260.00 263.00 260.00 Sub Total 595.00 584.00 576.00 0.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 Engineering 15.00 14.00 14.00 Maintenance 3.00 3.00 3.00 Solid Waste Operations 25.00 25.00 25.00 Street Operations 60.00 60.00 60.00 Sewer Operations 35.00 35.00 35.00 Waste Water Ops 45.00 44.00 44.00 Organic Resources 6.00 6.00 6.00 Water Utilit O s 70.00 69.00 69.00 Sub Total 299.00 293.00 293.00 0.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 Human Rights 6.00 6.00 6.00 Morris & Palais 14.00 14.00 14.00 City Total 1160.00 1116.00 1104.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report February 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 Admin & Finance Clerk Common Council Legal Department 4.00 4.00 Sub Total 5.00 5.00 0.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 Dept. of Community Investment 1.00 1.00 Parks & Recreation Public Safety Administration 5.00 5.00 Maintenance 3.00 3.00 Golf Operations Recreation Ops 30.00 30.00 Zoological Ops 6.00 6.00 Greenhouse Ops Graffiti Removal Sub Total 44.00 44.00 0.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 Communications Fire 1.00 1.00 Sub Total 5.00 5.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Public Works Central Services 1.00 1.00 1.00 0.00 Engineering 4.00 4.00 Traffic & Lighting Maintenance Solid Waste Ops 2.00 2.00 Street Ops 3.00 3.00 Sewer Ops Waste Water Ops Water Utilit Ops 1.00 1.00 Sub Total 11.00 11.00 0.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 1.00 1.00 0.00 Morris & Palais 5.00 5.00 City Total 74.00 74.00 0.00 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report February 2014 - Headcount Staffing Page 27 of 28 City of South Bend Staffing Headcount Temporay & Seasonal Staff Public Works Building Department Human Rights Morris & Palais Central Services Engineering 1.00 1.00 Traffic & Lighting Maintenance Solid Waste Ops 8.00 8.00 Street Ops 2.00 2.00 Sewer Ops 5.00 5.00 Leaf Pickup Waste Water Ops Organic Resources 1.00 1.00 Water Utilit Ops 3.00 3.00 Sub Total 20.00 20.00 0.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 0.00 1.00 3.00 3.00 2.00 2.00 2.00 2.00 1.00 1.00 0.00 Financial Report February 2014 - Headcount Staffing Page 28 of 28 Prior Jan Feb Mar Apr P I May y l Jun Jul Au Aug l Se P Oct Nov Dec Year End General Government Mayor Admin & Finance 1.00 2.00 Clerk Common Council Le al Sub Total 1.00 2.00 0.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 0.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 Maintenance 17.00 17.00 Golf Operations 1.00 1.00 Recreation Ops 51.00 51.00 Zoological Ops 0.00 0.00 Greenhouse Ops 0.00 0.00 Graffiti Removal 1.00 1.00 Sub Total 75.00 75.00 0.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 Communications Fire Sub Total 41.00 41.00 0.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 Traffic & Lighting Maintenance Solid Waste Ops 8.00 8.00 Street Ops 2.00 2.00 Sewer Ops 5.00 5.00 Leaf Pickup Waste Water Ops Organic Resources 1.00 1.00 Water Utilit Ops 3.00 3.00 Sub Total 20.00 20.00 0.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 0.00 1.00 3.00 3.00 2.00 2.00 2.00 2.00 1.00 1.00 0.00 Financial Report February 2014 - Headcount Staffing Page 28 of 28