|
City of South Bend Period Ending:November 30, 2016
<br />Monthly Debt Schedule
<br />Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at YT D Principa l Y TD Interes t YT D Debt a t
<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 Pay ments Ad ditions 11/30/20 16
<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
<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
<br />2 5 Wat er Works Impr ovemen ts W ater W orks 200 2 201 2 20 23 62 5 7/1 12/3 1--5,975,00 0.00 2,745,000.00 0.00 27,450.00 0.00 2,745,000.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
<br />2 4 Wat er Works Impr ovemen ts W ater W orks 200 6 20 27 62 5 7/1 12/3 1--4,710,00 0.00 3,090,000.00 0.00 68,900.00 0.00 3,090,000.00
<br />6 2 Cen tury Center Spec i al Tax Bonds C entury Center 200 8 20 28 32 4 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
<br />6 9 Wat er Works Impr ovemen ts W ater W orks 200 9 20 30 62 5 7/1 12/3 1--5,380,00 0.00 4,555,000.00 0.00 125,489.00 0.00 4,555,000.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 0.00 33,828.00 0.00 2,407,675.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 0.00 157,008.75 0.00 7,530,000.00
<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 0.00 340,350.00 0.00 18,175,000.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 0.00 108,393.13 0.00 7,275,000.00
<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 0.00 253,790.00 0.00 21,935,000.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 0.00 96,709.00 0.00 9,970,000.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
<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 paid thru 2/28/1 7
<br />13 9 Cen tury Center En ergy Saving s Impro v ements C entury 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
<br />14 1 Park s and Rec 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 00,000.00 180,106.00 0.00 5,305,000.00
<br />14 5 Sewage W orks Reve nue Bon ds - 2015 Sewer B ond Improvements 201 5 20 25 64 9 6/1 12/1--27,440,00 0.00 27,440,000.00 0.00 263,728.89 0.00 27,440,000.00
<br />15 6 2 016 W ater Wo rks Refu nding Bon ds R efunding 20 00 / 2 006 SRF 201 6 20 27 62 5 1/1 7/1--3,300,00 0.00 0.00 3,3 00,0 00.00 3,300,000.00
<br />xxx
<br />Total Bond Debt 2 34,877,59 3.50 140,677,079.92 3,3 27,585.00 2,678,883.11 3,3 00,0 00.00 140,649,494.92
<br />Loa ns Payab le
<br />6 8 State R evolving F und W ater W orks Improvement 200 9 20 30 62 5 7/1 12/3 1--427,33 2.00 352,793.00 0.00 5,944.56 0.00 352,793.00
<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 1 46,067.50 0.00 0.00 1,443,703.00
<br />2 6 State R evolving F und W ater W orks Improvements 200 0 20 19 62 5 7/1 12/3 1--2,600,00 0.00 698,431.00 0.00 10,127.00 0.00 698,431.00
<br />xxx
<br />Total Loans Pa yable 29,822,33 2.00 2,640,994.50 1 46,067.50 16,071.56 0.00 2,494,927.00
<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
<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.17 1,567.53 0.00(0.02)
<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
<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.45 0.00 0.00
<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
<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 570.84 17.64 0.00(0.03)
<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
<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
<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
<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.28 13,067.06 0.00 575,316.54
<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,134.62 77.14 0.00 862.87
<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
<br />10 6 Ricoh U SA 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 774.43 65.33 0.00 812.03
<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 861.58 91.52 0.00 1,521.51
<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,168.51 90.67 0.00 1,226.81
<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,390.72 262.84 0.00 3,557.93
<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.14 11,508.38 0.00 689,257.89
<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 1,104.78 191.22 0.00 3,612.09
<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 760.33 100.42 0.00 1,562.83
<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
<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
<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,764.86 270.14 0.00 4,359.06
<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,029.65 157.80 0.00 2,544.33
<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 862.84 132.22 0.00 2,132.23
<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 862.84 132.22 0.00 2,132.23
<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 769.89 132.11 0.00 2,148.41
<br />12 4 Key Go v ernment Fi nance 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
<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 28,545.66 3,376.67 0.00 66,179.43
<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 830.23 105.21 0.00 2,024.24
<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,243.84 127.53 0.00 2,910.58
<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 769.79 107.57 0.00 1,989.69
<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 277.97 30.80 0.00 731.80
<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 926.85 200.32 0.00 3,388.96
<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,560.47 302.05 0.00 5,022.84
<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,173.64 408.61 0.00 6,761.34
<br />13 4 Wat er Works Copier - Nort h S tation R icho US A C opiers 201 4 20 19 62 0 Monthly 19th--4,73 2.65 3,071.37 858.87 136.19 0.00 2,212.50
<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 3,947.69 665.49 0.00 12,222.14
<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 891.44 223.08 0.00 3,675.31
<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 26,907.24 5,088.46 0.00 97,217.77
<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
<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 607.73 108.59 0.00 2,217.60
<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,306.87 19,088.01 0.00 1,021,876.13
<br />14 6 Park s & Rec reation Copier R icoh Copier 201 6 20 20 20 1 Monthly 4,30 2.06 4,219.84 699.68 204.74 0.00 3,520.16
<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,368.14 957.72 32,5 25.00 29,156.86
<br />14 8 Cen tral Services Lanier C opier C 6502 201 6 20 20 22 2 Monthly---11,41 3.00 0.00 1,181.87 336.08 11,4 13.00 10,231.13
<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 48,696.81 25,350.98 3,3 39,8 30.00 2,991,133.19
<br />15 0 HP Computer Lease C omputer Leas e- Ref resh 201 6 20 20 40 4/64 1/620 Monthly---17,43 9.85 0.00 3,108.31 627.69 17,4 39.85 14,331.54
<br />15 1 Admin and Finance R ic oh Copier MPC800 2S P Copier 201 6 20 21 10 1 Monthly---10,92 3.63 0.00 1,819.98 476.49 10,9 23.63 9,103.65
<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
<br />15 3 PNC Vehicle / Equ ip Lease Amend 1 Parks and R ecreat io n 201 6 20 12 20 1 1/17 7/17--78,80 8.00 0.00 0.00 0.00 78,8 08.00 78,808.00
<br />15 4 PNC Vehicle / Equ ip Lease N o. 3 Parks & Rec / IT 201 6 20 21 20 1/279 4/19 10/1 9--1,256,09 6.99 0.00 0.00 0.00 1,2 56,0 96.99 1,256,096.99
<br />xxx
<br />T otal Cap ital L ease 30,053,77 4.51 11,343,531.62 4,1 73,470.45 205,231.72 8,7 39,5 85.19 15,909,646.36
<br />To tal Civ i l C i ty 2 94,753,70 0.01 154,661,606.04 7,6 47,122.95 2,900,186.39 12,0 39,5 85.19 159,054,068.28
<br />Fi nanci a l R e p or t No vembe r 2 0 1 6 - De b t Page 2 0 o f 25
|