Posts by: WST Expert 1
Re: Distressed Credit Overview - Valuation questions
1) You're overthinking it. Most of these will be clarified by reading the covenants in the credit agreements of each. It is impossible to place a generalizing bucket explanation since each debt is different. This is covered extensively in our Credit Agreements & Covenants course (not yet online ... Read More
1) You're overthinking it. Most of these will be clarified by reading the covenants in the credit agreements of each. It is impossible to place a generalizing bucket explanation since each debt is different. This is covered extensively in our Credit Agreements & Covenants course (not yet online ... Read More
Re: Modeling 'Names' used in IB/PE - Question
First step is to understanding Accounting - the "language of finance". Then you need to understand basics of finance and valuation, followed by financial modeling. Go here to learn more about what is required to succeed: http://www.wallst-training.com/self-study/tracks.html Read More
First step is to understanding Accounting - the "language of finance". Then you need to understand basics of finance and valuation, followed by financial modeling. Go here to learn more about what is required to succeed: http://www.wallst-training.com/self-study/tracks.html Read More
RE: Complex Trading Comps Analysis: Fair Value of Debt
Yes, in theory, that is correct. However, as explained in our Finance 101 video in our WACC calculation, for non-distressed, going concerns, the difference between book value and market value of debt is not that large and thus, book value is used because people get lazy to get on bloomberg and look ... Read More
Yes, in theory, that is correct. However, as explained in our Finance 101 video in our WACC calculation, for non-distressed, going concerns, the difference between book value and market value of debt is not that large and thus, book value is used because people get lazy to get on bloomberg and look ... Read More
Re: Merger modeling - Purchase price allocation
No particular reason. We want to say, allocate the book value portion and whatever is left is allocated based on whatever %age we chose.
No particular reason. We want to say, allocate the book value portion and whatever is left is allocated based on whatever %age we chose.
Re: Merger modeling - Merger BS
We are confused by your question. We checked with Hamilton and he is also confused. OBSERVATION; Target BS didn't have any GW or intangibles for us to subtract!!! If it did, we would have subtracted like in the Complex LBO class!!!!! We didn't go and create a new line item on Target BS for GW or in... Read More
We are confused by your question. We checked with Hamilton and he is also confused. OBSERVATION; Target BS didn't have any GW or intangibles for us to subtract!!! If it did, we would have subtracted like in the Complex LBO class!!!!! We didn't go and create a new line item on Target BS for GW or in... Read More
Re: Estimated Taxes
Yes, correct. Now, if the company generates additional NOLs in your projected periods, then don't forget to increase NOL amount by that amount. Obviously at that point, no cash taxes since no profit (Taxable Income). And DTA up if NOL up.
Yes, correct. Now, if the company generates additional NOLs in your projected periods, then don't forget to increase NOL amount by that amount. Obviously at that point, no cash taxes since no profit (Taxable Income). And DTA up if NOL up.
Re: Cannot FULLY use WSTMacros3.4.2.xla on Excel 2013
[quote="dipeshpatel01":3i9a37z5]Yes you are right. It was not installed properly. After downloading the .xla, I opened Excel 2013 and then straight on to "Options", "Add-Ins", etc. However, what I did not do after downloading was to make Excel "recognize" t... Read More
[quote="dipeshpatel01":3i9a37z5]Yes you are right. It was not installed properly. After downloading the .xla, I opened Excel 2013 and then straight on to "Options", "Add-Ins", etc. However, what I did not do after downloading was to make Excel "recognize" t... Read More
RE: Complex Trading Comps: Stock comp transition under 123(R)
That footnote is merely informative => adoption of 123R has not yet been complete nor mandatory as of yet; the deadline keeps getting pushed back. In this case, JCP has chosen to adopt 123R and thus, this would be an ongoing expense that will reduce profitability. Because it is ongoing and recurr... Read More
That footnote is merely informative => adoption of 123R has not yet been complete nor mandatory as of yet; the deadline keeps getting pushed back. In this case, JCP has chosen to adopt 123R and thus, this would be an ongoing expense that will reduce profitability. Because it is ongoing and recurr... Read More
Re: DTL creation
Apologies, but this topic is not covered in our video classes as it is beyond the scope of what we intended to cover. The reason is that, in our observation, when we do cover this in our public seminars, we end up confusing people more. So we removed it from our curriculum and add it back only on a... Read More
Apologies, but this topic is not covered in our video classes as it is beyond the scope of what we intended to cover. The reason is that, in our observation, when we do cover this in our public seminars, we end up confusing people more. So we removed it from our curriculum and add it back only on a... Read More
You are referring to modeling out NOL (net operating losses). The basic idea is that if a company has, say $100 of NOLs that can be carried forward to deduct against future Taxable Income, this will lower future taxes. For instance, say that $100 NOL company makes $60 next year, and then $120 the ye... You are referring to modeling out NOL (net operating losses). The basic idea is that if a company has, say $100 of NOLs that can be carried forward to deduct against future Taxable Income, this will lower future taxes. For instance, say that $100 NOL company makes $60 next year, and then $120 the year after, it would pay $0 (zero) in taxes next year, since all of the $60 would get removed due to the $100 existing NOL balance, with $40 NOL left. Thus, the year after, Taxable Income gets reduced from $120 to $80 (the remaining $40 NOL offsetting the income) and the company only pays taxes on $80 of income.
Thus, your easiest bet is to set up a reconciliation schedule that goes from Pre-Tax Income (GAAP) minus any use of NOL to get Taxable Income. Actual taxes are paid off Taxable Income. If an NOL is used up, the Deferred Tax Asset on the balance sheet goes down. The dynamic part is that if Pre-Tax Income is negative (made another loss), the NOL balance increases and so does Deferred Tax Assets. Don't forget, DTA is the amount of NOL used or generated x statutory tax rate.
Your reference to differences in D&A (straight line for GAAP and accelerated for tax) is regarding Deferred Tax Liabilities and you are correct in that it is not related to DTA and NOLs!
For more information, check out our Enhancements Part 2 course that focuses on modeilng out dynamic and robust tax schedule:
www.wstselfstudy.com/programs.html and click on package 3: Advanced Financial Modeling or go here directly:
http://www.wstselfstudy.com/package3-1.html Read More