HomeMy WebLinkAbout5B August 2015 Treasurer's Report (rviv
1311104 tri
4646 Dakota Street SE
Ese' Prior Lake, MN 55372
CITY COUNCIL AGENDA REPORT
MEETING DATE: September 28, 2015
AGENDA #: 5B
PREPARED BY: CATHERINE ASMUS, ACCOUNTANT
PRESENTED BY: DON URAM, FINANCE DIRECTOR
AGENDA ITEM: CONSIDER APPROVAL OF AUGUST, 2015 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 August, 2015.
This information is being provided in a format which categorizes the
balances by fund type. 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. Even though the business-type funds may have
an "unrestricted" fund balance and the General Fund may have an
"unassigned" fund balance, it does not necessarily mean that the balance is
available to appropriate to other funds for other uses. There are
constraints in place due to the type of fund or based on the City's fund
balance policy.
Current Circumstances
Staff has prepared a preliminary summary of the activity in the funds for the
month of August, 2015. The Treasurer's Report reflects beginning cash
balance, receipts, disbursements, and the ending cash balance for each
fund.
The Report is preliminary, unaudited and will change.
The attached memorandum provides a summary of the fund descriptions.
If Council members have questions, please feel free to contact me at 952-
447-9842 for more information.
ALTERNATIVES: 1. A motion and second as part of the consent agenda to approve the
August, 2015 Treasurer's Report as submitted.
2. Take no action and provide the staff with specific direction.
RECOMMENDED Alternative #1.
MOTION:
ATTACHMENTS: 1. City of Prior Lake August, 2015 Treasurer's Report
2. Treasurer's Report Fund Descriptions
5B
04 PR!0
City of Prior Lake
M Treasurers Report
44,YNS0,1. August, 2015
Fund 8/1/2015 8/31/2015
Fund Type& Name No. Balance Receipts Disbursements Balance
Business-Type Funds
Water Fund 601 $ 2,181,962.62 $ 700,608.97 $ 162,477.97 $ 2,720,093.62
Sewer Fund 604 1,118,040.70 388,118.50 157,042.44 1,349,116.76
Water Quality Fund 602 451,698.73 132,072.81 40,933.72 542,837.82
Transit Fund 603 799,179.80 0.00 799,179.80 -
Total Business-Type Funds $ 4,550,881.85 $ 1,220,800.28 $ 1,159,633.93 $ 4,612,048.20
Governmental-Type Funds
General Fund 101 $ 6,909,936.24 $ 329,933.91 $ 925,354.56 $ 6,314,515.59
Special Revenue Funds
Cable Franchise Fund 210 $ 66,092.31 $ - $ - $ 66,092.31
Capital Park Fund 225 709,171.20 3,628.68 26,726.00 686,073.88
EDA Special Revenue 240 159,382.86 722.89 11,792.07 148,313.68
Econ Dev Federal Revolving Loan Fund 250 119,165.55 292.29 0.00 119,457.84
Econ Dev MN Revolving Loan Fund 255 92,538.22 226.98 0.00 92,765.20
Developer Agreement Fund 260 1,293,727.32 16,950.00 5,798.98 1,304,878.34
Total Special Revenue Funds $ 2,440,077.46 $ 21,820.84 $ 44,317.05 $ 2,417,581.25
Capital Project Funds
Tax Increment 402 $ 74,850.97 $ 985.56 $ - $ 75,836.53
TIF#1-3 413 109,341.30 266.97 500.00 109,108.27
TIF#3-1 414 81,286.52 198.15 500.00 80,984.67
TIF#4-1 415 (33.00) 0.00 500.00 - 533.00
TIF#5-1 416 5,916.68 13.29 500.00 5,429.97
TIF#6-1 417 218,460.70 534.61 500.00 218,495.31
TIF#1-4 418 366.46 0.00 500.00 - 133.54
Revolving Equipment Fund 410 852,389.23 9,814.12 37,496.20 824,707.15
Revolving Park Equipment Fund 430 389,239.56 954.73 0.00 390,194.29
Facilities Management Fund 440 659,717.52 1,617.71 180.00 661,155.23
Construction Fund 501 10,224,838.23 81,363.76 1,705,262.53 8,600,939.46
Trunk Reserve Fund 502 1,380,258.43 27,444.37 0.00 1,407,702.80
Street Oversize Fund 503 620,502.98 1,521.97 0.00 622,024.95
Water Storage Fund 505 1,056,694.28 18,631.10 0.00 1,075,325.38
Total Capital Project Funds $ 15,673,829.86 $ 143,346.34 $ 1,745,938.73 $ 14,071,237.47
Debt Service Funds 5xx $ 2,614,083.76 $ 27,295.68 $ 31,894.87 $ 2,609,484.57
Agency Fund 801 $ 453,523.50 $ 32,500.00 $ 36,500.00 $ 449,523.50
Total Governmental Type Funds $ 28,091,450.82 $ 554,896.77 $ 2,784,005.21 $ 25,862,342.38
Internal Service Fund 701 $ 488,001.16 $ 3,085.23 $ - $ 491,086.39
Total All Funds $ 33,130,333.83 $ 1,778,782.28 $ 3,943,639.14 $ 30,965,476.97
Investment Pool & Ratio as of 813112015 99.33% $ 30,756,961.23
This report does not reflect financial obligations from contracts, agreements, purchases, services received, etc.
OF YR/04
0City of Prior Lake
Iu Treasurers Report
August, 2015
Fund Type&Name Fund Balance Classification Constraints
Business-Type Funds
Water Fund Unrestricted Identified on utility bill for this purpose
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 Unassigned Cashflow,emergencies,one-time opportunities
Special Revenue Funds
Cable Franchise Fund Assigned for communications Statutory obligation to use for PEG access
Capital Park Fund Assigned for capital improvements Contractually obligated;park dedication fees
EDA Special Revenue Assigned for development Economic Development
Econ Dev Federal Revolving Loan Fund Restricted for economic development Economic Development
Econ Dev MN Revolving Loan Fund Restricted for economic development Economic Development
Developer Agreement Fund Assigned for development Contractually obligated;
Capital Project Funds
Tax Increment Restricted for tax increment Contractually obligated by tax increment agreements
TIF#1-3 Restricted for tax increment Contractually obligated by tax increment agreements
TIF#3-1 Restricted for tax increment Contractually obligated by tax increment agreements
TIF#4-1 Restricted for tax increment Contractually obligated by tax increment agreements
TIF#5-1 Restricted for tax increment Contractually obligated by tax increment agreements
TIF#6-1 Restricted for tax increment Contractually obligated by tax increment agreements
Revolving Equipment Fund Assigned for capital improvements Identified for equipment replacement
Revolving Park Equipment Fund Assigned for capital improvements Identified for park equipment replacement
Facilities Management Fund Assigned for capital improvements Identified for funding Facilities Management Plan
Construction Fund Restricted for capital improvements Construction projects in progress
Trunk Reserve Fund Assigned for capital improvements Contractually obligated by developer agreements
Street Oversize Fund Assigned for capital improvements Contractually obligated by developer agreements
Water Storage Fund Assigned for capital improvements Contractually obligated by developer agreements
Debt Service Funds Restricted for Debt Service Reserved for contractually obligated debt service
Agency Fund N/A Escrows to be reimbursed to depositors
Internal Service Fund Unrestricted Identified as payment for severance compensation
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.
Water Fund - The Water Fund accounts for the collection of water billing utility revenue. This
enterprise fund balance is allocated for the operational costs of the Water departments and
normally reserved for large capital municipal system expenses.
Sewer Fund - The Sewer Fund accounts for the collection of sewer billing utility revenue. This
enterprise fund balance is allocated for the operational costs of the Sewer department and
normally reserved for large capital municipal system expenses.
Water Quality Fund-The Storm Water Fund is an enterprise account funded by the$11.25 storm
water charge that is generated on the bi-monthly water and sewer 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. Transit operations have been transferred to
the Minnesota Valley Transit Authority(MVTA) in 2015.
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.
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. These funds were closed in September,2011.
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.
Revolving Park Equipment Fund — This Fund was established in 2009 in conjunction with the
Park Equipment Replacement Plan to fund replacement of park equipment.
Facilities Management Fund — This Fund was established on 08/15/2011 per council resolution
#11-100 in conjunction with the Facilities Management Plan (FMP). The FMP provides a
schedule of major repairs,replacements and upgrades to all of the City facilities.
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 $2500 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.
Severance Compensation Fund — This Internal Service Fund was established on 12/31/2011 to
replace the Severance Compensation Fund (Special Revenue Fund) in conjunction with the
implementation of GASB Statement No. 54. 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.