Loading...
HomeMy WebLinkAboutAudit Report M KR CfR'fIFIEO PGBIJC ACCtII \ TANTS City of Prior Lake Audit Report Year Ended December 31, 2012 Malloy, Montague, Karnowski, Radosevich, & Co., P.A. � �. ��, _ �:� . z , , �,��- � ,; � � ,�, �� � ;� James H. Eichten, CPA � " � � "�� �T�� � Adrienne Mutzenberger, C P , �``�> . .� ,.:_ M KR A i r' �, ud to s Role CtLRTIFIEt> PI�i�LIC A C C O U\ 1 A\ T 1 �i Opinion on Financial Statements � — Financial Statements are Fairly Presented in Accordance with U.S. GAAP �1 Testing of Internal Controls and Compliance — Internal Controls over Financial Reporting — Compliance with Laws and Regulations related to Financial Reporting — Minnesota Legal Compliance 4 No Single Audit of Federal Awards for 2012 1 M �R Audit Results CFar�r�F.D Pcst.tC �A C L O l�� V�I� A N 7$ OFinancial Statement Opinion — Unqualified �Findings - Internal Controls — None CiFindings - MN Legal Compliance — None M KR Audi R �,,,,,, t esults CERI'IPIf�.i) Pti$LtC ACC(ll' \ TA NTS tiFollow-up on Prior Year Findings — Prior Period Adjustment — Adjusting Journal Entry — Withholding Affidavit 2 ' "' �' ` Mana em n R � g e t eport CER"1'IFIED PUBI.IC ACCI�G\T,�\TS 0 Audit Summary — Met Planned Scope and Timing — Significant Accounting Policies ° Implemented GASB Statement No. 63 — Uncorrected Misstatements — Other Required Communications t� Legislation � ti Property Taxes Local Net Tax Capacity $35,000,000 $30,000,000 $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 $- 2008 2009 2010 2011 2012 3 M KR Tax Rates CE��R'tlPlfiD Pt,'.BI.I(; � ACCOC'\ 1,1\Tti Rates expressed as a percentage ofnet taxcapacit5= AllCities Seven-Count} City State-Wide � Metro Area� Prior Lake 20ll 2012 2011 2012 20ll 2012 Acerage taa rate City 42.5 463 40.0 43.4 30.7 29.7 County 43.7 46.8 42.1 45.0 35.5 38.8 School 25.2 27.3 26.8 28.5 34.0 34.4 Special ta�ang 6.4 6.8 8.1 8.7 6.4 6.8 Total 117.8 127.2 117.0 ]25.6 106.6 109.7 M �� Man �, agement Report Ct;R"CIFIFI> Pl'BLIC AC� Ol'V iAVT� <i Audit Summary Gr Legislation G Property Taxes i� Governmental Funds Overview 4 �, A �� Governmental Funds Change in Fund Balance � V l (; P R'f 1 f I F. f) P C; R I.l C A C C O t'� i� T A:� l S Fund Balance as ofDecember3l, Increase � � 2012 � 2011 (Decrease) Fund balances ofgovemmental funds Totalby classification Restricted � $ 6,193,184 $ 8,842,047 $ (2,648,863) Assigned 8,608,145 6,881,166 1,726,979 � Unassigned � 6,281,156 7,011,612 (730,456) Total— govemmental funds $ 21,083,485 $ 22,734,825 $ (1,652,340) Total by fund General S 6,972,362 $ 7,747,207 $ (774,845) Debt Service 5,398,362 5,646,673 (248,311) ConstrucCion � 975,938 3,402,164 � (2,426,226) Specia] Revenue 1,513,43� 1,221,870 291,565 Capital Projects 6,222,388 4,716,9] I 1,505,477 Total—�ovemmentalfunds $ ?7,082,485 � 22,734,825 $ (1,652,340) M �� Co�ernmental Funds Re�enue per Capita With State-Wide Averages by Population Class � C�:a Pi.:s�.�c Accou;:r.axrs � State-Wide City of Prior lake Year December31,2011 2010 20ll 2012 Population 2,500—]0,000 10,00�2Q000 20,000-100,000 22,796 23,010 23,010 Propertyta?�s $ 390 $ 363 $ 406 $ 439 � 430 $ 413 Taxinerements 40 � 48 SI 22 � 21 21 Franchise and other ta�s 27 36 30 26 27 27 Special assessments 70 56 56 37 29 27 Licenses and permits 23 21 31 ]8 19 28 Intergovemmental revenues 283 263 152 93 61 162 Charges for services � 95 79 � � 78 71 68 l l6 Other 65 7� 65 37 40 56 Totalrevenue $ 993 $ 941 $ 869 $ 744 � 695 $ 850 5 M K R ��rnmental Funds Expen�litures per Capita With State-Wide Averages by Population Class Cf'R"I'1{IF.D PC.`BLit' A G C O C�"f A N'f 4 State-W ide City of Prior Lake 1'ear December31,2011 2010 2011 2012 Population 2,500–]0,000 iQ000-20,000 20,00(�100,000 22,796 23,010 23,010 Cunent Generalgovemment $ 126 $ 99 $ 82 � 91 S 98 $ ]06 Public safety 231 225 238 177 187 191 Streets and highways 114 108 89 76 79 74 C1�lture and recreation 79 _ 96 87 7] 75 7a All other 74 8l 82 2 q g 3 624 $ 609 $ 578 $ 4U 5 4a3 $ 453 Capital outlay and constniction $ 258 $ 272 $ 233 � 205 $� 169 $ 361 Debt service Principal $ 186 $ 148 S ]09 $ 118 $ 123 $ 149 [nterest and fiscal chages W 48� 4l 70 72 65 $ 2d6 $ 196 $ 150 � 188 $ 195 $ 209 General Fund Financial Position Year Ended December 3 l, $14,000,000 $12,000,000 $ I0,000,000 $8,000,000 $6,000,000 �4,000,000 $2,000,000 5- 2008 2009 2010 2011 2012 �FundBalance OCashandInvestmentsBalance — ExpendituresandTransfers0ut 6 General Fund Revenue by Source Year Ended December 31, � 10,000,000 $9,000,000 $8,000,000 $7,000,000 $6,000,000 �5,000,000 �4,000,000 $3,000,000 $2,000,000 $1,000,000 �- Taxes Licenses Intergovemmental Charges Fines AllOther and for and Permits Services Forfeits ■2008 ■2009 ❑2010 ■2011 ■2012 General Fund Expenditures by Function Year Ended December 31. �4,500,000 $4,000,000 --- 53,500,000 � � � $3,OOQ000 - � - �2,500,000 :z., � $2,000,000 - --- $1,500,000 � ��', � $1,000,000 = i � i � �500,000 �� � � r � i - � i �;,; ,�'>': S -- ��ru�r��� i�ubhc Salety ru�u� `vvuri:s Cultureand All Other Government Recreation ■2008 ■2009 ■2010 02011 ■2012 7 M KR Mana ement Re ort �� g P c�F t�rni.ic Acco� � r,�� rs �i Audit Summary c� Legislation ti Property Taxes €,� Governmental Funds Overview t� Internal Service Fund M KR Mana ement Re ort � g p C;F:R1'If 1fiC) I'l'•ItLfC p(:(:111'ti �l�A X'I�� 4 Audit Summary �i Legislation <i Property Taxes <'�► Governmental Funds Overview t� Internal Service Fund 6� Enterprise Funds Overview s M K R �terprise Funds Change in Financial Position Ctsnrien P�:Ri.t�: A C l.: O t! \ TA A�1 J Net Position as ofDecember3l, Increase � 2012 2011� (Decrease) Net position ofenterpnse funds Total b� classification Net investment in capiYalassets $ 45 $ 4�,435,153 $ 328,968 Unrestricted � 7,332,348 6,980,909 3�1,439 Total — enterprise funds $ 53,096,469 $ 52,416,062 S 680,407 Total by fund Water 5 30,776,518 $ 30,067,707 � 708,811 Se�mer 19,954,061 19,882,718 71,343 WaterQuality 787,2�6 771,146 16,ll0 Transit � 1,578,634 1,694,491 (115,85'n Total— enterpnse funds $ 53,096,469 $ 52,416,062 S� 68Q407 Water Enterprise Fund Year Ended December 3 l, 5,3,500,000 $3,250,000 � $3,000,000 �2,750,000 $2,500,000 ' 52.250.000 � �2,000,000 i 51,750,000 $1,500,000 ' $1,250,000 � � $1,000,000 ' 5750.000 $500,000 $250.000 $— — 2010 2011 2012 �OperatingRevenue o0peratingExpenses —Operatinglncome(Loss) —IncomeBeforeDepreciation 9 Sewer Enterprise Fund Year Ended December 31, $2,500,000 �2,250,000 � $2,000,000 � I ,750,000 51,500,000 $1,250,000 � � 1,000,000 ' $750,000 � �500,000 $250,000 � i �— � S(2J0,000) 2010 2011 2012 �Operating Revenue OOperating Expenses —Operatinglncome(Loss) —IncomeBeforeDepreciation Water Quality Enterprise Fund Year Ended December 31, S600,000 $500,000 $400,000 �300,000 $200,000 ' I $100,000 �� 5— � S(100,000) � i $(200,000) 2008 2009 2010 2011 2012 �OperatingRevenue �OperatingExpenses —Operatinglncome(Loss) —IncomeBeforeDepreciation 10 Transit Fund Year Ended December 3 l, � 1,000,000 $750,000 S�00,000 �250,000 �– $(250,000) $(500,000) $(750,000) 2008 2009 2010 20 ll 2012 �OperatingRevenue oQpzratingExpenses —Operating Income (Loss) M ' `� M n �„ a agement Report CE�:a Pt;[si.�c. ACCOl'\ I�AN'I J A� Audit Summary � � 4 Legislation t3 Property Taxes 0 Governmental Funds Overview O Internal Service Fund O Enterprise Funds 4 Overall Financial Analysis 11 M K R 2°'2 . 2°�' Program E�enses Recenues NetChanae NetChnnge CFRTIFIE�,D PCBLLC: ACt:(lU NTAti TS Net (e�.pense) recenue Cavemmental activities . General govemment $ 3,156,038 $ � 1,041,863 $ (2,114,175) $ (1,799,611) Public safety 4,744,743 1,834,652 (2,910,091) (3,07i,775) Public worl.s 4,931,149 4,319,544 (611,605) (2,308,642) Culture and recreation 2,231,995 929,363 (1,302,632) (1,912,385) Econortric develop�nent 595,770 1,653,380 1,057,610 (62$884) Interest on long-termdebt 2,101,559 — (2,101,559) (],603,642) Business-type activities � Water ' 2,057,934 �3,426,383 1,368,449 37$712 Sewer 2,34�,657 2,502,409 1�6,752 (178,282) Waterqualiry 362,459 622,501 260,042 10�,423 Transi[ 841,040 683,821 (157,219) (62,671) Totalnet(espense)cevenue $ 23,368,344 $ I7,013,916 (6,354,428) (11,085,697) General recenues Ta.�es . IQ520,436 1 Q89G,173 � Unrestricted grants and contributions � � '18,066 � 16,831 Investment eamings 697,847 891,574 Oth er recen ues 348,454 I G8,299 Total general reve�ues � ] 1,584,803 1 1,972,877 Change in net position $ 5,230,375 � 837,180 M KR Mana ement Re or g p t CLRTtFIF-!� PGItI,IC A C C O U\ C A\ T j t� Audit Summary +�i Legislation ti Property Taxes � Governmental Funds Overview 0 Internal Service Fund 4 Enterprise Funds ti Overall Financial Analysis t� Accounting and Auditing Updates 12 M KR ,� Summary C; F R�I� I E I F�, f� P t' R I_ 1 C. Ac:COI:\"IA\l ti � t� Clean Opinion on Financial Statements tiNo Findings i�Continue to Assess and Improve Internal � Controls and Financial Reporting � tiFinancial Results Indicate Adherence to Budget t�iImproving General Fund Financial Condition � t'1lmproving Overall Enterprise Fund Financial Trends 13