The URL can be used to link to this page

Home My WebLink About02A Invstmnt Rprt Oct2020CITY COUNCIL ACTION APPROVED DENTED RECEIVED =-I 11 e d OTHER CITY OF PALM DESERT Portfolio Management MEETING DATE AYES: Wni SfiAV� i Portfolio Summary NOES: None _ October 31, 2020 D►)C ABSENT:.l -- -- ABSTAIN; rt-e- VERIFIED BYE SrS - Par Market Book ON0,11nal oRamle with City ( lerk'YWR1ce Investments Who Who Yaho Portfolio Mat.ICall Term 365 Equiv. CAMP 9,856,654.95 9,85e,654.95 9,856,654.95 4.07 1 1 0.190 U,S. BANK / LAIF BOND PROCEEDS 4,605,369.20 4,605,36920 4,605,369.20 1.90 1 1 0.620 LAW 74,040,575.23 74,040,575.23 74,040,575.23 30.60 1 1 0.620 GOLDMAN SACHS GOVT FUND 2,258,989.90 2,258,%9.90 2,258,989.90 0.93 1 1 0.030 MEDIUM -TERM NOTES 40,000,000.00 40,831,150.00 39,971,750.60 16.52 544 930 1.783 COMMERCIAL PAPER 5,000,000.00 4,999,550.00 4,971,231.94 2.05 29 269 0,795 RIVERSIDE COUNTY POOL 44,862,459.37 44,862,459.37 44,862,459.37 18.54 1 1 0.522 GOLDMAN SACHS TREASURY FUND 61,384,958.79 61,384,958.79 61,384,958.79 25.37 1 1 0.010 Investments Cash Passbook/Checking (not included In yield calculations) Total Cash and Investments 242,009,007.44 242,839,707.44 241,951,989.98 100.00% 91 11,31802.81 11,318,602.81 11,318,602.81 253,327,610.25 264,158,310.25 253,270,592.79 91 160 0.620 1 0.000 160 0.620 Total Ewnktps ociww31 Novo Current Year 129,605.72 Average Daily Balance 249,751,714.29 Effective Rate of Return 0.61 % This investment portfolio is in compliance with the provisions of California Govemment 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 pq the Portfolio Summary page omits demand deposits. W. 1-20-2021 Janet M. f66ore, Director of Finance/City Treasurer VeLjym + FI lfA BY SA -RDA ON 2 - I I - 2nn0 2-1VERIFIED BY: C2(A SrS Reporting period 1010112020-10/31/2020 Portfolio CITY )riginal on file with City Clerk's Office AP Run Date: 01120=21 -13:19 No fiscal year history available IE(PRf PM7)7.3.11 Report Ver, 7.3.11 CITY OF PALM DESERT Portfolio Management Portfolio Details - Investments October 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,126,939.09 9,126,939.09 9,126,939.09 0.190 0.190 1 SYS12444 12444 C.A.M.P. POOL (DESERT WILLOW) 729,715.86 729,715.86 729,715.86 0.190 0.190 1 Subtotal and Average 6,926,655.75 9,856,654.95 9,856,654.95 9,856,654.95 0.190 1 U.S. BANK / LAIF BOND PROCEEDS 252026003 1233084 LOCAL AGENCY INVESTMENT FUND Subtotal and Average 4,600,962.05 4,605,369.20 4,605,369.20 4,605,369.20 0.620 0.620 1 4,605,369.20 4,605,369.20 4,605,369.20 0.620 1 LAIF 12000 12000 LOCAL AGENCY INVESTMENT FUND 74,040,575.23 74,040,575.23 74,040,575.23 0.620 0.620 1 Subtotal and Average 74,649,530.18 74,040,575.23 74,040,575.23 74,040,575.23 0.620 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.68 930.68 930.68 0.030 Aaa 0.030 1 252026017-G 401 GOLDMAN SACHS 362.92 362.92 362.92 0.030 Aaa 0.030 1 252026018-G 402 GOLDMAN SACHS 10,402.38 10,402.38 10,402.38 0.030 Aaa 0.030 1 260128000-G 404 GOLDMAN SACHS 15,965.43 15,965.43 15,965.43 0.030 Aaa 0.030 1 260128001-G 405 GOLDMAN SACHS 07/01/2019 0.00 0.00 0.00 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 5.40 5.40 5.40 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 188,785.81 188,785.81 188,785.81 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,829.91 8,829.91 8,829.91 0.030 Aaa 0.030 1 260128011-G 418 GOLDMAN SACHS 160,859.93 160,859.93 160,859.93 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,606.42 98,606.42 98,606.42 0.030 Aaa 0.030 1 Run Date: 01/20/2021 - 13:19 Portfolio CITY AP PM (PRF_PM2) 7.3.11 Report Ver. 7.3.11 CITY OF PALM DESERT Portfolio Management Portfolio Details - Investments October 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 Mat./Call Date GOLDMAN SACHS GOVT FUND 261470002-G 421 GOLDMAN SACHS 1,774,225.49 1,774,225.49 1,774,225.49 0.030 Aaa 0.030 1 Subtotal and Average 2,258,988.83 2,258,989.90 2,258,989.90 2,258,989.90 0.030 1 MEDIUM -TERM NOTES 037833DL1 614 APPLE, INC. 09/11/2019 5,000,000.00 5,130,800.00 4,999,094.26 1.700 As 1.710 679 09/11/2022 0378331311 616 APPLE, INC. 09/25/2019 10,000,000.00 10,261,600.00 9,993,658.26 1.700 As 1.735 679 09/11/2022 254687FJO 625 WALT DISNEY COMPANY 11/20/2019 5,000,000.00 5,122,650.00 4,996,406.59 1.650 A 1.690 669 09/01/2022 02665WBG5 615 AMERICAN HONDA FINANCE 09/09/2019 5,000,000.00 5,059,800.00 4,990,184.64 1.700 A 1.935 312 09/09/2021 02666WDC2 617 AMERICAN HONDA FINANCE 09/27/2019 5,000,000.00 5,170,050.00 4,999,966.65 2.050 A 2.045 800 01/10/2023 02665WBF7 623 AMERICAN HONDA FINANCE 11/15/2019 5,000,000.00 5,042,650.00 4,994,345.14 1.650 As 1.815 253 07/12/2021 549418BP8 624 MICROSOFT CORPORATION 11/20/2019 5,000,000.00 5,043,600.00 4,998,095.06 1.550 Aaa 1.600 280 08/08/2021 Subtotal and Average 39,970,662.01 40,000,000.00 40,831,150.00 39,971,750.60 1.783 644 COMMERCIAL PAPER 89233GLW4 633 TOYOTA MOTOR CREDIT CORP 03/06/2020 5,000,000.00 4,999,550.00 4,971,231.94 P-1 0.795 29 11/30/2020 Subtotal and Average 9,623,912.95 5,000,000.00 4,999,550.00 4,971.231.94 0.795 29 RIVERSIDE COUNTY POOL 052460 052460 POOLED INVESTMENT FUND 44,862,459.37 44,862,459.37 44,862,459.37 0.522 Aaa 0.522 1 Subtotal and Average 43,845,593.09 44,862,459.37 44,862,459.37 44,862,459.37 0.522 1 GOLDMAN SACHS TREASURY FUND 6736302420 498 GOLDMAN SACHS 9,616,910.92 9,616,910.92 9,616,910.92 0.010 Aaa 0.010 1 6736302430 499 GOLDMAN SACHS 21,639,374.86 21,639,374.86 21,639,374.86 0.010 Aaa 0.010 1 6736302440 500 GOLDMAN SACHS 9,787,255.40 9,787,255.40 9,787,255.40 0.010 Aaa 0.010 1 6736302450 501 GOLDMAN SACHS 20,341,417.61 20,341,417.61 20,341,417.61 0.010 Aaa 0.010 1 Subtotal and Average 62,053,402.21 61,384,958.79 61,384,958.79 61,384,958.79 0.010 1 Total and Average 249.751,714.29 242,009,007.44 242,839,707.44 241,951,989.98 0.620 91 Run Date: 01/20/2021 - 13:19 Portfolio CITY AP PM (PRF_PM2) 7.3.11 CITY OF PALM DESERT Portfolio Management Portfolio Details - Cash October 31, 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 8,830,461.65 8,830,461.65 8,830,461.65 0.000 1 SYS13013 13013 DESERT WILLOW GOLF COURSE 07/01/2019 821,883.66 821,883.66 821,883.66 0.000 1 SYS602 602 PUBLIC SAFETY CHECKING 07/01/2019 1,295,259.87 1,295,259.87 1,295,259.87 0.000 1 SYS13020 13020 RECREATIONAL FACILITIES CORP 07/01/2019 370,997.63 370,997.63 370,997.63 0.000 1 Average Balance 0.00 1 Total Cash and Investments 249,751,714.29 Run Date: 01120/2021 - 13:19 253,327,610.25 254,158,310.25 253,270,592.79 0.620 91 Portfolio CITY AP PM (PRF_PM2) 7.3.11 PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Summary October 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,082.58 4,938,082,58 4,938,082.58 9.55 1 1 0.010 CAMP 45,794,205.62 45,794,205.62 45,794,205.62 88.58 1 1 0.190 LAIF 968,061.79 968,061.79 968,061.79 1.87 1 1 0.620 51,700,349.99 61,700,349.99 51,700,349.99 100.00% 1 1 0.181 Investments Cash Passbook/Checking 4,367,278.83 4,367,278.83 4,367,278.83 1 1 0,000 (not included in yield calculations) Total Cash and Investments 56,067,628.82 56,067,628.82 56,067,628.82 1 1 0.181 Total Earnings October 31 Month Ending Current Year 5,718.08 Average Daily Balance 56,773,651.80 Effective Rate of Return 0.12% 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 suf0cient 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. A W- 7e2-&&4z 1-20-2021 Janet tyMoore, Director of Finance/City Treasurer Reporting period 10/01/2020-10/31/2020 Run Date: 01/2012021 -13:22 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 October 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,082.58 4,938,082.58 4,938,082.58 0.010 Aaa 1 0.010 Subtotal and Average 4,938,082.58 4,938,082.58 4,938,082.58 4,938,082.58 1 0.010 CAMP SYS12008 12008 CA ASSET MANAGEMENT PROGRAM 45,794,205.62 45,794,205.62 45,794,205.62 0.190 1 0.190 Subtotal and Average 46,948,540.93 45,794,205.62 45,794,205.62 45,794,205.62 1 0.190 LAW SYS21003 21003 LOCAL AGENCY INVESTMENT FUND 968,061.79 968,061.79 968,061.79 0.620 1 0.620 Subtotal and Average 967,135.40 968,061.79 968,061.79 968,061.79 1 0.620 Total and Average 56,773,651.80 Run Date: 01/20/2021 -13:22 51,700,349.99 51,700,349.99 51,700,349.99 Portfolio HA AP PM (PRF_PM2) 7.3.11 Report Ver. 7.3.11 PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Details - Cash October 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,773,651.80 Ron Date: 01120/2021 -13:22 3,905,222.33 3,905,222,33 3,905,222.33 07/01/2019 462,056.50 462,056.50 462,056.50 56,067,628.82 56,067,628.82 56,067,628.82 1 0.000 1 0.000 1 0.181 Portfolio HA AP PM (PRF_PM2) 1.3.11 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Summary October 31, 2020 Par Market Book % of Days to 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,522 CAMP 5,724.66 5,724.66 5,724.66 0,04 1 1 0.190 LAIF 739.47 739.47 739.47 0,00 1 1 0.620 US BANK MONEY MARKET ACCT 15,376,093.48 15,376,093.48 15,376,093.48 97.41 1 1 0.010 GOLDMAN SACHS GOVT FUND 401,993.32 401,993.32 401,993.32 2.55 1 1 0.030 15,784,885.73 15,784,885.73 15,784,885.73 100.00% 1 1 0.011 Investments Cash Passbook/Checking (not included in yield calculations) Total Cash and Investments 1, 219,381.07 1,219,381.07 1,219,381.07 1 1 0.000 17,004,266.80 17,004,266.80 17,004,266.80 1 1 0.011 Total Earnings October 31 Month Ending Current Year 75.40 Average Daily Balance 17,026,305.83 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. 9(i./Lt-{' - 7ew,4z 1-20-2021 Janet M. VAoore, Finance Officer Reporting period 10/01/2020-10/31/2020 Run Date: 01/20/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 Portfolio Details - Investments October 31, 2020 Page 1 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 RIVERSIDE COUNTY POOL SYS052470 052470 POOLED INVESTMENT FUND 334.80 334.80 334.80 0.522 Aaa 1 0.522 Subtotal and Average 334.78 334.80 334.80 334.80 1 0.522 CAMP SYS578 578 C.A.M.P. POOL (RDA S.A.) 5,724.66 5,724.66 5,724.66 0.190 1 0.190 Subtotal and Average 5,723.80 5,724.66 5,724.66 5,724.66 1 0.190 LAW SYS604 604 L.A.I.F.(RDA S.A.) 739.47 739.47 739.47 0.620 1 0.620 Subtotal and Average 738.76 739.47 739.47 739.47 1 0.620 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,905.79 527,905.79 527,905.79 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,868.56 7,434,868.56 7,434,868.56 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 844 US BANK 2,945,610.00 2,945,610.00 2,945,610.00 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,673.62 4,467,673.62 4,467,673.62 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,093.48 15,376,093.48 15,376,093.48 15,376,093.48 1 0.010 GOLDMAN SACHS GOVT FUND 277861000-G 811 GOLDMAN SACHS 277861001-G 812 GOLDMAN SACHS 277861002-G 813 GOLDMAN SACHS Run Date: 01/20/2021 - 13:25 401,993.32 401,993.32 401,993.32 0.030 Aaa 1 0.030 0.00 0.00 0.00 0.030 Aaa 1 0.030 07/01/2019 0.00 0.00 0.00 0.030 Aaa 1 0.030 Portfolio RDAS AP PM (PRF_PM2) 7.3.11 Report Ver. 7.3.11 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Investments October 31, 2020 Page 2 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 401,993.32 401,993.32 401,993.32 401,993.32 1 0.030 Total and Average 17,026,305.83 Ron Date: 01120/2021 -13:25 15,784,885.73 15,784,885.73 15,784,885.73 Portfolio RDAS AP PM (PRF_PM2) 7.3.11 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Cash October 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: 01120/2021 - 13:25 582 RDA SUCCESSOR AGENCY Average Balance 0.00 Total Cash and Investments 17,026,305.83 1,219,381.07 17,004,266.80 1,219,381,07 17,004,266.80 1,219,381.07 17,004,266.80 1 0.000 1 0.011 Portfolio RDAS AP PM (PRF_PM2) 7.3.11