Go back

AI in Financial Modeling for Analysts to Improve Accuracy and Speed with David Ingraham

38m 9s

AI in Financial Modeling for Analysts to Improve Accuracy and Speed with David Ingraham

David Ingram, CEO of Hyper Perfect, discusses how his Excel add-in integrates top AI models like Claude and ChatGPT to help finance professionals work more efficiently. He emphasizes that the key is not just raw AI power but efficient context management—Excel files contain massive data and metadata that can quickly exhaust token limits, so Hyper Perfect compacts information to improve performance. Ingram advises users to treat AI as a collaborative partner, not a magic solution. Instead of expecting perfect answers from one or two prompts, users should engage in a planning process with AI, breaking tasks into small, manageable segments (e.g., building just the revenue section of a model). This iterative approach surfaces user preferences and improves accuracy, similar to working with a first-year analyst. He warns that AI still hallucinates and lacks accountability, requiring human oversight at every step. Ultimately, Ingram believes finance professionals must adapt their workflows—using AI for planning and execution but reviewing outputs rigorously—to unlock its full potential while mitigating risks.

Transcription

6981 Words, 37103 Characters

English
Welcome to the future finance show where we talk about If you just expected to come back after one or two prompts and give you a perfect answer That's not how AI works when AI works really well You start with a planning process and you come up with a plan with the AI Conversation back and forth and one thing you'll be surprised if you start doing that and you haven't done it before is it's actually really good at planning In a lot of cases it will come up with ideas that you didn't think of but probably more importantly I mean that's great, but more importantly just going through that planning process like you would with a first-year financial analyst It starts surfacing things that you're no, I don't want to do it that way. I want to do it this way Future finances brought to you by Qflow.ai the strategic finance platform Solving the toughest part of planning and analysis B2B revenue aligns cells marketing and finance seamlessly Speed up decision-making and lock-in accountability with Qflow.ai Welcome to future finance. I am Glenn Hopper along with my colleague the FPNA guy Paul Barnhurst Paul How you doing? I'm doing great and yourself glad. I'm doing good It's been another one of those back-to-back meetings days But this today I got to get the car and actually go to an in-person meeting so you met actual people Not just talk to them online You want to tell everybody about our guest today? I do so we have here with us David David. Welcome to the show Thank you So let me give a little bit about our guest background. So David Ingram is the CEO and founder of hyper perfect He is a graduate of UC Berkeley and He has spent much of his career nearly 20 years. He worked in private equity working on deals Totally well over a billion dollars. He also founded FACTA which is an AI-powered financial Reporting and accounting platform for investors and SaaS companies Today, he's been focused on his new project new company hyper perfect Which embeds Clawed and other best-in-class AI models directly inside Excel He also serves as board president of AIMHai a Bay Area non-profit providing free summer education to nearly 2,000 students a year David's PE experience is what pulled him into becoming a software founder every deal started the same way someone buried in Excel Building models scrubbing data and hoping the formulas held up Glenn does that sound familiar? Yes It as former CFO and PE backed companies 100% that sounds I Think we could all relate to that one so you realize professionals need to flexibility Excel But want easier more reliable execution So he built hyper perfect as he puts it no context switching no copying into chat to you PTA you just talked to your data in plain English right where you already work So again, David welcome to the show Thank you. I'm not sure where you got all the bio information, but it's very nice Very nice background. So thank you. I will admit I got it online LinkedIn and then I had Clawed modify it and I cleaned it up a little bit Good for you mix of AI and your Lincoln profile primarily That's kind of every workflow that we do now, right is just some AI some web search and then some human judgment Is that a more truth to that than we want to admit Glenn? Yeah, hopefully it didn't hallucinate anything like say Berkeley instead of UCLA or anything crazy No, it's actually pretty accurate. Yeah, all right. There you go. Hey, I for the win So I am interested. I mean this Suddenly everybody's trying to get into Excel right now and as Paul always said I thought Excel was dead But I think your model is a little bit different Can you walk us through before we get in any the other questions? Just explain hyper perfect is how it works and where it kind of sits in this Excel plug-in battle right now appreciate that question. So yeah, I said well just to give you quit background so I About a year ago I was starting to play with AI and You know just teaching myself out of iPad and things like that just to get immersed in the sector because I saw the models were starting to perform and I quickly realized that this could be used to interact with Excel because Excel has offered like who she's offers an API that you can interact with the sheets with and at the time You know everybody was kind of just uploading files into chat GPT and asking it questions about the file and My feeling right away was like if you're if you can't like interact with the file It was thought the type of workflow that was gonna Work for most people and I think over time what I found as I got to you know really immersed myself in the technology is It's impossible to use Excel effectively with AI if you're not able to work very incrementally and So I think building that add in that is in that environment for me was key and now you've got a lot of other Tools that are offered in that environment so now the question is like how do you distinguish yourself and For us, I think that's two different things one is You know the two big competitors obviously are are Claude and then co-cilot So I think there's two ways that we are really focused on becoming different one is I just think about it raw horsepower super important and It's interesting. I'm I'm curious what you guys have been seeing But what I've seen recently is up until the last open AI model came out Claude was really far and ahead the best model for everything relating to Excel I've been testing the last open AI model and all of a sudden it's significantly better than Claude is and So one of the great advantages that the independent providers have is you can switch back and forth between whatever model is the best model and that Putting the right tool for the right job. I think is something that we're Definitely focused on so that we can provide the most amount of value for the least amount of money Which is I think quickly becoming the biggest issue with AI It's actually very expensive like I've been watching polls like tests with all these different providers The reality is anybody could win those modeling tests if they just Turn up all the knobs and spend a ton of tokens to be able to deliver the answer The long-term issue is going to be who can do that for the least amount of tokens and make them very efficient So just being able to have flexibility and horsepower is one the thing I'm noticing the most in the finance world having one foot in engineering and one foot in finance Finances like a year and a half two years behind all the engineering in terms of the sophistication of using AI So I'm still seeing a lot of people open up Excel Hey Claude build me a model and then they're just pointed when like the balance sheet doesn't balance in year five Well, you've missed like 50 steps in between where you started and where you want to get to and I think being able to hold user's hands in terms of Building out in particular context is everything Being able to support them and to teach them how to use these tools effectively those are providing that support Is I think job number one for everyone right now because I think the learning curve is so steep that people are having a hard time Just still understanding like what what's all the functionality I need to understand to be able to Make this work well for me Yeah, I think that's a really important point that you brought up because we've moved on I mean with more Capabilities in the frontier models we've moved on from really having to do chain of thought prompting But I think that the big gap that people have to bridge across is Assuming that the model or that whatever AI tool you're using Has the same context you do when you haven't given anything. That's like hiring a new employee and just telling them anyone can build a DCF model But with the specifics of that these companies were evaluating or whatever the case is you can't just assume they have that context So I really like what you said about the incremental steps in building this though because if you're already in the interface In the surface where you're going to be working in Excel and you say build a DCF model It could build you up a template or whatever And then you can add the context incrementally But if you're just doing it on if you're throwing it on the web-based chatbots It's like okay, it's going to build this whole model and then you've got to go through it It's a you now created kind of two work surfaces there So if you can integrate the two that that makes a lot of sense So how does this experience is it pretty much the same as if you use We won't talk about results because of Paul knows I love to dig on co-pilot here But I mean is it the same interface as if you use the chat gpt plugin or the cloud plugin or co-pilot Where it's just a sidebar but in in yours they get to do model selection or how does the user interact with it? I mean the the initial experiences There's some I mean all of these tools are gonna be always fairly similar just given the limitations that you have in Excel For what you can do with this chat window, but I think where we're taking it is what's different So I really do believe that context is everything in AI and I don't think enough people really appreciate what that is You Put the knilled it with your description of someone coming just out of school. Like if you hired someone just out of undergrad and said, "Build me a model with these financials, what do you think the results are going to be?" And it's not that you can't assume that they're going to know it. You can't assume, you can assume that they won't know it. And that is something that people don't understand about AI. When you press the return button and make a prompt, it has literally no information in its head until you press that button. And the only reason it has a little bit more information on the second time you press the button is because the software provider in the background is giving it the first part of the conversation again. So every time it's a blank slate and that's where the opportunity is to build that context for the individual. So to answer your question in terms of what's different about it, we are solving two problems at the same time. One is you need to provide it way more information than what people are doing today. And two is you need to protect the very finite amount of memory that it has. So Claude just went from two and a thousand tokens to a million tokens. But the reality is the more information you put into that context window, the less the performance goes down considerably. And then the other thing that I'm not sure people are really aware of about Excel in particular is it is extremely easy to blow out the context window in Excel. There's so much metadata, well first of all there's just so much data in Excel files, you know, there are thousands of rows often, hundreds of columns. That alone would pretty quickly blow out a context window. But then you start laying in things like formatting metadata. I've done some tests where a five-year monthly model that's 15 rows long, if you put all the information in there and send it to the LM, you've already filled up a 200,000 token context window. So you've got to start quickly thinking about how are you going to take a reasonable size model and shrink it down into serve that information to the LM in a way that is actually very useful for it. And still today, I think almost all of the tools that I've seen, you know, if you have a thousand rows of the same formula, it's going to send a thousand copies of that same formula to the LM and that just isn't an efficient way to do that. So we've got to do a much better job being able to compact things down to what the LM needs to know, which is there's a formula here and it goes down a thousand rows. And so we've already built that infrastructure in Dars and that's why I think that when I test our product against clawed and co-pilot, I'm seeing performance that's better. And I think it's because we spent the time to do those types of things. But the long-term opportunity is to build the bigger context around all of this information so that every time you press up a request to, you know, build the next 10 lines of this model or whatever, there's actually quite a lot of information being sent over, you know, how does Dave like to build his models? What are the items that the balance sheet is going to need to have for this particular company because we've been working on this company for two years? Dave works at an investment bank. They always use the same LBO model for when they're working with private equity clients. Well, where is that LBO model? Like go find the template and for these 10 lines of the model that we're working on, like what is his company expected to look like? These are all things that have not been built at all by any of these companies. And I think the ones that have made the furthest progress in particular, Claude, it's really like Claude code is built for coders. It's built for huge file repositories. That is not how financial professionals work. Financial professionals might have a file directory, but they also have emails. They've got calls and notes from calls. They've got telephone conversations. So what you need to be able to put into that workspace is much different than what is being offered today. And that's all of the kinds of information that over time we want to build into our product. So it feels like a lot of it around context and how you manage that context window and some of those type of things. Which leads me to kind of another question here. Obviously, you mentioned Chatchy PT has got a lot better, you know, Claude has made a huge leap forward a few weeks ago. You know, given where we're at right now, what are the things that you feel like agents are good for? And what are things that maybe people should not be trying to use agents for? I think a lot of people are struggling. They see this promise that it can build anything. And oh, you just got to get your prompt right. And there's still a level of human judgment here. I don't any I don't think anyone's at the point where it's like, yeah, just let AI do everything. So what's advice you give to finance people? How should they be thinking about using agents today? Not that AI is good at better at some things than other things. But if you're not treating it as a partner, you're not using it correctly. Like if you just expect it to come back after one or two prompts and give you a perfect answer, that's not how AI works. When AI works really well, you start with a planning process and you come up with a plan with the AI conversation back and forth. And one thing you'll be surprised if you start doing that and you haven't done it before is it's actually really good at planning. In a lot of cases, it will come up with ideas that you didn't think of. But probably more importantly, I mean, that's great. But more importantly, just going through that planning process like you would with a first year financial analyst, it starts surfacing things that you're, no, I don't want to do it that way. I want to do it this way. And so you come up with that plan, then you execute on that plan. You don't have a build a three-statement model right in one shot. You build it in manageable segments because what you'll find is the bigger the chunk of work you take, it will perform much more poorly. If you have it building just the revenue section of an income statement relative to building a three-statement model in one shot, it will do an a million times better on that revenue section than it would if it's just part of the entire model. Plus, as you're doing that, you can watch it to make sure that it's doing exactly what you want. That's the thing that people aren't getting is like, it's not this magical, like do it and it's done. We're partnering together and you're going to help me do the hard parts, but I'm going to be on top of every step that you do and every time that we get to the end of this one step of the bigger project that we're working on, I'm actually going to read everything you did and make sure you did it the way that I want you to do. And so I also think that's the disconnect. The people think that A.I. is going to just like remove everyone's jobs. I don't think that's true. It's never going to stop hallucinating the way that it's constructed today and you have to have a human there understanding it so that you can communicate that to other people in your organization to be accountable to the organization as well because A.I. is not accountable. It's just a computer. So I just think that people are very I guess you can, but it's not quite the same. You can change your life providers, but it doesn't care that you've changed your life providers. So I really think people have to very much change how they work with A.I. And if you look at how engineers work, that's how they do it. I mean, they're constantly writing tests to make sure that the code that A.I. wrote passes the tests. And I think that in finance, people don't do that. They just know the balance sheet didn't balance so it failed. No, get it to go rebuild. I haven't rebuilt the balance sheet three times before I even look at the balance sheet. Why would I look at it the first time? It's got two more attempts to get a better. It doesn't cost me much except for a few tokens. So I really think that people need to learn different techniques and how they do it and they'll see much better results. Ever feel like you're going to market teams and finance speak different languages? This misalignment is a breeding ground for failure, impairing the predictive power of forecasts and delaying decisions that drive efficient growth. It's not for lack of trying, but getting all the data in one place doesn't mean you've gotten everyone on the same page. Meet qflow.ai, the strategic finance platform, purpose built to solve the toughest part of planning and analysis. Be to be revenue. qflow quickly integrates key data from your go-to-market stack and accounting platform. Then handles all the data prep and normalization under the hood. It automatically assembles your go-to-market stacks, makes segmented scenario planning a breeze and closes the planning loop. Create airtight alignment, improve decision latency and ensure accountability across the team. I'd definitely have a follow-up question to that, but I'm going to interject here. You're talking about firing AI. I'm shutting down my open-claw server. I've been playing around with it for several weeks and then I kind of figured out that I can do all of what everything I was doing there basically within Cloud Code and Cloud Code work. But when I was shutting down my open-claw this morning, I stopped myself. I didn't do it, but I almost sent a farewell message. You're losing your mind. So anyway, that's my aside. You're inspired today informally, not just informally, but I can't write any of that. I didn't I didn't even go through HR, I just kicked it out. Again, I think you're nailing what a lot of people miss. I mentioned chain of thought prompting before. And what happens is if you're willing to accept sloppy work just in the past few months, the horizon over which AI can go out and work without coming back to you to ask questions has gotten exponentially longer than it was even four or six months ago. But to your point, if it goes off and it's doing its own thing and you're not watching and then you just get the magic return step back at the end, then like you would never build a model like you would first, whatever the main drivers are, you would look at those first and if you're going, you know, start with the income statement and going down, you would start with your revenue and then look at your cogs and you go through like that. So to ask the model to in one shot go consider everything, it's not going to pay as much attention, I guess, to the each of the subsequent steps. But if you do it like you're, you know, you're not handing this off and going to play golf and then coming back to get the perfect model. But if you're a thought partner and a coworker with it, it could be better and much faster than if you had to build the model yourself. So I think that's a very important point that you just made about maybe it's chain of thought again. It's just that the links in the chain get a little bit longer, but you still don't overshoot and try to boil the ocean all at once is what I'm hearing in that. - Absolutely. And I do think because the models are more powerful and they can take on more, it's a slipper slope. It's intriguing to be able to one shot a model. But and look, if that's how you, if you want to work in that size, Chong, you can do it. But don't be disappointed when you don't like the revenue, the way the revenue section always built. 'Cause you didn't tell it how to build the revenue section 'cause you were just, you're kind of going forward and hoping it was gonna do a perfect job. Well, it's not 'cause it doesn't know how you want it. It's a work. So get it, plan with it, go through it incrementally, have it check it, have it check its work, it's own work three times before you actually look at anything. And then when you find things that aren't gonna be perfect for what you want, which is inevitable, by the way, have it correct the problem, don't correct it yourself. That's what I see the advantage of the power and the models today. They can make amazing corrections now. You know, you can have allocation issues and it will not only find the allocation issues now, it will correct the allocation issues. And that's super impressive. And by the way, it does save, if you're using AI correctly, my best guess on my own productivity efficiency is 15 to 20x improvement in terms of how quickly I do things now. I just did a project for my company, that in my last company, it took over, it was about a month and a half and we paid a consultant $20,000 to do it. I did it in a day. I'm getting that routinely that efficiency gain. And I definitely see that in Excel as well. So if you're not getting 15 to 20x, you should start doing some more research and reading and figuring out like what are the techniques that I could be doing to get that. Paul, is it just me or does the steps of going through building a model with AI? It felt very analogous to raising children. Like you give it small incremental steps, you let it go and work those out and you say, no, honey, you didn't quite get that right. Go try again and it will correct its own. I don't know, this is me, that sounded very similar to my parents. I can't relate at all. I just tell my daughter, did get it done and she does it. And you have to give her steps. Obviously that was tongue in cheek. No, I definitely think there's some analogies there. And so we've talked a lot about that whole, you need to spend more time with the model. So what should finance professionals be doing to really kind of step up so to speak here? Is it more of just learning how to better prompt and get context, training, you think they should be changed? Taking, how do they really get themselves ready to get that 15 to 20x? So what advice would you offer them? One piece of advice that I would offer is look what the engineers are doing because like I said before, they're a year and a half ahead and they've gotten extremely sophisticated in how they use AI to code. And it's very analogous to financial modeling. And there's some things that are different too. But for instance, learning how to use sub agents, when you write code now, if you're kind of at the forefront of AI, you don't just chat with one agent and say, hey, write this file of code for me. You send out 10 sub agents. One's going to help you with the planning. One's going to check the agent that created the plan to make sure that they agreed with the, that they can agree on a common plan. Another one's going to go do execution on part one and another one's going to do execution on part two. Then you're going to send three others who are each experts in their particular field to go check all of the code. That's how people should be modeling today. You don't have access to sub agents in a lot of these tools. So you can't do that yet. But those are the kind of techniques that people are using. And I can guarantee you that if you're sending in 20 sub agents to go build an Excel model, you're going to get a better result than if you sit there and try to do it with one agent. So go look at what the engineers are doing. How are they pushing the envelope in terms of getting performance and see if you can transition or translate that into working with Excel, which I think nine times in a 10 year fine that you can. Thinking like an engineer, I've never worked as an engineer, but I've worked with a lot of engineers before. And I think the fact that I was nerdy enough to talk to them about software products we were building in projects that we had going on, you start to absorb some of that. And it does apply. And prooffully, if you're not using AI, it's that same mindset if you are just building a model, the old fashioned way in Excel. So I think understanding what AI does, what its limitations are, and then taking that architect approach, but then or maybe not the architect approach. It's the general contractor approach where here's the Gantt chart. These are the things we're going to do. And these are the specialists that are going to do it. And this is the sequence they run in. That feels like the new skill. If it's not so much about your great Excel formulas and skills in there, it's about managing your team of bots that can get the same outcome. Who cares what Paul Coverier hears? I was going to say who cares what formulas he uses. (laughing) I think your understanding and approach to AI is something that we all just have to start under, just shift our mindset. And on that, you recently posted about the difference between deterministic and probabilistic outcomes and the place for both of them. And I think that's an important thing to understand because as AI has just swept through the zeitgeist and everyone's everything we do, it's people who've never thought of AI before and never, you know, didn't think about spam filters and regression and classification and clustering. And everything that AI did years ago, AI is just a big blanket term and it all acts the same. So when they say, oh, AI is not very good at numbers or whatever AI hallucinates, well, generative AI does XYZ, but that's different than machine learning and other types of AI. So I think though it tells a little bit about what you had to say about that and how that applies to hyper-perfect because I think that's a perfect example and I'm going to stop taking words out of your mouth from the answer, but I'd love to hear you extend on that a bit. - Yeah, so deterministic and probabilistic are kind of engineering concepts and deterministic just means you can, with 100% accuracy to predict what the result's gonna be of something. That is not what AI is. If you ask it to do the same thing 10 times, you might get 10 different answers and it will always be that. One of the great things about AI though and I think where the future is certainly for our product is you can give AI access to tools that are deterministic. So let's say you work in the SaaS industry and you calculate SaaS metrics for your company or for companies that you consult for. There's a bazillion different ways to calculate those things. You can create a tool that every time you give a data is gonna do the exact same calculations. So don't ask the AI to build that analysis for you 'cause you're gonna get 10 different answers every time or if you do 10 different times. If you ask it to input the data into a tool that it is deterministic and it's going to spit out exactly the same analysis every time. It's very good at using those. That is where I think we wanna go is to build a lot of those deterministic tools, to build those, maybe even on a custom basis for users so that if I don't know, they're doing a certain accounting analysis or they want to fill out a very specific financial model every time. You don't actually have the AI inputting the data into the model, you have it turning the knobs on a tool that is going to put the information into the model the same way every time. So, and that is like a limitless opportunity. You could spend years, I imagine there's gonna be marketplaces of these tools, but I definitely think that's when I talk about deterministic and probabilistic, that's what I mean. - Well, I mean, we're definitely seeing a lot of that now, right? There's a reason they added coding, into all these tools, because if you write something in Python, the answer is deterministic. It's just going to run that and spit out the answer exactly based on the variables in the code. Whereas if you ask Jenner to AI to do the same thing without using Python, who knows what you're going to get? It's kind of whack-a-mole bingo, so to speak. Yeah, but you can write Python programs, tell the AI where the program is and how to use it. Yep. And then all of a sudden you've got it as a deterministic outcome from AI, which that is where I think it gets super powerful. Agree. I mean, the amount of coding you can just, the stuff you can code now that is deterministic when you're done using Jenner that the average person you've been new before. You know, I used it to do a ton of code for my website recently, and three years ago, I would have never been able to do that two years ago. I mean, I still had to do a lot of editing and clean up. But it pretty much did 99, pretty much all the code. I just had to clean up, you know, text and things like that. Same thing with like very basic Excel functionality. Like I was talking about don't read the same formula a hundred times because you're going to fill up your context window, which isn't going to help anything. You can build very a lot of different and we have deterministic tools to say like, okay, first of all, figure out what this is. If it's a profit and loss statement, attack it with this tool that we've built you and look, try to figure out like what time frame are we talking about? What are the different revenue accounts and the cost of good civil accounts? So we've started to give the AI a bunch of those tools that are specifically built for financial scenarios so that it has the ability to move quicker, but also in a more defined way. I think that's a great point to move into our next section. I think we've got a good conversation here on, you know, Excel and the thing I'll just remind people is look, we're all learning AI together. It's a journey. The key is you keep going, you find training, you find resource like you mentioned, looked to engineering, learned about chain of thought reasoning and don't just close it because well, I wrote, build me a model and then the model suck. Well, if you went to like you said, go to your junior analyst and say, build me a model with no context, expect the model to suck. AI isn't any different. So here's how our next section works as we move on. We give AI your bio, the questions from today, the internet, your LinkedIn profile and tell it to come up with 25 unique kind of personal and a little quirky because we want to have a little fun questions. So Glenn and I each take a different approach. I give you two options to see which question you have to answer. We can use the random number generator and remove the human from the loop or you can pick the number between one and 25 and I'll read you that question. So which ones you want, random number generator or pick the number yourself? I love probability. So we're in the number generator. All right, here we go. Let's see what it gives us. I came up with one. I don't think it's ever given me one before. It sounds fishy already. I agree. I could run it again. I mean, if you're one of those guys that want to, you know, a lot of local time. No, let's hear the question first and then when they answer. And this is Google Gemini. I used this week. Okay, good. And a little while since I used them, this is under the section titled the PE veteran and Excel trauma. There's five questions under this section. So number one says you spent 20 years in private equity and worked on over one billion in deals. In all those years, what is the single most cringe worthy? And it did put that in quotes. cringe worthy formula are circular reference error you ever found in a high stakes model. I think this is answering the question, but it's a little different. I don't remember what the formula was, but we were looking at a deal once. One of the funds that I worked with we invest a lot on data centers, which I see big today now. But they were very large dollar investments because they're so expensive to build out. So the numbers were sometimes pretty big. And I got a, you know, the investment that you go through a investment banking process, you get the model and everything from the investment bankers. And I once found it was probably a two or three hundred million dollar deal. There was a $50 million dollar modeling mistake. And so there was basically you had to put $50 million more capital than they were telling you into this deal to get the results that they were telling you you're going to get. That was crazy. That's not a small number. What's 50 million among friends? Come on guys. It was very significant. And they probably sent that same model out to, you know, 50 other private equity funds. That by the way, something that AI's were found that mistake very easily. Great point. And that's a, again, thought partner, right? So, okay. So my approach is I figure AI generated the questions. Let AI pick what the question is. And if it picks number 25, we're going to know there's some kind of weird alpha and omega thing going on here. I number six. So, okay. Number six is hyper perfect. Let's use those talk to their data in plain English. If you could use that same technology to talk to your coffee machine or your car, what would you first prompt? That's not a bad question. What's the first prompt going to be to that coffee machine or car? Well, I actually just bought a new espresso maker two days ago. So, I'm going to go with coffee machine. I mean, I would just give it all the information of what I wanted to do. You know, like, I'm just coming up to speed on this. I'm not one of those crazy espresso guys, but I'm trying to make a decent, you know, espresso. So, first of all, turn on at 7 a.m. Get up to, I think it's like nine bars of pressure you're supposed to get up to. Set the dial on the grinder to get to that nine bars of pressure. I mean, it would just be back to context, giving it all the context of what I think needs to go in and not just what I want out, because I don't think that that's, we're quite at the point yet where you can do that. I think you had to tell it like how you want to get there to get the result that you want. You're going to give it instructions, not an output of I want a really good tasting espresso. Well, I should revise that a little bit. I first would tell what the ultimate goal is, then I would ask it, how are you going to get to that goal given that you've got, you know, up to nine bars of pressure that you can use and all, you know, those other things. The other thing I would do is, and this is another tidbit that people should be getting from engineering, don't be typing to your AI. You should have voice recognition software. If you don't already use it, you should go right out today and get it because that really opens the door that allows you to give AI way more context. So I'd be talking to my espresso maker, I wouldn't be typing to. I love that answer because I got one of those brevils, makes all the drinks things for Christmas. And the first three days, fiddling around with that grinder to get it to make the right, you know, it has to, it's supposed to start brewing. It's in coming out at eight seconds and at 25 seconds, it was maddening. And I would have loved to have just had a bite and say, go fix this. I don't why doesn't it come from the factory like this doing all that tuning. So that's AI, there's your challenge. Make the perfect cup of coffee. You both realize it's only going to be a few years until we start to see appliances with all that. I'm excited. It'll make my life a lot easier. If I have 15 more expresses for the same amount of work, I think that would be great. Love it. All right. Well, thank you so much for joining us, David. We had a lot of fun with this conversation. I appreciate you carbon out some time for us. It was a pleasure to talk to you guys. Thanks for listening to the future finance show. And thanks to our sponsor, Qflow.ai. If you enjoyed this episode, please leave a rating and review on your podcast platform of choice. And may your robot overlords be with you. [ Music ]

Podcast Summary

Key Points:

  1. Hyper Perfect is an Excel add-in that embeds Claude and other leading AI models, allowing users to interact with data in plain English without leaving Excel.
  2. Key differentiators include model flexibility (switching between best models like Claude and ChatGPT) and efficient context management to avoid blowing out token limits from large Excel files.
  3. AI works best as a partner through iterative planning and incremental execution, not by expecting perfect answers in one or two prompts.
  4. Users should treat AI like a junior analyst
  5. Human oversight is essential because AI can hallucinate and lacks accountability; it’s a tool to augment, not replace, human judgment.

Summary:

David Ingram, CEO of Hyper Perfect, discusses how his Excel add-in integrates top AI models like Claude and ChatGPT to help finance professionals work more efficiently. He emphasizes that the key is not just raw AI power but efficient context management—Excel files contain massive data and metadata that can quickly exhaust token limits, so Hyper Perfect compacts information to improve performance. Ingram advises users to treat AI as a collaborative partner, not a magic solution.

, building just the revenue section of a model). This iterative approach surfaces user preferences and improves accuracy, similar to working with a first-year analyst. He warns that AI still hallucinates and lacks accountability, requiring human oversight at every step.

Ultimately, Ingram believes finance professionals must adapt their workflows—using AI for planning and execution but reviewing outputs rigorously—to unlock its full potential while mitigating risks.

FAQs

Hyper Perfect is an Excel add-in that embeds AI models like Claude directly into Excel, allowing users to interact with their data in plain English without switching to external chatbots.

Hyper Perfect focuses on raw horsepower and flexibility by switching between the best AI models for the task, and it optimizes context management to avoid blowing out the token window with Excel metadata.

AI models have no inherent context until you provide it, and Excel files can quickly fill the context window with data and metadata, so efficient compaction and incremental work are key to performance.

Treat AI as a partner, not a magic solution. Start with a planning process, break tasks into manageable segments, and review each step to ensure accuracy, just like working with a junior analyst.

AI still hallucinates and cannot be held accountable, so human oversight is essential. Trying to build a full three-statement model in one shot will perform poorly compared to building it section by section.

Sending thousands of rows of identical formulas to an AI is inefficient. Compacting data to what the AI needs—like noting a formula repeats down a thousand rows—improves performance and saves tokens.

Chat with AI

Loading...

Pro features

Go deeper with this episode

Unlock creator-grade tools that turn any transcript into show notes and subtitle files.