Question

In: Accounting

For company Exxon Mobil stock symbol XOM Liquidity (current ratio, quick ratio, and net working capital-to-sales...

For company Exxon Mobil stock symbol XOM

Liquidity (current ratio, quick ratio, and net working capital-to-sales ratio)

Operating performance ratio (Days of Sales in Inventory, Days of Sales in Receivables), turnovers

Profitability ratios (Gross Profit Margin, Operating Profit Margin, Net Profit Margin)

Return on Investment ratios: (Basic Earning Power ratio, ROA, ROE)

You can find financial ratios for the company for the last 3-5 years in the Internet (www.morningstar.com)

a) Present the ratios as the table(s) in your project. Create graphs for some ratios on your choice over three years to show trends.

EXXON MOBIL CORP (XOM) CashFlowFlag INCOME STATEMENT
Fiscal year ends in December. USD in millions except per share data. 2013-12 2014-12 2015-12 2016-12 2017-12 TTM
Revenue 420836/ 394105/ 259488/ 218608/ 237162/ 261554
Cost of revenue 332452 313470 206316 179496 182238 200971
Gross profit 88384 80635 53172 39112 54924 60583
Costs and expenses
Sales, General and administrative 12877 12598 11501 10799 10956 11488
Interest expense 9 286 311 453 601 648
Other operating expenses 17787 16121 19394 19891 24693 26095
Total costs and expenses 30673 29005 31206 31143 36250 38231
Income before income taxes 57711 51630 21966 7969 18674 22352
Provision for income taxes 24263 18015 5415 -406 -1174 1089
Net income from continuing operations 33448 33615 16551 8375 19848 21263
Other -868 -1095 -401 -535 -138 -313
Net income 32580 32520 16150 7840 19710 20950
Net income available to common shareholders 32580 32520 16150 7840 19710 20950
Earnings per share
Basic 7.37 7.6 3.85 1.88 4.63 4.91
Diluted 7.37 7.6 3.85 1.88 4.63 4.91
Weighted average shares outstanding
Basic 4419 4282 4196 4177 4256 4269
Diluted 4419 4282 4196 4177 4256 4269
EBITDA 74902 69213 40325 30730 39168 42781
EXXON MOBIL CORP (XOM) CashFlowFlag BALANCE SHEET
Fiscal year ends in December. USD in millions except per share data. 2013-12 2014-12 2015-12 2016-12 2017-12
Assets
Current assets
Cash
Cash and cash equivalents 4644 4616 3705 3657 3177
Total cash 4644 4616 3705 3657 3177
Receivables 33152 28009 19875 21394 25597
Inventories 16135 16678 16245 15080 16992
Other current assets 5377 3607 2798 1285 1368
Total current assets 59308 52910 42623 41416 47134
Non-current assets
Property, plant and equipment
Gross property, plant and equipment 434517 446789 447337 453915
Accumulated Depreciation -190867 -194121 -195732 -209691
Net property, plant and equipment 243650 252668 251605 244224 252630
Equity and other investments 36328 35239 34245 35102 39160
Other long-term assets 7522 8676 8285 9572 9767
Total non-current assets 287500 296583 294135 288898 301557
Total assets 346808 349493 336758 330314 348691
Liabilities and stockholders' equity
Liabilities
Current liabilities
Accounts payable 30920 25286 18074 17801 21701
Short-term debt 15808 17468 18762 13830 17930
Income taxes payable 7831 4938 2802 2615 3045
Other current liabilities 17165 16941 14338 13392 15095
Total current liabilities 71724 64633 53976 47638 57771
Non-current liabilities
Long-term debt 6516 11278 18687 27707 23079
Capital leases 375 375 1238 1225 1327
Deferred taxes liabilities 40530 39230 36818 34041 26893
Pensions and other postretirement benefits 20646 25802 22647 20680 21132
Minority interest 6492 6665 5999 6505 6812
Other long-term liabilities 26522 27111 26582 25193 23989
Total non-current liabilities 101081 110461 111971 115351 103232
Total liabilities 172805 175094 165947 162989 161003
Stockholders' equity
Additional paid-in capital 10077 10792 11612 12157 14656
Retained earnings 387432 408384 412444 407831 414540
Treasury stock -212781 -225820 -229734 -230424 -225246
Accumulated other comprehensive income -10725 -18957 -23511 -22239 -16262
Total Stockholders' equity 174003 174399 170811 167325 187688
Total liabilities and stockholders' equity 346808 349493 336758 330314 348691

Solutions

Expert Solution

Formula sheet

A B C D E F G H I J
2
3 EXXON MOBIL CORP (XOM) CashFlowFlag INCOME STATEMENT
4 Fiscal year ends in December. USD in millions except per share data. 2013-12 2014-12 2015-12 2016-12 2017-12 TTM
5 Revenue 420836 394105 259488 218608 237162 261554
6 Cost of revenue 332452 313470 206316 179496 182238 200971
7 Gross profit 88384 80635 53172 39112 54924 60583
8 Costs and expenses
9 Sales, General and administrative 12877 12598 11501 10799 10956 11488
10 Interest expense 9 286 311 453 601 648
11 Other operating expenses 17787 16121 19394 19891 24693 26095
12 Total costs and expenses 30673 29005 31206 31143 36250 38231
13 Income before income taxes 57711 51630 21966 7969 18674 22352
14 Provision for income taxes 24263 18015 5415 -406 -1174 1089
15 Net income from continuing operations 33448 33615 16551 8375 19848 21263
16 Other -868 -1095 -401 -535 -138 -313
17 Net income 32580 32520 16150 7840 19710 20950
18 Net income available to common shareholders 32580 32520 16150 7840 19710 20950
19 Earnings per share
20 Basic 7.37 7.6 3.85 1.88 4.63 4.91
21 Diluted 7.37 7.6 3.85 1.88 4.63 4.91
22 Weighted average shares outstanding
23 Basic 4419 4282 4196 4177 4256 4269
24 Diluted 4419 4282 4196 4177 4256 4269
25 EBITDA 74902 69213 40325 30730 39168 42781
26
27 EXXON MOBIL CORP (XOM) CashFlowFlag BALANCE SHEET
28 Fiscal year ends in December. USD in millions except per share data. 2013-12 2014-12 2015-12 2016-12 2017-12
29 Assets
30 Current assets
31 Cash
32 Cash and cash equivalents 4644 4616 3705 3657 3177
33 Total cash 4644 4616 3705 3657 3177
34 Receivables 33152 28009 19875 21394 25597
35 Inventories 16135 16678 16245 15080 16992
36 Other current assets 5377 3607 2798 1285 1368
37 Total current assets 59308 52910 42623 41416 47134
38 Non-current assets
39 Property, plant and equipment
40 Gross property, plant and equipment 434517 446789 447337 453915
41 Accumulated Depreciation -190867 -194121 -195732 -209691
42 Net property, plant and equipment 243650 252668 251605 244224 252630
43 Equity and other investments 36328 35239 34245 35102 39160
44 Other long-term assets 7522 8676 8285 9572 9767
45 Total non-current assets 287500 296583 294135 288898 301557
46 Total assets 346808 349493 336758 330314 348691
47 Liabilities and stockholders' equity
48 Liabilities
49 Current liabilities
50 Accounts payable 30920 25286 18074 17801 21701
51 Short-term debt 15808 17468 18762 13830 17930
52 Income taxes payable 7831 4938 2802 2615 3045
53 Other current liabilities 17165 16941 14338 13392 15095
54 Total current liabilities 71724 64633 53976 47638 57771
55 Non-current liabilities
56 Long-term debt 6516 11278 18687 27707 23079
57 Capital leases 375 375 1238 1225 1327
58 Deferred taxes liabilities 40530 39230 36818 34041 26893
59 Pensions and other postretirement benefits 20646 25802 22647 20680 21132
60 Minority interest 6492 6665 5999 6505 6812
61 Other long-term liabilities 26522 27111 26582 25193 23989
62 Total non-current liabilities 101081 110461 111971 115351 103232
63 Total liabilities 172805 175094 165947 162989 161003
64 Stockholders' equity
65 Additional paid-in capital 10077 10792 11612 12157 14656
66 Retained earnings 387432 408384 412444 407831 414540
67 Treasury stock -212781 -225820 -229734 -230424 -225246
68 Accumulated other comprehensive income -10725 -18957 -23511 -22239 -16262
69 Total Stockholders' equity 174003 174399 170811 167325 187688
70 Total liabilities and stockholders' equity 346808 349493 336758 330314 348691
71
72 Liquidity Ratio 2013 2014 2015 2016 2017
73 Current Ratio (Current Assets / Current Liabilities) =E37/E54 =F37/F54 =G37/G54 =H37/H54
74 Quick Ratio ((Current Assets - Inventory) / Current Liabilities) =(E37-E35)/E54 =(F37-F35)/F54 =(G37-G35)/G54 =(H37-H35)/H54
75 Net Working Capital to Sales Ratio ((Current Assets - Current Liabilities)/ Sales) =(E37-E54)/E5 =(F37-F54)/F5 =(G37-G54)/G5 =(H37-H54)/H5
76
77 Operating Performance Ratio
78 Days Sales in Inventory (365*Average Inventory / Cost of Goods Sold) =365*AVERAGE(D35:E35)/E6 =365*AVERAGE(E35:F35)/F6 =365*AVERAGE(F35:G35)/G6 =365*AVERAGE(G35:H35)/H6
79 Days Sales in Receivables (365*Average Receivables /Credit Sales) =(365*AVERAGE(D34:E34)/E5) =(365*AVERAGE(E34:F34)/F5) =(365*AVERAGE(F34:G34)/G5) =(365*AVERAGE(G34:H34)/H5)
80
81 Profitability Ratio
82 Gross Profit Margin (Gross Profit / Sales) =E7/E5 =F7/F5 =G7/G5 =H7/H5
83 Operating Profit Margin (Operating Income / Sales) =(E7-E9-E11)/E5 =(F7-F9-F11)/F5 =(G7-G9-G11)/G5 =(H7-H9-H11)/H5
84 Net Profit Margin (Net Profit / Sales) =E17/E5 =F17/F5 =G17/G5 =H17/H5
85
86 Return on investment ratio
87 Basic Earning Power Ratio (EBIT / Total Assets) =(E7-E9-E11)/E46 =(F7-F9-F11)/F46 =(G7-G9-G11)/G46 =(H7-H9-H11)/H46
88 ROA (Net Income /Average Assets) =E17/AVERAGE(D46:E46) =F17/AVERAGE(E46:F46) =G17/AVERAGE(F46:G46) =H17/AVERAGE(G46:H46)
89 ROE (Net Income / Average Shareholders' Equity) =E17/AVERAGE(D69:E69) =F17/AVERAGE(E69:F69) =G17/AVERAGE(F69:G69) =H17/AVERAGE(G69:H69)
90

ekkarill92 answered 7 months ago
Next > < Previous

Related Solutions

Obtain monthly adjusted close prices of Microsoft (symbol: MSFT) and Exxon Mobil Corporation (symbol: XOM) during...
Obtain monthly adjusted close prices of Microsoft (symbol: MSFT) and Exxon Mobil Corporation (symbol: XOM) during December 1989 – December 2019 from Yahoo Finance. Using Excel, compute monthly returns of each company during January 1990 – December 2019. Also, compute and report the arithmetic average and the standard deviation of each company’s returns. Compute and report the correlation coefficient between these two stock returns. Next, form a portfolio that combines Microsoft and Exxon Mobil Corporation with equal weight. Compute monthly...
On Sept 30th, 2011, Exxon Mobil (XOM) stock was traded at $72.63 while the December XOM...
On Sept 30th, 2011, Exxon Mobil (XOM) stock was traded at $72.63 while the December XOM put option with $75 exercise price is traded at $5.00 and the December XOM call option with $70 exercise price is traded at $5.60. The put option's delta is -0.65 and the call option's delta is 0.7. A) On October 3rd, XOM stock price changed to $71.15 on Oct 3rd, what will be the values of the put and call options? B) Consider a...
On Sept 30th, 2011, Exxon Mobil (XOM) stock was traded at $72.63 while the December XOM...
On Sept 30th, 2011, Exxon Mobil (XOM) stock was traded at $72.63 while the December XOM put option with $75 exercise price is traded at $5.00 and the December XOM call option with $70 exercise price is traded at $5.60. The put option's delta is -0.65 and the call option's delta is 0.7. A) On October 3rd, XOM stock price changed to $71.15 on Oct 3rd, what will be the values of the put and call options? B) Consider a...
On Sept 30th, 2011, Exxon Mobil (XOM) stock was traded at $72.63 while the December XOM...
On Sept 30th, 2011, Exxon Mobil (XOM) stock was traded at $72.63 while the December XOM put option with $75 exercise price is traded at $5.00 and the December XOM call option with $70 exercise price is traded at $5.60. The put option's delta is -0.65 and the call option's delta is 0.7. A) On October 3rd, XOM stock price changed to $71.15 on Oct 3rd, what will be the values of the put and call options? B) Consider a...
On Sept 30th, 2011, Exxon Mobil (XOM) stock was traded at $72.63 while the December XOM...
On Sept 30th, 2011, Exxon Mobil (XOM) stock was traded at $72.63 while the December XOM put option with $75 exercise price is traded at $5.00 and the December XOM call option with $70 exercise price is traded at $5.60. The put option's delta is -0.65 and the call option's delta is 0.7. A) On October 3rd, XOM stock price changed to $71.15 on Oct 3rd, what will be the values of the put and call options? B) Consider a...
Working with Yahoo!Finance. The Company that has been chosen Exxon Mobil Corp. (XOM) . Part A-Fundamental...
Working with Yahoo!Finance. The Company that has been chosen Exxon Mobil Corp. (XOM) . Part A-Fundamental Valuation: Estimate a growth rate for your firm's Dividends per Share. Assume a 12.5% discount rate. Calculate an estimated value of a share of the stock using the constant-growth model (Eq. 8-6 in the textbook), also known as the Gordon growth model. Compare and contrast your valuation results with the current share price in the market. Respond to this question: What changes in the...
Why a company with high current ratio and net working capital would still have a liquidity...
Why a company with high current ratio and net working capital would still have a liquidity problem and not able to cover daily routine expenses.
1.      Holmes Inc. has a quick ratio of 0.70, current liabilities of $21,500, net working capital...
1.      Holmes Inc. has a quick ratio of 0.70, current liabilities of $21,500, net working capital of $1200, and sales of $14,500. How much does it have in inventory? 2.      Watson Co. has net income of $235,000, a return on assets of 12.5%, and a debt-equity ratio of 0.52. What is its return on equity? 3.      Lestrade Plc. has net income of $16,000 and a profit margin of 8%. It also had costs (including depreciation) of $154,000 and a tax...
Both the current ratio and quick ratio are used to measure the liquidity of company. Explain...
Both the current ratio and quick ratio are used to measure the liquidity of company. Explain how the quick ratio overcomes the limitation of the current ratio. As a part of your answer discuss how the composition of current assets/liabilities impacts a firm’s liquidity position. (word limit 150)
Effect of Transactions on Working Capital, Current Ratio, and Quick Ratio The following account balances are...
Effect of Transactions on Working Capital, Current Ratio, and Quick Ratio The following account balances are taken from the records of Liquiform Inc.: Cash $ 70,000 Short-term investments 60,000 Accounts receivable 80,000 Inventory 100,000 Prepaid insurance 10,000 Accounts payable 75,000 Taxes payable 25,000 Salaries and wages payable 40,000 Short-term loans payable 60,000 Required: 1. Use the information provided to compute the amount of working capital and Liquiform's current and quick ratios (round to two decimal points). Working capital $ Current...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT