HomeMy Public PortalAbout2020-02-04 Lynwood Public Financing AuthorityThis 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.
Procedures for Addressing the Members of the Authority
IN ORDER TO EXPEDITE LYNWOOD PUBLIC FINANCING AUTHORITY BUSINESS, WE ASK THAT ALL PERSONS
WISHING TO ADDRESS THE MEMBERS FILL OUT A FORM PROVIDED AT THE PODIUM, AND TO TURN IT IN TO
THE CITY CLERK PRIOR TO THE START OF THE MEETING. FAILURE TO FILL OUR SUCH A FORM WILL
PROHIBIT YOU FROM ADDRESSING THE MEMBERS IN THE ABSENCE OF THE UNANIMOUS CONSENT OF THE
MEMBERS.
AGENDA
Lynwood Public Financing Authority
TO BE HELD ON
February 4, 2020
COUNCIL CHAMBERS - 11350 BULLIS RD. LYNWOOD, CA 90262
6:00 PM
1.CALL TO ORDER
2.CERTIFICATION OF AGENDA POSTING BY SECRETARY
3.ROLL CALL OF MEMBERS
Aide Castro, President
Jorge Casanova, Vice President
Salvador Alatorre, Member
Marisela Santana, Member
Jose Luis Solache, Member
4.GOVERNMENT CODE SECTION 54954.3
Members of the City Council are also members of Lynwood Public Financing Authority, which is
concurrently convening with the City Council this evening and each Council Member is paid an
Additional Stipend of $100 for Attending the Lynwood Public Financing Authority Meeting. Further,
the Authority is scheduled to meet four (4) timer per year. If additional meetings are required beyond
the scheduled four (4) meetings, the City Council will only get paid for the first four(4) meetings.
PUBLIC ORAL COMMUNICATIONS
(Regarding Agenda Items Only)
NON-AGENDA PUBLIC ORAL COMMUNICATIONS
THIS PORTION PROVIDES AN OPPORTUNITY FOR THE PUBLIC TO ADDRESS THE LYNWOOD PUBLIC
FINANCING AUTHORITY ON ITEMS WITHIN THE JURISDICTION OF THE LYNWOOD PUBLIC FINANCING
AUTHORITY AND NOT LISTED ON THE AGENDA. IF AN ITEM IS NOT ON THE AGENDA, THERE SHOULD BE NO
Lynwood Public Financing Authority - Page 1 of 26
SUBSTANTIAL DISCUSSION OF THE ISSUE BY LYNWOOD PUBLIC FINANCING AUTHORITY, BUT LYNWOOD
PUBLIC FINANCING AUTHORITY MAY REFER THE MATTER TO STAFF OR SCHEDULE SUBSTANTIVE
DISCUSSION FOR A FUTURE MEETING. (The Ralph M. Brown Act, Government Code Section 54954.2 (a).)
CONSENT CALENDAR
ALL MATTERS LISTED UNDER THE CONSENT CALENDAR WILL BE ACTED UPON BY ONE MOTION
AFFIRMING THE ACTION RECOMMENDED ON THE AGENDA. THERE WILL BE NO SEPARATE DISCUSSION ON
THESE ITEMS PRIOR TO VOTING UNLESS MEMBERS OF THE COUNCIL OR STAFF REQUEST SPECIFIC
ITEMS TO BE REMOVED FROM THE CONSENT CALENDAR FOR SEPARATE ACTION.
5.TREASURER'S QUARTERLY REPORT
Comments:
The purpose of this item is to have the Honorable Mayor and the Lynwood City Council review the
Treasurer’s Quarterly Investment Report as required by State Statutes. (CT)
Recommendation:
It is recommended that the City of Lynwood receive and file the attached Quarterly Investment Report.
The following information provided in this report highlights the investment activity for the 2nd quarter
ending December 31, 2019.
ADJOURNMENT
THE LYNWOOD PUBLIC FINANCE AUTHORITY MEETINGS WILL BE POSTED AS
NEEDED. THE NEXT MEETING WILL BE HELD IN THE COUNCIL CHAMBERS OF CITY
HALL ANNEX, 11350 BULLIS ROAD, CITY OF LYNWOOD, CALIFORNIA.
Lynwood Public Financing Authority - Page 2 of 26
Agenda Item # 5.
AGENDA STAFF REPORT
DATE: February 4, 2020
TO: Honorable President and Members of the Public Finance Authority
APPROVED BY: Jose E. Ometeotl, City Manager
PREPARED BY: Gabriela Camacho, City Treasurer
Sheila Harding, Deputy City Treasurer
SUBJECT: TREASURER'S QUARTERLY REPORT
Recommendation:
It is recommended that the City of Lynwood receive and file the attached Quarterly Investment Report. The following
information provided in this report highlights the investment activity for the 2nd quarter ending December 31, 2019.
Background:
Due to the crisis caused by the Orange County investment pool, the State Legislature in 1995 enacted SB564 and
SB866. These laws were enacted as State Statutes to impose certain mandates regarding investments with public
funds. The statutes have imposed the following mandates:
1. Annual adoption of an Investment Policy that incorporates changes mandated by the State.
2. Quarterly Investment Reports presented to the Legislative Body or Board Members.
3. Restriction on the use of certain investment instruments.
The purpose of the Treasurer’s report is to update the City Council and the public of the status of the City’s cash
balances, investments and highlight changes from one period to another. This report includes reconciliation
between cash and investment balances, a schedule of all investments, and a report providing information on all
investment types, costs, interest rates, maturity dates and current market value.
Reports prepared by FTN Main Street Capital Advisors are as follows:
Portfolio Summary
Investment Policy Compliance Report
Historical Earnings & Book Rate
Portfolio Summary - Management
Lynwood Public Financing Authority - Page 3 of 26 Agenda Item # 2
Portfolio Details – Investments Report
Inventory by Maturity Report
Credit Rating Report
Interest Earnings Report
Accrued Interest Report
Gains/Losses Report
Cash Reconciliation Report
Monthly Economic & Market Update Report
Discussion and Analysis:
The market value of securities fluctuates, depending on how interest rates perform. When interest rates decrease,
the market value of the securities in the City’s portfolio will likely increase and when the interest rates increase, the
market value of the securities will likely decrease. The City’s practice is to buy and hold investments until maturity
so changes in the market price do not affect the City’s investment principal.
Short-term excess cash is primarily invested in the Local Agency Investment Fund (LAIF) administered by the
State Treasurer. LAIF is a high quality investment available in terms of safety, liquidity and yield. The City’s cash
and investment portfolio is sufficiently liquid to meet expected expenditures for the coming six months.
The majority of property tax revenues are received from the County in December and April. The vast majority of
cash held by the City is deposited into the Local Agency Investment Fund and can be withdrawn at any time.
There are three petty cash funds totaling $1,700.00 currently being used by various departments. There are two
change funds totaling $640.00; Water Billing $600.00 and Recreation $40.00.
The total amount of Non Sufficient Funds (NSF) from customers for the 2nd quarter reporting is $18,550.43 of
which, $1,376.30 has been collected. The remaining balance of Non Sufficient Funds outstanding for the 2nd
quarter is $17,174.13.
The market valuation is provided by FTN Main Street Capital Advisors and all of the investments are in compliance with
California Government Code Sections 53600 et seq. and the City’s investment policy.
Fiscal Impact:
The action recommended in this report will not have a fiscal impact on the City.
Coordinated With:
FTN Financial Main Street Advisors.
ATTACHMENTS:
Description
Quarterly Report - December 2019
FHN - December 2019 Investment Report
Lynwood Public Financing Authority - Page 4 of 26 Agenda Item # 2
Schedule of City Cash & Investments: This schedule provides information on the cash and investments
managed by the City.
Quarterly Interest Credit
Money Market/Certificate of Deposit (CD)Balance Interest F/Y to Date
JP Morgan Chase - Section 108 MMA 125,153.13$ 131.31$ 308.73$
JP Morgan Chase - Money Market Account 1,880,164.79$ 1,972.55$ 4,637.88$
JP Morgan Chase - Parking Enforcement 3,492,871.91$ 3,602.11$ 8,198.99$
US Bank - City of Lynwood 4,539.07$ 0.10$ 0.10$
Total 5,502,728.90$ 5,706.07$ 13,145.70$
Demand Deposits
General Account 6,406,691.87
US Bank - Economic Development 11,868.61
US Bank - Housing Authority A 29,527.83
US Bank - Housing Authority B 18,000.09$
US Bank - City HCDA 78,719.79$
US Bank - City Home Program 465,727.00
US Bank - Taxable Tabs 1,710,209.45$
US Bank - Lyn Tr. Center Unf Wrkr 2,791.24$
US Bank - Money Market Account 49,028.48$
US Bank - US Dept. of HUD/Section 108 170,048.96$
US Bank - RORF Successor Agency 3,290,268.15
US Bank - Low Mod Housing Trst Fnd/Rogel 299,438.43
US Bank - Lynwood Disaster Relief Fund 5,000.00$
US Bank - Settlement Remittance Fund 526,140.83
US Bank - Housing Authority 6,376.71$
Total 13,069,837.44$
Money Market Fund - A Money Market fund is a type of mutual fund that invest in short term debt
securities of agenies of the U.S. Government, banks, corporations and U.S. Treasury Bills.
Some advantages of a money market fund over savings and CDs are high liquidity, low risk, and competive yields.
The City currently has a total of five MMA accounts within the City's investment portfolio.
Certificate of Deposit - A Certificate of Deposit or CD, is a time deposit. They are similar to savings
accounts in that they are insured and relatively risk-free. They are different from savings accounts in that
they usually are for a fixed term and a fixed interest rae. CDs are inteded to be held until maturity, at which
time, the money may be withdrawn together with the accrued interest. The City currently has one CD
within the City's investment portfolio
Demand Deposits - Also known as "cash in the bank", this is the balance of the City's checking account with
US Bank, from which virtually all obligations are paid.
CITY OF LYNWOOD
QUARTERLY INVESTMENT REPORT
December 31, 2019
Lynwood Public Financing Authority - Page 5 of 26 Agenda Item # 2
Dec 2019.xls
Quarterly Date Interest
Issuer Investment Balance Interest Rec'd Received Rate
State of California LAIF 15,722,784.66 124,231.85 15-Oct-19 2.29%
Local Agency Investment Fund (LAIF):
The Local Agency Investment Fund is managed by the State Treasurer's Office Investment Division through the Pooled Money
Investment Account (PIMA). The LAIF allows cities, counties and special districts to place money in a major portfolio and to use
the expertise of their Investment Division staff, with no additional cost to taxpayers. Participating agencies can withdraw their funds
from the LAIF at any time. The State Treasurer invests money safely and prudently while minimizing the service costs and maximizing
the service costs and maximizing the investment yields. These investments help manage cash flow and enhance financial security.
The interest earned from the LAIF is distribued quarterly. (See Chart Below)
88.9 Billion
12/31/2019
CITY OF LYNWOOD
QUARTERLY REPORT
December 31, 2019
LAIF Daily Yield 2.03 - Quarter to Date 2.12 - Average Days to Maturity 225
Pooled Money Investment Account
Portfolio Composition
0 0.2 0.4 0.6 0.8 1
Loans
Corporate Bonds
Commercial Paper
Now Accounts
Time Deposits
CDs/BNs
Agencies
Mortgages
Treasuries
10.68%
0.00%
7.61%
0.00%
5.33%
18.16%
14.32%
0.00%
53.88%
Lynwood Public Financing Authority - Page 6 of 26 Agenda Item # 2
Dec 2019.xls
PAR MARKET BOOK
INVESTMENTS VALUE VALUE VALUE
*Money Market Funds 87,896.32$ 87,896.32$ 87,896.32$
LAIF 15,722,784.66$ 15,722,784.66$ 15,722,784.66$
Corporate Notes 3,500,000.00$ 3,593,480.00$ 3,525,225.65$
Federal Agency 2,550,000.00$ 2,571,624.50$ 2,545,019.63$
Treasury Coupon Securities 250,000.00$ 250,547.50$ 248,395.22$
CD-FDIC 4,712,000.00$ 4,808,951.12$ 4,708,098.04$
TOTAL 26,822,680.98$ 27,035,284.10$ 26,837,419.52$
*Money Market Fund held at Goldman Sach
Schedule of City Cash & Investments: This schedule provides information on the cash and investments
managed by the City.
Time Deposit/MM/Certificate of Deposit Balance Maturity Date Interest
JP Morgan Chase (Section 108)125,153.13$ N/A 131.31$
JP Morgan Chase - Money Market Account 1,880,164.79$ N/A 1,972.55$
JP Morgan Chase - Parking Enforcement 3,492,871.91$ N/A 3,602.11$
US Bank - City of Lynwood 4,539.07$ N/A 0.10$
TOTAL 5,502,728.90$ 5,706.07$
Corporate Checking Accounts Balance
General Account 6,406,691.87$
US Bank - City HCDA 78,719.79$
US Bank - City Home Program 465,727.00$
US Bank - Economic Development 11,868.61$
US Bank - Housing Authority A 29,527.83$
US Bank - Housing Authority B 18,000.09$
US Bank - Lyn Tr. Center Unf Wrkr 2,791.24$
US Bank - City of Lynwood 49,028.48$
US Bank - RORF Successor Agency 3,290,268.15$
US Bank - Low Mod Housing Trst Fnd/Rogel 299,438.43$
US Bank - Taxable Tabs Housing Proj. 1,710,209.45$
US Bank - US Dept. of HUD/Section 108 170,048.96$
US Bank - Lynwood Disaster Relief Fund 5,000.00$
US Bank - Settlement Remittance Fund 526,140.83$
US Bank - Housing Authority 6,376.71$
TOTAL 13,069,837.44$
CITY OF LYNWOOD
QUARTERLY REPORT
31-Dec-19
PORTFOLIO SUMMARY
Lynwood Public Financing Authority - Page 7 of 26 Agenda Item # 2
Dec 2019.xls
AVERAGE
MARKET PERCENTAGE (%)DAYS TO
DESCRIPTION VALUE PORTFOLIO MATURITY
INVESTMENTS*27,035,284.10 100%*
CERTIFICATE OF DEPOSIT/TIME DEPOSIT/
MONEY MARKET/CUSTODY HOLDINGS 5,502,728.90
CHECKING ACCOUNT 13,069,837.44
TOTAL AVERAGES 18,572,566.34$
TOTAL INVESTMENTS & AVERAGES 45,607,850.44$
Gabriela Camacho
Gabriela Camacho/Sheila Harding I certify that this report accurately reflects all pooled
City Treasurer/Deputy Treasurer investment policy statements adopted by the City Council
on August 15, 1995. A copy of this policy is available at
the office of the City Clerk. The Investment Program herein
shown provides sufficient cash flow liquidy to meet 3 to 6
months estimated expenditures.
*See Report Prepared by Main Street Capital Advisors
CITY OF LYNWOOD
QUARTERLY REPORT
December 31, 2019
MASTER SUMMARY
Lynwood Public Financing Authority - Page 8 of 26 Agenda Item # 2
Jan - Mar Apr - June July - Sept Oct - Dec
Investments Managed by Main Street 22,784,016.84 $32,094,288.70 30,368,003.03 $27,035,284.10
Cash & Investments 14,074,630.18 $18,198,426.89 14,975,380.23 $18,572,566.34
Per Treasurer's Reports 36,858,647.02 50,292,715.59$ $45,343,383.26 45,607,850.44$
Accounts
Balances per Statement Beginning Credits Debits Ending
US Bank - General Account*2,500,537.73$ 7,835,442.88$ 7,619,250.22$ 2,716,730.39$
*Local Agency Investment Fund 19,098,552.81$ 124,231.85$ 1,000,000.00$ 18,222,784.66$
US Bank - Economic Development 10,696.54$ -$ -$ 10,696.54$
US Bank - RORF - Successor Agency 1,577,007.27$ -$ 176,304.75$ 1,400,702.52$
Accounts
Balances per Statement Beginning Credits Debits Ending
US Bank - General Account*2,716,730.39$ 5,293,784.53$ 5,072,650.75$ 2,937,864.17$
*Local Agency Investment Fund 18,222,784.66$ 500,000.00$ 17,722,784.66$
US Bank - Economic Development 10,696.54$ 1,172.07$ -$ 11,868.61$
US Bank - RORF - Successor Agency 1,400,702.52$ -$ 1,800.00$ 1,398,902.52$
Accounts
Balances per Statement Beginning Credits Debits Ending
US Bank - General Account 2,937,864.17$ 10,842,450.52$ 7,373,622.82$ 6,406,691.87$
*Local Agency Investment Fund 17,722,784.66$ -$ 2,000,000.00$ 15,722,784.66$
US Bank - Economic Development 11,868.61$ -$ -$ 11,868.61$
US Bank - RORF - Successor Agency 1,398,902.52$ 1,891,365.63$ -$ 3,290,268.15$
QUARTERLY TOTAL OF DEBITS/CREDITS 38,873,005.94$ 25,739,739.01$
*Funds transferred from LAIF account to the general account to cover expenditures
2019
Oct-19
Nov-19
Dec-19
CITY OF LYNWOOD
QUARTERLY REPORT
31-Dec-19
MONTHLY BALANCES PER STATEMENT
DEMAND DEPOSIT ACCOUNTS
BALANCES PER QUARTER
Lynwood Public Financing Authority - Page 9 of 26 Agenda Item # 2
Portfolio Summary
LAIF
FFCB
Market Value JP Morgan Chase & Co.
Book Value FNMA
Variance Citibank
FHLB
Par Value FHLMC
Oracle
Net Asset Value Toyota
US Bank
Book Yield Met Life
Walmart
Years to Maturity Honda
John Deere
Effective Duration Apple
*Book Value is Amortized
$197,865 $214,597
$26,822,681 $28,797,324
1.9%
1.9%
1.9%
1.3%
1.9%
$100.737 $100.745
12/31/19 11/30/19
$27,035,284 $29,026,520
$26,837,420 $28,811,923
0.9%
0.9%
0.9%
0.9%
0.9%
0.9%
1.0%
0.9%
12/31/2019
SECTOR ALLOCATION MATURITY DISTRIBUTION CREDIT QUALITY (MOODY'S)
City of Lynwood
ACCOUNT SUMMARY MONTH-END PORTFOLIO BOOK YIELD TOP ISSUERS
Issuer % Portfolio
58.6%
4.5%
2.20% 2.22%
1.02 0.98
0.91 0.94
Agy 9.5%
Tsy 0.9%
LAIF 58.6%
MMF 0.3%
CD-FDIC
17.5%
CP
0.0%
Corp 13.1%67.6%
9.3%7.4%7.4%8.3%
0%
10%
20%
30%
40%
50%
60%
70%
80%
0-1Y 1-2Y 2-3Y 3-4Y 4-5Y
58.6%
17.5%
0.0%
0.0%
3.8%
4.7%
0.9%
0.9%
2.8%
10.7%
0%25%50%75%
NR-LAIF
NR-FDIC CDs
P-1
A3
A2
A1
Aa1
Aa2
Aa3
Aaa
2.10%
2.15%
2.20%
2.25%
2.30%
2.35%
2.40%
2.45%
2.50%
2.55%Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-19Dec-19Total Ex LAIF
NR: Not RatedPer Book ValuePer Book Value
Per Book Value
2Lynwood Public Financing Authority - Page 10 of 26 Agenda Item # 2
Investment Policy Compliance
Securities' market values are derived from the Entity's custodian.
0.0%
0.0%
0.3%
13.1%
Yes:
Yes:
Yes:
Yes:
Yes:
Yes:
Yes:
Yes:
Yes:
9.5%
17.5%
0.0%
15.7 Mil
Supranational Debt Obligations
U.S. Federal Agencies No sector limit, no issuer limit (FHLB, FFCB, FNMA, FHLMC), maximum maturity 5 years
Commercial Paper
25% sector limit, no issuer limit, maximum maturity of 1 year, issued by national/state charter banks or
savings and loan associations, collateralized according to State Code
LAIF No sector limit, issuer limit is $65 million
Negotiable Certificates of Deposit 30% sector limit, issuer limit no greater than FDIC insured limit (currently $250,000), max maturity 5
years, issued by national/state charter banks or savings and loan associations
30% limit, 5% per issuer of US dollar-denominated senior unsecured unsubordinated obligations
guaranteed by IBRD, IFC, and IABD. Max maturity 5 years, min rating by 2 NRSRO's of AA.
Non-Negotiable Time Deposits
25% sector limit, 2% per issuer, maximum maturity 270 days, rated A-1 S&P or P-1 Moody's, issued by a
domestic corporation w/ at least $500 million of assets and A (S&P) or A2 (Moody's) long term debt
Money Market Mutual Funds Sector limit 20%, issuer limit 10%, Aaa (S&P) and AAA (Moody's)
Corporate Medium Term Notes 30% sectors limit, 2% issuer limit (includes CP in aggregate), maximum maturity 5 years, rated at least A
by S&P or A2 by Moody's
City of Lynwood 12/31/2019
0.9%Yes:
Weighted Average Maturity Weighted Average Maturity (WAM) must be less than 3.0 years
U.S. Treasuries No sector limit, no issuer limit, maximum maturity 5 years
Liquidity At least 30% of the portfolio must have maturities of 1 year or less Yes:67.6%
Item / Sector Parameters In Compliance
1.02 Yrs
3Lynwood Public Financing Authority - Page 11 of 26 Agenda Item # 2
Historical Earnings and Book Rate of Return Performance
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
$10.1 $24.6 $34.1 $51.3 $61.1 $70.7 $87.2 $96.6 $107.6 $123.5 $133.8 $144.8
$12.2 $25.2 $38.6 $60.4 $73.8 $87.6 $109.0 $122.3 $136.9 $159.5 $174.8 $190.5
$16.9 $34.0 $49.5 $78.2 $93.6 $109.5 $136.7 $154.3 $173.9 $205.9 $225.9 $245.5
$20.7 $42.0 $63.2 $85.8 $106.6 $128.0 $152.4 $176.5 $200.9 $225.6 $252.5 $281.1
$28.6 $53.2 $75.2 $99.7 $122.7 $145.5 $174.9 $200.2 $229.0 $261.9 $297.4 $332.7
$37.9 $76.5 $113.6 $155.5 $190.6 $227.5 $272.8 $315.9 $362.6 $413.0 $462.1 $527.1
$65.1 $31.7 $187.2 $249.1 $303.1 $354.9
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
2.41%2.38%2.36%2.31%2.27%2.21%
Custom Benchmark*2.38%2.39%2.31%2.25%2.19%2.15%
0.03%-0.01%0.05%0.06%0.08%0.06%
*Benchmark: 60% LAIF's Monthly Distribution Rate; ICE BofAML 24 Month Moving Average of 25% the 1-5 Year Corporate Index, 15% 1-5 Year Agency Index
City of Lynwood 12/31/2019
Variance
Book Rate of Rtn
Fiscal YTD ($000s)
FY 2014
FY 2015
FY 2016
FY 2017
FY 2018
FY 2019
FY 2020
$0
$100
$200
$300
$400
$500
$600
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May JunThousandsFiscal Year-to-Date Earnings
FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020
2.00%
2.10%
2.20%
2.30%
2.40%
2.50%
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
Monthly Book Rate of Return vs Benchmark
Portfolio
Benchmark
13Lynwood Public Financing Authority - Page 12 of 26 Agenda Item # 2
1-10-20
16Lynwood Public Financing Authority - Page 13 of 26 Agenda Item # 2
Moody's
Page 1
Par Value Book Value Maturity
Date
Stated
RateMarket Value
December 31, 2019
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
Lynwood - Portfolio Management
S&P
YTM
365CUSIPInvestment #Purchase
Date
Money Market Funds
AaaGoldman Sach Govt MMF10011 87,896.32 87,896.32 1.50087,896.32 1.5009000 AAA
87,896.32 1.50087,896.3287,896.3273,031.43Subtotal and Average
LAIF
LAIF10000 15,722,784.66 15,722,784.66 2.03015,722,784.66 2.0309001
15,722,784.66 2.03015,722,784.6615,722,784.6616,464,720.14Subtotal and Average
Corporate Notes
Aa1Apple10118250,000.00 249,889.38 08/04/20211.55008/04/2016 249,062.50 1.579037833CC2 AA+
A1BMW10149250,000.00 249,192.10 04/12/20213.10010/09/2018 253,752.50 3.36505565EAU9 A+
Aa3Citibank10134250,000.00 249,980.55 10/20/20202.12510/23/2017 250,302.50 2.13517325FAJ7 A+
A1Cisco10123250,000.00 247,607.68 09/20/20211.85011/29/2016 250,172.50 2.44317275RBJ0 AA-
A2John Deere10125 250,000.00 249,963.69 01/15/20201.70003/21/2017 249,977.50 2.08624422ERY7 A
A2Honda10150250,000.00 250,054.74 10/10/20233.62510/10/2018 264,010.00 3.61902665WCQ2 A
A1Jackson Natl Life10128 250,000.00 248,893.18 06/27/20222.50007/12/2017 253,525.00 2.69146849LSW2 AA-
A2JP Morgan Chase & Co.10160 500,000.00 513,200.43 05/13/20243.62505/13/2019 530,055.00 2.97046625HJX9 A-
Aa3Met Life10135 250,000.00 251,025.09 04/08/20222.65011/02/2017 253,707.50 2.45859217GCD9 AA-
A1Oracle10166250,000.00 259,711.74 11/15/20242.95011/27/2019 259,877.50 2.10668389XBS3 A+
Aa3Toyota10155250,000.00 252,931.21 01/08/20243.35002/28/2019 262,485.00 3.03389236TFS9 AA-
A1US Bank10156 250,000.00 252,680.68 07/24/20233.40003/01/2019 261,207.50 3.07690331HNV1 AA-
Aa2Walmart10142250,000.00 250,095.18 06/23/20213.12506/27/2018 255,345.00 3.098931142EJ8 AA
3,525,225.65 2.6883,593,480.003,500,000.003,525,363.39Subtotal and Average
Federal Agency
AaaFFCB10152500,000.00 500,785.70 11/15/20213.05011/27/2018 513,145.00 2.9613133EJT74 AA+
AaaFFCB10162500,000.00 499,909.95 07/01/20241.90007/02/2019 503,220.00 1.9043133EKTV8 AA+
AaaFFCB10165200,000.00 198,437.05 10/16/20241.50010/17/2019 197,506.00 1.6713133EK3B0 AA+
AaaFHLB10124500,000.00 497,367.96 12/10/20211.87512/28/2016 502,445.00 2.1623130AAB49 AA+
AaaFHLMC10126350,000.00 350,000.00 04/27/20201.58004/27/2017 349,933.50 1.5803134GBHX3 AA+
AaaFNMA10136500,000.00 498,518.97 10/05/20222.00011/30/2017 505,375.00 2.1133135G0T78 AA+
2,545,019.63 2.1412,571,624.502,550,000.002,544,948.75Subtotal and Average
Treasury Coupon Securities
AaaU.S. Treasury10158 250,000.00 248,395.22 12/15/20201.87503/04/2019 250,547.50 2.5679128283L2 AA+
Portfolio LYNW
APData Updated: SET_PMM: 01/09/2020 08:36
Run Date: 01/09/2020 - 08:36 PM (PRF_PM2) 7.3.0
Report Ver. 7.3.6.1 18Lynwood Public Financing Authority - Page 14 of 26 Agenda Item # 2
Moody's
Page 2
Par Value Book Value Maturity
Date
Stated
RateMarket Value
December 31, 2019
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
Lynwood - Portfolio Management
S&P
YTM
365CUSIPInvestment #Purchase
Date
248,395.22 2.567250,547.50250,000.00248,326.24Subtotal and Average
CD-FDIC
Comenity Capital Bank10143 248,000.00 247,599.99 06/29/20233.30006/29/2018 261,735.94 3.40320033AZK5
Ally Bank10127 248,000.00 247,942.79 06/22/20201.90006/23/2017 247,998.93 1.95202006L3N1
Barclays Bank10133 248,000.00 247,912.19 09/21/20201.95009/21/2017 248,066.42 2.00106740KKU0
BMW Bank10130 248,000.00 247,923.81 08/18/20201.90008/21/2017 247,979.67 1.95205580AKA1
Citibank10154 248,000.00 247,523.49 02/27/20243.00002/28/2019 261,046.33 3.05217312Q3B3
Enerbank10164 248,000.00 247,554.21 09/27/20232.00009/30/2019 250,796.10 2.05229278TLY4
Capital One Bank USA10129 248,000.00 247,698.54 08/02/20222.30008/03/2017 251,890.51 2.3511404203Z1
Eagle Bank10159 248,000.00 248,000.00 05/20/20222.60005/10/2019 253,297.79 2.60527002YEM4
Flagstar Bank10161 248,000.00 248,000.00 06/13/20222.50006/12/2019 252,880.39 2.50033847E2J5
First Missouri Bank10163 248,000.00 248,000.00 09/13/20241.85009/13/2019 249,477.64 1.85232100LCB9
Goldman Sachs Bank10144 248,000.00 247,600.62 07/06/20233.30007/09/2018 261,743.08 3.35238148PR33
HSBC10116 248,000.00 248,000.00 07/08/20201.40007/08/2016 247,338.14 1.40140434AZ44
Key Bank10131 248,000.00 247,922.29 08/21/20201.85008/24/2017 247,899.63 1.90349306SYR1
Merrick Bank10153 248,000.00 247,636.27 02/21/20233.35012/19/2018 260,826.78 3.40759013J5Z8
Morgan Stanley Bank10137 248,000.00 247,646.81 01/11/20232.65001/12/2018 255,163.22 2.70261747MF63
State Bank of India10138 248,000.00 247,863.08 02/16/20212.45002/15/2018 249,335.51 2.503856285HL8
Salllie Mae Bank10132 248,000.00 247,691.83 08/23/20222.35008/24/2017 252,297.69 2.402795450D36
Synchrony Bank10115 248,000.00 248,000.00 06/29/20211.55006/29/2016 246,822.26 1.55187165HNN6
Wells Fargo Bank10147 248,000.00 247,582.12 08/30/20233.30008/31/2018 262,355.09 3.354949763TF3
4,708,098.04 2.4364,808,951.124,712,000.004,708,030.33Subtotal and Average
2.20127,564,420.29 26,822,680.98 27,035,284.10 26,837,419.52Total and Average
Portfolio LYNW
APData Updated: SET_PMM: 01/09/2020 08:36
Run Date: 01/09/2020 - 08:36 PM (PRF_PM2) 7.3.0
19Lynwood Public Financing Authority - Page 15 of 26 Agenda Item # 2
Lynwood - Maturity Report
Inventory by Maturity Report
December 31, 2019
Current
Rate
Par
Value
Book
Value
Sec.
TypeFund Date Maturity
Amount
Days toTotal
Days 360 365MaturityYTM
MaturityCUSIPInvestment #Issuer Purchase
Date
15,722,784.662.03015,722,784.66 15,722,784.6607/01/2019LAIF100009001PA2LYNL 12.0302.0021
87,896.321.50087,896.32 87,896.3207/01/2019Goldman Sach Govt MMF100119000PA1LYN 11.5001.4791
250,000.001.700249,963.69 250,000.0003/21/2017John Deere1012524422ERY7MTNLYN 01/15/2020 142.0862.0581,030
350,000.001.580350,000.00 350,000.0004/27/2017FHLMC101263134GBHX3FACLYN 04/27/2020 1171.5801.5581,096
248,000.001.900247,942.79 248,000.0006/23/2017Ally Bank1012702006L3N1MC2LYN 06/22/2020 1731.9521.9251,095
248,000.001.400248,000.00 248,000.0007/08/2016HSBC1011640434AZ44MC2LYN 07/08/2020 1891.4011.3821,461
248,000.001.900247,923.81 248,000.0008/21/2017BMW Bank1013005580AKA1MC2LYN 08/18/2020 2301.9521.9251,093
248,000.001.850247,922.29 248,000.0008/24/2017Key Bank1013149306SYR1MC2LYN 08/21/2020 2331.9031.8761,093
248,000.001.950247,912.19 248,000.0009/21/2017Barclays Bank1013306740KKU0MC2LYN 09/21/2020 2642.0011.9731,096
250,000.002.125249,980.55 250,000.0010/23/2017Citibank1013417325FAJ7MTNLYN 10/20/2020 2932.1352.1061,093
250,000.001.875248,395.22 250,000.0003/04/2019U.S. Treasury101589128283L2TRCLYN 12/15/2020 3492.5672.531652
248,000.002.450247,863.08 248,000.0002/15/2018State Bank of India10138856285HL8MC2LYN 02/16/2021 4122.5032.4691,097
250,000.003.100249,192.10 250,000.0010/09/2018BMW1014905565EAU9MTNLYN 04/12/2021 4673.3653.319916
250,000.003.125250,095.18 250,000.0006/27/2018Walmart10142931142EJ8MTNLYN 06/23/2021 5393.0983.0551,092
248,000.001.550248,000.00 248,000.0006/29/2016Synchrony Bank1011587165HNN6MC2LYN 06/29/2021 5451.5511.5301,826
250,000.001.550249,889.38 250,000.0008/04/2016Apple10118037833CC2MTNLYN 08/04/2021 5811.5791.5571,826
250,000.001.850247,607.68 250,000.0011/29/2016Cisco1012317275RBJ0MTNLYN 09/20/2021 6282.4432.4091,756
500,000.003.050500,785.70 500,000.0011/27/2018FFCB101523133EJT74FACLYN 11/15/2021 6842.9612.9211,084
500,000.001.875497,367.96 500,000.0012/28/2016FHLB101243130AAB49FACLYN 12/10/2021 7092.1622.1321,808
250,000.002.650251,025.09 250,000.0011/02/2017Met Life1013559217GCD9MTNLYN 04/08/2022 8282.4582.4241,618
248,000.002.600248,000.00 248,000.0005/10/2019Eagle Bank1015927002YEM4MC2LYN 05/20/2022 8702.6052.5691,106
248,000.002.500248,000.00 248,000.0006/12/2019Flagstar Bank1016133847E2J5MC2LYN 06/13/2022 8942.5002.4661,097
250,000.002.500248,893.18 250,000.0007/12/2017Jackson Natl Life1012846849LSW2MTNLYN 06/27/2022 9082.6912.6541,811
248,000.002.300247,698.54 248,000.0008/03/2017Capital One Bank USA101291404203Z1MC2LYN 08/02/2022 9442.3512.3191,825
248,000.002.350247,691.83 248,000.0008/24/2017Salllie Mae Bank10132795450D36MC2LYN 08/23/2022 9652.4022.3691,825
500,000.002.000498,518.97 500,000.0011/30/2017FNMA101363135G0T78FACLYN 10/05/2022 1,0082.1132.0841,770
248,000.002.650247,646.81 248,000.0001/12/2018Morgan Stanley Bank1013761747MF63MC2LYN 01/11/2023 1,1062.7022.6651,825
248,000.003.350247,636.27 248,000.0012/19/2018Merrick Bank1015359013J5Z8MC2LYN 02/21/2023 1,1473.4073.3601,525
248,000.003.300247,599.99 248,000.0006/29/2018Comenity Capital Bank1014320033AZK5MC2LYN 06/29/2023 1,2753.4033.3571,826
248,000.003.300247,600.62 248,000.0007/09/2018Goldman Sachs Bank1014438148PR33MC2LYN 07/06/2023 1,2823.3523.3061,823
250,000.003.400252,680.68 250,000.0003/01/2019US Bank1015690331HNV1MTNLYN 07/24/2023 1,3003.0763.0331,606
248,000.003.300247,582.12 248,000.0008/31/2018Wells Fargo Bank10147949763TF3MC2LYN 08/30/2023 1,3373.3543.3081,825
248,000.002.000247,554.21 248,000.0009/30/2019Enerbank1016429278TLY4MC2LYN 09/27/2023 1,3652.0522.0231,458
250,000.003.625250,054.74 250,000.0010/10/2018Honda1015002665WCQ2MTNLYN 10/10/2023 1,3783.6193.5691,826
250,000.003.350252,931.21 250,000.0002/28/2019Toyota1015589236TFS9MTNLYN 01/08/2024 1,4683.0332.9921,775
Portfolio LYNW
APData Updated: SET_MAT: 01/09/2020 08:43
Run Date: 01/09/2020 - 08:43 IM (PRF_IM) 7.1.1
Report Ver. 7.3.6.1
20Lynwood Public Financing Authority - Page 16 of 26 Agenda Item # 2
Current
Rate
Par
Value
Book
Value
Sec.
Type
Page 2
Fund Date
Maturity
Amount
Days toTotal
Days 360 365
Maturity YTM
Maturity
Inventory by Maturity Report
Lynwood - Maturity Report
CUSIP Investment #Issuer
Purchase
Date
248,000.003.000247,523.49 248,000.0002/28/2019Citibank1015417312Q3B3MC2LYN 02/27/2024 1,5183.0523.0101,825
500,000.003.625513,200.43 500,000.0005/13/2019JP Morgan Chase & Co.1016046625HJX9 MTNLYN 05/13/2024 1,5942.9702.9291,827
500,000.001.900499,909.95 500,000.0007/02/2019FFCB101623133EKTV8FACLYN 07/01/2024 1,6431.9041.8781,826
248,000.001.850248,000.00 248,000.0009/13/2019First Missouri Bank1016332100LCB9MC2LYN 09/13/2024 1,7171.8521.8271,827
200,000.001.500198,437.05 200,000.0010/17/2019FFCB101653133EK3B0FACLYN 10/16/2024 1,7501.6711.6481,826
250,000.002.950259,711.74 250,000.0011/27/2019Oracle1016668389XBS3MTNLYN 11/15/2024 1,7802.1062.0771,815
Subtotal and Average 26,822,680.98 26,822,680.9826,837,419.52 2.171 2.201 371
26,822,680.98 26,822,680.9826,837,419.52Net Maturities and Average 2.171 2.201 371
Portfolio LYNW
APData Updated: SET_MAT: 01/09/2020 08:43
Run Date: 01/09/2020 - 08:43 IM (PRF_IM) 7.1.1
Report Ver. 7.3.6.1
21Lynwood Public Financing Authority - Page 17 of 26 Agenda Item # 2
Lynwood - Credit Rating
Credit Rating Report
December 31, 2019
Sorted by Moody's - Investment Number
Security #Purchase
Principal
Book
ValueInvestment #% of
Total
Moody's
RatingIssuerMarket
Value
S&P
Rating
Purchase
Date
Maturity
Date
Days To
Maturity
Stated
Rate YTM
10011 9000GSGF 07/01/2019Aaa AAA87,896.32 87,896.32 87,896.32 1 1.500 1.500 0.33
12/10/2021101243130AAB49FHLB12/28/2016Aaa AA+493,290.00 497,367.96 502,445.00 709 1.875 2.162 1.85
04/27/2020101263134GBHX3FHLMC04/27/2017Aaa AA+350,000.00 350,000.00 349,933.50 117 1.580 1.580 1.30
10/05/2022101363135G0T78FNMA11/30/2017Aaa AA+497,400.00 498,518.97 505,375.00 1,008 2.000 2.113 1.86
11/15/2021101523133EJT74FFCB11/27/2018Aaa AA+501,245.00 500,785.70 513,145.00 684 3.050 2.961 1.87
12/15/2020101589128283L2USTR03/04/2019Aaa AA+247,001.95 248,395.22 250,547.50 349 1.875 2.567 0.93
07/01/2024101623133EKTV8FFCB07/02/2019Aaa AA+499,900.00 499,909.95 503,220.00 1,643 1.900 1.904 1.86
10/16/2024101653133EK3B0FFCB10/17/2019Aaa AA+198,370.00 198,437.05 197,506.00 1,750 1.500 1.671 0.74
SubTotal for Aaa 2,875,103.27 2,881,311.17 2,910,068.32 10.742.1582.032866
08/04/202110118037833CC2AAPL08/04/2016Aa1 AA+249,652.50 249,889.38 249,062.50 581 1.550 1.579 0.93
SubTotal for Aa1 249,652.50 249,889.38 249,062.50 0.931.5791.550581
06/23/202110142931142EJ8WMT06/27/2018Aa2 AA250,192.50 250,095.18 255,345.00 539 3.125 3.098 0.93
SubTotal for Aa2 250,192.50 250,095.18 255,345.00 0.933.0983.125539
10/20/20201013417325FAJ7C10/23/2017Aa3 A+249,927.50 249,980.55 250,302.50 293 2.125 2.135 0.93
04/08/20221013559217GCD9MET11/02/2017Aa3 AA-252,002.50 251,025.09 253,707.50 828 2.650 2.458 0.94
01/08/20241015589236TFS9TOY02/28/2019Aa3 AA-253,545.00 252,931.21 262,485.00 1,468 3.350 3.033 0.94
SubTotal for Aa3 755,475.00 753,936.85 766,495.00 2.812.5442.711865
09/20/20211012317275RBJ0CSCO11/29/2016A1 AA-243,310.00 247,607.68 250,172.50 628 1.850 2.443 0.92
06/27/20221012846849LSW2JAC07/12/2017A1 AA-247,795.00 248,893.18 253,525.00 908 2.500 2.691 0.93
04/12/20211014905565EAU9BMWW10/09/2018A1 A+248,417.50 249,192.10 253,752.50 467 3.100 3.365 0.93
07/24/20231015690331HNV1USB03/01/2019A1 AA-253,307.50 252,680.68 261,207.50 1,300 3.400 3.076 0.94
11/15/20241016668389XBS3ORCL11/27/2019A1 A+259,900.00 259,711.74 259,877.50 1,780 2.950 2.106 0.97
SubTotal for A1 1,252,730.00 1,258,085.38 1,278,535.00 4.692.7322.7651024
01/15/20201012524422ERY7DE03/21/2017A2 A247,370.00 249,963.69 249,977.50 14 1.700 2.086 0.93
10/10/20231015002665WCQ2HNDA10/10/2018A2 A250,072.50 250,054.74 264,010.00 1,378 3.625 3.619 0.93
05/13/20241016046625HJX9JPM05/13/2019A2 A-515,115.00 513,200.43 530,055.00 1,594 3.625 2.970 1.91
SubTotal for A2 1,012,557.50 1,013,218.86 1,044,042.50 3.772.9123.1501151
10000 9001LAIF 07/01/2019None None15,722,784.66 15,722,784.66 15,722,784.66 1 2.030 2.030 58.59
06/29/20211011587165HNN6SYF06/29/2016None None248,000.00 248,000.00 246,822.26 545 1.550 1.551 0.92
07/08/20201011640434AZ44HSBC07/08/2016None None248,000.00 248,000.00 247,338.14 189 1.400 1.401 0.92
Portfolio LYNW
APData Updated: SET_CRE: 01/09/2020 08:50
Run Date: 01/09/2020 - 08:50 CR (PRF_CR) 7.2.0
Report Ver. 7.3.6.1
22Lynwood Public Financing Authority - Page 18 of 26 Agenda Item # 2
Sorted by Moody's - Investment Number
Page 2Credit Rating Report
Lynwood - Credit Rating
Security #Purchase
Principal
Book
ValueInvestment #% of
Total
Moody's
RatingIssuerMarket
Value
S&P
Rating
Purchase
Date
Maturity
Date
Days To
Maturity
Stated
Rate YTM
06/22/20201012702006L3N1ALLY06/23/2017None None247,637.92 247,942.79 247,998.93 173 1.900 1.952 0.92
08/02/2022101291404203Z1COFU08/03/2017None None247,417.20 247,698.54 251,890.51 944 2.300 2.351 0.92
08/18/20201013005580AKA1BMW08/21/2017None None247,637.92 247,923.81 247,979.67 230 1.900 1.952 0.92
08/21/20201013149306SYR1KEY08/24/2017None None247,635.44 247,922.29 247,899.63 233 1.850 1.903 0.92
08/23/202210132795450D36SLMA08/24/2017None None247,417.20 247,691.83 252,297.69 965 2.350 2.402 0.92
09/21/20201013306740KKU0BACR09/21/2017None None247,635.44 247,912.19 248,066.42 264 1.950 2.001 0.92
01/11/20231013761747MF63MSB01/12/2018None None247,417.20 247,646.81 255,163.22 1,106 2.650 2.702 0.92
02/16/202110138856285HL8SBIIN02/15/2018None None247,635.44 247,863.08 249,335.51 412 2.450 2.503 0.92
06/29/20231014320033AZK5ADS06/29/2018None None247,427.12 247,599.99 261,735.94 1,275 3.300 3.357 0.92
07/06/20231014438148PR33GOLD07/09/2018None None247,432.08 247,600.62 261,743.08 1,282 3.300 3.352 0.92
08/30/202310147949763TF3WFB08/31/2018None None247,429.60 247,582.12 262,355.09 1,337 3.300 3.354 0.92
02/21/20231015359013J5Z8MERICK12/19/2018None None247,516.40 247,636.27 260,826.78 1,147 3.350 3.407 0.92
02/27/20241015417312Q3B3C02/28/2019None None247,427.12 247,523.49 261,046.33 1,518 3.000 3.052 0.92
05/20/20221015927002YEM4EGBN05/10/2019None None248,000.00 248,000.00 253,297.79 870 2.600 2.605 0.92
06/13/20221016133847E2J5FBC06/12/2019None None248,000.00 248,000.00 252,880.39 894 2.500 2.500 0.92
09/13/20241016332100LCB9FMOSTB09/13/2019None None248,000.00 248,000.00 249,477.64 1,717 1.850 1.852 0.92
09/27/20231016429278TLY4CMS09/30/2019None None247,523.84 247,554.21 250,796.10 1,365 2.000 2.052 0.92
SubTotal for No Specified Rating 20,427,974.58 20,430,882.70 20,531,735.78 76.072.1232.114200
Portfolio LYNW
APData Updated: SET_CRE: 01/09/2020 08:50
Run Date: 01/09/2020 - 08:50 CR (PRF_CR) 7.2.0
Report Ver. 7.3.6.1
23Lynwood Public Financing Authority - Page 19 of 26 Agenda Item # 2
Page 1
December 31, 2019
Interest Earnings Summary
Month EndingDecember 31 Fiscal Year To Date
Portfolio Management
Lynwood - Portfolio Management
CD/Coupon/Discount Investments:
25,121.60Interest Collected
Plus Accrued Interest at End of Period
Less Accrued Interest at Beginning of Period
59,602.48
( 62,184.35)
126,883.20
59,602.48
( 54,583.18)
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
22,539.73
139.53
0.00
131,902.50
1,620.64
-111.47
22,679.26 133,411.67
Pass Through Securities:
0.00Interest Collected
Plus Accrued Interest at End of Period
Less Accrued Interest at Beginning of Period
0.00
( 0.00)
0.00
0.00
( 0.00)
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
0.00
0.00
0.00
0.00
0.00
0.00
0.00 0.00
Cash/Checking Accounts:
234.94Interest Collected
Plus Accrued Interest at End of Period
Less Accrued Interest at Beginning of Period
96,019.59
( 67,092.87)
223,003.87
96,019.59
( 97,536.04)
Interest Earned during Period 29,161.66 221,487.42
Total Interest Earned during Period
Total Adjustments from Premiums and Discounts
Total Capital Gains or Losses
Total Earnings during Period
51,701.39
139.53
0.00
353,389.92
1,620.64
-111.47
51,840.92 354,899.09
Portfolio LYNW
APData Updated: SET_PMM: 01/09/2020 08:36
Run Date: 01/09/2020 - 08:36 PM (PRF_PM6) 7.3.0
Report Ver. 7.3.6.1
26Lynwood Public Financing Authority - Page 20 of 26 Agenda Item # 2
Lynwood - Interest Reports
Interest Earnings
Sorted by Security Type - Maturity Date
December 1, 2019 - December 31, 2019
Yield on Beginning Book Value
Maturity
Date
Current
Rate
Ending
Par Value
Ending
IssuerFund Book Value
Beginning
Book Value
Adjusted Interest Earnings
Accretion
Amortization/
Earnings
Adjusted InterestAnnualized
YieldCUSIPInvestment #
Interest
Earned
Security Type: Money Market Funds
87,896.321001187,896.32 1.500GSGF 97.03 0.00 97.031.827LYN62,539.789000
87,896.32Subtotal 87,896.32 1.827 97.030.0097.0362,539.78
Security Type: LAIF
15,722,784.661000015,722,784.66 2.030LAIF 29,064.63 0.00 29,064.631.931LYNL17,722,784.669001
15,722,784.66Subtotal 15,722,784.66 1.931 29,064.630.0029,064.6317,722,784.66
Security Type: Corporate Notes
249,963.6910125250,000.00 1.700DE01/15/2020 354.16 77.81 431.972.035LYN249,885.8824422ERY7
249,980.5510134250,000.00 2.125C10/20/2020 442.71 2.02 444.732.095LYN249,978.5317325FAJ7
249,192.1010149250,000.00 3.100BMWW04/12/2021 645.83 52.57 698.403.301LYN249,139.5305565EAU9
250,095.1810142250,000.00 3.125WMT06/23/2021 651.04 -5.36 645.683.040LYN250,100.54931142EJ8
249,889.3810118250,000.00 1.550AAPL08/04/2021 322.91 5.79 328.701.549LYN249,883.59037833CC2
247,607.6810123250,000.00 1.850CSCO09/20/2021 385.42 115.95 501.372.385LYN247,491.7317275RBJ0
251,025.0910135250,000.00 2.650MET04/08/2022 552.08 -37.64 514.442.413LYN251,062.7359217GCD9
248,893.1810128250,000.00 2.500JAC06/27/2022 520.83 37.06 557.892.640LYN248,856.1246849LSW2
252,680.6810156250,000.00 3.400USB07/24/2023 708.33 -62.69 645.643.008LYN252,743.3790331HNV1
250,054.7410150250,000.00 3.625HNDA10/10/2023 755.21 -1.21 754.003.550LYN250,055.9502665WCQ2
252,931.2110155250,000.00 3.350TOY01/08/2024 697.91 -60.77 637.142.965LYN252,991.9889236TFS9
513,200.4310160500,000.00 3.625JPM05/13/2024 1,510.42 -251.92 1,258.502.886LYN513,452.3546625HJX9
259,711.7410166250,000.00 2.950ORCL11/15/2024 614.58 -166.11 448.472.032LYN259,877.8568389XBS3
3,500,000.00Subtotal 3,525,225.65 2.627 7,866.93-294.508,161.433,525,520.15
Security Type: Federal Agency
350,000.0010126350,000.00 1.580FHLMC04/27/2020 460.83 0.00 460.831.550LYN350,000.003134GBHX3
500,785.7010152500,000.00 3.050FFCB11/15/2021 1,270.83 -34.97 1,235.862.905LYN500,820.673133EJT74
497,367.9610124500,000.00 1.875FHLB12/10/2021 781.25 112.96 894.212.117LYN497,255.003130AAB49
498,518.9710136500,000.00 2.000FNMA10/05/2022 833.33 44.70 878.032.074LYN498,474.273135G0T78
Portfolio LYNW
APData Updated: SET_INT: 01/09/2020 08:49
Run Date: 01/09/2020 - 08:49 IE (PRF_IE) 7.2.0
Report Ver. 7.3.6.1
27Lynwood Public Financing Authority - Page 21 of 26 Agenda Item # 2
Lynwood - Interest Reports
Accrued Interest
Sorted by Security Type - Maturity Date
December 1, 2019 - December 31, 2019
Maturity
Date
Security
Type
Current
Rate
Par
Value
* Beginning
Accrued Interest
* Ending
Accrued Interest
Adjusted Acc'd Int.
at Purchase
During PeriodCUSIPInvestment #Interest
Earned
Interest
Received
Money Market Funds
234.9410011900087,896.32 1.500PA1 97.03 234.94 97.030.00
234.9487,896.32Subtotal 97.0397.03 234.940.00
LAIF
66,857.9310000900115,722,784.66 2.030PA2 29,064.63 0.00 95,922.560.00
66,857.9315,722,784.66Subtotal 95,922.5629,064.63 0.000.00
Corporate Notes
1,605.561012524422ERY7250,000.00 1.700MTN01/15/2020 354.16 0.00 1,959.720.00
605.031013417325FAJ7250,000.00 2.125MTN10/20/2020 442.71 0.00 1,047.740.00
1,054.861014905565EAU9250,000.00 3.100MTN04/12/2021 645.83 0.00 1,700.690.00
3,428.8210142931142EJ8250,000.00 3.125MTN06/23/2021 651.04 3,906.25 173.610.00
1,259.3810118037833CC2250,000.00 1.550MTN08/04/2021 322.91 0.00 1,582.290.00
912.151012317275RBJ0250,000.00 1.850MTN09/20/2021 385.42 0.00 1,297.570.00
975.351013559217GCD9250,000.00 2.650MTN04/08/2022 552.08 0.00 1,527.430.00
2,673.611012846849LSW2250,000.00 2.500MTN06/27/2022 520.83 3,125.00 69.440.00
2,998.611015690331HNV1250,000.00 3.400MTN07/24/2023 708.33 0.00 3,706.940.00
1,283.851015002665WCQ2250,000.00 3.625MTN10/10/2023 755.21 0.00 2,039.060.00
3,326.741015589236TFS9250,000.00 3.350MTN01/08/2024 697.91 0.00 4,024.650.00
906.251016046625HJX9500,000.00 3.625MTN05/13/2024 1,510.42 0.00 2,416.670.00
327.781016668389XBS3250,000.00 2.950MTN11/15/2024 614.58 0.00 942.360.00
21,357.993,500,000.00Subtotal 22,488.178,161.43 7,031.250.00
Federal Agency
522.28101263134GBHX3350,000.00 1.580FAC04/27/2020 460.83 0.00 983.110.00
677.78101523133EJT74500,000.00 3.050FAC11/15/2021 1,270.83 0.00 1,948.610.00
4,453.13101243130AAB49500,000.00 1.875FAC12/10/2021 781.25 4,687.50 546.880.00
1,555.56101363135G0T78500,000.00 2.000FAC10/05/2022 833.33 0.00 2,388.890.00
3,958.33101623133EKTV8500,000.00 1.900FAC07/01/2024 791.67 0.00 4,750.000.00
375.00101653133EK3B0200,000.00 1.500FAC10/16/2024 250.00 0.00 625.000.00
11,542.082,550,000.00Subtotal 11,242.494,387.91 4,687.500.00
Treasury Coupon Securities
Portfolio LYNW
ACData Updated: SET_INT: 01/09/2020 08:49
Run Date: 01/09/2020 - 08:49 AI (PRF_AI) 7.2.8
Report Ver. 7.3.6.1
* Beginning Accrued may not include investments that redeemed in the previous month that had outstanding accrued interest. Ending Accrued includes outstanding purchase interest.
29Lynwood Public Financing Authority - Page 22 of 26 Agenda Item # 2
Maturity
Date
Security
Type
Current
Rate
Par
Value
Sorted by Security Type - Maturity Date Page 2
* Beginning
Accrued Interest
* Ending
Accrued Interest
Adjusted Acc'd Int.
at Purchase
During Period
Accrued Interest
Lynwood - Interest Reports
CUSIP Investment #
Interest
Earned
Interest
Received
Treasury Coupon Securities
2,164.45101589128283L2250,000.00 1.875TRC12/15/2020 397.03 2,343.75 217.730.00
2,164.45250,000.00Subtotal 217.73397.03 2,343.750.00
CD-FDIC
2,091.351012702006L3N1248,000.00 1.900MC206/22/2020 400.20 2,362.45 129.100.00
1,388.801011640434AZ44248,000.00 1.400MC207/08/2020 294.88 0.00 1,683.680.00
1,355.501013005580AKA1248,000.00 1.900MC208/18/2020 400.20 0.00 1,755.700.00
1,256.981013149306SYR1248,000.00 1.850MC208/21/2020 389.67 0.00 1,646.650.00
940.701013306740KKU0248,000.00 1.950MC209/21/2020 410.73 0.00 1,351.430.00
1,814.4810138856285HL8248,000.00 2.450MC202/16/2021 516.04 0.00 2,330.520.00
1,632.391011587165HNN6248,000.00 1.550MC206/29/2021 326.47 1,927.27 31.590.00
370.971015927002YEM4248,000.00 2.600MC205/20/2022 547.64 529.97 388.640.00
2,921.641016133847E2J5248,000.00 2.500MC206/13/2022 526.58 3,108.49 339.730.00
1,890.91101291404203Z1248,000.00 2.300MC208/02/2022 484.45 0.00 2,375.360.00
1,596.7110132795450D36248,000.00 2.350MC208/23/2022 494.98 0.00 2,091.690.00
2,574.781013761747MF63248,000.00 2.650MC201/11/2023 558.18 0.00 3,132.960.00
295.901015359013J5Z8248,000.00 3.350MC202/21/2023 705.61 682.85 318.660.00
206.721014320033AZK5248,000.00 3.300MC206/29/2023 704.74 672.66 238.800.00
3,318.441014438148PR33248,000.00 3.300MC207/06/2023 695.08 0.00 4,013.520.00
739.9110147949763TF3248,000.00 3.300MC208/30/2023 695.08 1,367.74 67.250.00
54.361016429278TLY4248,000.00 2.000MC209/27/2023 421.26 407.67 67.950.00
1,956.821015417312Q3B3248,000.00 3.000MC202/27/2024 631.90 0.00 2,588.720.00
993.021016332100LCB9248,000.00 1.850MC209/13/2024 389.67 0.00 1,382.690.00
27,400.384,712,000.00Subtotal 25,934.649,593.36 11,059.100.00
0.0026,822,680.98Total 155,902.6251,701.39 25,356.54129,557.77
Portfolio LYNW
ACData Updated: SET_INT: 01/09/2020 08:49
Run Date: 01/09/2020 - 08:49 AI (PRF_AI) 7.2.8
Report Ver. 7.3.6.1
* Beginning Accrued may not include investments that redeemed in the previous month that had outstanding accrued interest. Ending Accrued includes outstanding purchase interest.
30Lynwood Public Financing Authority - Page 23 of 26 Agenda Item # 2
Lynwood - Interest Reports
Sorted By Investment Type
Sales/Calls/Maturities: December 1, 2019 - December 31, 2019
Realized Gains and Losses
Investment #
Maturity DateCurrent Rate
Par Value
Book Value
Maturity/Sale
Proceeds
Realized
Gain/Loss
Sale Date Total
Earnings Yield 365
Inv.
Type
Purchase
Date Term
Days Held
Net Earnings
Total Total
Issuer
0.000.00 0.00 0.00 0.00 0.000No Sales or Maturities
Portfolio LYNW
ACData Updated: SET_INT: 01/09/2020 08:49
Run Date: 01/09/2020 - 08:49 CG (PRF_CGR1) 7.1.1
Report Ver. 7.3.6.1
31Lynwood Public Financing Authority - Page 24 of 26 Agenda Item # 2
City of Lynwood
Cash Reconciliation Report
For the Period December 1, 2019 - December 31, 2019
Grouped by Fund
Par
Value Cash
Trans.
TypeInvestment # Fund Security ID
Trans.
Date Security Description Maturity
Date Interest RedemptionsPurchases
Lynwood
08/30/20231014712/02/2019 InterestLYN 949763TF3 248,000.00 WFB 0.2M 3.30% Mat. 08/30/2023 0.00 695.08 0.00 695.08
1001112/02/2019 DepositLYN 9000 663,500.32 GSGF 0.7M 2.25%-695.08 0.00 0.00 -695.08
1001112/03/2019 InterestLYN 9000 663,500.32 GSGF 0.7M 0.01%0.00 234.94 0.00 234.94
1001112/03/2019 InterestLYN 9000 663,500.32 GSGF 0.7M 0.01%-234.94 0.00 0.00 -234.94
12/10/20211012412/10/2019 InterestLYN 3130AAB49 500,000.00 FHLB 0.5M 1.88% Mat. 12/10/2021 0.00 4,687.50 0.00 4,687.50
05/20/20221015912/10/2019 InterestLYN 27002YEM4 248,000.00 EGBN 0.2M 2.60% Mat. 05/20/2022 0.00 529.97 0.00 529.97
1001112/10/2019 DepositLYN 9000 663,500.32 GSGF 0.7M 2.25%-5,217.47 0.00 0.00 -5,217.47
06/13/20221016112/12/2019 InterestLYN 33847E2J5 248,000.00 FBC 0.2M 2.50% Mat. 06/13/2022 0.00 3,108.49 0.00 3,108.49
1001112/12/2019 DepositLYN 9000 663,500.32 GSGF 0.7M 2.25%-3,108.49 0.00 0.00 -3,108.49
12/15/20201015812/16/2019 InterestLYN 9128283L2 250,000.00 USTR 0.3M 1.88% Mat. 12/15/2020 0.00 2,343.75 0.00 2,343.75
1001112/16/2019 DepositLYN 9000 663,500.32 GSGF 0.7M 2.25%-2,343.75 0.00 0.00 -2,343.75
02/21/20231015312/18/2019 InterestLYN 59013J5Z8 248,000.00 MERICK 0.2M 3.35% Mat.0.00 682.85 0.00 682.85
1001112/18/2019 DepositLYN 9000 663,500.32 GSGF 0.7M 2.25%-682.85 0.00 0.00 -682.85
06/22/20201012712/23/2019 InterestLYN 02006L3N1 248,000.00 ALLY 0.2M 1.90% Mat. 06/22/2020 0.00 2,362.45 0.00 2,362.45
06/23/20211014212/23/2019 InterestLYN 931142EJ8 250,000.00 WMT 0.3M 3.13% Mat. 06/23/2021 0.00 3,906.25 0.00 3,906.25
1001112/23/2019 DepositLYN 9000 663,500.32 GSGF 0.7M 2.25%-6,268.70 0.00 0.00 -6,268.70
06/27/20221012812/27/2019 InterestLYN 46849LSW2 250,000.00 JAC 0.3M 2.50% Mat. 06/27/2022 0.00 3,125.00 0.00 3,125.00
09/27/20231016412/27/2019 InterestLYN 29278TLY4 248,000.00 CMS 0.2M 2.00% Mat. 09/27/2023 0.00 407.67 0.00 407.67
1001112/29/2019 DepositLYN 9000 663,500.32 GSGF 0.7M 2.25%-3,532.67 0.00 0.00 -3,532.67
06/29/20211011512/30/2019 InterestLYN 87165HNN6 248,000.00 SYF 0.2M 1.55% Mat. 06/29/2021 0.00 1,927.27 0.00 1,927.27
06/29/20231014312/30/2019 InterestLYN 20033AZK5 248,000.00 ADS 0.2M 3.30% Mat. 06/29/2023 0.00 672.66 0.00 672.66
08/30/20231014712/30/2019 InterestLYN 949763TF3 248,000.00 WFB 0.2M 3.30% Mat. 08/30/2023 0.00 672.66 0.00 672.66
1001112/30/2019 DepositLYN 9000 663,500.32 GSGF 0.7M 2.25%-3,272.59 0.00 0.00 -3,272.59
Subtotal -25,356.54 25,356.54 0.00 0.00
Lynwood LAIF
1000012/05/2019 WithdrawalLYNL 9001 21,001,393.55 LAIF 21.0M 2.41%0.00 0.00 1,000,000.00 1,000,000.00
1000012/20/2019 WithdrawalLYNL 9001 21,001,393.55 LAIF 21.0M 2.41%0.00 0.00 1,000,000.00 1,000,000.00
Subtotal 0.00 0.00 2,000,000.00 2,000,000.00
Total -25,356.54 25,356.54 2,000,000.00 2,000,000.00
Portfolio LYNW
AP
Run Date: 01/09/2020 - 08:52 AC (PRF_AC) 7.2.0
Report Ver. 7.3.6.132Lynwood Public Financing Authority - Page 25 of 26 Agenda Item # 2
Economic and Market Update
*Estimates for the current quarter/month, some data are lagged Sources: FHN Main Street and Bloomberg
Case-Shiller Home Prices YOY*2.2%2.0%0.2%
Consumer Confidence 126.5 126.3 0.2
Gold (per ounce)$1,517.27 $1,472.49 $44.78
Dollar Index 96.39 99.38 (2.99)
U.S. Avg Regular Unleaded $2.59 $2.66 ($0.07)
Retail Sales YOY*5.6%4.0%1.6%
S&P 500 3,231 2,977 8.5%
Consumer Price Index YOY*1.8%1.7%0.1%
1-5 Yr A-AAA Corporate Spread 0.36%0.44%(0.08%)
Dow Jones 28,538 26,917 6.0%
30 Year Mortgage Rate 3.86%3.72%0.14%
1-5 Yr Agency Spread 0.04%0.05%(0.01%)
10 Year T-Note 1.92%1.67%0.25%
U.S. Fed Debt Avg Yield*2.39%2.44%(0.05%)
3 Year T-Note 1.61%1.56%0.05%
5 Year T-Note 1.69%1.55%0.15%
2 Year T-Note 1.57%1.62%(0.05%)
3 Month T-Bill 1.55%1.82%(0.27%)
Labor Force Participation 63.2%63.2%0.0%
Effective Fed Funds Rate 1.55%1.90%(0.35%)
U.S. Payrolls Monthly Change 145,000 193,000 (48,000)
Unemployment Rate 3.5%3.5%0.0%
12/31/19
Item 12/31/19 9/30/19 Change
34Lynwood Public Financing Authority - Page 26 of 26 Agenda Item # 2