课程: Excel Modeling Tips and Tricks

免费学习该课程！

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

Determining model accuracy

Determining model accuracy - Microsoft Excel教程

课程: Excel Modeling Tips and Tricks

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

Determining model accuracy

“

- [Instructor] It's important not only to be able to build financial models in Excel, but also to be able to evaluate the accuracy and quality of those financial models by reviewing either your own models or other people's models. Let's take a look at an example. I'm in the 04_01_Begin Excel file. Now, we have here a couple of models that we have built out for two different firms, right? I'm going to call it Airbnb 2.0 and Factset 2.0. And these models are somewhat complex. It's a monthly model showing essentially the growth of these firms over time. But what's notable here is we might want to go through and evaluate the relative accuracy of our forecast. For example, we have here for the year 2021, our forecast for how we think Airbnb 2.0 is going to perform. And we see that forecast in the italicized column. Then we have the actuals in the next column over, right? So year end 2021 forecast, year end actuals. We need to go through and assess whether or not this is a good forecast. So…

内容