I built a 5-Year DCF in 20 Minutes | Claude Opus 4.6 Financial Modeling

Can AI actually handle complex finance? I built a professional 5-year DCF model in just 20 minutes using Claude Opus 4.6. This is the ultimate workflow for financial modeling with Claude (I’d recommend this for FP&A, startups, and consulting.) A few years ago, tools like GPT, Gemini, and Claude were terrible at building financial models. Broken formulas, missing references, and Excel sheets that made zero sense. As a financial analyst in Switzerland, I tested them repeatedly and honestly gave up. But things have changed… REALLY changed. In this video, I show you how to build a full DCF financial model using Claude Opus 4.6 — including: 5-year projections Income Statement Balance Sheet Cash Flow Statement Assumptions (aka Command Center) DCF valuation Investor equity calculations We build a model for a fictional startup, step-by-step, and test whether the outputs are actually usable for investors, banks, or internal planning. If you work in finance, startups, consulting, or FP&A, this workflow can save you hours of modeling work. This is how to build a financial model with Claude (Opus 4.6) ⏱️ Timestamps 0:00 Intro – AI Financial Modelling Bugs 0:37 The AI Model That Actually Works (Claude Opus 4.6) 1:23 Creating the Project & Example Company 3:44 The Right Way to Prompt This Financial Model 11:54 Generating the Assumptions aka. The Command Center 15:25 Building the Financial Statements 22:03 Reviewing the Full DCF Model & Final Checks Drop a comment, ask a question and let’s discuss!