The URL can be used to link to this page

Home My WebLink About08/20/2013 05B 2013 2nd Quarter Financial Trend Monitoring Report7 ti J BUSINESS OF THE CITY COUNCIL YAKIMA, WASHINGTON AGENDA STATEMENT Item No. S For Meeting of: 8/20/2013 ITEM TITLE: 2nd Quarter Financial Trend Monitoring report SUBMITTED BY: Cindy Epperson, Director of Finance and Budget SUMMARY EXPLANATION: The Financial Trend Monitoring System (FTMS) report format was presented for the first time for the 1 st quarter of 2013. It is designed to provide a "performance at a glance" of budgetary and revenue trends, and reviews key financial and economic indicators as an "early warning system" regarding the financial and economic health of the city, and assigns "positive ", "normal', "warning ", and "negative" labels to revenues and expenditures. At the end of the second quarter, we are seeing typical variances tied to timing —such as annual dues /assessments. Most categories received a "normal' ranking, as actual results are within 5% of expected levels at this point in time. There were no categories receiving a "warning" or "negative" designation. Overall, year to date results through the second quarter of 2013 are as anticipated. Resolution: Other (Specify): Report Contract: Start Date: Item Budgeted: NA Funding Source /Fiscal Impact: Strategic Priority: Insurance Required? No Mail to: Phone: APPROVED FOR SUBMITTAL: Ordinance: Contract Term: End Date: Amount: Public Trust and Accountability City Manager 4:=IjftT &O.J, RECOMMENDATION: Accept Report ATTACHMENTS: Name- Description- L-1 FIN Report grid Qrtr.docx 2nd qtr Financial Monitoring Report MEMORANDUM August 20, 2013 TO: The Honorable Mayor and Members of the City Council FROM: Tony O'Rourke, City Manager Cindy Epperson, Director of Finance & Budget SUBJECT: 2013 2nd Quarter Financial Monitoring Report We are submitting for your review the City of Yakima's 2013 2nd Quarter actual compared to budgeted Revenue and Expenditure Report for all city funds. Beginning fund 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. It should be noted that the budget information for the Yakima Air Terminal (YAT) is not yet incorporated into the operating and capital components of this report because of the 2 month timing difference for January and February. The operating fund results are summarized in the same format as the other funds, but are presented separately. YAT is continuing to rebuild its cash reserves after making the scheduled County SIED loan repayment in June. This report is summarized by type of fund, and reported by functional type, in the following order: ➢ Performance at a Glance - Financial Monitoring System ➢ City -Wide Overview ➢ General Fund Revenue Analysis ➢ General Fund Expenditure Analysis ➢ Other Funds Analysis ➢ Top 10 Capital Project ➢ Exhibits - Fund detail that supports the summaries: • Exhibit I - Other Operating /Enterprise Funds • Exhibit II - Capital Improvement Funds • Exhibit III - Reserve and Other Funds • Exhibit IV - Bond Redemption Funds PDFConvert. 2960.1.FIN_Report_2nd_Qrtr.docx 1 of 14 PERFORMANCE AT A GLANCE General Fund Revenues Expenditures Operating /Enterprise Funds �1> Capital Funds (1) Reserve, Trust & Agency Funds �1> Bond Redemption Funds (1) Legend: Revenues exceed budget >5 %, Expenditures below budget >5% Revenues exceed budget <5 %, Expenditures below budget <5% Revenues below budget between 3 -5% Revenues below budget >5% (1) These funds are graded on a net Revenue measurement. STATUS NORMAL NORMAL NORMAL NORMAL NORMAL NORMAL PAGE 3/4-5 3 /6-7 8/8-9 8/10/12 8/13 8/14 POSITIVE NORMAL WARNING NEGATIVE PDFConvert. 2960.1.FIN_Report_2nd_Qrtr.docx 2 of 14 CITY WIDE OVERVIEW REVENUE COMPARISON (Budget vs. Actual) EXPENDITURE COMPARISON (Budget vs. Actual) ___________- 2012 _ 2013 ________________________ 2013 - 2nd Qtr Percent Amended 2nd Qtr Percent Percent Actual Rec'd Budget Actual Rec'd General $26,808,025 57.0% $52,489,635 $27,459,044 52.3% Parks and Recreation 2,114,191 52.2% 4,083,765 2,011,371 49.3% Street & Traffic Operations 2,607,598 51.6% 5,411,260 2,805,273 51.8% General Government Subtotal 31,529,814 53.2% 61,984,660 32,275,688 52.1% Community Development 777,053 21.8% $2,538,741 790,438 31.1% Operating/Enterprise Funds 31,643,152 51.9% 63,275,950 30,831,890 48.7% Capital Funds 6,525,831 20.7% 47,108,241 12,418,028 26.4% G.O. Bond Redemption Funds 1,808,715 49.8% 3,812,383 1,603,094 42.0% Water /Sewer Redemption Funds 1,158,063 43.9% 2,129,686 1,063,781 50.0% Employee Benefit Reserves 6,610,033 47.3% 14,630,500 6,807,129 46.5% Operating Reserves 2,652,303 26.5% 3,586,500 2,836,426 79.1% Trust and Agency Funds 297,520 54.8% 528,200 529,150 100.2% Total $83,002,484 44.5% $199,594,861 $89,155,624 44.7% EXPENDITURE COMPARISON (Budget vs. Actual) PDFConvert. 2960.1.FIN_Report_2nd_Qrtr.docx 3 of 14 -------- ---- -- 2012 - 2013 - 2nd Qtr Percent Amended 2nd Qtr Percent Actual Spent Budget Actual Spent General $24,358,431 48.1% $53,419,358 $26,175,777 49.0% Parks and Recreation 1,902,372 47.6% 4,082,425 2,058,175 50.4% Street & Traffic Operations 2,730,221 54.9% 5,490,823 2,500,636 45.5% General Government Subtotal 28,991,024 48.6% 62,992,606 30,734,588 48.8% Community Development (HUD grants) 1,044,394 29.1% $2,564,724 860,599 33.6% Operating/EnterpriseFunds 30,847,550 49.1% 63,502,773 29,150,079 45.9% Capital Funds 8,402,255 16.5% 54,805,281 12,363,865 22.6% G.O. Bond Redemption Funds 1,170,641 32.2% 3,831,384 1,127,645 29.4% Utility Revenue Bond Redemption Funds 515,561 19.6% 2,127,561 396,280 18.6% Employee Benefit Reserves 6,779,882 47.3% 14,634,979 5,833,859 39.9% Operating Reserves 1,165,479 11.4% 3,918,264 1,381,757 35.3% Trust and Agency Funds 51,695 10.3% 517,200 55,192 10.7% Total $78,968,481 37.9% $208,894,772 $81,903,864 39.2% PDFConvert. 2960.1.FIN_Report_2nd_Qrtr.docx 3 of 14 GENERAL FUND REVENUE ANALYSIS GENERAL GOVERNMENT REVENUES 2013 -- - - - - -- Revenues through 6/30 -- - - - - -- Amended 2011 2012 2013 General Sales Tax $6,231,953 $6,380,538 $6,952,180 Crim. Justice Sales Tax 1,289,846 1,184,129 1,398,434 Property Tax 8,095,020 8,390,289 8,612,036 Franchise & Utility Taxes 5,873,525 7,103,518 7,151,868 Charges for Services 3,303,700 3,074,166 3,171,816 State Shared Revenue 1,362,354 1,607,595 1,203,760 Other Intergovernmental 628,876 549,045 753,784 Fines and Forfeitures 802,842 789,983 815,955 Other Taxes 917,687 922,722 977,332 Transfers from other Funds 500,215 732,149 579,783 Licenses and Permits 321,251 423,979 386,930 Other Revenue 327,879 371,701 271,575 Total Revenue 29,655,148 31,529,814 32,275,453 Beginning Fund Balance 5,954,903 9,948,220 10,908,094 Total Resources 35,610,051 41,478,034 43,183,547 2013 Amended Percent Budget Receipted $13,375,000 52.0% 2,747,000 50.9% 15,329,000 56.2% 14,530,000 49.2% 6,379,205 49.7% 2,611,000 1,386,605 1,555,000 1,396,500 1,370,000 731,700 573,650 61,984,660 10.908.094 72,892,754 46.1% 54.4% 52.5% 70.0% 42.3% 52.9% 47.3% 52.1% Status NORMAL NORMAL NORMAL NORMAL NORMAL NORMAL NORMAL NORMAL NORMAL NORMAL NORMAL NORMAL NORMAL 59.2% NORMAL Sales Tax - The second quarter continued the acceleration seen in the second half of 2012 and the first quarter of 2013. Through the second quarter of 2013, sales tax is 8.9% more than the prior year, although this percentage is not expected to hold as we get to the last half of the year because last year's numbers well exceeded budgeted amounts. We are finally on track to exceed 2008 levels in 2013. Since the 2013 budget is slightly below 2012 actual results, this revenue should exceed budget by year end; the recent appropriation ordinance before City Council estimated an additional $625,000 coming into General Fund, which has been designated primarily for eligible match for the Yakima Redevelopment Area (mill site) project. Property Tax - The first half of the Property Tax assessment is due to the Yakima County Treasurer by April 30, and the second half is due October 31. Therefore, the second quarter receipts are typically slightly more than 50% of the annual budget, because of accounts that are paid in full in April and payments in full when property sells. The budget is set based on assumptions of new construction and collection rates - the 2013 actual levy was very close to the levy assumptions made, so this major revenue should meet or slightly exceed budget, depending on collection rate. Other Taxes - This category consists primarily of Business Licenses and Gambling Taxes. Business licenses are due in January for the year, so that over 95% of this category has been collected by March 31. Gambling taxes are up year over year through the 2nd quarter, however, Council recently amended the ordinance to exclude taxes on certain non - profit corporations. These revenues are expected to approximate the budget by year end. The last three categories all contain timing exceptions, and are still expected to meet the budget. Overall, general government revenues are up by about $745,000 or 2.3% over 2012, and we anticipate year end to exceed the budget within the 5% range which maintains the "normal" ranking. PDFConvert. 2960.1.FIN_Report_2nd_Qrtr.docx 4 of 14 GENERAL FUND REVENUES - By Month 10,000,000 — 8,000,000 ■ 2011 6,000,000 4,000,000 ■ 2012 2,000,000 0 ■ 2013 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 60,000,000 40,000,000 20,000,000 0 GENERAL FUND REVENUES - Cumulative By Month 2011 2012 2013 January 4,204,721 3,668,912 4,451,264 February 3,875,777 4,206,186 41267,636 March 4,078,448 4,861,758 4,896,583 April 9,178,647 9,388,842 9,758,283 May 4,565,077 4,833,268 4,733,408 June 3,929,664 4,146,240 4,168,515 July 3,536,362 4,636,431 August 3,405,624 3,574,114 September 4,354,881 4,250,150 October 8,531,924 9,673,506 November 3,925,532 4,263,220 December 4,035,837 4,016,944 57,622,494 61,519,571 32,275,689 10,000,000 — 8,000,000 ■ 2011 6,000,000 4,000,000 ■ 2012 2,000,000 0 ■ 2013 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 60,000,000 40,000,000 20,000,000 0 GENERAL FUND REVENUES - Cumulative By Month E M 0 0 11*1 t] I Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ■ 2011 ■ 2012 ■ 2013 PDFConvert. 2960.1.FIN_Report_2nd_Qrtr.docx 5 of 14 2011 2012 2013 January 4,204,721 3,668,912 4,451,264 February 8,080,498 7,875,098 81718,900 March 12,158,946 12,736,856 13,615,483 April 21,337,593 22,125,698 23,373,766 May 25,902,670 26,958,966 28,107,174 June 29,832,334 31,105,206 32,275,689 July 33,368,696 35,741,637 August 36,774,320 39,315,751 September 41,129,201 43,565,901 October 49,661,125 53,239,407 November 53,586,657 57,502,627 December 57,622,494 61,519,571 E M 0 0 11*1 t] I Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ■ 2011 ■ 2012 ■ 2013 PDFConvert. 2960.1.FIN_Report_2nd_Qrtr.docx 5 of 14 GENERAL FUND EXPENDITURE ANALYSIS GENERAL GOVERNMENT EXPENDITURES 2013 --- - --- Expenditures through 6/30 -- - - - - -- Amended Percent 2011 2012 2013 Budget Spent Status Police $10,843,662 $11,505,648 $12,293,943 $25,819,899 47.6% NORMAL Fire 4,272,483 4,373,731 4,816,992 9,909,477 48.6% NORMAL Transfers To Other Funds 1,057,098 1,281,328 1,183,747 2,502,275 47.3% NORMAL Information Systems 1,178,747 1,064,820 1,158,164 2,435,038 47.6% NORMAL Financial Services 660,251 705,809 742,653 1,478,418 50.2% NORMAL Municipal Court 564,882 570,184 647,680 1,384,004 46.8% NORMAL Code Administration 612,705 584,700 614,899 1,389,047 44.3% NORMAL Utility Services 628,927 683,834 673,041 1,324,950 50.8% NORMAL Police Pension 752,061 643,700 698,456 1,297,225 53.8% NORMAL Legal 501,141 523,119 589,371 1,287,573 45.8% NORMAL Indigent Defense 234,872 241,363 244,522 833,500 29.3% SITI Engineering 374,125 332,958 362,383 686,172 52.8% NORMAL Purchasing 215,707 243,995 266,606 541,244 49.3% NORMAL Records - City Clerk 213,004 380,771 249,666 461,070 54.1% NORMAL Planning 346,185 290,114 284,919 460,502 61.9% NORMAL Human Resources 193,238 235,639 249,622 459,969 54.3% NORMAL Economic Development 0 0 297,992 457,217 65.2% NORMAL City Hall Maintenance 211,883 201,109 225,552 372,923 60.5% NORMAL City Manager 245,280 187,936 210,841 366,555 57.5% NORMAL City Council 124,516 134,147 161,524 284,751 56.7% NORMAL Intergovernmental 172,135 155,213 178,593 261,549 68.3% NORMAL State Examiner 24,924 2,884 6,019 110,000 5.5% NORMAL Urban Area Hearings Exam. 8,345 15,429 18,592 26,000 71.5% NORMAL Position Vacancy Savings 0 (730,000) 0.0% Total General Fund 23,436,171 24,358,431 26,175,777 53,419,358 49.0% NORMAL Parks & Recreation Fund 2,045,222 1,902,372 2,058,175 4,082,425 50.4% NORMAL Street &Traffic Ops. 2,548,556 2,730,221 2,500,636 5,490,823 45.5% NORMAL Total General Government $28,029,949 $28,991,024 $30,734,588 $62,992,606 48.8% NORMAL Total General Government Fund Expenditures -1.2% Below 50% 1 NORMAL PDFConvert. 2960.1.FIN_Report_2nd_Qrtr.docx 6 of 14 SIGNIFICANT EXPENDITURE VARIANCES Positive Indigent Defense - The contract increase to comply with a new mandate was budgeted to begin in mid -year. The implementation date of the new rule has been moved back to 2015 — savings will extend through the end of the year. Normal- Over /under 50% in first quarter, yet comparable to prior years - payment timing variance • Utility Services - Annual maintenance of $115,000 for the utility billing system is paid in the first quarter. • Police Pension - Annual medicare premiums of $44,000 reimbursed to pensioners in the first quarter. • Records - Prior year election costs of $86,700 paid in the first quarter. • City Hall Maintenance - Annual transfer to Risk Management Fund to pay for property insurance is made in the first quarter - $107,000. • City Council - Annual Association of Washington Cities (AWC) dues of $62,000 paid in the first quarter. • Intergovernmental - Annual dues for Yakima County Emergency Management of $67,000 paid in the first quarter. • State Examiner - The annual audit does not get under way until the 2nd quarter of the year. Position Vacancy Savings - Shown for fund total purposes only - no "actual" will be charged here. Since General Government is about 68% staffing, events affecting total payroll have a significant impact on budgets. Position vacancies can start being an "overage" because of the cashout of earned accrued leave balances, but then can produce savings when the position is vacant for any length of time. Most other variances are the result of position vacancies. It should be noted that the recent collective bargaining settlements have not been budgeted, and the results are not yet reflected in these numbers. As we review the 2013 budget results in conjunction with 2014 budget development, an additional appropriation may be brought to Council if needed. PDFConvert. 2960.1.FIN_Report_2nd_Qrtr.docx 7 of 14 OTHER FUNDS ANALYSIS Operating/Enterprise Funds Capital Funds Reserve, Trust & Agency Funds Bond Redemption Funds Total Revenue Beginning Fund Balance Total Resources Operating /Enterprise Funds Capital Funds Reserve, Trust & Agency Funds Bond Redemption Funds Total Expenditures OTHER FUNDS REVENUES OTHER FUNDS EXPENDITURES --- - --- Expenditure through 6/30 -- - - - - -- 2011 2012 2013 $30,659,027 $31,891,944 - ---- -- Revenues through 6/30 -- ---- -- Amended Percent 8,241,589 2011 2012 2013 Budget Spent Status $29,204,480 $32,420,205 $31,622,328 $65,814,691 48.0% NORMAL 11,612,205 6,525,831 12,418,028 47,108,241 26.4% NORMAL 9,054,433 9,559,856 10,172,705 18,745,200 54.3% NORMAL 3,196,188 2,966,778 2,666,875 5,942,069 44.9% NORMAL 53,067,306 51,472,670 56,879,936 137,610,201 41.3% NORMAL 47,566,161 44,858,285 47,394,784 47,394,784 100,633,467 96,330,955 104,274,720 185,004,985 56.4% NORMAL OTHER FUNDS EXPENDITURES --- - --- Expenditure through 6/30 -- - - - - -- 2011 2012 2013 $30,659,027 $31,891,944 $30,010,678 9,623,309 8,402,255 12,363,865 8,241,589 7,997,056 7,270,808 1,604,505 1,686,202 1,523,925 50,128,430 49,977,457 51,169,276 2013 Amended Percent Budget Spent Status $66,067,497 45.4% NORMAL 54,805,281 22.6% NORMAL 19,070,443 38.1% NORMAL 5,958,945 25.6% NORMAL 145,902,166 35.1% NORMAL Second quarter results are performing as expected. Most variances at this time of the year are related to timing, which is why they are getting a Normal status. Most Operating/Enterprise Funds are close to the 50% mark for both revenue and expenditures at June 30. Significant variances are related to timing (i.e. Irrigation operating fund pays all of its ditch charges to outside irrigation companies in the first half of the year, so it is showing 60.8% spent —this is not unusual, and the budget is not in jeopardy to be overspent by year end.) Fund balances are within expected levels at this time of the year for all of these funds. Capital Fund budgets include the full project, and are not expected to be 100% completed in the current year. The $5 million bond for major Street grind and overlay projects was received in June, but the projects were just getting started, so the revenue and ending balance reflects this. The Martin Luther King Blvd railroad underpass project is picking up, and has been using fund balance until the grant reimbursement arrives. Wastewater has several major projects in process, and has also used capital reserves in accordance with the budgeted plan. A listing of the top ten budgeted projects and their first quarter expenses follow. Reserve Funds are ahead in revenue during the first part of the year because the full year of "premiums" to Risk Management and YAKCORPS allocations are paid in the 1St half of the year. Expenses are down primarily because of lower claim costs in the Medical Insurance Fund -last year included a major claim in this time frame. The employee benefit related funds are all doing well in PDFConvert. 2960.1.FIN_Report_2nd_Ortr.docx 8 of 14 2013, and at this point in time, we anticipate no rate increases in 2014 for unemployment, workers' compensation, and the medical funds. Risk management continues to have challenges, this fund will require additional "premiums' from the operating funds in 2014. Revenues in Bond Redemption Funds are deposited /transferred ratably throughout the year, but mainly interest payments are made in the first half of the year - the bulk of debt service principal payments are made in the last quarter. YAKIMA AIR TERMINAL ANALYSIS Actual Revenue Appropriations Ending Beg Bal Amended Actual % Amended Actual % Balance Fund 3/1/2013 Budget Revenue Rec'd Budget Exp Exp'd 6/30/2013 Airport Operating Fund(') 226,962 1,074,027 343,960 32.0% 1,071,192 533,320 49.8% 37,602 The YAT summary is included as a separate analysis - not included in City totals at this time. The budget is for the full year, but the revenues and expenditures are only for the 4 months the City has been sole owner, starting March 1, 2013. The airport is slowly adding to its cash reserves, which is demonstrated by the fact that it started with $226,962 on March 1, but was able to repay $256,000 SIED loan in June, and have $37,602 at the end of the 2nd quarter. PDFConvert. 2960.1.FIN_Report_2nd_Qrtr.docx 9 of 14 TOP 10 BUDGETED CAPITAL PROJECTS Dept. Legend: ST - Street Improvement WW - Wastewater Capital W - Water Capital PDFConvert. 2960.1.FIN_Report_2nd_Qrtr.docx 10 of 14 Total 2013 Actual 2013 Expected Project Number /Description Dept Budget Expended Funding Source Completion 1818 Railroad Grade Separation ST $12,409,500 $1,512,034 State & Federal Grants FY 2014 Martin Luther King Blvd Public Works Trust Fund Loan 2341 Regional Wastewater Treatment WW 6,510,000 4,290,570 Capital Reserves FY 2013/14 Plant UASB and Electrical Impr Revenue Bond (2014) 2353 City Streets Project Impr ST 5,000,000 54,468 General Obligation Bond FY 2013 (Proceeds received in June, 2013) 2308 Biosolids Improvement WW 5,000,000 83,918 State Revolving Fund Loan FY 2014/15 2261 Automated Meter Reading W/WW 4,165,000 268,302 Public Works Trust Fund Loan FY 2013 2327 Ind Waste Line Boise Site WW 2,200,000 1,014,234 Public Works Trust Fund Loan FY 2013/14 2264 Speedway/Race Street (2nd Ph) WW 1,700,000 353,261 Wastewater Capital Reserves FY 2013/14 2259 Water Treatment Plant Lagoons W 1,558,021 146,690 Drinking Water State FY 2014 Revolving Fund Loan 2267 WW NPDES/TMDL Dschrg/Load WW 1,300,000 239,701 Wastewater Capital Reserves FY 2014/15 2314 River Road Improvement ST 1,204,421 69,678 State & Federal Grants FY 2013 Dept. Legend: ST - Street Improvement WW - Wastewater Capital W - Water Capital PDFConvert. 2960.1.FIN_Report_2nd_Qrtr.docx 10 of 14 EXHIBITS OTHER OPERATING /ENTERPRISE FUNDS Exhibit I Fund Actual Beg Bal 1/1/2013 Amended Budget Revenue Actual Revenue % Rec'd Appropriations Amended Actual Budget Exp % Exp'd Ending Balance 6/30/2013 Economic Development $253,488 $229,000 $124,218 54.2% $277,332 $132,145 47.6% $245,561 Neighborhood Development 193,121 2,538,741 790,438 31.1% 2,564,724 860,599 33.6% 122,960 Community Relations 902,872 521,750 276,943 53.1% 922,855 240,302 26.0% 939,513 Cemetery 35,219 252,550 109,566 43.4% 267,327 134,153 50.2% 10,632 Emergency Services 106,982 1,195,026 683,400 57.2% 1,189,923 494,367 41.5% 296,015 Public Safety Communication 535,778 3,268,328 1,773,743 54.3% 3,520,154 1,546,214 43.9% 763,307 Police Grants 431,407 707,911 365,271 51.6% 708,078 424,681 60.0% 371,997 P.B.I.A. (Parking & Bus Impr) 83,656 205,340 100,564 49.0% 287,522 80,269 27.9% 103,951 Trolley 19,986 64,926 1,275 2.0% 77,246 15,202 19.7% 6,059 Front Street Bus Impr Area 8,750 3,535 1,300 36.8% 5,000 2,866 57.3% 7,184 Conv Center (Tourist Promo) 314,510 1,468,250 637,137 43.4% 1,460,299 722,797 49.5% 228,850 PFD- Convention Center 193,585 700,750 363,558 51.9% 684,000 340,992 49.9% 216,151 Tourism Promotion Area 414 667,000 258,929 38.8% 667,000 258,929 38.8% 414 Capitol Theatre 108,960 359,177 202,762 56.5% 348,300 205,389 59.0% 106,333 PFD - Capitol Theatre 53,337 528,500 275,188 52.1% 517,000 259,642 50.2% 68,883 Stormwater Operating Fund 1,365,147 2,035,000 1,603,116 78.8% 2,087,622 951,144 45.6% 2,017,119 Transit 603,916 8,049,195 4,145,417 51.5% 8,042,761 3,836,557 47.7% 912,776 Refuse 533,131 5,473,500 2,581,007 47.2% 5,545,199 2,765,452 49.9% 348,686 Wastewater Operating 1,495,206 20,653,916 9,567,543 46.3% 19,525,178 8,732,161 44.7% 2,330,588 Water Operating 2,910,120 8,258,100 3,472,005 42.0% 8,546,883 3,975,960 46.5% 2,406,165 Irrigation 662,115 1,683,100 880,162 52.3% 1,509,163 917,222 60.8% 625,055 Equipment Rental 4,602,251 5,653,658 2,835,068 50.1% 5,978,336 2,563,802 42.9% 4,873,517 Environmental 438,798 150,000 0 0.0% 192,950 587 0.3% 438,211 Public Works Admin. 474,218 1,147,438 573,718 50.0% 1,142,645 549,246 48.1% 498,690 Total Other Operating Funds $16,326,967 $65,814,691 $31,622,328 48.0% $66,067,497 $30,010,678 45.4% $17,938,617 PDFConvert. 2960.1.FIN_Report_2nd_Ortr.docx 11 of 14 Exhibit II CAPITAL IMPROVEMENT FUNDS PDFConvert. 2960.1.FIN_Report_2nd_Qrtr.docx 12 of 14 Actual Revenue Appropriations Ending Beg Bal Amended Actual % Amended Actual % Balance Fund 1/1/2013 Budget Revenue Rec'd Budget Exp Exp'd 6/30/2013 Arterial Street $400,600 $8,870,322 $6,181,826 69.7% $8,935,977 $1,023,553 11.5% $5,558,873 Central Bus District Capital 335,424 0 39,261 n/a 229,500 32,429 14.1% 342,256 Capitol Theatre Construction 619 0 0 n/a 0 0 n/a 619 Yakima Redevelopment Area 671,283 2,850,000 0 0.0% 2,509,240 392,651 15.6% 278,632 Parks and Recreation Capital 156,544 75,000 82,996 n/a 100,000 99,910 99.9% 139,630 Fire Capital 470,817 800,750 206,377 25.8% 569,896 227,409 39.9% 449,785 Law and Justice Capital 272,377 546,613 413,496 75.6% 749,202 462,056 61.7% 223,817 Public Works Trust Constr 695,613 611,306 260,078 42.5% 958,782 528,815 55.2% 426,876 REET 2 Capital 437,954 527,000 260,078 49.4% 506,822 378,411 74.7% 319,621 Transit Capital Reserve 1,231,995 618,250 53,139 8.6% 545,500 37,167 6.8% 1,247,967 Stormwater Capital Fund 992,090 320,000 75,000 23.4% 435,000 83,408 19.2% 983,682 Convention Center Cap Impr 537,767 220,500 110,000 49.9% 295,000 44,627 15.1% 603,140 Reserve for Capital Impr 2,667,858 10,728,000 0 0.0% 12,537,058 1,559,665 12.4% 1,108,193 Wastewater Capital 8,692,828 15,132,000 4,118,418 27.2% 20,455,000 6,480,073 31.7% 6,331,173 Domestic Water Improvement 3,810,836 4,600,000 0 0.0% 4,945,000 470,336 9.5% 3,340,500 Irrigation System Impr 58,847 1,208,500 617,359 51.1% 1,033,304 543,355 52.6% 132,851 Total Capital Impr Funds $21,433,452 $47,108,241 $12,418,028 26.4% $54,805,281 $12,363,865 22.6% $21,487,615 PDFConvert. 2960.1.FIN_Report_2nd_Qrtr.docx 12 of 14 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 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 - Beg Bal Amended Actual 1/1/2013 Budget Revenue - -- Appropriations % Amended Actual Recd Budget Exp Exhibit III -- Ending % Balance Exp'd 6/30/2013 $358,948 $177,000 $93,229 52.7% $293,796 $57,342 19.5% $394,835 2,471,682 11,995,000 5,356,247 44.7% 11,628,854 4,636,521 39.9% 3,191,408 1,092,471 1,018,000 581,740 57.1% 1,244,636 469,753 37.7% 1,204,458 126,438 60,000 0 0.0% 120,200 36,970 30.8% 89,468 892,140 1,380,500 775,913 56.2% 1,347,493 633,273 47.0% 1,034,780 $4,941,679 $14,630,500 $6,807,129 46.5% $14,634,979 $5,833,859 39.9% $5,914,949 251,922 500 0 0.0% 71,927 0 0.0% 251,922 1,030,191 3,586,000 2,836,426 79.1% 3,846,337 1,381,757 35.9% 2,484,860 $1,282,113 $3,586,500 $2,836,426 79.1% $3,918,264 $1,381,757 35.3% $2,736,782 $612,724 $16,500 $5,342 32.4% $5,500 $0 0.0% $618,066 392,200 511,700 523,808 102.4% 511,700 55,192 10.8% 860,816 $1,004,924 $528,200 $529,150 100.2% $517,200 $55,192 10.7% $1,478,882 PDFConvert. 2960.1.FIN_Report_2nd_Qrtr.docx 13 of 14 Exhibit IV BOND REDEMPTIONS FUNDS PDFConvert. 2960.1.FIN_Report_2nd_Qrtr.docx 14 of 14 Actual Revenue Appropriations Ending Beg Bal Amended Actual % Amended Actual % Balance Fund 1/1/2013 Budget Revenue Rec'd Budget Exp Exp'd 6/30/2013 GO Bond Redemption LIDGuaranty $60,164 $50 $0 0.0% $0 $0 n/a $60,164 1994 GO LTD Police & Streets 96,934 512,000 158,451 30.9% 515,625 7,813 1.5% 247,572 1995 GO Street, Parks & Fire 189,345 293,000 160,905 54.9% 294,600 9,800 3.3% 340,450 1996 GO LTD- Conv Center 65,220 428,750 172,064 40.1% 428,315 49,158 11.5% 188,126 2002 GO Convention Center 168,506 1,017,594 505,061 49.6% 1,017,000 543,600 53.5% 129,967 2005 GO Parks and Rec Bond 14,739 1,286,989 493,495 38.3% 1,290,844 432,972 33.5% 75,262 LID Debt Service Control 54,154 274,000 113,118 41.3% 285,000 84,302 29.6% 82,970 Total G.O. Bond Redemption $649,062 $3,812,383 $1,603,094 42.0% $3,831,384 $1,127,645 29.4% $1,124,511 Water /Sewer Revenue Bond Redemption 1997 Water Rev Bond Res $271,407 $400 $0 0.0% $0 $0 n/a $271,407 1996 Revenue Bond Reserve 147,763 700 0 0.0% 0 0 n/a 147,763 Water /Sewer Revenue Bonds 114,528 0 0 n/a 0 0 n/a 114,528 1997 Water Revenue Bonds 4,916 232,725 116,350 50.0% 232,700 26,350 11.3% 94,916 2008 Water /Sewer Rev Bond 1 414,813 207,407 50.0% 414,813 94,906 22.9% 112,502 2003 Wastewater Bond Red 965 1,158,544 579,272 50.0% 1,158,544 176,772 15.3% 403,465 2003 Irrigation Bond Red 35,436 321,504 160,752 50.0% 321,504 98,252 30.6% 97,936 Water /Sewer Rev Bond Res 972,700 1,000 0 0.0% 0 0 n/a 972,700 2003 Sewer Rev Bond Res 208,871 0 0 n/a 0 0 n/a 208,871 Total W/S Rev Bond Red $1,756,587 $2,129,686 $1,063,781 50.0% $2,127,561 $396,280 18.6% $2,424,088 PDFConvert. 2960.1.FIN_Report_2nd_Qrtr.docx 14 of 14