How Generative AI is Revolutionizing FP&A Processes for Financial Leaders with Bryan Lapidus
In this episode of FP&A Tomorrow, Paul Barnhurst discusses the ever-evolving field of financial planning and analysis (FP&A) with Bryan Lapidus. They explore the shift from traditional roles to value-driven finance. The discussion focuses on the rising importance of generative AI, and examines the essential skills needed for success in the field.
Bryan Lapidus is the Director of the Association for Financial Professionals (AFP) and a leading voice in the FP&A community. With decades of experience spanning senior roles, an MBA from NYU, and a history of helping finance professionals elevate their skills, Bryan brings a wealth of knowledge on FP&A trends, certifications, and technological advancements.
Expect to Learn:
The evolution of FP&A and how specialization is reshaping the field.
The critical role of generative AI in finance and practical advice for adoption.
How the FP&A certification can boost career growth and salary potential.
Differences between value-creating and control-focused CFOs and why it matters.
Key technical and soft skills to thrive as an FP&A professional.
Here are a few relevant quotes from the episode:
"To excel in FP&A, you need the why, the what, and the how: why we allocate capital, what we deliver, and how we use technology and people." - Bryan Lapidus
"When finance focuses solely on controls, it limits its ability to contribute to the company’s growth." - Bryan Lapidus
"The rise of data analytics in FP&A means more roles require coding knowledge like Python and SQL." - Bryan Lapidus
In this episode, Bryan Lapidus shares the transformative impact of technology, and the skills that define the role of FP&A. He emphasized the importance of value creation, specialization, and adopting tools like generative AI while staying grounded in foundational skills.
Plan Smarter with Workday:
Workday Adaptive Planning empowers organizations with AI-driven insights, advanced data visualization, and powerful reporting tools. Make smarter decisions faster and elevate your budgeting, forecasting, and modeling. Learn more at http://www.workday.com/fpaguy
Follow FP&A Tomorrow:
Newsletter - Subscribe on LinkedIn - https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=6957679529595162624
Follow Bryan:
LinkedIn - https://www.linkedin.com/in/bryan-lapidus-fpac/
Follow Paul:
Website - https://www.thefpandaguy.com
LinkedIn - https://www.linkedin.com/in/thefpandaguy
World-class Digital FP&A Course Bundle:
Signup for over ten hours of video content with 4 different courses and 8 modules on FP&A topics including: Business Partnering, Data Analysis, Financial Modeling Design Principles, and Modern Excel. Use code Podcast to save 25%. What are you waiting for signup now: https://bit.ly/4bX9WST
Earn Your CPE Credit
For CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions and earn your CPE certification. To earn education credits for FPAC Certificate, take the quiz on earmark and contact Paul Barnhurst for further details.
In Today’s Episode
[01:43] - About Bryan Lapidus
[03:04] - Defining FP&A
[06:30] - Challenges in FP&A
[10:30] - Bryan’s Career Journey
[14:51] - AFP Overview
[19:09] - AI’s transformative potential
[29:55] - FPAC Certification Value
[32:59] - Value-creating vs. Control-focused CFOs
[39:46] - FP&A Standard Questions
[50:36] - Advice for FP&A Professionals
Full Show Transcript
[00:01:43] Host: Paul Barnhurst: Hello everyone! Welcome to FP&A tomorrow, where we delve into the world of financial planning and analysis, examining its current state and future prospects. I'm your host, Paul Barnhurst, aka The FP&A Guy, and I'll be guiding you through the evolving landscape of FP&A. Each week, we're joined by thought leaders, industry experts, and practitioners who share their insights and experiences, helping us navigate today's complexities and tomorrow's uncertainties. This week, I'm thrilled to be joined by Bryan Lapidus. Bryan, welcome to the show.
[00:02:20] Guest: Bryan Lapidus: Paul, great to talk to you as always.
[00:02:22] Host: Paul Barnhurst: Yeah, I'm really excited to have you. I know you just finished an overseas trip and excited to chat with you. Maybe we'll get to hear a little bit about that as we go through things.
[00:02:33] Guest: Bryan Lapidus: Sure.
[00:02:33] Host: Paul Barnhurst: All right. So just to give a little background on Bryan, Bryan is the director for AFP. He is the crazy guy who helps with the conference every year. And if you see him by Wednesday of the conference, he looks like he needs a week of vacation. He spent his career in FP&A. He did an MBA from NYU, did an undergrad history degree, which we might ask him about, and worked for a number of different companies in senior roles and FP&A. So let's start with this question. If you had to define FP&A and you only had one sentence to do it, how would you define it?
[00:03:12] Guest: Bryan Lapidus: Well, you know, I have a lot of words, so I feel like you're really handicapping me by saying I got one sentence. That's the goal. That's the goal. All right. FP&A is the part of the CFO organization that provides actionable intelligence for where you're going to put your next dollar of capital.
[00:03:27] Host: Paul Barnhurst: I like it actionable intelligence of where you're going to put your next dollar of capital. So I had someone who defined finance. I don't know if you know who Stu West. He's the CFO of Grammarly, our former CFO. He just stepped down like a month or two ago, and he's advising them. And he summed up the finance function in three words. And it was one of my favorite definitions. He's all better, faster. Decisions like help the business make better, faster decisions.
[00:03:51] Guest: Bryan Lapidus: So I see where he gets that. And obviously Stu is an expert in his area. I would take a bit of a broader view, right. So I think of the CFO as the steward of enterprise capital, and that means managing its sources and uses from where it was, where it is and where it's going, where it was. Right. We call that accounting. We call that controllership. We call that audit. Right. To make sure you've got all your controls in place where it is in that circulation. I think of that as treasury. And then the FP&A part is where it's going. The next step. Where do you put that next dollar?
[00:04:24] Host: Paul Barnhurst: Yeah. And I agree for all three functions. Yeah I think that makes a lot of sense. So speaking of FP&A how would you define great FP&A. What does that look like? I'll give you more than a sentence here.
[00:04:36] Guest: Bryan Lapidus: Well, here this is where I would go with Stu's definition. Right. Better decisions faster. It's creating value through decision support, capital allocation and performance management. I think that the way that FP&A does that it has it's the why, the what and the how. Right. So that's the why. The why: is put the next dollar of capital to its best use. The what: is “what do we deliver?” We deliver it through our financial processes of planning and budgeting, through management, reporting and metrics and decision support. Financial analysis. Right. So that's the “what we do”. And then the “how we do that” through having good technology on the back end. Right. You have to be able to be good backstage in order to be good on stage. And then the other how is our people. Right. You have to have people who have the psychological safety to question, to search and to seek out, who have the growth mindset, to experiment and try different things, who have the training to be good at their job. And yeah, I think that's the why, the what and the how of FP&A.
[00:05:41] Host: Paul Barnhurst: And I think I just won bingo. We had capital allocation, psychological safety, growth mindset. I think there's a couple others I agree with all of them. But, you know, I just was joking that I won my bingo card.
[00:05:55] Guest: Bryan Lapidus: But that's why it's so hard to find a great FP&A person. Right. It's a little bit of, you got to know a little accounting, and you got to know finance, and you got to know economics, and you got to know how to communicate and business partner. You've got to have the right. It's hard to find all of that. I've had members of my advisory council tell me that it's a little bit like an apprenticeship in order to get good at the different areas, or you build a team and the team has that expertise, and you can pull the team together to tap into that.
[00:06:25] Host: Paul Barnhurst: I agree. I mean, it's hard enough to be really good technically and soft. And what we're seeing is we're seeing FP&A being asked more and more, right, more strategic. Be you're seeing more kind of data science stuff being asked sometimes be more commercial. And, you know, it's tough. How do you find one person that does all that? If they do all that and they're really good, what's the odds that they're not going to move up really quickly and be in some other type of role. And so it becomes tough. So there's the trying to find the right team with the skills, and also trying to find those individuals that are really good in certain areas or holistic enough to really move the business forward.
[00:07:07] Guest: Bryan Lapidus: I think you put your finger on the change certainly in my career. Right. So I was 20 years in the office of the CFO and now at AFP. I've had this time to really study FP&A as it's changed over time. And it used to be that you would look for all of that in one person, right before the job was really well defined. You had to have that all in one person and kind of the Swiss Army knife, right? Everyone's got a tool for everything. What I really see over the last decade is that maturation has led to specialization and that especially and you see it really in the larger companies where they'll have a reporting team and they'll have an analytics team. And so as the field has become more defined through conferences and certifications and classes and training and, you know, people like you being a great voice to talk about what we do as the field develops its own identity. It is gaining specialization in those areas and really just getting better and better at it.
[00:08:09] Host: Paul Barnhurst: Yeah, I mean, you're definitely seeing more and more of the specialization. You know, you have the corporate reporting side. You have those people that are more business partnering in the sense that they sit in the business, support the general manager. Sometimes you have the data science person you're starting to see FP&A sometimes have the strictly that finance transformation or I mean, I had a role in the title of it, and I kind of have to laugh because I had nobody report to me, but boy, was it a title. I was the director of FP&A sales, Operations and Analytics.
[00:08:41] Guest: Bryan Lapidus: All of that.
[00:08:43] Host: Paul Barnhurst: All of that. And what it was is it was the coordination role because the business was trying to switch to be SAS. It was trying to coordinate with cells and analytics and FP&A to get the data and the reporting right. And so it's really just a coordination. It was very special. I didn't do a single budget in that year. I had the role. I mean, I helped the business with it, but I wasn't doing budgeting. And I reported to the VP of FP&A. And so it just kind of shows how specialized sometimes you can be. Even though I was in the FP&A department, it was an FP&A role. It wasn't traditional at all, it was specialized.
[00:09:16] Guest: Bryan Lapidus: I had one CFO explain. He said, I know what FP&A is. It's everyone who reports to me who's not in Treasury tax or accounting. Right. But that's because, you know, at that time, FP&A wasn't defined. Right. It was all business analyst. The expense analyst. The financial analyst, the partner. Right. All these other things that are concerned with making helping the business do better decisions faster, allocate their next dollar, whatever you want to call it. Right. It's everybody else. And when you think about that right then you can actually say, all right, this is what FP&A is. Here is the skill set that you need. Here's the network of people you want to meet in order to grow your skills. Right now, we can really define how to help you be great at your job. Yeah.
[00:10:04] Host: Paul Barnhurst: And I think for many years it was really difficult to define what is FP&A. I think we've done a good job now of defining the core. But there's still go company to company. There's rev ops. In fact many smaller companies often it does sales commissions or they calculate so many little edge cases. But I think we've at least got the core well defined at this point. Your thoughts? What do you agree with that?
[00:10:28] Guest: Bryan Lapidus: Spot on. Couldn't have said it better.
[00:10:30] Host: Paul Barnhurst: All right. So now I'm going to kind of step back a little bit and ask a fun question that takes you back a few years. You did a history degree. How did you make that transition into finance? I know you ended up doing an MBA, but if I remember right, you were doing some finance before you went back and did your MBA. So how did that kind of come about.
[00:10:48] Guest: Bryan Lapidus: Yeah. So I was an undergraduate history major and Spanish language minor to just to go even further into liberal arts. And I started taking graduate history classes. I then actually my first job was at the Smithsonian, and I guess maybe the first ROI I did was trying to figure out the return on a PhD and a career in history, and I just decided that it just the business prospects, the future prospects. It just wasn't what I wanted. It wasn't going to take me to how I wanted to live, and I wasn't going to be able to do the kinds of things that I had wanted to do and explore. So I still listen to history podcasts. I still read, read history. I watch Crash Course History, you know, all four different channels of it on YouTube. But career wise, I took a couple different steps. I traveled abroad, I lived abroad, and then I came back and wanted to keep that international experience and exposure. And the only job I could get was in the office of the CFO. So I moved from there. While I was writing about tracking and rating mutual funds, which exposed me to the market, I was in consulting, and that was really it was in consulting. It was being forced by my partners, by my bosses to say, well, what's the economic rationale behind your recommendation? And they just kept drilling that in. Right. Strategy by itself is not enough. How does it make economic sense? And I realized I had a deficiency. I couldn't figure that out. I couldn't answer that as well as I wanted to, which ultimately led me to go back to my school. I got my MBA in finance and management, and I've been in finance ever since.
[00:12:30] Host: Paul Barnhurst: Well, there you go. So basically, you did an early on ROI and realized that lifestyle goals and history degree probably didn't align as well as you'd like.
[00:12:43] Guest: Bryan Lapidus: Exactly.
[00:12:44] Host: Paul Barnhurst: So what's your favorite history podcast, you mentioned the four YouTube channels. Do you have a favorite or favorite history book?
[00:12:50] Guest: Bryan Lapidus: My favorite podcast is "The Rest is History" which are two gentlemen out of the UK, and they kind of take a topic. They go pretty deep into it. So they just did seven hours on the French Revolution. You know, they pick something and they really go in depth book wise. Anything by Eric Larson, his books read like movie screens. It's amazing.
[00:13:12] Host: Paul Barnhurst: You say Arc Larson? Eric, Eric Larson, Eric Larson. I'll have to check them out. I haven't read him. Todd McCullough has always been one of my favorite on the history side. I like his stuff.
[00:13:21] Guest: Bryan Lapidus: Classic.
[00:13:21] Host: Paul Barnhurst: All right, well, now we'll get to AFP. You've been at AFP. Is it six years now?
[00:13:28] Guest: Bryan Lapidus: Six years? It's true. And before that, I was a member. You know, I liked it so much. I joined the company.
[00:13:35] Host: Paul Barnhurst: And there you go. You get your membership, and then you decided you didn't want to leave. So you figured you just joined the team.
[00:13:40] Guest: Bryan Lapidus: It started when actually, it started when I was in Treasury and I was looking just to keep my knowledge going. And at that time AFP was just Treasury only. And I was excited to find when I moved into FP&A a couple of years later, that they had opened up the FP&A arm with the certification and the conference tracks. That was about 2010 through 2014. They did that, but I was in a position and I knew that I was going to be changing jobs, and I was wanting to say, well, you know, how do I demonstrate when I go for an interview that I'm more than just someone who can handle the numbers? How do I demonstrate that? I think about things differently. So I got involved just by writing some articles, reflecting on what I'd done. I went to a conference. I ended up teaching, speaking at conference and then teaching a class at conference. And so as a member, it helped me to raise my knowledge, my profile and to network. And then I got to tell you, I went to conference and I just loved it. I was blown away by what they could do. What now we can do, putting people out there and just the feel of people sitting around being really excited and geeking out about finance topics.
[00:14:50] Host: Paul Barnhurst: Nice. So tell our audience, for those who aren't familiar with it, what AFP stands for, and kind of just a little bit of what it is.
[00:14:58] Guest: Bryan Lapidus: Sure. So we are a not for profit. And we do. I would say four things. One is we do conferences, we do so events in general. We just had our largest conference and I believe it's the world's largest in our in the corporate finance space, we had almost 7000 people, 130 educational sessions. We had Malcolm Gladwell as a keynote. We had six different keynotes. We were in Nashville and it was amazing. Second, the second conference that we have is one that is just for FP&A, and that's coming up in March. So that'll be a little bit smaller. Probably 25 different sessions, all FP&A focused. They're usually when people talk about this event, they say, I found my tribe, right? Everybody there is FP&A. They understand what it is and will have the breadth. And like everything else we do, it is education focused people. You know, vendors can't buy their way into sessions. It is a competitive review to get a speaking slot. So those are the kind of the event side. The second thing that we do is certification. We have two certifications, the CTP, which is the certified Treasury professional, and the FPAC, which is FP&A professional. The two certs, over the 40 years that we've been in business, more than 40,000 people in 70 countries have earned them so really well established in the marketplace. Third is training. We have a corporate training business and we will make, we have either generalized off the shelf sessions or we will make bespoke sessions for businesses. We have a panel, a stable of professors of practitioners, consultants who are really experts in their area. And then the fourth is membership, which is some things are behind a membership paywall. A little bit more in the community focus, as well as discounts on all the other events. Those are the four things that AFP does.
[00:16:50] Host: Paul Barnhurst: When it comes to business planning. Staying ahead means planning smarter. Whether it's forecasting, budgeting, our long term strategic planning, you need a solution that's built to scale with you. That's why more growing businesses turn to workday adaptive planning. It's designed to empower organizations to move beyond spreadsheets and into a connected, agile future with powerful AI. Workday Adaptive Planning delivers insights that help you make better decisions faster. Our advanced data visualization and powerful reporting tools make it easier to elevate your budgeting, planning, and modeling. It's time to start planning smarter. Discover how at www.workday.com.
[00:17:46] Host: Paul Barnhurst: Got it. Well thank you I appreciate that summary for you know, anyone who's not familiar with them. So thank you for doing that. What are the main benefits. Why should somebody join. I mean, obviously I'm going to guess most people who are joining aren't going to end up working for AFP like some. So why should they going what are the benefits.
[00:18:06] Guest: Bryan Lapidus: So you can take part in all AFP activities either as a member or as a nonmember, right. So we have the member and we have called the broader community by paying the membership fee all 495. Then you get discounts and it really pays for itself in terms of discounts on conference, on certification, on some of the webinars or some webinars actually do have a payment component, but also some of our research, which is proprietary and deeply well executed. Some of that is behind the paywall. Other bits are available to everybody for the community.
[00:18:39] Host: Paul Barnhurst: Great. Yeah. And, you know, full transparency. I've been a member now for 2 or 3 years, I believe. I think I'm coming up at the end of my second year of membership. And so I know what you're talking about. You know, and I've done the certification now. I did the FPAC last year before, but almost a year and a half now, I think I'm a little over a year ago when I got it. I think it was about this time last year. So excited there. And a big fan of what you guys do. I appreciate the work you do to help the FP&A community. And speaking of the FP&A community, we've talked to some of the challenges of hiring the role. I'm curious, what are you hearing from finance leaders around generative AI? What's kind of the buzz there? Because that obviously seems like that's been for the last 24 months. All anyone's talked about at times is AI and how it's going to impact our work. So what are you seeing and hearing from the leaders out there?
[00:19:33] Guest: Bryan Lapidus: You know the phrase, when all is said and done, a lot more is said than is done. Yes, that's where we are at the moment. Everybody is. Everybody is still wondering what it looks like. And there are lots. So first of all, we're going to split out gen AI versus machine learning AI.
[00:19:49] Host: Paul Barnhurst: Thank you. I totally agree the split them.
[00:19:53] Guest: Bryan Lapidus: Right. Because the ML version is a lot more data sciency different kind of tools. And it's a different process and a different step. Gen AI people are trying to figure it out. They're trying. There is genuine concern about data security and privacy. We've seen lots of people seem to be figuring that out with small language models instead of large language models, and really concentrating on your own data. And so broad, bringing that in-house is helping to resolve that. I see a lot of text based use cases. So in the healthcare sector, I know one company is reviewing all of the state level laws and by laws of what they can do to make sure that they're in compliance. Other companies are looking at contracts to test service level agreements. I really see gen AI being integrated into the tool suite that we have already. That it'll be a front end like copilot. You can talk to it and it will go and do things on the back end. It will help you write your SQL query. It will help you to create your Dax code on the back end and help you in that way. Roughly speaking, I would say a quarter of people are using gen AI on an industrial scale, right? Daily, weekly, quarterly. They're doing real finance with it. The next tranche, maybe 40 to 50%. They are. They have plans to either implement or put a formal pilot in place in the next 12 months. And then the balance are either trying to figure out how to start or honestly, their companies won't let them start. There are companies have policies or restrictions in place that will prevent them.
[00:21:36] Host: Paul Barnhurst: Got it. So you're saying about 25% are using it regularly now? It's kind of part of that process. Another we'll just call it 50% for simple math. You said 40 or 50 is, hey, we're planning on implementing it in the next 12 months. We're working on getting there. We might be able to use it a little bit, and then there's some percentage. I think you said about 10% or so where the company is just like, nope, there's just not a path to that right now.
[00:21:58] Guest: Bryan Lapidus: Yeah. So on the bell curve, right. So a quarter are your advanced users. About 50% are in the middle. Light users are planning for the next 12 months. And then another quarter are on the back end. And they are somewhere in between. I don't know how to start and my company won't allow me to use it at all.
[00:22:16] Host: Paul Barnhurst: Sure. Early adopters. Late adopters for whatever reason. And the typical bell curve in the middle. Amazing how that works. How often that is the truth. So any advice you'd offer to people listening and they haven't really got started? Where should they think about getting started with AI?
[00:22:34] Guest: Bryan Lapidus: So the short answer is any way that you can, any way that you can get on it, use it, experiment with it, break it, don't break it. Right. Obviously you want to stay within your compliance rules, but the first answer is to just get on board. Second is there's a little bit of a buy build rent. If you're not ready to buy it yet, you're not ready to create your own. Or I guess, I guess if you're not ready to build your own, there are ways to buy it. And I think that we're going to see it becoming more resonant inside software, right? So the software you already use is just going to have that as a layer. And I see this through all the EPM tools. All of them are saying they have gen I, some are maybe fudging the definition a little bit and saying, well we we're calling it AI, but it's really automation. It doesn't matter. That way. It is going to be built in to all the software that you have or that you will buy. So it's coming and that's the easiest way for it to get there. And then the rent part is partnerships. Working with vendors, bringing people on contractors, support staff that can help you in the short term to bridge that. And that's how people are getting that familiarity until they can bring that resident skill set in-house.
[00:23:52] Host: Paul Barnhurst: Yeah. And, you know, it's definitely a developing skill set. What does it mean to be an expert in gen AI? Right. Everybody's going to have a different opinion and different ways of using it. Now a couple of things I think I like that you said there is one. The software is integrating it. It's coming. Definitely. Some are fudging. You know, when I first came out, they had their ten year old algorithms and all of a sudden they were now marketing it all as I write, because everybody had to market that they were an AI tool, whether it was Gen AI or not. Now you're starting to see them build it in. And I heard someone say, where we want to go is you want it to be Active and not notice it's there in a lot of cases. Okay, so I'm doing commentary. I saw a tool the other day. You could have it automatically tell you the what. Like bring it up and then you start adding your details just like hey, write in the comment line, not off in some chat bot, but you can just have a tell me what happened here and it brings it up. I've seen the other ones with early warning signals and different things to be more proactive, and that's what has me excited. When does it get to that point where it's kind of naturally built into the processes, and it helps us be better throughout the day?
[00:25:04] Guest: Bryan Lapidus: Exception reporting is a great use case. What number looks odd signal these aberrations to me, being able to build baseline forecasts. And then you can layer on your expertise and things you don't that you know that the machine doesn't know. But really to be able to do the ugly part of, of FP&A, you know, that you used to have armies of people whose job it was to aggregate data and roll it up so that other people could make that decision. Right. What if we had more people on the insight level and less on the aggregation level? I think that's where we all want to go.
[00:25:40] Host: Paul Barnhurst: Yeah. And, you know, I'll get your thoughts on this. I've heard several people say this, and right now I agree. We'll see long term. But I'd love your thoughts. We're seeing with AI kind of two things happen. People as gen AI a little bit more need is AI comes to be strategic. That thought leadership that curiosity. But there's also going to be almost a little bit more of that citizen data scientist, and you'll be much more efficient and effective with a little bit of coding. Like the fact that you write Python code and you could do machine learning and so many other things, I start to wonder if we could see a divergence where there's almost a little bit more of technical skills needed and soft skills, but not the traditional technical. And some of it, like a lot of the Excel formulas, will just be able to use Copilot to write them. And a lot of things that we used to think of as technical will be technical, almost more hard, technical in some ways to extend what we're able to do. Thoughts on that? I've heard that from a number of people, and I think it makes sense in a lot of ways.
[00:26:39] Guest: Bryan Lapidus: I think we're saying the same thing. Right. So you have your data scientists, and I think we'll still need the data scientists, because there's certain things that are just so advanced and require their expertise. But at the citizen data scientist level, or the data engineering level, the ability, the ability to collect data from different areas to find and dig and data mine for you that you can ask the computer to go and do that and it will come back, and you won't ever have to write the SQL code. It'll simply execute the SQL code based on what you have set. I think that's where we're going.
[00:27:16] Host: Paul Barnhurst: Yeah, that's partly what I'm getting where I'm getting at. I agree. Well, there'll always be a level of complexity. You'll need that right? Data scientist and the really senior person. But I also think FP&A people that learn some basic coding, like Python, to be able to run some basic machine learning or SQL to be able to, because anyone who understands the basics, I've found, is much more effective with AI. Like, if I know Excel well, I can get a lot more out of an AI than somebody that knows nothing about Excel and just hopes the formulas, right? So I almost feel like there'll be a need to be a little more technical than what we see today with Gen AI. And I'm curious about your thoughts on that for the average FP&A person.
[00:27:57] Guest: Bryan Lapidus: So there is a lot of hand- wringing in the community about this question.
[00:28:04] Host: Paul Barnhurst: I know. That's why I'm asking it.
[00:28:06] Guest: Bryan Lapidus: Right. Yeah. You and everybody else. Right. If the gen AI will help you to do those simple things, then how do you learn the complex things if you've never learned the simple things? I don't. I don't have a good answer to that other than we will adapt because we always have. Right. Nobody's using the loom now to, you know, to weave their own fabric. Somehow we're all still getting clothed. You know, I've heard this question over the years. If certain jobs get outsourced, then how do we build our finance staff to be able to do those basics right? You know, if nobody's doing the asset, you know, the credits and debits, then how can you possibly get to the next level of account accruals? Well, somehow we all keep getting there. So I can't say how we're going to get there, but I do believe that we will learn to let go of the of the basic building blocks in order to be able to do more of that middle level. And maybe, you know, I understand your point. Knowing Excel helps you to ask the question of what to build. I don't know, maybe it's too much faith, but I think we're going to get there.
[00:29:18] Host: Paul Barnhurst: I believe we'll get there. It'll be fascinating to watch. And I think everybody's trying to figure out what it all means. And if I had a crystal ball and could forecast it accurately. As I always like to say, I'd be sitting on a beach somewhere because I would have made a fortune at the stock market. If I could forecast that accurately.
[00:29:33] Guest: Bryan Lapidus: You would own the beach.
[00:29:35] Host: Paul Barnhurst: I'd own the mountain. I'm a mountain person instead of all right. No beaches here in Utah. All right. So I covered the Gen AI. I want to go in a little bit of a different direction for a few minutes. I get asked regularly about the FPA certification along with other certifications. You know, what people should do for their career. So talk a little bit about who is the FP&A certification for who's kind of the target student for that?
[00:30:03] Guest: Bryan Lapidus: The FPAC works on both sides of the desk if you're the applicant, right. If you're the person who's earning the cert, it does two things. It signals your interest in this area. I want to do this. I want to build my career here just like anything else. It says, you know, like a degree. I want to be here. I want to be great at what I do. And then it also signals a certain level of rigor and preparation. Right? The certification is two exams. It is rigorous. I mean, you know, this you know, the pass fail rate is on par with the CPA and the CFA from the other side of the desk. If you're an employer, when you're evaluating candidates, you're looking at people and you're trying to distinguish the FPAC tells the employer, the hiring manager, that this person has done the work and they know they know this much, right. It's a guarantee, a security blanket, that they know this much. I should add one other thing, which is our survey research shows that the other advantage of earning the FPAC is you get paid more anywhere from 6 to 14%, depending on which level in the organization you are. But there is a distinct salary increase for people who have the certification over those who don't.
[00:31:17] Host: Paul Barnhurst: FP&A guy here today I want to talk about the FP&A guys ultimate FP&A course bundle. This bundle includes over ten hours of content recorded by Ron Monteiro and myself. Many templates and great lessons to make you a better professional. The content includes FP&A business partnering, how to manage tough conversations, build world class relationships, and hold the business accountable. Includes modern Excel, which is a real game changer for the way you'll work in Excel. Excel tables the gateway to modern Excel. Power Query: a game changer for transforming your manual processes and loading data, and then dynamic arrays. Next, we cover modeling design principles. In this course, we talk about the importance of designing models in a certain way and how important it is that you think about design. And last but not least, driving value through smart analysis how you can conduct data analysis to be a better FP&A professional. Go ahead and sign up for this bundle at thefpandaguy.com. That's thefpandaguy.com. Use the code Podcast to save 25%. Get started learning today.
[00:32:36] Host: Paul Barnhurst: So you're saying I should go back into the field and see if they'll pay me more now that I have it?
[00:32:40] Guest: Bryan Lapidus: Absolutely.
[00:32:41] Host: Paul Barnhurst: All right. We'll put that to the test. I'll let you know when I decide to do that. I think you're having two.
[00:32:47] Guest: Bryan Lapidus: You're having too much fun doing this. I can't see you going back.
[00:32:50] Host: Paul Barnhurst: You're actually right, I am. I don't see myself going back. You never know. Never know. At the moment, I don't see it. All right, so that covers kind of for. This is a fun one. I was going through LinkedIn just looking at some of your posts, kind of think of some questions to ask. And one of them I liked, and I want to talk a little bit about not so much FP&A, but you did a post on the difference between what you call a control focused CFO and value creating CFOs. And you had some research that you pointed to in the article can maybe talk a little bit about that, the difference between them and why those two. Why did you kind of focus on that comparison?
[00:33:30] Guest: Bryan Lapidus: Paul, do you know when the term CFO came into prominent use?
[00:33:34] Host: Paul Barnhurst: I'm guessing early 1900s, I don't know.
[00:33:38] Guest: Bryan Lapidus: Not even close. But it's. But you would think so, right? Because of so much of the management science that came out in the 1920s and then, you know, the Frederick Taylor and time and motion studies. Right. And the professionalization. So I looked at some research from the University of Chicago, and they charted 400 plus large companies. And when they actually started using the term CFO, and you can see the graph that before 1970, it was right around one. By the time you get to the 1980s, the number had jumped and continued to climb until by the time he got to about 2000, almost everybody had used it. So from somewhere between 1970 and 2000, suddenly everybody had a CFO. So the question is what changed? And I think this really three things that changed. One is we got more tools. We had the capability to do things we couldn't do before. The data revolution. Right. All of that, which clearly we're still living in.
[00:34:34] Host: Paul Barnhurst: Yes, without a doubt.
[00:34:36] Guest: Bryan Lapidus: Number two, complexity and sophistication. The world became a lot more complex, whether it was FX rates or the international trade. Really, the globalization really ramped up. And somebody there's a great quote from the Disney CEO. He said, somebody has to be able to explain to the business what all these impacts in the world mean financially. How do we make a decision if we don't know what exchange rates are or the change in tax policy that was happening in the late 70s? And he goes through a whole list. Somebody had to do that, that somebody was finance. And the third was the focus on value. The focus that a company is creating value, what you think about it today? Is the future benefits, the cash streams, its ability to deliver on its mission. And when the CEOs looked around and boards looked inside the company and they said who inside the company is focused on value? It was the CFO. And so a lot of that Wall Street financial acumen, you know, the barbarians at the gates, right? All of that was brought inside. So we see that today where heads of other departments are coming to the CFO saying, be my partner. How do I add value on this decision? Help me make my next decision. Right. All those things we talked about, talked about at the top of the pod.
[00:35:56] Guest: Bryan Lapidus: Well, imagine if you're the CFO and you said, I'm not going to use these great tools at my disposal. I'm not going to interpret what everything in the world means, and I'm not going to focus on value. I'm going to focus on the historical part. The control part. Well, what you're doing is you're limiting what services you can bring to the company. If you say my job is financial control, you are limiting what the CFO can do. You're limiting how much the company can grow. And honestly, you're limiting what everybody in the finance organization can do. Right. Because at that point, you are honestly a tax that is being administered to the PNL of every other business. It's incredibly important. I'm not denying that at all. But the rest of the business sees you as a small player in what they're trying to do. By contrast, if you're a value focused CFO, you're thinking that you're bringing financial and quantitative models and rationale to the rest of the company. You're aiding in their growth. You're helping make their decisions. Your success is their success. That means that you can create value for them. You now have a different and a larger role. You're using those three forces to make the company better, and creating a more exciting career path for you and everybody else in the finance organization.
[00:37:19] Host: Paul Barnhurst: Fascinating. I had no idea that it was the 70s that you really started hearing the CFO term. I would have never guessed. I've never researched that. That is fascinating.
[00:37:27] Guest: Bryan Lapidus: It also gives you a sense of how fast the job is changing, right? I mean, this is for some of us who are on this pod, right? This is within our lifetimes, right? That this role came and it's still evolving and it's still changing, which is also important to think we're not done changing and we don't know where the CFO is going, but we have a role to play in helping to shape that.
[00:37:50] Host: Paul Barnhurst: Yeah. And I've heard people, you know, I had someone on a podcast that says, you know, CFO in many ways is almost becoming the business intelligence officer in the sense of data right here, chief value, you know, these different terms and different ideas. Here are some people say, hey, FP&A is eventually really going to be under the office of the CEO. I know a guy that that's where they put it. They're planning an analytics directly under the CEO instead of the CFO. So it will be interesting to see how it develops. But one thing I love is the term value creation, because you see from time to time this argument on LinkedIn, hey, you know, we should be viewed as a revenue generating cost center. No, no, we don't generate revenue. We can be a value creation cost center. And I usually like to distinguish the two. So I really like to use that term because that's a big one I use a lot. You know we're value creation and we can help the business create more value. That may be revenue. That may be expenses that may be better. Capital allocation can mean lots of different things. But it's all helping the business be healthier financially.
[00:38:53] Guest: Bryan Lapidus: Define what the value is and help the business meet that. You know, we talked earlier about the CFOs focus on capital. And so when you talked about should FP&A be the business analytics hub that reports directly to the CEO? I think that focus on capital is how you know you work for finance, right? If you report to the CFO and you're making decisions, that's great. You're a data analytics. You're a decision shop. The key element is if you report up to the CFO, you are concerned with company capital. There is data analytics everywhere. And you know what everybody does planning right. Planning happens in supply chain and planning happens in marketing. If you work for the CFO, you also do planning. But it's on the. With that basics of sources and uses of capital. And that's how you know you're in the role.
[00:39:44] Host: Paul Barnhurst: Yeah. Well said and I agree. So now I'm going to move into this FP&A section where we ask some standard questions of our guests about FP&A. So everybody gets the opportunity to answer these. So first one is what is the number one technical skill that FP&A professionals should master.
[00:40:05] Guest: Bryan Lapidus: Number one technical skill. There's so many potential technical skills right. And you talked about R and Python and machine learning and AI. But I'm going to go old school. And I'm going to say that it's Excel. And I'm going to say it and I know. I feel like it's a little. A little countercultural to say that now, but I think there's really two reasons. Number one, it is still the dominant. Tool that everybody uses. And in every job, in everywhere. In finance you still need to know Excel. And number two, Excel thinking is the basis for all the other thinking, the ability to build a model in Excel. And you can see it. It's very transparent will help you to build a model in your EPM. And the understanding of data and the ETL will help you understand how to use a business intelligence tool, right? And that idea of managing data, it is a great way, an essential first step to learn all of those higher level skills.
[00:41:08] Host: Paul Barnhurst: I'm with you. It's still critically important. It's one of the two most mentioned. The most often we get is spreadsheets. Sometimes people will say Excel, sometimes they'll say spreadsheet, preferably Excel and financial modeling. Those are the two most common answers we get. And, you know, I've often said Excel in many ways is a gateway to data analytics, particularly modern Excel. What I mean by that is tables, Power Query, Power Pivot, dynamic arrays. Now it's Python and the stuff you can do in Excel. If you drop somebody that used Excel 15 years ago into today, they wouldn't hardly recognize the tool other than it's still rows and columns and it's great.
[00:41:50] Guest: Bryan Lapidus: Great.
[00:41:51] Host: Paul Barnhurst: Or they just start to use all the formulas they knew before and not realize it's a completely different tool. One of the two.
[00:41:56] Guest: Bryan Lapidus: 100% agree with you. It is. It is the gateway to everything else that we do in finance.
[00:42:03] Host: Paul Barnhurst: Yeah. It's amazing. I mean, it's really amazing what they've done. All right. Number one soft skill.
[00:42:07] Guest: Bryan Lapidus: Number one soft skill. I mean all the soft skills are becoming more important. I feel like it's cheating if I say business partnership because that includes the relationships. It includes communication, and storytelling is a subset of communication. I would say it this way in terms of hard skills and soft skills. I'm going to steal a line from one of our event speakers. He said that we're in a world where compute power is becoming cheaper and it's hard to compute. It's hard to compete with that. And he gave an analogy. He said, imagine there's a world where there's only two beverages, and those are coffee and tea, right? You could tell he's an economist. Imagine a world. So on. So suddenly imagine that coffee becomes free. We use coffee to drink. We use coffee to water our plants. My dog sitting over here on the floor is drinking coffee. Right, everybody? Coffee is used everywhere. What happens to the price of tea in this scenario.
[00:43:02] Host: Paul Barnhurst: Becomes virtually free.
[00:43:04] Guest: Bryan Lapidus: Right? It craters. Right. So his point was compute power. Our now in the fourth and you're called I whether either flavor of I compute power is something that we can't really compete against. So he said his name was Avi Goldfarb from the University of Toronto. And he said, don't be a bad computer. Be a good human. Don't try to compete and be the tea. When coffee is free, be the cream and sugar the thing that makes it work better, right? So it's that sense of learn how to use the tool, learn how to communicate the outputs, learn how to see what it can't see. Right. So things that aren't in its data, those human skills combined with a compute power at our disposal is what makes for great FP&A going forward.
[00:43:50] Host: Paul Barnhurst: So I'm going to put you down for be the coffee.
[00:43:53] Guest: Bryan Lapidus: No, not the coffee. Be the cream and sugar.
[00:43:55] Host: Paul Barnhurst: Oh, Okay.
[00:43:56] Guest: Bryan Lapidus: That makes the coffee better.
[00:43:58] Host: Paul Barnhurst: Got it. So I'm going to put cream and sugar. And speaking of coffee, if you get the chance, do you know who Damon West is? The coffee bean parable. I won't go into it. We don't have time to run through it. But I'll tell the audience to give you a chance to read about that in his story. Absolutely. Fascinating. Went from being a drug dealer to basically a life sentence to prison, to being one of the most inspirational keynote speakers in the world.
[00:44:21] Guest: Bryan Lapidus: Got it. The coffee Bean story?
[00:44:23] Host: Paul Barnhurst: Coffee Bean and Damien West. You may be thinking that when you gave the coffee example. So. All right, all right. Third one, this is kind of a fun one because I never know where people are going to go. If you could wave your little magic wand and change one thing about FP&A, what are you going to change?
[00:44:41] Guest: Bryan Lapidus: Budgets, man. Budgets.
[00:44:45] Host: Paul Barnhurst: Just the look on your face as you said that.
[00:44:48] Guest: Bryan Lapidus: So I sit on the advisory board for the CFO Alliance and CFOs getting together, talking about it. And the last meeting, this one guy is just sitting there and he says, if my kids. He's got a kid in college and she's going to finance. He says, if my kid is still doing budgets the same way I'm doing budgets. I feel like I will have failed as a professional. Right. It's still painful and it's critically important. And I've been in this role long enough that I remember when it was, everything is going to be beyond budgets and we're not going to do budgets anymore. And here we are still doing budgets. There are ways to do it better. There are ways to do it faster. The technology can help. But if I can make a magic wand and people are still suffering with us.
[00:45:33] Host: Paul Barnhurst: I agree. When I asked on LinkedIn one time, is the budget process broken? 70% of people said yes.
[00:45:40] Guest: Bryan Lapidus: Everybody knows right. Yeah, we all know it. We all hate it. You know, there's a high percentage of us who, you know, who are listening to this podcast, who are going to spend six months doing the budget. Right. There are better ways.
[00:45:54] Host: Paul Barnhurst: There's a lot of things I loved about the eternal budget process was not one of them.
[00:45:59] Guest: Bryan Lapidus: And then you got to love when you do the eternal budget process from the bottoms up, and then it goes to the board, and the board comes down and said, we had a number in mind. We didn't tell you, but your bottoms up process doesn't get there, so go start over.
[00:46:11] Host: Paul Barnhurst: Yeah, I hear you. I had one year where it took us to, I think six months into the year or 4 or 5 months to, you know, finalize the number. We finalized it and we were so far ahead of budget at this point that two months later, corporate decided to redo everybody's budget, and they did it on their own and didn't consult us. So I got all these new numbers and I finally, multiple times my variance commentary said, I have no idea what's driving the variance because I didn't even put it together. I just couldn't make. I couldn't make heads or tails of it. And, you know, I consider myself a pretty good FP&A person, pretty diligent. But I literally put that on a couple comments. I have no idea.
[00:46:49] Guest: Bryan Lapidus: I don't know where this number came from, so I can't comment on how we're missing it.
[00:46:53] Host: Paul Barnhurst: Basically, it was so frustrating, but I finally just hit the point where I'm like, I'm done trying to make this up. Here's the answer.
[00:47:01] Guest: Bryan Lapidus: Nice. That's phenomenal.
[00:47:03] Host: Paul Barnhurst: So all right, we're going to move into the get to know you section. Favorite hobby or passion?
[00:47:09] Guest: Bryan Lapidus: Favorite hobby? Well, judging by this past weekend, you would say raking leaves.
[00:47:15] Host: Paul Barnhurst: Well, if you love it so much, you can come out here and do it for me.
[00:47:18] Guest: Bryan Lapidus: I'll take it. I'll take a week out in Utah. All right. That's probably what it would take, right? I'm actually searching for. For hobbies. You know, there's lots of little things that I enjoy. My wife and I both like to cook. She's a little bit better at it, so I guess that means I have a hobby of doing a lot of dishes. You know, I do a lot of biking, and right now, in fall, it's a great time to be out. But I'll be an empty nester starting next year, so I'll have time to explore more hobbies. So ask me a year from now and I'll have a better answer.
[00:47:48] Host: Paul Barnhurst: We'll check that out. One book you'd recommend to our audience.
[00:47:52] Guest: Bryan Lapidus: I mean, I'm going to stick with Anything by Erik Larson, devil in the White City, about the 1893 World's Fair in Chicago is unbelievable. And, like, sweating edge of your seat. Historical truth dead draft is also great about World War one. So anything from Eric Larson?
[00:48:09] Host: Paul Barnhurst: Got it. I like it all right. When you were a kid, what did you want to be when you grew up?
[00:48:16] Guest: Bryan Lapidus: Clearly an FP&A professional.
[00:48:18] Host: Paul Barnhurst: You know what this means. That's sign language. So those who are listening on audio will go out to see the video to understand that one. And it's not American Sign Language, it's Paul's sign language.
[00:48:30] Guest: Bryan Lapidus: I didn't have like a true calling, which is really interesting because as I go through, as my younger daughter is applying for schools, I'm looking at all the essays. And so many of the essays are when you come here, what do you want to study? What clubs do you want to join? What do you want to do afterwards? I was never that kid. What I wanted to do changed on a yearly basis. I didn't want to be a history teacher for a long time. I wanted to be a travel writer. You know, back when the Let's Go books were popular. I wanted to be the let's Go travel writer, you know, checking out hostels and all around the world, but I think I was just always open to curiosity and trying things, which is sometimes made for a trying and challenging career path, and I think has definitely that curiosity has made for an interesting career path.
[00:49:17] Host: Paul Barnhurst: See, I figured you always wanted to be like Mark Ripkin or something. You know, quarterback for the Washington Commanders now, Redskins, whatever they're called these days.
[00:49:27] Guest: Bryan Lapidus: Jayden Daniels is an impressive dude, man. We're excited in DC.
[00:49:31] Host: Paul Barnhurst: I bet. All right, so last one. If you could have an alter ego what would it be?
[00:49:38] Guest: Bryan Lapidus: I'm going to let you down. I don't. I don't have a good answer for this one.
[00:49:42] Host: Paul Barnhurst: Oh, man.
[00:49:43] Guest: Bryan Lapidus: What have other people said?
[00:49:45] Host: Paul Barnhurst: You know what? This is a new question. First time I've asked it. I mixed it up last week. So you're the first one to get this one?
[00:49:52] Guest: Bryan Lapidus: I'm the first one to get it. Yeah. I'm sorry, I don't have a good answer for you.
[00:49:56] Host: Paul Barnhurst: That's all right. All right. If you could be a superhero, who are you going to be? I'll switch it up.
[00:50:01] Guest: Bryan Lapidus: You know, so in this house, we're huge fans of the whole Marvel Cinematic Universe wisecracking Robert Downey Jr in Iron Man and just his whole story arc of how he changed. But it's the fact that he kind of built it on his own. He wasn't imbued with super powers. He just kind of used his mind, his creativity and saw things that weren't there. So, yeah. So the RDJ early Iron Man movies, I love those.
[00:50:28] Host: Paul Barnhurst: All right. So we got you down for Iron Man. All right. We're going to move into our kind of wrap up here. And just have another question for you. If you could offer one piece of advice to our audience to be a better business partner starting today, what would that advice be?
[00:50:47] Guest: Bryan Lapidus: Don't be a point, be a line. I had a boss who said this to me. He said, the point is somebody who shows up every once in a while. Hi. I'm here. Give me your budget. You put a couple points together. Hi. Let's talk about this. Help me understand this. You come by and you speak to that person more often. You put enough points together and you become aligned. That's how you become a business partner. You're there. You're there consistently. You're not always asking. You're giving. Don't be a point. Be the line.
[00:51:17] Host: Paul Barnhurst: I like it. I think I could see that making a LinkedIn post one day. I might even credit you for it. All right, if someone wants to learn more about you or get in touch, what's the best way for them to do that?
[00:51:29] Guest: Bryan Lapidus: Honestly, I'm on LinkedIn all the time reading what other people say, listening to you and others posting. Occasionally, I will say that there are at least three other Bryan Lapidus' out there. I've met two of them and they're and they're great guys. I'm the one who works for AFP, though.
[00:51:45] Host: Paul Barnhurst: There you go. So if you need to find the right Bryan, look for AFP.
[00:51:49] Guest: Bryan Lapidus: Exactly.
[00:51:50] Host: Paul Barnhurst: And Bryan with the 'Y'
[00:51:51] Guest: Bryan Lapidus: One of the other ones has a Y as well. Like I said, he's a good dude.
[00:51:55] Host: Paul Barnhurst: He can narrow it down a little bit with the Y. Just not all the way. All right. Well, thank you so much for joining me. I appreciate you carving out some time to chat with us today. And thanks for all the work you do for the FP&A community.
[00:52:06] Guest: Bryan Lapidus: Paul, there's a ton of fun and I look forward to when we get to hang out again.
[00:52:10] Host: Paul Barnhurst: Same here. Looking forward to it. Thanks.
[00:52:12] Guest: Bryan Lapidus: Cheers.
[00:52:13] Host: Paul Barnhurst: Thanks for listening to FP&A tomorrow. If you enjoyed the show, please leave us a five star rating and a review on your podcast platform of choice. This allows us to continue to bring you great guests from around the globe. As a reminder, you can earn CPE credit by going to earmarkcpe.com, downloading the app, taking a short quiz, and getting your CPE certificate to earn continuing education credits for the FPAC certification. Take the quiz on earmark and contact me, the show host for further details.