课程: Excel Modeling Tips and Tricks

免费学习该课程！

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

Using financial models

Using financial models - Microsoft Excel教程

课程: Excel Modeling Tips and Tricks

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

Using financial models

“

- [Instructor] Excel has some great tools to be able to go through and critically interpret financial models. Let's take a look at an example. I'm in the 04_03_Begin Excel file. So we have here our FactSet 2.0 and Airbnb 2.0 models, and as you'll see in the FactSet 2.0 model, we've gone through and we've added this column for percentage, looking at what the level of cost is versus our user fees. And we want to see, obviously, that our costs are lower relative to our user fees, but the nice thing about doing this in Excel is I can go through and I can use the conditional formatting model, and I can go through and add color scales, either green for higher values or red for higher values, depending on kind of what I'm looking at. Now, in this case, we're looking at expenses, so we'd probably want to have green, indicating good, for lower values, and red for higher values. And this tells me immediately that obviously, that 90th percentile is very high level. It's not necessarily a very…

内容