Forum Search: technical analysis

Re: Cost of Equity and Debt
Recall that the WACC analysis is meant to capture the MARGINAL cost of capital for the company. As such, you definitely use MARKET VALUE of equity and debt. In reality, for non-distressed companies, we proxy market value of debt by using book value of debt. Minor, immaterial differences, so no worri... Read More
Go to post added 11 years ago
Complex Trading Comps Analysis
Hi,

For Costco Corporation, there is a tax benefit of $13,895 associated with lower state tax in the fourth quarter and it has mentioned a few times in the 10K. Why don't we need to make any adjustment on the EPS? Thanks.
Go to post added 11 years ago
Re: Complex Trading Comps Analysis
It depends on the reason for the lower state tax. If "normal" and "ordinary course of business", then no need to adjust.
If it is due to a specific one-time item, then perhaps we would adjust.
what is the specific nature of the tax benefit?
Go to post added 11 years ago
Re: Complex Trading Comps Analysis
Here is part of the note to consolidated financial statements from income tax section: "The effective income tax rate on earnings was 31.4% in fiscal 2005, 37% in fiscal 2004, and 37.8% in fiscal 2003. The decrease in the effective income tax rate in fiscal 2005 from fiscal 2004 is primarily... Read More
Go to post added 11 years ago
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: 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
Re: Convertible Debt Adjustment
Sorry, but I realized I have a handful of related, follow-up questions to this as well. Admittedly my understanding of convertibles is somewhat limited, which is the source of most of these questions. (4) This is related to the original question of this post: referring to the Costco 10-Q, pg 26, in... Read More
Go to post added 11 years ago
Re: Convertible Debt Adjustment
1) You would adjust the S/Out by the amount that still has not been converted. We don't remember the numbers off-hand, but it would not be the entire maximum amount of shares. 2) Yes, same for all convertible securities. There's no difference in this context between preferred or debt. The differen... Read More
Go to post added 11 years ago
AD analysis left-field questions
I had a few side/random questions from the accretion dilution analysis. Finance ONLY purchase price equity (& NOT EV), as quick/dirty model/anal? In other words, I would think that financing would FUND EV (if there is debt, that debt would most likely be refinanced/ repaid/retired, or less co... Read More
Go to post added 11 years ago
Re: WMT model question
From the perspective of financial analysis, we don't differentiate the difference between redeemable and non-redeemable. This is an accounting related classification that results in whether or not it is slotted into the Equity account (new rules) or if it is not. As such, the point is that the entit... Read More
Go to post added 11 years ago