7.17. (Untitled - Intel Excel File

7.17. (Untitled - Intel Excel File - 10-year DCF Valuation...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
10-year DCF Valuation Model: Intel Corp. 1999 2000E 2001E 2002E 2003E 2004E 2005E 2006E 2007E 2008E 2009E Terminal Panel A – Inputs for Present Value Calculations 1. Net revenues* $29,389 $29,389 $29,389 $29,389 $29,389 $29,389 $29,389 $29,389 $29,389 $29,389 $29,389 2. Revenue growth rate 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 3. Net OI $9,417 $- $- $- $- $- $- $- $- $- $- 4. Cash tax rate 33.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 5. Income taxes 3,108 - - - - - - - - - - 6. NOPAT $6,309 $- $- $- $- $- $- $- $- $- $- 7. + Depreciation 3,186 - - - - - - - - - - 8. – Change in working capital (380) - - - - - - - - - - 9. – Capital expenditures 3,403 - - - - - - - - - - 10. – Change in other assets net - - - - - - - - - - - 11. Free cash flows $6,472 $- $- $- $- $- $- $- $- $- $- 12. WACC 2.76% 11.03% 11.03% 11.03% 11.03% 11.03% 11.03% 11.03% 11.03% 11.03% 13. Discount factor
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/04/2008 for the course ACCT 3320 taught by Professor Frankzhang during the Summer '06 term at University of Texas at Dallas, Richardson.

Ask a homework question - tutors are online