HomeMy Public PortalAboutA 2018-08-21 LSAvchlist
08/14/2018 10:27:57AM
Bank code: sa_usb
Voucher Date Vendor
FY-2017-2018
Check List
Successor Agency of the Lynwood Redevelopment Agency
Invoice PO# -------
5439 8/21/2018 007223 COX, CASTLE & NICHOLSON LLP 470675
11-001116
1 Vouchers for bank code : sa_usb
1 Vouchers in this report
Page:
Description/Account
ENVIRONMENTAL LEGAL SERVICES-6/2018
1021.76.211.62001
Total:
Bank total:
Total vouchers:
Page:
1
Amount
"600.00
600.00
·6oo.oo
600.00
vchlist
08/14/2018 12:02:39PM
Bank code: sa_usb
Voucher Date Vendor
5440 8/21/2018 000173 U.S. BANK TRUST
5441 8/21/2018 000173 U.S. BANK TRUST
2 Vouchers for bank code : sa_usb
2 Vouchers in this report
FY-2018-2019
Check List
Successor Agency of the Lynwood Redevelopment Agency
Invoice
000173090118
000173082518
PO#
02-002174
02-002174
02-002177
02-002177
Page: 2
ALLOCATION BOND SERIES 2013A-9/2018
1021 .76.211.67601
1021.76.211.67605
Total:
Amount
540,000.00
183,8f 1.88
723,871.88
LRA-HOUSING PROJ 2011 SERIES B-9/2018
1021.76.211.67601
1021.76.211.67605
Total:
Bank total:
Total vouchers :
165,000.00
204,655.99
369,655.99
1,093,527.87
1,093527.87
Page: 2
City of Lynwood
Investment Report Summary Notes
For the Month of
July 2018
The Investment activity for July 2018 – 1 Purchase(s); 1 Maturity(ies).
Purchaser/Issuer Rating Par Value Term Stated Rate Structure
Goldman Sachs Bank N/A 248,000 5 yrs. 3.300 CD-FDIC
Redemption/Issuer
Maturity
Rating Par Value Interest
Earned
Stated Rate Days/ Maturity Structure
AXP N/A 245,000 2,040 1.650 1,097 CD-FDIC
The City’s Local Agency Investment Fund (LAIF) account was credited $42,327.94 for the quarterly interest earned on deposits
for June 31, 2018. The quarter ending performance for June 30, 2018 reflects a daily rate of 1.92%. The quarter end principal
balance as of July 31, 2018 was $12,209,194.98. The City is within the desired average range of $9-$15 million in liquid assets.
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 complies 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 ranked as the
top priority.
Portfolio Performance:
Portfolio Interest Earning Summary July, 2018 Fiscal YTD
CD/Coupon/Discount Investments:
Interest Collected 9,800.37 9,800.37
Plus Accrued Interest @ End of Period 49,547.00 49,547.00
Less Accrued Interest @ Beginning of Period ( 43,191.48) ( 43,191.48)
Less Accrued Interest @ Purchase During Period 0.00 0.00
Interest Earned during this Period 16,155.89 16,155.89
Adjusted by Premiums and Discounts 1,875.11 1,875.11
Adjusted by Capital Gains or Losses 0.00 0.00
18,031.00 18,031.00
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
Investment Report July 2018
Page Two
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 54,156.37 54,156.37
Plus Accrued Interest at End of Period 48,213.92 48,213.92
Less Interest at Beginning of Period ( 79,855.38) ( 79,855.38)
Interest Earned this Period 22,514.91 22,514.91
Total Interest Earned 38,670.80 38,670.80
Total Adjustments from Premium and Discounts 1,875.11 1,875.11
Total Capital Gains or Loss 0.00 0.00
Total Earnings this Period 40,545.91 40,545.91
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.
Month
End &
Year
# of
Securities
Interest
Average
Balance
YTM
360%
YTM
365
Effective
Rate of
Return
Days to
Maturity
Jul-18 39 40,545.91 22,950,574.99 1.962 1.989 2.08% 348
Investment Activity
Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18
38 39 39 40 38 39 39 39 39 39 40 39
Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18
4 1 1 2 0 1 1 1 1 1 2 1
3 1 1 2 0 1 1 1 1 1 2 1
3 7 2 2 4 0 2 2 2 2 2 4
City of Lynwood7/31/2018
Purchases
Total Transactions
Positions
Redemptions
32
34
36
38
40
42
Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18PositionsNumber of Positions at Month End
0
1
2
3
4
5
6
Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18Number of TransactionsPurchases and Redemptions* (Excluding LAIF & MMF)Purchases
Redemptions
*Redemptions include maturities, calls, and sells (excluding paydowns)
15
8-7-18
16
Page 1
July 31, 2018
Interest Earnings Summary
Month EndingJuly 31 Fiscal Year To Date
Portfolio Management
Lynwood - Portfolio Management
CD/Coupon/Discount Investments:
9,800.37Interest Collected
Plus Accrued Interest at End of Period
Less Accrued Interest at Beginning of Period
49,547.00
( 43,191.48)
9,800.37
49,547.00
( 43,191.48)
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
16,155.89
1,875.11
0.00
16,155.89
1,875.11
0.00
18,031.00 18,031.00
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:
54,156.37Interest Collected
Plus Accrued Interest at End of Period
Less Accrued Interest at Beginning of Period
48,213.92
( 79,855.38)
54,156.37
48,213.92
( 79,855.38)
Interest Earned during Period 22,514.91 22,514.91
Total Interest Earned during Period
Total Adjustments from Premiums and Discounts
Total Capital Gains or Losses
Total Earnings during Period
38,670.80
1,875.11
0.00
38,670.80
1,875.11
0.00
40,545.91 40,545.91
Portfolio LYNW
APData Updated: SET_PMM: 08/06/2018 14:39
Run Date: 08/06/2018 - 14:40 PM (PRF_PM6) 7.3.0
Report Ver. 7.3.6.1
26
City of Lynwood
Cash Reconciliation Report
For the Period July 1, 2018 - July 31, 2018
Par Value Cash
Trans.TypeInvestment # Fund Security ID
Trans.Date Security Description MaturityDate Interest RedemptionsPurchases
07/02/20181009007/02/2018 InterestLYN 02587DZM3 248,000.00 AXP 0.2M 1.65% Mat. 07/02/2018 0.00 11.12 0.00 11.12
07/02/20181009007/02/2018 InterestLYN 02587DZM3 248,000.00 AXP 0.2M 1.65% Mat. 07/02/2018 0.00 2,028.88 0.00 2,028.88
07/02/20181009007/02/2018 MaturityLYN 02587DZM3 248,000.00 AXP 0.2M 1.65% Mat. 07/02/2018 0.00 0.00 248,000.00 248,000.00
1001107/02/2018 DepositLYN 9000 38,355.32 GSGF 0.0M 1.81%-250,040.40 0.00 0.00 -250,040.40
1001107/03/2018 InterestLYN 9000 38,355.32 GSGF 0.0M 0.01%0.00 230.93 0.00 230.93
1001107/03/2018 InterestLYN 9000 38,355.32 GSGF 0.0M 0.01%-230.93 0.00 0.00 -230.93
07/08/20201011607/09/2018 InterestLYN 40434AZ44 248,000.00 HSBC 0.2M 1.40% Mat. 07/08/2020 0.00 1,721.73 0.00 1,721.73
07/06/20231014407/09/2018 PurchaseLYN 38148PR33 248,000.00 GOLD 0.2M 3.30% Mat. 07/06/2023 -247,432.08 -67.27 0.00 -247,499.35
1001107/09/2018 WithdrawalLYN 9000 38,355.32 GSGF 0.0M 1.81%0.00 0.00 245,777.62 245,777.62
01/11/20231013707/11/2018 InterestLYN 61747MF63 248,000.00 MSB 0.2M 2.65% Mat. 01/11/2023 0.00 3,258.99 0.00 3,258.99
1001107/11/2018 DepositLYN 9000 38,355.32 GSGF 0.0M 1.81%-3,258.99 0.00 0.00 -3,258.99
1000007/13/2018 InterestLYNL 9001 12,155,269.54 LAIF 12.2M 0.57%0.00 53,925.44 0.00 53,925.44
1000007/13/2018 InterestLYNL 9001 12,155,269.54 LAIF 12.2M 0.57%-53,925.44 0.00 0.00 -53,925.44
01/15/20201012507/16/2018 InterestLYN 24422ERY7 250,000.00 DE 0.3M 1.70% Mat. 01/15/2020 0.00 2,125.00 0.00 2,125.00
1001107/16/2018 DepositLYN 9000 38,355.32 GSGF 0.0M 1.81%-2,125.00 0.00 0.00 -2,125.00
06/29/20231014307/30/2018 InterestLYN 20033AZK5 248,000.00 ADS 0.2M 3.30% Mat. 06/29/2023 0.00 672.66 0.00 672.66
1001107/30/2018 DepositLYN 9000 38,355.32 GSGF 0.0M 1.81%-672.66 0.00 0.00 -672.66
Subtotal -557,685.50 63,907.48 493,777.62 -0.40
Total -557,685.50 63,907.48 493,777.62 -0.40
Portfolio LYNW
AP
Run Date: 08/06/2018 - 14:56 AC (PRF_AC) 7.2.0
Report Ver. 7.3.6.1 32