CMS Case Study
Portfolio Restructuring for Cloyd Bank & Trust, Greenbow , AL
Transaction Summary (Pre-Tax) Institution Type: Bank
SELL 10,834,360 11,328,554 11,328,296
BUY
SELL BUY CHANGE
Book Yield: Market Yield: Average Life:
Original Portfolio Par: % Trans to Portfolio:
Par :
140,752,406 7.70%
11,400,514 11,400,514 10,964,195
0.55 0.59 1.74 1.11 3.35
1.25 1.25 6.94 4.90 1.90
0.70 0.66 5.20 3.79 -1.45
Market Value: Book Value : Gain (Loss) :
Effective Duration:
258
Coupon:
Historical scenario is selected
Portfolio Impact
Down 100 1.98%
Down 50 2.11%
2.18% Down 25
Historical 2.20%
Up 25 2.32% 2.32% 0.00% 1.28% 1.28% 0.00% -0.48% -0.56%
Up 50 2.40% 2.38% -0.02% 1.57% -1.02% -1.19% 1.57% 0.00%
4.18% -0.04% -10.50% -11.29% Up 300 2.73% 2.66% -0.07% 4.22%
Before After Change Before After Change Before After Before After Before After
1.98%
2.12%
2.19%
2.25% 0.05% 0.78% 0.83% 0.05% 0.00%
Book Yield
0.00%
0.01% 0.42% 0.42% 0.00% 0.98% 1.10%
0.01% 0.70% 0.71% 0.01% 0.51% 0.57% 1.95
-0.13% -0.16% -0.03% 1.83% 2.00%
Market Yield
% Price Change
0.00%
1.63 1.71
1.84 2.08 2.83 3.06
2.28 2.57 3.19
3.29 3.70 2.34 2.63
2.56
4.91 5.20 6.32
Effective Duration
2.20 2.94 3.25
2.86 3.52
2.65
Average Life
2.77
3.60
3.96
6.71
Change in Cashflows
Down 100 (2,116,638)
Down 50
Down 25
Historical (3,469,568) (1,500,853) (384,929) 135,561 371,585 (4,848,203)
Up 25
Up 50
Up 300 (548,814) (509,791)
Year 1 Year 2 Year 3 Year 4 Year 5 Sum
(2,507,179)
(2,633,169)
(2,410,299)
(2,092,770)
(558,228)
392,287 (3,052,645) (1,019,814) (154,412) 236,473
(1,233,807)
(1,423,177)
(1,367,077)
165,372 399,849
(343,205) 102,798 313,818
(651,692) (189,468) 82,579
(728,432) (310,662) (41,272) (4,540,214)
(426,688)
(352,604) (286,671) (2,124,568)
433,051
(1,676,594)
(3,793,565)
(4,592,057)
Cumulative Net Income
Down 100
Down 50
Down 25
Historical
Up 25
Up 50
Up 300
Income Impact
Gain with ▲ income Gain with ▲ income
Gain with ▲ income
Gain with ▲ income Gain with ▼ income
Gain with ▼ income Gain with ▼ income
Break-even Month Reinvestment Rate
N/A
N/A
N/A
N/A
N/A
N/A
N/A
0.21%
0.71%
0.96%
1.21%
1.46%
1.71%
4.21%
Year 1 Year 2 Year 3 Year 4 Year 5
$10,487
$18,095 $34,781 $49,983 $63,454 $75,206
$56,673 $66,864 $17,736 $32,450 $45,276
$62,116
($38,779) ($5,963) ($13,746) ($22,302) ($30,795)
($26,681) ($53,209) ($79,323) ($104,338) ($127,793)
($118,169)
$23,302
$95,717 $116,398 $130,241 $140,399
($241,669)
$35,229 $45,307 $53,468
($373,263) ($511,672) ($655,762)
This communication is from Raymond James & Associates, Inc. fixed incomePortfolioStrategy Group; it is not research. This communication is directed exclusively to institutional investors, for informationalpurposes only. The informationprovidedherein is not completeandmaynot be reliedon as such. We are onlyproviding this communicationon the condition that it will not form the basis for any investmentdecisionor strategyyoumaymake. Youmust independently determine the appropriatenessof an investment in any securities or strategy referred to hereinbasedon the array of informationavailable toyou,applicable legal, tax, and accountingconsiderations,aswellas yourown investment strategy and risk tolerance. Raymond James& Associates, Inc. disclaims responsibility for any such investmentdecision.You should assume Raymond James & Associates, Inc. that has a positionand will transact in any of the securitiesmentioned in this communication. Raymond James & Associates, Inc. may provide investment-banking services to any of the issuers mentioned inthis communication.The dataand values described hereinare calculatedbased on historical informationand should not be relied upon topredict future valuesor prices. Raymond James & Associates, Inc. has used sources it considers reliable. Any and all data, calculationsor expressions reflect the judgmentof the PortfolioStrategy Groupemployeeat the time ofwritingand are subject to change without notice. Raymond James& Associates, Inc. does not represent that this material is accurate, current or complete,and you should not rely upon it as such.
* Principal cashflows are displayed / Tax Rate=21% / Cost of Funds=0.51% / Subject to TEFRA / Reinvestment Rate=1.21% / Takeout Rate=0.25% / Pre-tax income is displayed
12/11/2020
Raymond James
Page 2 of 10
Made with FlippingBook PDF to HTML5