The last balance sheet account that we need to calculate is the property, plant, equipment. The components of PPE that we need assumptions for to complete our CapEx and depreciation. Depreciation, as you may recall was forecast on the monthly income statement and we've already converted it to a weekly accrual on the weekly income statement. CapEx was also forecast. However, we have not dealt with the CapEx yet as it doesn't belong on the income statement. We haven't seen that account yet. The assumption for CapEx is actually on the monthly property, plant, equipment roll forward. So basically, again, because this model, this 13 week model had existed previously, we had a roll forward for CapEx and that exists here on the monthly roll forward page which are the monthly versions of the accounts that we're working on now on the weekly income statement. So the CapEx, historically, has been about 5,000, 4,000 each month. And we have a forecast here for the next three months which will comprise our 13 week period of 5,000 per month.

So what we'll need to do is we'll have to get this into a weekly number and below the PP&E calculation, we have our daily CapEx which is simply CapEx on a monthly basis divided by the number of days in that month. So taking that daily CapEx, we're going to have to convert it on our weekly roll forward into a monthly amount, that's going to require that we come up here to the top. I have hidden these rows previously for more room. I'm going to unhide them now and we're simply gonna take that daily CapEx number and convert it into a weekly number. And we'll do that beginning in column Q, which is our first cashflow period. That's going to be equal to Q8 times the CapEx from October, the daily CapEx from October in H43. And again, I want to anchor that column plus Q7, which are the six days in November times the November daily CapEx. Also anchored by the column, my beginning PP&E will be my ending PP&E from the previous period. And my depreciation is going to come directly from the weekly income statement. So I'll get that from column Q in row 14. And that's gonna remain a negative 'cause it reduces our PP&E balance. And now I can go ahead and calculate my ending PP&E. So again, the thing I need to be careful of here is that changeover from month to month with the CapEx 'cause we need to adjust in the first week of each month. So I have to go back and rebuild this formula, again, the November CapEx times the number of days from the previous month, plus the number of days from the current month times the December. And I need to go in and re-anchor my column here in the first argument of the formula. And now I can go ahead and copy this over through the end of December and build one last time in this model. I know we'll all be happy about that. The conversion of monthly to weekly for CapEx, so six times the December anchored plus one day times the January, and we now have our PP&E roll forward through the end of the 13 week period. Our CapEx, our major cash outflow is the big takeaway from this calculation.