HomeMy WebLinkAbout5B Approval of Treasurer's Report�I�1
4646 Dakota Street SE
Prior Lake, MN 55372
CITY COUNCIL AGENDA REPORT
MEETING DATE: February 7, 2011
AGENDA #: 5B
PREPARED BY: JERILYN ERICKSON, FINANCE DIRECTOR
PRESENTED BY: JERILYN ERICKSON, FINANCE DIRECTOR
AGENDA ITEM: CONSIDER APPROVAL OF DECEMBER 2010 TREASURER'S REPORT
DISCUSSION: Introduction
The purpose of this agenda item is for the Council to consider approval of
the monthly treasurer's report for December, 2010.
This information is being provided in a new format which categorizes the
balances by fund type. This new format was presented to Council
members at their workshop on March 15, 2010.
A second page is included to provide the Fund Balance Classification for
each of the funds as well as the restrictions placed upon their usage. This
was also presented and discussed at the workshop. Even though a fund
may have an "unrestricted" or "unreserved" fund balance classification, it
does not necessarily mean that the balance is available to appropriate to
other funds for other uses. There may be constraints in place due to the
type of fund (i.e. debt service fund), the contractual obligations (i.e.
developer or tax increment agreements) or as communicated when the
fund was established.
For example, TIF Capital Project Funds have an "unreserved- designated
for improvements" fund balance classification. These funds are
contractually obligated by tax increment agreements in place so they are
not available to appropriate for other City uses. Upon decertification of a
TIF district, any residual funds will be sent to Scott County to be
redistributed to the city, school and county.
The business -type funds have "unrestricted" fund balance classifications.
In the case of the Transit Fund, we receive funds from the Met Council for
transit - related uses. Any remaining fund balance in the Transit Fund
cannot be appropriated for other City uses. To use the fund balances in
the Water, Sewer and Water Quality Funds for something other than what
was indicated on the utility bill would misrepresent the intent of the fees that
were charged.
The funds that have balances which have been identified for a particular
purpose such as equipment replacement or downtown building fagade
improvements can be appropriated for other City uses as determined by
the Council. Certain long -term plans in the Capital Improvement Program
have been established which support the balances in these funds. Council
would need to consider the financial impact of appropriating these balances
for other uses.
Further description of the constraints on other funds is reflected on the
second page of the report.
Current Circumstances
Staff has prepared a preliminary summary of the activity in the fund
balances for the month of December, 2010. The Treasurer's Report
reflects beginning cash balance, receipts, disbursements, and the ending
cash balance for each fund for the month of December, 2010. Interest
earned is allocated to each fund on a monthly basis and based upon each
individual fund's proportionate share of the total cash balance. The report
details each fund balance classification. The report is preliminary,
unaudited, and may change. In most instances these funds were
established and restricted for specific and designated purposes by either
Minnesota Statutes or City Code to accomplish the goals and objectives of
the City of Prior Lake. The attached memorandum provides a summary of
the fund descriptions.
Interest for the month of December, 2010, per this report has not been
allocated to each fund. Interest will be allocated after further review of the
yearend balances.
If Council members have questions, please feel free to contact me at 952-
447 -9841 for more information.
ALTERNATIVES: 1. A motion as part of the consent agenda to approve the December,
2010 Treasurer's Report as submitted.
2. Take no action and provide the staff with specific direction.
RECOMMENDED Alternative 1. A motion as part of the consent agenda to approve the
MOTION: A December, 2010 Treasurer's Report as submitted.
ie d
FrankAoyi,lasi City Manager
ATT� CHIVI�NTS: 1. City of Prior Lake December, 2010 Treasurer's Report
/ 2. Treasurer's Report Fund Descriptions
of PRIG
h City of Prior Lake
Treasurers Report
M,v�so° December, 2010
Governmental -Type Funds
General Fund
Special Revenue Funds
Cable Franchise Fund
Capital Park Fund
Severance Compensation
EDA Special Revenue
Econ Dev Federal Revolving Loan Fund
Econ Dev MN Revolving Loan Fund
Developer Agreement Fund
Total Special Revenue Funds
Capital Project Funds
Downtown Revolving Fund
Tax Increment
TIF #1 -3
TIF #3 -1
TIF #4 -1
TIF #5 -1
TIF #6 -1
Revolving Equipment Fund
Building Fund
Revolving Park Equipment Fund
Construction Fund
Trunk Reserve Fund
Street Oversize Fund
Water Storage Fund
Total Capital Project Funds
Debt Service Funds
Agency Fund
Total Governmental Type Funds
Total All Funds
Investment Pool & Ratio
101 $ 4,858,274.68 $ 5,667,294.11 $ 3,380,350.14 $ 7,145,218.65
210
Fund
12/1/2010
225
65,654.11 63,327.04
12/31/2010
Fund Type & Name
No.
Balance
Receipts
Disbursements
Balance
Business -Type Funds
105,609.09 -
- 105,609.09
255
82,010.97 -
- 82,010.97
Water & Sewer Fund
601
$ 6,715,521.84
$ 621,440.69
$ 1,685,972.80
$ 5,650,989.73
Water Quality Fund
602
637,999.75
64,538.39
74,081.50
628,456.64
Transit Fund
603
1,590,925.79
111,786.05
41,717.34
1,660,994.50
Total Business -Type Funds
166,344.79
$ 8,944,447.38
$ 797,765.13
$ 1,801,771.64
$ 7.940.440.87
Governmental -Type Funds
General Fund
Special Revenue Funds
Cable Franchise Fund
Capital Park Fund
Severance Compensation
EDA Special Revenue
Econ Dev Federal Revolving Loan Fund
Econ Dev MN Revolving Loan Fund
Developer Agreement Fund
Total Special Revenue Funds
Capital Project Funds
Downtown Revolving Fund
Tax Increment
TIF #1 -3
TIF #3 -1
TIF #4 -1
TIF #5 -1
TIF #6 -1
Revolving Equipment Fund
Building Fund
Revolving Park Equipment Fund
Construction Fund
Trunk Reserve Fund
Street Oversize Fund
Water Storage Fund
Total Capital Project Funds
Debt Service Funds
Agency Fund
Total Governmental Type Funds
Total All Funds
Investment Pool & Ratio
101 $ 4,858,274.68 $ 5,667,294.11 $ 3,380,350.14 $ 7,145,218.65
210
$ 42,080.16 $ - $
- $ 42,080.16
225
65,654.11 63,327.04
1,898.90 127,082.25
230
507,714.64 -
- 507,714.64
240
101, 966.94 -
- 101, 966.94
250
105,609.09 -
- 105,609.09
255
82,010.97 -
- 82,010.97
260
675,369.73 -
6,392.51 668,977.22
2,815.24
$ 1,580,405.64 $ 63,327.04 $
8,291.41 $ 1,635,441.27
256
$ 38,425.86
$ -
$ -
$ 38,425.86
402
151,864.06
10,359.46
-
162,223.52
413
95,840.79
79,303.47
29,275.00
145,869.26
414
39,740.61
33,221.71
-
72,962.32
415
2,815.24
4,245.38
-
7,060.62
416
1,533.12
6,406.14
-
7,939.26
417
66, 920.50
89,184.94
-
156,105.44
410
1,281,406.13
166,344.79
397.20
1,447,353.72
420
436,241.13
-
-
436,241.13
430
205,595.66
-
-
205,595.66
501
305,514.83
808,304.29
274,047.95
839,771.17
502
946,970.78
55,000.00
21,800.00
980,170.78
503
450,029.24
2,711.52
-
452,740.76
505
221,259.39
4,000.00
-
225,259.39
$ 4,244,157.34
$ 1,259,081.70
$ 325,520.15
$ 5,177,718.89
5xx
$ 1,602,568.99
$ 906,530.29
$ 755,753.13
$ 1,753,346.15
801
$ 154,200.00
$ 6,000.00
$ 9,500.00
$ 150,700.00
$ 12,439,606.65
$ 7,902,233.14
$ 4,479,414.83
$ 15,862,424.96
$ 21,384,054.03
$ 8,699,998.27
$ 6,281,186.47
$ 23,802,865.83
$ 23,828,686.22 100.11%
This report does not reflect financial obligations from contracts, agreements, purchases, services received, etc.
OF PRrpB
h City of Prior Lake
m Treasurers Report
December, 2010
Fund Type & Name Fund Balance Classification Constraints
Business -Type Funds
Water & Sewer Fund Unrestricted Identified on utility bill for this purpose
Water Quality Fund Unrestricted Identified on utility bill for this purpose
Transit Fund Unrestricted Funds received for transit - related uses
Governmental -Type Funds
General Fund
Special Revenue Funds
Cable Franchise Fund
Capital Park Fund
Severance Compensation
EDA Special Revenue
Econ Dev Federal Revolving Loan Fund
Econ Dev MN Revolving Loan Fund
Developer Agreement Fund
Capital Project Funds
Downtown Revolving Fund
Tax Increment
TIF #1 -3
TIF #3 -1
TIF #4 -1
TIF #5 -1
TIF #6 -1
Revolving Equipment Fund
Building Fund
Revolving Park Equipment
Construction Fund
Trunk Reserve Fund
Street Oversize Fund
Water Storage Fund
Debt Service Funds
Unreserved Cashflow, emergencies, one -time opportunities
Unreserved; Designated for Capital Outlay Statutory obligation to use for PEG access
Unreserved; Designated for Improvements Contractually obligated; park dedication fees
Reserved for Severance Compensation Reserved for Severance Compensation
Unreserved; Designated for Improvements Economic Development
Unreserved; Designated for Development Loans Economic Development
Unreserved; Designated for Development Loans Economic Development
Unreserved; Designated for Improvements Contractually obligated;
Unreserved; Designated for Improvements
Unreserved; Designated for Improvements
Unreserved; Designated for Improvements
Unreserved; Designated for Improvements
Unreserved; Designated for Improvements
Unreserved; Designated for Improvements
Unreserved; Designated for Improvements
Unreserved; Designated for Capital Outlay
Unreserved; Designated for Capital Outlay
Identified for downtown building facade improvements
Contractually obligated by tax increment agreements
Contractually obligated by tax increment agreements
Contractually obligated by tax increment agreements
Contractually obligated by tax increment agreements
Contractually obligated by tax increment agreements
Contractually obligated by tax increment agreements
Identified for equipment replacement
Identified for funding Facilities Management Plan (future)
Fund Unreserved; Designated for Capital Outlay Identified for park equipment replacement
Unreserved; Construction projects in progress
Unreserved; Contractually obligated by developer agreements
Unreserved; Contractually obligated by developer agreements
Unreserved; Contractually obligated by developer agreements
Reserved for Debt Service Reserved for contractually obligated debt service
Agency Fund N/A Escrows to be reimbursed to depositors
TREASURER'S REPORT FUND DESCRIPTIONS
General Fund - The General Fund represents the necessary resources to support general operating
budget expenditures of the City. The year -end fund balance represents dollars that have
accumulated over a period of time as a result of cumulative budgetary revenue surpluses and
expenditure under runs. The City Council has designated a portion of this amount, equal to a
minimum of 45% of the current operating budget, for working capital to finance city operations.
Sewer & Water Fund - The Sewer and Water Fund accounts for the collection of sewer and water
billing utility revenue. This enterprise fund balance is allocated for the operational costs of the
Water /Sewer departments and normally reserved for large capital municipal system expenses.
Water Ouali . Fund - The Storm Water Fund is an enterprise account funded by the $7.25 storm
water charge on the utility bills. The funds in the account are dedicated to finance water quality
improvements including departmental administration, storm water maintenance operations and
improvement projects related to water quality.
Transit Fund - The Transit Fund is an enterprise account funded predominantly (90 %) by state
aid that is derived from the vehicle excise tax paid through annual license tab renewals on
vehicles. The receipts are dedicated to pay for community transit services such as the downtown
commuter service, van pool and dial -a -ride services.
Cable Franchise Fund - This fund was created to act as a clearing house for funds that were
received from the cable franchise company as specified by ordinance.
Capital Park Fund - Capital Park funds are dedicated funds received from developers in
accordance with the City's Park Dedication requirement when land is platted. Funds are
collected for the purpose of developing the City's neighborhood park and trail system. These
dollars are programmed throughout the course of the City's Capital Improvement Program.
Severance Compensation Fund - This fund was established to partially fund the City's
compensated absence liability which is associated with the accrued vacation and sick leave for
employees upon employment termination. The State Auditor's Office has recommended that
local governments set aside a certain percentage on the basis of foreseeable turnover.
ED Special Revenue — This fund is reserved and expended at the direction of the Prior Lake
Economic Development Authority for specific economic development activity as allowed by MN
Statute. The purpose is to provide economic incentives for new business expansion within the
community.
ED Fed /MN Loan Funds - These funds were created to account for the proceeds of economic
development grants received either from the federal government or the State of Minnesota to
provide seed money for a revolving loan account. The purpose is to provide economic incentive
for new business expansion within the community.
Downtown Redevelopment Fund - This fund was created to provide development assistance in
the context of building facade improvements for downtown businesses in an effort to revitalize
and renew business activity and the general appearance of the downtown business district.
DAG Special Revenue Fund - The DAG Fund is a special revenue fund related to the costs the
City incurs in connection with a subdivision. The fees are paid to the City by the developer when
the Development Contract and Final Plat are approved by the City Council. These revenues are
used to pay for legal expenses incurred in connection with review and approval of the plat and
inspection services on developer installed - utilities including sewer, water and street installation
for newly approved subdivisions within the City of Prior Lake.
Water Revenue Bond Fund — Pw Bldg - This fund is a debt service fund to pay the bonds that
were issued to construct the public works maintenance building. The capital facility (CFAC)
charge of $10.00 that is generated on the bi- monthly water and sewer bill provides the funding
for the bond payments which occur semi - annually in June and December of each year. Upon
demand the funds are transferred from the Sewer and Water Fund.
Water Revenue Bond Fund — WT Plant - This fund is a debt service fund to pay the bonds that
were issued to construct the water treatment plant. Revenue from the water and sewer bills
provides the funding for the bond payments which occur semi - annually in June and December of
each year. Upon demand the funds are transferred from the Sewer and Water Fund.
Tax Increment Funds - The Tax Increment Fund represents an accumulation of funds such as
bond proceeds and project administration fees charged to companies requesting project write-
downs in the form of tax increment financing for new and /or redevelopment. The TIF district
property taxes are then deposited in a number of tax increment funds established to track their
respective revenue.
Revolving Equipment Fund - A regular replacement schedule for equipment needs of the City in
excess of $5,000 has been adopted. Periodic fund transfers are appropriated to provide a funding
source for the acquisition and purchase of new and replacement vehicles and equipment. The
long term effect of appropriating fund transfer is to mitigate property tax increases and eliminate
debt financing.
Buildin Fund - The funds within the Building Fund are reserved for future building needs.
Revolving Park Equipment Fund — This Fund was established in 2009 in conjunction with the
Park Equipment Replacement Plan to fund replacement of park equipment.
Construction Fund - Construction Fund dollars represent unexpended bond proceeds that are
reserved to pay for improvement projects that have been approved by the City Council on an
annual basis. For the most part, these moneys are necessary to complete outstanding construction
contracts and related engineering and professional services.
Street Oversize Fund - The Collector Street Fund consists of dedicated revenue generated by fees
associated with new development and new construction building permits for the purpose of
funding pedestrian related improvements i.e., bikeways, sidewalks, trail systems plus right of
way acquisition along collector streets and occasional collector street links.
Trunk Reserve Fund - The Trunk Reserve Fund consists of dedicated revenue generated from
utility connection permits and acreage fees assessed at time of sewer and water installation for
the purpose of recovering trunk oversizing costs and central municipal system improvements i.e.,
wells lift stations, force mains, etc. These dollars are programmed throughout the course of the
City's capital improvement plan.
Water Storage Fund - The Water Storage Fund accounts for the water tower fee that is charged
and collected on building permits. This fund balance is 100% reserved for the construction of
elevated and ground water storage facilities.
Debt Service Funds - The Debt Service Fund represents prepayments of special assessments,
property tax collections and special levies needed to pay the outstanding bonded indebtedness of
the City. This fund balance is 100% reserved for the payment of bond principal and interest.
Agency Fund - The Agency Fund accounts for the $1500 residential building permit deposit that
is refunded to the building contractor upon final inspection. This provides the City the required
financial assurance that the property site will be adequately cleaned up and debris free before an
occupancy permit is granted.