课程: Financial Modeling Foundations

今天就学习课程吧！

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

Bottom-up financial models

Bottom-up financial models - Microsoft Excel教程

课程: Financial Modeling Foundations

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

Bottom-up financial models

“

- [Instructor] An alternative to top-down models of financial forecasting are bottom-up analysis. Now, we've gone through when we've added a toggle because we now have a few different methods for forecasting how revenue growth will change over time. So if we type in a 1, that indicates the top-down method, if we type in a 2, that's gonna be for our bottom-up method, and 3 will be for our conventional simple and easy to use CAGR method. And as we see, at present, we're using the top-down method. If we instead switch to the CAGR method, we see that that flows through and our net income at the end of the period does in fact change. Now, we're interested in trying to use a bottom-up method as an alternative. So while the top-down method starts with target sales and then filters through market share and then order value, in order to get overall growth rates, the bottom-up analysis starts by looking at what is our firm's traffic. And then from there what is the conversion rate based on our…

内容