For company Exxon Mobil stock symbol XOM Liquidity (current ratio, quick ratio,

Question

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

Explanation / Answer

Find the excel file on below link which will help you.

https://ufile.io/x0e2h

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 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 Liquidity Ratio 2013-12 2014-12 2015-12 2016-12 2017-12 Cash 1 Current Ratio = CurrentAssets / Current Liabilities 0.826892 0.818622 0.789666 0.86939 0.815876 Cash and cash equivalents 4644 4616 3705 3657 3177 2 Quick Ratio = ( Cash and equivalents + receivables)/ current liabilities 0.526964 0.504773 0.436861 0.525862 0.49807 Total cash 4644 4616 3705 3657 3177 3 net working capital-to-sales ratio = (Current Assets - Current Liabilities)/ Sales -0.0295 -0.02975 -0.04375 -0.02846 -0.04485 Receivables 33152 28009 19875 21394 25597 Inventories 16135 16678 16245 15080 16992 Other current assets 5377 3607 2798 1285 1368 Operating performance ratio Total current assets 59308 52910 42623 41416 47134 Non-current assets 1 Days of Sales in Inventory = 365/ Inventoryturnover 17.71466 19.41963 28.73953 30.66475 34.03286 Property, plant and equipment 2 Days of Sales in Receivables = 365/ receivable turnover 28.75343 25.94051 27.9565 35.7206 39.39461 Gross property, plant and equipment 434517 446789 447337 453915 ` Accumulated Depreciation -190867 -194121 -195732 -209691 Profitability ratios Net property, plant and equipment 243650 252668 251605 244224 252630 1 Gross Profit Margin = Gross profit / sales 0.21002 0.204603 0.204911 0.178914 0.231589 Equity and other investments 36328 35239 34245 35102 39160 2 Operating profit margin = operating profit / sales 0.137156 0.131731 0.08585 0.038526 0.081274 Other long-term assets 7522 8676 8285 9572 9767 3 Net profit margin = Net profit / sales 0.077417 0.082516 0.062238 0.035863 0.083108 Total non-current assets 287500 296583 294135 288898 301557 Total assets 346808 349493 336758 330314 348691 Return on Investment ratios Liabilities and stockholders' equity 1 Basic Earning Power ratio = EBIT / Total assets 0.166432 0.148547 0.066151 0.025497 0.055278 Liabilities 2 ROA = Net Income / Total assets 0.093942 0.093049 0.047957 0.023735 0.056526 Current liabilities 3 ROE = Netincome/ Shareholder equity 0.187238 0.186469 0.094549 0.046855 0.105015 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

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.