Loading...
CC SR 20240604 D - City April Treasury Report CITY COUNCIL MEETING DATE: 06/04/2024 AGENDA REPORT AGENDA HEADING: Consent Calendar AGENDA TITLE: Consideration and possible action to receive the April 2024 Cash Balances/Monthly Treasurer’s Report. RECOMMENDED COUNCIL ACTION: (1) Receive and file the April 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 April 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 $99 million with over $43.7 million or 44% of the total cash balance in the Local Agency Investment Fund (LAIF). The City has over $2.7 million or 3% of the total cash balance with BMO and over $4.2 million or 4% with Malaga Bank. The City opened a new money market account with BMO to earn additional interest. Total aggregate amount including operating checking will maintain at $5 million. Additionally, the investments under the City’s brokerage firm Stifel includes Certificates of Deposit (CD) investments over $28.7 million or 29%, Treasury Bills and Agency Bonds $14.5 million or 15% of the total cash balance, and a money market account has a balance of $41,000 or less than 1% of the total cash balance. The City holds a money market account with Stifel for transaction s related to the selling and purchasing of 1 investments, as applicable. The securities are held by Bank of America and are FDIC- insured. In summary, the City’s General Fund has over $35 million or 36% of the cash balance, and the Capital Infrastructure Program (CIP) Fund has over $34 million or 35% 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 $72,000 or less than 1% in the Habitat Restoration Fund, over $0.1 million or less than 1% in the Quimby Fund, and over $22 million or 23% in Other Restricted Funds. Compared to the April 2023 balance, the City’s cash balance increased by $0.8 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 March 2024, the City’s cash balance increased by $3.5 million, mainly attributed to the timing of billing for general services and disbursements for City-approved projects and the property tax revenues. The major disbursements for this month included Aleshire and Wynder for legal services, ACE Capital Engineer for retaining wall repair at Crest Road, Ambit Construction for Point Vicente Interpretive Center restroom project, Clark Contracting for emergency sinkhole repairs at the residential streets, Hardy and Harper and Hout Construction for Portuguese Bend area landslide emergency repair, and West Coast Arborist for annual tree trimming services. 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) ADJUSTMENTS(3) PLUS: TRANSFERS IN LESS : TRANSFERS OUT ENDING BALANCE (1) AU LAIF interest is paid quarterly . (2) Electron ic Disbursements ; Payroll Payroll Charges Postage Bank and Merchant Fees CDTFA BMO Operating 2,545 ,814 .27 6,234 ,994 .71 (2 ,524 ,900.78) (834 ,475.21 ) (1 ,728.00) 3,000,000.00 (5 ,664 ,981 .96) 2,754,723.03 466,342 .04 274 ,155.67 3,000.00 87 ,327.50 3,650 .00 834,475.21 (3) The net adjustment was due to void checks and other adjustment . C ITY OF RANCHO PALOS VERDES MONTHLY TREASURER'S REPORT APRIL 2024 Malaga Bank BMO Non-Negotlable MMOA Petty Cash LAIF-CITY CD 5,000 .00 46 ,206,831 .62 4,240 ,337 .13 530,591 .70 23,730.99 5,000 ,000.00 (3 ,000,000 .00) 5,000 ,000.00 5,000.00 43,737,423 .32 4,264 ,068 .12 APRIL 2024 CASH BALANCE BY MAJOR FUNDS 0% 0% Stifel Stifel Money Market Investment Total Cash 291 ,945.21 42 ,273.000.00 95 ,562,928 .23 6,234 ,994 .71 554 ,322.69 (2,524,900.78) (834,475.21) (250 ,150.79) 1,000,000.00 748,121 .21 8,000,000.00 (8 ,664,981 .96) 41 ,7 94.42 43 ,273,000.00 99,076,008.89 ■GENERAL FUND 36% ■CIP 35% ■EQUIPMENT REPLACEMENT 3% a1911 ACT 3% DHABITAT RESTORATION 0% DQUIMBY0% COTHER RESTRICTED FUNDS 23% 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 Aaencies STREET MAINTENANCE 1972 ACT GAS TAX-SB1 EL PRADO CDBG CDBG-R 1911 ACT SOLID WASTE AIR QUALITY MAN A GEMENT PROPOSITION C PROPOSITION A PUBLIC SA FETY GR A NTS MEASURER MEASURE M HABITAT RESTORATION SUBREGION 1 MAINTENANCE MEASURE A MAINTENANCE AB A LONE COVE SEWER DISTRICT RPVTV GIN SBURG CULTURE ARTS BUILDING DONOR RESTRICTED CONTR IBUT IONS FEDERAL GRANTS STATE GRANTS FEDERAL GRANTS-ARPA QUIMBY LOW-MODERATE INCOME HOUSING AFFORDABLE HSNG IN LIEU EET MEASURE A CAP ITAL BIKEWAYS UNDERGROUND UTILITIES ROADWAY BEAUTIFIC ATION MEASURE W WATER QUALITY FLOOD PROTECTION REDEVELOPMENT OBLIGATION RETIRE IMPROVEMENT DISTRICT 9 SPECIAL TRUSTS Subtotal GRAND TOTAL CITY OF RANCHO PALOS V ERDES MONTHLY TREASURER'S REPORT APRIL 2024 BALANCE FORWARD DEBIT CRED IT 31,562,036.42 17,936,303.78 13,981,111.13 0.00 0.00 0.00 34 ,951,115 .16 200 ,790.28 935,385.10 3 ,363 ,710.36 18,745.73 31 ,404 .23 0 .00 0.00 0 .00 1,175,240.34 6,587 .38 0 .00 0.00 0.00 0 .00 39,490,065 .86 226,123.39 966,789.33 683,761 .96 88 ,240 .16 43,062 .22 30,758.12 172.40 0 .00 2,111 ,284 .78 100 ,638 .33 0 .00 50,542 .65 1,317.80 0 .00 12 ,889.76 0.00 5,862 .50 0.00 0 .00 0 .00 2,692,778 .95 277 ,310 .87 22 ,240 .00 391 ,790.91 20 ,625.02 38 ,583 .83 66 ,570.48 349 .70 0 .00 357,021 .29 71 ,601.49 88 ,602 .50 2,238,437 .14 98 ,044.87 521.44 84 ,863 .57 634.48 0 .00 2 ,867 ,587 .72 125,798.11 0.00 570,483.13 127 ,664 .23 99 ,104.32 71 ,5 18.70 400.87 0.00 788,498 .78 4,380.46 896.59 71 ,363.27 493.42 0 .00 45 ,912.17 15,427 .19 1,509.90 0.00 0.00 0.00 0.00 0.00 0.00 940,414 .26 5,207 .23 465 .14 0 .00 0.00 0 .00 1,559,092 .94 35 ,364.94 13,665.00 4,458 ,101 .02 25 ,522 .62 183,737 .33 128,448.96 871 .38 3,612 .00 390,508.49 55 ,126.25 0.00 914 ,449 .12 5,125.61 0.00 87,067 .01 488 .02 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 1,460 ,830.27 8,417 .74 40 ,892 .04 0 .00 0.00 0 .00 288 ,657 .82 1,617 .96 264 ,687 .00 0.00 0.00 0 .00 1,147,192.68 45 ,701 .50 10,546 .89 24,510,825.95 1,1 16,542.65 81 7,988.70 95,562,928.23 19,278,969.82 15,765,889.16 Total Investment: Change In Change In Endina Cash Endina Cash CASH Balance Balance in% 35,517,229.07 3,955,192.65 13% 0.00 0 .00 0% 34 ,216,520.34 (734 ,594 .82 -2% 3,351 ,051 .86 (12,658.50 0% 0 .00 0 .00 0% 1,181 ,827.72 6 ,587 .38 1% 0 .00 0 .00 0% 38,749,399.92 (740,665 .941 -2% 728 ,939.90 45,177 .94 7% 30 ,930 .52 172.40 1% 2 ,211 ,923 .11 100,638 .33 0% 51,860.45 1,317.80 3% 7 ,027 .26 (5 ,862 .50) -45% 0.00 0 .00 0% 2,947 ,849.82 255 ,070.87 9% 373 ,832 .10 (17 ,958 81) -5% 66 ,920 .18 349.70 1% 340,020 .28 (17,001 .01) -5% 2 ,335 ,960 .57 97 ,523.43 4% 85,498.05 634.48 1% 2,993 ,385 .83 125,798 .11 4% 599 ,043 .04 28 ,559 .91 5% 71 ,919 .57 400.87 1% 791 ,982 .65 3,483.87 0% 71 ,856 .69 493.42 1% 59 ,829.46 13 ,917 .29 30% 0.00 0 .00 0% 0.00 0 .00 0% 945 ,156 .35 4,742 .09 1% 0 .00 0.00 0% 1,580,792.88 21,699 .94 1% 4,299,886 .31 (158 ,214 .71 -4% 125,708 .34 (2 ,740 62) -2 % 445 ,634 .74 55 ,126.25 14% 919 ,574 .73 5,125.61 1% 87 ,555 .03 488.02 1% 0 .00 0.00 0% 0.00 0.00 0% 0.00 0 .00 0% 0.00 0 .00 0% 1,428,355 .97 (32,474 .30) -2% 0.00 0 .00 0% 25 ,588.78 (263,069.04) -91% 0.00 0.00 0% 1,182,347 .29 35 ,154 .61 3% 24,809,379.90 298,553.95 1% 99,076,008.89 3,513,080.66 4% 99,076,008 .89 A-2 CITY OF RANCHO PALOS VERDES MONTHLY INVESTMENT REPORT APRIL 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 43,737,423 43,737,423 4.27% Note (1) MMDA BMD NIA N/A On Demand 5,000,000 5,000,000 4.50% CD -Non-Negotiable Malaga Bank 2/21/2024 6 Mos 8/19/2024 4,264,068 4,264,068 4.25% 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 s 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 712212020 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 07181JABO 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% Capital One 14042RQBO 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 19058LABO 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 s 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 236334ADO 12/28/2023 60 Mos 12/28/2028 250,000 $ 250,000 5.30% Dart Bk Mason 237412ASO 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 254673B70 4/27/2022 36 Mos 4/28/2025 $ 250,000 $ 250,000 2.80%> Oort Financial Cr Union 25844MADO 10/28/2022 24 Mos 10/28/2024 $ 250,000 250,000 4.60% Eaglemark Savings Bank 27004PCM3 3/2/2022 60 Mos 3/212027 250,000 250,000 2.00% Empower Credit Union 291916ABO 9/29/2023 60 Mos 9/29/2028 250,000 s 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°/o First lndpt Bank 32056VAM9 8/23/2023 60 Mos 8/30/2028 $ 250,000 250,000 5.30% First Nat'! 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 219/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% 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 45791JACO 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 Bank FSB 56102AAJ5 5/29/2020 60 Mos 5/29/2025 250,000 250,000 0.70% Marlin Business Bank 57116ATMO 1/15/2020 60 Mos 1/15/2025 250,000 250,000 1.75% Midflorida Cr Union 59741QAAO 7/26/2023 60 Mos 7/26/2028 250,000 250,000 5.55% A-3 CITY OF RANCHO PALOS VERDES MONTHLY TREASURER'S REPORT APRIL 2024 Issuer of Acquisition Maturity Market Book In vestment Investment CUSIP# Date Term Date Value Value 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 60 Mos 9/14/2028 250,000 250,000 5.07% Morgan Stanley Bk 61690UK82 6/2/2022 36 Mos 6/212025 250 ,000 250,000 3.05% Mountain Amer Fed CR UN 62384RAL0 8/31/2022 36 Mos 8/2 9/2 025 250 ,000 250,000 3.50% Mutual First Fed Cr Union 62825MM2 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 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.35% Noble Fed Credit Union 65504UM5 21 15/2024 60 Mos 2/15/2029 250 ,000 250,000 5.25% Numerica Credit Union 67054NBA0 11/4 /2022 24 Mos 11/4/2024 250,000 250,000 4.85% Oklahoma Fed Credit Union 67886WAB3 11 /22/2022 24 Mos 11/2212024 250,000 250,000 5.00% Old 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 .80% 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/2 9/2027 250,000 s 250,000 1.20% Pima Fed Cr Un 722000AC0 8/17/2023 36 Mos 8/17/2026 250 ,0 00 s 250,000 5.30% Pittsburgh City Hall 72500MM3 8/16/2022 60 Mos 8/16/2027 250,000 s 250,000 3.60% Popular Bank 73317MY8 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 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&Biddefords Savs 78577THR9 7/2 1/2022 60 Mos 7/2 1/2027 250,000 250,000 3.45% Sallie Mae Ban k/Salt Lake 7954504P7 10/16/2019 60 Mos 10/16/2024 250,000 250,000 1.90% Sawyers Svgs Bank 805508BT4 10/28/2022 60 Mos 10/28/2027 250,000 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 82671DM5 10/27/2022 48 Mos 10/2 7/2026 248 ,000 248,000 4.60% Southwest Finl Fed Cr Un 84485EAJ6 9/21/2022 60 Mos 9/21/2027 250,000 250,000 3.80% State Bank of India 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/2 025 250,000 250,000 0 .6 0% Texas Exchange Bank 88241T JN1 11 /25/2020 60 Mos 11/25/2025 250,000 250,000 0.60% Texas Exchange Bank 88241TJR2 12118/2020 60 Mos 121 18/2025 250,000 250,000 0 .60% Texas Excange BK SSB 88241TNV8 8/5/2022 51 Mos 11/16/2 026 250,000 250,000 3 .60% The Dist Cr Un 88340MC5 12/22/2022 36 Mos 12/22/2025 250,000 250,000 5 .25% Toyota Financial Svgs Bank 89235MLE9 7/29/2021 60 Mos 7/29/2026 250,000 250,000 0 .95% Truliant Fed Cr Un 89789ME7 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,000 250,000 5.55 % Tucson Fed Ce Un 898812AC6 9/8/2023 60 Mos 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 914242M0 212 1/2023 31 Mos 9/26/2025 249,000 249 ,000 4.00% United Bankers Bank 909557JP6 12/16/2021 56 Mos 8/17/2026 250 ,000 250,000 1.00% Valley Stro ng Cr Union 920133AJ4 12114/2022 24 Mos 12/13/2024 250 ,000 250,000 5 .10% Vision Bank of 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/2 023 22 Mos 2/28/2025 249,000 249,000 1.49% Workers Fed Cr Un 98138MCB4 11/15/2023 60 Mos 11/15/2027 250,000 250,000 5.35% Treasury-Bank of New Yo rk (Vining Sparks) United States Treas 9 1282C EX5 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 912796Y52 1/4/2024 6 Mos 7/5/2024 1,000,000 1,000 ,000 5.05% United States Treas 9 1282CAJ0 2/28/2021 20 Mos 8/31/2025 1,978 ,000 1,978,000 4.40% 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 6/8/2022 60 Mos 6/8/2027 1,000,000 1,000,000 0.94% Fed Farm Credit Bank 3133EMZ21 8/6/2021 54 Mos 4/6/2026 1,000,000 1,000,000 0 .6 9% Fed Farm Credit Bank 3133ENYX2 6/17/2022 24 Mos 6/17/2024 $ 500,000 500,000 3 .25% Fed Farm Credit 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 Corp 3134H1UZ4 2126/2024 60 Mos 2126/2029 1,000,000 1,000 ,000 5 .00% Fed Home Loan Bank 313384B40 3/8/2024 5 Mos 8/9/2024 1,000,000 1,000,000 5.07% Fed Home Loan Bank 313384ZE2 3/14/2024 4 Mos 7/10/2024 1,000 ,000 1,000,000 5 .12% Fed Home Loan Bank 3130B0H36 4/18/2024 11 Mos 3/14/2025 1,000 ,000 1,000,000 5.00% Total Investments 96,274,491 Summary: Local Agency Investment Fund (LAIF-CITY) 43 ,737,423 .32 MMDA-BMO 5,000,000.00 Certificate of Deposit -Malaga Ban k 4,264 ,068 .12 Certificate of Deposit -Stifel 28,743,000.00 Treasury Bills & Agency Bonds -Stifel 14,530,000.00 Total Investments 96,274,491.44 BMO Bbalance 2,754,723.03 Petty Cash 5,000.00 Stifel Money Market 41 ,794.42 Total Cas h & In ves tment 99 ,076 ,008 .89 Total Cash & Investment from above 99,076,008 .89 A-4 NOTE: CITY OF RANCHO PALOS VERDES MONTHLY TREASURER'S REPORT APRIL 2024 SUMMARY OF CASH BALANCE BY INSTITUTION APRIL 2024 St ifel -CD&Bond 29% 4% St ifel -Money Market 0% BMO -Money Market (1) LAIF market values will be reported to vary from book value if the Ci ty calcul ated share of total LAIF assets is less than the Ci ty book value. To the best of my knowledge, there are no misstatements of material amounts wi thin this report; or omissions of material amoun ts to cause the report to be misleading . I certify that this report accurately reflects all City inves tments and co mplies with the investment policy of the City of Rancho Palos Verdes as approved by the City Counci l. Furth er more , I certi fy that sufficient investm ent liquidity and anticipated revenues are available to meet the City's expenditure requirements for the next six months . Respectfully submitted , Treasurer A-5