Attachment 1 - Investment ReportTown of Los Gatos
Summary Investment Information
June 30, 2019
Weighted Average YTM Portfolio Yield: 2.05% Weighted Average Maturity (days) 244
This Month Last Month One year ago
Portfolio Balance $72,013,634 $70,576,201 $76,649,992
Benchmarks/ References:
Town's Average Yield
LAIF Yield for month
3 mo. Treasury
6 mo. Treasury
2 yr. Treasury
5 yr. Treasury (most recent)
10 Yr. Treasury
2 - 3 years
25%
2.05%
2.43%
2.09%
2.10%
1.76%
1.77%
2.01%
3 - 5 years
15%
2.08%
2.45%
2.34%
2.35%
1.92%
1.91%
2.13%
Portfolio Maturity Profile
1.73%
1.85%
1.92%
2.11%
2.54%
2.74%
2.86%
0 - 1 year
30%
Compliance: The Town's investments are in compliance with the Town's investment policy dated May 15, 2018
and also in compliance with the requirements of Section 53601 of the California State Code. Based on the information available, the Town has
sufficient funds to meet the cash demands for the next six months.
Page 1
ATTACHMENT 1
Town of Los Gatos
Portfolio Allocation & Treasurer's Fund Balances
June 30, 2019
Month YTD
Fund Balances - Beginning of Month/Period $70,576,200.92 $76,649,992.26
Receipts 6,343,273.29 50,261,550.12
Disbursements (4,905,840.44) (54,897,908.61)
Fund Balances - End of Month/Period $72,013,633.77 $72,013,633.77
Portfolio Allocation: % of Portfolio Max. % 0r $ Allowed Per State Law or Policy
BNY MM $29,757.04 0.05% 20% of Town Portfolio
US Treasury Notes $7,660,761.72 13.07% No Max. on US Treasuries
Government Agency Debenture Notes $29,788,231.38 50.82% No Max. on Non -Mortgage Backed
Corporate Medium Term Bonds $14,712,046.50 25.10% 30%ofTown Portfolio
Local Agency Investment Fund 6,425,281.07 10.96% $65M per State Law
Subtotal - Investments 58,616,077.71 100.00%
Reconciled Demand Deposit Balances 13,397,556.06
Total Treasurer's Fund $72,013,633.77
Portfolio Investment Allocation
Local Agency Investment Fund BNY MM
11.0% 0.05%
Corporate Medium Term Bonds
25.1%
US Treasury Notes
13.07%
Government Agency Debenture Notes
50.82%
AOC Dig
70000060
86DDi3DUii
6dQ0.7SC...1
c2 �: Dig
600000.00
Jun-18
JuI-18
Aug-1.8
Sep-18
Treasurer's Fund Balances
Oct-18
Nov-18
Dec-1.8 Jan-19
Feb-19
Mar-19 Apr-19 May-19 Jan-i9
page 2
Town of Los Gatos
Non -Treasury Restricted Fund Balances
June 30, 2019
JUNE 19 JUNE 19 JUNE 19
Previous Deposits Ending
Balance Realized Gain/Ad!. Interest Withdrawals Balance
Non -Treasury Funds:
Cert. of Participation 2002 Series A Reserve Fund $ 687,325.31 $ 1,083.51 $ - $ - $ 688,408.82 Note 1
Cert. Of Participation 2010 Ser A Lease Pymt Fund 90.86 41,999.87 (0.26) 42,090.99 Note 1
Cert. of Participation 2002 Lease Payment Fund 5,222.52 2.38 5,224.90 Note 1
Cert. of Participation 2010 Series Reserve Fund 1,319,062.37 2,529.18 0.00 41,999.87 1,279,591.68 Note2
Total Restricted Funds: $ 2,011,701.06 $45,612.56 $2.38 $41,999.61 $2,015,316.39
These accounts are not part of the Treasurer's fund balances reported elsewhere in this report, as they are for separate and distinct
entities.
Note 1: The three original funds for the Certificates of Participation 2002 Series A consist of construction funds which will be expended over the
next few years, reserve funds which will guarantee the payment of lease payments, and a third fund for the disbursement of lease payments
and initial delivery costs.
Note 2: The 2010 COP Funds are all for the Library construction, reserves to guarantee lease payments, and a lease payment fund for the
life of the COP issue. The COI fund was closed in September 2010.
Page 3
Town of Los Gatos
Statement of Interest Earned
June 30, 2019
Interest by Month
July 2018
August 2018
September 2018
October 2018
November 2018
December 2018
January 2019
February 2019
March 2019
April 2019
May 2019
June 2019
$84,433.16
87,305.09
86,525.12
93,667.82
93,016.61
96,247.20
97,652.37
88,226.40
98,981.09
98,858.10
95,684.33
102,543.09
$1,123,140.38
Page 4
Town of Los Gatos Investment Schedule June 2019
858988
a82929P28, 8.[4$ 8$4.. mc-a8m�9a99og,89989 a
ry O O m 0 0 0 0 m O O m m 0 .y m O m 7J O O m O m m 22
0 0 0 0 0 0' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
888888888888888888888888848888<8888888888888
CAPWAPA$ W"7.oS
88888888888882888884888888888888888898888888
FC2A
8, mom 8 m 8 N c c c g e o e v .^o; o e m o 0 o m o8"
U 161,039.60 $
88888888888888888888888888888888888888888888
............................................ .
888888888888888888s888888888888888888$8§§§88
gs
mgg§§§§§§ oosgag§§§8 88soAass§ W§ §§§PA
44
o�se ���oo
;oi i� iioomeei iiii i
tZm ZZ�SS t6— 6mg22'tmmm> m'
a a a o a a i a 8 o d o "1 1 1 l t I l o d d a!!› ?4 g e o a
u° ci c� » u u° c� u° � n M3 ,2 8 ,5 (3 w ,, ,, w o ,20R.� � u' » u° em u° u°
gAMMUM
88888888888
8888888888888
8888888888888
ggggggoaggg
j l§ O L7 tO L) O O u O O u O
Maturity Profile
RERE
Town of Los Gatos Investment Schedule June 2019
Market to Cost Position Report
E
Weighted Average YTM Portfolio Yield:
Portfolio Balance
Benchmarks/ References:
Town's Average Yield
LAIF Yield for month
3 mo. Treasury
6 mo. Treasury
2 yr. Treasury
5 yr. Treasury (most recent)
10 Yr. Treasury
This Month
$70,576,201
2.08%
2.45%
2.34%
2.35%
1.92%
1.91%
2.13%
Town of Los Gatos
Summary Investment Information
May 31, 2019
2.08% Weighted Average Maturity (days) 236
Last Month One year ago
$69,831,987 $76,817,429
2.04%
2.45%
2.42%
2.45%
2.27%
2.28%
2.50%
Portfolio Maturity Profile
2 - 3 years
25%
1.71%
1.76%
1.90%
2.08%
2.43%
2.70%
2.86%
Compliance: The Town's investments are in compliance with the Town's investment policy dated May 15, 2018
and also in compliance with the requirements of Section 53601 of the California State Code. Based on the information available, the Town has
sufficient funds to meet the cash demands for the next six months.
Page 1
Town of Los Gatos
Portfolio Allocation & Treasurer's Fund Balances
May 31, 2019
Month YTD
Fund Balances - Beginning of Month/Period $69,831,986.81 $76,649,992.26
Receipts 4,487,507.03 43,918,276.83
Disbursements (3,743,292.92) (49,992,068.17)
Fund Balances - End of Month/Period $70,576,200.92 $70,576,200.92
Portfolio Allocation: % of Portfolio Max. % Or $ Allowed Per State Law or Policy
BNY MM $60,654.97 0.10% 20% of Town Portfolio
US Treasury Notes $7,660,761.72 13.08% No Max. on US Treasuries
Government Agency Debenture Notes $29,697,268.38 50.72% No Max. on Non -Mortgage Backed
Corporate Medium Term Bonds $14,712,046.50 25.12% 30%ofTown Portfolio
Local Agency Investment Fund 6,425,281.07 10.97% $65M per State Law
Subtotal - Investments 58,556,012.64 100.00%
Reconciled Demand Deposit Balances 12,020,188.28
Total Treasurer's Fund $70,576,200.92
Portfolio Investment Allocation
Local Agency Investment Fund BNY MM
11.0% 0.10%
Corporate Medium Term Bonds
25.1%
US Treasury Notes
13.08%
Government Agency Debenture Notes
50.72%
8C000030
78000000
7E000000
74000000
72000000
70000000
CS000000
86000000
6A030000
62000000
5000000
May-18
Jun-18
Jul-18
Auk-18
Treasurer's -Fund -Balances
Sep-18
Oct-18
N:v-18
Dec-18
Jan-19 Feb-19
Mar-19 Apr19 May-19
page 2
Town of Los Gatos
Non -Treasury Restricted Fund Balances
May 31, 2019
MAY 19 MAY 19 MAY 19
Previous Deposits Ending
Balance Realized Gain/Adj. Interest Withdrawals Balance
Non -Treasury Funds:
Cert. of Participation 2002 Series A Reserve Fund $ 691,406.31 $ 1,074.31 $ 5,155.31 $ 687,325.31 Note 1
Cert. Of Participation 2010 Ser A Lease Pymt Fund 90.61 0.25 90.86 Note 1
Cert. of Participation 2002 Lease Payment Fund 67.17 5,155.31 0.04 5,222.52 Note1
Cert. of Participation 2010 Series Reserve Fund 1,316,606.07 2,456.30 1,319,062.37 Note z
Total Restricted Funds: $ 2,008,170.16 $5,155.31 $3,530.90 $5,155.31 $2,011,701.06
These accounts are not part of the Treasurer's fund balances reported elsewhere in this report, as they are for separate and distinct
entities.
Note 1: The three original funds for the Certificates of Participation 2002 Series A consist of construction funds which will be expended over the
next few years, reserve funds which will guarantee the payment of lease payments, and a third fund for the disbursement of lease payments
and initial delivery costs.
Note 2: The 2010 COP Funds are all for the Library construction, reserves to guarantee lease payments, and a lease payment fund for the
life of the COP issue. The COI fund was closed in September 2010.
Page 3
Town of Los Gatos Investment Schedule May 2019
,• 8„7,n m5 88 °'" n.,. nnnn.,.,mnme. F8annmg8888 9
113
d �
n8W“,omenamm33,70 aao'nme4A,T01mooem m$ao8.'73888
m UOMR �e e E FAIo�u.0 I E.ri e m ry w.m,.n`a
5 m
°S8
4 gi e g n .. m n n n n
�8� 8888 8"8888S8� 88. 88m 889 o8m88
o o p o 8 m m m 8 0 m m o m m o e$ m uNj1i 8 v
nrvmrvn� m mnm rvnry m nmmmrva m—"ivnn°a m ammmmamnmmmm
4Ati44444,4,444V,H4444,H w �� H ,HHH HHH HHwHH tih Mti�
e �° �° X�a'ti eE I've veX��`R �' a Xa'eC e¢2E eFe se e¢eP e¢;E ee��°a°a° o¢ eF d° of eF o�pf LF ��
n 9 .n, V9I m 8 8 l 9 a m 8 m m n 8 v8i 8 m m 8 8 v V 8 8 8 8 mm m o ma.+m �nm Qom min n m mm
o a o 0 o a o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
8
8a88888888888888888888888t28888,138888888H HA
88880E 88 " 88m8` 88888.me
s>I goeo8° �m8a88 mm p affsIp, !ppi8 ...,
o`
31
a II
888
88A88888
8888858828`n8`88888°8888888888°8888,3°.8m8888e88588B
� 88 888 mm m8m 888 �88m
441.
52,070,076.60 $
88888888888888888888888888888888888888888888
'88888888888888888888888888888888888888888
888888g8888888888888888888888888888888888888
o c a o
88°8888888888988888888888$888888888888888888
ry x n ,4.4.4.4
•� � oe o o'm"eoryoo 0 0 0 0 0 0 .'�, ,'�• .�, •'�, �
0 c N m ., m` m m n g g m m c a m` o '�„ n` n`` m m n m a a\ m .o m m
gl
w z
0 0 'c '_ o 0 0 '=di77 o z
m a c
zhezggxzegg r > n `
m eP eE ;e d2 de ems' X X ! e
0 0 0 0 0 o ry o
8888828
8A0
8aee8884
88888888888
8888.8g88ga88
scgg$8g88§H
a¢¢¢ a o¢ a o` °� w
> �
0 LLH u 0 0 u 0 3 U
Town of Los Gatos Investment Schedule May 2019
Market to Cost Position Report
tg
Town of Los Gatos
Summary Investment Information
April 30, 2019
Weighted Average YTM Portfolio Yield: 2.04% Weighted Average Maturity (days) 245
This Month Last Month One year ago
Portfolio Balance $69,831,987 $66,777,438 $77,476,376
Benchmarks/ References:
Town's Average Yield
LAIF Yield for month
3 mo. Treasury
6 mo. Treasury
2 yr. Treasury
5 yr. Treasury (most recent)
10 Yr. Treasury
2.04%
2.45%
2.42%
2.45%
2.27%
2.28%
2.50%
2 - 3 years
25%
3 5 years
15%
2.00%
2.43%
2.39%
2.43%
2.26%
2.23%
2.41%
Portfolio Maturity Profile
1.65%
1.66%
1.80%
2.01%
2.49%
2.80%
2.95%
30%
0 - 1 year
,30%
Compliance: The Town's investments are in compliance with the Town's investment policy dated May 15, 2018
and also in compliance with the requirements of Section 53601 of the California State Code. Based on the information available, the Town has
sufficient funds to meet the cash demands for the next six months.
Page 1
Town of Los Gatos
Portfolio Allocation & Treasurer's Fund Balances
April 30, 2019
Month YTD
Fund Balances - Beginning of Month/Period $66,777,437.99 $76,649,992.26
Receipts 6,584,461.05 39,430,769.80
Disbursements (3,529,912.23) (46,248,775.251
Fund Balances - End of Month/Period $69,831,986.81 $69,831,986.81
Portfolio Allocation: % of Portfolio Max. % Or $ Allowed Per State Law or Policy
BNY MM $163,637.78 0.28% 20% of Town Portfolio
US Treasury Notes $7,660,761.72 13.09% No Max. on US Treasuries
Government Agency Debenture Notes $29,697,268.38 50.76% No Max. on Non -Mortgage Backed
Corporate Medium Term Bonds $14,563,697.00 24.89% 30% of Town Portfolio
Local Agency Investment Fund 6,425,281.07 10.98% $65M per State Law
Subtotal - Investments 58,510,645.95 100.00%
Reconciled Demand Deposit Balances 11,321,340.86
Total Treasurer's Fund $69,831,986.81
Portfolio Investment Allocation
Local Agency Investment Fund BNY MM
11.0% 0.28%
Corporate Medium Term Bonds
24.9%
US Treasury Notes
13.09%
Government Agency Debenture Notes
50.76%
-...Treasurer's Fund Balances
A c•r-SE N'ay-]c l;,n..15 Ju:-1$ Aug-1S Sep•IS Oct-].B ^: r_.d-•� r.c�. :S i ,.
page 2
Town of Los Gatos
Non -Treasury Restricted Fund Balances
April 30, 2019
APR 19 APR 19 APR 19
Previous Deposits Ending
Balance Realized Gain/Adj. Interest Withdrawals Balance
Non -Treasury Funds:
Cert. of Participation 2002 Series A Reserve Fund $ 690,311.04
Cert. Of Participation 2010 Ser A Lease Pymt Fund 90.35
Cert. of Participation 2002 Lease Payment Fund 67.12
Cert. of Participation 2010 Series Reserve Fund 1,314,071.16
$ 1,095.27 $ 691,406.31 Note 1
0.26 90.61 Note].
0.05 67.17 Note 1
2,534.91 1,316,606.07 Note2
Total Restricted Funds: $ 2,004,539.67
$0.00 $3,630.49 $0.00 $2,008,170.16
These accounts are not part of the Treasurer's fund balances reported elsewhere in this report, as they are for separate and distinct
entities.
Note 1: The three original funds for the Certificates of Participation 2002 Series A consist of construction funds which will be expended over the
next few years, reserve funds which will guarantee the payment of lease payments, and a third fund for the disbursement of lease payments
and initial delivery costs.
Note 2: The 2010 COP Funds are all for the Library construction, reserves to guarantee lease payments, and a lease payment fund for the
life of the COP issue. The COI fund was closed in September 2010.
Page 3
Town of Los Gatos
Statement of Interest Earned
April 30, 2019
Interest by Month
July 2018
August 2018
September 2018
October 2018
November 2018
December 2018
January 2019
February 2019
March 2019
April 2019
May 2019
June 2019
$84,433.16
87,305.09
86,525.12
93,667.82
93,016.61
96,247.20
97,652.37
88,226.40
98,981.09
98,858.10
$924,912.96
Page 4
8
8
111111111111
888888888888
0 o a o o.
888888888888
8888880888<8
00`,6'$0000��
8 i8888888888
'8t',4NB`dN2n8
wgggggleggg
N$N N8
08N88Mt.INM.1
014,014,4,01-1,
oS�
o�w
o� m 58..�
3d
D �
� m
56'sv9'azs'es$
r] v
Ll C C S L1 C S L1 Ll 41 � � LI G C Ll Ll n o Ll GI G1 L1 N L1 H � Ll C L1 Gl C Gl 41 C L] � 0
°°< d a y a d v d! I d d>>: 's
o° ° ° o o° 0 0 o v o
z m m
§gooss osssos ooso M goo§sss§s§§§:§ s�soN�s
5. 888o8o8S88888888888808 8888888 W 888$888888
8 88888888888888888888888888888888888888888888
0['LZL'TZ6'SS
8
NP
0
oee ee ISw
^^ 'B FniS88tieWSP oompSPAWMM' o 8Mo -
8888$88V8888888888088888N888;;18�88818m8888888
ee
N�uNBnm:°rWffiw 4081°
08> 8'6$S'�$om mew
888888�888888888888888888SS888888888888888N8
aeaeaaa:acaeaeaeK'*'a' a' X *XX gegaa*gga� ,g
nrg n°° w a8..m w88a'o
tiw$��m>$�_C8888 _ �ti 8888w888858mww�w;8c� _
e8ew�$
w o$ to m 8 w w .8. 8 w w O
wgw wu
�n mm�mtiLobs-temmo$.
UJ
m a N
8888$8N85 58�w
-.. v���m p wN.,�w�.nmoo 00.• o woa�c�w$rO1.. n, n,m w.�e.n n �n�w.'.� e o goti
p4
I S
Town of Los Gatos Investment Schedule April 2019
VI
-0
ert
ON
Town of Los Gatos Investment Schedule April 2019