Posts by: Guest 1
Cash Circular
I have seen the videos (sometimes twice). I have read *everything* on circular references. I have checked that my income expense is keying off of my ending debt values (this company has no debt) and that it has a negative sign. I have similarly checked interest income. It too keys off the ending deb... Read More
I have seen the videos (sometimes twice). I have read *everything* on circular references. I have checked that my income expense is keying off of my ending debt values (this company has no debt) and that it has a negative sign. I have similarly checked interest income. It too keys off the ending deb... Read More
Re: Beginning Cash Balance
I think I found the error, and it has nothing to do with implementing things as taught. Remember, I did what you said earlier, fixed my errors (there were 2), audited all formulas, and I have no debt, so the revolver/interest expense are zero. The SUM function is throwing off wrong answers. This ... Read More
I think I found the error, and it has nothing to do with implementing things as taught. Remember, I did what you said earlier, fixed my errors (there were 2), audited all formulas, and I have no debt, so the revolver/interest expense are zero. The SUM function is throwing off wrong answers. This ... Read More
Beginning Cash Balance
Hi In the debt schedule, we did the following: Cash Available for Debt Servicing Plus: Beginning Cash Balance Less: Minimum Cash Balance Equals: Cash Available before Mandatory Debt Payments Then we pay debt and revolver; which essentially means that we have utilized beginning cash balan... Read More
Hi In the debt schedule, we did the following: Cash Available for Debt Servicing Plus: Beginning Cash Balance Less: Minimum Cash Balance Equals: Cash Available before Mandatory Debt Payments Then we pay debt and revolver; which essentially means that we have utilized beginning cash balan... Read More
Advanced Excel: Pivot Tables Error Message
I'm trying to create the Pivot Table in the Advanced Excel for Data Analysis module and am getting an error message when i'm trying to set up the layout in the PivotChart Wizard. The error is: Cannot open PivotTable source file '[AdvancedExcelDataAnalysisTemplate(1).xls]7) Pivot Table' Know ho... Read More
I'm trying to create the Pivot Table in the Advanced Excel for Data Analysis module and am getting an error message when i'm trying to set up the layout in the PivotChart Wizard. The error is: Cannot open PivotTable source file '[AdvancedExcelDataAnalysisTemplate(1).xls]7) Pivot Table' Know ho... 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
Re: Software for Financial Analyst
This is for investment bank, private equity, merger, and acquisition job. Are we using is regular Excel? please advise more specific so I can purchase one and practice for the next interview. Thanks.
This is for investment bank, private equity, merger, and acquisition job. Are we using is regular Excel? please advise more specific so I can purchase one and practice for the next interview. Thanks.
Re: Distressed Debt Model
Ok I understand what you are saying now. However, why are only the senior notes affected? Is it b/c you are only change one class of debt simply for illustrative purposes to show what can happen to a class of security when post-petition valuation/leverage is off? I assume you can theoretically cha... Read More
Ok I understand what you are saying now. However, why are only the senior notes affected? Is it b/c you are only change one class of debt simply for illustrative purposes to show what can happen to a class of security when post-petition valuation/leverage is off? I assume you can theoretically cha... Read More
Treasury Options: Shares dilution
Hi, I have one doubt related to shares dilution. When you are calculating the Equity Value per share for a private company you need to divide the Equity Value by the number of fully diluted shares. But how can you have the number of diluted shares if we neither have a current market value (as it ... Read More
Hi, I have one doubt related to shares dilution. When you are calculating the Equity Value per share for a private company you need to divide the Equity Value by the number of fully diluted shares. But how can you have the number of diluted shares if we neither have a current market value (as it ... 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*(1-33/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*(1-33/44.88)" is inputted. Cant quite locate it...
Many thanks! I will give it a try once this drink (and the few that followed it) have worn off!