6 Feb 2001, 14:01 UTC
Re: Fwd:Re: Home Depot case question(s)
- From
- Jeff Dasovich jeff.dasovich@enron.com
- To
- Mark Guinney
- Cc
- chin@haas.berkeley.edu, jdasovic@enron.com, Jeff Dasovich, sama@haas.berkeley.edu, vavrek@haas.berkeley.edu
- Bcc
- chin@haas.berkeley.edu, jdasovic@enron.com, Jeff Dasovich, sama@haas.berkeley.edu, vavrek@haas.berkeley.edu
- Date
- Tue, 6 Feb 2001 06:01:00 -0800 (PST)
Be happy to talk tonite about how to pull this together. Can't do it until 8:30-9PM tonite, though. That too late? And, if that's not enough, I don't have conferencing capability from home. Suggestions? Best, Jeff "Mark Guinney" <Mark_Guinney@watsonwyatt.com> 02/06/2001 10:22 AM To: "vavrek@haas.berkeley.edu" <vavrek@haas.berkeley.edu>, "sama@haas.berkeley.edu" <sama@haas.berkeley.edu>, "Jeff.Dasovich@enron.com" <Jeff.Dasovich@enron.com>, "jdasovic@enron.com" <jdasovic@enron.com>, "chin@haas.berkeley.edu" <chin@haas.berkeley.edu> cc: Subject: Fwd:Re: Home Depot case question(s) FYI- Tasker has approved my assumptions for the cash flow statement so we are free to answer the questions. ********************************************** Mark D. Guinney, CFA Consultant Watson Wyatt Investment Consulting 345 California Street, Ste. 1400 San Francisco, CA 94104 (415) 733-4487 ph. (415) 733-4190 fax ____________________Forward Header_____________________ Subject: Re: Home Depot case question(s) Author: tasker@haas.berkeley.edu (Sarah Tasker) Date: 02/06/2001 2:09 PM Mark - I apologize for the delay in responding. I had to fly back East due to a family illness and had problems accessing my email from there. Your assumptions are fine. As to your previous email, I think the additional B/S data on pp 9-47 and 9-48 gives you what you need for prior years. Hope that helps - sorry again for the delay! Sarah Tasker At 06:45 PM 2/4/01 -0500, you wrote:
Quoted or forwarded from earlier messages
>Professor Tasker: > >I've constructed a pro forma cash flow statement for the next fiscal year for >Home Depot. I wanted to solicit your input to see if I'm making some incorrect >assumptions. I've included my work in the attached spreadsheet (applicable work >is shaded in gray). The assumptions that I'm questioning are as followed: > >Instead of estimating net income I calculated EBIT; I did this since interest >expense is a variable that could change given financing needs undertaken >Taxes paid are difficult to calculate; I used previous years taxes from the >income statement and increase it by 30% (assumed growth rate); the tax credits >the company enjoyed from previous years are difficult to assume >At a minimum, I assumed that the company would have to pay for PPE on the order >of last year's depreciation plus 30%; I would consider this maintanence of >assets as opposed to purchase of new assets, construction, etc. >I calculated an additional PPE expense for 9 new stores and subtracted out the >$28 million in "construction in progress" from the previous year's balance sheet >(I assumed that this line item was construction for the new 9 sites) > >These are my main adjustments that I wanted to get some validation either way so >my group doesn't base our strategy and answers on incorrect assumptions. > > > >********************************************** >Mark D. Guinney, CFA >Consultant >Watson Wyatt Investment Consulting >345 California Street, Ste. 1400 >San Francisco, CA 94104 >(415) 733-4487 ph. >(415) 733-4190 fax >Attachment Converted: "c:\eudora\attach\HD.xls" > ---------------------------- Forwarded with Changes --------------------------- From: tasker@haas.berkeley.edu (Sarah Tasker) at Internet Date: 2/6/01 2:09PM -0500 To: Mark Guinney at ~WW_SFO Subject: Re: Home Depot case question(s) ------------------------------------------------------------------------------ -