Attachment 1Town oI los Gatos
Summary lnvestment lnformation
.lune 30, 2017
weighted Average YTM Portfolio Yield:
Last Month
57s,337,9ss
One vear ato
s74,913,935Portfolio 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
weighted Average Maturitv (davs) 3a7
0.78v"
0.30%
0.01%
0.rL%
0.u%
1.65%
7.47%
1.25%
This Month
s75.983,998
1.25%
o.gav"
t.o1v"
t.L3%
1.38%
1.89%
2.3t%
7.21%
o.93%
0.97%
1.07%
1.28%
1.75%
2.20%
3 '5 yea6
15J( _0'1yeer
30%
2'3years
25%
1- 2 ye..s
30%
Complirnce: The Town's investnents are in compliance with the Town's investment policy dated November l, 2016
and also in compliance with the requirements ofsection 5160I ofthe Califomia State Code. Based on rhe information available, rheTown has
sufficient funds to meet the cash demands for the next six months.
Portlolio Maturity Profi le
Page l
ATTACHMENT 1
Town of Los Gatos
Portfollo Allocation & Irearu.er's Fund Balances
lune 30, 2017
YTD
Fund Salances - Bednning of Month/Period
Receipts
Disbursements
Fund Salances - End of Month/Period
Portfolio Allocation:
TotalTrea5urer's fund
574,913,936.39
M,8/8,081.r2
l.43.77a,025.191
s7s,983,998.32
BNY MM
US Govt Agencies & Corp. Bonds
Local Agency lnveslment Fund
Subtotal- lnvestments
Reconciled Demand Deposit Balances
s141,783.95
s0,655,735.82
6.2L3,an 36
sl ,0t1,391 .L4
18.972.601.18
Ponfolio lnv8tment Allocation
8NY MM
Loc.l At.n.y lnEstm.nl Fund O-25X
10 9096
s75,983,998.32
Treasurer's Fund Ealances
76,@0,0@
74,@0,000
72,@0,0@
70,0@,0@
6a,mo,ooo
65,00o,0o0
64,000,000
62,000,0@
50_@o.0@
paSe 2
Month
s75,337,9s4.97
5,850,472.92
15,20/.,429.571
s75,983,998.32
US 6ovt Age..a€r & Co.p. Bonds
aa.a5*
i+i.A-j,ri^.iri:<i3d93:XS"*9:
ATTACHMENT 1
To*n ot lor G.roi
tlon-TreasuryRaatrlded Fund B.lance6
lun.3O,2017
luNf 17
Preou3 DcF3its
&b!!! Realtedc.inlAdi.
luNt 17
Etgs!
luitt 17
W[hd..mlt &!qsc
cert. of Parti.rp.tao. 2@2 series A ReseN. aund
Ce.t. OfPani.ipaton 2002 ser A teare Pymt Fund
Cert of Particip.tion 2@2 se.ier a Con3t. tund
COP 2010 Library R8eru. alnd
Tot.l Restricted Fu.ds:
645,426.14
24.76
0.58
t,2w,24D.r7
5
0.00
175.14
0.m
123.80 5
0.oo
0.@
675.91
175.14 t 6E6,374.80
0.(D 24.76
0.@ 115.12
o.@ 1,2E09!6.54
s
t!:94::.!l s175.14 s799.71 su5.14 s1.957,495.96
Theseaccount5a.enotpa.toftheTreasu,er'rfundbalancerrepo.t.dehsh€reinthisieport,a5theva,eforseparate.nddirtinct
ot€ t The thre. ongrhal fu.dr for th€ C.rtdi..tes of Particip.tion 2002 s.ries A @.rist ot .onttrucnon fu.ds which will b. .rp.nded o*r th.
.ext fry yeart, r.r!N. fu.ds wnich will guarantee the paym€nt ot 1.a5. payme.ts, .nd a thrd fund for the disbuEenent ot lease parments
and initial deliv.ry costl.
l{ote 2: Ihe 2010 COP fonds are all for the Library .onshuctio., reserves to guaEnte le.se pavments, and a leas. paym.nt fu.d for the
life of the COP rttue. ihe COI fund wa5 tloted an september 2010
ATTACHMENT 1
Town oI los Gatos
Statement of lnterest Earned
June 30, 2017
July 2016
Au8ust 2016
Septemb€r 2016
October 2016
November 2016
December 2016
January 2017
February 2017
March 2017
April2077
May 2017
June 2017
540,143.04
47,290.94
39,945.53
40,937.76
41,t54.77
42,859.62
43,069.29
39,24197
43,826-01
46,70t_89
50,861.75
49,254.67
s579,137.23
Page 4
lnterest bv Month
ATTACHMENT 1
To\r'n of Los Catos
ln\estment Schedule
.lxne 30- 2017
s
5tII
5
5
5
s
s
tI
t
t
st
It
5
5
I
5
s
9
5
9
st
s
s
sI
t
9
s
5t
It
tt
!
9
5
J
s
5 31s,9r427 S .37,n3o t .21,s7er5 50,555,731 32 9 0,7r5e S e,.$,21105 5 21,!e.70
5 3$5r.27 9 47,n36e 5 4rr,2m.et
-----11!!.1].1!!g s F1r2o1ra s 7rr,5r2 32 5 5r$37r1
Page 5 ATTACHMENT 1
weighted Average YTM Portfolio Yield:
This Month
s75,337,9ss
L.27%
Last Month
s75,20s,s09
Town of Los Gatos
Summary lnvestment lnformation
May 31, 2017
One vear ago
S73,ss8,s66
weighted Average Maturity (days) 393
Portfolio Balance
Benchmarks/ Reterences:
Town's Average Yield
LAlt Yield for month
3 mo. Treasury
6 mo. Treasury
2 yr. Treasury
5 yr. Treasury (most recent)
10 Yr. Treasury
o.7ay"
O.23lo
O.03/o
0.74%
o.56%
737%
1.85%
7.20%
0.88%
o.a0%
o.97%
7.26%
7.at%
2.2A%
Portfolio Maturity Profile
12v,
30v"
2 3years
25%
30%
Compliance: The Town's investments are in compliance with the Town's investment policy dated November l, 2016
and also in compliance with the requirements ofsection 53601 ofthe Califomia State Code. Based on the information available, the Tott'n has
sufficient funds !o meet the cash demands for the next six months.
Page I
t27%
0.93%
0.97%
7.07%
7.24%
7.75%
2.20%
ATTACHMENT 1
Town ol los Gatos
Port olio Allocation & Treasurer's Fund Balances
May 31,2017
Month
s76,20s,s08.s4
1,988,654.32
{2,856.207.89)
s75,337,954.97
YTD
Fund Balances - Beginning of Month/Period
Receipts
Disbursements
Fund Balances - End of Month/Period
s74,913,936.39
34,997,6t4.20
(38.s73.s9s.62)
575,337,954.97
TotalTreasurer's Fund
BNY MM
US Govt Agencies & Co.p. Bonds
Local Agency Investment Fund
Subtotal- lnvestments
Reconciled Demand Deposit Balances
S84,1s4.34
44,651,U9.57
4.213,a77.36
s2,955 ,081.21
22.342.473 .t0
Portlolio lnvestment Allocation
SNY MM
Lo6l Agency lnvgtment Fund O.t6%
7.96%
iis,337,9s4.91
US 6ovt Agencies & Corp. Bonds
91.84%
Treasurer's Fund Balances
l
page 2
Portfolio Allocation:
76,@0,000
74,000,0@
12,@O,ON
70,m0,000
64,@0,000
66,000,000
64,000,000
62,@0,OOO
60,000,000
I
ATTACHMENT 1
Town ot tot Gatos
l'aon-Ireasury Restrlcted fund B.l.nc!s
Mtt !1,2017
9!E!!c Realized G.in/Adi.Elsrg!B!b!!9withdrawalt
Cert. ofParticipation 2002 Series A Reseryefund
Cert. Of Participation 2002 Ser A Lease Pymt,und
cert. ofParti.ipation 2002 series A const. ru.d
COP 2010 Librery Resetue fu.d
Total R.strided Funds:
686,324.50
24.76
0.s8
o.00
0.00
101.64 s
0.m
0_00
0.00
0.00
s 585,426.14
24.16
o.58
ss
1,279,657.39 0.m 5$38 0.00 1,280,240.7791ryI $9:99 sry so.oo s1!9q.q9!?!
These accountr rr€ not p.rtoftheTreasur.r's fthd b.lances reported elsshere in thir report, as theyareforsepaEte and distin<t
Note t The three origi.alfunds for the Certillcates ofPanicipahon 2002 Seri€s A consitt of construction fundtwhich willbe expended over the
next few years, reteNe funds which willgua.anteethe paymentofleate payhentsi and a thnd fu.d for the ditbu.sementof lease payments
and initial delivery @sts.
tlote 2: The 2010 COP Funds are allfor the tibrary construction, res.rvs to guarantee lease paymentsi .nd . lease paymentfund for the
lifeoftheCOPistue. The COI fund was clo5ed in september2010.
ATTACHMENT 1
Town of Los Gatos
Statement of lnterest Earned
May 37,2OL7
lnterest bv Month
July 2016
August 2016
September 2016
October 2016
November 2016
December 2016
Ja^uary 2Ol7
February 2017
March 2017
April 2017
May 2077
June 2017
s40,143.04
47,290.94
39,945.53
40,937.76
47,754.71
42,859.62
43,069.29
39,24t.97
43,a26.0t
46,70t.89
50,867.76
5470,07a.56
PaSe 4
ATTACHMENT 1
Town of Los Cetos
Investment Schedule
M '31.2017
s
5
s
9
s
5I
5
5
5
I
s
5
5
s
5
5
ffi I 77r.101 15 9 4qS@sO 9 333 6e a3
I 777,01rs I .q!Og ra 9 1u,27.75
- r1!.!914!l's 1,257,3s 13 5 7e,sr2 r? 9 !70,q3 !€
t:?t::!!!z
P!8.5 ATTACHMENT 1
Weighted Average YTM Portfolio Yield:
This Month
Portfolio Balance
One Year ago
s73,389,66s
o.7a%
0.23%
0.03%
0.14v"
0.56%
L.87%
Porttolio Maturity Profile
Weighted Average Maturity (days) 390t.20%
Last Month
s76,20s,509 572,979,6s6
Benchmarks/ References:
Town's Average Yield
LAlF Yield for month
3 mo. Treasury
6 mo- Treasury
2 yr. Treasury
5 yr. Treasury (most recent)
10 Yr. Treasury
1.20%
o.8a%
0.80%
o.97%
1.26%
1.8t%
2.28%
0.98v"
0.82%
0.75%
0.90%
1.26%
1.92%
2.39%
3 5ye.6
0 l year- .30%
3V/"
Compliance: The Town's in\estments arc in compliance with the Town's investment policy dated November I , 20l6
and also in compliance with the requirements ofSection 53601 ofthe California State Code. Based on the information available. the Town has
sumcient funds to meet the cash demands for the next six months.
Page I
Town of Los Gatos
Summary lnvestment lnformation
April 30, 2017
2 -3 years
25%
ATTACHMENT 1
Fund Salances - Beginning of Month/Perlod
Receipts
Disbursement5
Fund Balances - End of Month/Period
Ma tt
572,979,655.66
5,996,415.27
12,110,s62.39t
574,913,936.39
37,m8,959.88
i.35,717 3a7.731
s76.205.508.54
YTD
Portfolio Allocation:
TotalTreasurer's Fund
BNY MM
US Govt Agencies & Corp. Bonds
local Agency lnvestment Fund
Subtotal - lnvestments
Reconciled Demand Deposit Balances
S40,104.68
44,666,23L.92
4.213.877.36
52,920,213.96
23,285.294.58
576,205,508.54
s75,20S,508.54
Us c@t Age..i8 & Corp. Bond5
9t 96%
Porttolio lnvestment Allocation
BNY MM
Locll Agency lnvertd.nt Fund O.Oa%
7.96,6
Treasurer's Fund Ealances
76,@O,OO
74,0@,CIOO
72,000,0@
70,@0,000
64,000,0@
66,000,000
64,000,0@
62,@0,000
60,@0,0@
page 2
Town of lor 6ato5
Portfolio Allocition & T.ea'ure.'s Fund Balancei
April 30, 2017
l;E35ItsEi3i5
ATTACHMENT 1
ToIn ol a6 Graot
tion-Tr€aeriv IL5rkEd rlnd lLlaoca.
Aprtl lO, 2(}1,
APR 17
Pr.vious D.poritr
&j!!S! Realizedcain/Adi.!!!!!!!9d!!!!wllhdrawalt
c.rt. of I,a.ti.ipation 2@2 S.ri.r A R6.tu. Fund
C.rt. Ol Panicipation 2@2 5e. A Le.re Pymt fund
Ce.t. of Pa.ticipation 2002 S.ri€ A Consr. fund
COP 2O1O lib6ry Ae*rv. rund
lotal RBtncted Funds:
446,273.64
24.76
o.5a
0-m
0-00
0trc
50.85 S
0.@
0.@
0.00
000
0.@
s 5a6,324.50
2A_76
0.58
ss
iaot 1i The three oiginal fund5 fo, the Ce.tifi6ta of P.rticip.tion 2002 !.ris A consirt of @nstru.tion funds wti.h wll b€ .rpended over th.
n.ttf.wyeeB, reterv€ fundr whi(h wjllgsaEnteth€ payme.t ot 1..r. p.ym.nB,.nd. third tund tor the di3buu.m.ntofl.aie payments
.nd initial delivery @sts.
ilrra. 2: The 2010 COP Fu.ds ... .ll fo. tt! Ubr.ry consbEtron, r...ry6 to gu.r.nte laE paymsts, and . t..3. p.ym.nt fund for th.
life of th€ aOP issue. Tn. COI fund wa3 .lor€d in s€ptember 2010.
sq!9 sry:sq!9 123
Ihet€ account5 a.e not pa.t of theTreaslr.r't fund balancet reported els.wh€re in thit report, as they are for s.parat. and dirtinct
sl:gl::g
ATTACHMENT 1
.luly 2016
August 2016
September 2016
October 2016
November 2015
December 2015
lanuary 2017
February 2017
March 2017
April 2017
May 2017
June 2017
s40,143.04
41,290.94
39,945.53
40,937.76
41,t54.17
42,459.62
43,069.29
39,247.97
43,826.0t
46,70r.a9
5419,210.a0
Page 4
Town o, los Gatos
Statement oI lnterest Earned
April 30, 2017
lnterest bv Month
ATTACHMENT 1
To$n of Los G.tos
Invcstmenl Schedule
April30,2017
I 4.e,2I92 S 71,rrr9,9 .rJ339.O9 5 eze
9 7e5,2!r u t 5r2,e3s 35 t r75.r17I
J L2ro,r2 .' t 7s5r2 12 t .1x210&
__!q
tttI
9
9
5t
5It
J
9
5
3tIIt
tI
t
9ttttII
9!!
stt
3
tt
tt
Jttttt
3tItttttIIt
I
3
9tItt
3IttttII
5
3
sttt
ATTACHMENT 1