Posts by: WST Expert 1
Re: about the diluted shares outstanding
When initially building the first pass on the IS (before BS and CF), we simply say set this projected year's diluted shares outstanding to last year's for simplicity. Then, when we have finished our Cash Flow Statement construction, we have an actual updated basic shares outstanding count after the... Read More
When initially building the first pass on the IS (before BS and CF), we simply say set this projected year's diluted shares outstanding to last year's for simplicity. Then, when we have finished our Cash Flow Statement construction, we have an actual updated basic shares outstanding count after the... Read More
RE: List of random numbers from -1 to 1 with given std dev
To create a random number between -1 to 1, use the formula: =rand()*2-1 rand() generates a random number between 0 and 1 hence the need to modify the range. as for a given standard deviation, it is doubtful that can be done - that is to specify a standard deviation and have excel generate a lis... Read More
To create a random number between -1 to 1, use the formula: =rand()*2-1 rand() generates a random number between 0 and 1 hence the need to modify the range. as for a given standard deviation, it is doubtful that can be done - that is to specify a standard deviation and have excel generate a lis... Read More
RE: Advanced Excel: Pivot Tables Error Message
Please make sure that you have saved the file separately to the desktop or otherwise as opposed to working off a "temp" version of the template file. If working directly off your desktop or hard drive and the same error msg occurs, please recreate the pivot table from scratch as their may be a ... Read More
Please make sure that you have saved the file separately to the desktop or otherwise as opposed to working off a "temp" version of the template file. If working directly off your desktop or hard drive and the same error msg occurs, please recreate the pivot table from scratch as their may be a ... Read More
Re: Sources and Uses Questions
Usually mgmt rollover or other rollover equity does not affect sponsor IRR since everything is the same proportion. The capital structure of an LBO company post-deal various but rules of thumb are: Bank Debt: 25%-50% Bonds: 25%-50% Equity: 15%-40% Bank Debt includes: revolver, term loans, securit... Read More
Usually mgmt rollover or other rollover equity does not affect sponsor IRR since everything is the same proportion. The capital structure of an LBO company post-deal various but rules of thumb are: Bank Debt: 25%-50% Bonds: 25%-50% Equity: 15%-40% Bank Debt includes: revolver, term loans, securit... Read More
Re: Question about EPS
No circular references in that logic, because the key is that we use PRIOR YEAR's EPS on the CF to estimate number of shares repurchased. If we used THIS YEAR's EPS, then yes, we get a circular reference. See your other post for more detailed explanation.
No circular references in that logic, because the key is that we use PRIOR YEAR's EPS on the CF to estimate number of shares repurchased. If we used THIS YEAR's EPS, then yes, we get a circular reference. See your other post for more detailed explanation.
Re: Software for Financial Analyst
Regular Excel correct. Buy a PC laptop with Office for PC.
And one doesn't just "learn Excel", one must use Excel.
Get up the learning curve fast:
http://www.wstselfstudy.com/programs.html
Regular Excel correct. Buy a PC laptop with Office for PC.
And one doesn't just "learn Excel", one must use Excel.
Get up the learning curve fast:
http://www.wstselfstudy.com/programs.html
Re: Distressed Debt Model
That was an illustrative exercise. We're teaching you how to think, not the only scenario that could occur!
That was an illustrative exercise. We're teaching you how to think, not the only scenario that could occur!
RE: Summarize ways to copy & paste efficiently in Excel
Copy / Paste => copies and pastes formulas/values, formatting and comments Ctrl + R / D => copies and pastes formulas/values and formatting don't forget about Ctrl + L and Ctrl + Shift + U with our macros Ctrl + Enter => copies and pastes formulas/values only Ctrl + ' => copies and ... Read More
Copy / Paste => copies and pastes formulas/values, formatting and comments Ctrl + R / D => copies and pastes formulas/values and formatting don't forget about Ctrl + L and Ctrl + Shift + U with our macros Ctrl + Enter => copies and pastes formulas/values only Ctrl + ' => copies and ... Read More
RE: Selecting two or more non-adjacent cells to quicky get sum
To highlight non-adjacent cells, use mouse - it's quicker. One could write a macro, but not worth it. When you have more than 1 cell (whether adjacent or not adjacent) selected, see the bottom right of your status bar. The sum should appear.
To highlight non-adjacent cells, use mouse - it's quicker. One could write a macro, but not worth it. When you have more than 1 cell (whether adjacent or not adjacent) selected, see the bottom right of your status bar. The sum should appear.
Debt covenants are determined by the Company’s industry. In the past few years, LBO’s have increasingly been structured with covenant-lite debt, meaning that they have fewer requirements and restrictions than traditional debt structure. However, as debt markets substantially decline (as in 2007 ... Debt covenants are determined by the Company’s industry. In the past few years, LBO’s have increasingly been structured with covenant-lite debt, meaning that they have fewer requirements and restrictions than traditional debt structure. However, as debt markets substantially decline (as in 2007 Q3), investors have lost their appetite for covenant-lite debt. Before modeling a potential LBO transaction, discuss with debt capital markets what the appropriate covenants for a deal are and the maximum debt to EBITDA ratio appropriate for the particular industry. Read More