Posts by: WST Expert 1
RE: Complex Trading: When to normalize Qs for calculating LTM?
Please see our Complex Trading Comps online course, under COST Inputs for an example of inputting quarterly information for LTM calculations. The COST Fiscal Year Yr section explains LTM fully, especially when spreading comps with different fiscal year ends.
Please see our Complex Trading Comps online course, under COST Inputs for an example of inputting quarterly information for LTM calculations. The COST Fiscal Year Yr section explains LTM fully, especially when spreading comps with different fiscal year ends.
Re: Hospital Model
Unfortunately at this time, we don't have a training module on hospitals.
Unfortunately at this time, we don't have a training module on hospitals.
RE: Stock Based Compensation
For our comparable company analysis, while all analysts seem to be submitting their EPS figures on a GAAP basis (incl. SBC), it is ambiguous as to whether they submit their EBITDA figures to consensus with or without SBC. So basically one comp has an EBITDA consensus number that is the average of EB... Read More
For our comparable company analysis, while all analysts seem to be submitting their EPS figures on a GAAP basis (incl. SBC), it is ambiguous as to whether they submit their EBITDA figures to consensus with or without SBC. So basically one comp has an EBITDA consensus number that is the average of EB... Read More
Re: LBO "Super Complex Course"
Apologies for the delay as our reporting system was being upgraded.
We have confirmed your previous purchase and Hamilton has approved the upgrade.
Order Package 5 LBO into your shopping cart after logging in.
Please use the following discount code: hlin_approved
Thank you.
Apologies for the delay as our reporting system was being upgraded.
We have confirmed your previous purchase and Hamilton has approved the upgrade.
Order Package 5 LBO into your shopping cart after logging in.
Please use the following discount code: hlin_approved
Thank you.
Re: Clear Content Shortcut or VBA script?
We use the old Excel 2003 menu keystrokes: Alt+E+A+A which is Edit, Clear, All We also use Alt+E+A+F which is Edit, Clear, Formatting We considered creating a macro in our WST macros but decided against it since we were running out of keystrokes and would have to use a Ctrl+Shift+Alt+[letter] whic... Read More
We use the old Excel 2003 menu keystrokes: Alt+E+A+A which is Edit, Clear, All We also use Alt+E+A+F which is Edit, Clear, Formatting We considered creating a macro in our WST macros but decided against it since we were running out of keystrokes and would have to use a Ctrl+Shift+Alt+[letter] whic... Read More
RE: Effective vs marginal tax rate for FCFF
if the marginal tax rate and the effective tax rate are similar, it really doesn't matter. normally it is marginal tax rate for everything, however, b/c this isn't an "incremental" analysis (like a merger), effective tax rate is preferred for FCFF calculations. cash taxes is the term used to ind... Read More
if the marginal tax rate and the effective tax rate are similar, it really doesn't matter. normally it is marginal tax rate for everything, however, b/c this isn't an "incremental" analysis (like a merger), effective tax rate is preferred for FCFF calculations. cash taxes is the term used to ind... Read More
Re: Interest Schedule calcs
Hmm. that looks correct - that's our custom number formatting. what specifically was the ERROR?
Hmm. that looks correct - that's our custom number formatting. what specifically was the ERROR?
Re: Cash Circular
It doesn't count if you're on the first floor or have a balcony right underneath you! However, in all seriousness, we do not advocate jumping out of windows. So, we've got good news and bad news for you. Which do you want first? Always the bad of course. Bad news is that one can have a circular ref... Read More
It doesn't count if you're on the first floor or have a balcony right underneath you! However, in all seriousness, we do not advocate jumping out of windows. So, we've got good news and bad news for you. Which do you want first? Always the bad of course. Bad news is that one can have a circular ref... Read More
RE: Correct benchmark for beta
Yes, generally speaking, use the beta for the national market. But the key is match apples and apples - you must use the appropriate market risk premium to make the beta make sense! So for your Dutch company, use: 1) beta vs. Dutch national benchmark 2) the market risk premium of above benchma... Read More
Yes, generally speaking, use the beta for the national market. But the key is match apples and apples - you must use the appropriate market risk premium to make the beta make sense! So for your Dutch company, use: 1) beta vs. Dutch national benchmark 2) the market risk premium of above benchma... Read More
Well the definition of TBV is book less intangibles. Traditionally that obviously doesn't include a prepaid asset like prepaid rent for instance. So don't minus out the DAC. Remember DAC is purely a GAAP term. Note however that a common valuation metric is price / premiums sort of like enterpris... Well the definition of TBV is book less intangibles. Traditionally that obviously doesn't include a prepaid asset like prepaid rent for instance. So don't minus out the DAC. Remember DAC is purely a GAAP term.
Note however that a common valuation metric is price / premiums sort of like enterprise vale/revenue. Then insurance companies have a premium/surplus restriction. Thus an implied price/ surplus ratio. That surplus is indeed closer to book value less tangibles less DAC and other smaller (usually insignificant items) and so in short, both methods are not unreasonable, just use the right terminology then you are fine. Any shortfall in capital or surplus is reduced one for one in value, not multiplied. Read More