Cash-flow analysis and financial evidence

Normalize before calculating

Classify inflows and outflows before computing a ratio. Internal transfers, loan proceeds, refunds, and customer revenue have different meanings. Repeated movement between accounts can inflate apparent activity without adding economic income.

Use stable transaction identifiers and a documented categorization process. Preserve raw descriptions for restricted review, but expose normalized categories downstream. Record confidence and allow correction. A merchant with unusual payment descriptions should not inherit a poor credit decision merely because a parser has never seen its industry. Validate categories against representative samples and financial records.

A bank feed contains movements of cash, not a ready-made income statement. Transfers between the same owner’s accounts can appear as new receipts. Borrowing can increase cash without increasing sales. A tax payment can make one month look unusually weak even when it reflects an obligation accumulated over several periods. Normalize these items with traceable rules and preserve the original transactions for review.

Missing coverage matters as much as classification. One connected account may exclude the account that pays wages or collects a large share of revenue. The analysis should state which accounts and periods it covers, how complete the data appears, and which conclusions depend on that coverage. A neat ratio calculated from an incomplete feed can be more misleading than an explicitly limited estimate.

Inside the mechanism. Normalize dates, currencies, account scope, and recurring versus exceptional items before calculating ratios. Transfers between a business’s own accounts can inflate apparent revenue if counted as external receipts. Loan proceeds are cash inflows but not ordinary operating sales. Keep the raw transaction and the classification rationale so adjustments can be reviewed. Reconciliation should establish that the normalized view still explains the source balances.

A concrete example. The connected accounts contain sales, owner transfers, debt proceeds, and unusual expenses. A transaction feed is not yet a repayment-capacity measure. The case has $295,000 of exposure. Its stated one-year PD and LGD imply $6,814.50 of expected loss, while the cover analysis leaves $224,000.00 of stress exposure. Monthly cash coverage is 1.36×. These are separate measures: one describes an average under probability assumptions, one describes available cover, and one describes a period’s funding capacity.

When the assumption fails. Transfers among the owner’s accounts are counted as new sales. Classify movements with traceable rules and disclose account and period coverage. The following worked sequence shows the reference condition, a stress condition, and a response condition with explicit synthetic data. These are comparative assumptions, not measured causal effects.

Follow a worked case3 conditions · 36 figures

The connected accounts contain sales, owner transfers, debt proceeds, and unusual expenses. A transaction feed is not yet a repayment-capacity measure.

01Reference conditionBank-feed normalization

02Failure and stressBank-feed normalization

03Controlled responseBank-feed normalization

Normalize before calculating Normalize before calculating — the flow Follow the sequence. Compare with supporting records. Ingest Preserve original references Classify Separate revenue transfers and financing Reconcile Compare with supporting records — Follow the sequence. Compare with supporting records. Chapter sources · Open image

Normalize before calculating Normalize before calculating — the distinction These concepts answer different questions. Read each definition in the context of the section. External revenue Payment from operating activity Internal transfer Movement within the same economic owner — These concepts answer different questions. Read each definition in the context of the section. Chapter sources · Open image

Normalize before calculating Inflow classification Fictional teaching record. No new operating income. Inflow classification Illustrative data; not a real customer record or a prescribed policy. Bank credit 30000 USD Observed movement Source own savings account Internal transfer Revenue contribution 0 USD No new operating income Movement is not new income — Fictional teaching record. No new operating income. Chapter sources · Open image

Normalize before calculating Normalize before calculating — control and failure modes Movement is not new income. The branches show why alternative designs fail. Control design Remove internal transfers from operating revenue. Movement is not new income. Failure mode 1 Count all credits as sales. That can inflate capacity. avoid Failure mode 2 Discard uncertain categories. Unknown items need review or a defined treatment. avoid Failure mode 3 Trust every parser label blindly. Classification errors affect decisions. avoid — Movement is not new income. The branches show why alternative designs fail. Chapter sources · Open image

Read the cash conversion cycle

A business can be profitable while cash is tied up in inventory or receivables. The cash conversion cycle connects inventory days, receivable days, and payable days. In a simplified model, inventory days plus receivable days minus payable days estimates the time cash is tied up.

For 40 inventory days, 30 receivable days, and 20 payable days, the cycle is 50 days. This is a teaching ratio, not a complete forecast. Seasonality, deposits, supplier terms, and uneven sales can change the practical need. Compare the cycle with the proposed financing term and actual cash ladder.

Inside the mechanism. The cash conversion cycle links inventory time, collection time, and supplier payment time. A longer collection interval can consume cash even when reported sales rise. Use compatible periods and definitions when comparing the components. An average can hide a concentrated receivable that will not arrive before a payment is due. Connect the ratio to a dated cash ladder and the actual customer or supplier dependencies.

A concrete example. The business pays suppliers before selling inventory and collecting receivables. A profitable sale can still create a cash gap during that cycle. The case has $625,000 of exposure. Its stated one-year PD and LGD imply $16,500.00 of expected loss, while the cover analysis leaves $442,000.00 of stress exposure. Monthly cash coverage is 1.24×. These are separate measures: one describes an average under probability assumptions, one describes available cover, and one describes a period’s funding capacity.

When the assumption fails. Inventory turns slow while supplier payments remain fixed. Use a time-based cash forecast and explain the cycle components behind the funding need. The following worked sequence shows the reference condition, a stress condition, and a response condition with explicit synthetic data. These are comparative assumptions, not measured causal effects.

Follow a worked case3 conditions · 36 figures

The business pays suppliers before selling inventory and collecting receivables. A profitable sale can still create a cash gap during that cycle.

Inventory and receivable timing: reference condition figure preview

01Reference conditionInventory and receivable timing

Inventory and receivable timing: failure and stress figure preview

02Failure and stressInventory and receivable timing

Inventory and receivable timing: controlled response figure preview

03Controlled responseInventory and receivable timing

Read the cash conversion cycle Read the cash conversion cycle — the flow Follow the sequence. Supplier terms offset part of the wait. Inventory Cash supports goods before sale Receivables Cash waits after sale Payables Supplier terms offset part of the wait — Follow the sequence. Supplier terms offset part of the wait. Chapter sources · Open image

Read the cash conversion cycle Read the cash conversion cycle — the distinction These concepts answer different questions. Read each definition in the context of the section. Accounting profit Income less recognized expenses Cash conversion Timing of usable receipts and payments — These concepts answer different questions. Read each definition in the context of the section. Chapter sources · Open image

Read the cash conversion cycle Cycle example Fictional teaching record. Cycle equals 50 days. Cycle example Illustrative data; not a real customer record or a prescribed policy. Inventory days 40 Time before sale Receivable days 30 Time after sale Payable days 20 Cycle equals 50 days Repayment timing should fit the operating need — Fictional teaching record. Cycle equals 50 days. Chapter sources · Open image

Read the cash conversion cycle Read the cash conversion cycle — control and failure modes Repayment timing should fit the operating need. The branches show why alternative designs fail. Control design Match financing to the cash cycle. Repayment timing should fit the operating need. Failure mode 1 Assume profit means cash today. Recognition and cash timing differ. avoid Failure mode 2 Add payable days. They offset rather than extend the simple cycle. avoid Failure mode 3 Use the ratio as a complete forecast. Uneven flows need a cash schedule. avoid — Repayment timing should fit the operating need. The branches show why alternative designs fail. Chapter sources · Open image

Stress the weak month

An annual average can hide months in which cash cannot cover obligations. Build monthly or weekly views appropriate to the business. Identify low periods, customer concentration, fixed costs, and delayed receipts. Use documented assumptions rather than a single unexplained stress percentage.

A seasonal seller may earn most revenue before holidays and pay suppliers months earlier. Financing that amortizes evenly can create pressure during the low season. Test the proposed schedule against that pattern. A stress case should show the path from changed assumptions to a cash shortfall so the decision can be challenged.

Consider a seasonal seller with strong annual sales and a cash trough before the holiday period. An annual average can imply comfortable debt service while the business cannot meet a payment in its weakest month. Build a simple time-based cash forecast using opening cash, expected receipts, essential payments, and debt service. Then change the assumptions that matter: delayed customer payments, slower stock turnover, or a large supplier deposit. The point is to locate the timing of a shortfall and the available response, not to make one precise forecast appear certain.

Inside the mechanism. A useful stress changes a plausible driver and follows its timing: slower collections, lower sales, higher refunds, or a supplier prepayment requirement. Avoid applying unrelated percentage shocks without explaining their connection. Show opening cash, receipts, necessary uses, debt service, and closing cash for each period. The minimum balance and the first missed obligation often matter more than the final year-end total.

A concrete example. An annual average makes a seasonal merchant look comfortable while one month contains large supplier deposits and weak receipts. Timing is the main risk. The case has $345,000 of exposure. Its stated one-year PD and LGD imply $9,867.00 of expected loss, while the cover analysis leaves $254,000.00 of stress exposure. Monthly cash coverage is 0.93×. These are separate measures: one describes an average under probability assumptions, one describes available cover, and one describes a period’s funding capacity.

When the assumption fails. The peak receivable is delayed beyond the next debt-service date. Locate the weak month and test the specific bridge funding or terms response. The following worked sequence shows the reference condition, a stress condition, and a response condition with explicit synthetic data. These are comparative assumptions, not measured causal effects.

Follow a worked case3 conditions · 36 figures

An annual average makes a seasonal merchant look comfortable while one month contains large supplier deposits and weak receipts. Timing is the main risk.

Seasonal cash trough: reference condition figure preview

01Reference conditionSeasonal cash trough

Seasonal cash trough: failure and stress figure preview

02Failure and stressSeasonal cash trough

Seasonal cash trough: controlled response figure preview

03Controlled responseSeasonal cash trough

Stress the weak month Stress the weak month — the flow Follow the sequence. Trace the impact on obligations. Baseline Build a period-by-period view Shock Change a named assumption Shortfall Trace the impact on obligations — Follow the sequence. Trace the impact on obligations. Chapter sources · Open image

Stress the weak month Stress the weak month — the distinction These concepts answer different questions. Read each definition in the context of the section. Annual average Smooths peaks and troughs Weak-period view Shows when payments may fail — These concepts answer different questions. Read each definition in the context of the section. Chapter sources · Open image

Stress the weak month Seasonal stress Fictional teaching record. Creates 5000 USD gap. Seasonal stress Illustrative data; not a real customer record or a prescribed policy. Normal receipts 50000 USD Monthly baseline Stress receipts 35000 USD 30 percent illustrative reduction Fixed outflows 40000 USD Creates 5000 USD gap Averages can hide a payment shortfall — Fictional teaching record. Creates 5000 USD gap. Chapter sources · Open image

Stress the weak month Stress the weak month — control and failure modes Averages can hide a payment shortfall. The branches show why alternative designs fail. Control design Analyze the weak period and its drivers. Averages can hide a payment shortfall. Failure mode 1 Use only the best sales month. That overstates normal capacity. avoid Failure mode 2 Apply stress without stating assumptions. The result cannot be interpreted. avoid Failure mode 3 Ignore fixed costs. They may remain when revenue falls. avoid — Averages can hide a payment shortfall. The branches show why alternative designs fail. Chapter sources · Open image

Reconcile cash and accounting views

Bank transactions, management accounts, tax records, and financial statements can describe different periods and bases. Reconcile the differences before treating disagreement as deception. Accrual revenue may precede receipt; a loan payment includes principal that is not an ordinary operating expense in an income statement.

Create a bridge between reported earnings and cash available under the underwriting definition. Label non-cash items, working-capital movement, and financing flows. Use consistent periods. A clean bridge does not prove the business is safe, but an unexplained bridge makes the capacity estimate difficult to trust.

Inside the mechanism. Accrual profit, bank cash, and available liquidity describe different things. Recognized revenue may remain uncollected; a cash receipt may be restricted or owed onward. Reconcile the movement from accounting income to cash and identify noncash items, working-capital changes, and financing flows. Then identify restrictions on use. A bank balance alone cannot establish that the business can freely spend every dollar it displays.

A concrete example. The books recognize obligations while bank records show movements of cash. Reconciling both views helps explain working-capital changes and unresolved items. The batch begins with $276,000 of instructions and $264,960.00 of captured value. At the observation cutoff, $7,948.80 remains pending. After the stated refunds, fees, and restrictions, $216,207.36 is available for payout. The unresolved instruction count is 2; an unknown external result is handled separately from a known decline.

When the assumption fails. Accrued revenue is treated as money already available for payout. Link receivables, observed settlement, adjustments, and usable cash at the same cutoff. The following worked sequence shows the reference condition, a stress condition, and a response condition with explicit synthetic data. These are comparative assumptions, not measured causal effects.

Follow a worked case3 conditions · 36 figures

The books recognize obligations while bank records show movements of cash. Reconciling both views helps explain working-capital changes and unresolved items.

Accounting-to-cash reconciliation: reference condition figure preview

01Reference conditionAccounting-to-cash reconciliation

Accounting-to-cash reconciliation: failure and stress figure preview

02Failure and stressAccounting-to-cash reconciliation

Accounting-to-cash reconciliation: controlled response figure preview

03Controlled responseAccounting-to-cash reconciliation

Reconcile cash and accounting views Reconcile cash and accounting views — the flow Follow the sequence. Use the relevant cash measure. Compare Align periods and accounting bases Bridge Explain non-cash and timing items Assess Use the relevant cash measure — Follow the sequence. Use the relevant cash measure. Chapter sources · Open image

Reconcile cash and accounting views Reconcile cash and accounting views — the distinction These concepts answer different questions. Read each definition in the context of the section. Accrual revenue Recognized under accounting rules Bank receipt Cash arrived in the account — These concepts answer different questions. Read each definition in the context of the section. Chapter sources · Open image

Reconcile cash and accounting views Reconciliation bridge Fictional teaching record. Not automatically false reporting. Reconciliation bridge Illustrative data; not a real customer record or a prescribed policy. Invoice December Revenue recognition period Cash received January Bank movement period Difference timing Not automatically false reporting Different records can both be correct — Fictional teaching record. Not automatically false reporting. Chapter sources · Open image

Reconcile cash and accounting views Reconcile cash and accounting views — control and failure modes Different records can both be correct. The branches show why alternative designs fail. Control design Explain basis and period differences. Different records can both be correct. Failure mode 1 Call every mismatch fraud. Timing may explain it. avoid Failure mode 2 Mix quarterly revenue with monthly costs. Periods become inconsistent. avoid Failure mode 3 Treat loan proceeds as earnings. Financing is not operating profit. avoid — Different records can both be correct. The branches show why alternative designs fail. Chapter sources · Open image

Financial records reveal more than repayment capacity. They may expose health, family, location, or other sensitive patterns. Define permitted use, access, retention, and correction. A data connection does not mean every available field should become a model feature.

Track source coverage and outages. An empty feed can mean no activity, a disconnected account, or a provider error. Provide a clear path for customers to supply valid alternative evidence where the product permits it. Keep the distinction between data availability and creditworthiness visible to decision makers.

Inside the mechanism. Financial-data access should have a defined purpose, scope, and permitted use. Preserve source account coverage and connection gaps so an incomplete feed does not masquerade as a complete financial picture. A missing month is not zero revenue. Restrict raw records and use derived features only within their supported meaning. A data refresh can change a decision; retain the earlier snapshot so the customer’s historical treatment remains explainable.

A concrete example. Financial account data is obtained for a stated purpose and period. Later use by another decision process can exceed the original product expectation or approved access. The case identifies 2,542 eligible records from a source population of 4,100. The required workflow completes for 2,466, but 37 completed records miss the illustrative internal target. Another 76 remain incomplete. Communication evidence covers 2,441 generated notices. Scope, completion, timeliness, and delivery are four separate properties of the customer outcome.

When the assumption fails. A broad export is retained after the original underwriting purpose has ended. Keep purpose, access, coverage, retention, and any applicable consent or authorization records explicit. The following worked sequence shows the reference condition, a stress condition, and a response condition with explicit synthetic data. These are comparative assumptions, not measured causal effects.

Follow a worked case3 conditions · 36 figures

Financial account data is obtained for a stated purpose and period. Later use by another decision process can exceed the original product expectation or approved access.

Consented financial data use: reference condition figure preview

01Reference conditionConsented financial data use

Consented financial data use: failure and stress figure preview

02Failure and stressConsented financial data use

Consented financial data use: controlled response figure preview

03Controlled responseConsented financial data use

Chapter connections

This chapter builds on Credit risk and repayment capacity. Continue with Reserves, limits, and payout policy to follow the next part of the system. Use the glossary for terminology and risk mathematics for formulas and worked calculations.

Cash-flow analysis and financial evidence

Normalize before calculating

Read the cash conversion cycle

Stress the weak month

Reconcile cash and accounting views

Use financial data with consent and limits

Chapter connections

Sources