04/09/2002 - City Council Finance CommitteeTO: CITY COUNCIL FINANCE COMMITTEE / MEMBERS MAYOR AWADA AND
COUNCILMEMBER TILLEY
FROM: CITY ADMINISTRATOR HEDGES
DATE: APRIL 5, 2002
SUBJECT: FINANCE COMMITTEE MEETING / APRIL 9 AT 8:30 A.M.
A Finance Committee meeting has been called by Mayor Awada for Tuesday, April 9, at 8:30 a.m. at
Byerlys Restaurant, adjacent to the Caribou Coffee, for the purpose of discussing financing options to
cover the unfunded storm mitigation projects. The City has received a $5 million grant to fund a majority
of the projects, however, the total anticipated project expenses will exceed the $5 million appropriation by
the state, causing need for the City to identify a revenue source for the remaining project costs.
Attached is a copy of some work sheets that were produced for your review on the fund balance on the
storm sewer, water trunk and sanitary sewer trunk funds. Also attached is a copy of the 2002 major street
pro -forma. Please note that the cover sheet for each of these four fund balances is in ,000's dollars. In
other words, the storm sewer pro -forma has a 2002 cash balance of $2,441,000 and so forth.
Director Colbert is working diligently to get the estimated project costs for the storm mitigation projects
ready for distribution to the Finance Committee on Monday in preparation for our meeting on Tuesday.
If you have any questions, please feel free to contact this office at any time.
City Administrator
Attachments
Cc: Director of Administrative Services VanOverbeke
Director of Public Works Colbert
ms
i
�
...
*
MEMO
' city of eagan
TO: CITY COUNCIL FINANCE COMMITTEE / MEMBERS MAYOR AWADA AND
COUNCILMEMBER TILLEY
FROM: CITY ADMINISTRATOR HEDGES
DATE: APRIL 5, 2002
SUBJECT: FINANCE COMMITTEE MEETING / APRIL 9 AT 8:30 A.M.
A Finance Committee meeting has been called by Mayor Awada for Tuesday, April 9, at 8:30 a.m. at
Byerlys Restaurant, adjacent to the Caribou Coffee, for the purpose of discussing financing options to
cover the unfunded storm mitigation projects. The City has received a $5 million grant to fund a majority
of the projects, however, the total anticipated project expenses will exceed the $5 million appropriation by
the state, causing need for the City to identify a revenue source for the remaining project costs.
Attached is a copy of some work sheets that were produced for your review on the fund balance on the
storm sewer, water trunk and sanitary sewer trunk funds. Also attached is a copy of the 2002 major street
pro -forma. Please note that the cover sheet for each of these four fund balances is in ,000's dollars. In
other words, the storm sewer pro -forma has a 2002 cash balance of $2,441,000 and so forth.
Director Colbert is working diligently to get the estimated project costs for the storm mitigation projects
ready for distribution to the Finance Committee on Monday in preparation for our meeting on Tuesday.
If you have any questions, please feel free to contact this office at any time.
City Administrator
Attachments
Cc: Director of Administrative Services VanOverbeke
Director of Public Works Colbert
ms
4/4/2002 2002 PROJECTED TRANSFERS
Pro -Forma Receipts
Special Assessments
Total
Pro -Forma Disbursements
Financing of 2002 - 2006 CIP
Total
Beginning Cash Balance
Receipts
Disbursements
Ending Cash Balance PraForrna
2002 Storm Sewer Pro -Forma
In ,000's of dollars
2002 2003 2004 2005 2006 TOTAL
860 36
860 36
3,301 2,441
(860) (36)
2,441 2,405
2,405
2,405
896
896
2,405 2,405 3,301
(896)
2,405 2,405 2,405
4/4/2002
2002 PROJECTED TRANSFERS
Woodhaven Park Pond AP -1 Outlet Structure
864 Lone Oak Road Upgrade
858 Sibley Terminal Industrial Park
812 Drainage system maintenance
810 Lift station upgrades
809 Blue Gentian Road
806 Kennerick Addition
790R Central Parkway
771 Lexington Avenue Upgrade YDR to Lone Oak
759R Beau D' Rue
751 R Dodd Rd S Cliff to Butwin
709R TH 13/Blackhawk Road Signal
680 Cliff Road
Subtotal
2002 Total
Outlet of Pond GP -5 to GP -1
Storm
Trunk
50,000
72,792
632,794
104,000
859,586
36,000
2003 Total 36,000 -
Special
Assessment
Total
-
50,000
232,006
232,006
187,208
260,000
148,791
781,585
104,000
568,005 1,427,591
36,000
36,000
4/4/2002
Pro -Forma Receipts
Special Assessments
Total
Pro -Forma Disbursements
Financing of 2002 - 2006 CIP
Total
Beginning Cash Balance
Receipts
Disbursements
Ending Cash Balance Pro -Forma
2002 PROJECTED TRANSFERS
2002 Water Trunk Pro Forma
In ,000's of dollars
2002 2003 2004 2005 2006 TOTAL
156 -
93
- - 249
156 -
93
- - 249
4,396 4,240.
4,240
4,147 4,147 4,396
(156) -
(93)
- - (249)
4,240 4,240
4,147
4,147 4,147 4,147
4/4/2002
2002 PROJECTED TRANSFERS
Water Special
Trunk Assessment
809 Blue Gentian Road
19,450
Cedar Grove Redevelopment Area
- -
790R Central Parkway
74,757 55,753
751 R Dodd Rd S Cliff to Butwin
(42,101)
680 Cliff Road
103,445
Subtotal
2002 Total
155,551 55,753
2003 Total
Argenta Trail/Delaware Trail 11,500 71,000
Point 704 to Wescott Rd 62,000
Lone Oak Rd E to TH 149 19,500 245,000
2004 Total 93,000 318,000
2005 Total
2006 Total
fttm
19,450
130,510
(42,101)
103,445
211,304
82,500
62,000
264,500
409,000
4/4/2002
Pro -Forma Receipts
Special Assessments
Total
Pro -Forma Disbursements
Financing of 2002 - 2006 CIP
Total
Beginning Cash Balance
Receipts
Disbursements
Ending Cash Balance Pro -Forma
2002 PROJECTED TRANSFERS
2002 Sanitary Sewer Trunk Sewer Pro -Forma
In ,000's of dollars
2002 2003 2004 2008 2006 TOTAL
(80) - - - - (80)
(80) - - - (80)
7,183 7,263 7,263 7,263 7,263 7,183
80 - - - - 80
7,263 7,263 7,263 7,263 7,263 7,263
4/4/2002 2002 PROJECTED TRANSFERS
Sanitary
Sewer Spectai
Trunk Assessment Total
751 R Dodd Rd S Cliff to Butwin (80,416) (80,416)
Subtotal -
2002 Total (80,416) (80,416)
2003 Total - - -
2004 Total • -
2005 Total - - -
-
2006 Total - -
3/8/2002
1
2002 Major Street Pro -Forma
in ,000's of dollars
2002
2003
2004
2005
2006
TOTAL
Pro -Forma Receipts
Property Taxes
1,050
1,050
1,050
1,050
1,050
5,250
Development Agreements
15
14
13
-
-
42
Municipal State Aid - Construction
1,563
1,563
1,563
1,563
1,563
7,815
Municipal State Nd - Maintenance
52
52
52
52
52
260
Total
2,680
2,679
2,678
2,665
2,665
13,367
Pro -Forma Disbursements
Maintenance Transfer to General Fund
Financing of 2002.2006 CIP
69
18,066
69(�
2,342
69
69
'c'\
69 $
Q
345
6,184
8,913
3,024
38,530
Project 800 Cedarvale Access
7,720
7,720
Project 759R Beau D' Rue Reconstruction
1,349
1,349
Total
D a 27,204
2,411
6,253
6,982
3,093
47,944
Beginning Cash Balance
20,004
(4,521)
(4,253)
(7,829)
(14,146)
19,879
Receipts
2,680
2,679
2,678
2,665
2,665
13,367
Disbursements
(27,204)
(2,411)
(6,253)
(8,982)
(3,093)
(47,944)
Ending Cash Balance Pro -Forma
(4,521)
(4,253)
(7,829)
(14,146)
(14,574)
(14,698)
1
3/8/2002
680 Cliff Road
707 Traffic Signal Lone Oak 149
708 Wescott & Pilot Knob Rd
709R Hwy 13 Silver Bell to Yankee Doodle
710 Slater Rd Sidewalk
710B Slater Rd Sidewalk
736 AUAR Study
75OR Hwy 55 West Segment
761 R Dodd Road Cliff Rd to Butwin
764R SelMark, Burrview Acres, Harvey
766 Wescott Lexington Signal
770 Denmark Avenue
771 Lexington Avenue City Lead Agency
776 Yankee Doodle Road Extension
777 Blackhawk Road Ashbury Traffic Calming
785 City Sidewalk
79OR & 768 Central Parkway(790) & Northwood Parkwa
794 River Hills 9th Reconstruction
795 Beacon Hill, Brittany's Johnny Cake Ridge
796 Cedar Cliff 1st 3rd and Mari Acres
801 Silver Bell Road Overlay
802 Pilot Knob Road
807 Trail along Dodd-Diffley to Wescott
809 Blue Gentian Rd
814 Johnny Cake & Diffley Signal
850 Dodd Road Diffley to Ethan
851 Town Centre, Denmark, Duckwood Street & Trail
852 Post, Rustic Hills, & Oster A'ddn Overlay
853 Woodgatelst Overlay
854 Parkcliff 1st -3rd Overlay
855 Oak Chase 6th Chas Mar East Overlay
866 Chas Mar Street Overlay
857 Skyline Road Trail
859 TH 55, Blue Gentian Lexington Intersection
860 TH 55 Blue Water Rd Intersection
8612002 Citywide Trails
862 Dodd Road Ethan to Wescott
864 Lone Oak Road- Hiway 13 -Pilot Knob
865 AUAR Cedar Grove Redevelopment
867 Master Streetscape & Monuments
Subtotal
Maintenance transfer to General Fund
759R Beau D' Rue Dr
800 Cedarvale Access Modifications"
866 Streetscape Now included in Project 800 above
Total
MAJOR
BEET
1,627,507
56,977
1,032,920
45,874
117,725
83,092
1,625,000
120,400
662,461
2,769,795
2,092,555
439,518
1,886,082
113,080
486,814
169,140
142,500
483,305
497,644
97,600
631,800
56,480
66,800
105,192
130,689
127,526
7,850
204,170
2,186,000
0
18,066,496
69,000
1,349,200
7,719,560
0
27,204,256
Includes $500,000 for streetscaping, part of which is beyond
the scope c' gect 800.
0
SPECIAL
ASSESSMENT
197,180
104,670
558,000
166,000
454,900
362,645
1,796,673
131,120
222,886
104,140
76,100
477,206
24,000
32,730
30,900
43,508
62,111
64,364
3,370
114,000
TOTAL
1,824,687
56,977
1,137,590
45,874
117,725
83,092
2,183,000
288,400
662,481
3,224,695
2,455,200
439,518
3,682,755 Includes $931,050 assess CA
244,200
709,700
273,280
217,600
483,305
974,850
97,600
655,800
89,210
97,700
148,700
192,800
191,890
11,220
204,170
2,300,000
0
5,351,033 30,295,999
69,000
337,300 1,686,500 $500,000 to bury overhead u
1,929,890 9;649,450 Reimburse 100% by devel a(
41,701,949
A
3/8/2002
3
2002 Major Street Pro -Forma
in ,000's of dollars
2002
2003
2004
2005
2006
TOTAL
Pro -Forma Receipts
Property Taxes
1,050
1,050
1,050
11050
11050
5,250
Development Agreements
15
14
1342
Municipal State Aid - Construction
1,563
1,563
1,563
1,563
56
1,3
7,815
Municipal State Aid - Maintenance
52
52
52
52
52
260
Total
2,660
2,679
2,678
2,665
2,665
13,367
Pro -Forma Disbursements
Financing of 2002tenance {-r to 2006 Ctpral Fund
lj
Q �O
n
� `
p
` �
345
18 066
2 342 �
6 184
8,9613
3,024
38,530
Total
18,135
2,411
6,253
8,982
3,093
36,875
Beginning Cash Balance
20,004
4,548
4,816
1,240
(5,077)
19,879
Receipts
2,680
2,679
2,678
2,665
2,665
13,367
Disbursements
(18,135)
(2,411)
(6,253)
(8,982)
(3,093)
(38,875)
Ending Cash Balance Pro -Forma
4,548
4,816
1,240
(5,077)
(5,505)
(5,629)
3
3/8/2002
MAJOR
SPECIAL
STREET
ASSESSMENT
TOTAL
680 Cliff Road
1,627,507
197,180
1,824,687
707 Traffic Signal Lone Oak 149
-
708 Wescott & Pilot Knob Rd
56,977
-
56,977
709R Hwy 13 Silver Bell to Yankee Doodle
1,032,920
104,670
1,137,590
710 Slater Rd Sidewalk
45,874
45,874
710B Slater Rd Sidewalk
117,725
117,725
736 AUAR Study
83,092
83,092
750R Hwy 55 West Segment
-
-
-
751R Dodd Road Cliff Rd to Butwin
1,625,000
558,000
2,183,000
764R SelMark, Burrview Acres, Harvey
120,400
166,000
286,400
766 Wescott Lexington Signal
662,461
662,461
770 Denmark Avenue
-
-
771 Lexington Avenue City Lead Agency
2,769,795
454,900
3,224,695
776 Yankee Doodle Road Extension
2,092,555
362,645
2,455,200
777 Biackhawk Road Ashbury Traffic Calming
-
785 City Sidewalk
439,518
439,518
790R & 768 Central Parkway(790) & Northwood Parkw,
1,886,082
1,796,673
3,682,755
794 River Hills 9th Reconstruction
113,080
131,120
244,200
795 Beacon Hill, Brittany's Johnny Cake Ridge
486,814
222,886
709,700.
796 Cedar Cliff 1st 3rd and Mari Acres
169,140
104,140
273,280
801 Silver Bell Road Overlay
142,500
75,100
217,600
802 Pilot Knob Road
483,305
483,305
807 Trail along Dodd-Diffley to Wescott
-
-
809 Blue Gentian Rd
497,644
477,206
974,850
814 Johnny Cake & Diffley Signal
97,600
97,600
850 Dodd Road Diffley to Ethan
631,800
24,000
655,800
851 Town Centre, Denmark, Duckwood Street & Trail
-
-
-
852 Post, Rustic Hills, & Oster A'ddn Overlay
56,480
32,730
89,210
853 WoodgateIst Overlay
66,800
30,900
97,700
854 Parkcliff 1st -3rd Overlay
105,192
43,508
148,700
855 Oak Chase 6th Ches Mar East Overlay
130,689
62,111
192,800
856 Chas Mar Street Overlay
127,526
64,364
191,890
857 Skyline Road Trail
7,850
3,370
11,220
859 TH 55, Blue Gentian Lexington Intersection
-
860 TH 55 /Blue Water Rd Intersection
-
861 2002 Citywide Trails
204,170
204,170
862 Dodd Road Ethan to Wescott
2,186,000
114,000
2,300,000
864 Lone Oak Road- Hiway 13 -Pilot Knob
-
865 AUAR :,edar Grove Redevelopment
-
867 Master Streetscape & Monuments
0
0
-
Subtotal
18,066,496
5,351,033
30,296,999
Maintenance transfer to General Fund
69,000
69,000
Total
18,135,496
30,365,999
3/8/2002
Approved CIP
5
MAJOR
SPECIAL
Year Roadway
TREET
ASSESSMENT
TOTAL
2003 Deerwood Drive overlay
21,000
64,000
85,000
2003 Slater Road Cliff to Storland
162,000
28,000
190,000
2003 Lone Oak Road TH13-Pilot knob Road Now 864
451,000
80,000
531,000
2003 Yankee Doodle Road Hwy 149 to IGH Now 776
_
2003 Wilderness Park 2nd & 3rd
139,360
65,000
204,360
2003 Whispering Woods &. Slaters Acres
61,218
63,538
124,756
2003 Avalon & Burnside Ave
66,760
90,000
156,760
2003 Lexington Place & Lexington Place South
278,000
150,000
428,000
2003 Drexel Heights
64,680
30,000
94,680
2003 Town Centre, Denmark, Duckwood Street &'Trail
97,000
362,000
459,000
2003 Northview Park Road (Braddock Tr-Elrene Rd)
46,530
46,530
2003 Elrene Rd (Wescott Rd.- Dodd Rd)
46,420
46,420
2003 Elrene Rd (Wescott Rd: Yankee Doodle Rd)
58,190
58,190
2003 Nicola Rd (Glory Dr -Beau D'Rue Dr)
42,020
42,020
2003 Nicols Rd (Erin Or - Shale Lane)
22,000
22,000
2003 Diffley Rd (Rahn Rd-Blackhawk Rd)
30,360
30,360
2003 Yankee Doodle Rd (TH-149 - IGH) Now In Pro) 776
_
2003 Lone Oak Rd (TH-13 - Pine Ridge Dr)
34,000
34,000
2003 Seal Coat
185,227
185,227
2003 Signal Lights
114,000
114,000
2003 Curb and gutter
422,567
422,567
2,342,332
932,538
3,274,870
5
3/8/2002 Approved CIP
MAJOR
SPECIAL
Year Roadway
STREET
ASSESSMENT
OTAL
2004 Yankee Doodle TH13 to Federal
1,487,000
1,487,000
2004 HWY 149(hwy 55 to Wescott)
1,400,000
1,400,000
2004 Galaxle Ave Cliff to Berkshire
105,000
15,000
120,000
2004 Four Oaks Rd (TH-13 to Coachman RD)
26,000
41,000
67,000
2004 Silver Bell Rd (Kennebec to Nicols)
20,000
80,000
100,000
2004 Covington Lane (Johnny Cake to Galaxie)
115,000
20,000
135,000
2004 Alexander Road
42,960
42,960
2004 Terminal Dr/Yankee Dr
211,920
211,920
2004 Meadowview Road
110,000
110,000
2004 Coachman Land Co 1st to 3rd
38,880
18,000
56,880
2004 Donald CVCentury Pt
17,400
20,000
37,400
2004 Blackhawk Rd (Kennebec-TH-13)
24,120
24,120
2004 Briar Hill 1st -4th
23,040
11,000
34,040
2004 Rahn Road (Cedarvale Blvd-Beau-d'Rue)
13,400
13,000
26,400
2004 Coachman Rd (YDR to St Charles Place)
7,400
45,000
52,400
2004 Thomas Lake Hghts 1 st & 2nd
115,240
55,000
170,240
2004 take Park Shores & Thomas Lake Addns
59,000
30,000
89,000
2004 Lakeside Estates
91,760
40,000
131,760
2004 Sheffield Addn (Sudberry Lane)
29,868
29,867
59,735
2004 Ridgecliffe 1-6 and Park Ridge 1-2 Addn
276,881
276,881
553,762
2004 St Francis Woods 1,2,3,&5
87,920
40,000
127,920
2004 TH-55 (Lone Oak Road-TH-149)
20,400
20,400
2004 TH-149 (Wescott Rd- TH-55 Frontage Rd)
329,460
329,460
2004 Blackhawk Rd (Cliff Rd - Diffley)
50,820
50,820
2004 Blackhawk Rd (Dlffley-Deerwood Dr)
41,030
41,030
2004 Blackhawk Rd (35E- Diftley)
119,000
119,000
2004 Deerwood Dr(Riverton Ave -Pilot Knob Rd)
57,640
57,640
2004 High Line Trail (Johnny Cake Ridge -Thomas Lake Rd)
31,790
31,790
2004 YankeeDoodle Rd (TH-13 - Federal Dr)
170,000
170,000
2004 Lone Oak Rd (TH-55 - IGH)
173,740
173,740
2004 Seal Coat
189,463
189,463
2004 Signal Light
369,000
369,000
2004 Curb and gutter
718,211
718,211
6,184,343
1,123,748
7,308,091
3/8/2002
Approved CIP
MAJOR
SPECIAL
Year Roadway
ETREET
ASSESSMENT
TOTAL
2005 Northwood Parkway Upgrade to 3 lane & Bridge
4,066,000
4,066,000
2005 Rahn Road
45,000
45,000
2005 Yankee Doodle (Promenade to Lexington)
500,000
500,000
2005 Lone Oak Road (TH-55 to IGH)
1,665,000
85,000
1,750,000
2005 Windcrest Addn
61,259
61,259
122,518
2005 Cedar Grove 1& 2
438,183
490,183
928,366
2005 Cinnamon Ridge 1-7 Addn
93,988
128,868
222,856
2005 Peaceful Heights (Glory Dr)
6,994
20,982
27,976
2005 Cedar Ridge 1& 2, (Cedar Ridge Circle)
-
31,412
31,412
2005 Eden Addition
71,100
74,300
145,400
2005 Thomas Center Dr
77,973
77,973
2005 Suncliff 1-5 Addn
179,137
183,137
362,274
2005 Glen Ponds/Marice
22,115
50,000
72,115
2005 Walden Heights 1st, Twin View Manor 1&2,Hlllcrest
138,418
150,258
288,676
2005 Meadowland 1st -Beaver Dam Road
81,000
40,000
121,000
2005 Safari Addition
106,740
106,740
213,480
2005 Johnny Cake Ridge Road (Cliff- Diffiey)
61,600
61,600
2005 Johnny Cake Ridge Road (Apple Valley - Cliff)
115,390
115,390
2005 Wilderness Run Road (Lexington -Dodd Rd)
72,380
72,380
2005 D1ffley Rd( Braddock Tr -Dodd Rd)
73,370
73,370
2005 Northwood Parkway (Marice Dr -Denmark Ave)
68,950
68,950
2005 Seal Coat
153,769
153,769
2005 Signal
95,000
95,000
2005 Curb and Gutter
797,714
797,714
8,913,107
1,500,112
10,413,219
3/8/2002
Approved CIP
MAJOR
SPECIAL
X2 -8r Roadway
STREET
ASSESSMENT
TOTAL
2006 Federal Dr (Yankkee Doodle to Violet)
112,000
30,000
142,000
2006 Dodd Road (Diffley to Wescott)
125,000
15,000
140,000
2006 Ashbury Road (Blue Cross to Blackhawk Hills)
64,000
130,000
194,000
2006 Blackhawk Hills Rd (Ashbury to Federal)
48,000
19,000
67,000
2006 Bicentennial 1-8 Additions
38,260
114,780
153,040
2006 Robin Lane
59,199
59,199
118,398
2006 Blackhawk Oaks (Riverton Ave)
34,432
34,432
68,864
2006 Hillandale 1-3 Addn's (Meadowlark South)
36,340
36,340
72,680
2006 Art Rahn (Kathryn Cir)
16,361
16,361
32,722
2006 Towerview Rd (West of Pilot Knob)
52,680
52,680
2006 Killdeer Addition (Joyce Ct)
12,900
12,900
25,800
2006 Saddlehom/Sunset Addn's
326,640
325,440
652,080
2006 Lexington Square
346,000
346,000
692,000
2006 WestburyAddn
133,700
134,100
267,800
2006 Hampton Heights
109,580
109,580
219,160
2006 Pilot Knob Rd (Duckwood Dr- Yankee Doodle Rd)
15,620
15,620
2006 Diffley Rd(BlackHawk Rd -35E Northbound Ramp)
19,030
19,030
2006 Diffley Rd (35E Northbound Ramp - Pilot Knob)
122,210
122,210
2006 Pilot Knob Rd (Duckwood Dr- Diffley)
178,970
178,970
2006 Cliff Rd (Johnny Cake - Lake Park Dr)
85,030
85,030
2006 Cliff Rd (Thomas Ln - Lake Park Dr)
3,960
3,960
2006 Cliff Rd (Lenore Ln -Johnny Cake)
18,590
18,590
2006 Seal Coat
153,711
153,711
2006 Signal
95,000
95,000
2006 Curb and Gutter
869,467
869,467
3,024,000
1,435,812
4,459,812