From the course: Cash Flow Cycles and Analysis

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Overview of cash flow cycle case study

Overview of cash flow cycle case study

From the course: Cash Flow Cycles and Analysis

Start my 1-month free trial Buy for my team

Overview of cash flow cycle case study

“

- [Instructor] Cashflow cycles and analysis in Excel. Please open up the file called Cashflow Cycles and Analysis Demonstration-Blank. In this file, you'll see what we're going to build together, which is a cashflow statement for a company based on its income statement and balance sheet. That will require us to review the concepts we've covered in this course, including the operating working capital cycle in cash flow, and the longer term investing cycle in cash flow. At the end, we'll have a completed cash flow statement for this business, which will help us assess potential lending and borrowing opportunities for a company. Along the way, we'll start by calculating cash flow from operating activities. It's equal to net income plus all non-cash expenses, for example, depreciation or stock-based compensation, and then it's adjusted by subtracting the net increase in working capital accounts. The changes in working capital are based on changes in accounts receivable, inventory…

Contents