Loading...
CC SR 20240903 C - Treasurer Report July 2024 City CITY COUNCIL MEETING DATE: 09/03/2024 AGENDA REPORT AGENDA HEADING: Consent Calendar AGENDA TITLE: Consideration and possible action to receive the July 2024 Cash Balances/Monthly Treasurer’s Report. RECOMMENDED COUNCIL ACTION: (1) Receive and file the July 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 July 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 $95.8 million with over $36.2 million or 38% of the total cash balance in the Local Agency Investment Fund (LAIF). The City has a total of over $3.1 million or 4% of the total cash balance with BMO, which includes $1.6 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 4% is with Malaga Bank. Investments under the City’s brokerage firm Stifel include Certificates of Deposit (CD) investments of $28.7 million or 30%, Treasury Bills and Agency Bonds $22 million or 23% of the total cash balance, and a money market account has a balance of $1.3 million or 1 RANCHO PALOS VERDES 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.3 million is higher than usual due to the timing of investments that matured on July 31. This balance was reduced by the following month for the new purchases replacing the investments that matured on July 31. The securities are held by Bank of America and are FDIC-insured. In summary, the City’s General Fund has over $34 million or 36% of the cash balance, and the Capital Infrastructure Program (CIP) Fund has over $31 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, 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 July 2023 balance, the City’s cash balance decreased by approximately $1.3 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. The City seeks to recover these costs through FEMA reimbursement requests for the 2024 winter storms based on the declared federal disaster for Los Angeles County. Additionally, while comparing the balance in June 2024, the City’s cash balance decreased by $2.6 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, AMG and Associates for the Ladera Linda Community Park Project, Clarke Contracting for emergency storm drain repair work in the landslide area, Iteris, Inc. for traffic study at Western Avenue, the Los Angeles County Sheriff’s Department for law enforcement services , Sky Elements for the Fourth of July drone light show, Malcolm Drilling for emergency hydraugers tasks, Stay Green for citywide and emergency storm related landscape services, and Tyler Technologies for Munis SAAS annual payment and training fees. 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 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) Electronic Disbursements· Payroll Payroll Charges Postage Bank and Merchant Fees CalPers Lump Payment Petty Cash CDTFA CITY OF RANCHO PALOS VERDES PRELIMINARY MONTHLY TREASURER'S REPORT JULY 2024 BMO Operating 1,243,389.79 3,023,715.34 (4,504,947.70) (2,063,250.17) 2,013.62 13,000,000.00 (9,083,059.02) 1,617,861.86 490,989.01 297. 137.85 1,500.00 15,290.31 1,253,923.00 608.00 3,802.00 2,063,250.17 BMO MMDA 523,143.61 3,000,000.00 (2,000,000.00) 1,523,143.61 Petty Cash LAIF-CITY 5,000.00 46,737,423.32 512,370.62 (11,000,000.00) 5,000.00 36,249,793.94 (3) The net adjustment was due to void checks and other adjustment JULY 2024 CASH BALANCE BY MAJOR FUNDS 0010 /( 0% Malaga Bank Non-Negotiable Stifel Stifel CD Money Market Investment Total Cash 4,327,874.73 1,095,330.61 44,523,000.00 98,455,162.06 3,023,715.34 512,370.62 (4,504,947.70) (2,063,250.17) 211,418.66 6,250,000.00 6,463,432.28 16,000,000.00 (22,083,059.02) 4,327,874.73 1,306,749.27 50,773,000.00 95,803,423.41 ■GENERAL FUND 36% ■CIP 33% ■EQUIPMENT REPLACEMENT 3% ■1911 ACT 3% [JHABITAT RESTORATION 0% [JQUIMBY0¾ COTHER RESTRICTED FUNDS 25% A-1 • ■ • A-2 CASH BALANC ES BY FUND Unrestricted GENERAL FUND Restricted by Council Action B EAUTIFICATION FUND C IP EQU IPM ENT REPLACEM ENT BU ILDING RE PLACEM ENT EM PLOYE E PEN SION PLA N EM PLOYE E BE NEFITS Subtotal Restricted by Law or Ex ternal Agencies STR EET MA INTENANCE 1972ACT GAS TAX-SB 1 EL PRA DO CDBG CDBG-R 1911 ACT SOLI D WASTE A IR QUALI TY MANAGEME NT PRO POSITIONC PROPOS ITION A PU BLI C SAF ETY GRANTS MEASU RER MEASU RE M HA BITAT RESTO RATION SU BREG ION 1 MAINT ENANCE MEASU RE A MAIN TE NANCE ABALON E COVE SEWER D ISTRICT RPVTV GINS BURG CU LTURE ARTS BUI LD ING DONOR RESTR ICT ED CONTRI BUTI ONS FEDE RA L G RANTS STATE GRANTS FEDERAL GRANTS-AR PA QU IMBY LOW-MODERATE INCOME HOUSING A FFORDABLE HSNG IN LI EU EET MEASUR E A CA PITA L BIKEWAYS UNDERGROUND UTILI TIES ROA DWAY BEAU TIFIC ATION MEASUR E W WAT ER QUALITY FLOOD PROTECTION REDEVELO PMENT OBLI GATION RETIRE IMPROVEM ENT DISTR ICT 9 SPEC IAL TRUS TS Subtotal GRAND TOTAL CITY OF RANCHO PALOS VERDES PRELIMINARY MONTHLY TREASURER'S REPORT JULY 2024 BA LANCE FO RWAR D DE B IT CREDIT 36,199,719.15 28 ,370,379.26 30,367 ,460.28 0 .00 0 .00 0 .00 32 ,569,683 .56 171 ,727.49 900 ,08 0 .19 3,225,258.88 16,909.38 10,83 0.45 0 .00 0 .00 0.00 1,05 1,1 40 .82 5,867 .09 0.00 0.00 000 0.00 36 ,846,083.26 194,503.96 910,910.64 919 ,548 .77 103,013.66 41 ,256.02 31 ,057.59 159.65 0 .00 2,4 15 ,4 59.21 100,024 .58 0.00 52 ,502 .87 30 5 .87 000 24 ,709.26 0.00 1,200.00 0.00 0.00 0 00 2 ,980,282 .1 4 24,689.32 50 ,531 .29 50 5 ,262.44 18 ,049.20 22 ,52 1.03 81,464.85 369 .92 0.00 4 14 ,697.12 162 ,020.54 0.00 2 ,520 ,647 .96 119,050 .6 1 521.43 43,291.11 368 .17 0.00 3,058,569.65 135,795.71 125.00 530 ,1 24 .38 288 ,793.99 137,155.81 178.65 224 .44 000 809 ,922.44 4 ,106.92 3 ,692.37 47,117.67 327.87 0 .00 80 ,840 .30 655.91 1,1 31.29 0.00 0.00 000 0.00 0.00 0 .00 950,481 .50 16 ,883.56 0 .00 0.00 000 0 .00 1,546,816.84 8,020.34 115,892.50 3,799,163.1 2 2 1,29 1.34 546,272.31 115,864.75 6 15.30 25,659.75 447,465.58 2,300.13 0 .00 923 ,352.70 4 ,746.36 000 87,9 14 .74 4,353 .91 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,387 ,873.1 2 7 ,262 .33 38,443 .02 0 .00 0.00 0 .00 357,474.65 702 .1 2 578 .00 0 .00 0 .00 0.00 1,246,453.06 49 ,371.00 26,773.88 25,409,359.65 1,073,502 .75 1,01 1,753.70 98,455,162.06 29,638 ,385.97 32,290,124.62 Total Investment: Change In Change In Ending Cash Ending Cash CASH Ba lance Ba lance in % 34 ,202,638.13 (1 ,997 ,081 .02 -6% 0 .00 0.00 0% 31,841 ,330.86 (728 ,352 .70) -2% 3,231 ,337.8 1 6,078.93 0% 0 .00 0 .00 0% 1,057,007 .91 5,867 .09 1% 0.00 0.0 0 0% 36 ,129,676.58 (716,406.68 -2% 98 1,306 .4 1 6 1,757 .64 7 % 31 ,217.24 159.65 1% 2,5 15 ,483.79 100 ,024 .58 0% 52,808.74 305 .87 1% 23,509.26 (1,200.00) -5% 0.00 0.00 0% 2,954,440.1 7 (25 ,841 .97) -1% 500,790 .6 1 (4,471 .83) -1% 81 ,834 .77 369.92 0% 576,7 17 .66 162 ,020.54 39 % 2,639,177.14 118,529.18 5% 43,6 59 .28 368 .17 1% 3,194,240.36 135,670.71 4% 681,762 .56 15 1,638.18 29% 4 03.09 224.44 126% 810 ,336.99 414.55 0% 47,445.54 327.87 1% 80,364 .92 (475.38) -1 % 000 0.00 0% 0 .00 000 0 % 967 ,365.06 16,883.56 2 % 000 0 .00 0 % 1,438,944 .68 (107,872.16) -7 % 3,2 74 ,182 .1 5 (524 ,980.97) -14% 90,820 .30 (25,044.45) -22 % 449,765.71 2 ,300.13 1% 928 ,099.06 4 ,746.36 1% 92,268 .65 4 ,353.91 5% 0.00 0 .00 0% 30,823.18 000 0% 0.00 0 .00 0% 000 0 .00 0 % 1,356,692.43 (31 ,1 80 .69) -2 % 0 .00 0 .00 0% 357,598.77 124.12 0% 0 .00 0 .00 0% 1,269 ,0 50 .18 22 ,597 .12 2% 25,4 71,108.70 6 1,749.05 0% 95,803 ,423.41 (2,651 ,738.65) -3% 95,803,423 .41 A-3 CITY OF RANCHO PALOS VERDES PRELIMINARY MONTHLY TREASURER'S REPORT JULY 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 NIA NIA On Demand 36,249,794 36,249,794 4.52% Note{1) MMOA BMO NIA NIA On Demand 1,523,144 1.523,144 4.50% CD -Non-Negotiable Malaga Bank 2121/2024 6 Mos 8/19/2024 4.327.875 4,327,875 4.17% CD -Bank of America -Stifel (Non-Negotiable} A+ Fed Credit Union Austin 00224TAB2 6129/2022 60 Mos 6/2912027 250.000 250,000 3.55% Advia Cr Un 00782JAC6 9127/2023 60 Mos 912712028 s 250.000 s 250,000 5.07% Alaska USA Fed Ce Un 011852AH3 312212023 36 Mos 3/2312026 s 250.000 s 250,000 5.15% Alliant Credit Union 01882MAH5 11115/2023 60 Mos 1111512028 s 250.000 s 250,000 5.34% American Expr Natl Bank 02589ABM3 31312022 36 Mos 3/312025 s 250.000 s 250,000 1.80% American First Cr Un 02616ABX6 313012023 36 Mos 3/3012026 s 250.000 s 250.000 5.05% Arsenal Credit Union 04288LAA6 1120/2024 12 Mos 1/2112025 s 250.000 s 250.000 5.10% Auburn State Bank 05059LAC6 3131/2022 48 Mos 3/3112026 250.000 s 250.000 2.10% Austin Telco Fed Cr Union 052392BN6 912112022 24 Mos 9/2012024 s 250,000 s 250.000 3.70% Bank of Baroda 06063HMT7 712212020 60 Mos 712212025 s 250,000 s 250.000 0.65% Bank Forward 062163BN9 1212812019 60 Mos 12118/2024 s 250,000 s 250.000 1.75% Bank Hapoalim 06251A2Q2 12114/2020 60 Mos 1212512025 $ 250,000 $ 250.000 0.50% Bankers Bank 06610RBL2 4/1312022 42Mos 10114/2025 $ 250,000 $ 250,000 2.05% BankNewport Rhode 06647JAV6 813/2022 48 Mos 8/312026 $ 250,000 $ 250,000 3.50% Bankunited 066519QK8 31512021 60 Mos 3/512026 250,000 250,000 0.65% Baxter Credit Union 07181JAB0 6123/2022 36 Mos 6123/2025 250.000 250,000 3.10% B aycoa st Bank 072727AZ3 112412020 60 Mos 1124/2025 250.000 250,000 1.70% Beal Bank USA 07371CK32 31912022 48 Mos 314/2026 250,000 250,000 1.90% BOM Bank 09776DAA2 5123/2024 48 Mos 5/3012028 250,000 250,000 5.25% Capital One 14042RQB0 1111712021 60 Mos 11117/2026 250,000 250,000 1.10% Capital One 14042RQS3 4120/2022 60 Mos 4/2012027 250,000 250,000 2.80% Celtic Bank 15118RUX3 411712020 60 Mos 411712025 250.000 250,000 1.50% Centris Fed Cr Un 15643VAB8 512412023 24 Mos 5/2412025 250.000 250.000 5.02% Chief Finl Fed Cr Un Rochester 16863LAB1 712912022 60Mos 7/2912027 250.000 250,000 3.50% Chief Finl Fed Cr Un Rochester 16863LAE5 1011212022 36 Mos 10114/2025 250.000 250.000 4.60% Clearpat!l Fed Cr Un 18507MAD3 7/912024 60 Mos 713012029 s 250.000 250.000 5.40% Coastlife Credit Union 19058LABO 211312023 36 Mos 2112/2026 s 250.000 $ 250.000 4.65% Comenity Capital Bank 20033A3A2 4/14/2022 60 Mos 411412027 $ 250,000 $ 250.000 2.65% Community West Cr Un 20416JAC8 12123/2022 30 Mos 6/2312025 s 250.000 $ 250.000 5.00% Communitywide FCU 20416TAV4 1218/2022 36 Mos 1218/2025 s 250,000 $ 250,000 5.00% Connectone Bank 20786AOL6 912412021 60 Mos 9/2712026 s 250,000 s 250.000 0.80% Connexus Credit Union 20825WAT7 5126/2022 36 Mos 512712025 s 250,000 $ 250,000 3.00% County School FCU 22258JAB7 212212023 55 Mos 9130/2027 s 249,000 $ 249,000 4.40% Credit Un of Tex Allen 22551KAB8 712212022 36 Mos 712212025 250,000 250,000 3.30% Dannemora Fed Cr Un 236334AO0 1212812023 60 Mos 12/28/2028 250.000 250,000 5.30% Dart Bk Mason 237412AS0 6/2112022 42 Mos 1212212025 250,000 250,000 3.10% Dept of labor Fed Cr Un 24951AAD8 911412023 36 Mos 9114/2026 250.000 250,000 5.60% Di sea ver Bank 254673B70 412712022 36 Mos 412812025 250.000 s 250,000 2.80% Dort Financial Cr Union 25844MAD0 10/28/2022 24Mos 1012812024 250,000 s 250.000 4.60% Eaglemark Savings Bank 27004PCM3 31212022 60 Mos 31212027 250.000 $ 250,000 2.00% Empower Credit Union 291916AB0 912912023 60 Mos 9/2912028 250.000 250.000 5.15% Farmers&Merchants Bank 307811DP1 1114/2022 60 Mos 1/1412027 250.000 s 250.000 1.20% Farmers State Bannk 310567AG7 11114/2022 36Mos 11/1412025 250.000 $ 250.000 5.00% First Bank Blue Eart!l 32114MAY3 10121/2022 30Mos 4121/2025 250.000 $ 250,000 4.45% First Federal S&l 32022EAW6 1212912021 60 Mos 1212912026 s 250.000 250,000 1.05% First lndpt Bank 32056VAM9 812312023 60 Mos 8/3012028 $ 250,000 250,000 5.30% First Nat'I Bank 32110YXG5 6124/2022 60 Mos 6124/2027 s 250.000 250,000 3.25% First Natl Bank/DAMA 32117BEQ7 12130/2021 60 Mos 12130/2026 $ 250.000 250,000 1.25% First Trust & Savs Bank 33743UAB2 21912024 60 Mos 21912029 249,000 249,000 4.90% Flus!li ng Bank 34387AFF1 1114/2022 36 Mos 111412025 250,000 250,000 4.70% Four Pts FCU Omaha 35089LAD5 612912022 60 Mos 6/29/2027 250,000 250,000 3.40% Generations Bank 37149CAX5 5/1212022 60 Mos 511212027 250,000 $ 250.000 3.10% GESA Cr Union 37424PAH7 7131/2023 36 Mos 7131/2026 250.000 s 250,000 5.25% GHS Fed Credit Union 36266LAA4 9115/2022 60 Mos 911512027 250,000 s 250.000 3.80% Green state Credit Un ion 39573LOC9 112612023 27 Mos. 4129/2025 249,000 s 249.000 2.65% Hapo Cmnty Cr Un 41138NAB4 8131/2023 42 Mos. 212612027 250.000 $ 250,000 5.00% lntercredit Bank NA 458657MC4 113112022 60 Mos 112912027 250.000 250,000 1.35% Insight Credit Union 45791JAC0 212712023 24Mos 212412025 s 250.000 250,000 5.10% JP Morgan Chase Bank 48128UMX4 9/3012020 60 Mos 9/3012025 s 250.000 250,000 0.50% Kemba Finl Credit Union 48836LAN2 912112022 60 Mos 912112027 s 250.000 250,000 4.10% Lebanon FCU PA 52248LAB2 8/412022 60Mos 81412027 $ 250,000 250.000 3.55% liberty First Cr Un 530520AM7 8129/2023 48 Mos 8/3012027 s 250,000 250,000 5.00% Lincoln Park Cmn!y Cr Un 534574AC2 8128/2023 60 Mos 812812028 s 250,000 s 250,000 5.00% live Oak Bankinig 538036UG7 21112022 48 Mos 21212026 $ 250,000 $ 250.000 1.25% Magnolia Bank 559582Al5 10/3012020 54 Mos 4/3012025 $ 250,000 s 250.000 0.40% Malaga Bank FSB 56102AAJ5 5129/2020 60 Mos 512912025 250,000 250.000 0.70% Marlin Business Bank 57116ATM0 1/1512020 60 Mos 1/1512025 250,000 250,000 1.75% Midflorida Cr Union 59741QAA0 7126/2023 60 Mos 7126/2028 250.000 250,000 5.55% A-4 CITY OF RANCHO PALOS VERDES PRELIMINARY MONTHLY TREASURER'S REPORT JULY 2024 Issuer of Acquisition Maturity Market Book Investment Investment CUSIP# Date Term Date Value Value Yield Mineola Community Bank 60273NAB9 111912022 60 Mos 111912027 250 ,000 250,000 5.10% Money One FCU 60936TAL3 911 412023 60Mos 9/1412028 250 ,000 250 ,000 5.07% Morgan Stanley Bk 61690UK82 61212022 36 Mos 612/2025 250 ,000 250 ,000 3.05% Mountain Amer Fed CR UN 62384RALO 8131 12022 36 Mos 8/2912025 250 ,000 $ 250,000 3.50% Mutual First Fed Cr Union 62825MAA2 81312023 24 Mos 814/2025 250 ,000 $ 250,000 5.20% Nat'I Bank of Commerce 633368FJ9 1/1 912022 60 Mos 111912027 250,000 $ 250,000 1.1 5% Nexbank 653344CD1 511 512 023 24 Mos 5/1512025 250 ,000 $ 250 ,000 5.07% Noble Fed Credit Union 65504UAA5 211512024 60Mos 211512029 250 ,000 $ 250,000 5.25% Numerica Credit Union 67054NBA0 111412022 24 Mos 11 /4/2024 250 ,000 $ 250,000 4.85% Oklahoma Fed Credit Un ion 67886WAB3 1112212022 24 Mos 11/22/2024 250 ,000 250,000 5.00% Old Dominion Nat;I Bank 679585AZ2 112012022 60 Mos 1/20/2 027 250,000 $ 250,000 1.15% Old Mission Bank 68002LCN6 4/29/2022 54Mos 10/29/2026 250,000 $ 250 ,000 2.65% Onpath Fed Cr Union 68283MAG1 9/1 512022 60Mos 9/15/2027 250,000 $ 250 ,000 3.80% Pacific Western Bank 69506YWM7 31712023 60 Mos 317/2028 250,000 $ 250,000 5.15% Pathfinder Bank 70320KBR1 113 1/2022 60 Mos 1/29/2027 250,000 $ 250 ,000 1.20% Pima Fed Cr Un 722000AC0 811712023 36 Mos 8/17/2026 250,000 $ 250,000 5.30 % Pittsburgh City Hall 72500MAA3 8/16/2022 60 Mos 8/1612027 250,000 $ 250,000 3.60% Popular Bank 73317AAY8 411312022 36 Mos 4/14/2025 250,000 $ 250 ,000 2.45% Preferred Ban k LA 740367MA2 711 712020 60 Mos 7/17/2025 250,000 $ 250 ,000 0.50 % Raymond James Ban k 75472RAN1 11/2612019 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 112022 60 Mos 7/21/2027 250 ,000 250,000 3.45% Sallie Mae Bank/Salt Lake 7954504P7 1011612019 60 Mos 10/16/2024 250,000 250 ,000 1.90% Sawyers Svgs Bank 805508BT4 1012812022 60 Mos 10/28/2027 250 ,000 250 ,000 4.90 % Sharon view Fed Cr Union 819866BM5 8/1512022 36 Mos 8/1 5/2025 250,000 250 ,000 3.40 % Signature Fed Cr Un 82671DAA5 1012712022 48 Mos 10/27/2026 248,000 248,000 4 .60% Southwest F inl Fed Cr Un 84485EAJ6 912112022 60 Mos 9/2112 027 250,000 250,000 3.80% State Ban k of India 856285RS2 1112712019 72 Mos 11/27/2024 250 ,000 250 ,000 2.05 % St Lawrence Fed Cr Un 791125AC1 121112023 60 Mos 121 112028 250 ,000 250 ,000 5.69% Texas Exchange Bank 88241TJJO 10/23/2020 60 Mos 10123/2025 250,000 250,000 0.60% Texas Exchange Bank 88241TJN1 1112512020 60 Mos 11/2512025 $ 250,000 250 ,000 0 .60% Texas Exchange Bank 88241TJR2 1211812020 60 Mos 1211 812025 $ 250,000 250,000 0 .60% Te xas Excange BK SSB 88241TNV8 8/512022 51 Mos 11/1 612026 $ 250 ,000 250,000 3.60% The Dist Cr Un 88340AAC5 12/22/2022 36 Mos 1212212025 $ 250 ,000 250,000 5.25% Toyota Financial Svgs Bank 89235MLE9 712912021 60 Mos 712912026 $ 250,000 250,000 0.95% Truliant Fed Cr Un 89789AAE7 3110/2023 30 Mos 9/1012025 $ 250,000 250,000 5.05% Trustone Finl Cr Un 89841MAF4 711912022 60 Mos 711912027 $ 250 ,000 250,000 3.40% TTCU Fed Cr Union 89854LAK9 7/2612023 60 Mos 7/2612028 250,000 250,000 5.55% Tucson Fed Ce Un 898812AC6 9/8/2023 60 Mos 9/812028 250,000 250,000 5.00% University Credit Un ion 9 14242AA0 2121/2023 31 Mos 9126/2025 249,000 249 ,000 4.00% United Bankers Bank 909557JP6 12/16/2021 56 Mos 8117/2026 250,000 $ 250,000 1.00% USB Bank 90355GPK6 7/3/2024 48 Mos 7110/2028 $ 250,000 $ 250 ,000 4.60% Valley Strong Cr Union 920 133AJ4 12/14/2022 24 Mos 1211 3/2024 $ 250,000 $ 250,000 5.10% Vision Bank of Iowa 92834CCL4 11 /29/2019 72Mos 11/29/2024 $ 250 ,000 $ 250,000 1.75% Workers Credit Union 98 138MAT7 9/29/2022 60Mos 9129/2027 $ 250 ,000 $ 250,000 4 .50% Workers Credit Union 98138MAM2 4/17/2023 22 Mos 2128/2025 249,000 $ 249 ,000 1.49% Workers Fed Cr Un 98 138MCB4 11115/2023 60 Mos 11/15/2027 250,000 $ 250 ,000 5.35% Treasury-Bank of New York(Vining Sparks) United States Treas 912828XZ8 6/30/2020 60 Mos 6/30/2025 1,000 ,000 1,000,000 2.75% United States Treas 91282CAJ0 2/28/2021 20 Mos 8131/2 025 1,978 ,000 1,978 ,000 4.40% United States Treas 9 12797HE0 5/20/2024 6 Mos 10/31 /2024 1,000,000 1,000 ,000 5.12% United States Treas 912797KS5 5/20/2024 11 Mos 4/17/2025 1,000,000 1,000,000 5.00% United States Treas 91282CDZ1 7/1 /2024 7 Mos 21 15/2025 1,000 ,000 1,000,000 5.24% United States Treas 91282CDZ1 7/8/2024 7 Mos 2/1 5/2025 2,000 ,000 2,000,000 5.13% United States Treas 91282CEU 1 7/8/2024 11 Mos 6/15/2025 3,000 ,000 3,000,000 4.94 % United States Treas 912828R36 7/1 912024 23 Mos 5/1 512026 3,000 ,000 3 ,000 ,000 4.48% Agency Bonds Fed Agric MTG Corp 31424WFC1 1/2212024 36 Mos 1/2212027 1,000 ,000 1,000 ,000 5.00% Fed Farm Credit Bank 3133ELF41 618/2022 60 Mos 6/812027 1,000 ,000 1,000 ,000 0.94% Fed Farm Cred it Bank 3133EMZ21 81612021 54 Mos 4/612026 1,000,000 1,000 ,000 0.69% Fed Farm Cred it Bank 3133ENNX4 1211512022 26 Mos 211412025 1,052,000 1,052 ,000 1.67% Fed Home Loan Bank 3130ASYR4 813012022 36 Mos 8/2812025 1,000,000 1,000 ,000 4.00% Fed Home Loan MTG Corp 3134H 1UZ4 2126 12024 60 Mos 212612029 1,000 ,000 1,000,000 5.00% Fed Home Loan Bank 313384B40 31812024 5 Mos 81912024 1,000,000 1,000 ,000 5.07% Fed Home Loan Bank 3130B0H36 4/1812024 11 Mos 3114/2025 1,000 ,000 1,000 ,000 5.00% Total Investments $ 92,873,812 Summary: Local Agency Investment Fund (LAIF-CITY) 36,249,793.94 MMDA-BMO 1,523,143.61 Certificate of Deposit -Malaga Bank 4,327,874.73 Certificate of Deposit -Stifel 28 ,743 ,000 .00 Treasury Bills & Agency Bonds -Stifel 22,030,000.00 Total Investments 92,873,812.28 BMO Bbalance 1,617 ,861 .86 Petty Cash 5,000 .00 Stifel Money Market 1,306,749.27 Total Cash & Investment 95 ,803 ,423.41 Total Cash & Investment from above 95 ,803,423 .41 A-5 NOTE: CITY OF RANCHO PALOS VERDES PRELIMINARY MONTHLY TREASURER'S REPORT JULY 2024 SUMMARY OF CASH BALANCE BY INSTITUTION JULY 2024 Stifel -Money Market 1% BMO -Money Market 2% Malaga Bank -CD 4% (1) LAIF market values will be reported to vary from book value ii the City calculated share of total LAIF assets is less than the City book value . To the best of my know ledge, there are no mi sstatements of material amounts wi thin t hi s report; or om issions of materia l amounts to cause the report to be misleadi ng I certify that this report accurately reflects all City investments and complies with t he investment policy of the City of Rancho Pa los Verdes as approved by the City Council. Furthermore , I certify that sufficient i nvestment liquidity and antici pated revenues are available to meet the City's expenditure requ i rements for the next six months . Respectfully subm itted , Treasurer Dated