Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Visit the Yahoo web site and click the link to Finance. Enter the letters XOM into the Quote Lookup box, and this will display the

Visit the Yahoo web site and click the link to Finance. Enter the letters "XOM" into the Quote Lookup box, and this will display the latest stock price, related stock data, and links to the financial statements for Exxon-Mobil Corporation ("XOM" is the stock symbol for this company). Using the available data, indicate the EPS and P/E ratios. Next, digging deeper into the financials, perform a horizontal analysis spanning the latest three years of data, specifically showing the trends (change over time) for earnings, inventory, the company's cash position, and also indicate the trend for the gross profit ratio and profit margin ratio. In addition, perform a vertical analysis over all of the asset classes listed on the Balance Sheet (as a proportion of the Total Assets). Summarize all of your findings, and be sure to display all calculations you've made in the process. Also provide conclusions regarding your assessment of what your analysis indicates about the current state of Exxon-Mobil.

ncome Statement

All numbers in thousands

Revenue 12/31/2017 12/31/2016 12/31/2015 12/31/2014
Total Revenue 238,883,000 201,626,000 241,406,000 364,763,000
Cost of Revenue 160,491,000 134,238,000 163,605,000 234,856,000
Gross Profit 78,392,000 67,388,000 77,801,000 129,907,000
Operating Expenses
Research Development - - - -
Selling General and Administrative 10,455,000 10,304,000 10,961,000 12,002,000
Non Recurring - - - -
Others 32,459,000 31,375,000 32,834,000 64,857,000
Total Operating Expenses 223,584,000 199,692,000 226,971,000 330,681,000
Operating Income or Loss 15,299,000 1,934,000 14,435,000 34,082,000
Income from Continuing Operations
Total Other Income/Expenses Net 3,375,000 6,035,000 7,531,000 17,548,000
Earnings Before Interest and Taxes 15,299,000 1,934,000 14,435,000 34,082,000
Interest Expense -601,000 -453,000 -311,000 -286,000
Income Before Tax 18,674,000 7,969,000 21,966,000 51,630,000
Income Tax Expense -1,174,000 -406,000 5,415,000 18,015,000
Minority Interest 6,812,000 6,505,000 5,999,000 6,665,000
Net Income From Continuing Ops 19,848,000 8,375,000 16,551,000 33,615,000
Non-recurring Events
Discontinued Operations - - - -
Extraordinary Items - - - -
Effect Of Accounting Changes - - - -
Other Items - - - -
Net Income
Net Income 19,710,000 7,840,000 16,150,000 32,520,000
Preferred Stock And Other Adjustments - - - -
Net Income Applicable To Common Shares 19,710,000 7,840,000 16,150,000

32,520,000

Annual

Quarterly

Balance Sheet

All numbers in thousands

Period Ending 12/31/2017 12/31/2016 12/31/2015 12/31/2014
Current Assets
Cash And Cash Equivalents 3,177,000 3,657,000 3,705,000 4,616,000
Short Term Investments - - - -
Net Receivables 25,597,000 21,394,000 19,875,000 28,009,000
Inventory 16,992,000 15,080,000 16,245,000 16,678,000
Other Current Assets 1,368,000 1,285,000 2,798,000 3,607,000
Total Current Assets 47,134,000 41,416,000 42,623,000 52,910,000
Long Term Investments 24,528,000 20,964,000 20,611,000 20,543,000
Property Plant and Equipment 252,630,000 244,224,000 251,605,000 252,668,000
Goodwill - - - -
Intangible Assets - - - -
Accumulated Amortization - - - -
Other Assets 24,399,000 23,710,000 21,919,000 23,372,000
Deferred Long Term Asset Charges 3,318,000 4,120,000 3,421,000 3,955,000
Total Assets 348,691,000 330,314,000 336,758,000 349,493,000
Current Liabilities
Accounts Payable 21,701,000 17,801,000 18,074,000 25,286,000
Short/Current Long Term Debt 42,336,000 42,762,000 38,687,000 29,121,000
Other Current Liabilities 14,829,000 13,354,000 14,203,000 18,589,000
Total Current Liabilities 57,771,000 47,638,000 53,976,000 64,633,000
Long Term Debt 23,079,000 27,707,000 18,687,000 11,278,000
Other Liabilities 72,014,000 79,914,000 86,047,000 92,143,000
Deferred Long Term Liability Charges - - - -
Minority Interest 6,812,000 6,505,000 5,999,000 6,665,000
Negative Goodwill - - - -
Total Liabilities 154,191,000 156,484,000 159,948,000 168,429,000
Stockholders' Equity
Misc. Stocks Options Warrants - - - -
Redeemable Preferred Stock - - - -
Preferred Stock - - - -
Common Stock 14,656,000 12,157,000 11,612,000 10,792,000
Retained Earnings 414,540,000 407,831,000 412,444,000 408,384,000
Treasury Stock -241,508,000 -252,663,000 -253,245,000 -244,777,000
Capital Surplus - - - -
Other Stockholder Equity -16,262,000 -22,239,000 -23,511,000 -18,957,000
Total Stockholder Equity 187,688,000 167,325,000 170,811,000 174,399,000
Net Tangible Assets 187,688,000 167,325,000 170,811,000 174,399,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Real Estate And Accounting For Beginners

Authors: Nespy Online Marketing

1st Edition

1802242880, 978-1802242881

More Books

Students also viewed these Accounting questions