Financial Modeling: FMVA, DCFs, and AI in Excel with 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.
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.
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 — FreeKeep Reading
More from Investing for Beginners
How to Get 9% Returns with Half the Market Volatility
Aug 31 · 39 min
BiggerPockets Real Estate Podcast
The Financial Freedom "Stack": Start with No Rentals, Retire Decades Early
Mar 11
More from Investing for Beginners
Dissecting Capital One, Netflix, and Wall Street's Favorite Metrics
Aug 27 · 49 min
Venture Stories
Recall Sessions: Itai Damti on Embedded Finance and the Art of Getting Your First Customer
Feb 23
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
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?
How to Get 9% Returns with Half the Market Volatility
Dissecting Capital One, Netflix, and Wall Street's Favorite Metrics
AAR64 - The Personal Finance Time Machine
AI, Space, and Defense: Separating Hype from True Moats
The Psychology of Position Sizing
Similar Episodes
Related episodes from other podcasts
BiggerPockets Real Estate Podcast
Mar 11
The Financial Freedom "Stack": Start with No Rentals, Retire Decades Early
Venture Stories
Feb 23
Recall Sessions: Itai Damti on Embedded Finance and the Art of Getting Your First Customer
Latent Space
Aug 21
Simulation: the new Scaling Law — Joon Sung Park, Simile AI
The Diary of a CEO
Aug 6
Top Bitcoin Holder: Ask AI To Do THIS, Stop Trying To Out-Work The Robots! | Michael Saylor
The Prof G Pod
Aug 5
The Basics of Financial Security + Can American Small Business Compete Again?
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 DigestNo credit card · Unsubscribe anytime