Posts by: WST Expert 1
RE: Complex Trading Comps: Stock comp transition under 123(R)
That footnote is merely informative => adoption of 123R has not yet been complete nor mandatory as of yet; the deadline keeps getting pushed back. In this case, JCP has chosen to adopt 123R and thus, this would be an ongoing expense that will reduce profitability. Because it is ongoing and recurr... Read More
That footnote is merely informative => adoption of 123R has not yet been complete nor mandatory as of yet; the deadline keeps getting pushed back. In this case, JCP has chosen to adopt 123R and thus, this would be an ongoing expense that will reduce profitability. Because it is ongoing and recurr... Read More
Re: DTL creation
Apologies, but this topic is not covered in our video classes as it is beyond the scope of what we intended to cover. The reason is that, in our observation, when we do cover this in our public seminars, we end up confusing people more. So we removed it from our curriculum and add it back only on a... Read More
Apologies, but this topic is not covered in our video classes as it is beyond the scope of what we intended to cover. The reason is that, in our observation, when we do cover this in our public seminars, we end up confusing people more. So we removed it from our curriculum and add it back only on a... Read More
Re: Estimated Taxes
The concept of "cash taxes" in FCFF calculation is not to get actual cash taxes paid. We normally just take your tax rate * EBIT = NOPAT. Please see our Corporate Valuation course and DCF Modeilng for more detail. DTA and DTL is not considered "operations" in the sense that worki... Read More
The concept of "cash taxes" in FCFF calculation is not to get actual cash taxes paid. We normally just take your tax rate * EBIT = NOPAT. Please see our Corporate Valuation course and DCF Modeilng for more detail. DTA and DTL is not considered "operations" in the sense that worki... Read More
RE: Complex Trading Comps Analysis: Convertibles of COSTCO
No, upon conversion, the holder does NOT pay $22 per share. The $22 is simply used to determine the INITIAL value of the convertible bond/note when priced, so in short, the $22 is no longer required at this point. Don't confuse convertibles with options and warrants!
No, upon conversion, the holder does NOT pay $22 per share. The $22 is simply used to determine the INITIAL value of the convertible bond/note when priced, so in short, the $22 is no longer required at this point. Don't confuse convertibles with options and warrants!
Re: Share Based Compensation Forecast
The official rules say to use Black-Scholes which takes into account numerous factors that affect option pricing other than price differential. You would have to have a model for Black-Scholes. We think that is unncessarily complex and non-value added. As a shortcut we would suggest to either calcu... Read More
The official rules say to use Black-Scholes which takes into account numerous factors that affect option pricing other than price differential. You would have to have a model for Black-Scholes. We think that is unncessarily complex and non-value added. As a shortcut we would suggest to either calcu... Read More
Re: Revolver, ST. Debt or LT Debt?
revolver is usually classified as short term debt. truth be told, the company's classification isn't really all that important. the key is to read the revolver credit agreement and ascertain the following: - length of revolver: usually 2 years or so (can be 4-6 years if issued in conjunction with a ... Read More
revolver is usually classified as short term debt. truth be told, the company's classification isn't really all that important. the key is to read the revolver credit agreement and ascertain the following: - length of revolver: usually 2 years or so (can be 4-6 years if issued in conjunction with a ... Read More
Re: Insurance financial modeling
Thank you for pointing this out. At first glance, you are correct that it does not sweep through. We will revert with an updated correct formula once our insurance expert has a change to revise.
Thank you for pointing this out. At first glance, you are correct that it does not sweep through. We will revert with an updated correct formula once our insurance expert has a change to revise.
Re: WST Macro Problem
Step 1: disable capiq shortcuts: Go to capiq menu in excel, select settings, look for general at the bottom then uncheck use capiq shortcuts and click on. If you get an msg about online access ignore it. It will be disabled Step 2: reload WST macros: go to tools add-ins (alt + t+i) and uncheck WST ... Read More
Step 1: disable capiq shortcuts: Go to capiq menu in excel, select settings, look for general at the bottom then uncheck use capiq shortcuts and click on. If you get an msg about online access ignore it. It will be disabled Step 2: reload WST macros: go to tools add-ins (alt + t+i) and uncheck WST ... Read More
[quote="dipeshpatel01":3i9a37z5]Yes you are right. It was not installed properly. After downloading the .xla, I opened Excel 2013 and then straight on to "Options", "Add-Ins", etc. However, what I did not do after downloading was to make Excel "recognize" t... [quote="dipeshpatel01":3i9a37z5]Yes you are right. It was not installed properly. After downloading the .xla, I opened Excel 2013 and then straight on to "Options", "Add-Ins", etc. However, what I did not do after downloading was to make Excel "recognize" the .xla file. I double clicked on the .xla file, authorized the pop-up to open with Excel, and lastly, "Enable Macros".
Thank you for your help.[/quote:3i9a37z5]
The correct installation video can be found here: http://youtu.be/L06CUjovVBA
In other words, here are the steps:
1. Download the ZIP containing the .xla
2. Extract the .xla to any folder of your choice (e.g., Desktop, temporarily)
3. Copy the .xla file (CTRL+C)
4. Go to "Options" -> "Add-Ins" in Excel
5. Click "Browse..." and right click in this default folder that opens up, then select Paste
6. Click "OK"
7. Ensure that the WST Macros appears, with the checked checkbox, and click "OK"
From here, restart Excel and verify that WST shows up in your Add-Ins menu going forward.
Please let us know if this resolves the issue for you. Thanks! Read More