UCA cash flow: format, calculation and interpretation

UCA cashflow is a lending analysis that converts accrual sales, expenses and balance-sheet changes into cash sources and uses. It shows whether operations generated enough cash for taxes, scheduled debt service and other commitments. Its value is the sequence of cash uses, so define each subtotal before judging repayment capacity.

Start with the borrower exports and a stated convention

Bring the income statement, opening and closing balance sheets, supporting operating-account schedules, debt amortization schedule and bank reconciliation for the same period. Use one borrower scope throughout; exclude intercompany movements only when both sides are eliminated consistently.

The Federal Reserve's commercial-loan examination guidance describes accrual conversion and cautions that traditional earnings-based cash-flow analysis misses receivable, inventory and payable changes. Those changes are often the explanation for a profitable borrower's borrowing request.

UCA is arranged for credit analysis. It does not replace the borrower's US GAAP statement of cash flows. BankersHub's UCA training outline distinguishes operations, cash after debt amortization, distributions, capital expenditures and the financing requirement. Subtotal labels can vary across lender worksheets, so use this explicit convention here:

Cash after operations is before income taxes and interest. Cash available for debt service is after cash income taxes but before interest and principal. Distributions and capital expenditures follow debt service.

This example assumes no leases, acquisitions, foreign-currency movements, asset sales, write-offs or other noncash balance changes. Real schedules must isolate those items before treating balance movements as cash. The related cash flow lending guide explains the wider underwriting decision.

Step 1: identify earnings and other cash uses

Consider an illustrative Ohio distributor for the year ended December 31, 2025. Place these labels in column A and amounts in B, with the header in row 1. All amounts are USD; no rounding is needed for dollar calculations.

The equality between tax expense and taxes paid, and between interest expense and interest paid, is an assumption for this borrower. Replace each with its own cash schedule when accruals differ. Operating expenses exclude both interest and income taxes.

Keep depreciation visible within operating expenses. Removing it twice would overstate cash generation. Cash capital spending comes from payment records, not simply the change in fixed assets.

Step 2: convert working-capital movements into cash

On the same worksheet, put the following labels in A16:A20, opening balances in B and closing balances in C. In D16 enter =C16-B16 and fill down. All balances are operating balances and exclude cash and borrowing.

An operating asset increase consumes cash; an operating liability increase preserves it. Therefore, customer receipts are sales less the receivable increase. Inventory purchases are cost of goods sold plus the inventory increase; payments to inventory suppliers then subtract the payable increase.

Do not put payroll accruals in the inventory-payable adjustment. This example assigns them to operating expenses. That separation prevents the same liability movement from appearing twice.

Step 3: build the cash-flow sequence

Put the following calculation labels in A24:A37 and formulas in B. Positive cash-use amounts are subtracted in the subtotal formulas.

For cash-based debt-service coverage, enter:

=B29/B37

That is 305,000 / 150,000 = 2.03 times, rounded to two decimals. This is the example's cash-based coverage calculation, not a claim about a particular loan covenant. If the numerator starts after interest instead, divide by principal alone: 275,000 / 120,000 = 2.29 times. Label that different measure explicitly; subtracting interest in the numerator and including it again in the denominator mixes conventions.

Step 4: prove the result and read the credit implication

The indirect operating-cash reconciliation must reach the same after-interest, after-tax amount. Net income is 2,400,000 - 1,440,000 - 520,000 - 30,000 - 70,000 = $340,000. Then:

=B2-B3-B4-B6-B7+B5-D16-D17+D18-D19+D20

This returns $275,000, matching B30. It also checks the sign of every working-capital adjustment. The final cash tie is $60,000 opening cash + $35,000 net movement = $95,000 closing cash.

Operations covered scheduled debt service, but capital spending and distributions left a $65,000 funding requirement. New borrowing of $100,000 covered that requirement and added $35,000 to cash. The credit question is whether those investments and distributions are appropriate and repeatable, rather than whether the final bank balance rose.

Review the operating cash flow ratio separately when comparing operating cash with current liabilities. A forward-looking cash flow forecast tests whether next period's collection dates and debt payments create a timing gap that this annual schedule hides.

Where it goes wrong

• Treating every balance change as cash. Write-offs, acquisitions and reclassifications need separate adjustments before converting receivables or inventory.
• Counting interest twice. Pair a before-interest numerator with interest plus principal, or a clearly labeled after-interest numerator with principal alone.
• Using total payables indiscriminately. Capital-expenditure creditors and tax liabilities do not belong in the inventory-supplier adjustment.
• Calling borrowing operating capacity. Financing can close the cash reconciliation while recurring operations remain weak.
• Ignoring contractual definitions. Required amortization, distributions, leases and balloon payments may be treated differently in the executed credit agreement.

Check your borrower schedule in Covirage

Upload a sample of your own borrower statements, operating-account schedules and debt-service workbook to Covirage, which maps the columns. Covirage's tools compute and check the movements and cash reconciliation; the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring the convention your credit team uses.

See Covirage for commercial banking for the supporting industry context.