
Package: SuperComplex M&A LBO Modeling
 Package: Intensive Accounting Boot Camp
 Package 1: Basic & Fundamental Concepts
 Package 2: Core Fundamental Concepts
 Package 3: Advanced Financial Modeling
 Package 4: Valuation Modeling Topics
 Package 5: Merger Modeling Topics
 Package 6: Leveraged Buyout Modeling
 Package: Technical Applications  Excel
 Package: Private Company Valuation
 Package: SuperComplex M&A LBO Modeling
 Package: Distressed Financial Modeling
 Package: Bank Financial Modeling
 Package: Insurance Financial Modeling
 Package: Real Estate Development Modeling
 Package: REIT Financial Modeling
 Package: BuySide Series
 Overview of Financial Markets + Exhibits
 Verification
 Certification
Package: SuperComplex M&A LBO Modeling
Take your modeling skills to an unmatched level: build fullblown, fullyintegrated, merger & LBO models that slap together the complete target + acquiror model into the extremely robust merger model. The integrated fullblown LBO model allows the target to be acquired or LBO'ed. This is among the most advanced models out there. Period. End of story.
Courses
 Complex, SuperAdvanced Merger Modeling (26 post(s))
 Complex LBO Modeling & Enhancements (44 post(s))
Last 10 posts
Complex LBO Modeling Enhancements  Mezzanine / Warrant Holder Investment Return (with PIK and Warrants)
I am confused by your comment re: "if warrants are converted..." ==> Does it mean that If conversion right is exercised and warrants are converted to equity interest based upon the conversion ratio, my Total Equity Interest will then be = (1) % of equity due to warrants conversion to equity inte... Read More
I am confused by your comment re: "if warrants are converted..." ==> Does it mean that If conversion right is exercised and warrants are converted to equity interest based upon the conversion ratio, my Total Equity Interest will then be = (1) % of equity due to warrants conversion to equity inte... Read More
What is Happening to "Existing Debt Tranche 1" in the "Debt Sweep" Worksheet, if "Refinance Option 3  Refinance AllExisting Debt" is selected for Switch Cell "W3" in the LBO Summary?
I have just finished Complex LBO & Enhancements module and encountered this problem below. In the "LBO Summary" worksheet, if the "Refinance Option 3 – Refinance AllExisting Debt Refinanced” is selected for switch cell "W3", I then thought the “Existing Debt – Tranche 1” in the Debt Sw... Read More
I have just finished Complex LBO & Enhancements module and encountered this problem below. In the "LBO Summary" worksheet, if the "Refinance Option 3 – Refinance AllExisting Debt Refinanced” is selected for switch cell "W3", I then thought the “Existing Debt – Tranche 1” in the Debt Sw... Read More
SuperAdvanced Merger Modeling  IS
I just finished the "SuperAdvanced Merger Modeling IS" module. I have two questions: (1) Line 28, Amortization of Transaction Debt Financing Fees => Since "Transaction Debt Financing Fees" is a financing decision = It does not affect EBITDA => Therefore, it should not be included in the EBITDA... Read More
I just finished the "SuperAdvanced Merger Modeling IS" module. I have two questions: (1) Line 28, Amortization of Transaction Debt Financing Fees => Since "Transaction Debt Financing Fees" is a financing decision = It does not affect EBITDA => Therefore, it should not be included in the EBITDA... Read More
LBO Model LBO Summary 1 Option 7 Shares Outstanding Section Cell Number AA39  Outstanding Amount at Strike price of $33.00
Per JCP FYE 1/29/2005 (FY 2004) 10K, page 40, Footnote 15 StockBased Compensation, Stock Options subsection, the table lists Stock Options Outstanding at strike price of $33.00 is "5,668". However, in the video presentation, your input was "5,688", resulting in FDSO under Deal to be "276.128... Read More
Per JCP FYE 1/29/2005 (FY 2004) 10K, page 40, Footnote 15 StockBased Compensation, Stock Options subsection, the table lists Stock Options Outstanding at strike price of $33.00 is "5,668". However, in the video presentation, your input was "5,688", resulting in FDSO under Deal to be "276.128... Read More
Illustrative Valuation Summary Section
For the "Enterprise Value as a Multiple of:" part of the Illustrative Valuation Summary Section, I understand why we are going off the pasted values for the 'current' column of multiples, but not for the 'transaction' column; wouldn't we want to divide the 'transaction' column's Equity Value and Ent... Read More
For the "Enterprise Value as a Multiple of:" part of the Illustrative Valuation Summary Section, I understand why we are going off the pasted values for the 'current' column of multiples, but not for the 'transaction' column; wouldn't we want to divide the 'transaction' column's Equity Value and Ent... Read More
Complex LBO Modeling Course (Super Complex M&A Modeling Course)
I am seriously thinking of purchasing this package. I already have a good understanding on LBO's and advance knowledge of excel modeling. However, is it necessary for me to go through Package 6 before going through the "SuperComplex" course? Perhaps there is a model built in LBO Course (Package... Read More
I am seriously thinking of purchasing this package. I already have a good understanding on LBO's and advance knowledge of excel modeling. However, is it necessary for me to go through Package 6 before going through the "SuperComplex" course? Perhaps there is a model built in LBO Course (Package... Read More
EPS adjustments
The diluted EPS reported on p.57 of the pdf. is 0.95 vs the 0.97 we get from dividing NI by DSO. This is because the net income is adjusted for 2 items (1) preferred stock dividends (2) interest on convertible debt. I understand that item 1 is often paid after net income on the P&L. But why isn't it... Read More
The diluted EPS reported on p.57 of the pdf. is 0.95 vs the 0.97 we get from dividing NI by DSO. This is because the net income is adjusted for 2 items (1) preferred stock dividends (2) interest on convertible debt. I understand that item 1 is often paid after net income on the P&L. But why isn't it... Read More
Sources and Uses Questions
Does Management Rollover Equity affect Sponsor IRRs at all? Why? Would the Sponsors IRR be lower, higher, or the same assuming there was rollover? In the Quick and dirty LBO model in the sources there was 10,520 of debt. This equates to 6.3x debt to ebitda. I know it is different for every industry... Read More
Does Management Rollover Equity affect Sponsor IRRs at all? Why? Would the Sponsors IRR be lower, higher, or the same assuming there was rollover? In the Quick and dirty LBO model in the sources there was 10,520 of debt. This equates to 6.3x debt to ebitda. I know it is different for every industry... Read More
Diluted shares outstanding
Can you assist in locating the exact moment on the Complex LBO video where the diluted shares outstanding formula: "MAX(0,10.78*(133/44.88)" is inputted. Cant quite locate it...
Can you assist in locating the exact moment on the Complex LBO video where the diluted shares outstanding formula: "MAX(0,10.78*(133/44.88)" is inputted. Cant quite locate it...
A followup to my previous question, it just occurred to me : Did you mean ==> if the warrants conversion right is exercised, then the annual Cash Flow prior to the Exit Year will be = Common Dividends Received * E102 (Equity due to Warrants) + Mezzanine Notes  Cash Interest; and ==> Exit Y... A followup to my previous question, it just occurred to me : Did you mean ==> if the warrants conversion right is exercised, then the annual Cash Flow prior to the Exit Year will be = Common Dividends Received * E102 (Equity due to Warrants) + Mezzanine Notes  Cash Interest; and ==> Exit Year Cash Flow = Implied Equity Value * E102 (Equity due to Warrants) + Cash Dividends received * E102 + Mezzanine Notes  Cash Interest. Thx. Peter Read More