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 June 30, 2018 Weighted Average YTM Portfolio Yield: 1.73% Weighted Average Maturity (days) 389 This Month Last Month One year ago Portfolio Balance $76,649,992 $76,817,429 $75,983,998 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% 1.73% 1.85% 1.92% 2.11% 2.54% 2.74% 2.86% 3 - 5 years 15% 1.71% 1.76% 1.90% 2.08% 2.43% 2.70% 2.86% Portfolio Maturity Profile 1.25% 0.98% 1.01% 1.13% 1.38% 1.89% 2.31% 1- 2 years 30% 0 - 1 year 30% 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 ATTACHMENT 1 Town of Los Gatos Portfolio Allocation & Treasurer's Fund Balances June 30, 2018 Fund Balances - Beginning of Month/Period Receipts Disbursements Fund Balances - End of Month/Period Portfolio Allocation: BNY MM US Treasury Notes Government Agency Debenture Notes Corporate Medium Term Bonds Local Agency Investment Fund Subtotal -Investments Reconciled Demand Deposit Balances Total Treasurer's Fund Month YTD $76,817,428.92 $75,983,998.32 5,740,505.51 47,134,518.09 (5,907,942.17) (46,468,524.151 $76,649,992.26 $76,649,992.26 $183,202.62 $6,702,511.72 $28,429,699.96 $13,013,457.00 6,282,764.12 54,611,635.42 22,038,356.84 $76,649,992.26 % of Portfolio Max. % 0r $ Allowed Per State Law or Policy 0.34% 12.27% 52.06% 23.83% 11.50% 100.00% 20% of Town Portfolio No Max. on US Treasuries No Max. on Non -Mortgage Backed 30%ofTown Portfolio $65M per State Law Portfolio Investment Allocation Local Agency Investment Fund BNY MM 11.5% 0.34% Corporate Medium Term Bonds 23.8% US Treasury Notes 12.27% Government Agency Debenture Notes 52.06% 78,000,000 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 J un•17 Jul-17 Aug-17 Sep-17 Treasurer's Fund Balances Oct-17 Nos-17 Dec-17 Jar-18 Feb-18 Mar -IS Apr-.18 May-18 Jun-18 page 2 Town of Los Gatos Non -Treasury Restricted Fund Balances June 30, 2018 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 Total Restricted Funds: JUNE 18 JUNE 18 JUNE 18 Previous Deposits Ending Balance Realized Gain/Adi. Interest Withdrawals Balance $ 690,229.28 $ 653.75 $ 690,883.03 Note 1 51.70 0.04 51.74 Note 1 24.17 24.17 Note 1 1,293,164.69 1,740.37 1,294,905.06 Note2 $ 1,983,469.84 $0.00 $2,394.16 $0.00 51,985,864.00 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 June 30, 2018 Interest by Month July 2017 August 2017 September 2017 October 2017 November 2017 December 2017 January 2018 February 2018 March 2018 April 2018 May 2018 June 2018 $58,520.73 54,113.45 50,380.68 66,971.08 60,263.58 64,761.73 69,007.27 63,484.43 72,902.24 73,247.46 78,696.39 81,274.93 $793,623.97 Page 4 Town of Los Gatos Investment Schedule June 30, 2018 OrgIna) Issue Maturity Yield to Interest Interest Interest Days Deposit Original (Discount) Market Purchased Date or Maturity Received Earned Earned to Institution Sews. Date Cost Premium Value Interest Call Date or Call to Date Prior Yrs. Current FY Maturity AYR 17 Security Freddie Mac Gov. Agency Debenture 08/01/16 1,005,560.00 5,560.00 990,781.00 4/15/2019 0.92% $ 18,437.50 $ 8,387.83 $ 9,193.87 289 Toyota Motor Credit Corporate Bond 07/25/16 954,246.50 4,246.50 939,683.00 5/20/2019 1.24% 5 24,198.61 $ 10,985.92 $ 11,793.71 324 FHLB Gov. Agency Debentur, 9/20/2017 1,776,432.00 03,568.00) 1,743,695.10 6/12/2020 1.56% 5 17,862.40 5 • $ 21,464.29 713 US Bancorp Corporate Bond 8/8/2016 1,019,550.00 19,550.00 997,880.00 10/15/2018 1.08% 5 34,504.17 $ 9,429.85 5 10,557.96 107 Microsoft Corporate Bond 8/8/2016 999,470.00 (530.00) 984,312.00 8/8/2019 1.12% 5 16,500.00 5 9,982.45 $ 11,176.67 404 FFCB Gov. Agency Debenture 9/20/2017 1,602,304.00 2,304.00 1,573,664.00 4/6/2020 1.54% $ 13,937.78 5 - $ 19,146.90 646 FNMA Gov. Agency Debentur, 9/21/2017 1,295,866.00 (4,134.00) 1,268,696.00 9/14/2020 1.61% $ 9,370.83 $ - $ 16,136.27 807 US Treasury US Treasury Note 9/21/20/7 997,109.38 (2,890.62) 978,398.00 5/31/2020 1.48% $ 9,504.78 5 - $ 11,452.54 701 FNMA Gov. Agency Debentur, 12/13/2017 2,017,900.00 17,900.00 1,983,920.00 10/16/2020 2.02% $ 16,058.33 $ • $ 22,192.96 839 FNMA Gov. Agency Debentur, 04/17/13 981,984.01 (18,015.99) 983,379.00 802.08 8/2/2019 2.17% 5 (802.08) $ • $ 6,897.75 398 Oracle Corporate Bond 5/3/2018 1,028,370.00 28,370.00 1,022,866.00 15,972.22 7/8/2019 2.54% $ (15,972.22) 5 - 5 4,127.43 373 FHLB Gov. Agency Debentur 06/09/15 997,710.00 (2,290.00) 998,690.00 8/27/2018 12252 $ 31,241.66 $ 25,158.75 5 12,211.36 58 American Express Corporate Bond 9/15/2017 1,007,980.00 7,980.00 986,880.00 1/2/2020 1.87% $ 10,266.67 $ - 5 14,619.64 551 Treasury US Treasury Note 4/17/2018 1,190,343.75 (9,656.25) 1,189,875.60 975.41 9/30/2019 2.32% 5 1975.41) $ - 5 5,603.23 457 FHLB Gov. Agency Debentur, 5/25/2018 1,989,800.00 (10,200.00) 1,989,420.00 8,000.00 9/13/2019 2.40% 5 (8,000.00) $ . 5 4,716.63 440 Treasury US Treasury Note 07/31/15 1,010,625.00 10,625.00 1,000,000.00 6/30/2018 1.00% 5 40,091.71 $ 19,386.29 5 10,108.57 0 FraklicMae Gov. Agency Debentur, 12/20/2017 991,200.00 (8,800.00) 984,291.00 1/17/2020 1.93% 5 1,125.00 $ $ 10,119.43 566 FHLB 600. Agency Debenture 8/20/2015 1,247,075.00 (2,925.00) 3,249,250.00 7/25/2018 3.1352 5 32,229.37 5 26,310.93 $ 14,122.78 25 FHLB Gov. Agency Debentur, 8/25/2015 999,500.00 (500.00) 999,400.00 7/25/2018 1.07% $ 25,637.50 $ 19,734.71 5 10,671.36 25 American Honda Corporate Bond 4/11/2018 990,620.00 (9,380.00) 988,511.00 11/13/2019 2.61% $ 1,944.44 5 - $ 5,675.13 501 Disney Corporate Bond 12/1/2017 998,190.00 (1,810.00) 983,431.00 3/4/2020 2.03% 5 5,034.50 $ $ 11,736.09 613 FFCB Gov. Agency Debentur, 6/1/2018 1,001,454.00 1,454.00 999,920.00 10/21/2019 2.38% $ (688.89) $ 5 1,887.24 478 FHLB Gov. Agency Debentur, 10/27/2015 1,005,030.00 5,030.00 998,086.00 9/14/2018 0.95% $ 26,781.25 $ 15,939.59 $ 9,506.46 76 FFCB Gov. Agency Debentur, 10/29/2015 1,494,840.00 (5,160.00) 1,495,410.00 10/9/2018 0.99% $ 32,083.33 $ 24,860.21 $ 14,875.37 101 Chevron Corporate Bond 11/9/2017 1,366,834.50 16,834.50 1,341,563.85 5/24/2020 1.94% $ 20,477.81 5 $ 16,684.10 694 FHLMC Gov. Agency Debentur, 4/29/2016 1,008,050.00 8,050.00 996,500.00 12/17/2018 1.04% $ 28,800.00 5 12,220.02 5 10,445.69 170 FFCB Gov. Agency Debentur, 4/29/2016 1,001,870.00 1,870.00 992,060.00 3/21/2019 1.09% $ 21,975.56 5 12,814.27 $ 10,953.65 264 FFCB Gov. Agency Debentur, 10/28/2016 997,507.00 (2,493.00) 981,870.00 10/17/2019 1.14% $ 15,429.17 $ 7,611.40 $ 11,339.43 474 FNMA Gov. Agency Debentur 11/15/2016 1,487,505.00 (12,495.00) 1,475,467.50 8/28/2019 1.31% $ 19,291.66 $ 12,120.46 $ 19,488.85 424 FHLMC Gov. Agency Debentur 3/14/2017 1,970,180.00 (29,820.00) 1,968,406.00 7/19/2019 1.52% 5 14,826.39 $ 8,936.03 5 30,200.47 384 FNMA Gov. Agency Debentur 12/20/2017 1,545,642.95 14,357.05) 1,534,712.35 11/26/2019 1.90% $ 11,754.17 $ - $ 15,453.41 514 Freddie Mac Gov. Agency Debentur, 9/29/2017 998,900.00 (1,100.00) 980,670.00 6/29/2020 1.67% $ 12,187.50 $ 5 12,498.83 730 JP Morgan Chase Corporate Bond 3/28/2017 1,393,196.00 16,804.00) 1,378,797.00 8/23/2019 1.86% $ 22,779.17 5 6,677.49 $ 25,928.54 419 US Treasury US Treasury Note 3/31/2017 1,004,218.75 4,218.75 994,297.00 3/31/2019 1.29% $ 15,000.00 $ 3,213.83 $ 12,890.63 274 FNMA Gov. Agency Debentur, 4/25/2017 1,013,390.00 13,390.00 991,230.00 2/7/2020 1.50% $ 15,666.67 5 2,748.32 $ 15,199.07 587 PNC Bank Corporate Bond 4/4/2017 1,003,120.00 3,120.00 994,509.00 2/2/2019 1.29% $ 17,875.00 5 4,242.21 $ 17,797.76 217 Treasury US Treasury Note 5/2/2017 503,339.84 3,339.84 496,347.50 6/30/2019 1.31% $ 9,449.24 5 1,063.61 $ 6,579.95 365 Pcpsitn Corporate Bond 5/15/2017 1,249,600.00 (400.00) 1,227,988.75 3/30/2020 1.31% $ 22,161.46 $ 2,931.91 5 23,260.05 639 61),30 Corporate Bond 6/30/2017 1,002,280.00 2,280.00 985,522.00 12/15/2019 1.6052 $ 16,291.67 $ $ 16,073.27 533 Treasury US Treasury Note 6/30/2017 1,002,148.44 2,148.44 987,578.00 10/31/2019 1.41% $ 12,513.59 $ $ 14,080.68 488 Treasury US Treasury Note 6/30/2017 994,726.56 (5,273.44) 980,859.110 1/31/2020 1.46% $ 7,320.44 $ $ 14,536.83 580 Toyota Motor Credit Corporate Bond 10/6/2017 503,545.00 3,545.00 493,980.00 3/12/2020 1.85% 5 4,658.33 $ $ 6,797.80 621 Berkshire Hathaway Corporate Bond 1/22/2018 1,086,305.00 (13,695.00) 1,083,448.30 6,236.39 8/15/2019 2.11% 5 913.61 $ 5 10,049.50 411 Freddie Mac Gov. Agency Debentur, 3/1/2018 1,482,225.00 (17,775.00) 1,4.33,755.00 6/24/2019 2.11% 5 5,885.42 5 5 10,696.53 359 Subtotal $ 51.217.743.68 ' $ 50,699,999.95 5 31,986.10 $ 635,627.89 S 244,756.08 $ 570,952.68 BNY MM 183,202.62 183,202.62 0.00% LAW N/A 12/31/14 6,282,764.12 6,282,764.12 1.66% 88,893.71 $57,683,710.42 $57,165,966.69 5 635,627.89 $ 244,756.08 5 659 846.39 Bank of the West Matured Assets Treasury US Treasury Note 06/09/15 1,004,140.63 4,140.63 9/15/2017 0.82% $ 22,663.04 $ 16,846.70 $ 1,724.99 FNMA Gov. Agency Debentur, 10/19/12 1,504,050.00 4,050.00 9/20/2017 0.94% 5 73,791.67 $ 66,614.26 $ 3,185.06 FNMA Gov. Agency Debentur, 11/30/12 1,003,200.00 3,200.00 9/20/2017 0.93% $ 48,055.56 $ 42,785.13 5 2,097.06 FNMA Gov. Agency Debentur, 12/04/12 1,002,750.00 2,750.00 9/20/2017 0.94% $ 47,916.67 5 43,077.49 $ 2,117.72 FFCB Gov. Agency Debentur, 10/18/12 1,996,960.00 (3,040.00) 9/21/2017 0.86% $ 81,755.00 $ 80,942.48 5 3,915.05 FHLMC Gov. Agency Debentur, 3/27/2017 999,750.00 (250.00) 9/27/2017 1.52% $ 17,500.00 $ 4,683.87 $ 4,388.05 Toyota Motor Credit Corporate Bond 07/10/15 502,200.00 2,200.00 10/5/2017 1.05% $ 13,975.69 $ 10,406.77 $ 1,400.08 Chevron Corporate Bond 12/15/2015 1,252,262.50 2,262.50 11/9/2017 1.25% $ 32,293.33 5 24,080.64 $ 5,645.90 Disney Corporate Bond 9/25/2015 995,298.50 298.50 12/1/2017 1.0996 $ 23,896.58 $ 19,070.28 $ 4,560.29 FHLB Gov. Agency Debentur, 12/12/12 1,998,720.00 (1,280.00) 12/8/2017 0.76% $ 73,583.33 $ 69,427.17 $ 6,729.54 FFCB Gov. Agency Debentur, 07/30/15 2,509,525.00 9,525.00 12/18/2017 0.96% $ 67,03125 $ 46,358.27 $ 11,308.51 Wells Fargo Corporate Bond 2/2/2016 1,001,680.00 1,680.00 1/22/2018 1.56% $ 32,862.50 $ 22,036.28 $ 8,831.66 Treasury US Treasury Note 1/26/2016 1,494,902.34 (5,097.66) 2/28/2018 0.91% $ 23,550.82 $ 19,534.50 $ 13,685.40 FNMA Gov. Agency Debentun 04/17/13 1,004,400.00 4,400.00 3/5/2018 1.03% $ 54,937.50 $ 43,523.65 $ 7,031.83 Walmart Corporate Bond 9/25/2015 998,960.00 (1,040.00) 4/11/2018 1.17% $ 28,625.00 $ 20,570.26 $ 9,103.30 Treasury US Treasury Note 06/11/15 990,468.75 (9,531.25) 4/15/2018 1.09% $ 21,331.97 $ 22,291.07 $ 8,589.49 AAPL Corporate Bond 05/16/13 991,680.01 (8,319.99) 5/3/2018 1.17% $ 49,638.89 $ 48,171.42 $ 9,819.80 FHLB Gov. Agency Debentur, 06/11/15 1,991,820.00 (8,180.00) 5/25/2018 1.19% $ 62,533.33 $ 48,836.51 $ 21,422.95 FFCB Gov. Agency Debentur, 10/27/2015 1,048,230.00 48,230.00 6/1/2018 0.86% $ 71,347.22 $ 14,973.77 $ 8,220.89 Total Investments "Matured" 517,265,438.97 $ 1,249,440.83 $ 754,143.58 $ 793,623.97 Maturity Profile 0-1 year 1-2 years 2-3 years 3-5 years Market to Cost Position Report Amount 522,202,926.83 531,168,117.59 54,312,666.00 50.00 557,683,710.42 Amortised Institution Cost 8NY Assets 551217,743.68 8NY MM 183,202.62 LAW 6282,764.12 Totals: 557,683,710.42 Page 5 Weighted Average YTM 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 This Month $76,817,429 1.71% 1.76% 1.90% 2.08% 2.43% 2.70% 2.86% Town of Los Gatos Summary Investment Information May 31, 2018 1.71% Weighted Average Maturity (days) 394 Last Month $77,476,376 1.65% 1.66% 1.80% 2.01% 2.49% 2.80% 2.95% 2-3years 25% 3 - 5 years 15% One year ago $75,337,955 1.21% 0.93% 0.97% 1.07% 1.28% 1.75% 2.20% Portfolio Maturity Profile 1 - 2 years 30% 0 -1 year 30% 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 May 31, 2018 Fund Balances - Beginning of Month/Period Receipts Disbursements Fund Balances - End of Month/Period Portfolio Allocation: BNY MM US Treasury Notes Government Agency Debenture Notes Corporate Medium Term Bonds Local Agency Investment Fund Subtotal - Investments Reconciled Demand Deposit Balances Total Treasurer's Fund Month YTD $77,476,376.23 $75,983,998.32 2,699,410.12 41,394,012.58 (3,358,357.43) (40,560,581.98) $76,817,428.92 $76,817,428.92 $110,096.32 56,702,511.72 528,476,475.96 $13,013,457.00 6,282,764.12 54,585,305.12 22,232,123.80 $76,817,428.92 Portfolio Investment Allocation Local Agency Investment Fund BNY MM 11.5% 0 70 % Corporate Medium Term Bonds 23.8% % of Portfolio Max. % Or $ Allowed Per State Law or Policy 0.20% 12.28% 52.17% 23.84% 11.51% 20% of Town Portfolio No Max. on US Treasuries No Max. on Non -Mortgage Backed 30% of Town Portfolio $65M per State Law 100.00% US Treasury Notes 12.28% Government Agency Debenture Notes 52.17% 60.000,000 78,000,000 76,UCQ 74,000:... 72,000,C. 70,000. 65,000,,. 64,CG0,;: 62,000,E 00,000.C. n.lay-17 1ul-17 Aug-1i Treasurer's Fund Balances Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May - page 2 Town of Los Gatos Non -Treasury Restricted Fund Balances May 31, 2018 MAY 18 MAY 18 MAY 18 Previous Deposits Ending Balance Realized Gain/Adi. Interest Withdrawals Balance Non -Treasury Funds: Cert. of Participation 2002 Series A Reserve Fund $ 689,639.31 $ 589.97 $ 690,229.28 Note 1 Cert. Of Participation 2002 Ser A Lease Pymt Fund 51.66 0.04 51.70 Note 1 Cert. of Participation 2002 Series A Const. Fund 24.17 24.17 Note 1 1,291,583.54 1,581.15 1,293,164.69 Note 2 Total Restricted Funds: $ 1,981,298.68 $0.00 $2,171.16 $0.00 $1,983,469.84 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 May 31, 2018 Interest by Month July 2017 August 2017 September 2017 October 2017 November 2017 December 2017 January 2018 February 2018 March 2018 April 2018 May 2018 June 2018 $58,520.73 54,113.45 50,380.68 66,971.08 60,263.58 64,761.73 69,007.27 63,484.43 72,902.24 73,247.46 78,696.39 $712,349.04 Page 4 Town of Los Gatos Investment Schedule May 31, 2018 Orginal Issue Maturity Yield to Interest Interest Interest Days Deposl Original (Discount) Market Purchased Date or Maturity Received Earned Earned to Institution Secur83 Date Cost Premium Value Interest Call Date or Call to Date Prior Yrs. Current FY Maturhv Aug 17 security Freddie Mac Gov. Agency Debentun 08/01/16 1,005,560.00 5,560.00 990,301.00 4/15/2019 0.92% $ 18,437.50 5 8,387.83 $ 8,43821 319 Toyota Motor Credit Corporate Bond 07/25/16 954,246.50 4,246.50 939,156.70 5/20/2019 1.24% $ 24,198.61 $ 10,985.92 $ 10,624.36 354 FHLB Gov. Agency Debentun 9/20/2017 1,776,432.00 (8,568.00) 1,746,176.25 6/12/2020 1.56% $ 5,590.53 $ - $ 10,188.93 743 US Bancorp Corporate Bond 8J8/2016 1,019,550.00 19,550.00 997,834.00 10/15/2018 1.08% $ 34,504.17 $ 9,429.85 $ 9,690.18 137 Microsoft Corporate Bond BJ8/2016 999,470.00 (530.00) 984,664.00 8/8/2019 1.12% $ 16,500.00 5 9,982.45 $ 10,258.04 434 FFCB Gov. Agency Debentur, 9/20/2017 1,602,304.00 2,304,00 1,576,224.00 4/6/2020 1.54% $ 13,937.78 $• $ 17,117.20 676 FNMA Gov. Agency Debentur, 9/21/2017 1,295,866.00 (4,134.00j 1,268,969.00 9/14/2020 1.61% $ 9,370.83 $ - $ 14,419.64 837 US Treasury US Treasury Note 9/21/2017 997,109.38 (2,890.62) 979,608.00 5/31/2020 1.48% $ 9,SD4.78 $ - 5 10,234.18 731 FNMA Gov. Agency Debentur, 12/13/2017 2,017,900.00 17,900.00 1,988,060.00 10/16/20I0 2.02% $ 16,056.33 $ - $ 18,847.29 869 FNMA Gov. Agency Debentun 04/17/13 981,984.01 (18,015.99) 983,361.00 802.08 8/2/2019 2.17% $ (802.08) $ - $ 5,129.09 428 Oracle Corporate Bond 5/3/2018 1,028,370.00 28,370.00 1,026,924.00 15,972.22 7/8/2019 2.5454 5 (15,972.22) 5 $ 1,992.55 403 FHLB Gov. Agency Debentur, 06/09/15 997,710.00 (2,290.00) 997,930.00 8/27/2018 1.22% $ 31,241.66 $ 25,158.75 $ 11,207.69 88 American Express Corporate Bond 9/15/2017 1,007,980.00 7,980.00 987,673.00 1/2/2020 1.87% $ 10,266.67 5 - $ 13,096.76 581 Treasury US Treasury Note 4/17/2018 1,190,343.75 (9,656.23) 1,190,766.00 975.41 9/30/2019 2.32% $ (975.41) $ $ 3,331.65 487 FHLB Gov. Agency Debentur, 5/25/2018 1,989,800.00 (10,200.00) 1,991,800.00 8,000.00 9/13/2019 2.40% 5 (8,000.00) $ $ 786.11 470 Treasury 35 Treasury Note 07/31/15 1,010,625.00 30,625.00 999,700.00 6/30/2018 3.00% $ 33,216.71 $ 19,3H6.29 5 9,277.73 30 PrcddicMoc Gov. Agency Debentur, 12/20/2017 991,200.00 (8,800.00) 985,467.00 1/37/2020 1.93% $ 1,125.00 $ $ 8,538.27 596 FHLB Gov. Agency Debentur, 8/20/2015 1,207,075.00 (2,925.00) 1,248,325.00 7/25/2018 1.13% $ 32,229.17 $ 26,310.93 $ 12,962.006 55 FHLB Gov. Agency Debentur, 8/25/20157 999,500.00 (500.00) 998,660.00 7/25/2018 1.0796 525,637.50 $ 19,734.71 $ 9,794.26 55 American Honda Corporate Bond 4/11/2018 990,620.00 (9,380.00) 990,480.00 11/13/2019 2.61% $ 1,944.44 $ - $ 3,546:95 531 Disney Corporate Bond 12/1/2017 998,190.00 (1,810.00) 987,957.00 3/4/2020 2.03% $ 5,034.50 5 - $ 10,067.45 643 FFCB Gov. Agency Debentur, 10/27/2015 1,048,230.00 48,230.00 1000,000.00 6/1/2018 0.86% $ 57,597.22 $ 14,973.77 5 8,196.42 1 f9L8 Gov. Agency Debentur, 10/27/2015 1,005,030.00 5,030.00 996,615.00 9/14/2018 0.95% 5 26,781.25 5 15,939.59 $ 8,725.11 106 FFCB Gov. Agency Debentun 10/29/2015 1,494,840.00 (5,160.00) 1,493,835.00 10/9/2018 0.99% 5 32,083.33 $ 24,860.21 $ 13,652.T4 131 Chevron Corporate Bond 11/9/2017 1366,834.50 16,834.50 1,341,030.60 5/24/2020 1.94% $ 4,095.56 $ $ 14,535.93 724 FHLMC Gov. Agency Debentur, 4/29/2016 1,OOSA50.00 8,050.00 995,820.00 3I/17/2018 1.04% $ 22,050.00 $ 12,220.02 5 9,587.14 200 FFCB Gov. Agency Debentur, 4/29/2016 1,001,870.00 1,870.00 991,690.00 3/21/2019 1.09% $ 21,975.56 5 12,814.27 $ 10,053.35 294 FFCB Gov. Agency 0ebentur, 10/28/2016 997,507.00 (2,493.00) 982,390.00 10/17/2019 1.14% $ 15,429.17 $ 7.611.40 5 10,407.42 504 FNMA 000. Agency Debentun 11/15/2016 1,487,505.00 (12,495.00) 1,475,863.50 8/28/2019 1.31% $ 19,291.66 5 12,120.46 $ 17,887.03 454 FHLMC Gov. Agency Debentun 3/14/2017 1,970.180.00 (29,820.00) 1,968,346.00 7/19/2019 1.52% $ 14,826.39 $ 8,936.03 5 217,718.242 414 FNMA Gov. Agency Debentun 12/20/2017 1,545,642.95 (4,357.05) 1,536,604.90 11/26/2019 1.90% $ 11,754.17 $ - 5 13,038.82 544 Freddie Mac Gov. Agency Debentur, 9/29/2017 998,900.00 (1,100.00) 982,240.00 6/29/2018 1.67% $ 4,W2.50 $ $ 11,896.16 29 JP Morgan Chase Corporate Bond 3/28/2017 1,393,196.00 (6,804.00) 1,382,560.20 8/23/2019 1.86% $ 22,779.17 5 6,677.49 $ 23,797.43 449 US Treasury US Treasury Note 3/31/2017 1,004,218.75 4,218.75 994,102.OD 3/31/2019 1.29% $ 15,000.00 5 3,213.83 $ 11,831.12 304 FNMA Gov. Agency Debentur, 4/25/2017 1,013,390.00 13,390.00 992,670.00 2/7/2020 1.5030 S 15,666.67 $ 2,748.32 $ 13,949.83 617 PNC Bunk Corporate Bond 4/4/2017 1,003,120.00 3,120.00 995,456.00 2/2/2019 1.2930 5 17,875.00 5 4,242.21 $ 16,334.93 247 Treasury US Treasury Note 5/2/2017 503,339.84 3,339.84 496,465.00 6/30/2019 1.3154 5 5,386.74 $ 1,063.61 $ 6,039.14 395 Ppsisn Corporate Bond 5/15/2017 1,249,600.00 (400.00) 1,232,637.50 3/30/2020 1.31% $ 22.161.46 $ 2,931.91 $ 21,351.93 669 Pli,,cr Corporate Bond 6/30/2017 1,002,280.00 2,280.00 986,410.00 12/15/2019 1.60% $ 7,7911.67 $ - 5 14,752.18 563 Treasury US Treasury Note 6/30/2017 1,002,148.44 2,148.44 986,164.00 30/31/2019 1.41% $ 12,533.59 $ - 5 1I,923.36 518 Treasury US Treasury Note 6/30/2017 994,726.56 (5,273.44) 981,680.00 1/31/2020 1.46% $ 7,320.44 $ - $ 13,342.02 610 Toyota Motor Credit Corporate Bond 10/6/2017 503,545.00 3,545.00 494,089.50 3/12/2020 1.85% 5 4,658,33 $ - $ 6,034.01 651 Berkshire Hathaway Corporate Bond 1/22/2018 1,086,305.00 (13,695.00) 1,085,367.80 6,236.39 8/15/2019 2.11% 5 913.61 5 $ 8,153.37 441 Freddie Mac Gov. Agency Debentur, 3J1/2018 1,482,225.00 (17,775.00) 1.483,890.00 3,489.58 6/24/2019 2.11% $ (3,489.58) 5 . $ 8,044.50 389 Subtotal 5 51,264,519.68 ' $ 50,738,002.95 $ 35,475.68 $ 621,572.38 $ 259,729.85 $ 510,950.72 BNY MM 110,096.32 110,096.32 0.00% 1A19 N/A 12/31/14 6,282,764.12 6,282,764.12 1.66% 76,966.45 $57,657,380.12 $57,130,863.39 $ 621,572.38 $ 259,729.85 $ 587,917.18 Bank of the West Matured ASSet5 Treasury US Treasury Note 06/09/15 1,064,140.63 4,140.63 9/15/2017 0.82% $ 22,663.04 $ 16,846.70 $ 1,724.99 FNMA Gov. Agency Debentur, 10/19/12 1,504,050.00 4,050.00 9/20/2017 0.94% $ 73,791.67 $ 66,614.26 $ 3,185.06 FNMA Gov. Agency Debentur, 11/30/12 1,003,200.00 3,200.00 9/20/2017 0.93% $ 48,055.56 $ 42,785.13 $ 2,097.06 FNMA Gov. Agency Debentun 12/04/12 1,002,750.00 2,750.00 9/20/2017 0.94% 5 47,916.67 $ 43,077.49 $ 2,117.72 F9C6 Gov. Agency Debentun 10/18/12 1,996,960.00 (3,040.00) 9/21/2017 0.86% $ 81,755.00 $ 80,942.48 $ 3,915.05 FHLMC Gov. Agency Debentur, 3/27/2017 999,750.00 (250.00) - 9/27/2017 1.52% $ 17,500.00 $ 4,683.87 $ 4,388.05 Toyota Motor Credit Corporate Bond 07/10/15 502,200.00 2,200.00 10/5/2017 1.05% $ 13,975.69 $ 10,406.77 $ 1,400.08 Chevron Corporate Bond 12/15/2015 1,252,262.50 2,262.50 11/9/2017 1.25% $ 32,293.33 $ 24,080.64 $ 5,645.90 Disney Corporate Bond 9/25/2015 995,298.50 298.50 12/1/2017 1.09% $ 23,896.58 $ 19,070.28 5 4,560.29 FHLB Gov. Agency Debentur, 12/12/12 1,998,720.00 (1,280.00) 12/8/2017 0.76% 5 73,583.33 $ 69,427.17 $ 6,729.54 FFCB Gov. Agency Debentur, 07/30/15 2,509,525.00 9,525.00 12/18/2017 0.96% $ 67,031.25 $ 46,358.27 $ 11,308.51 Wells Fargo Corporate Bond 2/2/2016 1,001,680.00 1,680.00 1/22/2018 1.56% $ 32,862.50 $ 22,036.28 $ 8,831.66 Treasury US Treasury Note 1/26/2016 1,494,902.34 (5,097.66) 2/28/2018 0.91% $ 23,550.82 $ 19,534.50 $ 12,560.57 FNMA Gov. Agency Debentun 04/17/13 1,004,400.00 4p00.00 3/5/2018 1.03% $ 54,937.50 $ 43,523.65 $ 7,031.83 Walman Corporate Bond 9/25/2015 998,960.03 (1,040.00) 4/11/2018 1.17% $ 28,625.00 $ 20,570.26 $ 9,103.30 Treasury US Treasury Note 06/11/15 990,468.75 (9,531.25) 4/15/2018 1.09% $ 21,331.97 $ 22,291.07 $ 8,589.49 AAPL Corporate Bond 05/16/13 991,680.01 (8,319.99) 5/3/2018 1.17% $ 49,638.89 $ 48,171.42 $ 9,819.80 FHLB Gov. Agency Debentur, 06/11/15 1,991,820.00 (8,180.00) 5/25/2018 1.19% $ 62,533.33 $ 48,836.51 $ 21422.95 Total Investments "Matured" $17,265,438.97 Maturity Profile 0-1 year 1-2 years 2-3 yearn 3.5 years Market to Cost Position Report Amount $22,191,385.69 $28,011,852.55 57,454,141.88 $0.00 557,657,380.12 Amortized Institution Cost BNY Assets 551,264,519.68 BNY MM 110,096.32 IAIF 6,282,764.12 Totals: 557,657,380.12 5 1.235,385.32 5 769,117.35 $ 712,349.00 Page 5 Weighted Average YTM 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 This Month $77,476,376 2 - 3 years 25% 1.65% 1.66% 1.80% 2.01% 2.49% 2.80% 2.95% Town of Los Gatos Summary Investment Information April 30, 2018 1.65% Weighted Average Maturity (days) 398 Last Month One year ago $74,933,169 $76,205,509 3 - 5 years 1.60% 1.52% 1.71% 1.92% 2.27% 2.56% 2.71% Portfolio Maturity Profile 1.20% 0.88% 0.80% 0.97% 1.26% 1.81% 2.28% 30% 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 April 30, 2018 Fund Balances - Beginning of Month/Period Receipts Disbursements Fund Balances - End of Month/Period Portfolio Allocation: BNY MM US Treasury Notes Government Agency Debenture Notes Corporate Medium Term Bonds Local Agency Investment Fund Subtotal -Investments Reconciled Demand Deposit Balances Total Treasurer's Fund Month YTD $74,933,168.89 575,983,998.32 5,087,436.00 38,694,602.46 (2,544,228.66) 137,202,224.551 $77,476,376.23 $77,476,376.23 589,846.37 $6,702,511.72 $28,478,495.96 $12,976,767.01 6.282.764.12 54,530,385.18 22,945,991.05 577,476,376.23 % of Portfolio Max. % 0r $ Allowed Per State Law or Policy 0.16% 12.29% 52.23% 23.80% 11.52% 20% of Town Portfolio No Max. on US Treasuries No Max. on Non -Mortgage Backed 30% of Town Portfolio $65M per State Law 100.00% Portfolio Investment Allocation Local Agency Investment Fund BNY MM 11.5% 0 16% Corporate Medium Term Bonds 23.8% US Treasury Notes 12.2956 Government Agency Debenture Notes 52.23% '0.000.000 78,000,000 76,000,000 74,000,000 72,000,000 70,000,000 68,000,000 6E000,000 64,000,000 62;000,000 50.000,000 Apr-17 May-1 7 Jun-17 Jul-17 Treasurer's Fund Balances Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-1.8 Peh--1S Mar-18 Apr.13 page 2 Town of Los Gatos Non -Treasury Restricted Fund Balances April 30, 2018 APR 18 Previous Deposits Balance Realized Gain/Adi. Non -Treasury Funds: APR 18 APR 18 Interest Ending Withdrawals Balance Cert. of Participation 2002 Series A Reserve Fund $ 689,096.90 $ 542.41 $ 689,639.31 Note 1 Cert. Of Participation 2002 Ser A Lease Pymt Fund 51.61 0.05 51.66 Note 1 Cert. of Participation 2002 Series A Const. Fund 24.17 24.17 Note 1 1,290,072.35 1,511.19 1,291,583.54 Note 2 Total Restricted Funds: $ 1,979,245.03 $0.00 $2,053.65 $0.00 $1,981,298.68 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 April 30, 2018 Interest by Month July 2017 August 2017 September 2017 October 2017 November 2017 December 2017 January 2018 February 2018 March 2018 April 2018 May 2018 June 2018 $58,520.73 54,113.45 50,380.68 66,971.08 60,263.58 64,761.73 69,007.27 63,484.43 72,902.24 73,247.46 $633,652.65 Page 4 Town of Los Gatos Investment Schedule April 30, 2018 O,BinaUswe Maturity Yield to Interest Interest Interest Days Deposit Original (Discount) Market Purchased Date or Maturity Received Eamed famed to Institution S� Date Cost Premium Value Interest Call Date or hll to Date Prior Y,t. Current FY Matu Aug 17 Sccur' Freddie Mac Gov. Agency Debentur, 04/01J16 1,005,560.00 5,560.00 988,968.00 4/15/2019 0.92% $ 18,437.50 $ 8,387.83 $ 7,657.36 350 Toyota Motor Credit Corporate Bond 07/25/16 954,246.50 4,246.50 939,318.20 5/20/2019 1.24% $ 17,548.61 $ 10,985.92 $ 385 FHLB Gov. Agency Debentur, 9/20/2017 1,776,432.00 (8,568.00) 1,742,320.65 6/12/2020 1.56% $ 5,590.53 $ 9,822.71 $ 19,837.71 774 US Bancorp Corporate Bond 8/8/2016 1,019,550.00 19,550.00 998,076.00 10/15/2018 1.08% $ 24,754.17 $ 9,429.85 $ 8,793.48 168 Microsoft Corporate Bond 8/8/2016 999,470.00 (530.00) 982,239.00 8/8/2019 1.12% $ 16,500.00 $ 9,982.45 $ 9,308.79 465 FFCB Gov. Agency Debentur, 9/20/2017 1,602,304.00 2,304.00 1,571,280.00 4/6/2020 1.54% $ 13,937.78 $ - $ 15,019.83 707 FNMA Gov. Agency Oe6entur, 9/21/2017 1,295,866.00 (4,134.00) 1,266,187.00 9/14/2020 1.61% $ 9,370.83 $ - $ 12,645.80 868 US Treasury US Treasury Not, 9/21/2017 997,109.38 (2,890.62) 976,875.00 5/31/2020 1.46% $ 2,629.78 $ - $ 8,975.22 762 FNMA Gov. Agency Debentur, 12/13/2017 2,017,900.00 17,900.00 1,983,160.00 30/16/2020 2.0234 $ 16,058.33 S • $ 15,390.09 900 FNMA Gov. Agency Dehentur, 3/5/2018 981,984.01 (18,015.99) 981,160.00 802.08 8/2/2019 2.17% $ (802.06) 5 - $ 3,301.49 459 AAPL Corporate Bond 05/16/13 991,680.01 (8,319.99) 999,950.00 5/3/2018 1.1704 $ 44,638.89 $ 48,171.42 $ 9,723.85 3 FHLB 0ov. Agency Debentur 06/09/15 997,710.00 (2,290.00) 997,310.00 8/27/2018 1.22% $ 31,241.66 5 25,158.75 $ 10,170.56 119 American Express Corporate Bond 9/15/2017 1,007,980.00 7,980.00 987,392.00 1/2/2020 1.87% $ 10,266.67 $ - $ 11,523.12 612 Treasury US Treasury Note 4/17/2018 1,190,343.75 (9,656.25) 1,188,890.40 975.41 9/30/2019 2.32% $ (975.41) $ - $ 984.35 518 FHLB Gov. Agency Debentur, 06/11/15 1,991,820.00 (8,180.00) 1,999,064.00 5/25/2018 1.19% $ 52,033.33 $ 48,836.51 $ 19.795.06 25 Treasury US Treasury Note 07/31/15 1,010,625.00 10,625.00 999,367.00 6/30/2018 1.0094 $ 33,216.71 5 19,386.29 5 8,419.19 61 FraldicMac Gov. Agency Debentur, 12/20/2017 991,200.00 (8,800.00) 983,590.00 1/17/2020 1.93% $ 1,125.00 $ - 5 6,904.41 627 FHLB Gov. Agency Debentur, 8/20/2015 1,247,075.00 (2,925.00) 1,247,550.00 7/25/2018 1.13% $ 32,229.17 $ 26,310.93 5 11,762.53 86 FHLB Gov. Agency Debentur, 8/25/2015 999,500.00 (500.00) 998,040.00 7/25/2018 1.07% $ 25,637.50 $ 19,734.71 $ 8,887,93 86 American Honda Corporate Bond 4/11/2018 990,620.00 (9,380.00) 986,561.00 8,055.56 11/13/2019 2.61% $ (8,055.56) 5 - $ 1,347.84 562 Disney Corporate Bond 12/1J2017 998,190.00 (1,810.00) 984,231.00 3/4/2020 2.03% $ 5,034.50 $ • $ 8,343.19 674 FFCB Gov. Agency Debentur, 10/27/2015 1,048,130.00 48,230.00 1,000,860.00 6/1/2018 0.8604 $ 57,597.22 5 14,973.77 $ 7,437.95 32 FHLB Gov. Agency Dehentur, 10/27/2015 1,OD5,030.00 5,030.00 996,885.00 9/14/2018 0.95% $ 26,781.25 $ 15,939.59 $ 7,917.71 137 FFCB Gov. Agency Debentur, 10/29/2015 1,494,840.00 (5,160.00) 1,492,635.00 10/9/2018 0.99% $ 32,083.33 $ 24,860.21 $ 12,389.35 162 Chevron Corporate Bond 11/9/2017 1,366,834.50 16,834.50 1,341,700.20 5/24/2020 1.94% $ 4,095.56 $ - $ 12,316.16 755 FHLMC Gov. Agency Debentur, 4/29/2016 1,008,050.00 8,050.00 995,060.00 12/17/2018 1.0404 $ 22,050.00 $ 12,220.02 5 8,699.97 231 FFCB 00v. Agency Debentur 4/29/2016 1,001,870.00 1,870.00 990,970.00 3/21/2019 1.0904 $ 21,975.56 $ 12,814.27 5 9,123.04 325 FFCB Gov. Agency Debentur, 10/28/2016 997,507.00 (2,493.00) 979,790.0D 10/17/2019 3.14% $ 15,429.17 5 7,611.40 $ 9,d44.35 535 FNMA Gov. Agency Debootur, 11/15/2016 1,487,505.00 (12,495.00) 1,472,610.00 - 8/28/2019 1.3104 $ 19,291.66 5 12,120.46 5 16,231.81 485 FHLMC Gov. Agency Debentur, 3/14/2017 1,970,180.00 (29,820.00) 1,964,220.00 7/19/2019 1.52% $ 14,826.39 $ 8,936.03 5 25,153.27 445 FNMA Gov. Agency Debentur, 12/20/2017 1,545,642.95 [4,357.05) 1,533,162.35 11/26/2019 1.90% $ (3,808.33) $ - $ 30,543.74 575 Freddie Mac Gov. Agency Debentur, 9/29/2017 998,900.00 (1,100.00) 979,090.00 6/29/2018 1.67% $ 4,062.50 $ - $ 10,341.12 60 JP Morgan Chase Corporate Bond 3/28/2017 1,393,196.00 16,804.00) 1,378,543.60 8/23/2019 1.86% $ 224,779.17 $ 6,677.49 $ 21,595.28 480 US Treasury US Treasury Note 3/31/2017 1,004,218.75 4,218.75 993,086.00 3/31/2019 1.2934 $ 15,000.00 5 3,213.83 $ 10,736.30 335 FNMA Gov. Agency Dehentur, 4/25/2017 1,013,390.00 13,390.00 990,730.00 2/7/2020 1.5004 5 15,666.67 $ 2,748.32 $ 12,658.95 648 PNC Bank Corporate Bond 4/4/2017 1,003,120.00 3,120.00 995,026.00 2/2/2019 1.29% $ 37,675.00 $ 4,242.21 $ 14,823.34 278 Treasury US Treasury Note 5/2/2017 503,339.84 3,339.84 495,918.00 6/30/2019 1.3104 5 5,386.74 $ 1,063.61 5 5,480.29 426 Pepsicn Corporate Bond 5/15/2017 1,209,600.00 (400.00) 1,229,773.75 3/30/2020 1.31% 5 22,161.46 5 2,931.91 5 19,376.08 700 PtiitT Corporate Bond 6J30/2017 1,002,280.00 2,280.00 985,404.00 12/15/2019 L60% $ 7,791.67 5 5 13,387.06 594 Treasury US Treasury Note 6/30/2017 1,002,148.44 2,1d8.a4 986,445.00 10/31/2019 1.41% $ 12,533.59 5 - 5 11,727.47 549 Treasury US Treasury Note 6/30/2017 994,726.56 (5,273.d4) 979,375.00 1/31/2020 1.46% $ 7,320.44 $ - 5 12,107.39 641 Toyota Motor Credit Corporate Bond 10/6/2017 503,545.00 3,545.00 493,458.50 3/12/2020 1.85% $ 4,658.33 $ - $ 5,244.75 682 Berkshire Hathaway Corporate Bond 1/22/2018 1,086,305.00 (13,695.00) 1,081,356.10 6,236.39 8/15/2019 2.11% $ 913.61 $ - $ 6,194.03 472 Freddie Mac Gov. Agency Debentur, 3/1/2018 1,482,225.00 (17,775.00) 1,481,610.00 3,489.58 6/24/2019 2.11% $ (3,489.58) $ - $ 5,304.07 420 Subtotal 5 51,229,849.69 ' $ 50,639,257.75 $ 19,559.02 $ 695,379.32 $ 356,737.77 $ 473,847.95 BNY MM 89,846.37 89,846.37 0.00% 1A10 N/A 12/31/14 6,282,764.12 6,282,764.12 1.66% 67,777.91 557,602,460.18 557,011,868.24 $ 695,379.32 $ 356,737.77 $ 541,625.86 Bank of the West Matured Assets Treasury US Treasury Note 06/09/15 1,004,100.63 4,140.63 9/15/2017 0.82% $ 22,663.04 $ 16,846.70 $ 1,724.99 FNMA Gov. Agency Debentur, 10/19/12 1,504,050.00 4,050.00 9/2(7/2017 0.94% $ 73,791.67 $ 66,614.26 $ 3,185.06 FNMA Gov. Agency Dehentur, 11/30/12 1,003,200.00 3,200.00 9/20/2017 0.93% $ 48,055.56 $ 42,785.13 $ 2,097.06 FNMA Gov. Agency Debentur, 12/04/12 1,002,750.00 2,750.00 9/20/2017 0.94% $ 47,916.67 $ 43,077.49 $ 2,117.72 FFCB Gov. Agency Debentur, 10/18/12 1,996,960.00 (3,040.00) 9/21/2017 0.86% $ 81,755.00 5 80,942.48 5 3,915.05 FHLMC Gov. Agency Debentur, 3/27/2017 999,750.00 (250.00) - 9/27/2017 1.52% $ 17,500.00 $ 4,683.87 $ 4,388.05 Toyota Motor Credit Corporate Bond 07/10/15 502,200.00 2,200.00 10/5/2017 1.05% $ 13,975.69 $ 10,406.77 $ 1,400.08 Chevron Corporate Bond 12/15/2015 1,252,262.50 2.262.50 11/9/2017 1.25% $ 32,293.33 $ 24,080.64 $ 5,645.90 Disney Corporate Bond 9/25/2015 995,298.50 298.50 12/1/2017 1.09% $ 23,896.58 $ 19,070.28 $ 4,560.29 FHLB Gov. Agency Debentur, 12/12/12 1,998,720.00 (1,280.00) 12/8/2017 0.76% $ 73,583.33 $ 69,427.17 5 6,729.54 FFCB Gov. Agency Debentur, 07/30/15 2,509,525.00 9,525.00 12/18/2017 0.96% $ 67,031.25 $ 46,358.27 $ 11,308.51 Wells Fargo Corporate Bond 2/2/2016 1,001,680.00 1,680.00 1/22/2018 1.56% $ 32,862.50 $ 22,036.28 $ 8,831.66 Treasury US Treasury Note 1/26/2016 1,494,902.34 (5,097.66) 2/28/2018 0.91% $ 23,550.82 5 19,534.50 $ 11,398.25 FNMA Gov. Agency Debentur 04/17/13 1,004,401).00 4,400.00 3/5/2018 1.03% $ 54,937.50 $ 43,523.65 $ 7,031.83 Walmart Corporate Bond 9/25/2015 998,960.00 (1,040.00) #N/A 4/11/2018 1.17% $ 28,625.00 $ 20,570.26 $ 9,103.30 Treasury US Treasury Note 06/11/15 990.468.75 (9,531.25) aN/A 4/15/2018 1.09% $ 21,331.97 $ 22,291.07 $ 8,589.49 Total Investments "Matured" Maturity Profile 0-1 year 1-2 years 2-3 years 3-5 years Market to Cost Poskion Report 517,265,438.97 $ 1,309,192.26 $ 856,125.27 $ 633,652.65 Amount 524,200,389.25 $25,947,929.05 57.454,141.88 50.00 557,602,460.18 Amortized Institution Cost BNY Assets $51,229,849.69 BNY MM 89,846.37 1AIF 6,282,764.12 Totals: 557,602,460,18 Page 5