Forum Search: technical analysis
Diluted Shares Outstanding for Equity Value
I have got a question related to Diluted Shares Outstanding that you may be able to help me with. Why should we include the diluted figures when calculating Market Equity Value for Trading Multiples analysis? Because my interpretation is that when these options or covertibles were excercised the... Read More
I have got a question related to Diluted Shares Outstanding that you may be able to help me with. Why should we include the diluted figures when calculating Market Equity Value for Trading Multiples analysis? Because my interpretation is that when these options or covertibles were excercised the... Read More
Levered vs. unlevered beta for cost of equity
My question relates to the appropriate use of levered vs. unlevered beta in deriving the cost of equity in a free cash flow to the firm and free cash flow to equity analysis. I have read conflicting information on the subject. Is it appropriate to use unlevered beta to calculate the cost of ... Read More
My question relates to the appropriate use of levered vs. unlevered beta in deriving the cost of equity in a free cash flow to the firm and free cash flow to equity analysis. I have read conflicting information on the subject. Is it appropriate to use unlevered beta to calculate the cost of ... Read More
Stock Based Compensation
I have some questions relating to stock based compensation expense. I am doing a valuation of a company using DCF and Comparable Company analyses and SBC expense has raised its ugly head. For our comparable company analysis, while all analysts seem to be submitting their EPS figures on a GAAP bas... Read More
I have some questions relating to stock based compensation expense. I am doing a valuation of a company using DCF and Comparable Company analyses and SBC expense has raised its ugly head. For our comparable company analysis, while all analysts seem to be submitting their EPS figures on a GAAP bas... Read More
Adjusting historical financials for non-recurring/XO items
I have a technical question related to the impact on taxes when adjusting historical financials for non-recurring/extraordinary items that you may be able to help me with. Let’s take a generic example: EBIT => $ 300 Interest => ($ 1000) Pre-Tax income => ($ 700) Taxes => $ 200 ... Read More
I have a technical question related to the impact on taxes when adjusting historical financials for non-recurring/extraordinary items that you may be able to help me with. Let’s take a generic example: EBIT => $ 300 Interest => ($ 1000) Pre-Tax income => ($ 700) Taxes => $ 200 ... Read More
DCF Terminal Value Discount Period
Hope you’re well. got a technical question for you: re the DCF: should the terminal value as per perpetuity growth rate method be discounted back at the same time period as the terminal multiple approach? Ie, doesn’t FCF * (1+g) / (r-g) = present value of terminal value, as of 1 year after the ... Read More
Hope you’re well. got a technical question for you: re the DCF: should the terminal value as per perpetuity growth rate method be discounted back at the same time period as the terminal multiple approach? Ie, doesn’t FCF * (1+g) / (r-g) = present value of terminal value, as of 1 year after the ... Read More
RE: lookup vs pivot table
this works best with a pivot table or custom built arrays
for more information see our advanced excel for data analysis class in our online courses at www.wstselfstudy.com
this works best with a pivot table or custom built arrays
for more information see our advanced excel for data analysis class in our online courses at www.wstselfstudy.com
RE: vlookup question
Yes - create a legend - a key. Then use vlookup to grab it in.
Let us know if you have questions on vlookup- it is covered in our advanced excel for data analysis class.
Yes - create a legend - a key. Then use vlookup to grab it in.
Let us know if you have questions on vlookup- it is covered in our advanced excel for data analysis class.
RE: Pesky Technical Question
1) when you say "self-fill", what exactly do you mean? do you enter a cell and when hitting ENTER, another cell auto-fills? or are you talking about the difference between Ctrl+R and Ctrl+Shift+Alt+R on our macros else, we don't know what you are referring to! 2) usually forma... Read More
1) when you say "self-fill", what exactly do you mean? do you enter a cell and when hitting ENTER, another cell auto-fills? or are you talking about the difference between Ctrl+R and Ctrl+Shift+Alt+R on our macros else, we don't know what you are referring to! 2) usually forma... Read More
RE: Minority Interest in LBO Model
Your question is a great one! Minority Interest treatment is summarized as follows: 1) In standalone valuation context, INCLUDE MI as part of TEV (Total Enterprise Value) because it is considered a form of capital since greater than 50% ownership forces consolidation 2) In credit analysis (... Read More
Your question is a great one! Minority Interest treatment is summarized as follows: 1) In standalone valuation context, INCLUDE MI as part of TEV (Total Enterprise Value) because it is considered a form of capital since greater than 50% ownership forces consolidation 2) In credit analysis (... Read More
In the context of an accretion/dilution analysis, got a quick question for you: is it valid to calculate amortization of [purchase price in excess of net tangible book value] as: = [ [ [Equity purchase price in an M&A transaction ] – [book value of equity – goodwill – intangible assets]... In the context of an accretion/dilution analysis, got a quick question for you: is it valid to calculate amortization of [purchase price in excess of net tangible book value] as:
= [ [ [Equity purchase price in an M&A transaction ] – [book value of equity – goodwill – intangible assets] ] * % of the excess that is allocated to intangibles ] / [number of amortization years]
Just want to make sure I’m looking at it the right way. Read More