课程: Excel Modeling Tips and Tricks

免费学习该课程！

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

Adding toggles and inputs to a model

Adding toggles and inputs to a model - Microsoft Excel教程

课程: Excel Modeling Tips and Tricks

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

Adding toggles and inputs to a model

“

- [Narrator] One of the neat things about Excel and building financial models in Excel is that you can go through and update that model and change the model very quickly and easily to reflect real world circumstances. Let's take a look at an example. I'm the 0204 Begin Excel file. So this is our model for a quick service restaurant, something like a Chipotle or a Panera. And as you see, we've got the monthly sales and costs associated with that restaurant, and then the net income for each month. Now, we've built in a seasonality factor to adjust for different levels of traffic throughout the year. Maybe we want to make a change though, we're not sure if we can accurately forecast what those levels of traffic are going to be from a seasonality point of view in advance. So I want to be able to change the model to take that out. Well, to do this, I'm going to take the sales value and I'm going to multiply that by a new if statement. So times if open parentheses, then, I'm going to say if…

内容