Home/Insights/AI in Finance

NVIDIA's True Value According to Claude AI (Spoiler: It's Wrong)

By Ani BjörkströmPublished 6 July 2026Reviewed 17 November 20267 min video + articleAI in Finance

NVIDIA's True Value According to Claude AI (Spoiler: It's Wrong)
▶ Watch the full 7-minute video · with chapters & transcript

AI IN FINANCE

Can Claude AI in Excel Build a Real DCF Model? A Live Nvidia Test

In short: Claude for Excel built a 5-year DCF model for Nvidia directly inside the workbook, using live formulas linked to the historicals tab and no hardcoded numbers.

Key takeaways

  • Claude for Excel built a 5-year DCF model for Nvidia directly inside the workbook, using live formulas linked to the historicals tab and no hardcoded numbers.
  • Claude's first draft used a 3% terminal growth rate; correcting it to 2.5%, in line with long-run GDP growth, changed the implied value per share.
  • Claude completed roughly 90% of a junior analyst's modeling work, but it still lacked the number sensitivity to judge which assumptions are too aggressive.

Anthropic's Claude for Excel sits inside your own workbook, reads the data on every tab, and writes formulas for you. To test it on realistic work, Ani Björkström, a tech consultant in the Stockholm financial industry, rebuilt the kind of DCF model junior analysts produce at large financial institutions, using Nvidia's public financials as the only input.

What data does Claude for Excel need to start a DCF model?

Claude only needs one tab of historical financials; every other tab can start empty. Because Nvidia is publicly traded, its income statement, balance sheet, and cash flow statement are freely available online and can be copied into a historicals tab, with all values in US$ millions.

In the test, the DCF, assumptions, and earnings tabs were cleaned of all numbers first, so every formula in the finished model was demonstrably generated by Claude.

How do you prompt Claude to build the model?

The first prompt primes the model with a role: "You are a senior equity research analyst working directly inside this Excel workbook," followed by instructions to build a 5-year DCF on the DCF tab, taper Nvidia's growth down each year, and use live formulas with no hardcoded numbers. Crucially, the prompt asks Claude to confirm its understanding and present a plan before touching any cells.

Claude responded with a plan referencing both tabs, noting that Nvidia's growth rate was 65% in the last year while projecting lower growth forward. After a simple "yes, go with it," Claude produced the full model: unlevered free cash flows, valuation, and an implied value per share.

Where did Claude get the assumptions wrong?

Claude initially set the terminal growth rate at 3%, above the roughly 2.5% long-run GDP growth a careful analyst would use as a ceiling. A follow-up prompt challenged the assumptions tab as "too aggressive or unsupported," told Claude to change terminal growth to 2.5%, and asked for the new implied value per share, which Claude recalculated and explained.

Model inputClaude's first passAfter the analyst's challenge
Terminal growth rateClaude proposed 3% terminal growthCorrected to 2.5%, aligned with long-run GDP growth
Revenue growth65% growth in Nvidia's last historical yearGrowth tapered down in each projection year
Share price checkImplied value per share from fundamentalsCompared against Nvidia's market price of 194

Comparing implied value per share with Nvidia's actual market price of 194 turned the exercise into a real valuation question: is the stock overvalued? Claude added the current share price to the assumptions tab and flagged the relevant cells in red and yellow.

Can Claude in Excel replace a junior financial analyst?

The answer is yes and no: Claude did about 90% of the job, but not the judgment. It built the DCF, generated assumptions, and wrote the difficult formulas, yet it needed an experienced analyst to spot that 3% terminal growth exceeds long-run GDP growth. Claude can do the math; the analyst supplies context and skepticism.

FAQ

Does Claude for Excel hardcode numbers into the model?

No, when prompted correctly it uses live formulas linked to the historicals tab, so a changed input flows through the entire DCF.

Should you accept Claude's assumptions as given?

No. Claude proposed 3% terminal growth, above long-run GDP growth of about 2.5%, and only corrected it when challenged in a follow-up prompt.

Want this working inside your finance team?

Ani Björkström

Ani Björkström — founder of QvantX Sweden AB, a Stockholm consultancy building AI solutions for banks, asset managers and finance teams. Anthropic partner. Every article starts from a real client build, minus the confidential parts. LinkedIn →