The URL can be used to link to this page

Home My WebLink About07B Treasurer's Report - April 2021investments CAMP IJ.S. BANK LAIF BOND PROCEEDS LAIF TRUSTEE CASH BALANCES MEDIUM -TERM NOTES CUSTODIAN PROJECT FUNDS RIVERSIDE COUNTY POOL Investments Cash Passbook/Checking (not included in yield calculations) Total Cash and Investments Par Value 6,961,073.34 4,617,690.14 74,238,968.53 1,963,023.86 40,000,000.00 58,684,877.61 68,533,259.83 254,998,893.31 CITY OF PALM DESERT Portfolio Management Portfolio Summary April 30, 2021 Market Value 6,961,073.34 4,617,690,14 74,238,968.53 1,963,023.86 40,586,300.00 58,684,877.61 68,533,259,83 255,585,193.31 7,474,606.24 7,474,606.24 262,473,499.55 263,059,799.55 Total Earnings April 30 Month Ending Fiscal Year To Date Current Year 99,952.15 1,221,707.49 Average Daily Balance 259,023,570.59 256,647,307.22 Effective Rate of Return 0.47% 0.57% Book % of Days to YTM!C Value Portfolio Mat/Call Term 365 Equiv. 6,961,073.34 2.73 1 1 0.060 4,617,690.14 1.81 1 1 0.339 74,238,968.53 29.12 1 1 0.339 1,963,023.86 0.77 1 1 0.040 39, 985,714.71 15.68 363 930 1.783 58,684,877.61 23.02 1 1 0.040 68,533,259.83 26.88 1 1 0.290 254,984,608.02 100.00% 58 147 0.474 7,474,606.24 262,459,214.26 58 147 0.000 0.474 This investment portfolio is in compliance with the provisions of Califomia 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 on the Portfolio Summary page omits demand deposits. ),�,„a 5-18-21 axat9frt Janet M. Moore, Director of Finance/City Treasurer Reporting period 04/01/2021-0413012021 Run Date: 05/17/2021 - 15:25 CITY COUNCIL ACTION APPROVED DENIED RECEIVED "k' I IE'-1 OTHER MEETING DATE 0 I f 'i,U AYES:4 U't'l.hJ IOI 4fh(j1, Nes Ci,1'1CI - ..Iti��(111�71i�1I 11U' ��i� NOES: MOr)r. ABSENT: N OOP ABSTAIN: NfY)E VERIFIED BY: L4& /3Y Original 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 April 30, 2021 Page 1 Average Purchase Stated YTM/C Days to Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Moodv's 365 Mat./Call Date CAMP SYS13 13 C.A.M.P. POOL (CITY) 6,230,988.87 6,230,988.87 6,230,988.87 0.060 0.060 1 SYS12444 12444 C.A.M.P. POOL (DESERT WILLOW) 730,084.47 730,084.47 730,084.47 0.060 0.060 1 Subtotal and Average 4,860,856.98 6,961,073.34 6,961,073.34 6,961,073.34 0.060 1 U.S. BANK / LAIF BOND PROCEEDS 252026003 12-33-084 LOCAL AGENCY INVESTMENT FUND 07/01/2020 4,617,690.14 4,617,690.14 4,617,690.14 0.339 0.339 1 Subtotal and Average 4,615,338.48 4,617,690.14 4,617,690.14 4,617,690.14 0.339 1 LAIF 12000 12000 LOCAL AGENCY INVESTMENT FUND 74,238,968.53 74,238,968.53 74,238,968.53 0 339 0 339 1 Subtotal and Average 74,201,160.71 74,238,968.53 74,238,968.53 74,238,968.53 0.339 1 TRUSTEE CASH BALANCES 252026000-G 382 GOLDMAN SACHS GOVERNMENT FUND 0.00 0.00 0.00 0.040 Aaa 0.040 1 252026001-G 383 GOLDMAN SACHS GOVERNMENT FUND 2.79 2.79 2.79 0.040 Aaa 0 040 1 252026002-G 384 GOLDMAN SACHS GOVERNMENT FUND 0.79 0.79 0.79 0.040 Aaa 0.040 1 252026003-G 385 GOLDMAN SACHS GOVERNMENT FUND 0.15 0.15 0.15 0.040 Aaa 0.040 1 252026004-G 386 GOLDMAN SACHS GOVERNMENT FUND 930.81 930.81 930.81 0.040 Aaa 0.040 1 252026017-G 401 GOLDMAN SACHS GOVERNMENT FUND 362.98 362.98 362.98 0.040 Aaa 0.040 1 252026018-G 402 GOLDMAN SACHS GOVERNMENT FUND 10,403.78 10,403.78 10,403.78 0.040 Aaa 0.040 1 260128000-G 404 GOLDMAN SACHS GOVERNMENT FUND 15,967.57 15,967.57 15,967.57 0.040 Aaa 0 040 1 260128001-G 405 GOLDMAN SACHS GOVERNMENT FUND 07/01/2020 0.00 0.00 0.00 0.040 Aaa 0.040 1 260128002-G 407 GOLDMAN SACHS GOVERNMENT FUND 07/01/2020 0.00 0.00 0.00 0.040 Aaa 0.040 1 260128003-G 408 GOLDMAN SACHS GOVERNMENT FUND 07/01/2020 0.00 0.00 0.00 0.040 Aaa 0.040 1 260128004-G 409 GOLDMAN SACHS GOVERNMENT FUND 07/01/2020 0.00 0.00 0.00 0.040 Aaa 0.040 1 260128005-G 410 GOLDMAN SACHS GOVERNMENT FUND 0.00 0.00 0.00 0.040 Aaa 0.040 1 260128006-G 412 GOLDMAN SACHS GOVERNMENT FUND 0.00 0.00 0.00 0.040 Aaa 0 040 1 260128007-G 414 GOLDMAN SACHS GOVERNMENT FUND 0.00 0.00 0.00 0.040 Aaa 0.040 1 260128008-G 415 GOLDMAN SACHS GOVERNMENT FUND 0.00 0.00 0.00 0.040 Aaa 0.040 1 260128009-G 416 GOLDMAN SACHS GOVERNMENT FUND 07/01/2020 0.51 0.51 0.51 0.040 Aaa 0.040 1 260128010-G 417 GOLDMAN SACHS GOVERNMENT FUND 0.30 0.30 0.30 0.040 Aaa 0.040 1 260128011-G 418 GOLDMAN SACHS GOVERNMENT FUND 160,881.44 160,881.44 160,881.44 0.040 Aaa 0.040 1 261470000-G 419 GOLDMAN SACHS GOVERNMENT FUND 5.66 5.66 5.66 0.040 Aaa 0 040 1 261470001-G 420 GOLDMAN SACHS GOVERNMENT FUND 4.37 4.37 4.37 0.040 Aaa 0.040 1 261470002-G 421 GOLDMAN SACHS GOVERNMENT FUND 1,774,462.71 1,774,462.71 1,774,462.71 0.040 Aaa 0.040 1 Run Date: 05/17/2021 - 15:25 Subtotal and Average 1,963,023.86 1,963,023.86 1,963,023.86 1,963,023.86 0.040 1 Portfolio CITY AP PM (PRF_PM2) 7.3.11 Report Ver 7.3.11 CUSIP Investment # MEDIUM -TERM NOTES 037833DL1 614 037833DL1 616 254687FJ0 625 02665WBG5 615 02665WDC2 617 02665WBF7 623 549418BP8 624 Issuer APPLE, INC. APPLE, INC. WALT DISNEY COMPANY AMERICAN HONDA FINANCE AMERICAN HONDA FINANCE AMERICAN HONDA FINANCE MICROSOFT CORPORATION Subtotal and Average CUSTODIAN PROJECT FUNDS 6736302420-G 6736302430-G 6736302440-G 6736302450-G 647 GOLDMAN SACHS 648 GOLDMAN SACHS 649 GOLDMAN SACHS 650 GOLDMAN SACHS RIVERSIDE COUNTY POOL 052460 052460 Subtotal and Average Average Balance 39,984,589.82 GOVERNMENT FUND GOVERNMENT FUND GOVERNMENT FUND GOVERNMENT FUND 59,180,586.19 POOLED INVESTMENT FUND Subtotal and Average 68,531,876.90 CUSTODIAN PROJECT FUNDS 6736302420 6736302430 6736302440 6736302450 Run Date: 05/17/2021 - 15:25 498 GOLDMAN SACHS 499 GOLDMAN SACHS 500 GOLDMAN SACHS 501 GOLDMAN SACHS Subtotal and Average Total and Average TREASURY FUND TREASURY FUND TREASURY FUND TREASURY FUND 0.00 259,023,570.59 CITY OF PALM DESERT Portfolio Management Portfolio Details - Investments April 30, 2021 Purchase Date Par Value Market Value Page 2 Stated YTM/C Days to Maturity Book Value Rate Moodv's 365 Mat./Call Date 09/11/2019 5,000,000.00 5,100,550.00 4,999,337.59 09/25/2019 10,000,000.00 10,201,100.00 9,995,362.01 11/20/2019 5,000,000.00 5,088,350.00 4,997,386.61 09/09/2019 5,000,000.00 5,025,400.00 4,995,920.89 09/27/2019 5,000,000.00 5,144,450.00 4,999,974.26 11/15/2019 5,000,000.00 5,013,850.00 4,998,400.42 11/20/2019 5,000,000.00 5,012,600.00 4,999,332.93 40,000,000.00 40,586,300.00 39,985,714.71 01/01/2021 8,694,509.90 8,694,509.90 8,694,509.90 01/01/2021 19,876, 501.62 19,876,501.62 19,876, 501.62 01/01/2021 9, 788, 314.21 9, 788, 314.21 9, 788, 314.21 01/01/2021 20,325,551.88 20,325,551.88 20,325,551.88 58, 684, 8 77.61 58, 684, 87 7.61 58,684,877.61 68,533,259.83 68,533,259.83 68,533,259.83 68,533,259.83 68,533,259.83 68,533,259.83 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 254,998,893.31 255,585,193.31 254,984,608.02 1.700 Aa 1.700 Aa 1.650 A 1.700 A 2.050 A 1.650 Aa 1.550 Aaa 0.040 Aaa 0.040 Aaa 0.040 Aaa 0.040 Aaa 1.710 498 09/11/2022 1.735 498 09/11/2022 1.690 488 09/01/2022 1.935 131 09/09/2021 2.045 619 01/10/2023 1 815 72 07/12/2021 1.600 99 08/08/2021 1.783 363 0 040 1 0.040 1 0.040 1 0.040 1 0.040 1 0.290 Aaa 0.290 1 0.010 Aaa 0.010 Aaa 0.010 Aaa 0.010 Aaa 0.290 1 0.010 0.010 0.010 0.010 0.000 0 0.474 58 Portfolio CITY AP PM (PRF_PM2) 7.3.11 CITY OF PALM DESERT Portfolio Management Portfolio Details - Cash April 30, 2021 Average Purchase Stated YTM/C Days to CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Moodv's 365 Mat./Call PENDING DEPOSIT WITH COUNTY POOL SYS651 651 CITY OF PALM DESERT MAIN 01/29/2021 0.00 0.00 0.00 0.000 1 UNION BANK CHECKING ACCOUNTS SYS13016 13016 CITY OF PALM DESERT MAIN 4,111,184.37 4,111,184.37 4,111,184.37 0.000 1 SYS13013 13013 DESERT WILLOW GOLF COURSE 07/01/2020 2,103,467.03 2,103,467.03 2,103,467.03 0.000 1 SYS602 602 PUBLIC SAFETY CHECKING 07/01/2020 379,475.03 379,475.03 379,475.03 0.000 1 SYS13020 13020 RECREATIONAL FACILITIES CORP 07/01/2020 880,479.81 880,479.81 880,479.81 0 000 1 Average Balance 0.00 1 Total Cash and Investments 259,023,570.59 262,473,499.55 263,059,799.55 262,459,214.26 0.474 58 Run Date: 05/17/2021 - 15:25 Page 3 Portfolio CITY AP PM (PRF_PM2) 7.3.11 CITY OF PALM DESERT Activity Report Sorted By Issuer April 1, 2021 - April 30, 2021 Par Value Par Value Percent Beginning Current Transaction Purchases or Redemptions or CUSIP Investment # Issuer of Portfolio Balance Rate Date Deposits Withdrawals Issuer: APPLE, INC. MEDIUM -TERM NOTES Subtotal and Balance Ending Balance 15,000,000.00 15,000,000.00 Issuer Subtotal 5.715% 15,000,000.00 0.00 0.00 15,000,000.00 Issuer: C.A.M.P. POOL (CITY) CAMP SYS13 13 C.A.M.P. POOL (CITY) 0.060 4,500,190.73 3,000,000.00 Subtotal and Balance 4,730,798.14 4,500,190.73 3,000,000.00 6,230,988.87 Issuer Subtotal 2.374% 4,730,798.14 4,500,190.73 3,000,000.00 6,230,988.87 Issuer: C.A.M.P. POOL (DESERT WILLOW) CAMP SYS12444 12444 C.A.M.P. POOL (DESERT WILLOW) 0.060 33.09 0.00 Subtotal and Balance 730,051.38 33.09 0.00 730,084.47 Issuer Subtotal 0.278% 730,051.38 33.09 0.00 730,084.47 Issuer: POOLED INVESTMENT FUND RIVERSIDE COUNTY POOL 052460 052460 POOLED INVESTMENT FUND 0.283 3,191.38 0.00 Subtotal and Balance 68,530,068.45 3,191.38 0.00 68,533,259.83 Issuer Subtotal 26.111% 68,530,068.45 3,191.38 0.00 68,533,259.83 Issuer: WALT DISNEY COMPANY MEDIUM -TERM NOTES Subtotal and Balance Issuer Subtotal 1.905% Run Date: 05/14/2021 - 15:06 5,000,000.00 5,000,000.00 0.00 0.00 5,000,000.00 5,000,000.00 Portfolio CITY CP DA (PRF_DA) 7 3 11 Report Ver 7 3 11 Percent CUSIP Investment # Issuer of Portfolio Issuer: GOLDMAN SACHS GOVERNMENT FUND TRUSTEE CASH BALANCES 252026004-G 252026017-G 252026018-G 260128000-G 260128010-G 260128011-G 261470001-G 261470002-G CITY OF PALM DESERT Activity Report April 1, 2021 - April 30, 2021 Par Value Beginning Current Transaction Balance Rate Date 386 GOLDMAN SACHS GOVERNMENT FUND 401 GOLDMAN SACHS GOVERNMENT FUND 402 GOLDMAN SACHS GOVERNMENT FUND 404 GOLDMAN SACHS GOVERNMENT FUND 417 GOLDMAN SACHS GOVERNMENT FUND 418 GOLDMAN SACHS GOVERNMENT FUND 420 GOLDMAN SACHS GOVERNMENT FUND 421 GOLDMAN SACHS GOVERNMENT FUND Subtotal and Balance CUSTODIAN PROJECT FUNDS 6736302420-G 6736302430-G 6736302440-G 6736302450-G 1,962,963.15 647 GOLDMAN SACHS GOVERNMENT FUND 648 GOLDMAN SACHS GOVERNMENT FUND 649 GOLDMAN SACHS GOVERNMENT FUND 650 GOLDMAN SACHS GOVERNMENT FUND Subtotal and Balance Issuer Subtotal 23.106% Issuer: GOLDMAN SACHS TREASURY FUND CUSTODIAN PROJECT FUNDS Subtotal and Balance Issuer Subtotal 0.000% Issuer: AMERICAN HONDA FINANCE MEDIUM -TERM NOTES Subtotal and Balance Issuer Subtotal Issuer: LOCAL AGENCY INVESTMENT FUND U.S. BANK / LAIF BOND PROCEEDS 5.715% 59,426,614.72 61,389,577.87 0.00 0.00 15,000,000.00 15,000,000.00 252026003 12-33-084 LOCAL AGENCY INVESTMENT FUND Subtotal and Balance 4,612,650.87 Run Date: 05/14/2021 - 15:06 0.040 0.040 0.040 0.040 0.040 0.040 0.040 0.040 0.040 0.040 0.040 0.040 0.339 Purchases or Deposits 0.03 0.01 0.32 0.49 0.03 4.93 0.50 54.40 60.71 269.46 633.12 300.08 623.10 1,825.76 1,886.47 0.00 0.00 5,039.27 5,039.27 Par Value Redemptions or Withdrawals 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 74,088.82 669,474.05 0.00 0.00 743,562.87 743,562.87 0.00 0.00 0.00 0.00 Page 2 Ending Balance 1,963,023.86 58,684,877.61 60,647,901.47 0.00 0.00 15,000,000.00 15,000,000.00 4,617,690.14 Portfolio CITY CP DA (PRF_DA) 7 3 11 Report Ver 7 3 11 CITY OF PALM DESERT Activity Report April 1, 2021 - April 30, 2021 Par Value Par Value Percent Beginning Current Transaction Purchases or Redemptions or Ending CUSIP Investment # Issuer of Portfolio Balance Rate Date Deposits Withdrawals Balance Issuer: LOCAL AGENCY INVESTMENT FUND LAIF 12000 12000 LOCAL AGENCY INVESTMENT FUND Subtotal and Balance 74,157,951.78 Issuer Subtotal 30.044% 78,770,602.65 Issuer: MICROSOFT CORPORATION MEDIUM -TERM NOTES 0.339 81,016.75 0.00 81,016.75 0.00 74,238,968.53 86,056.02 0.00 78,856,658.67 Subtotal and Balance 5,000,000.00 5,000,000.00 Issuer Subtotal 1.905% 5,000,000.00 0.00 0.00 5,000,000.00 Issuer: CITY OF PALM DESERT MAIN PENDING DEPOSIT WITH COUNTY POOL Subtotal and Balance 0.00 0.00 UNION BANK CHECKING ACCOUNTS SYS13016 13016 CITY OF PALM DESERT MAIN 12,111,951.72 11,137,041.40 Subtotal and Balance 3,136,274.05 12,111,951.72 11,137,041.40 4,111,184.37 Issuer Subtotal 1.566% 3,136,274.05 12,111,951.72 11,137,041.40 4,111,184.37 Issuer: DESERT WILLOW GOLF COURSE UNION BANK CHECKING ACCOUNTS SYS13013 13013 DESERT WILLOW GOLF COURSE 1,378,780.06 1,064,467.42 Subtotal and Balance 1,789,154.39 1,378,780.06 1,064,467.42 2,103,467.03 Issuer Subtotal 0.801% 1,789,154.39 1,378,780.06 1,064,467.42 2,103,467.03 Issuer: PUBLIC SAFETY CHECKING UNION BANK CHECKING ACCOUNTS SYS602 602 PUBLIC SAFETY CHECKING 343,414.43 37.05 Subtotal and Balance 36,097.65 343,414.43 37.05 379,475.03 Issuer Subtotal 0.145% 36,097.65 343,414.43 37.05 379,475.03 Run Date: 05/14/2021 - 15:06 Page 3 Portfolio CITY CP DA (PRF_DA) 7 3 11 Report Ver 7 3 11 CITY OF PALM DESERT Activity Report April 1, 2021 - April 30, 2021 Par Value Par Value Percent Beginning Current Transaction Purchases or Redemptions or Ending CUSIP Investment # Issuer of Portfolio Balance Rate Date Deposits Withdrawals Balance Issuer: RECREATIONAL FACILITIES CORP UNION BANK CHECKING ACCOUNTS SYS13020 13020 RECREATIONAL FACILITIES CORP 409,884.30 192,344.71 Subtotal and Balance 662,940.22 409,884.30 192,344.71 880,479.81 Issuer Subtotal 0.335% 662,940.22 409,884.30 192,344.71 880,479.81 Total 100.000% 259,775,564.80 18,835,388.20 16,137,453.45 262,473,499.55 Run Date: 05/14/2021 - 15:06 Page 4 Portfolio CITY CP DA (PRF_DA) 7 3 11 Report Ver 7 3 11 CITY OF PALM DESERT LONG-TERM LOANS RECEIVABLE APRIL 30, 2021 17-May-21 3:56 PM SymPro Book Stated No. Investment Value Maturity Date Interest Rate 1 City Loan to RDA* $ 10,575,462.50 N/A 0.34% 348 EIP Loan ** $ 1,394,000.00 09/02/34 7.00% 594 Highlands Utility Undergrounding *** $ 14,977.73 09/02/36 5.35% Assessment District 04-01 Deferred Loan ** Footnotes On May 17, 2019, the California State Department of Finance (DOF) denied the 1986 City Loan in the principal amount of $6,000,000 as an enforceable obligation of the Successor Agency of the Palm Desert Redevelopment Agency. Several attempts have been made to challenge this decision. The DOF, however, continues to maintain its position and its interpretation of the dissolution law as it relates to the loans. EIP balance adjustments made on 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 April 30, 2021 Par Market Book % of Days to YTMIC Investments Value Value Value Portfolio Mat./Call Term 365 Equiv. CAMP 48,817,877.95 48,817,877.95 48,817,877.95 89.20 1 1 0.060 LAIF 970,651.69 970,651.69 970, 651.69 1.77 1 1 0.339 CUSTODIAN PROJECT FUNDS 4,938,742.56 4,938,742.56 4,938,742.56 9.02 1 1 0.040 54,727,272.20 54,727,272.20 54,727,272.20 100.00% 1 1 0.063 Investments Cash Passbook/Checking 4,712,715.18 4,712,715.18 4,712,715.18 1 1 0.000 (not included in yield calculations) Total Cash and Investments Total Earnings Current Year Average Daily Balance Effective Rate of Return 59,439,987.38 59,439,987.38 April 30 Month Ending 2,840.04 59,376,498.40 0.06% Fiscal Year To Date 62,699.45 59,439,987.38 1 1 0.063 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. gart.etW. Weexe Janet M. Moore, Director of Finance/City Treasurer Reporting period 04/01/2021-04/3012021 Run Date: 05/17/2021 - 15:20 5-18-21 Portfolio HA AP IE (PRF_PM1) 7.3-11 Report Ver. 7.3.11 PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Details - Investments April 30, 2021 Page 1 Average Purchase Stated Days to YTM/C Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Moodv's Mat./Call 365 Date CAMP SYS12008 12008 CA ASSET MANAGEMENT PROGRAM 48,817,877.95 48,817,877.95 48,817,877.95 0.060 1 0.060 Subtotal and Average 48,815,738.89 48,817,877.95 48,817,877.95 48,817,877.95 1 0.060 CUSTODIAN PROJECT FUNDS 6736302460 590 GOLDMAN SACHS TREASURY FUND 0.00 0.00 0.00 0.010 Aaa 1 0.010 Subtotal and Average 0.00 0.00 0.00 0.00 0 0.000 LAIF SYS21003 21003 LOCAL AGENCY INVESTMENT FUND 970,651.69 970,651.69 970,651.69 0.339 1 0.339 Subtotal and Average 970,157.36 970,651.69 970,651.69 970,651.69 1 0.339 CUSTODIAN PROJECT FUNDS 6736302460-G 597 GOLDMAN SACHS GOVERNMENT FUND 01/01/2021 4,938,742.56 4,938,742.56 4,938,742.56 0.040 Aaa 1 0.040 Subtotal and Average 4,938,742.56 4,938,742.56 4,938,742.56 4,938,742.56 1 0.040 Total and Average 59,376,498.40 54,727,272.20 54,727,272.20 54,727,272.20 1 0.063 Run Date: 05/17/2021 - 15:20 Portfolio HA AP PM (PRF_PM2) 7.3.11 Report Ver 7.3.11 PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Details - Cash April 30, 2021 Average Purchase Stated Days to YTM/C CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Moodv's Mat./Call 365 CHECKING SYS25015 25015 HOUSING AUTH CHECKING 4,249,410.68 4,249,410.68 4,249,410.68 1 0.000 SYS25016 25016 HOUSING AUTH TRUST 07/01/2020 463,304.50 463,304.50 463,304.50 1 0.000 Run Date: 05/17/2021 - 15:20 Average Balance 0.00 1 Total Cash and Investments 59,376,498.40 59,439,987.38 59,439,987.38 59,439,987.38 1 0.063 Page 2 Portfolio HA AP PM (PRF_PM2) 7.3.11 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Summary April 30, 2021 Par Market Book % of Days to YTMIC Investments Value Value Value Portfolio Mat./Call Term 365 Equiv. RIVERSIDE COUNTY POOL 335.63 335.63 335.63 0.00 1 1 0.290 CAMP 5,727.56 5,727.56 5,727.56 0.02 1 1 0.060 LAIF 741.45 741.45 741.45 0.00 1 1 0.339 TRUSTEE CASH BALANCES - MMA 24,434,107.02 24,434,107.02 24,434,107.02 98.35 1 1 0.010 TRUSTEE CASH BALANCES - GF 402,051.74 402,051.74 402,051.74 1.62 1 1 0.040 24,842,963.40 24,842,963.40 24,842,963.40 100.00% 1 1 0.011 Investments Cash Passbook/Checking 1,662,548.15 1, 662, 548.15 1,662, 548.15 1 1 0.000 (not included in yield calculations) Total Cash and Investments Total Earnings Current Year Average Daily Balance Effective Rate of Return 26,505,511.55 26,505,511.55 April 30 Month Ending 214.62 26,506,729.71 0.01% Fiscal Year To Date 1,254.12 26,505,511.55 1 1 0.011 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. 5-18-21 Janet M. Moore, Finance Officer Reporting period 04/01/2021-04/3012021 Run Date: 05/17/2021 - 15:14 Portfolio RDAS AP IE (PRF_PM1) 7.3-11 Report Ver. 7.3.11 CUSIP Investment # RIVERSIDE COUNTY POOL SYS052470 Issuer RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Investments April 30, 2021 Page 1 Average Purchase Stated Days to YTM/C Maturity Balance Date Par Value Market Value Book Value Rate Moodv's Mat./Call 365 Date 052470 POOLED INVESTMENT FUND 335.63 335.63 335.63 0.290 Aaa 1 0.290 Subtotal and Average 335.62 335.63 335.63 335.63 1 0.290 CAMP SYS578 578 C.A.M.P. POOL (RDA S.A.) 5,727.56 5,727.56 5,727.56 0.060 1 0.060 Subtotal and Average 5,727.31 5,727.56 5,727.56 5,727.56 1 0.060 LAIF SYS604 604 L.A.I.F. (RDA S.A.) 07/01/2020 741.45 741.45 741.45 0.339 1 0.339 Subtotal and Average 741.07 741.45 741.45 741.45 1 0.339 TRUSTEE CASH BALANCES - MMA 247394001-U 830 U.S. BANK MONEY MARKET ACCOUNT 07/01/2020 0.13 0.13 0.13 0.010 P-1 1 0.010 247394003-U 832 U.S. BANK MONEY MARKET ACCOUNT 07/01/2020 0.00 0.00 0.00 0.010 P-1 1 0.010 247394002-U 833 U.S BANK MONEY MARKET ACCOUNT 207,500.00 207,500.00 207,500.00 0 010 P-1 1 0.010 247394000-U 834 U.S. BANK MONEY MARKET ACCOUNT 527,923.19 527,923.19 527,923.19 0.010 P-1 1 0.010 236781002-U 837 U.S. BANK MONEY MARKET ACCOUNT 2,930,000.00 2,930,000.00 2,930,000.00 0.010 P-1 1 0.010 236781003-U 838 U.S. BANK MONEY MARKET ACCOUNT 07/01/2020 0.00 0.00 0.00 0.010 P-1 1 0.010 236781000-U 839 U.S. BANK MONEY MARKET ACCOUNT 7,435,098.31 7,435,098.31 7,435,098.31 0.010 P-1 1 0.010 253446003-U 842 U.S. BANK MONEY MARKET ACCOUNT 07/01/2020 0.00 0.00 0.00 0.010 P-1 1 0.010 253446002-U 843 U.S BANK MONEY MARKET ACCOUNT 1,530,000.00 1,530,000.00 1,530,000.00 0.010 P-1 1 0.010 253446000-U 844 U.S. BANK MONEY MARKET ACCOUNT 2,945,715.23 2,945,715.23 2,945,715.23 0.010 P-1 1 0.010 253446001-U 845 U.S. BANK MONEY MARKET ACCOUNT 07/01/2020 1.02 1.02 1.02 0.010 P-1 1 0.010 224324000-U 853 U.S. BANK MONEY MARKET ACCOUNT 4,467,866.94 4,467,866.94 4,467,866.94 0.010 P-1 1 0.010 224324001-U 855 U.S. BANK MONEY MARKET ACCOUNT 07/01/2020 1.96 1.96 1.96 0.010 P-1 1 0.010 224324002-U 856 U.S. BANK MONEY MARKET ACCOUNT 4,390,000.00 4,390,000.00 4,390,000.00 0.010 P-1 1 0.010 224324003-U 857 U.S BANK MONEY MARKET ACCOUNT 07/01/2020 0.00 0.00 0.00 0.010 P-1 1 0.010 236781001-U 881 U.S. BANK MONEY MARKET ACCOUNT 09/01/2020 0.24 0.24 0.24 0.010 P-1 1 0.010 Subtotal and Average 24,434,107.02 24,434,107.02 24,434,107.02 24,434,107.02 1 0.010 TRUSTEE CASH BALANCES - GF 277861000-G 811 GOLDMAN SACHS GOVERNMENT FUND 402,051.74 402,051.74 402,051.74 0 040 Aaa 1 0.040 277861001-G 812 GOLDMAN SACHS GOVERNMENT FUND 0.00 0.00 0.00 0.040 Aaa 1 0.040 277861002-G 813 GOLDMAN SACHS GOVERNMENT FUND 07/01/2020 0.00 0.00 0.00 0.040 Aaa 1 0.040 277861003-G 814 GOLDMAN SACHS GOVERNMENT FUND 07/01/2020 0.00 0.00 0.00 0.040 Aaa 1 0.040 Subtotal and Average 402,051.74 Run Date: 05/17/2021 - 15:14 402,051.74 402,051.74 402,051.74 1 0.040 Portfolio RDAS AP PM (PRF_PM2) 7.3.11 Report Ver 7.3.11 CUSIP Run Date: 05/17/2021 - 15:14 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Investments April 30, 2021 Average Purchase Stated Days to YTM/C Investment # Issuer Balance Date Par Value Market Value Book Value Rate Moodv's Mat./Call 365 Total and Average 26,506,729.71 24,842,963.40 24,842,963.40 24,842,963.40 1 0.011 Page 2 Portfolio RDAS AP PM (PRF_PM2) 7.3.11 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Cash April 30, 2021 Average Purchase Stated Days to YTM/C CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Moodv's Mat./Call 365 UNION BANK CHECKING ACCOUNTS SYS582 582 RDA SUCCESSOR AGENCY 1,662,548.15 1,662,548.15 1,662,548.15 1 0.000 Average Balance 0.00 1 Total Cash and Investments 26,506,729.71 26,505,511.55 26,505,511.55 26,505,511.55 1 0.011 Run Date: 05/17/2021 - 15:14 Page 3 Portfolio RDAS AP PM (PRF_PM2) 7.3.11 PALM DESERT RDA SUCCESSOR AGENCY LONG-TERM LOANS RECEIVABLE APRIL 30, 2021 17-May-21 3:56 PM SymPro Book Stated No. Investment Value Maturity Date Interest Rate 738 EIP Loan * $ 542,000.00 09/02/29 3.00% Footnotes EIP balance adjustments made on March 2 and September 2 of each year.