课程: Excel Modeling Tips and Tricks

免费学习该课程！

今天就开通帐号，24,600 门业界名师课程任您挑！

Steps in building the single-sheet model

Steps in building the single-sheet model - Microsoft Excel教程

课程: Excel Modeling Tips and Tricks

开始一个月试用 购买团队方案

Steps in building the single-sheet model

“

- [Instructor] One of the really useful things about Excel is the ability to go through and modify our Excel model in order to see what the outcome is in real-world scenarios. Let's take a look at an example. I'm in the 02_07_begin Excel file. Now we have here our quick service restaurant and the monthly forecast, and we've gone through and created a series of different toggles to allow us to update the model based on things like whether we're going to spend money on marketing or not. What the impact from that spending is. That is how much value do we get from the marketing, whether or not we want to take into account seasonality, things like that. But we can also go through and we can build in the computations for different key performance indicators or KPIs, like for example, contribution margin. Now, contribution margin is essentially just our wholesale margin. In the case of a restaurant then, it's the cost that the customer pays minus the cost of those ingredients. So for our…

内容