How FP&A Teams Can Improve Decision-Making with Scenario Planning & Financial Models - Michael
Showcase: Explore Leading Tools
FP&A leaders are embracing AI, and we’re here to help. On May 21st, I’ll host the FP&A & AI Software Showcase, featuring FP&A planning and AI tools like Concourse, Sapien, Drivetrain, and Una AI. Join us for live demos, insights, and no sales pressure.
Register today:www.thefpandaguy.com/fpa-software-showcase
In this episode of FP&A Unlocked, Paul Barnhurst speaks with Michael Gould, a technology entrepreneur and founder of Kaleidoscope, about his extensive experience in financial planning and modeling. Michael shares insights from his 40+ years in the industry, including his work with Anaplan, and discusses how modern finance teams can break free from the limitations of spreadsheets and legacy systems.
Michael Gould is a technology entrepreneur and software engineer with over 40 years of experience in financial planning and modeling systems. After studying Mathematics and Computation at the University of Oxford, Michael co-created Adaytum, a leading business planning platform, and later founded Anaplan, a globally successful enterprise planning platform that became a British tech unicorn. Today, he is the founder of Kaleidoscope, focusing on rethinking financial modeling for modern teams and continuing to pioneer innovations that drive better decision-making in business.
Expect to Learn:
The challenges and complexities of modern financial modeling
How Kaleidoscope is helping businesses move beyond spreadsheets
Michael's journey from IBM to Anaplan and now Kaleidoscope
The importance of understanding business processes in financial modeling
How AI is impacting the financial modeling landscape
Here are a few relevant quotes from the episode:
“The key to financial modeling is representing the complexity of a business without over-simplifying it.” – Michael Gould
“AI is a powerful tool, but it’s the data context that drives the real value.” – Michael Gould
Glenn explains that career growth in FP&A is no longer about following a fixed path or relying on credentials. It comes from building relationships, gaining real experience, and understanding how the business works. He also highlights that strong professionals go beyond numbers by connecting financial results to real business drivers and supporting better decisions.
Follow Michael:
LinkedIn: https://www.linkedin.com/in/migould/
Website:https://www.kaleidoscope.com/?utm_source=partner_fpandaguys&utm_medium=podcast&utm_campaign=interview
Earn Your CPE Credit For CPE credit, please go to earmarkcpe.com, listen to the episode, download the app, answer a few questions, and earn your CPE certification. To earn education credits for the FPAC Certificate, take the quiz on earmark and contact Paul Barnhurst for further details.
In Today’s Episode
[00:00] – Trailer
[06:00] – Challenges of Multi-Dimensional Modeling
[12:00] – Transitioning to Anaplan
[15:00] – Kaleidoscope’s Mission to Help Small Businesses
[21:00] – The Role of AI in Financial Modeling
[27:00] – The Future of Financial Modeling
[33:00] – Key Learnings from the Entrepreneurial Journey
[39:00] – How AI is Changing Financial Decision-Making
[45:00] – Overcoming the Data Challenges in Finance
[51:00] – Final Thoughts on Innovation and Future Trends in Finance
[57:00] – Conclusion and Key Takeaways
Full Show Transcript:
Host: Paul Barnhurst (00:00:00):
Welcome to another episode of FP&A Unlocked where finance meets strategy. I'm your host, Paul Barnhurst, the FP&A guy. Each week we bring you conversations and practical advice from thought leaders, industry experts, and practitioners who are reshaping the role of FP&A in today's business world. This week I am thrilled to be joined by our guest, Michael Gould. Michael, welcome to the show.
Guest: Michael Gould (00:00:25):
Great to be with you Paul. It's really good to be here.
Host: Paul Barnhurst (00:00:27):
Not excited to have you. And so lemme start just a little bit of Michael's background, but first I'll say why I'm so excited is Michael's one of the biggest tools, I think kind of a huge one, this industry that everybody knows about. So when you said yes to come on, I have to admit I was really excited. I enjoy talking to people that have been in this space for a long time and I think you're over 40 years now.
Guest: Michael Gould (00:00:48):
That's right, yes. Yep. More than 40 years in this space now
Host: Paul Barnhurst (00:00:51):
You know where all the bodies are married, so to speak.
Guest: Michael Gould (00:00:55):
Certainly do.
Host: Paul Barnhurst (00:00:56):
Alright, so a little bit about Michael's background and then we'll jump into the interview. So Michael Gould is a technology entrepreneur and software engineer with over 40 years’ experience building financial planning and modeling systems. He began his career in the early 1980s on IBM mainframes, after studying Mathematics and Computation at the University of Oxford. He went on to co-create Adaytum, a leading early business planning platform, and later founded Anaplan a globally successful enterprise planning platform and British tech unicorn, which listed on the New York Stock Exchange. Today, Michael is the founder of Kaleidoscope, his latest venture focused on rethinking modeling and planning for modern teams. He continues to pioneer in the space, exploring how better systems can improve the structure of financial models and drive clearer, more effective decision-making.
Guest: Michael Gould (00:02:01):
It seems to have kind of got me hooked, hasn't it? Yeah, so I started out, got a job as an intern at IBM. It was a gap year between school and university. Didn't know what it was about. It was a programming job, learned on the job in terms of programming. Programming in a PL back in the day. Goes back a while, not used so much nowadays, but it was used quite extensively at the time. And the system I was working on had been developed in-house within IBM by a great guy who's kind of my mentor, George Kunzel, who had built essentially a multidimensional modeling system for internal use in IBM uk. And so it was kind of very similar to the sort of technologies that then emerged over many years to come in terms of being an alternative to the spreadsheet as a vehicle for describing what's going on in the business and planning it. So that's where I got into this journey, found out about it, learned on the job and took it from there.
Host: Paul Barnhurst (00:03:02):
What's kept you interested in it all these years? Obviously you must've found it quite interesting trying to solve that multi-dimensional modeling problem versus just using a spreadsheet, so to speak. Yeah,
Guest: Michael Gould (00:03:15):
So I think why it's kept me fascinated is essentially the problem we're trying to solve is how do you represent what's going on in a business? And that is a complex thing. There's a lot of different parts in a business, a lot of different business functions, how they interrelate with each other. There's a lot of data and essentially trying to come up with a representation of that business that's a natural representation of the activities of business in all their complexity and not dumbing it down, not trying to make it over simplistic but not so complicated that you can't work with it and model it. And obviously we need it forward looking for financial planning, financial modeling, you don't know, you can't model transactional level detail. You've got to model at a much higher level. So just trying to understand that problem. How do you translate what's going on in a business into an effectively a computer model of it that allows people to make good decisions.
Host: Paul Barnhurst (00:04:09):
And I think you made a great point, right? You're not going to model or nobody should model at the transactional level. Just the amount of work that would make no sense. So how do you consolidate it and build something that's still realistic?
Guest: Michael Gould (00:04:23):
Yeah, absolutely. And represents the real complexity of what your business does.
Host: Paul Barnhurst (00:04:28):
So I would love to go back, I know you helped found a datum and then you helped found Anaplan. What led you kind of to that entrepreneur route to starting a business and what's that journey been like? I mean Anaplan, well known in the marketplace, one of the leading enterprise tools out there now.
Guest: Michael Gould (00:04:44):
Great journey with Anaplan. So I've been, as you said, at Ed AUM and then we got acquired by Cognos. And since you Rick recognised that it was an unsolved problem, the problem which I'd by that stage been working on for 20 years, this challenge of how do you represent business, how do you model it? Seeing that spreadsheets, Excel was launched in 1985. So by the time I started on Anaplan, Excel had been out for 40 years now for accounting. The motivation really was seeing that companies big and small, still on spreadsheets, still struggling to get this kind of the right framework for modeling business decisions. And even though we'd made some progress with a data, which was essentially taking this IBM mainframe system that had worked on previously and taking it initially to dos and into Windows and then onto the web, it still wasn't the right representation of how a business functioned.
(00:05:41):
Anaplan was effectively a chance to just start again, clean slate, try and rethink it. And we moved a significant step along the journey with Anaplan. I don't think we got the whole way, but it made substantial progress, which is how it became established as a leading player in that space in terms of the journey. So I left my job at Cognos and I was in a position where I was able to work by myself unpaid for a couple of years. One of the things I've learned, because you've been around this loop quite a few times now, is it takes a long time from writing the first line of code to having a product. These are complex problems. So at Anaplan, it was actually four and a half years from when I wrote the first line of code to when we signed our first customer, which is a long lead time.
(00:06:38):
So I worked by myself in a very cold stone barn a couple of miles up the road from where I'm now rural North Yorkshire, writing the core calculation engine, showed it to Guy and Sue Hatton who invested in the business. A guy came in as CEO and Sue started out in head marketing and then took another two years with a small engineering team to build the product out and launched commercially. And so it was a long lead time, got it out and then started to see the success with it and started signing up some really amazing big name customers and took it from there.
Host: Paul Barnhurst (00:07:22):
Great journey. I've heard the barn part, I've seen that a few places you kind of started in a bar and that's always fun. It's kind of like HP and starting in a garage,
Guest: Michael Gould (00:07:31):
That's the one. Yes. Yeah, yeah,
Host: Paul Barnhurst (00:07:33):
Those type of stories. The other thing I heard you say, and it doesn't surprise me now, when I started it did, I really started talking to fp a software vendors about five years ago now. And now I've talked to well over a hundred. I've talked to a lot in the market and when you said four years, I'm like, yeah, I started thinking of all the tools, they show me a demo, then all of a sudden I wouldn't hear anything for a long time. Yeah, we went back and rebuilt the product, it'd be a year later, two years later, whatever, because they'd come out to market and just realise, oh, this isn't competitive or we haven't really solved the problem. Or one guy was talking to, he got a year and a half in and he started over because he didn't feel comfortable with the product.
(00:08:12):
And so hearing you say that kind of ties with what I hear a lot of these founders say. Everybody thinks, oh, I just need a spreadsheet and some reporting. And this is a simple problem I think especially after COVID and when I saw so many tools prop up and I'm like, yeah, okay, maybe for a startup, but then they're just going to use Excel enterprise, anything of real scale. Love your thoughts. It feels like this becomes a very complex challenge to manage the dimensionality, the calculations and build out what they really need to support a business.
Guest: Michael Gould (00:08:46):
Well, I think one of the things I've seen that's really interesting is the complexity. Obviously at Anaplan we were dealing with some of the biggest companies in the world, the likes of hp, DIG, people like that, huge companies. But in many ways the small businesses have the same problems. They have the same complexities, the detail, it's obviously much smaller scale, but you've got a lot of the same challenges about supply chains and choices, decisions you're going to make about do you outsource manufacturing or you do in-house, do you manufacture sub components or buy them in all these kind of decisions that you have to make. And they really are the same challenges, whereas for small businesses you don't have the resources to bring in to deal with relatively complex enterprise software systems.
Host: Paul Barnhurst (00:09:38):
Sure, yeah. It can get very expensive in a hurry if you're doing a lot of customization. You got supply chain planning, you got sales off, you got finance for using them all in the same tool, whether it's Anaplan or somebody else. I mean, you know this right there can be a big consulting bill to get that all set up. The engine may be great, but there's a lot of bespoke work so to speak that goes on to meet each business's needs. So I'm curious if you could do it over again, anything you do differently at Anaplan maybe what are some of those kind of key learnings from that journey?
Guest: Michael Gould (00:10:09):
Really good question. So one of the things about Anaplan was obviously we were VC funded as it got after getting the initial product out, started to get a few customers, we got investment from venture capital firms. I don't think I appreciated because the first time I'd been on that journey, I don't think I quite appreciated at the time what that implied in terms of jumping onto a moving walkway that was just going to accelerate. It had to accelerate. So you're jumping onto a trajectory that requires fast growth, further investment, further growth, and always striving for the next milestone, which was in hindsight, that was the only way we could have done it. It was extraordinary. It was building a business. We, we went from 150 to 300 to 600 employees in successive years and you lose a few along the way. So by the time we were at 600, 500 of those employees had only been with the business for a year or so.
(00:11:18):
It's extraordinary kind of churn and change that you get in that high growth stage. So if I was doing it over again, what would I do differently In one way, nothing at all. I think that was the right path for what we were doing then we couldn't have done it in any other way. But what it does do is it forces you into a more short-term perspective on what you're building because you're trying to hit the revenue targets for the next quarter and the next quarter you've got to get the big deals in, therefore you prioritise the features that the next big enterprise deal will make the difference to get that deal across the line in time for the quarter to close in time for the year end. And that drives growth, drives then allows for future investment. But what it doesn't do is it's not a path that helps you on a long-term strategic rearchitecting of the system.
(00:12:22):
And in many ways what you find is whatever you built in to start with, that's what you've got to play with. And then you're building a lot of stuff around the edges is very hard to really rearchitect things. And so I think the one thing which would I do differently? Probably not in a sense, but I don't think we could have done this any differently, but the thing which I would love to do and now trying to do differently is just taking that longer term view to say, okay, well where we want to get to, we're prepared to take a bit longer to architect the system. You mentioned you've seen people already and they're only a year or two out. And in a way I think that's the right thing to be doing. We didn't have that chance to Anaplan, we were too busy being successful in the market to do that.
Host: Paul Barnhurst (00:13:14):
It can be tough. I know of a tool that's been around nearly 30 years and they did a big architecting project and well continuing to have customers and be good size, that's hard to do. It's really tough because of all that goes with that. So it sounds like the biggest thing, the learning and probably what you're taking away with Kaleidoscope is really taking that time to build it, get comfortable where it's at, really doing that architecting, making sure you have the tool you want and going to market. If I understand correctly, I don't think you've done really any VC or any of that type of funding with this one. It's a little bit more allowing you to not have the high growth targets as you try to build.
Guest: Michael Gould (00:14:01):
Yeah, started collide scope back in 2020 on the back of having had the Anaplan IPO. So able to fund it, take our time and try and do it right next time round. The client scoop is my sixth attempt at this. So this IBM mainframe version that I worked on back in the early eighties, that is V one and counting through the different attempts. This one is V six
Host: Paul Barnhurst (00:14:27):
IBM, there's a datum, there's Anaplan, kaleidoscope, what's the other two in there?
Guest: Michael Gould (00:14:31):
Id count as two because there was the kind of DOS Windows desktop product and then we rebuilt it for the internet.
Host: Paul Barnhurst (00:14:39):
Ah, yeah, yeah, that's a totally different,
Guest: Michael Gould (00:14:42):
It was quite a different world and a dating contributor. And then there was, whilst still at Cognos, we attempted a new platform which never made it out out and learned some good lessons along the way trying to do it, but that one never saw the light of day. So there was one more in there.
Host: Paul Barnhurst (00:15:01):
Got it. Okay, that makes sense. So I figured there might be a couple within either IBM or the whole Cognos journey there, so that makes sense. Yeah, you
Guest: Michael Gould (00:15:08):
Mentioned knowing where the skeletons are. Yeah.
Host: Paul Barnhurst (00:15:10):
So tell us about Kaleidoscope. You've been working on that I think since 2020. I mean I know you founded the company to build the tool you wanted now, but kind of just walk through why Kaleidoscope, how you're thinking about it, why it's needed in the marketplace? Just give us a story.
Guest: Michael Gould (00:15:29):
So one of the things that I've seen and going back over the years at Ed aum, we were working with much smaller companies than we did at Anaplan and then gradually worked towards bigger companies towards the end of Ed aum. And with COAs, obviously large companies seeing that the problems that small companies are trying to solve are really just as real as big companies in terms of decision making. If you think of the impact on cashflow of a decision that you make, if you're a bigger company, you may have a bit more leeway in terms of being able to raise capital or restructure or whatever. If you're a small business and you make a bad decision, you just run out of cash and you're out of business. So in many ways the decision making process is more critical. So what we're trying to do with Kaleidoscope is to take the kind of modeling that allows you to come to good decisions that really has been exclusively the domain of big companies with big implementation teams and bring that to smaller companies. Initially we may well go to bigger companies in future, but our initial target is to take that same kind of modeling expertise domain into small businesses, medium-sized businesses and provide them with a platform that allows them to make good decisions and specifically to explore possible scenarios, model different assumptions about where the business may go, and then be able to evaluate options before you commit to a decision. And not all decisions are going to be good, but at least you can understand what the risks and benefits are.
Host: Paul Barnhurst (00:17:13):
Got it. And when you say smaller company, are we talking few hundred employees, you're kind of mid-market or how do you think about that at some point if you're too small probably doesn't make sense. So how do you think about
Guest: Michael Gould (00:17:30):
Yeah, so that's been part of our journey over the last couple of years. So we started out looking at very small businesses and there was a reason for that. Really it was to almost set us a challenge to say, okay, well we've got experience in the mid-market with our data experience in the big companies with Anaplan. If you start with really small businesses, you've got two things going to happen. One is you've got the kind of threshold for usability is just so high if you can't get the up and running really quickly, really easily, you've just got to make it easy and you've got to make it easy to get data in. And now we can come back and talk about that because that see is one of the real big challenges and the big opportunity there. The other reason for starting with really small companies is there's this kind of gravitational pull upwards. So once you've got people selling a product, every salesperson on the planet, they never come to you and say, Hey, can you take all these features out so I can sell smaller deals into smaller businesses?
(00:18:37):
That's not what a salesperson says. They say, can you put this feature in because if you put this feature in, I can get this deal at this big company. And so there's this kind of gravitational pull upwards towards the bigger companies. So we thought, well let's start right at the smaller businesses, see how we get on and then take it from there. We initially started looking at sales analysis, demand planning and stock planning for micro businesses. So tiny companies, anything we didn't, we said, okay, well exclude sole traders. We assume a sole trader can just, they're doing it on the back of an envelope, but anyone who's got a couple of employees upwards and are selling goods on e-commerce platforms, what we found was that it's actually that size of business. You don't have anyone who's technical in the company, typically they're the founder who has a passion for some particular product and they've got some ideas and they've started producing it and selling it. You don't have a finance person quite often and found that sector just too challenging to get into. So we've now shifted up, but we are still looking at small to mid-market companies. So essentially companies, once you're big enough to have a finance team, you've got people using spreadsheets, you've got anything from, we are probably targeting more like a hundred to 500 company, but we're certainly interested in the 50 to a hundred as well. Maybe a bit smaller than that in terms of number of employees.
Host: Paul Barnhurst (00:20:13):
Yeah, no, that makes sense. And yeah, I'm not surprised to see you moved up a little bit the smaller you go, it's very hard in this space from everything I've seen and I'm glad you tackled that. Anything else you want to share about Kaleidoscope before we move on? I want to ask you some questions about fp and a, but I give you anything else you want to share. There
Guest: Michael Gould (00:20:36):
Is pervasive through everything and one of the things we're thinking about very hard at the moment is looking at what's going to be differentiated in the AI space. Because my perception is that things have shifted and they've changed even over the last few months.
(00:20:53):
There's something has moved in terms of the capabilities and the adoption of ai. So I think it's fair to assume now that any platform going forward will have AI to help you with bringing data in and cleaning it up, helping you build your model, helping you get insights from it, either queries to get information out of it or to alert you to things that are going on. But those kind of capabilities they're going to be across everything are in spreadsheets, they're in big enterprise tools and so what's going to be differentiated is going to come down to some very different things. To me, those things are now just table stakes. If you don't have that, then you're not in the business. So then it comes down to, well, is your model a good representation of the business such that AI tools or people and or people can build a really good model and understand it, trust the numbers.
(00:21:57):
One of the big challenges, okay, it's all very well for AI to generate lots of data, but do you trust it? Do you know what it's got? So that's the kind of stuff that we're looking at now is to say, okay, we think we've got building on the multiple attempts at this building a framework that allows you to describe your business really well, that actually is then amenable to AI tools to do the same thing but still got that human aspect that you can inspect it, you can understand it and make sense of it and therefore trust it. And just to give an example, I mean extraordinary, the developments recently in terms of AI tools generating spreadsheets, they're getting so good at it, which is amazing, but an AI tool that generates a hundred thousand cell 4 million in spreadsheets, how do you know it's done it right?
(00:22:58):
How are you going to figure that out? Okay, it might be great and it may be that we'll get to a point where people trust the tools so well that the tools are so good, they just don't make those mistakes that humans make. But in the meantime, I think it's a real challenge. There could be some anomalies in there that you just don't spot and if you didn't construct the model, actually picking through it is going to be really difficult. So in a way, one of the questions I still feel like people will have to ask and we are asking ourselves as a business as we build out our platform is, okay, what are the constructs that you're actually working with? Are they a faithful natural representation of what's going on in your business so that you can examine them and understand them and see specifically the calculation logic, but the data structures, do they help you and do they play well in that world?
Host: Paul Barnhurst (00:23:52):
I think you hit on kind of a key point with all these tools, building models, whether you're building it in a spreadsheet or whether you're having a build in a planning tool, more so in a spreadsheet because every cell is typically a different formula. They're not building them with a raise, at least that I see in general. So you're dealing with a hundred thousand formulas if you have a hundred thousand cells. And I really like what somebody said, I had an expert modeler on, we did a conversation, he's like, thing everybody needs to remember is we trade in trust. When you have someone build a model and you trust that it's right, he goes, they don't care if the tool built it or you built it. If it's wrong, you lose the trust, not ai.
Guest: Michael Gould (00:24:31):
It is an interesting point, that trust aspect and how do you know whether it's good or not almost in say independent of whether it was built by a personal or an AI tool.
Host: Paul Barnhurst (00:24:46):
So you need to become better at auditing because the best modeling houses, investment banking, all those big deals, they have a very strict audit process and you're going to see that developed for ai. And some of it will be another tool checking it, some will be software, some will be a human, until we get, like you said, one day maybe we get to the level where we're comfortable enough that the errors and mistakes are going to be less than the human. We let it build. And we probably do get there at some point given how far we've advanced in a few years, but I don't think we're there yet for most models. I wouldn't trust it at this point without a review. So I think it's a fascinating area and discussion. It'll be fun to kind of watch it all unfold.
Guest: Michael Gould (00:25:26):
Yep, indeed.
Host: Paul Barnhurst (00:25:26):
Alright, so I'd love to get your thoughts. You've supported FP a software for 40 plus years now, six different tools. How would you describe or how do you think of the job of FP&A in an organisation? What's your thoughts on that?
Guest: Michael Gould (00:25:41):
So I think fundamentally it's supporting the decision-making process in an organisation. I like to think of organisations as kind of two types of people in there are the people actually do the stuff. So people who make staff who do services, they go out and sell it and market it because you've got to market it for people to know about it. You've got to sell it for people to have it, build the products, whatever it is, support them. They've got the frontline people. And then in organisation you've got the kind of people who are one step removed from that. So senior management, finance, hr, it. If you're not an IT company, they're all one step removed. You could just say don't really do anything useful to the business. At least they only do things by being one step removed in that sense. So it's what their supporting role is within the organisation that is critical.
(00:26:45):
So specifically in terms of the finance team, what are they doing? Obviously they're providing the information, the insight as to what is going on in the business, but I see it fundamentally as being, enabling the decision-making and therefore providing the analysis of potential future states. What if I do this? What's going to happen? What are the alternatives? What are the different paths that as an organisation, a particular decision could lead to? And putting that in the hands of the right people. So senior management, but all the different departments in the company making their own decisions about how they spend their budget, what hiring they do, what investment do they do in plant and equipment, all those critical decisions, enabling all of that and critically, I suppose tying it all together so that the functioning of the business is a coherent whole rather than disconnected, dragging off in different directions.
Host: Paul Barnhurst (00:27:54):
I like what you said there is fp and a, it really is to enable decision making. So as you look at it, how do you think fp a is doing at the job? How do you think they've done from your perspective? Do you think the field's done a pretty good job there, things you think we need to improve on or what's kind of your take on just the FP&A profession on how they're doing?
Guest: Michael Gould (00:28:15):
I think I'd characterise it as doing as good a job as they can with the tools available. I think the motivation is there. The people want to do a good job. I think people are still wallowing in spreadsheets and that's a problem. People are, even with bigger companies with the planning systems in place, they don't necessarily have the kind of flexibility to move things on in the way that they want to and speed of change because of the teams involved in that process. And I think where that comes out in terms of the limitations of what people are able to achieve as an FP&A function supporting the business is things like evaluating scenarios. So very often when you hear people talking about scenarios, it's just, okay, well there's the best case and there's a worst case. And guys, that's not so over simplistic. You've got a whole bunch of levers that are interconnected. You make a decision on, let's take an example. You've got a new product launch, you don't know how much it's going to sell. You've got to decide how much stock you're going to make.
(00:29:43):
Do you buy more or make more? And that ties up capital. What profile of sales, what profile of uptake is there going to be? Are you going to, if you don't have the funds to fund that initial stock purchase or stock production, you might have to take out some financing arrangements. What are your risks around the upside or downside depending on how you are on a range of outcomes or range of timings as well. It's not just about, especially for the smaller businesses, it's not just about how much you sell or don't sell, but when's that kind of curve of update hitting those kinds of things. They're enough to make or break a small company especially. So how do you tie all those things together to be able to evaluate lots of different scenarios and identify risk? And that to me is where I feel like in terms of the role of fp and a, the desire is there, the willingness is there, but the tools are not to enable people to do that kind of detailed exploration and analysis of potential future future states, particularly with regard to this kind of interconnection.
(00:31:06):
Okay, product launch, I've got new products, I've got to be able to market them. Am I going to be able to sell them? Have I got the finances? Have we got the production capacity? Have we got the warehousing to store the things, the logistics to deliver them? All those parts of the business get triggered from one decision we're going to make going to launch this new product line. And how does that all pull together back into the finance function where right, I've actually got to pull this together into a p and l cashflow and a balance sheet and see where we would end up if we make that decision.
Host: Paul Barnhurst (00:31:41):
FP&A guy here, ag agentic AI is one of the biggest shifts in finance ever and most FP&A leaders are still struggling to figure it out on May 21st. I'm hosting the FP&A and AI software showcase with two of the leading AI agents in the marketplace, concourse and sapien plus leading planning tools, drivetrain and un a AI one sitting real demos register at the fp a guy.com/fpa software showcase. That's fp a guy.com/fpa software showcase CU on the 21st. It sounds like the biggest challenge you see is really around the tech and being able to manage scenarios, sensitivity variables, really looking at something interconnectedly and saying, Hey, we're going to do decision C, go into this new market or build a plant or whatever that might be. How do we really make sure we understand all the implications? What's that do for cash? What does that mean for inventory? What does that mean for our customer support team, whatever it might be. Because we all know any big decision touches pretty much everything in a business.
Guest: Michael Gould (00:33:07):
Yeah. An example of where I see this kind of thing working well is in the s and OP process, particularly in larger companies where on a monthly cycle deciding how much production to run, you're bringing together the sales team, the marketing team, finance, statistical analysis or statistical forecast based on historic data in order to come to a consensus plan that can then drive your production. But that's a very tightly managed structured process on a monthly cycle with specific events going on through the month and specific meetings in order to drive what's effectively a short-term planning decision. What are we going to make of which products in the next period of production? It feels like that same kind of ethos is needed on the bigger decisions and the longer term ones getting all the different functions, each function. So one thing I really believe is critical for finance is how do you look almost like the coordination, each part of the business have their own expertise. They understand what's going on, what makes marketing work. I don't understand what makes marketing work. There's a world out there of people who understand that what levers you can pull and where investment will pay off and what you need in order to have a successful product launch or ramp up a particular product line.
(00:34:45):
But how does that code, it's all very well marketing, doing a great job on marketing a product. What if the production capacity isn't there? So there's constraint or you shouldn't have been marketing that because there wasn't the demand and the statistical forecasts may have shown you that. So there's kind of tying all those pieces together and it seems like a key role of the finance team should be almost having a finger on the pulse of all those different parts of the business, how they connect, and then modeling that in such a way that you can explore what potential future states look like.
Host: Paul Barnhurst (00:35:21):
I'm sure you've seen this in your role and with companies how many times, and I've been guilty of it, you make a decision and you realise, oh, we didn't think about this or we didn't include that. It feels like the more and more we connect, the less that should happen, the better the data can speak to each other. And sometimes it's an fp a mistake. I've done a few, I've made my errors so to speak, but a lot of times it's just a challenge in knowing everything you need that help. And so I think you bring up a really good point and then you add in the complexity of more of an long-term. If you're thinking out of a year, it's one thing when you're doing production for a month or a quarter, the shorter the time, the more detailed you can be, the more accurate you can be. And even if you're a little bit off the less risk, right? One month. So a
Guest: Michael Gould (00:36:07):
Chance to be adjust, yeah, course correct is
Host: Paul Barnhurst (00:36:10):
A lot less expensive than if you get a year into something and you realise you did it completely wrong.
Guest: Michael Gould (00:36:14):
One of the things which I sort of feel like we should be aiming for in this space is you can't say no nasty surprises because nasty surprises can happen. COVID walls don't want to go into which plenty humans.
Host: Paul Barnhurst (00:36:31):
Humans are human,
Guest: Michael Gould (00:36:33):
Plenty going on in the world or just decisions that don't work out in the way you hoped, no outsides influence affecting it, but just products that just don't take off in the way that you expected that they would. So not saying that there should be no nasty surprise or no nasty events happening, that's part of life. But in a way I feel like there shouldn't be surprises because if you've modelled it, if you're modeling a product launch, you should have modelled it assuming it didn't go well, there wasn't the uptake you expected. You've had to weigh up a decision you've had to make a decision. That's what senior management execs have paid to make the call on those things. And they may get it wrong, but what you shouldn't be in a situation is where it goes wrong and you don't know the results of it are unforeseen and you're scrambling trying to model something that you hadn't thought about beforehand. It feels like you should know what the results of that be and almost get the very early indicators, okay, well it's not going quite as well as we thought. Therefore we are on track to this scenario that we have already modelled out if you like, our pre-planned actions that we can then put into play. And obviously things change and you have to rework things, but so well obviously you can get surprises, but it shouldn't be a complete surprise. That's what I'm trying to say.
Host: Paul Barnhurst (00:38:10):
Yeah, you should have a good idea. I mean, like I said, there's always going to be big things, macro things that come out of the blue that you couldn't have foreseen, but within that range of foreseen things, there shouldn't be big surprises. There's always a little bit of that unforeseen world. And even then, we all know at some point a black swan's going to come. You can at least model, okay, what could that mean for the business if it's a bad or good scenario in a black swan and how would we respond? You may not be able to know exactly what nobody knew and exactly what that would be like, but you still could have said, Hey, a black swan's coming, if one comes that has a significant impact on our business, here's some different things that could have, how would we think about that?
(00:38:56):
And so I'm with you, it's that idea within that range of known probabilities, you shouldn't have big surprises. Small ones are going to happen, but there shouldn't be big things. And that gets a lot into tools. But I think there's also maybe a little bit of skilling and I'd love to get your thought because Monte Carlo and a lot of things that help you do scenario and sensitivity tend to be more on the math side than a lot of finance people are in fp and a. You don't see a lot of the statistical modeling. So what's your thoughts there? Do you think as a profession we need a little bit more of that data science skill? I know AI is starting to fill some of that gap now making it easier, but just your thoughts in general because I've used some statistics and frankly I would've liked to use more if I did it again and learn Monte Carlo and some of those things. I feel like it's a little bit a weakness, but I'd love your thoughts.
Guest: Michael Gould (00:39:48):
Yeah, I think it's a really interesting question in terms of whether AI will move the bar. Yeah, bigger companies will have data scientists, they'll have, can't it used to be called operational planning? I dunno if it's called that anymore, but it's the teams who do this who are specialists and I think it's needed. And I think the question is, is it something that will, my gut feel is that it will come, that it will bring, that kind of analysis will become more available to much smaller companies who don't have the specialists. They probably need to take it with a bit of caution, but it could at least alert people to, like we were saying, scenarios that they maybe hadn't thought of or probabilities risks. I certainly see a role for that.
Host: Paul Barnhurst (00:40:51):
I agree with you. I think that's where we're headed. I think AI makes it easier to be a data science citizen I guess, or a citizen data scientist. You still need to know things and so that's kind of a challenge. There's still a fundamental knowledge you need to have, but you can get a lot further with the basics than you could before is kind of how I see it. But you got to take it with a graining salt like you said, because the less, more you can be surprised
Guest: Michael Gould (00:41:17):
In a sense I like to, there's not so much taking it with a grain of salt as more saying, okay, I'm not a statistician, I'm not a data scientist, sorry, I know I'm not going to understand the INS confidence levels that model has produced or whatever. But what I do know is I do know my business and I do know how the business works, and so I can at least put that sort of sense check on it to say, okay, well there's this possibility that there's a risk I haven't thought about. How does that look in my business? And bringing that kind of human instinct kind of instinct combined with experience to play onto the input you get from the tools that you don't understand in a sense, in a way, AI as a whole complete bucket in a way. It's a similar thing to a statistical model or data science model that it's a bit of a black box, but both are a bit of a black box.
(00:42:24):
AI is almost a hundred percent black box because it's all happening inside some the weights inside some LLM and the tool calls that are going on in the background when it says thinking with a little spinner, there's something happening, I don't understand. I don't know what it's going on exactly, and some results come out and I have to assess the results. And in a way, what you're saying with things like statistical methods, it's almost, if you're a non statistician, you almost have to take 'em in the same way. Well, yeah, I don't necessarily understand how it got to it, but I can absorb and assess what it's presented me with. But critically is the important thing. You can't be noncritical about it, but bring your own understanding of the business and of finance and to bear.
Host: Paul Barnhurst (00:43:15):
I often hear finance leaders say, I know I need FP&A software, but I don't even know where to start. That's why I created the FP&A software showcase. So you could see top tools in action. This year we're featuring drivetrain and UN a AI on the planning side, and for the first time ever, we're adding two leading AI analyst agents on the market, concourse and sapien. These tools are already being deployed at public companies. You will get to see actual demos without the pressure of a formal sales pitch. Ask your questions and compare tools all from the comfort of your chair. Join me on May 21st for the showcase. Register for free at the fp a guy.com/fpa software showcase. That's the fpna guide.com/fpa software showcase. See you there. Yeah, you don't have to understand, I think what you're saying there, you don't have to understand all the math behind it, all the details, but you have to be able to do a sense check. You have to understand enough to look at it and say, okay, this is realistic, or no, something looks totally off here. I need to dig deeper or rerun this or whatever. So it's kind of that judgement level that you have to bring regardless of whether you understand everything because black box transparency, none of us understand everything that's going on behind ai, but we have to be able to look at it and decide, does this look right enough that I can use it? Is there enough here that I trust it?
Guest: Michael Gould (00:44:58):
And of the bits that I can see, is it giving me visibility to things in terms of things like the calculation logic and things like that?
Host: Paul Barnhurst (00:45:08):
Yep. No, makes sense. So I want to move into our fp a section. There's a couple questions I ask every guest. There's two I pretty much always ask, and so I'm curious what you'll say coming from a different perspective than the typical guest I have that usually works day-to-day in fp a. What do you think is the number one technical skill that FBNA professionals should master?
Guest: Michael Gould (00:45:29):
So right now we've been talking about it ai, and I think why it's critical is because I think there's a huge shift happening and some people are kind of at the forefront embracing it and exploring it. Some people are sceptical, don't really believe it, but I think, and I've seen this recently within our business in different areas, just being prepared to understand, try almost replacing your own job with an AI tool to say, can I get the AI tool to do what I'm doing today and see what works and understand, because I think it's a lot of opportunity. There's a lot of pitfalls and things are going to change a lot. So I would say understanding how that impacts your day-to-day work and what the opportunities are and what the risks are. You can't do that without actually just trying it hands-on and is not that difficult to do.
(00:46:42):
You can just spin up any of the AI tools and try stuff if you are doing it. And I would recommend a paid subscription because then they come with a licence agreement where they're not, whatever data you share isn't being used to train the AI model. Just to flag that one up just on behalf of anyone who's thinking about doing this. If you stick all your company finances into an AI tool and you haven't got a subscription with a zero data retention policy, you have just provided the AI tool with some learning data for the next time round. So you need to be cautious and look at the data retention policies, but using tools to build a spreadsheet using tools to drive the whatever other tools you're using or just to explore what it can do for you. And to me, that's a very different answer from what I'd have given even six months or a year ago just because of the shift I've seen in really in a space of a few months, the level of reliability of what's coming out, the ability of tools, like we've talked about, generating spreadsheets. You've at least got to understand what it's capable of and keep up with it because what it can do now, you might have your best efforts and think, okay, that was load of rubbish, it didn't do what I want. I could have built that myself with far fewer errors and done it. That might not be true in six months time or even three months time. And so keeping current on that to me is the number one technical skill that FP a professionals should be investing in right now.
(00:48:27):
Which is, in a way, it's interesting because it's not an fp a skill, it applies to as much new. I've had similar conversation with people on my design team at cly Scope where even six months or a year ago if we wanted to do a working prototype, we'd write some code and knock up a working version of something just so we could put it in front of people to try it out, get a bunch of engineers building it, and we don't need to do that now because we can just use tools that we'll generate to really convince seeing UI that you can try out with people. So suddenly the ground has shifted and the designers, they can try out prototypes that they couldn't do even six months ago on a very tight turnaround. And so I think just keeping abreast with that and seeing how that impacts your day-to-day work. And I'd say almost do it with everything. Do any task if you're in accounts, do you reconciling your bank statements, how can you automate that and just see what happens and often be surprised.
Host: Paul Barnhurst (00:49:41):
It's a great point on the ai, it's an answer I expect to see more. I think I've only had it maybe the second or third person so far, but I've been doing this for a couple of years and I think we've all seen that become more and more important.
Guest: Michael Gould (00:49:56):
I think there's something in my mind, something has shifted literally in the last few months.
Host: Paul Barnhurst (00:50:02):
I agree.
Guest: Michael Gould (00:50:02):
Experiments that we were doing last year and getting just very, very different results. I'm a software engineer by background, I'm not a finance person. You're seeing what the, and that's the space where, because AI tools are built by software engineers, that's the first thing that they've tried to crack is because the people who are building it understand the problem they're to. So that's almost the kind of leading indicator on where things are heading. And it is quite extraordinary what tools can do in terms of understanding a complex code base, making changes quite successfully and safely and presenting you with reasons why those changes were made. It's extraordinary. And that I didn't think that was true that long ago. It was people trying it and the people who are really enthusiastic would make progress, but normal people wouldn't. Something shifted. And so I would say that's the number one technical skill to invest in.
Host: Paul Barnhurst (00:51:10):
Alright, what about softer human skill?
Guest: Michael Gould (00:51:12):
Coming back to what we talked about earlier in terms of this kind of coordination? So I feel like two things really. One is that just recognition, understanding that the finance team, sorry, quick anecdote. One of the people I worked with back at IBM, he used to say, well finance, we made our numbers what the rest of you guys doing? But at one level, finance, they don't contribute anything to the business. They don't sell stuff, they don't make stuff. So understanding, okay, so what is your role? It's that supporting role in terms of the decision making of the business. So in terms of the soft skills, I feel like this kind of making the connections is between the different people and trying to make sure that almost enabling the communication, don't get lost inside the technology, but understand the extent to which what you're doing is enabling different parts of the business to talk to each other, but talking numbers to each other. Because at the end of the day, it's going to have to boil down to specific concrete things, how much you spend, how much you produce, how much you store all those, how many people you employ, what you pay them, all those decisions.
(00:52:43):
But acting as that kind of coordination in whatever job you're doing because you're working on the financial models, but you touch, you've got touch points across the business and so there's no reason why you shouldn't be more than just the number cruncher who kind of pulls this stuff together by burning the midnight oil low hunched over your spreadsheet. I feel like there's an opportunity to do something that's far more, contributes a lot more to the ongoing success of a business than just that.
Host: Paul Barnhurst (00:53:21):
Thank you, appreciate that. I like both of those half fast this because I'm curious, as somebody who very much focused on multidimensional modeling and seen Excel survive for 40 years now and continue to be arguably the most used software in the world, what do you see as its greatest strength if you had to list one and maybe it's greatest weakness?
Guest: Michael Gould (00:53:44):
So I think the greatest strength, there are many. I mean clearly it wouldn't have survived as a tool if you hadn't got some extraordinary good qualities about it. I think it's a combination of the fact that it's so quick and simple and easy and natural to get started. You can open up a spreadsheet, you can just type in some stuff or copy and paste some stuff in, do a calculation, which you only need to learn how to point and click and you can start to build something so you can get up and running remarkably easily in expert hands. It can do, you're basically almost unlimited. I'd say almost. There are some big caveats to that because any experienced Excel user will understand, they could push it so far and then there would be another level of complexity that wouldn't just be a bit more work, but it would completely become completely infeasible. So there is a ceiling on the complexity that Excel can handle. It goes quite a long way and especially if you start writing macros and things, then yeah, you can start to push the barriers. It's amazing
Host: Paul Barnhurst (00:54:57):
How far you can push it. You can push it in the hands of a capable person, but
Guest: Michael Gould (00:55:02):
You
Host: Paul Barnhurst (00:55:03):
Hit a limit.
Guest: Michael Gould (00:55:04):
You hit a limit, but you don't hit a brick wall. It's more like you hit a curve that's going up steeper and steeper. You what I mean by the analogy, it's like, yeah, you can get a long way and then it gets harder and then the really good people can get a bit further, but it's getting harder and harder and harder. But doesn't actually, there isn't a hard stop where you've got a tool where it says, okay, well no, you just can't do that. It's not supported in the tool. You never hit that kind of a brick wall. It's incredibly flexible. You can apply it to any kind of problem. So I think those are the strengths, very easy to share. And you can email spreadsheets around, so it's great for collaboration. Conversely, that's nightmare for the poor people in FP&A who got to try and pull the whole stuff to get back together again.
(00:55:59):
Greatest weakness I think is the fundamentally, it's not a good representation of your business. If you think, what are the constructs in Excel in a spreadsheet, obviously there are online spreadsheets too, but the constructs are, you've got a workbook which has got sheets, it's got rows and columns themselves as a grid. And your business doesn't work in terms of sheets and rows and columns. Your business deals with products and product lines and employees or people, contractors and employees, customers and numerical metrics. So it's basically dealing with a different set of constructs and your are using a spreadsheet metaphor to represent those. But in Excel, in a spreadsheet, there's no meaning attached to a number. So if I type in 5,000 in a cell, the only reason it has any meaning is by looking typically to the left and above and seeing what other bits of information have been put in the headers in the same column or in the same row and maybe the sheet name as well, or maybe a header somewhere up on the top left. The meaning of that number is only there by inference. Remarkably, the AI tools are beginning to get quite good at figuring that stuff out and therefore understanding what's going on. But there isn't any kind of coherent data structure that says, okay, that was a sales figure for this product of sales forecast for this product in this month within this region.
Host: Paul Barnhurst (00:57:42):
It
Guest: Michael Gould (00:57:42):
Doesn't have that information. The information is all implicit and depending on how tight you've been about constructing the thing, it's quite, it may or may not be good. You can do it without them. The labels in there if you know what.
Host: Paul Barnhurst (00:58:00):
So
Guest: Michael Gould (00:58:00):
I think in a way the weakness is the fact that
(00:58:06):
It's not a close representation of your business. It doesn't deal with the lists of things that you care about, the people, the products, the locations, all the fundamental metrics, drivers ratios, all those things that you are interested or your accounts from your accounting system. Those constructs aren't actually represented in it. And then there's obviously a whole bunch of other weaknesses in terms of things like collaborations, sending a bunch of spreadsheets out and everybody inserts a row and it goes all out, changes the formula or whatever. And all that fun and games that any fp a person will be only too familiar with. But that's more of a kind of just practical logistical challenge.
Host: Paul Barnhurst (00:58:56):
We've all been there on those, so appreciate that. I want to just ask you one or two questions, kind of get to know you a little bit better, help our audience get to know you and then we'll wrap up here.
Guest: Michael Gould (00:59:06):
Yep. Great. Thank you. First,
Host: Paul Barnhurst (00:59:07):
What do you like to do to unwind? What do you do in your spare time when you're not working on kaleidoscope?
Guest: Michael Gould (00:59:12):
So firstly, I'm a Christian. My faith is really important to me in that, yes, it's not just outside. I see that as something that I try to live out both in work and outside work. I play the guitar, love guitar playing classical guitar and acoustic. I have a little folding guitar. So when I was a Anaplan, I was travelling. I was in San Francisco about every six weeks or so, and also trips to other parts of the world on sales visits. So I always had a little travel guitar with me to carry around. So I played the guitar and I started running, and this was after kind of winding down Anaplan and managing to get a bit more time and trying to undo a bit of the damage of 10 years of flying around the world, spending too much time in airports and hotels. So I run, yeah.
Host: Paul Barnhurst (00:59:56):
Okay, great. And then I appreciate sharing the Christian party. I know some of that. I know you and your wife have done a lot of fostering of young refugees. Share a little bit of that experience. How'd that kind of come about? We'd love to just share a little bit.
Guest: Michael Gould (01:00:10):
Yeah, so we have a big family. We've got four birth children and three we've adopted at the time of the Syrian refugee crisis, which was, I guess, I'm trying to think about 10 years ago now, we saw images of terrible things happening and we basically said, we can't just sit by and do nothing about that. This, we've got space in our house, we've got the means. We decided to start fostering and specifically to foster unaccompanied asylum seeking children, and we've been doing that for the last, so we had to go through, we signed up through a local authority, got the training and did that. So we've been doing that for the last nine years and it's been a wonderful journey. I mean, we specifically, we do fostering for teenage girls who've arrived in this country either as refugees or as asylum seekers. Obviously it doesn't take much imagination to guess what the experience of girls who've been travelling alone across Europe is like they come, they're very traumatised, have had a really tough time.
(01:01:07):
It's just wonderful to be able to provide a place where, a big house where they can be safe, they can get back on their feet, they can get back to school, get back to college, learn skills, and we've had quite a few now who've moved through. Now they're safe, they're happy, they're living independently, making a life for themselves. That's just a real joy to see. And yeah, in terms of, you asked what I do in my spare time or we've currently got eight people hides my wife and myself in the house, so it's a busy household as well.
Host: Paul Barnhurst (01:01:35):
Is there really any free time with that many in the house? Right?
Guest: Michael Gould (01:01:38):
Yeah, there's a lot going on
Host: Paul Barnhurst (01:01:40):
And that's why you're out in the barn, so to speak.
Guest: Michael Gould (01:01:41):
Yeah, so I have this little shepherd tuck down the bottom of our field where I hide away so I get on with the business.
Host: Paul Barnhurst (01:01:46):
Understand that one. Thank you so much for joining me, Michael. It's a pleasure to chat. I loved hearing some of the backstory and just how you think about these things and all the work you've done. I mean, one of the experts out there, obviously in this space with 40 plus years of experience, and before we finish here, if someone wants to learn more about Kaleidoscope or maybe get in touch with you, what's the best way for them to do that?
Guest: Michael Gould (01:02:11):
The best way would be, well obviously go to our website, kaleidoscope.com, drop us an email hello at kaleidoscope com. The thing we're particularly looking for, so we are not launched commercially yet. The thing we're looking for, we'd love to talk to people who are, particularly people in finance teams who are struggling with spreadsheets. If you're in a finance team in a small business, we'd love to have a chat to understand what are you looking for in a system. What are the tools you'd love to have to help you do your job better? We are busy building something, and we'd love to just hear from people who would like to dive into an early adopter engagement. Participating in the process of building this next platform is an opportunity to jump in early and have a bit of influence about what we build. So yeah, love to hear from people. Well,
Host: Paul Barnhurst (01:02:53):
Great. Hopefully you do hear from some people. Really excited to see what you end up building and see the product when you're ready. And thank you again so much for carving out some time. It was a pleasure chatting with you.
Guest: Michael Gould (01:03:03):
Great. Thanks fool. Really great to spend time with you.
Host: Paul Barnhurst (01:03:05):
Thank you. That's it for today's episode of FP&A Unlocked. If you enjoy FP&A unlocked, please take a moment to leave a five-star rating and review. It's the best way to support the FP&A guy and help more FP&A professionals discover the show. Remember, you can earn CPE credit for this episode by visiting earmarkcpe.com. Downloading the app and completing the quiz. If you need continuing education credits for the FPAC certification, complete the quiz and reach out to me directly. Thanks for listening. I'm Paul Barnhurst, the FP&A guy, and I'll see you next time.