Agenda - Council - 10/11/2011 - Laserfiche WebLink

Home

CITY OF RAMSEY - FINANCIAL DASHBOARD QUARTERLY UPDATE - PERIOD ENDING JUNE 30, 2011 BOND RATING: AA+ As of November 2009 (Reaffirmed August 2011) BUDGET TO DATE: June 30, 2011 General Fund EDA HRA Water Fund Sewer Fund Street Lighting Recycling Fund Storm Water Fund ADOPTED BUDGET 2010 Adopted Adopted Revenue Expenditure ADOPTED BUDGET 2011 Adopted Adopted Revenue Expenditure $ 9,698,041 $ 291,705 $ 410,124 $ 1,911,226 $ 1,373,761 $ 193,368 $ 335,673 $ 614,184 $ 9,698,041 $ 291,705 $ 410,124 $ 1,481,910 $ 1,204,728 $ 171,479 $ 323,392 $ 395,069 YTD ACTUALS 2010 YTD Rev. 2010 YTD Exp. 2010 $ 516,123 $ 3,472,656 $ - $ 141,532 $ $ 193,813 $ 181,774 $ 247,926 $ 271,781 $ 316,772 $ 43,534 $ 50,739 $ 73,974 $ 153,705 $ 154,693 $ 57,340 $ 9,449,400 $ 291,705 $ 371,049 $ 1,860,075 $ 1,324,830 $ 191,678 $ 336,079 $ 614,184 $ 9,449,400 $ 291,705 $ 647,926 $ 1,484,255 $ 1,274,244 $ 187,328 $ 324,392 $ 395,928 YTD ACTUALS 2011 YTD Exp. % of YTD Rev. 2011 % of Budget 2011 Budget $ 598,895 $ $ 60,000 $ 725,914 $ 641,286 $ 88,724 $ 147,970 $ 316,012 6.34% 0.00% 16.17% 39.03% 48.41% 46.29% 44.03% 51.45% $ 3,331,628 $ 53,946 $ 308,799 $ 253,980 $ 363,302 $ 65,569 $ 151,412 $ 54,122 35.26% 18.49% 47.66% 17.11% 28.51% 35.00% 46.68% 13.67% CASH & INVESTMENTS: June 30, 2011 Village Bank Checking 4M Savings Agencies Certificates of Deposits Municipal Bonds Less Discounts Paid on Invest) Total Cash & Investments $ 1,241,568 $ 2,649,031 $ 15,267,390 $ 10,417,269 $ 13,580,000 $ (1,718,787) $ 41,436,471 ICASH FLOWS: 60,000,000.00 50,000,000.00 40,000,000.00 30,000,000.00 20,000,000.00 10,000,000.00 2004 2005 Cash Flows 2004 - June 2011 2006 2007 2008 9 -Jun 10 -Jun 11 -Jun EDIALMTEMITIII Revenues: Daily Deposits Tax Settlements Bond Proceeds Interest Earnings Expenditures Accounts Payable Pay Estimates Payroll Debt Service Misc Beginning Balance Net Cash 2004 17,045,349 $ 7,746,031 $ 336,205 $ 1,023,555 $ (5,911,760) $ (9,534,423) $ (2,719,270) $ (1,838,030) $ (12) $ 35,027,774 $ 41,175,419 $ 22,606,303 8,629,156 10,103,167 1,274,236 (17,863,383) (11,225,921) (3,092,730) (1,940,720) (157) 41,175,419 49,665,371 20,538,237 10,167,987 9,157,679 1,726,436 (19,023,267) (22,858,721) (3,316,983) (3,073,821) $ 49,665,371 $ 42,982,918 14,880,623 $ 11,799,207 $ 6,184,685 $ 1,876,393 $ (13,844,597) $ (4,226,511) $ (3,588,329) $ (3,775,998) $ (59) $ 42,982,918 $ 52,288,333 $ 2008 11,106,091 12,436,239 1,822,313 $ 3,925,411 $ 135,166 $ - $ 989,364 (14,934,001) $ (14,055,964) $ (2,028,001) $ (514,739) $ (3,680,767) $ (1,851,077) $ (3,009,422) $ (1,583,514) $ (43) 52,288,333 $ 54,000,742 $ 54,000,742 $ 41,045,388 $ COR Land Purchase $ 4,474,762 $ 111,377 $ $ 538,745 (6,629,112) (2,139,428) (1,782,780) (1,036, 296) 46,312,884 39,850,152 $ 4,622,006 $ 235,999 $ - $ 488,107 $ (5,532,452) $ (165,155) $ (1,737,459) $ (892,404) $ 44,417,830 $ 41,436,471 .--Cash Flows (CASH FLOWS DETAIL: 54,000, /43 41,175,419 -19',-665,371 42 .8,2,918 ,288,333 39,850,152 41,045,388 41,436,471 ■ CITY OF RAMSEY - FINANCIAL DASHBOARD QUARTERLY UPDATE - PERIOD ENDING JUNE 30, 2011 BOND RATING: AA+ As of November 2009 (Reaffirmed August 2011) BUDGET TO DATE: June 30, 2011 General Fund EDA HRA Water Fund Sewer Fund Street Lighting Recycling Fund Storm Water Fund ADOPTED BUDGET 2010 Adopted Adopted Revenue Expenditure ADOPTED BUDGET 2011 Adopted Adopted Revenue Expenditure $ 9,698,041 $ 291,705 $ 410,124 $ 1,911,226 $ 1,373,761 $ 193,368 $ 335,673 $ 614,184 $ 9,698,041 $ 291,705 $ 410,124 $ 1,481,910 $ 1,204,728 $ 171,479 $ 323,392 $ 395,069 YTD ACTUALS 2010 YTD Rev. 2010 YTD Exp. 2010 $ 516,123 $ 3,472,656 $ - $ 141,532 $ $ 193,813 $ 181,774 $ 247,926 $ 271,781 $ 316,772 $ 43,534 $ 50,739 $ 73,974 $ 153,705 $ 154,693 $ 57,340 $ 9,449,400 $ 291,705 $ 371,049 $ 1,860,075 $ 1,324,830 $ 191,678 $ 336,079 $ 614,184 $ 9,449,400 $ 291,705 $ 647,926 $ 1,484,255 $ 1,274,244 $ 187,328 $ 324,392 $ 395,928 YTD ACTUALS 2011 YTD Exp. % of YTD Rev. 2011 % of Budget 2011 Budget $ 598,895 $ $ 60,000 $ 725,914 $ 641,286 $ 88,724 $ 147,970 $ 316,012 6.34% 0.00% 16.17% 39.03% 48.41% 46.29% 44.03% 51.45% $ 3,331,628 $ 53,946 $ 308,799 $ 253,980 $ 363,302 $ 65,569 $ 151,412 $ 54,122 35.26% 18.49% 47.66% 17.11% 28.51% 35.00% 46.68% 13.67% CASH & INVESTMENTS: June 30, 2011 Village Bank Checking 4M Savings Agencies Certificates of Deposits Municipal Bonds Less Discounts Paid on Invest) Total Cash & Investments $ 1,241,568 $ 2,649,031 $ 15,267,390 $ 10,417,269 $ 13,580,000 $ (1,718,787) $ 41,436,471 ICASH FLOWS: 60,000,000.00 50,000,000.00 40,000,000.00 30,000,000.00 20,000,000.00 10,000,000.00 2004 2005 Cash Flows 2004 - June 2011 2006 2007 2008 9 -Jun 10 -Jun 11 -Jun EDIALMTEMITIII Revenues: Daily Deposits Tax Settlements Bond Proceeds Interest Earnings Expenditures Accounts Payable Pay Estimates Payroll Debt Service Misc Beginning Balance Net Cash 2004 17,045,349 $ 7,746,031 $ 336,205 $ 1,023,555 $ (5,911,760) $ (9,534,423) $ (2,719,270) $ (1,838,030) $ (12) $ 35,027,774 $ 41,175,419 $ 22,606,303 8,629,156 10,103,167 1,274,236 (17,863,383) (11,225,921) (3,092,730) (1,940,720) (157) 41,175,419 49,665,371 20,538,237 10,167,987 9,157,679 1,726,436 (19,023,267) (22,858,721) (3,316,983) (3,073,821) $ 49,665,371 $ 42,982,918 14,880,623 $ 11,799,207 $ 6,184,685 $ 1,876,393 $ (13,844,597) $ (4,226,511) $ (3,588,329) $ (3,775,998) $ (59) $ 42,982,918 $ 52,288,333 $ 2008 11,106,091 12,436,239 1,822,313 $ 3,925,411 $ 135,166 $ - $ 989,364 (14,934,001) $ (14,055,964) $ (2,028,001) $ (514,739) $ (3,680,767) $ (1,851,077) $ (3,009,422) $ (1,583,514) $ (43) 52,288,333 $ 54,000,742 $ 54,000,742 $ 41,045,388 $ COR Land Purchase $ 4,474,762 $ 111,377 $ $ 538,745 (6,629,112) (2,139,428) (1,782,780) (1,036, 296) 46,312,884 39,850,152 $ 4,622,006 $ 235,999 $ - $ 488,107 $ (5,532,452) $ (165,155) $ (1,737,459) $ (892,404) $ 44,417,830 $ 41,436,471 .--Cash Flows (CASH FLOWS DETAIL: