Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
12-31-2016 Debt Schedule Summary
City of South Bend, Indiana Debt Schedule Summary Decemeber 31, 2016 12/31/15 12/31/16 12/31/15 Principal 2016 2016 Principal Current Noncurrent Name CAFR Balance Principal Additions Balance Principle Principle Business-Type Activities - By Fund EMS - Fund 287/288 6,101,714 6,101,714 378,082 107,464 5,831,096 401,729 5,429,366 Buildng Department Fund 600 118,849 118,849 31,421 139,941 227,369 54,621 172,747 Solid Waste - Fund 610/611 2,048,564 2,048,564 850,494 1,753,362 2,951,432 1,033,476 1,917,957 Water Works - Fund 620/625 18,767,045 18,767,045 4,834,782 4,276,915 18,209,178 1,606,846 16,602,332 Wastewater - Fund 640/641/649 89,557,255 89,557,255 7,522,453 878,127 82,912,929 7,664,021 75,248,908 Rounding 0 0 0 0 (1)0 (1) Total 116,593,427 116,593,427 13,617,232 7,155,808 110,132,002 10,760,693 99,371,309 Business-Type Activities - By Type Capital Leases 4,411,042 4,411,042 1,681,727 3,855,808 6,585,123 2,071,584 4,513,539 Loans Payable 3,458,899 3,458,899 876,694 0 2,582,205 183,384 2,398,821 Mortgage Bonds 5,851,565 5,851,565 294,700 0 5,556,865 295,725 5,261,140 Revenue Bonds 102,871,921 102,871,921 10,764,112 3,300,000 95,407,809 8,210,000 87,197,809 Total 116,593,427 116,593,427 13,617,232 7,155,808 110,132,002 10,760,693 99,371,309 Governmental Activities Capital Leases 8,491,407 8,491,407 2,605,323 5,042,991 10,929,075 2,858,050 8,071,025 Loans Payable 4,831,752 4,831,752 184,371 0 4,647,381 210,266 4,437,115 Mortgage Bonds 13,904,973 13,904,973 1,813,423 0 12,091,550 1,744,275 10,347,275 Revenue Bonds 107,815,890 107,815,890 8,775,758 0 99,040,132 11,962,653 87,077,479 Total 135,044,022 135,044,022 13,378,875 5,042,991 126,708,138 16,775,244 109,932,894 Grand Total 251,637,448 251,637,448 26,996,107 12,198,799 236,840,139 27,535,937 209,304,203 2016 Additions 2016 Central Services Copier #147 32,525.00 2016 Central Services Copier #148 11,413.00 2016 Public.Finance.com Vehicle/Equipment Lease #149 3,339,830.00 2016 HP Computer Lease #150 17,439.85 2016 Administration/Finance Copier #151 10,923.63 2016 PNC Bank Vehicle/Equipment Lease #152 3,992,548.72 2016 PNC Park Vehicle Lease Amendment #153 78,808.00 2016 PNC Bank Vehicle/Equipment Lease #154 1,256,096.99 2016 HP Computer Lease #155 156,029.30 2016 Waterworks Bond Refunding #156 3,300,000.00 2016 Parks Forestry Copier #157 3,184.06 Total New Debt 12,198,798.55 Debt Schedule Summary 2/17/2017 Page 1 City of South Bend, Indiana Debt Schedule Summary - By Type December 31, 2016 Amort.12/31/15 12/31/16 Fund Schedule CAFR Type Principal 2016 2016 2016 Principal Current Noncurrent Name Number Number Activity of Debt Balance Principal Additions Interest Balance Principal Additions 2011 Bldg Dept Vehicles & Equipment Lease (Sun Trust) (2%)600 89 Business-Type Capital Lease 4,318.30 4,318.30 0.00 31.35 0.00 0.00 0.00 2011 Solid Waste - One Packer and Containers (Sun Trust)611 90 Business-Type Capital Lease 32,195.78 32,195.78 0.00 268.39 0.00 0.00 0.00 2012 Public Works Vehicles Lease (PNC Equipment Finance) (14.51%)641 98 Business-Type Capital Lease 42,252.37 28,062.53 0.00 530.71 14,189.84 14,189.84 0.00 2012 Public Works Vehicles Lease (PNC Equipment Finance) (14.51%)640 98 Business-Type Capital Lease 42,252.37 28,062.53 0.00 530.71 14,189.84 14,189.84 0.00 2012 Public Works Vehicles Lease (PNC Equipment Finance) (17.52%)641 98 Business-Type Capital Lease 51,017.33 33,883.91 0.00 640.80 17,133.42 17,133.42 0.00 2012 PNC Vehicle Lease (65%)611 100 Business-Type Capital Lease 743,080.53 369,124.78 0.00 8,493.59 373,955.74 373,955.74 0.00 2012 PNC Vehicle Lease (12%)641 100 Business-Type Capital Lease 137,184.10 68,146.11 0.00 1,568.05 69,037.98 69,037.98 0.00 2012 PNC Vehicle Lease (11%)641 100 Business-Type Capital Lease 125,752.09 62,467.27 0.00 1,437.38 63,284.82 63,284.82 0.00 2012 PNC Vehicle Lease (1%)600 100 Business-Type Capital Lease 11,432.01 5,678.84 0.00 130.67 5,753.17 5,753.17 0.00 2012 PNC Vehicle Lease (7%)287/288 100 Business-Type Capital Lease 80,024.06 39,751.90 0.00 914.69 40,272.16 40,272.16 0.00 2012 Wastewater Ricoh/Ikon MPC4502 Copier 641 102 Business-Type Capital Lease 1,997.49 1,240.72 0.00 81.20 756.77 756.77 0.00 2012 Fire Dept Ricoh/Ikon MPC4502 Copier 287/288 103 Business-Type Capital Lease 2,099.54 1,172.86 0.00 97.94 926.68 926.68 0.00 2013 PNC Vehicle & Equipment Lease (Sewers, 13.78%)641 110 Business-Type Capital Lease 141,610.17 46,630.44 0.00 1,585.85 94,979.74 47,201.07 47,778.67 2013 Building Department Ricoh Copier 600 112 Business-Type Capital Lease 2,323.16 831.39 0.00 107.61 1,491.77 878.55 613.22 2013 Suntrust Vehicle Lease (Solid Waste, 53.15%)611 113 Business-Type Capital Lease 487,975.39 160,097.35 0.00 7,102.52 327,878.03 162,644.95 165,233.09 2013 Water Works Main Street Ricoh Copier 620 118 Business-Type Capital Lease 3,573.98 1,125.87 0.00 169.53 2,448.11 1,189.78 1,258.33 2013 Water Works Colfax Ricoh Copier 620 119 Business-Type Capital Lease 2,995.07 943.45 0.00 142.07 2,051.62 997.01 1,054.61 2013 Water Works Olive Street Ricoh Copier 620 120 Business-Type Capital Lease 2,995.07 943.45 0.00 142.07 2,051.62 997.01 1,054.61 2014 Police & Public Works Vehicles (Key Government Finance) (12%)641 124 Business-Type Capital Lease 189,551.67 46,296.03 0.00 2,759.56 143,255.65 47,016.45 96,239.19 2014 Police & Public Works Vehicles (Key Government Finance) (1%)600 124 Business-Type Capital Lease 15,795.97 3,858.00 0.00 229.96 11,937.97 3,918.04 8,019.93 2014 HP Computer Leases #1 (9.13%)641 125 Business-Type Capital Lease 8,648.40 2,848.51 0.00 330.95 5,799.89 2,979.39 2,820.50 2014 HP Computer Leases #1 (2.92%)600 125 Business-Type Capital Lease 2,765.97 911.02 0.00 105.85 1,854.95 952.88 902.06 2014 HP Computer Leases #1 (1.54%)620 125 Business-Type Capital Lease 1,458.77 480.47 0.00 55.82 978.29 502.55 475.75 2014 HP Computer Leases #1 (1.55%)620 125 Business-Type Capital Lease 1,468.24 483.59 0.00 56.19 984.65 505.81 478.84 2014 HP Computer Leases #1 (1.55%)620 125 Business-Type Capital Lease 1,468.24 483.59 0.00 56.19 984.65 505.81 478.84 2014 HP Computer Leases #1 (1.39%)611 125 Business-Type Capital Lease 1,316.68 433.67 0.00 50.39 883.01 453.60 429.41 2014 HP Computer Leases #2 (83.58%)620 126 Business-Type Capital Lease 2,385.93 758.46 0.00 94.46 1,627.48 794.34 833.14 2014 HP Computer Leases #7 620 129 Business-Type Capital Lease 1,009.77 303.72 0.00 33.12 706.05 315.44 390.61 2014 Solid Waste Copier - Ricoh MPC3503 Copier 611 130 Business-Type Capital Lease 4,315.81 1,013.49 0.00 216.15 3,302.32 1,071.78 2,230.54 2014 Wastewater Ricoh Copiers (2)641 132 Business-Type Capital Lease 5,956.65 1,584.55 0.00 293.45 4,372.10 1,675.63 2,696.47 2014 Organic Resources Ricoh Copier (1)641 132 Business-Type Capital Lease 2,978.33 792.27 0.00 146.73 2,186.06 837.82 1,348.24 2014 Water Works Copier - North Station (Ricoh)620 134 Business-Type Capital Lease 3,071.37 939.12 0.00 146.40 2,132.25 992.44 1,139.81 2015 HP Computer Lease #8 (5.88%) Solid Waste 611 136 Business-Type Capital Lease 950.78 253.76 0.00 42.16 697.02 266.86 430.16 2015 Animal Control Copier (Ricoh)600 137 Business-Type Capital Lease 4,566.75 974.87 0.00 240.97 3,591.88 1,033.37 2,558.51 2015 HP Computer Lease #9 - (1.66%) Wastewater 641 138 Business-Type Capital Lease 2,056.07 488.28 0.00 91.13 1,567.79 513.04 1,054.75 2015 HP Computer Lease #9 - (1.61%) Building Department 600 138 Business-Type Capital Lease 2,004.39 473.57 0.00 88.39 1,530.82 497.58 1,033.24 2015 HP Computer Lease #9 - (9.23%) Water Works 620 138 Business-Type Capital Lease 11,461.96 2,714.94 0.00 506.73 8,747.02 2,852.61 5,894.41 2015 Vehicle/Equip Lease (Banc of America) Wastewater - 14.86%641 140 Business-Type Capital Lease 508,995.65 98,288.23 0.00 7,613.84 410,707.42 100,561.11 310,146.31 2015 Vehicle/Equip Lease (Banc of America) Solid Waste - 17.35%611 140 Business-Type Capital Lease 594,284.97 114,757.80 0.00 8,889.64 479,527.17 117,411.53 362,115.64 2015 Vehicle/Equip Lease (Banc of America) Water Works - 1.27%620 140 Business-Type Capital Lease 43,500.97 8,400.14 0.00 650.71 35,100.84 8,594.39 26,506.45 2015 Vehicle/Equip Lease (Banc of America) Code Enforcement - 1.05%600 140 Business-Type Capital Lease 35,965.37 6,945.00 0.00 537.99 29,020.38 7,105.60 21,914.78 2015 Vehicle/Equip Lease (Banc of America) Sewer Department - .99%641 140 Business-Type Capital Lease 33,910.21 6,548.14 0.00 507.25 27,362.07 6,699.56 20,662.51 2015 Vehicle Lease No. 2 (PNC Equipment Finance) - Fire Departmnet - 46%287/288 144 Business-Type Capital Lease 579,922.00 112,889.92 0.00 8,788.93 467,032.08 114,807.09 352,224.99 2015 Vehicle Lease No. 2 (PNC Equipment Finance) - Code Enforcement - 3%600 144 Business-Type Capital Lease 39,677.00 7,362.39 0.00 573.19 32,314.61 7,487.42 24,827.19 2015 Vehicle Lease No. 2 (PNC Equipment Finance) - Solid Waste - 15%611 144 Business-Type Capital Lease 184,444.00 36,811.93 0.00 2,865.96 147,632.07 37,437.09 110,194.98 2015 Vehicle Lease No. 2 (PNC Equipment Finance) - Organic Resources - 16%641 144 Business-Type Capital Lease 212,032.00 39,266.05 0.00 3,057.01 172,765.95 39,932.90 132,833.05 2016 Vehicle/Equipment Lease (public-finance.com) - Organic Resources - 21%641 149 Business-Type Capital Lease 0.00 67,902.62 708,845.00 5,323.71 640,942.38 136,874.58 504,067.80 2016 Vehicle/Equipment Lease (public-finance.com) - Water Works - 29%620 149 Business-Type Capital Lease 0.00 93,770.29 960,000.00 7,351.78 866,229.71 189,017.28 677,212.43 2016 Vehicle/Equipment Lease (public-finance.com) - Solid Waste - 42%610 149 Business-Type Capital Lease 0.00 135,805.25 1,408,485.00 10,647.41 1,272,679.75 273,749.16 998,930.59 2016 HP Computer Lease #12 - Wastewater - 19.69%641 150 Business-Type Capital Lease 0.00 674.55 3,433.91 134.63 2,759.36 769.66 1,989.70 2016 HP Computer Lease #12 - Water Works - 19.69%620 150 Business-Type Capital Lease 0.00 674.55 3,433.91 134.63 2,759.36 769.66 1,989.70 2016 HP Computer Lease #12 - Solid Waste - 6.05% (IT budget to Fund 279 in 2017)279/404 150 Business-Type Capital Lease 0.00 207.26 1,055.10 41.37 847.84 236.49 611.35 2016 PNC Bank Vehicle/Equipment Lease No. 2 - Fire - 2.69%287 152 Business-Type Capital Lease 0.00 0.00 107,463.60 0.00 107,463.60 20,723.53 86,740.07 2016 PNC Bank Vehicle/Equipment Lease No. 2 - Wastewater - .17%641 152 Business-Type Capital Lease 0.00 0.00 6,797.42 0.00 6,797.42 1,309.67 5,487.75 2016 PNC Bank Vehicle/Equipment Lease No. 2 - Solid Waste - 8.63%610 152 Business-Type Capital Lease 0.00 0.00 344,877.00 0.00 344,877.00 66,484.80 278,392.20 2016 PNC Bank Vehicle/Equipment Lease No. 2 - Organic Resources - 3.75%641 152 Business-Type Capital Lease 0.00 0.00 149,892.00 0.00 149,892.00 28,889.69 121,002.31 2016 PNC Bank Vehicle/Equipment Lease No. 2 - Code Enforcement - 1.05%600 152 Business-Type Capital Lease 0.00 0.00 42,006.00 0.00 42,006.00 8,089.11 33,916.89 2016 PNC Bank Vehicle/Equipment Lease/Building Dept No. 2 - Building Department - 2.40%600 152 Business-Type Capital Lease 0.00 0.00 96,000.00 0.00 96,000.00 18,489.40 77,510.60 2016 HP Computer Lease No. 13 - Environmental Services - 5.87%641 155 Business-Type Capital Lease 0.00 320.89 9,158.92 72.22 8,838.03 1,970.40 6,867.63 2016 HP Computer Lease No. 13 - Building Department - 1.24%600 155 Business-Type Capital Lease 0.00 67.79 1,934.76 15.26 1,866.97 416.24 1,450.73 2016 HP Computer Lease No. 13 - Water Utility - 8.64%620 155 Business-Type Capital Lease 0.00 472.31 13,480.93 106.30 13,008.62 2,900.22 10,108.40 Offage (1.00)(208.00)(1,056.00)0.00 (849.00)(237.00)(612.00) Total 4,411,041.73 1,681,726.51 3,855,807.55 86,831.56 6,585,122.76 2,071,583.80 4,513,538.96 2000 Water Works Improvements - State Revolving Fund (Refunded 2016) (3)625 26 Business-Type Loan Payable 698,431.00 698,431.00 Refunded 10,127.00 0.00 0.00 0.00 2009 Water Works Improvements - State Revolving Fund 625 68 Business-Type Loan Payable 352,793.00 20,231.00 0.00 11,889.12 332,562.00 20,912.00 311,650.00 2009 Sewage Works Revenue Bonds - State Revolving Fund 649 70 Business-Type Loan Payable 2,407,675.00 158,032.00 0.00 67,656.00 2,249,643.00 162,472.00 2,087,171.00 Total 3,458,899.00 876,694.00 0.00 89,672.12 2,582,205.00 183,384.00 2,398,821.00 2001 Public Works Service Center (Building Corporation), Refunded 2010 (12.3%)641 36 Business-Type Mortgage Bonds 407,745.00 68,880.00 0.00 13,926.80 338,865.00 70,725.00 268,140.00 2013 Building Corporation EMS Fire Station/Tower Bonds 287288 116 Business-Type Mortgage Bonds 5,365,000.00 220,000.00 0.00 184,155.00 5,145,000.00 225,000.00 4,920,000.00 Unamortzed Premium 78,820.20 5,820.20 0.00 0.00 73,000.00 0.00 73,000.00 Total 5,851,565.20 294,700.20 0.00 198,081.80 5,556,865.00 295,725.00 5,261,140.00 2006 Water Works Improvements (Refunded 2016) (3)625 24 Business-Type Revenue Bonds 3,090,000.00 3,090,000.00 Refunded 68,900.00 0.00 0.00 0.00 2002/2012 Refunding Water Works Improvements 625 25 Business-Type Revenue Bonds 2,745,000.00 365,000.00 0.00 54,900.00 2,380,000.00 375,000.00 2,005,000.00 2009 Water Works Improvements, Series B 625 69 Business-Type Revenue Bonds 4,555,000.00 230,000.00 0.00 250,978.00 4,325,000.00 240,000.00 4,085,000.00 2010 Sewage Works Revenue Bonds 649 80 Business-Type Revenue Bonds 7,530,000.00 385,000.00 0.00 314,017.50 7,145,000.00 395,000.00 6,750,000.00 2011 Sewage Works Revenue Bonds 649 93 Business-Type Revenue Bonds 18,175,000.00 880,000.00 0.00 680,700.00 17,295,000.00 895,000.00 16,400,000.00 2012 Water Works Revenue Bond 625 99 Business-Type Revenue Bonds 7,275,000.00 350,000.00 0.00 216,786.26 6,925,000.00 355,000.00 6,570,000.00 Debt Schedule Summary 2/17/2017 Page 2 City of South Bend, Indiana Debt Schedule Summary - By Type December 31, 2016 Amort.12/31/15 12/31/16 Fund Schedule CAFR Type Principal 2016 2016 2016 Principal Current Noncurrent Name Number Number Activity of Debt Balance Principal Additions Interest Balance Principal Additions 2012 Sewage Works Revenue Bonds 649 101 Business-Type Revenue Bonds 21,935,000.00 1,045,000.00 0.00 507,580.00 20,890,000.00 1,060,000.00 19,830,000.00 2013A Sewage Works Revenue Bonds (PNC Bank) (2)649 105 Business-Type Revenue Bonds 9,970,000.00 1,920,000.00 0.00 193,418.00 8,050,000.00 1,955,000.00 6,095,000.00 2015 Sewage Works Refunding Bonds (Piper Jaffray/Huntington Public Capital) (2)649 145 Business-Type Revenue Bonds 27,440,000.00 2,475,000.00 0.00 538,128.89 24,965,000.00 2,530,000.00 22,435,000.00 2016 Waterworks Refunding Bonds (City Securities) Refund 2000 & 2006 Water Bonds (#24 & #26) (3)625 156 Business-Type Revenue Bonds 0.00 0.00 3,300,000.00 0.00 3,300,000.00 405,000.00 2,895,000.00 Unamortized Premium/Discount 156,920.64 24,111.64 0.00 0.00 132,809.00 0.00 132,809.00 Total 102,871,920.64 10,764,111.64 3,300,000.00 2,825,408.65 95,407,809.00 8,210,000.00 87,197,809.00 2011 Police Dept - Detective Bureau - Ricoh Copier/Printer (GE Capital)101 91 Governmental Capital Lease 437.96 437.96 0.00 7.40 0.00 0.00 0.00 2011 Mayor Ricoh MP2851 SP Copier - Ikon Office Solution 101 94 Governmental Capital Lease 570.81 571.81 1.00 17.67 0.00 0.00 0.00 2013 Legal Department Ricoh Copier 101 108 Governmental Capital Lease 2,395.32 1,162.59 0.00 108.21 1,232.73 1,231.73 1.00 2013 PNC Vehicle & Equipment Lease (Eng, 1.46%)101 110 Governmental Capital Lease 15,003.69 4,940.53 0.00 168.02 10,063.17 5,000.98 5,062.18 2013 Engineering Ricoh Plotter and Scanner 101 111 Governmental Capital Lease 4,716.87 2,257.61 0.00 334.39 2,459.26 2,458.26 1.00 2013 Administration & Finance Ricoh Copier (GE Capital Inf. Tech)101 114 Governmental Capital Lease 5,386.95 2,307.59 0.00 263.65 3,079.36 2,444.79 634.57 2013 Police Department Records Division Ricoh Copier 101 117 Governmental Capital Lease 6,123.92 1,929.78 0.00 290.22 4,194.14 2,039.23 2,154.91 2014 Police Department Training Ricoh Copier 101 123 Governmental Capital Lease 2,918.30 841.86 0.00 142.14 2,076.44 890.27 1,186.17 2014 Police & Public Works Vehicles (Key Government Finance) (1%)101 124 Governmental Capital Lease 15,795.97 3,858.00 0.00 229.96 11,937.97 3,918.04 8,019.93 2014 Police Communications Ricoh Copier 101 131 Governmental Capital Lease 6,583.31 1,706.32 0.00 325.50 4,876.99 1,804.44 3,072.55 2015 Vehicle/Equip Lease (Banc of America) Engineering - .25%101 140 Governmental Capital Lease 8,563.18 1,653.57 0.00 128.09 6,909.61 1,691.81 5,217.80 2015 Vehicle Lease No. 2 (PNC Equipment Finance) - Engieering - 2%101 144 Governmental Capital Lease 24,000.00 4,908.26 0.00 382.13 19,091.74 4,991.61 14,100.13 2016 Administration & Finance Ricoh MPC8002SP Copier 101 151 Governmental Capital Lease 0.00 1,985.36 10,923.63 519.88 8,938.27 2,047.09 6,891.18 2016 PNC Bank Vehicle/Equipment Lease No. 2 - Police - 17.15%101 152 Governmental Capital Lease 0.00 0.00 684,710.00 0.00 684,710.00 132,122.17 552,587.83 2016 PNC Bank Vehicle/Equipment Lease No. 2 - Engineering - .54%101 152 Governmental Capital Lease 0.00 0.00 21,712.00 0.00 21,712.00 4,160.11 17,551.89 2011 Parks Vehicles & Equipment Lease (Sun Trust) (46%)201 89 Governmental Capital Lease 99,320.97 99,320.97 0.00 721.07 0.00 0.00 0.00 2012 Parks Golf Cars Lease Financing (Sun Trust)201 95 Governmental Capital Lease 44,305.79 44,305.79 0.00 355.45 0.00 0.00 0.00 2013 Parks & Recreation Ricoh Copiers (three)201 109 Governmental Capital Lease 6,948.65 3,373.56 0.00 313.68 3,575.09 3,574.09 1.00 2014 HP Computer Leases #1 (7.32%)201 125 Governmental Capital Lease 6,933.88 2,283.80 0.00 265.34 4,650.07 2,388.73 2,261.34 2014 HP Computer Leases #2 (16.42%)201 126 Governmental Capital Lease 468.54 149.00 0.00 18.56 319.53 156.05 163.48 2014 HP Computer Leases #6 201 128 Governmental Capital Lease 2,759.48 841.49 0.00 115.63 1,917.99 883.34 1,034.65 2015 HP Computer Lease #8 (9.82%) Parks 201 136 Governmental Capital Lease 1,587.88 423.80 0.00 70.40 1,164.08 445.68 718.40 2015 HP Computer Lease #9 - (20.52%) Parks & Recreation 201 138 Governmental Capital Lease 25,474.76 6,035.84 0.00 1,126.55 19,438.92 6,341.89 13,097.03 2015 Vehicle/Equip Lease (Banc of America) Parks & Receation - 4.75%201 140 Governmental Capital Lease 162,700.50 31,417.84 0.00 2,433.76 131,282.65 32,144.37 99,138.29 2015 Ricoh Copier - Parks & Recreation Fund (Howard Park Senior Center)201 146 Governmental Capital Lease 4,219.84 765.12 0.00 221.52 3,454.72 810.05 2,644.67 2016 PNC Bank Vehicle/Equip Lease - Amendment No. 1 - Parks & Recreation - 100%201 153 Governmental Capital Lease 0.00 0.00 78,808.00 0.00 78,808.00 15,287.29 63,520.71 2016 PNC Bank Vehicle/Equip Lease No. 3 - Parks & Recreation - 80.5%201 154 Governmental Capital Lease 0.00 0.00 1,011,600.00 0.00 1,011,600.00 196,476.43 815,123.57 2016 HP Computer Lease No. 13 - Parks & Recreation - 11.67%201 155 Governmental Capital Lease 0.00 637.94 18,208.62 143.59 17,570.68 3,917.31 13,653.37 2016 Ricoh MPC2003 Copier (321 E. Walter Street, Forestry Office)201 157 Governmental Capital Lease 0.00 0.00 3,184.06 0.00 3,184.06 918.51 2,265.55 2012 Public Works Vehicles Lease (PNC Equipment Finance) (53.46%)202 98 Governmental Capital Lease 155,672.75 103,392.33 0.00 1,955.32 52,280.42 52,280.42 0.00 2013 Street/Sewer Department Ricoh Copier 202 107 Governmental Capital Lease 2,383.09 1,157.16 0.00 113.64 1,225.93 1,225.93 0.00 2013 PNC Vehicle & Equipment Lease (T&L, 20.37%)202 110 Governmental Capital Lease 209,332.31 68,930.48 0.00 2,344.26 140,401.83 69,774.00 70,627.83 2013 Suntrust Vehicle Lease (Street, 24.47%)202 113 Governmental Capital Lease 224,661.48 73,708.04 0.00 3,269.97 150,953.44 74,880.94 76,072.50 2014 Police & Public Works Vehicles (Key Government Finance) (30%)202 124 Governmental Capital Lease 473,879.18 115,740.07 0.00 6,898.90 358,139.12 117,541.13 240,597.99 2015 Vehicle/Equip Lease (Banc of America) Streets/T&L - 12.82%202 140 Governmental Capital Lease 439,120.07 84,795.10 0.00 6,568.60 354,324.97 86,755.95 267,569.02 2015 Vehicle Lease No. 2 (PNC Equipment Finance) - Street Department - 15%202 144 Governmental Capital Lease 184,310.00 36,811.93 0.00 2,865.96 147,498.07 37,437.09 110,060.98 2016 PNC Bank Vehicle/Equipment Lease No. 2 - Street Dept. - 30.79%202 152 Governmental Capital Lease 0.00 0.00 1,229,113.05 0.00 1,229,113.05 237,203.58 991,909.47 2013 Central Services Ricoh Copier 222 106 Governmental Capital Lease 1,586.46 770.64 0.00 69.12 815.82 814.82 1.00 2015 Vehicle/Equip Lease (Banc of America) Central Services - .31%222 140 Governmental Capital Lease 10,618.35 2,050.43 0.00 158.84 8,567.92 2,097.84 6,470.08 2015 Vehicle Lease No. 2 (PNC Equipment Finance) - Central Services - 1%222 144 Governmental Capital Lease 13,500.00 2,454.13 0.00 191.06 11,045.87 2,495.81 8,550.06 2016 Central Services - Print Shop - Lanier Pro C51005 Copier 222 147 Governmental Capital Lease 0.00 3,857.81 32,525.00 1,086.03 28,667.19 6,046.87 22,620.32 2016 Central Services - Print Shop - Lanier Pro C6502 Copier 222 148 Governmental Capital Lease 0.00 1,353.69 11,413.00 381.11 10,059.31 2,121.84 7,937.47 2016 PNC Bank Vehicle/Equip Lease No. 3 - IT/Innovation - 19.5%279 154 Governmental Capital Lease 0.00 0.00 244,496.99 0.00 244,496.99 47,593.67 196,903.32 2007 Chase Equipment Leasing (LED Equipment Lease)404 51 Governmental Capital Lease 380,582.65 186,262.63 0.00 14,317.03 194,320.02 194,319.97 0.05 2011 Information Technology - Telephone System $1,111,996 (Key Finance)404 92 Governmental Capital Lease 288,182.13 288,182.13 0.00 7,217.28 (0.00)0.00 (0.00) 2014 Police & Public Works Vehicles (Key Government Finance) (56%)404 124 Governmental Capital Lease 884,574.47 216,048.12 0.00 12,877.94 668,526.35 219,410.11 449,116.24 2015 Vehicle/Equip Lease (Banc of America) COIT - 46.35%404 140 Governmental Capital Lease 1,587,614.30 306,571.98 0.00 23,748.41 1,281,042.32 313,661.34 967,380.98 2015 Vehicle Lease No. 2 (PNC Equipment Finance) - Police Department - 2% 404 144 Governmental Capital Lease 29,298.00 4,908.26 0.00 382.13 24,389.74 4,991.61 19,398.13 2016 PNC Bank Vehicle/Equipment Lease No. 2 - Police/COIT - 32.83%404 152 Governmental Capital Lease 0.00 0.00 1,309,977.65 0.00 1,309,977.65 252,919.57 1,057,058.08 2016 HP Computer Lease No. 13 - IT/COIT - 72.58%404 155 Governmental Capital Lease 0.00 3,967.64 113,246.07 893.00 109,278.43 24,363.20 84,915.23 2013 PNC Vehicle & Equipment Lease (Police, 64.39%)406 110 Governmental Capital Lease 661,703.85 217,890.70 0.00 7,410.25 443,813.16 220,557.08 223,256.07 2012 PNC Vehicle Lease (4%)655 100 Governmental Capital Lease 45,728.03 22,715.37 0.00 522.68 23,012.66 23,012.66 0.00 2013 Suntrust Vehicle Lease (Releaf, 15.57%)655 113 Governmental Capital Lease 142,949.70 46,899.64 0.00 2,080.65 96,050.07 47,645.94 48,404.12 2014 HP Computer Leases #1 (74.60%) (IT buget to Fund 279 in 2017)279/404 125 Governmental Capital Lease 70,664.92 23,274.81 0.00 2,704.16 47,390.11 24,344.20 23,045.90 2014 HP Computer Leases #4 (IT budget to Fund 279 in 2017)279/404 127 Governmental Capital Lease 4,154.42 1,359.12 0.00 136.92 2,795.30 1,412.70 1,382.60 2015 HP Computer Lease #8 (84.30%) SB Stat, Fire, Engineering (IT budget Fund 279)279/404 136 Governmental Capital Lease 13,631.17 3,638.13 0.00 604.31 9,993.04 3,825.98 6,167.06 2015 HP Computer Lease #9 - (66.98%) COIT (IT budget to Fund 279 in 2017)279/404 138 Governmental Capital Lease 83,127.83 19,701.76 0.00 3,677.21 63,426.07 20,700.77 42,725.30 2015 HP Computer Lease #11 - Fire & Adm Fin (100%) COIT (IT budget to Fund 279)279/404 143 Governmental Capital Lease 2,825.33 664.27 0.00 117.17 2,161.06 695.77 1,465.29 2016 HP Computer Lease #12 - Information Technology - COIT - 54.57% (IT budget to Fund 279 in 2017)279/404 150 Governmental Capital Lease 0.00 1,869.50 9,516.93 373.11 7,647.43 2,133.10 5,514.33 2016 HP Computer Lease #12 - Solid Waste - 6.05% (IT budget to Fund 279 in 2017)279/404 150 Business-Type Capital Lease 0.00 207.26 1,055.10 41.37 847.84 236.49 611.35 2006 Main/Colfax Garage - Transpo Lease (To Fund 324 in 2017)324/404 13 Governmental Capital Lease 1,558,918.00 123,580.00 0.00 76,420.00 1,435,338.00 129,838.00 1,305,500.00 2011 Police Vehicles & Equipment Lease (Sun Trust) (52%)406/404 89 Governmental Capital Lease 112,275.88 112,275.88 0.00 815.12 0.00 0.00 0.00 2012 Police Department Vehicles & Equipment Lease (Sun Trust)406/404 97 Governmental Capital Lease 400,372.65 265,787.43 0.00 5,663.85 134,585.22 134,585.22 0.00 2013 Suntrust Vehicle Lease (Police, 6.81%)406/404 113 Governmental Capital Lease 62,523.28 20,512.94 0.00 910.03 42,010.34 20,839.36 21,170.97 2016 Vehicle/Equipment Lease (public-finance.com) - Police/COIT - 8% (CCD 406 in 2017 budget)406/404 149 Governmental Capital Lease 0.00 25,867.67 262,500.00 2,028.08 236,632.33 52,142.70 184,489.63 Total 8,491,406.89 2,605,323.46 5,042,991.10 197,546.31 10,929,074.53 2,858,049.94 8,071,024.59 2001 Indiana Development Finance Authority (Bosch) - Nonforgivable 210 3 Governmental Loan Payable 363,854.70 61,785.55 0.00 10,224.89 302,069.15 63,660.08 238,409.07 2014 Coveleski Stadium Synagogue Installment Purchase Agreement 377 122 Governmental Loan Payable 300,000.00 100,000.00 0.00 0.00 200,000.00 100,000.00 100,000.00 2015 Century Center Energy QECB Conservation Bond (Bank of America)672 139 Governmental Loan Payable 4,167,897.00 22,585.00 0.00 213,546.84 4,145,312.00 46,606.00 4,098,706.00 Unamortized Premium/Discount 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total 4,831,751.70 184,370.55 0.00 223,771.73 4,647,381.15 210,266.08 4,437,115.07 2001 Public Works Service Center (Building Corporation), Refunded 2010 (87.7%) (To Fund 324 in 2017)324/404 36 Governmental Mortgage Bonds 2,907,255.00 491,120.00 0.00 99,299.20 2,416,135.00 504,275.00 1,911,860.00 2012 Fire Station/Police Department Renovations (Building Corporation) (to Fund 324)324/404 39 Governmental Mortgage Bonds 2,521,250.00 300,000.00 0.00 91,390.00 2,221,250.00 310,000.00 1,911,250.00 Debt Schedule Summary 2/17/2017 Page 3 City of South Bend, Indiana Debt Schedule Summary - By Type December 31, 2016 Amort.12/31/15 12/31/16 Fund Schedule CAFR Type Principal 2016 2016 2016 Principal Current Noncurrent Name Number Number Activity of Debt Balance Principal Additions Interest Balance Principal Additions 2012 Fire Station/Police Department Renovations (Building Corporation)324 39 Governmental Mortgage Bonds 7,563,750.00 900,000.00 0.00 274,170.00 6,663,750.00 930,000.00 5,733,750.00 Unamortized Premium 912,718.00 122,303.00 0.00 0.00 790,415.00 0.00 790,415.00 Total 13,904,973.00 1,813,423.00 0.00 464,859.20 12,091,550.00 1,744,275.00 10,347,275.00 2011 College Football Hall of Fame Construction (Refunded 2011)313 8 Governmental Revenue Bonds 3,010,000.00 1,180,000.00 0.00 88,015.00 1,830,000.00 1,215,000.00 615,000.00 2011 South Bend Downtown Central Development Area TIF (Refunded 2011)324 5 Governmental Revenue Bonds 13,760,000.00 1,260,000.00 0.00 655,958.00 12,500,000.00 1,315,000.00 11,185,000.00 2011 Airport Development Area TIF (Refunded 2011)324 6 Governmental Revenue Bonds 7,845,000.00 720,000.00 0.00 373,987.50 7,125,000.00 750,000.00 6,375,000.00 2002 TJX Special Taxing District (Refunded 2014)324 12 Governmental Revenue Bonds 2,615,000.00 405,000.00 0.00 78,450.00 2,210,000.00 415,000.00 1,795,000.00 2008 2013 Century Center Special Tax Bonds (Refunded 2013)324 62 Governmental Revenue Bonds 3,465,000.00 290,000.00 0.00 97,612.50 3,175,000.00 300,000.00 2,875,000.00 2015 Redevelopment Authority Smart Streets Bonds (Bank of America/Merrill)324 135 Governmental Revenue Bonds 25,000,000.00 0.00 0.00 0.00 25,000,000.00 460,000.00 24,540,000.00 2010 Coveleski Stadium Recovery Zone Economic Development Bonds 377 81 Governmental Revenue Bonds 2,295,000.00 630,000.00 0.00 107,251.25 1,665,000.00 650,000.00 1,015,000.00 2011 Century Center Lease Rental Revenue (Refunded 2011) (25%)404 7 Governmental Revenue Bonds 295,000.00 115,000.00 0.00 6,968.75 180,000.00 118,750.00 61,250.00 2011 Century Center Lease Rental Revenue (Refunded 2011) (75%)407 7 Governmental Revenue Bonds 885,000.00 345,000.00 0.00 20,906.25 540,000.00 356,250.00 183,750.00 2014 St. Joseph County PSAP (EDIT) Revenue Bonds - City Share 29.03%408 133 Governmental Revenue Bonds 2,386,507.92 0.00 0.00 0.00 2,386,507.92 107,652.90 2,278,855.02 2015 EDIT/Parks Bonds (Bank of America)408 141 Governmental Revenue Bonds 5,605,000.00 200,000.00 0.00 180,106.00 5,405,000.00 215,000.00 5,190,000.00 2005 Erskine Village TIF Developer Bond (payoff 2/1/17 - $3,961,666.72 paid)432 22 Governmental Revenue Bonds 4,035,000.00 235,000.00 0.00 254,502.50 3,800,000.00 3,800,000.00 0.00 2015/2008 Eddy Street Commons - Lease Rental Revenue Bonds & Refunding 436 54 Governmental Revenue Bonds 31,450,000.00 1,375,000.00 0.00 1,095,929.43 30,075,000.00 1,315,000.00 28,760,000.00 2006 County Economic Development Income Tax Bonds (To Fund 324 in 2017) (paid off 1/31/17)324/408 31 Governmental Revenue Bonds 1,265,000.00 835,000.00 0.00 49,030.00 430,000.00 430,000.00 0.00 2009 Morris Performing Arts Center (Building Corporation) (Refunded 2009) (Final payment made 1/28/17)408/324 11 Governmental Revenue Bonds 1,510,000.00 995,000.00 0.00 50,600.00 515,000.00 515,000.00 0.00 Unamortized Premium 2,394,382.00 190,758.00 0.00 0.00 2,203,624.00 0.00 2,203,624.00 Total 107,815,889.92 8,775,758.00 0.00 3,059,317.18 99,040,131.92 11,962,652.90 87,077,479.02 Debt Schedule Summary 2/17/2017 Page 4 City of South Bend, Indiana Debt Schedule Summary - Business Activities by Fund December 31, 2016 Amort.12/31/15 12/31/16 Fund Schedule CAFR Type Principal 2016 2016 2016 Principal Current Noncurrent Name Number Number Activity of Debt Balance Principal Additions Interest Balance Principal Additions 2012 PNC Vehicle Lease (1%)600 100 Business-Type Capital Lease 11,432.01 5,678.84 0.00 130.67 5,753.17 5,753.17 0.00 2011 Bldg Dept Vehicles & Equipment Lease (Sun Trust) (2%)600 89 Business-Type Capital Lease 4,318.30 4,318.30 0.00 31.35 0.00 0.00 0.00 2013 Building Department Ricoh Copier 600 112 Business-Type Capital Lease 2,323.16 831.39 0.00 107.61 1,491.77 878.55 613.22 2014 Police & Public Works Vehicles (Key Government Finance) (1%)600 124 Business-Type Capital Lease 15,795.97 3,858.00 0.00 229.96 11,937.97 3,918.04 8,019.93 2014 HP Computer Leases #1 (2.92%)600 125 Business-Type Capital Lease 2,765.97 911.02 0.00 105.85 1,854.95 952.88 902.06 2015 Animal Control Copier (Ricoh)600 137 Business-Type Capital Lease 4,566.75 974.87 0.00 240.97 3,591.88 1,033.37 2,558.51 2015 HP Computer Lease #9 - (1.61%) Building Department 600 138 Business-Type Capital Lease 2,004.39 473.57 0.00 88.39 1,530.82 497.58 1,033.24 2015 Vehicle/Equip Lease (Banc of America) Code Enforcement - 1.05%600 140 Business-Type Capital Lease 35,965.37 6,945.00 0.00 537.99 29,020.38 7,105.60 21,914.78 2015 Vehicle Lease No. 2 (PNC Equipment Finance) - Code Enforcement - 3%600 144 Business-Type Capital Lease 39,677.00 7,362.39 0.00 573.19 32,314.61 7,487.42 24,827.19 2016 PNC Bank Vehicle/Equipment Lease No. 2 - Code Enforcement - 1.05%600 152 Business-Type Capital Lease 0.00 0.00 42,006.00 0.00 42,006.00 8,089.11 33,916.89 2016 PNC Bank Vehicle/Equipment Lease/Building Dept No. 2 - Building Department - 2.40%600 152 Business-Type Capital Lease 0.00 0.00 96,000.00 0.00 96,000.00 18,489.40 77,510.60 2016 HP Computer Lease No. 13 - Building Department - 1.24%600 155 Business-Type Capital Lease 0.00 67.79 1,934.76 15.26 1,866.97 416.24 1,450.73 Total 118,848.93 31,421.18 139,940.76 2,061.24 227,368.51 54,621.35 172,747.16 2016 Vehicle/Equipment Lease (public-finance.com) - Solid Waste - 42%610 149 Business-Type Capital Lease 0.00 135,805.25 1,408,485.00 10,647.41 1,272,679.75 273,749.16 998,930.59 2016 PNC Bank Vehicle/Equipment Lease No. 2 - Solid Waste - 8.63%610 152 Business-Type Capital Lease 0.00 0.00 344,877.00 0.00 344,877.00 66,484.80 278,392.20 2012 PNC Vehicle Lease (65%)611 100 Business-Type Capital Lease 743,080.53 369,124.78 0.00 8,493.59 373,955.74 373,955.74 0.00 2014 Solid Waste Copier - Ricoh MPC3503 Copier 611 130 Business-Type Capital Lease 4,315.81 1,013.49 0.00 216.15 3,302.32 1,071.78 2,230.54 2011 Solid Waste - One Packer and Containers (Sun Trust)611 90 Business-Type Capital Lease 32,195.78 32,195.78 0.00 268.39 0.00 0.00 0.00 2013 Suntrust Vehicle Lease (Solid Waste, 53.15%)611 113 Business-Type Capital Lease 487,975.39 160,097.35 0.00 7,102.52 327,878.03 162,644.95 165,233.09 2014 HP Computer Leases #1 (1.39%)611 125 Business-Type Capital Lease 1,316.68 433.67 0.00 50.39 883.01 453.60 429.41 2015 HP Computer Lease #8 (5.88%) Solid Waste 611 136 Business-Type Capital Lease 950.78 253.76 0.00 42.16 697.02 266.86 430.16 2015 Vehicle/Equip Lease (Banc of America) Solid Waste - 17.35%611 140 Business-Type Capital Lease 594,284.97 114,757.80 0.00 8,889.64 479,527.17 117,411.53 362,115.64 2015 Vehicle Lease No. 2 (PNC Equipment Finance) - Solid Waste - 15%611 144 Business-Type Capital Lease 184,444.00 36,811.93 0.00 2,865.96 147,632.07 37,437.09 110,194.98 Total 2,048,563.93 850,493.81 1,753,362.00 38,576.21 2,951,432.11 1,033,475.51 1,917,956.61 2014 HP Computer Leases #2 (83.58%)620 126 Business-Type Capital Lease 2,385.93 758.46 0.00 94.46 1,627.48 794.34 833.14 2014 HP Computer Leases #7 620 129 Business-Type Capital Lease 1,009.77 303.72 0.00 33.12 706.05 315.44 390.61 2014 Water Works Copier - North Station (Ricoh)620 134 Business-Type Capital Lease 3,071.37 939.12 0.00 146.40 2,132.25 992.44 1,139.81 2013 Water Works Main Street Ricoh Copier 620 118 Business-Type Capital Lease 3,573.98 1,125.87 0.00 169.53 2,448.11 1,189.78 1,258.33 2013 Water Works Colfax Ricoh Copier 620 119 Business-Type Capital Lease 2,995.07 943.45 0.00 142.07 2,051.62 997.01 1,054.61 2013 Water Works Olive Street Ricoh Copier 620 120 Business-Type Capital Lease 2,995.07 943.45 0.00 142.07 2,051.62 997.01 1,054.61 2014 HP Computer Leases #1 (1.54%)620 125 Business-Type Capital Lease 1,458.77 480.47 0.00 55.82 978.29 502.55 475.75 2014 HP Computer Leases #1 (1.55%)620 125 Business-Type Capital Lease 1,468.24 483.59 0.00 56.19 984.65 505.81 478.84 2014 HP Computer Leases #1 (1.55%)620 125 Business-Type Capital Lease 1,468.24 483.59 0.00 56.19 984.65 505.81 478.84 2015 HP Computer Lease #9 - (9.23%) Water Works 620 138 Business-Type Capital Lease 11,461.96 2,714.94 0.00 506.73 8,747.02 2,852.61 5,894.41 2015 Vehicle/Equip Lease (Banc of America) Water Works - 1.27%620 140 Business-Type Capital Lease 43,500.97 8,400.14 0.00 650.71 35,100.84 8,594.39 26,506.45 2016 Vehicle/Equipment Lease (public-finance.com) - Water Works - 29%620 149 Business-Type Capital Lease 0.00 93,770.29 960,000.00 7,351.78 866,229.71 189,017.28 677,212.43 2016 HP Computer Lease #12 - Water Works - 19.69%620 150 Business-Type Capital Lease 0.00 674.55 3,433.91 134.63 2,759.36 769.66 1,989.70 2016 HP Computer Lease No. 13 - Water Utility - 8.64%620 155 Business-Type Capital Lease 0.00 472.31 13,480.93 106.30 13,008.62 2,900.22 10,108.40 2000 Water Works Improvements - State Revolving Fund (Refunded 2016) (3)625 26 Business-Type Loan Payable 698,431.00 698,431.00 Refunded 10,127.00 0.00 0.00 0.00 2009 Water Works Improvements - State Revolving Fund 625 68 Business-Type Loan Payable 352,793.00 20,231.00 0.00 11,889.12 332,562.00 20,912.00 311,650.00 2006 Water Works Improvements (Refunded 2016) (3)625 24 Business-Type Revenue Bonds 3,090,000.00 3,090,000.00 Refunded 68,900.00 0.00 0.00 0.00 2002/2012 Refunding Water Works Improvements 625 25 Business-Type Revenue Bonds 2,745,000.00 365,000.00 0.00 54,900.00 2,380,000.00 375,000.00 2,005,000.00 2009 Water Works Improvements, Series B 625 69 Business-Type Revenue Bonds 4,555,000.00 230,000.00 0.00 250,978.00 4,325,000.00 240,000.00 4,085,000.00 2012 Water Works Revenue Bond 625 99 Business-Type Revenue Bonds 7,275,000.00 350,000.00 0.00 216,786.26 6,925,000.00 355,000.00 6,570,000.00 2016 Waterworks Refunding Bonds (City Securities) Refund 2000 & 2006 Water Bonds (#24 & #26)625 156 Business-Type Revenue Bonds 0.00 0.00 3,300,000.00 0.00 3,300,000.00 405,000.00 2,895,000.00 Unamortized Premium/(Discount)(24,568.00)(31,374.00)0.00 0.00 6,806.00 0.00 6,806.00 Total 18,767,045.37 4,834,781.95 4,276,914.84 623,226.38 18,209,178.26 1,606,846.34 16,602,331.91 2012 Public Works Vehicles Lease (PNC Equipment Finance) (14.51%)640 98 Business-Type Capital Lease 42,252.37 28,062.53 0.00 530.71 14,189.84 14,189.84 0.00 2012 Public Works Vehicles Lease (PNC Equipment Finance) (14.51%)641 98 Business-Type Capital Lease 42,252.37 28,062.53 0.00 530.71 14,189.84 14,189.84 0.00 2012 Public Works Vehicles Lease (PNC Equipment Finance) (17.52%)641 98 Business-Type Capital Lease 51,017.33 33,883.91 0.00 640.80 17,133.42 17,133.42 0.00 2012 PNC Vehicle Lease (12%)641 100 Business-Type Capital Lease 137,184.10 68,146.11 0.00 1,568.05 69,037.98 69,037.98 0.00 2012 PNC Vehicle Lease (11%)641 100 Business-Type Capital Lease 125,752.09 62,467.27 0.00 1,437.38 63,284.82 63,284.82 0.00 2014 Wastewater Ricoh Copiers (2)641 132 Business-Type Capital Lease 5,956.65 1,584.55 0.00 293.45 4,372.10 1,675.63 2,696.47 2014 Organic Resources Ricoh Copier (1)641 132 Business-Type Capital Lease 2,978.33 792.27 0.00 146.73 2,186.06 837.82 1,348.24 2012 Wastewater Ricoh/Ikon MPC4502 Copier 641 102 Business-Type Capital Lease 1,997.49 1,240.72 0.00 81.20 756.77 756.77 0.00 2013 PNC Vehicle & Equipment Lease (Sewers, 13.78%)641 110 Business-Type Capital Lease 141,610.17 46,630.44 0.00 1,585.85 94,979.74 47,201.07 47,778.67 2014 Police & Public Works Vehicles (Key Government Finance) (12%)641 124 Business-Type Capital Lease 189,551.67 46,296.03 0.00 2,759.56 143,255.65 47,016.45 96,239.19 2014 HP Computer Leases #1 (9.13%)641 125 Business-Type Capital Lease 8,648.40 2,848.51 0.00 330.95 5,799.89 2,979.39 2,820.50 2015 HP Computer Lease #9 - (1.66%) Wastewater 641 138 Business-Type Capital Lease 2,056.07 488.28 0.00 91.13 1,567.79 513.04 1,054.75 2015 Vehicle/Equip Lease (Banc of America) Wastewater - 14.86%641 140 Business-Type Capital Lease 508,995.65 98,288.23 0.00 7,613.84 410,707.42 100,561.11 310,146.31 2015 Vehicle/Equip Lease (Banc of America) Sewer Department - .99%641 140 Business-Type Capital Lease 33,910.21 6,548.14 0.00 507.25 27,362.07 6,699.56 20,662.51 2015 Vehicle Lease No. 2 (PNC Equipment Finance) - Organic Resources - 16%641 144 Business-Type Capital Lease 212,032.00 39,266.05 0.00 3,057.01 172,765.95 39,932.90 132,833.05 2016 Vehicle/Equipment Lease (public-finance.com) - Organic Resources - 21%641 149 Business-Type Capital Lease 0.00 67,902.62 708,845.00 5,323.71 640,942.38 136,874.58 504,067.80 2016 HP Computer Lease #12 - Wastewater - 19.69%641 150 Business-Type Capital Lease 0.00 674.55 3,433.91 134.63 2,759.36 769.66 1,989.70 2016 PNC Bank Vehicle/Equipment Lease No. 2 - Wastewater - .17%641 152 Business-Type Capital Lease 0.00 0.00 6,797.42 0.00 6,797.42 1,309.67 5,487.75 2016 PNC Bank Vehicle/Equipment Lease No. 2 - Organic Resources - 3.75%641 152 Business-Type Capital Lease 0.00 0.00 149,892.00 0.00 149,892.00 28,889.69 121,002.31 2016 HP Computer Lease No. 13 - Environmental Services - 5.87%641 155 Business-Type Capital Lease 0.00 320.89 9,158.92 72.22 8,838.03 1,970.40 6,867.63 2001 Public Works Service Center (Building Corporation), Refunded 2010 (12.3%)641 36 Business-Type Mortgage Bonds 407,745.00 68,880.00 0.00 13,926.80 338,865.00 70,725.00 268,140.00 2009 Sewage Works Revenue Bonds - State Revolving Fund 649 70 Business-Type Loan Payable 2,407,675.00 158,032.00 0.00 67,656.00 2,249,643.00 162,472.00 2,087,171.00 2010 Sewage Works Revenue Bonds 649 80 Business-Type Revenue Bonds 7,530,000.00 385,000.00 0.00 314,017.50 7,145,000.00 395,000.00 6,750,000.00 2011 Sewage Works Revenue Bonds 649 93 Business-Type Revenue Bonds 18,175,000.00 880,000.00 0.00 680,700.00 17,295,000.00 895,000.00 16,400,000.00 2012 Sewage Works Revenue Bonds 649 101 Business-Type Revenue Bonds 21,935,000.00 1,045,000.00 0.00 507,580.00 20,890,000.00 1,060,000.00 19,830,000.00 2013A Sewage Works Revenue Bonds (PNC Bank) (2)649 105 Business-Type Revenue Bonds 9,970,000.00 1,920,000.00 0.00 193,418.00 8,050,000.00 1,955,000.00 6,095,000.00 2015 Sewage Works Refunding Bonds (Piper Jaffray/Huntington Public Capital) (2)649 145 Business-Type Revenue Bonds 27,440,000.00 2,475,000.00 0.00 538,128.89 24,965,000.00 2,530,000.00 22,435,000.00 Unamortized Premium - Mortgage Bonds 4,151.20 1,552.20 0.00 0.00 2,599.00 0.00 2,599.00 Unamortized Premium - Revenue Bonds 181,488.64 55,485.64 0.00 0.00 126,003.00 0.00 126,003.00 Total 89,557,254.75 7,522,453.47 878,127.25 2,342,132.36 82,912,928.53 7,664,020.65 75,248,907.88 Debt Schedule Summary 2/17/2017 Page 5 City of South Bend, Indiana Debt Schedule Summary - Business Activities by Fund December 31, 2016 Amort.12/31/15 12/31/16 Fund Schedule CAFR Type Principal 2016 2016 2016 Principal Current Noncurrent Name Number Number Activity of Debt Balance Principal Additions Interest Balance Principal Additions 2012 PNC Vehicle Lease (7%)287/288 100 Business-Type Capital Lease 80,024.06 39,751.90 0.00 914.69 40,272.16 40,272.16 0.00 2012 Fire Dept Ricoh/Ikon MPC4502 Copier 287/288 103 Business-Type Capital Lease 2,099.54 1,172.86 0.00 97.94 926.68 926.68 0.00 2015 Vehicle Lease No. 2 (PNC Equipment Finance) - Fire Departmnet - 46%287/288 144 Business-Type Capital Lease 579,922.00 112,889.92 0.00 8,788.93 467,032.08 114,807.09 352,224.99 2016 PNC Bank Vehicle/Equipment Lease No. 2 - Fire - 2.69%287/288 152 Business-Type Capital Lease 0.00 0.00 107,463.60 0.00 107,463.60 20,723.53 86,740.07 2013 Building Corporation EMS Fire Station/Tower Bonds 287/288 116 Business-Type Mortgage Bond 5,365,000.00 220,000.00 0.00 184,155.00 5,145,000.00 225,000.00 4,920,000.00 Offage (1.00)0.00 0.00 0.00 (1.00)0.00 0.00 Unamortized Premium - Mortgage Bonds 74,669.00 4,267.00 0.00 0.00 70,402.00 0.00 70,402.00 Total 6,101,713.60 378,081.68 107,463.60 193,956.56 5,831,095.52 401,729.46 5,429,367.06 Debt Schedule Summary 2/17/2017 Page 6 City of South Bend, Indiana Discount/Premium - Governmental Activities City Name Schedule Revenue Bonds Century Center Refinance - 2001 (Refund 2011)7 Morris Performing Arts Center - 1998 Refinance 2009 (1)11 TJX Special District Bonds 2002 (Refunded 2014)12 Erskine Village Developer Bond - 2005 22 CEDIT Bonds - 1997 (Refunded 2006)31 Eddy Street Commons Lease Rental Revenue - 2008 (Refund 2015)54 Century Center Lease Rental Revenue Bonds - 2008 (Refund 2013)62 2015 Redevelopment Authority Smart Streets Bonds (Bank of America/Merrill)135 2015 EDIT/Parks Bonds (Bank of America)141 Total Revenue Bonds Mortgage Bonds - Building Corporation - GOVT PORTION ONLY 2010 - Public Works Service Center Refunding (87.7%) 36 2012 - Police & Fire Building/Renovation Refunding (2013 Issuance 39 Total Mortgage Bonds Total Discount/(Premium) Annual Amortization 2014 2015 2016 2017 2018 2019 2020 12/31/14 12/31/15 12/31/16 (4,135) (14,472) (4,135) (10,337) (4,135) (6,202) (4,135) (2,067) - - (10,119) (25,297) (10,119) (15,178) (10,119) (5,059) (5,059) - - - (10,741) (161,111) (21,482) (139,629) (21,482) (118,148) (21,482) (21,482) (21,482) (21,482) 3,181 39,766 3,181 36,585 3,181 33,404 3,181 3,181 3,181 3,181 (4,431) (11,076) (4,431) (6,646) (4,431) (2,215) (2,215) - - - (99,154) (1,239,420) 442,749 (1,682,169) (146,276) (1,535,894) (146,276) (146,276) (146,276) (146,276) (3,322) (38,205) (3,322) (34,883) (3,322) (31,561) (3,322) (3,322) (3,322) (3,322) - - - (458,630) - (458,630) (11,466) (22,931) (22,931) (22,931) - - - (83,495) (4,175) (79,320) (4,175) (4,175) (4,175) (4,175) (128,719) (1,449,815) 402,442 (2,394,382) (190,758) (2,203,624) (194,948) (197,072) (195,005) (195,005) (12,787) (41,527) (11,926) (29,601) (4,554) (25,047) (4,554) (4,554) (4,554) (4,554) (117,749) (1,000,866) (117,749) (883,117) (117,749) (765,368) (117,749) (117,749) (117,749) (117,749) (130,536) (1,042,393) (129,675) (912,718) (122,303) (790,415) (122,303) (122,303) (122,303) (122,303) (259,255) (2,492,208) 272,767 (3,307,100) (313,061) (2,994,039) (317,251) (319,375) (317,308) (317,308) Debt Schedule Summary 2/17/2017 Page 7 City of South Bend, Indiana Discount/Premium - Governmental Activities City Name Schedule Revenue Bonds Century Center Refinance - 2001 (Refund 2011)7 Morris Performing Arts Center - 1998 Refinance 2009 (1)11 TJX Special District Bonds 2002 (Refunded 2014)12 Erskine Village Developer Bond - 2005 22 CEDIT Bonds - 1997 (Refunded 2006)31 Eddy Street Commons Lease Rental Revenue - 2008 (Refund 2015)54 Century Center Lease Rental Revenue Bonds - 2008 (Refund 2013)62 2015 Redevelopment Authority Smart Streets Bonds (Bank of America/Merrill)135 2015 EDIT/Parks Bonds (Bank of America)141 Total Revenue Bonds Mortgage Bonds - Building Corporation - GOVT PORTION ONLY 2010 - Public Works Service Center Refunding (87.7%) 36 2012 - Police & Fire Building/Renovation Refunding (2013 Issuance 39 Total Mortgage Bonds Total Discount/(Premium) Annual Amortization 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 - - - - - - - - - - - - - - - - - - - - - - - - (21,482) (10,741) 3,181 3,181 3,181 3,181 3,181 3,181 1,594 - - - - - - - - - - - - - - - - - (146,276) (146,276) (146,276) (146,276) (146,276) (146,276) (73,134) - - - - - (3,322) (3,322) (3,322) (3,322) (3,322) (1,663) - - - - - - (22,931) (22,931) (22,931) (22,931) (22,931) (22,931) (22,931) (22,931) (22,931) (22,931) (22,931) (22,931) (4,175) (4,175) (4,175) (4,175) (4,175) (4,175) (4,175) (4,175) (4,175) (4,175) (4,175) (4,175) (195,005) (184,264) (173,523) (173,523) (173,523) (171,864) (98,646) (27,106) (27,106) (27,106) (27,106) (27,106) (4,554) (2,277) - - - - - - - - - - (117,749) (117,749) (58,874) - - - - - - - - - (122,303) (120,026) (58,874) - - - - - - - - - (317,308) (304,290) (232,397) (173,523) (173,523) (171,864) (98,646) (27,106) (27,106) (27,106) (27,106) (27,106) Debt Schedule Summary 2/17/2017 Page 8 City of South Bend, Indiana Discount/Premium - Governmental Activities City Name Schedule Revenue Bonds Century Center Refinance - 2001 (Refund 2011)7 Morris Performing Arts Center - 1998 Refinance 2009 (1)11 TJX Special District Bonds 2002 (Refunded 2014)12 Erskine Village Developer Bond - 2005 22 CEDIT Bonds - 1997 (Refunded 2006)31 Eddy Street Commons Lease Rental Revenue - 2008 (Refund 2015)54 Century Center Lease Rental Revenue Bonds - 2008 (Refund 2013)62 2015 Redevelopment Authority Smart Streets Bonds (Bank of America/Merrill)135 2015 EDIT/Parks Bonds (Bank of America)141 Total Revenue Bonds Mortgage Bonds - Building Corporation - GOVT PORTION ONLY 2010 - Public Works Service Center Refunding (87.7%) 36 2012 - Police & Fire Building/Renovation Refunding (2013 Issuance 39 Total Mortgage Bonds Total Discount/(Premium) Annual Amortization 2033 2034 2035 2036 2037 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - (22,931) (22,931) (22,931) (22,931) (11,476) (4,175) (4,175) (4,170) - - (27,106) (27,106) (27,101) (22,931) (11,476) - - - - - - - - - - - - - - - (27,106) (27,106) (27,101) (22,931) (11,476) Debt Schedule Summary 2/17/2017 Page 9 City of South Bend, Indiana Discount/Premium - Business Type Discount/Premium amortization uses the Effective Interest method and is hard-coded Issuance Unamortized Discount/(Premium) Annual Amortization City Issue/Refund 1st Pmt Maturity Discount Semi-annual Disc/(Prem)2014 2015 2016 2017 Name Schedule Date Date Date (Premium)Periods 12/31/13 12/31/14 12/31/15 12/31/16 Revenue Bonds 2006 Water Works Improvements - refunded end of 2016 24 12/30/06 01/01/07 01/01/27 45,642 41 13,091 2,916 10,175 2,461 7,714 1,971 - - 2012B Refunding Water Works Improvements 25 11/19/12 07/01/13 01/01/23 36,700 41 30,409 5,716 24,693 5,193 19,500 4,651 14,849 4,077 2007 Sewage Works Improvements 40 06/20/07 12/01/07 12/01/27 79,105 41 23,131 (8,706) 31,838 31,838 - - - - 2006 Sewage Works Improvements 42 12/01/06 12/01/06 12/01/26 15,613 35,979 989 34,990 34,990 - - - - 2007 Sewage Works Revenue Bonds - 2007B 52 06/01/07 06/20/07 12/01/27 (39,466) (81,996) 359 (82,355) (82,355) - - - - 2010 Sewage Works Revenue Bonds 80 12/21/10 06/01/11 12/01/30 (177,985) (158,840) (19,638) (139,202) (23,176) (116,026.14) (26,924) (89,102) (27,006) 2011 Sewage Works Revenue Bonds 93 10/25/11 06/01/12 12/01/31 2,834 40 94,586 6,287 88,299 225 88,073.96 (6,139) 94,213 (12,853) 2012 Water Works Revenue Bond 99 06/21/12 01/01/13 01/01/33 82,961 41 45,904 25,973 19,931 22,578 (2,646) 19,009 (21,656) 15,262 2012 Sewage Works Revenue Bonds 101 12/13/12 06/01/13 12/01/32 (196,371) (174,581) (11,924) (162,657) (14,463) (148,194.28) (17,081) (131,114) (19,791) 2013A Sewage Works Revenue Bonds (PNC Bank) (2)105 04/25/13 06/01/14 12/01/24 - (136,222) (636) (135,586) (135,586) - - - - Total Revenue Bonds (150,968) (308,539) 1,335 (309,874) (158,295) (151,580) (24,513) (132,809) (40,309) (156,921) 2015 CAFR Mortgage Bonds - Building Corporation 2010 - Public Works Service Center Refunding (12.3%) 36 2010 08/10/10 02/01/21 (20,481) 22 (7,618) (1,793) (5,824) (1,673) (4,152)(1,553) (2,599) (1,391) 2013 - Building Corporation EMS Fire Station/Tower Bonds 116 11/07/13 02/01/14 02/01/33 (83,202) 39 (83,202) (4,267) (78,935) (4,267) (74,669) (4,267) (70,402) (4,267) Total Mortgage Bonds (103,682) (90,820) (6,060) (84,759) (5,939) (78,820) (5,820) (73,000) (5,658) Total (254,650) (399,359) (4,725) (394,634) (164,234) (230,400) (30,333) (205,810) (45,967) Debt Schedule Summary 2/17/2017 Page 10 City of South Bend, Indiana Discount/Premium - Business Type Discount/Premium amortization uses the Effective Interest method and is hard-coded City Name Schedule Revenue Bonds 2006 Water Works Improvements - refunded end of 2016 24 2012B Refunding Water Works Improvements 25 2007 Sewage Works Improvements 40 2006 Sewage Works Improvements 42 2007 Sewage Works Revenue Bonds - 2007B 52 2010 Sewage Works Revenue Bonds 80 2011 Sewage Works Revenue Bonds 93 2012 Water Works Revenue Bond 99 2012 Sewage Works Revenue Bonds 101 2013A Sewage Works Revenue Bonds (PNC Bank) (2)105 Total Revenue Bonds Mortgage Bonds - Building Corporation 2010 - Public Works Service Center Refunding (12.3%) 36 2013 - Building Corporation EMS Fire Station/Tower Bonds 116 Total Mortgage Bonds Total Discount/(Premium) Annual Amortization 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 - - - - - - - - - - - - - - - 3,473 2,846 2,187 1,495 769 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - (27,065) (27,103) (27,106) (27,072) (27,000) (26,876) (26,699) 12,226 15,054 18,101 22,253 26,712 32,480 - - (19,930) (27,457) (35,453) (39,049) (42,851) (41,629) (40,251) (38,713) 51,113 56,350 61,934 67,878 74,196 80,929 - 11,330 7,207 4,690 2,053 (743) (3,706) (5,819) (7,016) (8,276) (8,493) (8,133) (7,157) (6,096) (4,324) (2,436) (22,594) (25,494) (28,503) (31,635) (34,904) (38,324) (41,899) (43,108) (43,046) 19,613 23,929 28,481 34,768 41,386 50,007 - - - - - - - - - - - - - - - (54,786) (70,001) (84,184) (94,208) (104,729) (110,536) (114,668) (76,611) 14,845 85,571 99,982 115,914 135,349 117,991 47,571 (1,052) (622) 93 373 12,575 0 - - - - - - - - - (4,267) (4,267) (4,267) (4,267) (4,267) (4,267) (4,267) (4,267) (4,267) (4,267) (4,267) (4,267) (4,267) (4,267) (4,267) (5,319) (4,889) (4,174) (3,894) 8,308 (4,267) (4,267) (4,267) (4,267) (4,267) (4,267) (4,267) (4,267) (4,267) (4,267) (60,106) (74,890) (88,358) (98,102) (96,421) (114,803) (118,935) (80,878) 10,578 81,304 95,715 111,647 131,082 113,724 43,304 Debt Schedule Summary 2/17/2017 Page 11 City of South Bend, Indiana Discount/Premium - Business Type Discount/Premium amortization uses the Effective Interest method and is hard-coded City Name Schedule Revenue Bonds 2006 Water Works Improvements - refunded end of 2016 24 2012B Refunding Water Works Improvements 25 2007 Sewage Works Improvements 40 2006 Sewage Works Improvements 42 2007 Sewage Works Revenue Bonds - 2007B 52 2010 Sewage Works Revenue Bonds 80 2011 Sewage Works Revenue Bonds 93 2012 Water Works Revenue Bond 99 2012 Sewage Works Revenue Bonds 101 2013A Sewage Works Revenue Bonds (PNC Bank) (2)105 Total Revenue Bonds Mortgage Bonds - Building Corporation 2010 - Public Works Service Center Refunding (12.3%) 36 2013 - Building Corporation EMS Fire Station/Tower Bonds 116 Total Mortgage Bonds Total Discount/(Premium) Annual Amortization 2033 - - - - - - - - - - - (2,130) (2,130) (2,130) Debt Schedule Summary 2/17/2017 Page 12 City of South Bend, Indiana Gain/Loss - Governmental Loss Unamortized City Issue/Refund 1st Pmt Maturity (Gain) on Semi-annual Loss (Gain)Loss/(Gain) Annual Amortization Name Schedule Date Date Date Refunding Periods 12/31/13 2014 2015 2016 12/31/14 12/31/15 Revenue Bonds Downtown Central Development Area TIF - 2003 (Refund 2011)5 12/29/11 02/01/12 08/01/24 (1,415,626) 26 (108,894) (1,197,837) (108,894) (1,088,943) (108,894) (980,049) (108,894) Airport TIF - 2003 (Refund 2011)6 12/29/11 02/01/12 08/01/24 (481,209) 26 (37,016) (407,177) (37,016) (370,161) (37,016) (333,145) (37,016) Century Center Refinance - 2001 (Refund 2011)7 08/16/11 02/01/12 02/01/18 248,042 13 38,160 171,721 38,160 133,561 38,160 95,401 38,160 Hall of Fame 2000 Refunding (Refund 2011)8 08/16/11 02/01/12 02/01/18 130,102 13 20,016 90,071 20,016 70,055 20,016 50,039 20,016 Morris Performing Arts Center - 1998 Refinance 2009 (1)11 04/29/09 08/01/09 02/01/17 300,193 16 37,524 131,334 37,524 93,810 37,524 56,286 37,524 TJX Special District Bonds 2002 (Refunded 2014)12 06/03/14 07/01/14 01/01/22 (46,522) 16 (5,815) - (5,815) 5,815 (5,815) 11,630 1,789 Erskine Village Developer Bond - 2005 22 4/19/05 08/01/05 02/01/27 - 44 - - - - - - - CEDIT Bonds-2006 refund 97 31 12/14/06 02/01/07 02/01/17 398,943 21 37,995 132,981 37,995 94,986 37,995 56,992 37,995 Eddy Street Commons Lease Rental Revenue - 2008 54 3/18/08 08/15/08 2/15/33 2,879,777 35 164,559 - - - 2,879,777 2,879,777 164,559 Century Center Lease Rental Revenue Bonds - 2008 (Refund 2013)62 12/05/13 05/01/14 05/01/26 466,724 25 37,338 466,724 37,338 429,386 37,338 392,048 37,338 Recovery Zone Economic Development Bonds 81 12/30/10 07/15/11 01/15/19 - 16 - - - - - - - 2011 SB Career Academy Project Economic Develop Revenue Bonds 96 12/30/11 02/15/12 11/15/14 - 12 - - - - - - Total Revenue Bonds 2,480,425 (612,183) 19,307 (631,490) 2,899,084 2,228,980 191,471 Mortgage Bonds - Building Corporation - GOVT PORTION ONLY 2010 - Public Works Service Center Refunding (87.7%) 36 2010 08/10/10 02/01/21 (146,030)22 (13,275) (54,314) (12,787) (41,527) (11,926) (29,601) (5,382) 2012 - Police & Fire Building/Renovation Refunding (2013 Issuance)39 09/10/12 02/01/13 02/01/23 449,520 21 42,811 406,709 42,811 363,897 42,811 321,086 42,811 Total Mortgage Bonds 303,490 352,395 30,024 322,370 30,885 291,485 37,429 Total 2,783,915 (259,788) 49,331 (309,120) 2,929,969 2,520,465 y 228,900 Debt Schedule Summary 2/17/2017 Page 13 City of South Bend, Indiana Gain/Loss - Governmental City Name Schedule Revenue Bonds Downtown Central Development Area TIF - 2003 (Refund 2011)5 Airport TIF - 2003 (Refund 2011)6 Century Center Refinance - 2001 (Refund 2011)7 Hall of Fame 2000 Refunding (Refund 2011)8 Morris Performing Arts Center - 1998 Refinance 2009 (1)11 TJX Special District Bonds 2002 (Refunded 2014)12 Erskine Village Developer Bond - 2005 22 CEDIT Bonds-2006 refund 97 31 Eddy Street Commons Lease Rental Revenue - 2008 54 Century Center Lease Rental Revenue Bonds - 2008 (Refund 2013)62 Recovery Zone Economic Development Bonds 81 2011 SB Career Academy Project Economic Develop Revenue Bonds 96 Total Revenue Bonds Mortgage Bonds - Building Corporation - GOVT PORTION ONLY 2010 - Public Works Service Center Refunding (87.7%) 36 2012 - Police & Fire Building/Renovation Refunding (2013 Issuance)39 Total Mortgage Bonds Total 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 42,735 (871,155) (108,894) (108,894) (108,894) (108,894) (108,894) (108,894) (108,894) (108,897) - - - - (296,129) (37,016) (37,016) (37,016) (37,016) (37,016) (37,016) (37,016) (37,017) - - - - 57,241 38,160 19,081 - - - - - - - - - - 30,023 20,016 10,007 - - - - - - - - - - 18,762 18,762 - - - - - - - - - - - 9,841 1,789 1,789 1,789 1,789 1,789 896 - - - - - - - - - - - - - - - - - - - 18,997 18,997 - - - - - - - - - - - 2,715,218 164,559 164,559 164,559 164,559 164,559 164,559 164,559 164,559 164,559 164,559 164,559 164,559 354,710 37,338 37,338 37,338 37,338 37,338 37,338 37,338 37,338 37,338 18,668 - - - - - - - - - - - - - - - - - - - - - - - - - - - - 2,037,509 153,711 86,864 57,776 57,776 57,776 56,883 55,987 55,983 201,897 183,227 164,559 164,559 (24,219) (5,382) (5,382) (5,382) (5,382) (2,691) - - - - - - - 278,275 42,811 42,811 42,811 42,811 42,811 42,811 21,409 - - - - - 254,056 37,429 37,429 37,429 37,429 40,120 42,811 21,409 - - - - - 2,291,565 191,140 124,293 95,205 95,205 97,896 99,694 77,396 55,983 201,897 183,227 164,559 164,559 Debt Schedule Summary 2/17/2017 Page 14 City of South Bend, Indiana Gain/Loss - Governmental City Name Schedule Revenue Bonds Downtown Central Development Area TIF - 2003 (Refund 2011)5 Airport TIF - 2003 (Refund 2011)6 Century Center Refinance - 2001 (Refund 2011)7 Hall of Fame 2000 Refunding (Refund 2011)8 Morris Performing Arts Center - 1998 Refinance 2009 (1)11 TJX Special District Bonds 2002 (Refunded 2014)12 Erskine Village Developer Bond - 2005 22 CEDIT Bonds-2006 refund 97 31 Eddy Street Commons Lease Rental Revenue - 2008 54 Century Center Lease Rental Revenue Bonds - 2008 (Refund 2013)62 Recovery Zone Economic Development Bonds 81 2011 SB Career Academy Project Economic Develop Revenue Bonds 96 Total Revenue Bonds Mortgage Bonds - Building Corporation - GOVT PORTION ONLY 2010 - Public Works Service Center Refunding (87.7%) 36 2012 - Police & Fire Building/Renovation Refunding (2013 Issuance)39 Total Mortgage Bonds Total 2029 2030 2031 2032 2033 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 164,559 164,559 164,559 164,559 82,274 - - - - - - - - - - - - - - - 164,559 164,559 164,559 164,559 82,274 - - - - - - - - - - - - - - - 164,559 164,559 164,559 164,559 82,274 Debt Schedule Summary 2/17/2017 Page 15 City of South Bend, Indiana Gain/Loss on Refunding - Buiness Type Loss Unamortized City Issue/Refund 1st Pmt Maturity (Gain) on Semi-annual Loss (Gain)2014 2015 2016 Name Schedule Date Date Date Refunding Periods 12/31/13 Loss/(Gain)12/31/14 Loss/(Gain)12/31/15 Revenue Bonds 2006 Water Works Improvements 24 12/30/06 01/01/07 01/01/27 - 41 - - - - - - 2012B Refunding Water Works Improvements 25 11/19/12 07/01/13 01/01/23 26,874 21 2,559 24,187 2,687 21,499 2,687 18,812 2,508 2011 Sewage Works Revenue Bonds 93 10/25/11 06/01/12 12/01/31 - 40 - - - - - - 2012 Water Works Revenue Bond 99 06/21/12 01/01/13 01/01/33 - 41 - - - - - - 2012 Sewage Works Revenue Bonds 101 - - - - - - - 2013A Sewage Works Revenue Bonds (PNC Bank) (2)105 04/25/13 06/01/14 12/01/24 631,980 24 52,665 596,870 52,665 544,205 52,665 491,540 54,616 2015 Sewage Works Revenue Bonds 145 12/08/15 06/01/16 12/01/25 1,903,507 20 190,351 1,903,507 190,351 2016 Water Works refunding (refunds 2006)*- - Total Revenue Bonds 2,562,361 621,057 55,352 565,704 55,352 2,413,859 247,474 Mortgage Bonds - Building Corporation 2010 - Public Works Service Center Refunding (12.3%) 36 2010 08/10/10 02/01/21 24,931 22 16,819 2,374 14,444 2,374 12,070 2,374 2013 - Building Corporation EMS Fire Station/Tower Bonds 116 11/07/13 02/01/14 02/01/33 - 39 - - - - - - Total Mortgage Bonds - - - - - - 2,374 Total 2,562,361 621,057 55,352 565,704 55,352 2,413,859 249,849 - but 2015 with this total is wrong - omitted 12,070?? - 2015 CAFR fin stmts are wrong also - delete from this sch for future or make adj entry to 2016 fin stmts * - immaterial since less than 5% - recognize as affecting current period income Debt Schedule Summary 2/17/2017 Page 16 City of South Bend, Indiana Gain/Loss on Refunding - Buiness Type City Name Schedule Revenue Bonds 2006 Water Works Improvements 24 2012B Refunding Water Works Improvements 25 2011 Sewage Works Revenue Bonds 93 2012 Water Works Revenue Bond 99 2012 Sewage Works Revenue Bonds 101 2013A Sewage Works Revenue Bonds (PNC Bank) (2)105 2015 Sewage Works Revenue Bonds 145 2016 Water Works refunding (refunds 2006)* Total Revenue Bonds Mortgage Bonds - Building Corporation 2010 - Public Works Service Center Refunding (12.3%) 36 2013 - Building Corporation EMS Fire Station/Tower Bonds 116 Total Mortgage Bonds Total * - immaterial since less than 5% - recognize as affecting current period income 2017 2018 2019 2020 2021 2022 2023 2024 2025 12/31/16 - - - - - - - - - 16,304 2,508 2,508 2,508 2,508 2,508 2,508 1,256 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 436,924 54,616 54,616 54,616 54,616 54,616 54,616 54,616 54,612 - 1,713,156 190,351 190,351 190,351 190,351 190,351 190,351 190,351 190,351 190,351 2,166,384 247,475 247,475 247,475 247,475 247,475 247,475 246,223 244,963 190,351 9,695 2,374 2,374 2,374 2,374 198 - - - - - - - - - - - - - - 9,695 2,374 2,374 2,374 2,374 198 - - - - 2,176,080 249,849 249,849 249,849 249,849 247,673 247,475 246,223 244,963 190,351 - but 2015 with this total is wrong - omitted 12,070?? - 2015 CAFR fin stmts are wrong also - delete from this sch for future or make adj entry to 2016 fin stmts Debt Schedule Summary 2/17/2017 Page 17