In: Accounting
How would you do a ratio analysis for IBM for years 2016 and 2017?
Annual data for 2016- 2017
| For the year ended December 31: | 2017 (Doller) | 2016 (Doller) | 
| Revenue | 79,139 | 79,919 | 
| Income from continuing operations | 5758 | 11881 | 
| Loss from discontinued operations, net of tax | (5) | (9) | 
| Net income | 5753 | 11872 | 
| Operating (non-GAAP) earnings* | 12935 | 13031 | 
| Earnings/(loss) per share of common stock: | ||
| Assuming dilution: | ||
| Continuing operations | 6.14 | 12.39 | 
| Discontinued operations | 0.00 | (0.01) | 
| Total | 6.14 | 12.38 | 
| Basic: | ||
| Continuing operations | 6.17 | 12.44 | 
| Discontinued operations | 0.00 | (0.01) | 
| Total | 6.17 | 12.43 | 
| Diluted operating (non-GAAP)* | 13.80 | 13.59 | 
| Cash dividends paid on common stock | 5506 | 5256 | 
| Per share of common stock | 5.90 | 5.50 | 
| Investment in property, plant and equipment | 3229 | 3567 | 
| Return on IBM stockholders’ equity | 35.1% | 74.0% | 
| At december 31: | 2017 (Doller) | 2016 (Doller) | 
| Total Assets | 125,356 | 117,470 | 
| Net investment in property | 11,116 | 10,830 | 
| Working capital | 12,373 | 7613 | 
| Total Debt | 46,824 | 42,169 | 
| Total Equity | 17,725 | 18,392 | 
Ratio Analysis
1) Current ratio: Current Assets / Current Liability
2017 = 133%
2016 = 121%
2) Quick Ratio = Cash Equivalent+ Current Receivable+Short term investment / Current Liability
2017 = 129%
2016 = 117%
3) Cash Ratio=
2017 = 34%
2016 = 24%
4) Gross Margin ratio =
2017 = 46%
2016 = 48%
5) Operating margin ratio =
2017 = 15%
2016 =16%
6) Pre-tax margin ratio =
2017 = 14%
2016 = 15%
7) Profit margin ratio =
2017 = 7%
2016 = 15%
8) Pre-tax ROE =
2017 = 65%
2016 = 68%
9) After tax ROE =
2017 = 33%
2016 = 66%