Cash flow analysis questions for borrower reviews
1. Am I looking at comparable information, and are there distortions that I need to consider?
Compare the borrower’s current results with the same period last year and with its projections/previous YTD interim statements. Look at revenue, margins, liquidity, and debt. A decline in revenue may warrant different follow-up if margins improved, for example, than if both revenue and margins fell.
Make sure the statements are comparable. Tax returns and internally prepared statements may use different accounting methods. A tax return may reflect tax accounting, while interim statements may follow cash or accrual accounting or include management adjustments. In addition, the quality of the interim statements matters. Using QuickBooks can provide better insights than an Excel spreadsheet, for example. Note those differences before drawing conclusions from a year-over-year comparison.
Annualizing interim results can be a useful tool. However, it can also distort the picture. A contractor may earn most of its revenue during certain months, while a retailer may depend on the holiday season. In our building supplier example, comparing six months of 2026 results with a full year of 2025 would not show whether the business is on track without accounting for its seasonal pattern.
2. Is the business turning its earnings into cash?
A business can report a profit and still face repayment pressure. Customers may be taking longer to pay, or inventory may be absorbing more cash than it did a year ago. That can leave less working capital available for operating costs and debt payments.
For the building supplier, slower collections could explain why revenue appears stable even as its line of credit is more heavily used. Receivables and payables, aging and concentrations, inventory turns, and line-of-credit activity can help clarify what is happening. Ask: “What is taking longer to turn into cash than it did a year ago?”
And speaking of line utilization, don’t forget to review your own data. What has line utilization been? Is it consistent with historical trends? If not, why? What about the operating account? Are average balances consistent with historical trends? If not, (particularly if they are going down), you want to understand why.
The answer can make the cash flow analysis more useful. A temporary delay tied to a few customers may call for different monitoring than a pattern of aging receivables, growing inventory, and repeated borrowing.
3. Does the analysis reflect the borrower’s current debt obligations?
Revisit the debt schedule. Ask about new borrowing, changes in terms (rate, payment, etc.), upcoming maturities, and obligations outside your institution. A lender may need to update information from the borrower’s other creditors to understand total debt service.
Last year’s debt service coverage calculation may no longer describe the borrower’s capacity if earnings or required payments have changed. Recalculate using current information and document the period, repayment sources, and assumptions.
In the supplier’s case, the additional debt could raise required payments, just as slower collections are increasing reliance on its line of credit. Consider those changes together when assessing repayment capacity.
4. Are the adjustments still defensible?
Review expenses previously treated as nonrecurring. Did they disappear, or have similar costs returned? Also, examine owner distributions, capital expenditures, and related-party transactions that may affect cash available for repayment.
Suppose the building supplier’s prior analysis added back a large equipment repair as a one-time expense. If the business has incurred comparable repair costs in each of the past three years, treating the latest one as unusual could overstate the cash available for debt service. Ask what caused the expense and whether similar costs are likely to continue
A nonrecurring adjustment should be supported by information and/or documentation. If it depends on an assumption, explain that assumption in the analysis.
5. What should the findings change about the next review?
Turn the findings into specific follow-up. Depending on the borrower’s risk and complexity, that might mean requesting updated financial statements or a debt schedule, discussing collection delays, monitoring line-of-credit use more closely, or reassessing the relationship in accordance with the institution’s credit policy.
The appropriate depth and frequency of follow-up should reflect the borrower’s circumstances and the institution’s policies. Abrigo’s risk-based approach to annual reviews also discusses tailoring reviews and distinguishing them from underwriting and covenant testing.
A concise review record can capture five points: what changed, why it changed, what it means for repayment, what is being done to reverse the trend, and who will follow up by when.