13 Week Cash Flow - How to do it?

Hey Everyone,

I'm interested in learning about the 13-Week Cash Flow model that is used in turnaround/distressed situations. Does anyone have any good resources? I'm going to be interviewing for a role in our distressed group and I'm going to have to model it out. Would appreciate your help/advice.

Thanks!

 
Best Response

The best thing to do is try and model out a scenario yourself and think each step through. When preparing for Ch. 11, a company will surely owe plenty of money to all kinds of creditors, not just banks. When you build your projections you are assuming that all accrued debt is wiped clean(for now) and you are starting with a clean slate.

When you make your projections make sure every creditor is paid current from the petition date, even bank interest. What you are going to see is negative cash flow.

From there you want to calculate Debtor in Possesion (DIP) financing - basically how much you will need to stay afloat for the 13 week period, equal to your cumulative cash deficit.

Your cash balance each week should be exactly zero (or some minimum cash balance that you set).

Make sure you can input separate rates for the current bank debt, other accruals, and DIP financing.

If you do this and read up on Ch.11 cases, you should be fine.

 

Thanks for sharing this post! The impact of global financial crisis brought numbers of bills, debts and bailouts to people and many investment companies. We dive so far into the world of debt that it becomes overwhelming, unmanageable, and plain out stressful. Believe it or not, if your debt has reached this point, you are not alone. One solution to this is debt consolidation. It is for when you have too many bills and the payments on your personal loans and other debts are getting to be too much. Debt consolidation brings all of these bills under one payment umbrella, and lowers the interest rate, and therefore payments. If you feel like you're drowning, and you have too many bills, then looking into debt consolidation is a far better choice than struggling paycheck to paycheck and worrying about short term loans to fill the gaps.

 

Ut officiis voluptatem iure delectus. Vitae blanditiis sit laudantium tenetur laboriosam ducimus. Rem laudantium eligendi velit occaecati. Placeat quos neque consectetur sed debitis omnis.

Quasi natus aperiam rerum vero. Natus magni fuga quia velit quia sed omnis. Sapiente dolorum suscipit voluptates quod. Aspernatur omnis saepe repellat officia non.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (145) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
CompBanker's picture
CompBanker
98.9
6
dosk17's picture
dosk17
98.9
7
kanon's picture
kanon
98.9
8
GameTheory's picture
GameTheory
98.9
9
bolo up's picture
bolo up
98.8
10
Linda Abraham's picture
Linda Abraham
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”