Posts by: WST Expert 1
RE: Complex Trading: Diluted s/out for preferred/convertibles?
Preferreds are treated like regular debt unless there are warrants attached (the warrants are treated like options) or if it is convertible. Without going into specifics and nuances, your assessment is not incorrect. Just don't forget to remove the par value portion from the total debt number wh... Read More
Preferreds are treated like regular debt unless there are warrants attached (the warrants are treated like options) or if it is convertible. Without going into specifics and nuances, your assessment is not incorrect. Just don't forget to remove the par value portion from the total debt number wh... Read More
Re: Using References with Inequalities
countif and countifs don't act "normal" when working with dates and as you noted, requires " " side, making a direct cell reference ineffective. You have to add an extra set of parenthesis to make it work: =COUNTIFS($A:$A,">"&B3&"",$A:$A,"<... Read More
countif and countifs don't act "normal" when working with dates and as you noted, requires " " side, making a direct cell reference ineffective. You have to add an extra set of parenthesis to make it work: =COUNTIFS($A:$A,">"&B3&"",$A:$A,"<... Read More
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
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
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
We apologize for the delay in response. It seems as if your post didn't come through to our control panel until now. We are looking into this to see if this is a technical issue on our end.
To respond to your question, what is the book value of the company?