课程: Financial Modeling Foundations
今天就开通帐号，24,600 门业界名师课程任您挑！
Assumptions in financial statements - Microsoft Excel教程
课程: Financial Modeling Foundations
Assumptions in financial statements
- [Instructor] Building financial models really starts when we begin making assumptions about what's going to happen to the business over time. In particular, in order to get to future assumptions, we're going to have to start by examining what's happened historically. I'm in the 02_05_Begin Excel file. Now, what we have here are a set of assumptions ranging from assumptions related to TAM, Target Addressable Market, to Income Statement Assumptions and Balance Sheet Assumptions. And these are really key assumptions that we're going to need to take from what's happened historically to what's happened in the future in order to forecast where this business will be going. Now, each of these assumptions is going to be built on our historical data initially. So, for example, looking at Revenue Growth. This revenue growth of 5.1% can come from the balance sheet. So, if we wanted to understand what 2015 Revenue Growth is, it's simply going to be the difference between our 2015 Revenue and our…
随堂练习，边学边练
下载课堂讲义。学练结合，紧跟进度，轻松巩固知识。
下载课程离线学习
下载课程到移动设备，轻松离线学习。在领英学习 iOS 或安卓版 APP 下载课程
内容
-
-
-
-
Foundations of the model4 分钟 27 秒
-
(已锁定)
Linking financial statements3 分钟 8 秒
-
(已锁定)
Three-statement financial model3 分钟 35 秒
-
(已锁定)
Setting source parameters5 分钟 19 秒
-
(已锁定)
Assumptions in financial statements3 分钟 37 秒
-
(已锁定)
Forecasting in financial statements3 分钟 46 秒
-
(已锁定)
Putting it all together4 分钟 56 秒
-
(已锁定)
Improving model quality3 分钟 37 秒
-
-
-
-
-
-
-
-