Cash Flow Analysis for Small Business Lending: A Practical Guide

Why Cash Flow Is the Most Important Lending Metric

Revenue is vanity, profit is sanity, but cash flow is reality. For small business lenders, cash flow analysis from bank statements provides the truest picture of a business's ability to repay a loan. A business can be profitable on paper — showing strong revenue and positive net income — yet still fail to meet its payment obligations if cash flow timing doesn't align.

Bank statements reveal actual cash flow in real time. Every dollar that enters and exits the account is documented, timestamped, and traceable. No accounting adjustments, no depreciation, no deferred revenue — just real money moving.

Key Cash Flow Metrics to Extract from Bank Statements

Average Monthly Deposits (Gross Revenue)

The total of all business income deposits per month. This represents the business's top-line revenue as actually received — not invoiced. Calculate the average across all months reviewed to smooth out seasonal fluctuations.

Average Monthly Withdrawals (Expenses)

The total of all outgoing payments per month. This includes payroll, rent, supplier payments, loan repayments, and all operational costs. Compare to deposits to assess gross margin.

Net Monthly Cash Flow

Simply deposits minus withdrawals. Consistent positive net cash flow of at least 1.25x the proposed payment amount (1.25 DSCR) is the standard minimum for most business lenders.

Ending Balance Trend

Track the ending balance month over month. A growing ending balance indicates the business is accumulating cash — a positive sign. A declining ending balance suggests the business is spending more than it earns.

Debt Service Coverage Ratio (DSCR) from Bank Statements

DSCR is the ratio of cash available to service debt. Calculate it as:

DSCR = Average Monthly Net Cash Flow ÷ Proposed Monthly Payment

A DSCR of 1.0 means the business earns exactly enough to cover the payment. Most lenders require 1.25-1.5x. A DSCR below 1.0 means the business cannot afford the proposed payment from operations alone.

Example: A business with $20,000 average monthly deposits and $16,000 in expenses has $4,000 net cash flow. A proposed $2,500 monthly payment would yield a DSCR of 1.6 — generally acceptable.

Seasonal Business Considerations

Many small businesses have significant seasonal revenue variation — retailers peak in Q4, landscapers peak in summer, accountants peak in Q1. When analyzing seasonal businesses:

• Request 12+ months of statements to capture full seasonal cycle
• Use annual average rather than recent 3-month average
• Identify the slow season and ensure cash flow remains positive even then
• Consider whether payment timing aligns with revenue peak seasons

Red Flags in Business Cash Flow

These patterns warrant deeper investigation:

• Revenue declining 3+ consecutive months — business may be struggling
• Large sporadic deposits — revenue may be lumpy and unreliable
• Payroll inconsistencies — owners sometimes skip their own payroll when cash is tight
• Supplier payment gaps — late supplier payments can signal cash crunches
• Multiple MCA repayments — business is over-leveraged with expensive debt

Using Bank Statement Analysis Tools

For lenders processing multiple applications per week, manual cash flow analysis becomes a bottleneck. StatementScrub automatically calculates all key cash flow metrics — average monthly deposits, withdrawals, net cash flow, ending balance trends, and DSCR-relevant figures — from any bank statement PDF in seconds. The monthly breakdown table makes seasonal patterns immediately visible.