The URL can be used to link to this page

Home My WebLink About2012/12/11 Item 18CITY COUNCIL AGENDA STATEMENT ~~{~~ CITY OF `~' CHULAVISTA DECEMBER 11, 2012, Item ITEM TITLE: INVESTMENT REPORT FOR THE QUARTER ENDED SEPTEMBER 30, 2012 SUBMITTED BY: DIRECTOR OF FIN CE/TREASURER-~~Y~'~ REVIEWED BY: CITY MANAGE ASSISTANT CITY NAGER S~ - - 4/STHS VOTE: YES ~ NO ^X SUMMARY_ Transmitted herewith is the City's investment report for the quarter ended September 30, 2012. To meet the reporting requirements set forth in the California Govenunent Code Sections 53600 et seq. and 53646 and the City of Chula Vista Investment Policy (Council Policy No. 220-01), a separate report was distributed to the City Council in October: ENVIRONMENTAL REVIEW The Environmental Review Coordinator has reviewed the proposed activity for compliance with the California Environmental Quality Act (CEQA) and has determined that the activity is not a "Project"~ as defined under Section 15378 (b)(4) of the State CEQA Guidelines; therefore, pursuant to Section 15060(c)(3) of the State CEQA Guidelines the activity is not subject to CEQA. Thus, no environmental review is necessary. RECOMMENDATION Council accept the report. BOARDS/COMMISSION RECOMMENDATION Not applicable. DISCUSSION The total cash and investment portfolio held by the City as of September 30, 2012 was $191,652,165. This is a decrease of approximately $23.4M from June 30, 2012 to September 30, 2012. This is primarily due to the fact that only a small portion of the City's major revenues such as property orsales tax are received during this quarter compared to the other quarters. For the quarter ended September 30, 2012, the earned interest yield was 0.778%, a slight decrease from the 0.784% reported for the quarter ended June 30, 2012, reflecting reinvestment in lower yielding investments. The weighted average maturity as of September 30, 2012 was 1.96 years, la-~ DECEMBER 11, 2012, Item Ig Page 2 of 2 an increase from the 1.93 years in the prior quarter. The weighted average maturity remaihs. .sufficiently liquid to enable the City to meet all operating requirements which might be reasonably anticipated. DECISION MAKER CONFLICT Staff has determined that the action contemplated by this item is ministerial in nature and does not require'the City Council members to make or participate in making a governmental decision, pursuant to California Code of Regulations section 18702.4(a). Consequently, this item does not present a conflict under the Political-Reform Act (Cal. Gov't Code § 87100, et seq.). Staff is not independently aware, nor has staff been informed by any City Council member, of any other fact that may constitute a basis for a decision maker conflict of interest in this matter. , CURRENT YEAR FISCAL IMPACT Considering the projected timing of cash receipts and disbursements -and the structure of the Pooled Investment Portfolio, the City should be able to comfortably meet overall cash flow needs over the next six months. There is no direct fiscal impact by this action. ONGOING FISCAL IMPACT There is no ongoing fiscal impact by this action. ATTACHMENTS A. Investment Report for the Quarter Ended September 30, 2012 Prepared by: E. Adachi, AssociateAccotintant, FinanceDept. j 18-2 II ~~~~ .~. ____~ CITY OF CHULAVISTA Finance Departm Investment Report for the Quarter Ended September 30, 2012 November 26, 2012 Honorable Mayor and City Council, I am pleased to present this report of investment activity for the quarter ended September 30, 20.12 in compliance with the reporting requirements as set forth in the California Government Code Sections 53600 et seq. and 53646 and the City of Chula Vista Investment Policy. The information presented in this report highlights the investment activity for.the quarter ended September 30, 2012 as well as provides a comparison to the quarters ended June 30, 2012 and September 30, 2011. Market Overview The Federal Open Market Committee (FOMC) continues to maintain the key Fed Funds rate at a target range of 0.00% to 0.25% in hopes of stimulating the economy. Two-year Treasuries yielding 0.30% at the beginning of the quarter ended lower at 0.23% at the end of the quarter. The overal6 consumer price index (CPI) rose 2.0% on ayear-over-year basis, and the core CPI (excluding food and energy) showed a 2.0% increase year-over-year indicating that inflation remains under control. Portfolio Composition The table below provides a summary of the City's total investment portfolio as of September 30, 2012. The Investment Portfolio ($170,143,197), Cash/Time Deposits ($21,508,968) and Bank Trustee/Fiduciary .Funds . ($77,752,565) continue to be invested in accordance with the Government Code, bond covenants and the Council Investment Policy as adopted on March 13, 2012. 18-3 Investment Report Quarter ended 09/30/2012- Page 2 of 4 Summary of Cash and Investments as of September 30, 2012 Investment Type Par Value Market Value Book Value Portfolio Investment Portfolio • Federal Securities 97,000,000 97,293,875 97,000,000 36.01% Pooled Investments 73,143,197 73,183,475 73,143,197 27.15%.. Corporate Bonds 0 0 0 0.00% - Subtotal 170,143,197 170,477,350 170,143,197 63.16%• Cash/Time Deposits $21,508,968 .$21,508,968 $21,508,968 - 7.98% Total Cash & Investments Held by the Citv $191,652,165 $191,986,318 $191,652,165 71.14% Held by Bank Trustee/Fiduciary Funds (1) U. S. Government - 2,021,563 2,052,960 2,021,563 0.75% Repurchase Agreement - ~ 0.00% Investment Agreements* 14,577,627 14,577,627 14,577,627 5.41% Mutual Funds* ~ 58,215,795 58,215,795 58,215,795 21.61% - Cash with Fiscal Agents 25,312 ~ 25,312 25,312 0.01°/0 Restricted Cash. 2,912,269 2,912,269-- 2,912,269 1.08% Total Held by Bank Trustee/Fiduciary Funds $77,752,565 ~ $77,783,962 $77,752,565 28.86% Totah Portfolio .$269,404,729 .$269,770,280 $269,404,729 100.00% (1) Reflects bond proceeds held by trustee in accordance with bond covenants. The graph below provides a snapshot of the portfolio composition by investment type for that portion of the portfolio not held by the bank trustee or in a fiduciary fund. Portfolio Composition as of September30, 2012 J US Govern Agency 57% 0.6% LAIF (State Pool) 19% >I - 18-4 Investment Report Quarter ended 09/30/2012 Page 3 of 4 .• Portfolio Performance Portfolio performance is'provided in more detail in the attachments to the report. The summary information provided below includes the-total portfolio income recognized for the last quarter as compared to the prior quarter and the same quarter one year ago. Total Portfolio Income Recognized Accrual Basis • Sep tember 30, 2012 June 30, 2012 Se ptember 30, 2011 ..Quarter-End ,Net Interest Earnings $ 375;376 $ 413,894 $ 567,170 Net Gains (Losses) from Sales $ - $ 1 300 $ - Net Total Income Recognized $ 375 376 $ 415 194 $ 567 170 Fiscal Year-to-Date Net Interest Earnings $ 375,376 $ 1,969,009 $ 567,170 • Net Gains (Losses) from Sales $ - $ 7 040 $ - NetTotallncomeReco~nized $ 375,376 $ ..1,976,049 $ _ 567,170 This table 'shows the City's average yield to maturity as of September 30, 2012 as compared to the County of San Diego and other cities in the, county. Carlsbad and Oceanside both have dedicated staff that actively manage their portfolios by buying and sellirig investments daily as opposed to our more passive "hold-to-maturity" investment style. Liquidity needs and risk tolerance cari also affect yields. Benchmark Comparison gent Yield Chula Vista 0.78% County of San Diego 0.37% Carlsbad 1.27% EI Cajon 0.77% Oceanside 1.06% San Die o 0,71% The following graph compares the monthly earned interest yield of the City's Portfolio-Fund with the monthly average yields for the same period of the State of California Local Agency Ihvestment Fund (LAIF) and the two-year and three-year treasury from September 2010 through September 2012. zoi psi ,oi o.sv o.oi "Monthly Benchmark Comparison soaio o®o-io mar-~i a....ni saa-+~ oe<-» ma.-~z ~~.,-iz sap- ~~. I 18-5 Investment Report Quarter ended 09/30/2012 Page 4 of 4 Per Section 16.1 of the City's Investment Policy, the two- .'year U.S. Treasury and the Local Agency Investment Fund yields are the performance benchmarks to be used when determining ,whether market yields are being achieved. The three-year U.S. Treasury is added as an additiorial point of reference in order to provide an upper range that is above the weighted average maturity of the City's portfolio, which is at 715 days. Investment Activity Benchmark"#~- ~aYi le d ~AQM ``` City 0.78% 715 LAIF 0.36% 242 2 Year Treasury 0.23% 730 3YearTreasur 0.31% 1,095 ADM =Average Days to Maturit During. the quarter, eight investments totaling $25,000,000 were redeemed by the issuers prior to their maturity dates, and three (two in July, one in. September) Federal Agency Securities totaling $9,000;000 were purchased using the City's Investment Policy guideline to ensure safety, liquidity and yield. These monies represent pooled ,cash received from various funding sources such as sewer, TDIF,' PAD, General Fund, etc. There is no further activity to report on other than .routine investments in money market mutual funds by the City's fiscal agents. Conclusio'n' The total cash and investment portfolio held by the City as of September 30, 2012 was $191,652,165. This is a decrease of approximately $23.4M from June 30, 2012'to September 30, 2012. This is primarily due to the fact that only a small portion of the City's major revenues such as property or sales tax are received during this quarter compared to the other quarters. For. the quarter ended September 30, 2012, the earned interest yield was 0.778%, a slight decrease from the 0.784% reported for the quarter ended June 30, 2012, reflecting higher yielding investments being redeemed and then reinvested at lower interest rates. The weighted average maturity as of September 30, 2012 increased from the previous quarter's 1.93 years to 1.96 years which is within the Council Policy of less than 3.0 years. The weighted average maturity remains sufficiently liquid to enable the City to meet all operating requirements that might be reasonably anticipated. Considering the projected timing of cash receipts and disbursements and the structure of the Pooled Investment Portfolio, the City should be able to comfortably meet overall cash flow needs over fhe next six months. There is no direct fiscal impact by this action. I certify that this report reflects the City of Chula Vista and related agencies pooled investments and. is in conformity with the State of California Government Code on authorized investments and. with the Investment Policy of the City of Chula Vista as stated in 'Resolution No. 2012-034 dated March 13, 2012. Respectfully. subm fitted, Maria Kachadoorian Director of Finance/Treasurer 18-6 ~`~ ~/ ~' .~ ~.~.~- CITY OF CHULAVISTA Investments Managed Pool ACCOUntt Managed PootAccount3 Managed Pool ACCOUn[2 Federal Agency Coupon Securities Federal Agency Callables Total Earnings ~eptem Current Year Average Daily Balance ~'1 E~ctive Rate of Return~J~ ~~/~ / - i r Phillip A. Davis, Assistant Director of Finance "Chula Vista )nvestment Pool Portfolio Management Portfolio Summary September 3Q, 2012 Par Market Book % of Days to Value Value Value Portfolio Term Maturity 33,024,640.73 33,064,919.00 33,024,640.73 19.41 1 1 39,105,956.17 39,105,956.17 39,705,956.17 22.98 1 b 1012,599.61 1,012,599.61 1,012,¢99.61 0.60 1 1 6,000,000.00. ~ 8,007,575.00 6,000;000.00 3.53 1,096 579 91,000,000.00 - 91,286,300.00 91,000,000.00 53.48 1,542 1,298 170,143,196.51 170,477,349.78 ~ 170,143,196.51 100.00% 864 715 30 Month Ending Fiscal Year To Date 118,874.25 ~ 375,375.73 179,009,863.18 187,732,188.52 0.81 % 0.79% City of Chula Vista 276 Fourth Ave Chula Vista CA 91910 (619)691-5250 YTM 0.348 0.370 0.380 1.050 1.096 0.778 Reportingperiod 09101/2012-0913012012 _ ~ Podfolio CHUL CC Run Date'1011712012 - 7 4'.46 ~ PM (PRF_PM1)SymRept 6.41.202b ' ~ Report Ver. 5.00 Chula Vista Investment Pool , Portfolio Management - gage z Portfolio Details -.Investments September 30,.2012 Average purchase ~ Stated .Days to YTM Maturity CUSIP Inves[ment# Issuer Balance - Date ~ Par Value - Market Value Book Value 'Rate .Term Maturity Dale Managed Pool Account 1 ~ . SY510197 10197 Local Agency Investment Fund - 33,024,fi40.73 33,064,919,00 33,024,640.73 0.348 1. 1 0.348 • - Subtotal and Average 33,024,640.73 ~ 33,024,640.73 33,064,979.00 33,024,640.73.. ~ 1 1 0.348 Managed'POOI Account3 S1 5 10547 San Diego County Inv Pool 39,105,956.17 39,105,956.17 39,105,956.17 0.370 1 1 0.370 ' 0 SY 47 Subtotal antl Average 39,105,956.17 39,105,956.17 39,105;956.17 39,105,956.17 ~ 1 1 0.370 . Managed Pool Account2 - 10507 CalTrust SHort Term Fund 1,012,599.61 ~ 1,012,599.61 1,012,599.61 0.380 1 1 0.380 SY510507 Subtotal and Average 1,012,599.61 1,012,599.61 1,012,599.61 1,012,599.61 1 1 0.380 Federal Agency Coupon Securities 3133XV6U0 10542 Federal Home Loan Bank 10/A9/2009 ~ 2,000,000.00 2,000,700.00 2,000,000.00 1.750 .1,096 6 1.750 10!09/2012 3 Federal Home Loan Mortgage Co 02/13/2012 4,000,000.00 4,006,875.00 - 4,000,000.00 0.700 1,096 665 0.700 02/13/2015 31~3LD0 1067 . oo. ~ Subtotal and Average 6,000,000.00 6,000,000.00' 6,007,575.00 6,000,000.00 1,096 579 1.050 Federal Agency Callables 3136FTHC6 10658 Federal Nal'I Mtg. ASSOC. 10/26/2011 3000,000.00 3,001,050.00 3,000,000.00 1.000 1,188 847 1.000 01/28/2015 8 10675 Federal Home Loan Modgage Co. 02/13/2012 3,000,000.00 3,011,370.00 3,000,000.00 0.550 1,096 865 0.550 02/13/2015 3134G3MR 10680 Federal Home Loan.MOrtgage Co. 02/24/2012 - 4,000,000.00 .4,005,920.00 - 4 000,000.00 0.500 1,096 ,876 0.500 02/24/2015 3134G3NL0 10657 Federal NafLMtg. Assoc. 10/28/2019' 3,000,000.00 3,001,650.00 3,000,000.00 1.100 1,279 940 1.100 04/29/2015 3136FTHL6 10628 Federal Home Loan Bank 06/10/2017 3,000,000.00 3,027,300.00 3,000;000.00 1.700 ' 1,461 982 1.700 06110/2015 313373VH2 tO6fi7 Federal Home Loan MortgageCO. 12/30/2011 3,000,000.00 3;019,740.00 3,000,000.00 1.000 1,278 1,002 1.000 06/30/2015 3134G3EB2 10670 Federal Home Loan Mortgage Co. 01/3072012 3,000,000.00 3,005,940.00 3,000,000.00 0.840 1,277 1,032 0.840 07/30(2015 3134G3JY7 10679 Federal Farm Credil Bank ~ 02/10/2012 3,000,000.00 3,000,060.00 ,' 3,000,000.00 0.590 1,277 1,043 0.590 08/10/2015 3133EACY2 10647 Federal Naf6Mtg. Assoc. 09/09/2011 3,000,000.00 ' 3,015,300.00 3,000,000.00 1.000 1,461 1,073 1.000 09/09/2015 3136PRX73 10655 Federal Farm Credit Bank 10!19/2011 3,000,000.00 3,001,320.00 3,000,000.00 1.290 1,461 1,113 7.290 10/19/2015 31331KG61 10660 Federal Home Loan Mortgage Co. 11/76/2011 3,000,000.00 3,002,940.00 3,000,000.00 1.250 1,461 1,141 1.250 11/16/2015 3134G24U3 10663 Federal Home Loan Mortgage Co. ~ 11/23/2011 3,000,000.00 3,002,880.00 3,000,000.00 1.125 ~ 1,461 1,148 1.125 11/23/2015 3134G25H1 ' 10665 federal Farm Credit Bank 12/07/2011 4,000,000.00 4,006,320.00 4,000,000.00 1.330 1,461 7,162 1'.330 12/07/2015 31331KZ29 10684 Federal Nome Loan Mortgage Co. . 12/14/2011 3,000,000.00 3,004,890.00 3,000,000.00 7.250 1,461 1,169 1.250 12/14/2015 3134G3BZ2 10868 ~ Federal Nal'I Mtg. Assoc. 12/28/2011 3,000,000.00 _ 3,005,010.00 3,000,000.00 1100 7,461 1,183 7.700 12/28/2015 3136FTXDG 10669 Federal Farm Credit Bank 01/71/2012 3,000,000.00 3;006,420.00 3,OOA,000DO 1.020 1,461 1,197 1.020 01/11/2016 31331 KST3 10687 Federal Nat'I Mtg. Assoc Ofi/04/2012 4,000,000.00 _ 4,010,520.00 4,000000.00 0.950 1,460 1,341 0.950 06/03/2016 3136GOJR3 10672 Federal Home Loan Modgage Co. 01/27/2012 3,000,000.00 3,024,240.00 3,000,000.00 - 1.100 1,643 1,395 1.100 07/27/2016 3134G3KK5 10649 Federal Nat'I.Mtg. Assoc. 09/20/2011 3,000,000.00 3,036,600.00 3,000,000.00, 1.420 1,827 1,450 1.420 09/20/2016 3136FRX57 - Portfolio CHUL CC ' Run Dale: 1 011712012-1 4:46 ~ ~ ~ PM (PRF_PM2) SymRep16.41.202b Report Ver. 5.00 Chula Vista Investment Pool . Portfolio Management Portfolio Details -Investments September 30; 2012 Page 3 Average purchase Statetl Days to YTM Maturity CUSIP ~ Investment# Issuer Balance Date Par Value Market Value BookValue Rate Term Maturity Date Federal Agency Callables -- 31331KL24 10656 FederalFarm Credit Bank 10/26/2011 ~ 3,000,000.00 3,003,030.00 3,000,000.00 1.540 1,827 1,486 1.540 10/2612016 31331 K6Y1 10671 Federal Farm Credit Bank 01/18/2012 3,000,000.00 3,010,830.00 3,000,000.00 1.270 1,827 1,570 1.270 01/18/2017 3136FTK73 1067fi Federal.Nat'I Mlg. Assod. 02/22/2012 3,000,000:00 3,015,150.00 3,000,000.00 1.375 1,827 1,605 1.375 02/22/2017 3136FTP52 10681 Federal Nafl Mtg. Assoc. 0212612012 3,000,000.00 3,007,890.00 3,000,000.00 1.100 1,827 1,611 1.097 02/28/2017 3136GOJX0 10605 Federal Nat'I Mtg. Assoc. 05/30/2012 4,000,000.00 4,015,920.00 4,000,000.00 1.250 1,826 1,702 1.250 05/30/2017 3134G3XE5 ' 10689 'Federal Home Loan Mortgage Co.~ 06/07/2012 3,000,000.00 3,009,570.00 3,000;000.00 1.150 1,826 1,710 1.150 06/07/2077 . 3135GOMN0 10690 Federal Nat'I Mtg. Assoc. 06/2812012 3,000;000.00 3,013,680.00 3,000,000.00 1.125 1,826 1,731 1.125 06/28/2017 3133EAVJYO 10691 Federal Farm Credit Bank 07/10/2012 3,000,000.00 3,011,970.00 3,000,000:00 1.040 1,826 1,743 1.040 07/10/2017 3134G3YZ7 10692 Federal Home Loan ModgageCo. 07/25/2012 3;000,000.00 3,005,280.00 3,000,000.00 1.100 1,826 1,758 1.100 07/25/2017 3133EAY28 10694 Federal Farm Credit Bank 09/21/2012 3,000,000.00 3,003,510.00 3,000,000.00 0.830 ~ 1,828 1,816 0.830 09/21/2017 Subtotal antl Average 99,666,666.67 91,000,000.00 91,286,300.00 -91,000,000.00 1,542 1,298 1.096 Total and Average 179,009,863.18 170,143,196.51 170,477,349.78 170,143,196.51 864 715 0.770 DD ' - - CD - - ~ Portfolio CHUL CC Run Data: 1 01171201 2-14:46 _ ~ PM (PRF_PM2)9ymRept 6.4t202b Chula Vista Investment Pool Portfolio Management Activity By Type Page a September 1, 2012 through September 30, 2012 - Stated Transaction Purchases Redemptions CUSIP Investment# Issuer - ~ -Rate ^ate - or Deposits or Withtlrawals Batarice Managed Pool Account 1 (Monthly Summary) - - Subtotal ~ - - 33,024,640.73 ManagedPool Account 3 (Monthly Summary) ~. ~ - - ' Subtotal 39,105,956.17 Managed Pool Account 2 (Monthly Summary) - - - - Subtotal ~ ' 1,012,599.61 Federal Agency Coupon Securities ~ - _ ~ - - Subtotal - ' 6,000,000:00 Federal Agency Callables - - - - 31331JH55 ~ 10595 Federal Farm Credit Bank '- - 1,875 _ 09/21/2012 0.00. 3,000,000.00 - 31333KZL7 10651 Federal Farm Credil Bank 1.020 09!20/2012 0.00 3 000 000 00 313~SR0 10688 Federal Farm Credil Bank - 0.850 09/2712012 ~ 0 00 , , . - ~ . 4,000,000.00 3133~Y29 10694 Federal Farm Credit Bank - 0.030 09/21/2012 3,000,000.00 0.00 313C~AK5 10853 Fetleral Nafl Mlg. Assoc. 1.000 09/28/2012 0 00 ~ 3 000 000 00 Subtotal - Total ' 3,000,000.00 13,000,000.00 - 91,000,000. 00 3,000,000.00 -, 13,000,000.00 170,143,196. 51 I un pale: i6/19/2012-14:46 ' Ponfolio CHUL CC ' PM (PRF_PM3)SymRept 6,g7.202b .. ~ - RePOrt Ver 5.00 • Chula Vista Investment Pool ' Portfolio Management '. • . Activity Summary Pages September 2011 through September 2012, ~:- - - Yieltl to Maturity - - Month Number of ~ Total Managed 360 365 Number Number End Year Securities Invested Pool of Equivalent Equivalent Rate Investments Purchas d of Investments R _ Average Average . e edeemed - Term Dayslo Maturity September 2011 44 166,541,104.47 1.191 1.208 ' 0 378 8 October 2011 45 166,591,129.67 . 1.190 ~ 1.207 0 385 4 7 1,045 930 November ~ .2011 47 160,591,129.67 . ~ 1.239 1 257 ~ 0.401 3 1 082 957 - December 2011 46 173,595,859.09 . 1.105 .1.121 0 382 - 5 5 3, - 1,188 - 1,045 January ~ 2012 47 203,135,286.16 . 0.990 1.003 0 385 _ 4 6 1,088 959 February 2012 52~ 199,136,296.74 . 0.968 0.982 0 389 10 -3 943 819 March 2012 48 184,136,296.74 ~ . 0.965 0.979 0 383 ~ 0 5 - 1,058 g29 .April 2012 ~ - 45 187,184,426.85 . D.881 0.893 0 367 0 4, t,D45 894 May 2012 ~ 41 186,984,426.85 . 0.840 0.851 0 363 1 3 958 ~ 874 June 2012 39 202,985,726.85 . 0.773 0.784 0 358 5 5 893 746 - July 2012 38 - 190,143,196.54 . 0.787 ~ 0.798 0 363 2 7 ~ 822 ~ 706 August 2D12 ~ 37 180,143,196.51 . 0.795 0.806 0 377 0 3 880 750 September 2012 34 170,143,196.51 . 0.767 0.778 0 348 1 1 899 749 - . ~ 4 864 715 ~ _ Average q3 182,408,559.43 -0.961% 0.974°/ 0 375 3 ~ . 4 ~ 982 ~ 847 - ~ Portfolio CHUL un Oale: 1011 7/2 0 7 2-14:46 - - ~ _ - CC ' ~ ~ ~ ~ PM (PRP_PM4) 6ymRepf 6.41.2026 ' - Report Ver. 5.00 Chula Vista Investment Pool Portfolio Management Page s Distribution of Investments By Type September 2011 through September 2012 . September October November December January February March Aprll ~ May June July August September Average Security Type 2011 2011 2011 2011 - 2012. 2012 2012 2012 2012 2012 2012 2012 2012 by Periotl Managed Pool Account 1 22.5 17.7 10.3 17.6. 23.7 13.6' . 14.2 20.4 ~ 26.7 24.6 21.1 18.3 19.4 19.2% Short Term Pool Accounts - Managed Pool Account 3 ~ ~ 3.0 ~ 6.0 6.3 5.8 9.9 10.1 10.9 10.7 10.7 19.3 20.6 . 21.7 23.0 12.2% Managed Pool Account 2 0.6 0.6 - 0.6 0.6 0.5 0.5 0.6 ~ 0.5 0.5 0.5 _ 0.5 0.6 0.6 •0.8% Federal Agency Coupon Securities 1.2 1:2 1.3 1.2 1.0 3.0 3.3 3.2 3.2 3.0 3.2 3.3 3.5 2.4% Federal Agency Callables 70.3 72.0 79.1 73.7 64.0 71.8 70.1 . 64.1 57.8 52.7 54.7 56.1 53.5 64.6% Corporate Coupon Bonds 2.4 2.4 2.5 1.2 1.0 1.0 1.1 1.1 1.1 1.1 oD J N 1 Run Dala: 1011712012-14:46 Portfolio CHUL CC PM (PRF_PMS) SymRept 6.41.2025 Report Ver. 5.00 Chula Vista Investment Pool Portfolio .Management. Page 7 Interest Earnings Summary September 30, 2012 Sepfemher 30 Month Ending Fiscal Year io Dake - ' CDICoupon/Discountinvestments: .Interest Collected ~ ~ - ~ 97;708.33 328,593.33 Plus Accrued Interest at End of Period 267,615.83 267,615.83 less Accrued Interest at Beginning of Period ( 268,236.10) ( 293,356.10) Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period 97,088.06 302,853.06 Adjusted by Capital Gains or Losses 0.00 ~ 0.00 - Earnings during Periods ~ ~ 97,088.06 302;853.06 . Pass Through Securities: Interest Collected 0.00 0.00 - Plus Accrued Interest at End of Period 0.00 0.00 - ~ - ~ Less Accrued Interest at Beginning of Period ( 0.00) ( O.OOj ~ _ I Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) " W ~ Interest Earned during Period ~ 0.00 0.00 Adjusted by Premiums and Discounts 0.00 0.00 Adjusted by Capital Gains or Losses 0.00 0.00 Earnings during Periods D.00 0.00 _ Cash/Checking Accounts: Interest Collected 0.00 57,469.66 Plus Accrued Interest at End of Period 84,560.11 84,560.11 Less Accrued Interest at Beginning of Period - ( 62,773.92) ~. ,( ~. 69,507.10) InteresLEamed during Period 21,786.19 72,522.67 Total Interest Earned during Period 118,874.25. 375,375.73 Total Capital Gains or Losses 0.00 - 0.00 . Total Earnings during Period. ~ .118,874.25 375,375.73' Portfolio CHUL CC Run gate: 1011]2012-14:46 PM (PRF_PMfi)SymRept 6.4L2026 Report Ver. 5.00 ~«!~ . City of Chula Vista Chula•Vista Investment Pool z7s FourthAVe, ~ ~ _ - I~eCelVed Interest ~ ~ Chula Vista CA 91910. CIIYOF Sorted by Date Received -Grouped by Fund (s19js91-szso CHUTA VISTA Received September 9, 2092.- September 30, 2012 Security Par Current Interest _ ' Date Received CUSIP ~ Investment# .Type Value Rate Date Due Date,Received Amount Due Amount Received ~ Variance Fund: Chula Vista Investment Pool ~ , September 2012 3136FRX73 10647 - MC1 .3,000,000. DO 1.000 09/09/2012 00/01/2012 .15,000.00 15,000.00 _ - r OD A 3136FRX57 10649 MCi 3,000000.00 - 31331JH55 10595 MC1 0.00 3133FASR0 10666 - MC1 0.00 31331 KZL7 10651 MCt 0.00 3136FTAK5 10653 ~ MC1 0.00 Run Bate: 10/17/2012 -14:48 1.420 09/20/2012 09!20/2012 21,300.00 21,300.00 - ' 1.875 09121!2012 09/21/2012 28,125.00 28,125.00 0.850 09/27/2012 09/27/2012 10,483.33 10,483.33 1.020 09!28/2012 09/28/2012 .15,300.00 ~ - 15,300.00 1.000, 09/28/2012 0912812012 7,500.00 - 7,500.00 Subtotal 97,700.33, 97,708.33 Chula Vista Investment Pool Subtotal 97,700.33 97,708.33 - Total 97,708.33 97,708.33 ~ ~TOtal Cash Overpayment 0.00 Total Cash Shortfall 0.00 Portfolio CHUL CC RI (PRF_RO SymRept 6.41.202b Repod Ver. 5.00 ' `~~ ~~ ~ ~ _ City of Chula Vista /~ Chula Vista Investment Pool z7s FoBrtnAve ~ Chula Vista CA 91910 , Realized' Gains and Losses Islslssr-azeo CITY OP Sorted By MaturitylSalelCall Date CHULAVISTA SaleslCallslMaturities: September 1, 2012 -September 30, 2012 Investment# .__. __._... _- Inv. ~ Purchase Par Value - ------- - Sale Date --------- - - Days Held ----------- ~ Maturity/Sale Realizetl Total Total Total Issuer - Type Date CurrentRate Maturity Date Term ~ Book Value Proceeds GainlLoss Earnings Net Earnings~Yield 365 10595. MC1 09121/2010 3,000,000.00 09121/2012 731 3,000,000.00 3,000,000.00 0.00 112,500.00 112,500.00 1.872 Federal Farm Credi[eank 1.875 09/21/2015 1,826 . 10688 MC1 06/06/2012 4,000,000.00 09/27/2012 113 4,000,000.00 4,000,000.00 ~ 0.00 10,483.33 10,483.33 -0.047 Federal Farm Credit Bank 0.850 06/06/2016 1,461 ~ - - ' 10651 MC1 09/28/2011 3,000,000.00 09/28/2012 366 3,000;000.00 3,000,000.00 0,00 30,600:00 30,600.00 1.017 Federal Farm Credit Bank 1.020 09!28/2015 1,461 10653 MC1 09/28/2011 3,000,000.00 09/28/2012 366 3,000,000.00 3,000,000.00 0.00 30,000.00 30,000.00 0.097 Federal Naf1 Mtg. Assoc. 1.000 12/28/2015 1,552 Total Realized GainslLOSSes 13,000,000.00 13,000,000.00 0.00 ~ 183,583.33 703,563.33 1.157 J Run Oale:40/17I2012 -14:49 Podfolio CHUL CC CG (PRF_CGR1) BymRep16.41,202b Report Ver. 5.00 ~~~/~ ~erOrr~ X11 CITY OF CHULA VISTA Chula Vista Investment Pool Accrued Interest Sorted by Issuer -Investment Number September 1, 2012 -September 30, 2012 City of Chula Vista 276. Fourth Ave Chula Vista CA 91910 (619)691-5250 .. - ' ~ - Security Par Maturity Current 'Beginning Adjusted Acc'd Int. atPUrchase - ' " CUSIP Investment# Type ~ Value 'Date Rate Accrued Interest During Period Interest ' Interest ~ Ending Federal Farm Cregit Bank - - Eardetl "Received Accrued'Interest 31331Jh155 10595 MC1 0.00 '09/21!2075 1:875 25 000 00 31331 KZL7 10651 MC1 0.00. 09/28/2015 020 1 , . 0.00 3,125.00 28,125.00 0.00 31331 KG61 10655 ~ MC1 3,000 000.00 10/19/2015 . "7 290 13,005.00 0.00 2,295.00 75,300.00 0.00 31331 KL24 ~ 10658 MC1 , 3,000 000:00 10/26/207e . 1 540 14,190.00 0.00 ~ 3,225.00 0.00 17,415'.00 , 31331KZ29 10665 MC1 ~ , 4,000 000.00 72/07/2075 . . 330 1 16,041167 0.00 3,850.00 0.00 19,897.67 31331K5T3 10669 MC7 , 3,000,000.00 01!11/2016 . 1 020 72,413.33 ~ 0.00 4,433.34 0.00 16,046.67 31331 K6Y1 10671 MC1 3,000,000.00 01/18/2017 . - 1 270 4,250.00 0.00 2,550.00 0.00 6,800.00 3133EACY2 10679 MC1 3,000 000 00 08/10/2015 . 0 590 4,550.83 0.00 3,175.00 0.00 ' .7,725.83 3133EASR0 10688 MC7 ~ , . 0.00 06/06/2016 . 0 850 1,032.50 .0.00 - 1,475.00 0.00 ' 2,507.50 3133EAVVYO 10fi91 MC7 3,000 000.00 07/10!2017 . 1 040 8,027.78. 0,00 2,455.55 10,483.33 - - .0.00 3133EAY28 10694 MC1 , 3,000,000.00 09/21/2017 . 0.830 4,420.00 0 00 0.00 2,600.00 - ~ 0.00 7,020.00 . 0.00 - 691.67 Subtotal 25,000 000.00 ~ " 0.00 691.67 Fer~ral Home Loan Bank , _ 102,931.11 ~ 0.00 - - ,29,875.56 - 53,908.33 ' 78,890.34 , 313~XVfiUO 10542 FAC 2,000,000.00 10/09/2012 1.750 13,805.56 0 00 313~3VH2 10628 MC1 3,000,000.00 08/10/2075 1.700 11 475 00 . 2,916.66 - 0.00 16:722.22 Subtotal 5,000 000 00 , . 0.00 4,250.00 0.00 75,725.00 - , . 25,280.56 0.00 7,166.66 0.00 32 447 22 Federal Home Loan Mortgage Co. , . 3134G24U3 10660 MC1 3,000;000.00 11/16/2015 1.250 70,937.50 0 00 3134G25F11 10fi63 MC1 3,000,000.00 11/23/2075 1.725 9 187 50 . 3,125.00 0.00 14,062.50 3134G38Z2 10664 MC1 ~ 3,000,000.00 12/1412015 1.250 , . 8 020 83 0.00 ~ 2,812.50 - 0.00 12,000.00 -3134G3EB2 10667 MC1 3,000,000.00 06/30/2015 1,000 , . 5 083 33 0.00 3,125:00 0.00 11,945.83 3134G3JY7 10670 MC1 3,000,000.00 07/3012015 0.840 , . 2 170 00 - 0.00 ~ 2,500.00 0.00 7,583.33 3134G3KK5 10672 MC1. 3,000,000.00 07/27/2018 1.100 , . 3 176 67 0.00 2,100.00 .0'00 4,270.00 3134G3LD0 10673 pAC 4,000,000.00 02/13/2015 0 700 , . 0.00 2,750.00 0.00 5,866.67 ' 3134G3MR8 10675 MC1 ~ 3,000 000.00 02/13/2015 . 0 550 1,400.00 0.00 2,333.33 0.00 3,733.33 3134G3NL0 10680 MCt - , 4,000,000.00 02/24/2015 . 0.500 825.00 388 89 0:00 1,375.00 0.00 2,200.00 3134G3XE5 ~ 10689 - MC1 3,000,000.00. 06/07/2017 1.150 . - 8 050 00 0.00 1,666.67 0.00 2,055.56 3134G3YZ7 10692 MC1 - 3,000,000.00 07/25/2017 7.100 , . 3 300 00 0.00 - 2,875.00 '0.00 10,925.00 Subtotal 35 000 000 00 , , 000 2,750.00 0.00 6,050.00 ' , , . 52,479.72 - 0.00 .27,412.50 0.00 79 892.22 Federal Nat I M tg. Assoc. , 3136FRX73 10647 MC1 3,000,000.00 09/09/2015 1.000 ' 14 333 33 0 313fiFRX57 10649 MC1 3,000,000.00 09/20/2016 - 1.420 , . 19 051 67 .00 0 2,500.00 15,000.00 7,833.33 ' Beginning Accrued may not include investments that redemed in the previous month that , . had outstanding acc d .00 i t E 3,550.00 21,300.00 1,301.67 ' rue n erest. nding Accrued includes outstanding purch ase interest. ~ - Portfolio CHUL tun Date. 10/A 712012 -14:49 ~ ~ ~ CC AI (PRF ql ) SymRep16.4t202b Repon Ver. 5.00 Chula Vista Investment Pool Accrued Interest - - S orted by Issuer- Investment NumbeF ~ ~ - , Page 2 ` - ~ - AtlJ ustedACC'd In[. ~ - - CUSIP Investment# Security 7yAe Par Value Maturity Dat Current • 'Beginning R e at Purchase Interest Interest ' Entling e at Accruedinterest During Period Earned Received Accrued Interest Federal Nat'IMtg. Assoc. ~ - 3136FTAK5 10653 MCT 0 .00 12/28/2015 1.000 5 250 00 0 00 3136FTHL6 10657 MC1 3,000,000 .00 04/28/2015 , . 1.100 11 183 32 . - 2,250.00 7,500.0D` 0.00 - 3136FTHC6 10658 MC1 3,000,000 .00 01I26I2015 , . 1:000 2 916 67 - 0.00 2,750.00 ~ 0.00 13,933.32 3136FTXD6 - 10668 MC1 3,000,000 .00 12/28/2015 , . 1.100 5 775 00 0.00 2,500.00 0.00 5,416.67 3136FTK73 - 1067G MC1 3,000,000. 00 02/22/2017 , . 1.375 - 1 031 25 0.00 2,750.00 0.00 8,525.00 3136FTP52 10fiB1 'MCt 3,000,000. 00 02128/2017 , . 1.100 275 00 D.00 3,437.50 ~ 0.00 4,468.75 3136GOJX0 10685 MC1 4,000,000. 00 05/30/2017 . 1.250 12 638 89 0:00 ' 2,750.00 0.00 3,025.00 3136GOJR3 10687 MC1 4,000,000. 00 06/03/2016 , . p.950 9 183 33 0.00 4,166.67 - 0:00 16,805.5G 3135GOMN0 10690 MCi 3 000 000 00 06/28/2017 , . 1 125 0.00 3,166.67 0.00 12,350.00 , , . . 5,90fi.25 0.00 281250 p 00 Subtotal ~ 32,000,000.00 87,544.71 0.00 32,633.34 43,800.00 Total 97,000,000.00 268,236.10 0.00 97,088.06 97,708.33 J I 8,718.75 76,376.05 267,615.83 * Beginning Accrued may not include investments that redemed in the previous month that had outstanding accrued interest. Ending Accrued includes outstanding purchase interest. Portfolio CHUL Run Dala~. 1011 7/2 012-14:49 CC AI (PRF_AI) SymRepl6.41.202b Report Ver. 5.00 Schetlule of Cash/Investments with Fiscal Agont as of September 30, 2012 Maturity Purchase Contractual Book Bontl Issue Security Description Trust Acct # Type Date Date Par Value Mkl Value Value Yield CV Public Financing Authority Milestone Treasury Oblig FD Prem Shr 34430300/1l2/3/4/5/8I9110/11/1: Mutuol Funds 4,125,878 4,125,878 ~ 4,125,878 Var 2001-112001-2 RAD Tdnity Plus Funding Co Invst Agrmt 94430303 Invtmnt Agrmt 02-Sep-2017 04-Sep-01 1,201,778 1,201,778 1,201,778 5.600 Trinity Plus Funding Co Invst Agrml 94430312 Invtmnt Agrmi 02-Sep-2017 04-Sep-01 426,500 426,500 426,500 5.600 2002 COP Police Facilities US Treasury 94445202 US Trsy Notes 2,021,563 2,052,960 2,027,563 5.835 Milestone Treasury Oblig FD Prem Shr 94445200 .Mutual Funds 3 3 3 Var CFD 06-(Improvement Area A Milestone Treasury Oblig FD Prem Shr 9 4 4 77 0 00/3/4/5/9 /1 0 Mutual Funds 4,989,396 4,989,396 4,989,396 Var Local Agency Investment Fund 94477005/9 Mutual Funds 4,863,414 4,863,414 4,863,414 Var 2003 Refunding Cert of Participation FSA Capital Mgmt Invst Agreement 94652201 Invmnt Agrmt 01-Sep-2013 11-Jun-03 611,797 811,797 811,797 3.100 Milestone Treasury Ohlig FD Prem Shr 94652200 ~ Mutual Funds 7 1 i .Var CFD 2001-2 McMi11In-Otay Ranch 6 Milestone Treasury Oblig FD Prem Shr 9 46 5 8 9 0 0/0 3/0 4/0 510 8/0 9/1 0 Mutual Funds 1,377,956' 1,377,956 1,377,956 Var CFD 08-I Otay Ranch Village 6 Milestone Treasury Oblig FD Prem Shr 94682700103/04/05 Mutual Funds 2,401,617 2,401,617 2,401,617 Var LAIF 94682105 Mutual Funds 1,600,790 1,600,790 1,600,790 CFD 07-I McMillin Otay Rnch Vllg 11 Milestone Treasury Oblig FD Prem Shr 784708000103/04 Mutual Funds 728,440 728,440 728,440 Var IAIF 784708003 Mutual FUnds 2,343,470 2,343,470 2,343,470 CFD O6-I Improvement Area B Milestone Treasury Oblig FD Prem Shr 786104000/3/415 Mutual Funds 1,704,402 1,704,402 1,704,402 Var 2004 COP Civic Center Phase I Dreyfus Inst'I Res Treasury 325544 Mutual Funds 125,400 125,400 125,400 Var FSA Capital Management Services LLC 325544 Invmnt Agrmt 01-Mar-2034 16-Sep-04 2,395,911 2,395,911 2,395,911 5.205 2006 COP Civic Center Phase 11 Dreyfus Insl'1 Res Treasury 745757 Mutual Funds 63,750 63,750 63,750 Var FSA Investment Agreement 145757 Invmnt Agrmt 01-Mar-2036 17-Mar-2006 1,272,459 1,272,459 1,272,459 5.010 CVPFA 2005 Rev Refunding SerA Milestone Treasury Oblig FD Prem Shr 790488000+ Mutual Funds 12,738,702 12,738,702 12,738,702 Var Citigroup GIC #871615.1 Reserve Accounts - Invmnt Agrmt 01-Sep-2032 6,436,873 6,436,873 6,436,673 4.889 Cash 790488004 Cash-Fiscal Agt 25,312 25,312 25,312 CFD 07-1 Improvement Area B Milestone Treasury Oblig FD Prem Shr 792183000-10 Mutual Funds ~ 5,252,239 5,252,239 5,252,239 Var CFD 12-I McMillin Otay Rnch Vllg 7 Milestone Treasury Oblig FD Prem Shr 7 91 9 4 9 00 0 /4/6!7/8/72 Mutual Funds 2,121,574 2,121,514 2,121,514 Var CFD 13-1 Otay Ranch Vllg 7 Milestone Treasury Oblig FD Prem Shr '93774000/03l04I05/06/07/OB/1 ~ Mutual Funds 4,004,293 4,004,293 4,004,293 Var ~ LAIF 793774003 Mutual Funds 1,147,000 1,147,000 1,147,000 CFID07-IB McMillin Otay Rnch Vllg 11 Milestone Treasury Oblig FD Prem Shr 794322000/01/03/09 Mutual Funds 1,244,272 1,244,272 1,244,272 Var I LAIF ~ 794322003 Mutual Funds 213,432 213,432 213,432 2013~OP Capital Facilities Refunding Milestone Treasury Oblig FD Prem Shr 136267000-136267005 Mutual Funds 2,830,969 2,830,969 2,830,969 Var O6 r. Tax Alloc Ref Bonds A Milestone Treasury PS Fund # MS 103986000/05 Mutual Funds - - - Var Rabobank International NY Branch 103986003 Invmnt Agrmt 09-Aug-2027 11-Sep-2006 1,027,945 1,027,945 1,027,945 4.980 O6 Subordinate Tax Alloc Ref Bds Milestone Treasury PS Fund # M5 103987003105 Mutual Funds 715,517 715,517 715,517 Var CiliGroup Financial Products, Inc. GIC 103987003 Invmnt Agrmt 26-Sep-2027 11-Sep-2006 1,004,365 1,004,365 1,004,365 5.097 RDA 2008 Tax Alloc Ref Bonds Milestone Treasury PS Fund # M5 727926000 10 6011 Mutual Funds 30-Sep-2036 22-Jul-2008 3,623,339 3,623,339 3,623,339 Var CDBG Section 108 Loan - Cash -Interest Bearing Acct 1459703226 Restdctetl Cash 2,264,279 2,264,279 2,264,279 Var Orange Tree MHP Cash -Interest Bearing Accl 2324-80156 Restricted Cash 647,990 647,990 647,990 Var Grand Total as of September 30, 201 2 77,752,565 77,783,962 77,752,565 i:financebalaVnvestUnvl3.xls City of Chula Vista Cash/Time Deposits 30-Sep-12 CASH IN BANK Bank of America -General Account Bank of America -Payroll Account California Bank -Direct Deposit Account Wells Fargo Bank-CV Workers Comp Account CASH ON HAND Petty Cash Fund TIME DEPOSIT . Bank of America Time Deposit Cash/Time Deposits as of 0913 0/2 01 2 20, 841,295 0 3,498 348,125 21,192,918 6,050 6,050 310,000 310,000 21,508,968 j:finance\data\Cash and Time Deposits FY1213 SEP j 30 2D92.DRAFT.xIs As of 10/30/2012