HomeMy WebLinkAbout04/16/2013 05B 2012 Year-End Budget Review and Expenditure ReportBUSINESS OF THE CITY COUNCIL
YAKIMA, WASHINGTON
AGENDA STATEMENT
Item No. I;B
For Meeting of: April 16, 2013
ITEM TITLE: 2012 Year -End Budget Revenue and Expenditure Report
SUBMITTED BY: Tony O'Rourke, City Manager
Cindy Epperson, Finance Director
CONTACT Cindy Epperson, 576 -6771
PERSON /TELEPHONE:
SUMMARY EXPLANATION:
As previously projected, actual 2012 budget performance was effectively managed so that
overall departmental expenditures have again been restrained below authorized budget
levels. As a result, the City's final year -end 2012 financial position improved. General
Government Revenues exceeded the original budget by $1.9 million, led by an upward turn
in sales tax after three years of stagnation, brought about by the strength in the agricultural
sector. Expenditures were within the total budget, so that about $731,000 was added to
reserves in 2012, ending with a balance of $10.7 million, which is 17.6% of the 2012
expenditures.
Total 2012 actual expenditure for all funds was $168.5 million compared to the 2012
amended budget of $213.0 million -- $44.5 million or approximately 21 % less than the City
Council's authorized appropriation level, primarily due to deferred spending for major Capital
Improvement Projects, which are or will be re- budgeted for 2013. All other funds ended
2012 with fund balances at expected /acceptable levels.
Conclusion:
Given the current state of the local and national economy, the state of the worldwide affairs
and the related potential impacts to all government entities, City management has taken a
conservative approach to budgeting of revenues and continues to maintain controls on
expenditures. Overall, the 2012 year -end fiscal position reflects that the City of Yakima was
able to effectively manage its economic environment.
Resolution Ordinance Other 2012 Year -End
(specify) Report
Contract: Mail to:
Contract Term: Amount: Expiration Date:
Insurance Required? No
Funding N/A
Source:
APPROVED FOR
SUBMITTAL:
Phone:
4goAa I &iF^&%ftfAA, City Manager
BOARD/COMMISSION RECOMMENDATION:
ATTACHMENTS:
Click to download
111111111 -
MEMORANDUM
April 16, 2013
TO: The Honorable Mayor and
Members of the City Council
FROM: Tony O'Rourke, City Manager
Cindy Epperson, Director of Finance & Budget
SUBJECT: 2012 Year -End Budget Revenue and Expenditure Report
We are submitting for your review the City of Yakima's 2012 year -end actual compared to
budgeted Revenue and Expenditure Report for all city funds. Balances shown are subject to
final adjustments made as a result of the year -end closing process, which will not be officially
concluded until the State Auditor's work is completed. We do not, at this time, expect that any
adjustments will materially affect the balances represented in this report.
This report is summarized by type of fund, and incorporates a shortened version of a new
Financial Monitoring System presentation. Year -end information is reported by functional
type, in the following order:
• Performance at a Glance -- Shortened version of Financial Monitoring System
• City -Wide Overview -- Expenditures and Revenues compared to Budget at a
summarized level by functional fund type
• Fund Balance - Summary of beginning balances, 2012 activity and ending
balances
• Exhibits - Fund detail that supports the summaries:
• Exhibit I - General Government Expenditures
• Exhibit II - Other Operating /Enterprise Funds
• Exhibit III - Capital Improvement Funds
• Exhibit IV - Reserve and Other Funds
o Exhibit V - Bond Redemption Funds
PDFConvert. 2509.1. 2012 _Year- End_Report_short_ version. docx
1 of 13
PERFORMANCE AT A GLANCE
Legend
Revenues exceed budget >5 %, Expenditures below budget >5% Positive
Revenues exceed budget <5 %, Expenditures below budget <5% Normal
Revenues below budget between 3 -5%
Revenues below budget >5% Negative
(1) Funds are graded on a Net Revenue measurement.
PDFConvert. 2509.1. 2012 _Year- End_Report_short_ version. docx
2of13
Status
Page
General Fund
Expenditures
Normal
5/14
Revenues — Overall
Normal
6
Property Tax
N or al
Sales Tax
Positive
Utility Tax
Normal .
Operating/Enterprise Funds a>
Normal
11
Capital Funds (1)
Normal
12
Reserve, Trust & Agency Funds (1)
Normal
13
Bond Redemption Funds")
Normal
14
Legend
Revenues exceed budget >5 %, Expenditures below budget >5% Positive
Revenues exceed budget <5 %, Expenditures below budget <5% Normal
Revenues below budget between 3 -5%
Revenues below budget >5% Negative
(1) Funds are graded on a Net Revenue measurement.
PDFConvert. 2509.1. 2012 _Year- End_Report_short_ version. docx
2of13
CITY -WIDE OVERVIEW
As previously projected, actual 2012 budget performance was effectively managed as our local
economy experienced a modest recovery. As a result of these factors, the City's final year -end 2012
financial position improved from the prior ,
Sales Tax had dropped as a result of the recession in 2009, and remained flat through 2010 and 2011.
There were still mixed messages in the national and regional underlying economic data as to the speed
of the economic recovery, so the 2012 budget was conservatively estimated. Sales Tax started 2012
slightly better than prior year — Through June 2012 we were about 2.4% ahead of 2011 actual, and the
mid -year estimate was based on that rate of growth continuing. Starting in July, the sales tax
rebounded at a much greater rate, and we ended the year 7.2% or about $900,000 ahead of 2011. (Note:
this actual is still about $220,000 less than 2008, as we started seeing the results of the recession late in
that year.)
This growth was driven primarily by good volume, quality and market conditions for the areas
agricultural commodities. Utility taxes were positively affected in the second half of the year because
of large harvests— processing plants are large utility customers.
The property tax levy was higher than originally estimated (we don't know the final levy until after the
budget is adopted each year). Also, we discount our budget estimates for uncollected amounts. We
typically build in about a 4% collection delay, especially in this recessionary time. However, this year,
the actual result was only 2.5% uncollected by year end. In other words, 97.5% of the levy was actually
collected.
As illustrated in Chart I, General Government 2012 actual expenditures were $60,777,181 compared to
the amended budget of $60,810,391- only $33,210 or 0.1% less than budget authorizations. Chart II
shows that actual revenue was $61,503,548, so that the fund balance grew by about $726,000. Because
the revenue was strong, savings from vacancies and other spending restraints were used to shore up
capital and risk management funds - these transfers pushed the actual expenditures almost to the full
budget.
Total 2012 actual expenditures for all funds was $168,551,143 compared to the 2012 amended budget of
$213,008,669 - $44,457,526 or approximately 20.9% less than the City Council's authorized
appropriation level, primarily due to deferred spending for major Capital Improvement Projects, which
are or will be rebudgeted for 2013.
PDFConvert. 2509.1. 2012 _Year- End_Report_short_ version. docx
3of13
2012 EXPENDITURE COMPARISON
(Budget vs. Actual)
General
Parks and Recreation
Street & Traffic Operations
General Government Subtotal
Community Development (11UD grants)
Operating/Enterprise Funds
Capital Funds
G.O. Bond Redemption Funds
Utility Revenue Bond Redemption Funds
Employee Benefit Reserves
Operating Reserves
Trust and Agency Funds
Total
Departments Under Budget (5% or More)
Chart I
Amended
2012
Variance
Budget
Actual
Amount
Percent
$51,562,537
$51,487,698
$74,839
0.1%
4,048,697
4,046,898
1,799
0.0%
5,199,157
5,237,585
(38,428)
(0.7 %)
60,810,391
60,772,181
38,210
0.1%
$3,590,419
2,258,745
1,331,674
37.1%
63,210,183
61,654,123
1,556,060
2.5%
52,435,742
20,285,617
32,150,125
61.3%
3,654,336
3,467,243
187,093
5.1%
4,030,903
3,480,991
549,912
13.6%
14,587,284
13,374,533
1,212,751
8.3%
10,186,186
3,045,038
7,141,148
70.1%
503,225
207,672
295,553
58.7%
$213,008,669
$168,546,143
$44,462,526
20.9%
• The Community Development amended budget includes both the "new" HUD grant and the
obligated carryover from prior year. The unspent funding at the end of 2012 is included in the
encumbrance ordinance, which will add about $1.1 million to their 2013 budget.
• In the Operating /Enterprise funds, most budgets over $1 million were within 5% of total
budget. The Public Safety Communication fund was under spent by $287,000 or 8% because of
position vacancies and the state reinstating its payment of the enhanced 9 -1 -1 telephone bill.
The Stormwater operating fund was under spent by about $300,000 because of position
vacancies and timing of the County's work on the regional coordination and education effort
and rate study.
• Capital funds reflect the progress on major capital projects. About $9 million of the positive
variance is tied to Street projects, including the MLK railroad underpass that was anticipated to
start in 2012. Another $14.2 million is from Wastewater projects; $4.5 million from Water
projects; and $2.4 million from Irrigation projects. These projects are carried forward into the
2013 budget.
• Revenue Bond funds had an error in the budget —a $320,000 debt service payment was
doubled. The balance of the positive variance was the result of a refunding done in the spring
of 2012, which saved Wastewater about $230,000 in 2012.
PDFConvert. 2509.1. 2012 _Year- End_Report_short_ version. docx
4of13
All of the self- insured employee benefit funds were under budget. Because of the potential
volatile nature of these expenditures, the expenditure estimates are set high. The Health Benefit
Reserve fund started 2012 with a balance that was below the state risk manager's recommended
minimum. This fund was able to add over $500,000 to its fund balance, and is in compliance at
the end of 2012.
The Operating Reserve category consists primarily of the Risk Management Reserve Fund. This
budget included $7 million in its budget for potential clean -up of the former city landfill on the
Cascade Mill site. This project has not yet begun, and is being moved to the Yakima
Redevelopment Area capital fund in 2013.
Funds Over Budget
Two funds slightly exceeded their total budget:
The Streets and Traffic Operations budget was over budget by $38,428. This was primarily due
to the timing of expenditures originally planned to be funded by American Recovery
Reinvestment Act (ARRA) grant reimbursement. The lights were purchased within the time -
frame, but not actually installed, which made the purchase ineligible for grant funding.
Revenues still exceeded expenditures by $54,000.
The Transit Operating Fund exceeded budget by about $50,000, primarily due to unforeseen
costs associated with the new Ellensburg route. The good sales tax trend also applies to this
fund, and the ending balance is still above the 60 day reserve target.
PDFConvert. 2509.1. 2012 _Year- End_Report_short_ version. docx
5of13
Chart II
2012 REVENUE COMPARISON
(Budget vs. Actual)
General
Parks and Recreation
Street & Traffic Operations
General Government Subtotal
Community Development
Operating/Enterprise Funds
Capital Funds
G.O. Bond Redemption Funds
Water /Sewer Redemption Funds
Employee Benefit Reserves
Operating Reserves
Trust and Agency Funds
Total
Notable Revenue Variances
Amended
2012
Variance
Budget
Actual
Amount
Percent
$50,469,610
$52,000,981
$1,531,371
3.0%
4,049,765
4,210,889
161,124
4.0%
5,055,310
5,291,678
236,368
4.7%
59,574,685
61,503,548
1,928,863
3.2%
$3,559,555
2,182,119
($1,377,436)
(38.7 %)
61,188,402
64,468,459
3,280,057
5.4%
32,364,114
19,764,241
(12,599,873)
(38.9 %)
3,628,383
3,444,797
(183,586)
(5.1 %)
2,638,249
2,865,324
227,075
8.6%
13,978,285
14,110,181
131,896
0.9%
10,011,500
3,164,410
(6,847,090)
(68.4 %)
543,256
566,064
22,808
4.2%
$187,486,429
$172,069,143
($15,417,286)
(8.2 %)
• Positive General Government revenue variances were explained earlier in the report.
• Revenues for Community Development and the $7 million in Operating Reserves are tied
directly to the expenditures, because they are reimbursable after the funding is spent.
Therefore, the negative revenue variance mirrors the positive expenditure variance noted
above. Many capital projects are also tied to reimbursable funding sources, so there is also a
correlation between reduced expenditures and revenues.
PDFConvert. 2509.1. 2012 _Year- End_Report_short_ version. docx
6of13
FUND BALANCES
CHANGE IN FUND BALANCE
01/01/12
Beginning 2012 2012
General
$8,440,130
Parks and Recreation
296,800
Street & Traffic Operations
1,211,290
General Government Subtotal
9,948,220
Community Development (HUD grants)
$269,747
Operating/Enterprise Funds
14,320,708
Capital Funds
22,065,359
G.O. Bond Redemption Funds
667,958
Utility Revenue Bond Redemption Funds
2,372,255
Employee Benefit Reserves
4,206,032
Operating Reserves
1,162,740
Trust and Agency Funds
646,533
Total
$55.659.552
Chart III
12/31/12
Ending
Actual Rev.
Actual Exp.
Balance
$52,000,981
$51,487,698
$8,953,413
4,210,889
4,046,898
460,791
5,291,678
5,237,585
1,265,383
61,503,548
60,772,181
10,679,587
2,182,119
2,258,745
$193,121
64,468,459
61,654,123
17,135,044
19,764,241
20,285,617
21,543,983
3,444,797
3,467,243
645,512
2,865,324
3,480,991
1,756,588
14,110,181
13,374,533
4,941,680
3,164,410
3,045,038
1,282,112
Chart IV
$3,500,000
$3,000,000
$2,500,000
$2,000,000
$1,500,000
$1,000,000
$500,000
$0
($500,000)
($1,000,000)
FUND BALANCES
Change from Prior Year
General Operating & Capital Funds Reserve, Trust Bond
Government Enterprise & Agency Redemption
Funds Funds Funds
PDFConvert. 2509.1. 2012 _Year- End_Report_short_ version. docx
7of13
FUND BALANCE ANALYSIS
The 2012 actual results of expenditures and revenues netted an overall increase in total City fund
balances of $3,523,000.
General Government added $731,367 to its ending fund balance, and ended 2012 with a balance of
$10,680,000 or about 17.6% of the 2012 expenditure budget. This slightly exceeds the 60 day or 16.7%
target. Note: the encumbrance ordinance includes about $780,000 of General Government budget to
carry forward into 2013, which roughly matches the growth in fund balance.
Operating and Enterprise funds added $2,815,000 to ending fund balances. About $1.1 million was in
Wastewater Operating fund, because the beginning balance was well below the recommended
minimum level. Even after this large increase, this funds ending balance of $1.5 million is still below
the minimum 60 day, but is on target to meet that goal in 2013. Water Operating fund added about
$900,000 to its balance, ending 2012 with $2.9 million, exceeding the recommended minimum.
Stormwater Operating fund netted an additional $313,000, resulting in a balance of $1.37 million, also
above minimum levels. Both Water and Stormwater have major capital projects identified in the near
future, and excess operating reserves may be tapped to accomplish them. All funds in this category
ended the year as expected.
Capital Funds used a net of $521,000 of beginning reserves, with Wastewater using about $900,000 of
its capital reserves, as they are in the middle of a series of major capital improvement projects. All the
other funds netted an increase.
As discussed earlier, the Employee Benefit and Risk Management funds grew their balances to stay in
compliance with minimum guidelines.
One of the revenue bonds was refunded in 2013, netting an annual savings of about $185,000 going
forward. Part of the analysis of this transaction was to look at bond reserve fund balances in
comparison with current bond covenants. Because a debt issuance was fully paid in 2011, there was an
excess balance in the bond reserves of about $620,000, which was used to defease the debt. At the end
of 2012 the Bond Redemption funds are in compliance with required bond covenants.
PDFConvert. 2509.1. 2012 _Year- End_Report_short_ version. docx
8of13
EXHIBITS
GENERAL GOVERNMENT EXPENDITURES
Police
Fire
Transfers To Other Funds
Information Systems
Financial Services
Utility Services
Municipal Court
Code Administration
Police Pension
Legal
Engineering
Planning
Purchasing
Records
Indigent Defense
Human Resources
City Manager
City Hall Maintenance
Intergovernmental
City Council
State Examiner
Economic Development
Urban Area Hearings Exam.
Total General Fund
Parks & Recreation Fund
Street & Traffic Ops.
Total General Government
2012
Amended
2012
Budget
Expenditures
$24,325,966
$24,470,231
9,380,495
9,419,820
3,231,275
3,485,667
2,447,396
2,216,953
1,423,068
1,437,305
1,342,110
1,281,779
1,256,587
1,173,261
1,208,765
1,164,991
1,186,350
1,264,681
1,127,361
1,087,024
702,274
659,375
579,331
550,322
527,535
503,721
513,172
520,503
481,000
487,601
449,628
437,905
367,925
357,542
357,016
320,121
240,299
241,669
235,214
236,321
106,000
105,946
42,770
42,485
31 nnn
22 475
01,002,00/ 01,401,M16
4,048,697 4,046,898
5.199.157 5237.585
�1�V,01 V,071 ZPOU, / /L,101
PDFConvert. 2509.1. 2012 _Year- End_Report_short_ version. docx
9of13
Budget
VarianrP
(�,144,2bb)
(39,325)
(254,392)
230,443
(14,237)
60,331
83,326
43,774
(78,331)
40,337
42,899
29,009
23,814
(7,331)
(6,601)
11,723
10,383
36,895
(1,370)
(1,107)
54
285
8.525
/4,00y
1,799
(38,428)
$38,210
Percent
Spent
100.6%
100.4%
107.9%
90.6%
101.0%
95.5%
93.4%
96.4%
106.6%
96.4%
93.9%
95.0%
95.5%
101.4%
101.4%
97.4%
97.2%
89.7%
100.6%
100.5%
99.9%
99.3%
72.5%
99.9%
100.0%
100.7%
99.9%
Exhibit I
Exhibit II
OTHER OPERATING /ENTERPRISE FUNDS
Fund
Actual
Beg Bal
1/1/2012
- --
Amended
Budget
Revenue - --
Actual
Revenue
%
Recd
- -- Appropriations
Amended Actual
Budget Exp
--
%
Exp'd
Ending
Balance
12/31/2012
Economic Development
$224,342
$272,000
$285,650
105.0%
$351,636
$256,503
72.9%
$253,489
Neighborhood Development
269,747
3,559,555
2,182,119
61.3%
3,590,419
2,258,745
62.9%
193,121
Community Relations
848,564
494,950
535,014
108.1%
594,554
480,705
80.9%
902,873
Cemetery
44,671
243,550
255,000
104.7%
265,699
264,453
99.5%
35,218
Emergency Services
78,012
1,196,026
1,204,497
100.7%
1,222,030
1,175,527
96.2%
106,982
Public Safety Communication
595,530
3,402,343
3,211,712
94.4%
3,558,224
3,271,463
91.9%
535,779
Police Grants
269,417
1,226,030
1,248,369
101.8%
1,174,399
1,086,380
92.5%
431,406
P.B.I.A. (Parking & Bus Impr)
19,134
251,340
218,638
87.0%
235,962
154,116
65.3%
83,656
Trolley
16,360
65,229
4,843
7.4%
75,021
1,217
1.6%
19,986
Front Street Bus Impr Area
6,922
3,535
3,361
95.1%
6,298
1,533
24.3%
8,750
Conv Center (Tourist Promo)
360,839
1,443,450
1,510,143
104.6%
1,447,373
1,426,855
98.6%
444,127
PFD- Convention Center
214,099
645,750
697,171
108.0%
719,000
717,685
99.8%
193,585
Tourism Promotion Area
68,723
636,000
632,725
99.5%
636,000
632,725
99.5%
68,723
Capitol Theatre
97,690
324,177
357,471
110.3%
346,200
346,200
100.0%
108,961
PFD- Capitol Theatre
43,113
500,500
527,210
105.3%
517,000
516,985
100.0%
53,338
Recovery Grants Program
0
73,905
37,348
50.5%
73,905
37,348
50.5%
0
Stormwater Operating Fund
1,052,283
2,035,000
2,252,809
110.7%
2,243,246
1,939,945
86.5%
1,365,147
Transit
1,699,057
7,302,972
7,609,057
104.2%
7,852,953
7,900,929
100.6%
1,407,185
Refuse
475,146
5,280,524
5,493,751
104.0%
5,440,763
5,435,765
99.9%
533,132
Wastewater Operating
374,849
19,015,988
20,408,644
107.3%
19,437,140
19,288,288
99.2%
1,495,205
Water Operating
2,015,479
8,138,769
9,099,438
111.8%
8,226,296
8,204,797
99.7%
2,910,120
Irrigation
357,765
1,618,700
1,690,832
104.5%
1,444,937
1,386,482
96.0%
662,115
Equipment Rental
4,619,613
5,682,333
5,847,104
102.9%
5,878,730
5,864,466
99.8%
4,602,251
Environmental
431,611
150,000
153,341
102.2%
277,339
146,154
52.7%
438,798
Public Works Admin.
407,489
1,185,331
1,184,331
99.9%
1,185,478
1,117,602
94.3%
474,218
Total Other Operating Funds
$14,590,455
$64,747,957
$66,650,578
102.9%
$66,800,602
$63,912,868
95.7%
$17,328,165
PDFConvert. 2509.1. 2012 _Year- End_Report_short_ version. docx
10 of 13
Fund
Arterial Street
Central Bus District Capital
Capitol Theatre Construction
Yakima Redevelopment Area
Parks and Recreation Capital
Fire Capital
Law and Justice Capital
Public Works Trust Constr
REET 2 Capital
Transit Capital Reserve
Stormwater Capital Fund
Convention Center Cap Impr
Reserve for Capital Impr
Wastewater Facilities Cap Res
Sewer Construction
Domestic Water Improvement
Wastewater Facility Project
Irrigation System Impr
Total Capital Impr Funds
CAPITAL IMPROVEMENT FUNDS
Actual
Beg Bal
1/1/2012
$590,660
359,114
1,820
754,876
77,274
409,661
254,340
753,127
372,975
1,102,129
1,101,747
419,440
3,308,925
738,547
5,387,653
3,374,809
3,466,727
(408,465)
Amended
Budget
$4,437,351
39,200
0
1,750,000
710,000
126,072
737,125
548,906
452,000
595,000
244,794
226,500
6,067,166
150,500
2,850,000
4,600,000
6,121,000
2,708,500
Exhibit III
Revenue
Actual
Revenue
%
Rec'd
Appropriations
Amended Actual
Budget Exp
%
Exp'd
Ending
Balance
12/31/2012
$2,273,198
51.2%
$4,554,478
$2,368,655
52.0%
$495,203
48,521
123.8%
132,277
72,210
54.6%
335,425
2,000
n/a
3,201
3,201
100.0%
619
1,215,943
69.5%
2,011,006
1,299,536
64.6%
671,283
908,331
127.9%
834,749
819,062
98.1%
166,543
332,249
263.5%
347,722
271,094
78.0%
470,816
977,810
132.7%
1,056,115
953,846
90.3%
278,304
573,801
104.5%
718,382
631,315
87.9%
695,613
571,801
423,954
268,577
330,153
1,556,729
151,268
3,622,514
862,860
3,420,188
2,224,344
$22,065,359 $32,364,114 $19,764,241
PDFConvert. 2509.1. 2012 _Year- End_Report_short_ version. docx
11 of 13
126.5% 506,822 506,822
71.3% 685,000 294,088
109.7% 633,000 378,233
145.8%
216,934
25.7%
9,432,249
100.5%
50,000
127.1%
6,418,253
18.8%
4,865,000
55.9%
15,855,000
82.1%
4,115,554
61.1%
$52,435,742
211,826
2,197,796
14,280
1,506,642
426,833
6,573,146
1,757,032
$20,285,617
100.0%
437,954
42.9%
1,231,995
59.8%
992,091
97.6%
537,767
23.3%
2,667,858
28.6%
875,535
23.5%
7,503,525
8.8%
3,810,836
41.5%
313,769
42.7%
58,847
38.7%
$21,543,983
Fund
Employee Benefit Reserves
Unemployment Comp Res
Employees Health Ben Res
Worker's Compensation Res
W ellness/EAP
Firemens' Relief and Pension
Total Employee Ben Reserve
Operating Reserves
Contingency
Capitol Theatre Reserve
Risk Management Reserve
Total Operating Reserve
Trust and Agency Funds
Cemetery Trust
Agency Fund- YAKCORPS
Total Other Funds
RESERVE AND OTHER FUNDS
Actual - -- Revenue - -- -- Appropriations
Beg Bal Amended Actual % Amended Actual
1/1/2012 Budget Revenue Recd Budget Exp
$327,790 $173,000
1,908,168 11,243,185
1,054,247 1,114,600
122,646 60,000
793,181 1,387,500
$4,206,032 $13,978,285
$0 $50,000
313,849 500
848,891 9,961,000
$1,162,740 $10,011,500
$604,420 $16,500
42,113 526,756
$646,533 $543,256
$181,275
11,445,576
1,031,754
60,000
1,391,576
$14,110,181
$0
10,000
3,154,410
$3,164,410
$28,304
537,760
$566,064
PDFConvert. 2509.1. 2012 _Year- End_Report_short_ version. docx
12 of 13
104.8%
101.8%
92.6%
100.0%
100.3%
100.9%
0.0%
2000.0%
31.7%
31.6%
171.5%
102.1%
104.2%
$318,064
11,469,378
1,363,785
92,000
1,344,057
$14,587,284
$200,000
71,927
9,914,259
$10,186,186
$5,500
497,725
$503,225
$150,116
10,882,062
993,530
56,208
1,292,617
$13,374,533
$0
71,927
2,973,111
$3,045,038
$20,000
187,672
$207,672
Exhibit IV
-- Ending
% Balance
Exp'd 12/31/2012
47.2%
94.9%
72.9%
61.1%
96.2%
91.7%
0.0%
100.0%
30.0%
29.9%
363.6%
37.7%
41.3%
$358,949
2,471,682
1,092,471
126,438
892,140
$4,941,680
$0
251,922
1,030,190
$1,282,112
$612,724
392,201
$1,004,925
Fund
GO Bond Redemption
LID Guaranty
1994 GO LTD Police & Streets
1995 GO Street, Parks & Fire
GO Line of Credit
1996 GO LTD- Conv Center
2002 GO Convention Center
2005 GO Parks and Rec Bond
LID Debt Service Control
Total G. 0. Bond Redemption
Exhibit V
BOND REDEMPTIONS FUNDS
Actual
Beg Bal
1/1/2012
Amended
Budget
Revenue
Actual
Revenue
%
Rec'd
Appropriations
Amended Actual
Budget Exp
%
Exp'd
Ending
Balance
12/31/2012
$80,089
$50
$75
150.0%
$20,000
$20,000
100.0%
$60,164
107,541
512,000
504,569
98.5%
515,175
515,175
100.0%
96,935
190,513
293,000
292,707
99.9%
293,875
293,875
100.0%
189,345
0
114,000
0
0.0%
114,000
0
0.0%
0
66,435
428,750
429,100
100.1%
430,315
430,315
100.0%
65,220
170,563
1,019,594
1,016,196
99.7%
1,018,253
1,018,253
100.0%
168,506
5,467
986,989
986,989
100.0%
977,718
977,717
100.0%
14,739
47,350
274,000
215,161
78.5%
285,000
211,908
74.4%
50,603
$667,958
$3,628,383
$3,444,797
94.9%
$3,654,336
$3,467,243
94.9%
$645,512
Water /Sewer Revenue Bond Redemption
1997 Water Rev Bond Res
$270,807
1996 Revenue Bond Reserve
146,763
Water /Sewer Revenue Bonds
114,528
1997 Water Revenue Bonds
4,866
2008 Water /Sewer Rev Bond
1
2003 Wastewater Bond Red
4
2003 Irrigation Bond Red
35,436
Water /Sewer Rev Bond Res
971,200
2003 Sewer Rev Bond Res
828,650
Total W/S Rev Bond Red
$2,372,255
$400
$600
150.0%
$0
$0
n/a
$271,407
700
1,000
142.9%
0
0
n/a
147,763
0
0
n/a
0
0
n/a
114,528
234,725
234,750
100.0%
234,700
234,700
100.0%
4,916
413,413
413,413
100.0%
413,413
413,413
100.0%
1
1,347,457
1,893,507
140.5%
2,122,457
1,892,546
89.2%
965
640,554
320,554
50.0%
640,554
320,554
50.0%
35,436
1,000
1,500
150.0%
0
0
n/a
972,700
0
0
n/a
619,779
619,778
100.0%
208,872
$2,638,249
$2,865,324
108.6%
$4,030,903
$3,480,991
86.4%
$1,756,588
PDFConvert. 2509.1. 2012 _Year- End_Report_short_ version. docx
13 of 13