Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
03 Attachment 1.Fourth Quarter Investment Report for FY 2019-20 (April through June 2020)
Town of Los Gatos Summary Investment Information June 30, 2020 Weighted Average YTM Portfolio Yield: 1.86%Weighted Average Maturity (days)608 This Month Last Month One year ago Portfolio Balance $72,729,892 $69,817,884 $72,013,634 Benchmarks/ References: Town's Average Yield 1.86%1.87%2.05% LAIF Yield for month 1.22%1.36%2.43% 3 mo. Treasury 0.15%0.15%2.09% 6 mo. Treasury 0.19%0.19%2.10% 2 yr. Treasury 0.15%0.16%1.76% 5 yr. Treasury (most recent)0.29%0.30%1.77% 10 Yr. Treasury 0.66%0.65%2.01% 0 -1 year 30% 1 -2 years 30% 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 3, 2019and 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, 2020 Month YTD Fund Balances - Beginning of Month/Period $69,817,884.22 $72,013,633.77 Receipts 8,584,629.88 52,198,499.88Disbursements(5,672,621.67)(51,482,241.22) Fund Balances - End of Month/Period $72,729,892.43 $72,729,892.43 Portfolio Allocation:% of Portfolio Max. % 0r $ Allowed Per State Law or Policy BNY MM $145,919.90 0.25%20% of Town PortfolioUS Treasury Notes $7,723,416.42 13.11%No Max. on US Treasuries Government Agency Debenture Notes $24,340,417.75 41.32%No Max. on Non-Mortgage Backed Corporate Medium Term Bonds $14,514,839.51 24.64%30% of Town Portfolio Local Agency Investment Fund 12,185,729.51 20.69%$75 M per State Law Subtotal - Investments 58,910,323.09 100.00% Reconciled Demand Deposit Balances 13,819,569.34 Total Treasurer's Fund $72,729,892.43 BNY MM0.25%US Treasury Notes13.11% Government Agency Debenture Notes41.32%Corporate Medium Term Bonds24.6% Local Agency Investment Fund 20.7% Portfolio Investment Allocation 60000000 62000000 64000000 66000000 68000000 70000000 72000000 74000000 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Treasurer's Fund Balances page 2 Town of Los Gatos Non-Treasury Restricted Fund Balances June 30, 2020 JUNE 20 JUNE 20 JUNE 20BeginningDepositsInterest/Ending Balance Realized Gain/Adj.Earnings Withdrawals Balance Non-Treasury Funds: ` Cert. of Participation 2002 Series A Reserve Fund 688,889.20$ 5.89$ 2,638.20$ 686,256.89$ Note 1Cert. Of Participation 2010 Ser A Lease Pymt Fund 732.21 0.05 732.26 Note 1Cert. of Participation 2002 Lease Payment Fund 84.03 2,638.20 2,722.23 Note 1 Cert. of Participation 2010 Series Reserve Fund 1,297,787.28 122.76 0.00 1,297,910.04 Note 2 Total Restricted Funds:1,987,492.72$ $2,638.25 $128.65 $2,638.20 $1,987,621.42 CEPPT IRS Section 115 Trust 272,454.58 393,400.24 4,123.31 669,978.13 PARS IRS Sectioh 115 Trust 3,400.24$ -$ -$ 3,400.24$ (0.00)$ Note 3 Grand Total COP's and PARS Trust 2,263,347.54$ 396,038.49$ 4,251.96$ 6,038.44$ 2,657,599.55$ These accounts are not part of the Treasurer's fund balances reported elsewhere in this report, as they are for separate and distinct entities. 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 paymentsand 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 PARS 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 pos Page 3 Town of Los Gatos Statement of Interest Earned June 30, 2020 Interest by Month July 2019 $103,310.93 August 2019 101,993.86 September 2019 99,668.91 October 2019 100,474.14 November 2019 96,912.19 December 2019 100,785.87 January 2020 97,263.82 February 2020 88,967.87 March 2020 83,480.41 April 2020 95,000.42 May 2020 87,454.01 June 2020 80,477.20 $1,135,789.63 Page 4 Town of Los Gatos Investment Schedule June 2020 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 Maturity Treasury 912828WR7 US Treasury Note 4/2/2019 1,000,000.00 995,625.00 1,019,335.94 6/30/2021 2.33%26,474.45$ 5,656.35$ 23,260.96$ 365Toyota Motor Credit 89236TDP7 Corporate Bond 05/20/19 1,100,000.00 1,102,596.00 1,133,957.18 1/11/2022 2.50%18,351.67$ 3,102.53$ 27,695.80$ 560Toyota Motor Credit 89236TCZ6 Corporate Bond 3/13/2020 500,000.00 504,440.00 505,727.58 4/8/2021 1.06%659.72$ -$ 1,599.24$ 282FFCB3133EKMX1Gov. Agency Debenture 8/2/2019 1,000,000.00 1,014,400.00 1,068,417.95 2/23/2024 1.90%18,025.83$ -$ 17,466.66$ 1333FFCB3133ELVV3Gov. Agency Debenture 4/8/2020 1,600,000.00 1,600,000.00 1,603,034.08 4/8/2022 0.93%-$ -$ 3,456.44$ 647FNMA3133EHYM9Gov. Agency Debenture 9/21/2017 1,300,000.00 1,295,866.00 1,304,284.11 9/14/2020 1.61%48,370.83$ 37,021.86$ 20,942.81$ 76FNMA3136G0AW1Gov. Agency Debenture 12/13/2017 2,000,000.00 2,017,900.00 2,012,739.00 10/16/2020 2.02%110,058.33$ 62,898.65$ 40,817.21$ 108IBM 459200HG9 Corporate Bond 8/8/2019 1,000,000.00 995,010.00 1,029,310.63 8/1/2022 2.05%9,010.42$ -$ 18,296.32$ 762Oracle68389XBL8Corporate Bond 7/8/2019 1,000,000.00 1,008,880.00 1,045,650.20 7/15/2023 2.18%16,466.67$ -$ 21,374.17$ 1110US Treasury 912828R28 US Treasury Note 7/2/2019 500,000.00 497,246.09 520,390.63 4/30/2023 1.77%6,734.04$ -$ 8,819.78$ 1034American Express 0258M0EB1 Corporate Bond 2/11/2020 1,000,000.00 1,007,210.00 1,013,740.91 4/4/2021 1.66%5,250.00$ -$ 6,215.30$ 278Freddie Mac 3137EAEN5 Gov. Agency Debenture 7/19/2019 2,000,000.00 2,072,358.00 2,149,729.32 6/19/2023 1.79%50,416.67$ -$ 34,741.74$ 1084 FFCB 3133EKVF0 Gov. Agency Debenture 7/22/2019 1,000,000.00 999,630.00 1,040,172.28 1/17/2023 1.89%9,114.58$ -$ 17,771.06$ 931Treasury912828L57US Treasury Note 7/22/2019 1,200,000.00 1,197,988.40 1,242,515.63 9/30/2022 2.09%14,516.39$ -$ 20,385.25$ 822Freddie Mac 3137EADB2 Gov. Agency Debenture 1/17/2020 2,100,000.00 2,132,039.70 2,170,007.85 554.16 1/13/2022 2.12%(554.16)$ -$ 15,274.50$ 562 US Treasury 912828Y20 Gov. Agency Debenture 1/31/2020 1,000,000.00 1,016,601.56 1,025,351.56 1,153.84 7/15/2021 1.47%(1,153.84)$ -$ 6,138.62$ 380American Honda 02665WCZ2 Corporate Bond 11/27/2019 1,000,000.00 1,012,410.01 1,051,135.62 6/27/2024 2.12%12,733.34$ -$ 12,601.45$ 1458JP Morgan Chase 46625HJE1 Gov. Agency Debenture 2/11/2020 900,000.00 934,587.00 950,359.76 9/23/2022 1.74%3,412.50$ -$ 6,148.83$ 815Honeywell Int'l.438516BW5 Corporate Bond 11/20/2019 1,000,000.00 1,014,660.00 1,064,024.41 7/15/2024 1.64%4,983.33$ -$ 12,127.88$ 1476Disney254687CK0Corporate Bond 3/4/2020 1,000,000.00 1,029,080.00 1,025,252.90 2,375.00 2/15/2021 1.39%(2,375.00)$ -$ 4,687.49$ 230FNMA3135G0V75Gov. Agency Debenture 10/17/2019 1,100,000.00 1,105,833.30 1,161,310.98 7/2/2024 1.63%4,331.25$ -$ 12,682.51$ 1463US Bancorp 91159HHV5 Corporate Bond 12/24/2019 1,000,000.00 1,049,040.00 1,092,997.90 1/5/2024 2.12%3,843.75$ -$ 11,183.73$ 1284FFCB3133EKCS3Gov. Agency Debenture 3/21/2019 1,400,000.00 1,403,262.00 1,422,334.51 3/11/2021 2.43%34,708.33$ 9,421.68$ 34,141.92$ 254FFCB3133EKQA7Gov. Agency Debenture 10/21/2019 1,000,000.00 1,019,780.00 1,069,667.34 9/10/2024 1.66%8,031.11$ -$ 11,615.55$ 1533PNC Financial 693476BN2 Corporate Bond 8/15/2019 1,000,000.00 1,029,280.00 1,043,147.43 2/6/2022 2.12%18,608.33$ -$ 18,589.78$ 586FHLB313379Q69Gov. Agency Debenture 7/22/2019 1,000,000.00 1,006,960.00 1,035,928.43 6/10/2022 1.87%18,770.83$ -$ 17,755.82$ 710 FNMA 3135G0V59 Gov. Agency Debenture 11/27/2019 1,540,000.00 1,562,924.44 1,596,313.12 4/12/2022 1.61%12,993.75$ -$ 14,793.93$ 651JP Morgan Chase 46625HJT8 Corporate Bond 9/23/2019 1,400,000.00 1,485,414.00 1,552,205.84 2/1/2024 2.39%19,288.89$ -$ 26,688.85$ 1311American Honda 02665WDH1 Corporate Bond 2/14/2020 600,000.00 603,756.00 617,574.13 5/10/2023 1.75%4,745.00$ -$ 3,955.80$ 1044 FHLB 3130AABG2 US Treasury Note 4/15/2019 1,000,000.00 988,250.00 1,024,268.02 11/29/2021 2.34%21,041.67$ 4,835.29$ 23,285.73$ 517FNMA3135G0Q89Gov. Agency Debenture 2/10/2020 1,000,000.00 998,702.00 1,014,980.59 10/7/2021 1.38%2,177.08$ -$ 5,614.15$ 464FNMA3135G0J20Gov. Agency Debenture 2/10/2020 1,000,000.00 998,882.00 1,007,349.96 2/26/2021 1.48%611.11$ -$ 5,724.31$ 241Treasury912828M80US Treasury Note 7/22/2019 1,000,000.00 1,006,175.23 1,044,023.44 11/30/2022 1.81%17,158.47$ -$ 17,118.04$ 883Treasury912828U57US Treasury Note 7/31/2019 1,000,000.00 1,011,875.00 1,065,625.00 11/30/2023 1.84%17,708.33$ -$ 16,990.40$ 1248BankAmerica Corp 06051GGS2 Corporate Bond 4/30/2020 1,300,000.00 1,302,314.00 1,305,289.64 2,437.92 10/1/2020 1.21%(2,437.92)$ -$ 4,141.23$ 93Treasury912828X70US Treasury Note 12/30/2019 1,000,000.00 1,010,589.29 1,068,125.00 4/30/2024 1.75%7,703.30$ -$ 9,805.98$ 1400Treasury912828XT2US Treasury Note 10/31/2019 1,000,000.00 1,015,667.41 1,069,375.00 5/31/2024 1.64%11,639.34$ -$ 11,040.77$ 1431 Wells Fargo 94988J6A0 Corporate Bond 6/24/2020 1,350,000.00 1,370,749.50 1,371,780.29 8,197.87 9/9/2021 0.80%(8,197.87)$ -$ 163.99$ 436FFCB3133EJ3Q0Gov. Agency Debenture 8/28/2019 1,500,000.00 1,587,503.75 1,631,288.09 12/21/2023 2.12%35,098.96$ -$ 19,226.80$ 1269Freddie Mac 3133EKKT2 Gov. Agency Debenture 6/24/2019 1,550,000.00 1,573,188.00 1,628,619.35 2/8/2023 1.82%30,418.75$ 468.29$ 28,565.41$ 953 Subtotal 45,940,000.00$ 46,578,673.68$ 47,797,341.60$ 14,718.79$ 608,738.23$ 123,404.64$ 612,906.19$ BNY MM 145,919.90 145,919.90 0.00%1LAIFN/A 12,185,729.51 12,185,729.51 1.22%123,712.57 1 $58,910,323.09 $60,128,991.01 608,738.23$ 123,404.64$ 736,618.76$ Matured AssetsTreasury 912828WS5 US Treasury Note 5/2/2017 500,000.00 503,339.84 7/1/2019 1.31%17,574.24$ 14,227.74$ 18.03$ Oracle 68389XAG0 Corporate Bond 5/3/2018 1,000,000.00 1,028,370.00 7/8/2019 2.54%59,027.78$ 30,101.79$ 569.30$ FHLB 3130AEU73 Gov. Agency Debenture 8/27/2018 1,000,000.00 999,180.00 7/22/2019 2.46%23,750.00$ 20,741.19$ 1,486.34$ Treasury 912828F39 US Treasury Note 4/17/2018 1,200,000.00 1,190,343.75 7/22/2019 2.32%30,524.59$ 34,452.97$ 1,726.57$ FHLB 313383VN8 Gov. Agency Debenture 5/25/2018 2,000,000.00 1,989,800.00 7/22/2019 2.40%52,000.00$ 53,614.71$ 2,941.46$ FHLMC 3137EAEB1 Gov. Agency Debenture 3/14/2017 2,000,000.00 1,970,180.00 7/19/2019 1.52%41,076.39$ 69,336.96$ 1,572.08$ Treasury 9128282K5 US Treasury Note 7/2/2018 1,000,000.00 989,218.75 7/31/2019 2.39%14,851.52$ 23,607.64$ 2,016.08$ FNMA 3135G0N33 Gov. Agency Debenture 04/17/13 1,000,000.00 981,984.01 8/2/2019 2.17%12,322.92$ 28,416.36$ 1,945.52$ Microsoft 594918BN3 Corporate Bond 8/8/2016 1,000,000.00 999,470.00 8/8/2019 1.12%33,000.00$ 32,335.78$ 1,194.22$ Berkshire Hathaway 084664CK5 Corporate Bond 1/22/2018 1,100,000.00 1,086,305.00 8/15/2019 2.11%22,363.61$ 33,119.10$ 2,907.40$ FNMA 3135G0P49 Gov. Agency Debenture 11/15/2016 1,500,000.00 1,487,505.00 8/28/2019 1.31%41,791.66$ 51,098.17$ 3,150.25$ JP Morgan Chase 48125LRG9 Corporate Bond 3/28/2017 1,400,000.00 1,393,196.00 9/23/2019 1.86%57,429.17$ 58,316.80$ 6,015.69$ FFCB 3133EGYP4 Gov. Agency Debenture 10/28/2016 1,000,000.00 997,507.00 10/17/2019 1.14%31,179.17$ 30,290.27$ 3,386.30$ FFCB 3133EJPU7 Gov. Agency Debenture 6/1/2018 1,000,000.00 1,001,454.00 10/21/2019 2.38%36,511.11$ 25,640.48$ 7,353.74$ Treasury 912828F62 US Treasury Note 6/30/2017 1,000,000.00 1,002,148.44 10/31/2019 1.41%35,013.59$ 28,161.36$ 4,745.00$ American Honda 02665WBZ3 Corporate Bond 4/11/2018 1,000,000.00 990,620.00 11/13/2019 2.61%31,944.44$ 31,567.90$ 9,647.72$ FNMA 3135G0ZY2 Gov. Agency Debenture 12/20/2017 1,550,000.00 1,545,642.95 11/26/2019 1.90%52,441.67$ 44,831.00$ 11,992.49$ Pfizer 717081EB5 Corporate Bond 6/30/2017 1,000,000.00 1,002,280.00 12/15/2019 1.60%41,791.67$ 32,146.55$ 7,398.11$ US Bamcorp 90331HNB5 Corporate Bond 10/19/2018 1,000,000.00 986,540.00 12/24/2019 3.09%25,277.78$ 21,850.15$ 15,226.29$ FNMA 3136G3TW5 Gov. Agency Debenture 7/25/2018 1,000,000.00 980,540.00 12/30/2019 2.54%16,451.39$ 23,363.19$ 12,574.89$ FreddieMac 3137EAEE5 Gov. Agency Debenture 12/20/2017 1,000,000.00 991,200.00 1/17/2020 1.93%31,125.00$ 29,356.90$ 10,593.78$ FreddieMac 3137EAEE5(A)Gov. Agency Debenture 12/18/2018 1,000,000.00 987,160.00 1/17/2020 2.71%16,208.33$ 14,278.83$ 14,794.05$ Treasury 912828H52 US Treasury Note 6/30/2017 1,000,000.00 994,726.56 1/31/2020 1.46%32,320.44$ 29,073.66$ 8,562.79$ JP Morgan Chase 48125LRK0 Corporate Bond 3/4/2019 1,000,000.00 996,520.00 2/1/2020 2.71%23,653.00$ 9,647.87$ 17,660.51$ American Express 0258M0EE5 Corporate Bond 9/15/2017 1,000,000.00 1,007,980.00 3/3/2020 1.87%54,266.67$ 33,568.97$ 12,697.60$ FHLB 3130ACRP1 Gov. Agency Debenture 7/25/2018 1,500,000.00 1,479,404.42 2/7/2020 2.59%38,640.00$ 35,933.93$ 23,462.74$ FNMA 3136FTB73 Gov. Agency Debenture 4/25/2017 1,000,000.00 1,013,390.00 2/7/2020 1.50%55,666.67$ 33,146.46$ 9,244.36$ Disney 25468PDP8 Corporate Bond 12/1/2017 1,000,000.00 998,190.00 3/4/2020 2.03%44,034.50$ 32,037.85$ 13,794.07$ Toyota Motor Credit 89236TCF0 Corporate Bond 10/6/2017 500,000.00 503,545.00 3/12/2020 1.85%26,158.33$ 16,090.68$ 6,517.74$ Page 5 Town of Los Gatos Investment Schedule June 2020 FFCB 3133EJB81 Gov. Agency Debenture 10/9/2018 1,700,000.00 1,697,331.00 3/25/2020 2.84%67,810.17$ 34,889.76$ 35,550.55$ FFCB 3133EHEZ2 Gov. Agency Debenture 9/20/2017 1,600,000.00 1,602,304.00 4/6/2020 1.54%65,137.78$ 43,841.67$ 19,011.59$ Pepsico 713448CS5 Corporate Bond 5/15/2017 1,250,000.00 1,249,600.00 4/30/2020 1.86%68,411.46$ 49,451.53$ 19,436.49$ FHLB 3130AECJ7 Gov. Agency Debenture 9/14/2018 1,000,000.00 998,101.00 5/28/2020 2.46%44,260.42$ 21,666.58$ 24,965.30$ US Treasury 912828VF4 US Treasury Note 9/21/2017 1,000,000.00 997,109.38 5/31/2020 1.48%37,004.78$ 26,275.86$ 13,645.58$ FHLB 3133834H1 Gov. Agency Debenture 9/20/2017 1,785,000.00 1,776,432.00 6/12/2020 1.56%66,949.90$ 49,147.92$ 26,394.25$ Chevron 166764AG5 Corporate Bond 11/9/2017 1,350,000.00 1,366,834.50 5/24/2020 1.94%86,006.81$ 42,820.12$ 23,558.23$ Freddie Mac 3134GBN40 Gov. Agency Debenture 9/29/2017 1,000,000.00 998,900.00 6/29/2020 1.67%44,687.50$ 29,148.73$ 16,649.90$ Freddie Mac 3134GVHB7 Corporate Bond 3/30/2020 1,800,000.00 1,800,000.00 6/30/2020 1.05%9,450.00$ -$ 4,763.84$ Total Investments "Matured"44,584,352.60 1,488,114.46 1,217,597.45 399,170.86 Total Interest FY 19_20 Matured and Current 1,135,789.63$ Maturity Profile Amount 0-1 year $22,886,228.411-2 years $12,808,103.202-3 years $9,879,938.72 3-5 years 13,336,052.76$ $58,910,323.09 AmortizedInstitution Cost BNY Assets $46,578,673.68BNY MM 145,919.90 LAIF 12,185,729.51Totals:$58,910,323.09 Market to Cost Position Report Page 6 Town of Los Gatos Summary Investment Information May 31, 2020 Weighted Average YTM Portfolio Yield: 1.87%Weighted Average Maturity (days)613 This Month Last Month One year ago Portfolio Balance $69,817,884 $71,749,285 $70,576,201 Benchmarks/ References: Town's Average Yield 1.87%1.87%2.08% LAIF Yield for month 1.36%1.65%2.45% 3 mo. Treasury 0.15%0.12%2.34% 6 mo. Treasury 0.19%0.11%2.35% 2 yr. Treasury 0.16%0.20%1.92% 5 yr. Treasury (most recent)0.30%0.36%1.91% 10 Yr. Treasury 0.65%0.64%2.13% 0 -1 year 30% 1 -2 years 30% 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 3, 2019and 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, 2020 Month YTD Fund Balances - Beginning of Month/Period $71,749,285.32 $72,013,633.77 Receipts 3,054,965.17 43,613,870.00Disbursements(4,986,366.27)(45,809,619.55) Fund Balances - End of Month/Period $69,817,884.22 $69,817,884.22 Portfolio Allocation:% of Portfolio Max. % 0r $ Allowed Per State Law or Policy BNY MM $1,148,526.94 1.92%20% of Town PortfolioUS Treasury Notes $8,720,525.80 14.57%No Max. on US Treasuries Government Agency Debenture Notes $27,115,749.75 45.30%No Max. on Non-Mortgage Backed Corporate Medium Term Bonds $16,310,924.51 27.25%30% of Town Portfolio Local Agency Investment Fund 6,565,729.51 10.97%$75 M per State Law Subtotal - Investments 59,861,456.51 100.00% Reconciled Demand Deposit Balances 9,956,427.71 Total Treasurer's Fund $69,817,884.22 BNY MM1.92%US Treasury Notes 14.57% Government Agency Debenture Notes45.30% Corporate Medium Term Bonds27.2% Local Agency Investment Fund11.0% Portfolio Investment Allocation 60000000 62000000 64000000 66000000 68000000 70000000 72000000 74000000 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Treasurer's Fund Balances page 2 Town of Los Gatos Non-Treasury Restricted Fund Balances May 31, 2020 MAY 20 MAY 20 MAY 20BeginningDepositsInterest/Ending Balance Realized Gain/Adj.Earnings Withdrawals Balance Non-Treasury Funds: ` Cert. of Participation 2002 Series A Reserve Fund 688,883.50$ 5.70$ -$ 688,889.20$ Note 1Cert. Of Participation 2010 Ser A Lease Pymt Fund 732.04 0.17 732.21 Note 1Cert. of Participation 2002 Lease Payment Fund 84.03 0.00 84.03 Note 1 Cert. of Participation 2010 Series Reserve Fund 1,297,490.26 297.02 0.00 1,297,787.28 Note 2 Total Restricted Funds:1,987,189.83$ $0.00 $302.89 $0.00 $1,987,492.72 CEPPT IRS Section 115 Trust 268,000.00 4,454.58 272,454.58 PARS IRS Sectioh 115 Trust 271,208.87$ -$ 191.37$ 268,000.00$ 3,400.24$ Note 3 Grand Total COP's and PARS Trust 2,258,398.70$ 268,000.00$ 4,948.84$ 268,000.00$ 2,263,347.54$ These accounts are not part of the Treasurer's fund balances reported elsewhere in this report, as they are for separate and distinct entities. 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 paymentsand 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 PARS 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 pos Page 3 Town of Los Gatos Statement of Interest Earned May 31, 2020 Interest by Month July 2019 $103,310.93 August 2019 101,993.86 September 2019 99,668.91 October 2019 100,474.14 November 2019 96,912.19 December 2019 100,785.87 January 2020 97,263.82 February 2020 88,967.87 March 2020 83,480.41 April 2020 95,000.42 May 2020 87,454.01 June 2020 $1,055,312.43 Page 4 Town of Los Gatos Investment Schedule May 2020 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 Maturity Treasury 912828WR7 US Treasury Note 4/2/2019 1,000,000.00 995,625.00 1,020,664.06 6/30/2021 2.33%15,849.45$ 5,656.35$ 21,354.33$ 395Toyota Motor Credit 89236TDP7 Corporate Bond 05/20/19 1,100,000.00 1,102,596.00 1,128,842.44 1/11/2022 2.50%18,351.67$ 3,102.53$ 25,425.65$ 590FHLB3133834H1Gov. Agency Debenture 9/20/2017 1,785,000.00 1,776,432.00 1,785,710.47 6/12/2020 1.56%54,678.03$ 49,147.92$ 25,484.11$ 12Toyota Motor Credit 89236TCZ6 Corporate Bond 3/13/2020 500,000.00 504,440.00 504,715.70 4/8/2021 1.06%659.72$ -$ 1,159.08$ 312FFCB3133EKMX1Gov. Agency Debenture 8/2/2019 1,000,000.00 1,014,400.00 1,068,067.41 2/23/2024 1.90%18,025.83$ -$ 15,893.09$ 1363FFCB3133ELVV3Gov. Agency Debenture 4/8/2020 1,600,000.00 1,600,000.00 1,603,699.50 4/8/2022 0.93%-$ -$ 2,207.12$ 677FNMA3133EHYM9Gov. Agency Debenture 9/21/2017 1,300,000.00 1,295,866.00 1,305,584.01 9/14/2020 1.61%48,370.83$ 37,021.86$ 19,226.19$ 106 US Treasury 912828VF4 US Treasury Note 9/21/2017 1,000,000.00 997,109.38 1,000,000.00 5/31/2020 1.48%37,004.78$ 26,275.86$ 13,645.58$ 0FNMA3136G0AW1Gov. Agency Debenture 12/13/2017 2,000,000.00 2,017,900.00 2,013,453.56 10/16/2020 2.02%110,058.33$ 62,898.65$ 37,471.53$ 138IBM 459200HG9 Corporate Bond 8/8/2019 1,000,000.00 995,010.00 1,029,051.82 8/1/2022 2.05%9,010.42$ -$ 16,617.76$ 792Oracle68389XBL8Corporate Bond 7/8/2019 1,000,000.00 1,008,880.00 1,054,487.36 7/15/2023 2.18%16,466.67$ -$ 19,583.04$ 1140US Treasury 912828R28 US Treasury Note 7/2/2019 500,000.00 497,246.09 520,820.31 4/30/2023 1.77%6,734.04$ -$ 8,092.88$ 1064American Express 0258M0EB1 Corporate Bond 2/11/2020 1,000,000.00 1,007,210.00 1,014,738.86 4/4/2021 1.66%5,250.00$ -$ 4,883.45$ 308Freddie Mac 3137EAEN5 Gov. Agency Debenture 7/19/2019 2,000,000.00 2,072,358.00 2,152,627.00 6/19/2023 1.79%22,916.67$ -$ 31,738.13$ 1114FFCB3133EKVF0Gov. Agency Debenture 7/22/2019 1,000,000.00 999,630.00 1,042,852.44 1/17/2023 1.89%9,114.58$ -$ 16,221.26$ 961 Treasury 912828L57 US Treasury Note 7/22/2019 1,200,000.00 1,197,988.40 1,243,921.87 9/30/2022 2.09%14,516.39$ -$ 18,607.47$ 852Freddie Mac 3137EADB2 Gov. Agency Debenture 1/17/2020 2,100,000.00 2,132,039.70 2,173,844.63 554.16 1/13/2022 2.12%(554.16)$ -$ 12,497.32$ 592US Treasury 912828Y20 Gov. Agency Debenture 1/31/2020 1,000,000.00 1,016,601.56 1,027,109.38 1,153.84 7/15/2021 1.47%(1,153.84)$ -$ 4,919.03$ 410American Honda 02665WCZ2 Corporate Bond 11/27/2019 1,000,000.00 1,012,410.01 1,030,808.81 6/27/2024 2.12%12,733.34$ -$ 10,851.25$ 1488JP Morgan Chase 46625HJE1 Gov. Agency Debenture 2/11/2020 900,000.00 934,587.00 947,142.32 9/23/2022 1.74%3,412.50$ -$ 4,831.23$ 845Honeywell Int'l.438516BW5 Corporate Bond 11/20/2019 1,000,000.00 1,014,660.00 1,062,404.48 7/15/2024 1.64%4,983.33$ -$ 10,496.32$ 1506Disney254687CK0Corporate Bond 3/4/2020 1,000,000.00 1,029,080.00 1,027,530.71 2,375.00 2/15/2021 1.39%(2,375.00)$ -$ 3,495.75$ 260FNMA3135G0V75Gov. Agency Debenture 10/17/2019 1,100,000.00 1,105,833.30 1,161,180.94 7/2/2024 1.63%4,331.25$ -$ 11,202.06$ 1493US Bancorp 91159HHV5 Corporate Bond 12/24/2019 1,000,000.00 1,049,040.00 1,089,654.12 1/5/2024 2.12%3,843.75$ -$ 9,408.53$ 1314Chevron166764AG5Corporate Bond 11/9/2017 1,350,000.00 1,366,834.50 1,351,728.00 5/24/2020 1.94%69,624.56$ 42,820.12$ 23,558.23$ 0FFCB3133EKCS3Gov. Agency Debenture 3/21/2019 1,400,000.00 1,403,262.00 1,424,553.94 3/11/2021 2.43%34,708.33$ 9,421.68$ 31,343.41$ 284 FFCB 3133EKQA7 Gov. Agency Debenture 10/21/2019 1,000,000.00 1,019,780.00 1,067,852.10 9/10/2024 1.66%8,031.11$ -$ 10,238.21$ 1563PNC Financial 693476BN2 Corporate Bond 8/15/2019 1,000,000.00 1,029,280.00 1,046,235.02 2/6/2022 2.12%18,608.33$ -$ 16,846.99$ 616FHLB313379Q69Gov. Agency Debenture 7/22/2019 1,000,000.00 1,006,960.00 1,037,886.69 6/10/2022 1.87%8,145.83$ -$ 16,207.35$ 740 FNMA 3135G0V59 Gov. Agency Debenture 11/27/2019 1,540,000.00 1,562,924.44 1,598,952.28 4/12/2022 1.61%12,993.75$ -$ 12,739.21$ 681Freddie Mac 3134GBN40 Gov. Agency Debenture 9/29/2017 1,000,000.00 998,900.00 1,001,107.11 6/29/2020 1.67%36,562.50$ 29,148.73$ 15,327.03$ 29JP Morgan Chase 46625HJT8 Corporate Bond 9/23/2019 1,400,000.00 1,485,414.00 1,545,247.47 2/1/2024 2.39%19,288.89$ -$ 23,839.51$ 1341American Honda 02665WDH1 Corporate Bond 2/14/2020 600,000.00 603,756.00 609,711.38 5/10/2023 1.75%4,745.00$ -$ 3,089.56$ 1074FHLB3130AABG2US Treasury Note 4/15/2019 1,000,000.00 988,250.00 1,025,721.03 11/29/2021 2.34%21,041.67$ 4,835.29$ 21,377.06$ 547FNMA3135G0Q89Gov. Agency Debenture 2/10/2020 1,000,000.00 998,702.00 1,015,886.86 10/7/2021 1.38%2,177.08$ -$ 4,419.65$ 494FNMA3135G0J20Gov. Agency Debenture 2/10/2020 1,000,000.00 998,882.00 1,008,636.50 2/26/2021 1.48%611.11$ -$ 4,506.37$ 271Treasury912828M80US Treasury Note 7/22/2019 1,000,000.00 1,006,175.23 1,045,273.44 11/30/2022 1.81%17,158.47$ -$ 15,625.18$ 913 Treasury 912828U57 US Treasury Note 7/31/2019 1,000,000.00 1,011,875.00 1,066,406.25 11/30/2023 1.84%17,708.33$ -$ 15,468.87$ 1278BankAmerica Corp 06051GGS2 Corporate Bond 4/30/2020 1,300,000.00 1,302,314.00 1,303,817.46 2,437.92 10/1/2020 1.21%(2,437.92)$ -$ 2,104.56$ 123Treasury912828X70US Treasury Note 12/30/2019 1,000,000.00 1,010,589.29 1,068,437.50 4/30/2024 1.75%7,703.30$ -$ 8,198.44$ 1430 Treasury 912828XT2 US Treasury Note 10/31/2019 1,000,000.00 1,015,667.41 1,069,609.38 5/31/2024 1.64%11,639.34$ -$ 9,677.71$ 1461Freddie Mac 3134GVHB7 Corporate Bond 3/30/2020 1,800,000.00 1,800,000.00 1,800,120.51 6/30/2020 1.05%-$ -$ 3,210.41$ 30FFCB3133EJ3Q0Gov. Agency Debenture 8/28/2019 1,500,000.00 1,587,503.75 1,633,030.14 12/21/2023 2.12%13,536.46$ -$ 17,347.96$ 1299Freddie Mac 3133EKKT2 Gov. Agency Debenture 6/24/2019 1,550,000.00 1,573,188.00 1,632,264.99 2/8/2023 1.82%30,418.75$ 468.29$ 26,223.98$ 983 Subtotal 51,525,000.00$ 52,147,200.06$ 53,361,390.25$ 6,520.92$ 744,493.47$ 270,797.28$ 626,661.85$ BNY MM 1,148,526.94 1,148,526.94 0.00%1LAIFN/A 6,565,729.51 6,565,729.51 2.19%114,491.52 1 $59,861,456.51 $61,075,646.70 744,493.47$ 270,797.28$ 741,153.37$ Matured AssetsTreasury 912828WS5 US Treasury Note 5/2/2017 500,000.00 503,339.84 7/1/2019 1.31%17,574.24$ 14,227.74$ 18.03$ Oracle 68389XAG0 Corporate Bond 5/3/2018 1,000,000.00 1,028,370.00 7/8/2019 2.54%59,027.78$ 30,101.79$ 569.30$ FHLB 3130AEU73 Gov. Agency Debenture 8/27/2018 1,000,000.00 999,180.00 7/22/2019 2.46%23,750.00$ 20,741.19$ 1,486.34$ Treasury 912828F39 US Treasury Note 4/17/2018 1,200,000.00 1,190,343.75 7/22/2019 2.32%30,524.59$ 34,452.97$ 1,726.57$ FHLB 313383VN8 Gov. Agency Debenture 5/25/2018 2,000,000.00 1,989,800.00 7/22/2019 2.40%52,000.00$ 53,614.71$ 2,941.46$ FHLMC 3137EAEB1 Gov. Agency Debenture 3/14/2017 2,000,000.00 1,970,180.00 7/19/2019 1.52%41,076.39$ 69,336.96$ 1,572.08$ Treasury 9128282K5 US Treasury Note 7/2/2018 1,000,000.00 989,218.75 7/31/2019 2.39%14,851.52$ 23,607.64$ 2,016.08$ FNMA 3135G0N33 Gov. Agency Debenture 04/17/13 1,000,000.00 981,984.01 8/2/2019 2.17%12,322.92$ 28,416.36$ 1,945.52$ Microsoft 594918BN3 Corporate Bond 8/8/2016 1,000,000.00 999,470.00 8/8/2019 1.12%33,000.00$ 32,335.78$ 1,194.22$ Berkshire Hathaway 084664CK5 Corporate Bond 1/22/2018 1,100,000.00 1,086,305.00 8/15/2019 2.11%22,363.61$ 33,119.10$ 2,907.40$ FNMA 3135G0P49 Gov. Agency Debenture 11/15/2016 1,500,000.00 1,487,505.00 8/28/2019 1.31%41,791.66$ 51,098.17$ 3,150.25$ JP Morgan Chase 48125LRG9 Corporate Bond 3/28/2017 1,400,000.00 1,393,196.00 9/23/2019 1.86%57,429.17$ 58,316.80$ 6,015.69$ FFCB 3133EGYP4 Gov. Agency Debenture 10/28/2016 1,000,000.00 997,507.00 10/17/2019 1.14%31,179.17$ 30,290.27$ 3,386.30$ FFCB 3133EJPU7 Gov. Agency Debenture 6/1/2018 1,000,000.00 1,001,454.00 10/21/2019 2.38%36,511.11$ 25,640.48$ 7,353.74$ Treasury 912828F62 US Treasury Note 6/30/2017 1,000,000.00 1,002,148.44 10/31/2019 1.41%35,013.59$ 28,161.36$ 4,745.00$ American Honda 02665WBZ3 Corporate Bond 4/11/2018 1,000,000.00 990,620.00 11/13/2019 2.61%31,944.44$ 31,567.90$ 9,647.72$ FNMA 3135G0ZY2 Gov. Agency Debenture 12/20/2017 1,550,000.00 1,545,642.95 11/26/2019 1.90%52,441.67$ 44,831.00$ 11,992.49$ Pfizer 717081EB5 Corporate Bond 6/30/2017 1,000,000.00 1,002,280.00 12/15/2019 1.60%41,791.67$ 32,146.55$ 7,398.11$ US Bamcorp 90331HNB5 Corporate Bond 10/19/2018 1,000,000.00 986,540.00 12/24/2019 3.09%25,277.78$ 21,850.15$ 15,226.29$ FNMA 3136G3TW5 Gov. Agency Debenture 7/25/2018 1,000,000.00 980,540.00 12/30/2019 2.54%16,451.39$ 23,363.19$ 12,574.89$ FreddieMac 3137EAEE5 Gov. Agency Debenture 12/20/2017 1,000,000.00 991,200.00 1/17/2020 1.93%31,125.00$ 29,356.90$ 10,593.78$ FreddieMac 3137EAEE5(A)Gov. Agency Debenture 12/18/2018 1,000,000.00 987,160.00 1/17/2020 2.71%16,208.33$ 14,278.83$ 14,794.05$ Treasury 912828H52 US Treasury Note 6/30/2017 1,000,000.00 994,726.56 1/31/2020 1.46%32,320.44$ 29,073.66$ 8,562.79$ JP Morgan Chase 48125LRK0 Corporate Bond 3/4/2019 1,000,000.00 996,520.00 2/1/2020 2.71%23,653.00$ 9,647.87$ 17,660.51$ American Express 0258M0EE5 Corporate Bond 9/15/2017 1,000,000.00 1,007,980.00 3/3/2020 1.87%54,266.67$ 33,568.97$ 12,697.60$ Page 5 Town of Los Gatos Investment Schedule May 2020 FHLB 3130ACRP1 Gov. Agency Debenture 7/25/2018 1,500,000.00 1,479,404.42 2/7/2020 2.59%38,640.00$ 35,933.93$ 23,462.74$ FNMA 3136FTB73 Gov. Agency Debenture 4/25/2017 1,000,000.00 1,013,390.00 2/7/2020 1.50%55,666.67$ 33,146.46$ 9,244.36$ Disney 25468PDP8 Corporate Bond 12/1/2017 1,000,000.00 998,190.00 3/4/2020 2.03%44,034.50$ 32,037.85$ 13,794.07$ Toyota Motor Credit 89236TCF0 Corporate Bond 10/6/2017 500,000.00 503,545.00 3/12/2020 1.85%26,158.33$ 16,090.68$ 6,517.74$ FFCB 3133EJB81 Gov. Agency Debenture 10/9/2018 1,700,000.00 1,697,331.00 3/25/2020 2.84%67,810.17$ 34,889.76$ 35,550.55$ FFCB 3133EHEZ2 Gov. Agency Debenture 9/20/2017 1,600,000.00 1,602,304.00 4/6/2020 1.54%65,137.78$ 43,841.67$ 19,011.59$ Pepsico 713448CS5 Corporate Bond 5/15/2017 1,250,000.00 1,249,600.00 4/30/2020 1.86%68,411.46$ 49,451.53$ 19,436.49$ FHLB 3130AECJ7 Gov. Agency Debenture 9/14/2018 1,000,000.00 998,101.00 5/28/2020 2.46%44,260.42$ 21,666.58$ 24,965.30$ Total Investments "Matured"37,645,076.72 1,244,015.47 1,070,204.81 314,159.06 Total Interest FY 19_20 Matured and Current 1,055,312.43$ Maturity Profile Amount0-1 year $21,848,542.45 1-2 years $11,426,018.702-3 years $8,814,540.723-5 years 15,408,410.76$ $57,497,512.63 AmortizedInstitution Cost BNY Assets $52,147,200.06BNY MM 1,148,526.94LAIF6,565,729.51 Totals:$59,861,456.51 Market to Cost Position Report Page 6 Town of Los Gatos Summary Investment Information April 30, 2020 Weighted Average YTM Portfolio Yield: 1.87%Weighted Average Maturity (days)651 This Month Last Month One year ago Portfolio Balance $71,749,285 $68,160,286 $69,831,987 Benchmarks/ References: Town's Average Yield 1.87%1.90%2.04% LAIF Yield for month 1.65%1.79%2.45% 3 mo. Treasury 0.12%0.12%2.42% 6 mo. Treasury 0.11%0.16%2.45% 2 yr. Treasury 0.20%0.25%2.27% 5 yr. Treasury (most recent)0.36%0.38%2.28% 10 Yr. Treasury 0.64%0.67%2.50% 0 -1 year 30% 1 -2 years 30% 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 3, 2019and 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, 2020 Month YTD Fund Balances - Beginning of Month/Period $68,160,286.04 $72,013,633.77 Receipts 6,361,348.26 40,558,904.83Disbursements(2,772,348.98)(40,823,253.28) Fund Balances - End of Month/Period $71,749,285.32 $71,749,285.32 Portfolio Allocation:% of Portfolio Max. % 0r $ Allowed Per State Law or Policy BNY MM $109,595.86 0.19%20% of Town PortfolioUS Treasury Notes $8,720,525.80 14.83%No Max. on US Treasuries Government Agency Debenture Notes $28,113,850.75 47.80%No Max. on Non-Mortgage Backed Corporate Medium Term Bonds $16,310,924.51 27.73%30% of Town Portfolio Local Agency Investment Fund 5,565,729.51 9.46%$75 M per State Law Subtotal - Investments 58,820,626.43 100.00% Reconciled Demand Deposit Balances 12,928,658.89 Total Treasurer's Fund $71,749,285.32 BNY MM0.19%US Treasury Notes14.83% Government Agency Debenture Notes47.80% Corporate Medium Term Bonds27.7% Local Agency Investment Fund 9.5% Portfolio Investment Allocation 60000000 62000000 64000000 66000000 68000000 70000000 72000000 74000000 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 Treasurer's Fund Balances page 2 Town of Los Gatos Non-Treasury Restricted Fund Balances April 30, 2020 APR 20 APR 20 APR 20BeginningDepositsInterest/Ending Balance Realized Gain/Adj.Earnings Withdrawals Balance Non-Treasury Funds: ` Cert. of Participation 2002 Series A Reserve Fund 688,677.38$ 206.12$ -$ 688,883.50$ Note 1Cert. Of Participation 2010 Ser A Lease Pymt Fund 731.45 0.59 732.04 Note 1Cert. of Participation 2002 Lease Payment Fund 84.03 0.00 84.03 Note 1 Cert. of Participation 2010 Series Reserve Fund 1,296,485.82 1,004.44 0.00 1,297,490.26 Note 2 Total Restricted Funds:1,985,978.68$ $0.00 $1,211.15 $0.00 $1,987,189.83 PARS IRS Sectioh 115 Trust 251,735.23$ -$ 19,473.64$ 271,208.87$ Note 3 Grand Total COP's and PARS Trust 2,237,713.91$ $0.00 20,684.79$ $0.00 2,258,398.70$ These accounts are not part of the Treasurer's fund balances reported elsewhere in this report, as they are for separate and distinct entities. Note 1: The three original funds for the Certificates of Participation 2002 Series A consist of construction funds which will be expended over thenext 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 PARS 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 post employment benefits. Page 3 Town of Los Gatos Statement of Interest Earned April 30, 2020 Interest by Month July 2019 $103,310.93 August 2019 101,993.86 September 2019 99,668.91 October 2019 100,474.14 November 2019 96,912.19 December 2019 100,785.87 January 2020 97,050.92 February 2020 79,677.48 March 2020 83,480.41 April 2020 96,860.11 May 2020 June 2020 $960,214.82 Page 4 Town of Los Gatos Investment Schedule April 2020 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 Maturity Treasury 912828WR7 US Treasury Note 4/2/2019 1,000,000.00 995,625.00 1,022,890.62 6/30/2021 2.33%15,849.45$ 5,656.35$ 19,384.14$ 426Toyota Motor Credit 89236TDP7 Corporate Bond 05/20/19 1,100,000.00 1,102,596.00 1,124,249.89 1/11/2022 2.50%18,351.67$ 3,102.53$ 23,079.83$ 621FHLB3133834H1Gov. Agency Debenture 9/20/2017 1,785,000.00 1,776,432.00 1,786,875.77 6/12/2020 1.56%54,678.03$ 49,147.92$ 23,132.90$ 43Toyota Motor Credit 89236TCZ6 Corporate Bond 3/13/2020 500,000.00 504,440.00 503,104.80 4/8/2021 1.06%659.72$ -$ 704.25$ 343FFCB3133EKMX1Gov. Agency Debenture 8/2/2019 1,000,000.00 1,014,400.00 1,063,338.06 2/23/2024 1.90%18,025.83$ -$ 14,267.06$ 1394FFCB3133ELVV3Gov. Agency Debenture 4/8/2020 1,600,000.00 1,600,000.00 1,603,556.59 4/8/2022 0.93%-$ -$ 916.16$ 708FNMA3133EHYM9Gov. Agency Debenture 9/21/2017 1,300,000.00 1,295,866.00 1,307,127.47 9/14/2020 1.61%48,370.83$ 37,021.86$ 17,452.34$ 137 US Treasury 912828VF4 US Treasury Note 9/21/2017 1,000,000.00 997,109.38 1,001,044.53 5/31/2020 1.48%30,129.78$ 26,275.86$ 12,386.61$ 31FNMA3136G0AW1Gov. Agency Debenture 12/13/2017 2,000,000.00 2,017,900.00 2,015,903.52 10/16/2020 2.02%110,058.33$ 62,898.65$ 34,014.34$ 169IBM 459200HG9 Corporate Bond 8/8/2019 1,000,000.00 995,010.00 1,024,848.26 8/1/2022 2.05%9,010.42$ -$ 14,883.24$ 823Oracle68389XBL8Corporate Bond 7/8/2019 1,000,000.00 1,008,880.00 1,046,650.00 7/15/2023 2.18%16,466.67$ -$ 17,732.20$ 1171US Treasury 912828R28 US Treasury Note 7/2/2019 500,000.00 497,246.09 520,546.88 4/30/2023 1.77%6,734.04$ -$ 7,341.74$ 1095American Express 0258M0EB1 Corporate Bond 2/11/2020 1,000,000.00 1,007,210.00 1,010,470.34 6,000.00 4/4/2021 1.66%(6,000.00)$ -$ 3,507.21$ 339Freddie Mac 3137EAEN5 Gov. Agency Debenture 7/19/2019 2,000,000.00 2,072,358.00 2,149,264.20 6/19/2023 1.79%22,916.67$ -$ 28,634.40$ 1145FFCB3133EKVF0Gov. Agency Debenture 7/22/2019 1,000,000.00 999,630.00 1,039,568.93 1/17/2023 1.89%9,114.58$ -$ 14,619.80$ 992 Treasury 912828L57 US Treasury Note 7/22/2019 1,200,000.00 1,197,988.40 1,244,203.13 9/30/2022 2.09%14,516.39$ -$ 16,770.43$ 883Freddie Mac 3137EADB2 Gov. Agency Debenture 1/17/2020 2,100,000.00 2,132,039.70 2,174,484.90 554.16 1/13/2022 2.12%(554.16)$ -$ 9,627.56$ 623US Treasury 912828Y20 Gov. Agency Debenture 1/31/2020 1,000,000.00 1,016,601.56 1,029,531.25 1,153.84 7/15/2021 1.47%(1,153.84)$ -$ 3,658.78$ 441American Honda 02665WCZ2 Corporate Bond 11/27/2019 1,000,000.00 1,012,410.01 1,003,260.54 6/27/2024 2.12%12,733.34$ -$ 9,042.71$ 1519JP Morgan Chase 46625HJE1 Gov. Agency Debenture 2/11/2020 900,000.00 934,587.00 941,806.50 9/23/2022 1.74%3,412.50$ -$ 3,469.70$ 876Honeywell Int'l.438516BW5 Corporate Bond 11/20/2019 1,000,000.00 1,014,660.00 1,048,651.05 7/15/2024 1.64%4,983.33$ -$ 8,810.39$ 1537Disney254687CK0Corporate Bond 3/4/2020 1,000,000.00 1,029,080.00 1,025,489.29 2,375.00 2/15/2021 1.39%(2,375.00)$ -$ 2,264.29$ 291FNMA3135G0V75Gov. Agency Debenture 10/17/2019 1,100,000.00 1,105,833.30 1,156,742.63 7/2/2024 1.63%4,331.25$ -$ 9,672.26$ 1524FHLB3130AECJ7Gov. Agency Debenture 9/14/2018 1,000,000.00 998,101.00 1,001,688.74 5/28/2020 2.46%31,135.42$ 21,666.58$ 22,866.11$ 28US Bancorp 91159HHV5 Corporate Bond 12/24/2019 1,000,000.00 1,049,040.00 1,074,110.00 1/5/2024 2.12%3,843.75$ -$ 7,574.16$ 1345Chevron166764AG5Corporate Bond 11/9/2017 1,350,000.00 1,366,834.50 1,351,710.76 5/24/2020 1.94%69,624.56$ 42,820.12$ 21,839.70$ 24 FFCB 3133EKCS3 Gov. Agency Debenture 3/21/2019 1,400,000.00 1,403,262.00 1,428,888.20 3/11/2021 2.43%34,708.33$ 9,421.68$ 28,451.60$ 315FFCB3133EKQA7Gov. Agency Debenture 10/21/2019 1,000,000.00 1,019,780.00 1,062,305.13 9/10/2024 1.66%8,031.11$ -$ 8,814.96$ 1594PNC Financial 693476BN2 Corporate Bond 8/15/2019 1,000,000.00 1,029,280.00 1,039,964.56 2/6/2022 2.12%18,608.33$ -$ 15,046.11$ 647 FHLB 313379Q69 Gov. Agency Debenture 7/22/2019 1,000,000.00 1,006,960.00 1,039,572.27 6/10/2022 1.87%8,145.83$ -$ 14,607.26$ 771FNMA3135G0V59Gov. Agency Debenture 11/27/2019 1,540,000.00 1,562,924.44 1,599,621.35 4/12/2022 1.61%12,993.75$ -$ 10,616.01$ 712Freddie Mac 3134GBN40 Gov. Agency Debenture 9/29/2017 1,000,000.00 998,900.00 1,002,303.75 6/29/2020 1.67%36,562.50$ 29,148.73$ 13,912.93$ 60JP Morgan Chase 46625HJT8 Corporate Bond 9/23/2019 1,400,000.00 1,485,414.00 1,520,787.34 2/1/2024 2.39%19,288.89$ -$ 20,895.19$ 1372American Honda 02665WDH1 Corporate Bond 2/14/2020 600,000.00 603,756.00 596,491.20 1,105.00 5/10/2023 1.75%(1,105.00)$ -$ 2,194.46$ 1105FHLB3130AABG2US Treasury Note 4/15/2019 1,000,000.00 988,250.00 1,025,639.60 11/29/2021 2.34%11,666.67$ 4,835.29$ 19,404.77$ 578FNMA3135G0Q89Gov. Agency Debenture 2/10/2020 1,000,000.00 998,702.00 1,016,440.69 10/7/2021 1.38%2,177.08$ -$ 3,185.33$ 525FNMA3135G0J20Gov. Agency Debenture 2/10/2020 1,000,000.00 998,882.00 1,009,620.96 2/26/2021 1.48%611.11$ -$ 3,247.83$ 302 Treasury 912828M80 US Treasury Note 7/22/2019 1,000,000.00 1,006,175.23 1,045,429.69 11/30/2022 1.81%7,158.47$ -$ 14,082.57$ 944Treasury912828U57US Treasury Note 7/31/2019 1,000,000.00 1,011,875.00 1,065,546.88 11/30/2023 1.84%7,083.33$ -$ 13,896.62$ 1309BankAmerica Corp 06051GGS2 Corporate Bond 4/30/2020 1,300,000.00 1,302,314.00 1,301,830.78 2,437.92 10/1/2020 1.21%(2,437.92)$ -$ -$ 154 Treasury 912828X70 US Treasury Note 12/30/2019 1,000,000.00 1,010,589.29 1,067,187.50 4/30/2024 1.75%7,703.30$ -$ 6,537.32$ 1461Treasury912828XT2US Treasury Note 10/31/2019 1,000,000.00 1,015,667.41 1,068,359.38 5/31/2024 1.64%1,639.34$ -$ 8,269.22$ 1492Freddie Mac 3134GVHB7 Corporate Bond 3/30/2020 1,800,000.00 1,800,000.00 1,800,164.20 6/30/2020 1.05%-$ -$ 1,605.21$ 61FFCB3133EJ3Q0Gov. Agency Debenture 8/28/2019 1,500,000.00 1,587,503.75 1,626,852.03 12/21/2023 2.12%13,536.46$ -$ 15,406.49$ 1330Freddie Mac 3133EKKT2 Gov. Agency Debenture 6/24/2019 1,550,000.00 1,573,188.00 1,628,400.53 2/8/2023 1.82%30,418.75$ 468.29$ 23,804.51$ 1014 Subtotal 52,525,000.00$ 53,145,301.06$ 54,216,524.69$ 13,625.92$ 711,653.89$ 292,463.86$ 571,630.71$ BNY MM 109,595.86 109,595.86 0.00%1LAIFN/A 5,565,729.51 5,565,729.51 2.19%99,390.34 1 $58,820,626.43 $59,891,850.06 711,653.89$ 292,463.86$ 671,021.05$ Matured Assets Treasury 912828WS5 US Treasury Note 5/2/2017 500,000.00 503,339.84 7/1/2019 1.31%17,574.24$ 14,227.74$ 18.03$ Oracle 68389XAG0 Corporate Bond 5/3/2018 1,000,000.00 1,028,370.00 7/8/2019 2.54%59,027.78$ 30,101.79$ 569.30$ FHLB 3130AEU73 Gov. Agency Debenture 8/27/2018 1,000,000.00 999,180.00 7/22/2019 2.46%23,750.00$ 20,741.19$ 1,486.34$ Treasury 912828F39 US Treasury Note 4/17/2018 1,200,000.00 1,190,343.75 7/22/2019 2.32%30,524.59$ 34,452.97$ 1,726.57$ FHLB 313383VN8 Gov. Agency Debenture 5/25/2018 2,000,000.00 1,989,800.00 7/22/2019 2.40%52,000.00$ 53,614.71$ 2,941.46$ FHLMC 3137EAEB1 Gov. Agency Debenture 3/14/2017 2,000,000.00 1,970,180.00 7/19/2019 1.52%41,076.39$ 69,336.96$ 1,572.08$ Treasury 9128282K5 US Treasury Note 7/2/2018 1,000,000.00 989,218.75 7/31/2019 2.39%14,851.52$ 23,607.64$ 2,016.08$ FNMA 3135G0N33 Gov. Agency Debenture 04/17/13 1,000,000.00 981,984.01 8/2/2019 2.17%12,322.92$ 28,416.36$ 1,945.52$ Microsoft 594918BN3 Corporate Bond 8/8/2016 1,000,000.00 999,470.00 8/8/2019 1.12%33,000.00$ 32,335.78$ 1,194.22$ Berkshire Hathaway 084664CK5 Corporate Bond 1/22/2018 1,100,000.00 1,086,305.00 8/15/2019 2.11%22,363.61$ 33,119.10$ 2,907.40$ FNMA 3135G0P49 Gov. Agency Debenture 11/15/2016 1,500,000.00 1,487,505.00 8/28/2019 1.31%41,791.66$ 51,098.17$ 3,150.25$ JP Morgan Chase 48125LRG9 Corporate Bond 3/28/2017 1,400,000.00 1,393,196.00 9/23/2019 1.86%57,429.17$ 58,316.80$ 6,015.69$ FFCB 3133EGYP4 Gov. Agency Debenture 10/28/2016 1,000,000.00 997,507.00 10/17/2019 1.14%31,179.17$ 30,290.27$ 3,386.30$ FFCB 3133EJPU7 Gov. Agency Debenture 6/1/2018 1,000,000.00 1,001,454.00 10/21/2019 2.38%36,511.11$ 25,640.48$ 7,353.74$ Treasury 912828F62 US Treasury Note 6/30/2017 1,000,000.00 1,002,148.44 10/31/2019 1.41%35,013.59$ 28,161.36$ 4,745.00$ American Honda 02665WBZ3 Corporate Bond 4/11/2018 1,000,000.00 990,620.00 11/13/2019 2.61%31,944.44$ 31,567.90$ 9,647.72$ FNMA 3135G0ZY2 Gov. Agency Debenture 12/20/2017 1,550,000.00 1,545,642.95 11/26/2019 1.90%52,441.67$ 44,831.00$ 11,992.49$ Pfizer 717081EB5 Corporate Bond 6/30/2017 1,000,000.00 1,002,280.00 12/15/2019 1.60%41,791.67$ 32,146.55$ 7,398.11$ US Bamcorp 90331HNB5 Corporate Bond 10/19/2018 1,000,000.00 986,540.00 12/24/2019 3.09%25,277.78$ 21,850.15$ 15,226.29$ FNMA 3136G3TW5 Gov. Agency Debenture 7/25/2018 1,000,000.00 980,540.00 12/30/2019 2.54%16,451.39$ 23,363.19$ 12,574.89$ FreddieMac 3137EAEE5 Gov. Agency Debenture 12/20/2017 1,000,000.00 991,200.00 1/17/2020 1.93%31,125.00$ 29,356.90$ 10,593.78$ FreddieMac 3137EAEE5(A)Gov. Agency Debenture 12/18/2018 1,000,000.00 987,160.00 1/17/2020 2.71%16,208.33$ 14,278.83$ 14,794.05$ Treasury 912828H52 US Treasury Note 6/30/2017 1,000,000.00 994,726.56 1/31/2020 1.46%32,320.44$ 29,073.66$ 8,562.79$ JP Morgan Chase 48125LRK0 Corporate Bond 3/4/2019 1,000,000.00 996,520.00 2/1/2020 2.71%23,653.00$ 9,647.87$ 17,660.51$ American Express 0258M0EE5 Corporate Bond 9/15/2017 1,000,000.00 1,007,980.00 3/3/2020 1.87%54,266.67$ 33,568.97$ 12,697.60$ FHLB 3130ACRP1 Gov. Agency Debenture 7/25/2018 1,500,000.00 1,479,404.42 2/7/2020 2.59%38,640.00$ 35,933.93$ 23,462.74$ Page 5 Town of Los Gatos Investment Schedule April 2020 FNMA 3136FTB73 Gov. Agency Debenture 4/25/2017 1,000,000.00 1,013,390.00 2/7/2020 1.50%55,666.67$ 33,146.46$ 9,244.36$ Disney 25468PDP8 Corporate Bond 12/1/2017 1,000,000.00 998,190.00 3/4/2020 2.03%44,034.50$ 32,037.85$ 13,794.07$ Toyota Motor Credit 89236TCF0 Corporate Bond 10/6/2017 500,000.00 503,545.00 3/12/2020 1.85%26,158.33$ 16,090.68$ 6,517.74$ FFCB 3133EJB81 Gov. Agency Debenture 10/9/2018 1,700,000.00 1,697,331.00 3/25/2020 2.84%67,810.17$ 34,889.76$ 35,550.55$ FFCB 3133EHEZ2 Gov. Agency Debenture 9/20/2017 1,600,000.00 1,602,304.00 4/6/2020 1.54%65,137.78$ 43,841.67$ 19,011.59$ Pepsico 713448CS5 Corporate Bond 5/15/2017 1,250,000.00 1,249,600.00 4/30/2020 1.86%68,411.46$ 49,451.53$ 19,436.49$ Total Investments "Matured"33,795,071.72 1,066,205.81 955,245.03 289,193.77 Total Interest FY 19_20 Matured and Current 960,214.82$ Maturity Profile Amount0-1 year $23,171,656.251-2 years $11,426,018.70 2-3 years $8,210,784.723-5 years 16,012,166.76$ $58,820,626.43 AmortizedInstitution Cost BNY Assets $53,145,301.06BNY MM 109,595.86LAIF5,565,729.51Totals:$58,820,626.43 Market to Cost Position Report Page 6