Financial Statement Analysis

profilebot2014
comparative_financial_analysis.xlsx
Home>Business & Finance homework help>Financial Statement Analysis

Ratio Analysis

RATIO ANALYSIS
ExxonMobil Current Year Prior Year 3 Years Ago 4 Years Ago 5 Years Ago
$ Percent $ Percent $ $ $
Income Statement
Revenue 377,635 100.0% 370,680 100.0% 298,035 246,738 204,506
Cost of Goods Sold 182,546 48.3% 185,219 50.0% 139,224
Interest Expense 654 0.2% 496 0.1% 638
Tax Expense 27,902 7.4% 23,302 6.3% 15,911
Income from Cont Operations
William R. Pasewark: Income from continuing operations is net income without the effects of any discontinued operations or extrordinary items. 		39,500 10.5% 36,130 9.7% 25,330 21,510 11,460
Net Income 39,500 10.5% 36,130 9.7%
Balance Sheet
Cash 32,848 15.0% 33,275 16.0% 23,135
Short Term Investments 0 0.0% 0 0.0% 0
Accounts Receivable 28,942 13.2% 27,484 13.2% 25,359
Inventory 8,979 4.1% 7,852 3.8% 8,136
Current Assets 75,777 34.6% 73,342 35.2% 60,377
Long Term Investments 23,237 10.6% 20,592 9.9%
Net Fixed Assets 113,687 51.9% 107,010 51.4%
Other Assets 6,314 2.9% 7,391 3.5%
Total Assets 219,015 100.0% 208,335 100.0% 195,256
Current Liabilities 48,817 22.3% 46,307 22.2% 42,981
Total Liabilities 105,171 48.0% 97,149 46.6% 93,500
Total Stockholders' Equity 113,844 52.0% 111,186 53.4% 101,756
Cash Flow
Cash Flow from Operations 49,286 48,138 40,551
Dividends Paid 7,628 7,185 6,896
Interest Paid 1,382 473 328
Share Information
Market Price at Year End 76.63 56.24 51.13
Earnings Per Share - Basic 6.62 5.71 3.91
Shares Outstanding 5,970 6,322 6,482
RATIO ANALYSIS
Growth Ratios
Sales Growth 1.9% 24.4%
Income Growth 9.3% 42.6%
Asset Growth 5.1% 6.7%
Activity Ratios
Receivable Turnover 13.4 14.0
Inventory Turnover 21.7 23.2
Fixed Asset Turnover 3.3 3.5
Profitability Ratios
Profit Margin 10.5% 9.7%
Return on Assets 18.5% 17.9%
Return on Equity 35.1% 33.9%
Dividend Payout Ratio 19.3% 19.9%
Price Earnings Ratio 11.6 9.8
Liquidity Ratios
Current Ratio 1.55 1.58
Quick Ratio 1.27 1.31
Solvency Ratios
Debt to Total Assets 0.48 0.47
Times Interest Earned (Accrual) 104.06 120.82
Times Interest Earned (Cash) 36.66 102.77
© 2008 William R. Pasewark

Competitor Analysis

PRIMARY COMPETITOR ANALYSIS
Your Company 1 2 3 4
$ $ $ $ $
Income Statement
Revenue 377,635 210,118 210,118 210,118 210,118
Cost of Goods Sold 182,546 128,151 128,151 128,151 128,151
Interest Expense 654 451 451 451 451
Tax Expense 27,902 14,838 14,838 14,838 14,838
Income from Cont Op 39,500 17,138 17,138 17,138 17,138
Net Income 39,500 17,138 17,138 17,138 17,138
Prior Year Revenue 370,680 198,200 198,200 198,200 198,200
Prior Year Income from Continuing Operations 36,130 14,099 14,099 14,099 14,099
Balance Sheet
Cash 32,848 10,493 10,493 10,493 10,493
Short Term Investments 0 953 953 953 953
Accounts Receivable 28,942 17,628 17,628 17,628 17,628
Inventory 8,979 4,656 4,656 4,656 4,656
Current Assets 75,777 36,304 36,304 36,304 36,304
Long Term Investments 23,237 18,552 18,552 18,552 18,552
Net Fixed Assets 113,687 137,747 137,747 137,747 137,747
Other Assets 6,314 8,914 8,914 8,914 8,914
Total Assets 219,015 132,628 132,628 132,628 132,628
Current Liabilities 48,817 28,409 28,409 28,409 28,409
Total Liabilities 105,171 63,693 63,693 63,693 63,693
Total Stockholders' Equity 113,844 68,935 68,935 68,935 68,935
Prior Year Accounts Receivable 27,484 17,184 17,184 17,184 17,184
Prior Year Inventory 7,852 4,121 4,121 4,121 4,121
Prior Year Assets 208,335 125,833 125,833 125,833 125,833
Prior Year Liabilities 97,149 63,157 63,157 63,157 63,157
Prior Year Stockholders' Equity 111,186 62,676 62,676 62,676 62,676
Cash Flow
Cash Flow from Operations 49,286 24,323 24,323 24,323 24,323
Dividends Paid 7,628 4,396 4,396 4,396 4,396
Interest Paid 1,382 470 470 470 470
RATIO ANALYSIS
Income Statement Common Size Data
Gross Profit/Sales 51.7% 39.0% 39.0% 39.0% 39.0%
Income from Continuing Operations/Sales 10.5% 8.2% 8.2% 8.2% 8.2%
Balance Sheet Common-Size Data
Current Assets/Total Assets 34.6% 27.4% 27.4% 27.4% 27.4%
Current Liabilities/Total Assets 22.3% 21.4% 21.4% 21.4% 21.4%
Liabilities/Total Assets 48.0% 48.0% 48.0% 48.0% 48.0%
Equity/Total Assets 52.0% 52.0% 52.0% 52.0% 52.0%
Profitabilty Ratios
Profit Margin 10.5% 8.2% 8.2% 8.2% 8.2%
Return on Assets 18.5% 13.3% 13.3% 13.3% 13.3%
Return on Equity 35.1% 26.0% 26.0% 26.0% 26.0%
Dividend Payout Ratio 19.3% 25.7% 25.7% 25.7% 25.7%
Liquidity Ratios
Current Ratio 1.55 1.28 1.28 1.28 1.28
Quick Ratio 1.27 1.02 1.02 1.02 1.02
Solvency Ratios
Liabilities/Total Assets 0.48 0.48 0.48 0.48 0.48
Times Interest Earned (Accrual) 104.06 71.90 71.90 71.90 71.90
Operational Ratios
Receivable Turnover 13.4 12.1 12.1 12.1 12.1
Inventory Turnover 21.7 29.2 29.2 29.2 29.2
© 2008 William R. Pasewark