Bank Analysis School eBook

Example Cash Flow Projection Format

Basic Methodology: Expected cash outflows and inflows are projected over various time horizons. If regular cash inflows are insufficient to fund expected outflows, liquid assets and/or borrowings will be utilized to cover the shortfall. Management should be using these types of projections to identify funding shortfalls and develop appropriate funding strategies.

0-30 Days 31-90 Days 4-6 months 6-12 months

Expected Cash Outflows: *New Loans/Drawdowns New Investments Deposit Maturities and *Withdrawals Maturing Borrowings (E.g. FHLB) Total Periodic Outflows Expected Cash Inflows: Fed Funds Sold *New Deposit Growth Asset Maturities/Payments/*Prepayments Total Periodic Inflows Periodic Net Cash Inflow/(Outflow) Cumulative Net Cash Inflow/(Outflow)

0

0

0

0

0

0

0

0

0 0

0 0

0 0

0 0

Available Liquid Assets: Cash and Due/Excess Reserves Unpledged Liquid Investments Total Liquid Assets External Funding Sources: Lines of Credit FHLB Brokered Deposits (Internal Limit) Internet Deposits (Internal Limit) FRB Discount Window Total Borrowing Availability

0

0

0

0

0

0

0

0

*Asterick indicates critical assumptions which should be supported.