The FP&A Guy

View Original

Unraveling the Mystery: Roderick Mckinley's Guide to Navigating Tokenomics

See this content in the original post

Show Notes

Welcome to the Financial Modeler's Corner (FMC), where we discuss the art and science of financial modeling with your host Paul Barnhurst. Financial Modeler's Corner is sponsored by the Financial Modeling Institute (FMI), the most respected accreditation in Financial Modeling globally.

In today’s episode, Paul engages in a conversation with Roderick McKinley, blockchain & Tokenomics advisor of Rmckinley.net. 

Roderick, a crypto expert, discusses financial modeling in the crypto space, highlighting challenges like token volatility and treasury management. He emphasizes aligning incentives for healthy exchanges and discusses his online course on Tokenomics Modeling and fundraising.

Roderick also offers strategic guidance, product development, and Tokenomic design services for various blockchain applications, including DeFi, blockchain games, and Layer 1 protocols. He assists in developing tokenized business models, designing token utilities, and structuring token allocations for successful capital raises.

In this episode, expect to learn:

  • Understand the integration of finance, blockchain, Tokenomics, and strategic guidance for blockchain projects.

  • Gain insights into challenges and opportunities in transitioning from traditional finance to the crypto space.

  • Learn how to navigate complexities like token volatility and incentive alignment in blockchain projects.

  • Obtain practical tips on developing tokenized business models, designing token utilities, and structuring token allocations for successful fundraising.

  • Acquire valuable knowledge for navigating the evolving landscape of blockchain and cryptocurrency.

Quotes:  

“Financial modeling often has a lot to do with client and industry expectations. What passes as good work or what passes as good enough can change very dramatically from country to country and sector to sector.”

“Some of the stuff they teach you is that, well, the world's this way because it can't be any other way. And you pass exams sort of like explaining why it's impossible to fix things but suddenly blockchain technology actually gives you a completely different kind of tool chest that opens that up again.”

“Models are built for a single primary purpose at the time that they are conceived”   

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

Visit www.fminstitute.com/podcast and use code Podcast to save 15% when you register.  

Go to https://earmarkcpe.com, download the app, take the quiz and you can receive CPE credit.  

Follow Roderick:    

 Follow Paul: 

Follow Financial Modeler's Corner  


In today’s episode:  

(01:10) Introduction;

(01:55) Rodrick’s horror story;

(03:55) Rodrick’s background;

(05:25) Getting stuck on a tropical island;

(06:08) Rodrick’s love of problem-solving, geeky coding, and number-crunching;

(11:50) Interview with Boris Johnson;

(13:17) Definition of token economics;

(21:39) How do crypto companies manage their treasury;

(28:04) Simplifying Tokenomics modeling;

(30:01) Deciding on tool selection;

(35:51) Rodrick’s Favorite and Most Valuable Excel Shortcuts;

(37:25) Rapid fire;

(42:42) Wrap up;


Full Show Transcript

Host: Paul Barnhurst: Welcome to Financial Modeler's Corner. I am your host, Paul Barnhurst. In this podcast, we talk all about the art and science of financial modeling with distinguished financial modelers from around the globe. The Financial Modeler's Podcast is brought to you by the Financial Modeling Institute. FMI offers the most respected accreditations in financial modeling. I'm thrilled and excited to welcome this week's guest to the show, Roderick McKinley. Welcome to Financial Modeler's Corner.

 

Guest: Roderick Mckinley: Hey, Paul, thank you so much for having me on here.

 

Host: Paul Barnhurst: Yeah, we're really excited to have you. I was very excited to bring you on after you and I had an opportunity to chat and learn a little bit more about yourself. So let's get started with the first question we ask everybody. Tell me about that horror story. The worst financial model you've ever seen. I know you have one.

 

Guest: Roderick Mckinley: Yeah, the one that comes to mind was this real estate model that was passed to me by a professional working for a famous billionaire real estate developer in the US. And I was just absolutely shocked at this thing. It was it had no structure. There was some giant matrix in the middle, hard codes everywhere. And I was just in disbelief because this guy was famous and he had all of these guys working for him on things that were projects that were high stakes and high value. But this was absolutely shocking. It was absolutely terrible. And it was just that disconnect between the seriousness of the deal and the shoddiness of the work, that was shocking.

 

Host: Paul Barnhurst: Interesting. That's surprising for that big of a deal. So what was maybe the key takeaway or learning experience from seeing that?

 

Guest: Roderick Mckinley: That financial modeling often has a lot to do with client and industry expectations. What passes as good work or what passes as enough can change very dramatically from country to country and sector to sector. And it's not that was a cue for me to feel like I could start being sloppy whenever I was working in real estate. But it was just an incredible example of how standards vary and that's something you should be aware of if you do. Sort of like if you're someone who moves around the space a fair bit.

 

Host: Paul Barnhurst: No, it's a really good point. And I think, beyond that, it also varies a lot if you look at FP&A versus more investment banking versus different kinds of areas within the finance sector. There are definitely different standards, many are trained to a different level depending on kind of how you got into financial modeling, plus all that difference sometimes when you just move industries or countries or companies.

Guest: Roderick Mckinley: Yeah for sure.

Host: Paul Barnhurst: So why don't you go ahead and tell our audience a little bit about yourself and your background? Help them become familiar with you.

 

Guest: Roderick Mckinley: Sure. Thank you. I originally started out, I taking economics at school to the master's level, and I started my professional life motivated by wanting to work on the climate problem. I started out at Bloomberg covering renewable energy and climate tech and quite a data-centric role. I was working with Excel a lot, for sure. I then pivoted over into, M&A and then a project finance role in renewable energy. And that's when I got really deep into the weeds with serious sort of financial modeling and project finance models are, among the most elaborate and, and technical that I've seen in the space. So it was baptism of fire of sorts. Anyway, eventually I got burnt out. Things were not working for me where I was, and, I quit, started traveling, and accidentally ended up working, as a freelance financial modeler while traveling around the world long before Covid had made that sort of thing fashionable. And during the pandemic, I was lucky enough to get stuck on a tropical island, with some crypto and blockchain entrepreneurs. And they saw that I had awesome spreadsheet skills and an ability to think my way around a problem logically. And, they found that very valuable. And that's that's how I came into that industry and fell in love with blockchain and crypto, which is where I work today.

 

Host: Paul Barnhurst: Great. And the one question I have to ask. Can you really get stuck on a tropical island?

 

Guest: Roderick Mckinley: Yeah, people were choosing to leave.I had the benefit of having become familiar with Thailand after having been in and out over many years, and even before it became clear how bad things were going to get, I felt confident saying, no, I'm going to stay here. This is where I want to be. And I'm totally cool with that. And it turned out to be one of the best decisions of my life, if not the best one possible.

 

Host: Paul Barnhurst: You know, that's great. I know you really love what you're doing. You've had some great opportunities. So I'm going to start with the question here is, I was doing a little bit of research before we chatted on your LinkedIn profile. You mentioned you love problem-solving, geeky coding, and number crunching. I think those are the three things you listed. I'm curious, have you always had a passion for those three things? Has that been since you were a child, or how did that kind of come about?

Guest: Roderick Mckinley: So yes and no. Not in the sort of like super obvious savant way I was. No, sort of like Alan Turing or anything. I used to enjoy puzzles. I used to enjoy taking gadgets apart. I used to enjoy playing with my chemistry set and blowing things up. But along the way, I ended up getting in my own way, sadly as I moved into high school, I felt too socially insecure to embrace my love for mathematics and science. And I also didn't really have much of a growth mindset. I believe that some of this more advanced stuff was beyond me. I remember when I went, I saw my peer coding up in VBA for the first time. My first reaction to that was like, oh my God, that's so hard. I'm never going to be able to do that. But thank goodness, eventually that shifted. The best motivator for me to learn coding was figuring out ways to get out of the office before 3 a.m., and in this process spending so much time with the computer, I eventually reconnected with this joy of this puzzle-solving. Okay, I really want this. I really want to get out of the office. But how do I do that? And it began to offer me its own sort of like, pleasure and enjoyment, which brought me back to those sort of childhood experiences of immersion in that kind of problem-solving.

 

Host: Paul Barnhurst: Got it. I can appreciate that. I like that example. And you mentioned the chemistry set and blowing things up. Any big blow-ups, anything kind of fun in there.

 

Guest: Roderick Mckinley: I cleaned up and hid the broken glasses before my parents came back, so nobody was any the wiser. It was fine.

 

Host: Paul Barnhurst: Smart decision. So when you and I chatted and you mentioned a little bit about it now, you shared how you got into the crypto space. You know, being stuck, as we mentioned earlier in Thailand, is a digital nomad during COVID. So can you talk a little bit more about that experience and how you became so interested in crypto? You mentioned they noticed you were doing financial modeling. And let me just tell a little bit more of the story in that experience.

 

Guest: Roderick Mckinley: So there was, we were all just there and we were all stuck together and it was such an interesting grab bag of people. There was nowhere for us to go. These guys wanted to start a co-living space or a crypto-themed co-living space on the island. So actually, the first point of contact was like, we want to raise some equity. We want to pitch to investors. Can you help us do the financials for that? And, and when they saw what I could do with that months later, they said, okay, we've decided we want to launch our own token. Can you do the Tokenomics for that? And I'm like, the token what? And they're like, don't worry and they gave me this model and I tried to reverse engineer it. I then went project finance on the whole thing and tried to take it to the n-th level before realizing that it was impossible to sort of solve some of some of the things. And, and I eventually worked out what the minimal kind of model necessary to get what they needed across the line was. And very fortunately for all of us, their listing went well. And then basically people kept on knocking at my door asking for more of this work and eventually so this is mainly, this started out as sort of like structuring a token sale.

 

Guest: Roderick Mckinley: So a deciding the terms that are sold to investors, how many tokens there are, which get released when, but eventually people started coming to me and asking me for like economic designs for these, projects for these ideas. And I'm like, each time I don't I just started this like a month ago or three, six months ago. They're like, we don't care, just do your best. And all this, it was a very hot market. So there was money to be made. And as I went into that problem, I started reconnecting with the studies that I'd done at university. And because I was a keen student, I was genuinely curious about why is our world the way it is? Why are we messing up with our resources? Why is there so much inequality? And it's kind of they call economics the dismal science. And some of the stuff they teach you is that, well, the world's this way because it can't be any other way. And you pass exams sort of like explaining why it's impossible to fix things but suddenly blockchain technology actually gives you a completely different kind of tool chest that opens that up again.

 

Guest: Roderick Mckinley: And there are a lot of very deep-seated problems that we can now look at again and say, well, hold on a second. Maybe if we can actually build a system of rules here that nobody can break, no matter who you are, that allows us to do different things to what we were able to do before. Maybe if we have a technology that allows us to monitor things at low cost automatically without loads of humans being involved, we can solve all different kinds of problems that we can solve and so on. And so my curiosity just drew me into this stuff and I became fascinated with it irrespective of the excitement. But it was a wild ride that eventually I ended up interviewing the ex-prime minister of the United Kingdom about blockchain technology at a conference in Singapore through one of my clients. I mean, it was such an incredible journey from knowing absolutely nothing of this stuff to being in that position. It was an absolutely wild ride. And the last two years have been very quiet, though after everything blew up. But hopefully, sweeter times are around the corner again.

 

Host: Paul Barnhurst: Yeah, that sounds like a pretty wild ride. And I'm curious. So how did you end up getting to interview the ex-prime minister of the UK? How did that kind of come about?

 

Guest: Roderick Mckinley: My client had a successful launch, and they put together a conference to discuss ideas around this technology and leverage that as a marketing opportunity for their project. All of this was set up the while everything was still flying high. And then some of the huge implosions happened. But Boris Johnson was already booked. So it was a very interesting experience. And I was lucky they, my client thought I had good communication skills and they wanted me to interview him. And it was a funny experience because I go and do my research, draw up all these questions, then his team come back and basically acts everything that I prepared and they give me a set of questions that I'm meant to ask him. And then I ask him the questions his team had prepared and he didn't have answers to some of them. I'm like, but it was it's he's a charming guy. He's controversial. I'm not going to play down the fact that there are a lot of problems. There have been a lot of issues with his conduct, but he's very personable. And he struck me as very intelligent, and I was certainly very happy for the opportunity.

 

Host: Paul Barnhurst: That's fine. Yeah. No, I think we all know anyone who's researched from Boris Johnson has his controversy, as does a lot of politicians, and we'll leave it at that. So can you give our guests our audience that's listening? Just kind of an overview on token maybe a definition of token economics. Help us make sure everybody kind of understands that.

 

Guest: Roderick Mckinley: Yeah. Nobody knows.

 

Host: Paul Barnhurst: That's why I'm asking you.

 

Guest: Roderick Mckinley: I'm only half joking so there are no authorities on this. I kind of, like, pick up a hefty book by Oxford University Press and point you to an official definition. I think they're kind of two camps, right? For some people, there's a sort of narrow definition that leans more into the word token. in Tokenomics right? And this is a view of that what matters is how much of the token there is, how quickly it inflates, who has it, and all of this sort of stuff. And these are relevant details, but they reflect very heavily on the earliest cryptocurrency designs, which were very much monetary instruments right? So these sort of factors are the most important ones. However, as blockchain technology has progressed, it basically has become more programmable. And as it becomes more programmable, there are more things you can build with it and more kinds of rules and systems that you can put together. And so Tokenomics becomes a more expansive term. That has more to do with economics, which is, one way to describe economics is the study of human behavior in systems, how they react to different rules, what other people do, how much resources they have. And so you use that sort of broader economic lens to figure out to ask a lot more varied questions about the system you may be designing or analyzing as a potential investment. So those are the two kind of definitions, the narrow token-centric one and the broader sort of economic definition for Tokenomics.

 

Host: Paul Barnhurst: Thank you. Appreciate you taking a minute and doing that. So now we're going to jump into some of our more, what I'll call nerdy hardcore modeling questions. So we're going to get started with the first one here. Talk to us a little bit about maybe the similarities and some of those differences between traditional models and other industries and building one for tokens. Just kind of talk a little bit about that.

 

Guest: Roderick Mckinley: So my answer there is to kind of turn the question on its head somewhat. If I am building a model for tokenized system in a spreadsheet, I've chosen to do that because it is similar enough to the business or process that we would be handling with the spreadsheet model in the first place. So one of the part of my journey in this effort to like, understand what it is I'm doing, what my skills are, is to figure out, what the limits of a spreadsheet model are. And we're a dab hand with this tool. We know that a lot of people who crap on it don't really understand just how much you can do with it when you're properly trained and skilled. So in those contexts where I think a spreadsheet is a good tool to model what you want to model I would say that they share basic similarities and concerns of tracking flows of resources and understanding the relationship between those flows and what drives them. In this sense, a financial model is part of a family of a more general class of models that engineers will call stock and flow models right?

Guest: Roderick Mckinley: So your balance sheet is collection of stock items and your P&L and your cash flows are flow items in this way of thinking about it. So when I'm building one of these models in Excel, that's very much my concern. I want to figure out what's moving these tokens from A to B and how am I tracking where they're landing in different locations. In terms of the difficulty like the token sale models are incredibly simple. But what matters there is really a lot more understanding about the context of what's going on in the deal and how different parties see the trade-offs between different choices you're making. But the model itself is kind of very simple to anyone, I'm sure, who's listening. And I was on a podcast yesterday with a CFO audience, and I got a great question. It's like in most of the models I see, tokens aren't included in the Opex line. What is your view on that? And I had to pause and think about this because it's it was sort of like a tricky question to answer.

I understand why it's excluded, but it is a cost. But we don't really have, there are no sort of established or settled ways for deciding how a token is. A token that you spend from your own treasury is a cost because you minted it at no cost out of thin air. And, then it's not always clear that you should be looking at the current market prices as the cost of spend. You might want to be looking at more downward effects of what happens to the token price by you adding that token into circulating supply. So you do some dilution analysis. So all of this sort of stuff can you can think your way around in the spreadsheet you need to think quite actively and carefully when you decide how you interpret those token flows and token balances. And that's where I would say is the key difference thinking about context a lot more.

Host: Paul Barnhurst: Really interesting, when you mentioned the opex part, never even thought about that. But. Yeah, right. The only cost was the computer that created it or whatever. Yeah. You could argue maybe there's a little bit of energy that was used, but it's probably on a server that's going to be used anyway. So it's hard to argue there's any real cost to creating it. And that value especially with volatility can be so different. How do you capture that. How do you think about it. How do you estimate it? I would imagine especially with the volatility we've seen over the years with tokens. Some of the implosion and the ramp ups, it would be really hard to around assumptions. You probably have a wide range sometimes for sensitivity. Is that a fair guess?

Guest: Roderick Mckinley: Yeah. I mean when I work on a project I was trying to design a process that generates or collects revenue in what we would call stablecoin, which is just a representation of the US dollar in a blockchain token. And sometimes I get pushback from this because they're like, oh, no, you're not really making use of the native token. I'm like, dude, I've seen projects blow up because they capitalize, they end up collecting revenues and something that's here today, gone tomorrow. And if you're serious about this project, it's going to take you years to build out. And so that's the way how I try to build in some control of the system to your point about volatility, I'm actually doing a research exercise right now. I've been teaching myself SQL and learning how a lot of these sort of markets are function on the blockchain in terms of their programming code. And then I go to the blockchain and get a readout of everything that all the things that the program did and decode that into an understanding of how many buyers, sellers there are, what the variation in prices are.


And what I'm working to eventually is coming up with a representative sort of history of volatility that I could then plug into an Excel model. You know, once I have those sort of high levels pretty much the same way as you would do in an FPA model. Right? You've got some historics you forecast out some sort of predictive analytics from that historical data. But this historical step now takes place with these amazing on-chain platforms. It's amazing. It's absolutely amazing. I've only worked on one huge large FP&A project, but there was so much difficulty in, like, integrating the point of sale data and figuring just getting the stuff to go in with blockchain, everything happens through data. There is no difference between the action and the data are the same thing. So all activity is self-documenting. And that potentially gives you the opportunity to set up real-time accounting or monitoring of what's going on. And that's at an incredibly low cost. It's just for me it's mind-blowing. so that's what I'm working on at the moment in order to sort of like create some empirically informed bounds for ranges and volatilities of key drivers in my modeling.

Host: Paul Barnhurst: Yeah. Well, you'll have to let us know kind of what you find there. I'd love to learn a little bit about that. It's fascinating that you're kind of doing all that work because yeah very true. Right. It's all digital. It's all recorded. The data is there. It's accessing it and analyzing it. That sometimes proves a little challenging, but it's all there.

Guest: Roderick Mckinley: That's right.

Host: Paul Barnhurst: That's pretty amazing. So you know one other kind of question I have here is you mentioned a little bit about treasury, you know dealing with the balance sheets. Talk about how companies these crypto companies manage their treasury. Do they hold so much in US dollars? You know, how do they think about those reserves and just kind of treasury departments? Because I'm sure with the volatility and other things, it's going to be managed a little different than your traditional treasury department. And I can tell that's true by your laughing.

Guest: Roderick Mckinley: Well, the question should be how do projects not manage their treasuries. let's be charitable here. We have democratized the ability to issue securities or issue financial instruments and create really complex sort of treasuries without a commensurate sort of level of education or capacity on the hands on the project side. And that's why I have worked interesting work to do. Because I want to help, hopefully, help build that understanding and best practice over what to do. this group that I was in touch with that I spoke for yesterday, Web Three CFO Club. They've had they've had some talks on where they talk about trying to keep a certain amount of their reserves and stablecoins. So first, first and foremost is the fact that a very large portion of your assets are at risk or will be by default denominated in this extremely volatile asset that's not only extremely volatile in terms of price, but extremely illiquid. there are exchanges that you can sell into, but they are configured in such a manner to be automatic so that if you sell into the market, you cut a huge price a huge percentage of the token that you're selling. So, you look at your balance sheet and you think you're as rich as Jeff Bezos.

Guest: Roderick Mckinley: And as soon as you try and spend it, it kind of disappears. It's this sort of this ironic thing, right? So really understanding that relationship between and furthermore, actually, you this isn't just an asset that's of relevance to the treasury. It's playing a role in an ecosystem, and it's affecting either your investors or it's affecting your users. So what you do with your treasury becomes you have to take more things into account. And then finally, you're not just having to manage the liquidity needs of your own enterprise. You probably have to look out, manage some of the liquidity on the decentralized exchanges, these automatic exchanges that I was just talking about. Because if liquidity gets too thin out there, then as I was selling, saying anybody who tries to sell and transact in that decentralized exchange pool will see really you'll see very volatile price movements because of that. So I think there's a real need to sort of keep an eye on that external liquidity, create incentives, continue making that attractive to people, helping that stay healthy, so all for all these reasons, it's a very different beast and a very interesting challenge.

Host: Paul Barnhurst: Yeah. And one of the things you mentioned is something around kind of incentives. Can you talk a little bit more of that, like how do you structure the incentives or how do you think about that to encourage the type of behavior that creates a healthy exchange and healthy environment for the tokens?

 

Guest: Roderick Mckinley: This is really potentially really hard. It's ideally, not ideally, but in some systems, you really get into some really interesting sort of design opportunities where you have two people who have nothing to do with each other, and you figure out a way to get them to collaborate. So again, the decentralized exchanges is a really great example because you have two groups of people. You have the people who want to exchange one token for another. But the only way that can be automated is if there's a pool, a reserve that's always available for people to, to um make those exchanges. And that pool only gets filled up by a different group of people who are the liquidity providers. We can think of them as being like savers at a bank. And so the the problem, a core part of the problem that the decentralized exchange designs had to solve was how do you make it worthwhile for those unrelated liquidity providers who aren't interested in trading to provide that? And it all gets funded by fee that's paid by the people who trade. Very simple. But but a helpful, clear example of how you can use this technology to create arrangements and interactions that allow two parties to come together to create a service without a middleman.

 

Guest: Roderick Mckinley: In terms of and then the token is also very frequently used almost all the time, used as a fundraising instrument. So you bring the investors on board. But there is in this case, we have a situation where there are conflicts of interest. Right. And it's very hard to align incentives because what investors want to do is cash out and them doing so messes the token price up for everybody else and maybe messes it up for the project as well. Who may be counting on that to to make some kind of contribution to their ongoing funding?  So in certain situations, the incentives are way out of line and a lot of work needs to be done on creating new contractual arrangements with investors to not give them a free ride, in my opinion. And we're getting to that. We're starting to see for fundraising. They're starting to mix equity and tokens. So you get an equity offer, a sale of future equity plus a token warrant. So you have some optionality in, in the award of tokens that that brings on. So we're seeing the space evolve to accommodate some of these challenges.  but yeah, it's very interesting and, uh yeah. Feature of the space.

 

Host: Paul Barnhurst: Fascinating. And I could tell by the way you mentioned conflicts and describe that. I'm like, we're talking to an economist. I can tell you have that econ background and kind of the incentives and behavior of people and trying to figure that all out. So I appreciate that next question I want to ask is you've created an online course for Tokenomics Modeling and fundraising. Talk a little bit about that. Tell us about that.

 

Guest: Roderick Mckinley: So that course collects all of the experiences I had. It was a wild time. But I did manage to help projects gain access to 150 million USD in new capital. And I saw a bunch of things go right and go wrong and sat through loads of phone calls, sat through lots of revisions. And that course is basically a distillation of everything and an opportunity for me to sort of like, really refine my thinking. And as is my as maybe coming through in the things that I'm sharing. I'm not uh someone who's just evangelizing the thing without any caveats. I'm, I'm I think I'm pretty realistic. You know, I have a whole section in a chapter in the course where I'm like, these are the differences between tokens and equity. And you should look at this first. You should look at this before you think whether this is the right fundraising instrument for you or not. And there is no free lunch, you're getting trade-offs in. Some of these trade-offs are pretty difficult to assess. So it's a course where I go into all of that background context and nuance, but then also just show you how to create a very simple model by, by financial modeling standards but one that essentially allows you to, to manage the, the track the, the terms of all the offers you're making to various parties and understand the key metrics that help you keep that offer balanced. And I also teach you sort of like approaches to working through the variables, working through the problem in a systematic manner. Because if you just see the thing and they say, here you go, you may not know the most efficient or, or the best route to take from A to B, you're just flipping switches all the way around. So all of that's in the course?

 

Host: Paul Barnhurst: Sounds like a great course. We'll make sure to put that in the show notes. Make sure to get that link from you. So anyone who's interested in it can check that out. So I know you're a big believer that a modeler should have more than just Excel in their tool kit. We've talked a little bit about that, so maybe talk about some of the other tools you use and how you make a decision of when, hey, Excel is the right tool or I should be using some Python, or another tool here, some kind of other modeling tool, maybe talk a little bit of how you think about that.

 

Guest: Roderick Mckinley: Yeah. So I don't I don't think everybody has to be multi-tool. I don't know. I guess the more I went into sort of like learning communities around Excel, I did see that people were starting to pick up more than one tool. I think you become a freelancer you help yourself.  by becoming more flexible, and actually let me just say that there has never ever,  I'm going to say it one more time, ever be a 5 or 6.


Guest: Roderick Mckinley: I've lost count I can't I'm so bowled over by how amazing ChatGPT is. I can't contain myself. I have, I've been taking on a really substantial undertaking in SQL, and I don't know how much time this thing has saved me because. For the first time we can we can basically detach the core foundations of our value add as analysts, which is understanding business processes and critical thinking. And I can just if I'm like, oh damn, I don't know how to loop through an array in SQL. I go, hey, ChatGPT, I want to multiply two arrays together in three. No SQL, this flavor of SQL, how do I do it? It spits out the answer and I put the answer in as long as I have. And I understand enough about coding and programming to evaluate what comes in. I'm doing my quality controls, my checks, my sanity checks as I go through, it is, but it is unreal. It is absolutely unreal. And you, for the first time you, I can you know, I remember tying my head ahead. Myself and Knots trying to get my head around Dax and M and Power Query. God, this is just going to be so easy now. I mean, comparatively, it is unreal. It is truly unreal. So there's never been a better time.  anyway, to think about. But if you've got a really deep well of work, if you're a project finance specialist, you may you may only need to do that. But it's never been a better time to diversify in terms of the different tools that are out there for what I do.

 

Guest: Roderick Mckinley: There's some really cool stuff.  there's a, there's a tool called machinations, which was developed for game designers. And imagine a financial model where you would actually sort of like build it with like little picture Lego blocks and you kind of have the revenue process there, the cost process there, and you hit and you wire them together and you hit go and you see how the money is sort of like moving around in your, in your little model. And it's it's very engaging and fun to work with. But you know, coming from the experience I had in M&A and finance, like, it doesn't I wouldn't trust that tool to build anything too complicated because documenting that and quality controlling that is, is really difficult.  there are some Python libraries as well. I haven't started working with those just yet. The example I give to people in terms of deciding what's the right sort of tool, if you think about a financial model, our exploration of the system, the explorations we have to make are in some ways really simple and forgiving. If we just consider where trying to figure out the break-even for profits, all we have to do is look at where the points where costs and revenues are the same. Now, there's there are no surprises that show up as you lower the revenues or as the costs come up. All we need to look for is that breakpoint.

 

Guest: Roderick Mckinley: However, in some of these systems that I was describing. So again, the decentralized exchange, really good one. The interaction is so complicated that as you move through the values of a particular parameter, you may hit a break in a really strange, unreal place, a unusual place that's just happens to be the sum result of all the factors that are leading the system to work in a particular way. And in tha setting, Excel is just not granular enough to, reveal those kind of strange and unexpected breaks to you.  but again if I'm not really in the business of, fine-tuning a really tricky detailed design issue like that and just want to know how many buyers and sellers are there on average? I can use my historical data to do that. Then I can go back to a spreadsheet again. I mean, to be honest, this is something I'm working out. Everybody comes to this work with their favorite tools. The engineers love their Matlab and their Python. The data analysts love their SQL and their dashboards. I'm sort of trying to navigate this a little bit myself and be cross-disciplinary and figure out what what what fits for me, the analytic stuff is clearly going to be key. We'll see how far I go down the Python rabbit hole, but uh, yeah, analytics and Python for now. Uh, and Excel for now.

 

Host: Paul Barnhurst: Trying to be multilingual there. And yeah, I love the example, the Python, the Excel. I really like what you said about ChatGPT is I like to say the tool is incredibly valuable. And the more you know about a subject to be able to kind of validate and test it, you don't have to have super deep knowledge, but it's deadly. And what I call the hands of the competent, right? If you have somebody that doesn't know anything and is just using ChatGPT, it's where there's going to be a lot of mistakes made. But if you know enough to kind of validate things, it can save you incredible time. I'll use it to help write formulas sometime. Like, all right. This is a really messy, indirect I had to write the other day and it was a bunch of different levels to it. And I hate that formula because you have quotes everywhere, single and double and ampersands. And I just threw it in and said, here's what I'm trying to do. Here's the cell, write me the formula. And then I did the next step. And after about 20 minutes, I had my six levels that I needed and I threw it in, I moved forward. It would have taken me an hour, probably to get the syntax right, because I just don't do it enough. So I'm totally with you. It's it is really neat to watch. So going back to Excel, this is one question we like to ask all our guests. What's your favorite or could call it most valuable Excel shortcut?

 

Guest: Roderick Mckinley: It's one that I made for myself. It launches a little VBA uh, task I get. I love working with multiple windows, but I get super annoyed when it resets the formatting every single time I do that. You know, in the financial, I have all the frames locked, all the cells. So I just set up a VBA script to open new windows and keep all the formatting that I have.  and that's I reach for that a lot.

 

Host: Paul Barnhurst: So you got your own custom shortcut you love there, I like yeah. So this next question is one kind of around modeling maybe what's a technical nugget or something you've learned within your modeling, whether it be something around depreciation or using a certain type of formula with a revolver or whatever it might be that you can give our audience that you wish more people would incorporate when building models.

 

Guest: Roderick Mckinley:  that's really hard.  technical nugget. Hmm. I don't know. I just love to see basic structure, clear basic structure.  it is just it is the be-all and end-all. Because if you have like clear basic structure, you can work the rest out.  I just think that's so foundational. That's that's the beginning of everything else. That's what I'll go with.

 

Host: Paul Barnhurst: I love that answer. I would 100% agree with you, as I've heard in Schnoor say, I'm on my podcasts. You know, the most important principle is design. It almost always comes back to design the issues in a model. He's like, you know. It's about flow, data flow, and process flow and design. And I just think that's so true. Almost always, the problem can be solved with thinking more about how you design it.

 

Guest: Roderick Mckinley: Hmm.

 

Host: Paul Barnhurst: So all right, we're going to move into our rapid-fire section before we wrap up here. So I'm going to give you the ground rules for this one. You get no more than 10 seconds to answer. You can't tell me. It depends because you could probably do that for all of these. So you have to pick a side. And then at the end, you can pick 1 or 2 to elaborate a little bit on. So you ready.


Guest: Roderick Mckinley: Ready. Let's do it.

 

Host: Paul Barnhurst: Here we go. Circular or no circular references.

 

Guest: Roderick Mckinley: Not on sheet.

 

Host: Paul Barnhurst: VBA or no VBA.

 

Guest: Roderick Mckinley: VBA.

 

Host: Paul Barnhurst: Horizontal or vertical models.

 

Guest: Roderick Mckinley: Horizontal. Man.

 

Host: Paul Barnhurst: Excel. Dynamic arrays. Yes or no?

 

Guest: Roderick Mckinley: No.

 

Host: Paul Barnhurst: Interesting external workbook links. Yes or no.

 

Guest: Roderick Mckinley: Go to hell.

 

Host: Paul Barnhurst: Thank you. All right. Named ranges versus no. Named ranges.

 

Guest: Roderick Mckinley: Yes, but sparingly.

 

Host: Paul Barnhurst: Okay. Do you follow a formal standards board, one of the formal standards out there when you're modeling? Yes or no?

 

Guest: Roderick Mckinley: I get inspired by them and then work consistently to what I choose to do.

 

Host: Paul Barnhurst: Makes sense. Will excel. Ever die.

 

Guest: Roderick Mckinley: It hasn't yet. I don't see it.

 

Host: Paul Barnhurst: Alrighty. Well, I build the models for us in the future.

 

Guest: Roderick Mckinley: I'm skeptical. There's so much context and nuance. I'm skeptical.

 

Host: Paul Barnhurst: Okay. Uh, use of sheet cell protection in your models? Yes or no?

 

Guest: Roderick Mckinley: Yes. When the employees may tamper with, uh their pay grade and performance.

 

Host: Paul Barnhurst: Makes sense. Do you believe financial models are the number one corporate decision-making tool? Yes or no?

 

Guest: Roderick Mckinley: Not anymore. What is analytics? Analytics and all this kind of technology is incredibly important in upgrading the whole FinOps operations, for companies.  and a lot of that happens without ever touching Excel. Okay.

 

Host: Paul Barnhurst: Definitely. We're seeing more and more of that. And then what is your lookup function of choice? Choose Vlookup index match or Xlookup.

 

Guest: Roderick Mckinley: Index match.

 

Host: Paul Barnhurst: Alrighty, that's a pretty common one. All right. So which answer did you want to elaborate on there?

 

Guest: Roderick Mckinley: Um let's see, I think the dynamic arrays are an interesting one to talk about. Like  I think so first of all, they seem like more of a convenience than a necessity. I do use them. They're like, I'm it's like cool. But there are certain things that I find really annoying. Like I mentioned that formatting and presentations, a large part of what I do, they don't track formatting. Then when I have this entire sort of skill set around integrating things with charts, I find that the integration doesn't go all the way into all these classic features. And then because I'm building, I'm often been building sort of spreadsheets in educational contexts and stuff, then there are compatibility issues or if I want to build and build a Google Sheets copy, I don't fully understand or trust how that migrates over into Google Sheets environment. So all of these little frictions I'll. Yeah, mean that I, that I haven't really been working with them so much even though I was excited to see them.  but I don't use them for all those reasons.

 

Host: Paul Barnhurst: Yeah. And we're definitely seeing some people that definitely have the friction. I tend to use them here and there, but I don't use them to build a whole model. I don't think they're quite there yet for that. But I definitely use them in a lot of areas. I love them in some of my analysis and different things, but I can agree with you that there are definitely some drawbacks. Still, it'll be interesting to watch and see how that develops over time.

 

Guest: Roderick Mckinley: The other thing I'll mention is about sorry, do we still have time for.  

Host: Paul Barnhurst: Go ahead. You can do one more. 

 

Guest: Roderick Mckinley: Yeah. The circular references thing. So I work in project finance, and there are these or. I used to. And there are these circular calculations that you just can't get away from. They are a feature, not a bug. And, um one of the things I eventually came to learn and understand was this method that Ed Boehmer Bodmer popularized where you use VBA to handle the circularity, and then suddenly instead of having these, um clunky machines which would copy and paste values until you would converge, you would be able to get a model that was sort of lightning fast and really reactive and like, literally this thing would have saved hours of my life in my last job, but it required a very different skill set to execute. So there's a really difficult trade-off with the maintainability of the model, the likelihood of finding someone skilled enough to keep that model going if you leave. It's very complicated. But it's an interesting point. Again, going into this issue of how broadly skilled should we be as, as modelers and analysts?  but yeah, that's a really interesting question there.

 

Host: Paul Barnhurst: And interesting you mentioned Edward Bodmere because I've learned a fair amount about him from Heidi Kianyfard. She's worked with them.

 

Guest: Roderick Mckinley: Yeah, she's a great fan.

 

Host: Paul Barnhurst: Him and she was going to introduce me to him. I'm hoping to have him on the show at some point in the future. So we were just talking about him earlier this week. So funny. You mentioned him. Yeah, she's a big fan of his. So I'm looking forward to learning a little bit more about his approach there. So yeah, it's a fascinating subject. And there are times when you have to do it heavy debt models. You got enough interest in there. You can't just avoid circular references and have an accurate number. So it's it's a challenge that everybody fights with. I think we'd all like to say no in the sense that it's kind of a pain and it creates risk. But there are times you have to take that risk one way or another. Even if you do VBA, however, you solve it, they're still going to be that calculation.

 

Guest: Roderick Mckinley: So. That's right.

 

Host: Paul Barnhurst: All right. We're coming up into our concluding section here. So just have two questions left. The first is if you could offer our audience one piece of advice that would help them become a better financial modeler. What is that one piece of advice you're going to offer?

 

Guest: Roderick Mckinley: Try and look for the shortest and most efficient way to express your calculations. Try and maximize the speed of your model.

 

Host: Paul Barnhurst: That's a really good one. Yeah, I like that. I've learned that lesson the hard way. You put in some offsets and indirects and all of a sudden you're like, I can go to lunch and hopefully it will run when I come back. So optimization is a that's a great one. So last question here. If our audience wants to learn more about you or get in touch with you, what would be the best way for them to do that?

 

Guest: Roderick Mckinley:  I'm active on LinkedIn.  I've got my Tokenomics channel token design.  and if I get around to it, I'll be releasing some old some project finance stuff that I that was working on before Covid.  and I'm very gradually sort of dusting off, so hopefully that'll be out in a few months. It's, my other YouTube channel, there is just project finance modeling on YouTube.  so, yeah, any of those ways LinkedIn is, is where I'm most active and on the crypto channel as well. So thank you.

 

Host: Paul Barnhurst: Well, perfect. Well, thank you for joining us, Roderick. I really enjoyed the chat. I know I learned a lot and I'm sure our audience will as well. So thanks for carving out some time for us.

 

Guest: Roderick Mckinley: Thank you so much for having me. Pleasure.

 

Host: Paul Barnhurst: Alrighty. 

Financial Modeler's Corner was brought to you by the Financial Modeling Institute. Visit FMI at www.fminstitute.com/podcast and use code “PODCAST" to save 15% when you enroll in one of their accreditations today.