Re: Complex Trading Comps Analysis
We should not adjust the $13,895 because it is merely a change in their estimates to arrive at the correct full year tax number.
This is not the effect of a one-time item, it is simply correcting conservative assumptions from the previous 3 quarters.

Re: Text to Row
Assuming that you do want to flip your data into a "table", i.e. transpose a single column of data to multiple rows, where each row is a different record like a database, follow these steps. Assuming your data (as you inputted in your initial question) is all in column A and starts in A1 ... Assuming that you do want to flip your data into a "table", i.e. transpose a single column of data to multiple rows, where each row is a different record like a database, follow these steps.

Assuming your data (as you inputted in your initial question) is all in column A and starts in A1 and assuming that Operator, Address and Phone are repeated with no extraneous rows (i.e. 3 rows per record):

STEP 1: Remove the titles (Operator, Address and Phone)
Go to B1 and type in: =RIGHT(A1,LEN(A1)-FIND(": ",A1)-1)
This will simulate a "text to columns" via formula since we don't like manual text to columns
Or you could have done a text to columns based on : delimiter and then use trim function on the actual data to remove the extra space in front
Copy this down the entire column B until your data in column A ends
If you have our WST macros installed, go to B1 and hit CTRL+SHIFT+ALT+D

STEP 2: Enter in 1, 2, 3 repeatedly in column C (needed for Filter shortly)
In cell C1, type in 1; in cell C2, type in 2; in cell C3, type in 3
In cell C4, enter in formula: =C1 and then copy C4 down until your data in column B ends
You should have 1,2,3 repeatedly in column C
If you have our WST macros installed, go to C4 and hit CTRL+SHIFT+ALT+D

STEP 3: do transpose array
Select cells D1:F1 (three cells across the first row of data)
Type in =TRANSPOSE(B1:B3) and hit CTRL+SHIFT+ENTER
The last part is important, as transpose must be an array else it won't work correctly
You formula is now: {=TRANSPOSE(B1:B3)}
The { } indicates an array

STEP 4: copy down the transpose
Select cells D1:F1 and copy down until your data in column C ends
If you have our WST macros installed, select D1:F1 and hit CTRL+SHIFT+ALT+D

STEP 5: clear out unwanted cells
At this point, you ONLY want the entries in which column C has a 1 in it
Thus, Select your entire data set from column C to F, so with your sample data, that's C1:F9
Hit ALT+D+F+F (any version of Excel for Windows) or ALT+A+T (Excel 2007 and above)
Go to C1 and open the drop-down (ALT+DownArrow) and select just 1 (uncheck Select All and then check 1)
Only the correct transposed values are visible now

Step 6: Copy paste values
Select C1:F9 (your entire data set basically) and Copy (Ctrl+C)
Go to a blank worksheet or anywhere on the side and paste (Enter or Ctrl+V)
It should paste automatically as values (else transpose function will reference wrong cells)
If it didn't paste correctly, then do a Paste Special (ALT+E+S+V)
In either case, the rows with "2" and "3" in column C do not appear.
This is because when you copy/paste from an filtered data set, it does not copy the hidden (non-visible cells)

This is relatively straightforward; if you have different number of rows for each record, i.e. some have Phone, some don't or some have Website, some don't and it's not consistent, then it's more challenging. You would skip STEP 1 and at the end, add a bunch of offset match functions to properly parse the data into the right column headings, and then use STEP 1 to clean out the headers. Incidentally, all of these techniques we just covered are thoroughly reviewed in our Advanced Excel for Data Analysis course: http://www.wallst-training.com/self-stu ... tech-excel

If you can master those topics we cover in that course, you'll be able to tackle difficult stuff like this.
Hope that was helpful. Read More

Re: Revolver Priority in Bankruptcy
Each deal and credit agreement terms are different, but generally speaking, revolvers are backed by accounts receivable and inventory. Not to say that revolvers are collateralized (they're usually not), but the A/R and Inv have been pledged. Also, usually, a revolver is the first facility to not get... Each deal and credit agreement terms are different, but generally speaking, revolvers are backed by accounts receivable and inventory. Not to say that revolvers are collateralized (they're usually not), but the A/R and Inv have been pledged. Also, usually, a revolver is the first facility to not get paid, since it's the shortest duration facility (other than bonds coming due or amortizing term loans, etc), and so the banks will tend to shut it off sooner and demand immediate payment (like your credit card). Read More

Re: Revolver Priority in Bankruptcy
To further clarify: Revolvers or any bank debt (revolvers, Term Loan A and Term Loan B) have the higher priority vs unsecured creditors as they are secured tranches vs unsecured creditors and definitely are not pari passu. Depending on a type of deal, asset based or cash flow, the revolvers can b... To further clarify:
Revolvers or any bank debt (revolvers, Term Loan A and Term Loan B) have the higher priority vs unsecured creditors as they are secured tranches vs unsecured creditors and definitely are not pari passu.

Depending on a type of deal, asset based or cash flow, the revolvers can be backed by assets or by stock. If the revolver is asset based, then it is usually
backed by 85% of A/R, 60% if Inventory and in some cases 50% of RE, if any. If CF revolver, than depending on issuer's profile and credit rating, it can be all assets, or just stock. Read More

Re: Printing
Logic:
Write a code to count the number of visible worksheets in the file, say it returns 8
Then write your print macro to print from worksheet number 2 thru 8 less 1
You can do this easily in a for loop.