Cash flow for loan application: what to prepare

Cash flow for a loan application should connect historical operating cash to bank balances and show how existing and proposed debt payments would be covered. Prepare the evidence for the same legal entity and reporting periods, then separate actual results from repayment assumptions.

Confirm the evidence the lender wants

Start with the lender's document checklist and coverage definition. Even within the SBA's business lending program, application contents vary with loan size and the lender's processing method. A company preparing a conventional commercial loan package should also confirm its lender's requirements rather than treating another borrower's checklist as universal.

The finance team should assemble these records before calculating ratios:

Include requested tax returns and explanations for differences from book income. Identify intercompany transactions and restricted cash. A cash balance that belongs to another entity or cannot be used for repayment needs an explicit explanation.

The distinction between historical support and future assumptions also matters for cash-flow lending. This article builds the historical package; it does not turn historical performance into a forecast.

Rebuild operating cash from the underlying schedules

Consider an illustrative Wisconsin industrial distributor preparing its package for the year ended December 31, 2025. Its income statement reports net income of $480,000 and depreciation and amortization of $120,000. Cash taxes and existing interest are already reflected in earnings, with no related accrual changes or other noncash adjustments in this simplified example.

Enter the operating balance schedule in columns A through D, with the first data row at row 2:

Calculate D2 and fill down through D5:

=C2-B2

An increase in receivables or inventory uses cash; an increase in operating payables provides cash relative to reported earnings. Keep financing balances out of this schedule. The working-capital movements explain why income alone cannot establish repayment capacity.

On the same worksheet, build this bridge in columns G and H, starting at row 2:

The bridge is $480,000 + $120,000 - $90,000 - $60,000 + $45,000 + $15,000 = $510,000. In a real export, add every relevant operating adjustment and investigate any difference from the reported cash flow statement.

Prove that the cash movements reconcile

The distributor's bank reconciliation supports closing cash of $510,000. Its investing and financing records provide the remaining movements below. These are actual historical transactions; the proposed loan has not been inserted into them.

On a separate cash-tie worksheet, put the signed opening balance and movements in B2:B7 and reported closing cash in B8. This check must return zero:

=SUM(B2:B7)-B8

The borrowing proceeds explain part of the cash balance; they are not operating earnings. Likewise, principal repayments reduce cash without appearing as an income statement expense. For a fuller statement layout, use the cash flow statement example.

Compare cash generation with both debt schedules

For an illustrative repayment overlay, define cash available before debt service as operating cash flow plus cash interest already deducted, less cash capital spending. All capital spending in this example is maintenance spending. This is a disclosed analytical convention; ask the lender which numerator and adjustments it requires.

The FDIC's commercial and industrial lending examination guidance considers cash flow history, financial statements, projections, and several coverage measures. Its different measures reinforce why a ratio needs a stated definition.

Compare that amount with annual payments supported by the debt schedules:

For this table in A1:D4, calculate D2 as =SUM(B2:C2), fill through D3, and calculate D4 as =SUM(D2:D3). Coverage and remaining cash are:

=480000/D4
=480000-D4

Coverage is 1.33 times, rounded to two decimal places, and remaining cash is $120,000 before distributions. A second route proves the same remainder: $510,000 - $90,000 - $180,000 - $120,000 = $120,000. Existing interest stays inside operating cash on that route, so it is not deducted again.

These results hold historical cash generation constant and add assumed annual payments. They are not a forecast or a contractual covenant test. Put the timing and assumptions in a separate cash flow forecast, particularly when a balloon payment or seasonal cash low falls within the proposed loan term.

Where it goes wrong

• Counting interest twice. Subtracting total debt service from operating cash after interest understates repayment capacity unless interest is added back first.
• Treating bank deposits as revenue. Borrowings and transfers can inflate deposits without increasing operating cash generation.
• Ignoring capital spending and distributions. Free cash flow highlights capital spending, while distributions remain another claim on the cash left over.
• Mixing periods or entities. Annual earnings, partial-year payments, and a related company's cash balance do not form a coherent coverage calculation.
• Presenting assumptions as history. Proposed repayments and management adjustments need separate labels and supporting evidence. Retain the original reported figures alongside them.

Prepare your own cash evidence in Covirage

Bring a sample of your own financial workbook, cash records, and debt schedules to Covirage. Covirage maps the columns, and its tools compute and check the historical cash bridge and your stated repayment comparison; the external AI model explains the result with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your file.

See Covirage for finance teams for the wider financial reporting context.