Loading...
HomeMy WebLinkAbout5B - August 2010 Treasurer's Report ~ox PRJo~ <" t:: ~ U trl ~ MEETING DATE: AGENDA #: PREPARED BY: PRESENTED BY: AGENDA ITEM: DISCUSSION: 4646 Dakota Street SE Prior Lake. MN 55372 CITY COUNCIL AGENDA REPORT SEPTEMBER 20,2010 5B JERIL YN ERICKSON, FINANCE DIRECTOR JERIL YN ERICKSON, FINANCE DIRECTOR CONSIDER APPROVAL OF AUGUST 2010 TREASURER'S REPORT Introduction The purpose of this agenda item is for the Council to consider approval of the monthly treasurer's report for August, 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. R:\Collncil\2010 Agenda Reports\09 2010\2010 August Treasurer Report,doc 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 August, 2010. The Treasurer's Report reflects beginning cash balance, receipts, disbursements, and the ending cash balance for each fund for the month of August, 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. 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 August, 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: IJ !U9Ust, 2010 Treasurer's Report as submitted. R.QwedJYl~ . ~\\J Frank Boyl , 'ity :v1anager , 1. City of Prior Lake August, 2010 Treasurer's Report 2. Treasurer's Report Fund Descriptions ATTAC R:\Council\2010 Agenda Reports\09 2010\2010 AlIgllst Treasllrer Report.doc City of Prior lake Treasurers Report August, 2010 Fund 8/1/2010 8/31/2010 Fund Type & Name No. Balance Receipts Disbursements Balance Business-Type Funds Water & Sewer Fund 601 $ 6,082,694.60 $ 891,004.81 $ 403,368.18 $ 6,570,331.23 Water Quality Fund 602 655,433.26 65,899.28 74,076.65 647,255.89 Transit Fund 603 1,697,891.44 52,573.00 67,220.42 1,683,244.02 Total Business-Type Funds $ 8,436,019.30 $ 1,009,477.09 $ 544,665.25 $ 8,900,831.14 Governmental-Type Funds General Fund 101 $ 7,020,758.32 $ 1,096,150.00 $ 2,013,405.85 $ 6,103,502.47 Special Revenue Funds Cable Franchise Fund 210 $ 42,080.16 $ $ $ 42,080.16 Capital Park Fund 225 149,132.55 323.75 10,896.75 138,559.55 Severance Compensation 230 412,075.00 965.08 413,040.08 EDA Special Revenue 240 101,113.47 236.81 101,350.28 Econ Dev Federal Revolving Loan Fund 250 104,725.13 245.27 104,970.40 Econ Dev MN Revolving Loan Fund 255 81,324.53 190.46 81,514.99 Developer Agreement Fund 260 812,318.38 101,226.94 711,091.44 Total Special Revenue Funds $ 1,702,769.22 $ 1,961.37 $ 112,123.69 $ 1,592,606.90 Capital Project Funds Downtown Revolving Fund 256 $ 38,104.24 $ 89.24 $ $ 38,193.48 Tax Increment 402 150,876.28 352.69 283.33 150,945.64 TIF #1-3 413 95,391.13 222.74 283.33 95,330.54 TIF #3-1 414 39,691.31 92.29 283.33 39,500.27 TIF #4-1 415 3,075.01 6.54 283.33 2,798.22 TIF #5-1 416 1,803.63 3.56 283.34 1,523.85 TIF #6-1 417 66,643.71 155.42 283.34 66,515.79 Revolving Equipment Fund 410 1,320,547.97 8,475.21 1,745.01 1,327,278.17 Building Fund 420 440,752.96 1,021.08 4,763.73 437,010.31 Revolving Park Equipment Fund 430 203,874.83 477.47 204,352.30 Construction Fund 501 469,001.93 15,171.43 271,194.01 212,979.35 Trunk Reserve Fund 502 1,311,099.06 6,066.30 4,830.44 1,312,334.92 Street Oversize Fund 503 546,028.84 1,278.79 547,307.63 Water Storage Fund 505 201,464.87 2,476.51 203,941.38 Total Capital Project Funds $ 4,888,355.77 $ 35,889.27 $ 284,233.19 $ 4,640,011.85 Debt Service Funds 5xx $ 2,401,625.38 $ 16,839.39 $ $ 2,418,464.77 Agency Fund 801 $ 203,000.00 $ 5,500.00 $ 34,500.00 $ 174,000.00 Total Governmental Type Funds $ 16,216,508.69 $ 1,156,340.03 $ 2,444,262.73 $ 14,928,585.99 Total All Funds $ 24,652,527.99 $ 2,165,817.12 $ 2,988,927.98 $ 23,829,417.13 Investment Pool & Ratio $ 24,224,253.94 101.66% This report does not reflect financial obligations from contracts, agreements, purchases, services received, etc. City of Prior Lake Treasurers Report August, 2010 Fund Type & Name Business-Type Funds Water & Sewer Fund Water Quality Fund Transit Fund Governmental-Type Funds General Fund Fund Balance Classification Unrestricted Unrestricted Unrestricted Unreserved Special Revenue Funds Cable Franchise Fund Unreserved; Designated for Capital Outlay Capital Park Fund Unreserved; Designated for Improvements Severance Compensation Reserved for Severance Compensation EDA Special Revenue Unreserved; Designated for Improvements Econ Dev Federal Revolving Loan Fund Unreserved; Designated for Development Loans Econ Dev MN Revolving Loan Fund Unreserved; Designated for Development Loans Developer Agreement Fund Unreserved; Desiqnated for Improvements 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 Debt Service Funds Agency Fund 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 Unreserved; Designated for Capital Outlay Unreserved; Unreserved; Unreserved; Unreserved; Reserved for Debt Service N/A Constraints Identified on utility bill for this purpose Identified on utility bill for this purpose Funds received for transit-related uses Cashflow, emergencies, one-time opportunities Statutory obligation to use for PEG access Contractually obligated; park dedication fees Reserved for Severance Compensation Economic Development Economic Development Economic Development Contractually obligated; Identified for downtown building fayade 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) Identified for park equipment replacement Construction projects in progress Contractually obligated by developer agreements Contractually obligated by developer agreements Contractually obligated by developer agreements Reserved for contractually obligated debt service 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 Oualitv 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. Caoital 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 Comoensation 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 Soecial 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 Redevelooment 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 Soecial 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 (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- 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. Revolvinl! Eauioment 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. Buildinl! Fund - The funds within the Building Fund are reserved for future building needs. Revolvinl! Park Eauioment 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. Agencv 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.