HomeMy WebLinkAboutOther Auditor Reports 12/31/2004CITY OF LINO LAKES, MINNESOTA
OTHER AUDITOR REPORTS
YEAR ENDED DECEMBER 31, 2004
CITY OF LINO LAKES, MINNESOTA
TABLE OF CONTENTS
DECEMBER 31, 2004
Page
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
WNW
WRNS
LarsonAiled
CPAs, Consultants & Advisors
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, 2004, which collectively comprise the City's basic financial
statements and have issued our report thereon dated March 18, 2005. We conducted our audit in
- accordance with U.S. generally accepted auditing standards and the standards applicable to financial
audits contained in Govemment 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 intemal control over financial
• reporting. Our consideration of the intemal 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
intemal 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.
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 18, 2005.
(1)
Larson, Allen, Weishair & Co., LLP 1 An Independent Member of Baker Tilly International
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 18, 2005
aze,440A. ddre.i; 1
LARSON, ALLEN, WEISHAIR & CO., LLP
(2)
leiwr
LarsonAlleIT
CPAs, Consultants & 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, 2004, and have issued our report thereon dated March 18, 2005.
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 six main categories of
compliance to be tested: contracting and bidding, deposits and investments, conflicts of interest, public
indebtedness, claims and disbursements, and miscellaneous provisions. Our study included all of the
listed categories.
Mow
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.
Ism
Austin, Minnesota
March 18, 2005
LARSON, ALLEN, WEISHAIR & CO., LLP
(3)
Larson, Allen, Weishair & Co., LLP 1 An Independent Member of Baker Tilly International
WINN
LarsonAllen'
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,
2004, and have issued our report thereon dated March 18, 2005. 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 20, 2004, 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.
MEM
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 2004. 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)
Larson, Allen, Weishair & Co., LLP I An Independent Member of Baker Tilly International
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, 2004 by employees eligible for retirement at that date. In
addition, an amount is recorded for those individuals not eligible for retirement at December 31,
2004, 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 Adjustments
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)
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 18, 2005
LARSON, ALLEN, WEISHAIR & CO., LLP
(6)
LarsonAlleff
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, 2004, 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
IMMO
Our consideration of internal 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
2004 Annual Financial Report. As of December 31, 2004, six of the capital project funds have deficit
fund balances equaling a combined deficit of $1,195,975. This compares to eight capital project funds
with a combined deficit fund balance of $5,553,381 as of December 31, 2003. A significant portion of
this prior year deficit was eliminated during 2004 through operating transfers as well as proceeds from
the sale of the Town Center property. The remaining deficits are in Tax Increment funds or related to
new projects in the start up phase where it is not unusual to have a deficit balance.
We commend the City for addressing these deficits and 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)
Larson, Allen, Weishair & Co., LLP 1 An Independent Member of Baker Tilly 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 2004 Total
Revenue
SAC refund $ 368,816 $ $ 368,816
Investment earnings 249,891 3,650 253,541
Total revenue 618,707 3,650 622,357
Expenditures:
Refunds 252,408 5,400 257,808
Fund balance - December 31, 2004 $ 364,549
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,778,185 and $753,423, respectively.
During 2004, a transfer of $270,000 was made to the Improvement Refunding Bonds of 1999A debt
service fund.
(8)
The Water Revenue Bonds of 1999B and 1996B have future debt service requirements totaling
$461,909 and $2,876,636 (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 2004, a transfer of $303,108 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.
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 2004 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.
December 31, 2004
Fund Deferred
Fund Description Balance Revenue
General Debt:
Certificates of Indebtedness
Lease Revenue Bonds of 1998A
99C Public Project Revenue Bonds
Special Assessment Debt:
Improvement Bonds of 1998A
Improvement Bonds of 19988
Refunding Imp. Bonds of 1999A
Improvement Bonds of 2002A
Improvement Bonds of 2002B
Improvement Bonds of 2003A
Improvement Bonds of 20038
Improvement Bonds of 2004A
Remaining
Debt Service
Total Scheduled
86,370 $ 4,513 $ 90,883
871,231 4,801 876,032
337,961 1,999 339,960
$ 1,295,562 $ 11,313 $ 1,306,875
$ 1,314
356,523
3,173
397,414
503,628
276,740
76,623
96,416
$ 1,711,831
$ 205,394
297,414
7,824
174,114
1,460,151
294,724
57,855
627,578
$ 3,125,054
$ 206,708
653,937
10,997
571,528
1,963,779
571,464
134,478
723,994
$ 4,836,885
Scheduled
Property
Taxes
606,277 636,591
6,693,590 6,195,904
680,744 374,767
7,980,611 $ 7,207,262
3,963,975 $
1,981,856 1,547,587
753,423 708,669
613,489 53,142
2,428,025
2,416,084
323,383 198,105
1,778,185 1,891,136
$ 14,258,420 4,398,639
Final
Maturity
Date
12/31/07
02/01/19
02/01/10
02/01/15
02/01/15
02/01/06
02/01/13
02/01/13
02/01/19
02/01/14
02/01/20
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)
Schedule of Special Assessment Debt:
Total resources available
+ Scheduled property tax levies
4,836,885
4,398,639
$ 9,235,524
- Debt Service 14,258,420
Deficit in scheduled funding (at 12/31/04) $ (5,022,896)
This deficit 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.
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 are 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.
-00---,e4:04,-..--
LARSON, ALLEN, WEISHAIR & CO., LLP
Austin, Minnesota
March 18, 2005