Loading...
CC SR 20241001 C - August Treasury Report CITY COUNCIL MEETING DATE: 10/01/2024 AGENDA REPORT AGENDA HEADING: Consent Calendar AGENDA TITLE: Consideration and possible action to receive the August 2024 Cash Balances/Monthly Treasurer’s Report. RECOMMENDED COUNCIL ACTION: (1) Receive and file the August 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 August 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 $94 million with over $29.2 million or 31% of the total cash balance in the Local Agency Investment Fund (LAIF). The City has a total of over $4.3 million or 5% of the total cash balance with BMO, which includes $2.8 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 interest earnings instead of leaving the amount in the BMO checking account. Additionally, over $4.3 million or 5% is with Malaga Bank. Investments under the City’s brokerage firm Stifel include Certificates of Deposit (CD) investments of $28.5 million or 30%, Treasury Bills and Agency Bonds $27.4 million or 29% of the total cash balance, and a money market account has a balance of $257,853 1 CITYOF RANCHO PALOS VERDES 7L or less than 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. In summary, the City’s General Fund has over $34 million or 37% of the cash balance, and the Capital Infrastructure Program (CIP) Fund has approximately $30 million or 32% 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, approximately $0.1 million or less than 1% in the Quimby Fund, and over $23 million or 25% in Other Restricted Funds. Compared to the August 2023 balance, the City’s cash balance decreased by approximately $3 million, primarily due to increased expenditures for the Portuguese Bend Landslide area. This decrease is expected due to the emergency repairs needed to mitigate the severity of the landslide movement. The City seeks to recover these costs through Federal Emergency Management Agency (FEMA) reimbursement requests for the 2024 winter storms based on the declared federal disaster for Los Angeles County , or other funding sources with the assistance of the county, state and federal partners . Additionally, while comparing the balance in July 2024, the City’s cash balance decreased by $1.7 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, Clarke Contracting for emergency sewer repair in the landslide area, Cotton, Shires and Associates for geologic evaluation in the Portuguese Bend Landslide area, Geologic Associates for Portuguese Bend Landslide remediation, Hardy and Harper for patching potholes and repairs in Seaview and landslide emergency repairs, LSA Associates for environmental monitoring services, Malcolm Drilling for emergency hydraugers tasks, Ocean Blue Environmental for emergency sewage services at Ginger Root Lane and Narcissa Drive, and Stay Green for citywide and emergency storm related landscape services. All expenditures were disbursed in accordance with the Fiscal Year 2024-25 budget and the City Council’s approved expenditures related to the landslide. 2 A-1 BMO C IT Y OF RANCHO PALOS VERDES PRELIMINARY MONTHLY TREASURER'S REPORT AUG UST 2024 BMO Malaga Bank Non-Negotiable Operating MMDA Petty Cash LAIF-CITY CD BEGINNING BALANCE PLUS: DEPOSITS PLUS: INTEREST EARNINGS(1) LESS: CHECK DISBURSEMENTS LESS: ELECTRONIC DISBURSEMENTS(2) ADJUSTMENTS(3) PLUS: TRANSFERS IN LESS : TR ANSFERS OUT ENDING BALANCE (1) All LAIF interest is paid quarterly . (2) Electronic Disbursements: Payroll Payroll Charges Bank and Merchant Fees CalPers Tier Adj Petty Cash Unemployment In surance/Claims (3) Th e net adjustment was due to miscellaneous adjustment. 1,617 ,861 .86 3,186,055 .5 1 (3 ,703,009.65) (1 ,193,806.94) (16 ,809.59) 7 ,0D0 ,0D0 .00 (4 ,095 ,588.90) 2 ,794 ,702.29 733,754.54 436 ,679.36 19,818.01 2 ,597 .66 387 .00 570 .37 1,193,806 .94 1,523 ,143.61 1,523,143.61 5 ,D00 .00 36,249,793.94 4 ,327,874 .73 (7 ,000,000.00) 5,000 .00 29 ,249,793 .94 4,327,874.73 AUGUST 2024 CASH BALANCE BY MAJOR FUNDS 0% 0% Stifel Stifel Money Market Investment Total Cash 1,306,749 .27 50,773,000.00 95,803,423.41 3,186,055.51 (3,703,009.65) (1 ,193,806 .94) (1,D48,895 .96) 5 , 149,000.0D 4,083 ,294.45 7,D0D ,0D0 .D0 (11 ,095 ,588 .90) 257,853.31 55 ,922,DD0.00 94 ,080 ,367.88 ■GENERAL FUND 37% ■C IP32% ■EQUIPMENT REPLACEMENT 3% 111911 ACT 3% DHABITAT RESTORATIO N 0% D QU IMBYO% C OTHER RESTRICTED FUNDS 25% A-2 CASH BALANCES BY FUND Unrestricted GENERAL FUN D Restricted by Council Action BEAUTIFI CAT ION FU ND CIP EQUIPMENT REPLACEMENT BUIL DING REPLACEMENT EMP LOYEE PENS IO N PLAN EMPLOYEE BE NEFITS Subtotal Restricted bv Law or External Aoencies STREET MA INTENANCE 1972 ACT GAS TAX-S B1 EL PRADO CDBG CDBG-R 191 1 ACT SOLID WASTE AIR QUALI TY MANAGEMENT PROPOS ITION C PROPOS ITI ON A PUBLIC SAFETY GRANTS MEASURER MEASURE M HAB IT AT RESTORATION SUBREG ION 1 MA INTENA NCE MEASURE A MAINTENANCE ABALONE COVE SEWER DISTR ICT RPVTV GINSBURG CULTURE ARTS BUILDING DONOR RESTR ICTED CONTR IBUTIONS FEDERA L GRANTS STATE GRANTS FEDERAL GRANTS-ARPA QUIMBY LOW-MODERATE INCOME HOUS ING AFFORDABLE HS NG IN LI EU EET MEASURE A CAPITAL BIKEWAYS UNDERGROUND UTILITIES ROADWAY BEA UTIFI CATION MEAS UREW WATER QUALITY FLOOD PROTECTION REDEVELOPMENT OBLIGATION RETIRE IMPROVEMENT DISTR ICT 9 SPECIAL TRUSTS Subtotal GRAND TOTAL CI T Y OF RANCHO PALOS V ERD ES PR E LIMINARY MONTHLY TREASURER'S RE PORT AUGUST 2024 BA LANCE FORWARD DEB IT CREDIT 34,202,638.13 17,7 84,89 7.25 17,32 3,9 89.3 8 0.00 0.00 0.00 3 1,84 1,330.86 0.00 2.12 1,3 13.22 3,231 ,337.81 160.00 7,475 .25 0 .00 0 .0 0 0.00 1.057 ,007 .91 0.00 0.00 0.00 0.00 0.00 36,12 9,676.58 160 .00 2,1 28 ,788 .47 981 ,306.4 1 111 ,551 .27 63 ,507.45 31 ,2 17.24 0.00 0 .00 2.515,483.79 102 .257.07 0.00 52 .808 74 135.96 0.00 23,509.26 14.342 .00 10.000.00 0 .00 0.00 0.00 2 ,954,440.17 34,444 .67 35 ,722.49 500,790.6 1 27 ,836.77 28,196 .10 81 ,834 .77 0 .00 0 .00 576 ,717 .66 63 ,64 1.17 0.00 2,639, 177.14 76,724.64 0.00 43 ,659.28 0.00 0.00 3,194,240.36 47 ,725.82 0.00 681 ,762 .56 53 ,890.98 51 ,373.77 403.09 0.00 224.44 8 10 ,336 .99 0.00 5,9 41 .43 47,445.54 0.00 0 .00 80 ,364 .92 969.32 11 ,593 .91 0 .00 0.00 0.00 0.00 0.00 0.00 967,365.06 5,000.00 1,984.56 0.00 0.00 0 .00 1 ,438.944 .68 79 ,485 .00 2,255 .00 3.274 , 182.15 0.00 460 ,400 .28 90,820.30 0.00 5,752 .00 449,765 .71 0.00 0.00 928,099 .06 0.00 0.00 92,268.65 0.00 0.00 0.00 0.00 0 .00 30,823.18 0.00 0 .00 0 .00 0 .00 0.00 0 .00 0 .00 0.00 1,356,692.43 0.00 15,828.15 0 .00 0.00 0.00 357,598.77 0.00 0.00 0.00 0.00 0.00 1 .269.050.18 67,039.75 47 ,599.77 25,471 ,108 .70 685,044.42 740,379.35 95,803,423.4 1 18,470,101.67 20,1 93,157.20 Tota l Investment: Chanqe In Chanqe In Ending Cash Ending Cash CASH Ba lance Ba lance in % 34,66 3,54 6.00 460 ,907.8 7 1% 0 .00 0.00 0% 29.720,0 17.64 {2,12 1,3 13.22 -7% 3,224,022 .56 (7,315.25) 0% 0 .00 0.00 0% 1,057 .007.9 1 0.00 0% 0.00 0.0 0 0% 34,001,048 .11 (2 ,128 626 .47) -6% 1,029 ,350 .23 48 ,043 .82 5% 31 ,217 .24 0.00 0% 2 ,617.740 .86 102 ,257 .07 0% 52 ,944 .70 135 .96 0% 27 ,85 1.2 6 4,342 .00 18% 0.00 0.00 0% 2 ,953 ,162.35 (1 .277.82 0% 500 ,431 .28 (359.33) 0% 81 ,834 .77 0.00 0% 640,358.83 63,641.17 11% 2,7 15,901 .78 76,724 .64 3% 43,659 .28 0.00 0% 3,241 .966 .18 47,725 .82 1% 684 .279.77 2,517.21 0% 178.65 (224.44 -56% 804,395 .56 (5 ,94 1.43 -1% 47,445 .54 0.00 0% 69 ,740 .33 (10 ,624 .59) -13% 0 .00 0 .00 0% 0 .00 0 .00 0% 970.380.50 3,0 15.44 0% 0.00 0 .00 0% 1,516.174.68 77 .23000 5% 2 ,813 ,781 .87 {460,400.28 -14% 85 ,068 .30 (5 .752 .00 -6% 449 ,765.7 1 0.00 0% 928,099 .06 0.00 0% 92,268 .65 0.00 0% 0.00 0 .00 0% 30.823.18 0.00 0% 0.00 0.00 0% 0.00 0.00 0% 1,3 40 ,864.28 (15,828.15) -1% 0.00 0.00 0% 357 ,598.77 0.00 0% 0 .0 0 0.00 0% 1 .288,490.16 19,439.9 8 2% 25,415,773,77 (55,334 .93) 0% 94,080,367 .88 (1 ,723,05 5.5 3) -2% 94,080,367 .88 A-3 CITY OF RANCHO PALOS VERDES PRELIMINARY MONTHLY TREASURER'S REPORT AUGUST2024 Issuer of Acquisition Maturity Market Book Investment Investment CUSIP# Date Term Date Value Value Ylald Local Agency Investment Fund (LAIF-CITY) State of California NIA NIA On Demand 29,249,794 29,249,794 4.58% Nole (1) MMDA BMO NIA NIA On Demand 1,523,144 1,523,144 4.50% CD -Non-Negotiable Malaga Bank 811912024 36 Mos 811912027 4,327,875 4,327,875 3.92% CO -Bank of America -Stifel (Non-Negotiable) A+ Fed Credit Union Austin 00224TAB2 612912022 60Mos 6/2912027 $ 250,000 s 250,000 3.55% AdviaCrUn 00782JAC6 9127/2023 60Mos 912712028 $ 250,000 $ 250,000 5.07% Alaska USA Fed Ce Un 011852AH3 3122/2023 38 Mos 312312026 $ 250,000 $ 250,000 5.15% Alliant Credit Union 01882MAH5 11/15/2023 60Mos 11/15/2028 $ 250,000 $ 250,000 5.34% American Expr Natl Bank 02589ABM3 313/2022 36 Mos 313/2025 $ 250,000 $ 250,000 1.80% American First Cr Un 02616ABX6 3130/2023 36 Mos 313012026 $ 250,000 $ 250,000 5.05% Arsenal Credit Union 04288LM6 1/20/2024 12 Mos 1121/2025 $ 250,000 $ 250,000 5.10% Auburn State Bank 05059LAC6 3131/2022 48Mos 3/3112026 s 250,000 $ 250,000 2.10% Austin Telco Fed Cr Union 052392BN6 9/2112022 24Mos 912012024 $ 250,000 $ 250,000 3.70% Bank of Baroda 06063HMT7 712212020 60 Mos 712212025 $ 250,000 $ 250,000 0.65% Bank Forward 062163BN9 1212812019 60 Mos 1211812024 s 250,000 $ 250,000 1.75% Bank Hapoalim 06251A2Q2 1211412020 60 Mos 1212512025 $ 250,000 $ 250,000 0.50% Bankers Bank 06610RBL2 411312022 42 Mos 1011412025 $ 250,000 250,000 2.05% BankNewport Rhode 06647JAV6 81312022 48 Mos 81312026 $ 250,000 250,000 3.50% Bankunited 066519QK8 31512021 60 Mos 31512026 $ 250,000 250,000 0.65% Baxter Credit Union 07181JA80 612312022 36 Mos 612312025 $ 250,000 250,000 3.10% Baycoast Bank 072727AZ3 112412020 60 Mos 112412025 $ 250,000 250,000 1.70% Beal Bank USA 07371CK32 31912022 48 Mos 31412026 250,000 250,000 1.90% SOM Bank 09776DAA2 5/23/2024 48 Mos 513012028 $ 250,000 $ 250,000 5.25% Capital One 14042RQBO 11117/2021 60Mos 1111712026 s 250,000 s 250,000 1.10% Capital One 14042RQS3 4/20/2022 60 Mos 412012027 s 250,000 s 250,000 2.80% Celtic Bank 15118RUX3 4/17/2020 60Mos 4117/2025 250,000 $ 250,000 1.50% Centris Fed Cr Un 15643VAB8 512412023 24Mos 512412025 250,000 $ 250,000 5.02% Chief Finl Fed Cr Un Rochester 16863LAB1 7/2912022 60Mos 712912027 250,000 $ 250,000 3.50% Chief Finl Fed Cr Un Rochester 16863LAE5 1011212022 36Mos 10/1412025 $ 250,000 $ 250,000 4.60% Citizens Bank 173477CC2 81512024 60 Mos 812112029 $ 249,000 $ 249,000 4.60% Clearpath Fed Cr Un 18507MA03 71912024 60 Mos 713012029 $ 250,000 $ 250,000 5.40% Coastlife Credit Union 19058LABO 211312023 36 Mos 211212026 $ 250,000 250,000 4.65% Comenity Capital Bank 20033A3A2 411412022 60 Mos 411412027 $ 250,000 250,000 2.65% Community West Cr Un 20416JAC8 1212312022 30 Mos 612312025 $ 250,000 250,000 5.00% Communitywide FCU 20416TAV4 121812022 36 Mos 121812025 $ 250,000 250,000 5.00% Connectone Bank 20786ADL6 912412021 60 Mos 912712026 $ 250,000 250,000 0.80% Connexus Credit Union 20825WAT7 512612022 36 Mos 512712025 $ 250,000 250,000 3.00% County School FCU 22258JAB7 2/22/2023 55 Mos 9130/2027 $ 249,000 $ 249,000 4.40% Credit Un of Tex Allen 22551KAB8 7122/2022 36Mos 7122/2025 250,000 $ 250,000 3.30% Dannemora Fed Cr Un 236334ADO 12/28/2023 60Mos 12/28/2028 $ 250,000 $ 250,000 5.30% Dart Bk Mason 237412ASO 6/2112022 42Mos 12/22/2025 $ 250,000 250,000 3.10% Dept of Labor Fed Cr Un 24951AAD8 911412023 36Mos 9/14/2026 $ 250,000 $ 250,000 5.60% Discover Bank 254673B70 4/27/2022 36Mos 4/28/2025 $ 250,000 $ 250,000 2.80% Dort Financial Cr Union 25844MADO 10/2812022 24 Mos 10/28/2024 $ 250,000 $ 250,000 4.60% Eaglemark Savings Bank 27004PCM3 3/212022 60Mos 3/2/2027 s 250,000 $ 250,000 2.00% Empower Credit Union 291916ABO 9129/2023 60 Mos 912912028 s 250,000 $ 250,000 5.15% Farmers&Merchants Bank 307811DP1 111412022 60 Mos 111412027 $ 250,000 $ 250,000 1.20% Farmers State Bannk 310567AG7 1111412022 36 Mos 1111412025 $ 250,000 $ 250,000 5.00% First Bank Blue Earth 32114MAY3 1012112022 30 Mos 412112025 $ 250,000 250,000 4.45% First lndpt Bank 32056VAM9 812312023 60 Mos 813012028 $ 250,000 250,000 5.30% First Nat'I Bank 32110YXG5 612412022 60 Mos 612412027 $ 250,000 250,000 3.25% First Natl Bank/DAMA 32117BEQ7 1213012021 60 Mos 1213012026 $ 250,000 250,000 1.25% First Trust & Savs Bank 33743UA82 21912024 60 Mos 21912029 $ 249,000 249,000 4.90% Flushing Bank 34387AFF1 111412022 36 Mos 111412025 250,000 250,000 4.70% Four Pis FCU Omaha 35089LAD5 612912022 60 Mos 612912027 $ 250,000 250,000 3.40% Generations Bank 37149CAX5 5/12/2022 60 Mos 5112/2027 $ 250,000 $ 250,000 3.10% GESA Cr Union 37424PAH7 7131/2023 36 Mos 713112026 250,000 250,000 5.25% GHS Fed Credit Union 36266LAA4 911512022 60Mos 9/15/2027 $ 250,000 250,000 3.80% Greenstate Credit Union 39573LOC9 1126/2023 27 Mos. 4/2912025 $ 249,000 $ 249,000 2.65% Hapo Cmnty Cr Un 41138NAB4 8/31/2023 42Mos. 2126/2027 $ 250,000 $ 250,000 5.00% lntercredit Bank NA 458657MC4 1131/2022 60Mos 1/29/2027 $ 250,000 $ 250,000 1.35% Insight Credit Union 45791JACO 2/27/2023 24Mos 2124/2025 $ 250,000 $ 250,000 5.10% JP Morgan Chase Bank 48128UMX4 9130/2020 60Mos 9130/2025 $ 250,000 $ 250,000 0.50% Kemba Finl Credit Union 48836LAN2 9/2112022 60Mos 9/21/2027 $ 250,000 $ 250,000 4.10% Lebanon FCU PA 52248LAB2 8/412022 60 Mos 8/412027 $ 250,000 $ 250,000 3.55% Liberty First Cr Un 530520AM7 812912023 48 Mos 8130/2027 $ 250,000 $ 250,000 5.00% Lincoln Park Cmnty Cr Un 534574AC2 812812023 60 Mos 612812028 $ 250,000 $ 250,000 5.00% Live Oak Bankinig 538036UG7 2/112022 48 Mos 212/2026 $ 250,000 $ 250,000 1_25% Magnolia Bank 559582AL5 10/3012020 54 Mos 4130/2025 $ 250,000 $ 250,000 0.40% Malaga Bank FSB 56102AAJ5 512912020 60 Mos 512912025 $ 250,000 $ 250,000 0.70% Marlin Business Bank 57116ATMO 1/15/2020 60 Mos 1/1512025 $ 250,000 $ 250,000 1.75% Midflor!da Cr Union 59741QAAO 712612023 60 Mos 712612028 $ 250,000 $ 250,000 5.55% A-4 CITY OF RANCHO PALOS VERDES PRELIMINARY MONTHLY TREASURER'S REPORT AUGUST 2024 Issuer of Acq ui sition Maturi ty Market Book In vestment Investment CUSIP# Date Term Date Va lue Value Yield Mineola Commu nity Bank 60273NAB9 1119/2022 60 Mos 11/9/2027 250 ,000 250,000 5.10% Money O ne FCU 60936TAL3 9/14/2023 60 Mos 9/14/2028 250,000 250,000 5.07% Mo rg an Stanl ey Bk 61690UK82 6/2/2022 36 Mos 6/2/2025 250,000 250,000 3.05% Mou nt ain Amer Fed CR UN 62384RALO 8/31/2022 36 fy1os 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 Ba nk of Commerce 633368FJ9 1/19/2022 60 Mos 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% Noble Fed Credit Union 65504UAA5 2/15/2024 60 Mos 2/15/2029 250,000 250,000 5.25% Nu merica Credit Union 67054NBAO 11/4/2022 24 Mos 11 /4/2024 250,000 250,000 4.85% Ok lahoma Fed Cred it Union 67886WAB3 11 /22/2022 24 Mos 11 /22/2024 250,000 250,000 5.00% Ol d Dominion Nat ;I Bank 679585AZ2 1/20/2022 60 Mos 1/20/2027 250,000 250,000 1.15% 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 60 Mos 9/15/2027 250,000 250,000 3.801% Pacific Western Bank 69506YWM7 3/7/2023 60 Mos 3/7/2028 250,000 250,000 5.15% Pathfinder Bank 70320KBR1 1/31/2022 60 Mos 1/29/2027 250,000 250 ,000 1.20% Pima Fed er Un 722000ACO 8/17/2023 36 Mos 8/17/2026 250,000 250 ,000 5.30% Pittsburgh Ci ty Hall 72500MAA3 8/16/2022 60 Mos 8/16/2027 250,000 250,000 3.60 % Pop ular Ba nk 73317AAY8 4/13/2022 36 Mos 4/14/2025 250,000 250,000 2.45% Pre ferred Bank LA 740367MA2 7/17/2020 60 Mos 7/17/2025 250,000 250,000 0.5 0% Raymo nd James Bank 75472RAN 1 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&Bidde fords Savs 78577THR9 7/21/2022 60 Mos 7/21/2027 250,000 250,000 3.45% Sallie Mae Ba nk/Sall Lake 7954504P7 10/16/2019 60 Mos 10/16/2024 250,000 250,000 1.90% Sal,\')'e rs Svgs Bank 805508BT4 10/28/2022 60 Mos 10/28/2027 250,000 250,000 4.90% Sharonview Fed Cr Union 8198668M5 8/15/2022 36 Mo s 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.60% Sout hwest Finl Fed Cr Un 84485EAJ6 9/21/2022 60 Mos 9/2112027 250,000 250,000 3.80% Sta te Bank of India 856285RS2 11 /27/2019 72 Mos 11 /27/2024 250 ,000 250,000 2.05% St La wrence Fed Cr Un 791125AC1 12/1/2023 60 Mos 12/1/2028 250 ,000 250,000 5.69 % Texas Excha nge Bank 88241T JJO 10/23/2020 60 Mos 10/23/2025 s 250 ,000 250,000 0.60 % Texas Excha ng e Bank 88241TJN1 11/25/2020 60 Mos 11/25/2025 $ 250,000 250,000 0.60% Te xas Exchange Ba nk 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 Dist Cr Un 88340AAC5 12/22/2022 36 Mos 12/22/2025 $ 250,000 250,000 5.25% Toyota Fina ncia l Svgs Bank 89235MLE9 7/29/202 1 60 Mos 7/29/2026 250,000 250,000 0.95% Trulia nt 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% Tucso n Fed Ce Un 898812AC6 9/8/2023 60 Mos 9/8/2028 250,000 250,000 5.0 0% University Credit Union 914242AAO 2/21/2023 31 Mos 9/26/2025 249 ,000 249 ,000 4.00% United Ba nkers Bank 909557JP6 12/16/2021 56 Mos 8/17/2026 250 ,000 250,000 1.00% USB Bank 90355GPK6 7/3/2024 48 Mos 7/10/2028 250 ,000 250,000 4.60% Va ll ey Stro ng Cr Union 920133AJ4 12/14/2022 24 Mos 12/13/2024 250,000 250,000 5.10% Vision Bank of Iowa 92834CCL4 11 /29/20 19 72 Mos 11 /29/2024 250,000 250,000 1.751% Wo rke rs Credit Union 98138MAT7 9/29/2022 60 Mos 9/29/2027 250,000 250,000 4.50°/o Workers Credit Union 98138MAM2 4/17/2023 22 Mos 2/28/2025 $ 249,000 249,000 1.49% Workers Fed Cr Un 98138MCB4 11/15/2023 60 Mos 11/1 5/2027 s 250,000 250,000 5.35% Treasury-Bank of New York (Stifel) United States Treas 912828XZ8 6/30/2020 60 Mos 6/30/2025 1,000 ,000 1,000,000 2.75% United States Treas 91282CAJO 2/28/2021 20 Mos 8/3 1/2025 1,978,000 1,978,000 4.40% Unlled States Trea s 912797HEO 5/20/2024 6 Mos 10/31/2024 1,000 ,000 1,000,000 5.12% United Sta tes Trea s 9 12797KS5 5/20/2024 11 Mos 4/17/2025 1,000 ,000 1,000,000 5.00% United States Trea s 91282CDZ1 7/1/2024 7 Mos 2/15/2025 s 1,000,000 1,000,000 5.24 % United St ates Treas 91282CDZ1 7/8/2024 7 Mos 2/15/2025 2,000 ,000 2,000,000 5.13% United Stat es Treas 91282CEU 1 7/8/2024 11 Mos 6/15/2025 3,000,000 3,000,000 4.94% Uni ted States Trea s 912828R36 7/19/2024 23 Mo s 5/15/2026 3,000,000 3,000,000 4.48% United States Treas 91282CEHO 8/12/2024 8 Mos 4/15/2025 1,000,000 1,000,000 4.57 % Age ncy Bonds (Stife l) Fed Agric MTG Corp 3 1424WFC1 1/22/2024 36 Mos 1/22/2027 1,000,000 1,000,000 5.00% Fed Farm Credi t 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/28/2025 1,000 ,000 1,000,000 4.00% Fed Home Loan MTG Co rp 3134H1UZ4 2/26/2024 60 Mos 2/26/2029 1,000 ,000 1,000,000 5.00% Fed Home Loa n Bank 3130BOH36 4/18/2024 11 Mos 3/14/2025 1,000 ,000 1,000,000 5.00% Fed Home Loan Bank 3130ARYF2 8/2/2024 34 Mo s 5/24/2027 500,000 500 ,000 4.00% Fed Home Loan Bank 3130ASF53 8/2/2024 35 Mos 6/30/2027 500 ,000 500,000 4.00% Fed Fa rm Credit Bank 3133ERMH1 8/2/2024 60 Mos 7/29/2027 3,000,000 3,000,000 5.00% Fed Fa rm Credit Bank 3133ERRE3 8/22/2024 60 Mos 8/28/2029 s 1,000,000 1,000,000 4.72% Fed Farm Credit Bank 3 133 ERRE3 8/23/2024 60Mos 8/28/2029 1,000,000 1,000,000 4.72% Fed Home Loan Bank 3134HAFB4 8/23/2024 60 Mos 8/14/2029 400,000 400,000 4.20% Fed Farm Credit Bank 3133ERM H1 8/29/2024 59 Mos 7/29/2027 1,000,000 1,000,000 5.00% Total In ves tments $ 87,622,812 Summary: Local Age ncy In vestmen t Fund (LA IF -C ITY) 29 ,249,793.94 MMDA-BMO 1,523 ,143.61 Cert ificate or Deposit -Malaga Bank 4,327 ,874 .73 Ce rtificate of Deposit -St ifel 28,492 ,000.00 Treasury Bills & Agency Bonds -Stifel 27,430,000.00 14,978,000 12,452,000 27,430,000 Tota l Investments 91,022,812.28 16 .5% 13.7% 30 .1% BMO Bbalance 2 ,794,702.29 Petty Cash 5,000.00 Sti fel Money Market 257,853.31 A-5 Tota l Cash & Investment Total Cash & Investment rrom above NOTE: 94,080,367.88 94,080,367.88 CITY OF RANCHO PALOS VERDES PRELIMINARY MONTHLY TREASURER'S REPORT AUGUST 2024 SUMMARY OF CASH BALANCE BY INSTITUTION AUGUST 2024 0% BMO -M oney M ar ket (1) LAlF market values will be reported to vary rrom book va lue if the City ca lculated share of total LAIF assets is less than the City book value . To the best of my knowledge , there are no misstatements of material amounts within 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 investment policy of the City of Rancho Palos Verdes as approved by the City Council. Furthermore, I certify that sufficient Investment liquidity and anticipated revenues are available to meet the City's expenditure requirements for the next six months . Respectfully submitted , Treasurer Mal aga Ba n k -CD 5%