← Files Institutional Equity AnalystARCHIVED FILE

canonical/modules/M062-balance-sheet-and-liquidity-stress-testing.md

6.78 KB · Oct 3, 2026 · 06:37 UTC

↓ Download file

<!-- Generated loss-aware reference mirror from God_Level_Public_Company_Financial_Analyst_Job_Guide_V6_99_ALL_SUB70_FIXED.docx. Canonical source remains the bundled DOCX. -->

<!-- Module: 062 | Title: Balance Sheet and Liquidity Stress Testing -->

## PART XIII - RISK, PORTFOLIO CONTEXT, AND DECISION MAKING | MODULE 062

# Balance Sheet and Liquidity Stress Testing

> Mission. Stress cash burn, maturities, covenants, refinancing rates, collateral, and working-capital shocks.

## Decision output

Objective: Stress cash burn, maturities, covenants, refinancing rates, collateral, and working-capital shocks. The completed work product must be reproducible from evidence, show the downstream financial or decision effect when material, state the strongest contrary case, and define a dated update rule.

## Explicit operating procedure

1. Start with unrestricted cash and committed availability after borrowing-base/covenant restrictions, then build scheduled debt/lease/other fixed payments by date.

1. Stress revenue, margin, working-capital reversal, capex commitments, restructuring, collateral, interest rates, and refinancing together over the actual risk window.

1. Calculate minimum cash, covenant headroom, fixed-charge/interest coverage, maturity wall, and time to liquidity shortfall under each scenario.

1. Model management responses with timing and feasibility, including capex deferral, asset sales, dividend/buyback suspension, revolver draw, secured financing, equity, waiver, or restructuring.

1. Do not assume refinancing simply because debt is termed out today; specify market access, collateral, pricing, and leverage at the future refinance date.

1. Translate the stress into dilution/recovery and valuation so balance-sheet risk is not represented by an arbitrary multiple haircut.

## Required evidence and model bridge

- Primary-source set: risk register, stress model, correlation/liquidity inputs, decision journal, forecast-error history. Preserve exact document/version, date, period, and source location for every material factual input used in balance sheet and liquidity stress testing.

- For each key concept - all fixed claims, debt maturities, covenant definitions, restricted cash, revolver, working capital - state whether it is a reported fact, analyst calculation, management claim, external estimate, or judgment. Quantitative concepts must retain raw components and units; qualitative concepts must retain the specific evidence and counterevidence.

- Map only economically relevant findings into the model or decision record. Process-control modules such as balance sheet and liquidity stress testing may have no direct valuation line; in that case document the downstream error or governance risk the control prevents.

## Metrics and calculation controls

| Metric / concept | Construction | Required validation |
| --- | --- | --- |
| minimum liquidity | Lowest cash plus committed available liquidity across the stress horizon after required operating cash, maturities, collateral calls, and covenant-driven restrictions. | minimum liquidity: Recalculate from same-scope numerator and denominator; confirm period, units, cohort/geography, and issuer definition; reconcile material differences to filings or operating data. |
| maturity wall | Debt principal and mandatory financing obligations due by period, shown in dollars and as a % of liquidity/normalized FCF. | maturity wall: Tie cash, debt, facilities, maturities, and fixed charges to balance-sheet/footnote data; stress availability restrictions, refinancing assumptions, and downside cash generation. |
| covenant headroom | Distance between forecast covenant metric and covenant limit, expressed in absolute units and % headroom under base and stress cases. | covenant headroom: Tie cash, debt, facilities, maturities, and fixed charges to balance-sheet/footnote data; stress availability restrictions, refinancing assumptions, and downside cash generation. |



## Liquidity stress laboratory

- Stress operating cash generation, working-capital reversal, capex commitments, debt maturities, interest rates, collateral/borrowing base, covenant headroom, and minimum cash simultaneously.

- Show monthly or quarterly headroom until the risk window passes. A company with positive annual FCF can still fail if cash needs occur before receipts or refinancing.

- Identify management actions by timing and realism: capex deferral, asset sales, dividend suspension, revolver draw, equity issuance, covenant amendment, restructuring.

## Worked application

> Case: reported cash looks safe but minimum operating cash and a maturity create a refinancing gap.

- Reconstruct the relevant reported fact from primary evidence before interpreting the case. For balance sheet and liquidity stress testing, show the raw components rather than only the resulting ratio or narrative.

- Build the causal chain through all fixed claims, debt maturities, covenant definitions, restricted cash, then identify which link is directly observed and which link remains an assumption.

- Calculate minimum liquidity, maturity wall, covenant headroom from sourced components under the reported/base interpretation and at least one skeptical alternative interpretation.

- Translate the difference between cases into the variable that matters for balance sheet and liquidity stress testing: evidence quality, revenue, operating profit/NOPAT, free cash flow, invested capital, financing/dilution, risk, or valuation. Mark non-applicable links instead of inventing them.

- Expert consistency test: use debt-document definitions and find the first date action becomes necessary.

- Precommit the specific future filing, KPI, customer/supplier observation, regulator action, or market input that would materially invalidate the balance sheet and liquidity stress testing conclusion.

## Failure tests

- FAIL if all fixed claims cannot be defined and reproduced from the source pack.

- FAIL if stress testing lowers earnings or valuation without modeling cash timing, working capital, mandatory uses, financing availability, covenants, and minimum operating liquidity.

- FAIL if the balance sheet and liquidity stress testing conclusion depends on an unstated assumption, unreconciled definition, or evidence that cannot be traced to its source/version.

- FAIL if evidence materially inconsistent with the balance sheet and liquidity stress testing conclusion is omitted, reclassified, or dismissed without a documented definition, materiality, causal, timing, and source-quality analysis.

## Completion test

A senior reviewer must be able to reproduce the balance sheet and liquidity stress testing conclusion, vary the most sensitive assumption independently, trace the change through the model, understand the strongest opposing case, and identify the next evidence that would force an update. If any link is missing, the module remains open.

SHA-256: 9c1c2f8fa091b5db26f32e4a18be6e2d383ef738aeb89809390944e660ee4a49