Financial Modeler's Corner

In this episode of The Mod Squad, hosts Paul Barnhurst, Ian Schnoor, and Giles Male continue their exploration of tools for financial modeling. This time, they test Melder, a tool designed to streamline financial modeling tasks in Excel. The hosts evaluate how it handles various financial exercises, such as creating formulas and generating a deferred revenue schedule. While the tool shows promise, the hosts identify areas where Melder has room to improve, particularly with bugs and user experience quirks. This episode also highlights the challenges of using tools still in beta.Expect to LearnA detailed review of Melder’s features for Excel-based financial modeling.How Melder compares to other tools previously tested by the team.Challenges faced when using Melder for tasks like building formulas and financial schedules.The pros and cons of using Melder, especially when it comes to its unique features and limitations.Insights into tools’ development process, especially when still in beta.Here are a few quotes from the episode:"I appreciate the confidence behind the bold statements, but at the end of the day, tools need to make sure they’re doing the job correctly." – Ian Schnoor"When tools go wrong, it’s not just about fixing the error; it’s about understanding what went wrong so we can avoid future issues." – Giles MaleMelder offers some useful features for financial modeling, such as custom formulas and file handling, but it still faces challenges like data overwriting and slow performance. While it shows potential, especially in automating tasks, it needs further refinement to become a reliable tool for complex financial tasks. As it continues to evolve, we look forward to seeing how it improves and addresses these issues.Follow Ian:LinkedIn - https://www.linkedin.com/in/ianschnoor/?originalSubdomain=caFollow Giles Male:LinkedIn -  https://www.linkedin.com/in/giles-male-30643b15/In today’s episode: [00:31] - What is Melder?[03:30] - Melder’s Website and Features[08:40] - Testing Melder on Financial Modeling Tasks[12:00] - Exploring Melder’s Formula Creation Capabilities[14:30] - Overview of the LLM Model and Google Gemini Models[19:43] - Testing the Trial Balance and Tool's Thought Process[24:08] - Understanding Overengineered Formulas[32:05] - Testing the PVM Use Case and Encountering Errors[41:51] - Final Thoughts and Melder’s Future Potential

In this episode of Financial Modeler’s Corner, hosts Paul Barnhurst and Ian Schnoor continue their exploration of AI tools for financial modeling. This time, they test Trufflepig, a tool designed to help financial analysts automate spreadsheet tasks while still allowing them to focus on the insights. The hosts test Trufflepig on various financial modeling tasks, discussing its performance and how it compares to other tools they've used. They cover tasks such as building a DCF model for Nvidia, generating executive summaries, and creating a financial forecast. While Trufflepig performs well in some areas, there are still challenges that need to be addressed, particularly with certain financial concepts like working capital and net income.Expect to LearnA review of Trufflepig, an AI-powered spreadsheet tool.How Trufflepig performs on real-world financial tasks.The benefits and limitations of AI tools in financial modeling.Insights into how Trufflepig compares with other financial modeling tools.Here are a few quotes from the episode:“The biggest advantage of using Trufflepig is that it helps you with the repetitive tasks, so you can focus on higher-level analysis.” - Ian Schnoor“Trufflepig is an interesting tool, but as with any new software, there’s a learning curve. But if it delivers value, it’s worth it.” - Ian SchnoorTrufflepig is a promising tool for financial professionals, particularly those looking to automate repetitive spreadsheet tasks. While it performs well on basic tasks like building DCF models and creating executive summaries, there are areas for improvement, especially around financial concepts like working capital and the handling of complex formulas.Follow Ian:LinkedIn - https://www.linkedin.com/in/ianschnoor/?originalSubdomain=caTrufflepig: https://Trufflepig.ai/In today’s episode: [01:40] – Review of Previously Tested AI Tools[05:15] – Trufflepig’s Positioning and Messaging[12:00] – Trufflepig Attempts the eSports Modeling Case[22:00] – Challenges with TEXTSPLIT and Modern Excel Functions[30:50] – Executive Summary Generation[40:01] – Data Sourcing and Web Pulling Behavior[49:26] – Reasons for DCF and Market Price Differences[59:45] – Exporting to Excel and Formatting Issues[1:12:26] – Final Review and Closing Thoughts

In this episode of The ModSquad on Financial Modeler’s Corner, Giles Male and Ian Schnoor put Elkar to the test, a financial modeling tool that's been getting attention for its speed and slick design. From solving structured Excel challenges to building full forecast models, they push the tool to its limits. What follows is a revealing look at how Elkar performs when accuracy, logic, and professional modeling standards are on the line. Along the way, they uncover surprising strengths, critical flaws, and even moments of unexpected comedy. Whether you’re curious about automation or cautious about AI in finance, this episode offers plenty to think about.Expect to LearnWhat Elkar gets right: speed, formatting, and a sleek interfaceWhere it breaks down: logic errors, disconnected assumptions, and unreliable outputsHow Elkar stacks up against other AI tools like TabAI and AgentWhy using AI without understanding modeling fundamentals can be dangerousWhat it takes to turn a promising AI output into a reliable financial modelHere are a few quotes from the episode:"Right now, Elkar is like a junior analyst, you see potential, but you can't let them run unsupervised." - Giles Male"AI tools like this might build something that looks like a model, but without logic, it’s a house of cards." - Ian SchnoorIn this episode, Elkar proves to be a fast and visually polished AI tool with clear potential, especially in formatting and task execution speed. However, when it comes to financial logic, assumption structuring, and balance sheet integrity, it consistently misses the mark. The tool even resorts to shortcuts like hardcoding values and plugging imbalances. Follow Giles Male:LinkedIn -  https://www.linkedin.com/in/giles-male-30643b15/Follow Ian:LinkedIn - https://www.linkedin.com/in/ianschnoor/?originalSubdomain=caElkar: https://elkar.coIn today’s episode: [06:48] - Exploring Elkar: Website, Pricing, and Features[10:34] - Elkar Takes on the Esports Excel Challenge[20:14] - Elkar Gets Caught Cheating[24:18] - Elkar Struggles with Complex Logic[35:45] - Cash Flow Logic & Balance Sheet Errors[46:38] - From Hardcoding to Dynamic Assumptions[53:45] - Balance Sheet Plugging and Logical Failure[57:34] - Reviewing Elkar’s Working Capital Assumptions[1:04:20] - Wrap up & Final Thoughts

In this episode of The ModSquad on Financial Modeler’s Corner, Paul Barnhurst and Giles Male put Shortcut under the AI microscope, testing one of the most hyped AI tools in the financial modeling world. With claims like “the most accurate Excel agent in the world” and the ability to outperform human champions in modeling tasks, Shortcut has made a big splash, but does it live up to its own bold promises? Paul and Giles run it through a rigorous series of real-world modeling challenges, from esports cases and financial forecasts to dashboard analysis and deferred revenue schedules. What they find is a tool with clear potential, and some serious red flags.Expect to LearnWhere Shortcut impresses with formatting, speed, and usabilityWhere it fails, especially with modeling logic How Shortcut compares to Excel Agent and TabAI across key modeling tasksWhy reversing formatting in a model is a huge red flagWhat to consider when investing in premium AI tools for modelingHere are a few quotes from the episode:“Shortcut has potential, but right now it’s flash over fundamentals.” - Giles Male“Could you imagine an analyst reversing formatting to make a number look negative? They’d be out the door.” - Giles MaleDespite the hype, Shortcut proved to be a solid tool with promise. It delivered impressive formatting and UI, yet had some serious issues like incorrect logic, hardcoded values, and non-balancing models, which held it back. A promising AI assistant, just not a replacement for real modeling expertise.Follow Giles Male:LinkedIn -  https://www.linkedin.com/in/giles-male-30643b15/In today’s episode: [01:15] - Intro & Where the AI Modeling Journey Stands[05:11] - Shortcut: First Impressions & Bold Claims[14:28] - Viral Demo Video Breakdown[23:12] - Esports Challenge: Basic Excel Tasks[31:19] - Intermediate Case: Modeling Accuracy[36:10] - Building a 3-Statement Forecast[44:24] - Red Flags: Formatting & Balance Sheet Errors[50:27] - Deferred Revenue Test[56:32] - Trial Balance Dashboard: Visuals vs. Substance[1:07:22] - Final Thoughts & Shortcut's Ranking

In this episode of The Mod Squad on Financial Modeler’s Corner, Paul Barnhurst, Ian Schnoor, and Giles Male take a close look at TabAI, a tool designed to simplify and speed up Excel tasks using automation and intelligent suggestions. With more tools dropping out of the market and Excel’s own Agent feature gaining ground, the question is simple: Does TabAI offer something worth switching to? From cleaning data and building dashboards to attempting a full five-year forecast, the team puts TabAI through a series of real-world modeling challenges to see what it gets right and where it still falls short.Expect to LearnWhere TabAI shines in helping analysts and where it needs improvement.How does it compare to Excel Agent in terms of speed, usability, and accuracy?Why finance pros still need to understand what’s going on under the hood.What to watch for when relying on tools that promise “done-for-you” modeling.Here are a few quotes from the episode:“Agent was faster, but TabAI handled more advanced stuff better.” - Ian Schnoor“AI is great at building things fast, but one small mistake can make the whole model unusable.” - Giles MaleTabAI turned out to be one of the more impressive tools we’ve tested so far, especially when it comes to everyday Excel tasks and building dashboards. It’s not perfect, especially with full-scale models, but it’s definitely a step in the right direction. For now, it’s a great helper, but you’ll still need your own modeling skills to get the job done right.Follow Ian Schnoor:LinkedIn -  https://www.linkedin.com/in/ianschnoor/Follow Giles Male:LinkedIn -  https://www.linkedin.com/in/giles-male-30643b15/In today’s episode: [02:28] - TabAI Leaves Retail[05:17] - Competing with Excel Agent[06:50] - TabAI Feature Overview[10:30] - The “Iron Man Suit” Claim[14:28] - eSports Case Test[23:12] - Dancing Fur Coat Model[29:14] - Trial Balance Dashboard[33:56] - Deferred Revenue Test[38:36] - Full Forecast Model Build[51:10] - Final Thoughts

In Episode 5 of The ModSquad on Financial Modeler’s Corner, Paul Barnhurst, Ian Schnoor, and Giles Male take a hard look at the changing landscape of financial modeling in the wake of Microsoft’s release of Excel Agent. Since launching at the end of September to coincide with Excel’s 40th birthday, Excel Agent has quickly changed the competitive dynamics for AI-powered modeling tools. The team explores the implications: how Excel Agent’s capabilities compare to other tools, why third-party platforms are shutting down, and what all this means for the future of work in modeling-heavy industries like investment banking.Expect to LearnWhy Excel Agent is pushing competing modeling tools like Rosie AI out of the market.What makes Excel Agent a “magnifier” of both modeling skill and error.How fast AI is evolving inside Excel and what that means for modelers today.Why AI won’t reduce hours in finance, despite speeding up modeling work.What OpenAI’s Project Mercury reveals about the next phase of automation in investment banking.Here are a few quotes from the episode:“You can't hit a prompt, go get a coffee, and expect a working model.” – Giles Male“If you don’t understand what the AI just built, you’re in trouble.” – Ian SchnoorThis episode makes it clear: AI is not a replacement for skill; it’s a multiplier. Excel Agent may be setting the new standard, but success still comes down to human understanding, judgment, and accountability. As the modeling world evolves rapidly, professionals who stay informed and upskill will thrive. The Mod Squad isn’t slowing down either; more tool reviews and sharp conversations are coming.Follow Ian Schnoor:LinkedIn -  https://www.linkedin.com/in/ianschnoor/Follow Giles Male:LinkedIn -  https://www.linkedin.com/in/giles-male-30643b15/In today’s episode: [05:29] - AI Tools Recap[07:26] - AI Hype and Hidden Risks[10:23] - AI as a Skill Magnifier[13:48] - Microsoft’s Impact on AI Startups[16:15] - Rapid Evolution of Excel AI[21:29] - OpenAI’s Role in Financial Modeling[29:17] - Understanding Assumptions and Calculations[31:53] - Final Thought

In this episode of The ModSquad on Financial Modeler's Corner, Paul Barnhurst, Ian Schnoor, and Giles Male explore Microsoft’s newly released Excel Agent, a beta tool designed to bring AI into Excel Online. The team compares its performance to Rosie AI, running both through a range of tasks, including formula building, audit reviews, and a full five-year model forecast. Along the way, they test the tools against real modeling challenges like the Excel Esports case and a creative custom case, "The Humble MVP." This isn’t just about flashy tech. It’s a deeper conversation on where AI can help, where it falls short, and why core financial modeling skills still matter.Expect to LearnWhat happened when Excel Agent tried to build a full five-year forecast model.Why solid modeling skills still beat "one-click" AI hype.Where AI tools succeed, and fail, in reviewing formulas and detecting issues.Why you should never fully trust AI without understanding what it’s doing.Here are a few quotes from the episode:“Building a model is like flying a plane; you don’t want a rookie in charge when something breaks.” - Ian Schnoor“You can’t hit a prompt, go get a coffee, and expect a working model.” - Giles MaleFollow Ian Schnoor:LinkedIn -  https://www.linkedin.com/in/ianschnoor/Follow Giles Male:LinkedIn -  https://www.linkedin.com/in/giles-male-30643b15/In today’s episode: [02:21] - What is an Excel Agent and why does it matter?[05:37] - Sharpen Your Modeling Skills[06:51] - Modeling Requires Human Judgment[09:27] - Esports Case: Rosie AI vs Excel Agent Test[19:39] - Excel Agent Hangs in Beta Mode[25:26] - Testing PVM in the Smoothie Business Case[30:01] - Ian Takes Over: Testing Excel Agent on AFM Model[44:11] - Building a five-year forecast model from scratch[55:19] - Adding a revolver to the model[01:00:12] - Why the balance sheet doesn’t balance[01:03:46] - Final thoughts and takeaways

Note: This episode was recorded and scheduled for release before the recent announcement that Rosie AI is shutting down.In this episode of the ModSquad series on Financial Modeler’s Corner, host Paul Barnhurst is joined by modeling experts Ian Schnoor and Giles Male to evaluate Rosie AI, a new tool that integrates with both Excel and Google Sheets. Together, they test its capabilities in building financial models, solving complex FP&A tasks, and performing real-world use cases. They push Rosie through a series of tests, from basic formula creation to building full three-statement models, and discuss where it excels, where it needs improvement, and its potential future in the world of financial modeling.Expect to LearnHow Rosie AI performs in real-world financial modeling tasksThe strengths and weaknesses of Rosie in building models and formulasKey insights into how AI tools are evolving in financial modelingThe importance of knowing how to validate AI-generated modelsHow Rosie compares with other AI tools and traditional financial modeling techniquesHere are a few quotes from the episode:“AI can’t replace the need for modelers to understand the logic, but it can help speed up certain tasks.” - Giles Male“If you know what you’re doing, these tools can save you time. If you don’t, you need to double-check everything.” - Ian SchnoorFollow Ian Schnoor:LinkedIn -  https://www.linkedin.com/in/ianschnoor/Follow Giles Male:LinkedIn -  https://www.linkedin.com/in/giles-male-30643b15/Rosie AI: https://www.askrosie.ai/In today’s episode: [02:23] - Excel Turns 40[07:29] - Microsoft’s AI Agent vs. Modeling Tools[16:18] - Exploring Rosie’s Website and Features[25:35] - Real-World FP&A Test: Trial Balance Summary[35:53] - Deferred Revenue Schedule Test[50:54] - Detecting Inconsistent Formulas in Financial Models[01:00:53] - Testing Rosie AI on a Five-Year Forecast Model Build[01:08:31] - Final Thoughts: Where AI Helps and Where It Doesn’t

Disclaimer: This episode is best experienced in video format. Since we’re testing new tools like Tracelight, the visuals add valuable context and make everything much clearer. We highly recommend watching the video for the full experience.In this episode of the ModSquad series on Financial Modelers’ Corner, host Paul Barnhurst is joined by modeling experts Ian Schnoor and Giles Male to evaluate Tracelight, a new Excel-based modeling tool. Together, they explore how well it performs across real-world use cases in FP&A, Excel eSports, and corporate finance. From auditing balance sheets to solving Excel battle cases and building five-year forecast models, the ModSquad puts Tracelight through a comprehensive test to assess what it gets right, what it gets wrong, and where it still needs improvement.Expect to LearnHow Tracelight performs across different financial modeling scenariosThe impact of LLM selection and prompt design on tool outputWhere Tracelight excels, and where it falls short, in building models and running checksHow Excel eSports challenges expose strengths and weaknesses in formula logicWhen these tools can save time, and when they create more workHere are a few quotes from the episode:"If you don't know your stuff, you're going to learn the wrong things; or worse, think it's right when it’s not." - Giles Male"The best Excel modellers aren’t the fastest, they’re the most thoughtful."-  Ian Schnoor Follow Ian Schnoor:LinkedIn -  https://www.linkedin.com/in/ianschnoor/Follow Giles Male:LinkedIn -  https://www.linkedin.com/in/giles-male-30643b15/Tracelight: https://tracelight.ai/In today’s episode: [02:22] - Tracelight Overview & Positioning[09:46] - Giles vs. Excel eSports Battle Case[18:00] - Reviewing Tracelight’s Logic and Output[28:04] - Advanced Test: Championship-Level Modeling[33:59] - AI Tools and the Learning Curve[41:49] - Deferred Revenue Schedule Test[56:26] - Why Doesn’t the Balance Sheet Balance?[1:02:21] - Fixing Balance Sheet Errors Using Cloud Opus[1:316:00] - Episode Wrap-Up and Final Thoughts

In this special launch episode of The Mod Squad, host Paul Barnhurst is joined by co-hosts Giles Male and Ian Schnoor to explore the evolving intersection of artificial intelligence and financial modeling. Together, they introduce a new podcast series, The ModSquad, designed to test AI tools built for financial modelers, FP&A professionals, and analysts. The trio shares their excitement, cautious optimism, and the pressing questions they hope to answer through hands-on experimentation with cutting-edge tools that promise to transform the modeling landscape. Paul, Giles, and Ian bring decades of combined experience across FP&A, corporate finance, Excel training, and financial modeling accreditation. This introductory episode sets the tone for a candid, unscripted, and deeply analytical journey into the practical realities of AI in finance.Expect to LearnWhy AI won't replace financial modelers, but will transform the way they workHow AI tools are being developed to serve finance professionals specificallyThe importance of judgment, communication, and scoping in effective modelingWhat The Mod Squad plans to test: from three-statement models to Excel esportsHow to prepare your career for the AI revolution in modelingHere are a few quotes from the episode:“Just because it looks cool doesn’t mean it gives you a finished product.” - Giles Male“Modeling is just as much the journey as it is the destination.” - Ian SchnoorFollow Ian Schnoor:LinkedIn -  https://www.linkedin.com/in/ianschnoor/Follow Giles Male:LinkedIn -  https://www.linkedin.com/in/giles-male-30643b15/In today’s episode: [01:21] - Introduction of the Episode[04:57] - Why This Series? Helping Modelers Cut Through the AI Noise  [09:14] - Fear & Job Security: Will AI Replace Financial Modelers?  [14:14]- The Human Element in Modeling: Judgment, Communication, Scoping  [21:03] - Series Format: Tools We’ll Test & Why  [26:03] - Testing Assignments: Who’s Doing What?  [29:03] - FP&A Use Cases Paul Will Explore  [35:21] - What to Expect: Raw Prompts, Real Results  [36:52] - Closing: Why This Series Matters & How You Can Engage