AI for Three-Statement Models: Build Integrated Financials with Claude

Three-Statement Models and AI

The three-statement model — linking the income statement, balance sheet, and cash flow statement into one integrated framework — is the foundation of financial modeling. It takes 5-8 hours to build manually from scratch. Claude with ClaudeFinLab walks through each layer conversationally, checks the model's balance, and handles the circular reference between the revolver and interest expense.

Income Statement Projection

• "Build a 5-year income statement for this industrial company. Historical: Year 0 revenue $485M, COGS 62% of revenue, gross profit $184.3M (38% margin), SG&A $68M (14%), R&D $24M (5%), D&A $28M (5.8%), EBIT $64.3M, interest expense $18.4M, tax rate 24%, net income $34.9M. Project years 1-5: revenue CAGR 6%, gross margin expands 50bps/year, SG&A grows 3%/year (operating leverage), R&D stays 5% of revenue, D&A 5.5% of revenue."
• "Separate the income statement into segments: (1) Products segment — $310M revenue, 42% gross margin; (2) Services segment — $175M revenue, 28% gross margin. Blended gross margin check: ($310M × 42% + $175M × 28%) / $485M = 36.9% (not matching 38% — identify the reconciling item)."
• "Model the interest expense line with circular reference: the company has a $75M revolver at SOFR+175bps. Cash available = net income + D&A − capex − working capital change. If cash goes negative, draw the revolver (which increases interest expense, which decreases net income, which decreases available cash). Resolve the circular reference iteratively."

Balance Sheet Projection

• "Project the balance sheet using these drivers: Accounts receivable: 45 days of revenue (DSO). Inventory: 60 days of COGS (DIO). Accounts payable: 42 days of COGS (DPO). Net PP&E: prior year + capex − D&A. Long-term debt: prior year − mandatory amortization + new borrowings. Retained earnings: prior year + net income − dividends ($12M/year). Build years 1-3."
• "Balance check: after projecting all balance sheet line items, does the model balance (assets = liabilities + equity)? If it doesn't, identify the balancing plug. In most models, the revolver (on the liability side) or cash (on the asset side) is the plug. Which is correct and why?"
• "Model goodwill impairment sensitivity: the company has $84M of goodwill from a 2022 acquisition. Reporting unit fair value: $240M vs carrying value $195M (headroom 23%). If fair value declines 25% (to $180M), triggering a $15M impairment charge — how does the impairment flow through the three statements? (P&L charge, balance sheet write-down, non-cash addback in operating cash flows)"

Cash Flow Statement (Indirect Method)

• "Build the cash flow from operations using the indirect method: start with net income, add back non-cash items (D&A $28M, stock-based comp $8.4M, goodwill impairment $0), then adjust for working capital changes (increase in AR is a use of cash, increase in inventory is a use, increase in AP is a source). Show the working capital bridge and CFFO total."
• "Compute free cash flow: CFFO $78.4M, capex ($42M) = FCF $36.4M. FCF yield: FCF / market cap ($1.2B equity value) = 3.0%. FCF conversion: FCF / net income = $36.4M / $46.8M = 77.8%. How does this compare to FCF conversion benchmarks for industrial companies (typically 75-90%)?"
• "Model the financing cash flows: new debt drawn $0, debt repayment ($24M TL amortization), dividends paid ($12M), share repurchases ($20M, bought at $18/share — how many shares retired?). Total financing outflow. Cross-check: CFFO + CFI (capex) + CFF = change in cash. Does it balance with the balance sheet cash movement?"

Working Capital Deep Dive

• "Analyze working capital efficiency: Year 0 DSO 45 days, DIO 60 days, DPO 42 days. Cash Conversion Cycle = DSO + DIO − DPO = 63 days. If the company reduces CCC to 55 days through supply chain improvements, compute the one-time cash release and the ongoing working capital requirement reduction at $485M revenue."
• "Stress test working capital: if a recession causes customers to stretch payment terms by 15 days (DSO: 45 → 60) while inventory builds 10 days (DIO: 60 → 70), compute the cash impact on a $485M revenue base. How much additional revolver capacity is needed to fund the working capital increase?"

Sensitivity Analysis and Scenarios

• "Run a two-way sensitivity table on EBIT margin vs revenue growth: rows = revenue CAGR (2%, 4%, 6%, 8%, 10%), columns = EBIT margin in year 5 (8%, 10%, 12%, 14%, 16%). Show the implied year 5 EBIT for each combination. Which scenario gives EBIT > $100M?"
• "Build 3 scenarios (bear, base, bull) with different revenue and margin assumptions. For each: compute 5-year cumulative FCF, ending net debt position, and net debt / EBITDA ratio. Which scenarios result in the company being net cash by year 5?"

Model Integrity Checks

• "Audit this three-statement model for common errors: (1) Check balance: total assets = total liabilities + equity at each year-end. (2) Check cash flow: net change in cash per CFS = ending cash per BS − beginning cash. (3) Check interest expense: interest = average debt balance × interest rate. (4) Check tax: tax expense = EBT × effective tax rate. Flag any discrepancies."

Related Articles

• AI DCF Model
• LBO Modeling AI
• Financial Modeling Guide