HomeMy WebLinkAbout2001 Audit Review April 2, 2002 City of
Oak Park Heights,
Minnesota
2001 Audit Review
April 2, 2002
HLB TAUTGES REDPATH, LTD.
a
x
J
'a
d
N
3
Reports Issued
H
Annual Financial
Report
♦ City's financial statements
♦ Independent auditor
reports on the fair
presentation of the
financial statements
♦ "Clean opinion" on the
2001 financial statements
as
a
x 3
State Legal
Compliance Report
♦ Required by Minnesota
Statute §6.65
♦ OSA established a task
force to develop audit guide
for legal compliance
Audit guide covers five
categories
1) contracting and bidding
2) deposits and investments
3) conflicts of interest
4) public indebtedness
5) claims and disbursement
♦ No compliance findings for
� 2001 based on items tested
a
x 4
Report on Internal
Control
♦ Required by audit standards
♦ Based on inquiries and
observations
♦ Identifies reportable
conditions
♦ Reportable condition
defined as "significant
deficiencies in the design or
operation of the internal control over
financial reporting that would
adversely affect the City's ability to
record, process, summarize, and
report financial data"
♦ No reportable conditions
a noted
x 5
Management Report
♦ Summary:
— General Fund:
• Fund balance decreased
$107,000 during 2001.
Budget Actual Variance
Revenue /transfers in $2,403,000 $2,298,000 ($105,000)
Expenditures /transfers out 2,375,000 2,405,000 (30,000)
Increase (decrease) in fund balance $28,000 ($107,000) ($135,000)
• Fund balance at December
31 7 2001 was $1,173,000
6
Management Report
• Fund balance at December
31 2001 was not sufficient
to fulfill all city policy reserve
requirements.
Reserve Policy Balance
Component Requirement Available
Cash flow $956,000 $956,000
Contingent employee benefits 104,161 104,161
General contingency 388,000 112,957
Increase (decrease) in fund balance $1,448,161 $1,173,118
M�
7
Management Report
$1,400,000 General Fund Monthly Cash Balances
A
$1,200,000
$1,000,000 I $861,000
decrease
$800,000
$600,000
$400,000
$200,000
$0 /1/01 1/31/01 1 2/28101 3/31/01 4/30/01 5/31/01 6/30/01 1 7/31/01 8/31/01 9/30/01 10/31/01 T 1 /30101 12/31/01
■Series) $1,301,000 $1,152,0001 $984,000 $818,000 $649,000 $508,000 $440,000 1$1,172,000 $967,000 $808,000 $698,000 1 $570,000 $1,142,0001
p
O
Management Report
Summary:
— Special Revenue Funds:
• Economic Development
fund had a fund balance of
$48,000 at year end. If sale
of Bell property occurs, the
proceeds should be
accepted in the Capital
Revolving Fund
• Forfeiture and Seizure Fund
had a fund balance of
$17,000 at year end
a
x 9
Management Report
—Debt Service Funds:
• Three bond issues
outstanding totaling $2.655
million.
• Water and Sewer Bonds of
1993 -this bond issue is
funded by transfers from the
Connection Charge Fund.
Existing connection charges
should be sufficient to fund
debt service requirements
a
x
10
Management Report
—Debt Service Funds:
• Improvement Bonds of 2001
- this bond issue is projected
to have a surplus of $52,000
at final bond maturity (2005).
City may be able to cancel a
portion of the 2005 tax levy.
• Improvement Bonds of 1998
- this bond issue matures in
2014. Debt service is funded
by special assessments and
connection charges. Existing
connection charges should
be sufficient to fund debt
service requirements.
a
x ��
Management Report
— Capital Proiect Funds:
• A comparison of fund balance
of all Capital Project Funds is
as follows:
December 31, Increase
Fund 2000 2001 (Decrease)
Capital Revolving $438,392 $258,296 ($180,096)
Budgeted Projects and Equipment Revolving 53,834 47,618 (6,216)
57th Street/Oakgreen extension 30,632 - (30,632)
SuperamericaNalvoline Oil 1,311 1,960 649
Park Development 302,359 320,406 18,047
St. Croix Mall (TIF) 91,663 - (91,663)
Street Reconstruction 334,855 367,317 32,462
Deep Well #3 (1,153) (668) 485
Renewal and Replacement 1,599,177 1,830,661 231,484
• Central Business District (12,866) (190) 12,676
Brekke Park Memorial 777 824 47
AAE - Kern Center 30 8,260 8,230
AAE - Brackey - Oak Park Pond (22,417) - 22,417
AAE - Brackey - Outlots A & B 22,336 - (22,336)
AAE - 58th Street Improvement - Phase III 32,452 4,201 (28,251)
AAE - First Student 3,099 - (3,099)
AAE - Sanitary Sewer Connection 362,829 357,804 (5,025)
AAE - Water Connection 280,662 203,804 (76,858)
AAE - Storm Sewer Connection 541,815 554,867 13,052
Totals $4,059,787 $3,955,160 ($104,627)
AP1
12
Management Report
— Capital Project Funds:
• Capital Revolving Fund -
fund balance decreased by
$180,000 during the year.
Assets of this fund at
December 31, 2001
consisted of:
—cash $295,000
— assessments 163,000
*total $458,000
a
x 13
Management Report
— Capital Proiect Funds:
• Connection Charge Funds -
a summary is as follows:
Sanitary Water Storm
Sewer Works Water Total
Fund balance - December 31, 2001 $357,804 $203,804 $554,867 $1,116,475
Future connection charges 286,000 499,000 632,000 1,417,000
Subtotal 643,804 702,804 1,186,867 2,533,475
Debt service commitments:
Bonds of 1993 (55,000) (310,000) - (365,000)
Bonds of 1998 (329,260) (114,100) (208,640) (652,000)
Uncommitted $259,544 $278,704 $978,227 $1,516,475
• Park Development Fund -
fund balance increased by
$18,000 during the year. The
fund balance was $320,000
at December 31, 2001.
I �
Ir•� 14
Management Report
— Capital Project Funds:
• Renewal and Replacement
Fund - fund balance
increased by $230,000 during
the year. The fund balance
was $1.83 million at
December 31, 2001.
• Street Reconstruction Fund -
fund balance was $367,000
at December 31, 2001.
These monies will provide
partial financing for the next
phase of street
reconstruction.
a�
a
x 15
Management Report
— Enterprise F
• Water operations reflected
operating income for 2001
of $27,000
• Sewer operations reflected
an operating loss for 2001
of $5,000
• Sanitation operations are
subsidized by the General
fund. The 2001 transfer
was $83,000
• Storm Sewer operations
reflected an operating
income for 2001 of $6,000
a
Z 16
Management Report
- Other:
• The City experienced an
overall collection rate of
99% for special
assessments in 2001.
• The City has an excellent
property tax collection rate -
99% for 2001.
• Significant changes in
accounting and financial
reporting will be required by
2004 (GASB 34)
a
x 17
Management Report
Tax Rates and Tax Capacity
2000 2001 2002
Market value $325,495,900 $324,581,100 $349,905,900
Tax capacity values:
Real estate $6,571,300 $7,249,830 $5,085,897
Personal property 120,574 120,220 77,543
Subtotal 6,691,874 7,370,050 5,163,440
Fiscal disparity contribution (784,872) (918,384) (611,097)
Fiscal disparity distribution 298,275 343,723 221,368
Total $6,205,277 $6,795,389 $4,773,711
Tax capacity rates 23.620 23.692 41.741
Tax levy $1,440,200 $1,588,435 $1,967,579
Market Value I x Class Rate = I Tax Capacity
18
Management Report
Tax Rates and Tax Capacity
Perc 4paci
Decre
Property Classification Market Value Class Rate Tax Ca aci in Tax C
Residential Homestead $150,000 1st $76,000 - 1.00% $1,981
Remainder - 1.65%
Residential Homestead $500,000 1st $76,000 - 1.00% $7,756
Remainder - 1.65%
Commercial $500,000 1st $150,000 - 2.40% $11,900
Remainder - 3.40%
Commercial $1,500,000 1st $150,000 - 2.40% $49,500
Remainder - 3.40%
Residential Homestead $150,000 1st $500,000 - 1.00% $1,500 24%
Remainder - 1.25%
Residential Homestead $500,000 1st $500,000 - 1.00% $5,000 35%
Remainder - 1.25%
Commercial $500,000 1 st $150,000 - 1.50% $9,250 22%
Remainder - 2.00%
Commercial $1,500,000 1st $150,000 - 1.50% $29,250 40%
Remainder - 2.00%
Percent of Total
City Tax Capacity
• Taxpayer 1999 2000 2001
Xcel Energy, Inc. 55.3% 53.1% 36.7%
SC Mall, LLC 5.2% 5.3% 4.4%
• KTJ Limited Partnership Eleven 5.0% 5.3% 4.2%
Menards, Inc. 3.6% 3.5% 2.8%
Wal -Mart Real Estate Business 2.4% 2.4% 1.9%
F�
M-� 19
Management Report
Tax Rates and Tax Capacity
Tax Levy _ I Tax Capacity = I Tax Rate
a b c d e
(a x b) (c x d)
Market Class Tax Tax City
Value Rate Capacity Rate Tax
Market Tax Tax City Percent
Pro e T e Value Capacity Rate Tax Increase
Residential Homestead $150,000 $1,981 23.692 $469
Residential Homestead 500,000 7,756 23.692 1,837
Commercial 1,500,000 49,500 23.692 11,727
Residential Homestead 150,000 1,500 41.741 626 33%
Residential Homestead 500,000 5,000 41.741 2,087 13%
Commercial 1,500,000 29,250 41.741 12,209 4%
F�
�i 20