CMS Case Study
Cloyd Bank & Trust - 12/31/2021
Page
Page
Section I ‐ Executive Summary Current Position Assessment
Section IV ‐ Strategy Development Strategy Formulation Summary of Potential Strategies
4 5 6 7 8 9
34 35 38 39
Executive Risk Summary
Balance Sheet Mix
Year 1 Investment Cashflow into Loans
Historical Balance Sheet & NII Inventory of Liquidity Resources
Index MMDA to Prime
50BP Increase in Short Term Market Rates ﴾With Prime Indexed MMDA﴿ Index MMDA to Prime & Year 1 Investment Cashflow into Loans
40
Capital Analysis
41
Section II ‐ Liquidity & Cash Flow Analysis Basic Surplus Report
50BP Increase in Short Term Market Rates
42 43
11 12 13 14 15 16 17 19 20 21 22 23 24 25 26 27 28 29 30 31
50BP Increase in Short Term Market Rates & Deposit Rates
Liquidity Projection Investment Cash Flows
Section V ‐ Stress Test Analysis
Loan Cash Flows
Alternative EVE Stress Methodology
45
Wholesale Funding Maturities
Stress Test: EVE ‐ 50% Decreased Average Life on Non‐ Maturity Deposits Stress Test: EVE ‐ Remove Functional Costs on Deposits
Time Deposit Migration
46
Deposit Pricing & Activity Analysis
47
Section III ‐ Interest Rate Risk 2 Year Net Interest Income ﴾NII﴿ Simulation ‐ 12M Ramps
Appendix
Derivatives Market Indications
49 51 52 53 55 61 62 63 64 65 68
5 Year NII Simulation ‐ 12M Ramps
Market Rate Summary
5 Year NII Simulation ‐ 12M Ramps YOY Comparison 5 Year NII Simulation ‐ Alt. Ramp Scenarios 5 Year NII Simulation ‐ Alt. Ramp Scenarios Cont. 5 Year NII Simulation ‐ Rising & Falling Rate Ramp Scenarios
NII Reconciliation
Summary of Simulation Assumption Methodologies
Summary of Rates
Loan Cap Report 3m Comparison Loan Cap Report 12m Comparison Loan Floor Report 3m Comparison Loan Floor Report 12m Comparison Detailed Simulation Assumptions
5 Year NII Simulation ‐ Parallel Shock Scenarios 2 Year Net Income ﴾NI﴿ Simulation ‐ 12M Ramps
Yield Curve Assumptions
Economic Value of Equity ﴾EVE﴿ Summary Graphs and Charts
Core Funding Utilization
Balance Sheet Comparison
Funding Matrix
Static Gap
Disclaimer The information contained herein consists of data supplied by various third parties, and by the institution itself. While Darling Consulting Group ﴾DCG﴿ obtains the data from sources we believe to be reliable, we do not guarantee its accuracy. It is the responsibility of the user to independently verify all information contained in the report.
Made with FlippingBook PDF to HTML5