Part 2 Calculations - (30 points) Always use the most current years for ratios, horizontal and vertical analyses

3. Calculate ratios for the companies. The ratios should help you decide about the financial health of the company. Calculate two years of ratios for each company. See Attachment C for spreadsheet format Show the ratios on one table; show your calculations on a separate table) Again, one per company.

4. Perform a horizontal analysis for the companies on the Balance Sheet and the Income Statement. -- Show on two tables for each company. Note: you MUST use calculations in your spreadsheet for the % column. Do NOT type the answer in; it must be calculated using Excel formulas.

5. Perform a vertical analysis for these companies on the Balance Sheet and the Income Statement.-- Show on two tables for each company. Note: you MUST use calculations in your spreadsheet for the % column. Do NOT type the answer in; it must be calculated using Excel formulas.

Please note I need two sets of calculations for each company.

Compare and contrast the two companies. Which is a better investment based on this research and why?

Thank you!!

CONSOLIDATED BALANCE SHEET Note Reference Number Dec. 31 Dec. 31 2018 (millions of dollars) 2017 3,042 24,701 3,177 25,597 Assets Current assets Cash and cash equivalents Notes and accounts receivable, less estimated doubtful amounts Inventories Crude oil, products and merchandise Materials and supplies Other current assets Total current assets Investments, advances and long-term receivables Property, plant and equipment, at cost, less accumulated depreciation and depletion Other assets, including intangibles, net Total assets 14,803 4,155 1,272 47,973 40,790 12,871 4,121 1,368 47,134 39,160 247,101 10,332 346,196 252,630 9,767 348,691 Liabilities Current liabilities Notes and loans payable Accounts payable and accrued liabilities Income taxes payable Total current liabilities Long-term debt Postretirement benefits reserves Deferred income tax liabilities Long-term obligations to equity companies Other long-term obligations Total liabilities 17,258 37,268 2,612 57,138 20,538 20,272 27,244 4,382 18,094 147,668 17,930 36,796 3,045 57,771 24,406 21,132 26,893 4,774 19,215 154,191 Commitments and contingencies 15,258 421,653 (19,564) 14,656 414,540 (16,262) Equity Common stock without par value (9,000 million shares authorized, 8,019 million shares issued) Earnings reinvested Accumulated other comprehensive income Common stock held in treasury (3,782 million shares in 2018 and 3,780 million shares in 2017) ExxonMobil share of equity Noncontrolling interests Total equity Total liabilities and equity (225,553) 191,794 6,734 198,528 346,196 (225,246) 187,688 6,812 194,500 348,691 The information in the Notes to Consolidated Financial Statements is an integral part of these statements, CONSOLIDATED STATEMENT OF INCOME Note Reference Number 2018 2016 2017 (millions of dollars) 279,332 7,355 3,525 290,212 237,162 5,380 1.821 244,363 200,628 4,806 2,680 208,114 Revenues and other income Sales and other operating revenue Income from equity affiliates Other income Total revenues and other income Costs and other deductions Crude oil and product purchases Production and manufacturing expenses Selling, general and administrative expenses Depreciation and depletion Exploration expenses, including dry holes Non-service pension and postretirement benefit expense Interest expense Other taxes and duties Total costs and other deductions Income before income taxes Income taxes Net income including noncontrolling interests Net income attributable to noncontrolling interests Net income attributable to ExxonMobil 104,171 30,448 10,443 22,308 1,467 1,835 156,172 36,682 11,480 18,745 1,466 1,285 766 32,663 259,259 30,953 9,532 21,421 453 128,217 32,690 10,649 19,893 1,790 1,745 601 30,104 225,689 18,674 (1,174) 19,848 138 19,710 2 29,020 00,145 7,969 (406) 8,375 581 535 7,840 20,840 Earnings per common share (dollars) 4.88 4.63 1.88 Earnings per common share - assuming dilution (dollars) 12 4.88 4.63 1.88 The information in the Notes to Consolidated Financial Statements is an integral part of these statements