CMS Case Study

BBA

Projected Distribution Summary: Entire Portfolio Cloyd Bank & Trust - Greenbow , AL

As Of 12/31/2021

Page 1 of 2

Over 3 Months 3 Months or Less Through 1 Year

Through 5 Years Through 10 Years Over 10 Years Over 1 Year Over 5 Years

Security Group

Group Totals

US Treasury Notes & Bonds Book Value Market Value Par Value Yield

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

8,138,337.56 8,106,289.00 8,000,000.00 0.97

16,441,216.48 16,310,700.00 16,000,000.00 1.15

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

24,579,554.04 24,416,989.00 24,000,000.00

5.498 5.485 5.455

% % %

1.09 1.09

0.97

1.15

Yield (BV weight)

SBA Securities

Book Value Market Value Par Value Yield Yield (BV weight) Book Value Market Value Par Value Yield Yield (BV weight) Book Value Market Value Par Value Yield Yield (BV weight) Book Value Market Value Par Value Yield Yield (BV weight) Book Value Market Value Par Value Yield Yield (BV weight)

4,110,967.52 4,328,400.96 4,096,398.97 3.23

8,001,628.88 7,890,150.58 7,932,927.70 1.32

12,112,596.40 12,218,551.54 12,029,326.67

2.709 2.745 2.734

% % %

1.99 1.96

3.22

1.32

Tax Exempt Munis

1,501,073.67 1,506,625.35 1,500,000.00 3.28

2,762,554.51 2,897,881.45 2,730,000.00 3.82

8,199,499.62 8,510,496.90 8,080,000.00 3.34

18,470,240.29 19,342,478.50 17,740,000.00 3.28

30,933,368.09 32,257,482.20 30,050,000.00

6.919 7.247 6.830

% % %

3.35 3.33

3.28

3.81

3.34

3.26

Taxable Munis

305,030.48 305,268.40 305,000.00 0.85

2,418,645.04 2,466,440.40 2,425,000.00 2.52

944,380.69 925,288.60 940,000.00 1.41

6,491,922.31 6,502,883.65 6,465,000.00 2.17

10,159,978.52 10,199,881.05 10,135,000.00

2.273 2.291 2.304

% % %

2.15 2.14

0.85

2.49

1.41

2.17

Certificates of Deposit

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

994,000.00 994,000.00 994,000.00 2.19

495,000.00 495,000.00 495,000.00 2.21

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

1,489,000.00 1,489,000.00 1,489,000.00

0.333 0.335 0.338

% % %

2.20 2.20

2.19

2.21

Corporate Bonds

0.00 0.00 0.00 0.00 0.00

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

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

0.447 0.451 0.455

% % %

2.75 2.75

2.75

Yield is tax equivalent yield. Weighted average Yield is weighted by Market Value. Maturities of MBS and CMO securities are based on accounting speed. Maturities of muni securities are based on stated maturity or prerefund/call date. Distribution is based on the projected calls/maturities using market values.

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.

465 465

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