Exxon Mobil Ratio Analysis PDF

Preview

Summary

Company analysis for professor roman g....

Description

FRL 3000 ExxonMobil Financial Statement Ratio Analysis 1.) Current Ratio = Current assets / Current liabilities 47,134 / 57,771 = 0.82 times 2.) Quick Ratio (Acid-test) = Current assets - Inventory / Current liabilities 47,134 - 16,992 / 57,771 = 0.52 times 3.) Cash Ratio = Cash / Current liabilities 3,177 / 57,771 = 0.05 times 4.) Net Working Capital to Total Assets = Net working capital / total assets 47,134 - 57,771 / 348,691 = -0.03 times 5.) Interval Measure = Current assets / Average daily operating costs 47,134 / (75,783 - 19,893) / 365 = 308 days 6.) Total Debt Ratio = Total assets - Total equity / Total assets 348,691 - 194,500 / 348,691 = 0.44 times 7.) Debt-Equity Ratio = Total debt / Total equity 24,406 / 194,500 = 0.13 times 8.) Equity Multiplier = Total assets / Total equity 348,691 / 194,500 = 1.79 times 9.) Long-Term Debt Ratio = Long-term debt / Long-term debt + Total equity 24,406 / 24,406 + 194,500 = 0.11 times 10.) Times Interest Earned Ratio = EBIT / Interest 18,674 / 601 = 31.07 times 11.) Cash Coverage Ratio = EBIT + Depreciation / Interest 18,674 + 19,893 / 601 = 64.17 times 12.) Inventory Turnover = N/A 13.) Day Sales in Inventory = N/A 14.) Receivables Turnover = Sales / A/R 237,162 / 47,134 = 5.03 times 15.) Days/ Sales in Receivables = 365 days / Receivable turnover 365 / 5.03 = 73 days 16.) NWC Turnover = Sales / NWC

237,162 / 47,134 - 57,771 = -22.30 times 17.) Fixed Asset Turnover = N/A 18.) Total Asset Turnover = Sales / Total assets 237,162 / 348,691 = 0.68 times 19.) Profit Margin = Net Income / Sales 19,710 / 237,162 = 0.083 or 8.3% 20.) Return on Assets = Net Income / Total Assets 19,710 / 348,691 = .056 or 5.6% 21.) Return on Equity = Net Income / Total Equity 19,710 / 194,500 = .1013 or 10.13% PE Ratio = N/A Market-to-book Ratio = N/A Enterprise Value = N/A EBITDA = N/A...