The URL can be used to link to this page

Home My WebLink About02B Invstmnt Rprt Nov2020CITY COUNCIL ACTION APPROVED DENIED RECEIVED OTHER CITY OF PALM DESERT Portfolio Management MEETING DATE 2- Portfolio Summary AYESA42Wq NQSt� d Intah 11 November 30, 2020 NOES: Uo n - ABSENT: No ne ABSTAIN: VERIFIED BV! b GK TIEs (rlVeitlllefHB Par Market Book OrioTlal o t�vith City Clerk's Offte Vapor Vahw Vak a Port lio at. al erm 365 Equiv. CAMP 9,857,752.03 9,857,752.03 9,857,752.03 4.16 1 1 0.140 U.S. BANK / LAIF BOND PROCEEDS 4,605,369.20 4,605,369.20 4,605,369.20 1.94 1 1 0,576 LAW 74,040,575.23 74,040,575.23 74,040,575,23 31.26 1 1 0.576 GOLDMAN SACHS GOUT FUND 2,259,041.03 2,259,041.03 2,250,041.03 0.95 1 1 0.020 MEDIUM -TERM NOTES 40,000,000.00 40,809,250.00 39,974,077.95 16.88 514 930 1.783 RIVERSIDE COUNTY POOL 44,862,459.37 44,862,459.37 44,862,459.37 18.94 1 1 0.479 GOLDMAN SACHS TREASURY FUND 61,257,466.99 61,257,466.99 61,257,466.99 25,86 1 1 0.010 Investments Cash Passbook/Checking (not included in yield calculations) Total Cash and Investments 236,882,663.85 14,439,541.81 237,691,913.85 236,856,741.80 100.00% 88 14,439,541.81 14,439,541.81 251,322,205.66 252,131,455.66 251,296,283.61 88 158 0.592 1 0.000 158 0.592 ToW Ea s Noverrit!W 30 Moen Current Year 119,511,14 Average Daily Balance 253,104,149.05 Effective Rate of Return 0.57% This investment portfolio is in compliance with the provisions of California Government Code Section 53601 and the City of Palm Desert investment policy. Barring unforeseen events, it has sufficient cash to fund city expenditures for the next six months. Union Bank Custody Services has provided market value prices for all corporate securities. All balances are bank balances. The "% of Portfolio' calculation on the Portfolio Summary page omits demand deposits. W -X P~ 1-20-2021 Janet M. Mdlrre, Director of Finance/City Treasurer kmved ck C-1led BY SA -RDA ON 2-1t-2021 Reporting period 11/0112020.11130/2020 Run Date: 0111%=1 -11:30 No fiscal year history available 'ERIFIED BY: l7� / SrS 'riginal on file with City Clerk's Office Portfolio CITY AP IE (PRF PM1) 7.3.11 Report Ver. 7.3.11 CITY OF PALM DESERT Portfolio Management Portfolio Details - Investments November 30, 2020 Page 1 Average Purchase Stated YTM/C Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate Mootly's 365 Mal./Call Date CAMP SYS13 13 C.A.M.P. POOL (CITY) 9,127,954.95 9,127,954.95 9,127,954.95 0.140 0.140 1 SYS12444 12444 C.A.M.P. POOL (DESERT WILLOW) 729,797.08 729,797.08 729,797.08 0.140 0.140 1 Subtotal and Average 9,856,691.52 9,857,752.03 9,867,752.03 9,857,752.03 0.140 1 U.S. BANK / LAIF BOND PROCEEDS 252026003 1233084 LOCAL AGENCY INVESTMENT FUND Subtotal and Average 4,605,369.20 4,605,369.20 4,605,369.20 4,605,369.20 0.576 0.576 1 4,605,369.20 4,605,369.20 4,605,369.20 0.576 1 LAIF 12000 12000 LOCAL AGENCY INVESTMENT FUND 74,040,575.23 74,040,575.23 74,040,575.23 0.576 0.576 1 Subtotal and Average 74,040,575.23 74,040,575.23 74,040,575.23 74,040,575.23 0.576 1 GOLDMAN SACHS GOVT FUND 252026000-G 382 GOLDMAN SACHS 0.00 0.00 0.00 0.020 Aaa 0,020 1 252026001-G 383 GOLDMAN SACHS 0.56 0.56 0.56 0.020 Aaa 0.020 1 252026002-G 384 GOLDMAN SACHS 0.79 0.79 0.79 0.020 Aaa 0.020 1 252026003-G 385 GOLDMAN SACHS 0.15 0.15 0.15 0.020 Aaa 0.020 1 252026004-G 386 GOLDMAN SACHS 930.70 930.70 930.70 0.020 Aaa 0.020 1 252026017-G 401 GOLDMAN SACHS 362.93 362.93 362.93 0.020 Aaa 0.020 1 252026018-G 402 GOLDMAN SACHS 10,402.62 10,402.62 10,402.62 0.020 Aaa 0.020 1 260128000-G 404 GOLDMAN SACHS 15,965.79 15,965.79 15,965.79 0.020 Aaa 0.020 1 260128001-G 405 GOLDMAN SACHS 07/01/2019 0.00 0.00 0.00 0.020 Aaa 0.020 1 260128002-G 407 GOLDMAN SACHS 07/01/2019 0.00 0.00 0.00 0.020 Aaa 0.020 1 260128003-G 408 GOLDMAN SACHS 07/01/2019 0.00 0.00 0.00 0.020 Aaa 0.020 1 260128004-G 409 GOLDMAN SACHS 07/01/2019 0.00 0.00 0.00 0.020 Aaa 0.020 1 260128005-G 410 GOLDMAN SACHS 5.40 5.40 5.40 0.020 Aaa 0.020 1 260128006-G 412 GOLDMAN SACHS 0.00 0.00 0.00 0.020 Aaa 0.020 1 260128007-G 414 GOLDMAN SACHS 0.00 0.00 0.00 0.020 Aaa 0.020 1 260128008-G 415 GOLDMAN SACHS 188,790.08 188,790.08 188,790.08 0.020 Aaa 0.020 1 260128009-G 416 GOLDMAN SACHS 07/01/2019 1.20 1.20 1.20 0.020 Aaa 0.020 1 260128010-G 417 GOLDMAN SACHS 8,830.11 8,83ml 8,830.11 0.020 Aaa 0.020 1 260128011-G 418 GOLDMAN SACHS 160,863.57 160,863.57 160,863.57 0.020 Aaa 0.020 1 261470000-G 419 GOLDMAN SACHS 12.83 12.83 12.83 0.020 Aaa 0.020 1 261470001-G 420 GOLDMAN SACHS 98,608.65 98,608.65 98,608.65 0.020 Aaa 0.020 1 Run Date: 0111512021 - 11:30 Portfolio CITY AP PM (PRF_PM2) 7.3.11 Report Ver. 7.3.11 CITY OF PALM DESERT Portfolio Management Portfolio Details - Investments November 30, 2020 Page 2 Average Purchase Stated YTM/C Days to Maturity CUSIP Investment # Issuer Balance Date Par Value Markel Value Book Value Rate Mootly's 365 Mal./Call Date GOLDMAN SACHS GOVT FUND 261470002-G 421 GOLDMAN SACHS 1,774,265.65 1,774,265.65 1,774,265.65 0.020 Aaa 0.020 1 Subtotal and Average 2,259,039.33 2,259,041.03 2,259,041.03 2,259,041.03 0.020 1 MEDIUM -TERM NOTES 037833DL1 614 APPLE, INC. 09/11/2019 5,000,000.00 5,130,300.00 4,999,134.81 1.700 As 1.710 649 09/11/2022 0378331311 616 APPLE, INC. 09/25/2019 10,000,000.00 10,260,600.00 9,993,942.21 1.700 As 1.735 649 09/11/2022 254687FJO 625 WALT DISNEY COMPANY 11/20/2019 5,000,000.00 5,111,700.00 4,996,569.93 1.650 A 1.690 639 09/01/2022 02665WBG5 615 AMERICAN HONDA FINANCE 09/09/2019 5,000,000.00 5,053,400.00 4,991,140.68 1.700 A 1.935 282 09/09/2021 02666WDC2 617 AMERICAN HONDA FINANCE 09/27/2019 5,000,000.00 5,171,150.00 4,999,967.92 2.050 A 2.045 770 01/10/2023 02665WBF7 623 AMERICAN HONDA FINANCE 11/15/2019 5,000,000.00 5,042,150.00 4,995,021.02 1.650 As 1.815 223 07/12/2021 549418BP8 624 MICROSOFT CORPORATION 11/20/2019 5,000,000.00 5,039,950.00 4,998,301.38 1.550 Aaa 1.600 250 08/08/2021 Subtotal and Average 39,972,953.07 40,000,000.00 40,809,250.00 39,974,077.95 1.783 514 COMMERCIAL PAPER Subtotal and Average 4,805,524.21 RIVERSIDE COUNTY POOL 052460 052460 POOLED INVESTMENT FUND 44,862,459.37 44,862,459.37 44,862,459.37 0.479 Aaa 0.479 1 Subtotal and Average 44,862,459.37 44,862,459.37 44,862,459.37 44,862,459.37 0.479 1 GOLDMAN SACHS TREASURY FUND 6736302420 498 GOLDMAN SACHS 9,513,465.48 9,513,465.48 9,513,465.48 0.010 Aaa 0.010 1 6736302430 499 GOLDMAN SACHS 21,632,979.70 21,632,979.70 21,632,979.70 0.010 Aaa 0.010 1 6736302440 500 GOLDMAN SACHS 9,787,476.95 9,787,476.95 9,787,476.95 0.010 Aaa 0.010 1 6736302450 501 GOLDMAN SACHS 20,323,544.86 20,323,544.86 20,323,544.86 0.010 Aaa 0.010 1 Subtotal and Average 61,278,903.02 61,257,466.99 61,257,466.99 61,257,466.99 0.010 1 Total and Average 253,104,149.05 236,882,663.85 237,691,913.85 236,856,741.80 0.592 88 Run Date: 01/15/2021 - 11:30 Portfolio CITY AP PM (PRF_PM2) 7.3.11 CITY OF PALM DESERT Portfolio Management Portfolio Details - Cash November 30, 2020 Page 3 Average Purchase Stated YTM/C Days to CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Mootly's 365 Mal./Call UNION BANK CHECKING ACCOUNTS SYS13016 13016 CITY OF PALM DESERT MAIN 12,776,265.63 12,776,265.63 12,776,265.63 0.000 1 SYS13013 13013 DESERT WILLOW GOLF COURSE 07/01/2019 1,005,920.97 1,005,920.97 1,005,920.97 0.000 1 SYS602 602 PUBLIC SAFETY CHECKING 07/01/2019 155,382.56 155,382.56 155,382.56 0.000 1 SYS13020 13020 RECREATIONAL FACILITIES CORP 07/01/2019 501,972.65 501,972.65 501,972.65 0.000 1 Average Balance 0.00 1 Total Cash and Investments 253,104,149.05 Run Date: 0111512021 - 11:30 251,322,205.66 252,131,455.66 251,296,283.61 0.592 88 Portfolio CITY AP PM (PRF_PM2) 7.3.11 PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Summary November 30, 2020 Par Market Book %of Days to YTM/C Investments Value Value Value Portfolio Mat./Call Term 365 Equiv. GOLDMAN SACHS TREASURY FUND 4,938,194.34 4,938,194,34 4,938,194.34 9.55 1 1 0.010 CAMP 45,799,302.67 45,799,302.67 45,799,302.67 88.58 1 1 0.140 LAIF 968,061.79 968,061.79 968,061.79 1.87 1 1 0.576 51,705,558.80 51,705,558.80 51,705,558.80 100.00% 1 1 0.136 Investments Cash Passbook/Checking 4,355,203.37 4,355,203.37 4,355,203.37 1 1 0.000 (not included in yield calculations) Total Cash and Investments 56,060,762.17 56,060,762.17 56,060,762.17 1 1 0.136 Total Earnings November 30 Month Ending Current Year 5,249.98 Average Daily Balance 56,067,504.24 Effective Rate of Return 0.11% This investment portfolio complies with the provisions of California Government Code Section 53601 and the City of Palm Desert investment policy. Barring unforeseen events, it has sufficient cash to fund Housing Authority operations for the next six months. All balances are bank balances. The "% of Portfolio" calculation on the Portfolio Summary page omits demand deposits. 1-20-2021 Janet W Moore, Director of Finance/City Treasurer Reporting period 11/01/2020-11/3012020 Run Date: 01/1512021 -11:36 No fiscal year history available Portfolio HA AP IE(PRF_Phd) 7.3.11 Report Ver. 7.3.11 PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Details - Investments November 30, 2020 Page 1 Average Purchase Stated Days to YTM/C Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate Moody's Mat./Call 365 Date GOLDMAN SACHS TREASURY FUND 6736302460 590 GOLDMAN SACHS 4,938,194.34 4,938,194,34 4,938,194.34 0,010 Aaa 1 0.010 Subtotal and Average 4,938,190.61 4,938,194.34 4,938,194.34 4,938,194.34 1 0.010 CAMP SYS12008 12008 CA ASSET MANAGEMENT PROGRAM 45,799,302.67 45,799,302.67 45,799,302.67 0.140 1 0.140 Subtotal and Average 45,794,375.52 45,799,302.67 45,799,302.67 45,799,302.67 1 0.140 LAW SYS21003 21003 LOCAL AGENCY INVESTMENT FUND 968,061.79 968,061.79 968,061.79 0.576 1 0.576 Subtotal and Average 968,061.79 968,061.79 968,061.79 968,061.79 1 0.576 Total and Average 56,067,504.24 Ron Date: 01116/2021 - 11:36 51,705,558al) 51,705,558.80 51,705,558.80 1 0.136 Portfolio HA AP PM (PRF_PM2) 7.3.11 Report Ver. 7.3.11 PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Details - Cash November 30, 2020 Page 2 Average Purchase Stated Days to YTM/C CUSP Investment# Issuer Balance Date Par Value Market Value Book Value Rate Moody's Mat./Call 365 CHECKING SYS25015 25015 HOUSING AUTH CHECKING SYS25016 25016 HOUSING AUTH TRUST Average Balance 0.00 Total Cash and Investments 56,067,504.24 Ron Date: 01116/2021 - 11:36 3,892,925.87 3,892,925,87 3,892,925.87 07/01/2019 462,277.50 462,277.50 462,27T50 56,060,762.17 56,060,762.17 56,060,762.17 1 0.000 1 0.000 1 0.136 Portfolio HA AP PM (PRF_PM2) 7.3.11 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Summary November 30, 2020 Par Market Book % of Daysto YTM/C Investments Value Value Value Portfolio Mat./Call Term 365 Equiv. RIVERSIDE COUNTY POOL 334.80 334.80 334,80 0,00 1 1 0.479 CAMP 5,725.30 5,725.30 5,725.30 0,04 1 1 0.140 LAIF 739.47 739.47 739.47 0,00 1 1 0.576 US BANK MONEY MARKET ACCT 15,376,158.60 15,376,158.60 15,376,158.60 97.41 1 1 0.010 GOLDMAN SACHS GOVT FUND 402,002.42 402,002.42 402,002.42 2,55 1 1 0.020 15,784,960.59 15,784,960.59 15,784,960.59 100.00% 1 1 0.010 Investments Cash Passbook/Checking (not included in yield calculations) Total Cash and Investments 1,229,956 48 1,229,956.48 1,229,956.48 1 1 0.000 17,014,917.07 17,014,917.07 17,014,917.07 1 1 0.010 Total Earnings November 30 Month Ending Current Year 70.86 Average Daily Balance 17,004,691.08 Effective Rate of Return 0.01% This investment portfolio is in compliance with the provisions of California Government Code Section 53601 and the City of Palm Desert investment policy. Pursuant to ABX126, the availability of cash to fund the Palm Desert RDA Successor Agency's debt service is dependent upon the County of Riverside and the State of California. All balances are bank balances. The "% of Portfolio" calculation on the Portfolio Summary page omits demand deposits. 9alf N 7e&&4.- Janet M. Moore, Finance Officer Reporting period 11/01/2020-11/3012020 1-20-2021 Run Date: 01/1512021 -11:43 No fiscal year history available Portfolio RDAS AP IE (PRF_PMi) 7.3.11 Report Ver. 7.3.11 RDA SUCCESSOR AGENCY Portfolio Management Page 1 Portfolio Details - Investments November 30, 2020 Average Purchase Stated Days to YTM/C Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate Mootly's Mat./Call 365 Date RIVERSIDE COUNTY POOL SYS052470 052470 POOLED INVESTMENT FUND 334.80 334.80 334.80 0.479 Aaa 1 0.479 Subtotal and Average 334.80 334.80 334.80 334.80 1 0.479 CAMP SYS578 578 C.A.M.P. POOL (RDA S.A.) 5,725.30 5,725.30 5,725.30 0.140 1 0.140 Subtotal and Average 5,724.68 5,725.30 5,725.30 5,725.30 1 0.140 LAW SYS604 604 L.A.I.F.(RDA S.A.) 739.47 739.47 739.47 0.576 1 0.576 Subtotal and Average 739.47 739.47 739.47 739.47 1 0.576 US BANK MONEY MARKET ACCT 247394001-U 830 USBANK 07/01/2019 0.00 0.00 0.00 0.010 P-1 1 0.010 247394003-U 832 US BANK 07/01/2019 0.00 0.00 0.00 0.010 P-1 1 0.010 247394002-U 833 US BANK 0.81 0.81 0.81 0.010 P-1 1 0.010 247394000-U 834 US BANK 527,908.03 527,908.03 527,908.03 0.010 P-1 1 0.010 236781002-U 837 US BANK 11.75 11.75 11.75 0.010 P-1 1 0.010 236781003-U 838 US BANK 07/01/2019 0.00 0.00 0.00 0.010 P-1 1 0.010 236781000-U 839 US BANK 7,434,900.05 7,434,900.05 7,434,900.05 0.010 P-1 1 0.010 253446003-U 842 US BANK 07/01/2019 0.00 0.00 0.00 0.010 P-1 1 0.010 253446002-U 843 US BANK 5.89 5.89 5.89 0.010 P-1 1 0.010 253446000-U B44 US BANK 2,945,622.47 2,945,622.47 2,945,622.47 0.010 P-1 1 0.010 253446001-U 845 US BANK 07/01/2019 0.00 0.00 0.00 0.010 P-1 1 0.010 224324000-U 853 US BANK 4,467,692.54 4,467,692.54 4,467,692.54 0.010 P-1 1 0.010 224324001-U 855 US BANK 07/01/2019 0.00 0.00 0.00 0.010 P-1 1 0.010 224324002-U 856 US BANK 17.06 17.06 17.06 0.010 P-1 1 0.010 224324003-U 857 US BANK 07/01/2019 0.00 0.00 0.00 0.010 P-1 1 0.010 236781001-U 881 US BANK 09/01/2020 0.00 0.00 0.00 0.010 P-1 1 0.010 Subtotal and Average 15,376,156.43 15,376,158.60 15,376,158.60 15,376,158.60 1 0.010 GOLDMAN SACHS GOVT FUND 277861000-G 811 GOLDMAN SACHS 402,002.42 402,002.42 402,002.42 0.020 Aaa 1 0.020 277861001-G 812 GOLDMAN SACHS 0.00 0.00 0.00 0.020 Aaa 1 0.020 277861002-G 813 GOLDMAN SACHS 07/01/2019 0.00 0.00 0.00 0.020 Aaa 1 0.020 Portfolio RDAS AP Run Date: 01/15/2021 - 11:43 PM (PRF_PM2) 7.3.11 Report Ver. 7.3.11 RDA SUCCESSOR AGENCY Portfolio Management Page Portfolio Details - Investments November 30, 2020 Average Purchase Stated Days to YTM/C Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate Moody's Mat./Call 365 Date GOLDMAN SACHS GOVT FUND 277861003-G 814 GOLDMAN SACHS 07/01/2019 0.00 0.00 0.00 0,020 Aaa 1 0.020 Subtotal and Average 402,002.12 402,002.42 402,002.42 402,002.42 1 0.020 Total and Average 17,004,691.08 Ron Date: 01116/2021 - 11:43 15,784,960.59 15,784,960.59 15,784,960.59 1 0.010 Portfolio RDAS AP PM (PRF_PM2) 7.3.11 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Cash November 30, 2020 Page 3 Average Purchase Stated Days to YTM/C CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate Moody's Mat./Call 365 UNION BANK CHECKING ACCOUNTS SYS582 Ron Date: 01116/2021 - 11:43 582 RDA SUCCESSOR AGENCY Average Balance 0.00 Total Cash and Investments 17,004,691.0; 1,229,956.48 17,014,917.07 1,229,956.48 17,014,917.07 1,229,956.48 17,014,917.07 1 0.000 1 0.010 Portfolio RDAS AP PM (PRF_PM2) 1.3.11