Posts by: Guest 1

Re: Modeling 'Names' used in IB/PE - Question
Thanks to both of your replies! Now say I was to get into 'community' college, what is the one (1) subject I can take that introduces me to (and shows me) what analysts [or other lower entry positions in banking] know - yes, not do; KNOW! About me> Keep in mind that I'm a pretty smart guy when ... Read More
Go to post added 11 years ago
Accounting for Discontinued Ops on financial statements
Full Question: How do you typically account for Discontinued Operations in the BS, IS and CF? With regards to the BS: I am looking at the 3Q2006 results of WMT and reported the affect on the Cash & Equivalents and Current Assets of Discontined Operations, but have not detailed the affects on... Read More
Go to post added 11 years ago
Complex Trading Comps Analysis: Fair Value of Debt
Is it not more appropriate to use the fair Value of Debt (given in footnote 5 in F-15) versus the Book Value of Debt less Capital Leases Obligations as shown in the Video?

Thanks.
Go to post added 11 years ago
Inputting scheduled lease payments in the debt sweep
Full Question:
How should I input the scheduled lease payment in the page of debt sweep of your spreadsheet? Should I input the scheduled payment of each year and leave interest rate zero?
Go to post added 11 years ago
Re: Estimated Taxes
Thanks for the prompt response. So to break this down to absolute basics, I go to the income taxes footnote and look for the current Operating Loss Carry Forwards balance. If there is a positive (there is a pool of losses) then in my projections I reduced future/projected pretax income dollar ... Read More
Go to post added 11 years ago
Re: Distressed Credit Overview - Valuation questions
thanks for the clarification!
Go to post added 11 years ago
Re: Cannot FULLY use WSTMacros3.4.2.xla on Excel 2013
I guess the problem is coming due to format issues. Make the file .xlsx and enable macro in the file menu. Then you can download the WSTMacros3.4.2 (full version) from the site referred above. It should work automatically then.
Go to post added 11 years ago
Modeling out pension expenses on the cash flow statement
Full Question: I am building an IFRS full model on a UK company at the moment and need to ask soemthing regarding the Cash Flow statement. Would you include payments to the Company Pension Fund as a negative item in calculations for the Cash Flow from Operations ? It seems many of the sell side rep... Read More
Go to post added 11 years ago
Complex Trading Comps: Stock comp transition under 123(R)
Why didn't we include an adjustment for the stock comp charge upon transition to FAS 123(R)? F-28 states that compensation cost for 2005 includes $32 million ($20 million after tax) of costs related to the changes required by the adoption of 123(R). If we aren't adjusting for general non-cash st... Read More
Go to post added 11 years ago
Valuing a negative EPS and EBIT company
I'm currently valuing a company that is generating negative EPS for the next five years and at the same time generating negative tax effected EBIT. If I simply took the advanced financial model on WMT built by Hamilton in the video, using the DCF tab, I stick in a 6/7x EV/EBITDA multiple gives me a... Read More
Go to post added 11 years ago