In our cash flow statements, we've still got our investing activities to do, then our financing activities to do, then our eventual cash balance at the bottom, and hopefully, we'll then be able to balance the balance sheets by putting that cash balance into the balance sheet. So, let's start with capital expenditure. I'm going to be working in column F, that's our first projected year and capital expenditure we can already find done for us up in the PP&E base analysis. So, if I scroll up find that there it is 37.5. However, in the cash flow statement that's gonna have to be shown as a negative because it's a cash outflow. So, I'm going to multiply that by minus one. Great. Next, the change in long-term investments that's in our balance sheet. If I go up to the asset section there it is and I need to take last year's long-term investments minus this year's and that will give me the cash flow impact. In this particular case, it's zero. So now I can sum the two items above, and that will get me my cash from investing activities, and it's negative 37.5. Let's keep going down for my change in long-term debt. Again, that will be in the balance sheet, but this time it's going to be the other way around. I'm going to take this year's debt minus the year before. Now, my debt has come down from 25 to 20. What cash flow must have done that? It must have been a 5-out flow of cash. I must have paid off some of my debt. There's that negative outflow. Next are my dividends. These are dividends paid. They also need to be a negative. I can find them in my equity section, and they're already shown as a negative 18.5.

So, my cash from financing is in the sum of those two items giving me negative 23.5, and then I can get on to the bits at the bottom. So, I'm going to start with last year's cash balance, and that's all the way up in the balance sheet, top of the balance sheet, 94.6. I'll then have to add on to that my net cash flow. Now, the net cash flow is the sum of the three sections in the cash flow statement. It's your cash flow from operations, your cash flow from investing activities, and the cash from financing. To get to the cash balance at the end of this year, I'll take last year's cash, add on any cash flow that we made during this year, and that gets us to 117. Fantastic. We've just got two more things to do now and basically, we need to finish up the balance sheet. Let's go have a look at those two things in the balance sheet. The first one is at the top and it is cash. What I'm going to do here is I'm going to say if cash at the bottom of the cash flow statement, if that is positive, I want it to go here. If it's a negative, I just want this to be a zero. And basically, if it's a negative, I want it to go into short-term debt instead. But we'll come on to that in a second. So, I only want cash at the bottom of the cash flow statement here, if it's a positive. So, I could use an if function to do that, but I'd much rather use something much simpler, and that's the max function. The max function, I'm going to say I want the maximum of zero or the figure at the bottom of the cash flow statement. Let's go get that. And the maximum of zero or 117. In this case, it is 117. Great. Let's do the same kind of thing with our short-term borrowings but in this case, I only want the figure from the bottom of the cash flow statement if it's a negative. So instead of using the max function, I'm going to use the minus min function. Now, I've used the minus min because I want to change the negative to a positive. So, let's say I want the minimum of zero, or the figure at the bottom of the cash flow statement. Now annoyingly, this one is a positive. So, because it's a positive, it's just going to return a zero. But let's see what would have happened if I changed that cash balance at the bottom. Let's see what would happen if I changed that, and made it a negative. So, I've now got a negative 117 here. Let's see what would have happened in the balance sheet. My short-term borrowings would have changed to 117.

Let's undo that before we accidentally leave that in there. It was just an example. So, undo that. Great. So, my balance sheet is basically done. What I want to do now is I want to copy all of this to the right and make sure my balance sheet balances in every year. So, I select the cells, I now press CTRL+R to copy that to the right. I do exactly the same for my short-term borrowings.

Select the cells to the right and hit CTRL+R. And now I want to go down to all those line items in the cash flow statement that I've just done. Select all of them. And select to the right. And hit CTRL+R, so they all copy to the right in one go. And now I'm getting excited. Oh, we're going to have a balance sheet in every single year. Fingers crossed! And it balances! Amazing, what a great feeling.