| Peer
Companies: | Royal dutch shell plc | Chevron | Conocophilipes | Exxon Mobile Corporation |
| Ticker | RDS.A | CVX | COP | XOM |
| PERIOD
ENDING | 12-31-2017 | 12-31-2017 | 12-31-2017 | 12-31-2017 |
| From Income
Statement and Balance Sheet |
| Balance Sheet |
| Total
assets | 407097 | 253806 | 73362 | 348691 |
| Total
liabilities | 209285 | 104487 | 42561 | 154191 |
| Net
book value | 197812 | 149319 | 30801 | 194500 |
| Average no. of shares
outsanding. | 4156.38 | 1,890.53 | 1221.038 | 4256 |
| Share price at year end | 27.79 | 125.19 | 54.89 | 83.64 |
| Book
value per share | 47.59 | 78.98 | 25.23 | 45.70 |
| Cash
& Cash equivalents | 20312 | 4813 | 6325 | 3177 |
| Minority
interest | 3456 | 1195 | 194 | 6812 |
| Long
term debts | 4428 | 33477 | 17128 | 24406 |
| Market
capitalization | 115505.8408 | 236675.951 | 67022.776 | 355971.84 |
| Enterprise
value | 103077.8408 | 266534.951 | 78019.776 | 384012.84 |
| EBIDTA | 48395 | 28877 | 11895 | 39168 |
|
|
|
|
|
| 0 |
|
|
|
|
|
|
|
| Income Statement |
| Net
income | 13435 | 9269 | 3559 | 19848 |
| Interest expenses | 4042 | 307 | 1245 | 601 |
| Depreciation | 26223 | 19349 | 9062 | 19893 |
| Income taxes | 4695 | -48 | -1971 | $ (1,174.00) |
| Earning per share | 1.58 | 4.88 | -0.7 | 4.63 |
| Sales | 305179 | 134674 | 29106 | 237162 |
83127,62,919 |
| sales per share | 73.42 | 71.24 | 23.84 | 55.72 |
41563,81,459.50 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Calculated
Multiples |
|
| EV/EBITDA
Multiple | 2.13 | 9.23 | 6.56 | 9.80 |
| P/E
Multiple | 52.21 | 16.90 | (117.84) | 17.82 |
| Market
to Book Multiple | 0.58 | 1.59 | 2.18 | 1.83 |
| Price/Revenue
Multiple | 0.38 | 1.76 | 2.30 | 1.50 |
|
| Your Company
Valuation |
| Exxon Mobile Corporation |
| Enterprise
Value based on EV/EBITDA multiple | $8,853 | $17,450 | $8,009 | $41,727 |
| Plus: Your Company Cash | 20312 | 4813 | 6325 | 3177 |
| Less: Your Company Interest-bearing debt | 4428 | 33477 | 17128 | 24406 |
| Total
Equity value based on EBITDA | $24,737 | ($11,214) | ($2,794) | $20,498 |
| VA
Shares Outstanding (millions) | 4156.38 | 1890.53 | 1221.04 | 4256.00 | – |
| Equity
value per share | $5.95 | ($5.93) | ($2.29) | $4.82 |
|
| Equity
value per share based on P/E multiple | $310.72 | ($100.27) | $269.67 | $85.81 |
| Total
Equity value based on P/E multiple | $12,91,480 | ($1,89,564) | $3,29,272 | $3,65,199 |
|
| Plus:
Your Company Interest-bearing debt | 4428 | 33477 | 17128 | 24406 |
| Less:
Your Company Cash and equivalents | 20312 | 4813 | 6325 | 3177 |
| Enterprise
value based on P/E multiple | $4,62,194 | $2,94,963 | ($9,43,784) | $7,43,423 |
|
| Equity
value per share based on MTB Ratio | $636.62 | ($1,489.17) | $114.22 | $2,266.69 |
| Total
Equity value based on MTB ratio | $14,444 | ($17,775) | ($6,080) | $37,515 |
|
| Plus:
Your Company Interest-bearing debt | 4428 | 33477 | 17128 | 24406 |
| Less:
Your Company Cash and equivalents | 20312 | 4813 | 6325 | 3177 |
| Enterprise
value based on MTB ratio | $5,169 | $4,67,527 | ($20,53,668) | $13,60,606 |
|
| Equity
value per share based on P/Revenue ratio | $2.25 | ($10.42) | ($0.99) | $3.21 |
| Total
Equity value based on P/Revenue ratio | $9,363 | ($19,708) | ($6,434) | $30,767 |
|
| Plus:
Your Company Interest-bearing debt | 4428 | 33477 | 17128 | 24406 |
| Less:
Your Company Cash and equivalents | 20312 | 4813 | 6325 | 3177 |
| Enterprise
value based on P/Revenue ratio | $3,351 | $30,666 | $18,442 | $62,631 |
