The URL can be used to link to this page

Home My WebLink AboutAgenda Report - April 5, 2023 C-04CITY OF "! 0 t IlP CALIFORNIA AGENDA ITEM C04 COUNCIL COMMUNICATION AGENDA TITLE: Accept the Quarterly Investment Report as Required by the City of Lodi Investment Policy MEETING DATE: April 5, 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 December 31, 2022 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: htp://www.lodi._qov/196/Finance . FISCAL IMPACT: Not applicable. FUNDING AVAILABLE As per attached report. Dv*1116r (�- Andrew Keys Deputy City Manager/Internal Services Director APPROVED: �,,e+(Mar 22.202312:04 PDT) Stephen Schwabauer, City Manager CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED DECEMBER 31, 2022 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Cash and Equivalents Farmers & Merchants Bank Main * Due on Demand 3,895,793 3,895,793 2.13% Farmers & Merchants Bank Payroll * Due on Demand 66,330 66,330 0.04% Local Agency Investment Fund Due on Demand 59,740,085 59,740,085 32.60% Farmer's & Merchants Bank Money Market * Due on Demand 3,049,366 3,049,366 1.66% Wells Fargo Bank Money Market * Due on Demand 2,922,523 2,922,523 1.59% Total Demand Deposit Accounts 69,674,096 69,674,096 38.02% Bond Mutual Fund Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio CAL TRUST Medium Term Fund Due on Demand 10,106,020 10,106,020 5.51% Total Bond Mutual Funds 10,106,020 10,106,020 5.51% 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 1.09% Total Local Bank Certificates of Deposit 2,000,000 2,000,000 2,000,000 1.09% Negotiable Certificates of Deposit Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio SYNCHRONY BANK 2.60% 1/19/2023 250,000 250,000 249,798 0.14% SALLIE MAE BANK/SALT LAKE CITY, UTAH 2.65% 1/24/2023 250,000 250,000 249,756 0.14% STATE BANK OF INDIA 2.70% 2/16/2023 250,000 250,000 249,544 0.14% MEDALLION BANK UTAH 2.90% 4/10/2023 250,000 250,000 249,148 0.14% STIFEL BANK AND TRUST 2.95% 5/15/2023 250,000 250,000 248,843 0.14% CITIBANK NA 3.25% 6/6/2023 250,000 250,000 248,936 0.14% INDUSTRIAL & COM BKCHNA 3.30% 6/30/2023 250,000 250,000 248,788 0.14% COMENITY CAPITAL BANK 3.30% 7/16/2023 250,000 250,000 248,615 0.14% UBS BANK 3.35% 10/5/2023 250,000 250,000 247,728 0.14% BARCLAYS BANK/DELAWARE 3.35% 10/10/2023 250,000 250,000 247,689 0.14% BANK OFBARODA 3.55% 11/30/2023 250,000 250,000 247,636 0.14% MCHENRY SAVINGS BK IL 2.80% 3/14/2024 250,000 250,000 244,637 0.13% MORGAN STANLEY BANK 1.95% 11/29/2024 250,000 250,000 237,960 0.13% MORGAN STANLEY PRIVATE BANK 1.90% 11/29/2024 250,000 250,000 237,733 0.13% BMW BANK NORTH AMERICA 0.90% 12/10/2024 250,000 250,000 232,925 0.13% ALLY BANK 3.30% 8/18/2026 250,000 250,000 239,386 0.13% FIRST NATL BK OF AMERICA 1.25% 12/30/2026 250,000 250,000 219,548 0.12% TEXAS EXCHANGE BANK SSB 1.25% 12/30/2026 250,000 250,000 220,004 0.12% BANK HAPOALIM BM NY 1.50% 1/7/2027 250,000 250,000 221,942 0.12% AMERICAN EXPRESS NATIONAL BANK 3.40% 6/29/2027 250,000 250,000 237,987 0.13% Total Negotiable Certificates of Deposit 5,000,000 5,000,000 4,828,603 2.63% Agency Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio FEDERAL NATIONAL MORTGAGE ASSOCIATION 2.38% 1/19/2023 250,000 246,300 249,788 0.14% FEDERAL FARM CREDIT BANK SYSTEM 2.65% 3/8/2023 250,000 249,325 249,405 0.14% FEDERAL FARM CREDIT BANK SYSTEM 2.70% 4/11/2023 250,000 249,500 248,906 0.14% FEDERAL HOME LOAN BANK 2.85% 5/8/2023 250,000 250,175 248,722 0.14% FEDERAL AGRICULTURE MORTGAGE CORPORATION 2.90% 7/24/2023 250,000 249,150 247,707 0.14% FAMCA ** 4.90% 11/10/2023 1,000,000 1,000,000 999,904 0.55% FEDERAL FARM CREDIT BANK SYSTEM 0.90% 1/18/2024 500,000 499,250 480,931 0.26% FAMCA 2.65% 5/2/2024 350,000 349,825 340,470 0.19% FEDERAL NATIONAL MORTGAGE ASSOCIATION 1.63% 10/15/2024 500,000 508,800 475,234 0.26% FEDERAL HOME LOAN MORTGAGE CO ** 4.65% 11/15/2024 500,000 499,650 499,960 0.27% FAMCA ** 5.08% 12/5/2024 750,000 750,000 749,675 0.41% FEDERAL HOME LOAN BANK 2.75% 12/13/2024 500,000 537,050 484,295 0.26% FEDERAL HOME LOAN MORTGAGE CO 3.00% 12/23/2024 400,000 399,800 390,016 0.21% FEDERAL HOME LOAN BANK 1.25% 1/28/2025 500,000 500,000 464,552 0.25% FEDERAL HOME LOAN MORTGAGE CO 3.15% 3/27/2025 400,000 400,000 389,761 0.21% FEDERAL HOME LOAN MORTGAGE CO 0.57% 9/24/2025 500,000 487,850 448,278 0.24% FREDDIE MAC 0.60% 10/27/2025 500,000 497,750 449,297 0.25% FAMCA 0.49% 12/18/2025 300,000 279,360 269,693 0.15% FEDERAL HOME LOAN BANK 0.90% 12/26/2025 500,000 499,900 450,197 0.25% FEDERAL FARM CREDIT BANK SYSTEM ** 4.92% 1/12/2026 500,000 500,000 498,519 0.27% FEDERAL HOME LOAN BANK 0.55% 1/20/2026 500,000 464,700 444,368 0.24% FEDERAL HOME LOAN BANK 0.85% 3/30/2026 400,000 399,840 356,737 0.19% FEDERAL HOME LOAN BANK 1.20% 4/28/2026 500,000 500,000 450,014 0.25% FEDERAL HOME LOAN BANK 1.00% 5/26/2026 500,000 500,000 445,828 0.24% FEDERAL HOME LOAN BANK 1.88% 9/11/2026 400,000 417,280 367,791 0.20% FEDERAL FARM CREDIT BANK SYSTEM 4.87% 9/28/2026 500,000 500,000 496,586 0.27% FAMCA 1.05% 10/5/2026 500,000 500,000 447,712 0.24% :y�rc.�ar.�ei SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED DECEMBER 31, 2022 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Agency Securities Cont'd FEDERAL HOME LOAN MORTGAGE CO 0.80% 10/27/2026 500,000 489,350 437,029 0.24% FEDERAL HOME LOAN BANK ** 5.00% 1/19/2027 500,000 500,000 497,260 0.27% FEDERAL HOME LOAN BANK 2.03% 2/25/2027 500,000 500,000 454,350 0.25% FEDERAL HOME LOAN BANK 3.50% 4/26/2027 500,000 500,000 475,826 0.26% FEDERAL HOME LOAN BANK 2.20% 4/27/2027 500,000 500,000 486,003 0.27% FEDERAL HOME LOAN BANK 4.38% 8/25/2027 500,000 500,400 491,865 0.27% FEDERAL FARM CREDIT BANK SYSTEM 3.45% 6/1/2027 500,000 500,000 480,839 0.26% FIRST CAPITAL BK SC 3.50% 6/30/2027 250,000 250,000 238,915 0.13% Total Agency Securities 16,000,000 15,975,255 15,206,435 8.30% US Treasury Notes Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio UNITED STATES TREASURY 2.13% 12/31/2022 250,000 244,700 250,000 0.14% UNITED STATES TREASURY 1.50% 2/28/2023 250,000 237,075 248,852 0.14% UNITED STATES TREASURY 1.50% 3/31/2023 250,000 236,800 248,243 0.14% UNITED STATES TREASURY 1.63% 4/30/2023 250,000 238,225 247,676 0.14% UNITED STATES TREASURY 1.63% 5/31/2023 250,000 236,525 247,061 0.13% UNITED STATES TREASURY 2.63% 6/30/2023 250,000 247,375 247,695 0.14% UNITED STATES TREASURY 1.25% 7/31/2023 250,000 231,625 245,078 0.13% UNITED STATES TREASURY 0.25% 6/15/2024 250,000 245,450 234,727 0.13% UNITED STATES TREASURY 0.38% 9/15/2024 250,000 245,350 233,135 0.13% UNITED STATES TREASURY 1.00% 12/15/2024 250,000 248,925 234,131 0.13% UNITED STATES TREASURY 0.50% 3/31/2025 250,000 244,475 229,785 0.13% UNITED STATES TREASURY 0.25% 6/30/2025 250,000 241,475 226,650 0.12% UNITED STATES TREASURY 0.25% 9/30/2025 250,000 240,475 224,697 0.12% UNITED STATES TREASURY 0.38% 11/30/2025 350,000 345,065 313,373 0.17% UNITED STATES TREASURY 0.38% 12/31/2025 250,000 240,575 223,652 0.12% UNITED STATES TREASURY 0.38% 1/31/2026 350,000 344,435 311,705 0.17% UNITED STATES TREASURY 0.75% 3/31/2026 750,000 741,675 672,627 0.37% UNITED STATES TREASURY 0.75% 5/31/2026 500,000 499,500 446,465 0.24% UNITED STATES TREASURY 0.88% 6/30/2026 250,000 244,025 223,818 0.12% UNITED STATES TREASURY 0.88% 9/30/2026 250,000 243,425 222,285 0.12% UNITED STATES TREASURY 1.25% 12/31/2026 250,000 247,500 223,926 0.12% Total US Treasury Notes 6,200,000 6,044,675 5,755,582 3.14% Corporate Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio BANK OF NEW YORK MELLON CORP 2.95% 1/29/2023 100,000 100,070 99,879 0.05% WELLS FARGO NATIONAL BANK WEST 1.90% 1/30/2023 250,000 250,000 249,547 0.14% WELLS FARGO & COMPANY 3.45% 2/13/2023 150,000 152,145 149,720 0.08% UNITED HEALTH GROUP INC 2.75% 2/15/2023 100,000 99,140 99,763 0.05% EXXON MOBIL CORPORATION 2.73% 3/1/2023 250,000 247,050 249,234 0.14% WALMART INC 2.55% 4/11/2023 250,000 244,525 248,438 0.14% APPLE INC 2.40% 5/3/2023 250,000 240,875 248,028 0.14% SOUTHERN CALIFORNIA EDISON 3.40% 6/1/2023 254,000 252,857 251,959 0.14% NEW YORK UNIVERSITY 2.72% 7/1/2023 230,000 234,899 226,712 0.12% ORACLE CORP 3.63% 7/15/2023 250,000 253,425 248,069 0.14% IBM CORP 3.38% 8/1/2023 500,000 492,500 495,134 0.27% GILEAD SCIENCES INC 2.50% 9/1/2023 260,000 249,886 255,688 0.14% PROV ST JOSEPH HEALTH OBL 4.38% 10/1/2023 315,000 340,704 313,379 0.17% PRES & FELLOWS OF HARVAR 2.60% 10/1/2023 300,000 306,750 294,495 0.16% TOYOTA MOTOR CREDIT CORP 2.25% 10/18/2023 250,000 235,225 244,785 0.13% NATIONAL RURAL UTIL COOP 3.40% 11/15/2023 300,000 297,900 295,904 0.16% ALABAMA POWER CO 3.55% 12/1/2023 250,000 249,875 246,699 0.13% CITIGROUP GLOBAL MARKETS 4.00% 12/1/2023 500,000 500,000 492,878 0.27% TOYOTA MOTOR CREDIT CORP 3.35% 1/8/2024 400,000 399,280 394,814 0.22% JOHN DEERE CAPITAL CORP 3.45% 1/10/2024 250,000 250,450 246,871 0.13% 3M COMPANY 3.25% 2/14/2024 300,000 314,610 294,502 0.16% BOEING CO 2.80% 3/1/2024 250,000 248,500 242,482 0.13% DETROIT EDISON CO 3.65% 3/15/2024 300,000 318,180 294,967 0.16% BANK OF AMERICA CORP 4.00% 4/1/2024 250,000 261,725 246,965 0.13% HORMEL FOODS CORP 0.65% 6/3/2024 500,000 495,100 471,026 0.26% CATERILLAR FINANCIAL SERVICE 3.30% 6/9/2024 500,000 527,550 488,831 0.27% AMERICAN HONDA FINANCE 0.55% 7/12/2024 400,000 399,080 373,622 0.20% WALT DISNEY COMPANY 1.75% 8/30/2024 500,000 499,300 476,905 0.26% WELLS FARGO & COMPANY 3.30% 9/9/2024 750,000 788,725 727,742 0.40% AMERICAN HONDA FINANCE 2.15% 9/10/2024 500,000 499,550 477,433 0.26% SHELL INTERNATIONAL FIN 2.00% 11/7/2024 500,000 497,650 475,574 0.26% :y�rc.�ar.�ei SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED DECEMBER 31, 2022 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Corporate Securities Cont'd CATERILLAR FINANCIAL SERVICE 3.25% 12/1/2024 500,000 528,700 483,810 0.26% JOHNSON & JOHNSON ** 2.63% 1/15/2025 1,000,000 967,600 964,596 0.53% APPLE INC 2.50% 2/9/2025 500,000 478,000 478,380 0.26% TOYOTA MOTOR CREDIT CORP 1.80% 2/13/2025 300,000 299,940 282,098 0.15% WESTPAC BANKING CORP 2.35% 2/19/2025 500,000 514,250 474,758 0.26% FLORIDA POWER & LIGHT CO 2.85% 4/1/2025 500,000 499,400 479,034 0.26% BAY AREA CA TOLL AUTH 2.33% 4/1/2025 250,000 242,025 238,433 0.13% BMW US CAPITAL LLC 3.90% 4/9/2025 400,000 399,880 391,663 0.21% AMAZON.COM INC 0.80% 6/3/2025 500,000 497,950 456,918 0.25% APPLE INC 0.55% 8/20/2025 500,000 492,150 450,989 0.25% JOHNSON&JOHNSON 0.55% 9/1/2025 950,000 944,185 857,465 0.47% NATIONAL RURAL UTIL COOP 1.00% 9/15/2025 500,000 499,250 440,090 0.24% TOYOTA MOTOR CREDIT CORP 0.80% 10/16/2025 500,000 493,650 447,998 0.24% TOYOTA MOTOR CREDIT CORP 0.80% 1/9/2026 500,000 498,800 445,966 0.24% APPLE INC 0.70% 2/8/2026 500,000 492,000 444,256 0.24% PUBLIC STORAGE 0.88% 2/15/2026 300,000 297,720 265,935 0.15% MERCK & CO INC 0.75% 2/24/2026 400,000 398,640 354,567 0.19% BMW US CAPITAL LLC 2.80% 4/11/2026 500,000 495,900 467,639 0.26% BMO HARRIS BANK NA 1.00% 4/13/2026 250,000 250,000 222,837 0.12% AMAZON.COM INC 1.00% 5/12/2026 500,000 498,800 443,386 0.24% CHARLES SCHWAB CORP 1.15% 5/13/2026 500,000 499,500 444,814 0.24% BANK OF AMERICA CORP 1.25% 5/28/2026 500,000 500,000 430,815 0.24% BANK OF AMERICA CORP 1.20% 6/25/2026 500,000 499,300 411,895 0.22% MASS INSTITUTE OF TECH 3.31% 7/1/2026 500,000 532,750 477,807 0.26% TOYOTA FINANCIAL SGS BK 0.95% 7/29/2026 250,000 250,000 220,304 0.12% BANK OF AMERICA CORP 1.15% 9/10/2026 250,000 248,200 203,489 0.11% TEXAS INSTRUMENTS INC 1.13% 9/15/2026 400,000 392,400 353,573 0.19% 1PMORGAN CHASE & CO 2.95% 10/1/2026 500,000 534,550 467,002 0.25% TSMC ARIZONA CORP ** 1.75% 10/25/2026 500,000 437,800 446,661 0.24% PROCTER & GAMBLE CO/THE 1.90% 2/1/2027 350,000 347,270 318,641 0.17% IBM CORP 2.20% 2/9/2027 500,000 475,200 449,923 0.25% PROGRESSIVE CORP 2.50% 3/15/2027 500,000 488,800 459,184 0.25% BEAL BANK - PLANO TX 2.00% 3/3/2027 250,000 250,000 225,638 0.12% NIKE INC 2.75% 3/27/2027 1,000,000 959,100 935,349 0.51% VISA INC ** 1.90% 4/15/2027 500,000 442,600 451,027 0.25% MIDAMERICAN ENERGY CO ** 3.10% 5/1/2027 500,000 461,050 468,024 0.26% UNILEVER CAPITAL CORP 2.90% 5/5/2027 300,000 288,450 279,965 0.15% CHEVRON CORP 2.00% 5/11/2027 500,000 469,150 449,732 0.25% INTEL CORP** 3.15% 5/11/2027 500,000 463,800 471,756 0.26% NSTAR ELECTRIC CO 3.20% 5/15/2027 400,000 388,640 375,706 0.20% AMAZON.COM INC 1.20% 6/3/2027 500,000 450,650 433,671 0.24% META PLATFORMS INC ** 3.50% 8/15/2027 500,000 461,700 466,772 0.25% Total Corporate Securities 30,209,000 29,877,276 28,254,608 15.42% Municipal Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio CARSON CA REDEVELOPMENT 3.00% 2/1/2023 80,000 81,000 79,882 0.04% GEORGIA ST GENERAL OBLIGATION 2.23% 2/1/2023 310,000 299,553 309,485 0.17% FRESNO FING-B REF 3.18% 4/1/2023 285,000 282,236 283,990 0.15% OHIO ST THIRD FRONTIER RESEARCH 2.11% 5/1/2023 250,000 240,275 248,303 0.14% RIVERSIDE CA PENSION OBLIGATION 2.63% 6/1/2023 250,000 243,900 247,826 0.14% SAN DIEGO TOBACCO SETTLEMENT 3.44% 6/1/2023 500,000 500,750 496,821 0.27% SOLANO COMMUNITY COLLEGE DT 2.06% 8/1/2023 145,000 145,000 142,924 0.08% CALIFORNIA VARIOUS PURPOSE 3.50% 8/1/2023 305,000 310,490 303,614 0.17% VISTA REDEV AGENCY-TXBL 3.00% 9/1/2023 290,000 300,643 286,030 0.16% CENTRAL CONTRA COSTA SANITATION DISTRICT 3.12% 9/1/2023 415,000 417,283 411,350 0.22% CALIFORNIA STATE MUNI TAX 2.25% 10/1/2023 250,000 239,750 246,321 0.13% TX PUB FIN AUTH-A-REF 5.08% 10/1/2023 300,000 300,000 291,055 0.16% NATIONAL SECS CLEARING 4.00% 12/7/2023 500,000 498,850 479,685 0.26% OAKLAND PENSION-TXBL 4.35% 12/15/2023 400,000 440,880 398,179 0.22% RIVERSIDE CA UNIFIED SCHOOL DIST 1.98% 2/1/2024 400,000 400,000 389,120 0.21% NATIONAL RURAL UTIL COOP 3.50% 2/8/2024 300,000 297,090 284,702 0.16% CALIFORNIAST-TXBL-B 3.00% 4/1/2024 200,000 213,180 196,471 0.11% CORTE MADERA-TXBL-REF 2.75% 5/1/2024 150,000 150,300 146,338 0.08% TULARE COUNTY BRD ED-TXBL 2.31% 5/1/2024 235,000 236,528 227,519 0.12% UNIV OF CALIFORNIA -BF 0.83% 5/15/2024 120,000 120,216 113,963 0.06% CHAFFEY COMMUNITY COLLEGE DT 1.72% 6/1/2024 480,000 477,168 460,815 0.25% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED DECEMBER 31, 2022 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Municipal Securities Cont'd ORANGE-TXBL-REF 5.87% 6/1/2024 400,000 394,320 376,656 0.21% RIVERSIDE CO PUB FIN 1.92% 7/1/2024 300,000 300,000 286,519 0.16% LOMPOC VALLEY MED-TXBL 2.07% 7/1/2024 110,000 110,869 105,305 0.06% ANAHEIM PUBLIC FIN 0.63% 7/1/2024 250,000 245,500 234,047 0.13% SAN FRANCISCO CITY 3.76% 8/1/2024 250,000 270,675 244,623 0.13% TAMALPAIS UN HSD-TXBL 2.02% 8/1/2024 150,000 151,770 143,992 0.08% TENNESSEE-C-REF-TXBL 1.97% 8/1/2024 170,000 171,751 163,848 0.09% CONTRA COSTA CA COMNTY 1.77% 8/1/2024 250,000 250,000 239,149 0.13% MINNESOTA ST-C-TXBL 3.00% 8/1/2024 215,000 227,857 209,992 0.11% SOLANO COMMUNITY COLLEGE DT 2.16% 8/1/2024 300,000 300,000 288,411 0.16% SAN FRANCISCO REDEV-C 3.13% 8/1/2024 500,000 524,000 484,945 0.26% MT SAN ANTONIO CCD 1.94% 8/1/2024 400,000 404,080 384,780 0.21% MD ST -B 0.46% 8/1/2024 300,000 300,000 280,956 0.15% SANTA CLARA CO-B-TXBL 2.00% 8/1/2024 475,000 467,543 456,658 0.25% LOS ANGELES CCD -REF ** 0.67% 8/1/2024 500,000 469,000 469,715 0.26% ORANGE COUNTY CA WATER DIST 1.94% 8/15/2024 200,000 200,080 191,423 0.10% W SACRAMENTO AREA 2.07% 9/1/2024 150,000 150,000 143,247 0.08% ESCONDIDO JT POWERS 2.19% 9/1/2024 380,000 383,192 364,902 0.20% HAWAII ST -GB 0.80% 10/1/2024 125,000 124,938 117,173 0.06% CARMICHAEL WATER DIST 2.17% 11/1/2024 1,295,000 1,304,065 1,239,049 0.68% INDIO PUB FIN-B-TXBL 3.35% 11/1/2024 180,000 190,350 175,273 0.10% VENTURA COUNTY CA PUBLIC 1.22% 11/1/2024 100,000 100,000 93,687 0.05% SEMITROPIC IMP DIST-A 2.36% 12/1/2024 140,000 141,694 133,850 0.07% CON EDISON CO OF NY INC 3.30% 12/1/2024 310,000 330,646 297,266 0.16% CARSON -TXBL-REV 1.88% 1/15/2025 505,000 516,817 474,477 0.26% SAN RAMON REDEV AGY 4.00% 2/1/2025 140,000 155,834 137,150 0.07% CALIFORNIA ST MUNI FI 1.67% 2/1/2025 300,000 281,760 281,232 0.15% CALIFORNIA-TXBL 3.38% 4/1/2025 315,000 340,200 306,874 0.17% STANISLAUS CONSOL FIR 1.25% 4/1/2025 235,000 236,998 216,003 0.12% SAN DIEGO CNTY CA REG 2.09% 4/1/2025 350,000 366,485 331,821 0.18% YALE UNIVERSITY 0.87% 4/15/2025 1,075,000 1,068,318 989,432 0.54% MONTEREY PK TXBL 0.89% 6/1/2025 400,000 399,800 363,393 0.20% GOLDEN ST TOBACCO -B 1.40% 6/1/2025 300,000 300,000 274,992 0.15% LAKEPORT-REV-TXBL 1.18% 6/1/2025 155,000 155,233 141,788 0.08% MONTEBELLO -REV -TXBL ** 2.50% 6/1/2025 1,000,000 932,700 942,266 0.51% ANAHEIM PUBLIC FIN 0.94% 7/1/2025 250,000 249,400 226,683 0.12% UNIV CA-AX-TXBL 3.06% 7/1/2025 1,150,000 1,242,765 1,105,917 0.60% SAN RAMON-TXBL 1.20% 7/1/2025 500,000 497,250 456,683 0.25% UT ST-BABS-B ** 3.54% 7/1/2025 750,000 540,585 540,031 0.29% FOOTHILL DE ANZA-B 0.91% 8/1/2025 500,000 504,600 455,966 0.25% SANTA ROSA ELEM SD 1.01% 8/1/2025 500,000 500,000 452,987 0.25% W CONTRA COSTA SD -B 0.94% 8/1/2025 505,000 505,000 459,195 0.25% CASTRO VLY LIN IF SCH 1.20% 8/1/2025 500,000 503,100 457,486 0.25% OAK GROVE SD -REF 0.87% 8/1/2025 240,000 240,000 218,094 0.12% BELMONT-REDWOOD-A- 0.88% 8/1/2025 205,000 205,000 186,224 0.10% BELMONT-REDWOOD-B-REF 0.88% 8/1/2025 200,000 200,000 181,682 0.10% SAN BERNARDINO CCD 0.84% 8/1/2025 275,000 275,000 249,142 0.14% BELLFLOWER-TXBL 1.32% 8/1/2025 500,000 500,000 455,573 0.25% KLAMATH & TRIN ITY-B 1.83% 8/1/2025 250,000 250,000 231,077 0.13% COVINA-VLY SD-TXBL 1.28% 8/1/2025 410,000 381,915 376,360 0.21% SUTTER HEALTH 1.32% 8/15/2025 750,000 743,175 681,524 0.37% RIO ESD CMNTY FACS DT 1.12% 9/1/2025 380,000 380,000 343,285 0.19% ANAHEIM CA HSG & PUB -B ** 1.86% 10/1/2025 525,000 481,478 485,796 0.27% MA CMWLTH -E-TXBL-REF 0.70% 11/1/2025 220,000 218,306 196,513 0.11% CALIFORNIA STUNIV-B 0.86% 11/1/2025 100,000 100,000 89,491 0.05% STHRN KERN UNIF SD -B 1.08% 11/1/2025 370,000 370,000 332,505 0.18% VENTURA CNTY CA PUBLI 1.32% 11/1/2025 500,000 496,250 452,729 0.25% GA ST -SER H ** 4.50% 11/1/2025 535,000 534,305 533,594 0.29% TENNESSEE ST -B-REF ** 0.86% 11/1/2025 115,000 102,350 104,293 0.06% SACRAMENTO CNTY CA -B 1.04% 12/1/2025 485,000 471,275 438,259 0.24% BAY AREA CA TOLL AUTH 2.43% 4/1/2026 230,000 245,834 215,188 0.12% CALIFORNIAST-TXBL-B 2.65% 4/1/2026 500,000 526,650 470,145 0.26% WISCONSIN ST GEN FUND 3.05% 5/1/2026 300,000 329,010 284,068 0.15% UNIV OF CALIFORNIA -BI ** 0.87% 5/15/2026 405,000 353,484 355,829 0.19% NEW JERSEY ST-A-TXBL 2.25% 6/1/2026 660,000 630,432 606,971 0.33% SAN FRANCISCO CA CITY 1.10% 6/15/2026 370,000 372,923 326,280 0.18% SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED DECEMBER 31, 2022 TYPE OF INVESTMENT Municipal Securities Cont'd RED BLUFF-TXBL SOCIETE GENERALE BELMONT-REDWOOD-B-REF SAN BERNARDINO CCD BELLFLOWER -TXBL KLAMATH & TRINITY -B SAN FRANCISCO CO-TXBL RIVERSIDE UNIF SO FIN CUCAMONGA VLY WTR-B ** CALIFORNIA ST-TXBL TEXAS ST-REF-TXBL ENTERGY LOUISIANA LLC CA ST UNIV-D OREGON ST -H -REF CALIFORNIA ST UNIV-B LOS ANGELES MUNI -C RIVERSIDE CNTY CA INF ** CA ST DEPT OF WTR RES NEW YORK ST RIVERSIDE CO-TXBL-REV SAN JOSE -C -REF -REV BAY AREA CA TOLL AUTH SAN DIEGO CO REGL-A PORT OF OAKLAND CA LOS ANGELES DEPT ARPT UNIV OF CALIFORNIA -N UNIV OF CA-AG-TXBL UNIV OF CA-AS-TXBL ** PALM SPRINGS FIN AUTH ** DISCOVER BANK SANTA ROSA REGL RES DAVIS REDEV SUCCESSOR ** CALIFORNIA ST UNIV-B ** Total Municipal Securities Supranational Securities 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. Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio 1.46% 7/15/2026 350,000 356,965 305,984 0.17% 1.35% 7/30/2026 500,000 500,000 500,000 0.27% 1.10% 8/1/2026 205,000 205,000 180,512 0.10% 1.10% 8/1/2026 230,000 230,000 202,121 0.11% 1.60% 8/1/2026 465,000 463,512 412,155 0.22% 2.08% 8/1/2026 130,000 130,000 117,413 0.06% 1.76% 9/1/2026 295,000 298,540 264,422 0.14% 1.65% 9/1/2026 750,000 741,825 665,208 0.36% 3.55% 9/1/2026 250,000 238,325 239,799 0.13% 2.38% 10/1/2026 515,000 534,364 474,072 0.26% 3.42% 10/1/2026 990,000 1,093,653 954,939 0.52% 2.40% 10/1/2026 400,000 375,640 364,053 0.20% 1.14% 11/1/2026 375,000 369,563 325,913 0.18% 1.19% 11/1/2026 115,000 112,309 101,609 0.06% 1.14% 11/1/2026 500,000 447,600 434,619 0.24% 3.32% 11/1/2026 140,000 133,882 132,186 0.07% 1.47% 11/1/2026 335,000 290,579 293,957 0.16% 1.05% 12/1/2026 500,000 485,500 434,484 0.24% 2.36% 2/15/2027 800,000 809,900 730,906 0.40% 2.96% 2/15/2027 205,000 206,046 188,906 0.10% 1.73% 3/1/2027 195,000 189,345 169,938 0.09% 1.43% 4/1/2027 520,000 478,088 455,505 0.25% 1.40% 4/1/2027 425,000 388,365 371,973 0.20% 1.67% 5/1/2027 1,085,000 933,092 943,404 0.51% 1.10% 5/15/2027 240,000 207,720 204,129 0.11% 3.04% 5/15/2027 100,000 97,570 92,241 0.05% 3.28% 5/15/2027 500,000 492,550 469,419 0.26% 2.74% 5/15/2027 500,000 450,700 458,859 0.25% 1.61% 6/1/2027 845,000 717,912 733,974 0.40% 3.35% 7/20/2027 250,000 250,000 237,333 0.13% 3.07% 8/1/2027 200,000 197,000 185,759 0.10% 2.20% 9/1/2027 375,000 327,413 325,071 0.18% 1.36% 11/1/2027 380,000 323,266 321,749 0.18% 45,235,000 44,487,871 41,891,468 22.86% Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio 2.625 1/16/2024 300,000 309,510 293,202 0.16% 0.39% 4/16/2024 500,000 499,900 473,335 0.26% 0.60% 2/28/2025 500,000 496,250 460,292 0.25% 2.05% 3/17/2025 750,000 740,400 710,941 0.39% 0.65% 2/24/2026 500,000 493,900 445,117 0.24% 0.82% 2/27/2026 500,000 501,500 445,805 0.24% 2.13% 4/7/2026 396,000 418,730 370,220 0.20% 0.80% 6/17/2026 500,000 496,750 444,894 0.24% 0.88% 7/15/2026 500,000 500,900 445,188 0.24% 0.82% 9/15/2026 400,000 396,720 350,889 0.19% 0.75% 10/8/2026 250,000 246,000 219,411 0.12% 1.50% 1/13/2027 1,000,000 995,900 901,199 0.49% 6,096,000 6,096,460 5,560,493 3.03% 110,740,000 109,481,537 103,497,190 56.47% 189,261,654 183,277,306 100.00% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED DECEMBER 31, 2022 TYPE OF INVESTMENT Interest Rate Maturitv Date Par Value Cost Market Value % of Portfolio 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 June 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. lva� xy�pj Andrew Keys, Treasurer/Director of Finance Andrew Keys Review Date Lisa Noffsinger, Budget Manager 3/21/23 Review Date IRS Section 115 Retirement Benefit Trust Funds Public Agency Retirement Services - Pension Stabilization Fund Balanced Strategy Mutual Fund Total Pension Stabilization Fund CalPERS - California Employer's Retiree Benefit Trust (CERBT) CERBT Strategy 2 Total CERBT Total Section 115 Retirement Benefit Trust Funds Restricted Cash Accounts PCE/TCE Central Plume Remediation Fund Farmers & Merchants Bank Money Market Total PCE/TCE Central Plume Account Total Restriction Cash Accounts Market Value $ 20,023,091 $ 20,023,091 $ 2,046,507 $ 2,046,507 $ 22,069,598 Market Value $ 439,696 $ 439,696 $ 439,696