From the course: Excel Modeling Tips and Tricks

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Steps in building the single-sheet model

Steps in building the single-sheet model - Microsoft Excel Tutorial

From the course: Excel Modeling Tips and Tricks

Start my 1-month free trial Buy for my team

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…

Contents