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

LOAN CASH FLOW (INCL. ESTIMATED PREPAYMENTS) Agricultural $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

Auto

$0

Commercial & Industrial Commercial Real Estate

$8,912 $6,388 $7,940 $10,899 $3,984 $3,654 $3,067 $3,196 $48,040 $30,204 $10,853 $14,220 $15,015 $11,012 $8,550 $9,797 $8,972 $108,623

Construction Home Equity Residential Other Loans LOAN SALES Agricultural

$4,926 $2,666 $2,092 $1,788 $1,104 $1,050

$70

$118

$253

$0

$0 $10,125 $937 $8,534

$971

$889 $1,042

$753

$4,161 $3,060 $2,537 $2,852 $2,916 $2,027 $2,340 $2,154 $22,047

$11,382 $1,930 $1,881 $1,021

$900

$738

$663

$642 $19,157

$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 $0 $0

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

Auto

Commercial & Industrial Commercial Real Estate

Construction Home Equity Residential Other Loans

LOAN ORIGINATIONS Agricultural

Auto

Commercial & Industrial Commercial Real Estate

Construction Home Equity Residential Other Loans

BOND CASH FLOW MBS / CMO (Gov't) MBS / CMO (Private)

$11,969 $10,284 $11,195 $11,419 $10,033 $8,990 $10,226 $10,605 $84,721

$0

$0

$0

$0

$0

$0

$0

$0

$0

Municipals

$1,305 $1,805

$0 $1,305

$745 $2,730

$0 $1,935 $9,825

Other Investments

$125 $245

$278

$121

$270 $744

$117 $250

$263

$113

$255 $1,542 $0 $1,239

Other Liquid Investments Overnight Investments

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

UST / GSE Bonds

BOND SALES

28

© Darling Consulting Group 2021

12/13/2021 - 2:11 PM