Loading...
HomeMy WebLinkAbout011420-05.3mtADMINISTRATIVE STAFF REPORT S.3 pRl`IVILLE TO: Mayor and Town Council SUBJECT: November 2019 Month End Treasurer's Report BACKGROUND January 14, 2020 The California Government Code and the Town of Danville's Investment Policy require that a report specifying the investment activity during the month, as well as the month- end investment balances, be prepared and presented to the Town Council on a monthly basis. DISCUSSION Beginning and Ending Cash and Investment Balances for the month of November 2019: Town Funds Trust Funds Assessment & SA Total Cash & Investments Total Cash & Investments Year -to -Year Comparison 2018 Cost Basis October 31, 2019 $83,844,573 1,214,067 1,691,834 $86,750,474 November 30, 2019 $80,635,907 1,231,335 1,699,441 $83,566,684 Market Value October November 31, 2019 30, 2019 $84,734,633 1,214,067 1,695,533 $87,644,233 $81,385,385 1,231,335 1,701,114 $840,317,835 $82,170,303 $78,469,544 $80,942,913 $77,427,603 There were no purchases for the month of November 2019. There were no purchases for the NERIAD Fund for the month of November 2019. Maturities for the month included one Federal Home Loan Bank Note for $648,875. Maturities for the NERIAD Fund for the month of November 2019 included one Federal Farm Credit Bank Discount Note for $82,150 and one U.S. Treasury Note for $198,039. The Town's net cash position changed from $10,305,695 to $7,745,905 during the month of November 2019. This consisted of operating expenses in excess of operating revenues of -$3,343,263, net funds invested of $648,875, premium/ discount recognition of $2,975 and interest received of $131,623. Cash requirements have been projected for the next 12 months, and the Town is in a position to meet its cash requirements. All investments that the Town owns are in compliance with the California Government Code and the Towns Investment Policy. PUBLIC CONTACT Posting of the meeting agenda serves as notice to the general public. RECOMMENDATION Accept the November 2019 Month End Treasurer's Report. Prepared by: Lani Ha Finance Manager/ Treasurer Reviewed by: Joseph A. Calabrigo Town Manager Attachment: November 2019 Month End Treasurer's Report November 2019 Treasurer's Report 2 January 14, 2020 0 ti 0 0 0 0 0 0 1,0 M Vn kn O 00 O a1 M O M ,--i V') O_ O O �O %c 00 0O O Cl llc M 00 �D vl O V7 01, tr) N 00 N M 01 N Do N M O [— N V N N M 69 64 e O N 0 O O 00 M 00 M ao 69 O C� v'i M �O 10 00 0 0, O 00 69 N --� Cl 00 O r N vi vi 0; 00. r N r- O e+i O l N N 69 oo)n0000 0 0 0 0 O O 000,0 00 oato C0 fn by . � U •� O I�.i Cis C8 L:1' F" M t/1 N 00 01 M O [� N N M � 64 e O N 0 O O 00 M 00 M ao 69 O C� v'i M �O 10 00 0 0, O 00 69 0 0 0 0 0 0 0 0 M W) r-1.0 O\ � N N 00 l— M N W"T O 00 l— 00 O N V M vi oo O N kn \.O "T 00 W) O 0\ N "t W � M 01 1.0 O M 0, 00 M N D 01 N N "T v') "T v) � t- 69 00 00 M 00 69 a� CA N a� 0 0 )n Q co O `O ao - Nm M V') o ob ct O H CIS c� a � 0 a o Z �A � fn by . � U •� O I�.i Cis C8 L:1' F" O •v v� �wU¢zci �D 0 0 0 0 0 0 0 0 M W) r-1.0 O\ � N N 00 l— M N W"T O 00 l— 00 O N V M vi oo O N kn \.O "T 00 W) O 0\ N "t W � M 01 1.0 O M 0, 00 M N D 01 N N "T v') "T v) � t- 69 00 00 M 00 69 a� CA N a� 0 0 )n Q co O `O ao - Nm M V') o ob ct O H CIS c� a 7 N b a 0 0 0 0 0 0 0 0 O O O O H 0 to O O 1p Ol vl kn kn to O kn Wn M ' 00 00 l— l-- 00 M l— M M ° lU O^ ll \O M M llc o0 l0 1p ,It 0, It 't kn It r M to N 00 00 DD M 00 ? DD 0 DD N Con 69 69 69 69 69 GS 69 69 u7 j N kn O O S 00 O O' O M O O\ M O 00 1p is l_O lfl M 01 M M Vl -+ 1p M lD �+ k 0 0 O N ch N N 110N N k4l) y '. o0 00 o. O �z GS I.S 460S f..� 'n O O O O\ O1 O\ kn to O ON cs M t" O 00 00 00 O M 00 \0 N M ' "'Zt ' O C1, C O\ Cl, M cl ll , y l0 l0 O 0; 01 C\ kr) l0 01 M � t- N N N N N 00 00 Cd 69 64 G9 69 69 69 69 Gni U V] W u o d cnon L) aw O --'InnO Q = vn asN an F H O o cz O d A� En V)o w� H W > E- d H O p; U U +� d C's O i Cd cd cn Ul cl m wwv�d void-d CA U U w d W w� Q z ��HUz Cd � U U v) 7 N b a m , , . . , . • oll \ 7 - /. @ 7 &- C4 0 / m $ g _ M ' oc & kr)m & r CD r- \00 o 0 �� 00� � $ _ _ 8 ƒ m _ \ , 00 kn a§$ \'4-, 2 0 m °+ƒ § \ © / E Q \ ^ / m llc� \ 7 7 ~ / / 00 2 w §. 0 / _ _ $ � ` / / \ \ S o ( ° k % � _ _ \ — § 7 ] / u 2 \ Z° 0 / \ \ ( � \ � / § ƒ § # d _ ® ) •- S § . § m 2 $ \ # & & l § / / \ 4 •\§ CO u § w w Q §% ° 7 $ l m O O Q, N O O O O O vn 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 V �D Vl �O �O �O O O O O O, O N O O O T O o0 vl O O O T O O ON O1 o0 00 N clM l0 IIR 00 00 r� C1 o0 7 ll* r, 00 O � O O a O C y M N 00 , N �o M kn �O Vi M 00 N O �--� V vi tl 1.D O O O y N N r M N N N 7 N N N N M N M V M N M N Q � � 69 O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CD 01 7 N N M't't N t, 00 O 0oo oo 4' �O 0 l Vl O V O t- 'O O M 'd �1 O V1 Irl �D �O 7 't 't V'1 O\ Vl oo 00 .--� Ol V'1 00 00 Vl Vl \o 00 [- 'tN N O O --—^ N N N N M— N N N N N N N 7 O t— N 00 N "t "It Vl 01. Cl 00 N N N O N t— t— N 00 Cl 'It �O �O --� oo �O O 00 O O\ Ln 4/l M 7 oo M O_ N O\ t— o0 O t— O 01 V O7M M rl 00 tl rl tl --� N lO o0 o0 N k/1 N O co Ol 01 00 O �O 00 F O M N V _O O� t- t' O M O o0 O t- M O 7 �O Cl Cl 00 �--� M 0 0 M O Vl O H O o0 N N T oo 00 �O M m N N n V V V1 t— O kl 7 W) M �!1 �O O"t Ot O 00 O 7 N l� N 01 ul D, 69 N O y O O +0+ +0+ N N +0+ N 15 d N +0+ ,z000000� � o �ozQzzzz�zzzzz wuw w w 2 N N 12 12 zzzzzzzzzzzz www w w w w w w w w O p O 7 O vl 10 vl 1) O O 7 n 01 h � O o0 O 00 O D, Ol O vl O �O vl �D vl ?2 D\ 00 � O\ t— kn M 1O Vl --� t� V'l 00 O �!- V1 N M 00 O V1 V'I M O O Vl Ol M N M 01 .--� r. �Y 00 �--� �--� ocVl O l� CF �' M N O o0 M ON Vi [� vi M 01 O t- O\ W) M �O N ul O o0 Vi t- Vi oo O Q. O O N 7 N 0 00 O O t- a\ N Ol O o0 M (31 O �O 0� o0 �O O 7 N r 7 Vl �O M 69 O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O td � O O Vi O Cl O Cl O O O O O O O Cl vn O w) 0 0 0 0 0 0 0 0 Vi O O o0 �--� O O O O O Vl O O O O O r- O N O O O Vl O O O O Ol Q ; IO Vl "Ij v1 00 O vl klj Ul M Vl IO O O C1 O 00 t- Vl a— — — — — — — — — — — p N 0 O O � O Q w M N O, 0 0 0 0 0 0 0 0 0 0 N N N N N N N N N N M M M N N N N N N N N N o O N N N N N N N N N N N N N N N N N O O O O O O O O O O O O O O O O O O O O O O O G.' O O N N N NNNQ NQ N NQ N N N N N N N N N N N N Na) O o0 M : 0 0 M [� oo oo N 01 r- O\ , Ol O 0 F�+ N� N N N N �--� \ �-+ O� �--� �--� O O N N N m in r- N N --� �o �c 0, %. O, U ^ 0 0 0 0 0 0 0 0 0 0 0 0 O O i.. �Nsy v7 cO N N (� t— tl- tl- t, �O oo Vl Vl n 00 t— t— ON 00 00 ON 01 00 O1 oo oo O1 m m F" Ca 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 N N N N N N N N N N N N N N N N N N N N N N N N N N N O O Qi M r- wi t- M N t- Z Z Vl vl t- O o0 w O U--� M --� N O --� M --� N N N --� •-+ N�� --� O N O --i N N� N --� �c t- Oi U O 0 0 0 0 0 0 0 0 0 0 0 N O y O O +0+ +0+ N N +0+ N 15 d N +0+ ,z000000� � o �ozQzzzz�zzzzz wuw w w 2 N N 12 12 zzzzzzzzzzzz www w w w w w w w w O p O 7 O O O O O O O O O O O O O O O O O O ON �o N In M M h h rn 00 h O O O O O N O N Ln 01 N O vl O O h v1 C� �O W O O h 00 (7\ N 00 M N h M V1 N 00 W) O O, N oc oc01 O h 7 m h 0 lO O v1 h --� 00 M M h M M n V 0 7 n oc cl 00 N D\ 7 7 nN V r- �--� 00 to Ln Ln M O 00 00 D\ 10 �--� M 7 M N y N N N N 7 M N N N N M N m v vl N N N M O d � b9 69 69 O 0 0 0 0 0 0 0 0 0 0 o 0 0 0 0 0 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 0 0 0 0 0 0 0 0 0 0 0 7 DD N �--� M O 0� 00 W h O o0 --� N O O Ln M00 (ON M 7 V1 O M V) D1 --� M h '10 �O "O N h 7 ON O N 00 M h00 �--� U1 O --� O1 O O, h N O� M h �O In C�, --+ y�--� — — ,-. ,-. ..-� — — �--� N N N -- M N -� N O N --� M N �--� N �--� N �--� '. N N N O M O\ = O O O 7 w Q, V M �o v1 N M M h h 01 N Ln-� �D M O o0 O O O �D vl 00 �O -- �--� h M 00 h vn N M M V 10 O �o M ON h M �o O T N �D 00 V '. 00 00 O N [� [� --� N h --� O O M 7 00 h h - O DO �D G h M 7 7 01 Q1 0� O 0� T O1 �O V �o O O 0� 00 V1 vi m0 W) O O O OW) N ') M N O1 01 V1 V') �/1 M �o vl h M N 7 M �-- h 7 h h N M h h N �D 'n NV) 00 N M 01 0 0 N O �--� 7 00 X�-. �--i �--i �--i �--i .--� .--i �--i �-. .-. �--i �--i .--i .--i �--i- M to h N N 69 69 69 EA W O M w �o N h �o m h O 00'D 0O 'D�--� h h O, N M V �O �o O t- Vl h 00 <71 N N M O, v'l O M D\ DD N w w �c DD v'i h M (2,h M �0 O O1 O\ � h .- �D 00 -. - vl M h N v1 V h 00 M Do N ON N O 00 �o 00 00 V N vi a; -It N O �O O O N vi O �O M O vi 7 ON r- V 00' ° , , N a0 01 O 01 h 00 O 'o 'O V 'o � 00 'D O, O � V) h M N 7 r- M h �O �D M Q, O\ V1 00 U M �D Vl --� M �--� V V N 7 N N o0 01 7 �--� M �--� N Ul Cl N 01 Q h 69 6s fi9 69 O O O O O O O O O O Cl O O O O O Q O O h h O\ N Q O O O O O O O O O O O O O O O O O O O O O O O O O O O O O M O, h M �O O 0 0 0 0 0 0 O Cl O O O C C C 0 0 0 0 0 0 0 0 C C C C C C 0 C 00 "'i "% ) 0 0 C 0 0 0 O Q O O O cC 0 0 0 Cl 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Vj O �o M O Wn W) vj In Vi O O O O Q O O y Ul Ul 0 0 0 0 0 0 0 W) Q O In Q V1 O O O W) �D v1 h M N V h M h h h V 0 0 0 7 Q > N �1 M ('t n N n N 01 017. ul N N n O 00 In > y d N O o w M Q w N r+••� w co 0 0 0 0 0 0 0--� �--� N N N N m M M N N m M 7 O O N 0 O S p Q N N N N N N N NN N N N N N N N N" O O O O O O O O O O O O O O O O N N N N N N N N N o£, O O N N N N N N N N N N N N N N N N N N O O O O O N N N N N O O O O N N N N C O Cl 00 O O N It In 7 r- M V 01 O N M m : t L O In 00 00 N� W) 01 7 Cl O �--� O O CD Cl O -� O O O �--� O O O O O w N y Ci N ul h h V1 h h h DD o0 DD h 00 01 01 01 01 00 DD Q1 D, 01 [- e0 00 _h O N O 0� 00 V V 01 Z9 W N C� k [- Vl 00 C� �-. M U U W� N �o M N W N O O �O V Qi n N N N •--� -� In W W r-- O W C,-- --� --� 0 0 0 0 0 0 0 0O --� O O O O C O O O <= O O O O N N M 01 O M M N d a� ulu 4 00 N U M M o y N ° ° S d N z ti b N N N� O i•' N 00 N +0+ N a0+ O ° O Q00O z �zz N —RU - O16 y0 16ti ti ti ti ti m .D O ,� L v v v Z Q N X 0 0 0 0 0 0 0 0 0 0 0 0 O. 0 0 0 0 0 0., � .>, ? > iF.., � '� N N N Nd� ❑O > 7 � id N� bD z z z z z z z z z z z z Z Z Z Z z z �, �, G rn y a0i v U W o o a, 7 �• : 'C '� N N 0 H Cl) v CAC/) C V) Goi Vi vi v) C'n vi v) ui Cl) v) c2('o ��������DDD ����D-�:) 3:) Nxxxti aa�Ei4 U Q z O 7 O W) 0 0 0 O� C) W) V1 O O h v'1 00 O U O r� vl O O O �--� O r- r kn N� �--� r y N M M 7 Vl 00 l0 N 00N n O M v1 1� O [� M O\ a0 vi N O n D\ O D\ 00 O N �--� N rf) N N N N O [- C M �O 69 69 O C> M M V Oo 00-,1- 00 N r n In 7 n Oo l- b � °, O O MO� oo O N N l- r" In v1 O H (=> In W 00 O_ .r N [, N [- 00 l- N �O W/ O M w) �o. M �--� 00 Vl M �o �c 7 M M 00 N 00 [- [- N O M N �O l/1 11 [l O M 7 oo Oo M M M N Lr [� M l- M O o0 N O\ NT r: Qi In O �--� M 7 �o N �--� O v) N �o r- M O N DD 00 O l- l- O O. N O [� l- l- oo O N M 69 69 [� v1 00 n vl �° O� O N 01 N M O l� 0 --� M N N n 7 N M �D (0, N r vi O� 7 O D; 1) O N 7 �o r M 7 V) O oo oo M N C OC, Vl 00 v'1 �o V N O �o M U a0 oo O� [-- O O V N O\ n r r- oo O O H oo 1 1619 tell O O O O O O O O O O O O O O O O vl O O O O O O O O O O O O O O O O O O O O O O O O O O (= O O O O O O O\ p O O_ 0 0 0 0 0 0 W) 0 0 0 0 0 0 U1 W) O O W) W) O O O W' O Ln w) V1 O Vl �� 00 O� O l- l- O O h N O r r- r w D\ U [- 00 a 60s 69 Q N N N N N N N N N N N N N N N O O O O O O O O O O O O O O O N N N N N N N N N N N N N N N •� 00 01 � V' � � � V1 � M 01 M �O N O O O O- O O O o O O O O o Q o000000000s0000 rN N N N N N N N N N N N N N N N v) v1 c6 N M r- 00 Z 01 M T O� O\ r 0\ l- Vn M 00 a O O O O O 6 0 0 0 0 0 0 0 a C O U d Z Q o�o.2 u ° U c ° o ° o U °3 z. U Z Z° o U U °zz q U w y °zz°' u Z o � � 2 duo ° Zx U oZZZ�nx w b U U o -9'. ° ° d o up)f� c°i ?: ° «d ° '� 5 d ° �v�az000aUF°�oaa3¢ uro�a £ 2 » \ \ w 2 G % % � 2 � - -� - % % g q CDƒ ƒ > e ƒ § ® / Rf q 4.2 ( % ƒ d 2 e � a � k � � § k � � 2 / k ? \ ® � U � £ o O_ M 00 01 O 00 O\ M N l� M 14 Yr C� 69 69 O U N O i� CQ O M00 O1 O '-r 00 O1 It Vl N 110 M � 69 69 69 69169 r-. pp�qq ^ � U CC U N U .0 o o bo `"www w� Cd U O 69 69 00 aU a '' 21 N c� N c� 0 0 o �n M oo N Vi 0\ Q1 CF 01 h h 69 69 69'69 N M 00 M_ V1 00 0�1 M 69 64 69I69I OO O O O O O O O O O O C, all rn ebb > > o Y 0 0 0 61D z z Cd Cc cd En FI-, H H C'i v3 C/) CA A 69 !69 oll � Ni � 69 Gl�IfAI 69 Y 0 H