How to Use Claude for Financial Modeling: 2026 Guide

The single highest-leverage upstream activity is loading the deal context and source documents into a dedicated Claude Project. For a deal review, this typically includes: target company description, last 3 to 5 years of public filings (10-K, 10-Q if recent), recent earnings transcripts, the CIM or pitch deck if applicable, comparable company financials, industry overview documents, your firm's house assumptions (WACC by industry, terminal growth defaults, comparable multiples ranges), and any internal templates for the model and memo. For a public company review, the source documents alone often run 300,000 to 800,000 tokens across multiple files; Claude's per-conversation 200K limit means you load the most-relevant subset for each working session. Save the Project once and inherit context across every conversation. The setup takes 60 to 120 minutes once and pays back inside the first week of an engagement.

Before building any model, get the numbers out of the source documents. Claude's 200K context window comfortably fits a typical 10-K and most CIMs. Ask for specific extractions in structured tables: revenue by segment for the last 3 to 5 years, operating expenses by category (S&M, R&D, G&A), gross margin trajectory, EBITDA margin trajectory, capex as percent of revenue, working capital metrics (DSO, DPO, DIO), debt schedule (tranches, interest rates, maturities, covenants), share count history with dilution detail, deferred revenue movements, lease liability schedule, restructuring charges and other one-time items. Always ask Claude for source page and section references so you can verify. For a public company, this extraction takes 30 to 60 minutes and produces the assumption-page inputs for the model in a verified, citable format. The investment is meaningful: doing this manually for 10 to 20 comparable companies takes 1 to 2 weeks; with Claude it takes a single afternoon.

Skip directly to formulas and you build the wrong model. The discipline: ask Claude to draft the model architecture first (sheet structure, tab names, calculation flow, input vs calculation vs output separation, audit checks, scenario toggles) before any formula work. For a 3-statement model the standard architecture is: Inputs sheet (assumptions and toggles), Historicals sheet (5 years of historical financials), Projections sheet (5 years of projected P&L, balance sheet, cash flow), Schedules sheet (revenue build, working capital, debt, capex, depreciation), Valuation sheet (DCF, comparable companies, comparable transactions), Output sheet (summary tables, charts), Audit sheet (balance check, cash check, integrity tests). Claude proposes the architecture, you approve or adjust, then build sequentially. The architecture step takes 15 to 30 minutes and prevents the 4-to-8 hour rebuild that follows when you discover the architecture is wrong halfway through.

For the actual model build, work in Claude Artifacts so you can iterate on the formulas in place across multiple turns. Build sequentially: revenue model (driver-based, with explicit assumptions for unit volume and price), cost of goods sold and gross margin, operating expenses by category, EBITDA, depreciation and amortization (linking to fixed asset schedule), interest expense (linking to debt schedule), tax expense, net income; then balance sheet items that link from the P&L; then cash flow statement that derives from P&L and balance sheet changes. After each section, paste the historical values back to Claude and verify: do the projection ratios match the historical trends? Are growth rates consistent with management guidance and your house assumptions? Does anything look off vs the comparable companies? Iterate inside the Artifact until the projections pass the smell test, then export to Excel for the actual model.

Once the projection model is built and tied out, layer in the valuation work. For DCF: ask Claude to calculate unlevered free cash flow per year (EBIT * (1 - tax rate) + D&A - capex - change in working capital), discount each year at WACC, calculate terminal value using both Gordon growth and exit multiple methods, sum to enterprise value, bridge to equity value (subtract debt, add cash, subtract non-controlling interests), divide by diluted shares. Build a sensitivity table across WACC (8% to 14%) and terminal growth (1% to 4%) or exit multiple (8x to 14x EBITDA). For comparable company valuation: paste the comparable set with their current trading multiples, ask Claude to apply the median or mean multiple to the target's NTM EBITDA, revenue, or earnings, and present a valuation range. Compare DCF to comps and triangulate to a recommended valuation range with rationale. The valuation work in Artifacts takes 30 to 60 minutes for a clean public company.

A model with one scenario is a forecast pretending to be analysis. Ask Claude to build base, upside, and downside scenarios with explicit assumption deltas (e.g., revenue growth: base 12%, upside 18%, downside 5%; gross margin: base 45%, upside 48%, downside 41%; etc.). For each scenario, present the resulting outputs: revenue trajectory, EBITDA margin path, unlevered free cash flow, valuation range, IRR and MOIC if a deal context. Then stress test: what is the break-even assumption that takes IRR below 15%? What level of revenue growth keeps the company within debt covenants? What does the model look like in a recession scenario (negative growth year, margin compression, working capital strain)? The stress tests surface the assumptions that the deal hinges on; senior partners will ask about these in committee.

Before any model goes to a senior reviewer or investment committee, run a structured audit pass with Claude. Paste the model in formula-view and ask Claude to: (1) flag every hardcoded value in calculation cells (anything that should be assumption-driven), (2) identify formulas that reference cells outside the expected range or sheet (potential broken links), (3) check for circular references (other than intentional iteration loops like interest expense), (4) verify the balance sheet balances every period, (5) verify cash on the balance sheet matches the cash flow statement ending balance, (6) check that the historical period reconciles to the source filings within rounding, (7) flag formula inconsistencies across columns (e.g., column G uses =F5*1.05 but column H uses =G5*0.97 with no rationale), (8) sanity check assumption reasonability (gross margin trajectory, capex as percent of revenue, WC days). The audit takes 15 to 30 minutes and catches 60 to 90% of the errors a human reviewer would find.

Once the model is reviewed and tied out, ask Claude to draft the investment memo and committee materials from the model outputs. The pattern: paste key model outputs (revenue trajectory, EBITDA margin path, FCF profile, valuation range, IRR and MOIC across scenarios, sensitivity tables, key assumptions) plus the deal context and your firm's memo template structure. Claude produces a draft memo that captures the analysis correctly: executive summary, business overview, market and competitive position, financial performance and projections, valuation analysis, returns analysis, key risks, recommendation. You then layer in the qualitative judgment, market color, and proprietary insight that make it your firm's view rather than a generic write-up. For a 10-to-15 page memo, Claude saves 4 to 8 hours of writing time and produces a more structured starting point than a blank page. The memo edit pass takes 2 to 4 hours and is non-negotiable; the qualitative judgment is what the IC is paying for, not the model.