Posts by: WST Expert 1
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
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
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
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
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
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
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.
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.
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
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
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
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
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
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
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.
Yes you can, however, when you update comps regularly, that is too much work. Normally we just show the output.
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.
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.
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... 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 between public vs deal comps.
2) Correct, you can use a variety of data vendors to accomplish this. In our learning modules, we are data vendor-independent so it is hard coded. However, if you or your firm subscribes to such a data vendor, you would link it in. Read More