HomeMy WebLinkAbout01/21/2020 06C 2019 4th Quarter Treasury Report a\'4\lyy bxk ik 1
" PPd
+� PPP
d g.
P A
PPPPPP+Pd s'
lii it
tYlltYlA.\ta.
BUSINESS OF THE CITY COUNCIL
YAKIMA, WASHINGTON
AGENDA STATEMENT
Item No. 6.C.
For Meeting of: January 21, 2020
ITEM TITLE: 2019 4th Quarter Treasury Report
SUBMITTED BY: Steve Groom, Director of Finance and Budget
SUMMARY EXPLANATION:
The Treasury Report for the fourth quarter of 2019 is attached and consists of the following:
1 . 4th Quarter Treasurer's Report
• Cash and Investments
• Long term Debt
• I nterfund Borrowings
2. December Investment Transactions reviewed by Investment Committee
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
D 019 4th C uarter Treasury f epo 1/71 020 r Me o
2
t+`\
pmkt
rtle
FINANCE
Date: January 6, 2020
;IOTA
To: F.
To: Mayor and City Council G£31PICnretrcelLEfiC r.
Alex Meyerhoff, Interim City Manager x OM OE AKIO*
at
From: Steve Groom, Finance Director
Jennifer Morris, Financial Services Officer
Re: 2019 — 4th Quarter Treasury Report
Updates to the City's investment policy were approved by City Council on March 5, 2019; 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 $102.1 million: $18.2 million in depository
banks, $19.8 million in the State Pool, and $64.2 million invested.
The following chart shows the 5-year trend of total cash and investments month by month.
C,ty of=aPdna
tic uid Cat',a:i6(acestoetit history
::.2Ci,300,003
'Oft 3On,003
$EO,300,CO3 .. ...
550.300,CO3 .� . . . . . :, . .:, :.,. . . .
a,3aa.3�3 :
:
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:
• 1501 $1 ,000,000 FNMA called 10/30/2019
• 1503 $3,139,000 REFCORP matured 10/15/2019
• 1505 $2,160,000 REFCORP matured 10/15/2019
• 1506 $1 ,000,000 FHLB matured 11/15/2019
• 1511 $1 ,000,000 FHLB called 1/14/2019
• 1524 $1 ,000,000 FHLMC called 11/14/2019
• 1525 $1 ,000,000 FHLMC called 11/12/2019
Purchases: During the last quarter, the following were purchased:
• 1528 $1000,000 FHLMC to mature 8/6/2022
• 1529 $1 ,000,000 FFCB to mature 10/16/2023
• 1530 $1 ,000,000 FHLMC to mature 7/10/2023
• 1531 $1 ,000,000 FHLMC to mature 9/17/2024
• 1532 $1 ,000,000 FHLMC to mature 10/15/2021
• 1533 $1 ,000,000 FAMCA to mature 6/5/2024
• 1534 $1 ,000,000 US Treasury to mature 11/30/2020
• 1535 $1 ,000,000 FHLB to mature 7/24/2024
• 1536 $1 ,000,000 FHLMC to mature 10/28/2024
• 1537 $1 ,000,000 FFCB to mature 11/1/2023
• 1538 $1 ,000,000 FFCB to mature 11/8/2024
• 1539 $1 ,000,000 FHLMC to mature 8/12/2021
• 1540 $1 ,000,000 FNMA to mature 2/5/2024
• 1541 $1 ,000,000 FNMA to mature 1/19/2023
• 1542 $1 ,000,000 FFCB to mature 12/22/2020
• 1543 $1 ,000,000 US Treasury to mature 7/31/2021
• 1544 $1 ,000,000 FHLB to mature 12/9/2022
• 1545 $1 ,000,000 US Treasury to mature 8/31/2023
• 1546 $1 ,000,000 US Treasury to mature 8/31/2024
2
4
FINANCE
The following graphs illustrate the change to the portfolio, over the course of just over a year, in
maturity distribution. Diversifying by maturity reduces the re-investment risk the city is subject to
in any given month when an investment matures and the principal is reinvested at rates available
at that moment.
City of Yakima
Investment Potttol c Matur;ty Dates are.Amounts
SE 020,i02
$3,020,"
Sr o,( o..
1 l N2 02 s 02 l " 02 0. 202 Y'
X v x ..2 s ;' t r 0 7: 7 l a
'., C ty of Yakrta
rves-ment.Par-talk) Maturity Da-es an3 Amnurtc -Uctn:her 1.7018
I E,k'frPOG!
0220
11,tb00W
N.t9�D4:4
l R S -0 Y ti .002 .12 is '2 t+
3
5
FINANCE
by issuer due to
which can vary
byfluctuations
The following graphs illustrate the changetoistshueepr creditthe corui srks e theof city just i so vseurbai subject
taeora,fcoin
hr
well as diversifies
the diversification by issuer. Diversifyingorertdfoulcioesotvheer
each issuer as we . market price
issuer's business circumstances.
City of Yakima 2019 FRLB, 5693°1",746
Divers If
55 ,000,000,6%
Treat,
' motion by ssuer- Dec, _31 i
4%
AFT
5 oo,—noo,
I I tLNIC,
FAMCA, L°
000,146
12 Ws
, SLC°R
le
-A
....a..a.g.S.S.S.S.
F Mt $13..1"141:.1.DAN)4
roW1:1 ma 8naNcrutY rli)515:9 171 1 GO°,0 0 0:70:,a.'11156:
REC Cal ' lil 1414:1:rg It::11*3333.12;:iiiiiakinkatimazze::::::w " rosoft, 51,000,
1394 iir";ititit!Mil I,a Siiiiiiiiiistsgzatzsi
'rillic.eira**1 r:44413"Sfe11333333iiiiiiiiiiftwz,
CO or Yakima ,, 33 2018
, —
.
1W:Z.91,71 SCIAIllif.
. '
.' FFCE, 11214,15°°°'
FICO STRIP,
,..,+ . .
111 17411,01111 1:CH11 IlitLE.,....=Hr*1111111111tatititiazkitra 52311,000,8%
IL}-**171.': 'PrittEE03 illigiliiiiiiiiilialitiga;„ir
aill1111111
.*...::: tli 141 1 Mil liEr—exi_ali!):tilliftfiritlitt;ftitittiet '
.4 i ?i€i 4 i'=f PlEtrgi:i:titieliiiiiiiiiiiiiiiYaiiiiit, FFILB 2,030,000,3%
'11 1:4F;#65111 i--t-w-Ht".).:ziiiiiiiiiEigggtgr.
sv!-E7S551:417.:1WRiisisis,.......
4
6
FINANCE
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
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 December 31, 2019, the fixed income market is experiencing slightly less
uncertainty, evidenced by a yield curve that is extremely flat. The difference between the 1-year
Treasury at 1.59% and the 5-year Treasury at 1.69% was a mere 10 basis points. The 30-day
yield of the State Pool was at 1.728%.
Economic Outlook. The Federal Reserve has lowered the rates three times in 2019 — in
August, September, and October. Unemployment, nationally, remains low and the economy
continues to appear strong so recession concerns continue to appear to be optimistic.
Strategy Notes. The City of Yakima's Actual % Policy %
investments are not typically actively traded, LGIP 19,786,229 23% 100%
meaning that no attempt to "buy low and sell Treasuries 3,000,000 4% 100%
high" or "time the market" is made. Agencies 56,184,000 67% 100%
Investments purchased with the intent of Corporates 5,000,000 6% 15%
providing investment income are intended to 83,970,229 100%
be held to maturity, relying on following a
prudent course of action for income rather than predicting market direction. No securities were
considered, due to prevailing circumstances, to be sold prior to maturity during the last quarter.
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.
5
City of Yakima
Cash and Investment Summary
December 31 , 2019
Current Prior Quarter Prior Year
Description 12/31/2019 9/30/2019 12/31/2018
Cash Balances on Hand in Banks $ 18,154,002 $ 18,154,002 $ 9,297,534
Local Government Investment Pool (LGIP) 19,786,229 20,690,499 32,751 ,940
Investment Portfolio 64,184,000 55,483,000 50,544,848
Total Investments 83,970,229 76,173,499 83,296,788
Total Cash and Investments $ 102,124,232 $ 94,327,502 $ 92,594,322
Beg Balance Purchases Interest Maturities, Calls End Balance
Summary of Investment Activity 9/30/2019 & Deposits Reinvested & Withdrawals 12/31/2019
Local Government Investment Pool (LGIP) $ 20,690,499 $ 9,000,000 $ 95,730 $ (10,000,000) $ 19,786,229
Investment Portfolio 55,483,000 19,000,000 - (10,299,000) 64,184,000
Total Investments $ 76,173,499 $ 28,000,000 $ 95,730 $ (20,299,000) $ 83,970,229
Page 1 of 8 2019 Q4 TSO spreadsheet
City of Yakima
Distribution Cr Cash and Investments as of 12/31/2019
......::::::::::.........
Depository Banks,
01:01000022000020020
$18,154,002 , 181
Local Government
Investment Pool
0
Investment
19786229 191
Portfolio
0
64 184 000 63l
Page 2 of 8
City of Yakima
Investment Portfolio-Inventory by Agency
December 31, 2019
Expected Days to Call
Agency Inv# CUSIP Face Value Price Coupon Yield Settle Maturity Maturity Market Type Moodys S&P Fitch
FFCB 1520 3133EKJS6 1,000,000 1,000,000 2.400 2.400 4/29/19 4/29/20 120 1,002,923 NC Aaa AA+ AAA
FNMA 1488 3136G3QK4 3,000,000 2,999,970 1.500 1.500 6/3/16 5/22/20 143 2,998,716 Qtrly Aaa AA+ AAA
FNMA 1494 3136G4GK3 2,010,000 1,995,172 1.350 1.560 12/14/16 7/28/20 210 2,008,561 Qtrly Aaa AA+ AAA
UST 1526 912828VZ0 1,000,000 1,001,563 2.000 1.847 09/16/19 9/30/20 274 1,002,695 NC Aaa AA+ NC
RFCSP 1493 76116FAE7 3,203,000 2,999,859 1.716 1.716 12/14/16 10/15/20 289 3,159,862 NC Aaa AA+ AAA
RFCSP 1502 76116FAE7 2,122,000 1,999,174 2.250 2.250 02/14/18 10/15/20 289 2,093,421 NC Aaa AA+ AAA
UST 1534 9128285Q9 1,000,000 1,012,227 2.750 1.630 10/22/19 11/30/20 335 1,010,039 NC Aaa AA+ AAA
FFCB 1542 3133ELAQ7 1,000,000 1,000,000 1.600 1.600 11/22/19 12/22/20 357 1,000,120 NC Aaa AA+ AAA
RFCSP 1495 76116FAG2 2,137,000 1,995,637 1.821 1.821 04/06/17 1/15/21 381 2,096,916 NC Aaa AA+ AAA
RFCSP 1499 76116FAG2 1,000,000 945,156 1.730 1.730 10/06/17 1/15/21 381 981,243 NC Aaa AA+ AAA
RFCSP 1500 76116FAG2 2,667,000 2,499,062 2.200 2.200 01/25/18 1/15/21 381 2,616,975 NC Aaa AA+ AAA
FFCB 1496 3133EGRN7 2,015,000 1,994,713 1.470 1.740 4/6/17 2/17/21 414 2,011,961 1C-NC Aaa AA+ AAA
FFCB 1518 3133EKGY6 1,000,000 1,000,000 2.375 2.375 4/15/19 4/15/21 471 1,010,201 NC Aaa AA+ AAA
BNY 1521 06406FAB9 1,000,000 989,800 2.050 2.574 4/30/19 5/3/21 489 1,003,038 NC Al A AA-
FNMA 1490 3136G3SJ5 2,000,000 1,995,048 1.500 1.552 6/30/16 6/30/21 547 1,994,966 Qtrly Aaa AA+ AAA
UST 1543 912828WY2 1,000,000 1,009,453 2.250 1.660 12/11/19 7/31/21 578 1,010,078 NC Aaa AA+ AAA
FHLMC 1539 3137EAEC9 1,000,000 991,002 1.125 1.650 11/14/19 8/12/21 590 992,419 NC Aaa AA+ AAA
FFCB 1527 3133EKP67 1,000,000 996,900 1.625 1.780 9/17/19 9/17/21 626 1,000,851 NC Aaa AA+ AAA
FHLMC 1532 3134GUHC7 1,000,000 1,000,000 1.750 1.750 10/15/19 10/15/21 654 1,000,076 1C-NC Aaa AA+ AAA
FH LB 1492 3130A9Z61 2,030,000 1,994,020 1.500 1.880 12/14/16 11/9/21 679 2,019,324 Amer Aaa AA+ AA+
FNMA 1491 3136G3SW6 2,000,000 1,997,896 1.500 1.520 6/30/16 12/30/21 730 1,989,390 Qtrly Aaa AA+ AAA
USB 1515 91159HH P8 1,000,000 997,300 2.625 2.723 3/18/19 1/24/22 755 1,015,194 1X Al A+ AA-
MSFT 1512 594918BW3 1,000,000 996,920 2.400 2.575 3/15/19 2/6/22 768 1,014,131 NC Aaa AAA AA+
FFCB 1498 3133EHYQ0 3,000,000 2,993,640 1.950 2.000 10/6/17 3/14/22 804 3,000,054 Amer Aaa AA+ AAA
FFCB 1523 3133EKLR5 1,000,000 999,100 2.250 2.281 5/16/19 5/16/22 867 1,014,925 NC Aaa AA+ AAA
FAMCA 1522 31422BFF2 1,000,000 1,000,000 2.350 2.350 5/9/19 6/1/22 883 1,017,567 NC Aaa AA+ AAA
FHLMC 1528 3134GT3N1 1,000,000 999,990 1.750 1.750 10/2/19 8/26/22 969 999,623 1C-NC Aaa AA+ AAA
FH LB 1509 313383WD9 1,000,000 1,013,146 3.125 2.750 12/19/18 9/9/22 983 1,039,868 Amer Aaa AA+ AA+
FFCB 1519 3133EKHN9 1,000,000 997,450 2.330 2.406 4/18/19 10/18/22 1,022 1,019,419 NC Aaa AA+ AAA
FH LB 1544 313381BR5 1,000,000 1,006,250 1.875 1.660 12/11/19 12/9/22 1,074 1,006,654 NC Aaa AA+ AAA
FNMA 1541 3135GOT94 1,000,000 1,023,490 2.375 1.610 11/20/19 1/19/23 1,115 1,022,671 NC Aaa AA+ AAA
FHLMC 1510 3134GS6F7 1,000,000 1,000,000 2.720 2.720 3/27/19 3/27/23 1,182 1,001,600 lx Aaa AA+ AAA
FHLMC 1517 3134GTGM9 1,000,000 1,000,000 2.550 2.550 4/10/19 4/10/23 1,196 1,001,937 lx Aaa AA+ AAA
AAPL 1516 037833AK6 1,000,000 991,000 2.400 2.634 4/8/19 5/3/23 1,219 1,017,350 NC AA1 AA+ -
WMT 1513 931142EK5 1,000,000 1,026,800 3.400 2.730 3/15/19 6/26/23 1,273 1,050,970 NC Aa2 AA AA
FHLMC 1530 3134GUHJ2 1,000,000 1,000,000 1.750 1.750 10/10/19 7/10/23 1,287 990,016 1C-NC Aaa AA+ AAA
UST 1545 9128284X5 1,000,000 1,039,063 2.750 1.660 12/11/19 8/31/23 1,339 1,039,336 NC Aaa AA+ AAA
FAMCA 1508 3132X06C0 1,000,000 1,010,972 3.050 2.801 12/19/18 9/19/23 1,358 1,050,388 NC Aaa AA+ AAA
FHLMC 1529 3134GUGA2 1,000,000 1,000,000 2.000 2.000 10/16/19 10/16/23 1,385 991,445 Qtrly Aaa AA+ AAA
FFCB 1537 3133EK4X1 1,000,000 997,924 1.600 1.654 11/6/19 11/1/23 1,401 998,661 NC Aaa AA+ AAA
FH LB 1507 3130AFK87 1,000,000 1,003,225 3.100 2.933 12/28/18 12/28/23 1,458 1,010,143 Amer Aaa AA+ AA+
FNMA 1540 3135G0V340 1,000,000 1,032,055 2.500 1.710 11/14/19 2/5/24 1,497 1,031,052 NC Aaa AA+ AAA
FHLMC 1514 3134GS6W0 1,000,000 1,000,000 2.700 2.700 3/27/19 3/27/24 1,548 1,001,940 1X Aaa AA+ AAA
FAMCA 1533 31422BGA2 1,000,000 1,022,900 2.150 1.634 10/18/19 6/5/24 1,618 1,020,810 NC Aaa AA+ AAA
FH LB 1535 3030AHERO 1,000,000 1,000,000 1.850 1.850 10/24/19 7/24/24 1,667 998,186 1C-NC Aaa AA+ AA+
UST 1546 9128282U3 1,000,000 1,008,789 1.875 1.660 12/11/19 8/31/24 1,705 1,008,750 NC Aaa AA+ AAA
FHLMC 1531 3134GUCE8 1,000,000 1,002,769 2.020 1.720 10/10/19 9/17/24 1,722 1,000,811 1C-NC Aaa AA+ AAA
FHLMC 1536 3134GU LS7 1,000,000 1,000,000 1.875 1.875 10/28/19 10/28/24 1,763 999,173 1C-NC Aaa AA+ AAA
FFCB 1538 3133EK6J0 1,000,000 994,700 1.625 1.736 11/8/19 11/8/24 1,774 993,059 NC Aaa AA+ AAA
Subtotal 49 64,184,000 63,574,135 Avg. 2.04% 64,359,509
LGIP LGIP NA 19,786,229 19,786,229 2.505 2.505 NA NA 1 19,786,229 NC
(Grand Totals $83,970,229 $83,360,364 2.14% 606 $84,145,738
Page 3 of 8 2019 Q4 TSO spreadsheet
City of Yakima
Investment Portfolio by Issuer at 12/31J2019
FHLB, 6,030,000, 7%
...................................................
US T, 5,000,000, 6%
......................................................
....................................................
.....................................................
....................................................
....................................................
...................................................
FHLMC, 10,000,000, 12/°
FAMCA, 3,000,000, 41°
ssssssssssssssssssssssssssssssssssss AA at
1 000 000 1%
B L, , 0,000, 1%
tattaits
MSFT, 1,a0a,0a0, 1°t°
USB, 1,a0a,0a0, 1°t°
WMT, 1,000,000, 1!°
FNMA, 11,010,a0a, 13°t°
Mies
16111111111111111,11111111,
LGIP 19 786 229 24l°
RFCSP, 11, IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIF
3111111111111,
129,�00, 131°
FFCB, 13,015,�00, 16%
Page 4 of 8 2019 04 TSO spreadsheet
Page 5 of 8
City of Yakima
Investment Portfolio Maturity Distribution at 12/31/2019
S6,000,000
Ss,000,000
$4,000,000
$3,000,000
S2,000,000
$1,000,000
5o
c 9 etc to,i'L° J�•�� �•ti� a'L� c� �•L% jti'1 vs::. .y'1 a-1% ct0' `iv ��'Y \17, ti'L a�yti c 3 `�y3 ��y3 ,tib ti3 a�y"� cyo `tio �ryo \,tip do Jtia
t1e tta ci +o p era 4.a vo d to �a ict tsa ° 4.9 too se tta s- ° 49 ao �a 1a tra p' SeQ �o
Page 5 of 8 2019 Q4 TSO spreadsheet
12
City of Yakima
Investment Portfolio-Detail of Activity
December 31,2019
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 Total 2,000,000 1,000,000 - 3,000,000
Federal Farm Credit Bureau
FFCB 1496 2,015,000 - - 2,015,000
FFCB 1498 3,000,000 - - 3,000,000
FFCB 1518 1,000,000 - - 1,000,000
FFCB 1519 1,000,000 - - 1,000,000
FFCB 1520 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 Total 10,015,000 3,000,000 - 13,015,000
Federal Home Loan Bank
FHLB 1492 2,030,000 - - 2,030,000
FHLB 1506 1,000,000 - (1,000,000) -
FHLB 1507 1,000,000 - - 1,000,000
FHLB 1509 1,000,000 - - 1,000,000
FHLB 1511 1,000,000 - (1,000,000) -
FHLB 1535 - 1,000,000 - 1,000,000
FHLB 1544 - 1,000,000 - 1,000,000
FHLB Total 6,030,000 2,000,000 (2,000,000) 6,030,000
Resolution Funding Corporation
RFCSP 1493 3,203,000 - - 3,203,000
RFCSP 1495 2,137,000 - - 2,137,000
RFCSP 1499 1,000,000 - - 1,000,000
RFCSP 1500 2,667,000 - - 2,667,000
RFCSP 1502 2,122,000 - - 2,122,000
RFCSP 1503 3,139,000 - (3,139,000) -
RFCSP 1505 2,160,000 - (2,160,000) -
RFCSP Total 16,428,000 - (5,299,000) 11,129,000
Federal Home Loan Mortgage Corporation
FHLMC 1510 1,000,000 - - 1,000,000
FHLMC 1514 1,000,000 - - 1,000,000
FHLMC 1517 1,000,000 - - 1,000,000
FHLMC 1524 1,000,000 - (1,000,000) -
FHLMC 1525 1,000,000 - (1,000,000) -
FHLMC 1528 - 1,000,000 - 1,000,000
FHLMC 1529 - 1,000,000 - 1,000,000
FHLMC 1530 - 1,000,000 - 1,000,000
FHLMC 1531 - 1,000,000 - 1,000,000
FHLMC 1532 - 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 7,000,000 (2,000,000) 10,000,000
Federal National Management Association
FNMA 1488 3,000,000 - - 3,000,000
FNMA 1490 2,000,000 - - 2,000,000
FNMA 1491 2,000,000 - - 2,000,000
FNMA 1494 2,010,000 - - 2,010,000
FNMA 1501 1,000,000 - (1,000,000) -
FNMA 1540 - 1,000,000 - 1,000,000
FNMA 1541 - 1,000,000 - 1,000,000
FNMA Total 10,010,000 2,000,000 (1,000,000) 11,010,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 1,000,000 4,000,000 - 5,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 55,483,000 19,000,000 (10,299,000) 64,184,000
Other Investments - - - -
LGIP(StatePool LGIP 20,690,499 9,095,730 (10,000,000) 19,786,229
Other Investment Totals 20,690,499 9,095,730 (10,000,000) 19,786,229
Grand Totals $76,173,499 $ 28,095,730 $(20,299,000) $83,970,229
Page 6 of 8 2019 Q4 TSO spreadsheet
City of Yakima
Long Term Debt Schedule-by Project Group
December 31,2019
Date Issued Maturity Description Note Amount of Issue Current Balance
General Obligation Bonds
5/8/2007 5/1/2026 PFD Convention Center III Partial refunding of 2002 issue $ 4,910,000 $ 2,990,000
8/28/2009 12/1/2032 PFD Capitol Theatre Build America Bonds(Taxable) 4,980,000 4,980,000
6/17/2003 12/1/2023 Sundome Expansion Deferred Interest-Maturity$25M 1,430,528 244,526
8/28/2008 12/1/2021 Fire Apparatus Ladder Truck 760,000 140,000
5/8/2007 5/1/2022 Fire Station Remodel Facility 815,000 205,000
5/8/2007 5/1/2022 Downtown Futures Renovate downtown improvements 1,490,000 375,000
6/20/2013 6/20/2028 Street Project Demonstration(Refunded) Various City street improvements 3,500,000 3,058,575
6/9/2014 6/1/2024 Street Resurfacing Project Streets improvements 13,140,000 7,345,000
6/17/2014 12/1/2034 Comm Center Move City portion of County GO Bonds 1,716,500 1,395,000
9/24/2018 12/1/2035 Soccer Complex(Refunded) City portion of SOZO Sports Complex 4,440,127 4,257,543
9/24/2018 7/1/2035 2018 Aquatic Center YMCA City portion of Aquatic Center 8,009,873 7,982,086
Subtotal General Obligation Bonds $ 45,192,028 $ 32,952,730
Certificate of Participation-State of Washington
6/1/2011 12/1/2020 Fire Apparatus Two trucks purchased $ 576,847 $ 67,268
3/19/2013 7/1/2023 Fire Apparatus One truck 310,414 142,196
9/28/2017 6/1/2027 Energy Project LED Street Lighting 921,863 784,893
9/28/2017 6/1/2027 Fire Aerial&Pump App Fire Aerial 1,268,053 1,079,856
Subtotal Certificates of Participation $ 3,077,178 $ 2,074,212
Revenue Bonds
5/31/2012 11/1/2023 Wastewater Refunded 2003$10,155,000 issue $ 9,400,000 $ 4,230,000
6/5/2008 11/1/2027 Wastewater Wastewater system 5,440,000 2,980,000
9/4/2004 9/1/2034 Irrigation Irrigation System 5,215,000 3,375,000
Subtotal Revenue Bonds $ 20,055,000 $ 10,385,000
Intergovernmental Loans
8/14/2009 7/1/2028 PC-08-951-052 2009 Railroad Grade Separation $ 3,000,000 $ 1,485,902
5/6/2010 6/1/2034 41000030-0 2010 Railroad Grade Separation 1,149,841 992,647
9/30/2015 6/1/2023 '15 Yak Co SIED-21st Ave/Airport 2015 Yakima Co SIED Loan-21st Ave/Airport 307,000 218,849
6/1/2016 6/1/2027 '16 Yak Co SIED-SOZO 2016 Yakima Co SIED Loan-SOZO 900,000 757,405
11/21/2017 6/1/2024 '17 Yak Co SIED-YV Brewing Project 2017 Yakima Co SIED Loan-YV Brewing Project 61,580 61,580
7/17/2018 6/1/2029 '18 Yak Co SIED-River Rd. 2018 Yakima Co SIED-River Rd Improvements/Aquatics Center 500,000 500,000
6/1/2001 7/1/2021 PW-01-691-071 2001 Fruitavale Neighborhood Sewer 1,466,250 155,250
9/1/2003 7/1/2023 PW-03-691-027 2003 Naches WTP Improvements 2,694,500 538,900
6/27/2005 10/1/2025 SRF-04-65104-037 2005 Naches River WTP Filter Rehab 966,772 282,436
12/30/2005 7/1/2025 PW-05-691-064 2005 River Road Sewer 2,307,000 745,475
4/30/2007 7/1/2027 PW-07-962-019 2007 Ultra Violet Disinfection 2,300,000 971,111
4/15/2009 7/1/2028 PC-08-951-051 2009 New Water Well 2,257,200 1,090,339
10/10/2011 3/31/2033 L1100008 2011 Energy Efficiency 503,558 388,852
8/1/2011 7/1/2034 41200019 2012 Industrial Waste Anaerobic 590,350 486,416
6/1/2012 6/1/2032 PC-12-951-065 2012 Wastewater Treatment Plan 5,000,000 3,228,950
10/11/2012 6/1/2037 PC-13-961-059 2012 Industrial Sewer Extensions 2,000,000 1,464,115
8/5/2013 7/1/2032 PC-13-961-074 2013 Automated Reading System 5,000,000 3,421,053
12/12/2013 10/1/2034 DM-11-952-038 2013 Design WTP Lagoons 3,514,800 2,636,100
Subtotal Intergovernmental Loans $ 34,518,851 $ 19,425,380
IlGrand Total $ 102,843,056 $ 64,637,322
Page 7 of 8 2019 D4 ISO spreadsheet
City of Yakima
Interfund Borrowing
December 31,2019
Original Beginning Ending
Description Balance Balance Issued Retired Balance
Local Improvement District Bonds/Notes $ 1,432,509 $ 37,288 $ - $ 11,354 $ 25,934 Equipment Rental Reserve
Fund 153- Public Safety Communications 450,000 300,000 - 150,000 150,000 Equipment Rental Reserve
Fund 323- Millsite Project - 500,000 - - 500,000 REET
Total across all funds 1,882,509 837,288 - 161,354 675,934
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 2019. The final payment$150,000 will be paid in
2020.
Fund 323- Millsite(LIFT)
The Millsite project borrowed$500,000 from REET until such time as official financing can be secured.At that time the loan from REET will be repaid.A Statement of
Official Intent for the reimbursement has been executed to meet bond requirements.
Page 8 of 8 2019 Q4 TSO spreadsheet