Posts by: Guest 1
Re: The Financial Modeling Process
What you are saying makes sense to me. However, the difficulty I am having with the CFS results from the value of Net Income that is necessary to arrive at the CFO. In order to correctly compute CFO, Net Income has to equal 11,837. However, due to the fact that Interest Income and Interest Expense a... Read More
What you are saying makes sense to me. However, the difficulty I am having with the CFS results from the value of Net Income that is necessary to arrive at the CFO. In order to correctly compute CFO, Net Income has to equal 11,837. However, due to the fact that Interest Income and Interest Expense a... Read More
DCF analysis: net debt should be actual not est
Package 3 Advanced Financial Modeling DCF Analysis Regarding the debt & cash calcs, I believe cell A42 footnote (in the excel template) should say 1/31/2006 (= Actual 2005) – if so, is this a typo? Currently, the footnote states 1/31/2005 (= Actual 2004). In the 2005 diluted shares calc,... Read More
Package 3 Advanced Financial Modeling DCF Analysis Regarding the debt & cash calcs, I believe cell A42 footnote (in the excel template) should say 1/31/2006 (= Actual 2005) – if so, is this a typo? Currently, the footnote states 1/31/2005 (= Actual 2004). In the 2005 diluted shares calc,... Read More
General Inquiry
I have recently subscribed to a few of Wall Street Training's online modules and have found them very useful. I have also downloaded the keystroke shortcuts macro which I have found to be very useful as well. My only question is that the dollar and number formats traditionally used at my company a... Read More
I have recently subscribed to a few of Wall Street Training's online modules and have found them very useful. I have also downloaded the keystroke shortcuts macro which I have found to be very useful as well. My only question is that the dollar and number formats traditionally used at my company a... Read More
WMT's Net Revenue
Hi there,
In WMT's case, why didn't we adjust WMT's Net Revenue down to reflect the US$1.5 billion non-recurring / non-core foreign exchange income due to favorable FX conditions in FY2006?
Cheers
Hi there,
In WMT's case, why didn't we adjust WMT's Net Revenue down to reflect the US$1.5 billion non-recurring / non-core foreign exchange income due to favorable FX conditions in FY2006?
Cheers
Seg/rev build up questions
I (noticed and) believe that Segment (Revenue) Buildup videos are provided/shown twice in Package 3 (which are basically the same), for the repetition learning process / and also module-video organization nature? Also regarding the Segment Build videos, I believe Net International Sales = Internati... Read More
I (noticed and) believe that Segment (Revenue) Buildup videos are provided/shown twice in Package 3 (which are basically the same), for the repetition learning process / and also module-video organization nature? Also regarding the Segment Build videos, I believe Net International Sales = Internati... Read More
Tax rate
Hi, one simple question here: why didn't we use the statutory tax rate of 35% (according to 10K p. F-18) when calculating the after-tax impact of the LIFO-FIFO adj.? Is there any specific reason or circumstance? And why assumes 40%?
Thanks.
Hi, one simple question here: why didn't we use the statutory tax rate of 35% (according to 10K p. F-18) when calculating the after-tax impact of the LIFO-FIFO adj.? Is there any specific reason or circumstance? And why assumes 40%?
Thanks.
Factoring subsidies into WACC
Hello, A company I'm valuing gets a significant portion of its financing via government cash grants. Let's assume they normally spend $150m in capex annually with a 70/30 leverage ratio. With the cash grant, they'd get a 30% rebate off of their capital cost. So now their out-of-pocket capex is $1... Read More
Hello, A company I'm valuing gets a significant portion of its financing via government cash grants. Let's assume they normally spend $150m in capex annually with a 70/30 leverage ratio. With the cash grant, they'd get a 30% rebate off of their capital cost. So now their out-of-pocket capex is $1... Read More
NOL cap (due to M&A) affects "ALL FUTURE" NOLs?
In the tax schedule excel worksheet, NOL Used to Shelter Income (cell g13) formula takes the NOL cap per year if there is a change of control forward forever. So it appears that this “cap” affects all future (ending NOL) balances (and not just the acquired/historical target NOL portion)? Also i... Read More
In the tax schedule excel worksheet, NOL Used to Shelter Income (cell g13) formula takes the NOL cap per year if there is a change of control forward forever. So it appears that this “cap” affects all future (ending NOL) balances (and not just the acquired/historical target NOL portion)? Also i... Read More
Re: Macro partially disabled
I have been having the exact same issue with the Bloomberg add in. Was there a solution that was worked out?
I have been having the exact same issue with the Bloomberg add in. Was there a solution that was worked out?
Hi, one quick question on calendarization: when calendarizing financials, should we match all other comparables year endings to our client / focus company (in this case, WMT) or adjust all companies in the model (inclusive of our client / focus company) to a December year ending (irrespective of our... Hi, one quick question on calendarization: when calendarizing financials, should we match all other comparables year endings to our client / focus company (in this case, WMT) or adjust all companies in the model (inclusive of our client / focus company) to a December year ending (irrespective of our client / focus company year ending)? And if it doesn't matter at all, which approach is commonly used in the marketplace?
Thanks. Read More