Loading...
HomeMy WebLinkAbout4C, 2009 3rd Quarter Financial ReportN HILLS ...... ............................ : Request for Council Action ---------------------------- Prepared By: Sue Iverson, Finance Director/Treasurer Council Meeting Date: October 26, 2009 2009 Third Quarter Financial Reports Budgeted Amount: Actual Amount: Funding Source: N/A N/A N/A Recommendation: 1. A motion to accept the 2009 Third Quarter Financial Reports as presented. ......... ....... ............... ................. ............. W....-........... ............._........ .............. ..-...................................... .-... ............ ..........................-.............. ..--........... ................. ........._ Supporting Documents: 1. See the attached memo from Sue Iverson dated October 26, 2009 2. 3rd Quarter Investment Portfolio 3. 3rd Quarter Financial Reports It'.- --,----ARQEN HILLS MEMORANDUM DATE: October 26, 2009 TO: Honorable Mayor and City Council Members Ron Moorse, City Administrator FROM: Sue Iverson, Finance Director/Treasurer SUBJECT: 2009 3rd Quarter Reports Background Attached are the 3rd Quarter reports for 2009. Overall expenditures are running below budget estimates. Please remember that we receive 50% of our revenue from property taxes and will not receive the 2nd half until December. 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 through September 30, 2009. Accruals, deferred revenue adjustment, etc. are only done at year-end. Basically expenditures from operating activities are running below the budget estimates, revenues are low because we have not received the 2nd half property taxes and other revenues that are collected at year end. The investment portfolio is also included with these reports. Per the Investment Policy, our Benchmark Rate is the 4M Plus Rate. At September 30, 2009 — this rate was 0.33% and our portfolio is averaging 2.499%. All of our investments are in government secured or government based deposits. The section listed at the top of the portfolio are the "liquid" investments that we can access at anytime. Although the Evergreen Fund shows that we have 29% of our available cash in this fund, a $600,000 transfer was made to the 4M account in early October. Council Action Staff recommends a motion to accept the 3rd Quarter Financial Reports. City Council Meeting \\Metro-inet\ardenhills\Admin\Council\Agendas & Packet Information\2009\10-26-09 Regular\Packet Information\3 rd_Qtr_Financial_Reports. doc Page 1 of 1 City of Arden Hills Investment Portfolio Analysis September 30, 2009 er . ..... aspri: Eat� trf::aV:t:ap .:.:. ::::::::::...• ::ytqsttaeht� eP :C:ata' o h! : C:b71Ce��: :: .:.: e'! o st::::::::: �t•i a Aniia:. auzed: - : ce ta' : C liSip: • t ati • bit �tiu' sA "u' '� n# 4M Fund 30 Days MM MN Municipal. al Liquid Asset Fund (General.) 17% 583 166.82 0.130% .sd .ma $758.12 4M Fund 30 Days MM MN Municipal Liquid Asset Fund (Payroll) 2% 74 897.03 0.130% $97.37 4M PLUS Fund 90 Days MM MN Municipal PLUS Fund General 9% 320 346.01 0.330% 1,057.14 4M PLUS Fund 90 Days MM MN Municipal PLUS Fund PIR 3% 112 684.39 0.330% 371.86 Affinity Plus 30 days MM Share-S1 Affinity Plus Share Account 0% 69.56 0.500% 0.35 Affinity Plus 01/22/09 884 Days MM/CD 178 Affinity Plus Odyssey Certificate 0% 0.00 5.461% 0.00 Affinity Plus 01/22/09 884 Days MM/CD 178.1 Affinity Plus Odyssey Certificate 0% 0.00 5.461% 0.00 Affinity Plus 10/03/10 884 Days MM/CD 195 Affinity Plus Odyssey Certificate 39% 1,375,768061 3.203% 44 065.87 Wells Faro 30 Days MM Wells Faro Govt MM Fund 1%1 23 861.56 0.009% 2.15 Saloman Smith BarneySB Cash Clearing Account 0%1 0.00 0.000% 0.00 Wachovia 30 Days MM Ever reen US Govt MM Fund 29%1 994 606.52 0.010% 99.46 Sub -Total I 29% 3,485,400.50 1.333%1 46 452.31 Dain Rauscher Corp0.00 Dain Rauscher Corp Dain Rauscher Corp Saloman Smith Barne Saloman Smith Barney12/12/07 12/07/07 12/12/12 12/12/11 5 yr 4 yr CD CD 381426FEO 9393791-197 Goldman Sachs Bank Washington Mutual Bank 1%, 1% 96 000.00 96 000.00 4.600% 4.550% 4,416.00 4,368.00 Saloman Smith Barney12/14/07 12/14/10 3 yr CD 95989P6M6 Western Bank PR 1% 96 000.00 4.600% 4,416.00 Saloman Smith Barney12/20/07 12/20/12 5 yr CD 844776DF8 Southwest Bank of St Louis MO 1% 96 000.00 4.650% 4,464.00 Saloman Smith Barney12/20/07 12/20/12 5 yr CD 553036FG4 M&I Bank FSB NV 1% 96 000.00 4.650% 4,464.00 Saloman Smith Barney12/20/07 12/20/12 5 yr CD 55405PFBO M&I Marshall & lisley Bk WI 1%. 96 000.00 4.650% 4,464.00 Saloman Smith Barney12/28/07 12/28/11 ':>':: "':<':1> CD 173702CL3 Citizens Bank MI - Callable 0% 0.00 4.900% 0.00 Wells Faro 07/16/09 08/16/10 1 r Muni 050006BS3 Atwater -Cosmos -Grove City Bond 4% 502 665.00 1.502% 7,550.03 Wells Faro 07/15/09 12/01/12 3.5 Vr Muni 777543PD5 Rosemount IL Taxable FACS Im r 2% 217 449.11 2.500% 5,436.23 Wells Faro 11/24/08 05/ 11/ 3 M Muni 977100AS5 Wisconsin State Rev Bond -Callable 4% 501 322.50 4.140% 20 754.75 Wells Faro 01/29/09 12/01/13 5 yr Muni 604129LN4 State of Minnesota GO -Taxable 3% 355 484.50 2.900% 10 309.05 Wells Faro 02/12/09 02/01/14 5 yr Muni 777594WX6 Rosemount MN School Dist 196 3% 337 461.30 3.500% 11 811.15 Wells Faro 01/07/09 02/01/17 8 yr Muni 688443,127 Osseo MN School Dist 279 OPEB Bonds 2% 259 692.50 5.400%1 14 023.40 Wells Faro 07/06/09 07/06/12'' 'Aenc` 3133XTZ41 FHL Step-up Callable 2% 250 000.00 1.250% 3,125.00 Wells Faro 08/27/09 08/27/19 #3 .'"'s}<': Agency 3133XUKJ1 FHL Step-up Callable 2% 250 000.00 3.000% 7,500.00 Wells Faro 08/26/09 08/26/14 5 yr CD 06740KAY3 Barclays Bank DE Willington, DE 1% 95 000.00 3.150% 2,992.50 Wells Faro 12/12/07 12/12/12 5 Yr CD 14041AVJ5 Capital One Bk-VA/CD 1% 95 000.00 4.500% 4,275.00 Wells Faro 09/02/09 09/04/12 3 Yr CD 149159GV1 Cathay Bk. Los Angeles, CA 1% 95 000.00 2.350% 2,232.50 Wells Faro 09/08/09 03/08/13 3.5 Yr CD 300185AN5 Ever reen Bank Grp,IL 1% 95 000.00 2.400% 2,280.00 Wachovia Securities 01/06/09 07/06/12 >> 5i' :>':€': Agency 3128X8CG5 FHLMC Step-up,Callable 0% 0.00 2.653% 0.00 Wachovia Securities 06/03/08 06/03/13 Agency 3136F9-QX-4 Fannie Mae Step -Up - Callable 0% 0.00 4.125% 0.00 Wachovia Securities 01/29/09 01/29/14 i<i ' ':`":>': Agency 31288X8FN7 FHLMC Step-up Med Trm Note Callable 3% 349 825.00 3.312% 11 586.20 Wachovia Securities 02/04/09 02/04/14 ;' : A enc 3136F95G4 FNMA Step-up,Callable 1% 150 000.00 2.000% 3,000.00 Wachovia Securities 05/19/09 05/19/14 :'":;>` < A enc 3128X8-ZN-5 FHLMCSCMTN-Callable 8% 1,000,000.00 2.000% 20 000.00 Wachovia Securities 06/25/09 06/25/14:: Aqencv 3133XT-TK-2 FHLSCB Series 2 - Callable 0% 0.00 2.000% 0.00 Wachovia Securities 06/30/09 06/30/14 ;:''": Agency 3133XT-VW-3 FHLBSCB Series 7 - Callable 0% 0.00 2.000% 0.00 Wachovia Securities Wachovia Securities 08/26/09 10/15/09 08/26/14 10/15/14 .... '': € ::'`: Aqency Agency 3128X9-DE-7 3133XU-YV 9 FHLMCSCMTN Callable FHLBSCB Callable 3% 5% 300 000.00 650 000.00 2.000% 2.000% 6,000.00 13 000.00 Wachovia Securities 10/22/09 10/22/14 :: ` <>1 Agency 3133XV-6X-4 FHLBSCB Series 2 Callable 4% 500 000.00 2.000% 10 000.00 Wachovia Securities 03/03/08 03/03/15 " * :"': Agency 3128X6-4X 1 FHLMCC Med Term Note - Callable 0% 0.00 4.810% 0.00 Wachovia Securities 02/08/08 08/06/15:"''' Agency 3135A1-CN-5 Fannie Mae Step -Up - Callable 0% 0.00 4.276% 0.00 Wachovia Securities 12/14/07 12/12/17#":: < Agency 3136F8XS9 FNMA StepUp Coupon Bond -Callable 0%1 0.00 4.990% 0.00 Wachovia Securities 12/18/07 12/18/17 ii"'': Agency 3128X6-TD-8 FREDDIE MAC/Step Coupon Bond - Callable 0% 0.00 5.260% 0.00 Wachovia Securities 10/29/08 04/29/16 Agency 3128X7-3F-9 FHLMCMTN-Callable 0% 0.00 6.000% 0.00 Wachovia Securities 04/16/08 04/16/18 ?:>':i:.`:? Agency 3128X7JX3 FHLMC Ste U -Callable 0% 0.00 4.000% 0.00 Wachovia Securities 03/14/08 03/13/09 1 yr CD 36185A-QY-7 GMAC Bank - Midvale UT 0% 0.00 3.600% 0.00 Wachovia Securities 03/18/08 03/18/09 1 r CD 98233P-ND-5 Wright Express Finl - UT 0% 0.00 3.600% 0.00 Wachovia Securities 06/18/08 06/18/09 1 yr CD 140653-VX 1 Ca mark Bank 0% 0.00 3.450% 0.00 Wachovia Securities 06/18/08 06/18/09 1 yr CD 795450-DL-6 Sallie Mae Bank 0% 0.00 3.400% 0.00 Wachovia Securities 06/19/08 06/19/09 1 W CD 19882-DE-9 Columbus Bank & Tr Co 0% 0.00 3.400% 0.00 Wachovia Securities 03/12/08 09/14/09 1.5 yr CD 00759T-XR-5 Advanta Bank Corp- UT 0% 0.00 3.600% 0.00 Wachovia Securities 12/26/08 12/28/09 :''": CD 61747-M-TG-6 Morgan Stanley Bank UT 1% 96 000.00 2.150% 2,064.00 Wachovia Securities 12/30/08 12/30/09 1 w CD 36159S-EQ-0 GE Money Bank 1%1 96 000.00 2.200% 2,112.00 Wachovia Securities 07/25/08 01/25/10 ti CD 92977E-PW-5 Wachovia Bank Charolotte NC 1% 96 000.00 4.000% 3,840.00 Wachovia Securities 07/25l08 01/25/10 CD 929781-FB-3 Wachovia Bank Las Vegas NV 1% 96 000.00 4.000% 3,840.00 Wachovia Securities 07/30/08 02/01/10 itr 1 CD 5252OK-WL-7 Lehman Bros Coml Bank 1% 96 000.00 4.000% 3,840.00 Wachovia Securities 08/13/08 02/16/10 €; i # s € CD 25469J-RG-6 Discover Bank DE 1% 96 000.00 4.200% 4,032.00 Wachovia Securities 09/15/08 03/15/10 18 mo CD 59012Y-TS-6 Merrick Bank UT 1% 96 000.00 4.000% 3,840.00 Wachovia Securities 10/08/08 04/08/10 ' CD 200339-CN-7 Comerica Bank 1%1 96 000.00 4.050% 3,888.00 Wachovia Securities 10/15/08 04/15/10f CD 195554-PH-7 Colonial Bank NA 0% 0.00 4.050% 0.00 Wachovia Securities 10/29/08 04/29/10 i<'i1 CD 17284P-M9-3 CIT Bank Salt Lake City,UT 1% 96 000.00 4.050% 3,888.00 Wachovia Securities 11/07/08 05/07/10 ?Ii CD 433411-BV-6 Hinsdale Bank & Trust 1 % 96 000.00 4.050% 3,888.00 Wachovia Securities 11/13/08 05/13/10 'i# f »': CD 319054-KE-1 1st Bank Beverly Hills 0% 0.00 4.050% 0.00 Wachovia Securities 10/07/08 10/07/10 €#1 CD 336472-CY-9 1 st State Bank Union City TN 1% 96 000.00 4.000% 3,840.00. Wachovia Securities 10/08/08 10/08/10 ffiao CD 42721 E-FZ-7 Heritage Bank of Commerce 1% 96 000.00 4.000% 3,840.00 Wachovia Securities 10/08/08 10/08/10 2 # CD 49306S-FS-0 Key Bank Nati Assoc Cleveland OH 1% 96 000.00 4.250% 4,080.00 Wachovia Securities 10/08/08 10/08/10 ` €€I CD 61747M-NT-4 Morgan Stanley Bank UT 1% 96,000.00 4.250% 41080.00 Wachovia Securities 10/09/08 10/12/10 CD 36159S-BW-0 GE Money Bank 1% 96 000.00 4.200% 4,032.00 Wachovia Securities 11/12/08 11/12/10 24 mos CD 0258OV-AW-5 American Express Bank 1% 96 000.00 4.250% 4,080.00 Wachovia Securities 12/01/08 12/01/10 <'; r; CD 05568PMKO BMW Bank Salt Lake City1% 96 000.00 4.150% 3,984.00 Wachovia Securities 06/03/09 12/03/11 i CD 795450-LU-7 Sallie Mae Bank 1% 150 000.00 2.650% 3,975.00 Sub Total Fixed Rate Instruments 71% 8,361,899.91 2.985% 249 610.80 �. --- :I tyre t " :ptccr�e�# : :Ma e. Haire � r�'�e�st: $583 166.82 2,966.67 - $74 897.03 705.27 - 320 346.01 1,691.63 - 112 684.39 341.65 - 69.56 0.27 - 0.00 2,098.34 - 0.00 2,099.34 1,375,768.61 30 061.34 - 23 861.56 43.84 - 0.00 - - 99,363.84 98,925.12 99,192.00 99,192.00 99,192.00 0.00 504,775.00 205,902.00 480,990.00 357,875.00 343,965.60 273,250.00 250,625.00 251,485.00 94,249.50 98,658.45 94,908.80 94,415.75 �0.00 0.00 349,024.20 150,281.25 17002,561.00 0.00 0.00 301,024.50 650,000.00 500,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 96,335.04 96,349.44 96,949.44 96,949.44 97,002.24 97,188.48 97,340.16 97,526.40 0.00 98,513.28 98,518.08 98,761.92 98,746.56 99.025.05 Total Investments 100%1 $11,847,300.411 T499%1 $296,063.111 $ 1 11,897,980.701 $240 826.88 $0.00 = callable Overall Annualized Rate of Return 2.499% Interest Rec' 2009 $240,826.88 Annualized Rate of Return w/o Money Market 2.985% 2008 Int Rec'd 2009 $58,192.70 Benchmark - 4M Plus Rate 0.330% 2009 Int not Rec'd Total 2009 Int Income $182,634.18 City of Arden Hills City -Wide Budget Summary Revenues I Proposed Actual Balance YTD FY 2009 39721 Available % of Budaet Operating Revenue Mayor & Council Elections Administration Finance & Support Services Planning & Zoning Government Buildings Public Safety Emergency Mangement Protective Inspections Street Maintenance Park Maintenance Recreation Transfers Total General Fund 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 Total Special Revenue Funds GO Tax Increment Bonds of 1998A Total Debt Service Funds Equipment, Bldg & Replacement Public Safety Capital Capital Improvement Fund (PIR) Total Capital Funds Water Sanitary Sewer Recycling Surface Water Management Total Enterprise Funds Total Operating Revenues Other Financing Sources Mayor & Council Elections Administration Finance Planning & Zoning Government Buildings Public Safety Emergency Mangement Protective Inspections Street Maintenance park Maintenance Recreation transfers Total General Fund rCAAP able Fund Risk Management 'ark Fund community Services _DA General Fund _DA TIF #3 Cottage Villas _DA Revolving Fund _DA TIF #2 Round Lake Total Special Revenue Funds 3,174, 068 1,604,966 1,569,102 50.56% 31,357 20 31,337 0.06% 56,250 39,080 17,170 69.48% 92,937 147 92,790 0.16% 80,200 19,028 61,172 23.73% 193,300 137,439 55,861 71.10% 64,450 67,961 (3,511) 105.45% 3,500 3,598 (98) 102.80% 89,000 82,577 6,423 92.78% 3,785,062 1,954,816 1,830,247 51.65% 1,001,000 (259, 736) 1,260,736 -25.95% 83,000 64,874 18,126 78.16% 10,000 7,675 2,325 76.75% 204,000 10,473 193,527 5.13% 50,500 33,906 16,594 67.14% 5,000 9,160 (4,160) 183.19% 51,000 20,273 30,727 39.75% 5,000 1,344 3,656 26.88% 435,000 251,061 183,939 57.72% 1,844,500 139,029 1,705,471 7.54% - (11) 11 - 52,000 4,845 47,155 9.32% 372,000 356,770 15,230 95.91 % 424,000 361,615 62,385 85.29% 1,443,942 1,117,478 326,464 77.39% 1,226,200 788,137 438,063 64.27% 119,404 64,184 55,220 53.75% 427,660 333,288 94,372 77.93% 3,217,206 2,303,088 914,118 71.59% 9,270,768 4,758,538 4,512,231 51.33% 25,000 - 25,000 0.00% 25,000 - 25,000 0.00% GO Tax Increment Bonds of 1998A Total Debt Service Funds Equipment, Bldg & Replacement Public Safety Capital Capital Improvement Fund (PIR) Total Capital Funds Water Sanitary Sewer Recycling Surface Water Management Total Enterprise Funds Total Other Financing Sources Prior Period Adjustment 278,475 253,175 25,300 90.91 % 278,475 253,175 25,300 90.91 % 204,000 - 204,000 0.00% 50,000 - 50,000 0.00% 200,000 - 200,000 0.00% 454,000 - 454,000 0.00% 757,475 253,175 504,300 33.42% Total Revenues $ 10,028,243 $ 5,011,713 $ 5,016,531 49.98% Operating Expenses Mayor & Council Elections Administration Finance & Support Services Planning & Zoning Government Buildings Public Safety Emergency Mangement Protective Inspections Street Maintenance Park Maintenance Recreation Reserves/Contingency Transfers Total General Fund 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 Total Special Revenue Funds GO Tax Increment Bonds of 1998A Total Debt Service Funds Equipment, Bldg & Replacement Public Safety Capital Capital Improvement Fund (PIR) Total Capital Funds Water Sanitary Sewer Recycling Surface Water Management Total Enterprise Funds Total Operating Expenses Capital Outlav Mayor & Council Elections Administration Finance & Support Services Planning & Zoning Government Buildings Public Safety Emergency Mangement Protective Inspections Street Maintenance Park Maintenance Recreation Transfers Total General Fund TCAAP Cable Fund Risk Management Park Fund ;ommunity Services =DA General Fund =DA TIF #3 Cottage Villas =DA Revolving Fund =DA TIF #2 Round Lake Total Special Revenue Funds City of Arden Hills City -Wide Budget Summary Expenditures Proposed FY 2009 $ 79,386 $ 1,010 388,879 142,832 256,128 240,106 1,217,766 32,746 243,144 282,719 407,636 214,957 6,315 255,000 3,768,624 1,009,009 79,154 27,000 50,000 10,500 44,200 1,300 1,221,163 Actual Balance YTD 9/30/2009 Available % of Budget 52,848 $ 26,538 66.570/1 1,641 (631) 162.500/( 234,607 154,272 60.330/( 113,228 29,604 79.270/( 119,241 136,887 46.560/( 109,617 130,489 45.650/c 1,042,780 174,986 85.630/c 4,286 28,460 13.090/c 169,304 73,840 69.630/c 180,489 102,230 63.840/c 258,137 149,499 63.330/c 159,139 55,818 74.030/c - 6,315 0.00% - 255,000 0.00% 2,445,316 1,323,308 64.890/c 195,054 813,956 19.33% 42,878 36,276 54.17% 4,628 22,372 17.14% 81,222 (81,222) - - 50,000 0.00% 1,979 8,521 18.85% 17,621 26,579 39.87% 186 1,114 14.34% 343,568 877,595 28.13% 1,759,790 786,791 973,000 44.71 % 1,389,531 813,034 576,497 58.51 % 118,679 81,857 36,821 68.97% 269,271 134,797 134,474 50.06% 3,537,271 1,816,480 1,720,791 51.35% 8,527,058 4,605,363 3,921,695 54.01 % 4,000 - 4,000 0.00% 161,895 - 161,895 0.00% 10,000 - 10,000 0.00% 175,895 175,895 0.00% GO Tax Increment Bonds of 1998A - - - - Total Debt Service Funds - - - - Equipment, Bldg & Replacement 156,068 131,991 24,077 84.57% Public Safety Capital 103,935 58,161 45,774 55.96% Capital Improvement Fund (PIR) 1,634,250 922,084 712,166 56.42% Total Capital Funds 1,894,253 1,112,236 782,017 58.72% Water 74,140 60,170 13,971 81.16% Sanitary Sewer 216,100 64,085 152,015 29.66% Recycling - - - _ Surface Water Management 414,500 22,101 392,399 5.33% Total Enterprise Funds 704,740 146,355 558,385 20.77% Total Capital Outlay 2,774,888 1,258,591 1,516,297 45.36% Debt Service GO Tax Increment Bonds of 1998A 278,475 278,425 50 99.98% Total Debt Service 278,475 278,425 50 99.98% Other Financinq Uses Mayor & Council - - - _ Elections - - - _ Administration - - - - Finance & Support Services - - - - Planning & Zoning - - - - Government Buildings - - - _ Public Safety - _ _ _ Emergency Mangement - - - _ Protective Inspections - - - - Street Maintenance - - _ _ Park Maintenance - _ _ _ Recreation - _ _ _ Transfers - _ _ _ Total General Fund - - - - 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 278,475 253,175 25,300 90.91 % Total Special Revenue Funds 278,475 253,175 25,300 90.91 % GO Tax Increment Bonds of 1998A - - - - Total Debt Service Funds - - - - Equipment, Bldg & Replacement - - - - Public Safety Capital - - - - Capital Improvement Fund (PIR) - - - - Total Capital Funds - - - - Water 39,500 - 39,500 0.00% Sanitary Sewer 58,500 - 58,500 0.00% Recycling _ _ _ _ Surface Water Management 34,500 - 34,500 0.00% Total Enterprise Funds 132,500 - 132,500 0.00% Total Other Financing Uses 410,975 253,175 157,800 61.60% Total Expenditures $ 11,991,396 $ 6,395,555 $ 5,595,841 53.33% City of Arden Hills General Fund Summary 2009 Budget Revenues Taxes 101-41300-31010 Current Ad Valorem Taxes 101-41300-31011 Payments in Leiu of Taxes 101-41300-31020 Delinquent Ad Valorem Taxes 101-41300-31030 Mobile Home Tax 101-41300-31040 Fiscal Disparities 101-41300-31910 Penalties & Interest on Taxes 101-41300-31910 Penalties & Interest on Taxes 101-41300-31920 Forfeited Tax Sales Total Taxes Licenses and Permits 101-41300-32110 Liquor, On Sale & Sunday 101-41300-32111 Liquor, Off Sale 101-41910-32170 Rental Regulations 101-41300-32160 Contractors 101-41300-32180 Business Licenses 101-41300-32181 Other Business Lic/Permits 101-42400-32210 Plan Review & Bldg Permits 101-42400-32220 Mechanical Permits 101-42400-32230 Plumbing Permits 101-41300-32240 Animal Licenses 101-41910-32250 Sign Permits 101-42400-32260 Electrial Permits 101-42400-32270 Utility Permit Fees 101-42400-32275 Fire Suppression Permits I101-42400-32278 Fire Permit Plan Check Fee 101-41910-32279 Erosion/Grading Permit 101-41300-32280 Other Nonbusiness Lic/Permits Total Licenses and Permits Intergovernmental Revenues 101-41300-33402 Market Value Homestead Credit 101-41300-33403 Mobile Home Homestead Credit 101-41300-33420 State PERA Aid 101-42100-33416 Police Aid 101-43100-33418 MSA Maintenance 101-41910-33422 State Grants 101-41410-33621 Other County Grants & Aids Other Intergovernmental Charges for Services 101-41910-34103 Zoning and Subdivision Fees 101-41910-34104 Plan Checking Fees 101-41300-34105 Sale of Maps and Publications 101-41910-34106 Plat & Other Fees 101-41300-34108 Admin Chgs from other funds 101-41500-34108 Admin Chgs from other funds 101-41940-34108 Admin Chgs from other funds 101-41910-34110 Zoning Permit Fees 101-41300-34120 Water Tower Antenna Rentals 101-41300-34121 Other General Govt Charges 101-42100-34202 False Alarms 101-42100-34206 Impound Fees 101-42400-34207 State Building Code Surcharges 101-42400-34208 City Building Code Surcharges 101-45200-34300 Park Facility Rental Fees 101-45120-34730 Summer Playground Fees 101-45120-34740 Summer Trip Fees 101-45120-34781 Adult Programs 101-45120-34782 Youth Programs 101-45120-34785 Adult Softball 101-45120-34790 After School Programs 101-45120-34791 Special Events Programs 101-41910-34950 Other Charges for Services Proposed Actual Balance YTD Proposed 9/30/2009 Available % of Budaet 2,961,994 1,336,756 1,625,238 45.1 7,000 19,610 (12,610) 280.1 7,500 1,526 5,974 20.3 - 135,614 (135,614) - 539 (539) 323 (323) 2,976,494 1,494,369 1,482,125 50.21 % 32,500 24,750 7,750 76.15% - 400 (400) - - 2,120 (2,120) - 5,000 4,320 680 86.40% 13,000 10,521 2,479 80.93% - 300 (300) - 125,000 80,861 44,140 64.69% 20,000 15,331 4,669 76.66% 10,000 5,340 4,660 53.40% 3,500 1,233 2,268 35.21 % 1,000 550 450 55.00% 20,000 18,735 1,265 93.68% 300 6,080 (5,780) 2026.67% 6,000 4,337 1,663 72.28% 3,000 1,621 1,379 54.04% 2,500 465 2,035 18.60% - 1,025 (1,025) - 241,800 177,988 63,812 73.61 % 5,179 2,590 2,590 50.00% 44,000 - 44,000 0.00% 64,000 67,649 (3,649) 105.70% 113,179 70,239 42,941 62.06% 40,000 29,327 10,673 73.320/( - 2 (2) 12,000 5,464 6,536 45.530/( 13,735 - 13,735 0.000/( 28,357 - 28,357 0.000/( 92,937 - 92,937 0.00O/C 750 1,104 (354) 147.200/( 73,760 52,340 21,420 70.960/c 3,300 3,365 (65) 101.980/C 2,000 300 1,700 15.00°/a 200 - 200 0.00°/a 8,000 4,254 3,746 53.17°/a 1,000 881 120 88.05°/a 3,500 3,598 (98) 102.80% 13,000 10,704 2,296 82.34% - 34 (34) - 15,500 14,500 1,000 93.55% 42,500 40,341 2,159 94.92% - 1,840 (1,840) - 15,000 11,687 3,314 77.91 % 3,000 3,271 (271) 109.03% - 50 (50) - Total Charges for Services 368,539 183,061 185,478 49.67% Fines & Forfeits 101-42100-35110 Highway Patrol Fines 3,000 101-42100-35130 DWI Forfeitures 1,000 101-42100-35140 Violations Bureau 30,000 101-42100-35200 Forfeets - 101-42100-35150 Tobacco Fines - Total Fines & Forfeits 34,000 Miscellaneous 101-41300-36210 Interest Income 40,000 101-41300-36230 Contributions/Donations 3,600 101-41940-36230 Contributions & donations - 101-45120-36230 Contributions & donations - 101-41910-36240 Developer Reimbursements - 101-41940-36270 Developer Reimbursements - 101-41910-36280 Other Miscellaneous Revenue - 101-43100-36270 Miscellaneous Reimbursements 450 101-41300-36270 Miscellaneous Reimbursement 4,000 101-41500-36270 Miscellaneous Reimbursement 3,000 101-43100-36275 Private Street Light Reimburseme - 101-42400-36280 Fire Inspection Reimbursement - Total Miscellaneous 51,050 Total Operating Revenues 3,785,062 Other Financing Sources 101-42100-39101 Sales of General Fixed Assets - 101-45200-39203 Transfer - Total Other Financing Sources - Total General Fund Revenue $ 3,785,062 $ Operating Expenses Mayor & Council $ 79,386 $ Elections 1,010 Administration 388,879 Finance & Support Services 142,832 Planning & Zoning 256,128 Government Buildings 240,106 Public Safety 1,217,766 Emergency Management 32,746 Protective Inspections 243,144 Street Maintenance 282,719 Park Maintenance 407,636 Recreation 214,957 Reserves/Contingency 6,315 Transfers 255,000 Total Operating Expenses 3,768,624 Capital Outlav Mayor & Council - Elections - Administration - Finance & Support Services - Planning & Zoning - Government Buildings - Public Safety - Emergency Management - Protective Inspections - Street Maintenance - Park Maintenance - Recreation - Transfers - Total Capital Outlay - Total General Fund Expenses $ 3,768,624 $ Revenue Over/(Under) Expenses 16,438 772 2,228 25.72% - 1,000 0.00% 17,609 12,391 58.70% 347 (347) - 18,728 15,272 55.08% 6,846 33,154 17.11 °/a 1,610 1,990 44.73°/a 200 (200) 147 (147) - 312 138 69.33% 1,296 2,704 32.40% 20 2,980 0.67% 10,431 40,619 20.43% 1,954,816 1,830,247 51.65% 1,954,816 $ 1,830,247 51.65% 52,848 $ 26,538 66.57% 1,641 (631) 162.50% 234,607 154,272 60.33% 113,228 29,604 79.27% 119,241 136,887 46.56% 109,617 130,489 45.65% 1,042,780 174,986 85.63% 4,286 28,460 13.09% 169,304 74,246 69.63% 180,489 102,230 63.84% 258,137 149,499 63.33% 159,139 55,818 74.03% - 6,315 0.00% - 255,000 0.00% 2,445,316 1,323,714 64.89% 2,445,316 $ 1,323,714 64.89% (490,501) 506,533 City of Arden Hills Special Revenue Fund Summary Proposed Actual Balance YTD FY 2009 9/30/2009 Available % of Budaet Operating Expenses TCAAP $ 1,009,009 $ 195,054 $ 813,956 19% Cable Fund 79,154 42,878 36,276 54% Risk Management 27,000 4,628 22,372 17% Park Fund - 81,222 (81,222) - Community Services 50,000 - 50,000 0% EDA General Fund 10,500 1,979 8,521 19% EDA TIF Dist #3 Cottage Villas 44,200 17,621 26,579 40% EDA Revolving Fund - - - - EDA TIF Dist #2 Round Lake 1,300 186 1,114 14% Total Operating Expenses 1,221,163 343,568 877,595 28% Capital Outlay TCAAP - - - - Cable Fund 4,000 - 4,000 0% Risk Management - - - - Park Fund 161,895 - 161,895 0% Community Services - - - - EDA General Fund 10,000 - 10,000 0% EDA TIF Dist #3 Cottage Villas - - - - EDA Revolving Fund EDA TIF Dist #2 Round Lake - - - - Total Capital Outlay 175,895 - 175,895 0% Other Finance Uses TCAAP - - - - Cable Fund - - - - Risk Management - - - - Park Fund - - - - Community Services - - - - EDA General Fund - - - - EDA TIF Dist #3 Cottage Villas - - - - EDA Revolving Fund - - - - EDA TIF Dist #2 Round Lake 278,475 253,175 25,300 91 % Total Other Financing Uses 278,475 253,175 25,300 91 % Total Special Revenue Funds $ 1,675,533 $ 596,743 $ 1,078,790 36% Proposed Actual Balance YTD FY 2009 YTD 3/31/2009 Available % of Budget Operating Revenue TCAAP $ 1,001,000 $ (259,736) $ 1,260,736 -26% Cable Fund 83,000 64,874 18,126 78% Risk Management 10,000 7,675 2,325 77% Park Fund 204,000 10,473 193,527 5% Community Services 50,500 33,906 16,594 67% EDA General Fund 5,000 9,160 (4,160) 183% EDA TIF Dist #3 Cottage Villas 51,000 20,273 30,727 40% EDA Revolving Fund 5,000 1,344 3,656 27% EDA TIF Dist #2 Round Lake 435,000 251,061 183,939 58% Total Operating Revenues 1,844,500 139,029 1,705,471 8% Other Financing Sources TCAAP - - - - Cable Fund - - - - Risk Management - - - - Park Fund - - - - Community Services - - - - EDA General Fund 25,000 - 25,000 0% EDA TIF Dist #3 Cottage Villas - - - - EDA Revolving Fund EDA TIF Dist #2 Round Lake - - - - Total Other Financing Sources 25,000 - 25,000 0% Total Special Revenue Funds $ 1,869,500 $ 139,029 $ 1,730,471 7% City of Arden Hills Debt Service Fund Summary Proposed Actual Balance YTD FY 2009 9/30/2009 Available % of Budget Debt Service GO Tax Increment Bonds of 1998A $ 278,475 $ 278,425 $ 50 100% Total Operating Expenses 278,475 278,425 50 100% Other Finance Uses GO Tax Increment Bonds of 1998A - - - - Total Capital Outlay - - - - Total Debt Service $ 278,475 $ 278,425 $ 50 100% I Proposed Balance YTD l FY 2009 Available % of Budget Operating Revenue GO Tax Increment Bonds of 1998A $ Total Operating Revenues Other Financing Sources GO Tax Increment Bonds of 1998A - $ (11) $ 11 - 278,475 253,175 25,300 91 % Total Other Financing Sources 91 % 91% 278,475 253,175 25,300 Total Debt Service $ 278,475 $ 253,164 $ 251311 City of Arden Hills Capital Fund Summary Proposed Actual Balance YTD FY 2009 9/30/2009 Available % of Budaet Capital Outlay Equipment, Bldg & Replacement 156,068 131,991 24,077 85% Public Safety Capital 103,935 58,161 45,774 56% Capital Improvement Fund (PIR) 1,634,250 922,084 712,166 56% Total Capital Outlay 1,894,253 1,112,236 782,017 59% Other Finance Uses Equipment, Bldg & Replacement - - _ - Public Safety Capital Capital Improvement Fund (PIR) Total Other Financing Uses - _ _ _ Total Special Revenue Funds $ 1,894,253 $ 1,112,236 782,017 59% Proposed Actual Balance YTD FY 2009 3/31/2009 Available % of Budget Operating Revenue Equipment, Bldg & Replacement $ - $ _ _ _ Public Safety Capital Capital Improvement Fund (PIR) 52,000 372,000 4,845 356,770 47,155 15,230 9% 96% Total Operating Revenues 424,000 361,615 62,385 85% Other Financing Sources Equipment, Bldg & Replacement Public Safety Capital Capital Improvement Fund (PIR) 204,000 50,000 200,000 - - - 204,000 50,000 200,000 0% 0% 0% Total Other Financing Sources 454,000 - 454,000 0% Total Special Revenue Funds $ 878,000 $ 3611615 516,385 41 % City of Arden Hills Enterprise Fund Summary Proposed Actual Balance YTD FY 2009 9/30/2009 Available % of Budaet Operating Expenses Water $ 1,759,790 $ 786,791 $ 973,000 45% Sanitary Sewer 1,389,531 813,034 576,497 '59% Recycling 118,679 81,857 36,821 69% Surface Water Management 269,271 134,797 134,474 50% Total Operating Expenses 3,537,271 1,816,480 1,720,791 51 % Capital Outlay Water 74,140 60,170 13,971 81 % Sanitary Sewer 216,100 64,085 152,015 30% Recycling - _ - - Surface Water Management 414,500 22,101 392,399 5% Total Capital Outlay 704,740 146,355 558,385 21 % Other Finance Uses Water 39,500 - 39,500 0% Sanitary Sewer 58,500 - 58,500 0% Recycling _ _ _ _ Surface Water Management 34,500 - 34,500 0% Total Other Financing Uses 132,500 - 132,500 0% Total Enterprise Funds $ 4,374,511 $ 1,962,835 $ 2,411,676 45% Proposed Actual Balance YTD FY 2009 9/30/2009 Available % of Budaet Operating Revenue Water $ 1,443,942 $ 1,117,478 $ 326,464 77% Sanitary Sewer 1,226,200 788,137 438,063 64% Recycling 119,404 64,184 55,220 54% Surface Water Management 427,660 333,288 94,372 78% Total Operating Revenues 3,217,206 2,303,088 914,118 72% Other Financing Sources Water - Sanitary Sewer _ _ _ _ Recycling - _ _ - Surface Water Management - _ - _ Total Other Financing Sources - - _ - Prior Period Adjustment (Recycling) Total Enterprise Funds $ 3,217,206 $ 2,303,088 $ 914,118 72%