HomeMy WebLinkAbout5G, 3rd Quarter 2011 Financial Reports EN HILLS
MEMORANDUM
DATE: November 28, 2011
TO: Honorable Mayor and City Council
Patrick Klaers, City Administrator
FROM: Sue Iverson, Director of Finance and Administrative Services
Kyle Howard, Finance Analyst
SUBJECT: 20113 d Quarter Actuals
Background/Discussion:
Attached are the 3`d Quarter Actuals for 2011. Overall expenditures are running below budget estimates.
Please remember that we have only received 50% of our revenue from property taxes. Governmental
accounting is not done on an accrual basis, therefore the numbers reflect what was actually taken in as
revenue or paid out as expenditures thru September 30,2011.
Accruals, deferred revenue adjustments, etc. are only done at year-end. Basically General Fund
expenditures from operating activities are running slightly below the budget estimates, revenues are
running close or slightly above budget estimates. Revenue from Conduit Debt Fees is running 1684%
above budget, due to the Presbyterian Homes Conduit Debt Fee collected in September. (Please note that
the overall percentages look lower because property taxes, liquor licenses, etc are collected at year-end.)
An Investment Portfolio has also been included with these financial reports. Per the Investment Policy,
our Benchmark Rate is the 4M plus Rate. At September 30, 2011 —this rate was 0.05% and our portfolio
is averaging 2.393%. All of our investments are in government secured or government backed deposits.
The section listed at the top of the portfolio are the "liquid" investments that we can access at anytime.
As we are trying to stay diversified in this area and we will be transferring between these accounts. We
have had some of our high interest notes call and I am working on cash flows with the PMP and other CIP
projects to determine how much I can invest and for what time periods. 6% of our total funds are in the
League of Minnesota Cities 4M Fund and 4M Plus accounts.
Staff Recommendation:
Staff requests that Council accept the 3`d Quarter Financial Reports.
0
b.'.
N O W m N O O O N N N O O O O N N O S O N O N O r O r 0 t°O O O O N O O O
......... N u?N O N
." O ^ mNN`N,1� fV<t<7 tO N f NO m N<O N 00 mOw�m o 1�N0 X00 thm00 00000 Nm b N^yam
ci
¢¢��'O 0mah NNNN N Nm Nme'1 mr N
C
k!
';.'aorarNNOm mm000 00000lom0000000NO$°o°o°o.°n 1°n v°�NNo°oN°a °o°o°o°o°o°O OO°o°o °e °° °o, u � E
mah OI mNOmN r•-<vv 000 NN e-0000�OOON NOO � O O N r O
000^ mm�Omi O�Omi m dmmO�MOO.-Y mN NOOmi 1010 NOOI m1")ro V r m O r b b e'1 ON e
NN °i W 86N 00i A Nr 01086 vl W N mOrNN mNm NrN OIO N m
'::.�H� � m O b N N N�N tnM NNN N M N N M NS Am d O p•Q.,C•
E N N f
^ Iv Ot2 S W PV °°<<y0y0 �OSONrm�OOO YN°')m Na�ID aQDO0000pp151°NV°h 868686 -6=s.SmW mS00 b O N
mm
°N° ONNNON�Om�°oN°rm W Yr00 �ONNa^Om r0 a0 W^N00aN0 OI W r'!
'b'�H e p� N V r �NmN V rm•-N mN NOINNN OM N N
A: f
L:x
a.�
o i�m-Ne
o Gm r OO o o 0<a 0 rm A l"n
0 ry 86 o mm e u o°o 0 uu°o'i o 1n°N m°o m o°o,N v o°o°o,o°�0°o 086 ff QN°o,1o°m NV N o°a S 0 r M I1°V n oM1°n°M°o I°o V N N M o NN°o N°o
N°o,86o 0g n°o,r°o N g°o,N°o m m°^°,oMlS V a N°O,°[oV°N,
o rn°wO°O N m o m a e c4 c
6 q $°o
°e°e M o
�� �
_ r
86 8686 8686 OI^OIN at O�Nh trn W NNN 1pONN N W Ot°'1N O W t70S
RY...N N N�Nt�C'1 N NN NNNN M N N m OI Or
YY b
a N�2=de V 2E O
bl a
o Gp1 m
z
E m z2 -6 a
c
Wm ' o^ca>m zy
s z «=�
=i
Q J OzY
cO „E �,w p n o
QLL.IL ULL g m m (:J m mO n m J m pp-'Ey N^ QS m C N m c ~Z c D ~m m 2 Cm
O X N Q m m m w E rn w «
zx mz '`oSNp$ a c cm�-a I
w oo
1 cc7N -
omLL W Dm O c ��mN UO w c C AIL w_f%1 G p N=OU U Y_ = m-.S m�
c"�a a LL y` `c c @ v @ U U m O y m w`o E d 0 3 C�d E N Y'a o E 0 a m m m m 0 m a o 0 o c xl
Z Z 2 Z m w 5CacC J E$ .� ._ o w w E'� �m�nn = y= Z m°^ Z 2 S Z 2 S=S S S li N N N F
W 3 0 U N KYy� m (J O W LL LL N U LL LL LL LL LL LL LL LL LL LL
QY'aK'NiLLLLm7 �Xm m_NK 3NJ70. uUj O N7
'::W ONi Y W 0 N N ri N QN m 0110O0'YN_YOj BOOO aWO St„VV1p fOm t°p V OLL NI°W �rCyy�ALLm laL�a�C7r
.:,u N— N b0 SvNi rap rorONOm�V r N ONN cmim th thN NI MM
T O m W m N b N t'1 th M[7
m E
ccccL
oCoco
'=oo='=o=868686'=' `o'EOC._._O._._.=o` and �A3
U U U U U U U U E U U S 2 E U Q 6 Q Q¢¢¢¢¢¢¢ m
u °E 'w
�!.' 0000900 O NON N I��..N Mt•1 O M ON NNma�dt�mt"1 rtimm m n mm 1.�rmmOONNNN ,.�^w O
Ob!
N N o o N o N n o e ° m m^m m n N N N 1�2 N a Q E
at�N ` `" z ao° �O NN N NO ra: W G a c
A��A$wa`�oinom�a000°oow°Soao� as
iz
O¢ m
q
(�(�O O O O 0 0°0 0 0 CI 86 0 O O O O O ^' NNN^NON^
ANN InMN NITi f�'HY PNAa m o�D�rM N N�NNI�N NNN a �a
n,.. aaNaa ao�a�aoa,Mc;acaig Zrza,��o
::.
m oro�r00000
E E E E E E w$w°�,w°w w w
86 0 0 0 0 0 0 0 >'>>">">>'>">"> _
oo¢000ao$$
Et= E E E E E o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o o o 0 0 0 0 0 _
ii IL j C
c�c�c E 0 E 0 0 0 i0n =-3=-31-3L I-3L=-3A-3I3—L I-3L��.I�L I3L LL3.I3L 3.3 3 I33 3—3 I I LL�Ii I3 I3 I3 I3 I3L LL L w I3 LL w IL w LLw.I3L vi I3L a d E w in n m m m—-- 33m a
A3: AmAm w I3L w I3L w I3L w I�I w I3L w I�L w f«
Fa-
,
City f Arden Hills
ty •
2011 Budget
Revenues
Adopted Actual Balance YTD
FY 2011 9/30/2011 Available %of Budget
Operating Revenue
Mayor&Council $ $ -
Elections - -
Administration 3,205,540 1,646,895 1,558,645 51%
Finance&Support Services 53,617 194,064 (140,447) 362%
Planning&Zoning 60,700 66,307 (5,607) 109%
Government Buildings 97,474 60 97,414 0%
Public Safety 102,387 11,654 90,733 11%
Emergency Management - - -
Protective Inspections 202,300 179,929 22,371 89%
Street Maintenance 68,199 38,321 29,879 56%
Park Maintenance 3,500 3,242 259 93%
Recreation 88,500 101,908 (13,408) 115%
Celebrating Arden Hills 15,000 10,687 4,313 71%
Transfers - -
Total General Fund 3,897,217 2,253,066 1,644,151 58%
TCAAP 70,000 1 69,999 0%
Cable Fund 83,000 48,497 34,503 58%
Risk Management 15,000 5,706 9,294 38%
Park Fund - 290,904 (290,904) -
Community Services 40,400 24,579 15,821 61%
EDA General Fund 9,100 22,993 (13,893) 253%
EDA TIF#3 Cottage Villas 32,000 23,345 8,655 73%
EDA Revolving Fund 2,500 2,356 144 94%
EDA TIF#2 Round Lake 460,000 241,093 218,907 52%
Total Special Revenue Funds 712,000 659,475 52,525 93%
GO Tax Increment Bonds of 1998A - - -
Total Debt Service Funds - - -
Equipment,Bldg&Replacement 10,000 - 10,000 0%
Public Safety Capital 15,000 7,250 7,750 48%
Capital Improvement Fund(PIR) 580,000 556,633 23,368 96%
Total Capital Funds 605,000 563,883 41,117 93%
Water 1,828,160 1,161,308 666,852 64%
Sanitary Sewer 1,793,833 1,001,565 792,268 56%
Recycling 136,885 105,444 31,441 77%
Surface Water Management 540,322 357,458 182,864 66%
Total Enterprise Funds 4,299,200 2,625,774 1,673,426 61%
Total Operating Revenues 9,513,417 6,102,198 3,411,219 64%
. Other Financing Sources
Mayor&Council
Elections -
Administration '
Finance
Planning&Zoning
Government Buildings - -
Public Safety -
Emergency Management
Protective Inspections - - -
Street Maintenance -
Park Maintenance
Recreation -
Celebrating Arden Hills -
Transfers
Total General Fund
TCAAP
Cable Fund -
Risk Management
Park Fund -
Community Services - -
EDA General Fund 12,600 12,600 0%
EDA TIF#3 Cottage Villas - - -
EDA Revolving Fund - - -
EDA TIF#2 Round Lake - - -
Total Special Revenue Funds 12,600 12,600 0%
GO Tax Increment Bonds of 1998A 284,375 284,375 0%
Total Debt Service Funds 284,375 - 284,375 0%
Equipment,Bldg&Replacement 183,000 8,740 174,260 5%
Public Safety Capital 25,000 - 25,000 0%
Capital Improvement Fund(PIR) 200,000 - 200,000 0%
Total Capital Funds 408,000 8,740 399,260 2%
Water - - -
Sanitary Sewer
Recycling
Surface Water Management -
Total Enterprise Funds -
Total Other Financing Sources 704,975 8,740 696,235 1%
Prior Period Adjustment - - - -
Total Revenues $ 10,218,392 $6,110,938 4,107,454 60%
City of Arden Hills •
2011 Budget
Expenditures
Adopted Actual Balance YTD
FY 2011 9/30/2011 Available %of Budget
Operating Expenses
Mayor&Council $ 69,706 $ 52,275 $ 17,431 75%
Elections 1,720 1,705 15 99%
Administration 338,828 231,039 107,789 68%
Finance&Support Services 139,745 106,511 33,234 76%
Planning&Zoning 270,806 159,968 110,838 59%
Government Buildings 237,870 166,085 71,785 70%
Public Safety 1,362,223 1,114,530 247,693 82%
Emergency Management 26,445 6,471 19,974 24%
Protective Inspections 259,302 189,340 69,962 73%
Street Maintenance 280,983 208,455 72,528 74%
Park Maintenance 412,825 342,962 69,863 83%
Recreation 218,953 161,300 57,653 74%
Celebrating Arden Hills 25,000 19,120 5,880 76%
Reserves/Contingency 20,211 - 20,211 0%
Transfers - - - -
Total General Fund 3,664,617 2,759,761 904,856 75%
TCAAP 70,000 16,210 53,790 23%
Cable Fund 78,671 50,387 28,284 64%
Risk Management 27,000 740 26,260 3%
Park Fund - 9,287 (9,287) -
Community Services 25,000 - 25,000 0%
EDA General Fund 12,000 2,862 9,138 24%
EDA TIF#3 Cottage Villas 4,000 1,310 2,690 33%
EDA Revolving Fund - - - -
EDA TIF#2 Round Lake 1,300 1,310 (10) 101%
Total Special Revenue Funds 217,971 82,107 135,864 38%
GO Tax Increment Bonds of 1998A - - - -
Total Debt Service Funds -
Equipment,Bldg&Replacement - -
Public Safety Capital -
Capital Improvement Fund(PIR) -
Total Capital Funds - - - -
Water 1,815,859 713,659 1,102,200 39%
Sanitary Sewer 1,476,717 904,199 572,518 61%
Recycling 135,950 90,857 45,093 67%
Surface Water Management 369,338 206,186 163,152 56%
Total Enterprise Funds 3,797,864 1,914,901 1,882,963 50%
Total Operating Expenses 7,680,452 4,756,769 2,923,683 62%
Capital Outlay
Mayor&Council
Elections
Administration 137 (137)
Finance&Support Services - -
Planning&Zoning 13 (13)
Government Buildings - -
Public Safety - '
Emergency Management -
Protective Inspections - - -
Street Maintenance - 870 (870)
Park Maintenance - - -
Recreation -
Celebrating Arden Hills -
Transfers - -
Total General Fund - 1,020 (1,020)
TCAAP - - -
Cable Fund 20,000 5,559 14,441 28%
Risk Management -
Park Fund 5,000 (22,754) 27,754 -455%
Community Services - -
EDA General Fund 15,000 15,000 0%
EDA TIF#3 Cottage Villas - -
EDA Revolving Fund
EDA TIF#2 Round Lake - - -
Total Special Revenue Funds 40,000 (17,195) 57,195 -43%
GO Tax Increment Bonds of 1998A - - -
Total Debt Service Funds - - - -
• Equipment,Bldg&Replacement 755,638 394,168 361,470 52%
Public Safety Capital 95,376 77,065 18,311 81%
Capital Improvement Fund(PIR) 1,971,000 679,369 1,291,631 34%
Total Capital Funds 2,822,014 1,150,601 1,671,413 41%
Water 368,140 122,279 245,861 33%
Sanitary Sewer 625,100 10,738 614,362 2%
Recycling - - -
Surface Water Management 560,000 100,426 459,574 18%
Total Enterprise Funds 1,553,240 233,443 1,319,797 15%
Total Capital Outlay 4,415,254 1,367,870 3,0479384 31%
Debt Service
GO Tax Increment Bonds of 1998A 284,375 284,325 50 100%
Total Debt Service 284,375 284,325 50 100%
•
Other Financing Uses •
Mayor&Council
Elections -
Administration -
Finance&Support Services
Planning&Zoning
Government Buildings -
Public Safety -
Emergency Management -
Protective Inspections
Street Maintenance -
Park Maintenance -
Recreation
Celebrating Arden Hills -
Transfers 252,600 252,600 0%
Total General Fund 252,600 252,600 0%
TCAAP - - -
Cable Fund -
Risk Management - -
Park Fund - '
Community Services - - -
EDA General Fund -
EDA TIF#3 Cottage Villas - - -
EDA Revolving Fund - -
EDA TIF#2 Round Lake 284,375 284,375 0%
Total Special Revenue Funds 284,375 - 284,375 0%
GO Tax Increment Bonds of 1998A - - -
Total Debt Service Funds -
Equipment,Bldg&Replacement •
Public Safety Capital -
Capital Improvement Fund(PIR) - -
Total Capital Funds - - -
Water 43,000 - 43,000 0%
Sanitary Sewer 62,000 - 62,000 0%
Recycling - - -
Surface Water Management 38,000 - 38,000 0%
Total Enterprise Funds 143,000 - 143,000 0%
Total Other Financing Uses 679,975 - 679,975 0%
Total Expenditures $ 13,060,056 $6,408,964 6,651,092 49%
•
City of Arden Hills
General Fund Summary
2011 Budget
Adopted Actual Balance YTD
Activity FY 2011 9/30/2011 Available %of Bud et
Taxes
101-41300-31010 Current Ad Valorem Taxes $3,040,964 $1,387,908 $1,653,056 46%
101-41300-31011 Payments in Lieu of Taxes -
101-41300-31020 Delinquent Ad Valorem Taxes 21,461 (14,708) 36,169 -69%
101-41300-31030 Mobile Home Tax 7,500 (1,641) 9,141 -22%
101.41300-31040 Fiscal Disparities - 140,409 (140,409) -
101-41300-31510 Aggregate Removal Tax (2,840) 2,840
101.41300-31910 Penalties&Interest on Taxes -
101 3130031920 Forfeited Tax Sales -
Total Taxes 3,069,925 1,509,128 1,560,797 49%
Licenses and Permits
1013130032110 Liquor,On Sale&Sunday 25,000 24,100 900 96%
10131300-32111 Liquor,Off Sale - 640 (640)
10131300-32150 Inspection Fees - 900 (900) -
10131300-32160 Contractors 5,500 5,550 (50) 101%
1013191032170 Rental Regulation Fee 3,400 3,040 360 89%
10131300-32180 Business Licenses 13,000 10,406 2,594 80%
10131300-32181 Other Business Lic/Permits 4,000 1,690 2,310 42%
1013130032182 Tabacco Liciense - 1,000 (1.000) -
10132400-32210 Plan Review&Bldg Permits 128,000 112,602 15,398 88%
10132400-32220 Mechanical Permits 26,000 23,133 2,867 89%
10132400-32230 Plumbing Permits 10,000 6,636 3,364 66%
10131300-32240 Animal Licenses 3,500 1,578 1,923 45%
10131910-32250 Sign Permits 1,300 1,250 50 96%
10131300-32250 Sign Permit Renewal 1,640 (1,640) -
1013240032260 Electrical Permits 20,000 20,885 (885) 104%
10132400-32270 Utility Permit Fees 300 2,625 (2,325) 875%
10132400-32275 Fire Suppression Permits 6,000 4,724 1,276 79%
10132400-32278 Fire Permit Plan Check Fee 3,000 1,555 1,445 52%
1013191032279 Erosion/Grading Permit 1,600 4,050 (2,450) 253%
10131910-32279 Temporary Structure Fee - 50 (50) -
10135400-34730 Other Nonbusiness Lic/Permits 662 (662) -
10131300-32280 Other Nonbusiness Lic/Permits 2000 1,000 1.000 50%
Total Licenses and Permits 252,600 229,716 22,884 91%
• Intergovernmental Revenues
10131300-33402 Market Value Homestead Credit (61,774) (61,774) 0%
1013130033403 Mobile Home Homestead Credit - - -
1013130033420 State PERA Aid 5,179 - 5,179 0%
10132100-33416 Police Aid 49,946 49,946 0%
10133100-33418 MSA Maintenance 67,649 38,009 29,641 56%
10131910-33422 State Grants - - -
10131410-33621 Other County Grants&Aids
Other Intergovernmental 61,000 38,009 22,992 62%
Charges for Services
1013191034103 Zoning and Subdivision Fees - - -
10131910-34104 Plan Checking Fees 42,000 47,027 (5,027) 112%
1013130034105 Sale of Maps and Publications - 9 (9) -
1013191034106 Plat&Other Fees 11,000 10,025 975 91%
10131300-34108 Admin Chgs from other funds 23,310 - 23,310 0%
10131500-34108 Admin Chgs from other funds 40,117 - 40,117 0%
10131940-34108 Admin Chgs from other funds 97,474 - 97,474 0%
10131910-34110 Zoning Permit Fees 1,200 510 690 43%
10131500-34250 Business Subsidiary App Fee - -
10131300-34120 Water Tower Antenna Rentals 65,000 61,466 3,534 95%
10131300-34121 Other General Govt Charges 3,300 3,401 (101) 103%
10132100-34202 False Alarms 2,000 - 2,000 0%
1013210034206 Impound Fees - -
10132400-34207 State Building Code Surcharges 8,000 6,967 1,033 87%
10132400-34208 City Building Code Surcharges 1,000 802 198 80%
1013194034101 City Hall Rental 60 (60) -
10135200-34300 Park Facility Rental Fees 3,500 3,242 259 93%
10135120-34730 Summer Playground Fees 12,000 13,537 (1,537) 113%
10135120-34740 Summer Trip Fees -
1013512034781 Adult Programs 20,000 33,610 (13,610) 168%
10135120-34782 Youth Programs 41,000 40,857 143 100%
10135120-34785 Adult Softball - - -
10135120-34790 After School Programs 12,000 11,030 970 92%
10135120-34791 Special Events Programs 3,500 2,124 1,376 61%
10131910-34950 Other Charges for Services 200 355 155 177%
Total Charges for Services 386,601 235,021 151,580 61%
s
Adopted Actual Balance YTD •
Activity FY 2011 9/30/2011 Available %of Bud et
Fines&Forfeits
101-41300-36102 Special Assessments - 219 (219) -
101-42100-35110 Highway Patrol Fines 10,000 1,695 8,305 17%
101-42100-35130 DWI Forfeitures 1,000 - 1,000 0%
101-42100-35140 Violations Bureau 23,000 9,523 13,477 41%
101-42100-35150 Tobacco Fines - 100 (100) -
101-42100-35160 Administrative Fines 11,000 - 11,000 0%
101-42100-35200 Forfeits 5,441 336 5,105 6%
Total Fines&Forfeits 50,441 11,873 38,568 24%
Miscellaneous
101-41300-36210 Interest Income 40,000 22,807 17,193 57%
101-41300-36230 Contributions/Donations 3,600 - 3,600 0%
10141940-36230 Contributions/Donations - -
101-45120-36230 Contributions/Donations - 750 (750) -
101-45400-36230 Contributions/Donations 15,000 10,025 4,975 67%
10145200-36230 Contributions/Donations - - -
101-41300-36215 Candidate Filing Fee
10141910-36240 Developer Reimbursements - - -
101-41500-36245 Conduit Debt Application Fee 500 500 - 100%
101-41500-36246 Conduit Debt Fees 10,000 168,436 (158,436) 1684%
101-43100-36277 Night Time Construction Waiver - - -
10141910-36280 Other Miscellaneous Revenue - - -
10143100.36270 Miscellaneous Reimbursements 550 312 238 57%
10141300-36270 Miscellaneous Reimbursement 4,000 1,363 2,637 34%
10141500-36270 Miscellaneous Reimbursement 3,000 25,127 (22,127) 838%
10141940-36270 Miscellaneous Reimbursement -
10143100-36275 Private Street Light Reimbursements - - -
10142100-36280 Miscellaneous Reimbursement - - -
10142400-36280 Fire Inspection Reimbursement - - -
Total Miscellaneous 76,650 229,320 (152,670) 299%
Total Operating Revenues 3,897,217 2,253,066 1,644,151 58%
Other Financing Sources
10142100-39101 Sales of General Fixed Assets - - - -
10145200-39203 Transfer - - -
Total Other Financing Sources - - - - •
Total General Fund Revenue $3,897 217 $2,253,066 1,644,151 58%
Operating Expenses
Mayor&Council $ 69,706 $ 52,275 17,431 75
Elections 1,720 1,705 15 99%
Administration 338,828 231,039 107,789 68%
Finance&Support Services 139,745 106,511 33,234 76%
Planning&Zoning 270,806 159,968 110,838 59%
Government Buildings 237,870 166,085 71,785 70%
Public Safety 1,362,223 1,114,530 247,693 82%
Emergency Management 26,445 6,471 19,974 24%
Protective Inspections 259,302 189,340 69,962 73%
Street Maintenance 280,983 208,455 72,528 74%
Park Maintenance 412,825 342,962 69,863 83%
Recreation 218,953 161,300 57,653 74%
Celebrating Arden Hills 25,000 19,120 5,880 76%
Reserves/Contingency 20,211 - 20,211 0%
Transfers 252,600 - 252,600 0%
Total Operating Expenses 3,917,217 2,759,761 1,157,456 70%
Capital Outlav
Mayor&Council - - -
Elections -
Administration - 137 (137) -
Finance&Support Services - - -
Planning&Zoning 13 (13)
Government Buildings - - -
Public Safety - - - -
Emergency Management
Protective Inspections - - '
Street Maintenance - 870 (870) -
Park Maintenance - - -
Recreation
Celebrating Arden Hills - - - -
Transfers - '
Total Capital Outlay - 1,020 (1,020) -
Total General Fund Expenses $3,917,217 $2,760,782 1,156,435 70% •
Revenue Over/Under Expenses (20,000) 507,716 487,715 2539%