Blog · Finance metrics and formulas · Finance and FP&A teams
Assess operating financial resilience by comparing liquidity, leverage and cash conversion across reporting periods. Follow a worked statement review with spreadsheet formulas, cash reconciliation and clear owners for the questions it raises.
Financial statement risk assessment compares liquidity, leverage and cash conversion to identify where a company's operating resilience needs review. Start with reconciled statements, calculate the same measures across comparable periods, and trace changes to the underlying schedules. Give each finding an owner and a next check, rather than turning the ratios into an unsupported risk score.
Collect balance sheets, income statements and cash flow statements for the same company scope and currency. Include opening balances, receivables aging, inventory detail and a debt schedule with maturity dates. A monthly financial report layout helps keep the statements aligned.
The SEC's financial statement guide distinguishes the balance sheet's reporting-date snapshot from the income and cash flow statements' period activity. That distinction matters when matching earnings with interest and when calculating average receivables.
Choose the question before selecting measures. Here the question is whether a distributor's short-term resources and operating cash generation have weakened while borrowing has increased. This is an operating review, separate from audit planning or accounting assurance.
The following illustrative US distributor reports in USD. Both comparison years contain 365 days. All sales in the example are credit sales, and the current-asset categories shown are complete.
Put labels in column A, 2025 in B and 2026 in C, with the first data row at row 2:
| Spreadsheet row | Input | 2025 (USD) | 2026 (USD) |
|---|---|---|---|
| 2 | Cash | 400,000 | 250,000 |
| 3 | Closing trade receivables | 1,050,000 | 1,350,000 |
| 4 | Inventory | 650,000 | 900,000 |
| 5 | Current assets | 2,100,000 | 2,500,000 |
| 6 | Current liabilities | 1,200,000 | 1,700,000 |
| 7 | Interest-bearing debt | 1,600,000 | 2,200,000 |
| 8 | Shareholders' equity | 2,800,000 | 2,600,000 |
| 9 | Annual EBIT | 700,000 | 560,000 |
| 10 | Annual interest expense | 140,000 | 200,000 |
| 11 | Annual credit sales | 7,300,000 | 7,300,000 |
| 12 | Opening trade receivables | 750,000 | 1,050,000 |
| 13 | Annual net income | 400,000 | 300,000 |
| 14 | Annual operating cash flow | 300,000 | 100,000 |
Enter these formulas for 2025, then copy across to column C:
Current ratio: =B5/B6
Quick ratio: =(B2+B3)/B6
Debt-to-equity: =B7/B8
Interest coverage: =B9/B10
Average receivables: =(B12+B3)/2
Receivables days: =((B12+B3)/2)/B11*365
Operating cash flow / net income: =B14/B13
Interest coverage here uses EBIT divided by interest expense. Debt means interest-bearing borrowing, and quick assets mean cash plus trade receivables; there are no short-term investments in this example. Document those definitions before comparing the results with another report. See financial risk ratios for the combined interpretation of debt, coverage and liquidity.
| Measure | 2025 result | 2026 result | What changed |
|---|---|---|---|
| Current ratio | 1.75x | 1.47x | Liabilities grew faster than current assets |
| Quick ratio | 1.21x | 0.94x | Less coverage without relying on inventory |
| Debt-to-equity | 0.57x | 0.85x | More borrowing against less equity |
| Interest coverage | 5.00x | 2.80x | Lower EBIT and higher interest expense |
| Average receivables (USD) | 900,000 | 1,200,000 | More sales value remained unpaid |
| Receivables days | 45.0 | 60.0 | Collection timing lengthened |
| Operating cash flow / net income | 75.0% | 33.3% | Less of the reported profit became operating cash |
Ratios are rounded to two decimal places; days and percentages to one. Use unrounded calculations for comparisons. A zero or negative denominator needs a separate explanation, rather than an ordinary positive-ratio interpretation.
The distributor still earns $300,000 in 2026, but operating cash flow is only $100,000. Its supplied indirect-method reconciliation contains these movements, with no other operating adjustments:
| Operating cash bridge | 2025 (USD) | 2026 (USD) |
|---|---|---|
| Net income | 400,000 | 300,000 |
| Add depreciation and amortization | 150,000 | 180,000 |
| Increase in trade receivables | -300,000 | -300,000 |
| Increase in inventory | -100,000 | -250,000 |
| Increase in operating payables and accruals | 150,000 | 170,000 |
| Operating cash flow | 300,000 | 100,000 |
If those five bridge lines occupy B2:B6 on a separate sheet, =SUM(B2:B6) returns the operating cash total. The increase in receivables uses the opening and closing balances already shown. Inventory and payable movements come from the comparative supporting schedules, with noncash changes excluded.
The cash bridge explains the profit-to-cash gap. It does not establish why collections slowed or inventory grew. Ask collections to identify overdue and disputed balances, and ask operations whether the inventory increase supports orders or includes slow-moving stock.
Average receivables rise from $900,000 to $1,200,000 while annual credit sales stay unchanged. Daily credit sales are 7,300,000 / 365 = $20,000; the 15-day increase in receivables days therefore corresponds to $300,000 of additional average receivables. Keep average and closing balances distinct. The days sales outstanding method explains the measurement choices and their limitations.
Use the supplied cash flow statement to prove where closing cash came from:
| 2026 cash reconciliation | Amount (USD) |
|---|---|
| Opening cash | 400,000 |
| Operating cash flow | 100,000 |
| Investing cash flow | -350,000 |
| Financing cash flow | 100,000 |
| Closing cash | 250,000 |
With amounts in B2:B5, =SUM(B2:B5) must equal the closing cash on the balance sheet. Cash falls by $150,000 despite positive financing cash flow. Investigate the timing of investment payments and operating receipts alongside upcoming debt payments; the historical ratio table cannot answer that timing question.
Also tie current assets to cash, receivables and inventory, and debt to the borrowing schedule. Compare the cash flow statement's definition of cash with the balance sheet before declaring a discrepancy. A reconciliation difference remains an unresolved data issue until explained.
The CFA Institute's financial analysis framework emphasizes comparisons and explaining why the numbers changed. Apply that discipline to a short review log: the observed movement, supporting rows, business explanation, responsible owner and next review date.
For this company, collections owns the receivables investigation, operations owns the inventory explanation, treasury owns debt maturities and rates, and the controller owns the statement reconciliations. FP&A connects their explanations to the approved cash plan. A flash report can carry the unresolved items into the next reporting discussion.
Describe these as warning signs requiring investigation. The figures do not establish default likelihood, an audit conclusion or compliance with a loan agreement. Keep contractual calculations separate and use the agreement's definitions.
Upload comparable statements and the receivables, inventory and borrowing schedules that explain their movements. Covirage maps the columns; its tools compute and check the comparisons, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own export.
See FP&A reporting in Covirage for the reporting context.
The operating review here asks whether the company has sufficient financial resilience to support its activities and obligations. An audit risk assessment serves a different purpose: planning work around possible material misstatements. A management review neither replaces an audit nor gives assurance on the statements.
Use comparable balance sheets, income statements and cash flow statements, together with their supporting schedules. Receivables aging, inventory detail and debt maturities explain exposures hidden inside totals. Include the opening balances needed to calculate averages and reconcile cash movements over the period.
Yes. Profit can coexist with declining cash when customers pay later, inventory grows or other payments precede receipts. Compare operating cash flow with earnings and inspect the underlying movements. A cash forecast then shows whether the timing of expected receipts matches scheduled obligations.
Use the company's reporting cadence and refresh the review when a significant operating or financing event changes the picture. Monthly statements often support the recurring review, while cash timing may need closer attention. Keep definitions stable so a new period adds information rather than changing the measurement.