Forum Search: technical analysis
RE: Free Cash Flow Tax Adjustment for Depreciation
Keep in mind the bigger picture. You are using book depreciation because the difference between tax and ook depreciation can be thought of as a working capital change which is in change in working capital in fcff calculation. Although technically deferred tax liabilities (which is difference btwn bo... Read More
Keep in mind the bigger picture. You are using book depreciation because the difference between tax and ook depreciation can be thought of as a working capital change which is in change in working capital in fcff calculation. Although technically deferred tax liabilities (which is difference btwn bo... Read More
Technical Question: Excel for PC vs Excel for Mac shortcuts
What are the major differences in Excel for PC vs Excel for Mac shortcuts?
What are the major differences in Excel for PC vs Excel for Mac shortcuts?
Re: Sale Impact on Equity
When the item is sold, sales (or revenue) would technically increase first, thereby affecting equity (up in this case). Then when the COGS for the item is recorded, equity gets affected again (down). Ditto for SG&A and any other related items. Cash and A/R would be affected based on the terms (payme... Read More
When the item is sold, sales (or revenue) would technically increase first, thereby affecting equity (up in this case). Then when the COGS for the item is recorded, equity gets affected again (down). Ditto for SG&A and any other related items. Cash and A/R would be affected based on the terms (payme... Read More
Re: CapitalIQ Shortcuts Override
If you'd like to use the WST Macros keyboard shortcuts while using other add-ins at the same time, we'd recommend disabling their shortcut functionality. You can usually find this in their settings menu. Please see the free guide on our website under About -> Resources -> Technical Resources -> "How... Read More
If you'd like to use the WST Macros keyboard shortcuts while using other add-ins at the same time, we'd recommend disabling their shortcut functionality. You can usually find this in their settings menu. Please see the free guide on our website under About -> Resources -> Technical Resources -> "How... Read More
Zero coupon bond vs. non-interest bearing debt
on Liabilities Exercise on pg311. In the video, the instructor refers to effective method to calculate the expense and record the entry. Why don't we go with the non-interest bearing debt analysis? Since it is a zero-coupon bond, shouldn't it be considered a non-interesting bearing bond? The differe... Read More
on Liabilities Exercise on pg311. In the video, the instructor refers to effective method to calculate the expense and record the entry. Why don't we go with the non-interest bearing debt analysis? Since it is a zero-coupon bond, shouldn't it be considered a non-interesting bearing bond? The differe... Read More
DCF Correct Time Period inputs
Hi WST, I have a not so smart question, let's say I am making a 5 year projection (2018-2022) for DCF analysis to calculate a company's implied stock price. Now, the company just releases its latest financial statements. So should I use the latest financial figures to calculate, say, net debt, an... Read More
Hi WST, I have a not so smart question, let's say I am making a 5 year projection (2018-2022) for DCF analysis to calculate a company's implied stock price. Now, the company just releases its latest financial statements. So should I use the latest financial figures to calculate, say, net debt, an... Read More
Restricted Stock, etc.
Hi, can you tell me which of these should be added to basic shares outstanding when performing comps (not precedents) analysis: RSAs, PSUs, PSAs, Restricted Stock, SARs exercisable/outstanding, Directors Shares? Thanks so much!
Hi, can you tell me which of these should be added to basic shares outstanding when performing comps (not precedents) analysis: RSAs, PSUs, PSAs, Restricted Stock, SARs exercisable/outstanding, Directors Shares? Thanks so much!
Re: Comps when valuing a company for M&A
A trading comps analysis is typically always from the perspective of a going concern and not a take private. As such, we would recommend to always use options exercisable and not options outstanding for spreading comps. The same applies for DCF - even though you know that the very reason you're doin... Read More
A trading comps analysis is typically always from the perspective of a going concern and not a take private. As such, we would recommend to always use options exercisable and not options outstanding for spreading comps. The same applies for DCF - even though you know that the very reason you're doin... Read More
Comps when valuing a company for M&A
Hi, thanks again for answering all of our questions! When spreading comps to perform a comps analysis (not precedents) for the purpose of valuing a company for a take-private, should you still use options exercisable instead of outstanding (even though you would expect all of the options outstanding... Read More
Hi, thanks again for answering all of our questions! When spreading comps to perform a comps analysis (not precedents) for the purpose of valuing a company for a take-private, should you still use options exercisable instead of outstanding (even though you would expect all of the options outstanding... Read More
Re an acc/dil analysis: Let’s say you wanted to calculate the historical exchange ratio between a company whose stock trades in Europe and a US company. European company is buying US company. Is the technically correct way to calculate that historical exchange ratio, say over the past 5 yea... Re an acc/dil analysis: Let’s say you wanted to calculate the historical exchange ratio between a company whose stock trades in Europe and a US company. European company is buying US company.
Is the technically correct way to calculate that historical exchange ratio, say over the past 5 years, to be: US company’s stock price / [ European company’s stock price in British Pounds * FX rate for each day]? at the end of the day, if the british company is buying the US company, US company’s shareholders are receiving stock in a foreign company, and so should factor in the impact of FX risk on their shares.
Does this sound right to you? Read More