HomeMy WebLinkAboutAudit Review April 28, 2009 2008 Audit Review
Cit y of Oak Park Heights, Minnesota
April 28, 2009
David J. Mol, CPA
Member of ItLB'tnternational
Reports Issued
♦ Opinion on financial statements
♦ Report on Compliance with Minnesota Statutes
♦ Report on Internal Control
♦ Management / Audit Committee Letter
r
Member of HLB International 2 S Tautgss RsdpatH� Ltd_
Annual Financial Report
♦ The financial statements are the responsibility of
management
♦ The role of the Independent Auditor is to report on
the fair presentation of the financial statements
♦ Audit standards followed:
— GAAS
— GAGAS
♦ "Clean opinion" on the 2008 financial statements
Member of Hk.B International � � Tsutass Ftsdps�r, L.,'td.
Financial Results
Governmental Business -type
Activities Activities
Program Revenue :
Charges for services 503,000 1,207,000
Operating grants and contributions 91,000 -
Capital grants and contributions 10,000 -
total program revenue 604,000 1,207,000
Program Expenses (3,984,000) (1,136,000)
Net expenses funded by property taxes and other sources (3,380,000) 71,000
Property taxes 3,261,000 -
Unrestricted grants 57,000 -
Investment income 607,000 43,000
Other 43,000 -
Abatement of property taxes (115,000) -
Interfund transfers 432,000 (432,000)
Total general revenues 4,285,000 (389,000)
Increase in net assets $905,000 ($318,000)
Member of HLB Intemationai 4 M a e Tautgas Rscipatti, Ltd.
Budget Performance
♦ General Fund
Budqet Actual Variance
Revenue $3,986,000 $4,006,000 $20,000
Expenditures 3,119,000 3,085,000 34,000
Revenue over expenditures 867,000 921,000 54,000
Other financing sources (uses):
Transfers in - 47,000 47,000
Transfers out (867,000) (867,000) -
Net change in fund balance $0 $101,000 $101,000
Member.o€ HLEVInternatiortai Tsutpss #tr►dpsth. L,mtd.
General Fund Reserves
General Fund Balance
December 31,
2007 2008
Designated for:
Cash flow $1 $1
Contingent employee benefits 183 188
General contingency 595,000 542,000
Subtotal - designated 2 2
Undesignated 39 345
Total fund balance $2 $2,616
Member of HLB International
6 Tautg ®s R®dpat* Ltd_
Debt Service Funds
City of Oak Park Heights, Minnesota
Projection of Cashflow
General Obligation Improvement Bonds of 1998
Total
Cash Balance Property Special Other Investment Projected Debt Other Cash Balance
Year January 1 Taxes Assessments Receipts Interest Receipts Payments Disbursements December31
2008 $ - $ - $ - $242,303 $7,457 $249,760 $122,513 $ - $127,247
2009 127,247 352,800 - - 2,450 355,250 380,026 - 102,471
2010 102,471 372,400 - - 2,050 374,450 391,650 - 85,271
2011 85,271 382,200 - - 1,775 383,975 392,526 - 76,720
2012 76,720 392,000 - - 1,658 393,658 403,030 - 67,348
2013 67,348 401,800 - - 1,529 403,329 412,845 - 57,832
2014 57,832 411,600 - - 1,401 413,001 422,018 - 48,815
2015 48,815 421,400 - - 1,289 422,689 430,418 - 41,086
2016 41,086 431,200 - - 1,208 432,408 438,000 - 35,494
2017 35,494 441,000 - - 1,167 442,167 449,720 - 27,941
2018 27,941 450,800 - - 1,093 451,893 460,470 - 19,364
2019 19,364 460,600 - - 1,005 461,605 470,346 - 10,623
2020 10,623 475,300 - - 935 476,235 484,324 - 2,534
2021 2,534 490,000 - - 889 490,889 496,724 - (3,301)
2022 (3,301) 504,700 - - 887 505,587 513,125 - (10,839)
2023 (10,839) 519,400 - - 850 520,250 533,325 - (23,914)
2024 (23,914) 534,100 - - 713 534,813 551,922 - (41,023)
2025 (41,023) 548,800 - - 489 549,289 578,882 - (70,616)
2026 (70,616) 563,500 - - 40 563,540 598,512 - (105,588)
2027 (105,588) 583,100 - - - 583,100 611,200 - (133,688)
2028 48,815 607,600 - - 2,819 610,419 636,840 - 22,394
Total $9,344,300 $0 $242,303 $31,704 $9,618,307 $9,778,416 $0
Member of HLR International, T'�utp�a R�dPath. Ltd.
Capital Project Funds
December 31, Increase
Fund I 2007 2008 (Decrease) Comments
Capital Revolvinq 1 $791,554 1 $820,496 $28,942
Budgeted Projects and Equipment Revolving 931,631 794,248 (137,383) see later comments
Park Development 1 485,002 1 485,8531 851 1
Street Reconstruction 1 951,872 1,317,841 365,969 1Received $320,000 from General Fund
Receives annual transfer from Water and
Renewal and Replacement I 3,243,027 3,559,002 315,975 Sewer in amount equal to depreciation
Brekke Park Memorial 1 368 384 161
Water Tower Rental $112,113 transfer to Water Tower rehab in
86,590 _
(86, 590) 2008
City Hall Improvements 1 - 1 5,840,475 5,840,475 1$6.3M bonds issued in 2008
Received transfer from Water Utility ($178,847)
Water Tower Rehabilitation (214,813) 80,153 294,966 and Water Tower Rental ($112,113)
Storm Sewer Renewal and Replacement - 1 78,000 78,000 1 New fund for 2008.
$138,875 transfer to 1998 Bonds Debt Service
Sanitary Sewer Connection 479,286 356,564 (122,722) Ito prepay bonds
$48,125 transfer to 1998 Bonds Debt Service
Water Connection 718,130 699,852 (18,278) to prepay bonds
$88,000 transfer to 1998 Bonds Debt Service
Storm Sewer Connection 915,153 864,247 (50,906) to prepay bonds
Well Rehabilitation 24,950 32,268 7,318
Sewer Rehabilitation 68,134 48,295 (19,839)
Totals $8,480,884 $14,977,678 $6,496,794
1 �
Member of HLB International $ R OS S O Tautg ®s R®dpath, Ltd
Budgeted Projects Fund
Balance Intra -fund Balance
Purpose 12/31/07 Revenues Expenditures Transfer 12/31/08
Sealcoat /crack seal $103,430 $100,000 $86,283 $ - $117,147
Outdoor storage 50,000 15,000 - - 65,000
Municipal building 157,575 10,000 6,586 - 160,989
Recreation:
Park and trail improvements 99,353 193,700 480,881 190,000 2,172
Trail maintenance 5,000 5,000 - - 10,000
Park building maintenance - 5,000 - - 5,000
Computers 21,226 4,000 11,910 - 13,316
Vehicles:
Police (36,105) 83,000 40,420 - 6,475
Public works 75,079 29,900 23,425 - 81,554
Building official - 15,000 14,762 - 238
Furniture and equipment:
Building inspections 78 - - - 78
Police 7,180 400 3,270 - 4,310
Trees 134,948 - 7,698 - 127,250
Public works equipment 5,000 60,000 5,232 - 59,768
Police radio equipment 32,055 - 6,250 - 25,805
Police computer equipment 126 - 126
Comprehensive plan 23,622 - 21,250 - 2,372
Coalition of utility cities 16,000 - - 16,000
Civil defense 10,000 - - - 10,000
Unallocated 227,064 59,142 9,558 (190,000) 86,648
Totals $931,631 $580,142 $717,525 $0 $794,248
Member of HLB International. ORES Tsu9tpw= Rsdpath, Ltd.
Water Util
$800,000
Water Operating
Revenue &
$700,000 Expense
$600,000
$500,000 Transfer Out
Depreciation
$400,000 Y All Other Expenses
Contractual
$300 - - - -- - -- Services
$200,000 --
$100,000
$O
2001 2002 2003 2004 2005 2006 2007 2008
Member of HLB International 10 Powa Tautg ®s R ®dpatti� Ltd_
Sewer Utility
$900,000
Sewer
Operating
$800,000 Revenue &
Expense
$700,000
$600,000
Transfer Out
$500,000 IIIIIIIIIIIIIIIIDepreciation
Personal Services
$400,000 All Other
Expenses
$300,000
$200,000
$100,000
$O
2001 2002 2003 2004 2005 2006 2007 2008
Member of HLB International ONES Tsutgos FLsdpatl�v, Ltd.
Storm Sewer Utilit
$80,000
Storm Sewer
s Operating
$70,000 Revenue &
Expense
$60,000 - - - - --
$50,000
Transfer Out
$40,000 All Other Expenses
® Contractual
Services
$30,000 - - -
$20,000 —
$10,000 —
$0
2001 2002 2003 2004 2005 2006 2007 2008
Member of HLB Intemational 12 Ru w Tautgas Radpatl-�� Ltd
n R e po rt
State C o m I i a ce
♦
Required by Minnesota Statute §6.65
♦ OSA established a task force to develop audit
guide for legal compliance
♦ Audit guide covers seven categories
1) contracting and bidding
2) deposits and investments
3) conflicts of interest
4) public indebtedness
5) claims and disbursement
6) other miscellaneous provisions
7) Tax increment provisions
♦ No findings of noncompliance for 2008
Member of HOB International 13 Tautgss Rsdpati� Ltd.
Report on Internal Control
♦ Two internal control findings reported
— Financial statement preparation
— Audit adjustments
Member of HLB Intemational 14 ROP O S Taaatgas Rsdpath. Ltd_
Communication to Those Charged
with Governance
• Audit firm responsibility under U.S. audit standards.
• Planned scope and timing of the audit.
• Significant accounting policies.
• Accounting estimates.
• No difficulties encountered in performing the audit.
• Audit Adjustments.
• Disagreements with management.
• Consultations with other auditors.
• Issues discussed prior to retention of auditor.
Member of HLB International 15 ow Tautg ®s Rsdpath Ltd