Step 9 Summary BS
- 03:38
Step 9 Summary BS
Transcript
The last two things we need to do to the model are complete the weekly balance sheet account and then reconcile the 13-week cash flow to EBITDA so that we can have an EBITDA number to compare to our loan docs or perhaps take back to the market and see if we can restructure. In order to complete the EBITDA reconciliation, we actually need to do this weekly balance sheet summary. And again, this is the summary we used for several of the debt items. They're kind of a worksheet for us to keep track of the items that have changed in the 13-week model specifically. Again, not a complete balance sheet. This is not going to balance, this is not the point of this exercise. I guess in theory, we could build a 13-week cash flow within a larger model and it could all tie together. It would be very complicated though and I'm not sure how much benefit we would get out of all of that considering how specific the needs of the 13-week cashflow are. And in terms of just the specificity of the moment in time when we need a 13-week cashflow, and it's really, again, hopefully just these points in time when the company is going through a liquidity crisis or approaching a liquidity crisis hopefully or not in an ongoing need for a 13 weeks cashflow statement that would roll out over several years. That would be probably saying s something pretty strong about the company and it's financial position. So I'm gonna go ahead and I'm gonna link my cash to the ending cash on the balance sheet and that's going to be this row 31. And the accounts receivable, I'm going to pick up from my roll forward. This is where all the working capital accounts will come from and a few of the non-working capital accounts as well. So I'll make sure I get out to period one, ending balance accounts receivable. And just so you can follow me, I will put these out here. For inventory, same thing. Roll forward down to the ending inventory balance in row 24 and PP&E I have as well on the roll forward and that's going to be the ending balance in row 59. Revolver I can get from the 13-week cashflow. And I have that in Q52. Accounts payable, I will need to go back to my roll forward. Salaries and wages payable also from the roll forward.
Accrued liabilities from the roll forward and the term loan from the 13-week cash flow.
One of the nice things about using this text formula to display the formulas of the cell, which is something I do in the classroom, the nice thing about it I will say from a modeling perspective is that because this is a long model with lots of jumping around in many columns, one quick look of this column tells me that at least I kept my matrix integrity and I didn't take something from the wrong year or wrong, in this case, wrong week, all the cues are telling me that at least I got the column correct. That doesn't guarantee that I'm in the right cell but it does certainly give me some security that I did it right. So now I will copy this across and we've got our weekly balance sheet and we've got all that we need to do. The EBITDA reconciliation.