Below you’ll find a replay of the coronavirus cash flow contingency planning webinar we held on Thursday, April 2nd, which walks through the cash flow planning template we’ve developed.
Here’s the link to use the template: Cash Flow Contingency Planning Template
The Objective
What’s most important now is making informed decisions and doing what we can to ride this thing out successfully. This exercise is aimed at helping you generate a clear-headed plan for getting the brewery through to the other side.
We spend the first 30 minutes or so walking through the cash flow planning process and template we’ve developed to help owners map out the next 3-6 months under best, worst, and likely sales reduction scenarios.
This covers cash infusion as well as relief, deferment, and expense reduction: when, where, and how much. We then spend the remainder of the time in Q&A addressing specifics.
Timestamps for your reference:
- 0:00 – Introduction and some notes about what’s happened over the last 3 weeks or so.
- 4:50 – An overview of the cash flow contingency planning tool.
- 8:25 – Creating an editable copy of the template.
- 9:20 – Pulling in your latest P&L data as a baseline.
- 15:10 – Adding in your P&L information into the analysis input tab and making any adjustments needed.
- 21:32 – Setting up your cash flow projection baseline.
- 27:20 – Planning for cash infusion and expense reduction modifications and prioritizing those options.
- 35:20 – Using the model on an ongoing basis for decision-making as time passes and you gather new information.
- 38:55 – Q&A Starts. Is there a way to add principal and/or debt service changes into the model?
- 39:50 – How do we handle incorporating an annual occupancy adjustment within the model?
- 40:28 – Is this set up for cash or accrual basis?
- 42:50 – Are you adding debt payments under Other Expenses? What about depreciation?
- 44:40 – Some PPP questions and information.
- 47:47 – What percent sales reductions are breweries in the rest of the country seeing?
- 51:37 – If our loans are being deferred for 90 days, how does that go into the model?
- 52:21 – Does this model allow for post-recovery adjustments and adding in new cost line items?
- 53:57 – More PPP questions.
- 1:01:47 – Which actions and decisions will prove fatal to small brewers vs. keep business thriving?
We hope you find this useful.
If you have questions specific to this planning tool → email tom@sbstandard.com.
If you have more broad financial or operational questions → email chris@sbstandard.com.