|
City of South Bend Period Ending:July 31, 2016
<br />Debt Schedule
<br />Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at 2016 Princip al 2016 Inter est 2016 Debt a t 2016 Total
<br />D eb t In strumen t D ebt Pur po se Issue Refunding M aturity F un d 1st 2nd 3rd 4th Is sue 12/3 1/20 15 Paym ents Payme nt Addit ion 12/31/20 16 D ebt P aymen ts
<br />Civil City Debt
<br />Bond Deb t
<br />A mort s ch #
<br />3 1 CEDIT Bond 199 7 200 6 20 17 40 8 2/1 8/1--11,870,00 0.00 1,265,000.00 8 35,000.00 49,030.00 0.00 430,000.00 884,03 0.00
<br />3 6 Sout h B end Building C orporation Pu bl ic W orks Building 200 1 201 0 20 21 40 4/649 2/1 8/1--9,250,00 0.00 3,315,000.00 5 60,000.00 113,226.00 0.00 2,755,000.00 673,22 6.00
<br />2 5 Wat er Works Impr ovemen ts W ater W orks 200 2 201 2 20 23 62 5 1/1 7/1--5,975,00 0.00 2,745,000.00 3 65,000.00 54,900.00 0.00 2,380,000.00 419,90 0.00
<br />3 9 Sout h B end Building C orporation Fire HQ / P ol ice H Q 200 3 201 2 20 23 40 4/324 2/1 8/1--21,335,00 0.00 10,085,000.00 1,2 00,000.00 365,560.00 0.00 8,885,000.00 1,565,56 0.00
<br />2 4 Wat er Works Impr ovemen ts W ater W orks 200 6 20 27 62 5 1/1 7/1--4,710,00 0.00 3,090,000.00 2 20,000.00 137,800.00 0.00 2,870,000.00 357,80 0.00
<br />6 2 Cen tury Center Spec i al Tax Bonds C entury Center 200 8 20 28 42 0 5/1 11/1--4,655,00 0.00 3,465,000.00 2 90,000.00 97,612.50 0.00 3,175,000.00 387,61 2.50
<br />6 9 Wat er Works Impr ovemen ts W ater W orks 200 9 20 30 62 5 1/1 7/1--5,380,00 0.00 4,555,000.00 2 30,000.00 250,978.00 0.00 4,325,000.00 480,97 8.00
<br />7 0 Sewage W orks Reve nue Bon ds - 2009 Sewag e W orks 200 9 20 28 64 9 6/1 12/1--3,297,00 0.00 2,407,675.00 1 58,032.00 67,656.00 0.00 2,249,643.00 225,68 8.00
<br />8 0 2 010 Sewage W orks Re v enue Bonds Sewag e W orks 201 0 20 30 64 9 6/1 12/1--9,345,00 0.00 7,530,000.00 3 85,000.00 314,017.50 0.00 7,145,000.00 699,01 7.50
<br />9 3 Sewage W orks Reve nue Bon ds 201 1 Sewag e W orks 201 1 20 31 64 9 6/1 12/1--21,500,00 0.00 18,175,000.00 8 80,000.00 680,700.00 0.00 17,295,000.00 1,560,70 0.00
<br />9 9 2 012 W ater Wo rks Reven ue Bond W ater W orks 201 2 20 33 62 5 1/1 7/1--8,300,00 0.00 7,275,000.00 3 50,000.00 216,786.26 0.00 6,925,000.00 566,78 6.26
<br />10 1 2 012 Sewage W orks Re v enue Bonds Sewag e W orks 201 2 20 32 64 9 6/1 12/1--25,000,00 0.00 21,935,000.00 1,0 45,000.00 507,580.00 0.00 20,890,000.00 1,552,58 0.00
<br />10 5 2 013A Sewer Bon d Refunding Sewag e W orks 201 3 201 3 20 24 64 9 6/1 12/1--14,765,00 0.00 9,970,000.00 1,9 20,000.00 193,418.00 0.00 8,050,000.00 2,113,41 8.00
<br />11 6 2 013 Building C orporation EMS / Fire D epar t ment 201 3 20 33 28 8 2/1 8/1--5,580,00 0.00 5,365,000.00 2 20,000.00 184,155.00 0.00 5,145,000.00 404,15 5.00
<br />13 3 St. Joseph Cou nty PS AP St. J oseph County PSA P 201 4 20 34 40 8 Monthly 2,657,69 6.50 2,386,507.92 0.00 0.00 0.00 2,386,507.92 0.00
<br />13 9 Cen tury Center En ergy Saving s Impro v ements at Century Ctr.201 5 20 31 67 2 5/1 11/1 4,167,89 7.00 4,167,897.00 22,585.00 213,546.84 0.00 4,145,312.00 236,13 1.84
<br />14 1 Park s and Rec reation Bo nd Parks Improveme nts 201 5 20 35 40 8 2/1 8/1--5,605,00 0.00 5,505,000.00 2 10,000.00 178,631.26 0.00 5,295,000.00 388,63 1.26
<br />14 5 Sewage W orks Reve nue Bon ds -20 15 Sewer Impr ovemen ts 201 5 20 25 64 9 6/1 12/1--27,440,00 0.00 27,440,000.00 2,4 75,000.00 538,128.89 0.00 24,965,000.00 3,013,12 8.89
<br />xxx
<br />Total Bond Debt 2 31,577,59 3.50 140,677,079.92 11,3 65,617.00 4,163,726.25 0.00 129,311,462.92 15,529,34 3.25
<br />Loa ns Payab le
<br />6 8 State R evolving F und W ater W orks Improvement 200 9 20 30 62 5 1/1 7/1--427,33 2.00 352,793.00 20,231.00 11,889.12 0.00 332,562.00 32,12 0.12
<br />8 2 In terfu nd Loan 41 0 - UDAG 1st Sour c e/Marriott Garage 201 0 20 15 41 0 6/15 12/1 5--2,700,00 0.00 1,589,770.50 2 38,172.75 0.00 0.00 1,351,597.75 238,17 2.75
<br />2 6 State R evolving F und W ater W orks Improvements 200 0 20 19 62 5 1/1 7/1--2,600,00 0.00 698,431.00 1 67,193.00 20,254.00 0.00 531,238.00 187,44 7.00
<br />xxx
<br />Total Loans Pa yable 29,822,33 2.00 2,640,994.50 4 25,596.75 32,143.12 0.00 2,215,397.75 457,73 9.87
<br />Ca pita l Leases
<br />5 1 Ch ase LE D Equipmen t 200 7 20 17 10 1 1/1 7/1--1,531,57 3.00 380,582.65 1 86,262.63 14,317.03 0.00 194,320.02 200,57 9.66
<br />8 9 Sun Trust Police, Parks, Bl dg vehicles 201 1 20 16 40 4/20 1/600 3/15 6/15 9/15 12/15 2,068,20 2.00 215,915.15 2 15,915.15 1,567.54 0.00 0.00 217,48 2.69
<br />9 0 Cap ital One Public Fundin g Solid Was te Cont ai ners/Truc k s 201 1 20 16 61 1 3/15 6/15 9/15 12/15 207,43 2.00 32,195.78 32,195.78 268.39 0.00 0.00 32,46 4.17
<br />9 1 GE Cap ital I nfor mation Techn ology Police Dept Copier 201 1 20 16 10 1 1/11 4/11 7/11 10/11 3,83 6.00 437.96 437.96 7.40 0.00 0.00 44 5.36
<br />9 2 Key Finance IT Phone S ystem 201 1 20 16 40 4 1/15 1,444,99 5.97 288,182.13 2 88,182.13 7,217.28 0.00 0.00 295,39 9.41
<br />9 4 Iko n Office Solu t ions Mayor Ric oh M P 2851 SP Copier 201 1 20 16 10 1 2/15 5/15 8/15 11/15 2,56 9.53 570.81 571.81 17.67 1.00 0.00 58 9.48
<br />9 5 Sun Trust E quipme nt F in ance Parks-Golf C ars Lease 201 2 20 16 20 1 4/15 10/1 5--344,50 0.00 44,305.79 44,305.79 355.45 0.00 0.00 44,66 1.24
<br />9 7 Sun Trust E quipme nt F in ance Police Veh ic le s & Equ ipment 201 2 20 17 40 6 5/15 11/1 5--1,295,00 0.00 400,372.65 2 65,787.43 5,663.85 0.00 134,585.22 271,45 1.28
<br />9 8 PNC Equipm ent F inance Pu bl ic W orks Vehicles Lease 201 2 20 17 20 2/64 1/640 5/15 11/1 5--945,67 4.38 291,194.81 1 93,401.30 3,657.54 0.00 97,793.51 197,05 8.84
<br />10 0 PNC Equipm ent F inance Pu bl ic W orks Vehicles Lease 201 2 20 17 20 2/64 1/600/288 1/15 7/15--2,806,05 4.00 1,143,200.82 5 67,884.27 13,067.06 0.00 575,316.55 580,95 1.33
<br />10 2 Iko n Office Solu t ions / Ricoh W astewater C opier 201 2 20 17 64 1 Monthly 1st 5,74 4.95 1,997.49 1,240.72 81.20 0.00 756.77 1,32 1.92
<br />10 3 GE Cap ital I nfor mation Techn ology Fire Department Cop ie r 201 2 20 17 10 1 2/28 5/28 8/28 11/28 5,47 1.01 2,099.54 1,172.86 97.94 0.00 926.68 1,27 0.80
<br />10 6 Ricoh U SA (N ew)C entra l Servi c es Copier 201 3 20 18 22 2 2/27 5/27 8/27 11/27 3,62 2.78 1,586.46 770.64 69.12 0.00 815.82 83 9.76
<br />10 7 Ricoh U SA Street/Sewer Dept Copier 201 3 20 18 20 2/641 3/4 6/4 9/4 12/4 5,55 9.15 2,383.09 1,157.16 113.64 0.00 1,225.93 1,27 0.80
<br />10 8 Ricoh U SA C ity Att orney C opier 201 3 20 18 10 1 2/12 5/12 8/12 11/12 5,55 9.15 2,395.32 1,162.59 108.21 0.00 1,232.73 1,27 0.80
<br />10 9 Ricoh U SA Parks & Rec Ricoh Copi ers(3)201 3 20 18 20 1 2/21 5/21 8/21 11/21 16,12 9.94 6,948.65 3,373.56 313.68 0.00 3,575.09 3,68 7.24
<br />11 0 PNC Equipm ent F inance Vehi c le/Equipmen t Lease 201 3 20 18 10 1/20 2/406/641 1/15 7/15--1,689,66 9.59 1,027,650.03 3 38,392.15 11,508.38 0.00 689,257.88 349,90 0.53
<br />11 1 Ricoh U SA En gi neer in g P l otter/Scan ner 201 3 20 18 10 1 3/3 6/3 9/3 12/3 10,66 7.67 4,716.87 2,257.61 334.39 0.00 2,459.26 2,59 2.00
<br />11 2 Ricoh U SA Bu ildin g Dept. Co pi er 201 3 20 18 60 0 Monthly 4,09 3.64 2,323.16 831.39 107.61 0.00 1,491.77 93 9.00
<br />11 3 Sun Trust E quipme nt F in ance Police and PW vehicles 201 3 20 18 40 4/65 5/611/202 4/24 10/2 4--1,506,46 5.26 918,109.86 3 01,217.97 13,363.17 0.00 616,891.89 314,58 1.14
<br />11 4 Ricoh U SA Admi n & Fina nce Copier 201 3 20 18 10 1 1/16 4/16 7/16 10/16 11,24 7.97 5,386.95 2,307.59 263.65 0.00 3,079.36 2,57 1.24
<br />11 7 Police Dept. R ecord D iv. R icoh Police Rec ords Co pi er 201 3 20 18 10 1 Monthly 3rd--9,67 8.26 6,123.92 1,929.78 290.22 0.00 4,194.14 2,22 0.00
<br />11 8 Wat er Works Main R i c oh Copier W ater W orks M ain Ricoh Co pi er 201 3 20 18 62 0 Monthly 10th--5,64 7.50 3,573.98 1,125.87 169.53 0.00 2,448.11 1,29 5.40
<br />11 9 Wat er Works Colfax Ricoh C opier W ater W orks Colfa x R ico h Copier 201 3 20 18 62 0 Monthly 16th--4,73 2.65 2,995.07 943.45 142.07 0.00 2,051.62 1,08 5.52
<br />12 0 Wat er Works Oliv e Ricoh Copier W ater W orks Olive Ricoh C opier 201 3 20 18 62 0 Monthly 10th--4,73 2.65 2,995.07 943.45 142.07 0.00 2,051.62 1,08 5.52
<br />12 3 Police T raining D ept. Ricoh C opier Tra in i ng Copier 201 4 20 19 10 1 Monthly 30th--4,26 3.00 2,918.30 841.86 142.14 0.00 2,076.44 98 4.00
<br />12 4 Police/Public Works V ehicle Leas e 2014 Ci ty V ehicles 201 4 20 19 Various 4/1 10/1--1,959,48 5.95 1,579,597.27 3 85,800.22 22,996.32 0.00 1,193,797.05 408,79 6.54
<br />12 5 HP Computer Lease #1 C omputer Equipment Le ase 201 4 20 18 various Monthly 8th--137,10 4.95 94,725.09 31,199.46 3,624.89 0.00 63,525.63 34,82 4.35
<br />12 6 HP Computer Lease #2 C omputer Equipment Le ase 201 4 20 18 20 1 and 620 Monthly 8th--4,00 0.00 2,854.47 907.46 113.02 0.00 1,947.01 1,02 0.48
<br />12 7 HP Computer Lease #4 C omputer Equipment Le ase 201 4 20 18 40 4 Monthly 8th--5,88 6.15 4,154.42 1,359.12 136.92 0.00 2,795.30 1,49 6.04
<br />12 8 HP Computer Lease #6 C omputer Equipment Le ase 201 4 20 18 20 1 Monthly 8th--3,75 5.50 2,759.48 841.49 115.63 0.00 1,917.99 95 7.12
<br />12 9 HP Computer Lease #7 C omputer Equipment Le ase 201 4 20 18 62 0 Monthly 8th--1,32 6.00 1,009.77 303.72 33.12 0.00 706.05 33 6.84
<br />13 0 Solid Waste C opier R icoh US A C opier 201 4 20 19 61 1 Monthly 17th--5,35 1.65 4,315.81 1,013.49 216.15 0.00 3,302.32 1,22 9.64
<br />13 1 Police Com munications Copier R icoh US A C opier 201 4 20 19 10 1 Monthly 12th--8,84 3.00 6,583.31 1,706.32 325.50 0.00 4,876.99 2,03 1.82
<br />13 2 Organic Resources & Was tewater R icoh US A C opiers 201 4 20 19 64 1 Monthly 21s t--12,26 0.18 8,934.98 2,376.82 440.18 0.00 6,558.16 2,81 7.00
<br />13 4 Wat er Works Copier - Nort h S tation R icoh US A C opiers 201 4 20 19 62 0 Monthly 19th--4,73 2.65 3,071.37 939.12 146.40 0.00 2,132.25 1,08 5.52
<br />13 6 HP Computer Lease #8 C omputer Equipment Le ase 201 5 20 19 40 4/20 1/611 Monthly 16th--19,60 3.94 16,169.83 4,315.69 716.87 0.00 11,854.14 5,03 2.56
<br />13 7 Anima l Control Ricoh Copier R icoh US A C opiers 201 5 20 20 60 0 Monthly 30th--5,26 1.50 4,566.75 974.87 240.97 0.00 3,591.88 1,21 5.84
<br />13 8 HP Computer Lease #9 C omputer Equipment Le ase 201 5 20 19 Various Monthly TBD--135,95 8.05 124,125.01 29,414.39 5,490.01 0.00 94,710.62 34,90 4.40
<br />14 0 Vehicle & Equip. Lease Vehi c le/Equipmen t Lease 201 5 20 20 Various 1/15 7/15--3,425,27 3.58 3,425,273.58 6 61,428.23 51,237.13 0.00 2,763,845.35 712,66 5.36
<br />14 3 HP Computer Lease #11 C omputer Equipment Le ase 201 5 20 19 40 4 Monthly--3,04 0.00 2,825.33 664.27 117.17 0.00 2,161.06 78 1.44
<br />14 4 PNC Vehicle Lease No. 2 Vehi c le Lease Pu rchase 201 5 20 20 Various 5/15 11/1 5--1,267,18 3.00 1,267,183.00 2 45,327.64 19,067.24 0.00 1,021,855.36 264,39 4.88
<br />14 6 Park s & Rec. Ricoh Cop ie r R icoh Copier 201 6 20 20 20 1 Monthly--4,30 2.06 4,219.84 765.12 221.52 0.00 3,454.72 98 6.64
<br />14 7 Cen tral Services Lanier C opier C 5100 5 Copier 201 6 20 20 22 2 Monthly--32,52 5.00 0.00 3,857.81 1,086.03 32,5 25.00 28,667.19 4,94 3.84
<br />14 8 Cen tral Services Lanier C opier C 6502 Copier 201 6 20 20 22 2 Monthly--11,41 3.00 0.00 1,353.69 381.11 11,4 13.00 10,059.31 1,73 4.80
<br />14 9 Vehicle & Equip. Lease Pu bl ic W orks Vehicles Lease 201 6 20 21 Various 2/15 8/15--3,339,83 0.00 0.00 3 23,345.83 25,350.98 3,3 39,8 30.00 3,016,484.17 348,69 6.81
<br />15 0 HP Computer Lease C opier L ease 201 6 20 20 Various Monthly--17,43 9.85 0.00 3,425.86 683.74 17,4 39.85 14,013.99 4,10 9.60
<br />15 1 Admin and Finance R ic oh Copier C opier L ease 201 6 20 21 10 1 Monthly--10,92 3.63 0.00 1,985.36 519.88 10,9 23.63 8,938.27 2,50 5.24
<br />15 2 PNC Vehicle / Equ ip Lease N o. 2 Vehi c le / E quipment Lea s e 201 6 20 21 Various 1/14 7/14--3,992,54 8.72 0.00 0.00 0.00 3,9 92,5 48.72 3,992,548.72 0.00
<br />xxx
<br />T otal Cap ital L ease 28,718,86 9.52 11,343,531.62 4,1 57,918.88 206,647.01 7,4 04,6 81.20 14,590,293.94 4,364,56 5.89
<br />To tal Civ i l C i ty 2 90,118,79 5.02 154,661,606.04 15,9 49,132.63 4,402,516.38 7,4 04,6 81.20 146,117,154.61 20,351,64 9.01
<br />Fi nanci a l R e p or t Jul y 2016 - Debt Page 1 8 o f 25
|