canonical/modules/M045-balance-sheet-and-cash-flow-forecasting.md

<!-- 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: 045 | Title: Balance Sheet and Cash Flow Forecasting -->

## PART IX - MODEL BUILDING | MODULE 045

# Balance Sheet and Cash Flow Forecasting

> Mission. Forecast working capital, capex, financing, share count, and cash without circular mistakes.

## Decision output

Objective: Forecast working capital, capex, financing, share count, and cash without circular mistakes. 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. Forecast receivables, inventory, payables, deferred revenue, and other operating balances from driver days/turns or contract mechanics; do not use cash as a plug.

1. Roll PP&E and intangibles from beginning balances through capex/acquisitions, depreciation/amortization, disposals, FX, and impairments.

1. Build a debt schedule by instrument with maturity, rate/floating benchmark, amortization, revolver, covenants, and refinancing assumption; link interest to average balances and rates.

1. Forecast cash taxes, dividends, repurchases/issuance, SBC dilution, leases/debt-like commitments, and acquisition consideration explicitly when material.

1. Let ending cash emerge from integrated operating/investing/financing flows, then trigger revolver/equity/other financing only under an explicit minimum-cash policy.

1. Require balance sheet balance and cash roll-forward in every scenario, including stress.

## Required evidence and model bridge

- Primary-source set: normalized historicals, KPI bridges, driver assumptions, debt/share schedules, source notes. Preserve exact document/version, date, period, and source location for every material factual input used in balance sheet and cash flow forecasting.

- For each key concept - working capital, PP&E, depreciation, debt, rates, cash taxes - 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 cash flow forecasting 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 cash headroom | Lowest forecast unrestricted cash plus committed undrawn liquidity minus minimum operating cash requirement across the modeled horizon. | minimum cash headroom: Recalculate from same-scope numerator and denominator; confirm period, units, cohort/geography, and issuer definition; reconcile material differences to filings or operating data. |
| net leverage | Net leverage = net debt / normalized EBITDA, with leases and other debt-like items treated consistently | net leverage: Recalculate net leverage from cited inputs; reconcile definition, period, units, signs, and source version; investigate and document any variance before use. |
| FCF conversion | Free cash flow divided by the relevant earnings base, typically net income, EBIT, or EBITDA; define consistently and reconcile every adjustment. | FCF conversion: Tie the dollar measure to filed statements/footnotes; reconcile classification adjustments, one-time items, acquisitions/FX, and period consistency before using it analytically. |



## Integrated forecast laboratory

- Forecast working-capital balances from operating drivers, PP&E from beginning balance plus capex less depreciation/disposals, debt from contractual maturities and financing needs, and shares from awards/issuance/repurchases.

- Interest expense should be linked to average debt and rates; cash interest income to average cash and yields; taxes to taxable economics; cash should be the residual output of integrated statements, not a plug.

- Use a revolver or explicit financing decision only when cash would fall below a defined minimum. The model must explain how the company survives a stress case.

## Worked application

> Case: positive EBITDA company runs out of cash because working capital and maturities consume liquidity.

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

- Build the causal chain through working capital, PP&E, depreciation, debt, then identify which link is directly observed and which link remains an assumption.

- Calculate minimum cash headroom, net leverage, FCF conversion 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 cash flow forecasting: 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: cash is an output of the integrated model, not a plug that makes the balance sheet balance.

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

## Failure tests

- FAIL if working capital cannot be defined and reproduced from the source pack.

- FAIL if forecast cash, working capital, PP&E, debt, taxes, and equity do not roll from operating assumptions and the statements require a balancing plug.

- FAIL if the balance sheet and cash flow forecasting 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 cash flow forecasting 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 cash flow forecasting 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.