The URL can be used to link to this page

Home My WebLink AboutAgenda Report - March 2, 2022 C-04AGENDA ITEM C,,4 ANCITY OF LODI COUNCIL COMMUNICATION TM AGENDA TITLE: Accept the Quarterly Investment Report as Required by the City of Lodi Investment Policy MEETING DATE: March 2, 2022 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 2018-33 on March 7, 2018, requiring the Treasurer to submit a quarterly investment reporting in accordance with Section 53646. The attached Treasurer's Report for the quarter ending December 31, 2021 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: littp://www.lodi.gov/196/Finance FISCAL IMPACT FUNDING AVAILABLE Attachment Not applicable. As per attached report. AndimNays WdiL5,D 150 P -5T) Andrew Keys Treasurer ab APPROVED: r ,:5 r ' er (Fpb lB, ]i172 n6:;R P5T1 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 Bond Mutual Fund CAL TRUST Medium Term Fund Total Bond Mutual Funds Local Bank Certificates of Deposit Farmers & Merchants Bank Total Local Bank Certificates of Deposit Negotiable Certificates of Deposit HORIZON BANK NATION ASSN CITI BANK CAPITAL ONE BANK USA NA CAPITAL ONE NA WELLS FARGO BANK NA GOLDMAN SACHS BANK USA AMERICAN EXPRESS BANK FSB SYNCHRONY BANK SALLIE MAE BANK/SALT LAKE CITY, UTAH STATE BANK OF INDIA MEDALLION BANK UTAH STIFEL BANK AND TRUST CITIBANK NA INDUSTRIAL & COM BK CHNA COMENITY CAPITAL BANK UBS BANK BARCLAYS BANK/DELAWARE BANK OFBARODA MCHENRY SAVINGS BK IL MORGAN STANLEY BANK MORGAN STANLEY PRIVATE BANK BMW BANK NORTH AMERICA ** FIRST NATL BK OF AMERICA ** TEXAS EXCHANGE BANK SSB ** BANK HAPOALIM BM NY ** Total Negotiable Certificates of Deposit Agency Securities FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL FARM CREDIT BANK SYSTEM FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL HOME LOAN BANK FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL FARM CREDIT BANK SYSTEM FEDERAL FARM CREDIT BANK SYSTEM FEDERAL HOME LOAN BANK FEDERAL AGRICULTURE MORTGAGE CORPORATION FEDERAL NATIONAL MORTGAGE ASSOCIATION ** FEDERAL HOME LOAN BANK FEDERAL HOME LOAN MORTGAGE CO ** FREDDIE MAC FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN BANK FAMCA ** CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED DECEMBER 31, 2021 Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Due on Demand 4,048,116 4,048,116 2.47% Due on Demand 70,681 70,681 0.04% Due on Demand 54,351,134 54,351,134 33.22% Due on Demand 5,428,890 5,428,890 3.32% Due on Demand 1,849,198 1,849,198 1.13% 65,748,019 65,748,019 40.18% Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Due on Demand 10,464,224 10,464,224 6.39% 10,464,224 10,464,224 6.39% Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio 0.20% 11/7/2023 2,000,000 2,000,000 2,000,000 1.22% 2,000,000 2,000,000 2,000,000 1.22% Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio 2.85% 5/4/2022 250,000 252,238 252,238 0.15% 1.95% 8/23/2022 250,000 252,708 252,708 0.15% 2.40% 11/22/2022 250,000 254,611 254,611 0.16% 2.40% 11/22/2022 250,000 254,611 254,611 0.16% 2.40% 11/22/2022 250,000 254,614 254,614 0.16% 2.40% 11/22/2022 250,000 254,611 254,611 0.16% 2.50% 12/5/2022 250,000 255,026 255,026 0.16% 2.60% 1/19/2023 250,000 255,849 255,849 0.16% 2.65% 1/24/2023 250,000 256,048 256,048 0.16% 2.70% 2/16/2023 250,000 256,497 256,497 0.16% 2.90% 4/10/2023 250,000 257,838 257,838 0.16% 2.95% 5/15/2023 250,000 258,514 258,514 0.16% 3.25% 6/6/2023 250,000 259,889 259,889 0.16% 3.30% 6/30/2023 250,000 260,471 260,471 0.16% 3.30% 7/16/2023 250,000 260,709 260,709 0.16% 3.35% 10/5/2023 250,000 262,150 262,150 0.16% 3.35% 10/10/2023 250,000 262,211 262,211 0.16% 3.55% 11/30/2023 250,000 263,909 263,909 0.16% 2.80% 3/14/2024 250,000 261,484 261,484 0.16% 1.95% 11/29/2024 250,000 257,692 257,692 0.16% 1.90% 11/29/2024 250,000 257,333 257,333 0.16% 0.90% 12/10/2024 250,000 250,104 250,104 0.15% 1.25% 12/30/2026 250,000 249,236 249,236 0.15% 1.25% 12/30/2026 250,000 249,840 249,840 0.15% 1.50% 1/7/2027 250,000 250,000 250,000 0.15% 6,250,000 6,408,191 6,408,191 3.92% Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio 2.63% 3/11/2022 250,000 250,872 250,872 0.15% 2.62% 5/27/2022 250,000 252,103 252,103 0.15% 1.88% 6/1/2022 250,000 251,555 251,555 0.15% 2.00% 8/26/2022 250,000 252,420 252,420 0.15% 3.13% 9/9/2022 250,000 254,235 254,235 0.16% 2.38% 1/19/2023 250,000 254,330 254,330 0.16% 2.65% 3/8/2023 250,000 256,052 256,052 0.16% 2.70% 4/11/2023 250,000 256,584 256,584 0.16% 2.85% 5/8/2023 250,000 256,691 256,691 0.16% 2.90% 7/24/2023 250,000 257,638 257,638 0.16% 1.63% 10/15/2024 500,000 504,374 504,374 0.31% 2.75% 12/13/2024 500,000 519,709 519,709 0.32% 0.57% 9/24/2025 500,000 481,761 481,761 0.29% 0.60% 10/27/2025 500,000 485,310 485,310 0.30% 0.90% 12/26/2025 500,000 487,602 487,602 0.30% 0.85% 3/30/2026 400,000 389,314 389,314 0.24% 1.20% 4/28/2026 500,000 492,785 492,785 0.30% 1.00% 5/26/2026 500,000 489,206 489,206 0.30% 1.88% 9/11/2026 400,000 404,546 404,546 0.25% 1.05% 10/5/2026 500,000 486,921 486,921 0.30% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED DECEMBER 31, 2021 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 477,735 477,735 0.29% Total Agency Securities 7,800,000 7,761,742 7,761,742 4.74% US Treasury Notes Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio UNITED STATES TREASURY 1.50% 1/31/2022 250,000 250,117 250,117 0.15% UNITED STATES TREASURY 1.88% 2/28/2022 250,000 250,491 250,491 0.15% UNITED STATES TREASURY 1.88% 3/31/2022 250,000 250,855 250,855 0.15% UNITED STATES TREASURY 1.75% 5/31/2022 250,000 251,329 251,329 0.15% UNITED STATES TREASURY 1.75% 6/30/2022 250,000 251,592 251,592 0.15% UNITED STATES TREASURY 1.88% 7/31/2022 250,000 252,012 252,012 0.15% UNITED STATES TREASURY 1.63% 8/31/2022 250,000 251,807 251,807 0.15% UNITED STATES TREASURY 1.88% 9/30/2022 250,000 252,461 252,461 0.15% UNITED STATES TREASURY 2.00% 10/31/2022 250,000 252,930 252,930 0.15% UNITED STATES TREASURY 2.00% 11/30/2022 250,000 253,125 253,125 0.15% UNITED STATES TREASURY 2.13% 12/31/2022 250,000 253,594 253,594 0.15% UNITED STATES TREASURY 1.50% 2/28/2023 250,000 252,324 252,324 0.15% UNITED STATES TREASURY 1.50% 3/31/2023 250,000 252,314 252,314 0.15% UNITED STATES TREASURY 1.63% 4/30/2023 250,000 252,656 252,656 0.15% UNITED STATES TREASURY 1.63% 5/31/2023 250,000 252,744 252,744 0.15% UNITED STATES TREASURY 2.63% 6/30/2023 250,000 256,416 256,416 0.16% UNITED STATES TREASURY 1.25% 7/31/2023 250,000 251,357 251,357 0.15% UNITED STATES TREASURY ** 0.25% 6/15/2024 250,000 244,424 244,424 0.15% UNITED STATES TREASURY ** 0.38% 9/15/2024 250,000 244,180 244,180 0.15% UNITED STATES TREASURY ** 1.00% 12/15/2024 250,000 247,617 247,617 0.15% UNITED STATES TREASURY ** 0.50% 3/31/2025 250,000 243,115 243,115 0.15% UNITED STATES TREASURY ** 0.25% 6/30/2025 250,000 239,990 239,990 0.15% UNITED STATES TREASURY ** 0.25% 9/30/2025 250,000 238,906 238,906 0.15% UNITED STATES TREASURY 0.38% 11/30/2025 350,000 334,893 334,893 0.20% UNITED STATES TREASURY ** 0.38% 12/31/2025 250,000 238,916 238,916 0.15% UNITED STATES TREASURY 0.38% 1/31/2026 350,000 333,854 333,854 0.20% UNITED STATES TREASURY 0.75% 3/31/2026 750,000 724,717 724,717 0.44% UNITED STATES TREASURY 0.75% 5/31/2026 500,000 482,031 482,031 0.29% UNITED STATES TREASURY ** 0.88% 6/30/2026 250,000 242,080 242,080 0.15% UNITED STATES TREASURY ** 0.88% 9/30/2026 250,000 241,406 241,406 0.15% UNITED STATES TREASURY ** 1.25% 12/31/2026 250,000 245,293 245,293 0.15% Total US Treasury Notes 8,700,000 8,589,545 8,589,545 5.25% Corporate Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio JOHNSON&JOHNSON 2.25% 3/3/2022 250,000 250,369 250,369 0.15% WELLS FARGO & COMPANY 3.50% 3/8/2022 400,000 401,674 401,674 0.25% TO AMERITRADE HOLDING COMPANY 2.95% 4/1/2022 250,000 250,501 250,501 0.15% ORACLE CORP 2.50% 5/15/2022 100,000 100,308 100,308 0.06% UNITED PARCEL SERVICE 2.35% 5/16/2022 100,000 100,482 100,482 0.06% DEERE & COMPANY 2.60% 6/8/2022 100,000 100,314 100,314 0.06% 3M COMPANY 2.00% 6/26/2022 150,000 150,975 150,975 0.09% TOYOTA MOTOR CREDIT CORPORATION 2.80% 7/13/2022 250,000 252,636 252,636 0.15% PROCTER & GAMBLE COMPANY 2.15% 8/11/2022 250,000 252,359 252,359 0.15% MERCK & CO INC 2.40% 9/15/2022 100,000 100,794 100,794 0.06% JPMORGAN CHASE & CO 3.25% 9/23/2022 100,000 101,756 101,756 0.06% GENERAL ELECTRIC CO 2.70% 10/9/2022 250,000 253,408 253,408 0.15% MICROSOFT CORP 2.65% 11/3/2022 250,000 253,327 253,327 0.15% AUSTRALIA & NEW ZEALAND BANKING GROUP NY 2.63% 11/9/2022 250,000 254,084 254,084 0.16% VISA INC 2.80% 12/14/2022 250,000 254,230 254,230 0.16% BANK OF NEW YORK MELLON CORP 2.95% 1/29/2023 100,000 102,166 102,166 0.06% WELLS FARGO NATIONAL BANK WEST 1.90% 1/30/2023 250,000 254,118 254,118 0.16% WELLS FARGO & COMPANY 3.45% 2/13/2023 150,000 154,109 154,109 0.09% UNITED HEALTH GROUP INC 2.75% 2/15/2023 100,000 101,369 101,369 0.06% EXXON MOBIL CORPORATION 2.73% 3/1/2023 250,000 254,276 254,276 0.16% WALMART INC 2.55% 4/11/2023 250,000 254,198 254,198 0.16% APPLE INC 2.40% 5/3/2023 250,000 254,650 254,650 0.16% SOUTHERN CALIFORNIA EDISON 3.40% 6/1/2023 254,000 260,189 260,189 0.16% CHEVRON CORPORATION 3.19% 6/24/2023 250,000 256,691 256,691 0.16% NEW YORK UNIVERSITY 2.72% 7/1/2023 230,000 232,983 232,983 0.14% ORACLE CORP 3.63% 7/15/2023 250,000 258,185 258,185 0.16% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED DECEMBER 31, 2021 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Corporate Securities Cont'd IBM CORP 3.38% 8/1/2023 500,000 516,515 516,515 0.32% GILEAD SCIENCES INC 2.50% 9/1/2023 260,000 265,440 265,440 0.16% PROV ST JOSEPH HEALTH OBL 4.38% 10/1/2023 315,000 330,660 330,660 0.20% PRES & FELLOWS OF HARVAR 2.60% 10/1/2023 300,000 305,759 305,759 0.19% TOYOTA MOTOR CREDIT CORP 2.25% 10/18/2023 250,000 254,435 254,435 0.16% NATIONAL RURAL UTIL COOP 3.40% 11/15/2023 300,000 310,582 310,582 0.19% ALABAMA POWER CO 3.55% 12/1/2023 250,000 260,324 260,324 0.16% TOYOTA MOTOR CREDIT CORP 3.35% 1/8/2024 400,000 416,481 416,481 0.25% JOHN DEERE CAPITAL CORP 3.45% 1/10/2024 250,000 260,882 260,882 0.16% BP CAP MARKETS AMERICA 3.79% 2/6/2024 500,000 523,076 523,076 0.32% 3M COMPANY 3.25% 2/14/2024 300,000 312,303 312,303 0.19% BOEING CO 2.80% 3/1/2024 250,000 255,338 255,338 0.16% DETROIT EDISON CO 3.65% 3/15/2024 300,000 311,921 311,921 0.19% BANK OF AMERICA CORP 4.00% 4/1/2024 250,000 263,890 263,890 0.16% HORMEL FOODS CORP ** 0.65% 6/3/2024 500,000 495,085 495,085 0.30% CATERILLAR FINANCIAL SERVICE 3.30% 6/9/2024 500,000 523,398 523,398 0.32% AMERICAN HONDA FINANCE 0.55% 7/12/2024 400,000 389,929 389,929 0.24% WALT DISNEY COMPANY 1.75% 8/30/2024 500,000 503,407 503,407 0.31% WELLS FARGO & COMPANY 3.30% 9/9/2024 750,000 781,611 781,611 0.48% AMERICAN HONDA FINANCE 2.15% 9/10/2024 500,000 507,859 507,859 0.31% SHELL INTERNATIONAL FIN 2.00% 11/7/2024 500,000 507,853 507,853 0.31% CATERILLAR FINANCIAL SERVICE 3.25% 12/1/2024 500,000 524,711 524,711 0.32% TOYOTA MOTOR CREDIT CORP 1.80% 2/13/2025 300,000 300,828 300,828 0.18% WESTPAC BANKING CORP 2.35% 2/19/2025 500,000 509,448 509,448 0.31% AMAZON.COM INC ** 0.80% 6/3/2025 500,000 485,605 485,605 0.30% APPLE INC 0.55% 8/20/2025 500,000 480,856 480,856 0.29% JOHNSON&JOHNSON 0.55% 9/1/2025 950,000 915,466 915,466 0.56% NATIONAL RURAL UTIL COOP 1.00% 9/15/2025 500,000 483,570 483,570 0.30% TOYOTA MOTOR CREDIT CORP 0.80% 10/16/2025 500,000 481,959 481,959 0.29% TOYOTA MOTOR CREDIT CORP 0.80% 1/9/2026 500,000 480,155 480,155 0.29% APPLE INC 0.70% 2/8/2026 500,000 480,755 480,755 0.29% PUBLIC STORAGE 0.88% 2/15/2026 300,000 288,050 288,050 0.18% MERCK & CO INC 0.75% 2/24/2026 400,000 385,638 385,638 0.24% JP MORGAN CHASE BANK 1.00% 3/26/2026 250,000 250,442 250,442 0.15% BMO HARRIS BANK NA 1.00% 4/13/2026 250,000 248,069 248,069 0.15% AMAZON.COM INC 1.00% 5/12/2026 500,000 486,110 486,110 0.30% CHARLES SCHWAB CORP 1.15% 5/13/2026 500,000 485,304 485,304 0.30% BANK OF AMERICA CORP 1.25% 5/28/2026 500,000 472,183 472,183 0.29% BANK OF AMERICA CORP 1.20% 6/25/2026 500,000 465,228 465,228 0.28% TOYOTA FINANCIAL SGS BK 0.95% 7/29/2026 250,000 246,803 246,803 0.15% BANK OF AMERICA CORP 1.15% 9/10/2026 250,000 241,092 241,092 0.15% TEXAS INSTRUMENTS INC ** 1.13% 9/15/2026 400,000 392,384 392,384 0.24% JPMORGAN CHASE & CO 2.95% 10/1/2026 500,000 518,112 518,112 0.32% Total Corporate Securities 23,309,000 23,379,664 23,379,664 14.29% Municipal Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio ROSEVILLE FINANCE AUTHORITY - ELECTRIC SYSTEM 2.41% 2/1/2022 250,000 250,393 250,393 0.15% POMONA REDEV AGY-REF 3.55% 2/1/2022 275,000 275,594 275,594 0.17% CA ST-TXBL 6.65% 3/1/2022 320,000 323,264 323,264 0.20% STATE OF MARYLAND 2.65% 3/15/2022 300,000 301,435 301,435 0.18% CALIFORNIA EDUCATIONAL FACILITIES AUTHORITY 2.46% 4/1/2022 250,000 251,141 251,141 0.15% CALIFORNIA ST-A-TXBL 2.37% 4/1/2022 500,000 502,723 502,723 0.31% SACRAMENTO CA PUBLIC 3.79% 4/1/2022 175,000 176,341 176,341 0.11% CALIFORNIA STATE DEPT OF WATER RESOURCES 2.00% 5/1/2022 300,000 301,577 301,577 0.18% UNIV OF CALIFORNIA -BC 2.61% 5/15/2022 250,000 252,186 252,186 0.15% FAIRFIELD-REF-TXBL 3.25% 6/1/2022 150,000 151,664 151,664 0.09% TULARE COUNTY CA PENSION OBLIGATION 3.20% 6/1/2022 250,000 252,999 252,999 0.15% ARKANSAS ST AMENDMENT 82 2.84% 7/1/2022 100,000 101,235 101,235 0.06% ADELANTO PUBLIC UTILITIES 3.50% 7/1/2022 240,000 243,341 243,341 0.15% ORANGE COUNTY CA WATER DIST 1.83% 8/15/2022 125,000 126,042 126,042 0.08% OCEANSIDE CA PENSION OBLIGATION 3.84% 8/15/2022 200,000 203,991 203,991 0.12% VISTA CA REDEVELOPMENT 3.00% 9/1/2022 120,000 121,741 121,741 0.07% SAN BERNARDINO COUNTY REDEVELOPMENT 3.25% 9/1/2022 160,000 162,743 162,743 0.10% SAN LEANDRO CA REDEVELOPMENT AGENCY 3.21% 9/1/2022 260,000 264,285 264,285 0.16% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED DECEMBER 31, 2021 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Municipal Securities Cont'd TX PUB FIN AUTH-A-REF ** 3.08% 10/1/2022 300,000 299,866 299,866 0.18% SAN FRANCISCO CITY & COUNTY CA 2.40% 11/1/2022 445,000 452,100 452,100 0.28% CALIFORNIA DEPARTMENT OF WATER RESOURCES 2.52% 12/1/2022 75,000 76,357 76,357 0.05% CARSON CA REDEVELOPMENT 3.00% 2/1/2023 80,000 81,880 81,880 0.05% CALIFORNIA HOUSING FINANCE AGENCY 2.88% 2/1/2023 450,000 458,707 458,707 0.28% GEORGIA ST GENERAL OBLIGATION 2.23% 2/1/2023 310,000 315,643 315,643 0.19% FRESNO FING-B REF 3.18% 4/1/2023 285,000 292,797 292,797 0.18% OHIO ST THIRD FRONTIER RESEARCH 2.11% 5/1/2023 250,000 254,684 254,684 0.16% RIVERSIDE CA PENSION OBLIGATION 2.63% 6/1/2023 250,000 255,818 255,818 0.16% SAN DIEGO TOBACCO SETTLEMENT 3.44% 6/1/2023 500,000 517,358 517,358 0.32% INDUSTRY-REF-TXBL 3.00% 7/1/2023 500,000 500,784 500,784 0.31% SOLANO COMMUNITY COLLEGE DT 2.06% 8/1/2023 145,000 148,128 148,128 0.09% CALIFORNIA VARIOUS PURPOSE 3.50% 8/1/2023 305,000 317,651 317,651 0.19% VISTA REDEV AGENCY-TXBL 3.00% 9/1/2023 290,000 298,133 298,133 0.18% CENTRAL CONTRA COSTA SANITATION DISTRICT 3.12% 9/1/2023 415,000 430,934 430,934 0.26% CALIFORNIA STATE MUNI TAX 2.25% 10/1/2023 250,000 256,247 256,247 0.16% TX PUB FIN AUTH-A-REF ** 5.08% 10/1/2023 300,000 298,787 298,787 0.18% NATIONAL SECS CLEARING ** 4.00% 12/7/2023 500,000 492,609 492,609 0.30% OAKLAND PENSION-TXBL 4.35% 12/15/2023 400,000 426,354 426,354 0.26% RIVERSIDE CA UNIFIED SCHOOL DIST 1.98% 2/1/2024 400,000 408,738 408,738 0.25% NATIONAL RURAL UTIL COOP ** 3.50% 2/8/2024 300,000 294,046 294,046 0.18% CALIFORNIAST-TXBL-B 3.00% 4/1/2024 200,000 209,523 209,523 0.13% CORTE MADERA-TXBL-REF 2.75% 5/1/2024 150,000 154,957 154,957 0.09% TULARE COUNTY BRD ED-TXBL 2.31% 5/1/2024 235,000 240,362 240,362 0.15% UNIV OF CALIFORNIA -BF ** 0.83% 5/15/2024 120,000 119,610 119,610 0.07% CHAFFEY COMMUNITY COLLEGE DT 1.72% 6/1/2024 480,000 487,556 487,556 0.30% ORANGE-TXBL-REF** 5.87% 6/1/2024 400,000 394,332 394,332 0.24% RIVERSIDE CO PUB FIN 1.92% 7/1/2024 300,000 304,664 304,664 0.19% LOMPOC VALLEY MED-TXBL 2.07% 7/1/2024 110,000 112,124 112,124 0.07% SAN FRANCISCO CITY 3.76% 8/1/2024 250,000 266,620 266,620 0.16% TAMALPAIS UN HSD-TXBL 2.02% 8/1/2024 150,000 153,950 153,950 0.09% TENNESSEE-C-REF-TXBL 1.97% 8/1/2024 170,000 174,678 174,678 0.11% CONTRA COSTA CA COMNTY 1.77% 8/1/2024 250,000 254,952 254,952 0.16% MINNESOTA ST-C-TXBL 3.00% 8/1/2024 215,000 225,719 225,719 0.14% SOLANO COMMUNITY COLLEGE DT 2.16% 8/1/2024 300,000 308,687 308,687 0.19% SAN FRANCISCO REDEV-C 3.13% 8/1/2024 500,000 522,088 522,088 0.32% MT SAN ANTONIO CCD 1.94% 8/1/2024 400,000 410,123 410,123 0.25% MD ST -B 0.46% 8/1/2024 300,000 295,494 295,494 0.18% ORANGE COUNTY CA WATER DIST 1.94% 8/15/2024 200,000 204,082 204,082 0.12% W SACRAMENTO AREA 2.07% 9/1/2024 150,000 153,170 153,170 0.09% ESCONDIDO JT POWERS 2.19% 9/1/2024 380,000 390,347 390,347 0.24% HAWAII ST -GB ** 0.80% 10/1/2024 125,000 124,064 124,064 0.08% CARMICHAEL WATER DIST 2.17% 11/1/2024 1,295,000 1,332,891 1,332,891 0.81% INDIO PUB FIN-B-TXBL 3.35% 11/1/2024 180,000 187,356 187,356 0.11% VENTURA COUNTY CA PUBLIC 1.22% 11/1/2024 100,000 100,153 100,153 0.06% SEMITROPIC IMP DIST-A 2.36% 12/1/2024 140,000 144,495 144,495 0.09% CON EDISON CO OF NY INC 3.30% 12/1/2024 310,000 322,626 322,626 0.20% CARSON -TXBL-REV ** 1.88% 1/15/2025 505,000 510,273 510,273 0.31% SAN RAMON REDEV AGY 4.00% 2/1/2025 140,000 150,181 150,181 0.09% CALIFORNIA-TXBL 3.38% 4/1/2025 315,000 337,985 337,985 0.21% STANISLAUS CONSOL FIR ** 1.25% 4/1/2025 235,000 234,048 234,048 0.14% SAN DIEGO CNTY CA REG 2.09% 4/1/2025 350,000 360,064 360,064 0.22% YALE UNIVERSITY ** 0.87% 4/15/2025 1,075,000 1,061,991 1,061,991 0.65% MONTEREY PK TXBL 0.89% 6/1/2025 400,000 391,954 391,954 0.24% GOLDEN ST TOBACCO -B ** 1.40% 6/1/2025 300,000 298,534 298,534 0.18% LAKEPORT-REV-TXBL ** 1.18% 6/1/2025 155,000 153,881 153,881 0.09% ANAHEIM PUBLIC FIN 0.94% 7/1/2025 250,000 245,040 245,040 0.15% UNIV CA-AX-TXBL 3.06% 7/1/2025 1,150,000 1,222,853 1,222,853 0.75% SAN RAMON-TXBL ** 1.20% 7/1/2025 500,000 497,250 497,250 0.30% FOOTHILL DE ANZA-B 0.91% 8/1/2025 500,000 494,598 494,598 0.30% SANTA ROSA ELEM SD 1.01% 8/1/2025 500,000 493,522 493,522 0.30% W CONTRA COSTA SD -B 0.94% 8/1/2025 505,000 497,837 497,837 0.30% CASTRO VLY UNIF SCH 1.20% 8/1/2025 500,000 495,216 495,216 0.30% OAK GROVE SD -REF 0.87% 8/1/2025 240,000 235,507 235,507 0.14% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED SEPTEMBER 30, 2021 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Municipal Securities Cont'd BELMONT-REDWOOD-A- 0.88% BELMONT-REDWOOD-B-REF 0.88% SAN BERNARDINO CCD 0.84% BELLFLOWER -TXBL ** 1.32% SUTTER HEALTH ** 1.32% RIO ESD CMNTY FACS DT 1.12% MA CM W LTH -E-TXBL-REF 0.70% CALIFORNIA ST UNIV-B 0.86% STHRN KERN UNIF SD -B 1.08% BAY AREA CA TOLL AUTH 2.43% CALIFORNIA ST-TXBL-B ** 2.65% WISCONSIN ST GEN FUND 3.05% SAN FRANCISCO CA CITY 1.10% RED BLUFF-TXBL 1.46% SOCIETE GENERALE 1.35% BELMONT-REDWOOD-B-REF 1.10% SAN BERNARDINO CCD 1.10% BELLFLOWER -TXBL ** 1.60% SAN FRANCISCO CO-TXBL ** 1.76% CALIFORNIA ST-TXBL ** 2.38% TEXAS ST-REF-TXBL ** 3.42% CA ST UNIV-D ** 1.14% Total Municipal Securities 4/1/2026 Supranational Securitles Interest Rate P INTERAMER DEV 0.39% INTL FIN CORP ** 0.60% INTERAMER DEV 0.80% INTERAMER DEV ** 1.50% INTL BK RECON & DEVELOP 0.88% INT BK RECON&D 0.65% INTL FIN CORP ** 0.75% INTL FIN CORP 2.13% INTL FIN CORP 0,82% Total Supranational Securities 750,000 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. 8/1/2025 205,000 202,096 202,096 0.12% 8/1/2025 200,000 197,167 197,167 0.12% 8/1/2025 275,000 271,177 271,177 0.17% 8/1/2025 500,000 497,367 497,367 0.30% 8/15/2025 750,000 734,116 734,116 0.45% 9/1/2025 380,000 374,484 374,484 0.23% 11/1/2025 220,000 214,844 214,844 0.13% 11/1/2025 100,000 98,351 98,351 0.06% 11/1/2025 370,000 365,176 365,176 0.22% 4/1/2026 230,000 238,472 238,472 0.15% 4/1/2026 500,000 525,550 525,550 0.32% 5/1/2026 300,000 319,245 319,245 0.20% 6/15/2026 370,000 362,290 362,290 0.22% 7/15/2026 350,000 346,147 346,147 0.21% 7/30/2026 500,000 500,000 500,000 0.31% 8/1/2026 205,000 201,663 201,663 0.12% 8/1/2026 230,000 226,840 226,840 0.14% 8/1/2026 465,000 463,521 463,521 0.28% 9/1/2026 295,000 298,043 298,043 0.18% 10/1/2026 515,000 530,218 530,218 0.32% 10/1/2026 990,000 1,082,395 1,082,395 0.66% 11/1/2026 375,000 368,551 368,551 0.23% 34,330,000 34,833,381 34,833,381 21.29% irity Date Par Value Cost Market Value %of Portfolio 4/16/2024 500,000 491,395 491,395 0.30% 2/28/2025 500,000 490,555 490,555 0.30% 6/17/2026 500,000 484,146 484,146 0.30% 1/13/2027 1,000,000 991,159 991,159 0.61% 7/15/2026 500,000 483,100 483,100 0.30% 2/24/2026 500,000 478,508 478,508 0.29% 10/8/2026 250,000 239,285 239,285 0.15% 4/7/2026 396,000 404,042 404,042 0.25% 9/15/2026 400.000 384,861 384,861 0.24% 4,546,000 4,447,051 4,447,051 2.72% 86,935,000 87,419,574 87,419,574 53.42% 163,631,817 163,631,817 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 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. " Andrew Keys RFeh 1',. )..';' ] :100PST} Andrew Keys, Treasurer/Director of Finance 2/15/2022 Review Date Za,fi+L,� Susan Bjork, Budget Manager 02/15/2022 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 $ 21,245,657 $ 21,245,657 $ 2,486,210 $ 2,486,210 $ 23,731,867 Market Value $ 586,432 $ 586,432 $ 586,432