课程: Financial Modeling Foundations

今天就学习课程吧！

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

Setting source parameters

Setting source parameters - Microsoft Excel教程

课程: Financial Modeling Foundations

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

Setting source parameters

“

- [Instructor] While building out the income statement and the balance sheet portion of the three-statement financial model is usually fairly straightforward, building out the statement of cash flows can be a little bit trickier because it often draws from the income statement and the balance sheet. I'm in the zero two zero four begin Excel file. Now we have our basic three-statement model and this includes the balance sheet and the income statement completely filled out for our purposes. But we have a significant portion of the statement of cash flows that's missing. In our case though, we should be able to go through and fill out the rest of the sheet based on that income statement and balance sheet. Notice the net income portion, which starts the cash from operating activities, this is going to be drawn directly from our income statement above. So our net income flows right out of the bottom of the income statement. We want to make sure that we continue to do this across the entire…

内容