Posts by: WST Expert 1

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.
Go to post added 11 years ago
Re: Text to Row
To clarify, are you looking to re-arrange your data so that you essentially have three columns: Operator, Address, Phone (these are the column headers); and the data itself fills in underneath it, like a table/mailing list, etc. Text to Columns (or "Text to Rows") would simply parse the O... Read More
Go to post added 11 years ago
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 ... Read More
Go to post added 11 years ago
Re: Information session at AEPi
It was great meeting you and I'm happy to see you take an active role in your future. While things are still being played out in Wall Street in this current financial crisis, what is still certain is that the most elite areas of finance (i.e. investment banking, private equity, mergers & acqui... Read More
Go to post added 11 years ago
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... Read More
Go to post added 11 years ago
Re: Tax implications on Cash vs Stock deal
The answer is much more complicated and ultimately depends on the tax situation of the seller. Short answer: In a stock deal, goodwill is created which is not tax deductible, and that is not a good thing either. The you wrap in 338(h)(10) elections in certain cases. Does the target company have larg... Read More
Go to post added 11 years ago
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... Read More
Go to post added 11 years ago
Re: Text to Row
This will get kind of ugly but bear with us here: So say A1 is a cell containing "Operator: John Doe Address: 123 S Washington St. Phone: (123) 456-789" (including the line breaks). Then in B1, you want to separate out the Operator using this formula: =LEFT(A1,FIND("Address",A1... Read More
Go to post added 11 years ago
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.
Go to post added 11 years ago
Re: Technical Question: Excel for PC vs Excel for Mac shortcuts
AutoSum: ALT = is Command Shift T Edit Mode: F2 is Ctrl U Anchor cell reference in edit mode: F2 is Command T Underline: Ctrl U is Command U When pasting, in PC, you can hit ENTER, in Mac version, you have to hit Ctrl V (or Command V) For full set of Excel for Mac shortcuts, go to: www.wallst-training.com click on FREE RESOURCES, scroll down to Technical Resources and download/print the Excel Shortcuts for Mac pdf file

Note that Office 2008 for the Mac is HIGHLY discouraged as there is no VBA and thus, WST macros cannot be installed.
Read More
Go to post added 11 years ago