From the course: Financial Modeling Foundations

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Setting source parameters

Setting source parameters - Microsoft Excel Tutorial

From the course: Financial Modeling Foundations

Start my 1-month free trial

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…

Contents