课程: Excel Modeling Tips and Tricks

免费学习该课程！

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

Notating and comments in models

Notating and comments in models - Microsoft Excel教程

课程: Excel Modeling Tips and Tricks

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

Notating and comments in models

“

- [Narrator] Models in Excel can be quite complex. So it's critical that you go through and do what you can to make that model understandable, readable, and usable, not only for other users in the future, but also for yourself. You don't want to put together a model and then six months later, go to open it and not really understand or remember exactly what you are doing in it. Let's take a look at how we can do this in Excel. I'm in the 0304 Begin file. So we have our multi-statement financial model, based on RedTech 30, and we're going to go through and add in a couple of comments to help us remember things. So I want to go ahead and I'm going to add my general administrative expenses, right? And you might be saying, well, how are we going to get this? Perhaps I'm not sure exactly what I should do, but we've got an assumption here. Our assumption is that G and A is 11.6% times our revenue. So that gives us our general and administrative expenses. And then we've got our EBIT, based on…

内容