Posts by: WST Expert 1

RE: Complex Trading: Options schedule in K vs bloomberg
1) Options are provided from the 10K. Whenever possible, get your inputs from the source. Bloomberg, like other data vendors, are aggregators. Options are only sometimes provided on 10Q, hence we get it from the 10K because we don't have other updated information to update from. No difference betwee... Read More
Go to post added 11 years ago
Re: WACC : Historical Beta Values
The accepted and widely used definition on Wall Street is: ßL = ßu * [1 + (D/E) * (1 – T) ] Which works out algebraically to the same as the one you listed for Damodaran. In short, this means that the ßL is higher than ßu by a factor equal to D/E ratio (tax-effected) since debt introduces m... Read More
Go to post added 11 years ago
Re: Same stores sales on retail business recovery
The general convention is to look at monthly sales over the same month LAST year - this accounts for seasonality in the business. Your basic logic sounds correct to see if the sales level is back to pre-crisis level. Although, the way you are doing it, why can't you just compare the absolute values ... Read More
Go to post added 11 years ago
Re: WACC : Historical Beta Values
your prior post: Q1: this is the part of the process of picking comparable companies; use the same criteria as those you think are closest to you Q2: it's like mean reversion: in statistics, never mix historical and projections when doing regression, the actual number will distort your results. Thi... Read More
Go to post added 11 years ago
Re: Watermark Help
Unfortunately, there is not a way to do that.
You'll also note that in Page Break Preview mode, shaded cells do not appear shaded as well.
We don't generally recommend working in that view mode.
Go to post added 11 years ago
RE: Deal Comps Analysis: Quick model formatting question
At the end of the day, it doesn't matter. In the Deal Comps, many firms do not input forward projections and such, a different template is used. You can most certainly use our Trading Comps template for Deal Comps. To answer your question about best practices, you are correct, be as clear as p... Read More
Go to post added 11 years ago
Re: Making COUNTIF More Adaptable
One way is to combine concatenate with indirect. Indirect works as follows: assume cell A1's value is the number 10 and cell B2 has a value of "A1" in cell C3, if you have a formula =B2, then it will simply display "A1" since it references cell B2 however, if in cell C3, you do ... Read More
Go to post added 11 years ago
Re: Core Model Enhancements - Tax Schedule
Amortization of Goodwill is not a tax-deductible expense. As such, it is a permanent difference in taxes. So it is not added back in that specific calculation since it does NOT reduce Taxable Income, resulting in higher income taxes since it is not deductible. To answer your direct question, Amort... Read More
Go to post added 11 years ago
RE: Deal Comps Analysis: Quick model formatting question
Yes you can, however, when you update comps regularly, that is too much work. Normally we just show the output.
Go to post added 11 years ago
Re: Advanced Excel for Data Analysis--newer version?
The Excel charting videos are done in 2007.
The Adv Excel for Data Analysis class, while in 2003 is the same as in 2007.
All the keystrokes remain the same.
Any differences (like pivot tables) have a separate video for 2007.
Go to post added 11 years ago