The URL can be used to link to this page

Home My WebLink AboutAgenda Report - September 1, 2021 C-04Cmw4 '- CITY OF LODI AGENDA ITEM COUNCIL COMMUNICATION TM AGENDA TITLE: Accept the Quarterly Investment Report as Required by the City of Lodi Investment Policy MEETING DATE: September 1, 2021 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 53W. The attached Treasurer's Report for the quarter ending June 30, 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: http://www.lQdj.-qov,,196Fin2nce FISCAL IMPACT: FUNDING AVAILABLE Attachment Not applicable. As per attached report. •.r^ a3 Andrew Keys Treasurer APPROVED: S!¢w-x ..: r::AU,1 21.:02115:39 POT 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 MB FINANCIAL BANK NA MERRICK BANK DISCOVER BANK THIRD FEDERAL SAVINGS & LOAN CLEVELAND BMW BANK NORTH AMERICA ENERBANK USA HORIZON BANK NATION ASSN CITI BANK CAPITAL ONE BANK USA NA CAPITAL ONE NA GOLDMAN SACHS BANK USA WELLS FARGO BANK NA 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 OF BARODA MCHENRY SAVINGS BK IL MORGAN STANLEY BANK MORGAN STANLEY PRIVATE BANK CELTIC BANK Total Negotiable Certificates of Deposit CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED JUNE 30, 2021 Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Due on Demand 6,117,405 6,117,405 4.01% Due on Demand 1,097,132 1,097,132 0.72% Due on Demand 58,269,768 58,269,768 38.23% Due on Demand 4,418,508 4,418,508 2.90% Due on Demand 611,798 611,798 0.40% 11/24/2021 250,000 70, 514, 611 70, 514, 611 46.26% Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Due on Demand 10,518,243 10,518,243 6.90% 10,518,243 10,518,243 6.90% Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio 1.00% 11/7/2021 2,000,000 2,000,000 2,000,000 1.31% 2,000,000 2,000,000 2,000,000 1.31% Interest Rate Maturity Date Par Value Cost Par Value Cost Market Value % of Portfolio 2.00% 11/17/2021 250,000 250,000 251,855 0.17% 2.10% 11/17/2021 250,000 250,000 251,950 0.17% 2.15% 11/22/2021 250,000 250,000 252,114 0.17% 2.10% 11/24/2021 250,000 250,000 252,092 0.17% 2.20% 11/29/2021 250,000 250,000 252,269 0.17% 2.55% 1/18/2022 250,000 250,000 253,435 0.17% 2.85% 5/4/2022 250,000 250,000 255,866 0.17% 1.95% 8/23/2022 250,000 250,000 255,275 0.17% 2.40% 11/22/2022 250,000 250,000 257,893 0.17% 2.40% 11/22/2022 250,000 250,000 257,893 0.17% 2.40% 11/22/2022 250,000 250,000 257,893 0.17% 2.40% 11/22/2022 250,000 250,000 257,849 0.17% 2.50% 12/5/2022 250,000 246,700 258,200 0.17% 2.60% 1/19/2023 250,000 250,000 259,429 0.17% 2.65% 1/24/2023 250,000 250,000 259,702 0.17% 2.70% 2/16/2023 250,000 250,000 260,265 0.17% 2.90% 4/10/2023 250,000 250,000 262,028 0.17% 2.95% 5/15/2023 250,000 250,000 262,825 0.17% 3.25% 6/6/2023 250,000 250,000 264,687 0.17% 3.30% 6/30/2023 250,000 250,000 265,360 0.17% 3.30% 7/16/2023 250,000 250,000 265,659 0.17% 3.35% 10/5/2023 250,000 250,000 267,506 0.18% 3.35% 10/10/2023 250,000 250,000 267,639 0.18% 3.55% 11/30/2023 250,000 250,000 269,863 0.18% 2.80% 3/14/2024 250,000 250,000 266,939 0.18% 1.95% 11/29/2024 250,000 250,000 263,387 0.17% 1.90% 11/29/2024 250,000 250,000 262,963 0.17% 1.70% 3/13/2025 250,000 250,000 250,488 0.16% 7,000,000 6,996,700 7,263,326 4.77% Agency Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio FEDERAL NATIONAL MORTGAGE ASSOCIATION 1.25% 8/17/2021 250,000 238,525 250,372 0.16% FEDERAL NATIONAL MORTGAGE ASSOCIATION 2.00% 9/28/2021 250,000 244,100 251,182 0.16% FEDERAL NATIONAL MORTGAGE ASSOCIATION 1.38% 10/7/2021 250,000 238,925 250,872 0.16% FEDERAL HOME LOAN BANK 2.63% 12/10/2021 250,000 248,750 252,820 0.17% FEDERAL NATIONAL MORTGAGE ASSOCIATION 2.00% 1/5/2022 250,000 243,225 252,451 0.17% FEDERAL HOME LOAN BANK 2.63% 3/11/2022 250,000 248,850 254,347 0.17% FEDERAL HOME LOAN BANK 2.62% 5/27/2022 250,000 249,475 255,584 0.17% FEDERAL FARM CREDIT BANK SYSTEM 1.88% 6/1/2022 250,000 242,050 253,993 0.17% FEDERAL NATIONAL MORTGAGE ASSOCIATION 2.00% 8/26/2022 250,000 242,725 255,200 0.17% FEDERAL HOME LOAN BANK 3.13% 9/9/2022 250,000 254,250 258,876 0.17% FEDERAL NATIONAL MORTGAGE ASSOCIATION 2.38% 1/19/2023 250,000 246,300 258,428 0.17% FEDERAL FARM CREDIT BANK SYSTEM 2.65% 3/8/2023 250,000 249,325 260,302 0.17% FEDERAL FARM CREDIT BANK SYSTEM 2.70% 4/11/2023 250,000 249,500 260,974 0.17% FEDERAL HOME LOAN BANK 2.85% 5/8/2023 250,000 250,175 262,144 0.17% FEDERAL AGRICULTURE MORTGAGE CORPORATION 2.90% 7/24/2023 250,000 249,150 263,449 0.17% FREDDIE MAC** 0.60% 10/27/2025 500,000 497,750 495,072 0.32% FEDERAL HOME LOAN BANK** 0.90% 12/26/2025 500,000 499,900 497,667 0.33% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED JUNE 30, 2021 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Agency Securities Cont'd FEDERAL HOME LOAN BANK 1.02% 3/30/2026 500,000 500,000 499,669 0.33% FEDERAL HOME LOAN BANK** 0.85% 3/30/2026 400,000 399,840 399,595 0.26% FEDERAL HOME LOAN BANK** 1.00% 4/15/2026 500,000 500,000 500,180 0.33% FEDERAL HOME LOAN BANK** 1.00% 4/24/2026 500,000 500,000 496,798 0.33% FEDERAL HOME LOAN BANK** 1.20% 4/28/2026 500,000 500,000 500,162 0.33% FEDERAL HOME LOAN BANK** 1.00% 5/26/2026 500,000 500,000 497,965 0.33% FEDERAL HOME LOAN BANK** 1.10% 6/16/2026 500,000 500,000 498,866 0.33% FEDERAL HOME LOAN BANK** 1.05% 6/16/2026 500,000 500,000 498,128 0.33% Total Agency Securities 8,650,000 8,592,815 8,725,095 5.72% US Treasury Notes Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio UNITED STATES TREASURY 1.13% 7/31/2021 250,000 237,925 250,224 0.16% UNITED STATES TREASURY 2.00% 8/31/2021 250,000 244,525 250,810 0.16% UNITED STATES TREASURY 1.13% 9/30/2021 250,000 237,175 250,665 0.16% UNITED STATES TREASURY 2.00% 10/31/2021 250,000 244,125 251,612 0.17% UNITED STATES TREASURY 2.00% 12/31/2021 400,000 394,520 403,828 0.26% UNITED STATES TREASURY 1.50% 1/31/2022 250,000 240,150 252,090 0.17% UNITED STATES TREASURY 1.88% 2/28/2022 250,000 243,375 252,988 0.17% UNITED STATES TREASURY 1.88% 3/31/2022 250,000 243,150 253,340 0.17% UNITED STATES TREASURY 1.75% 5/31/2022 250,000 242,225 253,770 0.17% UNITED STATES TREASURY 1.75% 6/30/2022 250,000 242,075 254,092 0.17% UNITED STATES TREASURY 1.88% 7/31/2022 250,000 243,025 254,766 0.17% UNITED STATES TREASURY 1.63% 8/31/2022 250,000 240,325 254,375 0.17% UNITED STATES TREASURY 1.88% 9/30/2022 250,000 242,675 255,400 0.17% UNITED STATES TREASURY 2.00% 10/31/2022 250,000 243,750 256,152 0.17% UNITED STATES TREASURY 2.00% 11/30/2022 250,000 243,600 256,484 0.17% UNITED STATES TREASURY 2.13% 12/31/2022 250,000 244,700 257,285 0.17% UNITED STATES TREASURY 1.50% 2/28/2023 250,000 237,075 255,400 0.17% UNITED STATES TREASURY 1.50% 3/31/2023 250,000 236,800 255,576 0.17% UNITED STATES TREASURY 1.63% 4/30/2023 250,000 238,225 256,328 0.17% UNITED STATES TREASURY 1.63% 5/31/2023 250,000 236,525 256,592 0.17% UNITED STATES TREASURY 2.63% 6/30/2023 250,000 247,375 261,797 0.17% UNITED STATES TREASURY 1.25% 7/31/2023 250,000 231,625 255,107 0.17% UNITED STATES TREASURY** 0.75% 3/31/2026 500,000 498,300 497,989 0.33% UNITED STATES TREASURY** 0.75% 5/31/2026 500,000 499,500 497,383 0.33% Total US Treasury Notes 6,650,000 6,452,745 6,744,053 4.42% Corporate Securities Interest Rate MaturityDate Par Value Cost Market Value % of Portfolio AMERICAN HONDA FINANCE 1.65% 7/12/2021 250,000 239,425 250,099 0.16% APPLE INC 1.55% 8/4/2021 500,000 485,400 500,038 0.33% MIZUHO FINANCIAL CORPORATION 2.27% 9/13/2021 250,000 240,900 250,954 0.16% BOEING COMPANY 2.35% 10/30/2021 250,000 245,375 251,576 0.17% PFIZER INC 2.20% 12/15/2021 200,000 198,280 201,805 0.13% TOYOTA MOTOR CREDIT CORP 2.60% 1/11/2022 250,000 246,650 253,104 0.17% PACIFICORP 2.95% 2/1/2022 250,000 249,825 252,258 0.17% JOHNSON&JOHNSON 2.25% 3/3/2022 250,000 245,175 253,053 0.17% WELLS FARGO & COMPANY 3.50% 3/8/2022 400,000 413,080 408,906 0.27% TD AMERITRADE HOLDING COMPANY 2.95% 4/1/2022 250,000 247,250 253,991 0.17% ORACLE CORP 2.50% 5/15/2022 100,000 99,200 101,545 0.07% UNITED PARCEL SERVICE 2.35% 5/16/2022 100,000 98,750 101,685 0.07% DEERE & COMPANY 2.60% 6/8/2022 100,000 99,150 101,676 0.07% 3M COMPANY 2.00% 6/26/2022 150,000 144,480 152,675 0.10% TOYOTA MOTOR CREDIT CORPORATION 2.80% 7/13/2022 250,000 246,950 256,623 0.17% PROCTER & GAMBLE COMPANY 2.15% 8/11/2022 250,000 243,150 255,292 0.17% MERCK & CO INC 2.40% 9/15/2022 100,000 98,700 102,017 0.07% 1PMORGAN CHASE & CO 3.25% 9/23/2022 100,000 101,380 103,598 0.07% GENERAL ELECTRIC CO 2.70% 10/9/2022 250,000 242,525 256,856 0.17% MICROSOFT CORP 2.65% 11/3/2022 250,000 247,575 257,162 0.17% AUSTRALIA & NEW ZEALAND BANKING GROUP NY 2.63% 11/9/2022 250,000 243,450 257,988 0.17% VISA INC 2.80% 12/14/2022 250,000 247,525 258,284 0.17% JPMORGAN CHASE & CO 2.97% 1/15/2023 150,000 147,510 152,098 0.10% BANK OF NEW YORK MELLON CORP 2.95% 1/29/2023 100,000 100,070 103,946 0.07% WELLS FARGO NATIONAL BANK WEST 1.90% 1/30/2023 250,000 250,000 256,847 0.17% WELLS FARGO & COMPANY 3.45% 2/13/2023 150,000 152,145 157,242 0.10% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED JUNE 30, 2021 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Corporate Securities Cont'd UNITED HEALTH GROUP INC 2.75% 2/15/2023 100,000 99,140 103,329 0.07% EXXON MOBIL CORPORATION 2.73% 3/1/2023 250,000 247,050 258,819 0.17% WALMART INC 2.55% 4/11/2023 250,000 244,525 259,318 0.17% APPLE INC 2.40% 5/3/2023 250,000 240,875 259,371 0.17% SOUTHERN CALIFORNIA EDISON 3.40% 6/1/2023 254,000 252,857 267,528 0.18% CHEVRON CORPORATION 3.19% 6/24/2023 250,000 249,300 262,453 0.17% NEW YORK UNIVERSITY 2.72% 7/1/2023 230,000 234,899 237,721 0.16% ORACLE CORP 3.63% 7/15/2023 250,000 253,425 265,585 0.17% IBM CORP 3.38% 8/1/2023 500,000 492,500 530,903 0.35% SHELL INTERNATIONAL FIN 3.40% 8/12/2023 250,000 252,275 265,460 0.17% GILEAD SCIENCES INC 2.50% 9/1/2023 260,000 249,886 270,660 0.18% PROV ST JOSEPH HEALTH OBL 4.38% 10/1/2023 315,000 340,704 339,090 0.22% PRES & FELLOWS OF HARVAR 2.60% 10/1/2023 300,000 306,750 311,148 0.20% TOYOTA MOTOR CREDIT CORP 2.25% 10/18/2023 250,000 235,225 260,378 0.17% NATIONAL RURAL UTIL COOP 3.40% 11/15/2023 300,000 297,900 318,539 0.21% ALABAMA POWER CO 3.55% 12/1/2023 250,000 249,875 268,176 0.18% TOYOTA MOTOR CREDIT CORP 3.35% 1/8/2024 400,000 399,280 427,776 0.28% JOHN DEERE CAPITAL CORP 3.45% 1/10/2024 250,000 250,450 268,955 0.18% BP CAP MARKETS AMERICA 3.79% 2/6/2024 500,000 529,500 539,394 0.35% 3M COMPANY 3.25% 2/14/2024 300,000 314,610 321,334 0.21% BOEING CO 2.80% 3/1/2024 250,000 248,500 260,944 0.17% DETROIT EDISON CO 3.65% 3/15/2024 300,000 318,180 321,804 0.21% BANK OF AMERICA CORP 4.00% 4/1/2024 250,000 261,725 272,750 0.18% CATERILLAR FINANCIAL SERVICE 3.30% 6/9/2024 500,000 527,550 538,589 0.35% WALT DISNEY COMPANY 1.75% 8/30/2024 500,000 499,300 517,030 0.34% WELLS FARGO & COMPANY 3.30% 9/9/2024 500,000 264,825 808,661 0.53% AMERICAN HONDA FINANCE 2.15% 9/10/2024 500,000 499,550 522,385 0.34% SHELL INTERNATIONAL FIN 2.00% 11/7/2024 500,000 497,650 519,938 0.34% CATERILLAR FINANCIAL SERVICE 3.25% 12/1/2024 500,000 528,700 545,513 0.36% TOYOTA MOTOR CREDIT CORP 1.80% 2/13/2025 300,000 299,940 309,818 0.20% WESTPAC BANKING CORP 2.35% 2/19/2025 500,000 514,250 525,965 0.35% APPLE INC 0.55% 8/20/2025 500,000 492,150 494,682 0.32% NATIONAL RURAL UTIL COOP** 1.00% 9/15/2025 500,000 499,250 497,539 0.33% TOYOTA MOTOR CREDIT CORP 0.80% 10/16/2025 500,000 493,650 495,740 0.33% TOYOTA MOTOR CREDIT CORP** 0.80% 1/9/2026 500,000 498,800 495,433 0.33% APPLE INC 0.70% 2/8/2026 500,000 492,000 494,481 0.32% PUBLIC STORAGE** 0.88% 2/15/2026 300,000 297,720 297,602 0.20% MERCK & CO INC** 0.75% 2/24/2026 400,000 398,640 397,860 0.26% JP MORGAN CHASE BANK 1.00% 3/26/2026 250,000 250,000 251,773 0.17% BMO HARRIS BANK NA 1.00% 4/13/2026 250,000 250,000 250,689 0.16% AMAZON.COM INC** 1.00% 5/12/2026 500,000 498,800 500,287 0.33% CHARLES SCHWAB CORP** 1.15% 5/13/2026 500,000 499,500 500,370 0.33% BANK OF AMERICA CORP** 1.25% 5/28/2026 500,000 500,000 497,144 0.33% Total Corporate Securities 21,159,000 20,945,626 22,104,253 14.50% Municipal Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio BURBANK-GLENDALE-PASADENA AIPORT AUTHORITY 4.13% 7/1/2021 90,000 94,320 90,000 0.06% MT DIABLO SD -REF -B 5.00% 7/1/2021 600,000 614,820 600,000 0.39% LA MIRADA CA REDEVELOPMENT 2.91% 8/15/2021 250,000 253,200 250,773 0.16% YUBA LEVEE FINANCING AUTHORITY 2.86% 9/1/2021 250,000 252,975 250,809 0.16% SAN DIEGO CA REDEVELOPMENT AGENCY 2.25% 9/1/2021 250,000 246,175 250,854 0.16% ROSEVILLE FINANCE AUTHORITY - ELECTRIC SYSTEM 2.41% 2/1/2022 250,000 246,925 253,020 0.17% POMONA REDEV AGY-REF 3.55% 2/1/2022 275,000 282,123 279,542 0.18% CA ST-TXBL 6.65% 3/1/2022 640,000 349,440 333,781 0.22% STATE OF MARYLAND 2.65% 3/15/2022 300,000 300,480 305,228 0.20% CALIFORNIA EDUCATIONAL FACILITIES AUTHORITY 2.46% 4/1/2022 250,000 246,275 253,496 0.17% CALIFORNIA ST-A-TXBL 2.37% 4/1/2022 500,000 496,950 508,243 0.33% SACRAMENTO CA PUBLIC 3.79% 4/1/2022 175,000 182,000 179,121 0.12% CALIFORNIA STATE DEPT OF WATER RESOURCES 2.00% 5/1/2022 300,000 291,690 304,528 0.20% UNIV OF CALIFORNIA -BC 2.61% 5/15/2022 250,000 250,000 255,156 0.17% FAIRFIELD-REF-TXBL 3.25% 6/1/2022 150,000 154,560 153,820 0.10% TULARE COUNTY CA PENSION OBLIGATION 3.20% 6/1/2022 250,000 250,250 256,295 0.17% ARKANSAS ST AMENDMENT 82 2.84% 7/1/2022 100,000 100,500 102,554 0.07% ADELANTO PUBLIC UTILITIES 3.50% 7/1/2022 240,000 246,936 247,034 0.16% CITY OF LODI SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED JUNE 30, 2021 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio Municipal Securities Cont'd ORANGE COUNTY CA WATER DIST 1.83% 8/15/2022 125,000 124,925 127,118 0.08% OCEANSIDE CA PENSION OBLIGATION 3.84% 8/15/2022 200,000 209,600 207,628 0.14% VISTA CA REDEVELOPMENT 3.00% 9/1/2022 120,000 120,960 123,314 0.08% SAN BERNARDINO COUNTY REDEVELOPMENT 3.25% 9/1/2022 160,000 161,840 164,560 0.11% SAN LEANDRO CA REDEVELOPMENT AGENCY 3.21% 9/1/2022 260,000 260,884 268,089 0.18% SAN FRANCISCO CITY & COUNTY CA 2.40% 11/1/2022 445,000 437,035 457,116 0.30% CALIFORNIA DEPARTMENT OF WATER RESOURCES 2.52% 12/1/2022 75,000 74,243 77,475 0.05% CARSON CA REDEVELOPMENT 3.00% 2/1/2023 80,000 81,000 82,515 0.05% CALIFORNIA HOUSING FINANCE AGENCY 2.88% 2/1/2023 200,000 200,000 464,634 0.30% GEORGIA ST GENERAL OBLIGATION 2.23% 2/1/2023 310,000 299,553 320,025 0.21% FRESNO FING-B REF 3.18% 4/1/2023 285,000 282,236 295,974 0.19% OHIO ST THIRD FRONTIER RESEARCH 2.11% 5/1/2023 250,000 240,275 258,304 0.17% RIVERSIDE CA PENSION OBLIGATION 2.63% 6/1/2023 250,000 243,900 259,388 0.17% SAN DIEGO TOBACCO SETTLEMENT 3.44% 6/1/2023 500,000 500,750 526,172 0.35% INDUSTRY-REF-TXBL 3.00% 7/1/2023 500,000 502,450 500,973 0.33% SOLANO COMMUNITY COLLEGE DT 2.06% 8/1/2023 145,000 145,000 149,283 0.10% CALIFORNIA VARIOUS PURPOSE 3.50% 8/1/2023 305,000 310,490 324,110 0.21% VISTA REDEV AGENCY-TXBL 3.00% 9/1/2023 290,000 300,643 302,749 0.20% CENTRAL CONTRA COSTA SANITATION DISTRICT 3.12% 9/1/2023 415,000 417,283 437,517 0.29% CALIFORNIA STATE MUNI TAX 2.25% 10/1/2023 250,000 239,750 260,275 0.17% OAKLAND PENSION-TXBL 4.35% 12/15/2023 400,000 440,880 434,554 0.29% RIVERSIDE CA UNIFIED SCHOOL DIST 1.98% 2/1/2024 400,000 400,000 414,692 0.27% CORTE MADERA-TXBL-REF 2.75% 5/1/2024 150,000 150,300 154,709 0.10% TULARE COUNTY BIRD ED-TXBL 2.31% 5/1/2024 235,000 236,528 243,981 0.16% CHAFFEY COMMUNITY COLLEGE DT 1.72% 6/1/2024 480,000 477,168 493,643 0.32% RIVERSIDE CO PUB FIN 1.92% 7/1/2024 300,000 300,000 309,043 0.20% LOMPOC VALLEY MED-TXBL 2.07% 7/1/2024 110,000 110,869 113,816 0.07% SAN FRANCISCO CITY 3.76% 8/1/2024 250,000 270,675 272,903 0.18% TAMALPAIS UN HSD-TXBL 2.02% 8/1/2024 150,000 151,770 156,514 0.10% TENNESSEE-C-REF-TXBL 1.97% 8/1/2024 170,000 171,751 176,992 0.12% CONTRA COSTA CA COMNTY 1.77% 8/1/2024 250,000 250,000 259,209 0.17% MINNESOTA ST-C-TXBL 3.00% 8/1/2024 215,000 227,857 230,889 0.15% SOLANO COMMUNITY COLLEGE DT 2.16% 8/1/2024 300,000 300,000 311,263 0.20% SAN FRANCISCO REDEV-C 3.13% 8/1/2024 500,000 524,000 528,302 0.35% MT SAN ANTONIO CCD 1.94% 8/1/2024 400,000 404,080 415,635 0.27% ORANGE COUNTY CA WATER DIST 1.94% 8/15/2024 200,000 200,080 207,273 0.14% W SACRAMENTO AREA 2.07% 9/1/2024 150,000 150,000 155,548 0.10% ESCONDIDO JT POWERS 2.19% 9/1/2024 380,000 383,192 395,623 0.26% CARMICHAEL WATER DIST 2.17% 11/1/2024 1,295,000 1,304,065 1,345,017 0.88% INDIO PUB FIN-B-TXBL 3.35% 11/1/2024 180,000 190,350 189,748 0.12% VENTURA COUNTY CA PUBLIC 1.22% 11/1/2024 100,000 100,000 100,955 0.07% SEMITROPIC IMP DIST-A 2.36% 12/1/2024 140,000 141,694 145,765 0.10% CON EDISON CO OF NY INC 3.30% 12/1/2024 310,000 330,646 333,307 0.22% SAN RAMON REDEV AGY** 4.00% 2/1/2025 140,000 155,834 153,773 0.10% CALIFORNIA-TXBL 3.38% 4/1/2025 315,000 340,200 344,886 0.23% MONTEREY PK TXBL 0.89% 6/1/2025 400,000 399,800 397,888 0.26% ANAHEIM PUBLIC FIN** 0.94% 7/1/2025 250,000 249,400 248,089 0.16% UNIV CA-AX-TXBL** 3.06% 7/1/2025 650,000 707,265 702,633 0.46% FOOTHILL DE ANZA-B** 0.91% 8/1/2025 500,000 504,600 501,324 0.33% SANTA ROSA ELEM SD** 1.01% 8/1/2025 500,000 500,000 499,863 0.33% W CONTRA COSTA SD -B** 0.94% 8/1/2025 505,000 505,000 505,568 0.33% CASTRO VLY UNIF SCH 1.20% 8/1/2025 500,000 503,100 501,992 0.33% OAK GROVE SD -REF** 0.87% 8/1/2025 240,000 240,000 238,919 0.16% RIO ESD CMNTY FACS DT ** 1.12% 9/1/2025 380,000 380,000 378,653 0.25% MACMWLTH -E-TXBL-REF** 0.70% 11/1/2025 220,000 218,306 219,094 0.14% BAY AREA CA TOLL AUTH 2.43% 4/1/2026 230,000 133,663 243,665 0.16% WISCONSIN ST GEN FUND** 3.05% 5/1/2026 300,000 329,010 329,016 0.22% Total Municipal Securities 22,480,000 22,394,516 23,136,221 15.18% Supranational Securities Interest Rate Maturity Date Par Value Cost Market Value % of Portfolio INTERAMER DEV** 0.80% 6/17/2026 500,000 496,750 500,643 0.33% INT BK RECON&D** 0.65% 2/24/2026 500,000 493,900 493,572 0.32% INTL FIN CORP** 2.13% 4/7/2026 396,000 418,730 419,027 0.27% Total Supranational Securities 1,396,000 1,409,380 1,413,242 0.93% CITY OF LODE SUMMARY OF CASH AND INVESTED FUNDS FOR THE QUARTER ENDED JUNE 30, 2021 TYPE OF INVESTMENT Interest Rate Maturity Date Par Value Cost Market Value % Of Portfolio INVESTMENTS SUBTOTAL NOT INCLUDING CASH & EQUIVALENTS TOTAL ALL INVESTM EMS INCLUDING CASH & EQUIVALENTS * End of month hank balances are reflected on this report. "` Investments purchased during this reporting period. 69,335,000 68,791,782 77„366,190 149, 824,635 152,419, 043 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 ClerkLs Office or online at http://wtwf.Iodi.gov/finance/revenue.htmi. And revi Keys ',Aug 23.202115:23 PDT} Andrew Keys, Treasurer/Director of Finance 08/23/2021 Review Date Susan Bjork, Budget Manager 08/23/2021 Review Date 46.84% 100.00% 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,499,725 $ 20,499,725 $ 2,397,238 $ 2,397,238 $ 22,896,963 Market Value $ 1,524,620 $ 1,524,620 $ 1,524,620