HomeMy WebLinkAboutResolution 2017-174 N.C.S. 12/18/2017Resolution No. 2017-174 N.C.S.
of the City of Petaluma, California
RESOLUTION TO RECEIVE AND FILE THE CITY TREASURER'S
QUARTERLY REPORT DATED SEPTEMBER 30, 2017
WHEREAS, the City Investment policy requires the City Treasurer to provide a
quarterly investment report to the Council for compliance with the adopted City Investment
Policy.
NOW, THEREFORE, BE IT RESOLVED that the City Council has received the City
Treasurer's Quarterly Report dated September 30, 2017 and directs the City Clerk to file the
report.
Under the power and authority conferred upon this Council by the Charter of said City
REFERENCE: I hereby certify the foregoing Resolution was introduced and adopted by the Approv d as to
Council of the City of Petaluma at a Regular meeting on the 181h day of December r
2017, by the following vote:
City Attorney
AYES: Albertson, Vice Mayor Barrett, Mayor Glass, Healy, Kearney, King, Miller
NOES: None
ABSENT: None
ABSTAIN:
ATTEST
Resolution No. 2017-174 N.C.S. Page 1
City of Petaluma
Quarterly Investment Report
July 1 to September 30, 2017
K"�00
a/
OV,
Exhibit 1
This report is presented in accordance with the City's investment policy and the California
Govermnent Code. The policy and Government Code requires the Treasurer to certify
that sufficient cash flow is available for the next six months to meet the expected demand
or provide an explanation as to why sufficient cash may not be available. The attached
report outlines the current investments, weighted average and yields of pooled investments.
The month end account statement of assets managed by Public Financial Management, LLC
(PFM), the Local Agency Investment Funds (LAIF) quarterly statement, and the City's
performance summary of portfolio investments' as compared to applicable benchmarks
are included. The report also includes the Treasurer's certification of adequate cash flow.
We respectfully submit the quarterly investment report for the quarter ending September 30, 2017.
Resolution No. 2017 -174 N.C.S. Page 2
CITY OF PETALUMA, CALIFORNIA
CITY TREASURER'S QUARTERLY REPORT
For the quarter ending September 30, 2017
Cash activity for the fiscal year:
Cash and Investments, Beginning of the quarter, 6/30/17
Cash Receipts
Cash Disbursements
Cash and Investments, End of the Quarter, 9 /30/17
Cash and Investment Portfolio at
Investments Managed by City Treasurer:
Assessment Districts Bonds
Local Agency Investment Funds (LAIF)
CAMP Pool (CA Asset Management Prog)
PFM Investments Securities **
Certificate of Deposits
Checking Accounts
Subtotal
Investments Managed by Fiscal Agents:
CAMP Debt Issue Accounts
Trustee Money Market Accounts
Subtotal
Total Cash and Investments
September 30, 2017
$ 135,132,210
70,883,841
(80,261,968)
$ 125,754,082
Percent
Fair Market Par Value of
Value* (Cost) Portfolio
307,390
307,390
0.24%
60,205,176
60,426,008
48.05%
30,585,064
30,585,064
24.32%
25,074,876
25,258,492
20.09%
250,000
250,000
0.20%
3,691,807
3,691,807
2.94%
120,114,313
120,518,762
95.84%
434,358
434,358 0.35%
4,800,962
4,800,962 3.82%
5,235,321
5,235,321 4.16%
125,349, 634 125,754,082 100.00%
I certify that this report contains the total amounts of cash and investments at September 30, 2017.
The investments are in conformity with the Investment Policy. A copy of the Investment Policy is
available for review in the Finance Department. The City Treasurer's cash management program provides
sufficient liquidity to meet expenditure requirements for the next six months.
We respectfully submit the quarterly gvestinent report for the quarter ending September 30, 2017.
P
William Mushallo, Finance Director D ecat
*Fair market values are furnished by the State of California, Local Agency Investment Fund and California Asset
Management Program.
** See *detail attached
Resolution No. 2017 -174 N.C.S. Page 3
CITY OF PETALU1 -vL&, CALIFORNIA
CITY TREASURER'S QUARTERLY REPORT
For the quarter ending September 30, 2017
Investments Dfanaged 41' City 'Treasurer:
Assessment District Bond (AD) 2000 -01
373,535.08
1,238.93
(66,144.82)
307,390.26
Sub -Total Assessment Districts Mond (AD) Accounts
373,535.08
-
(66,144,82)
307,390.26
LAW
60,124,444.45
138,45893
60,262,903.38
LAIF accrued interest
138,458.93
163,105.11
(138,458.93)
163,105.11
Sub -Total LAIC
60,262,903,38
301,564.04
(138,458.93)
60,426,008.49
CAMP Pool - Treasurers Investment Money Market
35,454 172.64
3,132,229.46
(8,001,337.82)
30,585,064.28
Sub -Total CA14H' Pool illanaged Account
35,454,172.64
3,132,229.46
(8,001,337,82)
30,585,064.28
Federal Agency Bonds/Discount Notes
14,991,670.35
927,587.85
(1;686,968.16)
14,232,290.04
Fed Agency accrued interest
32,309.63
42,090.29
(37,740.29)
36,659.63
US Treasury Bonds /Notes
10,191,523.84
2,050,583.98
(1,287,898.44)
10,954,209.38
US Treasury accrued interest
21,279.72
33,603.59
(19,550.63)
35,332.68
Sub -Total PFM Securities Managed Account **
25,236,783,54
3,053,865.71
(3,032,157,52)
25,258,491.73
Subtotal
121,327,394.64
6,487,659.21
(11,238,099.09)
116,576,954.76
Certificate of Deposits:
Umpqua Bank
250,000.00
60.95
(60.95)
250,000.00
Sub -Total Certificate of Deposits
250,000,00
60,95
(60,95)
250,000.00
Cheeidng Accounts:
Exchange - General Operating
8,238,960:53
28,675,96391
(33,311,557.17)
3,603,367.27
Exchange- Payroll
6,984.01
5,905,891.00
(5,906,207.52)
6,667.49
Thomas Lee Charity Trust
1,817.38
-
1,817.38
Police Trust
79,942.67
12.08
79,954.75
Sub -Total Checking Accounts
8,327,704.59
34,581,866.99
(39,217,764.69)
3,691,806,89
Total Cash and Investments Managed by the City Treasurer
129,905,099.23
41,069,587.15
(50,455,924.73)
120,518,761.65
Investments Dlauaged by Trustees Fiscal Agents;
CAMP -AD 23, 24, 25 Accounts Money Market
433,119,26
1,238.93
434,358.19
Sub -Total CAMP -Debt Issue Accounts
433,119.26
1,238.93
-
434,358.19
Bank ofNew York
40,169,57
-
40,169.57
US Bank First American Treas
4,753,821.60.
29,813,014.84
(29,806,043.65)
4,760,792.79
Sub -Total Trustees Money Market Account
4,793,991.17
29,813,014.84
(29,806,043.65)
4,800,962.36
Total Cash and Investments Managed by Fiscal Agents
5,227,110.43
29,814,253,77
(29,806,043.65)
5,235,320.55
TOTAL CASH AND INVEST rvIENTS
135,132,209,66
70,883,840.92
(80,261,968.38)
125,754,082.20
++ See detail attached
Accrued interest
(235,097.42)
General Ledger
125,518,984.78
Resolution No, 2017 -174 N.C.S. Page 4
CITY OF PETALUMA, CALIFORNIA
CITY TREASURER'S QUARTERLY REPORT
For the quarter ending September 30, 2017
Cost vs. Fair Market Value
Unrealized
Cost FV
US Treasury Bond/Note
Federal Agency Bond /Discount Note
Corporate Note
Certificate of Deposit
10,954,209.38
14,232,290.04
-
10,924,704.58
14,150,171.49
-
(29,504.80)
(82,118.55)
-
-
Sub -Total PFM Treasurer's Invest. Securities
25,186,499.42
25,074,876.07
(111,623.35)
CAMP Pool Money Market Fund
30,585,064.28
30,585,064.28
-
CAMP Treasurer's Investments
55,771,563.70
55,659,940.35
(111,623.35)
_Sub-Total
Accrued Interest
71,992.31
CAMP Total Investment Managed Securities Held
55,731,932.66
CAMP Debt Issue Managed Accounts
134,358.19
434,358.19
-
PFM CAMP Total Treasurer's Investments ** 56,205,921.89 56,094,298.54 (111,623.35)
LAIF 60,262,903.38 60,205,175.80 (57,727.58)
LAIF amortized cost rate 0.99904207100
** See detail attached
Resolution No. 2017 -174 N.C.S. Page 5
.0
4-r
rC�
V
Cd
^Q�
P1
4�
•rr-l1
V
H
O N
N X
.. O
O d:
M
rQ
d)
Sg
V
r
O
.A 00
U
M
O c
� M
� N
0 M O
bA
0
N
OMO M
o N
o
0
p r-t
U
•-+ M "'t
rt ..ti
Resolution No. 2017 -174 N.C.S.
O mot
r3
p
d
N
� � c
y qO
N N
Page 6
N
N
O
M
x.
N
.O
E
a)
c.
f!)
0
O)
C
0
W
L
Y
0
O
M
O
ti..
Q�
.Tr
�L
U
++aA�
vJ
4-
O
0
�F+
C
O
O
v
a
o�
fa
C
RJ
�.3
Ln
N
to
to
to
N
CO
tD
O
O�
o
O7
co
O
l!7
O1
0
OR
o
O
O
O
O
O
00
Ln
N
N
N
b)
Y3
to
rn
to
M
m
rn
n
n^
ti
h
Cl
N
a
o
o
tri
ri
q
m
c0
m
tLt)
[\
H
Ql
�n
!V
o
to
o
UUi
N
LO
to
rn
W
o
N
Oi
O
to
<Y
VN•
r
CD
[rI
Ln
G
O
.D
N
m
co
V;
k
m
m
V
o
O)
N
rn
M
to
V'
m
N
rn
C.
to
o
m
0)
rn
ri
M
00
M
Q
.� O
o
rMi
V
Vim'
tco
.-1
Ln
0
m
kO
Oat
o
OO1
y
C:)
o
N
ai
h
W
U�1
�y'
N
,-i
roi
o U
CG
o
to
to
M
04
co
�v{i
�6
+-+
'd
rl)
o
tV
'Q'
Oi
O
O
W
ko
m
Ui
o
O
Oi
ct
O
ri
N
Ln
O
tD
N
M
W
to
M
t0
M
M
t0
W
Ln
00
co
L. 7 1,
U .Li
1cD�
t0
(Nf�n
N
Oi
M
N
M
al
M
ID
M
O
t a n
to
N
.-i
N
V'
n
kO
t,
M
�j
M
m
LO
to
rl
N
to
M
(�
W
H
N
to
O
ID
o
U)
N
to
co
to
N
(i
W
n
M
U)
o
U)
O
t0
M
CO
b
H
H
H
W
W
W
rl
+-1
W
H
4
O
O)
ko
w
co
00
r`
o
0
M
Iq
co
M
to
r�
co
rn
W
d;
W
O�
to
o
(D
o
00
M
O)
W
O) O
N
n
M
o
N
m
N
io
dN
w
Ln
W
m
r,
tan,
2
N
D
N
to
O
m
O
°
N
.-i
Cl)
Ol
N
to
to
m
tD
f��,
o
o
e}�
Vj
Oi
V•
co
tb
VIn'
W
rl
V'
ti
W
W
Q1
O
N
U1
to
H
LO
H
to
W
tD
W
N
W
N
H
N
W
N
W
N
W
N
H
N
W
•tn
W
ft3
`
rn
0
\
V
o
\
O
\
}
H
\
M
O
\
to
O
\
M
O
\
H
O
\
N
W
\
to
O
\
W
N
\
N
o
\
O
M
�o
W
H
O
\
W
a
W
O
a
O
a
O
M
O
O
O
a
(D
d
U)
W
U)
W
w
W
tD
H
to
W
N
H
N
H
N
W
N
W
N
W
N
H
N
H
U)
W
10
to
o
W
a
a
o
o
`
H
O
M
Cl
W
o
W
M
to
�
M
o
tD
`
In
O
U)
\
or?
o
0
0
0
o
a
o
V G
ra
m
¢
m
m
¢
m
a
m
¢
m
m
¢a
m
a
m
a
m
Q
m
¢
m
a
o a
Qm
¢m
i
a c
+
+
+
+
+
+
+
+
+
+
+
+
+
,,
O
0
O
0
O
o
O
a
O
0
O
a
O
0
O
0
O
0
O
0
O
0
O
o
O
O
H
N
D
CD
0
0
o
0
0
0
0
a
0
0
O
o
0
0
a
0
0
o
0
O
0
0
o
o
0
0
a
o
0
o
O
0
0
o
o
0
O
ko
to
o
C)
t�
Ln
m
j
Nw
o
Cl
vM•,
o
to
7
o
0
0
n
0
0
0
n
0
ao
of
v
W
W
W
H
ri
H
O;
O
rl
`r
n
Lo
n�
cHO
(0
m
co
o
U)
a
-
o
'a
00
00
00
N
et
0.
m
m
co
a
o
m
o
00
co
n
m
w
x
m
m
N
N
00
N
W
N
CO
N
Op
N
CO
00
N
QO
N
00
N
O
co
co
N
W
N
CA
N
CO
t0
N
W
N
W
N
H
N
N
H
N
W
N
N
W
N
W
N
H
W
W
U
rn
rn
a,
,
a)
0)
a,
01
rn
o,
rn
o,
o,
rn
M
W
OD
O
al
Ol
O
O
O
O
O
o
o
W
W
W
C)
H
O
W
O
W
O
W
a
N
o
N
O
N
O
N
o
N
O
N
o
N
O
H
O
Q\
Irl o
H
N
M
vv
W
W
N
N
i
M
d'
tD
12'.
N
N
D�
Q
H
H
O
O
W
O
}
1 O
}.
>2 O
O
O
O
O
a
U)
m
V O
o
0
0
0
0
0
o
o
0
0
0
o
p
4 0
vt U
p N
o
cN
0
U
N
D
tN
D
O
to
o
to
m
to
m
to
M
to
to
u
D
n
N o Ln
m U
a� A
H
�"�
} a
W
��
} a
r-1
��
} o
ri
a`r
} o
ri
�ti
} o
H
�"'
} o
ri
"'
o
-4
o
I
z�
} o
zti
} o
pt"
} o
�H
} o
y
Ln
rv"
o
4i
(n
(Y N
(y� N
(x' �r
Q C
Q N
D: N
N
N
K N
p,
),
N
4
M
o
O
o
O
O
M
M
M
O
,! Q
N
ri
t`Ol
Cl
�W
ll]
O
O
N O
Jage
UJ
t"'
t� f"
AON-1
1'-
to 1-
AO
.Z 1""
AO
,� 1'
1"'
UI I"'
:n f"
Gr
�""
LL
fn
5
ResoIurion
!�
d
No. 2(�1 �1
Q
�.C?S.
a Q
0
5
rn
I
CL
7
n
rl
0
N
O
M
L
E
B
Q.
Ol
C
C
W
N
0
O
x
Q1
;p
ll..
Lam:
TQ�
i
U
�F.
O
C
O
U
a
a�
r.
►7
w
n roy m 10 l\ ° o N LrLni a)
t rn m n o 0) H 0 M to to
Ln C� N O M kR O t0 (I N p
m ID N ^ N .h-i .N� M. li Ln M
It r-+ M
H In
G
3
O
An co b m co V" O m 10 in O Q
00 l0 O Ln o Ln H M Ln o 10
N ; 'A N koo ON o tin ^b ko co ^ � 2
O tD H N Ci cry+ M V1 oq In Gi
o U M N n tH0 M .I�-� .I\-i (.Mj M M
D n r H d co a o m tt o o n
O c�ot- Ot- to V; h ^ tOn totnn i0
N N O off a� O o N tMn O N N M
Q H N H N H
[-' U M N dm', o co Ln ko ,l 0 ip rn rn
77"' ro O 14 O H ri O 14 H H H O O O
N N r rn Ln o to 01 o b O
m O to V O N H M H 1D O O h
s v 6 N t� Ln M H O O t0 X1 N of
O CO 00 to N tD h O Ql V'
Ol O 0 Lh H Il o N to O] m t i 1\ Lf] 00
U �j `L Ln of 0)
M N N W .-i N H eN-i H M -i in M
d 1-i
H
to Ln Ln to Ln Ln i� t\ t\ to to to
W Q) H H H H H H H H H H H H
1 O o O o o .�-� N to
-i
Cl) m M N N N H N H
4 m o two o rn g `w m� wo rn
O H b o H o 0 0 0 o d
Ln Ln Ln to Ln Ln N n n to ID to
Lu y H ID H H H H 00 C
1�9 N a o -4 o o ° cN c'iv OH ° Lni ti
Q m H LO W o m w m :4: coo rn
C) H b o H o d o o b b Cl
pG m m mm m�q irto} ims io m iQo icgo ico} irto�
00 Q Q 4 <L ¢ ¢ Q ¢ ¢ ¢ ¢
2: R'
4. � + + + + + + + + + + + +
n o to Ln v H o 0 N o o d
L d lNn r� Ln Ln O LQ of O o O w C3 C3
4. t0 m N b V M M O N N O O O
CD Ln -i m H m to tV o 0 0
M t0 N t\ ID ID a HH N d`( LOO m
tV � H
H
o �
°i ° �d `d zg
N
ID ((Y�77 W to t((on� (�(n� r((.f� r. ((DI� o r�
rmi r1 .Mi 11 H ri ri r-1 H
U - M M M M m m m M M M M M
� C
co m N cil N 1 N ) N N N 0 00 00 1-1
H H N ' H H
ON N L N
C\ C:)
C O N O O O H O o N N O O d H
�. N �. �..
O o � o ¢ o o o ¢ o ° o o ° °
7 LL va LL �1I C
V O o Ln 0 o a o 'j o N o 0 0 0 0 o F o
C.7 o H H H o, Ln N to H Q N M4 a N F Ln O Ln !�
\ ¢ o°o n m rn o n r`ti Z ip Tom.
0 Y U. o ,�i ,--i ,�i o ,--i ,-i .raj r-i p f V M ^^H N O
N RI In O Ln O O D Ln o Ln M H Y D O b z 0
0 H N H N H N H i H N H H H H y H Z H Of H N
O Y O
O M O O O O O O H
'-` 8 H H UJ H H H W H r
O O O O O O O O O O O N H
LU 0 cQQn mo caan H m o < o zH qo N O1D U C) �[ Ho U -I z po C� o v po
`L Q `L Q `iesolutio"ngo "20V- �17TN C` .° `� `� `� Q `� age8
N
N
O
M
E
a
N
w
c
0
a�
U2
VR:
Q)
.0
VI
O
Q�
4j
O
u
U
t3
a�
cG
C
n
3+ � M O 0 d O O pp O O M O O Q7
cr t0 to N N n ��Ctl" N h O) ul L9 @
Y 7 0 C m 0) o -4 00 N N n Lof O n
L fd V (0(��0 M ID M lIl !!1 O1 O7 O�
G, Vim' Vh' h ONl r t0 Ln m co 0) m '7 r�i T O
��{{ c� O
H V' H tD h O O to to 00 m It h
ti ri H io
41
G
CD r, NC+� 1pQ 8
N 0) 0; co w I\ 00 ai N H ri o ri
N t0 U) 00 tD 00 H M h Q1 M M '0' m
.y.yy.1 M OR O) tD t CO ltl ID M M �O CO Iq CO
0 U D) H cr W O m ICI w O1 m O \j" W h
h D) (n (() lf) Q) Q) D) t' H
,-� co 'd' H to h o co to to w m W h
Q H H H
D w m w h co O (!� O N O h M m O
co H O? t0 W O
L H N tD H to H I ^^A O O O ^l it d' in
M W fN N M M N N 00 M
Q N IA CV H H m N m +-i M
U co lC) 00 In V' N tD m In N N m O
H N O C) H co m D) O O M 'rr t0
'N 0 H H H H O O O +4 H H H H
f0
O O O O O O to O O O O O O O
O to O O O CO t0 O O O O Cf O 19
00 h to rl o ro o t;
10 rn O O 0) L
% U cn N
m Ol h co
0 M h rn to to LO m rn g d
,-; w y- ,-i tD h o co to L" o m <Y h
H rl H
(U tD tO to to tD tD ko to tD to h h h
N H
N o 0 0 m\C� H m rn o a n� � \w o a
N M O N N o 0 o N N o
\ \ \ \ 0) \ \ \
CD m N M 0 t0 h W C) Cl C� C) 00
O O H O O O O O O O H O O O
LO ID to tD tD to LO tD tD to ID h h h
o H H H H H 0) H \ m
O m O H
N
L Q \ \ \ \ \ \ N \ \ \ \
�.. W
al N CC3 M lD to h h O O
O O H O O O O O O O H O O O
.p C m m m m m m m m m m m m m m
0 4 Q Q Q Q Q Q
E
OI
a + + + + + + + + + + + + + +
O O O O O O O O o O O O O O
L O O O O O O O O O O O O O O
�p o 0 0 0 0 0 0 0 0 0 0 0 0 0
0. 0 C. o O a o 0 0 0 o O O o CD
0 0 0 0 0 0 0 0 0 o O o 0 0
CD 0 m O O C] O o o O o to C7 O
tC) to h O In ID to O O O V) H O IA
,-i co cf CY to h O 19) t0 tD 00 M to h
ri H ti
M
00 m m m m w ,d rn too
Ili t3 n A A o LIQ� z a Qa w E
M CU'D� 0 1 CC��7 CCu�� Q Q W ( 3 89 tJ 'w i 0
M LCI In In M M
mi m-I
U M M M m M m M M M m M m M M
�c
co co O) CP m m Ct) m CT Ot O) Cl O O
R H H H H H H H H H H H N N
O O O O O O O O O O O O O
O
N N N N S N N N CI N N N N N
\ CO \
C d- tp tD to H H m N 00 OJ 07 o O
,�. QCL o n� H N C' tp to h CO au c0 N W h ro
d H H o 0 o O o 0 o O o 0 0 0
�=
0 Z Oz � O o O O z �
d) Ii O H O m
H u oO H H H
rl o H M o t O 0 LO
Z ID to ►
0 D tD o h h h
0 0 0 o U o o < o 0 0 0 o O o 0
H �,CC C7C aC �C aC C u'CCC
Z m m w 0 Z N N (� O .-�
++ W o p o 0 7�} c� N O o O o N o p o p o p n°3 N p 0
•L N ca rn z�i N m q }p o o a U o m o Z q o z g z o U Z ^p o
(v O u Q O iii Q A A Um- A A A z rA izi z E LL L LL
9
N z U-0 LE -1 z� z
Resolution No. 2017 -174 N.C.S. ag
R
H
C ?
d.
� ny!
L O
C
U
C
W �tt
43 '
�E
w `
a 1
t Q N
E v
G
O
0
d) 441
Y�
V
W .L•\�;
cn
C _ 'fl c
cn
a
lY
M
a
U
B
m
C
O C
Q. O CL
V O
U
A y
�O
m
� O
t�
O
O
rl
O
O
Oi
H
R
N
H
O
li
Ln
N
M
R
H
O0
O
M
M
a
O
ti
M
mO
'L
rn
R
N
H
O
0
0
0
0
0
N
H
H
.c
v
N
R co
Lo
O
R o
R
to
O o
M
tD co
� N
lD Ln
.RI o
^ M
H O
N
0
T
Ot
rl
R
N
,4
� N
Q1 Cl
ro
00 LQ
rq o
t� m
z
� N
�r
m o
H o
� M
N
fc
H
.G
M
c
8
c 0
c �
i
N
4
O
00
Ln
M
N
00
to
O
M
O
O
O
O
N
m
Ln
0
M
N
0
N
0
M
0
F
f
M (+
v c
%DD V
L0
to
ih-
d'
n
O
H
h
4
tD
R
U
U)
H
M
N
0
(A
ri
R
0
N
H
O
R
M
tD
in
ui
A•
O
R
N
b
R
to
Ln
N•
r
Fes -
t
}
a�
)lAon
to
a
t`!
M
Ot
H
v
c
w
I v
0
o~2017-174 N.C.S.
00
4)
01
O
4
�i
tMA
G
7
If
d1
F-
m
N
LL
Q
0-
ge 10
N
rl
N
O
M
d)
.0
E
N
CL
N
tr�
c
c
W
C
O
N
O
C
fC
C
U
U
Q
C C
�
1�
�
M
CD
N
w
N
C
0
•cam}•
M
�
'-'0'
o
�
C
W
M
lk0
O�
to
v
(Ii
,
v
OJ
L C
C�rL)
n
co
Go
Lr
�
L
ko
ko
Ln
L
FO' a
n
M
LNrt
Lr
o
C
C
0
0
en
o
M
o
N
4,
c
Q
C C
O
ON.
M
M
LL!
col
}O
O
O
o
n
7
M
N
to
M
00
to
v
M
.--I
,
v
OJ
L C
a7
M
V'
of
V
N
M
M
LA
V
4,
c
Q
p o
Q
L QI O O O O O O O O
O U O O O O O O O 4
L
s
m N r\ r\ t\ N L\ n L\
N N N N N
H rn O`i rn O`i O�i m 0` CF)
O C? O O O O 4 O
Resolution No. 2
co
N
Ln
�
C
o
O
m
n.
ill
pp
O
O
7
M
M
LA
V
4,
c
Q
Q
X
°
>
o
N LLq Ln
C
M
!`•
3T
Q
Lq
Q
ONO
LO
to �
CL
M
M
11-1'1
¢
y+
N
N
0
FO
C-
Cl
Cl
C.
N
m
A
C
G
C
d
C
N
n
N
o
a
a
o
o
a,
LL
o
pad�
A
K
Q
r
H
UJ
O•
rC
� E n
U
a-°i
o-°i
c °1
o 4 o
0
Q
c
U Q
as
E w
a
Ln o
N
N Q
V��
N
Lin
N
Lin
N
N
N
N
N
o
$�
a\i
rn
rn
rn
rn
o\i
rn
o
y
o
0
0
0
0
0
0
+-+
O
:3
M
m N r\ r\ t\ N L\ n L\
N N N N N
H rn O`i rn O`i O�i m 0` CF)
O C? O O O O 4 O
Resolution No. 2
co
N
Ln
�
o
m
n.
ill
pp
O
O
O
M
M
LA
4,
c
8
Q
N LLq Ln
O N �
ONO
LO
to �
M M
U o
C
ro
C
0
v ��
U
O•
� E n
c °1
o 4 o
0
U Q
as
rn NN °N
a
Ln o
N
1.
°' r�i o
m
CL
H d)
CO rn rn
to
dN-
n'+ V; N
O
N
N
M N N
O
:3
M
C
ro
00 o
kq
=.0
M C
N
41 E
rn L` N o
a '
q
.-A
O
O w
CL
M
N
�
co N
lD r1
Ln
M ti v
to
O
M
C
v
s
rn
G
U
v
N
ro O
tQro
to
,
ro
c
K
c
�y
aa) U
N 'O
�
0
7 d 1'
o
'
8
1V -174
N.C.S
Page
I1
BETTY T. YEE
California State Controller
LOCAL AGENCY INVESTMENT FUND
REMITTANCE ADVICE
Agency Name
Account Number
PETALUMA
98 -49 -650
As of 10/13/2017, your Local Agency Investment Fund account has been directly credited
with the interest earned on your deposits for the quarter ending 09/30/2017.
Earnings Ratio .00002942867511750
Interest Rate . 1.07%
Dollar Day Total $ 5,542,387,144.87
Quarter End Principal Balance $ 60,262,903.38
Quarterly Interest Earned $ 163,105.11
Resolution No. 2017 -174 N.C.S. Page 12
ttrvesrsState of California
Pooled Money Investment Account
Market Valuation
9/30/2017
Carrying Cost'Plus
t)esertptlon Acciued IpterestFurch. Amortized Cost i atrValue Accrued; )ntere$t
United States Treasury:
Bills
$ 14,674,811,264.34
$ 14,728,634 539.67
$ 14,723 448 000.00
NA
Notes
$ 18,827,121,137.72
18,825,793,811.24
$ 18,779,355,000.00
$ 35,404,702,50
Federal Agency:
SBA
$ 882 001 016.40
$ 882,001,016.40
$ 872,264,699.96
$ 1,109,845.38
MBS- REMICs
$ 36,639,144.19
$ 36639144.19
$ 38144,662.40
$ 171,758.71
Debentures
$ 1 328 997,141.66
$ 1,328 621 620.83
$ 1 324,530 000.00
$ 2,307,558.75
Debentures FR
$ -
$
$ -
$ -
Debentures CL
$ 250,000,000.00
$ 250,000,000.00
$ 249,152,500.00
$ 732,860.50
Discount Notes
$ 9,694 389,458.06
$ 9,721,523,694.20
$ 9,720,621,000.00
NA
GNMA
$ -
$
$ -
$
Supranational Debentures
$ 450315,184.02
$ 450,217,961.80
$ 448,745,000.00
$ 1,053,298.00
Supranational Debentures FR
$ 50,000,000.00
$ 50,000,000.00
$ 50,075,500.00
$ 155,944.44
CDs and YCDs FR
$ 625,000,000.00
$ 625 000 000.00
$ 625,000,000-00
$ 1,539,891.61
Bank Notes
$ 700,000,000.00
$ 700,000,000.00
$ 699,891,966.88
$ 3,317,666.66
CDs and YCDs
$ 12 325,000 000.00
$ 12,325,000,000.00
$ 12,323,151,274.56
$ 32,191,583.30
Commercial Paper
$ 6177 895,486.11
$ 6,189,905,611.10
$ 6 189 559 750.03
NA
Corporate:
Bonds FR
$ -
$
$ -
$ -
Bonds
$ -
$
$ -
$ -
Repurchase Agreements
$ -
$
$ -
$ -
Reverse Repurchase
$ -
$
$ -
$ -
Time Deposits
$ 5,636 740,000.00
$ 5,636 740 000.00
$ 5,636,740,000.00
NA
AB 55 & GF Loans
$ 695,865,000.00
$ 695,865,000.00
$ 695,865,000.00
NA
TOTAL
$ 72,354,774,832.50
$ 72,445,942,399.43
$ 72 376 544 353.83
$ 77,985,109.85
Fair Value Including Accrued Interest $ 72,454,529,463.68
Governmental Accounting Standards Board (GASB) Statement #72
Repurchase Agreements, Time Deposits, AB 55 & General Fund loans, and
Reverse Repurchase agreements are carried at portfolio book value (carrying cost)
The value of each participating dollar equals the fair value divided by the amortized cost (0.999042071).
As an example: if an agency has an account balance of $20,000,000.00, then the agency would report its
participation In the LAIF valued at $19,980,841.43 or $20,000,000.00 x 0.999042071.
Resolution No. 2017 -174 N.C.S. Page 13
of Petaluma Performance Summaries
Returns as of
September 30; 2017
City of Petaluma
BAML reasury Index,
Past Quarter
0,27%
0,24%
Past 6 Months
0,51%
0,41.%
Past Year
0.45 %0
0,24%
Past 3 Years
0.88%
0.76%
Past 5 Years
0.72%
0,63%
Effective Duration
1.81 years
1,81 years
Yield
1.22%
1.47%
Notes;
1. Bank of America Merrill Lynch (BAML) Indices provided by Bloomberg Financial Markets.
2. CAMP Cash Reserve Pool holdings excluded from performance, yield and duration calculations.
3, Performance numbers for periods greater than one year are presented on an annualized basis.
4. The City's Treasury benchmark was the Merrill Lynch 1 -3 Year Index from inception to 6/30/12. Then
the benchmark switched to the Merrill Lynch 1 Year Treasury Index. On 6/30/11 the benchmark
returned to the Merrill Lynch 1 -3 Year Treasury Index,
5. Inception date is 12/31/01.
6. Yield for the City is calculated as the Yield to Maturity at Cost. The Yield for the City's Treasury
benchmark is calculated as the Yield to Maturity at Market.
Resolution No. 2017 -174 N.C.S. Page 14