Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Attachment 1
Town of Los Gatos Summary Investment Information July 31, 2018 Weighted Average YTM Portfolio Yield: 1.80%Weighted Average Maturity (days)391 This Month Last Month One year ago Portfolio Balance $74,160,411 $76,649,992 $71,205,721 Benchmarks/ References: Town's Average Yield 1.80%1.73%1.26% LAIF Yield for month 1.94%1.85%1.05% 3 mo. Treasury 2.02%1.92%1.08% 6 mo. Treasury 2.19%2.11%1.13% 2 yr. Treasury 2.67%2.54%1.35% 5 yr. Treasury (most recent)2.85%2.74%1.84% 10 Yr. Treasury 2.96%2.86%2.30% 0 -1 year 30% 1 -2 years 30% 2 -3 years 25% 3 -5 years 15% Portfolio Maturity Profile Compliance:The Town's investments are in compliance with the Town's investment policy dated May 15, 2018 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 Gatos Portfolio Allocation & Treasurer's Fund Balances July 31, 2018 Month YTD Fund Balances - Beginning of Month/Period $76,649,992.26 $76,649,992.26 Receipts 2,189,346.19 2,189,346.19 Disbursements (4,678,927.90)(4,678,927.90) Fund Balances - End of Month/Period $74,160,410.55 $74,160,410.55 Portfolio Allocation:% of Portfolio Max. % 0r $ Allowed Per State Law or Policy BNY MM $43,027.63 0.07%20% of Town Portfolio US Treasury Notes $6,681,105.47 11.57%No Max. on US Treasuries Government Agency Debenture Notes $30,125,294.38 52.15%No Max. on Non-Mortgage Backed Corporate Medium Term Bonds $14,603,307.00 25.28%30% of Town Portfolio Local Agency Investment Fund 6,312,576.31 10.93%$65M per State Law Subtotal - Investments 57,765,310.79 100.00% Reconciled Demand Deposit Balances 16,395,099.76 Total Treasurer's Fund $74,160,410.55 BNY MM 0.07%US Treasury Notes 11.57% Government Agency Debenture Notes 52.15% Corporate Medium Term Bonds 25.3% Local Agency Investment Fund 10.9% Portfolio Investment Allocation 60,000,000 62,000,000 64,000,000 66,000,000 68,000,000 70,000,000 72,000,000 74,000,000 76,000,000 78,000,000 80,000,000 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Treasurer's Fund Balances page 2 Town of Los Gatos Non-Treasury Restricted Fund Balances July 31, 2018 JULY 18 JULY 18 JULY 18 Previous Deposits Ending Balance Realized Gain/Adj.Interest Withdrawals Balance Non-Treasury Funds: Cert. of Participation 2002 Series A Reserve Fund 690,883.03$ 718.91$ 3,978.28$ 687,623.66$ Note 1 Cert. Of Participation 2010 Ser A Lease Pymt Fund 51.74 0.04 51.78 Note 1 Cert. of Participation 2002 Lease Payment Fund 24.17 3,978.28 4,002.45 Note 1 Cert. of Participation 2010 Series Reserve Fund 1,294,905.06 1,755.79 1,296,660.85 Note 2 Total Restricted Funds:1,985,864.00$ $3,978.28 $2,474.74 $3,978.28 $1,988,338.74 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. Page 3 Town of Los Gatos Statement of Interest Earned July 31, 2018 Interest by Month July 2018 $84,433.16 August 2018 September 2018 October 2018 November 2018 December 2018 January 2019 February 2019 March 2019 April 2019 May 2019 June 2019 $84,433.16 Page 4 Town of Los Gatos Investment Schedule July 31, 2018 Orginal Issue Maturity Yield to Interest Interest Interest Days Deposit Par Original (Discount)Market Purchased Date or Maturity Received Earned Earned to Institution CUSIP #Security Date Value Cost Premium Value Interest Call Date or Call to Date Prior Yrs.Current FY Maturity Aug_17_Security Freddie Mac 3137EADZ9 Gov. Agency Debenture 08/01/16 1,000,000.00 1,005,560.00 5,560.00 991,404.00 4/15/2019 0.92%18,437.50$ 17,581.70$ 780.85$ 258 Toyota Motor Credit 89236TDE2 Corporate Bond 07/25/16 950,000.00 954,246.50 4,246.50 940,046.85 5/20/2019 1.24%24,198.61$ 22,779.63$ 1,001.66$ 293 FHLB 3133834H1 Gov. Agency Debenture 9/20/2017 1,785,000.00 1,776,432.00 (8,568.00)1,742,552.70 6/12/2020 1.56%17,862.40$ 21,464.29$ 2,351.21$ 682 US Bancorp 91159HHE3 Corporate Bond 8/8/2016 1,000,000.00 1,019,550.00 19,550.00 998,434.00 10/15/2018 1.08%34,504.17$ 19,987.80$ 896.70$ 76 Microsoft 594918BN3 Corporate Bond 8/8/2016 1,000,000.00 999,470.00 (530.00)985,822.00 8/8/2019 1.12%16,500.00$ 21,159.11$ 949.25$ 373 FFCB 3133EHEZ2 Gov. Agency Debenture 9/20/2017 1,600,000.00 1,602,304.00 2,304.00 1,571,536.00 4/6/2020 1.54%13,937.78$ 19,146.90$ 2,097.36$ 615 FNMA 3133EHYM9 Gov. Agency Debenture 9/21/2017 1,300,000.00 1,295,866.00 (4,134.00)1,266,499.00 9/14/2020 1.61%9,370.83$ 16,136.27$ 1,773.84$ 776 US Treasury 912828VF4 US Treasury Note 9/21/2017 1,000,000.00 997,109.38 (2,890.62)977,070.00 5/31/2020 1.48%9,504.78$ 11,452.54$ 1,258.97$ 670 FNMA 3136G0AW1 Gov. Agency Debenture 12/13/2017 2,000,000.00 2,017,900.00 17,900.00 1,979,200.00 10/16/2020 2.02%16,058.33$ 22,192.96$ 3,457.20$ 808 FNMA 3135G0N33 Gov. Agency Debenture 04/17/13 1,000,000.00 981,984.01 (18,015.99)984,298.00 802.08 8/2/2019 2.17%(802.08)$ 6,897.75$ 1,827.61$ 367 Oracle 68389XAG0 Corporate Bond 5/3/2018 1,000,000.00 1,028,370.00 28,370.00 1,021,857.00 7/8/2019 2.54%9,027.78$ 4,127.43$ 2,206.04$ 342 FHLB 3130A5H36 Gov. Agency Debenture 06/09/15 1,000,000.00 997,710.00 (2,290.00)999,300.00 8/27/2018 1.22%31,241.66$ 37,370.11$ 1,037.13$ 27 American Express 0258M0EE5 Corporate Bond 9/15/2017 1,000,000.00 1,007,980.00 7,980.00 986,874.00 1/2/2020 1.87%10,266.67$ 14,619.64$ 1,573.64$ 520 Treasury 912828F39 US Treasury Note 4/17/2018 1,200,000.00 1,190,343.75 (9,656.25)1,189,593.60 975.41 9/30/2019 2.32%(975.41)$ 5,603.23$ 2,347.30$ 426 FHLB 313383VN8 Gov. Agency Debenture 5/25/2018 2,000,000.00 1,989,800.00 (10,200.00)1,988,540.00 8,000.00 9/13/2019 2.40%(8,000.00)$ 4,716.63$ 4,061.55$ 409 Treasury 9128282K5 US Treasury Note 7/2/2018 1,000,000.00 989,218.75 (10,781.25)989,375.00 7/31/2019 2.39%1,101.52$ -$ 1,886.01$ 365 FreddieMac 3137EAEE5 Gov. Agency Debenture 12/20/2017 1,000,000.00 991,200.00 (8,800.00)984,546.00 1/17/2020 1.93%8,625.00$ 10,119.43$ 1,633.87$ 535 FNMA 3136G3TW5 Gov. Agency Debenture 7/25/2018 1,000,000.00 980,540.00 (19,460.00)979,680.00 12/30/2019 2.54%(798.61)$ -$ 412.29$ 517 FHLB 3130ACRP1 Gov. Agency Debenture 7/25/2018 1,500,000.00 1,479,404.42 (20,595.58)1,477,800.00 2/7/2020 2.59%(11,760.00)$ -$ 634.13$ 556 American Honda 02665WBZ3 Corporate Bond 4/11/2018 1,000,000.00 990,620.00 (9,380.00)988,101.00 11/13/2019 2.61%1,944.44$ 5,675.13$ 2,199.11$ 470 Disney 25468PDP8 Corporate Bond 12/1/2017 1,000,000.00 998,190.00 (1,810.00)984,103.00 3/4/2020 2.03%5,034.50$ 11,736.09$ 1,724.26$ 582 FFCB 3133EJPU7 Gov. Agency Debenture 6/1/2018 1,000,000.00 1,001,454.00 1,454.00 999,260.00 10/21/2019 2.38%(688.89)$ 1,887.24$ 2,017.40$ 447 FHLB 3130A6AE7 Gov. Agency Debenture 10/27/2015 1,000,000.00 1,005,030.00 5,030.00 998,878.00 9/14/2018 0.95%26,781.25$ 25,446.05$ 807.40$ 45 FFCB 3133EFHU4 Gov. Agency Debenture 10/29/2015 1,500,000.00 1,494,840.00 (5,160.00)1,496,580.00 10/9/2018 0.99%32,083.33$ 39,735.58$ 1,263.39$ 70 Chevron 166764AG5 Corporate Bond 11/9/2017 1,350,000.00 1,366,834.50 16,834.50 1,340,811.90 5/24/2020 1.94%20,477.81$ 16,684.10$ 2,219.77$ 663 FHLMC 3134G6S95 Gov. Agency Debenture 4/29/2016 1,000,000.00 1,008,050.00 8,050.00 997,130.00 12/17/2018 1.04%28,800.00$ 22,665.71$ 887.17$ 139 FFCB 3133EFQ67 Gov. Agency Debenture 4/29/2016 1,000,000.00 1,001,870.00 1,870.00 992,470.00 3/21/2019 1.09%21,975.56$ 23,767.91$ 930.31$ 233 FFCB 3133EGYP4 Gov. Agency Debenture 10/28/2016 1,000,000.00 997,507.00 (2,493.00)982,330.00 10/17/2019 1.14%15,429.17$ 18,950.83$ 963.08$ 443 FNMA 3135G0P49 Gov. Agency Debenture 11/15/2016 1,500,000.00 1,487,505.00 (12,495.00)1,476,486.00 - 8/28/2019 1.31%19,291.66$ 31,609.32$ 1,655.22$ 393 FHLMC 3137EAEB1 Gov. Agency Debenture 3/14/2017 2,000,000.00 1,970,180.00 (29,820.00)1,970,272.00 7/19/2019 1.52%23,576.39$ 39,136.50$ 2,564.97$ 353 FNMA 3135G0ZY2 Gov. Agency Debenture 12/20/2017 1,550,000.00 1,545,642.95 (4,357.05)1,533,794.75 11/26/2019 1.90%11,754.17$ 15,453.41$ 2,495.08$ 483 Freddie Mac 3134GBN40 Gov. Agency Debenture 9/29/2017 1,000,000.00 998,900.00 (1,100.00)980,000.00 6/29/2020 1.67%12,187.50$ 12,498.83$ 1,414.10$ 699 JP Morgan Chase 48125LRG9 Corporate Bond 3/28/2017 1,400,000.00 1,393,196.00 (6,804.00)1,380,873.20 8/23/2019 1.86%22,779.17$ 32,606.03$ 2,202.15$ 388 US Treasury 912828SN1 US Treasury Note 3/31/2017 1,000,000.00 1,004,218.75 4,218.75 994,727.00 - 3/31/2019 1.29%15,000.00$ 16,104.45$ 1,094.82$ 243 FNMA 3136FTB73 Gov. Agency Debenture 4/25/2017 1,000,000.00 1,013,390.00 13,390.00 989,880.00 2/7/2020 1.50%15,666.67$ 17,947.39$ 1,290.88$ 556 PNC Bank 69353REV6 Corporate Bond 4/4/2017 1,000,000.00 1,003,120.00 3,120.00 995,978.00 2/2/2019 1.29%17,875.00$ 22,039.96$ 1,511.59$ 186 Treasury 912828WS5 US Treasury Note 5/2/2017 500,000.00 503,339.84 3,339.84 496,308.50 6/30/2019 1.31%9,449.24$ 7,643.56$ 558.85$ 334 Pepsico 713448CS5 Corporate Bond 5/15/2017 1,250,000.00 1,249,600.00 (400.00)1,228,587.50 3/30/2020 1.31%22,161.46$ 26,195.95$ 1,975.85$ 608 Pfizer 717081EB5 Corporate Bond 6/30/2017 1,000,000.00 1,002,280.00 2,280.00 987,634.00 12/15/2019 1.60%16,291.67$ 16,073.27$ 1,365.13$ 502 Treasury 912828F62 US Treasury Note 6/30/2017 1,000,000.00 1,002,148.44 2,148.44 987,266.00 10/31/2019 1.41%12,513.59$ 14,080.68$ 1,195.89$ 457 Treasury 912828H52 US Treasury Note 6/30/2017 1,000,000.00 994,726.56 (5,273.44)980,352.00 1/31/2020 1.46%13,570.44$ 14,536.83$ 1,234.63$ 549 Toyota Motor Credit 89236TCF0 Corporate Bond 10/6/2017 500,000.00 503,545.00 3,545.00 492,402.00 3/12/2020 1.85%4,658.33$ 6,797.80$ 789.26$ 590 Berkshire Hathaway 084664CK5 Corporate Bond 1/22/2018 1,100,000.00 1,086,305.00 (13,695.00)1,083,934.50 6,236.39 8/15/2019 2.11%913.61$ 10,049.50$ 1,959.34$ 380 Freddie Mac 3134G44Y1 Gov. Agency Debenture 3/1/2018 1,500,000.00 1,482,225.00 (17,775.00)1,484,415.00 6/24/2019 2.11%5,885.42$ 10,696.53$ 2,740.43$ 328 Subtotal 51,409,706.85$ `50,897,002.50$ 16,013.88$ 573,712.42$ 715,374.12$ 71,246.68$ BNY MM 43,027.63 43,027.63 0.00%1 LAIF N/A 12/31/14 6,312,576.31 6,312,576.31 1.94%11,432.82 1 $57,765,310.79 $57,252,606.44 573,712.42$ 715,374.12$ 82,679.50$ Bank of the West Matured Assets Treasury 912828VK3 US Treasury Note 07/31/15 1,000,000.00 1,010,625.00 10,625.00 7/2/2018 1.00%40,091.71$ 29,514.78$ 55.43$ FHLB 3130A66L6_1 Gov. Agency Debenture 8/20/2015 1,250,000.00 1,247,075.00 (2,925.00)7/25/2018 1.13%38,791.67$ 40,433.71$ 967.31$ FHLB 3130A66L6_2 Gov. Agency Debenture 8/25/2015 1,000,000.00 999,500.00 (500.00)7/25/2018 1.07%30,887.50$ 30,406.07$ 730.92$ Total Investments "Matured"$0.00 573,712.42$ 715,374.12$ 84,433.16$ Maturity Profile Amount 0-1 year $23,833,757.78 1-2 years $31,628,412.01 2-3 years $3,313,766.00 3-5 years $0.00 $58,775,935.79 Amortized Institution Cost BNY Assets $51,409,706.85 BNY MM 43,027.63 LAIF 6,312,576.31 Totals:$57,765,310.79 Market to Cost Position Report Page 5 Town of Los Gatos Summary Investment Information August 31, 2018 Weighted Average YTM Portfolio Yield: 1.81%Weighted Average Maturity (days)369 This Month Last Month One year ago Portfolio Balance $67,641,614 $74,160,411 $70,086,827 Benchmarks/ References: Town's Average Yield 1.81%1.80%1.27% LAIF Yield for month 2.00%1.94%1.08% 3 mo. Treasury 2.01%2.02%0.99% 6 mo. Treasury 2.27%2.19%1.08% 2 yr. Treasury 2.63%2.67%1.33% 5 yr. Treasury (most recent)2.74%2.85%1.70% 10 Yr. Treasury 2.86%2.96%2.12% 0 -1 year 30% 1 -2 years 30% 2 -3 years 25% 3 -5 years 15% Portfolio Maturity Profile Compliance:The Town's investments are in compliance with the Town's investment policy dated May 15, 2018 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 Gatos Portfolio Allocation & Treasurer's Fund Balances August 31, 2018 Month YTD Fund Balances - Beginning of Month/Period $74,160,410.55 $76,649,992.26 Receipts 2,644,559.87 4,833,946.06 Disbursements (9,163,356.09)(13,842,283.99) Fund Balances - End of Month/Period $67,641,614.33 $67,641,654.33 Portfolio Allocation:% of Portfolio Max. % 0r $ Allowed Per State Law or Policy BNY MM $96,985.90 0.17%20% of Town Portfolio US Treasury Notes $6,681,105.47 11.55%No Max. on US Treasuries Government Agency Debenture Notes $30,126,764.38 52.10%No Max. on Non-Mortgage Backed Corporate Medium Term Bonds $14,603,307.00 25.26%30% of Town Portfolio Local Agency Investment Fund 6,312,576.31 10.92%$65M per State Law Subtotal - Investments 57,820,739.06 100.00% Reconciled Demand Deposit Balances 9,820,875.27 Total Treasurer's Fund $67,641,614.33 BNY MM 0.17%US Treasury Notes 11.55% Government Agency Debenture Notes 52.10% Corporate Medium Term Bonds 25.3% Local Agency Investment Fund 10.9% Portfolio Investment Allocation 60,000,000 62,000,000 64,000,000 66,000,000 68,000,000 70,000,000 72,000,000 74,000,000 76,000,000 78,000,000 80,000,000 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Treasurer's Fund Balances page 2 Town of Los Gatos Non-Treasury Restricted Fund Balances August 31, 2018 AUG 18 AUG 18 AUG 18 Previous Deposits Ending Balance Realized Gain/Adj.Interest Withdrawals Balance Non-Treasury Funds: Cert. of Participation 2002 Series A Reserve Fund 687,623.66$ 790.97$ 688,414.63$ Note 1 Cert. Of Participation 2010 Ser A Lease Pymt Fund 51.78 1,024,710.76 0.04 1,024,762.50 0.08 Note 1 Cert. of Participation 2002 Lease Payment Fund 4,002.45 516,730.83 2.38 516,755.00 3,980.66 Note 1 Cert. of Participation 2010 Series Reserve Fund 1,296,660.85 1,905.10 1,298,565.95 Note 2 Total Restricted Funds:1,988,338.74$ $1,541,441.59 $2,698.49 $1,541,517.50 $1,990,961.32 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. Page 3 Town of Los Gatos Statement of Interest Earned August 31, 2018 Interest by Month July 2018 $84,433.16 August 2018 87,305.09 September 2018 October 2018 November 2018 December 2018 January 2019 February 2019 March 2019 April 2019 May 2019 June 2019 $171,738.25 Page 4 Town of Los Gatos Investment Schedule August 31, 2018 Orginal Issue Maturity Yield to Interest Interest Interest Days Deposit Par Original (Discount)Market Purchased Date or Maturity Received Earned Earned to Institution CUSIP #Security Date Value Cost Premium Value Interest Call Date or Call to Date Prior Yrs.Current FY Maturity Aug_17_Security Freddie Mac 3137EADZ9 Gov. Agency Debenture 08/01/16 1,000,000.00 1,005,560.00 5,560.00 992,542.00 4/15/2019 0.92%18,437.50$ 17,581.70$ 1,561.70$ 227 Toyota Motor Credit 89236TDE2 Corporate Bond 07/25/16 950,000.00 954,246.50 4,246.50 942,220.45 5/20/2019 1.24%24,198.61$ 22,779.63$ 2,003.32$ 262 FHLB 3133834H1 Gov. Agency Debenture 9/20/2017 1,785,000.00 1,776,432.00 (8,568.00)1,746,140.55 6/12/2020 1.56%17,862.40$ 21,464.29$ 4,702.42$ 651 US Bancorp 91159HHE3 Corporate Bond 8/8/2016 1,000,000.00 1,019,550.00 19,550.00 999,360.00 10/15/2018 1.08%34,504.17$ 19,987.80$ 1,793.41$ 45 Microsoft 594918BN3 Corporate Bond 8/8/2016 1,000,000.00 999,470.00 (530.00)987,256.00 8/8/2019 1.12%22,000.00$ 21,159.11$ 1,898.50$ 342 FFCB 3133EHEZ2 Gov. Agency Debenture 9/20/2017 1,600,000.00 1,602,304.00 2,304.00 1,574,032.00 4/6/2020 1.54%13,937.78$ 19,146.90$ 4,194.73$ 584 FNMA 3133EHYM9 Gov. Agency Debenture 9/21/2017 1,300,000.00 1,295,866.00 (4,134.00)1,268,579.00 9/14/2020 1.61%9,370.83$ 16,136.27$ 3,547.69$ 745 US Treasury 912828VF4 US Treasury Note 9/21/2017 1,000,000.00 997,109.38 (2,890.62)978,945.00 5/31/2020 1.48%9,504.78$ 11,452.54$ 2,517.93$ 639 FNMA 3136G0AW1 Gov. Agency Debenture 12/13/2017 2,000,000.00 2,017,900.00 17,900.00 1,982,800.00 10/16/2020 2.02%16,058.33$ 22,192.96$ 6,914.39$ 777 FNMA 3135G0N33 Gov. Agency Debenture 04/17/13 1,000,000.00 981,984.01 (18,015.99)985,625.00 8/2/2019 2.17%3,572.92$ 6,897.75$ 3,655.22$ 336 Oracle 68389XAG0 Corporate Bond 5/3/2018 1,000,000.00 1,028,370.00 28,370.00 1,020,025.00 7/8/2019 2.54%9,027.78$ 4,127.43$ 4,412.08$ 311 FHLB 3130AEU73 Gov. Agency Debenture 8/27/2018 1,000,000.00 999,180.00 (820.00)999,160.00 8/27/2019 2.46%-$ -$ 269.26$ 361 American Express 0258M0EE5 Corporate Bond 9/15/2017 1,000,000.00 1,007,980.00 7,980.00 987,835.00 1/2/2020 1.87%10,266.67$ 14,619.64$ 3,147.28$ 489 Treasury 912828F39 US Treasury Note 4/17/2018 1,200,000.00 1,190,343.75 (9,656.25)1,190,484.00 975.41 9/30/2019 2.32%(975.41)$ 5,603.23$ 4,694.60$ 395 FHLB 313383VN8 Gov. Agency Debenture 5/25/2018 2,000,000.00 1,989,800.00 (10,200.00)1,988,620.00 8,000.00 9/13/2019 2.40%(8,000.00)$ 4,716.63$ 8,123.09$ 378 Treasury 9128282K5 US Treasury Note 7/2/2018 1,000,000.00 989,218.75 (10,781.25)990,430.00 7/31/2019 2.39%1,101.52$ -$ 3,902.09$ 334 FreddieMac 3137EAEE5 Gov. Agency Debenture 12/20/2017 1,000,000.00 991,200.00 (8,800.00)985,534.00 1/17/2020 1.93%8,625.00$ 10,119.43$ 3,267.73$ 504 FNMA 3136G3TW5 Gov. Agency Debenture 7/25/2018 1,000,000.00 980,540.00 (19,460.00)981,680.00 798.61 12/30/2019 2.54%(798.61)$ -$ 2,542.46$ 486 FHLB 3130ACRP1 Gov. Agency Debenture 7/25/2018 1,500,000.00 1,479,404.42 (20,595.58)1,480,815.00 2/7/2020 2.59%840.00$ -$ 3,910.46$ 525 American Honda 02665WBZ3 Corporate Bond 4/11/2018 1,000,000.00 990,620.00 (9,380.00)990,252.00 11/13/2019 2.61%1,944.44$ 5,675.13$ 4,398.22$ 439 Disney 25468PDP8 Corporate Bond 12/1/2017 1,000,000.00 998,190.00 (1,810.00)987,186.00 3/4/2020 2.03%5,034.50$ 11,736.09$ 3,448.52$ 551 FFCB 3133EJPU7 Gov. Agency Debenture 6/1/2018 1,000,000.00 1,001,454.00 1,454.00 999,220.00 688.89 10/21/2019 2.38%(688.89)$ 1,887.24$ 4,034.80$ 416 FHLB 3130A6AE7 Gov. Agency Debenture 10/27/2015 1,000,000.00 1,005,030.00 5,030.00 999,717.00 9/14/2018 0.95%26,781.25$ 25,446.05$ 1,614.80$ 14 FFCB 3133EFHU4 Gov. Agency Debenture 10/29/2015 1,500,000.00 1,494,840.00 (5,160.00)1,498,080.00 10/9/2018 0.99%32,083.33$ 39,735.58$ 2,526.78$ 39 Chevron 166764AG5 Corporate Bond 11/9/2017 1,350,000.00 1,366,834.50 16,834.50 1,341,924.30 5/24/2020 1.94%20,477.81$ 16,684.10$ 4,439.54$ 632 FHLMC 3134G6S95 Gov. Agency Debenture 4/29/2016 1,000,000.00 1,008,050.00 8,050.00 997,520.00 12/17/2018 1.04%28,800.00$ 22,665.71$ 1,774.34$ 108 FFCB 3133EFQ67 Gov. Agency Debenture 4/29/2016 1,000,000.00 1,001,870.00 1,870.00 993,500.00 3/21/2019 1.09%21,975.56$ 23,767.91$ 1,860.62$ 202 FFCB 3133EGYP4 Gov. Agency Debenture 10/28/2016 1,000,000.00 997,507.00 (2,493.00)983,540.00 10/17/2019 1.14%15,429.17$ 18,950.83$ 1,926.15$ 412 FNMA 3135G0P49 Gov. Agency Debenture 11/15/2016 1,500,000.00 1,487,505.00 (12,495.00)1,478,557.50 8/28/2019 1.31%26,791.66$ 31,609.32$ 3,310.44$ 362 FHLMC 3137EAEB1 Gov. Agency Debenture 3/14/2017 2,000,000.00 1,970,180.00 (29,820.00)1,973,344.00 7/19/2019 1.52%23,576.39$ 39,136.50$ 5,129.94$ 322 FNMA 3135G0ZY2 Gov. Agency Debenture 12/20/2017 1,550,000.00 1,545,642.95 (4,357.05)1,535,279.65 11/26/2019 1.90%11,754.17$ 15,453.41$ 4,990.16$ 452 Freddie Mac 3134GBN40 Gov. Agency Debenture 9/29/2017 1,000,000.00 998,900.00 (1,100.00)982,350.00 6/29/2020 1.67%12,187.50$ 12,498.83$ 2,828.20$ 668 JP Morgan Chase 48125LRG9 Corporate Bond 3/28/2017 1,400,000.00 1,393,196.00 (6,804.00)1,384,600.00 8/23/2019 1.86%22,779.17$ 32,606.03$ 4,404.30$ 357 US Treasury 912828SN1 US Treasury Note 3/31/2017 1,000,000.00 1,004,218.75 4,218.75 995,547.00 3/31/2019 1.29%15,000.00$ 16,104.45$ 2,189.64$ 212 FNMA 3136FTB73 Gov. Agency Debenture 4/25/2017 1,000,000.00 1,013,390.00 13,390.00 987,970.00 2/7/2020 1.50%25,666.67$ 17,947.39$ 2,581.76$ 525 PNC Bank 69353REV6 Corporate Bond 4/4/2017 1,000,000.00 1,003,120.00 3,120.00 997,326.00 2/2/2019 1.29%17,875.00$ 22,039.96$ 3,023.18$ 155 Treasury 912828WS5 US Treasury Note 5/2/2017 500,000.00 503,339.84 3,339.84 496,719.00 6/30/2019 1.31%9,449.24$ 7,643.56$ 1,117.69$ 303 Pepsico 713448CS5 Corporate Bond 5/15/2017 1,250,000.00 1,249,600.00 (400.00)1,231,150.00 3/30/2020 1.31%22,161.46$ 26,195.95$ 3,951.70$ 577 Pfizer 717081EB5 Corporate Bond 6/30/2017 1,000,000.00 1,002,280.00 2,280.00 989,258.00 12/15/2019 1.60%16,291.67$ 16,073.27$ 2,730.25$ 471 Treasury 912828F62 US Treasury Note 6/30/2017 1,000,000.00 1,002,148.44 2,148.44 988,242.00 10/31/2019 1.41%12,513.59$ 14,080.68$ 2,391.79$ 426 Treasury 912828H52 US Treasury Note 6/30/2017 1,000,000.00 994,726.56 (5,273.44)981,992.00 1/31/2020 1.46%13,570.44$ 14,536.83$ 2,469.27$ 518 Toyota Motor Credit 89236TCF0 Corporate Bond 10/6/2017 500,000.00 503,545.00 3,545.00 494,960.00 3/12/2020 1.85%4,658.33$ 6,797.80$ 1,578.52$ 559 Berkshire Hathaway 084664CK5 Corporate Bond 1/22/2018 1,100,000.00 1,086,305.00 (13,695.00)1,086,830.80 8/15/2019 2.11%8,063.61$ 10,049.50$ 3,918.67$ 349 Freddie Mac 3134G44Y1 Gov. Agency Debenture 3/1/2018 1,500,000.00 1,482,225.00 (17,775.00)1,486,020.00 6/24/2019 2.11%5,885.42$ 10,696.53$ 5,480.87$ 297 Subtotal 51,411,176.85$ `50,963,168.25$ 10,462.91$ 589,595.76$ 678,004.01$ 145,178.51$ BNY MM 96,985.90 96,985.90 0.00%1 LAIF N/A 12/31/14 6,312,576.31 6,312,576.31 1.99%22,865.65 1 $57,820,739.06 $57,372,730.46 589,595.76$ 678,004.01$ 168,044.16$ Bank of the West Matured Assets Treasury 912828VK3 US Treasury Note 07/31/15 1,000,000.00 1,010,625.00 10,625.00 7/2/2018 1.00%40,091.71$ 29,514.78$ 55.43$ FHLB 3130A66L6_1 Gov. Agency Debenture 8/20/2015 1,250,000.00 1,247,075.00 (2,925.00)7/25/2018 1.13%38,791.67$ 40,433.71$ 967.31$ FHLB 3130A66L6_2 Gov. Agency Debenture 8/25/2015 1,000,000.00 999,500.00 (500.00)7/25/2018 1.07%30,887.50$ 30,406.07$ 730.92$ FHLB 3130A5H36 Gov. Agency Debenture 06/09/15 1,000,000.00 997,710.00 (2,290.00)8/27/2018 1.22%36,991.66$ 37,370.11$ 1,940.44$ 0 Total Investments "Matured"$997,710.00 736,358.30$ 815,728.68$ 171,738.25$ Maturity Profile Amount 0-1 year $29,837,646.06 1-2 years $25,679,952.00 2-3 years $3,313,766.00 3-5 years $0.00 $58,831,364.06 Amortized Institution Cost BNY Assets $51,411,176.85 BNY MM 96,985.90 LAIF 6,312,576.31 Totals:$57,820,739.06 Market to Cost Position Report Page 5 Town of Los Gatos Summary Investment Information September 30, 2018 Weighted Average YTM Portfolio Yield: 1.84%Weighted Average Maturity (days)353 This Month Last Month One year ago Portfolio Balance $63,940,263 $74,160,411 $67,380,046 Benchmarks/ References: Town's Average Yield 1.84%1.81%1.37% LAIF Yield for month 2.06%2.00%1.11% 3 mo. Treasury 2.06%2.01%1.05% 6 mo. Treasury 2.37%2.27%1.19% 2 yr. Treasury 2.82%2.63%1.49% 5 yr. Treasury (most recent)2.95%2.74%1.94% 10 Yr. Treasury 3.06%2.86%2.33% 0 -1 year 30% 1 -2 years 30% 2 -3 years 25% 3 -5 years 15% Portfolio Maturity Profile Compliance:The Town's investments are in compliance with the Town's investment policy dated May 16, 2017 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 Gatos Portfolio Allocation & Treasurer's Fund Balances September 30, 2018 Month YTD Fund Balances - Beginning of Month/Period $67,641,614.33 $76,649,992.26 Receipts 2,303,955.04 7,137,901.10 Disbursements (6,005,306.15)(19,847,590.14) Fund Balances - End of Month/Period $63,940,263.22 $63,940,303.22 Portfolio Allocation:% of Portfolio Max. % 0r $ Allowed Per State Law or Policy BNY MM $179,360.70 0.31%20% of Town Portfolio US Treasury Notes $6,681,105.47 11.54%No Max. on US Treasuries Government Agency Debenture Notes $30,119,835.38 52.02%No Max. on Non-Mortgage Backed Corporate Medium Term Bonds $14,603,307.00 25.22%30% of Town Portfolio Local Agency Investment Fund 6,312,576.31 10.90%$65M per State Law Subtotal - Investments 57,896,184.86 100.00% Reconciled Demand Deposit Balances 6,044,078.36 Total Treasurer's Fund $63,940,263.22 BNY MM 0.31%US Treasury Notes 11.54% Government Agency Debenture Notes 52.02% Corporate Medium Term Bonds 25.2% Local Agency Investment Fund 10.9% Portfolio Investment Allocation 60,000,000 62,000,000 64,000,000 66,000,000 68,000,000 70,000,000 72,000,000 74,000,000 76,000,000 78,000,000 80,000,000 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Treasurer's Fund Balances page 2 Town of Los Gatos Non-Treasury Restricted Fund Balances September 30, 2018 SEP 18 SEP 18 SEP 18 Previous Deposits Ending Balance Realized Gain/Adj.Interest Withdrawals Balance Non-Treasury Funds: Cert. of Participation 2002 Series A Reserve Fund 688,414.63$ 806.91$ 689,221.54$ Note 1 Cert. Of Participation 2010 Ser A Lease Pymt Fund 0.08 0.01 0.09 Note 1 Cert. of Participation 2002 Lease Payment Fund 3,980.66 4.66 3,985.32 Note 1 Cert. of Participation 2010 Series Reserve Fund 1,298,565.95 1,978.13 1,300,544.08 Note 2 Total Restricted Funds:1,990,961.32$ $0.00 $2,789.71 $0.00 $1,993,751.03 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. Page 3 Town of Los Gatos Statement of Interest Earned September 30, 2018 Interest by Month July 2018 $84,433.16 August 2018 87,305.09 September 2018 86,525.12 October 2018 November 2018 December 2018 January 2019 February 2019 March 2019 April 2019 May 2019 June 2019 $258,263.37 Page 4 Town of Los Gatos Investment Schedule September 30, 2018 Orginal Issue Maturity Yield to Interest Interest Interest Days Deposit Par Original (Discount)Market Purchased Date or Maturity Received Earned Earned to Institution CUSIP #Security Date Value Cost Premium Value Interest Call Date or Call to Date Prior Yrs.Current FY Maturity Aug_17_Security Freddie Mac 3137EADZ9 Gov. Agency Debenture 08/01/16 1,000,000.00 1,005,560.00 5,560.00 992,930.00 4/15/2019 0.92%18,437.50$ 17,581.70$ 2,317.36$ 197 Toyota Motor Credit 89236TDE2 Corporate Bond 07/25/16 950,000.00 954,246.50 4,246.50 942,653.65 5/20/2019 1.24%24,198.61$ 22,779.63$ 2,972.66$ 232 FHLB 3133834H1 Gov. Agency Debenture 9/20/2017 1,785,000.00 1,776,432.00 (8,568.00)1,742,392.05 6/12/2020 1.56%17,862.40$ 21,464.29$ 6,977.79$ 621 US Bancorp 91159HHE3 Corporate Bond 8/8/2016 1,000,000.00 1,019,550.00 19,550.00 999,390.00 10/15/2018 1.08%34,504.17$ 19,987.80$ 2,661.18$ 15 Microsoft 594918BN3 Corporate Bond 8/8/2016 1,000,000.00 999,470.00 (530.00)987,179.00 8/8/2019 1.12%22,000.00$ 21,159.11$ 2,817.13$ 312 FFCB 3133EHEZ2 Gov. Agency Debenture 9/20/2017 1,600,000.00 1,602,304.00 2,304.00 1,571,840.00 4/6/2020 1.54%13,937.78$ 19,146.90$ 6,224.43$ 554 FNMA 3133EHYM9 Gov. Agency Debenture 9/21/2017 1,300,000.00 1,295,866.00 (4,134.00)1,267,162.00 9/14/2020 1.61%19,120.83$ 16,136.27$ 5,264.31$ 715 US Treasury 912828VF4 US Treasury Note 9/21/2017 1,000,000.00 997,109.38 (2,890.62)976,992.00 5/31/2020 1.48%9,504.78$ 11,452.54$ 3,736.29$ 609 FNMA 3136G0AW1 Gov. Agency Debenture 12/13/2017 2,000,000.00 2,017,900.00 17,900.00 1,978,840.00 10/16/2020 2.02%16,058.33$ 22,192.96$ 10,260.06$ 747 FNMA 3135G0N33 Gov. Agency Debenture 04/17/13 1,000,000.00 981,984.01 (18,015.99)985,967.00 8/2/2019 2.17%3,572.92$ 6,897.75$ 5,423.87$ 306 Oracle 68389XAG0 Corporate Bond 5/3/2018 1,000,000.00 1,028,370.00 28,370.00 1,017,288.00 7/8/2019 2.54%9,027.78$ 4,127.43$ 6,546.96$ 281 FHLB 3130AEU73 Gov. Agency Debenture 8/27/2018 1,000,000.00 999,180.00 (820.00)997,800.00 8/27/2019 2.46%-$ -$ 2,288.71$ 331 American Express 0258M0EE5 Corporate Bond 9/15/2017 1,000,000.00 1,007,980.00 7,980.00 988,800.00 1/2/2020 1.87%21,266.67$ 14,619.64$ 4,670.16$ 459 Treasury 912828F39 US Treasury Note 4/17/2018 1,200,000.00 1,190,343.75 (9,656.25)1,189,219.20 9/30/2019 2.32%9,524.59$ 5,603.23$ 6,966.17$ 365 FHLB 313383VN8 Gov. Agency Debenture 5/25/2018 2,000,000.00 1,989,800.00 (10,200.00)1,988,080.00 9/13/2019 2.40%12,000.00$ 4,716.63$ 12,053.62$ 348 Treasury 9128282K5 US Treasury Note 7/2/2018 1,000,000.00 989,218.75 (10,781.25)990,117.00 7/31/2019 2.39%1,101.52$ -$ 5,853.13$ 304 FreddieMac 3137EAEE5 Gov. Agency Debenture 12/20/2017 1,000,000.00 991,200.00 (8,800.00)984,399.00 1/17/2020 1.93%8,625.00$ 10,119.43$ 4,848.90$ 474 FNMA 3136G3TW5 Gov. Agency Debenture 7/25/2018 1,000,000.00 980,540.00 (19,460.00)980,860.00 798.61 12/30/2019 2.54%(798.61)$ -$ 4,603.92$ 456 FHLB 3130ACRP1 Gov. Agency Debenture 7/25/2018 1,500,000.00 1,479,404.42 (20,595.58)1,478,625.00 2/7/2020 2.59%840.00$ -$ 7,081.10$ 495 American Honda 02665WBZ3 Corporate Bond 4/11/2018 1,000,000.00 990,620.00 (9,380.00)990,007.00 11/13/2019 2.61%1,944.44$ 5,675.13$ 6,526.40$ 409 Disney 25468PDP8 Corporate Bond 12/1/2017 1,000,000.00 998,190.00 (1,810.00)986,399.00 3/4/2020 2.03%14,784.50$ 11,736.09$ 5,117.16$ 521 FFCB 3133EJPU7 Gov. Agency Debenture 6/1/2018 1,000,000.00 1,001,454.00 1,454.00 998,410.00 688.89 10/21/2019 2.38%(688.89)$ 1,887.24$ 5,987.12$ 386 FHLB 3130AECJ7 Gov. Agency Debenture 9/14/2018 1,000,000.00 998,101.00 (1,899.00)997,178.00 8,239.58 5/28/2020 2.46%(8,239.58)$ -$ 1,199.53$ 606 FFCB 3133EFHU4 Gov. Agency Debenture 10/29/2015 1,500,000.00 1,494,840.00 (5,160.00)1,499,535.00 10/9/2018 0.99%32,083.33$ 39,735.58$ 3,749.41$ 9 Chevron 166764AG5 Corporate Bond 11/9/2017 1,350,000.00 1,366,834.50 16,834.50 1,338,453.45 5/24/2020 1.94%20,477.81$ 16,684.10$ 6,587.71$ 602 FHLMC 3134G6S95 Gov. Agency Debenture 4/29/2016 1,000,000.00 1,008,050.00 8,050.00 998,090.00 12/17/2018 1.04%28,800.00$ 22,665.71$ 2,632.89$ 78 FFCB 3133EFQ67 Gov. Agency Debenture 4/29/2016 1,000,000.00 1,001,870.00 1,870.00 993,970.00 3/21/2019 1.09%27,775.56$ 23,767.91$ 2,760.92$ 172 FFCB 3133EGYP4 Gov. Agency Debenture 10/28/2016 1,000,000.00 997,507.00 (2,493.00)986,320.00 10/17/2019 1.14%15,429.17$ 18,950.83$ 2,858.16$ 382 FNMA 3135G0P49 Gov. Agency Debenture 11/15/2016 1,500,000.00 1,487,505.00 (12,495.00)1,478,380.50 8/28/2019 1.31%26,791.66$ 31,609.32$ 4,912.26$ 332 FHLMC 3137EAEB1 Gov. Agency Debenture 3/14/2017 2,000,000.00 1,970,180.00 (29,820.00)1,973,688.00 7/19/2019 1.52%23,576.39$ 39,136.50$ 7,612.17$ 292 FNMA 3135G0ZY2 Gov. Agency Debenture 12/20/2017 1,550,000.00 1,545,642.95 (4,357.05)1,533,585.50 11/26/2019 1.90%11,754.17$ 15,453.41$ 7,404.76$ 422 Freddie Mac 3134GBN40 Gov. Agency Debenture 9/29/2017 1,000,000.00 998,900.00 (1,100.00)979,980.00 6/29/2020 1.67%12,187.50$ 12,498.83$ 4,196.69$ 638 JP Morgan Chase 48125LRG9 Corporate Bond 3/28/2017 1,400,000.00 1,393,196.00 (6,804.00)1,384,208.00 8/23/2019 1.86%34,329.17$ 32,606.03$ 6,535.41$ 327 US Treasury 912828SN1 US Treasury Note 3/31/2017 1,000,000.00 1,004,218.75 4,218.75 995,391.00 3/31/2019 1.29%22,500.00$ 16,104.45$ 3,249.14$ 182 FNMA 3136FTB73 Gov. Agency Debenture 4/25/2017 1,000,000.00 1,013,390.00 13,390.00 989,750.00 2/7/2020 1.50%25,666.67$ 17,947.39$ 3,831.00$ 495 PNC Bank 69353REV6 Corporate Bond 4/4/2017 1,000,000.00 1,003,120.00 3,120.00 997,260.00 2/2/2019 1.29%27,625.00$ 22,039.96$ 4,486.01$ 125 Treasury 912828WS5 US Treasury Note 5/2/2017 500,000.00 503,339.84 3,339.84 496,640.50 6/30/2019 1.31%9,449.24$ 7,643.56$ 1,658.51$ 273 Pepsico 713448CS5 Corporate Bond 5/15/2017 1,250,000.00 1,249,600.00 (400.00)1,230,135.00 3/30/2020 1.31%22,161.46$ 26,195.95$ 5,863.81$ 547 Pfizer 717081EB5 Corporate Bond 6/30/2017 1,000,000.00 1,002,280.00 2,280.00 986,536.00 12/15/2019 1.60%16,291.67$ 16,073.27$ 4,051.35$ 441 Treasury 912828F62 US Treasury Note 6/30/2017 1,000,000.00 1,002,148.44 2,148.44 987,383.00 10/31/2019 1.41%12,513.59$ 14,080.68$ 3,549.10$ 396 Treasury 912828H52 US Treasury Note 6/30/2017 1,000,000.00 994,726.56 (5,273.44)980,625.00 1/31/2020 1.46%13,570.44$ 14,536.83$ 3,664.08$ 488 Toyota Motor Credit 89236TCF0 Corporate Bond 10/6/2017 500,000.00 503,545.00 3,545.00 495,198.00 3/12/2020 1.85%10,033.33$ 6,797.80$ 2,342.31$ 529 Berkshire Hathaway 084664CK5 Corporate Bond 1/22/2018 1,100,000.00 1,086,305.00 (13,695.00)1,086,735.10 8/15/2019 2.11%8,063.61$ 10,049.50$ 5,814.80$ 319 Freddie Mac 3134G44Y1 Gov. Agency Debenture 3/1/2018 1,500,000.00 1,482,225.00 (17,775.00)1,485,900.00 6/24/2019 2.11%5,885.42$ 10,696.53$ 8,132.90$ 267 Subtotal 51,404,247.85$ `50,930,291.95$ 9,727.08$ 655,549.93$ 652,557.95$ 218,291.38$ BNY MM 179,360.70 179,360.70 0.00%1 LAIF N/A 12/31/14 6,312,576.31 6,312,576.31 2.06%34,298.47 1 $57,896,184.86 $57,422,228.96 655,549.93$ 652,557.95$ 252,589.85$ Bank of the West Matured Assets Treasury 912828VK3 US Treasury Note 07/31/15 1,000,000.00 1,010,625.00 10,625.00 7/2/2018 1.00%40,091.71$ 29,514.78$ 55.43$ FHLB 3130A66L6_1 Gov. Agency Debenture 8/20/2015 1,250,000.00 1,247,075.00 (2,925.00)7/25/2018 1.13%38,791.67$ 40,433.71$ 967.31$ FHLB 3130A66L6_2 Gov. Agency Debenture 8/25/2015 1,000,000.00 999,500.00 (500.00)7/25/2018 1.07%30,887.50$ 30,406.07$ 730.92$ FHLB 3130A5H36 Gov. Agency Debenture 06/09/15 1,000,000.00 997,710.00 (2,290.00)8/27/2018 1.22%36,991.66$ 37,370.11$ 1,940.44$ 0 FHLB 3130A6AE7 Gov. Agency Debenture 10/27/2015 1,000,000.00 1,005,030.00 5,030.00 9/14/2018 0.95%32,406.25$ 25,446.05$ 1,979.43$ 0 Total Investments "Matured"$2,002,740.00 834,718.72$ 815,728.68$ 258,263.37$ Maturity Profile Amount 0-1 year $32,095,134.61 1-2 years $24,793,775.25 2-3 years $2,017,900.00 3-5 years $0.00 $58,906,809.86 Amortized Institution Cost BNY Assets $51,404,247.85 BNY MM 179,360.70 LAIF 6,312,576.31 Totals:$57,896,184.86 Market to Cost Position Report Page 5