No cashflow statement is complete without the reconciliation of the cash account. Please keep in mind we did not complete a full balance sheet for the projected 13 weeks nor do we need to. It is helpful however, to keep a tally of the balance sheet accounts that we did forecast by way of base analysis and roll forwards. These are the only accounts that will be impacted by our projection. We will complete this once we complete the 13 week cashflow statement and that's going to be on this weekly balance sheet summary page. In the meantime, we will use the weekly balance sheet to access the historical weekly balance sheet accounts. Again, if we had a rolling 13 week model set up, we would have the balances for the balance sheet accounts, this is the situation we have. In this model, we benefit of having this done for us. If we were starting one from scratch, again, we would need to get those ending balance sheet accounts for the previous week period end, day one, so to speak, of our 13 week calendar. We need to get that from management. I say this because we obviously need a jumping off point for cash, we need to know where cash ended and that could be the October 30th which is the previous week's cash balance account. And that's given to us here on this weekly balance sheet summary. We need to have that number in order to perform the cash balance analysis. So the ending cash here of 21,989 is simply coming from that weekly balance sheet summary page. Again, this is not a complete balance sheet, it is not going to be a complete balance sheet, it's simply a place for us to put some place markers. Back on the 13 week cashflow tab, there are a few complications with cash, and I'm gonna zoom in here just so we can zoom in on the numbers. There is a minimum required cash balance of 20 million and that's on the high side but that might be something that the bank is required. It might be something that management feels that they need to have on hand to be comfortable. We need to make sure that we never go below this. If the company is generating excess cash however, we need to be able to add that amount to the minimum cash amount. So we're gonna be using a MAX formula for this. So first things first, let's go ahead and get our beginning cash in here from the ending cash of the previous year. And we can get our net cash flow from the net cash flow in row P23 above.

The ending cash is therefore going to simply be the net of of the beginning cash and the loss. The minimum cash amount is going to be the same in each period and that's going to be equal to that $20,000 hard coded assumption. So now we need to figure out what is the surplus cash, if it's positive or how much do we need to draw on the revolver if we need to satisfy that 20 million minimum cash amount. So again, we can't go below the 20 million, so it would simply not be okay to end our cash balance at 14,399. So my surplus cash is going to be my ending cash amount less the minimum cash amount and that tells me, if I'm below that, of course it'll be a negative number and that will tell me that I need to draw on the revolver to stay at that 20 million cash level. Now because the formula start to get complicated in this section, I'm gonna go ahead and put them off to the right. We also have the downloadable manual that you can keep up on screen as well that has the appropriate cell references in it that you can use but for now, I think I wanna do this. Now the ending cash on the balance sheet at this point, well, since we fell below the 20 million and we need to get to the minimum of 20 million, our intuition will tell us that basically the minimum cash, the ending cash on the balance sheet now is simply going to be the 20 million. The formula that we need for that, it's going to be the greater of the minimum cash required and the minimum cash required plus the amount in the surplus cash slash revolver amount. So if I had surplus cash, it would simply be adding these two numbers together and giving me a greater number. So just to test my formula, I'm going to just pretend that I had positive cash flow and see what happens to my formula. So here I had positive cash flow and that means that I have surplus cash here. And now the way the max formula is working, it's simply adding the surplus cash to the minimum cash required and giving me my ending cash amount. And that of course matches with my ending cash amount above. So those two should be the same. I will undo that because we're gonna be testing these formulas as we go to make sure they work and it's very important that we change it back after we do it or else we've got a lot of nasty hard codes in the numbers.