CMS Case Study

BBA

Portfolio Inventory Summary By Security Group: Entire Portfolio Cloyd Bank & Trust - Greenbow , AL

As Of 12/31/2021

Page 7 of 19

CUSIP

Description

Coupon Pool/Type

Orig Face Face Pledged

Par Value

Yield TEY

Proj. Avg Life

Dur Mod

as of 12/31/21 Market Value Book Value 248,000.00 248,000.00 250,000.00 250,000.00 245,000.00 245,000.00 250,000.00 250,000.00 1,489,000.00 1,489,000.00

Gain/(Loss) Mkt Price

Prev Mkt Value Prev Mkt Price

% Change

Maturity

PreRefund

as of 12/31/21

Safekeeping

20033AWR3 COMENITY CAPITAL BANK

248,000.00 248,000.00 0.00 250,000.00 250,000.00 0.00 245,000.00 245,000.00 0.00 250,000.00 250,000.00 0.00

2.350 2.350 1.660 1.660 3.398 3.398 1.050 1.050

0.706

0.698

248,000.00 100.000000 100.000000 250,000.00 100.000000 245,000.00 100.000000 250,000.00 100.000000 1,489,000.00

100.000000

0.00

%

CNTB

9/15/22

2.3500

0.00

HOPEFCU22 HOPE FCU

0.968

100.000000

0.00

0.978

%

12/23/22

1.6600

0.00

CNTB

38148PX44 GOLDMAN SACHS BANK USA

1.756

1.677

100.000000

0.00

%

CNTB

10/3/23

3.4000

0.00

795451AT0 SALLIE MAE BANK/SALT LKE

4.650

4.510

100.000000

0.00

%

CNTB

8/25/26

1.0500

0.00

0.00 %

Certificates of Deposit - FR

0.00 1,489,000.00 1,489,000.00 2.196 1.584 1.540 2.196

6

100.000000

0.00 0.00 0.00

Unrealized Gain: Unrealized Loss:

06417NA94 BANK OZK

2,000,000.00 2,000,000.00 0.00

2.750 2.750

9.750

8.498

2,010,836.34 100.541817 100.541817 2,010,836.34

2,000,000.00 2,009,528.08 2,009,528.08 2,000,000.00

100.476404

(0.07)

%

CNTB

10/1/31

2.7500

9,528.08

(0.07) %

Corporate Bonds - Var Rate

0.00 2,000,000.00 2,000,000.00 2.750 9.750 8.498 2.750

1

100.476404

9,528.08 0.00 9,528.08

Unrealized Gain: Unrealized Loss:

469249AA4 JAX BANCP STAT TRUST III

300,000.00 300,000.00 0.00

3.946 3.946

16.706

12.155

300,000.00 100.000000 100.000000 300,000.00

300,000.00 300,000.00 300,000.00 300,000.00

100.000000

0.00

%

CNTB

9/15/38

3.9527

0.00

0.00 %

Trust Preferred Stocks - VR

0.00 300,000.00 300,000.00 3.946 16.706 12.155 3.946

1

100.000000

0.00 0.00 0.00

Unrealized Gain: Unrealized Loss:

31418CCN2 FNMA 10YR

2.5000 MA2776 G18470 2.5000 3.0000 MA3454 MA4011 3.0000 G16446 2.5000

1,400,000.00 310,594.70 1,400,000.00 3,000,000.00 550,671.69 3,000,000.00 2,000,000.00 574,829.30 2,000,000.00 1,437,720.00 735,163.43 1,437,720.00 1,600,000.00 555,565.73 1,600,000.00

2.688 2.688 2.744 2.744 2.923 2.923 0.247 0.247 3.206 3.206

1.715

1.643

336,559.11 103.595753 104.145721 591,946.23 104.684639 614,974.22 105.407222 808,243.33 104.084064 595,266.90

309,211.56 321,497.28 547,614.86 573,012.19 574,723.34 601,326.60 773,427.28 773,751.00 547,274.18 577,676.18

103.510228 12,285.72 104.056954 25,397.33 104.609595 26,603.26 105.248843

(0.08)

%

CNTB

10/1/26

3128MMQY2 FHLMC 15YR

2.242

2.122

(0.09)

%

CNTB

6/1/28

31418CZU1 FNMA 10YR

2.049

1.936

(0.07)

%

CNTB

7/1/28

31418DN57 FNMA 10YR

2.500

2.433

(0.15)

%

CNTB

5/1/30

323.72

3128MFL30 FHLMC 15YR

2.197

2.065

103.979808 30,402.00

(0.10)

%

CNTB

7/1/30

(1) Previous market price is zero. Current market price used. Weighted average Yields, Avg Life, and Mod Dur are weighted by Market Value. Avg Life is Projected Average Life.

(2) Using Current Yield

Although the information in this report has been obtained from sources believed to be reliable, its accuracy cannot be guaranteed.

BBA - Baker Bond Accounting ®

The Baker Group Software Solutions, Inc.

518 518

12/29/2021 1:09 PM - DAW / GUNT

Made with FlippingBook PDF to HTML5