|
City of South Bend Period Ending:February 29, 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 2/2 9/2016
<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 4 10,000.00 29,265.00 0.00 855,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 2 80,000.00 58,713.00 0.00 3,035,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 0.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 5 95,000.00 188,730.00 0.00 9,490,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 0.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 42 0 5/1 11/1--4,655,00 0.00 3,465,000.00 0.00 0.00 0.00 3,465,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 0.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 0.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 0.00 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 0.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 0.00 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 0.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 0.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 93,727.50 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 0.00 0.00 0.00 4,167,897.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 1 00,000.00 90,040.00 0.00 5,405,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 0.00 0.00 27,440,000.00
<br />xxx
<br />Total Bond Debt 2 31,577,59 3.50 140,677,079.92 1,6 05,000.00 460,475.50 0.00 139,072,079.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 0.00 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 0.00 0.00 0.00 1,589,770.50
<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 0.00 0.00 698,431.00
<br />xxx
<br />Total Loans Pa yable 29,822,33 2.00 2,640,994.50 0.00 0.00 0.00 2,640,994.50
<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 92,145.36 8,144.47 0.00 288,437.29
<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 0.00 0.00 0.00 215,915.15
<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 0.00 0.00 0.00 32,195.78
<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 216.92 5.26 0.00 221.04
<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 139.71 7.41 0.00 431.10
<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 0.00 0.00 0.00 44,305.79
<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 0.00 0.00 0.00 400,372.65
<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 0.00 0.00 0.00 291,194.81
<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 2 83,019.14 7,456.53 0.00 860,181.68
<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 201.95 18.37 0.00 1,795.54
<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 286.83 30.87 0.00 1,812.71
<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 195.13 14.81 0.00 1,391.33
<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 0.00 0.00 0.00 2,383.09
<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 294.52 11.56 0.00 2,100.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 854.61 33.52 0.00 6,094.04
<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 1 68,681.59 6,268.67 0.00 858,968.44
<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 0.00 0.00 0.00 4,716.87
<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 135.40 21.10 0.00 2,187.76
<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 0.00 0.00 0.00 918,109.86
<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 564.46 78.35 0.00 4,822.49
<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 314.28 55.72 0.00 5,809.64
<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 183.36 32.54 0.00 3,390.62
<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 153.65 27.27 0.00 2,841.42
<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 153.65 27.27 0.00 2,841.42
<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 137.06 26.94 0.00 2,781.24
<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 0.00 0.00 0.00 1,579,597.27
<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 5,103.07 700.99 0.00 89,622.02
<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 148.35 21.73 0.00 2,706.12
<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 222.88 26.46 0.00 3,931.54
<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 137.42 22.10 0.00 2,622.06
<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 49.82 6.32 0.00 959.95
<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 165.00 39.94 0.00 4,150.81
<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 277.81 60.83 0.00 6,305.50
<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 386.97 82.53 0.00 8,548.01
<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 152.94 27.98 0.00 2,918.43
<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 704.28 134.48 0.00 15,465.55
<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 158.56 44.08 0.00 4,408.19
<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 4,801.92 1,015.48 0.00 119,323.09
<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 3 26,552.80 29,779.88 0.00 3,098,720.78
<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 108.59 21.65 0.00 2,716.74
<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 0.00 0.00 0.00 1,267,183.00
<br />14 6 Park s & Rec reation Copier R icoh Copier 201 6 20 20 20 1 Monthly 4,30 2.06 4,302.06 206.73 39.93 0.00 4,095.33
<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 0.00 0.00 32,5 25.00 32,525.00
<br />14 8 Cen tral Services Lanier C opier C 6502 201 6 20 20 22 2 Monthly---11,41 3.00 0.00 0.00 0.00 11,4 13.00 11,413.00
<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 0.00 0.00 3,3 39,8 30.00 3,339,830.00
<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 305.40 68.20 17,4 39.85 17,134.45
<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 366.47 51.07 10,9 23.63 10,557.16
<br />xxx
<br />T otal Cap ital L ease 24,726,32 0.80 11,343,613.84 1,1 75,708.76 61,621.59 3,4 12,1 31.48 13,580,036.56
<br />To tal Civ i l C i ty 2 86,126,24 6.30 154,661,688.26 2,7 80,708.76 522,097.09 3,4 12,1 31.48 155,293,110.98
<br />Fi nanci a l R e p or t February 2 0 1 6 - Deb t Page 2 0 o f 25
|