Posts by: WST Expert 1

Re: Question on Calculating EBITDA for Healthcare companies
To clarify on #3, old rules stated IPRD is expensed so its a merger adjustment to opening BS and as such, never hits future IS. So ppl generally like making changes to reverse new accounting rules until is 100% accepted by entire finance community and again, calculating normalized EBITDA.
Go to post added 11 years ago
Re: WACC for a Private Equity Firm
You bring up a good point; however, if you're investment horizon is three years, then you would compare the "IRR" of the investment against the private equity firm's cost of capital to evaluate the "invest or not" decision. The concept of WACC and using 10-yr UST (originally 20-... Read More
Go to post added 11 years ago
RE: Original Issuer Discount
No - it's 8% off $100. it's always off face value/principal.

Think of the $25 as amortization of debt financing fees that we talked about in class.
Thus, it's added as an asset and amortized over the 5 yrs pro-rata. Go straight to our lbo or super adv m&a model for the proper treatment.
Go to post added 11 years ago
RE: Change in Net Working Capital
The rationale is quite simple - since you are trying to calculate the amount of cash, don't include it in working capital calculation, otherwise you are double counting. The whole point of FCFF in the DCF is to estimate the amount of cash the firm generates.
Go to post added 11 years ago
Re: UNINSTALL WST ADD-INS FROM EXCEL 2007
Go to Tools => Add-ins (Alt + T + I) and uncheck the WST macros in the Add-in dialog box. hit OK. WST is now uninstalled from the Add-In ribbon on top and the shortcuts de-activated. To completely remove the macros, hit Alt + T + I again, click on Browse and delete the actual macro file. Hit Canc... Read More
Go to post added 11 years ago
Re: Macro partially disabled
What version of Excel are you running? Excel 2000 (very old) will need a different set of macros that we no longer maintain. If on a new version of Excel (or anything after Excel 2000) then check to make sure you don't have other conflicting macros: Alt + T + I (for add-ins dialog box) or look in t... Read More
Go to post added 11 years ago
RE: Free Cash Flow Tax Adjustment for Depreciation
Keep in mind the bigger picture. You are using book depreciation because the difference between tax and ook depreciation can be thought of as a working capital change which is in change in working capital in fcff calculation. Although technically deferred tax liabilities (which is difference btwn bo... Read More
Go to post added 11 years ago
Re: Return On Equity (ROI)
This is classic CFA question.
You probably mean ROE not ROI.

Generally speaking, your return is measured by your growth rate and your retention rate. don't forget that d, the dividend payout ratio is simply dividends/earnings. thus when you do the math /algebra, you get ROE
Go to post added 11 years ago
Re: Advance Financial Modeling- Core Model Questions on CF
Generally speaking, you will go with the company's classification of working capital, as they know best what is inside each line item. This can clearly be ascertained by looking at their CFO on the Cash Flow Statement to see where they placed the items. THey are usually grouped together with some so... Read More
Go to post added 11 years ago
Re: Building models from scratch?
Yes, this course of ours: Excel Fundamentals for the Finance Professional has a module called "Capstone Model" that starts from a truly blank excel page. http://www.wstselfstudy.com/packagetech.htmlhttp://www.wstselfstudy.com/packagetech.html

For additional questions, please email us at info@wallst-training.com and one of our reps will get back to you asap.
Read More
Go to post added 11 years ago