The Debt Schedule in 3-Statement Models, LBO Models, and Credit Models

NOTE: There is a "typo" around the 11:30 mark, and we link to the incorrect Beginning Cash balance. It should be $6 billion instead of $6.397 billion. Please go by the Excel file and screenshots. YouTube does not allow us to correct or edit videos.

Excel Files, Resources, and Table of Contents:

0:00 Intro

1:53 Summary of Debt Schedules by Model Type

5:37 Debt Schedules by Complexity and Features

7:22 Debt Schedules in 3-Statement Models

9:46 Debt Schedules in LBO Models

15:07 Debt Schedules in Credit or Refinancing Models

31:40 Recap and Summary

[wenkaiyang]

Awesome video! This is literally what I need. Thank you. looking forward to more.

[Fatmanstan]

Absolutely beautiful module, the web is super scant on refinance modeling which is super prevalent now in superday modeling tests, thank you

[financialmodeling]

Excel Files, Resources, and Table of Contents:


NOTE: There is a "typo" around the 11:30 mark, and we link to the incorrect Beginning Cash balance. It should be $6 billion instead of $6.397 billion. Please go by the Excel file and screenshots. YouTube does not allow us to correct or edit videos.

0:00 Intro

1:53 Summary of Debt Schedules by Model Type

5:37 Debt Schedules by Complexity and Features

7:22 Debt Schedules in 3-Statement Models

9:46 Debt Schedules in LBO Models

15:07 Debt Schedules in Credit or Refinancing Models

31:40 Recap and Summary

[denyagusman]

You are so great! and many thanks for giving it for free :D

[cyrokkk]

Hi Brian, thanks for the content ! I struggle a bit with the way the MIN function works here. What happens if the excess cash flow is positive but inferior to the Revolver drawn portion ? The function will pick the amount of excess cash flow as amount to repay ? So no more cash ? Thanks !

[ericgregorious]

Can u get around circular reference. For me personally I calculate revolver based on beginning instead of average...

[닝닝닝]

Hi, I was wondering if I want to prep for potential private credit modeling test, which video or course do you recommend? I only have experience in DCF and 3 statement modeling. 😂

[JoseFelixVelascoBarbachano]

Thanks for the video! Is the calculation of interest income from cash simplified or is it completely correct to take the final balance from the previous period?

[szesiangchong]

Is revolving credit usually the last thing to do in the 3FS model? Since you usually need forecasted FCF within the calculation for the cash available for pay down

[francocacciuttolo]

how do I find the minimum cash balance?

[MichaelHolder]

Cash at beginning of FY23 is 6000, not 6393

[dbsk]

Amortization = mandatory debt repayments 11:47