DCF Example
Historical Year Ending December 31, Projected Year Ending December 31, Terminal
2003 2004 2005 2006 2007 2008 2009 2010
Sales $36,697.0 $41,397.0 $51,408.0 $61,689.6 $75,261.3 $93,324.0 $117,588.3 $150,513.0
EBITDA 1,868.0 1,931.0 4,725.0 5,843.5 8,634.3 12,573.0 18,193.7 26,298.2
Less: Depreciation (858.0) (817.0) (1,271.0) (2,015.1) (2,458.5) (3,048.5) (3,841.1) (4,916.6)
Less: Amortization 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
EBIT 1,010.0 1,114.0 3,454.0 3,828.3 6,175.8 9,524.4 14,352.6 21,381.5
Less: Taxes @ 40.0% (404.0) (445.6) (1,381.6) (1,531.3) (2,470.3) (3,809.8) (5,741.0) (8,552.6)
Tax-effected EBIT 606.0 668.4 2,072.4 2,297.0 3,705.5 5,714.7 8,611.5 12,828.9
Plus: Depreciation 2,015.1 2,458.5 3,048.5 3,841.1 4,916.6
Plus: Amortization of Intangibles 0.0 0.0 0.0 0.0 0.0
Less: Capital Expenditures (1,869.9) (2,281.2) (2,828.7) (3,564.2) (4,562.2)
Less: Additions to Intangibles 0.0 0.0 0.0 0.0 0.0
Less: Changes in Working Capital (916.8) 369.8 390.0 1,565.1 1,992.7
Unlevered Free Cash Flow $1,525.5 $4,252.5 $6,324.5 $10,453.5 $15,176.1
Sales Growth 20.0% 22.0% 24.0% 26.0% 28.0%
EBIT Margin 6.2% 8.2% 10.2% 12.2% 14.2%
ROE 11.1% 15.1% 19.2% 23.1% 26.6%