Leveraging the Balance Sheet for Financial Modeling

Introduction

You're building forecasts but missing the parts that actually move cash and break promises, so start with the balance sheet-it's how you make realistic forecasts and spot financing risks early. I'll show which line items matter most: inventory, receivables, payables, PP&E, and debt drive cash, shape valuation, and trigger covenant breaches. Scope: we'll cover short-term working capital (stock, AR, AP), long-term capital needs (capex, debt maturities), and the firm's capital structure (equity vs debt, leverage). Model the balance sheet as the control center linking P&L and cash flow. This approach keeps forecasts realistic and financing risks visible-defintely worth the extra discipline.

Key Takeaways

• The balance sheet is the control center linking P&L and cash-you need it to make realistic forecasts and spot financing risks early.
• Model core items explicitly: cash (sweep/min cushion), AR (DSO/collection curve), inventory (DIO/slow buffers), AP (DPO), PP&E (gross, accum. depr., useful lives), and equity moves.
• Convert AR/AP/inventory to days metrics and use rolling 13‑week views; small changes in days (e.g., +10-20% DSO) can create large near‑term cash needs-stress test them.
• Tie capex to growth vs maintenance, use useful‑life schedules for depreciation, model disposals/impairments, and show cash capex vs non‑cash depreciation in the cash‑flow bridge.
• Build detailed debt schedules and covenant tests (amortization, interest, prepayments), model refinancing and breach costs, and link balance‑sheet flows into valuation scenarios and sensitivities.

Leveraging the Balance Sheet for Financial Modeling

You're building forecasts and need the balance sheet as the control center that links P&L and cash. Here's the short take: model cash, working-capital lines, fixed assets, and equity explicitly - they drive near-term cash needs, valuation, and covenant risk.

One-liner: Model the balance sheet as the control center linking P&L and cash flow.

Cash and Accounts Receivable

Start with the opening cash balance, a defined minimum cushion, and rules for any cash sweep (automatic transfers into debt paydowns or investments). If your model omits a min-cash floor, it will understate financing needs.

Steps to model cash precisely

• Set opening cash from the prior-period balance sheet line.
• Define a minimum cushion: common policy = 1-3% of trailing revenue or a fixed amount; example: $15,000,000 for an FY2025 mid‑market firm.
• Code a cash sweep: excess cash after meeting cushion pays down revolving debt each period.
• Feed monthly/weekly cash receipts and payments into the cash line (link from AR, AP, payroll, capex).

Accounts receivable: convert to days and model the collection curve (how much of AR collects in 0-30, 31-60, 61+ days). Use a weighted collection curve to time cash receipts.

Example FY2025 quick math (illustrative): Revenue $500,000,000, DSO 45 days.

Here's the quick math: AR = Revenue / 365 DSO = $500,000,000 / 365 45 = $61,644,000.

Best practices

• Break AR into buckets (0-30, 31-60, 61-90, >90) and map each bucket to a collection probability.
• Stress-test: a +10% DSO increases AR by ~$6.16m in the example - that's immediate financing need.
• Monitor concentration: top 5 customers >30% of AR increases counterparty risk.

What this estimate hides: seasonality, changing terms, and receivable factoring fees. Adjust the curve for big customer-term renegotiations - they change cash timing more than revenue moves.

One-liner: If AR slips 10%, expect a near-term cash hole equal to the AR increase, not a paper problem.

Inventory and Accounts Payable

Inventory and AP are the main working-capital levers. Convert to days to normalize across growth phases: DIO (days inventory outstanding) and DPO (days payable outstanding).

Steps and calculations

• Calculate COGS from the P&L; derive inventory using DIO: Inventory = COGS / 365 DIO.
• Calculate AP: AP = COGS / 365 DPO.
• Model slow-moving inventory buffers and explicit write-down triggers (age bands: 0-90, 91-180, >180 days).
• Link purchase timing to supplier terms; model early-pay discounts explicitly when material.

Example FY2025 quick math (illustrative): Revenue $500,000,000, gross margin 40%, so COGS = $300,000,000. DIO = 60 days, DPO = 50 days.

Inventory = $300,000,000 / 365 60 = $49,315,000. AP = $300,000,000 / 365 50 = $41,096,000.

Best practices

• Model inventory by bucket (raw, WIP, finished) and tag slow-moving %; reserve at a defined rate - e.g., add a 5% slow-moving buffer to DIO when channel returns rise.
• Encode supplier-term shifts: a move from net-30 to net-45 increases working capital demand by the AP timing delta.
• Use a rolling 13-week view for weekly cash planning and monthly for forecasting - inventory changes drive those weekly swings.

Quick stress example: if DIO rises +15% from 60 to 69 days, inventory increases by ~$7.4m in the example - that's cash tied up until sold or written down.

One-liner: Small changes in DIO or DPO often create the largest near-term cash swings.

Fixed Assets and Equity

Model gross PP&E (property, plant & equipment), accumulated depreciation, useful lives, and planned capex. Treat depreciation as a non-cash P&L line while cash capex appears in the cash-flow statement and reduces opening cash.

Fixed-asset steps

• List gross PP&E by asset class with useful lives (e.g., equipment 5-7 years, buildings 20-40 years).
• Apply depreciation schedules: straight-line is default; include accelerated methods where tax or policy requires.
• Model disposals: remove gross and accumulated depreciation, book gains/losses to the P&L, and include cash from sale.
• Segregate capex into maintenance vs growth; maintenance replaces wear-and-tear, growth ties to revenue assumptions.

Example FY2025 figures (illustrative): Gross PP&E $220,000,000, accumulated depreciation $110,000,000, FY2025 cash capex planned $25,000,000, FY2025 depreciation expense $18,000,000.

Here's the quick math for the cash-flow bridge: change in cash = net income + $18.0m depreciation - $25.0m cash capex +/- working-capital moves.

Equity steps and modeling considerations

• Track diluted share count: basic shares + options/RSUs (use treasury-stock method for options).
• Model new issuance, buybacks, and dividends on the financing and equity sections; show EPS impact explicitly.
• When modeling raises, include transaction fees (e.g., underwriting, legal) and time to close (often 30-90 days for secondary raises).

Example equity math: starting shares 100,000,000, option pool exercise adds 3,000,000 diluted shares, buyback of $20,000,000 at market price $10.00 reduces shares by 2,000,000.

What this estimate hides: impairments (non-cash) can swing equity and covenants; plan triggers (e.g., decline in recoverable amount by >20%) and model them explicitly.

One-liner: Separate cash capex from non-cash depreciation so you can see real funding needs and EVA (economic value added) impacts.

Next step: Finance - produce a monthly fixed-asset rollforward and a diluted share schedule for FY2025 by Friday; include capex split (maintenance/growth) and a 13-week cash sweep rule owner: Finance lead.

Working-capital mechanics and drivers

Convert AR, AP, Inventory into days metrics for trend forecasting

You're tracking raw balances but need days metrics to see pacing and risk. Convert each line to days using the standard formula: days = (balance / periodized flow) × period days. For annual models use 365 days; for monthly use 30 or exact calendar days.

Steps to implement in your model:

• Compute periodized flows: use trailing-12-month (TTM) revenue for AR, COGS for inventory, and TTM purchases or COGS+ΔInventory for AP.

• Calculate DSO = (AR / TTM Revenue) × 365.

• Calculate DIO = (Inventory / TTM COGS) × 365.

• Calculate DPO = (AP / TTM Purchases) × 365.

• Trend the days on a TTM and quarterly basis to filter noise and spot inflection.

Best practices and checks:

• Reconcile days to working-capital % of revenue to validate scale.

• Flag one-off receipts (large AR collections) and exclude from trend if non-recurring.

• Use inventory segmentation: fast-moving vs slow-moving; compute DIO per segment.

• Set governance: monthly review of days by product or customer cohort.

Model seasonality and customer-term shifts with rolling 13-week views

Monthly or annual days masks intra-quarter cash swings. Build a rolling 13-week (quarter) cash and AR/AP schedule to capture seasonality, timing, and customer-term changes.

How to build the 13-week view:

• Start with weekly sales and collections curves derived from historical cash receipts over the last eight quarters.

• Map customer payment profiles: e.g., 40% pay in week 1, 35% in week 2-4, remainder tailing 5-13 weeks.

• Project receipts by convolving projected weekly sales with the collection curve; do the same for payables using supplier payment terms.

• Roll forward: drop the oldest week, add projected week, and re-run to keep the view live.

Practical tips:

• Run variant curves for key customers (enterprise vs SMB) - one-size-curve hides concentration risk.

• Use the 13-week to set temporary financing (e.g., revolver draws) and to justify buffer cash policies.

• Keep a separate weekly bucket for seasonality events (big promotions, tax payments, payroll peaks).

One-liner: Model weekly timing to avoid last-week cash shocks - it's where most short-term surprises live.

Stress test a DSO increase and show cash impact and financing need

Small changes in days can create big cash swings. Here's the quick math using an illustrative FY2025 base case (for modeling practice only): assume FY2025 revenue of $600,000,000 and current DSO of 40 days. Daily sales = $1,643,836 (600M ÷ 365).

Scenario: DSO rises by 10% to 44 days (and a stress case of 20% to 48 days). Incremental AR and cash need:

• Incremental days: 4 days (10%) → incremental AR = 4 × daily sales = 4 × $1,643,836 = $6,575,344.

• Incremental days: 8 days (20%) → incremental AR = 8 × daily sales = 8 × $1,643,836 = $13,150,688.

Translate to financing need:

• If cash buffer target is $25,000,000, a 10% DSO shock reduces buffer by ~$6.6M; a 20% shock reduces it by ~$13.2M.

• If revolver interest is 8% annual, funding $13.15M for 3 months costs ~$261k in interest (13.15M × 8% × 0.25).

Modeling steps and caveats:

• Run the DSO shock across the rolling 13-week cash to see timing - not all incremental AR hits at once.

• Split AR by aging buckets; assume higher default rates in extended tails and include bad-debt expense sensitivity.

• Test combined shocks: DSO + inventory build or DPO compression; combined effects are often nonlinear.

• What this estimate hides: concentration risk (a few customers could create >50% of incremental AR) and credit losses; include counterparty-level scenarios.

One-liner: Small days changes often create the largest near-term cash swings - so stress them first, defintely.

Capex, depreciation, and long-lived assets

You're planning FY2025 capex and need a clear rule set so cash, P&L, and the balance sheet all reconcile and drive decisions. The direct takeaway: split capex into maintenance and growth, use clear useful-life schedules (straight-line or accelerated), and model disposals and impairments explicitly so cash and non-cash flows are visible in the cash-flow bridge.

Tie capex to growth initiatives and maintenance buckets

Lead with priorities: maintenance keeps the base running; growth buys incremental revenue. For FY2025, build two budgets: a maintenance bucket tied to asset replacement rates, and growth projects tied to KPIs (incremental revenue, capacity, or cost takeout).

Steps to do this right:

• List assets by class and age
• Tag each capex item as maintenance or growth
• Estimate life extension or incremental revenue per project
• Assign spend timing by quarter and approval gate
• Set contingency of 5-10% for timing slippage

Practical example for FY2025: assume revenue $500,000,000. Use ~2% of revenue for maintenance = $10,000,000; target growth capex at ~5% = $25,000,000; total capex = $35,000,000. Here's the quick math: maintenance preserves current cash generation, growth capex must show payback within your planning horizon (3-5 years) or be re-scoped.

What this estimate hides: industry norms vary-software firms spend ~3-8% on growth while manufacturing often needs higher one-offs, so adjust by asset intensity and strategy. Defintely track approvals by project to avoid scope creep.

Use useful-life schedules for straight-line and accelerated depreciation

Takeaway: create a per-asset-class depreciation schedule with method and in-service date so depreciation flows match economics and tax/timing realities. That schedule is the engine for non-cash expense in the P&L and for end-of-period net PP&E on the balance sheet.

Concrete steps and best practices:

• Create asset classes: IT, machinery, vehicles, buildings
• Assign useful lives: IT 3-5 yrs, equipment 7-15 yrs, buildings 39 yrs
• Choose method: straight-line (predictable) or accelerated (front-loaded) per class
• Build a schedule: opening gross, additions, disposals, accumulated depreciation, closing net
• Reconcile monthly/quarterly depreciation to general ledger

Example FY2025 entries: add IT servers $6,000,000 (3-year straight-line → depreciation $2,000,000/yr); add machinery $20,000,000 (10-year double-declining → first-year depreciation ~$4,000,000). Sum scheduled depreciation for FY2025 = $18,000,000 (example).

Modeling note: accelerated methods increase near-term non-cash expense and reduce taxable income earlier; straight-line smooths margins. Keep an assumptions tab that shows method, life, and rationale so auditors and lenders can follow.

Model asset disposals, impairment triggers, and show cash‑capex vs non‑cash depreciation in the cash‑flow bridge

Takeaway: explicitly model disposals and impairments so cash proceeds and non-cash losses are visible separately; show cash-capex and depreciation side-by-side in the investing section of your cash-flow bridge.

How to model disposals and impairments:

• Disposal flow: remove gross asset → remove accumulated depreciation → record sale proceeds → compute gain/loss (proceeds - book value)
• Impairment flow: identify trigger → estimate recoverable amount (higher of value-in-use or fair value less costs) → record impairment = carrying - recoverable
• Record tax effect: apply effective tax rate (example 25%) to gains/losses
• Document reasons: obsolescence, cash-flow underperformance, or regulatory change

Example FY2025 cash and P&L impacts:

• Sold equipment: gross $8,000,000, accumulated depreciation $6,000,000 → book value $2,000,000. Proceeds $3,000,000 → gain $1,000,000 pre-tax; cash inflow $3,000,000.
• Impaired asset: carrying value $10,000,000, recoverable value $4,000,000 → impairment loss $6,000,000 (non-cash) → tax impact reduces net loss by $1,500,000 at 25%.

Cash‑flow bridge example (FY2025 example numbers):

• Net income (example): $40,000,000
• Plus depreciation (non-cash): $18,000,000
• Less cash capex: $35,000,000
• Plus proceeds from disposals: $3,000,000
• Less taxes paid on gains (cash): $250,000 (example)
• Net investing cash flow impact = -$14,250,000

Here's the quick math: depreciation adds back $18m (non-cash) while cash-capex subtracts $35m, so your operating-to-investing bridge shows a $17m net cash drag before disposal proceeds and tax effects.

What this hides: timing matters - capex placed in Q4 can create immediate cash strain; disposal proceeds may lag by quarters. Always run a 13-week view with the capex calendar and include a covenant test if cash falls toward minimum cushion.

Next step: Finance - draft the FY2025 capex schedule, depreciation table, and a 13‑week cash bridge showing projected capex timing by Friday.

Capital structure, debt schedules, and covenants

Amortization, interest, and prepayment per facility

You're mapping each credit facility to cash and P&L so you can see timing and optionality - here's how to build that cleanly for the 2025 fiscal year.

Step 1: set a facility header row with these columns: effective date, maturity date, currency, opening principal, scheduled amortization, optional prepayment, spread/margin, base rate, interest type (fixed/floating), fees, and ending principal.

• Model interest as cash line: interest = (opening principal + average balance adjustments) × applicable rate; use actual days for irregular periods.
• Schedule amortization explicitly: e.g., Term Loan A opening $150,000,000 (as of 2025-12-31) with quarterly amortization $12,500,000 until 2028 - show each tranche row.
• Include a revolver: commitment $50,000,000, opening draw $10,000,000, unused fee 0.25% on the undrawn portion - model both drawn interest and commitment fee.
• Add an optional prepayment line per facility so your model can toggle: prepay amount, prepayment fee (e.g., 1.0% if repaid before 2027), and resulting cash impact.

Best practices: keep the schedule granular (monthly for 13-week cash flow; quarterly for annual pro forma), separate cash interest (affects cash flow) from non-cash accruals, and show unused fees and hedging costs as recurring line items so liquidity is accurate.

One-liner: Model each loan like a mini P&L with its own cash and principal movements.

Include covenant tests each period and model refinancing and breach costs

You need covenant logic that runs every period and a breach scenario that shows true economic cost - here's a practical checklist and worked examples anchored to 2025.

Build per-period covenant calculations (monthly if you run a 13-week, else quarterly):

• Compute EBITDA (TTM) with clear add-back rules; mark adjustments you expect lenders to accept.
• Compute Net Debt = Total Debt (short + long) - Cash (use committed cash definition) - show a reconciliation tab.
• Calculate leverage = Net Debt / EBITDA and interest coverage = EBITDA / Cash Interest; include minimum liquidity test (e.g., cash + available revolver > $15,000,000).
• Flag periods where any covenant > threshold; create a boolean violation column and an automatic waiver/amendment cost line.

Example math: TTM EBITDA $120,000,000, Net Debt $360,000,000 → leverage = 3.0x. Cash interest = $24,000,000 → interest coverage = 5.0x.

Stress test: revenue down 15% reduces EBITDA to $90,000,000; if working-capital outflow forces a $18,000,000 revolver draw, Net Debt → $378,000,000, leverage = 4.2x (breach if covenant ≤ 4.0x). What this estimate hides: lenders may use a pro forma or exclude specific one-offs - model both lender and management views.

Model breach economics explicitly:

• Immediate costs: amendment fee $2,000,000, legal $500,000.
• Ongoing costs: margin step-up e.g., +300 bps on outstanding $378,000,000 → incremental annual interest ≈ $11,340,000.
• Liquidity cure: show equity or asset sale required to restore covenant and the dilution or timing impact.

Refinancing scenarios: tee up parallel cases - rollover at current market spread, covenant reset with fee, or partial refinance with new equity. Example: a maturing tranche of $150,000,000 in 2026 refinanced at a tighter spread saving 200 bps, but with issuance fees of 1.5% (upfront cost $2,250,000). Compare NPV of interest savings vs issuance and covenant-cost risks.

One-liner: If you don't model covenant failure costs, you'll understate true financing risk by millions.

Reflect equity changes, dilution from raises, and impact on EPS per share

Equity moves change capital structure and investor metrics - model them as cash and share-count events tied to timing and price.

Practical steps:

• Create an equity schedule: opening shares, new issuance shares, buybacks, option/RSU exercises, and ending shares per period.
• Link net proceeds from equity raises to cash and to net debt (if proceeds pay debt). Show issuance fees separately (e.g., underwriting fee 2.0% of proceeds).
• Model EPS on a pro-forma basis: diluted EPS = Net Income / Diluted shares; show pre- and post-raise EPS and % dilution.

Worked example: existing shares 100,000,000, net income $50,000,000 → EPS = $0.50. Raise equity $200,000,000 at $10/share → new shares = 20,000,000, total shares = 120,000,000, pro-forma EPS = $0.4167 (down 16.7%). If proceeds immediately repay debt and reduce interest by $3,000,000 annually, show pro-forma net income and EPS in a second column; that reveals the true dilution net of financing benefit.

Buyback mechanics: model buybacks as cash use plus share-count reduction; a $50,000,000 repurchase at $10/share retires 5,000,000 shares and reduces outstanding shares - show impact on EPS assuming unchanged net income.

Best practices: stress test raises at different prices (cheap vs. fair), model anti-dilution clauses (if any), and show waterfall of uses for proceeds (capex, debt paydown, liquidity). Also track option pool expansion separately; it can add several percent dilution over time.

One-liner: Cash from equity is simple; the EPS and control economics are where the hard trade-offs live - defintely model both.

Finance: draft 13-week cash view and debt schedule by Friday.

Integrating the balance sheet into valuation and scenarios

You're mapping valuation assumptions into capital needs and risk tests; the balance sheet is the bridge. Here's the short takeaway: link every forecasted cash flow to the balance-sheet line that creates or consumes cash, and treat working capital normalization as a forecasted financing need.

Link balance-sheet flows to free cash flow and terminal assumptions

Start by wiring the core formula: Free Cash Flow (FCF) = NOPAT + Depreciation - CapEx - ΔNet Working Capital (ΔNWC = change in accounts receivable + inventory - accounts payable).

Step: map P&L drivers to balance-sheet balances each period. Tie revenue to AR (days sales outstanding, DSO) and COGS to inventory and AP days. Tie depreciation to the fixed-asset schedule and CapEx to explicit project buckets (growth vs maintenance).

Best practice: normalize working capital in the terminal period rather than forcing last-period balances into perpetuity. Choose a terminal working-capital level expressed in days (for example, target DSO = historical median) and model a one-time adjustment in the final discrete year to move toward that level.

Practical check: reconcile your FCF bridge each year - NOPAT to FCF - so non-cash items (depr) and cash items (CapEx, ΔNWC) net out exactly. If they don't, you've missed a deferred tax, asset sale, or one-off cash item.

Illustrative example (assumptions): Revenue $500,000,000, NOPAT margin 10% → NOPAT $50,000,000; Depreciation $10,000,000; CapEx $15,000,000; ΔNWC +$5,000,000. Here's the quick math: FCF = $50m + $10m - $15m - $5m = $40,000,000. What this estimate hides: terminal value will change materially if you assume a different terminal working-capital days or terminal growth rate.

Run scenario bundles: base, downside (revenue -15%), and recovery (+10%)

Build three scenario bundles as model presets so you can flip assumptions consistently across P&L, balance sheet, and cash flow.

• Base: management plan, historical DSO/DIO/DPO, CapEx tied to revenue growth.
• Downside: revenue -15%, assume DSO +10% (collection stress), DIO +5% (slower turns), delay growth CapEx by one year.
• Recovery: revenue +10% above base, working-capital days improve by 5 days, incremental growth CapEx funded from cash flow.

Steps to implement: create a scenario control table with switches for revenue %, DSO/DIO/DPO shifts, CapEx timing, and debt actions (draw, repay, refinance). Link each balance-sheet line to the scenario switches so ΔNWC and CapEx flows update automatically.

Concrete outputs to compare: annual FCF, cumulative cash burn/raise, debt outstanding, covenant ratios, and terminal value. Run the downside pack and record the incremental external financing need (or covenant breach) in each period - that's the real capital need your valuation implies.

Example effect: with the illustrative base (FCF $40m), a downside -15% revenue shock plus +10% DSO might swing ΔNWC by an added $8-12m in year one, turning a $40m positive FCF into a $30m negative cash position unless financing covers the gap.

Sensitivity matrix: WACC, terminal multiple, and working-capital days

Build a three-way sensitivity to show valuation and cash outcomes across plausible ranges. Use a grid with WACC on one axis, terminal multiple or terminal growth on the second, and create toggles for working-capital days shifts.

Recommended ranges (model-ready): WACC 7%-11%, terminal multiple 8×-14× (or terminal growth 0%-3%), and working-capital day shifts -10 to +20 days. Run the full cross to expose non-linear effects.

How to convert days moves into cash: AR cash = Revenue / 365 × DSO; Inventory cash = COGS / 365 × DIO; AP cash = COGS / 365 × DPO. ΔNWC from a days change = change in each line's days × (Revenue or COGS / 365). Example: a +10-day DSO at $500m revenue produces AR increase ≈ $13.7m (500m/365×10).

Decision use: show investors how sensitive enterprise value and required external funding are to small working-capital swings. If a 5-day DSO deterioration cuts present value by >10%, cash-work should be a board-level risk.

One-liner: The balance sheet turns valuation assumptions into capital needs.

Conclusion: checklist, deliverable, next step

Checklist: map links, create debt covenants sheet, stress-test 13-week cash

You need a short, actionable checklist that maps P&L flows into balance-sheet and cash outcomes so you spot pressure early. One-liner: map first, then move cash.

• Reconcile opening balances - cash, AR, inventory, AP, debt, equity.
• Link revenue to AR via DSO; COGS to inventory via DIO; supplier costs to AP via DPO.
• Build formulas: incremental revenue → incremental AR = annual revenue / 365 DSO change.
• Create a debt-covenants sheet with tests: Net leverage (Net debt/EBITDA), Interest coverage (EBITDA/Interest), and Minimum liquidity.
• Flag thresholds you'll monitor (example thresholds in model): leverage > 3.5x, interest coverage < 3.0x, liquidity < $10m.
• Design 13-week cash stress tests: baseline, DSO +10%, DSO +20%, revenue -15%, delayed supplier payments.
• Run quick math: if FY2025 revenue = $1,200m (monthly = $100m), DSO +10% from 45 to 49.5 days increases AR by ≈ $14.8m; DSO +20% adds ≈ $29.6m. What this hides: concentration, seasonality, and timing of receipts.
• Set escalation triggers: if 13-week cash < 6 weeks of cash burn or covenant breach likely, raise to CFO immediately.

Deliverable: a three-tab model - assumptions, monthly cash, annual pro forma

Build one compact workbook with clear ownership and reconciliation. One-liner: three tabs, one source of truth.

• Assumptions tab - single-source inputs: revenue drivers, monthly DSO/DIO/DPO, capex plan (growth vs maintenance), depreciation lives, debt facility terms, interest rates, covenant thresholds, share count and dilution schedules.
• Monthly cash tab - weekly or monthly cash waterfall for next 13 weeks, then monthly rolling 12-24 months. Include inflows (receipts schedule by AR curve), outflows (payroll, vendors, capex, taxes, debt service), and a cash sweep/minimum cushion rule. Add a scenario toggle (base / -15% rev / recovery +10% / DSO +20%).
• Annual pro forma tab - integrate P&L, balance sheet, cash-flow on annual basis to show long-term covenant paths, equity impacts, and free cash flow. Tie closing cash to the monthly sheet for continuity.
• Built-in checks - recon link rows, a control panel showing: opening cash vs model cash, covenant headroom, and change in net working capital. Use conditional flags for breaches.
• Output files - PDF-ready 13-week summary, covenant schedule, and a one-page capital needs chart showing runway and refinancing needs (months until liquidity breach under stressed scenario).

Next step: Finance - draft 13-week cash view and debt schedule by Friday

Assign clear tasks, deadline, and acceptance criteria. One-liner: Finance owns the short-term view; deliver it by date.

• Owner: Finance lead (name the person). Deliverable due: Friday, December 5, 2025.
• Tasks: produce a weekly 13-week cash forecast, populated from AR aging, AP schedule, payroll, taxes, and confirmed capex. Include per-facility debt amortization, interest, maturity, and optional prepayments in the debt schedule.
• Format: Excel workbook with the three tabs named Assumptions, Monthly Cash (weekly), Annual Pro Forma. Include a one-page dashboard with current cash, worst-case cash at week 13, and covenant headroom.
• Scenarios to run: base, revenue -15%, DSO +10%, DSO +20%, combined downside (rev -15% and DSO +20%). Show required external financing under each scenario and timing of need.
• Acceptance criteria: numbers reconcile to GL; covenant tests computed each week; stress case shows runway in months; ready for CFO review on Monday meeting. If runway < 12 weeks in stress, escalate now.
• Next meeting: Finance presents the workbook and three stress scenarios at the weekly cash review on Monday. Owner: Finance - draft 13-week cash view and debt schedule by Friday, Dec 5, 2025 (defintely bring the GL tie-outs).