Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Attachment 1
Weighted Average Portfolio Yield: Portfolio Balance Benchmarks/ References: Town's Average Yield LAIF Yield for month 3 mo. Treasury 6 mo. Treasury 2 yr. Treasury 5 yr. Treasury (most recent) 10 Yr. Treasury 2 - 3 years 25% Town of Los Gatos Summary Investment Information December 31, 2016 0.88% Weighted Average Maturity (days) 395 This Month Last Month One year ago $70,272,720 $68,749,199 $68,016,721 0.88% 0.72% 0.50% 0.61% 1.19% 1.93% 2.45% 3 - 5 years 0.88% 0.68% 0.49% 0.61% 1.12% 1.85% 2.39% Portfolio Maturity Profile 0.76% 0.40% 0.16% 0.49% 1.06% 1.76% 2.19% 1-2yea rs 30% Compliance: The Town's investments are in compliance with the Town's investment policy dated November 1, 2016 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 Gatos Portfolio Allocation & Treasurer's Fund Balances December 31, 2016 Month YTD Fund Balances - Beginning of Month/Period $68,749,198.93 $74,913,936.39 Receipts 4,571,275.31 18,294,639.52 Disbursements (3,047,753.79) (22,935,855.46) Fund Balances - End of Month/Period $70,272,720.45 $70,272,720.45 Portfolio Allocation: BNY MM US Govt Agencies & Corp. Bonds Local Agency Investment Fund Subtotal - Investments Reconciled Demand Deposit Balances Total Treasurer's Fund Local Agency Investment Fund 7.96% $270,720.59 48,304,393.42 4,198, 679.25 52,773,793.26 17,498,927.19 $70,272,720.45 Portfolio Investment Allocation BNY MM 0.51% US Govt Agencies & Corp. Bonds 91.53% 76,000,000 74,000,000 72,000,000 70,000,000 68,000,000 66,000,000 64,000,000 62,000,000 60,000,000 ul 0 Treasurer's Fund Balances .tD. a (0 0 .�-, .L-1 .'�-, 1Oi ti e 'n ID v n O Z a a page 2 Town of Los Gatos Non -Treasury Restricted Fund Balances December 31, 2016 Non -Treasury Funds: Cert. of Participation 2002 Series A Reserve Fund Cert. Of Participation 2002 Ser A Lease Pymt Fund Cert. of Participation 2002 Series A Const. Fund COP 2010 Library Reserve Fund Total Restricted Funds: DEC 16 DEC 16 DEC 16 Previous Deposits Ending Balance Realized Gain/Adi. Interest Withdrawals Balance $ 686,314.38 $ (63.38) $ 5.66 $ 4.88 0.00 0.00 14.81 63.38 0.00 1,277,905.80 0.00 228.31 $1,964,239.87 $0.00 $233.97 These accounts are not part of the Treasurer's fund balances reported elsewhere in this report, as they are for separate and distinct entities. 0.00 0.00 0.00 $0.00 $ 686,256.66 4.88 78.19 1,278,134.11 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. October includes gain on sale of zmoney market fund of $255.50 and reconciling adjustment for Sep 16 interest. 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. $1,964,473.84 Note 1 Note 1 Nate 1 Note 2 Page 3 Town of Los Gatos Statement of Interest Earned December 31, 2016 Interest by Month July 2016 August 2016 September 2016 October 2016 November 2016 December 2016 January 2017 February 2017 March 2017 April 2017 May 2017 June 2017 $40,143.04 41,290.98 39,945.53 40,937.76 41,154.71 42,859.62 $246,331.64 Page 4 Town of Los Gatos Investment Schedule December 31, 2016 Orginal Issue Maturity Yield to Interest Interest Interest Days Deposit Par Original (Discount) Market Purchased Date or Maturity Received Earned Earned to InstButbn Securd�L Date Value Cost Premium Value Interest Call Date or Call to Date Prior Yrs. Current FY Maturity 9012E8 Corporate Note 03/11/15 750,000.00 753,037.50 3,037.50 750,051.38 5/15/2017 0.91% $ 13,727.08 $ 8,855.98 $ 3,452.33 135 Freddie Mac Coupon Note 08/01/16 1,000,000.00 1,005,560.00 5,560.00 995,953.00 4/15/2019 0.92% $ 1,562.50 $ - $ 3,828.68 835 Toyota Motor Credit Coupon Note 07/10/15 500,000.00 502,200.00 2,200.00 499,934.00 10/5/2017 1.0534 5 7,725.69 $ 5,138.43 $ 2,655.82 278 Toyota Motor Credit Corporate Note 07/25/16 950,000.00 954,246.50 4,246.50 939,221.30 5/20/2019 1.24% 5 4,248.61 $ - 5 5,137.53 870 FNMA Callable Note 04/04/13 4,000,000.00 4,004,800.00 4,800.00 4,000,720.00 3/14/2017 0.7294 5 103,333.33 $ 93,289.54 $ 145,509.95 73 Treasury Note 05/27/14 2,000,000.00 2,015,156.25 15,156.25 2,002,476.00 3/31/2017 0.73% 5 46,885.25 $ 30,758.49 $ 7,398.12 90 Treasury Note 06/23/14 500,000.00 499,804.69 (195.31) 500,571.50 4/30/2017 0.89% 5 10,295.52 $ 8,984.22 $ 2,239.97 120 Berk Hath Coupon Note 01/11/13 500,000.00 509,280.00 9,280.00 500,932.50 5/15/2017 L61% $ 30,755.56 5 20,335.65 $ 2,955.58 135 FNMA Callable Note 10/19/12 1,500,000.00 1,504,050.00 4,050.00 1,501,320.00 9/20/2017 0.94% $ 58,791.67 $ 52,436.88 57,146.95 263 US Bancorp Corporate Note 8/8/2016 1,000,000.00 1,019,550.00 19,550.00 1,005,088.00 10/15/2018 1.0894 5 5,254.17 $ - $ 4,194.26 653 Microsoft Corporate Note 8/8/2016 1,000,000.00 999,470.00 (530.00) 986,553.00 8/8/2019 1.12% $ - $ - $ 4,d40.o5 950 FNMA Callable Note 11/30/12 1,000,000.00 1,003,200.00 3,200.00 1,000,880.00 9/20/2017 0.93% $ 38,055.56 $ 33,450.66 $ 4,705.60 263 FNMA Callable Note 12/04/12 1,000,000.00 1,002,750.00 2,750.00 1,000,880.00 9/20/2017 0.94% $ 37,916.67 5 33,651.06 5 4,751.95 263 FFCB Coupon Note 10/18/12 2,000,000.00 1,996,960.00 (3,040.00) 2,000,060.00 9/21/2017 0.86% $ 65,155.00 $ 63,725.70 $ 8,679.15 264 FHLB Coupon Note 12/12/12 2,000,000.00 1,998,720.00 (1,280.00) 1,995,920.00 12/8/2017 0.76% $ 538,583.33 $ 54,170.75 5 7,690.91 342 FNMA Callable Note 04/17/13 1,000,030.00 1,004,400.00 4,400.00 999,260.00 3/5/2018 1.03% $ 38,062.50 $ 33,174.38 $ 5,217.17 429 AAPL Corporate Note 05/16/13 1,000,000.00 991,680.01 (8,319.99) 996,250.00 5/3/2018 1.17% $ 34,638.89 5 36,496.41 $ 5,885.49 488 FHLB Coupon Note 06/09/15 1,000,000.00 997,710.00 (2,290.00) 998,660.00 8/27/2018 1.22% $ 13,991.66 $ 12,947.39 $ 6,155.86 604 Treasury Note 06/09/15 1,000,000.00 1,000,468.75 468.75 1,003,508.00 6/30/2017 0.73% $ 11,685.08 $ 7,710.82 $ 3,666.13 181 Treasury Note 06/09/15 1,000,000.00 1,004,140.63 4,140.63 1,001,562.00 9/15/2017 0.82% 5 12,663.04 5 8,669.78 $ 4,122.07 258 Treasury Note 06/11/15 1,000,000.00 990,468.75 (9,531.25) 996,914.00 4/15/2018 1.09% $ 10,081.97 $ 11,442.75 $ 5,468.74 470 FHLB Coupon Note 06/11/15 2,000,000.00 1,991,820.00 (8,180.00) 1,995,680.00 5/25/2018 1.19% $ 31,033.33 $ 25,069.41 5 11,981.22 510 Treasury Note 07/31/15 1,000,000.00 1,010,625.00 10,625.00 1,004,688.00 6/30/2018 1.00% $ 19,466.71 $ 9,277.73 $ 5,095.83 546 FFCB Coupon Note 07/30/15 2,500,000.00 2,509,525.00 9,525.00 2,504,927.50 12/18/2017 0.96% $ 38,906.25 $ 22,220.23 $ 12,168.22 352 FHLB Coupon Note 8/20/2015 1,250,000.00 1,247,075.00 (2,925.00) 1,246,575.00 7/25/2018 1.13% 5 12,541.67 $ 12,188.15 $ 7,119.43 571 FHLB Coupon Note 8/25/2015 1,000,000.00 999,500.00 (500.00) 997,260.00 7/25/2018 1.07% $ 9,887.50 5 9,063.35 $ 5,379.54 571 FFCB Coupon Note 8/27/2015 1,000,000.00 1,002,060.00 2,060.00 1.000,550.00 4/24/2017 0.63% $ 11,187.50 $ 5,281.77 $ 3,155.34 114 Walmart Corporate Note 9/25/2015 1,000,000.00 998,960.00 (1,040.00) 997,672.00 4/11/2018 1.17% $ 11,750.00 5 8,911.65 5 5.877.22 466 Disney Corporate Note 9/25/2015 995,000.00 995,298.50 29850 994,140.32 12/1/2017 1.09% 5 12,951.58 $ 8,261.82 5 5,448.65 335 FFCB Coupon Note 10/27/2015 1,000,000.00 1,048,230.00 48,230.00 1,019,770.00 6/1/2018 0.86% 5 30,097.22 $ 6,043.33 5 4,501.92 517 FHLB Coupon Note 10/27/2015 1,000,000.00 1,005,030.00 5,030.00 999,415.00 9/14/2018 0.95% $ 9,906.25 $ 6,433.14 $ 4,792.30 622 FFCB Coupon Note 10/29/2015 1,500,000.00 1,494,840.00 (5,160.00) 1,489,680.00 10/9/2018 09930 $ 12,395.83 $ 9,984.84 5 7,498.82 647 Chevron Corporate Note 12/15/2015 1,250,000.00 1,252,262.50 2,262.50 1,249,315.00 11/9/2017 1.25% $ 15,493.33 $ 8,468.86 $ 7,870.05 313 Treasury Note 1/26/2016 1,500,000.00 1494,902.34 (5,097.66) 1,496,484.00 2/28/2018 0.91% $ 6,675.82 $ 5,849.10 $ 6,898.94 424 Wells Fargo Corporate Note 2/2/2016 1,003,000.00 1,001,680.00 1,680.00 999,973.00 1/22/2018 1.56% 5 8,112.50 5 6,387.95 5 7,888.47 387 FHLMC Coupon Note 4/29/2016 1,000,000.00 1,006,050.00 8,050.00 1,001,720.00 12/17/2018 1.04% $ 8,550.00 $ 1,774.34 5 5,265.77 716 FFCB Coupon Note 4/29/2016 1,000,030.00 1,001,870.00 1,870.00 996,110.00 3/21/2019 1.09% $ 4,575.56 5 1,860.62 5 5,521.84 810 FFCB Coupon Note 10/28/2016 1,000,000.00 997,507.00 2,493.00 986,200.00 320.83 10/17/2019 1.14% $ (320.83) $ • $ 1,988.28 1020 FNMA Coupon Note 11/15/2016 1,500,000.00 1,487,505.00 12,495.00 1,483,336.50 3,041.67 8/28/2019 1.31% $ (3,041.67) $ - 5 2,456.13 970 Subtotal 5 48,304,393.42 $ 139,369.42 $ 48,137,211.00 $ 3,362.50 5 843,581.63 $ 662,315.16 $ 225,210.26 BNY MM 270,720.59 270,720.59 IAIF N/A 12/31/14 4,198,679.25 4,198,679.25 13,521.43 $52,773,793.26 $52,606,610.84 $ 843,581.63 $ 662,315.16 5 238,731.69 Bank of the West Matured Assets IBM Corporation Corporate Note 11/13/12 750,000.00 782,505.00 32,505.00 7/22/2016 0.76% $ 53,990.62 5 21,116.64 $ 350.62 Treasury Note 08/16/11 1,000,000.00 1,025,390.63 25,390.63 8/1/2016 0.97% $ 74,347.83 5 48,194.68 $ 1,273.97 Treasury Note 06/10/14 1,000,000.00 1,000,000.00 0.00 8/4/2016 0.00% $ 13,434.10 $ 12,859.59 5 574.51 Treasury Note 06/10/14 1,000,000.00 1,004,062.50 4,062.50 8/4/2016 0.42% $ 18,732.73 $ 14,121.82 $ 658.14 FNMA Callable Note 03/28/14 1,000,000.00 1,014,600.00 14,600.00 9/28/2016 0.66% $ 31,250.00 $ 15,089.49 $ 1,646.13 FNMA Callable Note 05/14/13 1,500,000.00 1,500,000.00 0.00 11/14/2016 0.55% $ 28,875.00 $ 25,834.93 $ 3,096.58 Total Investments"Matured" 56,326,556.13 $ 1,06,1,211.91 $ 799,532.32 $ 246,331.64 Maturity Profile 0-1year 1-2 years 2-3 years 3-5 years Market to Cost Position Report Amount $28,023,113.66 518,304,521.10 56,446,158.50 $0.00 $52,773,793.26 Amortized Institution Cost BNY Assets $48,304,393.42 BNY MM 270,720.59 IAIF 4,198,679.25 Totals: $52,773,793.26 Page 5 Weighted Average Portfolio Yield: Portfolio Balance Benchmarks/ References: Town's Average Yield LAIF Yield for month 3 mo. Treasury 6 mo. Treasury 2 yr. Treasury 5 yr. Treasury (most recent) 10 Yr. Treasury 2 - 3 years 25% Town of Los Gatos Summary Investment Information November 30, 2016 0.88% Weighted Average Maturity (days) 424 This Month Last Month One year ago $68,749,199 $68,682,596 $66,847,898 0.88% 0.68% 0.49% 0.61% 1.12% 1.85% 2.39% 3 - 5 years 15% 0.84% 0.64% 0.30% 0.49% 0.84% 1.31% 1.83% Portfolio Maturity Profile 0.79% 0.37% 0.22% 0.42% 0.93% 1.65% 2.26% 30% Compliance: The Town's investments are in compliance with the Town's investment policy dated November 1, 2016 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 November 30, 2016 Month YTD Fund Balances - Beginning of Month/Period $68,682,595.68 $74,913,936.39 Receipts 3,415,128.49 13,723,364.21 Disbursements (3,348,525.24) (19,888,101.67) Fund Balances - End of Month/Period $68,749,198.93 $68,749,198.93 Portfolio Allocation: BNY MM US Govt Agencies & Corp. Bonds Local Agency Investment Fund Subtotal - Investments Reconciled Demand Deposit Balances Total Treasurer's Fund Local Agency investment Fund 7.96% $223,142.70 48,304,393.42 4,198,679.25 52,726,215.37 16,022,983.56 $68,749,198.93 Portfolio Investment Allocation BNY MM 0.42% US Govt Agencies & Corp. Bonds 91.61% page 2 Town of Los Gatos Non -Treasury Restricted Fund Balances November 30, 2016 NOV 16 NOV 16 NOV 16 Previous Deposits Ending Balance Realized Gain/Adi. Interest Withdrawals Balance Non -Treasury Funds: Cert. of Participation 2002 Series A Reserve Fund $ 686,308.53 $ $ 5.85 $ Cert. Of Participation 2002 Ser A Lease Pymt Fund 4.88 0.00 0.00 Cert. of Participation 2002 Series A Const. Fund 14.81 0.00 0.00 COP 2010 Library Reserve Fund 1,277,740.38 0.00 165.42 - $ 686,314.38 0.00 4.88 0.00 14.81 0.00 1,277,905.80 Total Restricted Funds: $1,964,068.60 $0.00 5171.27 $0.00 $1,964,239.87 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. October includes gain on sale of zmoney market fund of $255.50 and reconciling adjustment for Sep 16 interest. 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 1 Note 1 Note 1 Note 2 Page 3 Town of Los Gatos Statement of Interest Earned November 30, 2016 Interest by Month July 2016 August 2016 September 2016 October 2016 November 2016 December 2016 January 2017 February 2017 March 2017 April 2017 May 2017 June 2017 $40,143.04 41,290.98 39,945.53 40,937.76 41,154.71 $203,472.02 Page 4 Town of Los Gatos Investment Schedule November 30, 2016 Deposit Par Institution Security Date Value Orginal Issue Maturity Yield to Interest Interest Interest Days Original (Discount) Market Purchased Date or Maturity Received Earned Earned to Cost Premium Value Interest fall Date or Call to Date Prior Yrs. Current FY Maturity PFIZER Corporate Note 03/11/15 750,000.00 753,037.50 3,037.50 750,358.13 5/15/2017 0.91% $ 13,727.08 $ 8,855.98 $ 2,870.69 166 Freddie Mac Coupon Note 08/01/16 1A00,000.00 1,005,560.00 5,560.00 995,621.00 4/15/2019 0.92% $ 1,562.50 5 • $ 3,047.83 866 Toyota Motor Credit Coupon Note 07/10/15 500,000.00 502,200.00 2,200.00 500,246.50 10/5/2017 1.05% $ 7,725.69 $ 5,138.43 5 2,208.37 309 Toyota Motor Credit Corporate Note 07/25/16 950,000.00 954,246.50 4,206.50 939,270.70 5/20/2019 1.24% $ 0,248.61 $ • 5 4,135.88 901 FNMA Callable Note 04/04/13 4,000,000.00 4,004,800.00 4,800.00 4,001,360.00 3/10/2017 0.72% $ 103,333.33 $ 93,289.54 $ 12,065.34 104 Treasury Note 05/27/14 2,000,000.00 2,015,156.25 15,156.25 2,003,286.00 3/31/2017 0.73% $ 46,885.25 5 30,758.49 $ 6,151.70 121 Treasury Note 06/23/14 500,000.00 499,804.69 (195.31) 500,671.00 4/30/2017 0.89% $ 10,295.52 5 8,984.22 $ 1,862.58 151 Berk Hath Coupon Note 01/11/13 500,000.00 509,280.00 9,280.00 501,481.00 5/15/2017 1.61% $ 30,755.56 $ 20,335.65 $ 2,457.63 166 FNMA Callable Note 10/19/12 1,500,000.00 1,504,050.00 4,050.00 1,501,929.00 9/20/2017 0.94% $ 58,791.67 $ 52,436.88 $ 5,942.85 294 35 Bancorp Corporate Note 8/8/2016 1,000,000.00 1,019,550.00 19,550.00 1,005,440.00 10/15/2018 1.08% $ 5,254.17 $ - 5 3,297.55 684 Microsoft Corporate Note 8/8/2016 1,000,000.00 999,470.00 (530.00) 986,202.00 8/8/2019 1.12% $ $ $ 3,490.79 981 FNMA Callable Note 11/30/12 1,000,000.00 1,003,200.00 3,200.00 1,001,286.00 9/20/2017 0.93% $ 38,055.56 $ 33,450.66 $ 3.912.81 294 FNMA Callable Note 12/04/12 1,000,000.00 1,002,750.00 2,750.00 1,001,286.00 9/20/2017 0.94% $ 37,916.67 5 33,651.06 $ 3,951.35 294 FFCB Coupon Note 10/18/12 2,000,000,00 1,996,960.00 (3,040.00) 1,999,8,40.00 9/21/2017 0.86% $ 65,155.00 $ 63,725.70 $ 7,216.90 295 FHLB Coupon Note 12/12/12 2,000,003.00 1,998,720.00 (1,280.00) 1,996,580.00 12/8/2017 0.76% 5 51,083.33 $ 54,170.75 5 6,395.16 373 FNMA Callable Note 04/17/13 1,000,000.00 1,004,400.00 4,400.00 999,630.00 3/5/2018 1.03% $ 38,062.50 $ 33,174.38 $ 4,338.19 460 AAPI. Corporate Note 05/16/13 1,003,000.00 991,680.01 (8,319.99) 995,020.00 5/3/2018 1.17% $ 34,638.89 $ 36,496.41 $ 4,893,91 519 FINS Coupon Note 6/9/2015 1,000,000.00 997,710.00 (2,290.00) 999,210.00 8/27/2018 1.22% $ 13,991.66 $ 12,947.39 $ 5,118.74 635 Treasury Note 6/9/2015 1,000,000.00 1,000,468.75 468.75 1,000,352.00 6/30/2017 0.73% $ 7,935.08 $ 7,710.82 $ 3,048.46 212 Treasury Note 6/9/2015 1,000,000.00 1,004,140.63 4,140.63 1,001,406.00 9/15/2017 0.82% 5 12,663.04 $ 8,669.78 $ 3,427.59 289 Treasury Note 6/11/2015 1,000,000.00 990,468.75 (9,531.25) 996,406.00 4/15/2018 1.09% $ 10,081.97 $ 11,442.75 $ 4,547.38 501 FHLB Coupon Note 6/11/2015 2,000,000.00 1,991,1320.00 (8,180.00) 1,996,440.00 5/25/2018 1.19% $ 31,033.33 $ 25,069.41 $ 9,962.65 541 Treasury Note 7/31/2015 1,000,000.00 1,010,625.00 10,625.00 1,005,156.00 6/30/2018 1.00% $ 12,591.71 $ 9,277.73 5 4,237.29 577 FFCB Coupon Note 7/30/2015 2,500,000.00 2,509,525.00 9,525.00 2,504,882.50 12/18/2017 0.96% $ 24,843.75 $ 22,220.23 $ 10,118.14 383 FHLB Coupon Note 8/20/2015 1,250,000.00 1,247,075.00 (2,925.00) 1,247,125.00 7/25/2018 1.13% $ 12,541..67 $ 12,188.15 $ 5,919.96 602 FHLB Coupon Note 8/25/2015 1,000,000.00 999,500.00 (500.00) 997,700.00 7/25/2018 1.07% $ 9,887.50 $ 9,063.35 $ 4,473.20 602 FFCB Coupon Note 8/27/2015 1,003,000.00 1,002,060.00 2,060.00 1,000,510.00 4/24/2017 0.63% $ 11,187.50 $ 5,281.77 5 2,623.74 145 Watmart Corporate Note 9/25/2015 1,000,000.00 998,960.00 (1,040.00) 997,647.00 4/11/2018 1.17% 5 11,750.00 $ 8,911.65 5 4,887.03 497 Disney Corporate Note 9/25/2015 995,000.00 995,298.50 298.50 994,193.06 12/1/2017 1.09% $ 7,479.08 $ 8,261.82 $ 4,530.67 366 FFCB Coupon Note 10/27/2015 1,000,000.00 1,048,230.00 48,230.00 1,022,020.00 6/1/2018 0.86% $ 16,347.22 5 6,043.33 $ 3,743.44 548 8906 Coupon Note 10/27/2015 1,000,000.00 1,005,030.00 5,030.00 998,831.00 9/14/2018 0.95% $ 9,906.25 $ 6,433.14 $ 3,984.90 653 FFCB Coupon Note 10/29/2015 1,500,000.00 1,494,840.00 (5,160.00) 1,490,175.00 10/9/2018 0.9914 $ 12,395.83 5 9,984.84 $ 6,235.43 678 Chevron Corporate Note 12/15/2015 1,250,000.00 1,252,262.50 2,262.50 1,251,187.50 11/9/2017 1.25% $ 15,493.33 $ 8,468.86 $ 6,544,12 344 Treasury Note 1/26/2016 1,500,000.00 1,494,902.34 (5,097.661 1,495,840.50 2/28/2018 0.91% 5 6,675.82 $ 5,849.10 5 5,736.62 455 Wells Fargo Corporate Note 2/2/2016 1,000,000.00 1,001,680.00 1,6130.00 1,000,928.00 1/22/2018 1.56% $ 8,112.50 $ 6,387.95 $ 6,559.44 418 FHLMC Coupon Note 4/29/2016 1,000,000.00 1,008,050.00 8,050.00 1,002,930.00 12/17/2018 1.04% $ 1,800.00 $ 1,774.34 5 4,378.60 747 FFCB Coupon Note 4/29/2016 1,000,000.00 1,001,870.00 1,870.00 996,740.00 3/21/2019 1.09% $ 4575.56 $ 1,860.62 $ 4,591.53 841 FFCB Coupon Note 10/28/2016 1,000,000.00 997,507.00 2,493.00 988,020.00 320.83 10/17/2019 1.14% $ (320.831 5 - $ 1,025.21 1051 FNMA Coupon Note 11/15/2016 1,500,000.00 1,487,505.00 12,495.00 1,483,263.00 3,041.67 8/28/2019 1.31% $ 13,041.671 $ - $ 800.91 1001 Subtotal $ 48,304,193.42 $ 139,369.42 $ 48,150,909.89 $ 3,362.50 $ 785,421.63 $ 662,315.16 $ 184,734.57 BNY MM IAIF N/A 12/31/14 223,142.70 223,142.70 4,198,679.25 4,198,679.25 11,137.51 $52,726,215.37 $52,572,731.84 $ 785,421.63 $ 662,315.16 $ 195,872.08 Bank of the West Matured Assets IBM Corporation Corporate Note 11/13/12 750,000.00 782,505.00 32,505.00 7/22/2016 0.76% $ 53,990.62 5 21,116.64 $ 350.62 Treasury Note 08/16/11 1,000,000.00 1,025,390.63 25,390.63 8/1/2016 0.97% $ 74,347.83 $ 48,194.68 $ 1,273.97 Treasury Note 06/10/14 1,000,000.00 1,000,000.00 0.00 8/4/2016 0.00% $ 13,434.10 $ 12,859.59 $ 574.51 Treasury Note 06/10/14 1,000,000.00 1,004,062.50 4,062.50 8/4/2016 0.42% $ 18,732.73 $ 14,121.82 $ 658.14 FNMA Callable Note 03/28/14 1,000,000.00 1,014,600.00 14,600.00 9/2S/2016 0.66% $ 31,250.00 $ 15,089.49 $ 1,646.13 FNMA Callable Note 05/14/13 1,500,000.00 1,500,000.00 0.00 11/14/2016 0.55% $ 28,875.00 5 25,834.93 5 3,096.58 Total Investments "Matured" $6,326,558.13 Maturity Profile 0-1 year 1-2 years 2.3 years 3.5 years Market to Cost Position Report Amount 522,471,992.27 520,808,194.60 $7,454,208.50 $0.00 $50,734,395.37 Amortized Institution o t BNY Assets $48,304,393.42 BNY MM 223,142.70 LAIF 4,198,679.25 Totals: $52,726,215.37 $ 1,006,051.91 5 799,532.32 $ 203,472.02 Page 5 Weighted Average Portfolio Yield: Portfolio Balance Benchmarks/ References: Town's Average Yield LAIF Yield for month 3 mo. Treasury 6 mo. Treasury 2 yr. Treasury 5 yr. Treasury (most recent) 10 Yr. Treasury 2 - 3 years 25% Town of Los Gatos Summary Investment Information October 31, 2016 0.86% Weighted Average Maturity (days) 422 This Month Last Month One year ago $68,682,596 $69,818,409 $66,506,768 0.86% 0.64% 0.30% 0.49% 0.84% 1.31% 1.83% 3 - 5 years 0.84% 0.57% 0.26% 0.35% 0.58% 0.99% 1.44% Portfolio Maturity Profile 0.79% 0.30% 0.08% 0.23% 0.34% 1.52% 2.09% 1 - 2 years 30% Compliance: The Town's investments are in compliance with the Town's investment policy dated November 1, 2016 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 October 31, 2016 Month YTD Fund Balances - Beginning of Month/Period $69,818,408.62 $74,913,936.39 Receipts 2,328,730.54 10,308,235.72 Disbursements (3,464,543.48) (16,539,576.43) Fund Balances - End of Month/Period $68,682,595.68 $68,682,595.68 Portfolio Allocation: BNY MM US Govt Agencies & Corp. Bonds Local Agency Investment Fund Subtotal - Investments Reconciled Demand Deposit Balances Total Treasurer's Fund $160,988.46 48,316,888.42 4,198,679.25 52,676,556.13 16,006,039.55 $68,682,595.68 Portfolio Investment Allocation BNY MM Local Agency Investment Fund 0.31% 7.97% US Govt Agencies & Corp. Bonds 91.72% Treasurer's Fund Balances 76,000,000 74,000,000 72,000,000 70,000,000 68,000,000 66,000,000 64,000,000 62,000,000 60,000,000 page 2 Town of Los Gatos Non -Treasury Restricted Fund Balances October 31, 2016 OCT16 OCT16 OCT 16 Previous Deposits Ending Balance Realized Gain/Adi. Interest Withdrawals Balance Non -Treasury Funds: Cert. of Participation 2002 Series A Reserve Fund $ 686,285.52 $ 17.35 $ 5.66 $ Cert. Of Participation 2002 Ser A Lease Pymt Fund 0.35 4.53 0.00 Cert. of Participation 2002 Series A Const. Fund 12.93 1.88 0.00 COP 2010 Library Reserve Fund 1,277,371.65 358.23 10.50 Total Restricted Funds: $1,963,670.45 $381.99 $16.16 These accounts are not part of the Treasurer's fund balances reported elsewhere in this report, as they are for separate and distinct entities. - $ 686,308.53 0.00 4.88 0.00 0.00 $0.00 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. October includes gain on sale of money market fund of $255.50 and reconciling adjustment for Sep 16 interest. 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. 14.81 1,277,740.38 $1,964,068.60 Note 1 Note 1 Note 1 Note 2 Page 3 Town of Los Gatos Statement of Interest Earned October 31, 2016 Interest by Month July 2016 August 2016 September 2016 October 2016 November 2016 December 2016 January 2017 February 2017 March 2017 April 2017 May 2017 June 2017 $40,143.04 41,290.98 39,945.53 40,912.95 $162,292.50 Page 4 Town of Los Gatos investment Schedule October 31, 2016 Orginal Issue Maturity Yield to Interest Interest Interest Days Deposit Par Original (Discount) Market Purchased Date or Maturity Received Earned Earned to In 3Butfon Seour4ll Dam Value Cost Premium Value Interest Call Date or Call to Date Prior Yrs. Current FY Maturity PFIZER Corporate Note 03/11/15 750,000.00 753,037.50 3,037.50 751,014.38 5/15/2017 0.91% $ 9,602.08 $ 8,855.98 $ 2,307.81 196 Freddie Mac Coupon Note 08/01/16 1,000,000.00 1,005,560.00 5,560.00 1,002,754.00 4/15/2019 0.9256 $ 1,562.50 $ - $ 2,292.17 896 Toyota Motor Credit Coupon Note 07/10/15 500,000.00 502,200.00 2,200.00 501,632.00 10/5/2017 1.05% $ 7,725.69 $ 5,138.43 $ 1,775.36 339 Toyota Motor Credit Corporate Note 07/25/16 950,000.00 954,246.50 4,246.50 948,125.65 5/20/2019 1.24% $ (2,401.39) $ - $ 3,166.53 931 FNMA Callable Note 05/14/13 1,500,000.00 1,500,000.00 0.00 1,500,150.00 11/14/2016 0.55% 5 24,750.00 $ 25,834.93 $ 2,780.14 14 FNMA Callable Note 04/04/13 4,000,000,00 4,004,800.00 4,800.00 4,004,280.00 3/14/2017 0.72% 5 103,333.33 $ 93,289.54 5 9,699.59 134 Treasury Note 05/27/14 2,000,000.00 2,015,156.25 15,156.25 2,004,768.00 3/31/2017 0.73% $ 46,885.25 $ 30,758.49 5 4,945.48 151 Treasury Note 06/23/14 500,000.00 449,804.69 (195.31) 500,844.50 4/30/2017 0.89% 5 8,108.02 $ 8,984.22 5 1,497.37 181 Berk Math Coupon Note 01/11/13 500,000.00 509,280.00 9,280.00 502,197.50 5/15/2017 1.6156 $ 26,755.56 $ 20,335.65 $ 1,575.74 196 FNMA Callable Note 10/19/12 1,500,000.00 1,504,050.00 4,050.00 1,503,813.00 9/20/2017 0.9456 $ 58,791.67 $ 52,436.88 $ 41,777.58 324 US Bancorp Corporate Note 8/8/2016 1,000,000.00 1,019,550.00 19,550.00 1,011,102.00 10/15/2018 108% $ (4,495.83) $ - $ 2,429.78 714 Microsoft Corporate Note 8/8/2016 1,000,000.00 999,470.00 (530.00) 993,807.00 8/8/2019 1.12% $ $• $ 2,572.16 1011 FNMA Callable Note 11/30/12 1,000,000.00 1,003,200.00 3,200.00 1,002,542.00 9/20/2017 0.9356 5 38,055.56 $ 33,450.66 $ 3,145.59 324 FNMA Callable Note 12/04/12 1,000,000.00 1,002,750.00 2,750.00 1,002,542.00 9/20/2017 0.94% $ 37,916.67 $ 33,651.06 5 3,176.58 324 FFCB Coupon Note 10/18/12 2,000,000.00 1,996,960.00 (3,040.00) 2,002,200.00 9/21/2017 0.86% $ 65,155.00 $ 63,725.70 $ 5,801.82 325 FHLB Coupon Note 12/12/12 2,003,000.00 1,998,720.00 (1,280.00) 1,999,020.00 12/8/2017 0.765 $ 51083.33 $ 54,170.75 $ 5,141.281 403 FNMA Callable Note 04/17/13 1,000,000.00 1,004,400.00 4,400.00 1,003,150.00 3/5/2018 1.03% $ 38,062.50 $ 33,174.38 $ 3,487.56 490 AAPL Corporate Note 05/16/13 1,000,000.00 991,680.01 (8,319.99) 998,679.00 5/3/2018 1.17% $ 29,638.69 5 36,496.41 $ 3,934.32 549 FHLB Coupon Note 6/9/2015 1,000,000.00 997,710.00 (2,290.00) 1,003,790.00 8/27/2018 1.225 5 13,991.66 $ 12,947.39 $ 4,115.06 665 Treasury Note 6/9/2015 1,000,000.00 1,0(0,468.75 468.75 1,000,820.00 6/30/2017 0.73% $ 7,935.08 5 7,710.82 $ 2,450.73 242 Treasury Note 6/9/2015 1,000,000.00 1,004,140.63 4,140.63 1,002,656.00 9/15/2017 0.82% 5 12,663.04 5 8,669.78 $ 2,755.51 319 Treasury Note 6/11/2015 1,000,000.00 990,468.75 (9,531.25) 999,375.00 4/15/2018 1.09% $ 10,081.97 $ 11,442.75 $ 3,655.74 531 F818 Coupon Note 6/11/2015 2,000,000.00 1,991,820.00 (8,180.00) 2,004,180.00 5/25/2018 1.19% 5 20,533.33 $ 25,069.41 $ 8,009.19 571 Treasury Note 7/31/2015 1,000,000.00 1,010,625.00 10,625.00 1,008,945.00 6/30/2018 1.00% $ 12,591.71 $ 9,277.73 $ 3,406.45 607 FFC8 Coupon Note 7/30/2015 2,500,000.00 2,509,525.00 9,525.00 2,509,225.00 12/18/2017 0.96% 5 24,843.75 $ 22,220.23 $ 8,134.19 413 FHLB Coupon Note 8/20/2015 1,250,000.00 1,247,075.00 (2,925.00) 1,252,462.50 7/25/2018 1.13% 5 12,541.67 $ 12,188.15 5 4,759.18 632 FHLB Coupon Note 8/25/2015 1,000p00.00 999,500.00 (500.00) 1,001,970.00 7/25/2018 1.07% 5 9,887.50 $ 9,063.35 5 3,596.10 632 9908 Coupon Note 8/27/2015 1,000,000.00 1,002,060.00 2,060.00 1,000,880.00 4/24/2017 0.63% $ 11,187.50 $ 5,281.77 $ 2,109.28 175 Walman Corporate Note 9/25/2015 1,000,000.00 998,960.00 (1,040.00) 1,000,816.00 4/11/2018 1.17% $ 11,750.00 $ 8,91165 5 3,928,79 527 Disney Corporate Note 9/25/2015 995,000.00 995,298.50 298.50 995,370.14 12/1/2017 1.09% $ 7,479.08 $ 8,261.82 5 3,642.31 396 FFCB Coupon Note 10/27/2015 1,000,000.00 1,048,230.00 48,230.00 1,027,410.00 6/1/2018 0.86% 5 16,347.22 $ 6,043.33 5 3,009.43 578 FHLB Coupon Note 10/27/2015 1,009,000.00 1,005,030.00 5,030.00 1,003,588.00 9/14/2018 0.95% 5 9,906.25 $ 6,433.14 5 3,203.55 683 FFCB Coupon Note 10/29/2015 1,500,000.00 1,49,1,840.00 (5,160.001 1,497,090.00 10/9/2018 0.99% 5 12,395.83 5 9,984.84 $ 5,012.80 708 Chevron Corporate Note 12/15/2015 1,250,000.00 1,252,262.50 2,262.50 1,252,575.00 11/9/2017 125% $ 7,068.33 5 8,441.73 $ 5,244.11 374 Treasury Note 1/26/2016 1,500,000.00 1,494,902.34 (5,097.66) 1,499,590.50 2/28/2018 0.91% $ 6,675.82 $ 5,849.10 $ 4,611.79 485 Wells Fargo Corporate Note 2/2/2016 1,000,000.00 1,001,680.00 1,680.00 1,003,400.00 1/22/2018 1.56% $ 8,112.50 5 6,387.95 $ 5,273.27 448 FHLMC Coupon Note 4/29/2016 1,000,000.00 1,008,050.00 8,050.00 1,00)3,640.00 12/17/2018 1.04% $ 1,800.00 $ 1,774.34 5 3,520.05 777 FFCB Coupon Note 4/29/2016 1,000,000.00 1,001,870.00 1,870.00 1,002,640.00 3/21/2019 1.09% $ 4,575.56 5 1,860.62 $ 3,691.23 871 FFC8 Coupon Note 10/28/2016 1,001,000.00 997,507.00 2,493.00 998,090.00 320.83 10/17/2019 1.14% $ (320.83) 5 - 5 93.20 1081 Subtotal $ 48,316,888.42 $ 126,874.42 $ 48,306,134.17 $ 320.83 $ 762,896.63 $ 6E18,122.96 $ 149,035.54 BNY MM 160,988.46 160,988.46 3619 N/A 12/31/14 4,198,679.25 4,198,679.25 8,753.59 552,676,556.13 552,665,801.88 $ 762,896.63 5 6843,122.96 $ 157,789.13 Bank of the West Matured Assets IBM Corporation Corporate Note 11/13/12 750,000.00 782,505.00 32,505.00 Treasury Note 08/16/11 1,000,000.00 1,025.390.63 25,390.63 Treasury Note 06/10/14 1,000,000.00 1,000,000.00 0.00 Treasury Note 06/10/14 1,000,000.00 1,004,062.50 4,062.50 FNMA Callable Note 03/28/14 1,000,000.00 1,014,600.00 14,600.00 Total Investments"Matured" Maturity Profile 0-1 year 1-2 years 2-3 years 3-5 years Market to Cost Position Report Institution BNY Assets BNY MM IAIF Totals: 54,826,558.13 Amount 522,657,575.53 524,052,277.10 55,966,703.50 $0.00 $52,676,556.13 Amortized Cost 548,316,888.42 160,988.46 4,198,679.25 $52,676,556.13 7/22/2016 0.76% 5 53,990.62 $ 21,116.64 $ 350.62 8/1/2016 0.97% $ 74,347.83 $ 48,194.68 $ 1,273.97 8/4/2016 0.00% $ 13,434.10 $ 12,859.59 $ 574.51 8/4/2016 0.42% $ 18,732.73 $ 14,121.82 5 658.14 9/28/2016 0.66% $ 31,250.00 $ 15,089.49 5 1,646.13 $ 954,651.91 5 799,505.19 $ 162.292.50 Page 5