Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Investment Report - September, October, November 2017
CITY OF PALM DESERT FINANCE DEPARTMENT INTEROFFICE MEMORANDUM TO: RACHELLE D. KLASSEN, CITY CLERK FROM: NIAMH ORTEGA, RECORDING SECRETARY DATE: FEBRUARY 26, 2018 SUBJECT: COMPLIANCE ANALYSIS AND INVESTMENT REPORTS Attached are the Compliance Analysis and Investment Reports for September, October and November 2017, which were presented and approved at the November 2017 and January 2018 meetings of the Audit, Investment and Finance Committee. Please include the report on the upcoming agenda for review and acceptance by City Council. Also included is a copy of the approved Minutes of the September and November 2017 meetings for acceptance by the City Council, and the 2017 and 2018 attendance reports to date. Please feel free to contact me at Ext. 382 if you have any questions. Thank you. nmo Attachments (as noted) G:\FINANCE\NIAMH ORTEGA\INVESTMENT COMMITTEE\MEMOS\RKLASSEN INV RPT MAY.DOCX 0 j 0) N N O Gg 0 0 z. •- 0-oo LI G co C GO id o 0 Oel 02 f 0 y o N O GOD. 0 O N x7 N N C1 0 CI O N 0 7 0) O) ai m> a a)) O o 01 a) 0 GD G. O N {f m Investments 20,709,7 42,726,596.10 69,280,530.61 2,074,000.00 o 0) 7 7 O f0 o 0 o 0 0 n G07 r 0) eo 0) eo a 0 Q r N N O Q rn f*".. 0) O 0 N l�) N 0) N 20,709,793.90 a 0 22,654,999.95 CITY LOAN TO RDA U.S. BANK/ LAIF BOND PROCEEDS 4 43,000,000.00 0 C9 0 u. _ Q. J coa Z U w 0 0 C7 0 6 69,280,530.61 GOLDMAN SACHS TREASURY FUND 2,074,000.00 LOANS RECEIVABLE - EIP 164,906,129.83 164,901,903.73 165,179,533.73 O 4,994,518.21 4,994,518.21 169,900,6,18.04 169,896,421.94 170,174,051.94 Total Cash and Investments c 0 ca W ui GD C O a 0 GO 1 0 E O z 141,088,151.93 160,898,163.33 Average Daily Balance Effective Rate of Return 00O.0 J n vi Q O :0 m1 y G a d yac C) W m a (0 d m O� z E rnE C O .E m w . yyy as N l0 > C E o N C 'O y a VJ y 8 N 4) 0 1p EO n. 7 0)U " per) O 2-C D VJ tll O. O a) CO • co Ev y U 0v C E. E CD CD O y c0 02Q. DS :2 a• E w N 0'11!0 X 01 U (1) c/) 0 O y Oc y 0 •10 0.. na - L�O '§ U m m8 E= 2a .y L O .y O.E N y y CO .0 11 c2a .- O Y N C 1-a°.a 01-09-2018 Reporting period 11/01/2017-11/30/2017 Run Date: 01/092018 - 10:03 Book Value Market Value Investment # M N N N N N 00000000000000000000000 I, n n n CO f0 1D CO to O CO 0 1D 1D CO 10 CO CO CO 0 1D CO 1D CO CO 1D CO 0 0 0 0 0 0 0 0 01 0) 0 0 01 0 0 01 0 0 01 0 0 0 0 0) 00) CM 1A V) WVV VI C6 0 N 10co 00tl csi to of 10 )41 N 20,153,651.51 0 V 20,709,793.90 20,709,793.90 20,709,793.90 42,302,863.01 Subtotal and Average CITY LOAN TO RDA 10 CO 10 CO CO CO CO CO 03 CO /0 CO CO CO CO CO CO CO CO CO CO CO CO N N 000000.000000000000000001p �1p �1p �1p 00f 0 0 0 0 N 82222222828288282 e- .- O O O O O O O O O O O O O 0 O O O 0 O O 0 O 22,654,999.95 22,654,999.95 22,654,999.95 CITY OF PALM DESERT 22,654,999.95 V 010 a n 0 0 fO CO O O O O O 0 0 O a 10 a N in 0.-0 m a a 0 0 0 0 0 0 M a a 10 a O M 0 O0 a G O O coa0 O C O O co N fy7 0 n 0 0 C f�pV n M M ccf71) 10 4- O) , 1 tD M M 0) 10 10 (0 a 0 a 10D a00 1NO crf of 0? 01a v ID T n 0 1D tO i0 a u) 0 0 0 0 0 0 a 0 sr 10 a N F) M 0) 0.�{ 0 0'-0 0) V a 0 0 0 O 0 O M a 10 O M O o. m. ID 00) O O M O O O a 0 0 0 0 N N oa)� n N n N OO1ppV r 0) M 0t) M co e- 0 00 f0 M M M t0 3 CO P. rzQ of vco ce 0) 10 M M r tSv a a v 22,664,999.96 22,664,999.95 Subtotal and Average U.S. BANK / LAIF BOND PROCEEDS 4- r rn 0 0 0 Oi CO1DV V. 0 0 0 0 0 0 0 a CO v 0 VI 0) CO.M O O j C C C N C G O G co 0V o1 n co r Off 100 0 CO csi r M 07 M 10 0 10 10 MO M CO co m v ai v m m of 0) e� M 0 a LOCAL AGENCY INVESTMENT FUND 0 M 252026003 M CD M Subtotal and Average GOLDMAN SACHS GOVT FUND n n n n n n n N N N N N N N O O 0 0 0 0 0 0 0 00000 07/01/2017 to O 1n O 0) U N 0) to fO COO M M N to U to N 0) (0 0) N 2 2 2 2 2= 2 2 2 2222222 2 2 = 2 2= 2 U U U U U 00 U U U U U U U U U U U U U U 00 a Q a a a Q a a a Q a a a a a a a a Q a a Q a m1nUmrncow rnywwWUNMN wow Wto i.2 Z 2 2 Z Z Z Z Z Z Z Z Z 2 o 2 0 0 22 o 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 J J J J J J J J J J J J J J J J J J J J J J J O O O O O 0 O O O O O O O O O O O O 0 0 0 0 0 0 0 0 0 0 0 U' (9 (9 (9 0 (9 01 0 (9 0 U' U1 0 0 (9 (9 U1 N a 10 EGOS Y) n 80 O N a 10 t0 n 00 01 O 00 Cc)0) M r0) 10 Y a v v o v a a a a v a a v a 252026000-G 252026001-G 999 00 0 0 COgg N N N N N N 252026017-G 0 (9 9 (9 (9 (9O 0 0 0 (9 Q 066,4g6 66 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 co m ao ao ao ao ao 0o m m 0o ao 0 N N N N N N N N N N N N N a N 0 0 0 0 0 0 0 0 0 O 0 O N N N N N N N N N N N N N N 261470001-G 261470002-G 274729000-G � a J Q n N o c, CL 2 a 0 m Run Date: 01 Report Ver. 7.3.3b a Z. S t. co co co 1p m co co co co 'C co 0 0 0 0 0 0 0 0 0 co Ma N N N N £I N N N !O t0 C.O. Is- NI. el CO CO 1n t0 0. Z- ? 0 el 10 v) N 1` O O O O O o G o oW - N CO CO a CO 0) I, CO �'f e- - co411- ii 10 O 01 10 N N 10 V 0a 1° 00000 0 �N N�1010 ( O (0 0000 M (0 t0 (0 (0 CO t0 Of O h M O1 O W Mat O) O) 0) N th O O 10 h 1n M 10 n n n r t. 0 0 0 0 0 0 . 0 0 0 0 0 p l0 l0 W co W $ .2 O. d d d d d d 0 Book Value §0p � 0p 0p 0 0p 0• 0 0 0 0 0 0 0 0 0 0 0 0 § § 0) Oi O ov'i, q 1Mq llO tOn, m N h o 0 0 0 0 0 0 0 0 O O 0- tNO. ' N. 00 O M CO M M N O f0 1(1 0) a7a O M ( 10 M t Np t0 L0 LC0 1�1) N CO') pOp N O O) 4) 1') ll) M v 10 r f9 r t0 O OI Y O (0 M O O M O (0 t0 CO (0 O aa 7 N co (0 0i f0 M r co O ro (0 a0 of 0 n f� I. 0) 0) CO h N t0 V M CO CO N V CO (0 N O O 01 01 Of Of OI co Cr' 01 0f A fh 0) 1 V CON M. sr v V si V' N t0 N 01 N 4 1 69,280,630.61 0.000 6,119 09/02/2034 0 0 1 2,074,000.00 OD (0 to a o 01 O 0 Opp 0 N h M 0 O M 0 0 0 0 0 0 0 0 0 0 t0 O 0) • 0 0 M O I-1 7? r 0 0 0 O O O O O O 0 .- N CO 1q t0 O O 0 0 .0- 0 U) app6 0 0 0 0 0 0 0 0 0 0 ei a ai v a0 0 0 m N O 01 n 0 co.00 (0pp)_ 0LIS 0) Opp O 10 traa0_ ��pp tn0_ 10 0 O 0:i Ni Of N • r O 0) OOf 0 0) Ol OMf co OOf n a'! 0) O V oi N O O fi t7 N V Y V Q V' 7 Y< 10 N 01asco N N C 4.0 • d H E• NI- d'a as 10 M 0 10 M 0 0 0 0 0 0 0 0 0 0 1WD 1O 0 0 0 N Z M O N V a rr O 0 0 p0 0 0 p0 0 0 0 ry 10 V. �o, o O O (el a0 N O O� O p Op 0 0 0 0 0 0 0 p8p (00 CO (0 10 O 0 ' IS ▪ a• ll)° t+f si Off) 0 p 0 0 0 0 0 0 0 O V COM1O ^ W n A C� IIi N 10 O 0 0 0 0 0 0 0 0 0 0 t7 0f 10 V' N O O J Glfiii e7 of tli 1c1 Ili Lei l0 l0 In Ili a n N Oi N N N O d £ G m Cif C C O Z Z b N. N. N. N. P n n 0- r 0- r A I, at ......... 0 0 0 0 a r 0 N N N QV N N N N N N N N N ^Q N Is. N N N N N N N O O O O Ii 0 o 0 0 0 00 O 0 > am a 0 GOLDMAN SACHS GOVT FUND DMAN SACHS O 0000 C9 CO C9 C9 0 N 1• 0+f M M O • v a v v C7 C? 0 • N M N N N n ▪ N N 278985000-G 278985001-G M co or Subtotal and Average COMMERCIAL PAPER >- >- z zzz z ce x x x x x CO V) V) V) m CO m m m Q M> M(0 C0 Y C F I- I- F I- 22222c° a66666 a00000Q z LL LL LL LL LL }00000E- ur m z z z z z Q Q Q a Q Q m m m CO CO C7 JP MORGAN SECURITIES LLC TOYOTA MOTOR CREDIT CORP co 8 O O M (0 CO 100 IO O Y) 10 10 10 O 10 N CO N (o co M() 0 0 06538CCE9 06538CFD8 06538CEG2 NT O LL • Y WX M 0 CD 1') 46640QDS7 89233HAX2 10 0) Subtotal and Average GOLDMAN SACHS TREASURY FUND CO CO CO a a a Z z zzzz O 0 O O O O O 0 0 GOLDMAN SACHS CO 0) 0 0) 0) 0 0 ▪ v h n 6736302420 0 1M0 1M0 COCo) el 10CO 6736302450 69,280,630.61 Subtotal and Average LOANS RECEIVABLE - EIP 09/02/2014 CITY OF PALM DESERT 0 O 0 O 0 N Subtotal and Average 164,906,129.83 164,901,903.73 166,179,533.73 160,898,163.33 Total and Average PM (PRF_PM2) 7.3.0 Run Date: 01/092018 - 10:03 0a.0 al O N da O LLi a a_ 0 a Market Value ✓ r r 0 0 00 • O 0 O 0 0 N CA O O N N co si I, CO el co 3 0 o r CO v i g CO 0 0 m Z Q N O O aL N.N. O O 10 O 169,900,648.04 Average Balance 169,896,421.94 170,174,061.94 160,898,163.33 Total Cash and Investments Run Date: 01/09/2018 - 10:03 o ; o a CO 3Ill § '2to t § 1- CD aye .o 02 CD 0) G 0 f ®� oi m O. 8k 7$ a.J � 2 5,000,000.00 4,999,615.00 co oi co co 26,008,780.52 52,365,679.84 k co 2o Oi 0 1- 0 0 tO FEDERAL AGENCY - COUPON 26,000,000.00 MEDIUM -TERM NOTES 52,365,679.84 RIVERSIDE COUNTY POOL CO 2 to 0 § 87,182,279.82 87,131,200.30 87,173,499.30 Investments f § 2$ 0q (0) .2 o %% 02 ko • o. �.o kk C§ \) a) To (0 a) kE E# a_6 CD 2J § to' § '- co & g do§ o ~k in §K$ §; '- J. § $ oE TDI E> E2 08 f} 22 fc o o0 5o r- & 7 k ' .c - k k 2 \c o. m O. 22 ■ £©© .o ( § 8$� §© O_ 88E 8 8�/ of §-- > a .-_ §` .. f 0. 12-18-2017 0 k Reporting period 11/01/2017-11/30/2017 4 i y,S n CO c0 n 0 CO CO 0 0 CO 03 0 d CO '= m o 0 0 0 0 0 0 0 0 0 o Z < CO a G NNNNNNNNNN CO 2 ` O O O O r1 ol .- — N N N C O 0 O O O =0 A00Mn O 2 1 O T 0 i Y )0 co N VN' N 0 N a d W CO N 0a 0 0 N 0 0 0 0 v) O_ O co CO CO (0 F 0 0 ` n f0 M N D. V u'r n A e` f0 CO O N '- M M M O") N 11 OV O O a- 0 0 2 la 0 m 8ce N Book Value Market Value 0 o v o 0 0 0 0 0 0 CO 0 0 0 0 0 0 0 0 0 0 O O I,0< CO CD CD M O 0 O 10 n M n N N Y F. t0 0 O O Y O N a 0) Y n U7 O sr N op. . O O O N 0) cn, N to OMO 0 CONt0 O 0 (0 (0 co 0) en 0) O) a- in I. N. 0 0 n A CO- n 0) of (0 0 0 0 0 0 0 0) 0) 0) 0)0 0 0 0 0 0 0 0 m eo 0) 0) 0) 0) 0 00 0 0 0 )n. to O+i 0 •" ,-,- N )0 M M N N o o co O 4 0 '7 0 00 0) 0 O 10 b 00 M 00 N 0)) O0 0 0N 0Of 0) 0) 0 W. a . ., of en 5,000,000.00 8 8 8 u mm o om o 8 ;— b m 0 0 C G a N V FEDERAL AGENCY - COUPON FEDERAL FARM CREDIT Subtotal and Average 3,807,819.46 LOCAL AGENCY INVESTMENT FUND 0 CO 0 00n 3133EFYM3 Subtotal and Average MEDIUM -TERM NOTES 2,000,000.00 1,995,230.00 1,999,958.00 O O O O O O O O O O O O co 0 In 0 U) 0 0)) H N 1 000 Ono Di 0 N. 0i of 0i a 0 v CDCh 0) 0 = N )n M N o 0 O o o 0 0 0 0 0 0 0 0 0000 O 0 0 O o O 0 0 NNNN 5,500,000.00 0 0 0 0 M 3,000,000.00 2,000,000.00 • 1,999,870.00 0 0 0 0 N CO CO n CO t0 N CO CO n D. 0000000000 N8DIINN0NNnn -a 00a-00 0 0 O O CHEVRON CORP. 0 z z 0 0 co F g Z gW w 0 z o 0 Z 2 Q 0 0 V 0 O O TOYOTA MOTOR CREDIT CORP a a a CO CO CO o CC LL LL LL J J J 0 f00 OOf 00 coV O) 0 0) 0) srY g 4 4 M 4 037833AJ9 0) CO M M 3 — CO I,o) 0 0) CO 74977EPZ0 89236TCP8 CO CO 03 (0 CO 0 CO N 0) 0) 0) W 0 0 00) 26,008,780.52 25,968,086.00 26,000,000.00 28,943,977.71 Subtotal and Average RIVERSIDE COUNTY POOL 52,365,679.84 52,365,679.84 52,365,679.84 POOLED INVESTMENT FUND f00 N O SYS052460 62,366,679.84 62,366,679.84 52,366,679.84 52,365,679.84 Subtotal and Average 87,182,279.82 87,131,200.30 87,173,499.30 90,117,477.01 Total and Average PM (PRF_PM2) 7.3.0 Run Date: 12/18/2017 - 15: Report Ver. 7.3.3b J a N_ CO 0 �•; co. 0 0 a Investments 18,743,202.53 18,743,202.53 a o 0 el I, 0 CD C? N C) 0) pa s co )c) m co GOLDMAN SACHS TREASURY FUND 42,456,416.04 42,456,416.04 42,456,416.04 0 0 2,723,150.42 N N of N N 2,723,150.42 T 45,179,566.46 45,179,566.46 45,179,566.46 Total Cash and Investments 45,287,496.19 Average Daily Balance Effective Rate of Return y 12-18-2017 Reporting period 11/01/2017-11/30/2017 No fiscal year history available Run Date: 12/18/2017 - 15:26 a a U � O 0 O O 7 7 olt e 1 Investment # a U GOLDMAN SACHS TREASURY FUND 06/13/2017 GOLDMAN SACHS Subtotal and Average 0) 18,169,375.04 18,169,375.04 18,169,375.04 CO N O 0 0 CA ASSET MANAGEMENT PROGRAM 18,169,376.04 18,169,376.04 18,152,081.90 Subtotal and Average 18,743,202.53 18,743,202.53 18,743,202.53 LOCAL AGENCY INVESTMENT FUND co C) 0 0 OOi N O h N 6736302460 co c.-, 0 0 a N 0 {L N y co O u g0 18,743,202.63 18,743,202.53 18,743,202.63 18,743,202.63 Subtotal and Average N 42,456,416.04 42,466,416.04 42,456,416.04 45,287,496.19 Total and Average PM (PRF_PM2) 7.3.0 12/182017 - 15:26 c Report Ver. 7.3.3b N 2 < m co O a o 0 0 D. Book Value O O O O O G N O '„ a o j 0 N. O) N N W l+] O N v S I 2 a J d gc 0 m a a0 a H V CHECKING Av 45,179,566.46 45,179,566A6 45,179,566.46 45,287,496.19 PM (PRF_PM2) 7.3.0 Run Date: 12/182017 - 15:26 os e ° Investments CO O) N 00 Cs p0p 0 0 O (1. •- O O o�om00 1.4 a 0 C7 00 11,452,575.95 11,452,575.95 11,452,575.95 11,316,338.52 11,316,338.52 n N 0 n t0 Is. O CO CD Ocn W m a 0 VI N N r N 0 1- (0 N co C m N) 0) N 0 N C7 t0 Y O U) (0 r- V A- 0 t") N CO J 0 0 a z 0 0 W CC a cc 0 US BANK MONEY MARKET ACCT LOANS RECEIVABLE - EIP GOLDMAN SACHS GOVT FUND 03 e^ O 0 S 24,341,569.53 24,341,569.53 24,341,569.53 Investments 0 C 2,757,267.69 27,098,837.22 27,098,837.22 a cn a° as Book Value Market Value 0 m CD c 0 7 a m a a C a 0 0 RIVERSIDE COUNTY POOL CO O 0) 0) CD CD (7 CO M 11,452,575.95 11,452,575.95 11,452,575.95 POOLED INVESTMENT FUND 11,452,675.96 11,452,675.96 11,462,675.96 11,452,575.95 Subtotal and Average N N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 n O O O O O O O O 0 O O O O O O O O O O O r 1f) 11) O 1() O if ID CO H) 1D Y) 0 1D 0 0 0 CO W O O a� o O C O C d C O O o O o o G o 0 0 O O 0 CD 01 N N v ddd dd ri.o add_ddddri.dO. D) N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0) r O O O O O O O O O O O O O O O O O O 1t) CO Y) 10 1D 0 1D 10 U) 1[) 1[) 1[) (0 1f) U) LL) U) 0 O O O O O O O O o O o o o o O O O N CD r n 0 0 M 0 N 0 0) 0 O 0 M 0 0 0 0 0 N 0 0 10 10 f0 t0 Is 0:0 0 0 00 0..;1: 0 0 Uri o 0 o ri o v v 0 ri, o ui 0 0 o ao 0 0 M M 0) 0) I, CD a MI 0) 001 N 0 0 M 1'f 10 t0 N V' N N t0 0 D. V: O. O C: CO N •- 0 r 10 v 3 3 M M N C? M 11,316,338.52 11,316,338.52 C.A.M.P. POOL (RDA S.A.) n N CO O 1rD SYS052470 11,316,338.52 11,316,338.52 11,306,667.93 Subtotal and Average 0 0 1O 0 1Nn a n o n 1n 0 OM) 0. 0 0 0 n 17 0 Ui 0 0 0 M 0 a V. 0 0) o 11j 0 0 0 Co r N V N N 1D 0 VM' a N d r f0 r a- N 0 0 0 0 0 0 O M M n r 00010N00000.00100000 N 0 0 a. 1C 0 0 MI CD 10 o 0, Ca 0.:) 0 0) O. 0 0 0 0:O 0 0) 0) O O 0. 0 V G 0 C 0) V• O 0 O N 0 0 0 co 0 0 1D CD N V' N N 10 O V' V: O O Cal.- 0 CO 1D P. aa en0 N (0 M L.A.I.F. (RDA S.A.) (00 a N11 CD Subtotal and Average US BANK MONEY MARKET ACCT r n N. r fn r 0- n n r r r r r r n o0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o O N �V 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 0 aaaaaaaaaaaa 0 0 0 0 0 0 0 0 0 0 0 0 a 8 3 00 0 0 0 25 Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y ZZ Z Z Z z ZZZZZZZZZ Z Z Q Q< .Q << Q Q< Q Q Q Q Q Q Q CO CO m m CO CO m CO CO m CO CO CO m m CO CO CD Co CO CD N N 0(0 CO CO CO N CO CO N N CO 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 C COMCMO CD 000 CO CI COMW OD 10 w CO COD COO CO CO CO 247394001-U 7 7 7 7 7 7 7 7 7 7 7 7 O N C� N M 0 A N 0 1 d N 0 0 0 0 0 0 0 0 0 0 0 0 0 CD CO W W CO f0 1D fD N N M M M n n r CI� ) M M n n n 1D CD so M M M if 0 V• N N N N N N N N N N N N N 224324003-U 220730000-U 236781001-U Subtotal and Average LOANS RECEIVABLE — EIP RDA SUCCESSOR AGENCY co r 0 0 0 0 3 M Subtotal and Average Portfolio RDAS a PM (PRF_PM2) 7.3.0 Run Date: 12/18/2017 - 13:55 Report Ver. 7.3.3b N Z" $ 10 a0 tO a 2 November 30, 2017 V 1*0 0 0 0 0 0 0 0 0 0 0 0 0 0 N CO CO CO 10 CD CO CO 10 CO f0 0 f0 0 CO O 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) r O o O o O G o O O G o o 0 .- aW • s 4 0 N 2 *5 CO 11QQ W (*5 CO CO CO(CO CO NO CO CO C 2 O o 0 0 0 0 0 0 0 0 0 0 la • 2 8 8 8 8 8 8 8 8 8 8 8 .0 IZ o O o 0 o o 0 o 0 0 o 0 M Book Value Market Value 0000000100000 CO CA0 O 0 0 O 0) O O O 0) O O O of. 0 N N CO 10 O O O ONO�• OOO AO O t0 0 0 0 0 0 0 0 0 0) O O O a0 O N N C) co • 0 0 0 0 30 0 N 0 01 N 0 0 N 7 0 0 0 0 0 0 N 0 0 0 O 0 0) O 0 0 0 0 0 0 0 O 0 O O co N M co C) a d N 0 GOLDMAN SACHS GOVT FUND GOLDMAN SACHS GOLDMAN SACHS CO CO s s s N N N 0 0 0 0 S= 2= 2 2= XX a00 a a a a a a a 00 a a s CO CO CO cn co co zd a¢ zd a a a .• . J J J J J J J O 0 C7 C,7 0 (7 C9 0 0 CO0COO00) 0 0 0 0 0 �- N fh Ps h Is Is CD CO CO CO CO CO CO Ci99 N 0 0 0 0 0 0 CO 10 CO CO CO CO N N N CO CO CO N N N 262826003-G 270298000-G 270298001-G 270298002-G 270298003-G O 0 O O O O 10 C0 r r N N 277861002-G 07/01/2016 GOLDMAN SACHS sT co 277861003-G n 10 co N Subtotal and Average 24,341,569.53 24,341,569.63 24,341,669.63 24,744,444.28 Total and Average PM (PRF PM2) 7.3.0 Run Date: 12/182017 M 0 N a RDA SUCCESSOR AGENCY November 30, 2017 2,757,267.69 Market Value O 0 ro 0 a O 0 0 OI 0 a c o am 1 0 a a Investment # a H V UNION BANK CHECKING ACCOUNTS RDA SUCCESSOR AGENCY N CO co } Average Balance 27,098,837.22 27,098,837.22 27,098,837.22 24,744,444.28 Total Cash and Investments PM (PRF_PM2) 7.3.0 12/18/2017 - 13:55 i in a7 § 7 2 00 8 r¥ w 0 0 0 c2 o� in 0 � / d %° a a g§ G q % K y ~ ~ o 0 o 7 g q# Cl 03 > CO- 0 ###& R-c) a.$ 52,668,141.25 52,668,141.25 c a. c 22,654,999.95 22,654,999.95 CITY LOAN TO RDA 69,242,525.07 ci @ @ o 7oJ2 6 \ § k 0O. kKk0co U.S. BANK / LAIF BOND PROCEEDS GOLDMAN SACHS GOVT FUND GOLDMAN SACHS TREASURY FUND LOANS RECEIVABLE - EIP 154,097,395.73 154,097,395.73 154,097,395.73 PI CO tO \csi 2 R$/% al§ ] /hi 2 °° (i 2_ 2 # 0) 2� E a)a i2 0) §■ 1-5 8 £$ $ _ aw 0,Ek f� k% =E c E2 � / c7 C1in � E2 a§ I-6 o - / \ co 0) _ _ c § k § \ ui k 0za $t. §2 ©§§ 20V E E »$$ Co o- p 2 ( 0 @ a c v;/ �k �a%$ w ' -©f =s2f22a 0.2 �-§c §%o _#� B 'Qa k /k§ \ . 8. 2 r) /2 § / .ca. 4- § .,- 0 §ks- 0 0 § \% / 2 & a §■6 k 'EB o t.c 0 U.I& > k _0 . E ) k § ° occ c k � O&§ I- a 2 ■ J 161,650,232.65 161,650,232.65 161,650,232.65 Total Cash and Investments Fiscal Year To Date 136, 11-13-2017 r r r r CO CO CD CO 10 M 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CO CO CO V a V 10 10 (0 to to 0) 0) 0) 0) U) 10 0) 0) 10 0) 0) 0 U) 0) 0) In 0) CO rg..e- O O 0) CO O O O) CO O O) 0) O) O) O 0) 0) CO 0) 0) CD CO CO 0) .- - r r 0 0 0 O O C C7 0 0 0 0 0 0 0 0 0 0 O 0 0 0 0 a p CO COm 52,668,141.25 a 22,654,999.95 22,654,999.95 2222222222aaaaa22222aaa M 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 • u') tO u) 0) u) 1O 0) 4) U) 1O 10 LC) )l) 1l) 10 )f) O If) 1O 0 u) 10 LC) 0) O O 0) CA O 0) 0) 0) O O CA 0) CA O 0)0 CO O 0)0 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 V, Q 0 0 1p 1O 1O 1O CO0 0 0 0 I'. 0 c0 c0 I...CO N.10 N 10 N n O O' Cl n r 1O 0 0 0 0 0 0 0 N O r r.CD O M1. 0 0 0 O�!' m O G O O N N r.:N C NI in m CCO CO d' O CO CO 0 001 17 M n a v CO N 1D 1O b '0' W V' CD N O 0� )) � Upip a a CC0 M t's Is bl 1NA N N N V da co g Q = co cn N CO CND M csi s (� C fA a •1 r to N J 1 d to 0 O m a) r- is.r-- n n n n N. W o O O O O O O O a Lt.1 Z G N N N Q N N N N o ° O O O O O O O 0 d a 0 0 0 0 0 0 0 0 7 a a a a Q 0 0 52,668,141.25 52,617,624.12 Subtotal and Average CITY LOAN TO RDA 22,654,999.95 CITY OF PALM DESERT 22,654,999.95 22,654,999.95 Subtotal and Average U.S. BANK / LAIF BOND PROCEEDS 0 0 1O 1O o 1n CO 0 0 0 0 n CO CO CO n CO n 1D N CO CO n O O CO n 0 O O O 0 0 0 O N 0 r CO '- 0 O N O C O LO O� V' C C C O O N 1V CO C CO n CO C C 33 O V COD GOD (0 O W 0 0 1C) 0 LC) 0 M 0 0 0 0 n O cp CO n M I..- CO N (c0p 0 O O 1O O O O 0 O 0 on N O r CO 0 S. N r C G aa O ti O O C O O CD N Cr-:c0 n 0 0 0 f0 O O O 1[f d' CO N CO CO CO c0 CO V 4 LC) r c7 M M 1O n 1O N M O tD CO 0 v o; '0:CO CO 0 0) 1n M n < LOCAL AGENCY INVESTMENT FUND coCsi Subtotal and Average GOLDMAN SACHS GOVT FUND CO CO CO CO 03 (y CO V) CI) CO CI) 0) CO CO CO CO M CO V) CO CO CO x x x x x x 2 x x x x x x x x= x x x x x x x U¢ Ua v3 vS QUUu¢S Uu¢S Ua UvQSUtQ0t/S yU U¢ Uv0S UNUUQv3 t0b UQ UQ 00 UQ UN U0 vi z z z z z z z z z z z z z z z z z z z z z z z CICICICIDOCICIOCCICI J J .............. J J J J J J J 00000000000000000000000 c9 0 0 0 0 0 c9 c9 0 c9 c9 0 c9 0 c9 0 0 0 0(1C7c9 c9 N 1+) O N CO N 1O n CO O 0 N 141 00 N. CD CO 0 CO CCO 03 O 10 CO0CO CO 1+0) a et - v a v a a v v v v v ‘ry v v Ci CV 0 V1 tt CO O N co Y1 0 0 n 0 O O r O N 6 o O O O O r O O O O O O O O O O r O O O O O O O O O O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 0 0 CO O m M aD CO CO m CO CO CO CO CO m aD CO 0 0 0 CO NCNINNNN NNNNNNNNNNNNNNNNN O O O O O O O N N N N N N N 0 0 0 0 0 0 0 0 0 0 0 0 'Q N N N N N N N CO N N CO CO N CO CO N N CO CO N N CO N V Q O a PM (PRF_PM2) 7.3.0 Run Date: 11/122017 - 15:11 Report Ver. 7.3.3b N df �7, 0 co a1 O. g W 1 Ce N Book Value Market Value O O O O O �0 10 !0 10 11) O O O O O O O O O O O 6, to 0 Co 0 0 0 0 0 CO C O O L O C 0 O aC1:1 al CO CO CO al CO CO al "T • :Ca ka 0 0 0 0 0 0 0 0 0 0 T 00( 0 001 001 v v v v 0 0 0 0 0 0 0 0 0 0 0 0 0 011 {N+1 N v v co ai M O ..- N n N *0 CO0co y .0 N O V. N n V' O N 1*0 I,0 f+) 0 3 v. (0 le.- O N .- N N 0 0 0 003 n M N v N. T CO O N- N A co N a0 00) v V: N O p<p Cl. n v 0 CO 0) n O 0 Y) O O N LL) 0 O � 01 Oi N N N 7 40) 0 0 C07 n 0) N C R° To CB O 4 O co 00 M W 0f 10 V N N WNI N CO a 0 03 a CO 0 00/ u1 s�� 0 N i0 O A O to v M .O0-• N N CO CO CO CO CO ggggg 7 ZZZZZ 0 § g2 g2 g2 0 0 0 0 0 Investment # 0. H GOLDMAN SACHS GOVT FUND 0 0 0 0 0 O O O O O N 0) M 0) 0) S Y N Y 90 00 N 0 0 0 0 O O 0 0 O O O O N N N 00 n n n O a CO NNNN 278985001-G Subtotal and Average GOLDMAN SACHS TREASURY FUND 69,242,525.07 69,242,525.07 69,242,525.07 0 0 S O p 0 p O 0 0 N N n n n n v N N N N O O O O O 0 0 0 0 0 xx gg gg 2 0 0 O 0 O O GOLDMAN SACHS GOLDMAN SACHS 03 0)O O 0 O Y . N O 6736302420 6736302430 6736302440 6736302450 69,241,404.03 Subtotal and Average LOANS RECEIVABLE - EIP CITY OF PALM DESERT 00 3 Subtotal and Average 154,097,395.73 154,097,395.73 154,097,395.73 158,654,877.14 Total and Average Portfolio LIQ Q PM (PRF_PM2) 7.3.0 Run Date: 11/122017 - W U — '- •- — v Ga U� M O O O cn n o o C O Market Value n CI V = 0 o 10 w 6 m Z CC O U HIL 0 LL Ct CO Lai O fi U 0 pd a co UNION BANK CHECKING ACCOUNTS RECREATIONAL FACILITIES CORI Average Balance 161,650,232.65 161,650,232.65 161,650,232.65 158,654,877.14 Total Cash and Investments Portfolio LIQ a0 an 0. a u. cc a a Run Date: 11/122017 - kw CO 03 ae 03 I� 0 CI Ill 03 03 • CI Cs! CD N CO CO CO 0 § to a(0. Q $w • and o a 8k00 -E a2 § k sr 5,000,000.00 FEDERAL AGENCY - COUPON 3,807,819.48 3,807,819.46 CO 0 0 § \§ CO CO 33,225,160.91 33,251,000.00 MEDIUM -TERM NOTES 52,365,679.84 52,365,679.84 RIVERSIDE COUNTY POOL 94,436,538.30 94,396,550.21 94,424,499.30 Fiscal Year To Date 0 Nr c c $ f. ■ § 2 2 0 125,649,781.09 96,543,068.29 Average Daily Balance Effective Rate of Return 11-13-2017 Reporting period 10/01/2017-10/31/2017 Run Date: 11/12/2017-15:22 0 CO W a 2 Book Value Market Value 40 12/11/2017 co co c- N. N. 0) 0 CO 0 CO CO 0 U a D. O 0 0 0 0 0 0 0 0 0 0 0 Z < M N N N N N Q N N N NN N N r� O O .0- 0 0 CO 4- 4- 4- N N N ai 00 0. V. •N- 0 CO 00 0 0 0 0 0 O LL O . - CO CO 44. CO V 10 CO 0 N N N N r — N 0 IX of CO CO CO O CO CO CO ' VI d d N i a O O M �cy) 100 0 )n 0 )0 0 10 CO M O O Y N. CDc() c0 '0 N n O Of P CO O �- N M •sr �- co. M .- M M 'Q Cl• � N o 0.- — 7 0 O 5,000,000.00 0 0 0 0 0 8 )0' M 3,807,819.46 0 o tO `r o 00 0 n 0 00 0 0 01 10 7 7 0- O Y• CO CD (0 O 10 41 CO N CO M CO I4 7 Ix- CO7 a Cr; eo CO t,ac Co CD CO N CO 0al 0) Off) 00) N 0. O O Or) 0 O 0)) 0)0 O OIL CO. 0) N O O O M 7 .- N 5,507,895.48 co co co . Nco O O CO N 7. CO N N O O 0 0 N O O O. Cr; M N N 33,253,039.00 00 o (0y 0 0 0 0 0 0 0 0 0 0 0 7 O f0 0 0 0 0 O O o 0 0 O O 0 0) O C7 Oi Oi N N b I. N O co ch 6 o 0 o o 0) O) 0) 0) I, 0) M O r- CO N CO CO CO CO CO O Z. O h 10 r 10 N— 0 N 0 co co e- D. e. 0 0 )n )n o o 0) 0) 0 0 0 0 ID O) O) O O 0) 0) 0 )0 O) n 0 0 0 0 0 0 eV W 0) CO O 0) 0). 0 N 0) 0) 0 u) 0 0 0 0 N sl srM M — c0 N s' s- N i0 pi'c•) N N M CO ti o m a o 0 v $ 000000000000 N co o o ai o 0 0 0 0 0 0 0 0 0 0 > 0 8 — 0 0 0 0 0 0 0 0 0 0 0 0 o o ao ee o 0 0 0 0 0 0 o O O o 0 w 6 o N. o 0 0 0 0 0 0 0 0 0 0 M a o g o 0 000(0Oo 000000 L O co CO. O O O N O O. O 10 t0 O. O O d 10 c0 CO- M N N O N N N N O M M N N.0 0 0 0 7 0 a e, FEDERAL AGENCY - COUPON FEDERAL FARM CREDIT BANK 0 0 a 0 0 8 N Subtotal and Average LOCAL AGENCY INVESTMENT FUND 0 0 O 0 0 CNI 3133EFYM3 U. 0 0 N co sr sn eh Subtotal and Average MEDIUM -TERM NOTES O O c0 00 Ix- O CO c0 O O N. Ix. O O 0 0 0 0 0 0 0 0 0 0 N N N N 0V N N NNNNN O CO O) O co V' 7 Y c0 N. n N O N O M N N O N N a 017 - -- -- - 0 0 0 0 0 0 0 CHEVRON CORP. CHEVRON CORP. CHEVRON CORP. 000ICO m n 0) V M co sr 037833AJ9 037833AJ9 166764AL4 166764BC3 166764AA8 MICROSOFT CORPORATION 594918BN3 TOYOTA MOTOR CREDIT CORP WELLS FARGO BANK WELLS FARGO BANK WELLS FARGO BANK vooi �vcv csi 74977EPZ0 89236TCP8 89236TCA1 33,251,000.00 33,264,489.52 Subtotal and Average RIVERSIDE COUNTY POOL co N 52,365,679.84 52,365,679.84 52,365,679.84 POOLED INVESTMENT FUND m N 0 SYS052460 52,365,679.84 52,365,679.84 52,365,579.84 54,471,003.79 Subtotal and Average N 94,436,538.30 94,396,550.21 94,424,499.30 96,543,068.29 Total and Average Run Date: 11 /12/2017 - Report Ver. 7.3.3b r 0 E cn C �= eoMM O2 o = o re•o E $ cwn o a o wa J a G vE a o CO v o b O 0 I, N- CO CO N d' O 18,151,485.59 S 7 N Lo • to>CAOD 0 3 00 18,151,485.59 18,743,202.53 18,743,202.53 18,743,202.53 • O 0 42,435,485.37 42,435,485.37 0 C M CD co CO CO 0 Z 0 LL >- N CC 0 0 0) W W 2 re 8 F. co a = c0 o V. C tiE �p U m LL 0 y �le. C 5 CDc)5 c C) a.— 45,288,176.68 45,288,176.68 45,288,176.68 Total Cash and Investments 0 c Eea } 0 0 45,436,445.95 Average Daily Balance tll co co O cif 0) c � N r aci •E o do wa cz mE � 0 a H 4) '- c U O a c o c a c8 f6 _ y O N 0ao Effective Rate of Return 11-13-2017 T N .S 0 •, f.. 'O o Z' e 41 y d) c N _ IC co O a N :c¢ico Reporting period 10/01/2017-10/31/2017 a No fiscal year history available Book Value O pOp R Q O G 7 N N n CO A S 3 0 . (5 I Q m 10 Z CS > Is Is CO C I r L a n M CIS 44) 0H a. 0 a wi wi 3le1 O d = ✓ .O • v w°o Cfioo • w a t e0 N CIO M a n ▪ o J Ir CO 03 O 40 et CO CO 18,151,485.59 18,151,485.59 18,151,485.59 07/01/2016 < 0 CI CL e A < CO o C4 b' G. H Z W 2 W C9 1 .. of g o a co a m a N U GOLDMAN SACHS TREASURY FUND GOLD 0 U 18,151,485.59 18,151,485.59 18,151,485.59 18,134,075.62 Subtotal and Average 18,743,202.53 18,743,202.53 18,743,202.53 LOCAL AGENCY INVESTMENT FUND CO M O O O O) N 10 .- N 6736302460 co r) O O d N O O ai 0 18,743,202.53 18,743,202.53 18,743,202.53 18,723,616.41 Subtotal and Average 42,435,485.37 42,435,485.37 42,435,485.37 45,436,445.95 Total and Average 1/122017 -14:51 o N m Q o a c o R 0 0 1 S V 00 V z 0 0 a c o q•' i a Book Value Market Value a y 0 CHECKING .- 0 M O N N 10 N O 0 N N N HOUSING AUTH CHECKING HOUSING AUTH TRUST 8 0 Average Balance 45,288,176.68 45,288,176.68 45,288,176.68 Total Cash and Investments Run Date: 11/122017 - RDA SUCCESSOR AGENCY T� O w CO VI CO 0 o N CO to 00 O/ 0 0 0 -0,-. 01 ti 0 '" O N. 0 U) o p O •- 0 v O m in O atf n 0 0 O U1 0 0 < R0. Y N m1O 11,452,575.95 11,452,575.95 11,452,575.95 RIVERSIDE COUNTY POOL 11,305,196.53 11, 305,196.53 1,354,000.00 O 0 o O N. m O O m 0) 0 0 0 CO CO 0 CO o UU) .- N (+) CO.N. CO0 v n 0 0 0) 0 CO_ 0 0 CV CO US BANK MONEY MARKET ACCT LOANS RECEIVABLE — EIP GOLDMAN SACHS GOVT FUND 24,330,130.33 24,330,130.33 24,330,130.33 0 O CO n 0 0) m 01 0')) co 0 0 N M c • 0 a 8 ) ca) Uc ry) cC a m .c gfa c (5 COO . V a5 a N 24,662,961.11 24,662,961.11 24,662,961.11 Total Cash and Investments 25,326,853.99 Average Daily Balance r N Effective Rate of Retum M 0 Z. C C O ts 0 co U m v« 0 C O a C .5 m C m E m m O N U-0 E8 U co c v O!n.O T P..N E Q as L E 3 0 8 a U mQ a co E E U co 0 0 O E O o Oma ar m N u c E O m = = O c« m N H U _ �a8 11-13-2017 c iL Reporting period 10/01/2017-10/31/2017 No fiscal year history available Run Date: 11/12/2017 - Market Value 0 0 0 0 cn Dat o Ce 0. a a co RIVERSIDE COUNTY POOL h r 0 11,452,575.95 11,452,575.95 11,452,575.95 POOLED INVESTMENT FUND 0 11,452,575.95 11,452,575.95 11,452,575.95 Subtotal and Average CO • (0 • r v T T 0 m 11,305,198.53 11,305,196.53 11,305,196.53 C.A.M.P. POOL (RDA S.A.) T T T 11,305,196.53 00000000000000000 Oo O O 00000000000000000 0 0 0 0 0 0 0 0 0 0 0 0 0 (n 0 0 O 0 0 o O o O 0 0 0 0 O 0 0 0 0 O 0 0 O 0 0 O 0 0 d a d d d d d d d d d d d d d d O. T (+7 (0 0 M ✓ et co 0 0 0 o O o o O o 0 0 0 0 0 0 0 0 O v 00000000000000000 0 0 0417 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o 0 0 0 0 0 ai r n 0 0 is O v) 0 co O N O v 0 O co O O O ID 0 0 0 O 0 O t0 0 0 0 0 0 0 0) O O O no O O 0) CAC O N� N G O O CO (O C O C N C O O N 0 0 CO CD N 1) O00) N 0 CO 0 O NCO T 0) C N (1. ▪ C7 T 0 0 r O (•) O co0 N 0 er 0 0 CO O O co N. P. a cO CO 0 0 0 0 - 0 0 m 0 0 0 0 0 0 0) 0 0 0 n 0 O co ri t` 0 o c0 La (0 0 0 0 in (0 0 0) 0 0 0 0 C O o O CD 0) 0) r 0 0) 0 CO 0 N 0 O 0 a- CO CO N 1 0. N 4D 0 •l CO O O O a T 0) CO CO .r- N DI 4- r CO N. n o o r O co o a0 O N o 38 e- 0 CO 0 O 0 CO CD 0 0 0 0 10 O (0 0 0 Ts. 0 iO 0 0 0 0 A 0 O (d r: 1: o o 0) ID 0) 0 0 0 03 o0 0 0 0 0 0 O (0 o O CO C) CA r )n 0) O co 0 N 0 0 a -CO CO N M. 0) N N O sr CD 0 0 O CV a) co m 0 10 O N 0 (1 r T n 0 40 CO C0 0) Subtotal and Average L.A.I.F. (RDA S.A.) N 0 et 0 ID COO n sr N CO N • M LL 8 Subtotal and Average US BANK MONEY MARKET ACCT r r r r r r r. n r r r- n N r r r 01 00000000000000000 $�V N N N N N N N QV N N VV N N N N N O O O O O O O O O O 0 0 0 0 0 0 0 O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 YQ YQ Yq YQ Y YQ NC Y Y Y YQ Y Y Y YQ YY ZZZZZZZZZZZZZZZZZ a Q 07>777CO 77777777CO a7 O N (0 V' r CO O) if)�{ (0 of 0 co In CO r O) et CO CO O 00 COO COO COO COOCO OD z CO 00D CO CO COO CO 247394001-U 247394003-U 247394002-U O CV 0 0 CV 0 0 0 0 0 0 0 (O1i�nr°0. v NNNN▪ NNsr 01 CA • 03 253446000-U 253446001-U 0 0 0 0 0 0 0 0 0 0 0 0 1 et sr O T N N N N CO CO (0 O (0 O N N N NN N NNNNINN co 0)) ((0 Subtotal and Average W LOANS RECEIVABLE — RDA SUCCESSOR AGENCY (00 r Subtotal and Average PM (PRF_PM2) 7.3.0 Run Date: 11/12/2017 -15 Report Ver. 7.3.3b N 01 3 m 0 D. >-o H Z W = cc a% N o c (/) �v y W C)2do 0 cn a °O t rea° CO m CO w m 0) 0) 0) a c o rn of G 0 C 06 O O C 06 0 0 0 cn ▪ 0 N • et • W 2 Jo i h O O O O O O O O O O O O O O M 1l1 O to N t an to o to to t0 u'r to et O O O O O O O O O O O O O O u) t0 b t0 O t0 O CO O an W 01 COW 0)0 01 0 01 T O 0) a- 000000000000 co) Book Value Market Value CO O CO N 0 O A O CD N O O O O N O O O O O V n o0tc000o000 0 Q1 N N M CO 10. CO to co O V O A O CO N O O O O 0! O t0 O N O O O O O Y CO 0 0 0 m 0 0 0 0! 0 0 0 Oi o toN NCO COO 01 - O O CO 0O 0 O .00400000 os od O 4 C CO 0 0 0 criO 0 0 0 oi s. 0) N N CO CO d O 0 d co 2 a CO0 o c Qm 0 d C a W 0 GOLDMAN SACHS GOVT FUND CO NCS O 0 0 07/01/2016 to N 0 0 CO CO CO CO CO CO CO CO CO CO CO VD _ _ _ _ _ _ _ _ _ _ _ _ Z Z Z Z Z Z Z Z Z Z Z a Z IgglIggggg O 0 0 0 0 0 0 0 0 0 0 0 C07f0700C07C07CCDC070U' 0U' C0700 0 0 COO COO N CO 0 O O O - N M A A h h CO coOD CO co Co CO c0 262826000-G 262826001-G 262826002-G O 0 (,0 O o O O co CO N 07 N O m A N N 270298001-G 270298002-G 270298003-G 277861000-G 277861001-G 277861002-G 277861003-G n CO• Subtotal and Average 24,330,130.33 24,330,130.33 24,330,130.33 25,326,853.99 Total and Average Portfolio RDAS Run Date: 11/12/2017 -15:46 en 0`0. iS $ k cc coo C G V io co to d Q 9m co i 3 0 o o0 m w v o— co t N CO 0 CD CO C) 0 O O 0 0 0 C O aL 0 0 con 0 fV fV 4 52,615,940.22 22,654,999.95 22,654,999.95 CA 0 01 0 m m 0 0 N N N O N N. 0 0 ri a 0 N 0 I' CO N N 0 m csi 4,355,512.69 4,223,522.15 N O 03 0 N 0. CO O C) N N 03 01 10 10 M 30 10 Ni 10. 0 M N uN) N V CITY LOAN TO RDA U.S. BANK / LAIF BOND PROCEEDS 69,207,772.70 69,207,772.70 2,074,000.00 3 0 0 0 r 155,131,747.71 155,131,747.71 155,131,747.71 0 0 ci v co 0 st 0 z 0 LL re u.zya. m 560 cc Wo c CO W CO ccd H Czziii 1 r 8z oo< > Ro 009 . U a8 co co 01 3 159,609,688.55 159,609,688.55 159,609,688.55 Total Cash and Investments Fiscal Year To Date c E ° w `1 O 0 128,709,142.98 141,990,033.42 Average Daily Balance Hai co yyy C -2as as tll Jo C > • N y aci COCL do y— O 2 g7 •C 8 m w • U ac d C. o E w O C cv O a) 0_ 0 cng_ •E to m co c >, E o a� oU o « Y e Cel of CI C f/1 y 0 O) L �. O -00 In E� a1 •� y U00 c c E. E E o > 0 (co j 0. m. c g ono p C O o 0 0 o y0d O 9 a O. N wl r C o L 3U m N E� c o 8 1 c2o Q. L y o3� o .c o.�L C y �L 0 c y Hda Effective Rate of Return 11-05-2017 Portfolio LIQ Reporting period 09/01/2017-09/30/2017 Run Date: 11/05/2017 - 16:30 CO CO CO r gr. 00000000000000000000000 •cra- - e- N N N N N N N N N N N N N N N N N N N N N N N !- • r O O) O) O 01 01 0) 0) O) O) 0) O) Of 0) 0) 0) 0) O 0) 0) O) 0) O1 ▪ • O O O O O O O O 0 0 0 0 CO 0 0 CO 0 0 0 0 0 0 a 0 2 co co 22 Market Value 52,615,940.22 52,615,940.22 52,615,940.22 22,654,999.95 22,654,999.95 22,654,999.95 22,654,999.95 22,654,999.95 22,654,999.95 Q•T2Q•Tali•22aa•2Q.T.Tali.T111 00000000000000000000000 N N N N N N N N N N N N N N N N N N N N N N N CO O) W O) O) O) O) CO 0) O) W O) O) O) O) O) W W 0) 0) O) CO O O O C G O O O O O O O G C O O O O O O O C 0) CO CO O )O )O a CO CO 0 0 0 0 0 O) CO 0 0 N W N W W eD 7 0 0,- O) W .- O O O O O CO O co Q) 1� f� O N N N O C C C G G O e0 0 0 0 0 a0 N 1n e0 e) N co eb O W U) - W m - CO 0) N M 0 u) )0 b M 10 .- CO • N eD co O N V 0) O COOCO CO 0 CO M r` e- 0) Of CO 0 r V7 10 0 0 0 0 O) N (0eD v, 0 0 f- O) 0CO— COCDO O O O 0 COO COCOCOv COCOCOO) ', r` f` O er N N N V r-:•ft G. Y) eM+) CO O 0 r CO CON • N 0 001 O N of CO CO O 0 CO CO r r r ✓ V 4,355,512.69 O) CO 0 u) u) CO M 0 0 0 0 0 CO CO a 0 01 CO N CO CZ! V' O O .- O) O O O O O O CO O CO 10 a O) n O N N 7 0 0 0 0 10 G C O O C0 N CO 0) N co CO od O O 1WO 10 CMO u) r W .Dr Is. CO N t0 O) M ▪ ea v O agoci • 70'N. 0 V 0 m r-. r- r- n n n r- 0 N N N N N N N O O O O O O O O 0. o 0 0 0 0 0 0 0 m m m Q m Investment # 32,420,613.27 Subtotal and Average CITY LOAN TO RDA CITY OF PALM DESERT } rn 22,654,999.95 Subtotal and Average U.S. BANK / LAIF BOND PROCEEDS LOCAL AGENCY INVESTMENT FUND 3 0 M 252026003 Of N 10 M Subtotal and Average GOLDMAN SACHS GOVT FUND CO CO CO CO CO O) Cr/ CO CO CO CO CO CO CO 0) N CO CO CO V) CO CO CO = S S S S S= S S S S S S S S S S S S S 2 S S z z z Q z z z z z z z z z z z z z z z z z z z z 0 0- 0 0 G G G G G G 0 O O 0. 0 o 0 _1 O G J J J J J J J J J J J J J J J J J J J J J J J 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N M st 10 CO N N h CO 0) 0 N u) CO is. CO 0) O CO CO CC0 eleCO V+) tW+) ela v 4 4 4 4 v .. v v v v v v v v CO N a 6 N A4 r` e0 6 N A 4 6 6r. ao W 6 .- O O O O O O O O O O O O O O O O O O O O Go O O O O O O O O O O O CO CO W CO m CO W CO CO CO CO m m CO CO CO CO CO CO NNNNNNNNNNNNNNNNNNN o 0 0 0 0 O O N N N N N N N O O O O O O O O O O O O i0 1n W 10 10 u) m CO m CO CO CO CO CO CO m m CO CO NNNNNNNNNNNNNNNNNNN 261470000-G 281470001-G O • 0 8 co N i a Run Date: 11/05/2017 - 16:30 Report Ver. 7.3.3b N Vo N mO O. 2 0 Book Value Market Value c d C e. d Q: N m co W n coO (D V O �w • C` M UO CO CO O CI v, c • to N O aM- N tn0 4 O d W H C() n CO CD :C� M L cm a • co I n N PI r°'i C .0..- Ili N O N c 3 F_ pG cu O .Ti co N 0. t .O O. a 6,1 co O O O O O 0 O O O O 0 0 0 CO NNNNN N O O O O 0 0 0 0 O) O) O) O) O) O) O O O O O O O O 0 0 0 0 0 0 0 0 0 0 0 0 0 11111 O O O O O NNNNN O O) W O) co O O 0 O O CO - 6... 0 u). 1On 10 • O . N ▪ - N a Co O, la Cr; of of of CO N 1MO n Nat 15,332,554.10 W 3 CO V n <c 0 0 • 0 22,393,802.00 co co n co O QVO • ;) LO O'0 N V' CO Vi CV n cc; N 4 V' CD ON) b i CO ▪ m � COD 000 i) in • N N M O 0 0 N o) M � N O N N m 0 0 CO C/) CO CO CO • S• QQ QS Q2 SQ • g N N VS VS m • ZZZZZ 0 O CIOCICI J J J J J O 0000 CI C a N U GOLDMAN SACHS GOVT FUND 01 N C ) P9 cN) CC ) v v v e v 274729001-G 278985000-G 278985001-G Subtotal and Average GOLDMAN SACHS TREASURY FUND 69,207,772.70 69,207,772.70 69,207,772.70 O 0 n 2,074,000.00 • n n n v N • N N N tON` O O c c 0 0 0 0 0 V) CO co co S T T U U U 0 zzzz O O O O J J J J O 0 0 0 O 000 co O) O ✓ ' . 14 6736302420 6736302430 0 O N N CO00) CI) 0- CO n n CO CO 69,207,772.70 Subtotal and Average LOANS RECEIVABLE - EIP CITY OF PALM DESERT CD co co ›- co O O 0 0 O N Subtotal and Average 155,131,747.71 155,131,747.71 155,131,747.71 141,990,033.42 Total and Average so Q o � o 0. 0 d 0 0 0 0 0 O 0 0 3 CO W CO > '• � CO 0 .0N "a o N. ti (0M Market Value N COCO N 0 in O O l n m M 3 O1�� > to cO 0 N O. c 0 O. n tD t) i ar n n L N N 00 CO m O 159,609,688.55 159,609,688.55 159,609,688.55 141,990,033A2 Total Cash and Investments a Run Date: 11/05/2017 n o corn n ,- oaz c ;e v ri ri ad C7 CD O o o. r Y o o o m a m ca • m 03 aW 5,000,000.00 4,998,600.00 0 0 O O ui 3,807,187.89 3,807,187.89 3,807,187.89 z a 0 ouj U z e • J • ul • 3 33,266,140.13 33,235,086.48 33,251,000.00 MEDIUM -TERM NOTES 58,304,433.37 58,304,433.37 58,304,433.37 RIVERSIDE COUNTY POOL 100,377,761.39 100,345,307.74 100,362,621.26 Fiscal Year To Date CO I N Current Year 135,457,477.79 120,655,944.17 Average Daily Balance Effective Rate of Return a, Oc o N tg o 2 . H 3 H c O oa a* m o E c 0 H L a°a Y N c Ea mO c m C Qh O E� 4 (a V) yj 0 r O O E:: aE .) a� • c E N '2 • cob «' c a c o = t5 To e115 'v Y f0 UE ca�i N E> cO d • 0. •Z E • f6m N m N w O G1 0, se O c a w U g L N N L a c E o▪ N c co 0 o u, .c • E y 0 O > N y O1 ego. E g • 0 c = 0 y C, C :crndco 11-05-2017 Reporting period 09/01/2017-09/30/2017 Run Date: 11/05/2017 - r y- r.. m m r- r- r- 0 co m CO m CO CO �o000000000000 0 g 0 NNNNNNNN N N rC�V Q CO 0- 0 0 0- CO a N N N a 0 0 . — - CO CO 0 0 0 0 0 n P r r at a-LO < CO CO CO t00 a0 CO CO CO CO rs N N m N ,. 1"' 1 Hai 7 0 0 pp pp m U) LLp') M CD ti 0 LC) 0r N. OOf al cq r N ch e- N c+l 0 0 M M N 0 0 r r r 15 r N N � r p o 0 0 v v O o 0 0 0 0 0 v co. 0 0 3 0• 0• 0• 0• 1 • • COO, m m N O 'r m cq 'O4 N t2O LO co co daa v a0- 0 0 CO Pm" CO 0 co co 0 0 coo o 100 0 M CO0 COO0 0 O 0 0) n W N 0 CO CO N n 0 ri r, 0 CO CO- O 0) 0) N CO N O O O 0) 0) 01 LC) 0) 0) 0 0 0 0 0 0 CO CO. O 01 O) N 01 O) O U) U) O OO O VS CI a- V N a- r N O co C0 N N O O 0) 0) O O O m O O O O O O O O p O m CD O O O O) O O O O U) O O O O 0 n n O O U) sr O co 7 Si0.:OD OS 0 0 CO CO N N CD MI V COiO O N r CO_ O r CO el V;, O N m m m Y 00 CO- n n U) 0 0 O O) N N c7 0 N 0) 0) O O O) 0) O �O 0) m O O O O O O 0) O) CO OO 0) O) O N O) O) O U) U) O O O 0) sf Q ci M < uo N r r N Ui co- o N N d r W d N 0 °fm C°'o 0000000000$o 0 co = O 0 o n 0 0 0 0 G O o0 0 0 0 0 0 o 0 - - 0 0 0 0 0 0 0 0 0 0 0 0 /1 C 1 M W o N- o O O o 0 0 0 o O o o O V i y o 0 o O O o u� 0 0 p 0 0 0 p 0 :1M p m Co O O O N O O O 0 U) O D O Z 5 41 U) idcoM N N i0 N N N N m M coN N 2 e E o Q, V O d a 7 (n 0 y CO CD CD OD CD n CD CO 0 CD CO n cO p 0 0 0 0 0 0 0 0 0 0 0 0 G N N N N N N N N N N N N N 0 ' m c�+ 0) O N N n n N O N O c") N O N N a a ? o 0 0 0 o 0 0 Is CM 0 00 a Z N mW � t00 ? N LL 0 O- ct W OC 0 f- 0 } Ct re n p Z 0 0 P. Z 0 0 d CC V Z Z Z Z a m as e UUUUz 000 0OOO 3 ZZZZZZ< 2 LL<C aZMa<HLL g uiuiOW- 0000 J J>%> ceO O O J J J d 2 C FEDERAL AGENCY - COUPON FEDE Subtotal LOCA 0 CD 03 CO 3133EFYM3 N Subtotal MEDIUM -TERM NOTES O 0, ,r co m co o m ( 3cti��P*10w1�---, CO 00 m n 0) rn- 0m') CO) COOCO CO 03 0 0 r 0 r m m 0) 0) 0) 33,266,140.13 33,235,086.48 33,251,000.00 34,434,322.91 Subtotal and Average RIVERSIDE COUNTY POOL 58,304,433.37 58,304,433.37 58,304,433.37 POOLED INVESTMENT FUND 10 0 SYS052460 58,304,433.37 58,304,433.37 Subtotal and Average CO 100,377,761.39 100,345,307.74 100,362,621.26 120,655,944.17 Total and Average PM (PRF_PM2) 7.3.0 Report Ver. 7.3.3b 0 j r co co - R o w ,3 cX O C a 0 CO o a`?? 0 0 co 18,133,495.29 co 0) 0 O 0 ar 0 18,692,605.06 M N 0 0 in Yo co co oi N co co m O O 0) m 0 co 0 ui GOLDMAN SACHS TREASURY FUND 18,133,495.29 18,692,605.06 42,364,116.74 42,364,116.74 42,364,116.74 O 0 3,044,224.87 3,044,224.87 a - CO a.! 0 r 4 45,408,341.61 45,408,341.61 45,408,341.61 C up c 0 W wcg 0 M 2 E 41 a d 1 2 a)us 8 1712 c ot pi SS :13 C m C R r y .§ 8� Uco -iv " `° } W c aLL m w to- '� 9 d og 0 o 10- 1--0 45,297,345.68 Average Daily Balance vi E X y w N 0 .0 N 0 0 0 E 0 0 z0 s o N N o c r c co C E cc 0 N O C{. 03 a U O o C 0 CL o a c 8 io_ 10 o a Effective Rate of Retum 11-05-2017 Reporting period 09/01/2017-09/30/2017 No fiscal year history available 0 a 2 o co S4 0 0 10 10 0 o � 0 0 0 .Oi. ii .- •- .- — .- , T in et i w a. co Q 0 a 5 7 (7 c0 iC e O Y M M O N . 2 Q 49 g I. en g ZCIS c o > m 10 CO C I M se o O 0 CO CO D al eni- 0. n el I. .G w: W C d co O O co 0 m W a .°cs 0. a 0 —J Q o)0o 01 a E� >� 10 a m 7 0 0 Investment # a_ co U GOLDMAN SACHS TREASURY FUND GOLDMAN SACHS N Subtotal and Average 18,133,495.29 18,133,495.29 18,133,495.29 18,133,495.29 18,133,495.29 18,133,495.29 18,116,978.96 Subtotal and Average 18,692,605.06 18,692,605.06 18,692,605.06 LOCAL AGENCY INVESTMENT FUND m c+) 0 N O '0 e- N 6736302460 m f+) O O a N O N LL N co g 18,692,605.06 18,692,605.06 18,692,605.06 18,692,605.06 Subtotal and Average 42,364,116.74 42,364,116.74 42,364,116.74 45,297,345.68 Total and Average Run Date: 11/05/2017 -16:46 Report Ver. 7.3.3b N Q 0 Ol 0 CO a lo 'gym 0 0 0 0 0 0. 01 0 n 0 7 CO o CO 7 N co .0 Y N 0! M_ o N N CO m o V $ N Y1 O N co 0 co co NC N a 2 N6. O O 0 CO S N J z N Lu z z ro Q Q Z Z 7 7 0 0 x z m 1 e ,n m co o 0 0 N N N 0 z 10 m Y a v 10 W N N _ } Y 0 0 CO CO Average Balance 45,408,341.61 45,408,341.61 45,297,345.68 Total Cash and Investments 0 a PM (PRF PM2) 7.3.0 Run Date: 11 /05/2017 -16: 0> Z 0 0 0 0 N 3 N a O 0 0 j 0 0 -fu W .0 o 6 at Y 0 COTo 0t To It CO O 41 M 10 N 0 0 of CO CO p V' O n V' N p N oi N O COf0 O O 11,444,755.47 11,444,755.47 RIVERSIDE COUNTY POOL 11,293,991.72 14,699,952.45 14,899,952.45 0 n o 10 o n N 10 0 O CO V N �O 01 L0 0 n is; V 0 t0 N 10 CO 0 Di CO w 0O n 01 .0 O 10 o) 0. 1L U 5 US BANK MONEY MARKET ACCT 38,896,128.10 38,896,128.10 38,896,128.10 0 O 0 0 M t0 O O M ID 0 ^y a LL wEd 5 co 0 8 min d w Q . c Ud Um h 8y 31 ceCO O0 U O. 39,507,758.20 39,507,758.20 39,507,758.20 Total Cash and Investments 03 e n W M 0 2 O E N co 39,421,570.37 Average Daily Balance Effective Rate of Return w O .0 0 0 16a tco 01 N L CO 1— Q V1 o8 C e l0 0 E N ai 7 Y d c co • �i m o d N 8 a1 c C w O N C e 0 0 U to - m CU E To C 0 a, w0 .ca e m CI M 0 O 7 O U f/) N E. e U C w Ec a1 e2 c o l4 M e w ._ Toco 0 p1-. 0) U G c O N T O C E N 0 w :2 E O eU a E0E c N !°0 0 a o oma O. y E�0 O C N 1G 0 cs fa In_ en 11-05-2017 Portfolio RDAS Reporting period 09/01/2017-09/30/2017 No fiscal year history available Run Date: 11/05/2017 - 1 a 0.07 f0 8 a a 0 O C t0 Z C m W Hc a w cv o O cCO CO ca •�") CO - ✓ ,O)E ✓ O G. .2 w ✓ a° at 016 eo v a co 0p • — 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 a M of V' 0 0 0 0 0 O O 0 0 0 0 C. 0 O O p O p O O N N r • ' M O M 0 N 100 M 0 0 0 0 0 0 O N �l) O b O a 0�. C 0 O O C O O O G G G O O O C O O O O O 2% - 8 3 0 () M (I. 01 O NI- sr .0 W a. 3 la 7 0 Market Value a to mF 0 a 0 0 w to w N a CC 11,444,755.47 v to v a�p b n 11,444,755.47 POOLED INVESTMENT FUND SYS052470 10 r 11,444,755.47 Subtotal and Average 0 11,293,991.72 11,293,991.72 11,293,991.72 C.A.M.P. POOL (RDA S.A.) 11,293,991.72 11,293,991.72 11,293,991.72 Subtotal and Average d d d d d d d d d d d d d d d d 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 00 O CCD to uo O In O O O to O o O 0 O O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0) O) OMco r r 0 O CO r 0 C) 0 M 4) O 10 o CO 0 O 0 0 O1 0 0 CO 0 n 0 N 0 10 N 0 N. 0 10 0 0 0 O CO CO CO O CO r CO CO M NOe� O) 06 O ea- tNp N c') M CD CO . O O N M +- 3, 3 0) Of 0 0 O) 0 CD 0 M 0 0) 0 r 4D 0 3 0 COO O N O ✓ r O O r 0 CO O CO N to O O oO O^ O N O a N O r O • O 0 0 COcn CO CD CO O ao h CO 40 M P 0) is - M CO COO ' 0 0 C7 M N C) N 0) O O COO, N N 0 CO O CCO 0 0 0 COO. 0 )[ 0 rn OOf o 0 CO 0 tn, O N o v N 0 r, o h o 0 0 CO t0 10 CO O o r co 0M r- 0 0) ▪ O t6�*p N M CO CO t O O M M N C+) L.A.I.F. (RDA S.A.) co Cn co a 1 8 (.) 5 t}o c Subtotal and Average US BANK MONEY MARKET ACCT 14,699,952.45 14,699,952.45 14,699,952.45 0 00 0 0 eet r r r r r r Is r r r r r r r r r r o O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O NCNINNNNNNNNQVNNNNN N SO0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 a a a a a a a a a a acavvvrr 0) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Y Y Yq he heY Y Yaa a he he NC he NC he he he he zzzzzzzzzzzzzzzzz gggggggg tn' f!) N to to to N q) to u) co 0) V) N V) y (f) 0 N M e r CO 0) yN4 a M '7 �0 CO )0 CO r 0) Y CO 000 coMCO CO m CO 01 00 CO 0 10 CO CO COO COD COO COD 247394001-U 247394003-U 247394002-U 247394000-U 236781002-U 7 7 7 7 0 0 0 0 0 00 00 0 00 n 6- N N N N N 253446001-U 224324000-U 224324001-U 224324002-U 224324003-U 220730000-U 236781001-U 14,699,952.45 Subtotal and Average LOANS RECEIVABLE -- EIP RDA SUCCESSOR AGENCY co r m 0 O s N Run Date: 11/05/2017 - 17:02 Report Ver. 7.3.3b N ea co GZ _u+ co m m m m m co• m co co ▪ CIS CO 2 0 0 o 0 0 0 0 0 0 0 0 0 NNNNNNNOINNNNlaS A 0) 0) 0) 0) W 0) 0) 0) 0) 0 O O) 12 $ 0 0 O O 0 0 O 0 0 0 O 0 cn 0 co n 0 N O Is 0 R) N 0 0 Is 7 O 0 n O n O N O O) 0 0 0 10 O 3 C n a O G O O C O coN Y • a. N con O O Cl N' O O O CO c") N. 0 N 0 n 0 10 N 0 0 n 0 O. Is )- O N O. CO 0 0 ID/0 n O 0 0 G o MI VO O a 0 c.i 01 O) N M n 0 N IN O O C) C Z C d Q Q% N m CO N. 0 N 0 Is 0 It) N 0 0 Is7 O 0 n 0 n O N 0 O o 0 0 b ��//�� �^ ` O V C C O C 0 G C O A V/ :Q ) CO d a D1 IA ON) N ✓ O d i C) S o n. N D •3 N 00 0 CO CO Qat ro s s ss N N N N O. a Cl ° s o os re n n n n 0 0 0 0 0 0 E c CO CO CO CO U) CO CO CO CO V) CO U) _ _ _ = _ = = _ = _ _ = 0 0 0 U 0 U U 0 0 0 0 U Z Z Z I Z Z ill Z Z • O 1 D O 0 Investment # GOLDMAN SACHS GOVT FUND O 00000000000 000000000000 O 0) 0 0 N - NCO CO 0) 0) 0 0 0 0 n n n n coco co co w co co co C9 9 0 0 O - N 1+) coop O O 00m CO 0 NNNN CO O CO CO NN0 m CO 0 NNNN 270298000-G 270298001-G 270298002-G 270298003-G 277861000-G 277861001-G 277861002-G 277861003-G Subtotal and Average N 0 0 0 0 0 0 0 0 0 0 0 o 0 NNNNNNNNNNNN N O) Q) O) O a) O) Of W O QJ a) W O) W CC!CDO O O 0 0 0 O dada O O 2 W - n 38,896,128.10 38,896,128.10 38,896,128.10 39,421,570.37 Total and Average Portfolio RDAS • 0 S 7 a 0 m. coo eta a a±