CFM Certification Tips for Financial Modelers to Pass Without 100 Hours with Carolina Lago

I think learning the three statements is one of the best skills that a financial professional can have, even if they never use it. The AFM is a very structured model that you know exactly what to expect, but it has a big reason for being that way, and it has. Today's guest is Carolina Lago, a financial modeling and FP&A expert. Over 20 years of experience, she's not only earned the prestigious Advanced Financial Modeler designation, but also leads workshops that help professionals make sharper strategic decisions.

How would you define the financial model? What counts as a financial model?

The financial model is anything that has inputs, calculations and outputs. Financial model itself needs to answer our business questions.

What's the most unique, most fun thing you have used Excel for in your personal life?

The most unique one was designing the floor plan of my apartment in Excel. Architects will kill me for that.

Any advice you'd offer to somebody taking the afm?

I have two things that I like to tell everybody that is taking the afm. One is.

Financial Modelers Corner is the world's premier modeling podcast. It is brought to you by Financial Modeling Institute, the world's leading financial modeling accreditation organization. Hello, everyone. Welcome to Financial Modeler's Corner. I am your host, Paul Barnhurst, AKA the FPA guy. And really excited for this episode is I have with me Carolina Lago, who's going to be my co host today. Welcome to the show.

Hey, Paul, how are you doing? I'm very happy to be here especially for this special episode that we're going to talk about. Something very important coming up, but I'll let you talk about it before I do.

All right, sounds good. I'm really excited to talk about it too. I'm excited you're here. As everybody knows, Financial Modelers Corner, we talk about financial modeling. Shock, shock. And it is brought to you by the Financial Modeling Institute. What I love about FMI is they offer the most respected accreditations in financial modeling. It's a way to validate your skills to yourself, to your employer and your prospective employers. I completed the AFM and if all goes well, I'll complete the CFM this year. And I know Caroline's laughing because we'll be studying together for that. So she's like, hopefully I'll get there too.

Yes, we're in trouble. We're in trouble for that now.

Probably more than we want to admit. So let me give a little bit of my co host background today. He is a financial modeling and FP and a specialist with 20 plus years of experience. She started when she was 12. So that's why she's got 20 years already. I wish.

Yeah, you're right. I'm 19.

She designs and delivers hands on programs that teach professionals and cross functional teams how to use financial modeling to see the big picture and make sharper strategic decisions. Drawing on her deep FP and a background and rigorous best practice methodology, Carolina has already earned the Advanced Financial Modeler designation from fmi, which is a seal of excellence. She now pairs it with an ambitious pursuit of the elite certified Financial Modeler credential. Her workshops blend time honored finance principles with forward thinking scenario analysis, equipping organizations to navigate uncertainty with clarity and confidence. Whether she's leading a classroom of seasoned executives or guiding an entire finance function through a modeling overhaul, Carolina brings meticulous structure, transparent logic and an unwavering commitment to elevating financial fluency across the enterprise. All righty. Exciting. So let me tell a little bit about our episode and then we'll let our co host jump in here. So we thought it would be fun to try something new. So give us your feedback after you listen to the episode. Let us know if you like it, what you think about it. But both Carolina and I are preparing to take the Chartered Financial Modeler test. Right. We're very excited. Have a little fun. No, we are. Be a great program.

I am.

I haven't got excited yet because I'm, I'm excited to learn the material. I'm not excited to find 100 hours to study.

Yeah. But I have a take on that, so I'll let you know.

All right, go ahead with your take and then I'll. I'll finish.

Okay. So I'm reading this book. I'm sure everybody has heard about it. It's called the Atomic Habits by James Clear. And that's when you asked me if I wanted to study together. And I had just read this phrase by him that says you do not rise to the level of your goals, you fall to the level of your system. Something like that. I did not memorize, but it stay with me.

Sure, I get the idea.

So what I thought before is that I would never have time and I don't have time. And that's why I didn't sign up before because I don't have a hundred hours and I don't have how to take a hundred hours. I don't know how am I going to find 100 hours or more if I need. But I just thought that the process might be fun and might be enlightening and might help me with my work. And might help me with my goals of becoming a better financial modeler, just like the AFM did. So I decided that I don't know if I'm going to have 100 hours. I don't know if I'm going to go through the whole 12 topics before October because I should have started last year right after the afm. I didn't. What I know is that if I can find 50 hours, if I can find 30 hours, if I can find 20 hours, doing this process until October, until I'm done with. Because I don't know if I will pass in October with. We all don't know that. But if I can find some hours, I will make the best out of it. And I think every model that I can go through, every topic that I can find out more will make me a better modeler. So it's all about the system and not about the ending goal. So I don't care about the ending goal. It's going to come someday and it's going to be a consequence. So if it's going to be now in October, or if it's going to be in a year after, I don't care. I don't mind. I just want to go through the system. So that's, that's why I'm excited about it. And I am not reading the hundred hours. It's going to come one day.

Great perspective. And so, you know, as mentioned, we're both signed up. We're going to share some of our thoughts about studying tips, tricks, things we've learned. You know, we're going to start today with a little bit of background, a little bit of afm, our experiences there. Then we'll talk a little bit of kind of the outline of the cfm, share maybe some preliminary thoughts. And then about once a month, we'll do an episode like this because we're, you know, big believers that taking these type of programs can make you a better modeler. And so that's kind of going to be our, our outline here today. But before we jump into that, I'm going to ask you two questions that you missed last time you were on the show. Oh. So, first one, this is a question I just recently asked. Somebody asked me to ask this of guests. So we're trying it out, see how people like it. If I asked you to define what is a financial model? So what counts as a financial model? A lot of times people are like, well, is this really a financial model? How would you define it? Or how would you answer that question?

Well, I'll go to the basics and say that a financial model is anything that has inputs, calculations and outputs. But at the same time, answer a question that can be answered financially because you have many models in the world, there will be also inputs, calculation process, or systems and outputs. But a financial model itself needs to answer a business question. So if you remain focused on answering the business question, you have a model. If you don't answer any question, you have a report. So that's how I differentiate it. But then it goes on a wide side because a financial model can be on any side of the business, any part of the business. The marketing team, marketing team can be doing a financial model as well. So it doesn't have to be stuck with finance. But if you have inputs, calculations, outputs that answer a business questions, whatever it is, I consider it a financial model. What do you think it is?

I think that's pretty similar to my thinking, right? Inputs, outputs, you got your structure, you're answering a question. I like Danielle Stein Fairhurst definition. I've seen a lot of different ones. And she basically says, look, if it's dynamic and it has inputs and outputs and it's modeling something, I'll call it as a financial model. And I think that's a very, you know, very loose definition. All the way up to when I teach this, there's one, and I don't have it in front of me, but the Federal Reserve, how they define a financial model, you know, and it's economic inputs and all these big, huge words throughout the whole thing. And you're just like, oh, that's painful.

I can imagine. And then people look at this and don't think, this is not for mere morals. We are mortals. We, we are regular people.

Yeah, it's very technical definitions. And then I share a more general one. And then Danielle is probably one of the loosest ones I've seen. It's in her, I believe, her Financial Modeling for Dummies book or her other business modeling book. And I like that one because I like to make it general. But at the same time, hey, it's dynamic. It's, you know, she's making sure, hey, it's easy to update, has inputs, outputs, and you're modeling something. I'm like, okay, that really covers it. It's kind of like. And you probably relate to this modeling best practices and principles. You can go, you can find 100 page book out there that tells you how to model every little thing and what you should do. And then you have others that have five or 10 guidelines. I'm much more of the type of, hey, give me the guidelines, give me the structure and then let me work within that versus tell me every little detail. What's your thoughts on that?

Yeah, I like this structure and that's the big difference between the AFM and the cfm. I don't know if you got into that yet, but the AFM is a very structured model that you know exactly what to expect expect. But it has a big reason for being that way and it has an outcome. If you go through the preparation and if you are prepared to pass the FM exam, once you're doing this systematically over and over, you start to build that model in your head. It becomes easier for you to understand how the finance. The numbers flow throughout the three statement model. And that's why I always discuss that and I always say that in public, that I think learning the three statements is one of the best skills that a financial professional can have, even if they never use it. It's because of this system that you build in your head and the AFM prepares you for that because you know how to build a model with the best practices, with the guidelines, like you say, with everything that is the best in the market. But at the same time, you build that in your head because you are repeating that on many types of business, many different cases, you're repeating the same structure. And when it's, when it becomes second nature to you, then you can expand. And the CFM is exactly that, that expansion of what the AFM provides you.

Great. Like that. And so been ask one more, one more question you didn't get last time and then we're going to talk a little more of afm. So this is kind of a fun one. What's the most unique, most fun thing you have used Excel for in your personal life?

Oh, our personal life. Well, we all did budgets for ourselves, but we do.

I'm terrible at it. I shouldn't admit that. Don't tell anyone.

Yeah, me too. But I think the most unique thing, well, we did task lists and any kind of project that we need to do. If we use Excel a lot, that's what we do every day. It's our first tool. But I think the most unique one was designing the floor plan of my apartment in Excel. Architects will kill me for that.

So did you. You drew out each room in Excel like the actual floor plan.

I just made each cell square and I decided that was I don't know how many centimeters square because from Brazil. Don't talk to me about feet. And all of that. And need to be centimeters and meters. Centimeters. Because I had a very tiny apartment back then.

Sure.

So I had to measure. I had to. I had the floor plan, but I needed to understanding where I was going to put the sofa, where I was going to put everything. I know AutoCAD is there for that and all of those amazing tools that the architects use. But I am a finance person. I use Excel for everything. So I just laid out everything on Excel. I drew the. The lines of the apartment. It was not perfect, but it helped me understand how I wanted to lay out the floor plan. And I think we all went through that, right. Using Excel for those.

Oh, yeah. We've all used it for personal things. I get all kinds of fun answers. We have yours. I've had somebody who built a bathroom tracker, somebody who built a tracker to tell how many times a TV show used swear words because it swore a lot. So I actually did an API and set up Excel to do that. Wedding Planner. No surprise there.

Playing my wedding in Excel too. I didn't remember that. Yeah, that's true.

There you go. I had someone who put like life goals for them and their partner and all this stuff so they could evaluate the. How they were doing each week in Excel. Didn't work very well with the partner, but they did that.

Habits is another one. I'm about to start that again now that I'm reading James Clear book.

Let me know how it goes. So, yeah, so all kinds of fun things. All right, so let's spend a little bit of time on the afm and I'm going to start by sharing my story and then I want you to share yours of how you first learned about the fmi. So I'm going to tell mine real quick. So Financial Modeling Institute. I first learned about them probably early in 2019, late 2018, so they were still very new at that point. I learned about them from Lance Rubin. So I was working in a job. I had been. I was getting displaced. They were moving the offices to Texas and I didn't want to go to Texas. So I was like, hey, there's a ton of startups here in Utah. I don't build three statement models. I haven't had to do it for work. It'd be really good to be able to say, hey, I have this on the resume. So I signed up for it late 2019, early 2020, based on kind of the recommendations, like I said, of Lance Rubin. And it got canceled for Covid.

Oh, okay.

Covid hit. I supposed to go to la. This is when you had to go in person and Covid hit because the test was in May. Covid really hit in March of 2020. And then I and as all this was going on, the job I was working at, they decided they wanted to keep me on and so I was working a ton of hours so I delayed it a couple times and just never completed it. When they became the sponsor of my podcast, one of the requirements in the podcast was in the first year I had to complete the afm. I'd wanted to do it anyway and so that that motivated me to complete it and they were nice enough to comp me that since I had already paid for the test and to delay it a couple times they had, you know, it had worked out. So that's kind of my story and my journey to how I ended up hearing about the FMI and a little bit of taking the test. Tell me now how did you learn about the fmi? What was your kind of initial thoughts? Tell us a little bit of that experience. Well, my background is in FP&A. I am also passionate about financial modeling. Like many financial modelers, I was self taught. Then I discovered the Financial Modeling Institute, the organization that offers the Advanced Financial Modeler program. I am a proud holder of the afm. Preparing for the AFM exam made me a better modeler. If you want to improve your modeling skills, I recommend the AFM program. Podcast listeners save 15% on the AFM program. Just use code podcast.

Well, I moved to France in the middle of COVID and I had to quit my job. I was not expecting to have to quit my job. I was prepared to work remote but with taxes issues and all of that, they couldn't keep me. So I end up I spent one year probably in France not working, being paid because they they were trying everything they could to keep me. And back then when I was working in the office, I was behind the computer. I was not looking what was going on. So I had never heard about anything like the FMI or your podcast or anything that was going on. I was just stuck in the office doing my routine, doing my things and work. Probably knowing a lot about the education industry, which is the industry that I was working on. But I was not trying to go after what was going on in the financial modeling on the FP&A market. I was not looking at it at all. And then looking for jobs and trying to relocate in France. I started to look around and got back to LinkedIn because I was not on LinkedIn at all until that time I got back to LinkedIn, I got back to listening to podcasts and got, you know, got the fun of it. I started to enjoy it, and your podcast was one of them. And I remember listening to an interview. Yeah, I remember listening to an interview with Danielle. I had never heard about Danielle. I never told her that, by the way. I don't remember. I don't recall if I, I don't think I told her that. So I was hearing her interview with you, and she was saying that she taught financial modeling, and she did all of that. She had a group to help women to break into the financial modeling market. And I was like, oh, my God, she's so lucky. She gets to do that. And then I came back home and I said, can you, I told my husband, and can you imagine if I was like a financial modeler instructor, like, teaching financial modeling, doing the best part of my job, but teaching others? And he laughed at me. He said, no, no way. Where are you going to find a university to do that? No, I can do that online. And then I played the podcast to him, and he laughed at me. And he still laughs at me sometimes. And I was like, I, that would be my dream job.

Our spouse laughed at all of us sometimes. You're not alone. Don't worry.

So that'll be my dream job. That's what I want to do. And then, then I heard about the FMI and the FM certification, and I, I, I had just gone to an interview. And on that phase of our lives when we are, like, running for higher positions, you don't get to be tested anymore. And I remember one time, 20 years ago, I went to an interview and they asked me to do some trick on Excel. They opened an Excel and said, just do something. And I did a sensitivity, quick, a data table in five minutes. And they were like, wow. And I went to this interview and I was saying everything that I went through, and it was impressive and everything, but I could not prove. So once I heard about the fmi, I was like, oh, that's how you prove. That's how you put the credential on your resume. It doesn't matter how long you've been on the market. You have a way to prove that you can do it under pressure, under time limit, and the CFM even more. But then I said, no, I need to take this test, and I need to test myself if I really can do it. And then maybe one day propose to them that I can be their partner and teach other people to do it. And it Was not about the business back then. I was not thinking about business. I was just. I wanted to do something that really excited me and I thought it was exciting to get out a little bit of the office. I was doing consulting work and it was fine, it was fun. But I found that I really liked to teach and corporate training and things like that would really make my eyes shine, like I say. And I thought Danielle was so lucky to be able to do that. And I just envied that for a while. So that's when I decided to apply and then I did the training. And it was hard. Oh man, it was hard. Even though I was like 20 years doing it because doing it under four hours, I never thought I could. But what did you think was the hardest part about training for the afm?

You know, for me, the hard it was finding time. It was that really, really busy time. I probably, I shouldn't admit this. I mean, I spent some time studying a few years back, but as far as for the actual first test, I probably only put in about 25 hours. And I'd say I lost count how much I did 10 to 15 probably was the week of the test. But I had watched the fundamental videos before. I'd gone through them because I started with that and I had seen, you know, examples of it for a few years. I mean, if you had all of that up together, probably 40, 50. But I think the heart so first was just carving out the time, which is a choice. We all say we don't have time. We all have time.

Exactly.

Every single one of us has 24 hours in a day. We get to choose how we use them. If we choose not to use them to study, then it wasn't a big enough priority. For whatever reason, we won't go into the psychology of all this. We all understand that. But we all like to say I don't have time. That's just, that's our excuse at the end of the day because we don't want to prioritize it high enough. But I think for me, the debt part was probably the hardest. And then, you know, next I'd say depreciation. Not that that's tough, but a little trick. Just make sure you get all the formulas right and lay it out in a really good format because I didn't deal with capex much. And then just getting comfortable linking everything and being quick because like I said, I've only built for a customer in my entire FP and a career 13 statement model. Okay, now I've rebuilt it for him as well. I had to rebuild it when they change all their chart of accounts and I maintain it for them every month. But you know, three statement modeling was just not something I did. So you know, really getting comfortable with all the different schedules and quickly linking them and depreciation and equity were probably some of the hardest parts. I mean you mentioned, you know, time beyond time and just getting comfortable being able to be quick. Was there a certain schedule, certain area that was really tough for you that you had to spend more time on?

I think the revenue. Because I started to practice with different business models. Once you are in an industry for so many years, you don't have to think about the business model anymore. We already know that. So you don't.

Sure. Yeah. You spent a decade somewhere and you kind of. It's second nature.

Exactly. And even the model itself, once. The first time actually I built a financial model was three companies ago. So that's something that I, I've carried along. This time I was implementing software for planning and then I had to build on the side the model so I could understand how I was going to translate to the model in the planning system. Well, that's when I had to learn how to connect everything and what is the impact of everything. And it just changed. It blew my mind back then and this has been probably 20 years, 2010, probably 2009. So back then it blew my mind and I started to see things completely different because of the three statement and how to, to understand how the numbers flow between the statements. And you can see, you start to see that everywhere. But the thing is I had time to do it. I didn't do in four hours. I did a whole model probably in a few weeks. So I had time to dive in. Or of course there was a much bigger model that would take the whole company into consideration. Actuals and all of that. Here we are just starting from a three statement model and just projecting everything the information is given to you. Okay, that's all of that. But at the same time I was not sure that I could do in four hours even if the information was given to me. And everything was very well processed already. Because it is the case is very well processed. You just have to put it on. If you know what you're doing, you just have to put it on and do it. And I end up doing my, my test in two and a half hours. So it was a huge accomplish accomplishment for me. Because when I started, when I first started, I think it took me seven or eight hours to do the first one, and I knew what I was doing. I. I watched the videos and I learned a few tricks. I learned a better way, better ways. Some of the schedules, the depth schedule was one. I didn't model a complete revolver. I had some way to do it dynamically, but it was not a complete revolver like we do on the efm. So there were a few things that I caught on the middle of the way. But what was the most gain that I had was the speed. And once I had to do over and over to gain speed, I started to internalize it even more. I already had 20 years building them in my career, and I used it for everything. Even though I'm not building the three statements after that, after that big project, I had to use that. I had to use the concept of a three statement on everything that I did. And for that I was completely, how can I say, on the job, I knew what I was doing, but I didn't know if I could do on time. So the time was a big challenge for me.

And that makes sense. I think that's a lot of what people fear. So before we jump into a little bit more on the cfm, any advice you'd offer to somebody taking the afm? It sounds like focusing on getting, being able to do it quick, quickly would be one of your core pieces of advice. I think for me, you know, the biggest thing is it's. It's about repetition. The test in and of itself is really not hard if you're prepared, like as many people have said, you know, train hard, test easy. You've ever heard that expression said different ways? And that's really true here. It's just about putting in the time, making sure you can do everything you're comfortable with. You know, the examples they give you, they give you flexibility to lay things out the way that makes sense for you. But make sure you can just do it structured. You can quickly connect things. You understand how that all works. It's not, you know, this test isn't rocket science. It's really just if you put in the time, you should be able to pass. I think that's the biggest thing for me. Any thoughts that you'd add to that?

I have two things that I like to. To tell everybody that is taking the afm. One is balance your model as you go. Don't leave it to the end. So anybody that wants to see. I have plenty of webinars. I did one for Danielle. I already posted a lot on LinkedIn on my method of balancing the balance sheet, because every Schedule needs to balance the balance sheet. So every transaction in the company balances the balance sheet. So once you do a schedule, as long as you link them correctly to the right place, it should balance the balance sheet and then you move on to the next one. So that's something that my students are used to hear a lot about. My three hooks method, that's where I link the three schedules before I even start tomorrow. So that's one thing and the other one is practice, practice, practice, practice. Put your hands in as many models as you can. And that's why it's so valuable to find a training provider. There are plenty out there. But it's so valuable to find a training provider because they will give you more and more models to practice. And as much as you can do different models before the day so you get comfortable doing and you'll be sure there is going to be a point that you are doing your model in three, two hours and a half maybe you'll be sure that you pass. So you get comfortable and you get calm because you did it so many times. The test is just one more. But now this is completely different from the a, from the cfm. So that's where I'm curious just to hear about what you think about the CFM in this sense.

Bad financial models can lead to bad decisions or worse. So how do you minimize the risk of a bad model? You make sure the models you build are great. Financial Modeling Institute developed the Advanced Financial Modeler Accreditation program to help modelers like you. The AFM program offers a step by step step approach to building world class financial models. The program ensures that you know the best practices in model design and structure and will help you brush up on your Excel and accounting skills too. Be the one on your team to build great models if you want to impress your boss and your clients. Get AFM accredited podcast listeners. Save 15 on the AFM program. Just use code podcast@fminstitute.com podcast yeah, so you know, first one thing I'll add, you know you mentioned balancing throughout. I, I did not take that approach. I linked everything up kind of more toward the end. It didn't balance. I, I did everything else after I couldn't find out why, I finally came back and figured out what I had messed up. There definitely is some benefit to doing it throughout. So I, I can relate to that, you know, so let's talk, let's talk cfm. And I think for me that you know the CFM again, it's not just practice, right? The AFM is very much. The practice is getting used to the structure. It's very. It's very methodical.

Yes.

You know, yes, they may vary. Some things, like they may change what the revenue is and you may have to think about capacity or they may add preferred debt or two different types of equity or whatever it might be, but it's not. Every section can be very different. There's some very structured way of doing it. You know, the CFM is structured, but every section can be quite different. The revenue can get very complex, or maybe it's very complex in the working capital or the debt structure or a tax schedule or, you know, multiple types of depreciation. So what they're really testing is you have the ability to think quickly and manage complexity in multiple areas. And so for me, it's much more of a deliberate practice. You know, the afm, it's practice, but you could just kind of keep going through it. You do enough times, you're good here. I think there's a lot more thought and being able to think strategically and being able to, hey, what are tips and tricks to allow me to quickly make sure I can think about a lot of different industries and how to model them, getting comfortable enough to be able to do that. And there's definitely a structure component to that, just like the afm. But I think it requires. I don't think it does require a higher level of thinking, which means you need a more deliberate practice approach. You can't just plan on, hey, if I do it enough times, I'll be good. Kind of that almost rote memorization, so to speak.

I think it's not about time, even though you are expected to do on time and the time is even more limited. I think it's more about resources. So that's why I think preparing for the CFM is going to be a whole lot of different fun from what was preparing for the afm. Because, you know, you have been doing most of those techniques before, but on a comfortable way that you know the company, you. You have time to think about it, you are not under pressure. And then on the cfm, you have to think fast and you have to be resourceful, you have to learn techniques. And that's what I'm intending to learn along the way. Because sometimes your way of doing might not be the best one. You might get it done, but it might take a longer time or it might expose your model to some risks. We have to admit that that doesn't matter how long you've been on this industry. You always have Something to learn and learning from others and from other people doing the same problem, which you don't get to do this very often. So that's why it's very important to study and being active in the community, active in your community, active in, in the FMI community, which is an amazing community to exchange ideas as well, because then you can see how other people solved that and you can pick up a few things along the way and sometimes you have the best way to do it and it's fine, it's great, just celebrate. But as long as you understand that you are going to go through all of those techniques that sometimes is going to be new to you and you are open to learn new things, doesn't matter how long you've been doing this, learn new things and apply. Because that's how I think I can evolve as a financial modeler. It's not only because I'm going to have a paper to prove that I am a cfm. I think every step of the way during this preparation, even if I don't get to the end, if I don't get the hundred hours to do all of those cases, even if I leave some topics off and I happen to be on the test and those topics are the ones being tested and I don't pass for that. Even though I think I might evolve as a financial modeler, as I am preparing for that. Because on every model that I understand and every, every solution from other people that I try to understand, even if I can make my own solution, I'm trying to go through every solution that is out there. Exchanging idea. Why did you do this way? Why did you do that way? Maybe I could try this way too. Maybe it'll be faster, maybe it'll be more safe to do this way. The formula won't break. Maybe it'll be more dynamic. Every single resource that I learned on the middle of the way is going to make me a better modeler. So that's, that's how I'm feeling about the cfm.

Thank you for sharing. So I'm going to say a few things on it with, with the CFM. So there's, if I'm right, 12 sections in the CFM. You know, you got revenue, you got your cost of goods sold, you got your equity and debt schedules and your taxes, depreciation, you know, on and on and on, each of those different schedules that you normally have. And so you have to practice different ways for each of them. But what I'll say is the CFM is hard and I'LL share what people have told me. So I, I know somebody who runs a professional modeling company, a pretty large one, you know, full time, has a partner, he trains people to prepare for the afm, you know, along with several other things. And he mentioned how concerned, even after he took it, he wasn't sure he had passed or not, you know, very concerned because he said it was really tough. So it really does help demonstrate. The other example I'll give, and I'm going to have him on the podcast here soon is I was talking to a guy who runs It's Denmark. I think it might be Denmark, but I know it's somewhere in that area. He, he runs for, you know, one of the big four accounting firms. He runs their M and A and you know, their modeling section. And their entire team took the CFM and they studied together as a group. And he said he could see a big difference in their models. And these are people that are building complex models. You know, that's their entire day job. And he was talking about, you know, how difficult it was. They put a lot of time in, how it made them all better at their job. So first thing is people are going to fail. It. It's hard. And that's when you know you're doing something that's worthwhile. When there's a risk of failing if everybody passes, I, I think you have to question it a little.

That's, that's how I feel. And even there's a big risk that me with 25 years of, of experience, I may fail too. And it's okay because I think if I do fail the test, I have already succeeded picking up some of the techniques I might have not pick up everything. So, so I think it's just a matter of time, timing to put on. That's why they say it takes around a hundred hours. It might take more for some, might take less for others. And even if I do the a hundred hours and I do successfully, there's still a big chance of failing because you don't know what's coming. So it's not like that.

My plan is to just bribe in just like some money over to him and see if he'll just pass me.

I don't.

You guys didn't hear that?

I don't think they take that.

So if you're listening, can I be your first student that was able to bribe you to pass the test?

I don't think that will work.

Come on, you gotta, you gotta try something.

But you have to see, you have to see that you already gain something even if you don't pass yet. I like to say yet because it's. I think it's a matter of time. And I heard of some people that didn't pass the first time and then did the second time without even having to study so much, and they just pass it easily because they had already incorporated those techniques. They gave themselves some time to understand those techniques and put it to use, and then they became comfortable with them. That's why I think it's a matter of time. You, you will pass some days. Sometime it might not be the first, maybe the second. It's hard. But at the same time, the gain is not only the certificate, the gain is much more than that. And you start gaining it from day one. You don't have to wait a year to do the exam and, and profit with it. Your profit starts as soon as you start preparing every, every single model that you go through. You're going to learn something, even if it's a small thing, and that's going to make a better modeler.

Yeah. So, you know, I think as we. We come close to wrapping up here, we've been talking for a while. I'll add a few little things and then we'll wrap up one. You know, we're going to do some more episodes on this, so let us know what topics or how you'd like us to approach this. Tom, we're going to probably start sharing a little more tips and tricks. Like, we may talk a little bit about revenue and how we thought about it. Some of the things we've seen now get into a little bit more of that. So let us know if that interests you. You know, I think the other thing to say is, you know, even if you don't want it, if you don't want to take the AFM or cfm, fine. I still think you can get some value out of listening to this and thinking about modeling. There are plenty of ways you can learn to be a great modeler. We like this program, but the biggest goal here is that we're all trying to learn, grow, and become better modelers, however we choose to do that. And then, you know, the, the last thing is we gotta, we gotta end with the joke here, because, you know, why not? So here's the question for you, Carolina. What do you call a broken. What do you call a broken spreadsheet? Because I nearly fall over. What do you call a broken spreadsheet?

I. Broken spreadsheet. You need to give the answers to the, to the guests beforehand. How Am I going to know a broken spreadsheet?

You got to try to guess and then I'll give you the answer here in a minute.

I am not good at that. Jokes excel. Jokes become even worse.

You basically, it becomes the intern's problem.

Oh, that's true. I heard that one before. And I've been the intern before, so.

Yeah. Or the new employee. Either. Or, hey, this is broken. Go fix it. Whoever designed it didn't know what they're doing. I'm going to start over.

Yes, I've been there before, many times. And that's one reason that you need to learn how to audit the model. That's one important thing that you need to learn how to do it because then you need to learn how to fix easily. That's one of the topics, by the way, right?

I believe it is, yes. The model audit is huge. I've had several guests on about that. And you know, because we've all been there where you make a decision and then you come back later only to find out the model was wrong and you pray it wasn't material. You're like, geez, don't let it be a big mistake. I can still remember the one where fortunately we had put quite a bit of padding and I will put it that way in this forecast because we were told whatever you do, make sure you submit a number you can hit. So there was plenty of wiggle room, which you don't get very often. But we had missed by such big mark numbers the fat past several years that it was pretty much we're going to deliver to the board no matter what. And we had like a million dollar plus timing mistake we made in one of our businesses. Not realizing it was a build where you had four and five weeks and we took a five week and we thought it was a four week and we started with that and built everything on top of it for the whole year. And so that area of the business, the revenue was way overstated. Fortunately we still hit our number for the year, but that was not a fun one.

So yeah, you probably understate your weekly revenue, which is good. And it could be your time.

Yeah, definitely was a problem. Right. When you are sticking five weeks of revenue in four weeks and you're going to be off. Go figure. But I think we'll go ahead and wrap up for this episode again. Send me an email. Send Carolina email, let us know what you thought. Thank you for joining me. I hope you enjoyed that. And we will do this again in a month or so.

Yes, thanks. Paul. And let's get to study. We have 100 hours to to manage, right?

Yeah. Go ahead and get started today. You know, you know the drill, so let us know.

Don't forget the vacation. Just start starting right away.

It's overrated. You don't need a vacation.

That's true. That's true. Thanks, Bob. Very nice talking to you.

Good having you on the show. Thanks for joining me.

Sure.

Financial Modelers Corner was brought to you by the Financial Modeling Institute. This year, I completed the Advanced Financial Modeler certification and it made me a better financial modeler. What are you waiting for? Visit fmi@www.fminstitute.com podcast and use code podcast cast to save 15% when you enroll in one of the accreditations today.