HomeMy WebLinkAbout5B - Treasurer's Report
5B
4646 Dakota Street S.E.
Prior Lake, MN 55372-1714
TO: Mayor and City Council
FROM: Ralph Teschner, Finance Director
DATE: August 6, 2007
RE: August 1,2007, City of Prior Lake Treasurer's Report
7/1/2007 8/1/2007
FUNDS BALANCE RECEIPTS DISBURSEMENTS BALANCE
General 5,253,896.55 1,743,428.08 2,288,003.47 4,709,321.16
Sewer & Water 6,073,818.52 131,504.56 294,903.91 5,910,419.17
Storm Water 404,025.76 6,904.56 21,589.47 389,340.85
Transit Services 1,229,571.36 69,181.36 41,148.47 1,257,604.25
Cable Franchise Fund 39,425.16 0.00 0.00 39,425.16
Capital Park 1,218,429.03 5,191.05 529,132.87 694,487.21
Severance Compo 348,966.86 851.80 0.00 349,818.66
ED Fed Loan Fund 89,758.70 219.09 0.00 89,977.79
ED MN Loan Fund 69,702.28 170.14 0.00 69,872.42
Downtown Red Fund 32,658.66 79.72 0.00 32,738.38
DAG Special Rev. Fund 1,039,094.83 0.00 23,792.00 1,015,302.83
Tax Increment Fund 72,688.97 177.43 0.00 72,866.40
TIF #1-3 (lakefront plaza) 96,285.44 110.65 50,952.68 45,443.41
TIF #3-1 (creekside) 45,407.62 40.01 29,015.77 16,431.86
TIF #4-1 (on-site) 194.85 0.48 0.00 195.33
TIF #6-1 (shep path) 647.91 0.00 0.00 647.91
Equipment Fund 962,384.53 12,384.89 54,737.50 920,031.92
Building Fund 3,242,518.81 7,676.31 137,972.46 3,112,222.66
Construction Fund 1,928,976.99 205,178.59 7,395.50 2,126,760.08
Trunk Reserve 4,484,250.24 24,235.03 93,100.12 4,415,385.15
Street Oversize 690,677.84 1,670.11 6,463.50 685,884.45
Water Storage 10,462,149.08 33,181.67 153,653.10 10,341,677.65
Debt Service 3,133,266.88 14,165.21 0.00 3,147,432.09
Agency Fund 293,250.00 7,500.00 10,500.00 290,250.00
Totals 41,212,046.87 2,263,850.74 3,742,360.82 39,733,536.79
INVESTMENT POOL... $39,676,569.00
Investment Ratio... 99.86%
www.cityofpriorlake.com
07-07 treasure.xls Phone 952.447.9800 / Fax 952.447.4245 4:00 PM 8/6/2007
FUNDS
EDA Special Revenue
4646 Dakota Street S.E.
Prior Lake, MN 55372-1714
TO: Mayor and City Council
FROM: Ralph Teschner, Finance Director
DATE: August 6, 2007
RE: August 1,2007, City of Prior Lake EDA Treasurer's Report
7/1/2007
BALANCE
RECEIPTS DISBURSEMENTS
93,265.98
366.61 18.83
Totals
93,265.98
366.61 18.83
GRAND TOTAL $93,613.76
FUND DESCRIPTION: These funds are separate and segregated from
all City established funds for the purpose of
accounting only. They are reserved and expended
at the direction of the Prior Lake Economic
Development Authority for specific economic
development activity as allowed by MN Statute.
www.cityofpriorlake.com
8/1/2007
BALANCE
93,613.76
93,613.76
07-07 treasure. xis
4:00 PM 8/6/2007
Phone 952.447.9800 / Fax 952.447.4245
4646 Dakota Street S.E.
Prior Lake, MN 55372-1714
TREASURER'S REPORT FUND DESCRIPTIONS
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 Quality Fund - The Storm Water Fund is an enterprise account funded by the $6.00
storm water charge on the water bills and is dedicated to finance water quality
improvements including departmental administration, storm water maintenance operations
and improvement projects such as water quality ponds.
Transit Fund - The Transit Fund is an enterprise account funded predominantly (90%) by
state aid that is derived from the vehicle excise tax paid thru annual license tab renewals on
vehicles and is 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 which are then paid to
ISD #719 as payment support for 50% of the public access coordinator position and for
cable studio equipment replacement.
Capital Park Fund - Capital Park funds are dedicated funds generated by the cash park
dedication fees paid at time of development contract execution as a result of new
development. 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 plan.
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 FedIMN 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 the general appearance of the downtown business district.
DAG Special Revenue Fund - The DAG Fund is a special revenue fund to account for
project engineering and inspection fe~~ fthat are collected as a result of a developer's
WWW.chyopnorlake.com
H\spreadshects\GeneralLedger\Treasurer.doc Phone 952.447.9800 / Fax 952.447.4245
agreement contract. The fees are paid to the City by the developer when the contract is
executed at the time of final plat approval. These revenues are used to pay for legal
expenses 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
(CF AC) 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-down in the form of tax increment fmancing 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 supplemental revenue to finance the acquisition and purchase of new and
replacement vehicles and equipment. The long term effect of contributing occasional fund
contributions is to mitigate property tax increases and eliminate debt financing.
Building Fund - The funds within the Building Fund are reserved for future building needs.
A high priority has been established by the Council to build a new city hall, police and
community facility. Also a space needs analysis has identified that the city will require
another satellite fire station to serve the northwest section of the city that will experience
the greatest growth.
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 over sizing 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.
H: \spreadsheets\General Ledger\ Treasurer .doc
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 Fund - The Debt Service Fund represents prepayments of special assessments,
property tax collections and special levies needed to amortize 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.
H:\spreadsheets\GeneraJ Ledger\ Treasurer .doc