HomeMy WebLinkAbout5H, Preliminary 2011 Actual Financial Results ,—A RI EN HILLS
Request for Council Action 5H
Prepared By: Sue Iverson Director of Finance Council Meeting Date: April 30, 2012
and Administrative Services
Preliminary 2011 Actual Financial Results
Budgeted Amount: Actual Amount: Funding Source:
N/A N/A N/A
Recommendation:
Motion to accept the 2011 Preliminary Financial Results as presented.
I
�I
Supporting Documents:
1. Memorandum from Sue Iverson and Kyle Howard dated April, 30, 2011.
2. Preliminary 2011 Financial Reports.
I
I
I
i
I
i
I��
'It
EN HILLS
MEMORANDUM
DATE: April 30, 2012
TO: Honorable Mayor and City Council
Patrick Klaers, City Administrator
FROM: Sue Iverson, Director of Finance and Administrative Services
Kyle Howard, Finance Analyst
SUBJECT: Preliminary 2011 Actual Financial Results
Backaround/Discussion
Attached are the preliminary actual numbers for 2011. These are the preliminary unaudited 2011
budget to actual numbers. Final audited numbers will be presented after completion of the 2012
audit.
Preliminary estimated numbers for 2011 came in at approximately 82% of overall budgeted
expenditures. The General fund expenditures came in at and estimated 98% of budgeted.
Revenues came in at about 106% of budgeted with the General fund at 114%. However there are
still adjustments and accruals to be made that may affect these final numbers.
An Investment Portfolio has also been included with these financial reports. Per the Investment
Policy, our Benchmark Rate is the 4M plus Rate. At December 31, 2011 —this rate was 0.05%
and our portfolio is averaging 1.728%. All of our investments are in government secured or
government backed deposits. The section listed at the top of the portfolio is 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. 11.85% 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 2011 Preliminary Financial Results.
City of Arden Hills
2011 Budget
Revenues
Adopted Actual Balance YTD
FY 2011 12/31/2011 Available %of Budget
Operaling Revenue
Mayor 8 Council $ - - - -
Elections - - - -
Administration 3,205,540 3,141,640.92 63,999 98%
Finance B Support Services 53,617 196,193.97 (142,577) 366%
Planning B Zoning 60,700 87,021.91 (26,322) 143%
Government Buildings 97,474 81,178.00 16,296 83%
Public Safety 102,387 76,670.89 25,716 75%
Emergency Management - - - -
Protective Inspections 202,300 262,233.99 (59,934) 130%
Street Maintenance 68,199 76,446.00 (8,247) 112%
Park Maintenance 3,500 3,241.50 259 93%
Recreation 88,500 107,676.98 (19,177) 122%
Celebrating Arden Hills 15,000 10,687.00 4,313 71%
Transfers
Total General Fund 3,897,217 4,042,891.16 (145,675) 104%
TCAAP 70,000 (2,576.46) 72,576 J%
Cable Fund 83,000 75,165.10 7,835 91%
Risk Management 15,000 49,995.74 (34,996) 333%
Park Fund - 252,895.45 (252,895) -
Community Seances 40,400 32,081.04 8,319 79%
EDA General Fund 9,100 31,994.00 (22,894) 352%
EDA TIF#3 Cottage Villas 32,000 43,629.85 (11,630) 136%
EDA Revolving Fund 2,500 4,483.03 (1,983) 179%
EDA TIF#2 Round Lake 460,000 317,720.56 142,279 69%
Total Special Revenue Funds 712,000 805,388.33 (93,388) 113%
GO Tax Increment Bonds of 1996A (17.93) 18
Total Debt Service Funds - (17.93) 18 -
Equipment,Bldg 8 Replacement 10,000 - 10,000 0%
Public Safety Capital 15,000 12,461.98 2,538 83%
Capital Improvement Fund(PIR) 580,000 763,026.46 (163,026) 132% '
Total Capital Funds 605,000 775,488.44 (170,488) 128%
Water 1,828,160 1,993,835.24 (165,675) 109%
Sanitary Sewer 1,793,833 1,812,955.52 (19,123) 101%
Recycling 136,885 169,702.95 (32,818) 124%
Surface Water Management 540.322 566,351.72 126.030) 105%
Total Enterprise Funds 4,299,200 4,542,845.43 (243,645) 106%
Total Operating Revenues 9,513,417 10,166,695.43 (653,179) 107%
Other Financing Souroes - -
Mayor 8 Council - - - -
Elections - - - -
Administration - - - -
Finance - - - -
Planning 8 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.00 - 100%
EDA TIF#3 Cottage Villas - - - -
EDA Revolving Fund - - - -
EDA TIF#2 Round Lake
Total Special Revenue Funds 12,600 12,600.00 - 100% ,
GO Tax Increment Bonds of 1998A 284.375 284.325.00 50 100%
Total Debt Service Funds 284,375 284,325.00 50 100% III
Equipment,Bldg 8 Replacement 183,000 193,212.00 (10,212) 106%
Public Safety Capital 25,000 - 25,000 0%
Capital Improvement Fund(PIR) 200.000 200.000.00 100%
Total Capital Funds 408,000 393,212.00 14,788 96%
Water - - - -
Sanitary Sewer - - -
Recycling - - -
Surface Water Management
Total Enterprise Funds - - - -
Total Other Financing Sources 704,975 690,137.00 14,838 98%
Prior Period Adjustment - - - -
Total Revenues $ 10,218,392 10,856,732.43 (638,341) 106%
i
City of Arden Hills
2011 Budget
Expenditures
Adopted Actual Balance VTD �
FY 2011 12/312011 Available %of Budget
Operating Expenses I,
Mayor 5 Council $ 69,706 71,097.67 E (1,392) 102%
Elections 1,720 17,038.07 (15,318) 991%
Administration 338,828 326,790.34 12,038 96%
Finance 8 Support Services 139,745 128,134.98 11,610 92%
Planning 6 Zoning 270,806 216,165.91 54,640 80%
Government Buildings 237,870 202,47234 35,398 85%
Public Safety 1,362,223 1,361,179.20 1,044 100%
Emergency Management 26,445 9,718.71 16,726 37%
Protective Inspections 259,302 269,648.58 (10,347) 104% j
Street Maintenance 280,983 272,774.70 8,208 97%
Park Maintenance 412,825 438,022.80 (25,198) 106%
Recreation 218,953 204,307.79 14,645 93%
Celebrating Arden Hills 25,000 19,893.94 5,106 80%
Re serves/Contingency 20,211 - 20,211 0%
Transfers
Total General Fund 3,664,617 3,537,245.03 127,372 97%
TCAAP 70,000 27,897.78 42,102 40%
Cable Fund 78,671 71,548.54 7,122 91%
Risk Management 27,000 8,895.55 18,104 33%
Park Fund - 32,752.53 (32,753) -
Community Services 25,000 - 25,000 0%
EDA General Fund 12,000 3,284.88 8,715 27%
EDA TIF a3 Cottage Villas 4,000 1,640.26 2,360 41%
EDA Revolving Fund - - -
EDA TIF a'2 Round Lake 1.300 1.716.21 (416) 132%
Total Special Revenue Funds 217,971 147,735.75 70,235 68%
GO Tax Increment Bonds of 1998A
Total Debt Service Funds - - - -
Equipment,Bldg 8 Replacement - - - -
Public Safety Capital - - - -
Capital Improvement Fund(PIR)
Total Capital Funds - - - -
Water 1,815,859 1,576,854.20 239,005 87%
Sanitary Sewer 1,476,717 1,519,442.28 (42,725) 103%
Recycling 135,950 152,270.03 (76,320) 112%
Surface Water Management 369.338 377.598.28 (8,260) 102%
Total Enterprise Funds 3,797,864 3,626,164.77 171,699 95%
Total Operating Expenses 7,680,452 7,311,145.55 369,306 95%
Capital Gulfav
Mayor 8 Council - - - -
Elections - - - -
Administration - (461.19) 461 -
Finance 8 Support Services - - - -
Planning 8 Zoning - 12.87 (13)
Government Buildings - - - -
Public Safety - - - -
Emergency Management - -
Protective Inspections - - - -
Street Maintenance - 56,775.74 (56,776) -
Park Maintenance - - - -
Recreation - - - -
Celebrating Arden Hills - - -
Transfers -
Total General Fund - 56,327.42 (56,327) -
TCAAP -
CableFund 20,000 12,259.45 7,741 61%
Risk Management - - - -
Park Fund 5,000 (2,208.57) 7,209 -44%
Community Services - - - -
EDA General Fund 15,000 - 15,000 0%
EDA TIF a3 Cottage Villas - - - -
EDA Revolving Fund - - - -
EDA TIF%2 Round Lake
Total Special Revenue Funds 40.000 10,050.88 29,949 25%
GO Tax Increment Bonds of 1998A
Total Debt Service Funds - - - -
Equipment,Bldg 8 Replacement 755,638 498,095.48 257,543 66%
Public Safety Capital 95,376 91,578.79 3,797 96%
Capital Improvement Fund(PIR) 1.971,000 1.042.962.80 928,037 53%
Total Capital Funds 2,822,014 1,632,637.07 1,189,377 58%
Water 368,140 123,659.23 244,481 34% i
Sanitary Sewer 625,100 478,358.60 146,741 77%
Recycling - - - - III
Surface Water Management 560,000 126,997.18 433,003 23%
Total Enterprise Funds 1,553,240 729,015.01 824,225 47% j
Total Capital Outlay 4,415,254 2,428,030.38 1,987,224 55%
Debt Service
GO Tax Increment Bonds of 1998A 284,375 284,325.00 50 100%
Total Debt Service 284,375 284,325.00 50 100%
I
Otter Financina Uses
Mayor 8 Council - - - -
Elections - - - -
Administratlon - - - -
Finance 8 Support Services - - - -
Planning 8Zoning - -
Government Buildings - - - -
Public Safety - - - -
Emergency Management - - - -
Protective Inspections - - - -
Street Maintenance - - - -
Park Maintenance - - -Recreation - - - -
Celebrating Arden Hills - - - -
Transfem 252.600 252,600.00 100%
Total General Fund 252,600 252,600.00 - 100%
TCAAP - -
Cable Fund - - - -
Risk Management - - - -
Park Fund - - - -
Community Services - - - -
EDA General Fund - - -
EDA TIF 03 Cottage Villas - - -
EDA Revolving Fund - - - -
EDATIFS2 Round Lake 284,375 284,325.00 50 100%
Total Special Revenue Funds 284,375 284,325.00 60 100%
GO Tax Increment Bonds of 1998A
Total Debt Service Funds - - - -
Equipment,Bldg 8 Replacement - - - -
Public Safety Capital - - -
Capital Improvement Fund(PIR)
Total Capital Funds - - - -
Water 43,000 43,000.00 - 100%
Sanitary Sewer 62,000 62,000.00 100%
Recycling - - -
Surface Water Management 38.000 38.000.00 100%
Total Enterprise Funds 143,000 143,000.00 100%
Total Other Financing Uses 679,975 679,925.00 50 100%
Total Expenditures $ 13,060,056 10,703,425.93 2,356,630 82%
I
III
Ili
City of Arden Hills
General Fund Summary
2011 Budget
Adopted Actual Balance YTD
Activity FY 2011 12/31/2011 Available %of Bud e
Taxes
101-41300-31010 Current Ad Valorem Taxes $3,040,964 2,662,035.66 $ 378,928 88%
101.41300.31011 Payments in Lieu of Taxes - 173.69 (174) -
101-41300-31020 Delinquent Ad Valorem Taxes 21,481 (7,721.17) 29,182 -36%
101-41300-31030 Mobile Home Tax 7,500 2,207.26 5,293 29%
101-41300-31040 Fiscal Disparities - 265,219.90 (265,220) -
101-41300-31510 Aggregate Removal Tax - (3,757.00) 3,757 -
101-41300-31910 Penalties&Interest on Taxes - - - -
101-41300-31920 Forfeited Tax Sales
Total Taxes 3,069,925 2,918,158.34 151,767 95%
Licenses and Permits
101-41300-32110 Liquor,On Sale&Sunday 25,000 24,100.00 900 96%
101-41300-32111 Liquor,Off Sale - 640.00 (640)
101.41300-32150 Inspection Fees - 900.00 (900) -
101-41300-32160 Contractors 5,500 6,750.00 (1,250) 123%
101-41910-32170 Rental Regulation Fee 3,400 3,280.00 120 96%
101-41300-32180 Business Licenses 13,000 10,286.00 2,714 79%
101-41300-32181 Other Business Lic/Permits 4,000 1,690.00 2,310 42%
101-41300-32182 Tabacco Liciense - 1,000.00 (1,000) -
101-42400-32210 Plan Review&Bldg Permits 128,000 151,644.21 (23,644) 118%
101-42400-32220 Mechanical Permits 26,000 29,498.71 (3,499) 113%
101-42400-32230 Plumbing Permits 10,000 23,194.24 (13,194) 232%
101-41300-32240 Animal Licenses 3,500 1,640.00 1,860 47%
101-41910-32250 Sign Permits 1,300 1,850.00 (550) 142%
101.41300.32250 Sign Permit Renewal - 1,640.00 (1,640)
101412400-32260 Electrical Permits 20,000 31,672.05 (11,672) 158%
101-42400-32270 Utility Permit Fees 300 4,375.00 (4,075) 1458%
10142400-32275 Fire Suppression Permits 6,000 6,954.83 (955) 116%
101 412400-32278 Fire Permit Plan Check Fee 3,000 2,662.43 338 89%
10141910-32279 Erosion/Grading Permit 1,600 6,250.00 (4,650) 391%
101-41910-32279 Temporary Structure Fee - 50.00 (50)
101-45400.34730 Other Nonbusiness Lic/Permits - 662.00 (662)
101-41300-32280 Other Nonbusiness Lie/Permits 2,000 1,100.00 900 55%
Total Licenses and Permits 252,600 311,839.47 (59,239) 123%
Intergovernmental Revenues
101-41300-33402 Market Value Homestead Credit (61,774) (61,774) 0%
101-41300-33403 Mobile Home Homestead Credit - 3,772.59 (3,773)
101-41300.33420 State PERA Aid 5,179 5,179.00 - 100%
101-42100-33418 Police Aid 49,946 41,722.00 8,224 84%
101-43100-33418 MSA Maintenance 67,649 76,017.00 (8,368) 112%
101-41910-33422 State Grants - - - -
101-41410-33621 Other County Grants&Aids
Other Intergovernmental 61,000 126,690.59 (65,691) 208%
Charges for Services
101-41910-34103 Zoning and Subdivision Fees - - - -
101-41910-34104 Plan Checking Fees 42,000 64,572.31 (22,572) 154%
101-41300-34105 Sale of Maps and Publications - 8.74 (9) -
101-41910.34106 Plat&Other Fees 11,000 10,025.00 975 91%
101-41300-34108 Admin Chgs from other funds 23,310 20,663.00 2,647 89%
101-41500.34108 Admin Chgs from other funds 40,117 34,680.00 5,437 86%
101-41940-34108 Admin Chgs from other funds 97,474 81,118.00 16,356 83%
101-41910-34110 Zoning Permit Fees 1,200 640.00 580 53%
101-41500-34250 Business Subsidiary App Fee - - - -
101-41300-34120 Water Tower Antenna Rentals 65,000 103,981.27 (38,981) 160%
101-41300-34121 Other General Govt Charges 3,300 3,401.00 (101) 103%
101-42100-34202 False Alarms 2,000 150.00 1,850 8%
101-42100-34206 Impound Fees - - -
101-42400-34207 State Building Code Surcharges 8,000 10,940.53 (2,941) 137%
101-42400-34208 City Building Code Surcharges 1,000 1,291.99 (292) 129%
101-41940.34101 City Hall Rental 60.00 (60) -
101-45200-34300 Park Facility Rental Fees 3,500 3,241.50 259 93%
101-45120-34730 Summer Playground Fees 12,000 13,537.00 (1,537) 113%
10145120-34740 Summer Trip Fees - - - -
101-45120-34781 Adult Programs 20,000 35,105.40 (15,105) 176%
101-45120-34782 Youth Programs 41,000 43,108.90 (2,107) 105%
101-45120-34785 Adult Softball - - - -
101-45120-34790 After School Programs 12,000 11,997.00 3 100%
101.45120-34791 Special Events Programs 3,500 3,180.68 319 91%
101-41910-34950 Other Charges for Services 200 354.60 155 177%
Total Charges for Services 386,601 442,054.92 (55,454) 114%
Adopted Actual Balance YTD
Activity FY 2011 12/31/2011 Available %of Bud e
Fines&Forfeits
101-41300-36102 Special Assessments - 438.19 (438)
101-41300-36102 Penalties&Special Assessment - 3.93 (4)
101-42100-35110 Highway Patrol Fines 10,000 1,761.64 8,238 18%
101-42100-35130 DWI Forfeitures 1,000 - 1,000 0%
101-42100-35140 Violations Bureau 23,000 13,087.27 9,913 57%
101-42100-35150 Tobacco Fines - 100.00 (100)
101.42100.35160 Administrative Fines 11,000 12,001.00 (1,001) 109%
101.42100-35200 Forfeits 5,441 335.98 5,105 6%
Total Fines&Forfeits 50,441 27,728.01 22,713 55%
Miscellaneous
101-41300.36210 Interest Income 40,000 34,858.18 5,142 87%
101-41300.36230 Contributions/Donations 3,600 - 3,600 0%
101-41940.36230 Contributions/Donations - -
101-45120-36230 Contributions/Donations - 750.00 (750) -
101-45400-36230 Contributions/Donations 15,000 10,025.00 4,975 67%
101-45200-36230 Contributions/Donations - - -
101-41300.36215 Candidate Filing Fee - - -
101-41910-36240 Developer Reimbursements - - - -
101-41500-36245 Conduit Debt Application Fee 500 500.00 - 100%
101-41500-36246 Conduit Debt Fees 10,000 134,955.49 (124,955) 1350%
101-43100-36277 Night Time Construction Waiver - - - -
101-41910-36280 Other Miscellaneous Revenue - - - -
101-43100-36270 Miscellaneous Reimbursements 550 429.00 121 78%
101-41300-36270 Miscellaneous Reimbursement 4,000 1,330.68 2,669 33%
101-41500-36270 Miscellaneous Reimbursement 3,000 26,058.48 (23,058) 869%
101-41940-36270 Miscellaneous Reimbursement - - - -
101-43100-36275 Private Street Light Reimbursements - - - -
101-42100-36280 Miscellaneous Reimbursement - 7,513.00 (7,513)
101-42400-36280 Fire Inspection Reimbursement
Total Miscellaneous 76,650 216,419.83 (139,770) 282%
Total Operating Revenues 3,897,217 4,042,891.16 (145,675) 104%
Other Financing Sources
101-42100.39101 Sales of General Fixed Assets - - -
101.45200-39203 Transfer
Total Other Financing Sources - - -
Total General Fund Revenue $3,897,217 4 042 891.18 (145,675) 104%
Operating Expenses
Mayor&Council $ 69,706 71,097.67 (1,392) 102%
Elections 1,720 17,038.07 (15,318) 991%
Administration 338,828 326,790.34 12,038 96%
Finance&Support Services 139,745 128,134.98 11,610 92%
Planning&Zoning 270,806 216,165.91 54,640 80%
Government Buildings 237,870 202,472.34 35,398 85%
Public Safety 1,362,223 1,361,179.20 1,044 100%
Emergency Management 26,445 9,718.71 16,726 37%
Protective Inspections 259,302 269,848.58 (10,347) 104%
Street Maintenance 280,983 272,774.70 8,208 97%
Park Maintenance 412,825 438,022.80 (25,198) 106%
Recreation 218,953 204,307.79 14,645 93%
Celebrating Arden Hills 25,000 19,893.94 5,106 80%
Reserves/Contingency 20,211 - 20,211 0%
Transfers 252,600 252 600.00 100%
Total Operating Expenses 3,917,217 3,789,845.03 127,372 97%
Capital Outlav
Mayor&Council - - - -
Elections - - - -
Administration - (461.19) 461
Finance&Support Services - - -
Planning&Zoning - 12.87 (13)
Government Buildings - - - -
Public Safety - - -
Emergency Management - - - -
Protective Inspections - - -
Street Maintenance - 56,775.74 (56,776) -
Park Maintenance - - - -
Recreation - - - -
Celebrating Arden Hills - - - -
Transfers
Total Capital Outlay - 56,327.42 (56,327) -
Total General Fund Expenses $3,917,217 3,846,172.45 71,045 98%
Revenue Over/Under Expenses (20,000) 196 718.71 (216,719) -984%
!2
I.: i cli 16 N MN 1614 NN
It-1 cl! . . . . . . . . . . . . . . .7
oo oqoqWWWW
c4. oq-!c4N,�P--q ..!qq V41� . . . . . . . . . .q lb q 9
o..R oo-221—V
IR
1. 311.31 No 11 lo c;
9 2 8.
W SmN . .
o.00s .8 oo
. . . . . .0 q
000.
S 3 O O ci
No
c4�:c44i4—qc; 66,:cq,6qi4 6
.4.:w
Al
oo ...
1.wl o 1
(R cq 1p(R o NO R% 11, n.. Soo
o
Q m 5:...
61 666 v v o 6 6 6 cq cm 4 Ili.-4 "1 N 6 c-i o 14 OOGO
o o S 8 8 .IS o o 8 22 8 =88988= 88.1 loo.8EWD S SC 1.1
8.81838;:828 . S. . . . . li . . . . . . . . . . . .
9 c! . . . . .
6 6 gi 4 000 oo oo.828j8N8� o
is
'88N ,I m 9
18 88
oi ci o n g �6 ui 4 2 1 ;.6 'i wi
Ail, oo.....o.—
TIT
I 1111111 111TIT T
All
02
Z
E
1cl
2 Z z z z
6" 0 00-19
go -6.6
< .2 0
2' 12 0 -j->-9 o 2 .2.0
"2,v o 0< :"M),17C o 0 Z, Z. A A. 2.
zw -Z 9 AS
m mz 1 –1 -a
z >
c5c0 z=i2 31
.0. 65 M-! a 2 i!
:R .0. 65 rj)65 2
m o.0 N 0 w
65
A�i A�i a�LL M-MtE*6Z2j?o E
2
Z Z Z Z :90 E 5.� - -.!!;M!%o> m
,.= �I M-A 28 03 m o aj m 5 V ro 5 6, zi mixim X X X Z
I I I 1 1 13:lolml�l 0 0 W> I Y]Zizl 1 1.9
_ OA�NNMNN NO QOM On
z >
ir
0 Us
6 x c4 8
E
m m C3 0 0 a a o'F O'E C,0 O'E'F'F a'a -E-E -E-F-E -E-E -E
0 0 0 L)U �00� ............
� =x-g
<<<<< < DoE
�
o 5�
2
85
4 'Nia
Q WE M
i;4 g
I PM1611
>>
r
N 12 t2 12 C @@ 4 V C@ t2
E 12 e e L E E E E E
2 0 0 0 mmmmm E E 6-E-8 .9;E E.1E,72 E E E-1E-E`2-E E;E E E E E E E E-E E 9.9.9.9.9.2 2 9.8.9.9 9 9
.0 .1 a >>> >5 > >>5 > 5,5;>
7H s I> t tu !�=5.5�1..1 ol(t ol ol W,Is(%8(10 0� 1�01)ol W,�;CIO 1�1%(t (t ol(�(t Ul)01)ol W, W2:2 Q Q l<l<l<Q l<Z2 Q
E E E E E o o o o o°a o o o o g o2 o o o o o o o a c a o o o o o o o o o o o o o o o o o o o o
O
'7 17
T Z Z'a-6 Z
Yaa3in3m' Sop" y�nS�N 333333333333333333333333333333 m 2 0.... e22Ee222EEE..2E2EREe2EeEeeeeee 2 2 2 2 2 2 2 2 2 2 2 e
d. ..... ........... ..d®. ............IL IL IL IL LLILLLIL ILLLLLILLLLLLLLLLL E E .........