Posts by: WST Expert 1
Re: WMT model question
From the perspective of financial analysis, we don't differentiate the difference between redeemable and non-redeemable. This is an accounting related classification that results in whether or not it is slotted into the Equity account (new rules) or if it is not. As such, the point is that the entit... Read More
From the perspective of financial analysis, we don't differentiate the difference between redeemable and non-redeemable. This is an accounting related classification that results in whether or not it is slotted into the Equity account (new rules) or if it is not. As such, the point is that the entit... 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
Merger Modeling Basics: Synergies and Cash PE question
As this is a quick and dirty analysis, goodwill amortization (usually zero) and any tax deducts (i.e. 338(h)(10) elections) are based on purchase price of equity and as such are not included in this short analysis. Don't think too much into this analysis - the concepts are discussed in the M&A D... Read More
As this is a quick and dirty analysis, goodwill amortization (usually zero) and any tax deducts (i.e. 338(h)(10) elections) are based on purchase price of equity and as such are not included in this short analysis. Don't think too much into this analysis - the concepts are discussed in the M&A D... Read More
Re: LBO - Quick & Dirty - for a early stage investment
1) Normally, TEV is a multiple of EBITDA. Sounds like this is some sort of project finance deal, and if you want to set TEV as the maximum debt in Year 2, then fine, but then you are saying the Equity is worth zero. 2) Correct logic. Normally, we build out our cash flow model and debt credit ratios ... Read More
1) Normally, TEV is a multiple of EBITDA. Sounds like this is some sort of project finance deal, and if you want to set TEV as the maximum debt in Year 2, then fine, but then you are saying the Equity is worth zero. 2) Correct logic. Normally, we build out our cash flow model and debt credit ratios ... Read More
Re: data table
Apologies for the delay in responding. please see response to your other post. Thank you.
Apologies for the delay in responding. please see response to your other post. Thank you.
Re: AD analysis left-field questions
1) Yes, generally, the debt is assumed or refinanced and as such, only the Equity portion is financed (ie 50/50). 2) Always use normalized figures; please clarify your question. 3) Tax rate is usually the marginal statutory tax rate, correct. 4) Similarly, interest rate would be the marginal cost... Read More
1) Yes, generally, the debt is assumed or refinanced and as such, only the Equity portion is financed (ie 50/50). 2) Always use normalized figures; please clarify your question. 3) Tax rate is usually the marginal statutory tax rate, correct. 4) Similarly, interest rate would be the marginal cost... Read More
Re: Macro error: compile error in hidden module: thiswork
Hi David,
We're unable to reproduce this issue on our Mac machines. Are you by any chance in the NYC area? If so, we would be open to meet up and troubleshoot directly on your computer to see what's going on.
Hi David,
We're unable to reproduce this issue on our Mac machines. Are you by any chance in the NYC area? If so, we would be open to meet up and troubleshoot directly on your computer to see what's going on.
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: Company Overview: Typo $3.34 not $3.33
Please note this applies to our WST Self-Study courses.
Please note this applies to our WST Self-Study courses.
Our guess, without researching accounting standards is no, since book value isn't marked to market.