Loading...
CC SR 20240116 C - City November Treasury Report CITY COUNCIL MEETING DATE: 01/16/2024 AGENDA REPORT AGENDA HEADING: Consent Calendar AGENDA TITLE: Consideration and possible action to receive the November 2023 Cash Balances/Monthly Treasurer’s Report. RECOMMENDED COUNCIL ACTION: (1) Receive and file the November 2023 Cash Balances/Monthly Treasurer’s Report. FISCAL IMPACT: None Amount Budgeted: N/A Additional Appropriation: N/A Account Number(s): N/A ORIGINATED BY: Jane Lin, Senior Accountant REVIEWED BY: Vina Ramos, Director of Finance VR APPROVED BY: Ara Mihranian, AICP, City Manager ATTACHED SUPPORTING DOCUMENTS: A. Monthly Treasurer’s Report (page A-1) BACKGROUND AND DISCUSSION: This report summarizes the cash balance of all funds and investments for the month of November 2023. A separate report is prepared monthly for the Improvement Authority and presented under separate cover before the Authority Commission. The overall cash balances of the City totaled $92.5 million with over $47.7 million or 52% of the total cash balance in the Local Agency Investment Fund (LAIF). The City has over $2.5 million or 3% of the total cash balance with Bank of the West and over $4.4 million or 5% with Malaga Bank. Additionally, the investments under the City’s brokerage firm Stifel includes Certificates of Deposit (CD) investments $29 million or 31%, Treasury Bills and Agency Bonds $8.5 million or 9% of the total cash balance, and a money market account has a balance of $235,553 or 1% of the total cash balance. The City holds a money market account with Stifel for transactions related to the selling and purchasing of investments, as applicable. The securities are held by Bank of America and are FDIC- insured. 1 In summary, the City’s General Fund has approximately $28 million or 30% of the cash balance, and the Capital Infrastructure Program (CIP) Fund has over $36 million or 40% of cash balance. The remaining cash balances are in the Equipment Replacement Fund with over $3 million or 3%, over $2 million or 3% in the 1911 Act Fund, approximately $0.1 million or less than 1% in the Habitat Restoration Fund, approximately $0.2 million or less than 1% in the Quimby Fund, and over $21 million or 24% in Other Restricted Funds. Compared to the November 2022 balance, the City’s cash balance increased by approximately $2 million, primarily due to the increase in revenue sources. This increase is expected and aligns with the FY 2023-24 adopted budget for revenues. Additionally, while comparing the balance in October 2023, the City’s cash balance decreased by $0.4 million, mainly attributed to the timing of billing for general services and disbursements for City-approved projects. The major disbursements for this month included Aleshire and Wynder for legal services, Express Sign & Neon for City entry and park monument signage, Geosyntec Consultant for the Peninsula Coordinated Integrated Monitoring Program (CIMP) implementation for storm water, Los Angeles County Sheriff’s Department for law enforcement services, Stay Green for City’s landscape project, and Transtech Engineers for building plan check services and Western Avenue Flow Improvement Project. All expenditures were disbursed in accordance with the Fiscal Year 2023-24 budget. 2 BEGINNING BALANCE PLUS: DEPOSITS PLUS: INTEREST EARNINGS(1) LESS: CHECK DISBURSEMENTS LESS: ELECTRONIC DISBURSEMENTS(2) ADJ USTMENTS(3) PLUS: TRANSFERS IN LESS: TRANSFERS OUT ENDING BALANCE (1) All LA IF interest is paid quarterly . (2) Electronic Disbursements : Payro ll Payroll Charges Postage Bank and Merc hant Fees (3) Th e net adjustme nt was due to a void check . Bank of the West Ope rating 3,543,377.87 2.441 ,329.33 (2,183,744 .13) (735,848.09) 1,113.12 (500 ,000.00) 2,566 ,228.10 448 ,516.34 269 ,888.90 1.500.00 15,942.85 735 ,848 .09 CITY OF RANCHO PALOS VEROES MONTHLY TREASURER'S REPORT NOVEMBER 2023 Petty Cas h LAIF-C ITY 5.000 .00 47 ,724,461.20 5,000.00 47.724,461 .20 Ma laga Bank Non-Negotiable Stifel Stlfel co Mo ne y Market In vestme nt 4,447 ,871 .01 405,401.10 36 ,794 ,000 .00 (169 ,847.7 1) 250,000.00 500,000.00 4,447 ,871 .01 235,553 .39 37 .544 ,000 .00 NOVEMBER 2023 CASH BALANCE BY MAJOR FUNDS 0% 0% Total Cas h 92.920.111.18 2.441 ,329.33 (2 ,183 ,744.13) (735 ,848.09) 81 ,265.41 500 ,000.00 (500 ,000.00) 92.523, 113.70 ■GENERAL FUND 30% ■CIP40% ■EQU IP MENT REPLACEMENT 3% 1,11911 ACT 3% CHABITAT RESTORATION 0% CQUIMBYO% COTHER RESTRICTED FUNDS 24% A-1 CASH BALANCES BY FUND Unrestricted GENERAL FUND Restricted by Council Action BEAUTIFICATION FUND CIP EQUIPMENT REPLACEMENT BUILDING REPLACEMENT EMPLOYEE PENSION PLAN EMPLOYEE BENEFITS Subtotal Restricted by Law or External Agencies STREET MAINTENANCE 1972 AC T GAS TAX-SB1 EL PRADO CDBG CDBG-R 1911 AC T SOLID WASTE AIR QUA LITY MANAGEMENT PROPOSITION C PROPOSITION A PUBLIC SAFETY GRANTS ME AS URER MEASURE M HAB ITAT RESTORATION SUBREG ION 1 M A INTENA NCE MEASURE A MAINTENANCE ABA LONE COVE SEWER DISTRICT RPVTV GINSBURG CULTURE ARTS BU ILDING DONOR RESTRICTED CO NTRIBUTIONS FEDER A L GRANTS STATE GRANTS FEDER AL GR ANTS-ARPA QU IMB Y LOW-MODER ATE INCOME HOUSING A FFORD ABLE HSNG IN LIEU EET MEASURE A CAPITAL BIKEWAYS UNDERGROUND UTILITIES ROADWAY BEA UTIFICATION MEASURE W WA TER QUALITY FLOOD PROTECTION REDEVELOPMENT OBLIGATION RET IRE IMPROVEMENT DISTRICT 9 SPECIAL TRU STS Subtotal GRAND TOTAL CITY OF RANCHO PALOS VERDES MONTHLY TREASURER'S REPORT NOVEMBER 2023 BALANCE FORWARD DEBIT CREDIT 28,337,428.85 3,959,371.86 4,318,262.06 0 .00 0.00 0.00 36 ,879,343.12 0 .00 102,527 .51 3,264 ,223 .36 0 .00 3 ,935.62 0.00 0 .00 0.00 1,161 ,347.54 0.00 0.00 0 .00 0.00 0 .00 41,304,914.02 0.00 106,463.13 845,629.77 0.00 62 ,85 1.60 30 ,394 .52 0.00 0 .00 1,649 ,719.92 96,461 .25 0 .00 48 ,034.51 57 .86 0.00 8,034.26 133.00 1,575.00 0.00 0.00 0.00 2 ,376,069.71 14,643 .03 20 ,172 .06 360,124.65 449 .77 18,910.86 38,887.46 0.00 0.00 274 ,528.42 74,153.38 561 .00 2,174,415.70 89,398.18 0 .00 90 ,001.15 30,385.31 0 .00 2,613 ,850.90 55 ,602.48 3,404 .25 709,740.74 62,927.98 74,041 .66 157 ,369.81 0.00 43 ,783 .88 771 ,714.01 0 .00 4,181 .95 99 ,563.48 0 .00 0 .00 29 ,701.06 0.00 4,525 .27 0.00 0.00 0.00 0.00 0.00 0.00 895,327 .84 0.00 636.43 0.00 0 .00 0 .00 1,525,684.81 30,490.20 5,530 .00 4 ,735,744.47 0.00 80 ,351 .50 199,990.95 0.00 0.00 385 ,892.20 0.00 0 .00 903,639.20 0.00 0.00 86 ,037 .77 0.00 0.00 0.00 0 .00 0 .00 0 .00 0 .00 0 .00 0.00 0 .00 0 .00 0.00 0.00 0 .00 898 ,569.34 0.00 22 ,272 .00 0.00 0.00 0 .00 285 ,245.53 0.00 0.00 0.00 0.00 0.00 1,083,856.13 38 ,104.53 81 ,653.66 23,277,768.31 492,806.97 424,451 .12 92,920,111.18 4,452,178.83 4,849,176.31 Total Investment: Chance In Chance In Endinc Cash Endinc Cash CASH Balance Balance in% 27,978,538.65 (358,890.20) -1% 0 .00 0.00 0% 36 ,776,815.61 (102,527 .51) 0% 3,260,287 .74 (3 ,935 62) 0% 0.00 0 .00 0% 1,161 ,347 .54 0.00 0% 0 .00 0 .00 0% 41,198,450 .89 (106,463.13 0% 782 ,778 .17 (62,851 .60) -7% 30 ,394.52 0.00 0% 1,746 ,181 .17 96,461 .25 0% 48 ,092 .37 57.86 0% 6,592 .26 (1,442 .00) -18% 0.00 0.00 0% 2,370,540 .68 (5 ,529 03 0% 341 ,663.56 (18 ,461 .09) -5% 38,887.46 0.00 0% 348 ,120.80 73 ,592 .38 27% 2,263,813 .88 89,398.18 4% 120,386.46 30 ,385.31 34% 2,666,049.13 52 ,198.23 2% 698,627 .06 (11 ,11 3.6 8) -2% 113,585 .93 (43 ,783 88) -28% 767 ,532 .06 (4 ,181 .95) -1% 99,563.48 0.00 0% 25 ,175.79 (4 ,525.27) -15% 0.00 0.00 0% 0.00 0.00 0% 894 ,691.41 (636 .43 0% 0 .00 0 .00 0% 1,550,645 .01 24 ,960.20 2% 4 ,655,392 .97 (80,351 .50) -2% 199,990.95 0.00 0% 385 ,892 .20 0 .00 0% 903,639.20 0.00 0% 86 ,037 .77 0.00 0% 0 .00 0 .00 0% 0 .00 0.00 0% 0 .00 0.00 0% 0 .00 0 .00 0% 876 ,297 .34 (22,272 00) -2% 0.00 0.00 0% 285,245.53 0.00 0% 0.00 0 .00 0% 1,040 ,307 .00 (43 ,549.13) -4% 23,346 ,124.1 6 68,355.85 0% 92,523,113.70 (396,997.48) 0% 92,523,113.70 A-2 Investment Local Agency Investment Fund (LAIF-CITY) Note (1) CD -Non-Negotiable CD -Non-Negotiable Issuer of Investment State of California Malaga Bank Malaga Bank CD -Bank of America -Stifel (Non-Negotiable) A+ Fed Credit Union Austin Advia Cr Un Alaska USA Fed Ce Un Alliant Credit Union American Expr Natl Bank American First Cr Un Arsenal Credit Union Auburn State Bank Austin Telco Fed Cr Union AXOS Bank Bank of Baroda Bank Forward Bank Hapoalim Bankers Bank BankNewport Rhode Bankunited Baxter Credit Union Baycoast Bank Beal Bank USA BMW Bank of Northern America Capital One Capital One Celtic Bank Centris Fed Cr Un Chief Finl Fed Cr Un Rochester Chief Finl Fed Cr Un Rochester Coastlife Credit Union Comenity Capital Bank Community West Cr Un Communitywide FCU Connectone Bank Connexus Credit Union County School FCU Credit Un of Tex Allen Dart Bk Mason Dept of Labor Fed Cr Un Discover Bank Dort Financial Cr Union Eaglemark Savings Bank Empower Credit Union Evansville Teachers FCU Farmers Ins. Group FCU Farmers&Merchants Bank Farmers State Bannk First Bank Blue Earth First Comw! Fed Cr Union First Federal S&L First tndpt Bank First Nat'I Bank First Natl Bank/DAMA Flushing Bank Four Pts FCU Omaha Generations Bank GESA Cr Union GHS Fed Credit Union Greenstate Credit Union Hapo Cmnty Cr Un lntercredit Bank NA Insight Credit Union JP Morgan Chase Bank Kemba Finl Credit Union Lebanon FCU PA Liberty First Cr Un Lincoln Park Cmnty Cr Un Live Oak Bankinig Magnolia Bank Malaga Bank FSB CITY OF RANCHO PALOS VERDES MONTHLY INVESTMENT REPORT NOVEMBER 2023 CUSIP# 00224TAB2 00782JAC6 011852AH3 01882MAH5 02589ABM3 02616ABX6 04288LAA6 05059LAC6 052392BN6 05465DAK4 06063HMT7 062163BN9 06251A2Q2 06610RBL2 06647JAV6 066519QK8 07181JAB0 072727AZ3 07371CK32 05580AB45 14042RQB0 14042RQS3 15118RUX3 15643VAB8 16863LAB1 16863LAE5 19058LAB0 20033A3A2 20416JAC8 20416TAV4 20786ADL6 20825WAT7 22258JAB7 22551KAB8 237412AS0 24951AAD8 254673B70 25844MAD0 27004PCM3 291916AB0 299547BC2 30960QAM9 307811DP1 310567AG7 32114MAY3 31982NAA4 32022EAW6 32056VAM9 32110YXG5 32117BEQ7 34387AFF1 35089LAD5 37149CAX5 37424PAH7 36266LAA4 39573LDC9 41138NAB4 458657MC4 45791JAC0 48128UMX4 48836LAN2 52248LAB2 530520AM7 534574AC2 538036UG7 559582AL5 56102AAJ5 Acquisition Date N/A 2/18/2023 2/18/2023 6/29/2022 9/27/2023 3/22/2023 11/15/2023 3/3/2022 3/30/2023 1/20/2024 3/31/2022 9/21/2022 3/26/2020 7122/2020 12/28/2019 12/14/2020 4/13/2022 8/3/2022 3/5/2021 6/23/2022 1/24/2020 3/9/2022 7/23/2021 11/17/2021 4/20/2022 4/17/2020 5/24/2023 7/29/2022 10/12/2022 2/13/2023 4/14/2022 12/23/2022 12/8/2022 9/24/2021 5/26/2022 2/22/2023 7/22/2022 6/21/2022 9/14/2023 4/27/2022 10/28/2022 3/2/2022 9/29/2023 2/6/2023 1/1/2023 1/14/2022 11/14/2022 10/21/2022 8/8/2023 12/29/2021 8/23/2023 6/24/2022 12/30/2021 11/4/2022 6/29/2022 5/12/2022 7/31/2023 9/15/2022 1/26/2023 8/31/2023 1/31/2022 2/27/2023 9/30/2020 9/21/2022 8/4/2022 8/29/2023 8/28/2023 2/1/2022 10/30/2020 5/29/2020 Term N/A 6 Mos 6 Mos 60 Mos 60 Mos 36 Mos 60 Mos 36 Mos 36 Mos 12 Mos 48 Mos 24 Mos 48 Mos 60 Mos 60 Mos 60 Mos 42 Mos 48 Mos 60 Mos 36 Mos 60 Mos 48 Mos 36 Mos 60 Mos 60 Mos 60 Mos 24 Mos 60 Mos 36 Mos 36 Mos 60 Mos 30 Mos 36 Mos 60 Mos 36 Mos 55 Mos 36 Mos 42 Mos 36 Mos 36 Mos 24 Mos 60 Mos 60 Mos 12 Mos 13 Mos 60 Mos 36 Mos 30 Mos 24 Mos 60 Mos 60 Mos 60 Mos 60 Mos 36 Mos 60 Mos 60 Mos 36 Mos 60 Mos 27 Mos. 42 Mos. 60 Mos 24 Mos 60 Mos 60 Mos 60 Mos 48 Mos 60 Mos 48 Mos 54 Mos 60 Mos Maturity Date On Demand 2/21/2024 2/21/2024 6/29/2027 9/27/2028 3/23/2026 11/15/2028 3/3/2025 3/30/2026 1/21/2025 3/31/2026 9/20/2024 3/26/2024 7/22/2025 12/18/2024 12/25/2025 10/14/2025 8/3/2026 3/5/2026 6/23/2025 1/24/2025 3/4/2026 7/23/2024 11/17/2026 4/20/2027 4/17/2025 5/24/2025 7/29/2027 10/14/2025 2/12/2026 4/14/2027 6/23/2025 12/8/2025 9/27/2026 5/27/2025 9/30/2027 7/22/2025 12/22/2025 9/14/2026 4/28/2025 10/28/2024 3/2/2027 9/29/2028 2/5/2024 1/18/2024 1/14/2027 11/14/2025 4/21/2025 8/8/2025 12/29/2026 8/30/2028 6/24/2027 12/30/2026 11/4/2025 6/29/2027 5/12/2027 7/31/2026 9/15/2027 4/29/2025 2/26/2027 1/29/2027 2/24/2025 9/30/2025 9/21/2027 8/4/2027 8/30/2027 8/28/2028 2/2/2026 4/30/2025 5/29/2025 Market Value 47,724,461 250,000 4,197,871 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 249,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 249,000 250,000 250,000 250,000 250,000 249,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 249,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 Book Value 47,724,461 250,000 4,197,871 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 249,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 249,000 250,000 250,000 250,000 250,000 249,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 249,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 Yield 3.84°/o 4.00% 4.00% 3.55% 5.07% 5.15% 5.34% 1.80% 5.05% 5.10% 2.10% 3.70% 1.65% 0.65% 1.75% 0.50% 2.05% 3.50% 0.65% 3.10% 1.70% 1.90% 0.50% 1.10% 2.80% 1.50% 5.02% 3.50% 4.60% 4.65% 2.65% 5.00% 5.00% 0.80% 3.00% 4.40% 3.30% 3.10% 5.60% 2.80% 4.60% 2.00% 5.15% 3.30% 5.00% 1.20% 5.00% 4.45% 5.50% 1.05% 5.30% 3.25% 1.25% 4.70% 3.40% 3.10% 5.25% 3.80% 2.65% 5.00% 1.35% 5.10% 0.50% 4.10% 3.55% 5.00% 5.00% 1.25% 0.40% 0.70% A-3 CITY OF RANCHO PALOS VERDES MONTHLY TREASURER'S REPORT NOVEMBER 2023 Issuer of Acquisition Maturity Market Book Investment Investment CUSIP# Date Term Da te Value Value Yield Marlin Business Bank 57116ATM0 1/15/2020 60 Mos 1/15/2025 250,000 s 250,000 1.75% Midflorida Cr Union 5974 1QAA0 7/26/2023 60 Mos 7/26/2028 250 ,000 $ 250 ,000 5.55% Mineola Community Bank 60273NA89 11/9/2022 60 Mos 11/9/2027 250,000 250,000 5.10% Money One FCU 60936TAL3 9/14/2023 60 Mos 9/14/2028 250,000 250,000 5.07 % Morgan St anley Bk 61690UK82 6/2/2022 36 Mos 6/2/2025 250,000 250 ,000 3.05% Mountain Amer Fed CR UN 62384RAL0 8/31/2022 36 Mos 8/29/2025 250,000 250,000 3.50% Mutual First Fed Cr Union 62825MAA2 8/3/2023 24 Mos 8/4/2025 250 ,000 250,000 5.2 0% Nat'I Bank of Commerce 633368FJ9 1/19/2022 60Mos 1/19/2027 250 ,000 250,000 1.15% Nexbank 653344CD1 5/15/2023 24 Mos 5/15/2025 250,000 250,000 5.07 % New York Community Bank 649447UP2 6/3/2021 36 Mos 6/3/2024 250,000 250,000 0.3 5% Numerica Credit Union 67054NBA0 11 /4/2022 24 Mos 11/4/2024 250,000 250 ,000 4 .85 % Oklahoma Fed Credit Union 67886WA83 11/22/2022 24 Mos 11/22/2024 250,000 250,000 5.00% Old Dominion Nat;J Bank 679585AZ2 1/20/2022 60 Mos 1/20/2027 250,000 250,000 1.151% Old Mission Bank 68002LCN6 4/29/2022 54 Mos 10/29/2026 250 ,000 250 ,000 2.65% Onpath Fed Cr Union 68283MAG1 9/15/2022 ea Mos 9/15/2027 250 ,000 s 250,000 3.80% Pacific Western Bank 69506YWM7 3/7/2023 60 Mos 3/7/2028 250 ,000 s 250,000 5.15% Pathfi nder Bank 70320KBR1 1/3 1/2 022 60 Mos 1/29/2027 250,000 250,000 1.20% Pima Fed Cr Un 722000AC0 8/17/2023 36 Mos 8/17/2026 250,000 250,000 5.30% Pittsburgh City Hall 72500MAA3 8/16/2022 60 Mos 8/16/2027 250 ,000 250,000 3.60% Popular Bank 73317AAY8 4/1 3/2022 36 Mos 4/14/2025 250,000 250,000 2.45% Preferred Bank LA 740367MA2 7/17/2020 60Mos 7/17/2025 250,000 250,000 0.5 0% Raymond James Bank 75472RAN1 11/26/2019 60 Mos 11/26/2024 250 ,000 250,000 1.85% Rogue Credit Union 77535MAL7 1/20/2023 48 Mos 1/20/2027 250 ,000 250 ,000 5.05% Saco&Biddefords Savs 78577THR9 7/2 1/2 022 60 Mos 7/2 1/2027 250 ,000 250 ,000 3.45% Sallie Mae Bank/Salt Lake 7954504P7 10/16/2019 60 Mos 10/16/2024 250,000 250,000 1.90% Say.,,yers Svgs Bank 805508BT4 10/28/2022 60 Mos 10/28/2027 250,000 250,000 4.90% Sharonview Fed Cr Union 819866BM5 8/15/2 022 36 Mos 8/15/2025 250,000 250,000 3.40% Signature Fed Cr Un 82671DAA5 10/27/2022 48 Mos 10/27/2026 248,000 248,000 4.6 0% Southwest Finl Fed Cr Un 84485EAJ6 9/21/2022 60 Mos 9/21/2027 250,000 250,000 3.80% State Bank of In dia 856285RS2 11/27/2019 72 Mos 11/27/2024 250,000 250,000 2.05% St Lawrence Fed Cr Un 791125AC1 12/1/2023 60 Mos 12/1/2028 250 ,000 250,000 5.69% Texas Exchange Bank 88241TJJ0 10/23/2020 60 Mos 10/23/2025 s 250,000 250,000 0.60% Texas Exchange Bank 88241TJN1 11/25/2020 60 Mos 11/25/2025 s 250,000 250,000 0.60% Te xas Exchange Bank 88241T JR2 12/18/2020 60 Mos 12/18/2025 250,000 250,000 0.60% Texas Excange BK SSB 88241TNV8 8/5/2022 51 Mos 11/16/2026 250,000 250 ,000 3.60% The Di st Cr Un 88340AAC5 12/22/2022 36 Mos 12/22/2025 250,000 250,000 5.25% Toyota Financial Svgs Bank 89235MLE9 7/29/202 1 60 Mos 7/29/2026 250,000 250,000 0.95% Truliant Fed Cr Un 89789AAE7 3/10/2023 30 Mos 9/10/2025 250,000 250,000 5.05% Trustone Finl Cr Un 89841MAF4 7/19/2022 60 Mos 7/19/2027 250,000 250,000 3.40% TTCU Fed Cr Union 89854LAK9 7/26/2023 60 Mos 7/26/2028 250 ,0 00 250,000 5.55 % Tucson Fed Ce Un 898812AC6 9/8/2023 60Mos 9/8/2028 250,000 250,000 5.00% UBS Bank USA 90348JN30 6/24/2021 36 Mos 6/24/2024 250,000 250,000 0.35 % University Credit Union 914242AA0 2/21/2023 31 Mos 9/26/2025 249,000 249 ,000 4.00%. United Bankers Bank 909557JP6 12/16/2 021 56 Mos 8/17/2026 250,000 250,000 1.00% Valley Strong Cr Union 920 133AJ4 12/14/2022 24 Mos 12/13/2024 250,000 250,000 5.10% Vision Bank or Iowa 92834CCL4 11/29/2019 72 Mos 11 /29/2024 250,000 250,000 1.75% Workers Credit Union 98138MAT7 9/29/2022 60 Mos 9/29/2027 250,000 250 ,000 4.50% Workers Credit Union 98138MAM2 4/17/2023 22 Mos 2/28/2025 249,000 s 249 ,000 1.49% Workers Fed Cr Un 98138MCB4 11/15/2023 60 Mos 11/15/2027 250 ,000 s 250,000 5.35% Treasury-Bank of New York(Vini ng Sparks) United States Treas 91282CEX5 6/30/2023 12Mos 6/30/2024 1,000 ,000 1,000,000 3.00% United States Treas 912828XZ8 6/30/2020 60 Mos 6/30/2025 1,000,000 1,000,000 2.75% United States Treas 91282CBC4 1/12/2021 60 Mos 12/31/2025 2,000 ,000 2,000,000 0.38 % Agency Bonds Fed Farm Cre dit Bank 3133ELF41 6/8/2022 60 Mos 6/8/2027 1,0 00 ,000 1,0 00 ,000 0.94% Fed Farm Credit Ba nk 3133EMZ21 8/6/2021 54 Mos 4/6/2026 1,000,000 1,000,000 0.69% Fed Farm Credit Bank 3133ENYX2 6/17/2022 24 Mos 6/17/2024 500,000 500,000 3.25% Fed Farm Cre dit Bank 3133ENNX4 12/15/2022 26 Mos 2/14/2025 1,052 ,000 1,052 ,000 1.67% Fed Home Loan Bank 3130ASYR4 8/30/2022 36 Mos 8/2 8/2025 1,000 ,000 1,000 ,000 4.00% Total Investments 89,716,332 Summary: Weighted Return 3.49% Local Agency Investment Fund (LAIF-C ITY) 47 ,724 ,461 .20 Cert ifi cate of Deposit -Malaga Bank 250 ,000 ,00 Certificate of Deposit -Malaga Bank 4,197,871.01 Certificate of Deposit -Stife l 28,992,000.00 Treasury Bills -Stifel 8,552,000 .00 Total Investments 89,716,332.21 BOW balance 2,566,228 .10 Petty Cash 5,000.00 Stifel money market 235,553.39 Total cash & investment 92 ,523, 113 ,7 0 Total cash & investment from above 92 ,523,11 3.70 A-4 NOTE: Malaga Ba nk -CD 5% CITY OF RANCHO PALOS VERD ES MONTHLY TREASURER'S REPORT NOVEMBER 2023 SUMMARY OF CASH BALANCE BY INSTITUTION NOVEMBER 2023 Stifel -Tr eas ury 9% Ba n k of the West 3% St ifel -M o ney Ma rke t 0% Sta t e of Ca lifornia -LAIF 52 % (1) LA IF market va lu es will be reported to vary from book value if the City calculated share of total LAIF assets is less than the City book value . To the best of my knowledge , there are no misstatements of materia l amounts within this report ; or omissions of material amoun ts to cause the report to be misleading. I certify that this report accurately re flects all City investments and complies with the investment policy of the City of Rancho Palos Verdes as approved by the City Council. Furthermore , I certify that su ffi cient investment liquidity and anticipated revenues are available to meet the City's expenditure requirements for th e next six months . Respectfully submitted, Uh Treasurer Dated A-5