Posts by: WST Expert 1
RE: Deal Comps Analysis: Deal Info Source?
Yes you can, however, when you update comps regularly, that is too much work. Normally we just show the output.
Yes you can, however, when you update comps regularly, that is too much work. Normally we just show the output.
Re: Core Model Enhancements - Tax Schedule
Yes, since we are defining both as non-tax-deductible, that is correct, they should both have the same treatment. However, MOST of the time, analysts do not adjust for non-tax-deductible amortization of other intangibles and the convention in calculating GAAP taxes (albeit wrong) is to ONLY include ... Read More
Yes, since we are defining both as non-tax-deductible, that is correct, they should both have the same treatment. However, MOST of the time, analysts do not adjust for non-tax-deductible amortization of other intangibles and the convention in calculating GAAP taxes (albeit wrong) is to ONLY include ... Read More
Re: Advanced Excel for Data Analysis--newer version?
Apologies, you are correct.
We did not include 2007 version for Regression.
This is covered in 2007 version in the Charting class, and is further expanded.
Apologies for confusion and inconvenience.
Apologies, you are correct.
We did not include 2007 version for Regression.
This is covered in 2007 version in the Charting class, and is further expanded.
Apologies for confusion and inconvenience.
RE: Deal Comps Analysis: Deal Info Source?
the .txt files were Press Releases, correct.
the .txt files were Press Releases, correct.
Re: Displaying Color Info
We aren't sure there's a way to utilize HSL color codes. What we've done in the past to get around this type of situation is to have a separate table designating the "rank" of each title. Then, do a vlookup based on the title to assign the rank and conditional formatting and sorting can be... Read More
We aren't sure there's a way to utilize HSL color codes. What we've done in the past to get around this type of situation is to have a separate table designating the "rank" of each title. Then, do a vlookup based on the title to assign the rank and conditional formatting and sorting can be... Read More
RE: Corporate Valuation: capital lease
Correct points and observations but operating leases are also tax deductible. Of course there is the whole timing difference of depreciation and interest but putting that aside, the more significant figure is the entire amount that is off balance sheet vs on balance sheet. Keep in mind rating agneci... Read More
Correct points and observations but operating leases are also tax deductible. Of course there is the whole timing difference of depreciation and interest but putting that aside, the more significant figure is the entire amount that is off balance sheet vs on balance sheet. Keep in mind rating agneci... Read More
Re: WACC : Historical Beta Values
The defacto source is from Bloomberg and spreading current credit yields over treasuries to obtain premiums. Use function FOMC (Fair Open Market Curve) and select the desired ratings. The desired ratings is based on the approximate leverage statistics of your company being analyzed. The only subject... Read More
The defacto source is from Bloomberg and spreading current credit yields over treasuries to obtain premiums. Use function FOMC (Fair Open Market Curve) and select the desired ratings. The desired ratings is based on the approximate leverage statistics of your company being analyzed. The only subject... Read More
Re: Displaying Color Info
No problem. That's what we're here for.
No problem. That's what we're here for.
RE: Pesky Technical Question
Forget excel. Try ctrl+shift+c for our percent macro formatting.
Forget excel. Try ctrl+shift+c for our percent macro formatting.
The add-back to row 12 is to increase Taxable Income (for tax purposes) to end up paying higher taxes since you don't get the deduct (as defined in the notes, non-tax deductible items added back).