Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Attachment 1 - FY 2021022 4Q Investment Report
Town of Los Gatos Summary Investment Information June 30, 2022 Weighted Average YTM Portfolio Yield: 1.37%Weighted Average Maturity (days)453 This Month Last Month One year ago Portfolio Balance $72,886,943 $76,336,706 $67,951,235 Benchmarks/ References: Town's Average Yield 1.37%1.27%1.37% LAIF Yield for month 0.86%0.68%0.26% 3 mo. Treasury 1.71%1.08%0.05% 6 mo. Treasury 2.52%1.58%0.06% 2 yr. Treasury 2.96%2.56%0.25% 5 yr. Treasury (most recent)3.04%2.82%0.89% 10 Yr. Treasury 3.02%2.85%1.50% 0 -1 year 30% 1 -2 years30% 2 -3 years25% 3 -5 years 15% Portfolio Maturity Profile Compliance:The Town's investments are in compliance with the Town's investment policy dated September 21, 2021and also in compliance with the requirements of Section 53601 of the California State Code. Based on the information available,the Town has sufficient funds to meet the cash demands for the next six months. Page 1 ATTACHMENT 1 Town of Los Gatos Portfolio Allocation & Treasurer's Fund Balances June 30, 2022 Month YTD Fund Balances - Beginning of Month/Period $76,336,706.30 $67,951,235.09 Receipts 8,110,362.42 72,959,325.89Disbursements(11,560,125.89)(68,023,618.15) Fund Balances - End of Month/Period $72,886,942.83 $72,886,942.83 Portfolio Allocation:% of Portfolio Max. % 0r $ Allowed Per State Law or Policy BNY MM $253,598.98 0.47%20% of Town PortfolioUS Treasury Notes $10,046,915.87 18.77%No Max. on US Treasuries Government Agency Debenture Notes $22,975,336.40 42.93%No Max. on Non-Mortgage Backed Corporate Medium Term Bonds $13,339,223.01 24.92%30% of Town Portfolio Local Agency Investment Fund $6,905,470.30 12.90%$75 M per State Law Subtotal - Investments 53,520,544.56 100.00% Reconciled Demand Deposit Balances 19,366,398.27 Total Treasurer's Fund $72,886,942.83 BNY MM0.47%US Treasury Notes18.77% Government Agency Debenture Notes42.93% Corporate Medium Term Bonds24.9% Local Agency Investment Fund12.9% Portfolio Investment Allocation 0 10000000 20000000 30000000 40000000 50000000 60000000 70000000 80000000 90000000 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Treasurer's Fund Balances page 2 Town of Los Gatos Non-Treasury Restricted Fund BalancesJune 30, 2022 JUNE 22 JUNE 22 JUNE 22BeginningDepositsInterest/Ending Balance Realized Gain/Adj.Earnings Withdrawals Balance Non-Treasury Funds: ` Cert. of Participation 2002 Series A Reserve Fund 686,341.17 92.21$ 686,433.38$ Note 1Cert. Of Participation 2010 Ser A Lease Pymt Fund 0.65 0.65$ Note 1 Cert. of Participation 2002 Lease Payment Fund 0.16 0.16$ Note 1 Cert. of Participation 2010 Series Reserve Fund 1,277,446.68 553.40 1,278,000.08 Note 2 Total Restricted Funds:1,963,788.66$ -$ 645.61$ -$ 1,964,434.27$ CEPPT IRS Section 115 Trust 387,834.74 300,000.00 (11,684.71)0.00 676,150.03 Grand Total COP's and CEPPT Trust 2,351,623.40$ 300,000.00$ (11,039.10)$ -$ 2,640,584.30$ These accounts are not part of the Treasurer's fund balances reported elsewhere in this report, as they are for separate and distinctentities. Note 1: The three original funds for the Certificates of Participation 2002 Series A consist of construction funds which will be expended over the next few years, reserve funds which will guarantee the payment of lease payments, and a third fund for the disbursement of lease payments and initial delivery costs. Note 2: The 2010 COP Funds are all for the Library construction, reserves to guarantee lease payments, and a lease payment fund for the life of the COP issue. The COI fund was closed in September 2010. Note 3: The CEPPT Section IRS Section 115 Trust was established as an irrevocable trust dedicated to accumulate resources to fund the Town's unfunded liabilities related to pension and other p Page 3 Town of Los Gatos Statement of Interest Earned June 30, 2022 Interest by Month July 2021 $57,076.80 August 2021 56,600.18 September 2021 54,523.00 October 2021 54,951.68 November 2021 51,445.84 December 2021 55,030.55 January 2022 51,909.39 February 2022 46,264.19 March 2022 50,912.58 April 20202 52,989.32 May 2022 55,136.41 June 2022 54,366.35 $641,206.29 Page 4 Town of Los Gatos Investment Schedule June 2022 Maturity Yield to Interest Interest Interest DaysDepositParOriginalMarketPurchasedDate or Maturity Received Earned Earned toInstitutionCUSIP #Security Date Value Cost Value Interest Call Date or Call to Date Prior Yrs.Current FY MaturityTreasury91282CAP6US Treasury Note 6/30/2021 1,000,000.00 995,390.63 964,062.50 10/15/2023 0.33%990.44$ -$ 3,260.06$ 472Toyota Motor Credit 89236THA6_1 Corporate Bond 04/12/21 500,000.00 510,580.00 488,839.09 8/25/2023 0.45%5,868.75$ 494.69$ 2,285.61$ 421Toyota Motor Credit 89236THA6 Corporate Bond 1/11/2022 1,100,000.00 1,107,315.00 1,075,446.00 8/25/2023 0.94%1,815.00$ -$ 4,812.29$ 421US Treasury 91282CDD0 US Treasury Note 1/13/2022 1,100,000.00 1,090,675.78 1,063,046.88 10/31/2023 0.85%1,219.27$ -$ 4,286.54$ 488US Treasury 91282CCN9 US Treasury Note 1/13/2022 1,200,000.00 1,188,375.00 1,164,000.00 7/31/2023 0.75%73.37$ -$ 4,153.18$ 396FFCB3133EKMX1Gov. Agency Debenture 8/2/2019 1,000,000.00 1,014,400.00 987,826.09 2/23/2024 1.90%62,625.83$ 36,611.80$ 19,145.14$ 603FFCB3133EMBE1Gov. Agency Debenture 10/8/2020 1,600,000.00 1,598,000.00 1,527,766.56 3/28/2024 0.34%7,053.34$ 3,903.24$ 5,376.16$ 637FFCB3133EMCQ3Gov. Agency Debenture 10/16/2020 2,000,000.00 1,998,000.00 1,933,503.54 10/13/2024 0.31%8,353.33$ 4,295.55$ 6,100.69$ 836BankAmerica Corp 06051GHC6 Corporate Bond 10/9/2020 1,300,000.00 1,366,287.00 1,295,738.43 12/20/2023 0.66%66,279.92$ 13,250.31$ 18,319.56$ 538IBM 459200HG9 Corporate Bond 8/8/2019 1,000,000.00 995,010.00 999,502.94 8/1/2022 2.05%46,510.42$ 38,718.82$ 20,422.50$ 32IBM 459200JY8 Corporate Bond 3/25/2021 1,000,000.00 1,071,040.00 991,990.68 5/15/2024 0.71%34,166.67$ 1,964.86$ 7,393.55$ 685US Treasury 912828R28 US Treasury Note 7/2/2019 500,000.00 497,246.09 494,941.41 4/30/2023 1.77%22,984.04$ 17,663.79$ 8,844.01$ 304 Freddie Mac 3137EAEN5 Gov. Agency Debenture 7/19/2019 2,000,000.00 2,072,358.00 1,995,292.76 6/19/2023 1.79%160,416.67$ 71,285.65$ 36,543.91$ 354FFCB3133EKVF0Gov. Agency Debenture 7/22/2019 1,000,000.00 999,630.00 995,726.02 1/17/2023 1.89%46,614.58$ 36,626.98$ 18,855.92$ 201Treasury912828L57US Treasury Note 7/22/2019 1,200,000.00 1,197,988.40 1,199,810.06 9/30/2022 2.09%56,516.39$ 42,014.96$ 21,629.70$ 92 US Treasury 91282CDA6 Gov. Agency Debenture 1/31/2022 1,100,000.00 1,085,222.44 1,063,734.38 9/30/2023 1.07%445.74$ -$ 4,781.92$ 457US Treasury 91282CAW1 Gov. Agency Debenture 7/15/2021 1,200,000.00 1,199,437.50 1,156,406.26 11/15/2023 0.27%2,502.72$ -$ 3,107.52$ 503American Honda 02665WCZ2 Corporate Bond 11/27/2019 1,000,000.00 1,012,410.01 976,797.19 6/27/2024 2.12%60,733.34$ 33,895.56$ 21,294.11$ 728JP Morgan Chase 46625HJE1 Gov. Agency Debenture 2/11/2020 900,000.00 934,587.00 901,391.06 9/23/2022 1.74%61,912.50$ 22,179.72$ 16,030.88$ 85Honeywell Int'l.438516BW5 Corporate Bond 11/20/2019 1,000,000.00 1,014,660.00 982,084.39 7/15/2024 1.64%50,983.33$ 31,978.44$ 19,850.56$ 746Caterpillar Financial Serv 14913Q2V0 Corporate Bond 2/23/2021 1,000,000.00 1,077,370.00 990,983.47 5/17/2024 0.44%35,150.00$ 1,582.27$ 4,547.46$ 687FNMA3135G0V75Gov. Agency Debenture 10/17/2019 1,100,000.00 1,105,833.30 1,075,146.34 7/2/2024 1.63%42,831.25$ 30,694.63$ 18,012.12$ 733US Bancorp 91159HHV5 Corporate Bond 12/24/2019 1,000,000.00 1,049,040.00 997,723.43 1/5/2024 2.12%71,343.75$ 32,781.93$ 21,598.20$ 554 FHLB 3133834G3 Gov. Agency Debenture 3/11/2021 1,400,000.00 1,460,522.00 1,388,360.26 6/9/2023 0.19%37,022.22$ 854.65$ 2,810.33$ 344FFCB3133EKQA7Gov. Agency Debenture 10/21/2019 1,000,000.00 1,019,780.00 978,930.17 9/10/2024 1.66%49,631.11$ 28,373.17$ 16,757.61$ 803PNC Financial 69349LAM0 Corporate Bond 2/7/2022 1,000,000.00 1,033,470.00 1,002,715.63 1,266.67 6/25/2023 1.49%(1,266.67)$ -$ 5,372.34$ 360 FHLB 3135G05X7 Gov. Agency Debenture 6/10/2022 1,200,000.00 1,102,952.40 1,102,108.69 1,312.50 8/25/2025 3.04%(1,312.50)$ -$ 1,902.68$ 1152Treasury912828ZL7Gov. Agency Debenture 4/12/2022 1,700,000.00 1,583,927.57 1,577,746.10 4/30/2025 2.72%316.99$ -$ 9,611.14$ 1035JP Morgan Chase 46625HJT8 Corporate Bond 9/23/2019 1,400,000.00 1,485,414.00 1,408,666.00 2/1/2024 2.39%127,788.89$ 61,355.87$ 34,667.02$ 581American Honda 02665WDH1 Corporate Bond 2/14/2020 600,000.00 603,756.00 593,717.56 5/10/2023 1.75%28,145.00$ 14,494.97$ 10,539.17$ 314Treasury912828V23US Treasury Note 11/29/2021 1,000,000.00 1,032,933.04 989,296.88 12/31/2023 0.66%13,206.52$ -$ 3,924.44$ 549Treasury91282CBE0_2 Gov. Agency Debenture 10/7/2021 1,000,000.00 994,768.98 957,226.56 1/15/2024 0.36%339.67$ -$ 2,587.41$ 564FHLB3130ALH98Gov. Agency Debenture 2/26/2021 1,000,000.00 997,610.00 959,212.41 2/26/2024 0.33%2,500.00$ 1,119.96$ 3,296.67$ 606Treasury912828M80US Treasury Note 7/22/2019 1,000,000.00 1,006,175.23 998,437.50 11/30/2022 1.81%57,158.47$ 35,281.07$ 18,163.03$ 153Treasury912828U57US Treasury Note 7/31/2019 1,000,000.00 1,011,875.00 988,515.62 11/30/2023 1.84%60,208.33$ 35,502.32$ 18,511.92$ 518Treasury912828X70US Treasury Note 12/30/2019 1,000,000.00 1,010,589.29 982,539.06 4/30/2024 1.75%51,703.30$ 29,364.36$ 19,558.38$ 670Treasury912828XT2US Treasury Note 10/31/2019 1,000,000.00 1,015,667.41 981,914.06 5/31/2024 1.64%51,639.34$ 27,624.64$ 16,583.87$ 701 American Honda 02665WCQ2 Corporate Bond 9/14/2021 950,000.00 1,012,871.00 952,517.20 10/10/2023 0.41%19,705.90$ -$ 3,232.93$ 467FFCB3133EJ3Q0Gov. Agency Debenture 8/28/2019 1,500,000.00 1,587,503.75 1,500,018.51 12/21/2023 2.12%121,348.96$ 42,086.02$ 22,859.22$ 539Freddie Mac 3133EKKT2 Gov. Agency Debenture 6/24/2019 1,550,000.00 1,573,188.00 1,547,845.70 2/8/2023 1.82%100,168.75$ 57,521.06$ 28,487.36$ 223 Treasury 91282CBE0 Gov. Agency Debenture 9/15/2021 650,000.00 647,615.46 622,197.26 1/15/2024 0.28%269.37$ -$ 1,447.14$ 564 Subtotal 45,750,000.00$ 46,361,475.28$ 44,853,724.65$ 2,579.17$ 1,565,964.30$ 753,521.26$ 510,964.25$ BNY MM Money Market 253,598.98 253,598.98 0.00%1LAIFState Investment Pool 6,905,470.30 6,905,470.30 0.86%29,469.56 1 $53,520,544.56 $52,012,793.93 1,565,964.30$ 753,521.26$ 540,433.81$ Matured AssetsUS Treasury 912828Y20 Gov. Agency Debenture 1/31/2020 1,000,000.00 1,016,601.56 7/15/2021 1.47%38,221.16$ 20,977.00$ 609.80$ Wells Fargo 94988J6A0 Corporate Bond 6/24/2020 1,350,000.00 1,370,749.50 9/9/2021 0.80%46,023.53$ 10,139.92$ 1,940.52$ FNMA 3135G0Q89 Gov. Agency Debenture 2/10/2020 1,000,000.00 998,702.00 10/7/2021 1.38%22,802.08$ 20,147.24$ 3,941.85$ FHLB 3130AABG2 US Treasury Note 4/15/2019 1,000,000.00 988,250.00 11/29/2021 2.34%49,166.67$ 51,343.12$ 9,670.58$ Toyota Motor Credit 89236TDP7 Corporate Bond 05/20/19 1,100,000.00 1,102,596.00 1/11/2022 2.50%75,551.67$ 58,418.45$ 14,755.96$ Freddie Mac 3137EADB2 Gov. Agency Debenture 1/17/2020 2,100,000.00 2,132,039.70 1/13/2022 2.12%99,195.84$ 49,063.54$ 18,236.83$ American Express Credit Corp.0258M0EG0 Corporate Bond 4/5/2021 1,000,000.00 1,020,330.00 1/31/2022 0.46%24,600.00$ 553.07$ 1,382.68$ PNC Financial 693476BN2 Corporate Bond 8/15/2019 1,000,000.00 1,029,280.00 2/6/2022 2.12%84,608.33$ 39,793.76$ 12,838.57$ FNMA 3135G0V59 Gov. Agency Debenture 11/27/2019 1,540,000.00 1,562,924.44 4/12/2022 1.61%82,293.75$ 39,792.92$ 19,588.25$ FHLB 313379Q69 Gov. Agency Debenture 7/22/2019 1,000,000.00 1,006,960.00 6/10/2022 1.87%61,270.83$ 36,595.58$ 17,807.44$ 0 Total Investments "Matured"100,772.47$ Total Interest FY 20_21 Matured and Current 641,206.29$ Maturity Profile Amount0-1 year $19,533,000.001-2 years $25,149,981.28 2-3 years $7,734,610.883-5 years 1,102,952.40$ $53,520,544.56 AmortizedInstitution Cost BNY Assets $46,361,475.28 BNY MM 253,598.98LAIF6,905,470.30Totals:$53,520,544.56 Market to Cost Position Report Page 5 Town of Los Gatos Summary Investment Information May 31, 2022 Weighted Average YTM Portfolio Yield: 1.27%Weighted Average Maturity (days)453 This Month Last Month One year ago Portfolio Balance $76,336,706 $76,134,869 $64,959,658 Benchmarks/ References: Town's Average Yield 1.27%1.27%1.40% LAIF Yield for month 0.68%0.52%0.32% 3 mo. Treasury 1.08%0.85%0.02% 6 mo. Treasury 1.58%1.41%0.04% 2 yr. Treasury 2.56%2.72%0.15% 5 yr. Treasury (most recent)2.82%2.96%0.80% 10 Yr. Treasury 2.85%2.94%1.60% 0 -1 year 30% 1 -2 years30% 2 -3 years25% 3 -5 years 15% Portfolio Maturity Profile Compliance:The Town's investments are in compliance with the Town's investment policy dated September 21, 2021and also in compliance with the requirements of Section 53601 of the California State Code. Based on the information available,the Town has sufficient funds to meet the cash demands for the next six months. Page 1 Town of Los Gatos Portfolio Allocation & Treasurer's Fund Balances May 31, 2022 Month YTD Fund Balances - Beginning of Month/Period $76,134,869.43 $67,951,235.09 Receipts 3,443,254.21 64,848,963.47Disbursements(3,241,417.34)(56,463,492.26) Fund Balances - End of Month/Period $76,336,706.30 $76,336,706.30 Portfolio Allocation:% of Portfolio Max. % 0r $ Allowed Per State Law or Policy BNY MM $240,447.60 0.45%20% of Town PortfolioUS Treasury Notes $10,046,915.87 18.81%No Max. on US Treasuries Government Agency Debenture Notes $22,879,344.00 42.84%No Max. on Non-Mortgage Backed Corporate Medium Term Bonds $13,339,223.01 24.97%30% of Town Portfolio Local Agency Investment Fund $6,905,470.30 12.93%$75 M per State Law Subtotal - Investments 53,411,400.78 100.00% Reconciled Demand Deposit Balances 22,925,305.52 Total Treasurer's Fund $76,336,706.30 BNY MM0.45%US Treasury Notes18.81% Government Agency Debenture Notes42.84% Corporate Medium Term Bonds25.0% Local Agency Investment Fund12.9% Portfolio Investment Allocation 0 10000000 20000000 30000000 40000000 50000000 60000000 70000000 80000000 90000000 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Treasurer's Fund Balances page 2 Town of Los Gatos Non-Treasury Restricted Fund BalancesMay 31, 2022 MAY 22 MAY 22 MAY 22BeginningDepositsInterest/Ending Balance Realized Gain/Adj.Earnings Withdrawals Balance Non-Treasury Funds: ` Cert. of Participation 2002 Series A Reserve Fund 686,335.47 5.70$ 686,341.17$ Note 1Cert. Of Participation 2010 Ser A Lease Pymt Fund 0.65 0.65$ Note 1 Cert. of Participation 2002 Lease Payment Fund 0.16 0.16$ Note 1 Cert. of Participation 2010 Series Reserve Fund 1,277,223.26 223.42 1,277,446.68 Note 2 Total Restricted Funds:1,963,559.54$ -$ 229.12$ -$ 1,963,788.66$ CEPPT IRS Section 115 Trust 387,511.56 0.00 323.18 0.00 387,834.74 Grand Total COP's and CEPPT Trust 2,351,071.10$ -$ 552.30$ -$ 2,351,623.40$ These accounts are not part of the Treasurer's fund balances reported elsewhere in this report, as they are for separate and distinctentities. Note 1: The three original funds for the Certificates of Participation 2002 Series A consist of construction funds which will be expended over the next few years, reserve funds which will guarantee the payment of lease payments, and a third fund for the disbursement of lease payments and initial delivery costs. Note 2: The 2010 COP Funds are all for the Library construction, reserves to guarantee lease payments, and a lease payment fund for the life of the COP issue. The COI fund was closed in September 2010. Note 3: The CEPPT Section IRS Section 115 Trust was established as an irrevocable trust dedicated to accumulate resources to fund the Town's unfunded liabilities related to pension and other p Page 3 Town of Los Gatos Statement of Interest Earned May 31, 2022 Interest by Month July 2021 $57,076.80 August 2021 56,600.18 September 2021 54,523.00 October 2021 54,951.68 November 2021 51,445.84 December 2021 55,030.55 January 2022 51,909.39 February 2022 46,264.19 March 2022 50,912.58 April 20202 52,989.32 May 2022 55,136.41 June 2022 $586,839.94 Page 4 Town of Los Gatos Investment Schedule May 2022 Maturity Yield to Interest Interest Interest DaysDepositParOriginalMarketPurchasedDate or Maturity Received Earned Earned toInstitutionCUSIP #Security Date Value Cost Value Interest Call Date or Call to Date Prior Yrs.Current FY MaturityTreasury91282CAP6US Treasury Note 6/30/2021 1,000,000.00 995,390.63 970,781.25 10/15/2023 0.33%990.44$ -$ 2,992.11$ 502Toyota Motor Credit 89236THA6_1 Corporate Bond 04/12/21 500,000.00 510,580.00 493,354.08 8/25/2023 0.45%5,868.75$ 494.69$ 2,097.75$ 451Toyota Motor Credit 89236THA6 Corporate Bond 1/11/2022 1,100,000.00 1,107,315.00 1,085,378.98 8/25/2023 0.94%1,815.00$ -$ 3,963.06$ 451US Treasury 91282CDD0 US Treasury Note 1/13/2022 1,100,000.00 1,090,675.78 1,070,609.38 10/31/2023 0.85%1,219.27$ -$ 3,521.09$ 518US Treasury 91282CCN9 US Treasury Note 1/13/2022 1,200,000.00 1,188,375.00 1,171,312.50 7/31/2023 0.75%73.37$ -$ 3,411.54$ 426FFCB3133EKMX1Gov. Agency Debenture 8/2/2019 1,000,000.00 1,014,400.00 995,364.44 2/23/2024 1.90%62,625.83$ 36,611.80$ 17,571.57$ 633FFCB3133EMBE1Gov. Agency Debenture 10/8/2020 1,600,000.00 1,598,000.00 1,535,626.24 3/28/2024 0.34%7,053.34$ 3,903.24$ 4,934.29$ 667FFCB3133EMCQ3Gov. Agency Debenture 10/16/2020 2,000,000.00 1,998,000.00 1,946,459.72 10/13/2024 0.31%8,353.33$ 4,295.55$ 5,599.26$ 866BankAmerica Corp 06051GHC6 Corporate Bond 10/9/2020 1,300,000.00 1,366,287.00 1,299,666.65 12/20/2023 0.66%46,753.92$ 13,250.31$ 16,813.84$ 568IBM 459200HG9 Corporate Bond 8/8/2019 1,000,000.00 995,010.00 1,000,354.41 8/1/2022 2.05%46,510.42$ 38,718.82$ 18,743.94$ 62IBM 459200JY8 Corporate Bond 3/25/2021 1,000,000.00 1,071,040.00 1,001,526.18 5/15/2024 0.71%34,166.67$ 1,964.86$ 6,785.86$ 715US Treasury 912828R28 US Treasury Note 7/2/2019 500,000.00 497,246.09 497,890.63 4/30/2023 1.77%22,984.04$ 17,663.79$ 8,117.11$ 334 Freddie Mac 3137EAEN5 Gov. Agency Debenture 7/19/2019 2,000,000.00 2,072,358.00 2,012,968.80 6/19/2023 1.79%132,916.67$ 71,285.65$ 33,540.30$ 384FFCB3133EKVF0Gov. Agency Debenture 7/22/2019 1,000,000.00 999,630.00 1,001,768.09 1/17/2023 1.89%46,614.58$ 36,626.98$ 17,306.12$ 231Treasury912828L57US Treasury Note 7/22/2019 1,200,000.00 1,197,988.40 1,201,546.87 9/30/2022 2.09%56,516.39$ 42,014.96$ 19,851.92$ 122 US Treasury 91282CDA6 Gov. Agency Debenture 1/31/2022 1,100,000.00 1,085,222.44 1,071,382.82 9/30/2023 1.07%445.74$ -$ 3,825.54$ 487US Treasury 91282CAW1 Gov. Agency Debenture 7/15/2021 1,200,000.00 1,199,437.50 1,164,656.26 11/15/2023 0.27%2,502.72$ -$ 2,841.16$ 533American Honda 02665WCZ2 Corporate Bond 11/27/2019 1,000,000.00 1,012,410.01 986,274.10 6/27/2024 2.12%60,733.34$ 33,895.56$ 19,543.91$ 758JP Morgan Chase 46625HJE1 Gov. Agency Debenture 2/11/2020 900,000.00 934,587.00 903,801.28 9/23/2022 1.74%61,912.50$ 22,179.72$ 14,713.28$ 115Honeywell Int'l.438516BW5 Corporate Bond 11/20/2019 1,000,000.00 1,014,660.00 989,975.65 7/15/2024 1.64%50,983.33$ 31,978.44$ 18,219.01$ 776Caterpillar Financial Serv 14913Q2V0 Corporate Bond 2/23/2021 1,000,000.00 1,077,370.00 999,248.38 5/17/2024 0.44%35,150.00$ 1,582.27$ 4,173.69$ 717FNMA3135G0V75Gov. Agency Debenture 10/17/2019 1,100,000.00 1,105,833.30 1,082,632.19 7/2/2024 1.63%42,831.25$ 30,694.63$ 16,531.67$ 763US Bancorp 91159HHV5 Corporate Bond 12/24/2019 1,000,000.00 1,049,040.00 1,005,985.55 1/5/2024 2.12%71,343.75$ 32,781.93$ 19,823.01$ 584 FHLB 3133834G3 Gov. Agency Debenture 3/11/2021 1,400,000.00 1,460,522.00 1,398,879.51 6/9/2023 0.19%22,147.22$ 854.65$ 2,579.34$ 374FFCB3133EKQA7Gov. Agency Debenture 10/21/2019 1,000,000.00 1,019,780.00 986,997.83 9/10/2024 1.66%49,631.11$ 28,373.17$ 15,380.28$ 833PNC Financial 69349LAM0 Corporate Bond 2/7/2022 1,000,000.00 1,033,470.00 1,010,744.77 1,266.67 6/25/2023 1.49%(1,266.67)$ -$ 4,245.28$ 390 FHLB 313379Q69 Gov. Agency Debenture 7/22/2019 1,000,000.00 1,006,960.00 1,000,344.94 6/10/2022 1.87%50,645.83$ 36,595.58$ 17,291.28$ 10Treasury912828ZL7Gov. Agency Debenture 4/12/2022 1,700,000.00 1,583,927.57 1,588,371.10 4/30/2025 2.72%316.99$ -$ 5,961.34$ 1065JP Morgan Chase 46625HJT8 Corporate Bond 9/23/2019 1,400,000.00 1,485,414.00 1,422,367.04 2/1/2024 2.39%127,788.89$ 61,355.87$ 31,817.67$ 611American Honda 02665WDH1 Corporate Bond 2/14/2020 600,000.00 603,756.00 597,468.98 5/10/2023 1.75%28,145.00$ 14,494.97$ 9,672.94$ 344Treasury912828V23US Treasury Note 11/29/2021 1,000,000.00 1,032,933.04 998,046.88 12/31/2023 0.66%1,956.52$ -$ 3,371.71$ 579Treasury91282CBE0_2 Gov. Agency Debenture 10/7/2021 1,000,000.00 994,768.98 964,218.75 1/15/2024 0.36%339.67$ -$ 2,295.59$ 594FHLB3130ALH98Gov. Agency Debenture 2/26/2021 1,000,000.00 997,610.00 965,996.38 2/26/2024 0.33%2,500.00$ 1,119.96$ 3,025.71$ 636Treasury912828M80US Treasury Note 7/22/2019 1,000,000.00 1,006,175.23 1,001,953.12 11/30/2022 1.81%57,158.47$ 35,281.07$ 16,670.18$ 183Treasury912828U57US Treasury Note 7/31/2019 1,000,000.00 1,011,875.00 996,914.06 11/30/2023 1.84%60,208.33$ 35,502.32$ 16,990.40$ 548Treasury912828X70US Treasury Note 12/30/2019 1,000,000.00 1,010,589.29 990,625.00 4/30/2024 1.75%51,703.30$ 29,364.36$ 17,950.84$ 700Treasury912828XT2US Treasury Note 10/31/2019 1,000,000.00 1,015,667.41 989,804.69 5/31/2024 1.64%51,639.34$ 27,624.64$ 15,220.81$ 731 American Honda 02665WCQ2 Corporate Bond 9/14/2021 950,000.00 1,012,871.00 959,764.29 10/10/2023 0.41%19,705.90$ -$ 2,897.33$ 497FFCB3133EJ3Q0Gov. Agency Debenture 8/28/2019 1,500,000.00 1,587,503.75 1,513,594.17 12/21/2023 2.12%99,786.46$ 42,086.02$ 20,980.38$ 569Freddie Mac 3133EKKT2 Gov. Agency Debenture 6/24/2019 1,550,000.00 1,573,188.00 1,555,763.52 2/8/2023 1.82%100,168.75$ 57,521.06$ 26,145.94$ 253 Treasury 91282CBE0 Gov. Agency Debenture 9/15/2021 650,000.00 647,615.46 626,742.19 1/15/2024 0.28%269.37$ -$ 1,296.39$ 594 Subtotal 45,550,000.00$ 46,265,482.88$ 45,057,161.67$ 1,266.67$ 1,523,209.13$ 790,116.83$ 478,714.41$ BNY MM Money Market 240,447.60 240,447.60 0.00%1LAIFState Investment Pool 6,905,470.30 6,905,470.30 0.68%25,160.49 1 $53,411,400.78 $52,203,079.57 1,523,209.13$ 790,116.83$ 503,874.90$ Matured AssetsUS Treasury 912828Y20 Gov. Agency Debenture 1/31/2020 1,000,000.00 1,016,601.56 7/15/2021 1.47%38,221.16$ 20,977.00$ 609.80$ Wells Fargo 94988J6A0 Corporate Bond 6/24/2020 1,350,000.00 1,370,749.50 9/9/2021 0.80%46,023.53$ 10,139.92$ 1,940.52$ FNMA 3135G0Q89 Gov. Agency Debenture 2/10/2020 1,000,000.00 998,702.00 10/7/2021 1.38%22,802.08$ 20,147.24$ 3,941.85$ FHLB 3130AABG2 US Treasury Note 4/15/2019 1,000,000.00 988,250.00 11/29/2021 2.34%49,166.67$ 51,343.12$ 9,670.58$ Toyota Motor Credit 89236TDP7 Corporate Bond 05/20/19 1,100,000.00 1,102,596.00 1/11/2022 2.50%75,551.67$ 58,418.45$ 14,755.96$ Freddie Mac 3137EADB2 Gov. Agency Debenture 1/17/2020 2,100,000.00 2,132,039.70 1/13/2022 2.12%99,195.84$ 49,063.54$ 18,236.83$ American Express Credit Corp.0258M0EG0 Corporate Bond 4/5/2021 1,000,000.00 1,020,330.00 1/31/2022 0.46%24,600.00$ 553.07$ 1,382.68$ PNC Financial 693476BN2 Corporate Bond 8/15/2019 1,000,000.00 1,029,280.00 2/6/2022 2.12%84,608.33$ 39,793.76$ 12,838.57$ FNMA 3135G0V59 Gov. Agency Debenture 11/27/2019 1,540,000.00 1,562,924.44 4/12/2022 1.61%82,293.75$ 39,792.92$ 19,588.25$ Total Investments "Matured"82,965.04$ Total Interest FY 20_21 Matured and Current 586,839.94$ Maturity Profile Amount0-1 year $15,960,458.621-2 years $28,700,663.87 2-3 years $8,750,278.293-5 years -$ $53,411,400.78 AmortizedInstitution Cost BNY Assets $46,265,482.88 BNY MM 240,447.60LAIF6,905,470.30Totals:$53,411,400.78 Market to Cost Position Report Page 5 Town of Los Gatos Summary Investment Information April 30, 2022 Weighted Average YTM Portfolio Yield: 1.27%Weighted Average Maturity (days)481 This Month Last Month One year ago Portfolio Balance $76,134,869 $71,616,902 $66,219,351 Benchmarks/ References: Town's Average Yield 1.27%1.16%1.41% LAIF Yield for month 0.52%0.37%0.34% 3 mo. Treasury 0.85%0.51%0.02% 6 mo. Treasury 1.41%1.03%0.04% 2 yr. Treasury 2.72%2.34%0.16% 5 yr. Treasury (most recent)2.96%2.46%0.85% 10 Yr. Treasury 2.94%2.34%1.63% 0 -1 year 30% 1 -2 years30% 2 -3 years25% 3 -5 years 15% Portfolio Maturity Profile Compliance:The Town's investments are in compliance with the Town's investment policy dated September 21, 2021and also in compliance with the requirements of Section 53601 of the California State Code. Based on the information available,the Town has sufficient funds to meet the cash demands for the next six months. Page 1 Town of Los Gatos Portfolio Allocation & Treasurer's Fund Balances April 30, 2022 Month YTD Fund Balances - Beginning of Month/Period $71,616,901.74 $67,951,235.09 Receipts 8,289,913.05 61,405,709.26Disbursements(3,771,945.36)(53,222,074.92) Fund Balances - End of Month/Period $76,134,869.43 $76,134,869.43 Portfolio Allocation:% of Portfolio Max. % 0r $ Allowed Per State Law or Policy BNY MM $153,893.45 0.29%20% of Town PortfolioUS Treasury Notes $10,046,915.87 18.84%No Max. on US Treasuries Government Agency Debenture Notes $22,879,344.00 42.91%No Max. on Non-Mortgage Backed Corporate Medium Term Bonds $13,339,223.01 25.02%30% of Town Portfolio Local Agency Investment Fund $6,905,470.30 12.95%$75 M per State Law Subtotal - Investments 53,324,846.63 100.00% Reconciled Demand Deposit Balances 22,810,022.80 Total Treasurer's Fund $76,134,869.43 BNY MM0.29%US Treasury Notes18.84% Government Agency Debenture Notes 42.91% Corporate Medium Term Bonds25.0% Local Agency Investment Fund12.9% Portfolio Investment Allocation 0 10000000 20000000 30000000 40000000 50000000 60000000 70000000 80000000 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 Treasurer's Fund Balances page 2 Town of Los Gatos Non-Treasury Restricted Fund BalancesApril 30, 2022 APR 22 APR 22 APR 22BeginningDepositsInterest/Ending Balance Realized Gain/Adj.Earnings Withdrawals Balance Non-Treasury Funds: ` Cert. of Participation 2002 Series A Reserve Fund 686,329.58 5.89$ 686,335.47$ Note 1Cert. Of Participation 2010 Ser A Lease Pymt Fund 0.65 0.65$ Note 1 Cert. of Participation 2002 Lease Payment Fund 0.16 0.16$ Note 1 Cert. of Participation 2010 Series Reserve Fund 1,277,148.48 74.78 1,277,223.26 Note 2 Total Restricted Funds:1,963,478.87$ -$ 80.67$ -$ 1,963,559.54$ CEPPT IRS Section 115 Trust 0.00 390,000.00 (2,488.44)0.00 387,511.56 Grand Total COP's and CEPPT Trust 1,963,478.87$ 390,000.00$ (2,407.77)$ -$ 2,351,071.10$ These accounts are not part of the Treasurer's fund balances reported elsewhere in this report, as they are for separate and distinctentities. Note 1: The three original funds for the Certificates of Participation 2002 Series A consist of construction funds which will be expended over the next few years, reserve funds which will guarantee the payment of lease payments, and a third fund for the disbursement of lease payments and initial delivery costs. Note 2: The 2010 COP Funds are all for the Library construction, reserves to guarantee lease payments, and a lease payment fund for the life of the COP issue. The COI fund was closed in September 2010. Note 3: The CEPPT Section IRS Section 115 Trust was established as an irrevocable trust dedicated to accumulate resources to fund the Town's unfunded liabilities related to pension and other p Page 3 Town of Los Gatos Statement of Interest Earned April 30, 2022 Interest by Month July 2021 $57,076.80 August 2021 56,600.18 September 2021 54,523.00 October 2021 54,951.68 November 2021 51,445.84 December 2021 55,030.55 January 2022 51,909.39 February 2022 46,264.19 March 2022 50,912.58 April 20202 52,989.32 May 2022 June 2022 $531,703.53 Page 4 Town of Los Gatos Investment Schedule April 2022 Maturity Yield to Interest Interest Interest DaysDepositParOriginalMarketPurchasedDate or Maturity Received Earned Earned toInstitutionCUSIP #Security Date Value Cost Value Interest Call Date or Call to Date Prior Yrs.Current FY MaturityTreasury91282CAP6US Treasury Note 6/30/2021 1,000,000.00 995,390.63 966,132.81 10/15/2023 0.33%990.44$ -$ 2,715.23$ 533Toyota Motor Credit 89236THA6_1 Corporate Bond 04/12/21 500,000.00 510,580.00 491,172.32 8/25/2023 0.45%5,868.75$ 494.69$ 1,903.63$ 482Toyota Motor Credit 89236THA6 Corporate Bond 1/11/2022 1,100,000.00 1,107,315.00 1,080,579.09 8/25/2023 0.94%1,815.00$ -$ 3,085.53$ 482US Treasury 91282CDD0 US Treasury Note 1/13/2022 1,100,000.00 1,090,675.78 1,065,195.32 10/31/2023 0.85%1,219.27$ -$ 2,730.12$ 549US Treasury 91282CCN9 US Treasury Note 1/13/2022 1,200,000.00 1,188,375.00 1,166,671.87 7/31/2023 0.75%73.37$ -$ 2,645.18$ 457FFCB3133EKMX1Gov. Agency Debenture 8/2/2019 1,000,000.00 1,014,400.00 995,245.79 2/23/2024 1.90%62,625.83$ 36,611.80$ 15,945.54$ 664FFCB3133EMBE1Gov. Agency Debenture 10/8/2020 1,600,000.00 1,598,000.00 1,529,209.34 3/28/2024 0.34%7,053.34$ 3,903.24$ 4,477.68$ 698FFCB3133EMCQ3Gov. Agency Debenture 10/16/2020 2,000,000.00 1,998,000.00 1,939,193.82 10/13/2024 0.31%8,353.33$ 4,295.55$ 5,081.12$ 897BankAmerica Corp 06051GHC6 Corporate Bond 10/9/2020 1,300,000.00 1,366,287.00 1,296,952.06 12/20/2023 0.66%46,753.92$ 13,250.31$ 15,257.94$ 599IBM 459200HG9 Corporate Bond 8/8/2019 1,000,000.00 995,010.00 998,784.83 8/1/2022 2.05%46,510.42$ 38,718.82$ 17,009.42$ 93IBM 459200JY8 Corporate Bond 3/25/2021 1,000,000.00 1,071,040.00 995,199.15 5/15/2024 0.71%19,166.67$ 1,964.86$ 6,157.91$ 746US Treasury 912828R28 US Treasury Note 7/2/2019 500,000.00 497,246.09 497,343.75 4/30/2023 1.77%22,984.04$ 17,663.79$ 7,365.97$ 365 Freddie Mac 3137EAEN5 Gov. Agency Debenture 7/19/2019 2,000,000.00 2,072,358.00 2,009,389.52 6/19/2023 1.79%132,916.67$ 71,285.65$ 30,436.57$ 415FFCB3133EKVF0Gov. Agency Debenture 7/22/2019 1,000,000.00 999,630.00 1,001,799.63 1/17/2023 1.89%46,614.58$ 36,626.98$ 15,704.66$ 262Treasury912828L57US Treasury Note 7/22/2019 1,200,000.00 1,197,988.40 1,202,109.37 9/30/2022 2.09%56,516.39$ 42,014.96$ 18,014.88$ 153 US Treasury 91282CDA6 Gov. Agency Debenture 1/31/2022 1,100,000.00 1,085,222.44 1,066,054.68 9/30/2023 1.07%445.74$ -$ 2,837.27$ 518US Treasury 91282CAW1 Gov. Agency Debenture 7/15/2021 1,200,000.00 1,199,437.50 1,158,515.63 11/15/2023 0.27%1,002.72$ -$ 2,565.92$ 564American Honda 02665WCZ2 Corporate Bond 11/27/2019 1,000,000.00 1,012,410.01 984,225.82 6/27/2024 2.12%60,733.34$ 33,895.56$ 17,735.37$ 789JP Morgan Chase 46625HJE1 Gov. Agency Debenture 2/11/2020 900,000.00 934,587.00 905,157.17 9/23/2022 1.74%61,912.50$ 22,179.72$ 13,351.75$ 146Honeywell Int'l.438516BW5 Corporate Bond 11/20/2019 1,000,000.00 1,014,660.00 987,393.49 7/15/2024 1.64%50,983.33$ 31,978.44$ 16,533.07$ 807Caterpillar Financial Serv 14913Q2V0 Corporate Bond 2/23/2021 1,000,000.00 1,077,370.00 997,013.34 5/17/2024 0.44%20,900.00$ 1,582.27$ 3,787.47$ 748FNMA3135G0V75Gov. Agency Debenture 10/17/2019 1,100,000.00 1,105,833.30 1,077,166.83 7/2/2024 1.63%42,831.25$ 30,694.63$ 15,001.87$ 794US Bancorp 91159HHV5 Corporate Bond 12/24/2019 1,000,000.00 1,049,040.00 1,003,818.76 1/5/2024 2.12%71,343.75$ 32,781.93$ 17,988.64$ 615 FHLB 3133834G3 Gov. Agency Debenture 3/11/2021 1,400,000.00 1,460,522.00 1,397,657.32 6/9/2023 0.19%22,147.22$ 854.65$ 2,340.66$ 405FFCB3133EKQA7Gov. Agency Debenture 10/21/2019 1,000,000.00 1,019,780.00 982,541.48 9/10/2024 1.66%49,631.11$ 28,373.17$ 13,957.03$ 864PNC Financial 69349LAM0 Corporate Bond 2/7/2022 1,000,000.00 1,033,470.00 1,009,129.89 1,266.67 6/25/2023 1.49%(1,266.67)$ -$ 3,080.64$ 421 FHLB 313379Q69 Gov. Agency Debenture 7/22/2019 1,000,000.00 1,006,960.00 1,001,659.44 6/10/2022 1.87%50,645.83$ 36,595.58$ 15,691.19$ 41Treasury912828ZL7Gov. Agency Debenture 4/12/2022 1,700,000.00 1,583,927.57 1,577,812.50 4/30/2025 2.72%316.99$ -$ 2,189.88$ 1096JP Morgan Chase 46625HJT8 Corporate Bond 9/23/2019 1,400,000.00 1,485,414.00 1,419,328.36 2/1/2024 2.39%127,788.89$ 61,355.87$ 28,873.35$ 642American Honda 02665WDH1 Corporate Bond 2/14/2020 600,000.00 603,756.00 595,307.03 5/10/2023 1.75%22,295.00$ 14,494.97$ 8,777.83$ 375Treasury912828V23US Treasury Note 11/29/2021 1,000,000.00 1,032,933.04 994,179.69 12/31/2023 0.66%1,956.52$ -$ 2,800.54$ 610Treasury91282CBE0_2 Gov. Agency Debenture 10/7/2021 1,000,000.00 994,768.98 958,515.62 1/15/2024 0.36%339.67$ -$ 1,994.05$ 625FHLB3130ALH98Gov. Agency Debenture 2/26/2021 1,000,000.00 997,610.00 961,171.45 2/26/2024 0.33%2,500.00$ 1,119.96$ 2,745.72$ 667Treasury912828M80US Treasury Note 7/22/2019 1,000,000.00 1,006,175.23 1,002,304.69 11/30/2022 1.81%47,158.47$ 35,281.07$ 15,127.57$ 214Treasury912828U57US Treasury Note 7/31/2019 1,000,000.00 1,011,875.00 993,320.31 11/30/2023 1.84%49,583.33$ 35,502.32$ 15,418.15$ 579Treasury912828X70US Treasury Note 12/30/2019 1,000,000.00 1,010,589.29 986,210.94 4/30/2024 1.75%51,703.30$ 29,364.36$ 16,289.72$ 731Treasury912828XT2US Treasury Note 10/31/2019 1,000,000.00 1,015,667.41 985,078.12 5/31/2024 1.64%41,639.34$ 27,624.64$ 13,812.32$ 762 American Honda 02665WCQ2 Corporate Bond 9/14/2021 950,000.00 1,012,871.00 957,143.80 10/10/2023 0.41%19,705.90$ -$ 2,550.55$ 528FFCB3133EJ3Q0Gov. Agency Debenture 8/28/2019 1,500,000.00 1,587,503.75 1,510,227.23 12/21/2023 2.12%99,786.46$ 42,086.02$ 19,038.91$ 600Freddie Mac 3133EKKT2 Gov. Agency Debenture 6/24/2019 1,550,000.00 1,573,188.00 1,555,915.02 2/8/2023 1.82%100,168.75$ 57,521.06$ 23,726.46$ 284 Treasury 91282CBE0 Gov. Agency Debenture 9/15/2021 650,000.00 647,615.46 623,035.15 1/15/2024 0.28%269.37$ -$ 1,140.63$ 625 Subtotal 45,550,000.00$ 46,265,482.88$ 44,924,862.43$ 1,266.67$ 1,455,984.13$ 790,116.83$ 427,887.93$ BNY MM Money Market 153,893.45 153,893.45 0.00%1LAIFState Investment Pool 6,905,470.30 6,905,470.30 0.52%20,850.57 1 $53,324,846.63 $51,984,226.18 1,455,984.13$ 790,116.83$ 448,738.50$ Matured AssetsUS Treasury 912828Y20 Gov. Agency Debenture 1/31/2020 1,000,000.00 1,016,601.56 7/15/2021 1.47%38,221.16$ 20,977.00$ 609.80$ Wells Fargo 94988J6A0 Corporate Bond 6/24/2020 1,350,000.00 1,370,749.50 9/9/2021 0.80%46,023.53$ 10,139.92$ 1,940.52$ FNMA 3135G0Q89 Gov. Agency Debenture 2/10/2020 1,000,000.00 998,702.00 10/7/2021 1.38%22,802.08$ 20,147.24$ 3,941.85$ FHLB 3130AABG2 US Treasury Note 4/15/2019 1,000,000.00 988,250.00 11/29/2021 2.34%49,166.67$ 51,343.12$ 9,670.58$ Toyota Motor Credit 89236TDP7 Corporate Bond 5/20/2019 1,100,000.00 1,102,596.00 1/11/2022 2.50%75,551.67$ 58,418.45$ 14,755.96$ Freddie Mac 3137EADB2 Gov. Agency Debenture 1/17/2020 2,100,000.00 2,132,039.70 1/13/2022 2.12%99,195.84$ 49,063.54$ 18,236.83$ American Express Credit Corp.0258M0EG0 Corporate Bond 4/5/2021 1,000,000.00 1,020,330.00 1/31/2022 0.46%24,600.00$ 553.07$ 1,382.68$ PNC Financial 693476BN2 Corporate Bond 8/15/2019 1,000,000.00 1,029,280.00 2/6/2022 2.12%84,608.33$ 39,793.76$ 12,838.57$ FNMA 3135G0V59 Gov. Agency Debenture 11/27/2019 1,540,000.00 1,562,924.44 4/12/2022 1.61%82,293.75$ 39,792.92$ 19,588.25$ Total Investments "Matured"82,965.04$ Total Interest FY 20_21 Matured and Current 531,703.53$ Maturity Profile Amount0-1 year $15,270,148.471-2 years $26,145,420.58 2-3 years $10,325,350.013-5 years 1,583,927.57$ $53,324,846.63 AmortizedInstitution Cost BNY Assets $46,265,482.88 BNY MM 153,893.45LAIF6,905,470.30Totals:$53,324,846.63 Market to Cost Position Report Page 5 Security Description Maturity Date Par/Shares Moody Rating S&P Rating Insight ESG Rating Environment Social Governance IBM CORP 1.875% 01AUG2022 8/1/2022 1,000,000$ A3 A-2 1 2 4 JPMORGAN CHASE & CO 3.25% 23SEP2022 9/23/2022 900,000$ A2 A-3 1 2 4 AMERICAN HONDA FINANCE 1.95% 10MAY2023 5/10/2023 600,000$ A3 A-3 1 3 3 PNC BANK NA 3.8% 25JUL2023 (CALLABLE 25JUN23)7/25/2023 1,000,000$ A3 A-3 2 3 2 TOYOTA MOTOR CREDIT CORP 1.35% 25AUG2023 8/25/2023 1,600,000$ A1 A+3 2 3 5 AMERICAN HONDA FINANCE 3.625% 10OCT2023 10/10/2023 950,000$ A3 A-3 1 3 3 BANK OF AMERICA CORP 3.004% 20DEC2023 (CALLABLE 20DEC22)12/20/2023 1,300,000$ A2 A-3 1 3 3 JPMORGAN CHASE & CO 3.875% 01FEB2024 2/1/2024 1,400,000$ A2 A-3 1 2 4 US BANCORP 3.375% 05FEB2024 (CALLABLE 05JAN24)2/5/2024 1,000,000$ A2 A+3 3 4 3 IBM CORP 3.0% 15MAY2024 5/15/2024 1,000,000$ A3 A-2 1 2 4 CATERPILLAR FIN SERVICES 2.85% 17MAY24 5/17/2024 1,000,000$ A2 A 3 3 2 4 AMERICAN HONDA FINANCE 2.4% 27JUN2024 6/27/2024 1,000,000$ A3 A-3 1 3 3 HONEYWELL INTERNATIONAL 2.3% 15AUG2024 (CALLABLE 15JUL24)8/15/2024 1,000,000$ A2 A 3 3 4 3 Total/Average 13,750,000$ 2.8 1.6 2.8 3.5 *ESG ratings are from 1 to 5, with 1 as the highest rating and 5 as the lowest. All ratings are weighted by industry rankings, based on the importance of the category within the individual industry. Town of Los Gatos Insight ESG Ratings as of June 30, 2022