HomeMy WebLinkAboutItem No. 06 - Monthly Investment Portfolio Report for April 2020
Consent Calendar
City of San Bernardino
Request for Council Action
Date: June 3, 2020
To: Honorable Mayor and City Council Members
From: Teri Ledoux, City Manager
By:Paul Espinoza, Finance Director
Subject: Monthly Investment Portfolio Report for April 2020
Recommendation
It is recommended that the Mayor and City Council of the City of San Bernardino,
California, accept and file the Monthly Investment Portfolio Report for April 2020.
Background
icy requires that a monthly Investment Portfolio
Report be prepared and submitted to the City Council. The Director of Finance will
portfolio is in compliance with th
Discussion
investment portfolio for the month ended April 30, 2020.
l compliance with the
California Government Code Section 53601, and there is sufficient cash flow from a
combination of liquid and maturing securities, bank deposits, and income to meet the
2020-2025 Key Strategic Targets and Goals
The acceptance and filing of the attached Investment Portfolio Report aligns with Key
Target No. 1: Financial Stability by Implementing and maintaining and updating a fiscal
accountability plan.
Fiscal Impact
None
Conclusion
It is recommended that the Mayor and City Council of the City of San Bernardino,
California, accept and file the Monthly Investment Portfolio Report for April 2020.
Attachments
Attachment 1 Investment Portfolio Management Summary Report
Page 1
6732
Ward: All
Synopsis of Previous Council Actions: None
Page 2
AP
YTM
1.6481.7801.9211.7691.8452.2022.4720.110
1.7441.744
365 Equiv.
290 N D. ST
Report Ver. 7.3.3b
Portfolio CITY
(909)384-5242
PM (PRF_PM1) 7.3.0
YTM
1.6251.7561.8941.7451.8202.1722.4380.108
1.7201.720
360 Equiv.
FINANCE DEPARTMENT
CITY OF SAN BERNARDINO
111
SAN BERNARDINO, CA 92401
666355783
431431
1,2051,368
Days to
Maturity
111
799799
Term
1,3391,4341,4451,2751,582
0.009.511.724.275.302.86
% of
40.8935.46
100.00%
Portfolio
Book
Value
1,769.10
21,884.7221,884.72
2,004,941.764,993,722.916,188,000.003,342,779.06
47,780,949.2911,108,058.0241,428,810.00
116,849,030.14116,870,914.86
1.87%
1,657,312.01
106,045,751.45
April 30, 2020
Value
Market
1,769.10
21,884.72
21,884.72
Fiscal Year To Date
Portfolio Summary
2,017,800.005,098,050.006,486,474.263,342,779.06
47,780,949.2911,132,812.9141,971,490.25
Portfolio Management
117,832,124.87117,854,009.59
CITY OF SAN BERNARDINO
Par
1.77%
Value
1,769.10
2,000,000.005,000,000.006,188,000.003,342,779.06
171,801.36
47,780,949.2911,062,890.0041,425,000.00
Month Ending
116,801,387.45116,801,387.45
118,108,159.76
April 30
Reporting period 04/01/2020-04/30/2020 Run Date: 05/07/2020 - 10:05
Investments State Local Agency Investment FundManaged Pool AccountsCorporate NotesFederal Agency Issues - CouponSupranationalsTreasury Securities - CouponCertificates of DepositMoney
Market Funds InvestmentsCash and Accrued InterestAccrued Interest at PurchaseSubtotalTotal Cash and InvestmentsTotal EarningsCurrent YearAverage Daily BalanceEffective Rate of Return"I
certify that this report accurately reflects all pooled investments and is in conformity with the Investment Policy Statement approved by the Mayor and City Council on November 6,
2019.*Book Value is amortized Cost Basis**Market Values provided by BNY Western Trust.__________________________________________________ ____________________PAUL ESPINOZA, DIRECTOR
OF FINANCE
AP
Date
Page 1
Maturity
05/10/202309/11/202209/11/202410/30/202202/28/202508/16/202303/01/202112/23/202401/25/202310/22/202410/26/202012/13/202104/09/202102/10/202306/03/202412/16/202109/16/202109/11/202012/24/202011/29/202
111/29/202104/07/202106/11/202109/11/202001/29/2024
1111
Report Ver. 7.3.3b
Portfolio CITY
863912304999178591343594503133237577577341406133
1,1041,5941,7641,2021,6971,6351,2051,0151,4941,368
PM (PRF_PM2) 7.3.0
Days to
Maturity
360
YTM
1.6251.6251.7561.7561.9081.7321.7782.1522.2011.9041.1802.2711.7312.0961.8941.7261.5671.6181.6121.6470.8190.7731.1641.7811.9131.9261.6721.6872.5412.836
A
AaAa
AaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaa
Moody's
1.6481.7801.9501.7001.8002.1002.0502.2001.6502.3002.6502.1251.7502.1101.6401.6001.6700.8300.7501.3751.5501.8751.8751.7501.8752.8752.875
Rate
Stated
1,769.101,769.10
998,704.84998,890.00999,074.14999,541.67998,409.06998,954.21998,836.91
Book Value
1,000,453.751,000,000.001,000,000.002,017,002.171,003,745.811,000,000.001,089,261.451,000,000.001,000,000.002,016,514.871,000,000.001,000,000.001,000,000.001,000,685.101,000,491.891,001,763.471,001,0
38.401,000,000.00
47,780,949.2947,780,949.2911,108,058.02
1,769.101,769.10
994,150.00986,040.00992,530.00982,160.00945,940.00
1,025,930.001,035,719.072,050,040.001,009,690.001,110,613.841,006,610.002,058,420.001,002,170.001,006,790.001,000,530.001,000,030.001,000,030.001,001,240.001,007,430.001,025,640.001,025,640.001,013,6
50.001,014,520.001,009,590.001,015,750.00
Market Value
47,780,949.2947,780,949.2911,132,812.91
1,769.101,769.10
Par Value
998,890.00
1,000,000.001,000,000.001,000,000.001,000,000.002,000,000.001,000,000.001,000,000.001,064,000.001,000,000.001,000,000.002,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,0
00.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.00
47,780,949.2947,780,949.2911,062,890.00
April 30, 2020
Date
Portfolio Management
Purchase
Portfolio Details - Investments
CITY OF SAN BERNARDINO
01/10/202012/10/201901/24/202010/30/201902/28/202010/16/201903/03/202012/23/201901/27/202010/22/201910/26/201712/31/201901/09/202002/11/202003/03/202003/16/202003/16/202011/02/201601/09/201701/19/201
702/14/201706/14/201706/22/201706/11/201801/29/2019
Balance
Average
1,756.96
41,902,327.1111,108,803.32
Issuer
LOCAL AGENCY INVESTMENT FUNDCALTRUST GOVT INVESTMENT FUNDAMERICAN HONDA FINANCE CORPAPPLE INCAPPLE INCBANK OF AMERICA CORPORATIONBANK OF AMERICA CORPORATIONBANK OF NEW YORK MELLON CORPJOHNSON
& JOHNSONJ.P. MORGAN CHASE & COCHARLES SCHWAB CORPTOYOTA MOTOR CREDIT CORPFEDERAL FARM CREDIT BANKFEDERAL FARM CREDIT BANKFEDERAL FARM CREDIT BANKFEDERAL FARM CREDIT BANKFEDERAL FARM
CREDIT BANKFEDERAL FARM CREDIT BANKFEDERAL FARM CREDIT BANKFEDERAL HOME LOAN BANKFEDERAL HOME LOAN BANKFEDERAL HOME LOAN BANKFEDERAL HOME LOAN BANKFEDERAL HOME LOAN BANKFEDERAL HOME
LOAN BANKFEDERAL HOME LOAN BANKFEDERAL HOME LOAN BANK
Subtotal and AverageSubtotal and AverageSubtotal and Average
Investment #1000120008305593055430561305493056830547C30570305513056330548305363055530557305643056730571305723051630522305233052830534305353053930540C
CUSIP State Local Agency Investment Fund SYS Managed Pool Accounts 20008 Corporate Notes 02665WDH1037833DL1037833DM906048WD7206048WH9406406FAD5478160BS248128GN97808513AT289236TGN9 Federal
Agency Issues - Coupon 3133EHJ953133EH2T93133ELGK43133ELMD33133ELQU13133ELTM63133ELTL8313380WG8313381P253130AABG23130AABG23130AB5A0313379RB7313370US53130AFRQ2
Run Date: 05/07/2020 - 10:05
AP
Date
Page 2
Maturity
12/19/202212/23/202202/12/202503/25/202408/12/202105/01/202001/26/202202/28/202209/16/202107/26/202104/26/202203/20/202405/22/202307/13/202209/29/202003/29/202110/07/202110/07/202110/07/202110/07/202
101/05/202201/05/202208/21/202001/05/202203/29/202201/27/202301/28/202506/30/202008/31/202107/31/2021
0
60
Portfolio CITY
962966468635668503451725803151332524524524524614614112614697666487456
1,7481,4241,4191,1161,0011,7331,368
PM (PRF_PM2) 7.3.0
Days to
Maturity
360
YTM
1.7751.7951.7261.5291.3411.4501.9782.0961.9731.9332.0422.8412.4081.6271.2721.3321.4111.4011.3411.7161.9461.9941.7752.0142.1401.7451.7261.9131.8201.5011.9192.348
AaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaa
Moody's
1.8001.8201.7501.5501.1251.3752.0002.1252.0001.8752.0002.8802.5001.6501.2701.3501.3751.3751.3751.3752.0002.0001.8002.0002.1701.7502.0501.6252.0002.250
Rate
Stated
997,094.22424,963.03998,991.71998,667.70999,922.92999,175.31999,375.34995,003.69999,659.33999,329.50998,446.36
Book Value
1,000,000.001,000,000.002,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,737.071,000,000.001,000,000.001,000,153.391,000,427.071,000,000.001,000,000.001,000,000.001,004,9
41.762,004,941.761,000,164.431,000,689.82
41,428,810.00
436,530.25
1,001,570.001,001,940.002,001,080.001,005,540.001,011,200.001,000,000.001,033,350.001,023,930.001,021,190.001,033,980.001,003,300.001,001,100.001,002,520.001,002,140.001,009,210.001,016,440.001,016,4
40.001,016,440.001,016,440.001,029,350.001,029,350.001,004,760.001,029,350.001,036,300.001,008,500.001,009,300.002,017,800.001,002,510.001,024,530.001,025,780.00
Market Value
41,971,490.25
Par Value
425,000.00
1,000,000.001,000,000.002,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,0
00.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.002,000,000.001,000,000.001,000,000.001,000,000.00
41,425,000.00
April 30, 2020
Date
Portfolio Management
Purchase
Portfolio Details - Investments
CITY OF SAN BERNARDINO
12/19/201912/31/201902/12/202003/25/202011/07/201611/22/201601/30/201702/28/201703/16/201703/06/201711/06/201703/20/201905/28/201901/13/202009/29/201609/29/201610/13/201610/31/201611/03/201611/18/201
601/23/201702/02/201702/21/201703/02/201703/29/201701/27/202003/03/202011/28/201602/21/201702/12/2018
Balance
Average
2,004,983.11
46,050,513.76
Issuer
FEDERAL HOME LOAN BANKFEDERAL HOME LOAN BANKFEDERAL HOME LOAN BANKFEDERAL HOME LOAN BANKFEDERAL HOME LOAN MORTGAGE CRPFEDERAL HOME LOAN MORTGAGE CRPFEDERAL HOME LOAN MORTGAGE CRPFEDERAL
HOME LOAN MORTGAGE CRPFEDERAL HOME LOAN MORTGAGE CRPFEDERAL HOME LOAN MORTGAGE CRPFEDERAL HOME LOAN MORTGAGE CRPFEDERAL HOME LOAN MORTGAGE CRPFEDERAL HOME LOAN MORTGAGE CRPFEDERAL HOME
LOAN MORTGAGE CRPFEDERAL NATIONAL MORTGAGE ASSOFEDERAL NATIONAL MORTGAGE ASSOFEDERAL NATIONAL MORTGAGE ASSOFEDERAL NATIONAL MORTGAGE ASSOFEDERAL NATIONAL MORTGAGE ASSOFEDERAL NATIONAL
MORTGAGE ASSOFEDERAL NATIONAL MORTGAGE ASSOFEDERAL NATIONAL MORTGAGE ASSOFEDERAL NATIONAL MORTGAGE ASSOFEDERAL NATIONAL MORTGAGE ASSOFEDERAL NATIONAL MORTGAGE ASSOINTL BK RECON & DEVELOPMENTINTL
BK RECON & DEVELOPMENTU.S. TREASURYU.S. TREASURYU.S. TREASURY
Subtotal and AverageSubtotal and Average
Investment #30552305563056530566305183052030525C30529C30530C3053130537C30541C30543C3055830510C30512C30513305153051730519305243052630527C3053230533C30562305694000040001C40002
CUSIP Federal Agency Issues - Coupon 3130AHPB33130AHRV73130AJ5F23130AJAX73137EAEC93137EADR73134GAU443134GA5T73134GA5C43134G9M203134GBP553134GS5Q43134GTNN93134GUW553136G37C33136G4BD43135GOQ893135G0Q89
3135GOQ893135G0Q893135G0S383135G0S383136G4LA93135G0S383136G4MQ3 Supranationals 45905U5U4459058HV8 Treasury Securities - Coupon 912828XH8912828D72912828WY2
Run Date: 05/07/2020 - 10:05
AP
Date
Page 3
Maturity
07/31/202103/15/202106/30/202112/01/202102/24/202205/30/202405/24/202104/15/202405/24/202206/03/202001/17/202311/18/202106/04/202105/10/202101/31/202406/13/202402/13/202306/28/202201/13/202210/21/202
102/22/202406/14/202102/23/202201/18/202406/28/202006/17/2021
11
3358
Portfolio CITY
456318355425579664388753991566399374788622538409663412783
1,4901,4451,3701,5041,0181,3921,357
PM (PRF_PM2) 7.3.0
Days to
Maturity
360
YTM
2.5102.5842.1721.7262.0222.1702.6142.8602.7122.4161.8253.1071.7752.9102.8603.0082.5642.7122.7122.0221.6772.9592.9592.0223.1561.3011.7262.4380.1080.108
AaaAaa
Moody's
2.2502.3751.7502.0502.2002.6502.9002.7502.4501.8503.1501.8002.9502.9003.0502.6002.7502.7502.0501.7003.0003.0002.0503.2001.3011.7500.110
Rate
Stated
996,476.18997,946.12248,000.00247,000.00247,000.00247,000.00246,000.00249,000.00249,000.00248,000.00245,000.00248,000.00249,000.00246,000.00246,000.00247,000.00245,000.00245,000.00249,000.00247,000.0
0245,000.00249,000.00247,000.00500,000.00250,000.00249,000.00
Book Value
4,993,722.916,188,000.003,342,779.063,342,779.06
250,847.16252,954.01254,923.07270,273.95251,371.26272,842.55260,085.60248,383.68264,005.43252,696.75254,866.96251,179.43271,133.55269,978.71261,773.34258,011.68255,648.85250,905.93269,989.90255,154.0
1254,231.52553,570.85250,000.00251,646.07
1,025,780.001,019,450.005,098,050.006,486,474.263,342,779.063,342,779.06
Market Value
Par Value
248,000.00247,000.00247,000.00247,000.00246,000.00249,000.00249,000.00248,000.00245,000.00248,000.00249,000.00246,000.00246,000.00247,000.00245,000.00245,000.00249,000.00247,000.00245,000.00249,000.0
0247,000.00500,000.00250,000.00249,000.00
1,000,000.001,000,000.005,000,000.006,188,000.003,342,779.063,342,779.06
April 30, 2020
Date
Portfolio Management
Purchase
Portfolio Details - Investments
CITY OF SAN BERNARDINO
06/04/201806/25/201806/30/201612/01/201602/24/201705/30/201905/23/201804/29/201905/24/201906/03/201501/16/201911/18/201606/04/201805/10/201801/31/201906/13/201902/13/201902/28/201901/13/201710/21/201
602/22/201906/13/201802/23/201701/18/201906/28/201806/17/2016
Balance
Average
4,993,528.076,188,000.005,858,247.43
Issuer
U.S. TREASURYU.S. TREASURY1ST TECHNOLOGY FEDERAL CREDITAMERICAN EXPRESS CENTURION BKBMW BANKCAPITAL ONE NATIONAL ASSOCCITI BANK SALT LAKE CITY UTAHCOMENITY CAPITAL BANKEAGLE BANKCAPITAL
ONE BANK USA NATLGOLDMAN SACHS GROUP INC.J.P. MORGAN CHASE & COMEDALLION BANKMORGAN STANLEY BANKMORGAN STANLEY PRIVATE BANKMORGAN STANLEY PRIVATE BANKNORTHWESTERN BANKOXFORD BANK &
TRUSTSTEARNS BANKSYNCHRONY BANKTIAA FSBUBS FINANCE COMMERCIAL PAPERWASHINGTON FIRST BK RESTONWELLS FARGO BK NAWELLS FARGO BANKWELLS FARGO BANKWELLS FARGO GOVT MONEY MARKET
Subtotal and AverageSubtotal and AverageSubtotal and Average
Investment #400034000480034800388004180054800438005280053800268004680037800448004280048800558004980051800398003680050800458004080047200338003320002
CUSIP Treasury Securities - Coupon 912828WY29128284B3 Certificates of Deposit 33715LAD202587DM7005580AGK414042RLW917312QM2220033AU6127002YEP7140420RT938148P4B048126XLB958404DCA761747MX6361760AVF36176
0AG52668015AL469140WAS4857894SK687165FNC487270LBU690348JCU2940727AH3949763WU616115078479497485W3 Money Market Funds SYS20002
Run Date: 05/07/2020 - 10:05
AP
Page 4
431
Portfolio CITY
PM (PRF_PM2) 7.3.0
Days to
Maturity
360
YTM
1.720
Moody's
Rate
Stated
Book Value
116,849,030.14
Market Value
117,832,124.87
Par Value
116,801,387.45
April 30, 2020
Date
Portfolio Management
Purchase
Portfolio Details - Investments
CITY OF SAN BERNARDINO
Balance
Average
118,108,159.76
Issuer
Total and Average
Investment #
CUSIP
Run Date: 05/07/2020 - 10:05
AP
Page 5
0
431
Portfolio CITY
PM (PRF_PM2) 7.3.0
Days to
Maturity
360
YTM
1.720
Moody's
Rate
Stated
21,884.7221,884.72
Book Value
116,870,914.86
21,884.7221,884.72
Market Value
117,854,009.59
Par Value
116,801,387.45
April 30, 2020
Portfolio Details - Cash
Date
Portfolio Management
Purchase
Accrued Interest at PurchaseSubtotal
CITY OF SAN BERNARDINO
0.00
Balance
Average
118,108,159.76
Issuer
Average Balance
Total Cash and Investments
Investment #
CUSIP
Run Date: 05/07/2020 - 10:05
AP
Page 1
Report Ver. 7.3.3b
Portfolio CITY
PM (PRF_PM3) 7.3.0
Balance
1,769.10
2,004,941.764,993,722.916,188,000.003,342,779.06
47,780,949.2911,108,058.0241,428,810.00
116,849,030.14
0.000.000.000.00
949,951.10999,850.00
1,000,000.001,000,000.001,000,000.001,000,000.001,000,000.002,000,000.008,949,801.10
Redemptions
13,488,628.7713,488,628.7722,438,429.87
or Withdrawals
0.000.000.000.000.000.000.000.000.00
12.5612.56
Purchases
or Deposits
9,704,190.399,704,190.39
12,200,785.5312,200,785.5321,904,988.48
Date
04/08/202004/15/202004/17/202004/22/202004/16/202004/28/202004/24/202004/09/2020
Activity By Type
Transaction
Portfolio Management
1.6481.7801.5801.8201.9801.7401.8401.8752.6002.1000.110
Rate
Stated
CITY OF SAN BERNARDINO
April 1, 2020 through April 30, 2020
Total
SubtotalSubtotalSubtotalSubtotalSubtotalSubtotalSubtotalSubtotal
IssuerLOCAL AGENCY INVESTMENT FUNDCALTRUST GOVT INVESTMENT FUNDFEDERAL FARM CREDIT BANKFEDERAL FARM CREDIT BANKFEDERAL FARM CREDIT BANKFEDERAL FARM CREDIT BANKFEDERAL FARM CREDIT BANKFEDERAL
HOME LOAN BANKFEDERAL HOME LOAN MORTGAGE CRPFEDERAL HOME LOAN MORTGAGE CRPWELLS FARGO GOVT MONEY MARKET
Investment #100012000830514C30545C30546C30553305603055030542C30544C20002
CUSIP State Local Agency Investment Fund (Monthly Summary)SYS Managed Pool Accounts (Monthly Summary)20008 Corporate NotesFederal Agency Issues - Coupon 3133EGZP33133EK2F23133EKX763133ELDV33133ELGS
73130AHGQ03134GTJW43134GUGG9 SupranationalsTreasury Securities - CouponCertificates of DepositMoney Market Funds (Monthly Summary)SYS20002
Run Date: 05/07/2020 - 10:05
AP
356302302348340344474430452456467527431402
Page 1
Average
Report Ver. 7.3.3b
Portfolio CITY
PM (PRF_PM4) 7.3.0
Days to Maturity
929745669792782795960869846826831898799826
Term
Average
15923402200283
Number
Redeemed
of Investments
23100070673603
Number
Purchased
of Investments
Pool
Rate
2.4502.4502.4492.3792.3412.2802.1902.1032.0431.9671.9121.7301.6482.149
Managed
365
1.826%
1.6481.3721.3192.1052.0121.9981.9851.9721.9691.9291.8961.7841.744
Equivalent
Yield to Maturity
360
Activity Summary
1.6261.3531.3012.0761.9841.9711.9571.9451.9421.9031.8701.7601.7201.801%
Portfolio Management
Equivalent
April 2019 through April 2020
CITY OF SAN BERNARDINO
Total
Invested
94,603,560.0691,198,209.0496,737,190.19
108,862,266.26128,886,141.21124,896,967.11102,169,953.51100,006,961.73104,414,539.79116,512,135.33123,735,583.62117,383,961.74116,849,030.14109,712,038.44
8785777673697674788588928480
Securities
Number of
Average
Year
2019201920192019201920192019201920192020202020202020
MonthEnd AprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberJanuaryFebruaryMarchApril
Run Date: 05/07/2020 - 10:05
AP
0.1%3.8%0.4%4.6%5.9%1.2%0.1%
20.1%24.0%39.8%
Page 1
Average
by Period
Report Ver. 7.3.3b
Portfolio CITY
PM (PRF_PM5) 7.3.0
9.51.74.35.32.9
40.935.5
April2020
9.51.74.35.33.9
2020 32.442.9
March
1.58.20.84.05.05.8
2020 35.239.4
February
4.27.80.94.35.33.4
34.839.3
2020
January
6.75.84.85.9
35.841.0
2019
December
4.25.26.4
2019 32.510.741.1
November
4.45.56.8
2019 24.613.045.8
October
5.36.5
23.725.738.9
2019
September
0.45.06.70.3
49.937.8
2019
August
0.44.97.00.2
Portfolio Management
July
2019 49.537.9
April 2019 through April 2020
CITY OF SAN BERNARDINO
Distribution of Investments By Type
0.30.24.05.40.2
2019 57.332.6
June
0.30.23.95.20.2
May
52.437.8
2019
0.40.24.65.90.2
41.347.4
April2019
Security TypeState Local Agency Investment FundManaged Pool AccountsNegotiable CD's - BankCorporate NotesFederal Agency Issues - CouponSupranationalsTreasury Securities - CouponCertificates
of DepositTreasury Discounts -AmortizingMoney Market FundsCertificate Deposit-2Negotiable CDs -3
Run Date: 05/07/2020 - 10:05
AP
Page 1
Report Ver. 7.3.3b
Portfolio CITY
PM (PRF_PM6) 7.3.0
0.000.000.000.000.000.00
6,411.226,411.22
-2,775.31-2,775.31
957,568.14254,282.80960,461.37964,097.28767,998.61505,708.23693,214.73
1,653,676.101,657,312.01
( 0.00)( 0.00)( 0.00)
( 251,389.57)( 580,492.11)
Fiscal Year To Date
0.000.000.000.000.000.00
48.9048.90
-1,489.76-1,489.76
60,856.75
167,666.26246,212.56112,385.47110,944.61205,032.17505,708.23173,242.22171,801.36
Month Ending
( 0.00)( 0.00)( 0.00)
( 301,493.35)( 649,883.65)
April 30
April 30, 2020
Portfolio Management
Interest Earnings Summary
CITY OF SAN BERNARDINO
Earnings during PeriodsEarnings during Periods
Interest Earned during PeriodInterest Earned during PeriodInterest Earned during Period
Total Earnings during Period
CD/Coupon/Discount Investments:Interest CollectedPlus Accrued Interest at End of PeriodLess Accrued Interest at Beginning of PeriodLess Accrued Interest at Purchase During PeriodAdjusted
by Premiums and DiscountsAdjusted by Capital Gains or LossesPass Through Securities:Interest CollectedPlus Accrued Interest at End of PeriodLess Accrued Interest at Beginning of PeriodLess
Accrued Interest at Purchase During PeriodAdjusted by Premiums and DiscountsAdjusted by Capital Gains or LossesCash/Checking Accounts:Interest CollectedPlus Accrued Interest at End
of PeriodLess Accrued Interest at Beginning of PeriodTotal Interest Earned during PeriodTotal Adjustments from Premiums and DiscountsTotal Capital Gains or Losses
Run Date: 05/07/2020 - 10:05