Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
02 Attachment 1
Town of Los Gatos Summary Investment Information March 31, 2020 Weighted Average YTM Portfolio Yield: 1.90%Weighted Average Maturity (days)656 This Month Last Month One year ago Portfolio Balance $68,160,286 $67,400,124 $66,777,438 Benchmarks/ References: Town's Average Yield 1.90%1.91%2.00% LAIF Yield for month 1.79%1.91%2.43% 3 mo. Treasury 0.12%1.56%2.39% 6 mo. Treasury 0.16%1.54%2.43% 2 yr. Treasury 0.25%1.32%2.36% 5 yr. Treasury (most recent)0.38%1.32%2.23% 10 Yr. Treasury 0.67%1.51%2.41% 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 3, 2019 and 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 GatosPortfolio Allocation & Treasurer's Fund Balances March 31, 2020 Month YTD Fund Balances - Beginning of Month/Period $67,400,123.50 $72,013,633.77 Receipts 3,650,223.44 34,197,556.57 Disbursements (2,890,060.90)(38,050,904.30) Fund Balances - End of Month/Period $68,160,286.04 $68,160,286.04 Portfolio Allocation:% of Portfolio Max. % 0r $ Allowed Per State Law or Policy BNY MM $74,492.13 0.13%20% of Town Portfolio US Treasury Notes $8,720,525.80 14.85%No Max. on US Treasuries Government Agency Debenture Notes $28,116,154.75 47.89%No Max. on Non-Mortgage Backed Corporate Medium Term Bonds $16,258,210.51 27.69%30% of Town Portfolio Local Agency Investment Fund 5,537,858.38 9.43%$65M per State Law Subtotal - Investments 58,707,241.57 100.00% Reconciled Demand Deposit Balances 9,453,044.47 Total Treasurer's Fund $68,160,286.04 BNY MM 0.13%US Treasury Notes14.85% Government Agency Debenture Notes47.89% Corporate Medium Term Bonds27.7% Local Agency Investment Fund9.4% Portfolio Investment Allocation 60000000 62000000 64000000 66000000 68000000 70000000 72000000 74000000 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Treasurer's Fund Balances page 2 Town of Los Gatos Non-Treasury Restricted Fund Balances March 31, 2020 MAR 20 MAR 20 MAR 20 Beginning Deposits Interest/EndingBalanceRealized Gain/Adj.Earnings Withdrawals BalanceNon-Treasury Funds: ` Cert. of Participation 2002 Series A Reserve Fund 688,100.07$ 577.31$ -$ 688,677.38$ Note 1 Cert. Of Participation 2010 Ser A Lease Pymt Fund 715.60 15.85 731.45 Note 1Cert. of Participation 2002 Lease Payment Fund 75.44 8.59 84.03 Note 1Cert. of Participation 2010 Series Reserve Fund 1,295,020.63 1,465.19 0.00 1,296,485.82 Note 2Total Restricted Funds:1,983,911.74$ $0.00 $2,066.94 $0.00 $1,985,978.68 PARS IRS Sectioh 115 Trust 284,819.89$ -$ (33,084.66)$ 251,735.23$ Note 3 Grand Total COP's and PARS Trust 2,268,731.63$ -$ (31,017.72)$ -$ 2,237,713.91$ 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 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 March 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,050.92 February 2020 79,677.48 March 2020 83,480.41 April 2020 May 2020 June 2020 $863,354.71 Page 4 Town of Los Gatos Investment Schedule March 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,025,039.06 6/30/2021 2.33%15,849.45$ 5,656.35$ 17,477.50$ 456Toyota Motor Credit 89236TDP7 Corporate Bond 05/20/19 1,100,000.00 1,102,596.00 1,105,667.08 1/11/2022 2.50%18,351.67$ 3,102.53$ 20,809.68$ 651FHLB3133834H1Gov. Agency Debenture 9/20/2017 1,785,000.00 1,776,432.00 1,788,671.05 6/12/2020 1.56%54,678.03$ 49,147.92$ 20,857.53$ 73 Toyota Motor Credit 89236TCZ6 Corporate Bond 3/13/2020 500,000.00 504,440.00 497,689.49 4,090.28 4/8/2021 1.06%(4,090.28)$ -$ 264.09$ 373FFCB3133EKMX1Gov. Agency Debenture 8/2/2019 1,000,000.00 1,014,400.00 1,062,320.27 2/23/2024 1.90%18,025.83$ -$ 12,693.49$ 1424FFCB3133EHEZ2Gov. Agency Debenture 9/20/2017 1,600,000.00 1,602,304.00 1,600,229.31 4/6/2020 1.54%52,337.78$ 43,841.67$ 18,605.65$ 6FNMA3133EHYM9Gov. Agency Debenture 9/21/2017 1,300,000.00 1,295,866.00 1,307,948.92 9/14/2020 1.61%48,370.83$ 37,021.86$ 15,735.72$ 167 US Treasury 912828VF4 US Treasury Note 9/21/2017 1,000,000.00 997,109.38 1,002,105.56 5/31/2020 1.48%30,129.78$ 26,275.86$ 11,168.26$ 61FNMA3136G0AW1Gov. Agency Debenture 12/13/2017 2,000,000.00 2,017,900.00 2,017,013.92 10/16/2020 2.02%86,558.33$ 62,898.65$ 30,668.67$ 199IBM 459200HG9 Corporate Bond 8/8/2019 1,000,000.00 995,010.00 1,008,940.43 8/1/2022 2.05%9,010.42$ -$ 13,204.68$ 853Oracle68389XBL8Corporate Bond 7/8/2019 1,000,000.00 1,008,880.00 1,023,973.48 7/15/2023 2.18%16,466.67$ -$ 15,941.07$ 1201US Treasury 912828R28 US Treasury Note 7/2/2019 500,000.00 497,246.09 520,410.16 4/30/2023 1.77%2,671.54$ -$ 6,614.84$ 1125American Express 0258M0EB1 Corporate Bond 2/11/2020 1,000,000.00 1,007,210.00 1,002,632.05 6,000.00 4/4/2021 1.66%(6,000.00)$ -$ 2,175.36$ 369 Freddie Mac 3137EAEN5 Gov. Agency Debenture 7/19/2019 2,000,000.00 2,072,358.00 2,142,636.46 6/19/2023 1.79%22,916.67$ -$ 25,630.79$ 1175FFCB3133EKVF0Gov. Agency Debenture 7/22/2019 1,000,000.00 999,630.00 1,029,671.78 1/17/2023 1.89%9,114.58$ -$ 13,069.99$ 1022Treasury912828L57US Treasury Note 7/22/2019 1,200,000.00 1,197,988.40 1,244,671.87 9/30/2022 2.09%14,516.39$ -$ 14,992.64$ 913Freddie Mac 3137EADB2 Gov. Agency Debenture 1/17/2020 2,100,000.00 2,132,039.70 2,173,637.21 554.16 1/13/2022 2.12%(554.16)$ -$ 6,850.38$ 653 US Treasury 912828Y20 Gov. Agency Debenture 1/31/2020 1,000,000.00 1,016,601.56 1,031,875.00 1,153.84 7/15/2021 1.47%(1,153.84)$ -$ 2,439.19$ 471American Honda 02665WCZ2 Corporate Bond 11/27/2019 1,000,000.00 1,012,410.01 985,567.90 6/27/2024 2.12%12,733.34$ -$ 7,292.50$ 1549JP Morgan Chase 46625HJE1 Gov. Agency Debenture 2/11/2020 900,000.00 934,587.00 928,180.39 9/23/2022 1.74%3,412.50$ -$ 2,152.09$ 906Honeywell Int'l.438516BW5 Corporate Bond 11/20/2019 1,000,000.00 1,014,660.00 992,929.21 7/15/2024 1.64%4,983.33$ -$ 7,178.83$ 1567Disney254687CK0Corporate Bond 3/4/2020 1,000,000.00 1,029,080.00 1,025,309.54 2,375.00 2/15/2021 1.39%(2,375.00)$ -$ 1,072.56$ 321FNMA3135G0V75Gov. Agency Debenture 10/17/2019 1,100,000.00 1,105,833.30 1,150,534.88 7/2/2024 1.63%4,331.25$ -$ 8,191.81$ 1554FHLB3130AECJ7Gov. Agency Debenture 9/14/2018 1,000,000.00 998,101.00 1,003,562.00 5/28/2020 2.46%31,135.42$ 21,666.58$ 20,616.99$ 58US Bancorp 91159HHV5 Corporate Bond 12/24/2019 1,000,000.00 1,049,040.00 1,061,620.78 1/5/2024 2.12%3,843.75$ -$ 5,798.97$ 1375Chevron166764AG5Corporate Bond 11/9/2017 1,350,000.00 1,366,834.50 1,348,337.66 5/24/2020 1.94%69,624.56$ 42,820.12$ 19,691.53$ 54FFCB3133EKCS3Gov. Agency Debenture 3/21/2019 1,400,000.00 1,403,262.00 1,429,795.93 3/11/2021 2.43%34,708.33$ 9,421.68$ 25,653.09$ 345FFCB3133EKQA7Gov. Agency Debenture 10/21/2019 1,000,000.00 1,019,780.00 1,060,393.45 9/10/2024 1.66%8,031.11$ -$ 7,437.63$ 1624PNC Financial 693476BN2 Corporate Bond 8/15/2019 1,000,000.00 1,029,280.00 1,014,748.05 2/6/2022 2.12%18,608.33$ -$ 13,303.31$ 677FHLB313379Q69Gov. Agency Debenture 7/22/2019 1,000,000.00 1,006,960.00 1,038,434.05 6/10/2022 1.87%8,145.83$ -$ 13,058.79$ 801FNMA3135G0V59Gov. Agency Debenture 11/27/2019 1,540,000.00 1,562,924.44 1,596,636.63 4,331.25 4/12/2022 1.61%(4,331.25)$ -$ 8,561.30$ 742Freddie Mac 3134GBN40 Gov. Agency Debenture 9/29/2017 1,000,000.00 998,900.00 1,002,929.71 6/29/2020 1.67%36,562.50$ 29,148.73$ 12,544.45$ 90JP Morgan Chase 46625HJT8 Corporate Bond 9/23/2019 1,400,000.00 1,485,414.00 1,499,323.53 2/1/2024 2.39%19,288.89$ -$ 18,045.84$ 1402American Honda 02665WDH1 Corporate Bond 2/14/2020 600,000.00 603,756.00 585,129.28 1,105.00 5/10/2023 1.75%(1,105.00)$ -$ 1,328.22$ 1135FHLB3130AABG2US Treasury Note 4/15/2019 1,000,000.00 988,250.00 1,023,880.81 11/29/2021 2.34%11,666.67$ 4,835.29$ 17,496.11$ 608FNMA3135G0Q89Gov. Agency Debenture 2/10/2020 1,000,000.00 998,702.00 1,014,545.57 4,697.92 10/7/2021 1.38%(4,697.92)$ -$ 1,990.83$ 555FNMA3135G0J20Gov. Agency Debenture 2/10/2020 1,000,000.00 998,882.00 1,009,501.69 2/26/2021 1.48%611.11$ -$ 2,029.90$ 332Treasury912828M80US Treasury Note 7/22/2019 1,000,000.00 1,006,175.23 1,045,664.06 11/30/2022 1.81%7,158.47$ -$ 12,589.72$ 974 Treasury 912828U57 US Treasury Note 7/31/2019 1,000,000.00 1,011,875.00 1,065,898.44 11/30/2023 1.84%7,083.33$ -$ 12,375.09$ 1339Pepsico713448CS5Corporate Bond 5/15/2017 1,250,000.00 1,249,600.00 1,249,872.16 4/30/2020 1.86%56,848.96$ 49,451.53$ 17,524.70$ 30Treasury912828X70US Treasury Note 12/30/2019 1,000,000.00 1,010,589.29 1,066,875.00 3,296.70 4/30/2024 1.75%(3,296.70)$ -$ 4,929.78$ 1491Treasury912828XT2US 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$ -$ 6,906.16$ 1522 Freddie Mac 3134GVHB7 Corporate Bond 3/30/2020 1,800,000.00 1,800,000.00 1,800,085.07 6/30/2020 1.05%-$ -$ 51.78$ 91FFCB3133EJ3Q0Gov. Agency Debenture 8/28/2019 1,500,000.00 1,587,503.75 1,623,946.79 12/21/2023 2.12%13,536.46$ -$ 13,527.65$ 1360Freddie Mac 3133EKKT2 Gov. Agency Debenture 6/24/2019 1,550,000.00 1,573,188.00 1,614,363.63 2/8/2023 1.82%30,418.75$ 468.29$ 21,463.08$ 1044 Subtotal 52,475,000.00$ 53,094,891.06$ 53,891,558.69$ 27,604.15$ 755,766.05$ 385,757.06$ 532,012.25$ BNY MM 74,492.13 74,492.13 0.00%1LAIFN/A 5,537,858.38 5,537,858.38 2.19%80,596.77 1 $58,707,241.57 $59,503,909.20 755,766.05$ 385,757.06$ 612,609.02$ 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$ 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$ Total Investments "Matured"33,795,071.72 1,066,205.81 955,245.03 250,745.69 Total Interest FY 19_20 Matured and Current 863,354.71$ Page 5 Town of Los Gatos Investment Schedule March 2020 Maturity Profile Amount0-1 year $23,146,621.391-2 years $9,774,744.262-3 years $9,276,463.073-5 years 16,509,412.85$ $58,707,241.57 AmortizedInstitution Cost BNY Assets $53,094,891.06BNY MM 74,492.13 LAIF 5,537,858.38Totals:$58,707,241.57 Market to Cost Position Report Page 6 Town of Los Gatos Summary Investment Information February 29, 2020 Weighted Average YTM Portfolio Yield: 1.91%Weighted Average Maturity (days)672 This Month Last Month One year ago Portfolio Balance $67,400,124 $67,213,822 $67,407,964 Benchmarks/ References: Town's Average Yield 1.91%1.93%1.95% LAIF Yield for month 1.91%1.97%2.39% 3 mo. Treasury 1.56%1.56%2.44% 6 mo. Treasury 1.54%1.54%2.50% 2 yr. Treasury 1.32%1.32%2.52% 5 yr. Treasury (most recent)1.32%1.32%2.51% 10 Yr. Treasury 1.51%1.51%2.72% 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 3, 2019 and 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 GatosPortfolio Allocation & Treasurer's Fund Balances February 29, 2020 Month YTD Fund Balances - Beginning of Month/Period $67,213,821.88 $72,013,633.77 Receipts 3,540,784.43 30,547,333.13 Disbursements (3,354,482.81)(35,160,843.40) Fund Balances - End of Month/Period $67,400,123.50 $67,400,123.50 Portfolio Allocation:% of Portfolio Max. % 0r $ Allowed Per State Law or Policy BNY MM $83,452.43 0.14%20% of Town Portfolio US Treasury Notes $8,720,525.80 14.89%No Max. on US Treasuries Government Agency Debenture Notes $29,813,485.75 50.89%No Max. on Non-Mortgage Backed Corporate Medium Term Bonds $14,426,425.51 24.63%30% of Town Portfolio Local Agency Investment Fund 5,537,858.47 9.45%$65M per State Law Subtotal - Investments 58,581,747.96 100.00% Reconciled Demand Deposit Balances 8,818,375.54 Total Treasurer's Fund $67,400,123.50 BNY MM 0.14%US Treasury Notes14.89% Government Agency Debenture Notes50.89% Corporate Medium Term Bonds24.6% Local Agency Investment Fund9.5% Portfolio Investment Allocation 60000000 62000000 64000000 66000000 68000000 70000000 72000000 74000000 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Treasurer's Fund Balances page 2 Town of Los Gatos Non-Treasury Restricted Fund Balances February 29, 2020 FEB 20 FEB 20 FEB 20 Beginning Deposits Interest/EndingBalanceRealized Gain/Adj.Earnings Withdrawals BalanceNon-Treasury Funds: ` Cert. of Participation 2002 Series A Reserve Fund 687,495.59$ 604.48$ -$ 688,100.07$ Note 1 Cert. Of Participation 2010 Ser A Lease Pymt Fund 192,756.90 121.20 192,162.50 715.60 Note 1Cert. of Participation 2002 Lease Payment Fund 150,310.60 71.09 150,306.25 75.44 Note 1Cert. of Participation 2010 Series Reserve Fund 1,293,444.86 1,575.77 0.00 1,295,020.63 Note 2Total Restricted Funds:2,324,007.95$ $0.00 $2,372.54 $342,468.75 $1,983,911.74 PARS IRS Sectioh 115 Trust 301,640.03$ -$ (16,820.14)$ 284,819.89$ Note 3 Grand Total COP's and PARS Trust 2,625,647.98$ -$ (14,447.60)$ 342,468.75$ 2,268,731.63$ 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 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 February 29, 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 April 2020 May 2020 June 2020 $779,874.30 Page 4 Town of Los Gatos Investment Schedule February 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,014,882.81 6/30/2021 2.33%15,849.45$ 5,656.35$ 15,507.31$ 487Toyota Motor Credit 89236TDP7 Corporate Bond 05/20/19 1,100,000.00 1,102,596.00 1,128,631.91 1/11/2022 2.50%18,351.67$ 3,102.53$ 18,463.86$ 682 FHLB 3133834H1 Gov. Agency Debenture 9/20/2017 1,785,000.00 1,776,432.00 1,784,982.45 6/12/2020 1.56%54,678.03$ 49,147.92$ 18,506.32$ 104FFCB3133EJB81Gov. Agency Debenture 10/9/2018 1,700,000.00 1,697,331.00 1,701,821.72 3/25/2020 2.84%44,605.17$ 34,889.76$ 32,246.60$ 25FFCB3133EKMX1Gov. Agency Debenture 8/2/2019 1,000,000.00 1,014,400.00 1,048,632.72 2/23/2024 1.90%18,025.83$ -$ 11,067.46$ 1455FFCB3133EHEZ2Gov. Agency Debenture 9/20/2017 1,600,000.00 1,602,304.00 1,600,547.22 4/6/2020 1.54%52,337.78$ 43,841.67$ 16,508.28$ 37FNMA3133EHYM9Gov. Agency Debenture 9/21/2017 1,300,000.00 1,295,866.00 1,302,782.25 9/14/2020 1.61%38,620.83$ 37,021.86$ 13,961.88$ 198US Treasury 912828VF4 US Treasury Note 9/21/2017 1,000,000.00 997,109.38 999,804.69 5/31/2020 1.48%30,129.78$ 26,275.86$ 9,909.29$ 92FNMA3136G0AW1Gov. Agency Debenture 12/13/2017 2,000,000.00 2,017,900.00 2,015,052.46 10/16/2020 2.02%86,558.33$ 62,898.65$ 27,211.47$ 230IBM 459200HG9 Corporate Bond 8/8/2019 1,000,000.00 995,010.00 1,012,500.81 8/1/2022 2.05%9,010.42$ -$ 11,470.17$ 884Oracle68389XBL8Corporate Bond 7/8/2019 1,000,000.00 1,008,880.00 1,032,018.42 7/15/2023 2.18%4,466.67$ -$ 14,090.23$ 1232US Treasury 912828R28 US Treasury Note 7/2/2019 500,000.00 497,246.09 511,503.91 4/30/2023 1.77%2,671.54$ -$ 5,863.70$ 1156American Express 0258M0EB1 Corporate Bond 2/11/2020 1,000,000.00 1,007,210.00 1,008,646.36 6,000.00 4/4/2021 1.66%(6,000.00)$ -$ 799.11$ 400 Freddie Mac 3137EAEN5 Gov. Agency Debenture 7/19/2019 2,000,000.00 2,072,358.00 2,116,276.82 6/19/2023 1.79%22,916.67$ -$ 22,527.07$ 1206 FFCB 3133EKVF0 Gov. Agency Debenture 7/22/2019 1,000,000.00 999,630.00 1,026,426.25 1/17/2023 1.89%9,114.58$ -$ 11,468.53$ 1053Treasury912828L57US Treasury Note 7/22/2019 1,200,000.00 1,197,988.40 1,226,578.13 9/30/2022 2.09%4,016.39$ -$ 13,155.60$ 944Freddie Mac 3137EADB2 Gov. Agency Debenture 1/17/2020 2,100,000.00 2,132,039.70 2,154,328.72 554.16 1/13/2022 2.12%(554.16)$ -$ 3,980.63$ 684US Treasury 912828Y20 Gov. Agency Debenture 1/31/2020 1,000,000.00 1,016,601.56 1,021,953.12 1,153.84 7/15/2021 1.47%(1,153.84)$ -$ 1,178.94$ 502American Honda 02665WCZ2 Corporate Bond 11/27/2019 1,000,000.00 1,012,410.01 1,032,256.07 6/27/2024 2.12%12,733.34$ -$ 5,483.96$ 1580JP Morgan Chase 46625HJE1 Gov. Agency Debenture 2/11/2020 900,000.00 934,587.00 938,228.58 11,212.50 9/23/2022 1.74%(11,212.50)$ -$ 790.56$ 937Honeywell Int'l.438516BW5 Corporate Bond 11/20/2019 1,000,000.00 1,014,660.00 1,039,544.41 7/15/2024 1.64%4,983.33$ -$ 5,492.89$ 1598 Disney 25468PDP8 Corporate Bond 12/1/2017 1,000,000.00 998,190.00 1,000,010.00 3/4/2020 2.03%34,284.50$ 32,037.85$ 13,571.59$ 4 FNMA 3135G0V75 Gov. Agency Debenture 10/17/2019 1,100,000.00 1,105,833.30 1,135,567.20 7/2/2024 1.63%4,331.25$ -$ 6,662.02$ 1585FHLB3130AECJ7Gov. Agency Debenture 9/14/2018 1,000,000.00 998,101.00 1,003,027.37 5/28/2020 2.46%31,135.42$ 21,666.58$ 18,292.89$ 89US Bancorp 91159HHV5 Corporate Bond 12/24/2019 1,000,000.00 1,049,040.00 1,071,241.62 1/5/2024 2.12%3,843.75$ -$ 3,964.60$ 1406Chevron166764AG5Corporate Bond 11/9/2017 1,350,000.00 1,366,834.50 1,352,347.16 5/24/2020 1.94%69,624.56$ 42,820.12$ 17,471.76$ 85FFCB3133EKCS3Gov. Agency Debenture 3/21/2019 1,400,000.00 1,403,262.00 1,420,515.08 3/11/2021 2.43%16,858.33$ 9,421.68$ 22,761.28$ 376FFCB3133EKQA7Gov. Agency Debenture 10/21/2019 1,000,000.00 1,019,780.00 1,047,559.88 2,368.89 9/10/2024 1.66%(2,368.89)$ -$ 6,014.38$ 1655PNC Financial 693476BN2 Corporate Bond 8/15/2019 1,000,000.00 1,029,280.00 1,034,097.00 2/6/2022 2.12%2,108.33$ -$ 11,502.43$ 708FHLB313379Q69Gov. Agency Debenture 7/22/2019 1,000,000.00 1,006,960.00 1,027,259.64 6/10/2022 1.87%8,145.83$ -$ 11,458.70$ 832 FNMA 3135G0V59 Gov. Agency Debenture 11/27/2019 1,540,000.00 1,562,924.44 1,582,277.77 4,331.25 4/12/2022 1.61%(4,331.25)$ -$ 6,438.10$ 773Freddie Mac 3134GBN40 Gov. Agency Debenture 9/29/2017 1,000,000.00 998,900.00 1,000,689.54 6/29/2020 1.67%36,562.50$ 29,148.73$ 11,130.34$ 121JP Morgan Chase 46625HJT8 Corporate Bond 9/23/2019 1,400,000.00 1,485,414.00 1,515,179.36 2/1/2024 2.39%19,288.89$ -$ 15,101.52$ 1433American Honda 02665WDH1 Corporate Bond 2/14/2020 600,000.00 603,756.00 608,993.23 1,105.00 5/10/2023 1.75%(1,105.00)$ -$ 433.12$ 1166FHLB3130AABG2US Treasury Note 4/15/2019 1,000,000.00 988,250.00 1,016,241.54 11/29/2021 2.34%11,666.67$ 4,835.29$ 15,523.82$ 639FNMA3135G0Q89Gov. Agency Debenture 2/10/2020 1,000,000.00 998,702.00 1,006,306.55 4,697.92 10/7/2021 1.38%(4,697.92)$ -$ 756.52$ 586FNMA3135G0J20Gov. Agency Debenture 2/10/2020 1,000,000.00 998,882.00 1,002,626.40 2/26/2021 1.48%611.11$ -$ 771.36$ 363Treasury912828M80US Treasury Note 7/22/2019 1,000,000.00 1,006,175.23 1,030,117.19 11/30/2022 1.81%7,158.47$ -$ 11,047.10$ 1005 Treasury 912828U57 US Treasury Note 7/31/2019 1,000,000.00 1,011,875.00 1,044,921.88 11/30/2023 1.84%7,083.33$ -$ 10,802.85$ 1370 Pepsico 713448CS5 Corporate Bond 5/15/2017 1,250,000.00 1,249,600.00 1,250,370.58 3/30/2020 1.31%56,848.96$ 49,460.00$ 15,551.86$ 30Treasury912828X70US Treasury Note 12/30/2019 1,000,000.00 1,010,589.29 1,044,257.81 3,296.70 4/30/2024 1.75%(3,296.70)$ -$ 3,268.66$ 1522Treasury912828XT2US Treasury Note 10/31/2019 1,000,000.00 1,015,667.41 1,045,117.19 5/31/2024 1.64%1,639.34$ -$ 5,497.67$ 1553Toyota Motor Credit 89236TCF0 Corporate Bond 10/6/2017 500,000.00 503,545.00 500,062.19 3/12/2020 1.85%20,783.33$ 16,090.68$ 6,212.22$ 12FFCB3133EJ3Q0Gov. Agency Debenture 8/28/2019 1,500,000.00 1,587,503.75 1,607,338.25 12/21/2023 2.12%13,536.46$ -$ 11,586.18$ 1391Freddie Mac 3133EKKT2 Gov. Agency Debenture 6/24/2019 1,550,000.00 1,573,188.00 1,608,520.92 2/8/2023 1.82%30,418.75$ 468.29$ 19,043.61$ 1075 Subtotal 52,375,000.00$ 52,960,437.06$ 53,672,045.18$ 34,720.26$ 770,279.33$ 468,783.83$ 504,548.44$ BNY MM 83,452.43 106,351.46 0.00%1LAIFN/A 5,537,858.47 5,537,858.47 2.19%80,596.77 1 $58,581,747.96 $59,316,255.11 770,279.33$ 468,783.83$ 585,145.21$ 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$ 0American Express 0258M0EE5 Corporate Bond 9/15/2017 1,000,000.00 1,007,980.00 3/3/2020 1.87%43,266.67$ 33,568.97$ 12,543.38$ 3FHLB3130ACRP1Gov. 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$ 0 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$ 0 Total Investments "Matured"30,596,005.72 917,202.81 872,226.74 194,729.10 Total Interest FY 19_20 Matured and Current 779,874.30$ Page 5 Town of Los Gatos Investment Schedule February 2020 Maturity Profile Amount0-1 year $22,122,305.781-2 years $10,673,566.262-3 years $9,276,463.073-5 years 16,509,412.85$ $58,581,747.96 AmortizedInstitution Cost BNY Assets $52,960,437.06BNY MM 83,452.43LAIF5,537,858.47Totals:$58,581,747.96 Market to Cost Position Report Page 6 Town of Los Gatos Summary Investment Information January 31, 2020 Weighted Average YTM Portfolio Yield: 1.93%Weighted Average Maturity (days)649 This Month Last Month One year ago Portfolio Balance $67,213,822 $63,890,429 $68,382,346 Benchmarks/ References: Town's Average Yield 1.93%1.93%1.55% LAIF Yield for month 1.97%2.04%1.35% 3 mo. Treasury 1.56%1.55%1.46% 6 mo. Treasury 1.54%1.59%1.65% 2 yr. Treasury 1.32%1.57%2.14% 5 yr. Treasury (most recent)1.32%1.69%2.52% 10 Yr. Treasury 1.51%1.69%2.71% 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 3, 2019 and 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 GatosPortfolio Allocation & Treasurer's Fund Balances January 31, 2020 Month YTD Fund Balances - Beginning of Month/Period $63,890,429.42 $72,013,633.77 Receipts 7,338,108.11 27,006,548.70 Disbursements (4,014,715.65)(31,806,360.59) Fund Balances - End of Month/Period $67,213,821.88 $67,213,821.88 Portfolio Allocation:% of Portfolio Max. % 0r $ Allowed Per State Law or Policy BNY MM $10,332.08 0.02%20% of Town Portfolio US Treasury Notes $8,720,525.80 14.92%No Max. on US Treasuries Government Agency Debenture Notes $29,374,109.17 50.24%No Max. on Non-Mortgage Backed Corporate Medium Term Bonds $14,819,959.51 25.35%30% of Town Portfolio Local Agency Investment Fund 5,537,858.47 9.47%$65M per State Law Subtotal - Investments 58,462,785.03 100.00% Reconciled Demand Deposit Balances 8,751,036.85 Total Treasurer's Fund $67,213,821.88 BNY MM 0.02%US Treasury Notes14.92% Government Agency Debenture Notes50.24% Corporate Medium Term Bonds25.3% Local Agency Investment Fund9.5% Portfolio Investment Allocation 60000000 62000000 64000000 66000000 68000000 70000000 72000000 74000000 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Treasurer's Fund Balances page 2 Town of Los Gatos Non-Treasury Restricted Fund Balances January 31, 2020 JAN 20 JAN 20 JAN 20 Beginning Deposits Interest/EndingBalanceRealized Gain/Adj.Earnings Withdrawals BalanceNon-Treasury Funds: Cert. of Participation 2002 Series A Reserve Fund 686,871.12$ 624.47$ -$ 687,495.59$ Note 1 Cert. Of Participation 2010 Ser A Lease Pymt Fund 593.73 192,162.50 0.67 192,756.90 Note 1Cert. of Participation 2002 Lease Payment Fund 7,040.24 143,266.01 4.35 150,310.60 Note 1Cert. of Participation 2010 Series Reserve Fund 1,291,837.67 1,607.19 0.00 1,293,444.86 Note 2Total Restricted Funds:1,986,342.76$ $335,428.51 $2,236.68 $0.00 $2,324,007.95 PARS IRS Sectioh 115 Trust 303,402.26$ -$ (1,762.23)$ 301,640.03$ Note 3 Grand Total COP's and PARS Trust 2,289,745.02$ 335,428.51$ 474.45$ -$ 2,625,647.98$ 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 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 pos Page 3 Town of Los Gatos Statement of Interest Earned January 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,050.92 February 2020 March 2020 April 2020 May 2020 June 2020 $700,196.82 Page 4 Town of Los Gatos Investment Schedule January 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,009,570.31 6/30/2021 2.33%15,849.45$ 5,656.35$ 13,664.23$ 516Toyota Motor Credit 89236TDP7 Corporate Bond 05/20/19 1,100,000.00 1,102,596.00 1,120,576.33 1/11/2022 2.50%18,351.67$ 3,102.53$ 16,269.39$ 711FHLB3133834H1Gov. Agency Debenture 9/20/2017 1,785,000.00 1,776,432.00 1,783,677.24 6/12/2020 1.56%54,678.03$ 49,147.92$ 16,306.80$ 133 FFCB 3133EJB81 Gov. Agency Debenture 10/9/2018 1,700,000.00 1,697,331.00 1,703,052.72 3/25/2020 2.84%44,605.17$ 34,889.76$ 28,414.01$ 54FFCB3133EKMX1Gov. Agency Debenture 8/2/2019 1,000,000.00 1,014,400.00 1,030,505.60 2/23/2024 1.90%6,875.83$ -$ 9,546.34$ 1484FFCB3133EHEZ2Gov. Agency Debenture 9/20/2017 1,600,000.00 1,602,304.00 1,600,182.08 4/6/2020 1.54%52,337.78$ 43,841.67$ 14,546.23$ 66 FNMA 3133EHYM9 Gov. Agency Debenture 9/21/2017 1,300,000.00 1,295,866.00 1,299,847.20 9/14/2020 1.61%38,620.83$ 37,021.86$ 12,302.47$ 227US Treasury 912828VF4 US Treasury Note 9/21/2017 1,000,000.00 997,109.38 999,140.62 5/31/2020 1.48%30,129.78$ 26,275.86$ 8,731.55$ 121FNMA3136G0AW1Gov. Agency Debenture 12/13/2017 2,000,000.00 2,017,900.00 2,011,054.60 10/16/2020 2.02%86,558.33$ 62,898.65$ 23,977.32$ 259IBM 459200HG9 Corporate Bond 8/8/2019 1,000,000.00 995,010.00 1,005,363.94 364.58 8/1/2022 2.05%(364.58)$ -$ 9,847.56$ 913Oracle68389XBL8Corporate Bond 7/8/2019 1,000,000.00 1,008,880.00 1,025,268.36 7/15/2023 2.18%4,466.67$ -$ 12,358.81$ 1261US Treasury 912828R28 US Treasury Note 7/2/2019 500,000.00 497,246.09 505,039.06 4/30/2023 1.77%2,671.54$ -$ 5,161.03$ 1185American Express 0258M0EE5 Corporate Bond 9/15/2017 1,000,000.00 1,007,980.00 1,000,000.00 3/3/2020 1.87%43,266.67$ 33,568.97$ 11,052.57$ 32 Freddie Mac 3137EAEN5 Gov. Agency Debenture 7/19/2019 2,000,000.00 2,072,358.00 2,092,887.38 6/19/2023 1.79%22,916.67$ -$ 19,623.58$ 1235FFCB3133EKVF0Gov. Agency Debenture 7/22/2019 1,000,000.00 999,630.00 1,012,775.08 1/17/2023 1.89%9,114.58$ -$ 9,970.39$ 1082Treasury912828L57US Treasury Note 7/22/2019 1,200,000.00 1,197,988.40 1,213,687.50 9/30/2022 2.09%4,016.39$ -$ 11,437.08$ 973 Freddie Mac 3137EADB2 Gov. Agency Debenture 1/17/2020 2,100,000.00 2,132,039.70 2,139,948.15 1/13/2022 2.12%(554.16)$ -$ 1,296.02$ 713US Treasury 912828Y20 Gov. Agency Debenture 1/31/2020 1,000,000.00 1,016,601.56 1,017,226.56 7/15/2021 1.47%(1,153.84)$ -$ -$ 531American Honda 02665WCZ2 Corporate Bond 11/27/2019 1,000,000.00 1,012,410.01 1,023,657.37 6/27/2024 2.12%733.34$ -$ 3,792.10$ 1609FHLB3130ACRP1Gov. Agency Debenture 7/25/2018 1,500,000.00 1,479,404.42 1,500,018.18 2/7/2020 2.59%26,040.00$ 35,933.93$ 22,722.93$ 7Honeywell Int'l.438516BW5 Corporate Bond 11/20/2019 1,000,000.00 1,014,660.00 1,026,434.53 6,516.67 7/15/2024 1.64%(6,516.67)$ -$ 3,915.73$ 1627Disney25468PDP8Corporate Bond 12/1/2017 1,000,000.00 998,190.00 1,000,133.55 3/4/2020 2.03%34,284.50$ 32,037.85$ 11,958.57$ 33FNMA3135G0V75Gov. Agency Debenture 10/17/2019 1,100,000.00 1,105,833.30 1,117,589.97 7/2/2024 1.63%4,331.25$ -$ 5,230.92$ 1614FHLB3130AECJ7Gov. Agency Debenture 9/14/2018 1,000,000.00 998,101.00 1,003,366.85 5/28/2020 2.46%31,135.42$ 21,666.58$ 16,118.74$ 118US Bancorp 91159HHV5 Corporate Bond 12/24/2019 1,000,000.00 1,049,040.00 1,063,528.26 13,031.25 1/5/2024 2.12%(13,031.25)$ -$ 2,248.58$ 1435Chevron166764AG5Corporate Bond 11/9/2017 1,350,000.00 1,366,834.50 1,352,619.80 5/24/2020 1.94%69,624.56$ 42,820.12$ 15,395.20$ 114FFCB3133EKCS3Gov. Agency Debenture 3/21/2019 1,400,000.00 1,403,262.00 1,418,499.67 3/11/2021 2.43%16,858.33$ 9,421.68$ 20,056.05$ 405 FFCB 3133EKQA7 Gov. Agency Debenture 10/21/2019 1,000,000.00 1,019,780.00 1,028,345.86 2,368.89 9/10/2024 1.66%(2,368.89)$ -$ 4,682.95$ 1684PNC Financial 693476BN2 Corporate Bond 8/15/2019 1,000,000.00 1,029,280.00 1,031,941.10 2/6/2022 2.12%2,108.33$ -$ 9,817.73$ 737FHLB313379Q69Gov. Agency Debenture 7/22/2019 1,000,000.00 1,006,960.00 1,017,630.90 6/10/2022 1.87%8,145.83$ -$ 9,961.84$ 861FNMA3135G0V59Gov. Agency Debenture 11/27/2019 1,540,000.00 1,562,924.44 1,569,679.28 4,331.25 4/12/2022 1.61%(4,331.25)$ -$ 4,451.88$ 802Freddie Mac 3134GBN40 Gov. Agency Debenture 9/29/2017 1,000,000.00 998,900.00 1,000,240.04 6/29/2020 1.67%36,562.50$ 29,148.73$ 9,807.48$ 150JP Morgan Chase 46625HJT8 Corporate Bond 9/23/2019 1,400,000.00 1,485,414.00 1,507,103.16 7,836.11 2/1/2024 2.39%(7,836.11)$ -$ 12,347.16$ 1462FHLB3130AABG2US Treasury Note 4/15/2019 1,000,000.00 988,250.00 1,008,705.12 11/29/2021 2.34%11,666.67$ 4,835.29$ 13,678.77$ 668FNMA3136FTB73Gov. Agency Debenture 4/25/2017 1,000,000.00 1,013,390.00 1,000,050.42 2/7/2020 1.50%45,666.67$ 33,146.46$ 8,952.87$ 7JP Morgan Chase 48125LRK0 Corporate Bond 3/4/2019 1,000,000.00 996,520.00 1,000,000.00 2/1/2020 2.71%10,633.00$ 9,647.87$ 17,578.75$ 1Treasury912828M80US Treasury Note 7/22/2019 1,000,000.00 1,006,175.23 1,019,023.44 11/30/2022 1.81%7,158.47$ -$ 9,604.01$ 1034Treasury912828U57US Treasury Note 7/31/2019 1,000,000.00 1,011,875.00 1,030,234.38 11/30/2023 1.84%7,083.33$ -$ 9,332.04$ 1399 Pepsico 713448CS5 Corporate Bond 5/15/2017 1,250,000.00 1,249,600.00 1,250,368.00 3/30/2020 1.31%56,848.96$ 49,460.00$ 13,703.48$ 59Treasury912828X70US Treasury Note 12/30/2019 1,000,000.00 1,010,589.29 1,027,929.69 3,296.70 4/30/2024 1.75%(3,296.70)$ -$ 1,714.71$ 1551Treasury912828XT2US Treasury Note 10/31/2019 1,000,000.00 1,015,667.41 1,028,320.31 5/31/2024 1.64%1,639.34$ -$ 4,180.04$ 1582 Toyota Motor Credit 89236TCF0 Corporate Bond 10/6/2017 500,000.00 503,545.00 500,249.05 3/12/2020 1.85%20,783.33$ 16,090.68$ 5,473.89$ 41FFCB3133EJ3Q0Gov. Agency Debenture 8/28/2019 1,500,000.00 1,587,503.75 1,579,498.05 12/21/2023 2.12%13,536.46$ -$ 9,769.97$ 1420Freddie Mac 3133EKKT2 Gov. Agency Debenture 6/24/2019 1,550,000.00 1,573,188.00 1,587,170.41 2/8/2023 1.82%12,981.25$ 468.29$ 16,780.23$ 1104 Subtotal 52,375,000.00$ 52,914,594.48$ 53,262,140.12$ 37,745.45$ 812,827.48$ 581,081.06$ 487,781.96$ BNY MM 10,332.08 106,351.46 0.00%1LAIFN/A 5,537,858.47 5,537,858.47 2.19%80,596.77 1 $58,462,785.03 $58,906,350.05 812,827.48$ 581,081.06$ 568,378.73$ 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$ Total Investments "Matured"26,098,711.30 755,976.47 759,929.51 131,818.10 Total Interest FY 19_20 Matured and Current 700,196.83$ Page 5 Town of Los Gatos Investment Schedule January 2020 Maturity Profile Amount0-1 year $25,547,597.851-2 years $7,638,374.262-3 years $7,797,968.073-5 years 17,478,844.85$ $58,462,785.03 AmortizedInstitution Cost BNY Assets $52,914,594.48BNY MM 10,332.08LAIF5,537,858.47Totals:$58,462,785.03 Market to Cost Position Report Page 6