|
EQUIPMENT REVOLVING FUND - CASHFLOW PROJECTIONS
<br />Ac Actual Actual Actual Estimated Estimated Estimated Estimated Estimated Estimated
<br />2007 2008 2009 2010 2011 2012 2013 2014 2015
<br />FUND BALANCE, Beginning of Year 4,502,838.85 4,373,43690 3,669,695.17 3,609,06122 3,265,28358 3,171,662.83 3,089,204.77. 2,996,783.85 2,947,187.60
<br />REVENUES:
<br />Transfers from General Fund:
<br />Excess Revenue
<br />Sale of Fixed Assets
<br />Prn Sunfish Commons
<br />Int Sunfish Commons
<br />Interest Earnings
<br />Total Revenues
<br />=ENDrI [TRES:
<br />Capital Outlay:
<br />Parks CEP
<br />General Government
<br />Fire
<br />Parks/PW
<br />Police
<br />Transfers to General Fund
<br />Debt Service on Equipment Certificates
<br />Debt Service on Muni Bldg
<br />Capital Outlay
<br />Muni Center Remodel
<br />Fire Station Generator
<br />PW Repair parts on sweeper
<br />Fuse Station 42 Rebr ild
<br />Sign Making Equipment
<br />Total Expenditures
<br />Increase (Decrease) in Cash
<br />FUND BALANCE, End of Year
<br />9,348.86
<br />- 0.00
<br />0.00
<br />0.00
<br />0.00
<br />0.00
<br />0.00
<br />0.00
<br />0.00
<br />0.00
<br />2,500.00
<br />0.00
<br />0.00
<br />0.00
<br />0.00
<br />0.00
<br />0.00
<br />0.00
<br />11,273.00
<br />11,87337
<br />11,43859
<br />0.00
<br />0.00.
<br />0.00
<br />0.00
<br />0.00
<br />0.00
<br />1,53226
<br />931.89
<br />299.56
<br />0.00
<br />0.00
<br />0.00
<br />0.00
<br />0.00
<br />0.00
<br />257,450.72
<br />210,701.04
<br />128,977.87
<br />54,13592
<br />48,979.5
<br />47,574.94
<br />46,338.07
<br />44,951.76
<br />44,207.81
<br />279,604.84
<br />226,00630
<br />140,716.02
<br />54,135.92
<br />48,97925
<br />47,57494
<br />46,338.07
<br />44,951.76
<br />44,207.81
<br />49,000.00
<br />139,802.42
<br />113,003.15
<br />26,200.00
<br />16,000.00
<br />6,775.00
<br />23, 787.47
<br />2,254.00
<br />22,475.88
<br />22,103.91
<br />Allowable interest earnings -NEW Capital Purch
<br />529,93252
<br />17,600.00
<br />32,000.00-
<br />740,361.64
<br />90,151.00
<br />21,101.00
<br />811,807.77
<br />834,283.65
<br />856,38756
<br />New Capital Purchase
<br />Remaining Interest Earnings
<br />87,200.00
<br />0
<br />109,448.00
<br />32,302.00
<br />71,193.00
<br />6,226.00
<br />0.00
<br />0.00
<br />0.00
<br />93,850.00
<br />94,600.00
<br />13,810.00
<br />16,306.00
<br />0.00
<br />0.00
<br />811,807.77
<br />217,629.74
<br />-
<br />298,628.00
<br />354,615.79
<br />392,200.00
<br />201,349.97
<br />43,726.69
<br />120,000.00
<br />21,29029
<br />9,336.87
<br />5,391.00
<br />409,006.79
<br />929,748.03
<br />201,34997
<br />397,913.56
<br />142,600.00
<br />130,033.00
<br />138,759.00
<br />94548.00
<br />6,226.00
<br />(129,401-95)
<br />(703,741-73)
<br />(60,633-95)
<br />(343,777-64)
<br />(93,620,75)
<br />(82,458.06)
<br />(9 2,42093)
<br />(4959624)
<br />37,981.81
<br />4,373 436 90
<br />3,669,695-17
<br />3 609 06122
<br />3265,28358
<br />3,171,662.83
<br />3 089204.77
<br />299 ,783.85
<br />2,947,187.6
<br />2985,169.42
<br />Summary Of Capital Oulay New Purchases (per policy adopted 12 -18-01)
<br />50% interest earnings/excessrevenue
<br />139,802.42
<br />113,003.15
<br />70,358.01
<br />27,06796
<br />24, 489.63
<br />23, 787.47
<br />23,169.04
<br />22,475.88
<br />22,103.91
<br />Allowable interest earnings -NEW Capital Purch
<br />529,93252
<br />642,935.67
<br />713293.68
<br />740,361.64
<br />764,85127
<br />788,638.74
<br />811,807.77
<br />834,283.65
<br />856,38756
<br />New Capital Purchase
<br />Remaining Interest Earnings
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />856,387.56
<br />529,93252
<br />642,935.67
<br />713,293.68
<br />740,361.64
<br />764,85127
<br />788,638.74
<br />811,807.77
<br />834,283.65
<br />11/9f2010 •
<br />
|