Modeling Case Study - Cashflow Statement Setup
- 01:29
How to do the cash flow statement for a financial model. As well as how to allocate the balance sheet items to operating, investing, and financing activities, and how to calculate the net cash flow from each activity.
Downloads
No associated resources to download.
Transcript
Next we're going to go to do the cashflow statement. Now, when I do the cashflow statement, I actually don't even look at the cashflow statement because if you're modeling from scratch, the first thing you should do is you should allocate the line items on the balance sheet to operating, investing and financing because you won't have cashflow statement labels if you're modeling from scratch. The assets, there are only two choices operating and investing. Anything to do with operating working capital will be operating, so accounts receivable, inventories, other current assets, net PP&E has a base calculation, so where we have base calculation, there'll be two entries. Investing activities for CapEx, operating activities for depreciation, and then financial assets. They will be an investing activity. I know it's confusing because it says financial and you may want to think financing, but you'll only find financing items on the other side of the balance sheet. Then we hop over to the other side of the balance sheet and here you can see that we have revolver, which is our plug, so I'm going to leave, but the accounts payable is operating part of operating working capital. Long-term debts can be financing, and then equity has a base calculation, net income and dividends. Net income is operating and dividends are financing. So we've got all our checklists there. And then as I work down the cash flow statement, I can tick these items off.