Loading...
CC SR 20230606 C - City Mar 2023 Treasury Report CITY COUNCIL MEETING DATE: 06/06/2023 AGENDA REPORT AGENDA HEADING: Consent Calendar AGENDA TITLE: Consideration and possible action to receive and file the March 2023 Cash Balances/Monthly Treasurer’s Report. RECOMMENDED COUNCIL ACTION: (1) Receive and file the March 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, Deputy Director of Finance 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 March 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 over $95 million with approximately $55 million or 58% of the total cash balance in the Local Agency Investment Fund (LAIF). The City has approximately $3 million or 3% of the total cash balance with Bank of the West and over $4 million or 5% with Malaga Bank. Additionally, the investments under the City’s brokerage firm Stifel includes Certificates of Deposit (CD) investments over $24 million or 25%, Treasury Bills and Agency Bonds over $8.5 million or 9% of the total cash balance, and a money market account at $42,000 or less than 1%. The City holds a money market account with Stifel for the transaction of selling and purchase purposes. The securities are held by Bank of America and are FDIC-insured. 1 In summary, the City’s General Fund has approximately $30 million or 32% in the cash balance, and the Capital Infrastructure Program (CIP) Fund has over $37 million or 40% in cash balance. The remaining cash balances are in the Equipment Replacement Fund with over $3 million or 3%, over $2 million or 2% in the 1911 Act Fund, over $0.2 million or less than 1% in the Habitat Restoration Fund, over $0.3 million or 1% in the Quimby Fund, and over $21 million or 23% in Other Restricted Funds. The City’s cash balance increased by over $15 million compared to the March 2022 balance. As reported in the prior month’s report, the significant overall increase in cash balance since the prior year includes the second payment of American Rescue Plan Act of $4.9 million received in July 2022, $8 million from Bank of the West for the partial funding of the Ladera Linda Community Park Project in April 2022, and the remaining $2.1 million is a combination of increased in revenues and timing of disbursements in General Fund and Other Special Revenue funds. Additionally, while comparing the balance in February 2023, the City’s cash balance decreased by $1.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, Griffin Structure, GTS, and Johnson Favaro for Ladera Linda Community Park construction, the Los Angeles County Sheriff’s Department for law enforcement services, Hardy and Harper for street maintenance, LSA and Servpro for Portuguese Bend Landslide remediation, South Bay Toyota for the acquisition of a vehicle, Stay Green for landscaping services, and West Coast Arborist for tree trimming services. All expenditures were disbursed in accordance with the Fiscal Year 2022-23 budget. 2 BEGINNING BALANCE PLUS: DEPOSITS PLUS: IN TEREST EARNINGS(1 ) LESS : CHECK DISBURSEMENTS LESS: ELECTRONIC DISBURSEMENTS(2) A DJUSTMENTS(3) PLUS : TRANSFERS IN LESS: TRANSFERS OUT ENDING BALANCE (1) All LAIF interest is paid quarterly (2) Electronic Disbursements : Payroll Payroll Charges Bank and Merchant Fees Postage Bank of the West Operating 5,536 ,482 .28 4 ,593 ,256.86 (4 ,506 ,826 .33) (979,197.01 ) 2 ,601 46 (1,722,344.65) 2 ,923 ,972.61 597 ,400.52 363 ,768.54 16,027 .95 2 ,000.00 979 ,197.01 (3) The net adjustment was due to a void check and miscellaneous adjustment. CITY OF RANCHO PALOS VERDES MONTHLY TREASURER'S REPORT MARCH 2023 Malaga Bank Non-Negotiable Stifel Petty Cash LAIF-CITY CD Money Market 5 ,000 .00 54 ,921 ,633 .95 4 ,339 ,378 .75 (168,144.94) 53,692 .84 (2,989.38) 160,000 .00 5 ,000.00 54 ,921 ,633.95 4 ,339 ,378 .75 42 ,558.52 MARCH 2023 CASH BALANCE BY MAJOR FUNDS 0% 0% Stifel Investment Total Cash 32 ,048 ,000.00 96,682 ,350.04 4 ,593 ,256 .86 53 ,692.84 (4,506 ,826 33) (979 ,197.01) (387.92) 750,000.00 910 ,000.00 (1,722 ,344 .65) 32 ,798,000.00 95,030,543.83 ■GENERAL FUND 32% ■CIP 40% ■EQUIPMENT REPLACEMENT 3% ■1911 ACT 2% DHABITAT RESTORATION 0% DQUIMBY0% COTHER RESTRICTED FUNDS 23% A-1 CASH BALANCES BY FUND Unrestncted 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 MA INTENANCE 1972 ACT EL PRADO CDBG CDBG-R 1911 ACT SOLID WASTE AIR QUALITY MANAGEMENT PROPOSITION C PROPOSITION A PUBLIC SAFETY GRANTS MEASURER MEASURE M HABITAT RESTORATION SUBREGION 1 MAINTENANCE MEASURE A MAINTENANCE ABALONE COVE SEWER DISTRICT RPVTV GINSBURG CULTURE ARTS BUILDING DONOR RESTRICTED CONTRIBUTIONS FEDERAL GRANTS STATE GRANTS FEDERAL GRANTS-ARPA QUIMBY LOW-MODERATE INCOME HOUSING AFFORDABLE HSNG IN LIEU EET MEASURE A CAPITAL BIKEWAYS UNDERGROUND UTILITIES ROADWAY BEAUTIFICATION MEASURE W WATER QUALITY FLOOD PROTECTION REDEVELOPMENT OBLIGATION RETIRE IMPROVEMENT DISTRICT 9 SPECIAL TRUSTS Subtotal GRAND TOTAL CITY OF RANCHO PALOS VERDES MONTHLY TREASURER'S REPORT MARCH 2023 BALANCE FORWARD DEBIT CREDIT 32,493,301.74 9,217,020.96 11,726,768.01 000 000 0.00 38 ,095,848.77 1,611 ,681.90 2,201,127.88 3,045,737.43 79,581.46 4,540.52 0.00 0.00 0.00 851 ,616.33 101 ,883.30 0.00 0.00 0.00 000 41,993,202.53 1,793,146.66 2,205,668.40 1,753 ,706.69 168,402.96 98,586.01 29,758.01 63 .33 000 45 ,486.66 114.90 0.00 0.00 37,293.00 25,241.19 0.00 0.00 0.00 2,211,768.62 9,310.10 66,397.96 382 ,348.49 41 ,482.22 76,730.64 104,905.42 13,024.19 58 ,910.76 583 ,958.56 74,225 08 69,825.30 1,839,438.12 91,930.44 0.00 148,532.45 271 .76 62,500.00 2,321,056.11 59,683.55 1,072.50 737 ,661.21 66,374.58 169,539.74 248,490.62 519.79 12 ,740.00 742,232.91 14,292.38 3,776.78 146,835.61 303.62 12 ,500.00 122,138.84 244.40 17,858.13 0.00 0.00 0.00 000 0.00 0.00 829 ,731.53 6 ,779.25 948.86 000 0.00 0.00 1,359 .75 1,501 ,063.89 15,970.00 6,034,260.70 12 ,817 .14 73,413.50 428 ,271.76 893 .30 43,699.86 377 ,811.04 80403 0.00 874 ,533.37 1,861 .13 000 97 ,645 .09 198.35 9,422 .22 0.00 000 0.00 0.00 0.00 0.00 0.00 000 0.00 0.00 0.00 0.00 1,095,911.51 2,338.96 55 ,826.05 0.00 0.00 0.00 17,759.60 37.79 0.00 0.00 0.00 0.00 1,020 ,243.10 67 ,543.00 26 ,451.06 22 ,195,845.77 2,171 ,873.14 901 ,410.56 96,682,350.04 13,182,040.76 14,833,846.97 Total Investment: Change In Ending Cash CASH Balance 29,983,554.69 (2,509,747.05) 0.00 000 37,506,402.79 (589 ,445.98) 3,120,778.37 75,040.94 0.00 0.00 953 ,499.63 101 ,883.30 0.00 000 41,580,680.79 (412,521.74) 1,823,523.64 69,816.95 29,821.34 63.33 45,601.56 114.90 12,051 .81 12,051.81 0.00 0.00 2,154,680.76 (57,087.86) 347,100.07 (35 ,248.42) 59 ,018.85 (45,886.57) 588 ,358.34 4 ,399.78 1,931,368.56 91 ,930.44 86 ,304.21 (62,22824) 2,379,667.16 58 ,611.05 634,496.05 (103,16516) 236 ,270.41 (12,220.21) 752,748.51 10,515.60 134,639.23 (12 ,196.38) 104,525.11 (17 ,613.73) 0.00 0.00 0.00 0.00 835 ,561.92 5,830.39 0.00 0 .00 1,486,453.64 1,485 ,093.89 5,973 ,664.34 (60 ,596.36) 385,465.20 (42 ,806 .56) 378,615.07 80403 876,394.50 1,861.13 88 ,421.22 (9 ,223.87) 000 000 0.00 0.00 0.00 0.00 0.00 0.00 1,042,424.42 (53,487.09) 0.00 0.00 17 ,797.39 37.79 0.00 0.00 1,061 ,335.04 41 ,091.94 23,466,308 .35 1,270,462 .58 95,030,543.83 (1,651,806.21) 95,030,543.83 Change In Ending Cash Balance in% -8% 0% -2% 2% 0% 12% 0% -1% 4% 0% 0% 0% 0% -3% -9% -44% 1% 5% -42% 3% -14% -5% 1% -8% -14% 0% 0% 1% 0% 100% -1 % -10% 0% 0% -9% 0% 0% 0% 0% -5% 0% 0% 0% 4% 6% -2% FUND 101 330 681 682 202 203 209 310 211 213 214 215 216 217 220 221 222 223 224 225 228 332 333 334 336 337 338 343 701 780 A-2 CITY OF RANCHO PALOS VERDES MONTHLY INVESTMENT REPORT MARCH 2023 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 54,921,634 54,921,634 2 83% Note (1) CO -Non-Negotiable Malaga Bank 2/18/2023 6 Mos 2/21/2024 $ 250,000 250,000 400% CO -Non-Negotiable Malaga Bank 2/18/2023 6 Mos 2/21/2024 4,089,379 4,089,379 4.00% 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% Alaska USA Fed Ce Un 011852AH3 3/22/2023 36 Mos 3/23/2026 $ 250,000 $ 250,000 5.15% 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 Te\co Fed Cr Union 052392BN6 9/21/2022 24 Mos 9/20/2024 $ 250,000 $ 250,000 3.70% AXOS Bank 05465DAK4 3/26/2020 48 Mos 3/26/2024 $ 250,000 $ 250,000 1.65% BMW Bank of Northern America 05580AB45 7/23/2021 36 Mos 7/23/2024 $ 250,000 $ 250,000 0.50% Bank of Baroda 06063HMT7 7/22/2020 60 Mos 7/22/2025 $ 250,000 $ 250,000 0.65% Bank Foiward 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% Bank Newport 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 065% 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 170% Beal Bank USA 07371CK32 3/9/2022 48 Mos 3/4/2026 $ 250,000 $ 250,000 1.90% Californai Credit Union 130162AK6 3/25/2023 7 Mos 10/25/2023 $ 250,000 $ 250,000 4.50% 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% 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 1218/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 7122/2022 36 Mos 7/22/2025 $ 250,000 $ 250,000 3.30% Dart Bk Mason 237412AS0 6/21/2022 42 Mos 12/22/2025 $ 250,000 $ 250,000 3.10% Discover Bank 254673870 412712022 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% Evansville Teachers FCU 299547BC2 2/6/2023 12 Mos 2/5/2024 249,000 249,000 3.30% Farmers Ins. Group FCU 30960QAM9 1/1/2023 13 Mos 1/18/2024 $ 250,000 250,000 5.00% 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 445% First Federal S&L 32022EAW6 12/29/2021 60 Mos 12/29/2026 $ 250,000 $ 250,000 1.05% First Nat'I Bank 32110YXG5 6/24/2022 60 Mos 6/24/2027 $ 250,000 $ 250.000 325% First Nat! Bank/DAMA 32117BEQ7 12/30/2021 60 Mos 12/30/2026 $ 250,000 $ 250,000 1.25% 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% 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% lntercredit Bank NA 458657MC4 1/31/2022 60 Mos 1/29/2027 250,000 250,000 135% 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% Live Oak Bankmig 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% A-3 CITY OF RANCHO PALOS VERDES MONTHLY TREASURER'S REPORT MARCH 2023 Issuer of Acquisition Maturity Market Book Investment In vestment CUSIP# Date Term Date Value Value Yield Marlin Business Bank 57116ATMO 1/15/2020 60 Mos 1/15/2025 250,000 $ 250,000 1.75% Mineola Community Bank 60273NAB9 11 /9/2022 60 Mos 11 /9/2027 $ 250 ,000 $ 250,000 5.10% Morgan Stanley Bk 61690UK82 6/2/2022 36 Mos 6/2/2025 $ 250 ,000 $ 250,000 3.05% Morgan Stanley PVT Bank 61760AZ51 9/19/2019 48 Mos 9/19/2023 $ 250,000 $ 250,000 1.85% Mountain Amer Fed CR UN 62384RALO 8/31 /2022 36 Mos 8/29/2025 $ 250 ,000 250,000 3.50% Nat'I Bank of Commerce 633368FJ9 1/19/2022 60 Mos 1/19/2027 $ 250 ,000 250,000 1.15% New York Community Bank 649447UP2 6/3/2021 36 Mos 6/3/2024 $ 250 ,000 250,000 0.35% Numerica Credit Union 67054NBAO 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/22/2024 $ 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°/c Onpath Fed Cr Union 68283MAG1 9/15/2022 60 Mos 9/15/2027 $ 250 ,000 250,000 3.80% Pacific Wes tern 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% Pittsburgh City Hall 72500MAA3 8/16/2022 60 Mos 8/16/2027 $ 250 ,000 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 75472RAN1 11/26/2019 60 Mos 11 /26/2024 250,000 250 ,000 1.85% Rogue Credit Union 77535MA L7 1/20/2023 48 Mos 1/20/2027 250,000 $ 250,000 5.05% Saco&Biddefords Savs 78577THR9 7/21/2022 60 Mos 7/21/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% 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% Southwest Finl Fed Cr Un 84485EAJ6 9/21 /2022 60 Mos 9/21 /2 027 $ 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% Sterling Bank POP BL MO 85916VDN2 9/1 8/2019 48 Mos 9/18/2023 $ 250 ,000 $ 250,000 1.65% Texas Exchange Bank 88241T JJO 10/23/2020 60 Mos 10/23/2025 $ 250 ,000 250,000 0.60% Texas Exchange Bank 88241T JN1 11 /25/2020 60 Mos 11/25/2025 $ 250 ,000 250,000 0.60% Texas 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 /1 6/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 Financial 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 30 Mos 9/10/2025 250,000 250,000 5.0 5°/c Trustone Finl Cr Un 89841MAF4 7/19/2022 60 Mos 7/19/2027 $ 250,000 250,000 3.40% UBS Bank USA 90348JN30 6/24/2021 36 Mos 6/24/2024 250,000 250,000 0.35% Uni versity Credit Un ion 914242AAO 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 $ 250,000 250,000 1.00% Valley Strong Cr Union 920133AJ4 12/14/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% W orkers Credit Union 98138MAT7 9/29/2022 60 Mos 9/29/2027 $ 250 ,000 250 ,000 4 .50% Treasury-Bank of New York(Vining Sparks) United States Treas 912828S35 9/12/2019 46 Mos 6 /30/2023 1,000 ,000 1,000,000 1.38% 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% 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.69% 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% Total Investments 92,059,013 Summary: Weighted Return 2.78% Local Agency Investment Fund (LAIF-CITY) 54 ,921 ,633.95 Certificate of Deposit -Malaga Bank 250 ,000 .00 Certificate of Deposit -Malaga Bank 4 ,089 ,378.75 Certificate of Deposit -Stifel 24,246 ,000.00 Treasury Bills -Stifel 8 ,552 ,000.00 Total Investments 92,059,012.70 BO W balance 2 ,923,972 .61 Petty Cash 5,000.00 Stifel money market 42 ,558 .52 Total cash & investment 95,030 ,543.83 Total cash & investment from above 95 ,030,543 .83 A-4 NOTE: Malaga Bank· CD 5% CITY OF RANCHO PALOS VERDES MONTHLY TREASURER'S REPORT MARCH 2023 SUMMARY OF CASH BALANCE BY INSTITUTION MARCH 2023 Stifel • Treasury 9% Bank of the West 3% Stifel · Money Market 0% State of California • LAIF 58% (1) LAIF market values will be reported to vary from book value if th e 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 amounts within this report; or omissions of material amounts to cause the report to be misleading. :'t I certify th at this report accurately reflects all City investments and complies with the investme nt 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 , Dated A-5