HomeMy WebLinkAbout7. E. 1. Debt Overview General Business 7, E. 1.
SHM(OPEE
TO: Mayor and City Council
Mark McNeill,City Administrator
FROM: Lori Hensen,Deputy City Clerk
DATE: 07/22/2014
SUBJECT: Debt Overview(F)
Action Sought
Council is provided with a detail of the existing debt service issues that will be discussed Tuesday evening.
Attachments: Debt Service Funds
CITY OF SHAKOPEE,MINNESOTA
2015 ANNUAL BUDGET
DEBT SERVICE FUNDS
2004B 2004C 2004D 2006A
Bldg Ref Improve Bldg Improve
3035 3036 3037 3038
Original Issuance 2,275,000 2,570,000 6,000,000 3,440,000
Maturity Date of Debt 2/1/2017 2/1/2015 2/1/2025 2/1/2017
Estimated Cash Balance at 12/31/14 274,518 391,537 143,794 144,810
Estimated Deferred Revenue for SA 12/31/14 - 148,308 - 63,602
Estimated(Current&Future)Available Funds 274,518 539,845 143,794 208,412
Principal Payments Remaining 660,000 260,000 3,865,000 1,110,000
Interest Remaining 40,563 5,200 969,386 66,200
Levy 2013 Collected 2014
Debt Levy Per Debt Issuance 253,706 141,855 468,150 343,959
Debt Levy Cancellation 78,706 141,855 468,150 -
Staff Recommendation for 2013 Levy 175,000 - - 343,959
General Fund Levy-Through Building Rent - - 468,150 -
Levy 2014 Collected 2015
Debt Levy Per Debt Issuance 249,926 - 466,680 343,215
Debt Levy Cancellation - 466,680 -
Staff Recommendation for 2014 Levy 249,926 - - 343,215
General Fund Levy-Through Building Rent - - 466,680 -
Levy 2015 Collected 2016
Debt Levy Per Debt Issuance 245,936 - 464,790 345,140
2007A 2007B 2008A 2010A 2012A
Improve Improve Improve Improve Refunding Total
3039 3040 3041 3042 3043
1,370,000 1,445,000 2,170,000 1,555,000 4,865,000 29,915,000
2/1/2017 2/1/2018 2/1/2019 2/1/2021 2/1/2025
232,647 85,882 230,217 625,987 395,044 2,524,436
346,111 25,201 248,152 131,385 103,781 1,066,540
578,758 111,083 478,369 757,372 498,825 3,590,976
460,000 610,000 1,035,000 965,000 4,865,000 13,830,000
27,400 61,400 125,300 88,685 564,563 1,948,696
8,125 94,362 150,741 144,728 317,494 1,923,120
8,125 94,362 150,741 144,728 317,494 1,404,161
- --
-
518,959
-
- - - 468,150
10,145 92,052 147,084 108,492 560,936 1,978,530
10,145 - 147,084 108,492 560,936 1,293,337
92,052 - - - 685,193
-
- - - 466,680
6,916 94,991 153,402 108,067 559,178 1,978,420
in
a) >; z3 N
00 o -.71- ;v) a
a N C h ' c C) °? c N a a
No s-cil = = 3 ., .?., = ° = a o Q o 0
w o o �, o -o Q o > o3Uo N
A � '° � -c >, O tea, � � � �
• ' 3 `,•`0 0 ad o ado) ° 0 c o 0 co a) `a o a-i o cn 4-) •!--",' N ' N d- 00 N a L1i W N f=4 Ri U., > ' .'
.4. cd
'6 A N in N N 00 01 --+ in
R 4* ,-, •-, r-- r- N N
S cy CC N N N N N N NN N >
A a
ctl
CI) N Lf 00 N .O 00 00 M Vl
.--i N cn v) -Q N N y
..1
H - N Q N - 0 O
W `"" v ° 0\ o
A �,�' N l
W ,•a i.
o �°
ci) cn
vn a
: 0
0
E
c:4
LC b4
0
b
W N
N
d,
O rn fs.
O 0 a)
CV a) < N 00 0 p
tip 715,
y^, co) O O co, O vi 4�
•C!) N N co co N co
'd P.
d a) a) a) a) a) . 0
N N N N ¢,
0 O C/) CI) Cl) Cl) C/) C/) 0 ',.
CC Pel vi vi vi vi cl ct -0) '0
0 0 0 0 0 0 a) W
= P+ b4
5 C 4- -1-' Cd Cd Q 5 C
Q > > > > > > > PA
.0
0
-Q. G. O. O. p. Q. Q.
O O O O O O O O
C7 C7 C7 C7 C7 L7 t7 C7 H