Posts by: WST Expert 1
Re: Array formula
Yes, any mathematical operator can be applied to the array function. Recall the array just allows you to simplify repetitive actions that you are doing a bunch of cells in Excel. So for instance taking the same example: Cell V11 : { =PRODUCT(1+T11:T32)-1} instead of -1 at the end you could do your ... Read More
Yes, any mathematical operator can be applied to the array function. Recall the array just allows you to simplify repetitive actions that you are doing a bunch of cells in Excel. So for instance taking the same example: Cell V11 : { =PRODUCT(1+T11:T32)-1} instead of -1 at the end you could do your ... Read More
Re: Current Liabilities - Taxes
Not to throw on the sales pitch, but this is covered in our Enhancements, Part II online course. Essentially deferred tax assets primarily arise thru NOLs and deferred tax liabilities arise through the differences between book and tax depreciation. Take a look: http://www.wstselfstudy.com/package3-1.html Read More
Not to throw on the sales pitch, but this is covered in our Enhancements, Part II online course. Essentially deferred tax assets primarily arise thru NOLs and deferred tax liabilities arise through the differences between book and tax depreciation. Take a look: http://www.wstselfstudy.com/package3-1.html Read More
Re: GAAP or cash
if your projections need to be solid, why are you using analyst projections?
LBO analyses are primarily dependent on sensitivity analysis and case scenarios, particularly worse case scenarios and building data tables to see debt paydown and IRRs under stressful revenue and cash flow assumptions.
if your projections need to be solid, why are you using analyst projections?
LBO analyses are primarily dependent on sensitivity analysis and case scenarios, particularly worse case scenarios and building data tables to see debt paydown and IRRs under stressful revenue and cash flow assumptions.
Re: Cannot FULLY use WSTMacros3.4.2.xla on Excel 2013
Unfortunately, that is still not the correct way to install the macros.
please go here:
http://www.wallst-training.com/about/resources.html
and click on the second link for video instructions.
Unfortunately, that is still not the correct way to install the macros.
please go here:
http://www.wallst-training.com/about/resources.html
and click on the second link for video instructions.
RE: How do you factor net operating losses (NOLs) in valuation?
The way we would account for NOLs in a DCF analysis is to reduce the "cash taxes" paid, thereby increasing Free Cash Flow to Firm and thus, increasing the PV of FCFF in the 4-5 year projection period. If there are significant NOLs still remaining after that, we would treat the PV of the tax shields ... Read More
The way we would account for NOLs in a DCF analysis is to reduce the "cash taxes" paid, thereby increasing Free Cash Flow to Firm and thus, increasing the PV of FCFF in the 4-5 year projection period. If there are significant NOLs still remaining after that, we would treat the PV of the tax shields ... Read More
RE: How to project minority interest?
This would be guided by Accounting financial statements (ie FASB/IFRS), meaning there is a clear black and white line, no gray line, as with many finance questions. Net Income is ALWAYS after the effects of Minority Interest. EPS is to be calculated off Net Income to Common Shareholders (so after Pr... Read More
This would be guided by Accounting financial statements (ie FASB/IFRS), meaning there is a clear black and white line, no gray line, as with many finance questions. Net Income is ALWAYS after the effects of Minority Interest. EPS is to be calculated off Net Income to Common Shareholders (so after Pr... Read More
RE: AFM Enhancements: Printing Set Up
We do have courses that consolidate a number of entities/divisions. This is our Segment Build-up class which is currently not in our online suite of courses (in the future it will be). The closest we have right now to that is our Super-Advanced M&A course in Package 5 of our online courses, whic... Read More
We do have courses that consolidate a number of entities/divisions. This is our Segment Build-up class which is currently not in our online suite of courses (in the future it will be). The closest we have right now to that is our Super-Advanced M&A course in Package 5 of our online courses, whic... Read More
Re: Debt Extinguishment - Equity offered
1) No, you do not need to add another line to CFS. Recall, because you are putting it in Trache 2 repayment/borrowing, it is already incorporated into the mandatory repayment line (net change in repayments) - row 11 on debt sweep. This is already wrapped into the change in debt subtotals! 2) Our in... Read More
1) No, you do not need to add another line to CFS. Recall, because you are putting it in Trache 2 repayment/borrowing, it is already incorporated into the mandatory repayment line (net change in repayments) - row 11 on debt sweep. This is already wrapped into the change in debt subtotals! 2) Our in... Read More
Re: GAAP or cash
Analyst projections are utilized as a reference point. If you're doing an LBO, you must confer with management. But again, LBO sensitivity is more important. your GAAP historicals are supposed to be adjusted anyways. Truth be told, these are all fairly basic questions. Please take our Complex Trad... Read More
Analyst projections are utilized as a reference point. If you're doing an LBO, you must confer with management. But again, LBO sensitivity is more important. your GAAP historicals are supposed to be adjusted anyways. Truth be told, these are all fairly basic questions. Please take our Complex Trad... Read More
Glad you liked the course! Please go to File => Page Setup (Alt + F+U) => Sheet and uncheck Row and column headings and you are all set!