|
<br />CITY OF RAMSEY - FINANCIAL DASHBOARD
<br />QUARTERLY UPDATE-PERIOD ENDING JUNE 30, 2011
<br />BOND RATING:AA+As of November 2009 (Reaffirmed August 2011)
<br />BUDGET TO DATE: June 30, 2011
<br />ADOPTED BUDGET 2010YTD ACTUALS 2010ADOPTED BUDGET 2011YTD ACTUALS 2011
<br />Adopted Adopted Adopted Adopted
<br />RevenueExpenditureYTD Rev. 2010YTD Exp. 2010RevenueExpenditureYTD Rev. 2011YTD Exp. 2011
<br />General Fund$ 9,698,041 $ 9,698,041 $ 516,123$ 3,472,656 $ 9,449,400 $ 9,449,400 $ 598,895$ 3,331,628
<br />EDA$ 291,705$ 291,705$ -$ 141,532 $ 291,705$ 291,705$ -$ 53,946
<br />HRA$ 410,124$ 410,124$ -$ 193,813 $ 371,049$ 647,926$ 60,000$ 308,799
<br />Water Fund$ 1,911,226 $ 1,481,910 $ 181,774$ 247,926 $ 1,860,075 $ 1,484,255 $ 725,914$ 253,980
<br />Sewer Fund$ 1,373,761 $ 1,204,728 $ 271,781$ 316,772 $ 1,324,830 $ 1,274,244 $ 641,286$ 363,302
<br />Street Lighting$ 193,368$ 171,479$ 43,534$ 50,739$ 191,678$ 187,328$ 88,724$ 65,569
<br />Recycling Fund$ 335,673$ 323,392$ 73,974$ 153,705 $ 336,079$ 324,392$ 147,970$ 151,412
<br />Storm Water Fund$ 614,184$ 395,069$ 154,693$ 57,340$ 614,184$ 395,928$ 316,012$ 54,122
<br />CASH & INVESTMENTS: June 30, 2011
<br />Village Bank Checking$ 1,241,568
<br />4M Savings$ 2,649,031
<br />Agencies $ 15,267,390
<br />Certificates of Deposits$ 10,417,269
<br />Municipal Bonds$ 13,580,000
<br /> Less Discounts Paid on Invest)$ (1,718,787)
<br /> Total Cash & Investments$ 41,436,471
<br />CASH FLOWS:
<br />ĂƐŚ&ůŽǁƐϮϬϬϮͲ:ƵŶĞϮϬϭϭ
<br />YearCash Flows
<br />60,000,000.00
<br />54,000,743
<br />44,417,830
<br />2004 41,175,419
<br />50,000,000.00
<br />52,288,333
<br />42,982,918
<br />2005 49,665,371
<br />41,175,419
<br />49,665,371
<br />2006 42,982,918
<br />46,312,884
<br />40,000,000.00
<br />2007 52,288,333
<br />41,436,471
<br />2008 54,000,743
<br />30,000,000.00
<br />Cash Flows
<br />2009 46,312,884
<br />2010 44,417,830
<br />20,000,000.00
<br />11-Jun 41,436,471
<br />10,000,000.00
<br />-
<br />200420052006200720082009201011-Jun
<br />CASH FLOWS DETAIL:
<br />Cash Detail20042005200620072008200920106/2011
<br />Revenues:
<br /> Daily Deposits$ 17,045,349 $ 22,606,303 $ 20,538,237 $ 14,880,623 $ 11,106,091 $ 10,435,320 $ 9,848,790 $ 4,622,006
<br /> Tax Settlements$ 7,746,031 $ 8,629,156 $ 10,167,987 $ 11,799,207 $ 12,436,239 $ 13,809,380 $ 12,631,192 $ 235,999
<br /> Bond Proceeds$ 336,205$ 10,103,167 $ 9,157,679 $ 6,184,685 $ -$ 1,302,616 $ -$ -
<br /> Interest Earnings$ 1,023,555 $ 1,274,236 $ 1,726,436 $ 1,876,393 $ 1,822,313 $ 1,601,042 $ 1,032,275 $ 488,107
<br />Expenditures
<br /> Accounts Payable$ (5,911,760)$ (17,863,383)$ (19,023,267)$ (13,844,597)$ (14,934,001)$ (20,948,142)$ (13,090,662)$ (5,532,452)
<br /> Pay Estimates$ (9,534,423)$ (11,225,921)$ (22,858,721)$ (4,226,511)$ (2,028,001)$ (6,133,618)$ (5,671,919)$ (165,155)
<br /> Payroll$ (2,719,270)$ (3,092,730)$ (3,316,983)$ (3,588,329)$ (3,680,767)$ (3,713,415)$ (3,567,183)$ (1,737,459)
<br /> Debt Service$ (1,838,030)$ (1,940,720)$ (3,073,821)$ (3,775,998)$ (3,009,422)$ (4,041,040)$ (3,077,547)$ (892,404)
<br /> Misc$ (12)$ (157)$ (59)$ (43)
<br />Beginning Balance$ 35,027,774 $ 41,175,419 $ 49,665,371 $ 42,982,918 $ 52,288,333 $ 54,000,742 $ 46,312,884 $ 44,417,830
<br />Net Cash$ 41,175,419 $ 49,665,371 $ 42,982,918 $ 52,288,333 $ 54,000,742 $ 46,312,884 $ 44,417,830 $ 41,436,471
<br />
<br />
|