The URL can be used to link to this page

Home My WebLink About07A Treasurer's Report - March 2021Investments CAMP U.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 Total Earnings Current Year Average Daily Balance Effective Rate of Return Par Value 5,460,849.52 4,612,650.87 74,157,951.78 1,962,963.15 40,000,000.00 59,426,614.72 68,530,068.45 254,151,098.49 5,624,466.31 259,775,564.80 March 31 Month Ending 108,411.58 260,078,095.41 0.49% CITY OF PALM DESERT Portfolio Management Portfolio Summary March 31, 2021 Market Value 5,460,849.52 4,612,650.87 74,157,951,78 1,962,963.15 40,622,400.00 59,426,614.72 68,530,068.45 254,773,498.49 5,624,466.31 260,397,964.80 Fiscal Year To Date 1,121,755.34 256,391,657.24 0.58% Book % of Days to YTM/C Value Portfolio MatJCall Term 385 Equiv. 5,460,849.52 2.15 1 1 0.080 4,612,650.87 1.82 1 1 0.357 74,157,951.78 29.18 1 1 0.357 1,962,963.15 0.77 1 1 0.040 39,983,387.37 15.73 393 930 1.783 59,426,614.72 23.38 1 1 0.040 68,530,068.45 26.97 1 1 0.303 254,134,485.86 100.00% 63 147 0.484 5,624,466.31 259,758,952.17 63 147 0.000 0.484 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. C� 7rd 7rlee,.. OO Janet M. Moore, Director of Finance/City Treasurer Reporting period 03/01/2021-03/31/2021 Run Date: 05/11/2021 - 14:07 5-18-21 CITY COUNCIL ACTION APPROVED �,J DENTED RECEIVED FI I('Cl OTHER MEETING DATE _LP ' I n i .- I AYES: turhI ,TDl1l�i%1G111�,F�S1Zii'Y, lu tan,ici Y ll NOES: _ ABSENT: N°Y e" ABSTAIN: NU/11 VERIFIED BY• MG-1 / s S Original on File with City Clerk's Office Portfolio CITY AP tE (PRF_PM1) 7.3.11 Report Ver. 7.3.11 CITY OF PALM DESERT Portfolio Management Portfolio Details - Investments March 31, 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) 4,730,798.14 4,730,798.14 4,730,798.14 0.080 0.080 1 SYS12444 12444 C.A.M.P. POOL (DESERT WILLOW) 730,051.38 730,051.38 730,051.38 0.080 0.080 1 Subtotal and Average 5,524,985.99 5,460,849.52 5,460,849.52 5,460,849.52 0.080 1 U.S. BANK / LAIF BOND PROCEEDS 252026003 12-33-084 LOCAL AGENCY INVESTMENT FUND 07/01/2020 4,612,650.87 4,612,650.87 4,612,650.87 0.357 0.357 1 Subtotal and Average 4,612,650.87 4,612,650.87 4,612,650.87 4,612,650.87 0.357 1 LAIF 12000 12000 LOCAL AGENCY INVESTMENT FUND 74,157,951.78 74,157,951.78 74,157,951.78 0 357 0 357 1 Subtotal and Average 74,157,951.78 74,157,951.78 74,157,951.78 74,157,951.78 0.357 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.78 930.78 930.78 0.040 Aaa 0.040 1 252026017-G 401 GOLDMAN SACHS GOVERNMENT FUND 362.97 362.97 362.97 0.040 Aaa 0.040 1 252026018-G 402 GOLDMAN SACHS GOVERNMENT FUND 10,403.46 10,403.46 10,403.46 0.040 Aaa 0.040 1 260128000-G 404 GOLDMAN SACHS GOVERNMENT FUND 15,967.08 15,967.08 15,967.08 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.27 0.27 0.27 0.040 Aaa 0.040 1 260128011-G 418 GOLDMAN SACHS GOVERNMENT FUND 160,876.51 160,876.51 160,876.51 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 3.87 3.87 3.87 0.040 Aaa 0.040 1 261470002-G 421 GOLDMAN SACHS GOVERNMENT FUND 1,774,408.31 1,774,408.31 1,774,408.31 0.040 Aaa 0.040 1 Run Date: 05/11/2021 - 14:07 Subtotal and Average 1,980,009.38 1,962,963.15 1,962,963.15 1,962,963.15 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,982,298.76 GOVERNMENT FUND GOVERNMENT FUND GOVERNMENT FUND GOVERNMENT FUND 59,553,627.55 POOLED INVESTMENT FUND Subtotal and Average 66,985,517.65 CUSTODIAN PROJECT FUNDS 6736302420 6736302430 6736302440 6736302450 Run Date: 05/11/2021 - 14:07 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 260,078,095.41 CITY OF PALM DESERT Portfolio Management Portfolio Details - Investments March 31, 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,107,450.00 4,999,297.04 09/25/2019 10,000,000.00 10,214,900.00 9,995,078.05 11/20/2019 5,000,000.00 5,091,900.00 4,997,223.28 09/09/2019 5,000,000.00 5,031,450.00 4,994,964.85 09/27/2019 5,000,000.00 5,140,100.00 4,999,972.99 11/15/2019 5,000,000.00 5,018,400.00 4,997,724.54 11/20/2019 5,000,000.00 5,018,200.00 4,999,126.62 40,000,000.00 40,622,400.00 39,983,387.37 01/01/2021 8,768,329.26 8,768,329.26 8,768,329.26 01/01/2021 20,545,342.55 20,545,342.55 20,545,342.55 01/01/2021 9,788,014.13 9,788,014.13 9,788,014.13 01/01/2021 20,324,928.78 20,324,928.78 20,324,928.78 59,426,614.72 59,426,614.72 59,426,614.72 68,530,068.45 68,530,068.45 68,530,068.45 68,530,068.45 68,530,068.45 68,530,068.45 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,151,098.49 254,773,498.49 254,134,485.86 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 528 09/11/2022 1.735 528 09/11/2022 1.690 518 09/01/2022 1.935 161 09/09/2021 2.045 649 01/10/2023 1 815 102 07/12/2021 1.600 129 08/08/2021 1.783 393 0 040 1 0.040 1 0.040 1 0.040 1 0.040 1 0.303 Aaa 0.303 1 0.010 Aaa 0.010 Aaa 0.010 Aaa 0.010 Aaa 0.303 1 0.010 0.010 0.010 0.010 0.000 0 0.484 63 Portfolio CITY AP PM (PRF_PM2) 7.3.11 CITY OF PALM DESERT Portfolio Management Portfolio Details - Cash March 31, 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 3,136,274.05 3,136,274.05 3,136,274.05 0.000 1 SYS13013 13013 DESERT WILLOW GOLF COURSE 07/01/2020 1,789,154.39 1,789,154.39 1,789,154.39 0.000 1 SYS602 602 PUBLIC SAFETY CHECKING 07/01/2020 36,097.65 36,097.65 36,097.65 0.000 1 SYS13020 13020 RECREATIONAL FACILITIES CORP 07/01/2020 662,940.22 662,940.22 662,940.22 0 000 1 Average Balance 0.00 1 Total Cash and Investments 260,078,095.41 259,775,564.80 260,397,964.80 259,758,952.17 0.484 63 Run Date: 05/11/2021 - 14:07 Page 3 Portfolio CITY AP PM (PRF_PM2) 7.3.11 CITY OF PALM DESERT Activity Report Sorted By Issuer March 1, 2021 - March 31, 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.774% 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 340.47 2,000,000.00 Subtotal and Balance 6,730,457.67 340.47 2,000,000.00 4,730,798.14 Issuer Subtotal 1.821% 6,730,457.67 340.47 2,000,000.00 4,730,798.14 Issuer: C.A.M.P. POOL (DESERT WILLOW) CAMP SYS12444 12444 C.A.M.P. POOL (DESERT WILLOW) 0.060 51.84 0.00 Subtotal and Balance 729,999.54 51.84 0.00 730,051.38 Issuer Subtotal 0.281% 729,999.54 51.84 0.00 730,051.38 Issuer: POOLED INVESTMENT FUND RIVERSIDE COUNTY POOL 052460 052460 POOLED INVESTMENT FUND 0.283 2,642,567.17 0.00 Subtotal and Balance 65,887,501.28 2,642,567.17 0.00 68,530,068.45 Issuer Subtotal 26.380% 65,887,501.28 2,642,567.17 0.00 68,530,068.45 Issuer: WALT DISNEY COMPANY MEDIUM -TERM NOTES Subtotal and Balance Issuer Subtotal 1.925% Run Date: 05/14/2021 - 15:12 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 CITY OF PALM DESERT Activity Report March 1, 2021 - March 31, 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: GOLDMAN SACHS GOVERNMENT FUND TRUSTEE CASH BALANCES 252026001-G 383 GOLDMAN SACHS GOVERNMENT FUND 0.040 2.79 704,812.50 252026004-G 386 GOLDMAN SACHS GOVERNMENT FUND 0.040 0.02 0.00 252026017-G 401 GOLDMAN SACHS GOVERNMENT FUND 0.040 0.01 0.00 252026018-G 402 GOLDMAN SACHS GOVERNMENT FUND 0.040 0.24 0.00 260128000-G 404 GOLDMAN SACHS GOVERNMENT FUND 0.040 0.38 0.00 260128010-G 417 GOLDMAN SACHS GOVERNMENT FUND 0.040 0.27 26,671.89 260128011-G 418 GOLDMAN SACHS GOVERNMENT FUND 0.040 3.71 0.00 261470001-G 420 GOLDMAN SACHS GOVERNMENT FUND 0.040 3.87 501,761.25 261470002-G 421 GOLDMAN SACHS GOVERNMENT FUND 0.040 40.87 0.00 Subtotal and Balance 3,196,156.63 52.16 1,233,245.64 1,962,963.15 CUSTODIAN PROJECT FUNDS 6736302420-G 647 GOLDMAN SACHS GOVERNMENT FUND 0.040 208.83 290,649.82 6736302430-G 648 GOLDMAN SACHS GOVERNMENT FUND 0.040 482.71 301,335.70 6736302440-G 649 GOLDMAN SACHS GOVERNMENT FUND 0.040 225.48 125.00 6736302450-G 650 GOLDMAN SACHS GOVERNMENT FUND 0.040 468.11 125.00 Subtotal and Balance 60,017,465.11 1,385.13 592,235.52 59,426,614.72 Issuer Subtotal 23.632% 63,213,621.74 1,437.29 1,825,481.16 61,389,577.87 Issuer: GOLDMAN SACHS TREASURY FUND CUSTODIAN PROJECT FUNDS Subtotal and Balance 0.00 0.00 Issuer Subtotal 0.000% 0.00 0.00 0.00 0.00 Issuer: AMERICAN HONDA FINANCE MEDIUM -TERM NOTES Subtotal and Balance 15,000,000.00 15,000,000.00 Issuer Subtotal 5.774% 15,000,000.00 0.00 0.00 15,000,000.00 Issuer: LOCAL AGENCY INVESTMENT FUND U.S. BANK / LAIF BOND PROCEEDS Subtotal and Balance 4,612,650.87 4,612,650.87 Run Date: 05/14/2021 - 15:12 Page 2 Portfolio CITY CP DA (PRF_DA) 7 3 11 Report Ver 7 3 11 CITY OF PALM DESERT Activity Report March 1, 2021 - March 31, 2021 Page 3 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 Subtotal and Balance 74,157,951.78 74,157,951.78 Issuer Subtotal 30.323% 78,770,602.65 0.00 0.00 78,770,602,65 Issuer: MICROSOFT CORPORATION MEDIUM -TERM NOTES Subtotal and Balance 5,000,000.00 5,000,000,00 Issuer Subtotal 1.925% 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 Subtotal and Balance Issuer Subtotal 1.207% Issuer: DESERT WILLOW GOLF COURSE UNION BANK CHECKING ACCOUNTS SYS13013 13013 DESERT WILLOW GOLF COURSE Subtotal and Balance Issuer Subtotal 0.689% Issuer: PUBLIC SAFETY CHECKING UNION BANK CHECKING ACCOUNTS SYS602 602 PUBLIC SAFETY CHECKING Subtotal and Balance Issuer Subtotal 0.014% Run Date: 05/14/2021 - 15:12 5,000,508.18 5,000,508.18 1,307,846.69 1,307,846.69 519,992.65 519,992.65 9,620,573.22 11,484,807.35 9,620,573.22 11,484,807.35 9,620,573.22 11,484,807.35 1,708,607.51 1,708,607.51 1,708,607.51 1, 227, 299.81 1,227,299.81 1,227,299.81 216,158.58 700,053.58 216,158.58 700,053.58 216,158.58 700,053.58 3,136,274.05 3,136,274.05 1,789,154.39 1,789,154.39 36,097.65 36,097.65 Portfolio CITY CP DA (PRF_DA) 7 3 11 Report Ver 7 3 11 CITY OF PALM DESERT Activity Report March 1, 2021 - March 31, 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 422,418.24 267,403.49 Subtotal and Balance 507,925.47 422,418.24 267,403.49 662,940.22 Issuer Subtotal 0.255% 507,925.47 422,418.24 267,403.49 662,940.22 Total 100.000% 262,668,455.87 14,612,154.32 17,505,045.39 259,775,564.80 Run Date: 05/14/2021 - 15:12 Page 4 Portfolio CITY CP DA (PRF_DA) 7 3 11 Report Ver 7 3 11 CITY OF PALM DESERT LONG-TERM LOANS RECEIVABLE MARCH 31, 2021 29-Apr-21 5:23 PM SymPro Book Stated No. Investment Value Maturity Date Interest Rate 1 City Loan to RDA* $ 10,575,462.50 N/A 0.36% 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 March 31, 2021 Par Market Book % of Days to YTMIC Investments Value Value Value Portfolio Mat./Call Term 365 Equiv. CAMP 48,815,665.13 48,815,665.13 48,815,665.13 89.20 1 1 0.080 LAIF 969,592.42 969, 592.42 969, 592.42 1.77 1 1 0.357 CUSTODIAN PROJECT FUNDS 4,938,591.28 4,938,591.28 4,938,591.28 9.02 1 1 0.040 54,723,848.83 54,723,848.83 54,723,848.83 100.00% 1 1 0.081 Investments Cash Passbook/Checking 4,649,761.12 4, 649, 761.12 4,649, 761.12 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,373,609.95 59,373,609.95 March 31 Month Ending 3,778.33 59,282, 004.39 0.08% Fiscal Year To Date 60,893.98 59,373,609.95 1 1 0.081 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. 2,244J-7/2.5-18-21 Janet M. Moore, Director of Finance/City Treasurer Reporting period 03/01/2021-03/31/2021 Run Date: 04/2012021 - 12:36 Portfolio HA AP IE (PRF_PM1) 7.3-11 Report Ver. 7.3.11 PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Details - Investments March 31, 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,815,665.13 48,815,665.13 48,815,665.13 0.080 1 0.080 Subtotal and Average 48,812,310.62 48,815,665.13 48,815,665.13 48,815,665.13 1 0.080 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 969,592.42 969,592.42 969,592.42 0.357 1 0.357 Subtotal and Average 969,592.42 969,592.42 969,592.42 969,592.42 1 0.357 CUSTODIAN PROJECT FUNDS 6736302460-G 597 GOLDMAN SACHS GOVERNMENT FUND 01/01/2021 4,938,591.28 4,938,591.28 4,938,591.28 0.040 Aaa 1 0.040 Subtotal and Average 4,938,591.28 4,938,591.28 4,938,591.28 4,938,591.28 1 0.040 Total and Average 59,282,004.39 54,723,848.83 54,723,848.83 54,723,848.83 1 0.081 Run Date: 04/20/2021 - 12:36 Portfolio HA AP PM (PRF_PM2) 7.3.11 Report Ver 7.3.11 PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Details - Cash March 31, 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,181,791.62 4,181,791.62 4,181,791.62 1 0.000 SYS25016 25016 HOUSING AUTH TRUST 07/01/2020 467,969.50 467,969.50 467,969.50 1 0.000 Run Date: 04/20/2021 - 12:36 Average Balance 0.00 1 Total Cash and Investments 59,282,004.39 59,373,609.95 59,373,609.95 59,373,609.95 1 0.081 Page 2 Portfolio HA AP PM (PRF_PM2) 7.3.11 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Summary March 31, 2021 Par Market Book % of Days to YTMIC Investments Value Value Value Portfolio Mat./Call Term 365 Equiv. RIVERSIDE COUNTY POOL 335.61 335.61 335.61 0.00 1 1 0.303 CAMP 5,727.30 5,727.30 5,727.30 0.02 1 1 0.080 LAIF 740.64 740.64 740.64 0.00 1 1 0.357 TRUSTEE CASH BALANCES - MMA 27,931,235.30 27,931,235.30 27,931,235.30 98.56 1 1 0.010 TRUSTEE CASH BALANCES - GF 402,039.41 402,039.41 402,039.41 1.42 1 1 0.040 28,340,078.26 28,340,078.26 28,340,078.26 100.00% 1 1 0.010 Investments Cash Passbook/Checking 1,663,808.98 1,663,808.98 1,663, 808.98 1 1 0.000 (not included in yield calculations) Total Cash and Investments Total Earnings Current Year Average Daily Balance Effective Rate of Return 30,003,887.24 30,003,887.24 March 31 Month Ending 251.59 30,027,044.73 0.01% Fiscal Year To Date 1,159.76 30,003,887.24 1 1 0.010 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 03/01/2021-03/31/2021 Run Date: 04/2012021 - 12:40 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 March 31, 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.61 335.61 Subtotal and Average 335.46 335.61 335.61 335.61 0.303 Aaa 1 0.303 335.61 1 0.303 CAMP SYS578 578 C.A.M.P. POOL (RDA S.A.) 5,727.30 5,727.30 5,727.30 0.080 1 0.080 Subtotal and Average 5,726.90 5,727.30 5,727.30 5,727.30 1 0.080 LAIF SYS604 604 L.A.I.F. (RDA S.A.) 07/01/2020 740.64 740.64 740.64 0.357 1 0.357 Subtotal and Average 740.64 740.64 740.64 740.64 1 0.357 TRUSTEE CASH BALANCES - MMA 247394001-U 830 U.S. BANK MONEY MARKET ACCOUNT 07/01/2020 134,884.38 134,884.38 134,884.38 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 0.81 0.81 0.81 0.010 P-1 1 0.010 247394000-U 834 U.S. BANK MONEY MARKET ACCOUNT 735,418.81 735,418.81 735,418.81 0.010 P-1 1 0.010 236781002-U 837 U.S. BANK MONEY MARKET ACCOUNT 11.75 11.75 11.75 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 10,365,041.71 10,365,041.71 10,365,041.71 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 5.89 5.89 5.89 0.010 P-1 1 0.010 253446000-U 844 U.S. BANK MONEY MARKET ACCOUNT 4,475,686.83 4,475,686.83 4,475,686.83 0.010 P-1 1 0.010 253446001-U 845 U.S. BANK MONEY MARKET ACCOUNT 07/01/2020 1,066,500.00 1,066,500.00 1,066,500.00 0.010 P-1 1 0.010 224324000-U 853 U.S. BANK MONEY MARKET ACCOUNT 8,857,805.55 8,857,805.55 8,857,805.55 0.010 P-1 1 0.010 224324001-U 855 U.S. BANK MONEY MARKET ACCOUNT 07/01/2020 2,043,318.76 2,043,318.76 2,043,318.76 0.010 P-1 1 0.010 224324002-U 856 U.S. BANK MONEY MARKET ACCOUNT 17.06 17.06 17.06 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 252,543.75 252,543.75 252,543.75 0.010 P-1 1 0.010 Subtotal and Average 27,931,235.30 27,931,235.30 27,931,235.30 27,931,235.30 1 0.010 TRUSTEE CASH BALANCES - GF 277861000-G 811 GOLDMAN SACHS GOVERNMENT FUND 402,039.41 402,039.41 402,039.41 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,039.41 Run Date: 04/20/2021 - 12:40 402, 0 39.41 402,039.41 402, 0 39.41 1 0.040 Portfolio RDAS AP PM (PRF_PM2) 7.3.11 Report Ver 7.3.11 CUSIP Run Date: 04/20/2021 - 12:40 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Investments March 31, 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 30,027,044.73 28,340,078.26 28,340,078.26 28,340,078.26 1 0.010 Page 2 Portfolio RDAS AP PM (PRF_PM2) 7.3.11 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Cash March 31, 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,663,808.98 1,663,808.98 1,663,808.98 1 0.000 Average Balance 0.00 1 Total Cash and Investments 30,027,044.73 30,003,887.24 30,003,887.24 30,003,887.24 1 0.010 Run Date: 04/20/2021 - 12:40 Page 3 Portfolio RDAS AP PM (PRF_PM2) 7.3.11 PALM DESERT RDA SUCCESSOR AGENCY LONG-TERM LOANS RECEIVABLE MARCH 31, 2021 29-Apr-21 5:25 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.