Video Summary — Claude Builds a 3-Statement Financial Model (Tim Vipond) 🚀

Brief overview

• Presenter: Tim Vipond (CFI)
• Goal: Test whether Anthropic’s Claude in Excel can rebuild a fully integrated, dynamic three-statement financial model (income statement, balance sheet, cash flow + supporting schedules) from a template with all forecast formulas removed.
• Result: Success — Claude rebuilt the model (formulas, links, and balancing) quickly and accurately; formatting mostly good with minor tweaks needed.

Step-by-step process demonstrated

1. Install Claude for Excel

   • Search for Claude by Anthropic, download from Microsoft AppSource, install Excel add-in.

2. Prepare file

   • Use a workbook that contains:
     • Historical financials (kept).
     • Forecast section emptied (all formulas removed) — only assumptions remain.

3. Upload file into Claude (Excel)

   • Open Claude pane in Excel → Add files/photos → Select the blank-forecast template.

4. Prompt given

   • Simple prompt used:
     "Use this Excel template from CFI to complete the forecast. You have all the assumptions you need to build the three financial statements linked in Excel."
   • Intentionally minimal to test Claude’s reasoning.

5. Claude’s workflow (observed)

   • Copies/pastes structure and historicals into working workbook.
   • Verifies structure and identifies forecast columns (years 1–5).
   • Inserts formulas across Income Statement first:
     • Revenue = prior period * (1 + growth rate)
     • COGS derived from gross margin (revenue * (1 - gross margin))
   • Builds supporting schedules iteratively:
     • Working capital schedule
     • PP&E schedule
     • Capital structure (debt, equity, dividends, retained earnings)
   • Constructs cash flow statement from supporting schedules.
   • Iterates to resolve dependencies (e.g., interest requires debt schedule).
   • Performs checks and fixes (taxes, dividends from payout ratio, etc.).
   • Achieves a balancing balance sheet and dynamic model (assumption changes propagate).

6. Formatting pass

   • Additional prompt to fix formatting.
   • Claude applied many CFI formatting conventions:
     • Hard-coded historicals colored blue
     • Formulas black
     • Years formatted as “Year X”
     • Percent formats, comma separators, bold headers
   • Minor misses remained (a few cells not shaded/formatted), fixable with brief further prompts.

7. Validation

   • Side-by-side comparison with the original CFI completed model:
     • Assumptions matched.
     • Income statement, balance sheet, cash flow numbers matched (including year-5 net income and ending cash).
     • Supporting schedules matched (working capital, capital structure, retained earnings).
   • Conclusion: Claude rebuilt the entire forecast from scratch in a new workbook using formulas (not copying answers).

Key takeaways / Implications ✅

• Claude (Excel add-in) can:
  • Reconstruct a complex, fully linked three-statement forecast using only assumptions and historicals.
  • Insert accurate formulas and supporting schedules, produce a balanced and dynamic model.
  • Apply formatting consistent with taught templates (mostly automated).
• Limitations:
  • Minor formatting quirks may require short follow-up prompts.
  • Some edge-case fixes needed during iterative review (but Claude handled them when guided).

Practical steps to reproduce (copyable checklist) 🛠️

• Install Claude Excel add-in.
• Prepare workbook: include historicals, remove all forecast formulas, leave forecast assumptions.
• Open Claude in Excel → Upload the file.
• Prompt Claude simply: ask it to complete the forecast using provided assumptions and template.
• Watch progress; optionally:
  • Prompt to format per template rules.
  • Prompt to double-check blue/black formatting of hard-codes vs formulas.
  • Spot-check critical outputs (net income, ending cash, balance sheet balancing).
• Make small manual/formatted adjustments if needed.

Final impression

• Tim calls this a “huge breakthrough”: Claude reliably replicates the CFI method at speed with formula-level precision. Minimal manual polishing required to match final visual formatting. ✨

If you want, I can convert this into a short checklist you can paste into Excel as prompts to run the same test.