Forum Search: technical analysis

Exchange Ratio in Accretion Dilution
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... Read More
Go to post added 10 years ago
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
Go to post added 10 years ago
Technical Question: Excel for PC vs Excel for Mac shortcuts
What are the major differences in Excel for PC vs Excel for Mac shortcuts?
Go to post added 10 years ago
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
Go to post added 3 years ago
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
Go to post added 3 years ago
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
Go to post added 5 years ago
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!
Go to post added 6 years ago
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
Go to post added 6 years ago
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
Go to post added 6 years ago
Formatting Cells D26 through I26
Hi,
So in comparing my unformatted workbook to the already completed formatted workboook, I noticed that cells D26 through I26 multiplied profit by the mutiple in C12 rather than C26. Should I use C12 instead when creating the scenario analysis?
Go to post added 6 years ago
1 2 3 ...23Next