SPREADSHEETSBEALENERGY(1)

SPREADSHEETSBEALENERGY(1) - Analyst: Brandon Beal...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Analyst: Brandon Beal Transocean LTD. (RIG) Annual Earnings Model, FY 2005-2011 (Figures in Millions, Except Per-Share Data) 2011 % Sales 2010 % Sales 2009 % Sales Revenue ### 100.0% 7.0% 9,591.48 100.0% -17.0% 100.0% Cost of Good Sold ### 44.0% 7.0% ### 44.0% -16.1% 43.5% (205.26) 2.0% 7.0% (191.83) 2.0% -8.2% (209.00) 1.8% 5,541.96 54.0% 7.0% 5,179.40 54.0% -18.0% 6,315.00 54.6% ### 12.0% 7.0% ### 12.0% -21.4% 12.7% Non-Operating Income/Expense 102.63 1.0% 7.0% 95.91 1.0% -54.3% 210.00 1.8% Special Items (923.66) 9.0% 7.0% (863.23) 9.0% 83.3% (471.00) 4.1% EBIT 3,489.38 34.0% 7.0% 3,261.10 34.0% -29.0% 4,590.00 39.7% Interest Expense (667.09) 6.5% 15.9% (575.49) 6.0% -13.6% (666.00) 5.8% Income Tax Rate 20.0% 0.0% 20.0% 4.1% 19.2% Income Taxes - Total (564.46) 5.5% 5.1% (537.12) 5.6% -28.8% (754.00) 6.5% 2,257.83 22.0% 5.1% 2,148.49 22.4% -32.5% 3,181.00 27.5% Net Income 2,257.83 22.0% 5.1% 2,148.49 22.4% -32.5% 3,181.00 27.5% EPS - Diluted 7.03 5.1% 6.69 -32.0% 9.84 Shares - for Diluted EPS Calc. 321.00 0.00% 321.00 0.00% 321.00 Dividends (Cash) per Share 0.00 0.00 0.00 5.47 EPS - Diluted 4th Q 1.22 Consensus EPS - Diluted 6.90 6.15% 6.50 Consensus EPS - Diluted 4th Q Estimate 1.03 EPS = Analyst Est. - Consensus Es 0.13 0.19 Oper. Activities - Net Cash Flow 4,971.58 48.4% 7.0% 4,646.34 48.4% -17.0% 5,598.00 48.4% Capital Expenditures 3,052.00 26.4% EPS 17.06% Net Incom 24.59% Revenue 27.10% Cash Flow 39.99% FISCAL YEAR (Ending 31DEC) % Change % Change 11,556.00 ) Expenses Operating Income (before depreciation) ) EPS - Diluted (Actual) Through 3 rd Q Assumptions = Blue 2010)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2008 % Sales 2007 % Sales 2006 % Sales 2005 -8.8% 100.0% 98.7% 6,377.00 100.0% 64.3% 3,882.00 100.0% 34.2% 2,891.70 -5.3% 41.9% 95.1% 42.7% 26.3% 55.5% 25.2% 8.3% (193.00) 1.5% 62.2% (119.00) 1.9% 32.2% (90.00) 2.3% 20.3% (74.80) -11.9% 7,170.00 56.6% 102.8% 3,536.00 55.4% 116.0% 1,637.00 42.2% 49.3% 1,096.30 5.3% 11.0% 178.6% (499.00) 7.8% 24.4% (401.00) 10.3% -1.2% (405.80) 26.5% 166.00 1.3% -59.3% 408.00 6.4% -18.7% 502.00 12.9% 667.6% 65.40 12.1% (420.00) 3.3% -324.6% 187.00 2.9% - 0.00 0.0% -100.0% 157.70 -16.9% 5,526.00 43.6% 52.1% 3,632.00 57.0% 109.0% 1,738.00 44.8% 90.2% 913.60 14.2% (583.00) 4.6% 135.1% (248.00) 3.9% 89.3% (131.00) 3.4% 17.8% (111.20) 27.8% 15.0% 101.1% 7.5% -45.9% 13.8% 27.7% 10.8% 1.5% (743.00) 5.9% 193.7% (253.00) 4.0% 14.0% (222.00) 5.7% 155.8% (86.80) -24.3% 4,202.00 33.2% 34.2% 3,131.00 49.1% 126.1% 1,385.00 35.7% 93.5% 715.60 -24.3% 4,202.00 33.2% 34.2% 3,131.00 49.1% 126.1% 1,385.00 35.7% 93.5% 715.60 -24.8% 13.09 -7.4% 14.14 131.1% 6.12 100.9% 3.04 0.00% 321.00 44.59% 222.00 -2.36% 227.37 -4.24% 237.44 0.00 47.21 0.00 0.00 12.9% 4,959.00 39.1% 61.4% 3,073.00 48.2% 148.4% 1,237.00 31.9% 43.1% 864.20 38.2% 2,208.00 17.4% 60.0% 1,380.00 21.6% 57.5% 876.00 22.6% 381.6% 181.90 % Change % Change % Change % Change 12,674.00 ) ) ) ) )
Background image of page 2
% Sales 100.0% 59.5% 2.6% 37.9% 14.0% 2.3% 5.5% 31.6% 3.8% 3.0% 24.7% 24.7% 29.9% 6.3%
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 25

SPREADSHEETSBEALENERGY(1) - Analyst: Brandon Beal...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online