Posts by: WST Expert 1

Re: TGT Debt for ROC
The correct calculation of ROC for TGT is:
=(2,408+463) / (9,872+14,205) = 11.9%

We're not sure where you're getting 8872?
Go to post added 10 years ago
Re: Material non-public information
Unfortunately, we will have to defer to securities lawyers. Usually, the regulators and the courts will look at everything in context and we wouldn't be in a position to speculate. The short answer to everything is that you are not allowed to trade or act on the information and the journalist would ... Read More
Go to post added 10 years ago
Re: Straight Line Instead of Effective Interest?
Straight line approach is fine.
Go to post added 10 years ago
Re: Bonds Issued at a discount
Thank you for pointing out the discrepancy. In this case, please rely on the video as the slides are not correct. Correct slide (in the videos) should have been presented as: Semi-annual interest payment: Interest Expense* 36,815 Cash 30,000 Bond disco... Read More
Go to post added 10 years ago
Re: Marketable Securities
1) Trading: Slide 202: Unrealized gains or losses are reflected in income (i.e. on the IS) AFS: Slide 204: Unrealized gains or losses are reflected as part of OCI (i.e. NO IS impact) HTM: no impact until sold since not marked to market Neither have a CF statement impact unless actual interest r... Read More
Go to post added 10 years ago
Re: 2005A EBIT
EBIT figures should be pulling in from Adjusted EBIT (not unadjusted EBIT). I.E. the LTM figures from the template should be calculated off Adjusted EBIT, which is exactly what the template already does. Keep in mind Costco has an Aug year end vs Jan year end, and thus requires a separate calculat... Read More
Go to post added 10 years ago
Re: Capitalization of interest
Capitalized interest generally applies when you have a construction loan for building a real asset, such a factory or building. Accounting rules stipulate that the interest on such a construction loan is NOT accounted for as interest expense, but rather, as part of the cost basis. For instance, a on... Read More
Go to post added 10 years ago
Re: Add-in on Excel Workbook
Which version of Excel are you running on the Surface? To our understanding, the installation instructions for one Excel/OS version should be the same regardless of the device being used.
Go to post added 10 years ago
Re: Mervyn enterprise value
Please see reply to the previous post above: Marshall's Cash In short, the A/R would be excess working capital that the Seller can monetize and does not have to go along with the overall sale of the company. In other words, the $1,650 purchase price would have specified a certain level of working... Read More
Go to post added 10 years ago
Re: additional adjustments
$18 million tax adjustments:
As you can see, there are tax adjustments every year and therefore, we don't adjust since they are considering recurring.
Go to post added 10 years ago