Skip to main content
Investing for Beginners

Financial Modeling: FMVA, DCFs, and AI in Excel with Tim Vipond

43 min episode · 2 min read
·
Financial Modeling,Tim Vipond

Episode

43 min

Read time

2 min

Topics

Career Growth, Investing, Startups

AI-Generated Summary

Key Takeaways

  • FMVA Certification Structure: The Financial Modeling and Valuation Analyst credential covers three standard valuation methods — DCF modeling, comparable company analysis using public multiples, and precedent M&A transactions. Students triangulate all three to form a valuation view. Completion requires 50–100 hours of part-time study, typically spread across six to twelve months.
  • AI Model Auditing with Claude: Uploading CFI's 100-page financial modeling best practices PDF to Claude, then instructing it to audit an Excel model against those guidelines, produced perfect error detection — every deliberately inserted mistake was identified. Individual investors building stock-picking models can replicate this workflow to catch formula and structural errors.
  • DCF for Mining vs. Operating Companies: Mining DCF models follow engineer-produced feasibility studies projecting ore extraction year-by-year, eliminating terminal value entirely. End-of-life environmental liabilities can create negative terminal cash flows. Standard operating company models forecast five to ten years with a terminal value, making the mine model a useful contrast for understanding DCF assumptions.
  • AI Consensus Limitation for Investors: Claude and similar tools default toward consensus views when building forecasts or investment theses. Since outperforming the market requires a nonconsensus perspective grounded in specific industry knowledge, investors should use AI to handle mechanical modeling tasks while retaining independent judgment for the actual thesis and assumptions driving the forecast.
  • Breaking Into Investment Banking: Networking through direct connections at target firms outperforms cold resume submissions unless a candidate holds a top GPA from a recognized institution. Supplementing networking with hands-on work — joining an investment club, building personal financial models, and incorporating that output directly into a resume — creates concrete differentiation in a large applicant pool.

What It Covers

Tim Vipond, cofounder and CEO of Corporate Finance Institute, covers financial modeling fundamentals through the FMVA certification, the three core valuation methods used by analysts, how Claude AI builds and audits Excel models, and strategies for breaking into investment banking and building a content-driven finance education business.

Key Questions Answered

  • FMVA Certification Structure: The Financial Modeling and Valuation Analyst credential covers three standard valuation methods — DCF modeling, comparable company analysis using public multiples, and precedent M&A transactions. Students triangulate all three to form a valuation view. Completion requires 50–100 hours of part-time study, typically spread across six to twelve months.
  • AI Model Auditing with Claude: Uploading CFI's 100-page financial modeling best practices PDF to Claude, then instructing it to audit an Excel model against those guidelines, produced perfect error detection — every deliberately inserted mistake was identified. Individual investors building stock-picking models can replicate this workflow to catch formula and structural errors.
  • DCF for Mining vs. Operating Companies: Mining DCF models follow engineer-produced feasibility studies projecting ore extraction year-by-year, eliminating terminal value entirely. End-of-life environmental liabilities can create negative terminal cash flows. Standard operating company models forecast five to ten years with a terminal value, making the mine model a useful contrast for understanding DCF assumptions.
  • AI Consensus Limitation for Investors: Claude and similar tools default toward consensus views when building forecasts or investment theses. Since outperforming the market requires a nonconsensus perspective grounded in specific industry knowledge, investors should use AI to handle mechanical modeling tasks while retaining independent judgment for the actual thesis and assumptions driving the forecast.
  • Breaking Into Investment Banking: Networking through direct connections at target firms outperforms cold resume submissions unless a candidate holds a top GPA from a recognized institution. Supplementing networking with hands-on work — joining an investment club, building personal financial models, and incorporating that output directly into a resume — creates concrete differentiation in a large applicant pool.

Notable Moment

Vipond demonstrated that Claude, when given Walmart's 10-K and a CFI Excel template, autonomously extracted financials, built a five-year forecast, constructed working capital schedules, and calculated a full DCF — a workflow that previously required hours of manual analyst work.

Know someone who'd find this useful?

Episode Transcript

And I show people how you can use Claude to build a three statement model really quickly, and it's actually, like, shockingly good. And then we also use it for error checking. And, like, I show how you can use Claude in Excel to audit a model, and it perfectly found every single error that we inserted into the model, which was quite awesome. So, yeah, so if you're doing like your own modeling, like your audience is into stock picking and you're building your own model, You could use Cloud and Excel to review your model, give you feedback, find any errors, so on and so on. You're tuned in you're tuned in to the Investing for Beginners podcast investing for beginners podcast, the show for the long term investor. We cut through the noise to focus on what works, compounding, discipline, and the conviction to buy wonderful businesses and stick with them. Your path to financial freedom start now. Welcome to the Messaging for Beginners podcast. Have another great guest for us today. I have Tim Vipon, the cofounder and CEO of CFI. Just a side note, a lot of the ways I've taught myself in the past about different CFA type topics and finance and modeling has been from your website. So I know this will be a very fun conversation. Thanks for joining us, Tim. Yeah. Thanks. My pleasure to be here. Looking forward to it. Awesome. So can we start at the beginning? Like, what gave you the idea to start a website like this? Did you see a pain point, or were you just following your passion? How did that look? Yeah. Great question. There's a few ways to talk about it. But the first is that I'd had a career in corporate finance for over a decade, had worked in investment banking, wealth management, corporate development. So, you know, that was that was my career, if you will, up until the point where I started CFI, but I actually got into it because I wanted to initially work on my public speaking and have had the best way to work on public speaking was to teach a course to a live audience so I went to a local university in Vancouver and taught a financial modeling course and that went well I enjoyed it got good feedback and one thing led to another and I got introduced to my cofounder, which was MDA Training, a professional, like, investment banking classroom training company, and they wanted to start an online offering. And I was working at shoes.com at the time, so my head was in the SEO and, you know, digital marketing space. And we we came together and launched CFI in 2016. So we just had our ten year anniversary this year. And so that that's, like, how it initially got going. And then, of course, there was, like, a whole a whole, big push into SEO and all sorts of other things, …

Get the full transcript (6,537 words) + summary by email — free

One-time email with the complete transcript and AI summary of this episode. No account needed.

One email, no spam. We’ll also show you what SignalCast does.

Browse all Investing for Beginners transcripts →

You just read a 3-minute summary of a 40-minute episode.

Get Investing for Beginners summarized like this every Monday — plus up to 2 more podcasts, free.

Pick Your Podcasts — Free

Keep Reading

Books, tools, and gear mentioned in this episode

SignalCast may earn commission on purchases via these links.

Tools

  • ClaudeRecommended

    by Anthropic

    Uploading CFI's 100-page financial modeling best practices PDF to Claude, then instructing it to audit an Excel model against those guidelines, produced perfect error detection
  • by Microsoft

    Claude, when given Walmart's 10-K and a CFI Excel template, autonomously extracted financials, built a five-year forecast, constructed working capital schedules, and calculated a full DCF

course

  • FMVA CertificationRecommendedBy guest

    by Corporate Finance Institute

    Tim Vipond, cofounder and CEO of Corporate Finance Institute, covers financial modeling fundamentals through the FMVA certification, the three core valuation methods used by analysts

More from Investing for Beginners

We summarize every new episode. Want them in your inbox?

Similar Episodes

Related episodes from other podcasts

Explore Related Topics

This podcast is featured in Best Investing Podcasts (2026) — ranked and reviewed with AI summaries.

Read this week's Investing & Markets Podcast Insights — cross-podcast analysis updated weekly.

You're clearly into Investing for Beginners.

Every Monday, we deliver AI summaries of the latest episodes from Investing for Beginners and 192+ other podcasts. Free for one show.

Start My Monday Digest

No credit card · Unsubscribe anytime