The URL can be used to link to this page

Home My WebLink About2017-03-28; City Council; ; Approve: Report on City Investments as of February 28, 2017Meeting Date To: From: March 28, 2017 Mayor and Council Members Kevin Crawford, City Manage�v- CA Review� ·Staff Contact:Craig Lindholm, City Treasurer; Nancy Sullivan, Deputy City Treasurer Nancy.Sullivan@carlsbadca.gov or 760-602-2473 Subject Approve: Report on City Investments as of February 28, 2017 Recommended Action Accept and file report. Executive Summary/Discussion The city's Investment Policy requires the City Treasurer to report to the City Council on a monthly basis the status of the city's pooled investment portfolio. A quarterly report is also required for the investments of bond proceeds held separately. The city's pooled investment portfolio as of the month ended February 28, 2017 is summarized below. Pooled Investment Portfolio {Cash and Securities) Current Month Prior Month Par Value 698,890,562 703,925,949 Cost of Investments 702,615,809 707,775,600 Amortized Cost (1) 700,676,612 705,840,004 Market Value (2) 698,378,689 703,170,074 (1)The cost of investments adjusted for amortized premiums and discounts. (2)The amount at which the investments could be sold. Source of market values is Union Bank of California's custodial report as of 2/28/17. The equity portion of the various funds in the total portfolio is summarized in the graph below. Fund balances are restricted for various purposes. See Exhibit 8 for a more detailed breakdown. FUND EQUITY IN POOLED INVESTMENTS (Dollar Amounts in Millions) General $118 Internal Service $45 Agency/frust $17 Enterprise $l79 Special Revenue $27 Capital Projects $ 315 Total Treasurer's Investment Portfolio at Amortized Cost February 28, 2017 $701 million Item #1 March 28, 2017 Page 1 of 21 CITY COUNCIL Staff Report Report on City Investments February 28, 2017 Meeting Date: March 28, 2017 Page2 Pooled Investment Interest Income Current Prior Cash Income Fiscal Year-to-Date * 6,137,058 5,351,174 *The cash income received is adjusted for any accrued interest purchased. Pooled Investment Performance/Measurement Average life Average Yield {Years} To Maturity December 2016 1.92 1.207% January 2017 1.94 1.242% February 2017 2.00 1.270% Current Month 785,884 Modified Duration 1.847 1.871 1.928 All pooled investments have been made in accordance with the city's Investment Policy adopted January 2, 1985 and last revised January 12, 2016. All investments were initially made in accordance with the city's Investment Policy. Events subsequent to the purchase might have resulted in some investments not being in compliance with the current policy. These events are typically a change in the city's Investment Policy, a change in the credit rating subsequent to a purchase, or a temporary reduction in total portfolio assets. See Exhibit 9 for details. The pooled investment portfolio has the ability to meet the city's cash flow demands for the next six {6) months. Fiscal Analysis None Next Steps The Report on City Investments is produced monthly by the City Treasurer. Environmental Evaluation (CEQA) Pursuant to Public Resources Code section 21065, this action does not constitute a "project" within the meaning of CEQA in that it has no potential to cause either a direct physical change in the environment, or a reasonably foreseeable indirect physical change in the environment, and therefore does not require environmental review. Item #1 March 28, 2017 Page 2 of 21 I I I I Report on City Investments February 28, 2017 Meeting Date: March 28, 2017 Page3 Public Notification This report is made available at least 72 hours prior to the posting of the agenda. Exhibits 1.Investment Portfolio Breakdown By Amortized Cost, Market Value, Cash Income, and Average Yield 2.Investment Portfolio Breakdown Of Maturities 3.Yield Comparison Graph 4.Market Yield Curve 5.Cumulative Cash Income Graph 6.Third Quarter Transactions 7.Detailed Investment Report 8.Fund Equity in Pooled Investments 9.Corporate Note and Commercial Paper Ratings 10.Percentage Weightings by Corporate Note Issuer Item #1 March 28, 2017 Page 3 of 21 CITY OF CARLSBAD INVESTMENT PORTFOLIO AS OF FEBRUARY 28, 2017 BREAKDOWN BY AMORTIZED COST, MARKET VALUE, CASH INCOME, AND AVERAGE YIELD BY CLASS AMORTIZED COST MARKET VALUE AVERAGE YIELD Cash Income Class Current Month Prior Month Current Month Prior Month Year to Date Current Month Prior Month CD 15,287,697 15,535,527 15,381,700 15,633,815 162,248 1.60 1.59 FN 17,901,744 17,879,569 17,851,796 17,842,136 0 1.61 1.61 TR 120,882,545 117,025,224 120,777,423 116,863,317 656,830 1.35 1.32 FA 299,955,604 288,288,934 298,351,537 286,549,983 2,622,637 1.28 1.25 CN 140,895,461 151,019,802 140,262,669 150,189,874 2,194,525 1.51 1.50 LAIF 102,240,000 111,903,432 102,240,000 111,903,432 499,791 0.76 0.75 CUSTODY 12,159 8,465 12,159 8,465 746 0.00 0.00 SWEEP 2,611,064 3,286,955 2,611,064 3,286,955 280 0.02 0.02 BANK ACCT 890,338 892,098 890,338 892,098 0 0.02 0.02 TOTALS 700,676,612 $705,840,005 $698,378,689 $703,170,074 6,137,058 1.27% 1.24% CD -Certificate of Deposit FA-Federal Agency Custody -Investment Cash account FN -Federal Discount Notes CN -Corporate Notes SWEEP -General Fund Overnight Cash acccount TR -US Treasury LAIF -Local Agency Investment Fund Bank Account -General Fund Cash account H H I-' Item #1 March 28, 2017 Page 4 of 21 CLASS CD FN TR FA CN LAIF CUSTODY SWEEP BANK ACCT TOTALS %TOTALS CITY OF CARLSBAD INVESTMENT PORTFOLIO AS OF FEBRUARY 28, 2017 BREAKDOWN OF MATURITIES BY CLASSIFICATION AND LENGTH OF TIME WITHIN 6 MONTHS 7 MONTHS TO 1 YEAR 1 TO 5 YEARS TOTAL 0 3,435,713 11,844,825 15,280,537 0 0 17,462,027 17,462,027 16,510,859 11,575,476 92,893,434 120,979,769 34,017,073 38,951,158 227,437,924 300,406,155 10,272,717 9,191,338 123,269,704 142,733,758 I 02,240,000 0 0 102,240,000 12,159 0 0 12,159 2,611,064 0 0 2,611,064 890,338 0 0 890,338 $166,554,211 (1) $63,153,685 (1) $472,907,914 $702,615,809 23.7% 9.0% 67.3% 100.0% Total within One Year $229,707,895 (I) POLICY: 32.7% (I)Not less than $168,954,000 to mature within one year. (2/3rds of current year operating budget of$253,430,000.00) (2)Policy states that not more than 30% of portfolio is to be invested in corporate notes. %TOTAL 2.2% 2.5% 17.2% 42.8% 20.3% (2) 14.6% 0.0% 0.4% 0.1% 100.0% N Item #1 March 28, 2017 Page 5 of 21 2.70 2.60 2.50 2.40 2.30 2.20 2.10 2.00 1.90 1.80 1.70 1.60 1.50 1.40 1.30 1.20 1.10 -1.000.900.800.700.600.500.400.300.200.100.00 YIELD COMPARISON � � � ' '--. '�/ .. � -''� '" '" " PORTFOLIO EX-LAIF VS. LAIF JULY 2010-FEBRUARY 2017 _.._t-X-1 All- '-' '\. "'-- � � � ......._ . - , "" , " " "" ,, '" , � A " " �• A IS::--.... . -- " ,, ,, ,, ,, .A � � � w � .,,.� � I I I I I I I I I I I I I I I I I I I I 1 1 I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I w Item #1 March 28, 2017 Page 6 of 21 1 ...... ' ... • @ • ' ... @ @ • I I I • • • I $ ~~~ ' ----.,-V ~ .. .... _ ....,I,._ l"''"' L ~-·- 5'~1 1010101(~,i~*)IOIE)!()l(,1€~ . , ,,,):C,i~~~1~l~,1,,1~,1~,1~~1,~1Ei1,~1,,1E~l~~l~,l~~IOl1 i1(,l~)l~)l~)l1 ,1~~IE~l~,i()I~ ,.:,ti.. MARKET YIELD CURVE 6/30/15, 6/30/16, 2/28/17 Market Rates 3.5 �----------------- 3 -+-------------------- 2. 5 -+-------------------- 2 -+---------------=��--=--�-- 1.5 -+---------�r,;,0.:W"'---"------------------:;�----,,,........,,..-_.---=,-="' ,,,........,,.. ,,,........,,.. 1 -+-----��=----------c..ao�------==---114'-=------ 0.5 +----=------��"'-------------------- 0 -=------�----�-----� 3 Mth 3 Mth �---� ---6/30/2015 .01 .,..... 6/30/2016 .26 wcr?>+u2/28/2017 .60 2 Yr 2Yr .65 .58 1.26 5 Yr 1.65 1.00 1.93 5 Yr IO Yr 2.35 1.47 2.39 10 Yr Item #1 March 28, 2017 Page 7 of 21 -,- Cumulative Millions$ 10 9 8 7 6 5 4 3 2 1 0 Cumulative Cash Income FY16-17 (February 2017) 0. 76 0.83 0.68 0.91 0.79 .,,,,,,,,,.. .IY"' .,,,,,,,,,..� Monthly Interest Income Millions$ .,,,,,,,,,.. � 7 6 5 4 3 2 1 0 Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun c=Jlnterest Income -+--Budget ---Actual YTD I Item #1 March 28, 2017 Page 8 of 21 8 .,..,.. - 11111 ~.,,,- ~ 1- 0.95 , 0.66 -n 0.58 I I I 1- I [J [J I I I I -r I I I I I C---------'-----' ------ TRANSACTIONS FOR PERIOD: 01/01/17 TO 02/28/17 3rd QUARTER 2016-2017 Trans Investment Call Par Amount Return Investment Date Date � Security Date Value Coupon (Cost) Rate Interest Return BUYS JANUARY 01/03/17 01/04/17 FA FHLMC 2/28/2017 2,000,000.00 1.250% 1,978,000.00 1.610% 100,750.00 2,078,750.00 01/05/17 01/06/17 FA FFCB 4/13/2017 1,000,000.00 1.400% 992,000.00 1.652% 53,772.22 1,045,772.22 01/05/17 01/06/17 TR US TREASURY N/A 4,000,000.00 2.125% 4,052,128.00 1.850% 371,463.16 4,423,591.16 01/09/17 01/10/17 TR US TREASURY N/A 1,250,000.00 1.625% 1,258,593.75 1.358% 44,936.98 1,303,530.73 01/09/17 01/10/17 TR US TREASURY N/A 1,400,000.00 1.375% 1,395,520.00 1.480% 64,835.66 1,460,355.66 01/12/17 01/13/17 TR US TREASURY N/A 1,300,000.00 1.375% 1,289,234.38 1.601% 78,611.61 1,367,845.99 01/05/17 01/18/17 CD MB FINANCIAL BANK N/A 249,000.00 2.050% 249,000.00 2.050% 25,522.50 274,522.50 01/17/17 01/20/17 CN NY LIFE GLOBAL N/A 2,000,000.00 1.950% 2,000,000.00 1.950% 119,275.00 2,119,275.00 01/19/17 01/20/17 TR US TREASURY N/A 2,750,000.00 1.125% 2,673,515.63 1.831% 203,567.42 2,877,083.05 01/19/17 01/20/17 TR US TREASURY N/A 1,500,000.00 1.125% 1,448,203.13 1.925% 145,113.79 1,593,316.92 01/19/17 01/20/17 TR US TREASURY N/A 3,000,000.00 1.500% 2,928,555.00 2.000% 297,790.11 3,226,345.11 01/05/17 01/20/17 CD FIRST NATL BANK OF AMERICA N/A 249,000.00 2.050% 249,000.00 2.050% 25,522.50 274,522.50 01/09/17 01/26/17 FA FHLMC 7/26/2017 2,000,000.00 2% STEP 2,000,000.00 2.360% 237,500.00 2,237,500.00 01/26/17 01/27/17 FA FNMA N/A 1,000,000.00 0.000% 950,223.00 1.900% 49,777.00 1,000,000.00 01/26/17 01/27/17 TR US TREASURY N/A 1,000,000.00 1.375% 1,003,590.00 1.200% 25,125.47 1,028,715.47 01/26/17 01/27/17 TR US TREASURY N/A 1,000,000.00 1.500% 1,005,980.00 1.220% 26,616.15 1,032,596.15 01/26/17 01/27/17 FA FFCB N/A 1,000,000.00 1.550% 1,004,421.67 1.430% 36,911.66 1,041,333.33 FEBRUARY 02/02/17 02/07/17 CN MICROSOFT N/A 2,000,000.00 1.550% 1,947,120.00 2.170% 192,466.11 2,139,586.11 02/02/17 02/03/17 TR US TREASURY N/A 1,850,000.00 2.125% 1,867,632.81 1.920% 175,237.36 2,042,870.17 02/09/17 02/16/17 FA FHLB 2/16/2018 1,325,000.00 2.000% 1,325,000.00 2.000% 119,250.00 1,444,250.00 02/14/17 02/16/17 FA FHLMC N/A 1,400,000.00 1.875% 1,392,580.00 2.000% 124,086.67 1,516,666.67 02/16/17 02/17/17 TR US TREASURY N/A 1,225,000.00 1.125% 1,194,853.52 1.760% 85,690.25 1,280,543.77 02/17/17 02/21/17 FA FFCB 4/18/2017 1,250,000.00 2.140% 1,250,000.00 2.140% 124,610.42 1,374,610.42 02/17/17 02/21/17 TR US TREASURY N/A 800,000.00 1.500% 803,875.00 1.283% 23,388.74 827,263.74 02/17/17 02/21/17 FA FHLB N/A 1,000,000.00 2.375% 1,024,070.00 1.497% 42,693.89 1,066,763.89 02/17/17 02/23/17 FA FAMCA N/A 2,600,000.00 2.100% 2,609,204.00 2.025% 263,796.00 2,873,000.00 02/14/17 02/28/17 FA FHLB 2/28/2018 2,600,000.00 1.25% STEP 2,600,000.00 2.239% 292,500.00 2,892,500.00 02/23/17 02/24/17 FA FHLB 11/22/2017 1,500,000.00 1.125% STEP 1,500,000.00 2.170% 155,062.50 1,655,062.50 MARCH 02/21/17 03/06/17 CN EXXON 1/6/2022 2,000,000.00 2.397% 2,003,380.00 2.360% 236,320.00 2,239,700.00 TOTAL THIRD QUARTER 2016-2017 46,248,000.00 45,995,679.89 1.885% 3,742,193.17 49,737,873.06 MATURITIES JANUARY 01/03/13 FA FHLMC N/A 3,000,000.00 0.600% 2,998,500.00 0.613% 73,500.00 3,072,000.00 09/18/14 CN COLGATE-PALMOLIVE N/A 500,000.00 1.300% 504,585.00 0.900% 4,970,415.00 5,475,000.00 01/31/12 CN BERSHIRE HATHAWAY N/A 5,000,000.00 1.900% 5,047,739.83 1.700% 427,260.17 5,475,000.00 trj 01/31/12 CN HSBC BANK N/A 5,000,000.00 2.5% FLOATING 5,000,000.00 1.748% 425,000.00 5,425,000.00 03/05/12 CN BERSHIRE HATHAWAY N/A 2,850,000.00 1.900% 2,914,809.00 1.418% 200,676.42 3,115,485.42 H ttJ H f--:1 O"\ Item #1 March 28, 2017 Page 9 of 21 TRANSACTIONS FOR PERIOD: 01/01/17 TO 02/28/17 3rd QUARTER 2016-2017 Trans Investment Call Par Amount Return Investment Date Date � Security Date Value Coupon (Cost) Rate Interest Return FEBRUARY 08/06/12 CN IBM N/A 5,000,000.00 1.250% 5,077,000.00 0.900% 204,250.00 5,281,250.00 02/16/12 CN WESTPAC BANKING CORP N/A 5,000,000.00 2.300% 5,000,000.00 2.300% 574,680.56 5,574,680.56 02/05/16 CN PEFOC N/A 2,000,000.00 1.375% 2,012,360.00 0.770% 15,903.89 2,028,263.89 02/28/12 CD MERCANTILE BANK OF MICHIG1 N/A 248,000.00 1.150% 247,380.00 1.150% 14,895.62 262,275.62 TOTAL THIRD QUARTER 2016-2017 28,598,000.00 28,802,373.83 1.446% 6,906,581.66 35,708,955.49 CALLS JANUARY 04/25/16 04/27/16 FA FHLMC 1/27/2017 2,000,000.00 0.75% STEP 1,999,000.00 1.559% 117,250.00 2,116,250.00 FEBRUARY -NONE MARCH 2/22/2016 03/10/16 FA FNMA 3/10/2017 2,500,000.00 1% STEP 2,500,000.00 1.724% 215,000.00 2,715,000.00 TOTAL THIRD QUARTER 2016-2017 4,500,000.00 4,499,000.00 1.651% 332,250.00 4,831,250.00 Item #1 March 28, 2017 Page 10 of 21 INVESTMENT REPORT AS OF FEBRUARY 28, 2017 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN {Days) 4/25/2014 FA FHLB .875% NON-CALL 3,000,000.00 3,002,460.00 0.846% 73,008.75 3,075,468.75 1,050 10/30/2015 FA FHLB .075% NON-CALL 3,500,000.00 3,507,910.00 0.580% 27,235.83 3,535,145.83 489 6/26/2015 FA FNMA 1.125% NON-CALL 1,250,000.00 1,260,975.00 0.643% 14,845.31 1,275,820.31 671 9/6/2013 FA FHLMC .70% CALL 5/8/15 ONE TIME 5,000,000.00 4,855,000.00 1.515% 273,527.78 5,128,527.78 1,340 1/27/2015 FA FHLMC 1.25% NON-CALL 2,000,000.00 2,025,640.00 0.685% 31,651.67 2,057,291.67 836 8/16/2012 FA FHLB .875% NON-CALL 4,000,000.00 4,000,000.00 0.875% 169,166.67 4,169,166.67 1,765 5/15/2015 FA TVA 5.50% NON-CALL 500,000.00 551,225.00 0.742% 8,587.50 559,812.50 795 7/25/2016 FA FHLB .625% NON-CALL 2,000,000.00 1,999,700.00 0.640% 12,800.00 2,012,500.00 365 5/20/2015 FA FHLMC 1.0% NON-CALL 2,125,000.00 2,138,812.50 0.702% 32,701.39 2,171,513.89 800 10/28/2015 FA FHLMC 0.70% QRTL Y CALL 3,000,000.00 3,000,000.00 0.700% 36,750.00 3,036,750.00 639 11/20/2013 FA FFCB . 700% CALL 11 /26/13 QRTL Y 2,000,000.00 1,975,000.00 1.043% 77,072.22 2,052,072.22 1,358 10/9/2015 FA FHLB 0.75% NON-CALL 2,000,000.00 2,004,800.00 0.622% 23,491.67 2,028,291.67 689 12/29/2015 FA FHLB .75% NON-CALL 1,000,000.00 995,550.00 1.020% 16,929.17 1,012,479.17 608 4/26/2016 FA FHLB .75% NON-CALL 2,700,000.00 2,700,000.00 0.750% 27,112.50 2,727,112.50 489 4/26/2016 FA FNMA 1.0% NON-CALL 2,096,000.00 2,102,707.20 0.770% 22,636.80 2,125,344.00 512 3/26/2014 FA FHLB 1.05% CALL 9/26/14 ONE TIME STEP 2,000,000.00 2,000,000.00 1.050% 73,500.00 2,073,500.00 1,280 1/23/2014 FA FFCB 1.160% NON-CALL 2,000,000.00 1,995,000.00 1.229% 92,000.00 2,087,000.00 1,369 2/19/2013 FA FFCB .87% CALL 11/27/13 CONT 2,000,000.00 1,985,000.00 1.030% 98,036.67 2,083,036.67 1,742 5/28/2013 FA FHLMC .75% CALL 5/28/15 ONE TIME 5,000,000.00 5,000,000.00 0.750% 168,750.00 5,168,750.00 1,645 3/6/2013 FA FNMA 1.0% CALL 3/6/15 ONE TIME 3,050,000.00 3,050,000.00 1.000% 144,875.00 3,194,875.00 1,736 12/3/2012 FA FHLB 2.625% NON-CALL 3,000,000.00 3,270,090.00 0.790% 124,753.75 3,394,843.75 1,831 1/22/2013 FA FHLMC .95% CALL 1 /22/15 QRTL Y 3,350,000.00 3,341,826.00 1.000% 167,299.00 3,509,125.00 1,826 1/25/2013 FA FAMCA .93% NON-CALL 5,000,000.00 5,004,870.00 0.910% 227,500.83 5,232,370.83 1,825 2/1/2013 FA FAMCA 1.05% NON-CALL 5,000,000.00 5,000,000.00 1.000% 262,354.17 5,262,354.17 1,824 11/3/2015 FA FNMA .875% NON-CALL 2,700,000.00 2,700,891.00 0.860% 52,593.37 2,753,484.37 828 5/8/2013 FA FHLB 1.10% CALL 2/20/14 CONT 1,000,000.00 1,000,774.00 1.080% 51,842.67 1,052,616.67 1,749 2/20/2015 FA FFCB 1.11 % NON-CALL 2,500,000.00 2,500,000.00 1.110% 83,250.00 2,583,250.00 1,096 7/21/2016 FA FHLB 1.375% NON-CALL 5,000,000.00 5,048,990.00 0.770% 63,301.67 5,112,291.67 596 10/26/2016 FA FFCB 0.75% NON-CALL 1,600,000.00 1,598,592.00 0.810% 19,141.33 1,617,733.33 539 8/5/2014 FA FNMA 0.875% NON-CALL 2,500,000.00 2,460,777.84 1.300% 122,225.63 2,583,003.47 1,385 5/30/2013 FA FHLB 1.050% CALL 7/4/13 CONT 3,000,000.00 2,964,750.00 1.050% 193,100.00 3,157,850.00 1,831 6/21/2016 FA FHLB 1.25% NON-CALL 4,000,000.00 4,034,280.00 0.809% 63,914.44 4,098,194.44 717 10/19/2015 FA FFCB 1.03% CALL 1/13/16 CONT 3,000,000.00 3,000,000.00 1.030% 84,460.00 3,084,460.00 998 12/29/2015 FA FNMA 1.125% NON-CALL 1,000,000.00 997,610.00 1.220% 31,171.25 1,028,781.25 934 7/27/2016 FA FNMA .875% ONE CALL 7/27/17 3,000,000.00 2,997,750.00 0.913% 54,750.00 3,052,500.00 730 1/27/2015 FA FNMA 1.0% NON-CALL 1,100,000.00 1,096,139.00 1.102% 42,452.67 1,138,591.67 1,280 5/5/2014 FA FFCB 1.6% NON-CALL 2,500,000.00 2,515,710.93 1.450% 157,622.40 2,673,333.33 1,584 10/27/2015 FA FHLB 1.125% NON-CALL 4,000,000.00 4,020,840.00 0.941% 108,785.00 4,129,625.00 1,053 5/2/2014 FA FNMA 1.875% NON-CALL 1,500,000.00 1,524,000.00 1.500% 99,125.00 1,623,125.00 1,600 ::r: 1/16/2014 FA FHLMC 1.20% CALL 9/24/14 ONE TIME 2,250,000.00 2,196,562.50 1.729% 180,037.50 2,376,600.00 1,712 H 5/23/2016 FA FNMA 1.125% NON-CALL 2,000,000.00 2,006,660.00 0.984% 47,465.00 2,054,125.00 879 td H 3/30/2015 FA FHLB 1.30% NON-CALL 1,000,000.00 1,000,000.00 1.300% 46,583.33 1,046,583.33 1,310 t-3 5/2/2014 FA FNMA 1.625% NON-CALL 2,000,000.00 2,008,347.18 1.530% 140,159.76 2,148,506.94 1,670 6/3/2014 FA FNMA 1.625% NON-CALL 2,000,000.00 2,010,791.92 1.500% 134,826.14 2,145,618.06 1,638 Item #1 March 28, 2017 Page 11 of 21 INVESTMENT REPORT AS OF FEBRUARY 28, 2017 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN (Days) 7/21/2015 FA FNMA 1.50% NON-CALL 1,000,000.00 1,006,875.00 1.290% 43,500.00 1,050,375.00 1,228 5/15/2015 FA FNMA 1.25% CALL 6/14/15 QRTL Y 1,000,000.00 997,500.00 1.322% 47,256.94 1,044,756.94 1,309 6/5/2015 FA FHLB 1.75% NON-CALL 2,000,000.00 2,034,100.00 1.254% 16,625.00 2,050,725.00 1,288 2/20/2015 FA FNMA 1.1 % NON-CALL 1,000,000.00 992,180.00 1.300% 49,925.56 1,042,105.56 1,397 10/28/2015 FA FFCB 1.15% CALL 1/28/16 4,650,000.00 4,648,837.50 1.158% 174,956.25 4,823,793.75 1,188 11/2/2015 FA FNMA 1.20% CALL 4/29/16 5,000,000.00 4,992,500.00 1.247% 202,000.00 5,194,500.00 1,184 2/26/2016 FA FFCB 1.03% NON-CALL 4,000,000.00 4,004,640.00 0.990% 117,357.78 4,121,997.78 1,096 12/9/2014 FA FNMA 1. 75% NON-CALL 2,500,000.00 2,515,625.00 1.596% 168,854.17 2,684,479.17 1,541 12/12/2014 FA FNMA 1.70% NON-CALL 1,852,000.00 1,863,630.56 1.545% 120,864.61 1,984,495.17 1,538 10/6/2014 FA FHLB 1.875% NON-CALL 2,000,000.00 2,011,440.00 1.875% 154,393.33 2,165,833.33 1,614 1/29/2016 FA FHLB 4.250% NON-CALL 1,500,000.00 1,643,640.00 1.166% 20,895.83 1,664,535.83 1,158 12/19/2016 FA FAMCA 1.86% NON-CALL 500,000.00 505,300.00 1.390% 16,167.50 521,467.50 842 6/6/2014 FA FHLMC 1.2% CALL 5/7 /15 1,000,000.00 976,800.00 1.693% 82,233.33 1,059,033.33 1,796 6/5/2015 FA FHLMC 1.75% NON-CALL 1,650,000.00 1,670,229.00 1.432% 94,869.96 1,765,098.96 1,455 7/10/2015 FA FHLMC 1.75% NON-CALL 1,000,000.00 1,015,100.00 1.350% 52,955.56 1,068,055.56 1,420 7/15/2015 FA FAMCA 1.50% NON-CALL 1,060,000.00 1,060,000.00 1.500% 62,230.83 1,122,230.83 1,430 2/26/2016 FA FAMCA 1.50% NON-CALL 3,000,000.00 3,033,300.00 1.156% 115,200.00 3,148,500.00 1,204 6/24/2015 FA FFCB 1.52% NON CALL 2,000,000.00 2,002,320.00 1.490% 119,280.00 2,121,600.00 1,461 6/26/2015 FA FFCB 1.52% NON-CALL 2,250,000.00 2,251,282.50 1.505% 135,327.50 2,386,610.00 1,459 6/28/2016 FA FNMA 1.20% CALL 12/28/16 2,500,000.00 2,500,000.00 1.200% 90,000.00 2,590,000.00 1,095 1/23/2015 FA FFCB 2.15% NON-CALL 3,250,000.00 3,354,097.50 1.410% 209,175.42 3,563,272.92 1,636 7/26/2016 FA FNMA 1.05% ONE CALL 7/26/18 2,300,000.00 2,300,000.00 1.050% 48,300.00 2,348,300.00 1,095 1/21/2015 FA FHLMC 1.25% NON-CALL 2,500,000.00 2,493,975.00 1.305% 147,518.06 2,641,493.06 1,653 8/30/2016 FA FNMA 1.0% ONE CALL 8/28/18 2,400,000.00 2,400,000.00 1.000% 71,866.67 2,471,866.67 1,093 10/23/2014 FA FHLB 2.00% NON-CALL 1,500,000.00 1,525,968.30 1.630% 120,698.37 1,646,666.67 1,786 1/21/2015 FA FHLB 1.375% NON-CALL 2,000,000.00 2,000,440.00 1.370% 127,282.22 2,127,722.22 1,696 1/27/2017 FA FFCB 1.550% NON-CALL 1,000,000.00 1,003,130.00 1.430% 38,203.33 1,041,333.33 973 7/19/2016 FA FHLMC 1.25% NON-CALL 3,000,000.00 3,027,363.00 1.250% 92,741.17 3,120,104.17 1,170 10/6/2015 FA FNMA 1.33% NON-CALL 4,183,000.00 4,197,807.82 1.240% 210,509.47 4,408,317.29 1,479 5/26/2016 FA FNMA 1.30% QRTL Y CALL 4,000,000.00 4,000,000.00 1.300% 182,000.00 4,182,000.00 1,279 6/15/2015 FA FHLB 2.375% NON-CALL 3,370,000.00 3,468,026.56 1.700% 261,697.54 3,729,724.10 1,642 2/21/2017 FA FHLB 2.375% NON-CALL 1,000,000.00 1,024,070.00 1.497% 42,693.89 1,066,763.89 1,025 12/30/2015 FA FFCB 1.72% CALL 12/30/16 2,600,000.00 2,600,000.00 1.720% 178,880.00 2,778,880.00 1,461 10/5/2015 FA FHLMC 1.40% NON-CALL 3,500,000.00 3,519,495.00 1.265% 189,299.44 3,708,794.44 1,557 5/13/2016 FA FHLMC 1.30% CALL 2/13/17 ONE TIME 2,750,000.00 2,750,000.00 1.300% 134,062.50 2,884,062.50 1,371 7/28/2016 FA FNMA 1.20% CALL 7/28/17 ONE TIME 4,850,000.00 4,850,000.00 1.200% 203,700.00 5,053,700.00 1,279 2/24/2016 FA FHLMC 1.50% CONT CALL 1,750,000.00 1,750,000.00 1.500% 105,000.00 1,855,000.00 1,461 2/24/2016 FA FFCB 1.4% CONT CALL 1,000,000.00 1,000,000.00 1.400% 56,000.00 1,056,000.00 1,461 1/4/2017 FA FHLMC 1.25% QRTL Y CALL 2,000,000.00 1,978,000.00 1.610% 100,750.00 2,078,750.00 1,150 7/13/2016 FA FNMA 1.25% CALL 4/13/17 ONE TIME 5,000,000.00 5,000,000.00 1.250% 234,375.00 5,234,375.00 1,370 1/6/2017 FA FFCB 1.4% CONT CALL 1,000,000.00 992,000.00 1.652% 53,772.22 1,045,772.22 1,193 7/28/2016 FA FNMA 1.25% CALL 4/28/17 ONE TIME 3,750,000.00 3,750,000.00 1.250% 175,781.25 3,925,781.25 1,370 5/26/2015 FA FNMA 1.7% CALL 5/26/17 ONE CALL 3,000,000.00 3,000,000.00 1.700% 255,000.00 3,255,000.00 1,827 6/12/2015 FA FHLB 1.75% NON-CALL 3,000,000.00 3,000,000.00 1.750% 262,500.00 3,262,500.00 1,827 2/23/2016 FA FHLB 1.75% NON-CALL 2,000,000.00 2,039,980.00 1.271 % 110,617.22 2,150,597.22 1,571 Item #1 March 28, 2017 Page 12 of 21 INVESTMENT REPORT AS OF FEBRUARY 28, 2017 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN (Days) 4/15/2016 FA FNMA 1.35% NON-CALL 2,150,000.00 2,159,632.00 1.240% 112,192.37 2,271,824.37 1,533 7/13/2016 FA FFCB 1.19% CALL 7 /13/17 CONT 4,250,000.00 4,250,000.00 1.190% 202,300.00 4,452,300.00 1,461 1/21/2016 FA FHLB 1.83% NON-CALL 2,500,000.00 2,549,375.00 1.378% 157,516.67 2,706,891.67 1,651 9/7/2016 FA FFCB 1.32% CALL 8/24/17 CONT 3,000,000.00 2,998,260.00 1.335% 158,710.00 3,156,970.00 1,447 4/19/2016 FA FHLMC 1.65% NON-CALL 1,000,000.00 1,017,760.00 1.230% 54,152.50 1,071,912.50 1,592 6/8/2016 FA FHLB 2.875% NON-CALL 3,000,000.00 3,206,160.00 1.214% 161,121.25 3,367,281.25 1,556 10/12/2016 FA FHLB 1.375% NON-CALL 1,800,000.00 1,808,975.18 1.244% 87,893.57 1,896,868.75 1,430 10/12/2016 FA FHLB 1.375% CALL 1/6/17 1,800,000.00 1,797,300.00 1.414% 101,287.50 1,898,587.50 1,455 7/22/2016 FA FNMA 1.65% NON-CALL 3,250,000.00 3,316,612.00 1.165% 166,507.79 3,483,119.79 1,589 6/14/2016 FA FFCB 1.54 % CALL 6/14/17 CONT 2,250,000.00 2,250,000.00 1.540% 155,925.00 2,405,925.00 1,644 6/21/2016 FA FFCB 1.55% CALL 9/21/16 CONT 2,000,000.00 2,000,000.00 1.550% 139,500.00 2,139,500.00 1,644 4/26/2016 FA FFCB 1.60% CALL 7/19/16 CONT 3,250,000.00 3,247,010.00 1.620% 248,978.89 3,495,988.89 1,729 7/19/2016 FA FHLB 1.40% CALL 10/19/16 CONT 3,500,000.00 3,500,000.00 1.400% 220,500.00 3,720,500.00 1,645 9/9/2016 FA FAMCA 1.550% NON-CALL 2,000,000.00 2,018,640.00 1.550% 117,071.11 2,135,711.11 1,599 10/12/2016 FA TENN VALLEY AUTHORITY 3.875% NON-CALL 3,000,000.00 3,315,660.00 1.370% 189,058.75 3,504,718.75 1,587 2/26/2016 FA FHLMC 1.25% QRTL Y CALL STEP 1,000,000.00 999,500.00 2.103% 106,750.00 1,106,250.00 1,827 2/26/2016 FA FHLB 1.69% CALL 8/26/16 CONT 480,000.00 480,000.00 1.690% 74,495.20 554,495.20 1,827 3/10/2016 FA FNMA 1.00% CALL 3/10/17 ONE TIME STEP 2,500,000.00 2,498,750.00 1.724% 216,250.00 2,715,000.00 1,826 3/22/2016 FA FHLB 1.25% QRTL Y CALL 6/22/16 STEP 2,500,000.00 2,498,750.00 1.870% 235,625.00 2,734,375.00 1,826 4/28/2016 FA FHLMC 1.25% QRTL Y CALL 10/28/16 STEP 2,500,000.00 2,496,250.00 2.122% 269,375.00 2,765,625.00 1,826 5/25/2016 FA FFCB 1.66% CALL 5/25/17 CONT 4,000,000.00 3,997,600.00 1.673% 334,400.00 4,332,000.00 1,826 10/12/2016 FA FHLB 2.25% NON-CALL 1,500,000.00 1,559,427.00 1.370% 97,979.25 1,657,406.25 1,703 10/26/2016 FA FHLB 1.125% NON-CALL 2,500,000.00 2,476,850.00 1.328% 155,806.25 2,632,656.25 1,722 2/16/2017 FA FHLMC 1.875% NON-CALL 1,400,000.00 1,392,580.00 2.000% 124,086.67 1,516,666.67 1,621 11/17/2016 FA FNMA1 .00% CALLI 1/28/17 QRTLY CALL STEP 2,600,000.00 2,596,100.00 2.079% 256,027.78 2,852,127.78 1,714 2/16/2017 FA FHLB 2.0% CALL 2/16/18 ONE TIME 1,325,000.00 1,325,000.00 2.000% 119,250.00 1,444,250.00 1,642 10/28/2016 FA FNMA 1.375% NON-CALL 2,500,000.00 2,491,075.00 1.450% 178,794.79 2,669,869.79 1,805 2/21/2017 FA FFCB 2.14% CALL 4/18/17 CONT 1,250,000.00 1,250,000.00 2.140% 124,610.42 1,374,610.42 1,700 2/24/2017 FA FHLB 1.125% CALL 11/22/17 STEP 1,500,000.00 1,500,000.00 2.170% 155,062.50 1,655,062.50 1,732 11/29/2016 FA FFCB 1.76% NON-CALL 3,000,000.00 3,000,000.00 1.760% 264,000.00 3,264,000.00 1,826 1/26/2017 FA FHLMC 2.0% QRTL Y CALL STEP 2,000,000.00 2,000,000.00 2.360% 237,500.00 2,237,500.00 1,826 2/23/2017 FA FAM CA 2.1 % NON-CALL 2,600,000.00 2,609,204.00 2.025% 263,796.00 2,873,000.00 1,826 2/28/2017 FA FHLB 1.25% ONE TIME CALL STEP 2,600,000.00 2,600,000.00 2.239% 292,500.00 2,892,500.00 1,826 SUB-TOTAL 298,891,000.00 300,406,154.99 1.276% 15,259,736.02 315,665,891.01 1,387 1/23/2015 FN FNMA 0% NON-CALL 1,163,000.00 1,086,447.85 1.700% 76,552.15 1,163,000.00 1,470 1/21/2015 FN FICO 0% NON-CALL 4,000,000.00 3,772,000.00 1.400% 228,000.00 4,000,000.00 1,535 4/1/2015 FN FICO 0% NON-CALL 2,100,000.00 1,958,591.39 1.560% 141,408.61 2,100,000.00 1,639 9/23/2015 FN FICO 0% NON-CALL 3,200,000.00 3,003,168.00 1.590% 196,832.00 3,200,000.00 1,464 3/3/2015 FN FNMA 0% NON-CALL 2,000,000.00 1,825,044.00 2.000% 174,956.00 2,000,000.00 1,681 11/7/2016 FN FNMA 0% NON-CALL 2,200,000.00 2,115,792.80 1.340% 84,207.20 2,200,000.00 1,066 1/27/2017 FN FNMA 0% NON-CALL 1,000,000.00 950,223.00 1.900% 49,777.00 1,000,000.00 985 10/23/2015 FN RFCSP 0% NON-CALL 3,000,000.00 2,750,760.00 1.750% 249,240.00 3,000,000.00 1,819 Item #1 March 28, 2017 Page 13 of 21 INVESTMENT REPORT AS OF FEBRUARY 28, 2017 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN (Days) SUB-TOTAL 18,663,000.00 17,462,027.04 1.6071% 1,200,972.96 18,663,000.00 3,005 Federal Investments Total 317,554,000.00 317,868,182.03 16,460,708.98 . 334,328,891.01 2,196 4/25/2014 TR US TREASURY 1.0% 3,000,000.00 3,010,827.00 0.870% 77,123.82 3,087,950.82 1,071 9/18/2015 TR US TREASURY 1.875% 2,500,000.00 2,551,660.00 0.805% 39,772.01 2,591,432.01 713 12/2/2016 TR US TREASURY 1.875% 2,750,000.00 2,776,034.25 0.830% 20,970.24 2,797,004.49 333 9/19/2014 TR US TREASURY 0.875% 3,000,000.00 2,996,484.38 0.920% 72,136.54 3,068,620.92 954 7/21/2015 TR US TREASURY .50% 2,000,000.00 1,995,000.00 0.642% 22,771.74 2,017,771.74 649 9/19/2014 TR US TREASURY 0.625% 1,000,000.00 991,015.63 0.963% 25,838.88 1,016,854.51 985 11/22/2013 TR US TREASURY .50% 2,000,000.00 1,974,619.96 0.850% 62,282.21 2,036,902.17 1,347 5/22/2015 TR US TREASURY .50% 1,000,000.00 996,900.00 0.643% 14,066.85 1,010,966.85 801 7/21/2015 TR US TREASURY .625% 2,000,000.00 1,994,352.00 0.760% 32,040.66 2,026,392.66 772 1/29/2016 TR US TREASURY 1.00% 2,800,000.00 2,809,078.13 0.800% 36,460.33 2,845,538.46 595 7/21/2015 TR US TREASURY .625% 1,500,000.00 1,494,787.50 0.785% 25,781.15 1,520,568.65 802 3/5/2015 TR US TREASURY .75% 2,000,000.00 1,989,531.25 0.950% 50,289.19 2,039,820.44 971 10/27/2015 TR US TREASURY .75% 2,500,000.00 2,506,045.00 0.629% 31,658.80 2,537,703.80 735 7/21/2015 TR US TREASURY .75% 1,700,000.00 1,691,765.61 0.932% 42,582.75 1,734,348.36 984 12/16/2016 TR US TREASURY 2.875% 2,000,000.00 2,045,792.00 1.080% 28,294.54 2,074,086.54 470 10/26/2016 TR US TREASURY .75% 2,400,000.00 2,400,000.00 0.750% 27,244.57 2,427,244.57 551 10/7/2014 TR US TREASURY 1.375% 1,400,000.00 1,400,251.69 1.370% 73,191.24 1,473,442.93 1,393 7/16/2014 TR US TREASURY 1.50% 4,000,000.00 4,009,600.00 1.496% 237,900.00 4,247,500.00 1,507 7/24/2014 TR US TREASURY 1.50% 2,000,000.00 2,006,348.00 1.420% 116,749.83 2,123,097.83 1,499 10/7/2014 TR US TREASURY 1.50% 1,500,000.00 1,505,664.36 1.400% 82,035.92 1,587,700.28 1,424 8/5/2014 TR US TREASURY 1.25% 3,000,000.00 2,974,200.00 1.460% 184,665.49 3,158,865.49 1,548 12/29/2015 TR US TREASURY 1.25% 2,000,000.00 1,998,878.00 1.270% 72,069.80 2,070,947.80 1,037 4/15/2016 TR US TREASURY 1.25% 1,500,000.00 1,515,292.97 0.850% 33,127.36 1,548,420.33 944 10/3/2014 TR US TREASURY 1.50% 1,000,000.00 1,000,000.00 1.500% 63,627.72 1,063,627.72 1,550 6/5/2015 TR US TREASURY 1.50% 2,000,000.00 2,015,296.00 1.285% 94,344.88 2,109,640.88 1,336 1/27/2017 TR US TREASURY 1.375% 1,000,000.00 1,003,590.00 1.200% 25,125.47 1,028,715.47 762 10/6/2015 TR US TREASURY 1.625% 4,000,000.00 4,083,992.00 1.010% 142,442.43 4,226,434.43 1,272 1/27/2017 TR US TREASURY 1.50% 1,000,000.00 1,005,980.00 1.220% 26,616.15 1,032,596.15 793 12/19/2016 TR US TREASURY 1.25% 800,000.00 798,640.00 1.323% 25,006.41 823,646.41 862 7/21/2015 TR US TREASURY 1.5% 1,500,000.00 1,505, 156.25 1.408% 81,708.50 1,586,864.75 1,410 2/21/2017 TR US TREASURY 1.5% 800,000.00 803,875.00 1.283% 23,388.74 827,263.74 829 8/1/2014 TR US TREASURY 1.625% 2,515,000.00 2,500,019.15 1.750% 219,213.54 2,719,232.69 1,825 10/6/2014 TR US TREASURY 1.00% 1,000,000.00 964,920.00 1.036% 84,085.52 1,049,005.52 1,790 1/10/2017 TR US TREASURY 1.625% 1,250,000.00 1,258,593.75 1.358% 44,936.98 1,303,530.73 963 12/22/2016 TR US TREASURY 1.375% 2,200,000.00 2, 184,531.25 1.602% 111,901.07 2,296,432.32 1,164 1/10/2017 TR US TREASURY 1.375% 1 ,400, 000. 00 1,395,520.00 1.480% 64,835.66 1,460,355.66 1,145 5/24/2016 TR US TREASURY 1.375% 2,300,000.00 2,315,093.75 1.204% 109,343.75 2,424,437.50 1,437 12/19/2016 TR US TREASURY 1.625% 1,350,000.00 1,345,570.31 1.721% 81,926.29 1,427,496.60 1,289 Item #1 March 28, 2017 Page 14 of 21 INVESTMENT REPORT AS OF FEBRUARY 28, 2017 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN (Days) 12/2/2016 TR US TREASURY 1.625% 1,500,000.00 1,500,000.00 1.625% 89,286.68 1,589,286.68 1,337 9/22/2015 TR US TREASURY 2.125% 3,000,000.00 3,085,500.00 2.097% 229,396.98 3,314,896.98 1,805 10/28/2016 TR US TREASURY 1.375% 1,750,000.00 1,759,570.31 1.235% 86,875.85 1,846,446.16 1,464 12/2/2016 TR US TREASURY 1.375% 1,200,000.00 1,186,200.00 1.680% 78,341.44 1,264,541.44 1,429 1/13/2017 TR US TREASURY 1.375% 1,300,000.00 1,289,234.38 1.601% 78,611.61 1,367,845.99 1,387 1/5/2016 TR US TREASURY 2.375% 4,000,000.00 4,127,500.00 1.705% 346,195.00 4,473,695.00 1,822 5/5/2016 TR US TREASURY 1.75% 2,000,000.00 2,049,174.00 1.205% 113,710.62 2,162,884.62 1,701 1/20/2017 TR US TREASURY 1.125% 2,750,000.00 2,673,515.63 1.831% 203,567.42 2,877,083.05 1,500 2/17/2017 TR US TREASURY 1.125% 1,225,000.00 1,194,853.52 1.760% 85,690.25 1,280,543.77 1,472 8/19/2016 TR US TREASURY 1.375% 3,000,000.00 3,037,662.00 1.100% 156,145.74 3,193,807.74 1,715 12/16/2016 TR US TREASURY 2.000% 2,250,000.00 2,250,000.00 2.000% 200,521.98 2,450,521.98 1,627 10/28/2016 TR US TREASURY 1.125% 2,500,000.00 2,477,400.00 1.325% 154,053.80 2,631,453.80 1,706 12/16/2016 TR US TREASURY 1.125% 2,650,000.00 2,547,312.50 2.022% 238,058.93 2,785,371.43 1,657 1/20/2017 TR US TREASURY 1.125% 1,500,000.00 1,448,203.13 1.925% 145,113.79 1,593,316.92 1,653 12/2/2016 TR US TREASURY 2.125% 1,600,000.00 1,615,500.00 1.913% 148,615.38 1,764,115.38 1,763 11/17/2016 TR US TREASURY 2.00% 2,000,000.00 2,030,000.00 1.683% 168,121.55 2,198,121.55 1,809 11/18/2016 TR US TREASURY 2.00% 2,000,000.00 2,028,360.00 1.700% 169,651.15 2,198,011.15 1,808 11/22/2016 TR US TREASURY 2.00% 2,000,000.00 2,016,562.50 1.825% 182,664.02 2,199,226.52 1,819 1/6/2017 TR US TREASURY 2.125% 4,000,000.00 4,052,128.00 1.850% 371,463.16 4,423,591.16 1,820 2/3/2017 TR US TREASURY 2.125% 1,850,000.00 1,867,632.81 1.920% 175,237.36 2,042,870.17 1,792 1/20/2017 TR US TREASURY 1.50% 3,000,000.00 2,928,555.00 2.000% 297,790.11 3,226,345.11 1,837 SUB-TOTAL 120,740,000.00 120,979,768.97 1.349% 6,326,669.85 127,306,438.82 1,279 4/18/2012 CN WAL-MART STORES 5.375% NON-CALL 3,000,000.00 3,568,354.19 1.400% 229,833.31 3,798,187.50 1,813 4/9/2015 CN NY LIFE GOLBAL 1.65% NON-CALL 1,675,000.00 1,704,362.75 0.806% 28,676.00 1,733,038.75 767 6/5/2012 CN HSBC BANK USA 1.925% FLOATER 5,000,000.00 5,000,000.00 1.037% 342,500.00 5,342,500.00 1,826 9/29/2016 CN ROYAL BANK OF CANADA 1.20% NON-CALL 1,275,000.00 1,276,597.58 1.070% 13,277.42 1,289,875.00 355 6/12/2014 CN CHEVRON CORP 1.104% NON CALL 2,000,000.00 1,996,180.00 1.160% 80,670.67 2,076,850.67 1,272 3/8/2013 CN WAL-MART 5.8% NON CALL 3,000,000.00 3,669,120.00 1.140% 189,763.33 3,858,883.33 1,805 5/27/2015 CN WAL-MART 5.8% NON CALL 2,000,000.00 2,249,440.00 1.125% 65,693.33 2,315,133.33 995 3/26/2013 CN COCA COLA CA 1.150% MAKE-WHOLE CALL 1,000,000.00 1,000,000.00 1.150% 57,627.78 1,057,627.78 1,832 10/29/2015 CN WAL-MART STORES 1.125% MAKE WHOLE 4,000,000.00 4,024,400.00 0.873% 85,850.00 4,110,250.00 895 9/18/2014 CN COLGATE-PALMOLIVE .90% MAKE WHOLE CALL 1,000,000.00 980,600.00 1.452% 51,975.00 1,032,575.00 1,321 1/27/2015 CN COLGATE-PALMOLIVE .90% MAKE WHOLE CALL 2,000,000.00 1,983,000.00 1.166% 75,700.00 2,058,700.00 1,190 2/25/2016 CN COLGATE-PALMOLIVE .90% MAKE WHOLE CALL 2,500,000.00 2,495,450.00 0.984% 53,675.00 2,549,125.00 796 5/11/2015 CN APPLE 1.0% MAKE WHOLE CALL 2,000,000.00 1,989,840.00 1.174% 69,715.56 2,059,555.56 1,088 5/15/2013 CN BERKSHIRE HATAWAY 1.30% MAKE WHOLE CALL 5,000,000.00 5,019,345.05 1.220% 305,654.95 5,325,000.00 1,826 12/24/2015 CN CHEVRON CORP 1.718% MAKE WHOLE CALL 2,250,000.00 2,253,600.00 1.650% 93,037.50 2,346,637.50 913 12/31/2015 CN CHEVRON CORP 1.718% MAKE WHOLE CALL 1,000,000.00 996,300.00 1.871% 46,315.94 1,042,615.94 906 1/28/2016 CN TOYOTA 1.55% NON-CALL 2,000,000.00 2,014,400.00 1.252% 61,808.33 2,076,208.33 897 12/19/2014 CN MASS MUTUAL GLOBAL 2.10% NON-CALL 3,500,000.00 3,555,685.00 1.645% 210,344.17 3,766,029.17 1,322 2/19/2015 CN ROYAL BANK OF CANADA 2.00% NON-CALL 2,250,000.00 2,289,442.50 1.500% 123,307.50 2,412,750.00 1,320 Item #1 March 28, 2017 Page 15 of 21 INVESTMENT REPORT AS OF FEBRUARY 28, 2017 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN (Days) 7/12/2016 CN IBM CORP 7.625% MAKE WHOLE CALL 2,628,000.00 3,005,118.00 1.167% 75,418.12 3,080,536.12 825 4/19/2016 CN NY LIFE 1.55% NON-CALL 2,000,000.00 2,014,620.00 1.256% 63,999.45 2,078,619.45 927 12/24/2013 CN COCA COLA CA 1.650% MAKE-WHOLE CALL 3,500,000.00 3,491,856.17 1.700% 288,391.75 3,780,247.92 1,782 10/28/2015 CN JOHNSON & JOHNSON 1.65% MAKE WHOLE 4,000,000.00 4,070,600.00 1.070% 134,183.33 4,204,783.33 1,134 4/9/2015 CN MICROSOFT 1.625% NON-CALL 2,000,000.00 2,037,820.00 1.096% 81,075.83 2,118,895.83 1,337 4/6/2015 CN PEFCO 4.375% NON-CALL 2,274,000.00 2,527,892.10 1.450% 138,254.46 2,666,146.56 1,439 12/22/2015 CN EXXON MOBIL 1.819% NON-CALL 1,250,000.00 1,259,125.00 1.580% 64,329.76 1,323,454.76 1,179 6/30/2015 CN MASS MUTUAL GLOBAL 2.35% NON-CALL 3,250,000.00 3,286,335.00 2.040% 251,980.62 3,538,315.62 1,379 10/8/2015 CN APPLE 2.10% MAKE WHOLE CALL 2,500,000.00 2,558,025.00 1.432% 129,808.33 2,687,833.33 1,306 5/27/2015 CN IBM CORP 1.8750% NON-CALL 2,150,000.00 2,169,715.50 1.635% 140,190.75 2,309,906.25 1,449 7/16/2015 CN TOYOTA 2.125% NON-CALL 2,000,000.00 2,009,760.00 1.998% 160,476.11 2,170,236.11 1,463 4/28/2016 CN PEFCO 1.45% NON-CALL 2,600,000.00 2,617,570.80 1.240% 106,734.48 2,724,305.28 1,204 11/18/2014 CN CHEVRON CORP 2.193% MAKE-WHOLE CALL 3,000,000.00 3,017,400.00 2.070% 311,001.75 3,328,401.75 1,823 12/22/2015 CN CHEVRON CORP 2.193% MAKE-WHOLE CALL 2,800,000.00 2,811,200.00 2.083% 228,105.03 3,039,305.03 1,424 4/20/2016 CN JOHNSON & JOHNSON 1.875% MAKE WHOLE CALL 2,250,000.00 2,315,250.00 1.057% 87,679.69 2,402,929.69 1,324 4/9/2015 CN NY LIFE GOLBAL 1.95% NON-CALL 2,000,000.00 2,017,520.00 1.760% 171,196.67 2,188,716.67 1,769 1/20/2017 CN NY LIFE GOLBAL 1.95% NON-CALL 2,000,000.00 2,000,000.00 1.950% 119,275.00 2,119,275.00 1,117 9/25/2015 CN CVX 1.961 % MAKE WHOLE CALL 2,800,000.00 2,790,704.00 2.039% 253,026.51 3,043,730.51 1,621 11/4/2015 CN EXXON MOBIL 1.912% MAKE WHOLE CALL 5,000,000.00 5,057,700.00 1.630% 357,097.78 5,414,797.78 1,584 5/23/2016 CN PEFCO 2.25% NON-CALL 3,000,000.00 3,099,000.00 1.358% 158,250.00 3,257,250.00 1,392 11/3/2015 CN APPLE 2.0% MAKE WHOLE CALL 4,000,000.00 4,028,000.00 1.837% 332,666.66 4,360,666.66 1,646 5/24/2016 CN IBM 1.625% MAKE-WHOLE CALL 1,500,000.00 1,503,000.00 1.573% 93,890.62 1,596,890.62 1,452 11/3/2015 CN MMM 2.0% MAKE WHOLE CALL 3,500,000.00 3,554,215.00 1.660% 279,062.78 3,833,277.78 1,739 9/25/2015 CN JOHNSON & JOHNSON 2.95% MAKE WHOLE 1,000,000.00 1,058,028.49 1.718% 87,504.84 1,145,533.33 1,803 9/24/2015 CN AUTOMATIC DATA PROCESSING 2.25% MAKE-WHOLI 4,000,000.00 4,029,600.00 2.090% 418,150.00 4,447,750.00 1,818 11/10/2015 CN MICROSOFT 2.00% MAKE WHOLE CALL 5,000,000.00 5,018,550.00 1.920% 479,505.56 5,498,055.56 1,820 6/10/2016 CN MICROSOFT 2.00% MAKE WHOLE CALL 1,500,000.00 1,539,450.00 1.370% 92,466.67 1,631,916.67 1,607 4/28/2016 CN EXXON MOBIL 2.222% MAKE WHOLE CALL 2,000,000.00 2,042,900.00 1.750% 172,263.67 2,215,163.67 1,768 7/26/2016 CN EXXON MOBIL 2.222% MAKE WHOLE CALL 1,000,000.00 1,034,050.00 1.440% 68,038.55 1,102,088.55 1,679 9/16/2016 CN TOYOTA 1.90% MAKE WHOLE CALL 3,000,000.00 3,031,680.00 1.659% 228,303.33 3,259,983.33 1,665 5/26/2016 CN ALPHABET, INC 3.625% MAKE WHOLE CALL 1,000,000.00 1,094,000.00 1.651% 86,545.14 1,180,545.14 1,819 9/13/2016 CN MIRCOSOFT 1.55% MAKE WHOLE CALL 6,000,000.00 5,995,740.00 1.565% 460,218.33 6,455,958.33 1,790 2/7/2017 CN MIRCOSOFT 1.55% MAKE WHOLE CALL 2,000,000.00 1,947,120.00 2.170% 192,466.11 2,139,586.11 1,643 10/14/2016 CN COCA COLA 1.55% MAKE WHOLE CALL 3,600,000.00 3,581,496.00 1.660% 290,839.00 3,872,335.00 1,783 11/7/2016 CN IBM 2.90% MAKE WHOLE CALL 1,000,000.00 1,052,600.00 1.792% 91,916.67 1,144,516.67 1,820 SUB-TOTAL 139,552,000.00 142,733,758.13 1.508% 8,879,739.14 151,613,497.27 1,416 12/24/2012 CD DEL TA NATL BANK & TRUST .90% 249,000.00 248,377.50 0.952% 11,624.88 260,002.38 1,792 12/24/2012 CD PACIFIC CONTL BANK .90% 249,000.00 248,452.20 0.946% 11,556.33 260,008.53 1,793 12/11/2012 CD BANCO POPULAR DE PR HATO 1.1% 248,000.00 248,000.00 1.100% 13,595.16 261,595.16 1,820 12/11/2014 CD ALLY BANK 1.55% 247,000.00 247,000.00 1.550% 11,485.50 258,485.50 1,096 12/14/2014 CD FIRST BANK OF PUERTO RICO 1.25% 249,000.00 249,000.00 1.250% 15,562.50 264,562.50 1,096 Item #1 March 28, 2017 Page 16 of 21 INVESTMENT REPORT AS OF FEBRUARY 28, 2017 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN (Days) 12/14/2012 CD BANKERS BANK KANSAS 1.0% 249,000.00 248,502.00 1.000% 12,948.00 261,450.00 1,826 1/16/2013 CD THE BANK OF HOLLAND 1.00% 249,000.00 248,751.00 1.000% 12,699.00 261,450.00 1,826 1/16/2013 CD BANK OF NORTHERN MICHIGAN 1.00% 249,000.00 248,751.00 1.000% 12,699.00 261,450.00 1,826 1/18/2013 CD STEARNS BANK .90% 249,000.00 248,253.00 1.000% 11,952.00 260,205.00 1,826 1/18/2017 CD MB FINANCIAL BANK 2.050% 249,000.00 249,000.00 2.050% 25,522.50 274,522.50 1,826 1/20/2017 CD FIRST NATL BANK O AMERICA 2.05% 249,000.00 249,000.00 2.050% 25,522.50 274,522.50 1,826 3/4/2013 CD GATEWAY BANK OF SW FLORIDA .95% 209,000.00 208,373.00 1.070% 10,367.28 218,740.28 1,792 1/29/2016 CD CUSTOMERS BANK 1.20% 248,000.00 248,000.00 1.200% 5,960.27 253,960.27 731 1/30/2013 CD FARMERS & MERCHANTS BANK .90% 249,000.00 248,253.00 0.900% 11,952.00 260,205.00 1,826 2/10/2016 CD ORIENTAL BANK SAN JAUN PR 1.2% NON-CALL 248,000.00 248,000.00 1.200% 5,943.73 253,943.73 730 2/10/2016 CD CADENCE BANK 1.25% NON-CALL 248,000.00 248,000.00 1.250% 6,217.22 254,217.22 733 3/28/2013 CD WASHINGTON FEDERAL SAVINGS 1.0% CALL 249,000.00 248,253.00 1.000% 13,197.00 261,450.00 1,826 4/5/2013 CD BOSTON PRIVATE BANK & TRUST .95% CALL 248,000.00 247,008.00 1.032% 12,765.55 259,773.55 1,825 4/18/2013 CD FIRST STATE BANK NE .95% CALL 249,000.00 248,502.00 0.991% 12,325.50 260,827.50 1,826 4/30/2013 CD FOREST COMMERCIAL BANK .90% CALL 249,000.00 248,253.00 0.960% 11,952.00 260,205.00 1,826 5/29/2015 CD COMPASS BANK BIRMINGHAM NON-CALL 248,000.00 248,000.00 1.300% 9,672.00 257,672.00 1,096 6/4/2015 CD MEDALLION BANK SALT LAKE 1.25 % NON-CALL 249,000.00 249,000.00 1.250% 9,337.50 258,337.50 1,096 6/15/2016 CD AMERICA'S CREDIT UNION 1.10% 248,000.00 248,000.00 1.100% 5,456.00 253,456.00 730 8/25/2016 CD BMO HARRIS BANK 1.10% 248,000.00 248,000.00 1.100% 5,456.00 253,456.00 729 1/20/2016 CD KEY BANK NATL ASSN OHIO 1.55% 247,000.00 247,000.00 1.550% 11,528.04 258,528.04 1,098 7/15/2015 CD CAPTIAL ONE 1.95% NON-CALL 249,000.00 249,000.00 1.950% 19,422.00 268,422.00 1,461 7/24/2014 CD AMERICAN EXPRESS BANK 2.00% 247,000.00 247,000.00 2.000% 24,700.00 271,700.00 1,826 8/28/2014 CD ENERBANK USA 2.05% 247,000.00 247,000.00 2.050% 25,317.50 272,317.50 1,826 8/29/2014 CD SYNCHRONY BANK 2.1 % 247,000.00 247,000.00 2.100% 25,935.00 272,935.00 1,826 8/30/2016 CD WASHINGTON TRUST 1.2% 248,000.00 248,000.00 1.200% 8,928.00 256,928.00 1,095 9/16/2016 CD ISRAEL DISCOUNT BK OF NY 1.3% 248,000.00 248,000.00 1.300% 9,689.91 257,689.91 1,095 9/24/2014 CD DISCOVER 2.15% 247,000.00 247,000.00 2.150% 26,552.50 273,552.50 1,826 9/24/2014 CD GOLDMAN SACHS BANK 2.15% 247,000.00 247,000.00 2.150% 26,552.50 273,552.50 1,826 10/8/2014 CD CAPITAL ONE ABANK USA 2.10% 247,000.00 247,000.00 2.100% 25,935.00 272,935.00 1,826 10/10/2014 CD GE CAPITAL BANK 2.0% 247,000.00 245,641.50 2.000% 26,058.50 271,700.00 1,826 10/29/2014 CD PEOPLES UTD BANK CT 1.9% 247,000.00 247,000.00 1.900% 23,465.00 270,465.00 1,826 11/3/2014 CD WEBSTER BANK NATL ASSOC 1.9% 247,000.00 247,000.00 1.900% 23,465.00 270,465.00 1,827 12/3/2014 CD CIT BANK SALT LAKE CITY 2.2% 247,000.00 247,000.00 2.200% 27,170.00 274,170.00 1,826 12/4/2014 CD AMERICAN EXPRESS CENTURION 2.2% 247,000.00 247,000.00 2.200% 27,170.00 274,170.00 1,826 12/10/2014 CD BMW BANK OF N AMERICA 2.15% 247,000.00 247,000.00 2.150% 26,552.50 273,552.50 1,826 12/23/2014 CD SALLIE MAE BANK SALT LAKE 2.2% 247,000.00 247,000.00 2.200% 26,976.46 273,976.46 1,813 1/23/2015 CD PRIVATE BANK & TRUST 1.90% 247,000.00 247,000.00 1.900% 23,465.00 270,465.00 1,826 7/24/2015 CD EAGLE BANK 1.80% 249,000.00 249,000.00 1.800% 20,169.00 269,169.00 1,645 1/27/2015 CD NORTHFIELD BANK 1.65% 249,000.00 249,000.00 1.650% 20,542.50 269,542.50 1,826 1/30/2015 CD BANK OF GEORGETOWN 1.65% 249,000.00 249,000.00 1.650% 20,542.50 269,542.50 1,826 2/6/2015 CD MACHIAS SAVINGS BANK 1.65% 247,000.00 247,000.00 1.650% 20,377.50 267,377.50 1,826 3/3/2015 CD THIRD FEDERAL SAVING & LOAN 1.75% 247,000.00 246,407.20 1.754% 22,146.09 268,553.29 1,821 3/25/2015 CD WELLS FARGO BANK SIOUX FALLS 1.5% 247,000.00 247,000.00 1.500% 18,525.00 265,525.00 1,827 4/22/2015 CD MARLIN BUSINESS BANK SALT LAKE 1.6% 247,000.00 247,000.00 1.600% 19,760.00 266,760.00 1,827 Item #1 March 28, 2017 Page 17 of 21 INVESTMENT REPORT AS OF FEBRUARY 28, 2017 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN {Days) 5/13/2015 CD WORLD FOREMOST BANK SYDNEY 2.00% 200,000.00 200,000.00 2.000% 20,000.00 220,000.00 1,827 6/29/2015 CD FIRST SOURCE BANK 1.85% 247,000.00 246,382.50 1.904% 23,465.00 269,847.50 1,827 7/31/2015 CD INSTITUTION FOR SAVINGS 2.05% 249,000.00 249,000.00 2.050% 25,522.50 274,522.50 1,827 8/6/2015 CD ORRSTOWN BANK 2.0% 249,000.00 249,000.00 2.000% 24,706.33 273,706.33 1,841 8/11/2015 CD INVESTOR BANK 2.0% 247,000.00 247,000.00 2.000% 24,700.00 271,700.00 1,841 9/10/2015 CD MERRICK BANK 1.85% 249,000.00 248,377.50 1.910% 23,655.00 272,032.50 1,827 9/22/2015 CD BARCLAYS BANK 2.2% 248,000.00 248,000.00 2.200% 27,190.31 275,190.31 1,821 10/19/2015 CD COMENITY CAP BANK 2.0% 249,000.00 249,000.00 2.000% 24,818.14 273,818.14 1,821 1/15/2016 CD INVESTORS CMNTY BANK 1.85% 249,000.00 249,000.00 1.850% 23,032.50 272,032.50 1,827 6/10/2016 CD . UBS BANK USA SALT LA KE CITY 1.65% 249,000.00 249,000.00 1.650% 20,508.73 269,508.73 1,823 6/23/2016 CD EAST BOSTON SAVING BANK 1.5% 248,000.00 248,000.00 1.500% 18,600.00 266,600.00 1,826 6/24/2016 CD FIRST BUSINESS BK MADISON 1.5% 248,000.00 248,000.00 1.500% 18,600.00 266,600.00 1,826 6/30/2016 CD FIRST TECHNOLOGY FEDERAL CR UNION 1.75% 248,000.00 248,000.00 1.750% 21,700.00 269,700.00 1,826 SUB-TOTAL 15,291,000.00 15,280,537.40 1.599% 1,133,213.43 16,413,750.83 1,645 0 WELLS FARGO BANK 890,034.00 890,034.00 0.020% 0.49 890,034.49 0 CORPORATE CASH MANAGEMENT ACCOUNT 2,611,064.32 2,611,064.32 0.020% 1.43 2,611,065.75 0 LI BRARY ACCOUNT 304.41 304.41 0.000% 304.41 0 UNION TRUST 12,159.43 12,159.43 0.000% 0.00 12,159.43 0 LA IF WATER DISTRICT 27,224,000.00 27,224,000.00 0.760% 574.73 27,224,574.73 0 LA IF PUBLIC IMPROVEMENT CORPORATION 22,692,000.00 22,692,000.00 0.760% 479.05 22,692,479.05 0 LA IF PUBLIC FINANCING CORPORATION 26,423,000.00 26,423,000.00 0.760% 557.82 26,423,557.82 0 LA I F CITY OF CARLSBAD 25,901,000.00 25,901,000.00 0.760% 546.80 25,901,546.80 SUB-TOTAL 105,753,562.16 105,753,562.16 0.735% 2,160.32 105,755,722.48 GRAND TOTAL 698,890,562.16 702,615,808.69 1.2696% 32,802,491.72 735,418,300.41 Item #1 March 28, 2017 Page 18 of 21 CITY OF CARLSBAD Fund Equity in Pooled Investments AS OF FEBRUARY 28, 2017 Cash Balance by Fund: General Special Revenue Capital Projects: General Capital Construction Traffic Impact Fees Public Facilities Fees Park Development Transnet Taxes Drainage Fees Special Districts Infrastructure Replacement Other Capital Construction Enterprise: Carlsbad Municipal Water District Sewer Fund Solid Waste Storm Water Golf Course Internal Service Agency Funds Trust Funds Total General ledger Balance** Reconciling Adjustments (1) Total Total Total Treasurer's Investment Portfolio at Amortized Cost 37,909,953 18,144,076 26,755,002 9,862,385 5,027,573 6,618,218 94,636,694 99,952,180 16,355,085 120,506,216 44,316,909 7,248,330 6,220,209 913,366 EXHIBIT 8 118,372,006 27,250,686 315,261,167 179,205,030 45,482,958 17,234,676 252,684 703,059,206 (2,382,594) 700,676,612 (1)The Reconciling Adjustments consist of differences between the General Ledger which is prepared on an accrual basis and the Treasurer's report which is prepared on the cash basis. Accrued Interest, amortized premium or discounts and outstanding checks and deposits in transit are not included in the Treasurer's summary. Differences between the time journal entries are posted and the time this report is produced may also be a component of the adjustment. ** Figures based on best estimate at the time report run on 3/06/17 Item #1 March 28, 2017 Page 19 of 21 EXHIBIT 9 CITY OF CARLSBAD INVESTMENT PORTFOLIO As of FEBRUARY 28, 2017 CORPORA TE NOTE AND COMMERCIAL PAPER RATINGS Corporate Note Investments Meeting the Current Investment Policy: (Ratings must be AA or better by two of the three: Moody's S&P or Fitch) Moody's S&P Fitch ADP AA3 AA NR ALPHABET, INC AA2 AA NR APPLE AA1 AA+ NR BERKSHIRE HATAWAY AA2 AA+ A+ CHEVRON AA2 AA-NR COCA COLA AA3 AA-A+ COLGATE-PALMOLIVE AA3 AA-AA- EXXON MOBIL AAA AA+ NR IBM CORP AA3 AA-A+ JOHNSON & JOHNSON AAA AAA AAA MASS MUTUAL GLOBAL AA2 AA+ AA+ MICROSOFT AAA AAA AA+ NEW YORK LIFE AAA AA+ AAA PRIVATE EXPORT FUNDING (PEFCO) AAA NR AAA ROYAL BANK OF CANADA AAA AAA AAA TOYOTA M3 AA-A WAL-MART AA2 AA AA Commercial Paper Investments Meeting the Current Investment Policy: (Ratings must be A1/P1 or better by two of the three: Moody's, S&P or Fitch) (Ratings of other debt must be AA or better by two of the three: Moody's, S&P or Fitch) NONE Investments with Subsequent Changes in Credit Rating * Moody's S&P HSBC BANK USA A1 AA+ 3M COMPANY A1 AA- Fitch NR NR Latest Maturity Date 06/05/2017 08/07/2020 * The City's Investment Policy allows the City Treasurer to determine the course of action that would correct exceptionsto the policy. All of these investments are paying interest at the required times. The principal of all investments are considered secure. It is the intent of the City Treasurer to hold these assets in the portfolio until maturity unless events indicate they should be sold. Carrying Value 5,000,000 3,539,096 Market Value 4,919,500 3,527,685 Item #1 March 28, 2017 Page 20 of 21 CITY OF CARLSBAD INVESTMENT PORTFOLIO AS OF FEBRUARY 28, 2017 WEIGHTINGS FOR CORPORATE AND FEDERAL AGENCY ISSUERS PERCENTAGE WEIGHTINGS BY CORPORATE NOTE ISSUER Investment Cost Percent of Portfolio* ADP 4,029,600.00 0.57% ALPHABET, INC 1,094,000.00 0.16% APPLE INC 8,575,865.00 1.22% BERKSHIRE HATHAWAY 5,019,345.05 0.71% CHEVRON 13,865,384.00 1.97% COCA COLA CO 8,073,352.17 1.15% COLGATE-PALMOLIVE 5,459,050.00 0.78% EXXON MOBIL 9,393,774.99 1.34% HSBC BANK USA 5,000,000.00 0.71% IBM CORP 7,730,433.50 1.10% JOHNSON & JOHNSON 7,443,878.49 1.06% MASS MUTUAL 6,842,020.01 0.97% MICROSOFT 16,538,680.00 2.35% 3M COMPANY 3,554,215.00 0.51% NEW YORK LIFE 7,736,502.75 1.10% PEFCO 8,244,462.90 1.17% ROYAL BANK OF CANADA 3,566,040.08 0.51% TOYOTA 7,055,840.00 1.00% WAL-MART 13,511,314.19 1.92% PERCENTAGE WEIGHTINGS BY FEDERAL AGENCY ISSUER FAMCA FICO FEDERAL FARM CREDIT BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN MORTGAGE CORP FEDERAL NATIONAL MORTGAGE ASSOC RFCO STRIP PRINCIPAL TENNESSEE VALLEY AUTHORITY U.S.TREASURY Investment Cost Percent of Portfolio** 19,231,314.00 8,733,759.39 60,418,480.43 85,599,646.04 49,644,893.00 87,622,444.18 2,750,760.00 3,866,885.00 120,979,768.97 2.74% 1.24% 8.60% 12.18% 7.07% 12.47% 0.39% 0.55% 17.22% EXHIBIT 10 Total Portfolio $702,615,808.70 *No more than 5% may be invested with a single corporate issuer. **There are no percentage limits on federal agency issuers.Item #1 March 28, 2017 Page 21 of 21