FOR PROFESSIONAL CLIENTS ONLY
NOT TO BE REPRODUCED WITHOUT PRIOR WRITTEN APPROVAL
PLEASE REFER TO ALL RISK DISCLOSURES AT THE BACK OF THIS DOCUMENT
CITY OF SAN PABLO
December 2021
Contents
Fixed income market review 3
Activity and performance summary 4
Recap of securities held 6
Maturity distribution of securities held 7
Securities held 8
GASB 40 - Deposit and investment risk disclosure 12
Detail of return and interest received 16
Transaction report 19
Additional information 20
FIXED INCOME MARKET REVIEW
As of December 31, 2021
CITY OF SAN PABLO
Chart 1: The Fed’s most significant recent upward policy rate forecast revision Source: Bloomberg, December 31, 2021
Chart 2: Unemployment rate continues to descend
Source: Bloomberg, December 31, 2021
Economic Indicators and Monetary Policy
The Federal Reserve (Fed) doubled its pace of ‘tapering’ to a rate of $30bn per month.
This puts the Fed on course to cease expanding its balance she et in March 2022. It revised its dot plot to reflects a median expectation of thre e hikes in 2022 (Chart 1).
November’s CPI report came in at 6.8% for headline inflation (the highest since 1982, but modestly lower than market fears of 7%+) with core inflat ion reaching 4.9% (the highest since 1991). Energy prices were a key factor, rising 33% pa. Regarding ‘sticky’ inflation categories, rents ran at ~0.4% in November, pushi ng owners’ equivalent rent to 3.5% pa and medical prices showed a small but notable 2.1% p a rise.
The US economy added 210,000 jobs in November, less than the 5 50,000 expected.
However, the unemployment rate fell unexpectedly to 4.2% fr om 4.6%. The participation rate increased to 61.8% from 61.6%. Wage data was close to expectations with average hourly earnings up 4.8% pa. Leisu re and hospitality wages continue to advance faster than other sectors – up 12.35% pa.
The JOLTS report was further indicative of a tight labor mark et. Job openings rose
4.1% to 11m, close to July’s record high. The number of layoff s declined 2.5% to
1.361m, close to a record low.
On the political front, President Joe Biden failed to secure Democratic Senator Joe Manchin’s approval for the ‘American Families Plan’, the la st component of the $1.75trn ‘Build Back Better’ fiscal program, forcing Congr ess to return to the drawing board.
In response to the global spread of the more transmissible bu t potentially less severe Omicron Covid-19 variant, a number of countries enacted pre cautionary restrictions around the holiday period, although such measures were rela tively modest in the US.
Risk assets enjoyed a strong end to the year.
Interest Rate Summary
Yields rose modestly across the curve. At the end of December , the 3-month US Treasury bill yielded 0.06%, the 6-month US Treasury bill yi elded 0.19%, the 2-year US Treasury note yielded 0.74%, the 5-year US Treasury note yie lded 1.27% and the 10- year US Treasury note yielded 1.51%.
3 ACTIVITY AND PERFORMANCE SUMMARY
For the period December 1, 2021 - December 31, 2021
CITY OF SAN PABLO
Amortized Cost Basis Activity Summary
28,935,367.51 Opening balance
76,159.67 Income received
76,159.67 Total receipts
0.00 Total disbursements
0.00 Interportfolio transfers
0.00 Total Interportfolio transfers
0.00 Realized gain (loss)
0.00 Change in accruals from security movement
(18,069.28) Total amortization expense
322.65 Total OID/MKT accretion income
0.00 Return of capital
Closing balance 28,993,780.55
Ending fair value 29,097,362.62
103,582.07 Unrealized gain (loss)
Comparative Rates of Return (%)
* Twelve
month trailing
* Six
month trailing
* One month
Fed Funds 0.08 0.04 0.01
Overnight Repo 0.04 0.02 0.00
Merrill Lynch 3m US Treas Bill 0.03 0.02 0.00
Merrill Lynch 6m US Treas Bill 0.04 0.02 0.01
ML 1 Year US Treasury Note 0.10 0.07 0.03
ML 2 Year US Treasury Note 0.27 0.19 0.06
ML 5 Year US Treasury Note 0.86 0.50 0.10
* rates reflected are cumulative
Summary of Amortized Cost Basis Return for the Period
Total portfolio
Interest earned 46,575.76
Accretion (amortization) (17,746.63)
Realized gain (loss) on sales 0.00
Total income on portfolio 28,829.13
Average daily amortized cost 28,967,173.05
Period return (%)
Weighted average final maturity in days 647
YTD return (%)
Detail of Amortized Cost Basis Return
Interest
earned
Realized
gain (loss)
Accretion
(amortization)
Total
income
0.00 Cash and Cash Equivalents 2.17 0.00 2.17
0.00 Corporate Bonds 19,485.13 (11,633.96) 7,851.17
0.00 Government Agencies 20,784.20 (3,711.13) 17,073.07
0.00 Government Bonds 6,304.26 (2,401.54) 3,902.72
Total 46,575.76 (17,746.63) 0.00 28,829.13
0.10 1.38
4 ACTIVITY AND PERFORMANCE SUMMARY
For the period December 1, 2021 - December 31, 2021
CITY OF SAN PABLO
Fair Value Basis Activity Summary
29,088,110.69 Opening balance
76,159.67 Income received
76,159.67 Total receipts
0.00 Total disbursements
0.00 Interportfolio transfers
0.00 Total Interportfolio transfers
0.00 Unrealized gain (loss) on security movements
0.00 Change in accruals from security movement
0.00 Return of capital
Change in fair value for the period (66,907.74)
Ending fair value 29,097,362.62
Comparative Rates of Return (%)
* Twelve
month trailing
* Six
month trailing
* One month
Fed Funds 0.08 0.04 0.01
Overnight Repo 0.04 0.02 0.00
ICE Bofa 3 Months US T-BILL 0.05 0.02 0.01
ICE Bofa 6m US Treas Bill 0.09 0.03 0.01
ICE Bofa 1 Yr US Treasury Note (0.07) (0.16) (0.11)
ICE BofA US Treasury 1-3 (0.55) (0.47) (0.25)
ICE BofA US Treasury 1-5 (1.10) (0.69) (0.28)
* rates reflected are cumulative
Detail of Fair Value Basis Return
Interest
earned
Change in
fair value
Total
income
Cash and Cash Equivalents 2.17 0.00 2.17
Corporate Bonds 19,485.13 (12,572.61) 6,912.52
Government Agencies 20,784.20 (42,809.75) (22,025.55)
Government Bonds 6,304.26 (11,525.38) (5,221.12)
Total 46,575.76 (66,907.74) (20,331.98)
Summary of Fair Value Basis Return for the Period
Total portfolio
Interest earned 46,575.76
Total income on portfolio (20,331.98)
Average daily total value * 29,218,019.45
Period return (%) (0.07)
Weighted average final maturity in days 647
Change in fair value (66,907.74)
YTD return (%) (0.47)
* Total value equals market value and accrued interest
5 RECAP OF SECURITIES HELD
As of December 31, 2021
CITY OF SAN PABLO
Weighted
average
final
maturity (days)
Weighted
average
effective
duration (years)
Percent
of
portfolio
Amortized
cost
Historical
cost
Fair value Unrealized
gain (loss)
Cash and Cash Equivalents 147,625.34 147,625.34 147,62 5.34 0.00 0.50 0.00 1 Corporate Bonds 8,277,076.50 8,130,471.97 8,140,608.03 10,136.06 661 28.29 1.50 Government Agencies 17,419,089.70 17,314,081.74 17,381 ,146.82 67,065.08 677 59.54 1.66 Government Bonds 3,412,460.94 3,401,601.50 3,427,982.4 3 26,380.93 486 11.66 1.31 Total 29,256,252.48 28,993,780.55 29,097,362.62 103,582.07 64 7 100.00 1.56 Cash and Cash Equivalents
Corporate Bonds
Government Agencies
Government Bonds
Portfolio diversification (%)
Cash and Cash Equivalents 0.50
Corporate Bonds 28.29
Government Agencies 59.54
Government Bonds 11.66
Portfolio diversification (%)
6 MATURITY DISTRIBUTION OF SECURITIES HELD
As of December 31, 2021
CITY OF SAN PABLO
Maturity Historic cost Percent
Under 90 days 1,254,054.84 4.29
90 to 179 days 1,616,868.00 5.53
180 days to 1 year 3,703,317.19 12.66
1 to 2 years 11,358,958.25 38.83
2 to 3 years 10,219,908.20 34.93
3 to 4 years 1,103,146.00 3.77
4 to 5 years 0.00 0.00
Over 5 years 0.00 0.00
29,256,252.48 100.00
Maturity distribution
0.00 2.00
4.00 6.00
8.00 10.00
12.00 Historical cost (mm)
Un
der 90 d
ays
90 to 179 d
ays 180 days
to 1 yea
r
1 to
2 years
2 to 3
years
3 to 4
years
4 to
5 years
Over 5 years
7 SECURITIES HELD
As of December 31, 2021
CITY OF SAN PABLO
Amortized cost Fair value Unrealized
gain
(loss)
Coupon Maturity/
Call date
Historical cost Cusip Total
accrued
interest
%
Port
cost
Par value or
shares
Description
Cash and Cash Equivalents
0.000 147,625.34 147,625.34 0.00 0.00 0.50 147,625.34 147,625.34 Cash and Cash Equivalents Total Cash and Cash Equivalents 147,625.34 147,625.34 147,625.34 0.00 0.50 0.00 147,625.34 Corporate Bonds
0258M0EG0 2.700 03/03/2022 561,181.50 551,118.15 (187.05) 4,867.50 01/31/2022
1.92550,931.10 550,000.00 AMERICAN EXPRESS CREDIT 2.7% 03MAR2022 (CALLABLE 31JAN22)
89236TFX8 2.650 04/12/2022 510,730.00 501,524.32 1,616.26 2,907.64 1.75503,140.58 500,000.00 TOYOTA MOTOR CREDIT CORP 2.65% 12APR2022 25468PCW4 2.350 12/01/2022 502,850.00 500,771.34 5,749.51 979.17 1. 72506,520.85 500,000.00 TWDC ENTERPRISES 18 CORP 2.35% 01DEC2022 166764AH3 3.191 06/24/2023 525,060.00 510,042.09 4,805.56 310.24 03/24/2023
1.79514,847.65 500,000.00 CHEVRON CORP 3.191% 24JUN2023 (CALLABLE 24MAR23)
90331HNV1 3.400 07/24/2023 629,250.00 611,621.65 12,294.16 8,896.6 7 06/24/2023
2.15623,915.81 600,000.00 US BANK NA CINCINNATI 3.4% 24JUL2023 (CALLABLE 23JUN23)
06051GHC6 3.004 12/20/2023 525,840.00 511,506.36 (1,141.46) 458.94 12/20/2022
1.80510,364.90 500,000.00 BANK OF AMERICA CORP 3.004% 20DEC2023 (CALLABLE 20DEC22)
17325FAS7 3.650 01/23/2024 1,007,152.00 978,596.05 20,840.63 15,21 8.47 12/23/2023
3.44999,436.68 950,000.00 CITIBANK NA 3.65% 23JAN2024 (CALLABLE 23DEC23) 693475AV7 3.500 01/23/2024 644,448.00 636,385.10 (8,036.46) 9,216. 67 12/24/2023
2.20628,348.64 600,000.00 PNC FINANCIAL SERVICES 3.5% 23JAN2024 (CALLABLE 23DEC23)
06051GHF9 3.550 03/05/2024 535,690.00 515,966.58 (1,068.70) 5,719. 44 03/05/2023
1.83514,897.88 500,000.00 BANK OF AMERICA CORP 3.55% 05MAR2024 (CALLABLE 05MAR23)
46647PBZ8 0.697 03/16/2024 702,695.00 702,065.06 (3,723.57) 1,423. 04 03/16/2023
2.40698,341.49 700,000.00 JPMORGAN CHASE & CO 0.697% 16MAR2024 (CALLABLE 16MAR23)
8 SECURITIES HELD
As of December 31, 2021
CITY OF SAN PABLO
Amortized cost Fair value Unrealized
gain
(loss)
Coupon Maturity/
Call date
Historical cost Cusip Total
accrued
interest
%
Port
cost
Par value or
shares
Description
Corporate Bonds
459200JY8 3.000 05/15/2024 535,390.00 526,706.49 (4,307.77) 1,916. 67 1.83522,398.72 500,000.00 IBM CORP 3% 15MAY2024 14913Q2V0 2.850 05/17/2024 1,064,950.00 1,055,495.66 (11,351.13) 3 ,483.33 3.641,044,144.53 1,000,000.00 CATERPILLAR FINL SERVICE 2.85% 17MAY2024 931142DV2 2.650 12/15/2024 531,840.00 528,673.12 (5,353.92) 588.89 10/15/2024
1.82523,319.20 500,000.00 WALMART INC 2.65% 15DEC2024 (CALLABLE 15OCT24) Total Corporate Bonds 8,277,076.50 8,130,471.97 8,140,608.03 10,136.06 28.29 55,986.67 7,900,000.00 Government Agencies
3135G0S38 2.000 01/05/2022 545,248.00 549,975.88 83.22 5,377.78 1.8 6550,059.10 550,000.00 FANNIE MAE 2% 05JAN2022 313379Q69 2.125 06/10/2022 1,106,138.00 1,100,910.18 8,178.64 1,36 3.54 3.781,109,088.82 1,100,000.00 FEDERAL HOME LOAN BANK 2.125% 10JUN2022 3130A3KM5 2.500 12/09/2022 1,022,510.00 1,006,139.09 13,708.37 1,5 27.78 3.501,019,847.46 1,000,000.00 FEDERAL HOME LOAN BANK 2.5% 09DEC2022 3133EKKT2 2.250 02/08/2023 1,014,550.00 1,004,447.70 17,851.12 8,9 37.50 3.471,022,298.82 1,000,000.00 FEDERAL FARM CREDIT BANK 2.25% 08FEB2023 3137EAEN5 2.750 06/19/2023 1,499,865.50 1,468,681.90 26,938.49 1,3 29.17 5.131,495,620.39 1,450,000.00 FREDDIE MAC 2.75% 19JUN2023 3133EKZK5 1.600 08/14/2023 1,000,509.00 1,000,207.44 19,351.93 6,0 88.89 3.421,019,559.37 1,000,000.00 FEDERAL FARM CREDIT BANK 1.6% 14AUG2023 3135G0U43 2.875 09/12/2023 1,041,890.00 1,016,910.74 20,067.13 8,7 04.86 3.561,036,977.87 1,000,000.00 FANNIE MAE 2.875% 12SEP2023 3134GXJH8 0.220 09/29/2023 1,199,700.00 1,199,809.78 (5,820.68) 14 .67 03/29/2022
4.101,193,989.10 1,200,000.00 FREDDIE MAC 0.22% 29SEP2023 (CALLABLE 29MAR22) 9 SECURITIES HELD
As of December 31, 2021
CITY OF SAN PABLO
Amortized cost Fair value Unrealized
gain
(loss)
Coupon Maturity/
Call date
Historical cost Cusip Total
accrued
interest
%
Port
cost
Par value or
shares
Description
Government Agencies
3137EAFA2 0.250 12/04/2023 500,500.00 500,381.74 (5,054.38) 93.75 1 .71495,327.36 500,000.00 FREDDIE MAC 0.25% 04DEC2023 3135G0V34 2.500 02/05/2024 1,038,382.00 1,018,529.24 17,051.06 10, 138.89 3.551,035,580.30 1,000,000.00 FANNIE MAE 2.5% 05FEB2024 3133EMBE1 0.300 03/28/2024 1,498,875.00 1,499,278.57 (16,087.15) 1 ,162.50 5.121,483,191.42 1,500,000.00 FEDERAL FARM CREDIT BANK 0.3% 28MAR2024 (CALLABLE 12JAN22)
3130AMQQ8 0.350 04/23/2024 1,200,000.00 1,200,000.00 (9,202.51) 93 .33 03/23/2022
4.101,190,797.49 1,200,000.00 FEDERAL HOME LOAN BANK 0.35% 23APR2024 (CALLABLE 23MAR22)
3136G46B4 0.350 04/26/2024 1,449,595.00 1,449,729.91 (17,044.39) 9 16.32 01/26/2022
4.951,432,685.52 1,450,000.00 FANNIE MAE 0.35% 26APR2024 (CALLABLE 26JAN22) 3135G0V75 1.750 07/02/2024 601,990.80 601,078.50 12,187.10 5,220.8 3 2.06613,265.60 600,000.00 FANNIE MAE 1.75% 02JUL2024 3135G0W66 1.625 10/15/2024 797,190.40 798,362.15 16,696.83 2,744.4 4 2.72815,058.98 800,000.00 FANNIE MAE 1.625% 15OCT2024 3133EMCN0 0.400 10/15/2024 799,000.00 799,292.25 (11,764.96) 675.5 6 2.73787,527.29 800,000.00 FEDERAL FARM CREDIT BANK 0.4% 15OCT2024 (CALLABLE 12JAN22)
3130AL2A1 0.500 02/10/2025 1,103,146.00 1,100,346.67 (20,074.74) 2 ,154.17 02/10/2022
3.771,080,271.93 1,100,000.00 FEDERAL HOME LOAN BANK 0.5% 10FEB2025 (CALLABLE 10FEB22)
Total Government Agencies 17,419,089.70 17,314,081.74 17,381,146.82 67,065.08 59. 5456,543.98 17,250,000.00 Government Bonds
9128282S8 1.625 08/31/2022 647,664.06 649,511.08 6,354.16 3,559.74 2.21655,865.24 650,000.00 USA TREASURY 1.625% 31AUG2022 912828M49 1.875 10/31/2022 1,004,453.13 1,001,107.82 11,353.12 3,1 59.53 3.431,012,460.94 1,000,000.00 USA TREASURY 1.875% 31OCT2022 10 SECURITIES HELD
As of December 31, 2021
CITY OF SAN PABLO
Amortized cost Fair value Unrealized
gain
(loss)
Coupon Maturity/
Call date
Historical cost Cusip Total
accrued
interest
%
Port
cost
Par value or
shares
Description
Government Bonds
9128285K2 2.875 10/31/2023 1,147,781.25 1,145,213.09 (1,728.71) 5, 329.08 3.921,143,484.38 1,100,000.00 USA TREASURY 2.875% 31OCT2023 912828U57 2.125 11/30/2023 612,562.50 605,769.51 10,402.36 1,085.8 5 2.09616,171.87 600,000.00 USA TREASURY 2.125% 30NOV2023 Total Government Bonds 3,412,460.94 3,401,601.50 3,427,982.43 26,380.93 11.66 13,134.20 3,350,000.00 Grand total 29,256,252.48 28,993,780.55 103,582.07 28,647,625.34 100.00125,664.85 29,097,362.62 11 GASB 40 - DEPOSIT AND INVESTMENT RISK DISCLOSURE
As of December 31, 2021
CITY OF SAN PABLO
Cusip S&P
rating
Moody
rating
Historical
cost
% Portfolio
hist cost
Market
value
% Portfolio
mkt value
Effective
dur (yrs)
Description Coupon Maturity
date
Call date Par value or
shares
Federal National Mortgage Association
3135G0S38 FANNIE MAE 2% 2.000 01/05/2022 AA+ Aaa 550,000.00 545,248 .00 1.86 550,059.10 1.89 0.01 3135G0U43 FANNIE MAE 2.875% 2.875 09/12/2023 AA+ Aaa 1,000,000.00 1 ,041,890.00 3.56 1,036,977.87 3.56 1.66 3135G0V34 FANNIE MAE 2.5% 2.500 02/05/2024 AA+ Aaa 1,000,000.00 1,0 38,382.00 3.55 1,035,580.30 3.56 2.03 3136G46B4 FANNIE MAE 0.35% 0.350 04/26/2024 01/26/2022 AA+ Aaa 1,45 0,000.00 1,449,595.00 4.95 1,432,685.52 4.92 1.93 3135G0V75 FANNIE MAE 1.75% 1.750 07/02/2024 AA+ Aaa 600,000.00 601, 990.80 2.06 613,265.60 2.11 2.43 3135G0W66 FANNIE MAE 1.625% 1.625 10/15/2024 AA+ Aaa 800,000.00 797 ,190.40 2.72 815,058.98 2.80 2.72 Issuer total 5,400,000.00 5,474,296.20 18.71 5,483,627.37 18.85 1.88 Federal Home Loan Banks
313379Q69 FEDERAL HOME LOAN 2.125 06/10/2022 AA+ Aaa 1,100,000.00 1 ,106,138.00 3.78 1,109,088.82 3.81 0.44 3130A3KM5 FEDERAL HOME LOAN 2.500 12/09/2022 AA+ Aaa 1,000,000.00 1 ,022,510.00 3.50 1,019,847.46 3.50 0.93 3130AMQQ FEDERAL HOME LOAN 0.350 04/23/2024 03/23/2022 AA+ Aaa 1,2 00,000.00 1,200,000.00 4.10 1,190,797.49 4.09 1.70 3130AL2A1 FEDERAL HOME LOAN 0.500 02/10/2025 02/10/2022 AA+ Aaa 1,1 00,000.00 1,103,146.00 3.77 1,080,271.93 3.71 2.58 Issuer total 4,400,000.00 4,431,794.00 15.15 4,400,005.70 15.12 1.43 Federal Farm Credit Banks Funding Corp
3133EKKT2 FEDERAL FARM CREDIT 2.250 02/08/2023 AA+ Aaa 1,000,000.0 0 1,014,550.00 3.47 1,022,298.82 3.51 1.09 3133EKZK5 FEDERAL FARM CREDIT 1.600 08/14/2023 AA+ Aaa 1,000,000.0 0 1,000,509.00 3.42 1,019,559.37 3.50 1.59 3133EMBE1 FEDERAL FARM CREDIT 0.300 03/28/2024 AA+ Aaa 1,500,000.0 0 1,498,875.00 5.12 1,483,191.42 5.10 1.97 3133EMCN0 FEDERAL FARM CREDIT 0.400 10/15/2024 AA+ Aaa 800,000.00 7 99,000.00 2.73 787,527.29 2.71 2.41 Issuer total 4,300,000.00 4,312,934.00 14.74 4,312,576.90 14.82 1.76 United States Treasury Note/Bond
9128282S8 USA TREASURY 1.625% 1.625 08/31/2022 AA+ Aaa 650,000.00 6 47,664.06 2.21 655,865.24 2.25 0.66 912828M49 USA TREASURY 1.875% 1.875 10/31/2022 AA+ Aaa 1,000,000.0 0 1,004,453.13 3.43 1,012,460.94 3.48 0.83 9128285K2 USA TREASURY 2.875% 2.875 10/31/2023 AA+ Aaa 1,100,000.0 0 1,147,781.25 3.92 1,143,484.38 3.93 1.79 12 GASB 40 - DEPOSIT AND INVESTMENT RISK DISCLOSURE
As of December 31, 2021
CITY OF SAN PABLO
Cusip S&P
rating
Moody
rating
Historical
cost
% Portfolio
hist cost
Market
value
% Portfolio
mkt value
Effective
dur (yrs)
Description Coupon Maturity
date
Call date Par value or
shares
United States Treasury Note/Bond
912828U57 USA TREASURY 2.125% 2.125 11/30/2023 AA+ Aaa 600,000.00 6 12,562.50 2.09 616,171.87 2.12 1.88 Issuer total 3,350,000.00 3,412,460.94 11.66 3,427,982.43 11.78 1.31 Federal Home Loan Mortgage Corp
3137EAEN5 FREDDIE MAC 2.75% 2.750 06/19/2023 AA+ Aaa 1,450,000.00 1 ,499,865.50 5.13 1,495,620.39 5.14 1.44 3134GXJH8 FREDDIE MAC 0.22% 0.220 09/29/2023 03/29/2022 AA+ Aaa 1,2 00,000.00 1,199,700.00 4.10 1,193,989.10 4.10 1.32 3137EAFA2 FREDDIE MAC 0.25% 0.250 12/04/2023 AA+ Aaa 500,000.00 500 ,500.00 1.71 495,327.36 1.70 1.92 Issuer total 3,150,000.00 3,200,065.50 10.94 3,184,936.85 10.95 1.47 Caterpillar Financial Services Corp
14913Q2V0 CATERPILLAR FINL 2.850 05/17/2024 A A2 1,000,000.00 1,064 ,950.00 3.64 1,044,144.53 3.59 2.30 Issuer total 1,000,000.00 1,064,950.00 3.64 1,044,144.53 3.59 2.30 Bank of America Corp
06051GHC6 BANK OF AMERICA CORP 3.004 12/20/2023 12/20/2022 A- A2 50 0,000.00 525,840.00 1.80 510,364.90 1.75 0.96 06051GHF9 BANK OF AMERICA CORP 3.550 03/05/2024 03/05/2023 A- A2 50 0,000.00 535,690.00 1.83 514,897.88 1.77 1.14 Issuer total 1,000,000.00 1,061,530.00 3.63 1,025,262.78 3.52 1.05 Citibank NA
17325FAS7 CITIBANK NA 3.65% 3.650 01/23/2024 12/23/2023 A+ Aa3 950, 000.00 1,007,152.00 3.44 999,436.68 3.43 1.90 Issuer total 950,000.00 1,007,152.00 3.44 999,436.68 3.43 1.90 JPMorgan Chase & Co
46647PBZ8 JPMORGAN CHASE & CO 0.697 03/16/2024 03/16/2023 A- A2 700 ,000.00 702,695.00 2.40 698,341.49 2.40 1.19 Issuer total 700,000.00 702,695.00 2.40 698,341.49 2.40 1.19 13 GASB 40 - DEPOSIT AND INVESTMENT RISK DISCLOSURE
As of December 31, 2021
CITY OF SAN PABLO
Cusip S&P
rating
Moody
rating
Historical
cost
% Portfolio
hist cost
Market
value
% Portfolio
mkt value
Effective
dur (yrs)
Description Coupon Maturity
date
Call date Par value or
shares
PNC Financial Services Group Inc/The
693475AV7 PNC FINANCIAL 3.500 01/23/2024 12/24/2023 A- A3 600,000.0 0 644,448.00 2.20 628,348.64 2.16 1.91 Issuer total 600,000.00 644,448.00 2.20 628,348.64 2.16 1.91 US Bank NA/Cincinnati OH
90331HNV1 US BANK NA CINCINNATI 3.400 07/24/2023 06/24/2023 AA- A1 600,000.00 629,250.00 2.15 623,915.81 2.14 1.44 Issuer total 600,000.00 629,250.00 2.15 623,915.81 2.14 1.44 American Express Credit Corp
0258M0EG0 AMERICAN EXPRESS 2.700 03/03/2022 01/31/2022 A- A2 550,00 0.00 561,181.50 1.92 550,931.10 1.89 0.08 Issuer total 550,000.00 561,181.50 1.92 550,931.10 1.89 0.08 Walmart Inc
931142DV2 WALMART INC 2.65% 2.650 12/15/2024 10/15/2024 AA Aa2 500, 000.00 531,840.00 1.82 523,319.20 1.80 2.74 Issuer total 500,000.00 531,840.00 1.82 523,319.20 1.80 2.74 International Business Machines Corp
459200JY8 IBM CORP 3% 3.000 05/15/2024 A- A3 500,000.00 535,390.00 1 .83 522,398.72 1.80 2.29 Issuer total 500,000.00 535,390.00 1.83 522,398.72 1.80 2.29 Chevron Corp
166764AH3 CHEVRON CORP 3.191% 3.191 06/24/2023 03/24/2023 AA- Aa2 5 00,000.00 525,060.00 1.79 514,847.65 1.77 1.22 Issuer total 500,000.00 525,060.00 1.79 514,847.65 1.77 1.22 TWDC Enterprises 18 Corp
25468PCW4 TWDC ENTERPRISES 18 2.350 12/01/2022 BBB+ A2 500,000.00 5 02,850.00 1.72 506,520.85 1.74 0.91 Issuer total 500,000.00 502,850.00 1.72 506,520.85 1.74 0.91 14 GASB 40 - DEPOSIT AND INVESTMENT RISK DISCLOSURE
As of December 31, 2021
CITY OF SAN PABLO
Cusip S&P
rating
Moody
rating
Historical
cost
% Portfolio
hist cost
Market
value
% Portfolio
mkt value
Effective
dur (yrs)
Description Coupon Maturity
date
Call date Par value or
shares
Toyota Motor Credit Corp
89236TFX8 TOYOTA MOTOR CREDIT 2.650 04/12/2022 A+ A1 500,000.00 510 ,730.00 1.75 503,140.58 1.73 0.28 Issuer total 500,000.00 510,730.00 1.75 503,140.58 1.73 0.28 Cash and Cash Equivalents
INVESTED CASH 0.000 147,625.34 147,625.34 0.00 147,625.34 0.51 0.00 Issuer total 147,625.34 147,625.34 0.00 147,625.34 0.51 0.00 Grand total 28,647,625.34 29,256,252.48 100.00 29,097,362.62 100.00 1.56 15 DETAIL OF RETURN AND INTEREST RECEIVED
For the period December 1, 2021 - December 31, 2021
CITY OF SAN PABLO
Description Interest earned Accretion
(amortization)
Realized gain
(loss)
Change in fair
value
Interest receivedCusip
Cash
Cash and Cash Equivalents 2.17 0.00 0.00 2.170.00
Total Cash 2.17 0.00 0.00 2.170.00
Corporate Bonds
AMERICAN EXPRESS CREDIT 2.7% 03MAR2022 (CALLABLE 31JAN22) 1,278.75 (1,080.88) (1,159.16) 0.000.00 0258M0EG0 BANK OF AMERICA CORP 3.004% 20DEC2023 (CALLABLE 20DEC22) 1,293.38 (986.26) (900.06) 7,510.000.00 06051GHC6 BANK OF AMERICA CORP 3.55% 05MAR2024 (CALLABLE 05MAR23) 1,528.47 (1,127.05) (1,504.82) 0.000.00 06051GHF9 CATERPILLAR FINL SERVICE 2.85% 17MAY2024 2,454.16 (1,942.67) 3,386.27 0.000.00 14913Q2V0 CHEVRON CORP 3.191% 24JUN2023 (CALLABLE 24MAR23) 1,373.91 (678.52) (1,655.45) 7,977.500.00 166764AH3 CITIBANK NA 3.65% 23JAN2024 (CALLABLE 23DEC23) 2,985.90 (1,203.20) (3,322.61) 0.000.00 17325FAS7 IBM CORP 3% 15MAY2024 1,291.67 (937.07) (769.64) 0.000.00 459200JY8 JPMORGAN CHASE & CO 0.697% 16MAR2024 (CALLABLE 16MAR23) 420.13 (142.09) (711.99) 0.000.00 46647PBZ8 PNC FINANCIAL SERVICES 3.5% 23JAN2024 (CALLABLE 23DEC23) 1,808.34 (1,530.93) (1,835.05) 0.000.00 693475AV7 TOYOTA MOTOR CREDIT CORP 2.65% 12APR2022 1,140.97 (448.33) (789.15) 0.000.00 89236TFX8 TWDC ENTERPRISES 18 CORP 2.35% 01DEC2022 1,011.81 (69.91) (1,827.62) 5,875.000.00 25468PCW4 US BANK NA CINCINNATI 3.4% 24JUL2023 (CALLABLE 23JUN23) 1,756.67 (631.14) 13.96 0.000.00 90331HNV1 WALMART INC 2.65% 15DEC2024 (CALLABLE 15OCT24) 1,140.97 (855.91) (1,497.29) 6,625.000.00 931142DV2 Total Corporate Bonds 19,485.13 (11,633.96) (12,572.61) 27,987.500.00 Government Agencies
FANNIE MAE 0.35% 26APR2024 (CALLABLE 26JAN22) 437.01 9.69 (5,731.65) 0.000.00 3136G46B4 FANNIE MAE 1.625% 15OCT2024 1,119.44 48.89 (2,316.94) 0.000.00 3135G0W66 16 DETAIL OF RETURN AND INTEREST RECEIVED
For the period December 1, 2021 - December 31, 2021
CITY OF SAN PABLO
Description Interest earned Accretion
(amortization)
Realized gain
(loss)
Change in fair
value
Interest receivedCusip
Government Agencies
FANNIE MAE 1.75% 02JUL2024 904.16 (35.87) (1,831.72) 0.000.00 3135G0V75 FANNIE MAE 2% 05JAN2022 947.22 144.73 (930.35) 0.000.00 3135G0S38 FANNIE MAE 2.5% 05FEB2024 2,152.78 (710.78) (5,420.83) 0.000.00 3135G0V34 FANNIE MAE 2.875% 12SEP2023 2,475.69 (828.96) (4,717.16) 0.000.00 3135G0U43 FEDERAL FARM CREDIT BANK 0.3% 28MAR2024 (CALLABLE 12JAN22) 387.50 26.78 (2,829.11) 0.000.00 3133EMBE1 FEDERAL FARM CREDIT BANK 0.4% 15OCT2024 (CALLABLE 12JAN22) 275.56 21.12 (1,256.77) 0.000.00 3133EMCN0 FEDERAL FARM CREDIT BANK 1.6% 14AUG2023 1,377.78 (10.65) 1,400.20 0.000.00 3133EKZK5 FEDERAL FARM CREDIT BANK 2.25% 08FEB2023 1,937.50 (335.25) (952.85) 0.000.00 3133EKKT2 FEDERAL HOME LOAN BANK 0.35% 23APR2024 (CALLABLE 23MAR22) 361.66 0.00 (2,088.36) 2,100.000.00 3130AMQQ8 FEDERAL HOME LOAN BANK 0.5% 10FEB2025 (CALLABLE 10FEB22) 473.61 (260.00) (1,950.48) 0.000.00 3130AL2A1 FEDERAL HOME LOAN BANK 2.125% 10JUN2022 2,012.85 (170.65) (2,689.58) 11,687.500.00 313379Q69 FEDERAL HOME LOAN BANK 2.5% 09DEC2022 2,152.78 (543.28) (2,381.51) 12,500.000.00 3130A3KM5 FREDDIE MAC 0.22% 29SEP2023 (CALLABLE 29MAR22) 227.34 9.07 (1,701.60) 1,320.000.00 3134GXJH8 FREDDIE MAC 0.25% 04DEC2023 107.64 (16.50) (1,102.71) 625.000.00 3137EAFA2 FREDDIE MAC 2.75% 19JUN2023 3,433.68 (1,059.47) (6,308.33) 19,937.500.00 3137EAEN5 Total Government Agencies 20,784.20 (3,711.13) (42,809.75) 48,170.000.00 Government Bonds
USA TREASURY 1.625% 31AUG2022 904.53 62.37 (1,142.57) 0.000.00 9128282S8 USA TREASURY 1.875% 31OCT2022 1,605.66 (112.96) (2,460.94) 0.000.00 912828M49 USA TREASURY 2.125% 30NOV2023 1,085.85 (255.87) (2,507.82) 0.000.00 912828U57 17 DETAIL OF RETURN AND INTEREST RECEIVED
For the period December 1, 2021 - December 31, 2021
CITY OF SAN PABLO
Description Interest earned Accretion
(amortization)
Realized gain
(loss)
Change in fair
value
Interest receivedCusip
Government Bonds
USA TREASURY 2.875% 31OCT2023 2,708.22 (2,095.08) (5,414.05) 0.000.00 9128285K2 Total Government Bonds 6,304.26 (2,401.54) (11,525.38) 0.000.00 Grand total 46,575.76 (17,746.63) (66,907.74) 76,159.670.00 18 TRANSACTION REPORT
For the period December 1, 2021 - December 31, 2021
CITY OF SAN PABLO
Maturity Par value or
shares
Interest Transaction totalPrincipal Transaction Cusip Sec type Description Trade date Settle date
Realized
gain(loss)
5,875.00 12/01/2021
12/01/2021
Income 25468PCW4 Corporate Bonds TWDC ENTERPRISES 18 CORP 12/ 01/2022 500,000.00 0.00 5,875.000.00 625.00 12/04/2021
12/04/2021
Income 3137EAFA2 Government Agencies FREDDIE MAC 0.25% 12/04/ 2023 500,000.00 0.00 625.00 0.00 12,500.00 12/09/2021
12/09/2021
Income 3130A3KM5 Government Agencies FEDERAL HOME LOAN BANK 1 2/09/2022 1,000,000.00 0.00 12,500.000.00 11,687.50 12/10/2021
12/10/2021
Income 313379Q69 Government Agencies FEDERAL HOME LOAN BANK 0 6/10/2022 1,100,000.00 0.00 11,687.500.00 6,625.00 12/15/2021
12/15/2021
Income 931142DV2 Corporate Bonds WALMART INC 2.65% 12/15/2024 500,000.00 0.00 6,625.000.00 19,937.50 12/19/2021
12/19/2021
Income 3137EAEN5 Government Agencies FREDDIE MAC 2.75% 06/19/ 2023 1,450,000.00 0.00 19,937.500.00 7,510.00 12/20/2021
12/20/2021
Income 06051GHC6 Corporate Bonds BANK OF AMERICA CORP 12/20/2 023 500,000.00 0.00 7,510.000.00 2,100.00 12/23/2021
12/23/2021
Income 3130AMQQ8 Government Agencies FEDERAL HOME LOAN BANK 0 4/23/2024 1,200,000.00 0.00 2,100.000.00 7,977.50 12/24/2021
12/24/2021
Income 166764AH3 Corporate Bonds CHEVRON CORP 3.191% 06/24/20 23 500,000.00 0.00 7,977.500.00 1,320.00 12/29/2021
12/29/2021
Income 3134GXJH8 Government Agencies FREDDIE MAC 0.22% 09/29/ 2023 1,200,000.00 0.00 1,320.000.00
2.17 Income Cash and Cash Equivalents Cash 2.170.00 0.00 0.00 12/31/2021 19 ADDITIONAL INFORMATION
As of December 31, 2021
CITY OF SAN PABLO
Past performance is not a guide to future performance. The value of investments and any income from them will fluctuate and is not guaranteed (this may partly be due to exchange rate changes) and investors may not get back the amount invested. Transactions in foreign securities may be executed and settled in local markets. Performance comparisons will be affected by changes in interest rates. Investment returns fluctuate due to changes in market conditions. Investment involves risk, including the possible loss of principal. No assurance can be given that the performance objectives of a given strategy will be achieved. The information contained herein is for your reference only and is being provided in response to your specific request and has been obtained from sources believed to be reliable; however, no representation is made regarding its accuracy or completeness. This document must not be used for the purpose of an offer or solicitation in any jurisdiction or in any circumstances in which such offer or solicitation is unlawful or otherwise not permitted. This document should not be duplicated, amended, or forwarded to a third party without consent from Insight. This is a marketing document intended for professional clients only and should not be made available to or relied upon by retail clients Investment advisory services in North America are provided through two different SEC-registered investment advisers using the brand Insight Investment: Insight North America LLC (INA) and Insight Investment International Limited (IIIL). The North American investment advisers are associated with a broader group of global investment managers that also (individually and collectively) use the corporate brand Insight Investment and may be referred to as Insight, Insight Group or Insight Investment.
INA is an investment adviser registered with the Securities and Exchange Commission (SEC), under the Investment Advisers Act of 1940, as amended. Registration with the SEC does not imply a certain level of skill or training.
You may request, without charge, additional information about Insight. Moreover, specific information relating to Insights strategies, including investment advisory fees, may be obtained from INA's Form ADV Part 2A, which is available without charge upon request.
Where indicated, performance numbers used in the analysis are gross returns. The performance reflects the reinvestment of all dividends and income. INA charges management fees on all portfolios managed and these fees will reduce the returns on the portfolios. For example, assume that $30 million is invested in an account with INA, and this account achieves a 5.0% annual return compounded monthly, gross of fees, for a period of five years.
At the end of five years that account would have grown to $38,500,760 before the deduction of management fees. Assuming management fees of 0.25% per year are deducted monthly from the account, the value at the end of the five year period would be $38,022,447. Actual fees for new accounts are dependent on size and subject to negotiation. INA's investment advisory fees are discussed in Part 2A of its Form ADV.
Unless otherwise stated, the source of information is Insight. Any forecasts or opinions are Insight’s own at the date of this document (or as otherwise specified) and may change. Material in this publication is for general information only and is not advice, investment advice, or the recommendation of any purchase or sale of any security. Insight makes no implied or expressed recommendations concerning the manner in which an account should or would be handled, as appropriate investment strategies depend upon specific investment guidelines and objectives and should not be construed to be an assurance that any particular security in a strategy will remain in any fund, account, or strategy, or that a previously held security will not be repurchased. It should not be assumed that any of the security transactions or holdings referenced herein have been or will prove to be profitable or that future investment decisions will be profitable or will equal or exceed the past investment performance of the securities listed.
Please compare the information provided in this statement to the information provided in the statement received from your Custodian.
For trading activity the Clearing broker will be reflected. In certain cases the Clearing broker will differ from the Executing broker.
In calculating ratings distributions and weighted average portfolio quality, Insight assigns U.S Treasury and U.S agency securities a quality rating based on the methodology used within the respective benchmark index. When Moody’s, S&P and Fitch rate a security, Bank of America and Merrill Lynch indexes assign a simple weighted average statistic while Barclays indexes assign the median statistic. Insight assigns all other securities the lower of Moody’s and S&P ratings.
Information about the indices shown here is provided to allow for comparison of the performance of the strategy to that of certain well-known and widely recognized indices. There is no representation that such index is an appropriate benchmark for such comparison. You cannot invest directly in an index and the indices represented do not take into account trading commissions and/or other brokerage or custodial costs. The volatility of the indices may be materially different from that of the strategy. In addition, the strategy’s holdings may differ substantially from the securities that comprise the indices shown.
The ICE BofA 3 Month US T-Bill index is an unmanaged market index of U.S. Treasury securities maturing in 90 days that assumes reinvestment of all income.
The ICE BofA 6 Month US T-Bill index measures the performance of Treasury bills with time to maturity of less than 6 months.
The ICE BofA 1-Year US Treasury Index is a one-security index comprised of the most recently issued 1-year US Treasury note. The index is rebalanced monthly. In order to qualify for inclusion, a 1-year note must be auctioned on or before the third business day before the last business day of the month.
The ICE BofA 3-Year US Treasury Index is a one-security index comprised of the most recently issued 3-year US Treasury note. The index is rebalanced monthly. In order to qualify for inclusion, a 3-year note must be auctioned on or before the third business day before the last business day of the month.
The ICE BofA 5-Year US Treasury Index is a one-security index comprised of the most recently issued 5-year US Treasury note. The index is rebalanced monthly. In order to qualify for inclusion, a 5-year note must be auctioned on or before the third business day before the last business day of the month.
The ICE BofA 1-3 US Year Treasury Index is an unmanaged index that tracks the performance of the direct sovereign debt of the U.S. Government having a maturity of at least one year and less than three years.
The ICE BofA 1-5 US Year Treasury Index is an unmanaged index that tracks the performance of the direct sovereign debt of the U.S. Government having a maturity of at least one year and less than five years. 20 ADDITIONAL INFORMATION
As of December 31, 2021
CITY OF SAN PABLO
Insight does not provide tax or legal advice to its clients and all investors are strongly urged to consult their tax and legal advisors regarding any potential strategy or investment.
Insight is a group of wholly owned subsidiaries of The Bank of New York Mellon Corporation. BNY Mellon is the corporate brand of The Bank of New York Mellon Corporation and may also be used as a generic term to reference the Corporation as a whole or its various subsidiaries generally. Products and services may be provided under various brand names and in various countries by subsidiaries, affiliates and joint ventures of The Bank of New York Mellon Corporation where authorized and regulated as required within each jurisdiction. Unless you are notified to the contrary, the products and services mentioned are not insured by the FDIC (or by any governmental entity) and are not guaranteed by or obligations of The Bank of New York Mellon Corporation or any of its affiliates. The Bank of New York Corporation assumes no responsibility for the accuracy or completeness of the above data and disclaims all expressed or implied warranties in connection therewith. © 2021 Insight Investment. All rights reserved.
21