Model - Cash Flows From Operations and Investing
- 04:17
Understand how to build the operating and investing CFS for Luxottica.
Glossary
Cash Flow Statement ForecastTranscript
We build up our cash flow statements going from top to bottom, but there will be a number of items where we need to look at the cash impact from the balance sheets. So, just to remind ourselves of the rules of thumb, when you're looking at the change in an asset, we're going to take last year's balance sheet figure minus this year's balance sheet figure, and that will give us the cash flow from a change in an asset. However, if we're looking at the change in a liability or equity, we'll just take the opposite. We take this year's balance sheet figure minus last year's balance sheet figure. So, we start with net income. We're not gonna be building the historical figures and scroll all the way up to our income statements.
And we've got two net incomes to choose from. We want the real net income. We don't want recurring that's completely made up. We want the one that's connected with cash flows. So, that's our net income there. We then need to add back depreciation and amortization. They're already both in the income statements. So, I'll scroll up, find them. There's depreciation. It's a positive already. That's great, 'cause I want to add back depreciation. You might notice the amortization is in the cell below. So what I can do is I can press Enter for depreciation. I can select the depreciation, select the cell below as well, and then I can press Ctrl + D to copy that formula down. Great. Next, for change in OWC, operating working capital, we need to do a small calculation. So, let's go up to the calc section. And in the calc section, we've got three line items here. We need to find current operating assets. Then, we'll subtract current operating liabilities to get operating working capital. Operating working capital is cash that's tied up in the business as current operating assets or provided by operating liabilities. So, I need current operating assets last year, 15,048. I then need current operating liabilities from last year, 16,085. So, how much cash did we have tied up in operating working capital? Take the top one minus the bottom one. Fantastic. We had no cash being tied up here. In fact, we had cash being provided by operating working capital. I'm gonna select those three cells and the three cells to the right, and then copy to the right with Ctrl + R. I can see that we had 1,037 of cash being provided to us last year. So, my bank accounts looking really good. This year, I've got even more cash being provided to us. That's fantastic. So, if I have more cash being provided, I should have a positive change. I.e, a cash inflow of roughly 230-ish. So, let's go down to the cash flow statement. So, let's make sure we get that positive 230 if I scroll up. Want to say last year's figure minus this year's figure, a bit like a change in assets, and I get that positive figure close to 230. Now, we move on to change in balance sheet items. I want change in other long-term assets first, last year minus this year, then change in other non-current liabilities, this year minus the previous year.
And that gets me my cash flow from operations and I can use Alt + equals or Command + Shift + T to total them up.
Then, onto cash flow from investing, I need CapEx. We've already got that in our calcs.
However, it's shown as a positive. I need to change it to a negative, 'cause it's a cash outflow.
Change in short-term investments, that's in the balance sheets. I'm going to take last year's figure minus this year's figure, and change in long-term investments. We need to do the same thing. Last year minus this year.
That gets me my cash from investing activities. Sum them up and that figure comes to 15,185.3.
It's shown as negative, because it's all a cash outflow.