CMS Case Study
BBA
Portfolio Inventory Summary By Security Group: Entire Portfolio Cloyd Bank & Trust - Greenbow , AL
As Of 12/31/2021
Page 16 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 380,197.09 384,461.98 515,537.87 522,635.27 785,923.84 768,199.90 1,322,336.15 1,300,530.00 447,799.44 450,332.88 730,662.94 751,777.55 430,883.39 429,940.02 2,895,374.16 2,860,446.93 618,724.50 614,274.48 768,315.01 763,938.60 1,713,537.55 1,661,030.78 2,994,929.00 2,943,242.60 2,769,766.58 2,748,242.26 2,203,312.17 2,109,042.76 2,018,754.01 1,936,892.89 2,198,754.26 2,102,964.02 2,751,086.47 2,699,830.05
Gain/(Loss) Mkt Price
Prev Mkt Value Prev Mkt Price
% Change
Maturity
PreRefund
as of 12/31/21
Safekeeping
31418DF23 FNMA Conv <30 Jumbo-conforming loans
1.262 1.262 1.633 1.633 -0.168 -0.168 0.385 0.385 1.693 1.693 3.168 3.168 0.861 0.861 1.248 1.248 0.375 0.375 0.779 0.779 1.022 1.022 1.746 1.746 1.744 1.744 1.653 1.653 1.330 1.330 1.574 1.574 1.638 1.638
3.5000 MA3784 MA3812 3.5000 BR8118 3.0000 3.0000 QA5174 MA3876 3.0000 2.5000 MA3878 RE6031 3.0000 2.5000 FM2629 MA4025 2.5000 RE6049 2.5000 2.5000 FM3576 CA7106 2.0000 CA6917 2.5000 SE9014 2.0000 2.0000 FM4585 FM4870 2.0000 RA4258 1.5000
2,500,000.00 371,311.45 2,500,000.00 2,500,000.00 504,433.33 2,500,000.00 2,125,000.00 751,638.13 2,125,000.00 2,100,000.00 1,237,033.54 2,100,000.00 2,500,000.00 442,695.95 2,500,000.00 2,500,000.00 738,522.38 2,500,000.00 2,000,000.00 422,463.90 2,000,000.00 4,230,000.00 2,788,342.65 0.00 2,000,000.00 604,352.62 2,000,000.00 2,000,000.00 751,961.94 2,000,000.00 2,100,000.00 1,614,353.10 0.00 3,300,000.00 2,941,206.05 3,300,000.00 3,300,000.00 2,678,071.04 0.00 2,200,000.00 2,113,914.59 2,200,000.00 2,200,000.00 1,932,617.90 0.00 2,200,000.00 2,098,008.92 2,200,000.00 3,000,000.00 2,787,471.24 0.00
1.919
1.835
407,352.36 103.601571 103.671410 577,736.25 102.299539 814,671.42 105.318836 1,346,113.53 102.040866 476,993.85 101.969543 754,421.95 102.069953 442,259.21 102.707794 2,960,013.70 101.813556 640,754.25 101.758550 792,636.38 102.975307 1,710,742.45 100.065728 2,966,776.50 102.804109 2,786,466.03 2,111,813.57 99.684777 100.137117 1,962,786.67 100.151355 2,119,241.01 2,704,754.33 96.472386
103.541643
(0.06)
%
CNTB
9/1/49
4,264.89
31418DGW6 FNMA Conv <30 Jumbo-conforming loans
1.965
1.871
103.608393
(0.06)
%
CNTB
9/1/49
7,097.40
3617M7AT5 GNMA II 30YR
3.713
102.203423 (17,723.94) 105.132962 (21,806.15) 101.725095 101.794823 21,114.61 101.769647 102.585919 (34,927.23) 101.641734 (4,450.02) 101.592721 (4,376.41) 102.891417 (52,506.77) 100.069242 (51,686.40) 102.620215 (21,524.32) 99.769535 (94,269.41) 100.221202 (81,861.12) 100.236181 (95,790.24) 96.855889 (51,256.42) 2,533.44 (943.37)
(0.09)
3.990
%
11/20/49
CNTB
31346YXB4 FRLMC 30YR
4.646
4.348
(0.18)
%
CNTB
12/1/49
31418DJW3 FNMA Conv <30 Jumbo-conforming loans
2.425
2.276
(0.31)
%
CNTB
12/1/49
31418DJY9 FNMA Conv <30 Jumbo-conforming loans
4.655
4.121
(0.17)
%
CNTB
12/1/49
3133N3VY7 FR RE6031
2.420
2.293
(0.29)
%
CNTB
3/1/50
3140X54P5 FNMA 30YR
4.903
4.529
(0.12)
%
CNTB
3/1/50
31418DPK2 FNMA Conv <30 Jumbo-conforming loans
3.652
3.417
(0.17)
%
CNTB
5/1/50
3133N3WJ9 FR RE6049
3.767
3.509
(0.16)
%
CNTB
6/1/50
3140X66N6 FNMA 30YR
5.305
4.962
(0.08)
%
CNTB
6/1/50
3140QE3Q3 FNMA 30YR
6.603
5.964
0.00
%
CNTB
9/1/50
3140QEVK5 FNMA 30YR
5.388
4.910
(0.18)
%
CNTB
9/1/50
3133SKAP6 FR SE9014
8.445
7.582
0.09
%
CNTB
10/1/50
3140X8CX3 FNMA 30YR
6.207
6.736
0.08
%
CNTB
10/1/50
3140X8MU8 FNMA 30YR
8.348
7.537
0.08
%
CNTB
11/1/50
3133KKWT2 FRLMC 30YR
8.001
7.149
0.40
%
CNTB
12/1/50
(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.
527 527
12/29/2021 1:09 PM - DAW / GUNT
Made with FlippingBook PDF to HTML5