Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
12-2014 Financial Report
Tab Narrative Revenue Prop Tax Rev Expenditures Debt Debt Monthly Headcount Distribution Period Ending: December 31, 2014 Issued By: Controller City of South Bend Financial Report Page Contents 2 Brief discussion on notable fund activity 3 -10 City Revenues 11 -12 Property Tax Revenue Collection Status 13 -17 Expenditures by Fund and Department 18 -19 Debt Status 20 -21 Current Debt at Month End 22 -25 Staffing Levels Mayor Chief of Staff Deputy Chief of Staff Controller Deputy Controller City Finance Director Financial Specialist Senior Department Heads Fiscal Officers City Common Council Pete Buttigieg Kathryn Roos Brian Pawlowski John Murphy Jennifer Hockenhull Rahman Johnson Cecil Eastman Financial Report December 2014 Page 1 of 25 December 31, 2014 Financial Report The Financial Report provides current year financial information for each City fund in a condensed format. Information is provided for revenue (by type and fund), expenditures, property taxes, debt status, and staffing levels. This report is prepared monthly and supplements other reports that the City prepares such as, the Controller's Cash Report, the Monthly Departmental Financial Report, and the Comprehensive Annual Financial Report (CAFR). Revenue by type For discussion on property taxes, see section listed below. The overall percentage of budgeted revenues that have been received by the city is 95 %. In comparison, the overall percentage of collected revenue amount for December 2013 was 88 %. Revenue type 335 (Gaming Proceeds), has reached 100% of its budgeted revenue. This is revenue from riverboat gaming proceeds and distributed by the State of Indiana. 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. Also, revenue types 311 (Property Taxes) and type 315 (Income taxes) has reached 100% of their budgeted revenue. Revenue by fund As of December 2014, the general fund has received 100% of its budgeted revenue versus 98% last year. The following funds have reached 100% of their 2014 budgeted revenue amount: - Fund 416 (MPAC Improvement) is 106% or $4,407 over its budgeted revenue. This is revenue generated by surcharges from ticket sales. - Fund 244, the Telephone Emergency System has reached 100% of its budgeted revenue. This is 911 revenue received from the county. This was formerly in the general fund. - Fund 278 (Police Take Home Vehicle) is at 100% of its budgeted revenue. - Funds 249, 404, and 408 received their monthly distributions from the County on time this month. Property taxes Property taxes are received in June and December. Property taxes collected for the year 2014 totaled -$72 million. Civil city funds received -$45 million and TIF funds received - $27 million. For 2014, the projected levy collection rate is 95% or $72.1 million. Please note, 2014 Civil City funds are $352,000 lower than 2013 budget and TIF funds are -$1.3 million less than 2013 budget. Total property taxes collected for the year 2013 was $69.8 million or 90.18 %. Specifically, in 2013 the City of South Bend received a total of $45,189,966 in property tax revenue in the civil city funds (general fund, parks, College Football Hall of Fame, and CCD). For TIF funds, the City received a total of $24,790,321 in property tax revenue. Expenditures As of December 2014, the City has spent 73% of budgeted expenditures, versus 76% of budgeted expenditures in December 2013. The General Fund has spent 96% of its 2014 budgeted expenditures, compared to 95% in 2013. The following funds have reached 90% or more of their budgeted expenditures as a result of bond payments: Fund 313 (Hall of Fame), fund 407 (Cumulative Capital Improvement), fund 377 (Professional Sports Development), and fund 432 (TIF - Erskine Village). Fund 405 (Park Non Reverting) has spent 81% of budget due to capital improvement for the zoo. Debt In December 2014, several debt service payments were made in the amount of - $7.7 million to Sun Trust, Kansas State Bank, PNC Bank, U.S. Bank and Ricoh USA. Payments are related to IT equipment leases, police / public works vehicles, solid waste containers, and sewer bonds. Headcount The Full Time Headcount as of December 2014 was 1,098 vs. a budgeted amount of 1,160. Currently, there are a total of 62 vacant positions. There are 42 open positions in the following departments: Public Safety (9), Public Works (17), Code Enforcement / Animal Control (3), Building Department (2), Parks Administration (8) and other (3). The other 20 budgeted positions in the parks department will not be filled due to privatizing of the Potawatomi Zoo. If you have any questions regarding this report, please contact John Murphy at (574) 235 -7678. Financial Report December 2014 Page 2 of 25 City of South Bend Period Ending: December 31, 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 Budget I f Bud et Property Tax ,to Excise Tax various 1,570,035 1,599,495 3,169,529 2,504,793 mmercial Vehicle Tax 311 Property Tax Civil City various 414,632 829,265 882,628 tel Motel Tax Century Center 670 24,319,653 656,725 23,567 1,313,450 20,189,158 44,508,811 44,421,648 100% 311 Property Tax TIF Districts various 401,000 tel Motel Tax Cum Cap Impm 407 Z575 150,000 14,671,628 150,000 150,000 IS County Contract 12,857,230 27,528,858 27,667,280 99% 1,634,868 Sub Total b Total 377,765 136,239 792,964 136,239 336,239 136,239 2,120,907 942,964 136,239 136,239 336,239 136,239 2,150,366 7,497,112 38,991,281 377,765 5,620,482 4,533,180 33,046,388 72,037,668 72,088,928 100% Income Tax 439 37,393 59,225 32,750 16,316 16,833 16,626 13,203 315,228 318,800 1,328,182 various 1,328,182 1,450,000 315 Econ Development Income Tax 408 733,068 733,068 733,068 733,068 733,068 733,068 1,466,137 733,068 1,466,137 733,068 8,796,821 8,796,821 100% 316 Local Option Income Tax -PS 249 531,669 531,669 531,669 531,669 531,669 531,669 1,063,338 531,669 1,063,338 531,669 6,380,029 6,380,029 100% 316 County Option Income Tax 404 720,484 720,484 720,484 720,484 720,484 720,484 1,440,968 720,484 1,440,968 720,484 8,645,811 8,645,811 100% 78% Sub Total 101 1,985,222 1,985,222 1,985,222 1,985,222 1,985,222 1,985,222 3,970,443 1,985,222 3,970,443 1,985,222 23,822,661 23,822,661 100% ;ounty (Remitted by) ,to Excise Tax various 1,570,035 1,599,495 3,169,529 2,504,793 mmercial Vehicle Tax various 414,633 434 414,632 829,265 882,628 tel Motel Tax Century Center 670 656,725 656,725 23,567 1,313,450 1,313,450 tel Motel Tax Century Center 420 200,000 0% 200,000 400,000 401,000 tel Motel Tax Cum Cap Impm 407 Z575 150,000 4,776 150,000 150,000 IS County Contract 101 136,239 136,239 136,239 136,239 136,239 136,239 136,239 136,239 136,239 136,239 136,239 136,239 1,634,868 1,588,824 b Total 377,765 136,239 792,964 136,239 336,239 136,239 2,120,907 942,964 136,239 136,239 336,239 136,239 2,150,366 7,497,112 6,840,695 State of Indiana Remitted b deral Drug 312 CRED Tax 434 Liability Insurance 5,304 14,852 4,256 1,668 5,118 4,344 23,567 238,310 241,463 59,110 75,000 650,000 0% 335 Cigarette Tax 1011407 10,810 12, 724 General Government Misc Ch s Z575 157,249 4,776 160 1,316 30,884 183,175 340,425 329,818 103% 335 State Pension Subsidy 7011702 377,765 377,765 377,765 377,765 5,620,482 377,765 377,765 5,620,482 4,533,180 4,533,215 ntractual Service 11,240,963 11,686,832 96% 335 CTP Distribution 439 37,393 59,225 32,750 16,316 16,833 16,626 13,203 315,228 318,800 1,328,182 various 1,328,182 1,450,000 92% 335 Gaming Proceeds 101 125,544 362,834 143,403 282,431 2,698,928 2,600,000 599,027 101,267 b Total 222 391,184 599,027 600,000 100% 335 Gasoline Tax 2021251 337,414 362,053 381,987 420,143 394,207 474,981 405,682 471,019 367,238 377,286 351,332 356,371 4,699,712 4,713,418 100% 335 Liquor Excise tax 101 164,513 182,249 38,577 171,086 25,240 200,503 138,466 146,788 2,171,530 2,762,612 79% 63,817 82,000 78% 335 Liquor Gallonage Tax 101 55,845 380,370 309,248 45,989 373,168 48,434 345,307 298,605 49,841 345,131 4,150,486 200,108 200,000 100% 335 ProfSports Development Tax 377 66,547 113,592 267,168 251,882 121,525 40,184 46,863 58,993 45,101 58,447 232,849 551,252 600,000 92% 335 Wheel Tax 202 Administration Fee 109,590 74,990 289,249 579,487 187,385 171,718 289,249 350,773 163,764 289,249 289,249 1,637,707 2,000,000 82% Sub Total 3,470,989 459,805 585,235 495,555 466,132 973,694 6,586,862 666,018 1,116,909 6,397,486 635,992 1,737,961 539,546 20,661,194 22,312,068 93% governmental Sources deral Drug 299 340 Liability Insurance 5,304 14,852 4,256 1,668 5,118 4,344 23,567 238,310 241,463 59,110 75,000 vte Drug 216 2,859,719 2,904,336 10,810 12, 724 General Government Misc Ch s Z575 4,776 160 1,316 30,884 36,600 yment in Lieu of Tax various 377,765 377,765 377,765 377,765 377,765 377,765 377,765 377,765 377,765 377,765 377,765 377,765 4,533,180 4,533,215 ntractual Service 211 13,419 11,183 29,006 57,869 11,403 37,393 59,225 32,750 16,316 16,833 16,626 13,203 315,228 318,800 ends various 266,072 219,847 300,262 168,560 101,267 125,544 362,834 143,403 282,431 2,698,928 2,600,000 101,267 101,267 b Total 222 391,184 388,948 406,771 451,747 416,744 520,681 441,233 415,633 403,201 418,166 394,391 390,968 5,039,669 5,064,882 Charge for Service Internal City 340 Liability Insurance 226 235,157 235,157 241,463 238,310 238,310 238,310 238,310 241,463 238,310 238,310 235,157 241,463 2,859,719 2,904,336 98% 340 General Government Misc Ch s 1011289 160 1,316 26,800 1,135 496 2,825 32,733 32,733 100% 340 Police Take Home Vehicle 278 7,160 4,730 4,640 4,700 4,700 4,700 4,680 7,050 4,710 4,700 4,680 4,720 61,170 60,580 101% 342 EMS Capital 288 151,160 281,678 233,496 266,072 219,847 300,262 168,560 163,640 125,544 362,834 143,403 282,431 2,698,928 2,600,000 104% 349 Central Service 222 47,661 49,015 46,909 47,019 43,783 46,212 46,488 45,011 45,585 49,799 31,302 40,730 539,515 619,002 87% 380 Central Service 222 204,221 185,484 192,354 198,773 164,513 182,249 188,273 171,086 198,820 200,503 138,466 146,788 2,171,530 2,762,612 79% 380 Energy Office Reimbursements 222 417,066 432,016 417,491 380,370 309,248 241,895 373,168 292,055 345,307 298,605 298,135 345,131 4,150,486 4,632,222 90% 380 Internal Service Reimbursement various 138,730 122,721 267,168 251,882 161,822 104,957 259,246 136,998 135,613 419,113 232,849 383,167 2,614,265 2,723,095 96% 392 Administration Fee 101 289,249 289,249 289,249 289,249 289,249 289,249 289,249 289,249 289,249 289,249 289,249 289,249 3,470,989 3,470,989 100% 392 Internal Fund Transfers various 4,314,974 1,011,355 3,039,278 3,486,819 1,050,575 956,852 1,120,384 2,413,363 1,073,076 4,014,311 967,613 1,299,436 24,748,037 25,527,194 97% 395 Employee Benefits various 946,856 995,209 1,002,625 1,362,041 1,088,236 1,081,657 1,090,339 1,095,810 1,075,140 1,082,777 1,082,341 1,094,869 12,997,900 13,794,672 94% Financial Report December 2014 - Revenue Report Page 3 or25 City of South Bend Period Ending: December 31, 2014 Revenue by Type Report S Fund % Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct I Nov I Dec I Year I Budget I of Bud et 396 Central Service Refunds 222 1,763 1,798 6,662 1,927 1,831 3,247 2,019 2,052 3,504 24,803 22,000 1 396 Self Funded Employee Benefits 711 11,182 (99) 93,040 66,839 35,084 81,553 41,769 77,390 406,757 372,000 11 Sub Total 6,753,998 3,608,413 5,746,016 6,531,797 3,573,526 3,448,174 3,898,539 4,926,946 3,568,954 7,046,631 3,464,964 4,208,875 56,776,832 59,521,435 Party Revenue 340 No EMS Service 101 320 28,006 3,332 13,674 5,512 2,824 2,407 8,133 2,344 63,094 129,325 90,000 11 340 Memorial Hospital Neo Natal 101 40,938 39,124 35,592 34,101 32,462 38,807 34,860 41,530 30,365 38,938 32,282 39,923 438,922 365,000 1; 350 Job Target Penalty Fee 408 354,660 1,720 3,363 127,524 128,202 99% 321 Code and Animal Fees 600 5,770 4,097 354,660 354,660 11 364 Cable TV Franchise Fees 101 180,787 5,213 4,275 181,751 3,351 4,000 183,119 71,008 81% 171,499 Building Fees 717,156 750,000 366 AT &T Franchise Fees 101 55,613 80,144 90,443 56,518 74,380 106,817 63,189 76,830 82,195 62,989 1,156,600 238,309 238,309 11 Sub Total 600 40,938 630,184 63,598 37,433 284,405 44,319 37,684 290,245 38,498 41,282 266,770 103,017 1,878,372 1,797,969 11 its 331 Federal Grants various 186,142 152,888 51,992 47,583 390,448 160,732 1,110,410 121,571 536,228 1,427,063 120,243 616,309 4,921,609 7,997,159 334 State Grants various 215,000 10,000 225,000 2,225,000 Sub Total 401,142 152,888 51,992 47,583 390,448 170,732 1,110,410 121,571 536,228 1,427,063 120,243 616,309 5,146,609 10,222,159 Fees for Services External 320 Inspections Central Service 222 370 680 400 1,450 1,500 97% 321 Business License 1011222 36,125 19,849 15,838 15,052 6,766 2,937 2,298 1,723 17,833 4,020 1,720 3,363 127,524 128,202 99% 321 Code and Animal Fees 600 5,770 4,097 4,413 5,415 4,285 5,776 4,823 5,213 4,275 6,453 3,351 4,000 57,871 71,008 81% 322 Building Fees 600 80,552 51,919 83,990 75,611 80,144 90,443 83,665 74,380 106,817 120,667 76,830 82,195 1,007,214 1,156,600 87% 322 Code Enforcement Fees 600 550 100 100 300 450 5,900 5,650 750 850 150 850 4,350 3,700 118% 322 EMS Capital 288 1,951 2,376 2,353 1,310 2,678 1,823 895 2,855 2,861 1,168 1,353 2,094 23,717 24,219 98% 322 General Government Fees 101 920 1,681 2,375 1,500 1,860 1,195 3,225 1,525 3,780 1,835 1,025 3,065 23,986 21,311 113% 341 General Government Various various 952 1,077 2,703 1,681 2,425 1,852 7,540 1,052 512 3,971 353 741 23,835 97,224 25% 342 Highway &Streets 1011202 26,493 20,100 9,381 8,871 38,266 30,104 15,066 27,470 9,347 13,363 18,341 16,837 233,639 190,000 123% 342 Public Safety various 25,316 10,922 7,390 14,858 6,362 5,416 11,331 7,105 8,744 7,304 7,214 6,797 118,756 130,000 91% 344 Solid Waste 610 396,546 392,279 391,374 398,710 399,877 402,065 399,430 404,443 401,034 403,100 400,199 401,594 4,790,651 4,766,995 100% 344 Code Environmental Clean Up 101 1600 5,284 5,038 7,784 11,188 8,001 3,605 4,517 2,602 11,488 5,048 7,475 16,195 88,224 71,628 123% 344 Sewage Waste Water 641 2,670,534 2,630,565 2,649,615 2,773,801 2,849,977 2,841,686 2,956,564 2,819,323 2,815,723 2,837,422 2,748,855 2,751,314 33,345,379 34,889,165 96% 344 Sewer Repair Insurance 640 47,660 45,850 48,269 49,367 48,620 49,793 48,706 49,033 48,651 51,729 48,878 49,302 585,858 573,570 102% 344 Water Leak Insurance 620 80,687 80,448 80,578 80,851 80,849 81,037 80,970 80,882 76,399 80,693 80,278 80,890 964,764 966,500 100% 346 Water Works Utility 620 904,758 1,107,816 1,002,853 1,016,525 1,025,445 1,320,058 1,085,238 1,465,819 1,119,445 1,383,651 996,104 992,866 13,420,578 13,798,953 97% 346 Solid Waste Misc 610 3,940 3,910 4,492 18,633 34,920 25,948 16,975 10,336 6,893 6,978 6,359 6,702 146,086 164,835 89% 346 Project ReLeaf 655 36,254 36,124 36,251 36,372 36,376 36,453 36,462 36,403 36,325 36,504 36,331 36,464 436,317 429,000 102% 347 Parks & Recreation various 70,289 189,088 109,825 323,691 253,042 364,432 467,876 332,937 278,539 171,964 41,534 113,573 2,716,789 3,516,830 77% 347 Blackthorn Golf Club 619 71,571 84,446 56,179 127,218 204,566 229,433 239,340 252,030 174,866 72,806 20,167 6,762 1,539,385 1,736,322 89% 347 Morris PAC 416 7,305 7,851 13,814 8,587 8,549 1,497 2,477 10,730 1,867 17,102 79,779 75,000 106% 349 Parking Garage Fees 601 94,897 64,534 74,073 71,198 62,422 92,266 63,249 66,411 72,179 72,103 61,863 83,983 879,177 918,342 96% 349 Code Demolition Board Up 101 1600 6,168 1,463 1,403 1,207 9,670 1,555 1,904 543 623 1,195 718 7,512 33,961 26,800 127% 349 Parking Century Center 670 9,503 19,224 23,453 6,149 5,480 5,791 3,090 4,015 4,265 6,462 4,290 8,912 100,634 175,000 58% 349 Parking SBCDA 420 2,432 2,820 3,359 3,342 3,175 1,324 3,634 3,107 2,928 3,299 2,956 2,922 35,297 43,700 81% 351 Fines &Fees various 16,291 14,865 24,764 18,480 18,613 13,293 19,410 8,337 15,184 15,642 14,338 14,069 193,287 266,820 72% 352 Forfeits various 1,250 1,340 1,950 9,495 75 87,594 5,450 92,775 5,295 365 8,250 71,596 285,435 292,430 98% 354 Ordinance Violation various 2,238 2,170 1,518 2,370 1,112 3,049 535 920 1,901 1,601 2,510 1,700 21,624 36,800 59% 360 Morris PAC various 55,061 50,740 141,675 67,138 53,643 258,527 24,933 3,302 72,144 65,311 19,396 198,469 1,010,360 888,163 114% 360 Palais Royale various 24,895 6,097 5,364 5,319 31,626 12,232 7,978 14,393 18,228 16,572 12,245 10,842 165,791 169,774 98% 360 Parks & Recreation various 28,974 14,868 7,730 8,693 5,161 3,401 10,312 10,209 41,137 13,945 3,389 44,872 192,691 173,366 111% 360 Police various 11,956 950 900 760 1,080 1,346 2,380 25,697 1,050 3,735 24,331 2,670 76,856 97,555 79% 360 TIF various 3,416 4,763 3,883 4,318 841 4,467 3,373 3,523 2,173 5,540 7,793 2,445 46,535 55,231 84% 360 COIT 404 36,458 0% 360 Central Services 222 41,759 3,015 351 1,351 1 3,098 1,832 1,629 243 1,485 54,765 55,436 99% 360 Century Center 670 1,805 7,700 14,453 2,260 4,666 5,330 11,115 15,628 19,806 2,803 365 2,273 48,593 50,000 97% 360 Code 101 1600 46 51 252 118 50 58 729 0 1,304 1,000 130% 360 Consolidated Building Dept. 600 919 919 NA 360 Cumulative Capital Improvement 4061407 854 854 NA 360 Dept Of Community Investment 2111212 6 52,208 40,415 56,705 111,753 30,765 1,649 109,345 97,047 499,893 916,550 55% 360 Stud. /Oliver Rev. Grants 209 300,000 0% 360 EMS Capital 288 59 117 9 1,256 1,000 67 2,509 16,000 16% 360 Engineering / Curb & Sidewalk 101 89 189 104 164 175 725 350 441 250 3,958 2,585 151 9,182 25,700 36% Financial Report December 2014 - Revenue Report Page 4 o/25 City of South Bend Period Ending: December 31, 2014 Revenue by Type Report S Fund % Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct I Nov I Dec I Year I Budget I of Bud et 360 Fire 701 391 TIF 4201324 8,245 1,220 1,484 1,484 35,704 NA 360 Police Pension Fund 702 4,047 1,612 4,129 588 (360) 28,223 33,000 391 Proceeds F.A. Disposal 600 4,122 137 4,259 4,500 9591 360 General Government Various 101131226 (5,160) 36,377 803 202 469 various 97 829 199 13,270 1,220 50 52,579 50,247 105% 360 Motor Vehicle Highway Scrap Meta 202 (3,548) 12,498 588 (360) 108,645 1,331 1,204 581 653 2,004 5,773 4,000 144% 360 Motor Vehicle Highway Curb Pr gm 202 6,563 8,579 4,684 1,803 2,857 8,184 3,215 1,703 5,368 51,655 9,040 8,818 112,470 113,229 99% 360 Local Roads and Streets 251 3,190 3,190 3,190 100% 360 Parking Garage Fund 601 275 78 235 588 828 71% 360 ProfessionalSports Development 377 34,608 32,102 66,710 74,228 90% 360 Solid Waste Fund 610 1,389 15 401 1,805 2,500 72% 360 Waste Water 6411719 2,621 2,611 5,321 4,529 5,637 346 14,841 954 5,680 8,808 15,910 67,258 67,371 100% 360 Water Works Utility 620 31,554 846 58 1,676 861 2,568 40,726 1,891 2,202 53 82,435 90,825 91% 362 Dept Of Community Investment 212 1,847 1,847 1,847 1,847 7,387 17,287 43% 362 Palals Royale 101 2,490 990 1,848 1,825 8,498 2,192 5,668 7,508 1,554 4,290 568 4,399 41,829 44,500 94% 362 Parks & Recreation 201 1,329 2,226 5,680 4,781 7,774 6,724 5,241 6,097 2,262 1,916 240 405 44,675 47,400 94% 362 S Bend School Corp Fee 407 25,000 25,000 25,000 100% 362 TIF Pro erty various 14,675 17,473 10,973 25,185 13,019 19,295 15,724 18,788 11,681 22,763 18,222 18,694 206,492 228,338 90% 369 Memorial Hosp Leighton Plaza 408 150,000 0% 371 Century Center Fees 670 90,135 146,746 129,551 100,543 152,417 152,953 670,535 54,864 246,759 324,047 166,768 389,708 2,625,027 3,539,678 74% 399 Bosch Retention Project 210 14,387 14,495 14,604 14,714 58,200 58,203 100% 399 Principal on Loan various 19,196 21,428 1,967 35,031 18,244 19,075 18,435 18,875 2,478 19,094 18,378 36,855 229,055 260,599 88% 399 Principal Income xxx 186,218 41,443 5,289 44,968 248,352 1,763 1,763 1,763 531,560 572,669 93% Sub Total 4,937,828 5,353,133 5,089,003 5,409,190 5,502,275 6,263,873 6,518,705 6,054,246 5,897,744 6,012,211 4,980,105 5,545,279 67,563,590 72,712,279 93% -est Income 361 Bank Account Interest various 32,479 87,965 108,404 120,271 38,199 51,939 27,878 43,754 125,929 76,455 31,256 (81,229) 663,302 1,048,896 Sub Total 32,479 87,965 108,404 120,271 38,199 51,939 27,878 43,754 125,929 76,455 31,256 (81,229) 663,302 1,048,896 ations 367 ND Contribution 101 330,000 330,000 330,000 11 367 Donations various 268 22,291 62 27 27 27 150,027 41 27 1,522 196 4,901 179,416 203,853 Sub Total 268 22,291 62 27 27 27 480,027 41 27 1,522 196 4,901 509,416 533,853 uric Preservation 368 Petals 450 1,796 334 125 384 145 841 132 1,140 2,311 1,201 895 303 9,607 10,300 Sub Total 1,796 334 125 384 145 841 132 1,140 2,311 1,201 895 303 9,607 10,300 of Assets 391 TIF 4201324 8,245 1,220 8,369 17,834 35,704 391 Water Hydrant Reimbursement 620 11,797 3,176 (150) 3,384 4,047 1,612 4,129 588 (360) 28,223 33,000 391 Proceeds F.A. Disposal 600 1,500 391 Sale of Fixed Assets van.ous 67,748 (5,160) 62,588 61,776 1i 391 Vehicle Damage Reimbursement various 1,000 Sub Total 11,797 11,421 (150) 1,220 3,384 71,795 (3,548) 12,498 588 (360) 108,645 132,980 Revenue Total 15,140,898 13,619,374 14,094,408 15,385,874 13,302,144 60,188,241 14,123,591 17,148,962 19,088,290 16,009,259 15,104,051 48,509,585 261,714,677 276,109,105 951 report 15,140, 898 13, 619, 374 14, 094,408 15, 385, 874 13,30Z 144 60,188, 241 14,123, 591 17,148,962 19,088,290 16,009,259 15,104,051 48,509,586 261, 714, 677 276,109,105 0 0 Financial Report December 2014 - Revenue Report Page 5 o125 City of South Bend Revenue by Fund Report Period Ending: December 31, 2014 s % Fund Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I ec I Year I Bud et I ofBUd et General Government 0000 General Revenues 101 833,855 1,001,393 802,401 805,843 982,078 22,482,554 1,119,005 1,585,605 762,202 953,360 976,888 19,047,808 51,352,992 51,115,199 100% 0101 Mayor 101 227 151 35 276 27 (636) 10 5,824 69 119 6,103 6,389 96% 0104 311 Call Center 101 26,509 109,227 38,185 34,017 31,299 34,739 45,786 33,274 34,231 36,746 32,707 456,722 480,077 95% 0301 Common Council 101 41 27 27 27 434 41 27 27 27 27 704 8,300 8% 0401 Administration and Finance 101 829 602 3,021 4,452 3,071 145% 0501 Legal 101 15 1,044 8 542 14 3,351 1,994 54,358 61,325 74,334 82% Sub Total 860,646 1,002,615 911,698 844,847 1,016,135 22,513,880 1,153,542 1,632,261 799,466 998,457 1,013,731 19,135,019 51,882,299 51,687,370 100% Public Works 0602 Engineering 101 115 18,481 575 200 291 100 3,808 50 23,620 25,350 93% Sub Total 115 18,481 575 200 291 100 3,808 50 23,620 25,350 93% Public Safety 0801 Police 101 38,053 30,089 10,162 7,215 40,040 10,913 29,390 32413 59,034 47,929 34,371 52,121 391,729 430,583 91% 0901 Fire 101 41,063 39,253 63,964 37,433 47,452 44,319 40,430 1,045,072 38,994 45,728 33,407 103,017 1,580,131 1625,983 97% Sub Total 79,116 69,341 74,126 44,647 87,492 55,231 69,820 1,077,485 98,028 93,657 67,778 155,139 1,971,860 2,056,566 96% Code Enforcement 1205 Code Unsafe Building 101 90 50 25 25 25 35 NA 1207 Code Animal Control 101 20 20 NA Sub Total 20 90 50 25 25 25 55 NA Arts & Culture 0404 Morris PAC 101 56,152 47,987 141,683 67,721 53,602 257,930 24,726 Z331 72,071 64,283 20,109 197,367 1,005,962 884,263 114% 0405 Palais Royale 101 29,101 7,384 7,641 8,067 41,102 16,359 14,560 23,569 21,348 2Z462 13,871 16,949 22Z413 228,524 97% Sub Total 85,253 55,371 149,324 75,788 94,704 274,289 39,286 25,901 93,419 86,745 33,980 214,316 1,228,375 11112,787 110% General Fund Revenue Total 1,025,130 1,127,327 1,135,147 965,302 1,216,722 22,843,976 1,262,847 2,735,937 991,063 1,182,693 1,115,564 19,504,498 55,106,209 54,882,073 100% Financial Report December 2014 - &p-dk- Summary Page 6 of 25 City of South Bend Revenue by Fund Report Period Ending: December 31, 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 ofBUd et Parks & Recreation 0000 Parks General revenue 201 61,214 62,071 62,107 61,846 61,020 4,357,371 61,052 67,256 62,379 61,881 62,284 3,734,608 8,715,088 8,696,487 100% 1100 Administration 201 1,551 2251 5,730 4,891 7,949 6,824 5,266 6,405 2287 2,120 243 408 45,925 49,550 93% 1101 Maintenance 201 6,893 7,305 7,508 83,872 16,746 17,247 75,330 28,400 68,320 69,895 2043 22,712 406,273 396,459 102% 1102 Golfo erations 201 2,568 71,543 11,607 161,363 186,018 22Z 156 241,418 207,934 173,943 66,961 8,841 20,097 1,369,313 1,588,000 86% 1103 Recreation Division 201 18,881 13,633 7,265 835 65 24,272 28,387 20,355 80 785 1,179 30,760 146,497 184,140 80% 1104 Potawatomi Zoo 201 265 34 13 312 NA 1108 Grafd Removal 201 6,464 6,425 3,296 15,313 49,650 15,158 24,347 19,906 140,559 99,304 142% Recreation Non Reverting 203 76,057 104,016 91,333 87,416 50,145 103,711 129,002 85,644 64,094 52,329 31,649 70,088 945,486 1,489,178 63% East Race Watemay 271 2 5 7 8 2 3 1 1 3 2 1 2 32 100 32% Coveleski Stadium 401 3 10 13 14 5 7 3 5 13,541 10 5 15 13,500 14,026 97% Zoo Endowment 403 6 18 24 26 8 12 5 9 28 16 6 19 139 2900 5% Park Non Reverting 405 79 7,670 443 518 5,448 740 4,687 774 410 5,329 60 111,020 137,177 246,420 56% Sub Total 168,582 275,212 189,369 400,789 34Z 719 4,782,007 560,308 416,782 385,085 283,675 106,312 4,009,561 11,920,401 12,766,564 93% Public Works Motor Vehicle Ni hway 202 285,523 416,631 384,110 1,840,889 927,707 611,250 523,905 494,985 656,754 2,002,949 288,187 559,463 8,992,353 9,257,615 97% Central Services 222 670,844 738,759 669,859 637,842 544,739 473,838 608,357 542,871 597,081 554,969 468,299 556,677 7,064,135 8,114,184 87% Local Roads & Streets 251 87,148 91,181 93,475 123,983 91,165 91,503 97,527 24,152 84,739 95,198 88,124 92,354 1,060,549 1,124,996 94% Protect ReLeaf 655 36,373 36,471 36,737 36,904 36,554 36,709 36,568 36,599 36,973 36,881 36,489 36,136 439,394 431,700 102% Sub Total 1,079,887 1,283,043 1,184,182 2639616 1,600,165 1,213,300 1,266,358 1098,606 1375,548 2689,998 881,099 1,244,630 17556,431 18,928,495 93% Public Works Solid Waste Solid Waste Operations 610 400,585 396,447 396,179 515,673 434,883 428,158 530,782 423,734 408,587 485,848 406,595 469,769 5,297,239 5,384,723 98% Solid Waste Capital 611 230,437 27 80,040 45,019 94,513 10 165,006 35,006 94,000 12 46,010 15 790,065 836,202 94% Sub Total 631,022 396,474 476,219 560,691 529,396 428,168 695,788 458,740 50Z587 485,859 45Z605 469,754 6,087,304 6,220,925 98% Public Works Water Utility 0000 Water Works Revenues 620 863,045 1,048,116 935 227 955,067 949,603 1,205,037 1 001 701 1,371,931 1 038 077 1,275,210 927 559 921,920 12,492,492 12 856,758 97% 0630 Water Leak Insurance 620 80,687 80,448 80,578 80,851 80,849 81,037 80,970 80,882 76,399 80,893 80,278 80,890 964,764 966,500 100% 0660 Clay Water 620 74,439 74,966 75,443 72,891 78,085 123,249 84,374 154,039 89,527 117,147 70,345 74,430 1,088,934 1,134,520 96% Waterworks Capital 622 453 1,296 1,756 1,853 603 856 346 616 1,994 1,111 438 1189 10,132 12500 81% Waterworks Construction 623 223 296 311 313 70 94 36 58 164 88 33 2 1,614 5,000 32% Waterworks Deposit 624 186 534 724 768 250 355 183 256 829 469 192 (564) 4,182 6,040 69% Waterworks Sinking 625 171,006 170,846 170,967 171,050 170,927 171,008 170,908 170,938 171,350 171,176 170,978 171,098 2,052,253 2,057,224 100% Waterworks Bond Reserve 626 8,761 9,130 9,337 9,383 8,833 8,947 8,719 8,842 8,938 515 210 (614) 81,001 90,073 90% Waterworks Debt Reserve 629 261 54,253 1,021 1,094 356 505 204 364 1,180 665 272 (792) 59,382 70,312 84% Sub Total 1,199,062 1,439,885 1,275,364 1,293,271 1,289,576 1,591,088 1,347,441 1,787,925 1,388,458 1,647,274 1,250,304 1,245,107 16,754,755 17,198,927 97% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 47,833 46,355 48,966 50,116 48,868 50,147 48,850 49,289 49,475 52,199 49,072 48,726 589,894 578,270 102% 0000 Wastewater Revenues 641 2,517,238 2,480,217 2,496,145 2,616,135 2,682,708 2,677,476 2,782,933 2,648,683 2,638,621 2,670,667 2,593,144 2,577,214 31,381,181 32,992,992 95% 0621 Sewer Department 641 573 2472 2060 5,106 3,518 145% 0625 Concrete Crew 641 4,008 4,376 6,385 5,927 6,327 19,233 8,989 8,917 20,412 84,574 83,940 101% 0630 Wastewater Operations 641 4,278 4,278 4,278 100% 0631 Organic Resources 641 4,508 4,508 4,508 100% 0650 Clay Sewage 641 153,599 152,617 158,751 160,954 168,094 166,939 170,475 173,117 179,690 169,296 157,647 164,978 1,976,156 1,924,741 103% Sewage Ca ital 642 2,000,563 1,522 2,002,341 3,149 1,036 1,416 538 930 2890 1,521 556 (1,352) 4,015,111 4,039,000 99% Sewage Reserve 643 130,386 1,221 1,702 1,797 585 829 335 598 1,937 1,092 446 (1,301) 139,626 238,715 58% Sewer Bond 2007 647 1 0 1 1 0 0 0 3 NA Sewage Bond Sinking 649 775,028 775,371 775,900 776,314 775,538 775,951 775,257 775,655 777,826 776,836 775,742 774,334 9,309,752 9,809,145 95% Sewer Bond 20078 651 0 (0) 0 NA Sewage Works DS Reserve 653 3 3 NA 2010 CSO Net Sewer Bond 658 0 1 1 1 0 1 0 0 1 0 0 0 6 NA 2011 Sewer Bond 659 1,034 2810 3,709 3,771 1,163 1,535 530 899 2,706 1,442 504 (438) 19,665 25,000 79% 2012 Sewer Bond 661 2372 6,686 8,940 9,354 3,043 4,317 1,744 3,112 10,083 5,609 2277 (6,277) 51,260 65,000 79% 2013A Sewer Refund Bonds 664 1 2 2 2 1 1 0 1 3 1 1 (2) 13 NA Sub Total 5,632,063 3,471,179 5,502844 3,627,519 3,687,937 3,678,611 3,799,893 3,663,541 3,672,221 3,687,581 3,579,390 3,578,359 47,581,137 49,769,107 96% Financial Report December 2014 - &p-dk- Summary Page 7 of 25 City of South Bend Revenue by Fund Report Period Ending: December 31, 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 Bud et I ofeud et Public Safe - Police Police Seizures 216 20 58 79 10,893 12,751 40 17 30 4,873 55 23 (73) 28,765 36,200 79% Curfew Violations 218 14 39 83 19 2 128 51 15 19 4 14 83 471 1,125 42% Law Enforcement Education 220 30,247 12,673 17,643 17,502 8,915 18,632 21,415 9,571 18,376 18,804 17,922 14,188 205,889 224,945 92% Public Safety LOIT 249 531,895 532,362 532,719 532,647 531,932 532,054 150 1,063,545 532206 391 1,063,465 531,084 6,384,450 6,391,029 100% Excess Welfare Public Safety 252 0 0 1 1 0 0 0 0 1 0 0 0 4 5 78% Police Take Home Vehicle 278 14,378 9,629 9,407 9,652 9,484 9,521 9,410 14,191 9,721 9,573 9,432 9,241 123,639 123,160 100% Police Block Grant 280 0 1 2 2 1 1 0 1 2 1 1 1 11 NA Police Grants 292 66,716 10,204 55 76,865 228,060 34% Poliea cademy 294 13,159 4,127 41 694 14 19 7 13 417 23 9 26 18,498 22,000 84% COPS More Grants 295 863 992 957 819 709 1,374 861 689 862 2865 714 710 12,415 41,600 30% Drua Enforcement 299 91 81 73 5,388 14,935 4,338 1,751 12,836 4,428 23,649 77 78 67,724 83,636 81% K -9 Unit 705 0 1,000 1 1 0 1 0 0 1 1,001 0 1 2,006 2,000 100% Sub Total 657,384 560,963 561,005 577,618 578,743 566,106 33,663 1,100,891 581,111 56,366 1,091,658 555,227 6,920,737 7,153,760 97% Publie Safe - Fire enc Tele h one S stem 244 215,000 19 214,981 215,000 100% VEmer a ital 288 154,587 286,614 238,953 270,628 223,443 305,054 170,620 172,030 130,770 365267 147,041 286,719 2,751,725 2,672,935 103% t 289 2 6 8 9 3 4 24,056 5 23 13 5 15 24,118 34,055 71% River Rescue 291 Z412 Z435 7,249 8,453 10,619 3,629 3,987 21 62 35 14 Z360 41,275 45,350 91% Sub Total 372,001 289,056 246,209 279,090 234,064 308,687 198,663 172,055 130,855 365,314 147,060 289,044 3,032,099 Z967,340 102% Department of Communi Investment Studebaker /0liver 209 139 398 539 569 185 263 106 190 614 346 142 413 3,078 335,000 1% State Grant 210 85 128 174 18,184 57 85 18,036 59 198 18,114 44 17,879 73,043 Z077,016 4% DCI Operating 211 435,848 11,776 40,226 480,581 11,562 37,945 59,311 455,116 18,497 779,907 16,762 12 844 Z360,377 Z406,017 98% 0000 Dept. of Community Investment 212 125,073 158,522 95,663 9Z945 363,187 220,198 1,114,430 129 950 522 124 1,04Z553 553 51 843 593,483 4,509,972 7,688,199 59% xxx Programs 212 111,753 105,079 97,047 313,879 NA 0000 Economic Revenue Bond 281 3 10 14 14 5 7 3 5 15 9 4 10 77 NA Sub Total 561,149 170,834 136,615 59Z294 374,996 258,497 1,303,639 585 319 541,449 1,946,009 165,841 623,782 7,260,425 12 506,232 58% 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 Financial Report December 2014 - &p-dk- Summary Page 8 of 25 City of South Bend Revenue by Fund Report Period Ending: December 31, 2014 s i Fund I Jan I Feb Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I Budget I ofBUd et Other Miscellaneous Rain Da 102 1,105 3,164 4,289 4,527 1.474 2,091 845 1,508 4,887 2,755 1,126 (3,287) 24,483 52,000 47% Excess Lev; 103 3,648 3,648 3,648 100% Gift Donation Bequest 217 10 21,140 38 50 16 23 150,009 17 131 74 29 3,761 175,299 178,403 98% Loss Recovery 227 1,018 2,913 3,945 4,119 1,316 1,850 738 1,295 4,138 2,287 860 2,148 22,331 31,950 70% Human Rights 258 89 4,817 9,168 4,420 5,145 148 9,936 26,668 6,877 53,003 70,518 101,781 272,697 239,033 114% Morris Palais Marketing 273 354 3,005 542 364 932 1,118 653 1,150 115 1,059 4 1,390 10,685 9,500 112% Professional Sports Development 377 101,255 113,844 299 354 106 121,664 72,350 46,954 59,230 45,244 58,514 234 619,580 678,228 91% 1201 Code Enforcement 600 585,873 8,041 13,979 598,989 20,188 99,607 12,878 4,275 17,290 1,164,762 16,571 97,767 2,640,220 2,632,829 100% 1207 Animal Control 600 5,770 4,102 4,463 5,513 4,285 5,776 6,423 5,213 4,275 6,453 3,351 4,000 59,624 72,608 82% 1306 Building Operations 600 80,574 51,956 84,261 76,484 80,228 90,611 83,722 75,298 106,941 121,616 76,901 81,947 1,010,539 1,159,100 87% Century Center 670 101,443 830,395 167,457 108,952 162,563 164,074 1,341,465 74,507 231,218 333,312 171,423 400,893 4,087,703 5,078,128 80% Century Center Capital 671 30 57 29 30 29 59 23 24 23 24 328 500 66% Sub Total 877,520 1,043,378 288,498 803,800 276,284 486,961 1,659,176 236,943 435,125 1,730,590 399,322 589,542 8,927,139 10,135,937 88% Business Insurance 0000 Business Insurance Revenues 226 235,841 273,423 244,661 240,954 239,180 250,200 238,824 242,352 241,238 240,430 349,776 239,334 3,036,215 3088,399 98% 0418 Workers Compensation 226 17,000 0% Sub Total 235,841 273,423 244,661 240,954 239,180 250,200 238,824 24Z352 241,238 240,430 349,776 239,334 3,036,215 3,105,399 98% Fiduc- Trust & A enc Trust Fire Pension 701 157 330 223 2 564 549 131 Z564,701 2 165 251 1,396 5,131,903 5,391,332 95% Police Pension 702 261 614 539 217 3,055,933 218 3,060,435 316 351 94 6,118,791 6,310,500 97% Employee Benefits 711 939,099 988,883 1,008,404 1 356 220 1,080,537 1 074 338 1,175,351 1 155 029 1,104,471 1 158 188 11116,170 1 162,287 13,318,976 14 097,608 94% Unemployment Comp 713 8,564 8,625 8,658 8,661 8,572 8,588 8,553 8,570 8,658 8,602 8,560 8,436 103,047 103,214 100% Cemetery Trust 730 5 14 18 19 6 9 4 6 18 9 4 11 101 250 41% Sub Total 948,086 998,466 1,017,843 1 365 117 1,089,115 6 703 416 1,183,908 1 163 953 6,738,283 1 167 280 1,125,336 1 172,014 24 672,818 25 902,904 95% Civil City Revenues 15,022,978 13,469,813 13,985,515 14,960,176 13,049,281 45,399,015 13,831,845 16,745,330 18,861,928 15,657,180 13,698,291 35,833,642 230,514,997 244,299,218 94% Tax Increment Financing TIF Airport 324 2,853 9,393 12,246 12,595 4,035 7,627,935 7,704 101,815 18,214 19,115 8,950 6,752,676 14,577,531 14,638,874 100% TIF Central Development 420 30,402 30,591 15,776 254,752 33,198 2,515,902 30,165 30,240 7,819 230,826 29,981 1,875,706 5,085,358 5,114,778 99% TIF West Washington 422 58 225 305 322 105 304,301 66 160 519 293 120 276,326 582,799 583,488 100% TIF Leighton Plaza 425 9,940 15,407 12,374 18,352 7,014 16,916 12,244 14,865 11,378 21,470 15,283 9,909 165,150 194,285 85% TIF Medical Service 426 371 1,141 1,524 1,609 445 460,029 157 344 1,108 611 250 390,604 858,194 866,211 99% TIF Northeast 429 349 1,104 1,497 1,580 514 808,914 311 667 2,163 1,219 497 758,176 1,576,990 1,577,240 100% TIF Southside 430 402 1,246 1,669 1,721 542 1,269,709 331 762 2,371 1,324 541 1,108,193 2,388,812 2,515,000 95% TIF Erskine Village 432 762 2,277 3,012 3,180 1,035 10,644 593 1,047 3,360 1,894 774 (2,260) 26,320 54,575 48% TIF Douglas Road 435 23 108 147 143 34 160,996 23 63 56 19 8 160,831 322,451 322,645 100% Northeast Residential TIF 436 244 920 502 362 118 1,382,665 95 354 345 155 47 1,342,497 2,728,304 2,730,109 100% Sub Total 45,404 62,412 49,053 294,616 47,040 14,558,011 51,686 150,317 47,332 276,926 56,451 12,672,658 28,311,909 28,597,205 99% Financial Report December 2014 - Exp -dk- Summary Page 9 of 25 City of South Bend Period Ending: December 31, 2014 Revenue by Fund Report s i Fund I Jan I Feb Mar Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I Bud et I Of Bud et Redevelopment Commission 117,919 149,560 108,892 425,698 252,863 14,789,226 291,746 403,632 226,362 352,080 1,405,760 12,675,943 31,199,679 31,809,887 98% City Operations Total 15,140,899 13,619,373 14,094,408 15,385,874 13,302,144 60,188,241 14,123,591 17,148,962 19,088,290 16,009,260 15,104,051 48,509,586 261,714,677 276,109,105 95% Revenue report 15,140,898 13,619,374 14,094,408 15,385,874 13,302,144 60,188,241 14,123,591 17,148,962 19,088,290 16,009,260 15,104,051 48,509,586 261,714,677 276,109,105 1 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report December 2014 - Expenditure Summary Page 10 of 25 City of South Bend Period Ending: December 31, 2014 Property Tax Revenue 2013 Tax Pay 2014 Fund Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy 101 Per County Collection Projected 61612014 612512014 1212412014 Total Property Tax Collection 36,779,631.05 Records Factor Collections Collections Collections Collections Collections Receivable Rate Citv Airport TIF District General Fund 101 38,715,401.11 0.95 36,779,631.05 13,984,752.01 6,078,082.84 16,646,154.38 36,708,989.23 2,006,411.88 94.82% Parks & Recreation 201 7,760,516.48 0.95 7,372,490.66 2,803,248.70 1,218,353.96 3,343,785.26 7,365,387.92 395,128.56 94.91% College Football Hall of Fame 313 524,471.43 0.95 498,247.86 - 271,788.05 225,979.78 497,767.83 26,703.60 94.91% Cumulative Capital District 406 453,896.12 0.95 431,201.31 163,956.07 71,258.93 195,570.89 430,785.89 23,110.23 94.91% Fire Pension 701 - 0.95 - - - 2,478,709.77 - - - Police Pension 702 99,497.78 0.95 Erskine Commons TIF District #2 431 0.95 - Total - City - 47,454,285.14 Erskine Village TIF District #3 45,081,570.88 16,951,956.78 7,639,483.78 20,411,490.31 45,002,930.87 2,451,354.27 94.83% Tax Increment Financinq Airport TIF District 324 15,600,858.95 0.95 14,820,816.00 7,521,012.22 6,763,722.21 14,284,734.43 1,316,124.52 91.56% South Bend Central TIF District 420 4,376,939.50 0.95 4,158,092.53 2,485,265.66 1,824,461.25 4,309,726.91 67,212.59 98.46% West Washington TIF District 422 602,782.79 0.95 572,643.65 304,152.20 276,835.15 580,987.35 21,795.44 96.38% Central Medical TIF District 426 764,755.26 0.95 726,517.50 459,659.10 391,551.74 851,210.84 (86,455.58) 111.30% Northeast Residential TIF District 436 2,674,146.48 0.95 2,540,439.16 1,382,498.19 1,343,410.58 2,725,908.77 (51,762.29) 101.94% Southside TIF District # 1 430 2,478,709.77 0.95 2,354,774.28 1,268,946.48 1,110,265.51 2,379,211.99 99,497.78 95.99% Erskine Commons TIF District #2 431 0.95 - - - - Erskine Village TIF District #3 432 - 0.95 - 9,175.08 - 9,175.08 (9,175.08) 100.00% Douglas Road TIF District 435 321,894.56 0.95 305,799.83 160,947.28 160,947.28 321,894.56 - 100.00% Northeast TIF 429 1,649,304.42 0.95 1,566,839.20 808,183.73 760,056.03 1,568,239.76 81,064.66 95.08% Airport Urban Enterprise Zone 454 0.95 - - - - Other xxx - Total - Tax Increment Financing 28,469,391.73 27,045,922.14 14,399,839.94 12,631,249.75 27,031,089.69 1,438,302.04 94.95% Grand Total 75,923,676.87 72,127,493.03 16,951,956.78 22,039,323.72 33,042,740.06 72,034,020.56 3,889,656.31 94.88% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 616114 2 Distribution 2 - Issued by St. Joseph County on 6125114 3 Distribution 3 - Issued by St. Joseph County on 12124114 Financial Report December 2014 - Property Tax Revenue Page 11 of 25 City of South Bend Property Tax Revenue 2012 Tax Pay 2013 Fund Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy Per County Collection Projected 61412013 611712013 1212312013 Total Property Tax Collection Airport TIF District 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% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 614113 2 Distribution 2 - Issued by St. Joseph County on 6117113 3 Distribution 3 - Issued by St. Joseph County on 12123113 X Financial Report December 2014 - Property Tax Revenue Page 12 of 25 City of South Bend Period Ending: December 31, 2014 Expenditure Report S i Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Au Sqp I Oct I Nov I Dec I Year I Budget of Bud et ral Government ?01 Code 101 740 3,642 (2,402) (1,129) 1,460 2,311 5,225 ?05 Code Unsafe Building 101 750 (750) ?07 Code Animal Control 101 612 (0) (312) (120) 70 35 327 (33) 579 101 Police 'Of Mayor 101 73,969 52,004 52,578 54,407 51,628 51,451 51,780 70,225 54,333 70,454 56,446 58,333 697,608 716,646 '04 311 Ca II Center 101 39,235 38,732 31,260 38,185 35,128 32,410 32,517 45,786 33,274 33,332 36,746 32,707 429,313 488,908 ?01 Clerk 101 33,254 24,949 24,763 25,023 25,501 22,930 32,837 40,496 24,452 23,817 28,972 26,600 333,593 393,508 101 Common Council 101 33,804 16,129 22,696 28,970 24,570 16,770 48,596 23,365 98,765 22,122 16,945 64,928 417,660 543,698 101 Administration and Finance 101 184,882 129,923 146,822 191,183 163,566 156,110 186,876 217,641 141,182 141,795 145,806 145,470 1,951,256 2,087,009 i01 Legal Department 101 111,670 74,144 74,485 83,836 76,265 73,434 68,166 96,508 71,744 67,196 81,557 66,947 945,954 1,025,635 Sub Total 476,814 335,881 352,603 421,604 376,658 353,106 420,772 494,022 423,750 358,716 366,473 394,985 4,775,384 5,255,404 C Works t02 Engineering 101 100,714 83,713 46,461 132,468 68,149 78,784 76,398 142,543 71,783 63,202 73,754 58,780 996,749 1,126,302 Sub Total 100,714 83,713 46,461 132,468 68,149 78,784 76,398 142,543 71,783 63,202 73,754 58,780 996,749 1,126,302 C Safety ?01 Code 101 740 3,642 (2,402) (1,129) 1,460 2,311 5,225 ?05 Code Unsafe Building 101 750 (750) ?07 Code Animal Control 101 612 (0) (312) (120) 70 35 327 (33) 579 101 Police 101 2,352,204 1,889,108 1,847,740 1,829,954 1,666,157 1,831,413 1,791,370 2,331,435 2,090,447 1,984,414 1,779,402 2,292,794 23,686,438 24,940,204 102 Police Communications 101 205,840 146,325 143,663 159,049 149,203 162,622 162,099 223,005 154,911 144,974 153,357 180,897 1,985,945 2,021,486 101 Fire 101 2,004,690 1,591,802 1,605,489 1,805,201 1,601,475 1,776,613 1,725,929 2,210,527 1,672,369 1,596,923 1,842,114 2,148,065 21,581,197 21,649,415 1 Sub Total 4,776,421 3,539,947 3,470,493 3,794,204 3,416,835 3,770,647 3,679,398 4,764,967 3,917,727 3,726,311 3,774,873 4,621,757 47,253,580 48,611,105 Enforcement ?01 Code 101 740 3,642 (2,402) (1,129) 1,460 2,311 5,225 ?05 Code Unsafe Building 101 750 (750) ?07 Code Animal Control 101 612 (0) (312) (120) 70 35 327 (33) 579 2,254 Sub Total 740 4,254 (2,403) (1,441) 750 (120) 70 35 1,037 (33) 2,890 7,479 6 Culture 104 Morris PAC 101 87,838 86,253 87,012 79,972 71,819 78,815 64,421 93,809 61,575 66,230 64,505 80,053 922,302 1,063,527 105 Palais Royale 101 43,724 31,427 36,381 35,103 32,903 32,545 28,354 41,019 29,491 28,642 25,106 36,630 401,325 523,710 Sub Total 131,562 117,680 123,393 115,075 104,722 111,360 92,776 134,828 91,066 94,871 89,611 116,683 1,323,628 1,587,237 m Rights )08 Human Rights 101 31,977 26,096 24,523 26,765 25,976 25,472 26,797 39,361 30,278 28,569 22,371 25,961 334,144 367,262 Sub Total 31,977 26,096 24,523 26,765 25,976 25,472 26,797 39,361 30,278 28,569 22,371 25,961 334,144 367,262 General Fund Expenditure Total 5,518,227 4,107,572 4,015,071 4,488,675 3,992,340 4,340,119 4,296,141 5,575,600 4,534,674 4,271,704 4,328,119 5,218,133 54,686,373 56,954,789 96% Financial Report December 2014 - &p-dk- Summary Page 13 of 25 City of South Bend Period Ending: December 31, 2014 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Au Sep I Oct I Nov I Dec I Year I Budget of Bud et Parks & Recreation Motor Vehicle Highway 1100 Administration 201 113,658 84,616 98,120 123,483 117,058 108,772 lIZ157 188,473 146,251 92,649 133,854 101,198 1,420,289 1,564,813 91% 1101 Maintenance 201 440,988 353,914 390,644 351,149 421,395 439,897 483,557 535,154 508,966 368,534 363,444 446,251 5,103,895 4,947,775 103% 1102 GolfOperations 201 79,201 66,423 162,024 161,674 154,410 148,933 160,978 172,210 141,499 111,995 94,476 133,747 1,587,569 1,526,640 104% 1103 Recreation Division 201 195,148 128,820 129,384 142,829 13Z 121 145,116 226,862 290,181 154,080 137,701 139,891 170,486 1,992,616 2,114,512 94% 1104 Potawatomi Zoo 201 669,326 24,910 19,666 20,268 18,914 423,970 20,573 24,440 22,395 15,335 44,611 27,634 1,332,042 2,283,664 58% 1106 Potawatomi Greenhouse 201 8,161 7,588 5,995 4,098 17,073 1,247 2,193 1,084 855 1,086 1,324 5,604 56,309 59,614 94% 1108 Graffiti Removal 201 7,701 4,982 7,622 7,691 6,556 8,602 7,235 9,726 7,386 6,298 7,349 8,543 89,692 103,860 86% Recreation Non Reverting 203 42,584 72,465 55,717 59,083 74,464 80,663 125,151 141,292 69,038 52,313 69,455 67,599 909,822 1,479,064 62% East Race Waterway 271 1,220,608 1,289,727 1,080,910 2045 7,047 1,455,274 1,462,006 1,209,937 1,245,144 1,276,004 1,025,182 2,831,009 9,092 10,346 88% Coveleski Stadium 401 500 850 750 1,539,362 132,890 350 350 400 5,648,880 1,977,890 9,302,222 3,540 0% Park Non Revertin 405 4,814 111,962 14,077 19,071 67 7,473 1,752 5,092 1,378 23,220 188,904 205,217 92% Sub Total 658 1,561,582 855,681 869,172 886,397 968,107 1,357,266 1,146,178 1,364,312 1,055,560 787,288 854,405 984,283 12,690,232 14,299,045 89% Yorks Motor Vehicle Highway 202 818,846 888,630 620,621 596,446 460,643 459,703 431,613 467,300 736,465 939,355 773,984 629,903 7,823,509 8,856,075 Curb and Sidewalk 202 49,312 36,865 30,043 28,523 40,168 41,673 96,666 52,411 260,207 178,416 43,456 110,579 968,319 1,152,802 Central Services 222 672,962 610,722 687,806 59Z 769 556,636 479,824 587,811 645,216 556,287 516,792 541,672 586,149 7,034,645 8,036,532 Local Roads & Streets 251 19,206 12 316 11,761 622 3,600 43,936 206,924 6,071 125,773 5,696 123,694 2 100 557,475 1,124,520 Project ReLeaf 655 14,433 3,216 2324 26,854 2823 2517 14,265 2852 7,288 29,550 27,834 263,586 397,542 430,114 Sub Total 42,093 1,574,759 1,551,748 1,352,556 1,244,591 1,060,270 1,027,652 1,337,279 1,173,850 1,686,020 1,669,808 1,510,639 1,592,317 16,781,490 19,600,043 Vorks Solid Waste Solid Waste Operations 610 672,124 364,775 527,277 436,201 495,263 408,192 585,467 507,445 555,415 340,689 443,646 344,709 5,681,203 5,854,463 Solid Waste Capital 611 264,795 79,617 45,260 83,600 29,025 10,821 220,069 34,713 10,821 83,640 40 10,902 873,306 996,070 Sub Total 936,920 444,393 572,537 519,801 524,288 419,013 805,536 54Z 158 566,237 424,330 443,686 355,611 6,554,509 6,850,533 Public Works Water Utility 0630 Water Leak Insurance 620 60,631 71,687 5Z589 6Z286 117,419 588 24Z562 139,468 87,557 77,955 54,543 46,823 1,014 106 1,115,000 91 0640 Water Works 620 1,137,738 1,021,433 1,021,980 1,133,868 1,231,292 1,069,240 1,131,394 1,067,628 993,159 953,780 916,465 1,067,690 12,745,667 13,724,004 93% 0660 Clay Water 620 215 37,262 3 27,777 105 35 2 38 1 127 48 16 590 3,000 20% Waterworks Capital 622 3,600 1,880,989 3,676,419 1,803,956 1,896,757 53 11,250 1,300 131,658 227,565 11,401 29,749 416,576 978,258 43% Waterworks Construction 623 17,780 195,292 4,436 191,283 38,778 430 76,003 355 30,220 15,077 42,093 19,960 631,706 811,011 785/ Waterworks Deposit 624 186 534 724 768 250 355 143 256 829 469 192 291 4,997 6,000 83% Waterworks Sinking 625 196 36 157 240 117 384,067 448 528 540 366 168 1,666,070 2,052,934 2,057,224 1005/ Waterworks Debt Reserve 629 261 746 1,021 1,094 356 505 204 364 1,180 665 272 411 7,079 8,500 83% Sub Total 647 1,220,608 1,289,727 1,080,910 1,389,538 1,388,316 1,455,274 1,462,006 1,209,937 1,245,144 1,276,004 1,025,182 2,831,009 16,873,656 18,702,997 90% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 17,250 30,211 23,925 22,790 50,604 16,799 89,589 40,179 33,989 33,189 43,364 39,546 441,433 549,978 80% 0621 Sewer Repair 641 461,905 389,062 283,083 389,913 341,488 309,177 370,813 373,545 416,466 302,270 293,430 313,894 4,245,046 5,132,912 83% 0625 Concrete Crew 641 39,120 37,262 32,982 27,777 28,774 26,040 24,188 35,595 33,720 24,937 30,668 28,375 369,438 453,145 82% 0630 Wastewater Operations 641 4,020,021 1,880,989 3,676,419 1,803,956 1,896,757 1,768,194 1,830,588 2,011,179 2,002,423 1,743,537 1,741,615 1,728,275 26,103,956 28,765,521 91% 0631 Organic Resources 641 78,091 82,861 91,592 95,259 63,735 92,096 69,529 68,391 55,870 47,536 58,155 87,566 890,679 1,202,616 74% 0650 Clay Sewage 641 978 0 158 1,939 158 14 171 211 65 1,422 2,000 71% Sewage Ca ital 642 978,994 416,435 421,874 311,133 164,146 350,346 152,471 319,205 294,490 488,409 80,597 329,856 4,307,956 9,436,035 46% Sewage Reserve 643 422 1,221 1,702 1,797 585 829 335 598 1,937 1,092 446 674 11,637 15,000 78% Sewer Bond 2007 647 805 338 1,143 1,144 100% Sewage Bond Sinking 649 500 850 750 1,539,362 132,890 350 350 400 5,648,880 1,977,890 9,302,222 9,802,231 95% Sewage Bond 2007 651 2 2 NA 2010 CSO Net Sewer Bond 658 924 1,296 2220 2221 100% 2011 Sewer Bond 659 275,419 265,818 144,834 676,437 418,754 711,646 424,489 187,892 384,241 1,278,177 950,835 550,237 6,268,779 13,598,486 46% 2012 Sewer Bond 661 272,470 216,156 17,815 575 6,278 10,485 343,500 43,386 61,503 558,854 1,531,023 18,868,570 8% 2013 Sewer Bond 663 NA Sub Total 6,143,212 3,320,865 4,694,227 3,330,387 4,504,204 3,414,941 2,965,557 3,047,577 3,567,049 3,962,705 8,911,000 5,615,230 53,476,953 87,829,859 6191 Financial Report December 2014 - &p-dk- Summary Page 14 of 25 City of South Bend Period Ending: December 31, 2014 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun Jul I Au I Sep I Oct I Nov I Dec I Year I Budget of Bud et O011ce EMS Capital 288 449,207 280,578 359,503 943,903 306,775 116,574 363,982 1,353,687 500,249 64,393 502,734 205,048 5,446,632 6,287,299 Hazmat 289 697 697 30,000 River Rescue 291 199 1,283 0 57 5,200 6,014 11,517 721 1,409 3,294 923 975 31,594 52,300 Sub Total Seizures 216 6,369,599 740 43,308 12,138 12,650 10,669 9,081 16,917 8,720 12,145 7,709 172,609 1,415,000 40,000 0% vViolations 218 18,003 _ _ 18,003 _ _ 18,003 _ 20,550 18,003 92,560 2,162,886 DCI Operating 1,000 0% nforcement Education 220 11,075 20,490 23,204 3,629 11,393 22,041 11,790 16,635 25,779 29,909 18,037 31,851 225,833 294,802 77% !ency Telephone S stem 244 27,387 16,003 16,999 18,603 17,040 11,973 12,813 15,295 11,577 11,260 10,742 11,637 181,329 215,000 84% SafetyLOIT 249 517,291 613,746 709,196 593,832 573,243 614,034 575,843 778,855 582,596 558,924 454,080 551,774 7,123,412 7,214,658 99% E Welfare Public Safety 252 8,365 29,593 113,460 84,853 16,685 15,432 245,776 375,595 Sub Total 586,245 337,650 1,146 1,146 1,146 100% Take Home Vehicle 278 590,297 614,839 1,158,741 399,864 632,588 6,909,624 13,173,555 7,028 60,580 0 0 60,580 80,580 75% Grants 292 20,975 138,059 37,702 10,204 20,975 185,965 228,060 82% Academy 294 136 197 330 3,967 6,380 564 259 710 3,960 821 430 543 18,300 23,750 77% More Grants 295 175 1,484 1,185 1,417 1,328 1,795 2,417 1,513 3,262 1,364 717 2,867 19,524 141,600 14% Enforcement 299 4,831,372 2,731 3,839 29,849 8,657 3,957 3,506,193 1,628 43,006 502 9,636 3,537 107,342 166,499 64% lit 705 2,000 0% Dtal 556,065 654,651 892,811 651,297 618,041 654,364 603,122 814,636 707,883 673,564 493,642 603,355 7,923,431 8,409,095 94% afe - Fire EMS Capital 288 449,207 280,578 359,503 943,903 306,775 116,574 363,982 1,353,687 500,249 64,393 502,734 205,048 5,446,632 6,287,299 Hazmat 289 697 697 30,000 River Rescue 291 199 1,283 0 57 5,200 6,014 11,517 721 1,409 3,294 923 975 31,594 52,300 Sub Total 449,407 281,861 359,503 943,960 311,974 122,587 375,500 1,354,409 501,657 67,688 504,353 206,023 5,478,923 6,369,599 ant of Community Investment Studebaker /Oliver 209 22,732 15,801 740 43,308 12,138 12,650 10,669 9,081 16,917 8,720 12,145 7,709 172,609 1,415,000 State Grant 210 _ _ 18,003 _ _ 18,003 _ _ 18,003 _ 20,550 18,003 92,560 2,162,886 DCI Operating 211 236,843 167,810 175,126 174,007 169,920 174,698 173,575 240,190 167,330 162,906 178,423 172,644 2,193,473 2,404,884 Dept. of Community Investment 212 85,538 190,071 52,948 198,374 292,394 149,543 1,137,228 320,514 429,506 910,982 184,206 426,509 4,377,814 6,812,862 Administration 212 21,424 12,784 718 39,704 13,824 10,495 9,389 8,130 8,704 8,721 11,931 146,076 291,901 2,328 Programs 212 15,269 811 12,709 5,393 18,891 37,774 8,365 29,593 113,460 84,853 16,685 15,432 245,776 375,595 Sub Total 586,245 337,650 358,693 258,786 377,775 481,205 380,019 1,319,168 590,297 614,839 1,158,741 399,864 632,588 6,909,624 13,173,555 Garages Main Street 601 22,732 15,801 740 43,308 12,138 12,650 10,669 9,081 16,917 8,720 12,145 7,709 172,609 388,575 St. Joseph 601 _ _ _ _ _ _ _ _ _ _ _ _ _ _ Leighton Plaza 601 39,122 41,189 2,241 69,225 21,180 18,657 18,771 15,315 19,483 9,325 17,971 19,950 292,429 575,008 Enforcement 601 13,486 4,479 196 8,021 4,204 4,739 8,900 6,346 6,939 196 6,676 10,553 74,736 90,606 Wayne Street 601 21,424 12,784 718 39,704 13,824 10,495 9,389 8,130 8,704 8,721 11,931 146,076 291,901 527,719 Eddy Street Commons 601 42,656 9,881,840 10,289,984 96% Major Moves 412 29,594 71,075 113,460 98,190 68,110 119,867 412,296 15,900 Sub Total 586,245 96,764 74,254 3,896 160,258 51,347 46,542 47,729 38,873 52,043 26,962 48,723 184,287 831,676 1,597,808 Ca I I /Debt Service Hall of Fame 313 634,500 636,000 800 1,271,300 1,271,300 100% COIT 404 1,612,310 385,712 447,510 943,423 420,072 649,232 1,018,798 392,180 693,900 942,142 464,614 1,193,046 9,162,940 11,165,785 82% Cum Capital Development 406 112,650 56,546 135,726 56,545 112,650 56,545 135,726 56,545 722,934 722,935 100% Cum Capital Improvement 407 185,250 183,750 800 369,800 369,800 100% EDIT 408 2,229,819 244,434 176,179 2,057,472 119,643 121,261 1,137,926 669,170 127,260 2,624,940 331,080 42,656 9,881,840 10,289,984 96% Major Moves 412 29,594 71,075 113,460 98,190 68,110 119,867 412,296 337,489 574,923 586,245 847,125 780,315 4,038,690 5,823,729 69% Morris PAC Improvement 416 2,911 4,227 652 7,028 3,490 4,213 22,522 53,200 42% CRED 434 20,975 20,975 650,950 0% Palis Historic Preservation 450 10,000 0% Hallaof Fame Capital 677 6,273 7,962 6,049 17,448 3,521 3,079 4,120 3,295 7,156 16,293 20,793 5,019 101,009 188,567 54% Sub Total 4,831,372 709,183 802,655 3,116,534 751,299 949,985 3,506,193 1,409,162 1,459,784 4,171,220 1,802,828 2,060,821 25,571,036 30,546,250 84% Financial Report December 2014 - &p-dk- Summary Page 15 of 25 City of South Bend Period Ending: December 31, 2014 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I AuIy I Sp I Nov I Dec I Year I Budget of Bud et Other Miscellaneous Self Funded Liability Ins Gift Donation Be oast 217 18,720 18,955 17,554 15,920 2,786 16,406 10,950 20,760 20,416 52,583 18,329 45,776 112,095 201,010 56% Loss Recovery 227 5,154 6,805 201,942 81,844 47,647 130,545 104,828 111,852 479,103 437,585 218,460 268,708 2,094,471 6,615,805 32% Human Ri hts 258 19,647 10,646 9,995 11,474 18,099 14,553 14,445 23,131 24,159 23,793 22,878 16,401 209,220 274,001 76% Morris Palais Marketin 273 3,628 51,044 982 2,453 705 547 50,042 878 865,282 1,888 Sub Total 878 11,957 18,000 66% ProfessionalSports Development 377 382,873 800 108,426 100,000 99,361 83,919 381,873 2,541,638 2,897,200 Sub Total 14,500 1,536,369 865,545 865,746 100% 1201 Code Enforcement 600 87,023 68,770 63,184 171,941 96,142 64,086 275,227 89,043 127,009 254,454 60,762 159,268 1,516,908 1,836,074 83% 1207 Animal Control 600 58,611 49,070 47,679 54,707 52,463 43,720 54,024 59,326 54,354 48,356 45,845 58,700 626,856 689,215 91% 1306 Building Operations 600 102,831 81,636 75,880 78,138 76,132 81,274 82,824 103,175 78,082 77,256 73,622 73,825 984,674 1,273,620 77% Cantu Center 670 314,629 427,425 323,712 278,861 560,565 306,614 360,870 47,716 245,407 304,536 297,210 351,376 3,818,921 4,564,898 84% Century Center Capital 671 1,464,500 400,791 1,000 1,464,000 339,363 246,589 339,363 393,547 86% Sub Total 974,395 645,150 723,375 779,417 854,539 641,338 1,285,039 774,483 1,008,115 1,200,450 718,777 974,932 10,580,010 16,731,916 63% Insurance Self Funded Liability Ins 226 20,289 18,720 18,955 17,554 15,920 15,072 16,406 20,694 20,760 20,416 16,694 18,329 219,809 253,743 Liability Insurance 226 39,002 243,446 47,138 64,670 26,048 15,285 127,528 7,029 58,161 8,092 10,923 270,676 917,998 1,028,811 Business Insurance 226 6,557 29,628 27,028 1,799 6,529 430,622 4,500 6,529 18,828 1,339,220 6,259 270 538,549 572,300 Workers Compensation 226 37,558 198,648 118,501 11,833 73,933 51,044 56,596 74,174 37,030 70,853 50,042 85,071 865,282 1,042,346 Sub Total 730 103,406 490,442 211,622 95,856 122,430 512,022 205,029 108,426 134,780 99,361 83,919 374,346 2,541,638 2,897,200 Trust & Agency Fire Pension 701 457,164 448,542 448,687 456,878 451,651 462,793 450,825 448,342 488,686 439,603 441,480 436,047 5,430,699 5,874,445 Police Pension 702 542,603 643,997 645,479 553,882 530,320 566,915 543,126 530,266 530,041 551,172 536,372 542,504 6,716,677 7,221,941 Employee Benefits 711 526,930 1,807,630 1,315,439 1,462,755 1,128,213 846,028 1,602,281 1,209,081 1,116,966 1,339,220 1,158,664 1,410,230 14,923,436 15,931,637 Unemployment Comp 713 9,673 16,224 12,294 13,584 18,283 13,315 7,135 12,357 8,540 6,488 2,774 1,241 121,906 227,974 City Cemetery Trust 730 125,690 149,425 84% TIF Medical Service 426 169,224 8,658 1,532,233 28,057 8,658 20,595 Sub Total 14,500 1,536,369 2,916,392 2,421,899 2,487,098 2,128,467 1,889,051 2,603,367 2,208,704 2,144,233 2,336,483 2,139,289 2,390,023 27,201,375 29,276,592 Civil City Expenditure 25,840,735 17,700,611 18,259,018 20,471,583 17,756,829 17,210,172 21,957,844 20,212,423 19,278,018 22,126,307 23,264,426 24,022,959 248,100,924 313,239,281 79% Tax Increment Financing TIFAir ort 324 1,403,524 250,577 673,576 192,333 433,246 161,642 1,435,500 749,457 585,473 646,662 701,131 984,638 8,217,759 27,286,693 30% TIF Central Development 420 1,015,931 314,263 51,873 339,598 42,310 32,302 1,274,876 25,099 25,663 228,764 2,196 252,877 3,601,359 5,829,261 62% TIF West Washington 422 319 360 786 119 12 657,534 0% TIF Leighton Plaza 425 4,077 13,665 13,842 7,161 15,045 16,524 8,803 11,357 5,317 3,517 21,472 4,910 125,690 149,425 84% TIF Medical Service 426 169,224 1,532,233 28,057 52,059 14,500 1,796,073 4,103,504 44% TIF Northeast 429 617 859 4,434 9,744 8,814 4,834 29,301 2,806,117 1% TIF Southside 430 81,949 8,298 169,406 27,289 15,925 43,125 6,064 201,858 11,920 1,403 207,344 96,588 871,169 6,487,957 13% TIF Erskine Village 432 354,606 137,545 492,151 494,151 100% TIF Douglas Road 435 160 95,231 300,230 395,621 399,823 99% Northeast Residential TIF 436 1,464,500 400,791 1,000 1,464,000 246,589 3,576,880 3,583,228 100% Sub Total 4,494,908 987,594 1,003,928 2,098,614 535,583 254,451 4,326,789 1,340,420 879,395 889,305 951,183 1,343,847 19,106,015 51,797,693 37% Financial Report December 2014 - &p-dk- Summary Page 16 of 25 City of South Bend Expenditure Report Period Ending: December 31, 2014 S i Fund I Jan I Feb I Mar I Apr I May Jun Jul I Au I Sep I Oct I Nov I Dec I Year I Budget of Bud et Redevelop ment Funds Administration 433 6,072 4,140 5,491 15,703 20,000 79% Certified Technology Park 439 3,600,000 09/ Blackthorn Go/fOperations 619 47,557 53,680 66,283 76,441 204,109 178,039 253,821 199,475 169,478 151,141 89,721 62,721 1,552,466 1,671,706 93% Sub Total 53,629 53,680 70,422 81,933 204,109 178,039 253,821 199,475 169,478 151,141 89,721 62,721 1,568,169 5,291,706 30% Redevelopment Commission 4,548,893 1,042,292 1,075,730 2,182,004 740,166 433,162 4,580,881 1,540,379 1,050,443 1,041,331 1,041,266 1,407,114 20,683,661 57,100,399 36% City Operations Total 30,389,628 18,742,903 19,334,748 22,653,588 18,496,995 17,643,334 26,538,725 21,752,802 20,328,461 23,167,638 24,305,691 25,430,073 268,784,587 370,339,680 73% Expenditure report 30,389,627 18,742,903 19,334,748 22,653,588 18,496,995 17,643,334 26,538,725 21,752,802 20,328,461 23,167,638 24,305,691 25,430,073 268,784,587 370,339,680 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report December 2014 - &p-dk- Summary Page 17 of 25 City of South Bend Debt Schedule Period Ending: December 31, 2014 Year of I Year of Yaar o/ Scheduled Payments Debt I Refit Debtat 2014 Principal 20141nterest 2014 Debt at 1014 Total Debt Instrument Debf Purpose Issue Refunding Maturity Fund let Ind 3rd 4th Issue 11131/2013 Payments Payment Addition f11J1/201d Debt Payments Civil Citv Debt Bond Debt Amort acM1 # 31 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 4385.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 HQ / Police HQ 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 6/1 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 40 Sewage Works Improvements Sewage Works 2007 2027 649 6/1 1211 - - 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 20076 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 52 Century Center Special Tax Bonds Century Canter 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 s9 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 1211 - - 3,297,000.00 2,710,898.00 149,511.00 76,176.00 0.00 2,561,387.00 225,687.00 a0 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 0 Sewage Works Revenue Bonds 2011 Sewage Works 2011 2031 649 6/1 1211 - - 21,500,000.00 19,895,000.00 855,000.00 732,300.00 0.00 19,040,000.00 1,587,300.00 ss 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 tot 2012 Sewage Works Revenue Bonds Sewage Works 2012 2032 649 6/1 1211 - - 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 105 2013A 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 [52013 Buildinq Corporation 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 68 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 az Inlerfund Loan 410 - UDAG tat 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 z5 State Revolving Fund WMar Workslmprovements 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 Payable 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 Eouipment 2007 2012 288 611 12/1 - - 621,520.00 0.00 000 0.00 0.00 0.00 0.00 51 Chase LED Equipment 2007 2017 101 1/1 7/1 - - 1,531,573.00 730,258.41 171,136.37 29,443.29 0.00 559,122.04 200,579.66 55 C rce omme 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 Michiqan 2008 2013 620 Monthly - - - 5,154.00 0.00 0.00 0.00 0.00 0.00 0.00 58 Lanier Copier 915 Olive 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/Trucks 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 Ka sea State Bank Clerk Lanier Doe 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 n Kansas State Bank Cade 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 7a Kan sas 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 Leasinq Inc IT Netaop San 2010 2014 404 1/1 4/1 7/1 10/1 207.521.37 14236.41 14236.41 210.59 0.00 0.00 14,447.00 ra Kansas State Bank Central Services Copley 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 Captal Information TechndogY Animal Control Copier 2010 2015 101 2/28 5/30 8/30 11/30 3,550.69 1,161.97 758.35 57.05 0.00 403.62 815.40 ra 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 79 Advanced Imacinq 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 ar Public Flnance.com Inc Solid Waste Contalners/Trucks 2011 2015 611 6/15 12/15 - 321,853.00 133,252.34 65,587.04 3,677.96 0.00 67,6fi5.30 69,265.00 89 Sun Trust Police. Parks. Bldq vehicles 2011 2016 404/201/600 3/15 (/15 9/15 12/15 2068.202.00 1.059,040.84 417,495.38 17,470.02 0.00 641,545.46 434.965.40 . Capital One Public Funding Sdid Waste Contalners/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 91 GE Capital Information TechndogY 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 868.72 9z 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 94 Ikon Office Solutions Mayor Ricoh MP 2651 SP Copier 2011 2016 101 2/15 5/15 8/15 11/15 2.569.53 1,620.15 509.86 78.62 0.00 1,110.29 588.48 95 Sun Trust EoulpmeM 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 97 Sun Tru Equipment Finance Police Vehicles & Equipment 2012 2017 406 5/15 11/15 - - 1295,000.00 918,678.73 256.966.38 14,484.90 0.00 661,712.35 271,451.28 9a PNC Eouipment Finance Public Works Vehicles Lease 2012 2017 2021641/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 Eouipment Finance Public Works Vehicles Lease 2012 2017 2021641/600/288 1/15 7/15 - - 2806,054.00 2.257,055.55 553.306.66 27,644.68 0.00 1.703,748.89 580,951.34 oz 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 103 GE Capital Information Techni Fire Department Copier 2012 2017 101 2/28 5/28 8/28 11/28 5,471.01 4,249.41 1.043.56 227.24 0.00 3,205.85 1,270.80 ,ca Ricoh USA (New) Central Services Copley 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 1 Ricoh USA Stree05ewer Dept Copier 2013 2018 202/641 3/4 6/4 9/4 1214 5.559.15 4.506.34 1.031.00 239.80 0.00 3,475.34 1,270.80 pa Ricoh USA City Attorney Cooler 2013 2018 101 2/12 5/12 8/12 11/12 5,559.15 4,528.32 1,035.69 235.11 0.00 3,492.63 1,270.80 1o9 Ricoh USA Parks & Rec Ricoh Cociers(3) 2013 2018 201 2/21 5/21 8/21 11/21 16.129.94 13.138.50 3.005.59 681.65 0.00 10,132.91 3,687.24 to PNC Equipment Finance Vehicle/Equipment Lease 2013 2018 101/202/406/641 1/15 7/15 - 1,689,669.59 1,689,669.59 327,718.32 22,182.20 0.00 1,361,951.27 349,900.52 11f Ricoh USA Engineering Plotter /Scanner 2013 2018 101 3/3 6/3 9/3 1213 10.667.67 8.694.31 1.904.10 687.90 0.00 6,790.21 2,592.00 12 Ricoh USA Buildinq 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 Eouipment Finance Police and PW vehicles 2013 2018 404/655/611/202 4/24 10/24 - - 1.506.465.26 1.506. 5.26 291.855.59 22.725.55 0.00 1.21 4.60 314,581.14 14 Ricoh USA Armin & Finance Copier 2013 2018 101 1/16 4/16 7/16 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 2/1 5/1 8/1 11/1 28.588.00 5,869.74 5.869.79 169.81 0.00 (0.05) 6,039.60 n 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 118 Water Works Main Ricoh Cooler Water Works Main Ricoh Copier 2013 2018 620 Monhly 10th 5.647.50 5,647.50 1.008.13 287.27 0.00 4,639.37 1,295.40 to Water Works Colfax Ricoh Copier Water Works Cdfax Ricoh Come 2013 2018 620 Monthly 16th 4,732.65 4,732.65 844.81 240.71 0.00 3,887.84 1,085.52 12g Water Works Olive Ricoh Copier Water Works Olive Ricoh Cooler 2013 2018 620 Monthly 101h 4.732.65 4,732.65 844.81 240.71 0.00 3,887.84 1,085.52 ,23 Po Training Dept. Ricoh Copier Tmininq Copier 2014 2019 101 Monthly 30th 4,263.00 0.00 548.62 169.48 4,263.00 3,714.38 718.10 124 Palice/Public Works Vehicle Lease 2014 CiN Vehicles 2014 2019 Various 4/1 10/1 1 959. 85.95 0.00 0.00 0.00 1,959.485.95 1.959.4B5 95 0.00 125 HP Computer Lease #1 Computer Eouipment Lease 2014 2018 various Monthly 8th 137,104.95 0.00 12,550.93 1,959.22 137,104.95 124,554.02 14,510.15 128 HP Computer Lease #2 Computer Eouipment Lease 2014 2018 201 and 620 Monthly 8th 4.000.00 0.00 280.05 60.11 4.000.00 3,719.95 340.16 zr HP Computer Lease #4 Computer Eouipment Lease 2014 2018 404 Monthly 8th 5,886.15 0.00 424.74 73.94 5,886.15 5,461.41 498.68 128 HP Computer Lease #6 Computer Eouipment Lease 2014 2018 201 Monthly 8th 3.755.50 0.00 194.40 44.88 3.755.50 3,561.10 239.28 29 HP Computer Lease #7 Computer Equipment Lease 2014 2018 620 Monthly 8th 1,326.00 0.00 23.87 4.20 1,326.00 1,302.13 28.07 130 So id West. Copier Ricoh USA Copier 2014 2019 611 Mom IV 17th 5,351.65 0.00 77.47 25.00 5.351.65 5,274.18 102.47 131 Police Communications Copier Ricoh USA Copier 2014 2019 101 Monthly 12th 8,843.00 0.00 646.14 200.46 8,843.00 8,196.86 846.60 132 Organic Resources & Wastewater Ricoh USA Copiers 2014 2019 641 Monthly 21st 12,260.18 0.00 1.077.57 330.93 12,260.18 11,182.61 1,408.50 Total CaPha /Lease 20.930,478.12 10.341,870.13 2.817,441.17 183,222.22 2,142,276.38 9,666,705.34 3,000,663.39 City of South Bend Debt Schedule Period Ending: December 31, 2014 Year of I Year of Year o/ Scheduled Payments Debt long Refit Debtat 2014 Principal 20141nterest 2014 Debt at 2014 Total Debt Instrument Debt Purpose Issue Refunding Maturity Fund let Ind 3rd 4th Issue 11131/2013 Payments Payment Addition f11J1/201d Debt Payments Redevelopment Commission Debt Bond Debt a Central Business TIF 1990 1996 2012 420 2/1 8/1 - - 3,790,000.00 0.00 0.00 0.00 0.00 0.00 0.00 fo Blackthorn Goff Cours e Blackthorn Golf 1992 1998 2013 619 311 9/1 - - 6,135,000.00 0.00 0.00 0.00 0.00 0.00 0.00 7 Cenlury Center Lease Rental Revenue Century Center 1994 2001/2011 2018 407 2/1 8/1 - - 6,825,000.00 2,070,000.00 440,000.00 46,350.00 0.00 1,630,000.00 486,350.00 8 College Football Hall of Fame Hall of Fame 1994 200012011 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 11 South Bend Buildinq Corporation Morris PAC mTJX 1998 2009 2017 408 2/1 8/1 - - 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 Special Taxing District 2002 2014 2022 324/4041414 1/1 7/1 - - 6,620,000.00 3,405,000.00 430,000.00 54,860.00 35,000.00 3,010,000.00 484,860.00 Downtown Central Area TIF s own 2003 2011 2024 420 2/1 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 a 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 zz Erskine Villme TIF Development Bond Erskine Village 2005 2027 432 2/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 54 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 of 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 2115 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 104 2012 Gates 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 Blackthorn Goff Cart Lease Blackthorn Gulf 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 1zz Svnagoque at Coveleski Improvements Covelaski Stadium 2014 2018 377 1/31 500,000.00 0.00 100,000.00 0.00 500,000.00 400,000.00 100,000.00 Total Bond Debt 140,213,788.00 83,123,333.34 7,783,216.62 3,905,381.35 828,788.00 76,168,90412 11,688,597.97 Loans Payable 3 Indiana Development Finance Authority Bosch Property(Nom-lve) 2001 2021 210 3/22 6/22 9/22 12/22 1,040,000.00 482,021 At 58,200.48 13,809.96 0.00 423,820.93 72,010.44 a Indiana Development Finance AuthariN Bosch Propertv(Forgive) 2001 2021 210 - - - - 260,000.00 133,214.96 16,084.70 3,816.62 0.00 117,130.26 19,901.32 z State Industrial Development Fund Bosch Proper" 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 3/31 6/30 9/30 12/31 764,809.60 0.00 0.00 0.00 0.00 0.00 0.00 is 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 to Indiana Development Finance Authot Anchor 2005 2014 404 6/30 12/31 - - 600,000.00 66.666.72 66.666.72 1,250.00 0.00 0.00 67,916.72 17 Ind -, 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 so HUD Section 108#8 Studebaker Oliver 2008 2025 434 2/1 8/1 - - 4,000,000.00 1,005,000.00 825,000.00 41,949.00 0.00 180,000.00 866,949.00 63 City of Mishawaka Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1,102,549.56 343,532.46 296,529.37 16,046.63 0.00 47,003.09 312,576.00 64 Interfund Fund 412 -Major MOVes Douglas Road TIF 2009 2029 435 2/15 B/15 - - 1,040,319.00 923,829.00 37,152.00 45,733.00 0.00 886,677.00 82,885.00 a3 Intertund Fund 619 - Blackthorn 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 Inlerfund Fund 412 -Major MOVes Triangle Development 2011 2029 436 2/15 8/15 - - 2,000,000.00 1,558,050.00 44,790.50 15,580.50 0.00 1,513,259.50 60,371.00 as Inter fund 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 re Interfund Fund 209 to Airport 324 Prairie Ave Brownfield Project 2011 2020 324 8/9 - - - 500,000.00 500,000.00 0.00 0.00 0.00 500,000.00 0.00 as Blackthorn Loan from Airport 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 0 22,058,511.06 8,506,351.78 1,569,116.13 307,42140 0.00 6,937,235.65 1,876,539.53 Capital Lease 75 PNC Equipment Financinq Blackthom Gdf Carts 2010 2015 619 Monthiv 246,509.64 106,802.80 106,802.80 4,33124 0.00 0.00 111,136.04 Total Capital Lease 1111009 246,509.64 106,802.80 106,802.80 4,333.24 0.00 0.00 111,136.04 Leases 37 Tranew Lease Leghton 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 1a Transco Lease 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 Tota /Lease 5,510,278.00 2,160,211.00 292,321.00 107,679.00 0.00 1,867,890.00 400,000.00 Total Redevelopment Commission ff 168.029,086.70 93.896,698.92 1 9.751.56.55 1 4324,816.99 828,788.00 1 84.974,030.37 1 14.076,273.54 Total Debt 450,125,344.82 257,332,552.05 22,450,243.72 9,582,622.95 2,971,064.38 237,853,372.71 32,032,866.67 City of South Bend Monthly Debt Schedule Period Ending: December 31, 2014 Year o/ Year of Year o/ Scheduled Payments Debt (Oriq /Re /i1 Debtat YTD Principal YTD Interest no Debt at Debt Instrument Debt Purpose Issue Refundinq Maturity Fund let 2nd 3rd 4th Issue 11131/2013 Payments Payments Additions 1213112014 Bond Debt Bosch Property Water W orks Improvement 1st Source /Marriott Garage Sewage Works Improvement W a[er W orks Improvements 2002 2009 2010 1998 2000 2022 2030 2015 2018 2019 210 625 410 649 625 1/30 7/1 6/15 6/1 7/1 4/30 12/31 12/15 12/1 12/31 7/30 - - - - 10/30 - - - - 506,448.00 427,332.00 2,700,000.00 24,095,000.00 2,600,000.00 0.00 391,297.00 2,027,973.00 0.00 1,018,815.00 0.00 18,933.00 0.00 0.00 157,902.00 0.00 13,186.70 0.00 0.00 29,546.00 0.00 0.00 0.00 0.00 0.00 Amort acM1 # 31 CEDIT Bond Total Loans Payable 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 36 South Bend Building Corporation Public Works Building 2001 2010 2021 404/649 2/1 8/1 - - 9.250.000.00 4385.000.00 525.000.00 145.626.00 0.00 3,860,000.00 25 m Water Works Improveents Water Works 2002 2012 2023 625 7/1 12/31 - - 5,975,000.00 3,450,000.00 350,000.00 69,000.00 0.00 3,100,000.00 39 South Band Building Corporation Fire HQ / Police HQ 2003 2012 2023 404/324 2/1 811 - - 21,335,000.00 12,365,000.00 1,120,000.00 446,010.00 0.00 11,245,000.00 41 Sewage Works Improvements ( #105) Sewage Works 2004 0.00 2024 649 6/1 12/1 - - 11,425,000.00 0.00 0.00 0.00 0.00 0.00 24 Water Works Improvements Water Works 2006 0.00 2027 625 7/1 12131 - - 4,710,000.00 3,505,000.00 205,000.00 155,438.00 0.00 3,300,000.00 42 Sewage Works Improvements Sewage Works 2006 0.00 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 40 Sewage Works Improvements Sewage Works 2007 0.00 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 52 Sewage Works Revenue Bonds 20078 Sewage Works 2007 5,154.00 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 52 Century Center Special Tax Bonds Century Canter 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 s9 Water Works Improvements Water Works 2009 - 2030 625 7/1 12/31 - - 5,380,000.00 4,985,000.00 210,000.00 270,232.00 0.00 4,775,000.00 70 Sewage Works Revenue Bonds -2009 Sewage Works 2009 4123 2028 649 6/1 1211 - - 3,297,000.00 2,710,898.00 149,511.00 76,176.00 0.00 2,561,387.00 a0 2010 Sewaqe Works Revenue Bonds Sewage Works 2010 1/23 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 0 Sewage Works Revenue Bonds 2011 Sewage Works 2011 101 2031 649 6/1 1211 - - 21,500,000.00 19,895,000.00 855,000.00 732,300.00 0.00 19,040,000.00 ss 2012 Water Works Revenue Bond Water Works 2012 2014 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 tot 2012 Sewage Works Revenue Bonds Sewage Works 2012 2010 2032 649 6/1 1211 - - 25,000,000.00 23,985,000.00 1,020,000.00 548,580.00 0.00 22,965,000.00 1p5 2013A Sewer Bond Refundinq 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 t [52013 Buildinq Corporation EMS / Fire Department 2013 7a Kansas State Bank 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 Loans Payable 1 State Revolving Fund 68 State Revolving Fund az Inlerfund Loan 410 - UDAG 44 State Revolving Fund (sch# 105) z5 State Revolving Fund Bosch Property Water W orks Improvement 1st Source /Marriott Garage Sewage Works Improvement W a[er W orks Improvements 2002 2009 2010 1998 2000 2022 2030 2015 2018 2019 210 625 410 649 625 1/30 7/1 6/15 6/1 7/1 4/30 12/31 12/15 12/1 12/31 7/30 - - - - 10/30 - - - - 506,448.00 427,332.00 2,700,000.00 24,095,000.00 2,600,000.00 0.00 391,297.00 2,027,973.00 0.00 1,018,815.00 0.00 18,933.00 0.00 0.00 157,902.00 0.00 13,186.70 0.00 0.00 29,546.00 0.00 0.00 0.00 0.00 0.00 0.00 372,364.00 2,027,973.00 0.00 860,913.00 Total Loans Payable 35,533,780.00 3,438,085.00 176,835.00 42,732.70 0.00 3,261,250.00 capital Leases 27 LaSalle Bank - Fire Fire Equipment 2007 2012 288 611 1211 - - 621,520.00 0.00 0.00 0.00 0.00 0.00 51 Chase LED Equipment 2007 2017 101 1/1 7/1 - - 1,531,573.00 730,258.41 171,136.37 29,443.29 0.00 559,122.04 55 Commerce Bank Police Vehicles 2008 2008 406 6/1 12/1 - - 963,508.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 57 Lanier Copier 830 N Michigan 2008 2013 620 Monthly - - - 5,154.00 0.00 0.00 0.00 0.00 0.00 58 Lanier Copier 915 Olive 2008 2013 620 Monthly - - - 5,154.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 57 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 0.00 71 Ka sea State Bank Clerk Lanier Doe Copier 2010 2014 101 1/23 4123 7/23 10/23 9,209.00 638.84 638.84 10.63 0.00 0.00 n Kansas State Bank Cade 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 7a 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 74 CSI Leasinq Inc IT Netaop San 2010 2014 404 4/1 7/1 10/1 12/31 207,521.37 14236.41 14236.41 210.59 0.00 0.00 7s Kansas State Bank Central Services Cooler 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 n GE Capital Information TechndogY Animal Conlyd Copier 2010 2015 101 2/28 5/30 8/30 11/30 3,550.69 1,161.97 758.35 57.05 0.00 403.62 7a Kansas State Bank Mayor Oce Cooler 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 79 Advanced Imacinq 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 a7 Public Finance.com Inc Solid Waste Contalners/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 89 Sun Trust Pdice, Parks. Bldq vehicles 2011 2016 404/201/600 3/15 6/15 9/15 12/15 2.068,202.00 1,059,040.84 417,495.38 17,470.02 0.00 641,545.46 9p Capital One Public Funding Sdid Waste Contalners/Trucks 2011 2016 6 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 91 GE Capital Information Tachndony 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 9z Key Finance IT Phone Svstem 2011 2016 404 1/15 1,444,995.97 843,595.57 274,272.26 21,127.15 0.00 569,323.31 94 Ikon Office Solutions Mayor Ricoh MP 2851 SP Copier 2011 2016 101 2/15 5/15 8/15 11/15 2,569.53 1,620.15 509.86 78.62 0.00 1,110.29 95 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 97 Sun Tru Equipment Finance Police Vehicles & Equipment 2012 2017 406 5/15 11/15 - - 1295,000.00 918,678.73 256,966.38 14,484.90 0.00 661,712.35 9a PNC Equipment Finance Public Works Vehicles Lease 2012 2017 2021641/640 5/15 11/15 - - 945,674.38 669,405.77 187,687.81 9,371.03 0.00 481,717.96 too PNC Eouipmenl Finance Public Works Vehicles Lease 2012 2017 2021641/600/288 1/15 7/15 - - 2.806,054.00 2257,055.55 553,306.66 27,644.68 0.00 1.703,748.89 oz Ikon Office Solutions /Ricoh Wastewater Copier 2012 2017 641 Monthly 1st 5,744.95 4,278.32 1,108.21 214.70 0.00 3,170.11 103 GE Capital Information Tachndony Fire Department Copier 2012 2017 101 2/28 5/28 8/28 11/28 5,471.01 4,249.41 1,043.56 227.24 0.00 3,205.85 ,as Ricoh USA Central Services Copley 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 107 Ricoh USA StreeVSewer Dept Copier 2013 2018 202/641 3/4 6/4 9/4 1214 5,559.15 4,506.34 1,030.99 239.81 0.00 3,475.35 pa Ricoh USA City Attorney Cooler 2013 2018 101 2/12 5/12 8/12 11/12 5,559.15 4,528.32 1,035.69 235.10 0.00 3. 92.63 109 Ricoh USA Parks & Rec Ricoh Cocieri 2013 2018 201 2/21 5/21 8/21 11/21 16,129.94 13,138.49 3,005.58 681.65 0.00 10,132.91 to PNC Equipment Finance Vehicle/Equipment Lease 2013 2018 101/202/406/641 1/15 7/15 - 1,689,669.59 1,689,669.59 327,718.32 22,182.20 0.00 1,361,951.27 111 Ricoh USA Engineernq Plotter /Scanner 2013 2018 101 3/3 6/3 9/3 1213 10.667.67 8,694.31 1,904.10 687.90 0.00 6,790.21 12 Ricoh USA Building Dept. Copier 2013 2018 600 Monthly 4,093.64 3,854.47 744.54 194.46 0.00 3,109.93 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.60 .67 14 Ricoh USA Armin & Finance Copier 2013 2018 101 1/16 4/16 7/16 10/16 11,247.97 9,620.91 2,055.86 515.39 0.00 7,565.05 115 CSI Leasin[I Inc 2010 Server IT Lease 2010 2014 404 2/1 5/1 8/1 11/1 28,588.00 5,889.74 5.869.79 189.81 0.00 (0.051 n 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 118 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 to Water Works Colfax Ricoh Copier Water Works Cdfax Ricoh Copie 2013 2018 620 Monthly 16th 4,732.65 4,732.65 844.81 240.71 0.00 3,887.84 120 Water Works Olive Ricoh Copier Water Works Olive Ricoh Copier 2013 2018 620 Monthly 101h 4,732.65 4,732.65 844.81 240.71 0.00 3,887.84 123 Police Training Dept. Ricoh Copier Tmininq Copier 2014 2019 101 Monthly 30th 4,263.00 0.00 548.61 169.48 4,263.00 3,714.39 124 Kev Government Finance 2014 City Vehicles 2014 2019 4/1 10/1 1.959,485.95 0.00 0.00 0.00 1.959. 5.95 1.959,485.95 125 HP Computer Lease Computer Equipment Lease 2014 2018 various Monthly 8th 137,104.95 0.00 12,550.93 1,959.22 137,104.95 124,554.02 126 HP Computer Lease #2 Computer Eouipmenl Lease 2014 2018 201 and 620 Mpnlhly 8th 4,000.00 0.00 280.05 80.11 4,000.00 3,719.95 127 HP Computer Lease #4 Computer Equipment Lease 2014 2018 404 Monthly 8th 5,886.15 0.00 424.74 73.94 5,886.15 5,461.41 128 HP Computer Lease #6 Computer Eouipmenl Lease 2014 2018 201 Monthly 8th 3,755.50 0.00 194.40 44.88 3,755.50 3,561.10 129 HP Computer Lease #7 Computer Equipment Lease 2014 2018 620 Monthly 8th 1,326.00 0.00 23.87 4.20 1,326.00 1,302.13 130 So id Waste Copier Ricoh USA Copier 2014 2019 611 ManthY 17th 5,351.65 0.00 77.47 25.00 5,351.65 5,274.18 131 Police Communications Copier Ricoh USA Copier 2014 2019 101 Monthly 129h 8,843.00 0.00 646.17 200.46 8,843.00 8,196.83 132 Organic Resources & Wastewater Ricoh USA Copiers 2014 2019 641 Monthly 21st 12,260.18 0.00 1,077.57 330.93 12,260.18 11,182.61 City of South Bend Period Ending: December 31, 2014 Monthly Debt Schedule Year o/ Year of Year of Scheduled Payments Debt (Oriq /Re /i1 Driblet YTD Principal YTD Interest YTD Debt at Debt Instrument Debt Purpose Issue Refundinq Maturity Fund 1st 2nd 3rd dth Issue 1113112013 Payments Payments Additions 1213112014 Redevelopment Commission Debt Bond Debt s Central Business TIF 1990 1996 2012 420 2/1 8/1 - - 3,790,000.00 0.00 0.00 0.00 0.00 0.00 fo Blackthorn Goff Cours e Blackthorn Golf 1992 1998 2013 619 311 9/1 - - 6,135,000.00 0.00 0.00 0.00 0.00 0.00 7 Cenlury Center Lease Rental Revenue Century Center 1994 200112011 2018 407 2/1 8/1 - - 6,825,000.00 2,070,000.00 440,000.00 46,350.00 0.00 1,630,000.00 8 College Football Hall of Fame Hall of Fame 1994 200012011 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 11 South Bend Buildinq Corporation Morris PAC mTJX 1998 2009 2017 408 2/1 8/1 - - 13,300,000.00 3,380,000.00 920,000.00 120,262.50 0.00 2,460,000.00 tz Special Taxing District 2002 2014 2022 324/4041414 1/1 7/1 - - 6,620,000.00 3,405,000.00 430,000.00 54,860.00 35,000.00 3,010,000.00 Downtown Central Area TIF s own 2003 2011 2024 420 2/1 8/1 - - 19,795,000.00 16,120,000.00 1,155,000.00 759,297.00 0.00 14,965,000.00 s 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 zz Erskine Village TIF Development Bond Erskine Villane 2005 2027 432 2/1 8/1 - - 5,485,000.00 4,465,000.00 210,000.00 281,495.00 0.00 4,255,000.00 54 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 of 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 9s SB Economic Develop Revenue Bonds Career Academy 2011 2014 324 2115 5/15 8/15 11/15 1,500,000.00 500,000.00 500,000.00 12,500.00 0.00 0.00 _ 2012 Gates 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 121 Blackthorn Goff Cart Lease Blackthorn Gulf 2014 2019 619 Monthly 14th 293,788.00 0.00 36,549.96 5,248.60 293,788.00 257,238.04 1zz Synagogue at Coveleski Improvements Covelaski Stadium 2014 2018 377 1/31 500,000.00 0.00 100,000.00 0.00 500,000.00 400,000.00 Total Bond Debt 140,213,788.00 83,123,333.34 7,783,216.62 3,905,381.35 828,788.00 76,168,904.72 Loans Payable 3 Intliana Development Finance Authority Bosch Property (Nonforgivel 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 a Indiana Development Finance Authority Bosch Property (Forgive) 2001 2021 210 - - - - 2fi0,000.00 133,214.96 16,084.70 3,816.62 0.00 117,130.26 z 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 14 Indiana Development Finance Authority Frederickson Park 2003 2012 404 3/31 6/30 9/30 12/31 764,809.60 0.00 0.00 0.00 0.00 0.00 fs Indiana Development Finance Authority Frederickson Park (Forgive) 2003 2012 404 - - - - 191,202.40 0.00 0.00 0.00 0.00 0.00 is Indiana Development Finance AuthariN Anchor 2005 2014 404 6/30 12/31 - - 600,000.00 66.666.72 66.666.72 1,250.00 0.00 0.00 11 Intliana 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 so HUD Section 108#8 Studebaker Oliver 2008 2025 434 2/1 8/1 - - 4,000,000.00 1,005,000.00 825,000.00 41,949.00 0.00 180,000.00 63 City of Mishawaka Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1,102,549.56 343,532.46 296,529.37 16,046.63 0.00 47,003.09 64 Interfund Fund 412 -Maior Moves Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1,040,319.00 923,829.00 37,152.00 45,733.00 0.00 886,677.00 83 Intertund Fund 619 - Blackthorn Blackthorn Equip (goff 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 a4 Inlerfund Fund 412 -Major Moves Triangle Development 2011 2029 436 2/15 8/15 - - 2,000,000.00 1,558,050.00 44,790.50 15,580.50 0.00 1,513,259.50 as Intedund Fund 412 -Maior 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 as Interfund Fund 209 to Airport 324 Prairie Ave Brownfeld Proled 2011 2020 324 8/9 - - - 500,000.00 500,000.00 0.00 0.00 0.00 500,000.00 as Blackthorn Loan from Airport 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 Total Loans Payable 0 22,058,511.06 8,506,351.78 1,569,116.13 307,423.40 0.00 6,937,235.65 Capital Leese 75 PNC Equipment Financinq Blackthom Golf Carts 2010 2015 619 Monthiv 246,509.64 106,802.80 106,802.80 4,333.24 0.00 0.00 Total Capital Lease 1111009 246,509.64 106,802.80 106,802.80 4,333.24 0.00 0.00 Leases 37 Tranew Lease Leghton 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 13 Transpo Lease Man /Coffax 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 Tota /Lease 5,510,278.00 2,160,211.00 292,321.00 107,679.00 0.00 1,867,890.00 Total Redevelopment Commission 168.029,086.70 93.896,698.92 9.751.56.55 4324,816.99 828,788.00 84.974,030.37 Total Debt 450,125,344.82 257,332,552.06 22,450,243.72 9,582,623.94 2,971,064.38 237,853,372.72 Terminated City of South Bend Staffing Headcount Summary Budget Full Time I Jan I Feb I Mar I Apr I May Jun Jul Aug Sep Oct I Nov Dec Full Time Staff 1160.00 1116.00 1104.00 1106.00 1109.00 1107.00 1101.00 1108.00 1107.00 1095.00 1100.00 1101.00 1098.00 Part Time Staff 75.00 75.00 72.00 71.00 73.00 73.00 66.00 69.00 64.00 64.00 66.00 67.00 Temporary /Seasonal 137.00 137.00 120.00 144.00 213.00 361.00 341.00 344.00 239.00 222.00 207.00 143.00 City Total 1328.00 1316.00 1298.00 1324.00 1393.00 1535.00 1515.00 1520.00 1398.00 1386.00 1374.00 1308.00 Financial Report December 2014 - Headcount Staffing Page 22 of 25 City of South Bend Staffing Headcount Full Time Staff Amended Budget FT I Jan I Feb I Mar I Apr I Mav I Jun Jul Aua I Sea I Oct I Nov I Dec General Government 12.00 11.00 11.00 11.00 11.00 11.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 Maintenance 44.00 Mayor 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 8.00 8.00 7.00 7.00 7.00 8.00 311 Call Center 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 26.00 Admin & Finance 23.00 21.00 21.00 21.00 22.00 22.00 22.00 22.00 21.00 20.00 20.00 21.00 21.00 3.00 Safety & Risk 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 1.00 Clerk 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 1.00 Common Council 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 93.00 L al De artment 10.00 9.00 9.00 9.00 10.00 9.00 8.00 9.00 10.00 9.00 10.00 9.00 10.00 Sub Total 64.00 61.00 61.00 61.00 63.00 62.00 61.00 62.00 63.00 61.00 61.00 61.00 62.00 Code Enfor. /Animal Control Water Utilit O s 26.00 24.00 21.00 21.00 23.00 22.00 22.00 23.00 24.00 23.00 23.00 23.00 23.00 Dept. of Community Investment Sub Total 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 25.00 24.00 25.00 26.00 25.00 Parks & Recreation Public Safety Administration 12.00 11.00 11.00 11.00 11.00 11.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 Maintenance 44.00 44.00 44.00 44.00 44.00 44.00 44.00 44.00 44.00 43.00 44.00 44.00 44.00 Golf Operations 8.00 8.00 8.00 8.00 9.00 9.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 Recreation Ops 26.00 26.00 26.00 27.00 26.00 26.00 26.00 25.00 26.00 24.00 24.00 22.00 22.00 Zoological Ops 23.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 2.00 2.00 2.00 1.00 Graffiti Removal 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Recreation Nonreverting 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Sub Total 115.00 94.00 94.00 95.00 95.00 95.00 93.00 92.00 93.00 89.00 90.00 88.00 87.00 Police 297.00 289.00 283.00 285.00 283.00 283.00 284.00 292.00 291.00 289.00 289.00 295.00 295.00 Communications 38.00 32.00 33.00 34.00 34.00 34.00 33.00 33.00 32.00 31.00 34.00 34.00 34.00 Fire 260.00 263.00 260.00 261.00 258.00 258.00 257.00 257.00 256.00 257.00 257.00 257.00 257.00 Sub Total 595.00 584.00 576.00 580.00 575.00 575.00 574.00 582.00 579.00 577.00 580.00 586.00 586.00 Public Works Central Services 40.00 37.00 37.00 37.00 38.00 37.00 37.00 37.00 39.00 39.00 38.00 37.00 35.00 Engineering 16.00 14.00 14.00 16.00 16.00 16.00 16.00 16.00 16.00 15.00 14.00 14.00 14.00 Maintenance 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 Solid Waste Operations 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 24.00 22.00 23.00 22.00 22.00 Street Operations 60.00 60.00 60.00 59.00 60.00 60.00 60.00 60.00 60.00 60.00 60.00 59.00 59.00 Sewer Operations 35.00 35.00 35.00 32.00 33.00 33.00 33.00 31.00 30.00 31.00 33.00 33.00 33.00 Waste Water Ops 44.00 44.00 44.00 44.00 44.00 44.00 44.00 44.00 44.00 44.00 44.00 42.00 42.00 Organic Resources 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 5.00 6.00 6.00 Water Utilit O s 70.00 69.00 69.00 68.00 69.00 70.00 68.00 68.00 68.00 68.00 68.00 68.00 68.00 Sub Total 299.00 293.00 293.00 290.00 294.00 294.00 292.00 290.00 290.00 288.00 288.00 284.00 282.00 Building Department 15.00 14.00 13.00 13.00 13.00 13.00 14.00 14.00 14.00 14.00 13.00 13.00 13.00 Human Rights 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 Morris & Palais 14.00 14.00 14.00 14.00 14.00 14.00 13.00 13.00 13.00 13.00 14.00 14.00 14.00 City Total 1160.00 1116.00 1104.00 1106.00 1109.00 1107.00 1101.00 1108.00 1107.00 1095.00 1100.00 1101.00 1098.00 Financial Report December 2014 - Headcount Staffing Page 23 of 25 City of South Bend Staffing Headcount Part Time Staff Dept. of Community Investment 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Parks & Recreation Public Safety Administration Jan I Feb I Mar I Apr I May I Jun Jul Aug I Sep Oct I Nov I Dec General Government 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 Mayor 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 311 Call Center 0.00 0.00 0.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Admin & Finance 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 Clerk 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Common Council 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Le al De artment 4.00 4.00 4.00 4.00 3.00 3.00 2.00 2.00 2.00 2.00 2.00 2.00 Sub Total 6.00 6.00 6.00 7.00 6.00 6.00 4.00 4.00 4.00 4.00 4.00 4.00 Code Ent. /Animal Control 2.00 2.00 2.00 2.00 2.00 2.00 2.00 3.00 3.00 2.00 2.00 2.00 Dept. of Community Investment 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Parks & Recreation Public Safety Administration 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 Maintenance 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 Golf Operations 0.00 0.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 Recreation Ops 30.00 30.00 28.00 26.00 26.00 26.00 25.00 25.00 23.00 25.00 27.00 28.00 Zoological Ops 6.00 6.00 3.00 3.00 3.00 3.00 3.00 2.00 0.00 0.00 0.00 0.00 Graffiti Removal 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 44.00 44.00 40.00 38.00 38.00 38.00 37.00 36.00 32.00 34.00 36.00 36.00 Police 4.00 4.00 5.00 5.00 5.00 5.00 3.00 4.00 5.00 6.00 6.00 6.00 Communications 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fire 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Sub Total 5.00 5.00 6.00 6.00 6.00 6.00 4.00 5.00 6.00 7.00 7.00 7.00 Public Works Central Services 1.00 1.00 1.00 2.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Engineering 4.00 4.00 2.00 2.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 Traffic & Lighting 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Solid Waste Ops 2.00 2.00 2.00 2.00 2.00 2.00 1.00 1.00 1.00 1.00 1.00 0.00 Street Ops 3.00 3.00 5.00 4.00 4.00 5.00 4.00 6.00 4.00 2.00 2.00 4.00 Sewer Ops 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Waste Water Ops 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water Utilit O s 1.00 1.00 1.00 1.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 Sub Total 11.00 11.00 11.00 11.00 13.00 14.00 12.00 14.00 12.00 10.00 10.00 11.00 Building Department 0.00 0.00 0.00 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Human Rights 1.00 1.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 Morris & Palais 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 City Total 75.00 72.00 71.00 73.00 73.00 66.00 69.00 64.00 64.00 66.00 67.00 Financial Report December 2014 - Headcount Staffing Page 24 of 25 City of South Bend Staffing Headcount Temporary, Seasonal, and Intern Staff Jan I Feb I Mar I Apr I May I Jun I Jul I Aug Sep I Oct I Nov I Dec General Government 5.00 5.00 5.00 5.00 5.00 7.00 7.00 6.00 6.00 6.00 6.00 5.00 Maintenance 17.00 Mayor 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 Admin & Finance 0.00 1.00 1.00 1.00 5.00 6.00 6.00 8.00 9.00 9.00 8.00 8.00 35.00 Clerk 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Common Council 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 277.00 Mal0.00 Sub Total 0.00 1.00 1.00 1.00 5.00 6.00 6.00 8.00 9.00 9.00 8.00 8.00 Code Enforcement Sewer Ops 1.00 0.00 1.00 1.00 1.00 1.00 1.00 3.00 3.00 2.00 2.00 2.00 Dept, of Community Investment Leaf Pickup 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Parks & Recreation Public Safety Administration 5.00 5.00 5.00 5.00 5.00 7.00 7.00 6.00 6.00 6.00 6.00 5.00 Maintenance 17.00 17.00 9.00 19.00 47.00 52.00 51.00 42.00 33.00 31.00 25.00 16.00 Golf Operations 1.00 1.00 24.00 40.00 48.00 53.00 54.00 53.00 54.00 52.00 51.00 5.00 Recreation Ops 51.00 51.00 35.00 27.00 34.00 164.00 170.00 166.00 78.00 50.00 52.00 50.00 Zoological Ops 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Graffiti Removal 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Sub Total 75.00 75.00 74.00 92.00 135.00 277.00 283.00 268.00 172.00 140.00 135.00 77.00 Police 41.00 41.00 27.00 25.00 32.00 37.00 10.00 36.00 27.00 27.00 27.00 30.00 Communications 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fire 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 41.00 41.00 27.00 25.00 32.00 37.00 10.00 36.00 27.00 27.00 27.00 30.00 Public Works Central Services 0.00 0.00 0.00 0.00 0.00 1.00 1.00 1.00 3.00 2.00 2.00 2.00 Engineering 1.00 1.00 1.00 1.00 7.00 6.00 6.00 3.00 3.00 3.00 3.00 1.00 Traffic & Lighting 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Solid Waste Ops 8.00 8.00 5.00 10.00 12.00 12.00 13.00 10.00 9.00 10.00 10.00 10.00 Street Ops 2.00 2.00 2.00 10.00 7.00 8.00 8.00 5.00 6.00 7.00 1.00 1.00 Sewer Ops 5.00 5.00 5.00 0.00 8.00 8.00 8.00 5.00 5.00 4.00 4.00 2.00 Leaf Pickup 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 16.00 13.00 8.00 Waste Water Ops 0.00 0.00 0.00 0.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 Organic Resources 1.00 1.00 1.00 1.00 1.00 0.00 0.00 1.00 1.00 1.00 1.00 1.00 Water Utilit O s 3.00 3.00 3.00 3.00 4.00 4.00 4.00 3.00 1.00 1.00 1.00 1.00 Sub Total 20.00 20.00 17.00 25.00 40.00 40.00 41.00 29.00 28.00 44.00 35.00 26.00 Building Department 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Human Rights 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Morris & Palais 0.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 137.00 137.00 120.00 144.00 213.00 361.00 341.00 344.00 239.00 222.00 207.00 143.00 Financial Report December 2014 - Headcount Staffing Page 25 of 25