Build a DCF Model with Claude in Excel

Yesterday we built a 5-year DCF model from scratch — assumptions, revenue projections, scenario analysis, sensitivity tables — using nothing but plain English and Claude inside Excel. No formulas typed by hand. In less than 30 minutes. (DCF = Discounted Cash Flow)

We were honored to have in attendance my Corporate Financial Strategy professor from MBA in the room. She said: "That was really interesting. I can see great advantages to professionals in speeding up business plan creation. Would need to be very careful in auditing the output, but if used properly the system has the potential to create a better spreadsheet than an average user. Thanks for a really useful webinar!" - Ruth Bender, Emeritus Professor of Corporate Financial Strategy at Cranfield School of Management

Here is the video recording link: Build a DCF Model with Claude in Excel Video

Here are the slides: Build a DCF Model with Claude in Excel

If you were in the room, this is your reference. If you missed it, this is the next best thing.

Every week, we'll post the slides and resources from our Lightning Lessons here. This is the library. It only grows.

Three more this week:

Wednesday – Turn Scattered Data into an Exec Brief (M365 Copilot)

Thursday – Build a Podcast and a Video (NotebookLM)

Friday – Create a Slide Deck in Minutes (Gamma)

All free. All live. All 3 PM CT. Links are in the Calendar tab.

Welcome to the Savant Society. We build things here.

0 comments