2021-03-16 CC Agenda Packet - ITEM #13 - PRESENTATION - Investment Portfolio ReportCITY OF
ELSEGUNDO
City of El Segundo
Investment Portfolio Report
December, 2020
Presented By:
City Treasurer's Office
March 16th5 2021
Portfolio Summar
December 31, 2020
0 540,000,000 $32,973,470
'ti '30,000,004
m
0,000,000
c° 510,000,ao $6,028,882
$84,383 $63,183
$40, 000,000 $32, 973,470
$30,000,000
$20, 000.0fl0
g10,000,00ff $6,0� $84,284 $63,183
$21,452,269
$Sa,a91,675 $8,109,518 $6,453,622
$1,785,800 �— — $1,246,04$
$1, 786, 900
.0 m '3
I SOO
iu 3.Oa%
v 2.aa%
•n 1.00 % 4
2396 0.49% 0.49% 0.413%
�— .f29n
40_00% 36.62%
r
m
20.00%
6.70%
o_OM6 0.09% 0.0795 1.98%
C
rc. a v d
is J O
a E r
E w
L
4] J C
LL
Q �
J LL
d
J
$10,416,570 $8,429,064
650
712
2.03 2.43%
%
$22,=,069
$6,679,114
�. . $1, 271, 775
962
724
362
2.68%
11.57°%
9.36°6
7.42°Ia
C
C
YI
O
z
C
p
m
o,
E
m
a
�
�
u
E
C
M
7
z.z
1.8195
24.78%
1.4I4�
•� L
N
h
a
0 d
a- R
L°M
w
R
�
C
n
4+
R
�
C
U
15
R
a+
�
LT
1/
R
�
R
CL
Interest Received
Transaction Date
Grand Total
Des€riptionl 05
$413, 681
$350.001,
$300, 00 C
Y
C
Q
iNTEREST
n
S s7w.u.
a
$166,089
'Minis0, 00
$100, 00
$80, 850
,M.O0-
so
avember December
There were no calls or maturities in calendar year 2020 Q4
$166,742
Compliance
Partial List of Al Iflwable Security Type Limits
Security Type
CAMP -JPAP
Cash
Government
%Maximum
30%
Nona
None
Compliance?
Y
Y
Y
0.09%
G-70%
11.57°Fo
LAIF-Immediate
Nona
Y
36.62%
LAIF-LAWA --
None
Y
0:07%
LAIF-SeniarHousing
None
Y
1-9B%
Mediurn Term Notes
Municipal Bonds
Negotiable Certificates of Deposit.
SupranationaiOhl igations
IS%
10%
W%
-0%
Y
Y
Y
y
F 9-W%
7.4 '0
F 2 .79%
1.41%
City of El Segundo - Treasury Department
Continuing Education Tracking - As of December 31, 2020
Requirement YTD Hours Excess/(Deficit) Notes
Treasurer
5.00
5.00
-
I CMTA/CDIAC Webinars
Deputy City Treasurer II
5.00
6.00
1.00
CMTA/GIOA/GFOA Webinars
Deputy City Treasurer I
5.00
15.00
10.00
CMTA/GIOA/GFOA + Webinars
Rating Compliance
December 31, 2020
Security Type
Issuer
S&PRatingl
Maximum%I %`Portfolio
MediumTerm Notes
AMAZON CDM INC
AA-
3%
j 0_577%
APPLE INC NT
AA+
3%
Q.582%
BANK OF NY MELLON
A
3%
I 0_558%
BEZKSHIREHATHAWAY
AA
3°5.58390
CATERPILLARFINCSVC
A
3%
I 0_572%
COCAL COLA CO S1Z NT
A+
Q.582%
ESTEE LAUDER COS INC
A+
_ :.
0 587%
JOHNS HOPKINS HLTH
AA-
_._
0.1G8%
NEW YDRK i I FIE 144A
AA+
_ :
0_571%
ORACLE'_-:
A
=._
0.564%
ORACLE ::==_=
A
=:.
0.561%
PACCARF1NLCC,�, :-
A+
3%
6.5GI%
TOYOTA MOTOR CR :3 =
A+
3%
I D.576%
UNITEDnAPCELSEPI. =
A-
3%
Q_58996
OVAL-M--=- _.- =Ev ;.:
AA
3%
I D.578%
E' -'_ _ 11 & CO
BBB+
3%
113296
Municipal Bonds
_W
C01', _ - -UT
A
I 12 D°c
CONP.=:- .'_TST
A
=
0_57596
GOO DR; C- -I AREA
AA
= :
I 0.350°{e
HOUSTON TES{
AA
= : _
1162%
LAQUINTA CADF REDS
AA-
595
I 1154%
LA vE::='C NEV
AA
=_
a_fi789n
NEW r;_:- l
AA
❑REC,ON = _=DTADMIN
AAA
TU-SA CNTY :-.+.LA INDP
N}A
= _
0.55_;=
Supranationai
iADBGLDBALMT
N/A
==:
C.55 94:
[Obligations
INTER-AMERiCANDEVEL
AAA
= _
.85:S z
nvestments by Security Type
Negotiable Certificates
$22, 311, 069
Municipal Boni
$6, 679,114
Mediu
$I
December 31, 2020
SupranationelObligations CAMP-JPAP Cash
$1,271,775 $84,284 %,028,882
$1,766,800
,diate
UO
Investments by Maturity date
December 31, 2020
$35,000,000
$32, 973, 470
$30,000.000
$25,000,000
$20,000,000
m
m
$15,000,000
$10,000.000
$6, D28, 882
°s5,600,000
$1,786,800
$U $63,183 $84,284
Cash &Cash LAIF- LAIF- Senior LAIF -LAWA CAMP -JPAP
Equivalents Immediate Housing
$3,978,327
$245,375 $736,833 0
t 30 Days 31to 90 Days 91ta 18o
Days
$11,269,714
$6, 517,731
$9,528,313
$16, 320, DS2
mmmm$51�
18itu365 Ito ZYears 2to3Years 3to4Years 4to5Years
Days
Reserve Portfolio Ladder by Quarter
December 31, 2020
_:-- 2022 2023
$20,000,00D
$18, 000,000
$15, 000,00G
$14. G00,000
$Z, 000.000
$10,600,00G
58. G00, 000
$G, G00.000
54, 000,000
$2,000.004 �
$G I ■
u7
N W
p- n
R Cl
LO
� N
M W
AA-
W lu [h !7
d d 0 cy 0
ZL d
LD
■
Quarter
�41
N Q2
Ln
� Q3
N m Q4
LD
W Total
C]
Ll"1
�
M1
Lh
10
Ql
P
wl
m
m
�
cri
N
a
m
sn
6
oT
m6
on
v
Ln
LD
m
ri
p
03'In
m
LD
N
d
N
C
to
N
[0
LO
M
Lr
�
00
6
Lr7
Oti
Ol
N
O
-64
CU
N
LYI
W SV
LV]
d d
d
d o
d
d
d
d
o d d
d
C7
0 _
-
r
Rolling 13-Month Cash Flow Analysis
$20,000.000
$18,000,O00
$16,00a,000
$14, 000.000
$23,76,
512,000,000
° $10,04'
a $10,000,000
58,000,000
56,000,000
$4,000.000
S2,000,O00
$4
December 2019
FLbruary2020 April 2020
$20,189, 644
$4,856,383
June 2020 August 2020 October 2020
Mo nth of Date
32,750
Decem ber 2020
Measure Names
Total Disbursements
Total Receipts
Rolling 1-3-Month Net Cash Flow Analysis
Date
S1a,000'mo
ss,DaD,Daa
$6,
S6,DOO,DDff
$4,000.090 �4,
$2.000,000
$o
r
a ($4A00,000)
(96,000,{}00)
($ S,OOO,SI DO)
($1(3,O00,000)
($12,000,400)
(514,OOV,O DO)
($16,000,0 DO)
$9,692,177
S, 617
�7, 977
($15,333,4G1)
January February March April May June July August September October November DeEember
Year of Date
2012
M 2019
■ 2020
CITY OF
ELSEGUNDO
LAI F
m
v
a
Li F Diagnostics
2 D Measure Names
Average Maturity
Daily
Quarterto Date
3-5
230
cC
_ Mar l Apr:. May l Jun l Jul l Aug 1 Sep 1 Oct 1 Nov i Dec l Jan 1
Bate [ZD201
w
C
L
E 7
P_
C
C
a
LAi F Apportionment Rates
1979 3984 1989 1994 1999 2004 2GG9 2014
Bate
LAIF Details
Commercial Paper Loans
9.24% G.64%
Tirr
[ertlficates of
Deposit}Plank Notes
1439%
Ag
U
Treasuries
54.17%
CITY OF
ELSEGUNDO
Economic Environment
Q.J.S. Treasurer field Curve
0.360D
0.35
0.3G
0.25
u 0.20
m
a
0.15
0.1G
ME
G.10 G
0_0300 0.0300
6 Nl _
• We are starting to seethe curve steepen for maturities > 3 yrs
Day of Date
June 30, 202D
September 30,2020
December3l, 2D20
2.GOo2_620 _ ___
2.5
2.0
'.5
1.D
0.5
0.0
U.S. Treasury field Curve
0.02D0.020
Dec 1.18 M5,1.19 un1.1'' _.13 Dec 1.15 Mar 1.20 Jun-1.'_0 SeD1.2D Dec2.20 Mar%??
Date
• Both the 3yr and 5yr rates have nearly doubled since the beginning of the year
Measure Names
M.
2 Mo
3 M.
6 Mo
1 Yr
3 Yr
S Yr
a
10-Year Minus 3-Month Treasury Yield Spread
1985 1990 1995 2000 2005 2Qi0 2015 2020
Date
9J
Unemployment vs Inflation
2003 2005 20G7 20G9 2011 ?r-3 2015 23"r 2019 2021
❑ate
Measure Names
Realized Inflation
Unemployment Rate
5-Year Breakeven Inflation Prediction
2004 2406 2908 2010 2012 2014 2016 2418 2020
Dete
CITY OF
ELSEGUNDO
Survey of Options
_4
Latest Offerings
8
°
0
00 020
L
o° 00 00 a0
0.7 ° Do ❑ 0
0 0
0
r
°
°
00
C. 9 0
°
❑ 0
a'
00 CD '00
�4 °
c 6
DD ❑ ..
C
D°
o D °
0 D 0 °
p O
00 00
LAW
000 0 0 0
0
4 00
D p D �
N
°
® ° o
° 0°00
�
s°
o
o a
0 08° o
0 a
G-� D � 0
R D
0 cD 000
D$ 0
CD 0
0
0 ° d7°
o®
� aD 0
°
c-a p ° 00
G-0
3.5
Effective Duration
0
®❑
Category
D C6
Corp
GSE
LA'.F
SuRra
D Taxable Muni
D
0
I
Non -Callable offerings
-.3
C
C.9
a
a
G.9
°
E
°
a(P a
°a
°a
C-6
a
a
a
4
0.s
00
w
LAW
a o
a a
0.4 a
S a
¢4 a
a
a
G.3 p
p
p
O °
O
°
a
p a
0
o
0.2
(iD
00
<ID
°
°
° 1
°� a
a
c.z 0 a °
a cD
a
((M,,>
G.6 a a a®
Effective Duration
Category
CD
Corp
GSE
LA'.E
Supra
Now vs Beginning of 2021
-.3
1.1
1.6
G.4 ❑ ❑
0
G.S ❑
0 0 ( 0
} G.7
0° 06 0
a 0 ❑
Gs ❑ 0 p (UO
0 0 0 0 0
04 0 00 0 d
0 $o 0 0
a H �y� 8
G.3 p 0 0 ❑ ❑�
0 0❑ $0 ® o ❑o
D.2 0 00 ° ❑
❑ 0 0 cam ° $ 00 0 boa)
❑ 4
G.6 d dD
00 G_5 -0 5 5 3.5 4.0 -15 y.0
Effective Duration
Month, Day, Year of Date
January i, 2021
March 15. 2021