Strategic Financial Models for Finance Professionals to Build $100M Businesses with Tim Vipond

Written By Paul Barnhurst

In this episode of Financial Modeler’s Corner, host Paul Barnhurst sits down with Tim Vipond who is a seasoned finance professional and co-founder of the Corporate Finance Institute (CFI). They discuss financial modeling nightmares, strategy’s vital role in modeling, and the importance of avoiding shortcuts. Tim also shares his unique entrepreneurial journey and offers practical advice for improving modeling and strategic decision-making.

Tim Vipond began his career as an investment banking analyst and later transitioned to wealth management, corporate development, and e-commerce finance. As the co-founder of the Corporate Finance Institute, Tim has trained over 2 million students and introduced practical certifications that reshape how finance professionals develop their skills. Tim’s blend of financial expertise, entrepreneurial spirit, and focus on strategy makes him a compelling guest for this conversation.

Expect to Learn:

  • How to avoid and learn from common financial modeling mistakes.

  • Why aligning financial models with business strategy is critical.

  • The journey of building the Corporate Finance Institute and insights into e-learning success.

  • The role of assumptions, execution, and scenario analysis in effective modeling.

  • Tim’s advice on combining unique skills to propel your career.

Here are a few quotes from the episode:

  • “Never take shortcuts in your modeling. It’s tempting when you’re under pressure, but those shortcuts will come back to bite you later.”

  • “Combining two or more unique skills is the best way to get significantly ahead in your career. It’s where you stand out and add the most value.”

  • “Many scenarios in models are not grounded in strategy. Thoughtful, realistic scenarios tied to strategic goals are what add real value.”

Tim Vipond highlighted the interplay between technical mastery and strategic insight in financial modeling. Tim provided actionable advice on avoiding pitfalls, validating assumptions, and connecting models to overarching business goals. His emphasis on skill stacking and execution underpins the value of continuous learning and adaptation in a rapidly evolving field.


Follow Tim:

Follow Paul: 


Follow Financial Modeler's Corner  

Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’.

Visit https://bit.ly/3AK5dYo and use the code “Podcast” to save 15% when you register. 

In today’s episode:
[02:53] Financial Modeling Horror Stories
[06:03] Building the Corporate Finance Institute
[11:18] The Role of Strategy in Modeling
[19:07] Execution and Modeling Feasibility
[22:11] Scenarios and Sensitivity Analysis
[30:52] Tim’s Favorite Investments and Skill Stacking
[34:48] Unique Modeling Stories
[36:06] Rapid Fire Questions
[41:14] Closing Thoughts and Advice


Full Show Transcript
[00:01:20] Host: Paul Barnhurst: Welcome to Financial Modeler's Corner. I am your host, Paul Barnhurst, aka the FP&A Guy. This is a podcast where we talk all about the art and science of financial modeling with distinguished financial modelers from around the globe. The Financial Modeler's 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 modeling this week. I am thrilled to welcome to the show. Tim Vipond. Tim, welcome to Financial Modeler's Corner.


[00:01:56] Guest: Tim Vipond: Hey, thanks so much for having me on. I'm excited to chat with you.


[00:02:00] Host: Paul Barnhurst: A little bit about Tim. Tim began his career as an investment banking analyst at CIBC Capital Markets in 2005. After working on a wide range of mergers, acquisitions and capital raising, he went to work in wealth management at Scotiabank after completing his MBA. Tim worked in strategy and corporate development at Newmont Goldcorp, and then was recruited to be the VP of Finance at SHOES.COM. Following that, Tim co-founded Corporate Finance Institute, which has now trained over 2 million students. We accomplished quite a bit there, Tim. Impressive.


[00:02:40] Guest: Tim Vipond: Oh, thanks. Well, when you condense it all down to a short summary like that sounds impressive.


[00:02:46] Host: Paul Barnhurst: Isn't it funny? Sometimes when you see it all in a short, you're like, wow, I really have done a lot.


[00:02:50] Guest: Tim Vipond: Yeah, distill it right down. Sure. Yeah.


[00:02:53] Host: Paul Barnhurst: We like to start every episode with this question, to kind of have a little bit of fun and see everybody's horror story, because we all have worst model you've ever seen you've had to work with.


[00:03:04] Guest: Tim Vipond: Well, I'll tell you about my financial modeling nightmare. I don't know that it was the worst model ever, but it was definitely the worst modeling experience I've ever had. Actually, way back at the the top of your intro there at CIBC, when I worked in investment banking, I was working on a pitch book late at night, as you often are, we're about to send it out to the client. There was some sort of last minute change that was required, and I don't know why I had to hard code some numbers into the model. It was like a couple minutes to do this. So I was like, okay, the only way to do this is to hard code some numbers later, we need to go back to a previous version of it, and I had somehow saved over. We didn't have autosave back then, and I could not undo this hard coding that I had done. So, you know, it's like 10:00 pm stresses are running high. We need to get this out the door. I completely messed it up. And, you know, I had to have a very hard conversation with the director that I was working with, who was there with me late at night explaining what had happened, and had to then take time to rebuild a whole bunch of stuff. So that was extremely stressful and painful and sort of the. But a great learning experience for me as well.


[00:04:17] Host: Paul Barnhurst: Yeah, I think we probably all have a story where we've done something with hard coding, especially before autosave. I know I've done a few things where I go back and I'm like, wait, I could have swore I saved this. This is not what I expected. And you're just like, go back and redo it. So what's the key takeaway? You said it was a great learning. What was the number one learning from that?


[00:04:36] Guest: Tim Vipond: Yeah. The key takeaway is do not take modeling shortcuts. Meaning when I say shortcuts I don't mean like keyboard shortcuts. I mean don't skip steps because they'll come back to bite you later, right? Anytime you think, oh, I'll just hard code this and remember to change it later, it's actually very likely that you won't remember to go fix it later. Do it the proper way the first time. But it's hard when you're under pressure. Like when there's a deadline to meet and you know, hey, I can do it this quick way. That's not the right way or the right way. That takes more time. There's going to be that tension there. But I would basically say, you know, never take shortcuts in your modeling.


[00:05:15] Host: Paul Barnhurst: Yeah, it's really easy to do and it often comes back to bite you. I'm with you. I've had I've been bit more than once where it's like, oh, there's a hard coded number there. This is not good because you think, oh yeah, I'll remember.


[00:05:28] Guest: Tim Vipond: But you won't. But then you're busy and you get distracted and you're never going to go back and fix it, or it's late at night and you just want to go home and you're just, you know, you're just not going to do it. So. So don't do it. Although I'm sure you know, it'll probably happen again for some reason or another.


[00:05:40] Host: Paul Barnhurst: Oh, I'm sure it will. It's like FP&A when you're in the middle of the night trying to load that budget, and the numbers don't tie, and you're finally like, just plug it. I'm going to bed. I don't care anymore. We'll figure out the million dollars later.


[00:05:50] Guest: Tim Vipond: Just insert a plug line. Yeah. Great.


[00:05:53] Host: Paul Barnhurst: You know, generally not good ideas. We've all been there. When you're tired enough, sometimes you do it, but it doesn't mean it's not going to come back to bite you. So I would love to know the story of how you built the Corporate Finance Institute into what it is today. How did you get into training?


[00:06:11] Guest: Tim Vipond: Sure. Yeah. Happy to talk about that. It's sort of a bit of serendipity, if you will. A bunch of things came together, but after working in corporate finance for a while, I realized I wanted to move up through an operating company like Gold Corp, where I worked, for example, be an executive or, who knows, maybe a CEO someday. And I realized that all these great executives had awesome public speaking skills. They were really comfortable talking to investors, to all the employees at the company. I wasn't very comfortable with public speaking. And I thought, what's a way I can do some public speaking? Well, if I design a course about financial modeling and go deliver it at the university where I live in Vancouver, UBC, that would be great public speaking experience. So I did just that. And doing that got me connected to a company called MDA training, which was actually hired by this university to financial modeling training. So I was actually competing with them without even really realizing what I was doing, because I kind of hacked my way in to go teach this course that MDA was paid to teach. That got me connected to them. And they said, hey, why don't you work with us and teach with us? And so I did a little bit on the side, but I said, look, ultimately I don't want to be a live instructor.


[00:07:22] Guest: Tim Vipond: I want to, you know, be an entrepreneur or an executive or something. And, we came together to start Corporate Finance Institute with some training materials that they had developed over the years. You know, they've trained countless global banks. I've even gone to one of their training programs in London for Deutsche Bank for a week, where we trained, you know, hundreds of new analysts at Deutsche Bank. So it was quite a thing to behold, actually. But that's how that's how it all got started. And then I went on to work at Shoes.com and while working at Shoes.com, I was obviously like very deep in the sort of e-commerce and SEO space. And I realized from looking at Shoes.com business that organic sales were much better than paid sales. Might sound super obvious, right? But it was like, hey, if you could build the whole business on organic traffic, that would be the ultimate way to build an online business. So I focused a huge amount of effort on articles and content creation for SEO, for Google search, but then ultimately for YouTube and basically all the organic channels which had this nice virtuous cycle of then feeding back into content for the eLearning business.


[00:08:34] Guest: Tim Vipond: Right, which created more marketing content and getting that cycle going. So, that was a big focus in growing the business. And then maybe the one other thing I'll add as well is that, you know, at the time, everyone in the online training space just had a collection of courses. There was really only one certification out there that was CFA and like all finance professionals, kind of defaulted to CFA. But the programs mostly focused on portfolio management, right. Which is not relevant for a lot of people in finance. So I thought, hey, there should be an alternative to that. There should be something that is extremely practical and useful for a bunch of other finance roles, like FP&A and investment banking and so on that do financial modeling that doesn't cost a fortune or take four years to complete like CFA. The pass rate on CFA, I think all the way through last time I checked is like 30% or something through all the levels. So I was like, okay, that's not working for a lot of people. And that's what that's what led us to create the FP&A and the other designations that we've created along the way.


[00:09:41] Host: Paul Barnhurst: Got it. No. That's helpful. I appreciate you sharing that. And yeah, you know, I see a lot of people think, should I take CFA? And I'm like, if you're in corporate finance, it's really not relevant. There are areas where it can be helpful, but there are a lot of other certifications you can take. I wouldn't take it just because it's well known.


[00:09:58] Guest: Tim Vipond: That's right. It is a badge of honor, though, or an indication that you are obviously smart enough and hardworking enough to get through it. So I think that could be, in and of itself, a great reason to take it. And it's, you know, no disrespect to it. It's a great program. It just doesn't work for a lot of other people, I think.


[00:10:16] Host: Paul Barnhurst: Yeah, there's different ways to do it. It's not the only one. It's a great program. No, I did level one. I've had Rob Rick, if you know him. Who? He manages a lot of the content for CFA, he's over. Yeah. A number of the programs there, I've had him on the podcast. And, you know, if you do it, you're definitely dedicated. There's no question you have to put in a lot of time to pass CFA. I remember how much I studied for level one and then just realized, not really going to use 2 or 3, I'm going to spend my time elsewhere.


[00:10:46] Guest: Tim Vipond: Yeah, but if you want to be a portfolio manager like. Oh, absolutely critical. You have to do it.


[00:10:51] Host: Paul Barnhurst: Yeah. Great. Yeah I agree if your portfolio investment, there's areas where you want it and it's fabulous. There's other areas where you have to decide if it makes sense. Yeah. What I want to jump into when you and I chatted ahead of time before, you know, coming together to record the episode, one of the areas we talked about was the importance of strategy. Right? We always hear technical skills and hey, you got to be good at Excel and know your shortcuts, understand your accounting. But I think a lot of times people don't realize the role strategy plays in modeling. So I'd like to get your thoughts, you know, what role does strategy play when you're building models?


[00:11:30] Guest: Tim Vipond: Yeah, that's a great question because I don't think this gets talked about enough. But, it's absolutely critical in building a useful financial model. Right. I often think about things as, like the high level big picture or the nitty gritty details, right, that are both critical for a world class financial model. You need to have that big picture and the detail. Now, it's easy to get dragged into the detail of the formulas and the functions and, you know, really sort of detailed calculations. But if you've lost sight of like, wait a minute, does this even fit with the company's strategy? You know, the model's not going to be that useful actually. So there's that. Another thing is strategy to a big part is about trade offs and strategic choices, right? So it's easy to be looking at scenarios in a model and say, oh, what if we increase prices or decrease costs and change all these assumptions and variables? But again, like you have to tie that back to the strategic choices or sort of mission vision purpose big, the bigger picture things that the business has said that it cares about, right. Or otherwise. You're just sort of doing this exercise, you know, on your own in isolation. It's not going to be very useful. So, that's another comment that I'll make just about strategy and financial modeling.


[00:13:01] Host: Paul Barnhurst: Yeah. Funny, I had a boss and I really liked the way he put it when you said trade offs. He goes. Strategy is about closing doors. There's going to be more opportunities than you have time or resources for. You have to decide which doors to close and which ones to leave open. And I really like that way of how he explained it, because it's sometimes we just want to do everything. I'm sure you struggled with that as you were growing CFI is getting distracted by opportunities that really may not have made sense to the core business.


[00:13:34] Guest: Tim Vipond: Absolutely. And I love that analogy about the Doors because, I think about that one. I think Jeff Bezos used it too. But he added one extra layer to that, which is like there are one way doors and two way doors. And this is also important in strategy. Like if you're going through a one way door you can never go back. You have to think very carefully and strategically about if you want to go through it now. But there's a lot of doors actually, that, you know, it's not that big a deal. We can go back and forth, maybe changing prices, an example of something where you can go back and forth. Right. So there's that as well, which I think is interesting. And absolutely with CFI, like staying focused on what works, what adds value for our students, right, like our core principles and all that kind of stuff. Absolutely. It's a big part of running a company.


[00:14:23] Host: Paul Barnhurst: Yeah. No, I mean, I think it's true for any company, right? You got to kind of figure out what your core principles are and how you stay true to your strategy. We've all seen it. There's so many companies where you're like, how does that fit with strategy? You know, the example I gave I worked at American Express and we started prepaid cards for the unbanked and underbanked. And it's like, how does that really fit with American Express's image, its strategy, its brand? And the reality is, it didn't. And they reorganized that whole department and then sold it off once they had eliminated a lot of the cost.


[00:14:55] Guest: Tim Vipond: Right. I mean, if their brand is about exclusivity and luxury and like you sort of by definition, then how can you go in this other direction? So that's an interesting example, right.


[00:15:06] Host: Paul Barnhurst: Yeah. Yeah. And there's others like that. You know, some of these airlines trying to be low cost airlines with a regular cost model, but it's not going to work like. And the other one I've always loved is I had someone say, you know, strategy you'll be able to see in the bottom line, if you have a good strategy, you're going to have above average return. You should be able to see it in your financials, maybe not immediately, but over time.


[00:15:29] Guest: Tim Vipond: And I would say strategy coupled with execution, you know, like what's the quote. It's like amateurs talk strategy. Professionals talk logistics. That's I think it's a military expression. But it's only to say that like a strategy without execution is nothing. And, you know, that's just something else that I think back to tie back to financial modeling, right? I think the model can help you see the execution. Like you have this strategy, but once you break it down into all the steps that are required to execute on it, you know, from the people you have to hire to all the things you have to do. It's like, wait, does this can we actually execute on this, you know, with a set of reasonable assumptions or not?


[00:16:15] Host: Paul Barnhurst: Yep. And that leads me to two questions. First one is, you know, how does a modeler get comfortable discussing strategy? You know, making sure the model makes strategic sense, because I think sometimes the modeler feels like I'm just here to build the model right and put in the assumptions, but they'll see things that they can tell like this doesn't make sense or this doesn't align. How do you get comfortable having those conversations?


[00:16:40] Guest: Tim Vipond: You know, I think a great place to get started. Whether you're at a public or private company, is to look at the public companies because there's so much out there on their strategies. So if you're at the public company, you look at that. If it's private, look for the comparable. That's public. Okay. Go to the ER section of their site. Look at the quarterly earnings calls like listen to those calls. Look at the slide decks that they put together. They're going to talk a lot about strategy in there. Listen to the equity research analyst ask their questions. They're going to ask great questions related to strategy. And then you can also even get the proxy statement or some other filings that will have the CEO's objectives. Right. So if you're thinking all the way back up to the CEO's objectives, like you can't get much higher, higher level than that of like are these decisions and things we're talking about down here? Do they map like back up to some corporate objective that we've publicly stated. Right. So I think that's a good way to get comfortable because first you're reading about it. You're seeing questions or listening to questions that are being asked. And then you can start to like, bounce those off people at your company. Just talk about the industry and the strategy with people. I think that is a great way to get started.


[00:17:57] Host: Paul Barnhurst: I really like how you talked about just the importance of reading the company's financials, the statements, the strategy. Right. Public companies, they're going to state all that right there in their ten Ks, ten Qs, their investor relations, those calls. They're going to let the public know how they're thinking about things and what the risks are. And so much that you can bring into strategy. And listening to some of those, you get to see the questions that analysts ask often around strategy, and that may inform some of the questions you're going to ask. And then also just knowing the company's goals, you know, what's the CEO trying to accomplish. And you know what we're building in this model. Does that align with that or is it totally different.


[00:18:37] Guest: Tim Vipond: Exactly. Exactly. Paying it and paying attention to the industry. Right. Like what are other companies doing in the industry? Because that leads to great discussion, right. Just bringing it up with colleagues of like, hey, did you notice that one of our competitors is doing this or doing that? Okay, what does that mean vis a vis our strategy? You know, you build the muscle, let's say, of reading about and talking about strategy. And then I think it'll naturally make its way into the financial modeling at least hopefully.


[00:19:06] Host: Paul Barnhurst: Yeah. No, I agree. And the second thing you talked about, you know, their strategy and then there's execution as you mentioned the logistics earlier. Yeah. And when you're building a model how do you think about that. Because I mean most of that happens after the model. But is there things you should be thinking about. Like is it possible to execute this or these realistic assumptions. Is that what the modeler should be looking at, kind of from that execution standpoint is more the validation to say, is this possible? And pushing back if things don't seem achievable?


[00:19:37] Guest: Tim Vipond: Yeah, I think that's right. I think maybe there's a bunch of places we could jump off from that question. You know, one is about assumptions, right? Like, are the assumptions that are required to, to hit this realistic or doable? You know, that's one place like, I like to think about the assumptions above, what I would say is like above the revenue line. So it's like, what are the activities and the things you need to do that ultimately lead down to revenue? To me, that's a guide to some degree. You know, like let me just give you a really simple example, like, I mean, if you were building a financial model for Chipotle and you were thinking about their revenue, I just happened to recently see this example. That's why I bring it up. Their CEO has an objective one of his like, three objectives is the number of restaurant locations that the company reviews each year. And, and then you sort of realize, like, okay, they're reviewing 3 or 400 new restaurant locations every year. If they want to double revenue, like, realistically, how many restaurant locations can they review in a year? What does that mean for the team? Like you think of then? Because this will connect to say like fixed costs or not, right? Like do you a lot of times companies think they have a fixed cost structure, so they have operating leverage. But the reality is like actually if you want to scale up revenue, you're going to actually some of these so-called fixed costs are actually going to behave more like variable costs. You're going to have to expand your team and so on. So, you know, there's this kind of a circular exercise, if you will, of going through assumptions and then numbers in the model, strategic objectives. And just like working your way through all of them. And so I don't know if that made any, if that was coherent or not.


[00:21:28] Host: Paul Barnhurst: But that was helpful. I get what you're saying. There's a circular in the sense of you go through the strategy, you put in the assumptions, you got to look at the outputs and say, hey, based on these assumptions, does this past a certain level of a sniff test? Does this even seem achievable? Because we've all been there. I'm sure you've done it. You look at a model, you get all done, you look at the number and go, either there's a formula messed up or an assumption doesn't make sense because that's not possible.


[00:21:53] Guest: Tim Vipond: Yeah, exactly.


[00:21:55] Host: Paul Barnhurst: Yeah, I've definitely done a few of those. I still remember somebody giving me a number of like, you know, $10 billion. I'm like, you didn't question this. You know, the industry is only like five. We're not going to double the industry by launching our product.


[00:22:09] Guest: Tim Vipond: No. Exactly. And, yeah. And then that this will connect to scenarios as well. Right. Because scenario analysis is of course a big part of financial modeling and maybe even strategic planning, you'd say. But I think you really have to dig into those scenarios with a strategic lens to see if they make sense. A lot of times, in my view, the scenarios that are thrown into a model like your classic upside case, downside case, base case are not grounded in strategy at all. Like they're just like, hey, what if. What if our revenue grows way more than expected and our costs go down for some weird reason, like, you know, sort of interplays between variables that are unlikely to actually happen. I think you want to be very thoughtful on your scenarios and your sensitivity analysis and understanding, like correlations between things in the business, right, that might move together or move or move separately from each other. So that's just another thought as well.


[00:23:08] Host: Paul Barnhurst: FP&A guy here and as you know, I am very passionate about financial modeling and the Financial Modeling Institute's mission. I have been a huge fan of the FMI for years, and I was super excited when they decided to sponsor the Financial Modeler's Corner. I recently completed the Advanced Financial Modeler certification and love the entire experience. It was top notch from start to start to finish. I am a better modeler today for having completed the certification. I strongly believe every modeler needs to demonstrate they are a qualified financial modeler, and one of the best ways to do that is through the FMI's program. Earning the accreditation will demonstrate to your current and future employers that you are serious about financial modeling. What are you waiting for? Visit www.fminstitute.com/podcast and use Code Podcast to save 15% when you enroll in an accreditation today.


[00:24:13] Host: Paul Barnhurst: I fully agree with you on scenario. I think sometimes we confuse sensitivity and scenario and kind of mix them in a way that's not good versus a good example. Let's take Tesla. You know, if Tesla is building a case, one case would be all right if we end credits. That has been talked about on EVs. What does that look like then all your assumptions are based on a case, and you could also decide what are the management decisions we're going to make if the scenario happens, which I think is the more important part than just having the numbers right, is how does that impact the decisions we're going to make, like for recession, if I build a business case that says the recession is coming next year, what's the trigger to let me know? I should start following that case? And what are the things I should be doing differently because of that? Not just well, I got base high and low, which we've all done. I've built, you know, and then we walk away and go, okay, I feel good. I've done my scenarios now we stick in one number and we just go forward.


[00:25:11] Guest: Tim Vipond: Yeah, I like what you said because you're now connecting it to like KPIs and sort of a more of a reporting lens. Right on. What are those metrics and KPIs you want to be tracking that are connected to the model but are part of like monthly, quarterly, whatever frequency meeting and reporting you're doing. Yeah.


[00:25:31] Host: Paul Barnhurst: So I'm curious, you mentioned, you know, analyzing things through strategic lens. Is there like a strategic framework you'd like to use throughout your career or any kind of methodology that's helped you?


[00:25:42] Guest: Tim Vipond: Yeah, that's a good question. I mean, there are so many frameworks and methodologies out there, right? Almost build a mosaic with all these different, you know, they're often like two by two matrices and things. Yeah. You know, find all the classic ones. I don't think any one is better than the other. I think it's about trying a number of them and seeing what provides insight for you. If you want to start with a SWOT analysis, because it's really simple to get things going. Start thinking internally and externally about your business and your industry. That's a good jumping off point. I really like the strategy House, which is a one page framework that kind of brings everything together. So it's like literally the shape of a house with a roof is like the vision and the mission underneath that are like the must win battles or strategic choices that you're making. Beneath that are the strategic initiatives or like projects that you're working on. And it's all supported by capabilities and people and culture. Something like that. Right.


[00:26:46] Guest: Tim Vipond: So the reason I like this one slide is you get a quick bird's eye view of like, how do we execute the vision or the mission. What are the key projects that we want to work on? I like the simplicity of that, you know, so that's nice as well. And finally, I think you want to just be grounded in first principles, thinking right about sort of the what and the why of the business. We mentioned trade offs earlier. Right. Like also having sort of a mental framework that thinks about trade offs, not just like we'll do everything or what have you. So there's that. Then we could talk about execution. We already talked about execution a bit. But then you could say, okay, how does this fit into the planning cycle? So I also like frameworks that you have your annual planning cycle that obviously includes budgeting and like the CFO office and the CEO's office, connecting that with the strategic planning that goes on across the company. Right, as well.


[00:27:48] Host: Paul Barnhurst: A lot of stuff there. And I like how you mentioned one. Pagers are always helpful. I think, you know, start starting with simple frameworks is always a good way to go, because there are some frameworks that can be really complex. And there's a lot of simple two by two matrix, and there isn't one right framework. Right. There's a reason there's dozens of them.


[00:28:07] Guest: Tim Vipond: Exactly, exactly. There's no silver bullet. If only it could be so easy that there's this one secret framework you use and you'll be off to the races. Right? I think you just gotta. You just got to try a bunch of stuff and see. See what works.


[00:28:18] Host: Paul Barnhurst: Well, if you find it, let me know, because I'm sure a lot of money off it.


[00:28:22] Guest: Tim Vipond: Yeah. You and I can launch something with that.


[00:28:26] Host: Paul Barnhurst: So true. So I'm going to ask you a question. Kind of wasn't on the list, was we were talking. You got me thinking about it. You've, you know, you've built a lot of models over your career. You've done a lot of training. Is there a favorite industry you like to model? Like one in particular that you enjoy kind of thinking about and working on models?


[00:28:43] Guest: Tim Vipond: Well, I can just comment on okay, maybe two things. One, that was very interesting was the mining industry, because there is so much modeling that takes place before revenue like to get from the material that's in the earth of, of like rock that has a grade of metal within it and then has to go through extraction, processing, refining, smelting, etcetera, etcetera to revenue. That part of the model in mining is enormous. And it's very and so, so I found that fascinating to be involved in building, I actually built the corporate model that we redid the corporate model at Goldcorp. So it's like quite an undertaking to get, you know, whatever 100 rows it was to get to revenue was fascinating and then was helpful for me later. Formulator. But I guess I really like you know being well with CFI and Shoes.com where I've had experience in consumer businesses. I really like you know thinking about let's say funnels of traffic and users and conversion rates, you know, to get you to revenue. So I personally am passionate about like online businesses and conversion rates and that kind of thing. So. Anyway, it's also fairly simple to model, which I like.


[00:30:02] Host: Paul Barnhurst: Yeah. No, those are fairly straightforward. Unlike I know mining can be complex. I've had some mining guests on and I was having a conversation very recently with someone that's doing a lot of modeling for pharmaceuticals. Right. And that's a really hard one because it's all optionality and weighing risk. And it might be ten years before you even collect any revenue. And so it's like, how much money are you willing to spend knowing there's a chance that this may never even generate any revenue.


[00:30:29] Guest: Tim Vipond: Totally. And if you have like, yeah, I imagine it's pretty binary, right? You have a blockbuster drug that just takes you to the moon or you or you flop on a whole bunch. So I imagine that would be interesting. I've never built a pharmaceutical model, but, yeah, so many, so many types of models out there.


[00:30:45] Host: Paul Barnhurst: It really is. Yeah. I haven't built a pharmaceutical, but it was just interesting to think about in that whole portfolio approach, just so different than what I built. So I want to ask you a little bit, you started your own ventures, kind of your own family owned investment firm. So do you have a favorite investment you've made today? Tell us a little bit about that.


[00:31:02] Guest: Tim Vipond: I mean, I guess the one that I like talking about the most is an investment I made in a ready to drink tequila beverage called Olé, which I think is making its way to the United States now. It started in Canada, but it was a tremendous growth story for like, in the ready to drink beverage space. Tequila is really hot recently, and there's like a strong trend in place for ready to drink tequila beverages. So the founder of this business built an incredible brand. And I really admire, you know, people that have built great brands. So he nailed like he first of all he nailed the formula and the taste of the drink. But then he nailed the marketing and the distribution. And so it was really cool business and it was actually recently acquired. So I didn't get to hold it for too long, but it worked out well financially. And it was really fun, like getting to know the founder and builder of that, of that business.


[00:32:00] Host: Paul Barnhurst: Fun. And how did you pick the kind of investment you're going to go for? Like what? What attracts you to a deal?


[00:32:07] Guest: Tim Vipond: It's just like, honestly, I don't focus on any particular sector or industry or anything. This came to me through my lawyer. He said, hey, like, you know, this company is looking to raise money sort of privately, if you will, and maybe you want to take a look at it. And so it just comes in through lawyers, accountants and your personal network really, I think, for some of these best opportunities. But I would say for direct investing, you know, I just have to believe in the opportunity, right in the like the founder, the story, the market, the financials, just kind of tying it all together.


[00:32:41] Host: Paul Barnhurst: Yeah, that makes sense. So for you it's really there isn't an industry. It's just finding deals that interest you that seem to make sense, that are attractive regardless of industry.


[00:32:51] Guest: Tim Vipond: Yeah, exactly.


[00:32:53] Host: Paul Barnhurst: Makes sense. Yeah. All right. So I'm curious over your career. As you look back on your career, what's the number one lesson you've learned that you could share with our audience that's helped you the most in your career?


[00:33:05] Guest: Tim Vipond: Yeah, I appreciate that question. I thought about it a lot, and I was, and I've realized that combining two or more unique skills is probably the best way to get significantly ahead. If you're if you're just, say, an accountant and like and that's great. But you want to be the best accountant in the world. Well, you're competing with like, however many million accountants that are just accountants. But if you're an accountant and you are like an AI expert or enthusiast or and or a particular industry that you have a tremendous amount of experience in, that's where now you're competing with a lot fewer people. And you can propel yourself forward a lot more quickly. So just like any, any two things that form a unique combination, or if you can add a third thing like that, you know, that's great as well. So, you know, in my case, like combining, you know, what was meant to be about public speaking with having worked in e-commerce with having a finance background. Right. Like I combined those three things together to build CFI so that that would be my number one tip, if you will.


[00:34:21] Host: Paul Barnhurst: I think there's a ton of value in that. And I've heard someone call it skill stacking, right. Having 2 or 3 skills that you're really good at that allow you to stand out and have a much smaller pond, so to speak, that you're competing against.


[00:34:36] Guest: Tim Vipond: Exactly. I like that term skill stacking. I hadn't heard that, but it must be the same thing.


[00:34:40] Host: Paul Barnhurst: Yeah, yeah. Same idea. I don't remember somebody said it on a podcast once and it kind of stuck with me. I like that because it was just an easy way to remember it. All right. So what's the funniest, funniest thing, most unique thing you've created a model for in your personal life?


[00:34:56] Guest: Tim Vipond: Yeah. Well, I don't know if it's funny, but perhaps it's unusual, but I did create a spreadsheet for my marriage, which is to actually, like, try to manage, you know, having a partner in life. And I created a dashboard that's like, the things that each of us need to make us happy, the things that we want to do each week and each week, you can go in and update, update the numbers and actually, like, have a sort of a dashboard report, if you will, on the quality of our marriage and the quality of our personal life.


[00:35:29] Host: Paul Barnhurst: And how did you like it when you first came up with that?


[00:35:32] Guest: Tim Vipond: She didn't like it as much as I did. I thought it was pretty cool, but she didn't really land as well with her. And, I kind of we don't even use it anymore, but at least it was fun to build it. And at least, you know, we had some good conversations about it. I think it actually sheds some light on things, you know, but, yeah, that's probably the most unusual thing that I built one for.


[00:35:55] Host: Paul Barnhurst: That's great. Yeah. I was like, I could definitely see where it could shed some light. Lead to good conversations. I was just wondering how she received it, because I know what my wife would say.


[00:36:05] Guest: Tim Vipond: Hahaha. Oh.


[00:36:06] Host: Paul Barnhurst: All right. Great. So we're going to move on to the rapid fire section. How this works is you can't say it depends as an answer. You have to pick a side, realizing there's nuance to all of these questions. Then at the end you can elaborate on 1 or 2 that you're most passionate about to kind of explain, hey, here's why I gave the opinion I did. Here's a little more nuance. So the first one, circular references and models. Yes or no? No VBA. Yes or no. No. Horizontal or vertical model. Do you prefer multiple sheets or kind of putting it all on one sheet?


[00:36:42] Guest: Tim Vipond: 100% vertical.


[00:36:44] Host: Paul Barnhurst: 100% I like it.


[00:36:46] Host: Paul Barnhurst: Dynamic arrays yes or no? No. All right. That will answer the next one of should we do fully dynamic models? That would be no as well. External workbook links.


[00:36:57] Guest: Tim Vipond: No.


[00:36:58] Host: Paul Barnhurst: All right. Named ranges yes or no.


[00:37:02] Guest: Tim Vipond: Yes. But let me explain later.


[00:37:04] Host: Paul Barnhurst: All right. We'll give you that one at the end. Do you follow a formal standard like fast or some of the other smart or others that are out there for your models?


[00:37:13] Guest: Tim Vipond: Well, I'd say I follow the CFI standards that we've created. Yeah.


[00:37:18] Host: Paul Barnhurst: You created your own. All right. Should financial modelers learn Python in Excel?


[00:37:23] Guest: Tim Vipond: For other people, probably yes. For me, no, I have not.


[00:37:28] Host: Paul Barnhurst: I haven't either, so I get it. What about Power Query.


[00:37:31] Guest: Tim Vipond: For other people? Yes.


[00:37:33] Host: Paul Barnhurst: All right. How about power BI?


[00:37:36] Guest: Tim Vipond: Yeah, definitely. Yeah.


[00:37:37] Host: Paul Barnhurst: All right. Will excel ever die?


[00:37:40] Guest: Tim Vipond: No, and I can also explain why on that later if you like, but no.


[00:37:44] Host: Paul Barnhurst: All right. We'll let you do that one. Will AI build the models for us in the future?


[00:37:49] Guest: Tim Vipond: Yeah, definitely. To some degree.


[00:37:52] Host: Paul Barnhurst: Okay, what about cell protection? Should we be using that in our models?


[00:37:56] Guest: Tim Vipond: No. Don't bother.


[00:37:58] Host: Paul Barnhurst: All right. Do you believe financial models are the number one corporate decision making tool?


[00:38:03] Guest: Tim Vipond: Like, if I had to pick one. Yeah, I would say. I would say definitely not the only. But if you're ranked stack ranking them.


[00:38:10] Host: Paul Barnhurst: Yeah sure. Yeah. Yeah. Not saying the only just kind of the biggest. Would it be at the top of the list. Yeah. All right. What's your lookup function of choice. Choose Vlookup index match Xlookup something else.


[00:38:22] Guest: Tim Vipond: It is definitely index match.


[00:38:26] Host: Paul Barnhurst: All right, I figured that's probably where you would go. And your favorite Excel shortcut.


[00:38:31] Guest: Tim Vipond: Okay. If we're talking keyboard shortcut. Yeah. Keyboard. If it's keyboard shortcut, it's control R for sure. All day long it's always control R, but if it's like a more of a function I would say go to special like is F5 like as a, as a different kind of shortcut?


[00:38:49] Host: Paul Barnhurst: Those are two great ones. All right. You want to elaborate on one and two, I believe circular references or maybe something else. What were the ones you wanted to elaborate on?


[00:38:56] Guest: Tim Vipond: Oh, well, I was saying for named ranges, right? I actually don't really like using them except to make a dynamic chart. So there's a cool way you can use named ranges and like an offset function, so that when you add more data to a table, the chart will capture that and update it. So you don't have to do all the selecting of your chart. But generally speaking, I don't like naming ranges or cells or things like that in models. I think it makes it harder for other users and sort of for auditing and other reasons. But so it's like to me one use case for named ranges. Okay.


[00:39:33] Host: Paul Barnhurst: Fair enough. And then on the Excel dying, you mentioned you share your thoughts why it's never going to die.


[00:39:40] Guest: Tim Vipond: Well, because if I step all the way back and ask myself what is Excel? If it's a spreadsheet like meaning a sheet that is a grid with rows and columns, that interface is never going to go away. Like, I can't think of any other way to analyze numbers that's not in a grid. That's very useful to me. So, I think Excel itself is going to change massively with AI and the way we use it's going to change and everything, but I think we'll still want to go back to this interface. That's a series of rows and columns.


[00:40:17] Host: Paul Barnhurst: And I agree with you. Whether Excel survives or not, and I always say it will die because everything dies. I don't see the spreadsheet interface ever going away.


[00:40:25] Guest: Tim Vipond: Yeah, yeah. Okay. Good point. If we're saying like a zero hedge, everything's dead in the long run. Sure. But yeah, all.


[00:40:33] Host: Paul Barnhurst: Depends on how you define it. Right? And since I get to ask the questions, I make sure I win.


[00:40:38] Guest: Tim Vipond: Yeah. Nice.


[00:40:42] Host: Paul Barnhurst: I couldn't resist. It's gotta have a little bit of fun, but I totally know what you mean. I mean, like, obviously in the short term, Excel's not going anywhere. It's going to change. It's going to adjust. But that, like you said, the row column interface, it's hard to replace. It's fabulous for so many things.


[00:40:58] Guest: Tim Vipond: Absolutely. And I mean, where else would you go to brainstorm or plan something that like. Right. You know, when you just want to try on an idea, right. Like where else are you going to go but a spreadsheet to play with those numbers?


[00:41:12] Host: Paul Barnhurst: Yep, I hear you. All right. So we're going to wrap up here. I have two more questions for you. The first is if you could offer one final piece of advice to our audience to be a better financial modeler, what would be that piece of advice you'd offer them to get better at modeling?


[00:41:31] Guest: Tim Vipond: Well, I hate to ask if I can give two, but since we've been talking technical.


[00:41:35] Host: Paul Barnhurst: Thank you.


[00:41:36] Guest: Tim Vipond: Appreciate it. Okay, so if we're talking technical reverse engineering of other people's models, I think it is the best way to improve your skills. So what I mean by that is like find examples of models that you think are interesting, that are good or whatever that excites you about them, and try to rebuild what they've done. And I don't mean like just copy like look at cell A1 and copy 1 to 1 like that. I just mean get to the same answers or results that they've gotten to and using it as a guide. And if you do that, you'll really learn. You'll probably improve on their model, quite frankly. You'll not only learn how they built it, but hopefully find some ways to make something better. So that's on the technical side. But then since we've been talking about strategy here, I think going back to what we talked about earlier with looking at public companies, CEOs, scorecards, corporate scorecards, investor decks, and playing around with models that you've got and trying to connect them back to these strategic objectives and just trying to trying to connect those dots, build the mental model or mental framework to see that that would be my other one.


[00:42:49] Host: Paul Barnhurst: Thank you. Great advice. I appreciate you giving too. I like how you went with the technical and more on the strategic side. So last question. If our audience wants to learn more about you or potentially get in touch with you, what's the best way for them to do that?


[00:43:01] Guest: Tim Vipond: Sure. I mean, the best way to get in touch would be LinkedIn. Just my profile. You can find me there. And of course CorporateFinanceInstitute.com. You can read more about me there or check out some of my courses or some of my colleagues courses there as well.


[00:43:16] Host: Paul Barnhurst: All right. Well thank you, Tim. I thoroughly enjoyed having you on the show. Really enjoyed chatting. And thank you for sharing some thoughts on strategy. You know, about modeling in general, and I am really excited to share this with my audience.


[00:43:29] Guest: Tim Vipond: Oh, thanks. It was an absolute pleasure. Thanks for having me.


[00:43:32] Host: Paul Barnhurst: Financial Modeler's 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 modeling. 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.

Paul Barnhurst
Previous

Named Ranges and External Links Fixes for Finance Professionals to Build Accurate Models with Joel Steendam
Next

Why Losing My Dream Job Made Me the FP&A Tools Expert with Paul Barnhurst