HomeMy WebLinkAboutOther Auditor Reports 12/31/2005CITY OF LINO LAKES, MINNESOTA
OTHER AUDITOR REPORTS
YEAR ENDED DECEMBER 31, 2005
CITY OF LINO LAKES, MINNESOTA
TABLE OF CONTENTS
DECEMBER 31, 2005
Page
—
IIMEr
Report on Internal Control over Financial Reporting
and on Compliance and Other Matters Based on an
Audit of Financial Statements Performed in Accordance
with Governmental Auditing Standards 1 -2
Report on Minnesota Legal Compliance 3
Other Required Auditor Communications 4 -6
Management Letter 7 -11
MOP
,A
Vow
Lars( nAllen`
CPAs, (:un,u!tants & \. I,i,or,
www.larsonallen.com
REPORT ON INTERNAL CONTROL OVER FINANCIAL REPORTING
AND ON COMPLIANCE AND OTHER MATTERS BASED ON
AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN
ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS
Honorable Mayor and
Members of the City Council
City of Lino Lakes, Minnesota
We have audited the financial statements of the governmental activities, the business -type activities,
each major fund, and the aggregate remaining fund information of the City of Lino Lakes, Minnesota as
of and for the year ended December 31, 2005, which collectively comprise the City's basic financial
statements and have issued our report thereon dated March 24, 2006. We conducted our audit in
accordance with U.S. generally accepted auditing standards and the standards applicable to financial
audits contained in Government Auditing Standards, issued by the Comptroller General of the United
States.
Internal Control Over Financial Reporting
In planning and performing our audit, we considered the City of Lino Lakes, Minnesota's internal control
over financial reporting in order to determine our auditing procedures for the purpose of expressing our
opinion on the financial statements and not to provide an opinion on the internal control over financial
reporting. Our consideration of the internal control over financial reporting would not necessarily
disclose all matters in the internal control over financial reporting that might be a material weakness. A
material weakness is a reportable condition in which the design or operation of one or more of the
internal control components does not reduce to a relatively low level the risk that misstatements caused
by error or fraud in amounts that would be material in relation to the financial statements being audited
may occur and not be detected within a timely period by employees in the normal course of performing
their assigned functions. We noted no matters involving the internal control over financial reporting and
its operations that we consider to be material weaknesses.
Compliance and Other Matters
As part of obtaining reasonable assurance about whether the City of Lino Lakes, Minnesota's financial
statements are free of material misstatement, we performed tests of its compliance with certain
provisions of laws, regulations, contracts, and grant agreements, noncompliance with which could have
a direct and material effect on the determination of financial statement amounts. However, providing an
opinion on compliance with those provisions was not an objective of our audit and, accordingly, we do
not express such an opinion. The results of our tests disclosed no instances of noncompliance or other
matters that are required to be reported under Govemment Auditing Standards.
(1)
Larson, .\Ilcn, \ \'ei,hair & Co., LLP I An Indepcndcnr Member of Baker Tills International
We also noted certain additional matters that were reported to the management of the City of Lino
Lakes, Minnesota in a separate letter dated March 24, 2006.
This report is intended solely for the information and use of the audit committee, management, the
Office of the State Auditor, and federal awarding agencies and pass- through entities and is not intended
to be and should not be used by anyone other than these specified parties.
Austin, Minnesota
March 24, 2006
'mi ,— GL'
LARSON, ALLEN, WEISHAIR & CO., LLP
(2)
Lars nAllenV
CPAs, (. nsultants & Advisors
www.larsonallen.com
REPORT ON MINNESOTA LEGAL COMPLIANCE
Honorable Mayor and
Members of the City Council
City of Lino Lakes, Minnesota
We have audited the financial statements of the City of Lino Lakes, Minnesota as of and for the year
ended December 31, 2005, and have issued our report thereon dated March 24, 2006.
We conducted our audit in accordance with U.S. generally accepted auditing standards, the standards
applicable to financial audits contained in Governmental Auditing standards, issued by the Comptroller
General of the United States, and the provisions of the Minnesota Legal Compliance Audit Guide for
Local Govemment, promulgated by the State Auditor pursuant to Minnesota Statute 6.65. Accordingly,
the audit included such tests of the accounting records and such other auditing procedures as we
considered necessary in the circumstances.
The Minnesota Legal Compliance Audit Guide for Local Govemment covers seven main categories of
compliance to be tested: contracting and bidding, deposits and investments, conflicts of interest, public
indebtedness, claims and disbursements, miscellaneous provisions, and tax increment financing. Our
study included all of the listed categories.
The results of our tests indicate that, with respect to the items tested, the City of Lino Lakes, Minnesota
complied with the material terms and conditions of applicable legal provisions referred to in the
preceding paragraph.
This report is intended solely for the use of the City of Lino Lakes, Minnesota, the Office of the State
Auditor, and other state agencies, and is not intended to be and should not be used by anyone other
than these specified parties.
Austin, Minnesota
March 24, 2006
LARSON, ALLEN, WEISHAIR & CO., LLP
(3)
I.arvnn.. \Ilex., \ \e hair & Co, 1.1-1' 1 . \n Independent \lembcr of Rakcr'1 Ili Intirnarion31
Vow
Mow
Lars nAllen
CPAs, Consultants & Advisors
www.larsonallen.com
OTHER REQUIRED AUDITOR COMMUNICATIONS
Honorable Mayor and
Members of the City Council
City of Lino Lakes, Minnesota
Dear Committee Members:
We have audited the financial statements of the City of Lino Lakes for the year ended December 31,
2005, and have issued our report thereon dated March 24, 2006. Professional standards require that
we provide you with the following information related to our audit.
Our Responsibility Under U.S. Generally Accepted Auditing Standards
As stated in our engagement letter dated December 28, 2005, our responsibility, as described by
professional standards, is to plan and perform our audit to obtain reasonable, but not absolute,
assurance that the financial statements are free of material misstatement and are fairly presented in
accordance with U.S. generally accepted accounting principles. Because an audit is designed to
provide reasonable, but not absolute assurance and because we did not perform a detailed examination
of all transactions, there is a risk that material misstatements may exist and not be detected by us.
As part of our audit, we considered the internal control of the City of Lino Lakes. Such considerations
were solely for the purpose of determining our audit procedures and not to provide any assurance
concerning such intemal control.
Other Information in Documents Containing Audited Financial Statements
Our responsibility for other information in documents containing the City of Lino Lakes financial
statements, including the supplementary information, does not extend beyond the information identified
in our report on the financial statements, and we have no professional responsibility to perform audit
procedures on such other information.
Significant Accounting Policies
-- Management has the responsibility for selection and use of appropriate accounting policies. In
accordance with the terms of our engagement letter, we will advise management about the
appropriateness of accounting policies and their application. The significant accounting policies used
by the City of Lino Lakes are described in Note 1 to the financial statements. No new accounting
policies were adopted and the application of existing policies was not changed during 2005. We noted
no transactions entered into by the City during the year that were both significant and unusual, and of
which, under professional standards, we are required to inform you, or transactions for which there is a
lack of authoritative guidance or consensus.
(4)
I.ars■n„ Ailcn, ACehh■ir & Cu., LIT I kn Indepcndenr Slember of Baker I iII Inrcrnati,mai
Accounting Estimates
Accounting estimates are an integral part of the financial statements prepared by management and are
based on management's knowledge and experience about past and current events and assumptions
about future events. Certain accounting estimates are particularly sensitive because of their significance
to the financial statements and because of the possibility that future events affecting them may differ
significantly from those expected. The most sensitive estimates affecting the financial statements were:
Annual depreciation is provided using rates sufficient to fully depreciate the related capital assets
over their useful lives based on past experiences.
The year end valuation of investments at fair value.
The City has recognized a liability for earned sick leave benefits. The amount recorded includes
amounts earned through December 31, 2005 by employees eligible for retirement at that date. In
addition, an amount is recorded for those individuals not eligible for retirement at December 31,
2005, but for whom pay -out of the amount earned to that date is reasonably expected. This
estimate is derived by an analysis of the pay -out history and current and anticipated future
employment conditions.
We evaluated the key factors and assumptions used to develop the above estimates in determining that
it is reasonable in relation to the financial statements taken as a whole.
Audit Adiustments
For purposes of this letter, professional standards define an audit adjustment as a proposed correction
of the financial statements that, in our judgment, may not have been detected except through our
auditing procedures. An audit adjustment may or may not indicate matters that could have a significant
effect on the City's financial reporting process (that is, cause future financial statements to be materially
misstated). In our judgment, none of the adjustments we proposed, whether recorded or unrecorded by
the City, either individually or in the aggregate, indicate matters that could have a significant effect on
the City's financial reporting process.
Management did not identify and we did not notify them of any uncorrected financial statement
misstatements.
Disagreements with Management
For purposes of this letter, professional standards define a disagreement with management as a matter,
whether or not resolved to our satisfaction, concerning a financial accounting, reporting, or auditing
matter that could be significant to the financial statements or the auditors' report. We are pleased to
report that no such disagreements arose during the course of our audit.
Consultations with Other Independent Accountants
In some cases, management may decide to consult with other accountants about auditing and
accounting matters, similar to obtaining a "second opinion" on certain situations. If a consultation
involves application of an accounting principle to the governmental unit's financial statements or a
determination of the type of auditors' opinion that may be expressed on those statements, our
professional standards require the consulting accountant to check with us to determine that the
consultant has all the relevant facts. To our knowledge, there were no such consultations with other
accountants.
(5)
Now
Iwo
IMO
Vino
Issues Discussed Prior to Retention of Independent Auditors
We generally discuss a variety of matters, including the application of accounting principles and auditing
standards, with management each year prior to retention as the City's auditors. However, these
discussions occurred in the normal course of our professional relationship and our responses were not
a condition to our retention.
Difficulties Encountered in Performing the Audit
We encountered no significant difficulties in dealing with management in performing our audit.
This information is intended solely for the use of the Finance Committee, Board of Directors, and
management of the City of Lino Lakes and is not intended to be, and should not be used by anyone
other than these specified parties.
Austin, Minnesota
March 24, 2006
4.1e Z4 r
LARSON, ALLEN, WEISHAIR & CO., LLP
(6)
Lars( nAller"
CPAs, Consultants & Advisors
www.larsonallen.com
Honorable Mayor and
Members of the City Council
City of Lino Lakes, Minnesota
In planning our audit of the financial statements of the City of Lino Lakes for the year ended
December 31, 2005, we considered its internal control in order to determine our auditing procedures for
the purpose of expressing our opinion on the financial statements and not to provide assurance on the
internal control.
We noted no matters involving internal control and its operation that we consider to be reportable
conditions under standards established by the American Institute of Certified Public Accountants.
Reportable conditions involve matters coming to our attention relating to significant deficiencies in the
design or operation of the internal control that, in our judgment, could adversely affect City's ability to
initiate, record, process, and report financial data consistent with the assertions of management in the
financial statements.
A material weakness is a reportable condition in which the design or operation of one or more of the
internal control components does not reduce to a relatively low level the risk that errors or fraud in
amounts that would be material in relation to the financial statements being audited may occur and not
be detected within a timely period by employees in the normal course of performing their assigned
functions
Our consideration of intemal control would not necessarily disclose all matters in internal control that
might be reportable conditions and, accordingly, would not necessarily disclose all reportable conditions
that are also considered to be material weaknesses as defined above.
During the course of our audit, several items came to our attention that we feel could be addressed by
the City of Lino Lakes to more efficiently run the City's operations or improve its internal controls. We
herein submit the following suggestions to the City of Lino Lakes for their consideration.
Auditor Comments:
Capital Project Deficits
The financial statements for the capital project funds are presented in Statements 3, 5, 12 and 13 of the
2005 Annual Financial Report. As of December 31, 2005, five of the capital project funds have deficit
fund balances equaling a combined deficit of $859,840. This compares to six capital project funds with
a combined deficit fund balance of $1,195,975 as of December 31, 2004. The most significant
remaining deficit is in the Dedicated Parks fund in the amount of $734,870.
While we recognize the significant improvements made related to fund balance deficits since fiscal year
2003, we urge the City to continue its review of capital projects as they progress. Plans should be made
to address projected deficits as they are identified.
(7)
Lan;on. Allen, ACeishair & Cu.. 1.1.1' I ,.n Independent A-lembcr of Baker "filly International
SAC Revolving
The SAC Revolving Fund was established in 1990 to account for a refund from the MCES (formerly
MWCC) of past SAC charges which were paid by residents that had not hooked up to the sewer
system.
A summary of financial activity of this fund is as follows:
Prior
Years 2005 Total
Revenue
SAC refund $ 368,816 $ - $ 368,816
Investment earnings 253,541 9,614 263,155
Total revenue 622,357 9,614 631,971
Expenditures:
Refunds $ 257,808 $ 2,186 259,994
Fund balance - December 31, 2005 $ 371,977
The City is allowing current homeowners to request a refund with 4% interest. If refunds and claims are
not submitted, the City will pay the full SAC charge from this fund at the time of hook -up. This policy will
likely require a supplemental future revenue source as the current MCES SAC charges times the
potential hookups exceeds the available balance.
If the MCES SAC fees continue to increase at a rate that is faster than the investment earnings rate,
other revenue sources will be needed in the future to fund the actual connections when they occur.
Area and Unit Charge Fund
On January 11, 1988, the City Council approved Resolution 1 -88, which established the Area and Unit
Charge Fund for the City. The purpose of this fund is to collect various area and unit charges to be used
to meet debt payments. Before October 1 of each year, the City estimates the required transfer needed
to meet debt payments for the subsequent year. In December, these estimated amounts are transferred
to the various debt funds. We recommend that the City continue to closely monitor actual versus
projected area and unit assessment collections to assure that debt payment requirements will be met.
Designations of balances required for debt service is necessary to define discretionary construction
balances available to the City. The financing plan for the following bond issues have pledged area and
unit charges for the repayment of debt service:
• Improvement and Utility Bonds of 2004A
• Improvement Refunding Bonds of 1999A
• Water Revenue Bonds of 1999B
• Water Revenue Bonds of 1996B
The Improvement and Utility Bonds of 2004A and Improvement Refunding Bonds of 1999A have future
debt service requirements (principal and interest) totaling $1,744,719 and $363,342, respectively.
During 2005, a transfer of $383,000 was made to the Improvement Refunding Bonds of 1999A debt
service fund.
mrmll
(8)
The Water Revenue Bonds of 1999B and 1996B have future debt service requirements totaling
$349,114 and $2,572,441 (principal and interest). The City annually transfers amounts from the Area
and Unit Charge Fund to the Water Fund sufficient to help cover the debt services of these bonds.
During 2005, a transfer of $304,195 was made to the Water Fund. It is the City's intention to repay the
Water Revenue Bonds of 1999B and 1996B with revenues of the Water Fund. If revenues are not
sufficient to meet the debt requirements, funds will be transferred from the Area and Unit Charge Fund.
In addition to the transfers above, the Area and Unit Charge Fund transferred $444,785 to the
Improvement Refunding Bonds of 2003A Fund for debt service requirements, $155,069 to Legacy
Woods Edge Improvement Fund for the Legacy at Woods Edge project, and $205,500 to Municipal
State Aid Fund for the Elm Street Reconstruction project.
DEBT SERVICE FUNDS
Debt service funds are a type of governmental fund used to account for the accumulation of resources
for the payment of principal and interest on general obligation debt (other than enterprise fund debt).
Debt service funds may have one or a combination of revenue sources pledged to retire debt including
property taxes, tax increments, special assessments and area and unit charges.
- The diverse nature of the type of debt included in the same fund type requires careful analysis to
determine the adequacy of the fund balance and projected fund balance. The following schedule
extracts information from Exhibits 1, 2 and 3 of the 2005 Annual Financial Report to assist in this
analysis. The following schedule compares outstanding debt with assets pledged for debt retirement.
This comparison provides a means to judge (at least on a preliminary basis) the financial position of
each individual debt service fund.
Man
December 31, 2005 Scheduled Total Remaining
Fund Deferred Property Resources Debt Service
Fund Description Balance Revenue Total Taxes Available Scheduled
- General Debt:
Certificates of Indebtedness $ 95,399 $ 4,285 $ 99,684 $ 477,785 $ 477,785 $ 455,033
Lease Revenue Bonds of 1998A 893,418 4,854 898,272 5,863,379 6,761,651 6,267,512
Public Project Revenue Bonds 1999C 342,041 1,992 344,033 248,126 592,159 549,223
$ 1,330,858 $ 11,131 $ 1,341,989 $ 6,589,290 $ 7,831,595 $ 7,271,768
Special Assessment Debt:
Improvement Bonds of 1998A $ 2,551,966 $ 190,541 $ 2,742,507 $ - $ 2,742,507 $ 3,534,475
Improvement Bonds of 1998B 1,687,599 263,378 1,950,977 1,396,515 3,347,492 1,792,104
Refunding Imp. Bonds of 1999A 3,702 818 4,520 290,270 294,790 363,342
Improvement Bonds of 2002A 516,188 117,423 633,611 51,595 685,206 501,449
Improvement Bonds of 2002B 513,443 1,336,776 1,850,219 - 1,850,219 2,161,041
.. Improvement Bonds of 2003A 297,981 319,625 617,606 - 617,606 1,928,334
Improvement Bonds of 2003B 102,848 49,278 152,126 198,105 350,231 311,530
Improvement Bonds of 2004A 332,641 416,150 748,791 1,891,136 2,639,927 1,744,719
Improvement Bonds of 2005A 37,712 5,090,691 5,128,403 8,555,411 13,683,814 8,148,010
Refunding Imp. Bonds of 2005B 7,552 7,552 4,863,519 4,871,071 4,631,923
$ 6,051,632 $ 7,784,680 $ 13,836,312 $ 17,246,551 $ 31,082,863 $ 25,116,927
Note: Deferred revenue in the above table does not include the future scheduled "interest portion" of the
adopted assessment rolls. The 1999A and 2004A Improvement Bonds also include a pledge from the
Area and Unit Fund that has not been included above.
The above table provides a means for the monitoring the status of the debt service funds. For the
General Debt funded solely by property taxes, it appears that there are adequate planned levies to retire
the debt when the future lease revenues scheduled to be received from the school district are included.
(9)
DEBT SERVICE FUNDS (Continued)
While in total the City has a surplus of total resources available over remaining scheduled debt service
based on the calculation above, certain individual funds are operating at a deficit. These deficits will
need to be funded by future adopted assessment rolls, special assessment levies, investment earnings,
transfers from other funds, property taxes or other available means.
Factors to consider when analyzing debt service funds:
• Are all the anticipated assessment rolls being adopted as soon as appropriate?
• Have all the planned financing sources been identified, such as pledged amounts from the area and
unit fund or future MSA funds?
• Are there significant "prepayments" received from property owners? In the current investment
environment, will the earnings the City will receive on these prepayments be lower than the interest
rate that was being charged on the adopted assessment roll?
We recommend that all Debt Service Funds of the City be reviewed at least annually by applying the
above criteria.
The Area & Unit Fund is committed to the debt service of some special assessment bonds as well as
toward the water revenue bonds. We recommend that the City determine the full commitment of the
Area and Unit Fund whenever this fund is used to pledge toward future bond issues and construction
projects.
Budget Appropriations
Each year the City adopts an annual budget for the general fund. Each department receives an
appropriation based upon detailed budget estimates for individual expenditure accounts. Department
heads have the ability to transfer appropriations within a department. This can be helpful and improves
flexibility in meeting department needs as they change during the year. However, such a policy can
lead to unnecessary or unauthorized expenditures. For example, equipment purchases.
We suggest the City review this policy and consider adding controls on the amounts that can be
transferred within a department without bringing it to the City Council for approval. These controls could
include dollar limits, restrictions on the types of purchases or getting the approval of someone in
administration.
Developer Escrow Accounts
The City maintains an Agency Fund to account for the activity related to developer escrows. It is our
understanding that developers deposit an escrow prior to a project beginning and that certain costs may
be applied against this escrow. We noted that there are several escrow accounts that carry a "negative"
balance, which represents an additional receivable balance from the developer. We recommend that
the City monitor these escrow balances and if they go negative that the developer be contacted so that
an additional deposit can be made.
Conclusion
We welcome the opportunity to discuss the points mentioned in this letter or any other accounting and
procedural issues in order to coordinate our efforts with you, the mutual objective being the
development of more effective accounting procedures for the City. We understand that some of the
aforementioned points are in the process of implementation or may already have been implemented;
however, these points art noted so that effective follow -up can be accomplished.
(10)
We sincerely appreciate all the courtesies and cooperation extended to us by you and the staff of the
City, and thank you for the opportunity to be of service to you. We look forward to working with you in
the future.
This report is intended solely for the information and use of the City, management, the City Council and
others within the administration and is not intended to be and should not be used by anyone other than
these specified parties.
Austin, Minnesota
March 24, 2006
i
r.
•..
ti •
MIIIII
fe;■--afi GG/'
LARSON, ALLEN, WEISHAIR & CO., LLP