Capital Markets School - Case Study

Cloyd Bank & Trust

Source of Funds Worksheet As of Date: 9/30/2021 DEC-21 MAR-22 JUN-22 SEP-22 DEC-22 MAR-23 JUN-23 SEP-23 TOTAL

MBS / CMO (Gov't) MBS / CMO (Private)

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Municipals

Other Investments

Other Liquid Investments Overnight Investments UST / GSE Bonds BOND PURCHASES MBS / CMO (Gov't) MBS / CMO (Private)

Municipals

Other Investments

Other Liquid Investments Overnight Investments

UST / GSE Bonds

NON-MATURITY DEPOSIT BALANCES DDA

$201,576 $327,440 $95,861

Interest Checking

Core Savings / MMDA Premium Savings / MMDA

$0

Other Secured Non-Maturity Deposits

$38,800

Brokered NMD Retail Repos

$0

$26,929

NON-MATURITY DEPOSITS - NEW BALANCES DDA

$0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0

Interest Checking

Core Savings / MMDA Premium Savings / MMDA

Other Secured Non-Maturity Deposits

Brokered NMD Retail Repos

TIME DEPOSIT - MATURITIES Regular / Local CD

$17,216 $17,230 $7,995 $10,742 $1,515 $1,375

$778

$514 $57,365 $0 $24,908

Jumbo CDs

$8,366 $5,359 $2,653 $6,906

$0 $1,624

Secured Time Deposits Internet / National CD Brokered -1 Way CD

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

$0 $0 $0 $0

Brokered CD

TIME DEPOSIT - EARLY WITHDRAWALS

29

© Darling Consulting Group 2021

12/13/2021 - 2:11 PM