Analyzing Balance Sheets and Cash Flows

Introduction

Start with FY2025 totals, then follow the cash - that's the simplest way to link the balance sheet to cash flows when you're judging a company's financial health for investment or management decisions. You're reviewing a company's position, so focus on the FY2025 audited numbers and the three-year trend (FY2023-FY2025) to spot structural shifts in closing cash, net debt, and working capital; map those changes to cash from operations, investing, and financing to see what's repeatable and what's one-off (this will defintely show stress points fast). Actionable start: pull FY2025 audited balance sheet and cash flow statement, compare key line items 2023→2025, and highlight any gaps between reported profit and cash generation.

Key Takeaways

• Start with FY2025 audited closing cash and totals, then "follow the cash" to link the balance sheet to cash flows.
• Compare FY2023-FY2025 to spot structural shifts in closing cash, net debt and working capital, and map those shifts to CFO, investing and financing to isolate one‑offs.
• Reconcile net income to cash from operations (indirect method); flag noncash items and impairments and compute cash‑quality metrics (CFO/Net Income, CFO/Revenue).
• Compute FY2025 key ratios-current ratio, debt‑to‑equity, receivables/inventory days-and verify off‑balance‑sheet and contingent liabilities for hidden risk.
• Produce actionable outputs: FY2025‑backed 13‑week cash forecast, a 3-5 year DCF using FY2025 CFO as baseline, and sensitivity/stress tests on liquidity and margins.

Analyzing Balance Sheets and Cash Flows - start with FY2025 totals, then follow the cash

You're reviewing a company's financial health and need to link the balance sheet to cash flows for an investment or management decision; start by pulling the audited FY2025 balance sheet and the FY2025 cash-flow statement, then map line items to the cash movements. Here's the direct takeaway: extract FY2025 Total assets, Total liabilities, and Shareholders' equity from the audited statements, confirm with the notes, then trace the related cash inflows and outflows on the FY2025 cash‑flow statement.

Read assets: current versus noncurrent and what each tells you

One-liner: current assets tell you near-term liquidity; noncurrent assets show capital intensity and potential impairment risk.

Steps to read and validate FY2025 asset lines

• Open the audited FY2025 balance sheet and note the Cash and cash equivalents line - this is your starting cash balance for a 13-week forecast.
• Locate Accounts receivable (AR) and check notes for allowances and aging; compute receivable days = (AR net / FY2025 revenue) × 365.
• Find Inventory, confirm valuation method (FIFO/LIFO/weighted) in notes, and compute inventory days = (Inventory / COGS) × 365.
• Check Prepaid expenses and other current assets; strip noncash items (deferred costs) when mapping to CFO.
• For noncurrent assets, list Property, plant & equipment (PPE) net, accumulated depreciation, and FY2025 capex in the investing cash flow note.
• Find intangible assets and goodwill; read impairment test notes for FY2025 - an impairment often shows up as a noncash charge that lowers equity but not CFO.

Best practices and checks

• Cross-check cash reported on balance sheet with cash reconciled in FY2025 cash‑flow statement.
• Compare PPE gross to capex spend in FY2025 investing cash flow; large gaps suggest asset sales or disposals.
• Flag sudden increases in goodwill or intangibles - read acquisition notes and financing for how they were paid.

What to extract for your model

• Total current assets (FY2025) - cash, AR (net), inventory, other current.
• Total noncurrent assets (FY2025) - PPE net, goodwill, intangibles, long‑term investments.
• Document any FY2025 adjustments: impairment amounts, fair‑value remeasurements, or asset sales.

Read liabilities: classify current versus long-term and spot funding risk

One-liner: current liabilities reveal funding needs in 12 months; long‑term liabilities show structural leverage and covenant risk.

Steps to read and validate FY2025 liability lines

• Identify Accounts payable (AP) and accruals; compute payable days = (AP / COGS) × 365 to see payment pace in FY2025.
• Locate Short‑term borrowings, the current portion of long‑term debt, and any commercial paper - these are immediate refinancing risks.
• Find Long‑term debt (bonds, bank loans) and read the debt maturity schedule in the notes; list FY2026-FY2028 maturities flagged in FY2025 disclosures.
• Extract lease liabilities under ASC 842 / IFRS 16 - split into current and noncurrent portions; verify right‑of‑use asset link in assets.
• Scan provisions, contingent liabilities, and litigation notes for FY2025; large reserves or newly disclosed contingencies can consume future cash.

Best practices and checks

• Reconcile interest expense in FY2025 income statement to cash interest paid in FY2025 financing cash flows.
• Check covenant footnotes for FY2025 breaches or waivers - covenant violations often trigger immediate liquidity events.
• Convert off‑balance obligations disclosed in notes (operating leases prior to adoption) into present‑value equivalents if needed.

What to extract for your model

• Total current liabilities (FY2025) - AP, short‑term debt, current portion of long‑term debt, other current.
• Total long‑term liabilities (FY2025) - long‑term debt, lease liabilities, deferred tax liabilities, provisions.
• List FY2025 debt maturities, interest rates, and any covenant tests or waivers shown in notes.

Read equity: components, retained earnings movement, and the math check

One-liner: equity reconciles accumulated earnings and transactions; always confirm assets = liabilities + equity for FY2025.

Steps to read and validate FY2025 equity

• Open the FY2025 statement of changes in equity (or notes) and capture Common stock par value, shares issued/repurchased, and Treasury stock activity.
• Record Retained earnings opening balance, FY2025 net income, dividends declared, and other adjusts (prior‑period corrections) to reach FY2025 closing retained earnings.
• Note Accumulated other comprehensive income (OCI) items (FX translation, pension remeasurements) - these affect equity but not CFO.
• Extract Noncontrolling interest if the company has consolidated subsidiaries; confirm how net income attributable to noncontrolling interests flows through the equity reconciliation.

Best practices and checks

• Reconcile FY2025 net income to retained earnings movement; any gap should be explained in the statement of changes in equity or footnotes.
• Verify share count (basic and diluted) at FY2025 year‑end for per‑share metrics; check stock‑based compensation and its noncash impact on equity.
• Use the balance‑sheet identity as a sanity check: Total assets (FY2025) = Total liabilities (FY2025) + Shareholders' equity (FY2025). If not, find the reconciling item in notes.

What to extract for your model

• Common stock and additional paid‑in capital (FY2025)
• Retained earnings (FY2025) - opening, additions (net income), subtractions (dividends), and adjustments.
• Noncontrolling interest (FY2025) and accumulated OCI balances.

Work: Extract these FY2025 totals from the audited statements and place them in a three‑column trend table for FY2023-FY2025 (Total assets; Total liabilities; Shareholders' equity). Use the balance‑sheet identity as a final check and reconcile any differences to the notes - defintely document the footnote references for each line item.

Next step: Finance - pull audited FY2025 balance sheet and FY2025 notes, populate the three‑year (FY2023-FY2025) table for totals, and deliver the workbook by Friday.

Cash-flow statement mapping

Sections: operating (CFO), investing (capex, acquisitions), financing (debt/equity moves)

You're tying the balance sheet to cash flows so you can see where cash actually came from or went in FY2025 - start by isolating the three cash-flow sections on the audited FY2025 statement and label the primary line items.

One-liner: Pull FY2025 cash from operations, cash used in investing, and cash from financing from the audited statement and treat those three totals as your working facts.

Steps to extract and verify

• Open the audited FY2025 cash-flow statement; use the statement labeled Statement of Cash Flows or Consolidated Statement of Cash Flows.
• Identify operating cash flow (CFO) - often shown as Cash Provided by Operating Activities or Net Cash from Operating Activities.
• Identify investing cash flow - typically Cash Used in Investing Activities, with sublines for Purchases of PPE (capex), Proceeds from asset sales, and Acquisitions (business combinations).
• Identify financing cash flow - typically Cash Provided by (Used in) Financing Activities, with sublines for Debt issued/repayments, Dividends paid, Share issuances/repurchases.
• Cross-check each section against the balance-sheet line items at 12/31/FY2025 to confirm entries (e.g., capex vs PPE change, debt proceeds vs long-term debt increase).

Best practices

• Prefer audited numbers from the 10-K or annual report - use the consolidated audited statement.
• Match subtotals to the net change in cash on the balance sheet; if they don't reconcile, flag classification reclassifications or missing restatements.
• Keep a one-line mapping table: FY2025 CFO = X line; Investing = Y line; Financing = Z line (fill with audited values once you have them).

Reconcile net income to CFO (indirect method): adjust for D&A, stock comp, working-capital change

You need to convert accrual net income to cash earnings for FY2025; the indirect method shows adjustments explicitly - follow the audited reconciliation line by line.

One-liner: Start with FY2025 net income, add noncash charges, and subtract increases in working capital to arrive at FY2025 CFO.

Concrete steps

• Record FY2025 net income from the audited income statement.
• Add back depreciation & amortization (D&A) - find the D&A line in the cash-flow statement or footnotes.
• Add back noncash compensation - Stock-based compensation is usually a separate add-back in CFO.
• Adjust for gains/losses that are non-operating (e.g., gain on asset sale) - these reduce net income but are investing cash, so subtract gains or add losses back in CFO.
• Compute working-capital changes: ΔAR, ΔInventory, ΔAP, ΔOther current assets/liabilities between FY2024 and FY2025 balance sheets. Increase in AR or inventory = cash out (subtract); increase in AP = cash in (add).
• Verify with the audited cash-flow reconciliation: the audited CFO subtotal must equal your calculated CFO; any residual should be explained in the footnotes (foreign-exchange effects, reclassifications).

Quick math example (structure only)

• FY2025 CFO = FY2025 Net Income + D&A + Stock comp ± Other noncash + (Decrease in AR) + (Decrease in Inventory) + (Increase in AP) ± Other working-capital changes.

What this estimate hides

• Big FX translation adjustments can mask true cash from operations - check cash-flow footnotes for currency effects.
• Timing issues - significant vendor prepayments or customer deposits create temporary swings; mark them as timing, not recurring performance.

Identify noncash and one-off items in FY2025 (asset sales, impairments) and pull FY2025 section totals

If FY2025 includes large one-offs, they break the link between reported earnings and sustainable cash generation - flag them and restate recurring CFO where useful.

One-liner: Pull the audited FY2025 subtotals and separately list noncash and one-off items so you can adjust FY2025 CFO for a normalized view.

How to identify and classify

• Scan the cash-flow statement for lines like Proceeds from sale of assets, Purchase of businesses, Cash paid for acquisitions - treat large amounts as investing one-offs.
• Find impairment charges, restructuring costs, litigation settlements noted in CFO or footnotes - check whether they were noncash (impairments show up in income but not in CFO) or cash (legal settlement cash outflow appears in CFO or financing/investing depending on nature).
• Flag fair-value remeasurements, mark-to-market gains, and noncash equity-accounted adjustments (joint ventures) - these affect net income but not CFO.
• Check the notes for tax refunds, deferred tax adjustments, or one-time tax benefits in FY2025 - those can inflate CFO temporarily.

Pull these FY2025 audited totals into a short table (replace placeholders with audited values):

• FY2025 Cash from Operations: fill with audited line item value.
• FY2025 Cash used in Investing: fill with audited line item value (show capex and acquisition splits).
• FY2025 Cash from (used in) Financing: fill with audited line item value (show net debt issuance/repayment and buybacks/dividends).

Actionable checks before you trust FY2025 cash subtotals

• Confirm capex in investing equals additions to PPE in footnotes plus capitalized leases; reconcile purchase vs depreciation.
• Verify acquisitions: cash paid should reconcile to changes in goodwill and intangible assets plus purchase price allocation notes.
• Break out financing: separate debt principal repayments from interest paid and from equity transactions (share repurchase vs issuance).
• For each flagged one-off, create an adjusted-CFO line removing the one-off cash impact to estimate recurring cash generation.

Next step I need from you: provide the audited FY2025 cash‑flow statement or tell me where to pull it from (10-K/annual report), and I'll compute the reconciliations, list one‑offs, and produce the normalized FY2025 CFO, investing, and financing totals.

Key ratios and diagnostics (FY2025 focus)

Liquidity - current ratio and how to read FY2025 numbers

You need to verify that Company Name can meet short-term obligations before forecasting growth - start with the FY2025 current ratio.

Step 1: pull FY2025 line items from the audited balance sheet: Current assets (cash and equivalents, short-term investments, receivables, inventory, other current assets) and Current liabilities (accounts payable, short-term debt, current lease liabilities, other current liabilities).

Formula: current ratio = current assets / current liabilities. One-liner: if this is below 1.0, there's immediate liquidity pressure; if above 1.5-2.0, working capital cushion is healthy for most industries.

Practical steps and checks:

• Confirm totals from the FY2025 audited balance sheet line-by-line.
• Exclude restricted cash held for long-term purposes (note disclosure) from current cash.
• Adjust for cash held in disposal groups or discontinued ops.
• Compare to FY2023-FY2025 trend - a falling current ratio signals rising short-term funding needs.

Example (illustrative only): if FY2025 current assets = $4,200m and current liabilities = $2,800m, current ratio = 1.50x. What this hides: concentrated short-term debt maturities or seasonal receivable concentration can make a 1.5x ratio risky.

Solvency - debt-to-equity and assessing long-term leverage

Debt-to-equity shows how much debt funds Company Name relative to shareholders' equity - use FY2025 totals for total debt and shareholders' equity.

Step 1: define total debt for FY2025 as the sum of short-term borrowings, current portion of long-term debt, and long-term debt (include finance leases if material). Step 2: pull shareholders' equity from FY2025 (common stock, additional paid-in capital, retained earnings, accumulated OCI, noncontrolling interest handled per your policy).

Formula: debt-to-equity = total debt / shareholders' equity. One-liner: a higher ratio means more creditor risk and less buffer for shocks.

Practical checks and adjustments:

• Include off-balance-sheet leases if material (discounted lease liability from note disclosures).
• Capitalize operating leases only if accounting treatment hides leverage - convert via note disclosures.
• Adjust for hybrid instruments (convertible debt, perpetuals) per economic substance.
• Compare FY2025 to FY2023-FY2025 trend and to peers in the same industry for context.

Example (illustrative only): FY2025 total debt = $7,500m, shareholders' equity = $15,000m, debt-to-equity = 0.50x. What to watch: if debt is short-term and interest rates rose in FY2025, refinancing risk is higher than the headline ratio suggests.

Efficiency and cash quality - receivables days, inventory days, asset turnover, and CFO ratios

Efficiency ratios show how Company Name turns assets into sales; cash-quality ratios show whether earnings convert to cash in FY2025.

Step-by-step metrics to compute from FY2025 audited statements:

• Receivables days (DSO) = (FY2025 average trade receivables / FY2025 revenue) × 365. Use the average of FY2024 and FY2025 receivables for numerator.
• Inventory days = (FY2025 average inventory / FY2025 COGS) × 365. Use COGS from FY2025 income statement.
• Asset turnover = FY2025 revenue / FY2025 average total assets.
• Cash from operations (CFO) / Net income = FY2025 CFO divided by FY2025 net income - measures earnings quality.
• CFO / Revenue = FY2025 CFO divided by FY2025 revenue - measures cash conversion to top line.

Best practices and red flags:

• Use averages (FY2024-FY2025) for balance-sheet denominators to remove timing noise.
• Investigate rising receivable days - check FY2025 allowance for doubtful accounts and major customer concentration (note disclosures).
• Rising inventory days with steady sales suggests obsolescence risk or demand slowdown.
• Low asset turnover vs peers implies capital inefficiency or overcapitalized assets (check PPE and goodwill).
• CFO / Net income 1.0 suggests high cash quality; below 0.7 flags accrual-driven earnings - dig into working-capital moves.
• CFO / Revenue below industry norms suggests weak cash conversion; check one-offs such as tax refunds or large noncash impairment in FY2025.

Example calculations (illustrative only): FY2025 revenue = $28,000m, average receivables = $2,100m → DSO = (2,100 / 28,000) × 365 = 27 days. FY2025 CFO = $5,600m, net income = $4,200m → CFO / Net income = 1.33x. What this hides: a large FY2025 tax refund counted in CFO can inflate cash quality - always cross-check cash-flow footnotes.

Action: Finance - compute these FY2025 ratios in the workbook, flag items needing note-review, and deliver to stakeholders; defintely include adjustments for material one-offs.

Red flags, adjustments, and cash-quality checks (FY2025 focus)

Spot one-offs in FY2025: asset sales, tax refunds, litigation

You're reviewing FY2025 results and need to separate repeatable cash from one-off items so forecasts don't inherit noise.

One-liner: Start with cash-line items in FY2025, then trace each to the notes.

Concrete steps

• Pull FY2025 cash-flow statement and income-statement footnotes.
• Match large cash inflows/outflows to note descriptions.
• Cross-check gain/loss on sale with PP&E and proceeds in the investing section.
• Reconcile tax refunds to prior-year tax assets and audits.
• Quantify litigation items: recorded reserve and off‑balance note amounts.

How to size and adjust (quick math)

• If FY2025 proceeds from asset sales = $150m, subtract that from FY2025 free cash flow (FCF) when projecting baseline operating FCF.
• If a tax refund in FY2025 = $25m, treat as working-capital timing, not recurring revenue.
• If a litigation settlement paid = $40m but reserves were zeroed in FY2025, book a negative adjustment of $40m to FY2025 cash quality.

Best practices

• Flag any FY2025 cash impact > 1-2% of revenue.
• Document recurrence probability (0-100%) and expected FY impact.
• Produce an adjusted FY2025 CFO excluding one-offs for forecasting.

Watch working-capital swings across FY2023-FY2025

You need to see whether changes in receivables, inventory, and payables are operational or accounting-driven; big swings break cash forecasts fast.

One-liner: Compare changes in working capital to revenue changes - cash moves should track sales growth, not diverge sharply.

Concrete steps

• Compute change in working capital (FY2025 vs FY2024 and FY2023) and express as a percent of FY2025 revenue.
• Calculate days metrics for FY2025: DSO, DIO, DPO using FY2025 balances and 365-day denominator.
• Look for step-changes > +/- 3-5% of revenue or > 15-30 days shift year-over-year.

How to calculate (here's the quick math)

• DSO = (Accounts receivable / Revenue) × 365.
• DIO = (Inventory / COGS) × 365.
• DPO = (Accounts payable / COGS) × 365.
• Working-capital swing % = (ΔWorking capital / FY2025 Revenue) × 100.

Red flags and what they mean

• Rising DSO by > 15 days - collections weakening or lenient credit.
• Inventory days up > 30 days - obsolescence risk or demand falloff.
• Payables falling while inventory and receivables rise - cash-burning operational mismatch.
• Large one-time vendor prepayments or customer deposits in FY2025 - treat separately.

Actions

• Adjust FY2025 CFO for normalized working capital using the 3-year median days.
• If onboarding takes > 14 days for receivables remediation, prepare cash buffer scenarios.

Adjust for aggressive accounting and verify off‑balance-sheet items

You must catch capitalization abuse, fair-value noise, related-party flows, leases, guarantees, and pension holes that hide real leverage.

One-liner: Treat aggressive accounting as a potential cash drain until proven otherwise.

Key checks and steps

• Capitalization vs expense: compare FY2025 capitalized costs (R&D, software) to cash paid and to amortization/impairment in the income statement.
• Depreciation vs capex: if FY2025 capex < FY2025 depreciation for growth assets, verify deferred maintenance risk.
• Fair-value gains: strip noncash fair-value gains from FY2025 net income when assessing CFO quality.
• Related-party transactions: read notes for FY2025, quantify cash transfers, and adjust free cash flow accordingly.
• Leases and guarantees: extract operating/finance lease liabilities under ASC 842 (or IFRS 16) from FY2025 notes.
• Pensions: check FY2025 pension funded status and contribution requirements; unrecognized deficits may be future cash calls.

Quantify off‑balance items (examples)

• If FY2025 disclosed future lease payments = $220m, discount expected cash impact into your 3-5 year forecast or add to net debt for covenant checks.
• If defined-benefit pension deficit = $85m and minimum required contribution = $20m/year, include that in near-term cash needs.
• For guarantees, if the maximum exposure = $300m but expected probability = 10%, treat the expected value = $30m as a contingent liability for stress tests.

Best practices and controls

• Recast FY2025 EBITDA removing noncash fair-value changes and one-off gains.
• Convert operating-lease disclosures into a present-value debt equivalent for leverage ratios.
• Require management to justify capitalization policy changes in FY2025 and document thresholds.
• Build a contingent-liability schedule with probability-weighted cash impacts for scenario modeling.

What this estimate hides: Some items (lawsuits, tax exposures) lack probability - treat them as stress scenarios, not single-point forecasts; defintely document assumptions.

Next step - Finance: pull audited FY2025 balance sheet and cash-flow notes, compute adjusted FY2025 CFO excluding one-offs, and deliver a 13-week cash view and ratio workbook by Friday.

Practical valuation and forecasting steps

Use FY2025 CFO as baseline to build a 3-5 year DCF

You're starting valuation with the audited FY2025 cash from operations (CFO); use that as the operational cash base and convert it to a forecastable free cash flow metric for a 3-5 year DCF.

Steps to convert FY2025 CFO into a DCF baseline:

• Pull FY2025 audited numbers: CFO, net income, interest expense, tax rate, capex, and change in working capital.

• Choose free cash flow definition. Two common choices:

  • FCFF (free cash flow to firm) = EBIT(1-tax) + D&A - capex - ΔNWC. Use when valuing whole firm.

  • FCFE (free cash flow to equity) = CFO - capex + net debt issuances. Use when valuing equity directly.

  
  

• If you only have CFO (indirect method), convert to FCFF by adding back after‑tax interest: FCFF ≈ CFO + interest(1-tax) - capex. Here's the quick math for an example.

• Example: FY2025 CFO = $150m, interest = $10m, tax rate = 21%, capex = $60m.

• Example calc (FCFF) = 150 + 10(1-0.21) - 60 = 150 + 7.9 - 60 = $97.9m. What this estimate hides: one-offs inside CFO (tax refunds, large restructuring cash) and timing differences between accrual profits and cash.

• Project the 3-5 year path: grow revenue by your scenarios, map margins to EBIT, add back D&A (or model D&A as % of PPE), subtract projected capex and ΔNWC each year, then discount by WACC for FCFF or required return for FCFE.

Modeling best practice: lock FY2025 audited line items, flag adjustments, then run base, upside, downside DCFs.

Forecast capex from FY2025 capex-to-sales ratio and maintenance vs growth split

You need capex split into maintenance (replacing wear-and-tear) and growth (capacity, new products). Use FY2025 as the calibration year.

Steps and checks:

• Compute FY2025 capex-to-sales ratio = capex / revenue (use audited FY2025 revenue). This gives a quick rule-of-thumb for projecting capex from revenue.

• Estimate maintenance capex. Quick proxies:

  • Maintenance ≈ FY2025 D&A (if company historically replaces assets at similar rates).

  • If capex >> D&A, split the excess as growth capex: Growth capex = capex - maintenance capex.

  
  

• Project forward: apply maintenance capex as a steady line (or tied to PPE base), apply growth capex as a % of incremental revenue using the FY2025 capex-to-sales or management guidance.

• Example: FY2025 capex = $60m, revenue = $1,200m → capex-to-sales = 5.0%. If D&A = $40m, then maintenance = $40m, growth = $20m.

• Document any one-offs: large acquisition-related capex, asset relocations, or atypical IT spend should be modeled separately, not rolled into steady-state maintenance.

Practical tip: run a sensitivity where maintenance = D&A and another where maintenance = 0.9-1.1×D&A to see valuation sensitivity to replacement assumptions.

Build a 13-week cash forecast starting from the FY2025 year-end cash balance and stress test with sensitivity

You must convert FY2025 year-end cash into a short-term rolling forecast (13 weeks) to manage liquidity; then run scenario tests (revenue ±200bps, margins ±100bps) and defintely stress-test liquidity and working-capital shocks.

13-week build steps:

• Start: use FY2025 year-end cash balance from the audited balance sheet as opening cash.

• Weekly receipts: forecast collections by aging buckets using FY2025 AR days. Map expected receipts from current AR and forecasted weekly sales collections using historical cash conversion patterns.

• Weekly disbursements: payroll, vendor payments (AP days), taxes, interest, scheduled capex, and debt maturities. Include discretionary spends as approval gates.

• Compute weekly net cash flow and run a rolling 13-week cumulative balance. Set triggers: e.g., alert if projected cash < $10m or below 10% of monthly opex.

• Example: FY2025 year-end cash = $80m. If weekly run-rate negative cash flow = $3m, 13-week draw = 39m → projected cash = $41m.

• Stress tests to run immediately:

  • Revenue shock: -200bps (-2 percentage points) change in growth rate over the quarter and +200bps upside case.

  • Margin shock: ±100bps (±1 percentage point) on operating margin; convert to cash using operating cash conversion ratio.

  • Working-capital shock: AR days increase by 10 days → cash tied up = (Δdays/365)FY2025 revenue. Example calc: 10 days on $1,200m revenue → tie-up ≈ $32.9m.

  • One-off events: vendor holdbacks, litigation payment, or tax refunds should be modeled as discrete dated items.

  
  

• Here's the quick math for translating margin/revenue moves to cash: incremental cash ≈ Δrevenue × margin × cash-conversion-rate. Example: baseline revenue $1,200m, margin 10%, cash conversion 80%. A +2% revenue shock = +$24m revenue → incremental cash ≈ 24×0.10×0.80 = $1.92m.

Action: Finance - draft a 13-week cash view using FY2025 year-end cash, run the three stress scenarios, and deliver by Friday. Keep one small buffer line for approvals.

Analyzing Balance Sheets and Cash Flows - Action checklist for close-out

You're reviewing a company's financial health and need to close the loop between the balance sheet and cash flows so you can decide on capital allocation, liquidity actions, or investment moves. Start from the audited FY2025 statements and work backward through the FY2023-FY2025 trend to spot structural shifts.

Action list

Pull the audited FY2025 balance sheet and cash-flow statement first, then run a short, repeatable set of checks that map balance-sheet lines into cash movements.

• Retrieve audited statements: balance sheet, cash-flow, and notes.
• Extract key FY2025 totals: cash, accounts receivable, inventory, PPE, goodwill, total liabilities, and shareholders' equity.
• Compute working-capital change: ΔAR + ΔInventory - ΔAP (FY2025 vs FY2024).
• Reconcile net income to cash from operations: add back D&A, stock comp, impairments; subtract noncash gains.
• Classify investing flows: maintenance vs growth capex; acquisitions; asset disposals.
• Classify financing flows: gross debt issuance, repayments, dividends, share repurchases, equity raises.
• Flag one-offs in FY2025: large asset sales, impairments, tax settlements, litigation receipts/charges.
• Document adjustments in a single workbook tab for audit trail and transparency.

One-liner: Pull audited FY2025 statements, map income → CFO, then label investing and financing flows.

Owner and deliverables

Assign clear ownership, deadlines, and format requirements so the outputs are actionable for treasury, FP&A, and any investor review.

• Owner: Finance (FP&A lead) - assemble source files and build the workbook.
• Deliverables: a) a reconciled worksheet linking balance-sheet deltas to CFO; b) a ratio workbook (liquidity, solvency, efficiency, cash quality); c) a 13-week cash forecast starting from FY2025 year-end cash.
• Format: single Excel with tabs for source, reconciliations, ratios, 13-week cash flow, assumptions log.
• Deadline: deliver the workbook and supporting notes by Friday; include clear sign-off on FY2025 one-offs and any outstanding auditor notes.
• Quality checks: link formulas to source cells, show FY2023-FY2025 trend columns, and annotate adjustments with note references.

One-liner: Finance owns the FY2025-backed workbook and the 13-week cash view - deliver by Friday.

One-liner and immediate next step

Verify the FY2025 cash balance on the audited balance sheet, then use that cash as the starting point for the 13-week forecast and DCF inputs.

• Immediate next step: Finance - confirm audited FY2025 year-end cash and unrestricted cash amount in the notes by EOD today.
• Then: build the 13-week cash using weekly collections (based on FY2025 AR days), disbursements, payroll, tax cash-outs, and committed capex.
• Stress tests: run scenarios -200bps/ +200bps revenue growth and -100bps/+100bps margin shifts; show runway under each.
• Call-outs: defintely call out any restricted cash, collateral, and covenant-triggering balances in the workbook.

One-liner: Verify FY2025 cash first, then build the forecasts.