HomeMy WebLinkAbout2A, CIP Financial Summary ,-ARZEN HILLS
Request for Council Action 2A
Prepared By: Sue Iverson,Director of Finance and work Session Date: July 9,2012
Administrative Services
CIP Financial Summary
Budgeted Amount: Actual Amount: Funding Source:
N/A N/A N/A
Discussion Topic:
Staff would like to have a discussion with Council regarding the beginning balance numbers and long-
range goals and plans for the use of the reserve funds.
Supporting Documents:
1. Memorandum dated July 9,2012,from Patrick Klaers, City Administrator.
2. June 22,2012,memo from Sue Iverson,Director of Finance and Administrative Services.
3. Source and Use of Funds CIP pages.
EN HILLS
MEMORANDUM
DATE: July 9,2012
TO: Honorable Mayor and City Councilmembers
FROM: Patrick Klaers, City Administrator
SUBJECT: CIP Financial Statement
Background
At the end of the June 15, 2012, Capital Improvement Program (CIP) work session, the
Council discussed the last section of the CIP booklet. This section titled "Source and Use
of Funds" was on blue paper. The main issues raised during this discussion were
questions about the beginning balance amount for the Enterprise Funds, and an overall
concern about the status of the fund balances for all of the Funds in 2017.
Sue Iverson, Director of Finance and Administrative Services, missed the June 15th work
session. On June 22nd, Sue sent out updated Source and Use of Funds pages and a memo
that explained the changes she made in the fund balances. It should be noted that Sue
updated all of the beginning fund balances and did not just correct the beginning balances
for the Enterprise Funds. This material is again attached for your review.
In the attached_June 22nd memo from Sue, she stated that a few assumptions were put into
some of the beginning balance numbers and these assumptions need a review by the
Council. This review is one of the reasons for this work session agenda item. Another
reason for this work session agenda item is to discuss some long-range goals and plans
for the use of the CIP funds. On June 15th the Council raised concerns about spending
too'much money on projects and equipment at too fast of a pace without knowing the
source of adequate revenues. This discussion on City projects and priorities needs to take
place so that staff can receive direction on how to best provide the Council with options
and recommendations annually for the 5-year CIP. This discussion will tie in directly to
the Pavement Management Program agenda item that is also scheduled for this work
session.
Since the attached CIP pages were updated, a couple of additional adjustments have been
identified but have not yet been made. These corrections have come to light during staff
City Council Meeting
P:\Admin\Council\Agendas&Packet Information\2012\07-09-12 Wk Sess\Packet\CIP 2.doc
Page 1 of 2
meetings on the proposed 2013 operating budget. These adjustments are more minor in
nature and Sue will present information on the changes at the work session. (The
corrections would have been made but I just recently moved this agenda item from the
July 16`h work session to the July 9th special work session and Sue is out of the office
enjoying some PTO over the 4th of July Holiday.)
City Council Meeting
P:\Admin\Council\Agendas.&Packet Information\2012\07-09-12 Wk Sess\Packet\CIP 2.doc
Page 2 of 2
,- RIQEN�HILLS
MEMORANDUM
DATE: June 22,2012
TO: Honorable Mayor and City Council Members
Patrick Klaers, City Administrator
FROM: Sue Iverson, Director of Finance and Administrative Services
SUBJECT: 2013 — 2017 Capital Improvement Plan (CIP) Estimated Fund
Balances
At last Monday's worksession, an incorrect copy of the "Sources and Uses of Funds"
(Blue Sheets) were included in your book. Attached is a corrected copy of this report. I
apologize for not being at the meeting and the confusion, as I instructed Kyle to put in the
fund balances and estimates for operating revenues and expenditures, but did not instruct
him to use "cash" balances for the enterprise funds (Water, Sewer, and Surface Water
Management). Governmental funds carry only "current resources" so their balances are
primarily "cash balances". Enterprise funds are "full accrual" accounting, so they carry
all costs including "fixed assets" and depreciation. This means that the fund balances
that were reflected in the report were incorrect for the all of the enterprise funds as the
balances included all assets, not just cash.
I have run preliminary numbers and estimates, but they are just rough estimates at this
time as we have not gone through the entire budget process yet. The numbers calculated
for the beginning balances for 2013 are actual 2011 balances with the 2012 budget
estimates for revenues and expenditures included.
There are a few assumptions that I have built into these numbers that we will talk with
the council about at the July worksession. One of these includes a transfer of$188,893
from the PIR fund to the Park fund to cover the remaining expenditures from the Safe
Routes to School and Elmer L. Anderson trail project. While we used Park dedication
fees and grants, there remains costs that we need to cover from the PIR fund. Another
was a transfer from the General fund to the EDA Operating fund of$124,955. This is the
transfer of the Presbyterian Homes Conduit Debt Fee that we have talked about in the
past, but have not officially decided to transfer yet.
The deficit in the Equipment, Building & Replacement fund will be addressed by
transfers built into the operating budget and will recover, but these transfer amounts will
be addressed during the budgeting process and will change as we analyze the actual
City Council Meeting
P:\Finance\Finance Director\2013 Budget\CIP\2013 CIP Preliminary-Follow-up Memo.docx
Page 1 of 2
equipment and usage by department—a more clear picture of this fund will be seen in fall
after we have completed the operating budgets.
The EDA Operating fund receives excess increment from the County as a result of the
Round Lake TIF District. This will discontinue in 2015 when the district decertifies. In
2011, a tax petition on some properties in the district was settled and the amount of TIF
received was reduced as well as the excess TIF received. I will have a better picture of
these numbers once I receive the first tax settlement from the county for 2012 which will
come in July. Both of these funds will have better estimates later in the year, although an
ongoing funding source for EDA revenues will be another discussion that staff will have
with the Council at a later date.
The water and sewer funds are cash flowing as expected with the 2008 rate study that was
implemented in 2009. You can see this by looking at the cash balances in this report.
The low points in 2014 (Sewer) and 2015 (Water) were expected and were the basis for
the increase in rates when we choose to implement these rates. Surface Water
Management needs to be looked at, as we have continuing deficits in this fund starting in
2013. Finance is working on a rate study with the assistance of FPAC and will bring this
forward to the City Council for discussion at a later date.
Staff will have a discussion with Council at the July worksession on the attached report.
Please remember that these are very preliminary estimates as we just finished the audit
and financial reports and are just starting the 2013 budgeting process which leads to the
long-term financial plan.
I have attached some graphs on the actual historical fund balances of the General Fund,
PIR Fund, and the utility funds from 2006—2011. The two spikes you see in the General
Fund are the year we settled mediation on City Hall and 2011 with the Presbyterian
Homes conduit debt and Pulte and Presbyterian Homes permit activity. The utility fund
balances have been recovering since we implemented the 2008 rate study.
If you have any questions,please feel free to call me and discuss them.
City Council Meeting
P:\Finance\Finance Director\2013 Budget\CIP\2013 CIP Preliminary-Follow-up Memo.docx
Page 2 of 2
City of Arden Hills, Minnesota
Capital.Improvement Plan
2013 thru 2017
SOURCES AND USES OF FUNDS
Source 2013 2014 2015 2016 2017 Total
Capital Improvement Funds (PIR)
Beginning Balance 6,073,457 5,076,835 3,462,835 1,864,335 2,034,335
Revenues and Other Fund Sources
Revenue
Interest Income 135,000 135,000 135,000 135,000 135,000
Estimated Rev from Assessments 400,000 400,000 400,000 400,000 400,000
Total 535,000 535,000 535,000 535,000 535,000
Other Fund Sources
Transfer from General Fund 200,000 200,000 200,000 200,000 200,000
Total 200,000 200,000 200,000 200,000 200,000
Total Revenues and Other Fund Sources 735,000 735,000 735,000 735,000 735,000
Total Funds Available 6,808,457 5,811,835 4,197,835 2,599,335 2,769,335
Expenditures and Uses
Capital Projects&Equipment
Equipment
Replace 2001 Used Dump Truck with Used Dump 15-EgpV-000 0 0 (40,000) 0 0
Large Area Mower 16-Eqp-001 0 0 (70,000) 0 0
Purchase Mini-Excavator 16-Eqp-002 0 0 0 (45,000) 0
Replace Air Compressor 16-Eqp-004 0 0 0 (25,000) 0
Replace One-Ton Truck 16-EgpV-005 0 0 0 (42,000) 0
Total 0 0 (110,000) (112,000) 0
Parks Department
Mounds View HS Trail Connection 11-Park-001 0 0 (40,000) 0 0
Playground Structure Replacement 11-Park-003 0 0 0 (70,000) (70,000)
Forestry Implementation Plan 11-Park-004 (10,000) (10,000) (10,000) (5,000) (5,000)
Park Amenities 11-Park-005 (3,000) (3,000) (3,000) (3,000) (3,000)
Trail Rehabilitation 12-Park-002 (50,000) (50,000) (50,000) (50,000) (50,000)
Valentine Park Pathway 13-Park-012 (167,622) 0 0 0 0
Off Leash Dog Area 13-park-013 (7,500) 0 0 0 0
Perry#3 Fencing 14-Park-009 0 (20,500) 0 0 0
Total (238,122) (83,500) (103,000) (128,000) (128,000)
Street Department
Regulatory Street Sign Replacement Program 11-Str-001 (5,000) (5,000) (15,000) (10,000) 0
Highway 96(Old Highway 8 to US Highway 10) 11-Str-055 (415,000) 0 0 0 0
Produced Using the Plan-It Capital Planning Sof fare Thursday,June 21,2012
Source 2013 2014 2015 2016 2017 Total
Capital Improvement Funds (PIR)
Co Rd E Impr between Hwy 51&Lexington Ave 12-Str-060 (145,000) (1,538,000) 0 0 0
2013 PMP Mill and Overlay(Removed tjm) 13-StrM-062 0 0 0 0 (40,000)
2013 Crack Fill and Seal Coat 13-StrS-XXX (140,000) 0 0 0 0
Co.Rd.E Bridge over TH 51 14-Str-061 0 (150,000) 0 0 0
1-694ITH 10 Landscaping 14-Str-062 0 (5,000) 0 0 0
Ridgewood Asbury--2013 PMP 14-Str-064 (788,500) (55,500) 0 0 0
2014 Crackseal and Sealcoat 14-StrS-063 0 (145,000) 0 0 0
2015 Crack Fill and Seal Coat 15-StrS-XXX 0 0 (145,000) 0 0
Indian Oaks PMP--2017 PMP 16-Str-065 0 0 0 (42,500) (1,294,500)
2016 Crackseal and Sealcoat 16-StrS-066 0 0 0 (150,000) 0
Glenview Neighborhood--2015 PMP 17-Str-039 0 (367,000) (1,960,500) (122,500) 0
2017 Crackseal and Sealcot 17-Str-XXX 0 0 0 0 (150,000)
Total (1,493,500) (2,265,500) (2,120,500) (325,000) (1,484,500)
Total Expenditures and Uses (1,731,622) (2,349,000) (2,333,500) (565,000) (1,612,500)
Change in Fund Balance (996,622) (1,614,000) (1,598,500) 170,000 (877,500)
Ending Balance 5,076,835 3,462,835 1,864,335 2,034,335 1,156,835
Produced Using the Plan-It Capital Planning Softivare Thursday,June 21,2012
Source 2013 2014 2015 2016 2017 Total
EDA Revenues
Beginning Balance 140,450 56,371 (29,698) (92,817) (165,297)
Revenues and Other Fund Sources
Revenue
Excess Tax Revenue 32,250 32,250 32,250 0 0
Total 32,250 32,250 32,250 0 0
Total Revenues and Other Fund Sources 32,250 32,250 32,250 0 0
Total Funds Available 172,700 88,621 2,552 (92,817) (165,297)
Expenditures and Uses
Capital Projects&Equipment
Economic Development
Gateway Signs 16-EDA-001 (50,000) (50,000) (25,000) 0 0
Total (50,000) (50,000) (25,000) 0 0
Other Uses
Operating Expenditures (66,329) (68,319) (70,369) (72,480) (74,655)
Total (66,329) (68,319) (70,369) (72,480) (74,655)
Total Expenditures and Uses (116,329) (118,319) (95,369) (72,480) (74,655)
Change in Fund Balance (84,079) (86,069) (63,119) (72,480) (74,655)
Ending Balance 56,371 (29,698) (92,817) (165,297) (239,952)
Produced Using the Plan-It Capital Planning Softivare Thursday,June 21,2012
Source 2013 2014 2015 2016 2017 Total
Equipment/Building Replacement
Beginning Balance (558,928) (879,928) (981,928) (999,928) (1,145,928)
Revenues and Other Fund Sources
Revenue
Interest Income 0 0 0 0 0
Total 0 0 0 0 0
Other Fund Sources
Transfer from Surface Water Fund 38,000 38,000 38,000 38,000 36,000
Transfer from General Fund 40,000 40,000 40,000 40,000 40,000
Transfer from Sanitary Sewer Fund 62,000 62,000 62,000 62,000 62,000
Transfer from Water Fund 43,000 43,000 43,000 43,000 43,000
Total 183,000 183,000 183,000 183,000 183,000
Total Revenues and Other Fund Sources 183,000 183,000 183,000 183,000 183,000
Total Funds Available (375,928) (696,928) (798,928) (816,928) (962,928)
Expenditures and Uses
Capital Projects&Equipment
Equipment
New Dump Truck w/Plow/Wing/Sander 10-EgpV-005 0 0 0 (150,000) 0
Replace Jetter and Vactor Truck with Combo Machi 11-EgpV-004 (300,000) 0 0 0 0
Brush Chipper 12-Eqp-001 0 (26,500) 0 0 0
Replace J Type Tamper 12-Eqp-005 0 0 0 (5,000) 0
Replace 1996 Roller 12-Eqp-006 0 (10,000) 0 0 0
Replace 1997 Dump Truck w/Plow/Wing Plow/San 12-EgpV-002 0 (140,000) 0 0 0
Replace 1993 Toro Turf Aerator 13-Eqp-001 0 0 0 (10,000) 0
Replace 2002 Groundsmaster with Snow Blower 13-Eqp-003 0 (35,500) 0 0 0
Replace 1997 Street Sweeper 13-Eqp-004 0 0 (188,000) 0 0
Replace 2001 F450 One Ton Dump/Plow/Sander 13-EgpV-002 (56,000) 0 0 0 0
Replace Trailer 13-EgpV-010 (10,000) 0 0 0 0
Replace 2002 F450 One-Ton w/Dump/Plow/Sande 14-EgpV-001 0 (60,000) 0 0 0
Replace Turf Sweeper 14-EgpV-005 0 0 0 (18,000) 0
Replace Pick up Truck#201 14-EgpV-010 0 0 0 (35,000) 0
Replace 2000 Backhoe 15-Eqp-003 (100,000) 0 0 0 0
Replace 2004(Unit 112)Hotbox 16-Egp_XXX 0 0 0 (18,000) 0
1996 Trailer Replacement(Skidsteer/Roller) 16-Eqp-003 0 0 0 (10,000) 0
Replace 2001 Workman(Unit 411) 16-Eqp-XX 0 0 0 (24,000) 0
Replace two 2011 Toro Z Mowers 17-Egp_XXX 0 0 0 0 (24,000)
Replace 2005 4-Door Diesel Pickup 17-EgpV-XXX 0 0 0 (46,000) 0
Total (466,000) (272,000) (188,000) (316,000) (24,000)
Technology
Springbrook Software Upgrades 12-Tec-001 (13,000) 0 0 0 0
Technology and Office Equipment 12-Tec-002 (15,000) (13,000) (13,000) (13,000) (13,000)
Plotter 13-Tec-001 (10,000) 0 0 0 0
Produced Using the Plan-It Capital Planning Sofhvare Thursday,June 21,2012
Source 2013 2014 2015 2016 2017 Total
EquipmentBuilding Replacement
Total (38,000) (13,000) (13,000) (13,000) (13,000)
Total Expenditures and Uses (504,000) (285,000) (201,000) (329,000) (37,000)
Change in Fund Balance (321,000) (102,000) (18,000) (146,000) 146,000
Ending Balance (879,928) (981,928) (999,928) (1,145,928) (999,928)
Source 2013 2014 2015 2016 2017 Total
Grant Revenue
Beginning Balance 0 0 0 0 0
Revenues and Other Fund Sources
Revenue
Grant Revenue 150,000 0 0 0 0
Total 150,000 0 0 0 0
Total Revenues and Other Fund Sources 150,000 0 0 0 0
Total Funds Available 150,000 0 0 0 0
Expenditures and Uses
Capital Projects&Equipment
Parks Department
Valentine Park Pathway 13-Park-012 (150,000) 0 0 0 0
Total (150,000) 0 0 0 0
Total Expenditures and Uses (150,000) 0 0 0 0
Change in Fund Balance 0 0 0 0 0
Ending Balance 0 0 0 0 0
Produced Using the Plan-It Capital Planning Sofhrare Thursday,June 21,2012
Source 2013 2014 2015 2016 2017 Total
Public Safety Capital Fund
Beginning Balance 338,706 222,986 146,886 185,292 186,458
Revenues and Other Fund Sources
Revenue
Interest Revenue 15,000 15,000 15,000 15,000 15,000
Total 15,000 15,000 15,000 15,000 15,000
Other Fund Sources
Charitable Gambling 30,000 30,000 30,000 30,000 30,000
Total 30,000 30,000 30,000 30,000 30,000
Total Revenues and Other Fund Sources 45,000 45,000 45,000 45,000 45,000
Total Funds Available 383,706 267,986 191,886 230,292 231,458
Expenditures and Uses
Capital Projects&Equipment
Public Safetv
Lake Johanna Fire Dept Equipment 09-Pub-001 (160,720) (121,100) (6,594) (43,834) 0
Total (160,720) (121,100) (6,594) (43,834) 0
Total Expenditures and Uses (160,720) (121,100) (6,594) (43,834) 0
Change in Fund Balance (115,720) (76,100) 38,406 1,166 45,000
Ending Balance 222,986 146,886 185,292 186,458 231,458
Source 2013 2014 2015 2016 2017 Total
Ramsey County-CSAH
Beginning Balance 0 0 0 0 0
Revenues and Other Fund Sources
No Funds 0 0 0 0 0
Total 0 0 0 0 0
Total Revenues and Other Fund Sources 0 0 0 0 0
Total Funds Available 0 0 0 0 0
Change in Fund Balance 0 0 0 0 0
Ending Balance 0 0 0 0 0
Produced Using the Plan-It Capital Planning Software Thursday,June 21,2012
Source 2013 2014 2015 2016 2017 Total
Sanitary Sewer Utility Fund
Beginning Balance 578,950 261,597 (82,603) 105,155 312,189
Revenues and Other Fund Sources
Revenue
Operating Revenue 1,866,304 1,903,630 1,941,703 1,980,537 1,980,537
Total 1,866,304 1,903,630 1,941,703 1,980,537 1,980,537
Total Revenues and Other Fund Sources 1,866,304 1,903,630 1,941,703 1,980,537 1,980,537
Total Funds Available 2,445,254 2,165,227 1,859,100 2,085,692 2,292,726
Expenditures and Uses
Capital Projects&Equipment
Equipment
Upgrade Camera System for Sewer Televising 14-Eqp-XXX 0 (37,000) 0 0 0
Total 0 (37,000) 0 0 0
Sanitary Sewer Department
Sewer Lining/Rehabilitation 09-Sew-002 (500,000) (125,000) 0 0 0
Reconstruct Lift Station 11 14-Sew-XXX 0 (250,000) 0 0 0
Total (500,000) (375,000) 0 0 0
Street Department
Snelling Avenue PMP 12-Str-007 (1,000) 0 0 0 0
Co Rd E Impr between Hwy 51&Lexington Ave 12-Str-060 (16,040) (160,000) 0 0 0
2013 PMP Mill and Overlay(Removed tjm) 13-StrM-062 0 0 0 0 (2,500)
Ridgewood Asbury--2013 PMP 14-Str-064 (47,500) (2,500) 0 0 0
Indian Oaks PMP-2017 PMP 16-Str-065 0 0 0 (7,500) (47,500)
Glenview Neighborhood--2015 PMP 17-Str-039 0 (7,500) (40,000) (2,500) 0
Total (64,540) (170,000) (40,000) (10,000) (50,000)
Other Uses
Operating Expenditures (1,557,117) (1,603,830) (1,651,945) (1,701,503) (1,752,548)
Operating transfer to Equipment Fund (62,000) (62,000) (62,000) (62,000) (62,000)
Total (1,619,117) (1,665,830) (1,713,945) (1,763,503) (1,814,548)
Total Expenditures and Uses (2,183,657) (2,247,830) (1,753,945) (1,773,503) (1,864,548)
Change in Fund Balance (317,353) (344,200) 187,758 207,034 115,989
Ending Balance 261,597 (82,603) 105,155 312,189 428,178
Produced Using the Plan-It Capital Planning Software Thursday,June 21,2012
Source 2013 2014 2015 2016 2017 Total
Special Revenue Cable Fund
Beginning Balance 262,075 207,254 148,744 95,279 37,900
Revenues and Other Fund Sources
Revenue
Operating Revenues 83,000 83,000 83,000 83,000 83,000
Total 83,000 83,000 83,000 83,000 83,000
Other Fund Sources
Interest Revenue 9,700 9,700 9,000 9,000 9,000
Total 9,700 9,700 9,000 9,000 9,000
Total Revenues and Other Fund Sources 92,700 92,700 92,000 92,000 92,000
Total Funds Available 354,775 299,954 240,744 187,279 129,900
Expenditures and Uses
Capital Projects&Equipment
Technology
Communications Equipment 12-Teo-003 (15,000) (15,000) (15,000) (15,000) (15,000)
City Website 12-Teo-004 (9,545) (9,545) 0 0 0
Total (24,545) (24,545) (15,000) (15,000) (15,000)
Other Uses
Operating Expenditures (122,976) (126,665) (130,465) (134,379) (138,410)
Total (122,976) (126,665) (130,465) (134,379) (138,410)
Total Expenditures and Uses (147,521) (151,210) (145.465) (149,379) (153,410)
Change in Fund Balance (54,821) (58,510) (53,465) (57,379) (61,410)
Ending Balance 207,254 148,744 95,279 37,900 (23,510)
Produced Using the Plan-It Capital Planning Sofhvare Thursday,,tune 21,2012
Source 2013 2014 2015 2016 2017 Total
Special Revenue Park Fund
Beginning Balance 0 (5,000) (5,000) (5,000) (5,000)
Revenues and Other Fund Sources
Revenue
Interest Revenue 0 0 0 0 0
Total 0 0 0 0 0
Total Revenues and Other Fund Sources 0 0 0 0 0
Total Funds Available 0 (5,000) (5,000) (5,000) (5,000)
Expenditures and Uses
Capital Projects&Equipment
Parks Department
Park Bench Implementation 10-Park-031 (5,000) 0 0 0 0
Total (5,000) 0 0 0 0
Total Expenditures and Uses (5,000) 0 0 0 0
Change in Fund Balance (5,000) 0 0 0 0
Ending Balance (5,000) (5,000) (5,000) (5,000) (5,000)
Produced Using the Plan-It Capital Planning Sofhi,are Thursday,June 21,2012
Source 2013 2014 2015 2016 2017 Total
State Aid Funds
Beginning Balance 1,072,717 262,793 (374,631) (344,555) (154,479)
Revenues and Other Fund Sources
Revenue
Estimated Revenues 190,076 190,076 190,076 190,076 190,076
Total 190,076 190,076 190,076 190,076 190,076
Total Revenues and Other Fund Sources 190,076 190,076 190,076 190,076 190,076
Total Funds Available 1,262,793 452,869 (184,555) (154,479) 35,597
Expenditures and Uses
Capital Projects&Equipment
Parks Department
Mounds View HS Trail Connection 11-Park-001 0 0 (160,000) 0 0
Total 0 0 (160,000) 0 0
Street Department
Snelling Avenue PMP 12-Str-007 (1,000,000) (727,500) 0 0 0
Lexington Avenue Improvement(1-694 to CR F) 14-Str-XXX 0 (100,000) 0 0 0
Total (1,000,000) (827,500) 0 0 0
Total Expenditures and Uses (1,000,000) (827,500) (160,000) 0 0
Change in Fund Balance (809,924) (637,424) 30,076 190,076 190,076
Ending Balance 262,793 (374,631) (344,555) (154,479) 35,597
Produced Using the Plan-It Capital Planning Sof fare Thursday,June 21,2012
Source 2013 2014 2015 2016 2017 Total
Surface Water Mgmt Utility Funds
Beginning Balance 352,504 (11,495) (362,368) (640,760) (554,793)
Revenues and Other Fund Sources
Revenue
Operating Revenue 573,228 593,291 614,056 635,548 635,548
Total 573,228 593,291 614,056 635,548 635,548
Total Revenues and Other Fund Sources 573,228 593,291 614,056 635,548 635,548
Total Funds Available 925,732 581,796 251,688 (5,212) 80,755
Expenditures and Uses
Capital Projects&Equipment
Street Department
Highway 96(Old Highway 8 to US Highway 10) 11-Str-055 (75,000) 0 0 0 0
Snelling Avenue PMP 12-Str-007 (20,000) 0 0 0 0
Co Rd E Impr between Hwy 51&Lexington Ave 12-Str-060 (43,000) (371,000) 0 0 0
2013 PMP Mill and Overlay(Removed tjm) 13-StrM-062 0 0 0 0 (5,000)
Ridgewood Asbury--2013 PMP 14-Str-064 (317,500) (17,500) 0 0 0
Indian Oaks PMP-2017 PMP 16-Str-065 0 0 0 (20,000) (315,000)
Glenview Neighborhood--2015 PMP 17-Str-039 0 (75,000) (400,000) (25,000) 0
Total (455,500) (463,500) (400,000) (45,000) (320,000)
Surface Water Management Dept
Storm Pond Maintenance 09-Storm-001 (50,000) (50,000) (50,000) (50,000) 0
Innovation Way/Co Rd F pond Dredging 12-Storm-001 (12,500) 0 0 0 0
Total (62,500) (50,000) (50,000) (50,000) 0
Other Uses
Operating Exenditures (381,227) (392,664) (404,448) (416,581) (441,576)
Transfer to Equipment Fund (38,000) (38,000) (38,000) (38,000) (38,000)
Total (419,227) (430,664) (442,448) (454,581) (479,576)
Total Expenditures and Uses (937,227) (944,164) (892,448) (549,581) (799,576)
Change in Fund Balance (363,999) (350,873) (278,392) 85,967 (164,028)
Ending Balance (11,495) (362,368) (640,760) (554,793) (718,821)
Produced Using the Plan-It Capital Planning Sof fare Thursday,June 21,2012
Source 2013 2014 2015 2016 2017 Total
TIF District
Beginning Balance 1,162,815 1,203,482 1,252,714 1,310,197 1,307,197
Revenues and Other Fund Sources
Revenue
Estimated Revenues 327,253 337,070 347,183 0 0
Total 327,253 337,070 347,183 0 0
Total Revenues and Other Fund Sources 327,253 337,070 347,183 0 0
Total Funds Available 1,490,068 1,540,552 1,599,897 1,310,197 1,307,197
Expenditures and Uses
Capital Projects&Equipment
Street Department
West Round Lake Road PMP(Moved to 2017 or b 15-Str-042 0 0 0 0 (50,000)
Total 0 0 0 0 (50,000)
Other Uses
Operating Expenses (1,716) (1,716) (3,000) (3,000) 0
Transfer to Debt Fund (284,870) (286,122) (286,700) 0 0
Total (286,586) (287,838) (289,700) (3,000) 0
Total Expenditures and Uses (286,586) (287,838) (289,700) (3,000) (50,000)
Change in Fund Balance 40,667 49,232 57,483 (3,000) (50,000)
Ending Balance 1,203,482 1,252,714 1,310,197 1,307,197 1,257,197
Produced Using the Plan-It Capital Planning Sofhvare Thursday,June 21,2012
Source 2013 2014 2015 2016 2017 Total
Water Utility Funds
Beginning Balance 1,311,627 1,148,966 506,524 346,632 688,487
Revenues and Other Fund Sources
Revenue
Operating Revenue 2,093,060 2,239,575 2,396,345 2,564,089 2,564,089
Total 2,093,060 2,239,575 2,396,345 2,564,089 2,564,089
Total Revenues and Other Fund Sources 2,093,060 2,239,575 2,396,345 2,564,089 2,564,089
Total Funds Available 3,404,687 3,388,541 2,902,869 2,910,721 3,252,576
Expenditures and Uses
Capital Projects&Equipment
Street Department
Snelling Avenue PMP 12-Str-007 (1,000) 0 0 0 0
Co Rd E Impr between Hwy 51&Lexington Ave 12-Str-060 (25,700) (265,000) 0 0 0
2013 PMP Mill and Overlay(Removed tjm) 13-StrM-062 0 0 0 0 (2,500)
Ridgewood Asbury--2013 PMP 14-Str-064 (240,000) (10,000) 0 0 0
Indian Oaks PMP--2017 PMP 16-Str-065 0 0 0 (5,000) (21,000)
Glenview Neighborhood-2015 PMP 17-Str-039 0 (90,000) (480,000) (30,000) 0
Total (266,700) (365,000) (480,000) (35,000) (23,500)
Water Department
Water Tower Repair and Repainting 12-W-001 0 (500,000) 0 (50,000) 0
Booster Station Roof Replacement 13-W-XX (20,000) 0 0 0 0
Hand Held GPS Unit 13-W-XXX (9,500) 0 0 0 0
Total (29,500) (500,000) 0 (50,000) 0
Other Uses
Transfer to Equipment Fund (43,000) (43,000) (43,000) (43,000) (43,000)
Operating Expenditures (1,916,521) (1,974,017) (2,033,237) (2,094,234) (2,094,234)
Total (1,959,521) (2,017,017) (2,076,237) (2,137,234) (2,137,234)
Total Expenditures and Uses (2,255,721) (2,882,017) (2,556,237) (2,222,234) (2,160,734)
Change in Fund Balance (162,661) (642,442) (159,892) 341,855 403,355
Ending Balance 1,148,966 506,524 346,632 688,487 1,091,842
Produced Using the Plan-It Capital Planning Sofh+,are Thursday,June 21,2012
General Fund Spendable Balance
2,500,000 - - ---
2,000,000
1,500,000 —
General Fund Spendable
1,000,000 Balance
500,000
2006 2007 2008 2009 2010 2011
PIR Fund Balances
7,000,000 -- -- -
6,800,000
6,600,000 - -
6,400,000 -------- -- -- -_---
PIR Fund Balances
6,200,000 - --
6,000,000 - -
5,800,000 - r- — —T- ----�
2006 2007 2008 2009 2010 2011
1,600,000
1,400,000
1,200,000 _.
1,000,000 -- __. ___n.__ Water Fund Cash
800,000 - - -- -Sewer Fund cash
600,000 L
— SurFacc Water Cash
400,000 --- - -
200,000 -- - ---
2006 2007 2008 2009 2010 2011