Shopify Inc. (SHOP) quarterly balance sheet — complete assets, liabilities & equity history
| Total Current Assets | 6.19B | 8.3B | 8.7B | 8.02B | 7.45B | 7.25B | 6.54B | 6.4B | 6.44B | 6.28B | 6.16B | 5.91B |
| Cash & Short-Term Investments | 5.74B | 5.77B | 6.34B | 5.83B | 5.51B | 5.48B | 4.89B | 5.02B | 5.18B | 5.01B | 4.92B | 4.78B |
| Cash Only | 1.85B | 1.53B | 2.41B | 1.55B | 1.31B | 1.5B | 1.51B | 1.54B | 1.62B | 1.41B | 1.29B | 1.61B |
| Short-Term Investments | 3.9B | 4.23B | 3.93B | 4.29B | 4.21B | 3.98B | 3.39B | 3.48B | 3.55B | 3.6B | 3.63B | 3.17B |
| Accounts Receivable | 449M | 2.37B | 2.13B | 1.95B | 1.69B | 1.66B | 1.44B | 1.19B | 1.08B | 1.16B | 1.08B | 981M |
| Days Sales Outstanding | 40.02 | 56.33 | 65.96 | 61.8 | 63.76 | 50.55 | 55.91 | 50.57 | 54.64 | 47.97 | 55.34 | 50.66 |
| Inventory | 0 | 21M | 0 | 0 | 0 | 26M | 0 | 0 | 0 | 19M | 0 | 0 |
| Days Inventory Outstanding | - | 0.98 | - | - | - | 1.64 | - | - | - | 1.62 | - | - |
| Other Current Assets | 0 | 14M | 226.78M | 234.52M | 242M | 0 | 211M | 188M | 183M | 7M | 162M | 148M |
| Total Non-Current Assets | 1.48B | 6.89B | 6.33B | 6.57B | 5.96B | 6.67B | 5.79B | 4.94B | 4.67B | 5.02B | 4.3B | 3.79B |
| Property, Plant & Equipment | 138M | 141M | 144.86M | 143.32M | 151M | 140M | 143M | 144M | 148M | 147M | 124M | 170M |
| Fixed Asset Turnover | 22.72x | 25.69x | 19.74x | 18.21x | 16.22x | 19.87x | 15.07x | 14.01x | 12.62x | 15.82x | 11.66x | 5.20x |
| Goodwill | 491M | 491M | 490.52M | 492.09M | 491M | 452M | 452M | 449M | 427M | 427M | 427M | 427M |
| Intangible Assets | 28M | 30M | 32.97M | 36.08M | 39M | 22M | 24M | 26M | 25M | 29M | 33M | 26M |
| Long-Term Investments | 708M | 6.16B | 5.61B | 5.84B | 5.15B | 6B | 5.13B | 4.28B | 4.03B | 4.38B | 3.68B | 3.13B |
| Other Non-Current Assets | 0 | 39M | 22.98M | 28.06M | 23M | 21M | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Assets | 14.12B | 15.19B | 15.02B | 14.59B | 13.4B | 13.92B | 12.33B | 11.35B | 11.11B | 11.3B | 10.46B | 9.7B |
| Asset Turnover | 0.22x | 0.24x | 0.19x | 0.19x | 0.17x | 0.21x | 0.18x | 0.18x | 0.17x | 0.20x | 0.17x | 0.16x |
| Asset Growth % | 5.38% | 9.09% | 21.86% | 28.62% | 20.59% | 23.23% | 17.82% | 16.93% | 1.35% | 5.04% | -6.6% | -9.72% |
| Total Current Liabilities | 500M | 1.39B | 2.21B | 2.08B | 2.01B | 1.96B | 921M | 874M | 902M | 898M | 852M | 880M |
| Accounts Payable | 1.03B | 570M | 969.05M | 840.87M | 776M | 360M | 612M | 0 | 0 | 364M | 0 | 554M |
| Days Payables Outstanding | 44.37 | 35.77 | 57.3 | 53.39 | 42.92 | 30.62 | 53.93 | - | - | 30.95 | - | 57.68 |
| Short-Term Debt | 179M | 0 | 920M | 919M | 919M | 918M | 0 | 0 | 0 | 0 | 0 | 0 |
| Deferred Revenue (Current) | 321M | 300M | 299.71M | 298.66M | 295M | 283M | 290M | 298M | 296M | 302M | 304M | 310M |
| Other Current Liabilities | 0 | 169M | 3.08M | 2M | 0 | 112M | 998.42K | 559M | 589M | 58M | 533M | 0 |
| Current Ratio | 12.38x | 5.96x | 3.93x | 3.85x | 3.71x | 3.71x | 7.10x | 7.32x | 7.14x | 6.99x | 7.23x | 6.71x |
| Quick Ratio | 12.38x | 5.94x | 3.93x | 3.85x | 3.71x | 3.70x | 7.10x | 7.32x | 7.14x | 6.97x | 7.23x | 6.71x |
| Cash Conversion Cycle | - | 21.54 | - | - | - | 21.56 | - | - | - | 18.64 | - | - |
| Total Non-Current Liabilities | 1.12B | 324M | 314.69M | 359.8M | 340M | 410M | 1.29B | 1.3B | 1.32B | 1.33B | 1.33B | 1.36B |
| Long-Term Debt | 0 | 0 | 0 | 0 | 0 | 0 | 917M | 917M | 916M | 916M | 915M | 914M |
| Capital Lease Obligations | 163.54M | 171M | 176M | 200.45M | 200M | 190M | 206M | 203M | 212M | 217M | 192M | 204M |
| Deferred Tax Liabilities | 0 | 55M | 29M | 36.08M | 5M | 73M | 8M | 10M | 6M | 6M | 5M | 6M |
| Other Non-Current Liabilities | 1.12B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Liabilities | 1.62B | 1.72B | 2.53B | 2.44B | 2.35B | 2.37B | 2.21B | 2.17B | 2.22B | 2.23B | 2.18B | 2.24B |
| Total Debt | 179M | 188M | 1.11B | 1.14B | 1.14B | 1.13B | 1.14B | 1.14B | 1.15B | 1.15B | 1.12B | 1.13B |
| Net Debt | -1.67B | -1.35B | -1.3B | -403.9M | -171M | -372M | -366M | -404M | -478M | -263M | -165M | -477M |
| Debt / Equity | 0.01x | 0.01x | 0.09x | 0.09x | 0.10x | 0.10x | 0.11x | 0.12x | 0.13x | 0.13x | 0.14x | 0.15x |
| Debt / EBITDA | 0.47x | 0.29x | 3.18x | 3.82x | 5.39x | 2.38x | 3.92x | 4.53x | 11.93x | 3.85x | 8.31x | - |
| Net Debt / EBITDA | -4.37x | -2.11x | -3.70x | -1.35x | -0.81x | -0.79x | -1.26x | -1.61x | -4.98x | -0.88x | -1.22x | - |
| Interest Coverage | - | - | - | - | - | - | - | - | - | - | - | - |
| Total Equity | 12.5B | 13.47B | 12.5B | 12.15B | 11.05B | 11.56B | 10.12B | 9.17B | 8.89B | 9.07B | 8.28B | 7.46B |
| Equity Growth % | 13.12% | 16.57% | 23.53% | 32.48% | 24.27% | 27.49% | 22.14% | 22.9% | 5.16% | 10.04% | -4.71% | -14.39% |
| Book Value per Share | 9.59 | 10.32 | 9.52 | 9.28 | 8.53 | 8.93 | 7.77 | 7.06 | 6.91 | 6.99 | 6.39 | 5.83 |
| Total Shareholders' Equity | 12.5B | 13.47B | 12.5B | 12.15B | 11.05B | 11.56B | 10.12B | 9.17B | 8.89B | 9.07B | 8.28B | 7.46B |
| Common Stock | 9.97B | 10.38B | 10.11B | 10.01B | 9.83B | 9.63B | 9.47B | 9.37B | 9.28B | 9.2B | 9.1B | 9.02B |
| Retained Earnings | 2.29B | 2.86B | 2.11B | 1.86B | 947M | 1.63B | 336M | -492M | -663M | -390M | -1.05B | -1.76B |
| Treasury Stock | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Accumulated OCI | -4M | 1M | -999.02K | 5.01M | -6M | -10M | -1M | -5M | -4M | 4M | -6M | 4M |
| Minority Interest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |