Loading...
CC SR 20240806 C - June 2024 Treasury Report CITY COUNCIL MEETING DATE: 08/06/2024 AGENDA REPORT AGENDA HEADING: Consent Calendar AGENDA TITLE: Consideration and possible action to receive the June 2024 Cash Balances/Monthly Treasurer’s Report. RECOMMENDED COUNCIL ACTION: (1) Receive and file the June 2024 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 June 2024. 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 $98 million with over $46.7 million or 48% of the total cash balance in the Local Agency Investment Fund (LAIF). The City has a total of over $1.7 million or 2% of the total cash balance with BMO, which includes $1.2 million in checking for operational needs. In April 2024, the City opened a new money market account with a starting balance of $0.5 million of idle funds to maximize interesting earnings instead of leaving the amount in the BMO checking account. Additionally, over $4.2 million or 4% is with Malaga Bank. Additionally, the investments under the City’s brokerage firm Stifel includes Certificates of Deposit (CD) investments $28.5 million or 29%, Treasury Bills and Agency Bonds $16 million or 16% of the total cash balance, and a money market account has a balance of 1 $1.1 million 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 balance of $1.1 million is higher than usual due to the timing of investments that matured on June 30. This balance was reduced by the following month for the new purchases replacing the investments that matured on June 30. In summary, the City’s General Fund has over $36 million or 37% of the cash balance, and the Capital Infrastructure Program (CIP) Fund has over $32 million or 33% of cash balance. The remaining cash balances are in the Equipment Replacement Fund with over $3 million or 3%, approximately $3 million or 3% in the 1911 Act Fund, over $0.1 million or less than 1% in the Quimby Fund, and over $23 million or 24% in Other Restricted Funds. Compared to the June 2023 balance, the City’s cash balance decreased by approximately $0.8 million, primarily due to increased expenditures for the Portuguese Bend landslide areas. This decrease is expected due to the emergency repairs needed to mitigate the severity of the landslide areas. Additionally, while comparing the balance in May 2024, the City’s cash balance decreased by $2 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, Geologic Associates, Hout Construction, and Hardy and Harper for Portuguese Bend area landslide emergency and roadway repairs, Malcolm Drilling for emergency hydraugers task, Ocean Blue Environmental Services for emergency landslide area clean-up, Palos Verdes Peninsula Land Conservancy for Palos Verdes Preserve Management Fee, Stay Green for citywide and emergency storm related landscape services, South Bay Toyota for a new City vehicle purchase, and Abalone Cove Landslide Abatement District and Klondike Canyon Geologic for the maintenance and operating improvements . All expenditures were disbursed in accordance with the Fiscal Year 2023-24 budget and the City Council’s approved expenditures related to the landslide. It is important to note that the June report reflects preliminary numbers; the final report will be submitted upon completion of the year-end closing. 2 BEGINNING BALANCE PLUS: DEPOSITS PLUS : INTEREST EARNINGS(1) LESS : CHECK DISBURSEMENTS LESS : ELECTRONIC DISBURSEMENTS(2) ADJUSTMENTS(3) PLUS: TRANSFERS IN LESS : TRANSFERS OUT ENDING BALANCE (1) All LAIF interest is paid quarterly . (2) Electron ic Disbursements : Payroll Payroll Charges Bank and Merchant Fees Petty Cash CITY OF RANCHO PALOS VERDES PRELIMINARY MONTHLY TREASURER'S REPORT JUNE 2024 BMC Operating 2,323,274.24 2,476 ,148.21 (3 ,749 ,952.20) (797 ,330.62) (6,237.89) 1,000,000.00 1,245,901.74 485 ,981 .94 289,776.36 2 1,049.32 523 .00 797 ,330.62 BMC MMDA Petty Cash LAIF-CITV 1,500,000.00 5,000.00 46,737,423.32 (1 ,000,000.00) 500,000.0 0 5,000.00 46 ,737 ,423.32 Malaga Bank Non-Negotiable co 4,2 64,068.12 4,264 ,068.12 (3) The net adjustment was due to vo id checks and ot her adjustment . JUNE 2024 CASH BALANCE BY MAJOR FUNDS 0% 0% Stlfel Stifel Money Market Investment Total Cash 5,599.94 45 ,523,000.00 100,358,365 .62 2,476 ,148 .21 (3 ,749,952.20) (797 ,330.62) 1,089,730.67 (1,000,000.00) 83,492.78 1,000 ,000.00 (1 ,000,000.00) 1,095,330.61 44 ,523 ,000.00 98 ,370 ,723.79 ■GENERAL FUND 37% IICIP 33% II EQUIPMENT REPLACEMEN T 3% 11:111911 ACT 3% DHABITAT RESTORATION 0% l!JQUIMBYO% Cl OTHER RESTRICTED FUNDS 24% A-1 CASH BALANCES BY FUND Unrestricted GENERAL FUND Restricted bv Council Action BE A UTI FICATION FUND CIP EQUIPMENT REPLACEMENT BUILDIN G REPLACEMENT EMPLOYEE PENSION PLAN EMPLOYEE BENEF ITS Subtotal Restricted by Law or External Agencies STREET MAINTENANCE 1972 A CT GAS TAX-SB1 EL PRADO CDBG CDBG-R 1911 ACT SOLID WASTE AIR QUALITY MANAGEMENT PROPOSITION C PROPOSITION A PUBLI C SA FETY GRA NTS MEASURER MEASURE M HA BIT AT RESTORATION SUBREGION 1 MAINTENANCE MEASURE A MAINTENANCE ABALONE COVE SEWER DISTR ICT RPVTV GINSBURG CULTURE ARTS BUILDIN G DONOR RESTRICTED CONTR IBUTIONS FEDE RA L GRANTS STATE GRANTS FEDER A L GRANTS-ARPA QU IMBY LOW-MODERATE INCOME HOUSING A FF ORDABLE HSNG IN LIEU EET MEAS UR E A CAPIT AL BIKEWAYS UNDERGROUND UTILITIE S ROADWAY BEAUTIFICATION MEASUREW WATER QUALITY FLOOD PROTECTION REDEVELOPMENT OB LI GATION RETIRE IMPROVEMENT DISTRICT 9 SPECIAL TRUSTS Sublotal GRAND TOTAL CITY OF RANCHO PALOS VERDES PRELIMINARY MONTHLY TREASURER'S REPORT JUNE 2024 BALANCE FORWARD DEBIT CREDIT 37 ,534,702.84 7,690,791 .45 8,863,880.51 0.00 0 .00 0 .00 33,163,629.66 1,105,250.00 1,835,886 .22 3,265 ,383.45 61 ,725.00 11 5 ,308 .94 0 .00 0.00 0.00 1,181 ,827 .72 0.00 135 ,356.94 0.00 0.00 0 .00 37,610,840.83 1,1 66 ,975 .00 2,086,552.10 742 ,622 .59 278,213.33 97 ,580 .86 30 ,930.52 0.00 0.00 2,307,082 .19 98 ,893 .53 0.00 52,282 .39 6 .26 0.00 7,027.26 2 1,052 .00 3 ,745.00 0.00 0.00 0 .00 3,026,9 12 .52 1,588.78 60,465 .96 477,770 .25 44,490.20 18,853 .64 66 ,920 .18 14 ,250.22 0 .00 4 13,100.03 0 .00 0.00 2,424 ,062 .83 86 ,628.18 0 .00 85,498.05 0.00 42 ,500 .00 3,046 ,127.22 0.00 0 .00 547,313 .00 49 ,001 .64 68,482.99 58 ,529 .57 29,038 .19 87 ,56 7 .76 788,427.30 20 ,2 12 .95 1,986.80 71 ,856.69 0 .00 25,000.00 66 ,080.69 17,500.00 3,023 .14 0 .00 0.00 0 .00 0 .00 0.00 0.00 946,721 .56 200 .00 327.24 0.00 0 .00 0.00 1,540 ,432 .88 0.00 0 .00 4 ,293,062 .31 0.00 510 ,846.48 11 6 ,549 .84 0.00 1,174.86 445,634 .74 0.00 0 .00 919,574 .73 0.00 0.00 87 ,555.03 0.00 0.00 0.00 0.00 0 .00 0 .00 30 ,790.00 0 .00 0 .00 0.00 0 .00 0 .00 0.00 0 .00 1,410,635.19 0.00 28,542 .67 0.00 0 .00 0.00 25,588 .78 33 1,327 .00 0 .00 0 .00 0 .00 0 .00 1,2 14 ,523 .6 1 33 ,138.00 1,208 .55 25,212,82 1.95 1,056 ,330.28 951,305 .95 100,358,3 65 .62 9,914,096.73 11 ,901,738.56 Total Investment : Chanqe In Chanqe In Ending Cash Ending Cas h CASH Balance Balance in % 36,361,613 .7 8 {1,1 73 ,089.06 -3% 0.00 0.00 0% 32,432 ,993.44 (730,636.22 -2% 3,211 ,799 .51 (53,583 94 -2% 0 .00 0.00 0% 1,046,470.78 (135 ,356 94 -11 % 0.00 0.00 0% 36,691,263.73 {919,577.10 -2% 923 ,255 .06 180,632.47 24 % 30 ,930 .52 0 .00 0% 2,405,975.72 98 ,893 .53 0% 52 ,288.65 6.26 0% 24 ,334 .26 17 ,307.00 246% 0.00 0.00 0% 2,968 ,035.34 (58 ,877.18) -2% 503,406 .8 1 25 ,636.56 5% 8 1,170.40 14 ,250.22 2 1% 413,100.03 0 .00 0% 2 ,510,691 .01 86 ,628.18 4% 42 ,998.05 (42,500 .00 -50% 3,046 ,127.22 0 .00 0% 527 ,83 1.65 (19,481 .35 -4 % 0 .00 (58 ,529.57 -100% 806 ,653.45 18,226.15 2% 46,856.69 (25 ,00000 -35 % 80,557.55 14,476.86 22 % 0.00 0.00 0% 0.00 0.00 0% 946 ,594 .32 (127.24) 0% 0 .00 0.00 0% 1,540,432.88 0.00 0% 3,782 ,215.83 (510,846.48) -12% 11 5,374 .98 (1 ,174.86) -1% 445 ,634 .74 0 .00 0% 919 ,574 .73 0.00 0% 87 ,555 .03 0.00 0% 0 .00 0.00 0% 30 ,790 .00 30 ,790.00 0% 0.00 0 .00 0% 0.00 0.00 0% 1,382 ,092 .52 (28 ,54267) -2% 0.00 0 .00 0% 356,9 15.78 331 ,327.00 1295% 0 .00 0.00 0% 1,246,453 .06 31 ,929.45 3% 25,3 17,846.28 105,024.33 0% 98,370,723.79 (1,987 ,641.83) -2% 98,370,723.79 A-2 CITY OF RANCHO PALOS VERDES PRELIMINARY MONTHLY TREASURER'S REPORT JUNE 2024 Issuer of Acquisition Maturity Market Book Investment Investment CUSIP# Date Term Date Value Value Yield Local Agency Investment Fund (LAIF-CITY) State of California N/A N/A On Demand 46,737,423 46,737,423 4-48% Note (1) MMDA BMO N/A N/A On Demand 500,000 500,000 4.50% CD -Non-Negotiable Malaga Bank 2/21/2024 6 Mos 8/19/2024 4,264,068 4,264,068 4.17% CD -Bank of America -Stifel {Non-Negotiable) A+ Fed Credit Union Austin 00224TAB2 6/29/2022 60 Mos 6/29/2027 250,000 250,000 3.55% Advia Cr Un 00782JAC6 9/27/2023 60 Mos 9/27/2028 250,000 $ 250,000 5.07% Alaska USA Fed Ce Un 011852AH3 3/22/2023 36 Mos 3/23/2026 250,000 $ 250,000 5.15% Alliant Credit Union 01882MAH5 11/15/2023 60 Mos 11/15/2028 250,000 $ 250,000 5.34% American Expr Natl Bank 02589ABM3 3/3/2022 36 Mos 3/3/2025 $ 250,000 $ 250,000 1.80% American First Cr Un 02616ABX6 3/30/2023 36 Mos 3/30/2026 $ 250,000 $ 250,000 5.05% Arsenal Credit Union 04288LAA6 1/20/2024 12 Mos 1/21/2025 $ 250,000 $ 250,000 5.10% Auburn State Bank 05059LAC6 3/31/2022 48 Mos 3/31/2026 $ 250,000 $ 250,000 2.10% Austin Telco Fed Cr Union 052392BN6 9/21/2022 24 Mos 9/20/2024 $ 250,000 250,000 3.70% Bank of Baroda 06063HMT7 7122/2020 60 Mos 7/22/2025 $ 250,000 250,000 0.65% Bank Forward 062163BN9 12/28/2019 60 Mos 12/18/2024 $ 250,000 $ 250,000 1.75% Bank Hapoalim 06251A2Q2 12/14/2020 60 Mos 12/25/2025 $ 250,000 $ 250,000 0.50% Bankers Bank 06610RBL2 4/13/2022 42 Mos 10/14/2025 $ 250,000 $ 250,000 2.05% BankNewport Rhode 06647JAV6 8/3/2022 48 Mos 8/3/2026 $ 250,000 $ 250,000 3.50% Bankunited 066519QK8 3/5/2021 60 Mos 3/5/2026 $ 250,000 $ 250,000 0.65% Baxter Credit Union 07181JAB0 6/23/2022 36 Mos 6/23/2025 $ 250,000 $ 250,000 3.10% Baycoast Bank 072727AZ3 1/24/2020 60 Mos 1/24/2025 $ 250,000 $ 250,000 1.70% Beal Bank USA 07371CK32 3/9/2022 48 Mos 3/4/2026 250,000 $ 250,000 1.90% BMW Bank of Northern America 05580AB45 7/23/2021 36 Mos 7/23/2024 250,000 250,000 0.50%1 SOM Bank 09776DAA2 5/23/2024 48 Mos 5/30/2028 250,000 250,000 5.25% Capital One 14042RQB0 11/17/2021 60 Mos 11/17/2026 250,000 250,000 1.10% Capital One 14042RQS3 4/20/2022 60 Mos 4/20/2027 250,000 250,000 2.80% Celtic Bank 15118RUX3 4/17/2020 60 Mos 4/17/2025 250,000 250,000 1.50% Centris Fed Cr Un 15643VAB8 5/24/2023 24 Mos 5/24/2025 250,000 250,000 5.02% Chief Finl Fed Cr Un Rochester 16863LAB1 7/29/2022 60 Mos 7/29/2027 250,000 250,000 3.50% Chief Finl Fed Cr Un Rochester 16863LAE5 10/12/2022 36 Mos 10/14/2025 $ 250,000 $ 250,000 4.60% Coastlife Credit Union 19058LAB0 2/13/2023 36 Mos 2/12/2026 $ 250,000 $ 250,000 4.65% Comenity Capital Bank 20033A3A2 4/14/2022 60 Mos 4/14/2027 $ 250,000 $ 250,000 2.65% Community West Cr Un 20416JAC8 12/23/2022 30 Mos 6/23/2025 $ 250,000 $ 250,000 5.00% Communitywide FCU 20416TAV4 12/8/2022 36 Mos 12/8/2025 250,000 $ 250,000 5.00% Connectone Bank 20786ADL6 9/24/2021 60 Mos 9/27/2026 250,000 $ 250,000 0.80% Connexus Credit Union 20825WAT7 5/26/2022 36 Mos 5/27/2025 250,000 $ 250,000 3.00% County School FCU 22258JAB7 2/22/2023 55 Mos 9/30/2027 249,000 $ 249,000 4.40% Credit Un of Tex Allen 22551KAB8 7/22/2022 36 Mos 7/22/2025 250,000 $ 250,000 3.30% Dannemora Fed Cr Un 236334AD0 12/28/2023 60 Mos 12/28/2028 250,000 $ 250,000 5.30% Dart Bk Mason 237412AS0 6/21/2022 42 Mos 12/22/2025 250,000 250,000 3.10% Dept of Labor Fed Cr Un 24951AAD8 9/14/2023 36 Mos 9/14/2026 250,000 250,000 5.60% Discover Bank 254673870 4/27/2022 36 Mos 4/28/2025 250,000 250,000 2.80% Dort Financial Cr Union 25844MAD0 10/28/2022 24 Mos 10/28/2024 250,000 250,000 4.60% Eaglemark Savings Bank 27004PCM3 3/2/2022 60 Mos 3/2/2027 250,000 250,000 2.00% Empower Credit Union 291916AB0 9/29/2023 60 Mos 9/29/2028 250,000 $ 250,000 5.15% Farmers&Merchants Bank 307811DP1 1/14/2022 60 Mos 1/14/2027 250,000 $ 250,000 1.20% Farmers State Bannk 310567AG7 11/14/2022 36 Mos 11/14/2025 250,000 $ 250,000 5.00% First Bank Blue Earth 32114MAY3 10/21/2022 30 Mos 4/21/2025 250,000 $ 250,000 4.45% First Federal S&L 32022EAW6 12/29/2021 60 Mos 12/29/2026 250,000 $ 250,000 1.05% First lndpt Bank 32056VAM9 8/23/2023 60 Mos 8/30/2028 250,000 $ 250,000 5.30% First Nat'I Bank 32110YXG5 6/24/2022 60 Mos 6/24/2027 250,000 $ 250,000 3.25% First Natl Bank/DAMA 32117BEQ7 12/30/2021 60 Mos 12/30/2026 250,000 $ 250,000 1.25% First Trust & Savs Bank 33743UAB2 2/9/2024 60 Mos 2/9/2029 249,000 $ 249,000 4.90% Flushing Bank 34387AFF1 11/4/2022 36 Mos 11/4/2025 $ 250,000 $ 250,000 4.70% Four Pts FCU Omaha 35089LAD5 6/29/2022 60 Mos 6/29/2027 $ 250,000 $ 250,000 3.40% Generations Bank 37149CAX5 5/12/2022 60 Mos 5/12/2027 $ 250,000 250,000 3.10% GESA Cr Union 37424PAH7 7/31/2023 36 Mos 7/31/2026 $ 250,000 250,000 5.25% GHS Fed Credit Union 36266LAA4 9/15/2022 60 Mos 9/15/2027 $ 250,000 250,000 3.80% Greenstate Credit Union 39573LDC9 1/26/2023 27 Mos. 4/29/2025 $ 249,000 249,000 2.65°/o Hapo Cmnty Cr Un 41138NAB4 8/31/2023 42 Mos. 2/26/2027 250,000 250,000 5.00% lntercredit Bank NA 458657MC4 1/31/2022 60 Mos 1/29/2027 250,000 250,000 1.35% Insight Credit Union 45791JAC0 2/27/2023 24 Mos 2/24/2025 250,000 250,000 5.10% JP Morgan Chase Bank 48128UMX4 9/30/2020 60 Mos 9/30/2025 250,000 250,000 0.50% Kemba Finl Credit Union 48836LAN2 9/21/2022 60 Mos 9/21/2027 250,000 250,000 4.10% Lebanon FCU PA 52248LAB2 8/4/2022 60 Mos 8/4/2027 250,000 250,000 3.55% Liberty First Cr Un 530520AM7 8/29/2023 48 Mos 8/30/2027 250,000 250,000 5.00% Lincoln Park Cmnty Cr Un 534574AC2 8/28/2023 60 Mos 8/28/2028 250,000 250,000 5.00% Live Oak Bankinig 538036UG7 2/1/2022 48 Mos 2/2/2026 250,000 250,000 1.25% Magnolia Bank 559582AL5 10/30/2020 54 Mos 4/30/2025 250,000 250,000 0.40% Malaga'sank FSB 56102AAJ5 5/29/2020 60 Mos 5/29/2025 250,000 250,000 0.70% Marlin Business Bank 57116ATM0 1/15/2020 60 Mos 1/15/2025 250,000 250,000 1.75% Midflorida Cr Union 59741QAA0 7/26/2023 60 Mos 7/26/2028 250,000 250,000 5.55% A-3 CITY OF RANCHO PALOS VERD ES PRELIMINARY MONTHLY TREASURER'S REPORT JUNE 2024 Issuer of Ac qu is itio n Maturity Market Book Investme nt In ves tme nt CUSIP# Date Te rm Date Val ue Va lue Yield Mineola Community Bank 60273NAB9 11/9/2022 60 Mos 11 /9/2027 250,000 250,000 5 .10% Money One FCU 60936TAL3 9/14/2023 so Mos 9/14/2028 250,000 250,000 5.07% Morgan Stanl ey Bk 6 1690UK82 6/2/2022 36 Mos 6/2/2025 250 ,000 250,000 3.05% Mounta in 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.20% Nat'I Bank of Commerce 633368FJ9 1/19/2022 60 Mos 1/19/2027 250 ,000 250 ,000 1.15% Nexbank 653344CD 1 5/15/2023 24 Mos 5/15/2025 s 250 ,000 250,000 5.07% Noble Fed Credit Union 65504UAA5 2/15/2024 60 Mos 2/15/2029 s 250 ,000 250 ,000 5.25% Nu mer ica Cred it Unio n 67054NBA0 1 1/4/2022 24 Mos 11/4/2024 250 ,000 250,000 4.85% Oklahoma Fed Credit Union 67886WAB3 11 /22/2022 24 Mos 11 /22/2024 250,000 250,000 5.00% Old Domin ion Nat ;I Bank 679585AZ2 1/20/2022 60 Mos 1/20/2027 250,000 250,000 1.15% Old Miss ion Bank 68002LCN6 4/29/2022 54 Mos 10/29 /2026 250,000 250,000 2.65% Onpath Fed Cr Unio n 68283MAG1 9/15/2022 so Mos 9/15/2027 250 ,000 250,000 3.80% Pacific Western Ba nk 69506YWM7 3f7/2023 so Mos 3/7/2028 250 ,000 250,000 5.15% Pathfin der Bank 70320KB R1 1/3 1/2022 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 s 250 ,000 5.30% Pittsburgh City Hall 72500MAA3 8/16/2022 60 Mos 8/16/2027 250 ,000 s 250 ,000 3.60% Popular Bank 73317AAY8 4/13/2022 36 Mos 4/14/2025 250,000 250 ,000 2 .45% Preferred Bank LA 740367MA2 7/17/2020 60 Mos 7/17/2025 250,000 250,000 0 .50% Raymond James Bank 75 472RAN1 11 /26/2019 60 Mos 11/26/2024 250,00 0 250,000 1.85% Rog ue C re di t Uni on 77535 MAL7 1/20/2023 48 Mos 1/20/2027 $ 250,000 250 ,00 0 5.05% Saco&Bi dd efo rds Savs 78577THR9 7/21/2022 60 Mos 7/21/2027 s 250,000 250,000 3.45% Sallie Mae Bank/Salt Lake 7954504P7 10/16/20 19 60Mos 10/16/2024 s 250 ,000 250,000 1.90% Sawyers Svgs Bank 805508BT4 10/28/2022 60 Mos 10/28/2027 s 250 ,000 s 250,000 4.90% Sharonview Fed Cr Union 819866BM5 8/15/2022 36 Mos 8/15/2025 250 ,000 $ 250,000 3.40% Sig nature Fed Cr Un 8267 1D AA5 10/27/2022 48 Mos 10/27/2026 248,000 s 248 ,000 4.60% Southwest Finl Fe d Cr Un 84485 EAJ6 9/2 1/2022 6 0 Mos 9/21/2027 25 0,000 $ 25 0,000 3.80% State Ba nk of India 856285RS2 11 /27/20 19 72 Mos 11 /27 /2024 250 ,000 s 250 ,000 2 .05% St Lawrence Fed Cr Un 79 1125AC1 12/1/2023 60Mos 12/1/2028 250,000 s 250 ,000 5.69% Texas Excha nge Bank 88241TJJ0 10/23/2020 6 0 Mos 10/23/2025 250,000 250,000 0.60% Texas Exchange Bank 88241TJN1 11/25/2020 60 Mos 11 /25/2025 250 ,000 250,000 0.60% Texas Exc hang e Bank 88241TJR2 12/18/2020 60 Mos 12/18/2025 250 ,000 250 ,000 0.60% Texas Exca nge BK SSB 8824 1TNV8 8/5/2022 5 1 Mos 11/16/2026 250,000 250,000 3.60% Th e Dist Cr Un 88340AAC5 12/22/2022 36 Mos 12/22/2025 250 ,000 250 ,000 5.25% Toyota Fi nancial Svgs Bank 89235MLE9 7/29/2021 60 Mos 7/29 /2026 250 ,000 250 ,000 0 .95% Truliant Fed Cr Un 89789AAE7 3/10/2023 30Mos 9/10/2025 250,000 250 ,000 5.05% Trusto ne Fin l 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 ,000 250,000 5.55% Tucson Fed Ce Un 8988 12AC6 9/8/2023 60 Mos 9/8/2028 250 ,000 250 ,000 5 .00% Universit y Credi t Union 914242AA0 2/21/2023 3 1 Mos 9/26/2025 249 ,000 249 ,000 4.00% United Bankers Bank 909557JP6 12/16/2021 56 Mos 8/17/2026 s 250 ,000 250,000 1.00% Valley Stro ng Cr Union 920133AJ4 12/14/2022 24 Mos 12/13/2024 250 ,000 250,000 5.10% Vision Bank of Iowa 92834CC L4 11 /29/2019 72 Mos 11 /2 9/2024 250 ,000 250,000 1.75% Workers Credit Uni on 98138MAT7 9/29/2022 60 Mos 9/29/2027 250 ,000 250 ,000 4.50% Wo rke rs Credit Union 98 138MAM2 4/17/2023 22 Mos 2/28/2025 249 ,000 249,000 1.49% Workers Fed Cr Un 98 138MCB4 11/15/2023 60 Mos 11/15/2027 250 ,000 250 ,000 5.35 % Treasury-Bank of New York (Vining Sparks) United States Treas 91282CEX5 6/30/2023 12 Mos 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 9 12796Y52 1/4/2024 6 Mos 7/5/2024 1,000,000 1,000,000 5.05% United States Treas 91282CAJ 0 2/28/2021 20 Mos 8/31 /2025 1,978 ,000 1,978 ,000 4.40% United States Treas 912797HE0 5/20 /2024 6 Mos 10/31 /2024 1,000 ,000 1,000,000 5 .12% Un ited States Tre as 91 2797KS5 5/20/2024 11 Mos 4/17/2025 1,000,000 1,000,000 5 .00% Agency Bonds Fed Ag ric MTG Corp 31424WFC1 1/22/2024 36 Mos 1/22/2027 1,000 ,000 1,000,000 5.00% Fed Farm Credit Bank 3133ELF4 1 6/8/2022 60 Mos 6/8/2027 1,000,000 1,000,000 0.94 % Fed Farm Credit Bank 3133 EMZ2 1 8/6/2021 54 Mos 4/6/2026 s 1,000 ,000 1,000 ,000 0 .69% Fed Fa rm Credit Bank 3133ENNX4 12/15/2022 26 Mos 2/14/2025 1,052 ,000 1,052 ,000 1.67% Fed Home Lo an Bank 3130ASYR4 8/30/2022 36 Mos 8/28/2025 1,000 ,000 1,000,000 4.00% Fed Ho me Loan MTG Corp 3134 H 1UZ4 2/26/2024 60 Mos 2/26/2029 1,000 ,000 1,000 ,000 5.00% Fed Home Loan Bank 313384840 3/8/2024 5Mos 8/9/2024 1,000 ,000 1,000 ,000 5.07% Fed Home Loa n Bank 313384ZE2 3/14/2024 4 Mos 7/10/2024 1,000,000 1,000,000 5.12% Fed Home Loa n Bank 3130B0H36 4/18/2024 11 Mos 3/14/2025 1,000 ,000 1,000,000 5.00% Total Inve stme nts 96,024,491 Summary: Loca l Agency Investment Fund (LA IF-CITY) 46 ,73 7,423 .32 MMDA -BMO 500,000 .00 Ce rt ificate of Deposit -Malaga Bank 4 ,26 4,068.12 Cert ificate of Deposit -St ife l 28,493,000.00 Treasury Bill s & Agency Bonds -Stifel 16,030,000.00 Total In vestme nts 96 ,0 24,491 .44 BMO Bb a lance 1,245,901 .74 Petty Ca sh 5,000 .00 Stifel Money Market 1,095 ,330 .61 Total Cash & Investment 98,370,723.79 Total Cash & Investment from above 98 ,370 ,723.79 A-4 NOTE: CITY OF RANCHO PALOS VERDES PRELIMINARY MONTHLY TREASURER'S REPORT JUNE 2024 SUMMARY OF CASH BALANCE BY INSTITUTION JUNE 2024 Stifel -CD 29% 1% BMO -Money M ark et (1) LA IF market values 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 material amoun ts withi n this report ; or omissions of material amounts to cause the report to be misleading . I certify that this report accurately reflects all City investments and complies with the in vestment policy of the City of Rancho Palos Verdes as approved by the City Council. Furthermore, I certify that sufficient investment liquidity and an ticipated revenues are available to meet the City's expe nditure requirements for th e next six months . Respectfully submitted , Treasurer Dated A-5