Posts by: WST Expert 1
Re: simple data table question
Sounds like you hit wrong keystroke. Our WST macros shortcut Ctrl+Alt+Y makes formatting of a cell into "Year "; you were probably aiming for Ctrl+shift+Y for our yellow shading macro. Simply select your data and change formatting: Ctrl+Shift+M for our "money" macro, or standard... Read More
Sounds like you hit wrong keystroke. Our WST macros shortcut Ctrl+Alt+Y makes formatting of a cell into "Year "; you were probably aiming for Ctrl+shift+Y for our yellow shading macro. Simply select your data and change formatting: Ctrl+Shift+M for our "money" macro, or standard... Read More
DCF EBITDA multiple approach
This is covered in detail in our Corporate Valuation and Basic Financial Modeling classes - last year's EBITDA (called Terminal Year EBITDA) times EBITDA exit multiple in fact gives you "Total Enterprise Value at the end of the Terminal Year". This is known as Terminal Value which indeed IS Enterpri... Read More
This is covered in detail in our Corporate Valuation and Basic Financial Modeling classes - last year's EBITDA (called Terminal Year EBITDA) times EBITDA exit multiple in fact gives you "Total Enterprise Value at the end of the Terminal Year". This is known as Terminal Value which indeed IS Enterpri... Read More
Re: Forex Gains (losses)
Our guess, without researching accounting standards is no, since book value isn't marked to market.
Our guess, without researching accounting standards is no, since book value isn't marked to market.
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
Don't forget, for the most part, you still you have to be GAAP compliant. So, while you have discretion, you can't just arbitrarily apply judgment.