The URL can be used to link to this page

Home My WebLink AboutAgenda Report - May 17, 2023 C-03CITY OF •� o z CALIFORNIA AGENDA ITEM C'm 3 COUNCIL COMMUNICATION AGENDA TITLE: Accept the Quarterly Investment Report as Required by the City of Lodi Investment Policy MEETING DATE: May 17, 2023 PREPARED BY: Deputy City Manager RECOMMENDED ACTION: Accept the quarterly investment report as required by the City of Lodi Investment Policy. BACKGROUND INFORMATION: Government Code Section 53646 prescribes suggested investment reporting requirements for California public agencies. The City Council adopted Resolution 2021-164 on June 2, 2021 approving FY 21/22 Investment Policy. The attached Treasurer's Report for the quarter ending March 31, 2023 is in compliance with the State's reporting recommendations and the City of Lodi's Investment Policy and Internal Control Guidelines. The investment report, investment policy and historical investment reports can be accessed on the City website by following this link: http://www.lodi.gov/196/Finance FISCAL IMPACT: Not applicable. FUNDING AVAILABLE: As per attached report. ovkvv��r ) z4p- Andrew Keys Deputy City Manager/Internal Services Director APPROVED: IMay9, M316:13P3T1 Stephen Schwabauer, City Manager TYPE OF INVESTMENT Cash and Equivalents Farmers & Merchants Bank Main Farmers & Merchants Bank Payroll Local Agency Investment Fund Farmer's & Merchants Bank Money Market Wells Fargo Bank Money Market * Total Demand Deposit Accounts CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED MARCH 31, 2023 Interest Rate Maturity Date Par Value Cost Due on Demand 4,576,806 Due on Demand 51,874 Due on Demand 74,999,165 Due on Demand 6,962,151 Due on Demand 3,718,823 Market Value % of Portfolio 4,576,806 2.02% 51,874 0.02% 74,999,165 33.04% 6,962,151 3.07% 3,718,823 1.64% 90,308,819 90,308,819 39.79% Bond Mutual Fund Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio CAL TRUST Medium Term Fund Due on Demand 10,254,814 10,254,814 4.52% Total Bond Mutual Funds 10,254,814 10,254,814 4.52% Local Bank Certificates of Deposit Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Farmers & Merchants Bank 0.20% 11/7/2023 2,000,000 2,000,000 2,000,000 0.88% Total Local Bank Certificates of Deposit 2,000,000 2,000,000 2,000,000 0.88% Negotiable Certificates of Deposit Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio MEDALLION BANK UTAH 2.90% 4/10/2023 250,000 250,000 249,861 0.11% STIFEL BANK AND TRUST 2.95% 5/15/2023 250,000 250,000 249,385 0.11% CITIBANK NA 3.25% 6/6/2023 250,000 250,000 249,182 0.11% INDUSTRIAL & COM BK CHNA 3.30% 6/30/2023 250,000 250,000 248,928 0.11% COMENITY CAPITAL BANK 3.30% 7/16/2023 250,000 250,000 248,739 0.11% UBS BANK 3.35% 10/5/2023 250,000 250,000 247,864 0.11% BARCLAYS BANK/DELAWARE 3.35% 10/10/2023 250,000 250,000 247,818 0.11% BANK OF BARODA 3.55% 11/30/2023 250,000 250,000 247,456 0.11% MCHENRY SAVINGS BK IL 2.80% 3/14/2024 250,000 250,000 244,611 0.11% MORGAN STANLEY BANK 1.95% 11/29/2024 250,000 250,000 237,950 0.10% MORGAN STANLEY PRIVATE BANK 1.90% 11/29/2024 250,000 250,000 237,753 0.10% BMW BANK NORTH AMERICA 0.90% 12/10/2024 250,000 250,000 233,520 0.10% CHARLES SCHWAB BANK SSB ** 5.05% 3/28/2025 250,000 250,000 250,464 0.11% TOYOTA FINANCIAL SGS BK 0.95% 7/29/2026 250,000 250,000 219,926 0.10% ALLY BANK 3.30% 8/18/2026 250,000 250,000 237,623 0.10% FIRST NATL BK OF AMERICA 1.25% 12/30/2026 250,000 250,000 218,703 0.10% TEXAS EXCHANGE BANK SSB 1.25% 12/30/2026 250,000 250,000 219,130 0.10% BANK HAPOALIM BM NY 1.50% 1/7/2027 250,000 250,000 220,937 0.10% BEAL BANK - PLANO TX 2.00% 3/3/2027 250,000 250,000 224,197 0.10% AMERICAN EXPRESS NATIONAL BANK 3.40% 6/29/2027 250,000 250,000 235,760 0.10% DISCOVER BANK 3.35% 7/20/2027 250,000 250,000 235,143 0.10% BELMONT BANK & TRUST CO ** 3.75% 2/15/2028 250,000 250,000 238,034 0.10% VISION BANK ** 3.75% 2/17/2028 250,000 250,000 238,026 0.10% CITY NATL BK - BEV HILLS ** 5.00% 3/31/2028 250,000 250,000 250,000 0.11% Total Negotiable Certificates of Deposit 6,000,000 6,000,000 5,731,005 2.53% Agency Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio FEDERAL FARM CREDIT BANK SYSTEM 2.70% 4/11/2023 250,000 249,500 249,869 0.11% FEDERAL HOME LOAN BANK 2.85% 5/8/2023 250,000 250,175 249,515 0.11% FEDERAL AGRICULTURE MORTGAGE CORPORATION 2.90% 7/24/2023 250,000 249,150 248,648 0.11% FAMCA 4.90% 11/10/2023 1,000,000 1,000,000 999,868 0.44% FEDERAL FARM CREDIT BANK SYSTEM ** 0.55% 11/24/2023 500,000 481,800 486,934 0.21% FEDERAL NATIONAL MORTGAGE ASSOCIATION ** 0.25% 11/27/2023 500,000 481,500 485,531 0.21% FEDERAL HOME LOAN BANK ** 4.75% 1/3/2024 500,000 499,500 500,692 0.22% FEDERAL FARM CREDIT BANK SYSTEM 0.90% 1/18/2024 500,000 499,250 484,724 0.21% FEDERAL HOME LOAN BANK ** 5.00% 2/14/2024 1,000,000 999,100 1,001,503 0.44% FEDERAL HOME LOAN BANK ** 2.38% 3/8/2024 400,000 389,400 391,879 0.17% FAMCA 2.65% 5/2/2024 350,000 349,825 342,407 0.15% FEDERAL HOME LOAN BANK ** 4.80% 7/10/2024 1,000,000 1,000,000 1,001,837 0.44% FEDERAL HOME LOAN BANK ** 2.88% 9/13/2024 400,000 389,080 392,153 0.17% FEDERAL NATIONAL MORTGAGE ASSOCIATION 1.63% 10/15/2024 500,000 508,800 480,257 0.21% FEDERAL HOME LOAN MORTGAGE CO 4.65% 11/15/2024 500,000 499,650 497,978 0.22% FAMCA 5.08% 12/5/2024 750,000 750,000 748,624 0.33% FEDERAL HOME LOAN BANK 2.75% 12/13/2024 500,000 537,050 486,677 0.21% FEDERAL HOME LOAN MORTGAGE CO ** 5.38% 12/13/2024 1,500,000 1,500,000 1,505,213 0.66% FEDERAL HOME LOAN MORTGAGE CO 3.00% 12/23/2024 400,000 399,800 389,217 0.17% FEDERAL FARM CREDIT BANK SYSTEM ** 1.13% 1/6/2025 500,000 469,250 471,631 0.21% FEDERAL NATIONAL MORTGAGE ASSOCIATION ** 1.63% 1/7/2025 500,000 479,000 477,748 0.21% FEDERAL HOME LOAN MORTGAGE CO ** 5.00% 1/27/2025 275,000 273,900 273,820 0.12% FEDERAL HOME LOAN BANK 1.25% 1/28/2025 500,000 500,000 470,043 0.21% Agency Securities Cont'd CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED MARCH 31, 2023 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio FEDERAL FARM CREDIT BANK SYSTEM ** 4.25% 2/10/2025 1,000,000 995,000 998,759 0.44% FEDERAL HOME LOAN MORTGAGE CO 3.15% 3/27/2025 400,000 400,000 389,125 0.17% FEDERAL HOME LOAN MORTGAGE CO 0.57% 9/24/2025 500,000 487,850 456,915 0.20% FREDDIE MAC 0.60% 10/27/2025 500,000 497,750 456,151 0.20% FAMCA 0.49% 12/18/2025 300,000 279,360 273,505 0.12% FEDERAL HOME LOAN BANK 0.90% 12/26/2025 500,000 499,900 458,633 0.20% FEDERAL FARM CREDIT BANK SYSTEM 4.92% 1/12/2026 500,000 500,000 497,187 0.22% FEDERAL HOME LOAN BANK 0.55% 1/20/2026 500,000 464,700 453,023 0.20% FEDERAL HOME LOAN MORTGAGE CO ** 5.05% 1/27/2026 1,000,000 1,000,000 994,348 0.44% FEDERAL HOME LOAN BANK 0.85% 3/30/2026 400,000 399,840 363,375 0.16% FEDERAL HOME LOAN BANK 1.20% 4/28/2026 500,000 500,000 455,571 0.20% FEDERAL HOME LOAN BANK 1.00% 5/26/2026 500,000 500,000 454,706 0.20% FEDERAL HOME LOAN BANK 1.88% 9/11/2026 400,000 417,280 372,189 0.16% FEDERAL FARM CREDIT BANK SYSTEM 4.87% 9/28/2026 500,000 500,000 495,347 0.22% FAMCA 1.05% 10/5/2026 500,000 500,000 454,388 0.20% FEDERAL HOME LOAN MORTGAGE CO 0.80% 10/27/2026 500,000 489,350 446,033 0.20% FEDERAL HOME LOAN BANK 5.00% 1/19/2027 500,000 500,000 495,891 0.22% TVA ** 2.88% 2/1/2027 500,000 481,050 479,604 0.21% FEDERAL HOME LOAN BANK 2.03% 2/25/2027 500,000 500,000 461,029 0.20% FEDERAL HOME LOAN BANK 3.50% 4/26/2027 500,000 500,000 483,240 0.21% FEDERAL HOME LOAN BANK 2.20% 4/27/2027 500,000 500,000 491,625 0.22% FEDERAL FARM CREDIT BANK SYSTEM 3.45% 6/1/2027 500,000 500,000 479,184 0.21% FIRST CAPITAL BK SC 3.50% 6/30/2027 250,000 250,000 236,622 0.10% FEDERAL HOME LOAN BANK 4.38% 8/25/2027 500,000 500,400 490,848 0.22% FEDERAL FARM CREDIT BANK SYSTEM ** 5.14% 1/18/2028 1,000,000 1,000,000 992,847 0.44% FEDERAL HOME LOAN BANK ** 4.50% 3/10/2028 500,000 516,350 515,820 0.23% Total Agency Securities 26,575,000 26,434,560 25,782,736 11.36% US Treasury Notes Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio UNITED STATES TREASURY 1.63% 4/30/2023 250,000 238,225 249,426 0.11% UNITED STATES TREASURY 1.63% 5/31/2023 250,000 236,525 248,740 0.11% UNITED STATES TREASURY 2.63% 6/30/2023 250,000 247,375 248,809 0.11% UNITED STATES TREASURY 1.25% 7/31/2023 250,000 231,625 247,090 0.11% UNITED STATES TREASURY 0.25% 6/15/2024 250,000 245,450 237,676 0.10% UNITED STATES TREASURY 0.38% 9/15/2024 250,000 245,350 236,113 0.10% UNITED STATES TREASURY 1.00% 12/15/2024 250,000 248,925 236,807 0.10% UNITED STATES TREASURY 0.50% 3/31/2025 250,000 244,475 233,066 0.10% UNITED STATES TREASURY 0.25% 6/30/2025 250,000 241,475 230,264 0.10% UNITED STATES TREASURY 0.25% 9/30/2025 250,000 240,475 228,623 0.10% UNITED STATES TREASURY 0.38% 11/30/2025 350,000 345,065 319,020 0.14% UNITED STATES TREASURY 0.38% 12/31/2025 250,000 240,575 227,695 0.10% UNITED STATES TREASURY 0.38% 1/31/2026 350,000 344,435 317,488 0.14% UNITED STATES TREASURY 0.75% 3/31/2026 750,000 741,675 686,426 0.30% UNITED STATES TREASURY 0.75% 5/31/2026 500,000 499,500 454,453 0.20% UNITED STATES TREASURY 0.88% 6/30/2026 250,000 244,025 227,764 0.10% UNITED STATES TREASURY 0.88% 9/30/2026 250,000 243,425 226,230 0.10% UNITED STATES TREASURY 1.25% 12/31/2026 250,000 247,500 228,164 0.10% Total US Treasury Notes 5,450,000 5,326,100 5,083,854 2.24% Corporate Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio WALMART INC 2.55% 4/11/2023 250,000 244,525 250,160 0.11% APPLE INC 2.40% 5/3/2023 250,000 240,875 249,625 0.11% SOUTHERN CALIFORNIA EDISON 3.40% 6/1/2023 254,000 252,857 252,559 0.11% NEW YORK UNIVERSITY 2.72% 7/1/2023 230,000 234,899 228,533 0.10% ORACLE CORP 3.63% 7/15/2023 250,000 253,425 248,830 0.11% IBM CORP 3.38% 8/1/2023 500,000 492,500 496,818 0.22% GILEAD SCIENCES INC 2.50% 9/1/2023 260,000 249,886 257,046 0.11% PROV ST JOSEPH HEALTH OBL 4.38% 10/1/2023 315,000 340,704 312,634 0.14% PRIES & FELLOWS OF HARVAR 2.60% 10/1/2023 300,000 306,750 296,149 0.13% TOYOTA MOTOR CREDIT CORP 2.25% 10/18/2023 250,000 235,225 246,498 0.11% NATIONAL RURAL UTIL COOP 3.40% 11/15/2023 300,000 297,900 292,602 0.13% ALABAMA POWER CO 3.55% 12/1/2023 250,000 249,875 247,201 0.11% CITIGROUP GLOBAL MARKETS 4.00% 12/1/2023 500,000 500,000 495,112 0.22% NATIONAL SECS CLEARING 4.00% 12/7/2023 500,000 498,850 482,617 0.21% TOYOTA MOTOR CREDIT CORP 3.35% 1/8/2024 400,000 399,280 394,917 0.17% JOHN DEERE CAPITAL CORP 3.45% 1/10/2024 250,000 250,450 246,916 0.11% Corporate Securities Cont'd 3M COMPANY 3.25% 2/14/2024 300,000 314,610 296,324 0.13% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED MARCH 31, 2023 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio BOEING CO 2.80% 3/1/2024 250,000 248,500 243,748 0.11% DETROIT EDISON CO 3.65% 3/15/2024 300,000 318,180 295,576 0.13% NORTHWESTERN MUTUALGLBL** 0.60% 3/25/2024 750,000 714,975 717,297 0.32% BANK OF AMERICA CORP 4.00% 4/1/2024 250,000 261,725 247,170 0.11% HORMEL FOODS CORP 0.65% 6/3/2024 500,000 495,100 474,894 0.21% CATERILLAR FINANCIAL SERVICE 3.30% 6/9/2024 500,000 527,550 491,466 0.22% AMERICAN HONDA FINANCE 0.55% 7/12/2024 400,000 399,080 378,970 0.17% WALT DISNEY COMPANY 1.75% 8/30/2024 500,000 499,300 481,101 0.21% WELLS FARGO & COMPANY 3.30% 9/9/2024 750,000 788,725 730,780 0.32% AMERICAN HONDA FINANCE 2.15% 9/10/2024 500,000 499,550 481,394 0.21% SHELL INTERNATIONAL FIN 2.00% 11/7/2024 500,000 497,650 480,289 0.21% CATERILLAR FINANCIAL SERVICE 3.25% 12/1/2024 500,000 528,700 488,240 0.22% CON EDISON CO OF NY INC 3.30% 12/1/2024 310,000 330,646 301,243 0.13% JOHNSON & JOHNSON 2.63% 1/15/2025 1,000,000 967,600 974,677 0.43% APPLE INC 2.50% 2/9/2025 500,000 478,000 484,551 0.21% TOYOTA MOTOR CREDIT CORP 1.80% 2/13/2025 300,000 299,940 285,214 0.13% WESTPAC BANKING CORP 2.35% 2/19/2025 500,000 514,250 479,289 0.21% FLORIDA POWER & LIGHT CO 2.85% 4/1/2025 500,000 499,400 484,455 0.21% BMW US CAPITAL LLC 3.90% 4/9/2025 400,000 399,880 392,422 0.17% YALE UNIVERSITY 0.87% 4/15/2025 1,075,000 1,068,318 1,002,183 0.44% AMAZON.COM INC 0.80% 6/3/2025 500,000 497,950 464,961 0.20% PEPSICO INC ** 3.50% 7/17/2025 500,000 488,000 492,581 0.22% SUTTER HEALTH 1.32% 8/15/2025 750,000 743,175 690,474 0.30% APPLE INC 0.55% 8/20/2025 500,000 492,150 460,396 0.20% JOHNSON & JOHNSON 0.55% 9/1/2025 950,000 944,185 872,783 0.38% WALMART INC ** 3.90% 9/9/2025 500,000 498,550 498,225 0.22% NATIONAL RURAL UTIL COOP 1.00% 9/15/2025 500,000 499,250 452,990 0.20% TOYOTA MOTOR CREDIT CORP 0.80% 10/16/2025 500,000 493,650 455,604 0.20% TOYOTA MOTOR CREDIT CORP 0.80% 1/9/2026 500,000 498,800 452,529 0.20% APPLE INC 0.70% 2/8/2026 500,000 492,000 454,570 0.20% PUBLIC STORAGE 0.88% 2/15/2026 300,000 297,720 269,434 0.12% MERCK & CO INC 0.75% 2/24/2026 400,000 398,640 365,973 0.16% JOHNSON & JOHNSON ** 2.45% 3/1/2026 500,000 478,500 480,132 0.21% BMW US CAPITAL LLC 2.80% 4/11/2026 500,000 495,900 475,369 0.21% BMO HARRIS BANK NA 1.00% 4/13/2026 250,000 250,000 222,653 0.10% AMAZON.COM INC 1.00% 5/12/2026 500,000 498,800 452,943 0.20% CHARLES SCHWAB CORP 1.15% 5/13/2026 500,000 499,500 438,579 0.19% BANK OF AMERICA CORP 1.25% 5/28/2026 500,000 500,000 430,821 0.19% BANK OF AMERICA CORP 1.20% 6/25/2026 500,000 499,300 437,511 0.19% MASS INSTITUTE OF TECH 3.31% 7/1/2026 500,000 532,750 485,294 0.21% SOCIETE GENERALE 1.35% 7/30/2026 500,000 500,000 500,000 0.22% BANK OF AMERICA CORP 1.15% 9/10/2026 250,000 248,200 208,170 0.09% TEXAS INSTRUMENTS INC 1.13% 9/15/2026 400,000 392,400 360,979 0.16% JPMORGAN CHASE & CO 2.95% 10/1/2026 500,000 534,550 471,685 0.21% ENTERGY LOUISIANA LLC 2.40% 10/1/2026 400,000 375,640 369,502 0.16% TSMC ARIZONA CORP 1.75% 10/25/2026 500,000 437,800 452,050 0.20% DUKE ENERGY CAROLINAS ** 2.95% 12/1/2026 500,000 473,550 471,670 0.21% PROCTER & GAMBLE CO/THE 1.90% 2/1/2027 350,000 347,270 325,036 0.14% IBM CORP 2.20% 2/9/2027 500,000 475,200 461,308 0.20% PROGRESSIVE CORP 2.50% 3/15/2027 500,000 488,800 460,595 0.20% NIKE INC 2.75% 3/27/2027 1,000,000 959,100 947,643 0.42% VISA INC 1.90% 4/15/2027 500,000 442,600 459,553 0.20% MIDAMERICAN ENERGY CO 3.10% 5/1/2027 500,000 461,050 472,303 0.21% UNILEVER CAPITAL CORP 2.90% 5/5/2027 300,000 288,450 284,351 0.13% CHEVRON CORP 2.00% 5/11/2027 500,000 469,150 457,592 0.20% INTEL CORP 3.15% 5/11/2027 500,000 463,800 478,406 0.21% NSTAR ELECTRIC CO 3.20% 5/15/2027 400,000 388,640 378,953 0.17% AMAZON.COM INC 1.20% 6/3/2027 500,000 450,650 443,471 0.20% META PLATFORMS INC 3.50% 8/15/2027 500,000 461,700 482,337 0.21% WALMART INC ** 3.95% 9/9/2027 500,000 494,800 498,979 0.22% AMAZON.COM INC ** 4.55% 12/1/2027 500,000 507,900 507,185 0.22% APPLE INC ** 1.20% 2/8/2028 750,000 642,750 660,519 0.29% COMCAST CORP ** 3.15% 2/15/2028 500,000 472,200 474,090 0.21% Total Corporate Securities 37,144,000 36,574,700 35,189,697 15.50% Municipal Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio FRESNO FING-B REF 3.18% 4/1/2023 285,000 282,236 285,000 0.13% OHIO ST THIRD FRONTIER RESEARCH 2.11% 5/1/2023 250,000 240,275 249,498 0.11% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED MARCH 31, 2023 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio RIVERSIDE CA PENSION OBLIGATION 2.63% 6/1/2023 250,000 243,900 249,024 0.11% SAN DIEGO TOBACCO SETTLEMENT 3.44% 6/1/2023 500,000 500,750 498,554 0.22% SOLANO COMMUNITY COLLEGE DT 2.06% 8/1/2023 145,000 145,000 143,657 0.06% CALIFORNIA VARIOUS PURPOSE 3.50% 8/1/2023 305,000 310,490 303,428 0.13% VISTA REDEV AGENCY-TXBL 3.00% 9/1/2023 290,000 300,643 287,127 0.13% CENTRAL CONTRA COSTA SANITATION DISTRICT 3.12% 9/1/2023 415,000 417,283 412,408 0.18% CALIFORNIA STATE MUNI TAX 2.25% 10/1/2023 250,000 239,750 246,637 0.11% TX PUB FIN AUTH-A-REF 5.08% 10/1/2023 300,000 300,000 293,707 0.13% OAKLAND PENSION-TXBL 4.35% 12/15/2023 400,000 440,880 398,173 0.18% RIVERSIDE CA UNIFIED SCHOOL DIST 1.98% 2/1/2024 400,000 400,000 390,697 0.17% NATIONAL RURAL UTIL COOP 3.50% 2/8/2024 300,000 297,090 287,441 0.13% CALIFORNIA ST-TXBL-B 3.00% 4/1/2024 610,000 616,087 599,385 0.26% CORTE MADERA-TXBL-REF 2.75% 5/1/2024 150,000 150,300 146,807 0.06% TULARE COUNTY BRD ED-TXBL 2.31% 5/1/2024 235,000 236,528 228,574 0.10% UNIV OF CALIFORNIA -BF 0.83% 5/15/2024 120,000 120,216 115,042 0.05% UNIV OF CA-AP-TXBL ** 3.06% 5/15/2024 1,000,000 981,600 983,059 0.43% CHAFFEY COMMUNITY COLLEGE DT 1.72% 6/1/2024 480,000 477,168 464,433 0.20% ORANGE -TXBL -REF 5.87% 6/1/2024 400,000 394,320 380,187 0.17% RIVERSIDE CO PUB FIN 1.92% 7/1/2024 300,000 300,000 288,889 0.13% LOMPOC VALLEY MED-TXBL 2.07% 7/1/2024 110,000 110,869 106,038 0.05% ANAHEIM PUBLIC FIN 0.63% 7/1/2024 250,000 245,500 237,960 0.10% SAN FRANCISCO CITY 3.76% 8/1/2024 250,000 270,675 246,156 0.11% TAMALPAIS UN HSD-TXBL 2.02% 8/1/2024 150,000 151,770 145,083 0.06% TENNESSEE-C-REF-TXBL 1.97% 8/1/2024 170,000 171,751 164,299 0.07% CONTRA COSTA CA COMNTY 1.77% 8/1/2024 250,000 250,000 240,891 0.11% MINNESOTA ST-C-TXBL 3.00% 8/1/2024 215,000 227,857 211,247 0.09% SOLANO COMMUNITY COLLEGE DT 2.16% 8/1/2024 300,000 300,000 290,975 0.13% SAN FRANCISCO REDEV-C 3.13% 8/1/2024 500,000 524,000 488,555 0.22% MT SAN ANTONIO CCD 1.94% 8/1/2024 400,000 404,080 386,874 0.17% MD ST -B 0.46% 8/1/2024 300,000 300,000 283,944 0.13% SANTA CLARA CO-B-TXBL 2.00% 8/1/2024 475,000 467,543 458,693 0.20% LOS ANGELES CCD -REF 0.67% 8/1/2024 500,000 469,000 474,927 0.21% CENTRAL BASIN -B -REF ** 1.94% 8/1/2024 600,000 577,860 577,595 0.25% ORANGE COUNTY CA WATER DIST 1.94% 8/15/2024 200,000 200,080 192,997 0.09% W SACRAMENTO AREA 2.07% 9/1/2024 150,000 150,000 144,121 0.06% ESCONDIDO JT POWERS 2.19% 9/1/2024 380,000 383,192 366,825 0.16% SAN FRANCISCO CMNTY-B ** 3.11% 9/1/2024 340,000 332,690 331,310 0.15% HAWAII ST -GB 0.80% 10/1/2024 125,000 124,938 118,182 0.05% CARMICHAEL WATER DIST 2.17% 11/1/2024 1,295,000 1,304,065 1,246,134 0.55% INDIO PUB FIN-B-TXBL 3.35% 11/1/2024 180,000 190,350 175,855 0.08% VENTURA COUNTY CA PUBLIC 1.22% 11/1/2024 100,000 100,000 94,830 0.04% SEMITROPIC IMP DIST-A 2.36% 12/1/2024 140,000 141,694 134,673 0.06% CARSON -TXBL-REV 1.88% 1/15/2025 505,000 516,817 478,329 0.21% SAN RAMON REDEV AGY 4.00% 2/1/2025 140,000 155,834 137,577 0.06% CALIFORNIA ST MUNI FI 1.67% 2/1/2025 300,000 281,760 282,742 0.12% CT ST -SER A ** 5.77% 3/15/2025 500,000 514,900 509,841 0.22% CALIFORNIA-TXBL 3.38% 4/1/2025 315,000 340,200 309,041 0.14% STANISLAUS CONSOL FIR 1.25% 4/1/2025 235,000 236,998 218,371 0.10% SAN DIEGO CNTY CA REG 2.09% 4/1/2025 350,000 366,485 333,568 0.15% BAY AREA CA TOLL AUTH 2.33% 4/1/2025 250,000 242,025 239,759 0.11% UNIV OF CA-AS-TXBL ** 2.49% 5/15/2025 545,000 523,255 525,374 0.23% MONTEREY PK TXBL 0.89% 6/1/2025 400,000 399,800 367,971 0.16% GOLDEN ST TOBACCO -B 1.40% 6/1/2025 300,000 300,000 278,122 0.12% LAKE PORT-REV-TXBL 1.18% 6/1/2025 155,000 155,233 143,467 0.06% MONTEBELLO -REV -TXBL 2.50% 6/1/2025 1,000,000 932,700 950,419 0.42% SANTA CRUZ CO CA-TXBL ** 0.79% 6/1/2025 315,000 289,107 290,314 0.13% ANAHEIM PUBLIC FIN 0.94% 7/1/2025 250,000 249,400 231,721 0.10% UNIV CA-AX-TXBL 3.06% 7/1/2025 1,150,000 1,242,765 1,121,148 0.49% SAN RAMON-TXBL 1.20% 7/1/2025 500,000 497,250 462,279 0.20% UT ST-BABS-B 3.54% 7/1/2025 750,000 540,585 544,411 0.24% FOOTHILL DE ANZA-B 0.91% 8/1/2025 500,000 504,600 461,519 0.20% SANTA ROSA ELEM SD 1.01% 8/1/2025 500,000 500,000 460,608 0.20% W CONTRA COSTA SD -B 0.94% 8/1/2025 505,000 505,000 467,165 0.21% CASTRO VLY UNIF SCH 1.20% 8/1/2025 500,000 503,100 463,166 0.20% Municipal Securities Cont'd OAK GROVE SD -REF 0.87% 8/1/2025 240,000 240,000 222,248 0.10% BELMONT-REDWOOD-A- 0.88% 8/1/2025 205,000 205,000 188,676 0.08% BELMONT-REDWOOD-B-REF 0.88% 8/1/2025 200,000 200,000 184,074 0.08% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED MARCH 31, 2023 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio SAN BERNARDINO CCD 0.84% 8/1/2025 275,000 275,000 254,708 0.11% BELLFLOWER -TXBL 1.32% 8/1/2025 500,000 500,000 461,402 0.20% KLAMATH & TRI NITY-B 1.83% 8/1/2025 250,000 250,000 233,698 0.10% COVINA-VLY SD-TXBL 1.28% 8/1/2025 410,000 381,915 382,435 0.17% RIO ESD CMNTY FACS DT 1.12% 9/1/2025 380,000 380,000 349,384 0.15% ANAHEIM CA HSG & PUB -13 1.86% 10/1/2025 525,000 481,478 493,457 0.22% PALM DESERT REDEV-B ** 3.25% 10/1/2025 500,000 483,850 483,660 0.21% MA CMWLTH -E-TXBL-REF 0.70% 11/1/2025 220,000 218,306 201,340 0.09% CALIFORNIA ST UNIV-B 0.86% 11/1/2025 100,000 100,000 91,812 0.04% STHRN KERN UNIF SD -B 1.08% 11/1/2025 370,000 370,000 337,601 0.15% VENTURA CNTY CA PUBLI 1.32% 11/1/2025 500,000 496,250 461,595 0.20% GA ST -SER H 4.50% 11/1/2025 535,000 534,305 534,382 0.24% TENNESSEE ST -B-REF 0.86% 11/1/2025 115,000 102,350 105,462 0.05% SACRAMENTO CNTY CA -B 1.04% 12/1/2025 485,000 471,275 447,051 0.20% NEW YORK ST ** 2.26% 2/15/2026 500,000 468,000 470,730 0.21% BAY AREA CA TOLL AUTH 2.43% 4/1/2026 230,000 245,834 217,765 0.10% CALIFORNIA ST-TXBL-B 2.65% 4/1/2026 500,000 526,650 477,748 0.21% WISCONSIN ST GEN FUND 3.05% 5/1/2026 300,000 329,010 288,728 0.13% UNIV OF CALIFORNIA -BI 0.87% 5/15/2026 405,000 353,484 366,161 0.16% NEW JERSEY ST-A-TXBL 2.25% 6/1/2026 660,000 630,432 619,893 0.27% BEVERLY HILLS PUB FIN ** 2.36% 6/1/2026 690,000 645,702 649,560 0.29% SAN FRANCISCO CA CITY 1.10% 6/15/2026 370,000 372,923 331,821 0.15% RED BLUFF-TXBL 1.46% 7/15/2026 350,000 356,965 312,395 0.14% BELMONT-REDWOOD-B-REF 1.10% 8/1/2026 205,000 205,000 184,270 0.08% SAN BERNARDINO CCD 1.10% 8/1/2026 230,000 230,000 208,323 0.09% BELLFLOWER -TXBL 1.60% 8/1/2026 465,000 463,512 420,469 0.19% KLAMATH & TRI NITY-B 2.08% 8/1/2026 130,000 130,000 119,613 0.05% SAN FRANCISCO CO-TXBL 1.76% 9/1/2026 295,000 298,540 267,563 0.12% RIVERSIDE UNIF SD FIN 1.65% 9/1/2026 750,000 741,825 678,872 0.30% CUCAMONGA VLY WTR-B 3.55% 9/1/2026 250,000 238,325 243,750 0.11% CALIFORNIA ST -TXBL 2.38% 10/1/2026 1,015,000 1,003,214 953,642 0.42% TEXAS ST-REF-TXBL 3.42% 10/1/2026 990,000 1,093,653 957,525 0.42% CA ST UNIV-D 1.14% 11/1/2026 375,000 369,563 335,916 0.15% OREGON ST -H -REF 1.19% 11/1/2026 115,000 112,309 103,227 0.05% CALIFORNIA ST UNIV-B 1.14% 11/1/2026 500,000 447,600 447,953 0.20% LOS ANGELES MUNI -C 3.32% 11/1/2026 140,000 133,882 133,752 0.06% RIVERSIDE CNTY CA INF 1.47% 11/1/2026 335,000 290,579 301,914 0.13% CA ST DEPT OF WTR RES 1.05% 12/1/2026 500,000 485,500 447,037 0.20% MANHATTAN BEACH -TXBL ** 1.57% 1/1/2027 375,000 334,463 336,005 0.15% NEW YORK ST 2.36% 2/15/2027 800,000 809,900 742,732 0.33% RIVERSIDE CO-TXBL-REV 2.96% 2/15/2027 205,000 206,046 192,409 0.08% SAN JOSE -C -REF -REV 1.73% 3/1/2027 195,000 189,345 174,762 0.08% BAY AREA CA TOLL AUTH 1.43% 4/1/2027 520,000 478,088 465,800 0.21% SAN DIEGO CO REGL-A 1.40% 4/1/2027 425,000 388,365 379,248 0.17% PORT OF OAKLAND CA 1.67% 5/1/2027 1,085,000 933,092 971,156 0.43% LOS ANGELES DEPT ARPT 1.10% 5/15/2027 240,000 207,720 208,310 0.09% UNIV OF CALIFORNIA -N 3.04% 5/15/2027 100,000 97,570 94,893 0.04% UNIV OF CA-AG-TXBL 3.28% 5/15/2027 500,000 492,550 481,688 0.21% UNIV OF CA-AS-TXBL 2.74% 5/15/2027 500,000 450,700 471,543 0.21% PALM SPRINGS FIN AUTH 1.61% 6/1/2027 845,000 717,912 752,822 0.33% STANFORD UNIVERSITY ** 1.29% 6/1/2027 900,000 793,540 803,028 0.35% SANTA ROSA REGL RES 3.07% 8/1/2027 200,000 197,000 188,717 0.08% DAVIS REDEV SUCCESSOR 2.20% 9/1/2027 375,000 327,413 338,452 0.15% CALIFORNIA ST UNIV-B 1.36% 11/1/2027 380,000 323,266 333,205 0.15% CALIFORNIA ST DEPT OF ** 1.16% 12/1/2027 865,000 749,350 752,267 0.33% SEMITROPIC IMP DIST-A ** 2.69% 12/1/2027 250,000 229,775 230,931 0.10% SAN FRANCISCO MUNI TR ** 1.30% 3/1/2028 500,000 425,100 425,065 0.19% Total Municipal Securities 50,100,000 48,803,662 46,961,449 20.69% TYPE OF INVESTMENT SugranationaI Securltles INTERAMER DEV INTERAMER DEV INTL FIN CORP INT BK RECON&D INT BK RECON&D INTERAMER DEV INTL FIN CORP INTERAMER DEV INTL BK RECON & DEVELOP INTL FIN CORP INTL FIN CORP INTERAMER DEV Total Supranational Securities INVESTMENTS SUBTOTAL NOT INCLUDING CASH & EQUIVALENTS TOTAL ALL INVESTMENTS INCLUDING CASH & EQUIVALENTS * End of month bank balances are reflected on this report. ** Investments purchased during this reporting period. CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED MARCH 31, 2023 Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Interest Rate Maturity Date Par Value Cost Market value_ % of Portfolio 2.63% 1/16/2024 300,000 309,510 295,108 0.13% 0.39% 4/16/2024 500,000 499,900 479,396 0.21% 0.60% 2/28/2025 500,000 496,250 466,102 0.21% 2.05% 3/17/2025 750,000 740,400 718,682 0.32% 0.65% 2/24/2026 500,000 493,900 453,539 0.20% 0.82% 2/27/2026 500,000 501,500 454,484 0.20% 2.13% 4/7/2026 396,000 418,730 375,764 0.17% 0.80% 6/17/2026 500,000 496,750 452,597 0.20% 0.88% 7/15/2026 500,000 500,900 454,285 0.20% 0.82% 9/15/2026 400,000 396,720 359,362 0.16% 0.75% 10/8/2026 250,000 246,000 224,740 0.10% 1.50% 1/13/2027 1.000,000 995,900 916,814 0.40% 6,096,000 6,096,460 5,650,872 2.49% 133,365,000 131,235,482 126,399,613 55.69% 231,799,115 226,963,246 100.00% CERTIFICATION I certify this report accurately reflects all city pooled investments and is in conformity with state law and the investment policy statement adopted by the City Council on lune 2, 2021. The investment program herein shown provides sufficient cash liquidity to meet the next six months estimated expenditures. A copy of this report is available in the City Clerk's Office or online at http://www.lodi.gov/finance/revenue.html. 00A,lemr X,�ohj Andrew Keys, Treasurer/Director of Finance Lisa Noffsinger, Budget Manager Andrew Keys Review Date 05/09/23 Review Date IRS Section 115 Retirement Benefit Trust Funds Market Value Public Agency Retirement Services - Pension Stabilization Fund Balanced Strategy Mutual Fund $ 20,902,055 Total Pension Stabilization Fund $ 20,902,055 CalPERS - California Employer's Retiree Benefit Trust (CERBT) CERBT Strategy 2 $ 2,137,033 Total CERBT $ 2,137,033 Total Section 115 Retirement Benefit Trust Funds $ 23,039,087 Restricted Cash Accounts Market Value PCE/TCE Central Plume Remediation Fund Farmers & Merchants Bank Money Market $ 411,078 Total PCE/TCE Central Plume Account $ 411,078 Total Restriction Cash Accounts $ 411,078