|
CITY OF ANYTOWN
<br />FUND BALANCE ILLUSTRATION
<br />SCENARIO 1- USE OF EXCESS FUND BALANCE IN 2013
<br />SCENARIO 2- USE OF EXCESS FUND BALANCE OVER TINE
<br />2011
<br />2012
<br />%
<br />2013
<br />%
<br />2014
<br />%
<br />2015
<br />ACTUAL
<br />BUDGET
<br />INC.
<br />BUDGET
<br />INC.
<br />BUDGET
<br />INC.
<br />REVENUES
<br />BUDGET
<br />INC.
<br />BUDGET
<br />INC.
<br />GENERALTAXES
<br />$
<br />9,000,000
<br />$
<br />8,880,000
<br />-1.33%
<br />$
<br />9,031,260
<br />1,70%
<br />$
<br />9,550,872
<br />5.75%
<br />OTHER REVENUE
<br />1,000,000
<br />1,020,000
<br />2.00%
<br />1,040,400
<br />2.00%
<br />GENERALTAXES
<br />1,061,208
<br />2.00%
<br />EXCESS FUND BALANCE
<br />8,980,000
<br />-
<br />$
<br />300,000
<br />2.04%
<br />$
<br />332,340
<br />3.59%
<br />$
<br />-
<br />2.62%
<br />TOTAL REVENUE
<br />$
<br />10,000,000
<br />$
<br />10,200,000
<br />2.00%
<br />$
<br />10,404,000
<br />2.00%
<br />10,612,080
<br />2.00%
<br />EXPENDITURES
<br />1,082,432
<br />2.00%
<br />EXCESS FUND BALANCE
<br />-
<br />200,000
<br />200,000
<br />BUDGET
<br />57,907
<br />10,000,000
<br />10,200,000
<br />2.00%
<br />TOTAL REVENUE
<br />10,404,000
<br />2,00%
<br />$
<br />10,612,080
<br />2.00%
<br />ACTUAL
<br />10,404,000
<br />9,700,000
<br />10,000,000
<br />3.09%
<br />10,404,000
<br />4.04%
<br />10,612,080
<br />2.00%
<br />REVENUES OVER EXPENDITURES
<br />$
<br />300,000
<br />$
<br />200,000
<br />$
<br />-
<br />$
<br />-
<br />TARGETED FUND BALANCE (41.5 %)
<br />$
<br />4,233,000
<br />$
<br />4,317,660
<br />$
<br />4,404,013
<br />10,000,000
<br />$
<br />4,492,093
<br />2.00%
<br />ACTUAL FUND BALANCE
<br />$
<br />4,750,000
<br />$
<br />4,650,000
<br />2.00%
<br />$
<br />4,317,660
<br />2.00%
<br />$
<br />4,317,660
<br />9,700,000
<br />EXCESS FUND BALANCE
<br />$
<br />517,000
<br />$
<br />332,340
<br />4.04%
<br />$
<br />(86,353)
<br />2.00%
<br />$
<br />(174,433)
<br />1.30%
<br />SCENARIO 2- USE OF EXCESS FUND BALANCE OVER TINE
<br />2011
<br />2012
<br />%
<br />2013
<br />%
<br />2014
<br />%
<br />2015
<br />%
<br />ACTUAL
<br />BUDGET
<br />INC.
<br />BUDGET
<br />INC.
<br />BUDGET
<br />INC.
<br />BUDGET
<br />INC.
<br />REVENUES
<br />GENERALTAXES
<br />$
<br />9,000,000
<br />$
<br />8,980,000
<br />-0.22%
<br />$
<br />9,163,600
<br />2.04%
<br />$
<br />9,492,965
<br />3.59%
<br />$
<br />9,741,889
<br />2.62%
<br />OTHER REVENUE
<br />1,000,000
<br />1,020,000
<br />2.00%
<br />1,040,400
<br />2.00%
<br />1,061,208
<br />2.00%
<br />1,082,432
<br />2.00%
<br />EXCESS FUND BALANCE
<br />-
<br />200,000
<br />200,000
<br />57,907
<br />-
<br />TOTAL REVENUE
<br />$
<br />10,000,000
<br />$
<br />10,200,000
<br />2.00%
<br />$
<br />10,404,000
<br />2.00%
<br />10,612,080
<br />10,824,322
<br />EXPENDITURES
<br />BUDGET
<br />$
<br />10,000,000
<br />$
<br />10,200,000
<br />2.00%
<br />$
<br />10,404,000
<br />2.00%
<br />$
<br />10,612,080
<br />2.00%
<br />$
<br />10,824,322
<br />2.00%
<br />ACTUAL
<br />$
<br />9,700,000
<br />$
<br />10,000,000
<br />3.09%
<br />$
<br />10,404,000
<br />4.04%
<br />$
<br />10,612,080
<br />2.00%
<br />$
<br />10,750,000
<br />1.30%
<br />REVENUES OVER EXPENDITURES
<br />$
<br />300,000
<br />$
<br />200,000
<br />$
<br />-
<br />$
<br />-
<br />$
<br />74,322
<br />TARGETED FUND BALANCE (41.5 %)
<br />$
<br />4,233,000
<br />$
<br />4,317,660
<br />$
<br />4,404,013
<br />$
<br />4,492,093
<br />$
<br />4,581,935
<br />ACTUAL FUND BALANCE
<br />$
<br />4,750,000
<br />$
<br />4,750,000
<br />$
<br />4,550,000
<br />$
<br />4,492,093
<br />$
<br />4,566,415
<br />EXCESS FUND BALANCE
<br />$
<br />517,000
<br />$
<br />432,340
<br />$
<br />145,987
<br />$
<br />(0)
<br />$
<br />(15,521)
<br />
|