Forum Search: technical analysis

Re: Diluted Shares Outstanding - Market Cap
Yes - in a change of control context. If you're doing a DCF (even in the context of and M&A or LBO), you would use options EXERCISABLE because DCF is always standalone valuation, which his exercisable and not outstanding options. Options outstanding become exercisable upon change of control - ... Read More
Go to post added 9 years ago
Re: investments in JV or associates
This is a tricky question and the answer is counter-intuitive. In essence, JVs that are treated as equity method (20%-50%) are considered the opposite of Minority Interest / Non-Controlling Interest. The idea is that in theory, one call sell off all the JV stakes and receive cash. Therefore, mar... Read More
Go to post added 9 years ago
Re: Where can I find the other templates for these standalone clips or are these just teasers, must we purchase the advanced package to get the same tutorial as we did with the basic?
Hi, as you mentioned, the Excel templates and/or slide materials referenced in this free package act as a preview of the full package. For a more detailed glimpse at several specific courses, please feel free to sign up for the six-month free trial (head to our webpage at http://wallst-training.com ... Read More
Go to post added 9 years ago
Re: Non-Controlling Interests IAS 10 accounting reclassification
Yes correct, we still treat MI / NCI as NOT part of Equity, therefore in our financial model and valuation analysis, we will reclassify MI / NCI back as part of Liability and make sure Equity does not include MI / NCI. This also applies to US GAAP, not just IFRS, since the same rule impacts US GAAP ... Read More
Go to post added 9 years ago
Re: Gain/Loss on Derivative for Oil & Gas Company
It shouldn't matter. Non-cash gains /losses are typically due to mark to market and go through OCI as they are likely classified as AFS securities and shouldn't change original analysis.
Go to post added 9 years ago
Re: WST Macros Add-In not appearing on toolbar
In Excel for Mac 2016, the menu/ribbon does not show up, but the shortcut keys all work. The natural downside to this is that any functions without shortcut keys cannot be accessed. This is due to Microsoft’s decision to exclude certain code functionality in their latest versions of Excel for M... Read More
X
NOTICE
Trying to get property of non-object
/home/pixelfind/product/html/resources/cache_p/dXNlcl9zZWFyY2g=.php
#54
-0/excel_add_in_instructions-343?single=1913&parent=1910" class="comm_tool fl">Go to post added 9 years ago
Re: Gain/Loss on Derivative for Oil & Gas Company
Historically, we typically do not adjust because it is considered recurring. Exceptions might be one-time shock events, but even then, it depends because chances are their comps will have similar impact. Exceptions apply of course - if one company hedges a lot and one doesn't, then you might want to... Read More
Go to post added 9 years ago
Re: Comparable companies analysis
Please refer to the discussion in your previous post on "Equity value derived from DCF". Based on the phrasing of your question here, we would consider the market cap to be pre-money since it presumably is based on current EPS / Net Income and doesn't incorporate the new money (again, see previous p... Read More
Go to post added 10 years ago
Comparable companies analysis
My subject company is a private one going to IPO. Let's say I have concluded the industry average P/E and am going to calculate subject company's implied market cap. Is this market cap considered pre-money or post-money? Because if that is a post-money market cap a.k.a. enlarged share capital, the o... Read More
Go to post added 10 years ago
Re: Cash
If a true asset sale, then correct, you are only purchasing certain assets and liabilities. Each of those would be valued separately to arrive at "fair" value. The analysis basically becomes build the asset vs. buy the asset. You could also look at it from an TEV perspective based on the nature of t... Read More
Go to post added 10 years ago