Corporate Finance Explained | Scenario Planning & Sensitivity Analysis in Corporate Finance

Welcome to Corporate Finance Explained, where we break down the essential topics every corporate finance professional needs to know. This series is narrated by AI, created using CFI's expert training materials, and designed to help you stay ahead in the world of finance. Enjoy this week's deep dive. It feels like every day in corporate finance, you know, there's a new curveball coming at you. Inflation one day, interest rate hikes the next, and then tell me about it. You never quite know what supply chains are going to do, let alone, like, what's happening around the world with, you know, geopolitics and everything. Absolutely. Makes you wonder how anyone plans for the future at all these days. Well, and I think that's exactly the point, right? I mean, the best finance teams, they're not focused on, like, getting a perfect prediction. They're more focused on being ready. For anything. For anything, exactly. And that's where I think these tools, scenario planning and sensitivity analysis, really come into play. Okay, so let's break those down a little bit. Scenario planning, for folks who, you know, may be familiar, maybe not. It's really exploring those what-ifs. So, you know, imagine you're modeling a big drop in sales or, I don't know, maybe interest rates just go through the roof. How does that then flow through your entire financial picture? Exactly, exactly. And so you're looking at, like you said, what are the plausible futures? Yeah. And how do we get ready for them? Right. And then on the sensitivity analysis side, it's really focusing in, like, on one variable and saying, okay, so how much does our EBITDA actually move... Right. ...if the price of this raw material goes up by 10 percent? Okay, so one is a combination, one is a little more focused. Exactly. Got it. Okay. And I think where these get really interesting, right, is using them together, because then you can really stress test those decisions. You can communicate risks, you know, really clearly to leadership. Yeah. And you end up with a much more robust planning. And I think we've seen how important that is, right? Like, even in recent history... Oh, yeah. ...like with COVID, right? I mean... Yeah. ...all those baseline forecasts, they went out the window... Just like that. ...immediately. And so it really highlighted that you've got to be ready for... ...for those big changes. Yeah. And that is the perfect example, right? Nobody... I mean, I remember talking to people and nobody knew what was going to happen. Nobody knew. At all. And that's why scenario planning is so crucial, you know? Look at a company like Airbnb. Travel basically stopped overnight. Oh, yeah. But their finance team, they didn't just sit around. Name. They modeled some pretty, you know, severe drops in demand. And what they did that was really smart... Yeah. ...was they didn't just say, oh, revenue is going down. They looked at, okay, what are the pieces... Okay. ...that are driving that? How long are travel bans going to last? What type of travel is most affected? Interesting. You know, is it business? Is it leisure? And then how quickly could different regions recover? Huh. Okay. So that let them make, like, much more targeted decisions. So it's almost like they're taking those big assumptions and breaking them down into smaller... Into smaller pieces. Okay. Very cool. So then, I mean, they had those models in place so they could move quickly... ...cut costs, you know, paused marketing, and I think, crucially... Yeah. ...secured more funding really quickly. And I think that was the key for them, right? Like, they took those actions based on the scenarios they had run... Right. ...and they not only survived, but they thrived coming out of it. Yeah. The IPO, after all that, that was... It was huge. Huge. Yeah. Yeah. And it shows, right, the value of having those what-if scenarios ready to go. Totally. It really made scenario planning, like, a core part of a strategic finance function, which I think is... Absolutely. ...it's really changed the game. Yeah. So if you're in FP&A today, you know, you can't just do those standard... No. ...best case, base case, worst case. Not anymore. That's not going to cut it. Nope. So what are you seeing? What are some of those expectations for FP&A teams today? Well, they're being asked to be a lot more strategic. So it's not just about, you know, giving the numbers. Right. It's about modeling those downside risks. Okay. Like, what if revenue shrinks because competition eats up? Or what if, you know, your supply chain costs spike unexpectedly? Makes sense. And it can't just be about the bad stuff either, right? Not for sure. Got to think about the good stuff too. Absolutely. What if a new market explodes? Right. What if a product takes off way faster than you thought? I mean, those scenarios, they can really drive growth. Totally. So to do this right, you're saying FP&A needs to work hand in hand with... Oh yeah. Big time. Sales, marketing, operations. You got to understand those business drivers, right? Because you're painting a picture of the future, right? Absolutely. Of these different... And FP&A becomes a storyteller almost. Yeah. You know, using their models... Oh, I like that. ...to help leadership navigate all this uncertainty. Okay. So how do finance teams actually do this? Like what are the tools, you know, the techniques they're using? Well, one of the big ones is driver based models. So instead of just saying, okay, revenue is going to grow by X percent... Yeah. ...you're actually tying it to what's happening in the business. Like how much does it cost to get a new customer? What's the average order value? Right. So it's much more grounded. Okay. And then building on that, rolling forecasts. I imagine that's a big way. Oh yeah. Huge. Instead of just having a static budget, you're constantly updating the outlook. Right. You know, every quarter, maybe even more often. So it's a living, breathing thing, really. It is. And then to really help people understand these scenarios... Yeah. ...dynamic dashboards are amazing. Okay. What are those? So they're interactive tools that let people play with the models. Oh, cool. You know, change the inputs. I see. And see what happens. It makes it much more engaging. So you can really get in there and see how things move around. Exactly. And then for folks who want to get even more sophisticated, I've heard, you know, Monte Carlo simulations. Is that...? Oh yeah. Those are really cool. Yeah. Basically, instead of just looking at a few scenarios... Right. ...you run thousands of simulations. Oh, wow. Where the key assumptions are changing randomly. Okay. It's like rolling a dice a bunch of times. Instead of... Instead of just predicting one outcome. So you see all those possibilities. Yeah. You get a much better sense of the risks. Okay. And then, you know, we talked about sensitivity analysis. So when you're trying to visualize that... Right. Are there any, like, charts or visuals that are particularly useful? Toredo charts are great for that. They show you which inputs have the biggest impact. I see. On your key numbers. Okay. So you can immediately see what really matters. Exactly. That's cool. And then, you know, while Excel is still king, I guess, there are all those... Oh yeah. Tons of them. ...add-ins and platforms. You got Power BI, Tableau. Those are great for visualization. Okay. And then there's, you know, Plaidful and similar tools that can really streamline the whole scenario planning process. Okay. So we've talked theory, we've talked tools, but what about some real-world examples of companies using this stuff? Right. Right. So we talked about Airbnb. Yeah. But let's look at Starbucks. Okay. And how they dealt with inflation. Yeah. That's been top of mind for a lot of folks. Oh yeah. So what their FP&A team did, they didn't just assume all costs would rise the same. Yeah. They worked with their supply chain and operations teams... Okay. ...to model different inflation levels for specific things, like the beans, the milk, the labor, logistics, all of it. Oh wow. So they really got granular with it. They did. And that's what's key, right? Because it let them tailor their response... Yeah. ...in a much more nuanced way. Interesting. So by building those scenarios, they could see the impact on their margins... Right. ...and adjust their prices, their promotions, even the store hours. And that let them stay profitable, I imagine. Oh yeah. Much more so than some of their competitors. Who maybe weren't as prepared. Exactly. Yeah. It shows that being proactive really can make a difference. It really can. Now, switching gears a bit... Yeah. ...let's talk about sensitivity analysis and capital planning. Okay. So if you're looking at a big investment... Right. ...you got to understand how sensitive your IRR and NPV are... Right. ...to changes in your assumptions. Okay. Like what happens to your IRR if your CapEx is 10% higher than you thought... Yeah. ...or if tax rates change, or even just your discount rate? Right. Small changes can make a big difference. So that's why sensitivity analysis is crucial. It is. It's a core part of capital budgeting, debt planning, M&A, cost optimization, the whole nine yards. Okay. So for finance teams who really want to get good at this stuff, both scenario planning and sensitivity analysis... Right. ...any best practices they should keep in mind? Yeah. A few key ones. First, make sure your scenarios are actually relevant. Okay. Don't just build models for the sake of it. They should be tied to the decisions your company's facing. Makes sense. And then you got to quantify the risks. What's the potential hit to EBITDA? How much runway do you have? Right. Put some numbers on it. Exactly. And don't just trust your gut. Pressure test your assumptions. Oh, good point. Talk to other departments, look at external data, make sure it's solid. And when it comes to communicating all this, especially to leadership... Yeah. ...how do you make it land? Keep it clear, concise, focus on the key takeaways... Okay. ...and document your models well. Yeah. If people don't understand them, they're not going to trust them. Right. Right. And finally, don't let perfect be the enemy of good. I like that. A simple model that's used is better than a complex one that sits on a shelf. Absolutely. Now, thinking about some more examples. Yeah. Delta Airlines, they use scenario planning to manage fuel prices. Okay. Which, for airlines, is a huge expense. Oh, yeah. So they model different price scenarios, and then they use that to inform their hedging strategies... Makes sense. ...and how they adjust their routes and pricing. So they're ready for whatever happens with fuel. They are. It's a great example of proactive risk management. And then there's Unilever operating in all those... Emerging markets, yeah. Emerging markets. That's got to be... That was a whole other ballgame. A whole other ballgame. With currency fluctuations and political instability... Yeah. ...they actually use geopolitical scenario models... Wow. ...to understand those risks... Okay. ...and build in buffers for their financials and logistics. So they can keep operating no matter what. Exactly. It shows how scenario planning isn't just about money. Right. It's about resilience across the whole business. So I think the big takeaway here, right, is uncertainty is the new normal. It is. It's not going away. And that's why these tools are so important. Right. They're not just technical things. Right. They're leadership tools. They help companies be more resilient, more agile... Right. ...and ready for anything. And that brings us to a really important question for you, the listener. How are you using scenario planning and sensitivity analysis in your own work? What are the biggest uncertainties your company is facing? And how could you start building models to explore those possibilities? Something to think about. It is. It's really a key part of being a successful finance professional today. Couldn't agree more. Yeah. Well, great conversation today. Yeah, this was fun. Always a pleasure. Likewise. Thanks for joining us on The Deep Dive. Anytime. Thanks for listening to Corporate Finance Explained. If you found this episode valuable, be sure to check out more episodes and explore CFI's highly rated courses at corporatefinanceinstitute.com. Don't forget to subscribe for more deep dives into essential finance topics. See you next time.