HomeMy WebLinkAbout11/02/2020 04C 2020 3rd Quarter Treasury Report 't..an,gtntj ka
d E$A
aY
BUSINESS OF THE CITY COUNCIL
YAKIMA, WASHINGTON
AGENDA STATEMENT
Item No. 4.C.
For Meeting of: November 2, 2020
ITEM TITLE: 2020 3rd Quarter Treasury Report
SUBMITTED BY: Steve Groom, Director of Finance and Budget
SUMMARY EXPLANATION:
The Treasury Report for the third quarter of 2020 is attached and consists of the following:
Third Quarter Treasurer's Report
• Cash and Investments
• Long term Debt
• I nterfund Borrowings
ITEM BUDGETED: NA
STRATEGIC PRIORITY: Public Trust and Accountability
APPROVED FOR SUBMITTAL BY THE CITY MANAGER
RECOMMENDATION:
Review only. Submitted for routine transparency and accountability.
ATTACHMENTS:
Description Upload Date Type
L 3 eartedy Treasury pe rt 10/21/ xecuti u arr�
2
r t\,
FINANCE
Date: October 16, 2020
•WPTA
To: Mayor and City Council C TifienanXCELL CE k
Bob Harrison, City Manager " ` =•'
crFY0t.Atu1A
From: Steve Groom, Finance Director (ax n
Kimberly Domine, Finance Division Managers
Jennifer Morris, Financial Services Officer w $ '
Re: 2020 — 3rd Quarter Treasury Report
This report is to transparently report the City's cash position and investment activity for the quarter
just ended. Each investment is in compliance with the City's Investment Policy, State Statues
and City Municipal Code. The City's investment policy was reviewed and approved by City
Council on March 5, 2019; and the policy received a Certification of Excellence from the
Washington Public Treasurer's Association on April 10, 2019.
Total Cash and Investments at Quarter-end total $106.0 million: $14.7 million in depository
banks, $51.4 million in the State Pool, and $39.8 million invested.
The following chart shows the 5-year trend of total cash and investments month by month
(showing only permanent accounts comparable year over year).
City of Yak•rna
LigLid Cash and!a=.estnents H;story
$120 000,000 -
$100,000,000
$80,000.000 . .—. . . . .. . :: . . .. . .. . ... .
$60,000.000 iE . .. .. . . iE .. .. .. ...
;Esj' 3"` v �m .r ro
3
FINANCE
The City's Investment Portfolio
The City's investment activities are governed by State regulations and the City of Yakima's
Investment Policy. All investments are in full compliance with the City's Investment Policy, State
Statues and City Municipal Code.
Calls or Maturities. During last quarter, the following matured or were called at full value:
• 1526 $1 ,000,000 US Treasury matured 09/30/2020
• 1528 $1 ,000,000 FHLMC matured 08/25/2020
• 1530 $1 ,000,000 FHLMC called 07/10/2020
• 1531 $1 ,000,000 FHLMC called 09/17/2020
• 1535 $1 ,000,000 FHLB called 07/24/2020
• 1548 $1 ,000,000 FHLB called 08/26/2020
Purchases: During the last quarter, no investments were purchased; proceeds from all calls
and maturities were invested in the State Local Government Investment Pool.
Portfolio and Benchmark Yield and Maturity:
Avg. weighted yield of City investments, excluding LGIP: 1.12%
LGIP 30-day yield: 0.200%
Weighted average maturity of City investments, excluding LGIP: 326 days
Weighted average maturity of LGIP 30-day yield: 43 days
Execution of each investment transaction contemplated ongoing cash flows from city operations,
debt obligations, liquid and maturing securities, and contingencies to meet the City's future cash
flow requirements.
The City's Investment Portfolio consists of three general tiers which coincide with the primary
considerations of prudent investing:
1) The Safety portion of the Portfolio consists of funds invested in the Local Government
Investment Pool (LGIP, or State Pool) managed by the State Treasurer, available same-
day. This allows for seasonal fluctuations, primarily the April/October inflows of Property
Tax and the outflows of debt service and capital projects.
2) The Liquidity portion of the Portfolio consist of demand deposit (checking) accounts at
banks which are qualified public depositaries, protected above FDIC-insured balances
through the actions of the Washington State Public Deposit Protection Commission
(PDPC).
3) The Yield portion of the Portfolio consists of a diversified portfolio of Agencies, Treasuries
and/or other authorized investments with staggered maturities of up to five years. Based
2
4
FINANCE
on analysis of historical cash reserves and budgetary planning, this segment will not be
subject to seasonal spending and continues to be safely invested long-term.
Current Rates. As of September 30, 2020, the fixed income market has plateaued at record low
levels, evidenced by a yield curve that is extremely low and flat. The difference between the 1-
year Treasury at 0.12% and the 5-year Treasury at 0.28% was 16 basis points. The 30-day yield
of the State Pool was at 0.200%, with a 43-day avg. maturity so will continue to fall.
Economic Outlook. The Federal Reserve had lowered the rates in March 2020 lowered to zero,
during the Coronavirus pandemic, and signaled it will likely keep rates low for three years.
Unemployment, nationally, is recovering and the economy is experiencing less volatility; it is
unclear how long nor how deep the current conditions will exist.
Strategy Notes. The City of Yakima's investments are not typically actively traded, meaning that
...................................................................................... . . ................................................................:..
no attempt to "buy low and sell ig or ; Actual % Policy %
"time the market" is made. Investments 33.LGIP 51,438,663 56% 100%,
purchased with the intent of providing ',;',Treasuries 3,000,000 3% 100%;,
investment income are intended to be held ''Agencies 31,789,000 35% 100%',,
to maturity, relying on following a prudent ;Corporates 5,000,000 5% 15%';,
course of action for income rather than 'i
predicting market direction. 91,227,663 100%
Debt Activity
All debt payments were paid out as scheduled. A comprehensive city-wide debt report is attached
with current balances.
Interfund Borrowings and Investments
Borrowing between funds is temporary in nature, reviewed periodically by staff and Council,
amended as circumstances change. All debt payments continue as scheduled.
3
City of Yakima
Cash and Investment Summary
September 30, 2020
Current Prior Quarter Prior Year
Description 9/30/2020 6/30/2020 9/30/2019
Cash Balances on Hand in Banks $ 14,735,513 $ 14,735,513 $ 18,154,002
Local Government Investment Pool (LGIP) 51 ,438,663 49,414,612 20,690,499
Investment Portfolio 39,789,000 45,789,000 55,483,000
Total Investments 91 ,227,663 95,203,612 76,173,499
Total Cash and Investments $ 105,963,175 $ 109,939,125 $ 94,327,501
Beg Balance Purchases Interest Maturities, Calls End Balance
Summary of Investment Activity 6/30/2020 & Deposits Reinvested & Withdrawals 9/30/2020
Local Government Investment Pool (LGIP) $ 49,414,612 $ 2,000,000 $ 24,051 $ - $ 51 ,438,663
Investment Portfolio 45,789,000 - - (6,000,000) 39,789,000
Total Investments $ 95,203,612 $ 2,000,000 $ 24,051 $ (6,000,000) $ 91 ,227,663
Page 1 of 8 2020 Q3 TSO spreadsheet 10-20-2020
City of Yakima
Distribution of Cash and Investments as of 9J30/2020
Depository Banks,
.......................................................
$14,735,513 , 14%
.............................
...................................................................
................................
..........................................................................
..................................
........................................................................................
........................................
.................................................................................................
........................................
.........................................................................................................
..................................................
..............................................2................................7...........................
....................................................
..........................................:::1„:::::................................................................
...........................................................
.....................................................................................................................
.........................................................
...............................::::„...........................................................................................
............................................................
..................................................................................................................................
.................................................................
...................................................................................................................................
...........................................................2:
..............................................................................................................................................
......................................................................
..................................................................................................................................................
.....................„:::::::::::........................................
.....................................................................................................................................................
...........................................................................
...........................................................................................................................................................
........................_:::::..................................................
............................................................................................................................................................
.................................................................................
....................................................................................................................................................................
..................................................................................
.....................................................................................................................................................................
....................................................................................
Investment
Portfolio
39 789 000 38l :
Local overnment
Investment Pool,
$51,438,663 , 48l
Page 2 of 8
City of Yakima
Investment Portfolio -Inventory by Agency
September 30, 2020
Expected Days to Call
Agency Inv# CUSIP Face Value Price Coupon Yield Settle Maturity Maturity Market Type Moodys S&P Fitch
RFCSP 1502 76116FAE7 2,122,000 1,999,174 2.250 2.250 02/14/18 10/15/20 107 2,121,885 NC Aaa AA+ AAA
US T 1534 9128285Q9 1,000,000 1,012,227 2.750 1.630 10/22/19 11/30/20 153 1,004,398 NC Aaa AA+ AAA
FFCB 1542 3133ELAQ7 1,000,000 1,000,000 1.600 1.600 11/22/19 12/22/20 175 1,003,404 NC Aaa AA+ AAA
RFCSP 1500 76116FAG2 2,667,000 2,499,062 2.200 2.200 01/25/18 1/15/21 199 2,665,181 NC Aaa AA+ AAA
US T 1549 912828Q37 1,000,000 997,695 1.625 1.496 2/4/20 3/31/21 274 1,005,742 NC Aaa NA AAA
FFCB 1518 3133EKGY6 1,000,000 1,000,000 2.375 2.375 4/15/19 4/15/21 289 1,012,153 NC Aaa AA+ AAA
BNY 1521 06406FAB9 1,000,000 989,800 2.050 2.574 4/30/19 5/3/21 307 1,009,040 NC Al A AA-
US T 1543 912828WY2 1,000,000 1,009,453 2.250 1.660 12/11/19 7/31/21 396 1,017,695 NC Aaa AA+ AAA
FHLMC 1539 3137EAEC9 1,000,000 991,002 1.125 1.650 11/14/19 8/12/21 408 1,008,583 NC Aaa AA+ AAA
FFCB 1527 3133EKP67 1,000,000 996,900 1.625 1.780 9/17/19 9/17/21 444 1,014,339 NC Aaa AA+ AAA
USB 1515 91159HHP8 1,000,000 997,300 2.625 2.723 3/18/19 1/24/22 573 1,029,238 1X Al A+ AA-
MSFT 1512 594918BW3 1,000,000 996,920 2.400 2.575 3/15/19 2/6/22 586 1,027,155 NC Aaa AAA AA+
FHLB 1556 313378CR0 1,000,000 1,032,367 2.250 0.630 3/6/20 3/11/22 619 1,030,263 NC Aaa AA+ NA
FNMA 1550 3135G0T45 1,000,000 1,009,506 1.875 1.422 2/14/20 4/5/22 644 1,026,367 NC Aaa AA+ AAA
FFCB 1523 3133EKLR5 1,000,000 999,100 2.250 2.281 5/16/19 5/16/22 685 1,033,946 NC Aaa AA+ AAA
FAMCA 1522 31422BFF2 1,000,000 1,000,000 2.350 2.350 5/9/19 6/1/22 701 1,036,133 NC Aaa AA+ AAA
FHLB 1509 313383WD9 1,000,000 1,013,146 3.125 2.750 12/19/18 9/9/22 801 1,057,011 Amer Aaa AA+ AA+
FFCB 1519 3133EKHN9 1,000,000 997,450 2.330 2.406 4/18/19 10/18/22 840 1,044,202 NC Aaa AA+ AAA
FFCB 1551 3133EA7E2 1,000,000 1,014,130 1.960 1.430 2/14/20 11/7/22 860 1,037,516 NC Aaa AA+ AAA
FHLB 1544 313381BR5 1,000,000 1,006,250 1.875 1.660 12/11/19 12/9/22 892 1,036,970 NC Aaa AA+ AAA
FNMA 1541 3135GOT94 1,000,000 1,023,490 2.375 1.610 11/20/19 1/19/23 933 1,049,425 NC Aaa AA+ AAA
FFCB 1557 3133EG5Y7 1,000,000 1,045,401 2.230 0.650 3/6/20 2/2/23 947 1,047,658 NC Aaa AA+ AAA
AAPL 1516 037833AK6 1,000,000 991,000 2.400 2.634 4/8/19 5/3/23 1,037 1,052,080 NC AA1 AA+ -
WMT 1513 931142EK5 1,000,000 1,026,800 3.400 2.730 3/15/19 6/26/23 1,091 1,080,690 NC Aa2 AA AA
US T 1545 9128284X5 1,000,000 1,039,063 2.750 1.660 12/11/19 8/31/23 1,157 1,075,859 NC Aaa AA+ AAA
FAMCA 1508 3132X06C0 1,000,000 1,010,972 3.050 2.801 12/19/18 9/19/23 1,176 1,082,066 NC Aaa AA+ AAA
FFCB 1537 3133EK4X1 1,000,000 997,924 1.600 1.654 11/6/19 11/1/23 1,219 1,042,292 NC Aaa AA+ AAA
FHLB 1507 3130AFKR7 1,000,000 1,003,225 3.100 2.933 12/28/18 12/28/23 1,276 1,007,336 Amer Aaa AA+ AA+
FAMCA 1552 31422BSD3 1,000,000 1,004,430 1.590 1.470 2/14/20 1/10/24 1,289 1,042,579 NC NA NA NA
FNMA 1540 3135G0V34 1,000,000 1,032,055 2.500 1.710 11/14/19 2/5/24 1,315 1,076,036 NC Aaa AA+ AAA
US T 1553 9128286R6 1,000,000 1,034,063 2.250 1.413 2/14/20 4/30/24 1,400 1,074,219 NC Aaa NA AAA
FAMCA 1533 31422BGA2 1,000,000 1,022,900 2.150 1.634 10/18/19 6/5/24 1,436 1,066,920 NC NA NA NA
US T 1546 9128282U3 1,000,000 1,008,789 1.875 1.660 12/11/19 8/31/24 1,523 1,065,781 NC Aaa NA AAA
FHLMC 1536 3134GULS7 1,000,000 1,000,000 1.875 1.875 10/28/19 10/28/24 1,581 1,000,868 1C-NC Aaa AA+ AAA
FFCB 1538 3133EK6J0 1,000,000 994,700 1.625 1.736 11/8/19 11/8/24 1,592 1,054,397 NC Aaa AA+ AAA
FHLB 1554 3130A3GE8 1,000,000 1,058,979 2.750 1.480 2/14/20 12/13/24 1,627 1,101,685 NC Aaa AA+ NA
FAMCA 1555 31422BRT9 1,000,000 1,011,943 1.750 1.495 2/14/20 1/3/25 1,648 1,058,004 NC NA NA NA
Subtotal 37 39,789,000 39,867,215 Avg. 2.22% 41,199,117
LGIP LGIP NA 51,438,663 51,438,663 0.300 0.300 NA NA 1 51,438,663 NC
IIGrand Totals $ 91,227,663 $ 91,305,878 1.14% 352 $ 92,637,779
Page 3 of 8 2020 Q3 TSO spreadsheet 10-20-2020
City of Yakima
Investment Portfolio by Issuer at 9/30/2020
FAMCA, 5,000,000, 6%
FHLB, 5,000,000, 6% FHLMC, 2,000,000, 2%
In REF 21"
RFCSP, 4,789,000, 5%
us T. 6,000,000, 7% FNMA, 3,000,000, 3%
411111111a *rs row maw
AAPL, 1 000 000 1%t
Aniiiiiiiik HMI g BF °
BNY, 1,000,000, 11°
MSFT 1,000,000, 11°
°
USB 1,000,000, 11°
aegsk) off
W MT 1,000,000, 1 f°
FFCB, 9,000,000, 10%
'1,66i.
ssssssssssssssss:: sits
Diversifying by issuer reduces
the credit risk the city is
subject to from any one
issuer as well as diversifies
market price fluctuations
which can vary by issuer. LGIP, 51,438,663, 56°t°
Page 4 of 8 2020 Q3 TSO spreadsheet 10-20-2020
Page 5 of 8
City of Yakima
Investment Portfolio Maturity Distribution at 9/30/2020
$4,000,000
53,5o0,000 Diversifying by maturity
reduces the re-investment risk
the city is subject to in any
$3,000,000 given month when an
investment matures and the
principal is reinvested at rates
$2,500,000 available at that moment.
$2,000,000
51,500,000
51,000,000
$500,000 II III III
ti9 ti ti~ I> 1> 'Lti 'L~ 'L1 titi 11' titi :1-1' ,1). 1� 1� ti� tie ti� 1, lob 1". 'Lb tio- 2," 1,4 'L� lt/ 'Lf2
Qze 4¢ 1pc psO cp. cf. pep vg 1JP ," 0C- cpc 1z`P pQt lJp P0° 04` cze Fz'd PQi .1 "0 0t" cibc1z"Sc v..
Page 5 of 8 2020 Q3 TSO spreadsheet 10-20-2020
10
City of Yakima
Investment Portfolio- Detail of Activity
September 30,2020
Beginning Additions and Calls and Ending
Agency Inv# Face Value Purchases Maturities Face Value
Farmer Mac
FAMCA 1508 1,000,000 - - 1,000,000
FAMCA 1522 1,000,000 - - 1,000,000
FAMCA 1533 1,000,000 - - 1,000,000
FAMCA 1552 1,000,000 - 1,000,000
FAMCA 1555 1,000,000 - - 1,000,000
FAMCA Total 5,000,000 - - 5,000,000
Federal Farm Credit Bureau
FFCB 1518 1,000,000 - - 1,000,000
FFCB 1519 1,000,000 - - 1,000,000
FFCB 1523 1,000,000 - - 1,000,000
FFCB 1527 1,000,000 - - 1,000,000
FFCB 1537 1,000,000 - - 1,000,000
FFCB 1538 1,000,000 - - 1,000,000
FFCB 1542 1,000,000 - - 1,000,000
FFCB 1551 1,000,000 - - 1,000,000
FFCB 1557 1,000,000 - - 1,000,000
FFCB Total 9,000,000 - - 9,000,000
Federal Home Loan Bank
FHLB 1507 1,000,000 - - 1,000,000
FHLB 1509 1,000,000 - - 1,000,000
FHLB 1535 1,000,000 - (1,000,000) -
FHLB 1544 1,000,000 - - 1,000,000
FHLB 1548 1,000,000 - (1,000,000) -
FHLB 1554 1,000,000 - - 1,000,000
FHLB 1556 1,000,000 - - 1,000,000
FHLB Total 7,000,000 - (2,000,000) 5,000,000
Resolution Funding Corporation
RFCSP 1500 2,667,000 - - 2,667,000
RFCSP 1502 2,122,000 - - 2,122,000
RFCSP Total 4,789,000 - - 4,789,000
Federal Home Loan Mortgage Corporation
FHLMC 1528 1,000,000 - (1,000,000) -
FHLMC 1530 1,000,000 - (1,000,000) -
FHLMC 1531 1,000,000 - (1,000,000) -
FHLMC 1536 1,000,000 - - 1,000,000
FHLMC 1539 1,000,000 - - 1,000,000
FHLMC Total 5,000,000 - (3,000,000) 2,000,000
Federal National Management Association
FNMA 1540 1,000,000 - - 1,000,000
FNMA 1541 1,000,000 - - 1,000,000
FNMA 1550 1,000,000 - - 1,000,000
FNMA Total 3,000,000 - - 3,000,000
US Treasury
US Treasury 1526 1,000,000 - (1,000,000) -
US Treasury 1534 1,000,000 - - 1,000,000
US Treasury 1543 1,000,000 - - 1,000,000
US Treasury 1545 1,000,000 - - 1,000,000
US Treasury 1546 1,000,000 - - 1,000,000
US Treasury 1549 1,000,000 - - 1,000,000
US Treasury 1553 1,000,000 - - 1,000,000
US Treasury 7,000,000 - (1,000,000) 6,000,000
Corporate Notes
AAPL 1516 1,000,000 - - 1,000,000
MSFT 1512 1,000,000 - - 1,000,000
WMT 1513 1,000,000 - 1,000,000
USB 1514 1,000,000 - 1,000,000
BNY 1521 1,000,000 - 1,000,000
Corporate Total 5,000,000 - - 5,000,000
Subtotal 45,789,000 - (6,000,000) 39,789,000
Other Investments - - - -
LGIP(StatePool) LGIP 49,414,612 2,024,051 - 51,438,663
Other Investment Totals 49,414,612 2,024,051 - 51,438,663
'Grand Totals $ 95,203,612 $ 2,024,051 $ (6,000,000) $ 91,227,663
Page 6 of 8 2020 03 ISO spreadsheet 10-20-2020
City of Yakima
Long Tenn Debt Schedule-by Project Group
September 30,2020
Date Issued Maturity Description Note Amount of Issue Current Balance
General Obligation Bonds
6/17/2003 12/1/2023 Sundome Expansion Deferred Interest-Maturity$25M x 1,430,528 244525.80
6/20/2013 6/20/2028 Street Project Demonstration(Refunded) Various City street improvements x 3,500,000 2758,315.13
6/9/2014 6/1/2024 Street Resurfacing Project Streets improvements x 13,140,000 5,995,000.00
6/17/2014 12/1/2034 Comm Center Move City portion of County GO Bonds 1,716,500 1,325,000.00
9/24/2018 12/1/2035 Soccer Complex(Refunded) City portion of SOZO Sports Complex x 4,440,127 4,072779.06
9/24/2018 7/1/2035 2018 Aquatic Center YMCA City portion of Aquatic Center x 8,009,873 7,950,366.01
4/21/2020 12/1/2034 2020 Ref 04 Irrigation 2020 Ref 64Irrigation x 3,260,000 3,260,000.00
4/21/2020 12/1/2027 2020 Ref 08 WS Rev 2020 Ref 08 WS Rev x 2590,000 2590,000.00
4/21/2020 12/1/2022 2020 Refunding Bonds,Downtown Future 2020 Refunding Bonds,Downtown Futures 260,000 260,000.00
4/21/2020 12/1/2021 2020 Refunding Bonds,Fire Apparatus 2020 Refunding Bonds,Fire Apparatus x 140,000 140,000 00
4/21/2020 12/1/2022 2020 Refunding Bonds,WV Fire Station 2020 Refunding Bonds,WV Fire Station x 140,000 140,000 00
4/21/2020 12/1/2032 2020B Capital Theatre 09 Refunded 2020B Capital Theatre 09 Refunded x 4,910,000 4,910,000.00
4/21/2020 12/1/2644 2020B Convention Center Addition 2020B Convention Center Addition x 12620,000 12620,000.00
4/21/2020 12/1/2044 2020B Convention Center Addition III Ref 2020B Convention Center Addition III Refunded 2,495,000 2,495,000.00
Subtotal General Obligation Bonds $ 71,607,028 48,760,986.00
Certificate of Participation-State of Washington
3/19/2013 7/1/2023 Fire Apparatus One track x 310,414 109,269.62
9/28/2017 6/1/2027 Energy Project 2017 Energy Project(lighting) x 921,863 701,899.85
7/21/2020 6/1/2035 Energy Project 2020 Energy Efficiency Project(lighting) x 1,415,000 1,415,000.00
9/28/2017 6/1/2027 Fire Aerial&Pump App Fire Aerial 1,268,053 965,674.41
Subtotal Certificates of Participation x $ 4,492178 3,191,843.88
Revenue Bonds
5/31/2012 11/1/2023 Wastewater Refunded 2003$10,155,000 issue x $ 9,400,000 4,230,000.00
Subtotal Revenue Bonds $ 20,055,000 4,230,000.00
Intergovernmental Loans
8/14/2009 7/1/2028 PC-08-951-052 2009 Railroad Grade Separation x $ 3,000,000 1,320,80200
5/6/2010 6/1/2034 L1000030-0 2010 Railroad Grade Separation x 1,149,841 964903.85
9/30/2015 6/1/2023 '16 Yak Co SIED-21st Ave/Airport 2015 Yakima Co SIED Loan-21st Ave/Airport x 307,000 166,098.93
6/1/2016 6/1/2027 '16 Yak Co SIED-SOZO 2016 Yakima Co SIED Loan-SOZO x 900,000 691,089.93
11/21/2017 6/1/2024 '17 Yak Co SIED-YV Brewing Project 2017 Yakima Co SIED Loan-YV Brewing Project x 61,580 43,195.68
7/17/2018 6/1/2029 '18 Yak Co SIED-River Rd. 2018 Yakima Co SIED-River Rd Improvements/Aquatics Center x 500,000 472034.18
6/1/2001 7/1/2021 PW-01-691-071 2001 Fruitavale Neighborhood Sewer x 1,466,250 77,625.00
9/1/2003 7/1/2023 PW-03-691-027 2003 Naches WTP Improvements x 2,694,500 404195.00
6/27/2005 10p/2025 SRF-04-65104-037 2005 Naches River WTP Filter Rehab x 966,772 282435.89
12/30/2005 7/1/2025 PW-05-691-064 2005 River Road Sewer x 2309,000 621,228.88
4/30/2009 7/1/2027 PW-07-962-019 2009 Ultra Violet Disinfection x 2300,000 849,92221
4/15/2009 7/1/2028 PC-08-951-051 2009 New Water Well x 2259,200 969,190.60
10p0/2011 3/31/2033 L1100008 2011 Energy Efficiency x 503,558 364809.89
8/1/2011 7/1/2034 41200019 2012 Industrial Waste Anaerobic x 590,350 459,548.32
6/1/2012 6/1/2032 PC-12-951-065 2012 Wastewater Treatment Plan x 5,000,000 2959,89054
10p1/2012 6/1/2037 PC-13-961-069 2012 Industrial Sewer Extensions x 2000,000 1,382775.15
8/5/2013 7/1/2032 PC-13-961-094 2013 Automated Reading System x 5,000,000 3,159,89494
12/12/2013 10p/2034 DM-11-962-038 2013 Design WTP Lagoons 3,514,800 2636,100.01
Subtotal Intergovernmental Loans x $ 34,518,851 17,803,500.78
°Grand Total $ 130,673,056 73,986,330.66 II
Page 7 of 8 2020 03 TS0 spreadsheet 10-20-2020
City of Yakima
Interfund Borrowing
September 30,2020
Original Beginning Ending
Description Balance Balance Issued Retired Balance
Local Improvement District Bonds/Notes $ 1,432,509 $ 34,072 $ - $ 16,751 $ 17,321 Equipment Rental Reserve
Fund 153- Public Safety Communications 450,000 300,000 - 150,000 150,000 Equipment Rental Reserve
Total across all funds 1,882,509 334,072 - 166,751 167,321
Fund 151 - Public Safety Communications- Interfund Loan
The Public Safety Communications Fund borrowed from the Equipment Replacement and Reserve Fund to provide working capital while they recover from the
excess cash outflow caused by the move to the new Communications Center last year.A$150,000 payment was made in 2019. The final payment$150,000 will be
paid in December 2020.
Page 8 of 8 2020 Q3 TSO spreadsheet 10-20-2020