Loading...
HomeMy WebLinkAboutInvestment Report Attachment (Finance)t t A .. CALJFO$tfl {.+•• NO. ,IONAL City tozod City Council Staff Report September 2, 2014 ITEM Staff Report: Investment Report for the quarter ended June 30, 2014. BACKGROUND The California Government Code (§ 53646(b)) requires that, when the treasurer or the chief fiscal officer of a local agency renders to the legislative body of the agency a quarterly report on the agency's investment portfolio, such report shall include the following information regarding all securities, investments, and moneys held by the local agency: • type of investment; • issuer (bank or institution); • date of maturity; ;- dollar amount invested; and •0 current market valuation as of the date of the report. In addition, the Government Code (§ 53646(b)(2)) requires that the report state the City's compliance with its investment policy and include a statement regarding the ability of the local agency to meet its pool's ability to meet its expenditure requirements Code (§ 53646(b)(3)). OVERVIEW OF CITY INVESTMENTS The City's pooled investment portfolio balance as of June 30, 2014 is summarized below and compared to the balance as of June 30, 2013. 6/30/2014 6/30/2013 Book Value 1 $ 65,408,642 $ 59,246,949 Market Value 2 $ 65,293,310 $ 58,969,729 (1) actual cost of investments (2) amount at which the investments could be sold The California Treasurer's Local Agency Investment Fund ("LAIF") and The County of San Diego Pooled Money Fund comprise 65.14% of the City of National City's total investment portfolio (57.43% and 7.71%, respectively). These are liquid investment pools that allow participants to earn market rate returns, while retaining access to funds within 24 to 48 hours of a withdrawal request with no penalty. The remainder of the City's portfolio is composed of investments that may be liquidated at any time. However, these investments likely do not provide Page 2 Staff Report: Investment Report for the quarter ended June 30, 2014. September 2, 2014 the short liquidity (i.e., quick access to funds) of the pooled money funds, and liquidation/withdrawal of these investments is at the risk of loss and/or penalty to the City. Summaries of the City's investment portfolio are illustrated below. INVESTMENT PORTFOLIO SUMMARY BY ISSUER/MANAGER As of June 30, 2014 Total Market %of Issuer/Manager Book Value Market Values YTM Portfolio Local Agency Investment Fund 37,468,579 $ 37,497,626 2 0.26% 57.43% Chandler Asset Management 20,440,063 $ 20,246,936 0.60% 31.01% County of San Diego 5,000,000 $ 5,035,547 0.42% 7.71% Neighborhood National Bank 2,060,000 $ 2,000,000 0.65% 3.06% First Tennessee National Bank 500,000 $ 513,201 2.00% 0.79% Totals for June 2014 65,408,642 65,293,310 0.00 100.00% 1 includes accrued Interest 2 calculated on 30/360 basis TOTAL MARKET VALUE $65.293,311 Neighborhood National Bank $2.000 000 County of San Diego $5 035,547 4041i. Chandler Asset Management S20,246,936 First Tennessee National Bank $513,201 Local Agency Investment Fund $37,497 626 Page 3 Stab Report: Investment Report for the quarter ended June 30, 2014. September 2, 2014 INVESTMENT PERFORMANCE BY ISSUER/MANAGER For the Quarter Ended June 30, 2014 Issuer/Manager Local Agency Investment Fund Chandler Asset Management County of San Diego Neighborhood National Bank (CDARS CD) First Tennessee National Bank Totals for June 2014 Total Market Value 3131/14 - 6130/14 Change Yield (Net) 3 29,477,919:° $ 37,497,528 $ 8,019,707.2 20,195,237 i $ 20,246,936. _ 51,699 5,023,150 ' 5,035,547 12,397 2,000,000 i 2,000,000 _ _ s 512,653 4 513,201 548 0.29% 1.02% 0.99% 0.65%' 0.43% 57,208,959 $ 65,293,310 $ 8,084,351 1 indudes accrued Interest 2 512912014 deposit $8,000,000 ' Annualized `Corrected beginning balance ° Interest earned paid & transferred Into Gity's account at the dose of the quarter COMPLIANCE STATEMENT All of the City's investments are in compliance with the City's investment policy (City Council Policy No. 203) and the California Government Code (§ 53601 et seq). FINANCIAL STATEMENT Realized and unrealized gains/(losses), reflected below, for the period were $88,560. These changes include changes in security market values, gain/(loss) from the sale of assets, accrued interest, and reinvested interest/earnings. Issuer/Manager Gain/(Loss} Chandler Asset Management County of San Diego First Tennessee Bank 1 LAIF Neighborhood National Bank 1 Totals for June 2014 51,699 12,397 3,616 17,853 2,994 $ 88,560 1 interest paid to the City is not reinvested Staff certifies that there are sufficient funds to meet the pool's expenditure requirements. RECOMMENDATIONS Accept and file the Investment Report for the quarter ended June 30, 2014. City of National City Account #10162 Portfolio Summary As of 6/30/2014 PORTFOLIO CHARACTERISTICS ACCOUNT SUMMARY TOP ISSUERS Average Duration Average Coupon Average Purchase YTM Average Market YTM Average S&P/Moody Rating Average Final Maturity Average Life 1.68 1.48 % 0.64 % 0,47 % AA+/Aaa 1.75 yrs 1.68 yrs Market Value Accrued Interest Total Market Value Income Earned Cont/WD Par Book Value Cost Value Beg. Values End Values as of 5131/14 as of 6130/14 20,178,523 20,172,528 81,320 74,409 20,259,843 20,246,936 26,011 25,479 -1,012 19,907, 515 19,933,035 20,467,976 26,440,063 20,467,976 20,440,063 Issuer % Portfolio Federal National Mortgage Assoc 22.3 % Government of United States 22.2 Federal Home Loan Bank 19.2 % Federal Home Loan Mortgage Corp 17.8 % Federal Farm Credit Bank 13.0 % Berkshire Hathaway 1.5 % Apple Inc 1.4 % ChevronTexaco Corp 1.3 % 98.7 % SECTOR ALLOCATION MATURITY DISTRIBUTION CREDIT QUALITY (S&P) Agency (72.3 %) Money Market /� Fund F1 (0.1 %} • us Corporate (5.4 %) US Treasury (22.2 %) 0-.25 .25-.6 .5.1 1-2 28.2 % 9.2 % 2.3 3-4 4-.5 5+ Maturity (Yrs) AA (98.7 %) PERFORMANCE REVIEW Total Rate of Return As of 6/30/2014 Current Month Latest Year 3 Months To Date 1 Yr Annualized 3 Yrs Since 5 Yrs 10 Yrs 2129/2012 2/29/2012 City of National City 1-3 Yr TreasuryAgency -0.06 % 0.27 % 0.46 % 0.92 % N/A N/A N/A 0.58 % 1.35 % 0.77 °,, 0.41 % 0.78°A N/A NIA N/A 0.54 % 1.26 % Chandler Asset Management- CONFIDENTIAL Page 1 Execution Time: 7121201411:50:43 AM City of National City May 31, 2014 COMPLIANCE WITH INVESTMENT POLICY Assets managed by Chandler Asset Management are in full compliance with State taw and with the City's investment policy. Category Standard Comment I Local Agency Bonds No Limitation; BBB rated equivalent by a NRSRO Complies Treasury Issues No Limitation Complies Agency Issues No Limitation Complies Banker's Acceptances 40% maximum; <180 days maturity; A-1 rated equivalent by at least two NRSROs Complies Commercial Paper * 25% maximum; <270 days maturity; A-1 rated equivalent by at least two NRSROs Complies Negotiable Certificates of Deposit * 30% maximum; A rated equivalent by at least two NRSROs Complies Medium Term Notes * 30% maximum; A rated equivalent by at least two NRSROs Complies * 10% combined total exposure to Commercial Paper, Negotiable Certificates of Deposit, and Medium Term Notes Money Market Mutual Funds 20% maximum; rated AAA equivalent by at least two NRSROs Complies Mortgage Pass-throughs, CMOs and Asset Backed Securities 20% maximum; AA -rated issue; A -rated issuer Complies Local Agency investment Fund - L.A.I.F. Currently not used by investment adviser Complies Prohibited Securities Inverse floaters; Ranges notes, Interest- only strips from mortgaged backed securities; Zero interest accrual securities Complies Issuer Maximum 5% per issuer for all non-govemrnent issuers Complies Maximum maturity 5 years Complies mj City Accountof #10162NationalCity Reconciliation Summary As of 6/30/2014 BOOK VALUE RECONCILIATION Beginning Book Value 520,467,976.07 Acqu isition + Security Purchases + Money Market Fund Purchases + Money Market Contributions + Security Contributions + Security Transfers Total Acquisitions $580,858.30 $564,666.53 $0.00 $0.00 $0.00 $1,145,524.83 Disgositiions $0.00 $583,134.51 $1,012.00 $0.00 $0.00 $0.00 $530,000.00 $0.00 $0.00 $1,114,146.51 - Security Sales - Money Market Fund Sales - MMF Withdrawals - Security Withdrawals - Security Transfers - Other Dispositions - Maturites - Calls - Principal Paydowns Total Dispositions AmortizationlAccretion +1- Net Accretion _ $0.00 $0.00 GainlLoss on Dispositions +1- Realized Gain/Loss ($59,291.10) ($59,291.10) Ending Book Value $20,440,063.29 CASH TRANSACTION SUMMARY BEGINNING BALANCE Acquisition Contributions Security Sale Proceeds Accrued Interest Received Interest Received Dividend Received Principal on Maturities Interest on Maturities Calls/Redemption (Principal) Interest from CallslRedemption Principal Paydown Total Acquisitions $0.00 $0.00 $0.00 $34, 663.33 $3.20 $530,000.00 $0.00 $0.00 $0.00 $0.00 $564,666.53 $32,515 05 Disposition Withdrawals $1,012.00 Security Purchase $580,858.30 Accrued Interest Paid $2,276.21 Total Dispositions S584,146.51 Ending Book Value $13,035 07 Chandler Asset Management - CONFIDENTIAL Page 3 Execution Time: 71212014 11:50:43 AM :Fayik I City of National City - -r... oillik I Account #10162 Holdings Report As of 6130/14 Purchase Dino Cost Valua Mkt Price Morkat Value °% of Port Mood9t58.P Maturity CUSIP Seeurily Description Par Valaellilnits Book Yield Book Value Mitt YTM Accrued Irtt, GoIMJLns5 Filch Oil rail ion AGENCY 3137EACD9 FHLMC Note 3% Due 7/28/2014 470,000.00 02/2412012 0.45% 498,859.88 498,859.88 100.22 471,034.47 2.36% Aaa/AA+ 0.17 % 5,992.50 (27,825,41) AAA 0.08 0.08 31398AZV7 FNMA Note 2.625% Due 11/20/2014 470,000.00 02/2112012 496,614.22 0.54 % 496,614.22 100.97 474,563.23 2.35 % Aaa 7 AA+ 0.39 0.13 % 1,435.10 (22,050.99) AAA 0.39 313381H24 FHLB Note 0.25% Due 1116/2015 3137EACHO FHLMC Note 2.875% Due 219/2015 31331KLE8 FFCB Note 1.6% Due 511812015 625,000.00 06121/2013 624,343.75 100.07 625,449.38 3.09 % Aaa / AA+ 0.55 0.32 % 624,343.75 0.12 °% 716.15 1,105.63 AAA 0.54 560,000.00 02/2412012 598,380.16 101.67 569,379.44 2.84 % Aaa/ AA+ 0.61 0.53 % 598,380.16 0.12 % 6,350.56 (29,000.72) AAA 0.60 540,000.00 05/16/2013 554,277.60 101.28 546,922.80 2.71 % Aaa/ AA+ 0.88 0.28 % 554,277.60 0.15 % 1,032.00 (7,354.80) AAA 0.88 3133XWN91 FHLB Note 2.875% Due 6/12/2015 525,000.00 10/15/2013 547,081.50 0.32 % 547,081.50 102.55 538,400.63 2.66 % Aaa / AA+ 0.95 0.18 % 796.61 (8,680.87) AAA 0.94 31398AU34 FNMA Note 2.375°% Due 7728/2015 470,000.00 02/24/2012 497,406.17 0.65 % 497,406.17 102.34 481, 012.10 2.40 % Aaa / AA+ 1.08 0.20 % 4,744.06 (16,394.07) AAA 1.06 3133EADW5 FFCB Note 0.55% Due 6/17/2015 425,000.00 04/19/2012 424,260.50 0.60 % 424,260.50 100.33 026 % 426,400.80 870.07 2.11 % Aaa / AA+ 1.13 2,140.30 AAA 1.12 3137EACM9 FHLMC Note 1.75% Due 9/10/2015 535,000.00 02/24/2012 555,169.50 0.67 % 555,169.50 101.81 544,676.01 2.70 % Aaa / AA+ 1.20 0.23 % 2,886.77 (10,493.49) AAA 1.18 313370JB5 FHLB Note 565,000.00 01/11/2013 585,407.80 101.82 575,260.97 2.86 % Aaa / AA+ 1.20 1.75% Due 9/11/2015 0.38 % 585,407.80 0.23 % 3,021.18 (10,146.83) AAA 1.18 31398A4M1 FNMA Note 525,000.00 05/06/2013 541,779.00 101.71 533,973.30 2.64 % Aaa 1 AA+ 1.32 1.625% Due 10/26/2015 0.32 % 541,779.00 0.33 16 1,540.36 (7,805.70) AAA 1.31 31331J2S1 FFCB Note 375,000.00 02/27/2012 386,490.75 101.59 380,955.38 1.89 % Aaa / AA+ 1.38 1.5% Due 11/16/2015 0.66 % 386,490.75 0.34 % 703.13 (5,535.37) AAA 1.36 313371NW2 FHLB Note 1.375% Due 12/11/2015 600,000.00 11 /16/2012 0.39 % 617,928.00 617,928.00 101.52 609,118.80 3.01 % Aaa / AA+ 0.32 °% 458.33 (8,809.20) AAA 1.45 1.43 3135GOSBO FNMA Note 0.375% Due 12121/2015 490,000.00 11/26/2012 0.45 % 488,858.30 488, 858.30 100.11 0.30 % 490,533.12 51.04 2.42 % Aaa 7 AA+ 1.48 1,674,82 AAA 1.47 3133ECFV1 FFCB Note 0.43% Due 1/29/2016 3133EAJU3 FFCB Note 1.05% Due 3/28/2016 515,000.00 02/25/2013 514,902.15 100.07 515,341.45 2.55 % Aaa / AA+ 1.58 0.44 16 514,902.15 0.39 % 935.01 439.30 AAA 1.57 340,000.00 03/11/2013 346,079.20 101.16 343,943.66 1.70 16 Aaa / AA+ 1.75 0.46 16 346,079.20 0.38 16 922.25 (2,135.54) AAA 1.73 3135G0BA0 FNMA Note 2.375% Due 4/11/2016 3137EACT4 FHLMC Note 2.5% Due 5/2712016 375,000.00 02/24/2012 397,993.13 103.64 388,650.75 1.93 % Aaa / AA+ 0.86 % 397,993.13 0.32 16 1,979.17 (9,342.38) AAA 375,000.00 03120/2012 395,804.63 103.72 388,953.75 1.93 % Aaa / AA+ 1.14 °% 395,804.63 0.54 % 885.42 (6,850.88) AAA 1.78 1.74 1.91 1.87 3137EACW7 FHLMC Note 2% Due 8/25/2016 575,000.00 01/09/2013 604,762.00 0.56 % 604,762.00 103.01 592,309.23 2.95 % Aaa / AA+ 2.16 0.59 % 4,025.00 (12,452.77) AAA 2.10 31331V3Z7 FFCB Note 5.2% Due 9/15/2016 365,000.00 06/22/2012 430,134.25 0.88 °% 430,134.25 110.12 401,926.69 2.01 % Aaa / AA+ 2.21 0.58 16 5,588.56 (28,207.56) AAA 2.09 Chandler Asset Management - CONFIDENTIAL Page 4 Execution Time: 7/2/201411:50:43 AM 1 City of National City Ak Account #10162 Holdings Report As of 6/30/14 Purchase Date Cost Value Mkt Price Markel Value 'f oI Port. NlaadyFS8P Maturity CUSIP Security Description Par Value/Units Bank Y eld Book Value Mkt Trhtl Accrued Int. Galnitoss; Fitch Duration AGENCY 3137EADS5 FHLMC Note 0.875% Due 10114/2016 480,000.00 11/14/2013 0.64 % 483,316.80 483,316.80 100.65 0.59 % 483,121.92 898.33 2.39% Aaa/AA+ (194.88) AAA 229 2.26 313371PV2 FHLB Note 1.625% Due 12/9/2016 3135G0GY3 FNMA Note 1.25% Due 1/30/2017 480,000.00 02/29/2012 494,668.80 102.18 490,454.88 2.42 % Aaa / AA+ 2.45 0.97 % 494,668.80 0.72 % 476.67 (4,213.92) AAA 2.39 400,000.00 09/17/2012 409,328.00 101.25 405,003.60 2.01 % Aaa / AA+ 2.59 0.71 % 409,328.00 0.76 % 2,097.22 (4,324.40) AAA 2.53 3135G0UY7 FNMA Callable Note 1X 2/27/15 1% Due 2/27/2017 600,000.00 04/26/2013 605,766.00 0.74 % 605,766.00 100.36 602,172.00 2.98 % Aaa / AA+ 2.67 0.45 % 2,066.67 (3,594.00) AAA 1.63 3137EADCO FHLMC Note 1% Due 3/8/2017 535,000.00 08/20/2012 538,386.55 0.86 % 538, 386.55 100.34 536,844.68 2.66 % Aaa / AA+ 2.69 0.87 % 1,679.31 (1,541.87) AM 2.64 313379DD8 FHLB Note 565,000.00 03/14/2014 566,553.75 100.33 566,869.59 2.80 % Aaa /AA+ 2.98 1% Due 6/21/2017 0.91 % 566,553.75 0.89 % 156.94 315.84 AAA 2.92 3135G0MZ3 FNMA Note 545,000.00 08/15/2013 535,429.80 99.45 541,975.80 2.68 % Aaa / AA+ 3.16 0.875% Due 8/28/2017 1.32 % 535,429.80 1.05 % 1,629.32 6,546.00 AAA 3.10 3135G0TG8 FNMA Note 0.875% Due 2/8/2018 590,000.00 12/11/2013 1.31 % 579,757.50 579,757.60 98.63 1.26 % 581,933.52 2,050.66 2.88 % Aaa / AA+ 3.61 2.175.92 AAA 3.52 313378A43 FHLB Note 470,000.00 09/17/2013 464,472.80 1.375% Due 3/9/2018 1.65 % 464,472.80 100.32 471,508.23 2.34 % Aaa / AA+ 3.69 1.29 % 2,010.56 7,035.43 AAA 3.57 14,784,212.59 14,578,690.18 72.29 % Aaa / AA+ 1.77 Total Agency 14,385,000.00 0.68 % 14,784,212.59 0.47 % 57,968.95 (205,522.41) Aaa 1.69 MONEY MARKET FUND FI 60934N807 Federated Govt Oblig Fund Inst. 13,035.07 Various 13,035.07 1.00 13,035.07 0.06 % Aaa / AAA 0.00 0.01 % 13,035.07 0.01 % 0.00 0.00 AAA 0.00 Total Money Market Fund Fi 13,035.07 13,035.07 0.01 % 13,035.07 0.01 % 13,035.07 0.06 96 Aaa I AAA 0.00 0.00 0.00 Aaa 0.00 US CORPORATE 037833AH3 Apple Inc Note 0.45% Due 5/3/2016 0846708D9 Berkshire Hathaway Note 1 a% Due 1/31/2017 290,000.00 06/17/2014 289,428.70 99.79 289,383.17 1.43 % Aa1 / AA+ 1.84 0.56 % 289,428.70 0.57 % 210.25 (45.53) NR 1.83 285,000.00 06117/2014 291,429.60 102.41 291,858.81 1.45 % Aa2 /AA 2.59 1.02 % 291,429.60 0.95 % 2,271.29 429.21 A+ 2.50 91159HHD5 US Bancorp Callable Note Cont 250,000.00 05/19/2014 254,227.50 101.53 253,816.75 1.26 % Al / A+ 2.88 4/15/2017 1.07 % 254,227.50 1.09 % 527.08 (410.75) AA- 2.72 1.65% Due 5/15/2017 166764AA8 Chevron Corp. Callable Note Cont 1115/17 1.104% Due 12/5/2017 260,000.00 05/19/2014 259,703.60 1.14 % 259.703.60 99.54 258, 804.78 1.28 % Aa1 / AA 3.44 1.24 % 207.31 (898.82) NR 3.35 1,094,789.40 Total US Corporate 1,085,000.00 0.94 % 1,094,789.40 0.95 % 1,093,863.51 5,42 % Aa2 / AA 2.66 3,215.93 (925.89) A+ 2.58 Chandler Asset Management - CONFIDENTIAL Page 5 Execution Time: 7/2/2014 11:50:43 AM City of National City Account #10162 Holdings Report As of 6/30/14 CUSIP Security Description Par Value/Volts Purchase pate Cost Value Mkt Price Market Value % of Fart Moody/S&P Maturity Bash `Field book Yakio Mkt YTM Aceruad Errt GainrLows Fitch Duration US TREASuftY 912828LK4 US Treasury Note 2.375% Due 8/31/2014 912828MZ0 US Treasury Note 2.5% Due 4/30/2015 912828TD2 US Treasury Note 0.25% Due 7/15/2015 912828TK6 US Treasury Note 0.25% Due 8115/2015 470,000.00 420,090.00 535,000.00 520,000.00 02/24/2012 0.39 % 02/24/2012 0.49% 10/15/2013 0.31 % 134/29/2013 0.25 % 493,244.54 493,244.54 446,612.34 446,612.34 534,416.64 534,416.64 520,022.05 520,022.05 100.38 471, 780.83 2.35 % Aaa IAA+ 0.12 % 3,730.94 (21,463.71) AAA 0.17 0.17 102.00 428,383.62 2.12 % Aaa I AA+ 0.83 0.11 % 1,769.02 (18,228.72) AAA 0.83 100.10 535,522.70 2.65 % Aaa / AA+ 1.04 0.16 % 617.02 1,106.06 AAA 1.04 100.09 520,487.76 2.57 % Aaa 1 AA+ 1.13 0.17 % 488.40 465.71 AAA 1.12 912828PE4 US Treasury Note 1.25% Due 10/31/2015 435,000.00 02/24/2012 445,434.66 4.59 % 445,434.66 101.41 441,116.97 2.18 % Aaa / AA+ 1.34 0.19 % 916.10 (4,317.69) AAA 1.32 912828UM0 US Treasury Note 0.375% Due 2/15/2016 500,000.00 11/14/2013 0.36 % 500,216.52 500,216.52 100.12 500,586.00 2.48 % Aaa / AA+ 1.63 0.30 % 704.42 369.48 AAA 1.62 9128280A1 US Treasury Note 2.25% Due 3/31/2016 500,000.00 12/14/2012 533,431.36 0.38 % 530,431.36 103.30 516,504.00 2.56 % Aaa / AA+ 1.75 0.36 % 2,827.87 (13,927.36) AAA 1.72 912828RF9 US Treasury Note 1%Due 8/31/2016 570,000.00 10/12/2012 581,357.38 0.48 % 581,357.38 101.03 575,877.84 2.85 % Aaa 1 AA+ 2.17 0.52 % 1,905.16 (5,479.54) AAA 2.14 912828SY7 US Treasury Note 0.625% Due 5/31/2017 500,000.00 03/14/2014 496,290.74 0.86 % 496,290.74 99.34 496,679.50 2.45 % Aaa /AA+ 2.92 0.86 % 264.69 388.76 AAA 2.88 Total US Treasury 4,450,000.00 0.45 4,548,026.23 4,548,026.23 0.32 % 4,486,939.22 22.23 % Aaa 1 AA+ 1.47 13,223.62 (61,087.01) Aaa 1.45 20,440,063.29 29,172,527.98 100.00 % Aaa I AA+ TOTAL PORTFOLIO 19,933,035.07 0.64 % 20,440,063.29 0.47 % 74,408.50 (267,535.31) Aaa 1.75 1.68 TOTAL. MARKET VALUE PLUS ACCRUED 20,246,936.48 Chandler Asset Management - CONFIDENTIAL Page 6 Execution Tune: 7I2/201411:50:43 AM County of San Diego Treasurer Investment Report MONTH EN June 30, 2014 COUNTY OF SAN DIEGO TREASURER TAX COLLECTOR Leading the way Participant Cash Balances PARTICIPANT FMV FMV FMV % of 04/30/14 05/31/14 06/30/14 Total San Diego Pooled Money Fund as of June 30, 2014 ($000) COUNTY COUNTY - SPECIAL TRUST FUNDS NON -COUNTY INVESTMENT FUNDS SCHOOLS (K THRU 12) COMMUNITY COLLEGES San Diego Grossmont Mira Costa Palomar Southwestern Total Community Colleges SDCERA SANCAL MTDB SANDAG CITIES Chula Vista Del Mar Encinitas National City INDEPENDENT AGENCIES Alpine FPD Bonita Sunnyside FPD Borrego Springs FPD Deer Springs FPD Fallbrook Public UtI Public Agency Self Insurance System Julian-Cuyamaca FPD Lake Cuyamaca Rec & Park Lakeside Fire Leucadia Water District Lower Sweetwater FPD $1,627,739 1,882,521 311,450 3,226,620 $1,000,845 1,893,275 305,388 3,183, 936 $ 684,874 1,983,100 248,594 2,935,419 439,487 425,516 399,106 117,764 117,370 116,196 34,355 36,082 26,789 130,123 120,564 120,564 148,561 146,110 144,050 870,290 845,643 806,705 4,585 629 763 35,091 34,049 33,455 5,759 703 703 59,344 57,793 57,701 39,280 39,139 39,099 3,030 3,019 3,416 2 2 2 5,027 5,009 5,004 1,263 1,530 1,383 4,795 4,835 5,075 1,361 1,533 1,071 6,689 7,589 7,63D 14 14 14 4,228 4,213 4,020 95 174 186 409 396 383 8,390 8,700 8,295 11,360 11,320 11,308 411 442 448 9.43% 27.31% 3.42% 40.42% 5.50% 1.60% 0.37% 1.66% 1.985k 11.11 % PARTICIPANT FMV FMV FMV %of 04/30/14 05/31/14 06/30114 Total Metropolitan Transit System Majestic Pines CSD Mission Resource Conservation District North County Cemetery District North County Cemetry Perpetual North County Cemetery North County Dispatch North County Fire Otay Water District investment Palomar Resource Conservation District Pine Valley FPD Pomerado Cem Perpetual Pomerado Cemetery District Ramona Cemetery District Ramona Cemetery Perpetual Rancho Santa Fe FPD San Diego Housing Commission San Diego Rural Fire San Dieguito River San Marcos FPD San Miguel FPD San Ysidro Sanitation Santa Fe Irrigation District SDC Regional Airport Authority So County OPS Center Spring ValleylCasa de Oro Upper San Luis Rey Reservoir Vallecitos Water District Valley Center FPD Valley Cntr Cemetery Valley Ctr Cem Perpetual Valley Ctr Water District Vista FPD 5,186 0 424 1,126 1,259 1,648 3,162 3,816 21,216 0 501 0 1,683 612 352 13,300 9,995 7 11 1 7,579 13 4,921 357,146 0 0 19 5,080 4,268 51 231 16,500 2,135 4,425 0 425 1,161 1,268 1,679 3,072 2,948 21,140 0 523 0 1,699 614 351 13,910 9,959 352 -30 1 9,859 13 4,903 332,711 0 0 20 5,062 4,630 49 230 17,701 2,127 3,982 0 425 1,197 1,278 1,662 2,839 1,873 17,143 0 497 0 1,711 597 350 13,455 9,949 36 -108 1 6,578 13 4,898 326,410 0 0 20 5,057 4,559 50 232 17,289 2,125 Total Independent Agencies 653,394 621,890 603,673 8.3159 Pooled Money Fund Total 3 8,571, 014 37, 850,976 $ 7,262,365 100.00% COUNTY OF SAN DIEGO TREASURER - TAX COLLECTOR 17 -IS Investments City of National City Portfolio Management Portfolio Summary June 30, 2014 Par Market Value Value Book % of Value Portfolio City of National City Days to YiMJC YTMfC Term Maturity 360 Equiv. 365 Equiv. LAIF Federal Agency Securities Investments Total Earnings 37,468,679.22 37,479,772.96 37,468,579.22 98.68 1 1 0.241 0.244 500,000.30 609,585.00 500,000.00 1.32 1,826 413 1.973 2.000 37,968,579.22 37,989,357.96 37,968,579.22 i00.00% 25 6 0.263 0.267 June 30 Month Ending Current Year Average Daily Balance Effective Rate of Return 8,715.24 37,968,579.22 0.28% Mark Roberts, Director of Finance Reporting period 0610412014.06I30f2014 Run Date: 08421f2014 - 11:12 No fecal year history avaiabie Portfolio CNC CC PM (PRF_.PM1) SymRepr & 41.202b Report Ver. 5.00 City of National City Portfolio Management Portfolio Details - Investments June 30, 2014 Page 2 Average Purchase Stated YTAMC Days to Maturity CUSIP Investment N Issuer Balance Dale Par Value Market Value Book Value Rate S&P 365 Maturity Bate LAIF 98-37-576 11058 Local Agency Investment Fund 37,468,579.22 37,479,772.96 37,468,579,22 0.244 0.244 1 Subtotal and Average 37,466,579.22 37,468,679.22 37,479,772.96 37,468,579,22 0.244 1 Federal Agency Securities 3136FPAB3 11362 Federal Nail_ Mortgage Assoc, 0811812010 500,000.00 509,585.00 500,000.00 2.000 AAA 2.000 413 0811812015 Subtotal and Average 600,000.00 500,000.00 504,585.00 600,000.00 2.000 413 Total and Average 37,968,579.22 Run rate: 0812112014 - 11:12 37,968,579.22 37,989,367.96 37,966,579.22 0.267 6 Portfolio CNC CC PM ZPRF PM2) SymRept 6.41.202b