Posts by: Guest 1
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...
Re: about the diluted shares outstanding
Thank you!
Thank you!
Interview Question - What would Hamilton or Dave Do?
I was hit in an interview with the question, "How would you value TiVo?" Here's the rub: the company is way out of my field. Yes, I know what a TiVo is, and I also know my cable box does the same thing. I also know I don't watch TV and have never had an occasion to use the DVR functions. S... Read More
I was hit in an interview with the question, "How would you value TiVo?" Here's the rub: the company is way out of my field. Yes, I know what a TiVo is, and I also know my cable box does the same thing. I also know I don't watch TV and have never had an occasion to use the DVR functions. S... Read More
Income Tax Payable
I just wanted to know if Income Tax payable can be lumped together as AP on the balance sheet or do we categorized it as accrued income taxes? Can you please explain? Thank you.
I just wanted to know if Income Tax payable can be lumped together as AP on the balance sheet or do we categorized it as accrued income taxes? Can you please explain? Thank you.
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... 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 balance in order to pay down debt. If this is correct then for calculating Ending Cash Balance in the Cash Flow statement why we once again add Beginning Cash Balance in the Change In Cash for the Year. Is this not the double counting of Beginning Cash Balance?
Please Explain. Read More