13-week model for distressed firms
Not sure if this is the right place for this, but are there any places where I can find a 13-weel cash flow model and learn more about distressed/restructuring modeling?
I know that WSP has a modeling course (~$400), but are there any free resources.
Anything out there in the public domain is pretty basic and not all that useful. I'm not sure the purpose you are using one for, but nothing I have seen in the public domain will be taken seriously by a bank, mezz fund or PE investor if the Company really had liquidity concerns. For companies under 25M in revenue, one location, one business line, very simple, they may be useful.
13 week cash flows are typically high customized to a company's cash conversion cycle and business model at a specific point in time. I doubt anyone would share a detailed developed model due to all the confidential information contained in one. Also they very significantly by industry, an auto manufacturer vs construction company versus a professional services firm.
I work at a restructuring firm, we have some high level template slides for presentation purposes that don't change a ton, but the bones of everyone vary significantly because they are built on the outputs of client systems (AR, AP, backlog, accruals) and client schedules (sales forecast, etc). Its difficult to template those components.
In addition, every borrowing base is calculated differently. distressed client typically under these, but this is not included on everyone.
What is the best way to prepare for restructuring interviews at places like PJT, Evercore, Moelis etc?
Thanks mate - Would it be possible to highlight which line items should be focused on or which are most volatile across the 13 week period though? I imagine after doing a few of these deals you'll start noticing recurring themes
Cash receipts can be difficult to model for certain clients, be sure to look at customer actual payment history. Forecasting timing leakage (if applicable) or accretion on A/R can be tough. (get the bank collateral audit for a quick cheat on accretion, so you don't have to do it yourself, or can at least roll it from when it was done) If your using a backlog to forecast sales and cash receipts after the AR burns off, have a conversation with the operational people. the people involved in inputting in the data usually do it based on when the client request the work to be performed, or desired dates of shipment, but not necessarily when the client plans to manufacture or deliver.
On the disbursement side, judging the timing of payments and how much "stretch" you can put into the numbers (assuming this is a distressed company) can be very subjective.
Forecasting Capex is extremely difficult at any client where this is an issue.
Forecasting cash disbursements for employee turnover with stock options in the money is nearly impossible, if any key person leaves, which they will never tell you until they do, who holds significant in the money options can be a problem. For private companies who have the valuation done once a year based on the prior year financials, there can be substantial payouts, even though the company is currently in a liquidity crisis.
Overall, you need to verify information well beyond the accounting/finance department and get to the operational people. Understanding staffing if that flexes significantly during seasonal companies or the affect of layoffs and severance can be material.
These forecast are usually only directionally correct.
Send me an email and I'll send you the one that's published in my book on the subject. [email protected]
His book his really good. Definitely take him up on the offer; I forced everyone at our firm to buy a copy lol.
Is it OK if I reach out to you as well? Would appreciate.
Yes, I've probably shared about a dozen times already.
Would you say your book is useful to someone working in a&m/Alix/fti on debtor / company side restructuring but who has come from other industry and wants to be more knowledgable about how to help clients/what solutions to come up with? Feel like it's such an on the job learning through experience thing but haven't had much chance yet. Ps EU based not US if it matters
Just saw this, Yes. Written from a sub $500M revenue perspective but the mechanics are all the same, insolvency rules the same, bank attitudes the same, etc. Biggest difference is I suspect Alix/AM/FTI are more like 10 people giving advice vs one CRO making changes.
Read this later
Et suscipit iure rem voluptatem quo sit sint. Ex aut qui ducimus harum. Et iste blanditiis consectetur. Consectetur est sed voluptas ratione autem eius quia. Exercitationem optio accusamus qui aut minima.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...