Financial Modeling for Analysts to Build Clear, Structured Models for Better Decisions with Shreya

In this episode of Financial Modelers Corner, host Paul Barnhurst interviews Shreya Bhatt, a manager at Cross Boundary Group with over eight years of experience in infrastructure and project finance modeling. Shreya shares her modeling philosophy, emphasizing that a model is never finished and must tell a clear story by linking inputs to outputs. She recounts a "horror" corporate model plagued by poor structure, random links, and tangled formulas, illustrating the importance of clear sheet purpose, input shading, and consistent labeling. Shreya describes her role building and reviewing financial models for renewable energy and infrastructure projects, focusing on portfolio roll‑up models for solar, where she monitors commercial, technical, and financial variables. She enjoys project‑finance models, especially a multi‑country template covering eleven nations, and highlights the balance between flexibility and clarity. Regarding modeling standards, she adopts a blended approach: FAST for smaller, user‑friendly models and SMART for large, complex portfolios, stressing consistency and organizational alignment. The conversation turns to AI, where Shreya is enthusiastic about AI as a partner that can accelerate calculations and enhance dashboards, but she warns that judgment, structure, and insight remain human responsibilities. She offers career advice about patience, self‑kindness, and continuous learning, and shares practical Excel tips such as the F5 shortcut, VBA usage, Power Query, Power BI, and XLOOKUP. In a rapid‑fire segment, she provides concise opinions on topics like lambdas, three‑statement models, cash‑flow focus, and preferred language models (Copilot). The episode concludes with a reminder to stay curious, help others learn, and connect via LinkedIn.
Chapters
I believe that AI could help, but it cannot take our jobs.
We can all see that AI is coming. It's getting better and better at building models.
The potential of AI in financial modeling is very exciting, and I see it as a—
Meet Shreya Bhatt, a financial modeling professional with over 8 years of experience in financial modeling and infrastructure finance. She currently serves as a manager at Cross Boundary Group. Her work spans portfolio modeling, project finance, corporate finance, and evaluation.
I have learned that a model truly never finished. So even if I have built it for the base model, but it can always be improved. A model can either be the most powerful tool or the most frustrating one. So it really depends on how you build it. Modeling is much more than just building Excel files. So a good modeler connects inputs and outputs to tell a clear story.
What's the most important lesson you've learned during your career? What's the number one thing you've learned that's helped you the most? So during my career, I have really understood 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. Welcome to another episode of Financial Modelers Corner. I am your host, Paul Barnhurst, aka the FP&A Guy. This podcast is where we talk all about the art and science of financial modeling with distinguished financial modelers from around the globe. The Financial Modelers Corner podcast is brought to you by the Financial Modeling Institute. FMI offers the most respected accreditations in financial modeling. And that is why I completed the Advanced Financial Modeler. I'm thrilled to welcome this week's guest on the show, Shariya Bhatt. Welcome to the show, Shariya.
Thanks, Paul. Thanks for this opportunity. I really loving it. I'm really looking forward for this conversation.
Excited to have you. And I love your background there. That's a fun one you got going.
Yeah, that's the Victoria Falls. We had an offsite. Last month, so I just kept it on the back.
Well, thank you for joining me. I know you're joining us today from India, so it's a late time for you, so I appreciate you doing that. I'm just going to start by just sharing a little bit of your background and then we'll jump into our questions. So Shreya has over 8 years of experience in financial modeling and infrastructure finance. She currently serves as a manager at Cross Boundary Group, and throughout her career, she has developed portfolio operational and optimization models. That support the strategic decision-making across sectors such as renewable energy, transportation, and professional services. Prior to her current role, she spent 4 years with Mazars, where she strengthened her expertise in smart financial modeling and advanced analytical practices. Her work spans portfolio modeling, project finance modeling, corporate finance, and valuation. With a consistent focus on building robust decision-oriented financial models that enhance investment analysis and improve operational efficiency. As a FAST Level 1 certified professional, she applies their structured modeling standards and analytical rigor to deliver clear, insightful financial solutions for complex projects. So love the background. I can definitely tell we have someone who loves modeling. Been spending a long time in it. So I know you have a horror story. What's that worst model you had to deal with, or what's your horror story as you look back over your career when it comes to modeling?
If I go back to my career, I think the worst model I have received is for rebuilding a corporate model, which was like very huge, multiple sheets, and there was like no clear input shadings. The links were very random. Workbook was not really structured properly. So it's also a problem when there are no clear sheet purpose. So when the most calculation have come into single sheet, it makes very difficult to understand that what is there. So, and when I go to those sheets, I found that they were like poor labeling, which can make things very worse. So, and the biggest issue I have ever faced in the bad models, uh, or the worst model I have ever seen is like long formulas, maybe the tangled formulas, which makes no sense when we just press F2. So I feel that when the model is there, it should actually be easy to understand better rather than being very complicated. So a model can either be the most powerful tool or the most frustrating one. So it really depends on how you build it. And I think, yeah, that was like most worst model I have ever seen. So I have also seen some of the other models which I received for the rebuild, and they were also like kind of, I would say, different kind of models I have received. So like operational models. Where they were like random linking, no balance sheet checks, and I don't know how they were relying on that model outputs. So it really matters that how you build it, like, yeah.
Yeah, 100% agree. It really matters how you build it. You need to be able to rely on the model. I'm curious, with the, the first one you mentioned, the rebuild, did you start over or did you try to fix the existing model?
I generally start from scratch. So I think in my early career I used to work like from the scratch. So I have built the models from the scratch where I take the model in, I understand what is the requirement, what they are trying to do in this model, and then when, uh, the client is there, we discuss how it is required, what are the people who are going to use it. So that is how we collect all the information in and then we make a model out of that, uh, all those inputs. So I generally enjoy financial modeling through my career, but I have learned that a model truly never finished. So even if I have built it like for a, like a base model for a delivery, but it can always be improved. So there have always been instance where I have been building the models from scratch. To make it better. Yep.
Got it. So I know today you work at Cross Boundary Group. Can you talk a little bit about, you know, what that is and your role there?
So yeah, I work at Cross Boundary Group. So the group is currently divided or split into advisory and investment firm. So I work with the investment firm where we focus on helping the capital flow into the underserved and frontier markets. The goal is to support the sustainable growth while we still deliver the strong financial returns for the investors. So we work with the governments, investors, development institutions, companies to fund the high-impact projects, and especially in the areas like energy, infrastructure, and climate. So I'm a manager in financial modeling team working with cross-boundary energy and cross-boundary access firm. And I build and review financial models that help investors and clients understand whether the project makes sense financially. And on the day-to-day basis, I test assumptions, look at the risk and returns, turn the complex numbers into clear, practical insights. So I work closely with the deal team to make sure the analysis is realistic and useful. So for example, if I support on the stress testing, the financial model for like one of the energy platform, so I help by presenting a clear story to the investor that how it is working. And my focus is always making on the analysis practical, like decision ready.
Got it. Thanks for that. I know, you know, over your career you've built several different types of models, you know, bid models, portfolio models. You're doing a lot of project finance, infrastructure. Is there a type of model you like building most?
Yeah, I think, um, that's a tough one, but, uh, I think right now I love financial modeling, so I love all types of models. But right now I think I really enjoy working on project finance models because over my career I have been in like consultant firms where we get the clients, we make the model, we deliver it on time, we make sure that client is very happy with it, but Right now I'm in a company where I'm dealing with everyone. I'm in a client side and I'm dealing with everyone. So currently I'm working on most of the project finance models and I'm loving that. And I find it most interesting in playing around with the numbers to find the breakeven point, seeing how the changes in assumptions affect the outcome through sensitivity scenarios and It makes model feel much more connected to the real world. So that is why I think I'm right now, my favorite is project finance. One model I especially enjoyed working on was a template I designed to work for 11 different countries. So it was a template which was used for 11 different countries and it was a project finance model and it had all the full text functionality, like with the inputs that can handle like different permutations and combinations. And it was definitely complex, but that's what made it interesting. And one of the parts I enjoyed the most was simplifying the structure, making model more flexible, user-friendly, while still keeping all the functionalities intact. So yeah, it was like a good model.
Yeah, I can see where that's a challenge if you had 11 different countries, because there's going to be a lot of nuance that you have to build into the model and into the templates, whether it's tax stuff or other things that are just going to be a little bit different between the different countries.
Yeah, yeah. And it keeps on adding on. Like, if you go, it was like I was building a portfolio kind of thing within a Project finance model, and which is kind of very interesting, but then it also had some kind of VBAs, which was in the end, if you have finalized the country, like you can just delete all the other things. So it can just compact your model in the end for one country.
Makes a lot of sense. Do you have a favorite industry you like to work with? Like, do you prefer renewable energies or is there, you know, a certain industry that you enjoy more than others?
Yeah, I think I like renewable energy and yeah, I have worked on it quite a— for so long. So yeah, I definitely like that.
Okay. Yeah, no, that makes a lot of sense. I know renewable energy projects are often 30, 50-year models, probably a lot of complexity in the length and assumptions that you got to be really dialed in on because we all know none of us know what's going to happen 50 years from now. So you need to at least make reasonable assumptions.
Yes, and I think the industry is being quite interesting in the terms of how the funding is coming in from the different platforms, and then it makes very interesting to build it up in the model and see how it impacts other things. So it makes it very interesting.
So I know one of the things, you know, when you and I chatted, you mentioned is you're doing some portfolio roll-ups, many of those around solar energy. So what are the key things you need to watch for, some of those key variables when you're doing roll-up type models?
So when I think, when I'm working on portfolio roll-up models for solar, so I currently work for Energy and also the Access, that is quite niche as of now. But yeah, so first thing I look closely for like commercial variables, and that is like tariff, contractors, calculations, and because those small changes here can materially impact the portfolio returns. And from the project model perspective, getting these assumptions consistent across the project is critical. So yeah, first is the commercial variables. Secondly, I think I focus on the technical and operating assumptions like capacity degradation, availability. And operating costs. These feed directly into the generation and cash flow stability. So I make sure they are realistic and aligned across the assets. And the last one is like financial variables, which are like quite interesting when it comes to funding and like leverage, cost of debt, you know, DSCRs, these refinancing assumptions. So when rolling projects up, I pay attention to how individual project structure is aggregated at the portfolio level. And yeah, makes sense.
And I could see kind of each of those, you know, different things that you gotta, you gotta focus on. And any of those, right, your cost expenses, your financing methods, whatever it might be, small changes can make a huge impact, especially over a long timeframe. Always good to have very practical assumptions. So I want to, I want to switch gears here a little bit. And talk about the FAST. So I know you completed Level 1 of the, the FAST certification. For just in case anyone from our audience doesn't know, FAST is one of the primary modeling standards out there. They're a pretty detailed standard that helps guide how people should model. So what motivated you to earn the Level 1 certification? Why did you know, why did you do that? What was it about FAST as a standard? 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.
I think I earned this certificate early in my career, like around 8 years ago, maybe like first year of my career when I had just entered this field and I didn't realize that real world impact financial models can have. So at that stage, I was still learning the basics of the modeling, but what really stood out was like exposure I got from my company. I was amazed at how they build the Excel models that were like large, complex, yet so easy to understand. So that experience sparked my curiosity and pushed me to learn more. And over the time, I realized how important it is to build models in a structured way, and one that tells the bigger story, not very crunch numbers. So following the Fast.ai played a big role in the learning journey, and it helped me create models that are structured, readable, and easy to understand. Yeah, and more importantly, like Fast.ai made modeling adaptable and turned into like a common language for clearly like presenting a bigger picture in one place.
I like what you said there about, you know, allow you kind of that bigger picture in one place and just the importance of standards. We've all seen what happens when a model isn't well structured, whether you use FAST or SMAR or your own standard. If a model doesn't have good structure, you lose confidence in it and it becomes really hard to trust the numbers are right. Like the example you gave at the beginning, right? We open it up and if you see no input sheet or you see hard codes or all kinds of colors, you immediately wonder what else is wrong. So totally agree with you, the value of standards. So I'm curious, you know, when it comes to standards, how do you decide when you're going to use FAST versus maybe your own standards versus another standard like SMART? Because there's a lot out there and none of them are perfect. Let's face it, right? There's a reason there's a lot of standards. So I'd love to know how you think about it when you're modeling.
So I usually take blended approach rather than, you know, strictly following one of the standard. And the FAST standard is very well defined, I should say. It provides like clear rules around the structure, formulas, links, input sharings, overall model discipline. But it's especially helpful for building models that are like very easy to follow and review. And the SMART approach, on the other hand, applies like, uh, similar principles but follows more flexibility, which can be useful as models grow in size and complexity. So in practice, I prefer like FAST for smaller or more universal models, like such as bid models, like Project Finance models, especially when they, they'll be used by wider group of users. And for very large and complex models like portfolio rollups and corporate models, I think I lean towards SMART, and as it allows great flexibility without losing clarity. So ultimately, both standards work, but as long as you understand the objective and apply them efficiently and consistently.
If I understand correctly, you generally go, you go with SMART when you need more flexibility, as maybe it's a bigger, a little more complex model. When you're building something a little more standardized, a smaller model, you like the FAST and that it's a little more detailed in what you need to do.
If I give like an example in the bid model or like project finance model, we have someone which is working from like deal team and they are looking into the model, like the revenue part. They want to see the tariff there clearly labeled so that they can relate it with the escalation. The flats and everything. I think the pastel works better there because it gives more of the detail of the lines when we do the calculations. But when we are going to the corporate models or like portfolio models, there we have a very big sheets of calculations for like different projects, for one asset covers one SPV. So in that part, I feel that we can compact a lot more of details. Same rows, maybe, and same columns. So that is why I would prefer SMART in there. And yeah.
Thanks for sharing that example. I appreciate it. I think that's helpful. And what I like is the practicality of approach. Because I see some people, they're like, hey, you need to use FAST no matter what, or you need to use SMART, or you got to follow these 25 rules and never vary from them. And you know, my philosophy has always been, look, whether it's FAST, whether it's SMART, whatever it is, there's general guidelines you should be following. There are some rules that you should avoid at all costs, like don't hard code, put in an adjustment line, do whatever you can. I've done some of it, but it's a bad idea. And there are some others that, you know, are kind of like that. Like, hey, you should have an input section. Now you can debate, should it all be on one sheet? Should it be on, you know, different areas within the model as long as it's clearly labeled? I've seen both work well. I like one input sheet. but you know, so it's like inputs, you gotta have 'em, they gotta be structured exactly how you structure it. There can be some flexibility depending on the model. That's at least how I think of it. So I think we probably have some similar ideas there, but I'd love to know what would you, what advice would you give to other modelers? Someone's trying to figure it out, like, you know, thinking about standards, any advice you'd offer to them?
I think my key advice would be like, to pick a modeling standard and follow it consistently. Like if you use FAST, apply it fully in that model, and if you use SMART, do the same. And even if you have like follow some formal standard which you have made on your own self, like the rules, just stick to them. I think all the standards, what they tell us is about consistency, and if we Consistency is what makes a model easy to hand over, maintain, and trust over its lifetime, right? So well-applied standards significantly improve the clarity, usability, and the decision-making. Understanding the impact of these rules on the end user is just as important as following the rules themselves. So just stick to the consistency.
Well said. If you're consistent every time in your model, it's going to be much easier for somebody to audit it, to follow it, etc. And I would go one step further, make sure you're consistent within your organization. You know, if you decide to do one standard and somebody else does something quite different, like they decide to use a different color coding, then it makes it really hard if you have to share models between teams. So I think the one thing I'd add to that is 100% agree with the consistency, but try to be consistent across your team, your broader organization, because I'm sure you do a fair amount of audit modeling and you appreciate when the people are consistent when you're auditing that model.
Yes, yes, definitely. It makes work very easy and I think it feels more connected when you are like in the same team following the same rules. And you know that how things works here. And yeah, it is very, really easy to connect and understand each other then. Yeah. All right.
I'm going to shift gears here again a little bit. You know, there's been a ton of talk the last few weeks about AI, right? We're seeing all these new tools in Excel and build models for you and just a ton of AI tools, whether it's Claude, You know, OpenAI came out with their own version. You have Copilot and you have a ton of other companies. So I'd love to get your thoughts. How do you think about this? These AI tools that say they can build models for us and they just seem to be coming at us really fast. What are your thoughts about this whole kind of AI and modeling? Bad financial models can lead to bad decisions or worse. So how do you 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 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 at fm institute.com/podcast.
I'm generally very excited about it. Like the potential of AI in financial modeling is very exciting and I see it as a like powerful partner for modelers maybe because it can help us to deliver the model very fast and It may help us to build a model, but it'll give us a more stronger analysis and more interactive, beautiful outputs like dashboards and scenario tools. So this feels like a natural evolution of modeling, right? The every technology comes in and we evaluate, evolve around it. So learning to work alongside new technology is how the field progresses. So AI can free up some time. To focus on what really matters, like judgment, structure, insight, which are like more time-consuming in financial modeling than, you know, once you get the model engineering, like, you know how to build a model, but finding a way out how to do that very efficiently to give the best of it takes time. So at the same time, modeling is much more than just building Excel files. So a good modeler connects inputs and outputs to tell a clear story, and it builds a reliable foundation. It creates insights. So it also supports real decisions. So AI can enhance that process, but thinking and interpretation will always remain central to this role, I think.
100% agree. We can all see that AI is coming. It's getting better and better at building models that can help us. But like you said, it's something that's there to help us. We still have to make judgment calls. We still have to understand things. We're not there yet. Whether we'll get there one day or not, who knows? But we're definitely not at the point where you can just turn it over to AI and then deliver it to your client. I wouldn't do that. There's not a chance.
Definitely, definitely. Even if a machine makes the whole model, we will have to review it at the end. We, we believe in our instincts rather than, you know, a built-up tool in our front. So yeah.
Yep. And I'm curious, are there, uh, any— anything you're seeing that really excites you? Any tools, or have you used AI to kind of Where have you maybe used AI to help you? Where are you seeing the benefit today?
Recently, like I would just say into the context, I haven't used it yet, but I quite use it on the VBA side for like getting the VBS codes and different codes around like what I can do. But when I see, I have just seen a webinar which was there for like PFI Nexus. When I was seeing that webinar, I quite understand that how it's like it is going to be there, but it is only going to be like it can give you a structure, but it cannot give you a reliable decision tool. So yes, AI will be there. It will help you to give the calculations at your place where you want, how you, the standards you are following maybe. But when it comes to decision-making, I think it's only the financial model which can tell that how reliable this model is, even if it's AI-made. So yeah, I believe that AI could help, but it cannot take our jobs.
No, I appreciate you sharing that. And I definitely feel like right now, you know, I say a lot is it's modeling or whatever, FP&A, these different finance tasks, they should be human-led, AI-assisted. Yeah, fabulous tool, but it's there to augment, not to replace us, at least, at least today. Well, we'll see how, what the future holds. The famous economist, I think it was John Maynard Keynes, who said it, you know, in the long run we're all dead, so I'll worry about the short term.
Yeah, yeah, definitely.
All right, so here's kind of, these are some standard questions we ask different guests, and then we're going to move into rapid fire here in minutes. So the first one, do you have a favorite Excel shortcut? If so, what is it?
I love shortcuts. And I mean, one of my favorite is F5. And I use F5 a lot during the reviews. So when I'm going back and forth during the calculations, I really like how quick and efficient it can make the review process. So shortcuts, like, I love them. They are like mini gifts Once you know them, you really enjoy them, so.
Agree, and F5's a great one. I've seen Insh Noor do some presentations where he shows a lot of the trace precedent, the way you could tell if a row's consistent using F5, find all your formulas, your blanks, so many different things that you can do with that F5 menu as you get in there. That's a good one. What's the most important lesson you've learned during your career? What's the number one thing you've learned that's helped you the most?
So during my career, I have really understood that being patient and kind with your learning process. So I have often seen people that they try to learn everything at once, they rush through it, and— but that's not how real learning works. So growth takes time and everyone learns differently. So your journey won't look same as someone else's, so even the same as it did before. So It's important to give yourself space to learn to your own pace and make mistakes and improve gradually.
I love that advice is we all learn differently. Be patient, be kind. Sounds like somebody who has had to do a lot of learning and probably has had to remind themselves that a few times. I know I have.
Sometimes, you know, when you work on a model, you're like, why it's not happening? Why it's not happening? Like. I need to do this. And, and we, I think somewhere we get lost in that and we are like angry on ourselves, like, or not doing like, why, why? And, but we should be like patient about it. And then, yeah, think on like fresh mind next morning and then I think it will be done. It happens a lot of time that I get stuck on some of the formula in my earlier career. Career. I was like stuck on stuck on a formula, why, why I'm not able to get this calculation in this formula and how it is going to be done. My mind is shut down. And then next day when I woke up, I'm with a solution. So you just have to be patient there.
The last part you said there, sometimes just sleeping on it at night can be incredibly valuable because you're, it's 11, 12, 1 in the morning and you're probably not getting a lot more benefit because you're frustrated, you're tired. You're not thinking clearly. Just be patient on yourself. Go to bed, come back to it the next day, and often the answer will come to you.
Yes.
Yeah. I'm with you on that. All right. So what's the most unique or fun thing you've done with a spreadsheet in your personal life?
Yeah. So I have done two of the things, like I have done my taxes on Excel sheets, like calculating taxes, where should I invest, how much I should do. And the best one is like my wedding budget and planning. So I have done entirely, entirely done everything on Excel. I could have done, you know, I could have made an invitation too there, but I think I should hold myself in. So I did everything like from expenses, like tracking to timeline to schedules and everything.
Awesome. We've had a few people mention wedding. My favorite was the person that tried to put a score to rate how valuable each person would be at the wedding to kind of decide who they were going to invite. And I'm like, what do you do when your husband, you know, your spouse puts a 5 or your partner and you put a 1 for somebody? And he just kind of laughed. He's like, yeah, we finally scrapped it. It wasn't working. And I just kind of laughed. So, you know, it's amazing what we can do in Excel. I had another one that had their, all their life goals in Excel and wanted to review it with their partner. And I kind of laughed. I'm like, how'd that go? It's like, well, we're not using it today. I'm not surprised. So love what we can do in Excel. I always, that's probably one of my favorite questions because I've definitely had some unique answers over the years. Alrighty. So we're going to move into rapid fire. So just a reminder of how this works. The reason it's rapid fire is we're going to go through the questions quickly. You pick an answer. So, you know, if I asked one, you would just say yes or no, or just answer the question quickly. And then at the end, you can give some context because I recognize many of these answers are nuanced, that there may be more. So, you know, I ask you one and you're like, at the end you could be like, well, let me tell you why I said that. And here's what the exception is because there may be one, but just to make it quick. So this should take about just a minute or two to kind of run through the questions. Circular references in models, yes or no?
No.
VBA, yes or no?
Yes.
Lambdas, should we be using lambdas in our financial models?
No.
I have a feeling you might come back to that one. You hesitated for a minute. I made you think. That's good. External workbook links, yes or no?
No.
Do you think it's important to use as many keyboard shortcuts as possible when modeling? Yes or no?
Yes.
Okay. Should financial models always be print ready?
Yes.
Okay. Are merge cells ever acceptable in a model?
No.
I, that's, that I always love people's answers on that one. There's usually strong opinions there. Okay. Do you think financial modelers should learn Python in Excel?
No.
What about Power Query?
Yes.
How about Power BI?
Yes.
Do you believe every financial modeler should be able to build a fully integrated three-statement model?
No.
Okay. And this is a fun one I always get to ask. Will Excel ever die?
No.
That's a pretty common answer. What financial statement do you believe is most important for financial modelers? Is it the income statement, the balance sheet, or the cash flow statement?
I think cash flow. Okay.
Do you have a favorite language model you like to use? One of these LLMs, Claude, Copilot, ChatGPT, or something else?
Copilot as of Okay.
So if I told you you had to pick one and only one for the rest of your models, would you pick sensitivity analysis or scenario analysis?
Maybe scenario analysis.
Okay. Do you believe financial models are the number one corporate decision-making tool?
Yes.
Okay. And the last one, what's your favorite lookup function in Excel? VLOOKUP, INDEX MATCH, XLOOKUP, CHOOSE, something else. Which one do you like?
XLOOKUP.
XLOOKUP. I like it. All right. Is there any of those you want to elaborate on? I know there's a few you had to think about them for a minute. So any you want to elaborate on?
Yeah, on the LAMBDA side, I think it is a new formula, I know, but it still needs to be, you know, to be searched more. How it works, how it can impact in bigger models. It might look that it is working very good, but until unless we are not using it very rigorously, we might not know that how it can affect in the model.
That's a valid point. That makes sense. Another one you thought about for quite a while, maybe you want to elaborate on this, is should financial modelers you know, everybody be able to build a fully integrated three-statement model. You went with no, but it seemed like you thought on that one for a minute. Anything you want to add there?
I like that financial modeler can do accountings and, you know, build the financial statements. But I have also seen some of the financial models which are like, they don't build the full IFRS, right? But still they are like good modelers. They know the knowledge. They, they have all the contacts in there, but It's just that it might work for them like that.
And I agree with you on that one. I like to see what different people say. So I have a similar view because most of my career I didn't build 3-statement models. So, but you know, that's one that some people have very strong opinions on. So it's fun to see what people have to say. All right. As we wrap up here, any final advice or any last thoughts you'd like to share with the audience before we finish up?
Stay curious. That's how you grow and learn modeling standards, shortcuts, new formulas, new approaches to the modeling. That's what makes it very interesting. And just as importantly, help others to learn how to read models and understand the tool and see how truly it can add the values.
Great advice. Stay curious, help others. I love it. If someone's listening to this episode and they want to reach out to you or maybe learn a little bit about you, what's the best way for them to do that?
Ping me on LinkedIn directly. You can also get my mail on LinkedIn. Yeah.
Perfect. I figured it was probably LinkedIn. That's a pretty common answer these days. But, uh, thank you so much for, uh, carving out some of your evening for this conversation, Shreya. I really appreciate it. I enjoyed chatting with you. So thank you.
Thanks for this opportunity. I'm really grateful. I hope to see you somewhere.
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 at www.fminstitute.com/podcast and use code podcast to save 15% when you enroll in one of the accreditations today.
[MUSIC] [MUSIC]
More from Paul

Trust and Leadership Lessons for FP&A From 100+ Top Leaders with CFO Jon Laudie









