The URL can be used to link to this page

Home My WebLink AboutInvestment Report - July, August, September 2020CITY OF PALM DESERT FINANCE DEPARTMENT INTEROFFICE MEMORANDUM TO: GRACE ROCHA, ACTING CITY CLERK FROM: PATTY LEON, RECORDING SECRETAR DATE: October 27, 2020 SUBJECT: COMPLIANCE ANALYSIS AND INVESTMENT REPORTS Attached are the Compliance Analysis and Investment Reports for July, August and September of 2020 which were presented and approved at the regular meeting of October 27th, 2020 of the Finance Committee. Please include the reports on the next available agenda for review and acceptance by the City Council. Also included is a copy of the approved minutes of the July 28, 2020 meeting for acceptance by the City Council. Please feel free to contact me at Ext. 349 if you have any questions. Thank you. 2 Attachments (as noted) G.\FINANCE\PATTY LEON\FINANCE COMMITTEE\COMMITTEE ADMINISTRATION\MEMOS\INV RPT TO CITY CLERK OCT DOCX Investments CAMP U S. BANK/LAW BOND PROCEEDS LAW GOLDMAN SACHS GOVT FUND MEDIUM -TERM NOTES COMMERCIAL PAPER RIVERSIDE COUNTY POOL GOLDMAN SACHS TREASURY FUND Investments Cash Passbook/Checking (not included in yield calculations) Total Cash and Investments CITY OF PALM DESERT Portfolio Management Portfolio Summary July 31, 2020 Par Market Book % of Days to YTM/C Value Value Value Portfolio Mat/Call Term 365 Equiv. 49,144,30698 49,144.30698 49,144,306.98 19,25 1 1 0.370 4,595,610.52 4.595.61052 4.595,61052 180 1 1 1217 74,881,83263 74,881,832.63 74,881,832.63 29.33 1 1 0.920 2,327,280 61 2,327,280.61 2,327,280.61 0.91 1 1 0.130 40.000,000,00 41017,850.00 39,964.76854 15.65 636 930 1.783 20.000,00000 19,992,600.00 19,856,29722 7.78 61 237 lA06 1,757,478A2 1.757,47842 1,757.47842 069 1 1 0.699 62,823,934.51 62,823,934.51 62,823,934.51 2460 1 1 0 000 255,530,443.67 256,540,893.67 255,351,509.43 100.00% 105 165 0.734 4,080,977.39 259,611,421.06 4,080,977.39 260,621,871.06 4,080.977 39 259,432,486.82 105 0 000 165 0.734 Total Earnings July 31 Month Ending Fiscal Year To Date Current Year 156,973.46 156,973.46 Average Daily Balance 262,614,414.74 Effective Rate of Return 0.70 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. All balances are bank balances. The "0/ of Portfolio' calcul n on the Portfolio uum/m rrry�p+age omits demand deposits J net Moore, Director of Finance Treasurer Reporting period 07/0112020-0713112020 Run Date- 10119=0-16 02 Portfolio CITY AP PM (PRF_PM1) 7.30 Report Ver. 7,3.310 CUSIP Investment# Issuer CAMP CITY OF PALM DESERT Portfolio Management - Portfolio Details - Investments July 31, 2020 Average Purchase Balance Date Par Value Market Value SYS13 13 CA M.P. POOL (CITY) SYS12444 12444 CA M.P POOL (DESERT WILLOW) Subtotal and Average 61,767,440.14 U.S. BANK 1 LAW BOND PROCEEDS 252026003 1233084 LOCAL AGENCY INVESTMENT FUND Subtotal and Average 4,588,065.19 LAW 12000 12000 LOCAL AGENCY INVESTMENT FUND Subtotal and Average 74,386,346.81 GOLDMAN SACHS GOVT FUND 252026000-G 382 GOLDMAN SACHS 252026001-G 383 GOLDMAN SACHS 252026002-G 384 GOLDMAN SACHS 252026003-G 385 GOLDMAN SACHS 252026004-G 386 GOLDMAN SACHS 252026017-G 401 GOLDMAN SACHS 252026018.G 402 GOLDMAN SACHS 260128000-G 404 GOLDMAN SACHS 260128001-G 405 GOLDMAN SACHS 260128002-G 407 GOLDMAN SACHS 260128003-G 408 GOLDMAN SACHS 260128004.G 409 GOLDMAN SACHS 260128005-G 410 GOLDMAN SACHS 260128006-G 412 GOLDMAN SACHS 260128007-G 414 GOLDMAN SACHS 260128008-G 415 GOLDMAN SACHS 260128009-G 416 GOLDMAN SACHS 260128010-G 417 GOLDMAN SACHS 260128011-G 418 GOLDMAN SACHS 261470000-G 419 GOLDMAN SACHS 261470001-G 420 GOLDMAN SACHS 261470002-G 421 GOLDMAN SACHS Subtotal and Average 2,327,280.61 Run Date 10119=0-1602 Page 1 Stated YTM/C Days to Maturity Book Value Rate Moody's 365 Mat/Call Date 47,715,169.71 47,715,16971 47,715,169.71 0370 0.370 1 1,429,137.27 1,429,13727 1,429,137.27 0370 0.370 1 49,144,306.98 49,144,306.98 49,144,306.98 0.370 1 4,595,610S2 4,595,610 52 4,595,610.52 1.217 1.217 1 4,695,610.52 4,596,610.52 4,696,610.52 1.217 1 74,881,832.63 74,881,832.63 74,881,83263 0.920 0.920 1 74,881,832.63 74,881,832.63 74,381,832.63 0.920 1 219.74 219.74 219.74 0.130 Aaa 0130 1 15118 151.18 151.18 0130 Aaa 0130 1 331.85 331.85 331.85 0.130 Aaa 0.130 1 DA5 0.15 0.15 0.130 Aaa 0130 - 1 930.49 930.49 930.49 0.130 Aaa 0.130 1 344.97 344.97 344.97 0.130 Aaa 0 130 1 10,400.15 10,40015 10.400.15 0.130 Aaa 0,130 1 10,831.72 10,83172 10,831.72 0130 Aaa 0.130 1 07101/2019 0.00 000 0.00 0.130 Aaa 0.130 1 07101/2019 0.00 0.00 000 0.130 Aaa 0.130 1 07/01/2019 0.00 0.00 000 0.130 Aaa 0,130 1 07/01/2019 0.00 0.00 0.00 0.130 Aaa 0.130 1 1.10 1.10 1A0 0.130 Aaa 0130 1 0.52 0.52 052 0 130 Aaa 0.130 1 72,963.26 72,96326 72.963.26 0.130 Aaa 0130 1 188,745.29 188.74529 188,745.29 0.130 Aaa 0130 1 07/01/2019 9.01 9.01 9.01 0.130 Aaa 0.130 1 6.07 6.07 6.07 0.130 Aaa 0.130 1 169,652.97 169,652 97 169,652.97 0.130 Aaa 0 130 1 156.75 156.75 156.75 0.130 Aaa 0130 1 10736 107.36 107.36 0.130 Aaa 0 130 1 1,872,42803 1,872,428.03 1,872,428.03 0.130 Aaa 0.130 1 2,327,280.61 2,327,280.61 2,327,280.61 0.130 1 Portfolio CITY AP PM(PRP-PM2)7.30 Report Ver 7 3.3b CUSIP Investment # Issuer MEDIUM -TERM NOTES CITY OF PALM DESERT Portfolio Management Portfolio Details - Investments July 31, 2020 Average Purchase Balance Date Par Value Market Value 037833DL1 614 APPLE, INC. 09111/2019 037833DL1 616 APPLE, INC. 09/25/2019 254687FJO 625 WALT DISNEY COMPANY 1112012019 02665WBG5 615 AMERICAN HONDA FINANCE 09/09/2019 02665WDC2 617 AMERICAN HONDA FINANCE 09127/2019 02665WBF7 623 AMERICAN HONDA FINANCE 11/15/2019 549418BPB 624 MICROSOFT CORPORATION 11/20/2019 Subtotal and Average 39,963,679.96 COMMERCIAL PAPER 62479LH40 622 62479LJ14 631 89233GKW5 632 89233GLW4 633 RIVERSIDE COUNTY POOL Page 2 Stated YTM/C Days to Maturity Book Value Rate Moody's 366 MatlCall Date 5,000,000.00 5,177,250.00 4,998,972.59 1700 As 1.710 771 09/11/2022 10,000,00000 10,354,500.00 9,992,806.38 1700 Aa 1.735 771 09/11/2022 5,000,000.00 5,117,400.00 4,995,916.58 1650 A 1.690 761 09/01/2022 5,000,000.00 5,067,600.00 4,987,316.51 1700 A 1.935 404 09/09/2021 5,000,000.00 5,177,250.00 4,999,962.85 2050 A 2.045 892 01/10/2023 5,000,000.00 5,061,150.00 4,992,317.50 1650 As 1.815 345 07/12/2021 5,000,000.00 5,062,700.00 4,997,476.13 1550 Aaa 1.600 372 08/08/2021 40,000,000.00 41,017,850.00 39,964,768.64 1.783 636 MUFG BANK LTD/NY 11/15/2019 5,000,000.00 5,000,000.00 4,933,884.72 1.810 P-1 1.880 3 08/04/2020 MUFG BANK LTD/NY 03/06/2020 5,000,000.00 4,999,500.00 4,977,625.00 0.900 P-1 0.929 31 09/01/2020 TOYOTA MOTOR CREDIT CORP 03/06/2020 5,000,000.00 4,996,550.00 4,973,555.56 P-1 0.826 90 10/30/2020 TOYOTA MOTOR CREDIT CORP 03/06/2020 5,000,000.00 4,996,550.00 4,971,231.94 P-1 0.795 121 11/30/2020 Subtotal and Average 19,856,297.22 20,000,000.00 19,992,600.00 19,366,297.22 1.106 61 052460 052460 POOLED INVESTMENT FUND Subtotal and Average 1,757,100.66 GOLDMAN SACHS TREASURY FUND 6736302420 498 GOLDMAN SACHS 6736302430 499 GOLDMAN SACHS 6736302440 500 GOLDMAN SACHS 6736302450 501 GOLDMAN SACHS Subtotal and Average 62,869,367.79 Total and Average 262,614,414.74 1,757,478A2 1,757,478.42 1,757,478.42 0699 Aaa 0.699 1 1,767,478.42 1,767,478.42 1,757,478.42 0.699 1 10,998,066.91 10,998,066.91 10,998,066.91 Aaa 0.000 1 21,700,622.57 21,700,622.57 21,700,622.57 Aaa 0.000 1 9.786,22941 9,786,229.41 9,786,229.41 Aaa 0,000 1 20,339,015.62 20,339,015.82 20,339,015S2 Aaa 0.000 1 62,823,934.61 62,823,934.51 62,823,934.51 0.000 1 255,530,443.67 256,540,893.67 255,351,509.43 0.734 105 Portfolio CITY AP Run Date 10/192020-1602 PM (PRF_PM2) 7 3.0 CITY OF PALM DESERT Portfolio Management Portfolio Details - Cash July 31, 2020 Average Purchase CUSIP Investment# Issuer Balance Date UNION BANK CHECKING ACCOUNTS SYS13016 13016 CITY OF PALM DESERT MAIN SYS13013 13013 DESERT WILLOW GOLF COURSE 07/0112019 SYS602 602 PUBLIC SAFETY CHECKING 07/01/2019 SYS13020 13020 RECREATIONAL FACILITIES CORP 07/0112019 Average Balance 0.00 Total Cash and Investments 262,614,414.74 Run Date 10/19R020-1602 Stated YTMIC Days to Par Value Market Value Book Value Rate Moody's 365 Mat./Call 2,705,982.22 2,705,982.22 2,705,982.22 0.000 1 610,652.45 610,65245 610,65245 0,000 1 444,522.62 444,52262 444,522.62 0.000 1 319,820.10 319,820.10 319,820A0 0,000 1 1 259,611,421.06 260,621,871.06 269,432,486.82 0.734 105 Page 3 Portfolio CITY AP PM(PRF PM2)730 CITY OF PALM DESERT LONG-TERM LOANS RECEIVABLE JULY 31, 2020 20-Oct-20 9:05 AM SymPro Book Stated No. Investment Value Maturity Date Interest Rate 1 City Loan to RDA* $ 10,575,462.50 N/A 1.22% 348 EIP Loan ** $ 1,668,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 Revelopment 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 July 31, 2020 Par Market Book % of Days to YTM/C Investments Value Value Value Portfolio Mat/Call Term 366 Equiv. GOLDMAN SACHS TREASURY FUND 4,937,43883 4,93T438.83 4.937,43883 920 1 1 0.000 CAMP 47,763,914.89 47.763.914 89 47.763,914 89 8900 1 1 0.370 LAIF 966,010.49 966.01049 966,010.49 1.80 1 1 1.217 53,667,364.21 53,667,364.21 53,667,364.21 100.00% 1 1 0.351 Investments Cash Passbook/Checking 3,951.007 91 3,951,007.91 3,951.00T91 1 1 0.000 (not included in yield calculations) Total Cash and Investments 57,618,372.12 57,618,372.12 57,618,372.12 1 1 0.351 Total Earnings July 31 Month Ending Fiscal Year To Date Current Year 13,305.58 13,306.58 Average Daily Balance 57,512,650.61 Effective Rate of Return 0.27 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 Housm uthority operations rrr th eexxt six months. All balances are bank balances The "% of Portfolio" calculation on the Portfolio Summary page omits demand deposits. Ja t M oom, Director of Finance/Cit)(Treasurer Reporting period 0710112020.0713112020 Run Date 10119=0 -15.56 Portfolio HA AP PM(PRF PM1)730 Repon Ver. 7.3.31c PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Details - Investments July 31, 2020 _ Average Purchase CUSIP Investment# Issuer Balance Date Par Value GOLDMAN SACHS TREASURY FUND 6736302460 590 GOLDMAN SACHS 4,937,438.83 Subtotal and Average 4,937,438.83 4,937,438.83 CAMP SYS12008 12008 CAASSET MANAGEMENT PROGRAM 47,763,914.89 Subtotal and Average 47,749,382.81 47,763,914.89 LAW SYS21003 21003 LOCAL AGENCY INVESTMENT FUND 966,010A9 Subtotal and Average 964,424.44 966,D10.49 Total and Average 57,512,660.61 53,667,364.21 Run Date 10/19=0-1556 Market Value 4,937,438.83 4,937,438.83 47,763,914.89 47,763,914.89 966,010 49 966,010.49 53A67,364.21 Page 1 Stated Days to YTMlC Maturity Book Value Rate Moody's Mat./Call 365 Date 4,937,438 83 Ass 1 0 000 4,937,438.83 1 0.000 47,763,914.89 0.370 1 0 370 47,763,914.89 1 0.370 966,010 49 1 217 966,010.49 53,667,364.21 1 1 217 1 1.217 1 0.351 Portfolio HA AP PM (PRF PM2)730 Repon Ver. 7.3 3b CUSIP Investment# Issuer CHECKING SYS25015 25015 HOUSING AUTH CHECKING SYS25016 25016 HOUSING AUTH TRUST Average Balance Total Cash and Investments 57, Run Dale. 10/192020 -15 56 PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Details - Cash July 31, 2020 Average Purchase Balance Date Par Value Market Value 3,493,540.41 3,493,540.41 07/01/2019 457,467.50 457,46Z50 0.00 2,660.61 57,618,372.12 67,618,372.12 Page 2 Stated Days to YTM/C Book Value Rate Moody's Mat/Call 366 3,493,540 41 1 0 000 457,467.50 1 0 000 1 61,618,372.12 1 0.361 Portfolio HA AP PM (PRF PM2)730 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Summary July 31, 2020 Investments Par Market Book % of Days to YTM/C Value Value Value Portfolio Mat/Call Term 365 Equiv. RIVERSIDE COUNTY POOL 334.23 334.23 33423 0.00 1 1 0.699 CAMP 5,721.00 5,72100 5.721.00 0.02 1 1 0.370 LAIF 73790 737.90 737.90 0.00 1 1 1.217 US BANK MONEY MARKET ACCT 36,442.792 40 36,442,792.40 36,442,792A0 97.87 1 1 0.010 GOLDMAN SACHS GOVT FUND 786,36042 786,360.42 786.36042 211 1 1 0.130 37,235,945.95 37,235,945.95 37,235,945.95 100.00% 1 1 0.013 Investments Cash Passbook/Checking 1,500,823 83 1,500,823.83 1,500,823 83 1 1 0.000 (not included in yield calculations) Total Cash and Investments 38,736,769.78 38,736,769.78 38,736,769.78 1 1 0.013 Total Earnings July 31 Month Ending Fiscal Year To Date Current Year 268.04 268.04 Average Daily Balance 38,763,849.22 Effective Rate of Return 0.01 This investment portfolio is in compliance with the provisions of California Government Code Section 53601 and the City of Palm Desert investment policy Pursuant to ABX126, the availability of cash to fund the Palm Desert RDA Successor Agency's debt service is dependent upon the County of Riverside and the State of California. All balances are bank balances. The "% of Portfolio" calculation on the Portfolio Summary page omits demand deposits. Jae Dore, FF cer � Reporting period 0710112020-0713112020 Run Dale: 10/19/2020 -16.09 Portfolio RDAS AP PM(PRF PM7)730 Repon Ver 7 3 30 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Investments July 31, 2020 Average Purchase CUSIP Investment# Issuer Balance Date Par Value Market Value RIVERSIDE COUNTY POOL SYS052470 052470 POOLED INVESTMENT FUND 334.23 334.23 Subtotal and Average 334.17 334.23 334.23 CAMP SYS578 578 C.A.M.P. POOL (RDA S.A.) Subtotal and Average LAW SYS604 604 L A LF (RDA SA) Subtotal and Average US BANK MONEY MARKET ACCT 247394001-U 830 US BANK 247394003-U 832 US BANK 247394002-U 833 US BANK 247394000-U 834 US BANK 236781002-U 837 US BANK 236781003-U 838 US BANK 236781000-U 839 US BANK 253446003-U 842 US BANK 253446002-U 843 US BANK 253446000-U 844 US BANK 253446001-U 845 US BANK 224324000-U 853 US BANK 224324001-U 855 US BANK 224324002-U 856 US BANK 224324003-U 857 US BANK Subtotal and Average GOLDMAN SACHS GOVT FUND 277661000-G 811 GOLDMAN SACHS 277861001-G 812 GOLDMAN SACHS 277861002-G 813 GOLDMAN SACHS 277861003-G 814 GOLDMAN SACHS Subtotal and Average Run Dale 10119/2020-1609 5,719.21 736.69 07/01/2019 07/01/2019 36,442,792.40 786,360.42 07/01/2019 G710112019 07101/2019 07/01/2019 07/01/2019 Page 1 Stated Days to YTM/C Maturity Book Value Rate Moody's MatlCall 365 Date 334.23 0.699 Aaa 1 0.699 334.23 1 0.699 5,721.00 5,721.00 5,721.00 0 370 1 0 370 5,721.00 5,721.00 5,721.00 1 0.370 737.90 737.90 737.90 1.217 1 1217 737.90 737.90 737.90 1 1.217 000 0.00 0.00 0.010 P-1 1 0.010 000 0.00 0.00 0.010 P-1 1 0.010 197,504.30 197,504.30 197,504.30 0.010 P-1 1 0,010 870,14781 870,14781 870,147.81 0.010 P-1 1 0.010 2,867,562.82 2,867,562 82 2,867,562.82 0 010 P-1 1 0.010 000 0.00 0.00 0 010 P-1 1 0.010 10,619,204.97 10,619,204.97 10,619,204.97 0010 P-1 1 0,010 0.00 000 0.00 0.010 P-1 1 0.010 1,437,531.36 1,437,53136 1,437,531.36 0.010 P-1 1 0.010 5.521,369.21 5,521,369.21 5,521,369.21 0.010 P-1 1 0.010 0.00 000 0.00 0.010 P-1 1 0.010 10,766.881.03 10,766,881.03 10,766,881.03 0.010 P-1 1 0.010 0.00 0.00 0.00 0.010 P-1 (' 1 0 010 4,162,590.90 4.162,590.90 4,162,590.90 0010 P-1 1 0.010 0.00 0.00 0.00 0.010 P-1 1 0 010 36,442,792.40 36,442,792.40 36,442,792.40 1 0.010 786,360.20 786,360,20 786,360,20 0.130 Aaa 1 0.130 022 022 0.22 0.130 Aaa 1 0.130 07/01/2019 0.00 000 0.00 0.130 Aaa 1 0.130 07/012019 0.00 Goo 0.00 0.130 Aaa 1 0.130 786,360.42 786,360.42 786,360.42 1 0.130 Portfolio RDAS AP PM (PRF_PM2) 7 3 0 Report Ver.7 3.31b CUSIP Run Date IWW020-1609 Investment# Issuer Total and Average RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Investments July 31, 2020 Average Purchase Balance Date Par Value 38,753,849.22 37,235,946.96 Page 2 Stated Daysto YTMIC Market Value Book Value Rate Moody's Mat/Call 365 37,236,945.96 37,235,945.95 1 0.013 Portfolio RDAS AP PM (PRP_PM2) 7 3 0 RDA SUCCESSOR AGENCY Portfolio Management Page Portfolio Details - Cash July 31, 2020 Average Purchase Stated Daysto YTMlC CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate Moody's MatJCall 365 UNION BANK CHECKING ACCOUNTS SYS582 582 RDA SUCCESSOR AGENCY 1,500,823.83 1,500,823 83 1,500,823.83 1 0,000 Average Balance 0.00 1 Total Cash and Investments 38,763,849.22 38,736,769.78 38,736,769.78 38,736,769.78 1 0.013 Run Date. 10119 020-1609 Portfolio RDAS AP PM (PRF_PM2) 7 3 0 PALM DESERT RDA SUCCESSOR AGENCY LONG-TERM LOANS RECEIVABLE JULY 31, 2020 20-Oct-20 9:06 AM SymPro Book No. Investment Value 738 EIP Loan * $ 668,000.00 Footnotes EIP balance adjustments made on March 2 and September 2 of each year. Maturity Date 09/02/29 Stated Interest Rate 3.00% Investments Par Value CAMP 42,752,123.49 U.S. BANK/ LAIF BOND PROCEEDS 4,595,610.52 LAIF 74,881,832.63 GOLDMAN SACHS GOVT FUND 5,484,917.49 MEDIUM -TERM NOTES 40.000,000 00 COMMERCIAL PAPER 15.000.000.00 RIVERSIDE COUNTY POOL 6.457.478.42 GOLDMAN SACHS TREASURY FUND 62,762,485.55 251,934,448.10 Investments Cash Passbook/Checking 6,969,065.24 (not included in yield calculations) Total Cash and Investments 258,903,513.34 CITY OF PALM DESERT Portfolio Management Portfolio Summary August 31, 2020 Market Book % of Daysto YTM/C Value Value Portfolio MatlCall Term 365 Equiv. 42,752,123.49 42,752,123.49 16.98 1 1 0.300 4,595,610.52 4,595,610.52 1.82 1 1 0.784 74.881,832,63 74,881,832.63 29.74 1 1 0.784 5,484,917.49 5.464.917.49 2.18 1 1 0.020 40,935,200.00 39,967,095.91 15.87 605 930 1.783 14,997,000.00 14,922,412.50 5.93 50 229 0.850 6,457,478.42 6,457,478.42 2.56 1 1 0626 62.762.485.55 62,762,405.55 24.92 1 1 0.000 252,867,648.10 251,823,956.511 100.00% 100 162 0.648 6,969,065.24 6,969,065.24 1 1 0.000 269,836,713.34 258,793,021.75 100 162 0.648 Total Earnings August3l Month Ending Current Year 139,890.53 Average Daily Balance 256,884,400.88 Effective Rate of Return 0.64 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. All balances are bank balances. The "% of Portfolio" calculation on 6rifolio Summa page o Is dipmand deposits. Janet M. Moor , Dir ctor of Finaf celcily Treasuret Reporting period 08101/2020-08131/2020 Run Dale: 10r192020-17:15 No fiscal year history available Portfolio CITY AP PM (PRI-_PMI) 7.30 Report Ver 733b CUSIP Investment# Issuer CAMP CITY OF PALM DESERT Portfolio Management Portfolio Details - Investments August 31, 2020 Average Purchase Balance Date Par Value Market Value SYS13 13 C.A.M.P. POOL (CITY) SYS12444 12444 C A.M.P. POOL (DESERT WILLOW) Subtotal and Average 46,442,762.67 U.S. BANK / LAW BOND PROCEEDS 252026003 1233084 LOCALAGENCY INVESTMENT FUND Subtotal and Average 4,695,610.62 LAW 12000 12000 LOCAL AGENCY INVESTMENT FUND Subtotal and Average 74,881,832.63 GOLDMAN SACHS GOVT FUND 252026000-G 382 GOLDMAN SACHS 252026001-G 383 GOLDMAN SACHS 252026002-G 384 GOLDMAN SACHS 252026003-G 385 GOLDMAN SACHS 252026004-G 386 GOLDMAN SACHS 252026017-G 401 GOLDMAN SACHS 252026018-G 402 GOLDMAN SACHS 260128000-G 404 GOLDMAN SACHS 260128001-G 405 GOLDMAN SACHS 260128002-G 407 GOLDMAN SACHS 260128003-G 408 GOLDMAN SACHS 260128004-G 409 GOLDMAN SACHS 260128005-G 410 GOLDMAN SACHS 260128006-G 412 GOLDMAN SACHS 260128007-G 414 GOLDMAN SACHS 260128008-G 415 GOLDMAN SACHS 260128009-G 416 GOLDMAN SACHS 260128010-G 417 GOLDMAN SACHS 260128011-G 418 GOLDMAN SACHS 26147000D-G 419 GOLDMAN SACHS 261470001-G 420 GOLDMAN SACHS 261470002-G 421 GOLDMAN SACHS Subtotal and Average 3,072,856.38 Run Date_ 10/19=20 -1718 Page 1 Stated YTM/C Days to Maturity Book Value Rate Moody's 365 MatJCall Date 42,022,688.44 42,022,688.44 42,022,688.44 0.300 0.300 1 729,435.05 729.435.05 729,435.05 ' 0.300 0.300 1 42,752,123.49 42,752,123.48 42,752,123.49 _ 0.300 1 4.595,610.52 4,595.610 52 4.595,610.52 0.784 0.764 1 4,595,610.52 4,595,610.62 4,595,610.62 0.784 1 74.881,832.63 74,881,832.63 74,8B1,832.63 0.784 0.784 1 74,881,832.63 74,881,832.63 74,881,832.63 0.784 1 0.00 000 0.00 0.020 Aaa 0.020 1 730.562.50 730.562 50 730,562 50 0.020 Aaa 0.020 1 1,030,000.00 1,030,00000 1.030,000.00 0.020 Aaa 0.020 1 0.15 0.15 0.15 0 020 Aaa 0.020 1 930.60 930.60 930.60 0.020 Aaa 0.020 1 345.01 345.01 34501 0.020 Aaa 0.020R 1 10,401.42 10.401.42 10,401A2 0.020 Aaa 0.020 1 10.833.04 10,833.04 10,833.04 0.020 Aaa 0.020 1 07/01/2019 000 000 0.00 0.020 Aaa 0 020 1 07/01/2019 0.00 0.00 0.00 0.020 Aaa 0 020 1 07/01/2019 0.00 0.00 0.00 0.020 Aaa 0.020 1 07/01/2019 0.00 0.00 0.00 0.020 Aaa 0.020 1 0.00 0.00 0.00 0.020 Aaa 0.020 1 92,362.50 92,362.50 92,362.50 0.020 Aaa 0020 1 0.00 0.00 0.00 0.020 Aaa 0.020 1 188,768.37 188,76E 37 188.768.37 0020 Aaa 0.020 1 07/01/2019 0.00 0.00 0.00 0.020 Aaa 0.020 1 124,165.64 124.165.64 124,165.64 0.020 Aaa 0.020 1 169.673.71 169.673.71 169,673.71 0.020 Aaa 0.020 1 0.09 0.09 0.09 0.020 Aaa 0.020 1 1.254.217.50 1,254,217.50 1.254.217.50 0020 Aaa 0.020 1 1.872.656.96 1.872,656.96 1,872,656.96 0020 ' Aaa 0.020 1 5,484,917.49 5,484,917.49 6,484,917.49 0.020 1 Portfolio CITY AP PM (PRF_PM2) 7 3.0 Report Ver. 7.3 3b CUSIP Investment# Issuer MEDIUM -TERM NOTES CITY OF PALM DESERT Portfolio Management Portfolio Details - Investments August 31, 2020 Average Purchase Balance Date Par Value Market Value 037833DL1 614 APPLE, INC. 09/1112019 037833DL1 616 APPLE, INC. 09/25/2019 254687FJO 625 WALT DISNEY COMPANY 11120/2019 02665WBG5 615 AMERICAN HONDA FINANCE 09/0912019 02665WDC2 617 AMERICAN HONDA FINANCE 09/27/2019 02665WBF7 623 AMERICAN HONDA FINANCE 11/15/2019 549418BP8 624 MICROSOFT CORPORATION 11/20/2019 Subtotal and Average 39,966,007.31 COMMERCIAL PAPER 62479LJ14 631 89233GKW5 632 89233GLW4 633 Page 2 Stated YTM/C Days to Maturity Book Value Rate Moody's 365 Mat./Call Date 5,000,000.00 5,149,100.00 4,999,013.15 1.700 Aa 1.710 740 09/11/2022 10,000,000m 10,298,200.00 9,993,09D.34 1.700 As 1.735 740 09/11/2022 5,000,000.00 5,125,450.00 4,996,07992 1.650 A 1.690 730 09/01/2022 5,000,000.00 5,067,200.00 4,988,27256 1.700 A 1935. 373 09/09/2021 5,000,000.00 5,185.10000 4,999,964.12 2.050 A 2.045 861 01/10/2023 5,000,000.00 5,054,150.00 4,992,993.38 1.650 Aa 1.815 314 07/12/2021 5,000,00000 5,057,000.00 4,997,68244 1.550 Aaa 1.600 341 08/08/2021 40,000,000.00 40,936,200.00 39,967,095.91 1.783 605 MUFG BANK LTD/NY 03/062020 5,000,000.00 5,000,000.00 4,977,625.00 0900 P-1 0929 0 09/012020 TOYOTA MOTOR CREDIT CORP 03/06/2020 5,000,000.00 4,998,85D.00 4,973,555.56 P-1 0.826 59 10/30/2020 TOYOTA MOTOR CREDIT CORP 03/0612020 5,000,000.00 4.998,15000 4,971,231.94 P-1 0.795 90 11/30/2020 Subtotal and Average 16,399,885.21 16,000,000.00 14,997,000.00 14,922,412.60 0.850 50 RIVERSIDE COUNTY POOL 052460 052460 POOLED INVESTMENT FUND Subtotal and Average 5,547,801.00 GOLDMAN SACHS TREASURY FUND 6736302420 498 GOLDMAN SACHS 6736302430 499 GOLDMAN SACHS 6736302440 500 GOLDMAN SACHS 6736302450 501 GOLDMAN SACHS Subtotal and Average 62,803,614.64 Total and Average 256,884,400.88 Run Date: 10/192020 -1718 6,457,478.42 6,457,478.42 6,457,478A2 0.626 Are 0.626 1 6,457,478.42 6,457,478.42 6,457,478.42 0.626 1 10,970,748.44 10.970.74844 10,970,748.44 Aaa 0.000 1 21,666,348.71 21,665,348.71 21,665,348.71 Aaa 0.00D 1 9,786,600.78 9,786,600.78 9,786,600.78 Aaa 0000 1 20,339,78T62 20,339,78762 20,339,787.62 Aaa 0000 1 62,762,485.55 62,762,485.55 62,762,485.55 0.000 1 261,934,448.10 262,867,648.10 251,823,956.51 0.648 100 Portfolio CITY AP PM (PRF_PM2) 7 3 0 CITY OF PALM DESERT Portfolio Management Portfolio Details - Cash August 31, 2020 Average Purchase Stated YTM/C Days to CUSIP Investment 0 Issuer Balance Date Par Value Market Value Book Value Rate Moody's 365 Mat./Call UNION BANK CHECKING ACCOUNTS SYS13016 13016 CITY OF PALM DESERT MAIN 5,087,716 61 5,087,716.61 5,087,716.61 0.000 1 SYS13013 13013 DESERT WILLOW GOLF COURSE 07/01/2019 817,321.16 817.321.16 817,321.16 0.000 1 SYS602 602 PUBLIC SAFETY CHECKING 07/0112019 718,385.05 718.385.05 718,385.05 0.000 1 SYS13020 13020 RECREATIONAL FACILITIES CORP 07/01/2019 345,64242 345,642.42 345,642.42 0.000 1 Average Balance 0.00 1 Total Cash and Investments 256,894,400.88 258,963,613.34 259,836,713.34 268,793,021.76 0.648 100 Run Date_ 10/19=0 - 17 18 Page 3 Portfolio CITY AP PM (PRF_PM2) 7.3 0 20-Oct-20 9:49 AM SymPro No. Investment 1 City Loan to RDA* 348 EIP Loan ** 594 Highlands Utility Undergrounding *** Assessment District 04-01 Deferred Loan CITY OF PALM DESERT LONG-TERM LOANS RECEIVABLE AUGUST 31, 2020 Book Stated Value Maturity Date Interest Rate $ 10,575,462.50 N/A 1.22% $ 1,668,000.00 09/02/34 7.00% $ 14,977.73 09/02/36 - 5.35% Footnotes * On May 17, 2019, the California 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 that 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 August,31, 2020 Par Market Book %of Daysto Investments Value Value Value Portfolio Term 365 Equiv. GOLDMAN SACHS TREASURY FUND 4,937,62625 4,937,626.25 4,937,626.25 9.20 1 1 0.000 y CAMP 47,776,036.21 47,776,036.21 47,776,036.21 a9.00 1 1 0.300 LAIF 966,010.49 966,010.49 966,010.49 1.80 1 1 0.784 53,679,672.95 53,679,672.95 53,679,672.95 100.00% 1 1 0.281 Investments Cash Passbook/Checking 3,993,765.64 3,993,765.64 3,993.76564 1 1 0000 (not included in yield calculabons) Total Cash and Investments 57,673,438.59 57,673,438.59 57,673,438.59 1 1 0.281 Total Earnings August 31 Month Ending Current Year 11,722.04 Average Daily Balance 57,620,317.74 Effective Rate of Return 0.24 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�A t6ontty/operations for the npxt six months. All balances are bank balances. The "% of Portfolio" calculation on the Portfolio Summary page omits demand deposits. Ja . M ore, Director of Finance/City Trkasurer Reporting period 08/0112020-08131/2020 Run Date: 10/192020-IT23 . No fiscal year history available Portfolio HA AP PM(PRF PM7)7.30 Report Ver. 7.3 3b PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Details - Investments August 31, 2020 Average Purchase CUSIP Investment# Issuer Balance Date GOLDMAN SACHS TREASURY FUND 6736302460 590 GOLDMAN SACHS Subtotal and Average 4,937,614.16 CAMP SYS12008 LAIF SYS21003 Run Date 10/192020-1730 12008 CA ASSET MANAGEMENT PROGRAM Subtotal and Average 47,764,305.90 21003 LOCAL AGENCY INVESTMENT FUND Subtotal and Average 966,010.49 Total and Average 57,620,317.74 Par Value 4,937,626.25 4,937,626.26 47,776,036.21 47,776,036.21 966,010.49 966.010.49 53,679,672.95 Market Value 4,937,626.25 4,937,626.25 47.776,036 21 47,776,036.21 966,010.49 966,010.49 53,679,672.95 Page 1 Stated Daysto YTMIC Maturity Book Value Rate Moody's Mat/Call 366 Date 4,937,626.25 Aaa 1 0.000 4,937,626.25 1 0.000 47,776,036.21 0 300 1 0.300 47,776,036.21 1 0.300 966.010.49 0.784 966,010.49 53,679,672.95 1 0.784 1 0.784 1 0.281 Portfolio HA AP PM (PRF_PM2) 7.3.0 Repon Ver.7.3 3b CUSIP Investment# Issuer CHECKING SYS25015 25015 HOUSING AUTH CHECKING SYS25016 25016 HOUSING AUTH TRUST Average Balance Total Cash and Investments 57, Run Date: 10/19=0-17 30 PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Details - Cash August 31, 2020 Average Purchase ' Balance Date Par Value Market Value 3,536,897A4 3,536,897.14 07/01/2019 456.868.50 456,868.50 0.00 !0,317.74 67,673,438.59 57,673,438.59 Page 2 Stated Daysto YTM/C Book Value Rate Moody's MatJCall- 365 3,536,897.14 _ 1 0.000 456,868.50 1 0.000 1 57,673,438.69 1 0.281 Portfolio HA AP PM (PRF PM2) 7.3 0 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Summary August 31, 2020 Par Market Book % of Daysto YTM/C Investments Value Value Value Portfolio Mat/Call Term 365 Equiv. RIVERSIDE COUNTY POOL 334.23 334.23 334.23 0.00 1 1 0.626 CAMP 5.722.45 5.722.45 5.72245 0.02 1 1 0.300 LAIF 737.90 737.90 737.90 0.00 1 1 0.784 US BANK MONEY MARKET ACCT 36,442,961.67 36,442,961:67 36,442,961.67 98.89 1 1 0.010 GOLDMAN SACHS GOVT FUND 401,953.43 401.953.43 401,953.43 1.09 1 1 0.020 36,851,709.68 36,851,709.68 36,851,709.68 100.00% 1 1 0.010 Investments Cash Passbook/Checking 1,115,496A5 1,115,496.15 1,115,496.15 1 1 0.000 (not included in yield calculations) Total Cash and Investments 37,967,206.83 37,967,206.83 37,967,205.83 1 1 0.010 Total Earnings August 31 Month Ending Current Year 217.80 Average Daily Balance 38,364,892.59 Effective Rate of Return 0.01 % This investment portfolio is in compliance with the provisions of California Government Code Section 53601 and the City of Palm Desert investment policy. Pursuant to ABX126, the availability of cash to fund the Palm Desert RDA Successor Agency's debt service is dependent upon the County of Riverside and the State of California. All balances are bank balances. The "% of Portfolio" calculation on the Portfolio Summary page omits demand deposits. _ net . Moore, Finance Officer Reporting period 0810112020-0813112020 1��Oe Run Date 1011MO20-1745 No fiscal year history available Portfolio RDAS AP PM(PRF PM1)T30 Report Ver 7.3.34 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Investments August 31, 2020 Average Purchase CUSIP Investment# Issuer Balance Date Par Value Market Value RIVERSIDE COUNTY POOL SYS052470 052470 POOLED INVESTMENT FUND Subtotal and Average 334.23 CAMP SYS578 578 C.A.M.P. POOL (RDA S.A) Subtotal and Average 5,721.05 LAIF SYS604 604 L A.I.F.(RDA SA.) Subtotal and Average 737.90 US BANK MONEY MARKET ACCT 247394001-U 830 US BANK 247394003-U 832 US BANK 247394002-U 833 US BANK 247394000-U 834 US BANK 236781002-U 837 US BANK 236781003-U 838 US BANK 236781000-U 839 US BANK 253446003-U 842 US BANK 253446002-U 843 US BANK 2534460OD-U 844 US BANK 253446001-U 845 US BANK 224324000-U 853 US BANK 224324001-U 855 US BANK 224324002-U 856 US BANK 224324003-U 857 US BANK Subtotal and Average 36,442,951.61 GOLDMAN SACHS GOVT FUND 277861000-G 811 GOLDMAN SACHS 277861001-G 812 GOLDMAN SACHS 277861002-G 813 GOLDMAN SACHS 277861003-G 814 GOLDMAN SACHS Subtotal and Average 426,763.90 Run Date: 10/192020 -1745 0710112019 07/01/2019 07/01/2019 07/01/2019 07/01/2019 07/01/2019 07101/2019 07/01/2019 07/01/2019 33423 334.23 5.722.45 6,722.45 737.90 737.90 0.00 0.00 197,505.22 870,151.85 2,867,576A4 000 10.619,254 29 000 1.437.538 04 5,521,394.86 0.00 10,766.931.04 0.00 4,162,610.23 0.00 36,442,961.67 401,953.43 0.00 0.00 0.00 401,953.43 334.23 334.23 5.722.45 6,722.45 737.90 737.90 000 000 197,505.22 870,151 85 2.867,576.14 0.00 10.619.254 29 0.00 1.437.538 04 5,521,394.86 0.0D 10.766,931.04 000 4.162,610.23 000 36,442,961.67 401,953.43 0.00 0.00 0.00 401,953.43 Page 1 Stated Days to YTM/C Maturity Book Value Rate Mcody's MatJCall 365 Date 334.23 0 626 Aaa 1 0.626 334.23 1 0.626 5,722.45 0.300 5,722.45 73790 0.784 737.90 000 0.010 P-1 0 Co 0.010 P-1 197.505 22 0.010 P-1 870,151 85 0.010 P-1 2,867,576A4 0.010 P-1 0.00 0 010 P-1 10.619,254.29 0.010 P-1 0.00 0.010 P-1 1437,538.04 0.010 P-1 5,521,394.86 0.010 P-1 0.00 0.010 P-1 10.766.931.04 0.010 P-1 0.00 0.010 P-1 4,162,610.23 0.010 P-1 0.00 0.010 P-1 36,442,961.67 401.953.43 0.020 Ass 0.00 0 020 Are 0.00 0 020 Ass 0.00 0.020 Ass 401,953.43 1 0 300 1 0.300 1 0.784 1 0.784 i 0.010 1 0.010 1 0.010 1 0.010 1 0.010 1 0.010 1 0.010 1 0010 1 0 010 1 0.010 1 0.010 1 0.010 1 0.010 1 0.010 1 0.010 1 0.010 1 0.020 1 0 020 1 0.020 1 0 020 1 0.020 Portfolio RDAS AP PM (PRF_PM2) 7.3.0 Report Ver. 7.3 3b CUSIP Run Date: 10119R020-17.45 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Investments August 31, 2020 Average Purchase Stated Days to YTMIC Investment# Issuer Balance Date Par Value Market Value Book Value Rate Moody's Mat/Call 365 Total and Average 38,364,892.59 36,851,709.68 36,851,709.68 36,851,709.68 1 0.010 Page 2 Portfolio RDAS AP PM (PRF_PM2) 7.3.0 CUSIP Investment# Issuer UNION BANK CHECKING ACCOUNTS SYS582 582 RDA SUCCESSOR AGENCY I:arlryl[;O/i41rLYL16fK9] RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Cash August 31, 2620 Average Purchase Balance Date Par Value Market Value 1,115,496.15 1,115,496.15 Average Balance 0.00 Total Cash and Investments 38,364,892.69 37,967,205.83 37,967,205.83 Page 3 Stated Days to YTMIC Book Value Rate Moody's Mat./Call 365 1,115,496.15 1 0.000 1 37,967,205.83 1 0.010 Portfolio RDAS AP PM(PRP PM2)730 20-Oct-2o 9:49 AM SymPro No. 738 * Investment EIP Loan * Footnotes EIP balance adjustments made on March 2 and September 2 of each year. PALM DESERT RDA SUCCESSOR AGENCY LONG-TERM LOANS RECEIVABLE AUGUST 31, 2020 Book Value Maturity Date 09/02/29 Stated Interest Rate 3.00% CITY OF PALM DESERT Portfolio Management Portfolio Summary 'September 30, 2020 Par Market Book %of Daysto YTM/C Investments Value Value Value Portfolio Mat/Call Term 365 Equiv. CAMP 4,655,621.32 4,655,621.32 4.655,62132 1.89 1 1 0.270 U.S. BANK/ LAIF BOND PROCEEDS 4,595,61052 4,595,610.52 4,595,610-52 1.86 1 1 0.685 LAIF 74,881,832.63 74,881,832.63 74.881.83263 30.39 1 1 0.685 GOLDMAN SACHS GOUT FUND 2,258,937.49 2,258,937.49 2,258,937.49 0.92 1 1 0.030 MEDIUM -TERM NOTES 40.000.000.00 40,936,200.00 39,969,423.25 16.22 575 930 1.783 COMMERCIAL PAPER 10,000,000.00 9,997,000.00 9,944,787.50 4.04 44 253 0.811 RIVERSIDE COUNTY POOL 47,360,826.89 47,360.826 89 47,360,826.89 19.22 1 1 0.527 GOLDMAN SACHS TREASURY FUND 62,766,862.57 62,766,862.57 62,766,862.57 25.47 1 1 0.010 246,519,691.42 247,452,891.42 246,433,902.17 100.00% 96 162 0.662 Investments Cash Passoock/Checking 5,742,12070 5.742.12070 5,742,120.70 1 1 0.000 (not included in yield calculations) Total Cash and Investments 252,261,812.12 263,195,012.12 252,176,022.87 96 162 0.652 Total Earnings September 30 Month Ending Current Year 128,700.85 Average Daily Balance 249,129,406.60 Effective Rate of Return 0.63 % 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. All balances are bank balances. The "% of Portfolio" calculation on the Polljollo Summa pageomits demand deposits. � 4 /0/:- / /04�) Janet M. Moore, tor of Finance%City Treasurer Reporting period Run Date: 10/19)2020-19.26 No fiscal year history available Portfolio CITY AP PM (PRF_PM1) 7.3.0 Repon Ver. 7.33b CUSIP Investment# Issuer CAMP CITY OF PALM DESERT Portfolio Management Portfolio Details - Investments September 30, 2020 Average Purchase Balance Date Par Value Market Value SYS13 13 C.AM.P. POOL (CITY) SYS12444 12444 C.AM.P. POOL (DESERT WILLOW) Subtotal and Average 15,372,240.08 U.S. BANK / LAW BOND PROCEEDS 252026003 1233084 LOCAL AGENCY INVESTMENT FUND Subtotal and Average 4,695,610.62 LAW 12000 12000 LOCAL AGENCY INVESTMENT FUND Subtotal and Average 74,881,832.63 GOLDMAN SACHS GOVT FUND 252026000-G 382 GOLDMAN SACHS 252026001-G 383 GOLDMAN SACHS 252026002-G 384 GOLDMAN SACHS 252026003.G 385 GOLDMAN SACHS 252026004-G 386 GOLDMAN SACHS 252026017-G 401 GOLDMAN SACHS 252026018-G 402 GOLDMAN SACHS 260T28000-G 404 GOLDMAN SACHS 260128001-G 405 GOLDMAN SACHS 260128002-G 407 GOLDMAN SACHS 260128003-G 408 GOLDMAN SACHS 260128004-G 409 GOLDMAN SACHS 260128005-G 410 GOLDMAN SACHS 260128006-G 412 GOLDMAN SACHS 260128007-G 414 GOLDMAN SACHS 260128008-G 415 GOLDMAN SACHS 260128009-G 416 GOLDMAN SACHS 260128010-G 417 GOLDMAN SACHS 260128011-G 418 GOLDMAN SACHS 261470000-G 419 GOLDMAN SACHS 261470001-G 420 GOLDMAN SACHS 261470002-G 421 GOLDMAN SACHS Subtotal and Average 2,309,010.18 Run Date-101192020 -18 25 Page 1 Stated YTM/C Days to Maturity Book Value Rate Moody's 365 MatJCall Date 3,926.022.37 3,926,022.37 3.926.02237 0270 0.270 1 729,598.95 729,598.95 729.598.95 0.270 0.270 1 4,665,621.32 4,665,621.32 4,655,621.32 0.270 1 4,595.610.52 4.595.610 52 4,595,610.52 0.685 0.685 1 4,695,610.62 4,595,610.52 4,695,610.52 0.685 1 74,881,83263 74,881,83263 74,881,832.63 0.685 0.685 1 74,881,832.63 74,881,832.63 74,881,832.63 0.686 1 0.00 0.00 0.00 0.030 Aaa 0.030 1 056 0.56 0.56 0.030 Aaa 0.030 1 0.79 0.79 0.79 0.030 Aaa 0 030 1 0.15 0.15 0.15 0.030 Aaa 0 030 1 930.60 930.60 930.60 0.030 Aaa 0.030 1 362.91 362.91 362.91 0.030 Aaa 0.030 1 10.402.14 10.402.14 10,402A4 0.030 Aaa 0.030 1 15,965 05 15.965.05 15,96&05 0.010 Aaa 0.010 1 07/01/2019 0.00 0.00 0 00 0.030 Aaa 0.030 1 07/01/2019 0.00 000 000 0 030 Aaa 0.030 1 07/01/2019 0.00 000 0.00 0 030 Aaa 0.030 1 07/01/2019 0.00 000 0.00 0.030 Aaa 0 030 1 5.40 5.40 5.40 0.030 Aaa 0 030 1 000 0.00 0.00 0.030 Aaa 0 030 1 000 0.00 0.00 0.030 Aaa 0 030 1 188,781.52 188.781.52 188.781.52 0.030 Aaa 0.030 1 07/01/2019 1.20 1.20 1.20 0.030 - Aaa 0.030 1 0,829.63 8,829.63 8,829.63 0030 Aaa 0.030 1 - 160.85626 160,856.26 160.856.26 0.030 Aaa 0.030 1 12.83 12.83 1283 0.030 Aaa 0.030 1 98,603 39 98,603.39 98,603.39 0.030 Aaa 0.030 1 1,774,185.00 1,774,185.00 1,774,18500 0.030 Aaa 0.030 1 2,258,937.43 2,258,937.43 2,258,937.43 0.030 1 Portfolio CITY AP PM (PRF_PM2) T30 Report Ver, T3 31b CUSIP Investment#. Issuer MEDIUM -TERM NOTES CITY OF PALM DESERT Portfolio Management - Portfolio Details - Investments September 30, 2020 Average Purchase Balance Date Par Value Market Value 037833DL1 614 APPLE, INC. 09/11/2019 037833DL1 616 APPLE, INC. 09/25/2019 254687FJO 625 WALT DISNEY COMPANY 11/20/2019 02665WBG5 615 AMERICAN HONDA FINANCE 09/09/2019 02665WDC2 617 AMERICAN HONDA FINANCE 09/27/2019 02665WBF7 623 AMERICAN HONDA FINANCE 11/1512019 549418BP8 624 MICROSOFT CORPORATION 11/20/2019 Subtotal and Average 39,968,298.37 COMMERCIAL PAPER 89233GKW5 632 TOYOTA MOTOR CREDIT CORP 03/062020 89233GLW4 633 TOYOTA MOTOR CREDIT CORP 03/06/2020 Subtotal and Average 9,944,787.50 RIVERSIDE COUNTY POOL 052460 052460 POOLED INVESTMENT FUND Subtotal and Average 32,362,597.60 GOLDMAN SACHS TREASURY FUND 6736302420 498 GOLDMAN SACHS 6736302430 499 GOLDMAN SACHS 6736302440 500 GOLDMAN SACHS 6736302450 501 GOLDMAN SACHS Subtotal and Average 62,766,862.67 Total and Average 249,129,406.54 Page 2 Stated YTM/C Daysto Maturity Book Value Rate Moody's 365 Mat/Call Date 5,000,000.00 5,149,100.00 4,999,053.70 1.700 As 1.710 710 09/11/2022 10,000,000.00 10,298,200.00 9,993,374.30 1.700 As 1735 710 09/11/2022 5,000,000.00 5,125,450.00 4,996.24326 1650 A 1690 700 09/01/2022 5,000,000.00 5,067,200.00 4,989,22860 1.700 A 1935 343 09/09/2021 5,000,000.00 5,185,100.00 4.999.965.38 2050 A 2.045 831 01/10/2023 fixo.000.00 5,054,160.00 4.993.66926 1.650 As 1.815 284 07/12/2021 5,000,000.00 5,057,000.00 4.997.888.75 1.550 Aaa 1.600 311 081OW021 40,000,000.00 40,936,200.00 39,969,423.25 1.783 576 5,000,000.00 4,998,850.00 4.973.555.56 P-1 0.826 29 10/302020 5,000,000.00 4,998,150.00 4,971,231.94 P-1 0795 60 11/302020 10,000,000.00 9,997,000.00 9,944,787.60 0.811 44 47,360,826.89 47,360,826.89 47,360,826.89 0.527 Aaa 0527 1 47,360,826.89 47,360,826.89 47,360,826.89 0.527 1 10,971,514.48 10,971,514.48 10,971,514.48 0.010 Aaa 0.010 1 21,666,860.48 21,666,860.48 21,666,860.48 0.010 Aaa 0.010 1 9,787,282.75 9,787,282.75 9.787.282.75 0.010 Aaa 0.010 1 20,341,204.86 20,341,204.86 20,341,204.86 0.010 Aaa 0.010 1 62,766,862.57 62,766,862.57 62,766,862.57 0.010 1 246,519,691.36 247,452,891.36 246,433,902.11 0.652 96 Portfolio CITY AP Run Date 10/19r2020-1825 - PM (PRF_PM2) 7,30 CITY OF PALM DESERT Portfolio Management Portfolio Details - Cash September 30, 2020 Average Purchase CUSIP Investment# Issuer Balance Date Par Value Market Value UNION BANK CHECKING ACCOUNTS SYS13016 13016 CITY OF PALM DESERT MAIN SYS13013 13013 DESERT WILLOW GOLF COURSE 07/01/2019 SYS602 602 PUBLIC SAFETY CHECKING 07/01/2019 SYS13020 13020 RECREATIONAL FACILITIES CORP 07/01/2019 Average Balance 0.00 Total Cash and Investments 249,129,406.54 Run Date. 10/192020-1825 3,805,706.93 607,896 03 929,731.41 398,786.33 3.805.706 93 607,896 03 929,731.41 398,786.33 Page 3 Stated YTM/C Days to Book Value Rate Moody's 365 Mat./Call 3,805,706 93 607,896.03 929,731.41 398,786.33 252,261,812.06 253,196,012.06 262,176,022.81 0 000 0 000 0.000 0 000 0A52 1 1 1 7 1 96 Portfolio CITY AP PM (PRF_PM2)7.3 0 CITY OF PALM DESERT LONG-TERM LOANS RECEIVABLE SEPTEMBER 30, 2020 20-Oco-20 9:51 AM SymPro Book Stated No. Investment Value Maturity Date Interest Rate 1 City Loan to RDA* $ 10,575,462.50 N/A 1.22% 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 SuccessorAgency.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, 2020 Par Market Book % of Days to YTM/C Investments Value Value Value . Portfolio Mat/Call Term 365 Equiv. GOLDMAN SACHS TREASURY FUND 4,937,970 30 4,937,970.30 4.937.970.30 9.20 1 1 0.270 CAMP 47,786,770.95 47.786.770.95 47,786,770.95 89.00 1 1 0.270 LAIF 966,010.49 966,010.49 966.010.49 1.80 1 1 0.685 53,690,751.74 53,690,751.74 53,690,751.74 100.00% 1 1 0.277 Investments Cash Passbook/Checking, 3,904,980 03 3,904,980.03 3,904,980.03 1 1 0.000 (not included in yield calculations) Total Cash and Investments 57,595,731.77 57,595,731.77 57,595,731.77 1 1 0.277 Total Earnings September 30 Month Ending Current Year 12,242.12 Average Daily Balance 57,671,180.94 Effective Rate of Return 0.26% 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 bankgalanc . The "% of Portfolio" calculation on the Portfolio Summary page omits demand deposits. Janet M. Moore ire for of Finance/City Tr asurer / Reporting period 09101/2020-0913012020 Run Date 1011912020-18:14 No fiscal year history available Portfolio HA AP PM (PRF_PM1) 7.3 0 Report Ver. 7.3 3b, PALM DESERT HOUSING AUTHORITY Portfolio Management Page 1 Portfolio Details - Investments September 30, 2020 Average Purchase Stated Daysto YTM/C Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate Moody's Mat[Call 365 Date GOLDMAN SACHS TREASURY FUND 6736302460 590 . GOLDMAN SACHS 4,937,970.30 4,937,970.30 4.937.970.30 0.270 Aaa 1 0.270 Subtotal and Average 4,937,970.30 4,937,970.30 4,937,970.30 4,937,970.30 1 0.270 CAMP SYS12008 12008 CA ASSET MANAGEMENT PROGRAM 47,786,770.95 47,786,770.95 47,786,770.95 0.270 1 0.270 Subtotal and Average 47,776,394.03 47,786,770.95 47,786,770.95 47,786,770.95 1 0.270 LAW SYS21003 21003 LOCAL AGENCY INVESTMENT FUND 966,010.49 966,010.49 966,01049 0685 1 0.685 Subtotal and Average 966,010.49 966,010.49 966,010.49 966,010.49 1 0.685 Total and Average 57,671,180.94 53,690,751.74 53,690,751.74 53,690,751.74 1 0.277 Portfolio HA AP Run Date. W192020 -1814 PM (PRF_PM2) 7.3.0 Report Ver. 7.3 31c CUSIP Investment# Issuer CHECKING SYS25015 25015 HOUSING AUTH CHECKING SYS25016 25016 HOUSING AUTH TRUST Average Balance Total Cash and Investments 57, Run Date: 10/192020 -18:14 PALM DESERT HOUSING AUTHORITY Portfolio Management Portfolio Details - Cash September 30, 2020 Average Purchase Balance Date Par Value Market Value 3,445,073.53 3,445,073.53 07/01/2019 459,906.50 459,906.50 0.00 1,180.94 57,595,731.77 67,595,731.77 Page 2 Stated Daysto YTMIC Book Value Rate Moody's Mat/Cali 366 3,445,073.53 1 0.000 459,906.50 1 0.000 1 57,595,731.77 1 0.277 Portfolio HA AP PM(PRP PM2)730 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Summary September 30, 2020 Par Market Book % of Daysto YTM/C Investments Value Value Value Portfolio Mat./Call Term 365 Equiv. RIVERSIDE COUNTY POOL 334.76 334.76 334.76 0.00 1 1 0.685 CAMP 5,723.74 5,723.74 5,723.74 0.02 1 1 0.270 LAIF 737.90 737.90 737.90 0.00 1 1 0.685 US BANK MONEY MARKETACCT 36,443,116.01 36,443.116 01 36.443.116.01 98.89 1 1 0.010 GOLDMAN SACHS GOVT FUND 401.984.18 401.984.18 401,984.18 1.09 1 1 0.030 36,851,896.59 36,851,896.59 36,851,896.59 100.00% 1 1 0.010 Investments Cash Passbook/Checking 1.242,156 37 1,242,156.37 1,242,156.37 1 1 0.000 (not included in yield calculations) Total Cash and Investments 38,094,052.96 38,094,052.96 38,094,052.96 1 1 0.010 Total Earnings September 30 Month Ending Current Year 311.31 Average Daily Balance 37,971,614.28 Effective Rate of Return 0.01 % This investment portfolio is in compliance with the provisions of California Government Code Section 53601 and the City of Palm Desert investment policy. Pursuant to ABX126, the availability of cash to fund the Palm Desert RDA Successor Agency's debt service is dependent upon the County of Riverside and the State of California. All balances are bank balances. The "% of Portfolio" calculation on the Portfolio Summary page omits demand deposits. Janet M. Moore, gancefficer Reporting period 0910112020-09130/2020 Run Date 10/19a020 -1902 No fiscal year history available Portfolio RDAS AP PM (PRF_PM1) 7.30 Report Ver. 7.3.31, RDA SUCCESSOR AGENCY Portfolio Management Page 1 Portfolio Details - Investments September 30, 2020 Average Purchase Stated Days to YTM/C Maturity CUSIP Investment # Issuer Balance Dale Par Value Market Value Book Value Rate Moody's Mat/Call 365 Date RIVERSIDE COUNTY POOL SYS052470 052470 POOLED INVESTMENT FUND 334.76 334.76 334.76 0.685 Aaa 1 0.685 Subtotal and Average 334.51 334.76 334.76 334.76 1 0.685 CAMP SYS578 578 C.A M P. POOL (RDA S.A.) 6.723.74 5,723.74 5.723.74 0.270 1 0.270 Subtotal and Average 5,722.49 6,723.74 5,723.74 5,723.74 1 0.270 LAW SYS604 604 L.A.I.F. (RDA SA.) 737.90 737.90 737.90 0.685 1 OS85 Subtotal and Average 737.90 737.90 737.90 737.90 1 0.685 US BANK MONEY MARKET ACCT 247394001-U 830 US BANK 07/01/2019 0.00 0.00 0 00 0.010 P-1 1 0 010 247394003-U 832 USBANK 07/01/2019 000 0.00 0.00 0.010 P-1 1 0010 247394002-U 833 USBANK 197,506.06 197,506.06 197,50606 0.010 P-1 1 0.010 247394000-U 834 USBANK 870,155.54 870,155.54 870.155.54 0010 P-1 1 0.010 236781002-U 837 USBANK 2,867,588.28 2,867,58828 2,867,588.28 0.010 P-1 1 0.010 236781003-U 838 USBANK 07/01/2019 0.00 000 0.00 0.010 P-1 1 0.010 236781000-U 839 USBANK 10.619.299.26 10,619,29926 10.619,299.26 0.010 P-1 1 0.010 253446003-U 842 USBANK 07/01/2019 0.00 OAD 0.00 0.010 P-1 1 0.010 253446002-U 843 USBANK 1,437,544A3 1,437,544.13 1,437.544.13 0.010 P-1 1 0.010 253446000-U 844 USBANK 5,521,418.24 5.521,418.24 5,521,41824 0.010 P-1 1 0.010 253446001-U 845 USBANK 07/01/2019 000 0.00 0.00 0.010 P-1 1 0.010 224324000-U 853 USBANK 10.766.97664 10,766.976.64 10.766,976.64 0.010 P-1 1 0.010 224324001-U 855 US BANK 07/01/2019 0.00 0.00 0.00 0.010 P-1 1 0.010 224324002-U 856 USBANK 4,162.62786 4,162,627.86 4.162,627.86 0.010 P-1 1 0.010 224324003-U 857 USBANK 07/012019 0.00 0.00 0.00 0.010 P-1 1 0.010 236781001-U 881 USBANK 09/01/2020 0.00 0.00 000 0.010 P-1 1 0.010 Subtotal and Average 36,443,116.01 36,443,116.01 36,443,116.01 36.443,116.01 1 0.010 GOLDMAN SACHS GOVT FUND ' 277861000-G 811 GOLDMAN SACHS 401,9a4.18 401,984.18 401,984 18 0.030 Aaa 1 0.030 277861001-G 812 GOLDMAN SACHS 0.00 0.00 0.00 0.030 Aaa 1 0.030 277861002-G 813 GOLDMAN SACHS 07/012019 0.00 0.00 0.00 0.030 Aaa 1 0.030 277861003-G 814 GOLDMAN SACHS 07/01/2019 0.00 000 0.00 0.030 Aaa 1 0.030 Subtotal and Average 401,985.21 - 401,984.18 401,984.18 401,984.18 1 0.030 Portfolio RDAS AP Run Date 10/192W0-1804 - PM(PRF_PM2)730 Report Ver 733b CUSIP Run Date_ 101192020-18 O Investment# Issuer Total and Average RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Investments September 30, 2020 Average Purchase Balance Date 37,971,614.28 Page 2 Stated Days to YTM/C Par Value Market Value Book Value Rate Moody's Mat/Call 365 36,851,895.59 36,851,896.59 36,851,896.69 1 0.010 Portfolio RDAS AP PM(PRF PM2)730 CUSIP Investment# Issuer UNION BANK CHECKING ACCOUNTS SYS582 582 RDA SUCCESSOR AGENCY Run Date 1WI92MO-1a.e4 RDA SUCCESSOR AGENCY Portfolio Management Portfolio Details - Cash September 30, 2020 Average Purchase Balance Date Par Value Market Value 1 242,156.37 1,242,156.37 Average Balance 0.00 Total Cash and Investments 37,971,614.28 38,094,052.96 38,094,062.96 Page 3 Stated Daysto YTM/C Book Value Rate Moody's MatJCall 365 1,242,156.37 1 0.000 1 38,094,052.96 1 0.010 Portfolio RDAS AP PM (PRF_PM2) 7.30 20-Oct2o 9:51 AM SymPro No. 738 Footnotes Investment EIP Loan * PALM DESERT RDA SUCCESSOR AGENCY LONG-TERM LOANS RECEIVABLE SEPTEMBER 30, 2020 * EIP balance adjustments made on March 2 and September 2 of each year. Book Value 542,000.00 Maturity Date 09/02/29 Stated Interest Rate 3.00