ENERGYSECTORAPPENDIX

ENERGYSECTORAPPENDIX - Fundamental and DuPont Analysis Net...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: Fundamental and DuPont Analysis Net Income, Oil and Gas Prices, Rig Year S&P 500 E & S (101010) WTI Oil ($/barrel) 1999 50.33 7.32 3.1 7.69 19.34 2000 51.04 15.35 5.18 16.44 30.38 2001 24.78 13.47 7.52 14.3 25.98 2002 16.73 3.92-16.47 7.25 26.18 2003 50.41 16.73 0.71 19.54 31.08 2004 58.71 23.58 4.42 26.87 41.51 2005 72.34 37.65 18.49 41.35 56.64 2006 85.64 44.33 30.72 47.19 66.05 2007 70.34 45.92 42.39 46.76 72.34 2008 20.78 35.73 41.68 34.83 99.67 2009 55.14 15.97 20.21 15.37 61.95 Net Income, Oil and Gas Prices, Rig Count, an Year S&P 500 E & S (101010) WTI Oil ($/barrel) 2000 1% 110% 67% 114% 57% 2001-51%-12% 45%-13%-14% 2002-32%-71%-319%-49% 1% 2003 201% 327%-104% 170% 19% 2004 16% 41% 523% 38% 34% 2005 23% 60% 318% 54% 36% 2006 18% 18% 66% 14% 17% 2007-18% 4% 38%-1% 10% 2008-70%-22%-2%-26% 38% 2009 165%-55%-52%-56%-38% 2000 101% 210% 167% 214% 2001 49% 88% 145% 87% 2002 68% 29%-219% 51% 2003 301% 427%-4% 270% 2004 116% 141% 623% 138% 2005 123% 160% 418% 154% 2006 118% 118% 166% 114% 2007 82% 104% 138% 99% 2008 30% 78% 98% 74% 2009 265% 45% 48% 44% Energy (10) O, G & CF (101020) Energy (10) O, G & CF (101020) CAGR 0.92% 8.11% 20.62% 7.17% DuPont Analysis 10 Year Average: Energy (10 ROE = Net Profit Margin X Asset Turnover X Equity Multiplier ROE = Net Income/Sales X Sales/Assets X Assets/Equity ROE = 0.08 X 1.09 X 2.2 10 Year Averages Net Income Sales Assets 25.27 323.12 297.18 Sales Assets Equity 323.12 297.18 135.29 DuPont Analysis 10 Year Average: S & P 500 ROE = Net Profit Margin X Asset Turnover X Equity Multiplier ROE = Net Income/Sales X Sales/Assets X Assets/Equity ROE = 0.06 X 0.34 X 5.78 10 Year Averages Net Income Sales Assets 50.59 845.89 2452.47 Sales Assets Equity 845.89 2452.47 424.33 Count, and RGDP Year S&P 500 2.27 1457 31.18 10779.8 1999 679.48 4.31 1913 32.11 11226.0 2000 745.71 3.96 2242 31.9 11347.2 2001 736.89 3.36 1829 33.21 11553.0 2002 674.59 5.5 2174 37.33 11840.7 2003 710.81 5.91 2395 42 12263.8 2004 788.17 8.81 2746 45.43 12638.4 2005 874.31 6.74 3043 49.15 12976.2 2006 952.51 6.98 3116 55.39 13228.9 2007 1025.08 8.86 3336 61.22 13228.8 2008 1042.47 3.95 2304 57.94 12880.6 2009 908.4 d RGDP Percentage Change Net Sales World GDP Year S&P 500 90% 31% 3% 4% 2000 10%-8% 17%-1% 1% 2001-1%-15%-18% 4% 2% 2002-8% 64% 19% 12% 2% 2003 5% 7% 10% 13% 4% 2004 11% 49% 15% 8% 3% 2005 11%-23% 11% 8% 3% 2006 9% 4% 2% 13% 2% 2007 8% 27% 7% 11% 0% 2008 2%-55%-31%-5%-3% 2009-13% 103% 104% 99% 101% 104% 102% 112% 102% 113% 104% 108% 103% 108% 103% 113% 102% 111% 100% 95% 97% Henry Hub, LA (Dollars/million BTU) annual average Worldwide Rig Count (annual averages) World GDP (Constant Prices $ Trillions) RGDP (Billions of $) Henry Hub, LA (Dollars/million BTU) annual average Worldwide Rig Count (annual averages) RGDP (Billions of $) 6.39% 1.80% 0) = ROE = Net Income/Sales = 0.19 = ROE = Net Income/Sales = 0.12 Net Sales...
View Full Document

This note was uploaded on 04/26/2011 for the course BUSINESS A 00 taught by Professor Misc during the Spring '11 term at Saint Louis.

Page1 / 62

ENERGYSECTORAPPENDIX - Fundamental and DuPont Analysis Net...

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

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