The URL can be used to link to this page

Home My WebLink About02 Compliance and Investment Report - May, June, July, August 2021CITY COUNCIL ACTION APPROVED RECEIVED --:fr-F.,..1-:-1-ec~j--: ~~:~~----- MEET~GDATE IO ·IY · '2.()2,1 AYES:Ht1 rn' K,.Joo:!dt::, ::b-:::ti~n7. Nt e::s=t~~nq-:7•e:7· ;;-Q,-1,-n'"7:m-=-· n-,-:-:ll -q-c1~1.t-1! ES: N0,1( '1 I i.~flW/ ENT: ~n-t TAIN: iiohe City of Pc!J m Desert . _IFIED BY: i\J u:1 I srs Investments Summary igmal on File with City Clerk's Office August 2021 The City 's investment portfolio is detailed below . Investment transactions were executed in accordance with the California State Government Code , the City 's Investment Policy and all bond indentures . Cash is sufficient to meet the next three months of expenditu res until additional revenues are collected . Investment Portfolio: $ Millions Beginning Ending Book Value Purchases & Redemptions & Book Value %of Asset Class (8/1/21) Deposits Withdrawals (8/31/21) Portfolio Agencies $ 6.00 $ 6.00 2% Corporates 38 .99 38 .99 14 % CAMP Pool 10 .76 10 .76 4% LAIF Pool 65 .50 65 .50 24% County Pool 79 .38 79.38 29 % Custodian ® 57 .30 (2 .25) 55 .05 20% Trustee® 0.18 4 .93 5.11 2% Cash 6.34 7.05 13.39 5% Total $ 264.45 $ 11.98 $ (2.25) $ 274.18 100% ® = Restricted funds based upon bond indenture terms . Changes to the portfolio include the addit ion of $5M in bond proceeds , $3.4M in reimbursements , $2 .7M in sales taxes , and about $1M miscellaneous revenue deposits . The redemptions include $2 .25M for projects including San Pablo and President's Plaza parking . Portfolio Allocations , Maturities and Performance: Investment Allocation Investment Maturities Restricted -23% (Custody-Trustee) Local Govt Pool 60% Corporate -15% Age n cy )2% 15% 11 ~--•~I_I __ _ 1M 2M 3M 6M 1Y 2Y 3Y 4Y SY Performance -Total Portfolio 0 . 70 % ~City Yield 0 .60 % 0 .50 % 0.40% 0 .30 % 0 .20 % 0 .10% 0 .00 % -LAI F Yield ~ Ou-~d' ,;/' /:!,,., .... '<~ ~l .,..~· ~'I>.., ':l' -.,<!' .,_.§'> c,,0~ ..,,,, CITY OF PALM DESERT PortFolio Managemen# Porkfolio Summary August 31, 2021 InvestrneMs CAMP U.S. eANK! LAIF BOND PiZOCEEDS FEDERALAGENCY-COUPON LAIF FEfl�RALAGENCY-CALLABLE TRUSTEE CASH BALANC@S MEDIUM-TERM NOTES CUSTODIAN PROJECT FUNDS RIVERSIDE COUNTY POOL Investments Cash and Accrued �Merest PassbooklChectcing {not induded m yield calculations) Accrued Interest at Purchase 5ubtotal Total Cash and Investments Par Value 10,762,592.67 3,770.21 3,000,000.00 65,489,582.51 3,000,000.00 5, � U9,950.07 39,00O,OOD.00 55,048,819.fi7 79,377,745.94 26D,802,461.01 13,39a,514.90 274,792,975.91 Market Value 10,7fi2,592.87 3,770.21 2,987,120.00 85,499,582 51 3,003,570 00 5,1p9,850.07 39,411,fi30.00 55,048,819.61 79,377,745.94 2fi1,214,T81.01 13,390,514.94 3,345.83 'E3,383,860.73 274,fi08,641.74 Book Value 7Q,762,592.67 3,770.21 2,959,562.69 65,499,582.51 3,000,000.00 5,109,950.07 38,991,254.D0 55,04$,819.87 79,3T7,745.94 260,793,277.70 13,390,5'E4.90 3,345.83 13,393,860.73 274,187,138.43 '�6 of Portfollo 4.13 0.00 1.15 25.92 9.15 1.96 14.95 27.71 30.44 100.00% oaya to MatJCall 1 7 149 1 331 1 498 1 1 69 Term 1 7 '1,188 7 7,096 t 1,042 1 1 183 1 1 69 183 YTM1C 365 Equiv. fl.U50 0.227 0.530 0.227 tl.400 0.030 1.5D5 0.030 0.289 0.368 0.000 0.388 Total Eamings August 31 Month Ending Current Year 84,928.91 - — Average Daily Balance 268,948,034.04 Eifective Rate of l2eturn 0.37°/a This investment portfolio is in compliance with the provisions of Califomia Go�emment Code Section 53601 and the City of Palm Desert investment policy. Barring unforeseen events, it has suificient cash o fund city expenditures for the next six manths, Union 8ank Custody Services has provided market value prices for al! corporate securities. All balances are bank 6alances. The "0�6 of " calcuta ' on the Po lia Su mary page omits demand posrts 9a��Janet . oore, Director of Fina�ce/City T asurer / Reporting period OBIQ11202f-0813112021 Run Data 09121r+'o2t - 1c�36 No fiscal y�ear history available Portfolio CITY AP IE {PRF PMi j 7.3.11 Repart Ver 7.3.11 CUSIP Imeskment * Issuer CAMP CITY OF PALM DESERT PortFolio Management PortFolio Details - tnvestments August 31, 2021 Average Purchasa Balance Q� Par Value Markat Va�lue SYS13 13 C.A.M.P. POOL (ClTY} SYS12444 12444 C.A.M.P. POQL (D�SER7 WILLOWj Su4total and Average 10,762,734.21 U.S. BANK ! LAIF BpND PROCEEDS 252028003 92-33-084 LOCAL AGENCY INVESTMEPET FUhD Subtotal and Average 3,770•21 FEDERAL AGENCY - CQUPON 3'E30ANAC4 664 FEDERAL HOME LOAN BANK Suhtotal and Average 2,999,557.30 �.nrF 12000 12000 LOCAL AGENCY INV�STMENT FUHD Subtatal and Average 65,499,582.51 FEDERAL AGENCY - CALLABLE 3134AN7KQ 660 FEOERAL HOME LOAN BANK Subtotal and Average 3,000,006.00 TRUSTEE CASH BALANCES 252028D00-G 382 GDl�MAN SACHS GOVERNMENT 252U260Q7-G 383 GOLDMAN SAGH5 GQVERNNIENT 252026002-G 384 GOLDMAN SACHS GOVERNMENT 2520260U3-G 385 GOLDMAN SACNS GOVERNMEF�T 252028004-G 386 GOLDMAN 5ACH5 GdVERNMENT 252426D17-G 401 GQIOMAN SACHS GOVERNMENT 25242601&G 402 GOLDMAN SACHS GOVERNMENT 26U128000-G 404 GOLDMAN SACHS GOVERNMENT 2601 2800 9-G 405 GOLflMAN SACMS GOVERNMENT 26012gpp2-G 407 GOLDMAN SAGHS GOVERNMENT 260128003�G 408 GOLDHWN SACNS GOVERNMENT 260'728404-G 409 Gd�DMAN SACHS GOVERNMENT 280728005-G 410 GOLDMAk SACHS GOVERNMENT 26072800B-G 472 GOLDMAN SACHS G�VERhIMENT Run Date• 09f212021 -1 D:38 07l6112020 10,032,381.10 730,271.57 10,7'62,592.67 3,770.21 3,770.21 07l2812021 3.fl00,0U0.00 3,000,000.00 85.499,582.57 65,484,582.51 p712g12027 3,0OO,ODO 00 5,000,000.06 07101l2U20 07/D112020 0710'E12020 07/01/2020 0.00 0.00 o.00 27.29 950.08 a.a� a.zv 15,969.05 0.00 o.oa 0.00 0.00 0.00 0.00 10,032,3$1.1 Q 73U,211.57 10,762,592.67 3,770.21 s,rra.zi 2,ss�,�so.ao Z.997,120.00 55,499,582 51 ss,asa.5ss.s� 3,003.570.0p 3,003,574.00 0 DO Q.00 a.00 27.29 95U.0$ a.a� tl.20 15,969A5 0.00 0.06 0.00 0.00 0.00 0.00 Page 1 Sm� rnuuc oays w Maturity �ook Value Rate MoodY�$ 385 MatlCal Date 1fl,U32,381,10 0.050 O,D50 7 730,217.57 0 O50 0.050 1 10,762,592.67 O.Oitl 1 s,rra.2� o.zz� a.22� � �,na.2� o.z2� � 2,999,562.68 0.540 Aae 0 580 149 1Ul2812024 2,999,562.69 0.530 1�9 65,499 582.51 0.221 0.221 9 65,499,582.51 Q.221 7 3,000,000.00 0400 Aaa �.4�6 331 07l29/2024 3,00O�OOU,00 0.400 331 D.Oo 0.030 Aaa 0.030 1 a.QO 0.03a Aaa Q.Q3U 1 0.00 0.03Q Aaa O.D30 1 27.29 0.030 Aaa 0.030 1 950.U8 0.030 Aaa 0.030 1 0.01 0.030 A3a 0.03� 1 0.20 0.030 Aaa 0.030 1 15,969.05 D.030 Aaa 0.034 1 4.00 0.030 Aaa 0.030 1 0.00 9.034 A2a 0.030 9 0.00 4.030 Aaa 0.030 1 O.Otl 0.030 Aaa 0.030 1 0.00 0.030 A3a D.03D 1 0.00 0.030 Aaa 0.03Q 1 Portfolio ctTY AP PM (PRF_PM2} 7 3.11 Report Ver. 7.3.11 CUSIP Investme�rt# Issuer TRUSTEE CASH BALANCES zsaszeoo�-c 260128U08-G �so, zeoas-c 260128010-G 260128011-G 281470000-G 26147Q001-G 267470002-G 283346000.G 263346007-G 263346002-G 263346003-G 263346004-G 263346005-G 263346006-G 283348007-G 263598000-G 263598d01-G 263599002-G 263599003-G 269048D00-G 277146000-C z�, �aeooi-c 271146UO2-G x» �asoo�-c 27'! 146004fi� 271746005-G 271746008-G 27758000a-G 414 415 ais 417 41$ 419 420 421 671 672 B73 674 675 676 877 878 679 680 882 883 684 685 �� 688 689 690 691 692 fi93 MED�IIM-7ERM NQTES 037833DL1 814 037833DL1 618 023135BW5 662 254687FJ0 625 CITY OF PALM DESERT Portfolio Management Portfolio Details - In�estme�ts August 31, 2021 Average Purchase Balanca Date Par Valus Market Value GOLDMAN SACHS GOVERNMENT GOLDMAN SACHS GOVERNMENT GOLDMAN SACHS GOVERNMENT GOL�MAN SACHS GOVERNMENT GOlDMAN SACHS GOVERNMENT GOLDMAk SACHS GOVERNMENT GOLDMAiJ SACHS GOVERNMENT GOLDMAN SACHS GOVERNMENT GOLDMAN SACHS GOVERNMENT GOLDMAN SACHS GOVERNMENT GOLDMAN SACHS GBVERNMENT GOLDMAN SACHS GOVERNMENT GOL�MAh SACNS GOVERNMENT GOLDMAN SACHS GOVERNMENT GdLDMAN SACHS GOVERNMEI�T GOLDMAN SACHS GOVERNMENT GOLDMAN SACHS GOVERNMENT GOLDMAN SACHS GOVERNMENT GOLDMAN SACHS GOVERNMENT GOLDMAN SACNS GOVERNMENT GOLaMAN SACHS GOVERNMENT GOLDMAN SACHS GOVERNMENT GOLDMAN SACH5 GOVERNMENT GOLDMAN SACHS GOVERHMENT GOLDMAN SACHS GOVERNMENT GOLDMAN SACHS GOVERNMENT GOLDMAN SACHS G4VERNMENT GQL�MAIV SACHS GOVERNMENT GOLDMAN SACHS GOVERNMENT 5ubtotal and Average 5,1D5,8fi1.73 APPLE, INC. APPLE, INC. hMAZON.COM ENC. WALT pISNEY COMPAIVY a7ru��2o20 08l01l2021 08I0!l2021 asro�r�az� Q8101I202i 0$!01l2621 fl8101l2021 UB1�1l2021 08101l2027 oe�ouzoz� OB10i12027 08/0112p21 08lfl11202t 08101/2021 08l01l2021 08I01l2021 08l01 J2021 08I01@021 oaro�no2� 08101/2021 os�o�naz� as�o�r�a2� 08l1 i12019 09@512019 o�nsr�a2� �arzorlo�a 0.00 0.00 o.00 126,671.89 1B0,896.50 0.00 0.00 54.56 a.ao a.00 0.�2 874,200.38 0.00 0 00 29,136 50 1,974.fi54.02 0.06 a.00 1,476,803.49 22.749.49 0.24 0.00 0.00 0.00 468,400.26 a.00 a.00 19,434.46 1.55 5,104,4i0.07 5,d00,000.OQ 90,000,000.00 3,000 000.00 s,000 000.00 0.00 0.00 o.00 126,671.B9 180,896.50 o.ao 0.00 54.56 o.ao o.00 0.�2 874.200.36 O.pO o.oa 29,936.5fl 1,974 654.02 0.00 o.00 1,416.8U3.49 22,749.49 o.za 0.00 o.oa Q.00 aea,aoa.zs a.no o.no 19,434.46 1.55 5,109,950.07 5,077.300.00 1 D.154,600.00 3.001,5B0.00 5,070,900.00 Page 2 Stated YTIWC Days to [Ylaturlty Book Value Rate Moody's 365 MatlCal Data 0.00 6.00 o.00 126,671.88 760,896,50 o.00 0.00 54.58 o.oa o.00 o.�z 874,200.36 0.00 o.oa 29,136.50 1,974,654.Q2 O.Op o.00 7 416, 803.49 22.748.49 o.2a a.ao o.00 U.00 ase.aoo 2s 0 00 o.00 79,434.46 1.55 5,109,950.07 0.03o Aaa 0.�3U 0.030 Aea 0.030 0.030 Aaa 0.030 0.030 Aaa O,D30 0.030 Aaa 0.030 o.oso ,aaa o.oso 0.030 Aaa 0.030 O.a30 Aaa 0.034 6A30 Aaa 0.430 U.fl30 Aaa 0.030 U.U30 Aaa 0.030 0.030 Aaa 0.030 0.030 Aaa 0.03D o.oso naa o.osa 0.030 A38 0.030 0 03D A88 0.03U 0.030 Aaa 0.030 0.030 Aaa 0.030 0.030 Aaa 0.030 0.030 Aas 0.030 0.03o aaa a.aso 0.03o naa a,aso 0.030 Aaa fl.U30 0.036 Aaa O.U30 a.osn ,4aa o osa 0.03U Aaa 0.030 O.p30 Aaa 0.030 0.030 Aaa 0.030 O.D30 Aaa 0.030 O.D30 1 1 1 1 1 � 1 1 7 1 1 1 7 � 7 7 1 1 1 1 1 � 1 1 � 1 1 9 ] 4.999.499.8i 9,996,497.$4 3,004,OOD.00 4.898,039.96 1.7Q0 Aa 7.710 1.700 Aa t.735 0.450 A D.450 1.850 A 1.890 375 09H 1I2022 3i5 09l1912022 72 OSl12l2024 385 09/01/2022 Po�tfolio cITY Run Date: 09121@021 -10'38 AP PM (PRF_PM2; 7 3.11 CITY QF PALM DESERT Portfolio Managemen# PortFolio Details - Investments August 37, 2021 Average Purohase CUSIP Investmeirt # tssuer Balance �ate Par Value Markat Value MEDIUM-TERM NOTES 02665WBG5 615 AMERICAN HONDA FINANCE 02665WDC2 617 AMEl21CAN HONDA FINANCE 89236TJH4 658 TOYOTA MpTOR CREDIT CORP 89238TJH8 659 TOYOTA MOTOR CREDIT CORP Suatotal and Average 38,990,543.10 CUSTODWN PR0.IECT FUNDS 6736302420-G 547 GOLDMAN SACFiS GOVERNMENF 673630243p-G 648 GOLOMAN SACHS GOVERNMEhT 673B30244D-G 649 GOLDMAN SACHS GOVERNiuIENT 8738302450-G B50 GOLQMAN SACHS GOVERNMENT 5ubtotal and Average 56,644,276.71 RIVER5IDE COUNTY PpQL 0524fi0 052460 POOLED INVESTMENT FUND Subtotal and Averaga 78,377,745.94 CUSTODIAN PROJECT FUNDS 673630242p 498 GOLDiuIAN SACHSTREASURY FUND 6736302430 489 GOLDMAN SACHS TREASURY FUND 67363a2440 500 GOLDMAN SACHS TREASURY FUND 6738302450 507 GOLDMAN SACHS TREASURY FUND Subtotal and Average O.OD Total and Average 268,848,Q34.09 a9109l2019 D9127I2D19 06118I2p21 U7108l2U27 oua�r�oz� 09I0112021 ouo�rzoz� d7l01l2021 S,OOO,OOO.tlO s,000,aoo oa 3,OOD,000.00 3,000,0OO.OD 39,000,000.00 6,841,893.04 18,Q90,484.01 9.789,104.87 20.327,327.69 55,048,819.61 79,377,745.94 79,377,745.94 8,841,893.04 18,090,494.07 9,789,Sp4.87 20,327,327.69 55,048,819.61 79,377,745.94 74,377,74i.84 Page 3 Stated YTMlC Days to Maturlty Book Valua Rate Moody's S65 MaklCal p� . 4.999,745.D6 i.700 A 1.935 $ 09109I2621 4,999,979.33 2.050 A 2.045 496 D1140I2023 3,004,400.00 0.500 A 0.500 1,02i U6118l2024 2,997,492.D0 0.500 A 0.530 7,021 U6118l2U24 38,991,254.00 Z.505 418 6,841,693.04 D.030 18,09p,494.01 0.030 9,789,104,87 0.030 20,327,327.69 0.030 55,048,819.61 Aaa U.U30 Aaa 0.030 Aaa 0.030 Aaa 0.030 0.030 1 1 1 � 1 79,377,7a5.94 fl.289 78,377,745.44 Aaa 0.289 1 0.284 1 0.00 0.00 0.00 0.010 Aaa 0.010 7 O.OQ 0.00 D.00 O.p10 Aaa 0.01U 1 0.00 0.00 O.DO 0.010 Aaa 0.070 4 �.00 D.00 0.00 0.010 Aaa O.D10 1 D.00 D.DO D.00 0.400 0 260,802,461.01 261,214,T81.01 260,79�,277.70 0.368 68 � 5,001,500.00 5,118,250.00 2,993.780.00 2,893,760.00 39,411,630.00 Portfolio cITY R�n nace: osrz,noz, - �o.•as AP PM (PRF_ PM2) 7 3.11 CITY OF PALM DESERT PortFolio Management Portfalio Details - Casi� August 31, 2021 CU51P Invesdnent# Isauar Averaga Purehasa Balanca Date Par Value PHNDING DEPOSIT WITH C�UNTY PQpL SYS651 fi51 CITY OF PALM DES�RT MAIN 01/2912021 0.00 UNION BANK CHECKING ACCOUNTS 5YS73076 93096 CITY QF PALM DESERTMAIN 10,093,407.54 SYS13013 13013 DESER7 UVILLOW GOLF COUi�SE 071U112020 1,327,i02.40 5YS602 6Q2 PUBLIC SAFETY CHECKING 0110112020 949.511.79 SY513020 13020 RECREATlONAL FACILITlES CORP D7l0112020 1,020,493.17 Averaga galance 0.00 Accrued Interest al Purchase SubWtal iotal Caah and InrestmeMs 288,948,034.09 274,192,975.91 Page 4 Sfatec! YTMlC Days to iNarket Value Book Value Rate Moody'a 365 MaklCal 0.00 0.00 0.000 1 10,U93,407.54 1,327,102.40 949,511.79 9,020,493.17 3,345.83 13,393,880.73 274,6Q8,641.74 10,093,407.54 7,327,102.40 949,511 79 1, 02U,493.17 3,345.83 13,393,860.73 274,1$1,t38.43 0.000 1 a.aoo i U.000 1 0.000 1 � 0.388 69 � Portfolio CITY Run Date: 09l2112021 10:38 AP AM (PRF PM2) 7 3.11 C1TY OF PALM DESERT Acti�ity Report Sorted By Issuer August 1, 2021 - August 34, 2021 Par Valua Percent Beglnning Current TrannacNon CUSIP InrestmeM# Isauer ofPortfoBo Balance Rata Date Issuer: APPLE, IiVC. MEDIUM TERM NOTES Subtotal and Balance 15,000,000.00 Isauer Subtotal 5.4719G 15,000,000.00 Issuer: AMAZOH.COM INC. MEDIUM-TERM NQTES Subtotal and Balanes 3,fl00,000.00 lasuer Subtotal 1.Q94°k 3,000,000.00 Issuer: C.A.M.P. POOL (CITY) CAMP SYS13 13 C.A.M.P. POOL (Cli'Y) O.d50 Subtotaf and Balanca 10,031,939.50 Issusr Subtokal 3.659°G 1D,031,938.5D Issuer: C.A.M.P. POOL (DESERT WILLOVY� CAMP SY572444 12444 CA.M.P. POOI {DESERT WILL0IN) 0 050 5ubtotal and Balance 730,179.43 Issuer SubWtat 0.268% 730,179.43 Issuer: POOLED INVESTMENT FUND RIVERSIDE COUNTY POOL Sub6oql and Balance 79,377,7�5.94 Issuer Subtotal 28.950'k 79,377,745.94 Run Date: 09212021 -11:14 Purchases or Deposits a.ao o.oa 441.60 4�1.60 447.60 32.74 32.14 32.14 �.00 Par Valus Redemptions or Withdrawa's o.00 4.00 U.OD 0.00 0.00 0.00 O.QO 0.00 Ending 6alanee 45,OOQ,000.00 ts,000,000.00 3,00O,OOD.00 3,a00,000.00 70,032,381.10 10,032,381.90 730,211.57 730,211.5T 79,377,745.94 0.00 79,377,745.94 PoRfolio C[7Y AP DA (PRF DA) 7.3.11 Reporl Var. 7.3.11 Peroe�rt CUSIP Investment # Issuer � Portfolio Issuer: WALT DISNEY COMPANY ME�IUM-TERM NOTES Sulrtotai and Balance Issuer Subtofal 1.824i6 Issuer: FEDERAL HOME LOAN BANK FEDERAL AGENCY - COUPON 5ubtotal and Balance FEDERAL AGENCY - GALLABLE Subtotal and 8alance Issuer SuMoffiI 2.188'�5 Issuer: GOLDMAN SACHS GOVERNMENF FUND TRUSTEE CASH BALANCES 252026003-G 385 GOLDMAN SACHS GOVERNMENT 252028004-G 386 GOLDMAN SACHS GOVERNMENT 25202BOi 7-G 401 GOlDMAN SACHS GOVERNMENT 252028018-G 402 GOLDMAN SACHS GOVERNMENF 260128000-G 404 GOLDAAAN SACHS GOVERNMENT 260128009-G 418 GOLDMAN SACHS GOVERNMENT 260128010-G 417 GOLDMAN SACHS GOVERNMENT 260128019-G 418 GOLDMAN SACHS GOVERHMENT 267470002-G 421 GOLDMAN SACHS GOVERNMENT 263346000-G 877 GOLDMAN SACNS GdVERNMENT 2fi3346001-G 672 GOLDMAN SACHS GdVERNMENT Zfi3346002-G 673 GOLDMAN SACHS GOVERNMENT 263346003-G 674 GOLOMAN SAGHS GOVERNMEAlT 283346004-G 675 GOLDMAN SACHS GOVERNMENT 263346005-G 675 GOLDMAN SAGHS GOVERNMENT 263346006-G 677 GOLDMAN SACHS GOVERNMENT 263348007-G 678 GOLDMAN SACHS GOVERNMEN7 26359900a-G 679 GOLDMAN SACHS GOVERNMENT 263599001-G 680 GOLDMAN $ACHS GOVERNMEN7 CITY OF PALM DESER7 Activity Report A�gust 1, 2021 - August 31, 2021 Par Value Beginning CurTant Transactfon Balance Raba Date 5,000,000.00 S,OOO,D00.00 3,000,000.00 3,OOO,D00.00 s,000,000.00 0.030 U.030 O.U30 0 030 0.030 0.034 0.030 0.030 0.030 0,03a 0.03D 0.030 0.030 D.03U 0.030 0.030 0.030 U.03Q 0.030 Purchases or Deposits 0.00 o.oa 27.04 19.20 O.Oi 0.20 0.35 126,671.38 128,877.59 3.57 7 $.50 0.07 n.a� a.13 874,200.36 0.01 0.01 28,136.50 1,974,$54.02 0.01 0.01 Par Value Redemptions or Witharawals O.OD o.00 0.00 o.oa 0.00 O.OD 0.00 128.677.89 0.00 D.00 0.00 o.o� o.o� 0.01 0.00 a.a� 0.07 0.00 0.00 Q.01 0.01 Page 2 Ending 8alanee S,OOa,G00.D0 S,OOp,000.Q0 3,000,000.00 3,000,000.�0 6.000.000.00 Portfolio CITY AP Run pale: 09E12112021 � 11'14 DA {PRF_DAy 7 3.11 Report Yer. 7 3.11 Pareent CUSIP Investment# Issuer ofPortfolio Issuer: GOLDMAN SACHS GOVERNMENT FUND TRUSTEE CASH BALANCES 263599002-G 682 GOLDMAN SACHS GOVERNM£NT 263599003-G 683 GOLDMA�I SACHS GOVERA[MENT 269048000-G 8&4 GOLDMAN SACHS G01/ERNMENT 27'l146000.G 685 GOLDMAN SACHS GOVERNMENT 271146001-G 687 GOLDMAN SACHS GdVERNMEN7 271148002-G 688 GOLDMAN SACHS GOVERNMENT 277146003-G fi89 GOLDMAN SACHS GOVERNMENT 271146604-G B90 GOLDNUIN SACHS GOVERNMENT 271146005-G 697 GOL�MAN SACHS GOVERNMENT 271146006-G 692 GOLDMAN SACHS GOVERNMENT 277580000-G 693 GOLDMAN SACHS GOVERNMENT Subtotal and Balance CUSiODIAN PROJECT FUNDS C1TY OF PALM DESERT AcGvity Report August 1, 2021 - August 3'i, 2Q21 Par Value BegEnning Current TrensBCtlon Balance Rate Date 177,831.63 673630242D-G 647 GOLdMAN SACHS GOVERNMENT 6736302430-G 648 GOLDMAN SACHS GOVERNI4IENT 6736302440-G 649 GOLDMAN SACHS GOVERNMENT 673B302450-G 65p GOLDMAN SACHS GOVERNMENT Subtotal and Balanca 57,295,751.36 Isauer Subtotai 21.9409G i7,473,582.99 lssuer: GOLDMAN 5ACliS TRFASURY fiUND CUSTODIAN PROJECT FUNDS Subtotal and Balance p.pp Isauer Su6total D.000°G 4.00 Issuer: AMERICAN HONDA FfNANCE MEDIUM-TEWN NOTES Su6total and 8alance 10,000,000.00 Issuer Subtotal 3,647°,G 10,000,000.00 O.Q30 0.030 0.03U 0.030 0.030 O.p30 0.030 0.030 0.030 D.630 0.030 0 030 0 030 0 030 0.030 Purchases or DeposdS 1,416,803.49 22,749.49 a.za a.az fl.01 0.01 466,40a.26 001 0.01 7 9,434.4$ 1.55 5,058,790A5 177.63 425.01 217 00 45�.43 1,270.07 i,060,06D.52 Q.06 D.00 Par VaEue Redemptions or WiCidrawals O.QO 0.00 a.00 0.07 0.04 O.D1 O.UO tl01 001 0 00 o. oa 12b,5T2.Ot 1,168,145.61 1,080,056.2'1 0.00 0.00 2,2A8,201.82 2,374,$73.63 Ending Balance i,108,85Q.87 55,048,819.61 80,158,769.68 0.00 0.00 D.00 10,00O,OOD.DO D.00 10,000,000.00 Page 3 PortfOliO CI7Y AP Run Dale: D92tl2021 -11:14 DA (PRF_DA) 7.3.11 Report Ver 7 3'I 7 CITY OF PALM D�SERT Activity RepoR August 1, 2021 - August 31, 2021 Par Valua PerceM BegEnning CurTerK TransaeHan CUSIP InvestmerK# Issuer ofAortFollo Balance Rata Date Issuer: LOCAL AGENCY II�VESTMENT FUND U.S. BANK 1 LA1F BOND PROCEEDS 5uhtotal and Balance 3,770.21 LAIF Subtotal and 8alance 65,499,582.51 Issuer Subtotal 23.$9a9. 65,503,352_72 Issuer: TOYOTA MOTOR CR�DIT CORP MEdIt1M-TERM NOTES Subtotal and Baiance 6,000,000.00 lasuer Su6total 2.188X 6.000,OOO.DO Issuer: CITY OF PALM DESERT MAIN PHNOING DEPOSIF WITH COUNTY POO[. S�btotal and Balanca 0.00 UNION BANK CHECKING ACCOUNTS SYSi 3096 13018 CfTY OF PALM DESERT AAAIN Subtotal and Balance 2,80Q,B80.03 Issuer 5ubtoMl 3.681Y. 2,800,fi90.D3 issuer: DESERT WILLOW GOLF COiJRSE UNION BANK CHECKING ACCOUNTS SY513013 13013 DESERT WILLpW GOLF COURSE Subtotal and 8alance 1,856,034.48 Issuer SubtoffiI 0.484x 1,856,034.,8 Issuer: Pl1BLIG SAFETY CHECKING UHION BANK CHECKING ACCOUNTS Run Oete: 09129120Q1 11:14 Purchases or Deposits 0.00 0.00 13,538.Zfi3.62 13,558,263.62 73,538,263.62 445,428.08 445,428.06 445,428.06 ... Par Value Redemptions or Withdrawais D.00 o.oa 6,245,546.11 6,245,546.11 fi,245,b�6.17 974,380.14 974,360.14 974,360.14 Page 4 Ending Balanea 3,77D.21 ss,ass,ssz.s� 65,503,352.72 fi,000,00p.Op 6�OD0�000-QO 0.00 10,081,/07.54 10,093,407.54 1,327,! 02.40 7,�27,'! 02A0 Portfolio CI7Y AP �A (PRF DA} 7 3.11 Report Vx. 7 311 Percent CUSIP IrnasdneM # Issuer � Portfolio Issuer: PUBLIC SAFETY CHECKING EJiVEON BANK CHECKING ACCOUNTS SYS602 602 �UBLIC SAFETY CHECKING Subtotal and Balance Issuer Subtotal 0.346% Issuer: RECRFJIZIONAL FACILITIES CORP UNION BANK CHECKING AGCOUNTS SY513020 13020 REGREIITIONAL FACILITIES CORP CITY OF PALM b�SERT Acti�ity Report August 1, 2Q21 - August 31, 2021 Par Valua Beginning Currertt Tranaaction Balance Rate Date 692,4i6.50 892,476.50 Su6total and Balance 987,828.63 Issuer Sabtotal 0.372°G 987,629.63 Total 100.00O;G 264,453,639.22 Purchases or aeposits 257,467.60 257,p6T.60 257.057.60 1fl8,477.59 108,417.59 108,417.59 19,409,717.13 Par Value Redemptions or Wrthdrawals 32.37 32.31 32.31 75,754 05 75,754.05 T5,754.05 9,670,566.44 Ending Balanee 949,511.79 949,511.79 1,020,491.1T 1,020,491.1T 274,192,975.91 Page 5 Portfolio CITY AP liun Dste' 04l2172021 -11:14 DA �PRF_�A) 7.3.1 i Report Var. 7.3.17 � CITY OF PALM DESERT LQNG-TERM LOANS RE�EIVABLE August 3!, 2021 zi-5ep-zi 11:40 AM SymPro No. Investment Book Value $ ].0,575,462.50 $ 1,394,004.00 Maturity �ate Stated Interest Rate 1 City Loan to RDA* 348 EIP Loan ** 594 Highlands Utility Undergrounding *** Assessment District 04-01 Deferred Laan $ 14,977.73 N/A 09/02/34 09/02/36 0.22% 7.00% 5.35% footnotes * On May 17, 20I9, the California State Department of Finance �DOFJ denied the I986 City Loan in the principal amount of $5,000,000 as an enforceable obligatiorr of the Successor Agency of rhe Palm Desert Redeveloprrrent Agency. Severa! attempts have been mode ta cha!lenge this decisian. The DOF, however, cnniinues ta mointain irs position and its interpretation of the dissolution law as ir relotes to the loans. ** EIP balance adjustments made an March 2 and on September 2 of each year. *** Highlands balance adjustments made on March 2 and on September 2 of each year. PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Summary August 31, 2fl21 Investments CAMP LAIF CUSTODIAN PROJECT FUNDS Investr�ents Cash PassbooklCheeking (not inGuded in yield plculatlons) Total Cash and Investrnents Par Value 48,826,376.40 971,444.20 4,939,204.29 54,737,p24.$9 3,522,696.87 58,259,729.56 NEarket Value 48,826,378.40 971,444.20 4,939,2D4 28 54,7ST,024.$9 3,522,896.67 58,259,721.56 Book 76 of Daya to Value Porffolfo MaklCall 48,828,376.40 89.20 7 971.444.20 1.77 1 4,939,204.29 9.02 1 54,T37,024.89 100.0096 1 3,522,696.67 58,259,721.56 1 � Term 7 7 7 1 0 1 YTMIC 365 Equiv. 0.054 o.zz� 0.030 0.051 o.oaa 0.051 7otal Eamings August 31 Month �nding Current Year 2,381.55 . Average Daily Balance 58,172,436.14 Effective Rate of Return 0.05°k ihis irnestmertt portfolio complies with the provisions of Califomia Goverrtment Code Section 53601 and the City of Palm pesert investment policy. Sarring unforeseen e►rents, it has sufficient cash to fund u'Rg Autharity o ra ' ns r the ne srx months. AEI bal��re b2vrk� lances. The "� oi PortFalio" calculation on the Partfolio Summary page omits demand deposits. / Janet ore, Directar of Finance/City asurer ' Reporting period �8101I202'I-0813712021 Run date: 09rz1f2021 -10:45 No fiscal year history available Portfolio HA AP IE(PRF PM1}73.t1 Report Var. 7 3.11 PALM DESERT HOUSING AUTHQRITY Portfolio Management Portfolio Details - Investments August 31, 2021 Average Pvrchaae Cl1SIP Investme� # Isaue� Balanea Date Par Value Market Yalus CAMP SYS72008 120a8 CAASSET MANAGEMENT PROGRAM 48,82B,37fi.40 48,826,37fi.40 Su6toLal and Average 48,824,296.51 48,826,576.40 48,826,376.40 CUSTODIAN PRQJECT FUNDS 6738302460 580 GOLDMAN SACHS TREASURY FUkD 0.00 0.00 Subtatal artid Average 0.00 0.00 0.00 LAIF SYS21003 21003 LOCAL AGENCY fNVESTMENT FUND 971.444.20 977,444.20 Su6total and Average 971,444.2D 971,444.20 971,444.20 CUSTODfAN PROJECT FUNDS 87383024Bd-G 597 GOiDMAN SACHS GQVERNMENT 07l01I2021 4,939,204.29 4,939,204 29 Suhtotel and Averaga 4,939,20p.78 4,939,204.29 4,939,204.24 Total and Arerage 58,l72,436.14 54,737,4Z4.84 54,737,024.89 Run Oste� OSl21/1021 -10:45 Paga 1 5tated Days to YTMlC � Book Value RRte Maady's MatlCal 3$5 p� . 48,826,376.40 U.U50 1 0.050 48,826,376.40 1 O.OSp D.Do 0.010 Aaa O.pO 971,44420 0.221 971,444.26 4,939,204.29 O.U30 Aaa 4,839,204.29 54,737,024.89 1 0010 0 0.000 7 0.221 1 0.22i 1 0.030 1 O.D30 t a.ast � Portfolio HA AP PM {PRF PM2� 7,3.11 Repai Ver 7 3.11 CUSIP Inrestmer�t# Issuer CHECKlNG SYS25015 25615 HOUSING AUTH CHECKfNG SYS25096 25D16 HOUSING AUTH TRUST Average Baiance Total Cash and Inveatmems 58 PALM DESERT HQUSING AUTHORITY Portfolio Management Portfoiio Details - Cash August 31, 2021 Average Purchase 6alance Date Par Value Market Valus 3,061,756.77 3.0B7,756.17 07I01l2020 460,940.50 4fi0,94p.5p 0.00 2,436.14 58,259,721.56 5$,254,721.5B Page 2 5tated Days m Y9'NUC Book Vaiue Rate Moody's MatJCal 365 3,081,756.17 7 0.000 460,94U 5D 1 0.000 1 58,259,721.56 1 O.p51 A PoRfolio HA Run Dete: 0912112v21 -10:45 AP PM(PRF pM2}73.f1 RDA SUCCESSOR AGENCY Portfolio Management PortFolio Summary August 31, 2027 Invasdnents RIVERSIDE COUNTY POOL CAMP LAIF TRUSTEE CASH BALANCES - MMA TRUSTEE GASH BALAkCES - GF Investments Cash PassbooWChedcing (not induded in yiefd cakxrlations) Total Cash and Investments Par Value 335.87 5.728.58 742.08 35.893.767.94 402,1D2.54 37,402,fiT6.97 1,284,876.98 38,687,553.95 Market Value 335.87 5,728.56 742.06 36,993,767.94 A02,192.54 37,402,678.97 1,284,B78.98 38,6$7,553.95 Book Value 335.87 5,728.56 742.06 36,993,767.94 402,102.54 3T,402,676.9T 1,284,876.98 38,687,553.95 ;G of Portfolb a.00 O.R2 0.00 98.97 1.D8 7 00.00% Deys to MaUCall 7 1 1 1 1 1 � Tertn 1 1 1 1 7 9 � YTMIC 365 Equiv. 0.289 a.p50 0.227 fl.aso 0.030 0.07 0 0.000 1 1 0.010 Tota! Eamings August 31 Month Ending Current Year 325.23 Arrerage Daily Balance 39,273,923.17 Effective Rate of Ratum 0.01�0 This investment portfolio is in comp�iance with the provisions of Califomia Govemment Code Section 53601 and the City of Palm DeseR investment policy. Pursuant to ABX12$, tbe availability of cash to fund the Palm Desert RDA Successor Agency's debt service is dependent u}�on the County of Ri�erside and the State oF California. All balances are bank balances. The "06 of Portfolio" calculation an the Portfolio Summary page omits demand deposits. � 9 �� Jane . oore, Finance Officer " ' Reporting period 08l4112021-0813912D21 Run Date: 09r1t2021 -11 00 No fiscal year history awaifable Portiolia RDAS AP IE (PRF_PM1} 7 3.11 Repvrt Vec 7 3.11 CUSIP Investment # RIVERSIDE COUNTY P�aL 052470 052470 POOiED INVESTMEMT FUIVD Su6total and Average Issuer RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Investments August 31, 2021 Average Purchase Balance Date Par Value Market Value 135.87 CAM� 5YS578 578 C.A.M.P. POOL (RDA S.A.} Sudtotal and Average 5,728.32 o�rn� �za2o LAIF SYS604 604 L.A.I.F. (R6A S.A.) Q7109I2020 Subtotal and Average 742.06 TRUSTEE CASH BALANCES - IHMA 247384007-U 830 U.S. BANK MONEY MARKET ACCOUNF 07107l2020 247394003-U 832 U.S. BANK MONEY MARKET ACCOUNT 07107I2020 247394002-U 833 U S. BANK MONEY MARKET ACCOUNT 247394000-U 834 U.S. BANK MONEY MARKET ACCOUNT 238781002-U 837 U S. BANK MONEY MARKET ACCOUNT 238781003-U 838 U.S. $ANKliA4NEYt�IWRKET'ACCOUNT 07l6112020 238781000.0 $39 U,S. $AAlKMONEYMARKETACCO�NT 253448003-U 842 U.S.BANKMONEYMARKETACCOUNT 071fl11202D 253446002-U 843 U.S BANK MONEY MARKETACCOUNT 253446000-U 844 U.S. BANK MONEY MARKETACCOUNT 253448a01-U 845 U.S. BANK MONEY MARKETACCOUNT 07I01l2020 22432400D-U 853 U.S. BANK MONEY MARKET ACCOUNT 224324007-U 85S U.S. BANK HEONEY MARKET AGCOUNT 07I01I2020 224324UO2-11 856 U.S. BANK MONEY MARKET ACCO�INT 224324003-U 857 U.S. BANK MONEY MARKET ACCOUNT 07101I2020 236787001-U eB1 U.S. BANK MONEY MARKET ACC6UNT Q9109I2p20 Suhtotal and Average 36,993,782.87 TRU5TEE CASH BALANCES - GF 277861000-G 891 GOLDMAN SACHS GOVERNMENT 277861001-G 892 GOLDMAN SACliS GOVERNMENT 277881002-G $13 GO�OMAN SACNS GOVERNMENF 07/0'i12020 277869003-G 814 GOLDMAN SACHS GOVERNMENT 07/01/2020 Run Dete: 0912i12021 - 11�D0 335.87 335.87 5,72$.56 5,728.56 742.06 742.06 0 13 0 00 207,503.46 $70.318.79 2,930,048.96 0.00 10,677,788.55 0.00 1,530 025.58 5,546.7Q0.58 1.D2 70,901,305.31 1.96 4,380,073.36 0.00 0.24 36,993,767.94 aaz,� o2.sa 0.00 0.00 o.oa 335.87 335.87 5,728.58 5,728.56 742 OB 742.06 0.13 0.00 207 503.4B 870 318 79 2,930 048.98 0.00 10,817,788.55 o.00 9,530,025 58 5.546,7tl�.58 1.02 40,901,305.37 1.96 4,390,073.36 0.00 a.za 3fi,993,767.84 402,102.54 o.oa 0.00 o.00 Page 1 5tated Daya to YTMlG Maturity Boak Value RaLe Mood�'s MaklCal 365 p� 335.87 0.289 Aaa 1 �.289 335.87 1 0.289 5,728.58 0.050 5,728.56 742.06 0.221 742.06 0.13 0.010 0.00 0.010 207,503.46 0.010 870,31B.79 0.010 2930,04B.96 0.010 0.00 0.010 10,617,788.55 0.010 0.00 0.010 1,530,025.58 0.01Q 5,548,7pp,5$ 0.090 1.42 0.09D 10,801,305.31 O,D7 p i.9s o.o�a 4,39p,073.36 0.01U 0.00 0.01D 0.24 0.010 36,993,76T.94 402,102.5A Q.030 0.00 O.fl30 0.00 0.030 0.00 U.fl30 P-7 P-1 P-1 P-'E P-4 P-1 P-1 P-1 P-1 P-1 P-1 P-1 P-1 P-1 P-1 P-1 Aaa Aaa Aaa Aaa 'E 0.050 1 0.050 1 0.227 1 0.221 1 0010 1 0010 1 0 01 D 1 0 010 1 0010 1 0.010 1 0.010 1 0.010 7 0.010 i 0.010 1 0.010 1 0.010 1 0.030 1 �.010 1 0.070 � o.o�a 1 0.010 7 0.03U 1 �.030 t 0.030 1 0.030 Portfolio RDAS AP PM (PRF PM2j 7.3.11 Repart Ver 7 3.11 CUSIP Invastme�rt�! laauer Subtotal and Averaga Tofal and Average RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Investments August 31, 2021 Average Purohasa Balanca Dabe 414,585.30 39,273,923.11 Par Yalue 402,102.54 37,4DI,fiT6.97 Market Value 402.! 02.i4 37,102,676.97 Book Yalue 402,102.54 37,402,67fi.97 Page 2 SSated Daya to YTMIC Rate N�oody's Mat1Ca1 365 1 0.030 1 0.010 Portfolio RDAS Ru� os�e� o�2�noz� - � � o0 AP PM {PRF_PM2) 7.3.11 CUSIP Investmant# Issuer UNION BANK CHECKING ACCOUNTS SYS5B2 582 RDA SUCCESSOR AGENCY RDA SUCCESSQR AGENCY Portfolio Management Portfolio Details - Cash August 31, 2021 Average Purchase Balence Date Par Value iNarket Value 1,284, 876. 98 1, 284.876. 98 Ayerage Balance 0.00 Total Gaah and InvestmetMs 39,273,823.i 1 3$,687,553.95 38,fi87,555.95 Page 3 $tated Days to YTM1C Book Value Rate Moody'a IYtat.lCal 36i 1,284,876.98 1 0.000 1 38,687,Si3.95 1 0.010 u Portfolio RDAS Run Date: 09121I2021 -11 •00 RP PM (PRF_PM2y 7 3. S 1 21-Sep-21 11:42 AM SymPro No. 7�3� #n��stment EIP Loan * Footnotes EIP baEance adjustments made on March 2 and Septernber 2 of �ach year. PALM DESERT RDA 5UCCE550R AGENCY LONG-TERM LOANS RECEIVABLE AUGUST 31, 2021 � Book Value 542,OOU.00 Maturity Date 09/02/29 Stated Interest Rate 3.0090 CITY OF PALM DESERT Portfolio Management Portfolio Summary ��iy 3i, 207� Investmerrts CAMP U.5. BANK 1 LAIF BaNQ PROCEEOS FEDERAL AGEIVCY - COUPON LAIF FEDERALAGENCY-CALLASLE TRUSTEE CASH BALANCES MEp1UM-TERM NOTES CUSTODIAN PROJECT FUNDS RIVERSIDE COUNTY POOL In�estments Gash and Accrued Interest PassbooklChecking (not induded in yield calculations) Accrued Interest at Purohase Subtotal Total Cash and Investments Par Value 10,782, 718.93 s,no.2� 3,000,000.04 85,499,582.57 3,000,000.00 177,831.63 39,000,OOO.UD 57,295,759.36 79,377,745.94 258,1'16,800.58 8,337,030.64 264,453,831.22 Markat Value 10,762,118.93 3,770.21 2,999,340.00 85,499,582.59 3,004,470.00 177,837.63 39,432,88d.d0 57,295,751.36 79,377,745.94 258,553,49fl.58 6,337,Q30.84 3,345.83 6,340,378.47 264,593,667.05 Book Value 10,782,178.93 3,770.21 2,995,551.15 85,499,582.51 3,000,000.00 177,831.83 38,989,734.91 57,295,751.38 79,377,745.94 256,106,085.84 6,337 030.64 3,345.$3 6,340,376.47 264,446,462.34 9L of POrtfolfo 4.17 0.00 1.16 25.38 1.16 0.07 15.17 zz.2a 3Q.75 1 DaAO% DayB bo iNatJCal[ 1 1 zaa 1 362 1 449 1 1 75 T6rm 1 1 7,188 1 i,096 1 1,042 9 1 185 1 1 75 185 YTMlC 365 Equiv. 0.050 0.221 0.530 0.221 0.40U 0.�3D 1.5QS O.D30 0.298 0.395 0 ODO 0.395 Total Eamings Juiy 31 Month Ending Fiscal Year To Date Current Year 88,305.08 88,305.0$ Average Daily Balance 271,951,641.10 259,792,648.�18 Effective Rate of Retum 0.3896 a.63% This investment portfolio is in compliance with the provisians of Califomia Govemment Code Section 53601 and the City of Palm DeseR irnestment policy. Barring unforeseen events, it has sufficient cash to fund city expenditures for the next six months. Union Bank Custody Services has pro�ided market ►ralue prices far all carporate securilies. All balances are bank balances. The "0�6 of Portfol' calculation on Po o Su ary page omits demand d psits. 9��' Jan re, Director of Finan 'dy Tr surer / Reporting period 07101l2021-0713112021 Rcn Date: 7&�3l2021 - 10:3'F Portfolio CITY AP IE (PRF PM1) 7,3.19 Report Ver 7.3.11 CLISIP InvestmaM # Isauer GAMP CITY OF PALM DESERT Portfolio Management PortFolio Details - Investments July 31, 2021 Arerage Purehaae Balanca Date Par Valua Market Value SYS13 13 C.A.M.P. POOL (CI7'Y) SYS92444 12444 C.A.M.P. POOL (�ESERT WILLp41� SubLotal and Averaga 11,342,292.37 U.S. BANK ! LAIF BOND PliOCEEDS 252028D03 '12-33-084 IOCAL AG£NCY IkVESTMEN7 FUNp 07I0112020 Subtotal and Average 1,938,518.24 FEDERAL AGENCY - COEIPON 3730ANAC4 884 FEDERAL HO�AE LOAN BANK 07I28l2021 Subtotaf and Avarage 387,038.82 LAIF 12000 72000 LOCAL AGENGY INVESTMENT FU�ID Subtotal and Average 75,433,498.78 FEDERAL AGENCY - CALLABLE 3130AN7K0 860 FEDERAL HOME LOAN BANK 07129l2U27 SubtoSal and Averaga 290,322.58 TRUSTEE CASN BALANCES 25202BD00.G 382 GOLDMAN SACHS GOVERNMENT 252026001-G 383 GOLDMAN SACHS GOVERNMENT 252028002-G 384 GOLDMAN SACHS GOVERNMENT 252026003-G 385 GOLDMAN SACHS GOVERNMENT 252028004-G 386 GOlDMAk SACHS GOVERNMENT 252p280'E7-G 401 GOLDMAN SACHS G�VERNMENT 25202601&G 402 GOLDMAN SACHS GOVERNMENT 260128000-G 404 GOLDMAN SACHS GOVERNMENT 2601280Q1-G 405 GOIpMAN SACHS GBVERNMENT D7107I2020 28�128002-G 407 GOLDMAN SACHS GOVERNMEPlT 07101I2020 260128003-G 408 GOLDMAIV SACHS GOVERNMENT o71a7l202p 260128004-G 409 GOLDMAN SACHS GOVERNMENT Oi107l2020 28Q128005-G 410 GBLDMAN SAGHS GOVERNMENT 260128Dp6-G 412 GOLDMAN SACHS GpVERNMENT Run Date: 09f�112p21 -19:37 10,031,939.50 730.179.43 10,762,118.93 3,770.27 3,770.21 3,000,000.00 S,OOO,OpD.00 65,499,582.51 65,494,582.51 3,000,000.00 3,0OO,OQ0.00 O.OU 0.00 O.DO 0.25 930.88 0.00 0.00 15,988.70 0.00 O,flO 0.00 o.00 0.00 O.OQ 70,fl31,939.50 730,779.43 10,762,118.83 3,776.21 3,770.21 z,ssa,sao.00 2,999,340.00 65,499,582.51 65,499,582.Si 3;D04,470.00 3,004,470.00 0.00 o.ao O.DO 0.25 936.88 0.00 0.00 i5,868.70 0,0� 0.00 0.06 0.00 0.00 0.00 Page 1 Sfated YTMIC Daya to MaturitY Baok Value Rate Moody's 365 MatlCal p� 10,031,939.50 0.050 0.050 1 730,179.43 0.050 0.050 1 10,762,118.93 0.450 1 3,770.21 0.221 0.221 1 3,770.21 0.221 ! 2,999,551.15 0.500 Aaa 0.530 180 10I2812024 2,998,551.75 0.530 18D 65.499,582.51 0.227 0.221 1 65,/99,$82.51 0.22t 1 3,000,000.00 0.400 Aa8 0.400 382 07129I2024 3.OQ0,000.00 a.�00 S62 D.00 0.030 Aaa 0.030 a.00 o.osa Aaa a.aso 0.00 0.03D Aaa 0.030 fl.25 0.030 Aaa 0.030 830.8B 0.030 Aaa OA30 o,oa o.osa ,aaa o.oao o.oa o.oaa ,aaa o.oso 75,968.70 0.030 Aaa 0.030 0.00 O.p30 Aaa 0.030 0.00 0.630 Aaa 0.030 0.00 U.030 Aaa 0.030 0.00 0.030 Aaa 0.030 0.00 0.030 Aaa 0.030 0.00 0.030 Aaa 0.036 1 � 1 1 1 � i � � 1 1 1 1 1 Portiolio cITY AP PM (PRF_PM2} 7 3.11 Report Ver 7.3.71 CUSIP Inveatmeirt � Issuer TRUSTEE CASFi BALAHCES C�TY QF PALM DESERT Portfoiio Management PortFolio Details - Investments July 31, 2429 Average Pnrchase Balance Date par Yalue Market Value 260128007-G 414 GOLDMAN SACHS GOVERNMENT 26D128008-G 415 GOLDMAN SACHS GOVERNiuIENT 260128pp9-G 416 GOLDMAN SACIiS GOVERNMENT 260128010-G 417 GOLDMAN SACNS GOVERNMENT 26U128019-G 41$ GOLQMAN SACHS GOVERNMENT 261470000-G 419 GOLDMAN SACHS GOVERNMENT 269470001-G 42D GOLDMAk SACHS GOVERNMENT 261470002-G 421 GOLDMAN SACHS GOVERNMENT Su6total and Average 93i,383.79 MEpIUM-TERM NOTES 037833�L1 B74 APPLE, INC. 037833DL1 816 APPLE, INC. 0231356W5 662 AMAZON.COM iNC 254687FJ0 825 WALT DISNEY COMPANY 02665WBG5 675 AMERICAN HONDA FIIVANCE 02665WDC2 877 AMERICAN HOHDA FINANCE 8923BTJH9 b58 70YOTA MdTOR GREDIT CORP 89238TJH8 B59 TOYOTA MOTOR CREDIT CORP 5ubtofal 8nd Averaga 39,473,400.78 CIfSTODIAN PROJECT FUNDS 67363U2420-G 647 GOLDMAN SACHS GOVERNMENT 8736302430-G 648 GOLDMAN SACHS GOVERNMENT 6736302440-G 648 GOLUMAN SACHS GOVERNMENT 6736302450-G 650 GOLDMAN SACHS GOVERNMENT Subtotb! and Averaige 57,285,751.36 RIVERSIDE COUNTY PpQL U52480 052460 POOLED INVESTMENT FUND SubtoffiI and Average 79,374,SB5.23 CUSTODIAN PROJECT FUNDS 6736302420 498 GOLDAAAN SACHS TREASURY FUND 8736302430 499 GOLDMAN SACHS TREASURY FUND 07I011202� 69/71/2019 09125l2079 a7119l2D21 �Tnor2ais U91d9l20t9 09127I2019 OB118l2027 07108I2021 01I0112021 0'1I0112021 07I0112021 01l0112021 0.00 0.00 0.51 0.30 180,892.93 0.00 0.00 38.p6 177,831.fi3 s,000,000.00 10,fI00,00p,00 3,000,000.00 5,aoa,aoo 00 5,000,000 00 S,OOO,OdO OQ 3,000,000.00 3,OQO,OOO.Oa 39,000,000.00 8,009,861.02 19,170,125.21 9,788,887.87 2U,326,877,26 57,295,751.36 79,377,745.94 79,377,745.54 0.00 0.00 0.00 a.00 0.51 a.ao 160,892.93 0.00 U.00 38.08 177,831.BS 5,079,850.06 10,159,300.06 2,999,010.OQ 5,D75,350.pp 5,007,850.00 5,131.400.00 2,990 �60.00 2,890 180.00 39,452,880.00 8.009,861.02 79,170,125.27 9.788,887.67 20,326,877.26 57,295,751.36 79,377,745.94 79,377,7ri5.94 0.00 0.00 Page 2 Sfated YTMIC Days to Maturily Boolc Value Rate Moody�'s 365 INatJCal p� 0.00 0.030 o.00 o.osu 0.51 O.D30 0.30 D.030 160,892.93 0.030 0.00 0.030 0.00 O.p30 38.06 0.030 1T7,831.63 Aaa 0.030 Aaa O.U30 A88 0.030 Aaa 0.030 Aaa 0.030 P� 0.03D Aaa 0.030 Aaa 0.03D 0.030 1 1 1 1 1 1 1 7 1 4,999,459.26 1.700 9.998,213.8E �.700 3,0OO,Op0.00 0.450 4.997,876.62 1 B50 4,998,788.07 1 700 4,989,978.06 2.050 3 000,000.00 0.500 2 987,497.28 0.500 38,989,T34.11 8,009,881.02 0.030 19,170,125.21 0.030 9,788.B87.87 0.030 20,328,877.26 0.03a 57,29b,751.3fi Aa 1.7'10 406 09l11@022 Aa 7.735 4�6 09N 112022 A 0.456 103 05l12l2024 A 1.690 396 09l0112d22 A 7.935 39 09I09/2021 A 2.045 527 07170I2023 A 0.500 1.052 06178I2024 A D.530 1.052 06118l2024 1.505 449 Aaa 0.030 Aaa aA30 Aaa O.U30 Aaa U.030 O.OaO 79,377,745.94 0.298 A8d 0.298 79,377,715.94 D.298 � � � 0.00 U.fl10 Aaa 0.010 '1 o.00 o.fl10 naa o.o�o � Portfolio cITY Run Date: D3f2�1202i -1�;37 AP PM {PRF PM2j 7.3.17 CITY OF PALM DESERT PortFolio Management Portfolio Details - Investmenfs July 31, 2021 Avarage Purehase CUSIP ]nrestment # Issuer Balance Date CUSTODIAN PROJ�CT FUNDS 6736302440 500 GOLDMAN SACHS TREASURY FUND 6736302450 SUt GOLDMAH SACHS TREASURY FUND Subtotal and Avarage O.DO Total and Average 271,451,841.70 Par Value 0.00 0.00 4.U0 258,116,80D.58 �age 3 Statad YTMIC Days W Maturily Market Value Book Value Rate Moody's 365 MatlCal py� 6.D0 0 00 0.010 Aaa 0.010 1 D.flo O.OD 0.070 Aaa 0.010 � 0.00 0.00 O.00U 0 258,551,49D.58 258,106,085.84 0.395 75 Portfolio G�TY Run Date• 091212021 � 10:37 AP PMjPRF PM2j7.3.11 CITY OF PALM DESERT PortFolio Management Portfolio Details - Cash July 31, 2021 Averoga Purchasa CUSIP Inves6meM # Issuer Balance �ate Par Value Market Value PENDING DEPOSIT WITH COUNTY POOL SYSB51 B51 CITY OF PA[.M pESERF MAIN 01/2912p21 0.00 0.00 UNION BANK CHECKING ACCOUNTS SYS1301$ 930lB CITYOF PALM DESERTMAIN 2,600,68p,03 2,800,690.03 5YS13013 130i3 DESERT WILLOW GOLF COURSE 07l01l2020 1,858,034.48 1,856,434.48 SYSBD2 602 PUBLIC SAFETY CHECKING 07I01/2020 892,4i6.50 692,476.50 SYS73020 13026 RECREATIONAL FACILffIES CORP 07I01l2020 987.829.63 987,829.63 Averaga Salanca 0.00 Aecrued InEerest at Purchase 3,345.83 Subtotal 6,340,376.47 7otal Caah and In�eatments 271,959,849.70 264,453,831.22 264,893,867.p5 Page 4 Stated Y7MlC Days to Book Value Rate Moody's 365 MaklCal 0.00 �.000 7 2,800,690.03 1,858,034.4$ 692,4TB.50 987,829.83 3,345.83 6,34p,378.47 264,446,462.31 O.Q00 1 0.000 1 O.UDO 1 0.000 1 t 0.395 75 A Portforio cITY Run Dale: 09N2112021 -10'37 AP PM (PRF_YM2) 7.3.11 CITY OF PALM DESERT Activity Report Sorted By Issuer July 1, 2027 - July 37, 2021 Par Value Pereent Seginning CurraM transactlon CUSIP Investment # Issuer oi Portfolio 8alanee Rate Date Issuer: APPLE, INC. MEDIUM-TERM NOTES Su6total and Balance 15,OQ0,000.00 Issuer Subtota[ 5.6727: 15,000,000.0p lssuer: AMAZON.COM INC. MEDIt1M-TERM NOTES 023135BW5 662 AMAZON.COM INC. 0.450 07+1�+2�2� Su6total and Balance 0.00 Issuar Subtotal 1.134;4 4.00 I&suer: C.A.M.P. POOL (CITYj CAMP 5Y513 13 C.A.M. P. POOL (CITY� 0 050 SubWtel and 8alanee 73,031,483.44 Isauer Svbtotal 3.78394 13,031,483.44 Issuer: C.A.M.P. POOL (DESERT WILLOVII� CAMP SYS12444 12444 C.A.M P. POOL (�ESERT WI�LOWj 0.050 5ub6otal and Balance 730,148.D4 IssuerSubtatal 0.276;G 710,148.04 Issuer: �QOLED INVESTMENT FUND RIVERSIDE COUNTY pOOL 052460 052464 POOLED INVESTMENT FUND fl.28g Purchases or Ueposits 0.00 3,000,000 00 5,000,400.00 3,000,000.00 456.06 456.06 456.06 31.39 3'1.39 31.39 4.899.1 Q Par Valus Redemptions or �thdrdwa's 0.00 0 00 O.OD 0.00 3,DQ0.000.00 s,000,000.00 3,000,000.00 0.00 o.00 4.00 0.00 Ending Balance 15,000,000.00 15,a00,OD0.00 3,OQ0,000.00 3�000,000.00 10,031,938.SQ 70,031,939.50 730,179.43 734,779.A3 Portfolia CITY AP Run �ete� 0912112p21 - 11•09 pA {pRF DA) 7.3.11 ReQat Var 7.3.11 PerceM CUSIP Inveahnent # Issuer of Portfolio Sudtotal and Balance Isauer 5ubtafal 3D.D169L issuer: WALT DISNEY C�MPANY MEDFUM-TERM NOTES CITY OF PALM DESERT Activity Raport Juiy 7, 2021 -July 31, 2021 Par Yalue Beginning Currerrt Tranatletion Balance Rate Date 78,372,$46.84 78,3M,$46.$4 Subtotal and Balance S,OOO,OOD.DO Issuer SubtoffiI 1.891°� 5,000,000.00 Issuer: FEDERAL HOME LOAN BANK FEDERAL AGENCY - COUPON 3130ANAC4 664 FEDERAL i10ME LOAN BAIVK Subtota! and Balance 0.00 FEDERAL AGENCY - CALLABLE 3130AN7K0 fi60 FEDERAL HOi�AE LOAN BANK Subtotal and Balance p,00 Issuer Subtotal 2.2699L O.Op 15suer: GOLDMAN! SACHS GOVERNMEIVT FUND TRl1STEE CAS�i BALANCES 252026001-G 383 GOL�FAAN SAGHS GOVERNMENT 2520260�2-G 384 GOLDMAN SACHS GOVERNMENT 2520260D3-G 385 G4LDMAN SACHS GOVERNMEiJ7 252U26004-G 386 GOLDMAN SACHS GOVERNMEN7 252026017-G 401 GOLDMAN SACHS G01/ERNMENT 252026018-G 402 GOLDMAN SACHS GOVERNMENT 260128000-G 404 GOL�MAN SACHS GOVERNMENT 26012801i-G 478 GOLDMAN SAC1iS GOVERNMENT 261470000-G 419 GOLDMAN SACNS GOVERNMENT 261470001-G 420 GOLDMAN SACHS GOVERNMENT 26147a002-G 421 GOLDMAN SACHS GOVERNMENT Subtotal and Balance 1,863,121.86 Run Oale: D9V21/2021 - 71:09 0.5U0 07128l2U27 0.4Q0 07/29/2021 0.030 O.Q30 0.030 0.030 D.D30 0.030 Q.030 0.030 U.030 0.030 0 030 Purvhases or Deposits 4,899.1p 4,899.1Q 0.00 3,000,060.00 3,000,000.00 3.000, 00�.00 3,004,OOD.00 6,D00,006.OD 0.00 0.00 0.10 0 02 001 0 22 0.34 3.45 0 00 o.oa 38.OB 42.20 Par Vt11ue Redemptions or Withdrawals 4.00 4.00 O.OD o.oa 0.00 0.00 0.00 0.00 2.79 0.79 0.00 a.ao 363.D1 10,404.52 0.00 a.oa 5.fi6 4.37 1,774,551.29 1,785,Z32./3 Page 2 Ending Balanca 79,377,T45.94 79,3T7,745.84 5,000,000.00 S,OOO,OUO.flO 3,000,000.00 3,000,000.00 6,DOO,OOD.06 177,831.63 Partfolio CITY AP DA (PRF_DA) 7.3.11 ReppR Vef. 7.3.11 CITY OF PALM DESERT Activity Report July 1, 2021 - July 37, 2Q21 Par Value Percant Beginning Current Tronsacdon CUSIF' Investmer�tN laausr �Portfolio Balance Rate Data Issuer: GOLDMAN SACHS GOVERNMENT FUND CUSTODIAN PROJECT FUNDS 6736302420-G 647 GOLDMAN SACHS GOVERNMENT 0.030 6736302430-G 648 GOLDMAN SACHS GOVERNMENT U.U30 8738302446-G 649 GOLDHWN SACHS GOVERNMENT fl.030 8736302450-G 65U GOLDMAN SACHS GOVERNMENT fl.fl30 Sutrtotal and Balance 58,304,268.81 lasuer 5ubtotal 21.733% fi0,272,39D.67 Issuer: GOLDMAN SACHS TREASURY FUI�D � CUSTODIAN PROJECT FUNDS 5ubtotal and Balance 0.00 Isauer Subtotal 0.00076 O.DO Issuer: AMERICAN HONDA FINANCE MEDIUM TERM N07ES 02685W8F7 623 AMERICANHONDAF[NANCE 1.650 07M2l2021 Subtotel and Balance 15,000,000.00 lasusr 5ubtotal 3.78195 15,000,000.00 Issuer: LOCAL AGENCY INVESTMENT FUND U.S. BANK 1 LAIF BOND PROCEEDS 252026UO3 12-33-084 LOCAi AGENCY INVESTh4ENT FUND 0.221 SubtOtal and Balanca 4,617,690.14 LAIF 12000 12000 LOCAL AGENCY INVESTMENT FUND 0.227 Subtotal and Balance 74,238,968.5z Issuer Su6tofal 24_7697G 78,856,558.67 Run Oate: 09f21l2021 -11.p9 Purchases or Deposits � 83.90 420.60 210.00 435.90 1,250.40 1,292.60 0.00 0.00 0.00 0.00 3.770.21 3,770.29 Bb,fi73 98 60,fi13.98 64,38�.18 Par Value Redemptions a Withdrawals 570,134.84 444,383.09 125.00 125.00 9,D14,767.85 2,800,100.28 0.00 5 OOO,OOD.00 5,000,000.00 5,D00,000.40 4,617,690.14 4,61 T,690.14 8,8tl0,000.00 $.$00,000.00 13,417,59D.14 Ending Balance 5T,295,751.36 57,47�,582.98 0.00 O.QO 1 O,Op0.00p.00 1D,DOO,OQ0.00 3,770.21 65,499,582.51 65,503,352.72 Page 3 Partfolio CITY AP DA {PRF_DA} 7 3.11 Report V6[ 7 3.11 n CITY OF PALM DESERT Activity Report July 1, 2021 - July 31, 2421 Par Value Parcent Beginning Cume�rt Tranaacdon CUSIP InvestmeM# Isausr ofPortbalio Balance Rate Dabe Issuer: MICROSOFT CORPORATION MEDIUM-TERM NOTES 549418BP8 624 MICROSOF7 CORPORATION 1.550 07108l2027 5udtotal and Balance S,OOO,OOa.00 Isauer Su6total 0.000!b 5,000,000.00 Issuer: TOYOTA MOTOR CREDIT CORP MEDIIJM-TERM NOTES 892367JH9 659 TOYOFA MOTOR CREDIT CdRP 0.500 07l0812021 Suhtota! and 5alanee S,Opp,fl40.0a Issuer Subtotal 2.264°h 3,00O,OOp.Qp Issuer: CITY OF PALM DES�RT MAIN PENDING DEPpSIT WITH COUNTY POOL SubtoffiI and Ba�aace 0.00 UNIQN BANK CHECKING ACC4UNTS SYS1307B 13016 CITY OF PALM OESERT MAIN Subiotal and Balanee 5,976,T67.30 lasuer Subtotal 1.059'h 5,876,Tb7.30 Issuer: DESERT WILLOW GOLF COURSE UNION BANK CHECKING ACCOUNTS SYS13013 73013 DESERT WILLOW GOLF COURSE Subtotal and Balance 2,313,927.08 Issuer Subtotal 0.T02iG6 2,313,827.09 Issuer: PUBLIC SAFETY CHECKING UNION BANK CFEECKING ACCOIlNTS SYS602 642 PUBLIC SAFETY CMECKING Run Date• 09�112021 -11:09 Purr�ases or Depasits 0.00 O.DO 0.00 3,000,000.00 3,D00,000.00 3,000,006.00 26,426,762.44 26,42fi,762.44 x6,426,762.44 356,419.45 Si6,419.49 356,419.49 297.841.38 Par Value _ Redemptions or Withdrawals 5,000,000.00 S,OOO,OaO_DO 5,QD0,000.00 0.00 0.00 0.00 29,602,839.71 29,6Q2,839.71 29,602,B38.71 814,312.10 894,312.1D 894,312.10 'f 3.82 Ending Balance 0.06 D.00 6,OOD,000.00 6,000,000.00 D.DO 2,800,690.D3 2,800,690.03 t,ass,o3a.4s 1,856,034.48 Page 4 POrtfoli0 CITY AP DA {pRF DA} 7 3.11 Report Ver 7.3.11 0 Pereerlt CUSIP InvestrnarH # Issuer � Portfolio 5ubtotal and Balance Issuer 5ubtotal 0.2625L Issuer. RECREATIONAL FACILITIES CORP L1N[QN BANK CHECKING ACCOUNTS SYS73020 13020 RECREATIONAi FAC[LITIES CORP CITY OF PALM bESERT Activily Report July 1, 2421 - July 31, 2021 Par Va1ue Beginning CurreM Tranaactlon Balance Rate Date 384,6�$.96 384,64$.96 5ubtotal and Balar►ce 904,639.75 Iasuer SubtoffiI 0.374;4 904,639.75 ToffiI 1pD.000'� 2$4,853,51fl.76 Run Qate� 09R112021 -11:09 Purchases or Depasils 28T,841.36 297,841.36 159,834.13 159,834.1 S 158,834.13 39,31l,920.78 Par Yalue Redemptions or W�thdrawals 13.82 13.82 78,644 25 7fi,b4415 76,511.25 59,711,fiR0.30 Ending Balance 692,47B.50 69Z,476.50 9$7,829.63 987,828.63 264,453,831.22 Page 5 Portfolio cITY AP DA {PRF DA) 7 3.11 R6port Yer. 7 3.11 CITY OF PALM DfSERT LONG-TERM LQANS RECEIVABLE 1u�y 31, 2021 21-Sep-21 11:39 AM SymPro No. Investment Boak Value Maturity Date Stated Interest Rate � City Loan to RDA* 3�� EIP Loan ** 594 Highlands l�tility Undergrounding *** Assessment District 04-01 Deferred Loan $ 10,575,462.50 N/A $ 1,394,040.00 09/02/34 $ 14,977.73 09/02/36 0.2230 7A0°�o ��3� Footnotes * On May 17, 2019, rhe California State Department of Finance (DOFJ denied the 1986 City toan in the principa! arrtount of $b,p00,Q00 as an enforceable obligation of the SuccessorAgency of �he Palm Desert Redevelopment Agency. Severa! attempts have 6een mude to challenge this decision. The DOF, however, continues to maintain rts position and its interpretation of the dissvlution !aw as it relates to the loans. ** EIP balance adjustments made on March 2 and on September 2 of each year. *** Highlands balance adjustments made an March 2 and an September 2 of each year. PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Summary July 3'1, 2021 Investments GAI�4P LAIF CUSTODIAN PROJECT FUNDS Investmerets Cash PassbooklChecking (nut inGuded in yiefd qlcula6ons) Total Cash and Investrnents Par VaEue 48,824,227.18 97t,444.20 4,538,094.86 54,734,766.24 3,434,654.60 58,169,420.$4 Market Value 4B,824,227.18 971.444.20 4,939,084.86 54,734,T66.24 3,434,654.b0 58,169,420.84 Book 9�. of Value PortfolEo 48,824,227.18 89.20 971,444.20 1.77 4,939,094.86 9.02 54�734,766.24 100.00°Ya 3,434,854 6a 58,169,420.84 pnys �o Ma�t.ICall Term 1 1 1 1 1 1 1 1 1 1 YTiNlC 365 Equiv. 0.050 0.221 0.03Q 0.051 a,oaa 1 1 0.051 Total Eamings July 31 Montii Ending Fiscal Year To Date Current Year 2,440.92 2,440.92 Average Daily Balance 58,127,870.97 Effecti�e Rate oi Retum 0.05% This imestment ortfoiio complies with the provisions of Califomia Govemment Code Section 53601 and the City oi Palm Desert invesRment policy. Barring unforeseen events, it has sufficienR cash to fund Ho ' Authority operati ns the next six months. All bal��y�han balances. The "°,6 of Portfolio" calculation on the Portfolio Summary page omits demand deposrts. Janet M, , Director of Finance Cityr �Feasurer / � Raporting period 0710112421-07l3112021 �, o.�. osrz+rzvz� - io:as Portfolio HA AP IE (PRF PMT) 7.3.11 Report Ver. 7 311 PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Details - lnvestrnents July 31, 2021 CUSIP Imresknerrt# Iasuer Avara9e Purchase Ba�anee Date CAMP SYS12008 12008 CA ASSET MANAGEMENT PROGRAM 5ubtotaland Average 48,822,796.25 CUSTO�IAN PROJECT FUNDS 6736302460 590 GOLDMAN SACHSTREASURY FUND Subtofal and Average D.00 LAIF 5YS21003 21003 LOCAL AGENCY INVESTME�IT FUND Subtotal and Average 571,086.29 CUSTODIAN PROJECT FUNDS 873fi302460-G 597 GOLDMAN SACHS GOVERNMENT 01I01l2021 Subtotal and Avarage 4,939,084.8fi Total and Average 58,127,870.97 Run Date: 09R�12021 -1p;46 Par Value 48,824,227.1 S 4a,sza,zn.Ts 0.00 O.p6 971,444.20 971,444.20 4,939,094.86 4,939,094.86 54,734,766.24 Page 1 Stated Daya to YTMlC M��y Markat Value 600k Yalua Rate Moody's MatlCal �65 pa� 48,824,227.18 48,824,227.18 0.050 1 0.050 as,ssa,227.18 as,au,a.�r.�s a o.oso 0.00 0.00 971,444.20 971,444.20 4,939,094.86 4,939,D94.86 54,734,766.24 0.00 0.010 Aaa a.00 971,444.20 D.221 971,444.20 1 0.010 0 0.000 1 0.221 1 0.22t 4,939,U94.86 0.030 Aaa 1 0.030 4,939,094.8fi 1 0.030 3M1,734,7fi6.24 1 D.D51 Portfolio HA AP PM (PRF_PM2} 7 3.11 Report Ver. 7 3.41 CUSIP InvestmerK# �ssuer CHECKING SY525015 25015 HOU5ING AUTH CH6CKING 5YS25016 25016 HOUSING AUTH TRUST Average Balance Tota! Cash and Investments 58 PALM DESERT HOUSING AUTHORITY Portfolio Management PortFolio Details - Cash JuEy 3'!, 2429 Average Purehase 8alanea Date Par Value Market Value 2 976,414.10 2,976,414.10 07I01I2020 458,240.50 458,240.50 0.00 7,870.97 58,169y420.84 58,169,420.84 Page 2 Stated Days to YT11AlC Book Value Rata �Uaody's Mat1Ca1 365 2,978,414.1 U 1 0.000 ase,zao.sa i a.000 1 58,169,420.84 9 0.051 � PortfOlio HA Run oace o�r2+naz� _ �o;a6 AP PM {PRF PM2) 7.3.11 RDA SUCCESSOR AGENCY PortFolio Manageme�t Portfolio Summary July 31, 2021 Investmerrts R1VER51DE CdUNTY Ppp� CAMP LAIF TRUSTEE CASH BALANCES - MMA TRUSTEE CASH BAI.ANCES - GF fnvestrnents Cash Pass600WCheCking (not induded in yield calculations) Total Cash and Investments Par Value 335.87 5,728.31 742.08 38,993,670.85 786,588.24 37,787,OQ5.33 9,877,981.07 39,864,966.40 Market Value 335.87 5,728.31 742.06 3&,893,610.85 786.588.24 37,787,005.33 �,sri,sa�.o� 39,664,988.4D Book Value 335.$7 5,72B.31 742.06 36,993,67U.85 786, 5E8.24 9L of Fortfolio O.OU a.o� 0.00 97.90 2.08 37,78T,D05.33 140.00% 1,877,987.07 39,664,986.40 Days to MatlCall 1 � 1 1 1 1 Term 1 � 1 1 1 1 7 7 1 t YThAlC 365 Equlv. 0.298 0.050 0.221 0.010 0.03Q 0.010 4.U00 o.a�o Totaf Eamings July 3� Mo�h Ending Fiscal Year % Date Current Year 175.00 175_OQ Average Daily Balance 39,692,587.01 Effecti�e Rate of Return 0.0196 ihis investment porlfalio is in compliance w+th the provisions of Califamia Go�ernment Code 5ection 53647 and the City of Palm Desert irnestment policy. Pursuant to ABX126, the availability of cash to fund the Palm Desert RDA Successor Agency's debt servioe is dependent upon the County of Riverside and the State of Califomia. All balances are bank baiances. The "0/a af Portfolio" calculation on the Portfolio Summary page omits clemand deposits. ��/� Janet . oore, Finance O(ficer � � / Reporting period 07101l2021-07l3112021 Run Date: 09f27f1p21 -10:59 Portfolio RDAS AP IE (PRF PM1) 7 3.11 Report Ver. 7.3.11 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Investments July 31, 2021 CUSIP Investment # Issuer ea ance pu�Dabe iiIVERSIDE COUNTY POpt 05247U 052470 POOLED INVESTMENT FUND D7101I2020 Su6total and Average 335.65 CAMP SYS578 578 CA.M.P. POOL (RDA S.A.) Subtotal and Avarage 5,728.07 LAI� SYS804 604 LA.I.F. (RDA S.A.) 07ltl1l2020 Subtotal and Average 741.78 TRUSTEE CASH BALANCES - MMA 247394001-{1 830 ll S. BANK MQNEY MARKETACCOUNT 07/01/2020 247394003-U 832 U S. BANK MQNEY MARKET ACCOUNT 07109I2020 247394002-U 833 U.S. BANK MONEY MARKETACCOUNT 247394000-U 834 ll.S.$ANKMONEYMARKETACCOUNT 236781002-U 837 U.S BANKMONEYMARKETACCOUNT 236751003-U 838 U.S. BANK MOIVEY MARKET ACCOUNT 07101I2U20 236781flD0-U 839 U,S. BANK MONEY MARKET ACCOUNT 253446003-U 842 U.S. BANK MONEY MARKETACCOUNT 07l071202� 2534460Q2-U 843 U.S. BANK MONEY MARICETACCOUNT 253446000-U 844 U.S. BANK MONEY MARKET ACCOUNT 253446001-U &15 U.S. BANK MONEY MARKET ACCOUNT 07I01/202d 224324000.0 853 U.S. BANK MONEY MARKET ACCOUNT 224324001-U 855 U.S. BANK MOA[EY MARKET ACCOUNT 07I01J2020 224324002-U 858 U.S. BANK MONEY MARKET ACCOiJNT 224324003-U 857 U S. BANK MpNEY MAiiKET ACCOUNT 07101I2020 238789001-U 881 U.S. BANK MBNEY MARKETACCOUNT 0910i12020 Subtotai and Average 36,993,610.85 TRUSTEE CASH BALANCE5 - GF 2778&7000-G 8'!1 GOLDMAN SACHS GOVERNMENT 2778B10D1-G 812 GOLDMAN SACMS GOVERNMENT 2778640Q2-G 813 GOLDMAN SACHS GOVERNMENT O7l0112p20 277861003-G 814 GOLDMAN SACHS GOVERNMENT 07IU112020 R�+ oace. osrz�no2i - �o ss Par Vatue 335.87 335.87 5,728.31 5,728.31 742.06 742.�6 0.13 a.00 2U7,502 5$ 870,315.09 2,930,036.52 0.00 10,617,743.45 0.00 1, 530,019.08 5,546 677.03 1.02 1fl,907,259.D2 1.98 4,390,054.72 0.00 0.24 �B,993,614.85 788,588.24 0.00 O.OQ 0.00 Page 1 Statad Qays to YTMIC Maturity Marlcet Value Book Value Rate Moody's MatlCal 365 Date 335.87 335.87 0.298 Aaa 1 0 298 335.87 335.87 1 0.298 5,728.3i i,728.31 742.06 742.06 0.l3 o.oa 207,502.SB a�a,als.os 2,930,036.52 0.00 i 0,617,743.48 0.00 1,530.019.08 5,546.877.03 1.02 70,901,258.02 1.96 4,390,054.72 a.ao 0.24 36,993,610.85 786,588.24 O.OU 0.00 O.OU 5,728.31 0.050 5,728.31 742.06 0,221 742.06 0.13 6.610 o.00 o.oTo 207.502.58 U.010 870,315.09 0.010 2,930,036.52 0.010 0.00 0.01 D 10,617,743.46 0.010 0.00 0.010 9 530,0�9.08 0.010 5.546,677.03 0, 01 D 1.D2 0.010 10,901,259.02 0.010 1.96 D.010 4,390,054.72 D.010 o.00 o.o�o 0.24 0.070 38,993,610.85 P-1 P-1 P-1 P-1 P-1 P-1 P-1 ?-1 P-1 P-1 P-1 P-1 P-1 P-1 P-1 P-7 1 0.050 1 0.050 7 0.221 1 0.227 1 0.010 i a.a10 1 6.010 1 0.010 1 4.U10 1 0.010 � o.a�a 1 0010 1 0.010 1 0.010 1 0.010 i 0.01 D i 0.010 1 0,01p � o.a�a � o.o�a 1 0.010 786,588.24 O.U30 Aaa 0.00 0.030 A88 D.00 0.030 Aaa O.DO 0.030 Aaa 1 D.030 1 0.030 1 O.U30 1 O.U30 Portfolio RaAS AP PM (PRF_PM2} 7 3.11 Report Ver. 7 3.11 CUSIP InvestmeM # Issuer Subtotal and Averaga Total and Averaga RDA SUCCESSOR AGENCY PortFolio Management Portfolio Details - Investments July 31, 2021 Average Purchase Balance Data �ss,5sa.0 39,B92,587.01 Par Value 786,588.24 37,787,005.33 Markat Va�ue 786,588.24 37,787,005.33 Baak Value �as,sss.0 37,787,005.33 Page 2 Stafed Days Lo YTiIAlC Rate Maody's MatlCal 365 � a.oso 1 0.010 Portfolio RpAS Run Date: 09/2112021 - 70'59 AP PM {PRF PM2j 7.3.11 RDA SUCCESSOR AGENCY PortFolio Management Portfolio Details - Cash July 31, 2021 Average Purchase CU51P Investmerrt # taauer Balance D� Par Value Market Value UNION SANK CHECKING ACCOUNTS SYS582 582 RQASUCCESSORAGENCY 1,877,981.07 � 877,981.07 Average Balanee O.Oa Total Cash and InvestmaMs 39,692,587.p1 38,B64,986.40 39,6fi4,986.40 Page 3 Stated Days to YTAAlC Book Yafue Rats Mood�'a MatlCal SBS 7,877,981.07 1 0.000 1 39,664,986.46 1 0.010 Portfolio R�AS R�n o�e� o9rzinozi -io:ss AP PM {PRF PM2j 7,3.11 � Zi-Sep-21 11:43 AM SymPro No. 738 rr�vestment EIP Loan * Footnotes EIP balance adjustments made an March 2 and September 2 af each year. PAIM DESERT RDA SUCCESSOR AGENCY LONG-TERM LOANS RfCEIVABLE JULY 31, 2021 � Baok Val�e 542,000.00 Maturity Date 09/02/29 Stated Interes# Rate 3.00% CITY OF PALM DESERT Portfolio Management Portfolio Summary June 30, 2021 Investments CqMP U.S. BANK 1 LAIF BOND PROCEEDS LAIF TRUSTEE CASH BALANCES MEDIUM-TERM NOTES CUSTddIAN PROJECT FUNDS RNERSIDE COUNTY POOL Investments Cash PassbooklChedcing (not included in yiefd plculations) Total Cash and Investments Par Value 13,761,635.48 4,817,690.14 74,238,96$.53 1,963,721.86 43,000,000.00 58,3a9,268.87 79,372,84B.84 275,263,52T.66 9,589,983 i0 264,853,510.76 Market Valus 13,781,831.48 4,617,890.14 74,238,888.53 1,963,121.88 43,477,800.00 58,309,268.81 79,372,846.84 275,74t,32T.65 9,589,983.10 2$5,331,310J6 Book Value 13,767,63'i.48 4,fi17,690.14 74,238,988.53 1,963,127.86 42,98�,369.47 58,309,288.87 79,372,846.84 275,253,89T.0T 9,589,983.10 264,843,880.17 9L of Portfolio 5.00 1 68 26 97 0.71 15.62 21.18 28.84 Too.00� Days bo MaLlCall 1 1 1 1 356 1 1 sr Term 1 7 7 1 942 1 1 148 1 1 57 148 YTMlC 365 Equiv. 0.050 0.282 0.282 O.p30 7.693 0.030 0.266 0.426 a.00a 0.426 7ota[ Eamings June 30 Month Ending Fiscal Year To Date Fiscal Year Ending Current Year 84,723.94 1,365,423,26 1,365,423.2fi Averege Daily Balance 275,793,109.00 x58,T60,183.33 Effective Rate of Retum 0.37% a.53°k This i�vestrnent pprtfolio is in compliance with the pro�isions of Califomia Gavemment Code Section 5366� and the City of Palm DeseR in►restment policy. Barring unforeseen e►rents, it has sufficient cash to iund city expenditures for the next six months. Union Bank Custody Ser►iices has provided market value prices for all corporate securities. All balances are 6ank balances. The "36 of lio" calc 'on the ortfolio mmary page omits demand d�pO�. � 7�/ Jan�i,M!FAoore, Director of FinancelCit�Treasurer �' Reporting period 0610112021-0613Dl2021 Run Dete: 09/21/2021 - 30�35 Portfo�io CITY AP IE (PRF_PM1 J 7 3.11 Raport Vx. 7.3.11 C1151P InvestmeM # Issuar CAMP CITY OF PALM DESERT PortFolio Management Portfolio Details - Investrr�ents June 30, 20x1 Averaga Purchase Balance D� Par Value Market Value SYS13 13 C.A.M.P. POOL (Cf'fY) SYS12444 12444 C.A.M.P. POOL (DESERT WILLOV� Subtotal and Average 7,228,004.72 U.S. BANK ! LAIF BONO PROCHEd5 2520260D3 12-33-084 LOCAL AGENCY INVESTMENT FllND 5ubtotal and A�erage 4,64T,690.14 LAIF 12p00 12000 LOCAL AGENCY INVESTMENT FUND Suh6Dtel and A�erttge 74,238,968.53 TRUSTEE CASH BALANCES 2520260D0-G 382 GOLDMAN SACHS GOVERNMENT 252028001-G 383 GOlDMAN SACHS GOVERNMENT 252azeo02-G s8a GOLp6nAN SACHS GOVERNMENT 252028003-G 385 GOL�MAN SACHS GOVERNMENT 252U26004-G 3E8 GOLDMAN SACHS GOVERNI4AENT 252026017-G 401 GOLDMAN SACHS GOVERNMENT 252026018-G 402 GOLOMAN SACHS GOVERNMENT 260128000-G 404 GOLDNIAN SACHS GOVERNMENT 280128004-G 405 GOLDMAN SACHS GOVERNMENT 280128002-G 407 GOLDMAN SACHS GOVERNMEkT 260128003-G 408 GOLDMAN SACHS GOVERNMENT 260128004G 409 GOLDAAAN SACHS GOVERNMENT 260728005-G 410 GOLDMAN SACMS GOVERNMENT 26U128006-G 412 GQLDMAN SACHS GOVERNMEN7 280128007-G 414 GOLDMAN SACHS GOVERNMENT 26fl128008-G 415 GOLDMAN SACHS GOVERNMENT 260128009-G 416 GOLDMAN SACHS GOVERNMENT 260128ot0-G 417 GOLDNIAN SACHS GOVERNMEIVT 260128Q11-G 418 GOLDMAN SACHS GOVERNMENT 267470000-G 419 GOLDMAN SACHS GOVERNMENT 281A70U07-G 420 GOLDMAN SACHS GOVERkMEN7 261470002-G 421 GOLDMAN SACHS GQVERNMENT R� o�s: osn�no2� - �aas o»a�no2o U71D1I2020 U7107I2p20 07101l2fl20 07101I2020 47I0112020 13,031,483.44 730,148.04 13,761,631.48 4,677,590.14 4,617,69D.14 74,238,968.53 74,238,958.53 0.00 2.78 0.79 0.15 830.8B 363.00 10,404.30 15,968.36 U.00 0.00 0.00 o.oa 0.00 o.oa OAO 0.00 0.51 0.30 160,889.48 5.66 4.37 9,774,55'l.29 13,031,483.44 730,148.D4 13,761,631.48 4,617,690.14 4,617,690.14 74,23$,968.53 71,238,968.53 0.00 2.79 tl.79 0.15 930.86 363.00 1 D,404.30 75,968.38 o.oa a.aa 0.00 o.00 0.00 o.00 0.00 0.00 0.51 0.30 160,889.48 5.66 4.37 1,774,551.29 Page 9 Sfated YTMIC Days to AAaturity Book Value Rate Moody's 365 MatlCal p� 13,031,483.44 0.050 730,748.04 O.O5d 13,761,639.48 0.050 'i a.aso � 8.050 1 4,617,890.14 0262 4,617,690.74 74,238,968.53 0.262 74,238,968.i3 a.00 a.aso 2.79 0.030 0.79 D.D30 0.15 0.030 930.88 4.Q30 363.00 U.030 40,464.30 O.fl30 15,968.38 0.�30 0.00 0 030 0.00 0.030 0.00 0.030 D.00 0.030 0.00 0.030 o.ao o.oso 0.00 0.030 0.00 0.030 0.57 0.030 0.30 0.030 180,889.48 0.03U 5.66 0.030 4.37 0.030 1,774,551.29 0.030 0.262 1 0.262 1 0.262 1 0.262 1 Aaa 0.030 Aaa 0.03U Aaa 0.030 Aaa 0.030 Aaa 0.030 Aaa 0.030 Aaa 0.030 Aaa �.030 Aaa 0.030 Aaa 0.030 Aaa 0.030 Aaa 0.030 Aaa 0.030 Aaa o.osa Aaa 0.030 Aaa 0.030 Aaa a.030 Aaa 6.030 Aaa 0.030 Aaa 0.030 Aaa a.fl30 Aaa fl.U30 � � � 1 1 7 1 1 1 7 1 1 1 � 7 1 1 1 1 1 1 1 Portfolio CITY AP PM {PRF PM2) 7 311 Report V9r. 7.3.11 Average CUSIP Investmar�t# lasue� Balance Subtntal and Average 1,963,t21.88 MEDIUM-FERM NOTES 037833DL't 614 APPLE, INC. a37833DL1 618 APPLE, INC. 254867FJ0 625 WALT DISNEI( COMPANY 02665W8G5 675 AMERICAN HONUA FINANCE 02685WDG2 617 AMERICAN HONDA FINANCE 02665WBF7 623 AM@RICAN HONDA FINANCE 549418BP8 624 MICROSdFT COliPORATION 89238TJH4 658 TOYOTA MOTOR CREdIT CORP Subtotal and Average 45,289,244.53 CUSTODIAN PROJECT FUNDS 6736302420-G 847 GOLDMAN SACHS GOVERNMEtJT 6736302430.G 648 GOLDMAN SACHS GOVERNMENT 6736302440-G 649 GdLDMAN SACHS GOVERNMENT 6736362450-G 650 GOLDMAN SACHS GOVERNMENT Su�total and Arrerage 58,309,268.81 ii�VERSIDE COUN3Y PpOL 052460 052460 POOLED INVESiMENT FUND S�btota! sed Average 79,368,917.95 CUSTODIAN PROJECT F[1NdS 6736302420 498 GOLDMAH SACHS TREASURY FUND 6738302430 499 GOLDMAN SACHS Ti2EASURY FUND 6736302440 500 GOLDMAN SACHS TREASURY FUND 6736302450 501 GOLDMAN SACHS TREASURY FUNO Subtotal and Avarage 0.00 Total and Avarage 275,783,109.Otl CITY OF PALM DESERT Portfolio Managemen# Portfolio Details - Investments June 30, 2021 Purehase Rate Par Valus 1,963,121.86 Market Vafue 1,963,127.86 09111l2019 09l2512019 17/20/2019 D9109I2079 09127I2079 � ��srza�a 11120I2079 06118f2021 01101I2027 011Q7l2021 o��a��zoz� 01l01I2027 s,000,oaa.00 t0,000,006.D0 fi,400,000.00 S,OOO,OOO.UO s,000,000.00 �,000,00a.ao 5,000,000 00 3,000,000.00 �3,DQ0,040.06 8,579,817 9B 19,614,987.82 s,�ae,ea2.a� 20,328,586.38 SB,309,268.8i 79,372,846.84 79,372,846.84 0.00 D.OQ 0.00 0.00 0.00 275,263,527.66 5,087,950 00 10,175,900.00 5,078.800.00 S,Di 3,5SO.Oa 5,131,500 00 s,002,aoo.oa 5,001,200.00 2,988,800A0 41,477,8D0.00 8,579,817.9fi 19,674.087.62 s,7se eas.s� 2a,326 586.36 58,309,2fi$.81 79,372,848.84 T9,3T2,846.84 a.00 0.00 0.00 o.00 o.00 275,741,527.66 Page 2 Sffitad YTMlC Daya to Iy�aturity Sook Yalue Rate Moody's 365 MatJCa1 Date 1,963,121.8B 0.030 1 4,999.418.70 1.700 9.895.929.92 1.700 4,997,713.29 1 5S0 4,997,832.97 i 700 4,999.976.80 2 050 4,999.752. 78 1.650 4,999,745.55 1.550 3,000,000.00 0.500 4x,990,369.41 8,579,811.96 0.030 Aaa 0.030 19.614,087.$2 0.030 Aaa 0.030 9,7B8,802.87 0.030 Aaa 0.030 20,32B,56B.36 0.030 A8a d.030 58,309,268.87 0.030 Aa 1.710 437 09111I2022 Aa 7.735 I37 09N 1l2022 A 7.690 427 09I0112022 A 1.935 70 09I09@021 A 2.045 558 01l10l2U23 Aa 7.Si5 11 07N2l2021 Aaa 7.600 38 08lD8/2021 A 0.500 1,083 OB178@D24 1.693 356 79, 372.846.84 0.268 79,372,846.84 o.00 o.oao a.00 o.o�o U.00 O,D1p U.flO 0.076 o.00 275,253,897.07 � Aaa 0.268 1 0.268 1 Aaa 0.010 1 Aaa 0.670 1 Aaa 0.010 1 Aaa a.a�o 1 a.aoo a 0.426 57 Portfolio CITY Run Oate: 09f27l2021 -10:35 AP PM (PRF_PM2) 7.3.11 CITY OF PALM DESERT Portfolio Managemeni Portfolio Details - Cash June 3D, 2t}21 CUSIP Invesfinent# lssusr Average P�r�hase Balance Date Par Value Market Value PENdING DEPOSfT WITH COUNTY POOL SYSB51 651 CfTY OF PALM DESERT AAAIN 01I29l2021 0.00 6.00 UNION BANK CHECKiNG ACCOUHYS SYS13016 73076 CITY OF PALM DESERT MAIN SYS13013 13013 DESERT WILLOW GOLF COURSE SY5$02 602 PUBLIC SAFETII CHECKING 5YS13020 73Q20 RECREATIONAL FACILiTIES CORP Average Balanee 0.00 Total CBsh and InveakmeMs 275,793,1�9.00 5 976,767.30 5,976,767,30 07I0112020 2,313,927.Q9 2,393,927.09 07l01l2020 394,848.96 394,648.96 a7l01I2020 904,639.75 904,639 75 2$4,853,510.76 285,331,�10.76 Page 3 Statad YTM1C Days to Book Value Rate Moody's 365 MatlCal 0.00 O.OQO 1 5,97B,767.3D 0.000 1 2,313,927.08 0.000 1 394,848.96 0.400 9 904.639.75 0.000 9 1 284,843,880.17 0.426 57 � Portfolio CIiY Run Date: 49f21l2p21 -10:35 AP PM (PRF PM2) 7.3.11 CITY OF PALM DESERT Activity Report Sorted By Issuer June 1, 2021 - June 30, 202�! Par Value Peroe� Beginning Cument TransactEon Purchases or CUSIP InvestmeM� lasuer �p�o��o Balance Rate Date peppsits Issuer: APPLE, INC. MEDIUM-TEWN NOTES Su6total and Balance 15,000,000.00 Issuer 5ubbotal 5.266% 75,000,000.00 lssuer: C.A.M.P. POOL {CITY) CAMP SYS13 i3 C.A.M P. POOL {CfTY) Sudtotal and Balance 6,031,2i5.22 lasuar Subtotal 4.b75!4 6,031,215.22 IsSuer: C.A.M.�. POOL (DESERT WILLOVYj CAMP SYS12444 12444 C.A M.P. PQOL (DESERT WILLOIA� Su6total and Balanca 730,117.89 lsauerSu6total 0.2569L 730,717.89 Issuer: POOLED INVESTMENT F�1ND RIVERSIDE COUNTY POOL 05246d 052480 POOLED INVESTMENT FUND Subtotal and Balenca 79,333,Si7.94 Issuer Subtatal 27.864;G 79,333,557.94 Issuer: WALT DISNEY COMPANY MEDIUM-TERM NOTES Subbotal and Balance 5,pp0,000.pp o.osa 0 050 0.289 O.OD �,000,zse.22 7,D00,268.22 7,OOQ,268.22 34.15 30.15 30.ii 39,288.90 38,288.90 34,288.90 Par Value Redemptlons or Wrthdrawais 0.00 a.00 D.00 4.00 0 00 0.00 0.00 0.00 0.00 Q.00 Entling Balance 15,000,000.00 15,000,000.00 13,031,483.44 13,431,483.44 730,146.04 730,148.04 T9,372,846.84 79,372,846.84 5,000,000.00 PoRfolio cITY AP Run Date' 49721f2021 -11: p8 LiA (PRF DA) 7 3.11 Raport Ver 7 3.11 CITY OF PALM D�SERT Activity Report June 'E, 202'I - June 3Q, 2021 Par Value PercerH Beginning Curre�rt Tranaaction CU51P Inveatme�# Issuer ofPortfolio Balanca Rate Date lasuer Su6total 1.755% 5,000,000.00 issuer: GOLDMAN SACHS GOVERNMEN7' FUND TRUSTEE CASH BALAiVCES 252626004-G 386 GOLDMAN SACHS GOVERNMENT 252D26D17-6 401 GOLDMAN SACHS GOVERNMENT 252a26Q1&G 402 GOLDMIAN SACHS G4VERNMENT 260128000-G 404 GOLDMAN SACHS GBVERNMENT 260128017-G 418 GOLDMAN SACHS GOVERNMENT 261470002-G 421 GOLDMAN SACHS GOVERNMErlT Svbtotal and Balance 1,963,O7B.35 CUSTOOIAI� PROJECT FUNDS 6736302420-G 647 GOLDMAN SACMS GOVERNMENT 6736302430-G 648 GOLDMAN SAGHS GOVERhMENT 6736302440-G 649 GOLDMAN SACHS GOVERNMENT 6736302450-G 650 GOLDMAN SACHS GOVERNMENT Subtotal and Balance 5$,307,979.41 Iss�er Subtotal 21.159x 60,271,D49.76 Issuer: GOLDMAN SACHS TREASURY FUND CUSTODIAN PROJECT FUNDS Subtotal and 8alanea 0.00 Issuer 5u6total 0.000!6 0.00 Issuer: AMERICAN HONDA FINANCE MEDIUM-TERM NOTES 5ubtotal artd Balance 15,000,000.00 taauer SuGtofal 5.26656 15,000,000.00 Issuer: LOCAL AGENCY ENVESTMENT FUND U.S. BANK 1 LAIF BOND PROCEEDS Run pale: D912112U21 - 71 DB 0.03U D.D30 0.030 0.030 0,030 0.030 o.osa 0.030 D.030 0.030 Purchases ar Deposits 0.00 0.02 0.01 0.23 0 35 3 57 39 33 43.51 �s� �a 438 23 z�7 00 450 43 1,297.40 t,340.91 0.00 0.00 Par Value Redemptions or Withdrawats 0.00 a.00 a.ao a.00 O.UO O.UO 0.00 0.00 End[ng Balance 5,000,000.00 1,963,121.86 Page 2 o.00 0.00 O.UO U.40 0.00 58,309,2fi8.81 0.00 64,272,590.67 0.00 0.00 0.00 15,400,0OO.OD 0.00 16,000,0OO.OD Portfolio CITY AP DA {PRF DAy 7 3.11 Report Ver. 7 3.11 GITY OF PALM DESERT Activity Report June 1, 2D21 - June 30, 2021 _ Par Value Percetrt Beginning CurreM Transaction CUSIP Invesfinent # issuer of PorNollo Balanca Rate pate Subtotal and Balance 4,517,690.14 lAIF SubtoSal and Balance 74,238,968.53 �ssuer Subtotal 27.fi63�. 78,856,658.fi7 Issuer: MICR050FT CORPORATION MEDIUM-TERM HOTES Subtofal and Balanca i,000,000.00 Isauar 5ubtotal 1.755!b 5,000,000.00 Issuer: TOYOTA MOTOR CREDIT CORP MEDIUM-TERM NOTES 89236TJH9 658 TOYOTA M0T4R CREDIT CURP Subtotal and Balanee 0.00 Issuer Subtotai 1.053X 0.00 issuer. CITY OF PALM DESERT MAIN PENDiNG DEPOSIT WITH COUNiY POOL Su6total and Bafance p,pp UNION BANK CHECKING ACCOUNTS SYS13018 13018 CI7Y QF PALM DESERT MAIN Subtotal and Balance 4,9T9,23B.42 Issuar Subtotal 2.D98% 4,979,23fi.42 Issuer: DE5ERT WILLOW GOLF COURSE llNIOH BANK CHECKING ACCOUNiS 5YS13013 i30t3 UESERT WIL�OW GOLF CBURSE Su6total and �alanee 2,250,503A4 IsauerSubtotal U.6127G 2,250,SOS.�� Run Data� p912112029 -19:fl8 0.500 06/16/2021 __ . Par Value Purchases or Redemptions or Deposits Withdrawals 0.00 0.00 3,Ob0,000.00 3,DOO,ODG.00 3,000,000.00 16,533,429 07 16,533,429.D7 16,553,429.07 709,034.95 709,034.95 709,034.95 O.OG 0.00 0.00 0.00 0.00 15,535,698 19 15,535,888.19 i5,535,898.14 645.81 i.27 645,fi11.27 645,811.27 Ending Balance 4,61T,69D.14 74,238,968.53 78,856,65$.fi7 i,000,000.OQ 5,000,000.00 3,000,0OO.OG 3,040,000.00 0.00 5,976,7fi7.30 5,476,7BT.30 Page 3 2,315,927.09 2,313,927.D9 Portfolio CITY AP DA ; PRF_DA; 7 3.11 Repprt Ver. 7.3.19 PBrGeM CUSIP InveadnerHi� Iasuer ofPorlfolio Issuer: PUBLIC SAFETY CHECKING UHION BANK CHECKING ACCOUN7S 5YS602 602 PUBLfC SAFETY CiiECKING 5ubfntal and Balance Issuer 5ubtotal 0.139°ti Issuer: RECREATIONAL FACILlTIES CORP UNION BANK CHECKING ACCOUNTS SYS13020 73020 RECREATIONAL FACILITIES CORP CITY QF PALM DESERT Activity Report June 1, 2D21 - June 30, 2021 Par Va1ue Beginning CurreM Transaction Balanca Rate pate 714,077.63 774,077.63 Subtotal and Balance SO6,Q6fi.70 lasusr Sulftotal 0.39856 806,066.70 Total 700.000'G 273,972,483.64 R�� a�e: osmno2� - i �.os Purchases or Deposits 387,530 86 387,530.86 187,530.$6 208 297.82 2D8,247.82 208,297.82 27,879,22Q.88 Par Value Redemptions or Withdrawals 706,859.53 706,959.53 706,959.i3 109.724.77 109,724.77 109,724.77 16,998,193.76 Ending Balance 394,648.96 394,648.96 904,639.75 904,639.75 284,853,510.76 Paga 4 Partfolio CITY AP DA (PRF pq) 7,3.11 RepoR Ver. 7.3.17 n CITY OF PALM DESERT LONG-TERM LOANS RECEIVASLE iUNE 30, 2021 21-Sep-21 11:36 AM Sym Pro No. I nvestme nt Book Value � 10,575,462.5Q � 1,394,000.00 Maturity Date Stated Interest Rate X City �oan to RpA* 348 E1P Loan ** ��4 Highlands EJtility Undergrounciing *** Assessment District 04-01 Deferred Loan $ 14,977.73 N/A 49/02/34 09/02/36 0.26% 7.00% ��•i'A Footnotes * On May 17, 2019, the California State Deportment of Finance (DOFJ denied rhe 1986 Gty Loarr in the principa! amount of $S,OOO,Q00 as an enforceable obligation of the SuccessorAgency of i�he Palrrr Desert Redevelopment Agency. 5evera! atiempts have been made to challenge rhis decision. The DOF, however, continues to maintain its position and its interpretation of the dissalution law �s it relates to the loans. ** EIP balance adjustments made on March 2 and on September 2 of each year. *** Highlands balance adju5tments made an March 2 and on September 2 of each year. PALM DESERT HOUS[NG AUTHORITY Portfolio Management Portfolio Summary June 30, 2021 Investments CAMP U11F CUSTODIAN PROJECT FUNDS Investments Cash PassbooklGhecking (not included in yiefd calr.utations) Total Cash and Investments 1 0 000 7 0.052 Total Eamings June 3Q Morrth Ending Fiscal Year To Data Fiscal Year Ending Current Year 2,4fi5.85 67,353.46 67,353.46 Average Daily Balance 59,068,790.34 Effective Rate of Retum 0.0590 This investment portfolio complies with the pro�isions of Califomia Govemment Code Section 53601 and the City of Palm Desert investment policy. Barrir�g unforeseen events, ii has sufficient cash to fund H Authority ope ns for ne six months, All balance are ba k balances. The "� of Portfolio" calculation on the Portfolio Summary page omits demand deposils_ q a-�%a-� Janet , Director of FinancelCity Tre�surer / � Reporting period 0610112021-05130l2021 Portfolio HA R�n o�� asrz�rzos� - �o�aa AP IE (PRF_PM1} 7.3.11 Report Ver. 7 3.11 Par Value 48,822,928.55 970,651.69 4,938,988.96 54,731,769.20 3,394,188.20 58,125,957.40 Market Value 48,822,128.55 970,651.$9 4,938,988 96 54,731,769.20 3,394 188.20 58,125,957.40 Book ;G of Value Portfolio 48,822,128.55 88.20 970,651.69 1.77 4,938,988.96 9.02 54,T31,7$9.20 100.a0°k 3, 354,18B.20 58,t25,957.40 Daya to YTM1C MaLlCall Tertn 165 Equlv. 1 1 0.050 1 1 0.262 1 1 0.030 1 1 0.052 f 1 PALM DESERT HOUSiNG AUTHORfTY Portfolio Management PortFolio Details - Investments June 30, 2021 Average Purchase CUSIP Investme�# Issuer Balance Daba CAMP SYS12008 12p0$ CA ASSET MANAGEMENT PRdGRAM SuMotal and Ayeraga 48,820,179.99 CUSTODIAN PRQJEGT FUNDS fi736302460 59D GOLDMAN SACHS iREASURY FUND Su6total ar►d Arerage 0.00 LAI F SYS21003 21603 LOCAL AGENCY INVES7MENF FUN� Subtotal and Avarage 970,fi51.69 CIISTODIAN PROJECT FUNDS 6738302480-G 597 GOLDMAN SACHS GOVERNMENT 04101l2021 Subtotal and Average 4,938,986.96 Tokal and Average 59,068,190.34 Run �ete' p912112027 -10:44 Par Value 48,822,128.55 48,822,t28.55 0.00 0.00 970,651.69 970,651.fi8 4,938,988 96 4,938,988.96 54,731,769.20 Page 1 Stated Days to YTMIC 141atu IYlarket Value Book Value Rate Moody's ARaUCa! 365 pa� 48,822,928.55 48,822,728.55 0.050 1 0.050 48,822,128.55 48,$22,128.55 1 0.050 o.oa 0.00 970,651.69 870,651.69 4,938,988.98 4,938,988.96 54,731,7fi9.20 o.flo o.o�o naa � o.o,n O.OD 0 0.000 970,651.69 0.262 1 0.262 870,651.69 1 0.262 4,938.98$.98 0.030 A88 4,938,986.96 54,T31,769.20 1 0 030 1 O.D30 1 0.052 Portfalio HA AP PM {PRF_PM2j 7.3.11 Repp�t Yer 7.3.! 4 CUS1P tnvasdnern# Issuer CHECKING SYS25075 25015 HOUSINGAUTHCHECKING SY525p16 25016 HOUSIMG AUTH 7RUST Average Balance Total Cash and Investments 59 PALM DESERT HOUSING AUTHORiTY Porlfolio Management Portfolio Details - Cash June 30, 2021 Averaga Purchasa Bala�ae �afe Par Value Marlcet Value 2.937,247.7fl 2,937,247.70 07lfl112020 456940.50 456.94Q50 0.00 8,190.34 i8,925,957.4p 58,125,957.40 Page 2 Stated Days to YTMIC Book Value Rate Nloody'a MatlCal 365 2,937,247.70 1 0.000 45B,94p.5p 1 0.000 1 5$,125,957.40 1 0,052 u Portfolio HA R�n o�: o�z�no2� - io;aa AP PM {PRF PM2) 7.3.11 RDA SUCCESSQR AGENCY PortFolio Management Portfolio Sumrr�ary June 30, 2021 Investments RIVERSIDE COUNTY POOI CAMP LAIF TRUSTEE CASH BALANCES - MMA TRUSTEE CASH BALAMCES - GF Investrnerrts Cash PassbooklChecking (not included in yiefd plwlations) Total Cash and Investments Par Value 335.84 5,728,fl8 741.45 38,993,476.02 786,574.94 37,786,85B.31 1 906,5U2.25 39,fi93,356.56 Market Valus 335.$4 5,728.06 747.45 36,993,476.D2 786 574.94 37,T86,856.31 1,506,502.25 39,693,358.56 Book Value 335.84 5,728.06 741.45 36,993,478.62 786,574.94 37,786,856.31 1,908,502.25 39,693,358.58 °ti of POrtfoifo O.OD 0.02 O.QO 87.90 2.08 1 a0.00°k Days to MatlCall 1 1 1 1 1 1 Term t 1 1 1 1 1 YTM1C 365 Equiv. 0.288 0.050 0282 a.o�o 0.030 Q.010 7 1 O.Q00 1 1 0.07 p Total Eamings June 30 Mor�th Ending Fiscal Year Ta Date Fiscal Ysar Ending C�rrent Year 148.59 1,4i 3.47 1,413.47 Average Daily Balance 35,125,121.34 Effective Rate of Retum O.Ot96 This investment portfolio is in compliance w�th the provisions of Cal'ifomia Govemment Code Section 53601 and the City of Palm Desert in►restment policy. Pursuant to ABX126, the availability of cash to fund the Palrrt Desert RDA Successor Agency's debt ser�ice is dependent upon the County of Riverside a�d the State of Califomia. All balances are 6ank balances. The "% of Portfolio" calculation on the Portfolio Summary page omits demand deposits. Janet ore, Finance Officer Reporting period 06J0112021-0613012Q21 stun oa�e osn�rzoz� - ta:se ��a/�a-� Portfolio RDAS AP IE(PRF PMi)7311 Report Ver. 7.3.11 RDA SUCCESSOR AGENCY PortFolio Managemen# Portfolio Details - Investments June 30, 2021 Average Aurchasa CUSIP lnvestma�rt # Iss�er 8alanc8 Data RIVERSIDE COIJNTY POOL 052470 052470 POOIED INVESTMENT Fl1ND 07101I2Q20 Suhtofal and Average 335.76 CAMP SYS578 578 C.A.M.P. POOL (RDA S.A.) Subtotal and Average 5,T27.83 LAIF SYS604 604 L.A.I.F. (RDA S.A.) 07I0112020 Subtotal and Averoge 741.45 TRUSTEE CASN BALANCES - MMA 247394001-U 830 U.S. BANK MONEY MARKET ACCOUNT 07l01l2020 247394003-U 832 U.S. BANK MONEY MARKET ACCpUNT a7l09I2020 247384002-U 833 U.S. BANK MQNEY MARKET ACCOUNT 247394000.E1 834 U.S. BANK MONEY MARKETACCDUNT 236781002-U 837 U.S. BANK MONEY MARKET ACCOUNT 2387810D3-U 838 lI.S. 8ANK MONEY MARKET ACCOUNT U7101l2020 238781000-U 839 U.S. BANK MONEY MARKET ACGOUNT 253448003-U 842 U.S. BANK MONEY NUIRKET ACCOUNT 07101l2020 253446002-i1 843 U.S. BANK MpNEY MARKEF ACCOl1NT 253446000-U 844 U.S. BANK MONEY MARKET ACCOUNT 253446001-U 845 U�5 BANK MONEY MARKETACCOl1NT 07/01/2020 224324000-U 853 U.S. BANK MpNEY MARKETACCOUNi 22432400i-U 855 U.S. BANK MONEY MARKET ACCOUNi 07I0112020 224324UO2-U 856 U.S. BANK MONEY MARKET ACCOUNT 224324003-U E57 U.S. BANK MONEY MARKET ACCOUPlT 07I0112Q2U 236781001-U 887 U.S. BANK MONEY MARKET ACCOUNT 09I01I2020 Subtatal and Average 32,808,560.38 TRUSTEE CASH BALANCES - GF 2778610U0-G 811 GOEDMAN SACHS GOVERNMENT 277861001-G 812 GOLDMAN SACHS GOVERNMENT 277861002-G 873 GOIDMAk SACHS GOVERNMENT 07141/2020 277869003-G 814 GOLDMAN SACHS GOVERNMENT 07/01/2020 R�n o■u: osrz�noz� - �o:ss Par Vaiue 335 84 335.84 5.728.06 5,728.06 74i.45 741.4i 0.13 a.00 2U7,501.73 870,311.98 2,93Q,Q24.48 0.00 10,617,704.79 0.00 1.53U.U12.79 5,546,857.79 1.02 10,901,223.03 5,96 4.390,038.68 0.00 0.24 36,993,476.02 786,574.94 0,00 0.00 o.oa Page 1 Stated Days to YTMIC MadirHy Market Value Book Value Rate Moody'a MatlCal 365 pate 335.84 335.84 0.288 Aaa 1 0.268 315.84 335.84 i 0.268 5.72$.O6 S,T28.U6 741.45 74t.45 0.13 o.00 207,501.73 870,311.98 2,930,a24.48 o.oa 10.677.704.19 O.OD 1,530,012.79 5.546.657.79 1.02 70,901,223.03 1.96 4,390,036.68 D.00 0.24 36,993,47fi.02 786,574,94 0.00 O.OU o.oa 5,728.OS 0.050 i 0.050 5,728.06 1 0.050 741.45 0.262 7 0.262 741.�5 1 0.262 0.13 Q.a10 P-1 1 0.010 0.00 O.U10 P-1 1 0.070 207,501.73 0.010 P-7 1 0.010 870,311.98 0.010 P-7 1 O.aSO 2,930,024.48 0.010 P-1 1 0.040 0.00 tl.010 P-1 1 0.010 70,fi17,704.19 0.010 P-1 1 0.010 0.00 0.010 ?-1 1 0,010 9,530,012.79 0.010 P-1 1 0.010 5 546,657.79 0.010 P-1 1 0.010 1.02 0.010 P-1 ! p.p10 10,901,223.03 0.090 P-1 i 0.010 1.96 D.01 p P-1 1 0.010 4,390,03$.$8 0.010 P-1 1 0.010 0,00 0.01Q P-1 7 0.090 0.24 0.01fl P-1 1 0.01Q 36,993,476.02 1 0.014 786,574.94 O.D30 Aaa 0.00 0.�30 Aaa 0.00 0.030 Aaa 0.00 O.U30 Aaa 7 0,030 1 0.030 1 0.030 1 D.030 Portfolio RDAS AP PM (PRF_PM2} 7 3.11 Raport Ver. 7 3.11 CUS[P Inveslme�rt# Essuer Subtotal and Average Total and Avenge RDA SUCCESSOR AGENCY PortFolio Management PorEfolio Details - Investments June 30, 2021 Average Purchase Balance Date 658,407.23 35,125,127.34 Par Valua 786,574.94 37,766,856.31 Market Val�e 786,574.94 37,786,8i6.31 Book Value T86,574.94 37,78fi,856.31 Page 2 Stalsd Daya to YTMlC Rate Moody'a Mnt.IGal 3fi5 1 0.030 7 0.010 �oRfolio RDAS Ru, oa�e: osnirzaz� - sa:sa AP PM (PRF_PM2j 7.3.11 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Cash June 30, 202'I Average Aurehase CU51P lnvestment # Issuer Balance Date Par Value Market Value UNIpN BANK CHECKING ACCOUNTS SYS582 582 RDA SUCCESSOR AGENCY 1,906,502.25 1,806,502.25 Average Balaeca 0.00 Total Cash and Invesdnents 35,125,121.34 39,69�,358.56 39,693,358.56 Page 3 Statad Days to YTAAtC Baok Value Rate IlAoody's MatlCal 365 1,906,502.25 1 0 OpD � 38,683,358.56 1 0.010 � Partfoiio RDAS R�n �ste: osrzanoz� - � o:sa AP PM (PRF PMZj 7.3.11 zi-sep-zs 11:37 AM SymPro No. 7�� [n�estment EIP Loan * Footnotes EIP balance adjustments made on March 2 ancf September Z of each year. �ALM DESERT RDA SUCCESSOR AGENCY LONG-TERM LOANS RECEIVABLE lUNE 30, 2021 S Book Value �42,000.00 Maturity Date 09/42/29 Stated Ir�terest Rate 3.U0°o CITY OF PALM DESERT Portfolio Managemen# Portfolio Summary May 31, 2�21 Investments GAMP U.S. BANK / LAIF BOND PROCEEDS LAIF TRUSTEE CA&H 8AlANCES MEDIUM-7ERM NOTES CUSTO�IAN PROJECT FUNDS RNERSIDE COUNTY POOL Investments Cash Passbook/CRedci� (not inGuded in yie d calculations) Totaf Cash and InvestmeMs Par Value 6,781,333.1 Z 4,617,890.14 74,238,968.53 1,963,078.35 4Q,OOU,000.00 58,307,971.41 79,333,557.94 265,222,599.48 8,749,884.18 273,9T2,4B3.64 Market Value 6,781,833. i 1 4,617,690.14 74,23$,968.53 1,963,078.35 40,556,75�AQ 58,307,971.41 79,333,557.94 265,779,344.48 8,749,884.16 274,529,233.fi4 Book Varue 6,7$1,333.11 4,617,690.14 74,238,968.53 1,963,078.35 38.488,Q42A7 58,307,97i.41 79 333,557.94 265,Z10,641.55 8,749,884.16 273,964,525.7'1 N. of Portfofla 2.55 1.74 27.99 D.74 15.U8 29.99 ss s� 100.OD% Dsys to MatlCa�� 1 i 1 1 332 Z � 51 0 51 Term 1 1 1 1 83U 1 � 141 YrNuc 365 Equiv. 0.050 0.37 5 0.375 D.030 1.7fi3 0 030 o. zea 4.456 � o.oao 141 fl.456 Total Eamings May 31 Month Ending Fiscal Year To Date Currenk Year 84,801.41 1,280,899.32 Average Daily Balance 263,015,834.57 257,234,824.92 EfFective itate of Retum 0.38� 0.54% This investment poRfolio is in comptiance with the provisions of Cal'ifomia Govemment Code Sectian 53fi61 and the City of Palm Desert investment policy. Barring unforeseen evenis, it has sufficient cash to fi.�nd city expenditures far the next six months. Union Bank Custody 8ervices has p�ovided market value p�ices for all corgorate securities. All balances are bank balanoes. The "°k of P '" calculatio n th o o Summary page omits deman�epos' . Jar+et . oore, Director of Finanoe/ ' Treasurer �� / Reporting period Q510112Q21-05(3112fl21 Run DatB: 09Er2112021 - 1p.34 PorEfolio CITY AP IE {PRF_PM1 j 7.3.11 Report Ver 7 31 t CUSIP IavestmeM� Issuer CAMP CiTY OF PALM DESERT Portfo�io Management Portfolio Details - Investments May 31, 202't Avarege Purehase Balance �� Par Value Market VaEue SYS73 13 G.A.M.P. POOL (CIT'Y) SYS12444 72444 C.A.M.P. POOI {DESERT WILL4UVj Subtotal and Average 5,fi64,332.67 U.S. BANK 1 LAlF BOND PROCEEDS 252U26003 12-33-084 LOCAL AGENCY INVES7MENT FUND 5uhtotal and A�erage 4,617,690.14 LAIF 12p00 12o0p LOCAL AGENCY INVESTMENT FUND Subtbt8l aod Averaga 74,238,958.53 TRUSTEE CASH BALANCES 252026000fii 382 GOLDMAN SACHS GQVERNMENT 252�26001-G 383 GOLDMAN SACHS GOVERNMENT 252026002-G 384 GOLDMAN SACHS GOVERNMENT 252026003-G 385 GOLDMAN SACHS GOVERNMENT 252p26pp4-G 386 GQLQMWN SACHS C'iOVERNMENT 252026017-G 401 GdLDMAN SACHS GOVERNMENT 25202601B-G 402 GBLDMAN SACHS GOVERNMENT 280128D00.G 404 GOLDMAN SACNS GOVERNMENT 26at28001-G 405 GOLDkfAN SACHS GOVERNMENT 260128002-G 407 GOLDMAN SACHS GOVERNMENT 260128003-G 406 GOLDMAM SACHS GOVERNMENT 26Q128�04-G 409 GOLDMAN SACHS GOVERNMENT 260128U05-G 416 GOLDMAN SACHS GOVERNMENT 260928006-G 412 GOLDMAN SACHS GdVERNMENT 260728007-G 414 GOLDMAN SACHS GOVERNMENT ZB0128008-G 475 GOLDMAN SACHS GOVERNMENT 26012800&G 4'!6 GOLDMAtJ SACHS GOVERNMENT 26Q128010-G 417 GOLOMAN SACHS GOVERNiNENF 260128071-G 418 GOLDMAN SACHS GOVERNMENT 269470000-G 418 GOLDMAN SACHS GOVERNMEh(T 2814700�1-G d20 GOLDMAN SACHS GOVERNMENT 26147QQ02-G 421 GOLDMAN SACHS GOVERNIIAEN7 Run Oats: 09/21/2021 -10:34 07101l2020 o7ro�rxazo o�roi rzozo o�ro� rzoza 07101I202fl 077D7I202b 6,031,215.22 730,117.89 6,761,333.17 4,617,690.14 4,617,690.14 74,238,968.53 74,238,968.53 a.ao 2.79 0.74 O.i5 930.84 382.99 10.404.07 15.988.09 o.00 0.00 o.ao O.OD a.00 O.OD 0.00 o.00 0.51 0.30 160,885.91 5.66 4.37 'I ,774.511.96 6,031,275 22 736,177.88 6,761,333.11 4.817.640. 74 4,67T,690.14 74.238,988.53 74,238,968.53 a.aa 2.79 0.79 0.15 93Q.84 362.99 'E0,4D4.07 15,968.01 o.00 0.00 0.00 a.00 fl.fl4 0.00 0.00 a.oa 0.51 0.3U 160,885.99 5,66 4.37 1.774.5l1.96 Page 7 5ffitsd YTIYUG Days 6o Maturity Book Value Rate Moody's 3fi5 MatlCa[ Date 4 8,031,215.22 U.050 0.050 730,117.89 0,050 0.05U 6,761,333.11 0.050 4,617,680.14 0.315 6.315 4,617,690.14 4.315 74,238,968.53 D.375 0315 74,238,96$.i3 0.315 0.00 Q.630 2.79 0.030 0.79 tl.030 0.15 0.030 93Q.84 0.030 382,99 0.030 10,404.07 0.030 15,968,01 U.030 a.ao o.o3a 0.00 0.03D 0.00 D.030 0,00 0.030 o.00 o.aso 0.0a 6.030 O,DO 6.030 0.00 0.030 0.51 0 030 0.30 0.03D 160,885.97 0.03p 5.68 0.030 4.37 0.030 1,774,511.96 0.030 Aaa Q.030 Aaa 0.030 Aaa 0 030 Aaa 0.030 Aaa 0.030 Aaa 0.03U A8a 0.030 Aaa p.030 naa a.oao Aaa 0.430 Aaa 0.030 ilaa O.tl30 {1aa 0.03D A88 0.030 Aaa O.D90 Aaa 0.030 Aaa D.030 Aaa 0.030 Aaa 0.030 Aaa 0.030 Aaa 6.030 Aaa 0.030 7 1 1 7 1 � 1 9 � 1 1 1 7 1 i S 1 1 1 1 1 ! i 1 1 1 7 1 1 Portfolio CITY AP PM (PRF PN12) 7 311 Report Vx. 7 311 Average CUSIP InvestmeM# Issuer Balance Sudtotal and Average 1,963,473.24 MEDIUM-TE12M HOTES 037833DL1 694 APPLE, INC. 037833DL1 BiB APPLE, INC. 2548$7FJ0 625 WALT �ISNEY COMPANY 62685WBG5 615 AMERICAN HONDA FiNANCE 02685WDC2 617 AMERICAN HONbA FINANCE 02665WBF7 823 AMERICAN HONQA FINANCE 549418BP8 624 MICf205QFT CORPORATION Subtotal and Average 39,98fi,953.4b CUSTODIAN PROJECT Fi1NDS 6738302420-G 647 GOLDMAN SACHS GOVERNMENT 6738302436-G 648 GOLDMAN SACHS GQVERNMENT 6738302440-G 649 GOLDMAN SACMS GOV�RNMENT 8736302450-G 650 GOLDMAN SACHS GOVERNMENT 5ubtotal and Areroga 58,539,871.45 RIVERSIDE COUNTY POOL 052460 052480 POOLED INVESTMENT FUND Subtotaf and Average 70,365,767.16 CUS70DIAN PROJECT FUNDS 8736302420 498 GOLDMAN SACHS TREASURY FUND 6738302430 499 GOLD�AAN SACHS TREASURY FUND 6736302440 500 GBLDMAN S,0.CHS TREASURY �UNd 6736302450 501 GOIDMAN SACHS TREASURY FUIVD Subtotal and Average 0.00 Total and Average 251,015,834.57 CITY OF PALM DESERT Portfolio Management Portfolio Details - In�estments May 37, 2021 Purchase Date Par Value 1,963,078.35 Market Value 1,963,D78.35 49111I2619 09125l2fli9 91l20I2019 09l0912019 09/27/2019 1'1l1512018 71I20l2D'19 01101l2021 U1101l2p21 01l01I2U27 01/01/2021 S,OOO,OQO.UO 10,OOQ,Q00.00 5,000,000.06 5,000,000.00 5,0O�,Op0.00 5,D00,000.00 5,000,000.00 40,000.00O.DO 8,579,820.22 19,613,6A9.39 9,788,585.87 20,328.115.93 58,307,971.,7 79,333,557.94 79,333,557.94 0.00 0.00 a.oa O.QO 0.00 265,222,549.48 5,097,150.00 16,194,300.D0 5,U86,4D0.00 5,027 ,150.00 5,942,850.00 5,OD7,850.00 5,007,050.00 40,556,750.00 B,579,620.22 i 9,673,649.39 8,788,585.87 2{1,326,115.93 58,30T,971.41 79,333,557.94 79,333,557.94 o.oa 0.00 o.oa 0.00 O.OU 265,779,349.18 Page 2 Stated YTMlC �ays to Maturily 800k Value Rata Moody's 365 MatlCal D� 1,963,07$.35 0.030 1 4,999,378.15 9.7Q0 9.995,845.97 1.700 4,897,549.85 1.850 4,996,87fi.83 7.700 4,998,975.53 2.05D 4,998,076.30 1.650 4,999,539.24 1.550 39,4$8,042.07 Aa 1.710 4$7 09111I2622 Aa 1.735 487 U9111l2022 A 1.850 457 09101l2022 A 1.935 10a 09/09/2021 A 2.045 588 01/10/2023 11a 1.815 41 07/12/2024 Aaa 1.600 88 08/08/2021 1.783 332 8.579,820.22 0.034 79,613,649.39 0.030 9,788,585.87 0.030 20,326,115.83 0.030 58,307,97�.41 79,333,557.94 0.284 79,133,557.94 0.00 O.UtO 0.00 0.010 o.00 o.o�o 0.00 0.010 p.00 265,210,64t.55 11a8 0.03D 7 Aaa 0.030 7 Aaa o.030 7 Aaa 0.030 1 0.030 1 Aaa 0 284 1 0.284 1 Aaa 0.0�0 Aaa O,D10 Aaa o.o�o Aaa 0.010 a.aoo 0.456 7 7 � 1 0 51 Portfolio cITY Run oe+e: o�rz�izn2� - �o:sa AP PM (PRF PM2} 7 3.11 CITY OF PALM DESERT Portfolio Management Portfolio Details - Cash May 31, 2021 Average Purehasa CUSIP Inrastmer�tl� lasusr Balance Date Par Value Market Valus PEND�NG DEPOSIT WITM COUNTY POOL SY5651 651 CITY OF PALM pESERT MAIN 01l2912021 O.Oa 0 00 UNION BANK CHEGKING ACCOUNTS SYS13016 13016 CITY OF PALM DESERT MAIN SYS13013 13013 DESERT WILLOW GOLF COLIRSE SYSB02 802 PUBLIC SAFETY CHECKING SYS13020 i 302D RECREATIONAL FACILITIES CORP Average Balance 0.00 Yotal Cash and InreatmeMa 263,D15,834.57 4,979,236.42 4,979,236.42 07I0112020 2,250,563.47 2,250,503.41 Wl01l2020 714,077.83 714,077.B3 07lD1l2U20 806,p66.70 906,D68.70 273.972,483.fi4 274,529,233.fi4 Page 3 Stated YTMlC Days to Book Value Rata Moody'a 365 MatlCal 0.00 0.000 1 4,979,238.42 fl.D00 1 2,250,503.41 0 ODO 1 714,077. fi3 0 000 1 806,066.70 0.000 1 1 273,960,525.71 0.4i6 51 Portfolio cITY R�n oa�e� osr2+na¢� - �o:sa AP PM (PRF PN12J 7 3.11 � CITY OF PALM DESERT Activity Report Sorted By Issuer May 7, 2a21 - May 3'�, 2021 Par Value PercaM Beg]nning Currerrt Transactlon CUSIP InvestmaM# Issuer �Portfoqo Balance Rate �ate Issuer: APPLE, INC. MEDIUM-TERM NOTES 5ubtotal and Balance 15,000,000.00 Isauer Subtotaf 5.4759L 15,D00,000.00 Issuer: C.A.M.P. POOL (CITIf} CAMP SY573 13 C.A.M.P. POOL (C11Y} Subtotal and Balar+ce fi,230,988.87 lasuer Su6total 2.20795 8,230,988.87 fssuer: C.A.M.P. POOL (DESERT WILLOVII� CAMP SYS12444 i 2444 C.A.M P. ?OOL (DESERT WILLO1Nj Subtotal and Balance 730,084.47 Issuar 5u6total 0.286!� 7a0,084A7 Issuer: POOLED INVESTMENT FUND RNERSIDE CQUNTY POOL 052460 052460 POOLED INVESiMENT FUND Subtotal and Balance 88,533,259.83 13suer Subtptal 28.957% fi8,533,259.83 Issuer: WALT DISNEY GOMPANY MEDIUM TERM NOTES Subtotal and Bafance 5,000,000.40 Run Oste: 09121f2021 - 1 �:07 0.050 0 d50 n.zss _ Par Value Purchases or Redemptions or Deposits wthdravrais D.00 2,800,226.35 z,soo,zzs.ss 2,800,22b.35 33.42 33.42 33.42 10,800.29E.11 1 D,600,29$.11 10,800,298.14 0.00 3,OQO,OOD DO 3,000,000.00 3,000,000.00 0.00 0.00 a.ao 0.00 0.00 0.00 Ending Balance 'E5,000,000.00 ts,000,000.oa 6,OSt,215.22 6,QS1,215.22 T30,117.89 730,117.84 79,333,557.94 78,313,557.94 S,OOO,pDO.Op Portfolio CITY AP DA (PRF_�A) 7,3.11 RaporE Yer. 7 3.11 CITY OF PALM DESER� AGtivity Report May 1, 2021 - May 37, 2021 Par Value Perceirt 6egEnning CurreM Trsnsactian CU31P ImestmeM � lasuer � Porlfollo Balanee Rate Data Iss�er 5ubtotal 1.825°G S,OOO,OpD.00 Issuer: GOLDMAN SACHS GOVERNMENT FIiND T1tUSTEE CASH BALANCES 252026004G 388 GOLQMAN SACH5 GOVERNMEhT 252426017-G 401 GOLDMAN SACHS GOVERNMENT 25202609&G 402 GOLDMAN SACHS GOVERNMENT 26Q12800D-G 404 GOL�MAN SACHS GOVERHMENT 260128011-G 418 GOLDMAN SACHS GOVERNMENT 26147oD02-G 421 GOLDMAN SACHS GOVERNMENT Subtotal and Balance 1,963,023.Sfi CUSTODIAN PROJECT FUNDS B73fi302420-G 647 GOLDMAN SACHS GOVERNMENT 87383p243a-G 648 GOLI]MAN SACHS GOVERNMENT $736302440-G 649 GOLDMAN SACHS GOVERNMENT B73B302450-G 650 GOLDMAN SACHS GOVERNMENT Su6total and Balance 58,684,877.61 IssuerSubtotal 21.999'ti 60,647,901A7 Issuer: GOLDMAN SACHS TREASEIRY FUND CUSTODIAN PROJECT FUiJDS Subtotai and Balanea O.OD lasusr Suiftotal 0.000'G 0.00 Issuer: AMERICAN HONDA FINANCE MEDIIlM TERM NOTES Subtotnl and Balance 15,000,000.00 lssuer Subtotai 5.4T59L 15,000,000.00 Essuer: LOCAL AGENCY INVESTMEHT FIlHD U.S. BANK 1 LAIF BOND Pi20CEEDS 0.030 0.030 0.030 0.030 0.430 0.030 0.030 0.03Q 0.030 a.osn Pur+chases or Deposrts 0.00 O.D3 0.01 0.29 Q.44 4.47 49.25 54.49 242.84 563.81 271.BB 564 05 1,642.76 1,fi96.65 0.00 0.00 Par Value Redemptions or wthdrawals O.OD 0.00 0.00 0.00 0.00 D.00 0.00 O.Op 115,732.32 263,418.D4 0.00 0.00 378,548.36 378,548.36 Ending Balanee S,OOO,OOO.OD 1,963,478.35 S$,307,971.41 50,271,049.76 Page 2 0.00 0.00 O.OQ 15,OD0,000.00 0.00 15.QOO,OOD.00 Portfolio CITY AP Run �ate: 09T11l2p2t -11 �07 OA (PRF_DA) 7.3.11 Report Yer. 7 311 CITY OF PALM DESERT Activity Report May 1, 2021 - May 31, 2027 Par Value Percant Beginning Curr�nt Transaetion CUSIP InvestmaM# laauer ofPartfolio Bafance Rate Data Subtotal and 8alanee 4,617,fi90.14 LAIF Subtotal and Balance 74,238,968.53 IssuerSu6total 28.783% 78,856,658.67 Issuer: MICROSOFT CORPORATIQN MEDiUM-TERM NOTES Snbtotal and Balance 5,OD0,000.00 IssuarSubYotal 1.825;4 5,004,OOD.00 Issuer: CI'fY OF PALM DESERT MAIN PENDING DEP051T WITH COUNTY POOL Subtotal nnd 8alance p.p0 UNION BANK CHECKING ACCOUNTS SYS13096 13016 GITY OF PALM dESERT MAIN Subtotal and Balance 4,1 N,16�.37 lssuerSu6total 1.617% 4,111,184.37 lssuer: DESERT WfLLOW GOLF COURSE UNION BANK GHECKING ACCOUNTS 5Y513013 13073 DESERT WILLOW GOLF COURSE Subtotal and Balance 2,103,467.03 IasuerSubtotal 0.821!6 2,103,467.03 Issuer: PUBLIC SAFETY CHECKING UNION BANK CHECKING ACCOUNTS SYSBD2 602 PUBLIC SAFETY CHECKING SubtoffiI and Balance 378,475.03 tssuerSubtotal a.261X 379,475.03 Run Dele: 09121/2D21 -11:07 Purchases or Deposits 0.40 0.00 23,245,002.36 23,245,002.36 23,245,002.36 1,057,961.87 1,05T,961.87 1,057,961.87 334,B73.S3 354,673.53 334,673.53 Par Vaiue Redemptio�s or w,tnd�ais 0.00 Page 3 Ending Ba�ar,ee 4,617,590.14 74,238,868.53 78,856,658.67 5,000,000.00 O.Da 5,OD0,000.00 0.00 22,376,950.31 22,376,950.31 22,376,950.31 910,525.49 950,925.49 910,925.49 70.93 70.93 70.83 4,979,236.42 4,979,236.42 2,230,5p3.4� 2,250,503.t1 714,07T.63 714,077.63 POrtfOliO CI7Y AP DA (PRF_DA) 7.3.11 Report Ver. 7,3.11 Paroerrt CUSIP Irnesdnant# Issuer �Portfolio Issuer: RECREATIONAL FACILlTIES CORP UNION BANK CHECKING ACCOUNTS SYS13Q20 i3020 RECREATIONAL FACILITIES CORP CITY OF PALM �E5ERT Activity Report May 1, 2021 - May 31, 2Q21 Par Value Beglnning CurreM Transactioti Balance Rate Date Subtotal and Balanca 880,474.81 Issuer Subtotal 0.294i6 880,4T9.81 Tofal 9DO.00Oi6 2f2,473,499.55 Purchases or Deposits 263,369.94 263,369.84 263,369.94 38,SQ3,2fi2.23 Par. VAlue Redemptions or Wrthdrawals 337,783.05 337,783.05 137,783.05 27,004,276.1, Ending Balance 806,066.70 806,OBB.70 273,972,483.64 Page 4 Portfalio CITY AP Run �ate: 090212021 -11:07 DA (PRF_DA) 7.3.1 i Report Ver 7 3.11 u CITY OF PALM DESERT LONG-TERM LOAN5 RECEIVABLE MAY 31, 2021 21-Sep-21 11:35 AM SymPro No. I n�estme nt Book Value Maturity Date Stated Interest Rate i City Loan to RDA* 348 E[P Loan ** 594 Highlands Utility Undergrounding *** Assessment District 04-01 Deferred Loan $ 10,575,462.50 N/A $ 1,394,000.00 09/02/34 $ 14,977.73 09/02/36 0.32% �.ao� 5.35% Footnates * On May I7, 2019, the Californra State Department of Finance (DQFJ denied the 1986 City Loon in the principa! nmount of $6,000,000 as an enforceahle obligation of the Successor Agency of the Palm Desert Redevelopment Agency. Severa! attempts have been made to challenge thrs decision. The D�F, however, continues to maintain its position and its in�erpreiation of the dissoluiion law as it relates io rhe loans. ** �IP balance adjustments made on Marct� 2 and on September z of each ygar. **'� Highlands balance adjustments made on March 2 and orr Septernber 2 of each year. PALM DESERT HOUSING AUTHORITY PortFolio Management Port#olio Summary May 31, 202i InvestrneMS CAMP LAIF CUSFODIAN PROJECT FUNDS Investments Cash Pass600klChecking (not induded in yield calcufadons) Total Cash and Inrrastments Par Value 48,820,Z 12.80 970,651.69 4,938,879 53 54,729,644.02 4,370,927.68 59,10a,571.70 MaHcet Value 48,820,112.80 970,651.69 4 938,879.53 54,729,644.Q2 4,370,927.68 59,100,571.70 Book � of Days to Value PortfoNo M�� 48,82Q.11280 89.20 1 97p.651.89 1.77 1 4,938,879 53 8.02 7 54,729,644.02 100.00% 1 4.370, 927.68 59,900,577.7Q YTMlC Term 365 Equiv. 1 0.050 '1 0.375 1 O.U30 i o.Q53 1 1 0.000 1 1 0.053 Total Eamings May 31 Month Ending Fiscal YearTo Date Current Year 2_395.20 64,8$7.61 � Average Daily Balance 59,396,302.27 Effective Rate oi Retum fl.p$agf, This investment portfolio complies with the provisions of Califomia Govemmeni Cale Section 53601 and the City of Palm DeseR investment poficy. Barring unforeseen events, it has sufficient cash to fund Housin A ority operatio�r t�e next six months, AA balances �re� �an balances. The "0� oi Portfolio" calculation on #he Portfolio Summary page omits demand deposits_ q/ � �-/ Janet M_ M�recEor of inance/City Tre surer / Reporting period 0510112021-05131l20x1 Run oate: o9�z��zo2� - �D:as Portfolio HA AP IE{pRF PM1)7311 Report Ver. 7.3.71 PALM DESERT HOUSiNG AUTHORITY Portfolio Management Portfolio Details - In�estments May 31, 2021 Average Purchase CUSIP Investmer�tA� Issuer Balanea Date CAMP 5Y512008 t2p08 CAASSET MANAGEMENT PROGRAM Subtotal and Average 48,818,166.32 CUSTODIAN PROJECT FUNDS 67363D2460 590 GBLDMAN S,4CHS TREASURY FUND Subtotal and Average D.00 E.AIF SYS21 D03 21003 lOCAL AGENCY ENIIESTMENT FUND Subtotal and Average 970,651.69 CUSTODIAN PROJECT FUNDS 6736302460-G 597 GOIDMAN SACHS GQVERNMENT 07I0112021 SubtoffiI and Average 4,938,870.69 ToSal and Average i9,396,302.27 Run Date: D912il2021 -10:43 Par Va[ue 48,820,112.80 �s,s2a,�u.sa 0.00 0.00 870,651.89 970,651.69 4,93B,679.53 4,938,879.53 54,729,fi44.02 0.00 0.0�0 Aaa a.00 Statad �ays to YTMlC Maturity Market Value Book Value Rate Maody's MatlCal 365 p� 48,820,112.80 48,820,712.6p tl 050 1 0.050 48,820,'112.SD 48,82D,112.80 1 0.050 0.00 0.00 970,651.69 970,651.fi9 4,938,879 53 4,938,879.53 54,729,64A.02 97p,651.64 0.375 970,651.69 Page 1 1 0.010 0 0.000 1 0.375 1 0.315 4,938 879.53 0 030 Aaa 1 0.030 4,938,879.53 1 0.010 54,729,644.02 1 0.053 Portfolia HA AP PM �PRF_PMZj 7.3.11 Report Ver. 7.9.11 n CUSIP CHECKING SYS25D15 5YS25018 Inveafine� # Issuer 25015 HOUSING AUTN CHECKING PALM DESERT HOUSlNG AUTHORfTY Portfolio Management Portfolio Details - Cash May 31, 2021 Averaga Aurchase Balanca Data Par Value INarkei Valus 3,908,523.'i8 3,908523.18 25016 HOUSING AUTii TRUST 07l0112020 462,404.50 482,404.50 Avarage Balanee 0.00 Total Cash and lnvestmer�ts 59,388,302.27 59,100,571.70 59,100,571.70 Page 2 SSated Daya W YTMIC Book Value itate Moody'a MaUCaI 365 3,9U8,523.18 1 0.000 462,404.54 1 0.000 1 59,100,571.70 1 OA53 A POrRfolio HA R�� o�� osn�noz� - �a�� AP PM (PRF_PM2} 7.3 11 RDA SUCCESSOR AGENCY PortFolio Management PortFolio Summary May 3'I, 2021 InvestmeMs RIVERSIDE COUNTY POOL CAMP LAlF TRUSTEE CASH BALANCE5 - MMR 7RUSTEE CASH BALANCES - GF Investrnerts Cash PassbooklChecking (nat inGuded in yiefd cafculations) Total Cash and Invastments Par Value 335.63 5,727.82 741.45 24,438,625.38 402,062.90 24,847,493.18 7,642,550.2$ 26,490,D43.46 Markat Value 335.63 5,727.82 741.45 24,438,825.38 402,D62.90 24,847,493.18 1.842,550.2b 26,490,043.46 Book Value 335 63 5,727.82 741.45 24,438,625.38 4D2 062.90 24,64T,493.18 1, 642, 550.28 26,490,043.46 ;G of Portiolio 0.00 o.az O.flO 98 35 'i.62 100.Q0°k flays to MatlCall 1 � 7 1 7 1 %rm 1 � 7 1 1 1 1 1 1 1 YTIWC 365 EquW. 0.284 a.aso U.315 0.010 0.030 0.010 0.000 0.010 Total Eamings May 31 Month Ending Fiscal Year To Date Current Year 113. i 2 1,2gq.gg Average Daily Balance 26,504,p33.25 Effective Rate of Retum 0.01% ThEs investment portfolio is in compliance with the provisions of Califomia Govemment Code Section 53601 and the City of Palm Desert investment policy. Pursuant to ABX12fi, the availabilityr of cash to ftmd the Palm peseR RDA Successor Agency's debt service is dependent upon the County of Riverside and the State af CaliFomia. AIE balances are bank balances. The "0k af Portfolio" calcu�ation on the Portfo�io Summary page omits demand deposits. � �/a'//�/ Janet ldrhlfoore, Finance Qfficer / / ' Reporting period 0510112021-0513112024 Run Date� 0921I2D21 - 1+758 PoRfolio RDAS AP IE(PRF PM1)7311 Repori Ver 7.3.1 S Cl1SIA Investrner►t # Issuer RIVERSlDE COUNTY POOL d52470 U52470 POOlE��NVESTMENTFUND Subbotal and Average RDA SUCCESSOR AGENCY Portfoiio Management Portfolio Details - Investments May 31, 2021 Average Purchase 8alanee ��e par Valua Market Value 335.63 CAMP SYS578 57B C.A.M.P. POOL (RDA S.A.) 5u4total and Average 5,727.59 07109l2020 LAIF SY5604 6Q4 L.A.1_F. (R�A S.A.) 0710112�20 Su6total and Average 741-45 TRUSTEE CASF! BALANCES - MMA 247394041-U 830 U.S. BANK MONEY MARKET ACGOUN7 6710�12020 247394043-U 832 U.S. BANK MOidEY MARICET ACCOUNT Q7101I2020 247394002•U 833 U.S. BANK MQNEY MARKETACCOUNT 247394000-U 834 U S. BANK MONEY MARKET ACCOUNT 2367810D2-U 837 U.S. BANK MONEY MARKET ACCOUf4T 236787003-U 838 lI.S. SANK MONEY NWRKE7 ACCQUNT 07l0712020 23678100d-U 839 U.S. BANKMONEYMARKETACCOUNT 253446Q03-U 842 U.S. BANK MONEY MARKETACCOUNT 071U112024 253d46002-U 843 U� S� BANK MONEY MARKET ACCOUNT 2534qgpp0.{J 844 U.S. BANK MONEY MARKE'f ACGOUNT 253446001-U 845 U.S� BANK MONEY MARKET ACCOUMT 07101@026 224324000-U 853 U.S. BANK MONEY FAARKET ACCOUNT 2243240Ui-U 855 U-S. BANK MOACEY MAl2KETACCOUNT 071Di12020 224324042-U 858 U.S. BANK MONEI' MARiCET ACCQUNT 274324003-U 857 U.S. &4NK MONEY MARKET ACCOUNF 07107l2D20 236781001-l) 881 U.S. BAkK MONEY MARKET ACCOUNT 09107l2020 Subtotul and Average 24,435,198.62 TRUSTEE CASW BALANCES - GF 277861000-G 817 GOLDMAN SACHS GOVERNMENT 27786 9 001-G 812 G�LDMAN SACHS GdVERtJMENT 2TT881002-G 813 GOLDMAN SACHS GOVERNMENT 07l01I2020 277861003-G 814 GOLDMAN SACHS GOVERNMENT 07101l2020 Run pate: 09V2112021 10 58 335.&3 335.fi3 5,727.82 5,72T.82 741.45 T41_45 0.13 0.00 207,500.85 527,825.36 2,930,Q12.04 o.aa 7,435,128.87 0.00 1,530,006.29 2.95�,145.28 1.02 4.487,885.30 1.96 4,390,018.84 0.00 0,24 24,438�6x5.38 402,OB2.90 o.oa 0.00 o.oa 33$.83 335.53 5,727.82 5,72T.82 741.45 741.45 U.13 0.00 207,500.85 527,925.38 2.930.012.04 O.OD 7,435, i 28.87 O.DO 1.530,406.29 2,950,145.28 �.oz 4,487,885.30 1.96 4,390,018.04 Q.00 0.24 24,438,625.38 402,062.90 0.00 0.00 a.oa Paga 1 g� Daya to YTiYVC MaUurity Book Velue Rete 1NaqdY�s MatlCal 365 Datb 335.63 0.284 Aaa 1 0.284 335.63 1 Q-ZB� 5,727.82 0.050 5,727.82 1 0.050 1 O.Q50 741,45 0.315 741.45 0.73 4,410 0.00 O.U'EO 207,500.85 0,010 527,925.38 0.010 2.930,012.04 0.010 0.00 0.010 7,435,72d.67 0.010 0.00 0.010 1,530,ODB.29 O.DiO 2,95Q,145,2$ O.Q10 i.oz o.o�a 4,487,885.30 0.01U 1.9B O.p10 4,39�,Q18.04 O.Q10 0,00 U.U'EO 0.24 0.010 24,438,625.38 4p2,062.80 0.030 0.00 0.030 0.00 OA30 O.flO 4.030 1 Q.315 1 0.315 P-� � o.o�o P-1 t 0.010 P-7 1 a.010 P-7 1 O.U10 P-i 1 0.01 U P-1 1 0.010 P-1 1 0.01D P•1 1 4.010 P-1 9 0.01D P-1 1 �.�1Q p.1 1 0.090 P-9 7 0.010 P-1 1 O.Dta P.1 1 0.070 P-1 1 D.010 P-1 1 D.D10 � 1 0.410 qaa 1 0.030 Aaa 't 0.030 Aaa 1 0.030 Aaa 1 0.034 Potifplio RDAS AP PM {PRF_PM2) 7.3.11 Reporl Vx 7.3 9 i CUSfP Invesdner�t# Issuer Su4total and Average Total and Average Run Dete: 0912i12021 - 10:58 RDA SUCCESSOR AGENCY PortFolio Management Portfolio Details - Investments May 31, 2021 Avarage Purchase Balance Oate 402,062.18 26,504,033.25 Par Value 402,p62.9D 24,847,493.1 B Market Value 402,062.9Q 24,847,493.18 Book Value 402,Q62.80 24,847,493.58 Page 2 Stated Days to Y7MIC Rate Moody'g MatlCal 365 1 O.D30 1 0.010 PoRfolio RDAS AP PM (PRF PM2) 7.3.11 RDA SUCCESSOR AGENCY PortFolio Management Portfolio Details - Cash May 31, 2021 Average Purchase CUSIP (nvestmeM # taauer Balanes Date Par Value Market Value UNION BANK CHEGKING ACCOUNTS 5YS582 582 RDA SUCCES50R AGEkCY 1.842,550 28 7,642,550 28 Average Balance 0.00 Tota1 Cash and Invesdnents 26,504,033.25 26,490,043.46 26,490,043A8 Page 3 Stated Days to YTMlC Book Value Rate Moody's MatlCal 365 1,642,550.28 1 0 000 9 26,49D,D43.46 1 0.010 Portfolio RDAS Run Dale: 0912tl2p21 - 94:58 AP PM {PRF PM2) 7 311 , 21-Sep-21 11:42 AM SymPro No. ��$ �nvestment EIP Laan * Foatnotes EIP halance adjustments made on March 2 and September 2 of each year. PALM DESERT RDA SUCCESSOR AGENCY LONG-TERM LOANS REC�IVABLE MAY 31, 2021 $ Baok Value 542,000.00 Maturity Date 09/02/29 Stated Interest Rate 3 AORo CITY OF PALM DESERTGeneral Fund Financial Reportto \2021‐22 Annual Budget2021‐22 YTD Budget2021‐22 YTD Actual2021‐22 % to YTD BudgetPrior YTD ActualRevenuesSales Tax19,879,000 - - 0% - First payment not received until September of each year. Last September payment received was $1.391M Transient Occupancy Tax10,337,678 491,559 1,151,594 234% 404,867 ↑ Includes payments received through August 31, 2021 for July 2021.License, Permits, & Charges3,371,238 568,221 466,104 82% 523,321 ↓Lower reimbursements from government to date, BL (-$131,454 {65%}), Permits (+167,302 {77%}) from PYProperty Tax7,598,723 - - 0% - Receive in January and May of each Fiscal Year. Franchise Fees3,000,000 - - 0% - Receive various times during the year. Interest Income and Rent1634,000 39,517 21,178 54% 39,954 ↓Current average Yield is 0.58%; Prior YTD Yield was 1.80%State Subvention4,646,960 329 285 87% 319 ↓All Others3,106,005 430,346 966,636 225% 427,313 ↑ InterFund Transfers In2,932,500 - - 0% - Transfers are done various times during the year.TOTAL REVENUES55,506,104 1,529,972 2,605,797 170% 1,395,774 2021‐22 Annual Budget2021‐22 YTD Budget2021‐22 YTD Actual Encumb.2021‐22 % to YTD BudgetPrior YTD ActualExpendituresPolice Services20,000,359 77 3,240 15,144,723 4208% 75 ↑ Riv Co Sheriff first invoice is received in September each year.General Government + Contrib14,982,431 5,739,310 4,627,128 581,292 81% 5,286,568 ↓Includes payment of $2.674M to PERS for the City's annual required payment; prior year paid $3.46MPublic Works6,328,350 584,075 570,855 749,648 98% 601,228 ↓Parks4,590,125 134,562 138,172 1,542,093 103% 128,146 ↑ Landscape Contracts and Medians paymentsBuilding and Safety1,399,750 163,091 144,162 4,789 88% 171,044 ↓Community Development3,377,800 346,203 287,237 4,173 83% 310,373 ↓Economic Development3,715,295 295,296 297,765 544,041 101% 268,305 ↑ InterFund Transfers Out8,110,435 - - - 0% - TOTAL GEN FUND EXP62,504,545 7,262,614 6,068,559 18,570,759 84% 6,765,739 Total GF Exp and Encumb 24,639,318 Fire Protection Services17,499,500 17,985 48,071 6,453,541 267% 13,232 Variance result of timing difference of Fire Billing, from Riverside County Fire Department.Notes: See notes to Financial report for additional information.1. Interest earnings are allocated to all funds that have cash balance at year end.2. Sales Tax is paid in estimated monthly payments and adjusted for each quarter: 1st ‐Feb. ‐ May, 2nd ‐June ‐Aug, 3rd‐ Sept ‐Nov, 4th‐ Nov ‐ Feb. 3. TOT is received on monthly basis for example January collection is paid in February.4. Property Taxes are collected from property owners in December and April bi‐annually and paid to the City in January and June.5. Department of Motor Vehicle fees are paid twice a year by the State on February and June.6. Franchise Fees are paid through property tax collection from Burtec and are paid in April for Time Warner. Edison and Gas Co. 7. General Gov. includes: City Council, City Clerk, City Attorney, City Manager, Finance, Audit, Human Resources, Information Tech., Insurance8. Economic Development includes: Community Promotions, Market, Visitor Information, Economic Dev. 9. The Information (unaudited) derived from actual revenues and expenditures received by the City during the respective month‐to‐date reported and are accurate as of the date of the report. Changes to the revenue and expenditures could result from the fiscal year end audit, changes in estimates by payer agency's i.e. Ca. Dept. of Fee and Tax. Any changes will be reflected at next earliest reporting period.ExplanationExplanationAugust 31, 2021 (Year to date)(YTD Budget based on prior year percentage of actual to budget)NEW FORMAT CITY OF PALM DESERTGeneral Fund Financial Report ‐ Two Year Comparison for the two years ended 2021‐22 YTD Actual Prior YTD Actual Variance% Comparison of Prior Year Actual RevenuesSales Tax2- - - 0.00%First payment not received until September of each year. Last September payment received was $1.391M Transient Occupancy Tax1,151,594 404,867 746,727 284.44%↑ Includes payments received through August 31, 2021 for July 2021.License, Permits, & Charges466,104 523,321 (57,217) 89.07%↓Lower reimbursements from government to date, BL (-$131,454 {65%}), Permits (+167,302 {77%}) Property Tax- - - 0.00%Receive in January and May of each Fiscal Year. Franchise Fees- - - 0.00%Receive various times during the year. Interest Income and Rent121,178 39,954 (18,776) 53.01%↓Current average Yield is 0.58%; Prior YTD Yield was 1.80%State Subvention285 319 (34) 89.34%↓All Others966,636 427,313 539,323 226.21%↑ InterFund Transfers In- - - 0.00%Transfers are done various times during the year.TOTAL REVENUES2,605,797 1,395,774 1,210,024 186.69% 2021‐22 YTD Actual Prior YTD Actual Variance% Comparison of Prior Year Actual ExpendituresPolice Services3,240 75 3,165 4320.00%↑ Riv Co Sheriff first invoice is received in September each year.General Government + Contrib4,627,128 5,286,568 (659,440) 87.53%↓Includes payment of $2.674M to PERS for the City's annual required payment; prior year paid $3.46MPublic Works570,855 601,228 (30,373) 94.95%↓Parks138,172 128,146 10,026 107.82%↑ Landscape Contracts and Medians paymentsBuilding and Safety144,162 171,044 (26,882) 84.28%↓Community Development287,237 310,373 (23,136) 92.55%↓Economic Development297,765 268,305 29,460 110.98%↑ InterFund Transfers Out- - - 0.00%TOTAL GEN FUND EXP6,068,559 6,765,739 (697,180) 89.70% Fire Protection Services48,071 13,232 34,839 363.29%Variance result of timing difference of Fire Billing, from Riverside County Fire Department. August 31, 2021, and August 31, 2020 ExplanationExplanationActual to Actual ‐ 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000Sales Tax Transient Occupancy Tax License, Permits, & Charges Property Tax Franchise Fees Interest Income and Rent State Subvention All Others InterFund Transfers InFy 2021‐22FY 2020‐21 2-YEAR COMPARISON CITY OF PALM DESERTGeneral Fund Financial ReportTO17% of the year complete2021‐22 Annual Budget2021‐22 YTD Budget2021‐22 YTD Actual2021‐22 % to YTD BudgetPrior YTD ActualRevenuesSales Tax 19,879,000 3,313,167 - 0% - First payment not received until September of each year. Last September payment received was $1.391M Transient Occupancy Tax 10,337,678 1,722,946 1,151,594 67% 404,867 ↑ Includes payments received through August 31, 2021 for July 2021.License, Permits, & Charges 3,371,238 561,873 466,104 83% 523,321 ↓Lower reimbursements from government to date, BL (-$131,454 {65%}), Permits (+167,302 {77%}) from PYProperty Tax 7,598,723 1,266,454 - 0% - Receive in January and May of each Fiscal Year. Franchise Fees 3,000,000 500,000 - 0% - Receive various times during the year. Interest Income and Rent1634,000 105,667 21,178 20% 39,954 ↓Current average Yield is 0.58%; Prior YTD Yield was 1.80%State Subvention 4,646,960 774,493 285 0% 319 ↓All Others 3,106,005 517,668 966,636 187% 427,313 ↑ InterFund Transfers In 2,932,500 488,750 - 0% - Transfers are done various times during the year.TOTAL REVENUES 55,506,104 9,251,018 2,605,797 28% 1,395,774 2021‐22 Annual Budget2021‐22 YTD Budget2021‐22 YTD Actual Encumb.2021‐22 % to YTD BudgetPrior YTD ActualExpendituresPolice Services 20,000,359 3,333,393 3,240 15,144,723 0% 75 ↑ Riv Co Sheriff first invoice is received in September each year.General Government + Contrib14,982,431 2,497,072 4,627,128 581,292 185% 5,286,568 ↓Includes payment of $2.674M to PERS for the City's annual required payment; prior year paid $3.46MPublic Works 6,328,350 1,054,725 570,855 749,648 54% 601,228 ↓Parks 4,590,125 765,021 138,172 1,542,093 18% 128,146 ↑ Landscape Contracts and Medians paymentsBuilding and Safety 1,399,750 233,292 144,162 4,789 62% 171,044 ↓Community Development 3,377,800 562,967 287,237 4,173 51% 310,373 ↓Economic Development 3,715,295 619,216 297,765 544,041 48% 268,305 ↑ InterFund Transfers Out 8,110,435 1,351,739 - 0% - TOTAL GEN FUND EXP 62,504,545 10,417,425 6,068,559 18,570,759 58% 6,765,739 Total GF Exp and Encumb 24,639,318 Fire Protection Services 17,499,500 2,916,583 48,071 6,453,541 2% 13,232 Variance result of timing difference of Fire Billing, from Riverside County Fire Department.Notes:- 1. Interest earnings are allocated to all funds that have cash balance at year end.2. Sales Tax is paid in estimated monthly payments and adjusted for each quarter: 1st ‐Feb. ‐ May, 2nd ‐June ‐Aug, 3rd‐ Sept ‐Nov, 4th‐ Nov ‐ Feb. 3. TOT is received on monthly basis for example January collection is paid in February.4. Property Taxes are collected from property owners in December and April bi annually and paid to the City in January and June.5. Department of Motor Vehicle fees are paid twice a year by the State on February and June.6. Franchise Fees are paid through property tax collection from Burtec and are paid in April for Time Warner. Edison and Gas Co. 7. General Gov. includes: City Council, City Clerk, City Attorney, City Manager, Finance, Audit, Human Resources, Information Tech., Insurance8. Economic Development includes: Community Promotions, Market, Visitor Information, Economic Dev. 9. The Information (unaudited) derived from actual revenues and expenditures received by the City during the respective month‐to‐date reported and are accurate as of the date of the report. Changes to the revenue and expenditures could result from the fiscal year end audit, changes in estimates by payer agency's i.e. Ca. Dept. of Fee and Tax. Any changes will be reflected at next earliest reporting period.August 31, 2021 (year to date) ExplanationYTD Budget based on ORIGINAL FORMAT