57 054 04 6 057 079 051 007 009 026 09

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

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

Unformatted text preview: % 0.25% -0.22% 0.4 7% 0.37% -0.39 % 0.08% -0.58% 0.23% 0.39 % -1.37% -0.16 % 0.81% -0.56 % -0.52% 0.06 % 0.4 9 % 0.01% 0.27% -0.81% 0.37% -0.15% 0.4 2% -2.27% -0.27% 0.50% -0.4 1% 0.6 1% 0.35% 0.81% 0.4 8% -0.22% -0.58% -0.05% 0.14 % 0.01% 0.20% -0.34 % 0.52% -0.36 % 0.01% -0.24 % 1.14 % 0.6 0% -0.09 % 0.14 % 0.31% -0.22% -0.4 7% -0.4 1% -0.08% 0.09 % 0.6 8% 0.01% 0.4 3% -0.12% -0.11% 0.6 6 % 0.32% -0.26 % -0.57% 0.38% -0.05% -0.4 5% -0.10% 0.07% 0.33% 0.38% 0.26 % 0.02% -0.02% -0.25% 0.15% 0.29 % 0.4 1% -0.75% -0.22% -0.26 % -0.4 1% 0.6 4 % -0.35% 0.59 % -0.23% 0.74 % 0.03% 0.14 % 0.4 5% -1.19 % -1.16 % -0.14 % 0.27% 0.02% 0.6 7% 0.07% 0.02% 0.20% -0.4 5% -0.15% -0.03% -0.4 8% -0.22% 0.57% 1.16 % 0.08% 0.05% 0.12% 0.25% -0.34 % -0.10% -0.03% 0.01% 0.51% -0.26 % -0.31% -0.06 % 0.9 1% -0.02% 0.34 % 0.72% -0.4 6 % -0.82% -0.13% -0.4 7% 0.37% -0.4 7% 0.07% 0.9 2% 0.19 % -0.4 1% -0.6 1% 0.01% -0.4 0% -0.09 % 0.36 % 0.30% -0.11% 0.20% 0.08% 1.00% -0.20% -0.06 % 0.09 % 0.6 4 % 0.17% 0.50% 0.26 % -0.33% 0.22% -0.28% 0.4 5% 0.12% -0.09 % -0.16 % -0.20% D E T Kd Ke Beta Rf EMRP Ke WACC 4,115 Only including currently outstanding debt paying a coupon 417,470 As of Aug 1, 2013 41.96% From assumptions 2.90% Average of 3 longest-term YTMs 0.96 Used 10-years of data from Aug 1, 2013 2.83% 10-year bond yield as of Aug 1, 2013 5% 7.63% 7.57% DDM 1: Using 2012 Actual Results Dividend (2012) Ke g DDM Share O/S DDM/share 10,092.00 7.63% 1.53% 167,990.13 4,502.00 $37.31 XOM Closing Price October 25, 2013: 87.97 DDM 2: Alter DDM to reverse engineer XOM stock price Dividend (2012) Ke g DDM Share O/S DDM/share 10,092.00 7.63% 4.95% Solved for a g that gave us 87.97 for DDM/Share 395,747.04 4,502.00 $87.90 Exxon Mobil Corporation (NYSE:XOM) > My Exxon Mobil Corporation Quick Comp > Quick Comparable Analysis > Financial Data Details Template: Currency: As-Of Date: Company Comp Set Company Name BP plc (LSE:BP.) Chevron Corporation (NYSE:CVX) Royal Dutch Shell plc (ENXTAM:RDSA) Total SA (ENXTPA:FP) Exxon Mobil Corporation (NYSE:XOM) Summary Statistics High Low Mean Median Craig XOM Comps US Dollar Oct-27-2013 Day Close Price Latest 7.29 120.59 34.4 61.48 Shares Outstanding Latest 18,782.1 1,932.0 6,219.9 2,268.0 Market Capitalization Latest 136,923.9 232,982.8 218,239.0 139,432.1 FY2012 Net Income 11,582.0 26,179.0 26,592.0 14,749.3 FY2012 Total Equity 119,620.0 137,832.0 189,927.0 102,328.12 FY2012 Cash from Ops. 20,397.0 38,812.0 46,140.0 30,979.93 87.97 4,401.6 387,211.6 44,880.0 171,660.0 56,170.0 Day Close Price Latest 120.59 7.29 55.94 47.94 Shares Outstanding Latest 18,782.1 1,932.0 7,300.5 4,244.0 Market Capitalization Latest 232,982.8 136,923.9 181,894.5 178,835.6 FY2012 Net Income 26,592.0 11,582.0 19,775.6 20,464.2 FY2012 Total Equity 189,927.0 102,328.12 137,426.78 128,726.0 P/E P/B P/CFO FY2012 Cash from Ops. 46,140.0 20,397.0 34,082.23 34,895.97 Excel Comp Set ID: IQ248956363 All values in millions, except per share data and ratios. Values converted at...
View Full Document

This document was uploaded on 02/05/2014.

Ask a homework question - tutors are online