The URL can be used to link to this page

Home My WebLink About06 Compliance and Investment Reports - September and October 2021Investments CAMP U.S. BANK / LAIF BOND PROCEEDS FEDERAL AGENCY - COUPON LAIF FEDERAL AGENCY - CALLABLE TRUSTEE CASH BALANCES MEDIUM -TERM NOTES CUSTODIAN PROJECT FUNDS RIVERSIDE COUNTY POOL Investments Cash and Accrued Interest Passbook/Checking (not included in yield calculations) Accrued Interest at Purchase Subtotal Total Cash and Investments Total Earnings Current Year Average Daily Balance Effective Rate of Return Par Value 10,763,040.93 3,770.21 3,000,000.00 65,499,582.51 8,090,000.00 4,983,303.53 37,090,000.00 54,289,238.75 79,424,092.81 262,963,028.74 7,538,411.17 270,501,439.91 September 30 Month Ending 79,479.98 274,304,334.81 0.35% CITY OF PALM DESERT Portfolio Management Portfolio Summary September 30, 2021 Market Value 10,763,040.93 3,770.21 2,992,650.00 65,499,582.51 7,952,250.00 4,983,303.53 37,326,790.00 54,289,238.75 79,424,092.81 263,234,718.74 7,538,411.17 10,529.16 7,548,940.33 270,783,659.07 APl"Kl1 V Eli RECEIVED ck leCil MEETING DATE 12, it AYES:lbw-1 4mY1i I<ei NOES• Nt►'1 ABSENT: None ABSTAIN: NDY\ VERIFIED BY• r)I w" I crs Book Origittai on Fi1w With City Clerk's Oi'fit e Value Portfolio MatiCail Term 365 Equiv. 10,763,040.93 3,770.21 2,999,574.23 65,499,582.51 7,967,968.62 4,983,303.53 36,990,052.94 54,289,238.75 79,424,092.81 262,920,624.53 7,538,411.17 10,529.16 7,548,940.33 270,469,564.86 4.09 1 0.00 1 1.14 119 24.91 1 3.03 848 1.90 1 14.07 493 20.65 1 30.21 1 ilia' 1 r. V OTHER (1'4e,5-tzinel (ka imam Ih +4<6"hiIt_ 1 1 1,188 1 1,158 1 1,081 0.050 0.206 0.530 0.206 0.475 0.030 1.367 0.010 0.279 100.00% 97 202 0.353 1 0.000 97 202 0.353 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. 9axat9st 7llesu (/JJanet M. Moore, Director of Finance/City Treasurer Reporting period 09/01/2021-09/30/2021 Run Date: 10/29/2021 - 13:56 No fiscal year history available Received 4 - t le (;1 BY SA -RDA ON l _ 1L' 2-°2-1 VERIFIED BY: N i P Original on file with City Clerk's Office Portfolio CITY AP IE (PRF_PMI) 7.3.11 Report Ver. 7.3.11 CITY OF PALM DESERT Portfolio Management Portfolio Details - Investments September 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) 10,032,798.95 10,032,798 95 10,032,798 95 0 050 0.050 1 SYS12444 12444 C A M P POOL (DESERT WILLOW) 730,241.98 730,241 98 730,241 98 0 050 0.050 1 Subtotal and Average 10,762,607.61 10,763,040.93 10,763,040.93 10,763,040.93 0.050 1 U.S. BANK / LAIF BOND PROCEEDS 252026003 12-33-084 LOCAL AGENCY INVESTMENT FUND 07/01/2020 3,770.21 3,770 21 3,770 21 0 206 0.206 1 Subtotal and Average 3,770.21 3,770.21 3,770.21 3,770.21 0.206 1 FEDERAL AGENCY - COUPON 3130ANAC4 664 FEDERAL HOME LOAN BANK 07/28/2021 3,000,000.00 2,992,650.00 2,999,574.23 0.500 Aaa 0.530 119 10/28/2024 Subtotal and Average 2,999,568.65 3,000,000.00 2,992,650.00 2,999,574.23 0.530 119 LAIF 12000 12000 LOCAL AGENCY INVESTMENT FUND 65,499,582.51 65,499,582 51 65,499,582 51 0 206 0.206 1 Subtotal and Average 65,499,582.51 65,499,582.51 65,499,582.51 65,499,582.51 0.206 1 FEDERAL AGENCY - CALLABLE 3133EMLP5 668 FEDERAL FARM CREDIT BANK 09/14/2021 5,000,000.00 4,953,300 00 4,967,968 62 0 320 Aaa 0.520 1,179 12/23/2024 3130AN7K0 660 FEDERAL HOME LOAN BANK 07/29/2021 3,000,000.00 2,998,950 00 3,000,000 00 0 400 Aaa 0.400 301 07/29/2024 Subtotal and Average 5,815,057.25 8,000,000.00 7,952,250.00 7,967,968.62 0.475 848 TRUSTEE CASH BALANCES 252026000-G 382 GOLDMAN SACHS GOVERNMENT FUND 0.00 0 00 0 00 0 030 Aaa 0.030 1 252026001-G 383 GOLDMAN SACHS GOVERNMENT FUND 0.00 0 00 0 00 0 030 Aaa 0.030 1 252026002-G 384 GOLDMAN SACHS GOVERNMENT FUND 0.00 0.00 0.00 0.030 Aaa 0.030 1 252026003-G 385 GOLDMAN SACHS GOVERNMENT FUND 27.18 27 18 27 18 0 030 Aaa 0.030 1 252026004-G 386 GOLDMAN SACHS GOVERNMENT FUND 950.10 950 10 950 10 0 030 Aaa 0.030 1 252026017-G 401 GOLDMAN SACHS GOVERNMENT FUND 0.01 0.01 0.01 0.030 Aaa 0.030 1 252026018-G 402 GOLDMAN SACHS GOVERNMENT FUND 0.20 0 20 0 20 0 030 Aaa 0.030 1 260128000-G 404 GOLDMAN SACHS GOVERNMENT FUND 15,969.41 15,969 41 15,969 41 0 030 Aaa 0.030 1 260128001-G 405 GOLDMAN SACHS GOVERNMENT FUND 07/01/2020 0.00 0.00 0.00 0.030 Aaa 0.030 1 260128002-G 407 GOLDMAN SACHS GOVERNMENT FUND 07/01/2020 0.00 0 00 0 00 0 030 Aaa 0.030 1 260128003-G 408 GOLDMAN SACHS GOVERNMENT FUND 07/01/2020 0.00 0 00 0 00 0 030 Aaa 0.030 1 260128004-G 409 GOLDMAN SACHS GOVERNMENT FUND 07/01/2020 0.00 0.00 0.00 0.030 Aaa 0.030 1 260128005-G 410 GOLDMAN SACHS GOVERNMENT FUND 0.00 0 00 0 00 0 030 Aaa 0.030 1 Run Date 10/29/2021 - 13 56 Portfolio CITY AP PM (PRF_PM2) 7 3 11 Report Ver 7 3 11 CUSIP Investment # TRUSTEE CASH BALANCES Issuer Average Balance CITY OF PALM DESERT Portfolio Management Portfolio Details - Investments September 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 260128006-G 412 GOLDMAN SACHS GOVERNMENT FUND 0.00 0 00 0 00 0 030 Aaa 0.030 1 260128007-G 414 GOLDMAN SACHS GOVERNMENT FUND 0.00 0 00 0 00 0 030 Aaa 0.030 1 260128008-G 415 GOLDMAN SACHS GOVERNMENT FUND 0.00 0.00 0.00 0.030 Aaa 0.030 1 260128009-G 416 GOLDMAN SACHS GOVERNMENT FUND 07/01/2020 2.08 2 08 2 08 0 030 Aaa 0.030 1 260128010-G 417 GOLDMAN SACHS GOVERNMENT FUND 0.63 0 63 0 63 0 030 Aaa 0.030 1 260128011-G 418 GOLDMAN SACHS GOVERNMENT FUND 160,900.07 160,900.07 160,900.07 0.030 Aaa 0.030 1 261470000-G 419 GOLDMAN SACHS GOVERNMENT FUND 0.00 0 00 0 00 0 030 Aaa 0.030 1 261470001-G 420 GOLDMAN SACHS GOVERNMENT FUND 0.00 0 00 0 00 0 030 Aaa 0.030 1 261470002-G 421 GOLDMAN SACHS GOVERNMENT FUND 54.56 54.56 54.56 0.030 Aaa 0.030 1 263346000-G 671 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 0.00 0 00 0 00 0 030 Aaa 0.030 1 263346001-G 672 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 0.00 0 00 0 00 0 030 Aaa 0.030 1 263346002-G 673 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 0.12 0.12 0.12 0.030 Aaa 0.030 1 263346003-G 674 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 874,204.07 874,204 07 874,204 07 0 030 Aaa 0.030 1 263346004-G 675 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 0.00 0 00 0 00 0 030 Aaa 0.030 1 263346005-G 676 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 0.00 0.00 0.00 0.030 Aaa 0.030 1 263346006-G 677 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 29,136.68 29,136 68 29,136 68 0 030 Aaa 0.030 1 263346007-G 678 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 1,974,662.41 1,974,662 41 1,974,662 41 0 030 Aaa 0.030 1 263599000-G 679 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 0.00 0.00 0.00 0.030 Aaa 0.030 1 263599001-G 680 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 0.00 0 00 0 00 0 030 Aaa 0.030 1 263599002-G 682 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 1,416,809.51 1,416,809 51 1,416,809 51 0 030 Aaa 0.030 1 263599003-G 683 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 22,749.64 22,749.64 22,749.64 0.030 Aaa 0.030 1 269048000-G 684 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 0.00 0 00 0 00 0 030 Aaa 0.030 1 271146000-G 685 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 0.00 0 00 0 00 0 030 Aaa 0 030 1 271146001-G 687 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 0.00 0.00 0.00 0.030 Aaa 0.030 1 271146002-G 688 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 0.00 0 00 0 00 0 030 Aaa 0.030 1 271146003-G 689 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 468,402.25 468,402 25 468,402 25 0 030 Aaa 0 030 1 271146004-G 690 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 0.00 0.00 0.00 0.030 Aaa 0.030 1 271146005-G 691 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 0.00 0 00 0 00 0 030 Aaa 0.030 1 271146006-G 692 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 19,434.61 19,434 61 19,434 61 0 030 Aaa 0 030 1 277580000-G 693 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 0.00 0.00 0.00 0.030 Aaa 0.030 1 Subtotal and Average 4,983,303.54 4,983,303.53 4,983,303.53 4,983,303.53 0.030 1 MEDIUM -TERM NOTES 037833DL1 614 APPLE, INC. 09/11/2019 5,000,000.00 5,067,850 00 4,999,540 37 1 700 Aa 1.710 037833DL1 616 APPLE, INC. 09/25/2019 10,000,000.00 10,135,700.00 9,996,781.80 1.700 Aa 1.735 023135BW5 662 AMAZON.COM INC 07/19/2021 3,000,000.00 2,993,940 00 3,000,000 00 0 450 A 0.450 Run Date 10/29/2021 - 13 56 345 09/11/2022 345 09/11/2022 42 05/12/2024 Portfolio CITY AP PM (PRF_PM2) 7 3 11 CITY OF PALM DESERT Portfolio Management Portfolio Details - Investments September 30, 2021 Page 3 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 MEDIUM -TERM NOTES 254687FJ0 625 WALT DISNEY COMPANY 11/20/2019 5,000,000.00 5,065,650 00 4,998,203 30 1 650 A 1.690 335 09/01/2022 02665WDC2 617 AMERICAN HONDA FINANCE 09/27/2019 5,000,000.00 5,107,300 00 4,999,980 60 2 050 A 2.045 466 01/10/2023 89236TJH9 658 TOYOTA MOTOR CREDIT CORP 06/18/2021 3,000,000.00 2,985,450.00 3,000,000.00 0.500 A 0.500 991 06/18/2024 89236TJH9 659 TOYOTA MOTOR CREDIT CORP 07/08/2021 3,000,000.00 2,985,450 00 2,997,566 72 0 500 A 0.530 991 06/18/2024 89236TJH9 667 TOYOTA MOTOR CREDIT CORP 09/14/2021 3,000,000.00 2,985,450 00 2,997,980 15 0 500 A 0.525 991 06/18/2024 Subtotal and Average 37,023,949.90 37,000,000.00 37,326,790.00 36,990,052.94 1.367 493 CUSTODIAN PROJECT FUNDS 6736302420-G 647 FIRST AMERICAN US TREASURY MMF 01/01/2021 6,081,922.49 6,081,922 49 6,081,922 49 0 010 Aaa 0.010 1 6736302430-G 648 FIRST AMERICAN US TREASURY MMF 01/01/2021 18,090,644.54 18,090,644 54 18,090,644 54 0 010 Aaa 0.010 1 6736302440-G 649 FIRST AMERICAN US TREASURY MMF 01/01/2021 9,789,182.61 9,789,182.61 9,789,182.61 0.010 Aaa 0.010 1 6736302450-G 650 FIRST AMERICAN US TREASURY MMF 01/01/2021 20,327,489.11 20,327,489 11 20,327,489 11 0 010 Aaa 0.010 1 Subtotal and Average 54,618,586.09 54,289,238.75 54,289,238.75 54,289,238.75 0.010 1 RIVERSIDE COUNTY POOL 052460 052460 POOLED INVESTMENT FUND 79,424,092.81 79,424,092.81 79,424,092.81 0.279 Aaa 0.279 1 Subtotal and Average 79,402,464.27 79,424,092.81 79,424,092.81 79,424,092.81 0.279 1 CUSTODIAN PROJECT FUNDS 6736302420 498 GOLDMAN SACHS TREASURY FUND 0.00 0 00 0 00 0 010 Aaa 0.010 1 6736302430 499 GOLDMAN SACHS TREASURY FUND 0.00 0.00 0.00 0.010 Aaa 0.010 1 6736302440 500 GOLDMAN SACHS TREASURY FUND 0.00 0 00 0 00 0 010 Aaa 0.010 1 6736302450 501 GOLDMAN SACHS TREASURY FUND 0.00 0 00 0 00 0 010 Aaa 0.010 1 Run Date 10/29/2021 - 13 56 Subtotal and Average 0.00 0.00 0.00 0.00 0.000 0 Total and Average 274,304,334.81 262,963,028.74 263,234,718.74 262,920,624.53 0.353 97 Portfolio CITY AP PM (PRF_PM2) 7 3 11 CUSIP CITY OF PALM DESERT Portfolio Management Portfolio Details - Cash September 30, 2021 Average Purchase Stated YTM/C Days to 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,171,161.64 4,171,161.64 4,171,161.64 0.000 1 SYS13013 13013 DESERT WILLOW GOLF COURSE 07/01/2020 1,086,975.90 1,086,975 90 1,086,975 90 0.000 1 SYS602 602 PUBLIC SAFETY CHECKING 07/01/2020 1,179,667.56 1,179,667 56 1,179,667 56 0.000 1 SYS13020 13020 RECREATIONAL FACILITIES CORP 07/01/2020 1,100,606.07 1,100,606.07 1,100,606.07 0.000 1 Run Date 10/29/2021 - 13 56 Average Balance 0.00 Accrued Interest at Purchase 10,529 16 10,529 16 1 Subtotal 7,548,940 33 7,548,940 33 Total Cash and Investments 274,304,334.81 270,501,439.91 270,783,659.07 270,469,564.86 0.353 97 Page 4 Portfolio CITY AP PM (PRF_PM2) 7 3 11 10-Nov-21 4:11 PM * CITY OF PALM DESERT LONG-TERM LOANS RECEIVABLE September 30, 2021 SymPro Book Stated No. Investment Value Maturity Date Interest Rate 1 City Loan to RDA* $ 7,512,000.00 N/A 0.22% 348 EIP Loan ** $ 1,159,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 September 30, 2021 Par Market Book % of Days to YTM/C Investments Value Value Value Portfolio Mat./Call Term 365 Equiv. CAMP 48,828,410 03 48,828,410 03 48,828,410 03 89 20 1 1 0.050 LAIF 971,444 20 971,444 20 971,444 20 1 77 1 1 0.206 CUSTODIAN PROJECT FUNDS 4,939,243 51 4,939,243 51 4,939,243 51 9 02 1 1 0.010 Investments Cash Passbook/Checking (not included in yield calculations) Total Cash and Investments Total Earnings Current Year Average Daily Balance Effective Rate of Return 54,739,097.74 54,739,097.74 54,739,097.74 100.00% 1 1 0.049 3,661,297 28 3,661,297 28 58,400,395.02 58,400,395.02 September 30 Month Ending 2,240.09 58,264,448.59 0.05% 3,661,297 28 1 1 0.000 58,400,395.02 1 1 0.049 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. 5tutatle.. Nes .a. Janet M. Moore, Director of Finance/City Treasurer Reporting period 09/01/2021-09/30/2021 Run Date' 10/29/2021 - 14'05 No fiscal year history available Portfolio HA AP IE (PRF_PM1) 7 3 11 Report Ver 7 3 11 PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Details - Investments September 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,828,410.03 48,828,410 03 48,828,410 03 0 050 1 0 050 Subtotal and Average 48,826,444.19 48,828,410.03 48,828,410.03 48,828,410.03 1 0.050 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 971,444.20 971,444 20 971,444 20 0 206 1 0 206 Subtotal and Average 971,444.20 971,444.20 971,444.20 971,444.20 1 0.206 CUSTODIAN PROJECT FUNDS 6736302460-G 597 FIRST AMERICAN US TREASURY MMF 01/01/2021 4,939,243.51 4,939,243 51 4,939,243 51 0 010 Aaa 1 0 010 Subtotal and Average 4,939,243.51 4,939,243.51 4,939,243.51 4,939,243.51 1 0.010 Total and Average 58,264,448.59 54,739,097.74 54,739,097.74 54,739,097.74 1 0.049 Run Date 10/29/2021 - 14 05 Portfolio HA AP PM (PRF_PM2) 7 3 11 Report Ver 7 3 11 PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Details - Cash September 30, 2021 Average Purchase Stated Days to YTM/C CUSIP Investment # Issuer Ralanco Date Par Value Market Value Book Value Rare Moodv's Mat./Call 365 CHECKING SYS25015 25015 HOUSING AUTH CHECKING 3,201,041.78 3,201,041 78 3,201,041 78 1 0 000 SYS25016 25016 HOUSING AUTH TRUST 07/01/2020 460,255.50 460,255 50 460,255 50 1 0 000 Run Date 10/29/2021 - 14 05 Average Balance 0.00 1 Total Cash and Investments 58,264,448.59 58,400,395.02 58,400,395.02 58,400,395.02 1 0.049 Page 2 Portfolio HA AP PM (PRF_PM2) 7 3 11 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Summary September 30, 2021 Par Market Book % of Days to YTM/C Investments Value Value Value Portfolio Mat./Call Term 365 Equiv. RIVERSIDE COUNTY POOL 336 08 336 08 336 08 0 00 1 1 0.279 CAMP 5,728 80 5,728 80 5,728 80 0 02 1 1 0.050 LAIF 742 06 742 06 742 06 0 00 1 1 0.206 TRUSTEE CASH BALANCES - MMA 36,993,925 03 36,993,925 03 36,993,925 03 98 91 1 1 0.010 TRUSTEE CASH BALANCES - GF 402,111 73 402,111 73 402,111 73 1 08 1 1 0.030 Investments Cash Passbook/Checking (not included in yield calculations) Total Cash and Investments Total Earnings Current Year Average Daily Balance Effective Rate of Return 37,402,843.70 37,402,843.70 37,402,843.70 100.00% 1 1 0.010 1,611,140 33 1,611,140 33 1,611,140 33 1 1 0.000 39,013,984.03 39,013,984.03 39,013,984.03 1 1 0.010 September 30 Month Ending 336.90 41,433,205.16 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. Janet M. Moore, Finance Officer Reporting period 09/01/2021-09/30/2021 Run Date' 10/29/2021 - 14'14 No fiscal year history available Portfolio RDAS AP IE (PRF_PM1) 7 3 11 Report Ver 7 3 11 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Investments September 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 RIVERSIDE COUNTY POOL 052470 052470 POOLED INVESTMENT FUND 07/01/2020 336.08 336 08 336 08 0 279 Aaa 1 0 279 Subtotal and Average 335.98 336.08 336.08 336.08 1 0.279 CAMP SYS578 578 C.A.M.P. POOL (RDA S.A.) 5,728.80 5,728.80 5,728.80 0.050 1 0.050 Subtotal and Average 5,728.57 5,728.80 5,728.80 5,728.80 1 0.050 LAIF SYS604 604 L A.I F (RDA S A) 07/01/2020 742.06 742 06 742 06 0 206 1 0 206 Subtotal and Average 742.06 742.06 742.06 742.06 1 0.206 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 415,000.00 415,000.00 415,000.00 0.010 P-1 1 0.010 247394000-U 834 U S BANK MONEY MARKET ACCOUNT 527,942.58 527,942 58 527,942 58 0 010 P-1 1 0 010 236781002-U 837 U S BANK MONEY MARKET ACCOUNT 5,860,000.00 5,860,000 00 5,860,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,351.53 7,435,351 53 7,435,351 53 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 3,060,000.00 3,060,000.00 3,060,000.00 0.010 P-1 1 0.010 253446000-U 844 U S BANK MONEY MARKET ACCOUNT 2,950,257.23 2,950,257 23 2,950,257 23 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 4,468,126.81 4,468,126.81 4,468,126.81 0.010 P-1 1 0.010 224324001-U 855 U S BANK MONEY MARKET ACCOUNT 07/01/2020 2,043,318.75 2,043,318 75 2,043,318 75 0 010 P-1 1 0 010 224324002-U 856 U S BANK MONEY MARKET ACCOUNT 8,780,000.00 8,780,000 00 8,780,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 252,543.75 252,543 75 252,543 75 0 010 P-1 1 0 010 Subtotal and Average 39,728,534.39 36,993,925.03 36,993,925.03 36,993,925.03 1 0.010 TRUSTEE CASH BALANCES - GF 277861000-G 811 GOLDMAN SACHS GOVERNMENT FUND 402,111.73 402,111.73 402,111.73 0.030 Aaa 1 0.030 277861001-G 812 GOLDMAN SACHS GOVERNMENT FUND 0.00 0 00 0 00 0 030 Aaa 1 0 030 277861002-G 813 GOLDMAN SACHS GOVERNMENT FUND 07/01/2020 0.00 0 00 0 00 0 030 Aaa 1 0 030 277861003-G 814 GOLDMAN SACHS GOVERNMENT FUND 07/01/2020 0.00 0.00 0.00 0.030 Aaa 1 0.030 Run Date 10/29/2021 - 14 14 Portfolio RDAS AP PM (PRF_PM2) 7 3 11 Report Ver 7 3 11 CUSIP Run Date 10/29/2021 - 14 14 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Investments September 30, 2021 Average Purchase Stated Days to YTM/C Investment # Issuer Ralance Date Par Value Market Value Book Value Rare Moodv's Mat./Call 365 Subtotal and Average 402,111.73 402,111.73 402,111.73 402,111.73 1 0.030 Total and Average 41,433,205.16 37,402,843.70 37,402,843.70 37,402,843.70 1 0.010 Page 2 Portfolio RDAS AP PM (PRF_PM2) 7 3 11 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Cash September 30, 2021 Average Purchase Stated Days to YTM/C CUSIP Investment # Issuer Ralanco Date Par Value Market Value Book Value Rare Moodv's Mat./Call 365 UNION BANK CHECKING ACCOUNTS SYS582 582 RDA SUCCESSOR AGENCY 1,611,140.33 1,611,140 33 1,611,140 33 1 0 000 Average Balance 0.00 1 Total Cash and Investments 41,433,205.16 39,013,984.03 39,013,984.03 39,013,984.03 1 0.010 Run Date 10/29/2021 - 14 14 Page 3 Portfolio RDAS AP PM (PRF_PM2) 7 3 11 10-Nov-21 4:12 PM SymPro No. Investment PALM DESERT RDA SUCCESSOR AGENCY LONG-TERM LOANS RECEIVABLE September 30, 2021 Book Value Maturity Date Stated Interest Rate 738 EIP Loan * $ 212,000.00 09/02/29 3.00% Footnotes * EIP balance adjustments made on March 2 and September 2 of each year. Account Statement - Transaction Summary For the Month Ending September 30, 2021 CITY OF PALM DESERT - CITY OF PALM DESERT CAMP Pool Opening Market Value Purchases Redemptions Unsettled Trades Change in Value Closing Market Value Cash Dividends and Income PFM Asset Management LLC 10,032,381.10 417.85 0.00 0.00 0.00 $10,032,798.95 417.85 Asset Summary CAMP Pool Total September 30, 2021 August 31, 2021 10,032,798.95 10,032,381.10 $10,032,798.95 $10,032,381.10 Asset Allocation CAMP Pool 100.00% Page 1 Account Statement For the Month Ending September 30, 2021 CITY OF PALM DESERT - CITY OF PALM DESERT Trade Date Settlement Date Transaction Description Share or Unit Price Dollar Amount of Transaction Total Shares Owned CAMP Pool Opening Balance 09/30/21 10/01/21 Closing Balance Opening Balance Purchases Redemptions (Excl. Checks) Check Disbursements Closing Balance Cash Dividends and Income Accrual Income Div Reinvestment - Distributions PFM Asset Management LLC Month of September 10,032,381.10 417.85 0.00 0.00 10,032,798.95 417.85 Fiscal YTD January -September 9,128,893.35 14,303,905.60 (13,400,000.00) 0.00 10,032,798.95 3,905.60 Closing Balance Average Monthly Balance Monthly Distribution Yield 1.00 417.85 10,032,798.95 10,032,395.03 0.05% Page 2 10,032,381.10 10,032,798.95 10,032,798.95 CAPti' Account Statement - Transaction Summary For the Month Ending September 30, 2021 CITY OF PALM DESERT - DESERT WILLOW GOLF RESORT CAMP Pool Opening Market Value Purchases Redemptions Unsettled Trades Change in Value Closing Market Value Cash Dividends and Income PFM Asset Management LLC 730,211.57 30.41 0.00 0.00 0.00 $730,241.98 30.41 Asset Summary CAMP Pool Total September 30, 2021 August 31, 2021 730,241.98 730,211.57 $730,241.98 $730,211.57 Asset Allocation CAMP Pool 100.00% Page 1 Account Statement For the Month Ending September 30, 2021 CITY OF PALM DESERT - DESERT WILLOW GOLF RESORT Trade Date Settlement Date Transaction Description Share or Unit Price Dollar Amount of Transaction Total Shares Owned CAMP Pool Opening Balance 09/30/21 10/01/21 Closing Balance Opening Balance Purchases Redemptions (Excl. Checks) Check Disbursements Closing Balance Cash Dividends and Income Accrual Income Div Reinvestment - Distributions PFM Asset Management LLC Month of September 730,211.57 30.41 0.00 0.00 730,241.98 30.41 Fiscal YTD January -September 729,872.11 369.87 0.00 0.00 730, 241.98 369.87 Closing Balance Average Monthly Balance Monthly Distribution Yield 1.00 30.41 730,241.98 730,212.58 0.05% Page 2 730,211.57 730,241.98 730,241.98 CAPti' Account Statement - Transaction Summary For the Month Ending September 30, 2021 CITY OF PALM DESERT - PALM DESERT HOUSING AUTHORITY CAMP Pool Opening Market Value Purchases Redemptions Unsettled Trades Change in Value Closing Market Value Cash Dividends and Income PFM Asset Management LLC 48,826,376.40 2,033.63 0.00 0.00 0.00 $48,828,410.03 2,033.63 Asset Summary CAMP Pool Total September 30, 2021 August 31, 2021 48,828,410.03 48,826,376.40 $48,828,410.03 $48,826,376.40 Asset Allocation CAMP Pool 100.00% Page 1 Account Statement For the Month Ending September 30, 2021 CITY OF PALM DESERT - PALM DESERT HOUSING AUTHORITY Trade Date Settlement Date Transaction Description Share or Unit Price Dollar Amount of Transaction Total Shares Owned CAMP Pool Opening Balance 09/30/21 10/01/21 Closing Balance Opening Balance Purchases Redemptions (Excl. Checks) Check Disbursements Closing Balance Cash Dividends and Income Accrual Income Div Reinvestment - Distributions PFM Asset Management LLC Month of September 48,826,376.40 2,033.63 0.00 0.00 48,828,410.03 2,033.63 Fiscal YTD January -September 45,804,011.06 3,024,398.97 0.00 0.00 48,828,410.03 24,398.97 Closing Balance Average Monthly Balance Monthly Distribution Yield 1.00 2,033.63 48,828,410.03 48,826,444.19 0.05% Page 2 48,826,376.40 48,828,410.03 48,828,410.03 CAPti' Account Statement - Transaction Summary For the Month Ending September 30, 2021 CITY OF PALM DESERT - RDA SUCCESSOR AGENCY -- PALM DESERT CAMP Pool Opening Market Value Purchases Redemptions Unsettled Trades Change in Value Closing Market Value Cash Dividends and Income PFM Asset Management LLC 5,728.56 0.24 0.00 0.00 0.00 $5,728.80 0.24 Asset Summary CAMP Pool Total September 30, 2021 5,728.80 $5,728.80 August 31, 2021 5,728.56 $5,728.56 Asset Allocation CAMP Pool 100.00% Page 1 Account Statement For the Month Ending September 30, 2021 CITY OF PALM DESERT - RDA SUCCESSOR AGENCY -- PALM DESERT Trade Date Settlement Date Transaction Description Share or Unit Price Dollar Amount of Transaction Total Shares Owned CAMP Pool Opening Balance 09/30/21 10/01/21 Closing Balance Opening Balance Purchases Redemptions (Excl. Checks) Check Disbursements Closing Balance Cash Dividends and Income Accrual Income Div Reinvestment - Distributions PFM Asset Management LLC Month of Fiscal YTD September January -September 5,728.56 0.24 0.00 0.00 5,728.80 0.24 5,725.89 2.91 0.00 0.00 5,728.80 2.91 Closing Balance Average Monthly Balance Monthly Distribution Yield 1.00 0.24 5,728.80 5,728.57 0.05% Page 2 5,728.56 5,728.80 5,728.80 10/29/21, 1:12 PM LAIF Regular Monthly Statement California State Treasurer Fiona Ma, CPA Local Agency Investment Fund P.O. Box 942809 Sacramento, CA 94209-0001 (916) 653-3001 CITY OF PALM DESERT CITY TREASURER 73-510 FRED WARING DRIVE PALM DESERT, CA 92260-2578 September 2021 Statement Account Summary. Total Deposit: Total Withdrawal: October 29, 2021 LAIF Home PMIA Average Monthly. )Mda TtAn Iypk. Definition 0.00 Beginning Balance: 0.00 Ending Balance: 65,499,582.51 65,499,582.51 httpsJllaitms.treasurer.ca.gov/RegularStatement.aspx 1/1 10/29/21, 1:14 PM LAIF Regular Monthly Statement California State Treasurer Fiona Ma, CPA Local Agency Investment Fund P.O. Box 942809 Sacramento, CA 94209-0001 (916) 653-3001 PALM DESERT HOUSING AUTHORITY CITY TREASURER 73-510 FRED WARING DRIVE PALM DESERT, CA 92260-2578 September 2021 Statement Account Summary Total Deposit: Total Withdrawal: October 29, 2021 LAIF Home PMIA Average Monthly_ Yields Tran Type Definitions, 0.00 Beginning Balance: 0.00 Ending Balance: 971,444.20 971,444.20 https:/Aaiims.treasurer.ca.goviRegularStatement.aspx 1.1 10/29/21, 1:13 PM LAIF Regular Monthly Statement California State Treasurer Fiona Ma, CPA Local Agency Investment Fund P.O. Box 942809 Sacramento, CA 94209-0001 (916) 653-3001 S/A TO THE PALM DESERT REDEVELOPMENT AGENCY FINANCE DIRECTOR 73-510 FRED WARING DRIVE PALM DESERT, CA 92260-2578 September 2021 Statement Account Summary Total Deposit: Total Withdrawal: October 29, 2021 LAIF Home PMIA Average Monthly Yields Tran Type Definitions 0.00 Beginning Balance: 0.00 Ending Balance: 742.06 742.06 https://laifms.treasurer.ca.gov/RegularStatement.aspx 1 /1 Fund Summary Report Parameters: Run Date: From : To : As at: Query: Fund Summary Bank: oneof Counterparty: equalto 04-Oct-2021 10:54:36 AM 01-Sep-2021 30-Sep-2021 04-Oct-2021 Balance Calculation Based On: Value Date County of Riverside Treasurer -Tax Collector User: Susan Account Number Account Name Balance Forward Total Receipts Total Payments Total City Of Palm Desert $79,377,745.94 $46,346.87 $0.00 $79,424,092.81 RDA Successor Agcy Palm Desert Grand Total: $335.87 $0.21 $79,378,081.81 $46,347.08 $0.00 $336.08 $0.00 $79,424,428.89 Printed on 10/4/2021 End of Report Page 1 of 1 Bank Account Balance Parameters: Query: Fund Detail Run Date: 04-Oct-2021 11:11:46 AM From : 01-Sep-2021 To : 30-Sep-2021 As at : 04-Oct-2021 Balance Calculation Based On: Value Date County of Riverside Treasurer -Tax Collector User: Susan Value Date Bank Value Date Deal No T/T Counterparty Entity Instrument Amount Balance Sank : FUNDS urrency : USD Account Name : City Of Palm Desert 9/1/2021 9/1/2021 OB 9/15/2021 9/15/2021 462697 AC nk: FUNDS aurrency : USD Opening Balance NONE Treasury 9/1/2021 9/1/2021 OB Opening Balance 9/15/2021 9/15/2021 462698 AC NONE Treasury 121 file Account Name : RDA Successor Agcy Palm Desert 121 file $79,377,745.94 $46,346.87 Closing balance : $79,377,745.94 $79,424,092.81 $79,424,092.81 $335.87 $0.21 Closing balance : $335.87 $336.08 $336.08 Printed on 10/4/2021 End of Report Page 1 of 1 City of Palm Desert Investments Summary October 2021 The City's investment portfolio is detailed below. Investment transactions were executed in accordance with the California Government Code, the City's Investment Policy, and all bond indentures. Cash is sufficient to meet the next three months of expenditures until additional revenues are collected. Investment Portfolio: $ Millions Beginning Ending Book Value Purchases & Redemptions & Book Value % of Asset Class (10/1/21) Deposits Withdrawals (10/31/21) Portfolio Agencies $ 11.0 $ 11.9 $ 22.9 8% Corporates 37.0 3.0 40.0 15% Negotiable CDs 5.0 5.0 2% CAMP Pool 10.8 (6.0) 4.8 2% LAIF Pool 65.5 (16.5) 49.0 18% County Pool 79.4 79.4 29% Custodian ® 54.3 54.3 20% Trustee ® 5.0 (0.2) 4.8 2% Cash 7.6 3.6 11.2 4% Total $ 270.5 $ 23.5 $ (22.7) $ 271.4 100% ®= Restricted funds based upon bond indenture terms. In October, the City portfolio increased by about $900K due to revenues, including $1.7M of sales tax, exceeding transfers and expenditures. Portfolio Allocations, Maturities, and Performance: Investment Allocation Restricted — 23% Local Govt Pools Negotiable CDs 1 2% Corporates — 15% Agencies • 9% 51% Investment Maturities Performance - Total Portfolio 0.80% 0.70% City Yield 0.60% AIF v"id 0.50% 1Y T-Bill 0.40% 0.30% 0.20% 0.10% 0.00% 1M 2M 3M 6M 1Y 2Y 3Y 4Y 5Y ,'o O; ti Fe�4a` P��a� �Jc ��\ P0See o& RECEIVED" r k-e6 OTHER C�...yt�eC 7hl«.a Janet M. Moore, Director of Finance/City Treasurer Repo 11ng period 10/01/2021-10/3112021 Run one: 1100/2021 - 180r No fecal year history available Investments' CAMP FEDERAL AGENCY • COUPON LAW FEDERAL AGENCY - CALLABLE TRUSTEE CASH BALANCES MEDIUM -TERM NOTES NEGOTIABLE CDs CUSTODIAN PROJECT FUNDS RIVERSIDE COUNTY POOL Investments Cash and Accrued Interest PassbookJChedtbg (not Included in yield calculations) Accrued Interest at Purchase Subtotal Total Cash and Investments Par Vdue 4,763,357,18 9.000,000,00 49,040,689.58 14,000,000.00 4,799,703,10 40,000,000.00 5,000,000.00 54,289,507.47 79,432,865,70 280,326,123.03 11,181,747.42 271,487,870.45 Total Earnings October 91 Month Ending Ctrrent Year 80,511.81 Average Daffy Balance 267,422,685.29 Effective Rate of Return 0.35% CITY OF PALM DESERT Portfolio Management Portfolio Summary October 31, 2021 Market Value 4,783,357.18 8.946.990.00 49,040,689.58 13,909,720.00 4,799,703.10 40,191,810.00 4,996,950.00 54289.507.47 79,432,865.70 280,371,593.03 11,181,747.42 16,884.67 11,178,631.99 271,550,225.02 Book Value 4,763,357,18 8,960,303.75 49,040,689.58 13,963,483.68 4,799,703.10 39,986,878.36 5.000.000.00 54,289,507.47 79,432,885.70 280,258,788.82 11,161,747.42 16,884.57 11,178,631.99 271,435,420.81 MEETING DATE k2- - tLo - Z AYES: ..-1 im6 (i1'1iKeilglk U NOES: %i'1'it ABSENT: NOne- ABSTAIN• i\lt i VERIFIED BY. 1 a J' - f . (' $ Original o�Eiluc with City Clerk's ce Po�eµp MatJCal1 Term 365 Equ1v. 1.83 1 1 0.050 3.45 492 887 0,414 18.84 1 1 0,203 5.37 577 973 0.454 1.84 1 1 0.030 15.36 496 1,072 1.302 1.92 385 397 0294 20.86 1 1 0.010 30.52 1 1 0.303 rDu irrtz€ni 1A.1-Fa m(l� 100.00% 132 255 0.379 132 1 0.000 255 0.379 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. Alt balances ere bank balances. The "% of Portfolio" calculation on the Portfolio Summary page omits demand deposits. ved lrt� ON 12- I ) - 1 VERIFIED BY: N if1 BY SA -RDA Original on file with City Clerk's Office Portfolio CITY AP IF (PRF_ 411) 7.5.11 !Import Vac 7.3.11 CUSIP CAMP SYS13 SYS12444 Investment # Issuer CITY OF PALM DESERT Portfolio Management Portfolio Details - Investments October 31, 2021 Average Purchase R:lanrn Dale 13 C.A.M P POOL (CITY) 12444 CA.M P POOL (DESERT WILLOW) Subtotal and Average 7,246,942.50 U.S BANK / LAIF BOND PROCEEDS 252026003 12-33-084 LOCAL AGENCY INVESTMENT FUND FEDERAL AGENCY 3130ANAC4 3137EAEY1 3137EAEW5 LAIF Subtotal and Average 3,316.69 -COUPON 664 FEDERAL HOME LOAN BANK 706 FEDERAL HOME LOAN MTG CORP 707 FEDERAL HOME LOAN MTG CORP Subtotal and Average 5,121.730.27 12000 12000 LOCAL AGENCY INVESTMENT FUND Subtotal and Average 57,118,899.29 FEDERAL AGENCY -CALLABLE 3133EMLP5 3133ENBN9 3133ENAU4 3130AN7K0 668 FEDERAL FARM CREDIT BANK 698 FEDERAL FARM CREDIT BANK 699 FEDERAL FARM CREDIT BANK 660 FEDERAL HOME LOAN BANK TRUSTEE CASH BALANCES 252026000-G 2520260014 252026002-G 2520260034 252026004-G 2520260174 252026018-G 260128000-G 260128001•G Run Dale: 111092021 -16.04 Subtotal and Average 10,385,578.04 382 GOLDMAN SACHS GOVERNMENT FUND 383 GOLDMAN SACHS GOVERNMENT FUND 384 GOLDMAN SACHS GOVERNMENT FUND 385 GOLDMAN SACHS GOVERNMENT FUND 386 GOLDMAN SACHS GOVERNMENT FUND 401 GOLDMAN SACHS GOVERNMENT FUND 402 GOLDMAN SACHS GOVERNMENT FUND 404 GOLDMAN SACHS GOVERNMENT FUND 405 GOLDMAN SACHS GOVERNMENT FUND 07/01/2020 Par Value Market Value Page 1 Stated YTMIC Days to Maturity Book Value Rata Moodv's 365 Mat./Call n: •n 4,033,083.46 4.033,083.46 4,033.083.46 0.050 730.273 72 730,273 72 730,273.72 0.050 4,763,357 18 4.763.357 18 4,763.357 18 0.00 0 00 0.00 0.203 0.00 0.00 0.00 07/28/2021 3,000,000.00 2,978,700.00 2,999,565.77 10/21/2021 3,000,000.00 2,980,560.00 2,986,253.98 1021/2021 3,000.000.00 2.987 730 00 2.994.464 00 9,000,000.00 8.946.990.00 8,980.303.75 0.500 0 125 0.250 49,040,689.58 49.040.689.58 49,040.689.58 0.203 49,040,689.58 49,040,689.58 49,040,689.58 09/14/2021 5.000.000.00 4,941,400.00 4,968,795.59 1020/2021 3,000,000.00 2,996,190.00 2,998,227 50 10/19/2021 3.000.000.00 2.987 070 00 2.996.460.59 0729/2021 3,000,000.00 2,985.060.00 3,000.000.00 07/0112020 14,000,000.00 13,909,720.00 13,963,483.68 0.00 0.00 0.00 0.00 0.00 0.00 0.00 15.969 75 0.00 0 00 0.00 0 00 0.00 0 00 0.00 0 00 15 969 75 0.00 0.320 0.340 0.270 0.400 0050 1 0050 1 0.050 1 0 203 1 Aaa Aaa Aaa 0 000 0 0.530 0 360 0 350 88 101282024 714 10/16/2023 676 09/082023 0.414 492 0 203 1 Aaa Aaa Aaa Aaa 0.203 1 0.520 0.460 0 392 0.400 1,148 12/23/2024 170 10/20/2023 345 10/12/2023 270 07/29/2024 0.00 0.030 Aaa 0.00 0.030 Aaa 0.00 0.030 Aaa 0.00 0.030 Aaa 0.00 0.030 Aaa 0.00 0.030 Aaa 0.00 0.030 Aaa 15.969.75 0.030 Aaa 0.00 0.030 Aaa 0.454 577 0030 0.030 0 030 0.030 0 030 0.030 0.030 0030 0.030 1 1 1 1 1 1 1 1 Portfolio CITY AP PM (PRF PM2) 7311 Report Vor 7311 CITY OF PALM DESERT Portfolio Management Portfolio Details - Investments October 31, 2021 Page 2 Average Purchase Stated YTMIC Days to Maturity CUSIP Investment a Issuer R:eanee Date Par Value Market Value Book Value ems Mooches 365 Mst/n,au n j TRUSTEE CASH BALANCES 260128002-G 407 GOLDMAN SACHS GOVERNMENT FUND 07/01/2020 0.00 000 0.00 0.030 Aaa 0030 1 260128003-G 408 GOLDMAN SACHS GOVERNMENT FUND 07/01(2020 0.00 000 0.00 0.030 Aaa 0030 1 2601280044 409 GOLDMAN SACHS GOVERNMENT FUND 07/0112020 0.00 0.00 0.00 0.030 Aaa 0.030 1 260128005-G 410 GOLDMAN SACHS GOVERNMENT FUND 0.00 0 00 0.00 0.030 Aaa 0 030 1 260128006E 412 GOLDMAN SACHS GOVERNMENT FUND 0.00 0.00 0.00 0.030 Aaa 0.030 1 260128007-G 414 GOLDMAN SACHS GOVERNMENT FUND 0.00 000 0.00 0.030 Aaa 0 030 1 2601280084 415 GOLDMAN SACHS GOVERNMENT FUND 0.00 0.00 0.00 0.030 Aaa 0.030 1 2601280094 416 GOLDMAN SACHS GOVERNMENT FUND 07/0112020 2.08 2.08 2.08 0.030 Aaa 0.030 1 260128010-G 417 GOLDMAN SACHS GOVERNMENT FUND 0 72 0 72 0 72 0.030 Aaa 0 030 1 2601280114 416 GOLDMAN SACHS GOVERNMENT FUND 160.903.52 160.903.52 160.903.52 0.030 Aaa 0.030 1 261470000E 419 GOLDMAN SACHS GOVERNMENT FUND 0.00 0 00 0.00 0.030 Aaa 0 030 1 2614700014 420 GOLDMAN SACHS GOVERNMENT FUND 0.00 0.00 0.00 0.030 Aaa 0.030 1 261470002-G 421 GOLDMAN SACHS GOVERNMENT FUND 0.00 000 0.00 0.030 Aaa 0030 1 263346000-G 671 GOLDMAN SACHS GOVERNMENT FUND 081012021 0.00 0 00 0.00 0.030 Aaa 0 030 1 2633460014 672 GOLDMAN SACHS GOVERNMENT FUND 08101/2021 0.00 0.00 0.00 0.030 Aaa 0.030 1 263346002E 673 GOLDMAN SACHS GOVERNMENT FUND 08/012021 0 12 0 12 0.12 0.030 Aaa 0 030 1 263346003E 674 GOLDMAN SACHS GOVERNMENT FUND 08f012021 874,207 66 874.207.66 874.207.66 0.030 Aaa 0.030 1 263346004-G 675 GOLDMAN SACHS GOVERNMENT FUND 08/012021 0.00 000 0.00 0.030 Aaa 0030 1 2633460054 676 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 0.00 0.00 0.00 0.030 Aaa 0.030 1 2633460064 677 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 29,136.80 29,136.80 29.136.80 0.030 Aaa 0.030 1 263346007E 678 GOLDMAN SACHS GOVERNMENT FUND 08/012021 1792.078.53 1 792 078.53 1792.078.53 0.030 Aaa 0030 1 263599000E 679 GOLDMAN SACHS GOVERNMENT FUND 08;012021 0.00 0.00 0.00 0.030 Aaa 0.030 1 263599001E 680 GOLDMAN SACHS GOVERNMENT FUND 08/012021 0.00 000 0.00 0.030 Aaa 0030 1 263599002E 682 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 1,416,815.33 1,416,815.33 1,416.815.33 0.030 Aaa 0.030 1 263599003-G 683 GOLDMAN SACHS GOVERNMENT FUND 08/0112021 22,749 73 22,749 73 22,749.73 0.030 Aaa 0 030 1 269048000-G 684 GOLDMAN SACHS GOVERNMENT FUND 08/012021 0.00 0 00 0.00 0.030 Aaa 0 030 1 271146000E 685 GOLDMAN SACHS GOVERNMENT FUND 08/012021 0.00 0.00 0.00 0.030 Aaa 0.030 1 271146001E 687 GOLDMAN SACHS GOVERNMENT FUND 08/012021 0.00 000 0.00 0.030 Aaa 0030 1 2711460024 688 GOLDMAN SACHS GOVERNMENT FUND 08f012021 0.00 0.00 0.00 0.030 Aaa 0.030 1 271146003-6 689 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 468,404 17 468.404 17 469,404.17 0.030 Aaa 0 030 1 2711460044 690 GOLDMAN SACHS GOVERNMENT FUND 08/012021 0.00 0.00 0.00 0.030 Aaa 0.030 1 271146005-G 691 GOLDMAN SACHS GOVERNMENT FUND 08/01/2021 0.00 0.00 0.00 0.030 Aaa 0.030 1 271146006E 692 GOLDMAN SACHS GOVERNMENT FUND 08/012021 19.434.69 19,434.69 19.434 69 0.030 Aaa 0 030 1 277580000E 693 GOLDMAN SACHS GOVERNMENT FUND 08;012021 0.00 0.00 0.00 0.030 Aaa 0.030 1 Run Dale: 111092021 -16.04 Subtotal and Average 4,830,108.35 4,799,703.10 4,799,70310 4,799,703.10 0.030 1 Portfolio CITY AP PIA (PRF_PM2) 7 311 CUSIP Investment M MEDIUM -TERM NOTES Issuer CITY OF PALM DESERT Portfolio Management Portfolio Details - Investments October 31, 2021 Page 3 Average Purchase Stated YTM/C Days to Maturity R:nanee Dam Par Value Market Value Book Value Rao. Moodu's 365 Mar 1Csu n j 037833DL1 614 APPLE. INC 09/112019 5,000,000.00 5,063,100.00 4,999,580.93 1 700 Aa 1 710 314 09/11/2022 037833DL1 616 APPLE. INC 09/25/2019 10.000.000.00 10 126.200 00 9.997.065.76 1 700 Aa 1 735 314 09/112022 023135BW5 662 AMAZON.COM INC 07/192021 3,000,000.00 2.977,470.00 3,000,000.00 0.450 A 0.450 11 05/12/2024 14913R2L0 697 CATERPILLAR FINANCIAL SERVICES 10/072021 3.000.000.00 2.975.94000 2.996.19957 0.450 A 0 500 928 05/17/2024 254687FJ0 625 WALT DISNEY COMPANY 11/20/2019 5,000,000.00 5,055.750.00 4,998.366.63 1.650 A 1.690 304 09/01/2022 02665WDC2 617 AMERICAN HONDA FINANCE 0927/2019 5,000,000.00 5.091.900.00 4,999,981 87 2.050 A 2.045 435 01/10/2023 89236TJH9 658 TOYOTA MOTOR CREDIT CORP 06/182021 3.000.000.00 2.967.150.00 3.000.000.00 0.500 A 0.500 960 06/18/2024 89236TJH9 659 TOYOTA MOTOR CREDIT CORP 07/08/2021 3,000,000.00 2,967,150.00 2,997,641.43 0.500 A 0.530 960 06/18/2024 89236TJH9 667 TOYOTA MOTOR CREDIT CORP 09/142021 3.000.000.00 2.967 150 00 2.998.042.17 0.500 A 0 525 960 06/18/2024 NEGOTIABLE CDs Subtotal and Average 39,406,639.09 40,000,000.00 40.191.810.00 39,986,878.36 1 302 496 89114WJ97 705 TORONTO DOMINION NEW YORK 10/20/2021 5,000,000.00 4,996,950.00 5.000.000.00 0.290 Aa 0.294 385 11/21/2022 Subtotal and Average 1,935,483.87 5,000,000.00 4,996,950.00 5,000,000.00 0.294 385 CUSTODIAN PROJECT FUNDS 6736302420-G 647 FIRST AMERICAN US TREASURY MMF 01/012021 6,081,954.03 6,081,954.03 6,081,954.03 0.010 Aaa 0.010 1 6736302430-G 648 FIRST AMERICAN US TREASURY MMF 01/01/2021 18,090,733.55 18.090,733.55 18,090.733.55 0.010 Aaa 0.010 1 6736302440-G 649 FIRST AMERICAN US TREASURY MMF 01/012021 9 789,230 77 9 789.230 77 9 789.230.77 0.010 Aaa 0 010 1 67363024504 650 FIRST AMERICAN US TREASURY MMF 01/01/2021 20.327,58912 20.327.58912 20,327,589.12 0.010 Aaa 0.010 1 Subtotal and Average 54,289,507.47 54,289,507.47 54,289,507.47 54,289,507.47 0.010 1 RIVERSIDE COUNTY POOL 052460 052460 POOLED INVESTMENT FUND 79.432.865 70 79.432.865 70 79.432.865.70 0.303 Aaa 0 303 1 Subtotal and Average 79,429,186.75 79,432,865.70 79.432.865.70 79,432,865.70 0.303 1 CUSTODIAN PROJECT FUNDS 6736302420 498 GOLDMAN SACHS TREASURY FUND 0.00 0 00 0.00 0.010 Aaa 0.010 1 6736302430 499 GOLDMAN SACHS TREASURY FUND 0.00 000 0.00 0.010 Aaa 0010 1 6736302440 500 GOLDMAN SACHS TREASURY FUND 0.00 0.00 0.00 0.010 Aaa 0.010 1 6736302450 501 GOLDMAN SACHS TREASURY FUND 0.00 0 00 0.00 0.010 Aaa 0 010 1 Subtotal and Average Run DMe: 111092021 -16.04 0.00 0.00 0.00 0.00 0 000 0 Portfolio CITY AP PIA (PRF_PM2) 7 311 CUSIP Run Dale: 111092021 -16.04 CITY OF PALM DESERT Portfolio Management Portfolio Details - Investments October 31, 2021 Average Purchase Stated YTMIC Days to Investment # Issuer //ltS RR//�:.lanres Date Par Value Market Value Book Value pate Moodv's 365 Mat.1Call Total and Average 267,4't .(19 260.326.123.03 260,371,593.03 260.256.788.82 0.379 132 Page 4 Portfolio CITY AP PM (PRF PM2) 7 311 CITY OF PALM DESERT Portfolio Management Portfolio Details - Cash October 31, 2021 Page 5 Average Purchase Stated YTMIC Days to CUSIP Investment 11 Issuer R: Ian,n Data Par Value Market Value Book Value Ram Moodv's 365 Mat.iCall PENDING DEPOSIT WITH COUNTY POOL SVS651 651 CITY OF PALM DESERT MAIN 01/29E2021 0.00 000 0.00 0000 1 UNION BANK CHECKING ACCOUNTS SYS13016 13016 CITY OF PALM DESERT MAIN 7 102.608 15 7 102 608 15 7102,608.15 0 000 1 SYS13013 13013 DESERT WILLOW GOLF COURSE 07/01/2020 1.340.633 75 1.340.633 75 1,340,633.75 0.000 1 SYS602 602 PUBLIC SAFETY CHECKING 07/01/2020 1,494,866.42 1,494,866.42 1,494,868A2 0 000 1 SYS13020 13020 RECREATIONAL FACILITIES CORP 07/0112020 1,223,63910 1.223.63910 1,221639.10 0.000 1 Average Balance 0.00 Accrued Interest al Purchase 16.884.57 16.884.57 Subtotal 11178,631 99 11,178,631 99 Total Cash and Investments Run Date. 14092021 . 1604 267,422,685.29 271,487,870.45 271,550,225.02 271,435,420.81 0.379 132 Portfolio CITY AP PM (PRF PM2)7311 CITY OF PALM DESERT LONG-TERM LOANS RECEIVABLE October 31, 2021 10-Nov-21 3.49 PM SymPro Book Stated No. Investment Value Maturity Date Interest Rate 1 City Loan to RDA* $ 7,512,000 00 N/A 0.22% 348 EIP Loan ** $ 1,159,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 October 31, 2021 Par Market Book %of Days to YTMIC Investments Value Value Value Portfolio Mat./Call Term 365 Equiv. CAMP 48,830,532.29 48,830,532.29 48,830,532.29 8920 1 1 0.050 LAIF 972,035 74 972,035 74 972.035 74 1.78 1 1 0.203 CUSTODIAN PROJECT FUNDS 4,939,267 81 4,939,267.81 4,939,267.81 9.02 1 1 0.010 Investments Cash Passbook/Chedting (not Included In yield calculations) Total Cash and Investments Total Earnings Current Year Average Daily Balance Effective Rate of Return 54,741,835.84 54,741,835.84 54,741,835.84 100.00% 1 1 0 049 3.665.505.67 3,665,505.67 3.665.505.67 1 58.407,341 51 58,407,341.51 October 31 Month Ending 2.283 03 58,401,084.85 0 05% 0.000 58,407,341.51 1 1 0 049 This investment portfolio complies 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 Housing Authority operations for the next six months PJI balances are bank balances The "% of Portfolio" calculation on the Portfolio Summary page omits demand deposits ia.r t7N 7tSn. Janet M Moore, Director of Finance/City Treasurer Reporting period 10/01/2021.10/31/2021 Run Dale 11/0912021 16.12 No fiscal year history available Portfolio HA AP IE (PRF PMI)73.11 Repel Vet 7 311 PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Details - Investments October 31, 2021 Page 1 Average Purchase Stated Days to YTM/C Maturity CUSIP Investment 8 Issuer lb Janet. Data Par Value Market Value Book Value Rim. Moodv's Mat./Call 365 n: •n CAMP SYS12008 12008 CA ASSET MANAGEMENT PROGRAM 48.830.532.29 48,830,532.29 48.830.532.29 0.050 1 0.050 Subtotal and Average 413,828,615.41 48,830,532.29 48,830,532.29 413,830,532.29 1 0.050 CUSTODIAN PROJECT FUNDS 6736302460 590 GOLDMAN SACHS TREASURY FUND 0.00 0.00 0.00 0.010 Aaa 1 0.010 LAIF Subtotal and Average 0.00 0.00 0.00 0.00 0 0.000 SYS21003 21003 LOCAL AGENCY INVESTMENT FUND 972,035 74 972.035 74 972,035.74 0.203 1 0.203 Subtotal and Average 971,768.59 972,035.74 972,035 74 972,035.74 1 0.203 CUSTODIAN PROJECT FUNDS 6736302460-G 597 FIRST AMERICAN US TREASURY MMF 01/01/2021 4.939.26781 4.939.267.81 4,939,267.81 0.010 Aaa 1 0.010 Subtotal and Average 4,939.267 81 4,939,267 81 4.939.267.81 4.939.267 81 1 0.010 Total and Average 58,401,084.85 54,741,835.84 54,741,835.84 54,741,835.84 1 0.049 Run Dale: 11109/2021 -16:12 Portfolio HA AP PM (PRF PM2) 7311 Report Vor 7311 CUSIP Investment # Issuer CHECKING SYS25015 25015 HOUSING AUTH CHECKING SYS25016 25016 HOUSING AUTH TRUST Run DMe: 111092021 -16:12 PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Details - Cash October 31, 2021 Average Purchase Rmlanee Data 07/01/2020 Par Value 3.205.758.65 459 747 02 Stated Days to YTM/C Market Value Book Value sat Moodv's Mat./Call 365 3,205,758.65 459 747 02 3.205.758.65 459.747 02 1 0.000 1 0.000 Average Balance 0.00 1 Total Cash and Investments 58,401,084.85 58,407,341.51 58.407.341.51 58,407.341 51 1 0.049 Page 2 Portfolio HA AP PM (PRF PM2) 7311 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Summary October 31, 2021 Par Market Book %of Days to YTM/C Investments Value Value Value Portfolio Mat./Call Tem, 365 Equiv. RIVERSIDE COUNTY POOL 336 12 336 12 336 12 0 00 1 1 0.303 CAMP 5.729.05 5.729.05 5.729.05 0.04 1 1 0.050 LAIF 742.51 742.51 742.51 0.00 1 1 0.203 TRUSTEE CASH BALANCES - MMA 15.381.830 16 15.381.830 16 15.381.830 16 97 41 1 1 0.010 TRUSTEE CASH BALANCES - GF 402.120.36 402.120.36 402,129.36 2.55 1 1 0.030 15,790,758.20 15,790,758.20 Investments 15,790,758.20 100.00% 1 1 0 011 Cash Passbook/Checking 2,994.157 26 2,994,157.26 2.994.157.26 1 1 0.000 (not included in yield calculations) Total Cash and Investments Total Earnings Current Year Average Daily Balance 18,784,915.46 18,784,915.46 18,784,915.46 1 1 0 011 October 31 Month Ending 141 35 17,446,511.53 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 Califomia All balances are bank balances. The'% of Portfolio' calculation on the Portfolio Summary page omits demand deposits tirt ?gnu. Janet M Moore, Finance Officer Reporting period 1010112021.10131/2021 Rao Date 11109/2021 16.23 No fiscal year history available Portfolio RDAS AP IE (PRF PMl) 73.11 Report Ver 7311 CUSIP Investment RIVERSIDE COUNTY POOL 052470 052470 Issuer POOLED INVESTMENT FUND RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Investments October 31, 2021 Average Purchase 11:tl...rn Date Par Vaiue Market Value Subtotal and Average 336.10 CAMP SYS578 578 CAM P POOL (RDA SA) 07/01/2020 33612 Page 1 Stated Days to YTM/C Maturity Book Value Rath Mnndv's MatICall 365 n..u. 33612 33612 0.303 Aaa 1 0.303 336.12 336.12 336.12 1 0.303 Subtotal and Average 5,728.82 5,729.05 5.729.05 5.729.05 0.050 5,729.05 5,729.05 5,729.05 1 0.050 1 0.050 LAIF SYS604 604 L.A.I F (RDA SA) Subtotal and Average 74231 07/01/2020 742.51 742.51 742.51 0.203 742.51 742.51 742.51 1 0203 1 0.203 TRUSTEE CASH BALANCES - MMA 2473940014J 830 U.S. BANK MONEY MARKET ACCOUNT 247394003-U 832 U.S. BANK MONEY MARKET ACCOUNT 2473940024J 833 2473940004J 834 23878100241 837 238781003.0 838 2367810004J 839 2534460034J 842 2534460024J 843 2534480004J 844 25344600141 845 2243240004J 853 2243240014J 855 224324002-U 856 22432400341 857 2367810014J 881 U.S. BANK MONEY MARKET ACCOUNT V.S. BANK MONEY MARKET ACCOUNT U S BANK MONEY MARKET ACCOUNT U.S. BANK MONEY MARKET ACCOUNT U S. BANK MONEY MARKET ACCOUNT U.S. BANK MONEY MARKET ACCOUNT U.S. BANK MONEY MARKET ACCOUNT U S. BANK MONEY MARKET ACCOUNT U.S. BANK MONEY MARKET ACCOUNT U S. BANK MONEY MARKET ACCOUNT U.S. BANK MONEY MARKET ACCOUNT U.S. BANK MONEY MARKET ACCOUNT U.S. BANK MONEY MARKET ACCOUNT V.S. BANK MONEY MARKET ACCOUNT Subtotal and Average 15,381,830.16 07/01/2020 0.04 07/01/2020 0.00 0.91 527,946.06 12.84 07/01/2020 0.00 7,435,394.29 07/01/2020 0.00 671 2,950,279.31 07/01/2020 0.29 4,488,189.84 07/01/2020 0.56 19.24 07/01/2020 0.00 09/01/2020 0.07 0.04 000 091 527,946.06 12.84 0.00 7,435.39429 0.00 671 2.950279.31 0.29 4.468 169.84 056 19.24 0.00 007 0.04 0.010 P-1 1 0.010 0.00 0.010 P-1 1 0.010 0.91 0.010 P-1 1 0.010 527,946.06 0.010 P-1 1 0.010 12.84 0.010 P-1 1 0.010 0.00 0.010 P-1 1 0.010 7,435,394.29 0.010 P-1 1 0.010 0.00 0.010 P-1 1 0.010 671 0.010 P-1 1 0.010 2,950,279.31 0.010 P-1 1 0.010 0.29 0.010 P-1 1 0.010 4,488,189.84 0.010 P-1 1 0.010 0.56 0.010 P-1 1 0.010 19.24 0.010 P-1 1 0.010 0.00 0.010 P-1 1 0.010 0.07 0.010 P-1 1 0.010 15,381,830.16 15,381,830 16 16,381,830.16 1 0.010 TRUSTEE CASH BALANCES - GF 277881000-G 277861001-6 277881002-G 277861003G Run Date. 11 O92021 -1623 811 GOLDMAN SACHS GOVERNMENT FUND 812 GOLDMAN SACHS GOVERNMENT FUND 813 GOLDMAN SACHS GOVERNMENT FUND 814 GOLDMAN SACHS GOVERNMENT FUND 07/01/2020 07/01/2020 402,120.38 0.00 0.00 0.00 402.120.38 000 0 00 0.00 402,120.36 0.030 Aaa 0.00 0.030 Aaa D.00 0.030 Aaa 0.00 0.030 Aaa 1 1 1 1 0.030 0.030 0.030 0.030 Portfolio RDAS AP PM (PRF PM2) 7 311 Roped Vor 7311 CUSIP Run DMe: 11109/2021 -1623 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Investments October 31, 2021 Average Purchase Stated Days to YTM/C Investment M Issuer R. Janet. Data Par Value Market Value Book Value oils.Moodv's Mat./Call 365 Subtotal and Average 40'4120.36 402.120.36 402.120.36 402.120.36 1 0.030 Total and Average 17.446,511 53 15,790,758.20 15,790,758.20 15.790.758.20 1 0.011 Page 2 Portfolio RDAS AP PM (PRF PM2) 7311 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Cash October 31, 2021 Average Purchase Stated Days to VTM/C CUSIP Investment # Issuer R;,Ianen Date Par Value Market Value Book Value Rik Moodv's Mat./Call 365 UNION BANK CHECKING ACCOUNTS SVS582 582 RDA SUCCESSOR AGENCY 2,994,157.26 2.994.157.26 2,994,15726 1 0.000 Average Balance 0.00 1 Total Cash and Investments 17,446,511 53 18,784,915.46 18,784,915.46 18,784,915.46 1 0.011 Run Date. 11,69)2021 -1623 Page 3 Portfolio RDAS AP PM (PRF PN2) 7311 PALM DESERT RDA SUCCESSOR AGENCY LONG-TERM LOANS RECEIVABLE October 31, 2021 10-Nov-21 3.49 PM SymPro Book Stated No. Investment Value Maturity Date Interest Rate 738 EIP Loan * $ 212,000 00 09/02/29 3.00% Footnotes EIP balance adjustments made on March 2 and September 2 of each year CAPti' Account Statement - Transaction Summary For the Month Ending October 31, 2021 CITY OF PALM DESERT - CITY OF PALM DESERT CAMP Pool Opening Market Value Purchases Redemptions Unsettled Trades Change in Value Closing Market Value Cash Dividends and Income PFM Asset Management LLC 10,032,798.95 3,000,284.51 (9,000,000.00) 0.00 0.00 $4,033,083.46 284.51 Asset Summary CAMP Pool Total October 31, 2021 4,033,083.46 $4,033,083.46 September 30, 2021 10,032,798.95 $10,032,798.95 Asset Allocation CAMP Pool 100.00% Page 1 Account Statement For the Month Ending October 31, 2021 CITY OF PALM DESERT - CITY OF PALM DESERT Trade Date Settlement Date Transaction Description Share or Unit Price Dollar Amount of Transaction CAMP Pool Opening Balance 10/06/21 10/08/21 10/18/21 10/19/21 10/21/21 10/29/21 Closing Balance 10/06/21 Redemption - Outgoing Wires 10/08/21 Redemption - Outgoing Wires 10/18/21 Purchase - Incoming Wires 10/19/21 Redemption - Outgoing Wires 10/21/21 Redemption - Outgoing Wires 11/01/21 Accrual Income Div Reinvestment - Distributions Opening Balance Purchases Redemptions (Excl. Checks) Check Disbursements Closing Balance Cash Dividends and Income PFM Asset Management LLC Month of Fiscal YTD October January -October 10,032,798.95 9,128,893.35 3,000,284.51 17,304,190.11 (9,000,000.00) (22,400,000.00) 0.00 0.00 4,033,083.46 4,033,083.46 284.51 4,190.11 Closing Balance Average Monthly Balance Monthly Distribution Yield 1.00 1.00 1.00 1.00 1.00 1.00 (1,500,000.00) (1,500,000.00) 3,000,000.00 (5,000,000.00) (1,000,000.00) 284.51 4,033,083.46 6,516,697.45 0.05% Page 2 Total Shares Owned 10,032,798.95 8,532,798.95 7,032,798.95 10,032,798.95 5,032,798.95 4,032,798.95 4,033,083.46 4,033,083.46 CAPti' Account Statement - Transaction Summary For the Month Ending October 31, 2021 CITY OF PALM DESERT - DESERT WILLOW GOLF RESORT CAMP Pool Opening Market Value Purchases Redemptions Unsettled Trades Change in Value Closing Market Value Cash Dividends and Income PFM Asset Management LLC 730,241.98 31.74 0.00 0.00 0.00 $730,273.72 31.74 Asset Summary CAMP Pool Total October 31, 2021 September 30, 2021 730,273.72 $730,273.72 730,241.98 $730,241.98 Asset Allocation CAMP Pool 100.00% Page 1 Account Statement For the Month Ending October 31, 2021 CITY OF PALM DESERT - DESERT WILLOW GOLF RESORT Trade Date Settlement Date Transaction Description Share or Unit Price Dollar Amount of Transaction Total Shares Owned CAMP Pool Opening Balance 10/29/21 11/01/21 Closing Balance Opening Balance Purchases Redemptions (Excl. Checks) Check Disbursements Closing Balance Cash Dividends and Income Accrual Income Div Reinvestment - Distributions PFM Asset Management LLC Month of Fiscal YTD October January -October 730,241.98 729,872.11 31.74 401.61 0.00 0.00 0.00 0.00 730,273.72 730,273.72 31.74 401.61 Closing Balance Average Monthly Balance Monthly Distribution Yield 1.00 31.74 730,273.72 730,245.05 0.05% Page 2 730,241.98 730,273.72 730,273.72 CAPti' Account Statement - Transaction Summary For the Month Ending October 31, 2021 CITY OF PALM DESERT - PALM DESERT HOUSING AUTHORITY CAMP Pool Opening Market Value Purchases Redemptions Unsettled Trades Change in Value Closing Market Value Cash Dividends and Income PFM Asset Management LLC 48,828,410.03 2,122.26 0.00 0.00 0.00 $48,830,532.29 2,122.26 Asset Summary CAMP Pool Total October 31, 2021 48,830,532.29 $48,830,532.29 September 30, 2021 48,828,410.03 $48,828,410.03 Asset Allocation CAMP Pool 100.00% Page 1 Account Statement For the Month Ending October 31, 2021 CITY OF PALM DESERT - PALM DESERT HOUSING AUTHORITY Trade Date Settlement Date Transaction Description Share or Unit Price Dollar Amount of Transaction Total Shares Owned CAMP Pool Opening Balance 10/29/21 11/01/21 Closing Balance Opening Balance Purchases Redemptions (Excl. Checks) Check Disbursements Closing Balance Cash Dividends and Income Accrual Income Div Reinvestment - Distributions PFM Asset Management LLC Month of Fiscal YTD October January -October 48,828,410.03 45,804,011.06 2,122.26 3,026,521.23 0.00 0.00 0.00 0.00 48,830,532.29 48,830,532.29 2,122.26 26, 521.23 Closing Balance Average Monthly Balance Monthly Distribution Yield 1.00 2,122.26 48,830,532.29 48,828,615.41 0.05% Page 2 48,828,410.03 48,830,532.29 48,830,532.29 CAPti' Account Statement - Transaction Summary For the Month Ending October 31, 2021 CITY OF PALM DESERT - RDA SUCCESSOR AGENCY -- PALM DESERT CAMP Pool Opening Market Value Purchases Redemptions Unsettled Trades Change in Value Closing Market Value Cash Dividends and Income PFM Asset Management LLC 5,728.80 0.25 0.00 0.00 0.00 $5,729.05 0.25 Asset Summary CAMP Pool Total October 31, 2021 September 30, 2021 5,729.05 $5,729.05 5,728.80 $5,728.80 Asset Allocation CAMP Pool 100.00% Page 1 Account Statement For the Month Ending October 31, 2021 CITY OF PALM DESERT - RDA SUCCESSOR AGENCY -- PALM DESERT Trade Date Settlement Date Transaction Description Share or Unit Price Dollar Amount of Transaction Total Shares Owned CAMP Pool Opening Balance 10/29/21 11/01/21 Closing Balance Opening Balance Purchases Redemptions (Excl. Checks) Check Disbursements Closing Balance Cash Dividends and Income Accrual Income Div Reinvestment - Distributions PFM Asset Management LLC Month of October 5,728.80 0.25 0.00 0.00 5,729.05 0.25 Fiscal YTD January -October 5,725.89 3.16 0.00 0.00 5,729.05 3.16 Closing Balance Average Monthly Balance Monthly Distribution Yield 1.00 0.25 5,729.05 5,728.82 0.05% Page 2 5,728.80 5,729.05 5,729.05 11/3/21, 4:42 PM LAIF Regular Monthly Statement California Ste Fiona Ma, CPA Local Agency Investment Fund P.O. Box 942809 Sacramento, CA 94209-0001 (916) 653-3001 CITY OF PALM DESERT CITY TREASURER 73-510 FRED WARING DRIVE PALM DESERT, CA 92260-2578 October 2021 Statement Effective Date Transaction Tran Confirm Date TyPe Number 10/15/2021 10/ 14/2021 10/15/2021 10/15/2021 10/19/2021 10/ 19/2021 Account Summary. Total Deposit: Total Withdrawal: QRD 1688526 RW 1688847 RW 1689073 November 03, 2021 LAW Home PMIA Average Monthly. Yields Tran Tyne Definitions Web Confirm Number Authorized Caller N/A SYSTEM N/A THOMAS METZ N/A THOMAS METZ 41,107.07 Beginning Balance: -16,500,000.00 Ending Balance: Amount 41,107.07 -11,500,000.00 -5,000,000.00 65,499,582.51 49,040,689.58 https://laifms.treasurer.ca.gov/RegularStatement.aspx 1?1 BETTY T. YEE California State Controller LOCAL AGENCY INVESTMENT FUND REMITTANCE ADVICE Agency Name Account Number As of 10/15/2021, your Local Agency Investment Fund account has been directly credited with the interest earned on your deposits for the quarter ending 09/30/2021. Earnings Ratio Interest Rate Dollar Day Total Quarter End Principal Balance Quarterly Interest Earned $ $ $ CITY OF PALM DESERT .00000661958813242 0.24% 6,209,912,995.20 65,499,582.51 41,107.07 11/3/21, 4:47 PM LAIF Regular Monthly Statement California State Treasurer Fiona Ma, CPA Local Agency Investment Fund P.O. Box 942809 Sacramento, CA 94209-0001 (916) 653-3001 PALM DESERT HOUSING AUTHORITY CITY TREASURER 73-510 FRED WARING DRIVE PALM DESERT, CA 92260-2578 October 2021 Statement Effective Transaction Type Confirm Date Date Type Number Web Confirm Number November 03, 2021 LAIF Home PMIA Average Monthly_ Yields Tran Type Definitions Authorized Caller 10/15/2021 10/14/2021 QRD 1687045 N/A SYSTEM Account Summary Total Deposit: Total Withdrawal: 591.54 Beginning Balance: 0.00 Ending Balance: Amount 591.54 971,444.20 972,035.74 https://laifms.treasurer.ca.gov/RegularStatement.aspx 111 Agency Name Account Number BETTY T. YEE California State Controller LOCAL AGENCY INVESTMENT FUND REMITTANCE ADVICE PALM DESERT HOUSING AUTHORITY As of 10/15/2021, your Local Agency Investment Fund account has been directly credited with the interest earned on your deposits for the quarter ending 09/30/2021. Earnings Ratio Interest Rate Dollar Day Total Quarter End Principal Balance Quarterly Interest Earned $ $ $ .00000661958813242 0.24% 89,361,771.26 971,444.20 591.54 11/3/21, 4:45 PM LAIF Regular Monthly Statement California State Treasurer Fiona Ma, CPA Local Agency Investment Fund P.O. Box 942809 Sacramento, CA 94209-0001 (916) 653-3001 S/A TO THE PALM DESERT REDEVELOPMENT AGENCY FINANCE DIRECTOR 73-510 FRED WARING DRIVE PALM DESERT, CA 92260-2578 October 2021 Statement Effective Transaction Type Confirm Date Date �'PNumber Web Confirm Number November 03, 2021 LAIF Home PMIA Average Monthly. Yields Traci •TYpe DefiritivE Authorized Caller 10/15/2021 10/14/2021 QRD 1687467 N/A SYSTEM Account Summary Total Deposit: Total Withdrawal: 0.45 Beginning Balance: 0.00 Ending Balance: Amount 0.45 742.06 742.51 https:/Aaifms.treasurer.ca.gov/RegularStatement.aspx 111 BETTY T. YEE California State Controller LOCAL AGENCY INVESTMENT FUND REMITTANCE ADVICE Agency Name Account Number S.A TO THE PALM DESERT As of 10.1512021, your Local Agency Investment Fund account has been directly credited with the interest earned on your deposits for the quarter ending 09/30/2021. Earnings Ratio .00000661958813242 Interest Rate 0.24% Dollar Day Total $ 68,260.98 Quarter End Principal Balance $ 742.06 Quarterly Interest Earned $ .45 Fund Summary Report Parameters: Run Date: From : To : As at: Query: Fund Summary Bank: oneof Counterparty: equalto 04-Nov-2021 09:41:12 AM 01-Oct-2021 31-Oct-2021 04-Nov-2021 Balance Calculation Based On: Value Date County of Riverside Treasurer -Tax Collector User: Susan Account Number Account Name Balance Forward Total Receipts Total Payments Total City Of Palm Desert $79,424,092.81 $8,772.89 $0.00 $79,432,865.70 RDA Successor Agcy Palm Desert Grand Total: $336.08 $0.04 $79,424,428.89 $8,772.93 $0.00 $336.12 $0.00 $79,433,201.82 Printed on 11/4/2021 End of Report Page 1 of 1 Bank Account Balance Parameters: Query: Fund Detail Run Date: From : To : As at: 04-Nov-2021 10:09:58 AM 01-Oct-2021 31-Oct-2021 04-Nov-2021 Balance Calculation Based On: Value Date County of Riverside Treasurer -Tax Collector User: Susan Value Date Bank Value Date Deal No T/T Counterparty Entity Instrument Amount Balance ank: FUNDS urrency : USD Account Number : Account Name : City Of Palm Desert 10/1/2021 10/1/2021 10/14/2021 10/14/2021 497189 OB AC Opening Balance NONE Treasury 121 file nk: FUNDS aurrency : USD Account Number : Account Name : RDA Successor Agcy Palm Desert 10/1/2021 10/1/2021 OB Opening Balance 10/14/2021 10/14/2021 497191 AC NONE Treasury 121 file $79,424,092.81 $8,772.89 Closing balance : $79,424,092.81 $79,432,865.70 $79,432,865.70 $336.08 $0.04 Closing balance : $336.08 $336.12 $336.12 Printed on 11/4/2021 End of Report Page 1 of 1 Revenues Sales Tax Transient Occupancy Tax License, Permits, & Charges Property Tax Franchise Fees Interest Income and Rent State Subvention All Others InterFund Transfers In TOTAL REVENUES Expenditures Police Services General Government + Contrib Public Works Parks Building and Safety Community Development Economic Development InterFund Transfers Out TOTAL GEN FUND EXP Fire Protection Services CITY OF PALM DESERT General Fund Financial Report to October 31, 2021 (Year to date) (YTD Budget based on prior year percentage of actual to budget) 2021-22 Annual Budget 2021-22 YTD Budget 19,879,000 3,822,159 10,337,678 1,883,801 3,371,238 1,003,576 7,598,723 341,908 3,000,000 115,267 634,000 300,009 4,646,960 1,032 3,106,005 1,677,029 2,932,500 55,506,104 9,144,781 2021-22 2021-22 Annual YTD Budget Budget 20,000,359 2,908,891 14,982,431 7,615,500 6,328,350 1,552,224 4,590,125 1,116,958 1,399,750 398,595 3,377,800 907,596 3,715,295 680,520 8,110,435 62,504,545 15,180,284 2021-22 YTD Actual 3,596,599 2,894,072 1,200,731 82,928 126,278 231,723 913 1,918,786 10,052,030 2021-22 YTD Actual Encumb. 1,534,727 18,465,632 6,523,968 1,099,545 1,672,911 1,342,430 1,023,297 1,875,295 404,778 516,247 785,746 427,469 986,480 1,127,414 12,931,907 24,854,032 Total GF Exp and Encumb 37,785,939 17,499,500 81,960 270,109 16,129,864 2021-22 % to YTD Budget Prior YTD Actual 94% 3,028,271 154% 1,551,572 120% 924,275 24% 332,773 110% 120,091 77% 303,322 88% 1,000 114% 1,665,208 0% 110% 7,926,512 2021-22 Prior % to YTD YTD Budget Actual 53% 86% 108% 92% 102% 87% 145% 0% 85% Explanation T Sales Tax for July -August 2021. Prior Year July -August 2020. T Includes payments received through October 31, 2021 for July -September 2021. T Building and Encroachment permits increased from prior year by $308,339 (77%). Receive in January and May of each Fiscal Year. Timing differences for unsecured taxes. T Receive various times during the year. Current average Yield is 0.38%; Prior YTD Yield was ..62%. 1 T Timing differences from various fees. Transfers are done various times during the year. Explanation 2,837,690 1 Current Year includes July 2021 expenditures invoiced; PY includes July &August expenditures. 7,014,755 1 Includes payment of $2.674M to PERS for the City's annual required payment; prior year paid $3.46M 1,597,811 T 1,063,704 1 Landscape Contracts and Medians payments 418,033 813,664 618,319 T 14,363,976 330% 60,301 Variance result of timing difference of Fire Billing, from Riverside County Fire Department. NEW FORMAT CITY OF PALM DESERT General Fund Financial Report - Two Year Comparison Actual to Actual for the two years ended October 31, 2021, and October 31, 2020 Revenues Sales Tax Transient Occupancy Tax License, Permits, & Charges Property Tax Franchise Fees Interest Income and Rent State Subvention All Others InterFund Transfers In TOTAL REVENUES Expenditures Police Services General Government + Contrib Public Works Parks Building and Safety Community Development Economic Development InterFund Transfers Out TOTAL GEN FUND EXP Fire Protection Services 4,000,000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 2021-22 YTD Actual Prior YTD Actual Variance 3,596,599 3,028,271 568,328 2,894,072 1,551,572 1,342,500 1,200,731 924,275 276,456 82,928 332,773 (249,845) 126,278 120,091 6,187 231,723 303,322 (71,599) 913 1,000 (87) 1,918,786 1,665,208 253,578 10,052,030 7,926,512 2,125,519 % Comparison of Prior Year Actual 118.77% 186.53% t 129.91% t 24.92% 105.15% 76.40% 1 91.30% 1 115.23% t 0.00% 126.82% % Comparison 2021-22 YTD of Prior Year Actual Prior YTD Actual Variance Actual 1,534,727 2,837,690 (1,302,963) 54.08% i 6,523,968 7,014,755 (490,787) 1,672,911 1,597,811 75,100 1,023,297 1,063,704 (40,407) 404,778 418,033 (13,255) 785,746 813,664 (27,918) 986,480 618,319 368,161 12,931,907 14,363,976 (1,432,069) 270,109 60,301 209,808 93.00% 0 104.70% t 96.20% 0 96.83% 0 96.57% 0 159.54% t 0.00% 90.03% Explanation Sales Tax for July -August 2021. Prior Year July -August 2020. Includes payments received through October 31, 2021 for July -September 2021. Building and Encroachment permits increased from prior year by $308,339 (77%). Receive in January and May of each Fiscal Year. Timing differences for unsecured taxes. Receive various times during the year. Current average Yield is 0.38%; Prior YTD Yield was .62%. Timing differences from various fees. Transfers are done various times during the year. Explanation Current Year includes July 2021 expenditures invoiced; PY includes July & August expenditures. Includes payment of $2.674M to PERS for the City's annual required payment; prior year paid $3.46M Landscape Contracts and Medians payments 447.93% Variance result of timing difference of Fire Billing, from Riverside County Fire Department 1 • Fy 2021-22 • FY 2020-21 ',FAR Cr1MPARICnN Sales Tax Transient Occupancy Tax License, Permits, & Charges Property Tax Franchise Fees Interest Income and Rent State Subvention All Others InterFund Transfers In Revenues Sales Tax Transient Occupancy Tax License, Permits, & Charges Property Tax Franchise Fees Interest Income and Rent 1 State Subvention All Others 2021-22 Annual Budget CITY OF PALM DESERT General Fund Financial Report TO October 31, 2021 (year to date) YTD Budget based on 2021-22 YTD 2021-22 YTD Budget Actual 19,879,000 6,626,333 10,337,678 3,445,893 3,371,238 1,123,746 7,598,723 2,532,908 3,000,000 1,000,000 634,000 211,333 4,646,960 1,548,987 3,106,005 1,035,335 3,596,599 2,894,072 1,200,731 82,928 126,278 231,723 913 1,918,786 InterFund Transfers In 2,932,500 977,500 TOTAL REVENUES 55,506,104 18,502,035 10,052,030 Expenditures Police Services General Government + Contril Public Works Parks Building and Safety Community Development Economic Development InterFund Transfers Out TOTAL GEN FUND EXP 2021-22 Annual Budget 20,000,359 14,982,431 6,328,350 4,590,125 1,399,750 3,377,800 3,715,295 8,110,435 62,504,545 Fire Protection Services 17,499,500 2021-22 YTD Budget 2021-22 YTD Actual 6,666,786 1,534,727 4,994,144 6,523,968 2,109,450 1,672,911 1,530,042 1,023,297 466,583 404,778 1,125,933 785,746 1,238,432 986,480 2,703,478 20,834,848 12,931,907 Total GF Exp and Encumb 33% of the year complete 2021-22 Prior 0/0 to YTD YTD Budget Actual Explanation 54% 3,028,271 Sales Tax for July -August 2021. Prior Year July -August 2020. 84% 1,551,572 T Includes payments received through October 31, 2021 for July -September 2021. 107% 924,275 T Building and Encroachment permits increased from prior year by $308,339 (77%). 3% 332,773 Receive in January and May of each Fiscal Year. Timing differences for unsecured taxes. 13% 120,091 Receive various times during the year. 110% 303,322 1 Current average Yield is 0.38%; Prior YTD Yield was ..62%. 0% 1,000 1 185% 1,665,208 T 0% - Transfers are done various times during the year. 54% 7,926,512 2021-22 0/0 to YTD Encumb. Budget 18,465,632 1,099,545 1,342,430 1,875,295 516,247 427,469 1,127,414 24,854,032 37,785,939 5,833,167 270,109 16,129,864 Prior YTD Actual 23% 2,837,690 1 Current Year includes July 2021 expenditures invoiced; PY includes July & August expenditures. 131% 7,014,755 1 Includes payment of $2.674M to PERS for the City's annual required payment; prior year paid $3.46M 79% 1,597,811 T 67% 1,063,704 1 Landscape Contracts and Medians payments 87% 418,033 1 70% 813,664 1 80% 618,319 T 0% 62% 14,363,976 5% 60,301 Variance result of timing difference of Fire Billing, from Riverside County Fire Department. ORIGINAL FORMAT CITY OF PALM DESERT General Fund Financial Report to October 31, 2021 (Year to date) Notes to the Financial Reports Notes: 1. Interest earnings are allocated to all funds that have cash balance at year end. 2. Sales Tax is paid in estimated monthly payments and adjusted for each quarter: 1st -Feb. - May, 2nd -June -Aug, 3rd- Sept -Nov, 4th- Nov - Feb. 3. TOT is received on monthly basis in arrears, for example January collection is paid in February. 4. Property Taxes are collected from property owners in December and April bi-annually and paid to the City in January and June. 5. Department of Motor Vehicle fees are paid twice a year by the State on February and June. 6. Franchise Fees are paid through property tax collection from Burtec and are paid in April for Time Warner. Edison and Gas Co. 7. General Gov. includes: City Council, City Clerk, City Attorney, City Manager, Finance, Audit, Human Resources, Information Tech., Insurance 8. Economic Development includes: Community Promotions, Market, Visitor Information, Economic Dev. 9. The Information (unaudited) derived from actual revenues and expenditures received by the City during the respective month -to -date reported and, are accurate as of the date of the report. Changes to the revenue and expenditures could result from the fiscal year end audit, changes in estimates by payer agency's i.e. Ca. Dept. of Fee and Tax. Any changes will be reflected at the next reporting period.