The URL can be used to link to this page

Home My WebLink AboutAgenda Report - November 16, 2022 C-04CITY OF 4 its 6�10 CALIFORNIA AGENDA ITEM C654 COUNCIL COMMUNICATION AGENDA TITLE: Accept the Quarterly Investment Report as Required by the City of Lodi Investment Policy MEETING DATE: November 16, 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 2021-164 on June 2, 2021 approving FY 21/22 Investment Policy. The attached Treasurer's Report for the quarter ending September 30, 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: http:lfwww.lodi.gov/l961Finance . FISCAL IMPACT: Not applicable. FUNDING AVAILABLE: As per attached report. oflv4j� Andrew Keys Deputy City Manager/Internal Services Director APPROVED: rvfwu�3,aur2�n:.shrUr� Stephen Schwabauer, City Manager ;�lY�'L�7�[Ur71 SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED SEPTEMBER 30, 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 4,503,387 4,503,387 2.55% Farmers & Merchants Bank Payroll * Due on Demand 55,487 55,487 0.03% Local Agency Investment Fund Due on Demand 59,537,500 59,537,500 33.71% Farmer's & Merchants Bank Money Market * Due on Demand 7,546,088 7,546,088 4.27% Wells Fargo Bank Money Market * Due on Demand 1,598,849 1,598,849 0.91% Total Demand Deposit Accounts 73,241,312 73,241,312 41.47% Bond Mutual Fund Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio CAL TRUST Medium Term Fund Due on Demand 10,008,322 10,008,322 5.67% Total Bond Mutual Funds 10,008,322 10,008,322 5.67% Local Bank Certificates of Deposit Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Farmers & Merchants Bank 0.20% 11/7/2022 2,000,000 2,000,000 2,000,000 1.13% Total Local Bank Certificates of Deposit 2,000,000 2,000,000 2,000,000 1.13% Negotiable Certificates of Deposit Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio CAPITAL ONE BANK USA NA 2.40% 11/22/2022 250,000 250,000 249,753 0.14% CAPITAL ONE NA 2.40% 11/22/2022 250,000 250,000 249,753 0.14% WELLS FARGO BANK NA 2.40% 11/22/2022 250,000 250,000 249,767 0.14% GOLDMAN SACHS BANK USA 2.40% 11/22/2022 250,000 250,000 249,753 0.14% AMERICAN EXPRESS BANK FSB 2.50% 12/5/2022 250,000 246,700 249,702 0.14% SYNCHRONY BANK 2.60% 1/19/2023 250,000 250,000 249,345 0.14% SALLIE MAE BANK/SALT LAKE CITY, UTAH 2.65% 1/24/2023 250,000 250,000 249,330 0.14% STATE BANK OF INDIA 2.70% 2/16/2023 250,000 250,000 249,106 0.14% MEDALLION BANK UTAH 2.90% 4/10/2023 250,000 250,000 248,700 0.14% STIFEL BANK AND TRUST 2.95% 5/15/2023 250,000 250,000 248,511 0.14% CITIBANK NA 3.25% 6/6/2023 250,000 250,000 248,861 0.14% INDUSTRIAL & COM BK CHNA 3.30% 6/30/2023 250,000 250,000 248,819 0.14% COMENITY CAPITAL BANK 3.30% 7/16/2023 250,000 250,000 248,683 0.14% UBS BANK 3.35% 10/5/2023 250,000 250,000 248,012 0.14% BARCLAYS BANK/DELAWARE 3.35% 10/10/2023 250,000 250,000 247,995 0.14% BANK OF BARODA 3.55% 11/30/2023 250,000 250,000 248,224 0.14% MCHENRY SAVINGS BK IL 2.80% 3/14/2024 250,000 250,000 245,003 0.14% MORGAN STANLEY BANK 1.95% 11/29/2024 250,000 250,000 237,922 0.13% MORGAN STANLEY PRIVATE BANK 1.90% 11/29/2024 250,000 250,000 237,666 0.13% BMW BANK NORTH AMERICA 0.90% 12/10/2024 250,000 250,000 232,308 0.13% ALLY BANK ** 3.30% 8/18/2026 250,000 250,000 240,720 0.14% FIRST NATL BK OF AMERICA 1.25% 12/30/2026 250,000 250,000 219,782 0.12% TEXAS EXCHANGE BANK SSB 1.25% 12/30/2026 250,000 250,000 220,266 0.12% BANK HAPOALIM BM NY 1.50% 1/7/2027 250,000 250,000 222,258 0.13% AMERICAN EXPRESS NATIONAL BANK 3.40% 6/29/2027 250,000 250,000 239,223 0.14% Total Negotiable Certificates of Deposit 6,250,000 6,246,700 6,079,462 3.44% 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,031 0.14% FEDERAL FARM CREDIT BANK SYSTEM 2.65% 3/8/2023 250,000 249,325 249,040 0.14% FEDERAL FARM CREDIT BANK SYSTEM 2.70% 4/11/2023 250,000 249,500 248,370 0.14% FEDERAL HOME LOAN BANK 2.85% 5/8/2023 250,000 250,175 248,089 0.14% FEDERAL AGRICULTURE MORTGAGE CORPORATION 2.90% 7/24/2023 250,000 249,150 247,483 0.14% FEDERAL FARM CREDIT BANK SYSTEM 0.90% 1/18/2024 500,000 499,250 479,462 0.27% FAMCA 2.65% 5/2/2024 350,000 349,825 341,473 0.19% FEDERAL NATIONAL MORTGAGE ASSOCIATION 1.63% 10/15/2024 500,000 508,800 474,561 0.27% FEDERAL HOME LOAN BANK 2.75% 12/13/2024 500,000 537,050 483,531 0.27% FEDERAL HOME LOAN MORTGAGE CO 3.00% 12/23/2024 400,000 399,800 391,695 0.22% FEDERAL HOME LOAN BANK 1.25% 1/28/2025 500,000 500,000 462,568 0.26% FEDERAL HOME LOAN MORTGAGE CO 3.15% 3/27/2025 400,000 400,000 389,985 0.22% FEDERAL HOME LOAN MORTGAGE CO 0.57% 9/24/2025 500,000 487,850 446,663 0.25% FREDDIE MAC 0.60% 10/27/2025 500,000 497,750 444,419 0.25% FAMCA 0.49% 12/18/2025 300,000 279,360 265,589 0.15% FEDERAL HOME LOAN BANK 0.90% 12/26/2025 500,000 499,900 445,626 0.25% FEDERAL HOME LOAN BANK 0.55% 1/20/2026 500,000 464,700 439,350 0.25% FEDERAL HOME LOAN BANK 0.85% 3/30/2026 400,000 399,840 352,973 0.20% FEDERAL HOME LOAN BANK 1.20% 4/28/2026 500,000 500,000 445,704 0.25% FEDERAL HOME LOAN BANK 1.00% 5/26/2026 500,000 500,000 441,280 0.25% FEDERAL HOME LOAN BANK 1.88% 9/11/2026 400,000 417,280 365,051 0.21% FEDERAL FARM CREDIT BANK SYSTEM ** 4.87% 9/28/2026 500,000 500,000 497,978 0.28% ;�lY�'L�7�[Ur71 SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED SEPTEMBER 30, 2022 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Agency Securities Cont'd FAMCA 1.05% 10/5/2026 500,000 500,000 441,000 0.25% FEDERAL HOME LOAN MORTGAGE CO 0.80% 10/27/2026 500,000 489,350 433,058 0.25% FEDERAL HOME LOAN BANK 2.03% 2/25/2027 500,000 500,000 450,778 0.26% FEDERAL HOME LOAN BANK 3.50% 4/26/2027 500,000 500,000 473,918 0.27% FEDERAL HOME LOAN BANK 2.20% 4/27/2027 500,000 500,000 483,984 0.27% FEDERAL HOME LOAN BANK ** 4.38% 8/25/2027 500,000 500,400 491,844 0.28% FEDERAL FARM CREDIT BANK SYSTEM 3.45% 6/1/2027 500,000 500,000 476,717 0.27% FIRST CAPITAL BK SC 3.50% 6/30/2027 250,000 250,000 240,229 0.14% Total Agency Securities 12,750,000 12,725,605 11,901,447 6.74% US Treasury Notes Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio UN ITED STATES TREASURY 2.00% 10/31/2022 250,000 243,750 249,848 0.14% LIN ITEDSTATES TREASURY 2.00% 11/30/2022 250,000 243,600 249,522 0.14% UN ITED STATES TREASURY 2.13% 12/31/2022 250,000 244,700 249,151 0.14% LIN ITEDSTATES TREASURY 1.50% 2/28/2023 250,000 237,075 247,686 0.14% UN ITED STATES TREASURY 1.50% 3/31/2023 250,000 236,800 247,061 0.14% LIN ITEDSTATES TREASURY 1.63% 4/30/2023 250,000 238,225 246,553 0.14% UN ITED STATES TREASURY 1.63% 5/31/2023 250,000 236,525 245,977 0.14% LIN ITEDSTATES TREASURY 2.63% 6/30/2023 250,000 247,375 247,412 0.14% UN ITED STATES TREASURY 1.25% 7/31/2023 250,000 231,625 243,955 0.14% LIN ITEDSTATES TREASURY 0.25% 6/15/2024 250,000 245,450 233,545 0.13% UNITED STATES TREASURY 0.38% 9/15/2024 250,000 245,350 231,992 0.13% UNITED STATES TREASURY 1.00% 12/15/2024 250,000 248,925 233,066 0.13% UNITED STATES TREASURY 0.50% 3/31/2025 250,000 244,475 228,125 0.13% UNITED STATES TREASURY 0.25% 6/30/2025 250,000 241,475 224,453 0.13% UNITED STATES TREASURY 0.25% 9/30/2025 250,000 240,475 222,217 0.13% UNITED STATES TREASURY 0.38% 11/30/2025 350,000 345,065 310,365 0.18% UNITED STATES TREASURY 0.38% 12/31/2025 250,000 240,575 221,133 0.13% UNITED STATES TREASURY 0.38% 1/31/2026 350,000 344,435 308,328 0.17% UNITED STATES TREASURY 0.75% 3/31/2026 750,000 741,675 666,152 0.38% UNITED STATES TREASURY 0.75% 5/31/2026 500,000 499,500 441,699 0.25% UNITED STATES TREASURY 0.88% 6/30/2026 250,000 244,025 221,416 0.13% UNITED STATES TREASURY 0.88% 9/30/2026 250,000 243,425 220,029 0.12% UNITED STATES TREASURY 1.25% 12/31/2026 250,000 247,500 222,129 0.13% Total US Treasury Notes 6,700,000 6,532,025 6,211,815 3.52% Corporate Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio GENERAL ELECTRIC CO 2.70% 10/9/2022 250,000 242,525 249,913 0.14% AUSTRALIA & NEW ZEALAND BANKING GROUP NY 2.63% 11/9/2022 250,000 243,450 249,618 0.14% VISA INC 2.80% 12/14/2022 250,000 247,525 249,405 0.14% BANK OF NEW YORK MELLON CORP 2.95% 1/29/2023 100,000 100,070 99,601 0.06% WELLS FARGO NATIONAL BANK WEST 1.90% 1/30/2023 250,000 250,000 248,654 0.14% WELLS FARGO & COMPANY 3.45% 2/13/2023 150,000 152,145 149,418 0.08% UNITED HEALTH GROUP INC 2.75% 2/15/2023 100,000 99,140 99,429 0.06% EXXON MOBIL CORPORATION 2.73% 3/1/2023 250,000 247,050 248,812 0.14% WALMART INC 2.55% 4/11/2023 250,000 244,525 247,744 0.14% APPLE INC 2.40% 5/3/2023 250,000 240,875 247,268 0.14% SOUTHERN CALIFORNIA EDISON 3.40% 6/1/2023 254,000 252,857 250,975 0.14% NEW YORK UNIVERSITY 2.72% 7/1/2023 230,000 234,899 226,190 0.13% ORACLE CORP 3.63% 7/15/2023 250,000 253,425 247,829 0.14% IBM CORP 3.38% 8/1/2023 500,000 492,500 495,994 0.28% GILEAD SCIENCES INC 2.50% 9/1/2023 260,000 249,886 254,593 0.14% PROV ST JOSEPH HEALTH OBL 4.38% 10/1/2023 315,000 340,704 314,315 0.18% PRES & FELLOWS OF HARVAR 2.60% 10/1/2023 300,000 306,750 293,693 0.17% TOYOTA MOTOR CREDIT CORP 2.25% 10/18/2023 250,000 235,225 244,656 0.14% NATIONAL RURAL UTIL COOP 3.40% 11/15/2023 300,000 297,900 295,766 0.17% ALABAMA POWER CO 3.55% 12/1/2023 250,000 249,875 246,399 0.14% CITIGROUP GLOBAL MARKETS ** 4.00% 12/1/2023 500,000 500,000 496,835 0.28% TOYOTA MOTOR CREDIT CORP 3.35% 1/8/2024 400,000 399,280 393,918 0.22% JOHN DEERE CAPITAL CORP 3.45% 1/10/2024 250,000 250,450 246,632 0.14% 3M COMPANY 3.25% 2/14/2024 300,000 314,610 293,804 0.17% BOEING CO 2.80% 3/1/2024 250,000 248,500 241,410 0.14% DETROIT EDISON CO 3.65% 3/15/2024 300,000 318,180 295,523 0.17% BANK OF AMERICA CORP 4.00% 4/1/2024 250,000 261,725 247,360 0.14% HORMEL FOODS CORP 0.65% 6/3/2024 500,000 495,100 467,652 0.26% CATERILLAR FINANCIAL SERVICE 3.30% 6/9/2024 500,000 527,550 489,284 0.28% ;�lY�'L�7�[Ur71 SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED SEPTEMBER 30, 2022 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Corporate Securities Cont'd AMERICAN HONDA FINANCE 0.55% 7/12/2024 400,000 399,080 371,442 0.21% WALT DISNEY COMPANY 1.75% 8/30/2024 500,000 499,300 473,010 0.27% WELLS FARGO & COMPANY 3.30% 9/9/2024 750,000 788,725 723,422 0.41% AMERICAN HONDA FINANCE 2.15% 9/10/2024 500,000 499,550 475,799 0.27% SHELL INTERNATIONAL FIN 2.00% 11/7/2024 500,000 497,650 475,121 0.27% CATERILLAR FINANCIAL SERVICE 3.25% 12/1/2024 500,000 528,700 485,566 0.27% APPLE INC ** 2.50% 2/9/2025 500,000 478,000 477,378 0.27% TOYOTA MOTOR CREDIT CORP 1.80% 2/13/2025 300,000 299,940 280,036 0.16% WESTPAC BANKING CORP 2.35% 2/19/2025 500,000 514,250 473,360 0.27% FLORIDA POWER & LIGHT CO 2.85% 4/1/2025 500,000 499,400 478,445 0.27% BAY AREA CA TOLL AUTH ** 2.33% 4/1/2025 250,000 242,025 236,922 0.13% BMW US CAPITAL LLC ** 3.90% 4/9/2025 400,000 399,880 388,184 0.22% AMAZON.COM INC 0.80% 6/3/2025 500,000 497,950 453,547 0.26% APPLE INC 0.55% 8/20/2025 500,000 492,150 447,977 0.25% JOHNSON & JOHNSON 0.55% 9/1/2025 950,000 944,185 848,381 0.48% NATIONAL RURAL UTIL COOP 1.00% 9/15/2025 500,000 499,250 443,481 0.25% TOYOTA MOTOR CREDIT CORP 0.80% 10/16/2025 500,000 493,650 443,352 0.25% TOYOTA MOTOR CREDIT CORP 0.80% 1/9/2026 500,000 498,800 440,394 0.25% APPLE INC 0.70% 2/8/2026 500,000 492,000 439,942 0.25% PUBLIC STORAGE 0.88% 2/15/2026 300,000 297,720 262,815 0.15% MERCK & CO INC 0.75% 2/24/2026 400,000 398,640 350,784 0.20% BMW US CAPITAL LLC 2.80% 4/11/2026 500,000 495,900 462,865 0.26% BMO HARRIS BANK NA 1.00% 4/13/2026 250,000 250,000 222,695 0.13% AMAZON.COM INC 1.00% 5/12/2026 500,000 498,800 439,391 0.25% CHARLES SCHWAB CORP 1.15% 5/13/2026 500,000 499,500 437,557 0.25% BANK OF AMERICA CORP 1.25% 5/28/2026 500,000 500,000 427,450 0.24% BANK OF AMERICA CORP 1.20% 6/25/2026 500,000 499,300 427,918 0.24% MASS INSTITUTE OF TECH 3.31% 7/1/2026 500,000 532,750 472,596 0.27% TOYOTA FINANCIAL SGS BK 0.95% 7/29/2026 250,000 250,000 220,261 0.12% BANK OF AMERICA CORP 1.15% 9/10/2026 250,000 248,200 210,341 0.12% TEXAS INSTRUMENTS INC 1.13% 9/15/2026 400,000 392,400 350,175 0.20% JPMORGAN CHASE & CO 2.95% 10/1/2026 500,000 534,550 458,449 0.26% PROCTER & GAMBLE CO/THE 1.90% 2/1/2027 350,000 347,270 316,506 0.18% IBM CORP 2.20% 2/9/2027 500,000 475,200 445,068 0.25% PROGRESSIVE CORP 2.50% 3/15/2027 500,000 488,800 451,831 0.26% BEAL BANK - PLANO TX 2.00% 3/3/2027 250,000 250,000 226,207 0.13% NIKE INC 2.75% 3/27/2027 500,000 498,700 459,657 0.26% UNILEVER CAPITAL CORP ** 2.90% 5/5/2027 300,000 288,450 276,211 0.16% CHEVRON CORP 2.00% 5/11/2027 500,000 469,150 443,315 0.25% NSTAR ELECTRIC CO ** 3.20% 5/15/2027 400,000 388,640 371,262 0.21% AMAZON.COM INC 1.20% 6/3/2027 500,000 450,650 427,167 0.24% Total Corporate Securities 26,959,000 26,915,826 25,148,972 14.24% Municipal Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio TX PUB FIN AUTH-A-REF 3.08% 10/1/2022 300,000 300,000 300,000 0.17% SAN FRANCISCO CITY & COUNTY CA 2.40% 11/1/2022 445,000 437,035 444,672 0.25% CALIFORNIA DEPARTMENT OF WATER RESOURCES 2.52% 12/1/2022 75,000 74,243 74,899 0.04% CARSON CA REDEVELOPMENT 3.00% 2/1/2023 80,000 81,000 79,716 0.05% CALIFORNIA HOUSING FINANCE AGENCY 2.88% 2/1/2023 450,000 443,775 449,799 0.25% GEORGIA ST GENERAL OBLIGATION 2.23% 2/1/2023 310,000 299,553 308,508 0.17% FRESNO FING-B REF 3.18% 4/1/2023 285,000 282,236 283,271 0.16% OHIO ST THIRD FRONTIER RESEARCH 2.11% 5/1/2023 250,000 240,275 247,198 0.14% RIVERSIDE CA PENSION OBLIGATION 2.63% 6/1/2023 250,000 243,900 246,875 0.14% SAN DIEGO TOBACCO SETTLEMENT 3.44% 6/1/2023 500,000 500,750 495,865 0.28% SOLANO COMMUNITY COLLEGE DT 2.06% 8/1/2023 145,000 145,000 142,202 0.08% CALIFORNIA VARIOUS PURPOSE 3.50% 8/1/2023 305,000 310,490 303,199 0.17% VISTA REDEV AGENCY-TXBL 3.00% 9/1/2023 290,000 300,643 285,621 0.16% CENTRAL CONTRA COSTA SANITATION DISTRICT 3.12% 9/1/2023 415,000 417,283 410,474 0.23% CALIFORNIA STATE MUNI TAX 2.25% 10/1/2023 250,000 239,750 245,635 0.14% TX PUB FIN AUTH-A-REF 5.08% 10/1/2023 300,000 300,000 289,593 0.16% NATIONAL SECS CLEARING 4.00% 12/7/2023 500,000 498,850 475,785 0.27% OAKLAND PENSION-TXBL 4.35% 12/15/2023 400,000 440,880 398,887 0.23% RIVERSIDE CA UNIFIED SCHOOL DIST 1.98% 2/1/2024 400,000 400,000 388,502 0.22% NATIONAL RURAL UTIL COOP 3.50% 2/8/2024 300,000 297,090 282,974 0.16% CALIFORNIAST-TXBL-B 3.00% 4/1/2024 200,000 213,180 196,362 0.11% CORTE MADERA-TXBL-REF 2.75% 5/1/2024 150,000 150,300 146,187 0.08% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED SEPTEMBER 30, 2022 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Municipal Securities Cont'd TULARE COUNTY BRD ED-TXBL 2.31% 5/1/2024 235,000 236,528 226,683 0.13% UNIV OF CALIFORNIA -BF 0.83% 5/15/2024 120,000 120,216 113,499 0.06% CHAFFEY COMMUNITY COLLEGE DT 1.72% 6/1/2024 480,000 477,168 458,767 0.26% ORANGE-TXBL-REF 5.87% 6/1/2024 400,000 394,320 374,561 0.21% RIVERSIDE CO PUB FIN 1.92% 7/1/2024 300,000 300,000 286,326 0.16% LOMPOC VALLEY MED-TXBL 2.07% 7/1/2024 110,000 110,869 105,307 0.06% ANAHEIM PUBLIC FIN 0.63% 7/1/2024 250,000 245,500 233,180 0.13% SAN FRANCISCO CITY 3.76% 8/1/2024 250,000 270,675 245,393 0.14% TAMALPAIS UN HSD-TXBL 2.02% 8/1/2024 150,000 151,770 143,971 0.08% TENNESSEE-C-REF-TXBL 1.97% 8/1/2024 170,000 171,751 162,832 0.09% CONTRA COSTA CA COMNTY 1.77% 8/1/2024 250,000 250,000 238,122 0.13% MINNESOTA ST-C-TXBL 3.00% 8/1/2024 215,000 227,857 210,195 0.12% SOLANO COMMUNITY COLLEGE DT 2.16% 8/1/2024 300,000 300,000 287,119 0.16% SAN FRANCISCO REDEV-C 3.13% 8/1/2024 500,000 524,000 485,815 0.28% MT SAN ANTONIO CCD 1.94% 8/1/2024 400,000 404,080 382,819 0.22% MD ST -B 0.46% 8/1/2024 300,000 300,000 280,413 0.16% SANTA CLARA CO-B-TXBL 2.00% 8/1/2024 475,000 467,543 455,573 0.26% ORANGE COUNTY CA WATER DIST 1.94% 8/15/2024 200,000 200,080 191,106 0.11% W SACRAMENTO AREA 2.07% 9/1/2024 150,000 150,000 143,048 0.08% ESCONDIDO JT POWERS 2.19% 9/1/2024 380,000 383,192 362,957 0.21% HAWAII ST -GB 0.80% 10/1/2024 125,000 124,938 116,273 0.07% CARMICHAEL WATER DIST 2.17% 11/1/2024 1,295,000 1,304,065 1,233,741 0.70% INDIO PUB FIN-B-TXBL 3.35% 11/1/2024 180,000 190,350 173,477 0.10% VENTURA COUNTY CA PUBLIC 1.22% 11/1/2024 100,000 100,000 93,194 0.05% SEMITROPIC IMP DIST-A 2.36% 12/1/2024 140,000 141,694 133,585 0.08% CON EDISON CO OF NY INC 3.30% 12/1/2024 310,000 330,646 299,467 0.17% CARSON -TXBL-REV 1.88% 1/15/2025 505,000 516,817 472,318 0.27% SAN RAMON REDEV AGY 4.00% 2/1/2025 140,000 155,834 137,623 0.08% CALIFORNIA ST MUNI FI ** 1.67% 2/1/2025 300,000 281,760 280,002 0.16% CALIFORNIA-TXBL 3.38% 4/1/2025 315,000 340,200 306,300 0.17% STANISLAUS CONSOL FIR 1.25% 4/1/2025 235,000 236,998 215,863 0.12% SAN DIEGO CNTY CA REG 2.09% 4/1/2025 350,000 366,485 329,655 0.19% YALE UNIVERSITY 0.87% 4/15/2025 1,075,000 1,068,316 984,664 0.56% MONTEREY PK TXBL 0.89% 6/1/2025 400,000 399,800 361,916 0.20% GOLDEN ST TOBACCO -B 1.40% 6/1/2025 300,000 300,000 272,344 0.15% LAKEPORT-REV-TXBL 1.18% 6/1/2025 155,000 155,233 141,400 0.08% ANAHEIM PUBLIC FIN 0.94% 7/1/2025 250,000 249,400 224,893 0.13% UNIVCA-AX-TXBL 3.06% 7/1/2025 1,150,000 1,242,765 1,104,212 0.63% SAN RAMON-TXBL 1.20% 7/1/2025 500,000 497,250 453,138 0.26% FOOTHILL DE ANZA-B 0.91% 8/1/2025 500,000 504,600 452,416 0.26% SANTA ROSA ELEM SD 1.01% 8/1/2025 500,000 500,000 453,269 0.26% W CONTRA COSTA SD -B 0.94% 8/1/2025 505,000 505,000 453,635 0.26% CASTRO VLY UN IF SCH 1.20% 8/1/2025 500,000 503,100 456,589 0.26% OAK GROVE SD -REF 0.87% 8/1/2025 240,000 240,000 215,438 0.12% BELMONT-REDWOOD-A- 0.88% 8/1/2025 205,000 205,000 184,969 0.10% BELMONT-REDWOOD-B-REF 0.88% 8/1/2025 200,000 200,000 180,457 0.10% SAN BERNARDINO CCD 0.84% 8/1/2025 275,000 275,000 247,653 0.14% BELLFLOWER-TXBL 1.32% 8/1/2025 500,000 500,000 454,496 0.26% KLAMATH & TRI N ITY-B 1.83% 8/1/2025 250,000 250,000 230,849 0.13% COVINA-VLY SD-TXBL ** 1.28% 8/1/2025 410,000 381,915 373,578 0.21% SUTTER HEALTH 1.32% 8/15/2025 750,000 743,175 677,568 0.38% RIO ESD CMNTY FACS DT 1.12% 9/1/2025 380,000 380,000 340,540 0.19% MACMWLTH -E-TXBL-REF 0.70% 11/1/2025 220,000 218,306 195,120 0.11% CALIFORNIA STUNIV-B 0.86% 11/1/2025 100,000 100,000 89,429 0.05% STHRN KERN UNIF SD -B 1.08% 11/1/2025 370,000 370,000 331,235 0.19% VENTURA CNTY CA PUBLI 1.32% 11/1/2025 500,000 496,250 450,882 0.26% SACRAMENTO CNTY CA -B 1.04% 12/1/2025 485,000 471,275 433,538 0.25% BAY AREA CA TOLL AUTH 2.43% 4/1/2026 230,000 245,834 214,077 0.12% CALI FORN IA ST-TXBL-B 2.65% 4/1/2026 500,000 526,650 469,745 0.27% WISCONSIN ST GEN FUND 3.05% 5/1/2026 300,000 329,010 284,826 0.16% NEW JERSEY ST-A-TXBL ** 2.25% 6/1/2026 660,000 630,432 605,286 0.34% SAN FRANCISCO CA CITY 1.10% 6/15/2026 370,000 372,923 323,253 0.18% RED BLUFF-TXBL 1.46% 7/15/2026 350,000 356,965 305,759 0.17% SOCIETE GENERALE 1.35% 7/30/2026 500,000 500,000 500,000 0.28% BELMONT-REDWOOD-B-REF 1.10% 8/1/2026 205,000 205,000 180,047 0.10% SAN BERNARDINO CCD 1.10% 8/1/2026 230,000 230,000 201,616 0.11% ;�lY�'L�7�[Ur71 SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED SEPTEMBER 30, 2022 TYPE OF INVESTMENT Municipal Securities Cont'd BELLFLOWER -TXBL KLAMATH & TRINITY -B SAN FRANCISCO CO-TXBL RIVERSIDE UNIF SD FIN CALIFORNIA ST -TXBL TEXAS ST-REF-TXBL ENTERGY LOUISIANA LLC ** CAST U N I V -D OREGON ST -H -REF CALIFORNIA ST UNIV-B ** LOS ANGELES MUNI -C ** 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 ** DISCOVER BANK ** SANTA ROSA REGL RES ** 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.60% 8/1/2026 465,000 463,512 412,332 0.23% 2.08% 8/1/2026 130,000 130,000 117,613 0.07% 1.76% 9/1/2026 295,000 298,540 262,909 0.15% 1.65% 9/1/2026 750,000 741,825 665,771 0.38% 2.38% 10/1/2026 515,000 534,364 475,610 0.27% 3.42% 10/1/2026 990,000 1,093,653 953,068 0.54% 2.40% 10/1/2026 400,000 375,640 358,930 0.20% 1.14% 11/1/2026 375,000 369,563 327,111 0.19% 1.19% 11/1/2026 115,000 112,309 101,299 0.06% 1.14% 11/1/2026 500,000 447,600 436,222 0.25% 3.32% 11/1/2026 140,000 133,882 132,240 0.07% 1.05% 12/1/2026 500,000 485,500 434,844 0.25% 2.36% 2/15/2027 800,000 809,900 727,314 0.41% 2.96% 2/15/2027 205,000 206,046 187,475 0.11% 1.73% 3/1/2027 195,000 189,345 169,831 0.10% 1.43% 4/1/2027 520,000 478,088 451,037 0.26% 1.40% 4/1/2027 425,000 388,365 370,032 0.21% 1.67% 5/1/2027 250,000 227,350 217,038 0.12% 1.10% 5/15/2027 240,000 207,720 202,152 0.11% 3.04% 5/15/2027 100,000 97,570 92,249 0.05% 3.28% 5/15/2027 500,000 492,550 469,900 0.27% 3.35% 7/20/2027 250,000 250,000 238,510 0.14% 3.07% 8/1/2027 200,000 197,000 188,095 0.11% 39,155,000 39,275,084 36,515,822 20.67% Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio 2.625 1/16/2024 300,000 309,510 293,544 0.17% 0.39% 4/16/2024 500,000 499,900 470,649 0.27% 0.60% 2/28/2025 500,000 496,250 456,080 0.26% 2.05% 3/17/2025 750,000 740,400 707,424 0.40% 0.65% 2/24/2026 500,000 493,900 440,079 0.25% 0.82% 2/27/2026 500,000 501,500 441,159 0.25% 2.13% 4/7/2026 396,000 418,730 367,587 0.21% 0.80% 6/17/2026 500,000 496,750 440,867 0.25% 0.88% 7/15/2026 500,000 500,900 440,550 0.25% 0.82% 9/15/2026 400,000 396,720 347,830 0.20% 0.75% 10/8/2026 250,000 246,000 217,535 0.12% 1.50% 1/13/2027 1,000,000 995,900 894,524 0.51% 6,096,000 6,096,460 5,517,829 3.12% 99,910,000 99,791,700 93,375,347 183,041,334 176, 624, 980 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. 00�-J� x Andrew Keys, Treasurer/Director of Finance Susan Bjork, Budget Manager Nov 3, 2022 Review Date Nov 3, 2022 Review Date 52.87% 100.00% IRS Section 115 Retirement Benefit Trust Funds Public Agency Retirement Services - Pension Stabilization Fund Balanced Strategy Mutual Fund Total Pension Stabilization Fund CaIPERS - California Employer's Retiree Benefit Trust (CERBT) CENT Strategy 2 Total CENT 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 $ 19,026,772 $ 19,026,772 $ 1,940,585 $ 1,940,585 $ 20,967,358 Market Value $ 466,072 $ 466,072 $ 466,072