Attachment #2
Investments Type Par Value Book Value Market Value Coupon Yield % of
Portfolio Maturity
S&P/Moody's
Credit Rating
Days to
Maturity
Federal National Mortgage Association Agency 2,000,000.00$ 2,019,580.00$ 2,000,220.00$ 2.00% 2.77% 0.48% 01/05/22 AA+ 5 John Deere Capital Corp. Corporate 2,000,000.00$ 2,032,420.00$ 2,000,900.00$ 3.20% 0.31% 0.48% 01/10/22 A 10 Federal National Mortgage Association Agency 3,000,000.00$ 3,040,290.00$ 3,001,740.00$ 2.63% 0.08% 0.72% 01/11/22 AA+ 11 Federal Home Loan Mortgage Corporation Agency 2,000,000.00$ 2,024,480.00$ 2,001,300.00$ 2.38% 2.77% 0.48% 01/13/22 AA+ 13 U.S. Treasury Treasury 2,000,000.00$ 2,024,220.00$ 2,004,540.00$ 2.00% 0.07% 0.48% 02/15/22 Aaa 46 U.S. Treasury Treasury 2,000,000.00$ 2,022,340.00$ 2,005,240.00$ 1.75% 0.06% 0.48% 02/28/22 Aaa 59 Federal Home Loan Bank Agency 1,000,000.00$ 1,015,140.00$ 1,004,050.00$ 2.25% 1.98% 0.24% 03/11/22 AA+ 70 Federal Home Loan Bank Agency 2,000,000.00$ 2,030,280.00$ 2,008,100.00$ 2.25% 0.11% 0.48% 03/11/22 AA+ 70 U.S. Treasury Treasury 3,000,000.00$ 3,048,750.00$ 3,013,530.00$ 2.38% 0.06% 0.72% 03/15/22 Aaa 74 U.S. Treasury Treasury 3,000,000.00$ 3,006,570.00$ 3,002,040.00$ 0.38% 0.07% 0.72% 03/31/22 Aaa 90 CA State High Speed Passenger Train Muni 2,000,000.00$ 2,032,980.00$ 2,010,900.00$ 2.37% 2.25% 0.48% 04/01/22 AA- 91 CA State High Speed Passenger Train Muni 3,255,000.00$ 3,308,674.95$ 3,272,739.75$ 2.37% 2.65% 0.79% 04/01/22 AA- 91 CA State High Speed Passenger Train Muni 1,500,000.00$ 1,524,735.00$ 1,508,175.00$ 2.37% 2.60% 0.36% 04/01/22 AA- 91 CA State Muni 2,000,000.00$ 2,032,720.00$ 2,010,320.00$ 2.35% 1.85% 0.48% 04/01/22 AA- 91 Federal National Mortgage Association Agency 2,000,000.00$ 2,027,340.00$ 2,008,080.00$ 1.88% 1.96% 0.48% 04/05/22 AA+ 95 Toyota Motor Credit Corporate 1,551,000.00$ 1,580,624.10$ 1,560,755.79$ 2.65% 2.80% 0.37% 04/12/22 A+ 102 CA State Department Power Muni 2,000,000.00$ 2,030,180.00$ 2,010,520.00$ 2.00% 2.78% 0.48% 05/01/22 AA+ 121 Federal Farm Credit Agency 3,000,000.00$ 3,004,290.00$ 3,001,290.00$ 0.25% 0.14% 0.72% 05/06/22 AA+ 126 U.S. Bank NA Corporate 2,000,000.00$ 2,039,740.00$ 2,014,340.00$ 2.65% 0.94% 0.48% 05/23/22 AA- 143 Federal Farm Credit Agency 1,625,000.00$ 1,647,311.25$ 1,635,822.50$ 1.48% 0.12% 0.39% 06/29/22 AA+ 180 U.S. Bancorp Corporate 2,000,000.00$ 2,051,940.00$ 2,023,700.00$ 2.95% 0.57% 0.49% 07/15/22 A 196 Wells Fargo & Company Corporate 3,000,000.00$ 3,075,090.00$ 3,037,080.00$ 2.63% 1.60% 0.73% 07/22/22 BBB+ 203 Suntrust Bank - Atlanta Corporate 3,000,000.00$ 3,064,890.00$ 3,030,540.00$ 2.45% 0.19% 0.73% 08/01/22 A 213 Federal National Mortgage Association Agency 3,000,000.00$ 3,044,190.00$ 3,022,560.00$ 1.38% 0.16% 0.73% 09/06/22 AA+ 249 JP Morgan Chase Co. Corporate 1,100,000.00$ 1,139,655.00$ 1,122,066.00$ 3.25% 1.92% 0.27% 09/23/22 A- 266 CA State Muni 2,000,000.00$ 2,057,400.00$ 2,030,340.00$ 2.50% 2.78% 0.49% 10/01/22 AA- 274 CA State Muni 2,250,000.00$ 2,314,575.00$ 2,284,132.50$ 2.50% 0.95% 0.55% 10/01/22 AA- 274 Federal National Mortgage Association Agency 2,000,000.00$ 2,046,040.00$ 2,025,360.00$ 2.00% 2.03% 0.49% 10/05/22 AA+ 278 Federal Farm Credit Agency 3,000,000.00$ 3,001,320.00$ 2,998,260.00$ 0.16% 0.16% 0.72% 10/13/22 AA+ 286 Toyota Motor Credit Corporate 3,000,000.00$ 3,004,200.00$ 2,995,620.00$ 0.35% 0.18% 0.72% 10/14/22 A+ 287 Federal Farm Credit Agency 2,000,000.00$ 2,057,080.00$ 2,035,020.00$ 2.33% 2.34% 0.49% 10/18/22 AA+ 291 CA State Muni 3,000,000.00$ 3,111,270.00$ 3,062,160.00$ 3.00% 0.25% 0.74% 11/01/22 AA- 305 Federal Home Loan Bank Agency 2,000,000.00$ 2,066,640.00$ 2,039,600.00$ 2.50% 2.21% 0.49% 12/09/22 AA+ 343 Federal Home Loan Bank Agency 2,000,000.00$ 2,080,920.00$ 2,048,920.00$ 3.00% 2.64% 0.49% 12/09/22 AA+ 343 U.S. Bank NA Corporate 3,000,000.00$ 3,071,970.00$ 3,038,610.00$ 1.95% 1.42% 0.73% 01/09/23 AA- 374 Bank of America Corporate 3,000,000.00$ 3,131,250.00$ 3,082,110.00$ 3.30% 2.00% 0.74% 01/11/23 A- 376 U.S. Treasury Treasury 2,000,000.00$ 2,041,171.88$ 2,021,800.00$ 1.50% 0.09% 0.49% 01/15/23 Aaa 380 U.S. Treasury Treasury 2,000,000.00$ 2,058,515.63$ 2,034,540.00$ 2.00% 0.11% 0.49% 02/15/23 Aaa 411 U.S. Treasury Treasury 2,000,000.00$ 1,997,500.00$ 1,991,800.00$ 0.13% 0.15% 0.48% 02/28/23 Aaa 424 Caterpillar Financial Service Corporate 2,575,000.00$ 2,671,073.25$ 2,630,903.25$ 2.63% 0.55% 0.63% 03/01/23 A 425 Federal Home Loan Bank Agency 2,000,000.00$ 2,077,440.00$ 2,048,480.00$ 2.50% 2.71% 0.49% 03/10/23 AA+ 434 U.S. Treasury Treasury 2,000,000.00$ 2,012,656.25$ 2,000,780.00$ 0.50% 0.11% 0.48% 03/15/23 Aaa 439 Federal Farm Credit Agency 2,000,000.00$ 2,088,020.00$ 2,061,500.00$ 2.70% 2.72% 0.49% 04/11/23 AA+ 466 WalMart Inc. Corporate 1,000,000.00$ 1,036,930.00$ 1,021,960.00$ 2.55% 0.52% 0.25% 04/11/23 AA 466 U.S. Treasury Treasury 2,000,000.00$ 2,004,453.13$ 1,993,280.00$ 0.25% 0.12% 0.48% 04/15/23 Aaa 470 Bank of New York Mellon Corp. Corporate 1,000,000.00$ 1,058,090.00$ 1,035,520.00$ 3.50% 0.55% 0.25% 04/28/23 A 483 U.S. Treasury Treasury 2,000,000.00$ 1,997,656.25$ 1,989,300.00$ 0.13% 0.20% 0.48% 04/30/23 Aaa 485 U.S. Treasury Treasury 2,000,000.00$ 2,050,620.00$ 2,028,820.00$ 1.63% 0.16% 0.49% 04/30/23 Aaa 485 Federal Farm Credit Agency 2,000,000.00$ 2,101,320.00$ 2,071,800.00$ 3.00% 2.73% 0.50% 05/02/23 AA+ 487 U.S. Treasury Treasury 2,000,000.00$ 2,056,260.00$ 2,032,960.00$ 1.75% 0.14% 0.49% 05/15/23 Aaa 500 U.S. Treasury Treasury 2,000,000.00$ 1,997,265.63$ 1,987,580.00$ 0.13% 0.21% 0.48% 05/31/23 Aaa 516 U.S. Treasury Treasury 2,000,000.00$ 2,052,820.00$ 2,030,160.00$ 1.63% 0.18% 0.49% 05/31/23 Aaa 516 Federal Home Loan Bank Agency 2,000,000.00$ 1,994,940.00$ 1,985,760.00$ 0.13% 0.16% 0.48% 06/02/23 AA+ 518 Federal Farm Credit Agency 3,000,000.00$ 2,991,933.00$ 2,990,340.00$ 0.35% 0.54% 0.72% 06/08/23 AA+ 524 U.S. Treasury Treasury 2,000,000.00$ 2,000,160.00$ 1,990,700.00$ 0.25% 0.15% 0.48% 06/15/23 Aaa 531 Federal Home Loan Mortgage Corporation Agency 2,000,000.00$ 2,098,380.00$ 2,062,740.00$ 2.75% 0.16% 0.50% 06/19/23 AA+ 535 Federal Home Loan Mortgage Corporation Agency 3,000,000.00$ 3,099,504.00$ 3,094,110.00$ 2.75% 0.52% 0.74% 06/19/23 AA+ 535 Federal Home Loan Mortgage Corporation Agency 2,965,000.00$ 2,964,940.70$ 2,950,738.35$ 0.25% 0.19% 0.71% 06/26/23 AA+ 542 U.S. Bank NA Corporate 2,000,000.00$ 2,119,420.00$ 2,079,540.00$ 3.40% 1.05% 0.50% 07/24/23 AA- 570 U.S. Treasury Treasury 2,000,000.00$ 1,995,937.50$ 1,984,300.00$ 0.13% 0.24% 0.48% 07/31/23 Aaa 577 CA State Muni 2,940,000.00$ 3,124,220.40$ 3,061,951.20$ 3.40% 3.05% 0.74% 08/01/23 AA- 578 San Diego Community College District Muni 3,375,000.00$ 3,490,492.50$ 3,447,900.00$ 2.00% 0.43% 0.83% 08/01/23 AAA 578 Bank of New York Mellon Corp. Corporate 1,000,000.00$ 1,065,040.00$ 1,041,910.00$ 3.45% 1.87% 0.25% 08/11/23 A 588 Federal Home Loan Mortgage Corporation Agency 2,000,000.00$ 1,999,780.00$ 1,987,020.00$ 0.25% 0.20% 0.48% 08/24/23 AA+ 601 Federal Home Loan Bank Agency 3,000,000.00$ 2,994,399.00$ 2,973,750.00$ 0.13% 0.22% 0.71% 08/28/23 AA+ 605 Federal Home Loan Bank Agency 3,000,000.00$ 2,994,258.00$ 2,970,990.00$ 0.13% 0.22% 0.71% 09/08/23 AA+ 616 Federal Home Loan Bank Agency 2,000,000.00$ 2,090,580.00$ 2,058,460.00$ 2.38% 1.58% 0.49% 09/08/23 AA+ 616 Federal National Mortgage Association Agency 2,000,000.00$ 2,114,000.00$ 2,073,760.00$ 2.88% 2.36% 0.50% 09/12/23 AA+ 620 Federal Farm Credit Agency 2,500,000.00$ 2,494,525.00$ 2,491,250.00$ 0.22% 0.25% 0.60% 09/22/23 AA+ 630 City of Visalia
Investment Report
By Maturity Date
12/31/2021
City of Visalia
Investment Report
By Maturity Date
12/31/2021 (cont.)
U.S. Treasury Treasury 2,000,000.00$ 1,999,687.50$ 1,985,940.00$ 0.25% 0.26% 0.48% 09/30/23 Aaa 638 CA State Muni 2,000,000.00$ 2,082,200.00$ 2,049,980.00$ 2.25% 3.15% 0.49% 10/01/23 AA- 639 CA State Muni 2,500,000.00$ 2,602,750.00$ 2,562,475.00$ 2.25% 1.00% 0.62% 10/01/23 AA- 639 Federal Farm Credit Agency 3,000,000.00$ 2,981,178.00$ 2,979,870.00$ 0.29% 0.64% 0.72% 10/12/23 AA+ 650 Federal Home Loan Mortgage Corporation Agency 3,000,000.00$ 2,980,611.00$ 2,970,330.00$ 0.13% 0.46% 0.71% 10/16/23 AA+ 654 CA State Muni 1,500,000.00$ 1,589,310.00$ 1,558,830.00$ 3.00% 0.35% 0.37% 11/01/23 AA- 670 Bristol-Myers Squibb Co. Corporate 3,000,000.00$ 3,003,600.00$ 2,986,710.00$ 0.54% 0.19% 0.72% 11/13/23 A+ 682 U.S. Treasury Treasury 2,000,000.00$ 1,984,921.88$ 1,983,520.00$ 0.25% 0.65% 0.48% 11/15/23 Aaa 684 Federal Farm Credit Agency 3,000,000.00$ 2,988,627.00$ 2,988,390.00$ 0.55% 0.75% 0.72% 11/24/23 AA+ 693 U.S. Treasury Treasury 2,000,000.00$ 1,993,828.13$ 1,992,340.00$ 0.50% 0.66% 0.48% 11/30/23 Aaa 699 Federal Home Loan Mortgage Corporation Agency 2,000,000.00$ 1,997,680.00$ 1,981,080.00$ 0.25% 0.21% 0.48% 12/04/23 AA+ 703 Federal Home Loan Bank Agency 2,000,000.00$ 2,147,020.00$ 2,101,160.00$ 3.38% 2.68% 0.50% 12/08/23 AA+ 707 U.S. Treasury Treasury 2,000,000.00$ 1,978,593.75$ 1,977,040.00$ 0.13% 0.67% 0.47% 12/15/23 Aaa 714 Federal Home Loan Bank Agency 3,000,000.00$ 2,992,581.00$ 2,992,950.00$ 0.63% 0.75% 0.72% 12/22/23 AA+ 721 U.S. Treasury Treasury 2,000,000.00$ 2,077,812.50$ 2,074,460.00$ 2.63% 0.68% 0.50% 12/31/23 Aaa 730 City of Oakland Muni 3,435,000.00$ 3,496,417.80$ 3,478,899.30$ 1.58% 1.56% 0.84% 01/15/24 AA 745 Bank of America Corporate 3,000,000.00$ 3,266,340.00$ 3,187,350.00$ 4.13% 0.44% 0.77% 01/22/24 A- 752 U.S. Bancorp Corporate 2,500,000.00$ 2,692,025.00$ 2,639,250.00$ 3.70% 1.32% 0.63% 01/30/24 A+ 760 Federal National Mortgage Association Agency 2,000,000.00$ 2,109,620.00$ 2,070,820.00$ 2.50% 1.76% 0.50% 02/05/24 AA+ 766 Federal Farm Credit Agency 2,000,000.00$ 1,992,460.00$ 1,979,180.00$ 0.25% 0.29% 0.48% 02/26/24 AA+ 787 Federal Home Loan Bank Agency 2,000,000.00$ 2,077,400.00$ 2,046,160.00$ 1.88% 1.46% 0.49% 03/08/24 AA+ 798 Federal Farm Credit Agency 2,000,000.00$ 1,993,580.00$ 1,987,560.00$ 0.30% 0.31% 0.48% 03/18/24 AA+ 808 Federal Home Loan Bank Agency 2,000,000.00$ 2,139,740.00$ 2,096,980.00$ 2.88% 1.85% 0.50% 06/14/24 AA+ 896 Toyota Motor Credit Corporate 3,000,000.00$ 2,992,962.00$ 2,954,460.00$ 0.50% 0.59% 0.71% 06/14/24 A+ 896 Federal Home Loan Mortgage Corporation Agency 3,750,000.00$ 3,722,925.00$ 3,707,700.00$ 0.38% 0.38% 0.89% 06/28/24 AA+ 910 Federal National Mortgage Association Agency 2,000,000.00$ 2,079,280.00$ 2,043,820.00$ 1.75% 1.68% 0.49% 07/02/24 AA+ 914 American Honda Finance Corp. Corporate 2,500,000.00$ 2,491,900.00$ 2,467,225.00$ 0.55% 0.71% 0.59% 07/12/24 A- 924 Federal Home Loan Bank Agency 2,000,000.00$ 2,063,460.00$ 2,032,100.00$ 1.50% 1.45% 0.49% 08/15/24 AA+ 958 City of Berkeley Muni 800,000.00$ 864,088.00$ 849,680.00$ 3.50% 1.95% 0.20% 09/01/24 AA+ 975 Federal Home Loan Bank Agency 2,000,000.00$ 2,148,580.00$ 2,101,720.00$ 2.88% 1.64% 0.50% 09/13/24 AA+ 987 Toyota Motor Credit Corporate 3,000,000.00$ 2,965,992.00$ 2,958,870.00$ 0.63% 1.04% 0.71% 09/13/24 A+ 987 Federal National Mortgage Association Agency 3,000,000.00$ 3,076,512.00$ 3,055,800.00$ 1.63% 0.75% 0.73% 10/15/24 AA+ 1019 Bank of New York Mellon Corp. Corporate 3,000,000.00$ 3,143,730.00$ 3,076,890.00$ 2.10% 0.52% 0.74% 10/24/24 A 1028 Federal Home Loan Bank Agency 2,000,000.00$ 2,147,380.00$ 2,103,040.00$ 2.75% 1.48% 0.50% 12/13/24 AA+ 1078 State Street Corp. Corporate 3,000,000.00$ 3,265,230.00$ 3,193,470.00$ 3.30% 0.64% 0.77% 12/16/24 A 1081 Federal National Mortgage Association Agency 2,000,000.00$ 2,070,580.00$ 2,036,160.00$ 1.63% 0.36% 0.49% 01/07/25 AA+ 1103 U.S. Treasury Treasury 2,000,000.00$ 2,054,920.00$ 2,022,820.00$ 1.38% 0.52% 0.49% 01/31/25 Aaa 1127 Federal Home Loan Mortgage Corporation Agency 3,000,000.00$ 3,074,400.00$ 3,043,320.00$ 1.50% 0.74% 0.73% 02/12/25 AA+ 1139 U.S. Treasury Treasury 2,000,000.00$ 2,100,000.00$ 2,060,000.00$ 2.00% 0.52% 0.49% 02/15/25 Aaa 1142 Federal National Mortgage Association Agency 2,000,000.00$ 1,997,540.00$ 1,972,360.00$ 0.63% 0.59% 0.47% 04/22/25 AA+ 1208 Federal Home Loan Bank Agency 2,000,000.00$ 2,008,000.00$ 1,969,900.00$ 0.63% 0.52% 0.47% 06/13/25 AA+ 1260 Federal National Mortgage Association Agency 2,000,000.00$ 1,987,480.00$ 1,960,100.00$ 0.50% 0.46% 0.47% 06/17/25 AA+ 1264 Los Angeles School District Muni 3,345,000.00$ 3,363,966.15$ 3,345,401.40$ 1.25% 1.09% 0.80% 07/01/25 Aa3 1278 JP Morgan Chase Co. Corporate 1,450,000.00$ 1,603,859.50$ 1,569,306.00$ 3.90% 1.07% 0.38% 07/15/25 A- 1292 Federal Home Loan Mortgage Corporation Agency 2,996,000.00$ 2,953,816.32$ 2,919,811.72$ 0.38% 0.46% 0.70% 07/21/25 AA+ 1298 Los Angeles Commty College Muni 5,000,000.00$ 4,964,700.00$ 4,928,000.00$ 0.77% 0.97% 1.18% 08/01/25 AA+ 1309 Federal Home Loan Mortgage Corporation Agency 2,000,000.00$ 1,968,700.00$ 1,945,840.00$ 0.38% 0.44% 0.47% 09/23/25 AA+ 1362 Federal Home Loan Mortgage Corporation Agency 2,000,000.00$ 1,959,600.00$ 1,945,840.00$ 0.38% 0.90% 0.47% 09/23/25 AA+ 1362 Federal Home Loan Mortgage Corporation Agency 2,000,000.00$ 1,978,820.00$ 1,955,660.00$ 0.55% 0.55% 0.47% 09/30/25 AA+ 1369 Procter & Gamble Co. Corporate 3,000,000.00$ 2,982,369.00$ 2,926,770.00$ 0.55% 0.69% 0.70% 10/29/25 AA- 1398 CA State Muni 2,000,000.00$ 2,176,040.00$ 2,136,080.00$ 3.00% 0.70% 0.51% 11/01/25 AA- 1401 Federal National Mortgage Association Agency 2,000,000.00$ 1,976,260.00$ 1,951,360.00$ 0.50% 0.68% 0.47% 11/07/25 AA+ 1407 Federal National Mortgage Association Agency 2,000,000.00$ 1,952,101.62$ 1,951,360.00$ 0.50% 1.13% 0.47% 11/07/25 AA+ 1407 U.S. Bancorp Corporate 3,000,000.00$ 3,399,450.00$ 3,285,450.00$ 3.95% 0.75% 0.79% 11/17/25 A+ 1417 John Deere Capital Corp. Corporate 3,000,000.00$ 2,994,723.00$ 2,909,160.00$ 0.70% 0.74% 0.70% 01/15/26 A 1476 Charles Schwab Corp. Corporate 4,000,000.00$ 3,969,040.00$ 3,900,880.00$ 0.90% 1.04% 0.94% 03/11/26 A 1531 CA State Muni 3,400,000.00$ 3,650,002.00$ 3,598,220.00$ 2.65% 0.97% 0.86% 04/01/26 AA- 1552 Amazon.Com Inc. Corporate 3,000,000.00$ 3,000,600.00$ 2,970,870.00$ 1.00% 1.02% 0.71% 05/12/26 AA 1593 John Deere Capital Corp. Corporate 1,250,000.00$ 1,258,312.50$ 1,228,500.00$ 1.05% 0.91% 0.29% 06/17/26 A 1629 Federal Home Loan Bank Agency 3,000,000.00$ 3,107,400.00$ 3,082,830.00$ 1.88% 1.12% 0.74% 09/11/26 AA+ 1715 Federal National Mortgage Association Agency 2,000,000.00$ 2,061,930.88$ 2,055,020.00$ 1.88% 1.21% 0.49% 09/24/26 AA+ 1728 CA State Muni 3,000,000.00$ 3,192,810.00$ 3,133,890.00$ 2.38% 1.05% 0.75% 10/01/26 AA- 1735 Total Investments 306,062,000.00$ 312,682,840.95$ 309,198,042.76$ 74.2% Other Investments
Local Agency Investment Funds (LAIF) LAIF 70,753,312.04$ 70,753,312.04$ 70,753,312.04$ 0.21% 0.21% 17.0% 12/31/21 N/A - Local Agency Investment Funds (LAIF) - COVID LAIF 14,693,937.28$ 14,693,937.28$ 14,693,937.28$ 0.21% 0.21% 3.5% 12/31/21 N/A - California Asset Management Program (CAMP) CAMP 21,507,140.11$ 21,507,140.11$ 21,507,140.11$ 0.05% 0.05% 5.2% 12/31/21 N/A - Village West Improvement Bond 5,234.19$ 5,234.19$ 5,234.19$ 6.00% 6.00% 0.0% 06/01/22 N/A 152 Orchard Walk West Bond 225,000.00$ 225,000.00$ 225,000.00$ 6.75% 6.75% 0.1% 06/01/26 N/A 1613 Atwood Water Main District Bond 90,199.53$ 90,199.53$ 90,199.53$ 4.00% 4.00% 0.0% 09/02/30 N/A 3167 Laura Water Main District Bond 57,189.36$ 57,189.36$ 57,189.36$ 4.00% 4.00% 0.0% 09/02/30 N/A 3167 Total Other Investments 107,332,012.51$ 107,332,012.51$ 107,332,012.51$ 25.8% Total Portfolio Holdings 413,394,012.51$ 420,014,853.46$ 416,530,055.27$ 0.75% 100.0%