Cash Flow Underwriting Example: How Lenders Decide From Statements

A cash flow underwriting example is the clearest way to see how lenders approve loans from a borrower's actual money movement instead of credit score alone. Below is a complete worked example with real numbers: read three months of a small business borrower's bank statements, calculate average monthly deposits and net cash flow, then test that cash flow against the new loan payment to reach a coverage decision. The line-by-line reading of statements is the slow part, which is what cash flow analysis software automates.

This walkthrough uses a US business asking for a working-capital term loan. If you want the concept first, start with what cash flow underwriting is and come back; here we go straight to the numbers a real underwriter would run.

What is cash flow underwriting?

Cash flow underwriting is approving a loan based on the cash a business actually generates, measured from its bank statements and financials, rather than relying mainly on the owner's credit score. The underwriter looks at deposits, the stability of revenue, recurring expenses, existing debt payments and how much net cash is left to service a new loan. It is the dominant method in small business, merchant cash advance and working-capital lending because it reflects real ability to repay; see how cash-flow-based lending works for the wider model.

The borrower in this example

Our borrower is a regional HVAC contractor, an LLC in business four years, asking for a $90,000 working-capital loan repaid over 18 months. The lender requests the three most recent months of business checking statements plus the last filed tax return. For this example we focus on the bank statement read, since that is where cash flow underwriting lives. Here is what the three statements show.

Step 1: Calculate average monthly revenue

Add the three months of deposits and divide by three: $142,000 plus $118,500 plus $155,200 equals $415,700, divided by three is roughly $138,600 in average monthly deposits. But raw deposits are not revenue. The underwriter has to strip out transfers between the owner's own accounts, loan proceeds, refunds and any one-time deposits, because those inflate the number without representing real sales. After removing $11,000 of inter-account transfers across the three months, true average monthly revenue lands near $134,900.

Step 2: Adjust for non-revenue deposits and existing debt

Next the underwriter scans withdrawals for existing loan and advance payments. The statements show recurring ACH debits to two lenders totaling $9,200 per month, which means the borrower already carries debt this new loan sits behind. Spotting those payments also flags whether the business is stacked, that is, carrying multiple short-term advances at once, which is a common decline reason; the same read is how you detect loan stacking from bank statements. In this case two facilities is acceptable, but the $9,200 is a real claim on cash that must be counted.

Step 3: Calculate net operating cash flow

Now build the monthly cash flow. Start from average revenue, subtract average operating outflows for payroll, materials, rent, utilities and existing debt service, and what remains is the cash available for the new loan. Using the borrower's normalized monthly figures:

Step 4: Test cash flow against the new payment

The $90,000 loan over 18 months at the lender's rate carries a payment of about $5,600 per month. The coverage test divides net operating cash flow by the new payment: $13,300 divided by $5,600 is a 2.38x coverage on the new payment in isolation. Lenders also run a global test that includes existing debt: cash flow before existing debt service is $22,500, and total debt service after the new loan is $14,800, giving a global debt service coverage ratio of about 1.52x. Both clear the typical 1.20x to 1.25x minimum, so the cash supports the loan.

Step 5: Read the risk signals, not just the ratio

A passing ratio is necessary but not sufficient. The underwriter still weighs the quality of the cash flow. Here, deposits dipped 17% in Month 2, there was one NSF item, and the business is seasonal. None of those are fatal, but they shape the offer: the lender might size the loan slightly smaller, shorten the term, or require the average daily balance to stay above a floor. This judgment layer is why cash flow underwriting is not a pure formula. The software surfaces the signals; a human sets the terms.

Cash flow underwriting example: the full picture

How to run this example faster

Done by hand, reading three statements, normalizing deposits, isolating existing debt payments and counting NSFs takes an analyst 30 to 60 minutes per file, longer if the statements are scanned PDFs. Cash flow analysis software extracts every transaction, separates real revenue from transfers, totals deposits and withdrawals, flags NSFs and existing loan payments, and computes the coverage ratios automatically, so the underwriter reviews a finished cash flow picture in minutes. For deals underwritten primarily from bank statements, our bank statement analyzer produces the same deposit, balance and NSF read, and for merchant cash advance files our merchant cash advance software adds stacking and holdback analysis.

If your credit memo lives in a spreadsheet, you can convert the borrower's statements to Excel to build the cash flow workpaper by hand, and where the borrower carries property obligations, confirming the numbers against abstracted lease terms keeps the rent line honest. Once the loan is approved, e-sign the loan agreement to close it out.

Frequently asked questions

What is an example of cash flow underwriting?

A simple example: a lender pulls three months of a business's bank statements, calculates $134,900 in average monthly revenue after removing transfers, subtracts $112,400 of operating expenses and $9,200 of existing debt payments to get $13,300 in net monthly cash flow, then divides by the new loan payment to confirm the business can cover it. The loan is approved because cash flow covers total debt by more than the 1.25x minimum.

How do lenders calculate cash flow from bank statements?

Lenders total the deposits across each statement, strip out transfers between the owner's accounts, loan proceeds and refunds to find true revenue, then subtract operating expenses and existing debt payments visible in the withdrawals. What remains is net operating cash flow. They also count NSFs and negative days as liquidity stress signals alongside the raw numbers.

What is a good cash flow coverage ratio?

Most commercial and small business lenders want a debt service coverage ratio of at least 1.20x to 1.25x, meaning cash flow exceeds total debt payments by 20 to 25 percent; see how to calculate the debt service coverage ratio from a borrower's statements. Higher is safer, and seasonal or volatile businesses are often held to a higher bar. A ratio below 1.0x means the business does not generate enough cash to cover its debt, which is usually a decline.

How many months of bank statements do lenders need for cash flow underwriting?

Most cash flow lenders review three to six months of business bank statements, enough to see revenue trend, seasonality and existing debt. Merchant cash advance underwriting often uses three to four months, while bank term loans may ask for six to twelve. The goal is a representative window of real cash movement, not a single strong month. For where this cash flow read sits in the wider file, see the commercial loan underwriting process.