Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2016-02-09; City Council; 22212; Report on City Investments as of December 31, 2015
Report on City Investments as of December 31, 2015 Meeting Date: February 9, 2016 Page3 FISCAL IMPACT: None ENVIRONMENTAL IMPACT: 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. EXHIBITS FOR POOLED INVESTMENTS: 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. Second 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 EXHIBIT FOR INVESTMENTS OF BOND PROCEEDS HELD SEPARATELY: 11. Detailed Investment Report-Quarterly Report EXHIBIT FOR SUMMARY OF OUTSTANDING HOUSING LOANS: 12. Detail Of Outstanding Housing Loans-Quarterly Report CITY OF CARLSBAD INVESTMENT PORTFOLIO AS OF DECEMBER 31,2015 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,040,551 15,289,216 14,973,569 15,301,089 137,587 1.50 1.50 FN 18,035,190 14,522,985· 17,854,888 14,405,953 0 1.41 1.63 TR 58,272,637 56,278,697 58,176,794 56,303,329 184,430 1.10 1.09 FA 325,089,647 315,470,268 324,160,746 315,117,363 2,124,064 1.19 1.17 CN 175,147,310 172,900,619 174,487,106 172,682,763 1,591 '119 1.60 1.61 LAIF 102,990,209 105,882,209 102,990,209 105,882,209 176,161 0.38 0.37 CUSTODY 8,819 84,247 8,819 84,247 43 0.00 0.00 SWEEP 4,168,869 1,864,287 4,168,869 1,864,287 203 0.02 0.02 BANKACCT 316,748 390,875 316,748 390,875 0 0.02 0.02 TOTALS $699,069,979 $682,683,403 $697,137,749 $682,032,115 4,213,606 1.17% 1.16% CD-Certificate ofDeposit 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 !:>:1 X :±: H tJj H 8 1-' ~ CLASS CD FN TR FA CN LAIF CUSTODY SWEEP BANKACCT TOTALS %TOTALS CITY OF CARLSBAD INVESTMENT PORTFOLIO AS OF DECEMBER 31, 2015 BREAKDOWN OF MATURITIES BY CLASSIFICATION AND LENGTH OF TIME WITHIN 6 MONTHS 7 MONTHS TO 1 YEAR 1 T05YEARS TOTAL 1,985,648 247,008 12,797,174 15,029,831 3,490,976 0 14,396,011 17,886,987 0 5,016,734 53,242,814 58,259,548 12,284,028 34,026,757 279,058,458 325,369,242 31,711,216 22,885,597 122,617,850 177,214,662 102,990,209 0 0 102,990,209 8,819 0 0 8,819 4,168,869 0 0 4,168,869 316,748 0 0 316,748 $156,956,513 (1) $62,176,095 (1) $482,112,307 $701,244,915 22.4% 8.9% 68.8% 100.0% Total within One Year $219,132,608 (1) POLICY: 31.3% (1) Not less than $160,258,000 to mature within one year. (2/3rds of current year operating budget of $240,385,000.00) (2) Policy states that not more than 30% of portfolio is to be invested in corporate notes. %TOTAL 2.1% 2.6% 8.3% 46.4% 25.3% (2) 14.7% 0.0% 0.6% 0.1% 100.0% t:rJ :><: ::r:: H trJ H 1-'3 N ·~ 6.75 6.50 6.25 6.00 5.75 5.50 5.25 5.00 4.75 4.50 4.25 4.00 3.75 3.50 3.25 3.00 2.75 2.50 2.25 2.00 1.75 1.50 1.25 1.00 0.75 0.50 ~VIII;V ~~ ~ ~ YIELD COMPARISON ~ ' \ ., -~ ' _:\.. '\. ~ \ 1 \.. PORTFOLIO EX-LAIF VS. LAIF JULY 2000-DECEMBER 2015 """""""' ~' -~' '#' 1 l ~ f' ~""'"~ 'j ..... ~ ~ .--w' lr 1 ''\ ''\ _;. t \ b. 'if' ~ ~ -~. '~ ~-_:\. -~. t ~ ~ '\i( J -....~ ~ I ~. ''--+-t:.X-L _AD-'E "\ ' ·~ 'Jif ~ '-~· 411= •:;or:--I '""-. \. "" --~ ~ .... ""'" 0.25 I -~-----~--.. t:tj o.ooiliilllllllllllllliiililiilllllllllillllllllllliiiillllllllllllllllllllllillllllliilllfllllilllllllliilllllllllllllllllilllllllllliilllllllllllliilllllllillllllllliiilllllillilllllllill :x:: ~~ ::r: ~~~~~~~~~~~~~~~~~~~~~~~~~~ § f-3 w TRANSACTIONS FOR PERIOD: 10/01/15 TO 12/31/15 2nd QUARTER 2015-2016 Trans Investment Call Par Amount Return Investment Date Date ~ Security Date Value Cou);!on !Cost) Rate Interest Return BOYS . OCTOBER 10/02/15 10/05115 FA FHLMC N/A 3,500,000.00 1.400% 3,519,495.00 1.264% 188,299.44 3,707,794.44 10/05/15 10/06/15 FA FNMA N/A 4,183,000.00 1.330% 4,197,807.82 1.240% 210,509.47 4,408,317.29 10/05/15 10/06/15 TR US TREASURY N/A 4,000,000.00 1.625% 4,083,992.00 1.010% 142,442.43 4,226,434.43 10/05/15 10/08/15 CN APPLE, INC N/A 2,500,000.00 2.100% 2,558,025.00 1.432% 129,808.33 2,687,833.33 10/08/15 10/09/15 FA FHLB N/A 2,000,000.00 0.750% 2,004,800.00 0.622% 23,491.67 2,028,291.67 10/05/15 10/15/15 FA FFCB 1/15/2016 3,000,000.00 1.440% 3,000,000.00 1.440% 172,800.00 3,172,800.00 1 0/16/15 10/19/15 FA FFCB 1/13/2016 3,000,000.00 1.030% 3,000,000.00 1.030% 84,460.00 3,084,460.00 1 0/06/15 10/19/15 CD COMENITY CAP BANK N/A 249,000.00 2.000% 249,000.00 2.000% 24,818.14 273,818.14 10/20/15 10/20/15 FA FFCB 1/20/2016 5,000,000.00 1.625% 5,000,000.00 1.625% 365,625.00 5,365,625.00 10/23/15 10/23/15 FN RFCSP N/A 3,000,000.00 0.000% 2,750,760.00 1.750% 249,240.00 3,000,000.00 10/27/15 10/27/15 FA FNMA 10/27/2016 5,000,000.00 1.470% 5,000,000.00 1.470% 367,500.00 5,367,500.00 10/27/15 10/27/15 TR US TREASURY N/A 2,500,000.00 0.750% 2,506,045.00 0.629% 31,658.80 2,537, 703.80 10/27/15 10/27/15 FA FHLB N/A 4,000,000.00 1.125% 4,020,840.00 0.941% 108,785.00 4,129,625.00 10/28/15 10/28/17 FA FHLMC 1/28/2016 3,000,000.00 0.700% 3,000,000.00 0.700% 36,750.00 3,036, 750.00 10/28/15 10/28/15 CN JOHNSON & JOHNSON N/A 4,000,000.00 1.650% 4,070,600.00 1.070% 134,183.33 4,204,783.33 10/28/15 10/28/15 FA FFCB 1/28/2016 4,650,000.00 1.150% 4,648,837.50 1.158% 174,956.25 4,823,793.75 10/29/15 10/29/15 CN WAL-MART STORES N/A 4,000,000.00 1.125% 4,024,400.00 0.873% 85,850.00 4,110,250.00 10/30/15 10/30/15 FA FHLB N/A 3,500,000.00 0.750% 3,507,910.00 0.580% 27,235.83 3,535,145.83 NOVEMBER 10/30/15 11/02/15 FA FNMA 4/29/2016 5,000,000.00 1.200% 4,992,500.00 1.247% 202,000.00 5,194,500.00 10/29/15 11/03/15 CN 3M N/A 3,500,000.00 2.000% 3,554,215.00 1.660% 279,062.78 3,833,277. 78 11/02/15 11/03/15 FA FNMA N/A 2,700,000.00 0.875% 2, 700,891.00 0.860% 52,593.37 2,753,484.37 11/02/15 11/03/15 TR US TREASURY N/A 3,000,000.00 1.000% 3,016,308.00 0.450% 13,444.75 3,029, 752.75 11/02/15 11/03/15 TR US TREASURY N/A 2,000,000.00 0.500% 2,000,426.00 0.480% 10,311.70 2,010,737.70 10/29/15 11/03/15 CN APPLE, INC N/A 4,000,000.00 2.000% 4,028,000.00 1.837% 332,666.66 4,360,666.66 11/05/15 11/10/15 CN MICROSOFT N/A 5,000,000.00 2.000% 5,018,550.00 1.920% 479,505.56 5,498,055.56 10/30/15 11/04/15 CN EXXON MOBIL N/A 5,000,000.00 1.912% 5,057,700.00 1.630% 357,097.78 5,414,797.78 11/02/15 11/27/15 FA FNMA 5/27/2016 2,000,000.00 1.500% 1,999,500.00 1.507% 113,000.00 2,112,500.00 DECEMBER 12/17/15 12/18/15 FN FHLB DISC CORP N/A 3,500,000.00 0.000% 3,490,975.83 0.005% 18,048.34 3,509,024.17 12/17/15 12/18/15 FA FFCB 8/12/2016 1 ,950,000.00 1.730% 1,950,000.00 1.730% 123,132.75 2,073,132.75 12/17/15 12/18/15 FA FNMA 2/28/2016 1 ,446,000.00 1.700% 1 ,444,554.00 1.728% 92,262.83 1,536,816.83 12/17/15 12/22/15 CN CHEVRON N/A 2,800,000.00 2.193% 2,811,200.00 2.083% 228,105.03 3,039,305.03 12/17/18 12/22/15 CN EXXON MOBIL N/A 1 ,250,000.00 1.819% 1 ,259,125.00 1.580% 64,329.76 1,323,454.76 12/21/15 12/22/15 FA FHLMC 2/15/2016 1,600,000.00 1.650% 1 ,596,800.00 1.703% 106,086.67 1, 702,886.67 12/17/15 12/23/15 FA FHLB 3/23/2016 2,500,000.00 1.950% 2,498,000.00 1.969% 221,375.00 2,719,375.00 12/21/15 12/28/15 FA FHLMC 3/28/2016 2,450,000.00 1% STEP 2,450,000.00 1.910% 165,375.00 2,615,375.00 12/21/15 12/30/15 FA FFCB 12/30/2016 2,600,000.00 1.720% 2,600,000.00 1.720% 178,880.00 2,778,880.00 12/21/15 12/24/15 CN CHEVRON N/A 2,250,000.00 1.718% 2,253,600.00 1.650% 93,037.50 2,346,637.50 J:l:j 12/28/15 12/29/15 TR US TREASURY N/A 2,000,000.00 1.250% 1 ,998,878.00 1.270% 72,069.80 2,070,947.80 :X: 12/28/15 12/29/15 FA FHLMC 3/17/2016 1 ,552,000.00 1.770% 1,552,000.00 1.770% 108,965.92 1 ,660,965.92 \I1 12/28/15 12/29/15 FA FHLB 7/27/2016 1 ,000,000.00 1.220% 998,850.00 1.265% 32,598.89 1,031,448.89 H td 12/28/15 12/29/15 FA FNMA N/A 1,000,000.00 1.125% 997,610.00 1.220% 31,171.25 1,028,781.25 H 12/28/15 12/29/15 FA FHLB N/A 1,000,000.00 0.750% 995,550.00 1.020% 16,929.17 1,012,479.17 t-3 12/28/15 12/29/15 CN CHEVRON CORP N/A 1,000,000.00 1.718% 996,300.00 1.871% 46,315.94 1,042,615.94 0'1 --£) TOTAL SECOND QUARTER 2015-2016 123,180,000.00 123,404,045.15 1.293% 5,996, 780.14 129,400,825.29 TRANSACTIONS FOR PERIOD: 10/01/15 TO 12/31/15 2nd QUARTER 2015-2016 Trans Investment Call Par Amount Return Investment Date Date ~ Security Date Value COU1;20n (Cost) Rate Interest Return ,,MATURITIE~:; OCTOBER 10/28/10 FA FNMA 4/28/2011 2,000,000.00 1.500% 1 ,999,000.00 1.510% 151,000.00 2,150,000.00 10/09/12 CN GENERAL ELECTIC COMPANY N/A 5,000,000.00 0.850% 5,022,225.00 0.700% 105,275.00 5,127,500.00 01/23/13 CN GENERAL ELECTIC COMPANY N/A 3,000,000.00 0.850% 3,010,440.00 0.720% 58,693.33 3,069,133.33 10/06/11 CN WAL-MART STORES N/A 3,000,000.00 1.500% 3,049,826.34 1.080% 132,548.66 3,182,375.00 05/15/12 CN WAL-MART STORES N/A 2,630,000.00 1.500% 2,696,944.02 0.750% 68,939.31 2,765,883.33 10/17/12 CD COMENITYCAP BANK N/A 249,000.00 0.500% 248,601.60 0.550% 4,233.74 252,835.34 NOVEMBER 02/10/12 CN PROCTER & GAMBLE N/A 2,844,000.00 1.800% 2,965,410.36 0.650% 71,270.64 3,036,681.00 11/07/12 CD EAGLE BANK N/A 249,000.00 0.600% 249,000.00 0.600% 4,490.30 253,490.30 DECEMBER 06/20/12 FA FNMA N/A 4,000,000.00 2.000% 4,186,600.00 0.660% 95,622.22 4,282,222.22 12/15/10 CN BARCLA YS BANK N/A 2,000,000.00 3.100% 2,000,000.00 3.100% 310,000.00 2,310,000.00 12/15/10 CN ROYAL BANK OF CANADA N/A 2,000,000.00 2.625% 2,038,220.00 2.220% 225,009.16 2,263,229.16 04/13/12 CN PROCTER & GAMBLE N/A 1,000,000.00 4.850% 1,147,830.00 0.760% 30,272.78 1,178,102.78 12/02/11 CD MIDLAND STATES BANK N/A 249,000.00 1.250% 249,000.00 1.250% 12,450.00 261,450.00 TOTAL SECOND QUARTER 2015-2016 28,221 ,000.00 28,863,097.32 1.071% 1,269,805.14 30,132,902.46 CALLS!'• OCTOBER 12/18/12 12/19/12 FA FHLB 10/9/2015 3,000,000.00 1.000% 2,999,400.00 1.004% 147,266.67 3,146,666.67 07/09/15 07/10/15 FA FHLMC 10/9/2015 1 ,600,000.00 1.600% 1 ,593,088.00 1.700% 122,040.89 1,715,128.89 05/06/15 05/07/15 FA FFCB 10/13/2015 3,000,000.00 1.690% 2,994,750.00 1.732% 223,682.50 3,218,432.50 02/13/15 02/17/15 FA FFCB 10/13/2015 2,000,000.00 1.370% 1 ,996,000.00 1.430% 98,606.11 2,094,606.11 12/04/12 12/05/12 FA FFCB 10/14/2015 2,266,000.00 0.657% 2,265,433.50 0.657% 57,805.03 2,323,238.53 03/21/13 04/17/13 FA FHLMC 10/17/2015 5,000,000.00 1.100% 4,993,750.00 1.126% 281,250.00 5,275,000.00 07/15/14 07/18/14 FA FHLB 10/18/2015 1 ,000,000.00 1.650% 991,430.00 1.830% 91,070.00 1,082,500.00 01/15/14 01/16/14 FA FFCB 10/21/2015 1 ,500,000.00 1.340% 1,474,500.00 1.718% 119,858.33 1 ,594,358.33 06/25/15 07/21/15 FA FHLB 10/21/2015 2,000,000.00 1% STEP 2,000,000.00 2.325% 235,000.00 2,235,000.00 11/10/14 11/12/14 FA FHLB 10/24/2015 3,000,000.00 1.200% 2,984,520.00 1.350% 142,680.00 3,127,200.00 03/05/15 03/06/15 FA FNMA 10/26/2015 1 ,000,000.00 1.010% 998,000.00 1.087% 28,652.78 1,026,652.78 12/14/12 12/28/12 FA FHLB 10/28/2015 5,000,000.00 0.950% 5,000,000.00 0.950% 237,500.00 5,237,500.00 04/30/15 05/01/15 FA FHLMC 10/29/2015 1,000,000.00 1.300% 999,750.00 1.307% 45,677.78 1 '045,427. 78 01/20/15 01/30/15 FA FHLMC 10/30/2015 4,000,000.00 0.625% STEP 4,000,000.00 1.656% 265,000.00 4,265,000.00 02/26/15 02/27/15 FA FHLMC 10/30/2015 1 ,000,000.00 1.000% 999,500.00 1.019% 30,250.00 1 ,029, 750.00 01/08/13 01/30/13 FA FHLB 10/30/2015 5,000,000.00 1.000% 5,000,000.00 1.000% 250,000.00 5,250,000.00 01/03/13 01/30/13 FA FHLB 10/30/2015 5,000,000.00 1.000% 5,000,000.00 1.000% 250,000.00 5,250,000.00 NOVEMBER 01/31/13 02/05/13 FA FHLB 11/3/2015 1 ,666,666.50 1.000% 1 ,662,499.83 1.050% 137,222.22 1,799,722.05 10/23/14 10/24/14 FA FNMA 11/8/2015 2,500,000.00 1.625% 2,482,550.00 1.778% 211,998.61 2,694,548.61 03/02/15 03/12/15 FA FHLB 11/12/2015 1,000,000.00 0.5% STEP 1 ,000,000.00 2.075% 97,333.33 1,097,333.33 11/13/14 11/20/14 FA FFCB 11/20/2015 2,250,000.00 1.940% 2,250,000.00 1.940% 218,250.00 2,468,250.00 01/07/15 01/08/15 FA FNMA 11/24/2015 550,000.00 1.750% 550,000.00 1.750% 42,136.11 592,136.11 DECEMBER 06/15/15 06/24/15 FA FHLMC 12/24/2015 1 ,500,000.00 1.625% 1,494,000.00 1.718% 115,687.50 1,609,687.50 06/12/15 06/15/15 FA FFCB 12/30/2015 1 ,950,000.00 2.000% 1 ,950,000.00 2.000% 177,125.00 2,127,125.00 ~ TOTAL SECOND QUARTER 2015-2016 57' 782,666.50 57,679,171.33 1.365% 3,626,092.86 61,305,264.19 ~ INVESTMENT REPORT AS OF DECEMBER 31, 2015 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN (Days) 2/1/2013 FA FFCB .4% NON-CALL 5,000,000.00 4,998,750.00 0.484% 61,250.00 5,060,000.00 1,095 6/20/2012 FA FNMA 2.25% NON-CALL 5,000,000.00 5,285,278.17 0.700% 135,034.33 5,420,312.50 1,364 4/27/2011 FA FHLB 2.5% NON-CALL 2,000,000.00 2,000,000.00 2.500% 250,000.00 2,250,000.00 1,827 6/12/2014 FA FNMA .375% NON-CALL 3,000,000.00 2,994,690.00 0.461% 28,528.75 3,023,218.75 754 6/12/2014 FA FHLB .59% NON-CALL 3,000,000.00 3,000,672.00 0.580% 39,153.00 3,039,825.00 823 9/12/2013 FA FFCB .95% NON-CALL 1,000,000.00 995,570.00 1.100% 33,009.17 1,028,579.17 1,099 6/12/2014 FA FFCB .97% NON-CALL 500,000.00 504,332.50 0.970% 6,674.31 511,006.81 830 6/12/2014 FA FNMA 1.25% NON-CALL 2,000,000.00 2,031,642.00 0.555% 25,719.11 2,057,361.11 839 10/6/2011 FA FFCB 1.30% NON-CALL 5,000,000.00 5,000,000.00 1.300% 325,000.00 5,325,000.00 1,827 3/3/2015 FA FHLB .625% NON-CALL 2,500,000.00 2,502,350.00 0.570% 24,559.73 2,526,909.73 631 5/28/2013 FA FNMA .50% CALL 5/28/14 QRTYL Y 5,000,000.00 4,997,500.00 0.514% 90,000.00 5,087,500.00 1,280 11/27/2012 FA FHLB .55% BULLET 5,000,000.00 5,000,000.00 0.550% 112,291.67 5,112,291.67 1,491 12/27/2012 FA FFCB .60% BULLET 3,000,000.00 3,000,000.00 0.600% 90,000.00 3,090,000.00 1,461 4/30/2013 FA FHLB .50% ONE CALL 6/30/15 4,000,000.00 4,000,000.00 0.500% 73,333.33 4,073,333.33 1,340 1/3/2013 FA FHLMC .60% BULLET 3,000,000.00 2,998,500.00 0.613% 73,500.00 3,072,000.00 1,461 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 10/30/2013 FA FNMA .075% CALL 12/28/13 QRTLY 2,000,000.00 1 ,978,600.00 1.049% 76,316.67 2,054,916.67 1,337 5/15/2015 FA TVA 5.50% NON-CALL 500,000.00 551,225.00 0.742% 8,587.50 559,812.50 795 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% QRTLY 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 QRTLY 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 5/20/2015 FA FHLB 1.75% CALL 3/18/16 ONE CALL 2,500,000.00 2,528,900.00 1.244% 72,940.28 2,601,840.28 852 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 12/29/2014 FA FHLB 1.05% CALL 12/29/15 CONT 3,000,000.00 2,995,500.00 1.106% 91,125.00 3,086,625.00 1,005 10/18/2012 FA FFCB .87% CALL 10/18/13 CONT 5,000,000.00 4,998,500.00 0.876% 219,000.00 5,217,500.00 1,826 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 11/27/2012 FA FNMA 0.90% CALL 11/27/13 QRTLY 4,000,000.00 4,000,000.00 1.100% 180,000.00 4,180,000.00 1,826 2/19/2013 FA FFCB .87% CALL 11/27113 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 QRTLY 3,350,000.00 3,341,826.00 1.000% 167,299.00 3,509,125.00 1,826 t>:l 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 :><: 1/29/2015 FA FHLB .750% CALL 1/29/16 STEP 2,000,000.00 2,000,000.00 1.330% 80,000.00 2,080,000.00 1,096 ::r:: 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 H tJj 2/5/2013 FA FHLB 1.00% CALL 8/5/13 CONT 3,333,333.50 3,325,000.17 1.050% 83,518.53 3,408,518.70 1,826 H 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 8 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 ~~' =="'=...---. INVESTMENT REPORT AS OF DECEMBER 31, 2015 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN (Days) 3/12/2013 FA FFCB 1.03% CALL 3/12/14 CONT 5,000,000.00 4,991 ,500.00 1.065% 266,000.00 5,257,500.00 1,826 5/7/2013 FA FHLB 1.00 CALL 3/20/15 CONT 3,000,000.00 3,000,000.00 1.000% 146,083.33 3,146,083.33 1,778 5/7/2013 FA FHLB 1.05 CALL 9/20/13 CONT 3,000,000.00 3,000,000.00 1.050% 153,387.50 3,153,387.50 1,778 5/23/2013 FA FHLMC 1.050% CALL 4/30/14 QRTL Y 3,000,000.00 3,000,000.00 1.050% 155,487.50 3,155,487.50 1,803 5/18/2015 FA FNMA 1.125% CALL 10/30/15 QRTLY 4,416,000.00 4,418,428.80 1.106% 144,127.20 4,562,556.00 1,078 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/12/2013 FA FHLMC 1.20% CALL 9/12/13 QRTLY 3,000,000.00 2,999,100.00 1.206% 180,900.00 3,180,000.00 1,826 6/13/2013 FA FNMA 0.80% CALL 12/13/13 QRTLY STEP 5,000,000.00 4,930,000.00 1.407% 351,250.00 5,281,250.00 1,826 6/20/2013 FA FNMA 1.25% CALL 12/20/13 QRTLY 4,000,000.00 3,977,200.00 1.360% 272,800.00 4,250,000.00 1,826 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/2015 FA FHLMC 1.150% CALL 7/27/16 ONE TIME 2,000,000.00 2,000,000.00 1.150% 69,000.00 2,069,000.00 1,096 12/29/2015 FA FHLB 1.220% CALL 7/27/16 ONE TIME 1 ,000,000.00 998,850.00 1.265% 32,598.89 1,031,448.89 941 1/15/2014 FA FHLMC 1.10% CALL 1/30/18 QRTLY 1,000,000.00 980,870.00 1.538% 69,088.33 1,049,958.33 1,657 1/27/2015 FA FNMA 1.0% NON-CALL 1 '1 00,000.00 1 ,096,139.00 1.102% 42,452.67 1 '138,591.67 1,280 5/1/2015 FA FFCB 1.24% CALL 5nt15 CONT 1,095,000.00 1,095,000.00 1.240% 44,090.78 1,139,090.78 1,186 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 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 1/8/2014 FA FFCB 1.250% CALL 1/14/14 CONT 1,750,000.00 1,705,900.00 1.808% 147,641.67 1 ,853,541.67 1,728 4/22/2015 FA FHLB 1.250% CALL4/22/16 1,000,000.00 1,000,000.00 1.250% 43,750.00 1,043,750.00 1,279 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 4/8/2014 FA FHLB 1.2% CALL 4/21/14 Monthly 2,250,000.00 2,198,250.00 1.720% 176,475.00 2,374,725.00 1,688 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 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 QRTLY 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 6/30/2015 FA FHLB 1.4% CALL 6/24/16 ONE TIME 2,000,000.00 2,000,000.00 1.400% 97,533.33 2,097,533.33 1,273 4/6/2015 FA FHLB 1.30% CALL 3/30/16 1,500,000.00 1,500,000.00 1.300% 72,691.67 1,572,691.67 1,362 7/28/2015 FA FHLB 1.250% CALL 7/28/16 1 ,700,000.00 1,700,000.00 1.250% 72,604.17 1,772,604.17 1,249 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 5/26/2015 FA FNMA 1.375% CALL 2/26/16 ONE TIME 1 ,500,000.00 1,501 ,395.00 1.350% 75,948.75 1,577,343.75 1,372 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 5/28/2015 FA FHLMC 1.5% CALL 8/28/15 QRTL Y 2,500,000.00 2,500,000.00 1.500% 140,625.00 2,640,625.00 1,372 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/2015 FA FHLMC 1.570% CALL 1/29/16 2,000,000.00 2,000,000.00 1.570% 134,450.00 2,134,450.00 1,551 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 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 -"""'--:,..__ INVESTMENT REPORT AS OF DECEMBER 31, 2015 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN !Days) 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/30/2015 FA FHLMC 1.5% CALL 86/28/16 ONE TIME 2,300,000.00 2,300,000.00 1.500% 137,808.33 2,437,808.33 1,459 12/28/2015 FA FHLMC 1.0% CALL 3/28/16 QRTLY STEP 2,450,000.00 2,450,000.00 1.910% 165,375.00 2,615,375.00 1,278 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 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 12/18/2015 FA FFCB 1.73% CALL 8/12/16 CONT 1,950,000.00 1 ,950,000.00 1.730% 123,132.75 2,073,132.75 1,333 12/18/2015 FA FNMA 1.7% CALL 2/28/16 QRTLY 1 ,446,000.00 1,444,554.00 1.728% 92,262.83 1,536,816.83 1,349 11/27/2015 FA FNMA 1.50% CALL 5/27/16 2,000,000.00 1,999,500.00 1.507% 113,000.00 2,112,500.00 1,369 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 10/24/2014 FA FNMA 1.55% CALL 1/15/15 QRTLY 1,000,000.00 984,640.00 1.875% 92,472.50 1 ,077,112.50 1,817 10/15/2015 FA FFC B 1.44 % CALL 1/15/16 CONT 3,000,000.00 3,000,000.00 1.440% 172,800.00 3,172,800.00 1,461 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 12/22/2015 FA FHLMC 1.650% CALL 2/15/16 QRTL Y 1,600,000.00 1,596,800.00 1.703% 106,086.67 1,702,886.67 1,424 1/21/2015 FA FNMA 1.25% CALL 2/21/15 QRTLY STEP 2,500,000.00 2,498,750.00 1.250% 271,041.67 2,769,791.67 1,765 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 12/28/2015 FA FHLMC 1.77% CALL 3/17/16 QRTLY 1 ,552,000.00 1,552,000.00 1.770% 108,965.92 1,660,965.92 1,450 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 4/6/2015 FA FFCB 1.690% CALL 4/9/15 CONT 1,500,000.00 1,495,500.00 1.755% 127,517.92 1,623,017.92 1,774 4/1/2015 FA FNMA 1.00% CALL 8/19/15 QRTL Y STEP 2,000,000.00 2,001,000.00 2.097% 206,666.67 2,207,666.67 1,785 4/1/2015 FA FHLB 2.25% CALL 9/23/16 ONE TIME 2,750,000.00 2,812,562.50 1.770% 245,437.50 3,058,000.00 1,818 4/1/2015 FA FNMA 1.70% CALL 3/30/16 QRTLY 1,099,000.00 1,099,549.50 1.690% 92,813.60 1,192,363.10 1,825 10/20/2015 FA FFCB 1.625% CALL 1/20/16 CONT 5,000,000.00 5,000,000.00 1.625% 365,625.00 5,365,625.00 1,644 4/29/2015 FA FHLMC 1.0% CALL 7/29/15 QRTLY STEP 1,500,000.00 1,498,500.00 2.109% 160,875.00 1,659,375.00 1,827 4/29/2015 FA FNMA 1.6% CALL 4/29/16 ONE CALL 2,000,000.00 2,000,000.00 1.600% 160,000.00 2,160,000.00 1,827 5/1/2015 FA FNMA 1.55% CALL 4/29/16 ONE CALL 2,650,000.00 2,646,025.00 1.581% 209,121.81 2,855,146.81 1,825 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 5/27/2015 FA FNMA 1.8% CALL 5/27/16 ONE CALL 1,750,000.00 1,750,000.00 1.800% 157,500.00 1,907,500.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 12/23/2015 FA FHLB 1.95% CALL 3/23/16 CONT 2,500,000.00 2,498,000.00 1.960% 221,375.00 2,719,375.00 1,644 7/15/2015 FA FHLMC 1.0% CALL 1/15/16 ONE TIME STEP 4,000,000.00 4,000,000.00 1.000% 402,500.00 4,402,500.00 1,827 10/27/2015 FA FNMA 1.470% CALL 10/27/16 ONE TIME 5,000,000.00 5,000,000.00 1.470% 367,500.00 5,367,500.00 1,824 SUB-TOTAL 324,781,333.50 325,369,242.25 1.193% 16,277,470.83 341,646,713.08 1,430 12/18/2015 FN FHLB 0% NON-CALL 3,500,000.00 3,490,975.83 0.520% 18,048.34 3,509,024.17 182 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% 282,817.22 2,241 ,408.61 1,639 9/23/2015 FN FICO 0% NON-CALL 3,200,000.00 3,003,168.00 1.590% 400,784.34 3,403,952.34 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 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 SUB-TOTAL 18,963,000.00 17,886,987.07 1.4109% 1,430,398.05 19,317,385.12 3,187 Federal Investments Total 343,7 44,333.50 343,256,229.32 17,707,868.88 360,964,098.20 2,309 INVESTMENT REPORT AS OF DECEMBER 31, 2015 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN (Davsl 11/3/2015 TR US TREASURY 1.0% 3,000,000.00 3,016,308.00 0.450% 13,444.75 3,029,752.75 363 11/3/2015 TR US TREASURY .50% 2,000,000.00 2,000,426.00 0.480% 10,311.70 2,010,737.70 393 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 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 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 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 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 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 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 8/1/2014 TR US TREASURY 1.6250% 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 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 SUB-TOTAL 58,115,000.00 58,259,547.78 1.098% 2,201,532.90 60,461 ,080.68 1,146 10/31/2011 CN MET LIFE GLOBAL FUNDING 3.125% NON-CALL 1,635,000.00 1,695,247.73 2.200% 154,062.17 1,849,309.90 1,533 12/28/2011 CN MET LIFE GLOBAL FUNDING 3.125% NON-CALL 2,000,000.00 2,063,239.83 2.300% 189,017.11 2,252,256.94 1,475 1/25/2012 CN MET LIFE GLOBAL FUNDING 3.125% NON-CALL 5,000,000.00 5,189,924.57 2.120% 428,999.04 5,618,923.61 1,447 3/9/2012 CN MET LIFE GLOBAL FUNDING 3.125% NON-CALL 3,000,000.00 3,169,646.15 1.600% 190,249.68 3,359,895.83 1,403 2/8/2012 CN GENERAL ELECTRIC 1.55% NON-CALL FLOATER 5,000,000.00 5,000,000.00 1.390% 227,500.00 5,227,500.00 1,461 5/6/2011 CN MASS MUTUAL GLOB 3.125% NON-CALL 1,000,000.00 1 ,024,175.57 3.125% 130,164.71 1,154,340.28 1,805 5/16/2011 CN GENERAL ELECTRIC 2.95% NON-CALL 2,000,000.00 2,000,912.32 2.940% 292,940.46 2,293,852.78 1,820 6/17/2011 CN GENERAL ELECTRIC 2.95% NON-CALL 2,000,000.00 2,009,952.38 2.840% 278,819.84 2,288,772.22 1,788 9/12/2011 CN GENERAL ELECTRIC 2.95% NON-CALL 1,400,000.00 1,427,513.33 2.500% 164,875.84 1,592,389.17 1,701 12/4/2012 CN JOHNSON & JOHNSON 2.15% NON-CALL 2,000,000.00 2,104,120.00 0.621% 44,110.56 2,148,230.56 1,258 9/13/2013 CN TOYOTA .80% NON-CALL 3,000,000.00 2,981,640.00 1.032% 82,626.67 3,064,266.67 977 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 9/4/2012 CN GOOGLE 2.125% NON-CALL 1,000,000.00 1,050,940.00 2.125% 6,197.92 1 ,057,137.92 1,353 9/10/2013 CN CHEVRON CORP .889% NON CALL 2,000,000.00 1,993,903.80 1.000% 55,682.64 2,049,586.44 1,018 ~--~ INVESTMENT DATE 10/27/2011 10/11/2011 1/23/2013 10/2/2012 9/22/2011 11/10/2011 9/18/2014 1/31/2012 1/31/2012 3/5/2012 8/6/2012 2/16/2012 4/18/2012 6/5/2012 6/12/2014 3/8/2013 5/27/2015 3/26/2013 10/29/2015 9/18/2014 1/27/2015 5/11/2015 5/15/2013 12/24/2015 12/31/2015 12/19/2014 2/19/2015 12/24/2013 10/28/2015 4/9/2015 4/6/2015 12/22/2015 6/30/2015 10/8/2015 5/27/2015 7/16/2015 11/18/2014 12/22/2015 4/9/2015 9/25/2015 11/4/2015 11/3/2015 11/3/2015 9/25/2015 9/24/2015 11/10/2015 TYPE CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN INVESTMENT REPORT AS OF DECEMBER 31, 2015 SECURITY PROCTER & GAMBLE 1.45% NON-CALL BERKSHIRE HATHAWAY 2.20% NON-CALL PROCTER & GAMBLE 1.45% NON-CALL COCA COLA CA 1.8% NON-CALL TOYOTA 2.0% NON-CALL NEW YORK LIFE 2.45% NON-CALL COLGATE-PALMOLIVE 1.30% MAKE WHOLE CALL BERSHIRE HATHAWAY 1.90% NON-CALL HSBC BANK USA 2.5% FLOATING RATE BERSHIRE HATHAWAY 1.90% NON-CALL IBM CORP 1.250% NON-CALL WESTPAC BANKING CORP 2.3% NON-CALL WAL-MART STORES 5.375% NON-CALL HSBC BANK USA 1.925% FLOATER CHEVRON CORP 1.104% NON CALL WAL-MART 5.8% NON CALL WAL-MART 5.8% NON CALL COCA COLA CA 1.150% MAKE-WHOLE CALL WAL-MART STORES 1.125% MAKE WHOLE COLGATE-PALMOLIVE .90% MAKE WHOLE CALL COLGATE-PALMOLIVE .90% MAKE WHOLE CALL APPLE 1.0% MAKE WHOLE CALL BERKSHIRE HATAWAY 1.30% MAKE WHOLE CALL CHEVRON CORP 1.718% MAKE WHOLE CALL CHEVRON CORP 1.718% MAKE WHOLE CALL MASS MUTUAL GLOBAL 2.10% NON-CALL ROYAL BANK OF CANADA 2.00% NON-CALL COCA COLA CA 1.650% MAKE-WHOLE CALL JOHNSON & JOHNSON 1.65% MAKE WHOLE MICROSOFT 1.625% NON-CALL PEFCO 4.375% NON-CALL EXXON MOBIL 1.819% NON-CALL MASS MUTUAL GLOBAL 2.35% NON-CALL APPLE 2.10% MAKE WHOLE CALL IBM CORP 1.8750% NON-CALL TOYOTA 2.125% NON-CALL CHEVRON CORP 2.193% MAKE-WHOLE CALL CHEVRON CORP 2.193% MAKE-WHOLE CALL NY LIFE GOLBAL 1.95% NON-CALL CVX 1.961% MAKE WHOLE CALL EXXON MOBIL 1.912% MAKE WHOLE CALL APPLE 2.0% MAKE WHOLE CALL MMM 2.0% MAKE WHOLE CALL JOHNSON & JOHNSON 2.95% MAKE WHOLE AUTOMATIC DATA PROCESSING 2.25% MAKE-WHOLI MICROSOFT 2.00% MAKE WHOLE CALL PAR VALUE 5,000,000.00 5,000,000.00 1,000,000.00 3,000,000.00 5,000,000.00 3,550,000.00 500,000.00 5,000,000.00 5,000,000.00 2,850,000.00 5,000,000.00 5,000,000.00 3,000,000.00 5,000,000.00 2,000,000.00 3,000,000.00 2,000,000.00 1 ,000,000.00 4,000,000.00 1,000,000.00 2,000,000.00 2,000,000.00 5,000,000.00 2,250,000.00 1,000,000.00 3,500,000.00 2,250,000.00 3,500,000.00 4,000,000.00 2,000,000.00 2,274,000.00 1,250,000.00 3,250,000.00 2,500,000.00 2,150,000.00 2,000,000.00 3,000,000.00 2,800,000.00 2,000,000.00 2,800,000.00 5,000,000.00 4,000,000.00 3,500,000.00 1,000,000.00 4,000,000.00 5,000,000.00 INVESTED AMOUNT 5,011 ,536.25 5,022,855.25 1 ,025,260.00 3,133,106.35 5,023,645.00 3,669,194.08 504,585.00 5,047,739.83 5,000,000.00 2,914,809.00 5,077,000.00 5,000,000.00 3,568,354.19 5,000,000.00 1 ,996,180.00 3,669,120.00 2,249,440.00 1 ,000,000.00 4,024,400.00 980,600.00 1,983,000.00 1 ,989,840.00 5,019,345.05 2,253,600.00 996,300.00 3,555,685.00 2,289,442.50 3,491,856.17 4,070,600.00 2,037,820.00 2,527,892.10 1 ,259,125.00 3,286,335.00 2,558,025.00 2,169,715.50 2,009,760.00 3,017,400.00 2,811,200.00 2,017,520.00 2,790,704.00 5,057,700.00 4,028,000.00 3,554,215.00 1,058,028.49 4,029,600.00 5,018,550.00 RETURN RATE 1.400% 2.100% 0.730% 0.650% 1.900% 1.700% 0.009% 1.700% 1.748% 1.418% 0.900% 2.300% 1.400% 1.037% 1.160% 1.140% 1.125% 1.150% 0.873% 1.452% 1.166% 1.174% 1.220% 1.650% 1.871% 1.645% 1.500% 1.700% 1.070% 1.096% 1.450% 1.580% 2.040% 1.432% 1.635% 1.998% 2.070% 2.083% 1.760% 2.039% 1.630% 1.837% 1.660% 1.718% 2.090% 1.920% INTEREST 336,463.75 510,033.64 26,376.11 78,243.65 474,410.56 287,655.64 10,527.50 427,260.17 425,000.00 200,676.42 204,250.00 574,680.56 229,833.31 342,500.00 80,670.67 189,763.33 65,693.33 57,627.78 85,850.00 51,975.00 75,700.00 69,715.56 305,654.95 93,037.50 46,315.94 210,344.17 123,307.50 288,391.75 134,183.33 81,075.83 138,254.46 64,329.76 251,980.62 129,808.33 140,190.75 160,476.11 311,001.75 228,105.03 171,196.67 253,026.51 357,097.78 332,666.66 279,062.78 87,504.84 418,150.00 479,505.56 INVESTMENT RETURN 5,348,000.00 5,532,888.89 1 ,051,636.11 3,211,350.00 5,498,055.56 3,956,849.72 515,112.50 5,475,000.00 5,425,000.00 3, 115,485.42 5,281,250.00 5,574,680.56 3,798,187.50 5,342,500.00 2,076,850.67 3,858,883.33 2,315,133.33 1,057,627.78 4,110,250.00 1,032,575.00 2,058,700.00 2,059,555.56 5,325,000.00 2,346,637.50 1,042,615.94 3,766,029.17 2,412,750.00 3,780,247.92 4,204,783.33 2,118,895.83 2,666,146.56 1,323,454.76 3,538,315.62 2,687,833.33 2,309,906.25 2,170,236.11 3,328,401.75 3,039,305.03 2,188,716.67 3,043,730.51 5,414,797.78 4,360,666.66 3,833,277.78 1 '145,533.33 4,447,750.00 5,498,055.56 TERM !Days) 1,754 1,770 1,300 1,430 1,820 1,708 850 1,827 1,827 1,793 1,645 1,826 1,813 1,826 1,272 1,805 995 1,832 895 1,321 1,190 1,088 1,826 913 906 1,322 1,320 1,782 1,134 1,337 1,439 1,179 1,379 1,306 1,449 1,463 1,823 1,424 1,769 1,621 1,584 1,646 1,739 1,803 1,818 1,820 INVESTMENT REPORT AS OF DECEMBER 31, 2015 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN (Days) SUB-TOTAL 173,634,000.00 177,214,662.19 1.599% 12,163,498.20 189,378,160.39 1,487 2/10/2012 CD CARDINAL BANK MCLEAN VA .90% 249,000.00 249,000.00 0.900% 8,970.06 257,970.06 1,461 2/6/2013 CD ORIENTAL BANK & TRUST .90% CALL 8/6/13 249,000.00 249,000.00 0.900% 6,735.45 255,735.45 1,097 8/24/2012 CD FIRST BUSINESS BANK .60% 248,000.00 247,578.40 0.600% 5,635.72 253,214.12 1,279 10/22/2012 CD NATIONAL BANK OF COMMERCE .50% 249,000.00 248,551.80 0.550% 4,791.87 253,343.67 1,274 5/4/2012 CD HERITAGE BANK OF COMMERCE .80% 249,000.00 248,004.00 0.900% 8,953.05 256,957.05 1,459 5/18/2012 CD NORTH JERSEY COMMUNITY .85% 248,000.00 247,008.00 0.950% 9,429.77 256,437.77 1,461 5/22/2012 CD STATE BANK & TRUST CO MACON, GA .80% 249,000.00 248,004.00 0.900% 8,974.88 256,978.88 1,462 5/31/2012 CD CRESCENT BANK & TRUST .90% 249,000.00 248,502.00 0.950% 9,468.06 257,970.06 1,461 8/15/2012 CD EVERBANK .90% 248,000.00 247,008.00 0.900% 9,926.11 256,934.11 1,461 2/28/2012 CD MERCANTILE BANK OF MICHIGAN 1.15% 248,000.00 247,380.00 1.150% 14,895.62 262,275.62 1,827 12/24/2012 CD DELTA 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/17/2012 CD FIRST AMERICAN BANK 1.0% 249,000.00 248,253.00 1.000% 13,128.78 261,381.78 1,816 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 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/23/2013 CD FIRST FARMERS BANK & TRUST 1.0% 249,000.00 248,626.50 1.000% 12,823.50 261,450.00 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/30/2013 CD FARMERS & MERCHANTS BANK .90% 249,000.00 248,253.00 0.900% 11,952.00 260,205.00 1,826 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 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 BANK2.1% 247,000.00 247,000.00 2.100% 25,935.00 272,935.00 1,826 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 BANK2.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 NAT'L 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 INVESTMENT REPORT AS OF DECEMBER 31, 2015 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN (Days) 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 2/27/2015 CD JP MORGAN CHASE BANK 2.0% 247,000.00 247,000.00 2.000% 24,700.00 271,700.00 1,826 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 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/21/2015 CD WESTERN STATE BANK 1.95% 249,000.00 248,377.50 2.000% 25,145.00 273,522.50 1,820 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 SUB-TOTAL 15,048,000.00 15,029,830.60 1.501% 1 ,084,125.90 16,113,956.50 1,701 0 WELLS FARGO BANK 316,458.00 316,458.00 0.020% 0.17 316,458.17 0 CORPORATE CASH MANAGEMENT ACCOUNT 4,168,868.56 4,168,868.56 0.020% 2.28 4,168,870.84 0 LIBRARY ACCOUNT 289.93 289.93 0.000% 289.93 0 UNION TRUST 8,819.18 8,819.18 0.000% 0.00 8,819.18 0 LA IF WATER DISTRICT 23,166,000.00 23,166,000.00 0.380% 244.53 23,166,244.53 0 LA IF PUBLIC IMPROVEMENT CORPORATION 20,336,927.62 20,336,927.62 0.380% 214.67 20,337,142.29 0 LA IF PUBLIC FINANCING CORPORATION 28,693,281.86 28,693,281.86 0.380% 302.87 28,693,584.73 0 L A I F CITY OF CARLSBAD 30,794,000.00 30,794,000.00 0.380% 325.05 30,794,325.05 SUB-TOTAL 107,484,645.15 107,484,645.15 0.365% 1,089.58 107,485,734.73 GRAND TOTAL 698,025,978.65 701,244,915.04 1.173% 33,158,115.46 734,403,030.50 CITY OF CARLSBAD Fund Equity in Pooled Investments AS OF DECEMBER 31, 2015 Cash Balance by Fund: General Special Revenue Debt Service 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 48,074,326 21,595,989 26,460,549 8,134,901 5,369,980 6,371,764 88,942,493 93,740,530 3,004,786 121,672,770 53,042,456 7,322,978 5,012,321 2,024,512 EXHIBIT 8 108,376,354 43,558,832 0 301 ,695,317 189,075,037 41,032,015 14,740,917 219,900 698,698,372 371,608 699,069,979 (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 01/08/16 J EXHIBIT 9 CITY OF CARLSBAD INVESTMENT PORTFOLIO As of DECEMBER 31, 2015 CORPORATE 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 APPLE AA1 AA+ AA+ BERKSHIRE HATAWAY AA2 AA A+ CHEVRON AA1 AA NR COCA COLA AA3 AA A+ COLGATE-PALMOLIVE AA3 AA-AA- CHEVRON CORP (CVX) AA1 AA NR EXXON MOBIL AAA AAA NR GOOGLE INC AA2 AA NR IBM CORP AA3 AA-A+ JOHNSON & JOHNSON AAA AAA AAA MASS MUTUAL GLOBAL AA2 AA+ AA+ MET LIFE GLOBAL AA3 AA-AA- MICROSOFT AAA AAA AA+ 3M COMPANY AA3 AA-NR NEW YORK LIFE AAA AA+ AAA PRIVATE EXPORT FUNDING (PEFCO) AAA A+ AAA PROCTER & GAMBLE AA3 AA-NR ROYAL BANK OF CANADA AA3 AA-AA TOYOTA AA3 AA-A WAL-MART AA2 AA AA WESTPAC BANKING CORP 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 * Latest Moody's S&P Fitch Maturity Date GENERAL ELECTRIC CAP A1 AA+ NR 05/09/2016 HSBC BANK USA A1 AA-NR 06/05/2017 *The City's Investment Policy allows the City Treasurer to determine the course of action that would correct exceptions to 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 10,402,888 10,000,000 Market Value 10,437,532 9,817,000 ~ City of Carlsbad Bond Proceeds Investment Report December 31, 2015 Stated Int. Maturity Fund Type Investments Rate Date Par Value Assessment District 03-01 (College/Cannon) Project Fund lnvesco Prime-Institutional Money Market N/A N/A $ 929,547 Re-Assessment District 97-01 (Alga Road & College Blvd) lmprvmnt Fund -Alga lnvesco Prime-Institutional Money Market N/A N/A $ 278,866 Assessment District 95-01 (Carlsbad Ranch) Reserve Fund Repub Natl Bank Repo Agreement: HSBC {GIC) 5.83% N/A $ 995,454 Assessment District 96-01 (Rancho Carrillo) Reserve Fund Repub Natl Bank Repo Agreement: HSBC (GIC) 6.03% 09/02/28 $ 1,292,770 ReAssessment District 2012-1 (College/Cannon & Poinsettia Lane) Reserve Fund BNY Goldman Sachs FS Money Market various N/A $ 2,166,510 Other BNY Goldman Sachs FS Money Market various N/A $ 6,080 Communities Facilities District #3 Improvement Area 1 Project Fund lnvesco Prime-Institutional Money Market N/A N/A $ 1,838,624 Reserve Fund BNY Dreyfus Money Market various 09/01/36 $ 777,965 Communities Facilities District #3 Improvement Area 2 Reserve Fund BNY Dreyfus Money Market various 09/01/38 $ 1,068,180 CPFA Golf Course Bonds Reserve Fund BNY Mellon {GIC) various N/A $ 1,367,253 $ 10,721,249 F:\My Documents~unk\Qtr lnv Rpt1215 Cost Source Fiscal Agent: BNYMellon $ 929,547 lnvesco Fiscal Agent: US Bank $ 278,866 lnvesco Fiscal Agent: BNYMellon $ 995,454 HSBC Bank of New York Fiscal Agent: BNYMellon $ 1,292,770 HSBC Bank of New York Fiscal Agent: BNYMellon $ 2,166,510 BNY Mellon $ 6,080 BNY Mellon Fiscal Agent: BNYMellon $ 1,838,624 lnvesco $ 777,965 BNY Mellon Fiscal Agent: BNYMellon $ 1,068,180 BNY Mellon Fiscal Agent: BNYMellon $ 1,367,253 BNY Mellon $ 10,721,249 l::tj :><: ::c: H tJj H 8 ...... ...... City of Carlsbad Summary of Outstanding Housing Loans As of December 31, 2015 Borrower Developl"!!~!!_t Purpose Individual homebuyers Individual homebuyers Individual homebuyers Individual homebuyers Individual homebuyers City-wide (CHAP) Calavera Hills Cherry Tree Walk Serrano Rancho Carlsbad Individual homebuyers Solamar Catholic Charities Homeless shelter CB Laurel Tree Apartments Laurel Tree USA Properties c/o CFHP Rancho Carrillo Pacific Vista Las Flores Vista Las Flores Poinsettia Housing Assoc Poinsettia Station Bridge Housing Corp Villa Loma Dove Family Housing La Costa Paloma CIC Calavera LP Mariposa Apts Individual homebuyers Individual homebuyers Mulberry at Bressi Ranch Village by the Sea El Camino Family Housing Cassia Heights Individual home buyers Individual homebuyers Individual homebuyers CIC La Costa Down Payment & Closing Cost Assistance CIC Glen Ridge, LP Tavarua Senior Apartments, Laguna Point The Bluffs Roosevelt Gardens Hunter's Point Various Glen Ridge LP Tavarua North County Solutions for Sale Sale Sale Sale Sale Sale Shelter Rentals Rentals Rentals Rentals Rentals Rentals Rentals Sale Sale Rentals Sale Sale Sale Rentals Assistance Rentals Rentals Change Property Acquisition Rentals Catholic Charities Homeless shelter Shelter Individual homeowners N/A Hospice of North Coast N/A Minor Home Repair Property Acquisition Property Harding Street Neighbors, LP Carol-Harding Duplex Acquisition Tracy Templeton Thomas & Judy Kim Solutions for Change Allowances Laguna Point Rose Bay N/A Sale Sale Property Acquisition First date issued 06/28/99 10/15/99 06/28/99 05/25/01 05/20/99 09/26/88 09/19/97 12/24/98 03/05/01 02/27/01 10/21/99 11/04/94 07/15/03 09/15/04 04/29/05 10/28105 03/07/06 07/06/06 06/14/07 08/30/07 08/19/08 06/25/09 10/05/09 12/14/11 06/28/12 03/01/10 05/20/10 02/27/13 03/14/13 04/17/13 08/23/13 12/19/14 #of loans issued 133 42 90 22 100 11 10 11 22 10 Loans issued by City to developers/ homeowners $1,680,000 75,000 453,600 1,350,000 752,533 147,726 200,000 1,134,000 1,157,584 363,948 920,000 2,212,000 2,070,000 1,060,000 1,840,000 220,000 1,454,276 210,000 200,000 1,583,423 1,932,000 255,518 1,014,000 780,000 507,585 39,676 1,065,000 7,408,000 108,150 229,775 Loans issued by Developer to homeowners 150,000 452,600 4,050,000 19,660,200 4,087,200 #of loans outstanding 19 14 25 100 11 10 11 21 Developer City loan repaid loan repaid to to City City ($1,656.431) (60,000) (324,000) (1,005,133) (592,646) (135,065) (1,134,000) (40,180) (224,279) (2,212,000) (1,851,325) (70,000) (12,500) (2,083) (120,000) (283,250) (2,700,000) Loan amount Developer loan due to City amount due to City (recorded as (not on City's AR) books) $23,569.48 15,000 129,600 344,867 159,887 12,661 200,000 (0) 1,117,404 363,948 695,721 218,675 1,060,000 1,840,000 220,000 1,454,276 140,000 200,000 1,583,423 1,932,000 243,018 1,014,000 780,000 507,585 37,593 1,065,000 7,408,000 108,150 229,775 30,000 169,350 1,350,000 19,660,200 4,087,200 Total Type of Loan Payment deferred 15 years. No 1nterest is due 23,569 unless home is sold before 16th year Payment deferred 30 years. No interest is due 45,000 unless home is sold before 31th year Payment deferred 30 years. No interest is due 298,950 unless home IS sold before 31th year Payment deferred 30 years. No interest is due 1,694,867 unless home is sold before 31th year 159,887 Principal is due when home is sold 12,661 Principal is due when home is sold 200,000 Pnncipal is due when property is sold Princ1pal and 3% interest each year for 30 years (D) when surplus cash is available Principal and 3% interest each year for 55 years 1,117,404 when surplus cash IS available Principal and 3% interest each year for 55 years 363,948 when surplus cash 1s available Prrncipal and 3% interest each year for 55 years 695,721 when surplus cash is available Principal and 3% rnterest each year for 15 years when surplus cash is available Principal and 3% 1nterest each year for 55 years 218,675 when surplus cash 1s available Principal and 3% interest each year for 55 years 1,060,000 when surplus cash is available Payment deferred 30 years No mterest is due 21,500,200 unless home is sold before 31th year Payment deferred 30 years. No interest 1s due 4,307,200 unless home is sold before 31th year Principal and 3% interest each year for 55 years 1 ,454,276 when surplus cash is available Payment deferred 45 years. No interest is due 140,000 unless home 1s sold before 46th year Payment deferred 30 years. No interest is due 200,000 unless home is sold before 31th year Refer to Agenda Bill18,569/ Resolution 2006- 1,583,423 131 &AB 19,183/R2007-255 1,932,000 Refer to AB18,251/ Resolution 2005-264 Refer to Agenda Bill19,415 I Resolution 2008- 243,018 121 1,014,000 Refer to Agenda Bill 397 I Resolution 435 Refer to Agenda Bill418/ Resolution 475 780,000 Refer to Agenda Biii20,936/Resolution 2012-136 Refer to AB19,768/R2009-068; AB20,530/R2011- 507,585 081, AB20,764/R2011-288 37,593 Refer to AB19,415/ Resolution 2008-121 1,065,000 Refer to AB21,116/Resolution 2013-027 7,408,000 Refer to AB21 ,028/Resolutlon 2012-235 108,150 TBD Payment deferred 30 years No interest 1s due 229,775 unless home IS sold before 31th y~ar 2,646,000 1 2,646,000 2,646,000 Refer to AB21,763/Resolution 2014-243 tr_j (1,605,178) (1,605,178) @ 491 $ 33,464,616 $ 28,4oo,ooo 251 $ (9,319,643) $ (3,103,250) $24,144,974 $ 25,296,750 $ 51,046,902 H October 15: received $1,795 in CHAP loan payments. November 15: received $2,072 in CHAP loan repayments. December 15: received $2,687 in CHAP loan payments; issued $5,000 MHR loan. IJj H 8 1-' N