Posts by: Guest 1
simple data table question
I made a mistake in typing in a data table formula, and now excel won't let me undo it. How do you undo a data table? (In my case every cell now reads Yedar 1.) Thanks.
I made a mistake in typing in a data table formula, and now excel won't let me undo it. How do you undo a data table? (In my case every cell now reads Yedar 1.) Thanks.
Effective vs marginal tax rate for FCFF
I have taken the on-line courses (Advanced Fin model - core model and the enhancements) and I still have a doubt that you may be able to help me with: - Not specifically talking about our case (WMT) but: Should anyone use the effective tax rate to calculate the tax-effected EBIT when calculating... Read More
I have taken the on-line courses (Advanced Fin model - core model and the enhancements) and I still have a doubt that you may be able to help me with: - Not specifically talking about our case (WMT) but: Should anyone use the effective tax rate to calculate the tax-effected EBIT when calculating... Read More
WACC of a private company?
Hi WST, I understand that in calculating WACC, we should use the "market" value of equity and debt of an enterprise to derive the % of equity and debt weight. However, what happens if the enterprise is a private company; then, where can we obtain the proper % of equity and debt weight for the priva... Read More
Hi WST, I understand that in calculating WACC, we should use the "market" value of equity and debt of an enterprise to derive the % of equity and debt weight. However, what happens if the enterprise is a private company; then, where can we obtain the proper % of equity and debt weight for the priva... Read More
Dividends from Subsidiary
Hi there I just want to clarify dividends recording from Subsidiary. Suppose Holdco holds say 90% of Subsidiary while 10% is NCI. There are two cases now: 1) How to record dividends received from Subsidiary by Holdco in its all three statements while preparing stand alone financial statements o... Read More
Hi there I just want to clarify dividends recording from Subsidiary. Suppose Holdco holds say 90% of Subsidiary while 10% is NCI. There are two cases now: 1) How to record dividends received from Subsidiary by Holdco in its all three statements while preparing stand alone financial statements o... Read More
Other Income and Expense
I have a question regarding other income and other expense. Should these be placed below the line along with interest expense/income and capital leases or should it be placed on the very top just after net sales on the income statement? If other income/expenses should be placed below the line (EBI... Read More
I have a question regarding other income and other expense. Should these be placed below the line along with interest expense/income and capital leases or should it be placed on the very top just after net sales on the income statement? If other income/expenses should be placed below the line (EBI... Read More
Stock Based Compensation
I have some questions relating to stock based compensation expense. I am doing a valuation of a company using DCF and Comparable Company analyses and SBC expense has raised its ugly head. For our comparable company analysis, while all analysts seem to be submitting their EPS figures on a GAAP bas... Read More
I have some questions relating to stock based compensation expense. I am doing a valuation of a company using DCF and Comparable Company analyses and SBC expense has raised its ugly head. For our comparable company analysis, while all analysts seem to be submitting their EPS figures on a GAAP bas... Read More
Automated S&P Debt Rating
Hello, I noticed that the models we receive already has the automated S&P ratings for the debt ratios, would it be possible for you to let me know how we can actually implement this automation into excel? For example I want to receive the latest debt ratings ratios as of 2008 or 2009 but I'm n... Read More
Hello, I noticed that the models we receive already has the automated S&P ratings for the debt ratios, would it be possible for you to let me know how we can actually implement this automation into excel? For example I want to receive the latest debt ratings ratios as of 2008 or 2009 but I'm n... Read More
Re: Accounting for Discontinued Ops on financial statements
I am trying to out together a training package for BD professionals on discontinued operations, do you have any recommendations on where can I find some information? Purpose of package is not to be too technical or too deep into accounting guidelines but a high level overview of requirements, implic... Read More
I am trying to out together a training package for BD professionals on discontinued operations, do you have any recommendations on where can I find some information? Purpose of package is not to be too technical or too deep into accounting guidelines but a high level overview of requirements, implic... Read More
AD analysis left-field questions
I had a few side/random questions from the accretion dilution analysis. Finance ONLY purchase price equity (& NOT EV), as quick/dirty model/anal? In other words, I would think that financing would FUND EV (if there is debt, that debt would most likely be refinanced/ repaid/retired, or less co... Read More
I had a few side/random questions from the accretion dilution analysis. Finance ONLY purchase price equity (& NOT EV), as quick/dirty model/anal? In other words, I would think that financing would FUND EV (if there is debt, that debt would most likely be refinanced/ repaid/retired, or less co... Read More
I hate to sound naive, but I guess coming from the pure equity long/short world, I am! To review, you would recommend I take the Quick & Dirty LBO class, or might this be too simple? Secondly, "The only thing that's missing is the first payment - or the purchase price so to speak. Once ... I hate to sound naive, but I guess coming from the pure equity long/short world, I am! To review, you would recommend I take the Quick & Dirty LBO class, or might this be too simple?
Secondly,
"The only thing that's missing is the first payment - or the purchase price so to speak. Once you plop that in there (assume it's end of Year 0 cash flow), you have the core inputs for your IRR calculation, with additional adjustments to get to Equity Value and taking into account capital structure."
Would the "purchase price" simply be the investment? For example, if a private equity firm invested $5m, and when the company was sold its enterprise value was $300m and they owned 10% or $30m --- would be a simple IRR, with -5m and $30m being the inputs. Read More