Advanced LBO Modeling Introducing a buy-out with a detailed multi-tranche financing structure. The transaction happens mid-year, necessitating a stub period. A fully integrated buyout model for the stub period and forecast years is completed with a detailed debt sheet. Show lesson playlist 01:59 Basic LBO Primer #1 of 33 03:01 Advanced LBO Model Tour #2 of 33 04:01 Flexible Deal Date - Why Do We Need A Stub Period #3 of 33 04:06 Deal Date Income Statement #4 of 33 02:49 Deal Date Balance Sheet #5 of 33 03:54 Deal Date Cash Flow Statement #6 of 33 03:05 Sources And Uses Of Funds #7 of 33 05:13 Immediately Post Deal Balance Sheet #8 of 33 04:13 Stub Period - Income Statement #9 of 33 03:25 Stub Period - Balance Sheet #10 of 33 05:23 Stub Period - Cash Flow Statement #11 of 33 03:30 Forecast - Income Statement #12 of 33 02:39 Forecast - Balance Sheet #13 of 33 04:53 Forecast - Cash Flow Statement #14 of 33 01:37 Debt Schedule and Sweep Explained #15 of 33 02:57 Debt Schedule Tour #16 of 33 04:59 Debt - Cash Flow Available For Debt Service #17 of 33 03:36 Debt - Revolver And Refinancing Facility #18 of 33 06:09 Debt - Cash For Sweep #19 of 33 03:52 Debt - Term Loan B, Second Lien, High Yield #20 of 33 01:16 What Is A Capex Facility #21 of 33 03:47 Debt - Mezzanine, Capex Facility #22 of 33 02:30 What Is An Original Issuer Discount #23 of 33 02:33 Debt - Original Issuer Discount #24 of 33 04:30 Debt - Ending Cash Checks #25 of 33 03:21 Putting Debt Into Balance Sheet #26 of 33 04:49 Interest - Revolver, Refin, Term Loan B #27 of 33 03:23 Interest - Second Lien, High Yield, Mezzanine #28 of 33 04:28 Interest - Capex Facility, Interest Income #29 of 33 05:30 Interest - Circular Interest in Income Statement #30 of 33 02:39 Debt - Refinancing Facility In Use #31 of 33 06:24 IRR #32 of 33 Advanced LBO Modeling Tryout #33 of 33 Debt - Mezzanine, Capex Facility 03:47 capex facility, capital expenditure facility, Debt Schedule, Leveraged Buy Out, Mezzanine, Paid In Kind, PE, PIK, Private Equity, Sweep, Waterfall Issuing or repaying term loan B, second lien and high yield in an LBO
