Rockwell Automation, Inc. (ROK) quarterly balance sheet — complete assets, liabilities & equity history
| Total Current Assets | 4.08B | 3.69B | 3.91B | 3.91B | 3.77B | 3.75B | 3.88B | 3.92B | 4.11B | 4.14B | 4.91B | 4.4B |
| Cash & Short-Term Investments | 423M | 444M | 468M | 495M | 456M | 477M | 471M | 406.7M | 470.3M | 439.5M | 1.07B | 443.5M |
| Cash Only | 423M | 444M | 468M | 495M | 450M | 471M | 471M | 406.7M | 470.3M | 439.5M | 1.07B | 443.5M |
| Short-Term Investments | 0 | 0 | 0 | 0 | 6M | 6M | 0 | 300K | 200K | 0 | 0 | 0 |
| Accounts Receivable | 1.88B | 1.77B | 1.93B | 1.87B | 1.82B | 1.68B | 1.8B | 1.88B | 1.96B | 1.93B | 2.17B | 2.25B |
| Days Sales Outstanding | 73.48 | 80.94 | 75.44 | 78.25 | 78.56 | 84.99 | 83.1 | 85.08 | 83.36 | 91.96 | 79.2 | 87.28 |
| Inventory | 1.23B | 1.22B | 1.25B | 1.25B | 1.18B | 1.23B | 1.29B | 1.36B | 1.38B | 1.47B | 1.4B | 1.44B |
| Days Inventory Outstanding | 98.68 | 104.12 | 162.43 | 87.12 | 90.34 | 100.13 | 96.35 | 99.3 | 100.6 | 105.35 | 86.67 | 94.58 |
| Other Current Assets | 554M | 258M | 265M | 296M | 325M | 368M | 315.1M | 284.6M | 299M | 287.5M | 266.7M | 277.4M |
| Total Non-Current Assets | 7.17B | 7.54B | 7.31B | 7.28B | 7.22B | 7.2B | 7.35B | 7.27B | 7.25B | 7.2B | 6.39B | 7.34B |
| Property, Plant & Equipment | 836M | 362M | 1.2B | 1.15B | 1.15B | 1.15B | 1.2B | 1.14B | 1.12B | 1.06B | 1.03B | 972.2M |
| Fixed Asset Turnover | 3.74x | 2.70x | 1.97x | 1.87x | 1.74x | 1.60x | 1.74x | 1.81x | 1.95x | 1.96x | 2.56x | 2.33x |
| Goodwill | 3.84B | 3.85B | 3.84B | 4B | 3.94B | 3.92B | 3.99B | 3.95B | 3.96B | 3.97B | 3.53B | 3.7B |
| Intangible Assets | 744M | 775M | 864M | 966M | 992M | 1.03B | 1.07B | 1.1B | 1.14B | 1.19B | 852.4M | 883.1M |
| Long-Term Investments | 0 | 187M | 183M | 181M | 171M | 165M | 168.7M | 168.3M | 171.8M | 161.9M | 157.1M | 1B |
| Other Non-Current Assets | 1.18B | 1.76B | 626M | 435M | 419M | 405M | 406.3M | 387.4M | 377.5M | 361.5M | 361.6M | 423.1M |
| Total Assets | 11.26B | 11.23B | 11.22B | 11.19B | 10.99B | 10.94B | 11.23B | 11.19B | 11.37B | 11.33B | 11.3B | 11.74B |
| Asset Turnover | 0.20x | 0.19x | 0.21x | 0.19x | 0.18x | 0.17x | 0.18x | 0.18x | 0.19x | 0.18x | 0.22x | 0.19x |
| Asset Growth % | 2.39% | 2.61% | -0.12% | 0.04% | -3.29% | -3.44% | -0.64% | -4.72% | -0.89% | 1.65% | 5.07% | 8.74% |
| Total Current Liabilities | 3.75B | 3.45B | 3.44B | 3.69B | 3.58B | 3.48B | 3.6B | 3.79B | 3.7B | 3.31B | 3.37B | 3.92B |
| Accounts Payable | 833M | 774M | 930M | 840M | 766M | 789M | 860.4M | 844.2M | 903.2M | 935M | 1.15B | 1.01B |
| Days Payables Outstanding | 64.91 | 71.98 | 115 | 57.63 | 58.31 | 65.35 | 61.99 | 63.3 | 64.69 | 76.31 | 65.89 | 68.49 |
| Short-Term Debt | 1.12B | 915M | 610M | 848M | 1.11B | 1.05B | 1.08B | 1.12B | 1.09B | 511.3M | 103.3M | 886.8M |
| Deferred Revenue (Current) | 662M | 617M | 621M | 648M | 649M | 608M | 584.1M | 608.8M | 609.8M | 595.3M | 592.5M | 621.2M |
| Other Current Liabilities | 782M | 657M | 952M | 868M | 749M | 727M | 781.1M | 747.3M | 800.1M | 829M | 1.11B | 961M |
| Current Ratio | 1.09x | 1.07x | 1.14x | 1.06x | 1.05x | 1.08x | 1.08x | 1.04x | 1.11x | 1.25x | 1.46x | 1.12x |
| Quick Ratio | 0.76x | 0.72x | 0.77x | 0.72x | 0.72x | 0.72x | 0.72x | 0.68x | 0.74x | 0.80x | 1.04x | 0.76x |
| Cash Conversion Cycle | 107.25 | 113.09 | 122.86 | 107.74 | 110.58 | 119.76 | 117.46 | 121.08 | 119.27 | 121.01 | 99.97 | 113.36 |
| Total Non-Current Liabilities | 3.94B | 3.98B | 4.06B | 3.88B | 3.8B | 3.91B | 3.95B | 3.9B | 3.94B | 4.24B | 4.2B | 4.2B |
| Long-Term Debt | 2.57B | 2.86B | 2.61B | 2.62B | 2.57B | 2.56B | 2.56B | 2.56B | 2.58B | 2.86B | 2.86B | 2.87B |
| Capital Lease Obligations | 279M | 284M | 329M | 318M | 321M | 326M | 355.6M | 332.9M | 333.2M | 277.9M | 285.3M | 256.6M |
| Deferred Tax Liabilities | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Other Non-Current Liabilities | 1.08B | 836M | 1.12B | 940M | 915M | 1.02B | 1.04B | 1B | 1.02B | 1.09B | 1.05B | 1.08B |
| Total Liabilities | 7.68B | 7.43B | 7.51B | 7.57B | 7.39B | 7.39B | 7.56B | 7.69B | 7.65B | 7.55B | 7.56B | 8.12B |
| Total Debt | 3.97B | 4.06B | 3.65B | 3.88B | 4.09B | 4.03B | 4.08B | 4.11B | 4.09B | 3.74B | 3.33B | 4.09B |
| Net Debt | 3.54B | 3.61B | 3.18B | 3.38B | 3.64B | 3.56B | 3.61B | 3.7B | 3.62B | 3.3B | 2.26B | 3.65B |
| Debt / Equity | 1.11x | 1.07x | 0.98x | 1.07x | 1.14x | 1.13x | 1.11x | 1.17x | 1.10x | 0.99x | 0.89x | 1.13x |
| Debt / EBITDA | 8.66x | 9.12x | 6.72x | 8.26x | 9.61x | 9.59x | 11.19x | 11.04x | 9.91x | 10.46x | 5.83x | 8.75x |
| Net Debt / EBITDA | 7.74x | 8.12x | 5.85x | 7.21x | 8.55x | 8.47x | 9.90x | 9.95x | 8.77x | 9.23x | 3.95x | 7.80x |
| Interest Coverage | 12.72x | 11.69x | 2.70x | 9.55x | 8.87x | 6.61x | 7.67x | 7.22x | 8.75x | 8.88x | 11.24x | 15.08x |
| Total Equity | 3.58B | 3.8B | 3.71B | 3.63B | 3.6B | 3.56B | 3.68B | 3.5B | 3.72B | 3.79B | 3.74B | 3.62B |
| Equity Growth % | -0.8% | 6.86% | 0.97% | 3.56% | -3.14% | -6.1% | -1.82% | -3.28% | 8.34% | 18.32% | 24.09% | 34.87% |
| Book Value per Share | 31.76 | 33.60 | 32.84 | 32.11 | 31.82 | 31.33 | 32.32 | 30.88 | 32.42 | 32.87 | 32.38 | 31.33 |
| Total Shareholders' Equity | 3.52B | 3.75B | 3.65B | 3.46B | 3.44B | 3.38B | 3.5B | 3.33B | 3.54B | 3.61B | 3.56B | 3.34B |
| Common Stock | 141M | 141M | 141M | 141M | 141M | 141M | 181.4M | 181.4M | 181.4M | 181.4M | 181.4M | 181.4M |
| Retained Earnings | 5.77B | 5.57B | 5.42B | 5.28B | 5.29B | 5.18B | 9.63B | 9.4B | 9.45B | 9.33B | 9.26B | 8.95B |
| Treasury Stock | -4.08B | -3.64B | -3.54B | -3.48B | -3.38B | -3.27B | -7.73B | -7.62B | -7.47B | -7.28B | -7.19B | -7.14B |
| Accumulated OCI | -639M | -624M | -657M | -737M | -833M | -872M | -772.4M | -793.5M | -762M | -729.8M | -790.1M | -725.5M |
| Minority Interest | 54M | 54M | 57M | 165M | 166M | 171M | 176.9M | 177.7M | 178.4M | 179.4M | 181.8M | 279M |