HomeMy WebLinkAbout07/17/2018 06C 2018 First Quarter Financial ReportITEM TITLE:
SUBMITTED BY:
BUSINESS OF THE CITY COUNCIL
YAKIMA, WASHINGTON
AGENDASTATEMENT
1
Item No. 6.C.
For Meeting of: July 17, 2018
2018 First Quarter Financial Report
Tara Lewis, Financial Services Manager
SUMMARY EXPLANATION:
The First Quarter Financial Report for 2018 is attached and consists of the following:
1. Summary Narrative
2. Financial Reports
• Fund Balance Summary
• Revenue and Expenditure Comparison to Budget and Actual Year -to -Date
• General Government Revenue Historical Year -to -Date Detail
• General Government Expenditure Historical Year -to -Date Detail
• Other Funds - Revenue, Expenditure and Fund Balance Summary
ITEM BUDGETED:
NA
STRATEGIC PRIORITY: Public Trust and Accountability
APPROVED FOR
SUBMITTAL:
Acting City Manager
STAFF RECOMMENDATION:
Accept Report
BOARD/COMMITTEE RECOMMENDATION:
ATTACHMENTS:
Description
d 2018 1st Garter Financial Report
Upload Date
7/10/2018
Type
Coker Memo
2
MEMORANDUM
To: The Honorable Mayor and Members of the City Council
From: Tara Lewis, Financial Services Manager
Date: July 17, 2018
Subject: 2018 First Quarter Financial Report
Financial activity for the first quarter of 2018 is as expected. In General Government operational
funds, expenditures tend to approximate 25% of the budget while revenues tend to lag behind.
Property taxes account for almost a quarter of General Government revenue, but the majority of
collections occur in the second and fourth quarters of the year. This timing issue is evident when
one reviews first quarter results from the Parks and Recreation fund. Revenues are only at 15%
of budget because the majority of Parks revenue comes from Property taxes. (Parks expenditures
are also less than one quarter of their budget due to their emphasis on summer and fall
programming.)
Points of consideration include the looming trade tariff war. Although there is talk of the federal
government providing mitigation funding to affected farmers, the potential damage is difficult
to quantify. Local agriculture's viewpoint of the economy is uncertain which will undoubtedly
impact the City's sales tax revenues in the short term.
Another dampening influence on financial expectations is 2018's mild winter. Utility tax
revenues, although trending upward due to the lifting of the cap, have been stifled by a mild
winter. And now that spring and early summer have given us an extended cool period, second
quarter utility taxes are expected to be lackluster as well.
One bright star in our revenue anticipation is the recent Supreme Court decision to overturn the
1992 Quill v. North Dakota case. Quill required that a seller have a physical presence in the state
before sales tax could be collected. In the recent case of South Dakota v. Wayfair the Court is now
allowing states to pass laws requiring sellers without a physical presence in the state to collect
sales taxes from customers. Residents of the City of Yakima tend to buy goods online at a rate
below the national average. It is too soon to develop a reliable forecast of the impact of this
decision.
In 2016 a new Governmental Accounting Standards Board (GASB) pronouncement took effect
that impacted the way in which the City of Yakima reports its General Fund activities. The City
administers two post -employment pension and benefit plans for retired law enforcement
officers and firefighters. These plans have no current employees and generally pertain only to
retirees who were hired prior to March 1, 1970 and are not covered under state plans. The retired
3
officer's plan has always been part of the General Fund, and the funding source is the general
tax revenues of the City. Historically, the retired firefighter's plan was treated as a trust fund in
the City Budget and City Financial Reports due to the requirement that property taxes be
allocated sufficient to fund it. However, recent consideration that property taxes are allocable
based on the City's budget and the obligation is no different than the funding of debt payments
and other legal obligations, the plan is now considered by the GASB to be an obligation and
activity of General Fund in a manner similar to the officer's plan.
Subsequently, the Comprehensive Annual Financial Reports (CAFR) for both 2016 and 2017
have included the firefighter plan in the General Fund. Since the CAFR is the report that
external users (including bond rating agencies) employ to analyze the City's financial condition,
it is prudent to prepare internal financial reports on the same basis. This inclusion has a small,
but minimally beneficial impact on the General Fund Balance as a percentage of expenditures.
General Government will continue to be referred to in relation to budgetary reporting. General
Government includes the General Fund, the Parks and Recreation Fund, and the Streets and
Traffic Fund.
4
CITY-WIDE FUND BALANCE SUMMARY
CHANGE IN FUND BALANCE
General Fund
Parks and Recreation
Street & Traffic Operations
General Government Subtotal
Other Governmental Operating Funds
Government Capital Funds
Enterprise Operating Funds
Enterprise Capital Funds
Internal Service Funds
Employee Benefit Reserve
Risk Management Reserves
Debt Service & Agency Funds
Total
20%
15% —
10%
5%
0%
16.7%
2018
Beginning
Balance
As of March 31
2018 2018 Ending
Actual Rev. Actual Exp. Balance
$ 8,464,925 $ 15,471,422 $ 15,682,962 $ 8,253,385
35,384 823,536 995,841 (136,921)
849,894 632,266 1,295,333 186,827
9,350,203 16,927,224 17,974,136 8,303,291
4,271,223
8,192,825
8,718,071
36,467,706
3,761,058
2,791,913
1,125,894
4,497,420
2,925,493 2,709,074 4,487,642
1,738,834 571,065 9,360,594
12,301,299 12,748,887 8,270,483
1,709,702 1,660,562 36,516,846
1,058,019 677,725 4,141,352
3,394,028 3,364,339 2,821,602
2,121,783 1,990,365 1,257,312
2,341,141 405,564 6,432,997
$ 79,176,313 $ 44,517,523 $ 42,101,717 $ 81,592,119
GENERAL FUND BALANCE PERCENT OF EXPENDITURES
2013 - 2018
Policy Level
Fund Balance:
18.2
14.6%
1
2013 2014
$10,071,272 $8,848,302
11.0%
13.0%
2015 2016
$6,887,225 $8,266,909
Target = 16.7% (2 months of Operations)
12.8°
13.2"
1.
2017 2018 Annualized
$8,464,924 $8,253,385
Fund Balance Discussion
General Government Fund balances tend to be artificially depressed in the first quarter due to lagging
Property Tax revenues. Note that even though the General Fund Balance itself increased in 2017 over
2016, it's percentage of expenditures was slightly lower, due to expenditures rising at a higher rate than
revenues. In 2017 this phenomenon was due to the catch-up restoration of fund reserves in the Risk
Management and Health funds. However, inflationary pressures, particularly in wages continue to
challenge the City's efforts to increase its Fund Balance as a percentage of expenditures. More progress is
expected in the second quarter as revenues begin to catch up with the timing of expenditures.
Finance Year -End Report - 3
5
CITY WIDE REVENUES & EXPENDITURES BY FUND GROUPING
General
Parks and Recreation
Street & Traffic Operations
General Government Subtotal
Other Government Operating Funds
Government Capital Funds
Enterprise Operating Funds
Enterprise Capital Funds
Internal Service Funds
Employee Benefit Reserves
Risk Management Reserve
Debt Service & Agency Funds
Total
General
Parks and Recreation
Street & Traffic Operations
General Government Subtotal
REVENUE COMPARISON
(Budget vs. Actual)
2017
2018
Actual
as of 3/31 Rec'd
0/0
Annual
Amended
Budget
Actual
as of 3/31 Rec'd
0/0
$ 14,385,890
781,133
612,404
15,779,427
1,821,960 11.7%
438,132 2.0%
11,038,251 20.1%
1,422,165 7.6%
1,089,624 17.6%
3,128,827 20.7%
1,950,030 47.8%
2,643,495 34.9%
$ 39,311,911 17.4% $ 244,244,924
21.6%
14.1%
7.0%
19.5%
$ 69,124,056
5,469,405
5,418,459
$ 15,471,422
823,536
632,266
80,011,920 16,927,224
14,799,720 2,925,493
42,032,139 1,738,834
55,826,645 12,301,299
19,532,463 1,709,702
6,114,371 1,058,019
14,395,290 3,394,028
4,173,141 2,121,783
7,359,235 2,341,141
22.4%
15.1%
11.7%
21.2%
19.8%
4.1%
22.0%
8.8%
17.3%
23.6%
50.8%
31.8%
$ 44,517,523 18.2%
EXPENDITURE COMPARISON
(Budget vs. Actual)
Other Government Operating Funds
Government Capital Funds
Enterprise Operating Funds
Enterprise Capital Funds
Internal Service Funds
Employee Benefit Reserves
Risk Management Reserve
Debt Service & Agency Funds
Total
2017
2018
Actual
as of 3/31
$ 15,284,487
1,049,286
1,750,999
18,084,772
0/0
Exp'd
22.8
18.8
20.9
22.4
Annual
Amended
Budget
Actual
as of 3/31
2,594,017 16.8 %
889,471 3.2 %
11,869,089 21.0 %
2,379,260 7.4 %
(148,074) (2.3)%
3,794,956 23.6 %
2,002,557 51.2 %
396,388 5.2 %
$ 41,862,436 16.9 % $ 249,901,212
$ 68,469,838 $ 15,682,962
5,626,305 995,841
5,441,133 1,295,333
79,537,276 17,974,136
14,747,867 2,709,074
38,564,670 571,065
57,555,706 12,748,887
26,658,235 1,660,562
6,424,481 677,725
15,042,112 3,364,339
4,021,304 1,990,365
7,349,561 405,564
0/0
Exp'd
22.9%
17.7%
23.8%
22.6%
18.4%
1.5%
22.2%
6.2%
10.5%
22.4%
49.5%
5.5%
$ 42,101,717 16.8%
Finance Year -End Report - 4
6
GENERAL GOVERNMENT REVENUE DETAIL
GENERAL GOVERNMENT REVENUES
2018
Revenues as of 3/31 Amended Percent
General Fund 2016 2017 2018 Budget Rec'd
General Sales Tax $ 3,764,550 $ 4,051,702 $ 4,324,326 $ 17,644,612 24.5%
Criminal Justice Sales Tax 780,949 810,299 891,971 3,426,346 26.0%
Property Tax 994,494 988,484 1,124,576 12,965,390 8.7%
Utility & Franchise Taxes 4,199,374 4,435,820 4,531,031 17,914,429 25.3%
Charges for Services 2,043,481 2,059,818 2,231,375 9,301,368 24.0%
State Shared Revenue 423,390 525,386 592,383 2,319,165 25.5%
Other Intergovernmental 160,571 126,604 213,878 797,865 26.8%
Fines and Forfeitures 488,465 462,379 457,121 1,790,632 25.5%
Other Taxes & Fees 580,119 663,250 674,511 1,601,264 42.1%
Licenses and Permits 227,703 215,687 296,941 834,702 35.6%
Other Revenue 99,474 46,461 133,307 528,283 25.2%
Total General Fund $ 13,762,570 $ 14,385,890 $ 15,471,420 $ 69,124,056 22.4%
Parks & Recreation
Property Tax 193,853 194,382 227,453 2,822,565 8.1%
Charges for Services 182,048 210,417 220,395 855,550 25.8%
State Shared Revenue 5,100 5,775 5,958 23,830 25.0%
Other Intergovernmental 12,755 6,275 9,334 39,500 23.6%
Transfers from other Funds 362,500 326,548 332,093 1,513,060 21.9%
Other Revenue 25,407 37,735 28,303 214,900 13.2%
Total Parks & Recreation 781,663 781,132 823,536 5,469,405 15.1%
Streets
Property Tax 242,933 264,614 253,149 3,141,437 8.1%
Charges for Services 650 2,250 1,650 545,000 0.3%
State Shared Revenue 316,773 306,572 311,827 1,349,812 23.1%
Other Intergovernmental 13,956 29,308 61,945 184,210 33.6%
Other Taxes & Fees 150,000 -%
Other Revenue 16,560 9,661 3,695 48,000 7.7%
Total Streets 590,872 612,405 632,266 5,418,459 11.7%
Finance Year -End Report - 5
7
GENERAL GOVERNMENT EXPENDITURE DETAIL
GENERAL GOVERNMENT EXPENDITURES
2018
Expenditures as of 3/31 Amended Percent
2016 2017 2018 Budget Exp'd
Police $ 5,861,358 $ 6,268,270 $ 6,343,341 $ 29,388,534 21.6 %
Fire 2,874,826 3,054,086 3,283,718 14,080,858 23.3 %
Transfers To Other Funds 1,186,060 1,150,393 1,119,696 3,952,540 28.3 %
Information Technology 907,652 967,702 952,896 3,523,653 27.0 %
Code Administration 410,726 426,953 397,180 2,007,930 19.8 %
Utility Services 339,434 364,196 442,956 1,926,299 23.0 %
Legal 355,390 366,815 388,016 1,686,272 23.0 %
Financial Services 353,023 384,123 377,936 1,651,963 22.9 %
Municipal Court 329,101 336,169 363,584 1,585,265 22.9 %
Firemen's Relief/Pension 359,854 325,082 344,077 1,229,483 28.0 %
Indigent Defense 232,231 209,004 164,731 1,050,000 15.7 %
Police Pension 275,945 249,485 236,308 927,497 25.5 %
Engineering 169,761 165,483 170,136 763,825 22.3 %
Economic Development 102,159 95,358 169,247 730,903 23.2 %
Human Resources 155,116 147,867 105,595 675,267 15.6 %
Planning 136,909 130,305 155,313 629,748 24.7 %
Purchasing 148,234 122,795 144,361 624,773 23.1 %
City Clerk / Records 309,144 105,056 165,903 533,319 31.1 %
City Hall Facility 155,348 175,006 101,177 514,138 19.7 %
City Management 118,929 95,139 103,298 434,550 23.8 %
City Council 113,409 107,515 122,010 262,650 46.5 %
Intergovernmental 29,005 30,978 31,483 160,372 19.6 %
State Examiner 6,703 130,000 - %
Total General Fund 14,923,614 15,284,483 15,682,962 68,469,839 22.9 %
Parks & Recreation Fund 1,005,167 1,049,286 995,841 5,626,305 17.7 %
Street & Traffic Ops. 1,579,953 1,750,999 1,295,333 5,441,133 23.8 %
Total General Government $ 17,508,734 $ 18,084,768 $ 17,974,136 $ 79,537,277 22.6 %
Finance Year -End Report - 6
8
OTHER FUNDS DETAIL
Fund
OTHER GOVERNMENT OPERATING FUNDS
2018 As of March 31
Beginning 2018 2018 Ending
Balance Actual Rev. Actual Exp. Balance
Economic Development $ 46,065 $ 25,449 $ 20,474 $ 51,040
Neighborhood Development 683,209 444,039 153,700 973,548
Community Relations 708,399 164,438 146,093 726,744
Cemetery 61,431 52,693 63,057 51,067
Emergency Services 106,362 120,183 282,347 (55,802)
Public Safety Communication 164,849 863,876 888,556 140,169
Police Grants 873,065 354,183 71,878 1,155,370
PBIA (Park/Bus Impr Area) 99,366 46,196 1,782 143,780
Trolley 20,952 1,275 843 21,384
Front Street Bus Impr Area 155 900 600 455
Cony Center (Tourist Promo) 378,217 201,223 420,996 158,444
Capitol Theatre 28,018 107,111 198,209 (63,080)
PFD - Convention Center 815,624 245,054 182,376 878,302
Tourism Promotion Area 79,342 113,491 113,491 79,342
PFD - Capitol Theatre 206,167 185,381 164,673 226,875
Total Other Gov't Oper Funds $ 4,271,221 $ 2,925,492 $ 2,709,075 $ 4,487,638
Fund
GOVERNMENTAL CAPITAL FUNDS
2018 As of March 31
Beginning 2018 2018 Ending
Balance Actual Rev. Actual Exp. Balance
Arterial Street $ 1,523,066 $ 149,443 $ 76,680 $ 1,595,829
Central Bus District Capital 572,172 669,492 24,357 1,217,307
Capitol Theatre Construction 102,791 15,000 117,791
Yakima Redevelopment Area 1,694,125 50,143 37,321 1,706,947
Parks & Recreation Capital 411,326 50,000 58,283 403,043
Fire Capital (1,082,051) 2,309 (1,084,360)
Law and Justice Capital 477,133 102,316 90,504 488,945
Public Works Trust Construction 2,131,719 299,756 114,867 2,316,608
REET 2 Capital 596,018 257,532 853,550
Street Capital 256,191 31,402 287,593
Convention Center Cap Impr 933,114 113,750 104,002 942,862
Reserve for Capital Impr 577,221 62,742 514,479
Total Gov't Capital Funds $ 8,192,825 $ 1,738,834 $ 571,065 $ 9,360,594
Finance Year -End Report - 7
Fund
9
ENTERPRISE OPERATING FUNDS
2018
Beginning
Balance
As of March 31
2018
2018
Actual Rev. Actual Exp.
Ending
Balance
Airport Operating
Stormwater Operating
Transit Operating
Refuse
Wastewater Operating
Water Operating
Irrigation
Total Enterprise Oper Funds
Fund
$ (22,526) $
784,536
2,925,034
928,298
2,222,606
1,368,975
511,148
321,087
307,064
1,841,033
1,889,144
5,563,641
1,878,246
501,084
$ 336,074
697,028
2,010,755
1,599,747
5,406,480
2,007,662
691,141
$ (37,513)
394,572
2,755,312
1,217,695
2,379,767
1,239,559
321,091
$ 8,718,071 $ 12,301,299 $ 12,748,887 $ 8,270,483
ENTERPRISE CAPITAL FUNDS
Airport Capital
Stormwater Capital
Transit Capital
Wastewater Facilities Capital
Wastewater Const Capital
Wastewater Capital
Water Capital
Irrigation Capital
Total Enterprise Oper Funds
Fund
2018
As of March 31
Beginning 2018
Balance Actual Rev.
$ 973,423 $ 86,419
4,938,073 266,256
6,367,633 3,600
3,067,165 172,150
8,517,535 725,000
5,325,403
3,932,875 125,375
3,345,599 330,903
2018
Actual Exp.
Ending
Balance
$ 52,416
54,139
1,452,655
$ 1,007,426
5,150,190
6,371,233
3,239,315
7,789,880
12,005 5,313,398
4,058,250
89,348 3,587,154
$ 36,467,706 $ 1,709,703 $ 1,660,563 $ 36,516,846
INTERNAL SERVICE FUNDS
2018
Beginning
Balance
As of March 31
Equipment Rental
Environmental
Public Works Admin
Total Enterprise Oper Funds
2018 2018 Ending
Actual Rev. Actual Exp. Balance
$ 2,844,672 $ 716,282 $ 380,759 $ 3,180,195
460,987 40,741 7,055 494,673
455,399 300,996 289,911 466,484
$ 3,761,058 $ 1,058,019 $ 677,725 $ 4,141,352
Finance Year -End Report - 8
Fund
10
EMPLOYEE BENEFIT RESERVES
2018 As of March 31
Beginning 2018 2018 Ending
Balance Actual Rev. Actual Exp. Balance
Unemployment Comp Rsv $ 150,189 $ 51,794 $ 19,131 $ 182,852
Employees Health Ben Rsv 2,194,903 3,084,081 2,995,328 2,283,656
Worker's Comp Rsv 382,854 257,989 329,816 311,027
Wellness/EAP 63,968 165 20,064 44,069
Total Employee Ben Reserve $ 2,791,914 $ 3,394,029 $ 3,364,339 $ 2,821,604
Fund
RISK MANAGEMENT RESERVE
2018 As of March 31
Beginning 2018 2018 Ending
Balance Actual Rev. Actual Exp. Balance
Risk Management Reserve $ 1,125,894 $ 2,121,783 $ 1,990,365 $ 1,257,312
Fund
DEBT SERVICE & AGENCY FUNDS
2018 As of March 31
Beginning 2018 2018 Ending
Balance Actual Rev. Actual Exp. Balance
GO Bond Redemption
LID Guaranty $ - $ $ $
2002 GO Convention Center 166,150 232,053 398,203
2005 GO Various Bonds 8,734 814,142 94,307 728,569
1996 GO LTD - Convention Center 72,672 63,561 136,233
LID Debt Service Control 38,809 38,809
Total GO Bond Redemption $ 247,556 $ 1,109,756 $ 94,307 $ 1,301,814
Water/Sewer Revenue Bond Redemption
Water Rev Bonds & Debt Service $ 581,253 $ - $ (1,833) $ 583,086
WW Rev Bond & 2008 Debt Service 267,982 103,455 (23,135) 394,572
Irrigation Bond Debt Service 176,060 85,671 28,557 233,174
WW Rev Bond Rsv & 2012 Debt Svc 2,557,272 388,300 (39,217) 2,984,789
Total W/S Rev Bond Redemption $ 3,582,567 $ 577,426 $ (35,628) $ 4,195,621
Agency Funds
Yakcorps 608,006 346,885 261,121
Cemetery Trust 667,296 7,144 674,440
Total Agency Funds $ 667,296 $ 615,150 $ 346,885 935,561
Finance Year -End Report - 9