CMS Case Study

Investment Cash Flows - 3/31/2021

ASSETS

Q1Y1 Q2Y1 Q3Y1 Q4Y1 Q1Y2 Q2Y2 Q3Y2 Q4Y2

Y3

Y4

Y5

>Y5 CASH FLOW

125MM

TREASURIES & AGENCIES

0

0

0

0

0

0

0

0

0

0

0

0

100MM

MBS & CMO'S MUNICIPALS

6,775 4,480 3,675 3,212 3,255 3,331 3,058 2,804 12,088 11,448 10,734 76,864

75MM

440

0

705 245

905 224

0 0

0

0

900 185

1,400

2,510

3,275 24,930

50MM

OTHER INVESTMENTS

980 2,713

948

250

570

275

235

3,254

25MM

TOTAL

8,195 7,193 4,625 4,342 3,255 4,279 3,308 3,890 14,057 14,233 14,244 105,048 8,195 15,388 20,013 24,355 27,611 31,889 35,197 39,087 53,144 67,377 81,621 186,669 -94 -1,519 -2,693 -4,938 -6,584 -9,565 -11,649 -14,567 -22,674 -30,047 -29,896 0

0

CUMULATIVE

UP 200BP RATE SCENARIO

Y1

Y2

Y3

Y4

Y5

>Y5

CML Δ FROM BASE

>Y5 CASH FLOW

ASSETS

Q1Y1 Q2Y1 Q3Y1 Q4Y1 Q1Y2 Q2Y2 Q3Y2 Q4Y2

Y3

Y4

Y5

125MM

TREASURIES & AGENCIES

0

0

0

0

0

0

0

0

0

0

0

0

100MM

MBS & CMO'S

6,869 5,305 4,849 4,558 4,901 5,007 4,396 3,893 15,904 13,586 11,658 60,798

75MM

MUNICIPALS

440

600

705 1,805

0 1,305

745 2,730

5,690

7,745

2,200 11,100

50MM

OTHER INVESTMENTS

980 2,713

245

224

0

948

250

185

570

275

235

3,254

25MM

0

TOTAL

8,289 8,618 5,799 6,587 4,901 7,260 5,391 6,808 22,164 21,605 14,093 75,152

BASE RATE SCENARIO

Y1

Y2

Y3

Y4

Y5

>Y5

CUMULATIVE

8,289 16,907 22,706 29,294 34,195 41,455 46,846 53,654 75,818 97,424 111,517 186,669

ASSETS

Q1Y1 Q2Y1 Q3Y1 Q4Y1 Q1Y2 Q2Y2 Q3Y2 Q4Y2

Y3

Y4

Y5

>Y5 CASH FLOW

125MM

TREASURIES & AGENCIES

0

0

0

0

0

0

0

0

0

0

0

0

100MM

MBS & CMO'S MUNICIPALS

6,941 6,170 7,151 8,429 9,993 9,590 7,857 6,343 19,762 13,107

9,695 36,685 2,200 11,100

75MM

440

600

705 1,805

0 1,305

745 2,730

5,690

7,745

50MM

OTHER INVESTMENTS

1,280 2,713

245

224

0

948

250

185

570

275

235

2,954

25MM

TOTAL

8,661 9,483 8,101 10,458 9,993 11,843 8,852 9,259 26,022 21,126 12,131 50,740 8,661 18,145 26,246 36,704 46,697 58,539 67,392 76,650 102,672 123,798 135,929 186,669 372 1,237 3,539 7,410 12,502 17,085 20,546 22,996 26,854 26,375 24,413 0

0

CUMULATIVE

Y1

Y2

Y3

Y4

Y5

DOWN 100BP RATE SCENARIO

>Y5

CML Δ FROM BASE

Cloyd Bank & Trust - Page 13