Posts by: WST Expert 1
RE: Deal Comps Analysis: Quick model formatting question
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: Advanced Excel for Data Analysis--newer version?
The Excel charting videos are done in 2007.
The Adv Excel for Data Analysis class, while in 2003 is the same as in 2007.
All the keystrokes remain the same.
Any differences (like pivot tables) have a separate video for 2007.
The Excel charting videos are done in 2007.
The Adv Excel for Data Analysis class, while in 2003 is the same as in 2007.
All the keystrokes remain the same.
Any differences (like pivot tables) have a separate video for 2007.
Re: Core Model Enhancements - Tax Schedule
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).
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).
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
Amortization of Goodwill is not a tax-deductible expense. As such, it is a permanent difference in taxes. So it is not added back in that specific calculation since it does NOT reduce Taxable Income, resulting in higher income taxes since it is not deductible. To answer your direct question, Amort... Amortization of Goodwill is not a tax-deductible expense. As such, it is a permanent difference in taxes. So it is not added back in that specific calculation since it does NOT reduce Taxable Income, resulting in higher income taxes since it is not deductible.
To answer your direct question, Amortization of Intangibles is NOT added back in that specific calculation because it DOES reduce Taxable Income and thus, one pays lower taxes. So really, the adjustment is for Goodwill (usually zero amortization anyway), not for other intangibles. Read More