The URL can be used to link to this page

Home My WebLink About02C Invstmnt Rprt Dec2020CITY COUNCIL ACTION APPROVED DENTED CITY OF PALM DESERT RECEIVED 41P OTHER Portfolio Management MEETING DATE, I 2 Portfolio Summary AYES: C D(fAIA December 31, 2020 NOES:- N10re ABSENT: ND he ABSTAIN: - No ne VERIFIED V &LR srs IR111r investments Par yakea Market Book yo of uays vat" Woe Oqp61tg1 on ki"ith City>Glerk'sel 0"We CAMP 9,858,765.46 9,858,765.46 9,858,765.46 4.03 1 1 0.120 U.S. BANK / LAW BOND PROCEEDS 4,605,369.20 4,605,369.20 4,805,369.20 1.88 1 1 0,540 LAW 74,040,575.23 74,040,57523 74,040,57523 30.27 1 1 0,540 GOLDMAN SACHS GOVT FUND 2,070,280.49 2,070,280.49 2,070,280.49 0.85 1 1 0,030 MEDIUM -TERM NOTES 40,000,000.00 40,782,050.00 39,976,405.31 16.34 483 930 1.783 RIVERSIDE COUNTY POOL 52,880,066.71 52,880,066.71 52,880,066.71 21.62 1 1 0,352 GOLDMAN SACHS TREASURY FUND 61,199,857.50 61,199,857,50 61,199,857.50 25.02 1 1 0.010 Investments Cash Passbook/Checking (not Included In yield calculations) Total Cash and Investments 244,654,914.59 8,352,844.92 245,436,964.59 2",631,319.90 100,00% 80 8,352,844.92 8,352,844.92 253,007,759.51 253,789,809.51 252,984,164.82 80 153 0.549 1 0.000 153 0.549 TOM Ewm np DeoWdW 31 M0nM End&q Current Year 112,704.39 Average Daily Balance 258,429,006.70 Effective Rate of Return 0.51% 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 sufficlent 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. 1-20-2021 Janet M. 6yoore, Director of Finance/City Treasurer BY SAS -RDA VERIFIED BY: srS Reporting period 12/01/2020-12/3112020 Original on file with City Clerk's Office Portfolio CITY AP Run Date: 01115M21 -12 01 No fiscal year history available IF (PRF_PM1)7.3.11 Report Ver. 7.3.11 y CITY OF PALM DESERT Portfolio Management Portfolio Details - Investments December 31, 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,128,893.35 9,1.28,893.35 9,128,893.35 0.120 0.120 1 SYS12444 12444 C.A.M.P. POOL (DESERT WILLOW) 729,872.11 729,872.11 729,872.11 0.120 0.120 1 Subtotal and Average 9,857,784.72 9,858,765.46 9,858,765.46 9,858,765.46 0.120 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.540 0.540 1 4,605,369.20 4,605,369.20 4,605,369.20 0.540 1 LAIF 12000 12000 LOCAL AGENCY INVESTMENT FUND 74,040,575.23 74,040,575.23 74,040,575.23 0.540 0.540 1 Subtotal and Average 74,040,575.23 74,040,575.23 74,040,575.23 74,040,575.23 0.540 1 GOLDMAN SACHS GOVT FUND 252026000-G 382 GOLDMAN SACHS 0.00 0.00 0.00 0.030 Aaa 0.030 1 252026001-G 383 GOLDMAN SACHS 0.56 0.56 0.56 0.030 Aaa 0.030 1 252026002-G 384 GOLDMAN SACHS 0.79 0.79 0.79 0.030 Aaa 0.030 1 252026003-G 385 GOLDMAN SACHS 0.15 0.15 0.15 0.030 Aaa 0.030 1 252026004-G 386 GOLDMAN SACHS 930.72 930.72 930.72 0.030 Aaa 0.030 1 252026017-G 401 GOLDMAN SACHS 362.94 362.94 362.94 0.030 Aaa 0.030 1 252026018-G 402 GOLDMAN SACHS 10,402.80 10,402.80 10,402.80 0.030 Aaa 0.030 1 260128000-G 404 GOLDMAN SACHS 15,966.06 15,966.06 15,966.06 0.030 Aaa 0.030 1 260128001-G 405 GOLDMAN SACHS 07/01/2019 0.00 0.00 0.D0 0.030 Aaa 0.030 1 260128002-G 407 GOLDMAN SACHS 07/01/2019 0.00 0.00 0.00 0.030 Aaa 0.030 1 260128003-G 408 GOLDMAN SACHS 07/01/2019 0.00 0.00 0.00 0.030 Aaa 0.030 1 260128004-G 409 GOLDMAN SACHS 07/01/2019 0.00 0.00 0.00 0.030 Aaa 0.030 1 260128005-G 410 GOLDMAN SACHS 0.00 0.00 0.00 0.030 Aaa 0.030 1 260128006-G 412 GOLDMAN SACHS 0.00 0.00 0.00 0.030 Aaa 0.030 1 260128007-G 414 GOLDMAN SACHS 0.00 0.00 0.00 0.030 Aaa 0.030 1 260128008-G 415 GOLDMAN SACHS 0.00 0.00 0.00 0.030 Aaa 0.030 1 260128009-G 416 GOLDMAN SACHS 07/01/2019 1.20 1.20 1.20 0.030 Aaa 0.030 1 260128010-G 417 GOLDMAN SACHS 8,830.26 8,830.26 8,830.26 0.030 Aaa 0.030 1 260128011-G 418 GOLDMAN SACHS 160,866.28 160,866.28 160,866.28 0.030 Aaa 0.030 1 261470000-G 419 GOLDMAN SACHS 12.83 12.83 12.83 0.030 Aaa 0.030 1 261470001-G 420 GOLDMAN SACHS 98,610.31 98,610.31 98,610.31 0.030 Aaa 0.030 1 Run Date: 0111512021 - 12:01 Portfolio CITY AP PM (PRF_PM2) 7.3.11 Report Ver. 7.3.11 CITY OF PALM DESERT Portfolio Management Portfolio Details - Investments December 31, 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,295.59 1,774,295.59 1,774,295.59 0.030 Aaa 0.030 1 Subtotal and Average 2,149,454.13 2,070,280.49 2,070,280.49 2,070,280.49 0.030 1 MEDIUM -TERM NOTES 037833DL1 614 APPLE, INC. 09/11/2019 5,000,000.00 5,126,350.00 4,999,175.37 1.700 As 1.710 618 09/11/2022 0378331311 616 APPLE, INC. 09/25/2019 10,000,000.00 10,252,700.00 9,994,226.17 1.700 As 1.735 618 09/11/2022 254687FJO 625 WALT DISNEY COMPANY 11/20/2019 5,000,000.00 5,115,100.00 4,996,733.27 1.650 A 1.690 608 09/01/2022 02665WBG5 615 AMERICAN HONDA FINANCE 09/09/2019 5,000,000.00 5,047,050.00 4,992,096.72 1.700 A 1.935 251 09/09/2021 02666WDC2 617 AMERICAN HONDA FINANCE 09/27/2019 5,000,000.00 5,170,450.00 4,999,969.19 2.050 A 2.045 739 01/10/2023 02665WBF7 623 AMERICAN HONDA FINANCE 11/15/2019 5,000,000.00 5,036,000.00 4,995,696.90 1.650 As 1.815 192 07/12/2021 549418BP8 624 MICROSOFT CORPORATION 11/20/2019 5,000,000.00 5,034,400.00 4,998,507.69 1.550 Aaa 1.600 219 08/08/2021 Subtotal and Average 39,975,316.71 40,000,000.00 40,782,050.00 39,976,405.31 1.783 483 RIVERSIDE COUNTY POOL 052460 052460 POOLED INVESTMENT FUND 52,880,066.71 52,880,066.71 52,880,066.71 0.352 Aaa 0.352 1 Subtotal and Average 52,355,418.00 52,880,066.71 52,880,066.71 52,880,066.71 0.352 1 GOLDMAN SACHS TREASURY FUND 6736302420 498 GOLDMAN SACHS 9,459,487.65 9,459,487.65 9,459,487.65 0.010 Aaa 0.010 1 6736302430 499 GOLDMAN SACHS 21,629,089.89 21,629,089.89 21,629,089.89 0.010 Aaa 0.010 1 6736302440 500 GOLDMAN SACHS 9,787,517.17 9,787,517.17 9,787,517.17 0.010 Aaa 0.010 1 6736302450 501 GOLDMAN SACHS 20,323,762.79 20,323,762.79 20,323,762.79 0.010 Aaa 0.010 1 Subtotal and Average 61,201,891.97 61,199,857.50 61,199,857.50 61,199,857.50 0.010 1 Total and Average 258,429,006.70 244,654,914.59 245,436,964.59 244,631,319.90 0.549 80 Portfolio CITY AP Run Date: 01/15/2021 - 12:01 PM (PRF_PM2) 7.3.11 CITY OF PALM DESERT Portfolio Management Portfolio Details - Cash December 31, 2020 Page 3 Average Purchase Stated YTM/C Days to CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate Moody's 365 Mat./Call UNION BANK CHECKING ACCOUNTS SYS13016 13016 CITY OF PALM DESERT MAIN 7,081,535.08 7,081,535,08 7,081,535.08 0,000 1 SYS13013 13013 DESERT WILLOW GOLF COURSE 07/01/2019 534,153.83 534,153.83 534,153.83 0.000 1 SYS602 602 PUBLIC SAFETY CHECKING 07/01/2019 404,379.58 404,379.58 404,379.58 0.000 1 SYS13020 13020 RECREATIONAL FACILITIES CORP 07/01/2019 332,776.43 332,776.43 332,776.43 0.000 1 Average Balance 0.00 1 Total Cash and Investments 258,429,006.70 Ron Date: 01116/2021 - 12:01 253,007,759.51 253,789,809.51 252,984,164.82 0.549 80 Portfolio CITY AP PM (PRF_PM2) 1.3.11 PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Summary December 31, 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,277.63 4,938,277.63 4,938,277.63 9.55 1 1 0.010 CAMP 45,804,011.06 45,804,011.06 45,804,011.06 88.58 1 1 0.120 LAIF 968,061.79 968,061.79 968,061.79 1.87 1 1 0.540 51,710,350.48 61,710,350.48 51,710,350.48 100.00% 1 1 0.117 Investments Cash Passbook/Checking 4,475,622.70 4,475,622.70 4,475,622.70 1 1 0.000 (not included in yield calculations) Total Cash and Investments 56,185,973.18 56,185,973.18 56,185,973.18 1 1 0.117 Total Earnings December 31 Month Ending Current Year 5,153.71 Average Daily Balance 56,064,881.84 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. Qw 1-20-2021 Janet . Moore, Director of Finance/City Treasurer Reporting period 12/01/2020-12/31/2020 Run Date: 01/1512021 -13:19 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 Page 1 Portfolio Details - Investments December 31, 2020 Average Purchase Stated Days to YTM/C Maturity CUSIP Investment # Issuer Balance Date Par Value Markel Value Book Value Rate Mootly's Mat./Call 365 Date GOLDMAN SACHS TREASURY FUND 6736302460 590 GOLDMAN SACHS 4,938,277.63 4,938,277.63 4,938,277.63 0.010 Aaa 1 0.010 Subtotal and Average 4,938,277.63 4,938,277.63 4,938,277.63 4,938,277.63 1 0.010 CAMP SYS12008 12008 CA ASSET MANAGEMENT PROGRAM 45,804,011.06 45,804,011.06 45,804,011.06 0.120 1 0.120 Subtotal and Average 45,799,454.55 45,804,011.06 45,804,011.06 45,804,011.06 1 0.120 LAW SYS21003 21003 LOCAL AGENCY INVESTMENT FUND 968,061.79 968,061.79 968,06139 0.540 1 0.540 Subtotal and Average 968,061.79 968,061.79 968,061.79 968,061.79 1 0.540 Total and Average 56,064,881.84 Run Date: 01/15/2021 - 13:19 51,710,350.48 51,710,350.48 51,710,350.48 Portfolio HA AP PM (PRF_PM2) 7.3.11 Report Ver. 7.3.11 PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Details - Cash December 31, 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,064,881.84 Ron Date: 01116/2021 - 13:19 4,013,174.20 4,013,174,20 4,013,174.20 07/01/2019 462,448.50 462,448.50 462,448.50 56,185,973.18 56,185,973.18 56,185,973.18 1 0.000 1 0.000 1 0.117 Portfolio HA AP PM (PRF_PM2) 7.3.11 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Summary December 31, 2020 Par Market Book % of Days to YTM/C Investments Value Value Value Portfolio Mat./Call Term 365 Equiv. RIVERSIDE COUNTY POOL 335.26 335.26 335.26 0,00 1 1 0,352 CAMP 5,725.89 5,725.89 5,725.89 0,04 1 1 0.120 LAIF 739.47 739.47 739.47 0,00 1 1 0.540 US BANK MONEY MARKET ACCT 15,376,221.61 15,376,221.61 15,376,221.61 97.41 1 1 0.010 GOLDMAN SACHS GOVT FUND 402,009.20 402,009.20 402,009.20 2.55 1 1 0.030 15,785,031.43 15,785,031.43 15,785,031.43 100.00% 1 1 0.011 Investments Cash Passbook/Checking (not included in yield calculations) Total Cash and Investments 1,233,985.28 1,233,985.28 1,233,985.28 1 1 0.000 17,019,016.71 17,019,016.71 17,019,016.71 1 1 0.011 Total Earnings December 31 Month Ending Current Year 141.85 Average Daily Balance 17,015,116.93 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. C�G�Z2� Janet M. Woore, Finance Officer Reporting period 12/01/2020-12/31/2020 1-20-2021 Run Date: 01/15/2021 -13:25 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 December 31, 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 335.26 335.26 335.26 0.352 Aaa 1 0.352 Subtotal and Average 334.89 335.26 335.26 335.26 1 0.352 CAMP SYS578 578 C.A.M.P. POOL (RDA S.A.) 5,725.89 5,725.89 5,725.89 0.120 1 0.120 Subtotal and Average 5,725.32 5,725.89 5,725.89 5,725.89 1 0.120 LAW SYS604 604 L.A.I.F.(RDA S.A.) 739.47 739.47 739.47 0.540 1 0.540 Subtotal and Average 739.47 739.47 739.47 739.47 1 0.540 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,910.19 527,910.19 527,910.19 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,930.52 7,434,930.52 7,434,930.52 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,634.54 2,945,634.54 2,945,634.54 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,710.85 4,467,710.85 4,467,710.85 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,221.61 15,376,221.61 15,376,221.61 15,376,221.61 1 0.010 GOLDMAN SACHS GOVT FUND 277861000-G 811 GOLDMAN SACHS 402,009.20 402,009.20 402,009.20 0.030 Aaa 1 0.030 277861001-G 812 GOLDMAN SACHS 0.00 0.00 0.00 0.030 Aaa 1 0.030 277861002-G 813 GOLDMAN SACHS 07/01/2019 0.00 0.00 0.00 0.030 Aaa 1 0.030 Portfolio RDAS AP Run Date: 01/15/2021 - 13:25 PM (PRF_PM2) 7.3.11 Report Ver. 7.3.11 RDA SUCCESSOR AGENCY Portfolio Management Page Portfolio Details - Investments December 31, 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.030 Aaa 1 0.030 Subtotal and Average 402,009.20 402,009.20 402,009.20 402,009.20 1 0.030 Total and Average 17,015,116.93 Ron Date: 01116/2021 - 13:25 15,785,031.43 15,785,031.43 15,785,031.43 Portfolio RDAS AP PM (PRF_PM2) 7.3.11 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Cash December 31, 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 - 13:25 582 RDA SUCCESSOR AGENCY Average Balance 0.00 Total Cash and Investments 17,015,116.93 1,233,985.28 17,019,016.71 1,233,985.28 17,019,016.71 1,233,985.28 17,019,016.71 1 0.000 1 0.011 Portfolio RDAS AP PM (PRF_PM2) 1.3.11