The URL can be used to link to this page

Home My Public Portal AboutA 2017-05-16 LSA40Y.LY.4y;�.. �LlYO4 ;` CITY OF LYNWOOD As Successor Agency to the Lynwood Redevelopment Agency Maria Teresa Santillan -Beas, Mayor Jose Luis Solache, Mayor Pro Tern Salvador Alatorre, Council Member Aide Castro, Council Member Edwin E. Hernandez, Council Member This Agenda contains a brief general description of each item to be considered. Copies of the Staff reports or other written documentation relating to each item of business referred to on the Agenda are on file in the Office of the City Clerk and are available for public inspection. Any person who has a question concerning any of the agenda items may call the City Manager at (310) 603 -0220, ext. 200. CITY OF LYNWOOD AS SUCCESSOR AGENCY TO THE LYNWOOD REDEVELOPMENT AGENCY JOSE LUIS SOLACHE MAYOR PRO -TEM AIDE CASTRO COUNCILMEMBER CITY MANAGER ALMA K. MARTINEZ CITY CLERK MARIA QUINONEZ MAY 16, 2017 REGULAR MEETING 6:00 P.M. CITY HALL 11330 BULLIS ROAD MARIA TERESA SANTILLAN -BEAS MAYOR RECEIVED May 11, 2017 CITY OF LYNWOOD MY CLERK OFFICE SALVADOR ALATORRE COUNCILMEMBER EDWIN E. HERNANDEZ COUNCILMEMBER CITY ATTORNEY NOEL TAPIA CITY TREASURER GABRIELA CAMACHO OPENING CEREMONIES: A. Call Meeting to Order B. Roll Call ( ALATORRE - CASTRO - HERNANDEZ - SOLACHE - SANTILLAN -BEAS) C. Certification of Agenda Posting by City Clerk PUBLIC ORAL COMMUNICATIONS (Regarding Agenda Items Only) NON - AGENDA PUBLIC ORAL COMMUNICATIONS CONSENT CALENDAR MINUTES FROM PREVIOUS MEETINGS: Regular Meeting — May 2, 2017 2. APPROVAL OF THE WARRANT REGISTER Comments: City of Lynwood Successor Agency warrant register dated May 16, 2017 for FY 2016/17 3. TREASURER'S MONTHLY INVESTMENT REPORT Comments: Government Code Section 53607, last amended 1996, with reference to the reporting of investment transactions states that the Treasurer shall make a monthly report of those transaction to the legislative body. Government Code Section 53646 (b) (1), last amended 2004, with reference to discussion related to establishment of an Investment Policy and investment reporting states that The Treasurer may render a quarterly report. To determine the applicable code in as much as reference to Government Code Section 53607 or non - compliance thereof has never been included in past audit findings. (CT) Recommendation: It is recommended that the City of Lynwood receive and file the attached Monthly Investment Report. The following information provided in this report highlights the investment activity for months ending March 31, 2017 and April 30, 2017. ADJOURNMENT CITY OF LYNWOOD AS SUCCESSOR AGENCY TO THE LYNWOOD REDEVELOPMENT AGENCY MEETINGS WILL BE POSTED AS NEEDED. THE NEXT MEETING WILL BE HELD IN THE COUNCIL CHAMBERS OF CITY HALL, 11330 BULLIS ROAD, CITY OF LYNWOOD, CALIFORNIA. 0 AGENDA REPORT DATE: May 16, 2017 TO: Honorable Mayor and Members of th City Council APPROVED BY: Alma K. Martinez, City Manager PREPARED BY: Maria Quinonez, City Clerk C? 40 0 Lourdes Morales, Office Assistant I I SUBJECT: City of Lynwood as Successor to the Lynwood Redevelopment Agency Minutes Recommendation: Staff recommends the Lynwood City Council approve the following minutes: • Regular Meeting — May 2, 2017 Background: N/A Discussion & Analysis: N/A Fiscal Impact: N/A Coordinated With: N/A ITEM I "_ CITY OF LYNWOOD AS SUCCESSOR AGENCY TO THE LYNWOOD REDEVELOPMENT AGENCY REGULAR MEETING MINUTES MAY 2, 2017 The City of Lynwood as Successor Agency to the Lynwood Redevelopment Agency met in a regular meeting in Council Chambers, 11330 Bullis Road, Lynwood, California on the above date at 6:46 p.m. Mayor Santillan -Beas presiding Council Members Alatorre, Castro, Hernandez, Mayor Pro Tern Solache and Mayor Santillan -Beas were present. Also present were City Manager Martinez, City Attorney Garcia, City Clerk Quinonez and City Treasurer Camacho. City Clerk Quinonez announced the Agenda had been duly posted in accordance with the Brown Act. PUBLIC ORAL COMMUNICATIONS (Regarding Agenda Items Only) NONE NON - AGENDA PUBLIC ORAL COMMUNICATIONS NONE CONSENT CALENDAR MOTION: It was moved by Council Member Castro, seconded by Council Member Hernandez to approve the consent calendar. Motion carried by the following vote: ROLL CALL: AYES: COUNCIL MEMBERS ALATORRE, CASTRO, HERNANDEZ, MAYOR PRO TEM SOLACHE AND MAYOR SANTILLAN -BEAS NOES: NONE ABSTAIN: NONE ABSENT: NONE Item #1. MINUTES FROM PREVIOUS MEETINGS: Regular Meeting — April 4, 2017 Regular Meeting —April 18, 2017 I Item #2. APPROVAL OF THE WARRANT REGISTER RESOLUTION NO. 2017.010 ENTITLED: RESOLUTION OF THE LYNWOOD CITY COUNCIL AS SUCCESSOR AGENCY TO THE LYNWOOD REDEVELOPMENT AGENCY OF LYNWOOD, CALIFORNIA, ALLOWING AND APPROVING THE DEMANDS AND WARRANTS Item #3. TREASURER'S QUARTERLY INVESTMENT REPORT Report was received and filed. ADJOURNMENT Having no further discussion, it was moved by Council Member Castro, seconded by Council Member Hernandez to adjourn the City of Lynwood as Successor Agency to the Lynwood Redevelopment Agency meeting at 6:47 p.m. Maria T. Santillan -Beas, Mayor Maria Quinonez, City Clerk - ;�ivFZ.� .g 0 AGENDA STAFF REPORT DATE: May 16, 2017 TO: Honorable Mayor and Members of the City Council as Successor Agency to the Lynwood Redevelopment Agency APPROVED BY: Alma Martinez, Executive Direct rd I F1 PREPARED BY: Jose Ometeotl, Finance Director Wu Monica Ochoa, Accounting Techniciapx/ly SUBJECT: Approval of the Warrant Register (�' Recommendation: Staff respectfully recommends that the Lynwood City Council as Successor Agency approve the warrant register dated May 16, 2017. Attached Warrant Register dated May 16, 2017• ITEM 2 vchlist 05109/2017 6:07:25PM Successor Voucher List Agency of the Lynwood Redevelopment Agency Page: 1 Bank code: sa usb Voucher Date Vendor Invoice PO # Description /Account Amount 5410 5/1612017 001329 U.S. BANK 4621129 ADMINISTRATION FEES - BOND - HOUSING PROJ 2011 02- 001987 1021.76.211.67899 935.00 4621137 ADMINISTRATION FEES -BOND PROJ AREAA 2011 02- 001986 1021.76.211.67899 935.00 Total : 1,870.00 5411 5/16/2017 007223 COX, CASTLE & NICHOLSON LLP 444732 LEGAL SVCS - 12/2016 11- 000878 1021.76.211.62001 4,052.60 444743 LEGAL SVCS- 12/2016 11- 000878 1021.76.211.62001 3,896.20 445910 LEGAL SVCS- 1/2017 11- 000878 1021.76.211.62001 453.10 445911 LEGAL SVCS- 1/2017 11- 000878 1021.76.211.62001 438.15 445921 LEGAL SVCS- 1/2017 11- 000878 1021.76.211.62001 634.80 446878 LEGAL SVCS- 2/2017 11- 000878 1021.76.211.62001 436.15 446880 LEGAL SVCS- 2/2017 11- 000878 1021.76.211.62001 1,108.60 Total: 11,021.60 2 Vouchers for bank code : sa_usb Bank total : 12,891.60 Page: 1 �e ..,. AGENDA STAFF REPORT DATE: May 16, 2017 TO: Honorable Mayor and Members of City Council, as Successor to Lynwood Redevelopment Board t�, APPROVED BY: Alma K. Martinez, City PREPARED BY: Gabriela Camacho, City Treasurerg Sheila Harding, Deputy City Treasurer S0' SUBJECT: Treasurer's Monthly Investment Report Recommendation: It is recommended that the City of Lynwood receive and file the attached Monthly Investment Report. The following information provided in this report highlights the investment activity for months ending March 31, 2017 and April 30, 2017. Background: Government Code Section 53607, last amended 1996, with reference to the reporting of investment transactions states that the Treasurer shall make a monthly report of those transaction to the legislative body. Government Code Section 53646 (b) (1), last amended 2004, with reference to discussion related to establishment of an Investment Policy and investment reporting states that The Treasurer may render a quarterly report. To determine the applicable code inasmuch as reference to Government Code Section 53607 or non - compliance thereof has never been included in past audit findings. While Government Code Section 53646 (b) (1) which is the most current version related to Investment Reporting utilizes the word "may" indicating the reporting mechanism is optional, to err on the side of caution, and in order to ensure that we are in compliance with all Government Codes, a new procedure of submitting monthly reports to the Council /Agency agenda is being implemented. Attached for council /agency review is the first in the city's /agency's history of a monthly Treasurer's Report submitted on the council /agency agenda. Subsequent reports will be provided on a monthly basis at the second meeting of each month. Fiscal Impact: The action recommended in this report will not have a fiscal impact on the City. I ITEM 0 City of Lynwood Investment Report Summary Notes For the Month of March 30, 2017 Investment Activity during the Period of March 2017. The investment activity for March 2017 included 1 purchase and 1 redemption. John Deere A2 5250.000.00 3 YR John Deere A2 5250.000.00 3YR 1.400% * Calculation uses 360 Day Basis ** Calculation uses 365 Day Basis 1.700% Coro Notes 1.230% Coro Notes The Local Agency Investment Fund (LAIF) balance as of March 31, 2017 is $17,181,415.58 with an average monthly yield of 0.821 %, and an interest rate of 0.78 %. Quarterly interest in the amount of $29,122.96 was received on January 13, 2017. The ending balance on February 28, 2017 was $19,181,415.58 resulting in a decrease of $2,000,000.00 which was transferred to the general account to meet monthly expenditures. Liquidity of the Portfolio The current goal is to keep the investment portfolio at an average maturity of 2 years based on current economic conditions. The portfolio's current average maturity Is 231 days. The goal is to keep an average of $9 - $15 million in liquid assets in order to meet operational needs and for unexpected expenditures that may arise. The City is in compliance with California Government Code Section 53646 which requires local agency to report its ability to meet pooled expenditure requirements for the next six (6) months. The City's portfolio will stay the course based on the current economic trends. Covering cash flow needs rank as the top priority. Portfolio Performance: Portfolio InterestEarning,,Summary March 2017 Fisca I YTD CD /Coupon /Discount Investments: ➢ Interest Collected 13,604.20 100,349.29 • Plus Accrued Interest @ End of Period 34,794.07 34,794.01 • Less Accrued Interest @ Beginning of Period (35,903.09) (28,145.78) ➢ Less Accrued Interest @ Purchase During Period 0.00 0.00 Interest Earned during this Period 12,495.18 106,997.52 Adjusted by Premiums and Discounts 470.92 2,801.72 Adjusted by Capital Gains or Losses 0.00 0.00 12,966.10 109,876.74 Pass Through Securities • Interest Collected 0.00 0.00 • Plus Accrued Interest @ End of Period 0.00 0.00 ➢ Less Accrued Interest @ Beginning of Period (0.00) (0.00) ➢ Less Accrued Interest at Purchase During Period (0.00) (0.001 Interest Earned during this 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 0.00 0.00 Investment Report Summary March 30, 2017 Page Two Cash /Checking Accounts: ➢ Interest Collected (Goldman Sachs) ➢ Plus Accrued Interest at End of Period ➢ Less Interest at Beginning of Period Interest Earned this Period Total Interest Earned Total Adjustments from Premium and Discounts Total Capital Gains or Loss Total Earnings this Period 62.38 33,191.03 (21,784.73) 11,468.68 83756.04 33,191.03 (25.921.56) 91,025.51 23,963.86 198,023.03 470.92 2,801.72 0.00 77.50 24,434.78 200,902.25 Notes: Adjusted by Premium /Discounts represents the premium or discount cost involved to secure higher or lower yield securities. The cost of the premium or discount is amortized down or up respectively to par over the life of the bond until reaching maturity. By amortizing the amount of taxable interest is reduced for each year the city owns the bond. This is because the amortized premiums or discounts offset the ordinary income of the coupon payment. As long as a bond is held to maturity there will be no capital loss or gain to report. Attachments: Reconciliation Report Interest Report Portfolio Summary Investment Activity Month End & Year # of Securities Interest Average Balance YTM 360% YTM 365 Effective Rate of Return Days to Maturity Jul -16 39 20,711.33 29,035,886.87 0.849 0.861 0.84% 213 Aug -16 39 21,322.94 29,068,055.07 0.876 0.888 0.86% 225 Sep-16 39 21,208.36 29,084,435.06 0.881 0.893 0.89% 215 Oct -16 39 21,973.80 29,112,032.67 0.884 0.896 0.89% 223 Nov -16 39 20,795.72 27,665,678.31 0.956 0.969 0.91% 253 Dec -16 38 21,368.32 25,949,845.70 1.015 1.029 0.97% 280 Jan -17 38 23,161.80 27,030,078.37 0.977 0.991 1.01% 217 Feb -17 38 24,031.34 30,621,974.05 1.099 0.023 1.02% 221 Mar -17 38 24,438.78 27,712,717.35 1.062 1.076 1.04% 235 Attachments: Reconciliation Report Interest Report Portfolio Summary Investment Activity City of Lynwood Cash Reconciliation Report For the Period March 1, 2017 - March 31, 2017 Trans. Trans. Par Maturity Date Investment# Fund Type Security ID Value Security DoscripUan Date Purchases Interest Redemptions Cash 03/01/201710097 LYN Interest 20451PNKB 248,000.00 BCOMPS 0.2M 1.50% Mat. 03/01/2018 0.00 1,844.71 0.00 1,844.71 03/011201710110 LYN Interest 30231 GAP7 250,000.00 XOM 03M 1.71% Mat. 03/01/2019 03/01/2019 0.00 2,135.00 0.00 2,135.00 03/06/2017 10119 LYN Interest 69353REV6 250,000.00 PNC 0.3M 1.95% MeL 03/04/2019 03104/2019 0.00 2,437.50 0.00 2,437.50 03/0812017 10078 LYN Interest 94974BGBO 250,000.00 WFB 0.3M 1.40% Mat 091082017 09/08/2017 0.00 1,750.00 0.00 1,750.00 03/13/201710080 LYN Interest 90331HMH3 250,000.00 USB 0.3M 1.38% Mat 09111/2017 09/112017 0.00 1,718.75 0.00 1,718.75 03/13/2017 10107 LYN Interest 9497483K1 248,000.00 WFB 0.2M 1.15% Mat. 02/12/2018 02/12/2018 0.00 218.78 0.00 218.78 03115/201710086 LYN Interest 24422ERNi 250,000.00 DE 0.3M 1.40% Mat. 03115/2017 03/15/2017 0.00 1,750.00 0.00 1,750.00 03115/201710086 LYN Maturity 24422ERNi 250,000.00 DE 0.3M 1.40% Mat. 03115/2017 03/15/2017 0.00 0.00 250,000.00 250,000.00 03/20/2017 10123 LYN Interest 17275RBJO 250,000.00 CSCO 0.3M 1.85% Mat 09/20/2021 09/20/2021 0.00 2,312.50 0.00 2,312.50 03/212017 10125 LYN Purchase 24422ERY7 250,000.00 DE 0.3M 1.70% Mat. 01/15/2020 01/1512020 - 247,370.00 - 779.17 0.00 - 248,149.17 03/27/2017 10083 LYN Interest 20033AJL1 248,000.00 ADS 0.2M 1.70% Mat. 05/25/2018 05/2512018 0.00 323.42 0.00 323.42 Run Date: 04117Q017 -14:36 Subtotal - 247,370.00 13,711.49 260,000.00 16,341.49 Total •247,370.00 13,711.49 250,000.00 16,341.49 Portfolio LYNW AP AC (PRF -AC) 72.0 Repon Ver.7.3.5 32 Lynwood - Portfolio Management Portfolio Management Interest Earnings Summary March 31, 2017 Page 1 Interest Earned during Period Adjusted by Premiums and Discounts Adjusted by Capital Gains or Losses Earnings during Periods 12,495.18 470.92 0.00 12,966.10 106,997.52 2,801.72 77.50 109,876.74 Pass Through Securities: March 31 Month Ending Fiscal Year To Date CD /Coupon /Discount Investments: 0.00 0.00 Interest Collected 13,604.20 100,349.29 Plus Accrued Interest at End of Period 34,794.07 34,794.01 Less Accrued Interest at Beginning of Period ( 35,903.09) ( 28,145.78) Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period Adjusted by Premiums and Discounts Adjusted by Capital Gains or Losses Earnings during Periods 12,495.18 470.92 0.00 12,966.10 106,997.52 2,801.72 77.50 109,876.74 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) ( 0.00) Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) 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 0.00 0.00 Cash /Checking Accounts: Interest Collected 62.38 83,756.04 Plus Accrued Interest at End of Period 33,191.03 33,191.03 Less Accrued Interest at Beginnng of Period ( 21,784.73) ( 25,921.56) Interest Earned during Period 11,468.68 91,025.51 Total Interest Earned during Period 23,963.86 198,023.03 Total Adjustments from Premiums and Discounts 470,92 2,801,72 Total Capital Gains or Losses 0.00 77.50 Total Earnings during Period Data Updated: SET _PMM: 04117/2017 14:09 Run Data: 04/172017 -14:09 24,434.78 200,902.25 Portfolio LYNW AP PM (PRF_PM6) 7.3.0 Report Ver. 7.3.5 26 Lynwood - Portfolio Management Portfolio Management Portfolio Summary March 31, 2017 Investments Par Market Book %of Daysto Value Value Value Portfolio Term Maturity Limey Market Funds 195,84D20 195,84026 195,87020 0.71 1 1 LAIF 17,187,415.58 17,181,415.58 17.181,415.58 0199 1 1 Corporate Na+ 3.250,00D.00 3.237405.00 3.245,038.45 11.71 1.120 059 Federal Agency 1.500,11DO.OD 1,497,700.00 1.492259.30 5.38 1.541 1,080 Treasury Coupon Secrarties 1,D00,000.00 1,001,175.00 098,590.72 3.00 1,801 470 Federal Agency CalUble 500,00D.00 494,260.00 500,0D0.00 1.80 1.095 818 CD -FDIC 4.1D6.00D.00 4,097,475.08 4,105,32254 14.81 1,219 454 Investments 27,733,255.84 27,702,420.92 27,716,472.94 100.1116% 473 235 Total Earnings March 31 Month Ending Fiscal Year To Date Current Year 24,434.76 200,90225 Average Daily Balance 27,712,717.35 28,341,335.13 Effective Rate of Return 1.04% 0.94;0 4 -18 -17 FFN vi ancial Main Street Advisors, Rick Phillips Reporting Period 031012017 - 0313112017 Data Updated: SET PMM: 04117201714:09 Rut care: avl7rmn- ta:D9 YrM YTM 380 Equiv. 385 Equiv. 0.612 D.809 1 boo 1.044 1.380 1.085 1.423 1.062 0.620 0.820 1.021 1.667 1.409 1.10a 1.442 1.076 Portfolio LYNW AP PM(PRF PMi)73.g Repro Vw.7.35 W.,, FTN FINANCIAL. Investment Activity MAIN STREET ADVISOR$ 3/31/2017 City of Lynwood A MAIN ImhvBaa.\mAsoRs az Number of Positions at Month End 41 40 39 N 0 o. 36 35 34 33 32 Apr -16 May -16 Jun -16 Jul -16 Aug -16 Sep -16 Oct -16 Nov -16 Dec -16 Jan -17 Feb -17 Mar -17 6 Purchases and Redemptions' (Excluding LAIF & MMF) wPurchases - S ERedemptions w 0 0 u 4 w C a F. 3 0 .0 2 _ E Z 1 ! i r i O Apr -16 May -16 Jun -16 Jul -16 Aug -16 Sep -16 Oct -16 Nov -16 Dec -16 Jan -17 Feb -17 Mar -17 'Redemptions include maturities, calls, and sells (excluding paydowns) Purchases - A r. -16, I _Ma -16 1, - Jun -16 I Jul16 -_, A.- - 161 =_; Se =16 - Oct -16_ Nbv -1fi' Dec:16r_': " +' - Jan 1p;. -. i' Eeb -771. I. Mar -17C ?: __. _. _ Redem dolls" 0 0 0 0 2 3 2 2 2 1 1 1 0 0 1 Total Transactions 3 0 0 1 0 1 2 1 2 1 1 1 1 1 2 1 0 1 0 1 1 1 5 1 2 1 4 1 4 1 2 1 2 1 0 1 0 2 15 City of Lynwood Investment Report Summary Notes For the Month of April 30, 2017 Investment Activity during the Period of April 2017. The investment activity for April 2017 included 1 purchase and 1 redemption. Plurchaser/.I�ssu.er Rating Par Value TerML Coupon* Structure FHLMC Aaa 5350.000 _ 3 YR 1.580% Fed. Aecv Callable Redemption /Issuer Rating. Par Value Term Coupon. YTM *' Status Goldman Bach Govt Aaa $350,000 1 •. r'. 0% MMF MMF * Calculation uses 360 Day Basis ** Calculation uses 365 Day Basis The Local Agency Investment Fund (LAIF) balance as of April 30, 2017 was $17,215,604.32 with an average monthly yield of 0.884 %, and an interest rate of 0.78 %. Quarterly interest in the amount of $34,188.74 was received on April 13, 2017. The ending balance on March 30, 2017 was $17,181,415.58. Liquidity of the Portfolio • The current goal is to keep the investment portfolio at an average maturity of 2 years based on current economic conditions. The portfolio's current average maturity is 231 days. • The goal is to keep an average of $9 - $15 million in liquid assets in order to meet operational needs and for unexpected expenditures that may arise. The City is in compliance with California Government Code Section 53646 which requires local agency to report its ability to meet pooled expenditure requirements forthe next six (6) months. • The City's portfolio will stay the course based on the current economic trends. Covering cash flow needs rank as the top priority. Portfolio Performance: CD /Coupon /Discount Investments ➢ Interest Collected 11,564.26 111,913.55 ➢ Plus Accrued Interest @ End of Period 35,642.95 35,642.89 ➢ Less Accrued Interest @ Beginning of Period (34,794.07) (28,145.78) ➢ Less Accrued Interest @ Purchase During Period 0.00 0.00 Interest Earned during this Period 12,413.14 119,410.66 Adjusted by Premiums and Discounts 529.51 3,331.23 Adjusted by Capital Gains or Losses 0.00 77.50 12,942.65 122,819.39 Pass Through Securities ➢ Interest Collected 0.00 0.00 ➢ Plus Accrued Interest @ End of Period 0.00 0.00 ➢ Less Accrued Interest @ Beginning of Period (0.00) (0.00) ➢ Less Accrued Interest at Purchase During Period (0.00) (0.00) Interest Earned during this 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 0.00 0.00 Investment Report Summary April 2017 Page Two Cash /Checking Accounts: ➢ Interest Collected (Goldman Sachs) ➢ Plus Accrued Interest at End of Period ➢ Less Interest at Beginning of Period Interest Earned this Period Total Interest Earned Total Adjustments from Premium and Discounts Total Capital Gains or Loss Total Earnings this Period 110.12 44,819.81 (33.191.03) 11,738.90 83,866.16 44,819.81 (25.921.56) 102,764.41 24,152.04 222,175.07 529.51 3,331.23 0.00 77.50 24,681.55 225,583.80 Notes: Adjusted by Premium /Discounts represents the premium or discount cost involved to secure higher or lower yield securities. The cost of the premium or discount is amortized down or up respectively to par over the life of the bond until reaching maturity. By amortizing the amount of taxable interest is reduced for each year the city owns the bond. This is because the amortized premiums or discounts offset the ordinary income of the coupon payment. As long as a bond is held to maturity there will be no capital loss or gain to report. Attachments: Reconciliation Report Interest Report Portfolio Summary Investment Activity Month End & Year # of Securities Interest Average Balance YTM 360% YTM 365 Effective Rate of Return Days to Maturity Jul -16 39 20,711.33 29,035,886.87 0.849 0.861 0.84% 213 Aug -16 39 21,322.94 29,068,055.07 0.876 0.888 0.86% 225 Sep -16 39 21,208.36 29,084,435.06 0.881 0.893 0.89% 215 Oct -16 39 21,973.80 29,112,032.67 0.884 0.896 0.89% 223 Nov -16 39 20,795.72 27,665,678.31 0.956 0.969 0.91% 253 Dec -16 38 21,368.32 25,949,845.70 1.015 1.029 0.97% 280 Jan -17 38 23,161.80 27,030,078.37 0.977 0.991 1.01% 217 Feb -17 38 24,031.34 30,621,974.05 1.099 0.023 1.02% 221 Mar -17 38 24,438.78 27,712,717.35 1.062 1.076 1.04% 235 Apr -17 38 24,681.65 27,743,013.65 1.108 1.124 1.08% 237 Attachments: Reconciliation Report Interest Report Portfolio Summary Investment Activity City of Lynwood Cash Reconciliation Report For the Period April 1, 2017 - April 30, 2017 Trans. Trans. Par Maturity Date Investment# Fund Type Security ID Value Security Description Date Purchases Interest Redemptions Cash 04/04/2017 10011 LYN Interest 9000 591,708.94 GSGF 0.6M 0.01% 0.00 04/04/201710011 LYN Interest 9000 591,708.94 GSGF OAM 0.01% 110.12 0.00 110.12 04/07/201710098 LYN Interest 14042RA04 248,000.00 CAPINA 0.2M 1.65 %MaL 10/09/2018 - 110.12 0.00 0.00 - 110.12 04/07/2017 10011 LYN Deposit 9000 591,708.94 GSGF 0.6M 0.29% 0.00 2,040.39 0.00 2,040.39 04108/2017 10088 LYN Interest 38148JQBO 248,000.00 GOLD 0.2M 1.20% Mat 04/09/2018 04/09/2018 - 2,040.39 0.00 0.00 0.00 - 2,040.39 04/1012017 10109 LYN Interest 02665WAC5 250,000.00 HNDA 0.3M 2.13% Mat. 10/10/201810/10 /2018 1,483.92 0.00 1,483.92 04/10/2017 10011 LYN Deposit 9000 591,708.94 GSGF 0.6M 0.29% 0.00 2,656.25 0.00 2,656.25 04/1212017 10107 LYN Interest 9497483K7 248,000.00 WFB 0.2M 1.15% Mat 02/12/2018 02112/2016 4.140.17 0.00 0.00 0.00 - 4,140.17 04/12/2017 10011 LYN Deposit 9000 591,708.94 GSGF O.6M 0.29% 242.22 0.00 242.22 04/14/201710000 LYNL Deposit 9001 18,598,109.09 LAIF 18.6M 0.57% - 242.22 0.00 0.00 - 242.22 04/17/201710059 LYN Interest 17284CBW3 150,000.00 CITBAK 0.2M 0.90% Mat 04117/2017 - 34,188.74 0.00 0.00 - 34,188.74 04/17/201710122 LYN Interest 3136G4DR1 500,000.00 FNMA 0.5M 1.10% Mat. 10/17/201910/17 /2019 0.00 0.00 673.15 0.00 673.15 04117/201710059 LYN Maturity 17284CBW3 150,000.00 CITBAK 0.2M 0.90% Mat 04117/2017 0.00 2,750.OD 0.00 2,750.00 04/17/2017 10011 LYN Deposit 9000 591,708.94 GSGF 0.6M 0.29% 0.00 150,000.00 150,000.00 04/21/201710100 LYN Interest 05573J5W0 248,000.00 BMO 0.2M 1.10% Mat. 10/23/2017 10/23/2017 - 153,423.15 0.00 0.00 0.00 - 153,423.15 04/21/2017 10011 LYN Deposit 9000 591,708.94 GSGF 0.6M 0.29% 1,360.26 0.00 1,360.26 04/26/2017 10083 LYN Interest 20033AJLI 248,000.00 ADS 0.2M 1.70% Mat 05/25/2018 05125/2018 - 1,360.26 0.00 0.00 0.00 - 1,360.26 04126!2017 10011 LYN Deposit 9000 591,708.94 GSGF 0.6M 0.29% 358.07 0.00 358.07 04/2712017 10126 LYN Purchase 3134GSHX3 350,000.00 FHLMC OAM 1.58% Mat. 04/27/202004/27 /2020 - 358.07 - 35D,000.00 0.00 0.00 0.00 - 358.07 04/27/2017 10011 LYN Withdrawal 90DO 591,708.94 GSGF 0.6M 0.29% 0.00 - 350,OOD.00 0.00 0.00 350,000.00 350.000.00 Subtotal - 645.863.12 1I.674AR snn nnn nn 1e .nc v. Total 545,863.12 11,674.38 600,000.00 - 34,188.74 Portfolio LYNW Run Date: 05108=17.14:32 AP AC (PRF_AC) 7.2.0 Report Ver. 7.3.5 32 Lynwood - Portfolio Management 0.00 Portfolio Management 0.00 Interest Earnings Summary Page 1 April 30, 2017 ( 0.00) April 30 Month Ending Fiscal Year To Date CD/Coupon/Discount Investments: 222,175.07 3,331.23 77.50 Interest Collected 11,564.26 111,913.55 Plus Accrued Interest at End of Period 35,642.95 35,642.89 Less Accrued Interest at Beginning of Period ( 34,794.07) ( 28,145.78) Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period 12,413.14 119,410.66 Adjusted by Premiums and Discounts 529.51 3,331.23 Adjusted by Capital Gains or Losses O.OD 77.50 Earnings during Periods Pass Through Securities: Interest Collected Plus Accrued Interest at End of Period Less Accrued Interest at Beginning of Period Less Accrued Interest at Purchase During Period Interest Earned during Period Adjusted by Premiums and Discounts Adjusted by Capital Gains or Losses Earnings during Periods 12,942.65 122,819.39 0.00 0.00 0.00 0.00 ( 0.00) ( 0.00) ( 0.00) ( 0.00) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Cash /Checking Accounts: Interest Collected Plus Accrued Interest at End of Period Less Accrued Interest at Beginning of Period 110.12 44,819.81 ( 33,191.03) 83,866.16 44,819.81 ( 25,921.56) Interest Earned during Period 11,738.90 102,764.41 Total Interest Earned during Period Total Adjustments from Premiums and Discounts Total Capital Gains or Losses 24,152.04 529.51 0.00 222,175.07 3,331.23 77.50 Total Earnings during Period Data Updated: SET PMM: OBIO 2017 14:19 Run Date: 05/082017 -14:19 24,681.55 225,583.80 Portfolio LYNW AP PM (PRF PM6) 7.3.0 Report Ver. 7.3.5 26 Lynwood - Portfolio Management Portfolio Management Portfolio Summary April 30, 2017 Investments Par market Seek %eI Days to YtM M eney Market Funds value Value Value Por1to0o Term Maturity 360 E ry qu W F 7,514.64 7,514.64 7,514.64 0.03 1 1 0.841 17,2158M.32 17215,604.32 17215,204.32 82.07 1 1 Corporate Notes 3,250p00.00 3,243.050.00 3245,063.08 11.08 0.668 Federal AgeneT 1.500.000.00 1,468255.00 1p92,420.97 5.36 1.120 828 1.588 Treasury Coupon Securkies 1,000,800.00 1.641 1.050 1.844 Federal Agency Callable 1,000,970.00 866,872.58 398 1,801 440 1.388 CUFDIC 850,000.00 843AXOD 850,000.00 308 1,085 913 7280 3,858,000.00 3,951,476.38 3,855,380.99 1425 1200 440 1.443 Investments 27,779,118.96 27,760,467.35 27,762,865.57 100.00% 478 237 1.108 Total Earnings April 30 Month Ending Ftscal Year To Date CUnent Year 24.601.55 225,503.80 Average Daily Balance 27,743,013.65 28,282,2911.25 Effective Rate of Return 1.0899 0.9691 T—P.,..�,�Y� 5 -9 -17 FfN Fnanclal Main Street Advisors, WUC Phillps Reporting period 041012017 - 04/302017 Data Updated: SET PMM: 05x0&201714: 19 RL D.aae:DeTKV,v17 -14:10 385 YTM 0.650 0.860 1.621 1.667 1.406 1.298 1.483 1.124 Porttdio LYNW AP PM (PI UM11730 RepatVer.7.3.5 fit: FTN FINANCIAL, Investment Activity MAIN $lltEETWAu D SORw 4/30/2017 City of Lynwood 42 Number of Positions at Month End 41 40 39 38 �'. 0 _..____.._. ". 0 n 36 35 34 33 32 May -16 Jun -16 Jul -16 Aug -16 Sep -16 Oct -16 Nov -16 Dec -16 Jan -17 Feb -17 Mar -17 Apr -17 6 Purchases and Redemptions* (Excluding LAIF & MMF) 5 C 0 U 4 m 0 c - f= 3 0 2 E z z 1 _ 1 0 May -16 Jun -16 Jul -16 Aug -16 Sep -16 Oct -16 'Redemptions include maturities, calls, and sells (excluding paydowns) RPurchases ■Redemptions Nov -16 Dec -16 Jan -17 Feb -17 Mar -17 Apr -17 _ Purchases _- _ Redemptions ." Total Transactions _ '. ".N1a =16 0 0 3 I Jun -16 2 3 0 Ju116 2 0 0 Au " -9fi '' 2 1 2 5 Se _76 2 1 2 2 1 1 1 4 1 1 1 4 1 1 2 2 0 0 1 2 0 0 0 1 1 0 1 1 1 2 15