BAS Presentations - March 2023
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.
Made with FlippingBook Digital Publishing Software