Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
City of Huntington Beach Investment Advisory Board Annual Re
CITY OF HUNTINGTON BEACH INVESTMENT ADVISORY BOARD rr ANNUAL REPORT TO THE CITY COUNCIL FOR THE PERIOD: OCTOBER 1, 2015 TO SEPTEMBER 30, 2016 14B -1 I- Item 1. - 1 INVESTMENT ADVISORY BOARD (IAB) Establishment of Board The Investment Advisory Board was created to act in an advisory capacity to the City Council and City Treasurer in matters pertaining to all of the City's investments by the City Council in May of 1995, by Resolution #3284. The Board is governed by the City's municipal code chapter 2.110. The duties of the IAB as defined in the municipal code include: 1) Preparation of an annual report to be submitted to the City Council 2) Review and recommendations regarding: - The city's Investment Policy Statement - Investment strategies and opportunities - Relevant governmental legislation - Quarterly investment reporting and compliance 3) Quarterly meetings The Board members are appointed by a member of the City Council. For the Fiscal Year 2015-16, members were as follows: Name Council Member Rob Sternberg Jim Katapodis Lydia Dupont Billy O'Connell Scott Dowds Barbara Delgleize Jennifer Handy Jill Hardy John Piekarski Mike Posey Ron Sterud Dave Sullivan Alan Ray Erik Peterson Board Activities The meetings of the Board for the 2015-16 fiscal year ending September 30, 2016 were open to the public, as required by Government Code 54950, and were held on the following dates in City Hall: October 15, 2015 January 26, 2016 April 21, 2016 July 21, 2016 The Annual Study Session was held on February 1, 2016. The two major activities of the Board consisted of reviewing each quarterly investment report and reviewing the City of Huntington Beach Investment Policy annually, prior to their presentation at a City Council meeting. Item 1. - 2 HB -12- As required under Huntington Beach Municipal Code 2.110.040(b), for the 2015/16 fiscal year, the Investment Advisory Board reviewed matters pertaining to the City's investments in the following areas: • Reviewed the annual Investment Policy Statement and recommended modifications including simplifying the portfolio benchmark to provide additional transparency and expanding permitted investments as allowable by the California Government Code Section 53601. • Discussed cash management and ensured sufficient liquidity to meet the next six months' estimated expenditures. • Reviewed risk-return analysis as it relates to safety, liquidity and yield. • Reviewed new investment opportunities, including information provided by the California Asset Management Program ("CAMP"). • Reviewed appropriate state and federal legislation as it may impact the City's investments, including updates to the California Government Code Section 53601. • Reviewed any anticipated exposure to loss through the analysis of liquidity, credit & market value of investments. • Reviewed quarterly reports prior to presentation to the City Council. • Reviewed quarterly compliance with Investment Policy. No exceptions were identified. Based on the information reviewed by the Investment Advisory Board for the period October 1, 2015 to September 30, 2016, the Board acknowledges that the City Treasurer has maintained compliance with all requirements in the City's Investment Policy and related governmental regulations, and has managed the City's investment portfolio in a prudent and suitable manner. HB -B- Item 1. - 3 Dept.ID CT 17-002 Page 1 of 1 Meeting Date:2/6/2017 r CITY OF HUNTINGTON BEACH - REQUEST FOR. CITY COUNCIL ACTION MEETING DATE: 2/6/2017 SUBMITTED TO: Honorable Mayor and City Council Members SUBMITTED BY: Fred A. Wilson, City Manager PREPARED BY: Alisa Cutchen, City Treasurer SUBJECT: Receive and file the City Treasurer's December 2016 Quarterly Investment Summary Report Statement of Issue: Receive and file the City Treasurer's Quarterly Investment Report for December 2016, pursuant to Section 17.0 of the Investment Policy of the City of Huntington Beach. Financial Impact: Not Applicable. Recommended Action: Receive and file the City Treasurer's Quarterly Investment Report for December 2016, pursuant to Section 17.0 of the Investment Policy of the City of Huntington Beach. Alternative Action(s): Deny or Critique Quarterly Report. Analysis: Not Applicable. Environmental Status: Not Applicable. Strategic Plan Goal: Strengthen economic and financial sustainability Attachment(s): 1. Treasurer's Quarterly Investment Report for December 2016 2. Treasurer's PowerPoint Presentation for December 2016 Item 1. - 1 H B -14- 4- f'. t City of Huntington Beach Treasurer's Investment Report Quarter Ending: December 2016 ,Prepared by. Alisa Cutchen, CCMT, CPFIM - City Treasurer i 1iPage HB -1 5- Item 1. - 2 Economic and Market Overview: Market Summary Federal Funds Rate 10-Year Treasury S&P Sot? DOW October 31,2016 0.25-0:50% 1.84% 2,126.15 18,142,42 November 30,2016 0.25-0.50% 2.37f 2,198.81 19,123,58 December 31, 2016 0.50-0.75`% 2.45% 2,238.83 19,762:60 Nov-Dec%Change 50% 3.38% 1.82% 3.34% The Federal Open Market Committee (FOMC) met in December to discuss the current state of the economy and to examine potential future interest rate hikes before year end. After this meeting, the Fed released an official statement explaining that"in view of realized and expected labor market conditions and inflation, the Committee decided to raise the target range for the federal funds rate to 112 to 3/4 percent. The stance of monetary policy remains accommodative, thereby supporting some further strengthening in labor market conditions and a return to 2 percent`inflation." Fixed Income/Equity Markets. The yield on the 10-year U.S. Treasury finished the quarter at 2.45%, up from 1.60% from the previous quarter, for a 53.13% increase quarter over quarter, The S&P 500 and the DJIA increased at 3.25% and 7.94% respectively for the same time period. In the fourth quarter of 2016, both the bond and equity markets posted strong gains to close out the quarter. Employment: The U.S. gained 156,000.jobs in December with the largest increases in education and health services, leisure and hospitality, professional and business services, and transportation. According to the labor department, the unemployment rate decreased from 4.9% to 4.7% quarter over quarter with the labor participation rate for December decreasing slightly to 62.7%. 2lPage Item 1. - 3 K B -i 6- 1 At a glance: the December jobs report Unemployment rate By selected industies On thousands Recession_ 4dplo ( period �- ' �' � - Mining/logging C truct an Manufacturin Wholesale trace 2 ItetaClr de F,b.3 _.._..' /� - 4 : Trans r tatir n and warehousing ' `08 109 110„ �.....Ill _.. '12 f13. � '14 `15 '16 a 14.7 Monthly jobs growth it)ttnoo5aods__.,,„._ - #W Utilities Recession 0.2 periad I fnr�na#inn 200 e Financial.act 1-3 t „ -2oo Prcfe si a! business services .� - -400 Education and health services -8ttt Leisure sand hospitality 9 �.. 24 ,. .._ _.. 1,000 ; government `t38 °09 110 I11 '12 '13 .. 114 '15_.. _'16 ERM12 Source:Bureau of Labor Statistics i i 3 page HB -l 7_ Item 1. - 4 Portfolio Overview: As of December 31, 2016: %of YTM Investment Type Market Value Book Value Portfolio 365-day Policy Limit Federal Agency Issues 140,938,620 142,528,693 67% 1.42% None Local Agency Investment Fund (LAIF) 21,524,011 21,524,011 10% 0.72% $65 million Medium Term Notes—1BRI) 4,968,800 4,982,174 2% 1.11% 10% Corporate Bonds 44,491,620 44,672,115 21% 1.44% 30% 1 Total Portfolio $212,923,051 $213,706,993 100% 1.35% As of December 31, 2016, the market value of the City's investment portfolio was approximately $211.9 million, with a book value of $213.7 million. The portfolio is invested in only those investments allowable by state regulations and the City's investment policy. Such investments are purchased to meet the portfolio objectives of preservation of principal, maintenance of sufficient operating liquidity, and to attain a market rate of return throughout budgetary and economic cycles, in that order of absolute priority. Portfolio Composition: Investments by Type as of December 31, 2016 Corporate Bonds 21% Federal Agencies 67% MTN-I BRD 2 Iya .......... 11111177 LAIF 10% ............. ................... 4 P a g e Item 1. - 5 HB -18- Currently, funds within this portfolio are invested in federal agency securities, corporate bonds, the International Bank for Reconstruction and Development ("IBRD") and the State of California's pooled account (Local Agency Investment Fund "LAIF"). The four federal government sponsored entities (agencies) whose bonds the City purchases are: Federal Home Loan Bank (FHLB), Federal Home Loan Mortgage Corporation (FHLMC/Freddie Mac), Federal National Mortgage Association (FNMA/Fannie Mae) and Federal Farm Credit Bank (FFCB/Farm Credit). Corporate bonds are obligations of corporations. All corporate bonds are "A" rated or its equivalent or better, per the City's investment policy and state of California regulations. LAIF offers local agencies the opportunity to participate in a major portfolio with overnight liquidity managed by the State of California Treasurer's Office. Please see http://ww�v.treasurer.ca.,qovlpm ia-la iffi/laif,asp for more information as well as the "State of California Pooled Money Investment Account Market Valuation" (included in this report) for month end data. LAIF has been utilized for the liquidity portion of the City's portfolio as the yield received at this time is greater than that of similar liquid investments such as money market accounts, short-term Treasury Bills, and commercial paper. Portfolio Earnings and Performance: 2016 Monthly Earnings History $250,000.00 ...................................................... $200,000.00 ............... $150,000.00 - ........... ............ ............... ......... $100,000.00 .......11 .......... ..... $50,000.00 .......... .............. ......... ................ S-1 ek (40 A to lip Monthly investment earnings for December 31, 2016, were $200,298, The monthly effective rate of return was 1.19%, with a fiscal year-to-date effective rate of return of 1.15%. This compares favorably to the previous year's monthly earnings of $169,539 and monthly effective 5 1 P a g P HB -19- Item 1. - 6 rate of return of 1.07%, for the same time period in 2015. These earnings are utilized to offset taxpayer funds for city operating expenses, capital projects, debt repayment, and other uses. Portfolio Earnings Month End 12/31116 FY 2016/2017 Current Year $ 200,298 $ 572,494 Current Budget $: 140,000 420,000 Last Year Actual 169,539 $ 499,573 Effective Rate of Return 1.19% Benchmark* 1.201 2-year Constant Maturity Treasury(CMT) rate With the sharp increase in the interest rates over November and December of 2016, the 2 year Constant Maturity Treasury rate climbed to 1.20% at the end of December,just off its high of 1.29% in mid-December, the highest rate since 2009. Due to this sudden and rapid rise, the return on the portfolio as a whole is just slightly under this rate for the month at 1.19%. With the increase in interest rates, it is anticipated that the portfolio will experience a similar increase in the rate of return over time. Portfolio Activity: (For details of portfolio activity, please see the Sympro reports attached titled"Activity Report) Monthly Activity: For the month ending December 31, 2016, $20 million in federal agency securities were purchased and $2 million in corporate bonds were purchased. $9 million was transferred from LAIF to the operating account over the month. ' Quarterly Activity: For the quarter ending December 31, 2016, a total of $30 million in federal agency securities were purchased with $20 million in federal agencies called or matured, A net of $1 million was transferred from LAIF to the operating account with a deposit of $61,730 for interest earned from quarter ending December 31, 2016. $7 million in corporate bonds were purchased and $5 million in medium term notes (International Bank for Reconstruction & Development "IBRD") were purchased. Compliance: The portfolio is in conformity with all relevant State regulations and the City's Investment Policy statement as approved by the City Council on November 7, 2016. The investment program herein shown provides sufficient cash flow liquidity to meet the next six months' obligations. 6 1 P a g e Item 1. - 7 HB -20- Additional Information: Retirement Plan Information as of September 30, 2016 (Due to the delay in statement receipt, information is from previous quarter.) CI of Huntington Beach-Pension/Trust Plans-Market Value Summaity Deferred Compensation Plan Summary information. as of September 30,2016 Beginning Contributions Distributional Earnings Other Fees/ Self Directed Ending Balance Transfers (change in Adjustments Option Balance Balance (7-1-16) value) (Nationwide. (9-30.16) Gain/Loss/ OnN) Reporting is Quarterly Interest. ICMARetirementCorporation(457:Pian) $42,665,682 $691,900 ($742,063) $1',373158 ($2,962) $443,986,725 Nationwide Retirement Solutions(457 Plan) $75,259,596 $1,053,664 ($916,085) $2,04511322 ($1,100) $1.042,726, $78,484,425 Total Deferred Compensation Plan Balances $117,925 280 $1,745,56 ($1,658,148) $3,418,780 ($4,052) $122.470,160 City of Huntington Beach Retiree Medical Trust Surnmag Information as of September 30,2016 Beginning Contributions Distributions/ Investment Other Fees! Ending Balance Transfers Earnings Adjustments Balance di-1as) (change in (9-30-16) Reporting is Quarterly value) CaIPERS Retiree Medical Trust Account $22,316 243 $76,000 $0 $472,156 ($4,842) $22,869,557 j i t i City of Huntington Beach Supplemental Pension Trust Summary Information(monthly reporting,.not quarterly) as of September 30,2016 Beginning Employer Interest& Realized Change In Other Trust Ending Balance Contributions Dividends Gain/Loss Unrealized Fees? Balance Pius Net Gains/Losses Adjustments (9.30-16,) (9-1-1fi) Accrued Reporting is Monthly Income US Bank Supplemental Pension Trust.Account $47,117372 $822 0D0 $107,339 $53,139 ($29,809) ($6,266) $48,063,775 ......................... 7 Page .KB -21- Item L - 8 Bond Reserve Accounts -Balances as of Decernber 31, 2016: Summary of Huntington Beach Bond Issue--Reserve Accounts Reserve Account Investments As of December 31,2D16 Value as of Federal Money Market Bond Issue: Doc 31,2016 LAIF Agency Issues Funds CAMP H.B.Public Finandrig A UOV tease RetiMing Bonds 2010 Wes A 1,242,875.79 1,242,000 875.79 H.B.Put'eFinanangAAufily(COW Improvement Refnare 8e brCener) Bonds.2011SeriesA 3,717,972,53 3.717,972,37 0,16 Redeyde aktAgency of H.B.-1939Tax Alloca3on Rebating Bonds(113of 1992} 754,148,37 M4,148.36 0:01 Redevel ntAaency of H.B.-24(I2 Teal Aibc*nRefunaing Bonds(213 of 1992) 1,678,974.62 647,773.23 1,003,020.OD 28;181.39 H.B.Coomunity FaciGtes aistdct No.1990.12001 Special Tax Boris(Goldenwest-Ellis) 172 662.12 172,282;00 400,12 H,B.Community Facilities Dis*tNo,2000-12013 Special Tax Bands(Grand Coast•Hya1 1,092,139.D2 364.02 1,091,775.00 H.B.Community Fmiffies Distiicl No.20D212002 S lal Tax Bonds(McDowell CenreBusiress Pali) 455,85742 455,857.32 H.B.CommwiryFaclliesDistict No.=12013Spqc�dal Tax Bonds(HuntingtonCorter-Bela Terra) 1,681,166.60 5560.35 1,680,606,25 TOTALS: $ 10,796,796 $ 6,990,013 $ 1,003,020 $ 30,382 $ 2,772,381 - 8 Page Item 1. - 9 H -22- �,��tlrrsrp� �iC�¢Easrou,�6 dE, y. City of Huntington Beach . x City of HB loco main St. Portfolio Management NunYirtgton seams, F�a cL� Portfolio Summary October 31, 2016 par Market Box* %of Wy$to Y71ri YM Investmenm Vakie Value Value PortfaW Tenn MaWrlty 36D Equal. 365 Equfv. Federid,Agency Issues•Coupon 122,405.M0.00 1?ZW,507,50 122a430.603,$l 62.90 1,331 1,074 1.278 1.296 Local Agency Inveslmeta;Fun& 29,524,611.27 29.524,011,27 29,624,011,27 15.17 1 1 0.645 0,654 Corporate 800AS 42.$04.000,00. 42,703,77S.00 42,702,324.87 21,04 1,164 601 1.392 1.411 Investments 9,0 194,4211 94,:27 1368,293.77 194,557,019.45 100.00% 1.090 807 1.207 1.224 Cash and Accrued Interest: .Accrued Interest at Purchase. 18,958,34 1$,958 34 subtotal 7e.ssa.3a 10,968.34 ZZ Totel.Cash and lnvesWwrMs 194.429,09127 194,387,252.11 194,676,977,79 1,090 807 1-207 1.224 f y; Total Earnings October 31 Month Ending Fiscal Year To.Date Fiscal Year.Ending Current Year 164,471,09 184,471.09 Cwent Budget 140k00:00 140.000.00 1,680,000.00: t_ast YearActuat 166.288.99 166,288,99 2,29%957.00 Average Daily,Satattce 196,574478.10 196,57Z,478A0 Effective Rate of Return 1.1 WA 1.10% I certify that this report a=rAt*..reflects all City pooled.kwasbrients and is inconfarinity vuith ail Stale lams am the Investment poI4 statement filed.W M the City Cound on November 7,201&A copy of this poacy is available at the of e.of the City Clerk,The kwesmient program herein shown provides sufficient cash low liquidity to meet 01e next sic month's obligations. Market Values provided by Union Bank via Interactive Dais.Comprabon. 4 C- A6sa Cutchen,CMYTREASURER Reporting period 14(0112016-1003112016 Portfolio CITY ►CD AP 1—C Run Oaw Dlnecol7 14:4a PM(PRF,PMI)7,30 �+ ricpost Var.7.32% r I� l� c-► 7 City of HIS Portfolio Management Page i. Portfolio Details-Investments October 31,2616 Average Purehase &fated YM Days to Maturity WSW 8rrwestment4 Issuer Balance Date Par Value PtarketValue Book Value Rabe S&P 3"Maturity ow" 1Fedoral Agency Issues.Coupon 3133EGEV3 414D Federal Farm Credit 9ar1k 06/15/2016 5,000,00O.D0 5,001,600,00 5.000,000,00 1.620 AA 1.620 1,688 D6r14J2021 3130A37A2 4M Federal borne Loan Bank 1213W014 5,000,D06.00 5,011,aco.00 4,599,809.31 1.000 AA L010 287 D8r1512017 313378A43 4D48 Federal dame Loan Bank 02=112015 5.000,0Q0.00 5,037,400.D0 S.D18,2722S 1,376 AA 1,100 493 03M912018 313OA7VW7 4136 Federal Herne Loan Bank 05r2412016 5,000,000,00 5,003.800.00 5,DD0,000.00 1.250 AA 1,250 934 M li2019 3130MDC4 4138 Fodersl Home.Loan Bank 06f30r20i 6 2,250,OD0.00 2,225,677.50 2.250.000-00 1.60C AA 1.600 1,520 1200J2020 313M9744 4163 Federal Home Loan Bank 08110J2015 5,W0,000.0o 4,M'So0.00 5„000,000-00 1.060 A4 1,518 1,378 0811=2,� 20 3134GTU25 4117 Federal Horde Loan Haft Corp 101274015 5,000,000,00 4,998.050,00 C000,000.00 0;800 AA 0.80D 360 10027n017 3134G73Ct2 4120 Federal Home Loan Mort Carp %2712D15 5,D00,000,06 4.989,700.00 5,000,000.0D 1.00C AAA 0.991 633 07J2712018 3134GIORN9 4139 Federal Howse Loan Mort Corp 06123=i8 5,000,000.Do 4,99S,300.DD' 5,000,0DO.CO 1.250 AA 1.919 1,330.0et23a= 3134G9UY1 4142 Feder Horne Loan Mon Corp C6129A2016 5,000,D00.D0 4,999,90D,00 5,000 D00.00 1.000 AA 1.000 6D5 06f2=18 3134Cv9F93 4140 Federal Home Loan Mort Corp 06/3012016 5,000;000.00 41974,700.00 5,000,000.00 1:000 AAA I 998 .969 06f28P2019 M34GSM 4149 Federal Horne Loan Mort Corp 05190r2016 5,000.000.D0 4,946,10D.00 5,000,000.00 1.280 AAA 1.2a0 1,429 09130=2D 3134GBC54 4150 Federal Horne Loan Mon Coip 06/3012016 4,855,000.00 4.603.795:00 4,655,000.CC 1.600 AA 1,500 1,702 06/3018021 rZ 3134G5G35 4151 Federal mom*Loan Mort Corp 0S 12016 5,000,000.00 4,989,850,00 5,000,000 00 1.DOO AAA 1,502 1.702 06/30I2021 3135,SORK1 3945 Fed.Nad Mort Assoc. 11/0712012 3.000,000.00 4.999,950,00, 51000.900,0C 0.90o AA 0.900 371 W07=17 la 31WAZRSS 4122 Fed.Nan Mort Assoc. 10J2912015 5,000,000.00 5,01a,450.00 5,0031000.00 1.040 AA 1.040 724 10726J2018 4- 3135GDZLO 4132 Fed,Nall Mort Ass= 031OW2016 5.000.ODD.00 5,013.200.00 SA08167,92 1.000 AA 0:800 330 09J27J2011 r 3138WKMG 4135 Fed,Nan WrL Assoc, 05117I2016 5.000.000,00 5,000,050.00 5.000;000.00 1.100 AAA 1-912 1,4158 CV17QC21 3135GDK85 4137 Fed.Nan Mort.Assoc. DW13r2016 5,000,ODO.00 5,005,650.01) 5,000,000.D0 1.400 AA 1.400 954 06J13l2019 3136G35J5 4141 Fed.Nail Mort AAseC. ow"I 2016 S,000,DDMOD 4,944,900.DO 4,998;834;03 11500 AA 1.505 1.702 0813=021 3136C+35NS 4143 Fed..Marl MorL Assoc. 08r2312016 3,030,00MOD 2,988,250.00 3,000.000.D0 1.500 AA 1,500 1.513 12f2312020 3135GDK93 4144 Fed.tsaL1 MOM Assoc, 06129P2016 $,000,000.00 4,995,300.00 5,000,000.00 1.250 AA 1.250 969 06/2812019 3135C3UT0 4146 Fed.Nat1 MorL Assoc. 06/30/2016 5,000,000.00 4,982,16C.00 5,01i0,300.00 1.500 AA 1.500 1,520 1213012020 3136G3Vu6 4147 Fed.Nafl Mot Assoc. 07h9J2016 5,000,000.00 4."0,75C:00 5,000.000.00 1.125 AA 1,819 1,721 07113=21 3136G3YG4 4152 Fed.Nat?Mort Assoc- 07125W16 7500.000.00 7,484,075.00 7;500.000.00 1.000 AA 1.000 905 0412512019 5ubtotat and Average 129,044.590.99 122,406,000,D0 122.140,507':60 122,430.683.51 i-296 1,f174 Local Agency Investment Funds SYS982 962 Law Chy 29,524,01127 29.624.011,27 .29.524.011.27 0.654 0.654 1 Subtotal and Average 28,694,998.79 29,524,f111.27 2%S24,011.27 22,824.011.27 0.994 1 Corpomte Ponds 054(>8HCZ0 4155 Bank of New York IM24/2016 5,006,000.OD 5,058.450.00 5,0e5,597.15 2.150 A 1,617 1.210 0212f1 20 1+4912LSP2 4024 Catwwllor F`nancial Corp. 12rt0I2014 3,000,0D0.00 2,999.700,00 2.990,077,52 1.300 A 1.SSS 485 031D1J2018 17275FiBG8 4164 CiscoSystmns Inc 09W/2016 3.000,D00.00 3,001,53D.03 3.008.191.93 1.400 AA 1.303 i.053.09120lms IW64AAB 4044 Chevron Corp 02JOB12015 3,000,000.00 2,999,910.OD 3,003,267.48 1.104 AA 1,003 399 1ZV5r2017 Ponfollo CITY RP Ruftoaie:OinOW',.14:d6 - PM IPRF Pam)7.3.0 Report Ver.7.3.3b City of H B Portfolio Management Page 2 Portfolio DeteiIs-investments October 31,2016 Average Purchase Stated y1-p{ RaYsto Maturity CUSIP InveShnentS Issuer Waage Date Pat Value hAarketValue Book Value RaW S&P 365 Maturity DSW corporaw Swift 269648AP7 4077 EMCCorp 07/1412015 2.SW,000.00 2,465600.OD 2.509,426,71. 1175 AA 1,630 577 t16101r2518 35962GSM $994 General Elee Capital Carp 12awo13 5,DDO,DD0.00 5.032,500.D0 '5;024p62,61 2.300 AAA 1.291 177 04127Y2D17 36962G6K5 4007 General Eltchl6 Capllal Corp OSM212014 2,500,DDD.00 2,511,950.DC 2,505,657.91 1,600 AA 1.340 394 1112t1r2D17 36962GSVM 4036 General Elawic.Capital Corp 1211912014 2.000.DDO.OD 2,008,980.D4 2,005,059.89 1.625 AA 1.442 S17 WOV2018 24422ESR1 4t26 John Deere Caphal 1210MO15 1,000,D00.00 1,004,750.D0 1,002,206.1$ 1,550 A 1.350 409 12i1512017 24422ESRI 4127 John Deere Capita 121082019 2.000,D00.00 2,009.500.D0 2,0D4,S90.19 1.550 A 1.337 409 12A62D17 1912188A7 4049 Coca Cola00 02/2412016 2,500,000:00 2.503,275.D0 2,496,26746 1.-50 AA 1.258 516 04101r2018 5893a'r'AC9 40" Merck&CcInc: D2108+2015 2.000,000.OD 2.OD3,040.DO 2,DDO,972.62 1.1DD AA 1.M 465 0113112018 68389%AQO 4071 OradeCwp D5/262015 3,000,000.OD 3,063,900_DD 3,041,161.83 2.376 AA 1,731 805 01/1512019 89233P7Ft A023 Toyota Motor Credit 12110,1014 3.000.OW0 00 3,DD3,600.00 2,995,941.89 1.376 AA 1.491 435 01110120t8 8923STAYI 4039 Toyota Motor Credit 0t2612015 3.OD0,000.00 3,037,290.00 3,028,76173 2.ODD AA 1A00 722.10/24/2019 Subtxal and Average 38,932,938.32 42,500,000.00 42,703,77&00 42,702,324.67 1.411 591 _. Total and Average 496,57z,47&10 194,429,011.27 194,3fr8,293.77 194,697,019.46 1.224 $07 1�..1 PWID10 CITY lJi (D AP Run Datm 01 M SM17•.t4A6 rra FiF ardz)7.3:0 c� City of HB w Portfolio Management Page 3 Portfolio Details-Cash October 31,2016 Average Purchase Statrtl YTM Days to CUSIP Investment# Issuer Balance Date Paryaiue Market Valve Book Value ltato S&P 365 Maturity Avwage Balance 0.00 Accrued Interest at Rjmhase 18,958.34 18,9%34 0 Sumtw 18,968.34 18,95&34 Otal Cash and 1nvestmeffts 196,572,478,1D 194.429,01127 1$4,387,2 11 IK675,977,79 12.24 807 f 1 Portfolio CITY AP Itm Cate:tMt1&W7•1.4.46 PAS{PRP Pfr12y 7.3.0 ..............................._....................................................... ..-----.._ - .. . ..... ... ....... .. City of H6 Portfolio Management Page 1 Activity By Type October 1,2016 through October 31, 2016 5taWd Transaction Purchases Redemptions CUSIP lmresvr"t,# Kswer Rate Date or Dapaslts or Withdrawals "anoe Fedee al Agency issues-Coupon 3137EADS5 4070 Federal Home Loan Mort Cr.Yp C.875 10114=16 0.0D 6,000,000.00 3134Cy7}f71 411 a Federal Home Loans Mon Corp 1.000 IWM2016 0.00 2.000.000.00 3134G7P96 41",9 Federal Horne Law Mott Carp 1.000 10123P2016 0.00 3,000,000.00 SubtoW 0.00 10,000,000.00 122,430,683S1 Local Agency Investment Funds (Monthly Summary) SY5982 92 LaIrcity 0.654 7,067,729.7E a.W Subtotal 7.081,729.7E 0.00 29,534,011.27 Corporate Bonds D64DEHczo 4165 SanxofN"York 2,160 10/24/2015 5.D88,100.00 0.00 Subtotal S,DB6,1.00.00 040 42,702,32d:67 Total 17,147.829,76 110,000,000A0 194,657,019.4E s t*J v k ('(1 Poft io CITY AP Run Date;01A W2017.14;a0 s� F1r1(PAF P1N3)7.3.0 Ropon Ver-7-3.3e I ra City of HB u, Portfolio Management Page 1 Activity Summary October 2015 through October 2016 Yield to fWaturAy Managed Number Number Month Number of Avorage 369 366 p0el of tnv*$tmarft Of:lnve"Ments Average Average End Year SeGuahits 62iarrce Equhraknnt Equivalent Nate Purchased Redeemed Term Dap wmawedy October 2016 41 186.003.67D.17 1207 1.223 0.337 7 6 1,184 944 November 2015 39 181,304,652.62 1.200 1.217 0.374 1 3 1.174 .9$3 December 201S 46 186,878,180.67 1238 1.255 0.400 8 1 1,147 925 January 2016 46 207,140,111,69 1243 1261 0,446 0 0 1,147 898 February 2016 43 204,413.571A2 1.217 1234 0.467 0 3 1.102 02 March 2016 47 201,877,568.13 1232 1,249 0,506 4 0 1,140 889 April 2016 45 204.141.812.62 1280 T.298 0.525 0 2 1.181 893 My 2016 44 208,914,6%.20 1.168 1.194 0.552 2 3 976 136 .tune 2016 46 228.822.47937 1.156 1.172 0-576 14 12 1,006 806 July 2016 45 230.059.053.62 1.167 1.183 0.588 2 3 1;044 890 August 2016 45 220,520,88$.69 1.166 1203 0,614 1 1 1.074 $31 September 2016 43 208,478,917.25 1205 1,222 0.634 1 3 1,114 S35 October 2016 41 196,572,478.10 1207 1.224 0.654 1 3 1,090 807 Erb Averayl0 44 205,008,023.32 1.2094A 1.225% 0.513 3 3 1,iQ6 857 E Portfolio CITY AP Ri,.y Data.tltrEOl�[st7.7a,c6 'PM(PPS )7.3A Rape 4+e['.7.3.3E City of HB Portfolio Management Page 1 Interest Earnings Summary October 31,2016 October 31 Month Ending Fiscal Year T4 Date CD1Couparrdl34scount Investments- Interest Collected 211 AW,04 211,000.00 Plus A=uecl Interest at End of Period 547,998.18 547,998.18 Less Accrued Interest at Beginning of Period ( 579268:64) ( 579.266.66) Less Aaaued Interest at Purchase During Period { 0:0.{Y) ( 0.00) Irsterest Famed during Period 179.731,52 179,731.52 Adjusted by Prerniurns and Discounts ,11.14&53 -11..14153 Arltusted by Capital Gains or Losses O.pO 0.00 Earnings during Periods 168,587s4 168.687.99 Pass Through Securities. Interest Collected 4.44 6.06 Plus Accrued Interest at End of Period 0.0p 0.00. Less Accrued Interest at Beginning of Period ( 0.00) 0.00) € Less Acertred Interest at Purchase Curing Period ( 0.00) [ 0,00 ' Interest.Eamed during Period 0.00 0.00. Adjusted by Premiums artd Discounts U0 0.00 Adjusted by Capital Gains or Losses 0.00. 0.00 Eerningsduring Periods 0.00 0.00 CashiChecicing Accounts: Interest Collected 61,729.76 61.729.76. Plus Accrued Interest at End of Period 18.064.39 18.064,39 Less Accrued Interest at Beginning of Period { 63,911.65) ( 68.911.05) Interest Earned during Period 15.893A 0 15,883:10 Total Interezt Earned during Period 195,6144.62 195,614.62. TOW Adjusftrnents from Premiums and Discounts =11,143.53 .11,1C3.53 Total Capital Gains or Losses 0-00 0.00 Total Earrings during Period 184,471.09 184,471.09 F--I Pordofo CITY APRun Dare:011' .71&27-14AS (PRF� �E@pOM1 Wu.i.3.36 1 &OUVE814f, State of California ®led Money Investment Account �qF �40 Market Valuation 1 / 1/2016 -/i Carrying Cost Plus m ip#icn Accrued Interest-Purch. Fair Value Accrued Interest United States Treasu Bills $ 11,051,332,669.56 $ 11,077,316,000.00 NA Notes $ 20,643,256,770,71 $ 20,650,936,500.00 $ 31,093,691.00 Federal Agency: SBA $ 768,121,293.93 $ 760,989,139.04 $ 486,492.50 MBS-REMICs $ 52,205,421.00 $ 55,269,562.03 $ 246,395.93 Debentures $ 875,108,937.82 $ 875,476,250.00 $ 1,399,680.25 Debentures FR $ - $ - $ - Discount Notes $ 5,979,779,777.70 $ 5,992,401,000.00 NA GNMA $ - $ - $ - Su ranational Debentures $ 349,980,433,20 $ 350,196,000.00 $ 627,916.50 Su ranational Debentures FR $ 50,000,000.00 $ 50,193,500.00 $ 25,795A4 CDs and YCDs FR $ 300.000,000,00 $ 300,000,000.00 $ 460,814.01 Bank Notes $ 600,000,000.00 $ 600,135,939.88 $ 1,694,888.90 CDs and YCDs $ 10,700,028,335.66 $ 10,699,998,794.76 $ 20,188,513,87 Commercial Paper $ 6,734,264,347.26 $ 6,742,669,319.43 NA Corporate: Bonds FR $ - $ - $ Bonds $ - $ - $ Repurchase Agreements $ - $ - $ Reverse Repurchase $ - i $ - $ Time Deposits $ 5,197,440,000.00 $ 5,197,440,000A0 NA AB 55&GF Loans 7,058,131,000.00 $ 7,058,131,000.00 NA; TOTAL Is 70,359,648,986.84 $ 70,411,153,005.14 $ 56,224,188.10 Fair Value Including Accrued Interest $ 70,467,377,193,24 Repurchase Agreements, Time Deposits,AB 55&General Fund loans, and Reverse Repurchase agreements are carried at portfolio book value(carrying cost). Item 1. - 17 11B -3 - Statement of Cash Receipts and Disbursements and Summary of Cash by Fund Finance Department October 2016 Cash Receipts and Disbursements September 2016 October 2016 Receipts General Fund Property Tax 1,535,034 170,649 Local Sales Tax 4,095,020 2,502,600. Public Safety Sales Tax 175,062 175,131 Transient Occupancy Tax Receipts (TOT) 1,178,901 963,948 Utility Users Tax(UUT) 1,769,954 1,727,414 Other Revenue 5,713,884 12,701,293' Total General Fund Revenue 14,467,855, 18,241,034 Capital Projects Funds 151,612 33,070 Debt Service Funds - - Enterprise Funds 5135,909 5,591,659 General Fund Other 6,278,819 367,811 Internal Service Funds 750,159 582,144 Special Revenue Funds 3,369,105 71,920 Grant Funds 1,244,645 207,216 Trust and Agency Funds 2,251,717 1,399,530 Total Receipts $33,649,822 $26,494;384 Disbursements General Fund Personal Services (11,629 299) (11,693,69.8) Operating Expenses (4,146,21.7) (3,467,979) Capital Expenditures 91,163 (311,497) Non-Operating Expenses (4,208) (4,208) Total General Fund Disbursements (15,688,552) (15,477,381) HB _3 1- Item 1. - 18 Capital Projects Funds (1,338,993) (231,615) Debt Service Funds (1,050) (3,049) Enterprise Funds (5 3581,087) (9,597,225) General Fund Other (2,559,804) (152,138) internal Service Funds (548;370) (515,266) Special Revenue Funds (61159,635) (409,525) Grant Funds (1,982,359) (294,533) Trust and Agency Funds (9,421,562) (1,473,518) Total Disbursements (42,058,412) (28,254,250) Net Change in Cash Flow ($8,408 590) ($1,659,866) Summary of Gash by Fund September 2016 October 2016 General Fund $60 936,229 64,647,426.25 General Fund Other 5,188,770 5,446,319 Capital Projects Funds 19;596,217 19 490,322 Debt Service Funds 12,500 9;450 Enterprise Funds 78,892,752 71,185,937 Trust and Agency Funds 10,203,046 10,308,229. Internal Service Funds 10,909006 11,025,418 Special Revenue Funds 26;400,209 26,180,450 General ledger Cash Balances $212;138,729 $208,293 552 * Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences. Note: Above information was obtained from the City's accounting system records.The above information includes receipts from maturing investments and payments for purchased investments in the city investment portfolio.This statement is prepared in compliance with the Cty's Charter. E i 3 i i Item 1. - 19 xB -)2- City of tlunfington Beach x City of HB .2000 Main St a e:. Huntington Beach. p : ;_ -��;: - Portfolio Management Portfolio Summary Ntrvember 30, Z016 Inv tits par Roar ks t Book %of Days to YTM YTU Ys4i® Value Value portfoilo Term maturity 360 Equiv, 365 Equiv. Fed"Ageocylasues-Coupon 123.405.000.00 121,136a35.55 127,52A,514.15 81,04 .1.298 1.079 1,28"3 - 1.201 .LQcW Agency Imft *rrt.Funds 30;524.011.27' 30,624,017.27 30,524.011,27 15.21 1 1 0.%9 0.676 Medium Term Notes�I8RD 3.0w,000.00 4,%7.6$0.00 4,9a1,215.31 2.48 Goa 595 1,053 1-109 CagnWe Bands 42,5D0.006.00 42,510,675,00 42,692,047.23 21.27 1,153 571 1.392 1-411 Imrestrnents 200,429,011.27 199,138,471.82 2130,721,787,96 100,00% 1,053 795 1.208 1225 Cash and Accreted Interest Accrued Inlerest at Pumha$e 50,936,67 50,836.87 Subtotal 50,930.87 5D;436.67 Total trash and Investments 200,429,011.Z7 199,189,408,49 200,772,72A,63 1,053. 795 1.208 1.225 r 1JJ LJ ' Total Earnings November 30 Month Ending Fiscal Year To Date Fiscal Year Ending Current Year 187,723,96 372,195.05 Current Sudget 140,000.00 280,000.00 1.680.000= Last Year Actual 163.744.54 330,033.53 2.299.957,00 Average Daily Balance 195,690,704.S6 196,138,818.99 Effective Rate of Return 1A7% 1.14% I certify that this report accurately reflects all City pooled investments and is in conformity With all State W4 and the investment policy statement tiled y6ttl the City Council on Novetrrbter 7,2016.A copy pt this policy is available,at the office of the City Clerk.The invastment program herein sflrsm provk*s sufficient cash flow liquidity t0 meet the next six mcrrth's obligations. Market Values provided by UniDn Sank via Inleraacfive Data Corporation. ) Alisa Cutchen,CITY TREASVRER r~f Reporting period 1110112t11ti-1113012016' P4rtfOliO Cl7`f CD AP Ron Dss:0111af2Q17.14:43 PM(FRF.PUI)7.3.0 1 A--1 CD City of HB Portfolio Management Page 1 Portfolio Details-Investments November 30,2016 Average Purchase Stated YTM Days t4 Mxwn'ty CUSIP InvestmentA Issuer Balance Date Par Value Market Value gawk Valve Rate S&P 3"tdaturity Dais Federal Agency Issues-Coupon 3133EGEV3 4140 Federal Farm Credr Bank 06115=16 5.000.000.00 4,945.850,00 S,000,DOO.00 1 S20 AA 1,620 1,656 W14P2021 313DA3TA2 4039 Fedtaal Horne Loan Bank 1213012014 5.000.003,00 5,005,SSO.00 4,999,650.58 1.000 AA 1.010 257 D61151241T 313378A43 40" Federal Hama Loan Hank 020012015 5,9D0,000.00 5,021,3WAO 5,017,148.95 1.375 AA 1A00 463.03M/2418 3130A7'AUK7 4136 Federal Home Loan Bank D512412016 5.000.001DO 4,970,35C,90 SAOD,D00,OO 1,250 AA 1.250 904-DS;2412019 313OAbDC4 4138 Federal Nome Loan Bank M3012016 $,2,59,00D.00 2.197,620.00 2,250.000.00 1.600 AA 1.600 1,490, 1213WAM 3130AST94 41$3 Federal Hu»d Loan Bank 08/10/2016 S.ODD,00D.00 4,940,750.00 S,DC0,000.00 1.050 AA 1,518 1,348 08110*020 313383VN8 4157 Federal Home Loan Bank 11/1612016 S,DDD,OD0,00 5,074,100.00 5,096.717.11 2.00D 1.297 1,016.09113P2019 3134G7U25 4117 Federal Home Loan Mort Corp 10/27/2015 5,000;OMOO 4.991.700.00 S,000,000.00 0.800 AA D.800 330 10127r2017 3134G73Q2 4120 Federal Home Loan Mort Corp 1W2712015 5,000,I)OD.00 4,968,500.00 5,000,000.00 1.000 AAA 0.991 .603 07127120t8 3134GORNS 4139 Federal Home Loan Mart Corp 0E12312016 5,000,QDO,00 4,94E,950.00 5,000,000.A0 1.250 AA 1,919 1,300 06l23M20 3134G9LIY1 4142 Federal Home Loan Mart Carp 06M/2016 5,000,DOD.00 4,994,100.00 5,DDO,C00.00 1.00D AA 1,000 575 06J2912018 3134GOF93 4148 Federal Home Loan Mork Carp O6f3W2D16 5.000,000.00 4,928,000,00 5,000,0©.0o 1,000 AAA 0.998 939 06126/2R14 3134G9E78 4149 Federal Houle Loan Mart Carp 06r30/2016 S,000,000.A4 4,850,900.00 5.090,000.00 11290 AAA 1.280 1,399 0913tl 10 3134GSC54 4150 Federal Horne Loan Mort Corp 0613W2016 4,655,000,D0 4,528,430:55 4.655,Cm.Do 1.500 AA 1.500 1,672 06f3012021 3134GSG35 4161 Federal H.o:ne Low Mort Carp D613Qr2016 5,000,000.00 4.943,400.00 S,000 000.00 1.000 AAA 1.592 1.672 06t3012021 3134GAUSS 4156 Federal H.orno Lose 1NnrtC" 11/2212016 5,000,000.00 4,859,260.00 5,000,000.00 1.660 AA 1.650 1.817 11/2212021 4=- 31SOG2R58 4122 Fed-Nall Mort Assoc. 10/29/2015 5.000,000.00 4,992;650.00 5.000.000,00 1.040 AA 1.040 694 1Or'2612D18 r 3135G02LO 4132 Fed.Nall MAR Assoc. 031D9M16 5,0D0,000.00 5,000,000.A0 S,DD8,142.65 1.000 AA 0.800. 300 D9f37=17 3135GCKSS 4137 Fed.NaCI Mom Assoc. 06113r2016 5.000,00C.00 4,954,459.00 5,000,000.00 1,400 AA 1.400 924 0611312Oi 9 3136G3SJ5 4141 zed.Nall Mort Assoc. 0613W2016 5,000.000,00 4,832,200,00 4,998,0.54,8E 1.5DO AA 'LSA5 1.672 06130/2021 313&G3SN6 4143 Fed,Nall Mart Assoc, 06123r2016 3,000,00.00. 2%7,96100 3.000,000.00 1SDO AA 1,5)0 1,483 1212=020. 3135GCK93 4144 Fed.Nall Mort Assoc. 06128r2016 5,000.000.00 4,978.400.00 S,ODD;000.00 1,250 AA 1.250 939 06f2917019 313SWUTO 4146 Pod,Nail MorL Assoc. 06/3012016 5,000,0DO.00 4,879,900.00 5.000.000.00 1.500 AA 1.500 1,490 12134fZ= 3135G3VL16 4147 Fed.Nall MArL Assoc, 071IM016 5,000.CDO.OD 4,975,100.00 5;100,000.00 1,125 AA 1.819 1,691. 07 0 1 91=21 3:36G3YCA 4152 Fed.Natl MorL Assoc. 07Ct512016 7,500.0=0 7.41E;775.00 71500,000:D0 1,000 AA 1.000 675 04/25/2019 Subtotal arW Average 120,144,SUAC 122ASS.D00.00 121,136,23SAS 122,$214,514.1$ 1.30i 1,079 L,ACaI Agency Investment Funds SYS982 S82 L"aty 30,524,011.27 30,524,011.27 30.624,011.27 0,876 0.678 1 Subtotal and Averaga 30,690,677.94 30,524,011227 30;524,011.27 30.624,L11.1.27 0.678 1 Medium Term Hates-18RD 459058FES 4159 Intl Bk Recan&Devetopmenl 11118,2015 5,000,000.00 4,967,650.00 4.951,216 31 0,676 AAA 1.109 595.07119f1A18 Subtatil and Average 2,158,443.57 5,000,000.00 4,967,550.00 4,991,215-31 1.109 $55 Par OVO CITY AP Run 0=7 4111872017-14.48 PM 1PRF_PIUM)7.3.0 Repod Ver.7.O.ab City of HS Portfolio Management 2 Portfolio Details-Investments November 30,2016 CLISEP tmreatrnent# laauer Average Purchase Stated YT4t to Luwrlty Balance Data Paz Value Market Value Bonk Value Rape S&P 365 Maturity f1sft0 Corporate Bonds 06406HCZO 415$ Bank of New York 10/24/2016 5,000,00a.00 4,992,250.00 S,Ca3,445.25 2.150 A 1.617 1.180 0224/2020 14912LSP2 4024 CaterpolarFinancial:CDrp. 12/10/2014 3,000;0➢600 2,993,aSD,00 2,990,597.67 11300 A 1.555 455 0=112018 17275RBG6 4154 Cisco swe'ns inn 09127=16 3,000,0➢0A0 2;965,38100 3,007,955.40 1.400 AA 1,303 1,023 09202019 166764AAS 4C,44. Chev=Corp 02109l2015 3,ODO.M.00 2,994,420.00 3,M1,009.45 1,104 AA 1.003 369 17J@]52D77 268648AP7 4077 EUC Corp 07/142015 2.540.020,60 2,463,450.00 2.508.930,57 1,875 AA 1.630 647 061012018 36962,vS D 3994 Generei Electric Cop&W Carp 12/262013 5,040,0{ 00 5,024,7D3,O0 $.0%961.03 2.300 AAA 1.291 147 04WM17 389$2G$Y.5 40D7 General Electric CaAilal Corp 05112201d 2,500,000.00 2.508,525.➢0 2.506.130.90 1.800 AA 1.W 354 11120F2417 30.62GiVO 4035 General vectric Capital Corp 12/19/2014 2,000;00=0 2,006,240.00 2;04.762.84 1.4255 AA 1.442 487 040=013 244229SR1 4126 John Deere Capital 1MBQ015 1,C00,0tl0,OO 1,003.70,W %GOZO42.34 1.Sfi0 A 1.350 379 12116=17 24422ESR1. 4127 ,Rohm boom Capital 12/082015 200,000.00 2.007,600,00 2,0041341.90 1,640 A 1.337 379 12MSM17 1912169A.7 4049 'Coca Cola Cp 02f2.42015 2,540,000AG 2.493.550.00 2,496,487,02 1,160 AA 1.258 486 04JOI*018 68933YAC9 4045 Merck$CO Inc 0=912015 2;000,001100 1,995,440,% 2,C00.907.84 1.100 AA 1,039 426 01P312D18 ez3"XAQ8 4071 Orade Corp 0526f2015 3,Oa0,D09Atl 3,043,S5O.CO 3,039,606.60 2.375 AA 1.731 T75 0IA512019 .Z 11MIA' O 40,23 Toyota Meter Credit 12/10/2014 3,000,000.00 2,999,010,00 2.06,225.58 1.375 AA 1.491 405.O1l102013 7 9922STAYJ 4039 Toyota Wor Credit 0112612015 3.000,000A0 3,013,660.00 3,027,54iU 2-OW AA 1,500 692.10rZV2018 r Subtotal and Average 42,697,014.6$ 42;500,000.00 42,510,675.00 42;592,047.23 1.411 $71 Vr r TOW and Average 195,690,7"M 200,429,01137 199,138,471.42 200,721,787.96 1.225 795 l--N E7vrtFDliD CITY R Dsre:alhlkn0s7.14:48 Pry 1PRF�27 7� n t N CD ' City of HB Portfolio Management Page 3 Portfolio Details-Cash November 30, 2016 CUSt? Investment# Issuer Average Purchase Stated YrM .Daysto Salome Date Pau value Market Vakm Book Vatue. Rate S&P Iti"t9tyr Average Balance O.00 Ao=ed Interest at Purchase 50,936.67 $0,936.67 0 Suhktal 50,936.67 50,936.67 TcUI Cash and lavestmerts 195.690.704.66 2O0,429,Ot1-27 199.183.40&49 200,772,72443 1.225 73S :JJ Pt doll4 MY - AP Rene Cow.0111=017-14.48 P4A(Pltf 1'tt4)7.9.0 City of HB Portfolio Management Paso I Activity By Type November 1,2016 through November 30,2016 Stated Transactlon Purchases Redemptions CUSIP Investmew p Issuer hate Oats or DaposHs or Wiithdravials Balance Federal Agency lssues-Coupon 313MVN8 4157 Feden d 14ome Loan Bank 2,000 11116I2016 5,097,150.00 0.00 3134GAUBS 4165 Federal Home Loan Mort Cole 1.65C 111=016 5,000,000.00 O.tlp 313-5CARK1 3945 Fed,Nail MorL Assoc. 0.900 11107=16 0.00 5,U00.000.00 313GG3KM6 4136 Fed.Nell Mort Assoc. 1.10C 11117/2016 0.00 5,00Q,000.00 Suhtoul 10.097.150.00 10,000,000.00 1=524,514.75 Local Agency In"stmerrt Funds (OAvn"Summary) sy 82 982 Lait City 0.675 10,00a.050.00 43.aa0,0p0.00 Subtotal 10,000,000.00 9,000A00:0o 30$24,611.27 Medium Tenn Notes-ISRO - - 459o58F88 4158 Intl Sk Recon 6 Dealopment 0.876 11I187016 4,980.800.00: 0.00 Subtotal _ 4,980.900.00 0.00 4,981,215.31 cc Corporate Bonds 3 Subtotal 47,692,047.23 Total 25,077,950.00 i9,000,000.D0 200,721,7a7.96 FBI r-F CD Powatl0 CITY AP Real Dare:0111Brlrll!_141.4 PM(PRF-PAd3)7.3.0 --` . Repot Ymr.-7.3.'.As t t� ra City of HB Portfolio Management page 1 Activity Summary November 2015 through November 2016 _ Y*Id to YAab►rity Managed Number Ftumber hfAnrll Numbers! Av"* 360 30S Path or Inveswrtem Of Invespromft Average Average End Year SecurWes tlahace Equivalent Equivalent Rate Puiroharsad Redeemed Term D"s to Maturity November 2015 39 181.304,552.62 1 no 1217 0.374 1 3 1.174 933 December 2015 46 186,878,1MV 14238 1.255 0.400 8 t 1,147 926 January 2016 46 20"7,140.11,1:69 1.243 1261 0.446 0 0 1.147 898 February 2016 43. 204,413,571.12 1,2.11 1234 0.467 0 3 1.102 832 March 2016 47 201.877.568.13, 1232 1.249 0.506 4 0 1.144 859 April 2016 45 204,141,812:62 1Z80 1.298 DZ25 0 2 1.101 893 may 2016 44 268.914mm-w 1168 1.184 .0.552 2 3 976 736 June 2016 46 228.822.479.77 1.156 1,172 0.578 14 12 1.006 806 July 201E 45 230.059,053.62 1.167 1.183 0.588 2 3 1,044 930 August 2016 45 220.520.888.69 1.186 1.203 0.614 1 1 1.074 831 September 2016 43 208.478.917.26 1205 1,222 0.634 1 3 1,114 835 October 2016 41 196.572.478A0 1207 1.224 0.854 1 3 1.090 807 movember 2016 42 195,690.704.56 1208 1.226 0.678 3 2 1.053 79S T Average 44 205,787,875.30. 1.208-& 1.2251A 0,540 3 3 1,696 845 cC PtirtfcAo CITY AP fkxe:mrir ell-ta;.e6 PIA(PFV�_PW)7.3.0 Ropari Ver..7,3,36 City of H8 Portfolio Management Page 1 Interest Earnings Summary November 30, 2016 Novrernber 30 rd*Mh Ending Fiscal Year To Date CD1Cau -ponlGiacaunt Investments- Interest Interest collected 101.250.00 312,250,00 Pius A=ued interest at End of Period 830:¢60,94 630.550.94 Leas Awrued InWrest at beginning of Peraod ( 547;99$.18) ( 576266.66): LCM-Acdxued Interest at Purchaset7urng Period ( 0.00) Interest Earred during Period 183,802.76 363.534.28 Adjusted by Prarniums and Mcount5 -13181,49 •24.325.02 Adjusted by Capital Gains or Losses 0.00- 0.00 Earnings during Periods 170.621.27 339.209.26 Pass Through Securities: IIntemst Collected ODD 0.00 MIS Accrued Interest at End of Period 0,00 0.00 CC7 Less Accrued Interest at peg inning of Period ( D.00) ( 0.0,0) '., Leas Accrued Interest at Purchase During Period ( 0.00) ( 0A0) v7 ' Interest Earned during Period (1.00 0.00 Adjusted by Premiums and Discounts 0.00 000 Adjusters by Capital Gains of Losses fl.00 0.00: Earnings during Periods 0.00 O.OD CashlEhocking Accounts: Interest Collected 0.00 61.729.76 Plus Accrued Interest at End of Period 35.167.08 35.167.08 LessAcen.ed Inierest.etSeginning of Period ( 18,064.39) ( 63.911.05) interest Earned during Period 17.102,69 32,W.79' TOUT Interest Earned during Period 200,905.45 396,520.07 Total Adfljustments from Prom iums and DiScounW -13,181,49 •24,325.02 Tofaf Capital Gains or losses 0.00 0.00 Total Earnings during Period 187,723.9E 372,195.05 Portfolio CITY. CID AP Run 6d2C:v1178rY077.74;48 PM(MR_PW)7A0 Ropon.Ver,?Azb t N ' � � � � � � � � � � State of California Pooled Money Investment Account Market Valuation 11130/2016 Carrying Cost Plus Description Accrued Interest Purch. Fair Value Accrued Interest United States Treasury: Federal Agency: � Fair Value Including Accrued Interest $ 70,431,997.18783 Repurchase Agreements, Time Deposits,AB55&General Fund loans, and Reverse Repurchase agreements are carried at portfolio book value(carrying cost). Item l . - 77 1R '40- Statement of Cash Receipts and Disbursements and Summary of Cash by Fund Finance.Department November 2016 Cash Receipts and Disbursements October 2016 November 2616 Receipts Genera!Fund Property Tax 170,648 5,694,548 Local Sales Tax 2,502,600 3,336,800 Public Safety Sales Tax 175,131 167;979 Transient Occupancy Tax Receipts (TOT) 963,948 926,955 Utility Users Tax(UUT) 1,727,414 1,585,747 Other Revenue 12,701,293 4,472,949. Total General Fund Revenue 18,241,034 16,184,08 Capital Projects Funds 33,070 100 Debt Service Funds - - Enterprise Funds 5,591,659 4,599,427 General Fund Other 367,911 462,595 Internal Service Funds 582,144 593,441 Special Revenue Funds 71,920 1,130,158 Grant Funds 207,216 546,050 Trust and Agency Funds 1,399,530 1,004,512 Total Receipts $26,494,384 $24,521,262 Disbursements General Fund Personal Services (11,693,698) (11,747,325) Operating Expenses (3,467,979) (3,702,003) Capital Expenditures {311,497} (894,2$0) Non-Operating Expenses (4,208) (386,942) Total General Fund Disbursements (15,477,381) (16,730,550) i K -41- Item 1. - 28 Capital Projects Funds (231,615) (136,247) Debt Service Funds (3,049) (2,000) Enterprise Funds (9,597,225,) (3,659,013) General Fund Other (152,13H) (346,054) Internal Service Funds (515,266) (339,793) Special Revenue Funds (409,525) (1,115,649) Grant Funds (294,533) (508,018) Trust and Agency Funds (1,473,518) (947,727) Total Disbursements (28,154,250) (23,785,052) Net Change in Cash Flow ($1,659,866) $736,210 Summary of Cash by Fund October 2016 November 2016 General Fund $64,647,426 63,463,276 General Fund Other 5,446,319 5,593,037 Capital Projects Funds 19,490,322 20,631,273 Debt Service Funds 9,450 60,960 Enterprise Funds 71,185,937 72,756,073 Trust and Agency Funds 10,308,229 10,344,494 Internal Service Funds 11,025,418 11,365,253 Special Revenue Funds 26,180,450 26,617,593 General Ledger Cash Balances $208,293,552 $210,831,1958 Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences. Note' Above information was obtained from the City's accounting system records.The above information includes receipts from maturing investments and payments for purchased investments in the city investment portfolio.This statement is prepared in compliance with the City's Charter. Item 1. - 29 HB -42- k�ptLTlAdSp�?r ~° City of hlun5rlgton Beach s City of HB 2mmHantaa' gtan Beacair st, Portfolio Management Portfolio Summary December 31,2016 Irrvestrlrerrts Par Mark4t Book Of Qaysto Y7M YRR Valuer Value Vallee Portfolio Tans lWanddy 360 Equiv. 355 E4uiv. Federal Agency Issues-Coupon t42,405,0oo.04 140,938,620,15 142A2$,593,% CB.w 1,347 1.130 1.403 1.422 Local Agency Inva went Funds 21,524,011.27 21,524,011.27 21,524,011 27 10.07 1 1 O.709 0.719 Medium Team Note&-ISRp 5,004,000.00 4,968,800.00 4.9$2.173.71 Z33 608 564 1.093 1.109 CorporalcBond* 44,500,0oo.00 44,491,620.00 44,672,115.16 20.50 1,154 568 1.41a 1.438 Investments 213,429,011.37 211,923,081,42 213;,70%M.39 1W.00% 1,154 =6 1,329 1.348 Cash and Accrued Interest Accrued Interest at Purchase s2.736.67 62,736 67 Subtotal 52.73657 62.736.07 Total Cash and Investments 213,429,011.27 211,985,788.09 213,769,730.06 1,164 $as 1.228 1.348 Total Earnings December 31 Month Ending Fis4W Year To Date Fmcal Year Ending Current Year 200.299.49 572,493.54 Current Budget 140,0ft0.00 420.00o.00 1,680,600:00 Last Year Actual 169.639.27 499,57ZS0 2,2",957.00 Average Daily glance 199,391,624.24 196,897,91%Al Effective Rate of Return 1.10% J.is% I certify that this report a=rallely reflects all City pocked Investments and is in conformity with all State Saws and the krAsstment policy statement filed wish the City Council on November 7,2016.A dopy of this policy is available at the office oflhe City Clerk The mvestment program Therein shown provides sulfkc ent cash slow liquo r to meet the elect six msonth's obligations. Market Valdes provided by union Bar1k via Interactive Data Corporation. Q Cy Afta Cutchen,CITY TREASURER i--I Reporting period 121011MG-12131f2016 Portfolio CITY r-F ASP Run 044K OffafZ017.r IM 18 PM(PRF PM7)7.3:D T<eponva;'Y:3ad 1 W ..._._......... _............................_.............................. ................_....................__... .._ •l City of HB Portfolio Management p Portfolio Details Investments age I December 31,2016 Average Purchase Su wA YTM Days to alawow CIISIP lnveMount4 Lauer 14abu+ Date Parvwue Markotvakre Bookvalue Rate S&P 365141a®uft Date Fedoral Agency Issues-Coupon 3133EGE'v3 4140 Federal Farm tradit Bank OWSW16 S,000.000.00 4,930.400.00 5,000.040.00 1,620 AA 1.620 1,525. OBi14,2021 3133EG2L8 4160 Federal Farris Credo Stank 121 V"16 S.00D,000.00 5,014,850.00 5,0M931:35 1.920 1.873 1.457 1278,2020 313OA3TA2 4030 Federal Home 1pan.Bank 12130r2014 S,OOO,000.DO 5,006,900100 4,999,691.85 tow AA 1.Ot0 226 OBAS2017 31337BA43 404a. Fedmral Home Low Sank D2120MIS 5.DDO,000.00 5,017,900.00 5.016.025,66 1,37S AA 1.100 432 03M9,12018 313OA7WK7 4136 Fedami Home Loans Bank 05i2412016 S.oOD„OD0,00 4.962,150,00 5.000,000.00 1.250 AA 1350 873 OSt242019 313Wa$DC4 4138 Federal Home lags Bank OW33o1 16 2250,000.00 2,1M US.00 2,?.5t1.000.00 1.600 AA 1.6oD 1.459 12noMO20 3130ACT94 4163. Federal H nse Loan Bank Osmolnio 5.00D,O0o.DO 4.937,650.00 S.M.000.00 1.D51) AA 1.519 1,317 O&MOM02D 31338WNa 4157 Federal Horne Loan Bank 1111G/2016 5,000,000.00 5,046.750.00 5,082.851.33 2,000 1.297 885 09f13=19 3.134G7Lr25 4117 FedeoW Horne Loan Mort Corp 1O,2772015 5,00D,000,0() 4,994,300.00 5,000,000.00 0.800 AA a.80o 299 10727,2017 3134G7302 4120 Federal Horne Loan.Mort Corp 1027/2015 5.MO.000.00 4.265.150,00 5,000,000,00 1.000 AAA 0.991 572 07t2T=19 3134G9R319 4139 Federal Horne Loan Mon Carp 06/23{2016 5.DDD,000.DO 4,938,450.00 5.000.000.00 1.750 AA 1„919 1269 06t23F2020 3134G9t1Y1 4142 Fedwl Home l oan Mart Corp 06tZ912016 5,000,000.00 "92.100.DO 51000.000.00 1.000 AA 1.000 544 Omwz018 3134GSF23 4148 Federal Horrld loan Mon Corp OW3012016 S,000„000.00 4.919,250.00 5.000,000.00 1.000 AAA 0,998 908 OWt2812019 3134G9E78. 4149 Federal Home Loan M6rt Carp 06r3012D16 S.GDD„ODO,DO 4;840,450.00 6,000.000.00 1 MD AAA 1.280 1.369 09t3WZ= 313409C54 4150 Federal Hnrtse Loan Mort Corp Q6d3=16 4X46.000.00 4.515,955.15 4,655,000.00 1,Sa0 AA 1,500 1,541 O6r302021 3134GISG35 4151 Federat Herne Loan Mort Carp 0=012016 S,000,000.00 4,937,750.00 S.M0,000.00 1.000 AAA 1.592 1.641 osam021 3134GAUSO 4166. FedwW Houle Lean Most Corp 11122W16 5,00D,000.00 4,844.,100.a0 5,000,000.00 i.:5SO AA 1.650 1.786 1V222021 i 31344GAA934 4163 Federal Horne.Lunn Mort.CArp 12i3a,2O19 5,000,000,00 4,999„850.DO S.ODO,000.0D 1.000 2,787 1,824 12P.70l2O21 3136G2Ft58 4122 Fed,Nail Mori Assoc. 1012912D15 S,ODO,000.0o 4,989.900.00 S.DDO,000.00 1.040 AA 1.040 893 1Ot2W2018 3135GO&O 4132 Fed,Nat)Mort Asaae. 03IO912016 5,OOD,OOD.00 5,004,70OA0 5,007.317.38 1,000 AA 0.000 269 09a712017 3135G01035. 4137 Fell.NSt7 Mort Assoc, Obi 1 W2016 S,ODD„0a0.DD 4,974.250-00 5,0 0,000,00 1AOO AA 1AOO 993 0611312019 31 6G3S,15 4141 Fed.Nail Mort.Assoc. 06f30r2O16 5,0DD„000.00 4„919.450.00 4,998,B75.69 1.500 AA 1.505 1.641 DW3012021 3136G3SH6 4143 Fed.Nan MorL Assoc. 0623r2D15 3,00D,000.00 2.901210.00 3.000,000.00 1.500 AA 1,500 1.452 17J2312020 3135GOK93 41" Fed.Natl Mart Assoc. 0%7W2D76 5.000,000.01) 4,972.150.00 5.000,000.00 1.250 AA 1.2$0 908 O6I=019 3136G3UTO 41" Fed.Nail Mort Assoc. 0"0=16 S,ODO,000.00 4,$63 ZW OG S,ODO.000.00 1_500 AA 1.500 1.459 7213072020 313G.G3vll6 4147 Fed.Natl Mort Aasm 07AS12016 5,ODD,0D0.00 4,976,500.00 6,000.000.00 1A25 AA 1.819 1,660 07119,2021 :3136G3YG4 41$2 Fed.Nail Mort Assoc. 07f252016 7,SDO.000.00 7,415,6SOA0 7,500.000,00 11000 AA, 1.000 844 04MS,2019 313ssmi s 4159 Fed.Narl Mort Assoc,. 12102r2016 5,ODD.M.00 4,961,700,00 5,000,000.00 1.950 1.950 1,796 12i=021 3136G4KN2 4161 Fed..Nail MorL Assoc. 1213012015 5,OD0,00.00 5,00G,50D.00 5,000,000,00 2650 AA 2.OS0 1.4S9 i213DM020 S:ubbAM and Average 128,652,170,91 U,2 435.000,00 140,938,6=.15 14 _C28,693.2S 1.422 1,130 Local Agency investment Funds SYS982 982_ LaS.Clty 21.524,011.27 21.S24,01127 21.524.011-27 0119 0,719 1 SubWWandAverage 21,814,333.8.E 21,624,011.27 21,524,01117 21,534,011.27 0.719 1 Partta6o CITY AP Rssr 03R6"..Ol IM017.13:56 Ropon Yer.7..3.3b City of HB Portfolio Management Page Portfolio Details-investments December 31, 2016 Ci1SIP b1►"OSkYrlerltS Issuer Avers * purnhase m 9 Staled YIAq [17ryE t9 1y1,1trr Balance hake Par Value Market Value Bonk Value Rats S&P 365 htatu ft pate Medium.Term NHS-18RD 454059F&5 4196 Intl&k Reoon S Development 11118=15 5,000,000.00 4.968,800,00 4,982,173.71 0.876 AAA 1.109 564 D711 912 01 8 Suhtcotal and Average 4.9111.725.41 5„OOO,Op QO 4,965,81 Ao 4,982,173.71 1.109 S94 CorporAo Sondr. OS40SHCZD 4155 Bank of New York 1=412014* 5,000,000.00 4.986.300,00 5.081.292.75 2.150 A 1 A17 1.149 02124riM 14912LSP2 4024 C'"Maar F'mancol Corp. 1211012014 3.000.000.30 2 993,130.00 2,991,317.53 1.300 A 1.555 424 D3J0112018 17275ROGS 4454 Cisco 5ystr nts Inc 09127,2016 3,000,400.00 2,967,300.00 3,007,718,86 1AOO AA 1,203 992 D5l2D/ZO1$ IW64AAS 40" GhevranCovp 02*9la.D15 3,000,00D,00 2,993.220.% 3,002,764.42 1.104 AA 1,003 338 IZIOS O1.7' 2SU46AP7 4077 EMC Corp 917 2015 2,500,000.01) Z472,300M 2,509,434..43 1..875 AA 1,630 $10 D5101=19 86962i3WM 3VU GeneralMWACt Capu Corp 121z=013, 5,000,DpO.OD 5,015,100.00 5,015,859,4E 2,300 AAA 1.291 116 042712017 36962GSKS 400-1 Gmeral Electric Capa2l Corp 05/12/2014 2.54D;ODO.DO 2,908,675.00 2,505,603.08 1,600 AA 1.340 323 1 if2012O17 36962GSM 4036 General Eleclri0 Capital 12f19r201R 2.000.000,00 2,006,540;D4 2.004.465.78 1.625 AA 1.442 456 D41O2r2018 Z4422ESRI 4126 John Deere CaVU 1VO6PZ015 1,00O,000.0IS 1,002,540.00 1{101,878..51 1.550 A 1.350 348 12J15r2017 244m,$R1 4127 Jahn Demur C3pita{ 121O81ms 2,000,000.00 2.009.080,00 2,OD3,993.62 1.Sa8 A 1.337 348 12115r2017 4943688P7 4164 Kimberly Clack Corp 1212er2016 2,000,DORAO 1,996,060.00 1„99D,U$Ai 1.950 2.008 1.165 0310112020 " 1912165A7 4042 Coca Cola Co D8l24=5 2,500,000.00 2,494,325.00 2,496,700.55 1.160 AA. 1.258 455 O4R31/2018 Jr 58933YACS 4045 hlffft*&CO I 02109122015 2,OOO.000.00 1,995,900.00 2.800;842,65 1.100 AA 1.089 395 01131P,2016 " 5838SXAR8 4071 Orade Corp OS1261201S 3,000,woxo 3,040,170 D0 3,039,951.37 2,376 AA 1,731 744 01115*019 8923SPTEG 4023 Toyota Motor Credit 1?110=14 3,000,000.00 2,996,220.00 2,996,609.46 1.375 AA 1.491 374 0111=018 69236TAY1 4039 Toyota Motor Credit 01126r als 3.000,000,00 3,017,780.D0 3,025,933.18 2.000 AA 1.500 661 1D12412018 Subtotal and Average 42,OAa3.39a.95 44,"A".00 44AM,620.00 44,872,115.16 IA38 568 Tvul and Average ISSA i,624.24 213,4x@,;011.27 211,9=051.42 213.70"%3,39 1.348 986 9®f PoffC iO CITY ,--t AP Run Dala:D111 8201 7-13:56 F%'C+RF_Pp17.3.6 0-4 c.+ 0 City of HB w Portfolio Management paw Portfolio Details -Gash December 31,2016 C!7&IP tn,vmmdnxl# la5uer Average Purchase stated rrM 0 aye to Secants Rate Per Valve Markot Value Beak VaAta Ram S&P 365 Maturflyr Average ManvLe 0.00 Accrued Vte ao at Pur io" E2,736.67 52,736 67 0 8ubiaud 62.736.67 52,73E_67 Tailat Cash and tnvesW*rft IS&M9;624.24 213,423,011.27 211.S".7s"S 213,769,730AS 1.m Us CT P4rt#e6a CITY AP Run}7ateC 07PF8RU77-13•..56 pm(PR; pwi2)'T Z O City of HB Portfolio Management Activity By Type Qe 1 December 1, 2016 through Oecember 31,2016 SteAd Transaction Pmehamas Redemptions CUSIF Investment 9i Iaswer Rate Bade ar Deposits ar WRkdrarsawls Balance Federal Agency Issues-Coulon 3133EG2L8 4160 Few Form Credit Bank 1.$24 12MM016 5;008,950.00 0.00 3134CAE34 41e3 Fed&*:Home Loan:Mort Corp 1.000 12awo15 5.Og0,000.rR7 0.00 3135G4HU0 4159 Ft&Nat{Shan:Assoc. 1.950 12102ME 5,000.0MOO 0" 3136G4KN2 4161 Fed Nan rearL Asrae, 2.050 IZ-4 2016 -5.U60.4b0.0t1 0.00 $upfptal 20.008.950A0 0.00 142,526,693.26 Local Agency Investment Funds (MantIdy Summary) SYS982. 982 L-&Cky 0,719 0.00 9.000.000.00 5uetotal 0 00 9A00,000A0 21,524,011.27 Nled-rurrr Term Nctes-IBRD 4,982,173.71 Corporate Bonds 7 494388BP7 4164 iGMtiertyr Cta*Corp 1.850 urzmo16 1.900.32R�7 O,UD i V Subbotal 1,990,SZSk.6D .9.OD 44„072,115.15 Total 21,999,270A0 213,706,9Un F'ortfotio CITY AP Run DOUK o1 IM017-1156 . f741{WtFf 7.3.0 3..r kwort vor.7.3.3D r W [4 +� City of HB Portfolio Management page 1 Activity Summary December 2015 through December 2016 Yield to Maturity Managed Number Number wo"th ftmwof Average Year .'�eOUr Average Equiva 360_ 389 Pool of Inves6nonts of InV021n �s Average Average. End lent Equivalent Recto Pumba ed Redeomod Term pays tollaZrn4Ly. December 2015 46 186.876,180.67 1.238 1.265 0.400 8 1 1,147 925 January 2018 46 207,140,111.69 1.243 1261 0.446 0 0 1,147 898 Fabruary 2016 43 204,413,571.12 1.217 1.234 0.467 0 3 1.102 832 March 2016 47 201,877.568.13 1.232 1249 0.506 4 0 1,140 M April 2016 45 204,141,81Z62 1.280 1.298 0.525 0 2 1,181 893 May 2016 44 209,914.65620 1.168 1,184 0.552 2 3 976 736 June 2016 46 228,822.479.77 1.156 1.172 0.576 14 12 11006 $06 July 2018 4$ 230,059,053.52 1.167 1.183 0.588 2 3 1.044 930 August 2016 45 220,520.888.69 Liss 1,203 0.614 1 1 1,074 B31 September 2016 43 208,478.917.26 1205 1.222 0.634 1 3 1,114 935 Oember 2016 4" 196,572,47&10 1.207 1224 0,654 1 3 1,090 807 November 2016 42 195,690.704.56 1208 1225 0.678 3 2 1,053 795 Z December 2016 47 198,391,624.24 1.329 1.348 0.719 5 0 1,154 886 Avers$o 4S 207,060;45SA2 1.213% 1=35% 0.666 3 3 1,094 842 cc r Portfoflo CITY AP Rim Dale,d11fBtd ?-17,% F'l it MRF_PU4j7,3.6 fiopan vat.7.3.3b City of HB Portfolio Management Page 1 Distribution of Inves#ments By Type December 2015 through December 2016 December January F►bruary March AptV RWy June July August SePtNT4;er October Noven36w December Average Security Type 2015 2016 20IG 2016 2016 zms 2015 2010 2016 2016 21"S 20'1S 2D18 by Period Repurchase Agreements _e.._... ... --- --- Certit-re�1les of Deposit ......... _.._ __ . ...._...__ _. Cornmerrcial Papar-1rrEerest Bearing ... . .m....... ....... .. ._ .. _......_ ,-- _. ..... Federal ASency Issues-Coupon 68.1 68.1 MO 69.2 71.1 591 60,11 62.9 652 68.9 G2-9 61.0 66.7 65A% LoeslAgerlcylnvestmentFunds 12.2 12.3 13.1 11.9 7.9 24.0 24.0 2p.5 17.6 11.7 15.2 15.2 1D.1 15.1% _.-... ....... .......... ........_ _._. .. . Treasury Secu Mies-'Coupon Medium ESRD 2.5 2.3 0.4% .._ .............. CerliTicates of Deposit.Bank ...... ....... _ Corporate Bonds 19.7 19.6 21.O 19.0 20.9 15.3 1&0 16.6 171 19.5 21.9 21.3 20.9 19.2% mortgage Hacked Securities Hankers Accep rwms Amortizing Commercial Paper Disc.,Amortizing Fedesa!Age nay D1sc.-Amertkdag Treasury Diseoums-Arreastiz9ng . w Ifteeilaneoues Discounts-Amortizing __.... ' Money mirlust Acet PassbooklChecking Accounts-3 ....................... . . ............. _.. ...__ . Rolfing Repurchase Agreementx 1-[ Portlolbo CITY AP Runovv,0141artr?-13:50 PM.{PRF P15j 7a.0 ReponVx..7.&3b 1 (n I City of HB —A Portfolio Management Page 1 Interest Earnings Summary December3l,2016 DOwMk r 31 Month Ending Fiscal Year To Dam CLIICouponit7ixcourrt Irrvo$ lerAs: Interest Collected 426.15722 738,407.22 Plus Accn*d ktarest at End of Period 405.43$k9 405.435.69 Less Accrued Interest at Beginning of Period ( 680.550.94) { ",2ss.66y Less Accrued Interest at Purchase during Period ( 0.00) 0.00).. Interest Earned during Period 20i,04L97 564.576.25 Adjusted by Prerniurrrs and Oise -14,064.$7 -38.389.59 Adjusted by Capital Gain or Losses Oku 0 00 Ea mings during Periods 186,977,40 526.186.66 Pass Through Secedes: Interest Collected 0.00 0.00 Pius Accrued Interest at End of Period t!_00 0,00 Less Aoxxued Interest at Beginning of Period ( 0.00) ( 0.00) Less Accrued Interest at Purchase d Period yr � f 0.00) ( 0.00) interest Earned during Period 0.00 0.00 Adjuster!by Prernkmx and Discounts 0.00 9.00 Adjusted by Gapitat Gains or Losses 0.06 0.00 Earnings during Periods 0.00 0,00 CashlChecking Accounts, Interest Collected 0.00 61,729-76 Plus Accrued Interest at End of Period 48,488,17 48,4W17 LessAcrasaed InVerest at Begirnliv of Period ( 35,167.08) { 63,911.05) Interest Earned during Period 13,321.09 46,306.88 Total Interest Earned during Period 214,363.06 810,S8 13 Total A4ustments from Premiun s and Discounts •14,064S7 .38,33g,59 Total Capital Gain!or Losses 0.00 0.00 Total Earnings during PerW 200,298AS 572,4MU Portfotio CITY AP aes IPRF, I 7.3,0 rrm...7�3ti %%vES State of California Pooled Money Investment Account 3cm Market Valuation t'"Paui4 12/31/20 1 6 Carrying Cost Plus Description Accrued Interest Purch. ,', ortized Cost Fair Value Accrued frtit 1* United States Treasu Bills $ 11,446,490,727.80 $ 11,469,093,813.84 $ 11,466,957,500.00 NA Notes $ 21,240,182,012.60 $ 21,237,355,143.84 $ 21,210,171,500.00 $ 32,928,180.00 1* Federal A enc SBA $ 792,593,999,73 $ 792,573,777.77 $ 785,274,949.19 $ 502,068.60 MBS-REMICs $ 49,039,552,21 $ 49,039,552.21 $ 51,627,495.79 $ 231,374.63 Debentures $ 1,025,076,967,25 $ 1,025,067,245.03 $ 1,021,615,500.00 $ 2,160,598.00 Debentures FR $ - $ - $ - $ - Discount Notes $ 7,173,45%944.34 $ 7,187,429,402.88 $ 7,187,637,000,00 NA GNMA $ - $ $ - $ - 1* Su ranational Debentures $ 299,974,475.25 $ 299,974,475,25 $ 298,367,000.00 $ 713,263.50 1* Su ranational Debentures FR $ 50,000,000.00 $ 50,000,000.00 $ 49,988,000.00 $ 108,611,11 2* CDs and YCDs FR $ 300,000,000.00 $ 300,000,000.00 $ 300,000,000.00 $ 457,592.31 2* Bank Notes $ 600,000 000.00 $ 600,000,000,00 $ 599,926,626.16 $ 2,316,861.11 2* CDs and YCDs $ 10,750,000,000A0 $ 10,750,000,000.00 $ 10,746,696,134.35 $ 23,101,888.89 2* Commercial Paper $ 6,584,098,055.50 $ 6,591,520,541.63 $ 6,591,285,159.72 NA 1* Corporate: Bonds FR $ - $ $ - $ Bonds $ - $ $ - $ 1* Repurchase Agreements $ $ $ - $ - 1* Reverse Repurchase $ S $ - $ - Time Deposits $ 5,286,440,000.00 $ 5,286,440,000.00 $ 5,286,440,000.00 NA AB 55&GF Loans $ 8,135,851,000.00 $ 8,135,851,000.00 $ 8,135,851,000.00 NA TOTAL $ 73,733,206,734.68 $ 73,774,344,952.45 $ 73,731,837,865.21 $ 62,520,438.15 Fair Value Including Accrued Interest $ 73,794,358,303.36 *Governmental Accounting Standards Board(GASB)Statement#72 Repurchase Agreements,Time Deposits,AB 55&General Fund loans,and Reverse Repurchase agreements are carried at portfolio book value(carrying cost). The value of each participating dollar equals the fair value divided by the amortized cost(0.999423823). As an example:if an agency has an account balance of$20,000„,000,00,then the agency would report ite participation in the LAIF valued at$19,988,476.46 or$20,000,000.00 x0.999423823. K _ ,_ Item 1. - 38 Statement of Cash Receipts and Disbursements and Summary of Cash by Funs! �• ,.,,;� Finance Department December 2016 Cash Receipts and Disbursements November 2016 December 2016 Receipts General Fund Property Tax. 5,694,548 23,834,299 Local Sales Tax 3,336,800 3,651,567 Public Safety Sales Tax 167,979 212,581 Transient Occupancy Tax Receipts (TOT) 9261,955 633,544 Utility Users Tax(UUT) 1,585,747 1,472,432 Other Revenue 4,472,949 4,198,252 Total General Fund Revenue 16,184,978 34,002,674 Capital Projects Funds 100 43,042 Debt Service Funds - - Enterprise Funds 4,599,427 4,878,349 General Fund Other 462,595 806,028 Internal Service Funds 593,441 507,544 Special Revenue Funds 1,130,158 471,232 Grant Funds 546,050 1,679,992 Trust and Agency Funds 1,004,512 2,367,853 Total Receipts $24,521,262 $44,756,713 Disbursements General Fund Personal Services (11,747,325) (18,120,033) Operating Expenses (3,702,003) (2,989,067) Capital Expenditures (894,290) (226,493) Non-Operating Expenses (386,942) (4,208) Total General fund Disbursements (16,730,550) (21,338,802) Item 1. - 39 HB -52- Capital Projects Funds (136,247) (410813) Debt Service Funds (2,000) (1,440) Enterprise Funds (3,659,013) (5,602,208) General Fund Other (346,054) (832,295) Internal Service Funds (339,793) (934,128) Special Revenue Funds (1,115,649) (1,645,585) Grant Funds (508,018) (1,086,546) Trust and Agency Funds (947,727) (1,391,372) Total Disbursements (23,785,052) (33,243,188) Net Change in Gash Flow $736,210 $11,513,625 Summary of Cash by Fund November 2016 December 2016 General Fund $63,463,276 80,226,032 General Find Other 5,593,037 5,665,094 Capital Projects Funds 20,631,273 20,534,527 Debt Service Funds 60,960 59,520 Enterprise Funds 72,756,073 71,835,225 Trust and Agency Funds 10,344,494 11,692,410 Internal Service Funds 11,365,253 10,938,669 Special Revenue Funds 26,617,593 24,955,976 General Ledger Cash Balances $210,831,958 $225,907452 Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences. Note. Above information was obtained from the City's accounting system records.The above information includes receipts from maturing investments,and payments for purchased investments in the city investment portfolio.This statement is prepared in compliance with the City's Charter. HB -53- Item 1. - 40 AM Alk A N1.. Quarter encling: 1 I�t I December Ali* sa uc e , FFIM 1 C Treasurer � k ' a � as �ME{CFI I�'' ���,:�.,,, '' i E �€ C`• a r � �d 'mm� ggg CityCharter - Section311 Powers and Duties o CityTreasurer elected to 4-year term Responsible to electorate N CD r l Portfoliogoverned T ® California Government Cociectio 53600 ® City's Inve Certified California Municipal • Treasurers Associati • Reviewed / E + Safety of Principal **�OAdeq---Juate LI* qul* di--LL-IT , **i�' Market t,l i 1 Rate of CD WO .Iv. MWIM CA Government Code Section 53651 'V*** FY2 o l6/ 17 Investment Policy Most commonly utilized : • U.S. Treasuries ® Federal Agencies • Corporate Notes "A" rated and above 19 CA State Local Agency Investment Fund "11AIF" s 'l rr REM v Polic ,. WN, Ago- Maximum maturity Maximum specified / of portfolio p Minimum quality (rating) requirements Maximum to % per issuer except U. S . CD TreasuryAgency& issues CD �i i WN Federal Reserve interest rates in Dec : 0 .50 - 0 - 75 DJIA I 8 %/ S&P qtr.p.vs% rior 3 lo-year U Treasury so`\ s �\ t x 1 _000/0 Hi h: 15.84% 9/3o/81 16M 1 .00% e cn. 12.00% t, 10.00% &00 6.[90% m` .00 Low: 1.3 % 7/4/16 2.00 ...... ..... . ... -4;, 1970 1980 1990 2000 2010 00 r/ r va% a $ 1*n milhons. Investment T e Market Value Federal Agency Issues $ 140. 9 Local ARency Investment Fund LAIR Medium Term Notes - I BRD $ 5. 0 Cor orate Bonds fr `r 44�5 p . Total- Portfolio $ 211s9 e r. Nk ew"..✓. xm/c."w H2.���s 689,�1at'ov��z.' 9 0 �1 3 _- /d! � 3 .� Corporate Bonds 21% Federal Agencies 67% W MTN/IBRD-, 2% LAIF 10% Based on book value v, 0 N . .;: tea.Hot ,. / I SO Jai Federal Agency Holdings . Federal Home Loan Bank Federal National Mortgage Associtatiton (Fannie Mae) MFecteral Farm r r G iai s,,r �"9'€a" ✓� :':eras.~. �y��,.� Joby. Select Corporate Bond Issuers : ,--,,I,ple Inc. CaterpillarCorp . b, Y, GE Capital Corp . Coca Cola Co . Merck & Co Inc. Oracle Corp. CD G„� /ii ,...,, ..j„ Bass=/ � � F µ, Investment Type Policy Limit Actual Compliance Federal Agency Issues None 67% yes Local Agency Investment Fund (LAIF) $65 million $21 . 5 million ,P x yes Medium Term Notes - I BRD 10% 2% yes �orporate' Bonds 30% 21 E Portfolio Maximum per Issuer* 10% yes Maximum maturity 5 years yes *Except for US Treasury/Agency Issues Based on book value Fg 6 r Portfolio Earni Month End 12/31/16. FY 2016/2017 x Current Year 200)298 572)494 ......... ..... . Current Budget 420,000 Last Year Actual 169)539 499)573 p p Effective Rate oReturn 1 191 , 15 p .,. cD y €E E.. mil, EI;EEE', ,.✓9 i Portfolio Earnings offset taxpayer $ for: operating expenses . . tal pr ects api oj debt r other . . . es Portfolio remains compliant with relevant governmental regulations and the City's g Investment Policy o, 'tePW a ° INA, �y Thank you 1. 1—I CD Q1